<?php 
include("../include/config.php");
include("../include/functions.php"); 
if($_REQUEST['exportExcel']=='yes'){
$where='';
$where='';
if($_REQUEST['search_coupon_code']!=''){
$name=$_REQUEST['search_coupon_code'];
$where.=" and coupon_code='".$name."'";	
}
if($_REQUEST['source_id']!=''){
$source_id=$_REQUEST['source_id'];
$where.=" and o.cp_source='".$source_id."'";	
}
if($_REQUEST['search_from_date']!='' && $_REQUEST['search_to_date']!=''){
$where.="and date(o.order_date)>='".$_REQUEST['search_from_date']."' and date(o.order_date)<='".$_REQUEST['search_to_date']."' ";
}
$order_by=' id ';
$order_by2=' desc ';  
//$sql=$obj->Query("select * from $tbl_coupon where 1=1 $where order by $order_by $order_by2 ",$debug=-1);
$cpReportSql = $obj->Query("SELECT o.id,o.order_via,o.amount,o.total_amount as orderAmount,o.discount,o.discount_via,o.coupon_code,o.order_date,o.order_status,o.payment_status, o.cp_source,cs.name FROM `tbl_order` o left join coupon_source as cs on cs.id=o.cp_source WHERE o.payment_status=1 and (o.discount_via !='') and o.coupon_code !='' $where order by $order_by $order_by2 "); 
//$csvData='';
$csvData.="Order ID,Order Amount, Order Date ,Coupon Code,Source";
$csvData.="\n";
$reccnt=$obj->numRows($cpReportSql);

if($reccnt>0){
    $count=1;
    while($data=$obj->fetchNextObject($cpReportSql))
    {   

    //$cpSrc = coupon_source_name($data->cp_source);
  	$csvData.=stripslashes($data->id).",";
	$csvData.=stripslashes($data->orderAmount).",";
	$csvData.=stripslashes($data->order_date).",";
	$discount='';
	$csvData.=stripslashes($data->coupon_code).",";	
	$csvData.=stripslashes($data->name).",";	
	$csvData.="\n";        
    $count++;    
    } }
ob_end_clean();				
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/csv");
header("Content-Disposition: attachment; filename=Coupon-Revenue-Report-".date("dMY_H:i").".csv");
echo $csvData;
exit;
header("location:".$_SERVER['HTTP_REFERER']);
exit();
}
?>