Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/paymny.co.in/public_html/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: exportpayout.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$filename="Payout ".date("d-m-Y").".xls";
$contents="RETAILER\tTOTAL AMOUNT\tPAID\tPENDING\n";
$table="cashbacks";
$pkey="id";
$totam=0;
$paid=0;
$sql="select distinct `retailer`, rt.* from `".$table."` cs, `retailers` rt where cs.retailer=rt.id and cs.status='1' and rt.status='1'";
if(isset($_REQUEST['rname']) && $_REQUEST['rname']!="") {
	$sql.=" and rt.name like '%".$_REQUEST['rname']."%'";
}
$sql.=" order by cs.".$pkey."";
//print $sql;
$res=mysqli_query($con,$sql);
if(mysqli_num_rows($res)>=1) {
	while($row=mysqli_fetch_assoc($res)) {
		$rowatot=mysqli_fetch_assoc(mysqli_query($con,"select sum(cashback) as cbk from `".$table."` where `retailer`='".$row['retailer']."' and `status`='1'"));
		$rowapd=mysqli_fetch_assoc(mysqli_query($con,"select sum(cashback) as cbk from `".$table."` where `retailer`='".$row['retailer']."' and `pystatus`='1' and `status`='1'"));
		$pending=$rowatot['cbk']-$rowapd['cbk'];
		//$totam+=$rowatot['cbk'];
		//$totpaid+=$rowapd['cbk'];
		$contents.=$row['name']."\t".$rowatot['cbk']."\t".$rowapd['cbk']."\t".$pending."\n";
	}		
}
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: exportpayout.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation