public with sharing class Eisai_InsertAcctList_cls {
    
    List<User> usersIdList; 
    Set<Id> usersIdSet = new Set<Id>(); 
    Set<Id> AffFromAcctSet = new Set<Id>(); 
    Set<String> uniqueFieldSet = new Set<String>();
    List<Affiliation_vod__c> allAffParentRecs;
    List<Account_List_vod__c> newAccListRecList = new List <Account_List_vod__c>();
    List<Account_List_vod__c> xAcctListRecs = new List <Account_List_vod__c>();
    List<Account_List_vod__c> InsertedAccList = new List <Account_List_vod__c>();
	
	//added Collections
	List<Id> fromAcctIdList = new List<Id>();
	List<TSF_vod__c> terr = new List<TSF_vod__c>();
	List<UserTerritory> userTerrInGroupAcct = new List<UserTerritory>();
    List<Account_List_vod__c> accListToInsert = new List<Account_List_vod__c>();
	Set<String> terrSet = new Set<String>(); 
	Set<Id> terrIdSet = new Set<Id>();
    Set<String> fromAcctValList = new Set<String>();
	
    
    public Eisai_InsertAcctList_cls(){
        allAffParentRecs = new List<Affiliation_vod__c>([SELECT Id, OwnerId, From_Account_vod__c, From_Account_Value__c, To_Account_vod__c
                                                         FROM Affiliation_vod__c
                                                         WHERE Parent_vod__c = True
                                                    	 AND From_Account_vod__c = '0011200001EURv0'
                                                         AND From_Account_RecType__c = 'Group_Practice_Account'
                                                 	     AND OwnerId IN: getActiveUsers()]);
        
        System.debug('Parent Affiliation Record Id '+ allAffParentRecs.size());
		
		//added SOQL Queries
		for(Affiliation_vod__c affFromAcct : allAffParentRecs){
            if(!AffFromAcctSet.contains(affFromAcct.From_Account_vod__c)){
				fromAcctIdList.add(affFromAcct.From_Account_vod__c);
            	fromAcctValList.add(affFromAcct.From_Account_Value__c);
            	AffFromAcctSet.add(affFromAcct.From_Account_vod__c);
            }
		}
        
        
        
		for(TSF_vod__c terr : [SELECT Id, Territory_vod__c, Account_vod__c FROM TSF_vod__c 
                               											   WHERE Account_vod__c IN:fromAcctIdList]){
				terrSet.add(terr.Territory_vod__c);
		}
		
		System.debug('Territory count: ' + terrSet.size());
		
		for(Territory terrId : [SELECT Id, Name FROM Territory 
                                				WHERE Name IN:terrSet]){
				terrIdSet.add(terrId.Id);
		}
		
		userTerrInGroupAcct = [SELECT UserId FROM UserTerritory 
                                       		 WHERE TerritoryId IN: terrIdSet];

       System.debug('No. of user owns the Group Practice Account: ' + userTerrInGroupAcct.size());
        
        //end of added SOQL Queries
		
		
        for(Account_List_vod__c xAcctListRecs  : [Select Name_Populate_Unique_Owner__c FROM Account_List_vod__c 
                                                  									   WHERE Name_Populate_Unique_Owner__c != Null
                                                  									   AND OwnerId IN: getActiveUsers()])
        {
            uniqueFieldSet.add(xAcctListRecs.Name_Populate_Unique_Owner__c);
        }
        
        for(String allParentAffRecs: fromAcctValList){
                   for(Integer i = 0; i < userTerrInGroupAcct.size(); i++){
                        Account_List_vod__c AccListRec = new Account_List_vod__c();    
                            AccListRec.Name = 'HO_' + allParentAffRecs; 
                            AccListRec.Icon_Name_vod__c = '0';  
                            AccListRec.OwnerId = userTerrInGroupAcct[i].UserId; 
                        	newAccListRecList.add(AccListRec);
                   }
        }
        
        for(Account_List_vod__c accList : newAccListRecList){
            if(!uniqueFieldSet.contains(accList.Name + accList.OwnerId)){
                InsertedAccList.add(accList);
            }
        }
            
        Database.SaveResult[] srList = Database.insert(InsertedAccList, false);

        for (Database.SaveResult sr: srList){
            if(sr.isSuccess()){
                System.debug('Inserted Account List count: ' + sr.getId());
            } else {
                for(Database.Error err : sr.getErrors()){
                System.debug(err.getStatusCode() + ': ' + err.getMessage());
                }
            }
        }
    }//end of 1st block
            
   public Set<Id> getActiveUsers(){
        
        usersIdList = new List<User>([SELECT Id
                                      FROM User
                                      WHERE (Profile_Name_vod__c LIKE '%Eisai_Epilepsy%' 
                                             OR Profile_Name_vod__c LIKE '%Eisai_PrimaryCare%') 
                                      AND IsActive = TRUE]); 
        
        for(User users : usersIdList){
            usersIdSet.add(users.Id);  
        }
        return usersIdSet;
    }
    
}// End of Class