Index: vhCARETAKER.mac.rou
===================================================================
diff -u -r62553 -r62600
--- vhCARETAKER.mac.rou (.../vhCARETAKER.mac.rou) (revision 62553)
+++ vhCARETAKER.mac.rou (.../vhCARETAKER.mac.rou) (revision 62600)
@@ -1216,12 +1216,21 @@
DiffAXVersusCacheOrders ; Verschillen tussen orders in AX en Cache opsporen
Try {
Do InitRuntimeContext
- Do ##class(AXimpl.Controle.OrdDiff.MaakDiff).%New().Maak()
+ Do ##class(AXimpl.Controle.OrdDiff.MaakDiff).%New(0).Maak()
} Catch {
Do OnError
}
Quit
-
+
+TAXArdisSelcoParser ; Ardis XML voor Selco inlezen en de prioriteit aanpassen in Ardis voor de andere werkstukken van diezelfde batch
+ Try {
+ Do InitRuntimeContext
+ Do ##class(APPS.Halux.Opvolging.ProductieStap.TAOR.impl.ArdisSelcoParser).%New().VerwerkAlle()
+ } Catch {
+ Do OnError
+ }
+ Quit
+
SyncGewichtenEnPrijzen ; Sync gewichten en prijzen per product naar DotNet databank
Try {
Do InitRuntimeContext
Index: EWPAL.mac.rou
===================================================================
diff -u -r61990 -r62600
--- EWPAL.mac.rou (.../EWPAL.mac.rou) (revision 61990)
+++ EWPAL.mac.rou (.../EWPAL.mac.rou) (revision 62600)
@@ -384,7 +384,7 @@
New MPRNr,CPPL,MPRNrs
Set Dir=$P("1\-1",D,$G(Dir)+1),Serie=$G(Serie),MPRNr=""
For Set MPRNr=$O(^PRLINK("IKM",KPRNr,MPRNr)) Quit:MPRNr="" Do
- .Set CPPL=$P($$PRIJSGEG^KPRIJS(MPRNr),D,6)
+ .Set CPPL=$$CifPPL^KPRIJS(MPRNr)
.Set CPPL(+CPPL,MPRNr)=""
Set (CPPL,MPRNrs)=""
If Serie Do
@@ -542,15 +542,15 @@
. Set $P(Rec,D,6)=$G(Result.Data("LocX"))
. Set $P(Rec,D,7)=$G(Result.Data("LocY"))
. Set $P(Rec,D,8,9)=D,R=$G(Result.Data("InvTime"))
- . Do:$L(R)
+ . Do:$L($TR(R," "))
. . Set $P(Rec,D,8)=$$INTDATE^vhLib.DataTypes($P(R,"-",1,3))
. . Set $P(Rec,D,9)=$$INTTIME^vhLib.DataTypes($P($P(R,"-",4),".",1,3))
. Set $P(Rec,D,10,11)=D,R=$G(Result.Data("LocTime"))
- . Do:$L(R)
+ . Do:$L($TR(R," "))
. . Set $P(Rec,D,10)=$$INTDATE^vhLib.DataTypes($P(R,"-",1,3))
. . Set $P(Rec,D,11)=$$INTTIME^vhLib.DataTypes($P($P(R,"-",4),".",1,3))
. Set R=$G(Result.Data("LastCCTime"))
- . Do:$L(R)
+ . Do:$L($TR(R," "))
. . Set $P(Rec,D,12)=$$INTDATE^vhLib.DataTypes($P(R,"-",1,3))
. . Set $P(Rec,D,13)=$$INTTIME^vhLib.DataTypes($P($P(R,"-",4),".",1,3))
. Set $P(Rec,D,14)=$G(Result.Data("AutoCCFlag"))
@@ -560,9 +560,12 @@
;De vertalling moet achteraf gebeuren omdat 2 geneste SQL queries niet werken over de SQL gateway
For I=1:1:Count Do
. Set Rec=^HULP(%J,I)
- . Set $P(Rec,D,16)=##class(EWMS.TransLoc).GetTransLocation(+$P(Rec,D,4),+$P(Rec,D,5),+$P(Rec,D,6),+$P(Rec,D,7))
- . If $P(Rec,D,16)="" Do ; geen transloc
- . . Set $P(Rec,D,16)=$E(100+$P(Rec,D,5),2,3)_" "_$E(100+$P(Rec,D,6),2,3)_" "_$E(100+$P(Rec,D,7),2,3)
+ . If ($P(Rec,D,4)=4) && ($P(Rec,D,5)=2) Do
+ . . Set $P(Rec,D,16)="HALUX"
+ . Else Do
+ . . Set $P(Rec,D,16)=##class(EWMS.TransLoc).GetTransLocation(+$P(Rec,D,4),+$P(Rec,D,5),+$P(Rec,D,6),+$P(Rec,D,7))
+ . . If $P(Rec,D,16)="" Do ; geen transloc
+ . . . Set $P(Rec,D,16)=$E(100+$P(Rec,D,5),2,3)_" "_$E(100+$P(Rec,D,6),2,3)_" "_$E(100+$P(Rec,D,7),2,3)
. Set ^HULP(%J,I)=Rec
Quit
Index: AXimpl/PM/Kenmerk/AXProductIterator.cls.xml
===================================================================
diff -u -r62525 -r62600
--- AXimpl/PM/Kenmerk/AXProductIterator.cls.xml (.../AXProductIterator.cls.xml) (revision 62525)
+++ AXimpl/PM/Kenmerk/AXProductIterator.cls.xml (.../AXProductIterator.cls.xml) (revision 62600)
@@ -42,28 +42,55 @@
_" case isnull(ResProductMaster.ADUCALCTECHNOLOGYBOMBOL,0) WHEN 3 THEN sl.ITEMID WHEN 0 THEN sl.ITEMID ELSE ResProduct.DISPLAYPRODUCTNUMBER END as ProductID,"
_" Kenmerk.RecID, "
_" sl.INVENTTRANSID as InventTransID, "
- _" case isnull(ResProductMaster.ADUCALCTECHNOLOGYBOMBOL,0) WHEN 3 THEN 'KIND' WHEN 0 THEN 'BESLAG' ELSE 'MW' END as ProductType, "
_" Inventtable.VHProductGroup as Familie,"
_" AdminProductNummer "
_" FROM SalesLine sl "
_" join InventTable "
_" on InventTable.ITEMID = sl.ITEMID and InventTable.DataAreaId = sl.DataAreaId and inventtable.PARTITION = sl.PARTITION "
_" join INVENTDIM dim "
_" on dim.DATAAREAID = sl.DATAAREAID and dim.INVENTDIMID = sl.INVENTDIMID and dim.Partition=sl.PARTITION "
- _" join INVENTDIM dimbase "
+ _" left outer join INVENTDIM dimbase "
_" on dimbase.DATAAREAID = dim.DATAAREAID and dimbase.Partition=dim.PARTITION "
_" and dim.ConfigID =dimbase.configid and dimbase.WMSLOCATIONID='' and dimbase.inventlocationid ='' and dimbase.inventsiteid='' "
_" and dimbase.inventbatchid=''"
- _" join INVENTDIMCOMBINATION as Idc"
+ _" left outer join INVENTDIMCOMBINATION as Idc"
_" on Idc.DATAAREAID= sl.DATAAREAID and Idc.ITEMID=sl.ITEMID and Idc.INVENTDIMID=DimBase.INVENTDIMID and idc.PARTITION = sl.PARTITION "
- _" join ECORESPRODUCT ResProduct"
+ _" left outer join ECORESPRODUCT ResProduct"
_" on idc.DISTINCTPRODUCTVARIANT= ResProduct.RecID and ResProduct.PARTITION = sl.PARTITION "
- _" join ECORESPRODUCT ResProductMaster"
+ _" left outer join ECORESPRODUCT ResProductMaster"
_" on ResProductMaster.RecID= ResProduct.ProductMaster and ResProduct.PARTITION = sl.PARTITION "
_" left outer join ADUEcoResAttributeCombination as Kenmerk "
_" on dim.ConfigId=Kenmerk.ConfigId and sl.ITEMID=Kenmerk.ITEMID and dim.ConfigId<>'' and kenmerk.Partition=sl.Partition "
_" where sl.Dataareaid='vhbe' and sl.Partition='5637144576' "
_" and ResProductMaster.ADUCALCTECHNOLOGYBOMBOL = 2"
+
+
+ Set SqlStatement = "select "
+ _" case isnull(ResProductMaster.ADUCALCTECHNOLOGYBOMBOL,0) WHEN 3 THEN sl.ITEMID WHEN 0 THEN sl.ITEMID ELSE case InventTable.STANDARDCONFIGID when dim.CONFIGID then InventTable.ITEMID else ResProduct.DISPLAYPRODUCTNUMBER end END as ProductID,"
+ _" sl.InventDimID,"
+ _" Inventtable.VHProductGroup as Familie, "
+ _" AdminProductNummer,"
+ _" sl.INVENTTRANSID as InventTransID"
+ _" FROM SalesLine sl"
+ _" join InventTable "
+ _" on InventTable.ITEMID = sl.ITEMID and InventTable.DataAreaId = sl.DataAreaId and inventtable.PARTITION = sl.PARTITION"
+ _" join INVENTDIM dim "
+ _" on dim.DATAAREAID = sl.DATAAREAID and dim.INVENTDIMID = sl.INVENTDIMID and dim.Partition=sl.PARTITION"
+ _" left outer join INVENTDIM dimbase "
+ _" on dimbase.DATAAREAID = dim.DATAAREAID and dimbase.Partition=dim.PARTITION and dim.ConfigID =dimbase.configid and dimbase.WMSLOCATIONID='' and dimbase.inventlocationid ='' and dimbase.inventsiteid='' and dimbase.inventbatchid='' and dimbase.inventsizeid='' and dimbase.recversion=dim.recversion"
+ _" left outer join INVENTDIMCOMBINATION as Idc "
+ _" on Idc.DATAAREAID= sl.DATAAREAID and Idc.ITEMID=sl.ITEMID and Idc.INVENTDIMID=DimBase.INVENTDIMID and idc.PARTITION = sl.PARTITION "
+ _" left outer join ECORESPRODUCT ResProduct "
+ _" on idc.DISTINCTPRODUCTVARIANT= ResProduct.RecID and ResProduct.PARTITION = sl.PARTITION "
+ _" left outer join ECORESPRODUCT ResProductMaster "
+ _" on ResProductMaster.RecID= isnull(ResProduct.ProductMaster,ResProduct.RecID) and ResProduct.PARTITION = sl.PARTITION "
+ _" left outer join ADUEcoResAttributeCombination as Kenmerk "
+ _" on dim.ConfigId=Kenmerk.ConfigId and sl.ITEMID=Kenmerk.ITEMID and dim.ConfigId<>'' and Kenmerk.PARTITION=sl.PARTITION "
+ _" where sl.Dataareaid='vhbe' "
+ _" and sl.Partition='5637144576' "
+ _" and isnull(ResProductMaster.ADUCALCTECHNOLOGYBOMBOL,0)=2 "
+
+
If VanafDatum
{
Set SqlStatement=SqlStatement_" and sl.CREATEDDATETIME >= '"_$zd(VanafDatum,3)_"'"
@@ -83,7 +110,7 @@
%List
Index: EWORDS6.mac.rou
===================================================================
diff -u -r58234 -r62600
--- EWORDS6.mac.rou (.../EWORDS6.mac.rou) (revision 58234)
+++ EWORDS6.mac.rou (.../EWORDS6.mac.rou) (revision 62600)
@@ -310,7 +310,8 @@
Set:SendWMSStatus="" SendWMSStatus=$E($P(^KKL(^KK1(KLNr),2),"\",8))
Set:SendWMSStatus'="M" SendWMSStatus="A"
}
- Quit SendWMSStatus
+ Set SendWMSStatus="A" ;TIJDELIJKE AANPASSING overbruggen van het manueel doorsturen, dus steeds automatisch- PV 02 10 2020
+ Quit SendWMSStatus
; Do orders moeten gesloten zijn
OrderGesloten(ORDNr)
Index: AX/Uitgaand/EC/DataAX/impl/HistoriekOphalen.cls.xml
===================================================================
diff -u -r61756 -r62600
--- AX/Uitgaand/EC/DataAX/impl/HistoriekOphalen.cls.xml (.../HistoriekOphalen.cls.xml) (revision 61756)
+++ AX/Uitgaand/EC/DataAX/impl/HistoriekOphalen.cls.xml (.../HistoriekOphalen.cls.xml) (revision 62600)
@@ -40,6 +40,11 @@
array
+
+WS.Vhisie4.KlantDocument.dto.HistoriekItem
+array
+
+
AX.Uitgaand.EC.DataAX.impl.Translator
1
@@ -66,8 +71,11 @@
Set:..GenerationId="" ..GenerationId=##class(AX.Uitgaand.EC.KlantenAX.impl.Klanten).LaatsteGenerationID()
Set ..ProductValidator=##class(AX.Uitgaand.EC.DataAX.impl.ProductValidator).%New(..KlantId,..GenerationId)
- Do ..GenereerLijst()
-
+ Do ..GenereerLijst(..KlantId)
+ Do:..KlantId=33895 ..GenereerLijst(19046) ; append oude klant ELISE BADMEUBELS - 16/09/2020 PV
+
+ Do ..SorteerProductGroepen()
+
Set ..Response.Tijd=Timer.Stop()\1
Quit $$$OK
@@ -88,21 +96,21 @@
+KlantId:%String
@@ -119,10 +127,45 @@
Set pxItem.Munt=$P(HistRec,"\",7)
Set pxItem.LaatsteDatum=$$INTDATE^vhLib.DataTypes($P(HistRec,"\",5))
Do pxItem.VulAanMetProduct(..Taal)
- Do ..ToevoegenAanGroep(pxItem)
+ Do ..Test(pxItem)
+ ;Do ..ToevoegenAanGroep(pxItem)
]]>
+
+pxItem:WS.Vhisie4.KlantDocument.dto.HistoriekItem
+
+
+
pxItem:WS.Vhisie4.KlantDocument.dto.HistoriekItem