Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Note for the following sql:
- // 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..
- // 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
- // change the reciepts.
- $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';");
- $db->query();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement