495) { $kudhi=0; } else { $kudhi=10; } $objconfirmorder = "SELECT * from tbl_confirmorder where orid='$id' "; $Fetconfirmorder=$DB->query($objconfirmorder); $nss_con=mysql_num_rows($Fetconfirmorder); $manssss='0'; $rows_order = mysql_fetch_array($Fetconfirmorder); $orderid=$rows_order['orderid']; $res_id =$rows_order['res_id']; $datenew=$rows_order['deliverydate']; $userid =$rows_order['userid']; $offer =$rows_order['offer']; $type =$rows_order['type']; $state=$rows_order['state']; $country_id=$rows_order['country_id']; $contry=$rows_order['contry']; $company_name=$rows_order['company_name']; $new_sta=1; if($state=="Tamilnadu") { $new_sta=0; } $varstatus =$rows_order['varstatus']; if($contry=="India") { if($varstatus!='0') { $ss=$varstatus; } else { $ss="Payumoney"; } } else { $ss="Paypal"; if($country_id==1) { $ss=$varstatus; } else { $ss="Paypal"; } } $Query = "SELECT * from `shop_user` where user_id='$userid' "; $name=$DB->query($Query); $no=mysql_num_rows($name); $row = mysql_fetch_array($name); $new_status=$row['new_status']; $gst=$row['gst']; $mala_olu=0; if($gst=="") { $mala_olu=1; } if($gst=="GST") { $mala_olu=1; } ?>






Name : BILL NO:
Address :

BILL DATE:
Age :   Sex: PAYMENT MODE: ONLINE
Mobile :
Email :
query($Query_jobmal_shipping_devidiya); $qty_devidiya=mysql_num_rows($name_pundai); //$Query = "SELECT * from tbl_order where orderid='$orderid'"; $Query = "SELECT td.price as price, td.* from tbl_order td inner join shop_product sp on td.productid = sp.product_id where sp.v_s !=1 and td.orderid='$orderid'"; $namesss=$DB->query($Query); $nsssss=mysql_num_rows($namesss); $manssss='0'; $si=0; while ($rowsss = mysql_fetch_array($namesss)) { $product_id=$rowsss['productid']; $qty=$rowsss['qty']; $freeqty=$rowsss['freeqty']; $unit_pr=$rowsss['price']; $tot_price=$rowsss['totprice']; if($contry=="India") { $sym="Rs"; } else { //$sym="$"; if($country_id==1) { $sym="Rs"; $sym1="Rupess"; } else { //$sym="$"; $sym=""; //$sym1="Dollar"; $sym1=""; } } $qty=$rowsss['qty']; $Query_12 = "SELECT * from `shop_product` where product_id='$product_id' "; $name_12=$DB->query($Query_12); $no=mysql_num_rows($name_12); $row_12 = mysql_fetch_array($name_12); $vstatus=$row_12['vstatus']; $Query_12_company = "SELECT * from `tbl_company` where id='$vstatus' "; $name_12_company=$DB->query($Query_12_company); $no_company=mysql_num_rows($name_12_company); $row_12_company = mysql_fetch_array($name_12_company); $new_comp_name=$row_12_company['name']; if($new_comp_name=="Siddhayoga Pharma") { $new_price=(($unit_pr*100)/(100+12)); $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+5)); $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+12)); $sg=number_format((float)$new_price, 2, '.', ''); // Outputs -> 105.00 } if($new_comp_name=="Siddha Sastric") { $hsn=30; }elseif($row_12['product_url'] == 'T.I. Book'){ $hsn=4901; }elseif($row_12['v_s'] == 1){ $hsn=999723; } else { $hsn=3004; } if($new_status==1) { if($vstatus==1) { $v_qty=($qty/2); } if($vstatus==7) { $v_qty=($qty/2); } if($vstatus==6) { $v_qty=($qty/2); } if($vstatus==2) { $v_qty=($qty/4); } $x = (int)$v_qty; } else { $x=0; } $weight=$row_12['stock_status_id']; $vid_type = $row_12['v_s']; if($vid_type !=1){ if($weight=='' || $weight==0) { $weight=100; } } else{ $weight = 0; } $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); $weight_shift+= $weight; ?> query($objqrynewsubee); $Fetchnewww = mysql_fetch_array($name_12_123); $subtotal_123=$Fetchnewww['amtTotal']; $objqrynewsubee_qty = "SELECT SUM(qty) AS qty FROM tbl_order td INNER JOIN shop_product sp on td.productid = sp.product_id where sp.v_s !=1 and td.orderid='$orderid'"; $name_12_123_qty=$DB->query($objqrynewsubee_qty); $Fetchnewww_qty = mysql_fetch_array($name_12_123_qty); $subtotal_123_qty=$Fetchnewww_qty['qty']; ?>
S.NO PRODUCT NAME HSN WEIGHT/NOS. RATE QUANTITY TAXABLE VALUE GST% CGST SGST IGST TOTAL
0) { if($freeqty==0) { $x=$x; } else { $x=$freeqty; } ?> + %
          Total  
          Total
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']; } 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 { $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=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; } } } $packing_charges=round((($subtotal*$kudhi)/100)); $packing_charges123=0; 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; } else { $courier_fees=$row_job_move_courier_1['amount']; } $subtotal_123; $packing_charges123=round((($subtotal_123*$kudhi)/100)); $packing_charges=round((($subtotal*$kudhi)/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; $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); ?> '' ,'1'=> 'One' ,'2'=> 'Two' ,'3' => 'Three','4' => 'Four','5' => 'Five','6' => 'Six','7' => 'Seven','8' => 'Eight','9' => 'Nine','10' => 'Ten','11' => 'Eleven','12' => 'Twelve','13' => 'Thirteen','14' => 'Fouteen','15' => 'Fifteen','16' => 'Sixteen','17' => 'Seventeen','18' => 'Eighteen','19' => 'Nineteen','20' => 'Twenty','30' => 'Thirty','40' => 'Fourty','50' => 'Fifty','60' => 'Sixty','70' => 'Seventy','80' => 'Eighty','90' => 'Ninty','100' => 'Hundred &','1000' => 'Thousand','100000' => 'Lakh','10000000' => 'Crore'); if($no == 0) return ' '; else { $novalue=''; $highno=$no; $remainno=0; $value=100; $value1=1000; while($no>=100) { if(($value <= $no) &&($no < $value1)) { $novalue=$words["$value"]; $highno = (int)($no/$value); $remainno = $no % $value; break; } $value= $value1; $value1 = $value * 100; } if(array_key_exists("$highno",$words)) return $words["$highno"]." ".$novalue." ".no_to_words($remainno); else { $unit=$highno%10; $ten =(int)($highno/10)*10; return $words["$ten"]." ".$words["$unit"]." ".$novalue." ".no_to_words($remainno); } } } ?> 0){ ?> 0) { ?> 0) { ?> 0) { ?> 0) { $s_roun_mal_su_ollu=number_format((float)$s_roun_mal_su_ollu, 2, '.', ''); ?>
OFFER@% :

Rupees only TAXABLE VALUE: 

TAXABLE VALUE : '.$off_mal_1.''; ?>
OFFER@% :

for SIDDHAYOGA PHARMA TOTAL CGST %: 

TOTAL CGST :
TOTAL SGST %: TOTAL SGST :

for SIDDHAYOGA PHARMA TOTAL IGST: 

TOTAL IGST :

NOTE : \n") ;?>

NOTE : \n") ;?>
SHIPPING : 

PACKING CHARGES :

PROPRIETRIX TOTAL : 

Rupees only TOTAL : 

TOTAL : 

PROPRIETRIX TOTAL : 

Rupees only TOTAL : 

PROPRIETRIX Rupees only TOTAL : 

PROPRIETRIX Rupees only TOTAL : 

0) { ?>

NOTE : \n") ;?>

NOTE : \n") ;?>


only

Authorised signature  

dollars only TOTAL : 

















Date:




WHOMSOEVER CONCERN



   This is to certify that , Age has been receiving treatment in my hospital in continuation of his/her treatment he/she has been given herbal supplements from our Pharmacy as per the prescription and bill for his/her personal use only. This course of supplements is mandatory for his/her recovery from his/her ailment. These supplements are not for commercial purpose.












DR. G. ANBUGANAPATHI

PERFORMANCE INVOICE
Exporter:
G.ANBUGANAPATHI
NO.10A RADHA NAGAR DIVISION
2ND STREET WEST VALACHERY
CHENNAI-600 042
TEL: 9080023510

Inv. No. & Date
Exporter 's Ref




Other Reference(s)
AADHAAR NO: 8871 1922 8208
Consignee:
'; echo strtoupper($set_cust['address']).'
'; if($set_cust['city']!=''){ echo strtoupper($set_cust['city']).'
'; } if($set_cust['state']!=''){ echo strtoupper($set_cust['state']).'
'; } if($set_cust['contry']!=''){ echo strtoupper($set_cust['contry']).'
'; } if($set_cust['pin']!=''){ echo $set_cust['pin'].'
'; } if($set_cust['dif_phone']!=''){ echo 'MOB: '.$set_cust['dif_phone'].' '; } ?>

Pre_Carrige by
N.A
Place of Receipt
N.A
Vessel/Flight
No.  AIR
Port of Loading
CHENNAI
Port of Discharge
Port of Destination
Country of Origin
INDIA
Country of Final Destination
 Terms of Delivery and Payment



SIDDHA MEDICINE
query($Query_jobmal_shipping_devidiya); $qty_devidiya=mysql_num_rows($name_pundai); //$Query = "SELECT * from tbl_order where orderid='$orderid'"; $Query = "SELECT td.price as price, td.* from tbl_order td inner join shop_product sp on td.productid = sp.product_id where sp.v_s !=1 and td.orderid='$orderid'"; $namesss=$DB->query($Query); $nsssss=mysql_num_rows($namesss); $manssss='0'; $si=0; echo ''; while ($rowsss = mysql_fetch_array($namesss)) { $product_id=$rowsss['productid']; $qty=$rowsss['qty']; $freeqty=$rowsss['freeqty']; $unit_pr=$rowsss['price']; $tot_price=$rowsss['totprice']; if($contry=="India") { $sym="Rs"; } else { //$sym="$"; if($country_id==1) { $sym="Rs"; $sym1="Rupess"; } else { //$sym="$"; $sym=""; //$sym1="Dollar"; $sym1=""; } } $qty=$rowsss['qty']; $Query_12 = "SELECT * from `shop_product` where product_id='$product_id' "; $name_12=$DB->query($Query_12); $no=mysql_num_rows($name_12); $row_12 = mysql_fetch_array($name_12); $vstatus=$row_12['vstatus']; $Query_12_company = "SELECT * from `tbl_company` where id='$vstatus' "; $name_12_company=$DB->query($Query_12_company); $no_company=mysql_num_rows($name_12_company); $row_12_company = mysql_fetch_array($name_12_company); $new_comp_name=$row_12_company['name']; if($new_comp_name=="Siddhayoga Pharma") { $new_price=(($unit_pr*100)/(100+12)); $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+5)); $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+12)); $sg=number_format((float)$new_price, 2, '.', ''); // Outputs -> 105.00 } if($new_comp_name=="Siddha Sastric") { $hsn=30; }elseif($row_12['product_url'] == 'T.I. Book'){ $hsn=4901; }elseif($row_12['v_s'] == 1){ $hsn=999723; } else { $hsn=3004; } if($new_status==1) { if($vstatus==1) { $v_qty=($qty/2); } if($vstatus==7) { $v_qty=($qty/2); } if($vstatus==6) { $v_qty=($qty/2); } if($vstatus==2) { $v_qty=($qty/4); } $x = (int)$v_qty; } else { $x=0; } $weight=$row_12['stock_status_id']; $vid_type = $row_12['v_s']; if($vid_type !=1){ if($weight=='' || $weight==0) { $weight=100; } } else{ $weight = 0; } $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); $weight_shift+= $weight; ?>
No. & Kind of Pkgs DESCRIPTION OF GOODS HSN CODE NO OF
PIECES
INR/PCS TOTAL INR
ONE PACKAGING 0) { if($freeqty==0) { $x=$x; } else { $x=$freeqty; } ?> + %
Amount (in words) INR TOTAL
only

Total Gross Weight: Kgs
Box Dimension (in CM): * *

Declaration: We declare that this invoice shows the price of the
goods described and that all the particulars true and correct.
For




Authorised Signatory
0 && $set_img['passport_file']!='' ){ foreach($file_arr as $arr){ $path = 'phpaction/uploads/'.$arr; ?>