public async Task <IHttpActionResult> PostReportGDQTongHop(ParameterCashier para)
{
NvGiaoDichQuayVm.ReportGDQTongHopNew reporter = new NvGiaoDichQuayVm.ReportGDQTongHopNew();
try
{
var unitCode = _service.GetCurrentUnitCode();
reporter.CreateDateNow();
reporter.FromDay = para.FromDate.Day;
reporter.FromMonth = para.FromDate.Month;
reporter.FromYear = para.FromDate.Year;
reporter.ToDay = para.ToDate.Day;
reporter.ToMonth = para.ToDate.Month;
reporter.ToYear = para.ToDate.Year;
reporter.ToDate = para.ToDate;
reporter.FromDate = para.FromDate;
reporter.TenDonVi = CurrentSetting.GetUnitName(unitCode);
reporter.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode);
//GetNhanVien
if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal)
{
var currentUser = (HttpContext.Current.User as ClaimsPrincipal);
var name = currentUser.Identity.Name;
var nhanVien = _service.UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault();
if (nhanVien != null)
{
reporter.Username = nhanVien.Username;
}
else
{
reporter.Username = "******";
}
}
switch (para.LoaiGiaoDich)
{
case TypeGiaoDich.NHAPBANLETRALAI:
reporter.DataDetails.AddRange(_service.ReportNhapBLeTraLai(para));
break;
default:
reporter.DataDetails.AddRange(_service.ReportGiaoDichQuay(para));
break;
}
}
catch (Exception ex)
{
}
return(Ok(reporter));
}
public async Task <IHttpActionResult> GetNewParameter()
{
var unitCode = _service.GetCurrentUnitCode();
var currentDate = DateTime.Now.Date;
var datelock = CurrentSetting.GetNgayKhoaSo(unitCode);
var result = new ParameterCashier()
{
ToDate = datelock,
FromDate = datelock,
MaxDate = currentDate,
UnitCode = unitCode,
GroupBy = TypeGroupInventoryCashier.MALOAIVATTU,
LoaiGiaoDich = TypeGiaoDich.XUATBANLE
};
return(Ok(result));
}
public async Task <IHttpActionResult> PostPrintTranferCashieer(ParameterCashier para)
{
NvGiaoDichQuayVm.ReportGDQ reporter = new NvGiaoDichQuayVm.ReportGDQ();
List <NvGiaoDichQuayVm.ReportGDQDetailLevel2> result = new List <NvGiaoDichQuayVm.ReportGDQDetailLevel2>();
try
{
//for (int i = 0; i < nv.Count();i++ )
//{
var unitCode = _service.GetCurrentUnitCode();
reporter.CreateDateNow();
reporter.FromDay = para.FromDate.Day;
reporter.FromMonth = para.FromDate.Month;
reporter.FromYear = para.FromDate.Year;
reporter.ToDay = para.ToDate.Day;
reporter.ToMonth = para.ToDate.Month;
reporter.ToYear = para.ToDate.Year;
reporter.ToDate = para.ToDate;
reporter.FromDate = para.FromDate;
reporter.TenDonVi = CurrentSetting.GetUnitName(unitCode);
reporter.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode);
//GetNhanVien
if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal)
{
var currentUser = (HttpContext.Current.User as ClaimsPrincipal);
var name = currentUser.Identity.Name;
var nhanVien = _service.UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault();
if (nhanVien != null)
{
reporter.Username = nhanVien.TenNhanVien;
}
else
{
reporter.Username = "******";
}
}
reporter.DataDetails.AddRange(_service.CreatePrintTranferCashieer(para.FromDate, para.ToDate, para.UnitCode, para.SellingMachineCodes, para.CashieerCodes));
//}
}
catch (Exception ex)
{
}
return(Ok(reporter));
}
public async Task <IHttpActionResult> CreateReportCashierByStaff(ParameterCashier para)
{
var result = new TransferObj <ReportCashier>();
try
{
var report = new ReportCashier();
var data = _service.CreateReportCashierByStaff(para.FromDate, para.ToDate, para.UnitCode);
report.Data = data;
report.CreateDate();
var userName = ControllerContext.RequestContext.Principal.Identity.Name;
report.SetWhoCreateThis(userName);
result.Data = report;
result.Data.CreateDate();
result.Status = true;
return(Ok(result));
}
catch (Exception e)
{
return(InternalServerError());
}
}
public HttpResponseMessage PostExportExcelGDQTongHop(ParameterCashier para)
{
HttpResponseMessage response = Request.CreateResponse();
try
{
MemoryStream streamData = new MemoryStream();
switch (para.LoaiGiaoDich)
{
case TypeGiaoDich.NHAPBANLETRALAI:
streamData = _service.ExportExcelNhapBLeTraLaiTongHop(para);
//switch (para.GroupBy)
//{
// case TypeGroupInventoryCashier.TYPE:
// case TypeGroupInventoryCashier.GROUP:
// case TypeGroupInventoryCashier.NHACUNGCAP:
// case TypeGroupInventoryCashier.WAREHOUSE:
// case TypeGroupInventoryCashier.MERCHANDISE:
// case TypeGroupInventoryCashier.GIAODICH:
// break;
//}
break;
default:
streamData = _service.ExportExcelGDQTongHop(para);
//switch (para.GroupBy)
//{
// case TypeGroupInventoryCashier.TYPE:
// case TypeGroupInventoryCashier.GROUP:
// case TypeGroupInventoryCashier.NHACUNGCAP:
// case TypeGroupInventoryCashier.WAREHOUSE:
// case TypeGroupInventoryCashier.MERCHANDISE:
// case TypeGroupInventoryCashier.GIAODICH:
// break;
//}
break;
}
response.StatusCode = HttpStatusCode.OK;
streamData.Seek(0, SeekOrigin.Begin);
response.Content = new StreamContent(streamData);
switch (para.GroupBy)
{
case TypeGroupInventoryCashier.MANHOMVATTU:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BaoCao_GDQ_TongHop_TheoNhomVatTu.xlsx"
};
break;
case TypeGroupInventoryCashier.MALOAIVATTU:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BaoCao_GDQ_TongHop_TheoLoaiVatTu.xlsx"
};
break;
case TypeGroupInventoryCashier.MAKHACHHANG:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BaoCao_GDQ_TongHop_TheoNhaCungCap.xlsx"
};
break;
case TypeGroupInventoryCashier.MAVATTU:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BaoCao_GDQ_TongHop_TheoVatTu.xlsx"
};
break;
case TypeGroupInventoryCashier.MAGIAODICH:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BaoCao_GDQ_TongHop_TheoGiaoDich.xlsx"
};
break;
case TypeGroupInventoryCashier.MAKHO:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BaoCao_GDQ_TongHop_TheoKho.xlsx"
};
break;
default:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BaoCao_GDQ_TongHop.xlsx"
};
break;
}
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
return(response);
}
catch (Exception ex)
{
response.StatusCode = HttpStatusCode.InternalServerError;
return(response);
}
}
public HttpResponseMessage ExportExcel(ParameterCashier para)
{
var _ParentUnitCode = _service.GetParentUnitCode();
NvGiaoDichQuayVm.ReportExcel result = null;
var unitCode = _service.GetCurrentUnitCode();
//var instance = _service.Repository.DbSet.FirstOrDefault(x => x.MaVatTu.ToUpper() == code.ToUpper());//&& x.UnitCode == unitCode);
var service = new ProcedureService <NvGiaoDichQuayVm.ReportExcel>();
var data = ProcedureCollection.GetReportGDQExcel(para.FromDate, para.ToDate, new BTS.API.ENTITY.ERPContext(), unitCode);
using (ExcelPackage package = new ExcelPackage())
{
var ms = new MemoryStream();
package.Workbook.Worksheets.Add("Data");
var worksheet = package.Workbook.Worksheets[1];
int index = 0;
worksheet.Cells[1, 1, 1, 5].Merge = true;
worksheet.Cells[1, 1].Value = "SIÊU THỊ TỪ SƠN ";
worksheet.Cells[2, 1, 2, 5].Merge = true;
worksheet.Cells[2, 1].Value = "Đường Lý Thái Tổ, P. Đình Bảng, TX Từ Sơn, Bắc Ninh ";
worksheet.Cells[4, 4, 4, 7].Merge = true;
worksheet.Cells[4, 4].Value = "BÁO CÁO GIAO DỊCH QUẦY ";
worksheet.Cells[5, 4, 5, 8].Merge = true;
worksheet.Cells[5, 4].Value = "Từ ngày: " + para.FromDate.Day + "/" + para.FromDate.Month + "/" + para.FromDate.Year + " Đến ngày:" + para.ToDate.Day + "/" + para.ToDate.Month + "/" + para.ToDate.Year;
worksheet.Cells[7, 1].Value = "STT";
worksheet.Cells[7, 2].Value = "Nhân viên";
worksheet.Cells[7, 3].Value = "Máy bán";
worksheet.Cells[7, 4].Value = "Ngày phát sinh";
worksheet.Cells[7, 5].Value = "Loại giao dịch";
worksheet.Cells[7, 6].Value = "Mã hàng";
worksheet.Cells[7, 7].Value = "Tên hàng";
worksheet.Cells[7, 8].Value = "Số lượng";
worksheet.Cells[7, 9].Value = "Tổng tiền";
index = 8;
if (data != null && data.Count() >= 1)
{
var item = data.ToList();
for (int i = 0; i < item.Count; i++)
{
var hanghoa = new MdMerchandiseVm.Dto();
var innerindex = item[i].MaVatTu;
var hanghoatg = _merchandiseservice.UnitOfWork.Repository <MdMerchandise>().DbSet.FirstOrDefault(x => x.MaVatTu == innerindex && x.UnitCode.StartsWith(_ParentUnitCode));
hanghoa = Mapper.Map <MdMerchandise, MdMerchandiseVm.Dto>(hanghoatg);
worksheet.Cells[index, 1].Value = index;
worksheet.Cells[index, 2].Value = item[i].MaNguoiTao + "-" + item[i].NguoiTao;
worksheet.Cells[index, 3].Value = item[i].MaQuayBan;
worksheet.Cells[index, 4].Value = item[i].NgayPhatSinh.Date + "/" + item[i].NgayPhatSinh.Month + "/" + item[i].NgayPhatSinh.Year;
worksheet.Cells[index, 6].Value = item[i].MaVatTu;
if (hanghoa == null)
{
worksheet.Cells[index, 7].Value = " ";
}
worksheet.Cells[index, 7].Value = hanghoa.TenHang;
worksheet.Cells[index, 8].Value = item[i].SoLuong;
worksheet.Cells[index, 9].Value = CurrentSetting.FormatTienViet(item[i].TTienCoVat.ToString());
if (item[i].LoaiGiaoDich == 1)
{
worksheet.Cells[index, 5].Value = "xuất bán";
}
else if (item[i].LoaiGiaoDich == 2)
{
worksheet.Cells[index, 5].Value = "bán trả lại";
}
index++;
}
}
else
{
//return null;
}
package.SaveAs(ms);
HttpResponseMessage response = Request.CreateResponse();
response.StatusCode = HttpStatusCode.OK;
ms.Seek(0, SeekOrigin.Begin);
response.Content = new StreamContent(ms);
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BaoCaoGiaoDichQuay.xlsx"
};
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
return(response);
}
}
