Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/vkmobiles/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: inventory-purchase.php

<?php
session_start();
// Include database connection
include('includes/db.php');

// Check if user is logged in as branch
if (!isset($_SESSION['branch_id'])) {
    header("Location: login.php");
    exit();
}

// Get branch ID from session
$branch_id = $_SESSION['branch_id'];

// Get branch info for display
$branch_sql = "SELECT branch_name, branch_code FROM branches WHERE id = $branch_id";
$branch_result = $conn->query($branch_sql);
$branch_info = $branch_result->fetch_assoc();

// Initialize notification variables
$notification = array(
    'type' => '', // success, danger, warning, info
    'message' => '',
    'icon' => '',
    'title' => ''
);

// Handle purchase order status update
if (isset($_POST['update_po_status'])) {
    $po_id = intval($_POST['po_id']);
    $status = $conn->real_escape_string($_POST['status']);
    
    // Verify the purchase order belongs to the user's branch
    $verify_sql = "SELECT id FROM purchase_orders WHERE id = $po_id AND branch_id = $branch_id";
    $verify_result = $conn->query($verify_sql);
    
    if ($verify_result->num_rows > 0) {
        $sql = "UPDATE purchase_orders SET status = '$status' WHERE id = $po_id";
        
        if ($conn->query($sql) === TRUE) {
            // If status is completed, update stock for the branch
            if ($status == 'completed') {
                $items_sql = "SELECT poi.product_id, poi.quantity 
                             FROM purchase_order_items poi
                             WHERE poi.purchase_order_id = $po_id";
                $items_result = $conn->query($items_sql);
                
                while ($item = $items_result->fetch_assoc()) {
                    // Verify product belongs to the same branch
                    $product_verify = "SELECT id FROM products WHERE id = {$item['product_id']} AND branch_id = $branch_id";
                    $product_result = $conn->query($product_verify);
                    
                    if ($product_result->num_rows > 0) {
                        $update_stock_sql = "UPDATE products SET stock_quantity = stock_quantity + {$item['quantity']} 
                                             WHERE id = {$item['product_id']} AND branch_id = $branch_id";
                        $conn->query($update_stock_sql);
                    }
                }
            }
            
            $notification = array(
                'type' => 'success',
                'message' => 'Purchase Order status updated successfully!',
                'icon' => 'fa-check-circle',
                'title' => 'Success!'
            );
            
            // Refresh page to show updated status
            header("Location: inventory-purchase.php?status_updated=1");
            exit();
        } else {
            $notification = array(
                'type' => 'danger',
                'message' => 'Error updating purchase order: ' . $conn->error,
                'icon' => 'fa-exclamation-triangle',
                'title' => 'Error!'
            );
        }
    } else {
        $notification = array(
            'type' => 'danger',
            'message' => 'Purchase order not found in your branch!',
            'icon' => 'fa-exclamation-triangle',
            'title' => 'Error!'
        );
    }
}

// Handle delete purchase order
if (isset($_GET['delete_po'])) {
    $po_id = intval($_GET['delete_po']);
    
    // First verify the purchase order belongs to the user's branch and is pending
    $verify_sql = "SELECT id, status, po_number FROM purchase_orders WHERE id = $po_id AND branch_id = $branch_id";
    $verify_result = $conn->query($verify_sql);
    
    if ($verify_result->num_rows > 0) {
        $order = $verify_result->fetch_assoc();
        
        if ($order['status'] == 'pending') {
            // Start transaction to ensure all deletions are successful
            $conn->begin_transaction();
            
            try {
                // First delete purchase order items
                $delete_items_sql = "DELETE FROM purchase_order_items WHERE purchase_order_id = $po_id";
                if (!$conn->query($delete_items_sql)) {
                    throw new Exception("Error deleting purchase order items: " . $conn->error);
                }
                
                // Then delete the purchase order
                $delete_po_sql = "DELETE FROM purchase_orders WHERE id = $po_id";
                if (!$conn->query($delete_po_sql)) {
                    throw new Exception("Error deleting purchase order: " . $conn->error);
                }
                
                // Commit transaction
                $conn->commit();
                
                $notification = array(
                    'type' => 'success',
                    'message' => 'Purchase Order #' . $order['po_number'] . ' deleted successfully!',
                    'icon' => 'fa-check-circle',
                    'title' => 'Success!'
                );
                
                // Redirect to clear GET parameter
                header("Location: inventory-purchase.php?deleted=1");
                exit();
                
            } catch (Exception $e) {
                // Rollback transaction on error
                $conn->rollback();
                $notification = array(
                    'type' => 'danger',
                    'message' => 'Error deleting purchase order: ' . $e->getMessage(),
                    'icon' => 'fa-exclamation-triangle',
                    'title' => 'Error!'
                );
            }
        } else {
            $notification = array(
                'type' => 'warning',
                'message' => 'Cannot delete purchase order #' . $order['po_number'] . '. Only pending orders can be deleted from your branch!',
                'icon' => 'fa-exclamation-circle',
                'title' => 'Warning!'
            );
        }
    } else {
        $notification = array(
            'type' => 'danger',
            'message' => 'Purchase order not found in your branch or you don\'t have permission to delete it!',
            'icon' => 'fa-exclamation-triangle',
            'title' => 'Error!'
        );
    }
}

// Check for success redirects and show appropriate notifications
if (isset($_GET['status_updated'])) {
    $notification = array(
        'type' => 'success',
        'message' => 'Purchase Order status updated successfully!',
        'icon' => 'fa-check-circle',
        'title' => 'Success!'
    );
}

if (isset($_GET['deleted'])) {
    $notification = array(
        'type' => 'success',
        'message' => 'Purchase Order deleted successfully!',
        'icon' => 'fa-check-circle',
        'title' => 'Success!'
    );
}
?>

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

<?php 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">

<?php if (!empty($notification['type'])): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="alert alert-<?php echo $notification['type']; ?> alert-dismissible fade show" role="alert">
                            <div class="d-flex align-items-center">
                                <div class="flex-shrink-0">
                                    <i class="fas <?php echo $notification['icon']; ?> fa-2x me-3"></i>
                                </div>
                                <div class="flex-grow-1">
                                    <h5 class="alert-heading mb-1"><?php echo $notification['title']; ?></h5>
                                    <p class="mb-0"><?php echo $notification['message']; ?></p>
                                </div>
                            </div>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

<div class="branch-info">
                    <div class="row align-items-center">
                        <div class="col-md-8">
                            <h4 class="mb-1">
                                <i class="fas fa-store-alt me-2"></i>
                                <?php echo htmlspecialchars($branch_info['branch_name']); ?>
                                <span class="badge bg-primary"><?php echo $branch_info['branch_code']; ?></span>
                            </h4>
                            <p class="text-muted mb-0">
                                <i class="fas fa-info-circle me-1"></i>
                                Viewing purchase orders for your branch only
                            </p>
                        </div>
                        <div class="col-md-4 text-end">
                            <a href="inventory-purchase-add.php" class="btn btn-primary">
                                <i class="fas fa-plus-circle me-2"></i>New Purchase Order
                            </a>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_po_sql = "SELECT COUNT(*) as total FROM purchase_orders WHERE branch_id = $branch_id";
                                            echo $conn->query($total_po_sql)->fetch_assoc()['total'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Branch Orders</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-store display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small><i class="fas fa-info-circle me-1"></i> Your branch only</small>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $pending_sql = "SELECT COUNT(*) as pending FROM purchase_orders WHERE branch_id = $branch_id AND status = 'pending'";
                                            echo $conn->query($pending_sql)->fetch_assoc()['pending'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Pending</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-clock display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small><i class="fas fa-exclamation-triangle me-1"></i> Awaiting delivery</small>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $shipped_sql = "SELECT COUNT(*) as shipped FROM purchase_orders WHERE branch_id = $branch_id AND status = 'shipped'";
                                            echo $conn->query($shipped_sql)->fetch_assoc()['shipped'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Shipped</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-shipping-fast display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small><i class="fas fa-truck me-1"></i> In transit to your branch</small>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $completed_sql = "SELECT COUNT(*) as completed FROM purchase_orders WHERE branch_id = $branch_id AND status = 'completed'";
                                            echo $conn->query($completed_sql)->fetch_assoc()['completed'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Completed</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-check-circle display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small><i class="fas fa-box me-1"></i> In branch inventory</small>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="row text-center">
                                    <div class="col-md-4">
                                        <?php
                                        $total_value_sql = "SELECT SUM(total_amount) as total_value FROM purchase_orders WHERE branch_id = $branch_id AND status IN ('completed', 'shipped')";
                                        $total_value_result = $conn->query($total_value_sql);
                                        $total_value = $total_value_result->fetch_assoc()['total_value'] ?? 0;
                                        ?>
                                        <h4 class="text-primary">₹<?php echo number_format($total_value, 2); ?></h4>
                                        <p class="text-muted mb-0">Total Purchase Value</p>
                                        <small class="text-muted"><i class="fas fa-store"></i> Your branch</small>
                                    </div>
                                    <div class="col-md-4">
                                        <?php
                                        $avg_order_sql = "SELECT AVG(total_amount) as avg_order FROM purchase_orders WHERE branch_id = $branch_id";
                                        $avg_order_result = $conn->query($avg_order_sql);
                                        $avg_order = $avg_order_result->fetch_assoc()['avg_order'] ?? 0;
                                        ?>
                                        <h4 class="text-success">₹<?php echo number_format($avg_order, 2); ?></h4>
                                        <p class="text-muted mb-0">Average Order Value</p>
                                        <small class="text-muted"><i class="fas fa-chart-line"></i> Branch average</small>
                                    </div>
                                    <div class="col-md-4">
                                        <?php
                                        $last_order_sql = "SELECT MAX(order_date) as last_order FROM purchase_orders WHERE branch_id = $branch_id";
                                        $last_order_result = $conn->query($last_order_sql);
                                        $last_order = $last_order_result->fetch_assoc()['last_order'];
                                        ?>
                                        <h4 class="text-info">
                                            <?php echo $last_order ? date('M j, Y', strtotime($last_order)) : 'Never'; ?>
                                        </h4>
                                        <p class="text-muted mb-0">Last Order Date</p>
                                        <small class="text-muted"><i class="fas fa-calendar"></i> Most recent PO</small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <h5 class="card-title mb-0">Branch Purchase Orders</h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <a href="inventory-purchase-add.php" class="btn btn-success">
                                            <i class="fas fa-plus-circle me-2"></i>New Purchase Order
                                        </a>
                                        <a href="inventory-suppliers.php" class="btn btn-outline-primary">
                                            <i class="fas fa-truck me-2"></i>Manage Suppliers
                                        </a>
                                        <a href="reports-purchases.php" class="btn btn-outline-info">
                                            <i class="fas fa-chart-bar me-2"></i>Branch Reports
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-3">
                                    <div class="col-md-3">
                                        <div class="input-group">
                                            <input type="text" class="form-control" id="searchInput" placeholder="Search PO number..." value="<?php echo isset($_GET['search']) ? htmlspecialchars($_GET['search']) : ''; ?>">
                                            <button class="btn btn-outline-secondary" type="button" id="searchButton">
                                                <i class="fas fa-search"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <select class="form-select" id="statusFilter">
                                            <option value="">All Status</option>
                                            <option value="pending" <?php echo (isset($_GET['status']) && $_GET['status'] == 'pending') ? 'selected' : ''; ?>>Pending</option>
                                            <option value="shipped" <?php echo (isset($_GET['status']) && $_GET['status'] == 'shipped') ? 'selected' : ''; ?>>Shipped</option>
                                            <option value="completed" <?php echo (isset($_GET['status']) && $_GET['status'] == 'completed') ? 'selected' : ''; ?>>Completed</option>
                                            <option value="cancelled" <?php echo (isset($_GET['status']) && $_GET['status'] == 'cancelled') ? 'selected' : ''; ?>>Cancelled</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <select class="form-select" id="supplierFilter">
                                            <option value="">All Suppliers</option>
                                            <?php
                                            $supplier_sql = "SELECT * FROM suppliers WHERE status = 'active' ORDER BY name";
                                            $supplier_result = $conn->query($supplier_sql);
                                            while($supplier = $supplier_result->fetch_assoc()) {
                                                $selected = (isset($_GET['supplier']) && $_GET['supplier'] == $supplier['id']) ? 'selected' : '';
                                                echo '<option value="' . $supplier['id'] . '" ' . $selected . '>' . htmlspecialchars($supplier['name']) . '</option>';
                                            }
                                            ?>
                                        </select>
                                        <div class="form-text">Suppliers are shared across branches</div>
                                    </div>
                                    <div class="col-md-3">
                                        <input type="date" class="form-control" id="dateFilter" placeholder="Filter by date" value="<?php echo isset($_GET['date']) ? htmlspecialchars($_GET['date']) : ''; ?>">
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table class="table table-bordered table-hover mb-0" id="purchaseOrdersTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th>PO Number</th>
                                                <th>Supplier</th>
                                                <th>Order Date</th>
                                                <th>Expected Date</th>
                                                <th>Items</th>
                                                <th>Total Amount</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Build query with filters - Only show orders from this branch
                                            $where_conditions = ["po.branch_id = $branch_id"];

// Status filter
                                            if (isset($_GET['status']) && !empty($_GET['status'])) {
                                                $where_conditions[] = "po.status = '" . $conn->real_escape_string($_GET['status']) . "'";
                                            }

// Supplier filter
                                            if (isset($_GET['supplier']) && !empty($_GET['supplier'])) {
                                                $where_conditions[] = "po.supplier_id = " . intval($_GET['supplier']);
                                            }

// Date filter
                                            if (isset($_GET['date']) && !empty($_GET['date'])) {
                                                $where_conditions[] = "DATE(po.order_date) = '" . $conn->real_escape_string($_GET['date']) . "'";
                                            }

// Search filter
                                            if (isset($_GET['search']) && !empty($_GET['search'])) {
                                                $search = $conn->real_escape_string($_GET['search']);
                                                $where_conditions[] = "(po.po_number LIKE '%$search%' OR s.name LIKE '%$search%')";
                                            }

$where_sql = "WHERE " . implode(" AND ", $where_conditions);

// Main query - Only orders from this branch
                                            $sql = "SELECT po.*, s.name as supplier_name, 
                                                   (SELECT COUNT(*) FROM purchase_order_items WHERE purchase_order_id = po.id) as item_count
                                                   FROM purchase_orders po 
                                                   LEFT JOIN suppliers s ON po.supplier_id = s.id 
                                                   $where_sql 
                                                   ORDER BY po.order_date DESC, po.id DESC 
                                                   LIMIT 50";
                                            
                                            $result = $conn->query($sql);

if ($result->num_rows > 0) {
                                                $grand_total = 0;
                                                while($order = $result->fetch_assoc()) {
                                                    // Status badge
                                                    $status_badge = '';
                                                    switch($order['status']) {
                                                        case 'pending':
                                                            $status_badge = '<span class="badge bg-warning"><i class="fas fa-clock me-1"></i>Pending</span>';
                                                            break;
                                                        case 'shipped':
                                                            $status_badge = '<span class="badge bg-info"><i class="fas fa-shipping-fast me-1"></i>Shipped</span>';
                                                            break;
                                                        case 'completed':
                                                            $status_badge = '<span class="badge bg-success"><i class="fas fa-check-circle me-1"></i>Completed</span>';
                                                            break;
                                                        case 'cancelled':
                                                            $status_badge = '<span class="badge bg-danger"><i class="fas fa-times-circle me-1"></i>Cancelled</span>';
                                                            break;
                                                    }

// Date formatting
                                                    $order_date = date('M j, Y', strtotime($order['order_date']));
                                                    $expected_date = date('M j, Y', strtotime($order['expected_date']));
                                                    
                                                    // Check if expected date has passed for pending orders
                                                    $date_warning = '';
                                                    if ($order['status'] == 'pending' && strtotime($order['expected_date']) < time()) {
                                                        $date_warning = ' <i class="fas fa-exclamation-triangle text-danger" title="Expected date has passed"></i>';
                                                    }

$grand_total += $order['total_amount'];
                                            ?>
                                            <tr data-status="<?php echo $order['status']; ?>" 
                                                data-supplier="<?php echo $order['supplier_id']; ?>"
                                                data-date="<?php echo $order['order_date']; ?>">
                                                <td>
                                                    <strong class="text-primary"><?php echo $order['po_number']; ?></strong>
                                                    <br><small class="text-muted"><i class="fas fa-store"></i> Branch PO</small>
                                                </td>
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <div class="flex-shrink-0">
                                                            <div class="avatar-xs bg-light rounded">
                                                                <i class="fas fa-truck font-size-13 text-info"></i>
                                                            </div>
                                                        </div>
                                                        <div class="flex-grow-1 ms-2">
                                                            <h6 class="mb-0"><?php echo htmlspecialchars($order['supplier_name']); ?></h6>
                                                            <small class="text-muted">Shared supplier</small>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <small><?php echo $order_date; ?></small>
                                                </td>
                                                <td>
                                                    <small>
                                                        <?php echo $expected_date; ?>
                                                        <?php echo $date_warning; ?>
                                                    </small>
                                                </td>
                                                <td>
                                                    <span class="badge bg-secondary"><?php echo $order['item_count']; ?> items</span>
                                                </td>
                                                <td>
                                                    <strong class="text-success">₹<?php echo number_format($order['total_amount'], 2); ?></strong>
                                                </td>
                                                <td>
                                                    <?php echo $status_badge; ?>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm" role="group">
                                                        <a href="inventory-purchase-view.php?id=<?php echo $order['id']; ?>" class="btn btn-outline-primary" title="View Order">
                                                            <i class="fas fa-eye"></i>
                                                        </a>
                                                        <button type="button" class="btn btn-outline-info update-status-btn" 
                                                                data-bs-toggle="modal" data-bs-target="#updateStatusModal"
                                                                data-po-id="<?php echo $order['id']; ?>"
                                                                data-po-number="<?php echo $order['po_number']; ?>"
                                                                data-current-status="<?php echo $order['status']; ?>"
                                                                title="Update Status">
                                                            <i class="fas fa-edit"></i>
                                                        </button>
                                                        <?php if ($order['status'] == 'pending'): ?>
                                                            <button type="button" 
                                                               class="btn btn-outline-danger delete-btn" 
                                                               data-po-id="<?php echo $order['id']; ?>"
                                                               data-po-number="<?php echo $order['po_number']; ?>"
                                                               title="Delete Order">
                                                                <i class="fas fa-trash"></i>
                                                            </button>
                                                        <?php else: ?>
                                                            <button type="button" class="btn btn-outline-secondary" disabled title="Cannot delete completed orders">
                                                                <i class="fas fa-trash"></i>
                                                            </button>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="8" class="text-center py-4">
                                                    <i class="fas fa-shopping-cart display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Purchase Orders Found</h5>
                                                    <p class="text-muted">No purchase orders found in your branch. Create your first purchase order.</p>
                                                    <a href="inventory-purchase-add.php" class="btn btn-success">
                                                        <i class="fas fa-plus-circle me-2"></i>Create Purchase Order
                                                    </a>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if (isset($grand_total) && $grand_total > 0): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <div class="alert alert-primary">
                                            <div class="d-flex justify-content-between align-items-center">
                                                <div>
                                                    <strong>Total Value of Branch Orders:</strong>
                                                    <br><small class="text-muted"><i class="fas fa-store me-1"></i> Showing only your branch orders</small>
                                                </div>
                                                <h4 class="mb-0 text-dark">₹<?php echo number_format($grand_total, 2); ?></h4>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>

</div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

<div class="modal fade" id="updateStatusModal" tabindex="-1" aria-labelledby="updateStatusModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content">
            <form method="POST" action="">
                <div class="modal-header">
                    <h5 class="modal-title" id="updateStatusModalLabel">Update Purchase Order Status</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-3">
                        <label for="modal-po-number" class="form-label">Purchase Order Number</label>
                        <input type="text" class="form-control" id="modal-po-number" readonly>
                    </div>
                    <input type="hidden" name="po_id" id="modal-po-id">
                    <div class="mb-3">
                        <label for="modal-status" class="form-label">Status <span class="text-danger">*</span></label>
                        <select class="form-select" id="modal-status" name="status" required>
                            <option value="pending">Pending</option>
                            <option value="shipped">Shipped</option>
                            <option value="completed">Completed</option>
                            <option value="cancelled">Cancelled</option>
                        </select>
                    </div>
                    <div class="alert alert-info">
                        <i class="fas fa-info-circle me-2"></i>
                        <small>Changing status to "Completed" will automatically update product stock levels in your branch.</small>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_po_status" class="btn btn-primary">Update Status</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="deleteConfirmModal" tabindex="-1" aria-labelledby="deleteConfirmModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content">
            <div class="modal-header bg-danger text-white">
                <h5 class="modal-title" id="deleteConfirmModalLabel">
                    <i class="fas fa-exclamation-triangle me-2"></i>Confirm Delete
                </h5>
                <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <div class="text-center mb-4">
                    <i class="fas fa-trash-alt fa-4x text-danger"></i>
                </div>
                <h5 class="text-center mb-3">Are you sure you want to delete this Purchase Order?</h5>
                <div class="alert alert-warning">
                    <i class="fas fa-exclamation-circle me-2"></i>
                    <strong>This action cannot be undone!</strong><br>
                    Purchase Order: <strong id="delete-po-number"></strong><br>
                    <small>All items in this order will also be deleted.</small>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">
                    <i class="fas fa-times me-2"></i>Cancel
                </button>
                <button type="button" class="btn btn-danger" id="confirm-delete-btn">
                    <i class="fas fa-trash me-2"></i>Delete Purchase Order
                </button>
            </div>
        </div>
    </div>
</div>

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

// Delete functionality with confirmation modal
    deleteButtons.forEach(button => {
        button.addEventListener('click', function() {
            const poId = this.getAttribute('data-po-id');
            const poNumber = this.getAttribute('data-po-number');
            
            // Update modal content
            document.getElementById('delete-po-number').textContent = poNumber;
            
            // Set up confirm delete button action
            confirmDeleteBtn.onclick = function() {
                window.location.href = `inventory-purchase.php?delete_po=${poId}`;
            };
            
            // Show confirmation modal
            const deleteModal = new bootstrap.Modal(document.getElementById('deleteConfirmModal'));
            deleteModal.show();
        });
    });

// Filter functionality
    const searchInput = document.getElementById('searchInput');
    const searchButton = document.getElementById('searchButton');
    const statusFilter = document.getElementById('statusFilter');
    const supplierFilter = document.getElementById('supplierFilter');
    const dateFilter = document.getElementById('dateFilter');

function applyFilters() {
        const params = new URLSearchParams();
        
        if (statusFilter.value) params.set('status', statusFilter.value);
        if (supplierFilter.value) params.set('supplier', supplierFilter.value);
        if (dateFilter.value) params.set('date', dateFilter.value);
        if (searchInput.value) params.set('search', searchInput.value);
        
        window.location.href = 'inventory-purchase.php?' + params.toString();
    }

searchButton.addEventListener('click', applyFilters);
    searchInput.addEventListener('keypress', function(e) {
        if (e.key === 'Enter') applyFilters();
    });
    
    statusFilter.addEventListener('change', applyFilters);
    supplierFilter.addEventListener('change', applyFilters);
    dateFilter.addEventListener('change', applyFilters);
    
    // Auto-dismiss notifications after 5 seconds
    const alerts = document.querySelectorAll('.alert-dismissible');
    alerts.forEach(alert => {
        setTimeout(() => {
            if (alert) {
                const bsAlert = new bootstrap.Alert(alert);
                bsAlert.close();
            }
        }, 5000);
    });
    
    // Scroll to top to show notification
    <?php if (!empty($notification['type'])): ?>
    window.scrollTo({ top: 0, behavior: 'smooth' });
    <?php endif; ?>
    
    // Remove success parameters from URL after showing notification
    const urlParams = new URLSearchParams(window.location.search);
    if (urlParams.has('status_updated') || urlParams.has('deleted')) {
        const searchParams = new URLSearchParams(window.location.search);
        searchParams.delete('status_updated');
        searchParams.delete('deleted');
        
        const newParams = searchParams.toString();
        const newUrl = newParams ? `${window.location.pathname}?${newParams}` : window.location.pathname;
        
        window.history.replaceState({}, document.title, newUrl);
    }
});
</script>

</body>
</html>

<?php
// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: inventory-purchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation