Index: CSPimpl/Vhisie4/WinkelkarTotOrderVerwerker/OfferteService.cls.xml
===================================================================
diff -u
--- CSPimpl/Vhisie4/WinkelkarTotOrderVerwerker/OfferteService.cls.xml	(revision 0)
+++ CSPimpl/Vhisie4/WinkelkarTotOrderVerwerker/OfferteService.cls.xml	(revision 53345)
@@ -0,0 +1,56 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="CSPimpl.Vhisie4.WinkelkarTotOrderVerwerker.OfferteService">
+<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="GeefOfferteDatum">
+<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 ID, OrderID, ExterneId, BestelStatus, Bestelopmerking, AangemaaktOp, KlantID, WinkelkarId, WensLeverDatum FROM APPS_VKP_impl.Offerte Where AangemaaktOp %StartsWith ? order by ID DESC"
+
+	#dim ResultSet As TECH.ResultSet = ..QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement,$Lb(Datum)))
+
+	Set Offertes = ##class(%ListOfDataTypes).%New()
+
+	While ResultSet.Next() {
+		Do Offertes.Insert($listbuild(ResultSet.GetData(1),ResultSet.GetData(2),ResultSet.GetData(3),ResultSet.GetData(4),$Extract(ResultSet.GetData(5),1,50),ResultSet.GetData(6),ResultSet.GetData(7),ResultSet.GetData(8),ResultSet.GetData(9)))
+	}
+	
+	Quit ##class(TECH.ListIterator).%New(Offertes)
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>