<?php
ob_start();
ini_set('display_errors','off');

include("settings/db_ini.php");


require 'config.php';


require 'razorpay-php/Razorpay.php';
use Razorpay\Api\Api;
use Razorpay\Api\Errors\SignatureVerificationError;

$success = true;

$error = "Payment Failed";

if (empty($_POST['razorpay_payment_id']) === false) {
    $api = new Api($keyId, $keySecret);

    try
    {
        // Please note that the razorpay order ID must
        // come from a trusted source (session here, but
        // could be database or something else)
        $attributes = array(
            'razorpay_order_id' => $_SESSION['razorpay_order_id'],
            'razorpay_payment_id' => $_POST['razorpay_payment_id'],
            'razorpay_signature' => $_POST['razorpay_signature'],
        );

        $api->utility->verifyPaymentSignature($attributes);
    } catch (SignatureVerificationError $e) {
        $success = false;
        $error = 'Razorpay Error : ' . $e->getMessage();
    }
}

if ($success === true) {

    $razorpay_order_id = $_SESSION['razorpay_order_id'];
    $razorpay_payment_id = $_POST['razorpay_payment_id'];
    $email = $_SESSION['email'];
    $price = $_SESSION['price'];

   $objcorderid    = mysql_query("SELECT * from tbl_confirmorder ");
 $nosnewcid=mysql_num_rows($objcorderid);
$Fetcorderid      = mysql_fetch_array($objcorderid);



$objcorderid_new    = mysql_query("SELECT * FROM `tbl_confirmorder` WHERE varstatus!='Cash' and company_name='Energy Foods' and `orid` in (select orderid from tbl_order)  ");
 $nosnewcid_new=mysql_num_rows($objcorderid_new);
 $nosnewcid_new_1=$nosnewcid_new+11;
  $orderid_new_s=HC.$nosnewcid_new_1;
 
 
//$Fetcorderid_new      = mysql_fetch_array($objcorderid_new);

if($nosnewcid=='0')
{
	 $maxcorderid='1';
	 $maxcorderid1=HC.$maxcorderid;
}
else
{
$objmaxcorder    = mysql_query("SELECT max(orid)+1 as newordid from tbl_confirmorder ");
$Fetmaxcorder      = mysql_fetch_array($objmaxcorder);
 $maxcorderid=$Fetmaxcorder['newordid'];
 $maxcorderid1=HC.$maxcorderid;	
}
 $numrows=5;

if($numrows>0)
{


$objRe    = mysql_query("SELECT * from shop_cart where trans='$razorpay_order_id' ");
   $numrows_ma = mysql_num_rows($objRe);
   
   if($numrows_ma>0)
{

$date = date_default_timezone_set('Asia/Kolkata');
    $dt2=date('Y-m-d H:i:s' );
   $Insert_memberord = "INSERT INTO tbl_confirmorder (`userid`,`intsessionid`,`orderid`,`refid`,`varstatus`,`order_tc_id`,`orderstatus`,`res_id`,`type`,`order_date_time`) VALUES ('$sessionid_free','$browsessionid','$maxcorderid','$orderid_new_s','0','0','0','0','','$dt2')";
	
   $inexeord=mysql_query($Insert_memberord);
   $attachmentfileid = mysql_insert_id();
   //$sessionid_free= addslashes($_POST['sessionid_free']);
   
   $Updatecart	=	mysql_query("UPDATE  tbl_confirmorder SET `orderid`='$attachmentfileid' where orid='$attachmentfileid' ");
   
   $objRe    = mysql_query("SELECT * from shop_cart where trans='$razorpay_order_id'");
   $numrows_ma = mysql_num_rows($objRe);
while($Fetchneword      = mysql_fetch_array($objRe))
{

$del_country=$Fetchneword['del_country'];
$del_city=$Fetchneword['del_city'];
$del_state=$Fetchneword['del_state'];
$del_address=$Fetchneword['del_address'];
$del_inp=$Fetchneword['del_inp'];
$dif_name=$Fetchneword['dif_name'];
$dif_phone=$Fetchneword['dif_phone'];


 "UPDATE  tbl_confirmorder SET `contry`='$del_country',`city`='$del_city',`state`='$del_state',`address`='$del_address',`pin`='$del_inp' where orid='$attachmentfileid' ";
 $Updatecart	=	mysql_query("UPDATE  tbl_confirmorder SET `contry`='$del_country',`intsessionid`='$razorpay_order_id',`varstatus`='Razorpay',`city`='$del_city',`state`='$del_state',`address`='$del_address',`pin`='$del_inp',`dif_name`='$dif_name',`dif_phone`='$dif_phone' where orid='$attachmentfileid' ");
 
$productid= $Fetchneword['productid'];
$qty= $Fetchneword['qty'];
$price= $Fetchneword['price'];
$totprice= $Fetchneword['totprice'];
$date = date_default_timezone_set('Asia/Kolkata');
    $dt2=date('Y-m-d H:i:s' );

   $Insert_member = "INSERT INTO tbl_order(`user_id`,`res_id`,`productid`,`qty`, `price`,`totprice`,`orderdate`,`type`,`session_id`,`ordertime`,`orderid`) VALUES ('$sessionid_free','0','$productid','$qty' ,'$price' ,'$totprice','$dt2','','$razorpay_order_id','','$attachmentfileid')";
   
   $inexe=mysql_query($Insert_member);

}

$Delete_Question	=	"DELETE FROM shop_cart WHERE `trans`='$razorpay_order_id'";

$Result_Question	=	mysql_query($Delete_Question);

 "SELECT * from shop_user where user_id='$sessionid_free_123' ";


 $objcorderid_n_user    = mysql_query("SELECT * from shop_user where user_id='$sessionid_free_123' ");
 $nosnewcid_n_user=mysql_num_rows($objcorderid_n_user);
 $Fetcorderid_n_user      = mysql_fetch_array($objcorderid_n_user);
 
  $new_status=$Fetcorderid_n_user['new_status'];
 
 $new_user_name=$Fetcorderid_n_user['email'];
 
 $objcorderid    = mysql_query("SELECT * from tbl_confirmorder where  orid='$attachmentfileid' ");
 $nosnewcid=mysql_num_rows($objcorderid);
 $Fetcorderid      = mysql_fetch_array($objcorderid);
  $new_order_id=$Fetcorderid['orderid'];
 
 $new_order_id=$Fetcorderid['orderid'];
 $userid_new_userid=$Fetcorderid['userid'];
 $orderdate=$Fetcorderid['order_date_time'];
 $order_id=$Fetcorderid['refid'];
 $order_id_iii=$Fetcorderid['orderid'];
 
 $contry=$Fetcorderid['contry'];
 if($contry=="India")
 {
 $sym="Rs";
 }
 else
 {
 $sym="$";
 }
$city=$Fetchneword['city'];
$state=$Fetcorderid['state'];
$address=$Fetchneword['address'];
$pin=$Fetchneword['pin'];

$new_sta=1;
$col_mal=8;
 
 if($state=="Tamilnadu")
   {
   
   $new_sta=0;
   $col_mal=9;
   }

?>

 

 <?php /*?>mail<?php */?>
  
  <?
//$id=170;								
									
  $objconfirmorder =  mysql_query("SELECT * from tbl_confirmorder  where orid='$attachmentfileid' ");
                                               //$Fetconfirmorder=$DB->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'];
  
  $mal_refid=$rows_order['refid'];
 
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'];
											   
											   $mobss= $row['phone'];
												$mmmm= $row['name'];
												
												
												$pundai_name=	$rows_order['dif_name'];
					
					
					
					if($pundai_name=="name")
					{
					
					$mala_name =$row['name'];
					}
					else
					{
					
					$mala_name =	$rows_order['dif_name'];
					}


?>

<?
 /*  -----------------------------------*/
 
 //enter Mobile numbers comma seperated 
		
	
 $message = "Hi ".$mmmm." Your Order With Dr. G.ANBUGANAPATHI is placed.Your order no. is ".$mal_refid.".Please check your mail. DRANBU"; //enter Your Message /enter Your Message 
 $message = urlencode($message);
 curl_setopt_array($curl, array(
   CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=DRANBU&Message='.$message.'&MobileNumbers='.$mobss.'&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';
		
		?>

 <?
  $msg5.='<style type="text/css">
	
		
	
		.white_link{
	
		font-family:Verdana;
	
		font-size:12px;
	
		color:#666666;
	
		line-height:18px;
	
		font-weight:normal;
	
		text-decoration:none;
	
		}
		.copy_txt{
	
		font-family:Arial, Helvetica, sans-serif;
	
		font-size:11px;
	
		color:#666666;
	
		text-decoration:none;
	
		}
	
		</style>
		<body>
  <table width="65%" border="1" align="center" cellpadding="15" cellspacing="0" class="border_blak" bgcolor="">
	
		<tr>
	
		<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFF">
	
		<tr>
	
		<td style="background-color:#6AAC00;"  align="center" valign="middle" bgcolor="#FFF">Dr. G.ANBUGANAPATHI</td>
	
		</tr>
		<tr>
		<td>&nbsp;</td>
		</tr>
		
		<tr>
	
		<td colspan="3">Hi '.$mala_name.' Your order has been submitted sucessfully<br/><br/>
		
		<div align="center">	<span style="color:#FF0000">
		Click the button below to view your order
		</span></div>
		
		<div align="center"><span style="color:#FF0000"> <a href="https://drganbuganapathi.com/order-confirm/order-admin/invoice_prin_download.php?id='.$attachmentfileid.'"><button name="subject" type="submit" value="View Order">View Order</button></a>
</span></div> 
		 </td>
	
		</tr>
		
		<tr>
		<td class="white_link" colspan="2">Thanks & Regards<br /><strong>Dr.G.ANBUGANAPATHI
		
</strong></td>
		</tr>
		
		<tr>
	
		<td height="3" align="center" bgcolor="#454545"></td>
	
		</tr>
	
		<tr>
	
		<td height="30" align="center"><span class="copy_txt"> Copyright &copy; 2020 - drganbuganapathi.com, All Rights Reserved.</span></td>
	
		</tr>
	
		
	</table>	';
		
		
  
  ?>
  
  
<?   $msg1.='<div style="width:100%">

<p style="margin-top:0px;margin-bottom:20px">New Order Recived-Order Details.</p>

<table style="border-collapse:collapse;width:100%;border-top:1px solid #dddddd;border-left:1px solid #dddddd;margin-bottom:20px">
      
    <thead>
      <tr>
        <td colspan="12" style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:left;padding:7px;color:#222222">Order Details</td>
      </tr>
    </thead>
    
    <tbody>
      <tr>
        <td style="font-size:12px;border-right:1px solid #dddddd;vertical-align:top;border-bottom:1px solid #dddddd;text-align:left;padding:7px"><b>
		ENERGY Foods</label><br />
	#11,2nd Street, Radha Nagar Extn.<br />
Velachery,Chennai 600 042.<br />
State :Tamilnadu&nbsp;&nbsp;Code:33<br />
Phone:044-2253 1316<br />
Email : drganbuganapathi@gmail.com<br />
Website : www.drganbuganapathi.com<br />
		</b>
          
		   
		   
		   </td>
		   
		   
		   <td style="font-size:12px;vertical-align:top;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:left;padding:7px">
		
		
		 <b>Buyer:'.$row['name'].'<br>
		 '.nl2br($rows_order['address']).'<br>
		 '.$rows_order['city'].', '.$rows_order['state'].'- '.$rows_order['pin'].'.<br>
                                        <strong>Mobile:'.$row['phone'].'</strong>
		 
		 </b> 
		
		
		
          
		  
		  
		   
		   
		   </td>
		   
		    <td style="font-size:12px;vertical-align:top;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:left;padding:7px"><b>
		GSTIN : 33ACMPA1286A2Z7
</label><br />
	PAN : ACMPA1286A2Z7
<br />
Invoice No : '.$rows_order['refid'].'
<br />
Invoice Date : '.$rows_order['order_date_time'].'
<br />
Payment Mode : '.$ss.'
<br />

		</b>
          
		   
		   
		   </td>
      </tr>
    </tbody>
  </table><table style="border-collapse:collapse;width:100%;border-top:1px solid #dddddd;border-left:1px solid #dddddd;margin-bottom:20px">
    <thead>
      <tr>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:left;padding:7px;color:#222222">Product</td>
		<td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:left;padding:7px;color:#222222">HSN</td>
        <!--<td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:left;padding:7px;color:#222222">Model</td>-->
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">Weight/Nos.</td>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">Rate</td>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">Qty</td>
		<td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">Taxable Value</td>';?>
		<?   $msg1.='<td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">GST%</td>';?>
		
		<? if($new_sta==0)
										{
										?>
		<?   $msg1.='<td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">CGST</td>
		<td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">SGST</td>';?>
		
		<?
		}
		else
		{
		?>
		
		<?   $msg1.='<td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">IGST</td>';?>
		
		<?
		}
		?>
		
		
		<?   $msg1.='<td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;background-color:#efefef;font-weight:bold;text-align:right;padding:7px;color:#222222">Total</td>
		
		
      </tr>
    </thead>
    <tbody>';?>
	
	<?
										$table_name="tbl_order";
									
 $Query = mysql_query("SELECT * from tbl_order where orderid='$orderid'");
                                               //$namesss=$DB->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+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==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);
 
 

											   ?>
											   
											   <?  $sym;?><?  $massss=($sg);?>
										<?  $sgxxx=number_format($massss, 2, '.', '');?>
	
	
	<?   $msg1.='<tr>
	<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:left;padding:7px">'.$row_12['name'].'</td>
	<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:left;padding:7px">'.$hsn.'</td>
	<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:left;padding:7px">'.$row_12['product_url'].'</td>
	<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.''.$sgxxx.'</td>';?>
	
	<? if($new_status==1)
												{
												?>
	
	<?   $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">';?>
	<? if($x>0) { ?>
										
										<?  $msg1.=''.($qty+$x).'';?><? $Msg1.='(';?><? $Msg1.=''.$qty.'';?><? $Msg1.='+';?><? $Msg1.=''.$x.'';?> <? $Msg1.='Free)';?>
										<?
										}
										else
										{
										?>
										<?  $msg1.=''.$qty.'';?>
										
										<?
										}
										?>
	<?  $msg1.='</td>';?>
	
	<?
	}
	else
	{
	?>
	<?   $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$rowsss['qty'].'</td>';?>
	
	<?
	}
	?>
	
	<?   $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.'';?> <?  $new_sg;?><?   $tot_new_price=($sg*$qty);
										?>
										<?
										$tot_new_price=number_format($tot_new_price, 2, '.', '');
										?>
										 <? $msg1.=''.$tot_new_price.'';?>
										 <?
										 $mas_price_1 +=$tot_new_price;
										 ?>
										 <?
										   $tot_new_price;
										   $gst=($tot_price-$tot_new_price);
										   $new_gst=($gst/2);
										  $tot_new_price_1=number_format($new_gst, 2, '.', '');
										  $mas_price_2 +=$tot_new_price_1;
												?>
												
											<?
											$mala=($tot_new_price_1+$tot_new_price_1);
											?>	
										 <? $msg1.='</td>
	<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$n_g.'%</td>';?>
	
	<? if($new_sta==0)
										{
										?>
	<? $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.'';?> <?  $new_sg;?><? $msg1.=''.$tot_new_price_1.'</td>';?>
	
	<? $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.'';?><? $msg1.=''.$tot_new_price_1.'</td>';?>
	
	<?
	}
	else
	{
	?>
	
	<? $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.'';?> <?  $new_sg;?><? $msg1.=''.$mala.'</td>';?>
	
		
	<?
	}
	?>
										
										<? $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.''.$tot_price=number_format((float)$tot_price, 2, '.', '').'</td>
	
	</tr>
	</tbody>';?>
	
	<?
	}
	?>
	<?
 $objqrynewsubee    = mysql_query("SELECT SUM(totprice) AS amtTotal FROM tbl_order where orderid='$orderid'");
//$name_12_123=$DB->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;?> <?  $subtotal_123_4=number_format((float)$subtotal_123, 2, '.', '');?>

<?   $msg1.='<tr style="font-weight:bold">
									
									<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">&nbsp;</td>
									<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">&nbsp;</td>

									<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">&nbsp;</td>
									<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">Total</td>
									<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$subtotal_123_qty.'</td>
									<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.''.$mas_price_1.'</td>
									<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">&nbsp;</td>';?>
									
									<? if($new_sta==0)
										{
										?>
									
									<? $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.''.$mas_price_2.'</td>
									<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.''.$mas_price_2.'</td>';?>
									
									<?
									}
									else
									{
									$mas_price_2_mal=($mas_price_2+$mas_price_2);
									?>
									
									<? $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.''.$mas_price_2_mal.'</td>';?>
									
									
									<?
									}
									?>

									<? $msg1.='<td  style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">'.$sym.''.$subtotal_123_4.'</td>
									
									</tr>';?>
									
									<?
											   $new_kilo_41=($tot_weight_2/1000);
$new_kilo_5 = explode('.',$new_kilo_41);
 $new_kilo_6=$new_kilo_5[0];
 
   $Query_job_move_courier= mysql_query("SELECT *  from tbl_courier_charges where state='$state' ");
  //$name_12=$DB->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'];
	
	$packing_charges=round((($subtotal_123*0)/100));
	 $packing_charges123=0;
	 
	 
	if($order_id_iii>179)
	{
	 $packing_charges123=round((($subtotal_123*0)/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=='')
{


 $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*0)/100));
 $packing_charges=round((($subtotal*0)/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);
 
 ?>
    <?   $msg1.='<tfoot>
            <tr>
        <td colspan="'.$col_mal.'" style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>Taxable Value:</b></td>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>'.$sym.' '.$mas_price_1.'</b></td>
      </tr>';?>
	  <? if($new_sta==0)
										{
										?>
	   <?   $msg1.='<tr>
        <td colspan="'.$col_mal.'" style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>Total CGST:</b></td>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>'.$sym.''.$mas_price_2.'</b></td>
      </tr>
	  
	   <tr>
        <td colspan="'.$col_mal.'" style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>Total SGST:</b></td>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>'.$sym.''.$mas_price_2.'</b></td>
      </tr>';?>
	  
	  <?
	  }
	  else
	  {
	  $vanma=($mas_price_2+mas_price_2);
	  ?>
	   <?   $msg1.='<tr>
        <td colspan="'.$col_mal.'" style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>Total IGST:</b></td>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>'.$sym.''.$vanma.'</b></td>
      </tr>';?>
	  
	  <?
	  }
	  ?>
	  
         <?
									 if($contry=="India")
  {
  $new_kilo_4=(($new_kilo_6+1)*$courier_fees);
									 $new_kilo_4=number_format((float)$new_kilo_4, 2, '.', '');
  }
  else
  {
   $new_kilo_4=number_format((float)$new_kilo_4, 2, '.', '');
  }
  ?>
	   <?  $msg1.='<tr>
        <td colspan="'.$col_mal.'" style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>Shipping:</b></td>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>'.$sym.''.$new_kilo_4.'</b></td>
      </tr></td>
      </tr>';?>
	  
	   <?
	   if($contry=="India")
  {
								if($packing_charges123>0)
{

?>
	  
	 
	  
	  <?
	  }
	  }
	  ?>
	  <? 
	  if($contry=="India")
  { 
	   
	   }
	   else
	   {
	   $packing_charges123=0;
	   }
	  $grsnt=($Fetchnewww['amtTotal']+$new_kilo_4+$packing_charges123);
									?>
	   <? $msg1.='<tr>
        <td colspan="'.$col_mal.'" style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px"><b>Total:</b></td>
        <td style="font-size:12px;border-right:1px solid #dddddd;border-bottom:1px solid #dddddd;text-align:right;padding:7px">';?>
		<? $msg1.='<b>'.$sym.''.$grsnt=number_format((float)$grsnt, 2, '.', '').'</b>';?>
		<? $msg1.='</td>
      </tr>';?>
         
          <?  $msg1.=' </tfoot>
  </table>
  
  
  
  
</div></div>';?>
  
 <?php /*?> mail<?php */?>
<?
    $msg1;

if($numrows_ma>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,$msg5,$headers1);
@mail($new_user_name,$Subjectnew,$msg5,$headers1);





}
   
}

}


    if (mysqli_query($con, $sql)) {
        echo "Payment Details  inserted to DB";
    }

    $html = "<p>Your payment was successful</p>
             <p>Payment ID: {$_POST['razorpay_payment_id']}</p>";
} else {
    $html = "<p>Your payment failed</p>
             <p>{$error}</p>";
}

echo $html;


?>

<?

if ($success === true) {

?>
<html>
<head>
<title>Merchant Check Out Page</title>
</head>
<body>
	<center><h1>Please do not refresh this page...</h1></center>
		<form method="post" action="order_complete.php" name="f1">
		<table border="1">
			<tbody>
			
			</tbody>
		</table>
		<script type="text/javascript">
			document.f1.submit();
		</script>
	</form>
</body>
</html>
<?
}
?>