| | |
| | | ' previousTotalContractAmount__c , currentTotalContractAmountVM__c , currentTotalGuaranteePrice__c '+ |
| | | ' , RecordType_DeveloperName__c ' + |
| | | ' from Maintenance_Contract__c ' |
| | | + ' where Status__c in (\'契約\',\'契約満了\') '; |
| | | + ' where Status__c in (\'契約\',\'契約満了\') ' |
| | | //URF限次合同2期 LY 20220811 start |
| | | + 'and URF_Contract__c = false'; |
| | | //URF限次合同2期 LY 20220811 end |
| | | if (string.isNotBlank(TestID) ) { |
| | | query += ' and id =: TestID'; |
| | | } else if (TestIDList != null && TestIDList.size() > 0) { |
| | |
| | | query += ' and Contract_End_Date__c = ' + |
| | | testDate.addDays(-1).format().replace('/', '-'); |
| | | } |
| | | system.debug('query:'+query); |
| | | //system.debug('query:'+query); |
| | | testDate = Datecheck(testDate); |
| | | |
| | | return Database.getQueryLocator(query); |