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: exportbilling.php

<?php
ob_start();
session_start();
include("includes/incall.php");
//$frdate=$_REQUEST['frdate'];
//$todate=$_REQUEST['todate'];
$d=date("Y-m-d");
$filename="Booking.xls";
$contents="Date\tTime\tTimeDiff\tMode\tName\tDOB\tMobile\tTaxable Amount\tDiscount\tGST\tNon-Taxable Amout\tRound-Off\tNet\tDuplicate Print\n";
$sql="select bk.date as dt, bk. pmode as pm, bk.amount as am, bk.*, cs.* from `booking` bk, `customer` cs where bk.cusref=cs.cid and bk.status='1'";
if($_SESSION['utype']=="store") {
	$sql.=" and bk.aby='".$_SESSION['uid']."'";
	//$dt=date("Y-m-d");
	//$dtlast=date("Y-m-d",strtotime($dt."-5 days"));
}
if($_REQUEST['frdate']) {
	if($_SESSION['utype']=="store") {
		/*if(dtconvert($_REQUEST['frdate'])<$dtlast) {
			$_REQUEST['frdate']=dtconvert($dtlast);
		}*/
		$sql.=" and bk.date>='".$d."'";
	} else {
		$sql.=" and bk.date>='".$_REQUEST['frdate']."'";
	}
}
if($_REQUEST['todate']) {
	if($_SESSION['utype']=="store") {
		/*if(dtconvert($_REQUEST['frdate'])<$dtlast) {
			$_REQUEST['frdate']=dtconvert($dtlast);
		}*/
		$sql.=" and bk.date<='".$d."'";
	} else {
		$sql.=" and bk.date<='".$_REQUEST['todate']."'";
	}
}
if($_REQUEST['frdate']=="" && $_REQUEST['todate']=="") {
	$sql.=" and bk.date='".$d."'";
}
if($_REQUEST['mobile']) {
	$sql.=" and cs.mobile like '%".$_REQUEST['mobile']."%'";
}
if($_REQUEST['pmode']) {
	if($_REQUEST['pmode']=="Cash") {
		$sql.=" and (bk.pmode='".$_REQUEST['pmode']."' or bk.pmode='')";
	} else {
		$sql.=" and bk.pmode='".$_REQUEST['pmode']."'";
	}
}
if($_REQUEST['aby']) {
	$sql.=" and bk.aby='".$_REQUEST['aby']."'";
}
if($_REQUEST['dcount']=="Duplicate Printing") {
	$sqlashis.=" and bk.pcount>'1'";
}
$sql.=" order by bk.bid desc";
//print $sql;exit();
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($res)) {
	$rowcus=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `cid`='".$row['cusref']."'"));
	if($rowcus['cardno']!="") { 
		$mode="Card";
	} else { 
		$mode=$row['pm'];
	}
	$timediff="";
	if($row['strchkotime']!="") { 
		$diff=$row['strchkotime']-$row['strtime'];
		$timediff=round($diff/60);
	}
	if($_SESSION['utype']!="opmng") { 
		$mob=$rowcus['mobile'];
	} else {
		$mob="xxxxxxxxxx";
	}
	$roundoff=$row['net']-$row['am']-$row['gst']-$row['aamount'];
	$contents=$contents.dtconvert($row['dt'])."\t".$row['time']."\t".$timediff."\t".$mode."\t".ucwords(strtolower(utf8_encode(stripslashes($rowcus['name']))))."\t".dtconvert($rowcus['dob'])."\t".$mob."\t".number_format($row['am'],2)."\t0.00\t".number_format($row['gst'],2)."\t".number_format($row['aamount'],2)."\t".round($roundoff,2)."\t".number_format($row['net'],2)."\t".$dprint."\n";
}
$sqlashis="select * from `bill` bk where bk.net!='' and bk.status='1'";
if($_SESSION['utype']=="store") {
	$sqlashis.=" and bk.aby='".$_SESSION['uid']."'";
}
if($_REQUEST['frdate']) {
	$sqlashis.=" and bk.fdate>='".$_REQUEST['frdate']."'";
}
if($_REQUEST['todate']) {
	$sqlashis.=" and bk.fdate<='".$_REQUEST['todate']."'";
}
if($_REQUEST['frdate']=="" && $_REQUEST['todate']=="") {
	$sqlashis.=" and (bk.bdate='".$d."' or bk.fdate='".$d."')";
}
if($_REQUEST['mobile']) {
	$sqlashis.=" and bk.mobile like '%".$_REQUEST['mobile']."%'";
}
if($_REQUEST['aby']) {
	$sqlashis.=" and bk.aby='".$_REQUEST['aby']."'";
}
$sqlashis.=" order by bk.blid desc";
//print $sqlashis;
$resshis=mysqli_query($con,$sqlashis);
while($row=mysqli_fetch_array($resshis)) {
	$roundoff=$row['net']-$row['amount']-$row['gst'];
	$dprint=$row['pcount']-1;
	$contents=$contents.dtconvert($row['fdate'])."\t".$row['time']."\t\t\t".ucwords(strtolower(utf8_encode(stripslashes($row['name']))))."\t".$row['dob']."\t".$row['mobile']."\t".number_format($row['gross'],2)."\t0.00\t".number_format($row['gst'],2)."\t\t".round($roundoff,2)."\t".number_format($row['net'],2)."\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: exportbilling.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation