#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
GSTIN : 33ACMPA1286A2Z7
GSTIN : 33ABNPT2826P1ZZ
PAN : ACMPA1286A
PAN : ABNPT2826P
Invoice No :
Invoice Date :
Payment Mode :
| S.No |
Product Name |
HSN |
Weight/Nos. |
Rate |
Quantity |
Taxable Value |
GST% |
CGST |
SGST |
IGST |
Total |
query($Query_jobmal_shipping_devidiya);
$qty_devidiya=mysql_num_rows($name_pundai);
$Query = "SELECT * from tbl_order where 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="$";
}
$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;
}
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'];
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) {
if($freeqty==0)
{
$x=$x;
}
else
{
$x=$freeqty;
}
?>
+
|
|
|
% |
|
|
|
|
query($objqrynewsubee);
$Fetchnewww = mysql_fetch_array($name_12_123);
$subtotal_123=$Fetchnewww['amtTotal'];
$objqrynewsubee_qty = "SELECT SUM(qty) AS qty FROM tbl_order where 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'];
?>
| |
|
|
|
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;
}
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);
?>
'' ,'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);
}
}
}
?>
|
Rupees only
Taxable Value:
|
Taxable Value : |
|
|
for SIDDHAYOGA PHARMA
TOTAL CGST:
|
Total CGST : |
|
| Total SGST : |
|
|
for SIDDHAYOGA PHARMA
TOTAL IGST:
|
Total IGST : |
|
| Shipping : |
|
0)
{
?>
| Packing Charges : |
|
|
Proprietrix
TOTAL :
Rupees only
TOTAL :
|
|
|
Proprietrix
Rupees only
TOTAL : |
|
| Shipping : |
|
0)
{
?>
|
dollars only
TOTAL :
|
|
dollars only
TOTAL : |
|
