summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAzka Nathan <darizkyfaz@gmail.com>2025-01-21 14:57:10 +0700
committerAzka Nathan <darizkyfaz@gmail.com>2025-01-21 14:57:10 +0700
commit25ea83dd6a1f8ff272fd086a998904ed792b1041 (patch)
tree8a82b50748d0cbeb0f38db71bc08aeeaa6199cd9
parente072cbf06a86cb376d71c0490f0f48c6de1fd3f7 (diff)
fix bug pj
-rw-r--r--indoteknik_custom/models/purchasing_job.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/indoteknik_custom/models/purchasing_job.py b/indoteknik_custom/models/purchasing_job.py
index 4efb0cd4..902bc34b 100644
--- a/indoteknik_custom/models/purchasing_job.py
+++ b/indoteknik_custom/models/purchasing_job.py
@@ -183,6 +183,7 @@ class OutstandingSales(models.Model):
join product_template pt on pt.id = pp.product_tmpl_id
left join x_manufactures xm on xm.id = pt.x_manufacture
where sp.state in ('draft', 'waiting', 'confirmed', 'assigned')
+ and sm.state in ('draft', 'waiting', 'confirmed', 'partially_available')
and sp.name like '%OUT%'
)
""")