query($Query); $nsssss=mysql_num_rows($namesss); $manssss='0'; $si=0; while ($rowsss = mysql_fetch_array($namesss)) { $product_id=$rowsss['productid']; $qty=$rowsss['qty']; $unit_pr=$rowsss['price']; $tot_price=$rowsss['totprice']; if($contry=="India") { $sym="Rs"; } else { if($country_id==1) { $sym="Rs"; } else { $sym="$"; } } $qty=$rowsss['qty']; $name_12 = mysql_query("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']; $name_12_company = mysql_query("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=="Anbu Phaarmaa") { $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=="Anbu-Phaarmaa") { $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") { $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 && $cust_id!='11363') { $offer_unit = $row_12['offer_unit']; if($offer_unit=="2+1") { $v_qty=($qty/2); } if($offer_unit=="4+1") { $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); $weight_shift+= $weight; ?> query($objqrynewsubee); $Fetchnewww = mysql_fetch_array($name_12_123); $subtotal_123=$Fetchnewww['amtTotal']; $name_12_123_qty = mysql_query("SELECT SUM(qty) AS qty, sum(freeqty) as qtys 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']; $subtotal_123_freeqty=$Fetchnewww_qty['qtys']; ?> 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; if($order_id>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; } } if($courier_fees=='') {} $courier_fees; if($contry=="India") { $new_kilo_4=(($new_kilo_6+1)*$courier_fees); } else { $tot_weight_2_int=$new_weight_2; $Query_job_move_courier_country= 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_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_job_move_courier_country= 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_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); 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); if($country_id==1) { $full_total_cm_ar=($subtotal+$new_kilo_4); } else { $full_total_cm_ar=($subtotal+$new_kilo_4); } if($pos === false){ ?> 0) { ?> 0) { ?> 0) { ?>

S.No	Product Name	Batch No/ Mfg Date	HSN	Weight/Nos.	Rate	Qty	Taxable Value	GST%	CGST	SGST	Total
						0 ) { $freeqty=$rowsss['freeqty']; if($freeqty==0) { $x=$x; } else { $x=$freeqty; } ?> +			%
				Total
									Taxable Value :
									Total CGST :
									Total SGST :
									Offer@% :
									Cart Total :
									Shipping :	= date(start_date) and '$adc_date'<=date(end_date)"); $set_adc = mysqli_fetch_array($get_adc, MYSQLI_ASSOC); 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; } ?>
									Packing Charges :
									Offer@% :
									Total :