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: print-prescription.php

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

if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    die('Invalid prescription ID');
}

$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,
           c.customer_address,
           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 customers c ON s.customer_phone = c.customer_phone
    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) {
    die('Prescription not found');
}

$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';
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Prescription - #<?php echo $prescription_id; ?></title>
    <style>
        @page {
            size: A4;
            margin: 20mm;
        }
        
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            margin: 0;
            padding: 20px;
            background-color: #fff;
            color: #333;
        }
        
        .prescription-container {
            max-width: 800px;
            margin: 0 auto;
            border: 2px solid #333;
            padding: 30px;
            background-color: #fff;
        }
        
        .header {
            text-align: center;
            margin-bottom: 30px;
            border-bottom: 2px solid #333;
            padding-bottom: 20px;
        }
        
        .store-name {
            font-size: 28px;
            font-weight: bold;
            color: #2c3e50;
            margin-bottom: 5px;
        }
        
        .store-address {
            font-size: 14px;
            color: #666;
            margin-bottom: 10px;
        }
        
        .store-contact {
            font-size: 14px;
            color: #666;
        }
        
        .prescription-title {
            text-align: center;
            margin: 30px 0;
            font-size: 24px;
            font-weight: bold;
            color: #2c3e50;
            text-decoration: underline;
        }
        
        .details-section {
            margin-bottom: 25px;
        }
        
        .section-title {
            background-color: #f8f9fa;
            padding: 10px 15px;
            font-weight: bold;
            margin-bottom: 15px;
            border-left: 4px solid #007bff;
            border-radius: 4px;
        }
        
        .details-grid {
            display: grid;
            grid-template-columns: repeat(2, 1fr);
            gap: 15px;
        }
        
        .detail-item {
            margin-bottom: 10px;
        }
        
        .detail-label {
            font-weight: bold;
            color: #555;
            margin-bottom: 5px;
            font-size: 14px;
        }
        
        .detail-value {
            padding: 8px;
            background-color: #f8f9fa;
            border-radius: 4px;
            border: 1px solid #dee2e6;
            font-size: 15px;
        }
        
        .medicine-table {
            width: 100%;
            border-collapse: collapse;
            margin: 20px 0;
        }
        
        .medicine-table th {
            background-color: #343a40;
            color: white;
            padding: 12px;
            text-align: left;
            font-size: 14px;
        }
        
        .medicine-table td {
            padding: 12px;
            border: 1px solid #dee2e6;
            font-size: 14px;
        }
        
        .medicine-table tr:nth-child(even) {
            background-color: #f8f9fa;
        }
        
        .amount-summary {
            margin-top: 30px;
            border-top: 2px solid #333;
            padding-top: 20px;
        }
        
        .amount-row {
            display: flex;
            justify-content: space-between;
            margin-bottom: 10px;
            font-size: 16px;
        }
        
        .total-row {
            font-size: 18px;
            font-weight: bold;
            border-top: 1px solid #333;
            padding-top: 10px;
            margin-top: 10px;
        }
        
        .footer {
            margin-top: 50px;
            text-align: center;
            font-size: 12px;
            color: #666;
            border-top: 1px solid #dee2e6;
            padding-top: 20px;
        }
        
        .signature-section {
            margin-top: 40px;
            display: flex;
            justify-content: space-between;
        }
        
        .signature-box {
            width: 45%;
            text-align: center;
            border-top: 1px solid #333;
            padding-top: 20px;
        }
        
        .warning-box {
            background-color: #fff3cd;
            border: 1px solid #ffeaa7;
            padding: 15px;
            margin: 20px 0;
            border-radius: 5px;
            font-size: 14px;
        }
        
        .print-info {
            text-align: right;
            font-size: 12px;
            color: #666;
            margin-bottom: 20px;
        }
        
        @media print {
            body {
                margin: 0;
                padding: 0;
            }
            
            .prescription-container {
                border: none;
                padding: 0;
                max-width: 100%;
            }
            
            .no-print {
                display: none;
            }
            
            .header {
                margin-bottom: 20px;
            }
            
            .print-info {
                display: none;
            }
        }
        
        @media screen {
            .no-screen {
                display: none;
            }
        }
    </style>
</head>
<body>
    <div class="print-info no-print">
        <button onclick="window.print()" class="no-print" style="background: #007bff; color: white; border: none; padding: 10px 20px; border-radius: 4px; cursor: pointer; font-size: 16px;">
            <i class="mdi mdi-printer"></i> Print Prescription
        </button>
        <button onclick="window.close()" class="no-print" style="background: #6c757d; color: white; border: none; padding: 10px 20px; border-radius: 4px; cursor: pointer; font-size: 16px; margin-left: 10px;">
            <i class="mdi mdi-close"></i> Close
        </button>
        <p class="no-print">Prescription will be printed in A4 format</p>
    </div>

<div class="prescription-container">
        
        <div class="header">
            <div class="store-name">MEDICAL STORE</div>
            <div class="store-address">123 Health Street, Medical City, MC 123456</div>
            <div class="store-contact">
                Phone: +91 9876543210 | Email: info@medicalstore.com<br>
                GSTIN: 22ABCDE1234F1Z5 | License No: MED123456
            </div>
        </div>

<div class="prescription-title">
            MEDICAL PRESCRIPTION
        </div>

<div class="print-info no-screen">
            Prescription ID: #<?php echo $prescription_id; ?> | Printed on: <?php echo date('d/m/Y H:i:s'); ?>
        </div>

<div class="details-section">
            <div class="section-title">DOCTOR INFORMATION</div>
            <div class="details-grid">
                <div class="detail-item">
                    <div class="detail-label">Doctor Name</div>
                    <div class="detail-value">Dr. <?php echo htmlspecialchars($prescription['doctor_name']); ?></div>
                </div>
                <?php if (!empty($prescription['doctor_license'])): ?>
                <div class="detail-item">
                    <div class="detail-label">Medical License</div>
                    <div class="detail-value"><?php echo htmlspecialchars($prescription['doctor_license']); ?></div>
                </div>
                <?php endif; ?>
                <div class="detail-item">
                    <div class="detail-label">Prescription Date</div>
                    <div class="detail-value"><?php echo $prescription_date; ?></div>
                </div>
                <div class="detail-item">
                    <div class="detail-label">Sale Date</div>
                    <div class="detail-value"><?php echo $sale_date; ?></div>
                </div>
            </div>
        </div>

<div class="details-section">
            <div class="section-title">PATIENT INFORMATION</div>
            <div class="details-grid">
                <?php if (!empty($prescription['patient_name'])): ?>
                <div class="detail-item">
                    <div class="detail-label">Patient Name</div>
                    <div class="detail-value"><?php echo htmlspecialchars($prescription['patient_name']); ?></div>
                </div>
                <?php endif; ?>
                <div class="detail-item">
                    <div class="detail-label">Customer Name</div>
                    <div class="detail-value"><?php echo htmlspecialchars($prescription['customer_name']); ?></div>
                </div>
                <div class="detail-item">
                    <div class="detail-label">Contact Number</div>
                    <div class="detail-value"><?php echo htmlspecialchars($prescription['customer_phone']); ?></div>
                </div>
                <?php if (!empty($prescription['customer_address'])): ?>
                <div class="detail-item" style="grid-column: span 2;">
                    <div class="detail-label">Address</div>
                    <div class="detail-value"><?php echo htmlspecialchars($prescription['customer_address']); ?></div>
                </div>
                <?php endif; ?>
            </div>
        </div>

<div class="details-section">
            <div class="section-title">PRESCRIBED MEDICINE</div>
            <table class="medicine-table">
                <thead>
                    <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>
            
            <?php if (!empty($prescription['composition'])): ?>
            <div class="detail-item" style="margin-top: 15px;">
                <div class="detail-label">Composition</div>
                <div class="detail-value"><?php echo htmlspecialchars($prescription['composition']); ?></div>
            </div>
            <?php endif; ?>
            
            <?php if (!empty($prescription['manufacturer'])): ?>
            <div class="detail-item">
                <div class="detail-label">Manufacturer</div>
                <div class="detail-value"><?php echo htmlspecialchars($prescription['manufacturer']); ?></div>
            </div>
            <?php endif; ?>
        </div>

<div class="warning-box">
            <strong><i class="mdi mdi-alert"></i> IMPORTANT NOTES:</strong>
            <ul style="margin: 10px 0 0 20px; padding: 0;">
                <li>This medicine requires a valid doctor's prescription</li>
                <li>Store in a cool, dry place away from direct sunlight</li>
                <li>Keep out of reach of children</li>
                <li>Do not use after the expiry date</li>
                <li>Follow the dosage instructions as prescribed by the doctor</li>
            </ul>
        </div>

<div class="amount-summary">
            <div class="section-title">AMOUNT DETAILS</div>
            <div class="amount-row">
                <span>Medicine Cost:</span>
                <span>₹<?php echo number_format($prescription['item_subtotal'], 2); ?></span>
            </div>
            <?php if ($prescription['discount'] > 0): ?>
            <div class="amount-row">
                <span>Discount:</span>
                <span class="text-danger">-₹<?php echo number_format($prescription['discount'], 2); ?></span>
            </div>
            <?php endif; ?>
            <?php if ($prescription['tax_amount'] > 0): ?>
            <div class="amount-row">
                <span>Tax (GST <?php echo $prescription['gst_rate']; ?>%):</span>
                <span>₹<?php echo number_format($prescription['tax_amount'], 2); ?></span>
            </div>
            <?php endif; ?>
            <div class="amount-row total-row">
                <span>TOTAL AMOUNT:</span>
                <span class="text-success">₹<?php echo number_format($prescription['total_amount'], 2); ?></span>
            </div>
            <div class="amount-row" style="margin-top: 10px;">
                <span>Payment Method:</span>
                <span><?php echo strtoupper($prescription['payment_method']); ?></span>
            </div>
        </div>

<div class="signature-section">
            <div class="signature-box">
                <div style="height: 50px;"></div>
                <div>_________________________</div>
                <div style="margin-top: 5px; font-weight: bold;">Dr. <?php echo htmlspecialchars($prescription['doctor_name']); ?></div>
                <div style="font-size: 12px;">Prescribing Doctor</div>
            </div>
            <div class="signature-box">
                <div style="height: 50px;"></div>
                <div>_________________________</div>
                <div style="margin-top: 5px; font-weight: bold;">Pharmacy Staff</div>
                <div style="font-size: 12px;">Dispensing Pharmacist</div>
            </div>
        </div>

<div class="footer">
            <p>This is a computer-generated prescription. Original copy should be retained by the pharmacy.</p>
            <p>Prescription ID: #<?php echo $prescription_id; ?> | Sale ID: #<?php echo $prescription['sale_id']; ?> | Generated on: <?php echo date('d/m/Y H:i:s'); ?></p>
            <p>For any queries, contact: +91 9876543210 | Email: support@medicalstore.com</p>
        </div>
    </div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: print-prescription.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation