$date = isset($_GET['date']) ? $_GET['date'] : date("Y-m-d");
$magasin = isset($_GET['magasin']) ? $_GET['magasin'] : "Tous";
$where_magasin = ($magasin != "Tous") ? "AND magasin='$magasin'" : "";

$sql = "SELECT * FROM commandes_fournisseurs WHERE date_commande = '$date' $where_magasin";
$result = $conn->query($sql);

$html = "
<h2>📦 Commande Fournisseur - $magasin</h2>
<p><b>Date :</b> $date</p>
";