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

<?php
ob_start();
include("includes/connection.php");
include("includes/functions.php");
$filename="ledgervoucher.xls";
$contents=$contents."Date \t Customer Name \t Invoice No. \t Gross Total \t Sales @ 18% \t Output GST @ 18% \t Rounded Off \n";
$count=1;
$totalgross=0;
$totaltxbl=0;
$totaltax=0;
$cusname=$_REQUEST['cusname'];
$da=dtconvert($_REQUEST['fromd']);
$da2=dtconvert($_REQUEST['tod']);
$sql="select * from `order` a, `customer` c where a.or_st='1' and a.cusname=c.adv_id and a.cdate>='".$da."' and a.cdate<='".$da2."' order by a.cdate";
$record=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($record)) {
	$gamtot=0;
	$taxtot=0;
	$sqla="select * from `product` p, `orderpro` op where op.op_ref='".$row['or_id']."' and op.op_free='' and op.op_pro=p.pro_id";
	$resa=mysqli_query($con,$sqla);
	while($rowa=mysqli_fetch_array($resa)) {
		$gam=$rowa['op_rate']*$rowa['op_qty'];
		$gamtot+=round($rowa['op_rate']*$rowa['op_qty'],2);
		if($row['or_bill']=="68" || $row['or_bill']=="69" || $row['or_bill']=="71" || $row['or_bill']=="73" || $row['or_bill']=="74" || $row['or_bill']=="75" || $row['or_bill']=="76" || $row['or_bill']=="78") {
			$trate="12";
		} else {
			$trate=$rowa['pro_tax'];
		}
		$tax=$gam*($trate/100);
		$taxtot+=$gam*($trate/100);
		//$rou=round($gamtot+$taxtot)-round(($gamtot+$taxtot),2);
	}
	$gamtot+=$row['delcharge'];
	$taxtot+=round($row['delcharge']*($trate/100),2);
	$rou=round($gamtot+$taxtot)-round(($gamtot+$taxtot),2);
	$contents=$contents.strtoupper($row['sdate'])." \t ".strtoupper($row['adv_name'])." \t ".strtoupper($row['or_bill'])." \t ".round($gamtot+$taxtot)." \t ".round(($gamtot+$taxtot),2)." \t ".round($taxtot,2)." \t ".$rou." \n";
	$totalgross+=round($gamtot+$taxtot);
	$totaltxbl+=round(($gamtot+$taxtot),2);
	$totaltax+=round($taxtot,2);
	$count++;
}
	$contents=$contents." \t \t \t ".$totalgross." \t ".round($totaltxbl,2)." \t ".round($totaltax,2)." \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: converttoexcel3.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation