/// <summary>
/// Tính tổng thời gian nghỉ theo từng loại trên chi tiết gán vào Att_AttendanceTable
/// </summary>
/// <param name="attendanceTable"></param>
/// <param name="midCutOffDate"></param>
private static void TotalGroupByLeaveDayType(Att_AttendanceTable attendanceTable, DateTime midCutOffDate)
{
#region Nghỉ mà xem như đi làm - Loại IsWorkDay
List<Att_AttendanceTableItem> listAttendanceTableItemCutOff = attendanceTable
.Att_AttendanceTableItem.Where(d => d.WorkDate <= midCutOffDate).ToList();
//Nếu nghỉ 2 loại ngày nghỉ khác nhau và cùng là IsWorkDay thì ưu tiên cột Cat_LeaveDayType4 trước...
List<Att_AttendanceTableItem> listAttendanceTableItemIsWorkDay = listAttendanceTableItemCutOff.Where(d =>
d.Cat_LeaveDayType2 != null && !d.Cat_LeaveDayType2.IsAnnualLeave && d.Cat_LeaveDayType2.IsWorkDay).ToList();
foreach (Att_AttendanceTableItem itemIsWorkDay in listAttendanceTableItemIsWorkDay)
{
if (attendanceTable.Cat_LeaveDayType4 == null || attendanceTable.Cat_LeaveDayType4 == itemIsWorkDay.Cat_LeaveDayType2)
{
attendanceTable.Cat_LeaveDayType4 = itemIsWorkDay.Cat_LeaveDayType2;
attendanceTable.LeaveDay4Hours = attendanceTable.LeaveDay4Hours + itemIsWorkDay.LeaveWorkDayHour.Get_Double();
attendanceTable.LeaveDay4Days = attendanceTable.LeaveDay4Days.Get_Double() + itemIsWorkDay.LeaveWorkDayDays.Get_Double();
}
//else if (attendanceTable.Cat_LeaveDayType5 == null || attendanceTable.Cat_LeaveDayType5 == itemIsWorkDay.Cat_LeaveDayType2)
//{
// attendanceTable.Cat_LeaveDayType5 = itemIsWorkDay.Cat_LeaveDayType2;
// attendanceTable.LeaveWorkDay2Hour = attendanceTable.LeaveWorkDay2Hour.Get_Double() + itemIsWorkDay.LeaveWorkDayHour.Get_Double();
// attendanceTable.LeaveWorkDay2Days = attendanceTable.LeaveWorkDay2Days.Get_Double() + itemIsWorkDay.LeaveWorkDayDays.Get_Double();
//}
}
#endregion
#region Những ngày nghỉ bình thường khác
//Nếu nghỉ nhiều loại ngày nghỉ khác nhau thì ưu tiên cột Cat_LeaveDayType trước...
List<Att_AttendanceTableItem> listAttendanceTableItemOther = listAttendanceTableItemCutOff.Where(d => (d.Cat_LeaveDayType != null
&& !d.Cat_LeaveDayType.IsAnnualLeave) || (d.Cat_LeaveDayType1 != null && !d.Cat_LeaveDayType1.IsAnnualLeave)).ToList();
attendanceTable.PaidWorkDayCount -= listAttendanceTableItemOther.Where(d => d.Cat_LeaveDayType != null && !d.Cat_LeaveDayType.IsAnnualLeave
&& d.Cat_LeaveDayType.Penalty > 0).Sum(d => (d.LeaveHours * d.Cat_LeaveDayType.Penalty) / d.udStandardWorkHours);
attendanceTable.PaidWorkDayCount -= listAttendanceTableItemOther.Where(d => d.Cat_LeaveDayType1 != null && !d.Cat_LeaveDayType1.IsAnnualLeave
&& d.Cat_LeaveDayType1.Penalty > 0).Sum(d => (d.ExtraLeaveHours * d.Cat_LeaveDayType1.Penalty) / d.udStandardWorkHours);
foreach (Att_AttendanceTableItem itemOther in listAttendanceTableItemOther)
{
if (itemOther.Cat_LeaveDayType != null && !itemOther.Cat_LeaveDayType.IsAnnualLeave)
{
if (attendanceTable.Cat_LeaveDayType == null || attendanceTable.Cat_LeaveDayType == itemOther.Cat_LeaveDayType)
{
attendanceTable.Cat_LeaveDayType = itemOther.Cat_LeaveDayType;
attendanceTable.LeaveDay1Hours = attendanceTable.LeaveDay1Hours + itemOther.LeaveHours;
attendanceTable.LeaveDay1Days = attendanceTable.LeaveDay1Days.Get_Double() + itemOther.LeaveDays.Get_Double();
}
else if (attendanceTable.Cat_LeaveDayType1 == null || attendanceTable.Cat_LeaveDayType1 == itemOther.Cat_LeaveDayType)
{
attendanceTable.Cat_LeaveDayType1 = itemOther.Cat_LeaveDayType;
attendanceTable.LeaveDay2Hours = attendanceTable.LeaveDay2Hours + itemOther.LeaveHours;
attendanceTable.LeaveDay2Days = attendanceTable.LeaveDay2Days.Get_Double() + itemOther.LeaveDays.Get_Double();
}
else if (attendanceTable.Cat_LeaveDayType2 == null || attendanceTable.Cat_LeaveDayType2 == itemOther.Cat_LeaveDayType)
{
attendanceTable.Cat_LeaveDayType2 = itemOther.Cat_LeaveDayType;
attendanceTable.LeaveDay3Hours = attendanceTable.LeaveDay3Hours + itemOther.LeaveHours;
attendanceTable.LeaveDay3Days = attendanceTable.LeaveDay3Days.Get_Double() + itemOther.LeaveDays.Get_Double();
}
else if (attendanceTable.Cat_LeaveDayType3 == null || attendanceTable.Cat_LeaveDayType3 == itemOther.Cat_LeaveDayType)
{
attendanceTable.Cat_LeaveDayType3 = itemOther.Cat_LeaveDayType;
attendanceTable.LeaveDay4Hours = attendanceTable.LeaveDay4Hours + itemOther.LeaveHours;
attendanceTable.LeaveDay4Days = attendanceTable.LeaveDay4Days.Get_Double() + itemOther.LeaveDays.Get_Double();
}
}
if (itemOther.Cat_LeaveDayType1 != null && !itemOther.Cat_LeaveDayType1.IsAnnualLeave)
{
if (attendanceTable.Cat_LeaveDayType == null || attendanceTable.Cat_LeaveDayType == itemOther.Cat_LeaveDayType1)
{
attendanceTable.Cat_LeaveDayType = itemOther.Cat_LeaveDayType1;
attendanceTable.LeaveDay1Hours = attendanceTable.LeaveDay1Hours + itemOther.ExtraLeaveHours;
attendanceTable.LeaveDay1Days = attendanceTable.LeaveDay1Days.Get_Double() + itemOther.ExtraLeaveDays.Get_Double();
}
else if (attendanceTable.Cat_LeaveDayType1 == null || attendanceTable.Cat_LeaveDayType1 == itemOther.Cat_LeaveDayType1)
{
attendanceTable.Cat_LeaveDayType1 = itemOther.Cat_LeaveDayType1;
attendanceTable.LeaveDay2Hours = attendanceTable.LeaveDay2Hours + itemOther.ExtraLeaveHours;
attendanceTable.LeaveDay2Days = attendanceTable.LeaveDay2Days.Get_Double() + itemOther.ExtraLeaveDays.Get_Double();
}
else if (attendanceTable.Cat_LeaveDayType2 == null || attendanceTable.Cat_LeaveDayType2 == itemOther.Cat_LeaveDayType1)
{
attendanceTable.Cat_LeaveDayType2 = itemOther.Cat_LeaveDayType1;
attendanceTable.LeaveDay3Hours = attendanceTable.LeaveDay3Hours + itemOther.ExtraLeaveHours;
attendanceTable.LeaveDay3Days = attendanceTable.LeaveDay3Days.Get_Double() + itemOther.ExtraLeaveDays.Get_Double();
}
else if (attendanceTable.Cat_LeaveDayType3 == null || attendanceTable.Cat_LeaveDayType3 == itemOther.Cat_LeaveDayType1)
{
attendanceTable.Cat_LeaveDayType3 = itemOther.Cat_LeaveDayType1;
attendanceTable.LeaveDay4Hours = attendanceTable.LeaveDay4Hours + itemOther.ExtraLeaveHours;
attendanceTable.LeaveDay4Days = attendanceTable.LeaveDay4Days.Get_Double() + itemOther.ExtraLeaveDays.Get_Double();
}
}
}
#endregion
}
private int ComputeAttendance(IUnitOfWork unitOfWork, Guid userID, DateTime monthYear, Guid cutOffDurationID, DateTime attendanceFrom,
DateTime attendanceTo, Hre_ProfileEntity profile, Cat_GradeAttendance gradeCfg, List<Cat_Shift> listShift, List<Att_AnnualDetail> listAnnualDetailByProfile,
List<Hre_HDTJob> listHDTJobByProfile, List<Att_LeaveDayEntity> listLeaveDayByProfile, List<Cat_LeaveDayType> listLeaveDayType,
List<Att_OvertimeEntity> listOvertimeByProfile, List<Cat_OvertimeType> listOvertimeType, List<Att_PregnancyEntity> listPregnancyByProfile,
List<Cat_LateEarlyRule> listLateEarlyRule, List<Att_Workday> listWorkDayByProfile, List<Att_AttendanceTableEntity> listPreAttendanceTableByProfile,
List<Att_TimeOffInLieuEntity> listTimeOffInLieuByProfile, Sys_AllSetting notAutoRegHolidayLeave, Sys_AllSetting otholidayscompute400,
Sys_AllSetting missTAM_LeaveType, Dictionary<DateTime, List<Guid?>> listMonthShiftID, List<Cat_DayOff> listHoliday)
{
Guid profileID = profile.ID;
if (gradeCfg == null || profile == null)
{
return 0;
}
DateTime midCutOffDate = attendanceTo;
bool isMidCutOffDay = false;
#region Tạo Att_AttendanceTable theo khoảng thời gian
Att_AttendanceTable attendanceTable = new Att_AttendanceTable();
unitOfWork.AddObject(typeof(Att_AttendanceTable), attendanceTable);
attendanceTable.Status = AttendanceTableStatus.E_WAITING.ToString();
attendanceTable.ID = Guid.NewGuid();
attendanceTable.ProfileID = profileID;
attendanceTable.MonthYear = monthYear;
attendanceTable.DateStart = attendanceFrom;
attendanceTable.DateEnd = attendanceTo;
double anlDayTaken = 0D;
double sickDayTaken = 0D;
double coBeginPeriod = 0D;
double coEndPeriod = 0D;
if (cutOffDurationID != Guid.Empty)
{
attendanceTable.CutOffDurationID = cutOffDurationID;
}
//Tính công đến ngày cấu hình trong grade, những ngày sau mặc định full công - Khách hàng CPG
if (gradeCfg != null && gradeCfg.IsMonthlyMidCutOff == true && gradeCfg.MidCutOffDay > 0)
{
if (!profile.DateQuit.HasValue || profile.DateQuit > attendanceTo)
{
midCutOffDate = new DateTime(monthYear.Year,
monthYear.Month, gradeCfg.MidCutOffDay.Value);
//Luôn tạo một dòng Ứng công lúc tính công, kô cần biết có nghỉ không
Att_AdvanceTableItem advanceTableItem = new Att_AdvanceTableItem();
advanceTableItem.Att_AttendanceTable = attendanceTable;
advanceTableItem.DateFrom = midCutOffDate.AddDays(1);
advanceTableItem.DateTo = attendanceTo;
isMidCutOffDay = true;
}
}
#endregion
#region Tạo Att_AttendanceTableItem theo khoảng thời gian
List<Att_AttendanceTableItem> listAttendanceTableItemByProfile = new List<Att_AttendanceTableItem>();
for (DateTime date = attendanceFrom.Date; date <= attendanceTo; date = date.AddDays(1))
{
var workdayByProfile = listWorkDayByProfile.Where(d =>
d.WorkDate.Date == date).FirstOrDefault();
Guid? shiftID1 = Guid.Empty;
Guid? shiftID2 = Guid.Empty;
var shiftByDate = listMonthShiftID.Where(d => d.Key.Date == date).Select(d => d.Value).FirstOrDefault();
if (shiftByDate != null)
{
if (shiftByDate.Count() > 0)
{
shiftID1 = shiftByDate[0];
}
if (shiftByDate.Count() > 1)
{
shiftID2 = shiftByDate[1];
}
}
if (workdayByProfile == null && gradeCfg.EDType == PayrollComputeMethod.E_SUBTRACT.ToString())
{
if (shiftID1.HasValue && shiftID1 != Guid.Empty)
{
workdayByProfile = new Att_Workday
{
ShiftID = shiftID1,
ShiftApprove = shiftID1,
ShiftActual = shiftID1,
WorkDate = date
};
if (shiftID2.HasValue && shiftID2 != Guid.Empty)
{
workdayByProfile.Shift2ID = shiftID2;
workdayByProfile.ShiftApprove2 = shiftID2;
workdayByProfile.ShiftActual2 = shiftID2;
}
if (listHoliday.Any(d => d.DateOff.Date == date))
{
workdayByProfile.Type = WorkdayType.E_HOLIDAY.ToString();
}
}
}
Att_AttendanceTableItem attendanceTableItem = new Att_AttendanceTableItem();
listAttendanceTableItemByProfile.Add(attendanceTableItem);
attendanceTableItem.ID = Guid.NewGuid();
attendanceTableItem.Att_AttendanceTable = attendanceTable;
attendanceTableItem.DutyCode = DutyCode.E_OFF.ToString();
attendanceTableItem.WorkDate = date;
double nightDuration = 0F;
double workDuration = 0F;
attendanceTableItem.WorkPaidHours = 0;
attendanceTableItem.PaidLeaveHours = 0;
attendanceTableItem.UnpaidLeaveHours = 0;
attendanceTableItem.LateEarlyMinutes = 0;
attendanceTableItem.LateInMinutes = 0;
attendanceTableItem.EarlyOutMinutes = 0;
attendanceTableItem.LeaveHours = 0;
attendanceTableItem.LeaveDays = 0;
attendanceTableItem.WorkHourFirstHaftShift = 0;
attendanceTableItem.WorkHourLastHaftShift = 0;
if (workdayByProfile != null)
{
attendanceTableItem.MissInOutReasonID = workdayByProfile.MissInOutReason;
attendanceTableItem.FirstInTime = workdayByProfile.FirstInTime;
attendanceTableItem.LastOutTime = workdayByProfile.LastOutTime;
attendanceTableItem.RootInTime = workdayByProfile.FirstInTime;
attendanceTableItem.RootOutTime = workdayByProfile.LastOutTime;
attendanceTableItem.ShiftID = workdayByProfile.ShiftID;
attendanceTableItem.Shift2ID = workdayByProfile.Shift2ID;
List<DateTime?> listInTime = new List<DateTime?>();
List<DateTime?> listOutTime = new List<DateTime?>();
listInTime.Add(workdayByProfile.InTime1);
listInTime.Add(workdayByProfile.InTime2);
listInTime.Add(workdayByProfile.InTime3);
listInTime.Add(workdayByProfile.InTime4);
listOutTime.Add(workdayByProfile.OutTime1);
listOutTime.Add(workdayByProfile.OutTime2);
listOutTime.Add(workdayByProfile.OutTime3);
listOutTime.Add(workdayByProfile.OutTime4);
attendanceTableItem.FirstInTime = listInTime.Where(d => d.HasValue).OrderBy(d => d).FirstOrDefault();
attendanceTableItem.LastOutTime = listOutTime.Where(d => d.HasValue).OrderBy(d => d).LastOrDefault();
if (workdayByProfile.ShiftApprove.HasValue)
{
attendanceTableItem.ShiftID = workdayByProfile.ShiftApprove.Value;
}
if (workdayByProfile.ShiftApprove2.HasValue)
{
attendanceTableItem.Shift2ID = workdayByProfile.ShiftApprove2.Value;
}
if (gradeCfg.AttendanceMethod == AttendanceMethod.E_FULL.ToString())
{
if (listMonthShiftID.Any(d => d.Key.Date == date))
{
//Bao.Tran: khi không kiểm tra vào ra thì ưu tiên ca đã tạo trong lịch làm việc
if (shiftID1 != Guid.Empty)
{
attendanceTableItem.ShiftID = shiftID1;
}
if (shiftID2 != Guid.Empty)
{
attendanceTableItem.Shift2ID = shiftID2;
}
}
//Bao.Tran: yêu cầu nếu công ko kiểm tra in/out thì không lấy in/out
attendanceTableItem.FirstInTime = null;
attendanceTableItem.LastOutTime = null;
//comment code này do ảnh hưởng task 0046036 : ko tính được ngày nghỉ lễ
////Bao.Tran: do khi THNC cũ, Nếu ko bỏ type thì nó sẽ tính ngày công trên là holiday (attendanceTableItem.IsHoliday = true;)
//workdayByProfile.Type = WorkdayType.E_NORMAL.ToString();
}
//kiểm tra ngày làm việc có Lịch làm việc hay ko?
if (attendanceTableItem.ShiftID != null && workdayByProfile.FirstInTime != null && workdayByProfile.LastOutTime != null)
{
#region Kiểm tra HDTJob
var listHDTJobByProfileByDate = listHDTJobByProfile.Where(d => (d.DateFrom.Value.Date <= date && d.DateTo == null)
|| (d.DateTo != null && d.DateFrom.Value.Date <= date && d.DateTo.Value.Date >= date)).ToList();
foreach (var HDTJobByProfile in listHDTJobByProfileByDate)
{
if (HDTJobByProfile != null)
{
attendanceTableItem.HDTJobType = HDTJobByProfile.Type;
}
}
#endregion
}
}
var shiftByProfile1 = listShift.Where(d => d.ID == attendanceTableItem.ShiftID).FirstOrDefault();
var shiftByProfile2 = listShift.Where(d => d.ID == attendanceTableItem.Shift2ID).FirstOrDefault();
if (shiftByProfile1 != null)
{
attendanceTableItem.Cat_Shift = shiftByProfile1;
attendanceTableItem.AvailableHours = shiftByProfile1.udAvailableHours;
}
if (shiftByProfile2 != null)
{
attendanceTableItem.Cat_Shift1 = shiftByProfile2;
}
if ((workdayByProfile != null && workdayByProfile.Type == WorkdayType.E_HOLIDAY.ToString())
|| (attendanceTableItem.ShiftID.HasValue && attendanceTableItem.ShiftID != Guid.Empty))
{
//Ngày đang xét là ngày làm việc bình thường
attendanceTableItem.DutyCode = DutyCode.E_ON.ToString();
if (workdayByProfile.Type == WorkdayType.E_HOLIDAY.ToString())
{
attendanceTableItem.IsHoliday = true;
}
}
else
{
//Ngày đang xét không phải là ngày làm việc bình thường
attendanceTableItem.DutyCode = DutyCode.E_OFF.ToString();
}
#region Kiểm tra ngày nghỉ - leaveday
if (attendanceTableItem.DutyCode != DutyCode.E_OFF.ToString())
{
var listLeaveDayByProfileByDate = listLeaveDayByProfile.Where(d =>
d.DateStart.Date <= date && d.DateEnd.Date >= date).ToList();
foreach (var leaveDayByProfile in listLeaveDayByProfileByDate)
{
if (leaveDayByProfile != null)
{
double leaveHours = 0D;
double leaveDays = 0D;
var leaveDayType = listLeaveDayType.Where(d => d.ID ==
leaveDayByProfile.LeaveDayTypeID).FirstOrDefault();
var standardWorkHours = attendanceTableItem.AvailableHours;
if (leaveDayByProfile.DurationType == LeaveDayDurationType.E_FULLSHIFT.ToString())
{
//Lấy giờ nghỉ của ngày đang xét dựa vào ca làm việc
leaveHours = standardWorkHours;
leaveDays = 1;//Nghỉ full shift
}
else
{
leaveHours = leaveDayByProfile.LeaveHours.GetDouble();
leaveDays = leaveDayByProfile.LeaveDays.GetDouble();
}
leaveHours = leaveHours > standardWorkHours ? standardWorkHours : leaveHours;
leaveDays = leaveDays > 1 ? 1 : leaveDays;//Tối đa là nghỉ 1 ngày
if (!attendanceTableItem.LeaveTypeID.HasValue)
{
attendanceTableItem.LeaveTypeID = leaveDayByProfile.LeaveDayTypeID;
attendanceTableItem.Cat_LeaveDayType = leaveDayType;
attendanceTableItem.LeaveHours = leaveHours;
attendanceTableItem.LeaveDays = leaveDays;
}
else if (!attendanceTableItem.ExtraLeaveTypeID.HasValue)
{
attendanceTableItem.ExtraLeaveTypeID = leaveDayByProfile.LeaveDayTypeID;
attendanceTableItem.Cat_LeaveDayType1 = leaveDayType;
attendanceTableItem.ExtraLeaveHours = leaveHours;
attendanceTableItem.ExtraLeaveDays = leaveDays;
}
if (leaveDayType != null && leaveDays > 0)
{
if (leaveDayType.Code == LeavedayTypeCode.ANL.ToString())
{
anlDayTaken += leaveDays;
}
if (leaveDayType.Code == LeavedayTypeCode.SICK.ToString())
{
sickDayTaken += leaveDays;
}
}
}
}
}
#endregion
#region Kiểm tra làm thêm - overtime
if (gradeCfg != null && gradeCfg.IsReceiveOvertimeBonus.Get_Boolean())
{
var listOvertimeByProfileByDate = listOvertimeByProfile.Where(d =>
d.WorkDate.Date == date).ToList();
foreach (var overtime in listOvertimeByProfileByDate)
{
if (overtime != null)
{
double overtimeHours = overtime.ConfirmHours;
string overTimeStatus = OverTimeStatus.E_APPROVED.ToString();
if (overTimeStatus == OverTimeStatus.E_APPROVED.ToString())
{
overtimeHours = overtime.ApproveHours.GetDouble();
}
else if (overTimeStatus == OverTimeStatus.E_CONFIRM.ToString())
{
overtimeHours = overtime.ConfirmHours;
}
if (!attendanceTableItem.OvertimeTypeID.HasValue)
{
attendanceTableItem.OvertimeTypeID = overtime.OvertimeTypeID;
attendanceTableItem.Cat_OvertimeType = listOvertimeType.Where(s => s.ID == overtime.OvertimeTypeID).FirstOrDefault();
attendanceTableItem.OvertimeDurationType = overtime.DurationType;
attendanceTableItem.OvertimeRegisterHours = overtime.RegisterHours;
attendanceTableItem.OvertimeHours = overtimeHours;
}
else if (!attendanceTableItem.ExtraOvertimeTypeID.HasValue)
{
attendanceTableItem.ExtraOvertimeTypeID = overtime.OvertimeTypeID;
attendanceTableItem.Cat_OvertimeType1 = listOvertimeType.Where(s => s.ID == overtime.OvertimeTypeID).FirstOrDefault();
attendanceTableItem.ExtraOvertimeDurationType = overtime.DurationType;
attendanceTableItem.ExtraOvertimeRegisterHours = overtime.RegisterHours;
attendanceTableItem.ExtraOvertimeHours = overtimeHours;
}
else if (!attendanceTableItem.ExtraOvertimeType2ID.HasValue)
{
attendanceTableItem.ExtraOvertimeType2ID = overtime.OvertimeTypeID;
attendanceTableItem.Cat_OvertimeType2 = listOvertimeType.Where(s => s.ID == overtime.OvertimeTypeID).FirstOrDefault();
attendanceTableItem.ExtraOvertimeDurationType2 = overtime.DurationType;
attendanceTableItem.ExtraOvertimeRegisterHours2 = overtime.RegisterHours;
attendanceTableItem.ExtraOvertimeHours2 = overtimeHours;
}
else if (!attendanceTableItem.ExtraOvertimeType3ID.HasValue)
{
attendanceTableItem.ExtraOvertimeType3ID = overtime.OvertimeTypeID;
attendanceTableItem.Cat_OvertimeType3 = listOvertimeType.Where(s => s.ID == overtime.OvertimeTypeID).FirstOrDefault();
attendanceTableItem.ExtraOvertimeDurationType3 = overtime.DurationType;
attendanceTableItem.ExtraOvertimeRegisterHours3 = overtime.RegisterHours;
attendanceTableItem.ExtraOvertimeHours3 = overtimeHours;
}
}
}
}
#endregion
#region Kiểm tra có thai sản không
var pregnancyByProfile = listPregnancyByProfile.Where(d =>
date >= d.DateStart && date <= d.DateEnd).FirstOrDefault();
if (pregnancyByProfile != null)
{
attendanceTableItem.IsHavingPregTreatment = true;
}
#endregion
#region Nhân viên đã nghỉ hoặc chưa đi làm
if ((profile.DateQuit.HasValue && profile.DateQuit.Value.Date <= date.Date)
|| (profile.DateHire.HasValue && profile.DateHire.Value.Date > date.Date))
{
if (attendanceTableItem.DutyCode == DutyCode.E_ON.ToString())
{
if (profile.DateHire.HasValue && profile.DateHire.Value.Date > date.Date)
{
if (shiftByProfile1 != null)
{
attendanceTableItem.udNotHiredHours = shiftByProfile1.WorkHours.GetDouble();
}
else
{
attendanceTableItem.udNotHiredHours = attendanceTableItem.udStandardWorkHours;
}
if (shiftByProfile2 != null)
{
attendanceTableItem.udNotHiredHours += shiftByProfile2.WorkHours.GetDouble();
}
}
if (profile.DateQuit.HasValue && profile.DateQuit.Value.Date <= date.Date)
{
if (shiftByProfile1 != null)
{
attendanceTableItem.udTerminatedHours = shiftByProfile1.WorkHours.GetDouble();
}
else
{
attendanceTableItem.udTerminatedHours = attendanceTableItem.udStandardWorkHours;
}
if (shiftByProfile2 != null)
{
attendanceTableItem.udTerminatedHours += shiftByProfile2.WorkHours.GetDouble();
}
}
}
attendanceTableItem.Cat_LeaveDayType = null;
continue;
}
#endregion
#region Loại ngày nghỉ là ngày làm việc
if (attendanceTableItem.Cat_LeaveDayType != null)
{
//Trường hợp ngày nghỉ tính như ngày đi làm => không tính nghỉ
if (attendanceTableItem.Cat_LeaveDayType.IsWorkDay)
{
attendanceTableItem.WorkHours += attendanceTableItem.LeaveHours;
attendanceTableItem.WorkPaidHours += attendanceTableItem.LeaveHours;
attendanceTableItem.LeaveWorkDayHour = attendanceTableItem.LeaveHours;
attendanceTableItem.LeaveWorkDayDays = attendanceTableItem.LeaveHours / attendanceTableItem.udStandardWorkHours;
attendanceTableItem.Cat_LeaveDayType2 = attendanceTableItem.Cat_LeaveDayType;
attendanceTableItem.Cat_LeaveDayType = null;
attendanceTableItem.LeaveHours = 0;
attendanceTableItem.LeaveDays = 0;
}
else
{
attendanceTableItem.PaidLeaveHours += attendanceTableItem.LeaveHours * attendanceTableItem.Cat_LeaveDayType.PaidRate;
attendanceTableItem.UnpaidLeaveHours += attendanceTableItem.LeaveHours * (1 - attendanceTableItem.Cat_LeaveDayType.PaidRate);
attendanceTableItem.PaidLeaveDays = attendanceTableItem.PaidLeaveHours / attendanceTableItem.udStandardWorkHours;
attendanceTableItem.UnpaidLeaveDays = attendanceTableItem.UnpaidLeaveHours / attendanceTableItem.udStandardWorkHours;
}
}
if (attendanceTableItem.Cat_LeaveDayType1 != null)
{
if (attendanceTableItem.Cat_LeaveDayType1.IsWorkDay)
{
attendanceTableItem.WorkHours += attendanceTableItem.ExtraLeaveHours;
attendanceTableItem.WorkPaidHours += attendanceTableItem.ExtraLeaveHours;
attendanceTableItem.Cat_LeaveDayType1 = null;
attendanceTableItem.ExtraLeaveHours = 0;
}
else
{
attendanceTableItem.PaidLeaveHours += attendanceTableItem.ExtraLeaveHours * attendanceTableItem.Cat_LeaveDayType1.PaidRate;
attendanceTableItem.UnpaidLeaveHours += attendanceTableItem.ExtraLeaveHours * (1 - attendanceTableItem.Cat_LeaveDayType1.PaidRate);
}
}
#endregion
if (attendanceTableItem.DutyCode == DutyCode.E_ON.ToString())
{
#region IsHavingPregTreatment
if (attendanceTableItem.IsHavingPregTreatment)
{
if ((attendanceTableItem.WorkPaidHours + attendanceTableItem.PaidLeaveHours) > attendanceTableItem.AvailableHours)
{
attendanceTableItem.WorkPaidHours = attendanceTableItem.AvailableHours - attendanceTableItem.PaidLeaveHours;
}
else
{
attendanceTableItem.WorkPaidHours = attendanceTableItem.WorkPaidHours;
}
}
#endregion
#region LateEarlyMinutes
attendanceTableItem.LateEarlyMinutes = (int)workdayByProfile.LateEarlyDuration.GetDouble();
attendanceTableItem.RealLateEarlyMinutes = attendanceTableItem.LateEarlyMinutes;
#endregion
#region Tính số giờ đi làm
if (workdayByProfile != null && shiftByProfile1 != null)
{
DateTime timeShiftStart1 = workdayByProfile.WorkDate.Date.Add(shiftByProfile1.InTime.TimeOfDay);
DateTime timeShiftEnd1 = timeShiftStart1.AddHours(shiftByProfile1.CoOut);
//Thời gian bắt đầu và kết thúc nghỉ giữa ca - dùng cho tính toán
DateTime timeShiftBreakIn1 = timeShiftStart1.AddHours(shiftByProfile1.CoBreakIn);
DateTime timeShiftBreakOut1 = timeShiftStart1.AddHours(shiftByProfile1.CoBreakOut);
workDuration = GetDuration(workdayByProfile, timeShiftStart1, timeShiftEnd1,
timeShiftBreakIn1, timeShiftBreakOut1, shiftByProfile1.InOutDynamic);
#region Tính số giờ làm ca đêm
if (shiftByProfile1.IsNightShift)
{
DateTime nightTimeStart = workdayByProfile.WorkDate.Date.AddHours(22);
DateTime nightTimeEnd = workdayByProfile.WorkDate.Date.AddDays(1).AddHours(6);
nightTimeStart = workdayByProfile.WorkDate.Date.Add(shiftByProfile1.NightTimeStart.Value.TimeOfDay);
nightTimeEnd = workdayByProfile.WorkDate.Date.Add(shiftByProfile1.NightTimeEnd.Value.TimeOfDay);
nightTimeEnd = nightTimeStart > nightTimeEnd ? nightTimeEnd.AddDays(1) : nightTimeEnd;
//Truong hop nghi giua ca nam trong khoang bat dau ca dem
nightDuration = GetDuration(workdayByProfile, nightTimeStart, nightTimeEnd,
timeShiftBreakIn1, timeShiftBreakOut1, shiftByProfile1.InOutDynamic);
}
#endregion
}
if (workdayByProfile != null && shiftByProfile2 != null)
{
DateTime timeShiftStart2 = workdayByProfile.WorkDate.Date.Add(shiftByProfile2.InTime.TimeOfDay);
DateTime timeShiftEnd2 = timeShiftStart2.AddHours(shiftByProfile2.CoOut);
//Thời gian bắt đầu và kết thúc nghỉ giữa ca - dùng cho tính toán
DateTime timeShiftBreakIn2 = timeShiftStart2.AddHours(shiftByProfile2.CoBreakIn);
DateTime timeShiftBreakOut2 = timeShiftStart2.AddHours(shiftByProfile2.CoBreakOut);
workDuration += GetDuration(workdayByProfile, timeShiftStart2, timeShiftEnd2,
timeShiftBreakIn2, timeShiftBreakOut2, shiftByProfile2.InOutDynamic);
#region Tính số giờ làm ca đêm
if (shiftByProfile2.IsNightShift)
{
DateTime nightTimeStart = workdayByProfile.WorkDate.Date.AddHours(22);
DateTime nightTimeEnd = workdayByProfile.WorkDate.Date.AddDays(1).AddHours(6);
nightTimeStart = workdayByProfile.WorkDate.Date.Add(shiftByProfile2.NightTimeStart.Value.TimeOfDay);
nightTimeEnd = workdayByProfile.WorkDate.Date.Add(shiftByProfile2.NightTimeEnd.Value.TimeOfDay);
nightTimeEnd = nightTimeStart > nightTimeEnd ? nightTimeEnd.AddDays(1) : nightTimeEnd;
//Truong hop nghi giua ca nam trong khoang bat dau ca dem
nightDuration = GetDuration(workdayByProfile, nightTimeStart, nightTimeEnd,
timeShiftBreakIn2, timeShiftBreakOut2, shiftByProfile2.InOutDynamic);
}
#endregion
}
attendanceTableItem.NightShiftHours = (nightDuration / 60);//lưu số giờ
attendanceTableItem.WorkPaidHours = (workDuration / 60);//lưu số giờ
attendanceTableItem.WorkHours = (workDuration / 60);//lưu số giờ
attendanceTableItem.WorkPaidHours = attendanceTableItem.WorkPaidHours < 0 ? 0 : attendanceTableItem.WorkPaidHours;
attendanceTableItem.WorkPaidHours = attendanceTableItem.WorkPaidHours > attendanceTableItem.AvailableHours
? attendanceTableItem.AvailableHours : attendanceTableItem.WorkPaidHours;
#endregion
if (gradeCfg.AttendanceMethod == AttendanceMethod.E_FULL.ToString())
{
#region gradeCfg.AttendanceMethod = E_FULL
if (shiftByProfile1 != null && shiftByProfile1.IsNightShift == true)
{
if (shiftByProfile1.NightTimeEnd != null && shiftByProfile1.NightTimeStart != null)
{
DateTime dateStartNightShift = shiftByProfile1.NightTimeStart.Value;
DateTime dateEndNightShift = shiftByProfile1.NightTimeEnd.Value;
if (dateStartNightShift > dateEndNightShift)
{
dateEndNightShift = dateEndNightShift.AddDays(1);
}
attendanceTableItem.NightShiftHours = dateEndNightShift.Subtract(dateStartNightShift).TotalHours;
}
else
{
attendanceTableItem.NightShiftHours = shiftByProfile1.WorkHours ?? 0;
}
}
else if (shiftByProfile2 != null && shiftByProfile2.IsNightShift == true)
{
if (shiftByProfile2.NightTimeEnd != null && shiftByProfile2.NightTimeStart != null)
{
DateTime dateStartNightShift = shiftByProfile2.NightTimeStart.Value;
DateTime dateEndNightShift = shiftByProfile2.NightTimeEnd.Value;
if (dateStartNightShift > dateEndNightShift)
{
dateEndNightShift = dateEndNightShift.AddDays(1);
}
attendanceTableItem.NightShiftHours = dateEndNightShift.Subtract(dateStartNightShift).TotalHours;
}
else
{
attendanceTableItem.NightShiftHours = shiftByProfile2.WorkHours ?? 0;
}
}
if ((shiftByProfile1 != null && shiftByProfile1.IsNightShift == true)
|| shiftByProfile2 != null && shiftByProfile2.IsNightShift == true)
{
if (attendanceTableItem.Cat_LeaveDayType != null)
{
double hourLeave = attendanceTableItem.LeaveHours + attendanceTableItem.PaidLeaveHours + attendanceTableItem.ExtraLeaveHours;
attendanceTableItem.NightShiftHours = attendanceTableItem.NightShiftHours - hourLeave;
if (attendanceTableItem.NightShiftHours < 0)
{
attendanceTableItem.NightShiftHours = 0;
}
}
}
if (attendanceTableItem.IsHoliday)
{
attendanceTableItem.LeaveHours = attendanceTableItem.PaidLeaveHours = 0;
attendanceTableItem.WorkPaidHours = attendanceTableItem.LateEarlyMinutes = 0;
attendanceTableItem.UnpaidLeaveHours = attendanceTableItem.AvailableHours;
bool isNoLongerWorking = false;
if ((profile.DateHire.HasValue && attendanceTableItem.WorkDate < profile.DateHire.Value)
|| (profile.DateQuit.HasValue && attendanceTableItem.WorkDate >= profile.DateQuit.Value))
{
isNoLongerWorking = true;
}
if (!attendanceTableItem.IsHavingPregTreatment && !isNoLongerWorking && (notAutoRegHolidayLeave == null
|| notAutoRegHolidayLeave.Value1 != bool.TrueString))
{
attendanceTableItem.WorkPaidHours = 0;
attendanceTableItem.LateEarlyMinutes = 0;
attendanceTableItem.UnpaidLeaveHours = 0;
attendanceTableItem.LeaveHours = attendanceTableItem.AvailableHours;
attendanceTableItem.PaidLeaveHours = attendanceTableItem.AvailableHours;
attendanceTableItem.Cat_LeaveDayType = listLeaveDayType.Where(d =>
d.Code == LeavedayTypeCode.HLD.ToString()).FirstOrDefault();
}
}
attendanceTableItem.WorkHours = 0;//Thời gian làm việc = 0
attendanceTableItem.WorkPaidHours = attendanceTableItem.AvailableHours
- attendanceTableItem.UnpaidLeaveHours - attendanceTableItem.PaidLeaveHours;
#endregion
}
#region Trường hợp tăng ca trong ngày lễ
if (attendanceTableItem.Cat_LeaveDayType != null && attendanceTableItem.Cat_LeaveDayType.Code == LeavedayTypeCode.HLD.ToString() &&
(otholidayscompute400 == null || otholidayscompute400.Value1 != bool.TrueString) && attendanceTableItem.Cat_OvertimeType != null)
{
var totalOvertimeHours = attendanceTableItem.OvertimeHours + attendanceTableItem.ExtraOvertimeHours
+ attendanceTableItem.ExtraOvertimeHours2 + attendanceTableItem.ExtraOvertimeHours3;
if (gradeCfg.EDType == PayrollComputeMethod.E_SUBTRACT.ToString())
{
if (attendanceTableItem.AvailableHours > totalOvertimeHours)
{
attendanceTableItem.LeaveHours = attendanceTableItem.AvailableHours - totalOvertimeHours;
attendanceTableItem.ExtraLeaveHours = totalOvertimeHours;
attendanceTableItem.PaidLeaveHours = attendanceTableItem.LeaveHours;
attendanceTableItem.Cat_LeaveDayType1 = null;
}
else
{
attendanceTableItem.Cat_LeaveDayType = null;
attendanceTableItem.LeaveHours = attendanceTableItem.AvailableHours;
attendanceTableItem.PaidLeaveHours = 0;
}
}
else
{
if (attendanceTableItem.AvailableHours >= totalOvertimeHours)
{
attendanceTableItem.LeaveHours = attendanceTableItem.PaidLeaveHours =
attendanceTableItem.AvailableHours - totalOvertimeHours;
}
else
{
attendanceTableItem.LeaveHours = attendanceTableItem.PaidLeaveHours = 0;
}
}
attendanceTableItem.WorkPaidHours = 0;
}
#endregion
}
unitOfWork.AddObject(typeof(Att_AttendanceTableItem), attendanceTableItem);
}
#endregion
#region Tính toán lại phép năm và phép ốm trong kỳ
var annualLeaveDetail = listAnnualDetailByProfile.Where(d => d.Type == AnnualLeaveDetailType.E_ANNUAL_LEAVE.ToString()).FirstOrDefault();
var sickLeaveDetail = listAnnualDetailByProfile.Where(d => d.Type == AnnualLeaveDetailType.E_SICK_LEAVE.ToString()).FirstOrDefault();
var preAttendanceTable = listPreAttendanceTableByProfile.Where(d => d.ProfileID == profileID).FirstOrDefault();
attendanceTable.AnlDayTaken = anlDayTaken;
attendanceTable.SickDayTaken = sickDayTaken;
if (preAttendanceTable != null)
{
if (annualLeaveDetail != null && annualLeaveDetail.MonthYear.HasValue
&& annualLeaveDetail.MonthYear.Value.Date == monthYear.Date)
{
attendanceTable.AnlDayAdjacent = anlDayTaken;
}
else
{
//VinhTran - 0030581 - AnlDayAdjacent là số ngày đã nghỉ tính tới đầu tháng đang tính công
attendanceTable.AnlDayAdjacent = preAttendanceTable.AnlDayAdjacent.GetDouble() + anlDayTaken;
}
if (sickLeaveDetail != null && sickLeaveDetail.MonthYear.HasValue
&& sickLeaveDetail.MonthYear.Value.Date == monthYear.Date)
{
attendanceTable.SickDayAdjacent = sickDayTaken;
}
else
{
//VinhTran - 0030581 - AnlDayAdjacent là số ngày đã nghỉ tính tới đầu tháng đang tính công
attendanceTable.SickDayAdjacent = preAttendanceTable.SickDayAdjacent.GetDouble() + sickDayTaken;
}
}
else
{
attendanceTable.AnlDayAdjacent = anlDayTaken;
attendanceTable.SickDayAdjacent = sickDayTaken;
}
if (annualLeaveDetail != null && annualLeaveDetail.MonthYear.HasValue)
{
attendanceTable.TotalAnlDayAvailable = annualLeaveDetail.Available.Get_Double();
attendanceTable.AnlDayAvailable = attendanceTable.TotalAnlDayAvailable.GetDouble() - attendanceTable.AnlDayAdjacent.GetDouble();
}
else if (preAttendanceTable != null)
{
attendanceTable.AnlDayAvailable = preAttendanceTable.AnlDayAvailable - attendanceTable.AnlDayTaken;
}
if (sickLeaveDetail != null && sickLeaveDetail.MonthYear.HasValue)
{
attendanceTable.TotalSickDayAvailable = sickLeaveDetail.Available.Get_Double();
attendanceTable.SickDayAvailable = attendanceTable.TotalSickDayAvailable.GetDouble() - attendanceTable.SickDayAdjacent.GetDouble();
}
else if (preAttendanceTable != null)
{
//tháng 7: còn 13, liền kề 1, hiện tại 1 => tháng 8: liền kề 2, hiện tại 1, còn 12
attendanceTable.SickDayAvailable = preAttendanceTable.SickDayAvailable.GetDouble() - attendanceTable.SickDayTaken.GetDouble();
}
#endregion
#region Tính toán lại phép bù trong kỳ
foreach (var leaveDayByProfile in listLeaveDayByProfile)
{
if (leaveDayByProfile != null)
{
var dateStart = leaveDayByProfile.DateStart;
var dateEnd = leaveDayByProfile.DateEnd;
if (leaveDayByProfile.DateOvertimeOff.HasValue)
{
dateStart = leaveDayByProfile.DateOvertimeOff.Value;
dateEnd = leaveDayByProfile.DateOvertimeOff.Value;
}
for (DateTime date = dateStart.Date; date <= dateEnd; date = date.AddDays(1))
{
double leaveHours = 0D;
double leaveDays = 0D;
double standardWorkHours = 0;
var leaveDayType = listLeaveDayType.Where(d => d.ID == leaveDayByProfile.LeaveDayTypeID).FirstOrDefault();
var attendanceTableItem = attendanceTable.Att_AttendanceTableItem.Where(d => d.WorkDate == date).FirstOrDefault();
if (attendanceTableItem!=null)
standardWorkHours = attendanceTableItem.udStandardWorkHours;
if (leaveDayByProfile.DurationType == LeaveDayDurationType.E_FULLSHIFT.ToString())
{
//Lấy giờ nghỉ của ngày đang xét dựa vào ca làm việc
leaveHours = standardWorkHours;
leaveDays = 1;//Nghỉ full shift
}
else
{
leaveHours = leaveDayByProfile.LeaveHours.GetDouble();
leaveDays = leaveDayByProfile.LeaveDays.GetDouble();
}
leaveHours = leaveHours > standardWorkHours ? standardWorkHours : leaveHours;
leaveDays = leaveDays > 1 ? 1 : leaveDays;//Tối đa là nghỉ 1 ngày
if (leaveDayType != null && leaveDays > 0)
{
if (leaveDayType.Code == LeavedayTypeCode.CPS.ToString()
|| leaveDayType.Code == LeavedayTypeCode.OCPS.ToString())
{
if ((leaveDayByProfile.DateOvertimeOff.HasValue
&& leaveDayByProfile.DateStart > attendanceTo)
|| date > attendanceTo)
{
//Nghỉ CO tháng sau => coEndPeriod
coEndPeriod += leaveDays;
}
else if (date >= attendanceFrom && date <= attendanceTo)
{
//Nghỉ CO trong tháng => coBeginPeriod
coBeginPeriod += leaveDays;
}
}
}
}
}
}
attendanceTable.COBeginPeriod = coBeginPeriod;
attendanceTable.COEndPeriod = coEndPeriod;
#endregion
#region Cập nhật Att_AttendanceTable sau khi tính xong
#region Sum type HDTJob
var _type4 = attendanceTable.Att_AttendanceTableItem.Where(d => d.HDTJobType == EnumDropDown.HDTJobType.E_TYPE4.ToString());
var _type5 = attendanceTable.Att_AttendanceTableItem.Where(d => d.HDTJobType == EnumDropDown.HDTJobType.E_TYPE5.ToString());
attendanceTable.HDTJobType1 = EnumDropDown.HDTJobType.E_TYPE4.ToString();
attendanceTable.HDTJobType2 = EnumDropDown.HDTJobType.E_TYPE5.ToString();
attendanceTable.HDTJobDayCount1 = _type4 != null ? _type4.Count() : 0;
attendanceTable.HDTJobDayCount2 = _type5 != null ? _type5.Count() : 0;
#endregion
attendanceTable.RealWorkDayCount = attendanceTable.Att_AttendanceTableItem.Where(d => d.udWorkHours > 0).Sum(d => (d.WorkPaidHours + d.LateEarlyMinutes / 60.0) / (d.udStandardWorkHours * d.udStandardWorkHours / d.udWorkHours));
attendanceTable.NightShiftHours = attendanceTable.Att_AttendanceTableItem.Where(d => d.DutyCode == DutyCode.E_ON.ToString()).Sum(d => d.NightShiftHours);
attendanceTable.OTNightShiftHours = attendanceTable.Att_AttendanceTableItem.Where(d => d.DutyCode == DutyCode.E_ON.ToString()).Sum(d => d.OTNightShiftHours.GetDouble());
attendanceTable.LateEarlyDeductionHours += attendanceTable.Att_AttendanceTableItem.Sum(d => d.LateEarlyMinutes) / 60.0;
attendanceTable.UnPaidLeave = attendanceTable.Att_AttendanceTableItem.Sum(d => d.UnpaidLeaveDays.GetDouble());
attendanceTable.PaidLeaveDays = attendanceTable.Att_AttendanceTableItem.Sum(d => d.PaidLeaveDays.GetDouble());
//Tính nghỉ bù
attendanceTable.COBeginPeriod = coBeginPeriod;
attendanceTable.COEndPeriod = coEndPeriod;
//Tính số ngày công chuẩn
int weekendDaysCount = attendanceTable.Att_AttendanceTableItem.Where(d => d.IsHoliday).Count();
attendanceTable.StdWorkDayCount = GetStandardWorkDays(gradeCfg, listHoliday, listShift, listMonthShiftID, monthYear, attendanceFrom, attendanceTo);
attendanceTable.StdWorkDayOTCount = GetOTStandardWorkDays(weekendDaysCount, gradeCfg, listHoliday, listShift, listMonthShiftID, monthYear, attendanceFrom, attendanceTo);
//Tổng số ngày được trả lương của nhân viên đang xét => ngày thực tế
attendanceTable.PaidWorkDayCount = attendanceTable.RealWorkDayCount;
if (gradeCfg.EDType == PayrollComputeMethod.E_SUBTRACT.ToString())
{
//Số ngày công thực tế + số ngày nghỉ hưởng lương
Double workAndPaidLeaveDays = attendanceTable.RealWorkDayCount;
double unHiredDays = 0; double terminatedDays = 0;
if (attendanceTable.Att_AttendanceTableItem.Count() > 0)
{
workAndPaidLeaveDays += attendanceTable.Att_AttendanceTableItem.Sum(d =>
d.PaidLeaveHours / d.udStandardWorkHours);
}
//Nếu nhân viên không vào làm hoặc nghỉ việc trong tháng và số ngày công thực tế + số ngày nghỉ hưởng lương > số ngày công tối thiểu
if (((profile.DateHire.HasValue && profile.DateHire.Value.Date < attendanceFrom) || workAndPaidLeaveDays > attendanceTable.StdWorkDayCount)
&& ((!profile.DateQuit.HasValue || profile.DateQuit.Value.Date > attendanceTo) || workAndPaidLeaveDays > attendanceTable.StdWorkDayCount)
&& workAndPaidLeaveDays >= gradeCfg.MinWorkDay.Value)
{
//Tổng số ngày nghỉ loại 1 và loại 2 khi có trường hợp 1 ngày mà nghỉ 2 loại
Double totalLeaveDays = attendanceTable.Att_AttendanceTableItem.Sum(d =>
(d.LeaveHours + d.ExtraLeaveHours) / d.udStandardWorkHours);
if (isMidCutOffDay)
{
totalLeaveDays = attendanceTable.Att_AttendanceTableItem.Where(d => d.WorkDate <= midCutOffDate)
.Sum(d => d.LeaveHours + d.ExtraLeaveHours / d.udStandardWorkHours);//Số ngày nghỉ không ứng công
}
//Cộng thêm số ngày chưa làm việc - trường hợp làm nửa ca
totalLeaveDays += attendanceTable.Att_AttendanceTableItem.Sum(d =>
d.udNotHiredHours / d.udStandardWorkHours);
if (profile.DateQuit.HasValue)
{
//Cộng thêm số ngày đã nghỉ việc
totalLeaveDays += attendanceTable.Att_AttendanceTableItem.Sum(d =>
d.udTerminatedHours / d.udStandardWorkHours);
}
//Tính số ngày công tính lương = số ngày công chuẩn - tổng số ngày nghỉ
attendanceTable.PaidWorkDayCount = attendanceTable.StdWorkDayCount - totalLeaveDays;
if (attendanceTable.PaidWorkDayCount < 0)
{
attendanceTable.PaidWorkDayCount = 0;
}
}
else if ((gradeCfg.IsApplySubSalaryNewQuitEmp.GetBoolean() && workAndPaidLeaveDays >= gradeCfg.MinWorkDayNewQuitEmp.GetDouble()) &&
((profile.DateHire.HasValue && profile.DateHire.Value.Date >= attendanceFrom) || (profile.DateQuit.HasValue && profile.DateQuit.Value.Date <= attendanceTo)))
{
Double totalLeaveDays = attendanceTable.Att_AttendanceTableItem.Sum(it => (it.LeaveHours + it.ExtraLeaveHours) / it.udStandardWorkHours);
Double DayNonShiftInUnEmployeeTime = 0;//Thời gian của nhân viên không có lịch làm việc trước khi vào công ty hoặc là sau khi ra khỏi công ty trong tháng
if (profile.DateHire.HasValue && profile.DateHire.Value > attendanceFrom)
{
unHiredDays = profile.DateHire.Value.Subtract(attendanceFrom).Days;
for (DateTime DateCheck = attendanceFrom; DateCheck < profile.DateHire.Value; DateCheck = DateCheck.AddDays(1))
{
if (listMonthShiftID == null || !listMonthShiftID.Any(d =>
d.Key.Date == DateCheck.Date && d.Value != null))
{
DayNonShiftInUnEmployeeTime++;
}
}
}
if (profile.DateQuit.HasValue && profile.DateQuit.Value < attendanceTo)
{
terminatedDays = attendanceTo.Subtract(profile.DateQuit.Value).Days + 1;
for (DateTime DateCheck = profile.DateQuit.Value; DateCheck < attendanceTo; DateCheck = DateCheck.AddDays(1))
{
if (listMonthShiftID == null || !listMonthShiftID.Any(d =>
d.Key.Date == DateCheck.Date && d.Value != null))
{
DayNonShiftInUnEmployeeTime++;
}
}
}
Double paidWorkDay = attendanceTable.StdWorkDayCount - totalLeaveDays;
paidWorkDay = paidWorkDay - (unHiredDays + terminatedDays - DayNonShiftInUnEmployeeTime) * gradeCfg.RateUneven.GetDouble();
attendanceTable.PaidWorkDayCount = paidWorkDay;
}
}
#region Tính tổng thời gian theo từng loại ngày nghỉ và loại làm thêm
TotalGroupByLeaveDayType(attendanceTable, attendanceTo);
TotalGroupByOvertimeType(attendanceTable, attendanceTo);
#endregion
#region Tính tổng thời gian và làm tròn
attendanceTable.TotalPaidWorkDayCount = attendanceTable.PaidWorkDayCount;
attendanceTable.TotalRealWorkDayCount = attendanceTable.RealWorkDayCount;
//Cấu hình làm tròng trễ sớm theo tháng
if (gradeCfg != null && gradeCfg.IsLateEarlyFirstLastShiftRound == true)
{
attendanceTable.LateEarlyDeductionHours = Att_AttendanceLib.RoundLateEarlyMinutes(listLateEarlyRule.Where(d =>
d.GradeCfgID == gradeCfg.ID).ToList(), Convert.ToInt32(attendanceTable.LateEarlyDeductionHours * 60)) / 60;
}
#endregion
#endregion
return attendanceTable != null ? 1 : 0;
}
/// <summary>
/// Tính tổng thời gian làm thêm theo từng loại trên chi tiết gán vào Att_AttendanceTable
/// </summary>
/// <param name="attendanceTable"></param>
/// <param name="midCutOffDate"></param>
private static void TotalGroupByOvertimeType(Att_AttendanceTable attendanceTable, DateTime midCutOffDate)
{
//Nếu làm thêm nhiều loại làm thêm khác nhau thì ưu tiên cột Cat_OvertimeType trước...
List<Att_AttendanceTableItem> listAttendanceTableItem = attendanceTable.Att_AttendanceTableItem.Where(d => d.WorkDate <= midCutOffDate
&& (d.Cat_OvertimeType != null || d.Cat_OvertimeType1 != null || d.Cat_OvertimeType2 != null || d.Cat_OvertimeType3 != null)).ToList();
foreach (Att_AttendanceTableItem item in listAttendanceTableItem)
{
#region item.Cat_OvertimeType != null
if (item.Cat_OvertimeType != null)
{
if (attendanceTable.Cat_OvertimeType == null || attendanceTable.Cat_OvertimeType == item.Cat_OvertimeType)
{
attendanceTable.Cat_OvertimeType = item.Cat_OvertimeType;
attendanceTable.Overtime1Hours += item.OvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType1 == null || attendanceTable.Cat_OvertimeType1 == item.Cat_OvertimeType)
{
attendanceTable.Cat_OvertimeType1 = item.Cat_OvertimeType;
attendanceTable.Overtime2Hours += item.OvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType2 == null || attendanceTable.Cat_OvertimeType2 == item.Cat_OvertimeType)
{
attendanceTable.Cat_OvertimeType2 = item.Cat_OvertimeType;
attendanceTable.Overtime3Hours += item.OvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType3 == null || attendanceTable.Cat_OvertimeType3 == item.Cat_OvertimeType)
{
attendanceTable.Cat_OvertimeType3 = item.Cat_OvertimeType;
attendanceTable.Overtime4Hours += item.OvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType4 == null || attendanceTable.Cat_OvertimeType4 == item.Cat_OvertimeType)
{
attendanceTable.Cat_OvertimeType4 = item.Cat_OvertimeType;
attendanceTable.Overtime4Hours += item.OvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType5 == null || attendanceTable.Cat_OvertimeType5 == item.Cat_OvertimeType)
{
attendanceTable.Cat_OvertimeType5 = item.Cat_OvertimeType;
attendanceTable.Overtime4Hours += item.OvertimeHours;
}
}
#endregion
#region item.Cat_OvertimeType1 != null
if (item.Cat_OvertimeType1 != null)
{
if (attendanceTable.Cat_OvertimeType == null || attendanceTable.Cat_OvertimeType == item.Cat_OvertimeType1)
{
attendanceTable.Cat_OvertimeType = item.Cat_OvertimeType1;
attendanceTable.Overtime1Hours += item.ExtraOvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType1 == null || attendanceTable.Cat_OvertimeType1 == item.Cat_OvertimeType1)
{
attendanceTable.Cat_OvertimeType1 = item.Cat_OvertimeType1;
attendanceTable.Overtime2Hours += item.ExtraOvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType2 == null || attendanceTable.Cat_OvertimeType2 == item.Cat_OvertimeType1)
{
attendanceTable.Cat_OvertimeType2 = item.Cat_OvertimeType1;
attendanceTable.Overtime3Hours += item.ExtraOvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType3 == null || attendanceTable.Cat_OvertimeType3 == item.Cat_OvertimeType1)
{
attendanceTable.Cat_OvertimeType3 = item.Cat_OvertimeType1;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType4 == null || attendanceTable.Cat_OvertimeType4 == item.Cat_OvertimeType1)
{
attendanceTable.Cat_OvertimeType4 = item.Cat_OvertimeType1;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours;
}
else if (attendanceTable.Cat_OvertimeType5 == null || attendanceTable.Cat_OvertimeType5 == item.Cat_OvertimeType1)
{
attendanceTable.Cat_OvertimeType5 = item.Cat_OvertimeType1;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours;
}
}
#endregion
#region item.Cat_OvertimeType2 != null
if (item.Cat_OvertimeType2 != null)
{
if (attendanceTable.Cat_OvertimeType == null || attendanceTable.Cat_OvertimeType == item.Cat_OvertimeType2)
{
attendanceTable.Cat_OvertimeType = item.Cat_OvertimeType2;
attendanceTable.Overtime1Hours += item.ExtraOvertimeHours2;
}
else if (attendanceTable.Cat_OvertimeType1 == null || attendanceTable.Cat_OvertimeType1 == item.Cat_OvertimeType2)
{
attendanceTable.Cat_OvertimeType1 = item.Cat_OvertimeType2;
attendanceTable.Overtime2Hours += item.ExtraOvertimeHours2;
}
else if (attendanceTable.Cat_OvertimeType2 == null || attendanceTable.Cat_OvertimeType2 == item.Cat_OvertimeType2)
{
attendanceTable.Cat_OvertimeType2 = item.Cat_OvertimeType2;
attendanceTable.Overtime3Hours += item.ExtraOvertimeHours2;
}
else if (attendanceTable.Cat_OvertimeType3 == null || attendanceTable.Cat_OvertimeType3 == item.Cat_OvertimeType2)
{
attendanceTable.Cat_OvertimeType3 = item.Cat_OvertimeType2;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours2;
}
else if (attendanceTable.Cat_OvertimeType4 == null || attendanceTable.Cat_OvertimeType4 == item.Cat_OvertimeType2)
{
attendanceTable.Cat_OvertimeType4 = item.Cat_OvertimeType2;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours2;
}
else if (attendanceTable.Cat_OvertimeType5 == null || attendanceTable.Cat_OvertimeType5 == item.Cat_OvertimeType2)
{
attendanceTable.Cat_OvertimeType5 = item.Cat_OvertimeType2;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours2;
}
}
#endregion
#region item.Cat_OvertimeType3 != null
if (item.Cat_OvertimeType3 != null)
{
if (attendanceTable.Cat_OvertimeType == null || attendanceTable.Cat_OvertimeType == item.Cat_OvertimeType3)
{
attendanceTable.Cat_OvertimeType = item.Cat_OvertimeType3;
attendanceTable.Overtime1Hours += item.ExtraOvertimeHours3;
}
else if (attendanceTable.Cat_OvertimeType1 == null || attendanceTable.Cat_OvertimeType1 == item.Cat_OvertimeType3)
{
attendanceTable.Cat_OvertimeType1 = item.Cat_OvertimeType3;
attendanceTable.Overtime2Hours += item.ExtraOvertimeHours3;
}
else if (attendanceTable.Cat_OvertimeType2 == null || attendanceTable.Cat_OvertimeType2 == item.Cat_OvertimeType3)
{
attendanceTable.Cat_OvertimeType2 = item.Cat_OvertimeType3;
attendanceTable.Overtime3Hours += item.ExtraOvertimeHours3;
}
else if (attendanceTable.Cat_OvertimeType3 == null || attendanceTable.Cat_OvertimeType3 == item.Cat_OvertimeType3)
{
attendanceTable.Cat_OvertimeType3 = item.Cat_OvertimeType3;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours3;
}
else if (attendanceTable.Cat_OvertimeType4 == null || attendanceTable.Cat_OvertimeType4 == item.Cat_OvertimeType3)
{
attendanceTable.Cat_OvertimeType4 = item.Cat_OvertimeType3;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours3;
}
else if (attendanceTable.Cat_OvertimeType5 == null || attendanceTable.Cat_OvertimeType5 == item.Cat_OvertimeType3)
{
attendanceTable.Cat_OvertimeType5 = item.Cat_OvertimeType3;
attendanceTable.Overtime4Hours += item.ExtraOvertimeHours3;
}
}
#endregion
}
}