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.22 TB

🔧 Quick Actions

✏️ Editing: inventory-suppliers.php

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

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

<div class="main-content">
        <div class="page-content">
           
            <div class="container-fluid">

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

// Handle new supplier
                if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['add_supplier'])) {
                    $name = $conn->real_escape_string($_POST['name']);
                    $contact_person = $conn->real_escape_string($_POST['contact_person']);
                    $email = $conn->real_escape_string($_POST['email']);
                    $phone = $conn->real_escape_string($_POST['phone']);
                    $address = $conn->real_escape_string($_POST['address']);
                    $gst_number = $conn->real_escape_string($_POST['gst_number']);
                    $status = $conn->real_escape_string($_POST['status']);

$sql = "INSERT INTO suppliers (name, contact_person, email, phone, address, gst_number, status) 
                            VALUES ('$name', '$contact_person', '$email', '$phone', '$address', '$gst_number', '$status')";
                    
                    if ($conn->query($sql) === TRUE) {
                        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                <i class="fas fa-check-circle me-2"></i>
                                Supplier "' . htmlspecialchars($name) . '" added successfully!
                                <div class="mt-2">
                                    <a href="inventory-suppliers.php" class="btn btn-sm btn-outline-primary me-2">View All Suppliers</a>
                                    <button type="button" class="btn btn-sm btn-outline-success" data-bs-toggle="modal" data-bs-target="#addSupplierModal">Add Another</button>
                                </div>
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    } else {
                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>
                                Error adding supplier: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle update supplier
                if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['update_supplier'])) {
                    $supplier_id = intval($_POST['supplier_id']);
                    $name = $conn->real_escape_string($_POST['name']);
                    $contact_person = $conn->real_escape_string($_POST['contact_person']);
                    $email = $conn->real_escape_string($_POST['email']);
                    $phone = $conn->real_escape_string($_POST['phone']);
                    $address = $conn->real_escape_string($_POST['address']);
                    $gst_number = $conn->real_escape_string($_POST['gst_number']);
                    $status = $conn->real_escape_string($_POST['status']);

$sql = "UPDATE suppliers SET 
                            name = '$name', 
                            contact_person = '$contact_person', 
                            email = '$email', 
                            phone = '$phone', 
                            address = '$address', 
                            gst_number = '$gst_number',
                            status = '$status',
                            updated_at = NOW()
                            WHERE id = $supplier_id";
                    
                    if ($conn->query($sql) === TRUE) {
                        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                <i class="fas fa-check-circle me-2"></i>
                                Supplier "' . htmlspecialchars($name) . '" updated successfully!
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    } else {
                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>
                                Error updating supplier: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle delete supplier
                if (isset($_GET['delete_supplier'])) {
                    $supplier_id = intval($_GET['delete_supplier']);
                    
                    // Check if supplier has purchase orders
                    $check_sql = "SELECT COUNT(*) as order_count FROM purchase_orders WHERE supplier_id = $supplier_id";
                    $check_result = $conn->query($check_sql);
                    $order_count = $check_result->fetch_assoc()['order_count'];
                    
                    if ($order_count > 0) {
                        echo '<div class="alert alert-warning alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-circle me-2"></i>
                                Cannot delete supplier with existing purchase orders! Deactivate instead.
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    } else {
                        $sql = "DELETE FROM suppliers WHERE id = $supplier_id";
                        
                        if ($conn->query($sql) === TRUE) {
                            echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                    <i class="fas fa-check-circle me-2"></i>
                                    Supplier deleted successfully!
                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                  </div>';
                        } else {
                            echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                    <i class="fas fa-exclamation-triangle me-2"></i>
                                    Error deleting supplier: ' . $conn->error . '
                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                  </div>';
                        }
                    }
                }

// Handle bulk actions
                if (isset($_POST['bulk_action'])) {
                    $action = $_POST['bulk_action'];
                    $supplier_ids = isset($_POST['supplier_ids']) ? $_POST['supplier_ids'] : array();
                    
                    if (!empty($supplier_ids)) {
                        $id_list = implode(',', array_map('intval', $supplier_ids));
                        
                        switch($action) {
                            case 'activate':
                                $sql = "UPDATE suppliers SET status = 'active' WHERE id IN ($id_list)";
                                $message = "Suppliers activated successfully!";
                                break;
                            case 'deactivate':
                                $sql = "UPDATE suppliers SET status = 'inactive' WHERE id IN ($id_list)";
                                $message = "Suppliers deactivated successfully!";
                                break;
                            case 'delete':
                                // Check for purchase orders before deletion
                                $check_sql = "SELECT COUNT(*) as order_count FROM purchase_orders WHERE supplier_id IN ($id_list)";
                                $check_result = $conn->query($check_sql);
                                $order_count = $check_result->fetch_assoc()['order_count'];
                                
                                if ($order_count > 0) {
                                    echo '<div class="alert alert-warning alert-dismissible fade show" role="alert">
                                            <i class="fas fa-exclamation-circle me-2"></i>
                                            Cannot delete suppliers with existing purchase orders! Deactivate instead.
                                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                          </div>';
                                    break;
                                } else {
                                    $sql = "DELETE FROM suppliers WHERE id IN ($id_list)";
                                    $message = "Suppliers deleted successfully!";
                                }
                                break;
                        }
                        
                        if (isset($sql) && $conn->query($sql) === TRUE) {
                            echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                    <i class="fas fa-check-circle me-2"></i>' . $message . '
                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                  </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_sql = "SELECT COUNT(*) as total FROM suppliers";
                                            echo $conn->query($total_sql)->fetch_assoc()['total'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Suppliers</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-truck display-4 opacity-50"></i>
                                    </div>
                                </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
                                            $active_sql = "SELECT COUNT(*) as active FROM suppliers WHERE status = 'active'";
                                            echo $conn->query($active_sql)->fetch_assoc()['active'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Active</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-check-circle display-4 opacity-50"></i>
                                    </div>
                                </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
                                            $inactive_sql = "SELECT COUNT(*) as inactive FROM suppliers WHERE status = 'inactive'";
                                            echo $conn->query($inactive_sql)->fetch_assoc()['inactive'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Inactive</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-pause-circle display-4 opacity-50"></i>
                                    </div>
                                </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
                                            $this_month_sql = "SELECT COUNT(DISTINCT supplier_id) as suppliers FROM purchase_orders WHERE MONTH(order_date) = MONTH(CURDATE()) AND YEAR(order_date) = YEAR(CURDATE())";
                                            echo $conn->query($this_month_sql)->fetch_assoc()['suppliers'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Active This Month</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-calendar-check display-4 opacity-50"></i>
                                    </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">Supplier Directory</h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <button type="button" class="btn btn-success" data-bs-toggle="modal" data-bs-target="#addSupplierModal">
                                            <i class="fas fa-plus-circle me-2"></i>Add New Supplier
                                        </button>
                                        <a href="inventory-purchase.php" class="btn btn-outline-primary">
                                            <i class="fas fa-shopping-cart me-2"></i>Purchase Orders
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-3">
                                    <div class="col-md-4">
                                        <div class="input-group">
                                            <input type="text" class="form-control" id="searchInput" placeholder="Search suppliers...">
                                            <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="active">Active</option>
                                            <option value="inactive">Inactive</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <select class="form-select" id="sortBy">
                                            <option value="name">Sort by Name</option>
                                            <option value="recent">Most Recent</option>
                                            <option value="orders">Most Orders</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <button type="button" class="btn btn-outline-secondary w-100" id="resetFilters">
                                            <i class="fas fa-refresh me-2"></i>Reset
                                        </button>
                                    </div>
                                </div>

<div class="row mb-3">
                                    <div class="col-12">
                                        <div class="d-flex gap-2 align-items-center flex-wrap">
                                            <select class="form-select" id="bulkAction" style="width: auto;">
                                                <option value="">Bulk Actions</option>
                                                <option value="activate">Activate</option>
                                                <option value="deactivate">Deactivate</option>
                                                <option value="delete">Delete</option>
                                            </select>
                                            <button type="button" class="btn btn-outline-primary" id="applyBulkAction">
                                                Apply
                                            </button>
                                            <div class="ms-auto">
                                                <span id="selectedCount" class="badge bg-primary">0 suppliers selected</span>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table class="table table-bordered table-hover mb-0" id="suppliersTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th width="50">
                                                    <div class="form-check">
                                                        <input class="form-check-input" type="checkbox" id="selectAll">
                                                    </div>
                                                </th>
                                                <th>Supplier</th>
                                                <th>Contact Information</th>
                                                <th>Business Details</th>
                                                <th>Order Statistics</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Build query with filters
                                            $where_conditions = array();

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

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

$where_sql = "";
                                            if (!empty($where_conditions)) {
                                                $where_sql = "WHERE " . implode(" AND ", $where_conditions);
                                            }

// Sort order
                                            $sort_by = isset($_GET['sort']) ? $_GET['sort'] : 'name';
                                            $order_sql = "ORDER BY s.name ASC";
                                            
                                            switch($sort_by) {
                                                case 'recent':
                                                    $order_sql = "ORDER BY s.created_at DESC";
                                                    break;
                                                case 'orders':
                                                    $order_sql = "ORDER BY order_count DESC";
                                                    break;
                                                default:
                                                    $order_sql = "ORDER BY s.name ASC";
                                            }

// Main query with statistics
                                            $sql = "SELECT s.*,
                                                   COUNT(po.id) as order_count,
                                                   COALESCE(SUM(po.total_amount), 0) as total_spent,
                                                   MAX(po.order_date) as last_order_date
                                                   FROM suppliers s 
                                                   LEFT JOIN purchase_orders po ON s.id = po.supplier_id 
                                                   $where_sql 
                                                   GROUP BY s.id 
                                                   $order_sql";
                                            
                                            $result = $conn->query($sql);

if ($result->num_rows > 0) {
                                                while($supplier = $result->fetch_assoc()) {
                                                    // Status badge
                                                    $status_badge = '';
                                                    if ($supplier['status'] == 'active') {
                                                        $status_badge = '<span class="badge bg-success"><i class="fas fa-check-circle me-1"></i>Active</span>';
                                                    } else {
                                                        $status_badge = '<span class="badge bg-warning"><i class="fas fa-pause-circle me-1"></i>Inactive</span>';
                                                    }

// Contact information
                                                    $contact_info = '';
                                                    if (!empty($supplier['contact_person'])) {
                                                        $contact_info .= '<div><strong>' . htmlspecialchars($supplier['contact_person']) . '</strong></div>';
                                                    }
                                                    if (!empty($supplier['email'])) {
                                                        $contact_info .= '<div><i class="fas fa-envelope me-1 text-muted"></i> ' . htmlspecialchars($supplier['email']) . '</div>';
                                                    }
                                                    if (!empty($supplier['phone'])) {
                                                        $contact_info .= '<div><i class="fas fa-phone me-1 text-muted"></i> ' . htmlspecialchars($supplier['phone']) . '</div>';
                                                    }

// Business details
                                                    $business_info = '';
                                                    if (!empty($supplier['gst_number'])) {
                                                        $business_info .= '<div><small class="text-muted">GST: ' . htmlspecialchars($supplier['gst_number']) . '</small></div>';
                                                    }

// Order statistics
                                                    $order_stats = '';
                                                    if ($supplier['order_count'] > 0) {
                                                        $order_stats .= '<div><strong>' . $supplier['order_count'] . '</strong> orders</div>';
                                                        $order_stats .= '<div class="text-success">₹' . number_format($supplier['total_spent'], 2) . ' spent</div>';
                                                        if (!empty($supplier['last_order_date'])) {
                                                            $last_order = date('M j, Y', strtotime($supplier['last_order_date']));
                                                            $order_stats .= '<div class="text-muted"><small>Last: ' . $last_order . '</small></div>';
                                                        }
                                                    } else {
                                                        $order_stats = '<div class="text-muted"><small>No orders yet</small></div>';
                                                    }

// Performance indicator
                                                    $performance_class = 'text-muted';
                                                    if ($supplier['total_spent'] > 100000) {
                                                        $performance_class = 'text-success';
                                                    } elseif ($supplier['total_spent'] > 50000) {
                                                        $performance_class = 'text-info';
                                                    } elseif ($supplier['total_spent'] > 0) {
                                                        $performance_class = 'text-warning';
                                                    }
                                            ?>
                                            <tr data-status="<?php echo $supplier['status']; ?>">
                                                <td>
                                                    <div class="form-check">
                                                        <input class="form-check-input supplier-checkbox" type="checkbox" value="<?php echo $supplier['id']; ?>">
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <div class="flex-shrink-0">
                                                            <div class="avatar-xs bg-light rounded-circle">
                                                                <i class="fas fa-truck font-size-13 text-primary"></i>
                                                            </div>
                                                        </div>
                                                        <div class="flex-grow-1 ms-2">
                                                            <h6 class="mb-0"><?php echo htmlspecialchars($supplier['name']); ?></h6>
                                                            <small class="text-muted">Added: <?php echo date('M j, Y', strtotime($supplier['created_at'])); ?></small>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <?php echo $contact_info; ?>
                                                </td>
                                                <td>
                                                    <?php echo $business_info; ?>
                                                    <?php if (!empty($supplier['address'])): ?>
                                                        <div class="mt-1">
                                                            <small class="text-muted" title="<?php echo htmlspecialchars($supplier['address']); ?>">
                                                                <i class="fas fa-map-marker-alt me-1"></i>
                                                                <?php echo strlen($supplier['address']) > 30 ? substr($supplier['address'], 0, 30) . '...' : $supplier['address']; ?>
                                                            </small>
                                                        </div>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <div class="<?php echo $performance_class; ?>">
                                                        <?php echo $order_stats; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <?php echo $status_badge; ?>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-outline-primary edit-supplier" 
                                                                data-bs-toggle="modal" data-bs-target="#editSupplierModal"
                                                                data-supplier-id="<?php echo $supplier['id']; ?>"
                                                                data-name="<?php echo htmlspecialchars($supplier['name']); ?>"
                                                                data-contact-person="<?php echo htmlspecialchars($supplier['contact_person']); ?>"
                                                                data-email="<?php echo htmlspecialchars($supplier['email']); ?>"
                                                                data-phone="<?php echo htmlspecialchars($supplier['phone']); ?>"
                                                                data-address="<?php echo htmlspecialchars($supplier['address']); ?>"
                                                                data-gst-number="<?php echo htmlspecialchars($supplier['gst_number']); ?>"
                                                                data-status="<?php echo $supplier['status']; ?>">
                                                            <i class="fas fa-edit"></i>
                                                        </button>
                                                        <a href="inventory-purchase.php?supplier=<?php echo $supplier['id']; ?>" class="btn btn-outline-info" title="View Orders">
                                                            <i class="fas fa-shopping-cart"></i>
                                                        </a>
                                                        <?php if ($supplier['order_count'] == 0): ?>
                                                            <a href="inventory-suppliers.php?delete_supplier=<?php echo $supplier['id']; ?>" class="btn btn-outline-danger" title="Delete Supplier" onclick="return confirm('Are you sure you want to delete this supplier?')">
                                                                <i class="fas fa-trash"></i>
                                                            </a>
                                                        <?php else: ?>
                                                            <button class="btn btn-outline-secondary" disabled title="Cannot delete supplier with orders">
                                                                <i class="fas fa-trash"></i>
                                                            </button>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="7" class="text-center py-4">
                                                    <i class="fas fa-truck display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Suppliers Found</h5>
                                                    <p class="text-muted">Add your first supplier to get started with purchase orders.</p>
                                                    <button type="button" class="btn btn-success" data-bs-toggle="modal" data-bs-target="#addSupplierModal">
                                                        <i class="fas fa-plus-circle me-2"></i>Add New Supplier
                                                    </button>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>

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

</div>
            
        </div>

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

</div>

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

<div class="modal fade" id="addSupplierModal" tabindex="-1" aria-labelledby="addSupplierModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="addSupplierModalLabel">Add New Supplier</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="name" class="form-label">Supplier Name <span class="text-danger">*</span></label>
                                <input type="text" class="form-control" id="name" name="name" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="contact_person" class="form-label">Contact Person</label>
                                <input type="text" class="form-control" id="contact_person" name="contact_person">
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="email" class="form-label">Email</label>
                                <input type="email" class="form-control" id="email" name="email">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="phone" class="form-label">Phone</label>
                                <input type="text" class="form-control" id="phone" name="phone">
                            </div>
                        </div>
                    </div>

<div class="mb-3">
                        <label for="address" class="form-label">Address</label>
                        <textarea class="form-control" id="address" name="address" rows="3"></textarea>
                    </div>

<div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="gst_number" class="form-label">GST Number</label>
                                <input type="text" class="form-control" id="gst_number" name="gst_number">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="status" class="form-label">Status</label>
                                <select class="form-select" id="status1" name="status" required>
                                    <option value="active">Active</option>
                                    <option value="inactive">Inactive</option>
                                </select>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="add_supplier" class="btn btn-primary">Add Supplier</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="editSupplierModal" tabindex="-1" aria-labelledby="editSupplierModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editSupplierModalLabel">Edit Supplier</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <input type="hidden" name="supplier_id" id="edit_supplier_id">
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="edit_name" class="form-label">Supplier Name <span class="text-danger">*</span></label>
                                <input type="text" class="form-control" id="edit_name" name="name" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="edit_contact_person" class="form-label">Contact Person</label>
                                <input type="text" class="form-control" id="edit_contact_person" name="contact_person">
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="edit_email" class="form-label">Email</label>
                                <input type="email" class="form-control" id="edit_email" name="email">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="edit_phone" class="form-label">Phone</label>
                                <input type="text" class="form-control" id="edit_phone" name="phone">
                            </div>
                        </div>
                    </div>

<div class="mb-3">
                        <label for="edit_address" class="form-label">Address</label>
                        <textarea class="form-control" id="edit_address" name="address" rows="3"></textarea>
                    </div>

<div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="edit_gst_number" class="form-label">GST Number</label>
                                <input type="text" class="form-control" id="edit_gst_number" name="gst_number">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="edit_status" class="form-label">Status</label>
                                <select class="form-select" id="edit_status" name="status" required>
                                    <option value="active">Active</option>
                                    <option value="inactive">Inactive</option>
                                </select>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_supplier" class="btn btn-primary">Update Supplier</button>
                </div>
            </form>
        </div>
    </div>
</div>

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

// Edit Supplier Modal
    editSupplierModal.addEventListener('show.bs.modal', function (event) {
        const button = event.relatedTarget;
        document.getElementById('edit_supplier_id').value = button.getAttribute('data-supplier-id');
        document.getElementById('edit_name').value = button.getAttribute('data-name');
        document.getElementById('edit_contact_person').value = button.getAttribute('data-contact-person');
        document.getElementById('edit_email').value = button.getAttribute('data-email');
        document.getElementById('edit_phone').value = button.getAttribute('data-phone');
        document.getElementById('edit_address').value = button.getAttribute('data-address');
        document.getElementById('edit_gst_number').value = button.getAttribute('data-gst-number');
        document.getElementById('edit_status').value = button.getAttribute('data-status');
    });

// Select All functionality
    selectAll.addEventListener('change', function() {
        supplierCheckboxes.forEach(checkbox => {
            checkbox.checked = this.checked;
        });
        updateSelectedCount();
    });

// Update selected count
    function updateSelectedCount() {
        const selected = document.querySelectorAll('.supplier-checkbox:checked').length;
        selectedCount.textContent = selected + ' suppliers selected';
    }

supplierCheckboxes.forEach(checkbox => {
        checkbox.addEventListener('change', updateSelectedCount);
    });

// Get selected supplier IDs
    function getSelectedSupplierIds() {
        return Array.from(document.querySelectorAll('.supplier-checkbox:checked'))
            .map(checkbox => checkbox.value);
    }

// Bulk action
    applyBulkAction.addEventListener('click', function() {
        const action = bulkAction.value;
        const selectedSuppliers = getSelectedSupplierIds();

if (!action) {
            alert('Please select a bulk action.');
            return;
        }

if (selectedSuppliers.length === 0) {
            alert('Please select at least one supplier.');
            return;
        }

if (action === 'delete') {
            if (!confirm('Are you sure you want to delete the selected suppliers? This action cannot be undone.')) {
                return;
            }
        }

// Create form and submit
        const form = document.createElement('form');
        form.method = 'POST';
        form.action = '';

selectedSuppliers.forEach(id => {
            const input = document.createElement('input');
            input.type = 'hidden';
            input.name = 'supplier_ids[]';
            input.value = id;
            form.appendChild(input);
        });

const actionInput = document.createElement('input');
        actionInput.type = 'hidden';
        actionInput.name = 'bulk_action';
        actionInput.value = action;
        form.appendChild(actionInput);

document.body.appendChild(form);
        form.submit();
    });

// Filter functionality
    function applyFilters() {
        const params = new URLSearchParams();
        
        if (statusFilter.value) params.set('status', statusFilter.value);
        if (sortBy.value !== 'name') params.set('sort', sortBy.value);
        if (searchInput.value) params.set('search', searchInput.value);
        
        window.location.href = 'inventory-suppliers.php?' + params.toString();
    }

searchButton.addEventListener('click', applyFilters);
    searchInput.addEventListener('keypress', function(e) {
        if (e.key === 'Enter') applyFilters();
    });
    
    statusFilter.addEventListener('change', applyFilters);
    sortBy.addEventListener('change', applyFilters);

// Reset filters
    resetFilters.addEventListener('click', function() {
        window.location.href = 'inventory-suppliers.php';
    });

// Set current filter values from URL
    const urlParams = new URLSearchParams(window.location.search);
    if (urlParams.get('status')) statusFilter.value = urlParams.get('status');
    if (urlParams.get('sort')) sortBy.value = urlParams.get('sort');
    if (urlParams.get('search')) searchInput.value = urlParams.get('search');
});
</script>

</body>
</html>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: inventory-suppliers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation