Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: view-prescription.php

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

if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    header('Location: prescriptions-list.php');
    exit;
}

$prescription_id = (int)$_GET['id'];

$query = "
    SELECT pd.*, 
           m.medicine_name,
           m.batch_number,
           m.expiry_date,
           m.composition,
           m.manufacturer,
           m.mrp,
           m.selling_price,
           m.gst_rate,
           m.requires_prescription,
           s.sale_date,
           s.total_amount,
           s.subtotal_amount,
           s.discount,
           s.tax_amount,
           s.payment_method,
           s.customer_name,
           s.customer_phone,
           si.quantity as sold_quantity,
           si.unit_price,
           si.subtotal as item_subtotal
    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 sale_items si ON pd.sale_id = si.sale_id AND pd.medicine_id = si.medicine_id
    WHERE pd.id = ?
";

$stmt = $conn->prepare($query);
$stmt->bind_param("i", $prescription_id);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows === 0) {
    header('Location: prescriptions-list.php');
    exit;
}

$prescription = $result->fetch_assoc();

// Format dates
$sale_date = date('d F Y, h:i A', strtotime($prescription['sale_date']));
$prescription_date = date('d F Y', strtotime($prescription['prescription_date']));
$record_date = date('d F Y, h:i A', strtotime($prescription['created_at']));
$expiry_date = !empty($prescription['expiry_date']) ? date('d F Y', strtotime($prescription['expiry_date'])) : 'N/A';

$title = "Prescription Details #" . $prescription_id;
include('includes/head.php');
?>

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

<div id="layout-wrapper">

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

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

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Prescription Details</h4>
                            <div class="page-title-right">
                                <div class="d-flex gap-2">
                                    <a href="print-prescription.php?id=<?php echo $prescription_id; ?>" target="_blank" class="btn btn-primary">
                                        <i class="mdi mdi-printer me-1"></i> Print Prescription
                                    </a>
                                    <a href="prescriptions-list.php" class="btn btn-secondary">
                                        <i class="mdi mdi-arrow-left me-1"></i> Back to List
                                    </a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-8">
                        <div class="card">
                            <div class="card-body">
                                <div class="row mb-4">
                                    <div class="col-md-6">
                                        <h5 class="card-title">Prescription Information</h5>
                                    </div>
                                    <div class="col-md-6 text-end">
                                        <span class="badge bg-success fs-6">PRESCRIPTION #<?php echo $prescription_id; ?></span>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-md-6">
                                        <div class="d-flex mb-2">
                                            <i class="mdi mdi-calendar-check font-size-18 text-primary me-2"></i>
                                            <div>
                                                <p class="mb-0 text-muted">Prescription Date</p>
                                                <h5 class="mb-0"><?php echo $prescription_date; ?></h5>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="d-flex mb-2">
                                            <i class="mdi mdi-calendar font-size-18 text-info me-2"></i>
                                            <div>
                                                <p class="mb-0 text-muted">Sale Date</p>
                                                <h5 class="mb-0"><?php echo $sale_date; ?></h5>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row">
                                    
                                    <div class="col-md-6">
                                        <div class="card mb-4">
                                            <div class="card-header bg-light">
                                                <h5 class="card-title mb-0">Doctor Information</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="mb-3">
                                                    <label class="form-label">Doctor Name</label>
                                                    <div class="form-control bg-light">Dr. <?php echo htmlspecialchars($prescription['doctor_name']); ?></div>
                                                </div>
                                                <?php if (!empty($prescription['doctor_license'])): ?>
                                                <div class="mb-3">
                                                    <label class="form-label">License Number</label>
                                                    <div class="form-control bg-light"><?php echo htmlspecialchars($prescription['doctor_license']); ?></div>
                                                </div>
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                    </div>

<div class="col-md-6">
                                        <div class="card mb-4">
                                            <div class="card-header bg-light">
                                                <h5 class="card-title mb-0">Patient Information</h5>
                                            </div>
                                            <div class="card-body">
                                                <?php if (!empty($prescription['patient_name'])): ?>
                                                <div class="mb-3">
                                                    <label class="form-label">Patient Name</label>
                                                    <div class="form-control bg-light"><?php echo htmlspecialchars($prescription['patient_name']); ?></div>
                                                </div>
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="card mb-4">
                                    <div class="card-header bg-light">
                                        <h5 class="card-title mb-0">Medicine Information</h5>
                                    </div>
                                    <div class="card-body">
                                        <div class="table-responsive">
                                            <table class="table table-bordered mb-0">
                                                <thead class="table-light">
                                                    <tr>
                                                        <th>Medicine Name</th>
                                                        <th>Batch No.</th>
                                                        <th>Expiry Date</th>
                                                        <th>Quantity</th>
                                                        <th>Unit Price</th>
                                                        <th>Subtotal</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <tr>
                                                        <td><?php echo htmlspecialchars($prescription['medicine_name']); ?></td>
                                                        <td><?php echo htmlspecialchars($prescription['batch_number']); ?></td>
                                                        <td><?php echo $expiry_date; ?></td>
                                                        <td><?php echo $prescription['sold_quantity']; ?></td>
                                                        <td>₹<?php echo number_format($prescription['unit_price'], 2); ?></td>
                                                        <td>₹<?php echo number_format($prescription['item_subtotal'], 2); ?></td>
                                                    </tr>
                                                </tbody>
                                            </table>
                                        </div>
                                        
                                        <?php if (!empty($prescription['composition'])): ?>
                                        <div class="mt-3">
                                            <label class="form-label">Composition</label>
                                            <div class="form-control bg-light"><?php echo htmlspecialchars($prescription['composition']); ?></div>
                                        </div>
                                        <?php endif; ?>
                                        
                                        <?php if (!empty($prescription['manufacturer'])): ?>
                                        <div class="mt-3">
                                            <label class="form-label">Manufacturer</label>
                                            <div class="form-control bg-light"><?php echo htmlspecialchars($prescription['manufacturer']); ?></div>
                                        </div>
                                        <?php endif; ?>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        
                        <div class="card mb-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Sale Information</h5>
                            </div>
                            <div class="card-body">
                                <div class="mb-3">
                                    <label class="form-label">Sale ID</label>
                                    <div class="form-control bg-light">#<?php echo $prescription['sale_id']; ?></div>
                                </div>
                                <div class="mb-3">
                                    <label class="form-label">Customer Name</label>
                                    <div class="form-control bg-light"><?php echo htmlspecialchars($prescription['customer_name']); ?></div>
                                </div>
                                <div class="mb-3">
                                    <label class="form-label">Customer Phone</label>
                                    <div class="form-control bg-light"><?php echo htmlspecialchars($prescription['customer_phone']); ?></div>
                                </div>
                                <div class="mb-3">
                                    <label class="form-label">Payment Method</label>
                                    <div class="form-control bg-light"><?php echo ucfirst($prescription['payment_method']); ?></div>
                                </div>
                            </div>
                        </div>

<div class="card mb-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Amount Summary</h5>
                            </div>
                            <div class="card-body">
                                <div class="d-flex justify-content-between mb-2">
                                    <span>Subtotal:</span>
                                    <strong>₹<?php echo number_format($prescription['subtotal_amount'], 2); ?></strong>
                                </div>
                                <?php if ($prescription['discount'] > 0): ?>
                                <div class="d-flex justify-content-between mb-2">
                                    <span>Discount:</span>
                                    <strong class="text-danger">-₹<?php echo number_format($prescription['discount'], 2); ?></strong>
                                </div>
                                <?php endif; ?>
                                <?php if ($prescription['tax_amount'] > 0): ?>
                                <div class="d-flex justify-content-between mb-2">
                                    <span>Tax (<?php echo $prescription['gst_rate']; ?>%):</span>
                                    <strong>₹<?php echo number_format($prescription['tax_amount'], 2); ?></strong>
                                </div>
                                <?php endif; ?>
                                <hr>
                                <div class="d-flex justify-content-between">
                                    <span class="fs-5">Total Amount:</span>
                                    <strong class="fs-4 text-success">₹<?php echo number_format($prescription['total_amount'], 2); ?></strong>
                                </div>
                            </div>
                        </div>

<div class="card">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Quick Actions</h5>
                            </div>
                            <div class="card-body">
                                <div class="d-grid gap-2">
                                    <a href="print-prescription.php?id=<?php echo $prescription_id; ?>" target="_blank" class="btn btn-primary">
                                        <i class="mdi mdi-printer me-2"></i> Print Prescription
                                    </a>
                                    <a href="receipt.php?sale_id=<?php echo $prescription['sale_id']; ?>" target="_blank" class="btn btn-success">
                                        <i class="mdi mdi-receipt me-2"></i> View Invoice
                                    </a>
                                    <a href="prescriptions-list.php" class="btn btn-outline-secondary">
                                        <i class="mdi mdi-arrow-left me-2"></i> Back to List
                                    </a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

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

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-prescription.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation