Production rapide
livraison partout au Canada

Mes commandes



Rechercher

ERREUR: (SELECT c.Id as Id_Commande, c.Id_Soumission, cd.Id as Id_Detail, cd.Lettre, c.En_Livraison, c.No_Livraison, c.En_Livraison_User, c.The_Date_Commande, c.No_Commande, CONCAT(u.Prenom, ' ', u.Nom) AS nom_complet, CONCAT(IF(ca.Use_Cat_LongueDesc = 1, ca.LongueDesc, sc.LongueDesc), ' - ', sc.NomSouscat, ' X ', p.NomProduit) AS NomProduit, au.Cie, tl.Nom, cd.En_Pre_Prod, cd.En_Prod, cd.En_Finition, cd.En_Termine, cd.En_Pre_Prod_User, cd.En_Prod_User, cd.En_Finition_User, cd.En_Termine_User, c.Fichier_Pdf FROM Utilisateurs u INNER JOIN Commandes c ON (u.Id = c.Id_User) INNER JOIN Type_Livraison tl ON (c.Type_Livraison = tl.Id) INNER JOIN Commande_Detail cd ON (c.Id = cd.Id_Commande) INNER JOIN Adresses_User au ON (c.Id_Adresse_Facturation = au.Id) INNER JOIN Produits p ON (cd.Id_Produit = p.Id) INNER JOIN Souscat sc ON (sc.Id = p.Id_Souscat) INNER JOIN Categories ca ON (sc.Id_Categorie = ca.Id) INNER JOIN Grande_Categories gc ON (ca.Id_GCategorie = gc.Id) INNER JOIN Tres_Grande_Categories tgcat ON gc.Id_TGCat = tgcat.Id LEFT JOIN Couleurs ON (Couleurs.Id = c.Couleur) WHERE c.Id_User = AND c.isPaye = 1 AND au.estPrincipale = 1 AND (c.The_Date_Commande BETWEEN '2020-03-16' AND '2020-03-30 23:59:59')) UNION ALL ( SELECT c.Id as Id_Commande, c.Id_Soumission, sd.Id as Id_Detail, 'S' AS Lettre, c.En_Livraison, c.No_Livraison, c.En_Livraison_User, c.The_Date_Commande, c.No_Commande, CONCAT(u.Prenom, ' ', u.Nom) AS nom_complet, sd.Description as nomProduit, au.Cie, tl.Nom, sd.En_Pre_Prod, sd.En_Prod, sd.En_Finition, sd.En_Termine, sd.En_Pre_Prod_User, sd.En_Prod_User, sd.En_Finition_User, sd.En_Termine_User, c.Fichier_Pdf FROM Commandes c INNER JOIN Utilisateurs u ON c.Id_User = u.Id INNER JOIN Adresses_User au ON c.Id_User = au.Id_User INNER JOIN Type_Livraison tl ON c.Type_Livraison = tl.Id INNER JOIN Soumission_Detail sd ON c.Id_Soumission = sd.Id_Soumission WHERE c.Id_User = AND (sd.Item_Obligatoire = 1 OR sd.Item_Selectionne = 1) AND sd.Afficher_Etats_Commande = 1 AND c.Id_Soumission > 0 AND c.isPaye = 1 AND au.estPrincipale = 1 AND (c.The_Date_Commande BETWEEN '2020-03-16' AND '2020-03-30 23:59:59')) UNION ALL (SELECT c.Id AS Id_Commande, c.Id_Proposition_Web, pd.Id AS Id_Detail, 'P' AS Lettre, NULL, NULL, NULL, c.The_Date_Commande, c.No_Commande, CONCAT(au.Prenom, ' ', au.Nom) AS nom_complet, pd.Description AS NomProduit, au.Cie, 'Web', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, c.Fichier_Pdf FROM Commandes c LEFT JOIN Propositions p ON c.Id_Proposition_Web = p.Id LEFT JOIN Proposition_Detail pd ON pd.Id_Proposition = p.Id LEFT JOIN Adresses_User au ON au.Id = p.Id_Contact_Client WHERE c.Id_User = AND (pd.Selected = 1 OR pd.Obligatoire = 1) AND (c.The_Date_Commande BETWEEN '2020-03-16' AND '2020-03-30 23:59:59')) ORDER BY Id_Commande
# Date d'ajout Produit Pré-Production Production Finition Terminé Livraison Type Livraison