Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/medical/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: today-sales.php

<?php
session_start();
include('includes/db_connection.php');

// Set timezone if not already set
date_default_timezone_set('Asia/Kolkata');

// Get today's date
$today = date('Y-m-d');
$today_start = $today . ' 00:00:00';
$today_end = $today . ' 23:59:59';

// Handle refund action
if (isset($_GET['refund_id'])) {
    $refund_id = (int)$_GET['refund_id'];
    
    if ($refund_id > 0) {
        // Get sale details before refund
        $sale_query = "SELECT * FROM sales WHERE id = ?";
        $stmt = $conn->prepare($sale_query);
        $stmt->bind_param("i", $refund_id);
        $stmt->execute();
        $sale = $stmt->get_result()->fetch_assoc();
        
        if ($sale && $sale['status'] != 'refunded') {
            // Start transaction
            $conn->begin_transaction();
            
            try {
                // Create refund record
                $refund_query = "INSERT INTO refunds (sale_id, refund_date, refund_amount, refund_method, refund_reason, return_type, status) 
                                VALUES (?, NOW(), ?, 'cash', 'customer_request', 'full', 'completed')";
                $stmt = $conn->prepare($refund_query);
                $refund_amount = $sale['total_amount'];
                $stmt->bind_param("id", $refund_id, $refund_amount);
                $stmt->execute();
                $refund_id_new = $conn->insert_id;
                
                // Get sale items to return stock
                $items_query = "SELECT * FROM sale_items WHERE sale_id = ?";
                $stmt = $conn->prepare($items_query);
                $stmt->bind_param("i", $refund_id);
                $stmt->execute();
                $items_result = $stmt->get_result();
                
                while ($item = $items_result->fetch_assoc()) {
                    // Add refund item
                    $refund_item_query = "INSERT INTO refund_items (refund_id, medicine_id, quantity, unit_price, subtotal) 
                                         VALUES (?, ?, ?, ?, ?)";
                    $stmt = $conn->prepare($refund_item_query);
                    $stmt->bind_param("iiidd", $refund_id_new, $item['medicine_id'], $item['quantity'], 
                                     $item['unit_price'], $item['subtotal']);
                    $stmt->execute();
                    
                    // Return stock to inventory
                    $update_stock_query = "UPDATE medicines SET stock_quantity = stock_quantity + ? WHERE id = ?";
                    $stmt = $conn->prepare($update_stock_query);
                    $stmt->bind_param("ii", $item['quantity'], $item['medicine_id']);
                    $stmt->execute();
                }
                
                // Update sale status to refunded
                $update_sale_query = "UPDATE sales SET status = 'refunded' WHERE id = ?";
                $stmt = $conn->prepare($update_sale_query);
                $stmt->bind_param("i", $refund_id);
                $stmt->execute();
                
                $conn->commit();
                $_SESSION['success_message'] = "Sale refunded successfully! Stock has been returned to inventory.";
            } catch (Exception $e) {
                $conn->rollback();
                $_SESSION['error_message'] = "Error processing refund: " . $e->getMessage();
            }
        } else {
            $_SESSION['error_message'] = "Sale not found or already refunded!";
        }
        
        header("Location: today-sales.php");
        exit();
    }
}

// Handle cancel action
if (isset($_GET['cancel_id'])) {
    $cancel_id = (int)$_GET['cancel_id'];
    
    if ($cancel_id > 0) {
        // Get sale details before cancel
        $sale_query = "SELECT * FROM sales WHERE id = ? AND status = 'completed'";
        $stmt = $conn->prepare($sale_query);
        $stmt->bind_param("i", $cancel_id);
        $stmt->execute();
        $sale = $stmt->get_result()->fetch_assoc();
        
        if ($sale) {
            // Start transaction
            $conn->begin_transaction();
            
            try {
                // Get sale items to return stock
                $items_query = "SELECT * FROM sale_items WHERE sale_id = ?";
                $stmt = $conn->prepare($items_query);
                $stmt->bind_param("i", $cancel_id);
                $stmt->execute();
                $items_result = $stmt->get_result();
                
                while ($item = $items_result->fetch_assoc()) {
                    // Return stock to inventory
                    $update_stock_query = "UPDATE medicines SET stock_quantity = stock_quantity + ? WHERE id = ?";
                    $stmt = $conn->prepare($update_stock_query);
                    $stmt->bind_param("ii", $item['quantity'], $item['medicine_id']);
                    $stmt->execute();
                }
                
                // Update sale status to cancelled
                $update_sale_query = "UPDATE sales SET status = 'cancelled' WHERE id = ?";
                $stmt = $conn->prepare($update_sale_query);
                $stmt->bind_param("i", $cancel_id);
                $stmt->execute();
                
                $conn->commit();
                $_SESSION['success_message'] = "Sale cancelled successfully! Stock has been returned to inventory.";
            } catch (Exception $e) {
                $conn->rollback();
                $_SESSION['error_message'] = "Error cancelling sale: " . $e->getMessage();
            }
        } else {
            $_SESSION['error_message'] = "Sale not found or already cancelled/refunded!";
        }
        
        header("Location: today-sales.php");
        exit();
    }
}

// Fetch today's sales
$sales_query = "
    SELECT s.*, 
           (SELECT COUNT(*) FROM sale_items WHERE sale_id = s.id) as item_count,
           (SELECT GROUP_CONCAT(CONCAT(m.medicine_name, ' (', si.quantity, ')') SEPARATOR ', ') 
            FROM sale_items si 
            JOIN medicines m ON si.medicine_id = m.id 
            WHERE si.sale_id = s.id 
            LIMIT 2) as item_names
    FROM sales s
    WHERE DATE(s.sale_date) = ?
    ORDER BY s.sale_date DESC
";

$stmt = $conn->prepare($sales_query);
$stmt->bind_param("s", $today);
$stmt->execute();
$today_sales_result = $stmt->get_result();
$total_today_sales = $today_sales_result->num_rows;

// Calculate today's sales statistics
$stats_query = "
    SELECT 
        COUNT(*) as total_sales,
        SUM(CASE WHEN status = 'completed' THEN total_amount ELSE 0 END) as completed_amount,
        SUM(CASE WHEN status = 'cancelled' THEN total_amount ELSE 0 END) as cancelled_amount,
        SUM(CASE WHEN status = 'refunded' THEN total_amount ELSE 0 END) as refunded_amount,
        AVG(total_amount) as average_sale,
        MAX(total_amount) as max_sale,
        MIN(total_amount) as min_sale
    FROM sales
    WHERE DATE(sale_date) = ?
";

$stmt = $conn->prepare($stats_query);
$stmt->bind_param("s", $today);
$stmt->execute();
$stats_result = $stmt->get_result();
$stats = $stats_result->fetch_assoc();

// Calculate payment method breakdown
$payment_stats_query = "
    SELECT 
        payment_method,
        COUNT(*) as count,
        SUM(total_amount) as amount
    FROM sales
    WHERE DATE(sale_date) = ? AND status = 'completed'
    GROUP BY payment_method
    ORDER BY amount DESC
";

$stmt = $conn->prepare($payment_stats_query);
$stmt->bind_param("s", $today);
$stmt->execute();
$payment_stats_result = $stmt->get_result();
?>

<!doctype html>
<html lang="en">
<head>
    <meta charset="utf-8"/>
    <title>Today's Sales - Medical Store</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    
    
    <link rel="shortcut icon" href="assets/images/favicon.ico">
    
    
    <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
    
    <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css"/>
    
    <link href="assets/css/app.min.css" rel="stylesheet" type="text/css"/>
    
    
    <link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css"/>
    <link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css"/>
    
    <style>
        .status-badge {
            padding: 4px 8px;
            border-radius: 4px;
            font-size: 12px;
            font-weight: 500;
        }
        .status-completed { background-color: #d1f7c4; color: #0c622e; }
        .status-cancelled { background-color: #ffeaea; color: #c00; }
        .status-refunded { background-color: #fff0cc; color: #996600; }
        
        .payment-method {
            padding: 3px 8px;
            border-radius: 12px;
            font-size: 11px;
            font-weight: 500;
        }
        .payment-cash { background-color: #d4edda; color: #155724; }
        .payment-card { background-color: #cce5ff; color: #004085; }
        .payment-upi { background-color: #d1ecf1; color: #0c5460; }
        .payment-online { background-color: #e2e3e5; color: #383d41; }

.stat-card:hover {
            transform: translateY(-2px);
            box-shadow: 0 5px 15px rgba(0,0,0,0.1);
        }
        
        .sale-item {
            font-size: 12px;
            color: #6c757d;
            max-width: 200px;
            white-space: nowrap;
            overflow: hidden;
            text-overflow: ellipsis;
        }
    </style>
</head>

<div id="layout-wrapper">

<?php include('includes/topbar.php') ?>
    
    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php') ?>
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">

<?php if (isset($_SESSION['success_message'])): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-check-all me-2"></i>
                        <?php echo $_SESSION['success_message']; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                    <?php unset($_SESSION['success_message']); ?>
                <?php endif; ?>
                
                <?php if (isset($_SESSION['error_message'])): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-block-helper me-2"></i>
                        <?php echo $_SESSION['error_message']; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                    <?php unset($_SESSION['error_message']); ?>
                <?php endif; ?>

<div class="row">
                    <div class="col-xl-3 col-md-6">
                        <div class="card stat-card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">₹<?php echo number_format($stats['completed_amount'] ?? 0, 2); ?></h4>
                                        <p class="text-muted mb-0">Today's Revenue</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-cash-multiple font-size-24 text-success"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card stat-card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $stats['total_sales'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Total Transactions</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-cart-outline font-size-24 text-primary"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card stat-card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">₹<?php echo number_format($stats['average_sale'] ?? 0, 2); ?></h4>
                                        <p class="text-muted mb-0">Average Sale</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-chart-bar font-size-24 text-info"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card stat-card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">₹<?php echo number_format($stats['max_sale'] ?? 0, 2); ?></h4>
                                        <p class="text-muted mb-0">Highest Sale</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-trending-up font-size-24 text-warning"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">Payment Method Breakdown</h5>
                                <div class="row">
                                    <?php if ($payment_stats_result->num_rows > 0): ?>
                                        <?php while ($payment = $payment_stats_result->fetch_assoc()): ?>
                                            <?php 
                                            $payment_class = '';
                                            switch(strtolower($payment['payment_method'])) {
                                                case 'cash': $payment_class = 'payment-cash'; break;
                                                case 'card': $payment_class = 'payment-card'; break;
                                                case 'upi': $payment_class = 'payment-upi'; break;
                                                case 'online': $payment_class = 'payment-online'; break;
                                                default: $payment_class = 'payment-cash';
                                            }
                                            ?>
                                            <div class="col-md-3 col-sm-6 mb-3">
                                                <div class="d-flex align-items-center">
                                                    <span class="<?php echo $payment_class; ?> me-2"><?php echo strtoupper($payment['payment_method']); ?></span>
                                                    <div class="flex-grow-1">
                                                        <h6 class="mb-0">₹<?php echo number_format($payment['amount'], 2); ?></h6>
                                                        <small class="text-muted"><?php echo $payment['count']; ?> transactions</small>
                                                    </div>
                                                </div>
                                            </div>
                                        <?php endwhile; ?>
                                    <?php else: ?>
                                        <div class="col-12">
                                            <p class="text-muted text-center mb-0">No payment data available</p>
                                        </div>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title">Today's Sales Transactions</h4>
                                    <div class="d-flex gap-2">
                                        <span class="text-muted"><?php echo date('d M Y'); ?></span>
                                        <a href="sales-history.php" class="btn btn-sm btn-outline-primary">
                                            <i class="mdi mdi-history me-1"></i> All Sales
                                        </a>
                                        <button onclick="printTodaySales()" class="btn btn-sm btn-outline-success">
                                            <i class="mdi mdi-printer me-1"></i> Print Report
                                        </button>
                                    </div>
                                </div>

<?php if ($total_today_sales == 0): ?>
                                    <div class="alert alert-info text-center">
                                        <h5>No Sales Today</h5>
                                        <p>No sales transactions have been recorded for today.</p>
                                        <a href="new-sale.php" class="btn btn-primary mt-2">
                                            <i class="mdi mdi-plus me-1"></i> Create New Sale
                                        </a>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered mb-0" id="todaySalesTable">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Invoice #</th>
                                                    <th>Time</th>
                                                    <th>Customer</th>
                                                    <th>Items</th>
                                                    <th>Payment</th>
                                                    <th>Amount</th>
                                                    <th>Status</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($sale = $today_sales_result->fetch_assoc()): ?>
                                                    <?php
                                                    // Format time
                                                    $sale_time = date('h:i A', strtotime($sale['sale_date']));
                                                    
                                                    // Status badge
                                                    $status_class = '';
                                                    switch($sale['status']) {
                                                        case 'completed': $status_class = 'status-completed'; break;
                                                        case 'cancelled': $status_class = 'status-cancelled'; break;
                                                        case 'refunded': $status_class = 'status-refunded'; break;
                                                        default: $status_class = 'status-completed';
                                                    }
                                                    
                                                    // Payment method badge
                                                    $payment_class = '';
                                                    switch(strtolower($sale['payment_method'])) {
                                                        case 'cash': $payment_class = 'payment-cash'; break;
                                                        case 'card': $payment_class = 'payment-card'; break;
                                                        case 'upi': $payment_class = 'payment-upi'; break;
                                                        case 'online': $payment_class = 'payment-online'; break;
                                                        default: $payment_class = 'payment-cash';
                                                    }
                                                    ?>
                                                    <tr>
                                                        <td>
                                                            <strong>#<?php echo str_pad($sale['id'], 6, '0', STR_PAD_LEFT); ?></strong>
                                                        </td>
                                                        <td><?php echo $sale_time; ?></td>
                                                        <td>
                                                            <?php if (!empty($sale['customer_name'])): ?>
                                                                <strong><?php echo htmlspecialchars($sale['customer_name']); ?></strong>
                                                                <?php if (!empty($sale['customer_phone'])): ?>
                                                                    <br><small class="text-muted"><?php echo htmlspecialchars($sale['customer_phone']); ?></small>
                                                                <?php endif; ?>
                                                            <?php else: ?>
                                                                <span class="text-muted">Walk-in Customer</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <div class="sale-item" title="<?php echo htmlspecialchars($sale['item_names'] ?: 'No items'); ?>">
                                                                <?php 
                                                                if (!empty($sale['item_names'])) {
                                                                    echo htmlspecialchars($sale['item_names']);
                                                                    if ($sale['item_count'] > 2) {
                                                                        echo ' +' . ($sale['item_count'] - 2) . ' more';
                                                                    }
                                                                } else {
                                                                    echo 'No items';
                                                                }
                                                                ?>
                                                            </div>
                                                            <small class="text-muted"><?php echo $sale['item_count']; ?> item(s)</small>
                                                        </td>
                                                        <td>
                                                            <span class="<?php echo $payment_class; ?>">
                                                                <?php echo strtoupper($sale['payment_method']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <strong>₹<?php echo number_format($sale['total_amount'], 2); ?></strong>
                                                        </td>
                                                        <td>
                                                            <span class="status-badge <?php echo $status_class; ?>">
                                                                <?php echo ucfirst($sale['status']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <div class="d-flex gap-1">
                                                                <a href="view-sale.php?id=<?php echo $sale['id']; ?>" class="btn btn-sm btn-outline-primary" title="View Details">
                                                                    <i class="mdi mdi-eye"></i>
                                                                </a>
                                                                <?php if ($sale['status'] == 'completed'): ?>
                                                                    <a href="?refund_id=<?php echo $sale['id']; ?>" class="btn btn-sm btn-outline-warning" title="Refund" onclick="return confirmRefund(<?php echo $sale['id']; ?>, <?php echo $sale['total_amount']; ?>)">
                                                                        <i class="mdi mdi-arrow-u-left-bottom"></i>
                                                                    </a>
                                                                    <a href="?cancel_id=<?php echo $sale['id']; ?>" class="btn btn-sm btn-outline-danger" title="Cancel" onclick="return confirm('Are you sure you want to cancel sale #<?php echo $sale['id']; ?>? This will return stock to inventory.')">
                                                                        <i class="mdi mdi-close-circle"></i>
                                                                    </a>
                                                                <?php endif; ?>
                                                                <a href="print-invoice.php?id=<?php echo $sale['id']; ?>" class="btn btn-sm btn-outline-success" title="Print Invoice" target="_blank">
                                                                    <i class="mdi mdi-printer"></i>
                                                                </a>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                            <tfoot>
                                                <tr class="table-light">
                                                    <td colspan="5" class="text-end"><strong>Total Today:</strong></td>
                                                    <td><strong>₹<?php echo number_format($stats['completed_amount'] ?? 0, 2); ?></strong></td>
                                                    <td colspan="2"></td>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">Cancelled Sales</h5>
                                <h3 class="text-danger">₹<?php echo number_format($stats['cancelled_amount'] ?? 0, 2); ?></h3>
                                <p class="text-muted mb-0">Total cancelled amount</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">Refunded Sales</h5>
                                <h3 class="text-warning">₹<?php echo number_format($stats['refunded_amount'] ?? 0, 2); ?></h3>
                                <p class="text-muted mb-0">Total refunded amount</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">Lowest Sale</h5>
                                <h3 class="text-info">₹<?php echo number_format($stats['min_sale'] ?? 0, 2); ?></h3>
                                <p class="text-muted mb-0">Minimum transaction today</p>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

<?php include('includes/footer.php') ?>
    </div>

</div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/apexcharts/apexcharts.min.js"></script>

<script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>

<script src="assets/js/app.js"></script>

// Confirm refund action
    function confirmRefund(saleId, amount) {
        return confirm('Are you sure you want to refund sale #' + saleId + '?\n\nRefund Amount: ₹' + amount.toFixed(2) + '\n\nThis action will:\n1. Return stock to inventory\n2. Mark sale as refunded\n3. Create refund record\n\nThis action cannot be undone.');
    }

// Print today's sales report
    function printTodaySales() {
        const today = '<?php echo date('d M Y'); ?>';
        const printContent = `
            <html>
            <head>
                <title>Today's Sales Report - ${today}</title>
                <style>
                    body { font-family: Arial, sans-serif; }
                    .header { text-align: center; margin-bottom: 20px; border-bottom: 2px solid #333; padding-bottom: 10px; }
                    .store-name { font-size: 24px; font-weight: bold; }
                    .report-title { font-size: 18px; margin: 10px 0; }
                    table { width: 100%; border-collapse: collapse; margin-top: 20px; }
                    th { background-color: #f8f9fa; border: 1px solid #dee2e6; padding: 8px; text-align: left; }
                    td { border: 1px solid #dee2e6; padding: 8px; }
                    .total-row { font-weight: bold; background-color: #f8f9fa; }
                    .footer { margin-top: 30px; text-align: center; font-size: 12px; color: #666; }
                </style>
            </head>
            <body>
                <div class="header">
                    <div class="store-name">Medical Store</div>
                    <div class="report-title">Today's Sales Report - ${today}</div>
                    <div>Generated on: ${new Date().toLocaleString()}</div>
                </div>
                
                ${document.querySelector('#todaySalesTable').outerHTML}
                
                <div class="footer">
                    <p>This is a computer-generated report</p>
                    <p>Report ID: TS${Date.now()}</p>
                </div>
            </body>
            </html>
        `;
        
        const printWindow = window.open('', '_blank');
        printWindow.document.write(printContent);
        printWindow.document.close();
        printWindow.onload = function() {
            printWindow.print();
        };
    }

// Auto-refresh page every 30 seconds
    setTimeout(function() {
        window.location.reload();
    }, 30000);

// Quick view sale details
    function viewSaleDetails(saleId) {
        window.location.href = 'view-sale.php?id=' + saleId;
    }

// Filter by payment method
    function filterByPayment(method) {
        const table = $('#todaySalesTable').DataTable();
        table.column(4).search(method).draw();
    }

// Filter by status
    function filterByStatus(status) {
        const table = $('#todaySalesTable').DataTable();
        table.column(6).search(status).draw();
    }

// Reset all filters
    function resetFilters() {
        const table = $('#todaySalesTable').DataTable();
        table.search('').columns().search('').draw();
    }
</script>

</body>
</html>
<?php
// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: today-sales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation