Index: OBJTimpl/WMSOrder/dtoKlantEtiketRequest.cls.xml
===================================================================
diff -u -r67345 -r67356
--- OBJTimpl/WMSOrder/dtoKlantEtiketRequest.cls.xml (.../dtoKlantEtiketRequest.cls.xml) (revision 67345)
+++ OBJTimpl/WMSOrder/dtoKlantEtiketRequest.cls.xml (.../dtoKlantEtiketRequest.cls.xml) (revision 67356)
@@ -14,10 +14,6 @@
%String
-
-
-%String
-
Index: OBJTimpl/WMSOrder/OphalenUserIdPickerVanLPN.cls.xml
===================================================================
diff -u -r67350 -r67356
--- OBJTimpl/WMSOrder/OphalenUserIdPickerVanLPN.cls.xml (.../OphalenUserIdPickerVanLPN.cls.xml) (revision 67350)
+++ OBJTimpl/WMSOrder/OphalenUserIdPickerVanLPN.cls.xml (.../OphalenUserIdPickerVanLPN.cls.xml) (revision 67356)
@@ -44,36 +44,22 @@
Set res=##class(TECH.ResultSet).%New("%DynamicQueryGW:SQLGW")
#dim OBJTConnection as %SQLGatewayConnection =..GeefSQLConnectie()
- #dim Status as %String = ""
- ;#dim SqlStatement as %String = "Select OUTBOUNDSTATUS FROM [OBJT_OUTBOUNDORDER] WHERE ID=?"
+ #dim UserIdPicker as %String = ""
#dim SqlStatement as %String
- Set SqlStatement = "select task.DTSSTART, outboundOrder.id, task.oid, employee.UserID, csitq.name, op.name, itemqty.VALUE "
- _ "from OBJT_TASK task"
- _ "left join OBJT_PICKORDER pickorder"
- _ "on task.ORDEROID = pickorder.OID"
- _ "left join OBJT_ORDERLINK link"
- _ "on link.PARENTCLASSNAME = 'objt.wms.bo.outboundmgt.OutboundOrder'"
- _ "and link.CHILDOID = pickorder.oid"
- _ "left join OBJT_OUTBOUNDORDER outboundOrder"
- _ "on outboundOrder.oid = link.PARENTOID"
- _ "left join OBJT_EMPLOYEE employee"
- _ "on employee.oid = task.EMPLOYEEOID"
- _ "left join OBJT_CONTAINERSTORAGEITEMQTY csitq"
- _ "on csitq.oid = task.CONTAINERSTORAGEITEMQTYOID"
- _ "left join OBJT_OPERATIONLINK opLink"
- _ "on opLink.CHILDOID = task.REFOID"
- _ "and opLink.PARENTCLASSNAME = 'objt.wms.bo.outboundmgt.OutboundOperation'"
- _ "left join OBJT_OUTBOUNDOPERATION op"
- _ "on op.oid = opLink.PARENTOID"
-
- _ "left join OBJT_OUTBOUNDITEMQTY itemqty"
- _ "on itemqty.OUTBOUNDOPERATIONOID = op.oid"
-
- _ "where task.CATEGORY = 'PICK'"
- _ "and outboundOrder.id = ?"
- _ "and csitq.name = ?"
-
-
+ Set SqlStatement = "select task.DTSSTART, outboundOrder.id, task.oid, employee.UserID UserId, csitq.name, op.name, itemqty.VALUE "
+ _ " from OBJT_TASK task"
+ _ " left join OBJT_PICKORDER pickorder on task.ORDEROID = pickorder.OID"
+ _ " left join OBJT_ORDERLINK link on link.PARENTCLASSNAME = 'objt.wms.bo.outboundmgt.OutboundOrder' and link.CHILDOID = pickorder.oid"
+ _ " left join OBJT_OUTBOUNDORDER outboundOrder on outboundOrder.oid = link.PARENTOID"
+ _ " left join OBJT_EMPLOYEE employee on employee.oid = task.EMPLOYEEOID"
+ _ " left join OBJT_CONTAINERSTORAGEITEMQTY csitq on csitq.oid = task.CONTAINERSTORAGEITEMQTYOID"
+ _ " left join OBJT_OPERATIONLINK opLink on opLink.CHILDOID = task.REFOID and opLink.PARENTCLASSNAME = 'objt.wms.bo.outboundmgt.OutboundOperation'"
+ _ " left join OBJT_OUTBOUNDOPERATION op on op.oid = opLink.PARENTOID"
+ _ " left join OBJT_OUTBOUNDITEMQTY itemqty on itemqty.OUTBOUNDOPERATIONOID = op.oid"
+ _ " where task.CATEGORY = 'PICK'"
+ _ " and outboundOrder.id = ?"
+ _ " and csitq.name = ?"
+
try
{
Do res.Prepare(SqlStatement,,OBJTConnection)
@@ -84,70 +70,13 @@
}
If res.Next()
{
- Set Status=$G(res.Data("OUTBOUNDSTATUS"))
+ Set UserIdPicker=$G(res.Data("UserId"))
}
do OBJTConnection.Disconnect()
- Quit Status
+ Quit UserIdPicker
]]>
-
-
-CONSNr:%String
-%String
-
-
-
-
-CONSNr:%String
-
-
-
-
-1
-CONSNr:%String
-
-
Index: OBJTimpl/WMSOrder/PrintKlantEtiket.cls.xml
===================================================================
diff -u -r67348 -r67356
--- OBJTimpl/WMSOrder/PrintKlantEtiket.cls.xml (.../PrintKlantEtiket.cls.xml) (revision 67348)
+++ OBJTimpl/WMSOrder/PrintKlantEtiket.cls.xml (.../PrintKlantEtiket.cls.xml) (revision 67356)
@@ -5,16 +5,23 @@
OBJTimpl.WMSOrder.VertrekplaatsConverteerder
+1
+
+OBJTimpl.WMSOrder.OphalenUserIdPickerVanLPN
+1
+
+
-VertrekplaatsConverteerder:OBJTimpl.WMSOrder.VertrekplaatsConverteerder=""
+VertrekplaatsConverteerder:OBJTimpl.WMSOrder.VertrekplaatsConverteerder="",PickerUserIdOphaler:OBJTimpl.WMSOrder.OphalenUserIdPickerVanLPN
1
1
%Status
1
@@ -27,7 +34,6 @@
Set Req.Vertrekplaats="HAL1.1PICK"
Set Req.ConsNr="2203378576"
Set Req.LPN="D-0011155"
- Set Req.UserIdPicker = "JoW"
Do ..PrintKlantEtiket(Req)
]]>
@@ -37,7 +43,8 @@
%String