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: add-medicine.php

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

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

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

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

// Fetch categories for dropdown
$categories_result = $conn->query("SELECT id, category_name FROM medicine_categories WHERE status = 'active' ORDER BY category_name");

// Fetch suppliers for dropdown (if suppliers table exists)
$suppliers_table_check = $conn->query("SHOW TABLES LIKE 'suppliers'");
$suppliers_result = null;
if ($suppliers_table_check->num_rows > 0) {
    $suppliers_result = $conn->query("SELECT id, supplier_name FROM suppliers WHERE status = 'active' ORDER BY supplier_name");
}

// Fetch schedule H1 drugs for reference
$h1_drugs_result = $conn->query("SELECT drug_name, schedule_type FROM schedule_h1_drugs WHERE status = 'active' ORDER BY drug_name");
$h1_drugs = [];
if ($h1_drugs_result && $h1_drugs_result->num_rows > 0) {
    while ($drug = $h1_drugs_result->fetch_assoc()) {
        $h1_drugs[$drug['drug_name']] = $drug['schedule_type'];
    }
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['add_medicine'])) {
        // Get form data with proper validation
        $medicine_name = isset($_POST['medicine_name']) ? trim($_POST['medicine_name']) : '';
        $generic_name = isset($_POST['generic_name']) ? trim($_POST['generic_name']) : '';
        $category_id = isset($_POST['category_id']) ? (int)$_POST['category_id'] : 0;
        $supplier_id = isset($_POST['supplier_id']) && !empty($_POST['supplier_id']) ? (int)$_POST['supplier_id'] : NULL;
        $batch_number = isset($_POST['batch_number']) ? trim($_POST['batch_number']) : '';
        $expiry_date = isset($_POST['expiry_date']) ? $_POST['expiry_date'] : '';
        $mrp = isset($_POST['mrp']) ? floatval($_POST['mrp']) : 0;
        $cost_price = isset($_POST['cost_price']) ? floatval($_POST['cost_price']) : 0;
        $selling_price = isset($_POST['selling_price']) ? floatval($_POST['selling_price']) : 0;
        $stock_quantity = isset($_POST['stock_quantity']) ? intval($_POST['stock_quantity']) : 0;
        $min_stock_level = isset($_POST['min_stock_level']) ? intval($_POST['min_stock_level']) : 10;
        $rack_number = isset($_POST['rack_number']) ? trim($_POST['rack_number']) : '';
        $box_number = isset($_POST['box_number']) ? trim($_POST['box_number']) : '';
        $composition = isset($_POST['composition']) ? trim($_POST['composition']) : '';
        $manufacturer = isset($_POST['manufacturer']) ? trim($_POST['manufacturer']) : '';
        $requires_prescription = isset($_POST['requires_prescription']) ? 1 : 0;
        $schedule_type = isset($_POST['schedule_type']) ? $_POST['schedule_type'] : 'G';
        $is_narcotic = isset($_POST['is_narcotic']) ? 1 : 0;
        $max_quantity_per_prescription = isset($_POST['max_quantity_per_prescription']) && !empty($_POST['max_quantity_per_prescription']) ? (int)$_POST['max_quantity_per_prescription'] : NULL;
        $hsn_code = isset($_POST['hsn_code']) ? trim($_POST['hsn_code']) : '';
        $gst_rate = isset($_POST['gst_rate']) ? floatval($_POST['gst_rate']) : 0;
        
        // Auto-detect schedule type if medicine name matches H1/X drugs
        if (empty($schedule_type) || $schedule_type === 'G') {
            $medicine_upper = strtoupper($medicine_name);
            foreach ($h1_drugs as $drug_name => $schedule) {
                if (strpos($medicine_upper, strtoupper($drug_name)) !== false) {
                    $schedule_type = $schedule;
                    break;
                }
            }
            
            // Check for narcotics based on name
            $narcotic_keywords = ['MORPHINE', 'PETHIDINE', 'FENTANYL', 'METHADONE', 'BUPRENORPHINE', 
                                'CODEINE', 'OXYCODONE', 'HYDROCODONE', 'TRAMADOL', 'TAPENTADOL'];
            foreach ($narcotic_keywords as $keyword) {
                if (strpos($medicine_upper, $keyword) !== false) {
                    $is_narcotic = 1;
                    $schedule_type = ''; // Empty for narcotic as per your table structure
                    break;
                }
            }
        }
        
        // Validate required fields
        if (empty($medicine_name) || $category_id == 0) {
            $error_message = "Medicine name and category are required!";
        } else if (empty($batch_number)) {
            $error_message = "Batch number is required!";
        } else if (empty($expiry_date)) {
            $error_message = "Expiry date is required!";
        } else if ($mrp <= 0 || $cost_price <= 0) {
            $error_message = "MRP and cost price must be greater than 0!";
        } else {
            // Check if medicines table exists
            if (!$medicines_table_exists) {
                // Create medicines table if it doesn't exist
                $create_table_sql = "
                CREATE TABLE IF NOT EXISTS medicines (
                    id INT PRIMARY KEY AUTO_INCREMENT,
                    medicine_name VARCHAR(255) NOT NULL,
                    generic_name VARCHAR(255),
                    category_id INT NOT NULL,
                    supplier_id INT,
                    batch_number VARCHAR(100) NOT NULL,
                    expiry_date DATE NOT NULL,
                    mrp DECIMAL(10,2) NOT NULL,
                    cost_price DECIMAL(10,2) NOT NULL,
                    selling_price DECIMAL(10,2) NOT NULL,
                    stock_quantity INT DEFAULT 0,
                    min_stock_level INT DEFAULT 10,
                    rack_number VARCHAR(50),
                    box_number VARCHAR(50),
                    composition TEXT,
                    manufacturer VARCHAR(255),
                    requires_prescription BOOLEAN DEFAULT FALSE,
                    schedule_type ENUM('G','H','H1','X','NARCOTIC','OTHER') DEFAULT 'G',
                    is_narcotic BOOLEAN DEFAULT FALSE,
                    max_quantity_per_prescription INT,
                    hsn_code VARCHAR(50),
                    gst_rate DECIMAL(5,2) DEFAULT 0,
                    status ENUM('active', 'inactive') DEFAULT 'active',
                    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                    FOREIGN KEY (category_id) REFERENCES medicine_categories(id),
                    INDEX idx_rack_number (rack_number),
                    INDEX idx_box_number (box_number)
                )";
                
                if ($conn->query($create_table_sql)) {
                    $medicines_table_exists = true;
                    $success_message = "Medicines table created successfully!";
                } else {
                    $error_message = "Error creating medicines table: " . $conn->error;
                }
            }
            
            if ($medicines_table_exists) {
                // Check if medicine with same batch already exists
                $check_stmt = $conn->prepare("SELECT id FROM medicines WHERE batch_number = ?");
                $check_stmt->bind_param("s", $batch_number);
                $check_stmt->execute();
                $check_result = $check_stmt->get_result();
                
                if ($check_result->num_rows > 0) {
                    $error_message = "Medicine with this batch number already exists!";
                } else {
                    // Auto-calculate selling price if not provided
                    if ($selling_price <= 0) {
                        $selling_price = $mrp;
                    }
                    
                    // Insert new medicine
                    $stmt = $conn->prepare("INSERT INTO medicines (
                        medicine_name, generic_name, category_id, supplier_id, batch_number, 
                        expiry_date, mrp, cost_price, selling_price, stock_quantity, 
                        min_stock_level, rack_number, box_number, composition, manufacturer, 
                        requires_prescription, schedule_type, is_narcotic, max_quantity_per_prescription,
                        hsn_code, gst_rate
                    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
                    
                    $stmt->bind_param(
                        "ssiisssddiissssiisisd", 
                        $medicine_name, $generic_name, $category_id, $supplier_id, $batch_number,
                        $expiry_date, $mrp, $cost_price, $selling_price, $stock_quantity,
                        $min_stock_level, $rack_number, $box_number, $composition, $manufacturer, 
                        $requires_prescription, $schedule_type, $is_narcotic, $max_quantity_per_prescription,
                        $hsn_code, $gst_rate
                    );
                    
                    if ($stmt->execute()) {
                        $success_message = "Medicine added successfully!";
                        // Clear form
                        echo "<script>
                            setTimeout(function(){ 
                                document.getElementById('medicineForm').reset();
                                // Reset expiry date
                                const twoYearsFromNow = new Date();
                                twoYearsFromNow.setFullYear(twoYearsFromNow.getFullYear() + 2);
                                const defaultExpiry = twoYearsFromNow.toISOString().split('T')[0];
                                document.getElementById('expiry_date').value = defaultExpiry;
                            }, 1000);
                        </script>";
                    } else {
                        $error_message = "Error adding medicine: " . $conn->error;
                    }
                }
            }
        }
    }
}
?>

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

<?php if (!$medicines_table_exists): ?>
                    <div class="alert alert-info alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-information me-2"></i>
                        <strong>Note:</strong> The medicines table will be created automatically when you add your first medicine.
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Medicine Information</h4>
                                
                                <form method="POST" action="" id="medicineForm">
                                    <div class="row">
                                        
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="medicine_name" class="form-label">Medicine Name <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="medicine_name" name="medicine_name" placeholder="Enter medicine name" required>
                                            </div>
                                            
                                            <div class="mb-3">
                                                <label for="generic_name" class="form-label">Generic Name</label>
                                                <input type="text" class="form-control" id="generic_name" name="generic_name" placeholder="Enter generic name">
                                            </div>
                                            
                                            <div class="mb-3">
                                                <label for="category_id" class="form-label">Category <span class="text-danger">*</span></label>
                                                <select class="form-select" id="category_id" name="category_id" required>
                                                    <option value="">Select Category</option>
                                                    <?php if ($categories_result && $categories_result->num_rows > 0): ?>
                                                        <?php while ($category = $categories_result->fetch_assoc()): ?>
                                                            <option value="<?php echo $category['id']; ?>"><?php echo htmlspecialchars($category['category_name']); ?></option>
                                                        <?php endwhile; ?>
                                                    <?php else: ?>
                                                        <option value="" disabled>No categories found. Please add categories first.</option>
                                                    <?php endif; ?>
                                                </select>
                                            </div>
                                            
                                            <div class="mb-3">
                                                <label for="composition" class="form-label">Composition</label>
                                                <textarea class="form-control" id="composition" name="composition" rows="2" placeholder="Enter medicine composition"></textarea>
                                            </div>
                                            
                                            <div class="mb-3">
                                                <label for="manufacturer" class="form-label">Manufacturer</label>
                                                <input type="text" class="form-control" id="manufacturer" name="manufacturer" placeholder="Enter manufacturer name">
                                            </div>
                                        </div>
                                        
                                        
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="batch_number" class="form-label">Batch Number <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="batch_number" name="batch_number" placeholder="Enter batch number" required>
                                            </div>
                                            
                                            <div class="mb-3">
                                                <label for="expiry_date" class="form-label">Expiry Date <span class="text-danger">*</span></label>
                                                <input type="date" class="form-control" id="expiry_date" name="expiry_date" required>
                                            </div>
                                            
                                            <div class="mb-3">
                                                <label for="supplier_id" class="form-label">Supplier</label>
                                                <select class="form-select" id="supplier_id" name="supplier_id">
                                                    <option value="">Select Supplier</option>
                                                    <?php if ($suppliers_result && $suppliers_result->num_rows > 0): ?>
                                                        <?php while ($supplier = $suppliers_result->fetch_assoc()): ?>
                                                            <option value="<?php echo $supplier['id']; ?>"><?php echo htmlspecialchars($supplier['supplier_name']); ?></option>
                                                        <?php endwhile; ?>
                                                    <?php else: ?>
                                                        <option value="" disabled>No suppliers found.</option>
                                                    <?php endif; ?>
                                                </select>
                                            </div>
                                            
                                            
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <div class="mb-3">
                                                        <label for="rack_number" class="form-label">Rack Number</label>
                                                        <input type="text" class="form-control" id="rack_number" name="rack_number" placeholder="e.g., R01, Rack-A">
                                                        <small class="text-muted">Where this medicine is stored</small>
                                                    </div>
                                                </div>
                                                <div class="col-md-6">
                                                    <div class="mb-3">
                                                        <label for="box_number" class="form-label">Box Number</label>
                                                        <input type="text" class="form-control" id="box_number" name="box_number" placeholder="e.g., B01, Box-1">
                                                        <small class="text-muted">Specific box/shelf location</small>
                                                    </div>
                                                </div>
                                            </div>
                                            
                                            
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <div class="mb-3">
                                                        <label for="schedule_type" class="form-label">Schedule Type</label>
                                                        <select class="form-select" id="schedule_type" name="schedule_type">
                                                            <option value="G" selected>G - General</option>
                                                            <option value="H">H - Prescription</option>
                                                            <option value="H1">H1 - Schedule H1</option>
                                                            <option value="X">X - Schedule X</option>
                                                            <option value="NARCOTIC">Narcotic</option>
                                                            <option value="OTHER">Other</option>
                                                        </select>
                                                        <small class="text-muted">Auto-detected from medicine name</small>
                                                    </div>
                                                </div>
                                                <div class="col-md-6">
                                                    <div class="mb-3">
                                                        <label for="max_quantity_per_prescription" class="form-label">Max Qty per Prescription</label>
                                                        <input type="number" class="form-control" id="max_quantity_per_prescription" name="max_quantity_per_prescription" min="1" placeholder="Leave empty for no limit">
                                                    </div>
                                                </div>
                                            </div>
                                            
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <div class="mb-3">
                                                        <div class="form-check">
                                                            <input class="form-check-input" type="checkbox" id="requires_prescription" name="requires_prescription" value="1" checked>
                                                            <label class="form-check-label" for="requires_prescription">
                                                                Requires Prescription
                                                            </label>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="col-md-6">
                                                    <div class="mb-3">
                                                        <div class="form-check">
                                                            <input class="form-check-input" type="checkbox" id="is_narcotic" name="is_narcotic" value="1">
                                                            <label class="form-check-label" for="is_narcotic">
                                                                Is Narcotic Drug
                                                            </label>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <hr>
                                    
                                    
                                    <h5 class="mb-3">Pricing Information</h5>
                                    <div class="row">
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="cost_price" class="form-label">Cost Price <span class="text-danger">*</span></label>
                                                <div class="input-group">
                                                    <span class="input-group-text">₹</span>
                                                    <input type="number" class="form-control" id="cost_price" name="cost_price" step="0.01" min="0" placeholder="0.00" required>
                                                </div>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="mrp" class="form-label">MRP <span class="text-danger">*</span></label>
                                                <div class="input-group">
                                                    <span class="input-group-text">₹</span>
                                                    <input type="number" class="form-control" id="mrp" name="mrp" step="0.01" min="0" placeholder="0.00" required>
                                                </div>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="selling_price" class="form-label">Selling Price</label>
                                                <div class="input-group">
                                                    <span class="input-group-text">₹</span>
                                                    <input type="number" class="form-control" id="selling_price" name="selling_price" step="0.01" min="0" placeholder="0.00">
                                                </div>
                                                <small class="text-muted">Leave empty to use MRP as selling price</small>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <hr>
                                    
                                    
                                    <h5 class="mb-3">Stock & Tax Information</h5>
                                    <div class="row">
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label for="stock_quantity" class="form-label">Stock Quantity</label>
                                                <input type="number" class="form-control" id="stock_quantity" name="stock_quantity" min="0" value="0">
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label for="min_stock_level" class="form-label">Minimum Stock Level</label>
                                                <input type="number" class="form-control" id="min_stock_level" name="min_stock_level" min="1" value="10">
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label for="hsn_code" class="form-label">HSN Code</label>
                                                <input type="text" class="form-control" id="hsn_code" name="hsn_code" placeholder="Enter HSN code">
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label for="gst_rate" class="form-label">GST Rate (%)</label>
                                                <div class="input-group">
                                                    <input type="number" class="form-control" id="gst_rate" name="gst_rate" step="0.01" min="0" max="100" value="0" placeholder="0.00">
                                                    <span class="input-group-text">%</span>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row mt-4">
                                        <div class="col-12">
                                            <div class="text-end">
                                                <button type="button" class="btn btn-secondary me-2" onclick="clearForm()">Clear Form</button>
                                                <button type="submit" name="add_medicine" class="btn btn-primary">Add Medicine</button>
                                            </div>
                                        </div>
                                    </div>
                                </form>
                            </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: add-medicine.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation