Index: Stat/OmzetKlantProductMaand.cls.xml =================================================================== diff -u -r1426 -r1600 --- Stat/OmzetKlantProductMaand.cls.xml (.../OmzetKlantProductMaand.cls.xml) (revision 1426) +++ Stat/OmzetKlantProductMaand.cls.xml (.../OmzetKlantProductMaand.cls.xml) (revision 1600) @@ -178,7 +178,7 @@ 1 - + @@ -234,6 +234,25 @@ Do ..ZoekPRNrsCatalogi() + Set %RSet=##class(%ResultSet).%New() + Set %RSetMetType=##class(%ResultSet).%New() + Set %RSetZonderType=##class(%ResultSet).%New() + + Do %RSet.Prepare("Select KlantNr, KostType,SUM(Kost) As Kostprijs from APPS_common_KlantKost_impl_data.MaandKost WHERE ((Jaar = ? AND MAAND >= ?) OR (Jaar = ? AND MAAND <= ?)) GROUP BY KlantNr, KostType") + + Set JaarVan = ##class(TECH.DateTime).Jaar(+%HorologHuidigVan) + Set MaandVan = ##class(TECH.DateTime).Maand(+%HorologHuidigVan) + Set JaarTot = ##class(TECH.DateTime).Jaar(+%HorologHuidigTot) + Set MaandTot = ##class(TECH.DateTime).Maand(+%HorologHuidigTot) + Do %RSet.Execute(JaarVan,MaandVan,JaarTot,MaandTot) + + While(%RSet.Next()){ + If (%RSet.Data("KostType") = ##class(APPS.common.KlantKost.enu.KostType).Bezoek()){ + Set %BezoekKost(%RSet.Data("KlantNr")) = %RSet.Data("Kostprijs") + }ElseIf (%RSet.Data("KostType") = ##class(APPS.common.KlantKost.enu.KostType).Monster()){ + Set %MonsterKost(%RSet.Data("KlantNr")) = %RSet.Data("Kostprijs") + } + } Quit $$$OK ]]> @@ -246,6 +265,7 @@ %Status @@ -437,27 +458,24 @@ KlantNr:%Integer,KostType:APPS.common.KlantKost.enu.KostType="",HuidigVan:%Date,HuidigTot:%Date %Float = ?) OR (Jaar = ? AND MAAND <= ?)) AND KlantNr = ? AND KostType = ?") - Do RSet.Execute(JaarVan,MaandVan,JaarTot,MaandTot,KlantNr,KostType) + Set Kostprijs = 0 + If (KostType = ##class(APPS.common.KlantKost.enu.KostType).Bezoek()){ + If ($Data(%BezoekKost(KlantNr))){ + Set Kostprijs = %BezoekKost(KlantNr) + } + }ElseIf (KostType = ##class(APPS.common.KlantKost.enu.KostType).Monster()){ + If ($Data(%MonsterKost(KlantNr))){ + Set Kostprijs = %MonsterKost(KlantNr) + } + }Else{ /// Totaal + If ($Data(%BezoekKost(KlantNr))){ + Set Kostprijs = Kostprijs + %BezoekKost(KlantNr) + } + If ($Data(%MonsterKost(KlantNr))){ + Set Kostprijs = Kostprijs + %MonsterKost(KlantNr) + } } - /// Alle kosten berekenen - Else{ - Do RSet.Prepare("Select SUM(Kost) As Kostprijs from APPS_common_KlantKost_impl_data.MaandKost WHERE ((Jaar = ? AND MAAND >= ?) OR (Jaar = ? AND MAAND <= ?)) AND KlantNr = ? ") - Do RSet.Execute(JaarVan,MaandVan,JaarTot,MaandTot,KlantNr) - } - If (RSet.Next()){ - Set Kostprijs = RSet.Data("Kostprijs") - } - If (Kostprijs = "") Set Kostprijs = 0 + Quit Kostprijs ]]> Index: APPS/common/KlantKost/impl/MonsterKostCalculator.cls.xml =================================================================== diff -u -r1384 -r1600 --- APPS/common/KlantKost/impl/MonsterKostCalculator.cls.xml (.../MonsterKostCalculator.cls.xml) (revision 1384) +++ APPS/common/KlantKost/impl/MonsterKostCalculator.cls.xml (.../MonsterKostCalculator.cls.xml) (revision 1600) @@ -10,7 +10,60 @@ Jaar:%Integer,Maand:%Integer - Index: APPS/common/KlantKost/impl/data/MonsterKostItem.cls.xml =================================================================== diff -u -r1384 -r1600 --- APPS/common/KlantKost/impl/data/MonsterKostItem.cls.xml (.../MonsterKostItem.cls.xml) (revision 1384) +++ APPS/common/KlantKost/impl/data/MonsterKostItem.cls.xml (.../MonsterKostItem.cls.xml) (revision 1600) @@ -8,8 +8,38 @@ APPS.common.KlantKost.impl.data.IndividueelKostItem 0 - + %String + + +Datum:%Date,KlantNr:%Integer,Kost:%Integer,ProformaNr:%String +1 +1 +%Status + + + + +%Library.CacheStorage +MonsterKostItemDefaultData + +listnode +"MonsterKostItem" + +Factuur + + +ProformaNr + + + Index: DOM/OV/impl/DataM/DataMBonAbstract.cls.xml =================================================================== diff -u -r1076 -r1600 --- DOM/OV/impl/DataM/DataMBonAbstract.cls.xml (.../DataMBonAbstract.cls.xml) (revision 1076) +++ DOM/OV/impl/DataM/DataMBonAbstract.cls.xml (.../DataMBonAbstract.cls.xml) (revision 1600) @@ -71,7 +71,7 @@ -%String +DOM.OV.enu.OrderType Index: APPS/CRM/KlantService.cls.xml =================================================================== diff -u -r1577 -r1600 --- APPS/CRM/KlantService.cls.xml (.../KlantService.cls.xml) (revision 1577) +++ APPS/CRM/KlantService.cls.xml (.../KlantService.cls.xml) (revision 1600) @@ -97,6 +97,7 @@ if '$length(Bestandsnaam) { Set ConfigMgr = ##class(TECH.Config.ConfigMgr).Instance() + Do ##class(vhLib.Logger).%New("APPS.CRM.KlantService").Info("VulKlantWijzigingenBestandAan","KlantNr : "_KlantNr) Do ##class(vhLib.Logger).%New("APPS.CRM.KlantService").Info("VulKlantWijzigingenBestandAan","ConfigMgr is Object ? "_$IsObject(ConfigMgr)) Set Bestandsnaam = ConfigMgr.GetString("APPS.CRM.KlantService.KlantBestandIncrementeel") Do ##class(vhLib.Logger).%New("APPS.CRM.KlantService").Info("VulKlantWijzigingenBestandAan","Bestandsnaam KlantBestand : "_Bestandsnaam) Index: TECH/DateTime.cls.xml =================================================================== diff -u -r1578 -r1600 --- TECH/DateTime.cls.xml (.../DateTime.cls.xml) (revision 1578) +++ TECH/DateTime.cls.xml (.../DateTime.cls.xml) (revision 1600) @@ -21,6 +21,14 @@ ]]> + +1 +Text:%String +%Date + + + 1 Timestamp:%TimeStamp Index: DOM/OV/enu/OrderType.cls.xml =================================================================== diff -u --- DOM/OV/enu/OrderType.cls.xml (revision 0) +++ DOM/OV/enu/OrderType.cls.xml (revision 1600) @@ -0,0 +1,53 @@ + + + +datatype +1 +%String +0 + + +,M,P,Y,C,K,A + + + +;Monster;Proforma;CashCarry;Contract;KlantGebonden;Afroep + + + +1 + + + + +1 + + + + +1 + + + + +1 + + + + +1 + + + + +1 + + + + Index: vhDeploy/JBL/Deploy20110704x1341.cls.xml =================================================================== diff -u --- vhDeploy/JBL/Deploy20110704x1341.cls.xml (revision 0) +++ vhDeploy/JBL/Deploy20110704x1341.cls.xml (revision 1600) @@ -0,0 +1,31 @@ + + + +1 +svn.Deploy +0 + + +Berekenen van monster kosten. + + + +1 + + + + Index: DOM/PM/Maatwerk/Calc/Common/BerekeningsSpecificatie.cls.xml =================================================================== diff -u -r1075 -r1600 --- DOM/PM/Maatwerk/Calc/Common/BerekeningsSpecificatie.cls.xml (.../BerekeningsSpecificatie.cls.xml) (revision 1075) +++ DOM/PM/Maatwerk/Calc/Common/BerekeningsSpecificatie.cls.xml (.../BerekeningsSpecificatie.cls.xml) (revision 1600) @@ -17,6 +17,8 @@ + +De hoeveelheid, is enkel bedoeld om de eenheidprijs te bepalen. Niet om de prijs voor die hoeveelheid te hebben. %Integer 1 Index: DOM/OV/impl/DataM/DataMProforma.cls.xml =================================================================== diff -u -r1076 -r1600 --- DOM/OV/impl/DataM/DataMProforma.cls.xml (.../DataMProforma.cls.xml) (revision 1076) +++ DOM/OV/impl/DataM/DataMProforma.cls.xml (.../DataMProforma.cls.xml) (revision 1600) @@ -33,6 +33,15 @@ ]]> + +%Date + + + Index 1 Index: JBL KPI Klant Product Anlayse Kosten.prj.xml =================================================================== diff -u -r1384 -r1600 --- JBL KPI Klant Product Anlayse Kosten.prj.xml (.../JBL KPI Klant Product Anlayse Kosten.prj.xml) (revision 1384) +++ JBL KPI Klant Product Anlayse Kosten.prj.xml (.../JBL KPI Klant Product Anlayse Kosten.prj.xml) (revision 1600) @@ -1,6 +1,6 @@ - + @@ -16,6 +16,20 @@ + + + + + + + + + + + + + + Index: DOM/AKP/impl/DataM/DataMAankoopPrijsAPI.cls.xml =================================================================== diff -u -r1075 -r1600 --- DOM/AKP/impl/DataM/DataMAankoopPrijsAPI.cls.xml (.../DataMAankoopPrijsAPI.cls.xml) (revision 1075) +++ DOM/AKP/impl/DataM/DataMAankoopPrijsAPI.cls.xml (.../DataMAankoopPrijsAPI.cls.xml) (revision 1600) @@ -11,7 +11,7 @@ APPS.PM.dto.Kenm.KenmerkMetadataList