Schedule.cs 9.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351
  1. using System;
  2. using System.Collections.Generic;
  3. using System.IO;
  4. using System.Linq;
  5. using System.Linq.Expressions;
  6. using InABox.Core;
  7. namespace Comal.Classes
  8. {
  9. public enum SchedulePeriod
  10. {
  11. Minute,
  12. Hour,
  13. Day,
  14. Week,
  15. Month,
  16. Year
  17. }
  18. public enum ScheduleTrigger
  19. {
  20. Distance,
  21. Usage,
  22. Counter1,
  23. Counter2,
  24. Counter3,
  25. Counter4,
  26. Counter5
  27. }
  28. public enum ScheduleRollover
  29. {
  30. FromDueDate,
  31. FromActualDate
  32. }
  33. public enum ScheduleType
  34. {
  35. None,
  36. Job,
  37. Task
  38. }
  39. public class ScheduleOffset : BaseObject, IPackable
  40. {
  41. public ScheduleOffset()
  42. {
  43. }
  44. public ScheduleOffset(int offset, SchedulePeriod period)
  45. {
  46. Period = period;
  47. Offset = offset;
  48. }
  49. [EnumLookupEditor(typeof(SchedulePeriod), Visible = Visible.Default)]
  50. [EditorSequence(1)]
  51. public SchedulePeriod Period { get; set; }
  52. [IntegerEditor(Visible = Visible.Default)]
  53. [EditorSequence(2)]
  54. public int Offset { get; set; }
  55. public void Pack(BinaryWriter writer)
  56. {
  57. writer.Write((int)Period);
  58. writer.Write(Offset);
  59. }
  60. public void Unpack(BinaryReader reader)
  61. {
  62. Period = (SchedulePeriod)reader.ReadInt32();
  63. Offset = reader.ReadInt32();
  64. }
  65. }
  66. public class ScheduleOffsetList : PackableList<ScheduleOffset>
  67. {
  68. }
  69. public class ScheduleLink : EntityLink<Schedule>
  70. {
  71. [NullEditor]
  72. public override Guid ID { get; set; }
  73. [TextBoxEditor(Editable = Editable.Hidden)]
  74. public string Title { get; set; }
  75. [EnumLookupEditor(typeof(ScheduleRollover), Editable = Editable.Hidden)]
  76. public ScheduleRollover Rollover { get; set; }
  77. }
  78. public class ActiveSchedulesFormula<T> : ComplexFormulaGenerator<T, int>
  79. where T : Entity
  80. {
  81. public override IComplexFormulaNode<T, int> GetFormula() =>
  82. Count<Schedule, Guid>(x => x.Property(x => x.ID))
  83. .WithLink(x => x.DocumentID, x => x.ID);
  84. }
  85. public class NextScheduleFormula<T> : ComplexFormulaGenerator<T, DateTime>
  86. where T : Entity
  87. {
  88. public override IComplexFormulaNode<T, DateTime> GetFormula() =>
  89. Aggregate<Schedule>(AggregateCalculation.Minimum,
  90. x => x.Property(x => x.DueDate),
  91. new Filter<Schedule>(x => x.IncludeInAggregate).IsEqualTo(true))
  92. .WithLink(x => x.DocumentID, x => x.ID);
  93. }
  94. [UserTracking("Task Scheduler")]
  95. public class Schedule : Entity, IPersistent, IRemotable, IOneToMany<Employee>, ILicense<ScheduleEngineLicense>
  96. {
  97. #region Public Properties
  98. [NullEditor]
  99. public string DocumentClass { get; set; }
  100. //[NullEditor]
  101. //[DoNotSerialize]
  102. public Type? DocumentType()
  103. {
  104. try
  105. {
  106. return CoreUtils.GetEntityOrNull(DocumentClass);
  107. }
  108. catch
  109. {
  110. return null;
  111. }
  112. }
  113. [NullEditor]
  114. public Guid DocumentID { get; set; }
  115. [TextBoxEditor]
  116. [EditorSequence(0)]
  117. public string Title { get; set; }
  118. [MemoEditor]
  119. [EditorSequence(1)]
  120. public string Description { get; set; }
  121. // Date Based Scheduling
  122. [IntegerEditor]
  123. [EditorSequence(2)]
  124. [Caption("Schedule Frequency")]
  125. public int Frequency { get; set; } = 1;
  126. [EnumLookupEditor(typeof(SchedulePeriod))]
  127. [EditorSequence(3)]
  128. [Caption("Schedule Type")]
  129. public SchedulePeriod Period { get; set; } = SchedulePeriod.Month;
  130. [DateTimeEditor]
  131. [EditorSequence(4)]
  132. [Caption("Schedule Due")]
  133. public DateTime DueDate { get; set; } = DateTime.Today.AddDays(1);
  134. // Trigger-Based Scheduling
  135. [IntegerEditor]
  136. [EditorSequence(5)]
  137. [Caption("Trigger Frequency")]
  138. public int Threshold { get; set; }
  139. [EnumLookupEditor(typeof(ScheduleTrigger))]
  140. [Caption("Trigger Type")]
  141. [EditorSequence(6)]
  142. public ScheduleTrigger Trigger { get; set; }
  143. [IntegerEditor]
  144. [EditorSequence(7)]
  145. [Caption("Trigger Level")]
  146. public int DueThreshold { get; set; }
  147. [EnumLookupEditor(typeof(ScheduleType))]
  148. [EditorSequence(8)]
  149. [Caption("Scheduled Action")]
  150. public ScheduleType ScheduleType { get; set; } = ScheduleType.Task;
  151. //[LookupEditor(typeof(KanbanType))]
  152. [EditorSequence(9)]
  153. [Caption("Task Type")]
  154. public KanbanTypeLink KanbanType { get; set; }
  155. [IntegerEditor]
  156. [EditorSequence(10)]
  157. [Caption("Lead Time")]
  158. public int LeadTime { get; set; }
  159. public ScheduleOffsetList Offsets { get; set; } = new ScheduleOffsetList();
  160. [Caption("Assigned To")]
  161. [EditorSequence(11)]
  162. public EmployeeLink EmployeeLink { get; set; }
  163. [Caption("Managed By")]
  164. [EditorSequence(12)]
  165. public EmployeeLink ManagerLink { get; set; }
  166. [Caption("Report Type")]
  167. [EditorSequence(13)]
  168. public DocumentLink Report { get; set; }
  169. [EnumLookupEditor(typeof(ScheduleRollover))]
  170. [EditorSequence(14)]
  171. public ScheduleRollover Rollover { get; set; }
  172. [TimestampEditor(Editable = Editable.Hidden)]
  173. public DateTime Completed { get; set; }
  174. [NullEditor]
  175. public bool Active { get; set; }
  176. [CheckBoxEditor]
  177. [EditorSequence(15)]
  178. [Comment("Include this schedule in the '" + nameof(Equipment.NextSchedule) + "' aggregate and the Planned Maintenance screen.")]
  179. public bool IncludeInAggregate { get; set; } = true;
  180. #endregion
  181. #region Public Methods
  182. private DateTime ApplyPeriod(DateTime date)
  183. {
  184. var result = date;
  185. switch (Period)
  186. {
  187. case SchedulePeriod.Year:
  188. return date.AddYears(Frequency);
  189. case SchedulePeriod.Month:
  190. return date.AddMonths(Frequency);
  191. case SchedulePeriod.Week:
  192. return date.AddDays(7 * Frequency);
  193. case SchedulePeriod.Day:
  194. return date.AddDays(Frequency);
  195. case SchedulePeriod.Hour:
  196. return date.AddHours(Frequency);
  197. case SchedulePeriod.Minute:
  198. return date.AddMinutes(Frequency);
  199. }
  200. return result;
  201. }
  202. private DateTime ApplyOffsets(DateTime date, int index)
  203. {
  204. if (index >= Offsets.Count)
  205. return date;
  206. var offset = Offsets[index];
  207. var result = date;
  208. var skip = 1;
  209. switch (offset.Period)
  210. {
  211. case SchedulePeriod.Year:
  212. result = date.AddYears(offset.Offset);
  213. break;
  214. case SchedulePeriod.Month:
  215. result = date.AddMonths(offset.Offset);
  216. break;
  217. case SchedulePeriod.Week:
  218. // First Lets get to the start of the month
  219. var startOfMonth = date.Date.AddDays(1 - date.Day);
  220. // Calculate the DOW for the start of the month
  221. var dow = (int)startOfMonth.DayOfWeek;
  222. // If the next offset is a day-type
  223. var tgtdow = 0;
  224. if (index < Offsets.Count - 1)
  225. {
  226. skip++;
  227. if (Offsets[index + 1].Period == SchedulePeriod.Day)
  228. tgtdow = Offsets[index + 1].Offset;
  229. else if (Offsets[index + 1].Period == SchedulePeriod.Hour)
  230. tgtdow = Offsets[index + 1].Offset / 24;
  231. else if (Offsets[index + 1].Period == SchedulePeriod.Minute)
  232. tgtdow = Offsets[index + 1].Offset / (24 * 60);
  233. else
  234. skip--;
  235. }
  236. result = startOfMonth.AddDays(0 - dow).AddDays(tgtdow);
  237. if (dow > tgtdow)
  238. result = result.AddDays(7);
  239. result = result.AddDays(Offsets[index].Offset * 7);
  240. break;
  241. case SchedulePeriod.Day:
  242. result = date.AddDays(offset.Offset);
  243. break;
  244. case SchedulePeriod.Hour:
  245. result = date.AddHours(offset.Offset);
  246. break;
  247. case SchedulePeriod.Minute:
  248. result = date.AddMinutes(offset.Offset);
  249. break;
  250. }
  251. return ApplyOffsets(result, index + skip);
  252. }
  253. public DateTime GetNextDate(DateTime last)
  254. {
  255. // if this is the first time run, then
  256. // just return the due date
  257. if (last.IsEmpty())
  258. return DueDate;
  259. // Get the base date for the next scheduled run
  260. var result = Rollover.Equals(ScheduleRollover.FromDueDate) ? DueDate : last;
  261. // Roll it forward to the next due date
  262. result = ApplyPeriod(result);
  263. // Apply any offsets we need
  264. if (Offsets != null && Offsets.Any())
  265. result = ApplyOffsets(result, 0);
  266. return result;
  267. }
  268. #endregion
  269. }
  270. public interface ISchedulable
  271. {
  272. //bool ScheduleEnabled { get; set; }
  273. [NullEditor]
  274. int ActiveSchedules { get; set; }
  275. }
  276. public interface IScheduleAction
  277. {
  278. DateTime Completed { get; set; }
  279. ScheduleLink ScheduleLink { get; set; }
  280. }
  281. }