trigger RentalApplyTrigger on Rental_Apply__c (before insert, before update,after insert,after update,after delete) {
|
if(Test.isRunningTest()||UserInfo.getUserId()!=System.Label.ByPassTrigger){
|
RentalApplyTriggerHandler handler = new RentalApplyTriggerHandler();
|
handler.run();
|
|
// ----------------------------------------------------------------------
|
// ここより、承認プロセス用に、经理、部长、总监を更新する
|
// ----------------------------------------------------------------------
|
//修理set
|
//LD 20200819 因备品出借可视化管理注释以下代码 Start
|
//Set<String> repairSet = new Set<String>();
|
|
|
//bp2 List<id> idlistLocal = new List<id>();
|
//bp2 Map<id,List<Rental_Apply_Equipment_Set__c>> AllDetailsMaps = new Map<id,List<Rental_Apply_Equipment_Set__c>>();
|
|
if (Trigger.isBefore) {
|
// OLY_OCM-584 Start 移动到Handler
|
// 申請中かどうかのチェック
|
// List<Id> copyUserIds = new List<Id>(); // 件数は Trigger.New と同じ
|
// List<Rental_Apply__c> newList = new List<Rental_Apply__c>(); // 件数は Trigger.New と同じ
|
// OLY_OCM-584 End
|
Rental_Apply__c old = null;
|
List<String> personInChargeIds = new List<String>();
|
//bp2
|
// for(Rental_Apply__c local : Trigger.New){
|
// if(local.id != null){
|
// idlistLocal.add(local.id);
|
// }
|
// }
|
// List<Rental_Apply_Equipment_Set__c> AllDetails = new List<Rental_Apply_Equipment_Set__c>();
|
// AllDetails = [select Name,Rental_Apply__c,Equipment_Set__r.Name,Equipment_Set__r.Loaner_code__c,SerialNumber__c from Rental_Apply_Equipment_Set__c
|
// where Rental_Apply__c in: idlistLocal
|
// and Inspection_before__c!='NG'
|
// and RAES_Status__c != '引当済'
|
// and RAES_Status__c != '取消分配'];
|
// for(Rental_Apply_Equipment_Set__c raes : AllDetails){
|
// if(AllDetailsMaps.containsKey(raes.Rental_Apply__c)){
|
// List<Rental_Apply_Equipment_Set__c> raseList = AllDetailsMaps.get(raes.Rental_Apply__c);
|
// raseList.add(raes);
|
// }else{
|
// List<Rental_Apply_Equipment_Set__c> raseList = new List<Rental_Apply_Equipment_Set__c>();
|
// raseList.add(raes);
|
// AllDetailsMaps.put(raes.Rental_Apply__c, raseList);
|
// }
|
// }
|
for (Rental_Apply__c local : Trigger.New) {
|
if ( Trigger.isUpdate) {
|
old = Trigger.oldMap.get(local.Id);
|
}
|
|
// 主担当をOwnerIdにします
|
// if (local.Person_In_Charge__c != null) local.OwnerId = local.Person_In_Charge__c;
|
|
// 黑名单用户不能提交申请 OCSM_BP3-10: 去掉"犯规点数超过Max的时候不能申请"的限制条件。【EquipmentRentalBlackList为999999999的时候, 事实上就是不check 】
|
if (trigger.isUpdate
|
&& local.Foul_Points__c >= Integer.valueOf(System.Label.EquipmentRentalBlackList)
|
&& local.demo_purpose2__c !='索赔QIS' //使犯规也要通过
|
// 申请中 防止change owner
|
&& (local.Status__c == FixtureUtil.raStatusMap.get(FixtureUtil.RaStatus.Shen_Qing_Zhong.ordinal())
|
&& old.OwnerId != local.OwnerId
|
)
|
&& System.Label.ProfileId_GPI_IF != UserInfo.getProfileId()) {
|
local.addError('已超期借用备品过多，不能提交备品借出申请。备品借出申请：' + local.Name);
|
}
|
// 去掉"犯规点数超过Max的时候不能申请"的限制条件。【EquipmentRentalBlackList_ChangeOwner_Threshold为999999999的时候, 事实上就是不check 】
|
if (trigger.isUpdate
|
&& local.Foul_Points__c >= Integer.valueOf(System.Label.EquipmentRentalBlackList_ChangeOwner_Threshold)
|
&& local.demo_purpose2__c !='索赔QIS' //使犯规也要通过
|
// OLY_OCM-398
|
&& (old.Status__c != FixtureUtil.raStatusMap.get(FixtureUtil.RaStatus.Tian_Xie_Wan_Bi.ordinal())
|
&& local.Status__c == FixtureUtil.raStatusMap.get(FixtureUtil.RaStatus.Tian_Xie_Wan_Bi.ordinal())
|
)
|
&& System.Label.ProfileId_GPI_IF != UserInfo.getProfileId()) {
|
local.addError('已超期借用备品过多，不能提交备品借出申请。备品借出申请：' + local.Name);
|
}
|
|
//*************************Create 20160615 No.153 趙徳芳 Start*************************//
|
//bp2
|
// //更新出库富文本
|
// if((Trigger.isUpdate||Trigger.isInsert)
|
// &&(local.Shipment_requested_cnt__c!=null
|
// &&local.Pre_inspection_ng_num__c!=null
|
// &&local.Rental_Apply_Equipment_Set_Cnt__c!=null
|
// &&local.Rental_Apply_Equipment_Set_Cnt__c!=0)){
|
// local.Notice_of_Delivery_Text__c = '出库通知：<BR> 已出库条数：'
|
// + (local.Shipment_requested_cnt__c - local.Shippment_ng_num__c)
|
// + '<BR>明细共：'
|
// + local.Rental_Apply_Equipment_Set_Cnt__c
|
// + '条。<BR>';
|
// }
|
// //更新全部出库邮件通知文本
|
// List<Rental_Apply_Equipment_Set__c> AllDetails = new List<Rental_Apply_Equipment_Set__c>();
|
// AllDetails = [select Name, Fixture_Set__r.Name, Fixture_Set__r.Loaner_code__c, First_RAESD__r.SerialNumber_F__c
|
// from Rental_Apply_Equipment_Set__c
|
// where Rental_Apply__c =: local.id
|
// and Inspection_before__c!='NG'
|
// and Cancel_Select__c = False
|
// and RAES_Status__c != '引当済'
|
// and RAES_Status__c != '取消分配'];
|
// system.debug('这是所有明细::::::::'+AllDetails);
|
// system.debug('这是所有::::::::'+local.id);
|
// if (AllDetails.size() > 0) {
|
// local.Assigned_Text__c = '<br/>具体明细：<br/> ';
|
// for(Rental_Apply_Equipment_Set__c raesMail : AllDetails){
|
// local.Assigned_Text__c = local.Assigned_Text__c
|
// + raesMail.Fixture_Set__r.Name + ' '
|
// + ' 型号: ' + raesMail.Fixture_Set__r.Loaner_code__c
|
// +' 机身编号：'+( raesMail.First_RAESD__r.SerialNumber_F__c!=null? raesMail.First_RAESD__r.SerialNumber_F__c:'')+
|
// + '<br/>';
|
// }
|
// }else{
|
// local.Assigned_Text__c = '<br/>无可以出库的备品<br/> ';
|
// }
|
//*************************Create 20160615 No.153 趙徳芳 End***************************//
|
// OLY_OCM-584 Start 移动到Handler
|
// 申請中になったとき、申請者上司を設定
|
// if (Trigger.isInsert
|
// || (Trigger.isUpdate && old.Status__c != local.Status__c && local.Status__c == '申请中')
|
// || (Trigger.isUpdate && old.OwnerId != local.OwnerId)
|
// ) {
|
// newList.add(local);
|
// //if (Trigger.isInsert || (Trigger.isUpdate && old.applyUser__c != local.applyUser__c)) {
|
// copyUserIds.add(local.OwnerId);
|
// //} else {
|
// // copyUserIds.add(UserInfo.getUserId());
|
// //}
|
// }
|
// OLY_OCM-584 End
|
//*************************SWAG-AZNAER 20180627 Start*************************//
|
personInChargeIds.add(local.Person_In_Charge__c);
|
}
|
if (System.Test.isRunningTest() && trigger.isUpdate) {
|
} else {
|
Map<Id, User> personInChargeMap = new Map<Id, User>([
|
SELECT Id, Name, OCM_man_province_Rental__c, Dept__c FROM User WHERE Id IN :personInChargeIds
|
]);
|
// 20220517 ljh SWAG-CDTEFS update start
|
// List<OCM_Management_Province__c> mpList = [select id, Name, Admin_assistant__c, Admin_assistant2__c, Admin_assistant3__r.Name, Energy_assistant__c from OCM_Management_Province__c];
|
List<OCM_Management_Province__c> mpList = [select id, Name, Admin_assistant__c, Admin_assistant2__c, Admin_assistant3__r.Name, Energy_assistant__c,OBA3_Email_Group__c from OCM_Management_Province__c];
|
Map<String, OCM_Management_Province__c> mpMap = new Map<String, OCM_Management_Province__c>();
|
for (OCM_Management_Province__c mp : mpList) {
|
mpMap.put(mp.Name, mp);
|
}
|
for (Rental_Apply__c rac : Trigger.New) {
|
if (personInChargeMap.containsKey(rac.Person_In_Charge__c)) {
|
User tempUser = personInChargeMap.get(rac.Person_In_Charge__c);
|
OCM_Management_Province__c omp = mpMap.get(tempUser.OCM_man_province_Rental__c);
|
if (omp != null) {
|
/*
|
SWAG-B6X8CK 把能量事业本部的判断去掉，都取备品助理 2018/11/29 start
|
*/
|
/*if (tempUser.Dept__c == '能量事业本部') {
|
rac.Rental_Assistant__c = omp.Energy_assistant__c;
|
rac.Rental_Assistant2__c = null;
|
rac.Rental_Assistant3__c = null;
|
} else {*/
|
rac.Rental_Assistant__c = omp.Admin_assistant__c;
|
rac.Rental_Assistant2__c = omp.Admin_assistant2__c;
|
rac.Rental_Assistant3__c = omp.Admin_assistant3__r.Name;// SWAG-BZL695 you 20210331
|
rac.OBA3_Email_Group__c = omp.OBA3_Email_Group__c;// 20220517 ljh SWAG-CDTEFS add
|
//}
|
/*
|
SWAG-B6X8CK 把能量事业本部的判断去掉，都取备品助理 2018/11/29 end
|
*/
|
}
|
}
|
}
|
}
|
//*************************SWAG-AZNAER 20180627 End*************************//
|
// OLY_OCM-584 Start 移动到Handler
|
// if (copyUserIds.size() > 0) {
|
// Map<Id, User> copyUserMap = new Map<Id, User>([
|
// SELECT Id, Name, Buzhang_Equipment_Manager__c, JingliEquipmentManager__c, SalesManager__c, BuchangApprovalManagerSales__c, JingliApprovalManager__c, BuchangApprovalManager__c, ZongjianApprovalManager__c, TongkuoZongjian__c FROM User WHERE Id IN :copyUserIds
|
// ]);
|
//
|
// for (Integer i = 0; i < copyUserIds.size(); i++) {
|
// Rental_Apply__c local = newList[i];
|
// User loginUser = copyUserMap.get(copyUserIds[i]);
|
// local.SalesManager__c = loginUser.JingliEquipmentManager__c != null ? loginUser.JingliEquipmentManager__c : loginUser.SalesManager__c;
|
// local.BuchangApprovalManagerSales__c = loginUser.Buzhang_Equipment_Manager__c != null ? loginUser.Buzhang_Equipment_Manager__c : loginUser.BuchangApprovalManagerSales__c;
|
// local.JingliApprovalManager__c = loginUser.JingliApprovalManager__c;
|
// local.BuchangApprovalManager__c = loginUser.BuchangApprovalManager__c;
|
// local.ZongjianApprovalManager__c = loginUser.ZongjianApprovalManager__c;
|
// local.TongkuoZongjian__c = loginUser.TongkuoZongjian__c;
|
// }
|
// }
|
// OLY_OCM-584 End
|
/** 暂时先不要编码加_1,_2
|
// SWAG-BZL695 you 20210402 start 给再申请得备品编码赋值 原编码_1...
|
|
if (Trigger.isInsert) {
|
Map<string, string> old_raMap = new Map<string, string>();//原备品申请，新备品申请
|
|
for (Rental_Apply__c ra: Trigger.New) {
|
if(String.isNotBlank(ra.Zsq_Rental_Apply__c) ){
|
old_raMap.put(ra.Zsq_Rental_Apply__c,ra.id);
|
}
|
|
}
|
|
// 查一下再申请出来得个数 用来拼接编码
|
List<AggregateResult> oldRaList = [
|
select Rental_Apply__c
|
from Rental_Apply_Equipment_Set__c where Zsq_Rental_Apply__c In:old_raMap.keySet()
|
group by Rental_Apply__c];
|
|
for (Rental_Apply__c ra: Trigger.New) {
|
if(old_raMap.containsKey(ra.Zsq_Rental_Apply__c)){
|
Integer num = oldRaList.size() + 1;
|
ra.Name+='_'+num;
|
}
|
|
|
|
|
}
|
|
}
|
// SWAG-BZL695 you 20210402 end
|
//ra.Name =ra.Name+'_'+ra.bpjcsqbh__c;
|
**/
|
}
|
// ----------------------------------------------------------------------
|
// ここまで、承認プロセス用に、经理、总监を更新する
|
// ----------------------------------------------------------------------
|
if (Trigger.isAfter) {
|
//*************************Create 20171027 SWAG-ASH66S 趙徳芳 Start***************************//
|
if (Trigger.isInsert) {
|
for (Rental_Apply__c local : Trigger.New) {
|
if(local.applyUser__c != local.Person_In_Charge__c){
|
try {
|
Rental_Apply__Share ras = new Rental_Apply__Share(
|
RowCause = 'ApplyUserShare__c',
|
ParentId = local.Id,
|
UserOrGroupId = local.applyUser__c,
|
AccessLevel = 'Read'
|
);
|
insert ras; // FIXME why DML in loop? and why try catch in trigger?
|
} catch (Exception e) {
|
local.addError( e.getMessage());
|
}
|
}
|
}
|
}
|
|
//2021-10-14 yjk 在trigger里触发修改qis是否有备品字段 start
|
|
|
if (Trigger.isInsert && Trigger.isAfter) {
|
List<Id> qisIdList = new List<Id>();
|
for (Rental_Apply__c local : Trigger.New) {
|
if(local.QIS_number__c != null){
|
|
qisIdList.add(local.QIS_number__c);
|
}
|
}
|
if(qisIdList != null && qisIdList.size() > 0){
|
List<QIS_Report__c> qisList = [select id,isLendRental__c from QIS_Report__c where id in :qisIdList];
|
for(QIS_Report__c qisReport : qisList){
|
qisReport.isLendRental__c = true;
|
}
|
update qisList;
|
}
|
|
}
|
|
|
if (Trigger.isUpdate && Trigger.isAfter) {
|
List<Id> qisIdList = new List<Id>();
|
for (Rental_Apply__c local : Trigger.New) {
|
if(local.QIS_number__c != null && local.QIS_number__c != Trigger.oldMap.get(local.Id).QIS_number__c){
|
|
qisIdList.add(local.QIS_number__c);
|
}
|
}
|
if(qisIdList != null && qisIdList.size() > 0){
|
List<QIS_Report__c> qisList = [select id,isLendRental__c from QIS_Report__c where id in :qisIdList];
|
for(QIS_Report__c qisReport : qisList){
|
qisReport.isLendRental__c = true;
|
}
|
update qisList;
|
}
|
|
}
|
//2021-10-14 yjk 在trigger里触发修改qis是否有备品字段 end
|
|
|
// SWAG-BZL695 you 20210331 start 将原来的 备品借出申请的 一览和一览明细 克隆一份至 新备品借出申请
|
if (Trigger.isInsert) {
|
Map<string, string> raMap = new Map<string, string>();//原备品申请，新备品申请
|
|
for (Rental_Apply__c ra: Trigger.New) {
|
if(String.isNotBlank(ra.Zsq_Rental_Apply__c) ){
|
raMap.put(ra.Zsq_Rental_Apply__c,ra.id);
|
//ra.addError(ra.requestNoJoinStr2__c+'===');
|
|
}
|
|
}
|
|
if (raMap!= null && raMap.size() > 0) {
|
//查询原来备品申请下得一览
|
List<Rental_Apply_Equipment_Set__c> raesList = [SELECT Id, Name,Loaner_centre_mail_address__c,Received_Confirm__c,
|
IsOPD_Account__c,LendNum__c,Received_NG_ReAssign_Text__c,Received_ng_detail__c, Rental_Apply__r.RecordTypeId,Rental_Apply__c,Bollow_Date_Add_10_WD__c,Guzhangpaicha_Final_reply_day_Text__c,
|
Fixture_Set__c,Loaner_code_text__c,Cancel_Select__c,Cancel_Reason__c,Loaner_cancel_Remarks__c,Loaner_cancel_reason__c,Cancel_Mem__c,
|
requestNoJoinStr2__c,Cancel_Date__c,UniqueKey__c,IndexFromUniqueKey__c,DataMigration_Flag__c,Rental_Num__c,First_RAESD__c,zsqybpyl__c
|
FROM Rental_Apply_Equipment_Set__c
|
WHERE Rental_Apply__c In:raMap.keySet() and Substitute_flag__c <> true];
|
//分单的时候 数量(Sys)是原来 总配套的数量，再申请的时候需要重新按照 配套型号，在重新计算 数量(Sys)
|
Map<String, List<Rental_Apply_Equipment_Set__c>> Fixture_Set_Map = new Map<String, List<Rental_Apply_Equipment_Set__c>>();
|
if(null!=raesList && raesList.size() > 0){
|
for (Rental_Apply_Equipment_Set__c raes:raesList){
|
if (!Fixture_Set_Map.containsKey(raes.Fixture_Set__c)) {
|
Fixture_Set_Map.put(raes.Fixture_Set__c, new List<Rental_Apply_Equipment_Set__c>());
|
}
|
Fixture_Set_Map.get(raes.Fixture_Set__c).add(raes);//原来的配套型号，一览
|
}
|
}
|
|
if (null!=raesList && raesList.size() > 0) {
|
List<Rental_Apply_Equipment_Set__c> insertCloneList = new List<Rental_Apply_Equipment_Set__c>();
|
for(String fsm : Fixture_Set_Map.keySet()){
|
List<Rental_Apply_Equipment_Set__c> fsmlist = Fixture_Set_Map.get(fsm);
|
Integer i=0;
|
for (Rental_Apply_Equipment_Set__c raes:fsmlist){
|
Rental_Apply_Equipment_Set__c raesClone = new Rental_Apply_Equipment_Set__c();
|
raesClone = raes.clone();
|
raesClone.Id = null;
|
raesClone.Cancel_Select__c = false;
|
raesClone.Cancel_Reason__c = null;
|
raesClone.Loaner_cancel_Remarks__c = null;
|
raesClone.Loaner_cancel_reason__c = null; //20210706 SFDC-C448KZ you
|
raesClone.Cancel_Mem__c = null;
|
raesClone.Cancel_Date__c = null;
|
raesClone.Rental_Num__c = fsmlist.size();
|
raesClone.IndexFromUniqueKey__c = i+1;
|
raesClone.Rental_Apply__c = raMap.get(raes.Rental_Apply__c);
|
raesClone.zsqybpyl__c = raes.id; //旧得一览id ，用来比对原来得一览下面得一览明细
|
raesClone.Zsq_Rental_Apply__c = raes.Rental_Apply__c;//旧得备品
|
system.debug('一览==='+raesClone.UniqueKey__c+'==raesClone.IndexFromUniqueKey__c=='+raesClone.IndexFromUniqueKey__c);
|
insertCloneList.add(raesClone);
|
i++;
|
}
|
}
|
|
if (insertCloneList.size() > 0) {
|
|
System.debug('==一览==insertCloneList=='+insertCloneList);
|
//插入一览
|
insert insertCloneList;
|
}
|
|
if(null!=insertCloneList && insertCloneList.size()>0){
|
//旧得一览id，新得一览
|
Map<String, Rental_Apply_Equipment_Set__c> raesMap = new Map<String, Rental_Apply_Equipment_Set__c>();
|
//旧的一览明细id，新的一览
|
Map<String, Rental_Apply_Equipment_Set__c> oldylmxidMap = new Map<String, Rental_Apply_Equipment_Set__c>();
|
|
for (Rental_Apply_Equipment_Set__c raes:insertCloneList){
|
raesMap.put(raes.zsqybpyl__c, raes);//旧得一览，
|
oldylmxidMap.put(raes.First_RAESD__c, raes);//旧的一览明细id，新的一览
|
}
|
if (raesMap!= null && raesMap.size() > 0) {
|
//查询之前备品和一览下面得明细
|
List<Rental_Apply_Equipment_Set_Detail__c> RaesdList = [select id,Name,IndexFromUniqueKey_Text__c, Rental_Apply_Equipment_Set__c,Fixture_Name_text__c,Fixture_Set_Detail__c,Is_Body__c,Loaner_accsessary__c,Fixture_Model_No_text__c,
|
Inspection_result__c,Pre_Inspection_Comment__c,Inspection_result_NG__c, Inspection_staff__c,DeliverySlip__c,Shippment_loaner_time__c,Return_DeliverySlip__c,Asset_return_time__c,
|
FSD_Product_Status_Flag__c,Internal_asset_location_before__c,Salesdepartment_before__c,Equipment_Type_text__c,SalesProvince_before__c,Product_category_text__c,
|
DataMigration_Flag__c,UniqueKey__c,IndexFromUniqueKey__c,Rental_Num__c,RequestNoJoinStr2__c,Loaner_centre_mail_address__c,zsqybpylmx__c,FSD_Id__c
|
from Rental_Apply_Equipment_Set_Detail__c
|
where Rental_Apply_Equipment_Set__c in :raesMap.keySet() and Rental_Apply__c in:raMap.keySet() and Cancel_Reason__c <>'重新分配'];
|
|
if (null!=RaesdList && RaesdList.size() > 0) {
|
List<Rental_Apply_Equipment_Set_Detail__c> RaesdCloneList = new List<Rental_Apply_Equipment_Set_Detail__c>();
|
for (Rental_Apply_Equipment_Set_Detail__c raesd:RaesdList){
|
Rental_Apply_Equipment_Set_Detail__c raesdClone = new Rental_Apply_Equipment_Set_Detail__c();
|
raesdClone = raesd.clone();
|
raesdClone.Id = null;
|
raesdClone.Cancel_Select__c = false;
|
raesdClone.Cancel_Reason__c = null;
|
raesdClone.Loaner_cancel_Remarks__c = null;
|
raesdClone.Loaner_cancel_reason__c = null; //20210706 SFDC-C448KZ you
|
raesdClone.DataMigration_Flag__c = false;
|
raesdClone.Cancel_Mem__c = null;
|
raesdClone.Cancel_Date__c = null;
|
raesdClone.Rental_Apply__c = raesMap.get(raesd.Rental_Apply_Equipment_Set__c).Rental_Apply__c;
|
raesdClone.Rental_Apply_Equipment_Set__c = raesMap.get(raesd.Rental_Apply_Equipment_Set__c).id;
|
raesdClone.zsqybpylmx__c = raesd.id;//暂时存放旧的一览明细 raesMap.get(raesd.Rental_Apply_Equipment_Set__c).requestNoJoinStr2__c
|
|
RaesdCloneList.add(raesdClone);
|
|
}
|
if (RaesdCloneList.size() > 0) {
|
//插入旧的一览明细
|
System.debug('==RaesdCloneList=='+RaesdCloneList);
|
insert RaesdCloneList;
|
}
|
if(null!=RaesdCloneList && RaesdCloneList.size()>0){
|
//旧得一览明细id，新的一览明细
|
Map<String, Rental_Apply_Equipment_Set_Detail__c> raesdMap = new Map<String, Rental_Apply_Equipment_Set_Detail__c>();
|
for (Rental_Apply_Equipment_Set_Detail__c reasd:RaesdCloneList){
|
raesdMap.put(reasd.zsqybpylmx__c, reasd);
|
}
|
List<Rental_Apply_Equipment_Set__c> raesdList1 = New List<Rental_Apply_Equipment_Set__c>();
|
for(String oldylmxid : oldylmxidMap.keySet()){
|
Rental_Apply_Equipment_Set__c raesobj = new Rental_Apply_Equipment_Set__c();
|
raesobj = oldylmxidMap.get(oldylmxid);
|
if(raesdMap.containsKey(oldylmxid)){
|
raesobj.First_RAESD__c=raesdMap.get(oldylmxid).id;
|
}
|
raesdList1.add(raesobj);
|
}
|
if (raesdList1.size() > 0) {
|
//更新一览上面得 第一条备品配套明细
|
update raesdList1;
|
}
|
|
|
}
|
|
}
|
|
}
|
}
|
|
}
|
}
|
}
|
|
// SWAG-BZL695 you 20210331 end
|
// LD 20200819 因备品出借可视化管理注释以下代码块 Start
|
//*************************Create 20171027 SWAG-ASH66S 趙徳芳 End***************************//
|
//取到插入或者更新备品借出申请的修理
|
// if (trigger.isInsert || trigger.isUpdate){
|
// for (Rental_Apply__c local : Trigger.New) {
|
// if (local.Repair__c!=null)
|
// repairSet.add(local.Repair__c);
|
// }
|
// }
|
// if (trigger.isUpdate){
|
// for (Rental_Apply__c local : Trigger.old) {
|
// if (local.Repair__c!=null)
|
// repairSet.add(local.Repair__c);
|
// }
|
// }
|
// //取到删除备品借出申请的修理
|
// if (trigger.isDelete){
|
// for (Rental_Apply__c local : Trigger.old) {
|
// if (local.Repair__c!=null)
|
// repairSet.add(local.Repair__c);
|
// }
|
// }
|
|
// if (repairSet.size()>0){
|
// List<Repair__c> uprepair = [SELECT Id FROM Repair__c WHERE Id in :repairSet AND Status1__c != '0.删除'];
|
// AggregateResult[] results = [SELECT Repair__c,count(Id) cnt
|
// FROM Rental_Apply__c
|
// //WHERE Repair__c in :repairSet
|
// WHERE Repair__c in (SELECT Id FROM Repair__c WHERE Id in :repairSet AND Status1__c != '0.删除')
|
// AND Status__c != '草案中'
|
// AND Status__c != '取消'
|
// group by Repair__c];
|
|
// List<Repair__c> repairUplist = new List<Repair__c>();
|
// for (Repair__c strRepair:uprepair){
|
// Integer cnt =0;
|
// for(AggregateResult ar: results){
|
// if(String.valueOf(ar.get('Repair__c')) == strRepair.Id){
|
// cnt = Integer.valueOf(ar.get('cnt'));
|
// break;
|
// }
|
// }
|
// Repair__c repair = new Repair__c();
|
// repair.Id = strRepair.Id;
|
// repair.Effective_RentalApply_No__c = cnt;
|
// repairUplist.add(repair);
|
// }
|
|
// if (repairUplist.size() > 0){
|
// update repairUplist;
|
// }
|
// }
|
}
|
}
|
}
|
