| | |
| | | // WHERE Id != null AND RecordTypeId = '01210000000QfWiAAK' AND Account.Is_Active_Formula__c = '有效' AND MobilePhone != '' AND Isactive__c = '有效' |
| | | // ]); |
| | | // 发送指定数据 |
| | | // 经销商和医院客户人员数据都需要重新执行 thh 20220411 start |
| | | return Database.getQueryLocator([SELECT id, Name, IsFromSPO__c, RecordTypeId, UnifiedI_Contact_ID__c, SendToComPlat__c,MobilePhone |
| | | FROM Contact |
| | | WHERE Id != null |
| | | AND RecordTypeId = '01210000000QfWiAAK' |
| | | AND (RecordTypeId = '01210000000QfWiAAK' OR RecordTypeId = '01210000000QfWdAAK') |
| | | AND Account.Is_Active_Formula__c = '有效' |
| | | AND MobilePhone != '' |
| | | AND ((Isactive__c = '有效' |
| | | AND SendToComPlat__c =true) OR SendToComPlat__c = true) |
| | | AND SendToComPlat__c = true) OR SendToComPlat__c = true) |
| | | ]); |
| | | // 经销商和医院客户人员数据都需要重新执行 thh 20220411 start |
| | | |
| | | } |
| | | |
| | | global void execute(Database.BatchableContext BC, list < Contact > senContactList) { |