diff options
| -rw-r--r-- | indoteknik_custom/models/sale_monitoring.py | 20 | ||||
| -rw-r--r-- | indoteknik_custom/views/sale_monitoring.xml | 64 |
2 files changed, 58 insertions, 26 deletions
diff --git a/indoteknik_custom/models/sale_monitoring.py b/indoteknik_custom/models/sale_monitoring.py index 6a558669..27c9007c 100644 --- a/indoteknik_custom/models/sale_monitoring.py +++ b/indoteknik_custom/models/sale_monitoring.py @@ -4,16 +4,18 @@ from odoo import fields, models, api, tools class SaleMonitoring(models.Model): _name = 'sale.monitoring' _auto = False + _rec_name = 'sale_order_id' id = fields.Integer() - name = fields.Char(string="Name") - product_name = fields.Char(string="Product Name") - default_code = fields.Char(string="Default Code") + sale_order_id = fields.Many2one("sale.order", string="Sale Order") + purchase_order_id = fields.Many2one("purchase.order", string="Purchase Order") + product_id = fields.Many2one("product.product", string="Product") qty_so = fields.Integer(string="Qty SO") qty_so_delivered = fields.Integer(string="Qty SO Delivered") qty_so_invoiced = fields.Integer(string="Qty SO Invoiced") qty_po = fields.Integer(string="Qty PO") qty_po_received = fields.Integer(string="Qty PO Received") + sale_create_date = fields.Datetime(string="Sale Create Date") def init(self): tools.drop_view_if_exists(self.env.cr, self._table) @@ -21,12 +23,18 @@ class SaleMonitoring(models.Model): CREATE or REPLACE VIEW %s as ( SELECT p.id AS id, - so.name AS name, - p.default_code AS default_code, - pt.name as product_name, + so.id AS sale_order_id, + p.id as product_id, sol.product_uom_qty AS qty_so, sol.qty_delivered AS qty_so_delivered, sol.qty_invoiced AS qty_so_invoiced, + so.create_date AS sale_create_date, + ( + SELECT poo.id + FROM purchase_order_line pol + JOIN purchase_order poo ON poo.id = pol.order_id + WHERE poo.sale_order_id = so.id AND pol.product_id = sol.product_id + ) AS purchase_order_id, ( SELECT SUM(product_uom_qty) FROM purchase_order_line pol diff --git a/indoteknik_custom/views/sale_monitoring.xml b/indoteknik_custom/views/sale_monitoring.xml index 3c160e19..1df23285 100644 --- a/indoteknik_custom/views/sale_monitoring.xml +++ b/indoteknik_custom/views/sale_monitoring.xml @@ -4,10 +4,9 @@ <field name="name">sale.monitoring.tree</field> <field name="model">sale.monitoring</field> <field name="arch" type="xml"> - <tree> - <field name="name"/> - <field name="product_name"/> - <field name="default_code"/> + <tree create="false"> + <field name="sale_order_id"/> + <field name="product_id"/> <field name="qty_so"/> <field name="qty_po"/> <field name="qty_po_received"/> @@ -17,35 +16,60 @@ </field> </record> + <record id="sale_monitoring_form" model="ir.ui.view"> + <field name="name">sale.monitoring.form</field> + <field name="model">sale.monitoring</field> + <field name="arch" type="xml"> + <form create="false" edit="false"> + <sheet> + <group> + <group> + <field name="sale_order_id"/> + <field name="purchase_order_id"/> + <field name="product_id"/> + </group> + <group> + <field name="qty_so"/> + <field name="qty_po"/> + <field name="qty_po_received"/> + <field name="qty_so_delivered"/> + <field name="qty_so_invoiced"/> + </group> + </group> + </sheet> + </form> + </field> + </record> + <record id="sale_monitoring_action" model="ir.actions.act_window"> <field name="name">Sale Monitoring</field> <field name="type">ir.actions.act_window</field> <field name="res_model">sale.monitoring</field> - <field name="view_mode">tree</field> + <field name="view_mode">tree,form</field> </record> -<!-- <menuitem--> -<!-- id="menu_sale_monitoring"--> -<!-- name="Sale Monitoring"--> -<!-- parent="purchase.menu_purchase_root"--> -<!-- sequence="100"--> -<!-- action="sale_monitoring_action"--> -<!-- />--> + <menuitem + id="menu_sale_monitoring_in_purchase" + name="Sale Monitoring" + parent="purchase.menu_purchase_root" + sequence="100" + action="sale_monitoring_action" + /> <menuitem - id="menu_sale_monitoring" + id="menu_sale_monitoring_in_sale" name="Sale Monitoring" parent="sale.sale_menu_root" sequence="100" action="sale_monitoring_action" /> -<!-- <menuitem--> -<!-- id="menu_sale_monitoring"--> -<!-- name="Sale Monitoring"--> -<!-- parent="stock.menu_stock_root"--> -<!-- sequence="5"--> -<!-- action="sale_monitoring_action"--> -<!-- />--> + <menuitem + id="menu_sale_monitoring_in_stock" + name="Sale Monitoring" + parent="stock.menu_stock_root" + sequence="100" + action="sale_monitoring_action" + /> </odoo>
\ No newline at end of file |