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

<?php
ob_start();
session_start();
include("includes/inall.php");
$fdate=$_REQUEST['fdate'];
$tdate=$_REQUEST['tdate'];
$filename="Data.xls";
$contents="Date\tHSN\tOrder No.\tInvoice No.\tMember ID\tName\tAddress\tProduct\tQty\tAmount\tType\n";
$entrytype=$_REQUEST['entrytype'];
$sql="select * from `orderp` op, `orderpro` od where op.order_id=od.orderpro_ref and op.orderstatus!='Order Cancelled' and op.paymentstatus='Done' and op.humsafar='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.or_inv_no";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($res)) {
	$name="";
	$address="";
	$rowc=mysqli_fetch_array(mysqli_query($con,"select * from `humsafar` 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'];
	}
	$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'];
	}
	if($rowc['humsafar']=="Yes") {
		$type="Humsafar";
	}
	$datearr=explode("-",$row['or_date']); 
	if($row['or_date']>="2023-04-01") {
		$yr="2023-24";
	} else {
		$yr="2022-23";
	}
	$invno="HS/".$yr."/".$datearr[1]."/".$row['or_inv_no'];
	$amount=$row['orderpro_qty']*$row['orderpro_val'];
	$contents=$contents.dtconvert($row['or_date'])."\t999316\t".$row['or_id']."\t".$invno."\t".$rowc['cusid']."\t".$name."\t".$address."\t".$rowp['name']."\t".$row['orderpro_qty']."\t".$amount."\t".$type." \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: exportordexcelhm.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation