JobRequisitionItemGrid.cs 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Reactive.Linq;
  5. using System.Threading;
  6. using System.Windows;
  7. using System.Windows.Controls;
  8. using Comal.Classes;
  9. using InABox.Clients;
  10. using InABox.Core;
  11. using InABox.DynamicGrid;
  12. using InABox.Wpf;
  13. using InABox.WPF;
  14. namespace PRSDesktop;
  15. internal class JobRequisitionItemGrid : DynamicDataGrid<JobRequisitionItem>, IMasterDetailControl<JobRequisition, JobRequisitionItem>, ISpecificGrid
  16. {
  17. public Job? Job { get; set; }
  18. private JobRequisition? _master;
  19. public JobRequisition? Master
  20. {
  21. get => _master;
  22. set
  23. {
  24. _master = value;
  25. // CheckVisibility();
  26. Reconfigure();
  27. }
  28. }
  29. public Filter<JobRequisitionItem> MasterDetailFilter => Master != null
  30. ? Master.ID != Guid.Empty
  31. ? new Filter<JobRequisitionItem>(x => x.Requisition.ID).IsEqualTo(Master.ID)
  32. : new Filter<JobRequisitionItem>().None()
  33. : Job is not null && Job.ID != Guid.Empty
  34. ? new Filter<JobRequisitionItem>(x => x.Requisition.Job.ID).IsEqualTo(Job.ID)
  35. : new Filter<JobRequisitionItem>().None();
  36. // private Button CancelItemsButton;
  37. public JobRequisitionItemGrid()
  38. {
  39. //CancelItemsButton = AddButton("Cancel Items", PRSDesktop.Resources.disabled.AsBitmapImage(), CancelItems);
  40. // CheckVisibility();
  41. }
  42. // private void CheckVisibility()
  43. // {
  44. // CancelItemsButton.Visibility = Master is not null && Security.CanEdit<JobRequisition>() && Security.CanEdit<JobRequisitionItem>()
  45. // ? System.Windows.Visibility.Visible
  46. // : System.Windows.Visibility.Hidden;
  47. // }
  48. // public override void SelectItems(CoreRow[]? rows)
  49. // {
  50. // base.SelectItems(rows);
  51. // CancelItemsButton.IsEnabled = rows is not null && rows.Length > 0;
  52. // }
  53. //private bool CancelItems(Button button, CoreRow[] rows)
  54. //{
  55. // if (Master is null) return false;
  56. // if(rows.Length == 0)
  57. // {
  58. // MessageWindow.ShowMessage("Please select at least one item to cancel.", "Select items");
  59. // return false;
  60. // }
  61. // // Reloading so I can ensure the correct columns without having to add hidden columns to JobRequisitionGrid.
  62. // var oldRequi = Client.Query(
  63. // new Filter<JobRequisition>(x => x.ID).IsEqualTo(Master?.ID ?? Guid.Empty),
  64. // Columns.None<JobRequisition>().Add(x => x.Description)
  65. // .Add(x => x.Number)
  66. // .Add(x => x.DueDate))
  67. // .ToObjects<JobRequisition>()
  68. // .First();
  69. // var oldRequiItems = Client.Query(
  70. // new Filter<JobRequisitionItem>(x => x.ID).InList(rows.Select(x => x.Get<JobRequisitionItem, Guid>(x => x.ID)).ToArray()),
  71. // Columns.None<JobRequisitionItem>().Add(x => x.Qty)
  72. // .Add(x => x.Sequence)
  73. // .Add(x => x.Job.ID)
  74. // .Add(x => x.Product.ID)
  75. // .Add(x => x.Product.Code)
  76. // .Add(x => x.Style.ID)
  77. // .Add(x => x.Style.Code)
  78. // .Add(x => x.Style.Description)
  79. // .Add(x => x.Dimensions.Unit.ID)
  80. // .Add(x => x.Dimensions.Quantity)
  81. // .Add(x => x.Dimensions.Length)
  82. // .Add(x => x.Dimensions.Width)
  83. // .Add(x => x.Dimensions.Height)
  84. // .Add(x => x.Dimensions.Weight)
  85. // .Add(x => x.Dimensions.UnitSize)
  86. // .Add(x => x.Supplier.ID));
  87. // var requisition = new JobRequisition
  88. // {
  89. // Description = $"Adjustment Requisition for Requisition {oldRequi.Number}",
  90. // DueDate = oldRequi.DueDate
  91. // };
  92. // requisition.Job.ID = Master.Job.ID;
  93. // requisition.Job.Synchronise(Master.Job);
  94. // var requiItems = new List<JobRequisitionItem>();
  95. // foreach(var oldItem in oldRequiItems.ToObjects<JobRequisitionItem>())
  96. // {
  97. // var newItem = new JobRequisitionItem
  98. // {
  99. // Notes = "Adjustment Requisition item",
  100. // Qty = -oldItem.Qty,
  101. // Sequence = oldItem.Sequence
  102. // };
  103. // newItem.Job.ID = requisition.Job.ID;
  104. // newItem.Product.ID = oldItem.Product.ID;
  105. // newItem.Style.ID = oldItem.Style.ID;
  106. // newItem.Supplier.ID = oldItem.Supplier.ID;
  107. // requiItems.Add(newItem);
  108. // }
  109. // var grid = DynamicGridUtils.CreateDynamicGrid(typeof(DynamicGrid<>), typeof(JobRequisition));
  110. // if (grid.EditItems(new JobRequisition[] { requisition }, t =>
  111. // {
  112. // if (t == typeof(JobRequisitionItem))
  113. // {
  114. // var table = new CoreTable();
  115. // table.LoadColumns(new Columns<JobRequisitionItem>(ColumnTypeFlags.Local | ColumnTypeFlags.IncludeAggregates | ColumnTypeFlags.IncludeFormulae | ColumnTypeFlags.Required));
  116. // table.LoadRows(requiItems);
  117. // return table;
  118. // }
  119. // return null;
  120. // }))
  121. // {
  122. // MessageWindow.ShowMessage($"Created requisition {requisition.Number}", "Created Requisition");
  123. // return true;
  124. // }
  125. // else
  126. // {
  127. // return false;
  128. // }
  129. //}
  130. protected override void DoReconfigure(DynamicGridOptions options)
  131. {
  132. base.DoReconfigure(options);
  133. options.RecordCount = true;
  134. options.SelectColumns = true;
  135. options.FilterRows = true;
  136. options.MultiSelect = true;
  137. if(Master is not null)
  138. {
  139. options.AddRows = true;
  140. }
  141. else
  142. {
  143. options.AddRows = false;
  144. }
  145. }
  146. protected override void Reload(
  147. Filters<JobRequisitionItem> criteria, Columns<JobRequisitionItem> columns, ref SortOrder<JobRequisitionItem>? sort,
  148. CancellationToken token, Action<CoreTable?, Exception?> action)
  149. {
  150. criteria.Add(MasterDetailFilter);
  151. base.Reload(criteria, columns, ref sort, token, action);
  152. }
  153. protected override bool CanCreateItems()
  154. {
  155. return base.CanCreateItems() && (Master?.ID ?? Guid.Empty) != Guid.Empty;
  156. }
  157. public override JobRequisitionItem CreateItem()
  158. {
  159. var result = base.CreateItem();
  160. if(Master is not null)
  161. {
  162. result.Requisition.ID = Master.ID;
  163. result.Requisition.Synchronise(Master);
  164. result.Job.ID = Master.Job.ID;
  165. result.Job.Synchronise(Master.Job);
  166. }
  167. result.Qty = 1;
  168. return result;
  169. }
  170. protected override void OnAfterEditorValueChanged(DynamicEditorGrid? grid, JobRequisitionItem[] items, AfterEditorValueChangedArgs args, Dictionary<string, object?> changes)
  171. {
  172. base.OnAfterEditorValueChanged(grid, items, args, changes);
  173. if (args.ColumnName.Equals("Product.ID") || args.ColumnName.Equals("Dimensions") || args.ColumnName.StartsWith("Dimensions.") || args.ColumnName.Equals("Style.ID") || args.ColumnName.Equals("Supplier.ID"))
  174. {
  175. JobRequisitionItem.UpdateCosts(
  176. items,
  177. changes
  178. );
  179. }
  180. }
  181. public override DynamicGridColumns GenerateColumns()
  182. {
  183. var columns = new DynamicGridColumns();
  184. columns.Add<JobRequisitionItem, DateTime>(x => x.Created, 80, "Date", "", Alignment.MiddleLeft);
  185. columns.Add<JobRequisitionItem, string>(x => x.Requisition.Job.JobNumber, 70, "Job", "", Alignment.MiddleLeft);
  186. columns.Add<JobRequisitionItem, int>(x => x.Requisition.Number, 50, "NO.", "", Alignment.MiddleLeft);
  187. columns.Add<JobRequisitionItem, string>(x => x.Product.Code, 70, "Code", "", Alignment.MiddleLeft);
  188. columns.Add<JobRequisitionItem, string>(x => x.Product.Name, 200, "Product Name", "", Alignment.MiddleLeft);
  189. columns.Add<JobRequisitionItem, string>(x => x.Style.Description, 150, "Style", "", Alignment.MiddleLeft);
  190. columns.Add<JobRequisitionItem, double>(x => x.Qty, 50, "Qty", "", Alignment.MiddleLeft);
  191. columns.Add<JobRequisitionItem, string>(x => x.Dimensions.UnitSize, 50, "Size", "", Alignment.MiddleLeft);
  192. columns.Add<JobRequisitionItem, string>(x => x.PurchaseOrderNumbers, 80, "PO Numbers", "", Alignment.MiddleLeft);
  193. columns.Add<JobRequisitionItem, JobRequisitionItemStatus>(x => x.Status, 80, "Status", "", Alignment.MiddleLeft);
  194. columns.Add<JobRequisitionItem, string>(x => x.Notes, 300, "Notes", "", Alignment.MiddleLeft);
  195. columns.AddRange(base.GenerateColumns());
  196. return columns;
  197. }
  198. }