chart_generator.php 35 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220
  1. <?php
  2. /**
  3. * Class ChartGenerator
  4. */
  5. class ChartGenerator {
  6. public const COLOUR_GREEN = "#4CAF50";
  7. public const COLOUR_RED = "#F44336";
  8. public const COLOUR_YELLOW = "#FFEB3B";
  9. public const COLOUR_LIGHT_GREY = "#CCCCCC";
  10. public const COLOUR_LIGHT_RED = "#FFAB91";
  11. public const COLOUR_ORANGE = "#FBC02D";
  12. public const COLOUR_BLUE = "#2196F3";
  13. public const COLOUR_MAGENTA = "#E91E63";
  14. public const COLOUR_DARK_BLUE = "#3F51B5";
  15. public const COLOUR_PURPLE = "#9C27B0";
  16. public const COLOUR_GREY = "#9E9E9E";
  17. public const COLOUR_CYAN = "#00BCD4";
  18. /** @var object $totalData */
  19. private $totalData;
  20. /** @var array $periodicData */
  21. private $periodicData;
  22. /** @var string $dateRangeLabel */
  23. private $dateRangeLabel;
  24. /** @var string $resolutionName */
  25. private $resolutionName;
  26. /** @var string[] $xDataLabels */
  27. private $xDataLabels;
  28. /** @var string[] $periodKeys */
  29. private $periodKeys;
  30. /** @var string[] $periodLabels */
  31. private $periodLabels;
  32. /** @var array $regionData */
  33. private $regionData;
  34. /** @var array $areaManagerData */
  35. private $areaManagerData;
  36. /** @var Template $template */
  37. private $template;
  38. public static function getVenueTypePassFailChart(array $venue_type_data): Chart {
  39. $chart = new Chart();
  40. $chart->addXAxis([
  41. "type" => "category",
  42. "stacked" => true,
  43. ]);
  44. $chart->addYAxis([
  45. "id" => "y-axis-1",
  46. "tick_config" => ["min" => 0, "max" => 100],
  47. "stacked" => true,
  48. ]);
  49. $get_rates = static function(string $column) use ($venue_type_data) {
  50. return array_values(array_map(static function($d) use ($column) {
  51. if($d["testCount"] === 0) return 0;
  52. return round(($d[$column] / $d["testCount"]) * 100);
  53. }, $venue_type_data));
  54. };
  55. $pass_rates = $get_rates("passCount");
  56. $fail_rates = $get_rates("failCount");
  57. $chart->setType("bar");
  58. $chart->setTitle("Pass / Fail by Venue Type");
  59. $chart->setLabels(array_keys($venue_type_data));
  60. $chart->addDataset("Pass Rate (%)", $pass_rates, ["background_colours" => self::COLOUR_GREEN]);
  61. $chart->addDataset("Fail Rate (%)", $fail_rates, ["background_colours" => self::COLOUR_RED]);
  62. $chart->setDatalabelSuffixes("%", "%");
  63. return $chart;
  64. }
  65. public function getVenueTypeChallengeStageStackedBarChart(array $venue_type_data): ?Chart {
  66. $field = $this->template->getChallengeStageField();
  67. if(!$field) {
  68. return null;
  69. }
  70. $x_labels = $field->displayStrings;
  71. array_shift($x_labels); // Remove placeholder string
  72. $chart = new Chart();
  73. $chart->addXAxis([
  74. "type" => "category",
  75. "stacked" => true,
  76. ]);
  77. $chart->addYAxis([
  78. "id" => "y-axis-1",
  79. // "tick_config" => ["min" => 0, "max" => 100],
  80. "stacked" => true,
  81. ]);
  82. $get_rates = static function(string $stage_index) use ($venue_type_data) {
  83. return array_values(array_map(static function($d) use ($stage_index) {
  84. $total_count = array_sum($d["stageCounts"]);
  85. if($total_count === 0) return 0;
  86. return round(($d["stageCounts"][$stage_index] / $total_count) * 100);
  87. }, $venue_type_data));
  88. };
  89. $bg_colours = [
  90. self::COLOUR_GREEN,
  91. self::COLOUR_YELLOW,
  92. self::COLOUR_ORANGE,
  93. self::COLOUR_LIGHT_RED,
  94. self::COLOUR_RED,
  95. ];
  96. $chart->setType("bar");
  97. $chart->setTitle("Stage % by Venue Type");
  98. $chart->setLabels(array_keys($venue_type_data));
  99. foreach($x_labels as $stage_index => $label) {
  100. $chart->addDataset("$label (%)", $get_rates($stage_index), ["background_colours" => $bg_colours[$stage_index]]);
  101. }
  102. $suffixes = array_fill(0, count($x_labels), "%");
  103. $chart->setDatalabelSuffixes(...$suffixes);
  104. return $chart;
  105. }
  106. public function getVenueTypeChallengeStagePieCharts(array $venue_type_data): array {
  107. $field = $this->template->getChallengeStageField();
  108. if(!$field) {
  109. return [];
  110. }
  111. $x_labels = $field->displayStrings;
  112. array_shift($x_labels); // Remove placeholder string
  113. $charts = [];
  114. foreach($venue_type_data as $venue_type => $data) {
  115. $values = $data["stageCounts"];
  116. $chart = new Chart();
  117. $chart->setType("pie");
  118. $chart->setTitle("Tests by Stage - $venue_type ({$this->dateRangeLabel})");
  119. $chart->setLabels($x_labels);
  120. $chart->addDataset("Counts", $values, [
  121. "background_colours" => [
  122. self::COLOUR_GREEN,
  123. self::COLOUR_YELLOW,
  124. self::COLOUR_ORANGE,
  125. self::COLOUR_LIGHT_RED,
  126. self::COLOUR_RED,
  127. ],
  128. "datalabels" => Chart::DATALABELS_BOX,
  129. ]);
  130. $charts[] = $chart;
  131. }
  132. return $charts;
  133. }
  134. public function __construct(object $total_data, array $periodic_data) {
  135. $this->totalData = $total_data;
  136. $this->periodicData = $periodic_data;
  137. $this->xDataLabels = array_values(array_map(static function($d) {
  138. return $d->label;
  139. }, $this->periodicData));
  140. }
  141. public function setDateRangeLabel(string $label): void {
  142. $this->dateRangeLabel = $label;
  143. }
  144. public function setResolutionName(string $name): void {
  145. $this->resolutionName = $name;
  146. }
  147. public function setPeriodKeysAndLabels(array $keys, array $labels): void {
  148. $this->periodKeys = $keys;
  149. $this->periodLabels = $labels;
  150. }
  151. public function setRegionData(array $data): void {
  152. ksort($data, SORT_NATURAL);
  153. $this->regionData = $data;
  154. }
  155. public function setAreaManagerData(array $data): void {
  156. ksort($data, SORT_NATURAL);
  157. $this->areaManagerData = $data;
  158. }
  159. // Charts
  160. public function getTestsByStageChart(): Chart {
  161. $chart = new Chart;
  162. $chart->setType("doughnut");
  163. $chart->setTitle("Tests by Stage ({$this->dateRangeLabel})");
  164. $chart->setLabels(["1 - On Entry", "2 - While Browsing", "3 - During Play", "4 - On Exit", "5 - No Challenge"]);
  165. $chart->addDataset("Tests", [
  166. $this->totalData->stage1Count,
  167. $this->totalData->stage2Count,
  168. $this->totalData->stage3Count,
  169. $this->totalData->stage4Count,
  170. $this->totalData->stage5Count,
  171. ], [
  172. "background_colours" => [
  173. self::COLOUR_GREEN,
  174. self::COLOUR_YELLOW,
  175. self::COLOUR_ORANGE,
  176. self::COLOUR_LIGHT_RED,
  177. self::COLOUR_RED,
  178. ],
  179. "datalabels" => Chart::DATALABELS_BOX,
  180. ]);
  181. $chart->setPrintSuffixes("");
  182. $chart->print = true;
  183. $chart->printPercentages = true;
  184. $chart->printTotalColumn = true;
  185. $chart->setPrintLabels(["Stage 1", "Stage 2", "Stage 3", "Stage 4", "Stage 5"]);
  186. return $chart;
  187. }
  188. public function getChallengerGenderChart(): Chart {
  189. $chart = new Chart;
  190. $chart->setType("pie");
  191. $chart->setTitle("Staff Gender ({$this->dateRangeLabel})");
  192. $chart->setLabels(["Male", "Female", "Unspecified"]);
  193. $chart->addDataset("Counts", [
  194. $this->totalData->maleChallengerCount,
  195. $this->totalData->femaleChallengerCount,
  196. $this->totalData->unspecifiedChallengerCount,
  197. ], [
  198. "background_colours" => [
  199. self::COLOUR_BLUE,
  200. self::COLOUR_MAGENTA,
  201. self::COLOUR_GREY,
  202. ],
  203. "datalabels" => Chart::DATALABELS_BOX,
  204. ]);
  205. return $chart;
  206. }
  207. public function getTesterGenderChart(): Chart {
  208. $chart = new Chart;
  209. $chart->setType("pie");
  210. $chart->setTitle("Tester Gender ({$this->dateRangeLabel})");
  211. $chart->setLabels(["Male", "Female"]);
  212. $chart->addDataset("Counts", [
  213. $this->totalData->maleTesterCount,
  214. $this->totalData->femaleTesterCount,
  215. ], [
  216. "background_colours" => [
  217. self::COLOUR_BLUE,
  218. self::COLOUR_MAGENTA,
  219. ],
  220. "datalabels" => Chart::DATALABELS_BOX,
  221. ]);
  222. return $chart;
  223. }
  224. public function getPassFailCountChart(): Chart {
  225. $data = $this->totalData;
  226. $dataset = [$data->passCount, $data->failCount];
  227. $labels = ["Pass", "Fail"];
  228. $colours = [self::COLOUR_GREEN, self::COLOUR_RED];
  229. if($data->voidCount > 0) {
  230. $dataset[] = $data->voidCount;
  231. $labels[] = "Void";
  232. $colours[] = self::COLOUR_GREY;
  233. }
  234. $chart = new Chart;
  235. $chart->setType("pie");
  236. $chart->setTitle("Pass / Fail ({$this->dateRangeLabel})");
  237. $chart->setLabels($labels);
  238. $chart->addDataset("Counts", $dataset, [
  239. "background_colours" => $colours,
  240. "datalabels" => Chart::DATALABELS_BOX,
  241. ]);
  242. return $chart;
  243. }
  244. public function getPeriodicPassFailRateChart(): Chart {
  245. $chart = new Chart;
  246. $chart->addXAxis([
  247. "type" => "category",
  248. "stacked" => true,
  249. ]);
  250. $chart->addYAxis([
  251. "id" => "y-axis-1",
  252. "tick_config" => ["min" => 0, "max" => 100],
  253. "stacked" => true,
  254. ]);
  255. $chart->setType("bar");
  256. $chart->setTitle("Pass / Fail by {$this->resolutionName}");
  257. $chart->setLabels($this->xDataLabels);
  258. $chart->addDataset("Pass Rate (%)", $this->getPeriodicPassRates(), [
  259. "background_colours" => self::COLOUR_GREEN
  260. ]);
  261. $chart->addDataset("Fail Rate (%)", $this->getPeriodicFailRates(), [
  262. "background_colours" => self::COLOUR_RED
  263. ]);
  264. $chart->setDatalabelSuffixes("%", "%");
  265. return $chart;
  266. }
  267. public function getPeriodicDoorSensorAlertPassRateChart(): Chart {
  268. return $this->getPeriodicPassRateChart(
  269. "Pass Rate by Door Sensor Alert",
  270. $this->getPeriodicPassRateByDoorSensorAlert(1),
  271. $this->getPeriodicPassRateByDoorSensorAlert(0),
  272. $this->getPeriodicPassRateByDoorSensorAlert(2)
  273. );
  274. }
  275. public function getPeriodicMachinePowerChart(): Chart {
  276. return $this->getPeriodicBooleanChart(
  277. "Machines Powered",
  278. $this->getMachinePowerRates()
  279. );
  280. }
  281. public function getPeriodicMachineSeatChart(): Chart {
  282. return $this->getPeriodicBooleanChart(
  283. "Machine Seating",
  284. $this->getMachineSeatRates()
  285. );
  286. }
  287. public function getPeriodicMachineTableChart(): Chart {
  288. return $this->getPeriodicBooleanChart(
  289. "Machine Table/Shelf",
  290. $this->getMachineTableRates()
  291. );
  292. }
  293. public function getPeriodicMachineAccessibleChart(): Chart {
  294. return $this->getPeriodicBooleanChart(
  295. "Machines Accessible",
  296. $this->getMachineAccessibleRates()
  297. );
  298. }
  299. public function getPeriodicEyeContactPassRateChart(): Chart {
  300. return $this->getPeriodicPassRateChart(
  301. "Pass Rate by Eye Contact",
  302. $this->getPeriodicPassRateByEyeContact(1),
  303. $this->getPeriodicPassRateByEyeContact(0),
  304. $this->getPeriodicPassRateByEyeContact(2)
  305. );
  306. }
  307. public function getPeriodicLineOfSightPassRateChart(): Chart {
  308. return $this->getPeriodicPassRateChart(
  309. "Pass Rate by Line of Sight",
  310. $this->getPeriodicPassRateByLineOfSight(1),
  311. $this->getPeriodicPassRateByLineOfSight(0),
  312. $this->getPeriodicPassRateByLineOfSight(2)
  313. );
  314. }
  315. public function getPeriodicBarPurchasePassRateChart(): Chart {
  316. return $this->getPeriodicPassRateChart(
  317. "Pass Rate by Bar Purchase",
  318. $this->getPeriodicPassRateByBarPurchase(1),
  319. $this->getPeriodicPassRateByBarPurchase(0),
  320. $this->getPeriodicPassRateByBarPurchase(2)
  321. );
  322. }
  323. public function getPeriodicBooleanPassRateChart(array $rates, string $title): Chart {
  324. $chart = new Chart;
  325. $chart->addXAxis([
  326. "type" => "category",
  327. "stacked" => true,
  328. ]);
  329. $chart->addYAxis([
  330. "id" => "y-axis-1",
  331. "tick_config" => ["min" => 0, "max" => 100],
  332. "stacked" => true,
  333. ]);
  334. $chart->setType("bar");
  335. $chart->setTitle($title);
  336. $chart->setLabels($this->xDataLabels);
  337. $chart->addDataset("Yes (%)", array_column($rates, 0), [
  338. "background_colours" => self::COLOUR_GREEN
  339. ]);
  340. $chart->addDataset("No (%)", array_column($rates, 1), [
  341. "background_colours" => self::COLOUR_RED
  342. ]);
  343. $chart->setDatalabelSuffixes("%", "%");
  344. return $chart;
  345. }
  346. public function getPeriodicEyeContactChart(): Chart {
  347. return $this->getPeriodicBooleanChart(
  348. "Eye Contact by {$this->resolutionName}",
  349. $this->getEyeContactRates()
  350. );
  351. }
  352. public function getPeriodicTotalsChart(): Chart {
  353. $test_counts = $this->getPeriodicTestCounts();
  354. $pass_rates = $this->getPeriodicPassRates();
  355. $pass_counts = $this->getPeriodicPassCounts();
  356. $fail_counts = $this->getPeriodicFailCounts();
  357. $chart = new Chart;
  358. $chart->setType("bar");
  359. $chart->setTitle("Totals by {$this->resolutionName}");
  360. $chart->setLabels($this->xDataLabels);
  361. $chart->addYAxis([
  362. "id" => "y-axis-1",
  363. "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10]
  364. ]);
  365. $chart->addYAxis([
  366. "position" => "right",
  367. "id" => "y-axis-2",
  368. "grid_lines" => false,
  369. "tick_config" => ["min" => 0, "max" => 100]
  370. ]);
  371. $chart->addDataset("Pass Rate (%)", $pass_rates, [
  372. "border_colours" => self::COLOUR_YELLOW,
  373. "background_colours" => "transparent",
  374. "type" => "line",
  375. "y_axis_id" => "y-axis-2",
  376. "datalabels" => [
  377. "display" => false
  378. ],
  379. "line_tension" => 0,
  380. ]);
  381. $chart->addDataset("Test Count", $test_counts, [
  382. "background_colours" => self::COLOUR_BLUE,
  383. "type" => "bar",
  384. "y_axis_id" => "y-axis-1",
  385. "datalabels" => [
  386. "display" => false
  387. ],
  388. ]);
  389. $chart->addDataset("Pass", $pass_counts, [
  390. "background_colours" => self::COLOUR_GREEN,
  391. "type" => "bar",
  392. "y_axis_id" => "y-axis-1",
  393. "datalabels" => [
  394. "display" => false
  395. ],
  396. ]);
  397. $chart->addDataset("Fail", $fail_counts, [
  398. "background_colours" => self::COLOUR_RED,
  399. "type" => "bar",
  400. "y_axis_id" => "y-axis-1",
  401. "datalabels" => [
  402. "display" => false
  403. ],
  404. ]);
  405. $chart->setDatalabelSuffixes("%", "", "", "");
  406. $chart->print = true;
  407. return $chart;
  408. }
  409. /**
  410. * @return Chart[]
  411. * @throws Exception
  412. */
  413. public function getPointOfChallengeCharts(): array {
  414. $charts = [];
  415. foreach($this->periodKeys as $index => $key) {
  416. $key_label = $this->periodLabels[$index];
  417. $period_data = $this->periodicData[$key];
  418. if($period_data->testCount === 0) continue;
  419. $chart = new Chart;
  420. $chart->setType("pie");
  421. $chart->setTitle("$key_label Point of Challenge");
  422. $chart->setLabels(["On Entry", "While Browsing", "During Play", "On Exit", "No Challenge"]);
  423. $chart->addDataset("Counts", [
  424. $period_data->stage1Count,
  425. $period_data->stage2Count,
  426. $period_data->stage3Count,
  427. $period_data->stage4Count,
  428. $period_data->stage5Count,
  429. ], [
  430. "background_colours" => [
  431. self::COLOUR_GREEN,
  432. self::COLOUR_YELLOW,
  433. self::COLOUR_ORANGE,
  434. self::COLOUR_LIGHT_RED,
  435. self::COLOUR_RED,
  436. ],
  437. "datalabels" => Chart::DATALABELS_BOX,
  438. ]);
  439. $charts[] = $chart;
  440. }
  441. return $charts;
  442. }
  443. public function getPeriodicTesterGenderChart(): Chart {
  444. $male_counts = $this->getPeriodicMaleTesterCount();
  445. $female_counts = $this->getPeriodicFemaleTesterCount();
  446. $counts = array_merge($male_counts, $female_counts);
  447. $chart = new Chart;
  448. $chart->addYAxis([
  449. "id" => "y-axis-1",
  450. "tick_config" => ["min" => 0, "max" => ceil(max($counts) / 10) * 10]
  451. ]);
  452. $chart->setType("bar");
  453. $chart->setTitle("Tester Gender by {$this->resolutionName}");
  454. $chart->setLabels($this->xDataLabels);
  455. $chart->addDataset("Male", $male_counts, [
  456. "background_colours" => self::COLOUR_BLUE
  457. ]);
  458. $chart->addDataset("Female", $female_counts, [
  459. "background_colours" => self::COLOUR_MAGENTA
  460. ]);
  461. return $chart;
  462. }
  463. public function getPeriodicTestCountChart(): Chart {
  464. $test_counts = $this->getPeriodicTestCounts();
  465. $chart = new Chart;
  466. $chart->addYAxis([
  467. "id" => "y-axis-1",
  468. "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10]
  469. ]);
  470. $chart->setType("bar");
  471. $chart->setTitle("Tests by {$this->resolutionName}");
  472. $chart->setLabels($this->xDataLabels);
  473. $chart->addDataset("Tests", $test_counts, [
  474. "background_colours" => self::COLOUR_BLUE
  475. ]);
  476. return $chart;
  477. }
  478. public function getGenderComparisonCharts(): array {
  479. $charts = [];
  480. $gender_keys = [
  481. "maleChallengeMale" => [
  482. "title" => "Male Challenge Male",
  483. "label" => "M Cha. M",
  484. ],
  485. "maleChallengeFemale" => [
  486. "title" => "Male Challenge Female",
  487. "label" => "M Cha. F",
  488. ],
  489. "femaleChallengeMale" => [
  490. "title" => "Female Challenge Male",
  491. "label" => "F Cha. M",
  492. ],
  493. "femaleChallengeFemale" => [
  494. "title" => "Female Challenge Female",
  495. "label" => "F Cha. F",
  496. ],
  497. "unknownChallenge" => [
  498. "title" => "Gender Not Specified",
  499. "label" => "Gender Not Specified",
  500. ],
  501. ];
  502. $gender_test_counts = [];
  503. foreach($gender_keys as $gk => $gv) {
  504. $gender_test_counts[] = array_sum(array_column($this->periodicData, "{$gk}Count"));
  505. }
  506. // Gender Comparison by Date Range
  507. $chart = new Chart;
  508. $chart->addYAxis([
  509. "id" => "y-axis-1",
  510. "tick_config" => ["min" => 0, "max" => ceil(max($gender_test_counts) / 10) * 10]
  511. ]);
  512. $chart->setType("bar");
  513. $chart->setTitle("Gender Comparison ({$this->dateRangeLabel})");
  514. $chart->setLabels(array_column($gender_keys, "label"));
  515. $chart->addDataset("Tests", $gender_test_counts, [
  516. "background_colours" => self::COLOUR_BLUE
  517. ]);
  518. $charts[] = $chart;
  519. // Gender Comparison by Resolution
  520. $mcm_counts = array_column($this->periodicData, "maleChallengeMaleCount");
  521. $mcf_counts = array_column($this->periodicData, "maleChallengeFemaleCount");
  522. $fcm_counts = array_column($this->periodicData, "femaleChallengeMaleCount");
  523. $fcf_counts = array_column($this->periodicData, "femaleChallengeFemaleCount");
  524. $ns_counts = array_column($this->periodicData, "unknownChallengeCount");
  525. $counts = array_merge($mcm_counts, $mcf_counts, $fcm_counts, $fcf_counts);
  526. $chart = new Chart;
  527. $chart->addYAxis([
  528. "id" => "y-axis-1",
  529. "tick_config" => ["min" => 0, "max" => ceil(max($counts) / 10) * 10]
  530. ]);
  531. $chart->setType("bar");
  532. $chart->setTitle("Gender Comparison by {$this->resolutionName}");
  533. $chart->setLabels($this->xDataLabels);
  534. $chart->addDataset("M Cha. M", $mcm_counts, ["background_colours" => self::COLOUR_BLUE]);
  535. $chart->addDataset("M Cha. F", $mcf_counts, ["background_colours" => self::COLOUR_DARK_BLUE]);
  536. $chart->addDataset("F Cha. M", $fcm_counts, ["background_colours" => self::COLOUR_PURPLE]);
  537. $chart->addDataset("F Cha. F", $fcf_counts, ["background_colours" => self::COLOUR_MAGENTA]);
  538. $chart->addDataset("Not Specified", $ns_counts, ["background_colours" => self::COLOUR_GREY]);
  539. $chart->print = true;
  540. $charts[] = $chart;
  541. // Gender Comparison Pass Rate by Resolution
  542. /** @noinspection PhpUnusedLocalVariableInspection */
  543. {
  544. $mcm_pass_counts = array_column($this->periodicData, "maleChallengeMalePassCount");
  545. $mcf_pass_counts = array_column($this->periodicData, "maleChallengeFemalePassCount");
  546. $fcm_pass_counts = array_column($this->periodicData, "femaleChallengeMalePassCount");
  547. $fcf_pass_counts = array_column($this->periodicData, "femaleChallengeFemalePassCount");
  548. $ns_pass_counts = array_column($this->periodicData, "unknownChallengePassCount");
  549. }
  550. /**
  551. * @var float $mcm_pass_rates
  552. * @var float $mcf_pass_rates
  553. * @var float $fcm_pass_rates
  554. * @var float $fcf_pass_rates
  555. * @var float $ns_pass_rates
  556. */
  557. foreach(["mcm", "mcf", "fcm", "fcf", "ns"] as $prefix) {
  558. $pass_rates = [];
  559. $pass_counts = ${$prefix . "_pass_counts"};
  560. $test_counts = ${$prefix . "_counts"};
  561. foreach($test_counts as $index => $test_count) {
  562. if($test_count === 0) {
  563. $pass_rates[] = 0;
  564. continue;
  565. }
  566. $pass_rates[] = number_format(($pass_counts[$index] * 100) / $test_count, 2);
  567. }
  568. ${$prefix . "_pass_rates"} = $pass_rates;
  569. }
  570. $chart = new Chart;
  571. $chart->addYAxis([
  572. "id" => "y-axis-1",
  573. "tick_config" => ["min" => 0, "max" => 100],
  574. ]);
  575. $chart->setType("bar");
  576. $chart->setTitle("Gender Comparison Pass Rate by {$this->resolutionName}");
  577. $chart->setLabels($this->xDataLabels);
  578. $chart->addDataset("M Cha. M", $mcm_pass_rates, ["background_colours" => self::COLOUR_BLUE, "datalabels" => ["display" => false], "line_tension" => 0]);
  579. $chart->addDataset("M Cha. F", $mcf_pass_rates, ["background_colours" => self::COLOUR_DARK_BLUE, "datalabels" => ["display" => false], "line_tension" => 0]);
  580. $chart->addDataset("F Cha. M", $fcm_pass_rates, ["background_colours" => self::COLOUR_PURPLE, "datalabels" => ["display" => false], "line_tension" => 0]);
  581. $chart->addDataset("F Cha. F", $fcf_pass_rates, ["background_colours" => self::COLOUR_MAGENTA, "datalabels" => ["display" => false], "line_tension" => 0]);
  582. $chart->addDataset("Not Specified", $ns_pass_rates, ["background_colours" => self::COLOUR_GREY, "datalabels" => ["display" => false], "line_tension" => 0]);
  583. $chart->print = true;
  584. $chart->setDatalabelSuffixes("%", "%", "%", "%", "%");
  585. $charts[] = $chart;
  586. // Gender Comparison Point of Challenge
  587. foreach($this->periodKeys as $index => $key) {
  588. $key_label = $this->periodLabels[$index];
  589. $period_data = $this->periodicData[$key];
  590. foreach($gender_keys as $prefix => $gv) {
  591. $title = $gv["label"];
  592. $test_count = $period_data->{$prefix . "Count"};
  593. $stage_data = $period_data->{$prefix . "Stages"};
  594. if($test_count === 0) continue;
  595. $chart = new Chart;
  596. $chart->setType("pie");
  597. $chart->setTitle("$key_label $title Point of Challenge");
  598. $chart->setLabels(["On Entry", "While Browsing", "During Play", "On Exit", "No Challenge"]);
  599. $chart->addDataset("Counts", $stage_data, [
  600. "background_colours" => [
  601. self::COLOUR_GREEN,
  602. self::COLOUR_YELLOW,
  603. self::COLOUR_ORANGE,
  604. self::COLOUR_LIGHT_RED,
  605. self::COLOUR_RED,
  606. ],
  607. "datalabels" => Chart::DATALABELS_BOX,
  608. ]);
  609. $charts[] = $chart;
  610. }
  611. }
  612. return $charts;
  613. }
  614. public function hasRegionData(): bool {
  615. return $this->regionData !== null;
  616. }
  617. public function getRegionPassRateChart(): Chart {
  618. $data_values = [];
  619. $test_counts = [];
  620. $pass_counts = [];
  621. $fail_counts = [];
  622. foreach($this->regionData as $r_data) {
  623. $total_region_test_count = array_sum(array_column($r_data, "testCount"));
  624. $total_region_pass_count = array_sum(array_column($r_data, "passCount"));
  625. $test_counts[] = $total_region_test_count;
  626. $pass_counts[] = $total_region_pass_count;
  627. $fail_counts[] = $total_region_test_count - $total_region_pass_count;
  628. $data_values[] = ($total_region_test_count === 0) ? 0 : round(($total_region_pass_count * 100) / $total_region_test_count);
  629. }
  630. $chart = new Chart;
  631. $chart->addYAxis([
  632. "id" => "y-axis-1",
  633. "tick_config" => ["min" => 0, "max" => 100]
  634. ]);
  635. $chart->setType("bar");
  636. $chart->setTitle("Region Pass Rate ({$this->dateRangeLabel})");
  637. $chart->setLabels($this->getRegionXDataLabels());
  638. $chart->addDataset("Pass %", $data_values , [
  639. "background_colours" => self::COLOUR_BLUE
  640. ]);
  641. $chart->addPrintDataset("Tests", $test_counts);
  642. $chart->addPrintDataset("Pass", $pass_counts);
  643. $chart->addPrintDataset("Fail", $fail_counts);
  644. $chart->setDatalabelSuffixes("%");
  645. $chart->print = true;
  646. $chart->printTotalColumn = true;
  647. return $chart;
  648. }
  649. public function getPeriodicRegionPassRateChart(): Chart {
  650. $chart = new Chart;
  651. $chart->addYAxis([
  652. "id" => "y-axis-1",
  653. "tick_config" => ["min" => 0, "max" => 100]
  654. ]);
  655. $chart->setType("bar");
  656. $chart->setTitle("Region Pass Rate by {$this->resolutionName}");
  657. $chart->setLabels($this->getRegionXDataLabels());
  658. foreach($this->periodKeys as $index => $key) {
  659. $data_values = [];
  660. foreach($this->getRegionKeys() as $region) {
  661. $r_data = $this->regionData[$region][$key];
  662. $data_values[] = ($r_data->testCount === 0) ? 0 : round(($r_data->passCount * 100) / $r_data->testCount);
  663. }
  664. $chart->addDataset($this->periodLabels[$index], $data_values, ["background_colours" => Chart::COLOURS[$index]]);
  665. }
  666. $chart->setDatalabelSuffixes(...array_fill(0, count($this->periodKeys), "%"));
  667. return $chart;
  668. }
  669. public function hasAreaManagerData(): bool {
  670. return $this->areaManagerData !== null;
  671. }
  672. public function getAreaManagerPassRateChart(): Chart {
  673. // Area Pass Rate (Selected Date Range)
  674. $data_values = [];
  675. $test_counts = [];
  676. $pass_counts = [];
  677. $fail_counts = [];
  678. foreach($this->areaManagerData as $a_data) {
  679. $total_area_manager_test_count = array_sum(array_column($a_data, "testCount"));
  680. $total_area_manager_pass_count = array_sum(array_column($a_data, "passCount"));
  681. $total_area_manager_fail_count = array_sum(array_column($a_data, "failCount"));
  682. $test_counts[] = $total_area_manager_test_count;
  683. $pass_counts[] = $total_area_manager_pass_count;
  684. $fail_counts[] = $total_area_manager_fail_count;
  685. $data_values[] = ($total_area_manager_test_count === 0) ? 0 : round(($total_area_manager_pass_count * 100) / $total_area_manager_test_count);
  686. }
  687. $chart = new Chart;
  688. $chart->addXAxis([
  689. "type" => "category",
  690. "scale_label_config" => [
  691. "display" => true,
  692. "labelString" => "Area Manager",
  693. ]
  694. ]);
  695. $chart->addYAxis([
  696. "id" => "y-axis-1",
  697. "tick_config" => ["min" => 0, "max" => 100]
  698. ]);
  699. $chart->setType("bar");
  700. $chart->setTitle("Area Manager Pass Rate ({$this->dateRangeLabel})");
  701. $chart->setLabels($this->getAreaManagerXDataLabels());
  702. $chart->addDataset("Pass %", $data_values , [
  703. "background_colours" => self::COLOUR_BLUE
  704. ]);
  705. $chart->addPrintDataset("Tests", $test_counts);
  706. $chart->addPrintDataset("Pass", $pass_counts);
  707. $chart->addPrintDataset("Fail", $fail_counts);
  708. $chart->setDatalabelSuffixes("%");
  709. $chart->print = true;
  710. $chart->printTotalColumn = true;
  711. return $chart;
  712. }
  713. public function getPeriodicAreaManagerPassRateChart(): Chart {
  714. $chart = new Chart;
  715. $chart->addXAxis([
  716. "type" => "category",
  717. "scale_label_config" => [
  718. "display" => true,
  719. "labelString" => "Area Manager",
  720. ]
  721. ]);
  722. $chart->addYAxis([
  723. "id" => "y-axis-1",
  724. "tick_config" => ["min" => 0, "max" => 100]
  725. ]);
  726. $chart->setType("bar");
  727. $chart->setTitle("Area Manager Pass Rate by {$this->resolutionName}");
  728. $chart->setLabels($this->getAreaManagerXDataLabels());
  729. foreach($this->periodKeys as $index => $key) {
  730. $data_values = [];
  731. foreach($this->getAreaManagerKeys() as $area_manager) {
  732. $a_data = $this->areaManagerData[$area_manager][$key];
  733. $data_values[] = ($a_data->testCount === 0) ? 0 : round(($a_data->passCount * 100) / $a_data->testCount);
  734. }
  735. $chart->addDataset($this->periodLabels[$index], $data_values, [
  736. "background_colours" => Chart::COLOURS[$index],
  737. "datalabels" => [
  738. "display" => false,
  739. ],
  740. ]);
  741. }
  742. $chart->setDatalabelSuffixes(...array_fill(0, count($this->periodKeys), "%"));
  743. return $chart;
  744. }
  745. public function getCleanlinessChart(): Chart {
  746. $chart = new Chart;
  747. $chart->setType("doughnut");
  748. $chart->setTitle("Tests by Cleanliness ({$this->dateRangeLabel})");
  749. $chart->setLabels(["Very dirty", "Dirty", "Adequate", "Clean", "Very Clean"]);
  750. $chart->addDataset("Tests", [
  751. $this->totalData->cleanlinessCounts[0],
  752. $this->totalData->cleanlinessCounts[1],
  753. $this->totalData->cleanlinessCounts[2],
  754. $this->totalData->cleanlinessCounts[3],
  755. $this->totalData->cleanlinessCounts[4],
  756. ], [
  757. "background_colours" => [
  758. self::COLOUR_RED,
  759. self::COLOUR_LIGHT_RED,
  760. self::COLOUR_ORANGE,
  761. self::COLOUR_YELLOW,
  762. self::COLOUR_GREEN,
  763. ],
  764. "datalabels" => Chart::DATALABELS_BOX,
  765. ]);
  766. $chart->setPrintSuffixes("");
  767. $chart->print = true;
  768. $chart->printTotalColumn = true;
  769. $chart->printPercentages = true;
  770. return $chart;
  771. }
  772. /**
  773. * @return Chart[]
  774. * @throws Exception
  775. */
  776. public function getPeriodicCleanlinessCharts(): array {
  777. $charts = [];
  778. foreach($this->periodKeys as $index => $key) {
  779. $key_label = $this->periodLabels[$index];
  780. $period_data = $this->periodicData[$key];
  781. if($period_data->testCount === 0) continue;
  782. $chart = new Chart;
  783. $chart->setType("pie");
  784. $chart->setTitle("$key_label Cleanliness");
  785. $chart->setLabels(["Very dirty", "Dirty", "Adequate", "Clean", "Very Clean"]);
  786. $chart->addDataset("Counts", [
  787. $period_data->cleanlinessCounts[0],
  788. $period_data->cleanlinessCounts[1],
  789. $period_data->cleanlinessCounts[2],
  790. $period_data->cleanlinessCounts[3],
  791. $period_data->cleanlinessCounts[4],
  792. ], [
  793. "background_colours" => [
  794. self::COLOUR_RED,
  795. self::COLOUR_LIGHT_RED,
  796. self::COLOUR_ORANGE,
  797. self::COLOUR_YELLOW,
  798. self::COLOUR_GREEN,
  799. ],
  800. "datalabels" => Chart::DATALABELS_BOX,
  801. ]);
  802. $charts[] = $chart;
  803. }
  804. return $charts;
  805. }
  806. public function getPeriodicStaffBadgeWornChart(): Chart {
  807. $staff_badge_worn_counts = array_column($this->periodicData, "staffBadgeWornCounts");
  808. $unknown_counts = array_column($staff_badge_worn_counts, 0);
  809. $no_counts = array_column($staff_badge_worn_counts, 1);
  810. $yes_counts = array_column($staff_badge_worn_counts, 2);
  811. $chart = new Chart;
  812. $chart->setType("bar");
  813. $chart->setTitle("Staff Badge Worn by {$this->resolutionName}");
  814. $chart->setLabels($this->xDataLabels);
  815. $chart->addDataset("Don't know", $unknown_counts, [
  816. "background_colours" => self::COLOUR_LIGHT_GREY
  817. ]);
  818. $chart->addDataset("No", $no_counts, [
  819. "background_colours" => self::COLOUR_RED
  820. ]);
  821. $chart->addDataset("Yes", $yes_counts, [
  822. "background_colours" => self::COLOUR_GREEN
  823. ]);
  824. return $chart;
  825. }
  826. public function getPeriodicStaffOfferedDrinkChart(): Chart {
  827. $counts = array_column($this->periodicData, "staffOfferedDrinkCounts");
  828. return $this->getPeriodicBooleanChart("Staff Offered Drink", $counts);
  829. }
  830. public function getPeriodicStaffOfferedPromotionChart(): Chart {
  831. $counts = array_column($this->periodicData, "staffOfferedPromotionCounts");
  832. return $this->getPeriodicBooleanChart("Staff Offered Promotion", $counts);
  833. }
  834. public function getPeriodicStaffOfferedHelpChart(): Chart {
  835. $counts = array_column($this->periodicData, "staffOfferedHelpCounts");
  836. return $this->getPeriodicBooleanChart("Staff Offered Help", $counts);
  837. }
  838. public function getPeriodicStaffBehaviourCharts(): array {
  839. $charts = [];
  840. foreach($this->periodKeys as $index => $key) {
  841. $key_label = $this->periodLabels[$index];
  842. $period_data = $this->periodicData[$key];
  843. if($period_data->testCount === 0) continue;
  844. $chart = new Chart;
  845. $chart->setType("pie");
  846. $chart->setTitle("$key_label Staff Behaviour");
  847. $chart->setLabels(["N/A", "Rude", "Slightly rude", "Neither rude or polite", "Polite", "Very polite"]);
  848. $chart->addDataset("Counts", [
  849. $period_data->staffBehaviourCounts[0],
  850. $period_data->staffBehaviourCounts[1],
  851. $period_data->staffBehaviourCounts[2],
  852. $period_data->staffBehaviourCounts[3],
  853. $period_data->staffBehaviourCounts[4],
  854. $period_data->staffBehaviourCounts[5],
  855. ], [
  856. "background_colours" => [
  857. self::COLOUR_LIGHT_GREY,
  858. self::COLOUR_RED,
  859. self::COLOUR_LIGHT_RED,
  860. self::COLOUR_ORANGE,
  861. self::COLOUR_YELLOW,
  862. self::COLOUR_GREEN,
  863. ],
  864. "datalabels" => Chart::DATALABELS_BOX,
  865. ]);
  866. $charts[] = $chart;
  867. }
  868. return $charts;
  869. }
  870. public function getPeriodicStaffUniformChart(): Chart {
  871. $counts = array_column($this->periodicData, "staffUniformCounts");
  872. return $this->getPeriodicBooleanChart("Staff Uniform", $counts);
  873. }
  874. // Private methods
  875. private function getPeriodicPassRates(): array {
  876. return array_values(array_map(static function($d) {
  877. if($d->testCount === 0) return 0;
  878. return round(($d->passCount / $d->testCount) * 100);
  879. }, $this->periodicData));
  880. }
  881. private function getPeriodicFailRates(): array {
  882. return array_values(array_map(static function($d) {
  883. if($d->testCount === 0) return 0;
  884. $pass_rate = round(($d->passCount / $d->testCount) * 100);
  885. return 100 - $pass_rate;
  886. }, $this->periodicData));
  887. }
  888. private function getPeriodicPassRate(string $prefix, int $index): array {
  889. $pass_field = $prefix . "PassCounts";
  890. $fail_field = $prefix . "FailCounts";
  891. return array_values(array_map(static function($data) use ($pass_field, $fail_field, $index) {
  892. if(!$data) return null;
  893. if(!isset($data->$pass_field)) return null;
  894. if(!isset($data->$fail_field)) return null;
  895. $test_count = $data->$pass_field[$index] + $data->$fail_field[$index];
  896. if($test_count === 0) {
  897. return null;
  898. }
  899. return round(($data->$pass_field[$index] / $test_count) * 100);
  900. }, $this->periodicData));
  901. }
  902. private function getPeriodicPassRateByDoorSensorAlert(int $index): array {
  903. return $this->getPeriodicPassRate("doorSensor", $index);
  904. }
  905. private function getPeriodicPassRateByEyeContact(int $index): array {
  906. return $this->getPeriodicPassRate("eyeContact", $index);
  907. }
  908. private function getPeriodicPassRateByLineOfSight(int $index): array {
  909. return $this->getPeriodicPassRate("lineOfSight", $index);
  910. }
  911. private function getPeriodicPassRateByBarPurchase(int $index): array {
  912. return $this->getPeriodicPassRate("barPurchase", $index);
  913. }
  914. private function getMachinePowerRates(): array {
  915. return $this->getBooleanRates("machinePowerCounts");
  916. }
  917. private function getMachineSeatRates(): array {
  918. return $this->getBooleanRates("machineSeatCounts");
  919. }
  920. private function getMachineTableRates(): array {
  921. return $this->getBooleanRates("machineTableCounts");
  922. }
  923. private function getMachineAccessibleRates(): array {
  924. return $this->getBooleanRates("machineAccessibleCounts");
  925. }
  926. private function getBooleanRates(string $field): array {
  927. return array_values(array_map(static function($period) use ($field) {
  928. if($period->testCount === 0) {
  929. return [0, 0, 0];
  930. }
  931. $yes = round(($period->$field[0] / $period->testCount) * 100);
  932. $no = 100 - $yes;
  933. $na = 0;
  934. return [$yes, $no, $na];
  935. }, $this->periodicData));
  936. }
  937. private function getEyeContactRates(): array {
  938. return $this->getBooleanRates("eyeContactCounts");
  939. }
  940. private function getPeriodicTestCounts(): array {
  941. return array_column($this->periodicData, "testCount");
  942. }
  943. private function getPeriodicPassCounts(): array {
  944. return array_column($this->periodicData, "passCount");
  945. }
  946. private function getPeriodicFailCounts(): array {
  947. return array_column($this->periodicData, "failCount");
  948. }
  949. private function getPeriodicMaleTesterCount(): array {
  950. return array_values(array_map(static function($d) {
  951. return $d->maleTesterCount;
  952. }, $this->periodicData));
  953. }
  954. private function getPeriodicFemaleTesterCount(): array {
  955. return array_values(array_map(static function($d) {
  956. return $d->femaleTesterCount;
  957. }, $this->periodicData));
  958. }
  959. private function getRegionKeys(): array {
  960. if(!$this->regionData) return [];
  961. return array_keys($this->regionData);
  962. }
  963. private function getRegionXDataLabels(): array {
  964. return array_map(static function($key) {
  965. return "Region $key";
  966. }, $this->getRegionKeys());
  967. }
  968. private function getAreaManagerKeys(): array {
  969. if(!$this->areaManagerData) return [];
  970. return array_keys($this->areaManagerData);
  971. }
  972. private function getAreaManagerXDataLabels(): array {
  973. return $this->getAreaManagerKeys();
  974. }
  975. private function getPeriodicBooleanChart(string $title, array $values): Chart {
  976. $no_counts = array_column($values, 0);
  977. $yes_counts = array_column($values, 1);
  978. $chart = new Chart;
  979. $chart->setType("bar");
  980. $chart->setTitle("{$title} by {$this->resolutionName}");
  981. $chart->setLabels($this->xDataLabels);
  982. $chart->addDataset("Yes", $yes_counts, [
  983. "background_colours" => self::COLOUR_GREEN
  984. ]);
  985. $chart->addDataset("No", $no_counts, [
  986. "background_colours" => self::COLOUR_RED
  987. ]);
  988. $chart->setDatalabelSuffixes("%", "%");
  989. return $chart;
  990. }
  991. private function getPeriodicPassRateChart(string $title, array $yes_rates, array $no_rates, ?array $null_rates = null): Chart {
  992. $chart = new Chart;
  993. $chart->addYAxis([
  994. "tick_config" => ["min" => 0, "max" => 100],
  995. ]);
  996. $chart->setType("bar");
  997. $chart->setTitle($title);
  998. $chart->setLabels($this->xDataLabels);
  999. $chart->setDatalabelSuffixes("%", "%");
  1000. $chart->addDataset("Yes", $yes_rates, [
  1001. "background_colours" => self::COLOUR_GREEN,
  1002. "border_colours" => self::COLOUR_GREEN,
  1003. "line_tension" => 0,
  1004. "datalabels" => ["display" => false],
  1005. ]);
  1006. $chart->addDataset("No", $no_rates, [
  1007. "background_colours" => self::COLOUR_RED,
  1008. "border_colours" => self::COLOUR_RED,
  1009. "line_tension" => 0,
  1010. "datalabels" => ["display" => false],
  1011. ]);
  1012. if($null_rates !== null) {
  1013. $chart->addDataset("Don't Know", $null_rates, [
  1014. "background_colours" => self::COLOUR_CYAN,
  1015. "border_colours" => self::COLOUR_CYAN,
  1016. "line_tension" => 0,
  1017. "datalabels" => ["display" => false],
  1018. ]);
  1019. $chart->setDatalabelSuffixes("%", "%", "%");
  1020. }
  1021. $chart->print = true;
  1022. return $chart;
  1023. }
  1024. /**
  1025. * @param Template $template
  1026. */
  1027. public function setTemplate(Template $template): void {
  1028. $this->template = $template;
  1029. }
  1030. }