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
+
+