Produits constatés d’avances de la maintenance :
– Faire la requête suivante :

SELECT distinct id.`id_invoice_detail`,id.`id_invoice`,c.name,i.ref,id.`description`,IF(p.account_code_sales,p.account_code_sales,pc.account_code_sales) as code_compta,id.amount,`date_end`,datediff(`date_end`,`date_start`)+1 as totaljour,datediff(`date_end`,'2023-03-31') as nbjour, (datediff(`date_end`,'2023-03-31') * id.amount / (datediff(`date_end`,`date_start`)+1)) as totalreport
FROM `swan_invoice_detail` id 
INNER JOIN `swan_invoice` i on id.`id_invoice`=i.`id_invoice` 
INNER JOIN `swan_company` c on i.id_company = c.id_company 
INNER JOIN `swan_product` p on id.id_product = p.id_product
INNER JOIN `swan_product` pc on p.id_product_category = pc.id_product_category
WHERE i.date_creation>='2022-04-01' AND i.date_creation<='2023-03-31' AND id.`date_end`>'2023-03-31'

– Corriger les erreurs de dates de dyslexie de Marie (nb total de jour >365)
-Faire le total de la colonne totalreport