Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.60 KB | None | 0 0
  1.             // Note for the following sql:
  2.             // There is no need to SUM() the numbers, there is only one line per product/size pair after the update of the bag, see the first lines of this function..
  3.             // This sql is to insert the products that the customer has ordered from the products table into a backup, so that changes to the price and similar does not
  4.             // change the reciepts.
  5.            
  6.             $db->setQuery("INSERT INTO #__shopper_orders_items SELECT p.*, $id, b.size_id, b.number FROM #__shopper_products AS p INNER JOIN #__shopper_bag As b ON p.id = b.product_id WHERE b.session = '$session_id';");
  7.             $db->query();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement