/// <summary>
/// Finds and reports specific products in all existing backorders.
/// </summary>
/// <param name="ProductNumber">Product number to find.</param>
public static void DumpData(int ProductNumber)
{
List <BackorderedItemExportHelper> ExportData = new List <BackorderedItemExportHelper>();
foreach (var C in Util.CustomerDictionary.Values)
{
foreach (var I in C.Invoices.Values.Where(x => x.BackorderedItems.Select(xx => xx.ItemNumber).Contains(ProductNumber)))
{
IEnumerable <BackorderedItem> Items;
if ((Items = I.BackorderedItems.Where(x => x.ItemNumber == ProductNumber)).Any())
{
foreach (var B in Items)
{
ExportData.Add(new BackorderedItemExportHelper(C, I, B));
}
}
}
}
List <int> Prioritized = new List <int>();
var Priority = Util.InvoicePriorities.Where(x => ExportData.Select(x1 => x1.I.InvoiceNumber).Contains(x.Key)).ToDictionary(x => x.Key, x => x.Value);
Prioritized = Priority.Select(x => x.Key).ToList();
if (ExportData.Any())
{
using (StreamWriter sw = new StreamWriter(Paths.ExportGenericData))
{
sw.WriteLine($"\t{(ProductAllocationModel.ProductNumber(ProductNumber))} was found in {ExportData.Count} backorder{(ExportData.Count != 1 ? "s" : "")}.");
sw.WriteLine();
ExportData.OrderByDescending(x => x.I.OrderDate).ThenByDescending(x => x.I.InvoiceNumber).ToList().ForEach(item =>
{
var TempPriority = Priority.Where(x => x.Value > item.I.OrderDate).ToDictionary(x => x.Key, x => x.Value);
foreach (var TP in TempPriority)
{
var ExData = ExportData.Find(x => x.I.InvoiceNumber == TP.Key);
if (ExData != null)
{
sw.WriteLine(ExData.ToString() + $" * {TP.Value:MM/dd/yyyy}");
}
Priority.Remove(TP.Key);
}
if (!Prioritized.Contains(item.I.InvoiceNumber))
{
sw.WriteLine(item.ToString());
}
});
foreach (var TP in Priority.OrderByDescending(x => x.Value))
{
var ExData = ExportData.Find(x => x.I.InvoiceNumber == TP.Key);
if (ExData != null)
{
sw.WriteLine(ExData.ToString() + $" * {TP.Value:MM/dd/yyyy}");
}
}
sw.WriteLine($" Total:{Util.Pad(Side.Left, 8, ExportData.Sum(x => x.B.QuantityOnBackOrder).ToString())}");
}
}
Process.Start(new ProcessStartInfo(Paths.ExportGenericData));
}
/// <summary>
/// Exports data on each product calculating what is actually on the shelf and available.
/// </summary>
/// <param name="ProductAllocation">Model must be prepopulated with data.</param>
public static void DumpActual(ProductAllocationModel ProductAllocation)
{
if (ProductAllocation.AllocatedItems.Any())
{
using (StreamWriter sw = new StreamWriter(Paths.ExportActualOnHand))
ProductAllocation.AllocatedItems.OrderBy(x => x.Key).ToList().ForEach(Prods => { sw.WriteLine("{0}{1}", Prods.Key, Prods.Value.ActualOnHand); });
}
List <Invoice> AllInvoices = Customer.ExtractInvoices(Util.CustomerDictionary);
ProductAllocationModel ExportOrderAllocation =
new ProductAllocationModel(
AllInvoices,
Customer.ExtractInvoices(Util.CustomerDictionary.Where(x => x.Key.StartsWith("E")).Select(x => x.Value)));
ProductAllocationModel DomOrderAllocation =
new ProductAllocationModel(
AllInvoices,
Customer.ExtractInvoices(Util.CustomerDictionary.Where(x => !x.Key.StartsWith("E")).Select(x => x.Value)));
using (StreamWriter sw = new StreamWriter(Paths.ExportTotalBackOrdered))
{
sw.WriteLine(ProductAllocation.TotalBackorderedItems);
sw.WriteLine(ProductAllocation.TotalValueOfBackOrders);
//double ExpBkoVal = 0;
//foreach (KeyValuePair<int, int> item in ExportOrderAllocation.CannotShip)
//{
// ExpBkoVal += Util.ProductDictionary.ContainsKey(ProductAllocationModel.ProductNumber(item.Key)) ? (Util.ProductDictionary[ProductAllocationModel.ProductNumber(item.Key)].ListPrice * item.Value) * 0.5 : 0;
//}
sw.WriteLine(ExportOrderAllocation.CannotShip.Sum(x => (Util.ProductDictionary[ProductAllocationModel.ProductNumber(x.Key)].ListPrice * x.Value) * 0.5));
sw.WriteLine(ExportOrderAllocation.TotalValueOfShippable);
//double DomBkoVal = 0;
//foreach (KeyValuePair<int, int> item in DomOrderAllocation.CannotShip)
//{
// DomBkoVal += Util.ProductDictionary.ContainsKey(ProductAllocationModel.ProductNumber(item.Key)) ? (Util.ProductDictionary[ProductAllocationModel.ProductNumber(item.Key)].ListPrice * item.Value) * 0.5 : 0;
//}
sw.WriteLine(DomOrderAllocation.CannotShip.Sum(x => (Util.ProductDictionary[ProductAllocationModel.ProductNumber(x.Key)].ListPrice * x.Value) * 0.5));
sw.WriteLine(DomOrderAllocation.TotalValueOfShippable);
}
using (StreamWriter sw = new StreamWriter(Paths.BackOrderedShipdate))
{
for (int i = 1; i <= Util.Products.Max(x => x.Id); i++)
{
DateTime ShipDate = DateTime.Now;
double Days = 0;
if (ProductAllocation.CannotShip.ContainsKey(i))
{
Days = Math.Round((((ProductAllocation.CannotShip[i] * Util.ProductDictionary[ProductAllocationModel.ProductNumber(i)].AssemblyTime) / 3600) / 8) + 0.5, 0, MidpointRounding.AwayFromZero);
}
while (Days > 0)
{
ShipDate = ShipDate.AddDays(1);
while (ShipDate.DayOfWeek == DayOfWeek.Sunday || ShipDate.DayOfWeek == DayOfWeek.Saturday)
{
ShipDate = ShipDate.AddDays(1);
}
Days--;
}
sw.WriteLine($"{i + 90000}{(ShipDate != DateTime.Now ? ShipDate.ToString("MM/dd/yyyy") : "now")}");
}
}
}
/// <summary>
/// Parses and sorts backorders, exports to html or csv depending on report type, filtered by Jobber Customer Code.
/// </summary>
/// <param name="ReportType">1-5 valid; 1-4 exports to html, 5 to csv.</param>
/// <param name="CustomerCode">Customer code from jobbber, to filter what is shown in report.</param>
/// <param name="PublicFields">Dictates whether or not certain fields are displayed.</param>
public static void DumpData(string ReportType, string CustomerCode, bool PublicFields = false)
{
int TotalItems = 0, ShownBackorders = 0, Cols = 8;
List <Invoice> AllInvoices = Customer.ExtractInvoices(Util.CustomerDictionary);
ProductAllocationModel ProductAllocation = new ProductAllocationModel(AllInvoices);
string ExportFile = ReportType != "5" ? Paths.ExportBackorderHtml : Paths.ExportBackorderCsv;
using (StreamWriter sw = new StreamWriter(ExportFile))
{
if (ReportType != "5")
{
sw.WriteLine("<!DOCTYPE html>\n<html xmlns=\"http://www.w3.org/1999/xhtml\" lang=\"en\" dir=\"ltr\" dark=\"true\">\n" +
"<head>\n<meta content=\"text/html;charset=utf-8\" http-equiv=\"Content-Type\"><meta content=\"utf-8\" http-equiv=\"encoding\">\n" +
$"<style>{Util.CSS}</style>\n" +
$"<script type=\"text/javascript\">{Util.Script}</script>\n" +
"</head>\n" +
"<body>\n");
sw.WriteLine("<table>\n<tbody>");
}
foreach (KeyValuePair <string, Customer> C in (string.IsNullOrEmpty(CustomerCode) ? Util.CustomerDictionary : Util.CustomerDictionary.Where(x => x.Key.ToUpper() == CustomerCode.ToUpper())))
{
var TempInvoiceList = AllInvoices.Where(x => C.Value.Invoices.Select(xx => xx.Key).Contains(x.InvoiceNumber)).ToList();
Dictionary <int, Invoice> ValidInvoices = new Dictionary <int, Invoice>();
(ReportType == "1" ? TempInvoiceList.Where(x => x.BackorderedItems.Where(xx => xx.QuantityAllocatable > 0 || ProductAllocation.AllocatedItems[ProductAllocationModel.ProductNumber(xx.ItemNumber)].ActualOnHand < 0).Any()) :
ReportType == "2" ? TempInvoiceList.Where(x => x.BackorderedItems.Where(xx => xx.QuantityAllocatable < xx.QuantityOnBackOrder).Any()) :
TempInvoiceList).ToList().ForEach(item =>
{
if (!ValidInvoices.ContainsKey(item.InvoiceNumber))
{
ValidInvoices.Add(item.InvoiceNumber, item);
}
});
if (ValidInvoices.Any())
{
int BackorderIndex = 1;
double CanShipSum = 0, TotalSum = 0;
if (ReportType == "5")
{
sw.WriteLine("Customer: {0} => {1} Backordered invoice{2}", C.Value.CustomerCode, ValidInvoices.Count, ValidInvoices.Count > 1 ? "s" : "");
sw.WriteLine("\t{0}", C.Value.CustomerInfo.First());
}
else
{
sw.WriteLine("<tr><td colspan=\"" + Cols + "\">Customer: {0} => {1} Backordered invoice{2}<br>", C.Value.CustomerCode, ValidInvoices.Count, ValidInvoices.Count > 1 ? "s" : "");
sw.WriteLine("{0}<br>", C.Value.CustomerInfo.First());
sw.WriteLine("</td></tr>" +
"<tr><td colspan=\"" + Cols + "\">To be packed by:<span class=\"editable\" data-oval=\"Employee\" ondblclick=\"input_text_insert(this)\">Employee</span></td></tr>");
}
if (ReportType == "4")
{
sw.WriteLine("<tr>\n" +
"<td></td>\n" +
"<td>Invoice #</td>\n" +
"<td>PO# - Order Date</td>\n" +
"<td>Discount</td>\n" +
"<td># Backordered Item(s)</td>\n" +
"<td colspan=\"" + (Cols - 7) + "\">Shippable<span class=\"f-right\"></span></td>\n" +
"<td colspan=\"" + (Cols - 6) + "\">Total:<span class=\"f-right\"><span></td>\n" +
"</tr>\n");
}
foreach (KeyValuePair <int, Invoice> I in ValidInvoices.OrderBy(x => x.Value.OrderDate).ThenBy(x => x.Value.InvoiceNumber))
{
DateTime?EstimatedShip = null;
if (I.Value.OrderDate.HasValue && Util.EDS.ContainsKey(I.Value.OrderDate.Value.Date))
{
EstimatedShip = DateTime.Now.AddDays(Util.InvoicePriorities.ContainsKey(I.Value.InvoiceNumber) ? Util.EDS[Util.InvoicePriorities[I.Value.InvoiceNumber]] : Util.EDS[I.Value.OrderDate.Value.Date] < 0 ? Util.EDS[I.Value.OrderDate.Value.Date] * -1 : 0);
}
int Count = 0;
if (ReportType == "4")
{
double CanShipVal = I.Value.BackorderedItems
.Where(xx => xx.QuantityAllocatable > 0 || ProductAllocation.AllocatedItems[ProductAllocationModel.ProductNumber(xx.ItemNumber)].ActualOnHand < 0)
.Sum(x => x.QuantityAllocatable * (Util.ProductDictionary[ProductAllocationModel.ProductNumber(x.ItemNumber)].ListPrice * 0.5));
double TotalBackOrderVal = I.Value.BackorderedItems.Sum(x => x.QuantityOnBackOrder * (Util.ProductDictionary[ProductAllocationModel.ProductNumber(x.ItemNumber)].ListPrice * 0.5));
sw.WriteLine("<tr><td>#{6}</td><td>{0}</td><td>{1} - {2}</td><td>{3}%</td><td>{4}</td><td colspan=\"" + (Cols - 7) + "\"><span class=\"f-right\">{7}</span></td><td colspan=\"" + (Cols - 6) + "\"><span class=\"f-right\">{8}<span></td></tr>",
I.Key,
I.Value.PurchaseOrderNumber,
I.Value.OrderDate.HasValue ? I.Value.OrderDate.Value.ToString("MM/dd/yyyy") : I.Value.OrderDateRaw,
I.Value.Discount,
I.Value.BackorderedItems.Count.ToString(),
(I.Value.BackorderedItems.Count > 1 ? "s" : " "),
BackorderIndex.ToString(),
CanShipVal.ToString("C"),
TotalBackOrderVal.ToString("C"));
sw.WriteLine("</td></tr>");
CanShipSum += CanShipVal;
TotalSum += TotalBackOrderVal;
BackorderIndex++;
}
else if (ReportType == "5")
{
sw.WriteLine();
sw.WriteLine("#{6},Invoice #:{0},PO#:{1},{2},Discount {3}%,{4} Backordered Item{5},Expected Completion Date: {7}",
I.Key,
I.Value.PurchaseOrderNumber,
I.Value.OrderDate.HasValue ? I.Value.OrderDate.Value.ToString("MM/dd/yyyy") : I.Value.OrderDateRaw,
I.Value.Discount,
I.Value.BackorderedItems.Count.ToString(),
(I.Value.BackorderedItems.Count > 1 ? "s" : " "),
BackorderIndex.ToString(),
EstimatedShip.HasValue ? EstimatedShip.Value.ToString("MM/dd/yyyy") : "Unknown");
sw.WriteLine("Item,Number,Description,Ordered,Fill Qty");
BackorderIndex++;
foreach (BackorderedItem B in I.Value.BackorderedItems)
{
//DateTime ShipDate = DateTime.Now;
int Allocated = ProductAllocation.AllocatedItems[ProductAllocationModel.ProductNumber(B.ItemNumber)].AllocatedOnOrder(B.InvoiceNumber);
#region Shipdate calculator, depracated
//if (Allocated < B.QuantityOnBackOrder)
//{
// var InvoicesBeforeCurrent = AllInvoices.Where(x => x.OrderDate <= (Util.InvoicePriorities.ContainsKey(I.Key) ? Util.InvoicePriorities[I.Key] : I.Value.OrderDate));
// int NeedToAssemble = InvoicesBeforeCurrent
// .Sum(x =>
// x.BackorderedItems
// .Where(x1 => x1.ItemNumber == B.ItemNumber)
// .Select(x2 => x2.QuantityOnBackOrder)
// .Sum() -
// x.BackorderedItems.Where(x1 => x1.ItemNumber == B.ItemNumber)
// .Select(x2 => x2.QuantityAllocatable)
// .Sum()
// );
// double Days = 0;
// if (NeedToAssemble > 0)
// {
// double seconds = (NeedToAssemble * Util.ProductDictionary[B.ItemNumber + 90000].AssemblyTime);
// //Util.Products.Where(x => x.RequiredProducts.ContainsKey(x.Number - 90000)).ToList().ForEach(item =>
// //{
// // seconds += GetSeconds(ValidInvoices, item.Number, (DateTime)I.Value.OrderDate);
// //});
// //foreach (var AttachedProduct in Util.ProductDictionary[B.ItemNumber + 90000].RequiredProducts)
// //{
// // seconds += (NeededToAssemble * Util.ProductDictionary[AttachedProduct.Key + 90000].AssemblyTime);
// // seconds += ValidInvoices
// // .Where(x => x.Value.OrderDate <= I.Value.OrderDate)
// // .Sum(x => x.Value.BackorderedItems.Where(x1 => x1.ItemNumber == B.ItemNumber).Select(x2 => x2.QuantityOnBackOrder).Sum() - x.Value.BackorderedItems.Where(x1 => x1.ItemNumber == B.ItemNumber).Select(x2 => x2.QuantityAllocatable).Sum())
// // * Util.ProductDictionary[AttachedProduct.Key + 90000].AssemblyTime;
// //}
// Days = Math.Round(((seconds / 3600) / 8) + 0.5, 0, MidpointRounding.AwayFromZero);
// while (Days > 0)
// {
// ShipDate = ShipDate.AddDays(1);
// while (ShipDate.DayOfWeek == DayOfWeek.Sunday || ShipDate.DayOfWeek == DayOfWeek.Saturday)
// ShipDate = ShipDate.AddDays(1);
// Days--;
// }
// }
//}
#endregion
sw.WriteLine("{0},{1},{2},{3},{4}",
Count,
ProductAllocationModel.ProductNumber(B.ItemNumber),
B.ItemName,
B.QuantityOnBackOrder.ToString(),
Allocated.ToString()
//,ShipDate == DateTime.Now ? " Now" : ShipDate.ToString("MM/dd/yyyy")
);
Count++;
}
}
else
{
//<span class=\"xs\"></span><span class=\"xs\"></span>
sw.WriteLine("</tbody><tbody class=\"inv-" + I.Key + "\"><tr class=\"no-vis\"><td colspan=\"" + Cols + "\"><br></td></tr>");
sw.WriteLine("<tr><td class=\"toggler\" onmouseup=\"this.parentElement.parentElement.classList.contains('no-print') ? this.parentElement.parentElement.classList.remove('no-print') : this.parentElement.parentElement.classList.add('no-print')\"></td><td>#{6}</td><td colspan=\"" + (Cols - 3) + "\">Invoice #:{0} PO#:{1} - {2}</td><td colspan=\"" + (Cols - 5) + "\">Discount {3}%</td></tr><tr><td colspan=\"" + (Cols - 4) + "\">{4} Backordered Item{5}<td colspan=\"" + (Cols - 3) + "\">Expected Completion Date: {7}</td>",
I.Key,
Util.Pad(Side.Right, 12, I.Value.PurchaseOrderNumber),
Util.Pad(Side.Right, 12, I.Value.OrderDate.HasValue ? I.Value.OrderDate.Value.ToString("MM/dd/yyyy") : I.Value.OrderDateRaw),
I.Value.Discount,
Util.Pad(Side.Left, 5, I.Value.BackorderedItems.Count.ToString()),
(I.Value.BackorderedItems.Count > 1 ? 's' : ' '),
Util.Pad(Side.Right, 4, BackorderIndex.ToString()),
EstimatedShip.HasValue ? EstimatedShip.Value.ToString("MM/dd/yyyy") : "Unknown");
sw.WriteLine("</tr><tr>");
sw.WriteLine("<td></td><td>Item</td><td>Number</td><td>Desc</td>{0}", (PublicFields ? "<td>AOnHand</td><td>Ordered</td><td class=\"fill-qty\">Fill Qty</td><td class=\"boxes\">Box #</td>" : "<td>Ordered</td><td colspan=\"" + (Cols - 4) + "\"></td>"));
sw.WriteLine("</tr>");
BackorderIndex++;
foreach (BackorderedItem B in I.Value.BackorderedItems.Where(xx => (ReportType == "1" ? ProductAllocation.AllocatedItems[ProductAllocationModel.ProductNumber(xx.ItemNumber)].AllocatedOnOrder(I.Value.InvoiceNumber) > 0 || ProductAllocation.AllocatedItems[ProductAllocationModel.ProductNumber(xx.ItemNumber)].ActualOnHand < 0 : ReportType == "2" ? xx.QuantityAllocatable < xx.QuantityOnBackOrder : ProductAllocation.AllocatedItems.Keys.Contains(ProductAllocationModel.ProductNumber(xx.ItemNumber)))))
{
sw.WriteLine(
"<tr><td class=\"toggler\" onmouseup=\"this.parentElement.classList.contains('no-print') ? this.parentElement.classList.remove('no-print') : this.parentElement.classList.add('no-print')\"></td><td>{0}</td><td>{1}</td><td>{2}</td><td class=\"right\">{3}</td>" +
(PublicFields ? "<td class=\"right\">{4}</td><td class=\"right fill-qty\" data-oval=\"{5}\"><span class=\"editable\" ondblclick=\"input_insert(this)\">{5}</span></td><td></td></tr>" : "<td colspan=\"" + (Cols - 4) + "\"></td></tr>"),
Count,
(90000 + B.ItemNumber).ToString(),
B.ItemName,
(PublicFields ? ProductAllocation.AllocatedItems[ProductAllocationModel.ProductNumber(B.ItemNumber)].ActualOnHand.ToString() : B.QuantityOnBackOrder.ToString()),
(PublicFields ? B.QuantityOnBackOrder.ToString() : string.Empty),
(PublicFields ? ProductAllocation.AllocatedItems[ProductAllocationModel.ProductNumber(B.ItemNumber)].AllocatedOnOrder(B.InvoiceNumber).ToString() : string.Empty));
Count++;
}
sw.WriteLine("</tbody>");
}
TotalItems += Count;
}
if (ReportType == "4")
{
sw.WriteLine($"<tr><td colspan=\"{Cols - 3}\"></td><td colspan=\"{Cols - 7}\"><span class=\"f-right\">{CanShipSum:C}</span></td><td colspan=\"{Cols - 6}\"><span class=\"f-right\">{TotalSum:C}</span></td></tr>");
}
ShownBackorders += BackorderIndex;
if (ReportType != "5")
{
sw.WriteLine("<tr><td class=\"no-vis\" colspan=\"" + Cols + "\"><br><br></td></tr>");
}
}
}
if (TotalItems == 0 && ShownBackorders == 0)
{
sw.WriteLine("Sorry! There aren't currently any backorders that can be filled with the given criteria.");
sw.WriteLine("Submit a request with no customer specified to see a full list of backorders that can be filled,");
sw.WriteLine("or run backorder report [9] which will show all current and open backorders.");
}
if (ReportType != "5")
{
sw.WriteLine("</table></body></html>");
}
}
Process.Start($"{ExportFile}");
DumpActual(ProductAllocation);
}