/**
|
* 前提：朝で実行するので、Date__c <= :toDate、期首日も 4/1 その日から 4/1 になる
|
*/
|
global class UpdateUserTextColBatch implements Database.Batchable<sObject> {
|
global final String testUserId;
|
|
Boolean IsNeedExecute = false; // 2021-03-08 mzy WLIG-BYHD79 SFDC环境batch合并调查 是否符合执行条件
|
|
/**
|
* コンスタント、パラメータを受け取る
|
*/
|
global UpdateUserTextColBatch(String testUserId) {
|
this.testUserId = testUserId;
|
}
|
|
global UpdateUserTextColBatch() {
|
this.testUserId = null;
|
}
|
|
// 2021-03-08 mzy WLIG-BYHD79 SFDC环境batch合并调查 start
|
global UpdateUserTextColBatch(Boolean NeedExecute) {
|
this.IsNeedExecute = NeedExecute;
|
}
|
global UpdateUserTextColBatch(String testUserId,Boolean NeedExecute) {
|
this.testUserId = testUserId;
|
this.IsNeedExecute = NeedExecute;
|
}
|
// 2021-03-08 mzy WLIG-BYHD79 SFDC环境batch合并调查 end
|
|
|
/**
|
* startには、queryを実行、ユーザーを検索
|
*/
|
global Database.QueryLocator start(Database.BatchableContext BC) {
|
String query = 'Select Id, Fiscal_Start_Date__c, Fiscal_Start_Date_from_May__c, Use_Start_Date__c, Maternity_leave_StartDate__c, Maternity_leave_EndDate__c from User'; //20230303 lt DB202302421915 add , Maternity_leave_StartDate__c, Maternity_leave_EndDate__c
|
if (String.isBlank(testUserId) == false) {
|
query += ' where Id =\'' + testUserId + '\'';
|
}
|
return Database.getQueryLocator(query);
|
}
|
|
global void execute(Database.BatchableContext BC, List<SObject> uList) {
|
for (SObject u : uList) {
|
User usr = (User) u;
|
Date toDate = Date.today();
|
Date fromDate4 = usr.Fiscal_Start_Date__c;
|
if (usr.Use_Start_Date__c != null && usr.Use_Start_Date__c > usr.Fiscal_Start_Date__c) {
|
fromDate4 = usr.Use_Start_Date__c;
|
}
|
|
//20230303 lt DB202302421915 start
|
// usr.Fiscal_Workdays__c = decimal.valueOf(getOlympusWorkDayCount(fromDate4, toDate));
|
|
Date mlStartDate = usr.Maternity_leave_StartDate__c;
|
Date mlEndDate = usr.Maternity_leave_EndDate__c;
|
|
if(mlStartDate == null && mlEndDate == null){
|
usr.Fiscal_Workdays__c = decimal.valueOf(getOlympusWorkDayCount(fromDate4, toDate));
|
}
|
else if(mlStartDate != null && mlEndDate == null && mlStartDate > fromDate4){
|
usr.Fiscal_Workdays__c = decimal.valueOf(getOlympusWorkDayCount(fromDate4, mlStartDate));
|
}
|
else if(mlStartDate != null && mlEndDate == null && mlStartDate <= fromDate4){
|
usr.Fiscal_Workdays__c = 0;
|
}
|
else if(mlStartDate != null && mlEndDate != null && mlStartDate > fromDate4){
|
usr.Fiscal_Workdays__c = decimal.valueOf(getOlympusWorkDayCount(fromDate4, mlStartDate)) + decimal.valueOf(getOlympusWorkDayCount(mlEndDate, toDate));
|
}
|
else if(mlStartDate != null && mlEndDate != null && mlStartDate <= fromDate4){
|
usr.Fiscal_Workdays__c = 0 + decimal.valueOf(getOlympusWorkDayCount(mlEndDate, toDate));
|
}
|
//20230303 lt DB202302421915 end
|
|
/***** CHAN-AZABMC ****** 2018/06/01 ********
|
**** 到本月的工作日（今年度）
|
**** 到本周的工作日（今年度）
|
*********************************************/
|
Date thisMonthToDate = Date.newInstance(toDate.year(), toDate.month(), 1);
|
Date thisWeekToDate = toDate.toStartofWeek().addDays(1);
|
if (usr.Use_Start_Date__c == null || (usr.Use_Start_Date__c != null && usr.Use_Start_Date__c < thisMonthToDate)) {
|
usr.Fiscal_Workdays_thisMonth__c = decimal.valueOf(getOlympusWorkDayCount(thisMonthToDate, toDate));
|
} else {
|
usr.Fiscal_Workdays_thisMonth__c = decimal.valueOf(getOlympusWorkDayCount(usr.Use_Start_Date__c, toDate));
|
}
|
if (usr.Use_Start_Date__c == null || (usr.Use_Start_Date__c != null && usr.Use_Start_Date__c < thisWeekToDate)) {
|
usr.Fiscal_Workdays_thisWeek__c = decimal.valueOf(getOlympusWorkDayCount(thisWeekToDate, toDate));
|
} else {
|
usr.Fiscal_Workdays_thisWeek__c = decimal.valueOf(getOlympusWorkDayCount(usr.Use_Start_Date__c, toDate));
|
}
|
|
usr.This_Month_SS_day__c = getThisMonthSSday(toDate);
|
Integer jintian = getOlympusWorkDayCount(toDate, toDate);
|
Integer zuotian = getOlympusWorkDayCount(toDate.addDays(-1), toDate.addDays(-1));
|
usr.Jintian_WorkingDay__c = (jintian > 0);
|
usr.Zuotian_WorkingDay__c = (zuotian > 0);
|
|
if (toDate >= Date.newInstance(2014, 4, 1)) {
|
// 来年度はいらない
|
} else {
|
Date fromDate5 = usr.Fiscal_Start_Date_from_May__c;
|
if (usr.Use_Start_Date__c != null && usr.Use_Start_Date__c > usr.Fiscal_Start_Date_from_May__c) {
|
fromDate5 = usr.Use_Start_Date__c;
|
}
|
AggregateResult[] cal5 = [Select Count(Id) cnt From OlympusCalendar__c Where Date__c >= :fromDate5 And Date__c <= :toDate And IsWorkDay__c = 1];
|
usr.Fiscal_Workdays_From_May__c = decimal.valueOf((Integer) cal5[0].get('cnt'));
|
}
|
|
//いらないはず、UpdateRentalApplyEquipmentSetBatch で計算しています
|
//bp2 AggregateResult[] points = [select SUM(Foul_Points__c) fp
|
// from Rental_Apply_Equipment_Set__c
|
// where Rental_Apply__r.OwnerId = :usr.Id and Foul_Points__c > 0
|
// and AND Cancel_Select__c = False];
|
//bp2 usr.Foul_Points__c = points[0].get('fp') == null ? 0 : decimal.valueOf(String.valueOf(points[0].get('fp')));
|
}
|
|
/* 2018-12-10 CHAN-B6W86D 根据权限集进行权限设置 start*/
|
|
Map <Id, User> uMap = new Map <Id, User>();
|
for (SObject u : uList) {
|
User newUser = (User) u;
|
newUser.Download_right__c = false;
|
newUser.ProductCostReferable__c = false;
|
newUser.ENDOPARTNERReferable__c = false;
|
newUser.P002_OCM_Act__c = false;
|
newUser.P002_Agent_Act__c = false;
|
newUser.SI_ProfessionalAuth__c = false;
|
newUser.Plan_report_permission__c = false;
|
newUser.Group_purchse_dept__c = false;
|
newUser.Create_dashboard__c = false;
|
newUser.EditCompetitorAsset__c = false;
|
uMap.put(newUser.Id, newUser);
|
}
|
list<PermissionSetAssignment> PermissionSetAssignmentList =
|
[SELECT Id, AssigneeId, PermissionSetId FROM PermissionSetAssignment
|
where AssigneeId in : uList
|
and (PermissionSetId = : system.Label.PermissionSet_Createdashboard_ID
|
or PermissionSetId = : system.Label.PermissionSet_ENDOPARTNER_ID
|
or PermissionSetId = : system.Label.PermissionSet_Group_purchse_dept_ID
|
or PermissionSetId = : system.Label.PermissionSet_P002_Agent_ID
|
or PermissionSetId = : system.Label.PermissionSet_P002_OCM_ID
|
or PermissionSetId = : system.Label.PermissionSet_Plan_report_permission_ID
|
or PermissionSetId = : system.Label.PermissionSet_ProductCost_ID
|
or PermissionSetId = : system.Label.PermissionSet_Report_ID
|
or PermissionSetId = : system.Label.PermissionSet_SI_ID
|
or PermissionSetId = : system.Label.PermissionSet_EditCompetitorAsset_ID // CHAN-B7K8K8 2018/12/18
|
)];
|
|
for (PermissionSetAssignment temPSA : PermissionSetAssignmentList) {
|
User currentUser = uMap.get(temPSA.AssigneeId);
|
if (currentUser == null) {
|
continue;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_Createdashboard_ID)) {
|
currentUser.Create_dashboard__c = true;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_ENDOPARTNER_ID)) {
|
currentUser.ENDOPARTNERReferable__c = true;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_Group_purchse_dept_ID)) {
|
currentUser.Group_purchse_dept__c = true;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_P002_Agent_ID)) {
|
currentUser.P002_Agent_Act__c = true;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_P002_OCM_ID)) {
|
currentUser.P002_OCM_Act__c = true;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_Plan_report_permission_ID)) {
|
currentUser.Plan_report_permission__c = true;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_ProductCost_ID)) {
|
currentUser.ProductCostReferable__c = true;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_Report_ID)) {
|
currentUser.Download_right__c = true;
|
}
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_SI_ID)) {
|
currentUser.SI_ProfessionalAuth__c = true;
|
}
|
// CHAN-B7K8K8 2018/12/18 start
|
if (temPSA.PermissionSetId.equals(system.Label.PermissionSet_EditCompetitorAsset_ID)) {
|
currentUser.EditCompetitorAsset__c = true;
|
}
|
// CHAN-B7K8K8 2018/12/18 end
|
}
|
/* 2018-12-10 CHAN-B6W86D 根据权限集进行权限设置 end*/
|
update uList;
|
}
|
|
global void finish(Database.BatchableContext BC) {
|
// 今回はやることないです
|
|
//2021-03-08 mzy WLIG-BYHD79 SFDC环境batch合并调查 start
|
if(!Test.isRunningTest() &&IsNeedExecute==true){
|
//batch里调用下一个batch时，希望跟原有的Schedule里面传的条数保持一致
|
Id execBTId = Database.executebatch(new TaskStatusUpdateBatch(true));
|
}
|
//2021-03-08 mzy WLIG-BYHD79 SFDC环境batch合并调查 end
|
|
}
|
|
public static Integer getOlympusWorkDayCount(Date fromDate, Date toDate) {
|
AggregateResult[] calAggResult = [Select Count(Id) cnt From OlympusCalendar__c Where Date__c >= :fromDate And Date__c <= :toDate And IsWorkDay__c = 1];
|
Integer workDayCount = (Integer) calAggResult[0].get('cnt');
|
return workDayCount;
|
}
|
public static Date getThisMonthSSday(Date thisMonth) {
|
Date mon1stDate = Date.newInstance(thisMonth.year(), thisMonth.month(), 1);
|
Integer SSBacth_Execute_Day = Integer.valueOf(System.Label.SSBacth_Execute_Day);
|
List<OlympusCalendar__c> ssDay = [Select Date__c From OlympusCalendar__c Where Date__c >= :mon1stDate And IsWorkDay__c = 1 order by Date__c asc limit :SSBacth_Execute_Day];
|
// TODO xudan ssDay.size() >= SSBacth_Execute_Day の判断は必要？
|
// Limit3なのに、実際データは2件しかないなど⇒データ不備、わざとExceptionを出したほうがいい？
|
return ssDay[SSBacth_Execute_Day - 1].Date__c;
|
}
|
}
|
