<?php 
include("../include/config.php");

function getFieldWhere($filed,$tbl,$where,$id){
$sql=mysqli_query($GLOBALS['conn'],"select $filed as field from $tbl  where $where='".$id."'");
$result=mysqli_fetch_assoc($sql);
return (stripslashes($result['field']));
}

if($_REQUEST['exportExcel']=='yes'){
$where='';
if($_REQUEST['search_order_id']!=''){
$name=$_REQUEST['search_order_id'];
$where.=" and order_id like '%$name%'";	
}
if($_REQUEST['search_user_id']!=''){
$name=$_REQUEST['search_user_id'];
$where.=" and user_id='".$name."'";	
}
if($_REQUEST['search_storename']!=''){
$name=$_REQUEST['search_storename'];
$where.=" and storeid ='".$name."' ";	
}
if($_REQUEST['search_orderstatus']!=''){
$name=$_REQUEST['search_orderstatus'];
$where.=" and order_status ='".$name."' ";	
}

if($_REQUEST['search_from_date']!='' && $_REQUEST['search_to_date']!=''){
$where.=" and order_date>='".$_REQUEST['search_from_date']."' and order_date<='".$_REQUEST['search_to_date']."' ";
}

$sql=$obj->Query("select customer_fname,customer_lname,concat(order_id,'-') as order_id,sum(sell_price*qty) as total_amount,ship_pincode,delivery_street_1,delivery_street_2,delivery_city,delivery_state,country,storeid,section,order_status,order_date from  insta_order_itmes where 1=1 $where group by order_id order by order_id desc");

$csvData.="Sl no.,Order Id,Total Amount,Customer Name,Customer Address,Zipcode,Store Name,Section Name,Order Status,Order Date\n";
$reccnt=$obj->numRows($sql);

if($reccnt>0){
    $count=1;
    while($data=$obj->fetchNextObject($sql))
    {  
    $address=$data->delivery_street_1." ".$data->delivery_street_2." ".$data->delivery_city." ".$data->delivery_state." ".$data->country;
    $address=str_replace(',','',$address);
    $csvData.=$count.","; 
  	$csvData.=$data->order_id.",";
	$csvData.=$data->total_amount.",";
	$csvData.=$data->customer_fname." ".$data->customer_lname.",";
	$csvData.=$address.",";
	$csvData.=$data->ship_pincode.",";
	$csvData.=getFieldWhere('storename','insta_stores','storeid',$data->storeid).",";	
	$csvData.=getFieldWhere('section_name','insta_section','id',$data->section).","; 
	$csvData.=getFieldWhere('order_status','insta_order_status','id',$data->order_status).","; 
	$csvData.=date('d-m-Y H:i',strtotime($data->order_date)).",";
	$csvData.="\n";        
    $count++;    
    } }
				
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: text/csv; charset=utf-8");
header("Content-Disposition: attachment; filename=Instacart-Sales-Report-".date("d-m-Y-H:i").".csv");
echo $csvData;
exit;
}
?>