| | |
| | | sql +='agencyAutoSignUpStatus__c,HPSignUpStatus__c,agencyConfirmDate__c,endUser__c,endUserName__c,HPConfirmDate__c,endConfirmDate__c,Hospital_Name_Text__c,CustomerNameContract__c,agencySignUpDate__c,skip_Hospital_Sign__c,skip_Distribution_Sign__c,skip_Distribution_Sign_Message__c, skip_Hospital_Sign_Message__c '; |
| | | sql +=' from eSignForm__c '; |
| | | //当isProcessed__c 为true的时候,工作流更新日期 所以不会有日期为null并且还打勾的情况 |
| | | sql +=' where (isProcessed__c = false or (isProcessed__c = true and endConfirmDate__c >: todate)) '; |
| | | sql +=' where (isProcessed__c = false or (isProcessed__c = true and endConfirmDate__c >=: todate)) '; |
| | | |
| | | //退货则不被检索 |
| | | //sql +=' and ReturnMark__c = false '; |
| | |
| | | } |
| | | system.debug('ceshi4+++'+tempEsignFormList); |
| | | if(tempEsignFormList.size() > 0){ |
| | | //fy 20220727 start |
| | | List<Id> eSignFormId = new List<Id>(); |
| | | for(eSignForm__c es:tempEsignFormList){ |
| | | eSignFormId.add(es.Id); |
| | | } |
| | | List<Attachment> AttachmentList= new List<Attachment>(); |
| | | AttachmentList =[select Id,name,ParentId from Attachment where ParentId in:eSignFormId]; |
| | | Map<String,String> AttachmentMap = new Map<String,String>(); |
| | | List<String> AttachmentStringList = new List<String>(); |
| | | if(AttachmentList.size() > 0){ |
| | | for(Attachment Att:AttachmentList){ |
| | | AttachmentMap.put(Att.ParentId, Att.ParentId+'_'+Att.name); |
| | | } |
| | | for (String value : AttachmentMap.values()) { |
| | | AttachmentStringList.add(value); |
| | | } |
| | | } |
| | | |
| | | system.debug('ceshi1+++'+AttachmentList); |
| | | system.debug('ceshi2+++'+AttachmentStringList); |
| | | system.debug('ceshi3+++'+eSignFormId); |
| | | //fy 20220727 end |
| | | for(eSignForm__c esf:tempEsignFormList){ |
| | | if(esf.endUser__c =='契約'){ |
| | | esf.Hospital_Name_Text__c = esf.CustomerNameContract__c; |
| | |
| | | } |
| | | } |
| | | eWList.eSignFormList = tempEsignFormList; |
| | | //fy 20220727 start |
| | | if(AttachmentStringList.size()>0){ |
| | | eWList.AttachmentStringList = AttachmentStringList; |
| | | } |
| | | //fy 20220727 end |
| | | }else{ |
| | | eWList.eSignFormList = null; |
| | | } |
| | |
| | | |
| | | @AuraEnabled |
| | | public List<eSignForm__c> eSignFormList; |
| | | //fy 20220727 start |
| | | @AuraEnabled |
| | | public List<String> AttachmentStringList; |
| | | //fy 20220727 end |
| | | public eSignWrapperList(){ |
| | | eSignFormEntryList = new List<eSignFormEntry__c>(); |
| | | eSignFormList = new List<eSignForm__c>(); |
| | | //fy 20220727 start |
| | | List<String> AttachmentStringList = new List<String>(); |
| | | //fy 20220727 end |
| | | } |
| | | |
| | | } |