chart_generator.php 43 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483
  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. public const COLOUR_BLACK = "#000000";
  19. public const COLOUR_DARK_GREY = "#333333";
  20. /** @var object $totalData */
  21. private $totalData;
  22. /** @var array $periodicData */
  23. private $periodicData;
  24. /** @var string $dateRangeLabel */
  25. private $dateRangeLabel;
  26. /** @var string $resolutionName */
  27. private $resolutionName;
  28. /** @var string[] $xDataLabels */
  29. private $xDataLabels;
  30. /** @var string[] $periodKeys */
  31. private $periodKeys;
  32. /** @var string[] $periodLabels */
  33. private $periodLabels;
  34. /** @var array $regionData */
  35. private $regionData;
  36. /** @var array $areaManagerData */
  37. private $areaManagerData;
  38. /** @var array */
  39. private $operationsManagerData;
  40. private ?array $gamingManagerData = null;
  41. private ?array $seniorGamingManagerData = null;
  42. /** @var array */
  43. private $brandData;
  44. /** @var Template $template */
  45. private $template;
  46. private ?Customer $customer = null;
  47. public static function getVenueTypePassFailChart(array $venue_type_data): Chart {
  48. $chart = new Chart();
  49. $chart->addXAxis([
  50. "type" => "category",
  51. "stacked" => true,
  52. ]);
  53. $chart->addYAxis([
  54. "id" => "y-axis-1",
  55. "tick_config" => ["min" => 0, "max" => 100],
  56. "stacked" => true,
  57. ]);
  58. $get_rates = static function(string $column) use ($venue_type_data) {
  59. return array_values(array_map(static function($d) use ($column) {
  60. if($d["testCount"] === 0) return 0;
  61. return round(($d[$column] / $d["testCount"]) * 100);
  62. }, $venue_type_data));
  63. };
  64. $pass_rates = $get_rates("passCount");
  65. $fail_rates = $get_rates("failCount");
  66. $chart->setType("bar");
  67. $chart->setTitle("Pass / Fail by Venue Type");
  68. $chart->setLabels(array_keys($venue_type_data));
  69. $chart->addDataset("Pass Rate (%)", $pass_rates, ["background_colours" => self::COLOUR_GREEN]);
  70. $chart->addDataset("Fail Rate (%)", $fail_rates, ["background_colours" => self::COLOUR_RED]);
  71. $chart->setDatalabelSuffixes("%", "%");
  72. return $chart;
  73. }
  74. public function getVenueTypeChallengeStageStackedBarChart(array $venue_type_data): ?Chart {
  75. $field = $this->template->getChallengeStageField();
  76. if(!$field) {
  77. return null;
  78. }
  79. $x_labels = $field->displayStrings;
  80. array_shift($x_labels); // Remove placeholder string
  81. $chart = new Chart();
  82. $chart->addXAxis([
  83. "type" => "category",
  84. "stacked" => true,
  85. ]);
  86. $chart->addYAxis([
  87. "id" => "y-axis-1",
  88. "tick_config" => ["min" => 0, "max" => 100],
  89. "stacked" => true,
  90. ]);
  91. $get_rates = static function(string $stage_index) use ($venue_type_data) {
  92. return array_values(array_map(static function($d) use ($stage_index) {
  93. $total_count = array_sum($d["stageCounts"]);
  94. if($total_count === 0) return 0;
  95. return round(($d["stageCounts"][$stage_index] / $total_count) * 100, 1);
  96. }, $venue_type_data));
  97. };
  98. $bg_colours = [
  99. self::COLOUR_GREEN,
  100. self::COLOUR_YELLOW,
  101. self::COLOUR_ORANGE,
  102. self::COLOUR_LIGHT_RED,
  103. self::COLOUR_RED,
  104. ];
  105. $chart->setType("bar");
  106. $chart->setTitle("Stages by Venue Type");
  107. $chart->setLabels(array_keys($venue_type_data));
  108. foreach($x_labels as $stage_index => $label) {
  109. $chart->addDataset("$label (%)", $get_rates($stage_index), ["background_colours" => $bg_colours[$stage_index]]);
  110. }
  111. $suffixes = array_fill(0, count($x_labels), "%");
  112. $chart->setDatalabelSuffixes(...$suffixes);
  113. return $chart;
  114. }
  115. /**
  116. * @param array $venue_type_data
  117. * @return Chart[]
  118. */
  119. public function getVenueTypeChallengeStagePieCharts(array $venue_type_data): array {
  120. $field = $this->template->getChallengeStageField();
  121. if(!$field) {
  122. return [];
  123. }
  124. $x_labels = $field->displayStrings;
  125. array_shift($x_labels); // Remove placeholder string
  126. $charts = [];
  127. foreach($venue_type_data as $venue_type => $data) {
  128. $values = $data["stageCounts"];
  129. $chart = new Chart();
  130. $chart->setType("pie");
  131. $chart->setTitle("Tests by Stage - $venue_type ({$this->dateRangeLabel})");
  132. $chart->setLabels($x_labels);
  133. $chart->addDataset("Counts", $values, [
  134. "background_colours" => [
  135. self::COLOUR_GREEN,
  136. self::COLOUR_YELLOW,
  137. self::COLOUR_ORANGE,
  138. self::COLOUR_LIGHT_RED,
  139. self::COLOUR_RED,
  140. ],
  141. "datalabels" => Chart::DATALABELS_BOX,
  142. ]);
  143. $charts[] = $chart;
  144. }
  145. return $charts;
  146. }
  147. public function __construct(object $total_data, array $periodic_data) {
  148. $this->totalData = $total_data;
  149. $this->periodicData = $periodic_data;
  150. $this->xDataLabels = array_values(array_map(static function($d) {
  151. return $d->label;
  152. }, $this->periodicData));
  153. }
  154. public function setDateRangeLabel(string $label): void {
  155. $this->dateRangeLabel = $label;
  156. }
  157. public function setResolutionName(string $name): void {
  158. $this->resolutionName = $name;
  159. }
  160. public function setPeriodKeysAndLabels(array $keys, array $labels): void {
  161. $this->periodKeys = $keys;
  162. $this->periodLabels = $labels;
  163. }
  164. public function setRegionData(array $data): void {
  165. ksort($data, SORT_NATURAL);
  166. $this->regionData = $data;
  167. }
  168. public function setAreaManagerData(array $data): void {
  169. ksort($data, SORT_NATURAL);
  170. $this->areaManagerData = $data;
  171. }
  172. public function setOperationsManagerData(array $data): void {
  173. ksort($data, SORT_NATURAL);
  174. $this->operationsManagerData = $data;
  175. }
  176. public function setGamingManagerData(?array $data): void {
  177. $this->gamingManagerData = $data;
  178. }
  179. public function setSeniorGamingManagerData(?array $data): void {
  180. $this->seniorGamingManagerData = $data;
  181. }
  182. public function setBrandData(array $data): void {
  183. $this->brandData = $data;
  184. }
  185. // Charts
  186. public function getTestsByStageChart(array $labels, string $title = "Tests by Stage"): Chart {
  187. $chart = new Chart();
  188. $chart->setType("doughnut");
  189. $chart->setTitle("$title ({$this->dateRangeLabel})");
  190. $chart->setLabels($labels);
  191. $chart->addDataset("Tests", [
  192. $this->totalData->stage1Count,
  193. $this->totalData->stage2Count,
  194. $this->totalData->stage3Count,
  195. $this->totalData->stage4Count,
  196. $this->totalData->stage5Count,
  197. ], [
  198. "background_colours" => [
  199. self::COLOUR_GREEN,
  200. self::COLOUR_YELLOW,
  201. self::COLOUR_ORANGE,
  202. self::COLOUR_LIGHT_RED,
  203. self::COLOUR_RED,
  204. ],
  205. "datalabels" => Chart::DATALABELS_BOX,
  206. ]);
  207. $chart->setPrintSuffixes("");
  208. $chart->print = true;
  209. $chart->printPercentages = true;
  210. $chart->printTotalColumn = true;
  211. $chart->setPrintLabels(["Stage 1", "Stage 2", "Stage 3", "Stage 4", "Stage 5"]);
  212. return $chart;
  213. }
  214. public function getChallengerGenderChart(): Chart {
  215. $chart = new Chart();
  216. $chart->setType("pie");
  217. $chart->setTitle("Staff Gender ({$this->dateRangeLabel})");
  218. $chart->setLabels(["Male", "Female", "Unspecified"]);
  219. $chart->addDataset("Counts", [
  220. $this->totalData->maleChallengerCount,
  221. $this->totalData->femaleChallengerCount,
  222. $this->totalData->unspecifiedChallengerCount,
  223. ], [
  224. "background_colours" => [
  225. self::COLOUR_BLUE,
  226. self::COLOUR_MAGENTA,
  227. self::COLOUR_GREY,
  228. ],
  229. "datalabels" => Chart::DATALABELS_BOX,
  230. ]);
  231. return $chart;
  232. }
  233. public function getTesterGenderChart(): Chart {
  234. $chart = new Chart();
  235. $chart->setType("pie");
  236. $chart->setTitle("Tester Gender ({$this->dateRangeLabel})");
  237. $chart->setLabels(["Male", "Female"]);
  238. $chart->addDataset("Counts", [
  239. $this->totalData->maleTesterCount,
  240. $this->totalData->femaleTesterCount,
  241. ], [
  242. "background_colours" => [
  243. self::COLOUR_BLUE,
  244. self::COLOUR_MAGENTA,
  245. ],
  246. "datalabels" => Chart::DATALABELS_BOX,
  247. ]);
  248. return $chart;
  249. }
  250. public function getPassFailCountChart(string $title = "Pass / Fail"): Chart {
  251. $data = $this->totalData;
  252. $dataset = [$data->passCount, $data->failCount];
  253. $labels = ["Pass", "Fail"];
  254. $colours = [self::COLOUR_GREEN, self::COLOUR_RED];
  255. $chart = new Chart();
  256. $chart->setType("pie");
  257. $chart->setTitle("{$title} ({$this->dateRangeLabel})");
  258. $chart->setLabels($labels);
  259. $chart->addDataset("Counts", $dataset, [
  260. "background_colours" => $colours,
  261. "datalabels" => Chart::DATALABELS_BOX,
  262. ]);
  263. return $chart;
  264. }
  265. public function getPassFailCountChartByKey(string $title, string $object_key): Chart {
  266. $data = $this->totalData;
  267. $counts = $data->$object_key;
  268. $pass_count = $counts["pass"] ?? 0;
  269. $fail_count = $counts["fail"] ?? 0;
  270. $dataset = [$pass_count, $fail_count];
  271. $labels = ["Pass", "Fail"];
  272. $colours = [self::COLOUR_GREEN, self::COLOUR_RED];
  273. $title = sprintf("%s (%s)", $title, $this->dateRangeLabel);
  274. $chart = new Chart();
  275. $chart->setType("pie");
  276. $chart->setTitle($title);
  277. $chart->setLabels($labels);
  278. $chart->addDataset("Counts", $dataset, [
  279. "background_colours" => $colours,
  280. "datalabels" => Chart::DATALABELS_BOX,
  281. ]);
  282. return $chart;
  283. }
  284. public function getPeriodicPassFailRateChart(array $options = []): Chart {
  285. $title = $options["title"] ?? "Pass / Fail";
  286. $array_key = $options["array_key"] ?? null;
  287. $pass_rates = [];
  288. $fail_rates = [];
  289. foreach($this->periodicData as $period) {
  290. if($array_key) {
  291. $pass_count = $period->$array_key["pass"];
  292. $fail_count = $period->$array_key["fail"];
  293. }
  294. else {
  295. $pass_count = $period->passCount;
  296. $fail_count = $period->failCount;
  297. }
  298. $test_count = $pass_count + $fail_count;
  299. if($test_count === 0) {
  300. $pass_rates[] = 0;
  301. $fail_rates[] = 0;
  302. }
  303. else {
  304. $pass_rate = round(($pass_count / $test_count) * 100);
  305. $pass_rates[] = $pass_rate;
  306. $fail_rates[] = 100 - $pass_rate;
  307. }
  308. }
  309. $chart = new Chart();
  310. $chart->setIsPeriodic(true);
  311. $chart->addXAxis([
  312. "type" => "category",
  313. "stacked" => true,
  314. ]);
  315. $chart->addYAxis([
  316. "id" => "y-axis-1",
  317. "tick_config" => ["min" => 0, "max" => 100],
  318. "stacked" => true,
  319. ]);
  320. $chart->setType("bar");
  321. $chart->setTitle("{$title} by {$this->resolutionName}");
  322. $chart->setLabels($this->xDataLabels);
  323. $chart->addDataset("Pass Rate (%)", $pass_rates, [
  324. "background_colours" => self::COLOUR_GREEN
  325. ]);
  326. $chart->addDataset("Fail Rate (%)", $fail_rates, [
  327. "background_colours" => self::COLOUR_RED
  328. ]);
  329. $chart->setDatalabelSuffixes("%", "%");
  330. return $chart;
  331. }
  332. public function getPeriodicDoorSensorAlertPassRateChart(): Chart {
  333. return $this->getPeriodicPassRateChart(
  334. "Pass Rate by Door Sensor Alert",
  335. $this->getPeriodicPassRateByDoorSensorAlert(1),
  336. $this->getPeriodicPassRateByDoorSensorAlert(0),
  337. $this->getPeriodicPassRateByDoorSensorAlert(2)
  338. );
  339. }
  340. public function getPeriodicMachinePowerChart(): Chart {
  341. return $this->getPeriodicBooleanChart(
  342. "Machines Powered",
  343. $this->getMachinePowerRates()
  344. );
  345. }
  346. public function getPeriodicMachineSeatChart(): Chart {
  347. return $this->getPeriodicBooleanChart(
  348. "Machine Seating",
  349. $this->getMachineSeatRates()
  350. );
  351. }
  352. public function getPeriodicMachineTableChart(): Chart {
  353. return $this->getPeriodicBooleanChart(
  354. "Machine Table/Shelf",
  355. $this->getMachineTableRates()
  356. );
  357. }
  358. public function getPeriodicMachineAccessibleChart(): Chart {
  359. return $this->getPeriodicBooleanChart(
  360. "Machines Accessible",
  361. $this->getMachineAccessibleRates()
  362. );
  363. }
  364. public function getPeriodicEyeContactPassRateChart(): Chart {
  365. return $this->getPeriodicPassRateChart(
  366. "Pass Rate by Eye Contact",
  367. $this->getPeriodicPassRateByEyeContact(1),
  368. $this->getPeriodicPassRateByEyeContact(0),
  369. $this->getPeriodicPassRateByEyeContact(2)
  370. );
  371. }
  372. public function getPeriodicLineOfSightPassRateChart(array $options = []): Chart {
  373. $title = $options["title"] ?? __("Pass Rate by Line of Sight");
  374. $include_no_challenge = $options["include_no_challenge"] ?? true;
  375. $pass_counts = $this->getPeriodicPassRateByLineOfSight(1);
  376. $fail_counts = $this->getPeriodicPassRateByLineOfSight(0);
  377. $no_challenge_counts = $this->getPeriodicPassRateByLineOfSight(2);
  378. return $this->getPeriodicPassRateChart(
  379. $title,
  380. $pass_counts,
  381. $fail_counts,
  382. $include_no_challenge ? $no_challenge_counts : null
  383. );
  384. }
  385. public function getPeriodicBarPurchasePassRateChart(): Chart {
  386. return $this->getPeriodicPassRateChart(
  387. "Pass Rate by Bar Purchase",
  388. $this->getPeriodicPassRateByBarPurchase(1),
  389. $this->getPeriodicPassRateByBarPurchase(0),
  390. $this->getPeriodicPassRateByBarPurchase(2)
  391. );
  392. }
  393. public function getPeriodicPassRateChartByKey(string $title, string $object_key): Chart {
  394. $pass_rates = [];
  395. $fail_rates = [];
  396. foreach($this->periodicData as $index => $data) {
  397. $counts = $data->$object_key;
  398. $pass_count = $counts["pass"];
  399. $fail_count = $counts["fail"];
  400. $test_count = $pass_count + $fail_count;
  401. if($test_count === 0) {
  402. $pass_rate = 0;
  403. $fail_rate = 0;
  404. }
  405. else {
  406. $pass_rate = round(($pass_count / $test_count) * 100);
  407. $fail_rate = 100 - $pass_rate;
  408. }
  409. $pass_rates[] = $pass_rate;
  410. $fail_rates[] = $fail_rate;
  411. }
  412. $chart = new Chart();
  413. $chart->setIsPeriodic(true);
  414. $chart->addXAxis([
  415. "type" => "category",
  416. "stacked" => true,
  417. ]);
  418. $chart->addYAxis([
  419. "id" => "y-axis-1",
  420. "tick_config" => ["min" => 0, "max" => 100],
  421. "stacked" => true,
  422. ]);
  423. $chart->setType("bar");
  424. $chart->setTitle("$title by {$this->resolutionName}");
  425. $chart->setLabels($this->xDataLabels);
  426. $chart->addDataset("Pass (%)", $pass_rates, ["background_colours" => self::COLOUR_GREEN]);
  427. $chart->addDataset("Fail (%)", $fail_rates, ["background_colours" => self::COLOUR_RED]);
  428. $chart->setDatalabelSuffixes("%", "%");
  429. return $chart;
  430. }
  431. public function getPeriodicBooleanPassRateChart(array $rates, string $title): Chart {
  432. $chart = new Chart();
  433. $chart->addXAxis([
  434. "type" => "category",
  435. "stacked" => true,
  436. ]);
  437. $chart->addYAxis([
  438. "id" => "y-axis-1",
  439. "tick_config" => ["min" => 0, "max" => 100],
  440. "stacked" => true,
  441. ]);
  442. $chart->setType("bar");
  443. $chart->setTitle($title);
  444. $chart->setLabels($this->xDataLabels);
  445. $chart->addDataset("Yes (%)", array_column($rates, "pass"), [
  446. "background_colours" => self::COLOUR_GREEN
  447. ]);
  448. $chart->addDataset("No (%)", array_column($rates, "fail"), [
  449. "background_colours" => self::COLOUR_RED
  450. ]);
  451. $chart->setDatalabelSuffixes("%", "%");
  452. return $chart;
  453. }
  454. public function getPeriodicEyeContactChart(): Chart {
  455. return $this->getPeriodicBooleanChart(
  456. "Eye Contact",
  457. $this->getEyeContactRates()
  458. );
  459. }
  460. public function getPeriodicTotalsChart(array $options = []): Chart {
  461. $title = $options["title"] ?? "Totals";
  462. // Test counts are in "pass" and "fail" keys
  463. $array_key = $options["array_key"] ?? null;
  464. if($array_key) {
  465. $test_counts = [];
  466. $pass_rates = [];
  467. $pass_counts = [];
  468. $fail_counts = [];
  469. foreach($this->periodicData as $index => $period) {
  470. $pass_count = $period->$array_key["pass"];
  471. $fail_count = $period->$array_key["fail"];
  472. $test_count = $pass_count + $fail_count;
  473. $test_counts[] = $test_count;
  474. $pass_rates[] = $test_count > 0 ? round(($pass_count / $test_count) * 100) : 0;
  475. $pass_counts[] = $pass_count;
  476. $fail_counts[] = $fail_count;
  477. }
  478. }
  479. else {
  480. $test_counts = $this->getPeriodicTestCounts();
  481. $pass_rates = $this->getPeriodicPassRates();
  482. $pass_counts = $this->getPeriodicPassCounts();
  483. $fail_counts = $this->getPeriodicFailCounts();
  484. }
  485. $chart = new Chart();
  486. $chart->setIsPeriodic(true);
  487. $chart->setType("bar");
  488. $chart->setTitle("{$title} by {$this->resolutionName}");
  489. $chart->setLabels($this->xDataLabels);
  490. $chart->addYAxis([
  491. "id" => "y-axis-1",
  492. "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10]
  493. ]);
  494. $chart->addYAxis([
  495. "position" => "right",
  496. "id" => "y-axis-2",
  497. "grid_lines" => false,
  498. "tick_config" => ["min" => 0, "max" => 100]
  499. ]);
  500. $chart->addDataset("Pass Rate (%)", $pass_rates, [
  501. "border_colours" => self::COLOUR_YELLOW,
  502. "background_colours" => "transparent",
  503. "type" => "line",
  504. "y_axis_id" => "y-axis-2",
  505. "datalabels" => Chart::DATALABELS_BOX,
  506. "line_tension" => 0,
  507. ]);
  508. $chart->addDataset("Test Count", $test_counts, [
  509. "background_colours" => self::COLOUR_BLUE,
  510. "type" => "bar",
  511. "y_axis_id" => "y-axis-1",
  512. "datalabels" => Chart::DATALABELS_STROKE,
  513. ]);
  514. $chart->addDataset("Pass", $pass_counts, [
  515. "background_colours" => self::COLOUR_GREEN,
  516. "type" => "bar",
  517. "y_axis_id" => "y-axis-1",
  518. "datalabels" => Chart::DATALABELS_STROKE
  519. ]);
  520. $chart->addDataset("Fail", $fail_counts, [
  521. "background_colours" => self::COLOUR_RED,
  522. "type" => "bar",
  523. "y_axis_id" => "y-axis-1",
  524. "datalabels" => Chart::DATALABELS_STROKE
  525. ]);
  526. $chart->setDatalabelSuffixes("%", "", "", "");
  527. $chart->print = true;
  528. return $chart;
  529. }
  530. /**
  531. * @return Chart[]
  532. * @throws Exception
  533. */
  534. public function getPointOfChallengeCharts(string $title_format, array $labels = []): array {
  535. $charts = [];
  536. foreach($this->periodKeys as $index => $key) {
  537. $key_label = $this->periodLabels[$index];
  538. $period_data = $this->periodicData[$key];
  539. if($period_data->testCount === 0) continue;
  540. $chart = new Chart();
  541. $chart->setType("pie");
  542. $chart->setTitle(sprintf($title_format, $key_label));
  543. $chart->setLabels($labels);
  544. $chart->addDataset("Counts", [
  545. $period_data->stage1Count,
  546. $period_data->stage2Count,
  547. $period_data->stage3Count,
  548. $period_data->stage4Count,
  549. $period_data->stage5Count,
  550. ], [
  551. "background_colours" => [
  552. self::COLOUR_GREEN,
  553. self::COLOUR_YELLOW,
  554. self::COLOUR_ORANGE,
  555. self::COLOUR_LIGHT_RED,
  556. self::COLOUR_RED,
  557. ],
  558. "datalabels" => Chart::DATALABELS_BOX,
  559. ]);
  560. $charts[] = $chart;
  561. }
  562. return $charts;
  563. }
  564. public function getPeriodicTesterGenderChart(): Chart {
  565. $male_counts = $this->getPeriodicMaleTesterCount();
  566. $female_counts = $this->getPeriodicFemaleTesterCount();
  567. $counts = array_merge($male_counts, $female_counts);
  568. $chart = new Chart();
  569. $chart->setIsPeriodic(true);
  570. $chart->addYAxis([
  571. "id" => "y-axis-1",
  572. "tick_config" => ["min" => 0, "max" => ceil(max($counts) / 10) * 10]
  573. ]);
  574. $chart->setType("bar");
  575. $chart->setTitle("Tester Gender by {$this->resolutionName}");
  576. $chart->setLabels($this->xDataLabels);
  577. $chart->addDataset("Male", $male_counts, [
  578. "background_colours" => self::COLOUR_BLUE
  579. ]);
  580. $chart->addDataset("Female", $female_counts, [
  581. "background_colours" => self::COLOUR_MAGENTA
  582. ]);
  583. return $chart;
  584. }
  585. public function getPeriodicTestCountChart(string $title = "Tests"): Chart {
  586. $test_counts = $this->getPeriodicTestCounts();
  587. $pass_rates = $this->getPeriodicPassRates();
  588. $pass_rate_max = ceil(max($pass_rates) / 10) * 10;
  589. $chart = new Chart();
  590. $chart->setIsPeriodic(true);
  591. $chart->addYAxis([
  592. "id" => "y-axis-1",
  593. "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10]
  594. ]);
  595. $chart->addYAxis([
  596. "id" => "y-axis-2",
  597. "tick_config" => ["min" => 0, "max" => $pass_rate_max],
  598. "position" => "right"
  599. ]);
  600. $chart->setType("bar");
  601. $chart->setTitle("{$title} by {$this->resolutionName}");
  602. $chart->setLabels($this->xDataLabels);
  603. $chart->addDataset("Pass Rate", $pass_rates, [
  604. "type" => "line",
  605. "y_axis_id" => "y-axis-2",
  606. "border_colours" => self::COLOUR_RED,
  607. "background_colours" => "transparent",
  608. "line_tension" => 0,
  609. "datalabels" => [
  610. "align" => "top",
  611. "color" => self::COLOUR_DARK_GREY,
  612. "borderColor" => self::COLOUR_GREY,
  613. "borderWidth" => 1,
  614. "borderRadius" => 4,
  615. "backgroundColor" => "white",
  616. "font" => [
  617. "weight" => "bold"
  618. ],
  619. ],
  620. "point_background_colour" => self::COLOUR_RED,
  621. ]);
  622. $chart->addDataset("Tests", $test_counts, [
  623. "background_colours" => self::COLOUR_BLUE
  624. ]);
  625. $chart->setDatalabelSuffixes("%", "");
  626. return $chart;
  627. }
  628. public function getGenderComparisonCharts(): array {
  629. $charts = [];
  630. $gender_keys = [
  631. "maleChallengeMale" => [
  632. "title" => "Male Challenge Male",
  633. "label" => "M Cha. M",
  634. ],
  635. "maleChallengeFemale" => [
  636. "title" => "Male Challenge Female",
  637. "label" => "M Cha. F",
  638. ],
  639. "femaleChallengeMale" => [
  640. "title" => "Female Challenge Male",
  641. "label" => "F Cha. M",
  642. ],
  643. "femaleChallengeFemale" => [
  644. "title" => "Female Challenge Female",
  645. "label" => "F Cha. F",
  646. ],
  647. "unknownChallenge" => [
  648. "title" => "Gender Not Specified",
  649. "label" => "Gender Not Specified",
  650. ],
  651. ];
  652. $gender_test_counts = [];
  653. foreach($gender_keys as $gk => $gv) {
  654. $gender_test_counts[] = array_sum(array_column($this->periodicData, "{$gk}Count"));
  655. }
  656. // Gender Comparison by Date Range
  657. $chart = new Chart();
  658. $chart->addYAxis([
  659. "id" => "y-axis-1",
  660. "tick_config" => ["min" => 0, "max" => ceil(max($gender_test_counts) / 10) * 10]
  661. ]);
  662. $chart->setType("bar");
  663. $chart->setTitle("Gender Comparison ({$this->dateRangeLabel})");
  664. $chart->setLabels(array_column($gender_keys, "label"));
  665. $chart->addDataset("Tests", $gender_test_counts, [
  666. "background_colours" => self::COLOUR_BLUE
  667. ]);
  668. $charts[] = $chart;
  669. // Gender Comparison by Resolution
  670. $mcm_counts = array_column($this->periodicData, "maleChallengeMaleCount");
  671. $mcf_counts = array_column($this->periodicData, "maleChallengeFemaleCount");
  672. $fcm_counts = array_column($this->periodicData, "femaleChallengeMaleCount");
  673. $fcf_counts = array_column($this->periodicData, "femaleChallengeFemaleCount");
  674. $ns_counts = array_column($this->periodicData, "unknownChallengeCount");
  675. $counts = array_merge($mcm_counts, $mcf_counts, $fcm_counts, $fcf_counts);
  676. $chart = new Chart();
  677. $chart->setIsPeriodic(true);
  678. $chart->addYAxis([
  679. "id" => "y-axis-1",
  680. "tick_config" => ["min" => 0, "max" => ceil(max($counts) / 10) * 10]
  681. ]);
  682. $chart->setType("bar");
  683. $chart->setTitle("Gender Comparison by {$this->resolutionName}");
  684. $chart->setLabels($this->xDataLabels);
  685. $chart->addDataset("M Cha. M", $mcm_counts, ["background_colours" => self::COLOUR_BLUE]);
  686. $chart->addDataset("M Cha. F", $mcf_counts, ["background_colours" => self::COLOUR_DARK_BLUE]);
  687. $chart->addDataset("F Cha. M", $fcm_counts, ["background_colours" => self::COLOUR_PURPLE]);
  688. $chart->addDataset("F Cha. F", $fcf_counts, ["background_colours" => self::COLOUR_MAGENTA]);
  689. $chart->addDataset("Not Specified", $ns_counts, ["background_colours" => self::COLOUR_GREY]);
  690. $chart->print = true;
  691. $charts[] = $chart;
  692. // Gender Comparison Pass Rate by Resolution
  693. /** @noinspection PhpUnusedLocalVariableInspection */
  694. {
  695. $mcm_pass_counts = array_column($this->periodicData, "maleChallengeMalePassCount");
  696. $mcf_pass_counts = array_column($this->periodicData, "maleChallengeFemalePassCount");
  697. $fcm_pass_counts = array_column($this->periodicData, "femaleChallengeMalePassCount");
  698. $fcf_pass_counts = array_column($this->periodicData, "femaleChallengeFemalePassCount");
  699. $ns_pass_counts = array_column($this->periodicData, "unknownChallengePassCount");
  700. }
  701. /**
  702. * @var float $mcm_pass_rates
  703. * @var float $mcf_pass_rates
  704. * @var float $fcm_pass_rates
  705. * @var float $fcf_pass_rates
  706. * @var float $ns_pass_rates
  707. */
  708. foreach(["mcm", "mcf", "fcm", "fcf", "ns"] as $prefix) {
  709. $pass_rates = [];
  710. $pass_counts = ${$prefix . "_pass_counts"};
  711. $test_counts = ${$prefix . "_counts"};
  712. foreach($test_counts as $index => $test_count) {
  713. if($test_count === 0) {
  714. $pass_rates[] = 0;
  715. continue;
  716. }
  717. $pass_rates[] = number_format(($pass_counts[$index] * 100) / $test_count, 2);
  718. }
  719. ${$prefix . "_pass_rates"} = $pass_rates;
  720. }
  721. $chart = new Chart();
  722. $chart->setIsPeriodic(true);
  723. $chart->addYAxis([
  724. "id" => "y-axis-1",
  725. "tick_config" => ["min" => 0, "max" => 100],
  726. ]);
  727. $chart->setType("bar");
  728. $chart->setTitle("Gender Comparison Pass Rate by {$this->resolutionName}");
  729. $chart->setLabels($this->xDataLabels);
  730. $chart->addDataset("M Cha. M", $mcm_pass_rates, ["background_colours" => self::COLOUR_BLUE, "datalabels" => ["display" => false], "line_tension" => 0]);
  731. $chart->addDataset("M Cha. F", $mcf_pass_rates, ["background_colours" => self::COLOUR_DARK_BLUE, "datalabels" => ["display" => false], "line_tension" => 0]);
  732. $chart->addDataset("F Cha. M", $fcm_pass_rates, ["background_colours" => self::COLOUR_PURPLE, "datalabels" => ["display" => false], "line_tension" => 0]);
  733. $chart->addDataset("F Cha. F", $fcf_pass_rates, ["background_colours" => self::COLOUR_MAGENTA, "datalabels" => ["display" => false], "line_tension" => 0]);
  734. $chart->addDataset("Not Specified", $ns_pass_rates, ["background_colours" => self::COLOUR_GREY, "datalabels" => ["display" => false], "line_tension" => 0]);
  735. $chart->print = true;
  736. $chart->setDatalabelSuffixes("%", "%", "%", "%", "%");
  737. $charts[] = $chart;
  738. // Gender Comparison Point of Challenge
  739. foreach($this->periodKeys as $index => $key) {
  740. $key_label = $this->periodLabels[$index];
  741. $period_data = $this->periodicData[$key];
  742. foreach($gender_keys as $prefix => $gv) {
  743. $title = $gv["label"];
  744. $test_count = $period_data->{$prefix . "Count"};
  745. $stage_data = $period_data->{$prefix . "Stages"};
  746. if($test_count === 0) continue;
  747. $chart = new Chart();
  748. $chart->setType("pie");
  749. $chart->setTitle("$key_label $title Point of Challenge");
  750. $chart->setLabels(["On Entry", "While Browsing", "During Play", "On Exit", "No Challenge"]);
  751. $chart->addDataset("Counts", $stage_data, [
  752. "background_colours" => [
  753. self::COLOUR_GREEN,
  754. self::COLOUR_YELLOW,
  755. self::COLOUR_ORANGE,
  756. self::COLOUR_LIGHT_RED,
  757. self::COLOUR_RED,
  758. ],
  759. "datalabels" => Chart::DATALABELS_BOX,
  760. ]);
  761. $charts[] = $chart;
  762. }
  763. }
  764. return $charts;
  765. }
  766. private function getDataPassRateChart(array $data, string $entity_name): Chart {
  767. $data_values = [];
  768. $test_counts = [];
  769. $pass_counts = [];
  770. $fail_counts = [];
  771. uasort($data, static function(array $a, array $b) {
  772. $a_test_count = array_sum(array_column($a, "testCount"));
  773. $a_pass_count = array_sum(array_column($a, "passCount"));
  774. $a_pass_rate = ($a_test_count === 0) ? 0 : round(($a_pass_count * 100) / $a_test_count);
  775. $b_test_count = array_sum(array_column($b, "testCount"));
  776. $b_pass_count = array_sum(array_column($b, "passCount"));
  777. $b_pass_rate = ($b_test_count === 0) ? 0 : round(($b_pass_count * 100) / $b_test_count);
  778. return $b_pass_rate <=> $a_pass_rate;
  779. });
  780. foreach($data as $datum) {
  781. $total_test_count = array_sum(array_column($datum, "testCount"));
  782. $total_pass_count = array_sum(array_column($datum, "passCount"));
  783. $test_counts[] = $total_test_count;
  784. $pass_counts[] = $total_pass_count;
  785. $fail_counts[] = $total_test_count - $total_pass_count;
  786. $data_values[] = ($total_test_count === 0) ? 0 : round(($total_pass_count * 100) / $total_test_count);
  787. }
  788. $chart = new Chart();
  789. $chart->addXAxis([
  790. "type" => "category",
  791. "scale_label_config" => [
  792. "display" => true,
  793. "labelString" => $entity_name,
  794. ]
  795. ]);
  796. $chart->addYAxis([
  797. "id" => "y-axis-1",
  798. "tick_config" => ["min" => 0, "max" => 100]
  799. ]);
  800. $chart->setType("bar");
  801. $chart->setTitle("{$entity_name} Pass Rate ({$this->dateRangeLabel})");
  802. $chart->setLabels(array_keys($data));
  803. $chart->addDataset("Pass %", $data_values , [
  804. "background_colours" => self::COLOUR_BLUE
  805. ]);
  806. $chart->addPrintDataset("Tests", $test_counts);
  807. $chart->addPrintDataset("Pass", $pass_counts);
  808. $chart->addPrintDataset("Fail", $fail_counts);
  809. $chart->setDatalabelSuffixes("%");
  810. $chart->print = true;
  811. $chart->printTotalColumn = true;
  812. $chart->numeratorColumnIndex = 2;
  813. $chart->denominatorColumnIndex = 1;
  814. return $chart;
  815. }
  816. public function getPeriodicDataPassRateChart(string $entity): Chart {
  817. switch($entity) {
  818. case "region":
  819. $data = $this->regionData;
  820. $entity_name = $this->customer->getRegionLabel(1);
  821. $entity_keys = $this->getRegionKeys();
  822. $x_labels = $this->getRegionXDataLabels();
  823. break;
  824. case "areaManager":
  825. $data = $this->areaManagerData;
  826. $entity_name = $this->customer->getAreaManagerLabel(1);
  827. $entity_keys = $this->getAreaManagerKeys();
  828. $x_labels = $this->getAreaManagerKeys();
  829. break;
  830. case "brand":
  831. $data = $this->brandData;
  832. $entity_name = $this->customer->getBrandLabel(1);
  833. $entity_keys = $this->getBrandKeys();
  834. $x_labels = $this->getBrandKeys();
  835. break;
  836. case "operationsManager":
  837. $data = $this->operationsManagerData;
  838. $entity_name = $this->customer->getOperationsManagerLabel(1);
  839. $entity_keys = $x_labels = $this->getOperationsManagerKeys();
  840. break;
  841. case "gamingManager":
  842. $data = $this->gamingManagerData;
  843. $entity_name = $this->customer->getGamingManagerLabel(1);
  844. $entity_keys = $x_labels = $this->getGamingManagerKeys();
  845. break;
  846. case "seniorGamingManager":
  847. $data = $this->seniorGamingManagerData;
  848. $entity_name = $this->customer->getSeniorGamingManagerLabel(1);
  849. $entity_keys = $x_labels = $this->getSeniorGamingManagerKeys();
  850. break;
  851. default:
  852. throw new RuntimeException("Invalid entity passed to getPeriodicDataPassRateChart: $entity");
  853. }
  854. $chart = new Chart();
  855. $chart->setIsPeriodic(true);
  856. $chart->addXAxis([
  857. "type" => "category",
  858. "scale_label_config" => [
  859. "display" => true,
  860. "labelString" => $entity_name,
  861. ]
  862. ]);
  863. $chart->addYAxis([
  864. "id" => "y-axis-1",
  865. "tick_config" => ["min" => 0, "max" => 100]
  866. ]);
  867. $chart->setType("bar");
  868. $chart->setTitle("{$entity_name} Pass Rate by {$this->resolutionName}");
  869. $chart->setLabels($x_labels);
  870. foreach($this->periodKeys as $index => $key) {
  871. $data_values = [];
  872. foreach($entity_keys as $entity_key) {
  873. $datum = $data[$entity_key][$key];
  874. $data_values[] = ($datum->testCount === 0) ? 0 : round(($datum->passCount * 100) / $datum->testCount);
  875. }
  876. $chart->addDataset($this->periodLabels[$index], $data_values, [
  877. "background_colours" => Chart::getColourByIndex($index),
  878. "datalabels" => [
  879. "display" => false
  880. ]
  881. ]);
  882. }
  883. $chart->setDatalabelSuffixes(...array_fill(0, count($this->periodKeys), "%"));
  884. $chart->print = true;
  885. return $chart;
  886. }
  887. public function hasRegionData(): bool {
  888. return $this->regionData !== null;
  889. }
  890. public function getRegionPassRateChart(): Chart {
  891. return $this->getDataPassRateChart($this->regionData, $this->customer->getRegionLabel(1));
  892. }
  893. public function getPeriodicRegionPassRateChart(): Chart {
  894. return $this->getPeriodicDataPassRateChart("region");
  895. }
  896. public function hasAreaManagerData(): bool {
  897. return $this->areaManagerData !== null;
  898. }
  899. public function getAreaManagerPassRateChart(): Chart {
  900. return $this->getDataPassRateChart($this->areaManagerData, $this->customer->getAreaManagerLabel(1));
  901. }
  902. public function getPeriodicAreaManagerPassRateChart(): Chart {
  903. return $this->getPeriodicDataPassRateChart("areaManager");
  904. }
  905. public function hasBrandData(): bool {
  906. return $this->brandData !== null;
  907. }
  908. public function getBrandPassRateChart(): Chart {
  909. return $this->getDataPassRateChart($this->brandData, $this->customer->getBrandLabel(1));
  910. }
  911. public function getPeriodicBrandPassRateChart(): Chart {
  912. return $this->getPeriodicDataPassRateChart("brand");
  913. }
  914. public function hasOperationsManagerData(): bool {
  915. return $this->operationsManagerData !== null;
  916. }
  917. public function hasGamingManagerData(): bool {
  918. return $this->gamingManagerData !== null;
  919. }
  920. public function hasSeniorGamingManagerData(): bool {
  921. return $this->seniorGamingManagerData !== null;
  922. }
  923. public function getOperationsManagerPassRateChart(): Chart {
  924. return $this->getDataPassRateChart($this->operationsManagerData, $this->customer->getOperationsManagerLabel(1));
  925. }
  926. public function getGamingManagerPassRateChart(): Chart {
  927. return $this->getDataPassRateChart($this->gamingManagerData, $this->customer->getGamingManagerLabel(1));
  928. }
  929. public function getSeniorGamingManagerPassRateChart(): Chart {
  930. return $this->getDataPassRateChart($this->seniorGamingManagerData, $this->customer->getSeniorGamingManagerLabel(1));
  931. }
  932. public function getPeriodicOperationsManagerPassRateChart(): Chart {
  933. return $this->getPeriodicDataPassRateChart("operationsManager");
  934. }
  935. public function getPeriodicGamingManagerPassRateChart(): Chart {
  936. return $this->getPeriodicDataPassRateChart("gamingManager");
  937. }
  938. public function getPeriodicSeniorGamingManagerPassRateChart(): Chart {
  939. return $this->getPeriodicDataPassRateChart("seniorGamingManager");
  940. }
  941. public function getCleanlinessChart(): Chart {
  942. $chart = new Chart();
  943. $chart->setType("doughnut");
  944. $chart->setTitle("Tests by Cleanliness ({$this->dateRangeLabel})");
  945. $chart->setLabels(["Very dirty", "Dirty", "Adequate", "Clean", "Very Clean"]);
  946. $chart->addDataset("Tests", [
  947. $this->totalData->cleanlinessCounts[0],
  948. $this->totalData->cleanlinessCounts[1],
  949. $this->totalData->cleanlinessCounts[2],
  950. $this->totalData->cleanlinessCounts[3],
  951. $this->totalData->cleanlinessCounts[4],
  952. ], [
  953. "background_colours" => [
  954. self::COLOUR_RED,
  955. self::COLOUR_LIGHT_RED,
  956. self::COLOUR_ORANGE,
  957. self::COLOUR_YELLOW,
  958. self::COLOUR_GREEN,
  959. ],
  960. "datalabels" => Chart::DATALABELS_BOX,
  961. ]);
  962. $chart->setPrintSuffixes("");
  963. $chart->print = true;
  964. $chart->printTotalColumn = true;
  965. $chart->printPercentages = true;
  966. return $chart;
  967. }
  968. /**
  969. * @return Chart[]
  970. * @throws Exception
  971. */
  972. public function getPeriodicCleanlinessCharts(): array {
  973. $charts = [];
  974. foreach($this->periodKeys as $index => $key) {
  975. $key_label = $this->periodLabels[$index];
  976. $period_data = $this->periodicData[$key];
  977. if($period_data->testCount === 0) continue;
  978. $chart = new Chart();
  979. $chart->setType("pie");
  980. $chart->setTitle("$key_label Cleanliness");
  981. $chart->setLabels(["Very dirty", "Dirty", "Adequate", "Clean", "Very Clean"]);
  982. $chart->addDataset("Counts", [
  983. $period_data->cleanlinessCounts[0],
  984. $period_data->cleanlinessCounts[1],
  985. $period_data->cleanlinessCounts[2],
  986. $period_data->cleanlinessCounts[3],
  987. $period_data->cleanlinessCounts[4],
  988. ], [
  989. "background_colours" => [
  990. self::COLOUR_RED,
  991. self::COLOUR_LIGHT_RED,
  992. self::COLOUR_ORANGE,
  993. self::COLOUR_YELLOW,
  994. self::COLOUR_GREEN,
  995. ],
  996. "datalabels" => Chart::DATALABELS_BOX,
  997. ]);
  998. $charts[] = $chart;
  999. }
  1000. return $charts;
  1001. }
  1002. public function getPeriodicStaffBadgeWornChart(): Chart {
  1003. $staff_badge_worn_counts = array_column($this->periodicData, "staffBadgeWornCounts");
  1004. $unknown_counts = array_column($staff_badge_worn_counts, 0);
  1005. $no_counts = array_column($staff_badge_worn_counts, 1);
  1006. $yes_counts = array_column($staff_badge_worn_counts, 2);
  1007. $chart = new Chart();
  1008. $chart->setType("bar");
  1009. $chart->setTitle("Staff Badge Worn by {$this->resolutionName}");
  1010. $chart->setLabels($this->xDataLabels);
  1011. $chart->addDataset("No challenge", $unknown_counts, [
  1012. "background_colours" => self::COLOUR_LIGHT_GREY
  1013. ]);
  1014. $chart->addDataset("No", $no_counts, [
  1015. "background_colours" => self::COLOUR_RED
  1016. ]);
  1017. $chart->addDataset("Yes", $yes_counts, [
  1018. "background_colours" => self::COLOUR_GREEN
  1019. ]);
  1020. return $chart;
  1021. }
  1022. public function getPeriodicStaffOfferedDrinkChart(): Chart {
  1023. $counts = array_column($this->periodicData, "staffOfferedDrinkCounts");
  1024. return $this->getPeriodicBooleanChart("Staff Offered Drink", $counts);
  1025. }
  1026. public function getPeriodicStaffOfferedPromotionChart(): Chart {
  1027. $counts = array_column($this->periodicData, "staffOfferedPromotionCounts");
  1028. return $this->getPeriodicBooleanChart("Staff Offered Promotion", $counts);
  1029. }
  1030. public function getPeriodicStaffOfferedHelpChart(): Chart {
  1031. $counts = array_column($this->periodicData, "staffOfferedHelpCounts");
  1032. return $this->getPeriodicBooleanChart("Staff Offered Help", $counts);
  1033. }
  1034. public function getPeriodicStaffBehaviourCharts(): array {
  1035. $charts = [];
  1036. foreach($this->periodKeys as $index => $key) {
  1037. $key_label = $this->periodLabels[$index];
  1038. $period_data = $this->periodicData[$key];
  1039. if($period_data->testCount === 0) continue;
  1040. $chart = new Chart();
  1041. $chart->setType("pie");
  1042. $chart->setTitle("$key_label Staff Behaviour");
  1043. $chart->setLabels(["N/A", "Rude", "Slightly rude", "Neither rude or polite", "Polite", "Very polite"]);
  1044. $chart->addDataset("Counts", [
  1045. $period_data->staffBehaviourCounts[0],
  1046. $period_data->staffBehaviourCounts[1],
  1047. $period_data->staffBehaviourCounts[2],
  1048. $period_data->staffBehaviourCounts[3],
  1049. $period_data->staffBehaviourCounts[4],
  1050. $period_data->staffBehaviourCounts[5],
  1051. ], [
  1052. "background_colours" => [
  1053. self::COLOUR_LIGHT_GREY,
  1054. self::COLOUR_RED,
  1055. self::COLOUR_LIGHT_RED,
  1056. self::COLOUR_ORANGE,
  1057. self::COLOUR_YELLOW,
  1058. self::COLOUR_GREEN,
  1059. ],
  1060. "datalabels" => Chart::DATALABELS_BOX,
  1061. ]);
  1062. $charts[] = $chart;
  1063. }
  1064. return $charts;
  1065. }
  1066. public function getPeriodicStaffUniformChart(): Chart {
  1067. $counts = array_column($this->periodicData, "staffUniformCounts");
  1068. return $this->getPeriodicBooleanChart("Staff Uniform", $counts);
  1069. }
  1070. // Private methods
  1071. private function getPeriodicPassRates(): array {
  1072. return array_values(array_map(static function($period) {
  1073. if($period->testCount === 0) return 0;
  1074. return round(($period->passCount / $period->testCount) * 100);
  1075. }, $this->periodicData));
  1076. }
  1077. private function getPeriodicFailRates(): array {
  1078. return array_values(array_map(static function($period) {
  1079. if($period->testCount === 0) return 0;
  1080. $pass_rate = round(($period->passCount / $period->testCount) * 100);
  1081. return 100 - $pass_rate;
  1082. }, $this->periodicData));
  1083. }
  1084. private function getPeriodicPassRate(string $prefix, int $index): array {
  1085. $pass_field = $prefix . "PassCounts";
  1086. $fail_field = $prefix . "FailCounts";
  1087. return array_values(array_map(static function($data) use ($pass_field, $fail_field, $index) {
  1088. if(!$data) return null;
  1089. if(!isset($data->$pass_field)) return null;
  1090. if(!isset($data->$fail_field)) return null;
  1091. $pass_count = $data->$pass_field[$index];
  1092. $fail_count = $data->$fail_field[$index];
  1093. $test_count = $pass_count + $fail_count;
  1094. if($test_count === 0) {
  1095. return null;
  1096. }
  1097. return round(($pass_count / $test_count) * 100);
  1098. }, $this->periodicData));
  1099. }
  1100. private function getPeriodicPassRateByDoorSensorAlert(int $index): array {
  1101. return $this->getPeriodicPassRate("doorSensorAlert", $index);
  1102. }
  1103. private function getPeriodicPassRateByEyeContact(int $index): array {
  1104. return $this->getPeriodicPassRate("eyeContact", $index);
  1105. }
  1106. private function getPeriodicPassRateByLineOfSight(int $index): array {
  1107. return $this->getPeriodicPassRate("lineOfSight", $index);
  1108. }
  1109. private function getPeriodicPassRateByBarPurchase(int $index): array {
  1110. return $this->getPeriodicPassRate("barPurchase", $index);
  1111. }
  1112. private function getMachinePowerRates(): array {
  1113. return $this->getBooleanRates("machinePowerCounts");
  1114. }
  1115. private function getMachineSeatRates(): array {
  1116. return $this->getBooleanRates("machineSeatCounts");
  1117. }
  1118. private function getMachineTableRates(): array {
  1119. return $this->getBooleanRates("machineTableCounts");
  1120. }
  1121. private function getMachineAccessibleRates(): array {
  1122. return $this->getBooleanRates("machineAccessibleCounts");
  1123. }
  1124. private function getBooleanRates(string $field): array {
  1125. return array_values(array_map(static function($period) use ($field) {
  1126. if($period->testCount === 0) {
  1127. return [0, 0, 0];
  1128. }
  1129. $yes = round(($period->$field[0] / $period->testCount) * 100);
  1130. $no = 100 - $yes;
  1131. $na = 0;
  1132. return [$yes, $no, $na];
  1133. }, $this->periodicData));
  1134. }
  1135. private function getEyeContactRates(): array {
  1136. return $this->getBooleanRates("eyeContactCounts");
  1137. }
  1138. private function getPeriodicTestCounts(): array {
  1139. return array_column($this->periodicData, "testCount");
  1140. }
  1141. private function getPeriodicPassCounts(): array {
  1142. return array_column($this->periodicData, "passCount");
  1143. }
  1144. private function getPeriodicFailCounts(): array {
  1145. return array_column($this->periodicData, "failCount");
  1146. }
  1147. private function getPeriodicMaleTesterCount(): array {
  1148. return array_values(array_map(static function($d) {
  1149. return $d->maleTesterCount;
  1150. }, $this->periodicData));
  1151. }
  1152. private function getPeriodicFemaleTesterCount(): array {
  1153. return array_values(array_map(static function($d) {
  1154. return $d->femaleTesterCount;
  1155. }, $this->periodicData));
  1156. }
  1157. private function getRegionKeys(): array {
  1158. if(!$this->regionData) return [];
  1159. return array_keys($this->regionData);
  1160. }
  1161. private function getRegionXDataLabels(): array {
  1162. return array_map(static function($key) {
  1163. return "Region $key";
  1164. }, $this->getRegionKeys());
  1165. }
  1166. private function getAreaManagerKeys(): array {
  1167. if(!$this->areaManagerData) return [];
  1168. return array_keys($this->areaManagerData);
  1169. }
  1170. private function getBrandKeys(): array {
  1171. if(!$this->brandData) return [];
  1172. return array_keys($this->brandData);
  1173. }
  1174. private function getOperationsManagerKeys(): array {
  1175. return $this->operationsManagerData ? array_keys($this->operationsManagerData) : [];
  1176. }
  1177. private function getGamingManagerKeys(): array {
  1178. return $this->gamingManagerData ? array_keys($this->gamingManagerData) : [];
  1179. }
  1180. private function getSeniorGamingManagerKeys(): array {
  1181. return $this->seniorGamingManagerData ? array_keys($this->seniorGamingManagerData) : [];
  1182. }
  1183. private function getAreaManagerXDataLabels(): array {
  1184. return $this->getAreaManagerKeys();
  1185. }
  1186. private function getPeriodicBooleanChart(string $title, array $values): Chart {
  1187. $no_counts = array_column($values, 0);
  1188. $yes_counts = array_column($values, 1);
  1189. $chart = new Chart();
  1190. $chart->setIsPeriodic(true);
  1191. $chart->setType("bar");
  1192. $chart->setTitle("{$title} by {$this->resolutionName}");
  1193. $chart->setLabels($this->xDataLabels);
  1194. $chart->addDataset("Yes", $yes_counts, [
  1195. "background_colours" => self::COLOUR_GREEN
  1196. ]);
  1197. $chart->addDataset("No", $no_counts, [
  1198. "background_colours" => self::COLOUR_RED
  1199. ]);
  1200. $chart->setDatalabelSuffixes("%", "%");
  1201. return $chart;
  1202. }
  1203. private function getPeriodicPassRateChart(string $title, array $yes_rates, array $no_rates, ?array $null_rates = null): Chart {
  1204. $chart = new Chart();
  1205. $chart->setIsPeriodic(true);
  1206. $chart->addYAxis([
  1207. "tick_config" => ["min" => 0, "max" => 100],
  1208. ]);
  1209. $chart->setType("bar");
  1210. $chart->setTitle($title);
  1211. $chart->setLabels($this->xDataLabels);
  1212. $chart->setDatalabelSuffixes("%", "%");
  1213. $chart->addDataset("Yes (%)", $yes_rates, [
  1214. "background_colours" => self::COLOUR_GREEN,
  1215. "border_colours" => self::COLOUR_GREEN,
  1216. "line_tension" => 0,
  1217. "datalabels" => ["display" => false],
  1218. ]);
  1219. $chart->addDataset("No (%)", $no_rates, [
  1220. "background_colours" => self::COLOUR_RED,
  1221. "border_colours" => self::COLOUR_RED,
  1222. "line_tension" => 0,
  1223. "datalabels" => ["display" => false],
  1224. ]);
  1225. if($null_rates !== null) {
  1226. $chart->addDataset("No challenge", $null_rates, [
  1227. "background_colours" => self::COLOUR_CYAN,
  1228. "border_colours" => self::COLOUR_CYAN,
  1229. "line_tension" => 0,
  1230. "datalabels" => ["display" => false],
  1231. ]);
  1232. $chart->setDatalabelSuffixes("%", "%", "%");
  1233. }
  1234. $chart->print = true;
  1235. return $chart;
  1236. }
  1237. /**
  1238. * @param Template $template
  1239. */
  1240. public function setTemplate(Template $template): void {
  1241. $this->template = $template;
  1242. }
  1243. public function setCustomer(?Customer $customer): void {
  1244. $this->customer = $customer;
  1245. }
  1246. }