40 lines
1.3 KiB
Plaintext
40 lines
1.3 KiB
Plaintext
|
컨베이어 라인 공정 시스템 개편
|
||
|
|
- 출하지시서 입력
|
||
|
|
- 작업 소요 시간 추가
|
||
|
|
- 제한 수량 변경
|
||
|
|
|
||
|
|
"SELECT un.ItemCode,un.ItemName,pk.ProdCount,ifnull(pd.FaceShot,-1),ifnull(pd.EyeShot ,-1),un.ProdCode FROM jomtTesterDB.jomtPKCodeTbl AS pk INNER JOIN (SELECT ItemCode,ProdCode,ItemName FROM jomtTesterDB.jomtProdList UNION SELECT ItemCode,ProdCode,ItemName FROM jomtTesterDB.jomtComponentTbl) AS un ON pk.ProdCode = un.ItemCode LEFT JOIN jomtTesterDB.jomtProdList AS pd ON pk.ProdCode = pd.ItemCode WHERE pk.PKCode = 'PK001-0270'"
|
||
|
|
|
||
|
|
"select it.code,it.name,io.expected_out_count,io.id from order_details od join items it on it.id = od.item_id join order_sheets os on os.id = od.order_sheet_id join item_outflows io on io.order_detail_id = od.id where os.code = 'ORD240821-0191' and od.deleted_at is null and io.state = 'registered';"
|
||
|
|
|
||
|
|
|
||
|
|
select it.code,it.name,io.expected_out_count,io.id from order_details od join items it on it.id = od.item_id join order_sheets os on os.id = od.order_sheet_id join item_outflows io on io.order_detail_id = od.id where os.code = 'ORD240821-0191' and od.deleted_at is null and io.state = 'registered';
|
||
|
|
|
||
|
|
|
||
|
|
gbInvoice
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
lbInv
|
||
|
|
|
||
|
|
txbInv
|
||
|
|
|
||
|
|
312312445190
|
||
|
|
|
||
|
|
ORD240821-0191
|
||
|
|
|
||
|
|
312406202122
|
||
|
|
312406198126
|
||
|
|
312406276129
|
||
|
|
312406374128
|
||
|
|
312406101124
|
||
|
|
312406751122
|
||
|
|
312406542127
|
||
|
|
312406966127
|
||
|
|
312406724127
|
||
|
|
|
||
|
|
312406016128
|
||
|
|
|
||
|
|
124029114145
|
||
|
|
|