query($Query);
$flag="sucess";
//header("location:order_details.php?id=".$id);
header("location:view_order.php");
}
}
?>
query($Query);
$si=0;
while ($rowsss = mysql_fetch_array($name_12_123_qty)) {
$si;
date_default_timezone_set('Asia/Kolkata');
$ne_1=$_REQUEST['from_date'];
$ne=strtotime($_REQUEST['from_date'][$si]);
$nameaa="";
$date_ss = date('Y-m-d H:i:s ', time());
$first_month_date=date("Y-m-d",$ne);
$y=date("Y",$ne);
$m=date("M",$ne);
$d=date("d",$ne);
$nameaa .="$d";
$nameaa .=" / ";
$nameaa .=" $m ";
$nameaa .=$y;
$nameaa;
$order_id=$rowsss['ordid'];
if($ne!="")
{
$Query="UPDATE `tbl_order` SET `batchno`='$nameaa' WHERE `ordid`='".$order_id."'";
$DB->query($Query);
}
$si=$si+1;}
$iyya=1;
}
}
?>
query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
}
?>
query($Query);
$ids=$_REQUEST['ids'];
header("location:view_packing.php?ids=".$ids);
}
if($status=="Verified")
{
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=="Returned")
{
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`='24', `returned_reason`= '$_POST[return_reason]' WHERE `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=15&retu=24");
}
if($status=="Unclaimed")
{
date_default_timezone_set('Asia/Kolkata');
$date_ss = date('Y-m-d H:i:s ', time());
$Query="UPDATE `tbl_confirmorder` SET `orderstatus`='25' where `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=15&retu=24");
}
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=="Ready to Dispatch")
{
date_default_timezone_set('Asia/Kolkata');
$date_ss = date('Y-m-d H:i:s ', time());
$Query="UPDATE `tbl_confirmorder` SET `orderstatus`='15' 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());
$dis_phone=$_REQUEST['dis_phone'];
//enter Mobile numbers comma seperated
$courier_no=trim(addslashes($_REQUEST['courier_no']));
$courier_status=trim(addslashes($_REQUEST['courier_status']));
$message = "Hi Shipment from Dr. G.ANBUGANAPATHI is dispatched through ".$courier_status.".Your Shipment no. is ".$courier_no.". ANBUDR"; //enter Your Message //enter Your Message //enter Your Message
$message = urlencode($message);
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=ANBUDR&Message='.$message.'&MobileNumbers='.$dis_phone.'&ApiKey=eYfIWFmiAMhbL6JDTfOb3kzGzQr+eimy6prshuD8qLo=&ClientId=b45d4e3d-cb26-4856-8cbf-93a02a7b9eeb',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'GET',
));
$response = curl_exec($curl);
curl_close($curl);
//$mobilenumbers1='$res_owner_mobile';
$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',d_stat='0' WHERE `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
if($status=="Own Delivery")
{
$date_ss = date('Y-m-d H:i:s ', time());
//$courier_no=trim(addslashes($_REQUEST['courier_no']));
//$courier_status=trim(addslashes($_REQUEST['courier_status']));
$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',d_stat='5' WHERE `orid`='".$_REQUEST['id']."'";
$DB->query($Query);
$ids=$_REQUEST['ids'];
header("location:view_order.php?ids=".$ids);
}
if($status=="Delivered-Confirmed by Call")
{
$date_ss = date('Y-m-d H:i:s ', time());
//$courier_no=trim(addslashes($_REQUEST['courier_no']));
//$courier_status=trim(addslashes($_REQUEST['courier_status']));
$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',d_stat='6' 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);
include '../../include/conf.php';
$id = $_GET['id'];
$get_qty = mysqli_query($conn, "select * from tbl_order where orderid = '$id'");
while($set_qty = mysqli_fetch_array($get_qty, MYSQLI_ASSOC)){
$product_id = $set_qty['productid'];
$qty = $set_qty['qty'];
$free_qty = $set_qty['freeqty'];
$revert_total = $qty + $free_qty;
$get_stock = mysqli_query($conn, "SELECT * FROM tbl_india_update_stock WHERE product_id = '$product_id' order by id desc limit 1");
$set_stock = mysqli_fetch_array($get_stock, MYSQLI_ASSOC);
$update_stock_count = $set_stock['current_stock'] + $revert_total;
mysqli_query($conn, "update tbl_india_update_stock set current_stock = '$update_stock_count' where product_id = '$product_id' and id = '".$set_stock['id']."'");
mysqli_query($conn, "delete from stock_log_entry where orderid = '$id' and product_id = '$product_id'");
}
header("location:view_order.php?ids=".$ids);
}
$flag="sucess";
// header("location:order_details.php?id=".$id);
}
}
?>
NO.8, 2ND STREET,
RADHA NAGAR EXTENSION,
VELACHERY, CHENNAI 600042
STATE: TAMILNADU CODE:33 MOBILE : 8939055088
drganbuganapathi@gmail.com
www.drganbuganapathi.com
-
AGE:
GST NO:.
GST NO:.
MOBILE: EMAIL :'.$row['email']; } ?>
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);
if($pundai_order_id>495)
{
$courier_fees=$row_job_move_courier['amount'];
$courier_fees_para_1=$row_job_move_courier['amount'];
$courier_fees_dealer = $row_job_move_courier['amount_dealer_2'];
}
else
{
if($curdate_mal_1<$curdate_mal_2)
{
$courier_fees=$row_job_move_courier['amount'];
$courier_fees_para_1=$row_job_move_courier['amount'];
if($state=="Puducherry")
{
$courier_fees=60;
$courier_fees_para_1=60;
}
if($state=="Tamilnadu")
{
$courier_fees=40;
$courier_fees_para_1=40;
}
if($state=="Andhra Pradesh")
{
$courier_fees=150;
$courier_fees_para_1=150;
}
if($state=="Karnataka")
{
$courier_fees=150;
$courier_fees_para_1=150;
}
if($state=="Kerala")
{
$courier_fees=150;
$courier_fees_para_1=150;
}
if($state=="Telangana")
{
$courier_fees=150;
$courier_fees_para_1=150;
}
}
else
{
if($state=="Puducherry")
{
$courier_fees=60;
$courier_fees_para_1=60;
}
if($state=="Tamilnadu")
{
$courier_fees=40;
$courier_fees_para_1=40;
}
if($state=="Andhra Pradesh")
{
$courier_fees=100;
$courier_fees_para_1=100;
}
if($state=="Karnataka")
{
$courier_fees=100;
$courier_fees_para_1=100;
}
if($state=="Kerala")
{
$courier_fees=100;
$courier_fees_para_1=100;
}
if($state=="Telangana")
{
$courier_fees=100;
$courier_fees_para_1=100;
}
if($state=="Puducherry")
{
$courier_fees=60;
$courier_fees_para_1=60;
}
}
}
$packing_charges=round((($subtotal*$kudhi)/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*$kudhi)/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=='')
{
$new_date_mal =$rows_order['order_date_time'];
$new_date_mal_1 = date("Y-m-d",strtotime($new_date_mal));
date_default_timezone_set('Asia/Kolkata');
$date_mal_1 = date('2020-10-06', time());
$curdate_mal_1 = strtotime($new_date_mal_1);
$curdate_mal_2 = strtotime($date_mal_1);
$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);
if($curdate_mal_1<$curdate_mal_2)
{
$courier_fees=300;
$courier_fees_dealer = 300;
}
else
{
$courier_fees=$row_job_move_courier_1['amount'];
$courier_fees_dealer = $row_job_move_courier_1['amount_dealer_2'];
}
$subtotal_123;
$packing_charges123=round((($subtotal_123*$kudhi)/100));
$packing_charges=round((($subtotal*$kudhi)/100));
$courier_fees=($courier_fees+$packing_charges);
$courier_fees_dealer = $courier_fees_dealer + $packing_charges;
}
$courier_fees;
$dealer_2=0;
// DEALER 2 & his users courier fees mark here
$get_ord = mysqli_query($conn, "SELECT * FROM tbl_confirmorder where orderid='$id'");
$set_ord = mysqli_fetch_assoc($get_ord);
$get_check_deal = mysqli_query($conn, "SELECT * FROM shop_user where user_id = '".$set_ord['userid']."' and new_status=2");
$my_check_rows = mysqli_num_rows($get_check_deal);
if($my_check_rows > 0){
$dealer_2=1;
}
$get_check_deal_1 = mysqli_query($conn, "SELECT * FROM shop_user where user_id = '".$set_ord['userid']."' and dealer_id !=''");
$my_check_rows = mysqli_num_rows($get_check_deal_1);
if($my_check_rows > 0){
$set_check_deal = mysqli_fetch_assoc($get_check_deal_1);
$get_luck = mysqli_query($conn, "SELECT * FROM shop_user where user_id = '".$set_check_deal['dealer_id']."' and new_status=2");
$my_check_rows_1 = mysqli_num_rows($get_luck);
if($my_check_rows_1 > 0){
$dealer_2=1;
}
}
// echo 'sugoi'.$dealer_2;
if($contry=="India" && $dealer_2 ==0)
{
$new_kilo_4=(($new_kilo_6+1)*$courier_fees);
}elseif($contry=="India" && $dealer_2 ==1){
$new_kilo_4=(($new_kilo_6+1)*$courier_fees_dealer);
}
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;
if($country_id==1)
{
$new_kilo_4=($courier_fees_country_1*75);
}
else
{
$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;
if($country_id==1)
{
$new_kilo_4=($courier_fees_country_1*75);
}
else
{
$new_kilo_4=$courier_fees_country_1;
}
}
}
$full_total_cm_ar=($subtotal+$new_kilo_4);
?>
NO.8, 2ND STREET,
RADHA NAGAR EXTENSION,
VELACHERY, CHENNAI 600042
STATE: TAMILNADU CODE:33 MOBILE : 8939055088
drganbuganapathi@gmail.com
www.drganbuganapathi.com
-
AGE:
GST NO:.
GST NO:.
MOBILE: EMAIL :'.$row['email']; } ?>
GSTIN : 33ACMPA1286A2Z7
GSTIN : 33ABNPT2826P1ZZ
PAN : ACMPA1286A
FSSAI No.: 12420002002956
PAN : ABNPT2826P
INVOICE NO :
INVOICE DATE :
PAYMENT MODE :
| WEIGHT : | ||
| OFFER@% : | ||
| TAX VALUE : | '.$off_mal_1.''; ?> | |
| TOTAL CGST %: | TOTAL CGST : | |
| TOTAL SGST %: | TOTAL SGST: | |
| TOTAL IGST : | ||
NOTE : \n") ;?> |
||
NOTE : \n") ;?> |
'2025-03-04'){ echo $new_kilo_4= (revised_shipping($new_kilo_41, $rows_order['state'], $conn) + $packing_charges); }else{ $new_kilo_4=(($new_kilo_6+1)*$courier_fees); echo $new_kilo_4=number_format((float)$new_kilo_4, 2, '.', ''); } ?> '2025-03-04'){ echo $new_kilo_4= (revised_shipping($new_kilo_41, $rows_order['state'], $conn) + $packing_charges); }else{ $new_kilo_4; echo $new_kilo_4=number_format((float)$new_kilo_4, 2, '.', ''); } ?> | |
| PACKING CHARGES: | ||
|
PROPRIETRIX TOTAL : Rupees only TOTAL : |
||
|
PROPRIETRIX TOTAL : Rupees only TOTAL : |
||
|
PROPRIETRIX Rupees only TOTAL : |
||
|
PROPRIETRIX Rupees only TOTAL : |
||
| WEIGHT : | |
Note : \n") ;?> |
|
Note : \n") ;?> SHIPPINGS : |
= date(start_date) and '$adc_date'<=date(end_date)"); $set_adc = mysqli_fetch_array($get_adc, MYSQLI_ASSOC); if($rows_order['need_shipping']==2){ echo $new_kilo_4 = $rows_order['custom_charge']; }else if($rows_order['need_shipping']!=1) { if($weight_shift !=0){ $int_weight=($tot_weight_2/1000); $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; } } echo $new_kilo_4=number_format((float)$tot_ship, 2, '.', ''); }else{ $new_kilo_4 = 0; } }else{ echo $new_kilo_4 = 0; } } ?> |
|
only TOTAL : |
|
|
only TOTAL : |