From 2aa25263601a88190319093b59e3a2f4dde01583 Mon Sep 17 00:00:00 2001
From: loulijun2021 <1694218219@qq.com>
Date: 星期一, 18 九月 2023 17:25:25 +0800
Subject: [PATCH] 1.正在测试库位管理、存货档案 ing...
---
src/views/systemSetting/dataImport.vue | 378 ++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 367 insertions(+), 11 deletions(-)
diff --git a/src/views/systemSetting/dataImport.vue b/src/views/systemSetting/dataImport.vue
index 070c0d2..fbb67e2 100644
--- a/src/views/systemSetting/dataImport.vue
+++ b/src/views/systemSetting/dataImport.vue
@@ -70,13 +70,12 @@
style="margin: 10px"
>
- <el-tabs type="border-card">
+ <el-tabs v-model="activeName" type="border-card">
<el-tab-pane
v-for="(i,j) in sheetName"
:key="i+j"
:label="i"
>
-
<el-table
v-if="tableData[j].length>0"
:ref="'tableDataRef'+i"
@@ -120,7 +119,18 @@
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||
+ item.indexOf('瀛樿揣鍒嗙被缂栫爜')!==-1||
+ item.indexOf('璁￠噺鏂瑰紡')!==-1||
+ item.indexOf('璁￠噺鍗曚綅/缁勫悕绉�')!==-1
"
>
<el-input v-model="row[item]" placeholder="璇疯緭鍏�" />
@@ -135,6 +145,31 @@
>
<el-option
v-for="item in statusArr"
+ :key="item.code"
+ :label="item.name"
+ :value="item.code"
+ />
+ </el-select>
+ </div>
+ <div
+ v-else-if="
+ item.indexOf('搴撲綅绠＄悊')!==-1||
+ item.indexOf('鏄惁澶栬喘')!==-1||
+ item.indexOf('鏄惁閿�鍞�')!==-1||
+ item.indexOf('鏄惁鑷埗')!==-1||
+ item.indexOf('鏄惁鐢熶骇娑堣��')!==-1||
+ item.indexOf('鏄惁濮斿')!==-1
+ "
+ >
+ <el-select
+ v-model="row[item]"
+ placeholder="璇烽�夋嫨"
+ filterable
+ style="width:100%"
+ clearable
+ >
+ <el-option
+ v-for="item in isYesOrNo"
:key="item.code"
:label="item.name"
:value="item.code"
@@ -272,7 +307,7 @@
<el-table-column
prop="errorField"
label="閿欒瀛楁"
-
+ width="160"
show-overflow-tooltip
/>
<el-table-column
@@ -318,6 +353,10 @@
excelArr: [],
statusArr: [],
+ isYesOrNo: [
+ { code: '1', name: '鏄�' },
+ { code: '0', name: '鍚�' }
+ ],
orgArr: [], // 缁勭粐
orgOptions: [],
defaultProps: {
@@ -337,7 +376,9 @@
groupArr: [], // 鐝粍
dialogVisible: false,
- dialogTableData: []
+ dialogTableData: [],
+
+ activeName: '0'// tab閫変腑鍊�
}
},
@@ -378,15 +419,16 @@
this.tableHeader = header
this.sheetName = sheetName
- console.log(this.tableData)
- console.log(this.tableHeader)
+ this.activeName = '0'
// 浜哄憳绠＄悊瀵煎叆鍒ゆ柇
if (this.sheetName.indexOf('浜哄憳绠＄悊') !== -1) {
this.handlePersonListUploadTemplate(true)
}
- if (this.sheetName.indexOf('瑙掕壊绠＄悊') !== -1 || this.sheetName.indexOf('鐝粍绠＄悊') !== -1) {
+ if (this.sheetName.indexOf('瑙掕壊绠＄悊') !== -1 || this.sheetName.indexOf('鐝粍绠＄悊') !== -1 ||
+ this.sheetName.indexOf('宀椾綅绠＄悊') !== -1
+ ) {
this.statusArr = [
{ code: 'Y', name: '姝ｅ父' },
{ code: 'N', name: '鍋滅敤' }
@@ -396,6 +438,36 @@
j.uuid = nanoid()
})
}
+
+ if (this.sheetName.indexOf('寰�鏉ュ崟浣�') !== -1) {
+ this.statusArr = [
+ { code: 'Y', name: '姝ｅ父' },
+ { code: 'N', name: '鍋滅敤' }
+ ]
+ this.tableData[0].forEach(j => {
+ j.uuid = nanoid()
+ })
+ this.tableData[1].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: '姝ｅ父' },
+ { code: '1', name: '鍋滅敤' }
+ ]
+ this.tableData[0].forEach(j => {
+ j['*鐘舵��'] = j['*鐘舵��'] ? this.statusArr.find(e => e.name === j['*鐘舵��']).code : ''
+ j['*搴撲綅绠＄悊'] = j['*搴撲綅绠＄悊'] ? this.isYesOrNo.find(e => e.name === j['*搴撲綅绠＄悊']).code : ''
+ j.uuid = nanoid()
+ })
+ }
+
+ // console.log(this.sheetName)
+ // console.log(this.tableData)
+ // console.log(this.tableHeader)
},
// 鎻愪氦
submit() {
@@ -420,6 +492,32 @@
}
if (this.sheetName.indexOf('鐝粍绠＄悊') !== -1) {
const res = this.handleGroupListSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+ if (this.sheetName.indexOf('宀椾綅绠＄悊') !== -1) {
+ const res = this.handlePostListSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+ if (this.sheetName.indexOf('寰�鏉ュ崟浣嶇被鍨�') !== -1 && this.sheetName.indexOf('寰�鏉ュ崟浣�') !== -1) {
+ const res = this.handleContactUnitListSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+
+ if (this.sheetName.indexOf('浠撳簱璁剧疆') !== -1) {
+ const res = this.handleWarehouseListSubmitData()
+ if (res.code !== '200') {
+ return this.$message.info(res.message)
+ }
+ }
+
+ if (this.sheetName.indexOf('搴撲綅璁剧疆') !== -1) {
+ const res = this.handleStorageListSubmitData()
if (res.code !== '200') {
return this.$message.info(res.message)
}
@@ -618,6 +716,174 @@
return { code: '200', message: '鎴愬姛锛�' }
},
+ // 澶勭悊宀椾綅绠＄悊鎻愪氦鏁版嵁
+ handlePostListSubmitData() {
+ 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: '鎴愬姛锛�' }
+ },
+ // 澶勭悊寰�鏉ュ崟浣嶆彁浜ゆ暟鎹�
+ handleContactUnitListSubmitData() {
+ 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['*寰�鏉ュ崟浣嶇被鍨嬬紪鍙�(鍞竴)'] === 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: '鎴愬姛锛�' }
+ },
+ // 澶勭悊浠撳簱璁剧疆鎻愪氦鏁版嵁
+ handleWarehouseListSubmitData() {
+ 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: '鎴愬姛锛�' }
+ },
+ // 澶勭悊搴撲綅璁剧疆鎻愪氦鏁版嵁
+ handleStorageListSubmitData() {
+ 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 (j['涓婄骇搴撲綅缂栫爜'] === j['*搴撲綅缂栧彿(鍞竴)']) {
+ flag = false
+ msg = '*搴撲綅缂栧彿(鍞竴)涓庝笂绾у簱浣嶇紪鐮佷笉鑳界浉鍚岋紒'
+ }
+ })
+
+ if (!flag) {
+ return { code: '301', message: msg }
+ }
+
+ this.tableData[0].map(item => {
+ delete (item.uuid)
+ })
+
+ return { code: '200', message: '鎴愬姛锛�' }
+ },
+ // 澶勭悊瀛樿揣妗ｆ鎻愪氦鏁版嵁
+ handleInventoryListSubmitData() {
+
+ },
// 鑾峰彇妯℃澘
async getExcelModelData() {
@@ -633,7 +899,6 @@
const res = await DownLoadExcel({ FileCode: this.excelCode })
window.location.href = res.data
},
-
handleClose() {
this.dialogTableData = []
},
@@ -695,6 +960,82 @@
'鎻忚堪': ''
})
}
+ // 宀椾綅绠＄悊鏂板琛�
+ if (this.sheetName.indexOf('宀椾綅绠＄悊') !== -1) {
+ this.tableData[0].unshift({
+ uuid: nanoid(),
+ '*宀椾綅缂栧彿(鍞竴)': '',
+ '*宀椾綅鍚嶇О': '',
+ '*鐘舵��': 'Y',
+ '鎻忚堪': ''
+ })
+ }
+ // 寰�鏉ュ崟浣�
+ 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(),
+ '*寰�鏉ュ崟浣嶇紪鍙�(鍞竴)': '',
+ '*寰�鏉ュ崟浣嶅悕绉�': '',
+ '*鐘舵��': 'Y',
+ '*寰�鏉ュ崟浣嶇被鍨嬬紪鐮�': '',
+ '鑱旂郴浜�': '',
+ '鑱旂郴鏂瑰紡': '',
+ '鍦板潃': ''
+ })
+ }
+ // 浠撳簱璁剧疆
+ if (this.sheetName.indexOf('浠撳簱璁剧疆') !== -1) {
+ this.tableData[0].unshift({
+ uuid: nanoid(),
+ '*浠撳簱缂栧彿(鍞竴)': '',
+ '*浠撳簱鍚嶇О': '',
+ '*鐘舵��': '0',
+ '*搴撲綅绠＄悊': '0',
+ '鎻忚堪': ''
+ })
+ }
+ // 搴撲綅璁剧疆
+ if (this.sheetName.indexOf('搴撲綅璁剧疆') !== -1) {
+ this.tableData[0].unshift({
+ uuid: nanoid(),
+ '*搴撲綅缂栧彿(鍞竴)': '',
+ '*搴撲綅鍚嶇О': '',
+ '*鎵�灞炰粨搴撶紪鐮�': '',
+ '涓婄骇搴撲綅缂栫爜': '',
+ '*鐘舵��': '0',
+ '鎻忚堪': ''
+ })
+ }
+
+ // 瀛樿揣妗ｆ
+ 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(),
+ '*寰�鏉ュ崟浣嶇紪鍙�(鍞竴)': '',
+ '*寰�鏉ュ崟浣嶅悕绉�': '',
+ '*鐘舵��': 'Y',
+ '*寰�鏉ュ崟浣嶇被鍨嬬紪鐮�': '',
+ '鑱旂郴浜�': '',
+ '鑱旂郴鏂瑰紡': '',
+ '鍦板潃': ''
+ })
+ }
},
delRow(row) {
// 閽堝鍗晄heet
@@ -705,9 +1046,24 @@
return this.$message.info('蹇呴』瑕佹湁涓�鏉℃暟鎹紒')
}
}
- // 閽堝澶歴heet
+ // 閽堝涓や釜 sheet
+ if (this.sheetName.length === 2) {
+ if (this.activeName === '0') {
+ if (this.tableData[0].length > 1) {
+ return this.tableData[0].splice(this.tableData[0].findIndex(i => i.uuid === row.uuid), 1)
+ } else {
+ return this.$message.info('蹇呴』瑕佹湁涓�鏉℃暟鎹紒')
+ }
+ }
+ if (this.activeName === '1') {
+ if (this.tableData[1].length > 1) {
+ return this.tableData[1].splice(this.tableData[1].findIndex(i => i.uuid === row.uuid), 1)
+ } else {
+ return this.$message.info('蹇呴』瑕佹湁涓�鏉℃暟鎹紒')
+ }
+ }
+ }
},
-
reset() {
this.tableData = []
this.tableHeader = []
--
Gitblit v1.9.3