From 844adb3a80b39f9a78dae89a6a27f19e58a931df Mon Sep 17 00:00:00 2001
From: loulijun2021 <1694218219@qq.com>
Date: 星期二, 09 一月 2024 10:34:58 +0800
Subject: [PATCH] 1.图片预览地址配置
---
src/views/systemSetting/dataImport.vue | 689 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 678 insertions(+), 11 deletions(-)
diff --git a/src/views/systemSetting/dataImport.vue b/src/views/systemSetting/dataImport.vue
index 72dc265..c4c8aa5 100644
--- a/src/views/systemSetting/dataImport.vue
+++ b/src/views/systemSetting/dataImport.vue
@@ -12,9 +12,9 @@
>
<el-option
v-for="item in excelArr"
- :key="item.fileCode"
- :label="item.fileName"
- :value="item.fileCode"
+ :key="item.FileCode"
+ :label="item.FileName"
+ :value="item.FileCode"
/>
</el-select>
@@ -135,7 +135,19 @@
item.indexOf('妯″叿缂栫爜')!==-1||
item.indexOf('浜у搧缂栫爜')!==-1||
- item.indexOf('璁￠噺鍗曚綅/缁勫悕绉�')!==-1
+ item.indexOf('鏍囧噯缂栧彿')!==-1||
+ item.indexOf('椤瑰簭鍙�')!==-1||
+ 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="璇疯緭鍏�" />
@@ -190,7 +202,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||
@@ -207,6 +222,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"
@@ -316,7 +349,7 @@
v-el-drag-dialog
title="澶辫触鍘熷洜"
:visible.sync="dialogVisible"
- width="1000px"
+ width="1300px"
:close-on-click-modal="false"
top="15vh"
@closed="handleClose"
@@ -342,13 +375,13 @@
label="搴忓彿"
/>
<el-table-column
- prop="errorField"
+ prop="ErrorField"
label="閿欒瀛楁"
- width="160"
+ width="200"
show-overflow-tooltip
/>
<el-table-column
- prop="errorCont"
+ prop="ErrorCont"
show-overflow-tooltip
label="閿欒鍘熷洜"
/>
@@ -422,6 +455,14 @@
meterMethodArr: [
{ code: 'S', name: '鍗曡閲�' },
{ code: 'M', name: '澶氳閲�' }
+ ],
+
+ cycleArr: [
+ { code: '骞�', name: '骞�' },
+ { code: '瀛�', name: '瀛�' },
+ { code: '鏈�', name: '鏈�' },
+ { code: '鍛�', name: '鍛�' },
+ { code: '鏃�', name: '鏃�' }
],
activeName: '0'// tab閫変腑鍊�
@@ -511,6 +552,17 @@
})
}
+ if (this.sheetName.indexOf('搴撲綅璁剧疆') !== -1) {
+ this.statusArr = [
+ { code: '0', name: '姝ｅ父' },
+ { code: '1', name: '鍋滅敤' }
+ ]
+ this.tableData[0].forEach(j => {
+ j['*鐘舵��'] = j['*鐘舵��'] ? this.statusArr.find(e => e.name === j['*鐘舵��']).code : ''
+ j.uuid = nanoid()
+ })
+ }
+
if (this.sheetName.indexOf('瀛樿揣鍒嗙被') !== -1) {
this.statusArr = [
{ code: '0', name: '姝ｅ父' },
@@ -573,6 +625,82 @@
j.uuid = nanoid()
})
}
+
+ if (this.sheetName.indexOf('妯″叿鐐规鏍囧噯') !== -1) {
+ this.tableData[0].forEach(j => {
+ j.uuid = nanoid()
+ })
+ 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 : ''
+ })
+ }
+
+ 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()
+ })
+ this.tableData[1].forEach(j => {
+ j.uuid = nanoid()
+ })
+ }
+
+ //
},
// 鎻愪氦
submit() {
@@ -665,6 +793,58 @@
return this.$message.info(res.message)
}
}
+
+ if (this.sheetName.indexOf('妯″叿鐐规鏍囧噯') !== -1) {
+ const res = this.handleMouldCheckStandSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+
+ if (this.sheetName.indexOf('妯″叿淇濆吇椤圭洰') !== -1) {
+ const res = this.handleMouldMaintainSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+
+ 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)
+ }
+ }
+
+ // 鏁版嵁鎻愪氦鍓嶅幓闄ょ┖鏍兼柟娉�
+ // this.tableDataTrim()
const data = {
fileCode: this.excelCode,
@@ -1243,6 +1423,18 @@
flag = false
msg = '*妯″叿鍚嶇О涓嶈兘涓虹┖锛�'
}
+ if (!j['*鐘舵��']) {
+ flag = false
+ msg = '*鐘舵�佷笉鑳戒负绌猴紒'
+ }
+ if (!j['*浠撳簱缂栫爜']) {
+ flag = false
+ msg = '*浠撳簱缂栫爜涓嶈兘涓虹┖锛�'
+ }
+ if (!j['*搴撲綅缂栫爜']) {
+ flag = false
+ msg = '*搴撲綅缂栫爜涓嶈兘涓虹┖锛�'
+ }
})
this.tableData[1].forEach(j => {
if (!j['妯″叿缂栫爜'] && j['浜у搧缂栫爜']) {
@@ -1291,6 +1483,334 @@
}
this.tableData[0].map(item => {
+ delete (item.uuid)
+ })
+
+ return { code: '200', message: '鎴愬姛锛�' }
+ },
+ // 澶勭悊妯″叿鐐规鏍囧噯鎻愪氦鏁版嵁
+ handleMouldCheckStandSubmitData() {
+ 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 = '*妯″叿鐐规鏍囧噯涓嶈兘涓虹┖锛�'
+ }
+ })
+ this.tableData[1].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)
+ })
+ this.tableData[1].map(item => {
+ delete (item.uuid)
+ })
+
+ return { code: '200', message: '鎴愬姛锛�' }
+ },
+ // 澶勭悊妯″叿淇濆吇椤圭洰鎻愪氦鏁版嵁
+ handleMouldMaintainSubmitData() {
+ 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 (!flag) {
+ return { code: '301', message: msg + '涓嶈兘涓虹┖锛�' }
+ }
+
+ this.tableData[0].map(item => {
+ delete (item.uuid)
+ })
+
+ return { code: '200', message: '鎴愬姛锛�' }
+ },
+ // 澶勭悊妯″叿淇濆吇鏍囧噯鎻愪氦鏁版嵁
+ handleMouldMaintainStandSubmitData() {
+ 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 = '*妯″叿淇濆吇鏍囧噯涓嶈兘涓虹┖锛�'
+ }
+ })
+ this.tableData[1].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)
+ })
+ this.tableData[1].map(item => {
+ delete (item.uuid)
+ })
+
+ 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)
})
@@ -1484,8 +2004,10 @@
'瑙勬牸鍨嬪彿': '',
'*鐘舵��': 'Y',
'*浠撳簱缂栫爜': '',
+ '*搴撲綅缂栫爜': '',
'棰勮瀵垮懡(娆�)': '',
'鍓╀綑瀵垮懡(娆�)': ''
+
})
}
if (this.sheetName.indexOf('妯″叿鍏宠仈浜у搧') !== -1 && this.activeName === '1') {
@@ -1505,6 +2027,126 @@
'瑕佹眰鎻忚堪': ''
})
}
+
+ // 妯″叿鐐规鏍囧噯
+ 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(),
+ '*妯″叿鐐规鏍囧噯缂栧彿': '',
+ '*鐐规椤瑰簭鍙�': '',
+ '*妯″叿鐐规椤圭紪鍙�(鍞竴)': '',
+ '*妯″叿鐐规椤瑰悕绉�': '',
+ '鐐规椤硅姹�': ''
+ })
+ }
+
+ // 妯″叿淇濆吇椤�
+ 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(),
+ '*妯″叿淇濆吇鏍囧噯缂栧彿': '',
+ '*淇濆吇椤瑰簭鍙�': '',
+ '*妯″叿淇濆吇椤圭紪鍙�(鍞竴)': '',
+ '*妯″叿淇濆吇椤瑰悕绉�': '',
+ '淇濆吇椤硅姹�': ''
+ })
+ }
+
+ // 璁惧鐐规椤圭洰
+ 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
@@ -1554,7 +2196,9 @@
// 妯℃澘涓嬭浇
async getExcel() {
const res = await DownLoadExcel({ FileCode: this.excelCode })
- window.location.href = res.data
+ if (res.code === '200') {
+ window.location.href = res.data
+ }
},
async getSelectArr() {
await this.getPrentOrganization()
@@ -1627,6 +2271,29 @@
h('span', { style: 'color:#FFF' }, column.label)
]
}
+ },
+ // 鏁版嵁鎻愪氦鍓嶅幓闄ょ┖鏍兼柟娉�
+ tableDataTrim() {
+ if (this.tableData.length === 1) { // 涓�涓猻heet
+ this.tableData[0].forEach(i => {
+ for (const j in i) {
+ i[j] = i[j].trim()
+ }
+ })
+ }
+
+ if (this.tableData.length === 2) { // 涓や釜sheet
+ this.tableData[0].forEach(i => {
+ for (const j in i) {
+ i[j] = i[j].trim()
+ }
+ })
+ this.tableData[1].forEach(i => {
+ for (const j in i) {
+ i[j] = i[j].trim()
+ }
+ })
+ }
}
}
@@ -1635,7 +2302,7 @@
<style lang="scss">
::v-deep .el-dialog__body {
- padding: 20px 20px !important;
+ padding: 10px 10px !important;
}
</style>
--
Gitblit v1.9.3