chart_generator.php 31 KB

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