window.open('login','_self')"; } $login_seller_user_name = $_SESSION['seller_user_name']; $select_login_seller = $db->select("sellers",array("seller_user_name" => $login_seller_user_name)); $row_login_seller = $select_login_seller->fetch(); $login_seller_id = $row_login_seller->seller_id; $get_payment_settings = $db->select("payment_settings"); $row_payment_settings = $get_payment_settings->fetch(); $total = 0; $select_cart = $db->select("cart",["seller_id" => $login_seller_id]); while($row_cart = $select_cart->fetch()){ $proposal_price = $row_cart->proposal_price; $proposal_qty = $row_cart->proposal_qty; $get_extras = $db->select("cart_extras",["seller_id"=>$login_seller_id,"proposal_id"=>$row_cart->proposal_id]); while($extra = $get_extras->fetch()){ $proposal_price += $extra->price; } $sub_total = $proposal_price * $proposal_qty; $total += $sub_total; } $processing_fee = processing_fee($total); $count_cart = $select_cart->rowCount(); if(isset($_GET['remove_proposal'])){ $proposal_id = $input->get('remove_proposal'); $delete_cart_proposal = $db->delete("cart",["proposal_id"=>$proposal_id,"seller_id"=>$login_seller_id]); $delete_cart_extras = $db->delete("cart_extras",["proposal_id"=>$proposal_id,"seller_id"=>$login_seller_id]); if($delete_cart_extras){ echo ""; } } ?> <?= $site_name; ?> - Cart
()
select("cart",array("seller_id"=>$login_seller_id)); while($row_cart = $select_cart->fetch()){ $proposal_id = $row_cart->proposal_id; $proposal_price = $row_cart->proposal_price; $proposal_qty = $row_cart->proposal_qty; @$video = $row_cart->video; $select_proposals = $db->select("proposals",array("proposal_id" => $proposal_id)); $row_proposals = $select_proposals->fetch(); $proposal_title = $row_proposals->proposal_title; $proposal_url = $row_proposals->proposal_url; $proposal_img1 = getImageUrl2("proposals","proposal_img1",$row_proposals->proposal_img1); $proposal_seller_id = $row_proposals->proposal_seller_id; $get_seller = $db->select("sellers",array("seller_id" => $proposal_seller_id)); $row_seller = $get_seller->fetch(); $proposal_seller_user_name = $row_seller->seller_user_name; $cart_extras = $db->select("cart_extras",array("seller_id"=>$login_seller_id,"proposal_id"=>$proposal_id)); ?>
    fetch()){ $name = $extra->name; $price = $extra->price; $proposal_price += $price; ?>
  • (+)

Your cart is empty

"; } ?>

post('code'); $select_coupon = $db->select("coupons",array("coupon_code"=>$coupon_code)); $count_coupon = $select_coupon->rowCount(); if($count_coupon == 1){ $row_coupon = $select_coupon->fetch(); $coupon_proposal = $row_coupon->proposal_id; $coupon_limit = $row_coupon->coupon_limit; $coupon_used = $row_coupon->coupon_used; $coupon_price = $row_coupon->coupon_price; $coupon_type = $row_coupon->coupon_type; if($coupon_limit <= $coupon_used){ $coupon_usage = "expired"; echo " "; }else{ $select_cart = $db->select("cart",array("proposal_id" => $coupon_proposal,"seller_id" => $login_seller_id,"coupon_used" => 0)); $count_cart = $select_cart->rowCount(); if($count_cart == 1){ $row_cart = $select_cart->fetch(); $proposal_price = $row_cart->proposal_price; if($coupon_type == "fixed_price"){ if($coupon_price > $proposal_price){ $coupon_price = 0; }else{ $coupon_price = $proposal_price-$coupon_price; } }else{ $numberToAdd = ($proposal_price / 100) * $coupon_price; $coupon_price = $proposal_price - $numberToAdd; $cart_extras = $db->select("cart_extras",array("seller_id"=>$login_seller_id,"proposal_id"=>$proposal_id)); } $update_coupon = $db->query("update coupons set coupon_used=coupon_used+1 where coupon_code=:c_code",array("c_code"=>$coupon_code)); $update_cart = $db->update("cart",array("proposal_price" => $coupon_price,"coupon_used" => 1),array("proposal_id" => $coupon_proposal,"seller_id" => $login_seller_id)); $coupon_usage = "used"; echo ""; }else{ $coupon_usage = "not_apply"; } } }else{ $coupon_usage = "not_valid"; } } ?>