修改服务地址

jikimo_purchase_request/models/product_template.py

@@ -13,7 +13,11 @@ class ProductTemplate(models.Model):
         template_id.purchase_request = product_id.purchase_request
         return template_id
 
+
+class ProdcutProduct(models.Model):
+    _inherit = 'product.product'
+
     def copy_template(self, product_template_id):
         """ 复制成品模板时，复制采购申请 """
-        super(ProductTemplate, self).copy_template(product_template_id)
+        super(ProdcutProduct, self).copy_template(product_template_id)
         self.purchase_request = product_template_id.purchase_request

jikimo_sale_multiple_supply_methods/models/product_template.py

@@ -6,6 +6,10 @@ class ProductTemplate(models.Model):
     is_manual_processing = fields.Boolean(string='人工线下加工')
     is_customer_provided = fields.Boolean(string='客供料')
 
+
+class ProductProduct(models.Model):
+    _inherit = 'product.product'
+
     def copy_template(self, product_template_id):
         if not isinstance(product_template_id, ProductTemplate):
             raise ValueError('%s必须是ProductTemplate类型' % product_template_id)

jikimo_workorder_exception/controllers/main.py

@@ -4,6 +4,7 @@ import json
 import logging
 from odoo.addons.sf_mrs_connect.controllers.controllers import Sf_Mrs_Connect
 from odoo.addons.sf_manufacturing.controllers.controllers import Manufacturing_Connect
+from odoo.addons.sf_base.decorators.api_log import api_log
 from datetime import datetime
 
 _logger = logging.getLogger(__name__)
@@ -12,6 +13,7 @@ class WorkorderExceptionConroller(http.Controller):
 
     @http.route('/AutoDeviceApi/BillError', type='json', auth='public', methods=['GET', 'POST'], csrf=False,
                 cors="*")
+    @api_log('工单对接错误', requester='中控系统')
     def workder_exception(self, **kw):
         """
             记录工单异常

sf_base/commons/common.py

@@ -103,12 +103,19 @@ class PrintingUtils(models.AbstractModel):
         self.send_to_printer(host, port, zpl_code)
 
 
-    def add_qr_code_to_pdf(self, pdf_path:str, content:str, buttom_text:Optional[str]=False):
+    def add_qr_code_to_pdf(
+            self,
+            pdf_path:str,
+            content:str,
+            qr_code_buttom_text:Optional[str]=False,
+            buttom_text:Optional[str]=False,
+    ):
         """
         在PDF文件中添加二维码
         :param pdf_path: PDF文件路径
         :param content: 二维码内容
-        :param buttom_text: 二维码下方文字
+        :param qr_code_buttom_text: 二维码下方文字
+        :param buttom_text: 正文下方文字
         :return: 是否成功
         """
         if not os.path.exists(pdf_path):
@@ -156,8 +163,9 @@ class PrintingUtils(models.AbstractModel):
                 existing_pdf = PdfFileReader(original_file)
                 output = PdfFileWriter()
                 
-                # 处理第一页
-                page = existing_pdf.getPage(0)
+                # 处理最后一页
+                last_page = existing_pdf.getNumPages() - 1
+                page = existing_pdf.getPage(last_page)
                 # 获取页面尺寸
                 page_width = float(page.mediaBox.getWidth())
                 page_height = float(page.mediaBox.getHeight())
@@ -179,13 +187,21 @@ class PrintingUtils(models.AbstractModel):
                 qr_y = margin + 20  # 将二维码向上移动一点，为文字留出空间
                 c.drawImage(qr_temp_path, page_width - qr_size - margin, qr_y, width=qr_size, height=qr_size)
                 
-                if buttom_text:
+                if qr_code_buttom_text:
                     # 在二维码下方绘制文字
-                    text = buttom_text
+                    text = qr_code_buttom_text
                     text_width = c.stringWidth(text, "SimSun" if font_found else "Helvetica", 10)  # 准确计算文字宽度
                     text_x = page_width - qr_size - margin + (qr_size - text_width) / 2  # 文字居中对齐
                     text_y = margin + 20  # 文字位置靠近底部
                     c.drawString(text_x, text_y, text)
+
+                if buttom_text:
+                    # 在下方中间添加文字
+                    text = button_text
+                    text_width = c.stringWidth(text, "SimSun" if font_found else "Helvetica", 10)  # 准确计算文字宽度
+                    text_x = (page_width - text_width) / 2  # 文字居中对齐
+                    text_y = margin + 20  # 文字位置靠近底部
+                    c.drawString(text_x, text_y, text)
                 
                 c.save()
                 
@@ -196,11 +212,12 @@ class PrintingUtils(models.AbstractModel):
                     
                     # 合并原始页面和二维码页面
                     page.mergePage(qr_page)
-                    output.addPage(page)
                     
                     # 添加剩余的页面
-                    for i in range(1, existing_pdf.getNumPages()):
+                    for i in range(0, last_page):
                         output.addPage(existing_pdf.getPage(i))
+
+                    output.addPage(page)
                     
                     # 保存最终的PDF到一个临时文件
                     final_temp_path = pdf_path + '.tmp'

sf_manufacturing/__manifest__.py

@@ -20,6 +20,7 @@
         'data/sf_work_individuation_page.xml',
         'data/agv_scheduling_data.xml',
         'data/product_data.xml',
+        'data/automation_folder_data.xml',
         'security/group_security.xml',
         'security/ir.model.access.csv',
         'wizard/workpiece_delivery_views.xml',

sf_manufacturing/controllers/controllers.py

@@ -2,16 +2,18 @@
 import logging
 import json
 from datetime import datetime
+import base64
 
 from odoo.addons.sf_manufacturing.models.agv_scheduling import RepeatTaskException
 from odoo import http
 from odoo.http import request
+from odoo.exceptions import MissingError
 from odoo.addons.sf_base.decorators.api_log import api_log
 
 
 class Manufacturing_Connect(http.Controller):
 
-    @http.route('/AutoDeviceApi/GetWoInfo', type='json', auth='sf_token', methods=['GET', 'POST'], csrf=False,
+    @http.route('/AutoDeviceApi/GetWoInfo', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
                 cors="*")
     @api_log('获取工单', requester='中控系统')
     def get_Work_Info(self, **kw):
@@ -54,8 +56,9 @@ class Manufacturing_Connect(http.Controller):
             logging.info('get_Work_Info error:%s' % e)
         return json.JSONEncoder().encode(res)
 
-    @http.route('/AutoDeviceApi/GetShiftPlan', type='json', auth='sf_token', methods=['GET', 'POST'], csrf=False,
+    @http.route('/AutoDeviceApi/GetShiftPlan', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
                 cors="*")
+    @api_log('获取日计划', requester='中控系统')
     def get_ShiftPlan(self, **kw):
         """
         自动化每天获取机台日计划
@@ -107,7 +110,7 @@ class Manufacturing_Connect(http.Controller):
             logging.info('get_ShiftPlan error:%s' % e)
         return json.JSONEncoder().encode(res)
 
-    @http.route('/AutoDeviceApi/QcCheck', type='json', auth='sf_token', methods=['GET', 'POST'], csrf=False,
+    @http.route('/AutoDeviceApi/QcCheck', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
                 cors="*")
     @api_log('工件预调(前置三元检测)', requester='中控系统')
     def get_qcCheck(self, **kw):
@@ -703,3 +706,59 @@ class Manufacturing_Connect(http.Controller):
             res = {'Succeed': False, 'ErrorCode': 202, 'Error': str(e)}
             logging.info('AGVDownProduct error:%s' % e)
         return json.JSONEncoder().encode(res)
+
+    @http.route('/api/upload_three_check_data', type='http', auth='public', methods=['POST'], csrf=False, cros='*')
+    def upload_three_check_data(self):
+
+        res = {'Succeed': True, 'ErrorCode': 200, 'Messages': '上传成功'}
+        uploaded_files = request.httprequest.files.getlist('file')
+        if uploaded_files:
+
+            try:
+                for uploaded_file in uploaded_files:
+                    file_content = uploaded_file.read()
+                    file_name = uploaded_file.filename
+
+                    production_name = '/'.join(file_name.split('_')[:-1])
+                    processing_panel = file_name.split('_')[-1].split('.')[0]
+                    # 找到对应的工单
+                    production_id = request.env['mrp.production'].sudo().search([('name', '=', production_name)])
+                    wo = production_id.workorder_ids.filtered(lambda wo: wo.processing_panel == processing_panel and wo.routing_type == '装夹预调')
+
+                    if not wo:
+                        raise MissingError('工单不存在')
+                    
+                    folder_id = request.env.ref('sf_manufacturing.documents_pre_three_element_detection_folder')
+                    
+                    document = request.env['documents.document'].sudo().search([('res_model', '=', 'mrp.workorder'), ('res_id', '=', wo.id)])
+                    if document and document.attachment_id:
+                        attachment = request.env['ir.attachment'].sudo().create({
+                            'name': file_name,
+                            'type': 'binary',
+                            'datas': base64.b64encode(file_content),
+                            'res_model': 'mrp.workorder',
+                            'res_id': wo.id,
+                            })
+                        document.write({'attachment_id': attachment.id})
+                    else:
+                        # Create ir.attachment record
+                        attachment = request.env['ir.attachment'].sudo().create({
+                            'name': file_name,
+                            'type': 'binary',
+                            'datas': base64.b64encode(file_content),
+                            'res_model': 'mrp.workorder',
+                            'res_id': wo.id,
+                            })
+
+                        # 创建 documents.document 记录
+                        request.env['documents.document'].sudo().create({
+                            'name': file_name,
+                            'attachment_id': attachment.id,
+                            'folder_id': folder_id.id,
+                            'res_model': 'mrp.workorder',
+                            'res_id': wo.id,
+                        })
+            except Exception as e:
+                res = {'Succeed': False, 'ErrorCode': 202, 'Error': str(e)}
+
+        return json.JSONEncoder().encode(res)

sf_manufacturing/data/automation_folder_data.xml

@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data noupdate="1">
+        <!-- 创建自动化文件夹 -->
+        <record id="documents_automation_folder" model="documents.folder">
+            <field name="name">自动化</field>
+            <field name="description">存放自动化生产流程相关文件</field>
+            <field name="sequence">20</field>
+        </record>
+        <record id="documents_pre_three_element_detection_folder" model="documents.folder">
+            <field name="name">前置三元检测报告</field>
+            <field name="parent_folder_id" ref="documents_automation_folder"/>
+            <field name="sequence">1</field>
+        </record>
+    </data>
+</odoo>

sf_manufacturing/models/mrp_workorder.py

@@ -6,6 +6,7 @@ import urllib.parse
 from datetime import date
 from datetime import datetime, timedelta
 import requests
+import tempfile
 import os
 import math
 from lxml import etree
@@ -771,146 +772,170 @@ class ResMrpWorkOrder(models.Model):
     # 获取三次元检测点数据
     def get_three_check_datas(self):
         ftp_resconfig = self.env['res.config.settings'].get_values()
-        ftp = FtpController(str(ftp_resconfig['ftp_host']), int(ftp_resconfig['ftp_port']),
-                            ftp_resconfig['ftp_user'],
-                            ftp_resconfig['ftp_password'])
+        # ftp = FtpController(str(ftp_resconfig['ftp_host']), int(ftp_resconfig['ftp_port']),
+        #                     ftp_resconfig['ftp_user'],
+        #                     ftp_resconfig['ftp_password'])
 
-        local_dir_path = '/ftp/before'
-        os.makedirs(local_dir_path, exist_ok=True)
+        # local_dir_path = '/ftp/before'
+        # os.makedirs(local_dir_path, exist_ok=True)
         local_filename = self.save_name + '.xls'
-        local_file_path = os.path.join(local_dir_path, local_filename)
-        logging.info('local_file_path:%s' % local_file_path)
-        # remote_path = '/home/ftp/ftp_root/ThreeTest/XT/Before/' + local_filename
-        remote_path = '/ThreeTest/XT/Before/' + local_filename
-        logging.info('remote_path:%s' % remote_path)
-        is_get_detection_file = self.env['ir.config_parameter'].sudo().get_param('is_get_detection_file')
-        if not is_get_detection_file:
-            paload_data = {
-                "filename": local_filename
-            }
-            if not ftp_resconfig['get_check_file_path']:
-                raise UserError('请先配置获取检测报告地址')
-            url = ftp_resconfig['get_check_file_path'] + '/get/check/report'
-            response = requests.post(url, json=paload_data)
-            logging.info('response:%s' % response.json())
-            if response.json().get('detail'):
-                raise UserError(response.json().get('detail'))
+        # local_file_path = os.path.join(local_dir_path, local_filename)
+        # logging.info('local_file_path:%s' % local_file_path)
+        # # remote_path = '/home/ftp/ftp_root/ThreeTest/XT/Before/' + local_filename
+        # remote_path = '/ThreeTest/XT/Before/' + local_filename
+        # logging.info('remote_path:%s' % remote_path)
+        # is_get_detection_file = self.env['ir.config_parameter'].sudo().get_param('is_get_detection_file')
+        # if not is_get_detection_file:
+        base_url = self.env['ir.config_parameter'].sudo().get_param('web.base.url')
+        paload_data = {
+            "filename": local_filename,
+            "sf_host": base_url
+        }
+        if not ftp_resconfig['get_check_file_path']:
+            raise UserError('请先配置获取检测报告地址')
+        url = ftp_resconfig['get_check_file_path'] + '/get/check/report'
+        response = requests.post(url, json=paload_data)
+        #     logging.info('response:%s' % response.json())
+        #     if response.json().get('detail'):
+        #         raise UserError(response.json().get('detail'))
 
-        if not ftp.file_exists(remote_path):
-            raise UserError(f"文件不存在: {remote_path}")
+        # if not ftp.file_exists(remote_path):
+        #     raise UserError(f"文件不存在: {remote_path}")
 
-        with open(local_file_path, 'wb') as local_file:
-            ftp.ftp.retrbinary('RETR ' + remote_path, local_file.write)
-        logging.info('下载文件成功')
-        # 解析本地文件
-        # file_path = 'WH_MO_00099.xls'  # 使用下载的实际文件路径
-        parser = etree.XMLParser(recover=True)  # Using recover to handle errors
-        tree = etree.parse(local_file_path, parser)
-        logging.info('tree:%s' % tree)
-        root = tree.getroot()
-        logging.info('root:%s' % root)
+        # with open(local_file_path, 'wb') as local_file:
+        #     ftp.ftp.retrbinary('RETR ' + remote_path, local_file.write)
+        # logging.info('下载文件成功')
+           
+        document = self.env['documents.document'].sudo().search([('res_model', '=', 'mrp.workorder'), ('res_id', '=', self.id)])
+        if not document:
+            raise UserError(f"未获取到检测数据")
+        binary_data = base64.b64decode(document.attachment_id.datas)
 
-        # 准备一个外部字典来存储以PT为键的坐标字典
-        pt_coordinates = {}
-        # 遍历每个工作表和行
-        for worksheet in root.iterfind('.//{urn:schemas-microsoft-com:office:spreadsheet}Worksheet'):
-            sheet_name = worksheet.attrib.get('{urn:schemas-microsoft-com:office:spreadsheet}Name')
-            logging.info('sheet_name:%s' % sheet_name)
-            if sheet_name == "Sheet1":  # 确保我们只查看包含数据的工作表
-                current_pt = None
-                for row in worksheet.iterfind('.//{urn:schemas-microsoft-com:office:spreadsheet}Row'):
-                    cells = list(row.iterfind('.//{urn:schemas-microsoft-com:office:spreadsheet}Cell'))
-                    for i, cell in enumerate(cells):
-                        data_cell = cell.find('.//{urn:schemas-microsoft-com:office:spreadsheet}Data')
-                        if data_cell is not None and data_cell.text is not None:  # 添加检查以确保data_cell.text不为空
-                            # 检查是否是PT标识
-                            logging.info(f"Data in cell: {data_cell.text}")  # 输出单元格数据
-                            if "PT" in data_cell.text:
-                                current_pt = data_cell.text
-                                pt_coordinates[current_pt] = []
-                            elif data_cell.text in ["X", "Y", "Z"] and current_pt is not None:
-                                # 确保当前单元格后面还有单元格存在，以获取理论值
-                                if i + 1 < len(cells):
-                                    next_cell = cells[i + 1]
-                                    theory_value = next_cell.find(
-                                        './/{urn:schemas-microsoft-com:office:spreadsheet}Data')
-                                    if theory_value is not None:
-                                        # 为当前PT键添加坐标数据
-                                        pt_coordinates[current_pt].append({
-                                            data_cell.text: float(theory_value.text)
-                                        })
-                                        logging.info(f"PT: {current_pt} - {data_cell.text}: {theory_value.text}")
-        logging.info('pt_coordinates=====%s' % pt_coordinates)
-        # pt_coordinates:{'PT1': [{'X': 38.9221}, {'Y': -18.7304}, {'Z': 128.0783}],
-        #                         'PT2': [{'X': 39.2456}, {'Y': -76.9169}, {'Z': 123.7541}]}
+        # 创建临时文件保存响应内容
+        with tempfile.NamedTemporaryFile(delete=False, suffix='.xls') as temp_file:
+            temp_file.write(binary_data)
+            temp_file_path = temp_file.name
+            
+        try:
+            # 使用临时文件进行解析
+            parser = etree.XMLParser(recover=True)
+            tree = etree.parse(temp_file_path, parser)
+            logging.info('tree:%s' % tree)
+            root = tree.getroot()
+            logging.info('root:%s' % root)
+            
 
-        # 检查是否存在PT1等键
-        if 'PT1' in pt_coordinates and pt_coordinates['PT1']:
-            self.X1_axis = pt_coordinates['PT3'][0]['X']
-            self.Y1_axis = pt_coordinates['PT3'][1]['Y']
-            self.Z1_axis = pt_coordinates['PT3'][2]['Z']
-        else:
-            raise UserError('PT1点未测或数据错误')
-        if 'PT2' in pt_coordinates and pt_coordinates['PT2']:
-            self.X2_axis = pt_coordinates['PT4'][0]['X']
-            self.Y2_axis = pt_coordinates['PT4'][1]['Y']
-            self.Z2_axis = pt_coordinates['PT4'][2]['Z']
-        else:
-            raise UserError('PT2点未测或数据错误')
-        if 'PT3' in pt_coordinates and pt_coordinates['PT3']:
-            self.X3_axis = pt_coordinates['PT5'][0]['X']
-            self.Y3_axis = pt_coordinates['PT5'][1]['Y']
-            self.Z3_axis = pt_coordinates['PT5'][2]['Z']
-        else:
-            raise UserError('PT3点未测或数据错误')
-        if 'PT4' in pt_coordinates and pt_coordinates['PT4']:
-            self.X4_axis = pt_coordinates['PT6'][0]['X']
-            self.Y4_axis = pt_coordinates['PT6'][1]['Y']
-            self.Z4_axis = pt_coordinates['PT6'][2]['Z']
-        else:
-            raise UserError('PT4点未测或数据错误')
-        if 'PT5' in pt_coordinates and pt_coordinates['PT5']:
-            self.X5_axis = pt_coordinates['PT7'][0]['X']
-            self.Y5_axis = pt_coordinates['PT7'][1]['Y']
-            self.Z5_axis = pt_coordinates['PT7'][2]['Z']
-        else:
-            raise UserError('PT5点未测或数据错误')
-        if 'PT6' in pt_coordinates and pt_coordinates['PT6']:
-            self.X6_axis = pt_coordinates['PT8'][0]['X']
-            self.Y6_axis = pt_coordinates['PT8'][1]['Y']
-            self.Z6_axis = pt_coordinates['PT8'][2]['Z']
-        else:
-            raise UserError('PT6点未测或数据错误')
-        if 'PT7' in pt_coordinates and pt_coordinates['PT7']:
-            self.X7_axis = pt_coordinates['PT9'][0]['X']
-            self.Y7_axis = pt_coordinates['PT9'][1]['Y']
-            self.Z7_axis = pt_coordinates['PT9'][2]['Z']
-        else:
-            raise UserError('PT7点未测或数据错误')
-        if 'PT8' in pt_coordinates and pt_coordinates['PT8']:
-            self.X8_axis = pt_coordinates['PT10'][0]['X']
-            self.Y8_axis = pt_coordinates['PT10'][1]['Y']
-            self.Z8_axis = pt_coordinates['PT10'][2]['Z']
-        else:
-            raise UserError('PT8点未测或数据错误')
-        if 'PT9' in pt_coordinates and pt_coordinates['PT9']:
-            self.X9_axis = pt_coordinates['PT1'][0]['X']
-            self.Y9_axis = pt_coordinates['PT1'][1]['Y']
-            self.Z9_axis = pt_coordinates['PT1'][2]['Z']
-        else:
-            raise UserError('PT9点未测或数据错误')
-        if 'PT10' in pt_coordinates and pt_coordinates['PT10']:
-            self.X10_axis = pt_coordinates['PT2'][0]['X']
-            self.Y10_axis = pt_coordinates['PT2'][1]['Y']
-            self.Z10_axis = pt_coordinates['PT2'][2]['Z']
-        else:
-            raise UserError('PT10点未测或数据错误')
+            # 准备一个外部字典来存储以PT为键的坐标字典
+            pt_coordinates = {}
+            # 遍历每个工作表和行
+            for worksheet in root.iterfind('.//{urn:schemas-microsoft-com:office:spreadsheet}Worksheet'):
+                sheet_name = worksheet.attrib.get('{urn:schemas-microsoft-com:office:spreadsheet}Name')
+                logging.info('sheet_name:%s' % sheet_name)
+                if sheet_name == "Sheet1":  # 确保我们只查看包含数据的工作表
+                    current_pt = None
+                    for row in worksheet.iterfind('.//{urn:schemas-microsoft-com:office:spreadsheet}Row'):
+                        cells = list(row.iterfind('.//{urn:schemas-microsoft-com:office:spreadsheet}Cell'))
+                        for i, cell in enumerate(cells):
+                            data_cell = cell.find('.//{urn:schemas-microsoft-com:office:spreadsheet}Data')
+                            if data_cell is not None and data_cell.text is not None:  # 添加检查以确保data_cell.text不为空
+                                # 检查是否是PT标识
+                                logging.info(f"Data in cell: {data_cell.text}")  # 输出单元格数据
+                                if "PT" in data_cell.text:
+                                    current_pt = data_cell.text
+                                    pt_coordinates[current_pt] = []
+                                elif data_cell.text in ["X", "Y", "Z"] and current_pt is not None:
+                                    # 确保当前单元格后面还有单元格存在，以获取理论值
+                                    if i + 1 < len(cells):
+                                        next_cell = cells[i + 1]
+                                        theory_value = next_cell.find(
+                                            './/{urn:schemas-microsoft-com:office:spreadsheet}Data')
+                                        if theory_value is not None:
+                                            # 为当前PT键添加坐标数据
+                                            pt_coordinates[current_pt].append({
+                                                data_cell.text: float(theory_value.text)
+                                            })
+                                            logging.info(f"PT: {current_pt} - {data_cell.text}: {theory_value.text}")
+            logging.info('pt_coordinates=====%s' % pt_coordinates)
+            # pt_coordinates:{'PT1': [{'X': 38.9221}, {'Y': -18.7304}, {'Z': 128.0783}],
+            #                         'PT2': [{'X': 39.2456}, {'Y': -76.9169}, {'Z': 123.7541}]}
 
-        self.data_state = True
-        self.getcenter()
+            # 检查是否存在PT1等键
+            if 'PT1' in pt_coordinates and pt_coordinates['PT1']:
+                self.X1_axis = pt_coordinates['PT3'][0]['X']
+                self.Y1_axis = pt_coordinates['PT3'][1]['Y']
+                self.Z1_axis = pt_coordinates['PT3'][2]['Z']
+            else:
+                raise UserError('PT1点未测或数据错误')
+            if 'PT2' in pt_coordinates and pt_coordinates['PT2']:
+                self.X2_axis = pt_coordinates['PT4'][0]['X']
+                self.Y2_axis = pt_coordinates['PT4'][1]['Y']
+                self.Z2_axis = pt_coordinates['PT4'][2]['Z']
+            else:
+                raise UserError('PT2点未测或数据错误')
+            if 'PT3' in pt_coordinates and pt_coordinates['PT3']:
+                self.X3_axis = pt_coordinates['PT5'][0]['X']
+                self.Y3_axis = pt_coordinates['PT5'][1]['Y']
+                self.Z3_axis = pt_coordinates['PT5'][2]['Z']
+            else:
+                raise UserError('PT3点未测或数据错误')
+            if 'PT4' in pt_coordinates and pt_coordinates['PT4']:
+                self.X4_axis = pt_coordinates['PT6'][0]['X']
+                self.Y4_axis = pt_coordinates['PT6'][1]['Y']
+                self.Z4_axis = pt_coordinates['PT6'][2]['Z']
+            else:
+                raise UserError('PT4点未测或数据错误')
+            if 'PT5' in pt_coordinates and pt_coordinates['PT5']:
+                self.X5_axis = pt_coordinates['PT7'][0]['X']
+                self.Y5_axis = pt_coordinates['PT7'][1]['Y']
+                self.Z5_axis = pt_coordinates['PT7'][2]['Z']
+            else:
+                raise UserError('PT5点未测或数据错误')
+            if 'PT6' in pt_coordinates and pt_coordinates['PT6']:
+                self.X6_axis = pt_coordinates['PT8'][0]['X']
+                self.Y6_axis = pt_coordinates['PT8'][1]['Y']
+                self.Z6_axis = pt_coordinates['PT8'][2]['Z']
+            else:
+                raise UserError('PT6点未测或数据错误')
+            if 'PT7' in pt_coordinates and pt_coordinates['PT7']:
+                self.X7_axis = pt_coordinates['PT9'][0]['X']
+                self.Y7_axis = pt_coordinates['PT9'][1]['Y']
+                self.Z7_axis = pt_coordinates['PT9'][2]['Z']
+            else:
+                raise UserError('PT7点未测或数据错误')
+            if 'PT8' in pt_coordinates and pt_coordinates['PT8']:
+                self.X8_axis = pt_coordinates['PT10'][0]['X']
+                self.Y8_axis = pt_coordinates['PT10'][1]['Y']
+                self.Z8_axis = pt_coordinates['PT10'][2]['Z']
+            else:
+                raise UserError('PT8点未测或数据错误')
+            if 'PT9' in pt_coordinates and pt_coordinates['PT9']:
+                self.X9_axis = pt_coordinates['PT1'][0]['X']
+                self.Y9_axis = pt_coordinates['PT1'][1]['Y']
+                self.Z9_axis = pt_coordinates['PT1'][2]['Z']
+            else:
+                raise UserError('PT9点未测或数据错误')
+            if 'PT10' in pt_coordinates and pt_coordinates['PT10']:
+                self.X10_axis = pt_coordinates['PT2'][0]['X']
+                self.Y10_axis = pt_coordinates['PT2'][1]['Y']
+                self.Z10_axis = pt_coordinates['PT2'][2]['Z']
+            else:
+                raise UserError('PT10点未测或数据错误')
 
-        return True
+            self.data_state = True
+            self.getcenter()
 
+            return True
+            
+        except Exception as e:
+            logging.error('解析文件失败: %s' % str(e))
+            raise UserError(f'解析文件失败: {str(e)}')
+            
+        finally:
+            # 清理临时文件
+            try:
+                os.unlink(temp_file_path)
+            except Exception as e:
+                logging.warning(f'清理临时文件失败: {str(e)}')
         # ftp.download_file('three_check_datas.xls', '/home/ftpuser/three_check_datas.xls')
         # ftp.close()
         # data = xlrd.open_workbook('/home/ftpuser/three_check_datas.xls')

sf_manufacturing/models/sale_order.py

@@ -56,10 +56,10 @@ class SaleOrder(models.Model):
                     'jikimo_sale_multiple_supply_methods.product_template_manual_processing').sudo()
 
             # 复制成品模板上的属性
-            line.product_id.product_tmpl_id.copy_template(product_template_id)
+            line.product_id.copy_template(product_template_id)
             # 将模板上的single_manufacturing属性复制到成品上
-            line.product_id.single_manufacturing = product_template_id.single_manufacturing
-            line.product_id.tracking = product_template_id.tracking
+            # line.product_id.single_manufacturing = product_template_id.single_manufacturing
+            # line.product_id.tracking = product_template_id.tracking
 
             order_id = self
             product = line.product_id
@@ -76,7 +76,7 @@ class SaleOrder(models.Model):
                 'embryo_redundancy_id': line.embryo_redundancy_id,
             }
             product_name = ''
-            match = re.search(r'(S\d{5}-\d)', product.name)
+            match = re.search(r'(S\d{5}-\d*)', product.name)
             # 如果匹配成功，提取结果
             if match:
                 product_name = match.group(0)

sf_tool_management/controllers/controllers.py

@@ -41,6 +41,7 @@ class Manufacturing_Connect(http.Controller):
 
     @http.route('/AutoDeviceApi/ToolInventory', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
                 cors="*")
+    @api_log('功能刀具清单', requester='中控系统')
     def get_functional_tool_inventory_Info(self, **kw):
         """
         功能刀具清单接口
@@ -70,6 +71,7 @@ class Manufacturing_Connect(http.Controller):
 
     @http.route('/AutoDeviceApi/ToolEntity', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
                 cors="*")
+    @api_log('功能刀具', requester='中控系统')
     def get_functional_tool_entity_Info(self, **kw):
         """
         功能刀具列表接口