Erreur : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.numero_client' in 'SELECT'<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
<style>
    html,
    body {
        height: 100%;
        margin: 0;
    }

    /* BODY layout */
    body {
        background: #f4f6f8;
    }

    /* SIDEBAR FIXE */
    .sidebar {
        position: fixed;
        left: 0;
        top: 0;
        width: 400px;
        height: 100%;
        /* hauteur écran */
        background: #ffffff;
        color: white;
        padding: 20px;
        overflow-y: auto;
        /* scroll si menu long */
        top: 68px;
        /* descend sous le header */
        /* height: calc(100vh - 30px); */
        overflow-y: auto;
        /* ✅ scroll vertical */
    }

    /* CONTENT */
    .content {
        margin-left: 400px;
        /* espace pour sidebar */
        height: 100vh;
        padding: 20px;
        overflow-y: auto;
        /* scroll indépendant */
    }



    .sidebar h2 {
        margin-bottom: 20px;
        font-size: 18px;
        text-align: center;
    }

    .sidebar ul {
        list-style: none;
    }

    .sidebar li {
        padding: 12px;
        cursor: pointer;
        border-radius: 6px;
        margin-bottom: 6px;
        transition: background 0.2s;
    }


    .sidebar li:hover {
        background: #ed1c24;
    }

    .sidebar li:hover a {
        color: #ffffff;
    }



    .table-container {
        background: white;
        padding: 20px;
        border-radius: 10px;
        box-shadow: 0 4px 12px rgba(0, 0, 0, 0.08);
        height: 80%;
        /* prend presque toute la hauteur */
        overflow: auto;
        /* scroll vertical si beaucoup de lignes */
    }

    h3 {
        margin-bottom: 15px;
    }

    table {
        width: 100%;
        border-collapse: collapse;
    }

    th,
    td {
        padding: 12px;
        border-bottom: 1px solid #e5e7eb;
        text-align: left;
        white-space: nowrap;
        /* évite le retour à la ligne pour garder le scroll horizontal */
    }

    th {
        background: #f1f5f9;
    }

    /* Settings submenu */
    .settings {
        display: flex;
        justify-content: space-between;
        align-items: center;
    }

    .submenu {
        list-style: none;
        margin-left: 15px;
        max-height: 0;
        overflow: hidden;
        transition: max-height 0.3s ease;
    }

    .submenu.open {
        max-height: 300px;
    }

    .arrow {
        transition: transform 0.3s ease;
    }

    .settings.active .arrow {
        transform: rotate(90deg);
    }

    .submenu li {
        padding: 10px;
        font-size: 14px;
        /* background: #2c2c2c; */
    }



    /* Responsive */
    @media (max-width: 900px) {
        body {
            flex-direction: column;
        }

        .sidebar {
            width: 100%;
            display: flex;
            flex-wrap: wrap;
            justify-content: center;
        }

        .sidebar ul {
            display: flex;
            flex-wrap: wrap;
            justify-content: center;
        }

        .sidebar li {
            width: 48%;
            text-align: center;
        }

        .submenu {
            width: 100%;
        }

        .content {
            padding: 15px;
        }

        .table-container {
            overflow-x: auto;
        }

        table {
            min-width: 600px;
        }
    }

    /* Liens du sidebar */
    .sidebar li a {
        color: #ed1c24;
        text-decoration: none;
        display: block;
        width: 100%;
    }

    @media (max-width: 480px) {
        .sidebar li {
            width: 100%;
        }

        h3 {
            font-size: 16px;
        }
    }

    .submenu {
        list-style: none;
        margin-left: 15px;
        max-height: 0;
        overflow: hidden;
        transition: max-height 0.3s ease;
    }

    .submenu.open {
        max-height: 400px;
    }

    .menu-title {
        cursor: pointer;
        display: flex;
        justify-content: space-between;
        align-items: center;
        color: #ed1c24;
    }

    .arrow {
        font-size: 12px;
    }

    /* responsivite */
    /* HAMBURGER BUTTON */
    .hamburger {
        display: none;
        position: fixed;
        top: 15px;
        left: 15px;
        font-size: 26px;
        background: #946137;
        color: white;
        padding: 8px 12px;
        border-radius: 6px;
        cursor: pointer;
        z-index: 1001;
    }

    /* TABLETTE + TELEPHONE */
    @media (max-width: 900px) {

        .hamburger {
            display: block;
        }

        .sidebar {
            transform: translateX(-100%);
            transition: 0.3s;
            z-index: 1000;
        }

        .sidebar.open {
            transform: translateX(0);
        }

        .content {
            margin-left: 0;
            padding-top: 60px;
        }

        .content {
            margin-top: 60px;
        }
    }

    /*  */
    .user-box {
        background: #ffffff;
        padding: 25px;
        /* border-radius: 10px; */
        margin-bottom: 20px;
        color: #333;
    }

    .user-name {
        font-weight: bold;
        font-size: 14px;
        margin-bottom: 5px;
        text-align: center;
    }

    .user-status {
        font-size: 12px;
        color: #888;
        /* display: flex; */
        text-align: center;
        gap: 6px;
        font-size: 12px;
        font-weight: 600;
        margin-bottom: 15px;
    }

    .dot {
        width: 8px;
        height: 8px;
        background: #4CAF50;
        border-radius: 50%;
        display: inline-block;
    }

    .search-box {
        margin-top: 15px;
        width: 100%;
        padding: 10px;
        border-radius: 6px;
        border: 1px solid #ddd;
        outline: none;
    }

    /*  */
    .sidebar li a {
        display: flex;
        align-items: center;
        gap: 10px;
        /* espace entre icône et texte */
        color: #ed1c24;
        text-decoration: none;
    }

    .sidebar li i {
        font-size: 16px;
    }

    /*  */
    .menu-title {
        padding: 12px;
        display: flex;
        justify-content: space-between;
        align-items: center;
        cursor: pointer;
        transition: all 0.3s ease;
    }

    /* Hover background */
    .menu-title:hover {
        background: #ed1c24;
    }

    /* Texte + icône */
    .menu-title:hover span,
    .menu-title:hover i {
        color: #ffffff;
    }

    /* Animation icône */
    .menu-title i {
        transition: 0.3s;
    }

    .menu-title:hover i {
        transform: scale(1.1);
    }
    .submenu.open{
    max-height: 200px;
    overflow-y: auto;
    padding-right: 5px;
}
</style>
<div class="hamburger" onclick="toggleMenu()">☰</div>
<div class="sidebar">
    <div class="user-box">
        <div class="user-info">
            <div class="user-name">Jean Dupont</div>
            <div class="user-status">
                <span class="dot"></span> EN LIGNE
            </div>
        </div>
        <hr>

        <input type="text" placeholder="Recherche Ticket..." class="search-box">
    </div>
    <ul class="menu">

        <!-- Dashboard -->
        <li class="">
            <a href="https://arsmateriaux.com/index.php">
                <i class="fas fa-home"></i>
                <span>Dashboard</span>
            </a>
        </li>

        <!-- Rapports -->
        <li class="menu-item">
            <div class="menu-title">
                <span><i class="fa-solid fa-closed-captioning"></i> Rapports</span>
                <span class="arrow"><i class="fas fa-plus"></i></span>
            </div>
            <ul class="submenu">
                <li><a href="https://arsmateriaux.com/Rapports/vente_detailles.php">Ventes détaillées</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/vente_mensuel.php">Ventes par mois</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/factures.php">Factures</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/caisse.php">Caisse</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/clients.php">Clients</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/prodruits.php">Produits</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/Chargement_sortie.php">Chargement / Sortie</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/transport.php">Transport</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/paiements.php">Paiements</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/fournisseurs.php">Fournisseurs</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/receptions.php">Réceptions</a></li>
                <li><a href="https://arsmateriaux.com/Rapports/reception_journaliere.php">Réceptions journalières</a></li>
            </ul>
        </li>

        <!-- Catalogue -->
        <li class="menu-item">
            <div class="menu-title">
                <span><i class="fas fa-shopping-cart"></i> Catalogue</span>
                <span class="arrow"><i class="fas fa-plus"></i></span>
            </div>
            <ul class="submenu">
                <li><a href="https://arsmateriaux.com/Catalogue/prodruits.php">Produits</a></li>
                <li><a href="https://arsmateriaux.com/Catalogue/categories.php">Catégories</a></li>
                <li><a href="https://arsmateriaux.com/Catalogue/add_product.php">Nouveau produit</a></li>
            </ul>
        </li>

        <!-- Réceptions -->
        <li class="menu-item">
            <div class="menu-title">
                <span><i class="fas fa-sync-alt"></i> Réceptions</span>
                <span class="arrow"><i class="fas fa-plus"></i></span>
            </div>
            <ul class="submenu">
                <li><a href="https://arsmateriaux.com/Receptions/index-r.php">Fournisseurs</a></li>
                <li><a href="https://arsmateriaux.com/Receptions/Prodruits.php">Produits</a></li>
                <li><a href="https://arsmateriaux.com/Receptions/contraventions.php">Contraventions</a></li>
                <li><a href="https://arsmateriaux.com/Receptions/receptions.php">Réceptions</a></li>
                <li><a href="https://arsmateriaux.com/Receptions/paiements.php">Paiements</a></li>
                <li><a href="https://arsmateriaux.com/Receptions/rapport.php">Rapport</a></li>
                <li><a href="https://arsmateriaux.com/Receptions/add_reception.php">Nouvelle réception</a></li>
            </ul>
        </li>

        <!-- Utilisateurs -->
        <li class="menu-item">
            <div class="menu-title">
                <span><i class="fas fa-users"></i> Utilisateurs</span>
                <span class="arrow"><i class="fas fa-plus"></i></span>
            </div>
            <ul class="submenu">
                <li><a href="https://arsmateriaux.com/Utilisateurs/index-u.php">Utilisateurs</a></li>
                <li><a href="https://arsmateriaux.com/Utilisateurs/roles_user.php">Rôles</a></li>
                <li><a href="https://arsmateriaux.com/Utilisateurs/cartes.php">Cartes</a></li>
                <li><a href="https://arsmateriaux.com/Utilisateurs/add_user.php">Nouvel utilisateur</a></li>
            </ul>
        </li>

        <!-- Clients -->
        <li class="menu-item">
            <div class="menu-title">
                <span><i class="fas fa-user"></i> Clients</span>
                <span class="arrow"><i class="fas fa-plus"></i></span>
            </div>
            <ul class="submenu">
                <li><a href="https://arsmateriaux.com/Clients/index-c.php">Clients</a></li>
                <li><a href="https://arsmateriaux.com/Clients/paiement.php">Paiements</a></li>
                <li><a href="https://arsmateriaux.com/Clients/special.php">Spécials</a></li>
                <li><a href="https://arsmateriaux.com/Clients/simulation.php">Simulation</a></li>
                <li><a href="https://arsmateriaux.com/Clients/requisition.php">Réquisitions</a></li>
                <li><a href="https://arsmateriaux.com/Clients/add_client.php">Nouveau client</a></li>
            </ul>
        </li>

        <!-- Camions -->
        <li>
            <a href="https://arsmateriaux.com/camion.php">
                <i class="fas fa-truck"></i>
                <span>Camions</span>
            </a>
        </li>

        <!-- Configuration -->
        <li class="menu-item">
            <div class="menu-title">
                <span><i class="fas fa-cog"></i> Configuration</span>
                <span class="arrow"><i class="fas fa-plus"></i></span>
            </div>
            <ul class="submenu">
                <li><a href="https://arsmateriaux.com/Configuration/pos.php">POS</a></li>
                <li><a href="https://arsmateriaux.com/Configuration/taux_du_jour.php">Taux du jour</a></li>
                <li><a href="https://arsmateriaux.com/Configuration/coffre.php">Coffre</a></li>
                <li><a href="https://arsmateriaux.com/Configuration/motifs.php">Motifs</a></li>
                <li><a href="https://arsmateriaux.com/Configuration/paiements.php">Paiements</a></li>
            </ul>
        </li>

        <!-- Déconnexion -->
        <li>
            <a href="https://arsmateriaux.com/logout.php">
                <i class="fa-solid fa-power-off"></i>
                <span>Déconnexion</span>
            </a>
        </li>

    </ul>
</div>

<script>
    document.querySelectorAll(".menu-title").forEach(function(menu) {

        menu.addEventListener("click", function() {

            let submenu = this.parentElement.querySelector(".submenu");
            let arrow = this.querySelector(".arrow");

            submenu.classList.toggle("open");

            if (submenu.classList.contains("open")) {
                arrow.innerHTML = '<i class="fas fa-minus"></i>';

                const menuTitle = submenu.closest(".menu-item")?.querySelector(".menu-title");
                const menuItem = submenu.closest(".menu-item");
                const links = submenu.querySelectorAll("a");
                if (menuTitle) {
                    menuTitle.style.color = "#fffefe";
                    links.forEach(link => link.style.color = "#fffefe");

                    menuItem.style.backgroundColor = "#ed1c24";
                }

            } else {
                arrow.innerHTML = '<i class="fas fa-plus"></i>';

                const menuTitle = submenu.closest(".menu-item")?.querySelector(".menu-title");
                if (menuTitle) {
                    menuTitle.style.color = "";
                    submenu.closest(".menu-item").style.backgroundColor = "";
                }
            }

        });

    });

    //////////////////////////////////////////////////////////////////////////////////
    function toggleMenu() {
        document.querySelector(".sidebar").classList.toggle("open");
    }
</script><style>
    .topbar{
    position: fixed;
    top: 0;
    left: 0; /* IMPORTANT */
    width: 100%; /* IMPORTANT */
    height: 80px;
    background: #ed1c24;
    display: flex;
    justify-content: space-between;
    align-items: center;
    padding: 0 20px;
    color: white;
    z-index: 2000; /* plus haut que sidebar */
}

/* LEFT */
.topbar-left h2{
    font-size: 20px;
    font-weight: bold;
}

/* RIGHT */
.topbar-right{
    display: flex;
    align-items: center;
    gap: 10px;
}

.topbar-right input{
    height: 35px;
    border-radius: 5px;
    border: none;
    padding: 0 10px;
}

/* bouton vert */
.btn-check{
    background: #5dab09;
    border: none;
    color: white;
    padding: 8px 12px;
    border-radius: 5px;
    cursor: pointer;
}

/* icone user */
.user-icon{
    background: #444;
    padding: 8px 10px;
    border-radius: 50%;
    font-size: 16px;
}

/* AJUSTER LE CONTENT */
    .content{
        margin-left: 420px; /* Aligned with sidebar.php 400px */
        margin-top: 60px; /* IMPORTANT */
        padding: 20px;
    }

    .breadcrumb-bar-inner {
        background-color: #f4f7f9;
        padding: 10px 20px;
        display: flex;
        justify-content: space-between;
        align-items: center;
        border-bottom: 1px solid #e1e4e8;
        font-size: 13px;
        color: #555;
        margin-bottom: 20px;
    }

    .breadcrumb-inner {
        display: flex;
        align-items: center;
        gap: 5px;
        color: #94a3b8;
    }

    .breadcrumb-inner a {
        color: #ed1c24;
        text-decoration: none;
    }

    .excel-box-inner .btn-excel-top-inner {
        background-color: #000;
        color: white;
        border: none;
        padding: 5px 12px;
        font-size: 12px;
        font-weight: bold;
        border-radius: 2px;
        cursor: pointer;
    }

    .report-title-inner {
        font-size: 24px;
        font-weight: 500;
        color: #666;
        margin: 0 0 25px 20px;
    }

            .facture-report-inner .facture-topbar {
            /* background-color: #2b2b2b; */
            padding: 8px 20px;
            display: flex;
            align-items: center;
            gap: 8px;
            font-size: 13px;
        }

        .facture-report-inner .facture-topbar a {
            color: #3b82f6;
            text-decoration: none;
        }

        .facture-report-inner .facture-topbar a:hover {
            color: #a8dff5;
        }

        .facture-report-inner .facture-topbar .crumb-text {
            color: #7ec8e3;
        }

        .facture-report-inner .facture-wrap {
            padding: 20px;
        }

        .facture-report-inner .facture-card {
            background: #ffffff;
            border: 1px solid #e8e8e8;
            box-shadow: 0 2px 8px rgba(0, 0, 0, 0.06);
            padding: 24px 28px 28px;
            max-width: 100%;
        }

        .facture-report-inner .facture-title {
            font-size: 26px;
            font-weight: 500;
            color: #9e9e9e;
            margin-bottom: 22px;
        }

        .facture-report-inner .facture-form-row {
            display: flex;
            align-items: center;
            gap: 10px;
            margin-bottom: 22px;
        }

        .facture-report-inner .facture-select {
            border: 1px solid #ccc;
            padding: 8px 12px;
            font-size: 14px;
            color: #555;
            background: #fff;
            min-width: 220px;
            outline: none;
        }

        .facture-report-inner .facture-select:focus {
            border-color: #aaa;
        }

        .facture-report-inner .btn-valider {
            background-color: #8bc34a;
            color: #fff;
            border: none;
            padding: 8px 18px;
            font-size: 14px;
            font-weight: 600;
            cursor: pointer;
            border-radius: 2px;
        }

        .facture-report-inner .btn-valider:hover {
            background-color: #7cb342;
        }

        .facture-report-inner .facture-table-wrap {
            border: 1px solid #e0e0e0;
            overflow-x: auto;
        }

        .facture-report-inner .facture-table {
            width: 100%;
            border-collapse: collapse;
            font-size: 13px;
        }

        .facture-report-inner .facture-table th {
            background: #fff;
            color: #424242;
            font-weight: 700;
            padding: 12px 10px;
            text-align: center;
            border: 1px solid #e0e0e0;
            white-space: nowrap;
        }

        .facture-report-inner .facture-table th .th-sort {
            display: inline-flex;
            align-items: center;
            gap: 6px;
            justify-content: center;
        }

        .facture-report-inner .facture-table th .th-sort i {
            font-size: 10px;
            color: #757575;
            font-weight: 400;
        }

        .facture-report-inner .facture-table td {
            padding: 28px 12px;
            border: 1px solid #e0e0e0;
            color: #9e9e9e;
            text-align: center;
        }

        .facture-report-inner .facture-table td.placeholder-cell {
            font-size: 14px;
            color: #b0b0b0;
        }

        .facture-report-inner .visually-hidden {
            position: absolute;
            width: 1px;
            height: 1px;
            padding: 0;
            margin: -1px;
            overflow: hidden;
            clip: rect(0, 0, 0, 0);
            white-space: nowrap;
            border: 0;
        }
</style>

<div class="content">
    <div class="topbar">
        <div class="topbar-left">
            <h2>VFMATERIAUX</h2>
        </div>

        <div class="topbar-right">
            <input type="date">
            <input type="date">

            <button class="btn-check">✔</button>

            <div class="user-icon">👤</div>
        </div>
    </div>

    <div class="breadcrumb-bar-inner">
        <div class="breadcrumb-inner">
            <a href="index.php"><i class="fas fa-home"></i></a>
            <span>/ Rapports Factures</span>
        </div>
        <div class="excel-box-inner">
            <button class="btn-excel-top-inner">Excel</button>
        </div>
    </div>

    <h1 class="report-title-inner">Factures</h1>

    
<div class="facture-report-inner">

           <form class="facture-form-row" method="get" action="">
                <label for="client" class="visually-hidden">Client</label>

                <select id="client" name="client" class="facture-select">
                    <option value="">-- Client --</option>

                                            <option value="9">
                            1234567 - wefrgthy                        </option>
                                            <option value="8">
                            12312 - wefrgthy                        </option>
                                            <option value="7">
                            9 - wefrgthy                        </option>
                                            <option value="3">
                            6031 - Compagnie C                        </option>
                                            <option value="2">
                            6030 - Compagnie B                        </option>
                                            <option value="1">
                            6029 - Compagnie A                        </option>
                    
                </select>

                <button type="submit" class="btn-valider">Valider</button>
            </form>

            <div class="facture-table-wrap">
                <table class="facture-table">
                    <thead>
                        <tr>
                            <th>Date</th>
                            <th>Heure</th>
                            <th>
                                <span class="th-sort">Vente #</span>
                            </th>
                            <th>Camion</th>
                            <th>Produit</th>
                            <th>Volume</th>
                            <th>Total</th>
                        </tr>
                    </thead>
                     <tbody>
                                                    <tr>
                                <td colspan="7">Aucune facture trouvée</td>
                            </tr>
                                            </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

</div>