add date if all line in delivery order reserved

1 files changed, 38 insertions, 0 deletions

diff --git a/indoteknik_custom/models/sale_order.py b/indoteknik_custom/models/sale_order.py
index 9324930e..9da6d9fb 100755
--- a/indoteknik_custom/models/sale_order.py
+++ b/indoteknik_custom/models/sale_order.py
@@ -1,5 +1,6 @@
 from odoo import fields, models, api, _
 from odoo.exceptions import UserError
+from datetime import datetime
 import logging, random, string, requests, math, json, re
 
 _logger = logging.getLogger(__name__)
@@ -81,6 +82,16 @@ class SaleOrder(models.Model):
     email = fields.Char(string='Email')
     picking_iu_id = fields.Many2one('stock.picking', 'Picking IU')
     helper_by_id = fields.Many2one('res.users', 'Helper By')
+    picking_ids = fields.Many2many('stock.picking', string='Pickings', compute='_get_pickings', readonly=True, copy=False, search="_search_picking_ids")
+
+    def _get_pickings(self):
+        state = ['assigned']
+        for order in self:
+            pickings = self.env['stock.picking'].search([
+                ('sale_id.id', '=', order.id),
+                ('state', 'in', state)
+            ])
+            order.picking_ids = pickings
 
     @api.model
     def action_multi_update_state(self):
@@ -193,8 +204,35 @@ class SaleOrder(models.Model):
                 sale.so_status = 'sebagian'
             else:
                 sale.so_status = 'menunggu'
+            
+            for picking in sale.picking_ids:
+                sum_qty_pick = sum(move_line.product_uom_qty for move_line in picking.move_ids_without_package)
+                sum_qty_reserved = sum(move_line.product_uom_qty for move_line in picking.move_line_ids_without_package)
+                if sum_qty_pick == sum_qty_reserved:
+                    current_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
+                    picking.date_reserved = current_time
+                else:
+                    picking.date_reserved = ''
+
             _logger.info('Calculate SO Status %s' % sale.id)
 
+    def _search_picking_ids(self, operator, value):
+        if operator == 'in' and value:
+            self.env.cr.execute("""
+                SELECT array_agg(so.sale_id)
+                    FROM stock_picking so
+                WHERE
+                    so.sale_id is not null and so.id = ANY(%s)
+            """, (list(value),))
+            so_ids = self.env.cr.fetchone()[0] or []
+            return [('id', 'in', so_ids)]
+        elif operator == '=' and not value:
+            order_ids = self._search([
+                ('order_line.invoice_lines.move_id.move_type', 'in', ('out_invoice', 'out_refund'))
+            ])
+            return [('id', 'not in', order_ids)]
+        return ['&', ('order_line.invoice_lines.move_id.move_type', 'in', ('out_invoice', 'out_refund')), ('order_line.invoice_lines.move_id', operator, value)]
+
     @api.onchange('partner_shipping_id')
     def onchange_partner_shipping(self):
         self.real_shipping_id = self.partner_shipping_id