新增需求 #2133
已結束
空母棧板數, 當母棧在CV時, 會計算少一
是由 冠榮 林 於 4 個月 前加入. 於 3 個月 前更新.
概述
getWcsStorageStatus 只找自動倉內母棧,
故當棧板在CV時, wcsCarrierCount.getTotalElements() 會變 53, 導致計算空母數量錯誤
應該要用 db/data/CarrierObjs 取得所有母棧數, 比較精準
待我案場實測後, 在留言告知正確公式
謝謝
檔案
| clipboard-202501222222-lrhzv.png (27.6 KB) clipboard-202501222222-lrhzv.png | 冠榮 林, 2025-01-22 14:22 | ||
| clipboard-202501241125-ybbdg.png (833 KB) clipboard-202501241125-ybbdg.png | 冠榮 林, 2025-01-24 03:26 | ||
| clipboard-202502041854-cq1y6.png (21.8 KB) clipboard-202502041854-cq1y6.png | 冠榮 林, 2025-02-04 10:54 | ||
| clipboard-202502081755-kpypn.png (376 KB) clipboard-202502081755-kpypn.png | 冠榮 林, 2025-02-08 09:55 |
是由 冠榮 林 於 4 個月 前更新
- 檔案 clipboard-202501241125-ybbdg.png clipboard-202501241125-ybbdg.png 已新增
- 被分派者 從 冠榮 林 變更為 家慶 潘
經確認, WMS 呼叫錯誤 API, 應呼叫 db/data/CarrierObjects
前提是, db/data/CarrierObjects 要支援篩選空母棧
舉例: 增加參數 isEmptyPallet, 並多回傳 totalEmements
邏輯如下
isEmptyPallet=true: 回傳 tag == ""的資料與 totalEmements
isEmptyPallet=false: 回傳 tag != ""的資料與 totalEmements
是由 家慶 潘 於 3 個月 前更新
- 被分派者 從 家慶 潘 變更為 冠榮 林
- 預估工時 設定為 8:00 小時
git: be44ce75e0259214e08b5967172924f5c064abdb [be44ce7]
過濾支援
id,attachObject,attachId,tag,isEmptyPallet
排序支援
id,attachObject,attachId,tag
使用方式如
http://localhost:19090/db/data/StallDevices
API
http://localhost:19090/db/data/CarrierObjs
{"totalPages":1,"content":[{"attachObject":"XYZStallDevice","id":"A0001","tag":"{"GPNo":"S0024855"}","attachId":"101010102"},{"attachObject":"XYZStallDevice","id":"A0005","tag":"{"GPNo":"S0024855"}","attachId":"101020103"},{"attachObject":"XYZStallDevice","id":"A0009","tag":"{"GPNo":"S0024855"}","attachId":"101010203"},{"attachObject":"XYZStallDevice","id":"A0013","tag":"{"GPNo":"S0024855"}","attachId":"101020203"},{"attachObject":"XYZStallDevice","id":"A0017","tag":"{"GPNo":"S0024855"}","attachId":"101030203"},{"attachObject":"XYZStallDevice","id":"A0021","tag":"","attachId":"101010303"},{"attachObject":"XYZStallDevice","id":"A0025","tag":"{"GPNo":"S0024855"}","attachId":"101020303"},{"attachObject":"XYZStallDevice","id":"A0029","tag":"{"GPNo":"S0024855"}","attachId":"101030303"},{"attachObject":"XYZStallDevice","id":"A0033","tag":"{"GPNo":"S0024855"}","attachId":"101010403"},{"attachObject":"XYZStallDevice","id":"A0037","tag":"{"GPNo":"S0024855"}","attachId":"101020403"},{"attachObject":"XYZStallDevice","id":"A0041","tag":"{"GPNo":"S0024855"}","attachId":"101030403"},{"attachObject":"XYZStallDevice","id":"A0045","tag":"{"GPNo":"S0024855"}","attachId":"101010503"},{"attachObject":"XYZStallDevice","id":"A0049","tag":"{"GPNo":"S0024855"}","attachId":"101020503"},{"attachObject":"XYZStallDevice","id":"A0053","tag":"{"GPNo":"S0024855"}","attachId":"101030503"},{"attachObject":"XYZStallDevice","id":"A0002","tag":"{"GPNo":"S0024855"}","attachId":"101010103"},{"attachObject":"XYZStallDevice","id":"A0006","tag":"{"GPNo":"S0024855"}","attachId":"101020104"},{"attachObject":"XYZStallDevice","id":"A0010","tag":"{"GPNo":"S0024855"}","attachId":"101010204"},{"attachObject":"XYZStallDevice","id":"A0014","tag":"{"GPNo":"S0024855"}","attachId":"101020204"},{"attachObject":"XYZStallDevice","id":"A0018","tag":"{"GPNo":"S0024855"}","attachId":"101030204"},{"attachObject":"XYZStallDevice","id":"A0022","tag":"{"GPNo":"S0024855"}","attachId":"101010304"},{"attachObject":"XYZStallDevice","id":"A0026","tag":"{"GPNo":"S0024855"}","attachId":"101020304"},{"attachObject":"XYZStallDevice","id":"A0030","tag":"{"GPNo":"S0024855"}","attachId":"101030304"},{"attachObject":"XYZStallDevice","id":"A0034","tag":"{"GPNo":"S0024855"}","attachId":"101010404"},{"attachObject":"XYZStallDevice","id":"A0038","tag":"{"GPNo":"S0024855"}","attachId":"101020404"},{"attachObject":"XYZStallDevice","id":"A0042","tag":"{"GPNo":"S0024855"}","attachId":"101030404"},{"attachObject":"XYZStallDevice","id":"A0046","tag":"{"GPNo":"S0024855"}","attachId":"101010504"},{"attachObject":"XYZStallDevice","id":"A0050","tag":"{"GPNo":"S0024855"}","attachId":"101020504"},{"attachObject":"XYZStallDevice","id":"A0054","tag":"{"GPNo":"S0024855"}","attachId":"101030504"},{"attachObject":"XYZStallDevice","id":"A0003","tag":"","attachId":"101010104"},{"attachObject":"XYZStallDevice","id":"A0007","tag":"{"GPNo":"S0024855"}","attachId":"101010201"},{"attachObject":"XYZStallDevice","id":"A0011","tag":"{"GPNo":"S0024855"}","attachId":"102020202"},{"attachObject":"XYZStallDevice","id":"A0015","tag":"{"GPNo":"S0024855"}","attachId":"102030202"},{"attachObject":"XYZStallDevice","id":"A0019","tag":"{"GPNo":"S0024855"}","attachId":"101010301"},{"attachObject":"XYZStallDevice","id":"A0023","tag":"{"GPNo":"S0024855"}","attachId":"102020302"},{"attachObject":"XYZStallDevice","id":"A0027","tag":"{"GPNo":"S0024855"}","attachId":"102030302"},{"attachObject":"XYZStallDevice","id":"A0031","tag":"{"GPNo":"S0024855"}","attachId":"101010401"},{"attachObject":"XYZStallDevice","id":"A0035","tag":"{"GPNo":"S0024855"}","attachId":"102020402"},{"attachObject":"XYZStallDevice","id":"A0039","tag":"{"GPNo":"S0024855"}","attachId":"102030402"},{"attachObject":"XYZStallDevice","id":"A0043","tag":"{"GPNo":"S0024855"}","attachId":"101010501"},{"attachObject":"XYZStallDevice","id":"A0047","tag":"{"GPNo":"S0024855"}","attachId":"102020502"},{"attachObject":"XYZStallDevice","id":"A0051","tag":"{"GPNo":"S0024855"}","attachId":"102030502"},{"attachObject":"XYZStallDevice","id":"A0004","tag":"{"GPNo":"S0024855"}","attachId":"101020102"},{"attachObject":"XYZStallDevice","id":"A0008","tag":"{"GPNo":"S0024855"}","attachId":"101010202"},{"attachObject":"XYZStallDevice","id":"A0012","tag":"{"GPNo":"S0024855"}","attachId":"101020202"},{"attachObject":"XYZStallDevice","id":"A0016","tag":"{"GPNo":"S0024855"}","attachId":"101030202"},{"attachObject":"XYZStallDevice","id":"A0020","tag":"{"GPNo":"S0024855"}","attachId":"101010302"},{"attachObject":"XYZStallDevice","id":"A0024","tag":"{"GPNo":"S0024855"}","attachId":"101020302"},{"attachObject":"XYZStallDevice","id":"A0028","tag":"{"GPNo":"S0024855"}","attachId":"101030302"},{"attachObject":"XYZStallDevice","id":"A0032","tag":"{"GPNo":"S0024855"}","attachId":"101010402"},{"attachObject":"XYZStallDevice","id":"A0036","tag":"{"GPNo":"S0024855"}","attachId":"101020402"},{"attachObject":"XYZStallDevice","id":"A0040","tag":"{"GPNo":"S0024855"}","attachId":"101030402"},{"attachObject":"XYZStallDevice","id":"A0044","tag":"{"GPNo":"S0024855"}","attachId":"101010502"},{"attachObject":"XYZStallDevice","id":"A0048","tag":"{"GPNo":"S0024855"}","attachId":"101020502"},{"attachObject":"XYZStallDevice","id":"A0052","tag":"{"GPNo":"S0024855"}","attachId":"101030502"}],"totalElements":54}
http://localhost:19090/db/data/CarrierObjs?isEmptyPallet=true
{"totalPages":1,"content":[{"attachObject":"XYZStallDevice","id":"A0021","tag":"","attachId":"101010303"},{"attachObject":"XYZStallDevice","id":"A0003","tag":"","attachId":"101010104"}],"totalElements":2}
是由 冠榮 林 於 3 個月 前更新
· 已被編輯
現況: 空母棧板數, 由 getWcsStorageStatus 取的, 其內部邏輯是呼叫 WCS db/data/StallDevices
當棧板在CV時, wcsCarrierCount.getTotalElements() 會變 53, 導致計算空母數量錯誤
正確作法: getWcsStorageStatus 內部邏輯, 請改呼叫 db/data/CarrierObjs?isEmptyPallet=true (參數帶 true)
並取得 wcsCarrierCount.getTotalElements() 回傳即可, 不用在 -total
是由 冠榮 林 於 3 個月 前更新
- 檔案 clipboard-202502081755-kpypn.png clipboard-202502081755-kpypn.png 已新增
- 狀態 從 新提問 變更為 問題結案
- 被分派者 從 鼎 秦 變更為 冠榮 林
紀錄一下:
目前出庫一板子母棧, 抵達站點
子母棧板數, 由於是抓 WMS 庫存表, 此時該板已清庫存, 故子母棧板數少1
空母棧板數, 由於是抓 WCS 母棧表, 此時該板尚未變成空板過材積門, 故空母棧板數維持
這是正常現象, 是 WMS清帳時機, 和 WCS 不同步造成的時間差
(WCS棧板 加/清帳, 是 子母板/空板 入庫通過材積門才 加/清)