<?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 tbl_order.id='".$name."'";	
}
if($_REQUEST['search_email']!=''){
$name=$_REQUEST['search_email']	;
$where.=" and bill_email like '%$name%' ";	
}
if($_REQUEST['order_status']!=''){
$name=$_REQUEST['order_status']	;
$where.=" and order_status='".$name."'";		
}
if($_REQUEST['payment_status']!=''){
$name=$_REQUEST['payment_status']	;
$where.=" and payment_status='".$name."'";		
}
if($_REQUEST['search_from_date']!='' && $_REQUEST['search_to_date']!=''){
$where.=" and tbl_order.order_date>='".$_REQUEST['search_from_date']."' and tbl_order.order_date<='".$_REQUEST['search_to_date']."' ";
}
$order_by=' tbl_order.id ';
$order_by2=' desc ';  

$storeid=$obj->query("select storeid,commission from stores where 1=1 and uid like '%$loged_userid%'");
$resstore=$obj->fetchNextObject($storeid);

$sql=$obj->Query("select *,tbl_order.id,tbl_order.user_id,tbl_order.discount,tbl_order.order_date,tbl_order.order_status,tbl_order.total_amount from $tbl_order left join tbl_order_itmes on tbl_order.id=tbl_order_itmes.order_id where 1=1 and tbl_order_itmes.storeid='$resstore->storeid' $where group by tbl_order_itmes.order_id order by $order_by $order_by2",$debug=-1);

$csvData='';
$csvData.="Order ID, Cart Amount, Amount Paid to Fresh Farms, Grocery, Produce, Non Food, Soda, Refund Processed (due to items unavailability), Discount, Discount Via, MyValue365 Commission, Low Tax, High Tax, City of Chicago/Soda Tax, Total Sales Tax, Delivery Type, Delivery Charge/Fresh Farms Coupon, Driver Tip, CC Fees, Total Amount, Order Date & Time";
$csvData.="\n\r";
$reccnt=$obj->numRows($sql);

if($reccnt>0){
    $count=1;
    while($data=$obj->fetchNextObject($sql)){
$grocery_items = 0;
																$low_tax_items = 0;
																$high_tax_items = 0;
																$soda_tax_items = 0;
																
																$breakUp = mysqli_query($GLOBALS['conn'],"SELECT tbl_order_itmes.qty, tbl_order_itmes.price, tbl_order_itmes.order_id, tbl_productprice.product_id as product_id, tbl_productprice.tax_method, tbl_order_itmes.price * tbl_order_itmes.qty AS total FROM tbl_order_itmes LEFT JOIN tbl_productprice ON tbl_order_itmes.product_id = tbl_productprice.id WHERE tbl_order_itmes.order_id = ".$data->id." and tbl_order_itmes.storeid=".$resstore->storeid."");
																
																
																while($breakUpResults = mysqli_fetch_assoc($breakUp))
																{
																	if(trim($breakUpResults['tax_method']) == 'Low Tax')
																	{
																		$grocery = mysqli_query($GLOBALS['conn'],"select categories from tbl_product where id=".$breakUpResults['product_id']);
																		$result_grocery = mysqli_fetch_assoc($grocery);
																		$category_ids = explode(",", $result_grocery['categories']);
																		if(!(in_array("4337", $category_ids)))
																			$grocery_items+= $breakUpResults['total'];
																		else
																			$low_tax_items+= $breakUpResults['total'];
																	}
																	if(trim($breakUpResults['tax_method']) == 'High Tax')
																		$high_tax_items+= $breakUpResults['total'];
																	if(trim($breakUpResults['tax_method']) == 'City of Chicago/Soda Tax')
																		$soda_tax_items+= $breakUpResults['total'];
																}
																

$storecount=$obj->query("SELECT COUNT(DISTINCT storeid) as scount from tbl_order_itmes where order_id='$data->id'");
$rs=$obj->fetchNextObject($storecount);
$scount=$rs->scount;
$count++;

$storetotal=$obj->query("select * from tbl_order_itmes where order_id='$data->id'");
																		$strtot=$obj->fetchNextObject($storetotal);
																		if($strtot->storeid=='0')
																		{
																			$userpaid=number_format($data->total_amount,2);
																			$carttot=number_format($data->total_amount,2);
																		} 
																		else 
																		{
																			$totalamt=0;
																			$carttotal=0;
																			$storetotal=$obj->query("select * from tbl_order_itmes where order_id='$data->id' and storeid='$data->storeid'");
																			
																			while($totalres=$obj->fetchNextObject($storetotal))
																			{
																				$totalamt=$totalamt+$totalres->price*$totalres->qty+$totalres->tax_value*$totalres->qty;
																				$carttotal=$carttotal+$totalres->price*$totalres->qty;
																			}
																			//Modified to deduct discount from total order value
																			$totalamt = $totalamt - ($data->discount/$scount);

																			$userpaid=number_format($totalamt,2);
																			$carttotal=number_format($carttotal,2);
																		
																			
																			//condition for Delivery Charge
																			if($resstore->storeid=='100'){
																				
																				//commented for the month of May 18
																				//echo $line->total_amount;
																				 if($totalamt>= 30 && $totalamt<40){
																				$data->shipping_amount = 6;
																				 }
																				 if($totalamt>=40){
																					 $data->shipping_amount = 10;
																				 }
																				//$10 calculation should be on Total cart value 
																				// if(($totalamt + $line->discount/$scount)>=30)
																					// $line->shipping_amount = 10;

																			}else{
																				$data->shipping_amount=$data->shipping_amount/$scount;
																			}
																		
																		}
$pricePaidTostore = ($userpaid - ($data->shipping_amount + $data->drivertip/$scount + ($carttotal*$resstore->commission/100) + ($userpaid*2.99/100)));
$myvalcomm=$carttotal*$resstore->commission/100;
$lowtotal=0;
$hightotal=0;
$citytotal=0;
$storelowtax=$obj->query("select * from tbl_order_itmes where order_id='$data->id' and storeid='$data->storeid' and tax_method='Low Tax'");
																		while($totallow=$obj->fetchNextObject($storelowtax)){
$lowtotal=$lowtotal+$totallow->tax_value*$totallow->qty;}
$storehightax=$obj->query("select * from tbl_order_itmes where order_id='$data->id' and storeid='$data->storeid' and tax_method='High Tax'");
																		while($totalres=$obj->fetchNextObject($storehightax)){
$hightotal=$hightotal+$totalres->tax_value*$totalres->qty;}
$storecitytax=$obj->query("select * from tbl_order_itmes where order_id='$data->id' and storeid='$data->storeid' and tax_method='City of Chicago/Soda Tax'");
																		while($totalres=$obj->fetchNextObject($storecitytax)){
$citytotal=$citytotal+$totalres->tax_value*$totalres->qty;}
																																
  	$csvData.=$data->id.",";	
	$csvData.=$website_currency_symbol.$carttotal.",";
	$csvData.=$website_currency_symbol.number_format($pricePaidTostore,2).",";
	$csvData.=$website_currency_symbol.number_format($grocery_items,2).",";
	$csvData.=$website_currency_symbol.number_format($low_tax_items,2).",";
	$csvData.=$website_currency_symbol.number_format($high_tax_items,2).",";
	$csvData.=$website_currency_symbol.number_format($soda_tax_items,2).",";
	$csvData.=",";
	$csvData.=$website_currency_symbol.number_format($data->discount/$scount,2).",";
	$csvData.=stripslashes($data->discount_via).",";
	$csvData.=$website_currency_symbol.number_format($myvalcomm,2).",";
	$csvData.=$website_currency_symbol.number_format($lowtotal,2).",";
	$csvData.=$website_currency_symbol.number_format($hightotal,2).",";
	$csvData.=$website_currency_symbol.number_format($citytotal,2).",";
	$csvData.=$website_currency_symbol.number_format($lowtotal+$hightotal+$citytotal,2).",";
	$csvData.=$website_currency_symbol.$data->delivery_type.",";
	$csvData.=$website_currency_symbol.number_format($data->shipping_amount,2).",";
	$csvData.=$website_currency_symbol.number_format($data->drivertip/$scount,2).",";
	$csvData.=$website_currency_symbol.number_format(($totalamt*2.99/100),2).",";
$csvData.=$website_currency_symbol.$data->total_amount.",";
	$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();
}
?>