private static void PrintPortionsSections(SimpleReport report, IEnumerable <MenuItem> items, MenuItemSellInfo menuItem, string reportTable)
{
var realMenuItem = items.FirstOrDefault(x => x.Name == menuItem.Name);
var menuItemGroups = MenuGroupBuilder.CalculatePortionsItems(ReportContext.Tickets, realMenuItem)
.OrderByDescending(x => x.Quantity);
if (menuItemGroups.Count() > 1)
{
foreach (var menuItemInfo in menuItemGroups)
{
report.AddRow(reportTable, menuItemInfo.Name, string.Format("({0:0.##})", menuItemInfo.Quantity),
"(" + menuItemInfo.Amount.ToString(ReportContext.CurrencyFormat) + ")");
}
}
}
private void ExportSalesData()
{
var fileName = AskFileName(Resources.ExportSalesData + "_" + String.Format("{0:yyyy-MM-dd_hh-mm-ss}.txt", DateTime.Now), ".csv");
if (string.IsNullOrEmpty(fileName))
{
return;
}
var lines = ReportContext.Tickets.SelectMany(x => x.TicketItems, (t, ti) => new { Ticket = t, TicketItem = ti });
var data = lines.Select(x =>
new
{
DateTime = x.TicketItem.CreatedDateTime,
Date = x.TicketItem.CreatedDateTime.ToShortDateString(),
Time = x.TicketItem.CreatedDateTime.ToShortTimeString(),
x.Ticket.TicketNumber,
UserName = ReportContext.GetUserName(x.TicketItem.CreatingUserId),
Account = x.Ticket.CustomerName,
Location = x.Ticket.LocationName,
x.TicketItem.DepartmentId,
x.TicketItem.OrderNumber,
x.TicketItem.Voided,
x.TicketItem.Gifted,
Name = x.TicketItem.MenuItemName,
Portion = x.TicketItem.PortionName,
x.TicketItem.Quantity,
Price = x.TicketItem.GetItemPrice(),
Value = x.TicketItem.GetItemValue(),
Discount = x.Ticket.GetPlainSum() > 0 ? x.Ticket.GetDiscountTotal() / x.Ticket.GetPlainSum() : 0,
Rounding = x.Ticket.GetRoundingTotal(),
Total = MenuGroupBuilder.CalculateTicketItemTotal(x.Ticket, x.TicketItem),
}
);
var csv = data.AsCsv();
File.WriteAllText(fileName, csv);
}
private void ExportSalesData()
{
var fileName = AskFileName(
Resources.ExportSalesData + "_" + DateTime.Now.ToString().Replace(":", "").Replace(" ", "_"), ".csv");
if (string.IsNullOrEmpty(fileName))
{
return;
}
var lines = ReportContext.Tickets.SelectMany(x => x.Orders, (t, ti) => new { Ticket = t, Order = ti });
var data = lines.Select(x =>
new
{
DateTime = x.Order.CreatedDateTime,
Date = x.Order.CreatedDateTime.ToShortDateString(),
Time = x.Order.CreatedDateTime.ToShortTimeString(),
x.Ticket.TicketNumber,
UserName = x.Order.CreatingUserName,
Account = x.Ticket.AccountName,
//TargetAccount = x.Ticket.TargetAccountName,
x.Order.OrderNumber,
x.Order.CalculatePrice,
DecreaseFromInventory = x.Order.DecreaseInventory,
Name = x.Order.MenuItemName,
Portion = x.Order.PortionName,
x.Order.Quantity,
Price = x.Order.GetItemPrice(),
Value = x.Order.GetItemValue(),
//Discount = x.Ticket.GetPlainSum() > 0 ? x.Ticket.GetDiscountTotal() / x.Ticket.GetPlainSum() : 0,
//Rounding = x.Ticket.GetRoundingTotal(),
Total = MenuGroupBuilder.CalculateOrderTotal(x.Ticket, x.Order),
}
);
var csv = data.AsCsv();
File.WriteAllText(fileName, csv);
}
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));
}
}
return(report.Document);
}
protected override FlowDocument GetReport()
{
var currentPeriod = ReportContext.CurrentWorkPeriod;
var report = new SimpleReport("8cm");
AddDefaultReportHeader(report, currentPeriod, Resources.WorkPeriodReport);
//---------------
report.AddColumTextAlignment("Departman", TextAlignment.Left, TextAlignment.Right);
report.AddTable("Departman", Resources.Sales, "");
var ticketGropus = ReportContext.Tickets
.GroupBy(x => new { x.DepartmentId })
.Select(x => new DepartmentInfo
{
DepartmentId = x.Key.DepartmentId,
TicketCount = x.Count(),
Amount = x.Sum(y => y.GetSumWithoutTax()),
Vat = x.Sum(y => y.CalculateTax()),
TaxServices = x.Sum(y => y.GetTaxServicesTotal())
});
report.AddRow("Departman", Resources.TotalSales.ToUpper(), ticketGropus.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat));
var vatSum = ticketGropus.Sum(x => x.Vat);
var serviceSum = ticketGropus.Sum(x => x.TaxServices);
if (vatSum > 0 || serviceSum > 0)
{
if (vatSum > 0)
{
report.AddRow("Departman", Resources.VatTotal.ToUpper(), vatSum.ToString(ReportContext.CurrencyFormat));
}
if (serviceSum > 0)
{
ReportContext.Tickets.SelectMany(x => x.TaxServices).GroupBy(x => x.TaxServiceId).ForEach(
x =>
{
var template = ReportContext.TaxServiceTemplates.SingleOrDefault(y => y.Id == x.Key);
var title = template != null ? template.Name : Resources.UndefinedWithBrackets;
report.AddRow("Departman", title, x.Sum(y => y.CalculationAmount).ToString(ReportContext.CurrencyFormat));
});
}
report.AddRow("Departman", Resources.GrandTotal.ToUpper(), ticketGropus.Sum(x => x.Amount + x.Vat + x.TaxServices).ToString(ReportContext.CurrencyFormat));
}
//---------------
if (ReportContext.Departments.Count() > 1)
{
var showDepartmentTotals = false;
report.AddColumnLength("CrossSales", "65*", "40*");
report.AddColumTextAlignment("CrossSales", TextAlignment.Left, TextAlignment.Right);
report.AddTable("CrossSales", Resources.DepartmentSales, "");
foreach (var departmentInfo in ticketGropus)
{
var info = departmentInfo;
var crossSales = ReportContext.Tickets.Where(x => x.DepartmentId == info.DepartmentId)
.SelectMany(ticket => ticket.TicketItems.Select(ticketItem => new { Ticket = ticket, TicketItem = ticketItem }))
.Where(x => x.TicketItem.DepartmentId != x.Ticket.DepartmentId)
.GroupBy(x => new { x.TicketItem.DepartmentId })
.Select(x => new DepartmentInfo {
DepartmentId = x.Key.DepartmentId, Amount = x.Sum(y => MenuGroupBuilder.CalculateTicketItemTotal(y.Ticket, y.TicketItem))
});
report.AddRow("CrossSales", string.Format("{0} {1}", departmentInfo.DepartmentName, Resources.Sales), (departmentInfo.Amount).ToString(ReportContext.CurrencyFormat));
if (crossSales.Count() > 0)
{
showDepartmentTotals = true;
report.AddRow("CrossSales", " -" + departmentInfo.DepartmentName, (departmentInfo.Amount - crossSales.Sum(x => x.Amount)).ToString(ReportContext.CurrencyFormat));
foreach (var crossSale in crossSales)
{
var cs = crossSale;
report.AddRow("CrossSales", " -" + cs.DepartmentName, cs.Amount.ToString(ReportContext.CurrencyFormat));
}
}
}
if (showDepartmentTotals)
{
report.AddBoldRow("CrossSales", Resources.Department + " " + Resources.Totals, "");
var salesByOrder = ReportContext.Tickets.SelectMany(ticket => ticket.TicketItems.Select(ticketItem => new { Ticket = ticket, TicketItem = ticketItem }))
.GroupBy(x => new { x.TicketItem.DepartmentId })
.Select(x => new DepartmentInfo {
DepartmentId = x.Key.DepartmentId, Amount = x.Sum(y => MenuGroupBuilder.CalculateTicketItemTotal(y.Ticket, y.TicketItem))
});
foreach (var sale in salesByOrder)
{
var cs = sale;
report.AddRow("CrossSales", cs.DepartmentName, cs.Amount.ToString(ReportContext.CurrencyFormat));
}
}
}
//---------------
var ac = ReportContext.GetOperationalAmountCalculator();
report.AddColumnLength("GelirlerTablosu", "45*", "Auto", "35*");
report.AddColumTextAlignment("GelirlerTablosu", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddTable("GelirlerTablosu", Resources.Incomes, "", "");
report.AddRow("GelirlerTablosu", Resources.Cash, ac.CashPercent, ac.CashTotal.ToString(ReportContext.CurrencyFormat));
report.AddRow("GelirlerTablosu", Resources.CreditCard, ac.CreditCardPercent, ac.CreditCardTotal.ToString(ReportContext.CurrencyFormat));
report.AddRow("GelirlerTablosu", Resources.Voucher, ac.TicketPercent, ac.TicketTotal.ToString(ReportContext.CurrencyFormat));
report.AddRow("GelirlerTablosu", Resources.AccountBalance, ac.AccountPercent, ac.AccountTotal.ToString(ReportContext.CurrencyFormat));
report.AddRow("GelirlerTablosu", Resources.TotalIncome.ToUpper(), "", ac.TotalAmount.ToString(ReportContext.CurrencyFormat));
//---------------
//Kasa raporu eklendiği için kasa özeti bu rapordan kaldırıldı. Başka bir rapora taşınabilir şimdilik bıraktım.
//var cashTransactionTotal = ReportContext.GetCashTotalAmount();
//var creditCardTransactionTotal = ReportContext.GetCreditCardTotalAmount();
//var ticketTransactionTotal = ReportContext.GetTicketTotalAmount();
//report.AddColumnLength("Kasa", "25*", "18*", "18*", "18*", "21*");
//report.AddColumTextAlignment("Kasa", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right, TextAlignment.Right, TextAlignment.Right);
//report.AddTable("Kasa", "Kasa", "Nakit", "K.Kartı", "Y.Çeki", "Toplam");
//report.AddRow("Kasa", "Gün Başı",
// currentPeriod.CashAmount.ToString(ReportContext.CurrencyFormat),
// currentPeriod.CreditCardAmount.ToString(ReportContext.CurrencyFormat),
// currentPeriod.TicketAmount.ToString(ReportContext.CurrencyFormat),
// (currentPeriod.CashAmount + currentPeriod.CreditCardAmount + currentPeriod.TicketAmount).ToString(ReportContext.CurrencyFormat));
//report.AddRow("Kasa", "Faaliyet",
// ac.CashTotal.ToString(ReportContext.CurrencyFormat),
// ac.CreditCardTotal.ToString(ReportContext.CurrencyFormat),
// ac.TicketTotal.ToString(ReportContext.CurrencyFormat),
// ac.GrandTotal.ToString(ReportContext.CurrencyFormat));
//report.AddRow("Kasa", "Hareketler",
// cashTransactionTotal.ToString(ReportContext.CurrencyFormat),
// creditCardTransactionTotal.ToString(ReportContext.CurrencyFormat),
// ticketTransactionTotal.ToString(ReportContext.CurrencyFormat),
// (cashTransactionTotal + creditCardTransactionTotal + ticketTransactionTotal).ToString(ReportContext.CurrencyFormat));
//var totalCash = currentPeriod.CashAmount + ac.CashTotal + cashTransactionTotal;
//var totalCreditCard = currentPeriod.CreditCardAmount + ac.CreditCardTotal + creditCardTransactionTotal;
//var totalTicket = currentPeriod.TicketAmount + ac.TicketTotal + ticketTransactionTotal;
//report.AddRow("Kasa", "TOPLAM",
// totalCash.ToString(ReportContext.CurrencyFormat),
// totalCreditCard.ToString(ReportContext.CurrencyFormat),
// totalTicket.ToString(ReportContext.CurrencyFormat),
// (totalCash + totalCreditCard + totalTicket).ToString(ReportContext.CurrencyFormat));
//---------------
var propertySum = ReportContext.Tickets
.SelectMany(x => x.TicketItems)
.Sum(x => x.GetPropertyPrice() * x.Quantity);
var voids = ReportContext.Tickets
.SelectMany(x => x.TicketItems)
.Where(x => x.Voided)
.Sum(x => x.GetItemValue());
var discounts = ReportContext.Tickets
.SelectMany(x => x.Discounts)
.Sum(x => x.DiscountAmount);
var gifts = ReportContext.Tickets
.SelectMany(x => x.TicketItems)
.Where(x => x.Gifted)
.Sum(x => x.GetItemValue());
report.AddColumTextAlignment("Bilgi", TextAlignment.Left, TextAlignment.Right);
report.AddColumnLength("Bilgi", "65*", "35*");
report.AddTable("Bilgi", Resources.GeneralInformation, "");
report.AddRow("Bilgi", Resources.ItemProperties, propertySum.ToString(ReportContext.CurrencyFormat));
report.AddRow("Bilgi", Resources.VoidsTotal, voids.ToString(ReportContext.CurrencyFormat));
report.AddRow("Bilgi", Resources.DiscountsTotal, discounts.ToString(ReportContext.CurrencyFormat));
report.AddRow("Bilgi", Resources.GiftsTotal, gifts.ToString(ReportContext.CurrencyFormat));
if (ticketGropus.Count() > 1)
{
foreach (var departmentInfo in ticketGropus)
{
report.AddRow("Bilgi", departmentInfo.DepartmentName, departmentInfo.TicketCount);
}
}
var ticketCount = ticketGropus.Sum(x => x.TicketCount);
report.AddRow("Bilgi", Resources.TicketCount, ticketCount);
report.AddRow("Bilgi", Resources.SalesDivTicket, ticketCount > 0
? (ticketGropus.Sum(x => x.Amount) / ticketGropus.Sum(x => x.TicketCount)).ToString(ReportContext.CurrencyFormat)
: "0");
if (ticketGropus.Count() > 1)
{
foreach (var departmentInfo in ticketGropus)
{
var dPayments = ReportContext.Tickets
.SelectMany(x => x.Payments)
.Where(x => x.DepartmentId == departmentInfo.DepartmentId)
.GroupBy(x => new { x.PaymentType })
.Select(x => new TenderedAmount {
PaymentType = x.Key.PaymentType, Amount = x.Sum(y => y.Amount)
});
report.AddColumnLength(departmentInfo.DepartmentName + Resources.Incomes, "40*", "Auto", "35*");
report.AddColumTextAlignment(departmentInfo.DepartmentName + Resources.Incomes, TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddTable(departmentInfo.DepartmentName + Resources.Incomes, string.Format(Resources.Incomes_f, departmentInfo.DepartmentName), "", "");
report.AddRow(departmentInfo.DepartmentName + Resources.Incomes, Resources.Cash, GetPercent(0, dPayments), GetAmount(0, dPayments).ToString(ReportContext.CurrencyFormat));
report.AddRow(departmentInfo.DepartmentName + Resources.Incomes, Resources.CreditCard, GetPercent(1, dPayments), GetAmount(1, dPayments).ToString(ReportContext.CurrencyFormat));
report.AddRow(departmentInfo.DepartmentName + Resources.Incomes, Resources.Voucher, GetPercent(2, dPayments), GetAmount(2, dPayments).ToString(ReportContext.CurrencyFormat));
report.AddRow(departmentInfo.DepartmentName + Resources.Incomes, Resources.AccountBalance, GetPercent(3, dPayments), GetAmount(3, dPayments).ToString(ReportContext.CurrencyFormat));
report.AddRow(departmentInfo.DepartmentName + Resources.Incomes, Resources.TotalIncome, "", dPayments.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat));
var dvoids = ReportContext.Tickets
.SelectMany(x => x.TicketItems)
.Where(x => x.Voided && x.DepartmentId == departmentInfo.DepartmentId)
.Sum(x => x.GetItemValue());
var ddiscounts = ReportContext.Tickets
.Where(x => x.DepartmentId == departmentInfo.DepartmentId)
.SelectMany(x => x.Discounts)
.Sum(x => x.DiscountAmount);
var dgifts = ReportContext.Tickets
.SelectMany(x => x.TicketItems)
.Where(x => x.Gifted && x.DepartmentId == departmentInfo.DepartmentId)
.Sum(x => x.GetItemValue());
report.AddRow(departmentInfo.DepartmentName + Resources.Incomes, Resources.VoidsTotal, "", dvoids.ToString(ReportContext.CurrencyFormat));
report.AddRow(departmentInfo.DepartmentName + Resources.Incomes, Resources.DiscountsTotal, "", ddiscounts.ToString(ReportContext.CurrencyFormat));
report.AddRow(departmentInfo.DepartmentName + Resources.Incomes, Resources.GiftsTotal, "", dgifts.ToString(ReportContext.CurrencyFormat));
}
}
//--
if (ReportContext.Tickets.Select(x => x.GetTagData()).Where(x => !string.IsNullOrEmpty(x)).Distinct().Count() > 0)
{
var dict = new Dictionary <string, List <Ticket> >();
foreach (var ticket in ReportContext.Tickets.Where(x => !string.IsNullOrEmpty(x.Tag)))
{
var tags = ticket.Tag.Split(new[] { '\r' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var tag in tags)
{
if (!dict.ContainsKey(tag))
{
dict.Add(tag, new List <Ticket>());
}
dict[tag].Add(ticket);
}
}
var tagGroups = dict.Select(x => new TicketTagInfo {
Amount = x.Value.Sum(y => y.GetSumWithoutTax()), TicketCount = x.Value.Count, TagName = x.Key
}).OrderBy(x => x.TagName);
var tagGrp = tagGroups.GroupBy(x => x.TagName.Split(':')[0])
.Where(x => ReportContext.TicketTagGroups.SingleOrDefault(y => y.Name == x.Key) != null);
if (tagGrp.Count() > 0)
{
report.AddColumTextAlignment("Etiket", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddColumnLength("Etiket", "45*", "Auto", "35*");
report.AddTable("Etiket", Resources.TicketTags, "", "");
}
foreach (var grp in tagGrp)
{
var tag = ReportContext.TicketTagGroups.SingleOrDefault(x => x.Name == grp.Key);
if (tag == null || tag.ExcludeInReports)
{
continue;
}
report.AddBoldRow("Etiket", grp.Key, "", "");
if (tag.PriceTags)
{
var tCount = grp.Sum(x => x.TicketCount);
var tSum = grp.Sum(x => Convert.ToDecimal(x.TagName.Split(':')[1]) * x.TicketCount);
var amnt = grp.Sum(x => x.Amount);
var rate = tSum / amnt;
report.AddRow("Etiket", string.Format(Resources.TotalAmount_f, tag.Name), "", tSum.ToString(ReportContext.CurrencyFormat));
report.AddRow("Etiket", Resources.TicketCount, "", tCount);
report.AddRow("Etiket", Resources.TicketTotal, "", amnt.ToString(ReportContext.CurrencyFormat));
report.AddRow("Etiket", Resources.Rate, "", rate.ToString("%#0.##"));
continue;
}
foreach (var ticketTagInfo in grp)
{
report.AddRow("Etiket",
ticketTagInfo.TagName.Split(':')[1],
ticketTagInfo.TicketCount,
ticketTagInfo.Amount.ToString(ReportContext.CurrencyFormat));
}
var totalAmount = grp.Sum(x => x.Amount);
report.AddRow("Etiket", string.Format(Resources.TotalAmount_f, tag.Name), "", totalAmount.ToString(ReportContext.CurrencyFormat));
var sum = 0m;
if (tag.NumericTags)
{
try
{
sum = grp.Sum(x => Convert.ToDecimal(x.TagName.Split(':')[1]) * x.TicketCount);
report.AddRow("Etiket", string.Format(Resources.TicketTotal_f, tag.Name), "", sum.ToString("#,##.##"));
}
catch (FormatException)
{
report.AddRow("Etiket", string.Format(Resources.TicketTotal_f, tag.Name), "", "#Hata!");
}
}
else
{
sum = grp.Sum(x => x.TicketCount);
}
if (sum > 0)
{
var average = totalAmount / sum;
report.AddRow("Etiket", string.Format(Resources.TotalAmountDivTag_f, tag.Name), "", average.ToString(ReportContext.CurrencyFormat));
}
}
}
//----
var owners = ReportContext.Tickets.SelectMany(ticket => ticket.TicketItems.Select(ticketItem => new { Ticket = ticket, TicketItem = ticketItem }))
.GroupBy(x => new { x.TicketItem.CreatingUserId })
.Select(x => new UserInfo {
UserId = x.Key.CreatingUserId, Amount = x.Sum(y => MenuGroupBuilder.CalculateTicketItemTotal(y.Ticket, y.TicketItem))
});
report.AddColumTextAlignment("Garson", TextAlignment.Left, TextAlignment.Right);
report.AddColumnLength("Garson", "65*", "35*");
report.AddTable("Garson", Resources.UserSales, "");
foreach (var ownerInfo in owners)
{
report.AddRow("Garson", ownerInfo.UserName, ownerInfo.Amount.ToString(ReportContext.CurrencyFormat));
}
//---
var uInfo = ReportContext.Tickets.SelectMany(x => x.Payments).Select(x => x.UserId).Distinct().Select(
x => new UserInfo {
UserId = x
});
if (uInfo.Count() > 1)
{
foreach (var userInfo in uInfo)
{
var info = userInfo;
var uPayments = ReportContext.Tickets
.SelectMany(x => x.Payments)
.Where(x => x.UserId == info.UserId)
.GroupBy(x => new { x.PaymentType })
.Select(x => new TenderedAmount {
PaymentType = x.Key.PaymentType, Amount = x.Sum(y => y.Amount)
});
report.AddColumnLength(userInfo.UserName + Resources.Incomes, "40*", "Auto", "35*");
report.AddColumTextAlignment(userInfo.UserName + Resources.Incomes, TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddTable(userInfo.UserName + Resources.Incomes, string.Format(Resources.ReceivedBy_f, userInfo.UserName), "", "");
report.AddRow(userInfo.UserName + Resources.Incomes, Resources.Cash, GetPercent(0, uPayments), GetAmount(0, uPayments).ToString(ReportContext.CurrencyFormat));
report.AddRow(userInfo.UserName + Resources.Incomes, Resources.CreditCard, GetPercent(1, uPayments), GetAmount(1, uPayments).ToString(ReportContext.CurrencyFormat));
report.AddRow(userInfo.UserName + Resources.Incomes, Resources.Voucher, GetPercent(2, uPayments), GetAmount(2, uPayments).ToString(ReportContext.CurrencyFormat));
report.AddRow(userInfo.UserName + Resources.Incomes, Resources.AccountBalance, GetPercent(3, uPayments), GetAmount(3, uPayments).ToString(ReportContext.CurrencyFormat));
report.AddRow(userInfo.UserName + Resources.Incomes, Resources.Total, "", uPayments.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat));
}
}
//---
var menuGroups = MenuGroupBuilder.CalculateMenuGroups(ReportContext.Tickets, ReportContext.MenuItems);
report.AddColumTextAlignment("Gıda", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddColumnLength("Gıda", "45*", "Auto", "35*");
report.AddTable("Gıda", Resources.ItemSales, "", "");
foreach (var menuItemInfo in menuGroups)
{
report.AddRow("Gıda", menuItemInfo.GroupName,
string.Format("%{0:0.00}", menuItemInfo.Rate),
menuItemInfo.Amount.ToString(ReportContext.CurrencyFormat));
}
report.AddRow("Gıda", Resources.Total.ToUpper(), "", menuGroups.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat));
return(report.Document);
}
protected override FlowDocument GetReport()
{
var currentPeriod = ReportContext.CurrentWorkPeriod;
var report = new SimpleReport("8cm");
AddDefaultReportHeader(report, currentPeriod, Resources.WorkPeriodReport);
//---------------
CreateTicketTypeInfo(report, ReportContext.Tickets.Where(x => x.TotalAmount >= 0), Resources.Sales);
var refundTickets = ReportContext.Tickets.Where(x => x.TotalAmount < 0).ToList();
if (refundTickets.Any())
{
CreateTicketTypeInfo(report, refundTickets, "Returns");
}
//---------------
var incomeCalculator = ReportContext.GetIncomeCalculator();
report.AddColumnLength("GelirlerTablosu", "45*", "Auto", "35*");
report.AddColumTextAlignment("GelirlerTablosu", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddTable("GelirlerTablosu", Resources.Incomes, "", "");
foreach (var paymentName in incomeCalculator.PaymentNames)
{
report.AddRow("GelirlerTablosu", paymentName, incomeCalculator.GetPercent(paymentName), incomeCalculator.GetAmount(paymentName).ToString(ReportContext.CurrencyFormat));
}
report.AddRow("GelirlerTablosu", Resources.TotalIncome.ToUpper(), "", incomeCalculator.TotalAmount.ToString(ReportContext.CurrencyFormat));
//---------------
var refundCalculator = ReportContext.GetRefundCalculator();
if (refundCalculator.TotalAmount != 0)
{
report.AddColumnLength("İadeTablosu", "45*", "Auto", "35*");
report.AddColumTextAlignment("İadeTablosu", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddTable("İadeTablosu", "Refunds", "", "");
foreach (var paymentName in refundCalculator.PaymentNames)
{
report.AddRow("İadeTablosu", paymentName, refundCalculator.GetPercent(paymentName),
refundCalculator.GetAmount(paymentName).ToString(ReportContext.CurrencyFormat));
}
report.AddRow("İadeTablosu", "TOTAL REFUND", "",
refundCalculator.TotalAmount.ToString(ReportContext.CurrencyFormat));
}
//---------------
var ticketGropus = ReportContext.Tickets
.GroupBy(x => new { x.TicketTypeId })
.Select(x => new TicketTypeInfo
{
TicketTypeId = x.Key.TicketTypeId,
TicketCount = x.Count(),
Amount = x.Sum(y => y.GetSum()),
Tax = x.Sum(y => y.CalculateTax(y.GetPlainSum(), y.GetPreTaxServicesTotal())),
Services = x.Sum(y => y.GetPostTaxServicesTotal())
}).ToList();
var propertySum = ReportContext.Tickets
.SelectMany(x => x.Orders)
.Sum(x => x.GetOrderTagPrice() * x.Quantity);
var discounts = Math.Abs(ReportContext.Tickets.Sum(x => x.GetPreTaxServicesTotal()));
report.AddColumTextAlignment("Bilgi", TextAlignment.Left, TextAlignment.Right);
report.AddColumnLength("Bilgi", "65*", "35*");
report.AddTable("Bilgi", Resources.GeneralInformation, "");
report.AddRow("Bilgi", Resources.ItemProperties, propertySum.ToString(ReportContext.CurrencyFormat));
report.AddRow("Bilgi", Resources.DiscountsTotal, discounts.ToString(ReportContext.CurrencyFormat));
if (ticketGropus.Count() > 1)
{
foreach (var ticketTypeInfo in ticketGropus)
{
report.AddRow("Bilgi", ticketTypeInfo.TicketTypeName, ticketTypeInfo.TicketCount.ToString());
}
}
report.AddBoldRow("Bilgi", Resources.Orders, "");
var orderCount = ReportContext.Tickets.Sum(x => x.Orders.Count);
report.AddRow("Bilgi", Resources.OrderCount, orderCount.ToString());
var orderStates = ReportContext.Tickets
.SelectMany(x => x.Orders)
.SelectMany(x => x.GetOrderStateValues()).Distinct().ToList();
if (orderStates.Any())
{
foreach (var orderStateValue in orderStates.Where(x => _cacheService.CanShowStateOnEndOfDayReport(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.AddRow("Bilgi", string.Format("{0} {1} ({2})", orderStateValue.State, orderStateValue.StateValue, count), amount.ToString(ReportContext.CurrencyFormat));
}
}
var ticketStates = ReportContext.Tickets
.SelectMany(x => x.GetTicketStateValues()).Distinct().ToList();
report.AddBoldRow("Bilgi", Resources.Tickets, "");
if (ticketStates.Any())
{
foreach (var ticketStateValue in ticketStates.Where(x => _cacheService.CanShowStateOnEndOfDayReport(x.StateName, x.State)))
{
TicketStateValue value = ticketStateValue;
var items = ReportContext.Tickets.Where(x => x.IsInState(value.StateName, value.State)).ToList();
var amount = items.Sum(x => x.GetSum());
var count = items.Count();
report.AddRow("Bilgi", string.Format("{0} ({1})", ticketStateValue.State, count), amount.ToString(ReportContext.CurrencyFormat));
}
}
var ticketCount = ticketGropus.Sum(x => x.TicketCount);
report.AddRow("Bilgi", Resources.TicketCount, ticketCount.ToString());
report.AddRow("Bilgi", Resources.SalesDivTicket, ticketCount > 0
? (ticketGropus.Sum(x => x.Amount) / ticketGropus.Sum(x => x.TicketCount)).ToString(ReportContext.CurrencyFormat)
: "0");
if (ticketGropus.Count() > 1)
{
foreach (var ticketTypeInfo in ticketGropus)
{
var dinfo = ticketTypeInfo;
var groups = ReportContext.Tickets
.Where(x => x.TicketTypeId == dinfo.TicketTypeId)
.SelectMany(x => x.Payments)
.GroupBy(x => new { x.Name })
.Select(x => new TenderedAmount {
PaymentName = x.Key.Name, Amount = x.Sum(y => y.Amount)
});
var ticketTypeAmountCalculator = new AmountCalculator(groups);
report.AddColumnLength(ticketTypeInfo.TicketTypeName + Resources.Incomes, "40*", "Auto", "35*");
report.AddColumTextAlignment(ticketTypeInfo.TicketTypeName + Resources.Incomes, TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddTable(ticketTypeInfo.TicketTypeName + Resources.Incomes, string.Format(Resources.Incomes_f, ticketTypeInfo.TicketTypeName), "", "");
foreach (var paymentName in ticketTypeAmountCalculator.PaymentNames)
{
report.AddRow(ticketTypeInfo.TicketTypeName + Resources.Incomes, paymentName, ticketTypeAmountCalculator.GetPercent(paymentName), ticketTypeAmountCalculator.GetAmount(paymentName).ToString(ReportContext.CurrencyFormat));
}
report.AddRow(ticketTypeInfo.TicketTypeName + Resources.Incomes, Resources.TotalIncome, "", ticketTypeInfo.Amount.ToString(ReportContext.CurrencyFormat));
var ddiscounts = ReportContext.Tickets
.Where(x => x.TicketTypeId == dinfo.TicketTypeId)
.Sum(x => x.GetPreTaxServicesTotal());
ddiscounts = Math.Abs(ddiscounts);
report.AddRow(ticketTypeInfo.TicketTypeName + Resources.Incomes, Resources.DiscountsTotal, "", ddiscounts.ToString(ReportContext.CurrencyFormat));
report.AddRow(ticketTypeInfo.TicketTypeName + Resources.Incomes, Resources.TaxAmount, "", ticketTypeInfo.Tax.ToString(ReportContext.CurrencyFormat));
}
}
//--
if (ReportContext.Tickets.Select(x => x.GetTagData()).Where(x => !string.IsNullOrEmpty(x)).Distinct().Any())
{
var dict = new Dictionary <string, List <Ticket> >();
foreach (var ticket in ReportContext.Tickets.Where(x => x.IsTagged))
{
foreach (var tag in ticket.GetTicketTagValues().Select(x => x.TagName + ":" + x.TagValue))
{
if (!dict.ContainsKey(tag))
{
dict.Add(tag, new List <Ticket>());
}
dict[tag].Add(ticket);
}
}
var tagGroups = dict.Select(x => new TicketTagInfo {
Amount = x.Value.Sum(y => y.GetPlainSum()), TicketCount = x.Value.Count, TagName = x.Key
}).OrderBy(x => x.TagName);
var tagGrp = tagGroups.GroupBy(x => x.TagName.Split(':')[0]).ToList();
if (tagGrp.Any())
{
report.AddColumTextAlignment("Etiket", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddColumnLength("Etiket", "45*", "Auto", "35*");
report.AddTable("Etiket", Resources.TicketTag.ToPlural(), "", "");
}
foreach (var grp in tagGrp)
{
var grouping = grp;
var tag = ReportContext.TicketTagGroups.SingleOrDefault(x => x.Name == grouping.Key);
if (tag == null)
{
continue;
}
report.AddBoldRow("Etiket", grp.Key, "", "");
if (tag.IsDecimal)
{
var tCount = grp.Sum(x => x.TicketCount);
var tSum = grp.Sum(x => Convert.ToDecimal(x.TagName.Split(':')[1]) * x.TicketCount);
var amnt = grp.Sum(x => x.Amount);
var rate = tSum / amnt;
report.AddRow("Etiket", string.Format(Resources.TotalAmount_f, tag.Name), "", tSum.ToString(ReportContext.CurrencyFormat));
report.AddRow("Etiket", Resources.TicketCount, "", tCount.ToString());
report.AddRow("Etiket", Resources.TicketTotal, "", amnt.ToString(ReportContext.CurrencyFormat));
report.AddRow("Etiket", Resources.Rate, "", rate.ToString("%#0.##"));
continue;
}
foreach (var ticketTagInfo in grp)
{
report.AddRow("Etiket",
ticketTagInfo.TagName.Split(':')[1],
ticketTagInfo.TicketCount.ToString(),
ticketTagInfo.Amount.ToString(ReportContext.CurrencyFormat));
}
var totalAmount = grp.Sum(x => x.Amount);
report.AddRow("Etiket", string.Format(Resources.TotalAmount_f, tag.Name), "", totalAmount.ToString(ReportContext.CurrencyFormat));
var sum = 0m;
if (tag.IsInteger)
{
try
{
sum = grp.Sum(x => Convert.ToDecimal(x.TagName.Split(':')[1]) * x.TicketCount);
report.AddRow("Etiket", string.Format(Resources.TicketTotal_f, tag.Name), "", sum.ToString("#,##.##"));
}
catch (FormatException)
{
report.AddRow("Etiket", string.Format(Resources.TicketTotal_f, tag.Name), "", "#Hata!");
}
}
else
{
sum = grp.Sum(x => x.TicketCount);
}
if (sum > 0)
{
var average = totalAmount / sum;
report.AddRow("Etiket", string.Format(Resources.TotalAmountDivTag_f, tag.Name), "", average.ToString(ReportContext.CurrencyFormat));
}
}
}
//----
var owners = ReportContext.Tickets.SelectMany(ticket => ticket.Orders.Where(x => !x.IncreaseInventory).Select(order => new { Ticket = ticket, Order = order }))
.GroupBy(x => new { x.Order.CreatingUserName })
.Select(x => new UserInfo {
UserName = x.Key.CreatingUserName, Amount = x.Sum(y => MenuGroupBuilder.CalculateOrderTotal(y.Ticket, y.Order))
}).ToList();
if (owners.Any())
{
report.AddColumTextAlignment("Garson", TextAlignment.Left, TextAlignment.Right);
report.AddColumnLength("Garson", "65*", "35*");
report.AddTable("Garson", Resources.UserSales, "");
}
foreach (var ownerInfo in owners)
{
report.AddRow("Garson", ownerInfo.UserName, ownerInfo.Amount.ToString(ReportContext.CurrencyFormat));
}
//----
var refundOwners = ReportContext.Tickets.SelectMany(ticket => ticket.Orders.Where(x => x.IncreaseInventory).Select(order => new { Ticket = ticket, Order = order }))
.GroupBy(x => new { x.Order.CreatingUserName })
.Select(x => new UserInfo {
UserName = x.Key.CreatingUserName, Amount = x.Sum(y => MenuGroupBuilder.CalculateOrderTotal(y.Ticket, y.Order))
}).ToList();
if (refundOwners.Any())
{
report.AddColumTextAlignment("Garsonİade", TextAlignment.Left, TextAlignment.Right);
report.AddColumnLength("Garsonİade", "65*", "35*");
report.AddTable("Garsonİade", "User Returns", "");
foreach (var ownerInfo in refundOwners)
{
report.AddRow("Garsonİade", ownerInfo.UserName,
ownerInfo.Amount.ToString(ReportContext.CurrencyFormat));
}
}
var uInfo = ReportContext.Tickets.SelectMany(x => x.Payments).Select(x => x.UserId).Distinct().Select(x => new UserInfo {
UserId = x, UserName = ReportContext.GetUserName(x)
}).ToList();
if (uInfo.Count() > 1)
{
foreach (var userInfo in uInfo)
{
var userIncomeCalculator = ReportContext.GetIncomeCalculatorByUser(userInfo.UserId);
report.AddColumnLength(userInfo.UserName + Resources.Incomes, "40*", "Auto", "35*");
report.AddColumTextAlignment(userInfo.UserName + Resources.Incomes, TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddTable(userInfo.UserName + Resources.Incomes, string.Format(Resources.SettledBy_f, userInfo.UserName), "", "");
foreach (var paymentName in userIncomeCalculator.PaymentNames)
{
report.AddRow(userInfo.UserName + Resources.Incomes, paymentName, userIncomeCalculator.GetPercent(paymentName), userIncomeCalculator.GetAmount(paymentName).ToString(ReportContext.CurrencyFormat));
}
report.AddRow(userInfo.UserName + Resources.Incomes, Resources.TotalIncome.ToUpper(), "", userIncomeCalculator.TotalAmount.ToString(ReportContext.CurrencyFormat));
}
}
var menuGroups = MenuGroupBuilder.CalculateMenuGroups(ReportContext.Tickets, ReportContext.MenuItems).ToList();
report.AddColumTextAlignment("Gıda", TextAlignment.Left, TextAlignment.Right, TextAlignment.Right);
report.AddColumnLength("Gıda", "45*", "Auto", "35*");
report.AddTable("Gıda", Resources.ItemSales, "", "");
foreach (var menuItemInfo in menuGroups)
{
report.AddRow("Gıda", menuItemInfo.GroupName,
string.Format("%{0:0.00}", menuItemInfo.Rate),
menuItemInfo.Amount.ToString(ReportContext.CurrencyFormat));
}
report.AddRow("Gıda", Resources.Total.ToUpper(), "", menuGroups.Sum(x => x.Amount).ToString(ReportContext.CurrencyFormat));
return(report.Document);
}
protected override FlowDocument GetReport()
{
var report = new SimpleReport("8cm");
AddDefaultReportHeader(report, ReportContext.CurrentWorkPeriod, Resources.ItemSalesReport);
var menuGroups = MenuGroupBuilder.CalculateMenuGroups(ReportContext.Tickets, ReportContext.MenuItems);
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)
{
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)
{
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));
}
report.AddRow("ÜrünTablosu", Resources.Total, "", menuItems.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 properties = ReportContext.Tickets
.SelectMany(x => x.TicketItems.Where(y => y.Properties.Count > 0))
.SelectMany(x => x.Properties.Where(y => y.MenuItemId == 0).Select(y => new { y.Name, x.Quantity }))
.GroupBy(x => new { x.Name })
.Select(x => new { x.Key.Name, Quantity = x.Sum(y => y.Quantity) });
if (properties.Count() > 0)
{
report.AddColumTextAlignment("ÖzelliklerTablosu", TextAlignment.Left, TextAlignment.Right);
report.AddColumnLength("ÖzelliklerTablosu", "60*", "40*");
report.AddTable("ÖzelliklerTablosu", Resources.Properties, "");
foreach (var property in properties.OrderByDescending(x => x.Quantity))
{
report.AddRow("ÖzelliklerTablosu", property.Name, property.Quantity.ToString("#.##"));
}
}
return(report.Document);
}
