diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2022-08-12 16:33:32 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2022-08-12 16:33:32 +0700 |
| commit | ca41c5daf852cc35164735a47e452a4495301463 (patch) | |
| tree | 1d184902a600e69bd29f5b9f2ac236a2c394c72f | |
| parent | 57d450627013892f95bbdfd1cf0ba93eb8aebcf4 (diff) | |
fix query sales monitoring
| -rw-r--r-- | indoteknik_custom/models/sale_monitoring.py | 2 |
1 files changed, 1 insertions, 1 deletions
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 |