I have a Leave__c as a custom object. It contains 3 fields: Employee Name (lookup to User), Leave Start Date (Date) and Leave End Date (Date). Example: User "John" is on leave from Start Date "4th Jan 2018" to End Date "12th Jan 2018". Like wise there can be multiple leave records for different users. I want to generate a apex logic such that for month of January (1st Jan to 31t Jan 2018), weekwise how many users are on leave. I want to displa this info in VF Page in table format for reporting purpose.

So I am planning to create a wrapper as below:

    Date leaveDate;
    Boolean isOnLeave;

    Integer weekNumber;
    Integer NumberofLeaves;
    List<DateWiseWrapper> //Max 7 days

    User u;
    List<weekWiseWrapper>; //Max 4 weeks

    List<UserWrapper> userWrapperList;

Does my wrapper looks correct? Can you please help me out on how do I proceed with the apex logic

1 Answer 1


You can start by creating a Map which tells on a particular date which employees are on a leave. Below code will help you to create a map.

List<Leave__C> leaves=[SELECT Id,Employee_Name__c,Employee_Name__r.UserName,Leave_End_Date__c,Leave_Start_Date__c 
                        FROM Leave__C WHERE Leave_Start_Date__c=:THIS_MONTH ];

Map<Date,List<String>> dateVsUserOnThatDayLeave=new Map<Date,List<String>>();

for(Integer i=1;i<=31;i++){
    Date eachDay=Date.newInstance(2018,1,i);
    for(Leave__C leave: leaves){
        if(eachDay>=leave.Leave_Start_Date__c && eachDay<=leave.Leave_End_Date__c){
                List<String> newUserList=new List<String>();

//dateVsUserOnThatLeave contains people who are on leave on a particular day

Now it depends on you how you iterate it and shows them on VF. You can use your wrapper.

I would go by creating a simple table.

Rows -> Each Day of Month

Column-> Each Employee whos on leave

enter image description here

Start doing it, let us know if you face any issues.

  • Thanks for your response. The way I need the output is somewhat this: Map<UserName, Map<WeekNumber, NoOfDaysofLeave>> So for example: for Weeks of Jan User "John" Week1 : 2 days leave Week2 : 3 days leave Week3 : 0 days leave Week4 : 1 days leave User "Smith" Week1 : 0 days leave Week2 : 4 days leave Week3 : 2 days leave Week4 : 2 days leave
    – Shrey
    Apr 13, 2018 at 5:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.