07e1cd7dca89a1678042477183b7ac3f

Server: devadmin.goquicklly.com (216.73.216.210)
PHP Uname: Linux 94.45.167.72.host.secureserver.net 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64

Edit file

File name : export-sellers.php

Content :

<?php 
include("../include/config.php");
include("../include/functions.php"); 
if($_REQUEST['exportExcel']=='yes'){
$where='';
if($_REQUEST['sellername_id']!=''){
$name=$_REQUEST['sellername_id'];
$where.=" and (uid='".$name."' or companyname like '%$name%')";	
}

if($_REQUEST['store']!=''){
$name=$_REQUEST['store'];
$where.=" and storename like '%$name%'";	
}
if($_REQUEST['search_email']!=''){
$name=$_REQUEST['search_email']	;
$where.=" and (emailid like '%$name%' or mobile like '%$name%')";	
}
if($_REQUEST['zip_area']){
$name=$_REQUEST['zip_area']	;
$where.=" and (ziparea like '%$name%' or zipcode='".$name."') ";		
}
if($_REQUEST['pan']!=''){
$name=$_REQUEST['pan']	;
$where.=" and pan like '%$name%'";		
}
$order_by=' uid ';
$order_by2=' desc ';  
$sql=$obj->Query("select * from sl_users, stores where 1=1 and sl_users.uid=stores.uid $where ",$debug=-1);

$csvData='';
$csvData.="Merchant Name (id),Storename, Contact Details ,KYC Details,Status,Products,Others ";
$csvData.="\n\r";
$reccnt=$obj->numRows($sql);

if($reccnt>0){
    $count=1;
    while($data=$obj->fetchNextObject($sql))
    {   
  	$csvData.=$data->companyname.' ('.$data->uid.')'.",";
	$csvData.=$data->storename.",";
	$csvData.=stripslashes($data->regcity).",";
	$csvData.=stripslashes($data->emailid)."".$data->emailid.",";
	$csvData.=$data->status.",";
	$csvData.=stripslashes($data->product).",";
	$csvData.=stripslashes($data->joindate).",";
	
	$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=Seller-Report-".date("dMY_H:i").".csv");
echo $csvData;
exit;
header("location:".$_SERVER['HTTP_REFERER']);
exit();
}
?>

Gel4y Mini Shell

Edit file