chart_generator.php 32 KB

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