JobGrid.cs 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  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. Refresh(false, true);
  73. }
  74. }
  75. protected override void Reload(Filters<Job> criteria, Columns<Job> columns, ref SortOrder<Job>? sort, Action<CoreTable?, Exception?> action)
  76. {
  77. if (_statusid != Guid.Empty)
  78. criteria.Add(new Filter<Job>(x => x.JobStatus.ID).IsEqualTo(_statusid));
  79. sort = new SortOrder<Job>(x => x.JobNumber, SortDirection.Descending);
  80. base.Reload(criteria, columns, ref sort, action);
  81. }
  82. public override DynamicEditorPages LoadEditorPages(Job item)
  83. {
  84. var pages = new DynamicEditorPages(new IDynamicEditorPage[]
  85. {
  86. new DynamicManyToManyGrid<JobDocument,Job>(),
  87. new DynamicManyToManyGrid<JobStyle,Job>(),
  88. new DynamicOneToManyGrid<Job,JobDocumentSetTag>(),
  89. new JobFormDefinitionGrid(),
  90. new DynamicOneToManyGrid<Job, JobProductMapping>(),
  91. });
  92. return pages;
  93. }
  94. protected override Job CreateItem()
  95. {
  96. var result = base.CreateItem();
  97. var defstatus = new Client<JobStatus>().Query(new Filter<JobStatus>(x => x.Default).IsEqualTo(true));
  98. if (defstatus.Rows.Any())
  99. result.JobStatus.ID = defstatus.Rows.First().Get<JobStatus, Guid>(x => x.ID);
  100. return result;
  101. }
  102. protected override Dictionary<string, object?> EditorValueChanged(IDynamicEditorForm editor, Job[] items, string name, object value)
  103. {
  104. var result = base.EditorValueChanged(editor, items, name, value);
  105. if (name.Equals("Customer.ID"))
  106. {
  107. // false here because a customer has a defaultcontact
  108. // and we need to load the lookups before we set the default value
  109. var contact = editor.FindEditor("Contact.ID") as ILookupEditorControl;
  110. if (contact != null)
  111. DefineLookups(contact,items,false);
  112. }
  113. return result;
  114. }
  115. private void FilterComponent_OnFilterSelected(DynamicGridSelectedFilterSettings settings)
  116. {
  117. _settings.Filters = settings;
  118. new UserConfiguration<JobGridSettings>().Save(_settings);
  119. }
  120. }
  121. }