Context.cs 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484
  1. using System;
  2. namespace FastReport.AdvMatrix
  3. {
  4. /// <summary>
  5. /// Holds context required for aggregate functions evaluation.
  6. /// </summary>
  7. public class Context
  8. {
  9. internal CellDescriptor Descriptor;
  10. internal HeaderData ColumnItem;
  11. internal HeaderData RowItem;
  12. internal AggregateExpressionPair Aggregate;
  13. private dynamic Div(dynamic value, dynamic divBy)
  14. {
  15. if (divBy == null || divBy == 0)
  16. return null;
  17. if (value is float || value is double || value is decimal)
  18. return value / divBy;
  19. return value / (double)divBy;
  20. }
  21. private bool CheckAggregate()
  22. {
  23. // in case we provide no arguments to the special method call, use the first aggregate in a cell
  24. if (Aggregate == null)
  25. {
  26. if (Descriptor != null && Descriptor.Aggregates.Count > 0)
  27. Aggregate = Descriptor.Aggregates[0];
  28. }
  29. return Aggregate != null;
  30. }
  31. private dynamic GetAggregateValue(int columnIndex, int rowIndex)
  32. {
  33. return Aggregate.GetValue(columnIndex, rowIndex);
  34. }
  35. /// <summary>
  36. /// Gets aggregate value. This method is for internal use only.
  37. /// </summary>
  38. /// <param name="aggregateName">Name of aggregate.</param>
  39. /// <param name="expression">Expression.</param>
  40. /// <returns>Aggregate value.</returns>
  41. public dynamic GetAggregate(string aggregateName, string expression)
  42. {
  43. if (Descriptor == null)
  44. return null;
  45. Aggregate = Descriptor.Aggregates.Find(aggregateName, expression);
  46. if (Aggregate == null)
  47. return null;
  48. return GetAggregateValue(ColumnItem.Index, RowItem.Index);
  49. }
  50. /// <summary>
  51. /// Gets value of the specific column. This method is for internal use only.
  52. /// </summary>
  53. /// <param name="value">The column value.</param>
  54. /// <param name="dummy">Dummy parameter.</param>
  55. /// <returns>The value or null.</returns>
  56. public dynamic GetSpecificColumn(object value, object dummy = null)
  57. {
  58. HeaderData columnItem = ColumnItem.GetSpecificItem(value);
  59. if (columnItem == null)
  60. return null;
  61. if (!CheckAggregate())
  62. return null;
  63. return GetAggregateValue(columnItem.Index, RowItem.Index);
  64. }
  65. /// <summary>
  66. /// Gets value of the specific row. This method is for internal use only.
  67. /// </summary>
  68. /// <param name="value">The row value.</param>
  69. /// <param name="dummy">Dummy parameter.</param>
  70. /// <returns>The value or null.</returns>
  71. public dynamic GetSpecificRow(object value, object dummy = null)
  72. {
  73. HeaderData rowItem = RowItem.GetSpecificItem(value);
  74. if (rowItem == null)
  75. return null;
  76. if (!CheckAggregate())
  77. return null;
  78. return GetAggregateValue(ColumnItem.Index, rowItem.Index);
  79. }
  80. /// <summary>
  81. /// Gets value of the first column. This method is for internal use only.
  82. /// </summary>
  83. /// <param name="dummy">Dummy parameter.</param>
  84. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  85. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  86. /// <returns>The value or null.</returns>
  87. public dynamic GetFirstColumn(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  88. {
  89. HeaderData firstColumnItem = ColumnItem.GetFirstItem(useIneractiveSort, useThisGroup);
  90. if (firstColumnItem == null)
  91. return null;
  92. if (!CheckAggregate())
  93. return null;
  94. return GetAggregateValue(firstColumnItem.Index, RowItem.Index);
  95. }
  96. /// <summary>
  97. /// Gets value of the last column. This method is for internal use only.
  98. /// </summary>
  99. /// <param name="dummy">Dummy parameter.</param>
  100. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  101. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  102. /// <returns>The value or null.</returns>
  103. public dynamic GetLastColumn(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  104. {
  105. HeaderData lastColumnItem = ColumnItem.GetLastItem(useIneractiveSort, useThisGroup);
  106. if (lastColumnItem == null)
  107. return null;
  108. if (!CheckAggregate())
  109. return null;
  110. return GetAggregateValue(lastColumnItem.Index, RowItem.Index);
  111. }
  112. /// <summary>
  113. /// Gets value of the first row. This method is for internal use only.
  114. /// </summary>
  115. /// <param name="dummy">Dummy parameter.</param>
  116. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  117. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  118. /// <returns>The value or null.</returns>
  119. public dynamic GetFirstRow(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  120. {
  121. HeaderData firstRowItem = RowItem.GetFirstItem(useIneractiveSort, useThisGroup);
  122. if (firstRowItem == null)
  123. return null;
  124. if (!CheckAggregate())
  125. return null;
  126. return GetAggregateValue(ColumnItem.Index, firstRowItem.Index);
  127. }
  128. /// <summary>
  129. /// Gets value of the last row. This method is for internal use only.
  130. /// </summary>
  131. /// <param name="dummy">Dummy parameter.</param>
  132. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  133. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  134. /// <returns>The value or null.</returns>
  135. public dynamic GetLastRow(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  136. {
  137. HeaderData lastRowItem = RowItem.GetLastItem(useIneractiveSort, useThisGroup);
  138. if (lastRowItem == null)
  139. return null;
  140. if (!CheckAggregate())
  141. return null;
  142. return GetAggregateValue(ColumnItem.Index, lastRowItem.Index);
  143. }
  144. /// <summary>
  145. /// Gets value of previous column. This method is for internal use only.
  146. /// </summary>
  147. /// <param name="dummy">Dummy parameter.</param>
  148. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  149. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  150. /// <returns>The value or null.</returns>
  151. public dynamic GetPreviousColumn(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  152. {
  153. HeaderData previousColumnItem = ColumnItem.GetPreviousItem(useIneractiveSort, useThisGroup);
  154. if (previousColumnItem == null)
  155. return null;
  156. if (!CheckAggregate())
  157. return null;
  158. return GetAggregateValue(previousColumnItem.Index, RowItem.Index);
  159. }
  160. /// <summary>
  161. /// Gets value of previous row. This method is for internal use only.
  162. /// </summary>
  163. /// <param name="dummy">Dummy parameter.</param>
  164. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  165. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  166. /// <returns>The value or null.</returns>
  167. public dynamic GetPreviousRow(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  168. {
  169. HeaderData previousRowItem = RowItem.GetPreviousItem(useIneractiveSort, useThisGroup);
  170. if (previousRowItem == null)
  171. return null;
  172. if (!CheckAggregate())
  173. return null;
  174. return GetAggregateValue(ColumnItem.Index, previousRowItem.Index);
  175. }
  176. /// <summary>
  177. /// Gets value of next column. This method is for internal use only.
  178. /// </summary>
  179. /// <param name="dummy">Dummy parameter.</param>
  180. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  181. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  182. /// <returns>The value or null.</returns>
  183. public dynamic GetNextColumn(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  184. {
  185. HeaderData nextColumnItem = ColumnItem.GetNextItem(useIneractiveSort, useThisGroup);
  186. if (nextColumnItem == null)
  187. return null;
  188. if (!CheckAggregate())
  189. return null;
  190. return GetAggregateValue(nextColumnItem.Index, RowItem.Index);
  191. }
  192. /// <summary>
  193. /// Gets value of next row. This method is for internal use only.
  194. /// </summary>
  195. /// <param name="dummy">Dummy parameter.</param>
  196. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  197. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  198. /// <returns>The value or null.</returns>
  199. public dynamic GetNextRow(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  200. {
  201. HeaderData nextRowItem = RowItem.GetNextItem(useIneractiveSort, useThisGroup);
  202. if (nextRowItem == null)
  203. return null;
  204. if (!CheckAggregate())
  205. return null;
  206. return GetAggregateValue(ColumnItem.Index, nextRowItem.Index);
  207. }
  208. /// <summary>
  209. /// Gets column total value. This method is for internal use only.
  210. /// </summary>
  211. /// <param name="dummy">Dummy parameter.</param>
  212. /// <returns>The value or null.</returns>
  213. public dynamic GetGrandColumnTotal(object dummy = null)
  214. {
  215. if (!CheckAggregate())
  216. return null;
  217. return GetAggregateValue(ColumnItem.Index, Descriptor.RowIndex);
  218. }
  219. /// <summary>
  220. /// Gets row total value. This method is for internal use only.
  221. /// </summary>
  222. /// <param name="dummy">Dummy parameter.</param>
  223. /// <returns>The value or null.</returns>
  224. public dynamic GetGrandRowTotal(object dummy = null)
  225. {
  226. if (!CheckAggregate())
  227. return null;
  228. return GetAggregateValue(Descriptor.ColumnIndex, RowItem.Index);
  229. }
  230. /// <summary>
  231. /// Gets grand total value. This method is for internal use only.
  232. /// </summary>
  233. /// <param name="dummy">Dummy parameter.</param>
  234. /// <returns>The value or null.</returns>
  235. public dynamic GetGrandTotal(object dummy = null)
  236. {
  237. if (!CheckAggregate())
  238. return null;
  239. return GetAggregateValue(Descriptor.ColumnIndex, Descriptor.RowIndex);
  240. }
  241. /// <summary>
  242. /// Gets column group total value. This method is for internal use only.
  243. /// </summary>
  244. /// <param name="dummy">Dummy parameter.</param>
  245. /// <returns>The value or null.</returns>
  246. public dynamic GetColumnTotal(object dummy = null)
  247. {
  248. if (!CheckAggregate())
  249. return null;
  250. int rowIndex = RowItem.Parent.Index;
  251. if (rowIndex == 0)
  252. rowIndex = Descriptor.RowIndex;
  253. return GetAggregateValue(ColumnItem.Index, rowIndex);
  254. }
  255. /// <summary>
  256. /// Gets row group total value. This method is for internal use only.
  257. /// </summary>
  258. /// <param name="dummy">Dummy parameter.</param>
  259. /// <returns>The value or null.</returns>
  260. public dynamic GetRowTotal(object dummy = null)
  261. {
  262. if (!CheckAggregate())
  263. return null;
  264. int columnIndex = ColumnItem.Parent.Index;
  265. if (columnIndex == 0)
  266. columnIndex = Descriptor.ColumnIndex;
  267. return GetAggregateValue(columnIndex, RowItem.Index);
  268. }
  269. /// <summary>
  270. /// Gets column group max value. This method is for internal use only.
  271. /// </summary>
  272. /// <param name="dummy">Dummy parameter.</param>
  273. /// <returns>The value or null.</returns>
  274. public dynamic GetColumnMaxValue(object dummy = null)
  275. {
  276. if (!CheckAggregate())
  277. return null;
  278. dynamic maxValue = null;
  279. HeaderDataList parent = RowItem.GetGroup();
  280. if (parent != null)
  281. {
  282. foreach (HeaderData d in parent)
  283. {
  284. dynamic value = GetAggregateValue(ColumnItem.Index, d.Index);
  285. if (maxValue == null || maxValue < value)
  286. maxValue = value;
  287. }
  288. }
  289. return maxValue;
  290. }
  291. /// <summary>
  292. /// Gets column group min value. This method is for internal use only.
  293. /// </summary>
  294. /// <param name="dummy">Dummy parameter.</param>
  295. /// <returns>The value or null.</returns>
  296. public dynamic GetColumnMinValue(object dummy = null)
  297. {
  298. if (!CheckAggregate())
  299. return null;
  300. dynamic minValue = null;
  301. HeaderDataList parent = RowItem.GetGroup();
  302. if (parent != null)
  303. {
  304. foreach (HeaderData d in parent)
  305. {
  306. dynamic value = GetAggregateValue(ColumnItem.Index, d.Index);
  307. if (minValue == null || minValue > value)
  308. minValue = value;
  309. }
  310. }
  311. return minValue;
  312. }
  313. /// <summary>
  314. /// Gets row group max value. This method is for internal use only.
  315. /// </summary>
  316. /// <param name="dummy">Dummy parameter.</param>
  317. /// <returns>The value or null.</returns>
  318. public dynamic GetRowMaxValue(object dummy = null)
  319. {
  320. if (!CheckAggregate())
  321. return null;
  322. dynamic maxValue = null;
  323. HeaderDataList parent = ColumnItem.GetGroup();
  324. if (parent != null)
  325. {
  326. foreach (HeaderData d in parent)
  327. {
  328. dynamic value = GetAggregateValue(d.Index, RowItem.Index);
  329. if (maxValue == null || maxValue < value)
  330. maxValue = value;
  331. }
  332. }
  333. return maxValue;
  334. }
  335. /// <summary>
  336. /// Gets row group min value. This method is for internal use only.
  337. /// </summary>
  338. /// <param name="dummy">Dummy parameter.</param>
  339. /// <returns>The value or null.</returns>
  340. public dynamic GetRowMinValue(object dummy = null)
  341. {
  342. if (!CheckAggregate())
  343. return null;
  344. dynamic minValue = null;
  345. HeaderDataList parent = ColumnItem.GetGroup();
  346. if (parent != null)
  347. {
  348. foreach (HeaderData d in parent)
  349. {
  350. dynamic value = GetAggregateValue(d.Index, RowItem.Index);
  351. if (minValue == null || minValue > value)
  352. minValue = value;
  353. }
  354. }
  355. return minValue;
  356. }
  357. /// <summary>
  358. /// Gets percent of column total. This method is for internal use only.
  359. /// </summary>
  360. /// <param name="dummy">Dummy parameter.</param>
  361. /// <returns>The value.</returns>
  362. public dynamic GetPercentOfColumnTotal(object dummy = null)
  363. {
  364. if (!CheckAggregate())
  365. return null;
  366. return Div(GetAggregateValue(ColumnItem.Index, RowItem.Index), GetColumnTotal());
  367. }
  368. /// <summary>
  369. /// Gets percent of row total. This method is for internal use only.
  370. /// </summary>
  371. /// <param name="dummy">Dummy parameter.</param>
  372. /// <returns>The value.</returns>
  373. public dynamic GetPercentOfRowTotal(object dummy = null)
  374. {
  375. if (!CheckAggregate())
  376. return null;
  377. return Div(GetAggregateValue(ColumnItem.Index, RowItem.Index), GetRowTotal());
  378. }
  379. /// <summary>
  380. /// Gets percent of grand total. This method is for internal use only.
  381. /// </summary>
  382. /// <param name="dummy">Dummy parameter.</param>
  383. /// <returns>The value.</returns>
  384. public dynamic GetPercentOfGrandTotal(object dummy = null)
  385. {
  386. if (!CheckAggregate())
  387. return null;
  388. return Div(GetAggregateValue(ColumnItem.Index, RowItem.Index), GetGrandTotal());
  389. }
  390. /// <summary>
  391. /// Gets percent of previous column. This method is for internal use only.
  392. /// </summary>
  393. /// <param name="dummy">Dummy parameter.</param>
  394. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  395. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  396. /// <returns>The value or null.</returns>
  397. public dynamic GetPercentOfPreviousColumn(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  398. {
  399. if (!CheckAggregate())
  400. return null;
  401. return Div(GetAggregateValue(ColumnItem.Index, RowItem.Index), GetPreviousColumn(dummy, useIneractiveSort, useThisGroup));
  402. }
  403. /// <summary>
  404. /// Gets percent of previous row. This method is for internal use only.
  405. /// </summary>
  406. /// <param name="dummy">Dummy parameter.</param>
  407. /// <param name="useIneractiveSort">Determines if the interactive sort must be respected.</param>
  408. /// <param name="useThisGroup">Determines if the same level group should be used to search for item.</param>
  409. /// <returns>The value or null.</returns>
  410. public dynamic GetPercentOfPreviousRow(object dummy = null, bool useIneractiveSort = false, bool useThisGroup = true)
  411. {
  412. if (!CheckAggregate())
  413. return null;
  414. return Div(GetAggregateValue(ColumnItem.Index, RowItem.Index), GetPreviousRow(dummy, useIneractiveSort, useThisGroup));
  415. }
  416. }
  417. }