Schedule.cs 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365
  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. Filter<Schedule>.Where(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 Employee { get; set; }
  163. [Obsolete("Replaced with Employee")]
  164. public EmployeeLink EmployeeLink
  165. {
  166. get => Employee;
  167. set { }
  168. }
  169. [Caption("Managed By")]
  170. [EditorSequence(12)]
  171. public EmployeeLink Manager { get; set; }
  172. [Obsolete("Replaced by Manager")]
  173. public EmployeeLink ManagerLink
  174. {
  175. get => Manager;
  176. set { }
  177. }
  178. [Caption("Report Type")]
  179. [EditorSequence(13)]
  180. public DocumentLink Report { get; set; }
  181. [EnumLookupEditor(typeof(ScheduleRollover))]
  182. [EditorSequence(14)]
  183. public ScheduleRollover Rollover { get; set; }
  184. [TimestampEditor(Editable = Editable.Hidden)]
  185. public DateTime Completed { get; set; }
  186. [NullEditor]
  187. public bool Active { get; set; }
  188. [CheckBoxEditor]
  189. [EditorSequence(15)]
  190. [Comment("Include this schedule in the '" + nameof(Equipment.NextSchedule) + "' aggregate and the Planned Maintenance screen.")]
  191. public bool IncludeInAggregate { get; set; } = true;
  192. #endregion
  193. #region Public Methods
  194. private DateTime ApplyPeriod(DateTime date)
  195. {
  196. var result = date;
  197. switch (Period)
  198. {
  199. case SchedulePeriod.Year:
  200. return date.AddYears(Frequency);
  201. case SchedulePeriod.Month:
  202. return date.AddMonths(Frequency);
  203. case SchedulePeriod.Week:
  204. return date.AddDays(7 * Frequency);
  205. case SchedulePeriod.Day:
  206. return date.AddDays(Frequency);
  207. case SchedulePeriod.Hour:
  208. return date.AddHours(Frequency);
  209. case SchedulePeriod.Minute:
  210. return date.AddMinutes(Frequency);
  211. }
  212. return result;
  213. }
  214. private DateTime ApplyOffsets(DateTime date, int index)
  215. {
  216. if (index >= Offsets.Count)
  217. return date;
  218. var offset = Offsets[index];
  219. var result = date;
  220. var skip = 1;
  221. switch (offset.Period)
  222. {
  223. case SchedulePeriod.Year:
  224. result = date.AddYears(offset.Offset);
  225. break;
  226. case SchedulePeriod.Month:
  227. result = date.AddMonths(offset.Offset);
  228. break;
  229. case SchedulePeriod.Week:
  230. // First Lets get to the start of the month
  231. var startOfMonth = date.Date.AddDays(1 - date.Day);
  232. // Calculate the DOW for the start of the month
  233. var dow = (int)startOfMonth.DayOfWeek;
  234. // If the next offset is a day-type
  235. var tgtdow = 0;
  236. if (index < Offsets.Count - 1)
  237. {
  238. skip++;
  239. if (Offsets[index + 1].Period == SchedulePeriod.Day)
  240. tgtdow = Offsets[index + 1].Offset;
  241. else if (Offsets[index + 1].Period == SchedulePeriod.Hour)
  242. tgtdow = Offsets[index + 1].Offset / 24;
  243. else if (Offsets[index + 1].Period == SchedulePeriod.Minute)
  244. tgtdow = Offsets[index + 1].Offset / (24 * 60);
  245. else
  246. skip--;
  247. }
  248. result = startOfMonth.AddDays(0 - dow).AddDays(tgtdow);
  249. if (dow > tgtdow)
  250. result = result.AddDays(7);
  251. result = result.AddDays(Offsets[index].Offset * 7);
  252. break;
  253. case SchedulePeriod.Day:
  254. result = date.AddDays(offset.Offset);
  255. break;
  256. case SchedulePeriod.Hour:
  257. result = date.AddHours(offset.Offset);
  258. break;
  259. case SchedulePeriod.Minute:
  260. result = date.AddMinutes(offset.Offset);
  261. break;
  262. }
  263. return ApplyOffsets(result, index + skip);
  264. }
  265. public DateTime GetNextDate(DateTime last)
  266. {
  267. // if this is the first time run, then
  268. // just return the due date
  269. if (last.IsEmpty())
  270. return DueDate;
  271. // Get the base date for the next scheduled run
  272. var result = Rollover.Equals(ScheduleRollover.FromDueDate) ? DueDate : last;
  273. // Roll it forward to the next due date
  274. result = ApplyPeriod(result);
  275. // Apply any offsets we need
  276. if (Offsets != null && Offsets.Any())
  277. result = ApplyOffsets(result, 0);
  278. return result;
  279. }
  280. #endregion
  281. }
  282. public interface ISchedulable
  283. {
  284. //bool ScheduleEnabled { get; set; }
  285. [NullEditor]
  286. int ActiveSchedules { get; set; }
  287. }
  288. public interface IScheduleAction
  289. {
  290. DateTime Completed { get; set; }
  291. ScheduleLink Schedule { get; set; }
  292. }
  293. }