Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/avatar_coupon/admin

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: issue-coupons.php

<?php
include('header.php');
$amount_result = mysqli_query($con, "SELECT coupon_amount FROM coupon WHERE coupon_id = 1 LIMIT 1");
$amount_data = mysqli_fetch_assoc($amount_result);     
$coupon_amount = (int)($amount_data['coupon_amount'] ?? 0);
$creditLimit = 2; // Max allowed coupons on credit
if (isset($_POST['submit']) && $_POST['submit'] === 'Submit') {
    $student_id         = $_POST['ref_student_id'] ?? '';
    $no_of_coupons      = intval($_POST['no_of_coupons'] ?? 0);
    $credit_coupons     = intval($_POST['credit_coupons'] ?? 0);
    $credit_amounts     = floatval($_POST['credit_amounts'] ?? 0);
    $coupon_particulars = $_POST['coupon_particulars'] ?? '';
    $payment_type       = intval($_POST['payment_type'] ?? 5);
    $upi_reference      = $_POST['upi_reference'] ?? '';

if (empty($student_id) || $no_of_coupons <= 0) {
        echo "<script>alert('Invalid student or coupon count');</script>";
        exit;
    }

if ($payment_type === 4 && empty($upi_reference)) {
        echo "<script>alert('UPI Reference required');</script>";
        exit;
    }

$added_date = date("Y-m-d H:i:s");
    $payment_date = ($payment_type == 1 || $payment_type == 4) ? $added_date : null;
    $transaction_status = ($payment_type == 2) ? 2 : 1;
    $payment_status = ($payment_type == 2) ? 2 : 1;

// Snacks
    $snacks = $_POST['snacks'][$student_id] ?? [];
    $snack_info = $_POST['snack_info'] ?? [];

$snack_entries = [];
    $snack_total_amount = 0;

foreach ($snacks as $snack_id => $qty) {
        $qty = (int)$qty;
        if ($qty <= 0) continue;

$amount = (float)($snack_info[$snack_id]['amount'] ?? 0);
        $total = $qty * $amount;

$snack_total_amount += $total;

$snack_entries[] = [
            'id' => $snack_id,
            'qty' => $qty,
            'amount' => $total
        ];
    }

// Get snack balance
    $student_result = mysqli_query($con, "SELECT snack_balance FROM student WHERE student_id = '" . mysqli_real_escape_string($con, $student_id) . "' LIMIT 1");
    $student_data = mysqli_fetch_assoc($student_result);
    $current_snack_balance = (float)($student_data['snack_balance'] ?? 0);

$snack_pay_from_balance = min($current_snack_balance, $snack_total_amount);
    $snack_amount_to_pay = max(0, $snack_total_amount - $snack_pay_from_balance);

$amount_to_pay = $credit_amounts + $snack_amount_to_pay;

// Insert Transaction
    $sql = "
        INSERT INTO coupon_transaction (
            ref_student_id, transaction_date, transaction_type, no_of_coupons, coupon_particulars,
            payment_type, payment_status, payment_amount, payment_date, transaction_status,
            delete_status, added_date, ref_snack_id, ref_snack_amt, snack_amount, snack_quantity, credit_coupon
        ) VALUES (
            '" . mysqli_real_escape_string($con, $student_id) . "',
            '$added_date',
            '2',
            '$no_of_coupons',
            '" . mysqli_real_escape_string($con, $coupon_particulars) . "',
            '$payment_type',
            '$payment_status',
            '$amount_to_pay',
            " . ($payment_date ? "'$payment_date'" : "NULL") . ",
            '$transaction_status',
            '0',
            '$added_date',
            '" . implode(',', array_column($snack_entries, 'id')) . "',
            '" . implode(',', array_column($snack_entries, 'amount')) . "',
            '$snack_total_amount',
            '" . implode(',', array_column($snack_entries, 'qty')) . "',
            '" . max(0, $no_of_coupons - $credit_coupons) . "'
        )
    ";
    // echo $sql;die();

if (mysqli_query($con, $sql)) {
        // Update student snack balance
        $update_snack_sql = "
            UPDATE student SET snack_balance = GREATEST(snack_balance - $snack_pay_from_balance, 0)
            WHERE student_id = '" . mysqli_real_escape_string($con, $student_id) . "'
        ";
        mysqli_query($con, $update_snack_sql);

if ($payment_type == 2) {
            // Credit update
            $update_student_sql = "
                UPDATE student SET 
                    coupon_balance = GREATEST(coupon_balance - $credit_coupons, 0),
                    coupon_redeemed = coupon_redeemed + $no_of_coupons,
                    credit_amount = credit_amount + $amount_to_pay,
                    credit_coupon = credit_coupon + " . max(0, $no_of_coupons - $credit_coupons) . "
                WHERE student_id = '" . mysqli_real_escape_string($con, $student_id) . "'
            ";
        } else {
            // Normal update
            $update_student_sql = "
                UPDATE student SET 
                    coupon_balance = GREATEST(coupon_balance - $no_of_coupons, 0),
                    coupon_purchased = GREATEST(coupon_purchased - " . max(0, $no_of_coupons - $credit_coupons) . ", 0),
                    coupon_redeemed = coupon_redeemed + $no_of_coupons
                WHERE student_id = '" . mysqli_real_escape_string($con, $student_id) . "'
            ";
        }

if (mysqli_query($con, $update_student_sql)) {
            echo "<script>alert('Coupon issued successfully.'); window.location.href = 'issue-coupons.php';</script>";
        } else {
            echo "<script>alert('Failed to update student.');</script>";
        }
    } else {
        echo "<script>alert('Failed to insert transaction.');</script>";
    }
}
?>

<?php if (!empty($user_permissions['add'])): ?>
<div class="main-content">
    <div class="page-content">
        <div class="container-fluid">

<div class="row">
                <div class="col-12">
                    <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                        <h4 class="mb-sm-0">Issue Coupon</h4>
                        <div class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
                                <li class="breadcrumb-item active">Issue Coupon</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>

<div class="row">
                <div class="col-lg-12">
                    <div class="card">

<div class="card-body">
                            <div class="row">
                                <form action="" method="post" enctype="multipart/form-data"
                                    class="d-flex align-items-end">
                                    <div class="col-md-3">
                                        <label><b>Enter Registered Number </b></label>
                                        <input type="text" name="reg_no" class="form-control"
                                            placeholder="Enter Register No"
                                            value="<?php echo isset($_POST['reg_no']) ? htmlspecialchars($_POST['reg_no']) : ''; ?>"
                                            required>
                                    </div>

<div class="col-md-2">
                                        <input type="submit" class="btn btn-success" name="search" value="Search">
                                    </div>
                                </form>
                            </div>
                            <br>
                            <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="post" enctype="multipart/form-data">

<?php
        $coupon_balance = 0;
        if (isset($_POST['search'])) {
            $reg_no = mysqli_real_escape_string($con, $_POST['reg_no']);

$sql1 = "
                SELECT s.*, c.class_name, sec.section_name,s.credit_coupon
                FROM student s
                LEFT JOIN class c ON s.ref_class_id = c.class_id
                LEFT JOIN section sec ON s.ref_section_id = sec.section_id
                WHERE s.student_regno LIKE '%$reg_no%' AND s.delete_status = 0 AND s.ref_status_id = 1
                LIMIT 1
            ";

$result1 = mysqli_query($con, $sql1);

if ($result1 && mysqli_num_rows($result1) > 0) {
                $student = mysqli_fetch_assoc($result1);
                $coupon_balance = $student['coupon_balance'] ?? 0;
                $student_id = $student['student_id'];
        ?>

<div class="col-md-6">
                    <p><b><?= htmlspecialchars($student['student_name']); ?> | Reg No : <?= htmlspecialchars($student['student_regno']); ?> |  
                        <?php if ($student['member_type'] == 1) { ?>
                            Class : <?= htmlspecialchars($student['class_name'] . '-' . $student['section_name']); ?>
                        <?php } elseif ($student['member_type'] == 2) { ?>
                            
                        <?php } ?></b>
                    </p>
                </div>
                
                <div class="col-md-6 text-end">
                    <?php if ($student['coupon_balance'] != 0): ?>
                        <b style="color:red;" id="couponBalance-<?= htmlspecialchars($student_id); ?>">
                            Available Coupons : <?= (int)($student['coupon_balance'] ?? 0); ?> 
                        </b>
                    <?php endif; ?> /
                    <?php if (!empty($student['snack_balance']) && $student['snack_balance'] > 0): ?>
                        <b style="color:blue;" id="snackBalance-<?= htmlspecialchars($student_id); ?>">
                            Available Snack Amt : ₹<?= number_format((float)$student['snack_balance'], 2); ?>
                        </b>
                    <?php endif; ?>
                </div>

<table class="table student-table"
                        data-coupon-balance="<?= (int)$student['coupon_balance']; ?>"
                        data-credit-coupon="<?= (int)$student['credit_coupon']; ?>"
                        data-snack-balance="<?= (float)$student['snack_balance']; ?>">

<tr class="student-row">
                            <th align="left">Enter Number of Coupons</th>
                            <td align="left" valign="top">
                                <?php
                                if ($student['coupon_balance'] != 0 || $student['credit_coupon'] <= 2) {
                                    if ($student['credit_coupon'] <= 2) { ?>
                                        <p style="color:red;">Credit Limit is Available</p>
                                <?php }
                                ?>

<input type="number" name="no_of_coupons" value="" placeholder="Enter Number of Coupons" class="form-control no-of-coupons" min="0" step="1" max="<?= (int)($student['coupon_balance'] ?? 0) + 100; ?>" oninput="this.value = this.value.replace(/[^0-9]/g, '')">
                                    
                                    <input type="hidden" name="credit_amounts" class="credit-amount" value="0">
                                    <input type="hidden" name="credit_coupons" class="credit-coupon" value="0">
                                    <input type="hidden" id="payment_amount" name="payment_amount" value="">

<?php
                                } else { ?>
                                    <p style="color:red;">
                                        Coupons, Credit, and balance not available for this <?= $member_type; ?>.</p>
                                <?php }
                                ?>

</td>
                        </tr>

<?php 
                        if ($student['snack_balance'] != 0) {

$snack_sql = "SELECT * FROM snack WHERE ref_status_id = 1 AND delete_status = 0";
                            $snack_result = mysqli_query($con, $snack_sql);

if ($snack_result && mysqli_num_rows($snack_result) > 0) {
                                while ($snack = mysqli_fetch_assoc($snack_result)) {
                                    $snack_id = (int)$snack['snack_id'];
                                    $snack_name = htmlspecialchars($snack['snack_name']);
                                    $snack_amount = number_format((float)$snack['snack_amount'], 2);
                        ?>
                                    <tr>
                                        <th align="right"><?= $snack_name; ?> - ₹ <?= $snack_amount; ?></th>
                                        <td>
                                            <input type="number" name="snacks[<?= $student_id; ?>][<?= $snack_id; ?>]" class="form-control snack-quantity"
                                                placeholder="Quantity" min="0" step="1" oninput="this.value = this.value.replace(/[^0-9]/g, '')">
                                            <input type="hidden" name="snack_info[<?= $snack_id; ?>][name]" value="<?= $snack_name; ?>">
                                            <input type="hidden" name="snack_info[<?= $snack_id; ?>][amount]" value="<?= $snack_amount; ?>">
                                        </td>
                                    </tr>
                        <?php
                                }
                            } else {
                                echo '<tr><td colspan="2"><em>No snacks available.</em></td></tr>';
                            }
                        } else { ?>
                            <tr>
                                <td colspan="2">
                                    <p style="color:red;">
                                        Snack balance not available for this <?= $member_type; ?>.</p>
                                </td>
                            </tr>
                        <?php }
                        ?>

<?php if ($student['coupon_balance'] != 0) { ?>
                            <tr>
                                <td colspan="2">
                                    <input type="text" name="coupon_particulars" placeholder="Info..." class="form-control coupon-particulars">
                                </td>
                            </tr>
                        <?php } ?>
                    </table>

</div>

<div style="display: none;" id="amountToPayContainer" class="mb-2 btn btn-primary col-md-3"><strong>Amount to Pay : ₹0.00</strong></div>
        <div id="paymentOptions" style="display: none;">
            <div class="form-check-inline">
                <input class="form-check-input" type="radio" name="payment_type" value="2" id="radio2">
                <label class="form-check-label" for="radio2">CREDIT</label>
            </div>
    </div>
    
    <div class="row">
        <div class="col-md-12 text-left">
            <input type="button" id="previewBtn" class="me-5 btn btn-danger submit" value="Submit">
            <input type="submit" id="submitBtn" class="me-5 btn btn-warning submit" value="Cancel">
        </div>
    </div>
    <br>

<?php
            } else {
                echo "<div class='alert alert-warning'>No students found with Reg No \"$reg_no\".</div>";
            }
        }
?>

<div class="modal fade" id="previewModal" tabindex="-1" aria-labelledby="previewModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Confirm Coupon Delivery</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"
                    aria-label="Close"></button>
            </div>
            <div class="modal-body" id="modalPreviewBody">
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary"
                    data-bs-dismiss="modal">Cancel</button>
                <input type="submit" name="submit" value="Submit"
                    class="btn btn-primary">
            </div>
        </div>
    </div>
</div>

</form>

</div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<?php else: 
    echo "<script>
            alert('You don\\'t have permission to access this page.');
            window.history.back();
          </script>";
    exit();
endif; ?>

<?php include "footer.php"; ?>

const amountToPayEl = document.getElementById("amountToPayContainer");
    const paymentOptionsEl = document.getElementById("paymentOptions");
    const paymentAmountInput = document.getElementById('payment_amount');

let globalToPay = 0;

function refreshAmounts() {
        let totalCouponAmount = 0;
        let totalSnackAmount = 0;

document.querySelectorAll(".student-table").forEach(table => {
            const couponInput = table.querySelector('input[name="no_of_coupons"]');
            const creditAmountInput = table.querySelector('input[name="credit_amounts"]');
            const creditCouponInput = table.querySelector('input[name="credit_coupons"]');

const couponQty = couponInput ? parseInt(couponInput.value) || 0 : 0;
            const availableCoupons = parseInt(table.dataset.couponBalance || "0");

const creditCoupon = Math.min(couponQty, availableCoupons);
            const extraCoupons = Math.max(0, couponQty - availableCoupons);
            const creditAmount = extraCoupons * amountPerCoupon;

if (creditAmountInput) creditAmountInput.value = creditAmount.toFixed(2);
            if (creditCouponInput) creditCouponInput.value = creditCoupon;

totalCouponAmount += creditAmount;

// Snack Calculation
            table.querySelectorAll("input[name^='snacks']").forEach(input => {
                const qty = parseInt(input.value || "0");
                if (qty > 0) {
                    const match = input.name.match(/\[.*?\]\[(\d+)\]/);
                    const snackId = match?.[1];
                    if (!snackId) return;

const amountInput = document.querySelector(`input[name="snack_info[${snackId}][amount]"]`);
                    if (!amountInput) return;

const snackPrice = parseFloat(amountInput.value || "0");
                    totalSnackAmount += qty * snackPrice;
                }
            });

console.log('Coupon Qty:', couponQty, 'Available Coupons:', availableCoupons, 'Extra Coupons:', extraCoupons, 'Credit Amount:', creditAmount);
        });

const creditAmountInputGlobal = document.getElementById("credit_amount");
        const globalCreditAmount = creditAmountInputGlobal ? parseFloat(creditAmountInputGlobal.value || "0") : 0;

let totalAmountToPay = totalCouponAmount - globalCreditAmount;
        totalAmountToPay = Math.max(0, totalAmountToPay);
        globalToPay = totalAmountToPay;

console.log('Total Amount To Pay:', totalAmountToPay);

if (totalAmountToPay > 0) {
            amountToPayEl.innerHTML = `<strong>Amount to Pay: ₹${totalAmountToPay.toFixed(2)}</strong>`;
            amountToPayEl.style.display = 'block';
            paymentOptionsEl.style.display = 'block';
            if (paymentAmountInput) {
                paymentAmountInput.value = totalAmountToPay.toFixed(2);
            }
        } else {
            amountToPayEl.style.display = 'none';
            paymentOptionsEl.style.display = 'none';
            if (paymentAmountInput) paymentAmountInput.value = '';
            document.querySelectorAll('input[name="payment_type"]').forEach(r => r.checked = false);
        }
    }

// Add input listeners
    document.querySelectorAll(".no-of-coupons").forEach(input => {
        input.addEventListener("input", refreshAmounts);
    });

document.querySelectorAll("input[name^='snacks']").forEach(input => {
        input.addEventListener("input", refreshAmounts);
    });

// Preview button logic
    document.getElementById("previewBtn").addEventListener("click", () => {
        const paymentType = document.querySelector('input[name="payment_type"]:checked')?.value;
        const modalBody = document.getElementById("modalPreviewBody");
        modalBody.innerHTML = "";

let totalCoupons = 0;
        let totalAmt = 0;
        const creditLimit = 2;
        let creditIssueErrors = [];
        let tableRows = "";

document.querySelectorAll(".student-table").forEach(table => {
            const couponInput = table.querySelector('input[name="no_of_coupons"]'); // ✅ fixed name
            const couponQty = couponInput ? parseInt(couponInput.value) || 0 : 0;

const availCoupons = parseInt(table.dataset.couponBalance || 0);
            const currentCredit = parseInt(table.dataset.creditCoupon || 0);
            const extraCoupons = Math.max(0, couponQty - availCoupons);

if (paymentType === "2" && extraCoupons > 0 && (currentCredit + extraCoupons) > creditLimit) {
                const reg = table.querySelector("tr.student-row th")?.innerText || "Unknown Reg";
                creditIssueErrors.push(`${reg}: Credit limit exceeded. Allowed: ${creditLimit}, Requested: ${extraCoupons + currentCredit}`);
                return;
            }

const reg = table.querySelector("tr.student-row th")?.innerText.replace("Reg No:", "").trim() || "Unknown";
            const name = table.querySelectorAll("tr")[1]?.querySelector("th")?.innerText.replace("Name :", "").trim() || "N/A";
            const particulars = table.querySelector('input[name="coupon_particulars[]"]')?.value.trim() || "N/A";

totalCoupons += couponQty;
            const toPay = extraCoupons * amountPerCoupon;
            totalAmt += toPay;

tableRows += `
                <tr>
                    <td>${reg}</td>
                    <td>${name}</td>
                    <td>${couponQty}</td>
                    <td>₹${toPay.toFixed(2)}</td>
                    <td>${snackDetails.length ? snackDetails.join("<br>") : "-"}</td>
                    <td>${particulars}</td>
                </tr>
            `;
        });

if (creditIssueErrors.length) {
            alert(creditIssueErrors.join("\n"));
            return;
        }

if (!tableRows) {
            alert("Please enter coupon quantities for at least one student.");
            return;
        }

if (totalAmt > 0 && !paymentType) {
            alert("Please select a payment method.");
            return;
        }

const finalTable = `
            <div class="table-responsive">
                <table class="table table-bordered table-striped align-middle small">
                    <thead class="table-light">
                        <tr>
                            <th>Reg No</th>
                            <th>Name</th>
                            <th>Coupons</th>
                            <th>Amount to Pay</th>
                            <th>Snacks (Qty)</th>
                            <th>Particulars</th>
                        </tr>
                    </thead>
                    <tbody>
                        ${tableRows}
                    </tbody>
                    <tfoot class="table-light fw-bold">
                        <tr>
                            <td colspan="2">Total</td>
                            <td>${totalCoupons}</td>
                            <td>₹${totalAmt.toFixed(2)}</td>
                            <td colspan="2">-</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        `;

modalBody.innerHTML = finalTable;
        new bootstrap.Modal(document.getElementById("previewModal")).show();
    });

refreshAmounts(); // Initial calculation
});
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: issue-coupons.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation