Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **Public Class Plan220219_class {**
- Public Summary1[] Summaries1 {get; set;}
- Public Summary2[] Summaries2 {get; set;}
- Public Summary3[] Summaries3 {get; set;}
- Public Plan220219_class() {
- agg1();
- agg2();
- agg3();
- }
- public void agg1() {
- AggregateResult[] results1 = [SELECT COUNT(OwnerId) CountAcc, Id FROM Account GROUP BY Id];
- Summaries1 = new List<Summary1>();
- FOR(AggregateResult ar1 : results1) {
- Summaries1.add(new Summary1(ar1));
- }
- }
- public void agg2() {
- AggregateResult[] results2 = [SELECT COUNT(Id) CountSales, SUM(Sales_amount__c) Sales_amount, contract2__r.contract1__r.account__r.Id FROM Sales__c GROUP BY contract2__r.contract1__r.account__r.Id];
- Summaries2 = new List<Summary2>();
- FOR(AggregateResult ar2 : results2) {
- Summaries2.add(new Summary2(ar2));
- }
- }
- public void agg3() {
- AggregateResult[] results3 = [SELECT SUM(Amount) Opp_Amount, Account.Id FROM Opportunity GROUP BY Account.Id];
- Summaries3 = new List<Summary3>();
- FOR(AggregateResult ar3 : results3) {
- Summaries3.add(new Summary3(ar3));
- }
- }
- public class summary1 {
- public Integer CountAcc {get; set;}
- public Id UId {get; set;}
- public summary1 (AggregateResult ar1) {
- CountAcc = (Integer) ar1.get('CountAcc');
- UId = (Id) ar1.get('Id');
- }
- }
- public class summary2 {
- public Integer CountSales {get; set;}
- public Double Sales_Amount {get; set;}
- public Id UId {get; set;}
- public summary2 (AggregateResult ar2) {
- CountSales = (Integer) ar2.get('CountSales');
- Sales_Amount = (Double) ar2.get('Sales_amouont');
- UId = (Id) ar2.get('Id');
- }
- }
- public class summary3 {
- public Double Opp_Amount {get; set;}
- public Id UId {get; set;}
- public summary3 (AggregateResult ar3) {
- Opp_Amount = (Double) ar3.get('Opp_Amount');
- UId = (Id) ar3.get('Id');
- }
- }
- }
- **<apex:page controller="Plan220219_class">**
- <apex:repeat value="{!Summaries1}" var="summary1">
- {!summary1.UId} : {!summary1.CountAcc} <br/>
- </apex:repeat>
- <br/>
- <apex:repeat value="{!Summaries2}" var="summary2">
- {!summary2.UId} : {!summary2.CountSales} : {!summary2.Brutto_BWS} <br/>
- </apex:repeat>
- <br/>
- <apex:repeat value="{!Summaries3}" var="summary3">
- {!summary3.UId} : {!summary3.OPP_Amount} <br/>
- </apex:repeat>
- </apex:page>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement