JobRequisitionItem.cs 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Linq;
  5. using System.Linq.Expressions;
  6. using InABox.Clients;
  7. using InABox.Core;
  8. using PRSClasses;
  9. namespace Comal.Classes
  10. {
  11. public enum JobRequisitionItemStatus
  12. {
  13. NotChecked, // Default
  14. /// <summary>
  15. /// All required stock has been received, and is in the correct <see cref="ProductStyle"/>.
  16. /// </summary>
  17. /// <remarks>
  18. /// This can be set even if there are unreceived <see cref="JobRequisitionItemPurchaseOrderItem"/>,
  19. /// since if we got the stock some other way, we still think of it as allocated.
  20. /// </remarks>
  21. Allocated,
  22. /// <summary>
  23. /// All required stock has been received, but some is not in the correct <see cref="ProductStyle"/>, meaning a treatment is required.
  24. /// </summary>
  25. /// <remarks>
  26. /// This can be set even if there are unreceived <see cref="JobRequisitionItemPurchaseOrderItem"/>,
  27. /// since if we got the stock some other way, we still think of it as having the stock allocated.
  28. /// </remarks>
  29. TreatmentRequired,
  30. /// <summary>
  31. /// The <see cref="JobRequisitionItem.OrderRequired"/> has been set, but there are no <see cref="JobRequisitionItemPurchaseOrderItem"/>s for
  32. /// this <see cref="JobRequisitionItem"/>.
  33. /// </summary>
  34. OrderRequired,
  35. /// <summary>
  36. /// We don't yet have all the stock, and there is at least one unreceived <see cref="JobRequisitionItemPurchaseOrderItem"/> of type
  37. /// <see cref="JobRequisitionItemPurchaseOrderItemType.Stock"/>.
  38. /// </summary>
  39. OnOrder,
  40. /// <summary>
  41. /// We don't yet have all the stock, and there is at least one unreceived <see cref="JobRequisitionItemPurchaseOrderItem"/> of type
  42. /// <see cref="JobRequisitionItemPurchaseOrderItemType.Treatment"/> and none of type <see cref="JobRequisitionItemPurchaseOrderItemType.Stock"/>.
  43. /// </summary>
  44. TreatmentOnOrder,
  45. [Obsolete]
  46. Received,// Drop
  47. [Obsolete]
  48. TreatmentReceived,// Drop
  49. /// <summary>
  50. /// The <see cref="JobRequisitionItem"/> has been cancelled, meaning it has a non-empty <see cref="JobRequisitionItem.Cancelled"/>.
  51. /// </summary>
  52. Cancelled,
  53. /// <summary>
  54. /// The <see cref="JobRequisitionItem/"> has been archived, meaning it has a non-empty <see cref="JobRequisitionItem.Archived"/>.
  55. /// </summary>
  56. Archived,
  57. /// <summary>
  58. /// The <see cref="JobRequisitionItem/"> has been issued, meaning that it has been allocated, and there are stock movements of type <see cref="StockMovementType.Issue"/> adding up to the correct total.
  59. /// </summary>
  60. Issued
  61. }
  62. public class JobRequisitionItemTotalQtyFormula : IFormula<JobRequisitionItem, double>
  63. {
  64. public Expression<Func<JobRequisitionItem, double>> Value => x => x.Qty;
  65. public Expression<Func<JobRequisitionItem, double>>[] Modifiers => new Expression<Func<JobRequisitionItem, double>>[] { x => x.Dimensions.Value };
  66. public FormulaOperator Operator => FormulaOperator.Multiply;
  67. public FormulaType Type => FormulaType.Virtual;
  68. }
  69. public class JobRequisitionItemInStockAggregate : CoreAggregate<JobRequisitionItem, StockMovement, double>
  70. {
  71. public override Expression<Func<StockMovement, double>> Aggregate => x => x.Units;
  72. public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<JobRequisitionItem, object>>> Links => new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<JobRequisitionItem, object>>>
  73. {
  74. { x => x.JobRequisitionItem.ID, x => x.ID }
  75. };
  76. public override AggregateCalculation Calculation => AggregateCalculation.Sum;
  77. }
  78. public class JobRequisitionItemOnOrderAggregate : CoreAggregate<JobRequisitionItem, JobRequisitionItemPurchaseOrderItem, double>
  79. {
  80. public override Expression<Func<JobRequisitionItemPurchaseOrderItem, double>> Aggregate => x => x.PurchaseOrderItem.Qty;
  81. public override Dictionary<Expression<Func<JobRequisitionItemPurchaseOrderItem, object>>, Expression<Func<JobRequisitionItem, object>>> Links => new Dictionary<Expression<Func<JobRequisitionItemPurchaseOrderItem, object>>, Expression<Func<JobRequisitionItem, object>>>
  82. {
  83. { x => x.JobRequisitionItem.ID, x => x.ID }
  84. };
  85. public override AggregateCalculation Calculation => AggregateCalculation.Sum;
  86. public override Filter<JobRequisitionItemPurchaseOrderItem>? Filter =>
  87. new Filter<JobRequisitionItemPurchaseOrderItem>(x => x.PurchaseOrderItem.ReceivedDate).IsEqualTo(null);
  88. }
  89. [Caption("Items")]
  90. [UserTracking(typeof(Job))]
  91. public class JobRequisitionItem : StockEntity, IRemotable, IPersistent, IOneToMany<JobRequisition>,
  92. ILicense<ProjectManagementLicense>, IJobMaterial, ISequenceable, IIssues
  93. {
  94. [EntityRelationship(DeleteAction.Cascade)]
  95. [Editable(Editable.Hidden)]
  96. public JobLink Job { get; set; }
  97. [EntityRelationship(DeleteAction.Cascade)]
  98. [Editable(Editable.Hidden)]
  99. public JobRequisitionLink Requisition { get; set; }
  100. [EntityRelationship(DeleteAction.SetNull)]
  101. [EditorSequence(1)]
  102. [RequiredColumn]
  103. public override ProductLink Product { get; set; }
  104. [EditorSequence(2)]
  105. [RequiredColumn]
  106. public ProductStyleLink Style { get; set; }
  107. [NullEditor]
  108. [Obsolete("Replaced with Dimensions", true)]
  109. public double UnitSize { get; set; }
  110. [EditorSequence(3)]
  111. [RequiredColumn]
  112. [DimensionsEditor(typeof(StockDimensions), AllowEditingUnit = false)]
  113. public override StockDimensions Dimensions { get; set; }
  114. [EditorSequence(4)]
  115. [RequiredColumn]
  116. public double Qty { get; set; }
  117. [DoubleEditor(Editable = Editable.Hidden)]
  118. [Formula(typeof(JobRequisitionItemTotalQtyFormula))]
  119. public double TotalQty { get; set; }
  120. [EditorSequence(5)]
  121. public double UnitCost { get; set; }
  122. [EditorSequence(6)]
  123. [CurrencyEditor(Summary = Summary.Sum)]
  124. public double TotalCost { get; set; }
  125. [EditorSequence(7)]
  126. [MemoEditor]
  127. public string Notes { get; set; }
  128. [EditorSequence(8)]
  129. public SupplierLink Supplier { get; set; }
  130. [EnumLookupEditor(typeof(JobRequisitionItemStatus), Editable = Editable.Disabled)]
  131. [EditorSequence(9)]
  132. [LoggableProperty]
  133. [RequiredColumn]
  134. public JobRequisitionItemStatus Status { get; set; } = JobRequisitionItemStatus.NotChecked;
  135. /// <summary>
  136. /// The amount of this requisition item that is currently in stock, which is an aggregate of the <see cref="StockMovement.Units"/> property.
  137. /// </summary>
  138. [Aggregate(typeof(JobRequisitionItemInStockAggregate))]
  139. [DoubleEditor(Editable = Editable.Disabled)]
  140. [EditorSequence(10)]
  141. public double InStock { get; set; }
  142. [Aggregate(typeof(JobRequisitionItemOnOrderAggregate))]
  143. [DoubleEditor(Editable = Editable.Disabled)]
  144. [EditorSequence(11)]
  145. public double OnOrder { get; set; }
  146. [EntityRelationship(DeleteAction.SetNull)]
  147. [RequiredColumn]
  148. [Obsolete("Replaced with JobRequisitionItemPurchaseOrderItem")]
  149. [NullEditor]
  150. public PurchaseOrderItemLink PurchaseOrderItem { get; set; }
  151. [Aggregate(typeof(JobRequisitionItemPurchaseOrderNumberAggregate))]
  152. [TextBoxEditor(Editable = Editable.Hidden)]
  153. public string PurchaseOrderNumbers { get; set; }
  154. [RequiredColumn]
  155. [EditorSequence(12)]
  156. public DateTime Cancelled { get; set; } = DateTime.MinValue;
  157. [RequiredColumn]
  158. [EditorSequence(13)]
  159. public DateTime Archived { get; set; } = DateTime.MinValue;
  160. [RequiredColumn]
  161. [Obsolete("Replaced with JobRequisitionItemPurchaseOrderItem")]
  162. [NullEditor]
  163. public DateTime Ordered { get; set; } = DateTime.MinValue;
  164. [RequiredColumn]
  165. [EditorSequence(14)]
  166. public DateTime OrderRequired { get; set; } = DateTime.MinValue;
  167. [NullEditor]
  168. public string Issues { get; set; }
  169. [NullEditor]
  170. public long Sequence { get; set; }
  171. static JobRequisitionItem()
  172. {
  173. LinkedProperties.Register<JobRequisitionItem, ProductStyleLink, Guid>(x => x.Product.DefaultInstance.Style, x => x.ID, x => x.Style.ID);
  174. LinkedProperties.Register<JobRequisitionItem, ProductStyleLink, String>(x => x.Product.DefaultInstance.Style, x => x.Code, x => x.Style.Code);
  175. LinkedProperties.Register<JobRequisitionItem, ProductStyleLink, String>(x => x.Product.DefaultInstance.Style, x => x.Description, x => x.Style.Description);
  176. LinkedProperties.Register<JobRequisitionItem, ProductInstanceLink, double>(x => x.Product.DefaultInstance, x => x.NettCost,
  177. x => x.UnitCost);
  178. StockEntity.LinkStockDimensions<JobRequisitionItem>();
  179. }
  180. private bool bChanging;
  181. protected override void DoPropertyChanged(string name, object? before, object? after)
  182. {
  183. if (bChanging)
  184. return;
  185. try
  186. {
  187. bChanging = true;
  188. if (name.Equals(nameof(Qty)) && after is double qty)
  189. TotalCost = UnitCost * qty;
  190. else if (name.Equals(nameof(UnitCost)) && after is double cost)
  191. TotalCost = cost * Qty;
  192. else if (name.Equals(nameof(TotalCost)) && after is double total)
  193. {
  194. if (Qty == 0)
  195. Qty = 1;
  196. UnitCost = total / Qty;
  197. }
  198. }
  199. finally
  200. {
  201. bChanging = false;
  202. }
  203. base.DoPropertyChanged(name, before, after);
  204. }
  205. public static void UpdateCosts(IEnumerable<JobRequisitionItem> items, Dictionary<String,object?> changes)
  206. {
  207. void UpdateValue<TType>(JobRequisitionItem item,Expression<Func<JobRequisitionItem, TType>> property, TType value)
  208. {
  209. CoreUtils.MonitorChanges(
  210. item,
  211. () => CoreUtils.SetPropertyValue(item, CoreUtils.GetFullPropertyName(property, "."), value),
  212. changes
  213. );
  214. }
  215. var productids = items.Where(x => x.Product.ID != Guid.Empty).Select(x => x.Product.ID).ToArray();
  216. MultiQuery query = new MultiQuery();
  217. query.Add(
  218. new Filter<SupplierProduct>(x=>x.Product.ID).InList(productids),
  219. new Columns<SupplierProduct>(x=>x.Product.ID)
  220. .Add(x=>x.SupplierLink.ID)
  221. .Add(x=>x.Style.ID)
  222. .Add(x=>x.Dimensions.UnitSize)
  223. .Add(x=>x.Job.ID)
  224. .Add(x=>x.SupplierCode)
  225. .Add(x=>x.SupplierDescription)
  226. .Add(x=>x.CostPrice)
  227. );
  228. query.Add(
  229. new Filter<ProductInstance>(x=>x.Product.ID).InList(productids),
  230. new Columns<ProductInstance>(x=>x.Product.ID)
  231. .Add(x => x.Style.ID)
  232. .Add(x => x.Dimensions.UnitSize)
  233. .Add(x => x.NettCost)
  234. );
  235. query.Query();
  236. foreach (var item in items)
  237. {
  238. //Check Supplier / Job Specific Pricing
  239. CoreRow? row = query.Get<SupplierProduct>()?.Rows.FirstOrDefault(r =>
  240. (r.Get<SupplierProduct, Guid>(c => c.Product.ID) == item.Product.ID)
  241. && (r.Get<SupplierProduct, Guid>(c => c.SupplierLink.ID) == item.Supplier.ID)
  242. && (r.Get<SupplierProduct, Guid>(c => c.Style.ID) == item.Style.ID)
  243. && (string.Equals(r.Get<SupplierProduct,String>(c=>c.Dimensions.UnitSize),item.Dimensions.UnitSize))
  244. && (r.Get<SupplierProduct, Guid>(c => c.Job.ID) == item.Job.ID)
  245. );
  246. if (row != null)
  247. {
  248. UpdateValue<double>(item, x => x.UnitCost, row.Get<SupplierProduct, double>(c => c.CostPrice));
  249. continue;
  250. }
  251. // Check Supplier Pricing
  252. row = query.Get<SupplierProduct>()?.Rows.FirstOrDefault(r =>
  253. (r.Get<SupplierProduct, Guid>(c => c.Product.ID) == item.Product.ID)
  254. && (r.Get<SupplierProduct, Guid>(c => c.SupplierLink.ID) == item.Supplier.ID)
  255. && (r.Get<SupplierProduct, Guid>(c => c.Style.ID) == item.Style.ID)
  256. && (string.Equals(r.Get<SupplierProduct,String>(c=>c.Dimensions.UnitSize),item.Dimensions.UnitSize))
  257. && (r.Get<SupplierProduct, Guid>(c => c.Job.ID) == Guid.Empty)
  258. );
  259. if (row != null)
  260. {
  261. UpdateValue<double>(item, x => x.UnitCost, row.Get<SupplierProduct, double>(c => c.CostPrice));
  262. continue;
  263. }
  264. // Check Specific Product Instance
  265. row = query.Get<ProductInstance>()?.Rows.FirstOrDefault(r =>
  266. (r.Get<ProductInstance, Guid>(c => c.Product.ID) == item.Product.ID)
  267. && (r.Get<ProductInstance, Guid>(c => c.Style.ID) == item.Style.ID)
  268. && (string.Equals(r.Get<ProductInstance,string>(c => c.Dimensions.UnitSize),item.Dimensions.UnitSize))
  269. );
  270. if (row != null)
  271. UpdateValue<double>(item, x => x.UnitCost, row.Get<ProductInstance, double>(c => c.NettCost));
  272. else
  273. UpdateValue<double>(item, x => x.UnitCost, 0.0F);
  274. }
  275. }
  276. }
  277. public class JobRequisitionItemPurchaseOrderNumberAggregate : CoreAggregate<JobRequisitionItem, JobRequisitionItemPurchaseOrderItem, string>
  278. {
  279. public override Expression<Func<JobRequisitionItemPurchaseOrderItem, string>> Aggregate => x => x.PurchaseOrderItem.PurchaseOrderLink.PONumber;
  280. public override Dictionary<Expression<Func<JobRequisitionItemPurchaseOrderItem, object>>, Expression<Func<JobRequisitionItem, object>>> Links { get; } = new Dictionary<Expression<Func<JobRequisitionItemPurchaseOrderItem, object>>, Expression<Func<JobRequisitionItem, object>>>
  281. {
  282. { x => x.JobRequisitionItem.ID, x => x.ID }
  283. };
  284. public override AggregateCalculation Calculation => AggregateCalculation.Concat;
  285. }
  286. }