/** * This function is used for merging the cart data with session * * @return string */ function mergeSessionWithCartDatabase() { if (isset($_SESSION['mycart'])) { $product_array = $_SESSION['mycart']; $default = new Core_CAddCart(); $cartid = $default->getCartIdOfUser(); if ($cartid == 0 || $cartid == '') { $sql = "insert into shopping_cart_table (user_id , cart_date) values ('" . $_SESSION['user_id'] . "','" . date('Y-m-d') . "')"; $query = new Bin_Query(); $query->updateQuery($sql); } $cartid = $default->getCartIdOfUser(); $cartchecksql = "SELECT product_id FROM shopping_cart_products_table WHERE cart_id =" . $cartid; $cartchechqry = new Bin_Query(); if ($cartchechqry->executeQuery($cartchecksql)) { foreach ($cartchechqry->records as $records) { $cartproducts[] = $records['product_id']; } } else { $cartproducts = array(); } foreach ($_SESSION['mycart'] as $key => $val) { $sql = 'select soh from product_inventory_table where product_id=' . $val['product_id']; $query = new Bin_Query(); $query->executeQuery($sql); $soh = $query->records[0]['soh']; if ($val['qty'] <= $soh) { $sql_shipping = 'select shipping_cost from products_table where product_id=' . $val['product_id']; $query_shipping = new Bin_Query(); $query_shipping->executeQuery($sql_shipping); $shipmentcost = $query_shipping->records[0]['shipping_cost']; $shippingcost = $val['qty'][$i] * $shipmentcost; $date = date('Y-m-d'); $default_cls = new Core_CAddCart(); $msrp = $default_cls->getMsrpByQuantity($val['product_id'], $val['qty']); if ($msrp == '' || $msrp == 0) { $msrp_sql = "SELECT msrp FROM products_table WHERE product_id=" . $val['product_id']; $msrp_query = new Bin_Query(); $msrp_query->executeQuery($msrp_sql); $msrp = $msrp_query->records[0][msrp]; } $defobjj = new Core_CAddCart(); $groupdiscount = $defobjj->getUserGroupDiscount(); $msrp = $msrp - $msrp * ($groupdiscount / 100); if (in_array($val['product_id'], $cartproducts)) { $sql = "UPDATE shopping_cart_products_table SET product_qty=" . $val['qty'] . ",product_unit_price=" . $msrp . " where product_id=" . $val['product_id'] . " and cart_id=" . $cartid; } else { $sql = "INSERT INTO shopping_cart_products_table (cart_id,product_id,product_qty,date_added,product_unit_price,shipping_cost) VALUES (" . $cartid . "," . $val['product_id'] . "," . $val['qty'] . ",'" . $date . "'," . $msrp . "," . $shippingcost . ")"; } $query = new Bin_Query(); $query->executeQuery($sql); } } $_SESSION['mycart'] = ''; unset($_SESSION['mycart']); } }