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

<?php
include('header.php'); // This should set up $conn as MySQLi connection

if (isset($_POST['collect_payment'])) {
    $coupon_id = $_POST['coupon_id'];
    $payment_mode = $_POST['payment_mode'];
    $upi_ref = $_POST['upi_ref'] ?? null;

$amount = floatval($_POST['amount']);
    $coupons = intval($_POST['coupon_count']);

$query = "
        SELECT ref_student_id 
        FROM coupon_transaction 
        WHERE coupon_id = '$coupon_id'
    ";
    $result = mysqli_query($con, $query);
    $data = mysqli_fetch_assoc($result);

if ($data) {
        $student_id = $data['ref_student_id'];

$updateStudentQuery = "
            UPDATE student 
            SET 
                credit_coupon = GREATEST(credit_coupon - $coupons, 0),
                credit_amount = GREATEST(credit_amount - $amount, 0)
            WHERE student_id = '$student_id'
        ";

$updateCouponTransactionQuery = "
            UPDATE coupon_transaction 
            SET transaction_status = 1 ,payment_status = 1
            WHERE coupon_id = '$coupon_id'
        ";

$insertCreditTransactionQuery = "
            INSERT INTO credit_transaction (
                ref_student_id, 
                ref_coupon_trans_id, 
                payment_type, 
                transaction_status, 
                transaction_date, 
                added_date
            ) VALUES (
                '$student_id', 
                '$coupon_id', 
                '$payment_mode', 
                1, 
                NOW(), 
                NOW()
            )
        ";

// echo "<pre>$updateStudentQuery</pre>";
        // echo "<pre>$updateCouponTransactionQuery</pre>";
        // echo "<pre>$insertCreditTransactionQuery</pre>";
        // die();        
        $updatestu           = mysqli_query($con, $updateStudentQuery);
        $updatecoptrans      = mysqli_query($con, $updateCouponTransactionQuery);
        $insertcredtrans     = mysqli_query($con, $insertCreditTransactionQuery);

if ($updatestu && $updatecoptrans && $insertcredtrans) {
            echo "<script>
            alert('Transaction successfully!');
            window.location.href = 'pendingpayments.php';
        </script>";
            exit;
        } else {
            echo "<script>alert('Error adding student.');</script>";
        }
    } else {
        $error_message = "Invalid coupon ID.";
    }
}

<?php if (!empty($user_permissions['view'])): ?>
<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">Pending List</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">Pending</li>
                            </ol>
                        </div>

</div>
                </div>
            </div>

<thead>
                                        <tr>
                                            <th align="left">Sl. No</th>
                                            <th align="left"><input type="checkbox" id="checkAll"></th>
                                            <th align="left">Name</th>
                                            <th align="left">Class/Section</th>
                                            <th align="left">Contact No</th>
                                            <th align="left">Amount</th>
                                            <th align="left">Collect</th>
                                            <th align="left">SMS Status</th>
                                            
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        // Your SQL query
                                        $sql = "
                                            SELECT 
                                                ct.coupon_id,
                                                ct.transaction_date, 
                                                s.student_name, 
                                                CONCAT(c.class_name, '-', sec.section_name) AS class_section,
                                                s.mobile_no, 
                                                ct.no_of_coupons, 
                                                ct.payment_type,
												ct.payment_amount,
                                                ct.credit_coupon
                                            FROM coupon_transaction ct
                                            JOIN student s ON ct.ref_student_id = s.student_id
                                            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 ct.payment_type = 2 && ct.transaction_type != 3 && ct.transaction_status = 2
                                            ORDER BY ct.added_date DESC
                                        ";

$result = mysqli_query($con, $sql);
                                        if ($result->num_rows > 0):
                                            $sl_no = 1; ?>

<?php while ($row = $result->fetch_assoc()): ?>
                                                <?php
                                                // $smsStatus = (rand(0, 1) == 1) ? "SENT" : "NOT SENT"; 
                                                // $smsClass = ($smsStatus === "SENT") ? "btn-success" : "btn-danger";
                                                $smsStatus = "NOT SENT";
                                                $smsClass = "btn-danger";
                                                ?>
                                                <tr>
                                                    <td><?php echo $sl_no++; ?></td>
                                                    <td>
                                                        <input type="checkbox" class="couponCheckbox" name="coupon_ids[]" value="<?php echo $row['coupon_id']; ?>">
                                                    </td>
                                                    <td><?php echo $row['student_name']; ?></td>
                                                    <td><?php echo $row['class_section']; ?></td>
                                                    <td><?php echo $row['mobile_no']; ?></td>
                                                    <td><b>₹ <?php echo number_format($row['payment_amount']); ?></b></td>
                                                    <td>
                                                        <button
                                                            class="btn btn-primary collect-btn"
                                                            data-id="<?php echo $row['coupon_id']; ?>"
                                                            data-name="<?php echo $row['student_name']; ?>"
                                                            data-amount="<?php echo $row['payment_amount']; ?>"
                                                            data-coupons="<?php echo $row['credit_coupon']; ?>">
                                                            Collect Amount
                                                        </button>
                                                    </td>

<td><span class="btn <?php echo $smsClass; ?>"><?php echo $smsStatus; ?></span></td>
                                                </tr>
                                            <?php endwhile; ?>
                                        <?php else: ?>
                                            <tr>
                                                <td colspan="7" style="text-align:center;">No records found</td>
                                            </tr>
                                        <?php endif; ?>

</tbody>
                                </table>

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

<div class="modal fade" id="collectAmountModal" tabindex="-1" role="dialog" aria-labelledby="modalTitle" aria-hidden="true">
    <div class="modal-dialog" role="document">

<form method="POST" id="collectAmountForm">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Collect Payment</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>

<div class="mb-3">
                        <label for="coupon_count" class="form-label">Coupons</label>
                        <input type="number" name="coupon_count" id="coupon_count" style="background-color: lightgrey;" class="form-control" min="1" readonly>
                    </div>

<div class="mb-3">
                        <label for="amount" class="form-label">Amount</label>
                        <input type="number" step="0.01" name="amount" id="amount" style="background-color: lightgrey;" class="form-control" min="0" readonly>
                    </div>

<div class="mb-3">
                        <label>Payment Mode</label><br>
                        <input type="radio" name="payment_mode" value="1" required> Cash
                        <input type="radio" name="payment_mode" value="4"> UPI/NEFT
                    </div>

<div class="mb-3 d-none" id="upiRefDiv">
                        <label for="upi_ref">UPI Reference Number *</label>
                        <input type="text" name="upi_ref" id="upi_ref" class="form-control">
                    </div>
                </div>

<div class="modal-footer">
                    <button type="submit" name="collect_payment" class="btn btn-success">Submit</button>
                </div>
            </div>
        </form>

</div>
</div>

<?php include("footer.php"); ?>
<script>
    // Open modal with details

$(document).ready(function() {
        $('.collect-btn').click(function() {
            $('#coupon_id').val($(this).data('id'));
            $('#student_name').val($(this).data('name'));
            $('#amount').val($(this).data('amount'));
            $('#coupon_count').val($(this).data('coupons'));
            $('#collectAmountModal').modal('show');
        });

$('input[name="payment_mode"]').change(function() {
            if ($(this).val() === '4') {
                $('#upiRefDiv').removeClass('d-none');
                $('#upi_ref').attr('required', true);
            } else {
                $('#upiRefDiv').addClass('d-none');
                $('#upi_ref').removeAttr('required');
            }
        });

// Submit Form via AJAX

});
    // Select DOM elements
    const checkAll = document.getElementById('checkAll');
    const checkboxes = document.querySelectorAll('.couponCheckbox');
    const sendSmsBtn = document.getElementById('sendSmsBtn');

// Check all checkboxes when "Check All" is clicked
    checkAll.addEventListener('change', function() {
        checkboxes.forEach(checkbox => {
            checkbox.checked = this.checked;
        });
        toggleSendSmsBtn();
    });

// Enable/disable button based on selections
    checkboxes.forEach(checkbox => {
        checkbox.addEventListener('change', toggleSendSmsBtn);
    });

function toggleSendSmsBtn() {
        const anyChecked = Array.from(checkboxes).some(cb => cb.checked);
        sendSmsBtn.disabled = !anyChecked;
    }
</script>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: pendingpayments.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation