diff options
Diffstat (limited to 'SJTele.ktr')
| -rw-r--r-- | SJTele.ktr | 20 |
1 files changed, 16 insertions, 4 deletions
@@ -652,19 +652,31 @@ sp.name AS picking_name, sp.sale_id AS sale_id, so.name AS sale_name, + so.state AS sale_state, sp.create_date, sp.date_doc_kirim FROM stock_picking sp LEFT JOIN report_logbook_sj_line rlsl - ON rlsl.picking_id = sp.id - OR (rlsl.name IS NOT NULL AND rlsl.name = sp.name) + ON rlsl.picking_id = sp.id + OR (rlsl.name IS NOT NULL AND rlsl.name = sp.name) JOIN sale_order so - ON so.id = sp.sale_id + ON so.id = sp.sale_id WHERE sp.picking_type_id = 29 AND (sp.state = 'done' OR sp.date_done IS NOT NULL) AND sp.create_date >= '2025-01-01 00:00:00' AND rlsl.id IS NULL - AND so.name NOT ILIKE '%CANCEL%' + AND so.state IN ('sale','done') + AND NOT EXISTS ( + SELECT 1 + FROM account_move am + JOIN account_move_line aml ON aml.move_id = am.id + JOIN sale_order_line_invoice_rel rel ON rel.invoice_line_id = aml.id + JOIN sale_order_line sol ON sol.id = rel.order_line_id + WHERE sol.order_id = so.id + AND am.move_type = 'out_invoice' + AND am.state = 'posted' + AND am.payment_state = 'paid' + ) ORDER BY sp.create_date DESC; </sql> <limit>0</limit> |