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

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: deposit.php

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

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['cusvl']) && $_POST['cusvl'] !== '') { // Only redirect if a karigar is selected
        $karigar_id = $_POST['cusvl'];
        header("Location: " . $_SERVER['PHP_SELF'] . "?karigar_id=" . $karigar_id);
        exit();
    }

if (isset($_POST['show_all'])) {
        // Redirect to page without karigar_id param to show all
        header("Location: " . $_SERVER['PHP_SELF']);
        exit();
    }
}

$karigar_id = $_GET['karigar_id'] ?? '';

include("includes/headermain.php");
?>

<body>
<div class="page-container">
    <?php include("includes/leftmenu.php"); ?>
    <div class="main-content">
        <?php include("includes/header.php"); ?>
        <div class="main-content-innera">
            <div class="col-lg-12 mt-5">
                <div class="card">
                    <div class="card-body">
                        <h4 class="header-title">View Karigar Balance</h4>
                        <form method="post" action="" style="display: flex; align-items: flex-end; gap: 10px; margin-bottom: 20px; flex-wrap: wrap;">
                            <div style="display: flex; flex-direction: column; min-width: 250px;">
                                <label for="cusvl" style="font-weight: bold; margin-bottom: 6px;">Select Karigar</label>
                                <select class="form-control" name="cusvl" id="cusvl" style="padding: 6px 8px;">
                                    <option value="">-- Select Karigar Name --</option>
                                    <?php
                                    $resc = mysqli_query($con, "SELECT `id`,`name` FROM `karigar_master` WHERE `status`='1'");
                                    while ($rowc = mysqli_fetch_object($resc)) {
                                        $selected = ($rowc->id == $karigar_id) ? "selected" : "";
                                        ?>
                                        <option value="<?php print $rowc->id; ?>" <?php print $selected; ?>>
                                            <?php print htmlspecialchars($rowc->name); ?>
                                        </option>
                                        <?php
                                    }
                                    ?>
                                </select>
                            </div>

<button type="submit" name="search" class="btn btn-primary">Search</button>
                            <button type="button" class="btn btn-primary" onclick="location.href='<?php print basename(__FILE__); ?>';">Show All</button>
                            <button type="button" class="btn btn-primary ml-2 pr-4 pl-4" onclick="location.href='karigarbacnceprint.php<?= !empty($karigar_id) ? '?cusvl=' . urlencode($karigar_id) : '' ?>'">Print</button>                        
                        </form>

<h5 class="mt-4 mb-3">Balance Summary</h5>
                        <table class="table">
                            <thead class="text-uppercase bg-primary">
                                <tr class="text-white">
                                    <th align="left">SL</th>
                                    <th align="left">Karigar Name</th>
                                    <th align="left">Karigar Balance (₹)</th>
                                    <th align="left">Karigar Payments (₹)</th>
                                    <th align="left">Available Balance (₹)</th>
                                    
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                if ($karigar_id != '') {
                                    $karigar_info = mysqli_fetch_assoc(mysqli_query($con, "SELECT name FROM karigar_master WHERE id='$karigar_id' AND status='1'"));
                                    $query = "
                                        SELECT 
                                            IFNULL(SUM(deposit), 0) AS total_deposit,
                                            IFNULL(SUM(withdraw), 0) AS total_withdraw 
                                        FROM khata_dpwt 
                                        WHERE karigar = '$karigar_id' AND status = 1
                                    ";
                                    $res = mysqli_fetch_assoc(mysqli_query($con, $query));
                                    $balance = $res['total_deposit'] - $res['total_withdraw'];
                                    ?>
                                    <tr>
                                        <td align="left">1</td>
                                        <td align="left"><?php print htmlspecialchars($karigar_info['name']); ?></td>
                                        <td align="left"><?php print number_format($res['total_deposit'], 2); ?></td>
                                        <td align="left"><?php print number_format($res['total_withdraw'], 2); ?></td>
                                        <td align="left"><?php print number_format($balance, 2); ?></td>
                                    </tr>
                                    <?php
                                } else {
                                    $sql = "SELECT id, name FROM karigar_master WHERE status='1' ORDER BY name";
                                    $res = mysqli_query($con, $sql);
                                    $sl = 1;

$total_deposit_all = 0;
                                    $total_withdraw_all = 0;
                                    $total_balance_all = 0;

while ($row = mysqli_fetch_assoc($res)) {
                                        $kid = $row['id'];
                                        $karigar_name = $row['name'];

$q = "
                                            SELECT 
                                                IFNULL(SUM(deposit), 0) AS total_deposit,
                                                IFNULL(SUM(withdraw), 0) AS total_withdraw 
                                            FROM khata_dpwt 
                                            WHERE karigar = '$kid' AND status = 1
                                        ";
                                        $r = mysqli_fetch_assoc(mysqli_query($con, $q));
                                        $balance = $r['total_deposit'] - $r['total_withdraw'];

// Accumulate totals
                                        $total_deposit_all += $r['total_deposit'];
                                        $total_withdraw_all += $r['total_withdraw'];
                                        $total_balance_all += $balance;
                                        ?>
                                        <tr>
                                            <td align="left"><?php print $sl; ?></td>
                                            <td align="left"><?php print htmlspecialchars($karigar_name); ?></td>
                                            <td align="left"><?php print number_format($r['total_deposit'], 2); ?></td>
                                            <td align="left"><?php print number_format($r['total_withdraw'], 2); ?></td>
                                            <td align="left"><?php print number_format($balance, 2); ?></td>
                                        </tr>
                                        <?php
                                        $sl++;
                                    }
                                    ?>
                                    <tr class="sbg4">
                                        <td colspan="2">&nbsp;</td>
                                        <td align="left"><strong>Total Karigar Balance: <?php print number_format($total_deposit_all, 2); ?></td>
                                        <td align="left"><strong>Total Karigar Payments:<?php print number_format($total_withdraw_all, 2); ?></td>
                                        <td align="left"><strong>Total Available Balance:<?php print number_format($total_balance_all, 2); ?></td>
                                    </tr>
                                    <?php
                                }
                                ?>
                            </tbody>
                        </table>

</div>
                </div>
            </div>
        </div>
    </div>
    <?php include("includes/footer.php"); ?>
</div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: deposit.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation