trigger BIGDEAL on Opportunity (Before update)
{
    set<Id> oppIds = new set<Id>();
    set<id> uids = new set<id>();
    //set<Id> accIdList = new set<Id>();
    List<Opportunity> OppList = new List<Opportunity>();
    Map<Id,List<Opportunitysplit>> oppMap = new Map<Id,List<Opportunitysplit>>();
    //OPTY TEAM Start
    Map<Id,List<OpportunityTeamMember>> oppTeam = new Map<Id,List<OpportunityTeamMember>>();
    //OPTY TEAM END
   // Map<Id,List<partner>> opppartMap = new Map<Id,List<partner>>();
    Map<Id,List<Opportunity_Splits__c>> opppartnerorderMap = new Map<Id,List<Opportunity_Splits__c>>();
    Map<Id,Sales_Scorecard__c> sscMap = new Map<Id,Sales_Scorecard__c>();
    List<Sales_Scorecard__c> ssList = new List<Sales_Scorecard__c>();

    for(Opportunitysplit ops :[Select id,SplitAmount,SplitPercentage,Role_Name__c,Opportunityid,SplitOwnerid from Opportunitysplit Where Opportunityid IN: trigger.newmap.keyset()])
    {
        uids.add(ops.SplitOwnerid);
        if(oppMap.containskey(ops.Opportunityid))
        oppmap.get(ops.Opportunityid).add(ops);
        else{
            List<Opportunitysplit> opslist = new List<Opportunitysplit>();
            opslist.add(ops);
            oppmap.put(ops.Opportunityid,opslist);
        }
    }
    
    List<Sales_Scorecard__c> ssclist =[select id, name,User_Name__c,Manager__c,Quota__c,Manager_Quota__c,User_Role__c from Sales_Scorecard__c where User_Name__c IN :uids];
   // Id devRecordTypeId = Schema.SObjectType.Opportunity.getRecordTypeInfosByName().get('GEIP-Renewal').getRecordTypeId();
    for(Sales_Scorecard__c ssc : ssclist){
        sscMap.put(ssc.User_Name__c,ssc);
    }   
    
    List<Opportunity_Splits__c> PODS = [SELECT Amount__c,Id,Name,Opportunity__c,Split_Percentage__c,Opportunity_Splits__c.Account__r.name FROM Opportunity_Splits__c where Opportunity__c IN:trigger.newmap.keyset()];
    for(Opportunity_Splits__c POS: PODS ){
        // accIdList.add(POS.Account__c);
        if(opppartnerorderMap.containskey(POS.Opportunity__c))
        opppartnerorderMap.get(POS.Opportunity__c).add(POS);
        else{
            List<Opportunity_Splits__c> podslist = new List<Opportunity_Splits__c>();
            podslist.add(POS);
            // podslist.add(POS);
            opppartnerorderMap.put(POS.Opportunity__c,podslist);
        }
    }  
    

    Map<Id,integer> OppTeamMapChannelRoles= New Map<id,integer>();
    
    Map<Id,integer> OppTeamMapAccountRoles= New Map<id,integer>();
    
    AggregateResult[] teamOppChannelCount =[SELECT OpportunityId,Count(id)FROM OpportunityTeamMember Where 
    Opportunityid IN: oppMap.keyset() and TeamMemberRole ='SW Channel Manager' GROUP BY OpportunityId];
    
    AggregateResult[] teamOppAccountCount =[SELECT OpportunityId,Count(id)FROM OpportunityTeamMember Where 
    Opportunityid IN: oppMap.keyset() and TeamMemberRole ='SW Account Manager' GROUP BY OpportunityId];
 

    for(AggregateResult ar : teamOppChannelCount){
        OppTeamMapChannelRoles.put((id)ar.get('OpportunityId'),(Integer)ar.get('expr0'));
    }
    
    for(AggregateResult ar : teamOppAccountCount){
        OppTeamMapAccountRoles.put((id)ar.get('OpportunityId'),(Integer)ar.get('expr0'));
    }
    

    for(opportunity opp : trigger.new)
    {   
        system.debug('testing opp'+opp);
        if(oppMap.get(opp.id)!=null)
        {
            System.debug('*******--***'+opp);
            for(Opportunitysplit opss : oppMap.get(opp.id))
            { 
                if((opp.ForecastCategoryName=='Best Case' || opp.ForecastCategoryName=='Commit') 
                //&& opp.RecordTypeId== devRecordTypeId 
                && sscmap!=null 
                && sscmap.get(opss.SplitOwnerid)!=null              
                && ((sscMap.get(opss.SplitOwnerid).Quota__c!=null
                && (sscMap.get(opss.SplitOwnerid).Quota__c/2 <= opss.SplitAmount))
                || (sscMap.get(opss.SplitOwnerid).Manager_Quota__c!=null 
                &&  opss.SplitAmount >=sscMap.get(opss.SplitOwnerid).Manager_Quota__c*25/100)))
                {   system.debug('testing opp'+opss );
					//Checking if an update is required.
					if (opp.Big_Deal__c != true){ //might suffice for what you need, but if not, try the following line
                    //if(((Opportunity)Trigger.oldMap.get(opportunity.Id)).Big_Deal__c != true){
						opp.Big_Deal__c=true;
					}
					break;
                }
                
                 else if((opp.ForecastCategoryName=='Best Case' || opp.ForecastCategoryName=='Commit') &&                             
                        (OppTeamMapChannelRoles.get(opp.id) > 1 || OppTeamMapAccountRoles.get(opp.id) > 1 )){
                        if (opp.Big_Deal__c != true)//Checking if an update is required.
							opp.Big_Deal__c = true;
                    } 
                    else if((opp.ForecastCategoryName=='Best Case' || opp.ForecastCategoryName=='Commit') && opppartnerorderMap!=null && opppartnerorderMap.get(opp.id)!=null && opppartnerorderMap.containsKey(opp.id))
                    {              
                        for(Opportunity_Splits__c POS : opppartnerorderMap.get(opp.id)) 
                        if(POS.Account__c!=null && POS.Account__r.name.contains('GE Intelligent platforms')&&(date.valueOf(opp.createdDate).daysBetween(date.valueOf(opp.CloseDate))<=30))
                        {
							if (opp.Big_Deal__c != true){//Checking if an update is required.
								opp.Big_Deal__c=true;
                            }
							break;
                        }
                        else if(POS.Account__c!=null && !POS.Account__r.name.contains('GE Intelligent platforms')&&(date.valueOf(opp.createdDate).daysBetween(date.valueOf(opp.CloseDate))<=45))
                        opp.Big_Deal__c=true;
                        else{
                            system.debug('testing opp');
                            if (opp.Big_Deal__c != false){//if true or null
								opp.Big_Deal__c=false;
                            }
                        }
                    }             
                        
                    else{
                        system.debug('testing opp');
						if (opp.Big_Deal__c != false){//if true or null
							opp.Big_Deal__c=false;
						}
                    }
               
            }
        }
    }
}