From 7439e7de1b827e986aa03f9650ab8ca6b9ca51c7 Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期四, 18 七月 2024 10:20:02 +0800
Subject: [PATCH] Merge branch 'master' of http://bore.pub:10439/r/ERP_override
---
north-glass-erp/northglass-erp/src/views/pp/reportingWorks/AddReportingWork.vue | 3 +--
north-glass-erp/src/main/resources/mapper/pp/ReportingWork.xml | 15 +++++++++------
2 files changed, 10 insertions(+), 8 deletions(-)
diff --git a/north-glass-erp/northglass-erp/src/views/pp/reportingWorks/AddReportingWork.vue b/north-glass-erp/northglass-erp/src/views/pp/reportingWorks/AddReportingWork.vue
index 72943eb..0faacb6 100644
--- a/north-glass-erp/northglass-erp/src/views/pp/reportingWorks/AddReportingWork.vue
+++ b/north-glass-erp/northglass-erp/src/views/pp/reportingWorks/AddReportingWork.vue
@@ -412,7 +412,6 @@
//鏍规嵁琛ョ墖鐘舵�佸垽鏂槸鍚﹁兘淇敼
request.post(`/reportingWork/getPatchCondition/${route.query.reportingWorkId}`).then(async (res) => {
if (res.code == 200) {
- console.log(res.data)
if (res.data > 0) {
ElMessage.error("璇ユ姤宸ュ寘鍚凡琛ョ墖鏁版嵁锛屼笉鍙慨鏀�!")
return
@@ -584,7 +583,7 @@
},
{
field: 'responsiblePersonnel',
- title: t('reportingWorks.responsiblePersonnel'),
+ title: '璐ｄ换淇℃伅',
editRender: {name: 'input', attrs: {placeholder: ''}}
},
diff --git a/north-glass-erp/src/main/resources/mapper/pp/ReportingWork.xml b/north-glass-erp/src/main/resources/mapper/pp/ReportingWork.xml
index a46c13d..459e971 100644
--- a/north-glass-erp/src/main/resources/mapper/pp/ReportingWork.xml
+++ b/north-glass-erp/src/main/resources/mapper/pp/ReportingWork.xml
@@ -591,7 +591,12 @@
</select>
<!-- 鏌ヨ涓嬪伐搴忔槸鍚︽姤宸�-->
<select id="selectCountByProcessId">
- select count(reporting_work_id) from reporting_work where this_process=#{nextProcess} and process_id=#{processId}
+ select count(reporting_work_id)
+ from reporting_work
+ where
+ this_process=#{nextProcess}
+ and process_id=#{processId}
+ and reviewed_state>-1
</select>
<!-- 鏌ヨ瀹屽伐娆＄牬鏁伴噺-->
@@ -600,12 +605,10 @@
rwd.order_number,
rwd.technology_number,
rwd.completed_quantity,
- IFNULL(SUM(dd.breakage_quantity), 0) as breakage_quantity
+ rwd.breakage_quantity as breakage_quantity
from reporting_work as rw
- left join reporting_work_detail as rwd on rw.reporting_work_id = rwd.reporting_work_id
- left join damage_details as dd
- on dd.reporting_work_id = rwd.reporting_work_id and dd.order_number = rwd.order_number and
- dd.technology_number = rwd.technology_number
+ left join reporting_work_detail as rwd on rw.reporting_work_id = rwd.reporting_work_id
+
where rw.reporting_work_id = #{reportingWorkId}
GROUP BY rwd.order_number, rwd.technology_number
</select>
--
Gitblit v1.8.0