From 04a8571e5a937e987dd0cc658cbc7a710205fa82 Mon Sep 17 00:00:00 2001
From: loulijun2021 <1694218219@qq.com>
Date: 星期二, 07 三月 2023 08:39:19 +0800
Subject: [PATCH] 1. MES工单新增报废补单工单查询

---
 src/views/scgl/gd.vue |  252 +++++++++++++++++++++++++++++---------------------
 src/api/scgl.js       |    8 +
 2 files changed, 153 insertions(+), 107 deletions(-)

diff --git a/src/api/scgl.js b/src/api/scgl.js
index b9f5d23..723508f 100644
--- a/src/api/scgl.js
+++ b/src/api/scgl.js
@@ -384,3 +384,11 @@
     params: data
   })
 }
+// MES鎶ュ簾琛ュ崟宸ュ崟鏌ヨ
+export function MesBadOrderSearch(data) {
+  return request({
+    url: 'ProductionManagement/MesBadOrderSearch',
+    method: 'get',
+    params: data
+  })
+}
diff --git a/src/views/scgl/gd.vue b/src/views/scgl/gd.vue
index c5d07bb..1f94596 100644
--- a/src/views/scgl/gd.vue
+++ b/src/views/scgl/gd.vue
@@ -20,7 +20,7 @@
           style="display: flex;"
         >
           <div class="elForm">
-            <el-form-item label="璁㈠崟鐘舵��" style=" display: flex;">
+            <el-form-item label="宸ュ崟鐘舵��" style=" display: flex;">
               <el-select
                 v-model="form.mesorderstus"
                 :popper-append-to-body="false"
@@ -37,7 +37,7 @@
                 />
               </el-select>
             </el-form-item>
-            <el-form-item label="璁㈠崟缂栧彿" style=" display: flex;">
+            <el-form-item label="宸ュ崟缂栧彿" style=" display: flex;">
               <el-input v-model="form.mesordercode" placeholder="璇疯緭鍏�" style="width: 200px" />
             </el-form-item>
             <el-form-item label="婧愬崟鍗曞彿" style="display: flex;">
@@ -158,7 +158,7 @@
           />
           <el-table-column
             prop="status"
-            label="璁㈠崟鐘舵��"
+            label="宸ュ崟鐘舵��"
             sortable="custom"
             width="110"
             show-tooltip-when-overflow
@@ -473,7 +473,7 @@
         label-width="110px"
       >
         <el-form-item
-          label="璁㈠崟鐘舵��"
+          label="宸ュ崟鐘舵��"
           prop="mesorderstus"
         >
           <el-select
@@ -881,45 +881,45 @@
           style="display: flex;justify-content: space-between"
         >
           <div class="elForm" style="justify-content: flex-start">
-            <el-form-item
-              label="棰勮寮�宸ユ椂闂�"
-              label-width="100px"
-              style=" display: flex;font-size: 14px;margin-top: 3px"
-            >
-              <el-date-picker
-                v-model="sourceForm.paystartdate"
-                type="daterange"
-                range-separator="~"
-                class="timeMini"
-                size="mini"
-                style="width: 200px;display: flex;line-height: 34px;height: 34px;font-size: 14px!important;"
-                :clearable="false"
-                start-placeholder="寮�濮嬫棩鏈�"
-                end-placeholder="缁撴潫鏃ユ湡"
-              />
-              <!--              :picker-options="expireTimeOption"-->
+            <!--            <el-form-item-->
+            <!--              label="棰勮寮�宸ユ椂闂�"-->
+            <!--              label-width="100px"-->
+            <!--              style=" display: flex;font-size: 14px;margin-top: 3px"-->
+            <!--            >-->
+            <!--              <el-date-picker-->
+            <!--                v-model="sourceForm.paystartdate"-->
+            <!--                type="daterange"-->
+            <!--                range-separator="~"-->
+            <!--                class="timeMini"-->
+            <!--                size="mini"-->
+            <!--                style="width: 200px;display: flex;line-height: 34px;height: 34px;font-size: 14px!important;"-->
+            <!--                :clearable="false"-->
+            <!--                start-placeholder="寮�濮嬫棩鏈�"-->
+            <!--                end-placeholder="缁撴潫鏃ユ湡"-->
+            <!--              />-->
+            <!--              &lt;!&ndash;              :picker-options="expireTimeOption"&ndash;&gt;-->
 
-            </el-form-item>
-            <el-form-item
-              label="棰勮瀹屽伐鏃堕棿"
-              label-width="100px"
-              style=" display: flex;font-size: 14px;margin-top: 3px"
-            >
-              <el-date-picker
-                v-model="sourceForm.payenddate"
-                type="daterange"
-                :clearable="false"
-                class="timeMini"
-                range-separator="~"
-                start-placeholder="寮�濮嬫棩鏈�"
-                style="width: 200px;display: flex;line-height: 34px ;height: 34px ;font-size: 14px !important;"
-                end-placeholder="缁撴潫鏃ユ湡"
-                size="mini"
-              />
-            </el-form-item>
-            <el-form-item label="璁㈠崟鐘舵��" style=" display: flex;">
+            <!--            </el-form-item>-->
+            <!--            <el-form-item-->
+            <!--              label="棰勮瀹屽伐鏃堕棿"-->
+            <!--              label-width="100px"-->
+            <!--              style=" display: flex;font-size: 14px;margin-top: 3px"-->
+            <!--            >-->
+            <!--              <el-date-picker-->
+            <!--                v-model="sourceForm.payenddate"-->
+            <!--                type="daterange"-->
+            <!--                :clearable="false"-->
+            <!--                class="timeMini"-->
+            <!--                range-separator="~"-->
+            <!--                start-placeholder="寮�濮嬫棩鏈�"-->
+            <!--                style="width: 200px;display: flex;line-height: 34px ;height: 34px ;font-size: 14px !important;"-->
+            <!--                end-placeholder="缁撴潫鏃ユ湡"-->
+            <!--                size="mini"-->
+            <!--              />-->
+            <!--            </el-form-item>-->
+            <el-form-item label="宸ュ崟鐘舵��" style=" display: flex;">
               <el-select
-                v-model="sourceForm.erporderstus"
+                v-model="sourceForm.mesordercode"
                 filterable
                 :popper-append-to-body="false"
                 style="width: 200px"
@@ -933,10 +933,10 @@
                 />
               </el-select>
             </el-form-item>
-            <el-form-item v-show="isExpandDialog" label="璁㈠崟缂栧彿" style=" display: flex;">
-              <el-input v-model="sourceForm.erpordercode" placeholder="璇疯緭鍏�" style="width: 200px" />
+            <el-form-item label="宸ュ崟缂栧彿" style=" display: flex;">
+              <el-input v-model="sourceForm.sourceorder" placeholder="璇疯緭鍏�" style="width: 200px" />
             </el-form-item>
-            <el-form-item v-show="isExpandDialog" label="浜у搧缂栫爜" style=" display: flex;">
+            <el-form-item label="浜у搧缂栫爜" style=" display: flex;">
               <el-input v-model="sourceForm.partcode" style="width: 200px" placeholder="璇疯緭鍏�" />
             </el-form-item>
 
@@ -948,6 +948,27 @@
             </el-form-item>
             <el-form-item v-show="isExpandDialog" label="鍒涘缓浜哄憳" style=" display: flex;">
               <el-input v-model="sourceForm.creatuser" style="width: 200px" placeholder="璇疯緭鍏�" />
+            </el-form-item>
+
+            <el-form-item
+              v-show="isExpandDialog"
+              label="鍒涘缓鏃堕棿"
+              label-width="100px"
+              style=" display: flex;font-size: 14px;margin-top: 3px"
+            >
+              <el-date-picker
+                v-model="sourceForm.createdate"
+                type="daterange"
+                range-separator="~"
+                class="timeMini"
+                size="mini"
+                style="width: 200px;display: flex;line-height: 34px;height: 34px;font-size: 14px!important;"
+                :clearable="false"
+                start-placeholder="寮�濮嬫棩鏈�"
+                end-placeholder="缁撴潫鏃ユ湡"
+              />
+              <!--              :picker-options="expireTimeOption"-->
+
             </el-form-item>
 
           </div>
@@ -1013,27 +1034,32 @@
             fixed
             label="搴忓彿"
           />
+          <!--          <el-table-column-->
+          <!--            prop="status"-->
+          <!--            label="宸ュ崟鐘舵��"-->
+          <!--            show-tooltip-when-overflow-->
+          <!--            sortable="custom"-->
+          <!--            width="110"-->
+          <!--          >-->
+          <!--            <template slot-scope="{row}">-->
+          <!--              <div v-if="row.status==='NEW'">鏂拌鍗�</div>-->
+          <!--              <div v-if="row.status==='CREATING'">閮ㄥ垎涓嬭揪</div>-->
+          <!--              <div v-if="row.status==='CREATED'">鍏ㄩ儴涓嬭揪</div>-->
+          <!--              <div v-if="row.status==='CLOSED'">宸插叧闂�</div>-->
+          <!--            </template>-->
+          <!--          </el-table-column>-->
           <el-table-column
-            prop="status"
-            label="璁㈠崟鐘舵��"
+            label="宸ュ崟缂栧彿"
+            prop="wo_code"
             show-tooltip-when-overflow
-            sortable="custom"
-            width="110"
-          >
-            <template slot-scope="{row}">
-              <div v-if="row.status==='NEW'">鏂拌鍗�</div>
-              <div v-if="row.status==='CREATING'">閮ㄥ垎涓嬭揪</div>
-              <div v-if="row.status==='CREATED'">鍏ㄩ儴涓嬭揪</div>
-              <div v-if="row.status==='CLOSED'">宸插叧闂�</div>
-            </template>
-          </el-table-column>
-          <el-table-column
-            prop="wo"
-            label="璁㈠崟缂栧彿"
-            show-tooltip-when-overflow
-            sortable="custom"
             min-width="150"
-          />
+            sortable="custom"
+          >
+            <!--            <template slot-scope="{row}">-->
+            <!--              <div v-if="row.m_po">{{ row.m_po }}</div>-->
+            <!--              <div v-else>{{ row.wo_code }}</div>-->
+            <!--            </template>-->
+          </el-table-column>
           <el-table-column
             prop="partcode"
             label="浜у搧缂栫爜"
@@ -1061,19 +1087,28 @@
             </template>
           </el-table-column>
           <el-table-column
-            prop="qty"
-            label="璁㈠崟鏁伴噺"
+            prop="plan_qty"
+            label="浠诲姟鏁伴噺"
             width="150"
             show-tooltip-when-overflow
             sortable="custom"
           />
+
           <el-table-column
-            prop="relse_qty"
-            show-tooltip-when-overflow
-            label="宸蹭笅鍗曟暟閲�"
+            prop="bad_qty"
+            label="鎶ュ簾鏁伴噺"
             width="150"
+            show-tooltip-when-overflow
             sortable="custom"
           />
+
+          <!--          <el-table-column-->
+          <!--            prop="relse_qty"-->
+          <!--            show-tooltip-when-overflow-->
+          <!--            label="宸蹭笅鍗曟暟閲�"-->
+          <!--            width="150"-->
+          <!--            sortable="custom"-->
+          <!--          />-->
           <el-table-column
             prop="wkshp_name"
             label="鐢熶骇杞﹂棿"
@@ -1087,50 +1122,50 @@
             </template>
           </el-table-column>
           <el-table-column
-            prop="planstartdate"
+            prop="plan_startdate"
             label="棰勮寮�宸ユ椂闂�"
             show-tooltip-when-overflow
             sortable="custom"
             width="130"
           >
             <template slot-scope="{row}">
-              <div v-if="row.planstartdate">{{ row.planstartdate.substring(0, 11) }}</div>
+              <div v-if="row.plan_startdate">{{ row.plan_startdate.substring(0, 11) }}</div>
               <div v-else>/</div>
             </template>
           </el-table-column>
           <el-table-column
-            prop="planenddate"
+            prop="plan_enddate"
             label="棰勮瀹屽伐鏃堕棿"
             show-tooltip-when-overflow
             sortable="custom"
             width="130"
           >
             <template slot-scope="{row}">
-              <div v-if="row.planenddate">{{ row.planenddate.substring(0, 11) }}</div>
+              <div v-if="row.plan_enddate">{{ row.plan_enddate.substring(0, 11) }}</div>
               <div v-else>/</div>
             </template>
           </el-table-column>
           <el-table-column
-            prop="createuser"
+            prop="lm_user"
             label="鍒涘缓浜哄憳"
             show-tooltip-when-overflow
             sortable="custom"
             width="150"
           >
             <template slot-scope="{row}">
-              <div v-if="row.createuser">{{ row.createuser }}</div>
+              <div v-if="row.lm_user">{{ row.lm_user }}</div>
               <div v-else>/</div>
             </template>
           </el-table-column>
           <el-table-column
-            prop="createdate"
+            prop="lm_date"
             label="鍒涘缓鏃堕棿"
             show-tooltip-when-overflow
             width="130"
             sortable="custom"
           >
             <template slot-scope="{row}">
-              <div v-if="row.createdate">{{ row.createdate.substring(0, 11) }}</div>
+              <div v-if="row.lm_date">{{ row.lm_date.substring(0, 11) }}</div>
               <div v-else>/</div>
             </template>
           </el-table-column>
@@ -1162,7 +1197,7 @@
         align="right"
         layout="total,prev, pager, next,sizes"
         popper-class="select_bottom"
-        @pagination="getErpOrderSearch"
+        @pagination="getMesBadOrderSearch"
       />
       <span slot="footer" class="dialog-footer">
         <div class="footerButton">
@@ -1671,7 +1706,7 @@
 import {
   AddUpdateMesOrder,
   ClosedMesOrder,
-  DeleteMesOrder, ErpOrderSearch, JobCreationSonAddVison,
+  DeleteMesOrder, MesBadOrderSearch, JobCreationSonAddVison,
   MesOrderSearch, PartSelectRoute, RouteSelectWkshop, SearchWorkStep, SelectRouteOrWkshop,
   SelectRouteStep
 } from '@/api/scgl'
@@ -1745,8 +1780,8 @@
 
         routecode: '', // 宸ヨ壓璺嚎缂栫爜
         wkshopcode: '', // 鐢熶骇杞﹂棿缂栫爜
-        planstartdate: '', // 璁″垝寮�濮嬫椂闂�
-        planenddate: '', // 璁″垝瀹屾垚鏃堕棿
+        // planstartdate: '', // 璁″垝寮�濮嬫椂闂�
+        // planenddate: '', // 璁″垝瀹屾垚鏃堕棿
         orderlev: '', // 宸ュ崟绛夌骇
         isAps: 'N', // 鏄惁鎺掔▼
         bomId: '', // 鐗╂枡娓呭崟id
@@ -1876,17 +1911,18 @@
       dialogVisibleSource: false,
       sourceTableData: [],
       sourceForm: {
-        erporderstus: '', // 璁㈠崟鐘舵�佺爜
-        erpordercode: '', // 璁㈠崟缂栧彿
+        mesordercode: '', // 璁㈠崟鐘舵�佺爜
+        sourceorder: '', // 宸ュ崟缂栧彿
         partcode: '', // 浜у搧缂栫爜
         partname: '', // 浜у搧鍚嶇О
         partspec: '', // 浜у搧瑙勬牸
         creatuser: '', // 鍒涘缓浜哄憳
         // paystartdate: '', // 浜や粯鏃堕棿
-        paystartdate: '', // 棰勮寮�宸ユ椂闂�
-        payenddate: '', // 棰勮瀹屽伐鏃堕棿
+        // paystartdate: '', // 棰勮寮�宸ユ椂闂�
+        // payenddate: '', // 棰勮瀹屽伐鏃堕棿
         createdate: '', // 鍒涘缓鏃堕棿
-        prop: 'createdate', // 鎺掑簭瀛楁
+
+        prop: 'lm_date', // 鎺掑簭瀛楁
         order: 'desc', // 鎺掑簭瀛楁
         page: 1, // 绗嚑椤�
         rows: 20 // 姣忛〉澶氬皯鏉�
@@ -2002,7 +2038,7 @@
       }
       this.sourceForm.order = order
       this.sourceForm.prop = prop
-      this.getErpOrderSearch()
+      this.getMesBadOrderSearch()
     },
     // 鏌ヨ
     search() {
@@ -2515,30 +2551,31 @@
         return this.$message.info('宸ュ崟绫诲瀷涓烘姤搴熻ˉ鍗曟儏鍐典笅鍙�夋嫨锛�')
       }
 
-      this.getErpOrderSearch()
+      this.getMesBadOrderSearch()
 
       this.dialogVisibleSource = true
     },
-    async getErpOrderSearch() {
-      let tempDate2 = this.sourceForm.paystartdate
-      if (tempDate2.length > 0) {
-        tempDate2 = handleDatetime(tempDate2[0]) + '~' + handleDatetime(tempDate2[1])
-      }
+    async getMesBadOrderSearch() {
+      // let tempDate2 = this.sourceForm.paystartdate
+      // if (tempDate2.length > 0) {
+      //   tempDate2 = handleDatetime(tempDate2[0]) + '~' + handleDatetime(tempDate2[1])
+      // }
 
-      let tempDate = this.sourceForm.payenddate
+      let tempDate = this.sourceForm.createdate
       if (tempDate.length > 0) {
         tempDate = handleDatetime(tempDate[0]) + '~' + handleDatetime(tempDate[1])
       }
 
       const data = {
-        erporderstus: this.sourceForm.erporderstus, // 璁㈠崟鐘舵�佺爜
-        erpordercode: this.sourceForm.erpordercode, // 璁㈠崟缂栧彿
+        mesordercode: this.sourceForm.mesordercode, // 璁㈠崟鐘舵�佺爜
+        sourceorder: this.sourceForm.sourceorder, // 宸ュ崟缂栧彿
         partcode: this.sourceForm.partcode, // 浜у搧缂栫爜
         partname: this.sourceForm.partname, // 浜у搧鍚嶇О
         partspec: this.sourceForm.partspec, // 浜у搧瑙勬牸
-        paystartdate: tempDate2, // 浜や粯鏃堕棿
-        payenddate: tempDate, // 浜や粯鏃堕棿
+        // paystartdate: tempDate2, // 浜や粯鏃堕棿
+        // payenddate: tempDate, // 浜や粯鏃堕棿
         creatuser: this.sourceForm.creatuser, // 鍒涘缓浜哄憳
+        createdate: tempDate, // 鍒涘缓鏃堕棿
 
         prop: this.sourceForm.prop, // 鎺掑簭瀛楁
         order: this.sourceForm.order, // 鎺掑簭瀛楁
@@ -2547,8 +2584,8 @@
 
       }
 
-      const res = await ErpOrderSearch(data)
-      this.sourceTableData = res.data.filter(item => item.status !== 'NEW')
+      const res = await MesBadOrderSearch(data)
+      this.sourceTableData = res.data
       this.sourceFormTotal = res.count
     },
     // 鍗曢�夋閫変腑鑾峰彇褰撳墠琛屼俊鎭�
@@ -2558,27 +2595,28 @@
     // 鍗曢�夋閫変腑鑾峰彇褰撳墠琛屼俊鎭�
     getCurrentRowSource(row, event, column) {
       this.radioSelectedId = row.id
+      this.dialogForm.mesqty = row.bad_qty
     },
     sourceSearch() {
-      this.getErpOrderSearch()
+      this.getMesBadOrderSearch()
     },
     sourceReset() {
-      this.sourceForm.erporderstus = ''
-      this.sourceForm.erpordercode = ''
+      this.sourceForm.mesordercode = ''
+      this.sourceForm.sourceorder = ''
       this.sourceForm.partcode = ''
       this.sourceForm.partname = ''
       this.sourceForm.partspec = ''
-      this.sourceForm.paystartdate = ''
-      this.sourceForm.payenddate = ''
+      // this.sourceForm.paystartdate = ''
+      // this.sourceForm.payenddate = ''
       this.sourceForm.creatuser = ''
       this.sourceForm.createdate = ''
-      this.getErpOrderSearch()
+      this.getMesBadOrderSearch()
     },
     dialogVisibleSourceClose() {
       this.radioSelectedId = ''
 
-      this.sourceForm.erporderstus = ''
-      this.sourceForm.erpordercode = ''
+      this.sourceForm.mesordercode = ''
+      this.sourceForm.sourceorder = ''
       this.sourceForm.partcode = ''
       this.sourceForm.partname = ''
       this.sourceForm.partspec = ''
@@ -2597,7 +2635,7 @@
       console.log(this.radioSelectedId)
       this.sourceTableData.forEach(item => {
         if (item.id === this.radioSelectedId) {
-          this.dialogForm.sourceorder = item.wo
+          this.dialogForm.sourceorder = item.wo_code
           this.dialogForm.partcode = item.partcode
           this.dialogForm.partspec = item.partspec
         }

--
Gitblit v1.9.3