Index: CSPimpl/Leverdatums/SFSKalenderService.cls.xml
===================================================================
diff -u
--- CSPimpl/Leverdatums/SFSKalenderService.cls.xml	(revision 0)
+++ CSPimpl/Leverdatums/SFSKalenderService.cls.xml	(revision 54310)
@@ -0,0 +1,64 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="CSPimpl.Leverdatums.SFSKalenderService">
+<Super>TECH.RegisteredObject</Super>
+
+<Property name="QueryAPI">
+<Type>TECH.Query.QueryAPI</Type>
+<Private>1</Private>
+</Property>
+
+<Method name="%OnNew">
+<FormalSpec>QueryAPI:TECH.Query.QueryAPI=""</FormalSpec>
+<Private>1</Private>
+<ProcedureBlock>1</ProcedureBlock>
+<ReturnType>%Status</ReturnType>
+<ServerOnly>1</ServerOnly>
+<Implementation><![CDATA[
+	Set ..QueryAPI = $$$Implementation(QueryAPI,##class(TECH.Context).Instance().GeefQueryAPI())
+	
+	Quit $$$OK
+]]></Implementation>
+</Method>
+
+<Method name="GeefDatum">
+<ReturnType>%String</ReturnType>
+<Implementation><![CDATA[
+	#dim Context As TECH.Context = ##class(TECH.Context).Instance()
+	#dim HuidigeDatumTijd As TECH.Horolog = Context.GeefDateTimeAPI().CurrentHorolog()
+	#dim NieuwFormaatDatumTijd As %String = Context.GeefFormatAPI().FormatHorolog(HuidigeDatumTijd, "yyyy-mm-dd")
+	Quit NieuwFormaatDatumTijd
+]]></Implementation>
+</Method>
+
+<Method name="GeefLijnenIterator">
+<FormalSpec>Datum:%Date=""</FormalSpec>
+<ReturnType>TECH.Iterator</ReturnType>
+<Implementation><![CDATA[
+	Set:(Datum="") Datum = ##class(TECH.DateTime).%New().CurrentDateVoorQueries()
+
+	#dim SqlStatement As TECH.String = "SELECT OrderDate, ProductionDays, PickupDate, CAST(DeliveryDate As Date) As LeverDatum FROM APPS_EC_impl_LeverdatumBepaler_Data.SFSKalender where CAST(OrderDate As Date) >= CAST(? As Date) order by OrderDate ASC"
+
+	#dim ResultSet As TECH.ResultSet = ..QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement,$Lb(Datum)))
+
+	Set Leverdatums = ##class(%ListOfDataTypes).%New()
+
+	Set LeveringsTermijnFactory = ##class(APPS.VKP.impl.LeveringsTermijnFactory).%New()
+	Set DateTimeApi = ##class(TECH.Context).Instance().GeefDateTimeAPI()
+	Set VerzendWijze = ##class(APPS.VKP.VerzendWijze).%New(12486,"SFS")
+	
+	#dim LeveringTermijn As APPS.VKP.LeveringsTermijn = LeveringsTermijnFactory.MaakLeveringsTermijn(DateTimeApi.CurrentHorolog(), VerzendWijze, ##class(DOM.VKP.enu.Klant).SFS(), ##class(DOM.common.enu.Personality).VanHoecke())
+	
+	While ResultSet.Next() {
+		Set ProductieHorolog = LeveringTermijn.GetLaatsteProductieTijdstip(ResultSet.GetData(3))
+		Set ProductieDatum = ##class(TECH.DateTime).HorologToDate(ProductieHorolog)
+		Do Leverdatums.Insert($listbuild($ZD(ResultSet.GetData(1),3),ResultSet.GetData(2),$ZD(ResultSet.GetData(3),3),$ZD(ResultSet.GetData(4),3),$ZD(ProductieDatum,3)))
+	}
+	
+	Quit ##class(TECH.ListIterator).%New(Leverdatums)
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>