Index: AXimpl/PM/SchaduwPrijs/SchaduwPrijs.cls.xml
===================================================================
diff -u
--- AXimpl/PM/SchaduwPrijs/SchaduwPrijs.cls.xml	(revision 0)
+++ AXimpl/PM/SchaduwPrijs/SchaduwPrijs.cls.xml	(revision 55345)
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="AXimpl.PM.SchaduwPrijs.SchaduwPrijs">
+<ClassType>persistent</ClassType>
+<Super>TECH.Persistent</Super>
+
+<Property name="ProductID">
+<Type>%String</Type>
+</Property>
+
+<Property name="AdminProduct">
+<Type>Prod.Product</Type>
+</Property>
+
+<Property name="CostPrice">
+<Type>%Decimal</Type>
+</Property>
+
+<Property name="UnitPrice">
+<Type>%Decimal</Type>
+</Property>
+
+<Index name="PrimaryKey">
+<IdKey>1</IdKey>
+<PrimaryKey>1</PrimaryKey>
+<Properties>ProductID</Properties>
+<Unique>1</Unique>
+</Index>
+
+<Storage name="Default">
+<Type>%Library.CacheStorage</Type>
+<DataLocation>^AXimpl.PM.Sch64E5.SchaduwPrijsD</DataLocation>
+<DefaultData>SchaduwPrijsDefaultData</DefaultData>
+<IdLocation>^AXimpl.PM.Sch64E5.SchaduwPrijsD</IdLocation>
+<IndexLocation>^AXimpl.PM.Sch64E5.SchaduwPrijsI</IndexLocation>
+<StreamLocation>^AXimpl.PM.Sch64E5.SchaduwPrijsS</StreamLocation>
+<Data name="SchaduwPrijsDefaultData">
+<Structure>listnode</Structure>
+<Subscript/>
+<Value name="1">
+<Value>%%CLASSNAME</Value>
+</Value>
+<Value name="2">
+<Value>AdminProduct</Value>
+</Value>
+<Value name="3">
+<Value>CostPrice</Value>
+</Value>
+<Value name="4">
+<Value>UnitPrice</Value>
+</Value>
+</Data>
+</Storage>
+</Class>
+
+
+</Export>
Index: AXimpl/PM/SchaduwPrijs/CalculateAll.cls.xml
===================================================================
diff -u
--- AXimpl/PM/SchaduwPrijs/CalculateAll.cls.xml	(revision 0)
+++ AXimpl/PM/SchaduwPrijs/CalculateAll.cls.xml	(revision 55345)
@@ -0,0 +1,103 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="AXimpl.PM.SchaduwPrijs.CalculateAll">
+<Super>TECH.RegisteredObject</Super>
+
+<Property name="Translator">
+<Type>AX.Uitgaand.EC.DataAX.impl.Translator</Type>
+</Property>
+
+<Property name="Converter">
+<Type>AXimpl.Controle.Order.Ax.AxOrderLijnConverter</Type>
+<Private>1</Private>
+</Property>
+
+<Property name="itProduct">
+<Type>TECH.Iterator</Type>
+<Private>1</Private>
+</Property>
+
+<Property name="SqlQueryConnection">
+<Type>AXimpl.SqlQueryConnection</Type>
+<Private>1</Private>
+</Property>
+
+<Property name="AddOnly">
+<Type>%Boolean</Type>
+<InitialExpression>1</InitialExpression>
+</Property>
+
+<Method name="VerwijderAlles">
+<Description>
+D ##class(AXimpl.PM.SchaduwPrijs.CalculateAll).%New().Verwerk()
+D ##class(AXimpl.PM.SchaduwPrijs.CalculateAll).VerwijderAlles()</Description>
+<ClassMethod>1</ClassMethod>
+<Implementation><![CDATA[	Do ##class(SchaduwPrijs).%KillExtent()
+]]></Implementation>
+</Method>
+
+<Method name="%OnNew">
+<ReturnType>%Status</ReturnType>
+<Implementation><![CDATA[
+	Set ..Translator=##class(AX.Uitgaand.EC.DataAX.impl.Translator).%New()
+	Quit $$$OK
+]]></Implementation>
+</Method>
+
+<Method name="Verwerk">
+<Implementation><![CDATA[
+	Set ..itProduct=##class(AXProductIterator).%New()
+	#dim lbProductIDs as %List
+	#dim ProductID as %String
+	#dim RecID as %String
+	#dim PRNr as %String
+	#dim GenTyp as %String
+	Set Count=1
+	While ..itProduct.HasNext() 
+	{
+		Set lbProductIDs=..itProduct.Next()
+		Set ProductID=$LI(lbProductIDs,1)
+		Set PRNr=$LI(lbProductIDs,2)
+		Set RecID=$LI(lbProductIDs,3)
+		Do ..ConverteerOne(ProductID,PRNr)
+		Set Count=Count+1
+		Write:Count#100=0 !,Count
+	}
+]]></Implementation>
+</Method>
+
+<Method name="ConverteerOne">
+<FormalSpec>ProductID:%String,PRNr:%String,RecID:%String</FormalSpec>
+<Implementation><![CDATA[
+	If ..AddOnly&&('##class(SchaduwPrijs).%ExistsId(ProductID))
+	{
+		Do ##class(SchaduwPrijs).%DeleteId(ProductID)
+		Do ..Add(ProductID,PRNr)				
+	}
+]]></Implementation>
+</Method>
+
+<Method name="Add">
+<FormalSpec>ProductID:%String,PRNr:%String</FormalSpec>
+<Implementation><![CDATA[
+	If 'PRNr,ProductID'[":" ; Alleen Identnr zonder configuratie
+	{ 
+		Set PRNr=..Translator.GeefPRNrForAdmin(ProductID)
+	}
+	
+	If PRNr
+	{
+		Set Q="K", D="\",U=";"
+		Set SchaduwPrijs=##class(SchaduwPrijs).%New()
+		Set SchaduwPrijs.ProductID=ProductID
+		Do SchaduwPrijs.AdminProductSetObjectId(PRNr)
+		Set SchaduwPrijs.CostPrice=$$CifPPL^KPRIJS(PRNr,"S")*100
+		Set SchaduwPrijs.UnitPrice=100
+		Do SchaduwPrijs.Save()
+	}
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>
Index: AXimpl/PM/SchaduwPrijs/AXProductIterator.cls.xml
===================================================================
diff -u
--- AXimpl/PM/SchaduwPrijs/AXProductIterator.cls.xml	(revision 0)
+++ AXimpl/PM/SchaduwPrijs/AXProductIterator.cls.xml	(revision 55345)
@@ -0,0 +1,95 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="AXimpl.PM.SchaduwPrijs.AXProductIterator">
+<Super>TECH.RegisteredObject,TECH.Iterator</Super>
+
+<Property name="Converter">
+<Type>AXimpl.Controle.Order.Ax.AxOrderLijnConverter</Type>
+<Private>1</Private>
+</Property>
+
+<Property name="ResultSet">
+<Type>TECH.ResultSet</Type>
+<Private>1</Private>
+</Property>
+
+<Property name="SqlQueryConnection">
+<Type>AXimpl.SqlQueryConnection</Type>
+<Private>1</Private>
+</Property>
+
+<Method name="%OnNew">
+<FormalSpec>SqlQueryConnection:AXimpl.SqlQueryConnection</FormalSpec>
+<Private>1</Private>
+<ProcedureBlock>1</ProcedureBlock>
+<ReturnType>%Status</ReturnType>
+<ServerOnly>1</ServerOnly>
+<Implementation><![CDATA[
+	Set ..SqlQueryConnection = $$$Implementation(SqlQueryConnection,##class(AXimpl.SqlQueryConnection).%New())
+	Do ..VoerUitQuery()
+	Set ..Converter = ##class(AXimpl.Controle.Order.Ax.AxOrderLijnConverter).%New()
+	Quit $$$OK
+]]></Implementation>
+</Method>
+
+<Method name="VoerUitQuery">
+<Private>1</Private>
+<Implementation><![CDATA[
+	#Dim SqlStatement as %String
+	
+	Set SqlStatement = "SELECT " ;top 10000"
+ 	_"  case isnull(ResProductMaster.ADUCALCTECHNOLOGYBOMBOL,0) WHEN 3 THEN sl.ITEMID WHEN 0 THEN sl.ITEMID ELSE ResProduct.DISPLAYPRODUCTNUMBER END as ProductID,"
+ 	_"  Kenmerk.RecID,"
+  	_"  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"
+ 	_" 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.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"
+ 	_" 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<>''"
+	_" where sl.Dataareaid='vhbe' "
+	_" and case isnull(ResProductMaster.ADUCALCTECHNOLOGYBOMBOL,0) WHEN 3 THEN 'KIND' WHEN 0 THEN 'BESLAG' ELSE 'MW' END <> 'BESLAG'"
+	
+	Set ..ResultSet = ..SqlQueryConnection.GetResultSet(SqlStatement)
+]]></Implementation>
+</Method>
+
+<Method name="HasNext">
+<ReturnType>%Boolean</ReturnType>
+<Implementation><![CDATA[	Quit (..ResultSet.Next() > 0)
+]]></Implementation>
+</Method>
+
+<Method name="Next">
+<ReturnType>%List</ReturnType>
+<Implementation><![CDATA[
+    /// Listbuild : QlikProductID, AdminPRNr, AXRecID
+ 	Quit $LB(..ResultSet.Data("ProductID"),..ResultSet.Data("AdminProductNummer"),..ResultSet.Data("RecID"))
+]]></Implementation>
+</Method>
+
+<Method name="%OnClose">
+<Private>1</Private>
+<ProcedureBlock>1</ProcedureBlock>
+<ReturnType>%Status</ReturnType>
+<ServerOnly>1</ServerOnly>
+<Implementation><![CDATA[
+	Do:$IsObject(..ResultSet) ..SqlQueryConnection.Disconnect()
+	Quit $$$OK
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>