<?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_user_id']!=''){
$name=$_REQUEST['search_user_id'];
$where.=" and e.user_id='".$name."'";	
}
if($_REQUEST['storename']!=''){
$name=$_REQUEST['storename'];
$where.=" and e.event_store_id='".$name."'";	
}
if($_REQUEST['search_email']!=''){
$name=$_REQUEST['search_email']	;
$where.=" and o.ship_email like '%$name%' ";	
}
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']."' ";
}
if($_REQUEST['search_payment_status'] || $_REQUEST['search_payment_status']=='0'){

$name=$_REQUEST['search_payment_status']	;

$where.=" and o.payment_status ='".$name."'";		

}
if($_REQUEST['event_status'] || $_REQUEST['event_status']=='0'){
if($_REQUEST['event_status']=='0'){
    
    $where.=" and e.event_cancel_reason!='' ";
} else {
   $where.=" and e.event_cancel_reason='' "; 
}
}
if($_REQUEST['search_pid']!=''){

$name=$_REQUEST['search_pid']	;

$where.=" and p.id='".$name."'";		

}


$order_by='o.id';
$order_by2=' desc ';  
$sql=$obj->Query("SELECT  e.id, e.event_product_id, e.order_id, e.user_name,e.user_id,e.event_store_id, e.event_name, e.total_qty, e.total_amount, e.event_time, 
                            e.event_from_date, e.event_to_date, e.event_address, e.latitude, e.longitude, e.event_qr_code_image, 
                            e.event_cancel_date, e.event_cancel_reason,e.event_remarks,e.event_status,o.payment_status, o.order_date,o.ship_fname,o.ship_lname,o.ship_email,o.ship_mobile, p.photo_wide, m.last_event_cancel_date, 
                            m.cancel_duduction_type, m.cancel_duduction_amount,e.service_fee_amount, i.tax_value,e.convenience_fee_amount
                    FROM    tbl_order_event e 
                            INNER JOIN tbl_order o ON e.order_id = o.id
							INNER JOIN tbl_order_itmes i ON i.order_id = e.order_id AND i.product_id = e.event_product_id
                            INNER JOIN tbl_product p ON p.id = e.event_product_id
                            INNER JOIN tbl_event_meta m ON m.id = e.event_id where 1=1 $where order by $order_by $order_by2",$debug=-1);

$csvData='';
$csvData.="Order Date,Order ID, Email, Phone, Name, Event Name, Event Date, Total Amount,Ticket Qty, Ticket Type, Refund Amount, Store Name, Event Status, Payment Status, Event Cancel Date, Reson for Cancel";
$csvData.="\n";
$reccnt=$obj->numRows($sql);

if($reccnt>0){
    $count=1;
    while($data=$obj->fetchNextObject($sql))
    {   
        
    	$cancelCharge = 0;
            $total = $data->total_amount + $data->tax_value + $data->service_fee_amount+$data->convenience_fee_amount;
            $cancelCharge = number_format((float)$data->service_fee_amount,2);
            $refundAmt = number_format((float)$total - (float)$cancelCharge,2);
            
$rstorename=getFieldWhere('storename', 'stores', 'storeid', $data->event_store_id);
  $fromDate = strtotime($data->event_from_date);
 $toDate = strtotime($data->event_to_date);
																
			 if($fromDate == $toDate)
                $fromDate = date('d M Y', $fromDate);
            else
                $fromDate = date('d M Y', $fromDate) . ' - ' . date('d M Y', $toDate);	 
                
                 $isCancelled = false;
            if($data->event_cancel_reason != null && $data->event_cancel_reason != ''){
                $isCancelled = true;
            }
                 if($isCancelled==false){
																			 $evstaus='Active';
																		  } else {
																			 $evstaus='Cancel';
																			  
																		  }
	if($data->payment_status==1){
																			 $paystatus='Success';
																		  } else {
																			 $paystatus='Declined';
																			  
																		  }
	if($data->event_cancel_date=='0000-00-00 00:00:00'){
	    $data->event_cancel_date='';
	}
	 
  	$csvData.=date('d/m/Y',strtotime($data->order_date)).",";
	$csvData.=$data->order_id.",";
	$csvData.=stripslashes($data->ship_email).",";
	$csvData.=stripslashes($data->ship_mobile).",";
	$csvData.=stripslashes($data->ship_fname).",";
	$csvData.=stripslashes($data->event_name).",";
	$csvData.=stripslashes($fromDate).",";
	$csvData.=stripslashes($total).",";
	$csvData.=stripslashes($data->total_qty).",";
	$csvData.=stripslashes($data->event_remarks).",";
	$csvData.=stripslashes($refundAmt).",";
	$csvData.=stripslashes($rstorename).",";
	$csvData.=stripslashes($evstaus).",";
	$csvData.=stripslashes($paystatus).",";
	$csvData.=stripslashes($data->event_cancel_date).",";
	$csvData.=stripslashes($data->event_cancel_reason).",";
	$csvData.="\n";        
    $count++;    
    } }
				
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/csv");
header("Content-Disposition: attachment; filename=Order-Event-Report-".date("dMY_H:i").".csv");
echo $csvData;
exit;
header("location:".$_SERVER['HTTP_REFERER']);
exit();
}
?>