JobGrid.cs 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using Comal.Classes;
  5. using InABox.Clients;
  6. using InABox.Configuration;
  7. using InABox.Core;
  8. using InABox.DynamicGrid;
  9. namespace PRSDesktop
  10. {
  11. public class JobGridSettings : IUserConfigurationSettings
  12. {
  13. [Obsolete]
  14. private CoreFilterDefinition? _currentFilter;
  15. [Obsolete]
  16. public CoreFilterDefinition? CurrentFilter
  17. {
  18. get => _currentFilter;
  19. set
  20. {
  21. if (value is not null)
  22. {
  23. Filters = new DynamicGridSelectedFilterSettings(new List<CoreFilterDefinition> { value }, false);
  24. }
  25. }
  26. }
  27. public DynamicGridSelectedFilterSettings Filters { get; set; } = new();
  28. }
  29. public class JobGrid : DynamicDataGrid<Job>
  30. {
  31. private Guid _statusid = Guid.Empty;
  32. private JobGridSettings _settings;
  33. public JobGrid()
  34. {
  35. _settings = new UserConfiguration<JobGridSettings>().Load();
  36. FilterComponent.SetSettings(_settings.Filters, false);
  37. FilterComponent.OnFiltersSelected += FilterComponent_OnFilterSelected;
  38. HiddenColumns.Add(x => x.ID);
  39. HiddenColumns.Add(x => x.JobNumber);
  40. HiddenColumns.Add(x => x.Name);
  41. HiddenColumns.Add(x => x.Customer.ID);
  42. HiddenColumns.Add(x => x.Customer.Code);
  43. HiddenColumns.Add(x => x.Customer.Name);
  44. HiddenColumns.Add(x => x.SiteAddress.Street);
  45. HiddenColumns.Add(x => x.SiteAddress.City);
  46. HiddenColumns.Add(x => x.SiteAddress.State);
  47. HiddenColumns.Add(x => x.SiteAddress.PostCode);
  48. HiddenColumns.Add(x => x.Account.ID);
  49. HiddenColumns.Add(x => x.Account.Code);
  50. HiddenColumns.Add(x => x.Account.Name);
  51. HiddenColumns.Add(x => x.Notes);
  52. HiddenColumns.Add(x => x.JobStatus.ID);
  53. HiddenColumns.Add(x => x.JobStatus.Active);
  54. HiddenColumns.Add(x => x.DefaultScope.ID);
  55. ActionColumns.Add(new DynamicMapColumn<Job>(this, x => x.SiteAddress.Location));
  56. }
  57. protected override void DoReconfigure(FluentList<DynamicGridOption> options)
  58. {
  59. base.DoReconfigure(options);
  60. options.AddRange(
  61. DynamicGridOption.RecordCount,
  62. DynamicGridOption.SelectColumns,
  63. DynamicGridOption.FilterRows
  64. );
  65. }
  66. public Guid StatusID
  67. {
  68. get => _statusid;
  69. set
  70. {
  71. _statusid = value;
  72. }
  73. }
  74. protected override void Reload(Filters<Job> criteria, Columns<Job> columns, ref SortOrder<Job>? sort, Action<CoreTable?, Exception?> action)
  75. {
  76. if (_statusid != Guid.Empty)
  77. criteria.Add(new Filter<Job>(x => x.JobStatus.ID).IsEqualTo(_statusid));
  78. sort = new SortOrder<Job>(x => x.JobNumber, SortDirection.Descending);
  79. base.Reload(criteria, columns, ref sort, action);
  80. }
  81. public override DynamicEditorPages LoadEditorPages(Job item)
  82. {
  83. var pages = new DynamicEditorPages(new IDynamicEditorPage[]
  84. {
  85. new DynamicManyToManyGrid<JobDocument,Job>(),
  86. new DynamicManyToManyGrid<JobStyle,Job>(),
  87. new DynamicOneToManyGrid<Job,JobDocumentSetTag>(),
  88. new JobFormDefinitionGrid(),
  89. new DynamicOneToManyGrid<Job, JobProductMapping>(),
  90. });
  91. return pages;
  92. }
  93. protected override Job CreateItem()
  94. {
  95. var result = base.CreateItem();
  96. var defstatus = new Client<JobStatus>().Query(new Filter<JobStatus>(x => x.Default).IsEqualTo(true));
  97. if (defstatus.Rows.Any())
  98. result.JobStatus.ID = defstatus.Rows.First().Get<JobStatus, Guid>(x => x.ID);
  99. return result;
  100. }
  101. protected override Dictionary<string, object?> EditorValueChanged(IDynamicEditorForm editor, Job[] items, string name, object value)
  102. {
  103. var result = base.EditorValueChanged(editor, items, name, value);
  104. if (name.Equals("Customer.ID"))
  105. {
  106. // false here because a customer has a defaultcontact
  107. // and we need to load the lookups before we set the default value
  108. var contact = editor.FindEditor("Contact.ID") as ILookupEditorControl;
  109. if (contact != null)
  110. DefineLookups(contact,items,false);
  111. }
  112. return result;
  113. }
  114. private void FilterComponent_OnFilterSelected(DynamicGridSelectedFilterSettings settings)
  115. {
  116. _settings.Filters = settings;
  117. new UserConfiguration<JobGridSettings>().Save(_settings);
  118. }
  119. }
  120. }