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