using OASystem.API.OAMethodLib.QiYeWeChatAPI;
using OASystem.Domain;
using OASystem.Domain.Entities.PersonnelModule;
using OASystem.Domain.ViewModels.PersonnelModule;
using OASystem.Domain.ViewModels.QiYeWeChat;
using OASystem.Infrastructure.Repositories.Groups;
using TencentCloud.Ocr.V20181119.Models;
namespace OASystem.API.OAMethodLib
{
///
/// 工资计算
///
public static class PayrollComputation
{
private static Result _result = new Result();
private static readonly IQiYeWeChatApiService _qiYeWeChatApiService = AutofacIocManager.Instance.GetService();
private static readonly UsersRepository _usersRep = AutofacIocManager.Instance.GetService();
private static readonly IMapper _mapper = AutofacIocManager.Instance.GetService();
private static readonly decimal _chengDuMinimumWage = 2100.00M;
///
/// 计算工资
///
///
///
///
///
///
///
public static async Task SalaryCalculatorAsync(
List pm_WageSheetDattaSources, List userNames,int userId, string thisYearMonth, DateTime startDt, DateTime endDt)
{
if (pm_WageSheetDattaSources.Count <= 0)
{
_result.Msg = "计算工资传入数据为空!";
return _result;
}
if (userNames.Count <= 0 )
{
var nameData = await _usersRep.GetUserNameList(1);
userNames = nameData.Data;
}
//获取所有打卡数据
CheckInView checkIn = await _qiYeWeChatApiService.GetCheckin_MonthDataAsync(startDt, endDt); //时间段内所有 打卡数据
if (checkIn.errcode != 0)
{
_result.Msg = checkIn.errmsg;
return _result;
}
List checkInDatas = checkIn.datas;
//请假
List sp_leave_details = new List();
sp_leave_details = await _qiYeWeChatApiService.GetApprovalDetailsAsync(startDt, endDt, 2, 1); //时间段内所有 已同意的 请假 审批数据
if (sp_leave_details.Count <= 0)
{
string errMsg = startDt + " - " + endDt + "请假 审批数据获取失败!";
return _result;
}
//打卡补卡
List sp_reissuecard_details = new List();
sp_reissuecard_details = await _qiYeWeChatApiService.GetApprovalDetailsAsync(startDt, endDt, 2, 2); //时间段内所有 已同意的 打卡补卡 审批数据
if (sp_reissuecard_details.Count <= 0)
{
string errMsg = startDt + " - " + endDt + "打卡补卡 审批数据获取失败!";
return _result;
}
foreach (var pm_wsInfo in pm_WageSheetDattaSources)
{
string itemName = userNames.Where(it => it.Id == pm_wsInfo.UserId).FirstOrDefault().CnName;
//补贴 金额
decimal meal_subsidy = 0.00M; // 午餐(午餐10元/天) 补贴 * 计算方式:单日上午请假时长(小时)大于或者等于三小时 没有餐补
//事假 病假 总金额
decimal personalLeaveTotal = 0.00M, // 事假 日薪 *计算方式:日平均工资 = 月工资/当月应出勤天数。
sickLeaveTotal = 0.00M; // 病假 日薪 *计算方式:日平均工资 = 成都市最低工资标准的80%/当月应出勤天数。 短期病假=当月15天内
//扣款金额
decimal beLate_deduction = 0.00M, // 迟到 扣款金额 *计算方式:
// 一个自然月内,不足 10 分钟的迟到/早退,不超过 2 次的部分,不做处罚;3 次及以上,按50元 / 次处罚;
// 超过 10 分钟(含 10 分钟),不足 60 分钟的迟到/早退,按 50 元/次处罚;
// 超过 60 分钟(含 60 分钟),不足 3 小时的迟到/早退,且无请假者,按旷工半日处理;超过3 小时的迟到 / 早退,且无请假者,按旷工一日处理。
early_deduction = 0.00M, // 早退 扣款金额
absenteeism_deduction = 0.00M, // 旷工 扣款金额 *计算方式:旷工扣发当日工资
unprinted_deduction = 0.00M, // 未打卡 扣款金额 *计算方式:
// 试用期员工每月有 2 次 补卡机会,超过 2 次不足 5 次的部分,按 10 元 / 次处罚,5 次及以上的漏卡,按 50 元 / 次处罚;
// 正式员工每月 3 次以内的补卡,按 10 元 / 次处罚,3 次及以上的漏卡,按 50 元 / 次处罚。
sickLeave_deduction = 0.00M,
other_deduction = 0.00M; // 其他 扣款金额
decimal meal_deduction = 0.00M; // 餐补 扣款金额
decimal reissuecard_deduction = 0.00M; // 补卡 扣款金额
//打卡数据
Data? checkInData = checkInDatas.Where(it => it.base_info.name == itemName).FirstOrDefault();
if (checkInData == null) { continue; }
string acctid = checkInData.base_info.acctid; //用户Id
//当月总计数据
Summary_Info? summary_Info = checkInData.summary_info;
if (summary_Info == null) { continue; }
int work_days = summary_Info.work_days; //应出勤天数
int regular_days = summary_Info.regular_days; //正常出勤天数
meal_subsidy = work_days * 10; //应发放餐补
#region 计算日工资 正常日薪 事假日薪 病假日薪
//月 - 应发工资
decimal amountPayable = pm_wsInfo.Basic + pm_wsInfo.Floats + pm_wsInfo.PostAllowance + pm_wsInfo.GarmentWashSubsidies + pm_wsInfo.CommunicationSubsidies +
pm_wsInfo.TrafficSubsidies + pm_wsInfo.InformationSecurityFee + pm_wsInfo.OperationBonus + pm_wsInfo.SpecialAllowance + pm_wsInfo.OtherSubsidies + pm_wsInfo.GroupCost;
// 日薪 = 事假日薪 *计算方式:日平均工资 = 月工资/当月应出勤天数。
decimal dailyWage = amountPayable / work_days;
// 病假日薪 *计算方式:日平均工资 = 成都市最低工资标准的80%/当月应出勤天数。 短期病假=当月15天内
decimal sickLeave_dailywage = _chengDuMinimumWage / work_days;
//病假 一天扣款
sickLeave_deduction = dailyWage - sickLeave_dailywage;
#endregion
int annualLeaveNum = 0, //年假
personalLeaveNum = 0, //事假
sickLeaveNum = 0, //病假
lieuLeaveNum = 0, //调休假
marriageLeaveNum = 0, //婚嫁
maternityLeaveNum = 0, //产假
paternityLeaveNum = 0, //陪产假
funeralLeaveNum = 0, //丧假
reissueCardNum = 0, //补卡 次数
evectionNum = 0, //出差 次数
outIngNum = 0, //外出 次数
outWorkNum = 0, //外勤 次数
otherLeaveNum = 0; //其他
#region 假勤 处理 1-请假;2-补卡;3-出差;4-外出;100-外勤;
List? sp_items = checkInData.sp_items.Where(it => it.count != 0).ToList();
if (sp_items != null && sp_items.Count > 0)
{
annualLeaveNum = Fallibilitydispose(sp_items, 1, "年假");
personalLeaveNum = Fallibilitydispose(sp_items, 1, "事假");
sickLeaveNum = Fallibilitydispose(sp_items, 1, "病假");
lieuLeaveNum = Fallibilitydispose(sp_items, 1, "调休假");
marriageLeaveNum = Fallibilitydispose(sp_items, 1, "婚嫁");
maternityLeaveNum = Fallibilitydispose(sp_items, 1, "产假");
paternityLeaveNum = Fallibilitydispose(sp_items, 1, "陪产假");
funeralLeaveNum = Fallibilitydispose(sp_items, 1, "丧假");
otherLeaveNum = Fallibilitydispose(sp_items, 1, "其他");
reissueCardNum = Fallibilitydispose(sp_items, 2, "补卡次数");
evectionNum = Fallibilitydispose(sp_items, 3, "出差");
outIngNum = Fallibilitydispose(sp_items, 4, "外出");
outWorkNum = Fallibilitydispose(sp_items, 3, "外勤");
}
#region 请假类型金额/餐补 处理
List sp_leave_item_infosData = sp_leave_details.Where(it => it.applyer.userid == acctid).ToList();
List ex_Items = new List();//假勤 And 打卡备注集合
Ex_Items ex_Items_jq = new Ex_Items() { Type = "假勤" }; //假勤
List ex_ItemInfos = new List();
foreach (Sp_Detail sp_item in sp_leave_item_infosData)
{
Apply_data? apply_data = sp_item.apply_data;
if (apply_data != null)
{
List contents = apply_data.contents;
ContentsItem content_Vacation = contents.Where(it => it.control== "Vacation").FirstOrDefault(); //请假类型
ContentsItem content_Textarea = contents.Where(it => it.control == "Textarea").FirstOrDefault(); //多行文本
if (content_Vacation != null)
{
Vacation vacation = content_Vacation.value.vacation;
Attendance attendance = vacation.attendance; //假勤组件
Selector selector = vacation.selector; //请假类型
}
//请假时长
//double leaveLength = (sp_leave.end_time_dt - sp_leave.start_time_dt).TotalHours;
//string typeName = string.Empty;
////leave_type 1年假;2事假;3病假;4调休假;5婚假;6产假;7陪产假;8其他
//switch (sp_leave.leave_type)
//{
// case 1: //年假
// typeName = "年假";
// if (sp_leave.timeunit == 0) //半天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.timeunit == 1) //小时
// {
// if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.duration > 7.5)
// {
// decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
// meal_deduction += daysPrice;
// }
// }
// break;
// case 2: //事假 需调整
// typeName = "事假";
// if (sp_leave.timeunit == 0) //半天
// {
// meal_deduction += 10;
// personalLeaveTotal += dailyWage / 2;
// }
// else if (sp_leave.timeunit == 1) //小时
// {
// if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.duration > 7.5)
// {
// decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
// meal_deduction += daysPrice;
// }
// }
// break;
// case 3: //病假 需调整
// typeName = "病假";
// if (sp_leave.timeunit == 0) //半天
// {
// meal_deduction += 10;
// sickLeaveTotal += sickLeave_deduction / 2;
// }
// else if (sp_leave.timeunit == 1) //小时
// {
// if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.duration > 7.5)
// {
// decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
// meal_deduction += daysPrice;
// }
// }
// break;
// case 4: //调休假
// typeName = "调休假";
// if (sp_leave.timeunit == 0) //半天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.timeunit == 1) //小时
// {
// if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.duration > 7.5)
// {
// decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
// meal_deduction += daysPrice;
// }
// }
// break;
// case 5: //婚假
// typeName = "婚假";
// if (sp_leave.timeunit == 0) //半天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.timeunit == 1) //小时
// {
// if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.duration > 7.5)
// {
// decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
// meal_deduction += daysPrice;
// }
// }
// break;
// case 6: //产假
// typeName = "产假";
// if (sp_leave.timeunit == 0) //半天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.timeunit == 1) //小时
// {
// if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.duration > 7.5)
// {
// decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
// meal_deduction += daysPrice;
// }
// }
// break;
// case 7: //陪产假
// typeName = "陪产假";
// if (sp_leave.timeunit == 0) //半天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.timeunit == 1) //小时
// {
// if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
// {
// meal_deduction += 10;
// }
// else if (sp_leave.duration > 7.5)
// {
// decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
// meal_deduction += daysPrice;
// }
// }
// break;
// default:
// break;
//}
//Ex_Item ex_Item = new Ex_Item()
//{
// SubTypeId = sp_leave.leave_type,
// SubType = typeName,
// Start_time_dt = sp_leave.start_time_dt,
// End_time_dt = sp_leave.end_time_dt,
// Duration = sp_leave.duration,
// Reason = sp_leave.reason,
// Apply_time_dt = sp_item.apply_time_dt,
// Approval_name = sp_item.approval_name,
//};
//ex_ItemInfos.Add(ex_Item);
}
}
if (ex_ItemInfos.Count > 0)
{
ex_Items_jq.Ex_ItemInfo = ex_ItemInfos.OrderBy(it => it.SubTypeId).ThenBy(it => it.Start_time_dt).ToList();
ex_Items.Add(ex_Items_jq);
}
#endregion
#endregion
#region 打卡补卡 处理
if (reissueCardNum == 3)
{
reissuecard_deduction += 10;
}
else if (reissueCardNum >= 4)
{
reissuecard_deduction += 50;
}
#endregion
Ex_Items ex_Items_dk = new Ex_Items() { Type = "打卡" }; //打卡
//List ex_reissuecard_Items = new List();
List ex_reissuecard_Items = new List();
List sp_reissuecard_item_InfosData = sp_reissuecard_details.Where(it => it.applyer.userid == acctid).ToList();
#region 打卡异常处理 统计 1-迟到;2-早退;3-缺卡;4-旷工;5-地点异常;6-设备异常;
int beLateNum = 0, // 1-迟到;
leaveEarlyNum = 0, // 2-早退;
dummyDeckNum = 0, // 3-缺卡;
minerNum = 0, // 4-旷工;
locationAnomalyNum = 0, // 5-地点异常;
unitExNum = 0; // 6-设备异常;
if (summary_Info.except_days > 0)
{
List? ex_infos = checkInData.exception_infos;
if (ex_infos != null && ex_infos.Count >= 0)
{
beLateNum = ExceptionStatistics(ex_infos, 1);
leaveEarlyNum = ExceptionStatistics(ex_infos, 2);
dummyDeckNum = ExceptionStatistics(ex_infos, 3);
minerNum = ExceptionStatistics(ex_infos, 4);
locationAnomalyNum = ExceptionStatistics(ex_infos, 5);
unitExNum = ExceptionStatistics(ex_infos, 6);
}
}
//foreach (Sp_Info sp_reissuecard_item in sp_reissuecard_item_InfosData)
//{
// DateTime apply_time_dt = sp_reissuecard_item.apply_time_dt; //申请时间
// List? approval_name = sp_reissuecard_item.approval_name; //审核人
// Comm sp_comm = sp_reissuecard_item.comm;
// if (sp_comm != null)
// {
// if (sp_comm.applydata != null)
// {
// List applyInfos = sp_comm.applydata;
// if (applyInfos.Count > 0)
// {
// //Ex_Item ex_reissuecard_Item = new Ex_Item();
// dynamic ex_reissuecard_Item = null;
// string text = applyInfos.Where(it => it.type == "text").FirstOrDefault().value.ToString(); //异常状态
// DateTime? datehour = applyInfos.Where(it => it.type == "datehour").FirstOrDefault().valueDt;//补卡时间
// string textarea = applyInfos.Where(it => it.type == "textarea").FirstOrDefault().value.ToString();//补卡事由
// if (text.Contains("未打卡"))
// {
// ex_reissuecard_Item = new
// {
// SubTypeId = 0,
// SubType = "未打卡",
// title = text,
// datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
// textarea = textarea,
// apply_time_dt = apply_time_dt,
// approval_name = approval_name
// };
// }
// else if (text.Contains("迟到"))
// {
// ex_reissuecard_Item = new
// {
// SubTypeId = 1,
// SubType = "迟到",
// title = text,
// datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
// textarea = textarea,
// apply_time_dt = apply_time_dt,
// approval_name = approval_name
// };
// }
// else if (text.Contains("早退"))
// {
// ex_reissuecard_Item = new
// {
// SubTypeId = 2,
// SubType = "早退",
// title = text,
// datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
// textarea = textarea,
// apply_time_dt = apply_time_dt,
// approval_name = approval_name
// };
// }
// else if (text.Contains("缺卡"))
// {
// ex_reissuecard_Item = new
// {
// SubTypeId = 3,
// SubType = "缺卡",
// title = text,
// datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
// textarea = textarea,
// apply_time_dt = apply_time_dt,
// approval_name = approval_name
// };
// }
// else if (text.Contains("旷工"))
// {
// ex_reissuecard_Item = new
// {
// SubTypeId = 4,
// SubType = "旷工",
// title = text,
// datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
// textarea = textarea,
// apply_time_dt = apply_time_dt,
// approval_name = approval_name
// };
// }
// else if (text.Contains("地点异常"))
// {
// ex_reissuecard_Item = new
// {
// SubTypeId = 5,
// SubType = "地点异常",
// title = text,
// datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
// textarea = textarea,
// apply_time_dt = apply_time_dt,
// approval_name = approval_name
// };
// }
// else if (text.Contains("设备异常"))
// {
// ex_reissuecard_Item = new
// {
// SubTypeId = 6,
// SubType = "设备异常",
// title = text,
// datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
// textarea = textarea,
// apply_time_dt = apply_time_dt,
// approval_name = approval_name
// };
// }
// if (ex_reissuecard_Item != null)
// {
// ex_reissuecard_Items.Add(ex_reissuecard_Item);
// }
// }
// }
// }
//}
if (ex_reissuecard_Items.Count > 0)
{
ex_Items_dk.Ex_ItemInfo = ex_reissuecard_Items.OrderBy(it => it.SubTypeId).ThenBy(it => it.datehour).ToList();
ex_Items.Add(ex_Items_dk);
}
#endregion
#region 应发合计 实发合计 扣款合计(假勤扣款,其他扣款,社保扣款,公积金代扣,个税扣款)
decimal mealTotal = meal_subsidy - meal_deduction; //餐补
decimal salaryTotal = amountPayable + mealTotal; //应发合计
//扣款合计 不含个税
decimal eductionTotal = sickLeaveTotal + personalLeaveTotal + beLate_deduction + early_deduction + absenteeism_deduction + unprinted_deduction + other_deduction +
pm_wsInfo.WithholdingInsurance + pm_wsInfo.ReservedFunds;
decimal actualReleaseTotal = salaryTotal - eductionTotal; //实发合计 * 不含个税
#endregion
#region 处理当月工资数据
pm_wsInfo.YearMonth = thisYearMonth;
pm_wsInfo.StartDate = startDt.ToString("yyyy-MM-dd");
pm_wsInfo.EndDate = endDt.ToString("yyyy-MM-dd");
pm_wsInfo.SickLeave = sickLeaveTotal; //病假
pm_wsInfo.SomethingFalse = personalLeaveTotal; //事假
pm_wsInfo.LateTo = beLate_deduction; //迟到
pm_wsInfo.LeaveEarly = early_deduction; //早退
pm_wsInfo.Absenteeism = absenteeism_deduction; //旷工
pm_wsInfo.NotPunch = unprinted_deduction; //未打卡
pm_wsInfo.OtherDeductions = other_deduction; //其他
pm_wsInfo.Ex_ItemsRemark = JsonConvert.SerializeObject(ex_Items); //
pm_wsInfo.Mealsupplement = mealTotal; //餐补
pm_wsInfo.Should = salaryTotal; //应发合计
pm_wsInfo.TotalDeductions = eductionTotal; //扣款合计
pm_wsInfo.TotalRealHair = actualReleaseTotal; //实发合计
pm_wsInfo.AfterTax = actualReleaseTotal - pm_wsInfo.WithholdingTax; //税后工资
pm_wsInfo.LastUpdateUserId = userId;
pm_wsInfo.LastUpdateDt = DateTime.Now;
pm_wsInfo.CreateUserId = userId;
pm_wsInfo.CreateTime = DateTime.Now;
pm_wsInfo.DeleteUserId = null;
pm_wsInfo.DeleteTime = null;
#endregion
}
_result.Code = 0;
_result.Data = pm_WageSheetDattaSources;
return _result;
}
///
/// 打卡数据
/// 假勤数据 统计
///
/// 数据源
///
/// 1-请假;2-补卡;3-出差;4-外出;100-外勤;
///
///
/// 年假 事假 病假 调休假 婚嫁 产假 陪产假 丧假 补卡次数 出差 外出数 外勤 其他
///
///
private static int Fallibilitydispose(List datas, int type, string? subTypeName)
{
int num = 0;
Sp_Item _Info = datas.Where(it => it.type == type && it.name == subTypeName).FirstOrDefault();
if (_Info != null) { num = _Info.count; }
return num;
}
///
/// 打卡数据
/// 异常数据 统计
///
///
private static int ExceptionStatistics(List datas, int type)
{
int num = 0;
Exception_Info _Info = datas.Where(it => it.exception == type).FirstOrDefault();
if (_Info != null) { num = _Info.count; }
return num;
}
}
}