0) { //$Updatecart = mysql_query("UPDATE shop_cart_admin_demo_1 SET `session_id`='' "); $name=$_REQUEST['name']; $pincode=$_REQUEST['pincode']; $Query = "insert into tbl_job_new values( NULL,'". $pincode . "','". $name . "')"; //$Insert_Run_1 = mysql_query($Query) or die("Insert query error".mysql_error()); //$new_id = mysql_insert_id(); // echo 'foreign customers'; while($Fetitem = mysql_fetch_array($objitem)) { $menuid=$Fetitem['id']; $menuid_d_s=$Fetitem['productid']; $si=$si+1; $qty=$Fetitem['qty']; $pu_user_id=$_REQUEST['name']; $pu_session_id=$Fetitem['id']; $pu_productid=$Fetitem['productid']; $pu_qty=$Fetitem['qty']; $pu_price=$Fetitem['price']; $pu_totprice=$Fetitem['totprice']; date_default_timezone_set('Asia/Kolkata'); $date = date('Y-m-d H:i:s ', time()); $pu_country=$Fetitem['del_country']; $pu_state=$Fetitem['del_state']; $pu_address=$Fetitem['del_address']; $pu_pin=$Fetitem['del_inp']; $pu_city=$Fetitem['del_city']; $Query = "insert into shop_cart_admin_demo_1 values( NULL,'". $pu_user_id . "','". $browsessionid . "','". $new_id . "','". $pu_productid . "','". $pu_qty . "','". $pu_price . "','". $pu_totprice . "','" . $date . "','0','0','". $pu_country . "','". $pu_city . "','". $pu_state . "','" . $pu_address . "','" . $pu_pin."','0','0', '$url')"; // $Insert_Run_1 = mysql_query($Query) or die("Insert query error".mysql_error()); $country=addslashes($_REQUEST['country']); $name=addslashes($_REQUEST['name']); $state=addslashes($_REQUEST['state']); $pincode=addslashes($_REQUEST['pincode']); $mobileno=addslashes($_REQUEST['mobileno']); $address=addslashes($_REQUEST['address']); //$Updatecart = mysql_query("UPDATE shop_cart_admin_demo SET `del_country`='$country',`del_state`='$state',`del_address`='$address',`del_inp`='$pincode' where id='$menuid' "); /*$qty_p=""; $qty_p .="qty_"; $qty_p .=$menuid_d_s; $qty_p; $par=$_REQUEST[$qty_p]; if($par=='') { $qty=1; } if($par=='') { $qty=$par; }*/ $objmenu=mysql_query("SELECT * from shop_product where product_id='$menuid_d_s'"); $resmenu=mysql_fetch_array($objmenu); $menuname=$resmenu['name']; $productprice=$resmenu['price']; $productprice_int=$resmenu['price']; $totprice=($qty*$pu_price); $totprice_int=($qty*$pu_price); $new_price +=$totprice_int; if($country=="India") { //$Updatecart = mysql_query("UPDATE shop_cart_admin_demo SET `price`='$productprice',`totprice`='$totprice' where id='$menuid' "); } else { //$Updatecart = mysql_query("UPDATE shop_cart_admin_demo SET `price`='$productprice_int',`totprice`='$totprice_int' where id='$menuid' "); //$Updatecart = mysql_query("UPDATE tbl_confirmorder SET `contry`='$del_country',`city`='$del_city',`state`='$del_state',`address`='$del_address',`pin`='$del_inp' where orid='$attachmentfileid' "); } $vstatus=$resmenu['vstatus']; $weight=$resmenu['stock_status_id']; $vid_type = $resmenu['v_s']; if($vid_type !=1){ if($weight=='' || $weight==0) { $weight=100; } } else{ $weight = 0; } if($new_status==1) { if($vstatus==1) { $v_qty=($qty/2); } if($vstatus==6) { $v_qty=($qty/2); } if($vstatus==7) { $v_qty=($qty/2); } if($vstatus==2) { $v_qty=($qty/4); } $x = (int)$v_qty; } else { $x=0; } $x; $new_qty=($weight*($qty+$x)); $new_kilo=($new_qty/1000); $new_kilo_1 = explode('.',$new_kilo); $new_kilo_2=$new_kilo_1[0]; // Before the Decimal point $new_kilo_3 +=$new_kilo_2; $totprice1 +=$totprice; $tot_weight_2 +=$new_qty; $Query_job_move_product = mysql_query("SELECT * from shop_product_image where product_id='$menuid_d_s' order by product_id asc "); $row_job_move_product_id = mysql_fetch_array($Query_job_move_product); ?>

PRODUCT X QUANTITY	AMOUNT
x 0) { ?> 100) { ?>(100) { ?>+ Free 0) { $qtyfree=$x; } else { $qtyfree=$x; } ?> )	X
CART TOTAL
WEIGHT	= date(start_date) and '$adc_date'<=date(end_date)"); $set_adc = mysqli_fetch_array($get_adc, MYSQLI_ASSOC); $get_ship = mysqli_query($conn, "select * from shipping_charges where chart_id = '".$set_adc['id']."'"); while($sel_ship = mysqli_fetch_array($get_ship, MYSQLI_ASSOC)){ if($int_weight <= $sel_ship['weight']){ $tot_ship = $sel_ship['total']; break; } } }else{ $tot_ship = 0; } }elseif($need_shipping == 1){ $tot_ship = 0; }elseif($need_shipping == 2){ $tot_ship = $custom_charge; } ?> kg
PACKING & SHIPPING	0) { $courier_fees_country=$row_job_move_courier_country['amount']; $courier_fees_country_extra=$row_job_move_courier_country['additional_amount']; } else { $Query_job_move_courier_country= mysql_query("SELECT * from tbl_courier_charges_country where state='Others' "); $row_job_move_courier_country= mysql_fetch_array($Query_job_move_courier_country); $courier_fees_country=$row_job_move_courier_country['amount']; $courier_fees_country_extra=$row_job_move_courier_country['additional_amount']; } if($tot_weight_2_int<=500) { $courier_fees_country_1=$courier_fees_country; } else { $tot_weight_2_int_1=($tot_weight_2_int-500); $tot_weight_2_int_1_2=($tot_weight_2_int_1/250); $new_kilo_5_int = explode('.',$tot_weight_2_int_1_2); $new_kilo_6_int=$new_kilo_5_int[0]; $new_kilo_6_int_7=($new_kilo_6_int+1); $new_kilo_6_int_7_8=($courier_fees_country_extra*$new_kilo_6_int_7); $courier_fees_country_1=($courier_fees_country+$new_kilo_6_int_7_8); } if($need_shipping == 0){ if($int_weight!=0){ $get_adc = mysqli_query($conn, "select * from tbl_adc_courier_charges where '$adc_date' >= date(start_date) and '$adc_date'<=date(end_date)"); $set_adc = mysqli_fetch_array($get_adc, MYSQLI_ASSOC); $get_ship = mysqli_query($conn, "select * from shipping_charges where chart_id = '".$set_adc['id']."'"); while($sel_ship = mysqli_fetch_array($get_ship, MYSQLI_ASSOC)){ if($int_weight <= $sel_ship['weight']){ $tot_ship = $sel_ship['total']; break; } } }else{ $tot_ship = 0; } }elseif($need_shipping == 1){ $tot_ship = 0; }elseif($need_shipping == 2){ $tot_ship = $custom_charge; } ?>
OFFER@ %
ORDER TOTAL