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/billingdemobcode

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: excelslreg.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$filename="Salesregister.xls";
$totam=0;
$totgstfive=0;
$totgstfteen=0;
$totgsteteen=0;
$totgstteight=0;
$contents="Bill Date \t Bill No \t Name of Customer \t GSTIN \t GROSS BILL \t TAXABLE @3% \t IGST @3%  \t CGST @2.5% \t SGST @2.5% \t WITH GST VALUE \t EXEMPTED \t Rounded Off \n";
$sqlh="select * from `sales_header` sh where sh.sl_st='1'";
if($_REQUEST['fdate']) {
	$sqlh.=" and sh.sl_docdate>='".$_REQUEST['fdate']."'";
}
if($_REQUEST['todate']) {
	$sqlh.=" and sh.sl_docdate<='".$_REQUEST['tdate']."'";
}
$sqlh.=" order by sh.sl_unid";
$resh=mysqli_query($con,$sqlh);
if(mysqli_num_rows($resh)>=1) {
	while($rowh=mysqli_fetch_array($resh)) {
		$gross=0;
		$taxzero=0;
		$taxfive=0;
		$taxtwelv=0;
		$taxeteen=0;
		$taxteight=0;
		$gstfive=0;
		$gsttwelv=0;
		$gsteteen=0;
		$gstteight=0;
		$roundoff=0;
		$res=mysqli_query($con,"select * from `sales_item` si where si.sl_id='".$rowh['sl_id']."'");
		while($row=mysqli_fetch_array($res)) {
			$pvalue=round($row['sales_valwogst'],2);
			if($row['sales_gst']=="" ||  $row['sales_gst']=="0" || $row['sales_gst']=="0.00" || $row['sales_gst']=="00.00") {
				$taxzero+=$pvalue;
			}
			if($row['sales_gst']=="3" || $row['sales_gst']=="3.0" || $row['sales_gst']=="3.00" || $row['sales_gst']=="03") {
				$taxfive+=$pvalue;
			}
			if($row['sales_gst']=="12" || $row['sales_gst']=="12.0" || $row['sales_gst']=="12.00") {
				$taxtwelv+=$pvalue;
			}
			if($row['sales_gst']=="18" || $row['sales_gst']=="18.0" || $row['sales_gst']=="18.00") {
				$taxeteen+=$pvalue;
			}
			if($row['sales_gst']=="28" || $row['sales_gst']=="28.0" || $row['sales_gst']=="28.00") {
				$taxteight+=$pvalue;
			}
			$gross+=$pvalue;
			$totam+=$pvalue;
		}
		$gstfive=$taxfive*(3/100);
		$gsttwelv=$taxtwelv*(12/100);
		$gsteteen=$taxeteen*(18/100);
		$gstteight=$taxteight*(28/100);
		
		$totfive=$taxfive+$gstfive; 
		$tottwelv=$taxtwelv+$gsttwelv;
		$toteteen=$taxeteen+$gsteteen;
		$totteight=$taxteight+$gstteight;
		
		$gross+=$gstfive+$gsttwelv+$gsteteen+$gstteight;
		
		$totgstfive+=$gstfive;
		$totgsttwelv+=$gsttwelv;
		$totgsteteen+=$gsteteen;
		$totgstteight+=$gstteight;
		
		$totgst+=$totgstfive+$totgsttwelv+$totgsteteen+$totgstteight;	
		
		$roundoff=round($gross)-(round($taxzero,2)+round($taxfive+$gstfive,2)+round($taxtwelv+$gsttwelv,2)+round($taxeteen+$gsteteen,2)+round($taxteight+$gstteight,2));
		
		$contents=$contents.dtconvert($rowh['sl_docdate'])." \t ".$rowh['sl_unid']." \t ".$rowh['cus_name']." \t \t ".number_format(round($gross),2)." \t ".round($taxfive,2)." \t \t ".round($gstfive/2,2)." \t ".round($gstfive/2,2)." \t ".round($totfive,2)." \t ".round($taxzero,2)." \t ".round($roundoff,2)." \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: excelslreg.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation