From ca41c5daf852cc35164735a47e452a4495301463 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Fri, 12 Aug 2022 16:33:32 +0700 Subject: fix query sales monitoring --- indoteknik_custom/models/sale_monitoring.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/indoteknik_custom/models/sale_monitoring.py b/indoteknik_custom/models/sale_monitoring.py index e82fe380..6fabb2df 100644 --- a/indoteknik_custom/models/sale_monitoring.py +++ b/indoteknik_custom/models/sale_monitoring.py @@ -47,7 +47,7 @@ class SaleMonitoring(models.Model): JOIN product_product p ON p.id = sol.product_id JOIN product_template pt ON pt.id = p.product_tmpl_id WHERE pt.type IN ('consu','product') - AND so.state IN ('sale') + AND so.state IN ('sale','done') AND so.create_date >= '2022-08-10' ) a where -- cgit v1.2.3