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; 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_Infos = new List(); sp_Infos = await _qiYeWeChatApiService.GetApprovalDatasAsync(startDt, endDt); //时间段内所有 审批数据 if (sp_Infos.Count <= 0) { string errMsg = startDt + " - " + endDt + "审批数据获取失败!"; return _result; } // 筛选 时间段内(请假时间,补卡时间) /审批类型(打卡补卡,请假)/审核通过的数据 List sp_leave_InfosData = sp_Infos.Where(it => it.sp_status == 2 && it.spname == "请假" && it.leave.start_time_dt >= startDt && it.leave.start_time_dt <= endDt).ToList(); //请假 List sp_reissuecard_InfosData = sp_Infos.Where(it => it.sp_status == 2 && it.spname == "打卡补卡" && it.comm.FillingDt >= startDt && it.comm.FillingDt <= endDt).ToList(); //补卡 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_InfosData.Where(it => it.spname == "请假" && it.apply_name == itemName).ToList(); List ex_Items = new List();//假勤 And 打卡备注集合 Ex_Items ex_Items_jq = new Ex_Items() { Type = "假勤" }; //假勤 List ex_ItemInfos = new List(); foreach (Sp_Info sp_item in sp_leave_item_infosData) { Leave? sp_leave = sp_item.leave; if (sp_leave != null) { //请假时长 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_InfosData.Where(it => it.apply_name == itemName).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; } } }