diff options
| author | Mqdd <ahmadmiqdad27@gmail.com> | 2026-01-28 11:07:14 +0700 |
|---|---|---|
| committer | Mqdd <ahmadmiqdad27@gmail.com> | 2026-01-28 11:07:14 +0700 |
| commit | 87abb539133d4f97c8a9cb9708a472c00a64e069 (patch) | |
| tree | 94cc59f27fdfd6990fa13a2b6afed352bcacc250 | |
| parent | 6ddc8876d34b9f85e3b8f546221feadd5fce43b0 (diff) | |
<Miqdad> change status
| -rw-r--r-- | fixco_custom/models/reordering_rule.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py index f1e0f9d..c95e611 100644 --- a/fixco_custom/models/reordering_rule.py +++ b/fixco_custom/models/reordering_rule.py @@ -105,13 +105,13 @@ class ReorderingRule(models.Model): COALESCE(SUM(sq.quantity), 0.0) + vmsbm.incoming_qty ) < vmsbm.min_stock - THEN 'MINUS STOCK' + THEN 'BUY' WHEN ( COALESCE(SUM(sq.quantity), 0.0) + vmsbm.incoming_qty ) <= (vmsbm.min_stock + vmsbm.buffer_stock) - THEN 'LOW STOCK' + THEN 'HOLD' ELSE 'READY STOCK' END AS stock_status |