<?php 
ob_start();
require_once("includes/dbsmain.inc.php");
include("site-main-query.php");
$site_url=$compDATA['admin_website_url'];


?>


<?php
/*$check_cart_empty=db_query("select * from tbl_basket where 1 and bskt_session_id='$_SESSION[cart_session_id]' ");
if(mysqli_num_rows($check_cart_empty)<=0)
{?>
  <script>
      alert("Your cart is empty !");
      window.location.href="cart.html";
  </script>
<?}*/

$Curr_Date = date("Y-m-d");
if($_SESSION['cart_session_id']!="" && !empty($_SESSION['cart_session_id']) && $_SESSION['login_id']!="" && !empty($_SESSION['login_id']))
{
    $check_cart_empty=db_query("select * from tbl_basket where 1 and bskt_session_id='$_SESSION[cart_session_id]' ");
if(mysqli_num_rows($check_cart_empty)<=0)
{?>
  <script>
      alert("Your cart is empty !");
      window.location.href="cart.html";
  </script>
<?}else{
    
db_query("insert into tbl_order set 
ord_reg_id='$_SESSION[login_id]',
ord_net_amount='$_SESSION[payable_amount]',
ord_tax='$_SESSION[tax]',
ord_amount='$_SESSION[sub_total]',
order_payment_method='$_SESSION[payment_method]',
ord_comment='$_SESSION[comment]',
ord_date='$Curr_Date'");

$order_id=db_scalar("select max(ord_id) from tbl_order");

 $cart_sql=db_query("select * from tbl_basket where 1 and bskt_session_id='$_SESSION[cart_session_id]' ");
  while($cart_data=mysqli_fetch_array($cart_sql))
  {
db_query("insert into tbl_order_detail set 
order_id='$order_id',
order_reg_id='$_SESSION[login_id]',
product_id='$cart_data[bskt_prd_id]',
product_qty='$cart_data[bskt_prd_qnty]',
product_unit_price='$cart_data[bskt_prd_unit_price]',
product_price='$cart_data[bskt_prd_subtotal]',
product_color='$cart_data[color]',
product_size='$cart_data[size]',
product_area='$cart_data[area]',
order_payment_method='$_SESSION[payment_method]',
order_date='$Curr_Date'");

$db_qnty=db_scalar("select category_qnty from tbl_category where category_id='$cart_data[bskt_prd_id]' ");
$qnty=$db_qnty-$cart_data['bskt_prd_qnty'];
db_query("update tbl_category set category_qnty='$qnty' where category_id='$cart_data[bskt_prd_id]'");

    }
    
    
/////////////////////// Data Entry For Invoice /////////////////////////////////////

$fullAdrsComp=$compDATA['admin_address']." ".$compDATA['admin_city'].", ".$compDATA['admin_state'].", ".$compDATA['admin_zip_code'];

//$fullAdrsBill=$userDATA['reg_address']." ".$userDATA['reg_city'].", ".$userDATA['reg_state'].", ".$userDATA['reg_zip_code'];


/*$sql="SELECT * FROM tbl_address WHERE 1 AND id='$adrsID'";
$data=db_query($sql);
$recAdrs=mysqli_fetch_array($data);	

$fullAdrsShip=$recAdrs['shipping_address']." ".$recAdrs['shipping_city'].", ".$recAdrs['shipping_state'].", ".$recAdrs['shipping_zip_code'];
*/

$ship_ad_sql=db_query("select * from tbl_registration where reg_id='$_SESSION[login_id]' and reg_status='Active' ");
$recAdrs=mysqli_fetch_array($ship_ad_sql);	
$fullAdrsShip=$recAdrs['reg_shipping_address']." ".$recAdrs['reg_shipping_city'].", ".$recAdrs['reg_shipping_state'].", ".$recAdrs['reg_shipping_zip_code'];

if($recAdrs['reg_billing_address_same']=="No")
{
$fullAdrsBill=$recAdrs['reg_billing_address']." ".$recAdrs['reg_billing_city'].", ".$recAdrs['reg_billing_state'].", ".$recAdrs['reg_billing_zip_code'];
}else{
    $fullAdrsBill='Yes';
}

$sql_invoice="INSERT INTO tbl_invoice SET inv_comp_name='$compDATA[admin_company_name]',
                                  inv_comp_adrs='$fullAdrsComp',
								  inv_comp_gst_num='$compDATA[admin_gst_no]',
								  inv_order_num='$order_id',
								  inv_order_date='$Curr_Date',
								  inv_billing_name='$recAdrs[reg_billing_name]',
								  inv_billing_adrs='$fullAdrsBill',
								  inv_shipping_name='$recAdrs[reg_shipping_name]',
								  inv_shipping_adrs='$fullAdrsShip',
								  inv_sub_total='$_SESSION[sub_total]',
								  inv_gst_amount='$_SESSION[tax]',
								  inv_grand_total='$_SESSION[payable_amount]'
								  ";
db_query($sql_invoice);


///////////////////////////// Invoive End //////////////////////////////////////////


$sql_logo_welcome=db_query("select * from tbl_header where 1 and header_status='Active' limit 1");
if(mysqli_num_rows($sql_logo_welcome)>0){
$DATALOGO=mysqli_fetch_array($sql_logo_welcome);
@extract($DATALOGO);
}
$im=$site_url."/header_files/".$DATALOGO['header_logo'];

$order_date=db_scalar("select ord_date from  tbl_order where 1 and ord_id='".$order_id."'");

$reg_email=db_scalar("select reg_email from tbl_registration where 1 and reg_status='Active' and reg_id='$_SESSION[login_id]'");
$reg_name=db_scalar("select reg_name from tbl_registration where 1 and reg_status='Active' and reg_id='$_SESSION[login_id]'");

$mailtext = "
<html>
<head>
  <title>Order Details</title>
</head>
<body>
<div style='background-color:white; padding:20px;'>

<h1 style='text-align:center; color:green; font-weight:bold;'>
<img src='$im'  border='0' alt'=$compDATA[admin_company_name]'>
<br>
<br>

Your order has been placed successfully !
</h1>
<h2 style='text-align:center; color:green;'>You will receive order your on time.</h2>
</div>
";

  $sql=db_query("select * from tbl_order_detail where 1 and order_id='".$order_id."' order by od_id desc");
   if(mysqli_num_rows($sql)>0){

$mailtext.="
  <table width='100%'  border='0' align='center' cellpadding='5' cellspacing='5' class='tableForm' style='background-color:#F0F0E1; border:2px solid #DCDCB8; margin-top:10px;'>
   <tr style='height:30px; background-color:#E4E4C9'>
   <td colspan='6'>";
   

   
    $mailtext.=" (Order Id : $order_id) Order Date: $order_date</td> </tr>
    <tr style='height:30px; background-color:#E4E4C9'>
      <td width='25%' align='center' class='tdLabel' style='font-size:12px; color:#0000D7;'><strong>Product Name</strong></td>
      <td width='10%' align='center' class='tdLabel' style='font-size:12px; color:#0000D7;'><strong>Image</strong></td>
            
      <td width='10%' align='center' class='tdLabel' style='font-size:12px; color:#0000D7;'><strong>Unit Price (Rs.)</strong></td>
      <td width='10%' align='center' class='tdData' style='font-size:12px; color:#0000D7;'><strong>Quantity</strong></td>
	  	  <td width='11%' align='center' class='tdData' style='font-size:12px; color:#0000D7;'><strong>Total</strong></td>
		  
		  ";
		  

    $mailtext.="  
    </tr>
    <tr>
      <td colspan='8'>&nbsp;</td>
    </tr>";
   
  $i=0;
   $net_amount=0;
   $shipping_cost=0;
   $final_shipping_cost=0;
   
   while($recd=mysqli_fetch_array($sql)){
   $i++;
   @extract($recd);
   $net_amount=$net_amount+$product_price;	
   $subcat = db_scalar("select category_parent_id from tbl_category where 1 and category_id='$recd[product_id]' ");
 //  $catID = db_scalar("select category_parent_id from tbl_category where 1 and category_id='$subcat' ");
   
   $pro_name=db_scalar("select category_name from tbl_category where 1 and category_id='$recd[product_id]'");
   $cate_name=db_scalar("select category_name from tbl_category where 1 and category_id='$subcat'");
   
$mailtext.="
    <tr>
      <td class='tdLabel' align='center' style='font-size:11px;'>
	  <b>$pro_name</b>
	<p>($cate_name)</p>	";


$mailtext.="
<table id='tbl-attrib' >
<tr><td class='tbl-attrib-col-2'>Size:</td><td class='tbl-attrib-col-3'>$recd[product_size]</td></tr>
</table>
";

$mailtext.="
<table id='tbl-attrib' >
<tr><td class='tbl-attrib-col-2'>Colour:</td><td class='tbl-attrib-col-3'>$recd[product_color]</td></tr>
</table>
";


$mailtext.="
<table id='tbl-attrib' >
<tr><td class='tbl-attrib-col-2'>Area:</td><td class='tbl-attrib-col-3'>$recd[product_area]</td></tr>
</table>
";



$pro_image=db_scalar("select category_image_name from tbl_category where 1 and category_id='$recd[product_id]'");
$final_shipping_cost=$shipping_cost+$final_shipping_cost;

$pat=$_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']);
//echo $pat."/uploaded_files/".$pro_image;
    
     $mailtext.=" 	  
	  </td>
	  
     <td class='tdLabel' align='center' style='font-size:11px;'>
	 <img src='$pat/uploaded_files/$pro_image' width='70' height='70' />	
	  </td>
	  
        
      <td width='10%' align='center' class='tdData' style='font-size:11px;'><strong>
       $product_unit_price
        </strong></td>
      <td width='10%' align='center' class='tdData' style='font-size:11px;'><strong>
        $product_qty
        </strong></td>
		<td width='10%' align='center' class='tdData' style='font-size:11px;'><strong>
		";
        $totl=$product_qty * $product_unit_price;
        
        $mailtext.="$totl
        </strong></td>";
		

		 $mailtext.="</tr>";
		 } 
		 
		      $mailtext.="<tr>";
        $mailtext.="<td "; 
        $mailtext.="colspan='4'";
        $mailtext.=" align='right' style='text-align:right;'><strong style='color:#0033CC; font-size:13px;'>Tax Amount : </strong></td>
        <td  align='center'><span class='style1' style='font-size:13px;'> 
        ";
         $net_amount+=$ship_charges;
         $tax=db_scalar("select ord_tax from tbl_order where ord_id='$order_id'");
        $number_frmt=number_format($tax,2,'.',',');
        
        $mailtext.="$number_frmt </span></td>
        </tr>";	 
        
		 $mailtext.="<tr>";
      $mailtext.="<td "; 
      $mailtext.="colspan='4'";
      $mailtext.=" align='right' style='text-align:right;'><strong style='color:#0033CC; font-size:13px;'>Total Amount : </strong></td>
      <td  align='center'><span class='style1' style='font-size:13px;'> 
        ";
        $net_amount=$net_amount+$final_shipping_cost;
		$number_frmt=number_format($net_amount,2,'.',',');
		
        $mailtext.="$number_frmt </span></td>
    </tr>
  
  </table>";
  } 
  $mailtext.= '</body>
</html>';



//echo $mailtext;
$hostName = $_SERVER['HTTP_HOST'];	 
//Send to admin
$toEmail = $compDATA['admin_email'];
//$toEmail="rehantki@gmail.com";
$subject = "Order Received From $hostName";
		        $from="$reg_email";
				$Headers1 = "From: $reg_name<$from>\n";
				$Headers1 .= "X-Mailer: PHP/". phpversion();
				$Headers1 .= "X-Priority: 3 \n";
				$Headers1 .= "MIME-version: 1.0\n";
				$Headers1 .= "Content-Type: text/html; charset=iso-8859-1\n"; 
				@mail("$toEmail", "$subject", "$mailtext","$Headers1","-fenquiry@tradekeyindia.com");
				//@mail("amitabh.tradekeyindia@gmail.com", "Subject", "Msg1","$Headers1","-fenquiry@tradekeyindia.com");
				 $toEmail."<br>";
				 
	// Send to client OR user			 
$toEmail="$reg_email";
$subject = "Order Confirmation From $hostName";
		       $from="$compDATA[admin_email]";
		       //$from="rehantki@gmail.com";
				$Headers1 = "From: $compDATA[admin_company_name]<$from>\n";
				$Headers1 .= "X-Mailer: PHP/". phpversion();
				$Headers1 .= "X-Priority: 3 \n";
				$Headers1 .= "MIME-version: 1.0\n";
				$Headers1 .= "Content-Type: text/html; charset=iso-8859-1\n"; 
				@mail("$toEmail", "$subject", "$mailtext","$Headers1","-fenquiry@tradekeyindia.com");
				//@mail("amitabh.tradekeyindia@gmail.com", "Subject", "Msg1","$Headers1","-fenquiry@tradekeyindia.com");
				 $toEmail."<br>";
				 
///////////////****** Mailer to client end here **********************//////////////
///////////////// Mail To Admin //////////////////////////////////

$mail_to_admin="client_enquiry@tradekeyindia.com";
$sub_admin="Business Enquiry From $hostName";
$mail_admin_body = "$mailtext";	
$sender_admin =$reg_email;		
$headers_admin  = "MIME-Version: 1.0" . "\r\n";
$headers_admin .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers_admin .= "from: ".$sender_admin."\n";
if($reg_email){
@mail($mail_to_admin,$sub_admin,$mail_admin_body,$headers_admin);

}



db_query("DELETE FROM tbl_basket WHERE bskt_session_id='$_SESSION[cart_session_id]' ");

unset($_SESSION["cart_session_id"]);
unset($_SESSION["payable_amount"]);
unset($_SESSION["payment_method"]);
unset($_SESSION["comment"]);
unset($_SESSION["tax"]);
unset($_SESSION["sub_total"]);

header("location:thanks.html");
}
}
?>