add sum_sale_monitoring

19 files changed, 32 insertions, 0 deletions

diff --git a/indoteknik_custom/models/__init__.py b/indoteknik_custom/models/__init__.py
index 03b01fc4..03b01fc4 100644..100755
--- a/indoteknik_custom/models/__init__.py
+++ b/indoteknik_custom/models/__init__.py
diff --git a/indoteknik_custom/models/coupon_program.py b/indoteknik_custom/models/coupon_program.py
index 4c839c9f..4c839c9f 100644..100755
--- a/indoteknik_custom/models/coupon_program.py
+++ b/indoteknik_custom/models/coupon_program.py
diff --git a/indoteknik_custom/models/crm_lead.py b/indoteknik_custom/models/crm_lead.py
index 15ec4119..15ec4119 100644..100755
--- a/indoteknik_custom/models/crm_lead.py
+++ b/indoteknik_custom/models/crm_lead.py
diff --git a/indoteknik_custom/models/product_public_category.py b/indoteknik_custom/models/product_public_category.py
index bb661772..bb661772 100644..100755
--- a/indoteknik_custom/models/product_public_category.py
+++ b/indoteknik_custom/models/product_public_category.py
diff --git a/indoteknik_custom/models/product_template.py b/indoteknik_custom/models/product_template.py
index 348bda99..348bda99 100644..100755
--- a/indoteknik_custom/models/product_template.py
+++ b/indoteknik_custom/models/product_template.py
diff --git a/indoteknik_custom/models/purchase_order.py b/indoteknik_custom/models/purchase_order.py
index 2c589d36..2c589d36 100644..100755
--- a/indoteknik_custom/models/purchase_order.py
+++ b/indoteknik_custom/models/purchase_order.py
diff --git a/indoteknik_custom/models/purchase_order_line.py b/indoteknik_custom/models/purchase_order_line.py
index 74b46e4c..74b46e4c 100644..100755
--- a/indoteknik_custom/models/purchase_order_line.py
+++ b/indoteknik_custom/models/purchase_order_line.py
diff --git a/indoteknik_custom/models/purchase_pricelist.py b/indoteknik_custom/models/purchase_pricelist.py
index 25e551ae..25e551ae 100644..100755
--- a/indoteknik_custom/models/purchase_pricelist.py
+++ b/indoteknik_custom/models/purchase_pricelist.py
diff --git a/indoteknik_custom/models/res_users.py b/indoteknik_custom/models/res_users.py
index 16820952..16820952 100644..100755
--- a/indoteknik_custom/models/res_users.py
+++ b/indoteknik_custom/models/res_users.py
diff --git a/indoteknik_custom/models/sale_monitoring.py b/indoteknik_custom/models/sale_monitoring.py
index 6fabb2df..6fabb2df 100644..100755
--- a/indoteknik_custom/models/sale_monitoring.py
+++ b/indoteknik_custom/models/sale_monitoring.py
diff --git a/indoteknik_custom/models/stock_vendor.py b/indoteknik_custom/models/stock_vendor.py
index 78baf14c..78baf14c 100644..100755
--- a/indoteknik_custom/models/stock_vendor.py
+++ b/indoteknik_custom/models/stock_vendor.py
diff --git a/indoteknik_custom/models/sum_sale_monitoring.py b/indoteknik_custom/models/sum_sale_monitoring.py
new file mode 100755
index 00000000..bb392bcf
--- /dev/null
+++ b/indoteknik_custom/models/sum_sale_monitoring.py
@@ -0,0 +1,32 @@
+from odoo import fields, models, api, tools
+
+class SumSaleMonitoring(models.Model):
+    _name = 'sum.sale.monitoring'
+    _auto = False
+    _rec_name = 'sale_order_id'
+
+    date_order = fields.Datetime(string="Date Order")
+    sale_order_id = fields.Many2one("sale.order", string="Sale Order")
+    qty_so = fields.Integer(string="Qty SO")
+    qty_po = fields.Integer(string="Qty PO")
+    qty_po_received = fields.Integer(string="Qty PO Received")
+    qty_so_delivered = fields.Integer(string="Qty SO Delivered")
+    qty_so_invoiced = fields.Integer(string="Qty SO Invoiced")
+    status = fields.Char(string="Status")
+
+    def init(self):
+        tools.drop_view_if_exists(self.env.cr, self._table)
+        self.env.cr.execute("""
+            select sm.date_order, sm.sale_order_id, sum(sm.qty_so) as qty_so, sum(sm.qty_po) as qty_po, 
+            sum(sm.qty_po_received) as qty_received, sum(sm.qty_so_delivered) as qty_delivered, sum(sm.qty_so_invoiced) as qty_invoiced,
+            case
+              when sum(qty_po) <> sum(qty_so) and sum(qty_po) <= 0 then 'Belum PO sama sekali'
+              when sum(qty_po) <> sum(qty_so) then 'Belum PO full'
+              when sum(qty_po_received) <> sum(qty_po) and sum(qty_po_received) <= 0 then 'Belum Received sama sekali'
+              when sum(qty_po_received) <> sum(qty_po) then 'Belum Received full'
+              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
+            from sale_monitoring sm
+            group by sm.date_order, sm.sale_order_id
+        """ % self._table)
\ No newline at end of file
diff --git a/indoteknik_custom/models/user_activity_log.py b/indoteknik_custom/models/user_activity_log.py
index 558e5b5c..558e5b5c 100644..100755
--- a/indoteknik_custom/models/user_activity_log.py
+++ b/indoteknik_custom/models/user_activity_log.py
diff --git a/indoteknik_custom/models/x_banner_banner.py b/indoteknik_custom/models/x_banner_banner.py
index a402789a..a402789a 100644..100755
--- a/indoteknik_custom/models/x_banner_banner.py
+++ b/indoteknik_custom/models/x_banner_banner.py
diff --git a/indoteknik_custom/models/x_banner_category.py b/indoteknik_custom/models/x_banner_category.py
index 7c91bd78..7c91bd78 100644..100755
--- a/indoteknik_custom/models/x_banner_category.py
+++ b/indoteknik_custom/models/x_banner_category.py
diff --git a/indoteknik_custom/models/x_biaya_kirim.py b/indoteknik_custom/models/x_biaya_kirim.py
index 5bf48c62..5bf48c62 100644..100755
--- a/indoteknik_custom/models/x_biaya_kirim.py
+++ b/indoteknik_custom/models/x_biaya_kirim.py
diff --git a/indoteknik_custom/models/x_manufactures.py b/indoteknik_custom/models/x_manufactures.py
index 8aff7f26..8aff7f26 100644..100755
--- a/indoteknik_custom/models/x_manufactures.py
+++ b/indoteknik_custom/models/x_manufactures.py
diff --git a/indoteknik_custom/models/x_partner_purchase_order.py b/indoteknik_custom/models/x_partner_purchase_order.py
index 6beca5df..6beca5df 100644..100755
--- a/indoteknik_custom/models/x_partner_purchase_order.py
+++ b/indoteknik_custom/models/x_partner_purchase_order.py
diff --git a/indoteknik_custom/models/x_product_tags.py b/indoteknik_custom/models/x_product_tags.py
index dac7ffe1..dac7ffe1 100644..100755
--- a/indoteknik_custom/models/x_product_tags.py
+++ b/indoteknik_custom/models/x_product_tags.py