public List<AggregateResult> inBudgetList {get;set;}
inBudgetList = [SELECT
Budget_User__r.Name inAEName,
Budget_User__c inAeId,
Advertiser__r.Name account,
Sum(Amount__c) inBudAmt,
Broadcast_Month_Date__c effectiveDate
FROM Sales_Budget__c
WHERE Old_Budget_User__c = :selectedUserId
GROUP BY Budget_User__r.Name, Budget_User__c, Advertiser__r.Name, Broadcast_Month_Date__c
ORDER BY Budget_User__r.Name
];
for(AggregateResult inBudItem: inBudgetList){
transferObj.transferUser = (String)inBudItem.get('inAEName');
transferObj.account = (String)inBudItem.get('account');
transferObj.transferIn = (Decimal)inBudItem.get('inBudAmt');
transferObj.transferEffectiveDate = ((Datetime)inBudItem.get('effectiveDate')).format('MMMMM -YYYY');
transferLogs.add(transferObj);
transferObj = new transferLogsWrapper();
This is a part of my code containig aggregate result,please help me in covering this in a test class
@istest
public class TrackCompensationPlanDetailsContTest{
public static testmethod void test1(){
Profile pro = [SELECT Id FROM Profile WHERE Name='Standard User'];
User u = new User(Alias = 'standt', Email='standarduser@testorg.com',
EmailEncodingKey='UTF-8', LastName='Testing 001', LanguageLocaleKey='en_US',
LocaleSidKey='en_US', ProfileId = pro.Id,
TimeZoneSidKey='America/Los_Angeles', UserName='standarduser124@testorg.com');
insert u;
Account objAcc = new Account ();
objAcc.Name = 'Test Account Owner Change';
objAcc.BillingStreet = 'Valley';
objAcc.BillingCity = 'dallas';
objAcc.BillingState = 'TX';
objAcc.BillingCountry = 'us';
objAcc.BillingPostalCode = '75432';
objAcc.Skip_Address_Validation__c = true;
objAcc.Last_Client_Schedule_Date__c = Date.today();
objAcc.Primary_Commodity__c = 'Alcoholic Beverages';
Sales_Budget__c sb = new Sales_Budget__c();
sb.advertiser__c = objAcc.id;
sb.Budget_user__c = u.id;
sb.HR_Manager__c = u.id;
sb.Old_Budget_User__c = u.id;
sb.Amount__c=999;
sb.Commodity__c='Auto Aftermarket';
sb.Product_Line__c='Linear/News/Sports';
sb.Broadcast_Month_Date__c = System.today();
sb.External_Id__c = '007'+u.id+System.today();
insert sb;
User o=new user();
ApexPages.StandardController stcon=new ApexPages.StandardController(o);
TrackCompensationPlanDetails2Controller obj=new TrackCompensationPlanDetails2Controller();
String v='00530000000ibYc';
TrackCompensationPlanDetails2Controller.ConfirmAEList(v);
}
public static testmethod void test2(){
User o=new user();
ApexPages.StandardController stcon=new ApexPages.StandardController(o);
TrackCompensationPlanDetails2Controller obj=new TrackCompensationPlanDetails2Controller();
Profile pro = [SELECT Id FROM Profile WHERE Name='Standard User'];
User u = new User(Alias = 'standt', Email='standarduser@testorg.com',
EmailEncodingKey='UTF-8', LastName='Testing 001', LanguageLocaleKey='en_US',
LocaleSidKey='en_US', ProfileId = pro.Id,
TimeZoneSidKey='America/Los_Angeles', UserName='standarduser124@testorg.com');
insert u;
Account objAcc = new Account ();
objAcc.Name = 'Test Account Owner Change';
objAcc.BillingStreet = 'Valley';
objAcc.BillingCity = 'dallas';
objAcc.BillingState = 'TX';
objAcc.BillingCountry = 'us';
objAcc.BillingPostalCode = '75432';
objAcc.Skip_Address_Validation__c = true;
objAcc.Last_Client_Schedule_Date__c = Date.today();
objAcc.Primary_Commodity__c = 'Alcoholic Beverages';
Sales_Budget__c sb = new Sales_Budget__c();
sb.advertiser__c = objAcc.id;
sb.Budget_user__c = u.id;
sb.HR_Manager__c = u.id;
sb.Old_Budget_User__c = u.id;
sb.Amount__c=999;
sb.Commodity__c='Auto Aftermarket';
sb.Product_Line__c='Linear/News/Sports';
sb.Broadcast_Month_Date__c = System.today();
sb.External_Id__c = '007'+u.id+System.today();
insert sb;
//update sb;
String v='00530000000ibYc';
TrackCompensationPlanDetails2Controller.ConfirmAEList(v);
}
}
Hi Rajesh ,please help me with this,Thanks in advance
