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

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

if (!isset($_GET['id']) || empty($_GET['id'])) {
    echo "No student ID specified.";
    exit;
}

$student_id = intval($_GET['id']);

$sql = "
    SELECT s.student_name, s.mobile_no, s.guardian_name,
           c.class_name,     
           sec.section_name, 
           st.status_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
    LEFT JOIN status st ON s.ref_status_id = st.status_id
    WHERE s.student_id = $student_id
    AND s.delete_status = 0
";

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

if (!$result || mysqli_num_rows($result) == 0) {
    echo "Student not found.";
    exit;
}

$student = mysqli_fetch_assoc($result);
?>



<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">&nbsp;</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">Student Info</li>
                            </ol>
                        </div>

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

<div class="row">
                <div class="col-lg-12">
                    <div class="card">
                        <div class="card-header">
                            <div class="row">
                                <h5 class="card-title mb-0 col-lg-10">Student Info</h5>
                            </div>
                        </div>

<div class="card-body">
                            <div class="row">
                                <div class="col-md-4	">
                                    <table class="table table-bordered">
                                        <tr>
                                            <th width="30%" align="left">Name</th>
                                            <td align="left"><?php echo $student['student_name']; ?></td>
                                        </tr>
                                        <tr>
                                            <th align="left">Class/Section</th>
                                            <td align="left">
                                                <?php echo $student['class_name'] . '-' . $student['section_name']; ?>
                                            </td>
                                        </tr>

<tr>
                                            <th align="left">Mobile No</th>
                                            <td align="left"><?php echo $student['mobile_no']; ?></td>
                                        </tr>
                                        <tr>
                                            <th align="left">Father Name</th>
                                            <td align="left"><?php echo $student['guardian_name']; ?></td>
                                        </tr>
                                        <tr>
                                            <th align="left">Status</th>
                                            <td align="left"><?php echo $student['status_name']; ?></td>
                                        </tr>
                                    </table>

</div>
                                <div class="col-md-8 table-responsive">
                                  <?php

$student_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
if (!$student_id) {
    die("Invalid student ID.");
}

$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 13 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);

$student = mysqli_fetch_assoc(mysqli_query($con, "SELECT coupon_balance FROM student WHERE student_id = $student_id"));
$current_balance = (int)($student['coupon_balance'] ?? 0);

<table class="table table-striped table-bordered w-100">
                <thead>
                    <tr style="background-color: skyblue;">
                        <th>Month</th>
                        <th>Previous Month Coupons</th>   
                        <th>Purchased Coupons</th>
                        <th>Redeemed Coupons</th>
                        <th>Available Coupons</th>
                        <th>Prev Month Snack Amt</th>   
                        <th>Purchased Snack Amt</th>
                        <th>Redeemed Snack Amt</th>
                        <th>Available Snack Amt</th>
                        <th>Payment Status</th>
                    </tr>
                </thead>
                <tbody>
                    <tbody>
<?php
$prev_available = 0;
$prev_amt = 0;
$credit_coupon = (int)($student['credit_coupon'] ?? 0);
$has_data = false;
$before4mth = date('F', strtotime('-11 month'));

while ($row = mysqli_fetch_assoc($res)) {
    $has_data = true;

$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="center"><?= $prev_amt; ?></td>
        <td align="center"><?= $purchased_snack; ?></td>
        <td align="center"><?= $redeemed_snack; ?></td>
        <td align="center"><?= $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>
                </div>
            </div>
        </div>
    </div>
</div>
</div>
<?php  include "footer.php"?>;

</body>

$('#Numbers').on('input', function() {
    this.value = this.value.replace(/[^0-9]/g, '');
});
</script>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewstudent.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation