From ba7dfefd608d2c295f7d58d12ad1ab3802ccf666 Mon Sep 17 00:00:00 2001
From: zhoushihao <zsh19950802@163.com>
Date: 星期一, 03 三月 2025 09:18:59 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/PushMessageToIndex.java    |    4 
 hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassPushMessage.java |    2 
 UI-Project/src/assets/C1.png                                                                          |    0 
 UI-Project/src/views/GlassStorage/rawfilmstorage.vue                                                  |   49 +++++----
 UI-Project/src/lang/en.js                                                                             |    1 
 UI-Project/src/lang/py.js                                                                             |    1 
 UI-Project/src/lang/zh.js                                                                             |    1 
 UI-Project/src/views/largescreendisplay/screendisplay.vue                                             |  130 ++++++++++++++------------
 UI-Project/src/assets/ypcc.png                                                                        |    0 
 hangzhoumesParent/common/servicebase/src/main/resources/mapper/RawGlassStorageDetailsMapper.xml       |   57 ++++++----
 10 files changed, 138 insertions(+), 107 deletions(-)

diff --git a/UI-Project/src/assets/C1.png b/UI-Project/src/assets/C1.png
index 67f0e20..388f062 100644
--- a/UI-Project/src/assets/C1.png
+++ b/UI-Project/src/assets/C1.png
Binary files differ
diff --git a/UI-Project/src/assets/ypcc.png b/UI-Project/src/assets/ypcc.png
index 86fe120..8820e9b 100644
--- a/UI-Project/src/assets/ypcc.png
+++ b/UI-Project/src/assets/ypcc.png
Binary files differ
diff --git a/UI-Project/src/lang/en.js b/UI-Project/src/lang/en.js
index f7649af..4287482 100644
--- a/UI-Project/src/lang/en.js
+++ b/UI-Project/src/lang/en.js
@@ -581,6 +581,7 @@
           premark :'Please enter a note',
       },
       film:{
+          fail:'澶辫触',
           mes:'Original film storage details',
           warehousing:'store',
           pwarehousing:'鍏ュ簱璇锋眰',
diff --git a/UI-Project/src/lang/py.js b/UI-Project/src/lang/py.js
index 2edcb56..1e53c24 100644
--- a/UI-Project/src/lang/py.js
+++ b/UI-Project/src/lang/py.js
@@ -581,6 +581,7 @@
         premark :'璇疯緭鍏ュ娉�',
     },
     film:{
+        fail:'澶辫触',
         mes:'鍘熺墖浠撳偍璇︽儏',
         warehousing:'鍘熺墖鍏ュ簱',
         pwarehousing:'鍏ュ簱璇锋眰',
diff --git a/UI-Project/src/lang/zh.js b/UI-Project/src/lang/zh.js
index 145e945..a0306ae 100644
--- a/UI-Project/src/lang/zh.js
+++ b/UI-Project/src/lang/zh.js
@@ -580,6 +580,7 @@
           premark :'璇疯緭鍏ュ娉�',
       },
       film:{
+          fail:'澶辫触',
           mes:'鍘熺墖浠撳偍璇︽儏',
           warehousing:'鍘熺墖鍏ュ簱',
           pwarehousing:'鍏ュ簱璇锋眰',
diff --git a/UI-Project/src/views/GlassStorage/rawfilmstorage.vue b/UI-Project/src/views/GlassStorage/rawfilmstorage.vue
index dff40a7..f3c75a8 100644
--- a/UI-Project/src/views/GlassStorage/rawfilmstorage.vue
+++ b/UI-Project/src/views/GlassStorage/rawfilmstorage.vue
@@ -4,6 +4,7 @@
 import {ElMessage, ElMessageBox} from 'element-plus'
 import {useI18n} from 'vue-i18n'
 import {host, WebSocketHost} from '@/utils/constants'
+import dayjs from 'dayjs';
 import request from "@/utils/request"
 import {closeWebSocket, initializeWebSocket} from '@/utils/WebSocketService';
 const router = useRouter()
@@ -16,7 +17,7 @@
 const dialogFormVisiblec = ref(false)
 const dialogFormVisiblee = ref(false)
 const Edit = ref(false)
-const timeRange = ref(["2022-01-01 00:00:00", "2025-01-01 00:00:00"])
+const timeRange = ref([])
 const selectValuesa = reactive([]);
 const patternWidth = ref('');
 const patternHeight = ref('');
@@ -42,9 +43,11 @@
   taskType: '',
   taskState: '',
 });
-request.post("/glassStorage/rawGlassStorageTask/setRawGlassTaskRequest",{
-      beginDate: "2022-01-01 00:00:00",
-      endDate: "2025-01-01 00:00:00",
+  let startTime = window.localStorage.getItem('startTime')
+  let endTime = window.localStorage.getItem('endTime')
+  request.post("/glassStorage/rawGlassStorageTask/setRawGlassTaskRequest",{
+  beginDate: startTime,
+  endDate: endTime,
 }).then((response) => {
           if (response.code == 200) {
             tableDataa.value = response.data
@@ -54,15 +57,18 @@
         
           }
           });
-onMounted(() => {
-    socket = initializeWebSocket(socketUrl, handleMessage);
+  onMounted(() => {
+  socket = initializeWebSocket(socketUrl, handleMessage);
+  const endTime = dayjs().startOf('minute'); // 褰撳墠鏃堕棿锛岀簿纭埌鍒嗛挓
+  const startTime = endTime.subtract(7, 'day').startOf('minute'); // 褰撳墠鏃堕棿鐨勫墠涓�澶╋紝绮剧‘鍒板垎閽�
+  // 璁剧疆鏃堕棿鑼冨洿涓� [寮�濮嬫椂闂�, 缁撴潫鏃堕棿]
+  timeRange.value = [startTime.format('YYYY-MM-DD HH:mm:ss'), endTime.format('YYYY-MM-DD HH:mm:ss')];
+  window.localStorage.setItem('startTime', startTime.format('YYYY-MM-DD HH:mm:ss'))
+  window.localStorage.setItem('endTime', endTime.format('YYYY-MM-DD HH:mm:ss'))
 });
 let socket = null;
 const socketUrl = `ws://${WebSocketHost}:${host}/api/glassStorage/api/talk/rawGlass`;
 const handleMessage = (data) => {
-  // if(data.tasks !=null){
-  // tableDataa.value = data.tasks[0]
-  // }
     const formattedTasks = data.tasks[0].map(task => {
       if (task && task.createTime) {
         return { ...task, createTime: formatTimestamp(task.createTime) };
@@ -72,7 +78,6 @@
     tableDataa.value = formattedTasks;
   if(data.rawStationDetailsList !=null){
   tableDatab.value = data.rawStationDetailsList[0]
-  console.log(tableDatab.value);
   }
 };
 const handleEdit = (row) => {
@@ -319,21 +324,21 @@
 }
 function getStatusType2(taskState) {  
 switch (taskState) {  
-  case 1:  
+  case 0:  
     return 'info';  
   case 2:  
     return 'warning';  
-  case 3:  
+  case 1:  
     return 'success';  
 }  
 }
 function getStatusText2(taskState) {  
 switch (taskState) {
-  case 1:  
+  case 0:  
     return t('film.built');//鏂板缓
   case 2:  
-    return t('film.execution');//鎵ц涓�
-  case 3:  
+    return t('film.fail');//澶辫触
+  case 1:  
   return t('film.finish');//瀹屾垚
 }  
 }
@@ -364,9 +369,9 @@
         :end-placeholder="$t('film.endtime')"
         :default-time="defaultTime" />
     <el-select v-model="selectValuesa[0]" clearable :placeholder="$t('film.taskstatus')" style="margin-left: 10px;" >
-      <el-option :label="$t('film.built')" value="1"></el-option>
-      <el-option :label="$t('film.execution')" value="2"></el-option>
-      <el-option :label="$t('film.finish')" value="3"></el-option>
+      <el-option :label="$t('film.built')" value="0"></el-option>
+      <el-option :label="$t('film.finish')" value="1"></el-option>
+      <el-option :label="$t('film.fail')" value="2"></el-option>
     </el-select>
     <el-select v-model="selectValuesa[1]" clearable :placeholder="$t('film.tasktype')" style="margin-left: 10px;" >
       <el-option :label="$t('film.stocke')" value="1"></el-option>
@@ -411,7 +416,7 @@
       </div>
     </el-card>
     <div class="img-dlpl">
-    <div class="img-car1" :style="'z-index:999;top:20px;left:' + 330 + 'px;position:absolute;'">
+    <div class="img-car1" :style="'z-index:999;top:250px;left:' + 20 + 'px;position:absolute;'">
     </div>
     </div>
     <el-dialog v-model="dialogFormVisiblea" top="5vh" width="85%" >
@@ -655,10 +660,10 @@
   position: absolute;
   background-repeat: no-repeat;
   background-attachment: local;
-  min-height: 200px;
-  width: 200px;
+  min-height: 150px;
+  width: 70px;
   max-width: 100%;
-  background-size: 200px 70px;
+  background-size: 70px 150px;
   overflow: hidden;
   position:relative
 }
diff --git a/UI-Project/src/views/largescreendisplay/screendisplay.vue b/UI-Project/src/views/largescreendisplay/screendisplay.vue
index d669cbc..4390eac 100644
--- a/UI-Project/src/views/largescreendisplay/screendisplay.vue
+++ b/UI-Project/src/views/largescreendisplay/screendisplay.vue
@@ -24,13 +24,13 @@
 const edgOneTasks = ref([])
 const edgTwoTasks = ref([])
 const engineeringOne = ref([])
-const engineeringTow = ref([])
+const engineeringTwo = ref([])
 const socketUrl1 = `ws://${WebSocketHost}:${host}/api/cacheGlass/api/talk/largenScreen`;
 const handleMessage1 = (data) => {
   edgOneTasks.value = data.edgOneTasks[0];
   edgTwoTasks.value = data.edgTwoTasks[0];
   engineeringOne.value = data.engineeringOne[0];
-  engineeringTow.value = data.engineeringTow[0];
+  engineeringTwo.value = data.engineeringTwo[0];
 };
 
 let socket2 = null;
@@ -42,20 +42,13 @@
   temperingGlassInfoList.value = data.temperingGlassInfoList[0];
 };
 
-
-const handleBinda = async (row) => {
-  blinda.value = true;
-  await fetchFlowCardId(row.orderId);
-};
-const fetchFlowCardId = async (orderId) => {
+const tableDatad = ref([]);
+const patternUsage = async () => {
   try {
-    const response = await request.post('/loadGlass/order/order/selectOrderdetail', {
-      orderId: orderId
-    })
+    const response = await request.post('/glassStorage/rawGlassStorageDetails/patternUsage?width=' + ptnusage.value.width + '&height=' + ptnusage.value.height + '&thickness=' + ptnusage.value.thickness + '&films=' + ptnusage.value.films);
     if (response.code == 200) {
       ElMessage.success(response.message);
-      tableData.value = response.data;
-      console.log(tableData.value);
+      tableDatad.value = response.data;
     } else {
       ElMessage.error(response.message);
     }
@@ -64,10 +57,18 @@
     console.error(error);
   }
 }
+const ptnusage=ref({
+  width: '',
+  height: '',
+  thickness: '',
+  films: ''
+})
+
+
 // 鐐瑰嚮涓嬫柟寮圭獥
 const handlehistorical = (row) => {
   blindb.value = true;
-  historical()
+  // historical()
 };
 // 鍦ㄧ粍浠舵寕杞芥椂璁剧疆榛樿鏃堕棿鑼冨洿
 onMounted(() => {
@@ -97,10 +98,23 @@
 <template>
   <div style="height: 500px;">
     <div class="awatch">
-      <img src="../../assets/screen.png" alt="Screen"
-        style="max-width: 48%; max-height: 100%; margin-top: 50px; float: left; position: relative;" />
+      <div class="img-screen" alt="Screen">
+        <!-- 閽㈠寲鑹插潡 -->
+        <div v-if="temperingGlassInfoList>0" class="tempering" style="width: 50px;height: 22px;top: 354px;left: 228px;position: absolute;background-color: red;"></div>
+        <div v-if="temperingGlassInfoList>1" class="tempering" style="width: 50px;height: 22px;top: 354px;left: 284px;position: absolute;background-color: red;"></div>
+        <!-- 鍒囧壊鍙拌壊鍧� -->
+        <div v-if="engineeringOne.length>1" class="slicing" style="width: 50px;height: 22px;top: 575px;left: 453px;position: absolute;background-color: red;"></div>
+        <div v-if="engineeringTwo.length>1" class="slicing" style="width: 50px;height: 22px;top: 625px;left: 453px;position: absolute;background-color: red;"></div>
+        <!-- 鍘熺墖浠撳偍鑹插潡 -->
+        <div class="raw" style="width: 31px;height: 32px;top: 571px;left: 300px;position: absolute;">
+          <div v-for="(item,index) in rawGlassStorageDetailList.slice(0,7)" :key="index" :style='"width: "+item.remainQuantity+"px;height: 5px;background-color: red;"'></div>
+        </div>
+        <!-- <div class="raw" style="width: 31px;height: 32px;top: 571px;left: 300px;position: absolute;background-color: red;">
+          <div v-for="(item,index) in rawGlassStorageDetailList.slice(0,7)" :key="index" :style='"width: "+item.remainQuantity+"px;height: 5px;background-color: red;"'></div>
+        </div> -->
+      </div>
       <div class="clickable-area" @click="handlehistorical"
-        style="position: relative; width: 175px; height: 240px; top: 570px; left: 310px;"></div>
+        style="position: relative;width: 110px;height: 140px;top: 603px;left: 297px;"></div>
     </div>
     <div style="height: 190px;width: 48%;float: right;">
       <el-table height="500" ref="table" @selection-change="handleSelectionChange" :data="tableDatac"
@@ -129,25 +143,21 @@
   </div>
   <!-- 鐐瑰嚮涓嬫柟寮圭獥 -->
   <el-dialog v-model="blindb" top="10vh" width="90%">
-  <div style="display: flex;">
-            <el-select 
-            :placeholder="$t('basicData.coatingtypes')"
-             clearable
-             style="width: 270px;margin-left: 10px;"  
-             v-model="taskStat">
-               <el-option
-                v-for="item in optionsa"
-                :key="item.value"
-                :label="item.label"
-                :value="item.value"
-              />
-          </el-select>
-          <!-- <span class="demonstration" style="margin-left: 20px;margin-top: 3px;">{{ $t('workOrder.time') }}</span> -->
-            <!-- <el-date-picker v-model="timeRange" type="datetimerange" range-separator="鑷�" :start-placeholder="$t('reportmanage.starttime')" 
+    <div style="display: flex;">
+      <el-input v-model="ptnusage.width" placeholder="璇疯緭鍏ュ搴�" style="width: 270px;margin-left: 10px;" clearable></el-input>
+      <el-input v-model="ptnusage.height" placeholder="璇疯緭鍏ラ珮搴�" style="width: 270px;margin-left: 10px;" clearable></el-input>
+      <el-input v-model="ptnusage.thickness" placeholder="璇疯緭鍏ュ帤搴�" style="width: 270px;margin-left: 10px;" clearable></el-input>
+      <el-input v-model="ptnusage.films" placeholder="璇疯緭鍏ヨ啘绯�" style="width: 270px;margin-left: 10px;" clearable></el-input>
+      <!-- <el-select :placeholder="$t('basicData.coatingtypes')" clearable style="width: 270px;margin-left: 10px;"
+        v-model="taskStat">
+        <el-option v-for="item in optionsa" :key="item.value" :label="item.label" :value="item.value" />
+      </el-select> -->
+      <!-- <span class="demonstration" style="margin-left: 20px;margin-top: 3px;">{{ $t('workOrder.time') }}</span> -->
+      <!-- <el-date-picker v-model="timeRange" type="datetimerange" range-separator="鑷�" :start-placeholder="$t('reportmanage.starttime')" 
              style="margin-left: 15px;" value-format = "YYYY-MM-DD hh:mm:ss"
               :end-placeholder="$t('reportmanage.endtime')">
             </el-date-picker> -->
-            <!-- <el-date-picker
+      <!-- <el-date-picker
               v-model="timeRange"
               type="datetimerange"
               range-separator="鑷�"
@@ -156,43 +166,26 @@
               value-format="YYYY-MM-DD hh:mm:ss"
               :end-placeholder="$t('reportmanage.endtime')">
             </el-date-picker> -->
-          <el-button type="primary" style="margin-left: 10px;margin-bottom: 10px;" @click="sethistorical()">{{
+      <el-button type="primary" style="margin-left: 10px;margin-bottom: 10px;" @click="patternUsage()">{{
         $t('reportmanage.inquire')
       }}</el-button>
     </div>
     <el-table ref="table" style="margin-top: 20px;height: 650px;" :data="tableDatad"
       :header-cell-style="{ background: '#F2F3F5 ', color: '#1D2129' }">
-      <el-table-column prop="glassIdIn" align="center" :label="$t('searchOrder.intoglassid')" min-width="80" />
-      <el-table-column prop="glassIdOut" align="center" :label="$t('searchOrder.outputglassID')" min-width="80" />
-      <el-table-column prop="currentCell" align="center" :label="$t('sorter.layernow')" min-width="80" />
-      <el-table-column prop="startCell" align="center" :label="$t('processCard.layer')" min-width="120" />
-      <el-table-column align="center" :label="$t('film.taskstatus')" min-width="80" prop="taskState">
-        <template #default="scope">
-          <el-tag :type="getStatusTypeb(scope.row.taskState)">
-            {{ getStatusTextb(scope.row.taskState) }}
-          </el-tag>
-        </template>
-      </el-table-column>
-      <el-table-column align="center" :label="$t('film.enabletype')" min-width="80" prop="taskType">
-        <template #default="scope">
-          <el-tag :type="getStatusTypea(scope.row.taskType)">
-            {{ getStatusTexta(scope.row.taskType) }}
-          </el-tag>
-        </template>
-      </el-table-column>
-      <el-table-column prop="createTime" align="center" :label="$t('film.createtime')" min-width="120" />
-      <el-table-column prop="updateTime" align="center" :label="$t('sorter.updateTime')" min-width="120" />
+      <el-table-column prop="patternWidth" align="center" :label="$t('瀹�')" min-width="80" />
+      <el-table-column prop="patternHeight" align="center" :label="$t('楂�')" min-width="80" />
+      <el-table-column prop="patternThickness" align="center" :label="$t('鍘氬害')" min-width="80" />
+      <el-table-column prop="filmsId" align="center" :label="$t('鑶滅郴')" min-width="120" />
+      <el-table-column prop="totalCount" align="center" :label="$t('鎬绘暟閲�')" min-width="120" />
+      <el-table-column prop="count" align="center" :label="$t('绗煎唴鏁伴噺')" min-width="120" />
+      <el-table-column prop="finishCount" align="center" :label="$t('涓婄墖鏁伴噺')" min-width="120" />
+      <el-table-column prop="damageCount" align="center" :label="$t('鐮存崯鏁伴噺')" min-width="120" />
     </el-table>
-    <template #footer>
-      <div id="dialog-footer">
-        <el-button @click="blindb = false">{{ $t('large.close') }}</el-button>
-      </div>
-    </template>
   </el-dialog>
   <el-dialog v-model="blinda" top="5vh" width="85%">
     <el-table height="650" ref="table" @selection-change="handleSelectionChange" :data="tableData"
       :header-cell-style="{ background: '#F2F3F5 ', color: '#1D2129' }">
-      <el-table-column prop="orderId" fixed align="center" :label="$t('large.orderId')" min-width="110" />
+      <el-table-column prop="orderId" fixed align="center" :label="$t('large.orderId1')" min-width="110" />
       <el-table-column prop="project" align="center" :label="$t('large.project')" min-width="110" />
       <el-table-column prop="processId" align="center" :label="$t('large.cardnumber')" min-width="110" />
       <el-table-column prop="orderNumber" align="center" :label="$t('large.serialnumber')" min-width="110" />
@@ -255,6 +248,23 @@
   height: 460px;
 }
 
+.img-screen {
+  max-width: 48%;
+  max-height: 100%;
+  margin-top: 50px;
+  float: left;
+  position: relative;
+  background-image: url('../../assets/screen.png');
+  width: 808px;
+  height: 841px;
+  background-size: contain;
+  background-repeat: no-repeat;
+  background-position: center;
+  /* width: 100%; 
+  height: 0; 
+  padding-bottom: 50%;  */
+}
+
 .clickable-area {
   cursor: pointer;
   /* 鎸囩ず杩欐槸涓�涓彲鐐瑰嚮鐨勫尯鍩� */
diff --git a/hangzhoumesParent/common/servicebase/src/main/resources/mapper/RawGlassStorageDetailsMapper.xml b/hangzhoumesParent/common/servicebase/src/main/resources/mapper/RawGlassStorageDetailsMapper.xml
index 56269da..e84942f 100644
--- a/hangzhoumesParent/common/servicebase/src/main/resources/mapper/RawGlassStorageDetailsMapper.xml
+++ b/hangzhoumesParent/common/servicebase/src/main/resources/mapper/RawGlassStorageDetailsMapper.xml
@@ -39,31 +39,42 @@
         AND T1.SLOT IS NULL
     </select>
 
-    <select id="listBySlotState" resultMap="RawGlassStorageDetailsDTO">
+    <select id="patternUsage" resultMap="RawGlassStorageDetailsDTO">
         select rgsd.pattern_width,
-               rgsd.pattern_height,
-               rgsd.pattern_thickness,
-               rgsd.films_id,
-               rgsd.count + sum(lgdth.finish_count) + sum(damage_count),
-               rgsd.count,
-               sum(lgdth.finish_count) as finishCount,
-               sum(damage_count)       as damageCount
+        rgsd.pattern_height,
+        rgsd.pattern_thickness,
+        rgsd.films_id,
+        ifnull(rgsd.count,0) + ifnull(sum(lgdth.finish_count),0) + ifnull(sum(damage_count),0) as totalCount,
+        ifnull(rgsd.count,0) as count,
+        ifnull(sum(lgdth.finish_count),0) as finishCount,
+        ifnull(sum(damage_count),0) as damageCount
         from (select pattern_width,
-                     pattern_height,
-                     pattern_thickness,
-                     films_id,
-                     sum(case when state = 100 then remain_quantity else 0 end) as count
-              from raw_glass_storage_details
-              group by pattern_width, pattern_height, pattern_thickness, films_id) as rgsd
-                 left JOIN load_glass_device_task_history as lgdth
-                           on rgsd.pattern_width = lgdth.raw_glass_width
-                               and rgsd.pattern_height = lgdth.raw_glass_height
-                               and rgsd.pattern_thickness = lgdth.raw_glass_thickness
-                               and rgsd.films_id = lgdth.raw_glass_films_id
-        where rgsd.pattern_width like "%#{processId}%"
-          and rgsd.pattern_height like "%#{pattern_height}%"
-          and rgsd.pattern_thickness like "%#{pattern_thickness}%"
-          and rgsd.films_id like "%#{films_id}%"
+        pattern_height,
+        pattern_thickness,
+        films_id,
+        sum(case when state = 100 then remain_quantity else 0 end) as count
+        from raw_glass_storage_details
+        group by pattern_width, pattern_height, pattern_thickness, films_id) as rgsd
+        left JOIN load_glass_device_task_history as lgdth
+        on rgsd.pattern_width = lgdth.raw_glass_width
+        and rgsd.pattern_height = lgdth.raw_glass_height
+        and rgsd.pattern_thickness = lgdth.raw_glass_thickness
+        and rgsd.films_id = lgdth.raw_glass_films_id
+        <where>
+            1=1
+            <if test="width != null and width != ''">
+                and rgsd.pattern_width like concat('%', #{width}, '%')
+            </if>
+            <if test="height != null and height != ''">
+                and rgsd.pattern_height like concat('%', #{height}, '%')
+            </if>
+            <if test="thickness != null and thickness != ''">
+                and rgsd.pattern_thickness like concat('%', #{thickness}, '%')
+            </if>
+            <if test="films != null and films != ''">
+                and rgsd.films_id like concat('%', #{films}, '%')
+            </if>
+        </where>
         group by rgsd.pattern_width, rgsd.pattern_height, rgsd.pattern_thickness, rgsd.films_id
     </select>
 </mapper>
diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/PushMessageToIndex.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/PushMessageToIndex.java
index 4628ee2..97f8fef 100644
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/PushMessageToIndex.java
+++ b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/PushMessageToIndex.java
@@ -168,13 +168,15 @@
         List<Engineering> engineeringOne = engineeringService.list(
                 new LambdaQueryWrapper<Engineering>()
                         .eq(Engineering::getStationCell, 5)
+                        .eq(Engineering::getState, 0)
         );
         List<Engineering> engineeringTow = engineeringService.list(
                 new LambdaQueryWrapper<Engineering>()
                         .eq(Engineering::getStationCell, 6)
+                        .eq(Engineering::getState, 0)
         );
         jsonObject.append("engineeringOne", engineeringOne);
-        jsonObject.append("engineeringTow", engineeringTow);
+        jsonObject.append("engineeringTwo", engineeringTow);
         ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("largenScreen");
         if (sendwServer != null) {
             for (WebSocketServer webserver : sendwServer) {
diff --git a/hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassPushMessage.java b/hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassPushMessage.java
index e22f979..ae005d6 100644
--- a/hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassPushMessage.java
+++ b/hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassPushMessage.java
@@ -60,7 +60,7 @@
         JSONObject jsonObject = new JSONObject();
         MPJLambdaWrapper<RawGlassStorageDetails> wrapper = new MPJLambdaWrapper<>();
         wrapper.select(RawGlassStorageStation::getSlot)
-                .select(RawGlassStorageDetails::getRemainQuantity)
+                .select("ifnull(remain_quantity, 0) as remain_quantity")
                 .rightJoin(RawGlassStorageStation.class, on -> on.eq(RawGlassStorageStation::getSlot, RawGlassStorageDetails::getSlot)
                         .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_IN))
                 .orderByAsc(RawGlassStorageStation::getSlot);

--
Gitblit v1.8.0