123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823 |
- 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
- {
- /// <summary>
- /// 工资计算
- /// </summary>
- public static class PayrollComputation
- {
- private static Result _result = new Result();
- private static readonly IQiYeWeChatApiService _qiYeWeChatApiService = AutofacIocManager.Instance.GetService<IQiYeWeChatApiService>();
- private static readonly UsersRepository _usersRep = AutofacIocManager.Instance.GetService<UsersRepository>();
- private static readonly IMapper _mapper = AutofacIocManager.Instance.GetService<IMapper>();
- private static readonly decimal _chengDuMinimumWage = 2100.00M;
- /// <summary>
- /// 计算工资
- /// </summary>
- /// <param name="pm_WageSheetDattaSources"></param>
- /// <param name="userNames"></param>
- /// <param name="thisYearMonth"></param>
- /// <param name="startDt"></param>
- /// <param name="endDt"></param>
- /// <returns></returns>
- public static async Task<Result> SalaryCalculatorAsync(
- List<Pm_WageSheet> pm_WageSheetDattaSources, List<UserNameView> 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<Data> checkInDatas = checkIn.datas;
- //获取 请假类型 Sp_Detail.template_id
- string leave_template_id = "C4NzTJCh1onCUK915rRkvy7Fh5Vqz4YbiEV9jrBY1";
- List<VacationLeaveTypeView> 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_Detail> sp_reissuecard_details = new List<Sp_Detail>();
- 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_Item>? 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_Detail> sp_leave_details = new List<Sp_Detail>();
- 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> ex_Items = new List<Ex_Items>();//假勤 And 打卡备注集合
- Ex_Items ex_Items_jq = new Ex_Items() { Type = "假勤" }; //假勤
- List<Ex_Item> ex_ItemInfos = new List<Ex_Item>();
- foreach (Sp_Detail sp_item in sp_leave_details)
- {
- Apply_data? apply_data = sp_item.apply_data;
- if (apply_data != null)
- {
- List<ContentsItem> 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<OptionsItem> optionsItems = selector.options; //key 请假类型 id
- List<TitleItem> 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_Item> ex_reissuecard_Items = new List<Ex_Item>();
- List<dynamic> ex_reissuecard_Items = new List<dynamic>();
- List<Sp_Detail> 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<Exception_Info>? 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<string>? approval_name = sp_reissuecard_item.approval_name; //审核人
- // Comm sp_comm = sp_reissuecard_item.comm;
- // if (sp_comm != null)
- // {
- // if (sp_comm.applydata != null)
- // {
- // List<ApplyInfo> 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;
- }
- /// <summary>
- /// 获取请假类型
- /// </summary>
- /// <param name="template_id"></param>
- /// <returns></returns>
- public static async Task<List<VacationLeaveTypeView>> GetVacationLeaveTypes(string template_id)
- {
- List<VacationLeaveTypeView> vacationLeaveTypes = new List<VacationLeaveTypeView>();
- TemplateDetailView templateDetailView = new TemplateDetailView();
- templateDetailView = await _qiYeWeChatApiService.GetTemplateDetailAsync(template_id);
- if (templateDetailView.errcode != 0)
- {
- return vacationLeaveTypes;
- }
- List<VacationItemInfo> 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;
- }
- /// <summary>
- /// 计算类型费用
- /// </summary>
- /// <param name="leaveType">
- /// 1年假;2事假;3病假;4调休假;5婚假;6产假;7陪产假;8其他;9丧假
- /// </param>
- /// <param name="date_Range_type">
- /// halfday 全天
- /// hour 小时
- /// </param>
- /// <param name="startTime"></param>
- /// <param name="endTime"></param>
- /// <param name="duration"></param>
- /// <param name="mealDeduction"></param>
- /// <param name="typeDeduction"></param>
- 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;
- }
- }
- /// <summary>
- /// 计算类型费用
- /// </summary>
- /// <param name="date_Range_type">
- /// halfday 全天
- /// hour 小时
- /// </param>
- /// <param name="startTime"></param>
- /// <param name="endTime"></param>
- /// <param name="duration"></param>
- /// <param name="mealDeduction"></param>
- 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; //餐补扣款
- }
- }
- }
- }
- }
- }
- /// <summary>
- /// 获取打卡补卡类型
- /// </summary>
- /// <param name="template_id"></param>
- /// <returns></returns>
- public static async Task<List<VacationLeaveTypeView>> GetVacationReissueCardTypes(string template_id)
- {
- List<VacationLeaveTypeView> vacationLeaveTypes = new List<VacationLeaveTypeView>();
- TemplateDetailView templateDetailView = new TemplateDetailView();
- templateDetailView = await _qiYeWeChatApiService.GetTemplateDetailAsync(template_id);
- if (templateDetailView.errcode != 0)
- {
- return vacationLeaveTypes;
- }
- List<VacationItemInfo> 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;
- }
- /// <summary>
- /// 打卡数据
- /// 假勤数据 统计
- /// </summary>
- /// <param name="datas">数据源</param>
- /// <param name="type">
- /// 1-请假;2-补卡;3-出差;4-外出;100-外勤;
- /// </param>
- /// <param name="subTypeName">
- /// 年假 事假 病假 调休假 婚嫁 产假 陪产假 丧假 补卡次数 出差 外出数 外勤 其他
- /// </param>
- /// <returns></returns>
- private static int Fallibilitydispose(List<Sp_Item> 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;
- }
- /// <summary>
- /// 打卡数据
- /// 异常数据 统计
- /// </summary>
- /// <returns></returns>
- private static int ExceptionStatistics(List<Exception_Info> datas, int type)
- {
- int num = 0;
- Exception_Info _Info = datas.Where(it => it.exception == type).FirstOrDefault();
- if (_Info != null) { num = _Info.count; }
- return num;
- }
- }
- }
|