chart_generator.php 30 KB

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