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

<?php include('header.php');
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
if ($_POST['submit'] === 'Submit') {
    $ref_student_ids = $_POST['ref_student_id'] ?? [];
    $coupon_ids = $_POST['coupon_id'] ?? []; // <--- define it
    $no_of_coupons = $_POST['no_of_coupons'] ?? [];
    $coupon_amounts = $_POST['coupon_amount'] ?? [];
    $snack_package_id = $_POST['snack_package_id'] ?? [];
    $snack_amount = $_POST['snack_amount'] ?? [];
    $payment_type = $_POST['payment_type'] ?? 0;

$allInserted = true;

foreach ($ref_student_ids as $index => $student_id) {
        // Trim and validate input
        $student_id = trim($student_id);
        $coupon_id = isset($coupon_ids[$index]) ? (int)$coupon_ids[$index] : 0;
        $coupon_count = isset($no_of_coupons[$index]) ? (int)$no_of_coupons[$index] : 0;
        $amount = isset($coupon_amounts[$index]) ? (float)$coupon_amounts[$index] : 0;
        $package_id = isset($snack_package_id[$index]) ? (int)$snack_package_id[$index] : 0;
        $snack_balance = isset($snack_amount[$index]) ? (int)$snack_amount[$index] : 0;

// Skip if required data is missing or invalid
        if (empty($student_id) || ($coupon_id === 0 || $coupon_count === 0 || $amount === 0.0) && ($package_id === 0 || $snack_balance === 0)) {
            continue;
        }

// Your existing insert logic continues here...

$transaction_date = date("Y-m-d H:i:s");
        $added_date = $transaction_date;

$sql = "
        INSERT INTO coupon_transaction (
            ref_student_id,
            transaction_date,
            transaction_type,
            ref_coupon_id,
            no_of_coupons,
            snack_package_id,
            snack_amount,
            payment_type,
            payment_status,
            payment_amount,
            transaction_status,
            delete_status,
            added_date
        ) VALUES (
            '$student_id',
            '$transaction_date',
            '1',
            '$coupon_id',
            '$coupon_count',
            '$package_id',
            '$snack_balance',
            '$payment_type',
            1,
            '$amount',
            1,
            0,
            '$added_date'
        )
    ";

if (!mysqli_query($con, $sql)) {
            $allInserted = false;
            error_log("Insert failed: " . mysqli_error($con));
        }
        $query = "SELECT coupon_purchased, coupon_balance, snack_balance FROM student WHERE student_id = $student_id";
        $result = mysqli_query($con, $query);
        $row = mysqli_fetch_assoc($result);
        
        $old_coupon_purchased = $row['coupon_purchased'];
        $old_coupon_balance = $row['coupon_balance'];
        $old_snack_balance = $row['snack_balance'];
        $new_coupon_purchased = $old_coupon_purchased + $coupon_count;
        $new_coupon_balance = $old_coupon_balance + $coupon_count;
        $new_snack_balance = $old_snack_balance + $snack_balance;
        $update = "UPDATE student 
           SET coupon_purchased = $new_coupon_purchased, 
               coupon_balance = $new_coupon_balance,
               snack_balance = $new_snack_balance
           WHERE student_id = $student_id";
        // print_r($update);die();

mysqli_query($con, $update);
    }

if ($allInserted) {
        echo "<script>
            alert('All coupons delivered successfully!');
            window.location.href = 'issue-coupons.php';
        </script>";
    } else {
        echo "<script>
            alert('Some coupons failed to deliver. Please check logs or database.');
        </script>";
    }
}
// }

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

<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">Purchase 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">Purchase 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 Phone Number </b></label>
                                        <input type="text" name="phone_no" class="form-control"
                                            placeholder="Enter Phone No"
                                            value="<?php echo isset($_POST['phone_no']) ? htmlspecialchars($_POST['phone_no']) : ''; ?>" oninput="this.value = this.value.replace(/[^0-9]/g, '')" 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">

<div class="row">
                            <?php if (isset($_POST['search'])) {
                                $phone_no = mysqli_real_escape_string($con, $_POST['phone_no']);

$sql = "SELECT s.*, c.class_name, sec.section_name
                                    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.mobile_no LIKE '%$phone_no%'
                                    AND s.delete_status = 0 AND s.ref_status_id = 1
                                    AND (
                                        s.member_type = 2
                                        OR NOT EXISTS (
                                        SELECT 1 FROM student WHERE mobile_no LIKE '%$phone_no%'
                                        AND delete_status = 0 AND ref_status_id = 1 AND member_type = 2
                                              )
                                          )";
                            // echo $sql;die();

$result = mysqli_query($con, $sql);

if ($result && mysqli_num_rows($result) > 0) {
                                while ($student = mysqli_fetch_assoc($result)) {
                        ?>
                                    <input type="hidden" name="ref_student_id[]" value="<?= $student['student_id']; ?>">
                                    <div class="col-md-6">
										<p><b>Reg No : <?= htmlspecialchars($student['student_regno']); ?> | Name : <?= htmlspecialchars($student['student_name']); ?> | Class : <?= htmlspecialchars($student['class_name'] . '-' . $student['section_name']); ?></b></p>
									</div>
									
									<div class="col-md-6 text-end">
										<b>
											<?php $break = true;
											if ($student['coupon_balance'] != 0) {
												$break = false;
											?>
												Available  Coupons : <?= $student['coupon_balance'] ?? '0'; ?> /
											<?php } if($student['snack_balance']){
												$break = false;
												echo "Available Snack Amount : ".$student['snack_balance'];
											}

if($break)
												echo "<br>";
											?>
										</b>
									</div>
                                        
                                    <div class="col-md-4">
                                    <?php
                                        $student_member_type = $student['member_type'];
                                        if ($student['member_type'] == 1) {
                                            $member_type = 'Student';
                                        } elseif ($student['member_type'] == 2) {
                                            $member_type = 'Teacher';
                                        }
                                    ?>
                                        
                                        
                                    <?php
                                        $couponQuery = mysqli_query($con, "SELECT coupon_id, coupon_name, no_of_coupons, coupon_amount, member_type FROM coupon where member_type = $student_member_type ORDER BY coupon_id ASC");
                                        $couponData = [];
                                        while ($row = mysqli_fetch_assoc($couponQuery)) {
                                            $couponData[$row['coupon_id']] = [
                                                'name'   => $row['coupon_name'],
                                                'count'  => $row['no_of_coupons'],
                                                'amount' => $row['coupon_amount']
                                            ];
                                        }
                                        $couponDataJSON = htmlspecialchars(json_encode($couponData), ENT_QUOTES, 'UTF-8');

$packageQuery = mysqli_query($con, "SELECT * FROM snack_packages where delete_status = 0 AND ref_status_id = 1 ORDER BY package_id ASC");

$packRes = mysqli_fetch_all($packageQuery, MYSQLI_ASSOC);
                                    ?>

<select name="coupon_id[]" class="form-select coupon-select"
                                                        data-coupon='<?= $couponDataJSON ?>'>
                                                        <option value="">-- Select Coupon --</option>
                                                        <?php foreach ($couponData as $id => $coupon): ?>
                                                            <option value="<?= $id ?>"><?= $coupon['name'] ?></option>
                                                        <?php endforeach; ?>
                                                    </select>

<div class="row mt-2">
                                                        <div class="col-md-5 pe-1">
                                                            <input type="text" name="no_of_coupons[]" title="Coupons" 
                                                                class="form-control no-of-coupons"
                                                                placeholder="Coupons" readonly
                                                                style="background-color: #80808029;">
                                                        </div>
                                                        <div class="col-md-7 ps-1">
                                                            <div class="input-group">
                                                                <span class="input-group-text">Rs</span>
                                                                <input type="text" name="coupon_amount[]"
                                                                    class="form-control coupon-amount"
                                                                    placeholder="" readonly
                                                                    style="background-color: #80808029;">
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <select name="snack_package_id[]" class="form-select mt-4 snack-select">
                                                        <option value="">-- Select Package --</option>
                                                    <?php foreach ($packRes as $res) { ?>
                                                        <option value="<?= $res['package_id']; ?>" data-amt="<?= $res['package_amount']; ?>"><?= $res['package_name'] ?></option>
                                                    <?php } ?>
                                                    </select>
                                                    <div class="row mt-2">
                                                        <div class="col-md-12 me-2">
                                                            <div class="input-group">
                                                                <span class="input-group-text">Snack Amt</span>
                                                                <input type="text" name="snack_amount[]" class="form-control snack_amount" readonly style="background-color: #80808029;">
                                                            </div>
                                                        </div>
                                                    </div>
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                <?php
                                }

?>
                            </div>
                                <div class="row mt-2">
                                    <div class="col-md-3 pe-1">
                                        <div class="input-group">
                                            <span class="input-group-text">Total Amt</span>
                                            <input type="text" class="form-control total_amt" readonly style="background-color: #80808029;">
                                        </div>
                                    </div>
                                    <div class="col-md-2 mt-2 mx-3">
                                        <div class="form-check-inline">
                                            <input class="form-check-input" type="radio" name="payment_type"
                                                value="1">
                                            <label class="form-check-label" for="radio1">CASH</label>
                                        </div>

<div class="col-md-4">
                                        <div class="form-group" id="upiRefInput" style="display: none;">
                                            <label for="upi_reference"><b>UPI Transaction Reference Number *</b></label>
                                            <input type="text" name="upi_reference" id="upi_reference" class="form-control"
                                                placeholder="Enter UPI Ref No">
                                        </div>
                                    </div>
                                </div>
                                <br>
                                <div class="row">
                                    <div class="col-md-12 text-end">
                                        <button type="button" id="openConfirmation" class="btn btn-danger">Submit</button>
                                        <input type="submit" id="submitBtn" class="me-5 btn btn-warning submit" name="submit" value="Cancel">
                                    </div>
                                </div>
                                <br>
                        <?php
                                        } else {
                                            echo "<div class='alert alert-warning'>No students found with phone number \"$phone_no\".</div>";
                                        }
                                    }
                        ?>

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

</form>
                            <br>

</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" ?>;

</body>

$('#Numbers').on('input', function() {
        this.value = this.value.replace(/[^0-9]/g, '');
    });
</script>
<script>
    $(document).ready(function(){
        $('.snack-select').on('change', function(){
            var amount = $(this).find('option:selected').attr('data-amt');
            const element = $(this).closest('.student-row').find('.snack_amount'); 
            if(amount)
                element.val(amount);
            else
                element.val('');

updateTotal();
        });
        
        $('.coupon-select').on('change', function(){
            updateTotal();
        });

function updateTotal(){
            var total = 0;
            $('.coupon-amount').each(function(){
                total += parseFloat($(this).val() || 0);
            });

$('.snack_amount').each(function(){
                total += parseFloat($(this).val() || 0);
            });

$('.total_amt').val(total);
        }
    });
    document.querySelectorAll('.coupon-select').forEach(function(select) {
        const couponDetails = JSON.parse(select.getAttribute('data-coupon'));
        const row = select.closest('.student-row');

select.addEventListener('change', function() {
            const selected = this.value;
            const noField = row.querySelector('.no-of-coupons');
            const amtField = row.querySelector('.coupon-amount');

if (selected && couponDetails[selected]) {
                noField.value = couponDetails[selected].count;
                amtField.value = couponDetails[selected].amount;
            } else {
                noField.value = '';
                amtField.value = '';
            }
        });
    });
</script>

radioButtons.forEach(function(radio) {
            radio.addEventListener("change", function() {
                if (this.value === "4") {
                    upiRefInput.style.display = "block";
                    upiInputField.setAttribute("required", "required");
                } else {
                    upiRefInput.style.display = "none";
                    upiInputField.removeAttribute("required");
                }
            });
        });
    });
</script>
<script>
    document.addEventListener("DOMContentLoaded", function() {
        const form = document.querySelector('form[action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>"]');
        const openModalBtn = document.getElementById("openConfirmation");
        const confirmSubmitBtn = document.getElementById("confirmSubmit");
        const upiInputField = document.getElementById("upi_reference");

openModalBtn.addEventListener("click", function() {
            const paymentType = document.querySelector('input[name="payment_type"]:checked');
            const upiRef = upiInputField?.value.trim();
            const studentTables = document.querySelectorAll('.student-table');

if (!paymentType) {
                alert("Please select a payment type.");
                return;
            }

if (paymentType.value === "4" && !upiRef) {
                alert("Please enter UPI reference number.");
                return;
            }

studentTables.forEach((table) => {
                const name = table.querySelector('tr:nth-child(2) th')?.innerText || '';
                const reg = table.querySelector('tr:nth-child(1) th')?.innerText || '';
                const couponSelect = table.querySelector('.coupon-select');
                const count = table.querySelector('.no-of-coupons').value;
                const amount = table.querySelector('.coupon-amount').value;
                const packageSelect = table.querySelector('.snack-select');
                const snack_amount = table.querySelector('.snack_amount').value;

if (couponSelect.value && count && amount) {
                    hasStudentData = true;
                    hasName = true;
                    const couponName = couponSelect.options[couponSelect.selectedIndex].text;
                    summaryHtml += `
                    <hr>
                    <p><strong>Student ${name}</strong> (${reg})</p>
                    <p><strong>Coupon:</strong> ${couponName}</p>
                    <p><strong>Quantity:</strong> ${count}</p>
                    <p><strong>Amount:</strong> Rs ${amount}</p>
                `;
                }else{
                    hasName = false;
                }

if(packageSelect.value && snack_amount){
                    hasStudentData = true;
                    const packageName = packageSelect.options[packageSelect.selectedIndex].text;
                    if(!hasName)
                        summaryHtml += ` <hr> <p><strong>Student ${name}</strong> (${reg})</p>`;
                    
                    summaryHtml += `
                    <p><strong>Snack Package:</strong> ${packageName}</p>
                    <p><strong>Snack Amount:</strong> Rs ${snack_amount}</p>
                `;
                }
            });

if (!hasStudentData) {
                alert("Please fill at least one student's coupon details.");
                return;
            }

document.getElementById("confirmationModalBody").innerHTML = summaryHtml;
            new bootstrap.Modal(document.getElementById('confirmationModal')).show();
        });

confirmSubmitBtn.addEventListener("click", function() {
            const hiddenSubmit = document.createElement("input");
            hiddenSubmit.type = "hidden";
            hiddenSubmit.name = "submit";
            hiddenSubmit.value = "Submit";
            form.appendChild(hiddenSubmit);
            form.submit();
        });
    });
</script>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: purchase_coupon.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation