Index: APPS/Halux/PPS/Document/impl/common/BatchNaarObjective/OptieGenerator/AantalRollenOptiesGenerator.cls.xml =================================================================== diff -u -r71932 -r74483 --- APPS/Halux/PPS/Document/impl/common/BatchNaarObjective/OptieGenerator/AantalRollenOptiesGenerator.cls.xml (.../AantalRollenOptiesGenerator.cls.xml) (revision 71932) +++ APPS/Halux/PPS/Document/impl/common/BatchNaarObjective/OptieGenerator/AantalRollenOptiesGenerator.cls.xml (.../AantalRollenOptiesGenerator.cls.xml) (revision 74483) @@ -107,7 +107,7 @@ While (HalffabItemsIterator.HasNext()) { #dim HalffabItem As DOM.PM.Maatwerk.Calc.HF.IHalffabItem = HalffabItemsIterator.Next() - If ..MagHalffabItemToegevoegdWorden(HalffabItem, NietMeeleverenLijst) { + If ..MagHalffabItemToegevoegdWorden(HalffabItem, NietMeeleverenLijst, IngegevenKenmerken.GeefVariant()) { #dim Naam As %String = ..GeefRolNaam(HalffabItem, IngegevenKenmerken) #dim Aantal As %String = ProductLijn.GeefAantal() * HalffabItem.GeefAantal() @@ -126,13 +126,20 @@ -HalffabItem:DOM.PM.Maatwerk.Calc.HF.IHalffabItem,NietMeeleverenLijst:%ListOfDataTypes +HalffabItem:DOM.PM.Maatwerk.Calc.HF.IHalffabItem,NietMeeleverenLijst:%ListOfDataTypes,Variant:%String %Boolean 1))) { If ($$$Not(HalffabItem.GeefAantal() = 0)) { @@ -154,6 +170,62 @@ Quit BackSteelIsFastMover ]]> + + +Variant:%String,LadeHoogte:%String,Kleur:%String,KlantID:%String +1 += '"_Datum_"' or GeldigTot is null) and (GeldigVan <= '"_Datum_"' or GeldigVan is null) and LadeKleur = '"_Kleur_"' and LadeHoogte = '"_LadeHoogte_"' and Klantbeperking = '"_KlantID_"'" + + #dim QueryAPI As TECH.Query.QueryAPI = ##class(TECH.Context).Instance().GeefQueryAPI() + #dim ResultSet As TECH.ResultSet = QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement, $LB())) + + If ResultSet.Next() { + Set PRNrAfdekkap = ResultSet.GetData(1) + } Else { + Set SqlStatement = "SELECT ProductID FROM " _SqlTableName _" WHERE " _"(GeldigTot >= '"_Datum_"' or GeldigTot is null) and (GeldigVan <= '"_Datum_"' or GeldigVan is null) and LadeKleur = '"_Kleur_"' and LadeHoogte = '"_LadeHoogte_"' and Klantbeperking is null" + Set ResultSet = QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement, $LB())) + If ResultSet.Next() { + Set PRNrAfdekkap = ResultSet.GetData(1) + } Else { + Do ##class(TECH.Exceptions.DataNotFoundException).Throw("Geen data gevonden voor "_SqlStatement_".") + } + } + + Quit PRNrAfdekkap +]]> + + + +Variant:%String,Kleur:%String,KlantID:%String +1 += '"_Datum_"' or GeldigTot is null) and (GeldigVan <= '"_Datum_"' or GeldigVan is null) and LadeKleur = '"_Kleur_"' and Klantbeperking = '"_KlantID_"'" + + #dim QueryAPI As TECH.Query.QueryAPI = ##class(TECH.Context).Instance().GeefQueryAPI() + #dim ResultSet As TECH.ResultSet = QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement, $LB())) + + If ResultSet.Next() { + Set PRNrAfdekkap = ResultSet.GetData(1) + } Else { + Set SqlStatement = "SELECT ProductID FROM " _SqlTableName _" WHERE " _"(GeldigTot >= '"_Datum_"' or GeldigTot is null) and (GeldigVan <= '"_Datum_"' or GeldigVan is null) and LadeKleur = '"_Kleur_"' and Klantbeperking is null" + Set ResultSet = QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement, $LB())) + If ResultSet.Next() { + Set PRNrAfdekkap = ResultSet.GetData(1) + } Else { + Do ##class(TECH.Exceptions.DataNotFoundException).Throw("Geen data gevonden voor "_SqlStatement_".") + } + } + + Quit PRNrAfdekkap +]]> +