public ThongKeModel getThongKeTheoTuan(DateTime?fromDate, DateTime?toDate)
{
try
{
DayOfWeek weekStart = DayOfWeek.Monday; // or Sunday, or whenever
DateTime startingDate = DateTime.Today;
while (startingDate.DayOfWeek != weekStart)
{
startingDate = startingDate.AddDays(-1);
}
DateTime previousWeekStart = startingDate.AddDays(-7);
DateTime previousWeekEnd = startingDate.AddDays(-1);
var thongke = new ThongKeModel();
var lsResult = new List <TB_CHITIETDKKHAM>();
lsResult = _unitOfWork.DKKhamRepository.Filter(c => DbFunctions.TruncateTime(c.NGAYDANGKY) <= previousWeekEnd && DbFunctions.TruncateTime(c.NGAYDANGKY) >= previousWeekStart).ToList();
if (lsResult != null)
{
thongke.TongSoDangKy = lsResult.Count();
thongke.ChoKham = lsResult.Where(x => x.MATRANGTHAI == 2).Count();
thongke.DangKham = lsResult.Where(x => x.MATRANGTHAI == 3).Count();
thongke.DaKham = lsResult.Where(x => x.MATRANGTHAI == 4).Count();
}
return(thongke);
}
catch (Exception ex)
{
OsLog.Error("ConfigWebServices --> getThongKe ", ex);
return(new ThongKeModel());
}
}
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 IActionResult ChiTietDiemDanhNhanVien(int id, int nam, int thang)
{
var diemdanhs = new List <DiemDanh>();
var model = new ThongKeModel()
{
Id = id,
Nam = nam,
Thang = thang
};
var url = $"{Common.Common.ApiUrl}/nhanvien/chitietdiemdanhnhanvien";
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
var json = JsonConvert.SerializeObject(model);
streamWriter.Write(json);
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var StreamReader = new StreamReader(httpResponse.GetResponseStream()))
{
var result = StreamReader.ReadToEnd();
diemdanhs = JsonConvert.DeserializeObject <List <DiemDanh> >(result);
}
return(View(diemdanhs));
}
public ThongKeModel BaoCaoCuoiNgay(string maShop)
{
ThongKeModel result = new ThongKeModel();
string msgError = "";
string msgError2 = "";
string msgError3 = "";
var dt = _dbHelper.ExecuteSProcedureReturnDataTable(out msgError, "CountDonHangHomNay", "@mashop", maShop);
var dt2 = _dbHelper.ExecuteSProcedureReturnDataTable(out msgError2, "DoanhThuHomNay", "@mashop", maShop);
var dt3 = _dbHelper.ExecuteSProcedureReturnDataTable(out msgError3, "BaoCaoCuoiNgay", "@mashop", maShop);
result.dsdh = dt3 != null && dt3.Rows.Count > 0 ? dt3.ConvertTo <DonHangModel>().ToList() : null;
if (dt2.Rows.Count > 0 && dt2.Rows[0]["doanhthu"] != DBNull.Value)
{
result.totalValue = (int)dt2.Rows[0]["doanhthu"];
}
if (dt2.Rows.Count > 0 && dt2.Rows[0]["donvi"] != DBNull.Value)
{
result.totalAmount = (int)dt2.Rows[0]["donvi"];
}
if (dt.Rows.Count > 0 && dt.Rows[0]["dh"] != DBNull.Value)
{
result.totalOrders = (int)dt.Rows[0]["dh"];
}
return(result);
}
// GET: Shipper/Home
public ActionResult Index()
{
if (Session["Shipper"] != null)
{
ThongKeModel tk = new ThongKeModel();
ViewBag.ThongKe = tk.GetThongKe(Session["UserN"].ToString());
List <string> lstString = new List <string>();
List <int> doanhthu = new List <int>();
foreach (var item in ViewBag.ThongKe)
{
DateTime date = item.NgayXacNhan;
lstString.Add(date.Day.ToString() + "/" + date.Month.ToString());
doanhthu.Add(item.ThongKe);
}
ViewBag.Date = lstString;
ViewBag.DoanhThu = doanhthu;
ViewData["DonHT"] = tk.TotalAccept(Session["UserN"].ToString());
ViewData["DonHuy"] = tk.TotalCancel(Session["UserN"].ToString());
ViewData["DonNhan"] = tk.Total(Session["UserN"].ToString());
return(View());
}
else
{
return(RedirectToAction("Index", "Login", new { area = "" }));
}
}
public IList <DiemDanh> ChiTietDiemDanhTheoThang(ThongKeModel model)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", model.Id);
parameters.Add("@Thang", model.Thang);
parameters.Add("@Nam", model.Nam);
IList <DiemDanh> diemDanhs = SqlMapper.Query <DiemDanh>(con, "sp_ChiTietDiemDanhTheoNhanVienId", parameters, commandType: CommandType.StoredProcedure).ToList();
return(diemDanhs);
}
public ThongKeModel TongQuanNam(string mashop, int nam)
{
var kq = new ThongKeModel();
kq.totalValue = 0;
kq.totalAmount = 0;
/* kq: 0 is amount, 1 is income,
* 2 is total orders that paid,3 is total orders that return
*/
string msgError = "";
try
{
var dt = _dbHelper.ExecuteSProcedureReturnDataTable(out msgError, "doanhthutheoshoptheonam", "@mashop", mashop, "@nam", nam);
var dt2 = _dbHelper.ExecuteSProcedureReturnDataTable(out msgError, "chiphinhaphangtheonam", "@mashop", mashop, "@nam", nam);
if (!string.IsNullOrEmpty(msgError))
{
throw new Exception(msgError);
}
if (dt.Rows.Count > 0 && dt.Rows[0]["DoanhThu"] != DBNull.Value)
{
kq.totalValue = (int)dt.Rows[0]["DoanhThu"];
}
if (dt.Rows.Count > 0 && dt.Rows[0]["DonVi"] != DBNull.Value)
{
kq.totalAmount = (int)dt.Rows[0]["DonVi"];
}
if (dt.Rows.Count > 0 && dt.Rows[0]["Orders"] != null)
{
kq.totalOrders = (int)dt.Rows[0]["Orders"];
}
if (dt2.Rows.Count > 0 && dt2.Rows[0]["ChiPhi"] != DBNull.Value)
{
kq.totalReValue = (int)dt2.Rows[0]["ChiPhi"];
}
if (dt2.Rows.Count > 0 && dt2.Rows[0]["DonVi"] != DBNull.Value)
{
kq.totalReAmount = (int)dt2.Rows[0]["DonVi"];
}
if (dt2.Rows.Count > 0 && dt2.Rows[0]["Orders"] != null)
{
kq.totalIR = (int)dt2.Rows[0]["Orders"];
}
return(kq);
}
catch (Exception ex)
{
throw ex;
}
}
public IList <DiemDanh> ChiTietDiemDanhTheoThang(ThongKeModel model)
{
return(_nhanVienRepository.ChiTietDiemDanhTheoThang(model));
}
public IActionResult KhachHang()
{
List <object> list = ThongKeModel.KhachHang();
return(View(list));
}
public IActionResult TopSanPham()
{
List <object> list = ThongKeModel.TopSanPham();
return(View(list));
}
public IActionResult DoanhThu()
{
List <object> list = ThongKeModel.DoanhThu();
return(View(list));
}
public ThongKeModel ThongkeThang(string mashop, int thang)
{
int doanhthutheoloai = 0; int chiphitheoloai = 0;
var kq = new ThongKeModel();
kq = tk.TongQuanThang(mashop, thang);
kq.incomebycates = l.GetDataAll();
kq.sphethang = tk.Sphethang(mashop);
kq.spbanchay = tk.Spbanchay(mashop, thang);
kq.dsdh = tk.donhangtheothang(mashop, thang);
kq.dshdn = tk.phieunhaptheothang(mashop, thang);
foreach (var item in kq.spbanchay)
{
item.dsgiaban = sp.GetGiaBans(item.MaSanPham);
item.giahientai = sp.Getgiahientai(item.MaSanPham);
item.kho = sp.Getkhobysp(item.MaSanPham);
item.danhmuc = sp.getloaibySanPham(item.MaSanPham);
item.loaicon1 = sp.getloai1bySanPham(item.MaSanPham);
item.loaicon2 = sp.getloai2bySanPham(item.MaSanPham);
}
foreach (var item in kq.sphethang)
{
item.dsgiaban = sp.GetGiaBans(item.MaSanPham);
item.giahientai = sp.Getgiahientai(item.MaSanPham);
item.kho = sp.Getkhobysp(item.MaSanPham);
item.danhmuc = sp.getloaibySanPham(item.MaSanPham);
item.loaicon1 = sp.getloai1bySanPham(item.MaSanPham);
item.loaicon2 = sp.getloai2bySanPham(item.MaSanPham);
}
foreach (var item in kq.dsdh)
{
item.Tonggiatri = 0;
item.TongDonVi = 0;
item.chitiet = dh.getctbymadonhang(item.MaDH);
{
for (int i = 0; i < item.chitiet.Count; i++)
{
item.Tonggiatri += item.chitiet[i].DonGia * item.chitiet[i].SoLuong;
item.TongDonVi += item.chitiet[i].SoLuong;
}
}
if (item.MaKH != null)
{
item.thongtinkh = kh.getbyid(item.MaKH);
}
else
{
item.thongtinkh = new KhachHangModel();
item.thongtinkh.tk = new TaiKhoanModel();
item.thongtinkh.HoTen = item.TenKH;
item.thongtinkh.tk.Email = item.Email;
}
if (item.MaDiaChi != null)
{
item.diachinhanhang = kh.Getdcbyid(item.MaDiaChi.Value);
item.diachinhanhang.tttinh = kh.GetTinh(item.diachinhanhang.Tinh);
item.diachinhanhang.tthuyen = kh.GetHuyen(item.diachinhanhang.Huyen);
item.diachinhanhang.ttxa = kh.GetXa(item.diachinhanhang.Xa);
}
else
{
item.diachinhanhang = new DiaChiModel();
item.diachinhanhang.tttinh = kh.GetTinh(item.Tinh.Value);
item.diachinhanhang.tttinh = kh.GetTinh(item.Tinh.Value);
item.diachinhanhang.ttxa = kh.GetXa(item.Xa.Value);
item.diachinhanhang.tthuyen = kh.GetHuyen(item.Huyen.Value);
item.diachinhanhang.ChiTiet = item.DCChitiet;
item.diachinhanhang.SoDienThoai = item.SoDienThoai;
}
}
foreach (var item in kq.dshdn)
{
item.Tongdonvi = 0;
item.Tongchiphi = 0;
item.chitiet = hdn.GetCtHDN(item.MaHDN);
for (int i = 0; i < item.chitiet.Count; i++)
{
item.Tongdonvi += item.chitiet[i].Soluong;
item.Tongchiphi += item.chitiet[i].Soluong * item.chitiet[i].DonGia;
}
}
foreach (var i in kq.incomebycates)
{
tk.doanhthutheoloaitheothang(mashop, i.MaLoai, thang, out doanhthutheoloai, out chiphitheoloai);
i.income = doanhthutheoloai;
i.chiphi = chiphitheoloai;
}
return(kq);
}
public IEnumerable <DiemDanh> ChiTietDiemDanh(ThongKeModel model)
{
return(_nhanVienService.ChiTietDiemDanhTheoThang(model));
}
