/** * This function is used to get cart snap sort * * * * @return array */ function cartSnapShot() { if ($_SESSION['user_id'] != '') { $userid = $_SESSION['user_id']; $query = new Bin_Query(); $sql = "SELECT pt.title,pt.model,pt.product_id,pt.brand,pt.shipping_cost,pt.sku,pt.msrp,pt.image,pt.thumb_image , shopping_cart_products_table. * , shopping_cart_table. * FROM (products_table pt INNER JOIN shopping_cart_products_table ON pt.product_id = shopping_cart_products_table.product_id) LEFT JOIN shopping_cart_table ON shopping_cart_products_table.cart_id = shopping_cart_table.cart_id WHERE shopping_cart_table.user_id =" . $userid; if ($query->executeQuery($sql)) { $cnt = count($query->records); $a = Core_CAddCart::showCart(); $output = Display_DAddCart::cartSnapShot($_SESSION['grandtotal'], $cnt); } else { $output = Display_DAddCart::cartSnapShotElse(); } } else { $cnt = count($_SESSION['mycart']); if ($cnt > 0) { $output = Display_DAddCart::cartSnapShot($_SESSION['grandtotal'], $cnt); } else { $output = Display_DAddCart::cartSnapShotElse(); } } return $output; }