global class RenewalValueOpp  implements Schedulable{
  global void execute(SchedulableContext SC) {
    List<Opportunity> RenewalValue=[SELECT Id,Opportunity.Name, (SELECT Id FROM Orders__r)
                                    FROM Opportunity
                                    WHERE CreatedBy.Name='Man' AND CreatedDate=Yesterday AND Type='Renewal'];//TODAY
    system.debug('RenewalValue van Opportunity'+RenewalValue);
    for(Opportunity r : RenewalValue){
      double TotOrder = 0;

      List<Order__c> OrderAmount =[SELECT id, Order_Amount__c FROM Order__c WHERE Opportunity_Name__r.Id=:r.Id];

      System.debug('OrderAmount '+ OrderAmount);
        for(Order__c o : OrderAmount){
          TotOrder += o.Order_Amount__c;
        }
       r.Renewal_Value__c=TotOrder;
       System.debug('r.Renewal_Value__c   TotOrder'+ r.Renewal_Value__c);
       Update r;
     }
  }
}

global class RenewalValueOpp  implements Schedulable{
  global void execute(SchedulableContext SC) {
    List<Opportunity> RenewalValue=[SELECT Id,Opportunity.Name, (SELECT Id FROM Orders__r)
                                    FROM Opportunity
                                    WHERE CreatedBy.Name='Man' AND CreatedDate=Yesterday AND Type='Renewal'];//TODAY
      List<Order__c> OrderAmount =[SELECT id,Opportunity_Name__r.Id, Order_Amount__c FROM Order__c WHERE CreatedDate=Yesterday];
      system.debug('RenewalValue van Opportunity'+RenewalValue);
    for(Opportunity r : RenewalValue){
      double TotOrder = 0;
      System.debug('OrderAmount '+ OrderAmount);
        for(Order__c o : OrderAmount){
            if(o.Opportunity_Name__r.Id==r.id){
          TotOrder += o.Order_Amount__c;
                }
        }
       r.Renewal_Value__c=TotOrder;
       System.debug('r.Renewal_Value__c   TotOrder'+ r.Renewal_Value__c);
       Update r;
     }
  }
}