diff options
| author | Azka Nathan <darizkyfaz@gmail.com> | 2024-08-13 09:01:54 +0700 |
|---|---|---|
| committer | Azka Nathan <darizkyfaz@gmail.com> | 2024-08-13 09:01:54 +0700 |
| commit | 64b78ce44b4268abf406f1c6fbf8793a9499890b (patch) | |
| tree | edd7710157498c47b094645519636ba66f9f050e | |
| parent | 7cfd00b84322965c86b40c481a9fa158c3277475 (diff) | |
update pj
| -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 373e469a..da783ab1 100644 --- a/indoteknik_custom/models/purchasing_job.py +++ b/indoteknik_custom/models/purchasing_job.py @@ -96,7 +96,7 @@ class PurchasingJob(models.Model): ) AS sub ON sub.product_id = pmp.product_id LEFT JOIN latest_purchase_orders po ON po.product_id = pmp.product_id LEFT JOIN random_user_ids ru ON ru.vendor_id = sub.vendor_id OR (ru.vendor_id IS NULL AND sub.vendor_id != 9688) - WHERE pmp.action = 'kurang' + WHERE pmp.po_number = 'kosong' and pmp.action = 'kurang' AND sub.vendor_id IS NOT NULL GROUP BY pmp.product_id, |