Guest User

Untitled

a guest
Nov 15th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. 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 ) )
  2.  
  3. $cid = (int)$this->customer->getId();
  4. $pid = (int)$product_query->row['product_id'];
  5. $customer_new = $this->db->query("
  6. SELECT tb03.customer_id, tb01.product_id AS prod_id, sum(tb01.quantity) AS sum_quantity
  7. FROM oc_order_product AS tb01
  8. LEFT JOIN oc_order AS tb02 ON tb01.order_id = tb02.order_id
  9. LEFT JOIN oc_customer AS tb03 ON tb02.customer_id = tb03.customer_id
  10. WHERE tb03.customer_id = '{$cid}'
  11. GROUP BY tb03.customer_id, tb01.product_id
  12. ");
  13. $rows = $customer_new->rows;
  14. $ssd = array();
  15. foreach($rows as $index => $row){
  16. $ssd[] = array(
  17. 'prod_id' => $row['prod_id'],
  18. 'sum_quantity' => $row['sum_quantity']
  19. );
  20. }
  21.  
  22.  
  23.  
  24. print_r($ssd);
Add Comment
Please, Sign In to add comment