diff options
| author | Azka Nathan <darizkyfaz@gmail.com> | 2025-01-21 10:48:25 +0700 |
|---|---|---|
| committer | Azka Nathan <darizkyfaz@gmail.com> | 2025-01-21 10:48:25 +0700 |
| commit | e3521c2153c36cee6629cee9146e1b4b0201da9f (patch) | |
| tree | 9819e5dbf929f3615dd18f0ca3e0b42ed4970a2a | |
| parent | 696d5e4bf41b927300102293e5027778ffdc9296 (diff) | |
cr purchasing job
| -rw-r--r-- | indoteknik_custom/models/purchasing_job.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/indoteknik_custom/models/purchasing_job.py b/indoteknik_custom/models/purchasing_job.py index 4efb0cd4..74b5134e 100644 --- a/indoteknik_custom/models/purchasing_job.py +++ b/indoteknik_custom/models/purchasing_job.py @@ -182,7 +182,7 @@ class OutstandingSales(models.Model): join product_product pp on pp.id = sm.product_id 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') + where sp.state in ('draft', 'waiting', 'confirmed') and sp.name like '%OUT%' ) """) |