From 1d193f2cc23f54634ef8ed73c11436fbe76bb575 Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期一, 19 八月 2024 14:13:39 +0800
Subject: [PATCH] Merge branch 'master' of http://bore.pub:10439/r/ERP_override
---
north-glass-erp/northglass-erp/src/components/pp/PrintProcess.vue | 28 ++++--
north-glass-erp/northglass-erp/src/components/pp/SelectSortTable.vue | 15 +--
north-glass-erp/src/main/java/com/example/erp/entity/pp/DamageDetails.java | 3
north-glass-erp/northglass-erp/src/views/pp/processCard/AddProcessCard.vue | 30 +++++++
north-glass-erp/northglass-erp/src/views/pp/report/CrossProcessBreaking.vue | 2
north-glass-erp/src/main/java/com/example/erp/mapper/pp/FlowCardMapper.java | 4
north-glass-erp/src/main/java/com/example/erp/dto/pp/DamageReportDTO.java | 2
north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml | 34 +++++++-
north-glass-erp/northglass-erp/src/components/pp/SelectSortDetailProcessCard.vue | 5
north-glass-erp/northglass-erp/src/views/pp/Replenish/PrintReplenishFlowCard.vue | 2
north-glass-erp/src/main/resources/mapper/pp/Report.xml | 25 +++--
north-glass-erp/northglass-erp/src/components/pp/PrintProcessReplenish.vue | 30 ++++++
north-glass-erp/northglass-erp/src/components/pp/PrintReworkProcess.vue | 24 +++---
north-glass-erp/northglass-erp/src/views/pp/report/DamageReport.vue | 2
north-glass-erp/src/main/java/com/example/erp/service/pp/FlowCardService.java | 5
15 files changed, 153 insertions(+), 58 deletions(-)
diff --git a/north-glass-erp/northglass-erp/src/components/pp/PrintProcess.vue b/north-glass-erp/northglass-erp/src/components/pp/PrintProcess.vue
index 9d8b397..c2013ab 100644
--- a/north-glass-erp/northglass-erp/src/components/pp/PrintProcess.vue
+++ b/north-glass-erp/northglass-erp/src/components/pp/PrintProcess.vue
@@ -383,19 +383,24 @@
</td>
</tr>
- <tr v-if="company.remarkSwitch=='1'" v-for="(itemremark,index) in item.remarkList" :key="index">
+ <tr v-if="company.remarkSwitch=='1'">
<td colspan="29">
- 缂栧彿锛歿{itemremark.S01}}
- 澶囨敞1锛歿{itemremark.S02}}
- 澶囨敞2锛歿{itemremark.S03}}
- 澶囨敞3锛歿{itemremark.S04}}
- 澶囨敞4锛歿{itemremark.S05}}
-
+ <div style="display: flex;flex-wrap: wrap;">
+ <div v-for="(itemremark,index) in item.remarkList" :key="index">
+ <span v-if="!(itemremark.S02==null&&itemremark.S03==null&&itemremark.S04==null&&itemremark.S05==null)">
+ 缂栧彿锛歿{itemremark.S01}}
+ </span>
+ <span v-if="itemremark.S02!=null">澶囨敞1锛歿{itemremark.S02}}</span>
+ <span v-if="itemremark.S03!=null">澶囨敞2锛歿{itemremark.S03}}</span>
+ <span v-if="itemremark.S04!=null">澶囨敞3锛歿{itemremark.S04}}</span>
+ <span v-if="itemremark.S05!=null">澶囨敞4锛歿{itemremark.S05}}</span>
+ </div>
+ </div>
</td>
</tr>
<tr v-for="(itemtextareas,index) in item.detail" :key="index">
<td colspan="29" style="width: 480px;height: 150px ">
- <div style="width: 100%;height: 100%;"><textarea style="height: 99%;width: 99%;border: none;;font-size: 12px;overflow: hidden;">{{itemtextareas.processing_note}}</textarea>
+ <div style="width: 100%;height: 100%;text-align: left"><textarea style="height: 99%;width: 99%;border: none;;font-size: 12px;overflow: hidden;text-align: left;vertical-align: middle">{{itemtextareas.processing_note}}</textarea>
</div>
</td>
</tr>
@@ -410,9 +415,10 @@
* {
margin: 0;
padding: 0;
+}
+td,input{
text-align: center;
}
-
#printFlowCard {
text-align: center;
@@ -442,11 +448,11 @@
}
#contentTable tbody {
-
+white-space: nowrap;
}
.tdNowrap {
-
+ white-space: nowrap;
}
#contentTable tfoot {
diff --git a/north-glass-erp/northglass-erp/src/components/pp/PrintProcessReplenish.vue b/north-glass-erp/northglass-erp/src/components/pp/PrintProcessReplenish.vue
index 01712d3..b3c0880 100644
--- a/north-glass-erp/northglass-erp/src/components/pp/PrintProcessReplenish.vue
+++ b/north-glass-erp/northglass-erp/src/components/pp/PrintProcessReplenish.vue
@@ -54,7 +54,7 @@
// }
// });
// data.value.printList = Object.values(uniqueObjects);
-let flowCardCount = data.value.printList.length
+let flowCardCount = null
onMounted(() => {
request.post(`/processCard/getSelectPrintingRefund/${merge}/${like}`, data.value).then((res) => {
if (res.code == 200) {
@@ -136,7 +136,31 @@
}
- //澶勭悊鍚岄厤缃墦鍗�
+ // 浣跨敤涓�涓璞℃潵瀛樺偍鍚堝苟鍚庣殑缁撴灉
+ const mergedData = produceList.value.reduce((acc, item) => {
+ const processId = item.detail[0].process_id;
+
+ // 濡傛灉璇� process_id 灏氭湭鍦� acc 涓紝鍒濆鍖栧叾鏁扮粍
+ if (!acc[processId]) {
+ acc[processId] = {
+ processList: item.processList,
+ detailList: [],
+ detail: item.detail
+ };
+ }
+
+ // 鍚堝苟 detailList
+ acc[processId].detailList = acc[processId].detailList.concat(item.detailList);
+
+ return acc;
+ }, {});
+
+// 灏嗗悎骞跺悗鐨勫璞¤浆鎹㈠洖鏁扮粍
+ produceList.value = Object.values(mergedData);
+
+ flowCardCount=produceList.value.length
+
+
handleSummary()
handleGetQRCode()
} else {
@@ -395,7 +419,7 @@
</tr>
<tr v-for="(itemtextareas,index) in item.detail" :key="index">
<td colspan="29" rowspan="6" style="width: 480px;height: 150px ">
- <div style="width: 100%;height: 100%;"><textarea style="height: 99%;width: 99%;border: none;;font-size: 12px">{{itemtextareas.processing_note}}</textarea>
+ <div style="width: 100%;height: 100%;"><textarea style="height: 99%;width: 99%;border: none;;font-size: 12px;text-align: left">{{itemtextareas.processing_note}}</textarea>
</div>
</td>
</tr>
diff --git a/north-glass-erp/northglass-erp/src/components/pp/PrintReworkProcess.vue b/north-glass-erp/northglass-erp/src/components/pp/PrintReworkProcess.vue
index 716b6eb..a02d0ee 100644
--- a/north-glass-erp/northglass-erp/src/components/pp/PrintReworkProcess.vue
+++ b/north-glass-erp/northglass-erp/src/components/pp/PrintReworkProcess.vue
@@ -122,9 +122,8 @@
}
- //澶勭悊鍚岄厤缃墦鍗�
-
+ handleSummary()
handleGetQRCode()
} else {
ElMessage.warning(res.msg)
@@ -197,11 +196,14 @@
<div id="bj" style="float: right;font-size: 28px">杩� {{ id + 1 }}</div>
<div>{{ company.companyName }}</div>
<div>鐢熶骇娴佺▼鍗�</div>
- <div v-if="itemFlow.technologyNumberMerge!=''" style="text-align: right;font-weight: bolder">娴佺▼鍗″彿锛� {{
+ <div v-if="itemFlow.technologyNumberMerge!=''" style="text-align: right;font-weight: bolder">{{itemFlow.otherRemarks}}
+ 娴佺▼鍗″彿锛� {{
itemFlow.process_id
}}/{{ itemFlow.technologyNumberMerge }} 鍏� {{ flowCardCount }} 鏋�
</div>
- <div v-else style="text-align: right;font-weight: bolder">娴佺▼鍗″彿锛� {{
+ <div v-else style="text-align: right;font-weight: bolder">
+ {{itemFlow.otherRemarks}}
+ 娴佺▼鍗″彿锛� {{
itemFlow.process_id
}}/{{ itemFlow.technologyNumber }} 鍏� {{ flowCardCount }} 鏋�
</div>
@@ -317,14 +319,12 @@
</td>
</tr>
<tr v-for="(itemtextarea,index) in item.detail" :key="index">
- <td v-if="like='1'" colspan="4" rowspan="6" style="width: 480px;height: 100px ">
- <div style="width: 100%;height: 100%;"><textarea style="height: 99%;width: 99%;border: none;;font-size: 11px">{{company.printLabel.printFlowCard.processingNote(itemtextarea)}}</textarea>
- </div>
- </td>
- <td v-else colspan="6" rowspan="2" style="width: 480px;height: 100px ">
- <!-- <div style="width: 100%;height: 100%"><textarea style="height: 99%;width: 99%;font-size: 11px">{{ itemtextarea.processing_note }}</textarea>-->
- <!-- </div>-->
- <div style="width: 100%;height: 100%;"><textarea style="height: 99%;width: 99%;border: none;;font-size: 11px">{{company.printLabel.printFlowCard.processingNote(itemtextarea)}}</textarea>
+ <td colspan="4" rowspan="5" style="width: 480px;height: 100px ">
+ <div>
+ 娆＄牬绫诲瀷锛歿{itemtextarea.breakage_type}}
+ 娆＄牬鍘熷洜锛歿{itemtextarea.breakage_reason}}
+ 璐ｄ换宸ュ簭锛歿{itemtextarea.responsible_process}}
+ 璐ｄ换鐝粍锛歿{itemtextarea.responsible_team}}
</div>
</td>
<td>瀹屽伐绛惧悕</td>
diff --git a/north-glass-erp/northglass-erp/src/components/pp/SelectSortDetailProcessCard.vue b/north-glass-erp/northglass-erp/src/components/pp/SelectSortDetailProcessCard.vue
index 974bdb2..f9329c0 100644
--- a/north-glass-erp/northglass-erp/src/components/pp/SelectSortDetailProcessCard.vue
+++ b/north-glass-erp/northglass-erp/src/components/pp/SelectSortDetailProcessCard.vue
@@ -188,8 +188,9 @@
{type: 'seq', fixed: "left", title: t('basicData.Number'), width: 50},
{
field: 'sort',
- width: 70,
+ width: 90,
editRender: {name: 'input', attrs: {placeholder: ''}},
+ sortable: true,
title: t('processCard.sorting'),
},
{
@@ -270,7 +271,7 @@
title: t('craft.process'),
filters: [{data: ''}],
slots: {filter: 'num1_filter'},
- filterMethod: filterChanged,width: 120
+ filterMethod: filterChanged
},
],
diff --git a/north-glass-erp/northglass-erp/src/components/pp/SelectSortTable.vue b/north-glass-erp/northglass-erp/src/components/pp/SelectSortTable.vue
index c847668..4a846c0 100644
--- a/north-glass-erp/northglass-erp/src/components/pp/SelectSortTable.vue
+++ b/north-glass-erp/northglass-erp/src/components/pp/SelectSortTable.vue
@@ -129,11 +129,10 @@
}
},
columns: [
- {type: 'expand', fixed: "left", slots: {content: 'content'}, width: 50},
- {type: 'seq', fixed: "left", title: t('basicData.Number'), width: 50},
+ {type: 'expand', fixed: "left", slots: {content: 'content'}},
+ {type: 'seq', fixed: "left", title: t('basicData.Number')},
{
field: 'sort',
- width: 70,
title: t('processCard.sorting'),
},
{
@@ -141,35 +140,35 @@
title: t('processCard.processId'),
filters: [{data: ''}],
slots: {filter: 'num1_filter'},
- filterMethod: filterChanged,width: 130
+ filterMethod: filterChanged
},
{
field: 'order_number',
title: t('order.OrderNum'),
filters: [{data: ''}],
slots: {filter: 'num1_filter'},
- filterMethod: filterChanged,width: 100
+ filterMethod: filterChanged
},
{
field: 'technology_number',
title: t('processCard.technologyNumber'),
filters: [{data: ''}],
slots: {filter: 'num1_filter'},
- filterMethod: filterChanged,width: 100
+ filterMethod: filterChanged
},
{
field: 'glassNumber',
title: t('reportingWorks.glassNumber'),
filters: [{data: ''}],
slots: {filter: 'num1_filter'},
- filterMethod: filterChanged,width: 100
+ filterMethod: filterChanged
},
{
field: 'process',
title: t('craft.process'),
filters: [{data: ''}],
slots: {filter: 'num1_filter'},
- filterMethod: filterChanged,width: 120
+ filterMethod: filterChanged
},
],
diff --git a/north-glass-erp/northglass-erp/src/views/pp/Replenish/PrintReplenishFlowCard.vue b/north-glass-erp/northglass-erp/src/views/pp/Replenish/PrintReplenishFlowCard.vue
index 310e8a4..8eee227 100644
--- a/north-glass-erp/northglass-erp/src/views/pp/Replenish/PrintReplenishFlowCard.vue
+++ b/north-glass-erp/northglass-erp/src/views/pp/Replenish/PrintReplenishFlowCard.vue
@@ -775,7 +775,7 @@
destroy-on-close
style="width: 75%;height:75% ">
<template #header="{ close, titleId, titleClass }">
- <el-button v-print="printContent" @click="printNumber" :icon="Printer" circle />
+ <el-button v-print="printContent" :icon="Printer" circle />
</template>
<print-process id="child" :printList="printRow.list" :printMerge="printRow.printMergeVal" :printLike="printRow.like"
style="width: 100%;height: 100%" />
diff --git a/north-glass-erp/northglass-erp/src/views/pp/processCard/AddProcessCard.vue b/north-glass-erp/northglass-erp/src/views/pp/processCard/AddProcessCard.vue
index 3a702f0..82c7891 100644
--- a/north-glass-erp/northglass-erp/src/views/pp/processCard/AddProcessCard.vue
+++ b/north-glass-erp/northglass-erp/src/views/pp/processCard/AddProcessCard.vue
@@ -74,13 +74,14 @@
const orderOtherMoney = ref(null)
-
+let maxProcseeId=null
//绗竴娆″姞杞芥暟鎹�
request.post(`/processCard/selectNoCard/${orderId}/${productionId}`, filterData.value).then((res) => {
if (res.code == 200) {
pageTotal.value = res.data.total
+ maxProcseeId=res.data.maxFlowCard[0].process_id
orderOtherMoney.value = res.data.orderOtherMoney
orderOtherMoney.value.forEach(item => {
let column = {
@@ -354,7 +355,32 @@
index = leftData[0].landingSequence + 1
//index = index.toString().padStart(2, '0')
}
- const processId = productionId + index.toString().padStart(3, '0')
+ let processId= null
+ // if (leftData.length !== 0){
+ // processId = productionId + index.toString().padStart(3, '0')
+ // }
+ // else {
+ if (maxProcseeId!== null || maxProcseeId!== undefined|| maxProcseeId!== ''){
+ if (leftData.length !== 0){
+ const str=leftData[0].processId
+ const lastThree = str.slice(-3);
+ const result = lastThree*1 + 1;
+ processId= productionId + result.toString().padStart(3, '0')
+ }
+ else {
+ // 鎴彇鍚庝笁浣�
+ const lastThree = maxProcseeId.slice(-3);
+ const result = lastThree*1 + 1;
+ processId= productionId + result.toString().padStart(3, '0')
+ }
+
+ }
+ else {
+ processId = productionId + index.toString().padStart(3, '0')
+ }
+ //}
+
+
const regex = /^(\d+|)$/;
if (!regex.test(checkedNum.value)) {
ElMessage.warning(t('processCard.schedulingNo'))
diff --git a/north-glass-erp/northglass-erp/src/views/pp/report/CrossProcessBreaking.vue b/north-glass-erp/northglass-erp/src/views/pp/report/CrossProcessBreaking.vue
index f2d938d..f36a006 100644
--- a/north-glass-erp/northglass-erp/src/views/pp/report/CrossProcessBreaking.vue
+++ b/north-glass-erp/northglass-erp/src/views/pp/report/CrossProcessBreaking.vue
@@ -9,6 +9,8 @@
{type:'expand',fixed:"left",width: 80},
{type: 'seq',fixed:"left", title: '鑷簭', width: 80 },
{field: 'reportingWork.reportingWorkTime', width: 120, title: t('reportingWorks.reportingWorkTime'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true, },
+ {field: 'reportingWork.processId', width: 160,title: t('processCard.processId') ,filters:[{ data: '' }],slots: { filter: 'num1_filter' }},
+ {field: 'code', width: 160,title: t('reportingWorks.glassNumber') ,filters:[{ data: '' }],slots: { filter: 'num1_filter' }},
{field: 'reportingWork.thisProcess',width: 120, title: t('reportingWorks.reportingProcess'), sortable: true,showOverflow:"ellipsis" ,filters:[{ data: '' }],slots: { filter: 'num1_filter' }},
{field: 'responsibleProcess',width: 120, title: t('reportingWorks.responsibleProcess'), sortable: true,showOverflow:"ellipsis" ,filters:[{ data: '' }],slots: { filter: 'num1_filter' }},
{field: 'responsibleTeam', width: 130,title: t('reportingWorks.responsibleTeam'), sortable: true,filters:[{ data: '' }],slots: { filter: 'num1_filter' }},
diff --git a/north-glass-erp/northglass-erp/src/views/pp/report/DamageReport.vue b/north-glass-erp/northglass-erp/src/views/pp/report/DamageReport.vue
index ec973fd..ce16597 100644
--- a/north-glass-erp/northglass-erp/src/views/pp/report/DamageReport.vue
+++ b/north-glass-erp/northglass-erp/src/views/pp/report/DamageReport.vue
@@ -231,6 +231,8 @@
{
field: 'orderNumber', width: 120, title: t('order.OrderNum'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }
},
+ {field: 'glassNumber', width: 160,title: t('reportingWorks.glassNumber') ,filters:[{ data: '' }],slots: { filter: 'num1_filter' }},
+
{
field: 'technologyNumber', width: 100, title: t('processCard.technologyNumber'), filters:[{ data: '' }],slots: { filter: 'num1_filter' }
},
diff --git a/north-glass-erp/src/main/java/com/example/erp/dto/pp/DamageReportDTO.java b/north-glass-erp/src/main/java/com/example/erp/dto/pp/DamageReportDTO.java
index 6195f1e..9de34c0 100644
--- a/north-glass-erp/src/main/java/com/example/erp/dto/pp/DamageReportDTO.java
+++ b/north-glass-erp/src/main/java/com/example/erp/dto/pp/DamageReportDTO.java
@@ -40,5 +40,7 @@
private String personnel;
@ExcelProperty("鍗曠墖鍚嶇О")
private String glassChild;
+ @ExcelProperty("缂栧彿")
+ private String glassNumber;
}
diff --git a/north-glass-erp/src/main/java/com/example/erp/entity/pp/DamageDetails.java b/north-glass-erp/src/main/java/com/example/erp/entity/pp/DamageDetails.java
index 36c508e..a0633e8 100644
--- a/north-glass-erp/src/main/java/com/example/erp/entity/pp/DamageDetails.java
+++ b/north-glass-erp/src/main/java/com/example/erp/entity/pp/DamageDetails.java
@@ -51,6 +51,9 @@
private Integer quantity;
@TableField(select = false,exist = false)
+ private String code;
+
+ @TableField(select = false,exist = false)
private String area;
@TableField(select = false,exist = false)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/pp/FlowCardMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/FlowCardMapper.java
index 6fa55c8..2349e5c 100644
--- a/north-glass-erp/src/main/java/com/example/erp/mapper/pp/FlowCardMapper.java
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/FlowCardMapper.java
@@ -130,7 +130,7 @@
List<Map<String, Object>> getDetailListLikeRefund(String processId, String technologyNumber, Integer orderNumber, String reportingWorkId);
- List<Map<String, Object>> getPrimaryListRework(String processId, String technologyNumber, Integer orderNumber);
+ List<Map<String, Object>> getPrimaryListRework(String processId, String technologyNumber, Integer orderNumber, String reportingWorkId);
List<Map<String, Object>> getDetailListRework(String processId, Integer technologyNumber, Integer orderNumber, String reportingWorkId);
@@ -167,4 +167,6 @@
String countFlowCard(String orderId);
List<Map<String, Object>> remakList(String processId);
+
+ List<Map<String, Object>> selectMaxFlowCard(String orderId, String productionId);
}
diff --git a/north-glass-erp/src/main/java/com/example/erp/service/pp/FlowCardService.java b/north-glass-erp/src/main/java/com/example/erp/service/pp/FlowCardService.java
index d84cbda..b74585e 100644
--- a/north-glass-erp/src/main/java/com/example/erp/service/pp/FlowCardService.java
+++ b/north-glass-erp/src/main/java/com/example/erp/service/pp/FlowCardService.java
@@ -101,6 +101,7 @@
public Map<String, Object> selectNoCardSv(String orderId, String productionId, FlowCard flowCard) {
Map<String, Object> map = new HashMap<>();
map.put("data", flowCardMapper.selectNoCardMp(orderId, productionId, flowCard));
+ map.put("maxFlowCard", flowCardMapper.selectMaxFlowCard(orderId, productionId));
map.put("orderOtherMoney", flowCardMapper.selectorderOtherMoney());
return map;
}
@@ -547,7 +548,7 @@
//娴佺▼鍗¤〃澶磋〃灏炬暟鎹�
//鏄惁浼犲叆鍚堝苟灞傛暟
if (printMerge.equals("")||printMerge.equals("null") ){
- itemmap.put("detail", flowCardMapper.getPrimaryListRework(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getOrderNumber()));
+ itemmap.put("detail", flowCardMapper.getPrimaryListRework(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getOrderNumber(),flowCard.getReportingWorkId()));
List<Map<String, Object>> detailList = flowCardMapper.getDetailListRework(flowCard.getProcessId(), flowCard.getTechnologyNumber(),flowCard.getOrderNumber(),flowCard.getReportingWorkId());
itemmap.put("detailList", detailList);
}
@@ -561,7 +562,7 @@
itemmap.put("detailList", detailList);
}
else {
- itemmap.put("detail", flowCardMapper.getPrimaryListRework(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getOrderNumber()));
+ itemmap.put("detail", flowCardMapper.getPrimaryListRework(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getOrderNumber(), flowCard.getReportingWorkId()));
List<Map<String, Object>> detailList = flowCardMapper.getDetailListLikeRework(flowCard.getProcessId(), printMerge,flowCard.getOrderNumber(),flowCard.getReportingWorkId());
itemmap.put("detailList", detailList);
diff --git a/north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml b/north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml
index 8f23708..6996202 100644
--- a/north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml
+++ b/north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml
@@ -217,7 +217,7 @@
sd.order_glass_detail as ogd left join flow_card as fc
on ogd.order_id = fc.order_id and ogd.order_number = fc.order_number
set ogd.splitting_status=0
- where ogd.order_id = #{orderId}
+ where fc.process_id = #{processId}
</update>
@@ -225,7 +225,7 @@
<update id="deleteFlowCardMp">
delete
from flow_card as fc
- where fc.order_id = left(#{processId}, 10)
+ where fc.process_id = #{processId}
</update>
<!-- 鍒嗘灦鏂板鏄庣粏鏌ヨ-->
@@ -442,7 +442,7 @@
<delete id="deleteReportingWork">
delete
from sd.order_process_detail
- where order_id = left(#{processId}, 10)
+ where process_id = #{processId}
</delete>
<select id="selectPrintFlowCardMp">
@@ -807,8 +807,8 @@
left join sd.order_detail as od on od.order_id = fc.order_id and od.order_number = fc.order_number
where fc.process_id = #{processId}
and position(fc.technology_number in #{technologyNumber})
-
- order by IF(fc.sort != NULL or fc.sort != '', fc.sort, fc.order_number)
+ GROUP BY fc.process_id,fc.order_number,fc.technology_number
+ order by IF(fcs.sort != NULL or fcs.sort != '', fcs.sort, fc.order_number)
</select>
<update id="printSortMp">
@@ -1336,7 +1336,12 @@
round(SUM(ogd.total_area), 2) as gross_area,
sum(od.weight) as weight,
#{technologyNumber} as technologyNumber,
- concat(fc.process_id, '/', #{technologyNumber}) as processIdNumber
+ concat(fc.process_id, '/', #{technologyNumber}) as processIdNumber,
+ dd.breakage_type,
+ dd.breakage_reason,
+ dd.responsible_process,
+ dd.responsible_team,
+ concat('瀵瑰簲鎴戝徃鍗曞彿', o.batch) AS otherRemarks
from flow_card as fc
left join sd.order_glass_detail as ogd
on fc.order_id = ogd.order_id and fc.order_number = ogd.order_number and
@@ -1358,9 +1363,14 @@
ogdc.technology_number = ogd.technology_number
left join rework as pl on pl.process_id = fc.process_id and pl.order_sort = fc.order_number and
pl.technology_number = fc.technology_number
+ left join pp.reporting_work as rw on rw.order_id = fc.order_id and rw.process_id = fc.process_id
+ left join pp.damage_details as dd
+ on rw.reporting_work_id = dd.reporting_work_id and dd.order_number = fc.order_number and
+ dd.technology_number = fc.technology_number
where fc.process_id = #{processId}
and fc.order_number = #{orderNumber}
and fc.technology_number = #{technologyNumber}
+ and rw.reporting_work_id = #{reportingWorkId}
group by fc.process_id, fc.technology_number
</select>
@@ -2051,4 +2061,16 @@
WHERE fc.process_id=#{processId}
GROUP BY fc.order_number
</select>
+
+ <select id="selectMaxFlowCard">
+ select ifnull((select fc.process_id
+ from sd.order_detail as od
+ left join sd.order_glass_detail as ogd
+ on od.order_id = ogd.order_id and od.order_number = ogd.order_number
+ left join flow_card as fc on fc.order_id=od.order_id and fc.order_number=od.order_number and fc.technology_number=ogd.technology_number
+ where od.order_id = #{orderId}
+ and ogd.production_id = #{productionId}
+ GROUP BY od.order_number
+ order by fc.process_id desc LIMIT 1),'') as process_id
+ </select>
</mapper>
\ No newline at end of file
diff --git a/north-glass-erp/src/main/resources/mapper/pp/Report.xml b/north-glass-erp/src/main/resources/mapper/pp/Report.xml
index eaf2a1a..db4e6a8 100644
--- a/north-glass-erp/src/main/resources/mapper/pp/Report.xml
+++ b/north-glass-erp/src/main/resources/mapper/pp/Report.xml
@@ -63,6 +63,8 @@
<result column="project" property="order.project"/>
<result column="order_id" property="order.orderId"/>
<result column="glass_child" property="orderGlassDetail.glassChild"/>
+ <result column="process_id" property="reportingWork.processId"/>
+ <result column="code" property="code"/>
</resultMap>
@@ -101,6 +103,7 @@
<result column="breakage_reason" property="breakageReason"/>
<result column="personnel" property="personnel"/>
<result column="glass_child" property="glassChild"/>
+ <result column="glassNumber" property="glassNumber"/>
</resultMap>
<resultMap id="teamOutputMap" type="com.example.erp.dto.pp.TeamOutputDTO">
@@ -219,15 +222,15 @@
o.project,
o.order_id,
ogd.glass_child,
- rw.this_process
- from damage_details as dd
- left join reporting_work as rw
- on rw.reporting_work_id = dd.reporting_work_id
- left join sd.order as o
- on rw.order_id = o.order_id
- left join sd.order_glass_detail as ogd
- on ogd.order_id = o.order_id and ogd.order_number = dd.order_number
- and ogd.technology_number and dd.technology_number
+ rw.this_process,
+ JSON_UNQUOTE( JSON_EXTRACT( od.other_columns, '$.S01' )) AS code,
+ CONCAT(rw.process_id,'/',GROUP_CONCAT(distinct dd.technology_number SEPARATOR '')) as process_id
+ from
+ sd.`order` as o left join sd.order_detail as od on o.order_id=od.order_id
+ left join sd.order_glass_detail as ogd on ogd.order_id=od.order_id and ogd.order_number=od.order_number
+ left join reporting_work as rw on rw.order_id=o.order_id
+ left join damage_details as dd on dd.reporting_work_id=rw.reporting_work_id and dd.order_number=ogd.order_number
+ and dd.technology_number=ogd.technology_number
where date(rw.reporting_work_time) >= #{startDate}
and date(rw.reporting_work_time) <= #{endDate}
and rw.this_worn_quantity > 0
@@ -482,7 +485,8 @@
dd.breakage_quantity,
round( ogd.child_width * ogd.child_height * dd.breakage_quantity / 1000000, 2 ) as area,
IFNULL(dd.responsible_personnel,'') as personnel,
- ogd.glass_child
+ ogd.glass_child,
+ JSON_UNQUOTE( JSON_EXTRACT( od.other_columns, '$.S01' )) AS glassNumber
FROM
sd.ORDER AS o
LEFT JOIN sd.order_glass_detail AS ogd ON ogd.order_id = o.order_id
@@ -490,6 +494,7 @@
LEFT JOIN damage_details AS dd ON dd.reporting_work_id = rw.reporting_work_id
AND dd.order_number = ogd.order_number
AND dd.technology_number = ogd.technology_number
+ left join sd.order_detail as od on o.order_id = od.order_id and od.order_number=ogd.order_number
WHERE
rw.reporting_work_time between #{selectTime1} and #{selectTime2}
AND dd.available = 0
--
Gitblit v1.8.0