summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAzka Nathan <darizkyfaz@gmail.com>2026-01-29 13:56:20 +0700
committerAzka Nathan <darizkyfaz@gmail.com>2026-01-29 13:56:20 +0700
commit45f6be90d1e5f620df1480eb8eefc24dfd552c43 (patch)
tree36f3eb2df7458787c2ac7300c11b583e103901aa
parentb7aff589190d505ba14ee5364253aab0f1012ded (diff)
PUSH
-rw-r--r--fixco_custom/models/reordering_rule.py6
-rw-r--r--fixco_custom/views/upload_payments.xml1
2 files changed, 4 insertions, 3 deletions
diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py
index 9f37da6..49a5fab 100644
--- a/fixco_custom/models/reordering_rule.py
+++ b/fixco_custom/models/reordering_rule.py
@@ -107,13 +107,13 @@ class ReorderingRule(models.Model):
WHEN (
COALESCE(SUM(sq.quantity), 0.0)
+ vmsbm.incoming_qty - vmsbm.outgoing_qty
- ) < vmsbm.min_stock
+ ) <= vmsbm.min_stock
THEN 'BUY'
WHEN (
COALESCE(SUM(sq.quantity), 0.0)
+ vmsbm.incoming_qty - vmsbm.outgoing_qty
- ) > vmsbm.min_stock
+ ) >= vmsbm.min_stock
THEN 'HOLD'
WHEN (
@@ -121,7 +121,7 @@ class ReorderingRule(models.Model):
+ vmsbm.incoming_qty - vmsbm.outgoing_qty
) > vmsbm.buffer_stock
THEN 'READY STOCK'
-
+
ELSE 'READY STOCK'
END AS stock_status
diff --git a/fixco_custom/views/upload_payments.xml b/fixco_custom/views/upload_payments.xml
index 1a25960..fbb7aa5 100644
--- a/fixco_custom/views/upload_payments.xml
+++ b/fixco_custom/views/upload_payments.xml
@@ -9,6 +9,7 @@
<field name="number"/>
<field name="date_upload"/>
<field name="user_id"/>
+ <field name="state"/>
</tree>
</field>
</record>