protected override FlowDocument GetReport() { var report = new SimpleReport("8cm"); AddDefaultReportHeader(report, ReportContext.CurrentWorkPeriod, Resources.ItemSalesReport); var menuGroups = MenuGroupBuilder.CalculateMenuGroups(ReportContext.Tickets, ReportContext.MenuItems).ToList(); report.AddColumTextAlignment("ÜrünGrubu", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right); report.AddColumnLength("ÜrünGrubu", "40*", "Auto", "35*"); report.AddTable("ÜrünGrubu", Resources.SalesByItemGroup, "", ""); foreach (var menuItemInfo in menuGroups.Where(x => x.Rate != 0)) { report.AddRow("ÜrünGrubu", menuItemInfo.GroupName, string.Format("%{0:0.00}", menuItemInfo.Rate), menuItemInfo.Amount.ToString(ReportContext.CurrencyFormat)); } report.AddRow("ÜrünGrubu", Resources.Total, "", menuGroups.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat)); //---------------------- report.AddColumTextAlignment("ÜrünGrubuMiktar", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right); report.AddColumnLength("ÜrünGrubuMiktar", "40*", "Auto", "35*"); report.AddTable("ÜrünGrubuMiktar", Resources.QuantitiesByItemGroup, "", ""); foreach (var menuItemInfo in menuGroups.Where(x => x.QuantityRate != 0)) { report.AddRow("ÜrünGrubuMiktar", menuItemInfo.GroupName, string.Format("%{0:0.00}", menuItemInfo.QuantityRate), menuItemInfo.Quantity.ToString("#")); } report.AddRow("ÜrünGrubuMiktar", Resources.Total, "", menuGroups.Sum(x => x.Quantity).ToString("#")); //---------------------- var menuItems = MenuGroupBuilder.CalculateMenuItems(ReportContext.Tickets, ReportContext.MenuItems) .OrderByDescending(x => x.Quantity); report.AddColumTextAlignment("ÜrünTablosu", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right); report.AddColumnLength("ÜrünTablosu", "50*", "Auto", "25*"); report.AddTable("ÜrünTablosu", Resources.MenuItem, Resources.Quantity, Resources.Amount); foreach (var menuItemInfo in menuItems) { report.AddRow("ÜrünTablosu", menuItemInfo.Name, string.Format("{0:0.##}", menuItemInfo.Quantity), menuItemInfo.Amount.ToString(ReportContext.CurrencyFormat)); PrintPortionsSections(report, ReportContext.MenuItems, menuItemInfo, "ÜrünTablosu"); } report.AddRow("ÜrünTablosu", Resources.Total, "", menuItems.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat)); //---------------------- var returnedMenuItems = MenuGroupBuilder.CalculateReturnedItems(ReportContext.Tickets, ReportContext.MenuItems) .OrderByDescending(x => x.Quantity); if (returnedMenuItems.Any()) { report.AddColumTextAlignment("IadeTablosu", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right); report.AddColumnLength("IadeTablosu", "50*", "Auto", "25*"); report.AddTable("IadeTablosu", Resources.MenuItem, Resources.Quantity, Resources.Amount); foreach (var menuItemInfo in returnedMenuItems) { report.AddRow("IadeTablosu", menuItemInfo.Name, string.Format("{0:0.##}", menuItemInfo.Quantity), menuItemInfo.Amount.ToString(ReportContext.CurrencyFormat)); } report.AddRow("IadeTablosu", Resources.Total, "", returnedMenuItems.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat)); } //---------------------- //PrepareModificationTable(report, x => x.Voided, Resources.Voids); //PrepareModificationTable(report, x => x.Gifted, Resources.Gifts); //var discounts = ReportContext.Tickets // .SelectMany(x => x.Discounts.Select(y => new { x.TicketNumber, y.UserId, Amount = y.DiscountAmount })) // .GroupBy(x => new { x.TicketNumber, x.UserId }).Select(x => new { x.Key.TicketNumber, x.Key.UserId, Amount = x.Sum(y => y.Amount) }); //if (discounts.Count() > 0) //{ // report.AddColumTextAlignment("İskontolarTablosu", TextAlignment.Left, TextAlignment.Left, TextAlignment.Right); // report.AddColumnLength("İskontolarTablosu", "20*", "Auto", "35*"); // report.AddTable("İskontolarTablosu", Resources.Discounts, "", ""); // foreach (var discount in discounts.OrderByDescending(x => x.Amount)) // { // report.AddRow("İskontolarTablosu", discount.TicketNumber, ReportContext.GetUserName(discount.UserId), discount.Amount.ToString(ReportContext.CurrencyFormat)); // } // if (discounts.Count() > 1) // report.AddRow("İskontolarTablosu", Resources.Total, "", discounts.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat)); //} //---------------------- //var ticketGroups = ReportContext.Tickets // .GroupBy(x => new { x.DepartmentId }) // .Select(x => new { x.Key.DepartmentId, TicketCount = x.Count(), Amount = x.Sum(y => y.GetSumWithoutTax()) }); //if (ticketGroups.Count() > 0) //{ // report.AddColumTextAlignment("AdisyonlarTablosu", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right); // report.AddColumnLength("AdisyonlarTablosu", "40*", "20*", "40*"); // report.AddTable("AdisyonlarTablosu", Resources.Tickets, "", ""); // foreach (var ticketGroup in ticketGroups) // { // report.AddRow("AdisyonlarTablosu", ReportContext.GetDepartmentName(ticketGroup.DepartmentId), ticketGroup.TicketCount.ToString("#.##"), ticketGroup.Amount.ToString(ReportContext.CurrencyFormat)); // } // if (ticketGroups.Count() > 1) // report.AddRow("AdisyonlarTablosu", Resources.Total, ticketGroups.Sum(x => x.TicketCount).ToString("#.##"), ticketGroups.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat)); //} //---------------------- var orderTags = ReportContext.Tickets .SelectMany(x => x.Orders.Where(y => !string.IsNullOrEmpty(y.OrderTags) && (y.IncreaseInventory || y.DecreaseInventory))) .SelectMany(x => x.GetOrderTagValues(y => y.MenuItemId == 0).Select(y => new { Name = y.TagValue, x.Quantity, Total = y.Price * x.Quantity })) .GroupBy(x => new { x.Name }) .Select(x => new { x.Key.Name, Quantity = x.Sum(y => y.Quantity), Amount = x.Sum(y => y.Total) }).ToList(); if (orderTags.Any()) { report.AddColumTextAlignment("ÖzelliklerTablosu", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right); report.AddColumnLength("ÖzelliklerTablosu", "50*", "20*", "30*"); report.AddTable("ÖzelliklerTablosu", Resources.Properties, "", ""); foreach (var property in orderTags.OrderByDescending(x => x.Quantity)) { report.AddRow("ÖzelliklerTablosu", property.Name, property.Quantity.ToString(LocalSettings.ReportQuantityFormat), property.Amount.ToString(LocalSettings.ReportCurrencyFormat)); } } report.AddColumTextAlignment("OrderStates", TextAlignment.Left, TextAlignment.Left, TextAlignment.Right); report.AddColumnLength("OrderStates", "4*", "3*", "3*"); report.AddTable("OrderStates", Resources.GeneralInformation, "", ""); var orderStates = ReportContext.Tickets .SelectMany(x => x.Orders) .SelectMany(x => x.GetOrderStateValues()).Distinct().ToList(); if (orderStates.Any()) { report.AddBoldRow("OrderStates", Resources.Orders, "", ""); foreach (var orderStateValue in orderStates.Where(x => _cacheService.CanShowStateOnProductReport(x.StateName, x.State)).OrderBy(x => x.OrderKey).ThenBy(x => x.StateValue)) { var value = orderStateValue; var items = ReportContext.Tickets.SelectMany(x => x.Orders).Where(x => x.IsInState(value.StateName, value.State, value.StateValue)).ToList(); var amount = items.Sum(x => x.GetValue()); var count = items.Count(); report.AddBoldRow("OrderStates", string.Format("{0} {1} ({2})", orderStateValue.State, orderStateValue.StateValue, count), "", amount.ToString(ReportContext.CurrencyFormat)); foreach (var order in items.GroupBy(x => new { x.MenuItemName, x.GetStateValue(value.StateName).UserId })) { report.AddRow("OrderStates", order.Sum(x => x.Quantity).ToString(LocalSettings.QuantityFormat) + " x " + order.Key.MenuItemName, UserService.GetUserName(order.Key.UserId), order.Sum(x => x.GetValue()).ToString(ReportContext.CurrencyFormat)); } } } return(report.Document); }