状态计算

Merge Request: 修复销售单号和追溯参考为空问题

Created By: @管欢
Reviewed By: @胡尧
Approved By: @胡尧 
Accepted By: @管欢
URL: https://jikimo-hn.coding.net/p/jikimo_sfs/d/jikimo_sf/git/merge/1710

jikimo_frontend/static/src/js/custom_form_status_indicator.js

@@ -139,7 +139,7 @@ patch(ListRenderer.prototype, 'jikimo_frontend.ListRenderer', {
         owl.onMounted(() => {
             this.activeElement = this.uiService.activeElement;
             this.setRequired()
-            // this.listherHeaderBodyNum()
+            this.listherHeaderBodyNum()
         })
         return this._super(...arguments);
     },
@@ -177,9 +177,10 @@ patch(ListRenderer.prototype, 'jikimo_frontend.ListRenderer', {
             const thead_th_num = thead_tr.children().length
             const tbody_tr_num = tbody_tr.children().length
             const num = thead_th_num - tbody_tr_num
-            console.log('num', num);
             if(num == -1) {
-                thead_tr.prepend('<td>序号</td>')
+                tbody.children('tr').each(function () {
+                    $(this).children('td').eq(0).remove()
+                })
             }
 
         } catch (e) {

jikimo_purchase_tier_validation/__manifest__.py

@@ -20,7 +20,7 @@
     'version': '0.1',
 
     # any module necessary for this one to work correctly
-    'depends': ['purchase', 'base_tier_validation', 'documents', 'purchase_request', 'account'],
+    'depends': ['purchase', 'purchase_tier_validation', 'documents', 'purchase_request', 'account', 'purchase_order_approved'],
 
     # always loaded
     'data': [

jikimo_purchase_tier_validation/models/models.py

@@ -23,6 +23,10 @@ class jikimo_purchase_tier_validation(models.Model):
         for record in self:
             if record.need_validation and record.validation_status != 'validated':
                 raise ValidationError(_('此操作需要至少对一条记录进行审批。\n请发起审批申请。'))
+            if record.state in ['to approve']:
+                raise ValidationError(_('请先完成审批。'))
+            if record.state == 'approved':
+                record.state = 'purchase'
         return super().button_confirm()
 
     # def button_confirm(self):
@@ -83,7 +87,17 @@ class jikimo_purchase_tier_validation(models.Model):
 
     def _validate_tier(self, tiers=False):
         res = super(jikimo_purchase_tier_validation, self)._validate_tier(tiers)
-        self.state = 'approved'
+        tier_reviews = tiers or self.review_ids
+
+        # 检查是否所有审批都已通过
+        all_approved = all(
+            tier_review.status == 'approved'
+            for tier_review in tier_reviews
+        )
+
+        if all_approved and tier_reviews:  # 确保有审批记录
+            self.state = 'approved'
+
         return res
 
     def _rejected_tier(self, tiers=False):

jikimo_purchase_tier_validation/views/views.xml

@@ -1,11 +1,23 @@
 <?xml version="1.0" encoding="UTF-8" ?>
 <odoo>
     <data>
+        <record model="ir.ui.view" id="tier_validation_view_approved_purchase_order_form_inherit">
+            <field name="name">tier_validation_view_approved_purchase_order_form_inherit</field>
+            <field name="model">purchase.order</field>
+            <field name="inherit_id" ref="purchase_order_approved.purchase_order_form"/>
+            <field name="arch" type="xml">
+                <xpath expr="//button[@name='button_release']" position="replace">
+                </xpath>
+            </field>
+        </record>
+
         <record model="ir.ui.view" id="tier_validation_view_purchase_order_form_inherit">
             <field name="name">tier_validation_view_purchase_order_form_inherit</field>
             <field name="model">purchase.order</field>
             <field name="inherit_id" ref="purchase.purchase_order_form"/>
             <field name="arch" type="xml">
+                <xpath expr="//header/button[@name='button_approve']" position="replace">
+                </xpath>
                 <xpath expr="//header/button[@name='button_cancel']" position="replace">
                 </xpath>
                 <xpath expr="//header/field[@name='state']" position="replace">

jikimo_purchase_tier_validation/wizards/__init__.py

@@ -1 +1,2 @@
-from . import upload_file_wizard
+from . import upload_file_wizard
+from . import comment_wizard

jikimo_purchase_tier_validation/wizards/comment_wizard.py

@@ -0,0 +1,15 @@
+from odoo import models, fields
+
+
+class CommentWizard(models.TransientModel):
+    _inherit = "comment.wizard"
+
+    def add_comment(self):
+
+        rec = self.env[self.res_model].browse(self.res_id)
+
+        self.review_ids = rec.review_ids
+
+        result = super(CommentWizard, self).add_comment()
+
+        return result

sf_manufacturing/models/mrp_production.py

@@ -802,46 +802,7 @@ class MrpProduction(models.Model):
                     workorder._get_surface_technics_purchase_ids().write({'state': 'cancel'})
                     workorder.move_subcontract_workorder_ids.write({'state': 'cancel'})
                     workorder.move_subcontract_workorder_ids.picking_id.write({'state': 'cancel'})
-                consecutive_workorders = []
                 sorted_workorders = sorted(process_parameter_workorder, key=lambda w: w.sequence)
-                # for i, workorder in enumerate(sorted_workorders):
-                #     # 检查当前工作订单和下一个工作订单是否连续，并且供应商相同
-                #     if i == 0:
-                #         consecutive_workorders.append(workorder)
-                #     elif workorder.sequence == sorted_workorders[
-                #         i - 1].sequence + 1 and workorder.supplier_id.id == sorted_workorders[i - 1].supplier_id.id:
-                #         consecutive_workorders.append(workorder)
-                #     else:
-                #         # 处理连续组，如果它不为空
-                #         if consecutive_workorders:
-                #             proc_workorders.append(consecutive_workorders)
-                #             # 创建外协出入库单和采购订单
-                #             # self.env['stock.picking'].create_outcontract_picking(consecutive_workorders, production, sorted_workorders)
-                #             # self.env['purchase.order'].get_purchase_order(consecutive_workorders, production,
-                #             #                                               product_id_to_production_names)
-                #             if i < len(sorted_workorders) - 1:
-                #                 # 重置连续组，并添加当前工作订单
-                #                 consecutive_workorders = [workorder]
-                #             else:
-                #                 # 判断最后一笔:
-                #                 if workorder.sequence == sorted_workorders[
-                #                     i - 1].sequence and workorder.supplier_id.id == sorted_workorders[
-                #                     i - 1].supplier_id.id:
-                #                     consecutive_workorders = [workorder]
-                #                 else:
-                #                     proc_workorders.append([workorder])
-                #                     # 立即创建外协出入库单和采购订单
-                #                     # self.env['stock.picking'].create_outcontract_picking(workorder, production)
-                #                     # self.env['purchase.order'].get_purchase_order(workorder, production,
-                #                     #   product_id_to_production_names)
-                #                     consecutive_workorders = []
-                #
-                # # 处理最后一个组，即使它可能只有一个工作订单
-                # if consecutive_workorders:
-                #     proc_workorders.append(consecutive_workorders)
-                    # self.env['stock.picking'].create_outcontract_picking(consecutive_workorders, production)
-                    # self.env['purchase.order'].get_purchase_order(consecutive_workorders, production,
-                    #                                               product_id_to_production_names)
             if not sorted_workorders:
                 return
             for workorders in reversed(sorted_workorders):
@@ -980,6 +941,8 @@ class MrpProduction(models.Model):
                                       and item.process_parameters_id == work.surface_technics_parameters_id) or
                                      (item.route_id.name == work.name and item.panel
                                       and item.panel == work.processing_panel))
+                    if work.name == '人工线下加工':
+                        td_ids = technology_design_ids.filtered(lambda item: (item.route_id.name in work.name))
                     if td_ids:
                         work.sequence = td_ids[0].sequence
                 cancel_work_ids = workorder_ids.filtered(lambda item: item.state in ('已取消', 'cancel'))

sf_manufacturing/models/mrp_workorder.py

@@ -17,6 +17,7 @@ from odoo.exceptions import UserError, ValidationError
 from odoo.addons.sf_mrs_connect.models.ftp_operate import FtpController
 
 
+
 class ResMrpWorkOrder(models.Model):
     _inherit = 'mrp.workorder'
     _order = 'sequence asc'
@@ -129,7 +130,7 @@ class ResMrpWorkOrder(models.Model):
     Y10_axis = fields.Float(default=0)
     Z10_axis = fields.Float(default=0)
     X_deviation_angle = fields.Integer(string="X轴偏差度", default=0)
-    test_results = fields.Selection([("合格", "合格"), ("返工", "返工"), ("报废", "报废")], default='合格',
+    test_results = fields.Selection([("合格", "合格"), ("返工", "返工")], default='合格',
                                     string="检测结果", tracking=True)
     cnc_ids = fields.One2many("sf.cnc.processing", 'workorder_id', string="CNC加工程序")
     cmm_ids = fields.One2many("sf.cmm.program", 'workorder_id', string="CMM程序")
@@ -330,7 +331,7 @@ class ResMrpWorkOrder(models.Model):
         return result
 
     def _get_surface_technics_purchase_ids(self):
-        domain = [('origin', '=', self.production_id.name), ('purchase_type', '=', 'consignment')]
+        domain = [('origin', 'like', '%' + self.production_id.name + '%'), ('purchase_type', '=', 'consignment')]
         purchase_orders = self.env['purchase.order'].search(domain)
         purchase_orders_id = self.env['purchase.order']
         for po in purchase_orders:
@@ -1035,49 +1036,6 @@ class ResMrpWorkOrder(models.Model):
                  'production_id.tool_state', 'production_id.schedule_state', 'sequence',
                  'production_id.programming_state')
     def _compute_state(self):
-        # super()._compute_state()
-        # for workorder in self:
-        #     if workorder.sequence != 1:
-        #         previous_workorder = self.env['mrp.workorder'].search(
-        #             [('production_id', '=', workorder.production_id.id),
-        #              ('sequence', '=', workorder.sequence - 1)])
-        #     if workorder.state == 'pending':
-        #         if all([wo.state in ('done', 'cancel') for wo in workorder.blocked_by_workorder_ids]):
-        #             if workorder.production_id.reservation_state == 'assigned' and workorder.production_id.schedule_state == '已排':
-        #                 if ((workorder.sequence == 1 and not workorder.blocked_by_workorder_ids)
-        #                         or (workorder.blocked_by_workorder_ids.state in ('done', 'cancel')
-        #                             and workorder.blocked_by_workorder_ids.test_results not in ['报废', '返工'])
-        #                         or (previous_workorder.state in ('done', 'cancel')
-        #                             and not workorder.blocked_by_workorder_ids
-        #                             and previous_workorder.test_results not in ['报废', '返工'])
-        #                 ):
-        #                     workorder.state = 'ready'
-        #         continue
-        #     if workorder.production_id.schedule_state == '未排' and workorder.state in ('waiting', 'ready'):
-        #         if workorder.sequence != 1:
-        #             workorder.state = 'pending'
-        #         continue
-        #     if workorder.state not in ('waiting', 'ready'):
-        #         continue
-        #     if workorder.state in (
-        #             'waiting') and workorder.sequence == 1 and workorder.production_id.schedule_state == '已排':
-        #         workorder.state = 'ready'
-        #         continue
-        #     if not all([wo.state in ('done', 'cancel') for wo in workorder.blocked_by_workorder_ids]):
-        #         workorder.state = 'pending'
-        #         if workorder.state in ['waiting']:
-        #             if previous_workorder.state == 'waiting':
-        #                 workorder.state = 'pending'
-        #         if workorder.sequence == 1 and workorder.state == 'pending':
-        #             workorder.state = 'waiting'
-        #         continue
-        #     if workorder.production_id.reservation_state not in ('waiting', 'confirmed', 'assigned'):
-        #         continue
-        #     if workorder.production_id.reservation_state == 'assigned' and workorder.state == 'waiting' and workorder.production_id.schedule_state == '已排':
-        #         workorder.state = 'ready'
-        #     elif workorder.production_id.reservation_state != 'assigned' and workorder.state == 'ready':
-        #         workorder.state = 'waiting'
-
         for workorder in self:
             # 如果工单的工序没有进行排序则跳出循环
             if workorder.production_id.workorder_ids.filtered(lambda wk: wk.sequence == 0):
@@ -1111,7 +1069,7 @@ class ResMrpWorkOrder(models.Model):
                         continue
                 else:
                     workorder.state = 'ready'
-                continue
+                    continue
             # ================= 如果制造订单刀具状态为[无效刀、缺刀] 或者 制造订单状态为[返工]==========================
             if (workorder.production_id.tool_state in ['1', '2'] or workorder.production_id.state == 'rework'
                     or workorder.production_id.schedule_state != '已排'
@@ -1134,86 +1092,12 @@ class ResMrpWorkOrder(models.Model):
                 if workorder.is_subcontract is False:
                     workorder.state = 'ready'
                 else:
-                    # production_programming = self.env['mrp.production'].search(
-                    #     [('origin', '=', self.production_id.origin)], order='name asc')
-                    # production_no_remanufacture = production_programming.filtered(
-                    #     lambda a: a.is_remanufacture is False)
-                    # production_list = [production.name for production in production_programming]
-                    # purchase_orders = self.env['purchase.order'].search(
-                    #     [('origin', 'ilike', ','.join(production_list))])
-                    # for line in purchase_orders.order_line:
-                    #     if (
-                    #             line.product_id.server_product_process_parameters_id == workorder.surface_technics_parameters_id
-                    #             and line.product_qty == len(production_no_remanufacture)):
-                    #         if all(pur_order.state == 'purchase' for pur_order in purchase_orders):
-                    #             workorder.state = 'ready'
-                    #         else:
-                    #             workorder.state = 'waiting'
                     purchase_orders_id = self._get_surface_technics_purchase_ids()
                     if purchase_orders_id:
                         workorder.state = 'ready' if purchase_orders_id.state == 'purchase' else 'waiting'
                     else:
                         workorder.state = 'waiting'
 
-            # re_work = self.env['mrp.workorder'].search([('production_id', '=', workorder.production_id.id),
-            #                                             ('processing_panel', '=', workorder.processing_panel),
-            #                                             ('is_rework', '=', True), ('state', 'in', ['done', 'rework'])])
-            # cnc_workorder = self.env['mrp.workorder'].search(
-            #     [('production_id', '=', workorder.production_id.id),
-            #      ('processing_panel', '=', workorder.processing_panel),
-            #      ('routing_type', '=', 'CNC加工'), ('state', 'in', ['done', 'rework']),
-            #      ('test_results', '=', '返工')])
-            # cnc_workorder_pending = self.env['mrp.workorder'].search(
-            #     [('production_id', '=', workorder.production_id.id),
-            #      ('processing_panel', '=', workorder.processing_panel),
-            #      ('routing_type', '=', 'CNC加工'), ('state', 'in', ['pending'])])
-            # unclamp_workorder = self.env['mrp.workorder'].search(
-            #     [('production_id', '=', workorder.production_id.id),
-            #      ('sequence', '=', workorder.sequence - 1),
-            #      ('state', 'in', ['done'])])
-            # if workorder.state not in ['cancel', 'progress', 'rework']:
-            #     if workorder.production_id.state == 'rework':
-            #         if workorder.routing_type == '装夹预调':
-            #             # # 有返工工单
-            #             # if re_work:
-            #             # 新工单
-            #             if workorder.is_rework is False:
-            #                 if (workorder.production_id.programming_state == '已编程'
-            #                         and workorder.production_id.is_rework is False):
-            #                     if re_work or cnc_workorder:
-            #                         workorder.state = 'ready'
-            #                 else:
-            #                     if workorder.production_id.is_rework is True:
-            #                         if re_work or cnc_workorder:
-            #                             workorder.state = 'waiting'
-            #
-            #         elif workorder.routing_type == 'CNC加工':
-            #             pre_workorder = self.env['mrp.workorder'].search(
-            #                 [('production_id', '=', workorder.production_id.id),
-            #                  ('processing_panel', '=', workorder.processing_panel),
-            #                  ('routing_type', '=', '装夹预调'), ('state', '=', 'done')])
-            #             if pre_workorder:
-            #                 if re_work:
-            #                     workorder.state = 'waiting'
-            #         elif workorder.routing_type == '解除装夹':
-            #             if cnc_workorder:
-            #                 if not cnc_workorder_pending or unclamp_workorder.test_results == '报废':
-            #                     workorder.state = 'waiting'
-            #         # else:
-            #         #     if workorder.production_id.is_rework is True:
-            #         #         workorder.state = 'waiting'
-            #     elif workorder.production_id.state == 'progress':
-            #         if (workorder.routing_type == '装夹预调' and workorder.production_id.programming_state == '已编程'
-            #                 and workorder.is_rework is False and workorder.state not in ['done', 'rework', 'cancel']):
-            #             if workorder.production_id.is_rework is False:
-            #                 if re_work or cnc_workorder or unclamp_workorder:
-            #                     workorder.state = 'ready'
-            #             # if (re_work or cnc_workorder) and workorder.production_id.is_rework is False:
-            #             #     workorder.state = 'ready'
-            #     elif workorder.production_id.state == 'scrap':
-            #         if workorder.routing_type == '解除装夹' and unclamp_workorder.test_results == '报废':
-            #             workorder.state = 'waiting'
-
     # 重写工单开始按钮方法
     def button_start(self):
         # 判断工单状态是否为等待组件

sf_manufacturing/models/purchase_order.py

@@ -10,10 +10,11 @@ from odoo.tools import OrderedSet
 # _get_surface_technics_purchase_ids
 class PurchaseOrder(models.Model):
     _inherit = 'purchase.order'
+
     production_count = fields.Integer(
         "关联制造订单",
         compute='_compute_workorder_count',
-        )
+    )
 
     def action_view_production(self):
         origins = [order.name for order in self.picking_ids]
@@ -37,34 +38,65 @@ class PurchaseOrder(models.Model):
             })
         return action
 
-
     def _compute_workorder_count(self):
         for purchase in self:
             origins = [order.name for order in purchase.picking_ids]
             production_id = self.env['mrp.production'].search([('origin', 'in', origins)])
             purchase.production_count = len(production_id)
+
     def button_confirm(self):
         super().button_confirm()
-        workorders = self.env['mrp.workorder'].search([('purchase_id', '=', self.id),('state', '!=', 'cancel')])
+        workorders = self.env['mrp.workorder'].search([('purchase_id', '=', self.id), ('state', '!=', 'cancel')])
         for workorder in workorders:
-            if workorder.routing_type == '表面工艺' and  workorder.is_subcontract is True:
+            if workorder.routing_type == '表面工艺' and workorder.is_subcontract is True:
                 move_out = workorder.move_subcontract_workorder_ids[1]
-                # move_out = self.env['stock.move'].search(
-                #     [('location_id', '=', self.env['stock.location'].search(
-                #         [('barcode', 'ilike', 'WH-PREPRODUCTION')]).id),
-                #      ('location_dest_id', '=', self.env['stock.location'].search(
-                #          [('barcode', 'ilike', 'VL-SPOC')]).id),
-                #      ('origin', '=', self.production_id.name), ('state', 'not in', ['cancel', 'done'])])
                 for mo in move_out:
                     if mo.state != 'done':
                         mo.write({'state': 'assigned', 'production_id': False})
                         if not mo.move_line_ids:
                             self.env['stock.move.line'].create(mo.get_move_line(workorder.production_id, workorder))
         return True
+
+    origin_sale_id = fields.Many2one('sale.order', string='销售订单号', store=True, compute='_compute_origin_sale_id')
+    origin_sale_ids = fields.Many2many('sale.order', string='销售订单号(多个)', store=True,
+                                       compute='_compute_origin_sale_id')
+
+    @api.depends('origin')
+    def _compute_origin_sale_id(self):
+        for purchase in self:
+            if not purchase.origin:
+                continue
+            elif 'MO' in purchase.origin:
+                mp_name_list = [name.strip() for name in purchase['origin'].split(',')]
+                os_ids = list({mp_id.sale_order_id.id for mp_id in self.env['mrp.production'].sudo().search([
+                    ('name', 'in', mp_name_list)])})
+                if len(os_ids) == 1:
+                    purchase.origin_sale_id = os_ids[0]
+                elif len(os_ids) >= 2:
+                    purchase.origin_sale_ids = os_ids
+            elif 'S' in purchase.origin:
+                os_name_list = [name.strip() for name in purchase['origin'].split(',')]
+                os_ids = self.env['sale.order'].sudo().search([('name', 'in', os_name_list)])
+                if len(os_ids) == 1:
+                    purchase.origin_sale_id = os_ids.id
+                elif len(os_ids) >= 2:
+                    purchase.origin_sale_ids = os_ids.ids
+            elif 'IN' in purchase.origin:
+                sp_name_list = [name.strip() for name in purchase['origin'].split(',')]
+                os_ids = list({sp_id.sale_order_id.id for sp_id in self.env['stock.picking'].sudo().search([
+                    ('name', 'in', sp_name_list)])})
+                if len(os_ids) == 1:
+                    purchase.origin_sale_id = os_ids[0]
+                elif len(os_ids) >= 2:
+                    purchase.origin_sale_ids = os_ids
+
+
 class PurchaseOrderLine(models.Model):
     _inherit = 'purchase.order.line'
     part_number = fields.Char('零件图号', related='product_id.part_number', readonly=True)
-    related_product = fields.Many2one('product.product',compute='_compute_related_product', string='关联产品',help='经此产品工艺加工成的成品')
+    related_product = fields.Many2one('product.product', compute='_compute_related_product', string='关联产品',
+                                      help='经此产品工艺加工成的成品')
+
     @api.depends('order_id.origin')
     def _compute_related_product(self):
         for record in self:
@@ -73,4 +105,3 @@ class PurchaseOrderLine(models.Model):
                 record.related_product = production_id.product_id if production_id else False
             else:
                 record.related_product = False
-

sf_manufacturing/models/stock.py

@@ -687,7 +687,11 @@ class StockPicking(models.Model):
                 'sf_manufacturing.outcontract_picking_in').id,
             outcontract_picking_type_out = self.env.ref(
                 'sf_manufacturing.outcontract_picking_out').id,
-            moves_in = self.env['stock.move'].sudo().create(
+            context = dict(self.env.context)
+            context.update({
+                'default_production_id': item.id,  # 添加额外信息到 context 中
+            })
+            moves_in = self.env['stock.move'].sudo().with_context(context).create(
                 self.env['stock.move']._get_stock_move_values_Res(item, outcontract_picking_type_in,
                                                                   procurement_group_id.id, move_dest_id))
             picking_in = self.create(
@@ -696,7 +700,8 @@ class StockPicking(models.Model):
             moves_in.write(
                 {'picking_id': picking_in.id, 'state': 'waiting'})
             moves_in._assign_picking_post_process(new=new_picking)
-            moves_out = self.env['stock.move'].sudo().create(
+            # self.env.context.get('default_production_id')
+            moves_out = self.env['stock.move'].sudo().with_context(context).create(
                 self.env['stock.move']._get_stock_move_values_Res(item, outcontract_picking_type_out,
                                                                   procurement_group_id.id, moves_in.id))
             workorder.write({'move_subcontract_workorder_ids': [(6, 0, [moves_in.id, moves_out.id])]})
@@ -773,6 +778,7 @@ class ReStockMove(models.Model):
             'origin': item.name,
             'group_id': group_id,
             'move_dest_ids': [(6, 0, [move_dest_ids])] if move_dest_ids else False,
+            # 'production_id': item.id,
             # 'route_ids': False if not route else [(4, route.id)],
             'date_deadline': datetime.now(),
             'picking_type_id': picking_type_id,

sf_manufacturing/security/ir.model.access.csv

@@ -183,4 +183,7 @@ access_sf_manual_product_model_type_routing_sort_manager,sf_manual_product_model
 access_sf_manual_product_model_type_routing_sort_group_plan_dispatch,sf_manual_product_model_type_routing_sort_group_plan_dispatch,model_sf_manual_product_model_type_routing_sort,sf_base.group_plan_dispatch,1,0,0,0
 access_sf_detection_result_manager,sf_detection_result_manager,model_sf_detection_result,,1,1,1,1
 
-access_mrp_workorder_batch_replan_wizard_group_plan_dispatch,mrp_workorder_batch_replan_wizard_group_plan_dispatch,model_mrp_workorder_batch_replan_wizard,sf_base.group_plan_dispatch,1,1,1,0
+access_mrp_workorder_batch_replan_wizard_group_plan_dispatch,mrp_workorder_batch_replan_wizard_group_plan_dispatch,model_mrp_workorder_batch_replan_wizard,sf_base.group_plan_dispatch,1,1,1,0
+
+access_mrp_workorder_group_purchase_director,mrp_workorder,model_mrp_workorder,sf_base.group_purchase_director,1,1,0,0
+access_mrp_workorder_group_purchase,mrp_workorder,model_mrp_workorder,sf_base.group_purchase,1,1,0,0

sf_manufacturing/views/purchase_order_view.xml

@@ -22,6 +22,13 @@
                         </div>
                     </button>
                 </xpath>
+                <!--                添加销售订单号字段-->
+                <xpath expr="//sheet/group/group[2]/div[@name='date_approve']" position="after">
+                    <field name="origin_sale_id" readonly="1" string="参考销售订单"
+                           attrs="{'invisible': [('origin_sale_id' , '=', False)]}"/>
+                    <field name="origin_sale_ids" readonly="1" string="参考销售订单" widget="many2many_tags"
+                           attrs="{'invisible': [('origin_sale_ids' , '=', [])]}"/>
+                </xpath>
             </field>
         </record>
     </data>

sf_manufacturing/wizard/production_technology_re_adjust_wizard.py

@@ -25,38 +25,6 @@ class ProductionTechnologyReAdjustWizard(models.TransientModel):
             # 该制造订单的其他同一销售订单的制造订单的工艺设计处理
             if production_item != self.production_id:
                 self.env['sf.technology.design'].sudo().unified_procedure_multiple_work_orders(technology_designs, production_item)
-                # for td_other in production_item.technology_design_ids:
-                #     # if td_other.is_auto is False:
-                #     #     td_del = technology_designs.filtered(lambda tdo: tdo.route_id.id == td_other.route_id.id)
-                #     #     if not td_del or td_del.active is False:
-                #     #         td_other.write({'active': False})
-                #     for td_main in technology_designs:
-                #         route_other = production_item.technology_design_ids.filtered(
-                #             lambda td: td.route_id.id == td_main.route_id.id)
-                #         if not route_other and td_main.active is True:
-                #             production_item.write({'technology_design_ids': [(0, 0, {
-                #                 'route_id': td_main.route_id.id,
-                #                 'process_parameters_id': False if td_main.process_parameters_id is False else
-                #                 self.env[
-                #                     'sf.production.process.parameter'].search(
-                #                     [('id', '=', td_main.process_parameters_id.id)]).id,
-                #                 'sequence': td_main.sequence,
-                #                 'is_auto': td_main.is_auto})]})
-                        # else:
-                        #     for ro in route_other:
-                        #         domain = [('production_id', '=', self.production_id.id),
-                        #                   ('active', 'in', [True, False]),
-                        #                   ('route_id', '=', ro.route_id.id)]
-                        #         if ro.route_id.routing_type == '表面工艺':
-                        #             domain += [('process_parameters_id', '=', ro.process_parameters_id.id)]
-                        #         elif ro.route_id.routing_tag == 'special' and ro.is_auto is False:
-                        #             # display_name = ro.route_id.display_name
-                        #             domain += [('id', '=', ro.id)]
-                        #         elif ro.panel is not False:
-                        #             domain += [('panel', '=', ro.panel)]
-                        #         td_upd = self.env['sf.technology.design'].sudo().search(domain)
-                        #         if td_upd:
-                        #             ro.write({'sequence': td_upd.sequence, 'active': td_upd.active})
             special_design = self.env['sf.technology.design'].sudo().search(
                 [('routing_tag', '=', 'special'), ('production_id', '=', production_item.id),
                  ('is_auto', '=', False), ('active', 'in', [True, False])])
@@ -71,23 +39,6 @@ class ProductionTechnologyReAdjustWizard(models.TransientModel):
                     else:
                         domain += [('technology_design_id', '=', special.id), ('state', '!=', 'cancel')]
                     workorder = self.env['mrp.workorder'].search(domain)
-                    # previous_workorder = self.env['mrp.workorder'].search(
-                    #     [('sequence', '=', workorder.sequence - 1), ('routing_type', '=', '表面工艺'),
-                    #      ('production_id', '=', workorder.production_id.id)])
-                    # if previous_workorder:
-                    #     if previous_workorder.supplier_id != workorder.supplier_id:
-                    #         is_cancel = True
-                    # else:
-                    #     is_cancel = True
-                    # if workorder.state != 'cancel' and is_cancel is True:
-                    #     workorder.write({'state': 'cancel'})
-                    #     workorder.picking_ids.write({'state': 'cancel'})
-                    #     workorder.picking_ids.move_ids.write({'state': 'cancel'})
-                    #     purchase_order = self.env['purchase.order'].search(
-                    #         [('origin', '=', workorder.production_id.name)])
-                    #     for line in purchase_order.order_line:
-                    #         if line.product_id.server_product_process_parameters_id == workorder.surface_technics_parameters_id:
-                    #             purchase_order.write({'state': 'cancel'})
                 else:
                     workorder = self.env['mrp.workorder'].search(
                         [('technology_design_id', '=', special.id), ('production_id', '=', special.production_id.id), ('state', '!=', 'cancel')])

sf_manufacturing/wizard/production_technology_wizard.py

@@ -27,36 +27,7 @@ class ProductionTechnologyWizard(models.TransientModel):
             if production != self.production_id:
                 self.env['sf.technology.design'].sudo().unified_procedure_multiple_work_orders(technology_designs,
                                                                                                production)
-                # for td_other in production.technology_design_ids:
-                    # if td_other.is_auto is False:
-                    #     td_del = technology_designs.filtered(lambda tdo: tdo.route_id.id == td_other.route_id.id)
-                    #     if not td_del or td_del.active is False:
-                    #         td_other.write({'active': False})
-                    # for td_main in technology_designs:
-                    #     route_other = production.technology_design_ids.filtered(
-                    #         lambda td: td.route_id.id == td_main.route_id.id)
-                    #     if not route_other and td_main.active is True:
-                    #         production.write({'technology_design_ids': [(0, 0, {
-                    #             'route_id': td_main.route_id.id,
-                    #             'process_parameters_id': False if td_main.process_parameters_id is False else self.env[
-                    #                 'sf.production.process.parameter'].search(
-                    #                 [('id', '=', td_main.process_parameters_id.id)]).id,
-                    #             'sequence': td_main.sequence})]})
-                        # else:
-                        #     for ro in route_other:
-                        #         domain = [('production_id', '=', self.production_id.id),
-                        #                   ('active', 'in', [True, False]),
-                        #                   ('route_id', '=', ro.route_id.id)]
-                        #         if ro.route_id.routing_type == '表面工艺':
-                        #             domain += [('process_parameters_id', '=', ro.process_parameters_id.id)]
-                        #         elif ro.route_id.routing_tag == 'special' and ro.is_auto is False:
-                        #             # display_name = ro.route_id.display_name
-                        #             domain += [('id', '=', ro.id)]
-                        #         elif ro.panel is not False:
-                        #             domain += [('panel', '=', ro.panel)]
-                        #         td_upd = self.env['sf.technology.design'].sudo().search(domain)
-                        #         if td_upd:
-                        #             ro.write({'sequence': td_upd.sequence, 'active': td_upd.active})
+            # 特殊表面工艺
             special_design = self.env['sf.technology.design'].sudo().search(
                 [('routing_tag', '=', 'special'), ('production_id', '=', production.id),
                  ('is_auto', '=', False), ('active', 'in', [True, False])])

sf_manufacturing/wizard/workpiece_delivery_wizard.py

@@ -207,8 +207,9 @@ class WorkpieceDeliveryWizard(models.TransientModel):
                     workorder.production_line_id.id != self.production_ids[0].production_line_id.id):
                 raise UserError(f'该rfid对应的制造订单号为{workorder.production_id.name}的目的生产线不一致')
 
-            # 调用打印成品条码方法
-            workorder.print_method()
+            if workorder.routing_type == '解除装夹':
+                # 调用打印成品条码方法
+                workorder.print_method()
 
             # 将对象添加到对应的同模型且是多对多类型里
             self.production_ids |= workorder.production_id

sf_plan_management/i18n/zh_CN.po

@@ -2023,6 +2023,11 @@ msgstr "<span class=\"o_stat_text\">损失</span>"
 msgid "<span class=\"o_stat_text\">Maintenance</span>"
 msgstr ""
 
+#. module: sf_manufacturing
+#: model:ir.model.fields.selection,name:sf_manufacturing.selection__mrp_production__state__confirmed
+msgid "待排程"
+msgstr "待排程"
+
 #. module: mrp
 #: model_terms:ir.ui.view,arch_db:mrp.product_product_form_view_bom_button
 #: model_terms:ir.ui.view,arch_db:mrp.product_template_form_view_bom_button

sf_quality/models/quality_cnc_test.py

@@ -25,7 +25,7 @@ class SfQualityCncTest(models.Model):
         ('pass', '合格'),
         ('fail', '不合格')], string='判定结果')
     number = fields.Integer('数量', default=1)
-    test_results = fields.Selection([("合格", "合格"), ("返工", "返工"), ("报废", "报废")], string="检测结果")
+    test_results = fields.Selection([("合格", "合格"), ("返工", "返工")], string="检测结果")
     reason = fields.Selection(
         [("programming", "编程"), ("cutter", "刀具"), ("clamping", "装夹"), ("operate computer", "操机"),
          ("technology", "工艺"), ("customer redrawing", "客户改图")], string="原因")

sf_sale/models/sale_order.py

@@ -285,8 +285,6 @@ class RePurchaseOrder(models.Model):
         [('standard', '标准采购'), ('consignment', '工序外协'), ('outsourcing', '委外加工'), ('outside', '外购订单')],
         string='采购类型', default='standard', store=True, compute='_compute_purchase_type')
 
-    origin_sale_id = fields.Many2one('sale.order', string='销售订单号', compute='_compute_origin_sale_id')
-
     # 合同编号
     contract_number = fields.Char(string='合同编号', size=20)
     # 合同概况
@@ -311,21 +309,6 @@ class RePurchaseOrder(models.Model):
                             purchase.purchase_type = 'outsourcing'
                             break
 
-    @api.depends('order_line.move_dest_ids.group_id.mrp_production_ids',
-                 'order_line.move_ids.move_dest_ids.group_id.mrp_production_ids', 'origin')
-    def _compute_origin_sale_id(self):
-        for purchase in self:
-            productions_ids = purchase._get_mrp_productions()
-            if productions_ids:
-                if productions_ids[0].sale_order_id:
-                    purchase.origin_sale_id = productions_ids[0].sale_order_id.id
-                    continue
-            order_id = self.env['sale.order'].sudo().search([('name', '=', purchase.origin)])
-            if order_id:
-                purchase.origin_sale_id = order_id.id
-                continue
-            purchase.origin_sale_id = False
-
     delivery_warning = fields.Selection([('normal', '正常'), ('warning', '预警'), ('overdue', '已逾期')],
                                         string='交期状态', default='normal',
                                         tracking=True)
@@ -374,12 +357,16 @@ class RePurchaseOrder(models.Model):
                     'product_qty': 1,
                     'product_uom': server_template.uom_id.id
                 }))
+                # 获取服务商品最后一个供应商的采购员
+                purchase_user_id = server_template.seller_ids[-1].partner_id.purchase_user_id
                 purchase_order = self.env['purchase.order'].sudo().create({
                     'partner_id': server_template.seller_ids[0].partner_id.id,
                     'origin': production.name,
                     'state': 'draft',
                     'purchase_type': 'consignment',
-                    'order_line': server_product_process})
+                    'order_line': server_product_process,
+                    'user_id': purchase_user_id.id
+                })
                 pp.purchase_id = [(6, 0, [purchase_order.id])]
         # self.env.cr.commit()
 
@@ -409,6 +396,23 @@ class RePurchaseOrder(models.Model):
                             production = self.env['mrp.production'].search([('name', '=', production_name)])
                             for workorder in production.workorder_ids.filtered(
                                     lambda wd: wd.routing_type == '表面工艺' and wd.state == 'waiting' and line.product_id.server_product_process_parameters_id == wd.surface_technics_parameters_id):
+                                work_ids = workorder.production_id.workorder_ids.filtered(
+                                    lambda wk: wk.state not in ['done', 'rework', 'cancel'])
+                                min_sequence_wk = min(work_ids, key=lambda wk: wk.sequence)
+                                artificial_offline = (
+                                            workorder.production_id.production_type == '人工线下加工' and workorder.production_id.schedule_state != '已排')
+                                auto_production = (
+                                            workorder.production_id.production_type == '自动化产线加工' and workorder.production_id.programming_state != '已编程')
+                                if workorder.sequence == min_sequence_wk.sequence:
+                                    if artificial_offline or auto_production:
+                                        raise UserError('等待组件')
+                                else:
+                                    sorted_work_ids = work_ids.sorted(key=lambda w: w.sequence)
+                                    previous_workorder = self.env['mrp.workorder'].search([('sequence', '<', workorder.sequence),
+                                    ('production_id', '=', workorder.production_id.id),
+                                    ('state', '=', 'done')], order='sequence desc', limit=1)
+                                    if not previous_workorder:
+                                        raise UserError('等待组件')
                                 workorder.state = 'ready'
 
         return result
@@ -441,6 +445,7 @@ class PurchaseOrderLine(models.Model):
     part_name = fields.Char('零件名称', related='product_id.part_name', readonly=True)
     # part_number = fields.Char('零件图号',related='product_id.part_number', readonly=True)
 
+
 class ResPartnerToSale(models.Model):
     _inherit = 'res.partner'
 

sf_sale/views/purchase_order_view.xml

@@ -190,11 +190,6 @@
                     <field name="partner_ref" string="合同名称"/>
                     <field name="contract_number"/>
                 </xpath>
-                <!--                添加销售订单号字段-->
-                <xpath expr="//sheet/group/group[2]/div[@name='date_approve']" position="after">
-<!--                     <field name="origin_sale_id" readonly="1" attrs="{'invisible': [('origin_sale_id', '=', False)]}" string="参考销售订单"/> -->
-                    <field name="origin_sale_id" readonly="1" string="参考销售订单"/>
-                </xpath>
                 <xpath expr="//sheet/group/group[2]/field[@name='effective_date']" position="attributes">
                     <attribute name="invisible">1</attribute>
                 </xpath>