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

🔧 Quick Actions

✏️ Editing: manage-suppliers.php

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

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

// Start session
session_start();

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

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

// Search and filter variables
$search = isset($_GET['search']) ? mysqli_real_escape_string($conn, $_GET['search']) : '';
$status_filter = isset($_GET['status']) ? mysqli_real_escape_string($conn, $_GET['status']) : '';

// Build WHERE clause
$where_conditions = [];
$params = [];
$types = '';

if (!empty($search)) {
    $where_conditions[] = "(supplier_name LIKE ? OR company_name LIKE ? OR phone LIKE ? OR email LIKE ? OR gst_number LIKE ?)";
    $search_term = "%{$search}%";
    $types .= 'sssss';
    $params = array_merge($params, [$search_term, $search_term, $search_term, $search_term, $search_term]);
}

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

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

// Get total number of suppliers for pagination
$count_sql = "SELECT COUNT(*) as total FROM suppliers $where_clause";
$count_stmt = mysqli_prepare($conn, $count_sql);
if (!empty($params)) {
    mysqli_stmt_bind_param($count_stmt, $types, ...$params);
}
mysqli_stmt_execute($count_stmt);
$count_result = mysqli_stmt_get_result($count_stmt);
$total_rows = mysqli_fetch_assoc($count_result)['total'];
$total_pages = ceil($total_rows / $limit);
mysqli_stmt_close($count_stmt);

// Get suppliers with pagination
$sql = "SELECT * FROM suppliers $where_clause ORDER BY supplier_name ASC LIMIT ?, ?";
$types .= 'ii';
$params[] = $start;
$params[] = $limit;

$stmt = mysqli_prepare($conn, $sql);
if ($stmt) {
    if (!empty($params)) {
        mysqli_stmt_bind_param($stmt, $types, ...$params);
    }
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $suppliers = mysqli_fetch_all($result, MYSQLI_ASSOC);
    mysqli_stmt_close($stmt);
} else {
    $suppliers = [];
}
?>

<?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 (isset($_GET['msg'])): ?>
                    <div class="alert alert-<?php echo $_GET['type'] ?? 'info'; ?> alert-dismissible fade show" role="alert">
                        <?php echo htmlspecialchars($_GET['msg']); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">

<div class="row mb-3">
                                    <div class="col-md-6">
                                        <a href="add-supplier.php" class="btn btn-primary">
                                            <i class="dripicons-user-add"></i> Add New Supplier
                                        </a>
                                        <a href="supplier-reports.php" class="btn btn-info ms-1">
                                            <i class="dripicons-graph-line"></i> Reports
                                        </a>
                                        <button type="button" class="btn btn-secondary ms-1" id="printBtn">
                                            <i class="dripicons-print"></i> Print
                                        </button>
                                    </div>
                                    <div class="col-md-6">
                                        <form method="GET" class="row g-2">
                                            <div class="col-md-5">
                                                <input type="text" class="form-control" name="search" 
                                                       placeholder="Search by name, phone, email..." 
                                                       value="<?php echo htmlspecialchars($search); ?>">
                                            </div>
                                            <div class="col-md-4">
                                                <select class="form-control" name="status">
                                                    <option value="">All Status</option>
                                                    <option value="active" <?php echo $status_filter == 'active' ? 'selected' : ''; ?>>Active</option>
                                                    <option value="inactive" <?php echo $status_filter == 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                                                    <option value="blocked" <?php echo $status_filter == 'blocked' ? 'selected' : ''; ?>>Blocked</option>
                                                </select>
                                            </div>
                                            <div class="col-md-3">
                                                <button type="submit" class="btn btn-primary w-100">
                                                    <i class="dripicons-search"></i> Filter
                                                </button>
                                            </div>
                                        </form>
                                    </div>
                                </div>

<div class="table-responsive" id="printableTable">
                                    <table class="table table-hover table-centered mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Supplier Name</th>
                                                <th>Company</th>
                                                <th>Contact Info</th>
                                                <th>GST No.</th>
                                                <th>Balance</th>
                                                <th>Credit Limit</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if (empty($suppliers)): ?>
                                                <tr>
                                                    <td colspan="9" class="text-center py-4">
                                                        <div class="text-muted">
                                                            <i class="dripicons-warning" style="font-size: 48px;"></i>
                                                            <h5 class="mt-2">No suppliers found</h5>
                                                            <p>Add your first supplier using the "Add New Supplier" button</p>
                                                        </div>
                                                    </td>
                                                </tr>
                                            <?php else: ?>
                                                <?php $counter = $start + 1; ?>
                                                <?php foreach ($suppliers as $supplier): ?>
                                                    <?php
                                                    $balance_class = 'text-success';
                                                    if ($supplier['current_balance'] > 0) {
                                                        $balance_class = 'text-danger'; // Supplier owes us
                                                    } elseif ($supplier['current_balance'] < 0) {
                                                        $balance_class = 'text-success'; // We owe supplier
                                                    }
                                                    
                                                    $status_class = '';
                                                    switch ($supplier['status']) {
                                                        case 'active':
                                                            $status_class = 'badge bg-success';
                                                            $status_text = 'Active';
                                                            break;
                                                        case 'inactive':
                                                            $status_class = 'badge bg-secondary';
                                                            $status_text = 'Inactive';
                                                            break;
                                                        case 'blocked':
                                                            $status_class = 'badge bg-danger';
                                                            $status_text = 'Blocked';
                                                            break;
                                                        default:
                                                            $status_class = 'badge bg-secondary';
                                                            $status_text = 'Unknown';
                                                    }
                                                    ?>
                                                    <tr>
                                                        <td><?php echo $counter++; ?></td>
                                                        <td>
                                                            <strong><?php echo htmlspecialchars($supplier['supplier_name']); ?></strong>
                                                            <?php if ($supplier['opening_balance'] != 0): ?>
                                                                <br><small class="text-muted">Opening: ₹<?php echo number_format($supplier['opening_balance'], 2); ?></small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <?php echo !empty($supplier['company_name']) ? htmlspecialchars($supplier['company_name']) : '<span class="text-muted">N/A</span>'; ?>
                                                        </td>
                                                        <td>
                                                            <div><i class="dripicons-phone"></i> <?php echo htmlspecialchars($supplier['phone']); ?></div>
                                                            <?php if (!empty($supplier['mobile'])): ?>
                                                                <div><i class="dripicons-mobile"></i> <?php echo htmlspecialchars($supplier['mobile']); ?></div>
                                                            <?php endif; ?>
                                                            <?php if (!empty($supplier['email'])): ?>
                                                                <div><i class="dripicons-mail"></i> <?php echo htmlspecialchars($supplier['email']); ?></div>
                                                            <?php endif; ?>
                                                            <?php if (!empty($supplier['city'])): ?>
                                                                <div><i class="dripicons-location"></i> <?php echo htmlspecialchars($supplier['city']); ?></div>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <?php echo !empty($supplier['gst_number']) ? htmlspecialchars($supplier['gst_number']) : '<span class="text-muted">N/A</span>'; ?>
                                                        </td>
                                                        <td class="<?php echo $balance_class; ?> fw-bold">
                                                            ₹<?php echo number_format(abs($supplier['current_balance']), 2); ?>
                                                            <?php if ($supplier['current_balance'] > 0): ?>
                                                                <br><small class="text-danger">(Due from Supplier)</small>
                                                            <?php elseif ($supplier['current_balance'] < 0): ?>
                                                                <br><small class="text-success">(Due to Supplier)</small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <?php if ($supplier['credit_limit'] > 0): ?>
                                                                ₹<?php echo number_format($supplier['credit_limit'], 2); ?>
                                                            <?php else: ?>
                                                                <span class="text-muted">No Limit</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <span class="<?php echo $status_class; ?>"><?php echo $status_text; ?></span>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group" role="group">
                                                                <button type="button" class="btn btn-sm btn-light dropdown-toggle" data-bs-toggle="dropdown" aria-expanded="false">
                                                                    <i class="dripicons-gear"></i>
                                                                </button>
                                                                <ul class="dropdown-menu">
                                                                    <li>
                                                                        <a class="dropdown-item" href="view-supplier.php?id=<?php echo $supplier['id']; ?>">
                                                                            <i class="dripicons-preview"></i> View Details
                                                                        </a>
                                                                    </li>
                                                                    <li>
                                                                        <a class="dropdown-item" href="edit-supplier.php?id=<?php echo $supplier['id']; ?>">
                                                                            <i class="dripicons-pencil"></i> Edit
                                                                        </a>
                                                                    </li>
                                                                    <li>
                                                                        <a class="dropdown-item" href="supplier-transactions.php?supplier_id=<?php echo $supplier['id']; ?>">
                                                                            <i class="dripicons-document"></i> Transactions
                                                                        </a>
                                                                    </li>
                                                                    <li>
                                                                        <a class="dropdown-item" href="supplier-payments.php?supplier_id=<?php echo $supplier['id']; ?>">
                                                                            <i class="dripicons-briefcase"></i> Payments
                                                                        </a>
                                                                    </li>
                                                                    <li><hr class="dropdown-divider"></li>
                                                                    <li>
                                                                        <?php if ($supplier['status'] == 'active'): ?>
                                                                            <a class="dropdown-item text-warning" href="actions/supplier-status.php?id=<?php echo $supplier['id']; ?>&status=inactive" onclick="return confirm('Deactivate this supplier?')">
                                                                                <i class="dripicons-cross"></i> Deactivate
                                                                            </a>
                                                                        <?php else: ?>
                                                                            <a class="dropdown-item text-success" href="actions/supplier-status.php?id=<?php echo $supplier['id']; ?>&status=active" onclick="return confirm('Activate this supplier?')">
                                                                                <i class="dripicons-checkmark"></i> Activate
                                                                            </a>
                                                                        <?php endif; ?>
                                                                    </li>
                                                                    <li>
                                                                        <a class="dropdown-item text-danger" href="actions/delete-supplier.php?id=<?php echo $supplier['id']; ?>" onclick="return confirm('Are you sure? This will delete all supplier data including transactions.')">
                                                                            <i class="dripicons-trash"></i> Delete
                                                                        </a>
                                                                    </li>
                                                                </ul>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if ($total_pages > 1): ?>
                                    <div class="row mt-3">
                                        <div class="col-md-6">
                                            <p class="text-muted">
                                                Showing <?php echo ($start + 1); ?> to <?php echo min($start + $limit, $total_rows); ?> of <?php echo $total_rows; ?> entries
                                            </p>
                                        </div>
                                        <div class="col-md-6">
                                            <nav aria-label="Page navigation">
                                                <ul class="pagination justify-content-end">
                                                    <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); ?>">Previous</a>
                                                    </li>
                                                    
                                                    <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                        <li class="page-item <?php echo ($page == $i) ? 'active' : ''; ?>">
                                                            <a class="page-link" href="?page=<?php echo $i; ?>&search=<?php echo urlencode($search); ?>&status=<?php echo urlencode($status_filter); ?>"><?php echo $i; ?></a>
                                                        </li>
                                                    <?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); ?>">Next</a>
                                                    </li>
                                                </ul>
                                            </nav>
                                        </div>
                                    </div>
                                <?php endif; ?>

<div class="row mt-4">
                                    <div class="col-md-3">
                                        <div class="card bg-primary text-white mb-0">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div>
                                                        <h6 class="text-white-50 mb-1">Total Suppliers</h6>
                                                        <h4 class="mb-0"><?php echo $total_rows; ?></h4>
                                                    </div>
                                                    <div class="avatar-sm">
                                                        <span class="avatar-title bg-light text-primary rounded-circle fs-3">
                                                            <i class="dripicons-user-group"></i>
                                                        </span>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="card bg-success text-white mb-0">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div>
                                                        <h6 class="text-white-50 mb-1">Active</h6>
                                                        <?php
                                                        $active_sql = "SELECT COUNT(*) as count FROM suppliers WHERE status = 'active'";
                                                        $active_result = mysqli_query($conn, $active_sql);
                                                        $active_count = mysqli_fetch_assoc($active_result)['count'];
                                                        ?>
                                                        <h4 class="mb-0"><?php echo $active_count; ?></h4>
                                                    </div>
                                                    <div class="avatar-sm">
                                                        <span class="avatar-title bg-light text-success rounded-circle fs-3">
                                                            <i class="dripicons-checkmark"></i>
                                                        </span>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="card bg-warning text-white mb-0">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div>
                                                        <h6 class="text-white-50 mb-1">Total Due</h6>
                                                        <?php
                                                        $due_sql = "SELECT SUM(current_balance) as total FROM suppliers WHERE current_balance > 0";
                                                        $due_result = mysqli_query($conn, $due_sql);
                                                        $due_amount = mysqli_fetch_assoc($due_result)['total'] ?? 0;
                                                        ?>
                                                        <h4 class="mb-0">₹<?php echo number_format($due_amount, 2); ?></h4>
                                                    </div>
                                                    <div class="avatar-sm">
                                                        <span class="avatar-title bg-light text-warning rounded-circle fs-3">
                                                            <i class="dripicons-wallet"></i>
                                                        </span>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="card bg-info text-white mb-0">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div>
                                                        <h6 class="text-white-50 mb-1">Credit Given</h6>
                                                        <?php
                                                        $credit_sql = "SELECT SUM(credit_limit) as total FROM suppliers WHERE credit_limit > 0";
                                                        $credit_result = mysqli_query($conn, $credit_sql);
                                                        $credit_total = mysqli_fetch_assoc($credit_result)['total'] ?? 0;
                                                        ?>
                                                        <h4 class="mb-0">₹<?php echo number_format($credit_total, 2); ?></h4>
                                                    </div>
                                                    <div class="avatar-sm">
                                                        <span class="avatar-title bg-light text-info rounded-circle fs-3">
                                                            <i class="dripicons-card"></i>
                                                        </span>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

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

</div>
        </div>

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

</div>

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

// Quick search functionality
    const searchInput = document.querySelector('input[name="search"]');
    let searchTimeout;
    
    searchInput.addEventListener('input', function(e) {
        clearTimeout(searchTimeout);
        searchTimeout = setTimeout(function() {
            if (searchInput.value.length >= 3 || searchInput.value.length === 0) {
                e.target.form.submit();
            }
        }, 500);
    });

// Export to Excel
    document.getElementById('exportBtn').addEventListener('click', function() {
        // This would require server-side export functionality
        window.location.href = 'export-suppliers.php?search=<?php echo urlencode($search); ?>&status=<?php echo urlencode($status_filter); ?>';
    });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-suppliers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation