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

<?php
ob_start();
include("includes/connection.php");
$filename ="purchasereport.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 \t \t \n";
	$contents = "GSTIN $row3[adv_tin] \t \t \t \t \t \t \n";
    $contents = $contents."SL. NO. \t DATE \t AMOUNT \t TAX \t TOTAL \t PAID \t PENDING \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 `stock` a, `customer` c where a.st_st='1' and a.cusname=c.adv_id and a.cdate>='$da' and a.cdate<='$da2' and c.adv_id='".$cusname."' order by a.cdate";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($res))
{
	$pnd=$row['totamount']-$row['given'];
	$amount=round($row['totamount']*(100/118),2);
	$tax=round($row['totamount']*(18/118),2);
	$contents = $contents.strtoupper($count)." \t ".strtoupper($row['sdate'])." \t ".strtoupper($amount)." \t ".strtoupper($tax)." \t ".strtoupper($row['totamount'])." \t ".strtoupper($row['given'])." \t ".strtoupper($pnd)." \n";
	$sale+=$row['totamount'];
	$paid+=$row['given'];
	$pending+=$pnd;
	$count++;
}
$contents = $contents.""." \t \t \t ".strtoupper("Total")." \t ".strtoupper($sale)." \t \t \n";
$contents = $contents.""." \t \t \t ".strtoupper("Total Paid")." \t ".strtoupper($paid)." \t \t \n";
$contents = $contents.""." \t \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: converttoexcel2p.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation