Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Array ( [0] => Array ( [prod_id] => 40 [sum_quantity] => 10 ) [1] => Array ( [prod_id] => 46 [sum_quantity] => 1 ) [2] => Array ( [prod_id] => 47 [sum_quantity] => 7 ) [3] => Array ( [prod_id] => 48 [sum_quantity] => 4 ) ) Array ( [0] => Array ( [prod_id] => 40 [sum_quantity] => 10 ) [1] => Array ( [prod_id] => 46 [sum_quantity] => 1 ) [2] => Array ( [prod_id] => 47 [sum_quantity] => 7 ) [3] => Array ( [prod_id] => 48 [sum_quantity] => 4 ) ) Array ( [0] => Array ( [prod_id] => 40 [sum_quantity] => 10 ) [1] => Array ( [prod_id] => 46 [sum_quantity] => 1 ) [2] => Array ( [prod_id] => 47 [sum_quantity] => 7 ) [3] => Array ( [prod_id] => 48 [sum_quantity] => 4 ) )
- $cid = (int)$this->customer->getId();
- $pid = (int)$product_query->row['product_id'];
- $customer_new = $this->db->query("
- SELECT tb03.customer_id, tb01.product_id AS prod_id, sum(tb01.quantity) AS sum_quantity
- FROM oc_order_product AS tb01
- LEFT JOIN oc_order AS tb02 ON tb01.order_id = tb02.order_id
- LEFT JOIN oc_customer AS tb03 ON tb02.customer_id = tb03.customer_id
- WHERE tb03.customer_id = '{$cid}'
- GROUP BY tb03.customer_id, tb01.product_id
- ");
- $rows = $customer_new->rows;
- $ssd = array();
- foreach($rows as $index => $row){
- $ssd[] = array(
- 'prod_id' => $row['prod_id'],
- 'sum_quantity' => $row['sum_quantity']
- );
- }
- print_r($ssd);
Add Comment
Please, Sign In to add comment