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/jusjumpin.in/public_html

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: exportvc.php

<?php
ob_start();
session_start();
include("includes/incall.php");
$frdate=$_REQUEST['frdate'];
$todate=$_REQUEST['todate'];
$d=date("Y-m-d");
$filename="Voucher_Report.xls";
$contents="Date\tVoucher No.\tCustomer\tMobile No.\tDone By\tPackage\tAmount\n";
$sqlashis="select distinct `voucher` from `vouchers` vc, `customer` cs where vc.customer=cs.cid";
if(($_SESSION['utype']=="store" || $_SESSION['utype']=="mall" || $_SESSION['uid']!="") && $_SESSION['utype']!="superadmin" ) {
	$sqlashis.=" and vc.aby='".$_SESSION['uid']."'";
}
if($_REQUEST['frdate']) {
	$sqlashis.=" and vc.date>='".$_REQUEST['frdate']."'";
}
if($_REQUEST['todate']) {
	$sqlashis.=" and vc.date<='".$_REQUEST['todate']."'";
}
if($_REQUEST['frdate']=="" && $_REQUEST['todate']=="") {
	$sqlashis.=" and vc.date='".$d."'";
}
if($_REQUEST['vcno']) {
	$sqlashis.=" and vc.voucher like '%".$_REQUEST['vcno']."%'";
}
if($_REQUEST['mobno']) {
	$sqlashis.=" and cs.mobile='".$_REQUEST['mobno']."'";
}
if($_REQUEST['aby']) {
	$sqlashis.=" and vc.aby='".$_REQUEST['aby']."'";
}
if($_REQUEST['sman']) {
	$sqlashis.=" and vc.salesman='".$_REQUEST['sman']."'";
}
$sqlashis.=" order by `id` desc";
$res=mysqli_query($con,$sqlashis);
while($row=mysqli_fetch_array($res)) {
	$rowdet=mysqli_fetch_array(mysqli_query($con,"select * from `vouchers` where `voucher`='".$row['voucher']."'"));
	$rowcus=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `cid`='".$rowdet['customer']."'"));
	$rowpka=mysqli_fetch_array(mysqli_query($con,"select * from `activity` where `id`='".$rowdet['mainref']."'"));
	$rowpkb=mysqli_fetch_array(mysqli_query($con,"select * from `activity` where `id`='".$rowdet['activity']."'"));
	$contents=$contents.dtconvert($rowdet['date'])."\t".$row['voucher']."\t".strtoupper(utf8_encode(stripslashes($rowcus['name'])))." \t ".$rowcus['mobile']." \t ".strtoupper($rowdet['salesman'])." \t ".$rowpka['name']."\t".$rowpka['charge']." \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: exportvc.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation