From 1cc0d7fbe0a61617de913b30f557de205c1a6f88 Mon Sep 17 00:00:00 2001
From: loulijun2021 <1694218219@qq.com>
Date: 星期五, 15 十二月 2023 15:44:31 +0800
Subject: [PATCH] 1.设备点检、保养 导入
---
src/views/systemSetting/dataImport.vue | 390 ++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 380 insertions(+), 10 deletions(-)
diff --git a/src/views/systemSetting/dataImport.vue b/src/views/systemSetting/dataImport.vue
index e094185..3285bcb 100644
--- a/src/views/systemSetting/dataImport.vue
+++ b/src/views/systemSetting/dataImport.vue
@@ -139,7 +139,12 @@
item.indexOf('椤瑰簭鍙�')!==-1||
item.indexOf('椤硅姹�')!==-1||
- item.indexOf('璁￠噺鍗曚綅/缁勫悕绉�')!==-1
+ item.indexOf('璁￠噺鍗曚綅/缁勫悕绉�')!==-1||
+
+ item.indexOf('淇濆吇閮ㄤ綅瑕佹眰')!==-1||
+ item.indexOf('淇濆吇椤圭洰瑕佹眰')!==-1||
+ item.indexOf('鐐规閮ㄤ綅瑕佹眰')!==-1||
+ item.indexOf('鐐规椤圭洰瑕佹眰')!==-1
"
>
<el-input v-model="row[item]" placeholder="璇疯緭鍏�" />
@@ -194,7 +199,10 @@
</div>
<div
v-else-if="
- item.indexOf('搴撲綅绠＄悊')!==-1||
+ item.indexOf('鐐规绠℃帶')!==-1||
+ item.indexOf('閫夋嫨鎵爜')!==-1||
+ item.indexOf('鏄惁鎵爜')!==-1||
+ item.indexOf('搴撲綅绠＄悊')!==-1||
item.indexOf('鏄惁澶栬喘')!==-1||
item.indexOf('鏄惁閿�鍞�')!==-1||
item.indexOf('鏄惁鑷埗')!==-1||
@@ -211,6 +219,24 @@
>
<el-option
v-for="item in isYesOrNo"
+ :key="item.code"
+ :label="item.name"
+ :value="item.code"
+ />
+ </el-select>
+ </div>
+ <div
+ v-else-if="item.indexOf('鐐规鍛ㄦ湡')!==-1||
+ item.indexOf('淇濆吇鍛ㄦ湡')!==-1"
+ >
+ <el-select
+ v-model="row[item]"
+ style="width: 100%;"
+ placeholder="璇烽�夋嫨"
+ >
+
+ <el-option
+ v-for="item in cycleArr"
:key="item.code"
:label="item.name"
:value="item.code"
@@ -346,13 +372,13 @@
label="搴忓彿"
/>
<el-table-column
- prop="errorField"
+ prop="ErrorField"
label="閿欒瀛楁"
width="160"
show-overflow-tooltip
/>
<el-table-column
- prop="errorCont"
+ prop="ErrorCont"
show-overflow-tooltip
label="閿欒鍘熷洜"
/>
@@ -426,6 +452,14 @@
meterMethodArr: [
{ code: 'S', name: '鍗曡閲�' },
{ code: 'M', name: '澶氳閲�' }
+ ],
+
+ cycleArr: [
+ { code: '骞�', name: '骞�' },
+ { code: '瀛�', name: '瀛�' },
+ { code: '鏈�', name: '鏈�' },
+ { code: '鍛�', name: '鍛�' },
+ { code: '鏃�', name: '鏃�' }
],
activeName: '0'// tab閫変腑鍊�
@@ -579,19 +613,61 @@
}
if (this.sheetName.indexOf('妯″叿鐐规鏍囧噯') !== -1) {
- // this.statusArr = [
- // { code: 'Y', name: '姝ｅ父' },
- // { code: 'N', name: '鏁呴殰' }
- // ]
-
this.tableData[0].forEach(j => {
j.uuid = nanoid()
- // j['*鐘舵��'] = j['*鐘舵��'] ? this.statusArr.find(e => e.name === j['*鐘舵��']).code : ''
})
this.tableData[1].forEach(j => {
j.uuid = nanoid()
})
}
+
+ if (this.sheetName.indexOf('璁惧鐐规椤圭洰') !== -1) {
+ this.isYesOrNo = [
+ { code: '鏄�', name: '鏄�' },
+ { code: '鍚�', name: '鍚�' }
+ ]
+ this.tableData[0].forEach(j => {
+ j.uuid = nanoid()
+ j['*鐐规鍛ㄦ湡'] = j['*鐐规鍛ㄦ湡'] ? this.cycleArr.find(e => e.name === j['*鐐规鍛ㄦ湡']).code : ''
+ j['*鏄惁鎵爜'] = j['*鏄惁鎵爜'] ? this.isYesOrNo.find(e => e.name === j['*鏄惁鎵爜']).code : ''
+ })
+ }
+
+ if (this.sheetName.indexOf('璁惧鐐规鏍囧噯') !== -1) {
+ this.isYesOrNo = [
+ { code: 'Y', name: 'Y' },
+ { code: 'N', name: 'N' }
+ ]
+ this.cycleArr = [
+ { code: '鏃�', name: '鏃�' }
+ ]
+
+ this.tableData[0].forEach(j => {
+ j.uuid = nanoid()
+ })
+ this.tableData[1].forEach(j => {
+ j.uuid = nanoid()
+ })
+ }
+
+ if (this.sheetName.indexOf('璁惧淇濆吇椤圭洰') !== -1) {
+ this.isYesOrNo = [
+ { code: 'Y', name: 'Y' },
+ { code: 'N', name: 'N' }
+ ]
+ this.cycleArr = [
+ { code: '骞�', name: '骞�' },
+ { code: '瀛�', name: '瀛�' },
+ { code: '鏈�', name: '鏈�' },
+ { code: '鍛�', name: '鍛�' }
+ ]
+ this.tableData[0].forEach(j => {
+ j.uuid = nanoid()
+ j['*鏄惁鎵爜'] = j['*鏄惁鎵爜'] ? this.isYesOrNo.find(e => e.name === j['*鏄惁鎵爜']).code : ''
+ })
+ }
+
+ //
},
// 鎻愪氦
submit() {
@@ -701,6 +777,34 @@
if (this.sheetName.indexOf('妯″叿淇濆吇鏍囧噯') !== -1) {
const res = this.handleMouldMaintainStandSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+
+ if (this.sheetName.indexOf('璁惧鐐规椤圭洰') !== -1) {
+ const res = this.handleCheckPositionSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+
+ if (this.sheetName.indexOf('璁惧鐐规鏍囧噯') !== -1) {
+ const res = this.handleCheckStandardSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+
+ if (this.sheetName.indexOf('璁惧淇濆吇椤圭洰') !== -1) {
+ const res = this.handleMaintainPositionSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+
+ if (this.sheetName.indexOf('璁惧淇濆吇鏍囧噯') !== -1) {
+ const res = this.handleMaintainStandardSubmitData()
if (res.code !== '200') {
return this.$message.info(res.message)
}
@@ -1472,6 +1576,202 @@
return { code: '200', message: '鎴愬姛锛�' }
},
+ // 澶勭悊璁惧鐐规椤圭洰鎻愪氦鏁版嵁
+ handleCheckPositionSubmitData() {
+ let flag = true
+ let msg = ''
+ if ([...new Set(this.tableData[0].map(i => i['*鐐规椤圭洰缂栧彿(鍞竴)']))].length !== this.tableData[0].length) {
+ return this.$message.info('缂栫爜涓嶈兘閲嶅锛�')
+ }
+ this.tableData[0].forEach(j => {
+ if (!j['*鐐规椤圭洰缂栧彿(鍞竴)']) {
+ flag = false
+ msg = '*鐐规椤圭洰缂栧彿(鍞竴)'
+ }
+ if (!j['*鐐规椤圭洰鍚嶇О']) {
+ flag = false
+ msg = '*鐐规椤圭洰鍚嶇О'
+ }
+ if (!j['*鐐规鍛ㄦ湡']) {
+ flag = false
+ msg = '*鐐规鍛ㄦ湡'
+ }
+ if (!j['*鏄惁鎵爜']) {
+ flag = false
+ msg = '*鏄惁鎵爜'
+ }
+ })
+
+ if (!flag) {
+ return { code: '301', message: msg + '涓嶈兘涓虹┖锛�' }
+ }
+
+ this.tableData[0].map(item => {
+ delete (item.uuid)
+ })
+
+ return { code: '200', message: '鎴愬姛锛�' }
+ },
+ // 澶勭悊璁惧鐐规鏍囧噯鎻愪氦鏁版嵁
+ handleCheckStandardSubmitData() {
+ let flag = true
+ let msg = ''
+ if ([...new Set(this.tableData[0].map(i => i['*璁惧鐐规鏍囧噯缂栧彿(鍞竴)']))].length !== this.tableData[0].length) {
+ return this.$message.info('璁惧鐐规鏍囧噯缂栧彿涓嶈兘閲嶅锛�')
+ }
+ // if ([...new Set(this.tableData[1].map(i => i['*妯″叿淇濆吇鏍囧噯缂栧彿']))].length !== this.tableData[1].length) {
+ // return this.$message.info('妯″叿淇濆吇鏍囧噯缂栧彿涓嶈兘閲嶅锛�')
+ // }
+ this.tableData[0].forEach(j => {
+ if (!j['*璁惧鐐规鏍囧噯缂栧彿(鍞竴)']) {
+ flag = false
+ msg = '*璁惧鐐规鏍囧噯缂栧彿(鍞竴)涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*璁惧鐐规鏍囧噯鍚嶇О']) {
+ flag = false
+ msg = '*璁惧鐐规鏍囧噯鍚嶇О涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*鐐规绠℃帶']) {
+ flag = false
+ msg = '*鐐规绠℃帶涓嶈兘涓虹┖锛�'
+ }
+ })
+ this.tableData[1].forEach(j => {
+ if (!j['*鐐规椤瑰簭鍙�']) {
+ flag = false
+ msg = '*鐐规椤瑰簭鍙蜂笉鑳戒负绌猴紒'
+ }
+
+ if (!j['*璁惧鐐规鏍囧噯缂栧彿(M)']) {
+ flag = false
+ msg = '*璁惧鐐规鏍囧噯缂栧彿(M)涓嶈兘涓虹┖锛�'
+ }
+
+ if (!j['*璁惧鐐规閮ㄤ綅缂栧彿(鍞竴)']) {
+ flag = false
+ msg = '*璁惧鐐规閮ㄤ綅缂栧彿(鍞竴)涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*璁惧鐐规閮ㄤ綅鍚嶇О']) {
+ flag = false
+ msg = '*璁惧鐐规閮ㄤ綅鍚嶇О涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*閫夋嫨鎵爜']) {
+ flag = false
+ msg = '*閫夋嫨鎵爜涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*鐐规鍛ㄦ湡']) {
+ flag = false
+ msg = '*鐐规鍛ㄦ湡涓嶈兘涓虹┖锛�'
+ }
+ })
+
+ if (!flag) {
+ return { code: '301', message: msg }
+ }
+
+ this.tableData[0].map(item => {
+ delete (item.uuid)
+ })
+ this.tableData[1].map(item => {
+ delete (item.uuid)
+ })
+
+ return { code: '200', message: '鎴愬姛锛�' }
+ },
+ // 澶勭悊璁惧淇濆吇椤圭洰鎻愪氦鏁版嵁
+ handleMaintainPositionSubmitData() {
+ let flag = true
+ let msg = ''
+ if ([...new Set(this.tableData[0].map(i => i['*淇濆吇椤圭洰缂栧彿(鍞竴)']))].length !== this.tableData[0].length) {
+ return this.$message.info('缂栫爜涓嶈兘閲嶅锛�')
+ }
+ this.tableData[0].forEach(j => {
+ if (!j['*淇濆吇椤圭洰缂栧彿(鍞竴)']) {
+ flag = false
+ msg = '*淇濆吇椤圭洰缂栧彿(鍞竴)'
+ }
+ if (!j['*淇濆吇椤圭洰鍚嶇О']) {
+ flag = false
+ msg = '*淇濆吇椤圭洰鍚嶇О'
+ }
+ if (!j['*鏄惁鎵爜']) {
+ flag = false
+ msg = '*鏄惁鎵爜'
+ }
+ })
+
+ if (!flag) {
+ return { code: '301', message: msg + '涓嶈兘涓虹┖锛�' }
+ }
+
+ this.tableData[0].map(item => {
+ delete (item.uuid)
+ })
+
+ return { code: '200', message: '鎴愬姛锛�' }
+ },
+ // 澶勭悊璁惧淇濆吇鏍囧噯鎻愪氦鏁版嵁
+ handleMaintainStandardSubmitData() {
+ let flag = true
+ let msg = ''
+ if ([...new Set(this.tableData[0].map(i => i['*璁惧淇濆吇鏍囧噯缂栧彿(鍞竴)']))].length !== this.tableData[0].length) {
+ return this.$message.info('璁惧淇濆吇鏍囧噯缂栧彿涓嶈兘閲嶅锛�')
+ }
+ // if ([...new Set(this.tableData[1].map(i => i['*妯″叿淇濆吇鏍囧噯缂栧彿']))].length !== this.tableData[1].length) {
+ // return this.$message.info('妯″叿淇濆吇鏍囧噯缂栧彿涓嶈兘閲嶅锛�')
+ // }
+ this.tableData[0].forEach(j => {
+ if (!j['*璁惧淇濆吇鏍囧噯缂栧彿(鍞竴)']) {
+ flag = false
+ msg = '*璁惧淇濆吇鏍囧噯缂栧彿(鍞竴)涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*璁惧淇濆吇鏍囧噯鍚嶇О']) {
+ flag = false
+ msg = '*璁惧淇濆吇鏍囧噯鍚嶇О涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*淇濆吇鍛ㄦ湡']) {
+ flag = false
+ msg = '*淇濆吇鍛ㄦ湡涓嶈兘涓虹┖锛�'
+ }
+ })
+ this.tableData[1].forEach(j => {
+ if (!j['*淇濆吇椤瑰簭鍙�']) {
+ flag = false
+ msg = '*鐐规椤瑰簭鍙蜂笉鑳戒负绌猴紒'
+ }
+
+ if (!j['*璁惧淇濆吇鏍囧噯缂栧彿(M)']) {
+ flag = false
+ msg = '*璁惧淇濆吇鏍囧噯缂栧彿(M)涓嶈兘涓虹┖锛�'
+ }
+
+ if (!j['*璁惧淇濆吇閮ㄤ綅缂栧彿(鍞竴)']) {
+ flag = false
+ msg = '*璁惧淇濆吇閮ㄤ綅缂栧彿(鍞竴)涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*璁惧淇濆吇閮ㄤ綅鍚嶇О']) {
+ flag = false
+ msg = '*璁惧淇濆吇閮ㄤ綅鍚嶇О涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*閫夋嫨鎵爜']) {
+ flag = false
+ msg = '*閫夋嫨鎵爜涓嶈兘涓虹┖锛�'
+ }
+ })
+
+ if (!flag) {
+ return { code: '301', message: msg }
+ }
+
+ this.tableData[0].map(item => {
+ delete (item.uuid)
+ })
+ this.tableData[1].map(item => {
+ delete (item.uuid)
+ })
+
+ return { code: '200', message: '鎴愬姛锛�' }
+ },
// parents:鐢ㄤ簬杩斿洖鐨勬暟缁勶紝childNode:瑕佹煡璇㈢殑鑺傜偣锛宼reeData锛歫son鏍戝舰鏁版嵁
findParent(parents, childNode, treeData) {
@@ -1730,6 +2030,76 @@
'淇濆吇椤硅姹�': ''
})
}
+
+ // 璁惧鐐规椤圭洰
+ if (this.sheetName.indexOf('璁惧鐐规椤圭洰') !== -1) {
+ this.tableData[0].unshift({
+ uuid: nanoid(),
+ '*鐐规椤圭洰缂栧彿(鍞竴)': '',
+ '*鐐规椤圭洰鍚嶇О': '',
+ '*鐐规鍛ㄦ湡': '',
+ '*鏄惁鎵爜': '',
+ '鐐规椤圭洰瑕佹眰': ''
+ })
+ }
+
+ // 璁惧鐐规鏍囧噯
+ if (this.sheetName.indexOf('璁惧鐐规鏍囧噯') !== -1 && this.activeName === '0') {
+ this.tableData[0].unshift({
+ uuid: nanoid(),
+ '*璁惧鐐规鏍囧噯缂栧彿(鍞竴)': '',
+ '*璁惧鐐规鏍囧噯鍚嶇О': '',
+ '*鐐规绠℃帶': '',
+ '鏍囧噯鎻忚堪': ''
+ })
+ }
+ if (this.sheetName.indexOf('璁惧鐐规閮ㄤ綅') !== -1 && this.activeName === '1') {
+ this.tableData[1].unshift({
+ uuid: nanoid(),
+ '*璁惧鐐规鏍囧噯缂栧彿(M)': '',
+ '*鐐规椤瑰簭鍙�': '',
+ '*璁惧鐐规閮ㄤ綅缂栧彿(鍞竴)': '',
+ '*璁惧鐐规閮ㄤ綅鍚嶇О': '',
+ '鐐规閮ㄤ綅瑕佹眰': '',
+ '*閫夋嫨鎵爜': '',
+ '*鐐规鍛ㄦ湡': ''
+ })
+ }
+
+ // 璁惧鐐规椤圭洰
+ if (this.sheetName.indexOf('璁惧淇濆吇椤圭洰') !== -1) {
+ this.tableData[0].unshift({
+ uuid: nanoid(),
+ '*淇濆吇椤圭洰缂栧彿(鍞竴)': '',
+ '*淇濆吇椤圭洰鍚嶇О': '',
+ '*鏄惁鎵爜': '',
+ '淇濆吇椤圭洰瑕佹眰': ''
+ })
+ }
+
+ // 璁惧淇濆吇鏍囧噯
+ if (this.sheetName.indexOf('璁惧淇濆吇鏍囧噯') !== -1 && this.activeName === '0') {
+ this.tableData[0].unshift({
+ uuid: nanoid(),
+ '*璁惧淇濆吇鏍囧噯缂栧彿(鍞竴)': '',
+ '*璁惧淇濆吇鏍囧噯鍚嶇О': '',
+ '*淇濆吇鍛ㄦ湡': '',
+ '鏍囧噯鎻忚堪': ''
+ })
+ }
+ if (this.sheetName.indexOf('璁惧淇濆吇閮ㄤ綅') !== -1 && this.activeName === '1') {
+ this.tableData[1].unshift({
+ uuid: nanoid(),
+ '*淇濆吇椤瑰簭鍙�': '',
+ '*璁惧淇濆吇鏍囧噯缂栧彿(M)': '',
+ '*璁惧淇濆吇閮ㄤ綅缂栧彿(鍞竴)': '',
+ '*璁惧淇濆吇閮ㄤ綅鍚嶇О': '',
+ '淇濆吇閮ㄤ綅瑕佹眰': '',
+ '*閫夋嫨鎵爜': ''
+ })
+ }
+
+ //
},
delRow(row) {
// 閽堝鍗晄heet
--
Gitblit v1.9.3