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: sales-history.php

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

// Check if sales table exists
$table_check = $conn->query("SHOW TABLES LIKE 'sales'");
$sales_table_exists = $table_check->num_rows > 0;

// Handle actions
if (isset($_GET['action']) && isset($_GET['id'])) {
    $sale_id = (int)$_GET['id'];
    $action = $_GET['action'];
    
    if ($sale_id > 0) {
        if ($action === 'view_details') {
            // Redirect to sale details page
            header("Location: sale-details.php?id=" . $sale_id);
            exit();
        } elseif ($action === 'print_receipt') {
            // Redirect to receipt page
            header("Location: receipt.php?sale_id=" . $sale_id . "&print=true");
            exit();
        } elseif ($action === 'cancel_sale') {
            $conn->begin_transaction();
            try {
                // Get sale items to restore stock
                $items_stmt = $conn->prepare("
                    SELECT medicine_id, quantity 
                    FROM sale_items 
                    WHERE sale_id = ?
                ");
                $items_stmt->bind_param("i", $sale_id);
                $items_stmt->execute();
                $items_result = $items_stmt->get_result();
                
                // Restore stock for each item
                while ($item = $items_result->fetch_assoc()) {
                    $restore_stmt = $conn->prepare("
                        UPDATE medicines 
                        SET stock_quantity = stock_quantity + ? 
                        WHERE id = ?
                    ");
                    $restore_stmt->bind_param("ii", $item['quantity'], $item['medicine_id']);
                    $restore_stmt->execute();
                }
                
                // Update sale status to cancelled
                $update_stmt = $conn->prepare("
                    UPDATE sales 
                    SET status = 'cancelled', updated_at = NOW() 
                    WHERE id = ?
                ");
                $update_stmt->bind_param("i", $sale_id);
                $update_stmt->execute();
                
                $conn->commit();
                $success_message = "Sale cancelled successfully! Stock has been restored.";
            } catch (Exception $e) {
                $conn->rollback();
                $error_message = "Error cancelling sale: " . $e->getMessage();
            }
        }
    }
}

// Get filter parameters
$date_from = isset($_GET['date_from']) ? $_GET['date_from'] : date('Y-m-01');
$date_to = isset($_GET['date_to']) ? $_GET['date_to'] : date('Y-m-d');
$payment_method = isset($_GET['payment_method']) ? $_GET['payment_method'] : '';
$status_filter = isset($_GET['status']) ? $_GET['status'] : '';
$customer_phone = isset($_GET['customer_phone']) ? $_GET['customer_phone'] : '';
$doctor_name = isset($_GET['doctor_name']) ? $_GET['doctor_name'] : '';

// Build WHERE clause for filtering
$where_conditions = ["1=1"];
$query_params = [];
$param_types = '';

if (!empty($date_from) && !empty($date_to)) {
    $where_conditions[] = "DATE(s.sale_date) BETWEEN ? AND ?";
    $query_params[] = $date_from;
    $query_params[] = $date_to;
    $param_types .= 'ss';
}

if (!empty($payment_method)) {
    $where_conditions[] = "s.payment_method = ?";
    $query_params[] = $payment_method;
    $param_types .= 's';
}

if (!empty($status_filter)) {
    $where_conditions[] = "s.status = ?";
    $query_params[] = $status_filter;
    $param_types .= 's';
}

if (!empty($customer_phone)) {
    $where_conditions[] = "s.customer_phone LIKE ?";
    $query_params[] = "%$customer_phone%";
    $param_types .= 's';
}

$where_clause = implode(" AND ", $where_conditions);

// Fetch sales history
if ($sales_table_exists) {
    $query = "
        SELECT 
            s.*,
            COUNT(si.id) as items_count,
            SUM(si.quantity) as total_quantity,
            (SELECT GROUP_CONCAT(CONCAT(m.medicine_name, ' (', COALESCE(pd.doctor_name, ''), ')') SEPARATOR ', ') 
             FROM sale_items si2 
             JOIN medicines m ON si2.medicine_id = m.id 
             LEFT JOIN prescription_details pd ON si2.sale_id = pd.sale_id AND si2.medicine_id = pd.medicine_id
             WHERE si2.sale_id = s.id 
             ORDER BY m.medicine_name
             LIMIT 3) as top_items,
            (SELECT GROUP_CONCAT(DISTINCT pd2.doctor_name SEPARATOR ', ')
             FROM prescription_details pd2
             WHERE pd2.sale_id = s.id AND pd2.doctor_name IS NOT NULL AND pd2.doctor_name != ''
             LIMIT 2) as doctors_list,
            (SELECT COUNT(DISTINCT pd3.id)
             FROM prescription_details pd3
             WHERE pd3.sale_id = s.id) as prescription_count
        FROM sales s
        LEFT JOIN sale_items si ON s.id = si.sale_id
        WHERE $where_clause
        GROUP BY s.id
        ORDER BY s.sale_date DESC
        LIMIT 500
    ";
    
    if (!empty($query_params)) {
        $stmt = $conn->prepare($query);
        $stmt->bind_param($param_types, ...$query_params);
        $stmt->execute();
        $sales_result = $stmt->get_result();
    } else {
        $sales_result = $conn->query($query);
    }
    
    $total_sales = $sales_result->num_rows;
} else {
    $total_sales = 0;
    $sales_result = null;
}

// Get all doctors for filter
$doctors = [];
try {
    $doctors_query = "SELECT DISTINCT doctor_name FROM prescription_details WHERE doctor_name IS NOT NULL AND doctor_name != '' ORDER BY doctor_name";
    $doctors_result = $conn->query($doctors_query);
    if ($doctors_result) {
        while ($doctor = $doctors_result->fetch_assoc()) {
            $doctors[] = $doctor['doctor_name'];
        }
    }
} catch (Exception $e) {
    // Ignore error if prescription_details table doesn't exist yet
}

// Calculate statistics
$total_revenue = 0;
$completed_sales = 0;
$cancelled_sales = 0;
$prescription_sales = 0;
$payment_methods_stats = [];

if ($sales_table_exists) {
    $stats_query = "
        SELECT 
            COUNT(*) as total_sales,
            SUM(CASE WHEN status = 'completed' THEN total_amount ELSE 0 END) as total_revenue,
            SUM(CASE WHEN status = 'completed' THEN 1 ELSE 0 END) as completed_sales,
            SUM(CASE WHEN status = 'cancelled' THEN 1 ELSE 0 END) as cancelled_sales,
            payment_method,
            COUNT(*) as method_count,
            SUM(total_amount) as method_revenue
        FROM sales 
        WHERE DATE(sale_date) BETWEEN ? AND ?
        GROUP BY payment_method
    ";
    
    $stats_stmt = $conn->prepare($stats_query);
    $stats_stmt->bind_param("ss", $date_from, $date_to);
    $stats_stmt->execute();
    $stats_result = $stats_stmt->get_result();
    
    while ($stat = $stats_result->fetch_assoc()) {
        $total_revenue += $stat['total_revenue'];
        $completed_sales += $stat['completed_sales'];
        $cancelled_sales += $stat['cancelled_sales'];
        $payment_methods_stats[$stat['payment_method']] = [
            'count' => $stat['method_count'],
            'revenue' => $stat['method_revenue']
        ];
    }
    
    // Count prescription sales
    $prescription_query = "
        SELECT COUNT(DISTINCT s.id) as prescription_sales_count
        FROM sales s
        JOIN prescription_details pd ON s.id = pd.sale_id
        WHERE DATE(s.sale_date) BETWEEN ? AND ?
    ";
    $prescription_stmt = $conn->prepare($prescription_query);
    $prescription_stmt->bind_param("ss", $date_from, $date_to);
    $prescription_stmt->execute();
    $prescription_result = $prescription_stmt->get_result();
    if ($prescription_result->num_rows > 0) {
        $prescription_data = $prescription_result->fetch_assoc();
        $prescription_sales = $prescription_data['prescription_sales_count'];
    }
}
?>

<!doctype html>
<html lang="en">

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

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

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

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

<div class="row">
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $total_sales; ?></h4>
                                        <p class="text-muted mb-0">Total Sales</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-2 col-md-4">
                        <div class="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($total_revenue, 2); ?></h4>
                                        <p class="text-muted mb-0">Total Revenue</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-currency-inr font-size-24 text-success"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $prescription_sales; ?></h4>
                                        <p class="text-muted mb-0">Prescription Sales</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-file-document font-size-24 text-warning"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $completed_sales; ?></h4>
                                        <p class="text-muted mb-0">Completed</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-check-circle font-size-24 text-success"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $cancelled_sales; ?></h4>
                                        <p class="text-muted mb-0">Cancelled</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-cancel font-size-24 text-danger"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $total_sales > 0 ? '₹' . number_format($total_revenue / $completed_sales, 2) : '0'; ?></h4>
                                        <p class="text-muted mb-0">Avg. Sale Value</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>

<?php if (!empty($payment_methods_stats)): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Payment Methods Breakdown</h5>
                                <div class="row">
                                    <?php foreach ($payment_methods_stats as $method => $stats): ?>
                                        <div class="col-md-2 col-6 mb-3">
                                            <div class="card border-<?php echo getPaymentMethodColor($method); ?>">
                                                <div class="card-body text-center p-2">
                                                    <h6 class="mb-1 text-<?php echo getPaymentMethodColor($method); ?>">
                                                        <?php echo strtoupper($method); ?>
                                                    </h6>
                                                    <h4 class="mb-0"><?php echo $stats['count']; ?></h4>
                                                    <small class="text-muted">₹<?php echo number_format($stats['revenue'], 2); ?></small>
                                                </div>
                                            </div>
                                        </div>
                                    <?php endforeach; ?>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

<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">Sales History</h4>
                                    <div>
                                        <a href="pos.php" class="btn btn-primary me-2">
                                            <i class="mdi mdi-point-of-sale me-1"></i> New Sale
                                        </a>
                                        <button type="button" class="btn btn-outline-success" onclick="exportSalesData()">
                                            <i class="mdi mdi-file-export me-1"></i> Export
                                        </button>
                                    </div>
                                </div>

<form method="GET" action="" class="row g-3 mb-4">
                                    <div class="col-md-2">
                                        <label class="form-label">From Date</label>
                                        <input type="date" class="form-control" name="date_from" value="<?php echo $date_from; ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label">To Date</label>
                                        <input type="date" class="form-control" name="date_to" value="<?php echo $date_to; ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label">Payment Method</label>
                                        <select class="form-select" name="payment_method">
                                            <option value="">All Methods</option>
                                            <option value="cash" <?php echo $payment_method === 'cash' ? 'selected' : ''; ?>>Cash</option>
                                            <option value="card" <?php echo $payment_method === 'card' ? 'selected' : ''; ?>>Card</option>
                                            <option value="upi" <?php echo $payment_method === 'upi' ? 'selected' : ''; ?>>UPI</option>
                                            <option value="online" <?php echo $payment_method === 'online' ? 'selected' : ''; ?>>Online</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label">Status</label>
                                        <select class="form-select" name="status">
                                            <option value="">All Status</option>
                                            <option value="completed" <?php echo $status_filter === 'completed' ? 'selected' : ''; ?>>Completed</option>
                                            <option value="cancelled" <?php echo $status_filter === 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                            <option value="refunded" <?php echo $status_filter === 'refunded' ? 'selected' : ''; ?>>Refunded</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label">Customer Phone</label>
                                        <input type="text" class="form-control" name="customer_phone" placeholder="Search phone..." value="<?php echo htmlspecialchars($customer_phone); ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label">Doctor Name</label>
                                        <select class="form-select" name="doctor_name">
                                            <option value="">All Doctors</option>
                                            <?php foreach ($doctors as $doctor): ?>
                                                <option value="<?php echo htmlspecialchars($doctor); ?>" 
                                                    <?php echo $doctor_name === $doctor ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($doctor); ?>
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-12 d-flex align-items-end">
                                        <button type="submit" class="btn btn-outline-primary me-2">
                                            <i class="mdi mdi-filter me-1"></i> Apply Filters
                                        </button>
                                        <a href="sales-history.php" class="btn btn-outline-secondary me-2">
                                            <i class="mdi mdi-refresh me-1"></i> Reset
                                        </a>
                                        <div class="form-check form-check-inline">
                                            <input class="form-check-input" type="checkbox" id="showPrescriptionOnly" name="show_prescription_only" value="1" 
                                                <?php echo isset($_GET['show_prescription_only']) ? 'checked' : ''; ?>>
                                            <label class="form-check-label" for="showPrescriptionOnly">
                                                Prescription Sales Only
                                            </label>
                                        </div>
                                    </div>
                                </form>

<?php if (!$sales_table_exists): ?>
                                    <div class="alert alert-warning text-center">
                                        <h5>Sales Table Not Found</h5>
                                        <p>The sales tracking system hasn't been set up yet. Make your first sale to create the necessary tables.</p>
                                        <a href="pos.php" class="btn btn-primary mt-2">Make First Sale</a>
                                    </div>
                                <?php elseif ($total_sales == 0): ?>
                                    <div class="alert alert-info text-center">
                                        <h5>No Sales Found</h5>
                                        <p>No sales records found for the selected criteria.</p>
                                        <div class="mt-3">
                                            <a href="pos.php" class="btn btn-primary me-2">Make a Sale</a>
                                            <a href="sales-history.php" class="btn btn-outline-primary">Clear Filters</a>
                                        </div>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-centered table-nowrap mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Sale ID</th>
                                                    <th>Date & Time</th>
                                                    <th>Customer</th>
                                                    <th>Items & Prescription</th>
                                                    <th>Total Amount</th>
                                                    <th>Payment Method</th>
                                                    <th>Status</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($sale = $sales_result->fetch_assoc()): 
                                                    // Parse prescription information
                                                    $hasPrescription = $sale['prescription_count'] > 0;
                                                    $doctorNames = $sale['doctors_list'] ? explode(', ', $sale['doctors_list']) : [];
                                                    $uniqueDoctors = array_unique(array_filter($doctorNames));
                                                ?>
                                                    <tr class="<?php echo $sale['status'] === 'cancelled' ? 'table-danger' : ($sale['status'] === 'refunded' ? 'table-warning' : ''); ?>">
                                                        <td>
                                                            <strong>#<?php echo str_pad($sale['id'], 6, '0', STR_PAD_LEFT); ?></strong>
                                                            <?php if ($hasPrescription): ?>
                                                                <br>
                                                                <span class="badge bg-warning badge-sm mt-1">
                                                                    <i class="mdi mdi-file-document me-1"></i> Rx
                                                                </span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <?php echo date('d M Y', strtotime($sale['sale_date'])); ?>
                                                            <br>
                                                            <small class="text-muted"><?php echo date('h:i A', strtotime($sale['sale_date'])); ?></small>
                                                        </td>
                                                        <td>
                                                            <?php if ($sale['customer_name']): ?>
                                                                <strong><?php echo htmlspecialchars($sale['customer_name']); ?></strong>
                                                                <?php if ($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>
                                                            <span class="fw-bold"><?php echo $sale['items_count']; ?> items</span>
                                                            <?php if ($sale['top_items']): ?>
                                                                <br>
                                                                <small class="text-muted">
                                                                    <?php 
                                                                    $items = explode(', ', $sale['top_items']);
                                                                    foreach ($items as $index => $item) {
                                                                        if ($index < 2) { // Show first 2 items max
                                                                            // Parse item name and doctor name
                                                                            preg_match('/^(.*?)\s*$(.*?)$$/', $item, $matches);
                                                                            $itemName = isset($matches[1]) ? $matches[1] : $item;
                                                                            $doctorName = isset($matches[2]) ? $matches[2] : '';
                                                                            
                                                                            echo htmlspecialchars($itemName);
                                                                            if (!empty($doctorName)) {
                                                                                echo ' <span class="text-warning">[' . htmlspecialchars($doctorName) . ']</span>';
                                                                            }
                                                                            if ($index < count($items) - 1 && $index < 1) {
                                                                                echo ', ';
                                                                            }
                                                                        } elseif ($index == 2) {
                                                                            echo '...';
                                                                            break;
                                                                        }
                                                                    }
                                                                    ?>
                                                                </small>
                                                            <?php endif; ?>
                                                            
                                                            <?php if (!empty($uniqueDoctors)): ?>
                                                                <br>
                                                                <small class="text-warning">
                                                                    <i class="mdi mdi-doctor me-1"></i>
                                                                    <?php echo implode(', ', array_map('htmlspecialchars', $uniqueDoctors)); ?>
                                                                </small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <strong class="text-success">₹<?php echo number_format($sale['total_amount'], 2); ?></strong>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo getPaymentMethodColor($sale['payment_method']); ?>">
                                                                <?php echo strtoupper($sale['payment_method']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo getStatusColor($sale['status']); ?>">
                                                                <?php echo strtoupper($sale['status']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <div class="d-flex gap-1">
                                                                <a href="sale-details.php?id=<?php echo $sale['id']; ?>" 
                                                                   class="btn btn-sm btn-outline-primary" 
                                                                   title="View Details">
                                                                    <i class="mdi mdi-eye"></i>
                                                                </a>
                                                                <a href="receipt.php?sale_id=<?php echo $sale['id']; ?>&print=true" 
                                                                   class="btn btn-sm btn-outline-info" 
                                                                   title="Print Receipt" target="_blank">
                                                                    <i class="mdi mdi-printer"></i>
                                                                </a>
                                                                <?php if ($sale['status'] === 'completed'): ?>
                                                                <a href="?action=cancel_sale&id=<?php echo $sale['id']; ?>" 
                                                                   class="btn btn-sm btn-outline-danger" 
                                                                   title="Cancel Sale"
                                                                   onclick="return confirm('Cancel this sale? Stock will be restored. This action cannot be undone.')">
                                                                    <i class="mdi mdi-cancel"></i>
                                                                </a>
                                                                <?php endif; ?>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                    
                                    
                                    <div class="row mt-3">
                                        <div class="col-sm-6">
                                            <div class="text-muted">
                                                Showing <strong><?php echo $total_sales; ?></strong> sale(s)
                                                from <?php echo date('d M Y', strtotime($date_from)); ?> to <?php echo date('d M Y', strtotime($date_to)); ?>
                                                <?php if ($prescription_sales > 0): ?>
                                                    | <span class="text-warning">
                                                        <i class="mdi mdi-file-document me-1"></i>
                                                        <?php echo $prescription_sales; ?> prescription sale(s)
                                                    </span>
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                        <div class="col-sm-6 text-end">
                                            <button type="button" class="btn btn-outline-success" onclick="printSalesReport()">
                                                <i class="mdi mdi-printer me-1"></i> Print Report
                                            </button>
                                            <?php if ($prescription_sales > 0): ?>
                                            <a href="prescription-report.php?date_from=<?php echo urlencode($date_from); ?>&date_to=<?php echo urlencode($date_to); ?>" 
                                               class="btn btn-outline-warning ms-2">
                                                <i class="mdi mdi-file-document me-1"></i> Prescription Report
                                            </a>
                                            <?php endif; ?>
                                        </div>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

// Print sales report
    function printSalesReport() {
        const originalContents = document.body.innerHTML;
        const printContents = document.querySelector('.card').outerHTML;
        
        document.body.innerHTML = `
            <!DOCTYPE html>
            <html>
            <head>
                <title>Sales Report - <?php echo date('d M Y', strtotime($date_from)); ?> to <?php echo date('d M Y', strtotime($date_to)); ?></title>
                <style>
                    body { font-family: Arial, sans-serif; margin: 20px; }
                    .table { width: 100%; border-collapse: collapse; }
                    .table th, .table td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                    .table th { background-color: #f8f9fa; }
                    .text-success { color: #198754; }
                    .text-muted { color: #6c757d; }
                    .text-warning { color: #ffc107; font-weight: bold; }
                    .badge { padding: 4px 8px; border-radius: 4px; font-size: 12px; }
                    .bg-success { background-color: #198754; color: white; }
                    .bg-danger { background-color: #dc3545; color: white; }
                    .bg-warning { background-color: #ffc107; color: black; }
                    .bg-info { background-color: #0dcaf0; color: black; }
                    .bg-primary { background-color: #0d6efd; color: white; }
                    .table-danger { background-color: #f8d7da; }
                    .table-warning { background-color: #fff3cd; }
                    .badge-sm { font-size: 10px; padding: 2px 6px; }
                </style>
            </head>
            <body>
                <h2>Sales History Report</h2>
                <p><strong>Period:</strong> <?php echo date('d M Y', strtotime($date_from)); ?> to <?php echo date('d M Y', strtotime($date_to)); ?></p>
                <p><strong>Total Sales:</strong> <?php echo $total_sales; ?> | <strong>Total Revenue:</strong> ₹<?php echo number_format($total_revenue, 2); ?> | <strong>Prescription Sales:</strong> <?php echo $prescription_sales; ?></p>
                ${printContents}
                <p class="text-muted" style="margin-top: 20px;">Generated on: <?php echo date('d M Y H:i:s'); ?></p>
                <p class="text-warning"><i>Note: [Doctor Name] indicates prescribed by doctor</i></p>
            </body>
            </html>
        `;
        
        window.print();
        document.body.innerHTML = originalContents;
        window.location.reload();
    }

// Keyboard shortcuts
    document.addEventListener('keydown', function(e) {
        // Ctrl + E to export
        if (e.ctrlKey && e.key === 'e') {
            e.preventDefault();
            exportSalesData();
        }
        
        // Ctrl + P to print
        if (e.ctrlKey && e.key === 'p') {
            e.preventDefault();
            printSalesReport();
        }
    });
</script>

</body>
</html>

<?php
// Helper functions
function getPaymentMethodColor($method) {
    switch ($method) {
        case 'cash': return 'success';
        case 'card': return 'primary';
        case 'upi': return 'info';
        case 'online': return 'warning';
        default: return 'secondary';
    }
}

function getStatusColor($status) {
    switch ($status) {
        case 'completed': return 'success';
        case 'cancelled': return 'danger';
        case 'refunded': return 'warning';
        default: return 'secondary';
    }
}

// Close database connection
if (isset($conn)) {
    $conn->close();
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sales-history.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation