1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
| SELECT
l.id,
l.product as product_id,
qty_chargement as qty_chargement,
ids,
conditionnement,
date as date,
state,
l.vendor_id as vendor_id,
company_id as company_id,
(i.qty / conditionnement) as qty_facture
FROM
(SELECT SUM(l.ecart_fadro) as qty_chargement, l.product, l.conditionnement,
s.date,
s.state,
s.vendor_id,
s.company_id,
min(l.id) as id
FROM sa_dechargement s
JOIN sa_dechargement_line l on (l.dechargement_id=s.id)
GROUP BY s.date,l.product,s.state,s.company_id ,s.vendor_id,l.conditionnement, l.id
) l
left join (
SELECT (MAX(li.id)) as ids, NULLIF(SUM(li.quantity),0) as qty,
li.product_id, li.vendor_id, a.date_invoice
FROM account_invoice a
join account_invoice_line li
on (li.invoice_id=a.id)
GROUP BY li.product_id, li.vendor_id, a.date_invoice ,li.id
) i
ON i.product_id =l.product and i.vendor_id = l.vendor_id and l.date= i.date_invoice |
