專案

一般

配置概況

動作
複製連結

BUG #1916

已結束

儲位管理, 用 "儲位編號", "母棧板編號", "子棧編號" 排序失敗

是由 冠榮 林 於 約 1 年 前加入. 於 約 1 年 前更新.

狀態:
問題結案
優先權:
Immediate
被分派者:
冠榮 林
開始日期:
2024-04-26
完成日期:
完成百分比:

0%

預估工時:
2:00 小時
耗用工時:
18:00 小時
預計完成日期:

概述

!clipboard-202404261250-brxqx.png!
前端用 "儲位編號", "母棧板編號", "子棧編號" 排序失敗

!clipboard-202404261253-jcctl.png!
!clipboard-202404261253-rziyv.png!

檔案

下載所有檔案
clipboard-202404261250-brxqx.png (244 KB) clipboard-202404261250-brxqx.png 冠榮 林, 2024-04-26 04:50
clipboard-202404261253-jcctl.png (167 KB) clipboard-202404261253-jcctl.png 冠榮 林, 2024-04-26 04:53
clipboard-202404261253-rziyv.png (185 KB) clipboard-202404261253-rziyv.png 冠榮 林, 2024-04-26 04:53
clipboard-202405031107-qyjcs.png (20.2 KB) clipboard-202405031107-qyjcs.png 鼎 秦, 2024-05-03 03:07
clipboard-202405071610-8mvif.png (48.4 KB) clipboard-202405071610-8mvif.png 冠榮 林, 2024-05-07 08:10
clipboard-202405071623-avaqt.png (301 KB) clipboard-202405071623-avaqt.png 冠榮 林, 2024-05-07 08:23
clipboard-202405081008-jv6s9.png (17.1 KB) clipboard-202405081008-jv6s9.png 鼎 秦, 2024-05-08 02:08
動作
複製連結
 #1

是由 冠榮 林 於 約 1 年 前更新 · 已被編輯

  • 被分派者 從 鼎 秦 變更為 家慶 潘

WCS 的儲位表查詢 API, 需要支援排序
WMS 前端目前用到的欄位有 儲位編號, 母棧板編號, 子棧板編號
若能支援更多欄位排序更好

另外, 根據剛剛會議結論, 此 API 也要支援分頁
謝謝

動作
複製連結
 #2

是由 家慶 潘 於 約 1 年 前更新 · 已被編輯

  • 被分派者 從 家慶 潘 變更為 鼎 秦
  • 預估工時 設定為 8:00 小時

http://localhost:19090/db/data/StallDevices
取得全部及預設結果
預設排序(direction) ASC(由小到大)
direction
ASC:小到大
DESC:大到小
預設排序欄位(properties) id
properties
id:儲位號
gPNo:子棧板號
carrierId:母棧板號
lx:X軸或Column與梭車流道位置可算出深度.. 1,2,3(梭車流道),4,5,6,7 深度ABS(lx-3) lx(1)=ABS(1-3)深度為2 lx(4)=(4-3)深度為1 ,lx(5)=(5-3)深度為2,lx(7)=(7-3)深度為4
ly:Y軸或Row
lz:Z軸或Layer或樓層

預設取的資料(size) 全部
預設取的分頁(page) 1

可過濾執行參數
direction,properties,size,page

這次資料新增lx,ly,lz 欄位
API 結果如下
[{"gPNo":"S0024855","id":"101030204","carrierId":"A0018","lx":7,"ly":5,"lz":2},{"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"gPNo":"S0024855","id":"101020504","carrierId":"A0050","lx":7,"ly":4,"lz":5},{"gPNo":"S0024855","id":"101010203","carrierId":"A0009","lx":6,"ly":3,"lz":2},{"gPNo":"S0024855","id":"101020303","carrierId":"A0025","lx":6,"ly":4,"lz":3},{"gPNo":"S0024855","id":"101030403","carrierId":"A0041","lx":6,"ly":5,"lz":4},{"gPNo":"","id":"101010102","carrierId":"","lx":5,"ly":3,"lz":1},{"gPNo":"S0024855","id":"101030202","carrierId":"A0016","lx":5,"ly":5,"lz":2},{"gPNo":"S0024855","id":"101010402","carrierId":"A0036","lx":5,"ly":3,"lz":4},{"gPNo":"S0024855","id":"101020502","carrierId":"A0048","lx":5,"ly":4,"lz":5},{"gPNo":"S0024855","id":"102030202","carrierId":"A0015","lx":1,"ly":5,"lz":2},{"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"gPNo":"S0024855","id":"101020101","carrierId":"A0002","lx":4,"ly":4,"lz":1},{"gPNo":"","id":"101010301","carrierId":"","lx":4,"ly":3,"lz":3},{"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"gPNo":"S0024855","id":"101020104","carrierId":"A0006","lx":7,"ly":4,"lz":1},{"gPNo":"S0024855","id":"101010304","carrierId":"A0022","lx":7,"ly":3,"lz":3},{"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"gPNo":"S0024855","id":"101030504","carrierId":"A0054","lx":7,"ly":5,"lz":5},{"gPNo":"S0024855","id":"101020203","carrierId":"A0013","lx":6,"ly":4,"lz":2},{"gPNo":"S0024855","id":"101030303","carrierId":"A0029","lx":6,"ly":5,"lz":3},{"gPNo":"S0024855","id":"101010503","carrierId":"A0045","lx":6,"ly":3,"lz":5},{"gPNo":"S0024855","id":"101020102","carrierId":"A0004","lx":5,"ly":4,"lz":1},{"gPNo":"","id":"101010302","carrierId":"","lx":5,"ly":3,"lz":3},{"gPNo":"","id":"101020402","carrierId":"","lx":5,"ly":4,"lz":4},{"gPNo":"S0024855","id":"101030502","carrierId":"A0052","lx":5,"ly":5,"lz":5},{"gPNo":"S0024855","id":"102020302","carrierId":"A0023","lx":1,"ly":4,"lz":3},{"gPNo":"S0024855","id":"102020502","carrierId":"A0047","lx":1,"ly":4,"lz":5},{"gPNo":"","id":"101010201","carrierId":"","lx":4,"ly":3,"lz":2},{"gPNo":"S0024855","id":"101020301","carrierId":"A0020","lx":4,"ly":4,"lz":3},{"gPNo":"S0024855","id":"101030401","carrierId":"A0032","lx":4,"ly":5,"lz":4},{"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"gPNo":"S0024855","id":"101010204","carrierId":"A0010","lx":7,"ly":3,"lz":2},{"gPNo":"S0024855","id":"101020304","carrierId":"A0026","lx":7,"ly":4,"lz":3},{"gPNo":"S0024855","id":"101030404","carrierId":"A0042","lx":7,"ly":5,"lz":4},{"gPNo":"","id":"101010103","carrierId":"","lx":6,"ly":3,"lz":1},{"gPNo":"S0024855","id":"101030203","carrierId":"A0017","lx":6,"ly":5,"lz":2},{"gPNo":"S0024855","id":"101010403","carrierId":"A0031","lx":6,"ly":3,"lz":4},{"gPNo":"S0024855","id":"101020503","carrierId":"A0049","lx":6,"ly":4,"lz":5},{"gPNo":"","id":"101010202","carrierId":"","lx":5,"ly":3,"lz":2},{"gPNo":"S0024855","id":"101020302","carrierId":"A0024","lx":5,"ly":4,"lz":3},{"gPNo":"S0024855","id":"101030402","carrierId":"A0040","lx":5,"ly":5,"lz":4},{"gPNo":"S0024855","id":"102020102","carrierId":"A0001","lx":1,"ly":4,"lz":1},{"gPNo":"S0024855","id":"102030302","carrierId":"A0027","lx":1,"ly":5,"lz":3},{"gPNo":"S0024855","id":"102030502","carrierId":"A0051","lx":1,"ly":5,"lz":5},{"gPNo":"S0024855","id":"101020201","carrierId":"A0007","lx":4,"ly":4,"lz":2},{"gPNo":"S0024855","id":"101030301","carrierId":"A0019","lx":4,"ly":5,"lz":3},{"gPNo":"S0024855","id":"101010501","carrierId":"A0043","lx":4,"ly":3,"lz":5},{"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"gPNo":"S0024855","id":"102020401","carrierId":"A0033","lx":2,"ly":4,"lz":4},{"gPNo":"","id":"101010104","carrierId":"A0003","lx":7,"ly":3,"lz":1},{"gPNo":"S0024855","id":"101020204","carrierId":"A0014","lx":7,"ly":4,"lz":2},{"gPNo":"S0024855","id":"101030304","carrierId":"A0030","lx":7,"ly":5,"lz":3},{"gPNo":"S0024855","id":"101010504","carrierId":"A0046","lx":7,"ly":3,"lz":5},{"gPNo":"S0024855","id":"101020103","carrierId":"A0005","lx":6,"ly":4,"lz":1},{"gPNo":"","id":"101010303","carrierId":"A0021","lx":6,"ly":3,"lz":3},{"gPNo":"S0024855","id":"101020403","carrierId":"A0037","lx":6,"ly":4,"lz":4},{"gPNo":"S0024855","id":"101030503","carrierId":"A0053","lx":6,"ly":5,"lz":5},{"gPNo":"S0024855","id":"101020202","carrierId":"A0012","lx":5,"ly":4,"lz":2},{"gPNo":"S0024855","id":"101030302","carrierId":"A0028","lx":5,"ly":5,"lz":3},{"gPNo":"S0024855","id":"101010502","carrierId":"A0044","lx":5,"ly":3,"lz":5},{"gPNo":"S0024855","id":"102020202","carrierId":"A0011","lx":1,"ly":4,"lz":2},{"gPNo":"S0024855","id":"102020402","carrierId":"A0035","lx":1,"ly":4,"lz":4},{"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"gPNo":"S0024855","id":"101030201","carrierId":"A0008","lx":4,"ly":5,"lz":2},{"gPNo":"","id":"101010401","carrierId":"","lx":4,"ly":3,"lz":4},{"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4}]

動作
複製連結
 #3

是由 鼎 秦 於 約 1 年 前更新 · 已被編輯

!clipboard-202405031107-qyjcs.png!

動作
複製連結
 #4

是由 家慶 潘 於 約 1 年 前更新 · 已被編輯

WCS
Git Commit: 01bc7ceb02b74ffeec95604e998b82087c290acf [01bc7ce]

多加deep欄位及deep排序選項

動作
複製連結
 #5

是由 冠榮 林 於 約 1 年 前更新 · 已被編輯

!clipboard-202405071610-8mvif.png!

依今日討論結論:
WCS 支援 totalElements(總數量) 和 totalPages(總共幾頁)
謝謝

動作
複製連結
 #6

是由 冠榮 林 於 約 1 年 前更新 · 已被編輯

!clipboard-202405071623-avaqt.png!
目前前端支援4種過濾條件, 麻煩 WCS 也支援
母棧編號: 用 WHERE carrierId LIKE xxx 支援部分比對
子棧編號: 用 WHERE gPNo LIKE xxx 支援部分比對
儲位編號: 用 WHERE id LIKE xxx 支援部分比對
是否空儲位: WHERE carrierId is null 判斷是否空儲位

如果後端帶兩個以上的篩選條件，記得 where 要用 and 連起來喔
（只有一個篩選條件則不用 and）

動作
複製連結
 #7

是由 家慶 潘 於 約 1 年 前更新 · 已被編輯

  • 被分派者 從 家慶 潘 變更為 鼎 秦

Git Commit: c818ad65fcc2736b50c754a61c713011211e7393 [c818ad6]

@林冠榮 @秦鼎 @Arder

  1. 改成此格式{
    "content": [],
    "totalPages": 0,
    "totalElements": 0
    }

2.加入id,gPNo,carrierId,isCarrierIdNull 條件參數
id,gPNo,carrierId為字串型態
isCarrierIdNull為Bool型態

備註:
1.條件規則及順序
allStallCarrierObjs.filter {
if (isCarrierIdNull) {
it.carrierId.isEmpty()
} else {
true
}
}.filter {
if (id.isEmpty()) {
true
} else {
it.id.contains(id)
}
}.filter {
if (gPNo.isEmpty()) {
true
} else {
it.gPNo.contains(gPNo)
}
}.filter {
if (carrierId.isEmpty()) {
true
} else {
it.carrierId.contains(carrierId)
}
}.forEach {
stallCarrierObjs += it
}

2.有帶條件page參數帶1避免有資料但分頁切錯無法呈現資料
3.有帶條件totalElements為過濾後筆數,totalPages 為 totalElements/size

API 使用範例1
http://localhost:19090/db/data/StallDevices?properties=carrierId&direction=DESC&carrierId=A003&page=1
取A003x母棧板
{"totalPages":1,"content":[{"deep":2,"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101020403","carrierId":"A0037","lx":6,"ly":4,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101020402","carrierId":"A0036","lx":5,"ly":4,"lz":4},{"deep":2,"gPNo":"S0024855","id":"102020402","carrierId":"A0035","lx":1,"ly":4,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101010403","carrierId":"A0033","lx":6,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010402","carrierId":"A0032","lx":5,"ly":3,"lz":4},{"deep":1,"gPNo":"S0024855","id":"101010401","carrierId":"A0031","lx":4,"ly":3,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030304","carrierId":"A0030","lx":7,"ly":5,"lz":3}],"totalElements":10}

範例2
http://localhost:19090/db/data/StallDevices?properties=carrierId&direction=DESC&isCarrierIdNull=true
取得空儲位
{"totalPages":1,"content":[{"deep":1,"gPNo":"","id":"101020101","carrierId":"","lx":4,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"101020301","carrierId":"","lx":4,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"101030401","carrierId":"","lx":4,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"deep":2,"gPNo":"","id":"102020102","carrierId":"","lx":1,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020201","carrierId":"","lx":4,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"101030301","carrierId":"","lx":4,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"102020401","carrierId":"","lx":2,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"deep":1,"gPNo":"","id":"101030201","carrierId":"","lx":4,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4}],"totalElements":20}

範例3
http://localhost:19090/db/data/StallDevices
取得全部資訊
{"totalPages":1,"content":[{"deep":4,"gPNo":"S0024855","id":"101030204","carrierId":"A0018","lx":7,"ly":5,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101020504","carrierId":"A0050","lx":7,"ly":4,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101010203","carrierId":"A0009","lx":6,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101020303","carrierId":"A0025","lx":6,"ly":4,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101030403","carrierId":"A0041","lx":6,"ly":5,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010102","carrierId":"A0001","lx":5,"ly":3,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101030202","carrierId":"A0016","lx":5,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101010402","carrierId":"A0032","lx":5,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101020502","carrierId":"A0048","lx":5,"ly":4,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102030202","carrierId":"A0015","lx":1,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"101020101","carrierId":"","lx":4,"ly":4,"lz":1},{"deep":1,"gPNo":"S0024855","id":"101010301","carrierId":"A0019","lx":4,"ly":3,"lz":3},{"deep":1,"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"deep":4,"gPNo":"S0024855","id":"101020104","carrierId":"A0006","lx":7,"ly":4,"lz":1},{"deep":4,"gPNo":"S0024855","id":"101010304","carrierId":"A0022","lx":7,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030504","carrierId":"A0054","lx":7,"ly":5,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101020203","carrierId":"A0013","lx":6,"ly":4,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101030303","carrierId":"A0029","lx":6,"ly":5,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101010503","carrierId":"A0045","lx":6,"ly":3,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101020102","carrierId":"A0004","lx":5,"ly":4,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101010302","carrierId":"A0020","lx":5,"ly":3,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101020402","carrierId":"A0036","lx":5,"ly":4,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101030502","carrierId":"A0052","lx":5,"ly":5,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102020302","carrierId":"A0023","lx":1,"ly":4,"lz":3},{"deep":2,"gPNo":"S0024855","id":"102020502","carrierId":"A0047","lx":1,"ly":4,"lz":5},{"deep":1,"gPNo":"S0024855","id":"101010201","carrierId":"A0007","lx":4,"ly":3,"lz":2},{"deep":1,"gPNo":"","id":"101020301","carrierId":"","lx":4,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"101030401","carrierId":"","lx":4,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"deep":4,"gPNo":"S0024855","id":"101010204","carrierId":"A0010","lx":7,"ly":3,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101020304","carrierId":"A0026","lx":7,"ly":4,"lz":3},{"deep":4,"gPNo":"S0024852","id":"101030404","carrierId":"A0042","lx":7,"ly":5,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101010103","carrierId":"A0002","lx":6,"ly":3,"lz":1},{"deep":3,"gPNo":"S0024855","id":"101030203","carrierId":"A0017","lx":6,"ly":5,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101010403","carrierId":"A0033","lx":6,"ly":3,"lz":4},{"deep":3,"gPNo":"S0024851","id":"101020503","carrierId":"A0049","lx":6,"ly":4,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101010202","carrierId":"A0008","lx":5,"ly":3,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101020302","carrierId":"A0024","lx":5,"ly":4,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101030402","carrierId":"A0040","lx":5,"ly":5,"lz":4},{"deep":2,"gPNo":"","id":"102020102","carrierId":"","lx":1,"ly":4,"lz":1},{"deep":2,"gPNo":"S0024855","id":"102030302","carrierId":"A0027","lx":1,"ly":5,"lz":3},{"deep":2,"gPNo":"S0024855","id":"102030502","carrierId":"A0051","lx":1,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"101020201","carrierId":"","lx":4,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"101030301","carrierId":"","lx":4,"ly":5,"lz":3},{"deep":1,"gPNo":"S0024855","id":"101010501","carrierId":"A0043","lx":4,"ly":3,"lz":5},{"deep":1,"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"102020401","carrierId":"","lx":2,"ly":4,"lz":4},{"deep":4,"gPNo":"","id":"101010104","carrierId":"A0003","lx":7,"ly":3,"lz":1},{"deep":4,"gPNo":"S0024855","id":"101020204","carrierId":"A0014","lx":7,"ly":4,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101030304","carrierId":"A0030","lx":7,"ly":5,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101010504","carrierId":"A0046","lx":7,"ly":3,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101020103","carrierId":"A0005","lx":6,"ly":4,"lz":1},{"deep":3,"gPNo":"","id":"101010303","carrierId":"A0021","lx":6,"ly":3,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101020403","carrierId":"A0037","lx":6,"ly":4,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101030503","carrierId":"A0053","lx":6,"ly":5,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101020202","carrierId":"A0012","lx":5,"ly":4,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101030302","carrierId":"A0028","lx":5,"ly":5,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101010502","carrierId":"A0044","lx":5,"ly":3,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102020202","carrierId":"A0011","lx":1,"ly":4,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102020402","carrierId":"A0035","lx":1,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"deep":1,"gPNo":"","id":"101030201","carrierId":"","lx":4,"ly":5,"lz":2},{"deep":1,"gPNo":"S0024855","id":"101010401","carrierId":"A0031","lx":4,"ly":3,"lz":4},{"deep":1,"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4}],"totalElements":74}

動作
複製連結
 #8

是由 鼎 秦 於 約 1 年 前更新 · 已被編輯

!clipboard-202405081008-jv6s9.png!

動作
複製連結
 #9

是由 冠榮 林 於 約 1 年 前更新 · 已被編輯

  • 被分派者 從 冠榮 林 變更為 家慶 潘

isCarrierIdNull 的規則:
isCarrierIdNull 沒帶 -> 不過濾, 全回
isCarrierIdNull == 0 -> 回母棧編號非空的
isCarrierIdNull == 1 -> 回母棧編號是空的

動作
複製連結
 #10

是由 家慶 潘 於 約 1 年 前更新 · 已被編輯

  • 被分派者 從 家慶 潘 變更為 冠榮 林
  • 預估工時 從 8:00 小時 變更為 2:00 小時

Git Commit: d374e30a2858fc061ece10d2aa0b13c5ab568f08 [d374e30]

isCarrierIdNull 的規則:
isCarrierIdNull 沒帶 -> 不過濾, 全回
isCarrierIdNull == 0 -> 回母棧編號非空的
isCarrierIdNull == 1 -> 回母棧編號是空的

http://localhost:19090/db/data/StallDevices?properties=gPNo
{"totalPages":1,"content":[{"deep":1,"gPNo":"","id":"101020101","carrierId":"","lx":4,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"101020301","carrierId":"","lx":4,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"101030401","carrierId":"","lx":4,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"deep":2,"gPNo":"","id":"102020102","carrierId":"","lx":1,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020201","carrierId":"","lx":4,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"101030301","carrierId":"","lx":4,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"102020401","carrierId":"","lx":2,"ly":4,"lz":4},{"deep":4,"gPNo":"","id":"101010104","carrierId":"A0003","lx":7,"ly":3,"lz":1},{"deep":3,"gPNo":"","id":"101010303","carrierId":"A0021","lx":6,"ly":3,"lz":3},{"deep":1,"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"deep":1,"gPNo":"","id":"101030201","carrierId":"","lx":4,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4},{"deep":4,"gPNo":"S0024811","id":"101010204","carrierId":"A0010","lx":7,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024851","id":"101020503","carrierId":"A0049","lx":6,"ly":4,"lz":5},{"deep":4,"gPNo":"S0024852","id":"101030404","carrierId":"A0042","lx":7,"ly":5,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030204","carrierId":"A0018","lx":7,"ly":5,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101020504","carrierId":"A0050","lx":7,"ly":4,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101010203","carrierId":"A0009","lx":6,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101020303","carrierId":"A0025","lx":6,"ly":4,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101030403","carrierId":"A0041","lx":6,"ly":5,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010102","carrierId":"A0001","lx":5,"ly":3,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101030202","carrierId":"A0016","lx":5,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101010402","carrierId":"A0032","lx":5,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101020502","carrierId":"A0048","lx":5,"ly":4,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102030202","carrierId":"A0015","lx":1,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"deep":1,"gPNo":"S0024855","id":"101010301","carrierId":"A0019","lx":4,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020104","carrierId":"A0006","lx":7,"ly":4,"lz":1},{"deep":4,"gPNo":"S0024855","id":"101010304","carrierId":"A0022","lx":7,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030504","carrierId":"A0054","lx":7,"ly":5,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101020203","carrierId":"A0013","lx":6,"ly":4,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101030303","carrierId":"A0029","lx":6,"ly":5,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101010503","carrierId":"A0045","lx":6,"ly":3,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101020102","carrierId":"A0004","lx":5,"ly":4,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101010302","carrierId":"A0020","lx":5,"ly":3,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101020402","carrierId":"A0036","lx":5,"ly":4,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101030502","carrierId":"A0052","lx":5,"ly":5,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102020302","carrierId":"A0023","lx":1,"ly":4,"lz":3},{"deep":2,"gPNo":"S0024855","id":"102020502","carrierId":"A0047","lx":1,"ly":4,"lz":5},{"deep":1,"gPNo":"S0024855","id":"101010201","carrierId":"A0007","lx":4,"ly":3,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101020304","carrierId":"A0026","lx":7,"ly":4,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101010103","carrierId":"A0002","lx":6,"ly":3,"lz":1},{"deep":3,"gPNo":"S0024855","id":"101030203","carrierId":"A0017","lx":6,"ly":5,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101010403","carrierId":"A0033","lx":6,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010202","carrierId":"A0008","lx":5,"ly":3,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101020302","carrierId":"A0024","lx":5,"ly":4,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101030402","carrierId":"A0040","lx":5,"ly":5,"lz":4},{"deep":2,"gPNo":"S0024855","id":"102030302","carrierId":"A0027","lx":1,"ly":5,"lz":3},{"deep":2,"gPNo":"S0024855","id":"102030502","carrierId":"A0051","lx":1,"ly":5,"lz":5},{"deep":1,"gPNo":"S0024855","id":"101010501","carrierId":"A0043","lx":4,"ly":3,"lz":5},{"deep":4,"gPNo":"S0024855","id":"101020204","carrierId":"A0014","lx":7,"ly":4,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101030304","carrierId":"A0030","lx":7,"ly":5,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101010504","carrierId":"A0046","lx":7,"ly":3,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101020103","carrierId":"A0005","lx":6,"ly":4,"lz":1},{"deep":3,"gPNo":"S0024855","id":"101020403","carrierId":"A0037","lx":6,"ly":4,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101030503","carrierId":"A0053","lx":6,"ly":5,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101020202","carrierId":"A0012","lx":5,"ly":4,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101030302","carrierId":"A0028","lx":5,"ly":5,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101010502","carrierId":"A0044","lx":5,"ly":3,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102020202","carrierId":"A0011","lx":1,"ly":4,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102020402","carrierId":"A0035","lx":1,"ly":4,"lz":4},{"deep":1,"gPNo":"S0024855","id":"101010401","carrierId":"A0031","lx":4,"ly":3,"lz":4}],"totalElements":74}

http://localhost:19090/db/data/StallDevices?properties=gPNo&isCarrierIdNull=true
{"totalPages":1,"content":[{"deep":1,"gPNo":"","id":"101020101","carrierId":"","lx":4,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"101020301","carrierId":"","lx":4,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"101030401","carrierId":"","lx":4,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"deep":2,"gPNo":"","id":"102020102","carrierId":"","lx":1,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020201","carrierId":"","lx":4,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"101030301","carrierId":"","lx":4,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"102020401","carrierId":"","lx":2,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"deep":1,"gPNo":"","id":"101030201","carrierId":"","lx":4,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4}],"totalElements":20}

http://localhost:19090/db/data/StallDevices?properties=gPNo&isCarrierIdNull=false
{"totalPages":1,"content":[{"deep":4,"gPNo":"","id":"101010104","carrierId":"A0003","lx":7,"ly":3,"lz":1},{"deep":3,"gPNo":"","id":"101010303","carrierId":"A0021","lx":6,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024811","id":"101010204","carrierId":"A0010","lx":7,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024851","id":"101020503","carrierId":"A0049","lx":6,"ly":4,"lz":5},{"deep":4,"gPNo":"S0024852","id":"101030404","carrierId":"A0042","lx":7,"ly":5,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030204","carrierId":"A0018","lx":7,"ly":5,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101020504","carrierId":"A0050","lx":7,"ly":4,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101010203","carrierId":"A0009","lx":6,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101020303","carrierId":"A0025","lx":6,"ly":4,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101030403","carrierId":"A0041","lx":6,"ly":5,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010102","carrierId":"A0001","lx":5,"ly":3,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101030202","carrierId":"A0016","lx":5,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101010402","carrierId":"A0032","lx":5,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101020502","carrierId":"A0048","lx":5,"ly":4,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102030202","carrierId":"A0015","lx":1,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"deep":1,"gPNo":"S0024855","id":"101010301","carrierId":"A0019","lx":4,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020104","carrierId":"A0006","lx":7,"ly":4,"lz":1},{"deep":4,"gPNo":"S0024855","id":"101010304","carrierId":"A0022","lx":7,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030504","carrierId":"A0054","lx":7,"

動作
複製連結
 #11

是由 冠榮 林 於 約 1 年 前更新 · 已被編輯

  • 狀態 從 新提問 變更為 問題結案
動作
複製連結

匯出至 Atom PDF