From 2f45123bb9911c4dacf08b527482e4f855c988b8 Mon Sep 17 00:00:00 2001
From: loulijun2021 <1694218219@qq.com>
Date: 星期二, 05 十二月 2023 16:07:47 +0800
Subject: [PATCH] 1.大小写修改

---
 src/views/systemSetting/dataImport.vue |  278 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 274 insertions(+), 4 deletions(-)

diff --git a/src/views/systemSetting/dataImport.vue b/src/views/systemSetting/dataImport.vue
index 8e5e0ca..e094185 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>
 
@@ -134,6 +134,10 @@
                     item.indexOf('鍓╀綑瀵垮懡')!==-1||
                     item.indexOf('妯″叿缂栫爜')!==-1||
                     item.indexOf('浜у搧缂栫爜')!==-1||
+
+                    item.indexOf('鏍囧噯缂栧彿')!==-1||
+                    item.indexOf('椤瑰簭鍙�')!==-1||
+                    item.indexOf('椤硅姹�')!==-1||
 
                     item.indexOf('璁￠噺鍗曚綅/缁勫悕绉�')!==-1
                   "
@@ -573,6 +577,21 @@
           j.uuid = nanoid()
         })
       }
+
+      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()
+        })
+      }
     },
     // 鎻愪氦
     submit() {
@@ -654,6 +673,34 @@
 
           if (this.sheetName.indexOf('妯″叿娓呭崟') !== -1 && this.sheetName.indexOf('妯″叿鍏宠仈浜у搧') !== -1) {
             const res = this.handleMouldListSubmitData()
+            if (res.code !== '200') {
+              return this.$message.info(res.message)
+            }
+          }
+
+          if (this.sheetName.indexOf('妯″叿鐐规椤圭洰') !== -1) {
+            const res = this.handleMouldCheckPosSubmitData()
+            if (res.code !== '200') {
+              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)
             }
@@ -1236,6 +1283,10 @@
           flag = false
           msg = '*妯″叿鍚嶇О涓嶈兘涓虹┖锛�'
         }
+        if (!j['*鐘舵��']) {
+          flag = false
+          msg = '*鐘舵�佷笉鑳戒负绌猴紒'
+        }
       })
       this.tableData[1].forEach(j => {
         if (!j['妯″叿缂栫爜'] && j['浜у搧缂栫爜']) {
@@ -1245,6 +1296,166 @@
         if (j['妯″叿缂栫爜'] && !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: '鎴愬姛锛�' }
+    },
+    // 澶勭悊妯″叿鐐规椤圭洰鎻愪氦鏁版嵁
+    handleMouldCheckPosSubmitData() {
+      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: '鎴愬姛锛�' }
+    },
+    // 澶勭悊妯″叿鐐规鏍囧噯鎻愪氦鏁版嵁
+    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 = '*妯″叿淇濆吇椤瑰悕绉颁笉鑳戒负绌猴紒'
         }
       })
 
@@ -1448,7 +1659,6 @@
           '*妯″叿鍚嶇О': '',
           '瑙勬牸鍨嬪彿': '',
           '*鐘舵��': 'Y',
-          '*浠撳簱缂栫爜': '',
           '棰勮瀵垮懡(娆�)': '',
           '鍓╀綑瀵垮懡(娆�)': ''
         })
@@ -1460,6 +1670,66 @@
           '浜у搧缂栫爜': ''
         })
       }
+
+      //  妯″叿鐐规椤�
+      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(),
+          '*妯″叿淇濆吇鏍囧噯缂栧彿': '',
+          '*淇濆吇椤瑰簭鍙�': '',
+          '*妯″叿淇濆吇椤圭紪鍙�(鍞竴)': '',
+          '*妯″叿淇濆吇椤瑰悕绉�': '',
+          '淇濆吇椤硅姹�': ''
+        })
+      }
     },
     delRow(row) {
       // 閽堝鍗晄heet

--
Gitblit v1.9.3