OpenCart 🇺🇦

$this->load->library('amazon');
if ($this->openbay->addonLoad('openstock')) {

	$rows = $this->db->query("
		SELECT `p`.`product_id`, `p`.`model`, `p`.`sku`, `pd`.`name` as `product_name`, '' as `var`, '' as `combi`, `p`.`has_option`
		FROM `" . DB_PREFIX . "product` as `p`
		LEFT JOIN `" . DB_PREFIX . "product_description` as `pd`
		ON `p`.`product_id` = `pd`.`product_id`
		AND `pd`.`language_id` = '" . (int)$this->config->get('config_language_id') . "'")->rows;

	$result = array();
	$this->load->model('openstock/openstock');
	$this->load->model('tool/image');
	foreach($rows as $row) {
		if ($row['has_option'] == 1) {
			$stockOpts = $this->model_openstock_openstock->getProductOptionStocks($row['product_id']);
			foreach($stockOpts as $opt) {
				if($this->productLinkExists($row['product_id'], $opt['var'])) {
					continue;
				}
				$row['var'] = $opt['var'];
				$row['combi'] = $opt['combi'];
				$row['sku'] = $opt['sku'];
				$result[] = $row;
			}
		} else {
			if(!$this->productLinkExists($row['product_id'], $row['var'])) {
				$result[] = $row;
			}
		}
	}
} else {
	$result = $this->db->query("
		SELECT `p`.`product_id`, `p`.`model`, `p`.`sku`, `pd`.`name` as `product_name`, '' as `var`, '' as `combi`
		FROM `" . DB_PREFIX . "product` as `p`
		LEFT JOIN `" . DB_PREFIX . "product_description` as `pd`
		ON `p`.`product_id` = `pd`.`product_id`
		LEFT JOIN `" . DB_PREFIX . "amazon_product_link` as `apl`
		ON `apl`.`product_id` = `p`.`product_id`
		WHERE `apl`.`amazon_sku` IS NULL
		AND `pd`.`language_id` = '" . (int)$this->config->get('config_language_id') . "'")->rows;
}

return $result;