using cylsg.Application.Orders.Dtos;
|
using cylsg.Application.Users.Dtos;
|
using cylsg.Core;
|
using cylsg.Model.OrderModel;
|
using cylsg.Model.UserModel;
|
using Furion.LinqBuilder;
|
using MapsterMapper;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Security.Claims;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace cylsg.Application.Orders
|
{
|
/// <summary>
|
/// 订单公司接口
|
/// </summary>
|
public class OrderCompanyAppService : IDynamicApiController
|
{
|
private readonly ISystemService _systemService;
|
private ISqlSugarClient _sqlSugarClient;
|
private IMapper _mapper;
|
public OrderCompanyAppService(ISystemService systemService, ISqlSugarClient sqlSugarClient, IMapper mapper)
|
{
|
_systemService = systemService;
|
_sqlSugarClient = sqlSugarClient;
|
_mapper = mapper;
|
}
|
|
|
/// <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
|
&& t.OrderUserId == userid);
|
|
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 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;
|
|
}
|
|
}
|
result.Items = datadto;
|
result.PageIndex = page.PageIndex;
|
result.PageSize = page.PageSize;
|
result.TotalCount = total;
|
|
return result;
|
}
|
|
|
/// <summary>
|
/// 保存招工信息（新增/修改）
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<bool> saveOrder(OrderDto orderDto)
|
{
|
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
string ITCode = App.User?.FindFirstValue("ITCode");
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
var userCompanyRes = new BaseRepository<UserCompany>();
|
var userCompany = await userCompanyRes.GetFirstAsync(p => p.UserId == userid && p.IsEn == true && p.IsDeleted == false);
|
if (userCompany == null || string.IsNullOrEmpty(userCompany.BusinessLicense))
|
{
|
throw Oops.Oh("请先完成公司认证才能发布招工！");
|
}
|
|
var orderRes = new BaseRepository<Order>();
|
bool res;
|
if (orderDto.Id > 0)
|
{
|
var order = await orderRes.GetByIdAsync(orderDto.Id);
|
if (order.OrderStatus > 0)
|
{
|
throw Oops.Oh("招工已经结束不能修改！");
|
}
|
order.OrderName = orderDto.OrderName;
|
order.WordStartTime = orderDto.WordStartTime;
|
order.WordEndTime = orderDto.WordEndTime;
|
order.Demand = orderDto.Demand;
|
order.WorderCount = orderDto.WorderCount;
|
order.WorderAddress = orderDto.WorderAddress;
|
order.ContactPhone = orderDto.ContactPhone;
|
order.WorkerType = orderDto.WorkerType;
|
order.WorkPrice = orderDto.WorkPrice;
|
|
|
order.UpDataBy = ITCode;
|
order.UpDataTime = DateTime.Now;
|
res = await orderRes.UpdateAsync(order);
|
|
|
}
|
else
|
{
|
var order = _mapper.Map<Order>(orderDto);
|
order.UpDataBy = ITCode;
|
order.UpDataTime = DateTime.Now;
|
order.CreateBy = ITCode;
|
order.CreateTime = DateTime.Now;
|
order.OrderStatus = 0;
|
order.OrderUserId = userid;
|
res = await orderRes.InsertAsync(order);
|
}
|
|
|
|
|
|
|
|
return res;
|
}
|
|
|
|
/// <summary>
|
/// 公司选择工人
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<bool> saveQueRen(QueRenDto queRenDto)
|
{
|
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
string ITCode = App.User?.FindFirstValue("ITCode");
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
var orderBiddingRes = new BaseRepository<OrderBidding>();
|
var orderRes = new BaseRepository<Order>();
|
|
var orderBidding = await orderBiddingRes.GetByIdAsync(queRenDto.OrderBiddingId);
|
if (orderBidding == null || orderBidding.IsEn != true || orderBidding.IsDeleted == true )
|
{
|
throw Oops.Oh("该投递已经无效！");
|
}
|
if(orderBidding.IsSelected == true)
|
{
|
throw Oops.Oh("该投递已经确认，不能重复确认！");
|
}
|
|
var order = await orderRes.GetByIdAsync(orderBidding.OrderId);
|
if (order == null || order.OrderStatus > 0)
|
{
|
throw Oops.Oh("该招工状态已经无法投递！");
|
}
|
|
var orderBiddings = await orderBiddingRes.CountAsync(x => x.OrderId == orderBidding.OrderId && x.IsSelected == true && x.IsDeleted == false && x.IsEn == true);
|
if (orderBiddings >= order.WorderCount)
|
{
|
throw Oops.Oh("招工人数已经满了，不能报名！");
|
}
|
|
|
|
bool res;
|
|
orderBidding.IsSelected = true;
|
orderBidding.Selectedtime = DateTime.Now;
|
orderBidding.UpDataBy = ITCode;
|
orderBidding.UpDataTime = DateTime.Now;
|
|
|
res = await orderBiddingRes.UpdateAsync(orderBidding);
|
|
if(order.WorderCount == (orderBiddings + 1))
|
{
|
order.OrderStatus = 1;
|
res = await orderRes.UpdateAsync(order);
|
}
|
|
return res;
|
}
|
|
|
|
|
/// <summary>
|
/// 查询公司下工人的打卡记录
|
/// </summary>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<PageResult<OrderDakaDto>> PostMyComDakaListPage(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 data = await orderRepository.Context.Queryable<Order, OrderBidding, OrderBiddingDetail>((a, b, c) =>
|
new JoinQueryInfos(JoinType.Inner, a.Id == b.OrderId,
|
JoinType.Inner, b.Id == c.OrderBiddingId
|
))
|
.Where((a, b, c) => a.IsEn == true && a.IsDeleted == false && b.IsEn == true && b.IsDeleted == false && c.IsEn == true && c.IsDeleted == false
|
&& b.IsSelected == true && a.OrderUserId == userid)
|
.WhereIF(page.WordDate.HasValue, (a, b, c) => (c.WorkDate == page.WordDate))
|
.WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == true, (a, b, c) => (c.IsShenPi == 2))
|
.WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == false, (a, b, c) => (c.IsShenPi < 2))
|
.OrderByDescending((a,b,c) => c.WorkDate)
|
.Select((a, b, c) => 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,
|
})
|
|
.ToPageListAsync(page.PageIndex, page.PageSize, total);
|
|
if (data != null && data.Count > 0)
|
{
|
foreach (var dakaDto in data)
|
{
|
int hours = 0;
|
int minutes = 0;
|
var orderBiddingDetailChecks = await orderBiddingDetailCheckRepository.GetListAsync(x => x.OrderBiddingDetailId == dakaDto.OrderBiddingDetailId && x.IsEn == true && x.IsDeleted == false);
|
string DakaMingxi = "";
|
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)
|
{
|
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;
|
|
return result;
|
}
|
|
|
|
|
|
/// <summary>
|
/// 公司确认工人当天打卡详情
|
/// </summary>
|
/// <returns></returns>
|
[Authorize]
|
[HttpPost]
|
public async Task<bool> saveDakaDetail(DakaQuerenDetailDto dakaDto)
|
{
|
|
var UserID = App.User?.FindFirstValue("UserID");
|
int userid = 0;
|
string ITCode = App.User?.FindFirstValue("ITCode");
|
if (!string.IsNullOrEmpty(UserID))
|
{
|
userid = int.Parse(UserID);
|
}
|
|
var orderBiddingRes = new BaseRepository<OrderBidding>();
|
var orderRes = new BaseRepository<Order>();
|
var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();
|
var userTiXianDetailRes = new BaseRepository<UserTiXianDetail>();
|
//var OrderBiddingDetailCheckRes = new BaseRepository<OrderBiddingDetailCheck>();
|
var userWorkerRes = new BaseRepository<UserWorker>();
|
var userCompanyRes = new BaseRepository<UserCompany>();
|
|
var orderBiddingDetail = await orderBiddingDetailRes.GetByIdAsync(dakaDto.OrderBiddingDetailId);
|
var orderBidding = await orderBiddingRes.GetByIdAsync(orderBiddingDetail.OrderBiddingId);
|
var order = await orderRes.GetByIdAsync(orderBidding.OrderId);
|
|
if (orderBidding == null || orderBidding.IsDeleted == true || orderBidding.IsEn == false || orderBidding.IsSelected != true)
|
{
|
throw Oops.Oh("该投递状态无法打卡确认！");
|
}
|
//if (order == null || order.OrderStatus > 1)
|
//{
|
// throw Oops.Oh("该招工状态已无法打卡确认！");
|
//}
|
var res = false;
|
try
|
{
|
var TodaySalary = orderBiddingDetail.TodaySalary.HasValue? orderBiddingDetail.TodaySalary.Value:0;
|
if(orderBiddingDetail.IsShenPi == (int)IsShenPis.yishenpi)
|
{
|
TodaySalary = dakaDto.TodaySalary.Value - TodaySalary;
|
}
|
else
|
{
|
TodaySalary = dakaDto.TodaySalary.Value;
|
}
|
orderRes.Context.Ado.BeginTran();
|
|
orderBiddingDetail.WorkTime = dakaDto.WorkTime;
|
orderBiddingDetail.WorkCount = dakaDto.WorkCount;
|
orderBiddingDetail.TodaySalary = dakaDto.TodaySalary;
|
orderBiddingDetail.IsShenPi = (int)IsShenPis.yishenpi;
|
orderBiddingDetail.ShenPitime = DateTime.Now;
|
orderBiddingDetail.UpDataBy = ITCode;
|
orderBiddingDetail.UpDataTime = DateTime.Now;
|
orderBiddingDetail.IsTiXian = true;
|
orderBiddingDetail.TiXiantime = DateTime.Now;
|
//orderBiddingDetail.CreateBy = ITCode;
|
//orderBiddingDetail.CreateTime = DateTime.Now;
|
res = await orderBiddingDetailRes.UpdateAsync(orderBiddingDetail);
|
if (!res)
|
{
|
orderRes.Context.Ado.RollbackTran();
|
throw Oops.Oh("结算失败！");
|
}
|
|
var userCompany = await userCompanyRes.GetFirstAsync(x => x.UserId == order.OrderUserId);
|
if(userCompany!=null && userCompany.IsTiXian == true)
|
{
|
//插入用户的结算金额
|
UserTiXianDetail userTiXianDetail = new UserTiXianDetail();
|
userTiXianDetail.UserId = orderBidding.WorkerUserId;
|
userTiXianDetail.YiTiXianJine = TodaySalary;
|
userTiXianDetail.ZhiChuShouRu = (int)ZhiChuShouRus.shouru;
|
userTiXianDetail.Remark = "招工订单" + order.OrderName + orderBiddingDetail.WorkDate.Value.ToString("yyyy-MM-dd") + "工资结算";
|
userTiXianDetail.UpDataBy = ITCode;
|
userTiXianDetail.UpDataTime = DateTime.Now;
|
userTiXianDetail.CreateBy = ITCode;
|
userTiXianDetail.CreateTime = DateTime.Now;
|
|
res = await userTiXianDetailRes.InsertAsync(userTiXianDetail);
|
if (!res)
|
{
|
orderRes.Context.Ado.RollbackTran();
|
throw Oops.Oh("结算失败！");
|
}
|
var userWorker = await userWorkerRes.GetFirstAsync(x => x.UserId == orderBidding.WorkerUserId);
|
if (userWorker != null)
|
{
|
var TiXianZonge = userWorker.TiXianZonge ?? 0;
|
|
userWorker.TiXianZonge = TiXianZonge + TodaySalary;
|
res = await userWorkerRes.UpdateAsync(userWorker);
|
if (!res)
|
{
|
orderRes.Context.Ado.RollbackTran();
|
throw Oops.Oh("结算失败！");
|
}
|
}
|
}
|
|
|
|
|
|
//判断订单是否可以修改为结算状态
|
|
if (order.WordEndTime <= DateTime.Now)
|
{
|
var sss = await orderBiddingRes.GetListAsync(x => x.OrderId == order.Id && x.IsEn == true && x.IsDeleted == false && x.IsSelected == true);
|
var bbb =sss.Select(x => x.Id).ToList();
|
var oCount = await orderBiddingDetailRes.CountAsync(x => bbb.Contains(x.OrderBiddingId) && x.IsEn == true && x.IsDeleted == false && x.IsShenPi != (int)IsShenPis.yishenpi);
|
if (oCount == 0)
|
{
|
order.OrderStatus = (int)OrderStatuses.jiesuanwanbi;
|
res = await orderRes.UpdateAsync(order);
|
if (!res)
|
{
|
orderRes.Context.Ado.RollbackTran();
|
throw Oops.Oh("结算失败！");
|
}
|
}
|
|
|
}
|
|
|
|
|
|
orderRes.Context.Ado.CommitTran();
|
}
|
catch (Exception ex )
|
{
|
orderRes.Context.Ado.RollbackTran();
|
throw Oops.Oh(ex.Message);
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
return res;
|
}
|
}
|
}
|
