using Google.Protobuf.WellKnownTypes; 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 System; using System.Linq.Expressions; 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; //获取 请假类型 Sp_Detail.template_id string leave_template_id = "C4NzTJCh1onCUK915rRkvy7Fh5Vqz4YbiEV9jrBY1"; List vacationLeaveTypes = await GetVacationLeaveTypes(leave_template_id); if (vacationLeaveTypes.Count <= 0) { _result.Msg = 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 List sp_reissuecard_details = new List(); sp_reissuecard_details = await _qiYeWeChatApiService.GetApprovalDetailsAsync(startDt, endDt, acctid, 2, 2); //时间段内所有 已同意的 补卡 审批数据 if (sp_reissuecard_details.Count <= 0) { _result.Msg += startDt + " - " + endDt + " " + itemName + " 打卡补卡 审批数据获取未获取到!\r\n"; continue; } //当月总计数据 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_details = new List(); sp_leave_details = await _qiYeWeChatApiService.GetApprovalDetailsAsync(startDt, endDt, acctid, 2 , 1); //时间段内所有 已同意的 请假 审批数据 if (sp_leave_details.Count <= 0) { _result.Msg += startDt + " - " + endDt +" "+itemName + " 请假 审批数据获取未获取到!\r\n"; continue; } 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_details) { 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; //请假类型 List optionsItems = selector.options; //key 请假类型 id List value = optionsItems[0].value; // value 文本描述值 int leaveType = int.Parse(optionsItems[0].key); //key 请假子类型 id Date_range date_Range = attendance.date_range; decimal thisTypeDeduction = 0.00M;//当前类型扣款 string leave_starttime = date_Range.new_begin_dt.ToString("HH:mm"); string leave_endtime = date_Range.new_end_dt.ToString("HH:mm"); string typeName = string.Empty; int leaveTypeId = leaveType; var leaveTypeData = vacationLeaveTypes.Where(it => it.id == leaveTypeId).FirstOrDefault(); if (leaveTypeData != null) { typeName = leaveTypeData.name; } //计算请假类型扣款金额 int new_duration = 0; if (date_Range.type == "halfday") { new_duration =date_Range.new_duration / 86400; } else if (date_Range.type == "hour") { new_duration =date_Range.new_duration / 3600; } decimal leave_meals = 0.00M; CalculateTypeFee(leaveType, date_Range.type, leave_starttime, leave_endtime, amountPayable, work_days, new_duration, out leave_meals, out thisTypeDeduction); meal_deduction += leave_meals; string startEndTiime = startEndTiime = date_Range.new_begin_dt.ToString("yyyy-MM-dd HH:mm") + " - " + date_Range.new_end_dt.ToString("yyyy-MM-dd HH:mm"); Ex_Item ex_Item = new Ex_Item() { SubTypeId = leaveType, SubType = typeName, Start_end_time_dt = startEndTiime, Duration = new_duration, Deduction = thisTypeDeduction, //Reason = apply_data.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.Apply_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; } /// /// 获取请假类型 /// /// /// public static async Task> GetVacationLeaveTypes(string template_id) { List vacationLeaveTypes = new List(); TemplateDetailView templateDetailView = new TemplateDetailView(); templateDetailView = await _qiYeWeChatApiService.GetTemplateDetailAsync(template_id); if (templateDetailView.errcode != 0) { return vacationLeaveTypes; } List VacationItemInfos = templateDetailView.vacation_list.item; foreach (var item in VacationItemInfos) { ValueItem valueInfo = item.name.Where(it => it.lang == "zh_CN").FirstOrDefault(); if (valueInfo != null) { vacationLeaveTypes.Add( new VacationLeaveTypeView() { id = item.id, name = valueInfo.text }); } } return vacationLeaveTypes; } /// /// 计算类型费用 /// /// /// 1年假;2事假;3病假;4调休假;5婚假;6产假;7陪产假;8其他;9丧假 /// /// /// halfday 全天 /// hour 小时 /// /// /// /// /// /// public static void CalculateTypeFee(int leaveType, string date_Range_type, string startTime, string endTime,decimal amountPayable,int work_days, int duration, out decimal mealDeduction, out decimal typeDeduction) { typeDeduction = 0; mealDeduction = 0; string am_starttime = "08:59"; string am_endtime = "13:01"; decimal personalkLeave_dailywage_day = amountPayable / work_days; //日薪 = 事假日薪 *计算方式:日平均工资 = 当月应发工资 /当月应出勤天数。 //半小时单位 decimal halfHour = Convert.ToDecimal(7.5) / Convert.ToDecimal(0.5); switch (leaveType) { case 1: //年假 CalculateTypeFeeSub(date_Range_type, startTime, endTime, duration, out mealDeduction); break; case 2: //2事假 // 事假日薪 *计算方式:日平均工资 = 当月应发工资 /当月应出勤天数。 decimal personalkLeave_dailywage_halfhour = personalkLeave_dailywage_day / halfHour; //事假单位 0.5小时 if (date_Range_type == "halfday") { mealDeduction = 10; //餐补扣款 typeDeduction = personalkLeave_dailywage_day; } else if (date_Range_type == "hour") { int leave_halfHour = duration / Convert.ToInt32(0.5); typeDeduction = personalkLeave_dailywage_halfhour * leave_halfHour; if (duration >= 3) //单天请假三小时 && 请假时间在上午 则没有餐补 { //处理开始时间 if (startTime.CompareTo(am_starttime) > 0 && startTime.CompareTo(am_endtime) < 0) { //处理结束时间 if (endTime.CompareTo(am_starttime) > 0 && endTime.CompareTo(am_endtime) < 0) { mealDeduction = 10; //餐补扣款 } } } else if (duration > 7.5) //多天计算 { int leave_halfHour1 = duration / Convert.ToInt32(0.5); typeDeduction = personalkLeave_dailywage_halfhour * leave_halfHour1; decimal leaveDays = Convert.ToDecimal(duration / 7.5); if (leaveDays % 1 == 0) { mealDeduction = 10 * leaveDays; //餐补扣款 } else { mealDeduction = 10 * Convert.ToInt32(leaveDays); //得到最后一天的请假时间 是否有餐补 int lastHours = (Convert.ToDateTime(endTime) - Convert.ToDateTime("09:00")).Hours; if (lastHours >= 3) { //处理结束时间 if (endTime.CompareTo(am_starttime) > 0 && endTime.CompareTo(am_endtime) < 0) { mealDeduction += 10; //餐补扣款 } } } } } break; case 3: //3病假 // 病假日薪 *计算方式:日平均工资 = 成都市最低工资标准的80% /当月应出勤天数。 短期病假=当月15天内 decimal chengDuMinimumWage_halrHour = _chengDuMinimumWage / work_days / halfHour; decimal sickLeave_dailywage_halfhour_deduction = personalkLeave_dailywage_day - chengDuMinimumWage_halrHour; //病假单位 0.5小时 扣款金额 if (date_Range_type == "halfday") { mealDeduction = 10; //餐补扣款 typeDeduction = sickLeave_dailywage_halfhour_deduction * halfHour; } else if (date_Range_type == "hour") { int sickLeave_halfHour = duration / Convert.ToInt32(0.5); typeDeduction = sickLeave_dailywage_halfhour_deduction *sickLeave_halfHour ; if (duration >= 3 && duration <= 7.5) //单天请假三小时 && 请假时间在上午 则没有餐补 { //处理开始时间 if (startTime.CompareTo(am_starttime) > 0 && startTime.CompareTo(am_endtime) < 0) { //处理结束时间 if (endTime.CompareTo(am_starttime) > 0 && endTime.CompareTo(am_endtime) < 0) { mealDeduction = 10; //餐补扣款 } } } else if (duration > 7.5) //多天计算 { int sickLeave_halfHour1 = duration / Convert.ToInt32(0.5); typeDeduction = sickLeave_dailywage_halfhour_deduction * sickLeave_halfHour1; decimal leaveDays = Convert.ToDecimal(duration / 7.5); if (leaveDays % 1 == 0) { mealDeduction = 10 * leaveDays; //餐补扣款 } else { mealDeduction = 10 * Convert.ToInt32(leaveDays); //得到最后一天的请假时间 是否有餐补 int lastHours = (Convert.ToDateTime(endTime) - Convert.ToDateTime("09:00")).Hours; if (lastHours >= 3) { //处理结束时间 if (endTime.CompareTo(am_starttime) > 0 && endTime.CompareTo(am_endtime) < 0) { mealDeduction += 10; //餐补扣款 } } } } } break; case 4: //4调休假 CalculateTypeFeeSub(date_Range_type, startTime, endTime, duration, out mealDeduction); break; case 5: //5婚假 CalculateTypeFeeSub(date_Range_type, startTime, endTime, duration, out mealDeduction); break; case 6: //6产假 CalculateTypeFeeSub(date_Range_type, startTime, endTime, duration, out mealDeduction); break; case 7: //7陪产假 CalculateTypeFeeSub(date_Range_type, startTime, endTime, duration, out mealDeduction); break; case 8: //8其他 CalculateTypeFeeSub(date_Range_type, startTime, endTime, duration, out mealDeduction); break; case 9: //9丧假 CalculateTypeFeeSub(date_Range_type, startTime, endTime, duration, out mealDeduction); break; } } /// /// 计算类型费用 /// /// /// halfday 全天 /// hour 小时 /// /// /// /// /// public static void CalculateTypeFeeSub(string date_Range_type, string startTime, string endTime, int duration, out decimal mealDeduction) { mealDeduction = 0; string am_starttime = "08:59"; string am_endtime = "13:01"; if (date_Range_type == "halfday") { mealDeduction = 10; //餐补扣款 } else if (date_Range_type == "hour") { if (duration >= 3 && duration < 7) //单天请假三小时 && 请假时间在上午 则没有餐补 { //处理开始时间 if (startTime.CompareTo(am_starttime) > 0 && startTime.CompareTo(am_endtime) < 0) { //处理结束时间 if (endTime.CompareTo(am_starttime) > 0 && endTime.CompareTo(am_endtime) < 0) { mealDeduction = 10; //餐补扣款 } } } else if (duration >= 7 && duration <= 7.5 ) { mealDeduction = 10; //餐补扣款 } else if (duration >= 7.5) //多天计算 { decimal leaveDays = Convert.ToDecimal(duration / 7.5); if (leaveDays % 1 == 0) { mealDeduction = 10 * leaveDays; //餐补扣款 } else { mealDeduction = 10 * Convert.ToInt32(leaveDays); //得到最后一天的请假时间 是否有餐补 int lastHours = (Convert.ToDateTime(endTime) - Convert.ToDateTime("09:00")).Hours; if (lastHours >= 3) { //处理结束时间 if (endTime.CompareTo(am_starttime) > 0 && endTime.CompareTo(am_endtime) < 0) { mealDeduction += 10; //餐补扣款 } } } } } } /// /// 获取打卡补卡类型 /// /// /// public static async Task> GetVacationReissueCardTypes(string template_id) { List vacationLeaveTypes = new List(); TemplateDetailView templateDetailView = new TemplateDetailView(); templateDetailView = await _qiYeWeChatApiService.GetTemplateDetailAsync(template_id); if (templateDetailView.errcode != 0) { return vacationLeaveTypes; } List VacationItemInfos = templateDetailView.vacation_list.item; foreach (var item in VacationItemInfos) { ValueItem valueInfo = item.name.Where(it => it.lang == "zh_CN").FirstOrDefault(); if (valueInfo != null) { vacationLeaveTypes.Add( new VacationLeaveTypeView() { id = item.id, name = valueInfo.text }); } } return vacationLeaveTypes; } /// /// 打卡数据 /// 假勤数据 统计 /// /// 数据源 /// /// 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; } } }