123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661 |
- using Comal.Classes;
- using InABox.Clients;
- using InABox.Core;
- using InABox.DynamicGrid;
- using InABox.Wpf;
- using InABox.WPF;
- using NPOI.SS.Formula.Functions;
- using Syncfusion.Data;
- using Syncfusion.Data.Extensions;
- using Syncfusion.UI.Xaml.Grid;
- using Syncfusion.Windows.Shared;
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows;
- using System.Windows.Controls;
- using System.Windows.Media;
- using System.Windows.Media.Imaging;
- using Columns = InABox.Core.Columns;
- namespace PRSDesktop.Panels.ReservationManagement.TreatmentPO;
- public class ReservationManagementTreatmentPOItem : BaseObject
- {
- public delegate void ChangedHandler(int idx, double quantity);
- public event ChangedHandler? Changed;
- public ProductLink TreatmentProduct { get; set; }
- public ProductStyleLink Finish { get; set; }
- public JobLink Job { get; set; }
- public ProductLink Product { get; set; }
- public ProductStyleLink Style { get; set; }
- public StockDimensions Dimensions { get; set; }
- public StockLocationLink Location { get; set; }
- public JobRequisitionItemLink JRI { get; set; }
- public double Multiplier { get; set; }
- [EditorSequence(4)]
- [DoubleEditor]
- public double RequiredQuantity { get; set; }
- private double[] Quantities = [];
- public double GetQuantity(int i) => Quantities[i];
- public void SetQuantity(int i, double quantity)
- {
- Quantities[i] = quantity;
- Changed?.Invoke(i, quantity);
- }
- public double GetTotalQuantity() => Quantities.Sum();
- public void SetQuantities(double[] quantities)
- {
- Quantities = quantities;
- }
- }
- public class StockForecastOrderingResult
- {
- public SupplierLink Supplier { get; set; }
- public ReservationManagementTreatmentPOItem Item { get; set; }
- public SupplierProduct SupplierProduct { get; set; }
- public double Quantity { get; set; }
- public StockForecastOrderingResult(SupplierLink supplier, ReservationManagementTreatmentPOItem item, double quantity, SupplierProduct supplierProduct)
- {
- Supplier = supplier;
- Item = item;
- Quantity = quantity;
- SupplierProduct = supplierProduct;
- }
- }
- public class ReservationManagementTreatmentOrderGrid: DynamicItemsListGrid<ReservationManagementTreatmentPOItem>, ISpecificGrid
- {
- private List<SupplierProduct> SupplierProducts = [];
- private SupplierLink[] Suppliers = [];
- public double TotalQuantity => Items.Sum(x => x.GetTotalQuantity());
- private DynamicActionColumn[] QuantityColumns = [];
- private DynamicActionColumn[] CostColumns = [];
- private readonly Dictionary<Guid, Job> JobDetails = [];
- private static BitmapImage _warning = PRSDesktop.Resources.warning.AsBitmapImage();
- public IEnumerable<StockForecastOrderingResult> Results
- {
- get
- {
- for(int i = 0; i < Suppliers.Length; ++i)
- {
- var supplier = Suppliers[i];
- foreach(var item in Items)
- {
- var qty = item.GetQuantity(i);
- if(qty == 0)
- {
- continue;
- }
- var supplierProduct = GetSupplierProduct(item, supplier.ID);
- if (supplierProduct is null)
- {
- continue;
- }
-
- yield return new(supplier, item, qty, supplierProduct);
- }
- }
- }
- }
- private DynamicGridCustomColumnsComponent<ReservationManagementTreatmentPOItem> ColumnsComponent;
- public ReservationManagementTreatmentOrderGrid()
- {
- HiddenColumns.Add(x => x.Product.Image.ID);
- ColumnsComponent = new(this, nameof(ReservationManagementTreatmentOrderGrid));
- }
- #region UI Component
- private Component? _uiComponent;
- private Component UIComponent
- {
- get
- {
- _uiComponent ??= new Component(this);
- return _uiComponent;
- }
- }
- protected override IDynamicGridUIComponent<ReservationManagementTreatmentPOItem> CreateUIComponent()
- {
- return UIComponent;
- }
- private class Component : DynamicGridGridUIComponent<ReservationManagementTreatmentPOItem>
- {
- private ReservationManagementTreatmentOrderGrid Grid;
- public Component(ReservationManagementTreatmentOrderGrid grid)
- {
- Parent = grid;
- Grid = grid;
- DataGrid.FrozenColumnCount = 9;
- }
- protected override Brush? GetCellSelectionBackgroundBrush()
- {
- return null;
- }
- protected override Brush? GetCellBackground(CoreRow row, DynamicColumnBase column)
- {
- var item = Grid.LoadItem(row);
- if(column is DynamicActionColumn ac)
- {
- var qIdx = Grid.QuantityColumns.IndexOf(ac);
- var idx = Math.Max(qIdx, Grid.CostColumns.IndexOf(ac));
- if(idx != -1)
- {
- var supplierProduct = Grid.GetSupplierProduct(item, Grid.Suppliers[idx].ID);
- if(supplierProduct is null)
- {
- return new SolidColorBrush(Colors.Gainsboro);
- }
- //if(item.GetTotalQuantity(Grid.OrderType) < item.RequiredQuantity)
- //{
- // return new SolidColorBrush(Colors.LightSalmon) { Opacity = 0.5 };
- //}
- //else
- //{
- // return new SolidColorBrush(Colors.LightGreen) { Opacity = 0.5 };
- //}
- }
- }
- return base.GetCellBackground(row, column);
- }
- }
- #endregion
- private bool _observing = true;
- private void SetObserving(bool observing)
- {
- _observing = observing;
- }
- protected override void Changed()
- {
- if (_observing)
- {
- base.Changed();
- }
- }
- protected override void DoReconfigure(DynamicGridOptions options)
- {
- options.Clear();
- options.FilterRows = true;
- }
- private bool _loadedData = false;
- private void LoadData()
- {
- var supplierColumns = Columns.None<SupplierProduct>().Add(x => x.ID)
- .Add(x => x.SupplierLink.ID)
- .Add(x => x.Job.ID)
- .Add(x => x.Product.ID)
- .Add(x => x.CostPrice)
- .Add(x => x.SupplierLink.Code)
- .Add(x => x.Product.TaxCode.ID)
- .Add(x => x.TaxCode.ID);
-
- SupplierProducts = Client.Query(
- new Filter<SupplierProduct>(x => x.Product.ID).InList(Items.Select(x => x.TreatmentProduct.ID).ToArray())
- .And(x => x.SupplierLink.ID).IsNotEqualTo(Guid.Empty),
- supplierColumns,
- new SortOrder<SupplierProduct>(x => x.SupplierLink.Code))
- .ToList<SupplierProduct>();
- Suppliers = SupplierProducts.Select(x => x.SupplierLink).DistinctBy(x => x.ID).ToArray();
- foreach(var (itemIdx, item) in Items.WithIndex())
- {
- var quantities = new double[Suppliers.Length];
- for(int i = 0; i < Suppliers.Length; ++i)
- {
- quantities[i] = 0;
- }
- item.SetQuantities(quantities);
- item.Changed += (i, qty) =>
- {
- if (!_observing) return;
- var row = Data.Rows[itemIdx];
- foreach(var ac in ActionColumns)
- {
- if(ac != QuantityColumns[i])
- {
- UpdateCell(row, ac);
- }
- }
- DoChanged();
- };
- }
- CalculateQuantities();
- _loadedData = true;
- }
- private void CalculateQuantities()
- {
- SetObserving(false);
- foreach(var item in Items)
- {
- var supplierProduct = GetSupplierProduct(item);
- for(int i = 0; i < Suppliers.Length; ++i)
- {
- var supplier = Suppliers[i];
- if(supplierProduct is not null && supplier.ID == supplierProduct.SupplierLink.ID)
- {
- item.SetQuantity(i, item.RequiredQuantity);
- }
- else
- {
- item.SetQuantity(i, 0);
- }
- }
- }
- SetObserving(true);
- DoChanged();
- InvalidateGrid();
- }
- protected override void SaveColumns(DynamicGridColumns columns)
- {
- ColumnsComponent.SaveColumns(columns);
- }
- protected override void LoadColumnsMenu(ContextMenu menu)
- {
- ColumnsComponent.LoadColumnsMenu(menu);
- }
- public override DynamicGridColumns GenerateColumns()
- {
- var columns = new DynamicGridColumns();
- columns.Add<ReservationManagementTreatmentPOItem, string>(x => x.Product.Code, 120, "Product", "", Alignment.MiddleCenter);
- columns.Add<ReservationManagementTreatmentPOItem, string>(x => x.Style.Code, 120, "Style", "", Alignment.MiddleCenter);
- //columns.Add<ReservationManagementTreatmentPOItem, string>(x => x.Location.Code, 80, "Location", "", Alignment.MiddleLeft);
- columns.Add<ReservationManagementTreatmentPOItem, string>(x => x.Dimensions.UnitSize, 80, "Size", "", Alignment.MiddleCenter);
- columns.Add<ReservationManagementTreatmentPOItem, string>(x => x.TreatmentProduct.Code, 120, "Finish", "", Alignment.MiddleCenter);
- columns.Add<ReservationManagementTreatmentPOItem, string>(x => x.TreatmentProduct.Name, 0, "Treatment Product", "", Alignment.MiddleCenter);
- columns.Add<ReservationManagementTreatmentPOItem, double>(x => x.RequiredQuantity, 80, "Required", "", Alignment.MiddleCenter);
- columns.Add<ReservationManagementTreatmentPOItem, double>(x => x.Multiplier, 80, "Multiplier", "", Alignment.MiddleCenter);
- return columns;
- }
- protected override DynamicGridColumns LoadColumns()
- {
- if (!_loadedData)
- {
- LoadData();
- }
- ActionColumns.Clear();
- ActionColumns.Add(new DynamicImageColumn(Warning_Image) { Position = DynamicActionColumnPosition.Start });
- ActionColumns.Add(new DynamicImagePreviewColumn<ReservationManagementTreatmentPOItem>(x => x.Product.Image) { Position = DynamicActionColumnPosition.Start });
- var columns = ColumnsComponent.LoadColumns();
- QuantityColumns = new DynamicActionColumn[Suppliers.Length];
- CostColumns = new DynamicActionColumn[Suppliers.Length];
- QuantityControls.Clear();
- for(int i = 0; i < Suppliers.Length; ++i)
- {
- InitialiseSupplierColumn(i);
- }
- ActionColumns.Add(new DynamicMenuColumn(BuildMenu));
- return columns;
- }
- private void EditSupplierProductGrid(DynamicGrid<SupplierProduct> grid)
- {
- grid.OnCustomiseEditor += (sender, items, column, editor) =>
- {
- if(new Column<SupplierProduct>(x => x.SupplierLink.ID).IsEqualTo(column.ColumnName)
- || new Column<SupplierProduct>(x => x.Product.ID).IsEqualTo(column.ColumnName)
- || new Column<SupplierProduct>(x => x.Style.ID).IsEqualTo(column.ColumnName)
- || new Column<SupplierProduct>(x => x.Job.ID).IsEqualTo(column.ColumnName)
- //|| new Column<SupplierProduct>(x => x.Dimensions).IsEqualTo(column.ColumnName)
- )
- {
- editor.Editable = editor.Editable.Combine(Editable.Disabled);
- }
- };
- }
- private void BuildMenu(DynamicMenuColumn column, CoreRow? row)
- {
- if (row is null) return;
- column.AddItem("New Supplier", null, row =>
- {
- if (row is null) return;
- var selection = new MultiSelectDialog<Supplier>(
- new Filter<Supplier>(x => x.ID).NotInList(Suppliers.Select(x => x.ID).ToArray()),
- Columns.None<Supplier>().Add(x => x.ID).Add(x => x.Code), multiselect: false);
- if (selection.ShowDialog() != true)
- {
- return;
- }
- var supplier = selection.Data().Rows.First().ToObject<Supplier>();
- var item = LoadItem(row);
- var supplierProduct = new SupplierProduct();
- LookupFactory.DoLookup<SupplierProduct, Product, ProductLink>(supplierProduct, x => x.Product, item.TreatmentProduct.ID);
- supplierProduct.SupplierLink.CopyFrom(supplier);
- if (DynamicGridUtils.EditEntity(supplierProduct, customiseGrid: EditSupplierProductGrid))
- {
- SupplierProducts.Add(supplierProduct);
- var newSuppliers = new SupplierLink[Suppliers.Length + 1];
- var newIdx = Suppliers.Length;
- for (int i = 0; i < Suppliers.Length; i++)
- {
- newSuppliers[i] = Suppliers[i];
- }
- newSuppliers[newIdx] = supplierProduct.SupplierLink;
- foreach (var (itemIdx, oItem) in Items.WithIndex())
- {
- var populateSupplierProduct = GetSupplierProduct(oItem);
- var quantities = new double[newSuppliers.Length];
- for (int i = 0; i < Suppliers.Length; ++i)
- {
- quantities[i] = oItem.GetQuantity(i);
- }
- quantities[newIdx] = 0;
- oItem.SetQuantities(quantities);
- }
- Suppliers = newSuppliers;
- Refresh(true, true);
- }
- });
- }
- private BitmapImage? Warning_Image(CoreRow? row)
- {
- if (row is null) return _warning;
- var item = LoadItem(row);
- if(item.GetTotalQuantity() < item.RequiredQuantity)
- {
- return _warning;
- }
- else
- {
- return null;
- }
- }
- protected override void ConfigureColumnGroups()
- {
- for(int idx = 0; idx < Suppliers.Length; ++idx)
- {
- GetColumnGrouping().AddGroup(Suppliers[idx].Code, QuantityColumns[idx], CostColumns[idx]);
- }
- }
- private class QuantityControl : ContentControl
- {
- private readonly ReservationManagementTreatmentPOItem Item;
- private readonly int SupplierIndex;
- private readonly ReservationManagementTreatmentOrderGrid Parent;
- public QuantityControl(ReservationManagementTreatmentOrderGrid parent, ReservationManagementTreatmentPOItem item, int supplierIndex)
- {
- Parent = parent;
- Item = item;
- SupplierIndex = supplierIndex;
- UpdateControl();
- }
- public void UpdateControl()
- {
- var supplierProduct = Parent.GetSupplierProduct(Item, Parent.Suppliers[SupplierIndex].ID);
- if(supplierProduct is null)
- {
- Content = null;
- return;
- }
- var editor = new DoubleTextBox
- {
- VerticalAlignment = VerticalAlignment.Stretch,
- HorizontalContentAlignment = HorizontalAlignment.Center,
- HorizontalAlignment = HorizontalAlignment.Stretch,
- Background = new SolidColorBrush(Colors.LightYellow),
- BorderThickness = new Thickness(0.0),
- MinValue = 0.0,
- Value = Item.GetQuantity(SupplierIndex)
- };
- editor.ValueChanged += (o, e) =>
- {
- var maxValue = Item.RequiredQuantity - (Item.GetTotalQuantity() - Item.GetQuantity(SupplierIndex));
- var value = (double?)e.NewValue ?? default;
- if(value > maxValue)
- {
- Dispatcher.BeginInvoke(() => editor.Value = maxValue);
- }
- else
- {
- Item.SetQuantity(SupplierIndex, value);
- }
- };
- Content = editor;
- }
- }
- private List<QuantityControl> QuantityControls = [];
- private void InitialiseSupplierColumn(int idx)
- {
- var supplierProducts = SupplierProducts.Where(x => x.SupplierLink.ID == Suppliers[idx].ID).ToArray();
- var contextMenuFunc = (CoreRow[]? rows) =>
- {
- var row = rows?.FirstOrDefault();
- if (row is null) return null;
- var item = LoadItem(row);
- var supplierProduct = GetSupplierProduct(item, Suppliers[idx].ID);
- if (supplierProduct is not null)
- {
- return null;
- }
- var menu = new ContextMenu();
- menu.AddItem("Create Supplier Product", null, new Tuple<ReservationManagementTreatmentPOItem, int>(item, idx), CreateSupplierProduct_Click);
- return menu;
- };
- // Making local copy of index so that the lambda can use it, and not the changed value of 'i'.
- var qtyColumn = new Tuple<DynamicActionColumn, QuantityControl?>(null!, null);
- QuantityColumns[idx] = new DynamicTemplateColumn(row =>
- {
- var instance = LoadItem(row);
- var control = new QuantityControl(this, instance, idx);
- QuantityControls.Add(control);
- return control;
- })
- {
- HeaderText = "Qty.",
- Width = 60,
- ContextMenu = contextMenuFunc
- };
- CostColumns[idx] = new DynamicTextColumn(row =>
- {
- if(row is null)
- {
- return "Cost";
- }
- var instance = LoadItem(row);
- var qty = instance.GetQuantity(idx);
- var supplierProduct = GetSupplierProduct(instance, Suppliers[idx].ID);
- if(supplierProduct is not null)
- {
- return $"{qty * supplierProduct.CostPrice * instance.Multiplier:C2}";
- }
- else
- {
- return "";
- }
- })
- {
- HeaderText = "Cost",
- Width = 70,
- ContextMenu = contextMenuFunc,
- GetSummary = () =>
- {
- return new DynamicGridCustomSummary((rows) => Cost_Aggregate(idx, rows), "C2");
- }
- };
- ActionColumns.Add(QuantityColumns[idx]);
- ActionColumns.Add(CostColumns[idx]);
- }
- private double Cost_Aggregate(int supplierIdx, IEnumerable<CoreRow> rows)
- {
- return rows.Sum(row =>
- {
- var item = LoadItem(row);
- var supplierProduct = GetSupplierProduct(item, Suppliers[supplierIdx].ID);
- if (supplierProduct is not null)
- {
- var qty = item.GetQuantity(supplierIdx);
- return qty * item.Multiplier * supplierProduct.CostPrice;
- }
- else
- {
- return 0;
- }
- });
- }
- private void CreateSupplierProduct_Click(Tuple<ReservationManagementTreatmentPOItem, int> tuple)
- {
- var (item, supplierIdx) = tuple;
- var supplierProduct = new SupplierProduct();
- LookupFactory.DoLookup<SupplierProduct, Product, ProductLink>(supplierProduct, x => x.Product, item.TreatmentProduct.ID);
- supplierProduct.SupplierLink.CopyFrom(Suppliers[supplierIdx]);
- if (DynamicGridUtils.EditEntity(supplierProduct, customiseGrid: EditSupplierProductGrid))
- {
- SupplierProducts.Add(supplierProduct);
- InvalidateGrid();
- }
- }
- private static bool Matches(ReservationManagementTreatmentPOItem item, SupplierProduct supplierProduct, bool matchJob)
- {
- return item.TreatmentProduct.ID == supplierProduct.Product.ID
- && (!matchJob || item.JRI.Job.ID == supplierProduct.Job.ID);
- }
- private SupplierProduct? GetSupplierProduct(ReservationManagementTreatmentPOItem item)
- {
- var defaultSupplierProduct = SupplierProducts.FirstOrDefault(x => x.ID == item.Product.Supplier.ID);
- if(defaultSupplierProduct is not null && Matches(item, defaultSupplierProduct, false))
- {
- return defaultSupplierProduct;
- }
- else
- {
- return SupplierProducts.FirstOrDefault(x => Matches(item, x, true))
- ?? SupplierProducts.FirstOrDefault(x => Matches(item, x, false));
- }
- }
- private SupplierProduct? GetSupplierProduct(ReservationManagementTreatmentPOItem item, Guid supplierID)
- {
- return SupplierProducts.FirstOrDefault(x => x.SupplierLink.ID == supplierID && Matches(item, x, false));
- }
- //private double GetQuantity(SupplierProduct product)
- //{
- // var instance = ProductInstances.WithIndex().Where(x => x.Value.Product.ID == product.ID)
- //}
- private class CostAggregate : ISummaryAggregate
- {
- public double Sum { get; private set; }
- private int SupplierIndex;
- private ReservationManagementTreatmentOrderGrid Grid;
- public CostAggregate(int supplierIndex, ReservationManagementTreatmentOrderGrid grid)
- {
- SupplierIndex = supplierIndex;
- Grid = grid;
- }
- public Action<IEnumerable, string, PropertyDescriptor> CalculateAggregateFunc()
- {
- return AggregateFunc;
- }
- private void AggregateFunc(IEnumerable items, string property, PropertyDescriptor args)
- {
- if (items is IEnumerable<DataRowView> rows)
- {
- }
- else
- {
- Logger.Send(LogType.Error, "", $"Attempting to calculate aggregate on invalid data type '{items.GetType()}'.");
- }
- }
- }
- }
|