public OrderStatisticsController(ApplicationDbContext db)
{
_db = db;
OrderStatisticVM = new OrderStatisticsViewModel()
{
Orders = new List <Order>()
};
}
public ApiResult <OrderStatisticsViewModel> GetOrderStatistics()
{
var query = from o in _context.Orders
join tp in _context.Transports on o.id equals tp.order_id into otp
from g in otp.DefaultIfEmpty()
select new { g, o };
var model = new OrderStatisticsViewModel()
{
orderWaitForConfirm = query.Where(x => x.o.status == 0).Count(),
orderWaitForPay = query.Where(x => x.o.status == 1 && !x.o.isPay).Count(),
orderWaitForShip = query.Where(x => x.g == null && x.o.isPay & x.o.status != -1).Count(),
orderBeingShip = query.Where(x => x.g.ship_status == 1).Count(),
};
return(new ApiSuccessResult <OrderStatisticsViewModel>(model));
}
public ActionResult StatistscDetail(
string sendDate
, string customerCode
, string bundlerNo
, string containerNo
, string container)
{
try
{
if (String.IsNullOrEmpty(sendDate))
{
TempData["Error"] = "ETD is missing.";
return(View("Error"));
}
var model = new OrderStatisticsViewModel
{
SendDate = sendDate,
BundleNo = bundlerNo,
ContainerType = containerNo
};
model.Orders = OrderManager.Instance.LoadStatisticsDetail(
Convert.ToDateTime(sendDate)
, customerCode
, bundlerNo
, containerNo
, container);
model.OrderCount = model.Orders.Count;
foreach (var item in model.Orders)
{
model.Total += item.Total;
model.Size1Total += item.Size1;
model.Size2Total += item.Size2;
model.Size3Total += item.Size3;
model.Size4Total += item.Size4;
model.Size5Total += item.Size5;
model.Size6Total += item.Size6;
model.Size7Total += item.Size7;
model.Size8Total += item.Size8;
model.Size9Total += item.Size9;
model.Size10Total += item.Size10;
model.Size11Total += item.Size11;
model.Size12Total += item.Size12;
model.Size13Total += item.Size13;
model.Size14Total += item.Size14;
model.Size15Total += item.Size15;
model.Size16Total += item.Size16;
model.Size17Total += item.Size17;
model.Size18Total += item.Size18;
}
var user = AccountHelper.GetLoginUserInfo(HttpContext.User.Identity);
if (AccountHelper.IsSuperAdmin(user))
{
model.IsSuperAdmin = true;
model.ShoeSizes = ShoeManager.Instance.LoadShoeSize(Constants.SuperAdminDefaultCustomerCode);
}
else
{
model.ShoeSizes = ShoeManager.Instance.LoadShoeSize(user.CustomerCode);
}
return(PartialView(model));
}
catch (Exception ex)
{
TempData["Error"] = ex.Message;
return(View("Error"));
}
}
