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

<?php
include('header.php');
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
$default_member_type = 3;

$food_prices = [];
$sql = "SELECT member_type, coupon_amount FROM coupon WHERE no_of_coupons = 1";
$result = mysqli_query($con, $sql);
if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {
        $food_prices[$row['member_type']] = $row['coupon_amount'];
    }
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $member_type = intval($_POST['ref_member_type']);
    $food_count = intval($_POST['food_count']);
    $payment_mode = $_POST['payment_mode'];
    $upi_reference_no = isset($_POST['upi_reference_no']) ? trim($_POST['upi_reference_no']) : null;

$payment_type = $payment_mode === 'upi' ? 4 : 1;

$sql_coupon = "SELECT coupon_id, coupon_amount FROM coupon WHERE member_type = $member_type AND no_of_coupons = 1 LIMIT 1";
    $result_coupon = mysqli_query($con, $sql_coupon);

if (!$result_coupon || mysqli_num_rows($result_coupon) === 0) {
        echo "<script>alert('Coupon not found for selected member type'); window.location.href='pointofsale.php';</script>";
        exit;
    }

$coupon = mysqli_fetch_assoc($result_coupon);
    $ref_coupon_id = $coupon['coupon_id'];
    $coupon_amount = floatval($coupon['coupon_amount']);
    $payment_amount = $coupon_amount * $food_count;
    $snack_total_amount = 0;
    $snack_ids = [];
    $snack_amounts = [];
    $snack_quantities = [];

if (!empty($_POST['snacks']) && is_array($_POST['snacks'])) {
        foreach ($_POST['snacks'] as $snack_id => $qty) {
            $qty = intval($qty);
            if ($qty > 0 && isset($_POST['snack_info'][$snack_id])) {
                $price = floatval($_POST['snack_info'][$snack_id]['amount']);
                $snack_total_amount += ($price * $qty);
                $snack_ids[] = $snack_id;
                $snack_amounts[] = $price;
                $snack_quantities[] = $qty;
            }
        }
    }

$ref_snack_ids = implode(',', $snack_ids);
    $ref_snack_amts = implode(',', $snack_amounts);
    $ref_snack_qtys = implode(',', $snack_quantities);

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

$sql_insert = "INSERT INTO coupon_transaction (
    transaction_date,
    transaction_type,
    ref_coupon_id,
    no_of_coupons,
    payment_type,
    payment_status,
    upi_reference_no,
    payment_amount,
    payment_date,
    transaction_status,
    delete_status,
    added_date,
    ref_snack_id,
    snack_amount,
    ref_snack_amt,
    snack_quantity,
    ref_member_type

) VALUES (
    '$added_date',
    4,
    '$ref_coupon_id',
    '$food_count',
    '$payment_type',
    1,
    '$upi_reference_no',
    '$payment_amount',
    '$added_date',
    1,
    0,
    '$added_date',
    '$ref_snack_ids',
    '$snack_total_amount',
    '$ref_snack_amts',
    '$ref_snack_qtys',
    $member_type
)";
// die();
    if (mysqli_query($con, $sql_insert)) {
        echo "<script>alert('Transaction saved successfully'); window.location.href='pointofsale.php';</script>";
        exit;
    } else {
        echo "<script>alert('Error saving transaction: " . mysqli_error($con) . "'); window.location.href='pointofsale.php';</script>";
        exit;
    }
}
?>
<?php if (!empty($user_permissions['add'])): ?>

<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">Point of Sale</h4>
                        <div class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="#">Home</a></li>
                                <li class="breadcrumb-item active">POS</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>

<div class="row">
                <div class="col-xl">
                    <div class="card mb-4">
                        <div class="card-body">
                            <form id="posForm" method="post" action="pointofsale.php">
                                <div class="card-body">
                                    <div class="row">
                                        
                                        <div class="col-md-3">
                                            <label><b>Choose Member Type</b></label>
                                            <select name="ref_member_type" id="memberType" class="form-control" required>
                                                <option value="">-- Select --</option>
                                                <option value="1">Student</option>
                                                <option value="2">Teacher</option>
                                                <option value="3" selected>Guest</option>
                                            </select>

<div id="foodSection" class="mt-3">
                                            <label><b>Enter No Of Coupons</b></label>
                                            <input type="number" name="food_count" id="foodCount" class="form-control" min="1" value="1" oninput="this.value = this.value.replace(/[^0-9]/g, '')">
                                            <small class="text-muted">₹<span id="foodUnitPrice">0</span> per item</small>
                                        </div>

<div id="snackSection" class="mt-3">
                                            <label><b>Add Snacks</b></label>

<div class="table-responsive">
                                                <table class="table table-bordered table-sm align-middle">
                                                    <thead class="table-light">
                                                        <tr>
                                                            <th width="10%" align="left">Snack Name</th>
                                                            <th width="10%" align="right">Price (₹)</th>
                                                            <th width="10%">Quantity</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        <?php
                                                        $snack_sql = "SELECT * FROM snack WHERE ref_status_id = 1 AND delete_status = 0";
                                                        $snack_result = mysqli_query($con, $snack_sql);

if ($snack_result && mysqli_num_rows($snack_result) > 0) {
                                                            while ($snack = mysqli_fetch_assoc($snack_result)) {
                                                                $snack_id = (int)$snack['snack_id'];
                                                                $snack_name = htmlspecialchars($snack['snack_name']);
                                                                $snack_amount = number_format((float)$snack['snack_amount'], 2);
                                                        ?>
                                                                <tr>
                                                                    <td><?= $snack_name; ?></td>
                                                                    <td style="text-align: right;">₹<?= $snack_amount; ?></td>
                                                                    <td style="text-align: right;"> 
                                                                        <input type="number" name="snacks[<?= $snack_id; ?>]" class="form-control snack-quantity" data-snack-price="<?= $snack_amount; ?>" data-snack-name="<?= $snack_name; ?>" placeholder="Qty" min="0" step="1" oninput="this.value = this.value.replace(/[^0-9]/g, '')">

<input type="hidden" name="snack_info[<?= $snack_id; ?>][amount]" value="<?= $snack_amount; ?>">
                                                                        <input type="hidden" name="snack_info[<?= $snack_id; ?>][name]" value="<?= $snack_name; ?>" >
                                                                    </td>
                                                                </tr>
                                                        <?php
                                                            }
                                                        } else {
                                                            echo '<tr><td colspan="3"><em>No snacks available.</em></td></tr>';
                                                        }
                                                        ?>
                                                    </tbody>
                                                </table>
                                            </div>

<div  class="mt-3">
										<label><b>Payment Mode</b></label><br>
										<div class="form-check form-check-inline">
											<input class="form-check-input" type="radio" name="payment_mode" id="cashRadio" value="cash" checked>
											<label class="form-check-label" for="cashRadio">Cash</label>
										</div>
										<div class="form-check form-check-inline">
											<input class="form-check-input" type="radio" name="payment_mode" id="upiRadio" value="upi">
											<label class="form-check-label" for="upiRadio">UPI</label>
										</div>
									</div>
                                 
                                    
									
									<div class="mt-3" id="upiRefSection" style="display:none;">
										<label><b>UPI Reference No</b></label>
										<input type="text" name="upi_reference_no" class="form-control" placeholder="Enter UPI Ref No">
									</div>

<div class="mt-4">
								<label><b>Total Amount</b></label>
								<input type="text" id="totalAmountDisplay" class="form-control" readonly value="₹0">
							</div>

<div class="mt-4">
								<button type="button" class="btn btn-primary" onclick="confirmOrder()">Submit Order</button>
								<a href="dashboard.php" class="btn btn-secondary">Cancel</a>
							</div>
							
						</div>
					 </div>

</div>
                            </form>
                        </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="confirmationModal" tabindex="-1" aria-labelledby="confirmModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg modal-dialog-centered">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Confirm Order Details</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="orderSummary"></div>
            <div class="modal-footer">
                <button type="submit" form="posForm" class="btn btn-success">Confirm & Submit</button>
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
            </div>
        </div>
    </div>
</div>

memberTypeSelect.addEventListener('change', updateFoodPrice);
});

const foodCountInput = document.getElementById('foodCount');
    const memberTypeSelect = document.getElementById('memberType');
    const foodUnitPriceSpan = document.getElementById('foodUnitPrice');
    const totalAmountDisplay = document.getElementById('totalAmountDisplay');
    const upiRadio = document.getElementById('upiRadio');
    const cashRadio = document.getElementById('cashRadio');
    const upiRefSection = document.getElementById('upiRefSection');

const foodPrices = <?= json_encode($food_prices) ?>;

function updateFoodPrice() {
        const memberType = memberTypeSelect.value;
        const rawPrice = foodPrices[memberType];

const price = parseFloat(rawPrice);
        const safePrice = isNaN(price) ? 0 : price;

foodUnitPriceSpan.textContent = safePrice.toFixed(2);
        updateTotalAmount();
    }

function updateTotalAmount() {
        const qty = parseInt(foodCountInput.value) || 0;
        const unitPrice = parseFloat(foodUnitPriceSpan.textContent) || 0;
        let foodTotal = qty * unitPrice;

let snackTotal = 0;
        document.querySelectorAll('.snack-quantity').forEach(input => {
            const snackQty = parseInt(input.value) || 0;
            const snackPrice = parseFloat(input.dataset.snackPrice) || 0;
            snackTotal += snackQty * snackPrice;
        });

const grandTotal = foodTotal + snackTotal;

totalAmountDisplay.value = '₹' + grandTotal.toFixed(2);

const snackTotalInput = document.getElementById('snackTotalAmount');
        if (snackTotalInput) {
            snackTotalInput.value = snackTotal.toFixed(2);
        }

return grandTotal.toFixed(2);
    }

function attachSnackListeners() {
        document.querySelectorAll('.snack-quantity').forEach(input => {
            input.addEventListener('input', updateTotalAmount);
        });
    }

// Show confirmation popup
    function confirmOrder() {
        const paymentMode = document.querySelector('input[name="payment_mode"]:checked').value;
        const upiRefInput = document.querySelector('input[name="upi_reference_no"]');
        const ref = upiRefInput.value.trim();

if (paymentMode === 'upi' && ref === '') {
            alert('Please enter UPI Reference No.');
            upiRefInput.focus();
            return;
        }

const qty = parseInt(foodCountInput.value) || 0;
        const price = parseFloat(foodUnitPriceSpan.textContent) || 0;
        const total = updateTotalAmount();

let summary = `<p><b>Coupons :</b> ${qty} × ₹${price.toFixed(2)}</p>`;

if (snackDetails) {
            summary += `<p><b>Snacks :</b></p><ul>${snackDetails}</ul>`;
        }

summary += `<p><b>Total :</b> ₹${total}</p>`;
        summary += `<p><b>Payment Mode :</b> ${paymentMode.toUpperCase()}</p>`;

if (paymentMode === 'upi') {
            summary += `<p><b>UPI Ref No :</b> ${ref}</p>`;
        }

document.getElementById('orderSummary').innerHTML = summary;
        new bootstrap.Modal(document.getElementById('confirmationModal')).show();
    }

// Initialize
    window.addEventListener('DOMContentLoaded', () => {
        updateFoodPrice();
        attachSnackListeners();
    });

// UPI toggle
    upiRadio.addEventListener('change', () => upiRefSection.style.display = 'block');
    cashRadio.addEventListener('change', () => upiRefSection.style.display = 'none');
</script>

<?php include('footer.php'); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: pointofsale.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation