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']; ?>

New Order Recived-Order Details.

Order Details
ENERGY Foods
#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
 		Buyer:'.$row['name'].'
'.nl2br($rows_order['address']).'
'.$rows_order['city'].', '.$rows_order['state'].'- '.$rows_order['pin'].'.
Mobile:'.$row['phone'].' 		GSTIN : 33ACMPA1286A2Z7
PAN : ACMPA1286A2Z7
Invoice No : '.$rows_order['refid'].'
Invoice Date : '.$rows_order['order_date_time'].'
Payment Mode : '.$ss.'
';?> GST%';?> CGST';?> IGST';?> Total';?> query($Query); $nsssss=mysql_num_rows($Query); $manssss='0'; $si=0; while ($rowsss = mysql_fetch_array($Query)) { $product_id=$rowsss['productid']; $qty=$rowsss['qty']; $unit_pr=$rowsss['price']; $tot_price=$rowsss['totprice']; if($contry=="India") { $sym="Rs "; } else { $sym="$"; } $qty=$rowsss['qty']; $Query_12 = mysql_query("SELECT * from `shop_product` where product_id='$product_id' "); //$name_12=$DB->query($Query_12); $no=mysql_num_rows($Query_12); $row_12 = mysql_fetch_array($Query_12); $vstatus=$row_12['vstatus']; $Query_12_company = mysql_query("SELECT * from `tbl_company` where id='$vstatus' "); //$name_12_company=$DB->query($Query_12_company); $no_company=mysql_num_rows($Query_12_company); $row_12_company = mysql_fetch_array($Query_12_company); $new_comp_name=$row_12_company['name']; if($new_comp_name=="Siddhayoga Pharma") { $new_price=(($unit_pr*100)/(100+18)); $sg=number_format((float)$new_price, 2, '.', ''); $n_g="12"; //GST Inclusive Price * GST Rate /(100 + GST Rate Percentage) // Outputs -> 105.00 //GST Inclusive Price * GST Rate /(100 + GST Rate Percentage) } if($new_comp_name=="Energy Foods") { $n_g="18"; //$new_price=(($tot_price*18)/100); $new_price=(($unit_pr*100)/(100+18)); $sg=number_format((float)$new_price, 2, '.', ''); // Outputs -> 105.00 } if($new_comp_name=="Siddha Sastric") { $n_g="5"; //$new_price=(($tot_price*18)/100); $new_price=(($unit_pr*100)/(100+18)); $sg=number_format((float)$new_price, 2, '.', ''); // Outputs -> 105.00 } if($new_comp_name=="Adv. Siddhayoga Research") { $n_g="12"; //$new_price=(($tot_price*18)/100); $new_price=(($unit_pr*100)/(100+18)); $sg=number_format((float)$new_price, 2, '.', ''); // Outputs -> 105.00 } if($new_comp_name=="Siddha Sastric") { $hsn=30; } else { $hsn=3004; } if($new_status==1) { if($vstatus==1) { $v_qty=($qty/2); } if($vstatus==2) { $v_qty=($qty/4); } $x = (int)$v_qty; } else { $x=0; } $weight=$row_12['stock_status_id']; if($weight=='' || $weight==0) { $weight=100; } $new_qty=($weight*$qty); $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; $tot_weight_2 +=$new_qty; $new_weight_2 +=($new_qty); ?> ';?> ';?> 0) { ?> ';?> '.$rowsss['qty'].'';?> '.$sym.'';?> ';?> '.$sym.'';?> ';?> '.$sym.'';?>';?> '.$sym.'';?> ';?> '.$sym.''.$tot_price=number_format((float)$tot_price, 2, '.', '').'';?> query($objqrynewsubee); $Fetchnewww = mysql_fetch_array($objqrynewsubee); $subtotal_123=$Fetchnewww['amtTotal']; $objqrynewsubee_qty = mysql_query("SELECT SUM(qty) AS qty FROM tbl_order where orderid='$orderid'"); //$name_12_123_qty=$DB->query($objqrynewsubee_qty); $Fetchnewww_qty = mysql_fetch_array($objqrynewsubee_qty); $subtotal_123_qty=$Fetchnewww_qty['qty']; ?> ';?> '.$sym.''.$mas_price_2.'';?> '.$sym.''.$mas_price_2_mal.'';?> '.$sym.''.$subtotal_123_4.'';?> query($Query_job_move_courier); $row_job_move_courier= mysql_fetch_array($Query_job_move_courier); $courier_fees=$row_job_move_courier['amount']; $courier_fees_para_1=$row_job_move_courier['amount']; echo $packing_charges=round((($subtotal_123*10)/100)); $packing_charges123=0; if($order_id_iii>179) { $packing_charges123=round((($subtotal_123*10)/100)); if($state=="Puducherry") { $packing_charges=0; } if($state=="Tamilnadu") { $packing_charges=0; } if($state=="Puducherry") { $packing_charges123=0; } if($state=="Tamilnadu") { $packing_charges123=0; } } echo $packing_charges123; if($courier_fees=='') { $Query_job_move_courier_1= mysql_query("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($Query_job_move_courier_1); $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); } $packing_charges123; $courier_fees; if($contry=="India") { $new_kilo_4=(($new_kilo_6+1)*$courier_fees); } else { $tot_weight_2_int=$new_weight_2; "SELECT * from tbl_courier_charges_country where state='$contry' "; $Query_q= mysql_query("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_q); $num_max_ship_int=mysql_num_rows($Query_q); 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= mysql_query("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_jo); $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); ?> ';?> ';?> ';?> ';?> 0) { ?> ';?> ';?>
Product HSN Weight/Nos. Rate Qty Taxable Value SGST
'.$row_12['name'].' '.$hsn.' '.$row_12['product_url'].' '.$sym.''.$sgxxx.' '.$n_g.'%
      Total '.$subtotal_123_qty.' '.$sym.''.$mas_price_1.'   '.$sym.''.$mas_price_2.'
Taxable Value: '.$sym.' '.$mas_price_1.'
Total CGST: '.$sym.''.$mas_price_2.'
Total SGST: '.$sym.''.$mas_price_2.'
Total IGST: '.$sym.''.$vanma.'
Shipping: '.$sym.''.$new_kilo_4.'
Packing Charges ';?>
Total: ';?> '.$sym.''.$grsnt=number_format((float)$grsnt, 2, '.', '').'';?>
';?> mail 0) { $job_name14357="New Order Received"; $Subjectnew = "$job_name14357-$order_id"; $useremail="drganbuganapathi@gmail.com"; $headers1 = "From: drganbuganapathi.com\r\n"."Content-Type: text/html; charset=iso-8859-1\r\n"; //$headers = "From: dranbuganapathi@gmail.com\r\n"."Content-Type: text/html; charset=iso-8859-1\r\n"; //@mail($useremail,$Subjectnew,$msg1,$headers1); //@mail($new_user_name,$Subjectnew,$msg1,$headers1); } //$Recart = mysql_query($Updatecart); //exit(); exit(); ?>