From bbd62792fcf95c2ef6c8c0696fd8601869eb1d49 Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期五, 20 九月 2024 11:46:06 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml | 4 ++-- ycl-server/src/main/java/com/ycl/task/WorkOrderImgTask.java | 1 + ycl-server/src/main/resources/mapper/zgyw/WorkOrderYwConditionRecordMapper.xml | 6 ++++-- ycl-server/src/main/java/com/ycl/utils/http/HttpUtils.java | 1 + 4 files changed, 8 insertions(+), 4 deletions(-) diff --git a/ycl-server/src/main/java/com/ycl/task/WorkOrderImgTask.java b/ycl-server/src/main/java/com/ycl/task/WorkOrderImgTask.java index 80a32cc..847391b 100644 --- a/ycl-server/src/main/java/com/ycl/task/WorkOrderImgTask.java +++ b/ycl-server/src/main/java/com/ycl/task/WorkOrderImgTask.java @@ -57,6 +57,7 @@ if (CollectionUtils.isEmpty(deviceList)) { return; } + log.info("姝ゆ鍏辨娴嬪伐鍗曞浘鐗囧伐鍗曟暟" + deviceList.size()); // 鏌ュ嚭鍥芥爣璁惧锛屽氨涓�鏉℃暟鎹� List<DeviceInfo> gbDevices = new LambdaQueryChainWrapper<>(deviceInfoMapper) .orderByDesc(DeviceInfo::getUpdateTime) diff --git a/ycl-server/src/main/java/com/ycl/utils/http/HttpUtils.java b/ycl-server/src/main/java/com/ycl/utils/http/HttpUtils.java index e446221..676b7b3 100644 --- a/ycl-server/src/main/java/com/ycl/utils/http/HttpUtils.java +++ b/ycl-server/src/main/java/com/ycl/utils/http/HttpUtils.java @@ -64,6 +64,7 @@ log.info("sendGet - {}", urlNameString); URL realUrl = new URL(urlNameString); URLConnection connection = realUrl.openConnection(); + connection.setConnectTimeout(20000); // 20s瓒呮椂 connection.setRequestProperty("accept", "*/*"); connection.setRequestProperty("connection", "Keep-Alive"); connection.setRequestProperty("user-agent", "Mozilla/5.0 (Windows NT 10.0; Win64; x64)"); diff --git a/ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml index b650439..3be2778 100644 --- a/ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml +++ b/ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml @@ -238,8 +238,8 @@ FROM t_work_order wo WHERE - wo.create_time BETWEEN #{start} AND #{end} AND wo.status = 'AUDITING' - AND deleted = 0 + wo.status = 'YW_HANDLE' + AND wo.deleted = 0 </select> <insert id="addMany"> diff --git a/ycl-server/src/main/resources/mapper/zgyw/WorkOrderYwConditionRecordMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/WorkOrderYwConditionRecordMapper.xml index b484ef5..09d7a95 100644 --- a/ycl-server/src/main/resources/mapper/zgyw/WorkOrderYwConditionRecordMapper.xml +++ b/ycl-server/src/main/resources/mapper/zgyw/WorkOrderYwConditionRecordMapper.xml @@ -14,10 +14,12 @@ </resultMap> <select id="selectYwConditionByYwId" resultMap="BaseResultMap"> - SELECT yw.id, yu.id as unit_id, yu.unit_name, yw.yw_proofMaterials, yw.create_time, yw.sys_msg, su.nick_name + SELECT DISTINCT yw.id, yu.id as unit_id, yu.unit_name, yw.yw_proofMaterials, yw.create_time, yw.sys_msg, su.nick_name FROM t_work_order_yw_condition_record yw - LEFT JOIN sys_user su ON yw.commit_user = su.user_id AND yw.deleted = 0 AND yw.work_order_no = #{workOrderNo} + LEFT JOIN sys_user su ON yw.commit_user = su.user_id AND yw.deleted = 0 LEFT JOIN t_yw_unit yu ON su.unit_id = yu.id + WHERE + yw.work_order_no = #{workOrderNo} ORDER BY yw.create_time DESC </select> -- Gitblit v1.8.0