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/ccadmultiservices.com/public_html/admin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: exportordexcelof.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$fdate=$_REQUEST['fdate'];
$tdate=$_REQUEST['tdate'];
$filename="Data.xls";
$contents="Date\tOrder No.\tInvoice No.\tMember ID\tName\tAddress\tAmount\n";
$entrytype=$_REQUEST['entrytype'];
$sql="select * from `orderp` op where op.paymentstatus='Done' and op.orderstatus!='Order Cancelled' and op.humsafar!='Yes' and op.medilink!='Yes'";
if(isset($_REQUEST['fdate']) && $_REQUEST['fdate']!="") {
	$sql.=" and op.or_date>='".$fdate."'";
}
if(isset($_REQUEST['tdate']) && $_REQUEST['tdate']!="") {
	$sql.=" and op.or_date<='".$tdate."'";
}
$sql.=" order by op.order_id desc";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($res)) {
	$name="";
	$address="";
	$rowc=mysqli_fetch_array(mysqli_query($con,"select * from `registration` where `reg_id`='".$row['cusid']."'"));
	//$rowp=mysqli_fetch_array(mysqli_query($con,"select * from `products` where `pro_id`='".$row['orderpro_pro']."'"));
	$name=$rowc['fname'];
	if($rowc['mname']!="") {
		$name.=" ".$rowc['mname'];
	}
	if($rowc['lname']!="") {
		$name.=" ".$rowc['lname'];
	}
	if($rowc['holdingno']!="") {
		$address=$rowc['holdingno'].", ";
	}
	if($rowc['streetname']!="") {
		$address.=$rowc['streetname'].", ";
	}
	if($rowc['addresslinea']!="") {
		$address.=$rowc['addresslinea'].", ";
	}
	if($rowc['addresslineb']!="") {
		$address.=$rowc['addresslineb'].", ";
	}
	if($rowc['state']!="") {
		$address.=$rowc['state'].", ";
	}
	if($rowc['district']!="") {
		$address.=$rowc['district'].", ";
	}
	if($rowc['pin']!="") {
		$address.=" Pin - ".$rowc['pin'];
	}
	$contents=$contents.dtconvert($row['or_date'])."\t".$row['or_id']."\t".$row['or_inv_no']."\t".$rowc['cusid']."\t".$name."\t".$address."\t".$row['or_net']."\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: exportordexcelof.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation