public AttendanceServiceDTO GetExsitedAttendanceData(int?Y, int?M)
{
if (Y == null || M == null)
{
return(null);
}
var report = _pinhuaContext.AttendanceReport.AsNoTracking().FirstOrDefault(r => r.Y == Y && r.M == M);
if (report == null)
{
return(null);
}
var reportResults = (from d in _pinhuaContext.AttendanceReportResults.AsNoTracking()
where d.ExcelServerRcid == report.ExcelServerRcid
select d).ToList();
var reportDetails = (from d in _pinhuaContext.AttendanceReportDetails.AsNoTracking()
where d.ExcelServerRcid == report.ExcelServerRcid
select d).ToList();
var rule = GetRule();
var days = DateTime.DaysInMonth(Y.Value, M.Value);
var dto = new AttendanceServiceDTO
{
Y = Y,
M = M,
Rule = rule,
PersonList = new List <AttendanceServicePerson>()
};
foreach (var result in reportResults)
{
var dayResults = new List <AttendanceServiceDayResult>();
var group = from p in reportDetails.Where(d => d.编号 == result.编号)
group p by p.日期 into g
select new
{
日期 = g.Key,
Details = g.Select(a => a)
};
foreach (var detail in group)
{
var a = new List <AttendanceServiceDayDetail>();
foreach (var x in detail.Details)
{
a.Add(new AttendanceServiceDayDetail
{
RangeId = x.班段,
Range = x.班段描述,
State = x.考勤结果,
Time1Fix = x.班,
Time2Fix = x.班,
Hours = x.工时
});
}
dayResults.Add(new AttendanceServiceDayResult
{
Date = detail.日期.Value,
Details = a.OrderBy(d => d.RangeId).ToList(),
});
}
var person = new AttendanceServicePerson
{
Id = result.编号,
Name = result.姓名,
IsFullAttendance = result.是否全勤 == "是",
DaytimeHours = result.正班,
OvertimeHours = result.加班,
TimesOfAbsent = result.缺勤,
TimesOfAskForLeave = result.请假,
TimesOfDinner = result.用餐,
TimesOfLate = result.迟到,
TimesOfLeaveEarly = result.早退,
TotalHours = result.总工时,
Results = dayResults.OrderBy(r => r.Date).ToList()
};
dto.PersonList.Add(person);
}
return(dto);
}
public AttendanceServiceDTO GetAttendanceData(int?Y, int?M)
{
if (Y == null || M == null)
{
return(null);
}
var files = _pinhuaContext.人员档案.AsNoTracking().ToList();
var overtimeForms = _pinhuaContext.OvertimeFormMain.Where(f => f.Y == Y && f.M == M).ToList();
var records = GetTimeRecrods(Y.Value, M.Value).OrderBy(p => p.Id).ThenBy(p => p.SignTime);
if (records.Count() == 0)
{
return(null);
}
var recordsGroupBy = from p in records
group p by new { p.Id, p.Name } into g
select new
{
g.Key.Id,
g.Key.Name,
SignTimes = g.Select(p => p.SignTime).ToList()
};
var rule = GetRule();
var holidays = _pinhuaContext.放假登记.AsNoTracking().ToList();
var days = DateTime.DaysInMonth(Y.Value, M.Value);
var dto = new AttendanceServiceDTO
{
Y = Y,
M = M,
Rule = rule,
PersonList = new List <AttendanceServicePerson>()
};
foreach (var record in recordsGroupBy)
{
var person = new AttendanceServicePerson
{
Id = record.Id,
Name = record.Name,
Results = new List <AttendanceServiceDayResult>()
};
for (int i = 0; i != days; i++)
{
var D = i + 1;
var result = new AttendanceServiceDayResult
{
Date = new DateTime(Y.Value, M.Value, D),
Details = new List <AttendanceServiceDayDetail>()
};
foreach (var range in rule.Ranges)
{
if (_pinhuaContext.拖班登记.AsNoTracking().Any(p => p.人员编号 == person.Id && p.时间.Value.Date == result.Date)) // 计算延班情况
{
if (range.RangeId == 2)
{
continue;
}
if (range.RangeId == 1)
{
range.Ending = new DateTime(1900, 1, 1, 21, 0, 0);
}
}
(var workfrom, var workto) = 指定日期的班段起止(range, new DateTime(Y.Value, M.Value, D));
(var clockinfrom, var clockinto) = 指定日期的签到起止(range, new DateTime(Y.Value, M.Value, D));
var checkin = record.SignTimes.Where(p => p.Value.IsBetween(clockinfrom, clockinto)).OrderBy(p => p).FirstOrDefault();
record.SignTimes.Remove(checkin);
(var clockoutfrom, var clockoutto) = 指定日期的签退起止(range, new DateTime(Y.Value, M.Value, D));
IEnumerable <DateTime?> set = null;
if (checkin.HasValue)
{
set = record.SignTimes.Where(p => p.Value.IsBetween(clockoutfrom, clockoutto) && p.Value.Subtract(checkin ?? DateTime.MaxValue).TotalHours >= 1).OrderBy(p => p);
}
else
{
set = record.SignTimes.Where(p => p.Value.IsBetween(clockoutfrom, clockoutto)).OrderBy(p => p);
}
DateTime?checkout = null;
if (set.Count() > 0)
{
checkout = set.FirstOrDefault();
record.SignTimes.Remove(checkout);
}
var detail = new AttendanceServiceDayDetail
{
RangeId = range.RangeId,
Range = range.ToRangeString(),
Time1 = checkin,
Time1Fix = (checkin < workfrom && checkin.HasValue) ? workfrom : checkin,
Time2 = checkout,
Time2Fix = checkout > workto ? (range.延迟算加班 == "是" ? checkout : workto) : checkout,
};
if (checkin.HasValue && checkout.HasValue)
{
if (range.RangeId == 2)
{
// 判断在不在加班名单中，如果没有加班名单，就允许所有人加班，如果有加班名单，在名单的允许加班，不在名单的不允许加班
var overtimeForm = overtimeForms.FirstOrDefault(f => f.D == D);
if (overtimeForm == null)
{
// 不存在加班名单
detail.State = "正常";
}
else
{
// 存在加班名单
var overtimeDetails = _pinhuaContext.OvertimeFormDetails.AsNoTracking().Where(d => d.ExcelServerRcid == overtimeForm.ExcelServerRcid);
if (overtimeDetails.Any(d => d.Id == person.Id))
{
// 如果员工在加班名单中
detail.State = "正常";
}
else
{
// 如果不在加班单中，即使有考勤数据也判定为无效
detail.State = "未加班";
detail.Time1Fix = null;
detail.Time2Fix = null;
result.Details.Add(detail);
break;
}
}
}
else
{
detail.State = "正常";
}
var workSpan = detail.Time2Fix.Value.DropSeconds().Subtract(detail.Time1Fix.Value.DropSeconds());
//var minutes = workSpan.TotalMinutes > 0 ? Math.Floor(workSpan.TotalMinutes) : 0;
var restSpan = new TimeSpan();
if (range.中途休息 == 1)
{
var restfrom = range.休息开始时间.Value.ConvertToTargetDate(new DateTime(Y.Value, M.Value, D));
var restto = range.休息结束时间.Value.ConvertToTargetDate(new DateTime(Y.Value, M.Value, D));
restSpan = GetOverlapSpan(detail.Time1Fix.Value, detail.Time2Fix.Value, restfrom, restto);
}
workSpan = workSpan - restSpan;
var hours = Math.Floor(workSpan.TotalHours * 10) / 10;
detail.Hours = (decimal)hours;
result.Details.Add(detail);
}
else
{
if (range.计算全勤 == "是")
{
if (result.Date < files.FirstOrDefault(f => f.人员编号 == person.Id)?.入职时间) // 在入职以前没有考勤记录，不算缺勤
{
detail.State = "正常";
}
else
{
detail.State = "缺勤";
}
}
result.Details.Add(detail);
}
if (holidays.Where(d => result.Date.IsBetween(d.期初, d.期末 ?? d.期初)).Count() > 0)
{
detail.State = "放假";
}
if (_pinhuaContext.拖班登记.AsNoTracking().Any(p => p.人员编号 == person.Id && p.时间.Value.Date == result.Date)) // 计算延班情况
{
detail.State = "延班";
}
}
result.DayHours = result.Details.Sum(p => p.Hours);
result.State = GetState(result.Details);
if (holidays.Where(d => result.Date.IsBetween(d.期初, d.期末 ?? d.期初)).Count() > 0)
{
result.State = "放假";
}
person.Results.Add(result);
}
person.TotalHours = person.Results.Sum(p => p.DayHours);
person.IsFullAttendance = IsFullWorkAttendance(person.Results);
int times = 0;
foreach (var x in person.Results)
{
foreach (var y in x.Details)
{
if (y.Time1 != null && y.Time2 != null)
{
times++;
}
}
}
person.DaytimeHours = person.Results.Sum(p => p.DayHours > 9 ? 9 : p.DayHours);
person.OvertimeHours = person.Results.Sum(p => p.DayHours > 9 ? p.DayHours - 9 : 0);
person.TimesOfDinner = times;
dto.PersonList.Add(person);
}
dto.TotalHours = dto.PersonList.Sum(p => p.TotalHours);
return(dto);
}
