From 9d50a35b4b1d1ed6c210c0b199fe45ad7cb2a56f Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 26 九月 2024 11:23:19 +0800
Subject: [PATCH] 下架招工
---
cylsg/cylsg.Application/Orders/OrderWorkerAppService.cs | 231 ++++++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 187 insertions(+), 44 deletions(-)
diff --git a/cylsg/cylsg.Application/Orders/OrderWorkerAppService.cs b/cylsg/cylsg.Application/Orders/OrderWorkerAppService.cs
index d8731ba..ab236aa 100644
--- a/cylsg/cylsg.Application/Orders/OrderWorkerAppService.cs
+++ b/cylsg/cylsg.Application/Orders/OrderWorkerAppService.cs
@@ -6,6 +6,7 @@
using EzTencentCloud;
using Furion.LinqBuilder;
using MapsterMapper;
+using Microsoft.IdentityModel.Tokens;
using Org.BouncyCastle.Asn1.X509;
using SqlSugar.Extensions;
using System;
@@ -51,6 +52,7 @@
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));
@@ -68,6 +70,7 @@
var orderRepository = new BaseRepository<Order>();
var orderBiddingRepository = new BaseRepository<OrderBidding>();
+ var userCompanyRepository = new BaseRepository<UserCompany>();
var data = await orderRepository.Context.Queryable<Order>()
.Where(expression)
@@ -81,6 +84,11 @@
{
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;
+ }
}
}
@@ -134,6 +142,7 @@
var orderBiddingRepository = new BaseRepository<OrderBidding>();
+ var userCompanyRepository = new BaseRepository<UserCompany>();
var data = await orderRepository.Context.Queryable<Order>()
.Where(expression)
@@ -170,6 +179,11 @@
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;
+ }
}
}
@@ -204,6 +218,7 @@
OrderDto orderDto = new OrderDto();
var orderRes = new BaseRepository<Order>();
var orderBiddingRes = new BaseRepository<OrderBidding>();
+ var userWorkerRes = new BaseRepository<UserWorker>();
var userRes = new BaseRepository<User>();
var order = await orderRes.GetByIdAsync(orderid);
orderDto = _mapper.Map<OrderDto>(order);
@@ -248,10 +263,15 @@
}
var user = await userRes.GetByIdAsync(orderBiddingDto.WorkerUserId);
+
if (user != null)
{
- orderBiddingDto.WorkerName = user.name;
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;
}
}
@@ -278,7 +298,7 @@
var UserID = App.User?.FindFirstValue("UserID");
int userid = 0;
- string ITCode = App.User?.FindFirstValue("ITCode");
+ string NickName = App.User?.FindFirstValue("NickName");
if (!string.IsNullOrEmpty(UserID))
{
userid = int.Parse(UserID);
@@ -297,6 +317,10 @@
if (order == null || order.OrderStatus>0)
{
throw Oops.Oh("璇ユ嫑宸ョ姸鎬佸凡缁忔棤娉曟姇閫掞紒");
+ }
+ if (order.OrderUserId == userid)
+ {
+ throw Oops.Oh("鑷繁鏃犳硶鎶曢�掕嚜宸卞彂甯冪殑鎷涘伐锛�");
}
bool res;
@@ -321,9 +345,9 @@
orderBidding1.WorkerUserId = userid;
orderBidding1.OrderId = baoMingDto.OrderId;
orderBidding1.IsSelected = false;
- orderBidding1.UpDataBy = ITCode;
+ orderBidding1.UpDataBy = NickName;
orderBidding1.UpDataTime = DateTime.Now;
- orderBidding1.CreateBy = ITCode;
+ orderBidding1.CreateBy = NickName;
orderBidding1.CreateTime = DateTime.Now;
res = await orderBiddingRes.InsertAsync(orderBidding1);
@@ -343,7 +367,7 @@
{
var UserID = App.User?.FindFirstValue("UserID");
int userid = 0;
- string ITCode = App.User?.FindFirstValue("ITCode");
+ string NickName = App.User?.FindFirstValue("NickName");
if (!string.IsNullOrEmpty(UserID))
{
userid = int.Parse(UserID);
@@ -355,6 +379,7 @@
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)
{
@@ -374,6 +399,11 @@
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);
}
@@ -392,7 +422,7 @@
var UserID = App.User?.FindFirstValue("UserID");
int userid = 0;
- string ITCode = App.User?.FindFirstValue("ITCode");
+ string NickName = App.User?.FindFirstValue("NickName");
if (!string.IsNullOrEmpty(UserID))
{
userid = int.Parse(UserID);
@@ -403,19 +433,25 @@
var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();
var OrderBiddingDetailCheckRes = new BaseRepository<OrderBiddingDetailCheck>();
- var orderBidding = await orderBiddingRes.GetByIdAsync(dakaDto.OrderBiddingId);
+ 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("璇ユ姇閫掔姸鎬佹棤娉曟墦鍗★紒");
}
- var order = await orderRes.GetByIdAsync(orderBidding.OrderId);
- if (order == null || order.OrderStatus > 1)
- {
- 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)
{
@@ -434,7 +470,7 @@
{
throw Oops.Oh("鍛樺伐鏈敞鍐屾垚宸ヤ汉");
}
- var faseres = _tencentCloudService.VerifyFace(dakaDto.FaceImg, UserWorkRes.IAIPersonId);
+ var faseres = _tencentCloudService.VerifyFace(dakaDto.FaceImg, UserWorkRes.IdCode);
if (faseres.IsMatch != true)
{
@@ -452,9 +488,9 @@
orderBiddingDetail.WorkDate = dateTime;
orderBiddingDetail.IsShenPi = 0;
orderBiddingDetail.IsTiXian = false;
- orderBiddingDetail.UpDataBy = ITCode;
+ orderBiddingDetail.UpDataBy = NickName;
orderBiddingDetail.UpDataTime = DateTime.Now;
- orderBiddingDetail.CreateBy = ITCode;
+ orderBiddingDetail.CreateBy = NickName;
orderBiddingDetail.CreateTime = DateTime.Now;
orderBiddingDetail.Id = await orderBiddingDetailRes.InsertReturnIdentityAsync(orderBiddingDetail);
}
@@ -463,9 +499,9 @@
orderBiddingDetailCheck.OrderBiddingDetailId = orderBiddingDetail.Id;
orderBiddingDetailCheck.CheckPhoto = dakaDto.CheckPhoto;
orderBiddingDetailCheck.Checktime = DateTime.Now;
- orderBiddingDetailCheck.UpDataBy = ITCode;
+ orderBiddingDetailCheck.UpDataBy = NickName;
orderBiddingDetailCheck.UpDataTime = DateTime.Now;
- orderBiddingDetailCheck.CreateBy = ITCode;
+ orderBiddingDetailCheck.CreateBy = NickName;
orderBiddingDetailCheck.CreateTime = DateTime.Now;
res = await OrderBiddingDetailCheckRes.InsertAsync(orderBiddingDetailCheck);
@@ -503,17 +539,21 @@
var orderBiddingDetailCheckRepository = new BaseRepository<OrderBiddingDetailCheck>();
- var data = await orderRepository.Context.Queryable<Order, OrderBidding, OrderBiddingDetail>((a, b ,c) =>
+ 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, b.Id == c.OrderBiddingId ,
+ JoinType.Inner, a.OrderUserId == d.UserId
))
- .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 && b.WorkerUserId == 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
+ .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,
@@ -524,10 +564,28 @@
TodaySalary = c.TodaySalary,
IsShenPi = c.IsShenPi,
WorkCount = c.WorkCount,
-
+ Suppliername = d.Suppliername,
})
.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)
{
@@ -601,7 +659,7 @@
result.PageIndex = page.PageIndex;
result.PageSize = page.PageSize;
result.TotalCount = total;
-
+ result.Heji = heji ?? 0;
return result;
}
@@ -620,7 +678,7 @@
{
var UserID = App.User?.FindFirstValue("UserID");
int userid = 0;
- string ITCode = App.User?.FindFirstValue("ITCode");
+ string NickName = App.User?.FindFirstValue("NickName");
if (!string.IsNullOrEmpty(UserID))
{
userid = int.Parse(UserID);
@@ -633,7 +691,7 @@
var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();
var OrderBiddingDetailCheckRes = new BaseRepository<OrderBiddingDetailCheck>();
var userRes = new BaseRepository<User>();
-
+ var userWorkerRes = new BaseRepository<UserWorker>();
var orderBiddingDetail = await orderBiddingDetailRes.GetByIdAsync(dakaDetailDto.OrderBiddingDetailId);
var orderBidding = await orderBiddingRes.GetByIdAsync(orderBiddingDetail.OrderBiddingId);
@@ -655,10 +713,13 @@
var user = await userRes.GetByIdAsync(orderDakaMingxiDto.WorkerUserId);
if (user != null)
{
- orderDakaMingxiDto.WorkerUserName = user.name;
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)
@@ -724,7 +785,7 @@
var UserID = App.User?.FindFirstValue("UserID");
int userid = 0;
- string ITCode = App.User?.FindFirstValue("ITCode");
+ string NickName = App.User?.FindFirstValue("NickName");
if (!string.IsNullOrEmpty(UserID))
{
userid = int.Parse(UserID);
@@ -736,30 +797,40 @@
//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);
- 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)
+ var order = await orderRes.GetByIdAsync(orderBidding.OrderId);
+
+
+ if (order == null || order.OrderStatus > 1 || order.IsDeleted == true || order.IsEn == false )
{
throw Oops.Oh("璇ユ嫑宸ョ姸鎬佸凡鏃犳硶鎵撳崱纭锛�");
}
- if (orderBiddingDetail == null || orderBiddingDetail.IsShenPi > 1)
- {
- throw Oops.Oh("璇ユ墦鍗＄姸鎬佸凡鏃犳硶鎵撳崱纭锛�");
- }
+
orderBiddingDetail.WorkTime = dakaDto.WorkTime;
orderBiddingDetail.WorkCount = dakaDto.WorkCount;
- orderBiddingDetail.TodaySalary = dakaDto.TodaySalary;
- orderBiddingDetail.IsShenPi = 1;
- orderBiddingDetail.UpDataBy = ITCode;
+ 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 = ITCode;
+ //orderBiddingDetail.CreateBy = NickName;
//orderBiddingDetail.CreateTime = DateTime.Now;
var res = await orderBiddingDetailRes.UpdateAsync(orderBiddingDetail);
@@ -771,5 +842,77 @@
+
+ /// <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;
+ }
+
+
+
}
}
--
Gitblit v1.9.1