Merge branch 'odoo-backup' of https://bitbucket.org/altafixco/indoteknik-addons into odoo-backup

1 files changed, 97 insertions, 9 deletions

diff --git a/indoteknik_api/controllers/api_v1/sale_order.py b/indoteknik_api/controllers/api_v1/sale_order.py
index ccab2827..fd460ea0 100644
--- a/indoteknik_api/controllers/api_v1/sale_order.py
+++ b/indoteknik_api/controllers/api_v1/sale_order.py
@@ -1,5 +1,5 @@
 from .. import controller
-from odoo import http
+from odoo import http, fields
 from datetime import datetime, timedelta
 from odoo.http import request
 import json
@@ -103,7 +103,11 @@ class SaleOrder(controller.Controller):
             'site': [],
             'limit': ['default:0', 'number'],
             'offset': ['default:0', 'number'],
-            'context': []
+            'context': [],
+            'status': [],
+            'sort': [],
+            'startDate': [],
+            'endDate': [],
         })
         limit = params['value']['limit']
         offset = params['value']['offset']
@@ -123,10 +127,19 @@ class SaleOrder(controller.Controller):
 
         if params['value']['name']:
             name = params['value']['name'].replace(' ', '%')
-            domain += [
+            order_lines = request.env['sale.order.line'].search([
+                ('order_id.partner_id', 'in', partner_child_ids),
                 '|',
-                ('name', 'ilike', '%' + name + '%'),
-                ('partner_purchase_order_name', 'ilike', '%' + name + '%')
+                ('product_id.name', 'ilike', name),
+                ('product_id.default_code', 'ilike', name),
+            ])
+            
+            sale_order_ids_from_lines = order_lines.mapped('order_id.id')
+            
+            domain += ['|', '|',
+                ('name', 'ilike', name),
+                ('partner_purchase_order_name', 'ilike', name),
+                ('id', 'in', sale_order_ids_from_lines)
             ]
         
         if params['value']['site']:
@@ -135,11 +148,86 @@ class SaleOrder(controller.Controller):
                 ('partner_id.site_id.name', 'ilike', '%' + site + '%')
             ]
 
+        status = params['value'].get('status')
+        if status:
+            if status == 'quotation':
+                domain += [('state', '=', 'draft')]
+                domain += [('approval_status', '=', False)]
+
+            elif status == 'cancel':
+                domain += [('state', '=', 'cancel')]
+
+            elif status == 'diproses':
+                domain += [
+                    ('state', '=', 'draft'),
+                    ('approval_status', 'in', ['pengajuan1', 'pengajuan2']),
+                ]
+
+            elif status in ['dikemas', 'dikirim', 'selesai', 'partial']:
+                domain += [('state', '=', 'sale')]
+
+            elif status == 'all':
+                domain += []
+
+        # Sorting
+        order = None
+        if params['value']['sort']:
+            if params['value']['sort'] == 'asc':
+                order = 'amount_total asc'
+            elif params['value']['sort'] == 'desc':
+                order = 'amount_total desc'
+
+        # Filter berdasarkan tanggal order
+        try:
+            if params['value']['startDate'] and params['value']['endDate']:
+                start_date = datetime.strptime(params['value']['startDate'], '%d/%m/%Y').strftime('%Y-%m-%d 00:00:00')
+                end_date = datetime.strptime(params['value']['endDate'], '%d/%m/%Y').strftime('%Y-%m-%d 23:59:59')
+            else:
+                start_date = '2023-01-01 00:00:00'
+                end_date = fields.Datetime.now().strftime('%Y-%m-%d 23:59:59')
+
+            domain.append(('date_order', '>=', start_date))
+            domain.append(('date_order', '<=', end_date))
+
+        except ValueError:
+            return self.response(code=400, description="Invalid date format. Use 'DD/MM/YYYY'.")
+
+
+
         sale_orders = request.env['sale.order'].search(
-            domain, offset=offset, limit=limit)
+            domain, order=order)  
+        status = params['value'].get('status')
+        if status in ['dikemas', 'dikirim', 'selesai', 'partial']:
+            filtered_orders = []
+            for sale_order in sale_orders:
+                bu_pickings = [
+                    p for p in sale_order.picking_ids
+                    if p.picking_type_id and p.picking_type_id.id == 29
+                ]
+                total = len(bu_pickings)
+                done_pickings = [p for p in bu_pickings if p.state == 'done']
+                done_with_driver = [p for p in done_pickings if p.driver_arrival_date]
+                done_without_driver = [p for p in done_pickings if not p.driver_arrival_date]
+
+                if status == 'dikemas' and len(done_pickings) == 0:
+                    filtered_orders.append(sale_order)
+                elif status == 'dikirim' and len(done_pickings) == total and len(done_pickings) > 0 and len(done_without_driver) == total:
+                    filtered_orders.append(sale_order)
+                elif status == 'selesai' and len(done_pickings) == total and len(done_pickings) > 0 and len(done_with_driver) == total:
+                    filtered_orders.append(sale_order)
+                elif status == 'partial' and (
+                    len(done_pickings) != total or
+                    (done_with_driver and done_without_driver)
+                ):
+                    filtered_orders.append(sale_order)
+        else:
+            filtered_orders = sale_orders
+
+        filtered_orders_paginated = filtered_orders[offset: offset + limit]
+
         data = {
-            'sale_order_total': request.env['sale.order'].search_count(domain),
-            'sale_orders': [request.env['sale.order'].api_v1_single_response(x) for x in sale_orders]
+            'sale_order_total': len(filtered_orders),
+            'sale_orders': [request.env['sale.order'].api_v1_single_response(x) for x in filtered_orders_paginated]
         }
         
         return self.response(data)
@@ -149,7 +237,7 @@ class SaleOrder(controller.Controller):
     def partner_get_sale_order_detail(self, **kw):
         params = self.get_request_params(kw, {
             'partner_id': ['number'],
-            'id': ['number']
+            'id': ['number'],
         })
         if not params['valid']:
             return self.response(code=400, description=params)