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.28 TB

🔧 Quick Actions

✏️ Editing: prescription-history.php

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

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

// Database connection
include('includes/db_connection.php');

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

// Get filter parameters
$search = isset($_GET['search']) ? $conn->real_escape_string($_GET['search']) : '';
$doctor_filter = isset($_GET['doctor_filter']) ? $_GET['doctor_filter'] : '';
$patient_filter = isset($_GET['patient_filter']) ? $_GET['patient_filter'] : '';
$medicine_filter = isset($_GET['medicine_filter']) ? (int)$_GET['medicine_filter'] : '';
$date_from = isset($_GET['date_from']) ? $_GET['date_from'] : '';
$date_to = isset($_GET['date_to']) ? $_GET['date_to'] : '';
$status_filter = isset($_GET['status_filter']) ? $_GET['status_filter'] : '';

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

if (!empty($search)) {
    $where_conditions[] = "(pd.doctor_name LIKE ? OR pd.patient_name LIKE ? OR pd.doctor_license LIKE ? OR m.medicine_name LIKE ? OR s.customer_name LIKE ? OR s.customer_phone LIKE ?)";
    $search_term = "%$search%";
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $param_types .= 'ssssss';
}

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

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

if (!empty($medicine_filter)) {
    $where_conditions[] = "pd.medicine_id = ?";
    $query_params[] = $medicine_filter;
    $param_types .= 'i';
}

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

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

if (!empty($status_filter)) {
    if ($status_filter === 'active_sales') {
        $where_conditions[] = "s.status = 'completed'";
    } elseif ($status_filter === 'cancelled_sales') {
        $where_conditions[] = "s.status = 'cancelled'";
    } elseif ($status_filter === 'refunded_sales') {
        $where_conditions[] = "s.status = 'refunded'";
    } elseif ($status_filter === 'today') {
        $where_conditions[] = "DATE(pd.prescription_date) = CURDATE()";
    } elseif ($status_filter === 'this_week') {
        $where_conditions[] = "YEARWEEK(pd.prescription_date, 1) = YEARWEEK(CURDATE(), 1)";
    } elseif ($status_filter === 'this_month') {
        $where_conditions[] = "MONTH(pd.prescription_date) = MONTH(CURDATE()) AND YEAR(pd.prescription_date) = YEAR(CURDATE())";
    } elseif ($status_filter === 'last_month') {
        $where_conditions[] = "MONTH(pd.prescription_date) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) AND YEAR(pd.prescription_date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))";
    }
}

$where_clause = '';
if (!empty($where_conditions)) {
    $where_clause = "WHERE " . implode(" AND ", $where_conditions);
}

// Fetch prescription history with all related data
if ($prescriptions_table_exists) {
    $query = "
        SELECT 
            pd.*,
            m.medicine_name,
            m.generic_name,
            m.batch_number,
            m.expiry_date,
            m.selling_price,
            m.mrp,
            m.manufacturer,
            m.requires_prescription,
            m.hsn_code,
            m.gst_rate,
            s.sale_date,
            s.total_amount,
            s.payment_method,
            s.customer_name as sale_customer_name,
            s.customer_phone as sale_customer_phone,
            s.status as sale_status,
            c.customer_name,
            c.customer_phone,
            c.customer_email,
            cat.category_name,
            DATEDIFF(CURDATE(), pd.prescription_date) as days_ago,
            CASE 
                WHEN s.status = 'completed' THEN 'Completed'
                WHEN s.status = 'cancelled' THEN 'Cancelled'
                WHEN s.status = 'refunded' THEN 'Refunded'
                ELSE s.status
            END as sale_status_label,
            CASE 
                WHEN DATEDIFF(CURDATE(), pd.prescription_date) <= 7 THEN 'recent'
                WHEN DATEDIFF(CURDATE(), pd.prescription_date) <= 30 THEN 'moderate'
                ELSE 'old'
            END as prescription_age
        FROM prescription_details pd
        LEFT JOIN medicines m ON pd.medicine_id = m.id
        LEFT JOIN sales s ON pd.sale_id = s.id
        LEFT JOIN customers c ON s.customer_phone = c.customer_phone
        LEFT JOIN medicine_categories cat ON m.category_id = cat.id
        $where_clause
        ORDER BY pd.prescription_date DESC, pd.created_at DESC
    ";
    
    if (!empty($query_params)) {
        $stmt = $conn->prepare($query);
        $stmt->bind_param($param_types, ...$query_params);
        $stmt->execute();
        $prescriptions_result = $stmt->get_result();
    } else {
        $prescriptions_result = $conn->query($query);
    }
    
    $total_prescriptions = $prescriptions_result->num_rows;
} else {
    $total_prescriptions = 0;
    $prescriptions_result = null;
}

// Get unique doctors for filter dropdown
$doctors_result = $conn->query("SELECT DISTINCT doctor_name FROM prescription_details WHERE doctor_name IS NOT NULL AND doctor_name != '' ORDER BY doctor_name");

// Get unique patients for filter dropdown
$patients_result = $conn->query("SELECT DISTINCT patient_name FROM prescription_details WHERE patient_name IS NOT NULL AND patient_name != '' ORDER BY patient_name");

// Get medicines for filter dropdown
$medicines_result = $conn->query("SELECT m.id, m.medicine_name FROM medicines m WHERE m.id IN (SELECT DISTINCT medicine_id FROM prescription_details) ORDER BY m.medicine_name");

// Get statistics
$total_prescriptions_count = 0;
$today_count = 0;
$this_week_count = 0;
$this_month_count = 0;
$total_sales_amount = 0;
$unique_doctors = 0;
$unique_patients = 0;
$unique_medicines = 0;

if ($prescriptions_table_exists) {
    // Total prescriptions count
    $count_query = "SELECT COUNT(*) as total FROM prescription_details";
    $count_result = $conn->query($count_query);
    if ($count_result) {
        $count_data = $count_result->fetch_assoc();
        $total_prescriptions_count = $count_data['total'];
    }
    
    // Today's prescriptions
    $today_query = "SELECT COUNT(*) as today_count FROM prescription_details WHERE DATE(prescription_date) = CURDATE()";
    $today_result = $conn->query($today_query);
    if ($today_result) {
        $today_data = $today_result->fetch_assoc();
        $today_count = $today_data['today_count'];
    }
    
    // This week prescriptions
    $week_query = "SELECT COUNT(*) as week_count FROM prescription_details WHERE YEARWEEK(prescription_date, 1) = YEARWEEK(CURDATE(), 1)";
    $week_result = $conn->query($week_query);
    if ($week_result) {
        $week_data = $week_result->fetch_assoc();
        $this_week_count = $week_data['week_count'];
    }
    
    // This month prescriptions
    $month_query = "SELECT COUNT(*) as month_count FROM prescription_details WHERE MONTH(prescription_date) = MONTH(CURDATE()) AND YEAR(prescription_date) = YEAR(CURDATE())";
    $month_result = $conn->query($month_query);
    if ($month_result) {
        $month_data = $month_result->fetch_assoc();
        $this_month_count = $month_data['month_count'];
    }
    
    // Total sales amount from prescriptions
    $sales_query = "
        SELECT SUM(s.total_amount) as total_sales_amount 
        FROM prescription_details pd
        LEFT JOIN sales s ON pd.sale_id = s.id
        WHERE s.status = 'completed'
    ";
    $sales_result = $conn->query($sales_query);
    if ($sales_result) {
        $sales_data = $sales_result->fetch_assoc();
        $total_sales_amount = $sales_data['total_sales_amount'] ?? 0;
    }
    
    // Unique doctors
    $doctors_query = "SELECT COUNT(DISTINCT doctor_name) as unique_doctors FROM prescription_details WHERE doctor_name IS NOT NULL AND doctor_name != ''";
    $doctors_result_stats = $conn->query($doctors_query);
    if ($doctors_result_stats) {
        $doctors_data = $doctors_result_stats->fetch_assoc();
        $unique_doctors = $doctors_data['unique_doctors'];
    }
    
    // Unique patients
    $patients_query = "SELECT COUNT(DISTINCT patient_name) as unique_patients FROM prescription_details WHERE patient_name IS NOT NULL AND patient_name != ''";
    $patients_result_stats = $conn->query($patients_query);
    if ($patients_result_stats) {
        $patients_data = $patients_result_stats->fetch_assoc();
        $unique_patients = $patients_data['unique_patients'];
    }
    
    // Unique medicines
    $medicines_query = "SELECT COUNT(DISTINCT medicine_id) as unique_medicines FROM prescription_details";
    $medicines_result_stats = $conn->query($medicines_query);
    if ($medicines_result_stats) {
        $medicines_data = $medicines_result_stats->fetch_assoc();
        $unique_medicines = $medicines_data['unique_medicines'];
    }
}
?>

<?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-3 col-md-6">
                        <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_prescriptions_count; ?></h4>
                                        <p class="text-muted mb-0">Total Prescriptions</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-file-document font-size-24 text-primary"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h6 class="text-muted mb-0">
                                        <span class="text-success me-1"><?php echo $today_count; ?> today</span>
                                        <span class="float-end"><?php echo $this_week_count; ?> this week</span>
                                    </h6>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <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_sales_amount, 2); ?></h4>
                                        <p class="text-muted mb-0">Total Sales Value</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-cash font-size-24 text-success"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h6 class="text-muted mb-0">
                                        <span class="text-success me-1"><?php echo $unique_doctors; ?> doctors</span>
                                        <span class="float-end"><?php echo $unique_patients; ?> patients</span>
                                    </h6>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <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 $unique_medicines; ?></h4>
                                        <p class="text-muted mb-0">Medicines Prescribed</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-pill font-size-24 text-info"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h6 class="text-muted mb-0">
                                        <span class="text-info me-1"><?php echo $this_month_count; ?> this month</span>
                                        <span class="float-end">Avg: <?php echo $total_prescriptions_count > 0 ? number_format($total_sales_amount / $total_prescriptions_count, 2) : 0; ?> per Rx</span>
                                    </h6>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <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 $unique_doctors; ?></h4>
                                        <p class="text-muted mb-0">Unique Doctors</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-doctor font-size-24 text-warning"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h6 class="text-muted mb-0">
                                        <span class="text-warning me-1"><?php echo $total_prescriptions_count > 0 ? number_format($total_prescriptions_count / $unique_doctors, 1) : 0; ?> Rx per doctor</span>
                                        <span class="float-end"><?php echo $total_prescriptions_count > 0 ? number_format($unique_patients / $total_prescriptions_count * 100, 1) : 0; ?>% patient rate</span>
                                    </h6>
                                </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">Prescription History</h4>
                                    <div>
                                        <a href="add-sale.php?with_prescription=true" class="btn btn-primary">
                                            <i class="mdi mdi-plus me-1"></i> Add New Prescription
                                        </a>
                                    </div>
                                </div>

<form method="GET" action="" class="row g-3 mb-4">
                                    <div class="col-md-2">
                                        <input type="text" class="form-control" name="search" placeholder="Search..." value="<?php echo htmlspecialchars($search); ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="doctor_filter">
                                            <option value="">All Doctors</option>
                                            <?php while ($doctor = $doctors_result->fetch_assoc()): ?>
                                                <option value="<?php echo htmlspecialchars($doctor['doctor_name']); ?>" <?php echo $doctor_filter === $doctor['doctor_name'] ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($doctor['doctor_name']); ?>
                                                </option>
                                            <?php endwhile; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="patient_filter">
                                            <option value="">All Patients</option>
                                            <?php while ($patient = $patients_result->fetch_assoc()): ?>
                                                <option value="<?php echo htmlspecialchars($patient['patient_name']); ?>" <?php echo $patient_filter === $patient['patient_name'] ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($patient['patient_name']); ?>
                                                </option>
                                            <?php endwhile; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="medicine_filter">
                                            <option value="">All Medicines</option>
                                            <?php while ($medicine = $medicines_result->fetch_assoc()): ?>
                                                <option value="<?php echo $medicine['id']; ?>" <?php echo $medicine_filter == $medicine['id'] ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($medicine['medicine_name']); ?>
                                                </option>
                                            <?php endwhile; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="status_filter">
                                            <option value="">All Time</option>
                                            <option value="today" <?php echo $status_filter === 'today' ? 'selected' : ''; ?>>Today</option>
                                            <option value="this_week" <?php echo $status_filter === 'this_week' ? 'selected' : ''; ?>>This Week</option>
                                            <option value="this_month" <?php echo $status_filter === 'this_month' ? 'selected' : ''; ?>>This Month</option>
                                            <option value="last_month" <?php echo $status_filter === 'last_month' ? 'selected' : ''; ?>>Last Month</option>
                                            <option value="active_sales" <?php echo $status_filter === 'active_sales' ? 'selected' : ''; ?>>Active Sales</option>
                                            <option value="cancelled_sales" <?php echo $status_filter === 'cancelled_sales' ? 'selected' : ''; ?>>Cancelled Sales</option>
                                            <option value="refunded_sales" <?php echo $status_filter === 'refunded_sales' ? 'selected' : ''; ?>>Refunded Sales</option>
                                        </select>
                                    </div>
                                    <div class="col-md-1">
                                        <button type="submit" class="btn btn-outline-primary w-100">
                                            <i class="mdi mdi-filter me-1"></i> Filter
                                        </button>
                                    </div>
                                    <div class="col-md-1">
                                        <a href="prescription-history.php" class="btn btn-outline-secondary w-100">
                                            <i class="mdi mdi-refresh me-1"></i> Reset
                                        </a>
                                    </div>
                                </form>

<form method="GET" action="" class="row g-3 mb-4">
                                    <div class="col-md-3">
                                        <label class="form-label">Date From</label>
                                        <input type="date" class="form-control" name="date_from" value="<?php echo htmlspecialchars($date_from); ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Date To</label>
                                        <input type="date" class="form-control" name="date_to" value="<?php echo htmlspecialchars($date_to); ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label">&nbsp;</label>
                                        <button type="submit" class="btn btn-outline-info w-100">
                                            <i class="mdi mdi-calendar-range me-1"></i> Date Filter
                                        </button>
                                    </div>
                                    <div class="col-md-4">
                                        <label class="form-label">&nbsp;</label>
                                        <div class="d-flex gap-2">
                                            <a href="prescription-history.php?status_filter=today" class="btn btn-outline-success btn-sm">Today</a>
                                            <a href="prescription-history.php?status_filter=this_week" class="btn btn-outline-info btn-sm">This Week</a>
                                            <a href="prescription-history.php?status_filter=this_month" class="btn btn-outline-primary btn-sm">This Month</a>
                                            <a href="prescription-history.php?status_filter=last_month" class="btn btn-outline-warning btn-sm">Last Month</a>
                                        </div>
                                    </div>
                                </form>

<?php if (!$prescriptions_table_exists): ?>
                                    <div class="alert alert-warning text-center">
                                        <h5>No Prescription Data Found</h5>
                                        <p>The prescription_details table hasn't been created yet.</p>
                                        <a href="add-sale.php?with_prescription=true" class="btn btn-primary mt-2">Add First Prescription</a>
                                    </div>
                                <?php elseif ($total_prescriptions == 0): ?>
                                    <div class="alert alert-info text-center">
                                        <h5>No Prescriptions Found</h5>
                                        <p>No prescription history found in the database.</p>
                                        <a href="add-sale.php?with_prescription=true" class="btn btn-primary mt-2">Add First Prescription</a>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-centered table-nowrap mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Prescription ID</th>
                                                    <th>Doctor & Patient</th>
                                                    <th>Medicine Details</th>
                                                    <th>Sale Information</th>
                                                    <th>Date & Time</th>
                                                    <th>Status</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($prescription = $prescriptions_result->fetch_assoc()): ?>
                                                    <?php
                                                    // Format dates
                                                    $prescription_date = !empty($prescription['prescription_date']) ? date('d M Y', strtotime($prescription['prescription_date'])) : 'N/A';
                                                    $sale_date = !empty($prescription['sale_date']) ? date('d M Y h:i A', strtotime($prescription['sale_date'])) : 'N/A';
                                                    $created_at = !empty($prescription['created_at']) ? date('d M Y h:i A', strtotime($prescription['created_at'])) : 'N/A';
                                                    
                                                    // Determine row color based on prescription age
                                                    $row_class = '';
                                                    if ($prescription['prescription_age'] === 'recent') {
                                                        $row_class = 'table-info';
                                                    } elseif ($prescription['prescription_age'] === 'moderate') {
                                                        $row_class = '';
                                                    } else {
                                                        $row_class = 'table-light';
                                                    }
                                                    
                                                    // Add strikethrough for cancelled/refunded sales
                                                    if ($prescription['sale_status'] === 'cancelled' || $prescription['sale_status'] === 'refunded') {
                                                        $row_class .= ' text-decoration-line-through text-muted';
                                                    }
                                                    
                                                    // Status badge color
                                                    $status_colors = [
                                                        'completed' => 'success',
                                                        'cancelled' => 'danger',
                                                        'refunded' => 'warning'
                                                    ];
                                                    $status_color = $status_colors[$prescription['sale_status']] ?? 'secondary';
                                                    
                                                    // Determine which customer name to display
                                                    $display_customer_name = $prescription['customer_name'] ?? $prescription['sale_customer_name'] ?? 'N/A';
                                                    $display_customer_phone = $prescription['customer_phone'] ?? $prescription['sale_customer_phone'] ?? '';
                                                    
                                                    // Check if medicine requires prescription
                                                    $requires_rx = $prescription['requires_prescription'] ? '<span class="badge bg-info ms-1">Rx Required</span>' : '';
                                                    
                                                    // Calculate GST amount
                                                    $gst_amount = ($prescription['selling_price'] * $prescription['gst_rate']) / 100;
                                                    ?>
                                                    <tr class="<?php echo $row_class; ?>">
                                                        <td>
                                                            <strong>#<?php echo $prescription['id']; ?></strong>
                                                            <?php if ($prescription['days_ago'] <= 1): ?>
                                                                <span class="badge bg-success ms-1">NEW</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <div>
                                                                <strong>Doctor:</strong>
                                                                <?php echo htmlspecialchars($prescription['doctor_name'] ?: 'N/A'); ?>
                                                            </div>
                                                            <?php if (!empty($prescription['doctor_license'])): ?>
                                                                <div class="small text-muted">
                                                                    License: <?php echo htmlspecialchars($prescription['doctor_license']); ?>
                                                                </div>
                                                            <?php endif; ?>
                                                            <?php if (!empty($prescription['patient_name'])): ?>
                                                                <div class="mt-1">
                                                                    <strong>Patient:</strong>
                                                                    <?php echo htmlspecialchars($prescription['patient_name']); ?>
                                                                </div>
                                                            <?php endif; ?>
                                                            <?php if (!empty($display_customer_name) && $display_customer_name !== 'N/A'): ?>
                                                                <div class="mt-1">
                                                                    <strong>Customer:</strong>
                                                                    <?php echo htmlspecialchars($display_customer_name); ?>
                                                                    <?php if (!empty($display_customer_phone)): ?>
                                                                        <br>
                                                                        <small class="text-muted"><?php echo htmlspecialchars($display_customer_phone); ?></small>
                                                                    <?php endif; ?>
                                                                </div>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <div>
                                                                <strong><?php echo htmlspecialchars($prescription['medicine_name'] ?: 'N/A'); ?></strong>
                                                                <?php echo $requires_rx; ?>
                                                            </div>
                                                            <?php if (!empty($prescription['generic_name'])): ?>
                                                                <div class="small text-muted">
                                                                    Generic: <?php echo htmlspecialchars($prescription['generic_name']); ?>
                                                                </div>
                                                            <?php endif; ?>
                                                            <?php if (!empty($prescription['category_name'])): ?>
                                                                <div class="small text-muted">
                                                                    Category: <?php echo htmlspecialchars($prescription['category_name']); ?>
                                                                </div>
                                                            <?php endif; ?>
                                                            <?php if (!empty($prescription['batch_number'])): ?>
                                                                <div class="small text-muted">
                                                                    Batch: <?php echo htmlspecialchars($prescription['batch_number']); ?>
                                                                </div>
                                                            <?php endif; ?>
                                                            <?php if (!empty($prescription['expiry_date'])): ?>
                                                                <?php
                                                                $expiry_status = '';
                                                                $expiry_date = strtotime($prescription['expiry_date']);
                                                                $today = time();
                                                                $thirty_days_later = strtotime('+30 days');
                                                                
                                                                if ($expiry_date < $today) {
                                                                    $expiry_status = '<span class="badge bg-danger">Expired</span>';
                                                                } elseif ($expiry_date <= $thirty_days_later) {
                                                                    $expiry_status = '<span class="badge bg-warning">Expiring Soon</span>';
                                                                }
                                                                ?>
                                                                <div class="small text-muted">
                                                                    Expiry: <?php echo date('M Y', $expiry_date); ?>
                                                                    <?php echo $expiry_status; ?>
                                                                </div>
                                                            <?php endif; ?>
                                                            <div class="text-success mt-1">
                                                                <strong>₹<?php echo number_format($prescription['selling_price'], 2); ?></strong>
                                                                <?php if ($prescription['gst_rate'] > 0): ?>
                                                                    <small class="text-muted"> (incl. ₹<?php echo number_format($gst_amount, 2); ?> GST)</small>
                                                                <?php endif; ?>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div>
                                                                <strong>Sale #<?php echo $prescription['sale_id']; ?></strong>
                                                            </div>
                                                            <div class="text-muted small">
                                                                <?php echo $sale_date; ?>
                                                            </div>
                                                            <?php if (!empty($prescription['total_amount'])): ?>
                                                                <div class="text-success">
                                                                    <strong>₹<?php echo number_format($prescription['total_amount'], 2); ?></strong>
                                                                </div>
                                                            <?php endif; ?>
                                                            <div class="small">
                                                                Payment: <?php echo strtoupper($prescription['payment_method']); ?>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div>
                                                                <strong>Prescription:</strong>
                                                                <?php echo $prescription_date; ?>
                                                            </div>
                                                            <div class="small text-muted">
                                                                <strong>Created:</strong>
                                                                <?php echo $created_at; ?>
                                                            </div>
                                                            <?php if ($prescription['days_ago'] > 0): ?>
                                                                <div class="small text-muted">
                                                                    <?php echo $prescription['days_ago']; ?> days ago
                                                                </div>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $status_color; ?>">
                                                                <?php echo $prescription['sale_status_label']; ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <div class="d-flex gap-1">
                                                                <a href="view-sale.php?id=<?php echo $prescription['sale_id']; ?>" class="btn btn-sm btn-outline-info" title="View Sale">
                                                                    <i class="mdi mdi-eye"></i>
                                                                </a>
                                                                <a href="print-prescription.php?id=<?php echo $prescription['id']; ?>" class="btn btn-sm btn-outline-success" title="Print" target="_blank">
                                                                    <i class="mdi mdi-printer"></i>
                                                                </a>
                                                                <a href="prescriptions-list.php?doctor_filter=<?php echo urlencode($prescription['doctor_name']); ?>" class="btn btn-sm btn-outline-primary" title="Doctor History">
                                                                    <i class="mdi mdi-doctor"></i>
                                                                </a>
                                                                <?php if ($prescription['sale_status'] === 'completed'): ?>
                                                                    <a href="edit-sale.php?id=<?php echo $prescription['sale_id']; ?>&edit_prescription=<?php echo $prescription['id']; ?>" class="btn btn-sm btn-outline-warning" title="Edit Prescription">
                                                                        <i class="mdi mdi-pencil"></i>
                                                                    </a>
                                                                <?php endif; ?>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                    
                                    
                                    <div class="row mt-4">
                                        <div class="col-md-6">
                                            <div class="text-muted">
                                                Showing <strong><?php echo $total_prescriptions; ?></strong> prescription(s)
                                                <?php if (!empty($search) || !empty($doctor_filter) || !empty($patient_filter) || !empty($medicine_filter) || !empty($date_from) || !empty($date_to) || !empty($status_filter)): ?>
                                                    (filtered results)
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                        <div class="col-md-6 text-end">
                                            <div class="btn-group">
                                                <button onclick="exportPrescriptionHistory()" class="btn btn-outline-success btn-sm">
                                                    <i class="mdi mdi-file-export me-1"></i> Export to Excel
                                                </button>
                                                <button onclick="printPrescriptionHistory()" class="btn btn-outline-primary btn-sm">
                                                    <i class="mdi mdi-printer me-1"></i> Print Report
                                                </button>
                                                <a href="prescription-analytics.php" class="btn btn-outline-info btn-sm">
                                                    <i class="mdi mdi-chart-bar me-1"></i> Analytics
                                                </a>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    
                                    <?php
                                    // Calculate summary statistics
                                    if ($prescriptions_result && $total_prescriptions > 0) {
                                        $prescriptions_result->data_seek(0); // Reset pointer
                                        $total_amount_sum = 0;
                                        $total_gst_sum = 0;
                                        $recent_count = 0;
                                        $active_count = 0;
                                        $cancelled_count = 0;
                                        $refunded_count = 0;
                                        
                                        while ($presc = $prescriptions_result->fetch_assoc()) {
                                            $total_amount_sum += $presc['total_amount'] ?? 0;
                                            $gst_amount = ($presc['selling_price'] * $presc['gst_rate']) / 100;
                                            $total_gst_sum += $gst_amount;
                                            
                                            if ($presc['days_ago'] <= 7) {
                                                $recent_count++;
                                            }
                                            
                                            if ($presc['sale_status'] === 'completed') {
                                                $active_count++;
                                            } elseif ($presc['sale_status'] === 'cancelled') {
                                                $cancelled_count++;
                                            } elseif ($presc['sale_status'] === 'refunded') {
                                                $refunded_count++;
                                            }
                                        }
                                        $prescriptions_result->data_seek(0); // Reset pointer again
                                    }
                                    ?>
                                    
                                    <div class="row mt-3">
                                        <div class="col-md-3">
                                            <div class="border rounded p-2 text-center">
                                                <small class="text-muted">Total Value</small>
                                                <h5 class="mb-0">₹<?php echo number_format($total_amount_sum ?? 0, 2); ?></h5>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="border rounded p-2 text-center">
                                                <small class="text-muted">Recent (7 days)</small>
                                                <h5 class="mb-0"><?php echo $recent_count ?? 0; ?></h5>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="border rounded p-2 text-center">
                                                <small class="text-muted">Active</small>
                                                <h5 class="mb-0 text-success"><?php echo $active_count ?? 0; ?></h5>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="border rounded p-2 text-center">
                                                <small class="text-muted">Cancelled</small>
                                                <h5 class="mb-0 text-danger"><?php echo $cancelled_count ?? 0; ?></h5>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="border rounded p-2 text-center">
                                                <small class="text-muted">Avg per Prescription</small>
                                                <h5 class="mb-0">₹<?php echo $total_prescriptions > 0 ? number_format(($total_amount_sum ?? 0) / $total_prescriptions, 2) : 0; ?></h5>
                                            </div>
                                        </div>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-4">Quick Insights</h5>
                                <div class="row">
                                    <div class="col-md-3">
                                        <a href="top-doctors.php" class="btn btn-outline-primary w-100 mb-2">
                                            <i class="mdi mdi-trophy me-1"></i> Top Doctors
                                        </a>
                                    </div>
                                    <div class="col-md-3">
                                        <a href="frequent-medicines.php" class="btn btn-outline-info w-100 mb-2">
                                            <i class="mdi mdi-pill me-1"></i> Frequent Medicines
                                        </a>
                                    </div>
                                    <div class="col-md-3">
                                        <a href="prescription-trends.php" class="btn btn-outline-success w-100 mb-2">
                                            <i class="mdi mdi-chart-line me-1"></i> Prescription Trends
                                        </a>
                                    </div>
                                    <div class="col-md-3">
                                        <a href="expiring-prescriptions.php" class="btn btn-outline-warning w-100 mb-2">
                                            <i class="mdi mdi-alert me-1"></i> Expiring Soon
                                        </a>
                                    </div>
                                </div>
                                <div class="row mt-3">
                                    <div class="col-md-4">
                                        <div class="alert alert-info mb-0">
                                            <h6 class="alert-heading"><i class="mdi mdi-information me-2"></i> Prescription Tips</h6>
                                            <small>
                                                • Always verify doctor license for controlled substances<br>
                                                • Check medicine expiry dates before dispensing<br>
                                                • Maintain prescription records for 3 years minimum
                                            </small>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="alert alert-warning mb-0">
                                            <h6 class="alert-heading"><i class="mdi mdi-alert-circle me-2"></i> Important Notes</h6>
                                            <small>
                                                • Prescriptions with Rx Required badge need verification<br>
                                                • Expired medicines should not be dispensed<br>
                                                • Keep digital copies of all prescriptions
                                            </small>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="alert alert-success mb-0">
                                            <h6 class="alert-heading"><i class="mdi mdi-chart-bar me-2"></i> Statistics</h6>
                                            <small>
                                                • <?php echo $unique_doctors; ?> doctors in system<br>
                                                • <?php echo $unique_patients; ?> unique patients<br>
                                                • <?php echo number_format($total_sales_amount / max($total_prescriptions_count, 1), 2); ?> avg per Rx
                                            </small>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

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

// Print prescription history
    function printPrescriptionHistory() {
        const originalContents = document.body.innerHTML;
        const printContents = document.querySelector('.card').outerHTML;
        
        const printWindow = window.open('', '_blank');
        printWindow.document.write(`
            <!DOCTYPE html>
            <html>
            <head>
                <title>Prescription History Report</title>
                <style>
                    body { font-family: Arial, sans-serif; margin: 20px; }
                    .table { width: 100%; border-collapse: collapse; margin: 20px 0; font-size: 12px; }
                    .table th, .table td { border: 1px solid #ddd; padding: 6px; text-align: left; }
                    .table th { background-color: #f8f9fa; font-weight: bold; }
                    .text-end { text-align: right; }
                    .text-center { text-align: center; }
                    .badge { padding: 2px 6px; border-radius: 3px; font-size: 10px; }
                    .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: white; }
                    .text-muted { color: #6c757d; }
                    .text-success { color: #198754; }
                    h2 { color: #495057; }
                    @page { size: landscape; }
                </style>
            </head>
            <body>
                <h2>Prescription History Report</h2>
                <p>Generated on: ${new Date().toLocaleDateString()} ${new Date().toLocaleTimeString()}</p>
                <p>Total Prescriptions: <?php echo $total_prescriptions; ?></p>
                ${printContents}
            </body>
            </html>
        `);
        
        printWindow.document.close();
        printWindow.focus();
        setTimeout(() => {
            printWindow.print();
            printWindow.close();
        }, 500);
    }

// Search with Enter key
    document.addEventListener('DOMContentLoaded', function() {
        const searchInput = document.querySelector('input[name="search"]');
        if (searchInput) {
            searchInput.addEventListener('keypress', function(e) {
                if (e.key === 'Enter') {
                    this.form.submit();
                }
            });
        }
        
        // Highlight expired medicines
        const rows = document.querySelectorAll('tbody tr');
        rows.forEach(row => {
            const expiryBadge = row.querySelector('.badge.bg-danger');
            if (expiryBadge && expiryBadge.textContent.includes('Expired')) {
                row.style.backgroundColor = 'rgba(220, 53, 69, 0.1)';
            }
            
            // Highlight new prescriptions (today or yesterday)
            const newBadge = row.querySelector('.badge.bg-success');
            if (newBadge && newBadge.textContent.includes('NEW')) {
                row.style.backgroundColor = 'rgba(13, 110, 253, 0.05)';
            }
        });
        
        // Auto-submit date filters when both are filled
        const dateFrom = document.querySelector('input[name="date_from"]');
        const dateTo = document.querySelector('input[name="date_to"]');
        
        if (dateFrom && dateTo) {
            dateFrom.addEventListener('change', checkDateFilters);
            dateTo.addEventListener('change', checkDateFilters);
        }
        
        function checkDateFilters() {
            if (dateFrom.value && dateTo.value) {
                dateFrom.form.submit();
            }
        }
        
        // Add row click functionality
        const tableRows = document.querySelectorAll('tbody tr');
        tableRows.forEach(row => {
            row.addEventListener('click', function(e) {
                if (!e.target.closest('a') && !e.target.closest('button')) {
                    const prescriptionId = this.querySelector('td:first-child strong').textContent.replace('#', '');
                    window.location.href = 'view-prescription.php?id=' + prescriptionId;
                }
            });
            
            // Add hover effect
            row.addEventListener('mouseenter', function() {
                this.style.backgroundColor = 'rgba(0, 0, 0, 0.02)';
                this.style.cursor = 'pointer';
            });
            
            row.addEventListener('mouseleave', function() {
                this.style.backgroundColor = '';
            });
        });
    });

// Quick filter functions
    function filterByDoctor(doctorName) {
        window.location.href = 'prescription-history.php?doctor_filter=' + encodeURIComponent(doctorName);
    }

function filterByPatient(patientName) {
        window.location.href = 'prescription-history.php?patient_filter=' + encodeURIComponent(patientName);
    }

function filterByMedicine(medicineId) {
        window.location.href = 'prescription-history.php?medicine_filter=' + medicineId;
    }

function filterByDateRange(days) {
        const today = new Date();
        const fromDate = new Date();
        fromDate.setDate(today.getDate() - days);
        
        const fromStr = fromDate.toISOString().split('T')[0];
        const toStr = today.toISOString().split('T')[0];
        
        window.location.href = 'prescription-history.php?date_from=' + fromStr + '&date_to=' + toStr;
    }

// Keyboard shortcuts
    document.addEventListener('keydown', function(e) {
        // Ctrl + F to focus search
        if (e.ctrlKey && e.key === 'f') {
            e.preventDefault();
            const searchInput = document.querySelector('input[name="search"]');
            if (searchInput) {
                searchInput.focus();
                searchInput.select();
            }
        }
        
        // Ctrl + P to print
        if (e.ctrlKey && e.key === 'p') {
            e.preventDefault();
            printPrescriptionHistory();
        }
        
        // Ctrl + E to export
        if (e.ctrlKey && e.key === 'e') {
            e.preventDefault();
            exportPrescriptionHistory();
        }
        
        // Ctrl + N for new prescription
        if (e.ctrlKey && e.key === 'n') {
            e.preventDefault();
            window.location.href = 'add-sale.php?with_prescription=true';
        }
    });

// Show prescription details on hover
    document.addEventListener('DOMContentLoaded', function() {
        const tooltip = document.createElement('div');
        tooltip.className = 'custom-tooltip';
        tooltip.style.cssText = `
            position: absolute;
            background: #333;
            color: white;
            padding: 8px 12px;
            border-radius: 4px;
            font-size: 12px;
            z-index: 1000;
            max-width: 300px;
            display: none;
            pointer-events: none;
        `;
        document.body.appendChild(tooltip);
        
        const rows = document.querySelectorAll('tbody tr');
        rows.forEach(row => {
            row.addEventListener('mouseenter', function(e) {
                const rect = this.getBoundingClientRect();
                const doctorName = this.querySelector('td:nth-child(2) strong')?.textContent || 'N/A';
                const medicineName = this.querySelector('td:nth-child(3) strong')?.textContent || 'N/A';
                const saleAmount = this.querySelector('td:nth-child(4) .text-success strong')?.textContent || '₹0.00';
                const prescriptionDate = this.querySelector('td:nth-child(5) strong')?.nextSibling?.textContent?.trim() || 'N/A';
                
                tooltip.innerHTML = `
                    <strong>${doctorName}</strong><br>
                    Medicine: ${medicineName}<br>
                    Amount: ${saleAmount}<br>
                    Date: ${prescriptionDate}
                `;
                
                tooltip.style.left = (rect.left + window.scrollX + 10) + 'px';
                tooltip.style.top = (rect.top + window.scrollY - 40) + 'px';
                tooltip.style.display = 'block';
            });
            
            row.addEventListener('mouseleave', function() {
                tooltip.style.display = 'none';
            });
        });
    });
</script>

</body>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: prescription-history.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation