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

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: billk.php

<?php
ob_start();
session_start();
include("includes/inall.php");

// Set max length for GROUP_CONCAT to prevent truncation
mysqli_query($con, "SET SESSION group_concat_max_len = 10000");

// Number to words function (unchanged)
function convert_number_to_words($number)
{
    $no = floor($number);
    $point = round(($number - $no) * 100);
    $words = array(
        '0' => '',
        '1' => 'one',
        '2' => 'two',
        '3' => 'three',
        '4' => 'four',
        '5' => 'five',
        '6' => 'six',
        '7' => 'seven',
        '8' => 'eight',
        '9' => 'nine',
        '10' => 'ten',
        '11' => 'eleven',
        '12' => 'twelve',
        '13' => 'thirteen',
        '14' => 'fourteen',
        '15' => 'fifteen',
        '16' => 'sixteen',
        '17' => 'seventeen',
        '18' => 'eighteen',
        '19' => 'nineteen',
        '20' => 'twenty',
        '30' => 'thirty',
        '40' => 'forty',
        '50' => 'fifty',
        '60' => 'sixty',
        '70' => 'seventy',
        '80' => 'eighty',
        '90' => 'ninety'
    );
    $digits = array('', 'hundred', 'thousand', 'lakh', 'crore');
    $str = array();
    $i = 0;
    $no_temp = $no;
    while ($no_temp > 0) {
        $divider = ($i == 1) ? 10 : 100;
        $number_part = $no_temp % $divider;
        $no_temp = floor($no_temp / $divider);
        if ($number_part) {
            $counter = count($str);
            $plural = ($counter && $number_part > 9) ? '' : null;
            $hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
            if ($number_part < 21) {
                $str[] = $words[$number_part] . " " . $digits[$counter] . $plural . " " . $hundred;
            } else {
                $str[] = $words[floor($number_part / 10) * 10] . " " . $words[$number_part % 10] . " " . $digits[$counter] . $plural . " " . $hundred;
            }
        } else {
            $str[] = null;
        }
        $i = ($divider == 10) ? 1 : 2;
    }
    $str = array_reverse($str);
    $result = implode('', $str);
    $points = '';
    if ($point > 0) {
        $points = "and " . $words[floor($point / 10)] . " " . $words[$point % 10] . " paise";
    }
    return strtoupper("Rupees " . trim($result) . " only " . $points);
}

// Validate bill ID
if (!isset($_REQUEST['id']) || empty($_REQUEST['id'])) die("❌ No bill ID provided.");
$id = (int)$_REQUEST['id'];

// Fetch bill
$row = mysqli_fetch_assoc(mysqli_query($con, "SELECT * FROM `sales_kheader` WHERE `sl_id`='$id'"));
if (!$row) die("❌ Bill not found.");

// Fetch buyer details
$rowk = mysqli_fetch_assoc(mysqli_query($con, "SELECT * FROM `customer_master` WHERE `id`='" . intval($row['kr_id']) . "'"));

// Fetch item details with correct joins
$sqla = "
SELECT 
    si.*, 
    pmsp.pro_image, 
    GROUP_CONCAT(DISTINCT pmspd.pro_color ORDER BY pmspd.pro_color SEPARATOR ', ') AS pro_color
FROM sales_kitem si
LEFT JOIN product_mastersp pmsp ON si.pro_name = pmsp.pro_code
LEFT JOIN product_msspdt pmspd ON pmspd.pro_ref = pmsp.pro_id
WHERE si.sl_id = '" . $id . "'
GROUP BY si.sales_id
ORDER BY si.sales_id
";

$resa = mysqli_query($con, $sqla);

// Check if any items found
if (mysqli_num_rows($resa) == 0) {
    print "❌ No product items found. Please check if product code matches correctly.";
}

// Calculate total
$total = 0;
while ($rowa = mysqli_fetch_assoc($resa)) {
    $total += $rowa['sales_qty'] * $rowa['sales_rate'];
}
mysqli_data_seek($resa, 0); // Rewind result set

$nettot = $total;
$gamtot = $total;

$mon = date("m");
if ($mon >= 4) {
    $fy = date("y") . "-" . (date("y") + 1);
} else {
    $fy = (date("y") - 1) . "-" . date("y");
}
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <title>Invoice with Full Border Inline CSS</title>
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <script>
        function PrintDivData(divId) {
            var divContent = document.getElementById(divId).innerHTML;
            var printWindow = window.open('', '', 'width=900,height=600');
            printWindow.document.write('<html><head><title>Print Invoice</title></head><body>');
            printWindow.document.write('<div style="max-width:1048px;margin:30px auto;border:3px solid #000;padding:25px 30px; background:#fff; font-family: Arial, sans-serif; font-size:14px; color:#333; box-sizing:border-box;">');
            printWindow.document.write(divContent);
            printWindow.document.write('</div></body></html>');
            printWindow.document.close();
            printWindow.focus();
            printWindow.print();
            printWindow.close();
        }
    </script>
</head>

<body style="margin:0; padding:0; background:#f7f7f7; font-family: Arial, sans-serif; font-size:14px; color:#333;">
    <div id="div_print" style="max-width:1048px; margin:30px auto; border:3px solid #000; padding:25px 30px; background:#fff; box-sizing:border-box; box-shadow: 0 0 10px rgba(0,0,0,0.15);">
        
        <div style="border-bottom:2px solid #333; padding-bottom:15px; margin-bottom:30px; display:flex; justify-content:space-between;">
            <div style="width:33.33%;flex:1; text-align:left; font-size:16px;">
                <strong style="font-size:16px;">UNIQ CREATION</strong><br />
                Junglepara Bazar, Chanditala, Hooghly<br />
                MOB +91 85973 15969
            </div>
            <div style="width:33.33%;flex:1; text-align:center; font-weight:bold; font-size:18px;">
                <div style="font-size:22px; color:#000; margin-bottom:8px;">BILL INVOICE</div>
                Invoice No: <span style="color:#555;"><?php print htmlspecialchars($row['sl_unid']); ?>/ <?php print $fy; ?></span><br />
                Date: <span style="color:#555;"><?php print date('d-m-Y', strtotime($row['sl_docdate'])); ?></span>
            </div>
            <div style="width:33.33%;flex:1; text-align:right; font-size:16px;">
                <strong>BUYER NAME: <?php print strtoupper(htmlspecialchars($rowk['name'])); ?></strong><br />
                <?php if (!empty($rowk['address'])): ?>
                    Address: <?php print strtoupper(htmlspecialchars($rowk['address'])); ?><br />
                <?php endif; ?>
                <?php if (!empty($rowk['mobno'])): ?>
                    Contact No.: <?php print strtoupper(htmlspecialchars($rowk['mobno'])); ?>
                <?php endif; ?>
            </div>
        </div>

<table style="width:100%; border-collapse:collapse; margin-top:20px; border:1px solid #000;">
            <thead>
                <tr style="background-color: #f2f2f2;">
                    <th style="border:1px solid #000; padding:8px; text-align:center; width:50px;">Sl No.</th>
                    <th style="border:1px solid #000; padding:8px; text-align:left;">Product Description</th>
                    <th style="border:1px solid #000; padding:8px; text-align:center;">Color</th>
                    <th style="border:1px solid #000; padding:8px; text-align:center; width:80px;">Qty</th>
                    <th style="border:1px solid #000; padding:8px; text-align:right; width:100px;">Rate (₹)</th>
                    <th style="border:1px solid #000; padding:8px; text-align:right; width:120px;">Amount (₹)</th>
                </tr>
            </thead>
            <tbody>
                <?php
                $sl = 1;
                while ($rowa = mysqli_fetch_assoc($resa)):
                    $qty = (float)$rowa['sales_qty'];
                    $rate = (float)$rowa['sales_rate'];
                    $amount = $qty * $rate;
                ?>
                    <tr>
                        <td style="border:1px solid #000; padding:8px; text-align:center;"><?php echo $sl++; ?></td>
                        <td style="border:1px solid #000; padding:8px;">
                            <strong><?php echo htmlspecialchars($rowa['pro_name']); ?></strong>
                        </td>
                        <td style="border:1px solid #000; padding:8px; text-align:center;">
                            <?php echo !empty($rowa['pro_color']) ? htmlspecialchars($rowa['pro_color']) : '-'; ?>
                        </td>
                        <td style="border:1px solid #000; padding:8px; text-align:center;"><?php echo $qty; ?></td>
                        <td style="border:1px solid #000; padding:8px; text-align:right;"><?php echo number_format($rate, 2); ?></td>
                        <td style="border:1px solid #000; padding:8px; text-align:right;"><?php echo number_format($amount, 2); ?></td>
                    </tr>
                <?php endwhile; ?>
            </tbody>

<tfoot>
                <tr>
                    <td colspan="3" rowspan="3" style="border:1px solid #000; padding:10px; vertical-align:top;">
                        <strong style="font-size:12px;">AMOUNT IN WORDS:</strong><br />
                        <div style="margin-top:5px; font-weight:bold;">
                            <?php echo strtoupper(convert_number_to_words(round($nettot))); ?>
                        </div>
                    </td>
                    <td colspan="2" style="border:1px solid #000; padding:8px; text-align:right; font-weight:bold;">Total</td>
                    <td style="border:1px solid #000; padding:8px; text-align:right; font-weight:bold;">
                        <?php echo number_format($gamtot, 2); ?>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" style="border:1px solid #000; padding:8px; text-align:right; font-weight:bold;">Round Off</td>
                    <td style="border:1px solid #000; padding:8px; text-align:right;">
                        <?php echo number_format(round($nettot) - $nettot, 2); ?>
                    </td>
                </tr>
                <tr style="background-color: #eee;">
                    <td colspan="2" style="border:1px solid #000; padding:8px; text-align:right; font-weight:bold; font-size:16px;">NET TOTAL</td>
                    <td style="border:1px solid #000; padding:8px; text-align:right; font-weight:bold; font-size:16px;">
                        ₹ <?php echo number_format(round($nettot), 2); ?>
                    </td>
                </tr>
            </tfoot>
        </table>

</div>

<button onclick="PrintDivData('div_print')" style="display:block; margin:20px auto; padding:10px 20px; font-size:16px; cursor:pointer; border:2px solid #000; background:#fff; transition: background 0.3s ease;">
        Print
    </button>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: billk.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation