OpenCart Community

Code: Select all

public function getProductByModel($model, $manufacturers){

$query = $this->db->query("SELECT product_id FROM " . DB_PREFIX . "product WHERE model = '" . $this->db->escape($model) . "' AND manufacturer_id IN (" . implode(',', $manufacturers) . ") ORDER BY `date_available` DESC");

$result = $query->row;
if($result && count($result)>0){
$this->db->query("UPDATE " . DB_PREFIX . "product SET status = 0 WHERE model = '" . $this->db->escape($model) . "' AND manufacturer_id IN (" . implode(',', $manufacturers) . ") AND quantity < 1");
$this->db->query("UPDATE " . DB_PREFIX . "product SET status = 1 WHERE product_id = '" . $this->db->escape($result['product_id']) . "' AND quantity > 0");

$this->db->query("UPDATE " . DB_PREFIX . "relatedoptions SET quantity = 0 WHERE product_id = '" . $this->db->escape($result['product_id']) . "' AND store_stock = 0");
}

return $result;
}

Code: Select all

public function getProductByModel($model, $manufacturers){

$query = $this->db->query("SELECT product_id FROM " . DB_PREFIX . "product WHERE model = '" . $this->db->escape($model) . "' AND manufacturer_id IN (" . implode(',', $manufacturers) . ") ORDER BY `date_available` DESC");

$result = $query->row;

if($result && count($result) > 0){

$this->db->query("UPDATE " . DB_PREFIX . "product SET status = 1 WHERE product_id = '" . $this->db->escape($result['product_id']) . "' AND quantity > 0");

}

Code: Select all

public function updateProductStatus($products, $manufacturers, $filename){
	
if (count($products) > 0){

$this->db->query("UPDATE " . DB_PREFIX . "product SET status = 1 WHERE quantity > 0 AND manufacturer_id IN (" . implode(',', $manufacturers) . ") AND product_id IN (" . implode(',', $products) . ")");

} else {

$this->db->query("UPDATE " . DB_PREFIX . "product SET status = 0 WHERE manufacturer_id IN (" . implode(',', $manufacturers) . ") AND product_id NOT IN (" . implode(',', $products) . ")");	

}
	
}