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
+]]>
+