Hi Roy,

Thanks for your insight here. I have given the login access for Salesforce.com support and so thought you might logging in with Blacktab access.

The code is mentioned below:

global class batchSetClassInactiveAfterLastClassDate Implements Database.Batchable<sObject>{

global String qry;

global batchSetClassInactiveAfterLastClassDate(String thisqry){
  qry = thisqry;
}

global Database.QueryLocator start(Database.BatchableContext bc) {  
  Date dt = Date.today();
  return Database.getQueryLocator(qry);  
}
 
global void execute(Database.BatchableContext BC, List<sObject> enrol){
system.debug('############ enrol =' + enrol);
  
  set<ID> contIDs = new set<ID>();
  
  for (Enrollments__c thisenrol : (List<Enrollments__c>)enrol)
        contIDs.add(thisenrol.Contact__c);
           
  system.debug('############ contIDs =' + contIDs);
  
  Map<ID,Contact> thiscontMap = new Map<ID,Contact>([select id, Name,RecordTypeID  from Contact where id In :contIDs ]);
  
  system.debug('############ thiscontMap =' + thiscontMap);
  
  // fianally a map of all enrolments against the contacts
  
  
           
           
    for (Enrollments__c thisenrolment : (List<Enrollments__c>)enrol)
  {
    
    system.debug('############ thisenrolment =' + thisenrolment);
    
    system.debug('############ thisenrolment is after last class date, so should be set to Inactive');
    thisenrolment.Status__c = 'Inactive';
    
    system.debug('############ thisenrolment now=' + thisenrolment);
           
  }
  update enrol;
  
  
  
  // last payment date
  system.debug('############ no look for all enrolments that should be set 2 zero becasue teh last payment date is today');
  list<Enrollments__c> enrollastpaymentdatetoday = [select Id, Status__c, Last_Payment_Date__c, Contact__c From Enrollments__c 
        where Status__c = 'Notice Period' and  Last_Payment_Date__c <= :Date.today()];
  
  system.debug('############ enrollastpaymentdatetoday =' + enrollastpaymentdatetoday);
  update enrollastpaymentdatetoday;
  
  system.debug('############ enrollastpaymentdatetoday after update=' + enrollastpaymentdatetoday);
      
  
  
        
    //set to contact type Ex-Student  
    Map<ID, Set<String>> enrollTypeMap = new Map<ID, Set<String>>();
    
    list<Enrollments__c> erolls = [select Id, Status__c, Last_Class_Date__c, Contact__c From Enrollments__c where Contact__c In :contIDs];
    Map<Id, list<Enrollments__c>> allEnrollToContactMap = new Map<Id, list<Enrollments__c>>();
    list<Enrollments__c> enrollLst;
    for (Enrollments__c eachEnroll : erolls){
    if (allEnrollToContactMap.get(eachenroll.Contact__c) == null)
      enrollLst = new list<Enrollments__c>();
    else
      enrollLst = allEnrollToContactMap.get(eachenroll.Contact__c);
    
    enrollLst.add(eachenroll);
    allEnrollToContactMap.put(eachenroll.Contact__c, enrollLst);      
    }
    system.debug('############ erolls =' + erolls);
    //for (Enrollments__c erolls : [select Id, Status__c, Last_Class_Date__c, Contact__c From Enrollments__c where Contact__c In :contIDs]){
           
      //Set<String> enrollTypeSet;
      //if (enrollTypeMap.get(erolls.Contact__c) != null){
      //  enrollTypeSet = enrollTypeMap.get(erolls.Contact__c);  
      //}
      //else{
      //  enrollTypeSet = new Set<String>();
      //}
      //enrollTypeSet.add(erolls.Status__c);
    //}
    
    
    //system.debug('############ enrollTypeSet =' + enrollTypeSet);
    //Ex-Student
  Utils.convertToExStudent(thiscontMap.Values(), allEnrollToContactMap);    
    
    //update thiscontMap.Values();  
}

global void finish(Database.BatchableContext BC){
}

Please let me know if you have any further questions.


Thanks & Regards,
Richard Dwyer