Index: APPS/MAG/Inventaris/dto/ProductOpPallet.cls.xml =================================================================== diff -u -r1924 -r1948 --- APPS/MAG/Inventaris/dto/ProductOpPallet.cls.xml (.../ProductOpPallet.cls.xml) (revision 1924) +++ APPS/MAG/Inventaris/dto/ProductOpPallet.cls.xml (.../ProductOpPallet.cls.xml) (revision 1948) @@ -13,6 +13,10 @@ %String + +%String + + %String Index: APPS/MAG/UGLYPicking/dto/ProductLijn.cls.xml =================================================================== diff -u -r1658 -r1948 --- APPS/MAG/UGLYPicking/dto/ProductLijn.cls.xml (.../ProductLijn.cls.xml) (revision 1658) +++ APPS/MAG/UGLYPicking/dto/ProductLijn.cls.xml (.../ProductLijn.cls.xml) (revision 1948) @@ -34,10 +34,6 @@ %String - -%String - - APPS.MAG.UGLYPicking.dto.ProductLijnProbleem list Index: APPS/MAG/Inventaris/dto/BijladenVanVerpakking.cls.xml =================================================================== diff -u --- APPS/MAG/Inventaris/dto/BijladenVanVerpakking.cls.xml (revision 0) +++ APPS/MAG/Inventaris/dto/BijladenVanVerpakking.cls.xml (revision 1948) @@ -0,0 +1,23 @@ + + + +1 +%RegisteredObject,%XML.Adaptor +0 + + +%Integer +0 + + + +%Integer +0 + + + +%Integer +0 + + + Index: CSC Ugly Picking.prj.xml =================================================================== diff -u -r1924 -r1948 --- CSC Ugly Picking.prj.xml (.../CSC Ugly Picking.prj.xml) (revision 1924) +++ CSC Ugly Picking.prj.xml (.../CSC Ugly Picking.prj.xml) (revision 1948) @@ -1,13 +1,16 @@ - + + + + @@ -61,6 +64,9 @@ + + + Index: WS/MAG/Inventaris/InventarisService.cls.xml =================================================================== diff -u -r1924 -r1948 --- WS/MAG/Inventaris/InventarisService.cls.xml (.../InventarisService.cls.xml) (revision 1924) +++ WS/MAG/Inventaris/InventarisService.cls.xml (.../InventarisService.cls.xml) (revision 1948) @@ -43,5 +43,27 @@ + + +PalletID:%String,DoelLocatieID:%String +1 + + + + +BronPalletID:%String,DoelPalletID:%String,ProductID:%String,AantalBijTeLaden:%Integer +APPS.MAG.Inventaris.dto.BijladenInfo +1 + + + + +BronPalletID:%String,DoelPalletID:%String,ProductID:%String,AantalBijTeLaden:%Integer +1 + + Index: APPS/MAG/InventarisService.cls.xml =================================================================== diff -u -r1924 -r1948 --- APPS/MAG/InventarisService.cls.xml (.../InventarisService.cls.xml) (revision 1924) +++ APPS/MAG/InventarisService.cls.xml (.../InventarisService.cls.xml) (revision 1948) @@ -5,6 +5,184 @@ %RegisteredObject 0 + +BronPalletID:%String,DoelPalletID:%String,ProductID:%String,AantalBijTeLaden:%Integer +APPS.MAG.Inventaris.dto.BijladenInfo + 0) + { + Set GrootVerpakking.AantalAanwezigOpDoel = ##class(TECH.Math).Floor(AantalOpDoelPallet/GrootVerpakking.AantalInVerpakking) + Set AantalOpDoelPallet = AantalOpDoelPallet#GrootVerpakking.AantalInVerpakking + Set GrootVerpakking.AantalBijladenVanBron = ##class(TECH.Math).Floor(AantalBijTeLaden/GrootVerpakking.AantalInVerpakking) + Set AantalBijTeLaden = AantalBijTeLaden#GrootVerpakking.AantalInVerpakking + } + Set BijladenInfo.GrootVerpakking = GrootVerpakking + + Set NormaalVerpakking = ##class(APPS.MAG.Inventaris.dto.BijladenVanVerpakking).%New() + Set NormaalVerpakking.AantalInVerpakking = Product.GeefAantalInNormaalVerpakking() + If (NormaalVerpakking.AantalInVerpakking > 0) + { + Set NormaalVerpakking.AantalAanwezigOpDoel = ##class(TECH.Math).Floor(AantalOpDoelPallet/NormaalVerpakking.AantalInVerpakking) + Set AantalOpDoelPallet = AantalOpDoelPallet#NormaalVerpakking.AantalInVerpakking + Set NormaalVerpakking.AantalBijladenVanBron = ##class(TECH.Math).Floor(AantalBijTeLaden/NormaalVerpakking.AantalInVerpakking) + Set AantalBijTeLaden = AantalBijTeLaden#NormaalVerpakking.AantalInVerpakking + } + Set BijladenInfo.NormaalVerpakking = NormaalVerpakking + + Set StukVerpakking = ##class(APPS.MAG.Inventaris.dto.BijladenVanVerpakking).%New() + Set StukVerpakking.AantalInVerpakking = 1 + Set StukVerpakking.AantalAanwezigOpDoel = AantalOpDoelPallet + Set StukVerpakking.AantalBijladenVanBron = AantalBijTeLaden + Set BijladenInfo.StukVerpakking = StukVerpakking + + Quit BijladenInfo +]]> + + + +BronPalletID:%String,DoelPalletID:%String,ProductID:%String,AantalBijTeLaden:%Integer + + + PalletID:%String APPS.MAG.Inventaris.dto.ProductenOpPallet @@ -14,18 +192,37 @@ Set ProductAPI = ##class(DOM.DomeinContext).Instance().GeefProductAPI() Set ResultSet = ##class(%ResultSet).%New() - Do ResultSet.Prepare("SELECT rtrim(product) as ProductID, CAST(qty_pcs AS INT) as Aantal, I.loc_m, L.loc_g, L.loc_x, L.loc_y, (SELECT count(1) FROM EWMS.Inventory WHERE loc_id = I.loc_id) as AantalSecties" - _" FROM EWMS.Inventory I JOIN EWMS.Locations L ON I.loc_m = L.loc_m and I.loc_id = L.loc_id WHERE I.loc_id = ? AND I.loc_m < 5") + //Do ResultSet.Prepare("SELECT rtrim(product) as ProductID, CAST(qty_pcs AS INT) as Aantal, I.loc_m, L.loc_g, L.loc_x, L.loc_y, (SELECT count(1) FROM EWMS.Inventory WHERE loc_id = I.loc_id) as AantalSecties" + // _" FROM EMWS.Inventory I JOIN EWMS.Locations L ON I.loc_m = L.loc_m and I.loc_id = L.loc_id WHERE I.loc_id = ? AND I.loc_m < 5 AND I.Product <> 'EMPTY'") + + If ('##class(EWMS.ToReceive).PalletIsInToReceive(PalletID)) + { + Do ResultSet.Prepare("SELECT rtrim(product) as ProductID, CAST(qty_pcs AS INT) as Aantal, I.loc_m, (SELECT count(1) FROM EWMS.Inventory WHERE loc_id = I.loc_id) as AantalSecties, T.Loc_Trans As LocatieID" + _" FROM EWMS.Inventory I" + _" JOIN EWMS.Locations L ON I.loc_m = L.loc_m and I.loc_id = L.loc_id" + _" LEFT JOIN EWMS.TransLoc T ON T.loc_m = L.loc_m AND T.loc_g = L.loc_g AND T.loc_x = L.loc_x AND T.loc_y = L.loc_y" + _" WHERE I.loc_id = ? AND I.loc_m < 5 AND I.Product <> 'EMPTY'") + } + Else + { + Do ResultSet.Prepare("SELECT rtrim(product) as ProductID, CAST(qtytoreceive AS INT) as Aantal, I.locm As loc_m, (SELECT count(1) FROM EWMS.ToReceive WHERE loc_id = I.locid) as AantalSecties, T.Loc_Trans As LocatieID" + _" FROM EWMS.ToReceive I" + _" LEFT JOIN EWMS.Locations L ON I.locm = L.loc_m and I.locid = L.loc_id" + _" LEFT JOIN EWMS.TransLoc T ON T.loc_m = L.loc_m AND T.loc_g = L.loc_g AND T.loc_x = L.loc_x AND T.loc_y = L.loc_y" + _" WHERE I.locid = ? AND I.locm < 5 AND I.Product <> 'EMPTY' AND I.QtyTransported = 0 AND I.QtyReceived > 0") + } Do ResultSet.Execute(PalletID) While (ResultSet.Next()) { Set ProductID = ResultSet.Data("ProductID") + Set Product = ProductAPI.GeefProduct(ProductID) Set ProductOpPallet = ##class(APPS.MAG.Inventaris.dto.ProductOpPallet).%New() Set ProductOpPallet.ProductID = ProductID Set ProductOpPallet.Aantal = ResultSet.Data("Aantal") Set ProductOpPallet.PalletID = PalletID - Set ProductOpPallet.LocatieID = ##class(BL.MB.UGLYPicking.General).GetTransLocStr(ResultSet.Data("loc_m"),ResultSet.Get("loc_g"),ResultSet.Get("loc_x"),ResultSet.Get("loc_y")) - Set ProductOpPallet.Korttekst = ProductAPI.GeefProduct(ProductID).GeefKorttekst() + Set ProductOpPallet.LocatieID = ResultSet.Data("LocatieID") + Set ProductOpPallet.Korttekst = Product.GeefKorttekst() + Set ProductOpPallet.Langtekst = Product.GeefLangtekst("N") Set ProductOpPallet.MagazijnOmschrijving = ##class(Prod.Product).GetMagViaOpslagzone(ResultSet.Data("loc_m")) Set ProductOpPallet.AantalSecties = ResultSet.Data("AantalSecties") Do ProductenOpPallet.Insert(ProductOpPallet) @@ -55,19 +252,22 @@ Set ProductAPI = ##class(DOM.DomeinContext).Instance().GeefProductAPI() Set ResultSet = ##class(%ResultSet).%New() - Do ResultSet.Prepare("SELECT CAST(qty_pcs AS INT) as Aantal, I.loc_id As PalletID, I.loc_m, L.loc_g, L.loc_x, L.loc_y, (SELECT count(1) FROM EWMS.Inventory WHERE loc_id = I.loc_id GROUP BY loc_id) as AantalSecties" + Do ResultSet.Prepare("SELECT CAST(qty_pcs AS INT) as Aantal, I.loc_id As PalletID, I.loc_m, (SELECT count(1) FROM EWMS.Inventory WHERE loc_id = I.loc_id GROUP BY loc_id) as AantalSecties, T.Loc_Trans As LocatieID" _" FROM EWMS.Inventory I" _" JOIN EWMS.Locations L ON I.loc_m = L.loc_m and I.loc_id = L.loc_id" + _" LEFT JOIN EWMS.TransLoc T ON T.loc_m = L.loc_m AND T.loc_g = L.loc_g AND T.loc_x = L.loc_x AND T.loc_y = L.loc_y" _" WHERE product = ? AND I.loc_m < 5") Do ResultSet.Execute(ProductID) While (ResultSet.Next()) { + Set Product = ProductAPI.GeefProduct(ProductID) Set ProductOpPallet = ##class(APPS.MAG.Inventaris.dto.ProductOpPallet).%New() Set ProductOpPallet.ProductID = ProductID Set ProductOpPallet.Aantal = ResultSet.Data("Aantal") Set ProductOpPallet.PalletID = ResultSet.Data("PalletID") - Set ProductOpPallet.LocatieID = ##class(BL.MB.UGLYPicking.General).GetTransLocStr(ResultSet.Data("loc_m"),ResultSet.Get("loc_g"),ResultSet.Get("loc_x"),ResultSet.Get("loc_y")) - Set ProductOpPallet.Korttekst = ProductAPI.GeefProduct(ProductID).GeefKorttekst() + Set ProductOpPallet.LocatieID = ResultSet.Data("LocatieID") + Set ProductOpPallet.Korttekst = Product.GeefKorttekst() + Set ProductOpPallet.Langtekst = Product.GeefLangtekst() Set ProductOpPallet.MagazijnOmschrijving = ##class(Prod.Product).GetMagViaOpslagzone(ResultSet.Data("loc_m")) Set ProductOpPallet.AantalSecties = ResultSet.Data("AantalSecties") Do ProductenOpPallet.Insert(ProductOpPallet) @@ -90,7 +290,6 @@ PalletID:%String,ProductID:%String APPS.MAG.Inventaris.dto.ProductReceptieDetail + +PalletID:%String,DoelLocatieID:%String + + + ProductID:%Integer 1 Index: APPS/MAG/UglyPickingService.cls.xml =================================================================== diff -u -r1797 -r1948 --- APPS/MAG/UglyPickingService.cls.xml (.../UglyPickingService.cls.xml) (revision 1797) +++ APPS/MAG/UglyPickingService.cls.xml (.../UglyPickingService.cls.xml) (revision 1948) @@ -73,24 +73,12 @@ ]]> - -Sessie:APPS.MAG.UGLYPicking.dto.Sessie -%Status - - - BonNr:%Integer,MagazijnID:APPS.MAG.UGLYPicking.enu.Magazijn - -ProductLijn:APPS.MAG.UGLYPicking.dto.ProductLijn -%Status - - - BonNr:%Integer,ProductLijn:APPS.MAG.UGLYPicking.dto.ProductLijn,NieuwReservatieAantal:%Integer - -Sessie:APPS.MAG.UGLYPicking.dto.Sessie -%Status - - BonNr:%Integer,MagazijnID:APPS.MAG.UGLYPicking.enu.Magazijn - -ProductLijn:APPS.MAG.UGLYPicking.dto.ProductLijn -%Status - - BonNr:%Integer,ProductLijn:APPS.MAG.UGLYPicking.dto.ProductLijn,NieuwReservatieAantal:%Integer - -%Status + + + + + + + + + + + + + + + + +%Status + + + + +%Status + + + + +s:%String +%Status + - + +s:%String %Status Index: DOM/PM/Product.cls.xml =================================================================== diff -u -r1921 -r1948 --- DOM/PM/Product.cls.xml (.../Product.cls.xml) (revision 1921) +++ DOM/PM/Product.cls.xml (.../Product.cls.xml) (revision 1948) @@ -104,5 +104,20 @@ 1 DOM.LEV.Leverancier + + +1 +%Integer + + + +1 +%Integer + + + +1 +%Integer + Index: DOM/PM/impl/ProductImpl.cls.xml =================================================================== diff -u -r1921 -r1948 --- DOM/PM/impl/ProductImpl.cls.xml (.../ProductImpl.cls.xml) (revision 1921) +++ DOM/PM/impl/ProductImpl.cls.xml (.../ProductImpl.cls.xml) (revision 1948) @@ -147,5 +147,23 @@ + + +%Integer + + + + +%Integer + + + + +%Integer + + Index: BL/MB/UGLYPicking/Opslag.cls.xml =================================================================== diff -u -r1074 -r1948 --- BL/MB/UGLYPicking/Opslag.cls.xml (.../Opslag.cls.xml) (revision 1074) +++ BL/MB/UGLYPicking/Opslag.cls.xml (.../Opslag.cls.xml) (revision 1948) @@ -246,7 +246,6 @@ Set SubLNr=RCPLNR#100*100+RCPLSPLITSNR $$$WriteToLog("CHECK ^RCP (OrderNr: "_OrderNr_", BonNr: "_BonNr_", LUNr: "_LUNr_", SubLNr: "_SubLNr_")") - Quit:('$D(^RCP("D",OrderNr,"D",BonNr,LUNr,SubLNr))) "Er is mogelijk een communicatieprobleem tussen WMS en ADMIN, probeer later eens opnieuw." $$$WriteToLog("VALUE: "_$G(^RCP("D",OrderNr,"D",BonNr,LUNr,SubLNr))) Index: APPS/MAG/Inventaris/dto/BijladenInfo.cls.xml =================================================================== diff -u --- APPS/MAG/Inventaris/dto/BijladenInfo.cls.xml (revision 0) +++ APPS/MAG/Inventaris/dto/BijladenInfo.cls.xml (revision 1948) @@ -0,0 +1,40 @@ + + + +1 +%RegisteredObject,%XML.Adaptor +0 + + +%Integer + + + +%String + + + +%String + + + +%String + + + +APPS.MAG.Inventaris.dto.BijladenVanVerpakking + + + +APPS.MAG.Inventaris.dto.BijladenVanVerpakking + + + +APPS.MAG.Inventaris.dto.BijladenVanVerpakking + + + +APPS.MAG.Inventaris.enu.BijladenDoelPalletStatus + + + Index: APPS/MAG/Inventaris/enu/BijladenDoelPalletStatus.cls.xml =================================================================== diff -u --- APPS/MAG/Inventaris/enu/BijladenDoelPalletStatus.cls.xml (revision 0) +++ APPS/MAG/Inventaris/enu/BijladenDoelPalletStatus.cls.xml (revision 1948) @@ -0,0 +1,34 @@ + + + +datatype +1 +%String +0 + + +,NieuwePalletEnSectie,NieuweSectieOpPallet,PalletEnSectieBestaat + + + +1 +APPS.MAG.Inventaris.enu.BijladenDoelPalletStatus + + + + +1 +APPS.MAG.Inventaris.enu.BijladenDoelPalletStatus + + + + +1 +APPS.MAG.Inventaris.enu.BijladenDoelPalletStatus + + + + Index: DOM/PM/impl/DataM/DataMProduct.cls.xml =================================================================== diff -u -r1921 -r1948 --- DOM/PM/impl/DataM/DataMProduct.cls.xml (.../DataMProduct.cls.xml) (revision 1921) +++ DOM/PM/impl/DataM/DataMProduct.cls.xml (.../DataMProduct.cls.xml) (revision 1948) @@ -365,5 +365,32 @@ + + +%Integer + + + + +%Integer + + + + +%Integer + +