<?php 
include("../include/config.php");
include("../include/functions.php"); 
if($_REQUEST['exportExcel']=='yes'){
$where='';
if($_REQUEST['search_order_id']!=''){
$name=$_REQUEST['search_order_id'];
$where.=" and o.id='".$name."'";	
}
if($_REQUEST['search_storename']!=''){
$name=$_REQUEST['search_storename']	;
$where.=" and ot.storeid = '$name'";	
}
if($_REQUEST['order_status']!=''){
$name=$_REQUEST['order_status']	;
$where.=" and o.order_status='".$name."'";		
}
if($_REQUEST['payment_status']!=''){
$name=$_REQUEST['payment_status']	;
$where.=" and o.payment_status='".$name."'";		
}
if($_REQUEST['search_from_date']!='' && $_REQUEST['search_to_date']!=''){
$where.=" and o.order_date>='".$_REQUEST['search_from_date']."' and o.order_date<='".$_REQUEST['search_to_date']."' ";
}
$storeid=$obj->query("select storename from stores where stores.storeid='".$_REQUEST['search_storename']."'");
$resultstore=$obj->fetchNextObject($storeid);

$sql=$obj->Query("select o.id, sum(ot.wh_price*qty) as cartamt, sum(ot.wh_price*qty)-((sum(ot.wh_price*qty))/100)-(((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100) as paistoStore, (sum(ot.wh_price*qty))/100 as comm, sum(ot.wh_tax_value*qty) as totaltax,((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100 as ccfee, o.delivery_type,o.order_date from go_order o left join go_order_itmes ot on o.id=ot.order_id where o.order_date>'2020-04-01' $where group by o.id order by o.id");

$csvData='';
$csvData.="Order ID, Cart Amount, Amount Paid to ".$resultstore->storename.", Refund Processed (due to items unavailability), Quicklly Commission, Total Sales Tax, CC Fees, Order Date & Time";
$csvData.="\n\r";
$reccnt=$obj->numRows($sql);

if($reccnt>0){
    $count=1;
    while($data=$obj->fetchNextObject($sql)){
																	
  	$csvData.=$data->id.",";	
	$csvData.=$website_currency_symbol.number_format($data->cartamt,2).",";
	$csvData.=$website_currency_symbol.number_format($data->paistoStore,2).",";
	$csvData.=",";
	$csvData.=$website_currency_symbol.number_format($data->comm,2).",";
	$csvData.=$website_currency_symbol.number_format($data->totaltax,2).",";
	$csvData.=$website_currency_symbol.number_format($data->ccfee,2).",";
	$csvData.=date('d M Y H:i',strtotime($data->order_date)).",";
	$csvData.="\n\r";        
    $count++;    
    } }
				
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/csv");
header("Content-Disposition: attachment; filename=Tax-Report-".date("dMY_H:i").".csv");
echo $csvData;
exit;
header("location:".$_SERVER['HTTP_REFERER']);
exit();
}
?>