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/ecommer.in/public_html/billing/medical

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: sale-details.php

<?php
// Start session at the very beginning

// Turn off error display for production
error_reporting(E_ALL);
ini_set('display_errors', 0);
ini_set('log_errors', 1);

include('includes/head.php');
include('includes/db_connection.php');

// Check if sale ID is provided
$sale_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

if ($sale_id === 0) {
    header("Location: sales-history.php");
    exit();
}

// Fetch sale details - FIXED: Use COUNT(si.id) instead of counting in GROUP BY
$sale_stmt = $conn->prepare("
    SELECT 
        s.*,
        COUNT(si.id) as items_count,
        COALESCE(SUM(si.quantity), 0) as total_quantity
    FROM sales s
    LEFT JOIN sale_items si ON s.id = si.sale_id
    WHERE s.id = ?
    GROUP BY s.id
");
$sale_stmt->bind_param("i", $sale_id);
$sale_stmt->execute();
$sale_result = $sale_stmt->get_result();

if ($sale_result->num_rows === 0) {
    header("Location: sales-history.php?error=Sale not found");
    exit();
}

$sale = $sale_result->fetch_assoc();

// If items_count is 0, fetch it separately
if ($sale['items_count'] == 0) {
    $count_stmt = $conn->prepare("SELECT COUNT(*) as items_count, COALESCE(SUM(quantity), 0) as total_quantity FROM sale_items WHERE sale_id = ?");
    $count_stmt->bind_param("i", $sale_id);
    $count_stmt->execute();
    $count_result = $count_stmt->get_result();
    if ($count_row = $count_result->fetch_assoc()) {
        $sale['items_count'] = $count_row['items_count'];
        $sale['total_quantity'] = $count_row['total_quantity'];
    }
}

// Fetch sale items
$items_stmt = $conn->prepare("
    SELECT 
        si.*,
        m.medicine_name,
        m.generic_name,
        m.batch_number,
        m.expiry_date,
        m.requires_prescription,
        m.schedule_type,
        m.is_narcotic,
        m.hsn_code,
        m.gst_rate,
        pd.doctor_name,
        pd.patient_name,
        pd.prescription_date,
        pd.pharmacist_signature,
        pd.signature_date
    FROM sale_items si
    JOIN medicines m ON si.medicine_id = m.id
    LEFT JOIN prescription_details pd ON si.sale_id = pd.sale_id AND m.id = pd.medicine_id
    WHERE si.sale_id = ?
    ORDER BY si.id
");
$items_stmt->bind_param("i", $sale_id);
$items_stmt->execute();
$items_result = $items_stmt->get_result();
$sale_items = [];
$total_gst = 0;
$has_schedule_h1 = false;
$has_narcotic = false;

while ($item = $items_result->fetch_assoc()) {
    $sale_items[] = $item;
    // Calculate GST for each item
    $gst_amount = ($item['subtotal'] * $item['gst_rate']) / 100;
    $total_gst += $gst_amount;
    
    // Check for special drugs
    if (in_array($item['schedule_type'], ['H1', 'H'])) {
        $has_schedule_h1 = true;
    }
    if ($item['is_narcotic'] == 1) {
        $has_narcotic = true;
    }
}

// Fetch prescription details if exists
$prescription_stmt = $conn->prepare("
    SELECT * FROM prescription_details 
    WHERE sale_id = ?
");
$prescription_stmt->bind_param("i", $sale_id);
$prescription_stmt->execute();
$prescription_result = $prescription_stmt->get_result();
$prescription_details = $prescription_result->fetch_all(MYSQLI_ASSOC);

// Handle actions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['cancel_sale'])) {
        $conn->begin_transaction();
        try {
            // Restore stock for each item
            foreach ($sale_items as $item) {
                $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();
            $_SESSION['success_message'] = "Sale cancelled successfully! Stock has been restored.";
            header("Location: " . $_SERVER['PHP_SELF'] . "?id=" . $sale_id);
            exit();
            
        } catch (Exception $e) {
            $conn->rollback();
            $_SESSION['error_message'] = "Error cancelling sale: " . $e->getMessage();
            header("Location: " . $_SERVER['PHP_SELF'] . "?id=" . $sale_id);
            exit();
        }
    }
    
    if (isset($_POST['refund_sale'])) {
        $conn->begin_transaction();
        try {
            // Restore stock for each item
            foreach ($sale_items as $item) {
                $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();
            }
            
            // Create refund record
            $refund_stmt = $conn->prepare("
                INSERT INTO refunds (sale_id, refund_date, refund_amount, refund_method, return_type, status)
                VALUES (?, NOW(), ?, 'cash', 'full', 'completed')
            ");
            $refund_stmt->bind_param("id", $sale_id, $sale['total_amount']);
            $refund_stmt->execute();
            $refund_id = $conn->insert_id;
            
            // Add refund items
            foreach ($sale_items as $item) {
                $refund_item_stmt = $conn->prepare("
                    INSERT INTO refund_items (refund_id, medicine_id, quantity, unit_price, subtotal)
                    VALUES (?, ?, ?, ?, ?)
                ");
                $refund_item_stmt->bind_param("iiidd", $refund_id, $item['medicine_id'], $item['quantity'], $item['unit_price'], $item['subtotal']);
                $refund_item_stmt->execute();
            }
            
            // Update sale status to refunded
            $update_stmt = $conn->prepare("
                UPDATE sales 
                SET status = 'refunded', updated_at = NOW() 
                WHERE id = ?
            ");
            $update_stmt->bind_param("i", $sale_id);
            $update_stmt->execute();
            
            $conn->commit();
            $_SESSION['success_message'] = "Sale refunded successfully! Stock has been restored.";
            header("Location: " . $_SERVER['PHP_SELF'] . "?id=" . $sale_id);
            exit();
            
        } catch (Exception $e) {
            $conn->rollback();
            $_SESSION['error_message'] = "Error refunding sale: " . $e->getMessage();
            header("Location: " . $_SERVER['PHP_SELF'] . "?id=" . $sale_id);
            exit();
        }
    }
    
    if (isset($_POST['add_signature'])) {
        $pharmacist_signature = trim($_POST['pharmacist_signature']);
        $medicine_id = (int)$_POST['medicine_id'];
        
        if (!empty($pharmacist_signature)) {
            $signature_stmt = $conn->prepare("
                UPDATE prescription_details 
                SET pharmacist_signature = ?, signature_date = NOW()
                WHERE sale_id = ? AND medicine_id = ?
            ");
            $signature_stmt->bind_param("sii", $pharmacist_signature, $sale_id, $medicine_id);
            
            if ($signature_stmt->execute()) {
                $_SESSION['success_message'] = "Pharmacist signature added successfully.";
                
                // Log the action in audit trail
                $audit_stmt = $conn->prepare("
                    INSERT INTO audit_trail (user_name, action_type, table_name, record_id, ip_address, description, timestamp)
                    VALUES ('System', 'SCHEDULE_H1_SIGNED', 'prescription_details', ?, ?, 'Signature added for Schedule H1 drug sale #?', NOW())
                ");
                $audit_stmt->bind_param("isi", $medicine_id, $_SERVER['REMOTE_ADDR'], $sale_id);
                $audit_stmt->execute();
                
                // Also log in schedule_h1_audit table
                if ($has_schedule_h1) {
                    $schedule_audit_stmt = $conn->prepare("
                        INSERT INTO schedule_h1_audit (sale_id, medicine_id, action_type, action_by, ip_address)
                        VALUES (?, ?, 'SIGNATURE_ADDED', ?, ?)
                    ");
                    $schedule_audit_stmt->bind_param("iiss", $sale_id, $medicine_id, $pharmacist_signature, $_SERVER['REMOTE_ADDR']);
                    $schedule_audit_stmt->execute();
                }
                
                header("Location: " . $_SERVER['PHP_SELF'] . "?id=" . $sale_id);
                exit();
            } else {
                $_SESSION['error_message'] = "Error adding signature: " . $conn->error;
                header("Location: " . $_SERVER['PHP_SELF'] . "?id=" . $sale_id);
                exit();
            }
        }
    }
}

// Calculate tax breakdown
$gst_rate = count($sale_items) > 0 ? $sale_items[0]['gst_rate'] : 0;
$cgst = $total_gst / 2;
$sgst = $total_gst / 2;
$subtotal_without_tax = $sale['total_amount'] - $total_gst;

// Get similar sales (for recommendation)
$similar_sales = [];
if (!empty($sale['customer_phone'])) {
    $similar_sales_stmt = $conn->prepare("
        SELECT DISTINCT s.id, s.sale_date, s.total_amount, s.customer_name
        FROM sales s
        JOIN sale_items si ON s.id = si.sale_id
        WHERE s.id != ? 
        AND s.customer_phone = ?
        AND s.status = 'completed'
        ORDER BY s.sale_date DESC
        LIMIT 5
    ");
    $similar_sales_stmt->bind_param("is", $sale_id, $sale['customer_phone']);
    $similar_sales_stmt->execute();
    $similar_sales_result = $similar_sales_stmt->get_result();
    
    while ($similar = $similar_sales_result->fetch_assoc()) {
        $similar_sales[] = $similar;
    }
}

// Get schedule H1 drugs list
$h1_drugs_stmt = $conn->prepare("SELECT * FROM schedule_h1_drugs WHERE status = 'active' ORDER BY drug_name");
$h1_drugs_stmt->execute();
$h1_drugs_result = $h1_drugs_stmt->get_result();
$h1_drugs = [];
while ($drug = $h1_drugs_result->fetch_assoc()) {
    $h1_drugs[] = $drug;
}

// Close prepared statements
$sale_stmt->close();
$items_stmt->close();
$prescription_stmt->close();
?>

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

<div class="row">
                    
                    <div class="col-lg-8">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title">Sale Information</h4>
                                    <div class="d-flex gap-2">
                                        <span class="badge bg-<?php echo getStatusColor($sale['status']); ?> fs-6">
                                            <?php echo strtoupper($sale['status']); ?>
                                        </span>
                                        <?php if ($has_schedule_h1): ?>
                                            <span class="badge bg-warning fs-6">Schedule H1</span>
                                        <?php endif; ?>
                                        <?php if ($has_narcotic): ?>
                                            <span class="badge bg-danger fs-6">Narcotic</span>
                                        <?php endif; ?>
                                        <a href="receipt.php?sale_id=<?php echo $sale_id; ?>&print=true" 
                                           class="btn btn-outline-info btn-sm" target="_blank">
                                            <i class="mdi mdi-printer me-1"></i> Print Receipt
                                        </a>
                                        <a href="sales-history.php" class="btn btn-outline-secondary btn-sm">
                                            <i class="mdi mdi-arrow-left me-1"></i> Back to Sales
                                        </a>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-md-6">
                                        <div class="border p-3 rounded">
                                            <h6 class="text-muted mb-3">Sale Details</h6>
                                            <div class="row">
                                                <div class="col-6">
                                                    <strong>Sale ID:</strong>
                                                </div>
                                                <div class="col-6">
                                                    #<?php echo str_pad($sale_id, 6, '0', STR_PAD_LEFT); ?>
                                                </div>
                                            </div>
                                            <div class="row mt-2">
                                                <div class="col-6">
                                                    <strong>Date:</strong>
                                                </div>
                                                <div class="col-6">
                                                    <?php echo date('d M Y', strtotime($sale['sale_date'])); ?>
                                                </div>
                                            </div>
                                            <div class="row mt-2">
                                                <div class="col-6">
                                                    <strong>Time:</strong>
                                                </div>
                                                <div class="col-6">
                                                    <?php echo date('h:i A', strtotime($sale['sale_date'])); ?>
                                                </div>
                                            </div>
                                            <div class="row mt-2">
                                                <div class="col-6">
                                                    <strong>Items:</strong>
                                                </div>
                                                <div class="col-6">
                                                    <?php echo $sale['items_count']; ?>
                                                </div>
                                            </div>
                                            <div class="row mt-2">
                                                <div class="col-6">
                                                    <strong>Total Quantity:</strong>
                                                </div>
                                                <div class="col-6">
                                                    <?php echo $sale['total_quantity']; ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="border p-3 rounded">
                                            <h6 class="text-muted mb-3">Customer Information</h6>
                                            <?php if (!empty($sale['customer_name'])): ?>
                                                <div class="row">
                                                    <div class="col-5">
                                                        <strong>Name:</strong>
                                                    </div>
                                                    <div class="col-7">
                                                        <?php echo htmlspecialchars($sale['customer_name']); ?>
                                                    </div>
                                                </div>
                                            <?php endif; ?>
                                            <?php if (!empty($sale['customer_phone'])): ?>
                                                <div class="row mt-2">
                                                    <div class="col-5">
                                                        <strong>Phone:</strong>
                                                    </div>
                                                    <div class="col-7">
                                                        <?php echo htmlspecialchars($sale['customer_phone']); ?>
                                                    </div>
                                                </div>
                                            <?php endif; ?>
                                            <div class="row mt-2">
                                                <div class="col-5">
                                                    <strong>Payment Method:</strong>
                                                </div>
                                                <div class="col-7">
                                                    <span class="badge bg-<?php echo getPaymentMethodColor($sale['payment_method']); ?>">
                                                        <?php echo strtoupper($sale['payment_method']); ?>
                                                    </span>
                                                </div>
                                            </div>
                                            <div class="row mt-2">
                                                <div class="col-5">
                                                    <strong>Last Updated:</strong>
                                                </div>
                                                <div class="col-7">
                                                    <?php echo date('d M Y H:i', strtotime($sale['updated_at'])); ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<?php if (count($sale_items) > 0): ?>
                                <h5 class="mb-3">Items Sold</h5>
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Medicine Name</th>
                                                <th>Batch No.</th>
                                                <th>Expiry Date</th>
                                                <th>Schedule Type</th>
                                                <th class="text-center">Qty</th>
                                                <th class="text-end">Unit Price</th>
                                                <th class="text-end">GST %</th>
                                                <th class="text-end">Subtotal</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php $counter = 1; ?>
                                            <?php foreach ($sale_items as $item): ?>
                                                <tr>
                                                    <td><?php echo $counter++; ?></td>
                                                    <td>
                                                        <strong><?php echo htmlspecialchars($item['medicine_name']); ?></strong>
                                                        <?php if (!empty($item['generic_name'])): ?>
                                                            <br>
                                                            <small class="text-muted"><?php echo htmlspecialchars($item['generic_name']); ?></small>
                                                        <?php endif; ?>
                                                        <?php if ($item['requires_prescription']): ?>
                                                            <br>
                                                            <span class="badge bg-info">Prescription Required</span>
                                                        <?php endif; ?>
                                                        <?php if ($item['is_narcotic']): ?>
                                                            <br>
                                                            <span class="badge bg-danger">Narcotic</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <code><?php echo htmlspecialchars($item['batch_number']); ?></code>
                                                    </td>
                                                    <td>
                                                        <?php echo date('M Y', strtotime($item['expiry_date'])); ?>
                                                        <?php
                                                        $expiry_status = getExpiryStatus($item['expiry_date']);
                                                        if ($expiry_status === 'expired'): ?>
                                                            <br>
                                                            <span class="badge bg-danger">Expired</span>
                                                        <?php elseif ($expiry_status === 'expiring_soon'): ?>
                                                            <br>
                                                            <span class="badge bg-warning">Expiring Soon</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <?php if ($item['schedule_type'] != 'G'): ?>
                                                            <span class="badge bg-<?php echo getScheduleColor($item['schedule_type']); ?>">
                                                                <?php echo $item['schedule_type']; ?>
                                                            </span>
                                                        <?php else: ?>
                                                            <span class="text-muted">G</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td class="text-center"><?php echo $item['quantity']; ?></td>
                                                    <td class="text-end">₹<?php echo number_format($item['unit_price'], 2); ?></td>
                                                    <td class="text-end"><?php echo number_format($item['gst_rate'], 2); ?>%</td>
                                                    <td class="text-end">
                                                        <strong>₹<?php echo number_format($item['subtotal'], 2); ?></strong>
                                                    </td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                                <?php else: ?>
                                <div class="alert alert-info text-center">
                                    <h5>No Items Found</h5>
                                    <p>This sale doesn't have any items recorded.</p>
                                </div>
                                <?php endif; ?>

<?php if (!empty($prescription_details) || $has_schedule_h1 || $has_narcotic): ?>
                                <div class="card mt-4">
                                    <div class="card-body">
                                        <h5 class="card-title mb-3">Prescription & Regulatory Information</h5>
                                        
                                        <?php if (!empty($prescription_details)): ?>
                                        <div class="mb-4">
                                            <h6 class="text-muted mb-2">Prescription Details</h6>
                                            <?php foreach ($prescription_details as $prescription): ?>
                                                <div class="border p-3 rounded mb-2">
                                                    <div class="row">
                                                        <div class="col-md-6">
                                                            <strong>Doctor:</strong> <?php echo htmlspecialchars($prescription['doctor_name']); ?><br>
                                                            <?php if (!empty($prescription['doctor_license'])): ?>
                                                                <strong>License:</strong> <?php echo htmlspecialchars($prescription['doctor_license']); ?><br>
                                                            <?php endif; ?>
                                                        </div>
                                                        <div class="col-md-6">
                                                            <?php if (!empty($prescription['patient_name'])): ?>
                                                                <strong>Patient:</strong> <?php echo htmlspecialchars($prescription['patient_name']); ?><br>
                                                            <?php endif; ?>
                                                            <?php if (!empty($prescription['prescription_date'])): ?>
                                                                <strong>Date:</strong> <?php echo date('d M Y', strtotime($prescription['prescription_date'])); ?>
                                                            <?php endif; ?>
                                                        </div>
                                                    </div>
                                                    
                                                    <?php if (!empty($prescription['pharmacist_signature'])): ?>
                                                    <div class="row mt-2 pt-2 border-top">
                                                        <div class="col-12">
                                                            <strong>Pharmacist Signature:</strong> 
                                                            <span class="text-success"><?php echo htmlspecialchars($prescription['pharmacist_signature']); ?></span>
                                                            <?php if (!empty($prescription['signature_date'])): ?>
                                                                <br>
                                                                <small class="text-muted">Signed on: <?php echo date('d M Y H:i', strtotime($prescription['signature_date'])); ?></small>
                                                            <?php endif; ?>
                                                        </div>
                                                    </div>
                                                    <?php endif; ?>
                                                </div>
                                            <?php endforeach; ?>
                                        </div>
                                        <?php endif; ?>
                                        
                                        
                                        <?php if ($has_schedule_h1 && $sale['status'] == 'completed'): ?>
                                        <div class="border p-3 rounded bg-light">
                                            <h6 class="text-muted mb-3">Schedule H1 Drug Verification</h6>
                                            <form method="POST" class="row g-3">
                                                <div class="col-md-6">
                                                    <label class="form-label">Select Medicine</label>
                                                    <select name="medicine_id" class="form-select" required>
                                                        <option value="">Select medicine...</option>
                                                        <?php foreach ($sale_items as $item): ?>
                                                            <?php if (in_array($item['schedule_type'], ['H1', 'H']) && empty($item['pharmacist_signature'])): ?>
                                                                <option value="<?php echo $item['medicine_id']; ?>">
                                                                    <?php echo htmlspecialchars($item['medicine_name']); ?> (Batch: <?php echo $item['batch_number']; ?>)
                                                                </option>
                                                            <?php endif; ?>
                                                        <?php endforeach; ?>
                                                    </select>
                                                </div>
                                                <div class="col-md-6">
                                                    <label class="form-label">Pharmacist Signature</label>
                                                    <input type="text" name="pharmacist_signature" class="form-control" 
                                                           placeholder="Enter your name" required>
                                                </div>
                                                <div class="col-12">
                                                    <button type="submit" name="add_signature" class="btn btn-warning">
                                                        <i class="mdi mdi-signature me-1"></i> Add Signature
                                                    </button>
                                                    <small class="text-muted ms-2">
                                                        Required for Schedule H1 drugs as per regulations
                                                    </small>
                                                </div>
                                            </form>
                                        </div>
                                        <?php endif; ?>
                                    </div>
                                </div>
                                <?php endif; ?>

<?php if (count($sale_items) > 0): ?>
                                <div class="row justify-content-end mt-4">
                                    <div class="col-md-6">
                                        <div class="border p-3 rounded">
                                            <h6 class="text-muted mb-3">Payment Summary</h6>
                                            <div class="row mb-2">
                                                <div class="col-6">
                                                    <strong>Subtotal:</strong>
                                                </div>
                                                <div class="col-6 text-end">
                                                    ₹<?php echo number_format($subtotal_without_tax, 2); ?>
                                                </div>
                                            </div>
                                            <?php if ($total_gst > 0): ?>
                                            <div class="row mb-2">
                                                <div class="col-6">
                                                    <strong>CGST (<?php echo number_format($gst_rate/2, 2); ?>%):</strong>
                                                </div>
                                                <div class="col-6 text-end">
                                                    ₹<?php echo number_format($cgst, 2); ?>
                                                </div>
                                            </div>
                                            <div class="row mb-2">
                                                <div class="col-6">
                                                    <strong>SGST (<?php echo number_format($gst_rate/2, 2); ?>%):</strong>
                                                </div>
                                                <div class="col-6 text-end">
                                                    ₹<?php echo number_format($sgst, 2); ?>
                                                </div>
                                            </div>
                                            <div class="row mb-2">
                                                <div class="col-6">
                                                    <strong>Total GST:</strong>
                                                </div>
                                                <div class="col-6 text-end">
                                                    ₹<?php echo number_format($total_gst, 2); ?>
                                                </div>
                                            </div>
                                            <?php endif; ?>
                                            <div class="row mt-3 pt-2 border-top">
                                                <div class="col-6">
                                                    <strong class="fs-5">Grand Total:</strong>
                                                </div>
                                                <div class="col-6 text-end">
                                                    <strong class="fs-5 text-success">₹<?php echo number_format($sale['total_amount'], 2); ?></strong>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>

<?php if ($sale['status'] === 'completed'): ?>
                                <div class="row mt-4">
                                    <div class="col-12">
                                        <div class="border p-3 rounded bg-light">
                                            <h6 class="text-muted mb-3">Sale Actions</h6>
                                            <form method="POST" class="d-flex gap-2">
                                                <button type="submit" name="cancel_sale" 
                                                        class="btn btn-outline-danger"
                                                        onclick="return confirm('Cancel this sale? Stock will be restored. This action cannot be undone.')">
                                                    <i class="mdi mdi-cancel me-1"></i> Cancel Sale
                                                </button>
                                                <button type="submit" name="refund_sale" 
                                                        class="btn btn-outline-warning"
                                                        onclick="return confirm('Process refund for this sale? Stock will be restored. This action cannot be undone.')">
                                                    <i class="mdi mdi-cash-refund me-1"></i> Process Refund
                                                </button>
                                                <span class="text-muted ms-2 align-self-center">
                                                    Both actions will restore medicine stock to inventory.
                                                </span>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Quick Actions</h5>
                                <div class="d-grid gap-2">
                                    <a href="pos.php" class="btn btn-primary">
                                        <i class="mdi mdi-point-of-sale me-1"></i> New Sale
                                    </a>
                                    <a href="sales-history.php" class="btn btn-outline-primary">
                                        <i class="mdi mdi-format-list-bulleted me-1"></i> All Sales
                                    </a>
                                    <a href="receipt.php?sale_id=<?php echo $sale_id; ?>" 
                                       class="btn btn-outline-info" target="_blank">
                                        <i class="mdi mdi-receipt me-1"></i> View Receipt
                                    </a>
                                    <?php if ($has_schedule_h1): ?>
                                    <a href="schedule-h1-register.php" class="btn btn-outline-warning">
                                        <i class="mdi mdi-book me-1"></i> H1 Register
                                    </a>
                                    <?php endif; ?>
                                    <button onclick="printSaleDetails()" class="btn btn-outline-success">
                                        <i class="mdi mdi-printer me-1"></i> Print Details
                                    </button>
                                </div>
                            </div>
                        </div>

<div class="card mt-3">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Sale Statistics</h5>
                                <div class="row text-center">
                                    <div class="col-6 mb-3">
                                        <div class="border rounded p-2">
                                            <h4 class="text-primary mb-0"><?php echo $sale['items_count']; ?></h4>
                                            <small class="text-muted">Items</small>
                                        </div>
                                    </div>
                                    <div class="col-6 mb-3">
                                        <div class="border rounded p-2">
                                            <h4 class="text-success mb-0"><?php echo $sale['total_quantity']; ?></h4>
                                            <small class="text-muted">Total Qty</small>
                                        </div>
                                    </div>
                                    <div class="col-6">
                                        <div class="border rounded p-2">
                                            <h4 class="text-info mb-0">
                                                <?php 
                                                if ($sale['items_count'] > 0) {
                                                    echo '₹' . number_format($sale['total_amount'] / $sale['items_count'], 2);
                                                } else {
                                                    echo '₹0.00';
                                                }
                                                ?>
                                            </h4>
                                            <small class="text-muted">Avg. Item Price</small>
                                        </div>
                                    </div>
                                    <div class="col-6">
                                        <div class="border rounded p-2">
                                            <h4 class="text-warning mb-0">
                                                <?php 
                                                if ($sale['items_count'] > 0) {
                                                    echo number_format($sale['total_quantity'] / $sale['items_count'], 1);
                                                } else {
                                                    echo '0.0';
                                                }
                                                ?>
                                            </h4>
                                            <small class="text-muted">Avg. Qty per Item</small>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<?php if (!empty($similar_sales) && !empty($sale['customer_phone'])): ?>
                        <div class="card mt-3">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Customer Purchase History</h5>
                                <div class="table-responsive">
                                    <table class="table table-sm table-borderless">
                                        <tbody>
                                            <?php foreach ($similar_sales as $similar): ?>
                                                <tr>
                                                    <td>
                                                        <a href="sale-details.php?id=<?php echo $similar['id']; ?>" 
                                                           class="text-primary">
                                                            #<?php echo str_pad($similar['id'], 6, '0', STR_PAD_LEFT); ?>
                                                        </a>
                                                        <br>
                                                        <small class="text-muted">
                                                            <?php echo date('d M Y', strtotime($similar['sale_date'])); ?>
                                                        </small>
                                                    </td>
                                                    <td class="text-end">
                                                        <strong>₹<?php echo number_format($similar['total_amount'], 2); ?></strong>
                                                    </td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                                <div class="text-center mt-2">
                                    <a href="customer-history.php?phone=<?php echo urlencode($sale['customer_phone']); ?>" 
                                       class="btn btn-sm btn-outline-primary">
                                        View Full History
                                    </a>
                                </div>
                            </div>
                        </div>
                        <?php endif; ?>

<div class="card mt-3">
                            <div class="card-body">
                                <h5 class="card-title mb-3">System Information</h5>
                                <div class="row">
                                    <div class="col-6">
                                        <small class="text-muted">Created:</small>
                                    </div>
                                    <div class="col-6 text-end">
                                        <small><?php echo date('d M Y H:i', strtotime($sale['created_at'])); ?></small>
                                    </div>
                                </div>
                                <div class="row mt-1">
                                    <div class="col-6">
                                        <small class="text-muted">Last Updated:</small>
                                    </div>
                                    <div class="col-6 text-end">
                                        <small><?php echo date('d M Y H:i', strtotime($sale['updated_at'])); ?></small>
                                    </div>
                                </div>
                                <div class="row mt-1">
                                    <div class="col-6">
                                        <small class="text-muted">Sale Duration:</small>
                                    </div>
                                    <div class="col-6 text-end">
                                        <small>
                                            <?php
                                            $sale_time = strtotime($sale['sale_date']);
                                            $now = time();
                                            $diff = $now - $sale_time;
                                            $days = floor($diff / (60 * 60 * 24));
                                            $hours = floor(($diff - ($days * 60 * 60 * 24)) / (60 * 60));
                                            echo $days . 'd ' . $hours . 'h ago';
                                            ?>
                                        </small>
                                    </div>
                                </div>
                                <?php if ($has_schedule_h1): ?>
                                <div class="row mt-2 pt-2 border-top">
                                    <div class="col-12">
                                        <small class="text-warning">
                                            <i class="mdi mdi-alert-circle me-1"></i>
                                            Contains Schedule H1 drugs requiring special records
                                        </small>
                                    </div>
                                </div>
                                <?php endif; ?>
                                <?php if ($has_narcotic): ?>
                                <div class="row mt-1">
                                    <div class="col-12">
                                        <small class="text-danger">
                                            <i class="mdi mdi-alert-circle me-1"></i>
                                            Contains Narcotic drugs requiring strict control
                                        </small>
                                    </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')?>

// Keyboard shortcuts
    document.addEventListener('keydown', function(e) {
        // Ctrl + P to print
        if (e.ctrlKey && e.key === 'p') {
            e.preventDefault();
            printSaleDetails();
        }
        
        // Escape to go back
        if (e.key === 'Escape') {
            window.history.back();
        }
    });

// Auto-refresh if sale status changes
    let currentStatus = '<?php echo $sale['status']; ?>';
    
    function checkStatusChange() {
        fetch(window.location.href)
            .then(response => response.text())
            .then(html => {
                const parser = new DOMParser();
                const doc = parser.parseFromString(html, 'text/html');
                const statusBadge = doc.querySelector('.badge.fs-6');
                if (statusBadge) {
                    const newStatus = statusBadge.textContent.trim().toLowerCase();
                    if (newStatus !== currentStatus.toLowerCase()) {
                        if (confirm('Sale status has changed. Refresh page?')) {
                            window.location.reload();
                        }
                    }
                }
            })
            .catch(error => console.error('Error checking status:', error));
    }

// Check for status changes every 30 seconds
    setInterval(checkStatusChange, 30000);

// Highlight expired medicines
    document.addEventListener('DOMContentLoaded', function() {
        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)';
            }
        });
    });
</script>

</body>

</html>

<?php
// Helper functions
function getStatusColor($status) {
    switch ($status) {
        case 'completed': return 'success';
        case 'cancelled': return 'danger';
        case 'refunded': return 'warning';
        default: return 'secondary';
    }
}

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 getScheduleColor($schedule) {
    switch ($schedule) {
        case 'H1': return 'warning';
        case 'H': return 'primary';
        case 'X': return 'danger';
        case 'NARCOTIC': return 'danger';
        default: return 'secondary';
    }
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sale-details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation