<?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 id='".$name."'";	
}
if($_REQUEST['search_email']!=''){
$name=$_REQUEST['search_email']	;
$where.=" and bill_email like '%$name%' ";	
}
if($_REQUEST['search_payment_method']){
$name=$_REQUEST['search_payment_method']	;
$where.=" and payment_method like '%$name%' ";		
}
if($_REQUEST['search_order_status']!=''){
$name=$_REQUEST['search_order_status']	;
$where.=" and order_status='".$name."'";		
}
if($_REQUEST['search_from_date']!='' && $_REQUEST['search_to_date']!=''){
if($_REQUEST['search_from_date']==$_REQUEST['search_to_date']){
$where.=" and order_date>='".$_REQUEST['search_from_date']."'";	
} else {
$where.=" and order_date>='".$_REQUEST['search_from_date']."' and order_date<='".$_REQUEST['search_to_date']."' ";
}
}
if($_REQUEST['storename']){
$name=$_REQUEST['storename']	;
$where.=" and storeid='".$name."'";		
}
if($_REQUEST['raitingstatus']){
$name=$_REQUEST['raitingstatus']	;
$where.=" and rating_status like '%$name%' ";		
}
if($_REQUEST['overallrating']){
$name=$_REQUEST['overallrating']	;
$where.=" and overall_rating='".$name."'";		
}
if($_REQUEST['state']!=''){
$name=$_REQUEST['state']	;
$where.=" and d.stateCode like '%$name%' ";	
}
$order_by=' id ';
$order_by2=' desc ';  
$sql=$obj->Query("select  c.*,d.stateCode,d.state from $tbl_order as c left join tbl_us_zipcodes as d on d.zipCode=c.ship_pincode where 1=1 $where order by $order_by $order_by2 ",$debug=-1);

$csvData='';
$csvData.="Order Date,Order ID, Store ID, User ID ,Email, State, Rating Status,Overall Rating,Overall Review,Order Status,Payment Status  ";
$csvData.="\n\r";
$reccnt=$obj->numRows($sql);

if($reccnt>0){
    $count=1;
	
    while($data=$obj->fetchNextObject($sql))
    {   

  	$csvData.=date('d/m/Y',strtotime($data->order_date)).",";
	$csvData.=$data->id.",";
	$csvData.=$data->storeid.",";
	$csvData.=stripslashes($data->user_id).",";
	$csvData.=stripslashes($data->ship_email).",";
	$csvData.=stripslashes($data->stateCode).",";
	$csvData.=stripslashes($data->rating_status).",";
	$csvData.=stripslashes($data->overall_rating).",";
	$csvData.=stripslashes($data->overall_review).",";
	$csvData.=getField('order_status',$tbl_order_status,$data->order_status).",";
	if($data->payment_status==1){
	$csvData.="Successful,";
	}else{
	$csvData.="Unsuccessful,";
	}
	$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=Overall-Order-Rating-Report-".date("dMY_H:i").".csv");
echo $csvData;
exit;
header("location:".$_SERVER['HTTP_REFERER']);
exit();
}
?>