| | |
| | | opportunityCategorySP.add('ENT'); |
| | | String log = ''; |
| | | if (TEST_ID != null && TEST_ID.size() > 0) { |
| | | //oppSql += ' where id in :TEST_ID'; |
| | | oppSql += ' where OCSMRMB_Without_Tax__c >= 1000000 and OCSMRMB_Without_Tax__c <= 2000000'; |
| | | oppSql += ' where id in :TEST_ID'; |
| | | }else{ |
| | | oppSql += ' where StageName = \'引合\' and ForecastAccuracyObject__c = true'; |
| | | oppSql += ' and Competitor__c in (\'A\',\'B\',\'C\',\'D\',\'E\') '; //2021-11-22 yjk 增加判断条件 询价等级 |
| | | // oppSql += ' and Competitor__c in (\'A\',\'B\',\'C\',\'D\',\'E\') '; //2021-11-22 yjk 增加判断条件 询价等级 |
| | | oppSql += ' and Competitor__c in (\'A\',\'B\',\'C\',\'D\') '; //2021-11-22 yjk 增加判断条件 询价等级 |
| | | oppSql += ' and IsNextMonthOfVisit__c = false and SalesdepartmentForecast__c in :areas'; |
| | | // 5)客户为H层客户的询价 |
| | | // oppSql += ' and (OCM__c = \'H0\' or OCM__c = \'H1\')'; |
| | |
| | | opportunityCategorySP.add('ENT'); |
| | | String log = ''; |
| | | for (Opportunity opp : oppList){ |
| | | //log += ' OCSMRMB_Without_Tax__c : '+ opp.OCSMRMB_Without_Tax__c + '\n'; |
| | | if(opp.Owner.IsActive){//2021-08-30 yjk 增加判断任务对应的用户必须为IsActive |
| | | task__c newTask = new task__c(); |
| | | newTask.assignee__c = opp.OwnerId; |
| | |
| | | } |
| | | |
| | | }else{ |
| | | log += 'OCSMRMB_Without_Tax__c :'+opp.OCSMRMB_Without_Tax__c + '\n'; |
| | | log = 'OCSMRMB_Without_Tax__c :'+opp.OCSMRMB_Without_Tax__c + '\n'; |
| | | log += 'Opportunity_Category__c : '+ opp.Opportunity_Category__c + '\n' ; |
| | | //log += 'Close_Forecasted_Date__c : '+ opp.Close_Forecasted_Date__c + '\n' ; |
| | | newTask.distributeReason__c = '半年大合同'; |