<?php 
include("../include/config.php");
$objmithaas = new DB($db_namemithaas, $hostmithaas, $usernamemithaas, $passwordmithaas);
function getField($filed,$table,$id) {
$sql=mysqli_query($GLOBALS['conn'],"select $filed as field from $table where id='$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 id='".$name."'";	
}
if($_REQUEST['search_email']!=''){
$name=$_REQUEST['search_email']	;
$where.=" and ship_email like '%$name%' ";	
}
/*if($_REQUEST['search_customer_type']!=''){
$name=$_REQUEST['search_customer_type'];
$where.=" and id='".$name."'";	
}
if($_REQUEST['search_storename']!=''){
$name=$_REQUEST['search_storename'];
$where.=" and id='".$name."'";	
}*/
if($_REQUEST['search_orderstatus']!=''){
$name=$_REQUEST['search_orderstatus'];
$where.=" and order_status='".$name."'";		
}
if($_REQUEST['search_ordertype']!=''){
$name=$_REQUEST['search_ordertype'];
$where.=" and order_type='".$name."'";	
}
if($_REQUEST['search_paymentstatus']!=''){
$name=$_REQUEST['search_paymentstatus'];
$where.=" and payment_status='".$name."'";	
}
if($_REQUEST['search_device']!=''){
$name=$_REQUEST['search_device'];
$where.=" and order_via='".$name."'";	
}
if($_REQUEST['search_user_id']!=''){
$name=$_REQUEST['search_user_id'];
$where.=" and user_id='".$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']."' ";
}
$csvData='';
$columnArray=$_POST['order_search'];

if(in_array(1, $columnArray)){
	$csvData.="Order ID,";
}
if(in_array(2, $columnArray)){
	$csvData.="Order Amount,";
}
if(in_array(3, $columnArray)){
	$csvData.="Order Type,";
}
if(in_array(4, $columnArray)){
	$csvData.="Order Status,";
}
if(in_array(5, $columnArray)){
	$csvData.="Order Date,";
}
if(in_array(6, $columnArray)){
	$csvData.="Order Via,";
}
if(in_array(7, $columnArray)){
	$csvData.="Payment Status,";
}
if(in_array(8, $columnArray)){
	$csvData.="Customer ID,";
}
if(in_array(9, $columnArray)){
	$csvData.="Customer Email,";
}
if(in_array(10, $columnArray)){
	$csvData.="Customer Phone,";
}
if(in_array(11, $columnArray)){
	$csvData.="Customer Name,";
}
if(in_array(12, $columnArray)){
	$csvData.="Customer Address,";
}
if(in_array(13, $columnArray)){
	$csvData.="Customer City,";
}
if(in_array(14, $columnArray)){
	$csvData.="Customer State,";
}
if(in_array(15, $columnArray)){
	$csvData.="Customer Zipcode,";
}

$sql=$objmithaas->Query("select id,order_date,order_status,total_amount,order_type,order_via,payment_status,user_id,ship_email,ship_mobile,ship_fname,ship_lname,ship_street,ship_complex,ship_city_id,ship_state,ship_pincode from $tbl_order where 1=1 $where order by id",$debug=-1);

$reccnt=$objmithaas->numRows($sql);

if($reccnt>0){
    while($data=$objmithaas->fetchNextObject($sql)){  
    $csvData.="\n"; 
  	if(in_array(1, $columnArray)){
	$csvData.=$data->id.",";
  	}
	if(in_array(2, $columnArray)){
		$csvData.=$website_currency_symbol.$data->total_amount.",";
	}
	if(in_array(3, $columnArray)){
		$csvData.=$data->order_type.",";
	}
	if(in_array(4, $columnArray)){
	$csvData.=getField('order_status',$tbl_order_status,$data->order_status).",";
	}
  	if(in_array(5, $columnArray)){
  		$csvData.=date('d/m/Y',strtotime($data->order_date)).",";
  	}
  	if(in_array(6, $columnArray)){
  		$csvData.=$data->order_via.",";
  	}
  	if(in_array(7, $columnArray)){
	if($data->payment_status==1){
	$csvData.="Successful,";
	}else{
	$csvData.="Unsuccessful,";
    } }
	if(in_array(8, $columnArray)){
		$csvData.=stripslashes($data->user_id).",";
	}
	if(in_array(9, $columnArray)){
		$csvData.=stripslashes(str_replace(',',' ',$data->ship_email)).",";
	}
	if(in_array(10, $columnArray)){
		$csvData.=stripslashes($data->ship_mobile).",";
	}
	if(in_array(11, $columnArray)){
		$csvData.=stripslashes($data->ship_fname.' '.$data->ship_lname).",";
	}
	if(in_array(12, $columnArray)){
		$csvData.=stripslashes(str_replace(',',' ',$data->ship_complex).' '.str_replace(',',' ',$data->ship_street)).",";
	}
	if(in_array(13, $columnArray)){
		$csvData.=stripslashes($data->ship_city_id).",";
	}
	if(in_array(14, $columnArray)){
		$csvData.=stripslashes($data->ship_state).",";
	}
	if(in_array(15, $columnArray)){
		$csvData.=stripslashes($data->ship_pincode).",";
	}
    } 
}
				
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/csv");
header("Content-Disposition: attachment; filename=Mithaas-Orders-Report-".date("dMY_H:i").".csv");
echo $csvData;
exit;
}
?>