优化配置

刘小明

2024-10-12 6518c722cbd542436787da4f864ef5ce26837d21

优化配置

 pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoOth/OthStatisticWorkloadMapper.java

@@ -1,6 +1,7 @@
package com.dy.pmsGlobal.daoOth;

import com.dy.pmsGlobal.pojoOth.OthStatisticWorkload;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDate;
import java.util.Date;
@@ -27,5 +28,5 @@

    Date selectMaxDate();

    void insertBatch(Date startDt, Date endDt);
    void insertBatch(@Param("startDt")Date startDt, @Param("endDt") Date endDt);
}

 pms-parent/pms-global/src/main/resources/application-global.yml

@@ -2,8 +2,8 @@
    servlet:
        multipart:
            # 前端上传文件，限制单个文件的大小和限制所有文件的大小
            max-file-size: 20MB
            max-request-size: 25MB
            max-file-size: 500MB
            max-request-size: 5000MB
logging:
    charset:
        console: UTF-8

 pms-parent/pms-global/src/main/resources/mapper/OthStatisticWorkloadMapper.xml

@@ -70,7 +70,7 @@
        ,user_name,type,node_content
        ,number)
         WITH  total as (select
             DISTINCT(t.device_no),t.curr_node,t.node_content,t.number,p.pro_name, p.plan_name,u.id user_id,u.`name` user_name
             DISTINCT(t.device_no) device_no,t.curr_node,t.node_content,t.number,p.pro_name, p.plan_name,u.id user_id,u.`name` user_name
            FROM
              (select * from sta_device_production_log_past
               where repair_id IS NULL and out_time BETWEEN #{startDt} AND #{endDt}