0) { $date = date_default_timezone_set('Asia/Kolkata'); $dt2=date('Y-m-d H:i:s' ); $offer=addslashes($_POST['offer']); $Insert_memberord = "INSERT INTO tbl_confirmorder (`userid`,`intsessionid`,`orderid`,`refid`,`orderstatus`,`res_id`,`varstatus`,`order_date_time`,`order_tc_id`,`company_name`,`offer`) VALUES ('$sessionid_free','$browsessionid','$maxcorderid','$orderid_new_s','0','$ses_us','$payment_mode','$dt2','$checkboxValue_2','$company_name','$offer')"; $inexeord=mysql_query($Insert_memberord); $attachmentfileid = mysql_insert_id(); //$sessionid_free= addslashes($_POST['sessionid_free']); $Updatecart = mysql_query("UPDATE tbl_confirmorder SET `orderid`='$attachmentfileid' where orid='$attachmentfileid' "); $objRe = mysql_query("SELECT * from shop_cart_admin_demo where session_id='$browsessionid'"); $numrows_ma = mysql_num_rows($objRe); while($Fetchneword = mysql_fetch_array($objRe)) { $del_country=$Fetchneword['del_country']; $del_city=$Fetchneword['del_city']; $del_state=$Fetchneword['del_state']; $del_address=$Fetchneword['del_address']; $del_inp=$Fetchneword['del_inp']; "UPDATE tbl_confirmorder SET `contry`='$del_country',`city`='$del_city',`state`='$del_state',`address`='$del_address',`pin`='$del_inp' where orid='$attachmentfileid' "; $Updatecart = mysql_query("UPDATE tbl_confirmorder SET `contry`='$country',`city`='$city',`state`='$state',`address`='$address',`pin`='$pin' where orid='$attachmentfileid' "); $productid= $Fetchneword['productid']; $qty= $Fetchneword['qty']; $freeqty= $Fetchneword['qty_free']; $price= $Fetchneword['price']; $totprice= $Fetchneword['totprice']; $date = date_default_timezone_set('Asia/Kolkata'); $dt2=date('Y-m-d H:i:s' ); $Insert_member = "INSERT INTO tbl_order(`user_id`,`res_id`,`productid`,`qty`,`price`,`totprice`,`orderdate`,`type`,`session_id`,`ordertime`,`orderid`,`freeqty`) VALUES ('$sessionid_free','0','$productid','$qty','$price' ,'$totprice','$dt2','','$browsessionid','','$attachmentfileid','$freeqty')"; $inexe=mysql_query($Insert_member); } $Delete_Question = "DELETE FROM shop_cart_admin_demo WHERE `session_id`='$browsessionid'"; $Result_Question = mysql_query($Delete_Question); "SELECT * from shop_user where user_id='$sessionid_free_123' "; $objcorderid_n_user = mysql_query("SELECT * from shop_user where user_id='$sessionid_free_123' "); $nosnewcid_n_user=mysql_num_rows($objcorderid_n_user); $Fetcorderid_n_user = mysql_fetch_array($objcorderid_n_user); $new_status=$Fetcorderid_n_user['new_status']; $new_user_name=$Fetcorderid_n_user['email']; $objcorderid = mysql_query("SELECT * from tbl_confirmorder where orid='$attachmentfileid' "); $nosnewcid=mysql_num_rows($objcorderid); $Fetcorderid = mysql_fetch_array($objcorderid); $new_order_id=$Fetcorderid['orderid']; $new_order_id=$Fetcorderid['orderid']; $userid_new_userid=$Fetcorderid['userid']; $orderdate=$Fetcorderid['order_date_time']; $order_id=$Fetcorderid['refid']; $contry=$Fetcorderid['contry']; if($contry=="India") { $sym="Rs"; } else { $sym="$"; } $city=$Fetchneword['city']; $state=$Fetcorderid['state']; $address=$Fetchneword['address']; $pin=$Fetchneword['pin']; ?> mail query($objconfirmorder); $nss_con=mysql_num_rows($objconfirmorder); $manssss='0'; $rows_order = mysql_fetch_array($objconfirmorder); $orderid=$rows_order['orderid']; $res_id =$rows_order['res_id']; $type =$rows_order['type']; $datenew=$rows_order['deliverydate']; $userid =$rows_order['userid']; $orderstatus=$rows_order['orderstatus']; $state=$rows_order['state']; $contry=$rows_order['contry']; if($contry=="India") { $ss="Payumoney"; } else { $ss="Paypal"; } $courier_no=$rows_order['courier_no']; "SELECT * from `shop_user` where user_id='$userid' "; $Query = mysql_query("SELECT * from `shop_user` where user_id='$userid' "); //$name=$DB->query($Query); $no=mysql_num_rows($Query); $row = mysql_fetch_array($Query); $new_status=$row['new_status']; ?> mail 0) {} } header("location:order_confirm_admin.php?id=".$attachmentfileid); exit(); } ?>

Price given on


,
,
.
'; echo 'SEX :'.$_REQUEST['dgender'].'
'; } ?> MOBILE :
0) { while($Fetitem = mysql_fetch_array($objitem)) { $menuid=$Fetitem['id']; $menuid_d_s=$Fetitem['productid']; $si=$si+1; $qty=$Fetitem['qty']; /*$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['points']; $totprice=($qty*$resmenu['price']); $totprice_int=($qty*$resmenu['points']); $new_price +=$totprice_int; $country=addslashes($_REQUEST['country']); $name=addslashes($_REQUEST['name']); $state=addslashes($_REQUEST['state']); $pincode=addslashes($_REQUEST['pincode']); $mobileno=addslashes($_REQUEST['mobileno']); $address=addslashes($_REQUEST['address']); $name=addslashes($_REQUEST['name']); $name=addslashes($_REQUEST['name']); $city=addslashes($_REQUEST['city']); $Updatecart = mysql_query("UPDATE shop_cart_admin_demo SET `user_id`='$name',`del_country`='$country',`del_state`='$state',`del_city`='$city',`del_address`='$address',`del_inp`='$pincode' where id='$menuid' "); 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
    × 0) { ?> 100) { ?>(100) { ?>+ Free= )     X  x $
   CART TOTAL
   WEIGHT kg
   WEIGHT 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); } ?>    PACKING & SHIPPING
   OFFER@ %
   ORDER TOTAL (Incl. GST)

Please send a check to Store Name, Store Street, Store Town, Store State / County, Store Postcode.

Pay With PayuMoney.


Price given on


,

'; echo 'SEX :'.$_REQUEST['dgender'].'
'; } ?> MOBILE :
0) { while($Fetitem = mysql_fetch_array($objitem)) { $menuid=$Fetitem['id']; $menuid_d_s=$Fetitem['productid']; $si=$si+1; $qty=$Fetitem['qty']; $country=addslashes($_REQUEST['country']); $name=addslashes($_REQUEST['name']); $state=addslashes($_REQUEST['state']); $pincode=addslashes($_REQUEST['pincode']); $mobileno=addslashes($_REQUEST['mobileno']); $address=addslashes($_REQUEST['address']); $need_shipping = $_REQUEST['need_shipping']; $custom_charge = $_REQUEST['custom_charge']; $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*$resmenu['price']); $totprice_int=($qty*$resmenu['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_sataus==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; } ?> 0.5 ){ $no_of_units = ceil($int_weight/0.5); $courier_kirupa = $no_of_units * $get_adc['courier_500g']; $adc = $int_weight / 3.5; $split = ceil($adc); $tot_ship1 = $courier_kirupa + ($split * $get_adc['adc_3.5kg']); } // $tot_ship1 = $adc_charges + $calc_ship; // $Updatecart = "UPDATE shop_cart_admin_demo SET `qty_free`='$qtyfree' WHERE id='$menuid' "; $Updatecart = "UPDATE shop_cart_admin_demo SET `qty_free`='$tot_ship1 ' WHERE id='$menuid' "; $Recart = mysql_query($Updatecart); } ?>
)
    X
   CART TOTAL
   WEIGHT 0.5 ){ $no_of_units = ceil($int_weight/0.5); $courier_kirupa = $no_of_units * $get_adc['courier_500g']; $adc = $int_weight / 3.5; $split = ceil($adc); $tot_ship = $courier_kirupa + ($split * $get_adc['adc_3.5kg']); } ?> 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); } $adc_date = date('Y-m-d'); //mark here to change international shipping 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 

Please send a check to Store Name, Store Street, Store Town, Store State / County, Store Postcode.

0) { ?>

$_REQUEST['country'], 'name' => $_REQUEST['name'], 'state' => $_REQUEST['state'], 'pincode' => $_REQUEST['pincode'], 'mobileno' => $_REQUEST['mobileno'], 'address' => $_REQUEST['address'], 'city' => $_REQUEST['city'], 'need_shipping' => $_REQUEST['need_shipping'], 'custom_charge' => $_REQUEST['custom_charge'], 'discount' => $_REQUEST['discount'], 'dage' => $dage, 'dgender' => $dgender, 'notes' => $_REQUEST['notes'] ]); ?>    ' . $js_code . ''; } echo $js_code; } ?>
0 && $weight <=1){ $courier = $set_c['amount']; }elseif($weight > 1 && $weight <=2){ $courier = $set_c['amount'] *2; }elseif($weight > 2){ $extra = $weight - 2; $courier = ($set_c['amount'] * 2) + (ceil($extra) * $set_c['3_rd_kg']); } return $courier; } ?>