// GET: ReceiptsChart public ActionResult ReceiptsChart(ReceiptsModels model) { // Fill Chart Data ------------------------------------------ #region Chart Data var api = new ReportsApiController(); var data = api.GetInvoiceRemainChart(model).ToList(); var opt = new ChartOption() { Name = "receiptsChart", ChartType = ChartTypes.Column, //XAxisData = chartCategories, YAxisData = new Data(data.Select(x => new Point() { Id = x.id.ToString(), Name = x.name, Y = x.y }).ToArray()), Tilte = "گزارش جمعی رسیدی ها به تفکیک متصدی ها", YAxisTitle = "جمع ریالی", SeriesName = "پرسنل", ShowLegend = false, ShowDataLabels = true, SubTitle = $"مبلغ کل رسیدی دفتر: {data.Sum(x => (long)x.y).ToString("N0", CultureInfo.GetCultureInfo("fa-IR"))}" }; #endregion //---------------------------------------------------------- return(PartialView("Receipt/ReceiptsChart", HtmlHelperExtensions.GetHighChart(opt))); }
public IEnumerable <dynamic> GetInvoiceRemainChart(ReceiptsModels model) { var result = Connections.SaleBranch.SqlConn.Query("sp_GetInvoiceRemainChart", new { EmployeeID = CurrentUser.UserName, EmployeeTypeid = CurrentUser.EmployeeType, FromRemain = model.FromNo, ToRemain = model.ToNo, DistanceAfterDistributeDate = model.DistanceAfterDistributeDate, RunDate = DateTime.Now.GetPersianDateNumber() }, commandType: System.Data.CommandType.StoredProcedure); return(result); }
public ActionResult Receipts(ReceiptsModels model) { ViewBag.Title = "گزارش رسیدی"; ViewData["dir"] = "ltr"; if (model == null || (model.FromNo == 0 && model.ToNo == 0)) { model = new ReceiptsModels() { FromNo = 10000, ToNo = 1000000000000, DistanceAfterDistributeDate = 2 }; } return(View("Receipt/Receipts", model)); }
// GET: ReceiptsTable public ActionResult ReceiptsTable(ReceiptsModels model) { ViewBag.Username = CurrentUser.UserName; // Fill Table data ------------------------------------------ #region Table Data var tableData = Connections.SaleBranch.SqlConn.ExecuteReader( "sp_GetInvoiceRemain", new { EmployeeID = CurrentUser.UserName, EmployeeTypeid = CurrentUser.EmployeeType, FromRemain = model.FromNo, ToRemain = model.ToNo, DistanceAfterDistributeDate = model.DistanceAfterDistributeDate, RunDate = DateTime.Now.GetPersianDateNumber() }, commandType: CommandType.StoredProcedure).ToDataTable(); var tblModel = new TableOption() { Id = "receipts", Data = tableData, DisplayRowsLength = 10, Orders = new[] { Tuple.Create(0, OrderType.desc) }, TotalFooterColumns = new[] { "InvoiceRemain", "Payable" }, AverageFooterColumns = new[] { "ShamsiDateDiff" }, CurrencyColumns = new[] { 8, 9 } }; #endregion //----------------------------------------------------------- ToolsController.SetLastUserRunningAction(CurrentUser.UserName, "ReceiptsTable", tableData); return(PartialView("Receipt/ReceiptsTable", tblModel)); }