72da7fd6d1302c0a159f6436d01e9eb0

Edit file

File name : export-store-report.php

Content :

<?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_storename']!=''){
$name=$_REQUEST['search_storename']	;
$where.=" and ot.storeid = '$name'";	
}
if($_REQUEST['order_status']!=''){
$name=$_REQUEST['order_status']	;
$where.=" and o.order_status='".$name."'";		
}
if($_REQUEST['payment_status']!=''){
$name=$_REQUEST['payment_status']	;
$where.=" and o.payment_status='".$name."'";		
}
if($_REQUEST['search_from_date']!='' && $_REQUEST['search_to_date']!=''){
$where.=" and o.order_date>='".$_REQUEST['search_from_date']."' and o.order_date<='".$_REQUEST['search_to_date']."' ";
}
$storeid=$obj->query("select storename,tbl_store_zip.commission from stores left join tbl_store_zip on stores.storeid=tbl_store_zip.storeid where stores.storeid='".$_REQUEST['search_storename']."'");
$resultstore=$obj->fetchNextObject($storeid);

$sql=$obj->Query("select o.id, sum(ot.wh_price*qty) as cartamt, sum(ot.wh_price*qty)-((sum(ot.wh_price*qty)*$resultstore->commission)/100)-(((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100) as paistoStore, (sum(ot.wh_price*qty)*$resultstore->commission)/100 as comm, sum(ot.wh_tax_value*qty) as totaltax,((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100 as ccfee, o.delivery_type,o.order_date from tbl_order o left join tbl_order_itmes ot on o.id=ot.order_id where o.order_date>'2020-04-01' $where group by o.id order by o.id");

$csvData='';
$csvData.="Order ID, Cart Amount, Amount Paid to ".$resultstore->storename.", Refund Processed (due to items unavailability), Quicklly Commission, Total Sales Tax, CC Fees, Order Date & Time";
$csvData.="\n\r";
$reccnt=$obj->numRows($sql);

if($reccnt>0){
    $count=1;
    while($data=$obj->fetchNextObject($sql)){
																	
  	$csvData.=$data->id.",";	
	$csvData.=$website_currency_symbol.number_format($data->cartamt,2).",";
	$csvData.=$website_currency_symbol.number_format($data->paistoStore,2).",";
	$csvData.=",";
	$csvData.=$website_currency_symbol.number_format($data->comm,2).",";
	$csvData.=$website_currency_symbol.number_format($data->totaltax,2).",";
	$csvData.=$website_currency_symbol.number_format($data->ccfee,2).",";
	$csvData.=date('d M Y H:i',strtotime($data->order_date)).",";
	$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=Tax-Report-".date("dMY_H:i").".csv");
echo $csvData;
exit;
header("location:".$_SERVER['HTTP_REFERER']);
exit();
}
?>

Gel4y Mini Shell

Edit file