trigger AttachmentTrigger on Attachment (before insert,after insert,before delete,after delete) {
|
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>();
|
// LHJ CHAN-BCLD4P 20190618 Start
|
List<String> specIds = new List<String>();
|
List<String> specDelIds = new List<String>();
|
// LHJ CHAN-BCLD4P 20190618 End
|
|
// 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 备品借出申请故障报告附件提取
|
|
// MZY SWAG-BXXBKA 2021-02-19 start
|
List<String> opdIds = new List<String>();
|
Map<String,String> opdMap = new Map<String,String>();
|
// MZY SWAG-BXXBKA 2021-02-19 end
|
|
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,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>();
|
if (Trigger.isBefore && Trigger.isInsert) {
|
for (Attachment att : Trigger.new) {
|
if(String.valueOf(att.ParentId).startsWith(System.Label.Oppor_sepKey)){
|
opportunity_FileIds.add(att.ParentId);
|
}
|
|
if(String.valueOf(att.ParentId).startsWith('a3Z')){
|
opportunityFileOrderIds.add(att.ParentId);
|
}
|
}
|
}
|
//CHAN-BCNCRB ---XHL----End-----
|
if (Trigger.isAfter && Trigger.isInsert) {
|
for (Attachment att : Trigger.new) {
|
//if (att.Name.toUpperCase() == '合同书.PDF' && String.valueOf(att.ParentId).startsWith('a0t')) {
|
// 添付した契約書のファイル名は指定できない
|
if (String.valueOf(att.ParentId).startsWith('a2K')) {
|
rentalIds.add(att.ParentId);
|
attIds.add(att.Id);
|
}
|
if (String.valueOf(att.ParentId).startsWith('a0t')) {
|
rentalApplyIds.add(att.ParentId);
|
}
|
if (String.valueOf(att.ParentId).startsWith('001')) {
|
accIds.add(att.ParentId);
|
}
|
if(String.valueOf(att.ParentId).startsWith(System.Label.Oppor_sepKey)){
|
OpporFileIds.add(att.ParentId);
|
}
|
// LHJ CHAN-BCLD4P 20190618 Start
|
if(String.valueOf(att.ParentId).startsWith(System.Label.OppSpecialApply)){
|
specIds.add(att.ParentId);
|
}
|
// LHJ CHAN-BCLD4P 20190618 End
|
|
// MZY SWAG-BXXBKA 2021-02-19 start
|
if(String.valueOf(att.ParentId).startsWith('a3E')){
|
opdIds.add(att.ParentId);
|
opdMap.put(att.ParentId,att.Name);
|
}
|
// MZY SWAG-BXXBKA 2021-02-19 end
|
|
if(String.valueOf(att.ParentId).startsWith('a3Z')){
|
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')) {
|
// 添付した契約書のファイル名は指定できない
|
if (String.valueOf(att.ParentId).startsWith('a2K')) {
|
rentaldelIds.add(att.ParentId);
|
attdelIds.add(att.Id);
|
}
|
if(String.valueOf(att.ParentId).startsWith(System.Label.Oppor_sepKey)){
|
OpporFileIds.add(att.ParentId);
|
}
|
// LHJ CHAN-BCLD4P 20190618 Start
|
if(String.valueOf(att.ParentId).startsWith(System.Label.OppSpecialApply)){
|
specDelIds.add(att.ParentId);
|
}
|
// LHJ CHAN-BCLD4P 20190618 End
|
if(String.valueOf(att.ParentId).startsWith('a3Z')){
|
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) {
|
if (String.valueOf(att.ParentId).startsWith('001')) {
|
accIds.add(att.ParentId);
|
}
|
// LHJ CHAN-BCLD4P 20190618 Start
|
if(String.valueOf(att.ParentId).startsWith(System.Label.OppSpecialApply)){
|
specIds.add(att.ParentId);
|
}
|
// LHJ CHAN-BCLD4P 20190618 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]) {
|
rentaldelList.add(ra);
|
}
|
ControllerUtil.delConsumableAccessoriesInvoiceSet(rentaldelList);
|
}
|
|
if (rentalIds.size() > 0) {
|
List<Consumable_order__c> rentalList = new List<Consumable_order__c>();
|
for (Consumable_order__c ra : [select Id from Consumable_order__c where Id in :rentalIds]) {
|
ra.Consumable_pdf_insert_day__c = Date.today();
|
ra.Order_Attachment__c = attIds[0];
|
//ra.Order_status__c = '录入完成';
|
//ra.Contract_pdf_updated__c = true;
|
rentalList.add(ra);
|
}
|
ControllerUtil.updRentalApplyList(rentalList);
|
}
|
if (rentalApplyIds.size() > 0) {
|
List<Rental_Apply__c> rentalApplyList = new List<Rental_Apply__c>();
|
for (Rental_Apply__c ra : [select Id from Rental_Apply__c where Id in :rentalApplyIds]) {
|
ra.Contract_pdf_update_day__c = Date.today();
|
ra.Contract_pdf_updated__c = true;
|
rentalApplyList.add(ra);
|
}
|
ControllerUtil.updRentalApplyList(rentalApplyList);
|
}
|
|
|
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;
|
}
|
|
if (accIds.size() > 0) {
|
Map<String, String> attMap = new Map<String, String>();
|
List<Attachment> attList = [select Id, ParentId from Attachment where ParentId = :accIds order by ParentId];
|
for (Attachment att : attList) {
|
attMap.put(att.ParentId, att.ParentId);
|
}
|
List<Account> updAccList = new List<Account>();
|
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;
|
}
|
// LHJ CHAN-BCLD4P 20190618 Start
|
if (specIds.size() > 0) {
|
|
Map<String, String> attMap = new Map<String, String>();
|
List<Attachment> attList = [select Id, ParentId from Attachment where ParentId = :specIds order by ParentId];
|
for (Attachment att : attList) {
|
attMap.put(att.ParentId, att.ParentId);
|
}
|
List<OpportunitySpecialApply__c> updSpecList = new List<OpportunitySpecialApply__c>();
|
for (String specId : specIds) {
|
OpportunitySpecialApply__c spec = new OpportunitySpecialApply__c(Id = specId);
|
spec.Is_upload_file__c = attMap.containsKey(specId);
|
updSpecList.add(spec);
|
}
|
if (updSpecList.size() > 0) update updSpecList;
|
}
|
// LHJ CHAN-BCLD4P 20190618 End
|
|
// MZY SWAG-BXXBKA 2021-02-19 start
|
System.debug('SWAG-BXXBKA start');
|
if (opdIds.size()>0) {
|
List<OPDPlan__c> updateOPDs = new List<OPDPlan__c>();
|
|
OPDPlan__c tempOPD = new OPDPlan__c();
|
for (String i :opdIds ) {
|
tempOPD.id = i;
|
tempOPD.AttachmentCertificate__c = opdMap.get(i);
|
updateOPDs.add(tempOPD);
|
}
|
System.debug('临时OPD :'+tempOPD);
|
if (updateOPDs.size()>0){
|
update updateOPDs;
|
}
|
}
|
System.debug('SWAG-BXXBKA end');
|
// MZY SWAG-BXXBKA 2021-02-19 end
|
|
if(OpporFileIds.size()>0){
|
List<Opportunity_File__c> OpporList = [select id,Last_upload_time__c,
|
Is_Locked__c,
|
Last_upload_user__c,
|
Stock_apply_time__c
|
from Opportunity_File__c
|
where id
|
in:OpporFileIds ];
|
if(OpporList.size()>0){
|
for(Opportunity_File__c ofc : OpporList){
|
if(!ofc.Is_Locked__c){
|
ofc.Last_upload_user__c = UserInfo.getUserId();
|
ofc.Last_upload_time__c = System.now();
|
System.debug(ofc+'23333');
|
}else{
|
OpporFileUndeleteMap.put(ofc.id,ofc.id);
|
System.debug(ofc+'23333444444');
|
}
|
}
|
update OpporList;
|
}
|
}
|
System.debug(Trigger.isDelete+'Trigger.isDelete');
|
System.debug(Trigger.isBefore+'Trigger.isBefore');
|
|
|
|
if(Trigger.isDelete && Trigger.isBefore){
|
for(Attachment att : Trigger.old){
|
if(OpporFileUndeleteMap.containsKey(att.ParentID)){
|
att.addError('备货已审批，不可删除附件');
|
|
return;
|
}else{
|
}
|
}
|
}
|
if(Trigger.isDelete && Trigger.isAfter){
|
for(Attachment att : Trigger.old){
|
if(OpporFileUndeleteMap.containsKey(att.ParentID)){
|
att.addError('备货已审批，不可删除附件');
|
|
return;
|
}else{
|
DeleteReIds.add(att.ParentId);
|
}
|
}
|
}
|
|
|
if(Trigger.isInsert){
|
for(Attachment att : Trigger.new){
|
if(OpporFileUndeleteMap.containsKey(att.ParentID)){
|
att.addError('备货已审批，不可删除附件');
|
|
return;
|
}else{
|
DeleteReIds.add(att.ParentId);
|
}
|
}
|
}
|
List<Attachment> atcList = [select id,ParentId,createddate,createdbyid from Attachment where ParentId in:DeleteReIds];
|
System.debug(DeleteReIds+'222222222222');
|
if(atcList.size()>0){
|
for(String ids : DeleteReIds){
|
for(Attachment atc : atcList){
|
if(OppordeleteReTimeMap.containsKey(ids)){
|
if(atc.createddate > OppordeleteReTimeMap.get(ids)){
|
OppordeleteReTimeMap.put(ids,atc.createddate);
|
OppordeleteReUserMap.put(ids,atc.createdbyid);
|
}else{
|
continue;
|
}
|
}else{
|
OppordeleteReTimeMap.put(ids,atc.createddate);
|
OppordeleteReUserMap.put(ids,atc.createdbyid);
|
}
|
}
|
}
|
|
|
List<Opportunity_File__c> reDateList = [select id,Last_upload_time__c,
|
Is_Locked__c,
|
Last_upload_user__c
|
from Opportunity_File__c
|
where id
|
in:DeleteReIds ];
|
if(reDateList.size()>0){
|
for(Opportunity_File__c ofc : reDateList){
|
ofc.Last_upload_time__c = OppordeleteReTimeMap.get(ofc.id);
|
ofc.Last_upload_user__c = OppordeleteReUserMap.get(ofc.id);
|
System.debug(ofc+'233333333');
|
}
|
update reDateList;
|
}
|
}else{
|
List<Opportunity_File__c> reDateList = [select id,Last_upload_time__c,
|
Is_Locked__c,
|
Last_upload_user__c
|
from Opportunity_File__c
|
where id
|
in:DeleteReIds ];
|
if(reDateList.size()>0){
|
for(Opportunity_File__c ofc : reDateList){
|
ofc.Last_upload_time__c = null;
|
ofc.Last_upload_user__c = null;
|
}
|
update reDateList;
|
}
|
}
|
//CHAN-BCNCRB ---XHL----Start-----
|
if (opportunity_FileIds.size() > 0) {
|
List<Opportunity_File__c> opporList = [select id,Last_upload_time__c,
|
Is_Locked__c,
|
Last_upload_user__c,
|
Stock_apply_time__c,
|
Oppor_File_Stage__c
|
from Opportunity_File__c
|
where id in:opportunity_FileIds And Oppor_File_Stage__c = 'G'];
|
List<String> ofIds = new List<String>();
|
if (opporList.size() > 0) {
|
|
for (Opportunity_File__c oppf : opporList) {
|
ofIds.add(oppf.Id);
|
}
|
|
if (ofIds.size() > 0 ) {
|
List<Attachment> atcList = [select id,ParentId,createddate,createdbyid from Attachment where ParentId in:ofIds];
|
|
if (atcList.size() > 0) {
|
delete atcList;
|
}
|
}
|
|
|
}
|
}
|
//CHAN-BCNCRB ---XHL----End-----
|
|
|
if (opportunityFileOrderIds.size() > 0) {
|
List<OpportunityFileOrder__c> ofoList = [select id,
|
OpporFileStage__c
|
from OpportunityFileOrder__c
|
where Id in:opportunityFileOrderIds And OpporFileStage__c = 'G'];
|
List<String> ofoIds = new List<String>();
|
if (ofoList.size() > 0) {
|
|
for (OpportunityFileOrder__c ofo : ofoList) {
|
ofoIds.add(ofo.Id);
|
}
|
|
if (ofoIds.size() > 0 ) {
|
List<Attachment> atcList = [select id,ParentId,createddate,createdbyid from Attachment where ParentId in:ofoIds];
|
|
if (atcList.size() > 0) {
|
delete atcList;
|
}
|
}
|
|
|
}
|
}
|
|
if (oFOrderIdMap.size() > 0) {
|
|
List<OpportunityFileOrder__c> oFOrderList = [select Id,Name,LatestUploadUser__c,LatestUploadTime__c
|
from OpportunityFileOrder__c
|
where Id In : oFOrderIdMap.keySet()];
|
if (oFOrderList.size() > 0 ) {
|
|
for (OpportunityFileOrder__c oFOrder :oFOrderList) {
|
|
if (oFOrderIdMap.get(oFOrder.Id)) {
|
oFOrder.LatestUploadUser__c = UserInfo.getUserId();
|
oFOrder.LatestUploadTime__c = System.now();
|
} else if (oFOrderIdMap.get(oFOrder.Id) == false){
|
oFOrder.LatestUploadUser__c = null;
|
oFOrder.LatestUploadTime__c = null;
|
}
|
}
|
|
update oFOrderList;
|
|
}
|
}
|
}
|
