chart_generator.php 33 KB

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