diff options
Diffstat (limited to 'indoteknik_custom/models')
| -rwxr-xr-x | indoteknik_custom/models/sale_monitoring.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/indoteknik_custom/models/sale_monitoring.py b/indoteknik_custom/models/sale_monitoring.py index 97e96e72..2ef23f39 100755 --- a/indoteknik_custom/models/sale_monitoring.py +++ b/indoteknik_custom/models/sale_monitoring.py @@ -17,6 +17,7 @@ class SaleMonitoring(models.Model): qty_so_invoiced = fields.Integer(string="Qty SO Invoiced") date_order = fields.Datetime(string="Date Order") status = fields.Char(string="Status") + po_number = fields.Char(string="PO Number") def init(self): tools.drop_view_if_exists(self.env.cr, self._table) @@ -41,7 +42,8 @@ class SaleMonitoring(models.Model): WHEN SUM(qty_so_delivered) <> SUM(qty_so) AND SUM(qty_so_delivered) <= 0 THEN 'SIAP KIRIM' WHEN SUM(qty_so_delivered) <> SUM(qty_so) THEN 'KIRIM SISANYA' ELSE 'Belum Invoiced' - END AS status + END AS status, + get_po_number(smd.sale_order_id) as po_number FROM sale_monitoring_detail smd GROUP BY smd.date_order, smd.sale_order_id, smd.partner_id, smd.user_id ) |