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.92 TB

🔧 Quick Actions

✏️ Editing: converttoexcelsl.php

<?php
ob_start();
include("includes/connection.php");
$filename = "salesreport.xls";
$cusname = $_REQUEST['cusname'];
if($cusname != "") {
    $resa = mysqli_query($con, "select * from `customer` where `adv_id`='".$cusname."'");
    $rowa = mysqli_fetch_array($resa);
    $contents = "Report for ".$rowa['adv_name']." \t \t \t \t \t \t \t \n";
    $contents = "GST ".$rowa['adv_tin']." \t \t \t \t \t \t \t \n";
    $contents = $contents."SL. NO. \t DATE \t BILL NO. \t AMOUNT \t TAX \t TOTAL \t PAID \t PENDING \n";
}
$count = 1;
$sale = 0;
$paid = 0;
$pending = 0;
$pur = 0;
$da = dtconvert($_REQUEST['fromd']);
$daa = 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<='$daa' 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'];
    $rowpr = mysqli_fetch_array(mysqli_query($con, "select * from `orderpro` where `op_ref`='".$row['or_id'].
        "'"));
    $rowtx = mysqli_fetch_array(mysqli_query($con, "select * from `product` where `pro_id`='".$rowpr['op_pro'].
        "'"));
    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") {
        $amount = round($row['totamount'] * (100 / 112), 2);
        $tax = round($row['totamount'] * (12 / 112), 2);
    } else {
        $tx = $rowtx['pro_tax'];
        $txtot = 100 + $tx;
        $amount = round($row['totamount'] * (100 / $txtot), 2);
        $tax = round($row['totamount'] * ($tx / $txtot), 2);
    }
    $contents = $contents.strtoupper($count)." \t ".strtoupper($row['sdate'])." \t ".strtoupper($row['or_bill'])." \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 \t ".strtoupper("Total")." \t ".strtoupper($sale)." \t \t \n";
$contents = $contents.""." \t \t \t \t ".strtoupper("Total Paid")." \t ".strtoupper($paid)." \t \t \n";
$contents = $contents.""." \t \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: converttoexcelsl.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation