// Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。
|
//
|
// 本项目主要遵循 MIT 许可证和 Apache 许可证（版本 2.0）进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。
|
//
|
// 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动！任何基于本项目二次开发而产生的一切法律纠纷和责任，我们不承担任何责任！
|
|
using Admin.NET.Application.Entity;
|
using Admin.NET.Application.Service.ReportCenter.WmsOtherReport.Dto;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using static SKIT.FlurlHttpClient.Wechat.Api.Models.SemanticSemproxySearchResponse.Types;
|
|
namespace Admin.NET.Application;
|
/// <summary>
|
/// 工作台服务
|
/// </summary>
|
[ApiDescriptionSettings(ApplicationConst.HomePageName, Order = 100)]
|
|
public class WmsHomePageService : IDynamicApiController, ITransient
|
{
|
private readonly SqlSugarRepository<WmsOrderMovement> _rep;
|
private readonly SqlSugarRepository<WmsStockQuan> _WmsStockQuanRep;
|
private readonly SqlSugarRepository<WmsOrderMovementDetails> _WmsOrderMovementDetailsRep;
|
private readonly SqlSugarRepository<V_WmsOrderMovementDetails> _v_wmsOrderMovementDetailsRep;
|
private readonly SqlSugarRepository<WmsBaseCustomer> _BaseCustomerRep;
|
private readonly SqlSugarRepository<WmsBaseMaterial> _wmsMaterialRep;
|
private readonly SqlSugarRepository<WmsConfigNoRule> _WmsNoCreateRuleRep;
|
private readonly SqlSugarRepository<WmsConfigSerialSN> _repSNRep;
|
private readonly SqlSugarRepository<WmsConfigSerialRule> _repRuleDetailRep;
|
private readonly SqlSugarRepository<WmsOrderDeliverDetails> _WmsOrderDeliverDetailsRep;
|
private readonly SqlSugarRepository<WmsLogAction> _wareActionLogRep;
|
private readonly WmsStockQuanService _wmsStockQuanService;
|
private readonly SqlSugarRepository<WmsBaseBusinessType> _WmsBaseBusinessTypeRep;
|
private readonly SqlSugarRepository<WmsBasePlace> _wmsPlaceRep;
|
private readonly SqlSugarRepository<WmsBaseContainer> _wmsContainerRep;
|
private readonly SqlSugarRepository<WmsContainerPlace> _wmsContainerPlace;
|
private readonly SqlSugarRepository<v_wms_stock_quan> _v_wms_stock_quanRep;
|
private readonly SqlSugarRepository<WmsOrderAsn> _wmsOrderAsnRep;
|
private readonly SqlSugarRepository<WmsRecordReceivingDelivery> _wmsRecordReceivingDeliveryRep;
|
|
public WmsHomePageService(
|
SqlSugarRepository<WmsRecordReceivingDelivery> wmsRecordReceivingDeliveryRep,
|
SqlSugarRepository<WmsOrderMovement> rep,
|
SqlSugarRepository<WmsStockQuan> wmsStockQuanRep,
|
SqlSugarRepository<WmsOrderMovementDetails> wmsOrderMovementDetailsRep,
|
SqlSugarRepository<WmsBaseCustomer> baseCustomerRep,
|
SqlSugarRepository<WmsBaseBusinessType> WmsBaseBusinessTypeRep,
|
SqlSugarRepository<WmsConfigNoRule> wmsNoCreateRuleRep,
|
SqlSugarRepository<WmsConfigSerialSN> repSNRep,
|
SqlSugarRepository<WmsConfigSerialRule> repRuleDetailRep,
|
SqlSugarRepository<WmsOrderDeliverDetails> WmsOrderDeliverDetailsRep
|
, SqlSugarRepository<WmsLogAction> wareActionLogRep
|
,
|
WmsStockQuanService wmsStockQuanService,
|
SqlSugarRepository<V_WmsOrderMovementDetails> v_wmsOrderMovementDetailsRep
|
,
|
SqlSugarRepository<WmsBaseMaterial> WmsMaterial,
|
SqlSugarRepository<WmsBaseBusinessType> WmsBaseBusinessType,
|
SqlSugarRepository<WmsBasePlace> wmsPlaceRep,
|
SqlSugarRepository<WmsBaseContainer> wmsContainerRep,
|
SqlSugarRepository<WmsContainerPlace> wmsContainerPlace,
|
SqlSugarRepository<v_wms_stock_quan> v_wms_stock_quanRep,
|
SqlSugarRepository<WmsOrderAsn> wmsOrderAsnRep
|
|
)
|
{
|
_wmsRecordReceivingDeliveryRep = wmsRecordReceivingDeliveryRep;
|
_rep = rep;
|
_WmsStockQuanRep = wmsStockQuanRep;
|
_WmsOrderMovementDetailsRep = wmsOrderMovementDetailsRep;
|
_BaseCustomerRep = baseCustomerRep;
|
_WmsBaseBusinessTypeRep = WmsBaseBusinessTypeRep;
|
_WmsNoCreateRuleRep = wmsNoCreateRuleRep;
|
_repSNRep = repSNRep;
|
_repRuleDetailRep = repRuleDetailRep;
|
_WmsOrderDeliverDetailsRep = WmsOrderDeliverDetailsRep;
|
_wareActionLogRep = wareActionLogRep;
|
_wmsStockQuanService = wmsStockQuanService;
|
_wmsMaterialRep = WmsMaterial;
|
_WmsBaseBusinessTypeRep = WmsBaseBusinessType;
|
_wmsPlaceRep = wmsPlaceRep;
|
_wmsContainerRep = wmsContainerRep;
|
_wmsContainerPlace = wmsContainerPlace;
|
_v_wms_stock_quanRep = v_wms_stock_quanRep;
|
_wmsOrderAsnRep = wmsOrderAsnRep;
|
}
|
|
/// <summary>
|
/// 首页出入库数据查询
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "WmsHomePageQuery")]
|
[Description("WmsHomePageService/WmsHomePageQuery")]
|
public async Task<WmsHomePageOutput> WmsHomePageQuery()
|
{
|
var returnData = new WmsHomePageOutput();
|
// 获取今天的日期
|
DateTime today = DateTime.Today;
|
var MovementOrderList = await _rep.AsQueryable().Where(u => u.CreateTime >= today && u.CreateTime < today.AddDays(1)).ToListAsync();
|
|
returnData.OuttingPlaceNumber = MovementOrderList.Where(u => u.OrderType == OrderTypeEnum.下架单 && u.OrderStatus == OrderStatusEnum.已完成).ToList().Count();
|
returnData.WarehousingNumber = MovementOrderList.Where(u => u.OrderType == OrderTypeEnum.上架单 && u.OrderStatus == OrderStatusEnum.已完成).ToList().Count();
|
returnData.AllOuttingNumber = MovementOrderList.Where(u => u.OrderType == OrderTypeEnum.下架单 && u.OrderStatus != OrderStatusEnum.已关闭 && u.OrderStatus != OrderStatusEnum.已取消).ToList().Count();
|
returnData.AllWarehousingNumber = MovementOrderList.Where(u => u.OrderType == OrderTypeEnum.上架单 && u.OrderStatus != OrderStatusEnum.已关闭 && u.OrderStatus != OrderStatusEnum.已取消).ToList().Count();
|
returnData.AllOrderNumber = returnData.AllOuttingNumber + returnData.AllWarehousingNumber;
|
return returnData;
|
}
|
/// <summary>
|
/// 首页库位数据查询
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "WmsHomePlaceQuery")]
|
[Description("WmsHomePageService/WmsHomePlaceQuery")]
|
public async Task<WmsHomePagePlaceInfoOutput> WmsHomePlaceQuery()
|
{
|
var returnData = new WmsHomePagePlaceInfoOutput();
|
var PlaceList = await _wmsPlaceRep.AsQueryable().Where(x => x.IsDelete == false && (x.IsVirtually == false || x.IsVirtually == null)).ToListAsync();
|
var StockQueryList = await _v_wms_stock_quanRep.AsQueryable().ToListAsync();
|
StockQueryList = StockQueryList.GroupBy(u => u.PlaceCode).Select(g => g.First()).ToList();//用库位号分组，去重
|
returnData.ContainerPlaceNumber = StockQueryList.Where(p => p.MaterialTypeCode == ApplicationConst.DefaultContinerMaterialCode).ToList().Count();
|
returnData.StockPlaceNumber = StockQueryList.Where(p => p.MaterialTypeCode != ApplicationConst.DefaultContinerMaterialCode).ToList().Count();
|
returnData.EmptyPlaceNumber = PlaceList.Count - returnData.ContainerPlaceNumber - returnData.StockPlaceNumber;
|
returnData.AllPlaceNumber = PlaceList.Count();
|
|
returnData.EmptyPlacePercentage = $"{Math.Round((returnData.EmptyPlaceNumber / returnData.AllPlaceNumber), 4):P}";
|
returnData.StockPlacePercentage = $"{Math.Round((returnData.StockPlaceNumber / returnData.AllPlaceNumber), 4):P}";
|
returnData.ContainerPlacePercentage = $"{Math.Round((returnData.ContainerPlaceNumber / returnData.AllPlaceNumber), 4):P}";
|
|
return returnData;
|
|
}
|
|
///// <summary>
|
///// 最近7天收发货推移图
|
///// </summary>
|
///// <returns></returns>
|
//[HttpPost]
|
//[ApiDescriptionSettings(Name = "WmsTransitionDiagramQuery")]
|
//[Description("WmsHomePageService/WmsTransitionDiagramQuery")]
|
//public async Task<List<WmsTransitionDiagram>> WmsTransitionDiagramQuery()
|
//{
|
// // 获取当前时间
|
// DateTime currentDate = DateTime.Now;
|
|
// //DateTime lastWeekDay = currentDate.AddDays(-(int)currentDate.DayOfWeek - 3).Date;
|
// //DateTime thisWeekDay = currentDate.AddDays(7 - (int)currentDate.DayOfWeek - 3).Date;
|
// // 计算七天前的日期
|
// DateTime lastWeekDay = currentDate.AddDays(-7).Date;
|
|
// // 当前日期的前一天作为结束日期
|
// DateTime thisWeekDay = currentDate.AddDays(+1).Date;
|
// var WmsTransitionDiagramList = new List<WmsTransitionDiagram>();
|
// var NewEmptyTransitionDiagramList = new List<WmsOrderAsn>();
|
// var query = await _wmsOrderAsnRep.AsQueryable().Where(u => u.CreateTime >= lastWeekDay && u.CreateTime <= thisWeekDay).ToListAsync();
|
// foreach (var item in query)
|
// {
|
// if (item.CreateTime == null) { NewEmptyTransitionDiagramList.Add(item); continue; }
|
// item.CreateTime = new DateTime(item.CreateTime?.Year ?? 1999, item.CreateTime?.Month ?? 1, item.CreateTime?.Day ?? 1);
|
// }
|
|
// query.RemoveAll(n => NewEmptyTransitionDiagramList.Select(x => x.Id).Contains(n.Id));
|
// // 使用 LINQ 的 GroupBy 方法，按照创建时间的日期分组
|
// var groupedData = query.GroupBy(u => u.CreateTime)
|
// .Select(group => new TransitionDiagramData
|
// {
|
// Date = (DateTime)group.Key,
|
// DataListCount = group.Count()
|
// }).ToList();
|
// if (groupedData.Count(p => p.Date >= currentDate.Date) == 0)
|
// {
|
// var todayInfo = new TransitionDiagramData()
|
// {
|
// Date = currentDate.Date,
|
// DataListCount = 0
|
// };
|
// groupedData.Add(todayInfo);
|
// }
|
|
// foreach (var item in groupedData)
|
// {
|
// var model = new WmsTransitionDiagram()
|
// {
|
// Day = item.Date.ToString("yyyy-MM-dd"),
|
// ReceiptNumber = item.DataListCount
|
// };
|
// WmsTransitionDiagramList.Add(model);
|
// }
|
// return WmsTransitionDiagramList;
|
//}
|
|
|
/// <summary>
|
/// 最近7天收发货推移图
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "WmsTransitionDiagramQuery")]
|
[Description("WmsHomePageService/WmsTransitionDiagramQuery")]
|
public async Task<List<WmsTransitionDiagram>> WmsTransitionDiagramQuery()
|
{
|
|
List<WmsTransitionDiagram> outputlist = new List<WmsTransitionDiagram>();
|
DateTime currentDate = DateTime.Today.AddDays(1);
|
DateTime firstDate = DateTime.Today.AddDays(-6);
|
// 查询在这一天内的出入库记录
|
var recordsOfDay = await _wmsRecordReceivingDeliveryRep.AsQueryable().Where(r => r.CreateTime >= firstDate && r.CreateTime <= currentDate).ToListAsync();
|
|
|
for (int i = 1; i < 8; i++)
|
{
|
DateTime startDate = currentDate.AddDays(-i);
|
DateTime endDate = startDate.Date.AddDays(1).AddTicks(-1);
|
|
// 查询在这一天内的出入库记录
|
var items = recordsOfDay.Where(r => r.CreateTime >= startDate && r.CreateTime <= endDate).ToList();
|
|
// 汇总出入库记录（这里假设你有合适的逻辑来汇总数据）
|
var summary = new WmsTransitionDiagram
|
{
|
ReceiptNumber = items.Where(x => x.InOutFlag == InOutFlagEnum.入).ToList().Sum(x => x.Quantity),
|
DeliveryNumber = items.Where(x => x.InOutFlag == InOutFlagEnum.出).ToList().Sum(x => x.Quantity),
|
Day = startDate.Date.ToString("yyyy-MM-dd")
|
};
|
|
outputlist.Add(summary);
|
}
|
|
|
//排序
|
outputlist = outputlist.OrderBy(x => x.Day).ToList();
|
|
return outputlist;
|
}
|
|
public class TransitionDiagramData
|
{
|
public DateTime Date { get; set; }
|
public decimal DataListCount { get; set; }
|
}
|
|
}
|
