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

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

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

// Get medicine ID from URL
$medicine_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

if ($medicine_id <= 0) {
    header('Location: medicines-list.php');
    exit();
}

// Fetch medicine details
$medicine_query = "
    SELECT m.*, c.category_name, s.supplier_name
    FROM medicines m 
    LEFT JOIN medicine_categories c ON m.category_id = c.id 
    LEFT JOIN suppliers s ON m.supplier_id = s.id
    WHERE m.id = ?
";

$stmt = $conn->prepare($medicine_query);
if (!$stmt) {
    die("Prepare failed: " . $conn->error);
}
$stmt->bind_param("i", $medicine_id);
$stmt->execute();
$medicine_result = $stmt->get_result();

if ($medicine_result->num_rows == 0) {
    header('Location: medicines-list.php?error=Medicine not found');
    exit();
}

$medicine = $medicine_result->fetch_assoc();

// 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
$suppliers_result = $conn->query("SELECT id, supplier_name FROM suppliers WHERE status = 'active' ORDER BY supplier_name");

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['update_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']) && $_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.0;
        $cost_price = isset($_POST['cost_price']) ? floatval($_POST['cost_price']) : 0.0;
        $selling_price = (isset($_POST['selling_price']) && $_POST['selling_price'] !== '') ? floatval($_POST['selling_price']) : 0.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']) && $_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']) && $_POST['gst_rate'] !== '' ? floatval($_POST['gst_rate']) : 0.0;
        $status = isset($_POST['status']) ? $_POST['status'] : 'active';
        
        // Validate required fields
        $errors = [];
        
        if (empty($medicine_name)) {
            $errors[] = "Medicine name is required!";
        }
        
        if ($category_id == 0) {
            $errors[] = "Category is required!";
        }
        
        if (empty($batch_number)) {
            $errors[] = "Batch number is required!";
        }
        
        if (empty($expiry_date)) {
            $errors[] = "Expiry date is required!";
        }
        
        if ($mrp <= 0) {
            $errors[] = "MRP must be greater than 0!";
        }
        
        if ($cost_price <= 0) {
            $errors[] = "Cost price must be greater than 0!";
        }
        
        // Check if MRP is less than cost price
        if ($mrp < $cost_price) {
            $errors[] = "MRP cannot be less than cost price!";
        }
        
        // Check expiry date
        try {
            $expiry_date_obj = new DateTime($expiry_date);
            $today = new DateTime();
            $today->setTime(0,0,0);
            if ($expiry_date_obj <= $today) {
                $errors[] = "Expiry date must be in the future!";
            }
        } catch (Exception $e) {
            $errors[] = "Invalid expiry date format!";
        }
        
        // If schedule is H1, X, or NARCOTIC, ensure prescription is required
        if (($schedule_type === 'H1' || $schedule_type === 'X' || $schedule_type === 'NARCOTIC') && !$requires_prescription) {
            $requires_prescription = 1;
        }
        
        if (empty($errors)) {
            // Check if batch number already exists (excluding current medicine)
            $check_stmt = $conn->prepare("SELECT id FROM medicines WHERE batch_number = ? AND id != ?");
            if (!$check_stmt) {
                $error_message = "Prepare failed (check batch): " . $conn->error;
            } else {
                $check_stmt->bind_param("si", $batch_number, $medicine_id);
                $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 or zero
                    if ($selling_price <= 0) {
                        $selling_price = $mrp;
                    }
                    
                    // Prepare the update statement - CORRECTED VERSION
                    $update_sql = "UPDATE medicines SET 
                        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 = ?,
                        status = ?,
                        updated_at = CURRENT_TIMESTAMP
                        WHERE id = ?
                    ";
                    
                    $update_stmt = $conn->prepare($update_sql);
                    if (!$update_stmt) {
                        $error_message = "Prepare failed (update): " . $conn->error;
                    } else {
                        // Type string — 23 parameters:
                        // 1 s  medicine_name
                        // 2 s  generic_name
                        // 3 i  category_id
                        // 4 i  supplier_id (nullable)
                        // 5 s  batch_number
                        // 6 s  expiry_date
                        // 7 d  mrp
                        // 8 d  cost_price
                        // 9 d  selling_price
                        // 10 i stock_quantity
                        // 11 i min_stock_level
                        // 12 s rack_number
                        // 13 s box_number
                        // 14 s composition
                        // 15 s manufacturer
                        // 16 i requires_prescription
                        // 17 s schedule_type
                        // 18 i is_narcotic
                        // 19 i max_quantity_per_prescription (nullable)
                        // 20 s hsn_code
                        // 21 d gst_rate
                        // 22 s status
                        // 23 i medicine_id
                        $types = 'ssiissdddiissssisiisdsi';
                        
                        // Ensure variables exist for binding (mysqli requires variables)
                        // supplier_id and max_quantity_per_prescription may be null — that's OK
                        if ($update_stmt->bind_param(
                            $types,
                            $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,
                            $status,
                            $medicine_id
                        )) {
                            if ($update_stmt->execute()) {
                                $success_message = "Medicine updated successfully!";
                                // Refresh medicine data
                                $stmt = $conn->prepare($medicine_query);
                                if ($stmt) {
                                    $stmt->bind_param("i", $medicine_id);
                                    $stmt->execute();
                                    $medicine_result = $stmt->get_result();
                                    $medicine = $medicine_result->fetch_assoc();
                                }
                            } else {
                                $error_message = "Error updating medicine: " . $update_stmt->error;
                                $error_message .= "<br>SQL Error: " . $conn->error;
                            }
                        } else {
                            $error_message = "Error binding parameters: " . $update_stmt->error;
                        }
                        
                        $update_stmt->close();
                    }
                }
                $check_stmt->close();
            }
        } else {
            $error_message = implode("<br>", $errors);
        }
    }
}
?>

<!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">

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Edit Medicine</h4>
                            <div class="page-title-right">
                                <a href="medicine-details.php?id=<?php echo $medicine_id; ?>" class="btn btn-secondary me-2">
                                    <i class="mdi mdi-arrow-left me-1"></i> View Details
                                </a>
                                <a href="medicines-list.php" class="btn btn-outline-secondary">
                                    <i class="mdi mdi-view-list me-1"></i> Back to List
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

<?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>
                    <script>
                        setTimeout(function() {
                            window.location.href = 'medicine-details.php?id=<?php echo $medicine_id; ?>';
                        }, 2000);
                    </script>
                <?php endif; ?>
                
                <?php if (isset($error_message)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-block-helper me-2"></i>
                        <?php echo $error_message; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <form method="POST" action="" id="medicineForm">
                                    <div class="row">
                                        
                                        <div class="col-md-6">
                                            <h5 class="mb-3">Basic Information</h5>
                                            
                                            <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" 
                                                       value="<?php echo htmlspecialchars($medicine['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" 
                                                       value="<?php echo htmlspecialchars($medicine['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 $medicine['category_id'] == $category['id'] ? 'selected' : ''; ?>>
                                                                <?php echo htmlspecialchars($category['category_name']); ?>
                                                            </option>
                                                        <?php endwhile; ?>
                                                    <?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"><?php echo htmlspecialchars($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" 
                                                       value="<?php echo htmlspecialchars($medicine['manufacturer']); ?>">
                                            </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 $medicine['supplier_id'] == $supplier['id'] ? 'selected' : ''; ?>>
                                                                <?php echo htmlspecialchars($supplier['supplier_name']); ?>
                                                            </option>
                                                        <?php endwhile; ?>
                                                    <?php endif; ?>
                                                </select>
                                            </div>
                                        </div>
                                        
                                        
                                        <div class="col-md-6">
                                            <h5 class="mb-3">Batch & Storage Information</h5>
                                            
                                            <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" 
                                                       value="<?php echo htmlspecialchars($medicine['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" 
                                                       value="<?php echo $medicine['expiry_date']; ?>" required>
                                            </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" 
                                                               value="<?php echo htmlspecialchars($medicine['rack_number']); ?>" placeholder="e.g., R01, Rack-A">
                                                    </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" 
                                                               value="<?php echo htmlspecialchars($medicine['box_number']); ?>" placeholder="e.g., B01, Box-1">
                                                    </div>
                                                </div>
                                            </div>
                                            
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <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" 
                                                               value="<?php echo $medicine['stock_quantity']; ?>" min="0">
                                                    </div>
                                                </div>
                                                <div class="col-md-6">
                                                    <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" 
                                                               value="<?php echo $medicine['min_stock_level']; ?>" min="1">
                                                    </div>
                                                </div>
                                            </div>
                                            
                                            
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <div class="mb-3">
                                                        <label for="schedule_type" class="form-label">Schedule Type <span class="text-danger">*</span></label>
                                                        <select class="form-select" id="schedule_type" name="schedule_type" required>
                                                            <option value="G" <?php echo ($medicine['schedule_type'] == 'G' || empty($medicine['schedule_type'])) ? 'selected' : ''; ?>>G - General</option>
                                                            <option value="H" <?php echo $medicine['schedule_type'] == 'H' ? 'selected' : ''; ?>>H - Prescription</option>
                                                            <option value="H1" <?php echo $medicine['schedule_type'] == 'H1' ? 'selected' : ''; ?>>H1 - Schedule H1</option>
                                                            <option value="X" <?php echo $medicine['schedule_type'] == 'X' ? 'selected' : ''; ?>>X - Schedule X</option>
                                                            <option value="NARCOTIC" <?php echo $medicine['schedule_type'] == 'NARCOTIC' ? 'selected' : ''; ?>>Narcotic</option>
                                                            <option value="OTHER" <?php echo $medicine['schedule_type'] == 'OTHER' ? 'selected' : ''; ?>>Other</option>
                                                        </select>
                                                        <?php if (empty($medicine['schedule_type'])): ?>
                                                            <div class="text-warning mt-1">
                                                                <small><i class="mdi mdi-alert"></i> Current value is empty. Please select a schedule type.</small>
                                                            </div>
                                                        <?php endif; ?>
                                                    </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" 
                                                               value="<?php echo $medicine['max_quantity_per_prescription']; ?>" min="1" placeholder="Leave empty for no limit">
                                                    </div>
                                                </div>
                                            </div>
                                            
                                            
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="mb-3">
                                                        <div class="form-check">
                                                            <input class="form-check-input" type="checkbox" id="requires_prescription" name="requires_prescription" value="1"
                                                                   <?php echo $medicine['requires_prescription'] ? 'checked' : ''; ?>>
                                                            <label class="form-check-label" for="requires_prescription">
                                                                Requires Prescription
                                                            </label>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="col-md-4">
                                                    <div class="mb-3">
                                                        <div class="form-check">
                                                            <input class="form-check-input" type="checkbox" id="is_narcotic" name="is_narcotic" value="1"
                                                                   <?php echo $medicine['is_narcotic'] ? 'checked' : ''; ?>>
                                                            <label class="form-check-label" for="is_narcotic">
                                                                Is Narcotic Drug
                                                            </label>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="col-md-4">
                                                    <div class="mb-3">
                                                        <label for="status" class="form-label">Status</label>
                                                        <select class="form-select" id="status" name="status">
                                                            <option value="active" <?php echo $medicine['status'] == 'active' ? 'selected' : ''; ?>>Active</option>
                                                            <option value="inactive" <?php echo $medicine['status'] == 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <hr>
                                    
                                    
                                    <h5 class="mb-3">Pricing Information</h5>
                                    <div class="row">
                                        <div class="col-md-3">
                                            <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.01" 
                                                           value="<?php echo $medicine['cost_price']; ?>" required>
                                                </div>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-3">
                                            <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.01" 
                                                           value="<?php echo $medicine['mrp']; ?>" required>
                                                </div>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-3">
                                            <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"
                                                           value="<?php echo $medicine['selling_price']; ?>">
                                                </div>
                                                <small class="text-muted">Leave empty to use MRP as selling price</small>
                                            </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="<?php echo $medicine['gst_rate']; ?>" placeholder="0.00">
                                                    <span class="input-group-text">%</span>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <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" 
                                                       value="<?php echo htmlspecialchars($medicine['hsn_code']); ?>" placeholder="Enter HSN code">
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label class="form-label">Calculated Margin</label>
                                                <div class="input-group">
                                                    <span class="input-group-text">%</span>
                                                    <input type="text" class="form-control" id="calculated_margin" readonly>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="row mt-4">
                                        <div class="col-md-6">
                                            <div class="card bg-light">
                                                <div class="card-body">
                                                    <h6 class="card-title">Audit Information</h6>
                                                    <table class="table table-sm table-borderless">
                                                        <tr>
                                                            <td width="40%">Created At:</td>
                                                            <td><?php echo date('d M Y H:i:s', strtotime($medicine['created_at'])); ?></td>
                                                        </tr>
                                                        <tr>
                                                            <td>Last Updated:</td>
                                                            <td><?php echo date('d M Y H:i:s', strtotime($medicine['updated_at'])); ?></td>
                                                        </tr>
                                                        <tr>
                                                            <td>Current Stock Value:</td>
                                                            <td>
                                                                <strong>₹<?php echo number_format($medicine['stock_quantity'] * $medicine['cost_price'], 2); ?></strong>
                                                                (Cost)
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>Current Schedule Type:</td>
                                                            <td>
                                                                <?php if (empty($medicine['schedule_type'])): ?>
                                                                    <span class="badge bg-warning">Not Set</span>
                                                                <?php else: ?>
                                                                    <span class="badge bg-info"><?php echo $medicine['schedule_type']; ?></span>
                                                                <?php endif; ?>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="card bg-light">
                                                <div class="card-body">
                                                    <h6 class="card-title">Quick Actions</h6>
                                                    <div class="d-grid gap-2">
                                                        <button type="button" class="btn btn-outline-primary" onclick="calculateAutoPrices()">
                                                            <i class="mdi mdi-calculator me-1"></i> Calculate Prices
                                                        </button>
                                                        <button type="button" class="btn btn-outline-warning" onclick="resetToDefaults()">
                                                            <i class="mdi mdi-refresh me-1"></i> Reset Changes
                                                        </button>
                                                        <button type="button" class="btn btn-outline-danger" onclick="showDeleteConfirm()">
                                                            <i class="mdi mdi-delete me-1"></i> Delete Medicine
                                                        </button>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row mt-4">
                                        <div class="col-12">
                                            <div class="text-end">
                                                <a href="medicine-details.php?id=<?php echo $medicine_id; ?>" class="btn btn-secondary me-2">Cancel</a>
                                                <button type="submit" name="update_medicine" class="btn btn-primary">Update 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: edit-medicine.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation