query($Query);
$flag="sucess";
//header("location:order_details.php?id=".$id);
header("location:view_order.php");
}
}
?>
query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
if($status=="Confirmed")
{
date_default_timezone_set('Asia/Kolkata');
$date_ss = date('Y-m-d H:i:s ', time());
$Query="UPDATE `tbl_confirmorder` SET `deliverydate`='" .$date_ss. "',`orderstatus`='1' WHERE `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
if($status=="Packing")
{
date_default_timezone_set('Asia/Kolkata');
$date_ss = date('Y-m-d H:i:s ', time());
$Query="UPDATE `tbl_confirmorder` SET `orderstatus`='5' WHERE `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
if($status=="Dispatched")
{
$date_ss = date('Y-m-d H:i:s ', time());
$courier_no=trim(addslashes($_REQUEST['courier_no']));
$courier_status=trim(addslashes($_REQUEST['courier_status']));
$Query="UPDATE `tbl_confirmorder` SET `deliverytime`='" .$date_ss. "',`couriername`='" .$courier_status. "',`courier_no`='" .$courier_no. "' ,`orderstatus`='2' WHERE `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
if($status=="Delivered")
{
$date_ss = date('Y-m-d H:i:s ', time());
$courier_no=trim(addslashes($_REQUEST['courier_no']));
$courier_status=trim(addslashes($_REQUEST['courier_status']));
$Query="UPDATE `tbl_confirmorder` SET `delivery_time1`='" .$date_ss. "',`order_afterdate_time`='" .$date_ss. "',`orderstatus`='3',`couriername`='" .$courier_status. "',`courier_no`='" .$courier_no. "' WHERE `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
if($status=="Refund")
{
$date_ss = date('Y-m-d H:i:s ', time());
$Query="UPDATE `tbl_confirmorder` SET `refund_time`='" .$date_ss. "',`orderstatus`='4' WHERE `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
$flag="sucess";
// header("location:order_details.php?id=".$id);
}
}
?>
#11,2nd Street, Radha Nagar Extn.
Velachery,Chennai 600 042.
State :Tamilnadu Code:33
Phone:044-2253 1316
Email : drganbuganapathi@gmail.com
Website : www.drganbuganapathi.com
, - .
Mobile:
query($objqrynewsubee);
$Fetchnewww = mysql_fetch_array($name_12_123);
$subtotal_123=$Fetchnewww['amtTotal'];
?>
query($Query_job_move_courier);
$row_job_move_courier= mysql_fetch_array($name_12);
$courier_fees=$row_job_move_courier['amount'];
$courier_fees_para_1=$row_job_move_courier['amount'];
$packing_charges=round((($subtotal*10)/100));
$packing_charges123=0;
//$packing_charges123=round((($subtotal_123*10)/100));
if($contry!="India")
{
$packing_charges123=0;
$packing_charges=0;
}
if($orderid>'179')
{
$packing_charges123=round((($subtotal_123*10)/100));
if($contry!="India")
{
$packing_charges123=0;
$packing_charges=0;
}
if($state=="Puducherry")
{
$packing_charges=0;
$packing_charges123=0;
}
if($state=="Tamilnadu")
{
$packing_charges=0;
$packing_charges123=0;
}
if($state=="Puducherry")
{
$packing_charges123=0;
}
if($state=="Tamilnadu")
{
$packing_charges123=0;
}
}
if($courier_fees=='')
{
$Query_job_move_courier_1= "SELECT * from tbl_courier_charges where state='Others' ";
$name_12_w=$DB->query($Query_job_move_courier_1);
$row_job_move_courier_1= mysql_fetch_array($name_12_w);
$courier_fees=$row_job_move_courier_1['amount'];
$subtotal_123;
$packing_charges123=round((($subtotal_123*10)/100));
$packing_charges=round((($subtotal*10)/100));
$courier_fees=($courier_fees+$packing_charges);
}
$courier_fees;
if($contry=="India")
{
$new_kilo_4=(($new_kilo_6+1)*$courier_fees);
}
else
{
$tot_weight_2_int=$new_weight_2;
$Query_q= "SELECT * from tbl_courier_charges_country where state='$contry' ";
$Query_job_move_courier_country=$DB->query($Query_q);
$row_job_move_courier_country= mysql_fetch_array($Query_job_move_courier_country);
$num_max_ship_int=mysql_num_rows($Query_job_move_courier_country);
if($num_max_ship_int>0)
{
$courier_fees_country=$row_job_move_courier_country['amount'];
$courier_fees_country_extra=$row_job_move_courier_country['additional_amount'];
}
else
{
$Query_jo= "SELECT * from tbl_courier_charges_country where state='Others' ";
$Query_job_move_courier_country=$DB->query($Query_jo);
$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;
$new_kilo_4=$courier_fees_country_1;
}
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);
$new_kilo_4=$courier_fees_country_1;
}
}
$full_total_cm_ar=($subtotal+$new_kilo_4);
?>
#11,2nd Street, Radha Nagar Extn.
Velachery,Chennai 600 042.
State :Tamilnadu Code:33
Phone:044-2253 1316
Email : drganbuganapathi@gmail.com
Website : www.drganbuganapathi.com
, - .
Mobile:
GSTIN : 33ACMPA1286A2Z7
PAN : ACMPA1286A2Z7
Invoice No :
Invoice Date :
Payment Mode :
| S.No | Product Name | Weight/Nos. | Rate | Qty | Taxable Value | GST% | CGST | SGST | Total | |
| 0) { ?> + OFFER | % | |||||||||
| Total |
| Weight : | |
| Taxable Value : | |
| Total CGST : | |
| Total SGST : | |
| Shipping : | |
| Packing Charges : | |
|
Rupees only TOTAL : |
|
|
Rupees only TOTAL : |