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/sri-motors/admin

Free Space:

10.17 TB

🔧 Quick Actions

✏️ Editing: suppliers.php

<!doctype html>
<html lang="en">
<?php include('includes/head.php') ?>
<body data-sidebar="dark">

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

<div class="d-flex justify-content-between align-items-center mb-3">
                                    <h4 class="card-title mb-0">All Suppliers</h4>
                                    <div class="d-flex gap-2">
                                        <button class="btn btn-outline-secondary" onclick="exportSuppliers()">
                                            <i class="bx bx-export me-1"></i> Export
                                        </button>
                                        <button class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#addSupplierModal">
                                            <i class="bx bx-plus me-1"></i> Add Supplier
                                        </button>
                                    </div>
                                </div>

<form method="GET" class="mb-4">
                                    <div class="row g-3 align-items-end">
                                        <div class="col-md-4">
                                            <label class="form-label">Search</label>
                                            <div class="input-group">
                                                <span class="input-group-text"><i class="fas fa-search"></i></span>
                                                <input type="text" name="search" class="form-control" placeholder="Supplier Name, Contact, GSTN..."
                                                       value="<?php echo isset($_GET['search']) ? htmlspecialchars($_GET['search']) : ''; ?>">
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <label class="form-label">Status</label>
                                            <select name="status" class="form-select">
                                                <option value="">All Status</option>
                                                <option value="active" <?= (isset($_GET['status']) && $_GET['status'] == 'active') ? 'selected' : '' ?>>Active</option>
                                                <option value="inactive" <?= (isset($_GET['status']) && $_GET['status'] == 'inactive') ? 'selected' : '' ?>>Inactive</option>
                                            </select>
                                        </div>
                                        <div class="col-md-2">
                                            <label class="form-label">Sort By</label>
                                            <select name="sort" class="form-select">
                                                <option value="supplier_name" <?= (isset($_GET['sort']) && $_GET['sort'] == 'supplier_name') ? 'selected' : '' ?>>Name</option>
                                                <option value="created_at" <?= (isset($_GET['sort']) && $_GET['sort'] == 'created_at') ? 'selected' : '' ?>>Date Added</option>
                                                <option value="total_orders" <?= (isset($_GET['sort']) && $_GET['sort'] == 'total_orders') ? 'selected' : '' ?>>Total Orders</option>
                                                <option value="total_spent" <?= (isset($_GET['sort']) && $_GET['sort'] == 'total_spent') ? 'selected' : '' ?>>Total Business</option>
                                            </select>
                                        </div>
                                        <div class="col-md-2">
                                            <label class="form-label">Order</label>
                                            <select name="order" class="form-select">
                                                <option value="ASC" <?= (isset($_GET['order']) && $_GET['order'] == 'ASC') ? 'selected' : '' ?>>Ascending</option>
                                                <option value="DESC" <?= (isset($_GET['order']) && $_GET['order'] == 'DESC') ? 'selected' : '' ?>>Descending</option>
                                            </select>
                                        </div>
                                        <div class="col-md-1">
                                            <label class="form-label">&nbsp;</label>
                                            <button type="submit" class="btn btn-primary w-100 h-100 d-flex align-items-center justify-content-center" title="Search">
                                                <i class="fas fa-search me-1"></i> Search
                                            </button>
                                        </div>
                                    </div>
                                </form>

<?php
                                require_once 'includes/db.php';

// Pagination
                                $limit = 15;
                                $page = max(1, (int)($_GET['page'] ?? 1));
                                $offset = ($page - 1) * $limit;

// Build WHERE
                                $where = [];
                                $params = [];
                                $types = '';

if (!empty($_GET['search'])) {
                                    $search = '%' . trim($_GET['search']) . '%';
                                    $where[] = "(supplier_name LIKE ? OR contact_person LIKE ? OR phone LIKE ? OR email LIKE ? OR gstn_number LIKE ?)";
                                    $params = array_merge($params, [$search, $search, $search, $search, $search]);
                                    $types .= 'sssss';
                                }

if (!empty($_GET['status'])) {
                                    $where[] = "status = ?";
                                    $params[] = $_GET['status'];
                                    $types .= 's';
                                }

$where_clause = !empty($where) ? 'WHERE ' . implode(' AND ', $where) : '';

// Sorting
                                $sort = isset($_GET['sort']) ? $_GET['sort'] : 'supplier_name';
                                $order = isset($_GET['order']) ? $_GET['order'] : 'ASC';
                                
                                // Validate sort field to prevent SQL injection
                                $allowed_sorts = ['supplier_name', 'created_at', 'total_orders', 'total_spent'];
                                $sort = in_array($sort, $allowed_sorts) ? $sort : 'supplier_name';
                                $order = ($order === 'ASC') ? 'ASC' : 'DESC';
                                
                                $order_by = "ORDER BY $sort $order";

// Count total
                                $count_sql = "SELECT COUNT(*) as total FROM suppliers $where_clause";
                                $count_stmt = $conn->prepare($count_sql);
                                if (!empty($params)) {
                                    $bind_params = $params;
                                    $count_stmt->bind_param($types, ...$bind_params);
                                }
                                $count_stmt->execute();
                                $count_result = $count_stmt->get_result();
                                $total_rows = $count_result->fetch_assoc()['total'];
                                $total_pages = max(1, ceil($total_rows / $limit));
                                $count_stmt->close();

// Fetch suppliers with purchase statistics
                                $sql = "SELECT 
                                            s.*,
                                            COUNT(DISTINCT po.id) as total_orders,
                                            COALESCE(SUM(po.total_amount), 0) as total_spent,
                                            MAX(po.po_date) as last_order_date,
                                            MIN(po.po_date) as first_order_date
                                        FROM suppliers s
                                        LEFT JOIN purchase_orders po ON s.id = po.supplier_id
                                        $where_clause
                                        GROUP BY s.id
                                        $order_by
                                        LIMIT ? OFFSET ?";

$stmt = $conn->prepare($sql);
                                if (!$stmt) {
                                    die("Error preparing statement: " . $conn->error);
                                }

// Add limit and offset parameters
                                $limit_param = $limit;
                                $offset_param = $offset;
                                
                                if (!empty($params)) {
                                    $stmt->bind_param($types . 'ii', ...array_merge($params, [$limit_param, $offset_param]));
                                } else {
                                    $stmt->bind_param('ii', $limit_param, $offset_param);
                                }

$stmt->execute();
                                $result = $stmt->get_result();

// Calculate summary stats
                                $summary_sql = "SELECT 
                                    COUNT(*) as total_suppliers,
                                    COUNT(CASE WHEN status = 'active' THEN 1 END) as active_suppliers,
                                    COUNT(CASE WHEN gstn_number IS NOT NULL AND gstn_number != '' THEN 1 END) as gstn_registered,
                                    COALESCE((
                                        SELECT COUNT(DISTINCT supplier_id) 
                                        FROM purchase_orders 
                                        WHERE supplier_id IS NOT NULL
                                    ), 0) as suppliers_with_orders
                                FROM suppliers 
                                $where_clause";
                                
                                $summary_stmt = $conn->prepare($summary_sql);
                                if (!empty($params)) {
                                    $summary_stmt->bind_param($types, ...$params);
                                }
                                $summary_stmt->execute();
                                $summary_result = $summary_stmt->get_result();
                                $summary = $summary_result->fetch_assoc();
                                $summary_stmt->close();
                                ?>

<div class="row mb-4">
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card mini-stat bg-primary text-white">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div>
                                                        <h5 class="font-size-14 text-white">Total Suppliers</h5>
                                                        <h4 class="mt-2"><?= $summary['total_suppliers'] ?? 0 ?></h4>
                                                    </div>
                                                    <div class="align-self-center">
                                                        <i class="fas fa-truck font-size-30"></i>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card mini-stat bg-success text-white">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div>
                                                        <h5 class="font-size-14 text-white">Active Suppliers</h5>
                                                        <h4 class="mt-2"><?= $summary['active_suppliers'] ?? 0 ?></h4>
                                                    </div>
                                                    <div class="align-self-center">
                                                        <i class="fas fa-check-circle font-size-30"></i>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card mini-stat bg-info text-white">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div>
                                                        <h5 class="font-size-14 text-white">GSTN Registered</h5>
                                                        <h4 class="mt-2"><?= $summary['gstn_registered'] ?? 0 ?></h4>
                                                    </div>
                                                    <div class="align-self-center">
                                                        <i class="fas fa-file-invoice font-size-30"></i>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card mini-stat bg-warning text-white">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div>
                                                        <h5 class="font-size-14 text-white">With Orders</h5>
                                                        <h4 class="mt-2"><?= $summary['suppliers_with_orders'] ?? 0 ?></h4>
                                                    </div>
                                                    <div class="align-self-center">
                                                        <i class="fas fa-shopping-cart font-size-30"></i>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table class="table table-hover table-bordered align-middle">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Supplier Details</th>
                                                <th>Contact Information</th>
                                                <th class="text-center">Orders</th>
                                                <th class="text-end">Total Business</th>
                                                <th class="text-center">Last Order</th>
                                                <th class="text-center">Status</th>
                                                <th class="text-center">Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if ($result->num_rows > 0):
                                                $counter = $offset + 1;
                                                while ($row = $result->fetch_assoc()):
                                                    // Calculate days since last order
                                                    $days_ago = $row['last_order_date'] ? round((time() - strtotime($row['last_order_date'])) / (60 * 60 * 24)) : 'N/A';
                                            ?>
                                            <tr>
                                                <td class="fw-bold"><?= $counter++ ?></td>
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <div class="avatar-sm me-3">
                                                            <div class="bg-primary rounded-circle d-flex align-items-center justify-content-center" 
                                                                 style="width: 40px; height: 40px;">
                                                                <span class="text-white fw-bold">
                                                                    <?= strtoupper(substr($row['supplier_name'], 0, 2)) ?>
                                                                </span>
                                                            </div>
                                                        </div>
                                                        <div>
                                                            <strong><?= htmlspecialchars($row['supplier_name']) ?></strong>
                                                            <?php if ($row['contact_person']): ?>
                                                                <br><small class="text-muted"><i class="fas fa-user"></i> <?= htmlspecialchars($row['contact_person']) ?></small>
                                                            <?php endif; ?>
                                                            <?php if ($row['gstn_number']): ?>
                                                                <br><small class="text-muted"><i class="fas fa-file-invoice"></i> <?= htmlspecialchars($row['gstn_number']) ?></small>
                                                            <?php endif; ?>
                                                            <?php if ($row['address']): ?>
                                                                <br><small class="text-muted"><?= nl2br(htmlspecialchars(substr($row['address'], 0, 100))) ?><?= strlen($row['address']) > 100 ? '...' : '' ?></small>
                                                            <?php endif; ?>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <?php if ($row['phone']): ?>
                                                            <a href="tel:<?= htmlspecialchars($row['phone']) ?>" class="text-decoration-none">
                                                                <i class="fas fa-phone"></i> <?= htmlspecialchars($row['phone']) ?>
                                                            </a>
                                                            <br>
                                                        <?php endif; ?>
                                                        <?php if ($row['email']): ?>
                                                            <a href="mailto:<?= htmlspecialchars($row['email']) ?>" class="text-decoration-none">
                                                                <i class="fas fa-envelope"></i> <?= htmlspecialchars($row['email']) ?>
                                                            </a>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td class="text-center">
                                                    <span class="badge bg-primary rounded-pill fs-6"><?= $row['total_orders'] ?></span>
                                                </td>
                                                <td class="text-end">
                                                    <?php if ($row['total_spent'] > 0): ?>
                                                        <strong>₹<?= number_format($row['total_spent'], 2) ?></strong>
                                                    <?php else: ?>
                                                        <span class="text-muted">-</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td class="text-center">
                                                    <?php if ($row['last_order_date']): ?>
                                                        <div><?= date('d M Y', strtotime($row['last_order_date'])) ?></div>
                                                        <small class="text-muted"><?= $days_ago ?> days ago</small>
                                                    <?php else: ?>
                                                        <span class="text-muted">No orders</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td class="text-center">
                                                    <span class="badge bg-<?= $row['status'] == 'active' ? 'success' : 'danger' ?>">
                                                        <?= ucfirst($row['status']) ?>
                                                    </span>
                                                </td>
                                                <td>
    <div class="btn-group">
        <button class="btn btn-outline-info btn-sm" 
                onclick="viewSupplier(<?= $row['id'] ?>)" 
                title="View Details">
            <i class="fas fa-eye"></i>
        </button>
        <button class="btn btn-outline-warning btn-sm" 
                onclick="editSupplier(<?= $row['id'] ?>)" 
                title="Edit Supplier">
            <i class="fas fa-edit"></i>
        </button>
        <a href="purchase-orders.php?supplier_id=<?= $row['id'] ?>" 
           class="btn btn-outline-success btn-sm" 
           title="New Purchase Order">
            <i class="fas fa-plus"></i>
        </a>
        <?php if ($row['phone']): ?>
        <a href="https://wa.me/91<?= htmlspecialchars($row['phone']) ?>?text=Hi <?= urlencode($row['supplier_name']) ?>" 
           target="_blank" 
           class="btn btn-outline-primary btn-sm" 
           title="WhatsApp">
            <i class="fab fa-whatsapp"></i>
        </a>
        <?php endif; ?>
        <button class="btn btn-outline-danger btn-sm" 
                onclick="deleteSupplier(<?= $row['id'] ?>, '<?= htmlspecialchars(addslashes($row['supplier_name'])) ?>')" 
                title="Delete Supplier">
            <i class="fas fa-trash"></i>
        </button>
    </div>
</td>
                                            </tr>
                                            <?php
                                                endwhile;
                                            else:
                                            ?>
                                            <tr>
                                                <td colspan="8" class="text-center py-4">
                                                    <i class="fas fa-truck display-1 text-muted"></i>
                                                    <h5 class="text-muted mt-3">No Suppliers Found</h5>
                                                    <p class="text-muted">No suppliers match your search criteria.</p>
                                                    <button class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#addSupplierModal">
                                                        <i class="fas fa-plus me-1"></i> Add First Supplier
                                                    </button>
                                                </td>
                                            </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if ($total_pages > 1): ?>
                                <div class="d-flex justify-content-between align-items-center mt-3">
                                    <div class="text-muted">
                                        Showing <?= $offset + 1 ?> to <?= min($offset + $limit, $total_rows) ?> of <?= $total_rows ?> entries
                                    </div>
                                    <nav>
                                        <ul class="pagination justify-content-center mb-0">
                                            <li class="page-item <?= $page <= 1 ? 'disabled' : '' ?>">
                                                <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => 1])) ?>">
                                                    <i class="fas fa-angle-double-left"></i>
                                                </a>
                                            </li>
                                            <li class="page-item <?= $page <= 1 ? 'disabled' : '' ?>">
                                                <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => $page-1])) ?>">
                                                    <i class="fas fa-chevron-left"></i>
                                                </a>
                                            </li>
                                            
                                            <?php 
                                            $start_page = max(1, $page - 2);
                                            $end_page = min($total_pages, $page + 2);
                                            
                                            for ($i = $start_page; $i <= $end_page; $i++): 
                                            ?>
                                            <li class="page-item <?= $i == $page ? 'active' : '' ?>">
                                                <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => $i])) ?>">
                                                    <?= $i ?>
                                                </a>
                                            </li>
                                            <?php endfor; ?>
                                            
                                            <li class="page-item <?= $page >= $total_pages ? 'disabled' : '' ?>">
                                                <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => $page+1])) ?>">
                                                    <i class="fas fa-chevron-right"></i>
                                                </a>
                                            </li>
                                            <li class="page-item <?= $page >= $total_pages ? 'disabled' : '' ?>">
                                                <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => $total_pages])) ?>">
                                                    <i class="fas fa-angle-double-right"></i>
                                                </a>
                                            </li>
                                        </ul>
                                    </nav>
                                </div>
                                <?php endif; ?>

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

<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 id="addSupplierForm" action="ajax/add-supplier.php" method="POST">
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Supplier Name *</label>
                                <input type="text" class="form-control" name="supplier_name" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Contact Person</label>
                                <input type="text" class="form-control" name="contact_person">
                            </div>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Phone</label>
                                <input type="text" class="form-control" name="phone">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Email</label>
                                <input type="email" class="form-control" name="email">
                            </div>
                        </div>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Address</label>
                        <textarea class="form-control" name="address" rows="3"></textarea>
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">GSTN Number</label>
                                <input type="text" class="form-control" name="gstn_number">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Status</label>
                                <select class="form-select" name="status">
                                    <option value="active">Active</option>
                                    <option value="inactive">Inactive</option>
                                </select>
                            </div>
                        </div>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Bank Details</label>
                        <textarea class="form-control" name="bank_details" rows="2" placeholder="Bank name, account number, IFSC, etc."></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary">Add Supplier</button>
                </div>
            </form>
        </div>
    </div>
</div>

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

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">

function viewSupplier(supplierId) {
    window.location.href = 'supplier-details.php?id=' + supplierId;
}

function editSupplier(supplierId) {
    window.location.href = 'edit-supplier.php?id=' + supplierId;
}

// Toast notification function
function showToast(message, type = 'info') {
    // Remove existing toasts
    const existingToasts = document.querySelectorAll('.toast-container');
    existingToasts.forEach(toast => toast.remove());
    
    const toastContainer = document.createElement('div');
    toastContainer.className = 'toast-container position-fixed top-0 end-0 p-3';
    toastContainer.style.zIndex = '9999';
    
    const toastHtml = `
        <div class="toast align-items-center text-white bg-${type === 'success' ? 'success' : type === 'error' ? 'danger' : 'info'} border-0 show" role="alert">
            <div class="d-flex">
                <div class="toast-body">
                    ${message}
                </div>
                <button type="button" class="btn-close btn-close-white me-2 m-auto" data-bs-dismiss="toast"></button>
            </div>
        </div>
    `;
    
    toastContainer.innerHTML = toastHtml;
    document.body.appendChild(toastContainer);
    
    // Auto remove after 3 seconds
    setTimeout(() => {
        toastContainer.remove();
    }, 3000);
}

// Handle form submission with AJAX
document.getElementById('addSupplierForm').addEventListener('submit', function(e) {
    e.preventDefault();
    
    const formData = new FormData(this);
    const submitBtn = this.querySelector('button[type="submit"]');
    const originalText = submitBtn.innerHTML;
    
    submitBtn.innerHTML = '<i class="bx bx-loader bx-spin me-1"></i> Adding...';
    submitBtn.disabled = true;
    
    fetch(this.action, {
        method: 'POST',
        body: formData
    })
    .then(response => response.json())
    .then(data => {
        if (data.success) {
            showToast('Supplier added successfully!', 'success');
            setTimeout(() => {
                window.location.reload();
            }, 1000);
        } else {
            showToast('Error: ' + data.message, 'error');
            submitBtn.innerHTML = originalText;
            submitBtn.disabled = false;
        }
    })
    .catch(error => {
        showToast('Network error: ' + error, 'error');
        submitBtn.innerHTML = originalText;
        submitBtn.disabled = false;
    });
});
</script>

</body>
</html>

<?php
if (isset($stmt)) $stmt->close();
if (isset($conn)) mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: suppliers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation