Notice: Undefined index: order_id in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_maj_facture_sagitta_v2.php on line 0
Notice: Undefined index: NoFacture in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_maj_facture_sagitta_v2.php on line 0
Erreur SQL !
select PF.code_uv,quantite,case when stock.code_fournisseur in (1276,1272,4606,4612) THEN '' ELSE SG.no_secteur END as no_secteur,MIN(SP.id_colis) as id_colis,
P.cip,P.cip13,P.ean
from (prod_factures as PF left join stock on PF.code_uv=stock.code_uv) left join (sag_factcmde as SF left join (sag_colis as SC left join
(sag_prodcolis SP left join (produit P left join sag_geos SG on P.code_geo=SG.code_geo) on SP.code_uv=P.code_uv) on SC.id_colis=SP.id_colis) on SF.id_cmde=SC.id_cmde) on PF.Nofacture=SF.NoFacture
Where PF.NoFacture = And (PF.code_uv = SP.code_uv or stock.code_fournisseur in (1276,1272,4606,4612)) AND (PF.sales_remontees is null or PF.sales_remontees=2) group by PF.code_uv,P.cip,P.cip13,P.ean,quantite,case when stock.code_fournisseur in (1276,1272,4606,4612) THEN '' ELSE SG.no_secteur END,stock.code_fournisseur