| | |
| | | trigger AttachmentTrigger on Attachment (before insert,after insert,before delete,after delete) { |
| | | trigger AttachmentTrigger on Attachment (before insert,after insert,before delete,after delete, before update, after update) { |
| | | List<String> rentalIds = new List<String>(); |
| | | List<String> attIds = new List<String>(); |
| | | List<String> rentaldelIds = new List<String>(); |
| | | List<String> attdelIds = new List<String>(); |
| | | List<String> rentalApplyIds = new List<String>(); |
| | | List<String> accIds = new List<String>(); |
| | | //20221014 yc 医院审批优化 start |
| | | List<String> accAppIds = new List<String>(); |
| | | //20221014 yc 医院审批优化 end |
| | | // LHJ CHAN-BCLD4P 20190618 Start |
| | | List<String> specIds = new List<String>(); |
| | | List<String> specDelIds = new List<String>(); |
| | |
| | | List<String> OpporFileIds = new List<String>(); |
| | | Map<String,String> OpporFileUndeleteMap = new Map<String,String>(); |
| | | List<String> DeleteReIds = new List<String>(); |
| | | Map<String,String> OppordeleteReUserMap = new Map<String,String>(); |
| | | Map<String,String> OppordeleteReUserMap = new Map<String,String>(); |
| | | Map<String,Datetime> OppordeleteReTimeMap = new Map<String,Datetime>(); |
| | | //CHAN-BCNCRB ---XHL----Start----- |
| | | List<String> opportunity_FileIds = new List<String>(); |
| | |
| | | List<String> opportunityFileOrderIds = new List<String>(); |
| | | List<String> oFOrderIds = new List<String>(); |
| | | Map<String,Boolean> oFOrderIdMap = new Map<String,Boolean>(); |
| | | |
| | | // sx 20230210start 备品借出申请故障报告附件提取 |
| | | List<String> rentalApplyFaultIds = new List<String>(); |
| | | Map<String,List<Id>> trentalImages = new Map<String,List<Id>>(); |
| | | List<String> rentaldeleteApplyFaultIds = new List<String>(); |
| | | Map<String,List<Id>> deleteImages = new Map<String,List<Id>>(); |
| | | // sx 20230210end 备品借出申请故障报告附件提取 |
| | | |
| | | if (Trigger.isBefore && Trigger.isInsert) { |
| | | for (Attachment att : Trigger.new) { |
| | | if(String.valueOf(att.ParentId).startsWith(System.Label.Oppor_sepKey)){ |
| | |
| | | if (String.valueOf(att.ParentId).startsWith('001')) { |
| | | accIds.add(att.ParentId); |
| | | } |
| | | //20221014 yc 医院审批优化 start |
| | | if (String.valueOf(att.ParentId).startsWith('a5C') || String.valueOf(att.ParentId).startsWith('a5A')) { |
| | | accAppIds.add(att.ParentId); |
| | | } |
| | | //20221014 yc 医院审批优化 end |
| | | if(String.valueOf(att.ParentId).startsWith(System.Label.Oppor_sepKey)){ |
| | | OpporFileIds.add(att.ParentId); |
| | | } |
| | |
| | | oFOrderIds.add(att.ParentId); |
| | | oFOrderIdMap.put(att.ParentId,true); |
| | | } |
| | | |
| | | //2023-2-10 sx备品 备品检测分析报告 start |
| | | Id cid = att.ParentId; |
| | | String parentLabel = cid.getSObjectType().getDescribe().getName(); |
| | | if(parentLabel.equals('Rental_Apply_Fault__c')){ |
| | | rentalApplyFaultIds.add(att.ParentId); |
| | | if(trentalImages.containskey(att.ParentId)){ |
| | | trentalImages.get(att.ParentId).add(att.Id); |
| | | }else{ |
| | | List<Id> temp = new List<Id>(); |
| | | temp.add(att.Id); |
| | | trentalImages.put(att.ParentId,temp); |
| | | } |
| | | } |
| | | //2023-2-10 sx备品 备品检测分析报告 end |
| | | } |
| | | } |
| | | if (Trigger.isBefore && Trigger.isDelete) { |
| | | List<Attachment> attDeleteList = new List<Attachment>(); |
| | | for (Attachment att : Trigger.old) { |
| | | //if (att.Name.toUpperCase() == '合同书.PDF' && String.valueOf(att.ParentId).startsWith('a0t')) { |
| | | // 添付した契約書のファイル名は指定できない |
| | |
| | | oFOrderIds.add(att.ParentId); |
| | | oFOrderIdMap.put(att.ParentId,false); |
| | | } |
| | | //2023-2-10 sx备品 备品检测分析报告 start |
| | | Id cid = att.ParentId; |
| | | String parentLabel = cid.getSObjectType().getDescribe().getName(); |
| | | if(parentLabel.equals('Rental_Apply_Fault__c')){ |
| | | rentaldeleteApplyFaultIds.add(att.ParentId); |
| | | attDeleteList.add(att); |
| | | if(deleteImages.containskey(att.ParentId)){ |
| | | deleteImages.get(att.ParentId).add(att.Id); |
| | | }else{ |
| | | List<Id> temp = new List<Id>(); |
| | | temp.add(att.Id); |
| | | deleteImages.put(att.ParentId,temp); |
| | | } |
| | | } |
| | | //2023-2-10 sx备品 备品检测分析报告 end |
| | | } |
| | | //2023-2-10 sx备品 备品检测分析报告 start |
| | | List<Rental_Apply_Fault__c> rafList = [SELECT Id, Name FROM Rental_Apply_Fault__c WHERE Id IN: rentaldeleteApplyFaultIds AND (status__c = '已发送' OR status__c = '已反馈')]; |
| | | for (Rental_Apply_Fault__c raf : rafList) { |
| | | for (Attachment att : attDeleteList) { |
| | | if (att.ParentId == raf.Id) { |
| | | att.addError('非草案中的检测分析报告不允许删除已上传的故障图片'); |
| | | } |
| | | } |
| | | } |
| | | //2023-2-10 sx备品 备品检测分析报告 end |
| | | } |
| | | if (Trigger.isAfter && Trigger.isDelete) { |
| | | for (Attachment att : Trigger.old) { |
| | |
| | | specIds.add(att.ParentId); |
| | | } |
| | | // LHJ CHAN-BCLD4P 20190618 End |
| | | //20221014 yc 医院审批优化 start |
| | | if (String.valueOf(att.ParentId).startsWith('a5C') || String.valueOf(att.ParentId).startsWith('a5A')) { |
| | | accAppIds.add(att.ParentId); |
| | | } |
| | | //20221014 yc 医院审批优化 end |
| | | } |
| | | } |
| | | //20221207 lt 医院审批优化 start |
| | | if (Trigger.isAfter && Trigger.isUpdate) { |
| | | for (Attachment att : Trigger.old) { |
| | | if (String.valueOf(att.ParentId).startsWith('a5C') || String.valueOf(att.ParentId).startsWith('a5A')) { |
| | | accAppIds.add(att.ParentId); |
| | | } |
| | | |
| | | |
| | | if (String.valueOf(att.ParentId).startsWith('001')) { |
| | | accIds.add(att.ParentId); |
| | | } |
| | | } |
| | | } |
| | | //20221207 lt 医院审批优化 start |
| | | //2023-2-10 sx备品 备品检测分析报告 start |
| | | if(rentalApplyFaultIds.size() > 0){ |
| | | List<Rental_Apply_Fault__c> renList = [SELECT Id,AttachmentId1__c,AttachmentId2__c from Rental_Apply_Fault__c where Id in :rentalApplyFaultIds]; |
| | | |
| | | system.debug('updrentalApplyFaultList====='+renList); |
| | | for(Rental_Apply_Fault__c ren : renList){ |
| | | if(trentalImages.containskey(ren.Id)){ |
| | | if (ren.AttachmentId1__c == null) { |
| | | ren.AttachmentId1__c = trentalImages.get(ren.id)[0]; |
| | | } else if(ren.AttachmentId2__c == null) { |
| | | ren.AttachmentId2__c = trentalImages.get(ren.id)[0]; |
| | | } |
| | | } |
| | | } |
| | | system.debug('updrentalApplyFaultList====='+renList); |
| | | UPDATE renList; |
| | | } |
| | | |
| | | if(rentaldeleteApplyFaultIds.size() > 0){ |
| | | List<Rental_Apply_Fault__c> renList = [SELECT Id,AttachmentId1__c,AttachmentId2__c from Rental_Apply_Fault__c where Id in :rentaldeleteApplyFaultIds]; |
| | | |
| | | system.debug('renList====='+renList); |
| | | for(Rental_Apply_Fault__c ren : renList){ |
| | | if(deleteImages.containskey(ren.Id)){ |
| | | |
| | | if(deleteImages.get(ren.Id).contains(ren.AttachmentId1__c)){ |
| | | ren.AttachmentId1__c = ''; |
| | | } |
| | | if(deleteImages.get(ren.Id).contains(ren.AttachmentId2__c)){ |
| | | ren.AttachmentId2__c = ''; |
| | | } |
| | | } |
| | | } |
| | | system.debug('renList====='+renList); |
| | | UPDATE renList; |
| | | } |
| | | //2023-2-10 sx备品 备品检测分析报告 end |
| | | |
| | | if (rentaldelIds.size() > 0) { |
| | | List<Consumable_accessories_invoice__c> rentaldelList = new List<Consumable_accessories_invoice__c>(); |
| | | for (Consumable_accessories_invoice__c ra : [select Id from Consumable_accessories_invoice__c where Invoice_code__c in :rentaldelIds and Attachment_ID__c in :attdelIds]) { |
| | |
| | | attMap.put(att.ParentId, att.ParentId); |
| | | } |
| | | List<Account> updAccList = new List<Account>(); |
| | | |
| | | //20221207 lt 医院审批优化 start |
| | | List<Account> accList = [select id,Name, |
| | | Is_Active__c |
| | | from Account |
| | | where id in:accIds ]; |
| | | //20221207 lt 医院审批优化 end |
| | | |
| | | for (String accid : accIds) { |
| | | Account acc = new Account(Id = accid); |
| | | acc.Is_upload_file__c = attMap.containsKey(accid); |
| | | updAccList.add(acc); |
| | | if(accList.size() > 0){ |
| | | // Account acc = new Account(Id = accid); |
| | | //20221207 lt 医院审批优化 start |
| | | for(Account acc : accList){ |
| | | if(Trigger.isUpdate && Trigger.isAfter){ |
| | | for(Attachment att : Trigger.New){ |
| | | System.debug('lt123---更新---状态---'+acc.Is_Active__c); |
| | | if(attMap.containsKey(att.ParentID) && acc.Is_Active__c != '草案中'){ |
| | | System.debug('lt123---草案中---'); |
| | | att.addError('非草案中,附件不允许编辑。'); |
| | | |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | |
| | | if(Trigger.isDelete && (Trigger.isBefore || Trigger.isAfter)){ |
| | | for(Attachment att : Trigger.old){ |
| | | // if(attMap.containsKey(att.ParentID) && acc.Is_Active__c != '草案中'){ |
| | | if(acc.Is_Active__c != '草案中'){ |
| | | att.addError('非草案中,附件不允许删除。'); |
| | | |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | acc.Is_upload_file__c = attMap.containsKey(accid); |
| | | updAccList.add(acc); |
| | | } |
| | | } |
| | | //20221207 lt 医院审批优化 end |
| | | } |
| | | |
| | | // for (String accid : accIds) { |
| | | // Account acc = new Account(Id = accid); |
| | | // acc.Is_upload_file__c = attMap.containsKey(accid); |
| | | // updAccList.add(acc); |
| | | // } |
| | | if (updAccList.size() > 0) update updAccList; |
| | | } |
| | | //20221014 yc 医院审批优化 start |
| | | if (accAppIds.size() > 0) { |
| | | Map<String, String> attMap = new Map<String, String>(); |
| | | List<Attachment> attList = [select Id, ParentId from Attachment where ParentId = :accAppIds order by ParentId]; |
| | | for (Attachment att : attList) { |
| | | attMap.put(att.ParentId, att.ParentId); |
| | | } |
| | | List<Account_Delay_Apply__c> updAccAppList = new List<Account_Delay_Apply__c>(); |
| | | |
| | | //20221207 lt 医院审批优化 start |
| | | List<Account_Delay_Apply__c> adaList = [select id,Name, |
| | | Is_Active__c |
| | | from Account_Delay_Apply__c |
| | | where id in:accAppIds ]; |
| | | //20221207 lt 医院审批优化 end |
| | | |
| | | for (String accappid : accAppIds) { |
| | | if(adaList.size() > 0){ |
| | | // Account_Delay_Apply__c accapp = new Account_Delay_Apply__c(Id = accappid); |
| | | //20221207 lt 医院审批优化 start |
| | | |
| | | for(Account_Delay_Apply__c accapp : adaList){ |
| | | if(Trigger.isUpdate && Trigger.isAfter){ |
| | | for(Attachment att : Trigger.New){ |
| | | if(attMap.containsKey(att.ParentID) && accapp.Is_Active__c != '草案中'){ |
| | | att.addError('非草案中,附件不允许编辑。'); |
| | | |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | if(Trigger.isDelete){ |
| | | for(Attachment att : Trigger.old){ |
| | | // if(attMap.containsKey(att.ParentID) && accapp.Is_Active__c != '草案中'){ |
| | | if(accapp.Is_Active__c != '草案中'){ |
| | | att.addError('非草案中,附件不允许删除。'); |
| | | |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | accapp.Is_upload_file__c = attMap.containsKey(accappid); |
| | | updAccAppList.add(accapp); |
| | | } |
| | | |
| | | } |
| | | |
| | | //20221207 lt 医院审批优化 end |
| | | |
| | | } |
| | | if (updAccAppList.size() > 0) update updAccAppList; |
| | | } |
| | | //20221014 yc 医院审批优化 end |
| | | |
| | | // LHJ CHAN-BCLD4P 20190618 Start |
| | | if (specIds.size() > 0) { |
| | | |
| | |
| | | |
| | | } |
| | | } |
| | | |
| | | } |