Analyse de l'ordonnance


Notice: Undefined variable: uv in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_analordo.php on line 0

Notice: Undefined variable: qtes in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_analordo.php on line 0

Notice: Undefined variable: index_assure in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_analordo.php on line 0
Erreur SQL !
select code_uv,cip_prod,nom_prod,factures.nofacture,dbo.formatdate(factures.datefacture,'dd/mm/yyyy'),sum(quantite) from prod_factures left join factures on prod_factures.nofacture=factures.nofacture where index_assure= and factures.datefacture>=dateadd(year,-1,getdate()) and factures.index_typefacture not in (9,20,21,22,23) and code_uv in () group by code_uv,factures.datefacture,cip_prod,nom_prod,factures.nofacture,factures.index_typefacture order by CASE WHEN code_uv= THEN 0 END,factures.datefacture desc,factures.nofacture
CIP Produits Quantité Date Facture Ecart N° Facture