using cylsg.Application.Orders.Dtos;
|
using cylsg.Application.Users.Dtos;
|
using cylsg.Core;
|
using cylsg.Model.OrderModel;
|
using cylsg.Model.UserModel;
|
using EzTencentCloud;
|
using Furion.LinqBuilder;
|
using MapsterMapper;
|
using Microsoft.IdentityModel.Tokens;
|
using Org.BouncyCastle.Asn1.X509;
|
using SqlSugar.Extensions;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Security.Claims;
|
using System.Text;
|
using System.Threading.Tasks;
|
using static SKIT.FlurlHttpClient.Wechat.Api.Models.ChannelsECOrderDeliverySendRequest.Types.Delivery.Types;
|
using static SKIT.FlurlHttpClient.Wechat.Api.Models.SemanticSemproxySearchResponse.Types;
|
|
namespace cylsg.Application.Orders
|
{
|
/// <summary>
|
/// 订单工人接口
|
/// </summary>
|
public class OrderWorkerAppService : IDynamicApiController
|
{
|
private readonly ISystemService _systemService;
|
private ISqlSugarClient _sqlSugarClient;
|
private IMapper _mapper;
|
private readonly ITencentCloudService _tencentCloudService;
|
public OrderWorkerAppService(ISystemService systemService, ISqlSugarClient sqlSugarClient, IMapper mapper,ITencentCloudService tencentCloudService)
|
{
|
_systemService = systemService;
|
_sqlSugarClient = sqlSugarClient;
|
_mapper = mapper;
|
_tencentCloudService = tencentCloudService;
|
}
|
|
|
/// <summary>
|
/// 查询工人可以投递的招工订单
|
/// </summary>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public async Task<PageResult<OrderDto>> PostListPage(OrderPageSearch page)
|
{
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
PageResult<OrderDto> result = new PageResult<OrderDto>();
|
|
Expression<Func<Order, bool>> expression = t => true;
|
|
expression = expression.And(t => t.IsDeleted == false && t.IsEn == true && t.OrderStatus == 0);
|
expression = expression.And(t => t.WordStartTime >= DateTime.Now.Date.AddDays(-30));
|
if (!string.IsNullOrEmpty(page.OrderName))
|
{
|
expression = expression.And(t => t.OrderName.Contains(page.OrderName));
|
}
|
if (page.WordStartTime.HasValue)
|
{
|
expression = expression.And(t => t.WordStartTime >= page.WordStartTime);
|
}
|
if (page.WordEndTime.HasValue)
|
{
|
expression = expression.And(t => t.WordStartTime <= page.WordEndTime);
|
}
|
|
RefAsync<int> total = 0;
|
var orderRepository = new BaseRepository<Order>();
|
|
var orderBiddingRepository = new BaseRepository<OrderBidding>();
|
var userCompanyRepository = new BaseRepository<UserCompany>();
|
|
var data = await orderRepository.Context.Queryable<Order>()
|
.Where(expression)
|
.OrderByDescending(c => c.WordStartTime)
|
.ToPageListAsync(page.PageIndex, page.PageSize, total);
|
var datadto = _mapper.Map<List<OrderDto>>(data);
|
|
if (datadto != null && datadto.Count > 0)
|
{
|
foreach (var orderDto in datadto)
|
{
|
var orderBiddings = await orderBiddingRepository.CountAsync(x => x.OrderId == orderDto.Id && x.IsSelected == true && x.IsEn == true && x.IsDeleted == false);
|
orderDto.WorderCounted = orderBiddings;
|
var userCompany = await userCompanyRepository.GetFirstAsync(x => x.UserId == orderDto.OrderUserId && x.IsDeleted == false && x.IsEn == true);
|
if (userCompany != null)
|
{
|
orderDto.OrderComName = userCompany.Suppliername;
|
}
|
if (userid > 0)
|
{
|
var orderBidding = await orderBiddingRepository.GetFirstAsync(x => x.OrderId == orderDto.Id && x.WorkerUserId == userid && x.IsEn == true && x.IsDeleted == false);
|
if (orderBidding != null)
|
{
|
if (!orderBidding.IsSelected.HasValue)
|
{
|
orderDto.IsSelectedName = "审核中";
|
}
|
else if (orderBidding.IsSelected.Value == true)
|
{
|
orderDto.IsSelectedName = "已录用";
|
}
|
else
|
{
|
orderDto.IsSelectedName = "未录用";
|
}
|
|
}
|
else
|
{
|
orderDto.IsSelectedName = null;
|
}
|
}
|
else
|
{
|
orderDto.IsSelectedName = null;
|
}
|
|
|
}
|
|
}
|
result.Items = datadto;
|
result.PageIndex = page.PageIndex;
|
result.PageSize = page.PageSize;
|
result.TotalCount = total;
|
|
return result;
|
}
|
|
|
|
/// <summary>
|
/// 查询工人已经投递的招工订单
|
/// </summary>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<PageResult<OrderDto>> PostMyListPage(OrderPageSearch page)
|
{
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
PageResult<OrderDto> result = new PageResult<OrderDto>();
|
var orderRepository = new BaseRepository<Order>();
|
Expression<Func<Order, bool>> expression = t => true;
|
|
expression = expression.And(t => t.IsDeleted == false && t.IsEn == true
|
&& SqlFunc.Subqueryable<OrderBidding>().Where(oi => oi.OrderId == t.Id && oi.IsDeleted == false && oi.IsEn == true && oi.WorkerUserId == userid).Any());
|
|
if (!string.IsNullOrEmpty(page.OrderName))
|
{
|
expression = expression.And(t => t.OrderName.Contains(page.OrderName));
|
}
|
if (page.WordStartTime.HasValue)
|
{
|
expression = expression.And(t => t.WordStartTime >= page.WordStartTime);
|
}
|
if (page.WordEndTime.HasValue)
|
{
|
expression = expression.And(t => t.WordStartTime <= page.WordEndTime);
|
}
|
|
RefAsync<int> total = 0;
|
|
|
var orderBiddingRepository = new BaseRepository<OrderBidding>();
|
var userCompanyRepository = new BaseRepository<UserCompany>();
|
|
var data = await orderRepository.Context.Queryable<Order>()
|
.Where(expression)
|
.OrderByDescending(c => c.WordStartTime)
|
.ToPageListAsync(page.PageIndex, page.PageSize, total);
|
var datadto = _mapper.Map<List<OrderDto>>(data);
|
|
if (datadto != null && datadto.Count > 0)
|
{
|
foreach (var orderDto in datadto)
|
{
|
switch (orderDto.OrderStatus)
|
{
|
case (int)OrderStatuses.fabu: orderDto.OrderStatusName = "发布"; break;
|
case (int)OrderStatuses.zhaogongwanbi: orderDto.OrderStatusName = "招工完毕"; break;
|
case (int)OrderStatuses.jiesuanwanbi: orderDto.OrderStatusName = "结算完毕"; break;
|
default: break;
|
}
|
|
var orderBiddings = await orderBiddingRepository.CountAsync(x => x.OrderId == orderDto.Id && x.IsSelected == true && x.IsEn == true && x.IsDeleted == false);
|
orderDto.WorderCounted = orderBiddings;
|
|
|
var orderBidding = await orderBiddingRepository.GetFirstAsync(x => x.OrderId == orderDto.Id && x.WorkerUserId == userid && x.IsEn == true && x.IsDeleted == false);
|
if (orderBidding != null)
|
{
|
orderDto.IsSelected = orderBidding.IsSelected;
|
if (!orderDto.IsSelected.HasValue )
|
{
|
orderDto.IsSelectedName = "审核中";
|
}
|
else if(orderDto.IsSelected.Value)
|
{
|
orderDto.IsSelectedName = "已确认";
|
}
|
else
|
{
|
orderDto.IsSelectedName = "不录用";
|
}
|
}
|
var userCompany = await userCompanyRepository.GetFirstAsync(x => x.UserId == orderDto.OrderUserId && x.IsDeleted == false && x.IsEn == true);
|
if (userCompany != null)
|
{
|
orderDto.OrderComName = userCompany.Suppliername;
|
}
|
}
|
|
}
|
result.Items = datadto;
|
result.PageIndex = page.PageIndex;
|
result.PageSize = page.PageSize;
|
result.TotalCount = total;
|
|
return result;
|
}
|
|
|
|
|
|
|
|
/// <summary>
|
/// 根据Id查询招工明细
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
public async Task<OrderDto> getOrder(int orderid)
|
{
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
OrderDto orderDto = new OrderDto();
|
var orderRes = new BaseRepository<Order>();
|
var orderBiddingRes = new BaseRepository<OrderBidding>();
|
var userWorkerRes = new BaseRepository<UserWorker>();
|
var orderBiddingWorkPriceRepository = new BaseRepository<OrderBiddingWorkPrice>();
|
var userRes = new BaseRepository<User>();
|
var order = await orderRes.GetByIdAsync(orderid);
|
orderDto = _mapper.Map<OrderDto>(order);
|
switch (orderDto.OrderStatus)
|
{
|
case (int)OrderStatuses.fabu: orderDto.OrderStatusName = "发布"; break;
|
case (int)OrderStatuses.zhaogongwanbi: orderDto.OrderStatusName = "招工完毕"; break;
|
case (int)OrderStatuses.jiesuanwanbi: orderDto.OrderStatusName = "结算完毕"; break;
|
default: break;
|
}
|
var orderBiddings = await orderBiddingRes.GetListAsync(x => x.OrderId == orderDto.Id && x.IsEn == true && x.IsDeleted == false && (x.IsSelected ==null || x.IsSelected !=false) );
|
var IsSelected = orderBiddings.Count(x => x.IsSelected == true);
|
orderDto.WorderCounted = IsSelected;
|
|
var orderBidding = orderBiddings.Where(x => x.WorkerUserId == userid).FirstOrDefault();
|
if (orderBidding != null)
|
{
|
var dangqianshijian = DateTime.Now.Date;
|
//当前有效的工价
|
var orderBiddingWorkPrices = await orderBiddingWorkPriceRepository.GetListAsync(x => x.OrderBiddingId == orderBidding.Id && x.IsEn == true && x.IsDeleted == false );
|
|
orderBiddingWorkPrices = orderBiddingWorkPrices.OrderByDescending(x => x.Id).ToList();
|
orderDto.orderBiddingWorkPrices = orderBiddingWorkPrices;
|
var orderBiddingWorkPrice = orderBiddingWorkPrices.Where(x => x.EffectTime <= DateTime.Now.Date).FirstOrDefault();
|
if (orderBiddingWorkPrice != null)
|
{
|
orderDto.WorkPriceDangqian = orderBiddingWorkPrice.WorkPrice;
|
}
|
else
|
{
|
orderDto.WorkPriceDangqian = orderDto.WorkPrice;
|
}
|
|
|
orderDto.IsSelected = orderBidding.IsSelected;
|
if (!orderDto.IsSelected.HasValue)
|
{
|
orderDto.IsSelectedName = "审核中";
|
}
|
else if (orderDto.IsSelected.Value)
|
{
|
orderDto.IsSelectedName = "已确认";
|
}
|
else
|
{
|
orderDto.IsSelectedName = "不录用";
|
}
|
}
|
|
|
var orderBiddingDtos = _mapper.Map<List<OrderBiddingDto>>(orderBiddings);
|
if(orderBiddingDtos != null&& orderBiddingDtos.Count > 0)
|
{
|
foreach (var orderBiddingDto in orderBiddingDtos)
|
{
|
if (!orderBiddingDto.IsSelected.HasValue)
|
{
|
orderBiddingDto.IsSelectedName = "审核中";
|
}
|
else if (orderBiddingDto.IsSelected.Value)
|
{
|
orderBiddingDto.IsSelectedName = "已确认";
|
}
|
else
|
{
|
orderBiddingDto.IsSelectedName = "不录用";
|
}
|
|
|
var user = await userRes.GetByIdAsync(orderBiddingDto.WorkerUserId);
|
|
if (user != null)
|
{
|
orderBiddingDto.WorkerAvatar = user.Avatar;
|
}
|
var userWorker = await userWorkerRes.GetFirstAsync(x => x.UserId == orderBiddingDto.WorkerUserId && x.IsEn == true && x.IsDeleted == false);
|
if (userWorker != null)
|
{
|
orderBiddingDto.WorkerName = userWorker.name;
|
}
|
|
//当前有效的工价
|
var orderBiddingWorkPrices = await orderBiddingWorkPriceRepository.GetListAsync(x => x.OrderBiddingId == orderBiddingDto.Id && x.IsEn == true && x.IsDeleted == false);
|
orderBiddingWorkPrices = orderBiddingWorkPrices.OrderByDescending(x => x.Id).ToList();
|
orderBiddingDto.orderBiddingWorkPrices = orderBiddingWorkPrices;
|
var orderBiddingWorkPrice = orderBiddingWorkPrices.Where(x => x.EffectTime <= DateTime.Now.Date).FirstOrDefault();
|
if (orderBiddingWorkPrice != null)
|
{
|
|
orderBiddingDto.WorkPrice = orderBiddingWorkPrice.WorkPrice;
|
}
|
else
|
{
|
orderBiddingDto.WorkPrice = orderDto.WorkPrice;
|
}
|
|
|
|
}
|
}
|
|
|
orderDto.orderBidding = orderBiddingDtos;
|
|
return orderDto;
|
}
|
|
|
|
|
|
/// <summary>
|
/// 工人投递
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<bool> saveBaoMing(BaoMingDto baoMingDto)
|
{
|
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
string NickName = App.User?.FindFirstValue("NickName");
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
var orderBiddingRes = new BaseRepository<OrderBidding>();
|
var orderRes = new BaseRepository<Order>();
|
var userWorkerRes = new BaseRepository<UserWorker>();
|
var userWorker = await userWorkerRes.GetFirstAsync(p=>p.UserId == userid && p.IsEn == true && p.IsDeleted == false);
|
if (userWorker == null || string.IsNullOrEmpty(userWorker.IdCode))
|
{
|
throw Oops.Oh("请先完成工人实名认证才能投递！");
|
}
|
|
var order = await orderRes.GetByIdAsync(baoMingDto.OrderId);
|
if (order == null || order.OrderStatus>0 || order.IsEn !=true )
|
{
|
throw Oops.Oh("该招工状态已经无法投递！");
|
}
|
if (order.OrderUserId == userid)
|
{
|
throw Oops.Oh("自己无法投递自己发布的招工！");
|
}
|
|
bool res;
|
|
var orderBidding = await orderBiddingRes.GetFirstAsync(x => x.OrderId == baoMingDto.OrderId && x.WorkerUserId == userid && x.IsDeleted == false && x.IsEn == true);
|
if (orderBidding != null)
|
{
|
throw Oops.Oh("已经投递过了！");
|
}
|
else
|
{
|
|
|
var orderBiddings = await orderBiddingRes.CountAsync(x => x.OrderId == baoMingDto.OrderId && x.IsSelected == true && x.IsDeleted == false && x.IsEn == true);
|
if(orderBiddings>= order.WorderCount)
|
{
|
throw Oops.Oh("招工人数已经满了，不能报名！");
|
}
|
|
|
OrderBidding orderBidding1 = new OrderBidding();
|
orderBidding1.WorkerUserId = userid;
|
orderBidding1.OrderId = baoMingDto.OrderId;
|
orderBidding1.IsSelected = null;
|
orderBidding1.UpDataBy = NickName;
|
orderBidding1.UpDataTime = DateTime.Now;
|
orderBidding1.CreateBy = NickName;
|
orderBidding1.CreateTime = DateTime.Now;
|
|
res = await orderBiddingRes.InsertAsync(orderBidding1);
|
|
}
|
|
return res;
|
}
|
|
/// <summary>
|
/// 进入打卡页面
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<OrderBiddingDetailDto> getDaka(BaoMingDto baoMingDto)
|
{
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
string NickName = App.User?.FindFirstValue("NickName");
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
OrderBiddingDetailDto orderBiddingDetailDto = null;
|
|
|
var orderBiddingRes = new BaseRepository<OrderBidding>();
|
var orderRes = new BaseRepository<Order>();
|
var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();
|
var OrderBiddingDetailCheckRes = new BaseRepository<OrderBiddingDetailCheck>();
|
var userWorkerRes = new BaseRepository<UserWorker>();
|
var order = await orderRes.GetByIdAsync(baoMingDto.OrderId);
|
if (order == null || order.OrderStatus > 1)
|
{
|
throw Oops.Oh("该招工状态已经无法打卡！");
|
}
|
var orderBidding = await orderBiddingRes.GetFirstAsync(x => x.OrderId == baoMingDto.OrderId && x.WorkerUserId == userid && x.IsDeleted == false && x.IsEn == true);
|
if (orderBidding == null || orderBidding.IsSelected != true)
|
{
|
throw Oops.Oh("没有确认的投递！");
|
}
|
var dateTime = DateTime.Now.Date;
|
var orderBiddingDetail = await orderBiddingDetailRes.GetFirstAsync(x => x.OrderBiddingId == orderBidding.Id && x.WorkDate == dateTime && x.IsDeleted == false && x.IsEn == true);
|
if (orderBiddingDetail != null )
|
{
|
if(orderBiddingDetail.IsShenPi>0)
|
{
|
throw Oops.Oh("当天的打卡已经提交，不能打卡！");
|
}
|
orderBiddingDetailDto = _mapper.Map<OrderBiddingDetailDto>(orderBiddingDetail);
|
orderBiddingDetailDto.WorkerUserId = orderBidding.WorkerUserId;
|
var worker = await userWorkerRes.GetFirstAsync(x => x.UserId == orderBidding.WorkerUserId);
|
if(worker != null)
|
orderBiddingDetailDto.WorkerName = worker.name;
|
|
var orderBiddingDetailChecks = await OrderBiddingDetailCheckRes.GetListAsync(x => x.OrderBiddingDetailId == orderBiddingDetail.Id && x.IsDeleted == false && x.IsEn == true);
|
orderBiddingDetailDto.orderBiddingDetailCheck = _mapper.Map<List<OrderBiddingDetailCheckDto>>(orderBiddingDetailChecks);
|
}
|
|
return orderBiddingDetailDto;
|
}
|
|
/// <summary>
|
/// 工人打卡
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<bool> saveDaka(DakaDto dakaDto)
|
{
|
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
string NickName = App.User?.FindFirstValue("NickName");
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
var orderBiddingRes = new BaseRepository<OrderBidding>();
|
var orderRes = new BaseRepository<Order>();
|
var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();
|
var OrderBiddingDetailCheckRes = new BaseRepository<OrderBiddingDetailCheck>();
|
|
var order = await orderRes.GetByIdAsync(dakaDto.OrderId);
|
if (order == null || order.OrderStatus > 1)
|
{
|
throw Oops.Oh("该招工状态已无法打卡！");
|
}
|
|
var orderBidding = await orderBiddingRes.GetFirstAsync(x => x.OrderId == dakaDto.OrderId && x.WorkerUserId == userid && x.IsSelected == true && x.IsEn == true && x.IsDeleted == false );//GetByIdAsync(dakaDto.OrderBiddingId);
|
if (orderBidding == null || orderBidding.IsDeleted ==true || orderBidding.IsEn == false || orderBidding.IsSelected !=true )
|
{
|
throw Oops.Oh("该投递状态无法打卡！");
|
}
|
|
|
bool res;
|
var dateTime = DateTime.Now.Date;
|
if ( dateTime < order.WordStartTime.Value && dateTime > order.WordEndTime.Value )
|
{
|
throw Oops.Oh("不在允许打卡的时间范围！");
|
}
|
var orderBiddingDetail = await orderBiddingDetailRes.GetFirstAsync(x => x.OrderBiddingId == orderBidding.Id && x.WorkDate == dateTime && x.IsDeleted == false && x.IsEn == true);
|
if (orderBiddingDetail!=null && orderBiddingDetail.IsShenPi>0)
|
{
|
throw Oops.Oh("该打卡记录已经审批，不能打卡！");
|
}
|
//人脸识别
|
if (App.Configuration["VerifyFace:Enable"].ObjToBool())
|
{
|
if (string.IsNullOrWhiteSpace(dakaDto.FaceImg))
|
{
|
throw Oops.Oh("未识别人脸");
|
}
|
|
var UserWorkRes = await new BaseRepository<UserWorker>().GetFirstAsync(x => x.UserId == userid);
|
if (UserWorkRes == null)
|
{
|
throw Oops.Oh("员工未注册成工人");
|
}
|
var faseres = _tencentCloudService.VerifyFace(dakaDto.FaceImg, UserWorkRes.IdCode);
|
|
if (faseres.IsMatch != true)
|
{
|
throw Oops.Oh("不是本人");
|
}
|
}
|
|
|
|
|
if(orderBiddingDetail == null)
|
{
|
orderBiddingDetail = new OrderBiddingDetail();
|
orderBiddingDetail.OrderBiddingId = orderBidding.Id;
|
orderBiddingDetail.WorkDate = dateTime;
|
orderBiddingDetail.IsShenPi = 0;
|
orderBiddingDetail.IsTiXian = false;
|
orderBiddingDetail.UpDataBy = NickName;
|
orderBiddingDetail.UpDataTime = DateTime.Now;
|
orderBiddingDetail.CreateBy = NickName;
|
orderBiddingDetail.CreateTime = DateTime.Now;
|
orderBiddingDetail.Id = await orderBiddingDetailRes.InsertReturnIdentityAsync(orderBiddingDetail);
|
}
|
//插入打卡记录
|
var orderBiddingDetailCheck = new OrderBiddingDetailCheck();
|
orderBiddingDetailCheck.OrderBiddingDetailId = orderBiddingDetail.Id;
|
orderBiddingDetailCheck.CheckPhoto = dakaDto.CheckPhoto;
|
orderBiddingDetailCheck.Checktime = DateTime.Now;
|
orderBiddingDetailCheck.UpDataBy = NickName;
|
orderBiddingDetailCheck.UpDataTime = DateTime.Now;
|
orderBiddingDetailCheck.CreateBy = NickName;
|
orderBiddingDetailCheck.CreateTime = DateTime.Now;
|
res = await OrderBiddingDetailCheckRes.InsertAsync(orderBiddingDetailCheck);
|
|
|
|
return res;
|
}
|
|
|
|
|
|
|
/// <summary>
|
/// 查询工人的打卡记录
|
/// </summary>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<PageResult<OrderDakaDto>> PostMyDakaListPage(OrderDakaPageSearch page)
|
{
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
PageResult<OrderDakaDto> result = new PageResult<OrderDakaDto>();
|
var orderRepository = new BaseRepository<Order>();
|
|
RefAsync<int> total = 0;
|
|
|
var orderBiddingDetailCheckRepository = new BaseRepository<OrderBiddingDetailCheck>();
|
var orderBiddingWorkPriceRepository = new BaseRepository<OrderBiddingWorkPrice>();
|
var data = await orderRepository.Context.Queryable<Order, OrderBidding, OrderBiddingDetail ,UserCompany>((a, b ,c ,d) =>
|
new JoinQueryInfos(JoinType.Inner, a.Id == b.OrderId ,
|
JoinType.Inner, b.Id == c.OrderBiddingId ,
|
JoinType.Inner, a.OrderUserId == d.UserId
|
))
|
.Where((a, b, c, d) => a.IsEn == true && a.IsDeleted == false && b.IsEn == true && b.IsDeleted == false && c.IsEn == true && c.IsDeleted == false
|
&& b.IsSelected == true && b.WorkerUserId == userid && d.IsEn == true && d.IsDeleted == false )
|
.WhereIF(page.WordDate.HasValue, (a, b, c, d) => (c.WorkDate == page.WordDate))
|
.WhereIF(page.WordDateStart.HasValue, (a, b, c, d) => (c.WorkDate >= page.WordDateStart))
|
.WhereIF(page.WordDateEnd.HasValue, (a, b, c, d) => (c.WorkDate <= page.WordDateEnd))
|
.WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == true, (a, b, c, d) => (c.IsShenPi == 2))
|
.WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == false, (a, b, c, d) => (c.IsShenPi < 2))
|
.WhereIF(!string.IsNullOrEmpty(page.Suppliername), (a, b, c, d) =>d.Suppliername.Contains(page.Suppliername))
|
.OrderByDescending((a, b, c, d) => c.WorkDate)
|
.Select((a, b, c, d) => new OrderDakaDto
|
{
|
OrderBiddingDetailId = c.Id,
|
OrderName = a.OrderName,
|
WorkDate = c.WorkDate,
|
WorkTime = c.WorkTime,
|
WorkerType = a.WorkerType,
|
WorkPrice = a.WorkPrice,
|
TodaySalary = c.TodaySalary,
|
IsShenPi = c.IsShenPi,
|
WorkCount = c.WorkCount,
|
Suppliername = d.Suppliername,
|
OrderBiddingId = c.OrderBiddingId,
|
})
|
|
.ToPageListAsync(page.PageIndex, page.PageSize, total);
|
|
|
|
|
var heji = orderRepository.Context.Queryable<Order, OrderBidding, OrderBiddingDetail, UserCompany>((a, b, c, d) =>
|
new JoinQueryInfos(JoinType.Inner, a.Id == b.OrderId,
|
JoinType.Inner, b.Id == c.OrderBiddingId,
|
JoinType.Inner, a.OrderUserId == d.UserId
|
))
|
.Where((a, b, c, d) => a.IsEn == true && a.IsDeleted == false && b.IsEn == true && b.IsDeleted == false && c.IsEn == true && c.IsDeleted == false
|
&& b.IsSelected == true && b.WorkerUserId == userid && d.IsEn == true && d.IsDeleted == false)
|
.WhereIF(page.WordDate.HasValue, (a, b, c, d) => (c.WorkDate == page.WordDate))
|
.WhereIF(page.WordDateStart.HasValue, (a, b, c, d) => (c.WorkDate >= page.WordDateStart))
|
.WhereIF(page.WordDateEnd.HasValue, (a, b, c, d) => (c.WorkDate <= page.WordDateEnd))
|
.WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == true, (a, b, c, d) => (c.IsShenPi == 2))
|
.WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == false, (a, b, c, d) => (c.IsShenPi < 2))
|
.WhereIF(!string.IsNullOrEmpty(page.Suppliername), (a, b, c, d) => d.Suppliername.Contains(page.Suppliername))
|
.Sum((a, b, c, d) => c.TodaySalary);
|
|
if (data != null && data.Count > 0)
|
{
|
foreach (var dakaDto in data)
|
{
|
var orderBiddingDetailChecks = await orderBiddingDetailCheckRepository.GetListAsync(x => x.OrderBiddingDetailId == dakaDto.OrderBiddingDetailId && x.IsEn == true && x.IsDeleted == false);
|
string DakaMingxi = "";
|
int hours = 0;
|
int minutes = 0;
|
for (int i = 0; i < orderBiddingDetailChecks.Count; i++)
|
{
|
|
if (i != orderBiddingDetailChecks.Count - 1)
|
{
|
DakaMingxi += orderBiddingDetailChecks[i].Checktime.Value.ToString("HH:mm") + "-";
|
}
|
else
|
{
|
DakaMingxi += orderBiddingDetailChecks[i].Checktime.Value.ToString("HH:mm");
|
}
|
|
if (i == 1 || i == 3 || i == 5 || i == 7 || i == 9 || i == 11 || i == 13 || i == 15 || i == 17 || i == 19 )
|
{
|
var timeDifference = orderBiddingDetailChecks[i].Checktime.Value - orderBiddingDetailChecks[i - 1].Checktime.Value;
|
hours += timeDifference.Hours;
|
minutes += timeDifference.Minutes;
|
|
}
|
}
|
//如果当天还没有填写申请，则计算工作时间和工资
|
if(dakaDto.IsShenPi == 0)
|
{
|
//当前有效的工价
|
var orderBiddingWorkPrice = (await orderBiddingWorkPriceRepository.GetListAsync(x => x.OrderBiddingId == dakaDto.OrderBiddingId && x.IsEn == true && x.IsDeleted == false && x.EffectTime <= dakaDto.WorkDate)).OrderByDescending(x => x.Id).FirstOrDefault();
|
if (orderBiddingWorkPrice != null)
|
{
|
dakaDto.WorkPrice = orderBiddingWorkPrice.WorkPrice;
|
}
|
dakaDto.WorkTime = hours+(minutes/60);
|
if(dakaDto.WorkerType == 0)
|
{
|
dakaDto.TodaySalary = dakaDto.WorkTime * dakaDto.WorkPrice;
|
}
|
else
|
{
|
var WorkCount = dakaDto.WorkCount ?? 0;
|
dakaDto.TodaySalary = WorkCount * dakaDto.WorkPrice;
|
}
|
|
}
|
|
switch (dakaDto.IsShenPi)
|
{
|
case (int)IsShenPis.baocun: dakaDto.IsShenPiName = "未结算"; break;
|
case (int)IsShenPis.tijiao: dakaDto.IsShenPiName = "未结算"; break;
|
case (int)IsShenPis.yishenpi: dakaDto.IsShenPiName = "已结算"; break;
|
default: break;
|
}
|
|
switch (dakaDto.WorkerType)
|
{
|
case (int)WorkerTypes.time: dakaDto.WorkerTypeName = "计时"; break;
|
case (int)WorkerTypes.count: dakaDto.WorkerTypeName = "计件"; break;
|
default: break;
|
}
|
|
|
|
|
|
dakaDto.DakaMingxi = DakaMingxi;
|
|
}
|
|
}
|
result.Items = data;
|
result.PageIndex = page.PageIndex;
|
result.PageSize = page.PageSize;
|
result.TotalCount = total;
|
result.Heji = heji ?? 0;
|
return result;
|
}
|
|
|
|
|
|
|
/// <summary>
|
/// 进入填写/审批工价页面
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<OrderDakaMingxiDto> getDakaDetail(DakaDetailDto dakaDetailDto)
|
{
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
string NickName = App.User?.FindFirstValue("NickName");
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
OrderDakaMingxiDto orderDakaMingxiDto = new OrderDakaMingxiDto(); ;
|
|
|
var orderBiddingRes = new BaseRepository<OrderBidding>();
|
var orderRes = new BaseRepository<Order>();
|
var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();
|
var OrderBiddingDetailCheckRes = new BaseRepository<OrderBiddingDetailCheck>();
|
var orderBiddingWorkPriceRepository = new BaseRepository<OrderBiddingWorkPrice>();
|
var userRes = new BaseRepository<User>();
|
var userWorkerRes = new BaseRepository<UserWorker>();
|
|
var orderBiddingDetail = await orderBiddingDetailRes.GetByIdAsync(dakaDetailDto.OrderBiddingDetailId);
|
var orderBidding = await orderBiddingRes.GetByIdAsync(orderBiddingDetail.OrderBiddingId);
|
var order = await orderRes.GetByIdAsync(orderBidding.OrderId);
|
|
var orderBiddingDetailChecks = await OrderBiddingDetailCheckRes.GetListAsync(x => x.OrderBiddingDetailId == orderBiddingDetail.Id && x.IsEn == true && x.IsDeleted == false);
|
orderDakaMingxiDto.orderBiddingDetailCheck = _mapper.Map<List<OrderBiddingDetailCheckDto>>(orderBiddingDetailChecks);
|
|
orderDakaMingxiDto.OrderBiddingDetailId = orderBiddingDetail.Id;
|
orderDakaMingxiDto.OrderName = order.OrderName;
|
orderDakaMingxiDto.WorkDate = orderBiddingDetail.WorkDate;
|
orderDakaMingxiDto.WorkTime = orderBiddingDetail.WorkTime;
|
orderDakaMingxiDto.WorkerType = order.WorkerType;
|
orderDakaMingxiDto.WorkPrice = order.WorkPrice;
|
orderDakaMingxiDto.TodaySalary = orderBiddingDetail.TodaySalary;
|
orderDakaMingxiDto.IsShenPi = orderBiddingDetail.IsShenPi;
|
orderDakaMingxiDto.WorkCount = orderBiddingDetail.WorkCount;
|
orderDakaMingxiDto.WorkerUserId = orderBidding.WorkerUserId;
|
var user = await userRes.GetByIdAsync(orderDakaMingxiDto.WorkerUserId);
|
if (user != null)
|
{
|
orderDakaMingxiDto.WorkerUserAvatar = user.Avatar;
|
}
|
var userWorker = await userWorkerRes.GetFirstAsync(x => x.UserId == orderDakaMingxiDto.WorkerUserId && x.IsEn == true && x.IsDeleted == false);
|
if (userWorker != null)
|
{
|
orderDakaMingxiDto.WorkerUserName = userWorker.name;
|
}
|
|
|
switch (orderDakaMingxiDto.IsShenPi)
|
{
|
case (int)IsShenPis.baocun: orderDakaMingxiDto.IsShenPiName = "未结算"; break;
|
case (int)IsShenPis.tijiao: orderDakaMingxiDto.IsShenPiName = "未结算"; break;
|
case (int)IsShenPis.yishenpi: orderDakaMingxiDto.IsShenPiName = "已结算"; break;
|
default: break;
|
}
|
|
switch (orderDakaMingxiDto.WorkerType)
|
{
|
case (int)WorkerTypes.time: orderDakaMingxiDto.WorkerTypeName = "计时"; break;
|
case (int)WorkerTypes.count: orderDakaMingxiDto.WorkerTypeName = "计件"; break;
|
default: break;
|
}
|
|
if (orderDakaMingxiDto.IsShenPi == 0)
|
{
|
int hours = 0;
|
int minutes = 0;
|
|
for (int i = 0; i < orderBiddingDetailChecks.Count; i++)
|
{
|
|
if (i == 1 || i == 3 || i == 5 || i == 7 || i == 9 || i == 11 || i == 13 || i == 15 || i == 17 || i == 19)
|
{
|
var timeDifference = orderBiddingDetailChecks[i].Checktime.Value - orderBiddingDetailChecks[i - 1].Checktime.Value;
|
hours += timeDifference.Hours;
|
minutes += timeDifference.Minutes;
|
|
}
|
}
|
//当前有效的工价
|
var orderBiddingWorkPrice = (await orderBiddingWorkPriceRepository.GetListAsync(x => x.OrderBiddingId == orderBidding.Id && x.IsEn == true && x.IsDeleted == false && x.EffectTime <= orderDakaMingxiDto.WorkDate)).OrderByDescending(x => x.Id).FirstOrDefault();
|
if (orderBiddingWorkPrice != null)
|
{
|
orderDakaMingxiDto.WorkPrice = orderBiddingWorkPrice.WorkPrice;
|
}
|
orderDakaMingxiDto.WorkTime = hours + (minutes / 60);
|
if (orderDakaMingxiDto.WorkerType == 0)
|
{
|
orderDakaMingxiDto.TodaySalary = orderDakaMingxiDto.WorkTime * orderDakaMingxiDto.WorkPrice;
|
}
|
else
|
{
|
var WorkCount = orderDakaMingxiDto.WorkCount ?? 0;
|
orderDakaMingxiDto.TodaySalary = WorkCount * orderDakaMingxiDto.WorkPrice;
|
}
|
}
|
|
|
|
|
return orderDakaMingxiDto;
|
}
|
|
|
|
/// <summary>
|
/// 工人确认当天打卡详情
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<bool> saveDakaDetail(DakaQuerenDetailDto dakaDto)
|
{
|
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
string NickName = App.User?.FindFirstValue("NickName");
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
var orderBiddingRes = new BaseRepository<OrderBidding>();
|
var orderRes = new BaseRepository<Order>();
|
var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();
|
//var OrderBiddingDetailCheckRes = new BaseRepository<OrderBiddingDetailCheck>();
|
|
var orderBiddingDetail = await orderBiddingDetailRes.GetByIdAsync(dakaDto.OrderBiddingDetailId);
|
if (orderBiddingDetail == null || orderBiddingDetail.IsShenPi > 1 || orderBiddingDetail.IsDeleted == true || orderBiddingDetail.IsEn == false)
|
{
|
throw Oops.Oh("该打卡状态已无法打卡确认！");
|
}
|
var orderBidding = await orderBiddingRes.GetByIdAsync(orderBiddingDetail.OrderBiddingId);
|
if (orderBidding == null || orderBidding.IsDeleted == true || orderBidding.IsEn == false || orderBidding.IsSelected != true)
|
{
|
throw Oops.Oh("该投递状态无法打卡确认！");
|
}
|
var order = await orderRes.GetByIdAsync(orderBidding.OrderId);
|
|
|
if (order == null || order.OrderStatus > 1 || order.IsDeleted == true || order.IsEn == false )
|
{
|
throw Oops.Oh("该招工状态已无法打卡确认！");
|
}
|
|
|
|
orderBiddingDetail.WorkTime = dakaDto.WorkTime;
|
orderBiddingDetail.WorkCount = dakaDto.WorkCount;
|
if(order.WorkerType == (int)WorkerTypes.count)
|
{
|
orderBiddingDetail.TodaySalary = dakaDto.WorkCount * order.WorkPrice;
|
}
|
else
|
{
|
orderBiddingDetail.TodaySalary = dakaDto.TodaySalary;
|
}
|
|
orderBiddingDetail.IsShenPi = (int)IsShenPis.tijiao;
|
orderBiddingDetail.UpDataBy = NickName;
|
orderBiddingDetail.UpDataTime = DateTime.Now;
|
//orderBiddingDetail.CreateBy = NickName;
|
//orderBiddingDetail.CreateTime = DateTime.Now;
|
var res = await orderBiddingDetailRes.UpdateAsync(orderBiddingDetail);
|
|
|
|
|
return res;
|
}
|
|
|
|
|
/// <summary>
|
/// 查询工人的收入记录
|
/// </summary>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<PageResult<UserTiXianDetailDto>> PostMyTiXianDetailListPage(PageBaseSearch page)
|
{
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
PageResult<UserTiXianDetailDto> result = new PageResult<UserTiXianDetailDto>();
|
|
RefAsync<int> total = 0;
|
|
|
var userTiXianDetailRepository = new BaseRepository<UserTiXianDetail>();
|
|
var data = await userTiXianDetailRepository.Context.Queryable<UserTiXianDetail>()
|
.Where(a => a.IsEn == true && a.IsDeleted == false && a.UserId == userid)
|
.OrderByDescending(a => a.CreateTime)
|
.Select(a => new UserTiXianDetailDto
|
{
|
Id = a.Id,
|
UserId = a.UserId,
|
YiTiXianJine = a.YiTiXianJine,
|
ZhiChuShouRu = a.ZhiChuShouRu,
|
Remark = a.Remark,
|
|
|
})
|
|
.ToPageListAsync(page.PageIndex, page.PageSize, total);
|
|
if (data != null && data.Count > 0)
|
{
|
foreach (var userTiXianDetailDto in data)
|
{
|
|
switch (userTiXianDetailDto.ZhiChuShouRu)
|
{
|
case (int)ZhiChuShouRus.zhichu: userTiXianDetailDto.ZhiChuShouRuName = "支出"; break;
|
case (int)ZhiChuShouRus.shouru: userTiXianDetailDto.ZhiChuShouRuName = "收入"; break;
|
default: break;
|
}
|
|
|
|
|
|
|
|
|
}
|
|
}
|
result.Items = data;
|
result.PageIndex = page.PageIndex;
|
result.PageSize = page.PageSize;
|
result.TotalCount = total;
|
|
return result;
|
}
|
|
|
|
}
|
}
|
