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/canteen.avatarpublicschool.com/public_html

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: transaction_details.php

<?php
include('config.php');

$phone = isset($_GET['phone_no']) ? preg_replace('/\D/', '', $_GET['phone_no']) : '';
if (strlen($phone) < 3) {
    die("<div class='alert alert-danger'>Invalid or too short phone number.</div>");
}

$student_q = mysqli_query($con, "
    SELECT * FROM student as s LEFT JOIN member_type as mt ON mt.member_type_id = s.member_type
    WHERE s.mobile_no LIKE '%$phone%' 
      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%' AND delete_status = 0 AND ref_status_id = 1 AND member_type = 2 ) )
    ORDER BY s.student_name
");

if (!$student_q || mysqli_num_rows($student_q) === 0) {
    die("<div class='alert alert-warning'>No students or teachers found with phone number matching '" . htmlspecialchars($phone) . "'.</div>");
}

while ($student = mysqli_fetch_assoc($student_q)) {
    $student_id = (int)$student['student_id'];
    $current_balance = (int)($student['coupon_balance'] ?? 0);

$sql = "SELECT 
                MONTH(ct.transaction_date) AS month_no,
                YEAR(ct.transaction_date) AS year_no,
                MONTHNAME(ct.transaction_date) AS month_name,
                SUM(CASE WHEN ct.transaction_type = 1 THEN ct.no_of_coupons ELSE 0 END) AS purchased,
                SUM(CASE WHEN ct.transaction_type = 2 && payment_type != 2 THEN ct.no_of_coupons ELSE 0 END) AS redeemed,
                SUM(CASE WHEN ct.transaction_type = 1 THEN ct.snack_amount ELSE 0 END) AS purchased_snack,
                SUM(CASE WHEN ct.transaction_type = 2 THEN ct.snack_amount ELSE 0 END) AS redeemed_snack
            FROM coupon_transaction ct
            WHERE ct.ref_student_id = $student_id
                AND ct.delete_status = 0
                AND ct.transaction_date >= DATE_SUB(CURDATE(), INTERVAL 4 MONTH)
            GROUP BY YEAR(ct.transaction_date), MONTH(ct.transaction_date)
            ORDER BY YEAR(ct.transaction_date), MONTH(ct.transaction_date)
        ";

$res = mysqli_query($con, $sql);
    ?>

<div class="row">
        <div class="col-md-8 mt-3">
            
			<p><b>Name : <?= htmlspecialchars($student['student_name']); ?> | 
			Reg No : <?= htmlspecialchars($student['student_regno']); ?> |
			Member Type : <?= htmlspecialchars($student['member_type_name']); ?></b></p>
        </div>

<div class="col-md-12">
            <table class="table table-bordered w-100">
                <thead>
                    <tr>
                        <th>Month</th>
                        <th>Prev Month Coupons</th>   
                        <th>Purchased Coupons</th>
                        <th>Redeemed Coupons</th>
                        <th>Available Coupons</th>
                        <th align="right">Prev Month Snack Amt</th>   
                        <th align="right">Purchased Snack Amt</th>
                        <th align="right">Redeemed Snack Amt</th>
                        <th align="right">Available Snack Amt</th>
                        <th>Payment Status</th>
                    </tr>
                </thead>
                <tbody>
<?php
$prev_available = 0;
$prev_amt = 0;
$credit_coupon = (int)($student['credit_coupon'] ?? 0);
$has_data = false;  // flag to check if any month has data
$before4mth = date('F', strtotime('-3 month'));

while ($row = mysqli_fetch_assoc($res)) {
    $has_data = true;  // found at least one month with data

$month_name = $row['month_name'];
    $purchased = $row['purchased'];
    $redeemed = $row['redeemed'];
    $available = $prev_available + $purchased - $redeemed;
    $purchased_snack = $row['purchased_snack'];
    $redeemed_snack = $row['redeemed_snack'];
    $available_snack_amt = $prev_amt + $purchased_snack - $redeemed_snack;

if ($purchased > 0) {
        if ($available > 0) {
            $payment_status = 'PAID';
            $btn_class = 'btn-success';
        } elseif ($available <= 0 && $credit_coupon > 0) {
            $payment_status = 'PENDING';
            $btn_class = 'btn-danger';
        } else {
            $payment_status = '';
            $btn_class = '';
        }
    } else {
        $payment_status = '';
        $btn_class = '';
    }

if($before4mth != $month_name) {
?>
    <tr>
        <td><?= htmlspecialchars($month_name); ?></td>
        <td align="center"><?= $prev_available; ?></td>
        <td align="center"><?= $purchased; ?></td>
        <td align="center"><?= $redeemed; ?></td>
        <td align="center"><?= $available; ?></td>
        <td align="right">₹ <?= $prev_amt; ?></td>
        <td align="right">₹ <?= $purchased_snack; ?></td>
        <td align="center"><?= $redeemed_snack; ?></td>
        <td align="right">₹ <?= $available_snack_amt; ?></td>
        <td>
            <?php if ($payment_status): ?>
                <span class="btn <?= $btn_class; ?> btn-sm"><?= $payment_status; ?></span>
            <?php endif; ?>
        </td>
    </tr>
<?php }
    $prev_amt = $available_snack_amt;
    $prev_available = $available; // update for next iteration
} // end foreach months

// Show "No data found" if none printed
if (!$has_data) {
    ?>
    <tr>
        <td colspan="10" class="text-center text-muted">No coupon transactions found.</td>
    </tr>
    <?php
}
?>
</tbody>

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

<hr>

<?php
} // end while student
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: transaction_details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation