Let me explain..I need to fetch all users below an user role(Sales VP)  in role heirarchy and send a mail to sales VP mail ID,  specifting him that these are list of users below you who did not edit any records in the last one week.


I guess I have coded to an extent to retreive VP(I specified Custom Label) and pass his Id to utility class which returns set of all users below him in heirarchy.

I am processing them and adding ton list if they did not modify any record in last week.


Now I need this list to be passed to sendemail method, andmention all users who did not modify any records in the EMAIL BODY.
The list which holds ids are below in unediteduseridlist.

This class needs to be scheduled weekly. So implemented schedulable and did code in execute() method. I guess this is fine
Hope you got my task. Kindly let me know if there are any changed rerquired.

Thanks in advance,.


CLASS:

Global class MyClass implements schedulable {
    
    Global void execute(schedulablecontext SC)
    {
     
        date d = system.today().addDays(-7);
        List<Account> acclist=  [select id,name,LastModifiedById from account where LastModifiedDate >:d];
  
        List<Opportunity> opplist=  [select id,name,LastModifiedById from Opportunity where LastModifiedDate >:d];
        List<Contact> conlist=  [select id,name,LastModifiedById from Contact where LastModifiedDate >:d];
        List<Lead> leadlist=  [select id,name,LastModifiedById from Lead where LastModifiedDate >:d];
       // List<activity> actlist = [select id,name,LastModifiedById from Activity where LastModifiedDate >:d]
        
        set<id> accset = new set<Id>();
        for(Account Acc : acclist){ accset.add(acc.LastModifiedById); }
           set<id> oppset = new set<Id>();
        for(Opportunity Opp : opplist){ oppset.add(opp.LastModifiedById); }
        set<id> conset = new set<Id>();
        for(contact con : conlist){ conset.add(con.LastModifiedById); }
        set<id> leadset = new set<Id>();
        for(lead ld : leadlist){ leadset.add(ld.LastModifiedById); }
        
        
        List<Id> subordlist=new List<Id>();
        List<id> unediteduseridlist = new List<id>();
        List<user> uneditedusernamelist= new List<user>();    
        List<user> TLSPuserlist=[Select id,Name from User where UserRole.Name =: 'Label.Chief'];
       
        for(user u : TLSPuserlist)
        {
            set<id> subord= new set<id>();
            subord=Roleutils.getRoleSubordinateUsers(u.Id);
            
            If(subord.size()>0 && subord!=NULL)
            {
               for(Id id1 : subordlist)
               {
                If(!accset.contains(id1) || !oppset.contains(id1) || conset.contains(id1) || leadset.contains(id1))
               { 
                   unediteduseridlist.add(id1);
               }
           }
           } 
       }
                
     }
   public void sendmail()
                {
                  Messaging.SingleEmailMessage email = new Messaging.SingleEmailMessage();
                  string [] toaddress= New string[]{''};
                  email.setSubject('CRM not updated this week');
                  String s = 'There has been no activity from the following sales people of your team: <br/>';
                  Integer i = 0;
                  for(user u : [SELECT id,firstname,lastname FROM user LIMIT 10]){
                  i++;
                  s += String.ValueOf(i) + '. ' + u.FirstName + ' ' + u.LastName + '<br/>';
                  }

                  email.setPlainTextBody(s);
                  email.setToAddresses(toaddress);
                  Messaging.sendEmail(New Messaging.SingleEmailMessage[]{email}); 
                }
}




--------------------------------------------------------
RoleUtils CLASS:

public with sharing class RoleUtils {

  public static Set<ID> getRoleSubordinateUsers(Id userId) {

    // get requested user's role
    Id roleId = [select UserRoleId from User where Id = :userId].UserRoleId;
    // get all of the roles underneath the user
    Set<Id> allSubRoleIds = getAllSubRoleIds(new Set<ID>{roleId});
    // get all of the ids for the users in those roles
    Map<Id,User> users = new Map<Id, User>([Select Id, Name From User where 
      UserRoleId IN :allSubRoleIds]);
    // return the ids as a set so you can do what you want with them
    return users.keySet();

  }

  private static Set<ID> getAllSubRoleIds(Set<ID> roleIds) {

    Set<ID> currentRoleIds = new Set<ID>();

    // get all of the roles underneath the passed roles
    for(UserRole userRole :[select Id from UserRole where ParentRoleId IN :roleIds AND ParentRoleID != null])
    currentRoleIds.add(userRole.Id);

    // go fetch some more rolls!
    if(currentRoleIds.size() > 0)
      currentRoleIds.addAll(getAllSubRoleIds(currentRoleIds));

    return currentRoleIds;

  }

}