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

<?php
ob_start();
session_start();
include("includes/inall.php");
$fdate=$_REQUEST['fdate'];
$tdate=$_REQUEST['tdate'];
$filename="Data.xls";
$contents="INVOICE NO\tFIRST NAME\tLAST NAME\tEMAIL ID\tMOBILE NO\tDOB\tGENDER\tPIN\tADDRESS LINE 1\tADDRESS LINE 2\tCITY\tSTATE\tAREA\tID\tNOMINEE\tRELATION\tTRANSACTION DATE\tAMOUNT\tPLAN NAME\tCHANNEL\tAGE PROOF\tID PROOF\tPHOTO\tAUDIO\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)) {
	$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']."'"));
	$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'];
	$ageprf="https://ccadmultiservices.com/system/kyc/".$rowc['ageprf'];
	$idprf="https://ccadmultiservices.com/system/kyc/".$rowc['idprf'];
	$photo="https://ccadmultiservices.com/system/kyc/".$rowc['photo'];
	$audio="https://ccadmultiservices.com/system/kyc/".$rowc['audio'];
	$contents=$contents.$invno."\t".$rowc['fname']."\t".$rowc['lname']."\t".$rowc['email']."\t".$rowc['mobile']."\t".dtconvert($rowc['dob'])."\t".$rowc['gender']."\t".$rowc['pin']."\t".$rowc['addresslinea']."\t".$rowc['addresslineb']."\t".$rowc['city']."\t".$rowc['state']."\t".$rowc['area']."\t".$rowc['panad']."\t\t\t".dtconvert($row['or_date'])."\t".$amount."\t".$rowp['name']."\t".$rowc['channel']."\t".$ageprf."\t".$idprf."\t".$photo."\t".$audio." \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: exportordexcelhmdoc.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation