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

<?php
ob_start();
session_start();
include("includes/inall.php");
$filename="Purchaseregister.xls";
$totam=0;
$totgstfive=0;
$totgstfteen=0;
$totgsteteen=0;
$totgstteight=0;
$contents="Bill Date \t Bill No \t Name & Address of Party \t GSTIN \t GROSS BILL \t TAXABLE @5% \t IGST @5%  \t CGST @2.5% \t SGST @2.5% \t WITH GST VALUE \t TAXABLE @12% \t IGST @12%  \t CGST @6% \t SGST @6% \t WITH GST VALUE \t TAXABLE @18% \t IGST @18%  \t CGST @9% \t SGST @9% \t WITH GST VALUE \t TAXABLE @28% \t IGST @28%  \t CGST @14% \t SGST @14% \t WITH GST VALUE \t EXEMPTED \t Rounded Off \n";
$sqlh="select * from `purchase_header` ph, `party_master` pm where ph.pur_sup=pm.p_id";
if($_REQUEST['fdate']) {
	$sqlh.=" and ph.pur_invdt>='".$_REQUEST['fdate']."'";
}
if($_REQUEST['todate']) {
	$sqlh.=" and ph.pur_invdt<='".$_REQUEST['tdate']."'";
}
$sqlh.=" order by ph.pur_invdt";
$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 `purchase_item` pi, `product_master` pr where pi.pro_code=pr.pro_code and pi.pur_id='".$rowh['pur_id']."'");
		while($row=mysqli_fetch_array($res)) {
			$pvalue=round($row['purchase_val'],2);
			if($row['pro_gst']=="" ||  $row['pro_gst']=="0" || $row['pro_gst']=="0.00" || $row['pro_gst']=="00.00") {
				$taxzero+=$pvalue;
			}
			if($row['pro_gst']=="5" || $row['pro_gst']=="5.0" || $row['pro_gst']=="5.00" || $row['pro_gst']=="05") {
				$taxfive+=$pvalue;
			}
			if($row['pro_gst']=="12" || $row['pro_gst']=="12.0" || $row['pro_gst']=="12.00") {
				$taxtwelv+=$pvalue;
			}
			if($row['pro_gst']=="18" || $row['pro_gst']=="18.0" || $row['pro_gst']=="18.00") {
				$taxeteen+=$pvalue;
			}
			if($row['pro_gst']=="28" || $row['pro_gst']=="28.0" || $row['pro_gst']=="28.00") {
				$taxteight+=$pvalue;
			}
			$gross+=$pvalue;
			$totam+=$pvalue;
		}
		$gstfive=$taxfive*(1/20);
		$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['pur_invdt'])." \t ".$rowh['pur_invno']." \t ".$rowh['company_name'].", ".$rowh['address'].", ".$rowh['city_place'].", ".$rowh['state']." \t ".$rowh['gstin']." \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($taxtwelv,2)." \t \t ".round($gsttwelv/2,2)." \t ".round($gsttwelv/2,2)." \t ".round($tottwelv,2)." \t ".round($taxeteen,2)." \t \t ".round($gsteteen/2,2)." \t ".round($gsteteen/2,2)." \t ".round($toteteen,2)." \t ".round($taxteight,2)." \t \t ".round($gstteight/2,2)." \t ".round($gstteight/2,2)." \t ".round($totteight,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: excelpurreg.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation