| | |
| | | query += ' and Sales_Root__c != \'\''; |
| | | //20190107 --------addEnd--------- |
| | | query += ' and Salesdepartment_Owner__c != \'外科事业本部\''; |
| | | // 20220928 ljh SWAG-CJMCZ4 start |
| | | query += ' and (ConfirmationofAward__c != \'竞争对手中标\''; |
| | | query += ' OR (ConfirmationofAward__c = \'竞争对手中标\' and Competitor__c != \'A1\' and Competitor__c != \'A\'))'; |
| | | // 20220928 ljh SWAG-CJMCZ4 end |
| | | System.debug('+++11111111--query--111111111111+++++' + query); |
| | | return Database.getQueryLocator(query); |
| | | |
| | |
| | | query += ' and StageName__c != \'失单\''; |
| | | query += ' and Sales_Root__c != \'\''; |
| | | query += ' and Salesdepartment_Owner__c != \'外科事业本部\''; |
| | | // 20220928 ljh SWAG-CJMCZ4 start |
| | | query += ' and (ConfirmationofAward__c != \'竞争对手中标\''; |
| | | query += ' OR (ConfirmationofAward__c = \'竞争对手中标\' AND Competitor__c != \'A1\' and Competitor__c != \'A\'))'; |
| | | // 20220928 ljh SWAG-CJMCZ4 end |
| | | System.debug('+++11111111--正常Batch执行query--111111111111+++++' + query); |
| | | return Database.getQueryLocator(query); |
| | | |