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: coupon-delivery-list.php

<?php
include('header.php'); 
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
$from_date    = $_GET['from_date'] ?? '';
$to_date      = $_GET['to_date'] ?? '';
$class_id     = $_GET['class_id'] ?? '';
$section_id   = $_GET['section_id'] ?? '';
$payment_type = $_GET['payment_type'] ?? '';
$transaction_type = $_GET['transaction_type'] ?? '';

$cancelMsg = '';

if (isset($_GET['cancel_id'])) {
    $coupon_id = $_GET['cancel_id'];

if (!isset($_SESSION["user_password"])) {
        $cancelMsg = "Session expired.";
    } elseif ($_SERVER['REQUEST_METHOD'] === 'POST') {
        $admin_password = $_POST['admin_password'];

if ($admin_password !== $_SESSION["user_password"]) {
            $cancelMsg = "Invalid admin password.";
        } else {
            $res = mysqli_query($con, "SELECT * FROM coupon_transaction WHERE coupon_id = '$coupon_id'");

if (!$res || mysqli_num_rows($res) === 0) {
                $cancelMsg = "Transaction not found.";
            } else {
                $row = mysqli_fetch_assoc($res);
                $student_id = $row['ref_student_id'];
                $coupons = $row['no_of_coupons'];
                $payment_type = $row['payment_type'];
                $payment_amount = $row['payment_amount'];

if ($payment_type == 2) {                
                $sql = "
                    UPDATE student SET
                    credit_amount = credit_amount - $payment_amount,
                    credit_coupon = credit_coupon - $coupons
                    WHERE student_id = '$student_id'
                ";
                 }else{
                  $sql = "
                    UPDATE student 
                    SET coupon_balance = coupon_balance + $coupons, 
                    coupon_redeemed = coupon_redeemed - $coupons,
                    coupon_purchased = coupon_purchased + $coupons
                    WHERE student_id = '$student_id'
                ";
                 }
                // print_r($sql);die();
                $updateStudent = mysqli_query($con, $sql);

$updateTransaction = mysqli_query($con, "
                    UPDATE coupon_transaction 
                    SET transaction_type = 3 
                    WHERE coupon_id = '$coupon_id'
                ");

if ($updateStudent && $updateTransaction) {
                    $cancelMsg = "Transaction cancelled successfully.";
                } else {
                    $cancelMsg = "Failed to cancel transaction.";
                }
            }
        }

echo "<script>alert('" . addslashes($cancelMsg) . "'); window.location.href='issue-coupons.php';</script>";
        exit;
    }
}
?>
<?php if (!empty($user_permissions['view'])): ?>
<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">Coupon Transactions</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">Coupon Transactions</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>
            
            <div class="row">
                <div class="col-lg-12">
                    <div class="card">
                        <div class="card-body">
                            <div class="row">
                                <?php if (isset($_GET['cancel_id'])): ?>
                                <div class="alert alert-warning">
                                    <form method="post">
                                        <input type="hidden" name="coupon_id"
                                            value="<?= htmlspecialchars($_GET['cancel_id']) ?>">
                                        <div class="mb-2">
                                            <label>Enter Admin Password to Cancel:</label>
                                            <input type="password" name="admin_password" class="form-control" required>
                                        </div>
                                        <button type="submit" class="btn btn-danger">Confirm Cancel</button>
                                        <a href="coupon-transactions.php" class="btn btn-secondary">Back</a>
                                    </form>
                                </div>
                                <?php endif; ?>

<form method="GET" class="mb-3">
                                    <div style="display: flex; flex-wrap: wrap; gap: 15px; align-items: flex-end;">
                                        
                                        <div>
                                            <label>From Date</label>
                                            <input type="date" name="from_date" value="<?= $from_date ?>"
                                                class="form-control">
                                        </div>
                                        <div>
                                            <label>To Date</label>
                                            <input type="date" name="to_date" value="<?= $to_date ?>"
                                                class="form-control">
                                        </div>
                                        <div>
                                            <label>Class</label>
                                            <select name="class_id" class="form-control">
                                                <option value="">All</option>
                                                <?php
                $classSql = "SELECT class_id, class_name FROM class WHERE ref_status_id = 1 AND delete_status = 1";
                $classRes = mysqli_query($con, $classSql);
                while ($c = mysqli_fetch_assoc($classRes)) {
                    echo "<option value='{$c['class_id']}' " . ($class_id == $c['class_id'] ? 'selected' : '') . ">{$c['class_name']}</option>";
                }
                ?>
                                            </select>
                                        </div>
                                        <div>
                                            <label>Section</label>
                                            <select name="section_id" class="form-control">
                                                <option value="">All</option>
                                                <?php
                $secSql = "SELECT section_id, section_name FROM section WHERE ref_status_id = 1 AND delete_status = 0";
                $secRes = mysqli_query($con, $secSql);
                while ($s = mysqli_fetch_assoc($secRes)) {
                    echo "<option value='{$s['section_id']}' " . ($section_id == $s['section_id'] ? 'selected' : '') . ">{$s['section_name']}</option>";
                }
                ?>
                                            </select>
                                        </div>
                                        <div>
                                            <label>Transaction Type</label>
                                            <select name="transaction_type" class="form-control">
                                                <option value="">All</option>
                                                <option value="1" <?= ($transaction_type == '1') ? 'selected' : '' ?>>Purchase</option>
                                                <option value="2" <?= ($transaction_type == '2') ? 'selected' : '' ?>>Redeem</option>
                                                <option value="3" <?= ($transaction_type == '3') ? 'selected' : '' ?>>Cancel</option>
                                                <option value="4" <?= ($transaction_type == '4') ? 'selected' : '' ?>>Point of sale</option>
                                            </select>
                                        </div>

<div>
                                            <label>Payment Type</label>
                                            <select name="payment_type" class="form-control">
                                                <option value="">All</option>
                                                <option value="1" <?= ($payment_type == '1') ? 'selected' : '' ?>>Cash
                                                </option>
                                                <option value="2" <?= ($payment_type == '2') ? 'selected' : '' ?>>Credit
                                                </option>
                                                <option value="3" <?= ($payment_type == '3') ? 'selected' : '' ?>>Wallet
                                                </option>
                                            </select>
                                        </div>

<div>
                                            <label>&nbsp;</label><br>
                                            <button type="submit" class="btn btn-primary">Search</button>
                                            
                                            <a href="coupon-delivery-list.php" class="btn btn-secondary">Reset</a>
                                        </div>
                                        <?php
$queryParams = http_build_query([
    'export' => 1,
    'from_date' => $from_date,
    'to_date' => $to_date,
    'class_id' => $class_id,
    'section_id' => $section_id,
    'payment_type' => $payment_type,
    'transaction_type' => $transaction_type
]);
?>
                                        <div style="margin-left: auto;">
                                            
                                            <a href="export.php?<?= $queryParams ?>" class="btn btn-success" style="margin-left:10px;">
                                                Export to Excel
                                            </a>

</div>

</div>
                                </form>

<table id="scroll-horizontal" class="example table nowrap align-middle"
                                    style="width:100%">
                                    <thead>
                                        <tr>
                                            <th align="left">Sl. No</th>
                                            <th align="left">Date</th>
                                            <th align="left">Member Details</th>
                                            
                                            
                                            <th align="left">Coupons</th>
                                            <th align="left">Snack Package</th>
                                            <th align="left">Snack Amount</th>
                                            <th align="left">Payment Type</th>
                                            <th align="left">Payment Status</th>
                                            <th align="right">Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
// $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.transaction_type,
//         ct.added_date,
//         ct.payment_status,
//         ct.snack_amount,
//         ct.ref_member_type,
//         sp.package_name,
//         mt.member_type_name
//     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
//     LEFT JOIN snack_packages sp ON sp.package_id = ct.snack_package_id
//     LEFT JOIN member_type mt ON mt.member_type_id = ct.ref_member_type
//     WHERE ct.delete_status = 0
// ";

// // Apply filters
// if ($from_date)     $sql .= " AND DATE(ct.transaction_date) >= '$from_date'";
// if ($to_date)       $sql .= " AND DATE(ct.transaction_date) <= '$to_date'";
// if ($class_id)      $sql .= " AND c.class_id = $class_id";
// if ($section_id)    $sql .= " AND sec.section_id = $section_id";
// if ($payment_type)  $sql .= " AND ct.payment_type = $payment_type";
// if ($transaction_type)  $sql .= " AND ct.transaction_type = $transaction_type";

// $sql .= " ORDER BY ct.transaction_date DESC";
$sql = "SELECT ct.*, sp.package_name, mt.member_type_name, 
               CASE WHEN ct.transaction_type != 4 THEN s.student_name ELSE NULL END AS student_name,
               CASE WHEN ct.transaction_type != 4 THEN c.class_name ELSE NULL END AS class_name,
               CASE WHEN ct.transaction_type != 4 THEN sec.section_name ELSE NULL END AS section_name,
               CASE WHEN ct.transaction_type != 4 THEN s.mobile_no ELSE NULL END AS mobile_no
        FROM coupon_transaction ct 
        LEFT JOIN snack_packages sp ON sp.package_id = ct.snack_package_id 
        LEFT JOIN member_type mt ON mt.member_type_id = ct.ref_member_type 
        LEFT JOIN student s ON s.student_id = ct.ref_student_id
        LEFT JOIN class c ON c.class_id = s.ref_class_id 
        LEFT JOIN section sec ON sec.section_id = s.ref_section_id
        WHERE ct.delete_status = 0 ";
        // // Apply filters
if ($from_date)     $sql .= " AND DATE(ct.transaction_date) >= '$from_date'";
if ($to_date)       $sql .= " AND DATE(ct.transaction_date) <= '$to_date'";
if ($class_id)      $sql .= " AND c.class_id = $class_id";
if ($section_id)    $sql .= " AND sec.section_id = $section_id";
if ($payment_type)  $sql .= " AND ct.payment_type = $payment_type";
if ($transaction_type)  $sql .= " AND ct.transaction_type = $transaction_type";

$sql .= " ORDER BY ct.transaction_date DESC";
// echo $sql;die();

$res = mysqli_query($con, $sql);
if ($res && mysqli_num_rows($res) > 0) {
    $sn = 1;
    while ($row = mysqli_fetch_assoc($res)) {
        switch ($row['payment_type']) {
    case 1:
        $btnClass = 'success';
        $btnText = 'CASH';
        break;
    case 2:
        $btnClass = 'danger';
        $btnText = 'CREDIT';
        break;
    case 3:
        $btnClass = 'info';
        $btnText = 'ONLINE';
        break;
    case 4:
        $btnClass = 'info';
        $btnText = 'UPI';
        break;
    case 5:
        $btnClass = 'primary';
        $btnText = 'WALLET';
        break;
    default:
        $btnClass = 'secondary';
        $btnText = 'UNKNOWN';
}
switch ($row['payment_status']) {
    case 1:
        $paybtnClass = 'success';
        $paybtnText = 'Paid';
        break;
    case 2:
        $paybtnClass = 'danger';
        $paybtnText = 'Unpaid';
        break;    
    default:
        $paybtnClass = 'secondary';
        $paybtnText = 'UNKNOWN';
}
?>
                                        <tr>
                                            <td><?= $sn ?></td>
                                            <td><?= date('d-m-Y', strtotime($row['transaction_date'])) ?></td>
                                            <?php
                                            if($row['transaction_type'] == 4){?>
                                                <td><?= $row['member_type_name'] ?? '';?></td>
                                            <?php 
                                            }else{ ?>
                                            
                                                 <td><?= htmlspecialchars($row['student_name']).'<br>'.$row['class_name'].'-'.$row['section_name'].'<br>'. $row['mobile_no']?></td>   
                                            <?php 
                                            }
                                            ?>        
                                                                            
                                            
                                            
                                            <td><?= $row['no_of_coupons'] ?></td>
                                            <td><?= $row['package_name'] ?></td>
                                            <td><?= $row['snack_amount'] ?></td>
                                            <td><button type="button"
                                                    class="btn btn-<?= $btnClass ?>"><?= $btnText ?></button></td>
                                            <td><button type="button"
                                                    class="btn btn-<?= $paybtnClass ?>"><?= $paybtnText ?></button></td>

<td align="right">
                                                <?php
                                                if($row['transaction_type']== 2){
                                                ?>
                                                <button type="button" class="btn btn-warning" style="font-size:14px;"
                                                    onclick="if(confirm('Are you sure to cancel this transaction?')) { window.location.href='?cancel_id=<?= $row['coupon_id'] ?>'; }">
                                                    <i class="ri-pencil-fill"></i> CANCEL
                                                </button>

<?php
                                                }
                                                ?>
                                            <?php
                                                if($row['transaction_type']== 3){
                                                ?>
                                                <button type="button" class="btn btn-danger" style="font-size:14px;">
                                                    <i class="ri-pencil-fill"></i> CANCELLED
                                                </button>

<?php
                                                }
                                                ?>
                                            </td>
                                        </tr>
                                        <?php
        $sn++;
    }
} else {
    ?>
                                        <tr>
                                            <td colspan="8" class="text-center">No coupon transactions found.</td>
                                        </tr>
                                        <?php
}

?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div> 
        </div> 
    </div> 
</div> 

<div class="modal fade" id="cancelModal" tabindex="-1" aria-labelledby="cancelModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="post"
            enctype="multipart/form-data">

<div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="cancelModalLabel">Cancel Transaction</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <input type="hidden" name="transaction_id" id="transaction_id">
                    <div class="mb-3">
                        <label for="admin_password" class="form-label">Enter Admin Password</label>
                        <input type="password" class="form-control" name="admin_password" id="admin_password" required>
                    </div>
                    <div id="cancelError" class="text-danger d-none">Invalid password or transaction failed.</div>
                </div>
                <div class="modal-footer">
                    <button type="submit" name="cancel_transaction" value="cancel_transaction"
                        class="btn btn-danger">Confirm Cancel</button>
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                </div>
            </div>
        </form>
    </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"); ?>
<script>
$(document).ready(function() {
    const $cancelForm = $('#cancelForm');
    const $cancelModal = new bootstrap.Modal($('#cancelModal')[0]);
    const $cancelError = $('#cancelError');

$('.cancel-btn').on('click', function(e) {
        e.preventDefault();
        $('#transaction_id').val($(this).data('id'));
        $('#admin_password').val('');
        $cancelError.addClass('d-none');
        $cancelModal.show();
    });

$cancelForm.on('submit', function(e) {
        e.preventDefault();
        const formData = new FormData(this);
        formData.append('cancel_transaction', '1');

fetch(window.location.href, {
                method: 'POST',
                body: formData
            })
            .then(res => res.json())
            .then(data => {
                if (data.status === 'success') {
                    location.reload();
                } else {
                    $cancelError.removeClass('d-none');
                }
            })
            .catch(() => {
                $cancelError.removeClass('d-none');
            });
    });
});
</script>

<!-- <script>
document.addEventListener('DOMContentLoaded', function() {
    const cancelBtns = document.querySelectorAll('.cancel-btn');
    const cancelForm = document.getElementById('cancelForm');
    const cancelModal = new bootstrap.Modal(document.getElementById('cancelModal'));

cancelBtns.forEach(btn => {
        btn.addEventListener('click', function(e) {
            e.preventDefault();
            document.getElementById('transaction_id').value = this.dataset.id;
            document.getElementById('admin_password').value = '';
            document.getElementById('cancelError').classList.add('d-none');
            cancelModal.show();
        });
    });

cancelForm.addEventListener('submit', function(e) {
        e.preventDefault();
        const formData = new FormData(cancelForm);
        formData.append('cancel_transaction', '1'); // Key to trigger PHP logic

fetch(window.location.href, {
                method: 'POST',
                body: formData
            }).then(res => res.json())
            .then(data => {
                if (data.status === 'success') {
                    location.reload();
                } else {
                    document.getElementById('cancelError').classList.remove('d-none');
                }
            }).catch(() => {
                document.getElementById('cancelError').classList.remove('d-none');
            });
    });

});
</script> -->

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: coupon-delivery-list.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation