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

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: converttoexcelslwp.php

<?php
ob_start();
session_start();
include("includes/connection.php");
unset($_SESSION['ordnoar']);
$filename ="salesreport.xls";
$cusname=$_REQUEST['cusname'];
if($cusname!="")
{
	$res3=mysqli_query($con,"select * from `customer` where `adv_id`='".$cusname."'");
    $row3=mysqli_fetch_array($res3);
	$contents = "Report for $row3[adv_name] \t \t \t \t \n";
    $contents = $contents."SL. NO. \t DATE \t BILL NO. \t SALE \t PAID \n";
}
$count=1;
$sale=0;
$paid=0;
$pending=0;
$pur=0;
$ed=explode("-",$_REQUEST['fromd']);
$da=$ed[2]."-".$ed[1]."-".$ed[0];
$ed2=explode("-",$_REQUEST['tod']);
$da2=$ed2[2]."-".$ed2[1]."-".$ed2[0];
$sql="select * from `order` a  LEFT JOIN `customer` c ON a.cusname=c.adv_id LEFT JOIN `paymentde` p ON p.pyd_ordref=a.or_id where a.or_st='1' and a.cdate>='".$da."' and a.cdate<='".$da2."' and c.adv_id='".$cusname."' order by p.pyd_cdate";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($res))
{
	if(!@in_array($row['or_id'],$_SESSION['ordnoar']))
	{
	  if($row['sdate']==$row['pyd_sdate'] && $row['sdate']!="")
	  {
	    $contents = $contents.strtoupper($count)." \t ".strtoupper($row['sdate'])." \t ".strtoupper($row['or_bill'])." \t ".strtoupper($row['totamount'])." \t ".strtoupper($row['pyd_amount'])." \n";
	  }
	  else
	  {
	    $contents = $contents.strtoupper($count)." \t ".strtoupper($row['sdate'])." \t ".strtoupper($row['or_bill'])." \t ".strtoupper($row['totamount'])." \t \n";
		$count++;
	    $contents = $contents.strtoupper($count)." \t ".strtoupper($row['pyd_sdate'])." \t ".strtoupper($row['or_bill'])." \t \t ".strtoupper($row['pyd_amount'])." \n";
	  }
	  $sale+=$row['totamount'];
	  $_SESSION['ordnoar'][]=$row['or_id'];
	}
	else
	{
	  $contents = $contents.strtoupper($count)." \t ".strtoupper($row['pyd_sdate'])." \t ".strtoupper($row['or_bill'])." \t \t ".strtoupper($row['pyd_amount'])." \n";
	}
	$paid+=$row['pyd_amount'];
	$count++;
}
$pending=$sale-$paid;
$contents = $contents.""." \t \t ".strtoupper("Total")." \t ".strtoupper($sale)." \t \t \n";
$contents = $contents.""." \t \t ".strtoupper("Total Paid")." \t ".strtoupper($paid)." \t \t \n";
$contents = $contents.""." \t \t ".strtoupper("Total Pending")." \t ".strtoupper($pending)." \t \t \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: converttoexcelslwp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation