private DateTime GetDate(Himall.Entity.Entities entity, DateTime checkDate)
{
var firstFinishedOrder = entity.PendingSettlementOrdersInfo.OrderBy(c => c.OrderFinshTime).FirstOrDefault();
if (firstFinishedOrder != null)
{
checkDate = firstFinishedOrder.OrderFinshTime;
}
else
{
checkDate = DateTime.MinValue;
}
return(checkDate);
}
/// <summary>
/// 取上一次统计时间
/// </summary>
/// <returns></returns>
DateTime GetStatisticDate()
{
DateTime startDate = DateTime.Now.Date;
try
{
Himall.Entity.Entities entity = new Himall.Entity.Entities();
var lastRecord = entity.ShopVistiInfo.Where(item => item.StatisticFlag == false).FirstOrDefault();
// Log.Error("测试统计ttttt");
if (lastRecord != null)
{
startDate = lastRecord.Date;
}
else
{
//是否第一次统计
var visitInfo = entity.ShopVistiInfo.FirstOrDefault();
if (visitInfo == null)
{//取第一个订单时间
var firstOrder = entity.OrderInfo.FirstOrDefault();
if (firstOrder != null)
{
startDate = firstOrder.OrderDate.Date;
}
else
{
startDate = DateTime.Now.Date;
}
}
else
{
startDate = visitInfo.Date;
}
}
}
catch (Exception ex)
{
Log.Debug("交易统计异常：" + ex.Message + ":::" + ex.StackTrace);
}
return(startDate);
}
void StatisticCreateOrder(DateTime statisticStartDate, DateTime statisticEndDate)
{
Himall.Entity.Entities entity = new Himall.Entity.Entities();
//时间段内所有订单（下单数据统计）
var orders = entity.OrderInfo.Where(e => e.OrderDate >= statisticStartDate && e.OrderDate < statisticEndDate).ToList();
var orderGroups = orders.GroupBy(e => e.ShopId);
//已存在的店铺统计
var shopids = orderGroups.Select(e => e.Key).Distinct();
var shopVisitInfos = entity.ShopVistiInfo.Where(e => shopids.Contains(e.ShopId) && e.Date == statisticStartDate).ToList();
List <ShopVistiInfo> shopVisitRange = new List <ShopVistiInfo>();
foreach (var g in orderGroups)
{
ShopVistiInfo shopVisit = shopVisitInfos.FirstOrDefault(e => e.ShopId == g.Key);
if (shopVisit == null)
{
shopVisit = new ShopVistiInfo();
shopVisitRange.Add(shopVisit);
}
shopVisit.Date = statisticStartDate;
shopVisit.ShopId = g.Key;
shopVisit.OrderCount = g.Count();
shopVisit.OrderAmount = g.Sum(e => e.TotalAmount);
shopVisit.OrderUserCount = g.Select(e => e.UserId).Distinct().Count();
shopVisit.OrderProductCount = g.Sum(e => e.OrderProductQuantity);
shopVisit.StatisticFlag = true;
}
//将没有订单记录的统计信息，统一修改为已统计
var noOrdersStatistic = shopVisitInfos.Where(e => !shopids.Any(p => p == e.ShopId));
foreach (var v in noOrdersStatistic)
{
v.StatisticFlag = true;
}
entity.ShopVistiInfo.AddRange(shopVisitRange);
entity.SaveChanges();
//时间段内已支付订单(付款数据统计)
var payOrders = entity.OrderInfo.Where(e => e.PayDate.HasValue && e.PayDate.Value >= statisticStartDate && e.PayDate.Value < statisticEndDate).ToList();
var payOrderGroups = payOrders.GroupBy(e => e.ShopId);
//已存在的店铺统计
shopids = payOrderGroups.Select(e => e.Key).Distinct();
shopVisitInfos = entity.ShopVistiInfo.Where(e => shopids.Contains(e.ShopId) && e.Date == statisticStartDate).ToList();
shopVisitRange = new List <ShopVistiInfo>();
foreach (var g in payOrderGroups)
{
ShopVistiInfo shopVisit = shopVisitInfos.FirstOrDefault(e => e.ShopId == g.Key);
if (shopVisit == null)
{
shopVisit = new ShopVistiInfo();
shopVisitRange.Add(shopVisit);
}
shopVisit.Date = statisticStartDate;
shopVisit.ShopId = g.Key;
shopVisit.OrderPayCount = g.Count();
shopVisit.OrderPayUserCount = g.Select(e => e.UserId).Distinct().Count();
shopVisit.SaleAmounts = g.Sum(e => e.TotalAmount);
shopVisit.SaleCounts = g.Sum(e => e.OrderProductQuantity);
shopVisit.StatisticFlag = true;
}
//将没有订单记录的统计信息，统一修改为已统计
var noPayOrdersStatistic = shopVisitInfos.Where(e => !shopids.Any(p => p == e.ShopId));
foreach (var v in noPayOrdersStatistic)
{
v.StatisticFlag = true;
}
entity.ShopVistiInfo.AddRange(shopVisitRange);
//平台统计
PlatVisitsInfo platVisit = entity.PlatVisitsInfo.FirstOrDefault(e => e.Date == statisticStartDate);
if (platVisit == null)
{
platVisit = new PlatVisitsInfo();
//添加
entity.PlatVisitsInfo.Add(platVisit);
}
platVisit.Date = statisticStartDate;
platVisit.OrderCount = orders.Count();
platVisit.OrderAmount = orders.Sum(e => e.TotalAmount);
platVisit.OrderUserCount = orders.Select(e => e.UserId).Distinct().Count();
platVisit.OrderProductCount = orders.Sum(e => e.OrderProductQuantity);
//已支付订单
platVisit.OrderPayCount = payOrders.Count();
platVisit.OrderPayUserCount = payOrders.Select(e => e.UserId).Distinct().Count();
platVisit.SaleAmounts = payOrders.Sum(e => e.TotalAmount);
platVisit.SaleCounts = payOrders.Sum(e => e.OrderProductQuantity);
platVisit.StatisticFlag = true;
entity.SaveChanges();
}