| | |
|---|
| | | 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\')'; |
|---|
