// GET: Admin/QuanLy
public ActionResult Index()
{
BaoCaoModel baocao = new BaoCaoModel();
int day = DateTime.Now.Day;
int month = DateTime.Now.Month;
int year = DateTime.Now.Year;
//Lay so sp da ban
int soSPDaBanHomNay = baocao.GetSoSPBanTaiQuanTrongNgay(day, month, year) + baocao.GetSoSPBanOnlineTrongNgay(day, month, year);
ViewBag.SoSPDaBanHomNay = soSPDaBanHomNay;
//Lay doanh thu 1 ngay
ViewBag.TongThuHomNay = baocao.GetTongThu1Ngay(day, month, year);
ViewBag.TongChiHomNay = baocao.GetTongChi1Ngay(day, month, year);
int soDonChuaXacNhan = baocao.GetSoDDHChuaXacNhanTrongNgay(day, month, year);
ViewBag.SoDonChuaXacNhan = soDonChuaXacNhan;
ViewBag.SoTienThuTaiQuan = baocao.GetTongThuTaiQuan1Ngay(day, month, year);
ViewBag.SoTienThuOnline = baocao.GetTongThuOnline1Ngay(day, month, year);
ViewBag.SoTienThuKhac = baocao.GetTongThuKhac1Ngay(day, month, year);
ViewBag.TongThuBuoiTrua = baocao.GetTongThuBuoiTrua1Ngay(day, month, year);
ViewBag.TongThuBuoiToi = baocao.GetTongThuBuoiToi1Ngay(day, month, year);
ViewBag.ChiNhapNguyenLieu = baocao.GetChiNhapNguyenLieu1Ngay(day, month, year);
ViewBag.ChiNhapDungCu = baocao.GetChiNhapDungCu1Ngay(day, month, year);
ViewBag.ChiNhapNuocGiaiKhat = baocao.GetChiNhapNuocGiaiKhat1Ngay(day, month, year);
ViewBag.ChiTraLuongNhanVien = baocao.GetChiTraLuongNhanVien1Ngay(day, month, year);
ViewBag.ChiKhac = baocao.GetChiKhac1Ngay(day, month, year);
return(View());
}
// GET: Admin/BaoCaoThuChi
public ActionResult Index(string thang, string nam)
{
int month;
int year;
try
{
month = Int32.Parse(thang);
year = Int32.Parse(nam);
}
catch { return(null); }
//Viewbag
List <int> dataChiThang = new List <int>();
List <int> dataThuThang = new List <int>();
List <int> dataDoanhThuThang = new List <int>();
//Lay du lieu tung ngay
BaoCaoModel baocao = new BaoCaoModel();
for (int i = 1; i <= DateTime.DaysInMonth(year, month); i++)
{
int chi = -baocao.GetTongChi1Ngay(i, month, year);
int thu = baocao.GetTongThu1Ngay(i, month, year);
dataChiThang.Add(chi);
dataThuThang.Add(thu);
dataDoanhThuThang.Add(thu + chi);
}
ViewBag.BaoCaoChiThang = dataChiThang;
ViewBag.BaoCaoThuThang = dataThuThang;
ViewBag.BaoCaoDoanhThuThang = dataDoanhThuThang;
ViewBag.Thang = thang;
ViewBag.Nam = nam;
//LAY so ngay can hien thi
int soNgayCanHienThi = 1;
if (month == DateTime.Now.Month && year == DateTime.Now.Year)
{
soNgayCanHienThi = DateTime.Now.Day;
}
else
{
soNgayCanHienThi = DateTime.DaysInMonth(year, month);
}
ViewBag.SoNgayCanHienThi = soNgayCanHienThi;
//Lay bao cao tong doanh thu
ViewBag.ThuBanHangTaiQuan = baocao.GetTongThuBanHangTaiQuan1Thang(month, year);
ViewBag.ThuBanHangTrenWeb = baocao.GetTongThuBanHangTrenWeb1Thang(month, year);
ViewBag.ThuKhac = baocao.GetTongThuKhac(month, year);
ViewBag.ChiNhapNguyenLieu = baocao.GetTongChiNhapNguyenLieu(month, year);
ViewBag.ChiNhapDungCu = baocao.GetTongChiNhapDungCu(month, year);
ViewBag.ChiNhapNuocGiaiKhat = baocao.GetTongChiNhapNuocGiaiKhat(month, year);
ViewBag.ChiTraLuongNhanVien = baocao.GetTongChiTraLuongNhanVien(month, year);
ViewBag.ChiKhac = baocao.GetTongChiKhac(month, year);
return(View());
}
// GET: Admin/BaoCaoHangNgay
public ActionResult Index(string ngay, string thang, string nam)
{
int day;
int month;
int year;
try
{
day = Int32.Parse(ngay);
month = Int32.Parse(thang);
year = Int32.Parse(nam);
}
catch { return(null); }
BaoCaoModel baocao = new BaoCaoModel();
//Lay so sp da ban
int soSPDaBanHomNay = baocao.GetSoSPBanTaiQuanTrongNgay(day, month, year) + baocao.GetSoSPBanOnlineTrongNgay(day, month, year);
ViewBag.SoSPDaBanHomNay = soSPDaBanHomNay;
//Lay doanh thu 1 ngay
ViewBag.TongThuHomNay = baocao.GetTongThu1Ngay(day, month, year);
ViewBag.TongChiHomNay = baocao.GetTongChi1Ngay(day, month, year);
int soDonChuaXacNhan = baocao.GetSoDDHChuaXacNhanTrongNgay(day, month, year);
ViewBag.SoDonChuaXacNhan = soDonChuaXacNhan;
ViewBag.SoTienThuTaiQuan = baocao.GetTongThuTaiQuan1Ngay(day, month, year);
ViewBag.SoTienThuOnline = baocao.GetTongThuOnline1Ngay(day, month, year);
ViewBag.SoTienThuKhac = baocao.GetTongThuKhac1Ngay(day, month, year);
ViewBag.TongThuBuoiTrua = baocao.GetTongThuBuoiTrua1Ngay(day, month, year);
ViewBag.TongThuBuoiToi = baocao.GetTongThuBuoiToi1Ngay(day, month, year);
ViewBag.ChiNhapNguyenLieu = baocao.GetChiNhapNguyenLieu1Ngay(day, month, year);
ViewBag.ChiNhapDungCu = baocao.GetChiNhapDungCu1Ngay(day, month, year);
ViewBag.ChiNhapNuocGiaiKhat = baocao.GetChiNhapNuocGiaiKhat1Ngay(day, month, year);
ViewBag.ChiTraLuongNhanVien = baocao.GetChiTraLuongNhanVien1Ngay(day, month, year);
ViewBag.ChiKhac = baocao.GetChiKhac1Ngay(day, month, year);
ViewBag.Ngay = ngay;
ViewBag.Thang = thang;
ViewBag.Nam = nam;
return(View());
}