public ActionResult GetDataChartRevenue(ThongKeModel data) //flag 1: ngay, 2: thang, 3:nam
{
List <ChartThongKe> model = new List <ChartThongKe>();
//ngay
if (data.flag == 1)
{
model = ThongKeService.GetDataChartForDay(data.TuNgay, data.DenNgay);
}
//thang
if (data.flag == 2)
{
model = ThongKeService.GetDataChartForMonth(data.TuNgay, data.DenNgay);
}
////nam
if (data.flag == 3)
{
model = ThongKeService.GetDataChartForYear(data.TuNgay, data.DenNgay);
}
ViewBag.TotalRevenue = ThongKeService.GetDataChartTotalThongKe(data.TuNgay, data.DenNgay);
ViewBag.Flag = data.flag;
return(PartialView("_ChartThongKe", model));
}
public ActionResult Export(ExportModel model)
{
var tenFile = model.TenFile + DateTime.Now.ToString("yyyyMMdd HH-mm") + ".xlsx";
var data = _soLieuNhapLieuService.GetSoLieuNhapLieusXuatFile(model.fromDate,
model.toDate, model.fromNumber, model.toNumber);
if (model.fromDate.HasValue == false || model.toDate.HasValue == false)
{
model.fromDate = data.Min(_ => _.NgayNhap);
model.toDate = data.Max(_ => _.NgayNhap);
}
var filePath =
ThongKeService.ExportFileThongKe(tenFile, model.TenNguoiThu, model.fromDate.Value, model.toDate.Value, data);
var mimeType = MimeMapping.GetMimeMapping(filePath);
byte[] stream = System.IO.File.ReadAllBytes(filePath);
return(File("~/XuatFiles/" + tenFile, mimeType, tenFile));
}
public JsonResult _ThongTinBaoCao(int?NhapKhoId, int?SanPhamId, IDataTablesRequest request)
{
var pageNum = request.Start / request.Length + 1;
ThongKeService _thongke = new ThongKeService();
var danhsach = _thongke.ListBaoCao(NhapKhoId, SanPhamId, request);
var result = danhsach.ToPagedList(pageNum, request.Length);
return(Json(new
{
draw = request.Draw,
data = result.Select(m => new
{
m.BaoCaoId,
m.TenSanPham,
m.DiaChiNhapHang,
m.NgayTao,
m.SoLuong,
m.TongTien,
}).ToList(),
recordsTotal = result.TotalItemCount,
recordsFiltered = result.TotalItemCount
}, JsonRequestBehavior.AllowGet));
}
