addXAxis([ "type" => "category", "stacked" => true, ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100], "stacked" => true, ]); $get_rates = static function(string $column) use ($venue_type_data) { return array_values(array_map(static function($d) use ($column) { if($d["testCount"] === 0) return 0; return round(($d[$column] / $d["testCount"]) * 100); }, $venue_type_data)); }; $pass_rates = $get_rates("passCount"); $fail_rates = $get_rates("failCount"); $chart->setType("bar"); $chart->setTitle("Pass / Fail by Venue Type"); $chart->setLabels(array_keys($venue_type_data)); $chart->addDataset("Pass Rate (%)", $pass_rates, ["background_colours" => self::COLOUR_GREEN]); $chart->addDataset("Fail Rate (%)", $fail_rates, ["background_colours" => self::COLOUR_RED]); $chart->setDatalabelSuffixes("%", "%"); return $chart; } public function getVenueTypeChallengeStageStackedBarChart(array $venue_type_data): ?Chart { $field = $this->template->getChallengeStageField(); if(!$field) { return null; } $x_labels = $field->displayStrings; array_shift($x_labels); // Remove placeholder string $chart = new Chart(); $chart->addXAxis([ "type" => "category", "stacked" => true, ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100], "stacked" => true, ]); $get_rates = static function(string $stage_index) use ($venue_type_data) { return array_values(array_map(static function($d) use ($stage_index) { $total_count = array_sum($d["stageCounts"]); if($total_count === 0) return 0; return round(($d["stageCounts"][$stage_index] / $total_count) * 100, 1); }, $venue_type_data)); }; $bg_colours = [ self::COLOUR_GREEN, self::COLOUR_YELLOW, self::COLOUR_ORANGE, self::COLOUR_LIGHT_RED, self::COLOUR_RED, ]; $chart->setType("bar"); $chart->setTitle("Stages by Venue Type"); $chart->setLabels(array_keys($venue_type_data)); foreach($x_labels as $stage_index => $label) { $chart->addDataset("$label (%)", $get_rates($stage_index), ["background_colours" => $bg_colours[$stage_index]]); } $suffixes = array_fill(0, count($x_labels), "%"); $chart->setDatalabelSuffixes(...$suffixes); return $chart; } /** * @param array $venue_type_data * @return Chart[] */ public function getVenueTypeChallengeStagePieCharts(array $venue_type_data): array { $field = $this->template->getChallengeStageField(); if(!$field) { return []; } $x_labels = $field->displayStrings; array_shift($x_labels); // Remove placeholder string $charts = []; foreach($venue_type_data as $venue_type => $data) { $values = $data["stageCounts"]; $chart = new Chart(); $chart->setType("pie"); $chart->setTitle("Tests by Stage - $venue_type ({$this->dateRangeLabel})"); $chart->setLabels($x_labels); $chart->addDataset("Counts", $values, [ "background_colours" => [ self::COLOUR_GREEN, self::COLOUR_YELLOW, self::COLOUR_ORANGE, self::COLOUR_LIGHT_RED, self::COLOUR_RED, ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; } return $charts; } public function __construct(object $total_data, array $periodic_data) { $this->totalData = $total_data; $this->periodicData = $periodic_data; $this->xDataLabels = array_values(array_map(static function($d) { return $d->label; }, $this->periodicData)); } public function setDateRangeLabel(string $label): void { $this->dateRangeLabel = $label; } public function setResolutionName(string $name): void { $this->resolutionName = $name; } public function setPeriodKeysAndLabels(array $keys, array $labels): void { $this->periodKeys = $keys; $this->periodLabels = $labels; } public function setRegionData(array $data): void { ksort($data, SORT_NATURAL); $this->regionData = $data; } public function setAreaManagerData(array $data): void { ksort($data, SORT_NATURAL); $this->areaManagerData = $data; } public function setOperationsManagerData(array $data): void { ksort($data, SORT_NATURAL); $this->operationsManagerData = $data; } public function setBrandData(array $data): void { $this->brandData = $data; } // Charts public function getTestsByStageChart(array $labels, string $title = "Tests by Stage"): Chart { $chart = new Chart(); $chart->setType("doughnut"); $chart->setTitle("$title ({$this->dateRangeLabel})"); $chart->setLabels($labels); $chart->addDataset("Tests", [ $this->totalData->stage1Count, $this->totalData->stage2Count, $this->totalData->stage3Count, $this->totalData->stage4Count, $this->totalData->stage5Count, ], [ "background_colours" => [ self::COLOUR_GREEN, self::COLOUR_YELLOW, self::COLOUR_ORANGE, self::COLOUR_LIGHT_RED, self::COLOUR_RED, ], "datalabels" => Chart::DATALABELS_BOX, ]); $chart->setPrintSuffixes(""); $chart->print = true; $chart->printPercentages = true; $chart->printTotalColumn = true; $chart->setPrintLabels(["Stage 1", "Stage 2", "Stage 3", "Stage 4", "Stage 5"]); return $chart; } public function getChallengerGenderChart(): Chart { $chart = new Chart(); $chart->setType("pie"); $chart->setTitle("Staff Gender ({$this->dateRangeLabel})"); $chart->setLabels(["Male", "Female", "Unspecified"]); $chart->addDataset("Counts", [ $this->totalData->maleChallengerCount, $this->totalData->femaleChallengerCount, $this->totalData->unspecifiedChallengerCount, ], [ "background_colours" => [ self::COLOUR_BLUE, self::COLOUR_MAGENTA, self::COLOUR_GREY, ], "datalabels" => Chart::DATALABELS_BOX, ]); return $chart; } public function getTesterGenderChart(): Chart { $chart = new Chart(); $chart->setType("pie"); $chart->setTitle("Tester Gender ({$this->dateRangeLabel})"); $chart->setLabels(["Male", "Female"]); $chart->addDataset("Counts", [ $this->totalData->maleTesterCount, $this->totalData->femaleTesterCount, ], [ "background_colours" => [ self::COLOUR_BLUE, self::COLOUR_MAGENTA, ], "datalabels" => Chart::DATALABELS_BOX, ]); return $chart; } public function getPassFailCountChart(string $title = "Pass / Fail"): Chart { $data = $this->totalData; $dataset = [$data->passCount, $data->failCount]; $labels = ["Pass", "Fail"]; $colours = [self::COLOUR_GREEN, self::COLOUR_RED]; if($data->voidCount > 0) { $dataset[] = $data->voidCount; $labels[] = "Void"; $colours[] = self::COLOUR_GREY; } $chart = new Chart(); $chart->setType("pie"); $chart->setTitle("{$title} ({$this->dateRangeLabel})"); $chart->setLabels($labels); $chart->addDataset("Counts", $dataset, [ "background_colours" => $colours, "datalabels" => Chart::DATALABELS_BOX, ]); return $chart; } public function getPassFailCountChartByKey(string $title, string $object_key): Chart { $data = $this->totalData; $counts = $data->$object_key; $pass_count = $counts["pass"] ?? 0; $fail_count = $counts["fail"] ?? 0; $dataset = [$pass_count, $fail_count]; $labels = ["Pass", "Fail"]; $colours = [self::COLOUR_GREEN, self::COLOUR_RED]; /* if($data->voidCount > 0) { $dataset[] = $data->voidCount; $labels[] = "Void"; $colours[] = self::COLOUR_GREY; } */ $title = sprintf("%s (%s)", $title, $this->dateRangeLabel); $chart = new Chart(); $chart->setType("pie"); $chart->setTitle($title); $chart->setLabels($labels); $chart->addDataset("Counts", $dataset, [ "background_colours" => $colours, "datalabels" => Chart::DATALABELS_BOX, ]); return $chart; } public function getPeriodicPassFailRateChart(array $options = []): Chart { $title = $options["title"] ?? "Pass / Fail"; $array_key = $options["array_key"] ?? null; $pass_rates = []; $fail_rates = []; foreach($this->periodicData as $period) { if($array_key) { $pass_count = $period->$array_key["pass"]; $fail_count = $period->$array_key["fail"]; } else { $pass_count = $period->passCount; $fail_count = $period->failCount; } $test_count = $pass_count + $fail_count; if($test_count === 0) { $pass_rates[] = 0; $fail_rates[] = 0; } else { $pass_rate = round(($pass_count / $test_count) * 100); $pass_rates[] = $pass_rate; $fail_rates[] = 100 - $pass_rate; } } $chart = new Chart(); $chart->addXAxis([ "type" => "category", "stacked" => true, ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100], "stacked" => true, ]); $chart->setType("bar"); $chart->setTitle("{$title} by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addDataset("Pass Rate (%)", $pass_rates, [ "background_colours" => self::COLOUR_GREEN ]); $chart->addDataset("Fail Rate (%)", $fail_rates, [ "background_colours" => self::COLOUR_RED ]); $chart->setDatalabelSuffixes("%", "%"); return $chart; } public function getPeriodicDoorSensorAlertPassRateChart(): Chart { return $this->getPeriodicPassRateChart( "Pass Rate by Door Sensor Alert", $this->getPeriodicPassRateByDoorSensorAlert(1), $this->getPeriodicPassRateByDoorSensorAlert(0), $this->getPeriodicPassRateByDoorSensorAlert(2) ); } public function getPeriodicMachinePowerChart(): Chart { return $this->getPeriodicBooleanChart( "Machines Powered", $this->getMachinePowerRates() ); } public function getPeriodicMachineSeatChart(): Chart { return $this->getPeriodicBooleanChart( "Machine Seating", $this->getMachineSeatRates() ); } public function getPeriodicMachineTableChart(): Chart { return $this->getPeriodicBooleanChart( "Machine Table/Shelf", $this->getMachineTableRates() ); } public function getPeriodicMachineAccessibleChart(): Chart { return $this->getPeriodicBooleanChart( "Machines Accessible", $this->getMachineAccessibleRates() ); } public function getPeriodicEyeContactPassRateChart(): Chart { return $this->getPeriodicPassRateChart( "Pass Rate by Eye Contact", $this->getPeriodicPassRateByEyeContact(1), $this->getPeriodicPassRateByEyeContact(0), $this->getPeriodicPassRateByEyeContact(2) ); } public function getPeriodicLineOfSightPassRateChart(array $options = []): Chart { $title = $options["title"] ?? __("Pass Rate by Line of Sight"); $include_no_challenge = $options["include_no_challenge"] ?? true; $pass_counts = $this->getPeriodicPassRateByLineOfSight(1); $fail_counts = $this->getPeriodicPassRateByLineOfSight(0); $no_challenge_counts = $this->getPeriodicPassRateByLineOfSight(2); return $this->getPeriodicPassRateChart( $title, $pass_counts, $fail_counts, $include_no_challenge ? $no_challenge_counts : null ); } public function getPeriodicBarPurchasePassRateChart(): Chart { return $this->getPeriodicPassRateChart( "Pass Rate by Bar Purchase", $this->getPeriodicPassRateByBarPurchase(1), $this->getPeriodicPassRateByBarPurchase(0), $this->getPeriodicPassRateByBarPurchase(2) ); } public function getPeriodicPassRateChartByKey(string $title, string $object_key): Chart { $pass_rates = []; $fail_rates = []; foreach($this->periodicData as $index => $data) { $counts = $data->$object_key; $pass_count = $counts["pass"]; $fail_count = $counts["fail"]; $test_count = $pass_count + $fail_count; if($test_count === 0) { $pass_rate = 0; $fail_rate = 0; } else { $pass_rate = round(($pass_count / $test_count) * 100); $fail_rate = 100 - $pass_rate; } $pass_rates[] = $pass_rate; $fail_rates[] = $fail_rate; } $chart = new Chart(); $chart->addXAxis([ "type" => "category", "stacked" => true, ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100], "stacked" => true, ]); $chart->setType("bar"); $chart->setTitle("$title by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addDataset("Pass (%)", $pass_rates, ["background_colours" => self::COLOUR_GREEN]); $chart->addDataset("Fail (%)", $fail_rates, ["background_colours" => self::COLOUR_RED]); $chart->setDatalabelSuffixes("%", "%"); return $chart; } public function getPeriodicBooleanPassRateChart(array $rates, string $title): Chart { $chart = new Chart(); $chart->addXAxis([ "type" => "category", "stacked" => true, ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100], "stacked" => true, ]); $chart->setType("bar"); $chart->setTitle($title); $chart->setLabels($this->xDataLabels); $chart->addDataset("Yes (%)", array_column($rates, "pass"), [ "background_colours" => self::COLOUR_GREEN ]); $chart->addDataset("No (%)", array_column($rates, "fail"), [ "background_colours" => self::COLOUR_RED ]); $chart->setDatalabelSuffixes("%", "%"); return $chart; } public function getPeriodicEyeContactChart(): Chart { return $this->getPeriodicBooleanChart( "Eye Contact by {$this->resolutionName}", $this->getEyeContactRates() ); } public function getPeriodicTotalsChart(array $options = []): Chart { $title = $options["title"] ?? "Totals"; // Test counts are in "pass" and "fail" keys $array_key = $options["array_key"] ?? null; if($array_key) { $test_counts = []; $pass_rates = []; $pass_counts = []; $fail_counts = []; foreach($this->periodicData as $index => $period) { $pass_count = $period->$array_key["pass"]; $fail_count = $period->$array_key["fail"]; $test_count = $pass_count + $fail_count; $test_counts[] = $test_count; $pass_rates[] = $test_count > 0 ? round(($pass_count / $test_count) * 100) : 0; $pass_counts[] = $pass_count; $fail_counts[] = $fail_count; } } else { $test_counts = $this->getPeriodicTestCounts(); $pass_rates = $this->getPeriodicPassRates(); $pass_counts = $this->getPeriodicPassCounts(); $fail_counts = $this->getPeriodicFailCounts(); } $chart = new Chart(); $chart->setType("bar"); $chart->setTitle("{$title} by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10] ]); $chart->addYAxis([ "position" => "right", "id" => "y-axis-2", "grid_lines" => false, "tick_config" => ["min" => 0, "max" => 100] ]); $chart->addDataset("Pass Rate (%)", $pass_rates, [ "border_colours" => self::COLOUR_YELLOW, "background_colours" => "transparent", "type" => "line", "y_axis_id" => "y-axis-2", "datalabels" => [ "display" => false ], "line_tension" => 0, ]); $chart->addDataset("Test Count", $test_counts, [ "background_colours" => self::COLOUR_BLUE, "type" => "bar", "y_axis_id" => "y-axis-1", "datalabels" => [ "display" => false ], ]); $chart->addDataset("Pass", $pass_counts, [ "background_colours" => self::COLOUR_GREEN, "type" => "bar", "y_axis_id" => "y-axis-1", "datalabels" => [ "display" => false ], ]); $chart->addDataset("Fail", $fail_counts, [ "background_colours" => self::COLOUR_RED, "type" => "bar", "y_axis_id" => "y-axis-1", "datalabels" => [ "display" => false ], ]); $chart->setDatalabelSuffixes("%", "", "", ""); $chart->print = true; return $chart; } /** * @return Chart[] * @throws Exception */ public function getPointOfChallengeCharts(string $title_format, array $labels = []): array { $charts = []; foreach($this->periodKeys as $index => $key) { $key_label = $this->periodLabels[$index]; $period_data = $this->periodicData[$key]; if($period_data->testCount === 0) continue; $chart = new Chart(); $chart->setType("pie"); $chart->setTitle(sprintf($title_format, $key_label)); $chart->setLabels($labels); $chart->addDataset("Counts", [ $period_data->stage1Count, $period_data->stage2Count, $period_data->stage3Count, $period_data->stage4Count, $period_data->stage5Count, ], [ "background_colours" => [ self::COLOUR_GREEN, self::COLOUR_YELLOW, self::COLOUR_ORANGE, self::COLOUR_LIGHT_RED, self::COLOUR_RED, ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; } return $charts; } public function getPeriodicTesterGenderChart(): Chart { $male_counts = $this->getPeriodicMaleTesterCount(); $female_counts = $this->getPeriodicFemaleTesterCount(); $counts = array_merge($male_counts, $female_counts); $chart = new Chart(); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => ceil(max($counts) / 10) * 10] ]); $chart->setType("bar"); $chart->setTitle("Tester Gender by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addDataset("Male", $male_counts, [ "background_colours" => self::COLOUR_BLUE ]); $chart->addDataset("Female", $female_counts, [ "background_colours" => self::COLOUR_MAGENTA ]); return $chart; } public function getPeriodicTestCountChart(string $title = "Tests"): Chart { $test_counts = $this->getPeriodicTestCounts(); $pass_rates = $this->getPeriodicPassRates(); $pass_rate_max = ceil(max($pass_rates) / 10) * 10; $chart = new Chart(); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10] ]); $chart->addYAxis([ "id" => "y-axis-2", "tick_config" => ["min" => 0, "max" => $pass_rate_max], "position" => "right" ]); $chart->setType("bar"); $chart->setTitle("{$title} by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addDataset("Pass Rate", $pass_rates, [ "type" => "line", "y_axis_id" => "y-axis-2", "border_colours" => self::COLOUR_RED, "background_colours" => "transparent", "line_tension" => 0, "datalabels" => [ "align" => "top", "color" => self::COLOUR_DARK_GREY, "borderColor" => self::COLOUR_GREY, "borderWidth" => 1, "borderRadius" => 4, "backgroundColor" => "white", "font" => [ "weight" => "bold" ], ], "point_background_colour" => self::COLOUR_RED, ]); $chart->addDataset("Tests", $test_counts, [ "background_colours" => self::COLOUR_BLUE ]); $chart->setDatalabelSuffixes("%", ""); return $chart; } public function getGenderComparisonCharts(): array { $charts = []; $gender_keys = [ "maleChallengeMale" => [ "title" => "Male Challenge Male", "label" => "M Cha. M", ], "maleChallengeFemale" => [ "title" => "Male Challenge Female", "label" => "M Cha. F", ], "femaleChallengeMale" => [ "title" => "Female Challenge Male", "label" => "F Cha. M", ], "femaleChallengeFemale" => [ "title" => "Female Challenge Female", "label" => "F Cha. F", ], "unknownChallenge" => [ "title" => "Gender Not Specified", "label" => "Gender Not Specified", ], ]; $gender_test_counts = []; foreach($gender_keys as $gk => $gv) { $gender_test_counts[] = array_sum(array_column($this->periodicData, "{$gk}Count")); } // Gender Comparison by Date Range $chart = new Chart(); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => ceil(max($gender_test_counts) / 10) * 10] ]); $chart->setType("bar"); $chart->setTitle("Gender Comparison ({$this->dateRangeLabel})"); $chart->setLabels(array_column($gender_keys, "label")); $chart->addDataset("Tests", $gender_test_counts, [ "background_colours" => self::COLOUR_BLUE ]); $charts[] = $chart; // Gender Comparison by Resolution $mcm_counts = array_column($this->periodicData, "maleChallengeMaleCount"); $mcf_counts = array_column($this->periodicData, "maleChallengeFemaleCount"); $fcm_counts = array_column($this->periodicData, "femaleChallengeMaleCount"); $fcf_counts = array_column($this->periodicData, "femaleChallengeFemaleCount"); $ns_counts = array_column($this->periodicData, "unknownChallengeCount"); $counts = array_merge($mcm_counts, $mcf_counts, $fcm_counts, $fcf_counts); $chart = new Chart(); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => ceil(max($counts) / 10) * 10] ]); $chart->setType("bar"); $chart->setTitle("Gender Comparison by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addDataset("M Cha. M", $mcm_counts, ["background_colours" => self::COLOUR_BLUE]); $chart->addDataset("M Cha. F", $mcf_counts, ["background_colours" => self::COLOUR_DARK_BLUE]); $chart->addDataset("F Cha. M", $fcm_counts, ["background_colours" => self::COLOUR_PURPLE]); $chart->addDataset("F Cha. F", $fcf_counts, ["background_colours" => self::COLOUR_MAGENTA]); $chart->addDataset("Not Specified", $ns_counts, ["background_colours" => self::COLOUR_GREY]); $chart->print = true; $charts[] = $chart; // Gender Comparison Pass Rate by Resolution /** @noinspection PhpUnusedLocalVariableInspection */ { $mcm_pass_counts = array_column($this->periodicData, "maleChallengeMalePassCount"); $mcf_pass_counts = array_column($this->periodicData, "maleChallengeFemalePassCount"); $fcm_pass_counts = array_column($this->periodicData, "femaleChallengeMalePassCount"); $fcf_pass_counts = array_column($this->periodicData, "femaleChallengeFemalePassCount"); $ns_pass_counts = array_column($this->periodicData, "unknownChallengePassCount"); } /** * @var float $mcm_pass_rates * @var float $mcf_pass_rates * @var float $fcm_pass_rates * @var float $fcf_pass_rates * @var float $ns_pass_rates */ foreach(["mcm", "mcf", "fcm", "fcf", "ns"] as $prefix) { $pass_rates = []; $pass_counts = ${$prefix . "_pass_counts"}; $test_counts = ${$prefix . "_counts"}; foreach($test_counts as $index => $test_count) { if($test_count === 0) { $pass_rates[] = 0; continue; } $pass_rates[] = number_format(($pass_counts[$index] * 100) / $test_count, 2); } ${$prefix . "_pass_rates"} = $pass_rates; } $chart = new Chart(); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100], ]); $chart->setType("bar"); $chart->setTitle("Gender Comparison Pass Rate by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addDataset("M Cha. M", $mcm_pass_rates, ["background_colours" => self::COLOUR_BLUE, "datalabels" => ["display" => false], "line_tension" => 0]); $chart->addDataset("M Cha. F", $mcf_pass_rates, ["background_colours" => self::COLOUR_DARK_BLUE, "datalabels" => ["display" => false], "line_tension" => 0]); $chart->addDataset("F Cha. M", $fcm_pass_rates, ["background_colours" => self::COLOUR_PURPLE, "datalabels" => ["display" => false], "line_tension" => 0]); $chart->addDataset("F Cha. F", $fcf_pass_rates, ["background_colours" => self::COLOUR_MAGENTA, "datalabels" => ["display" => false], "line_tension" => 0]); $chart->addDataset("Not Specified", $ns_pass_rates, ["background_colours" => self::COLOUR_GREY, "datalabels" => ["display" => false], "line_tension" => 0]); $chart->print = true; $chart->setDatalabelSuffixes("%", "%", "%", "%", "%"); $charts[] = $chart; // Gender Comparison Point of Challenge foreach($this->periodKeys as $index => $key) { $key_label = $this->periodLabels[$index]; $period_data = $this->periodicData[$key]; foreach($gender_keys as $prefix => $gv) { $title = $gv["label"]; $test_count = $period_data->{$prefix . "Count"}; $stage_data = $period_data->{$prefix . "Stages"}; if($test_count === 0) continue; $chart = new Chart(); $chart->setType("pie"); $chart->setTitle("$key_label $title Point of Challenge"); $chart->setLabels(["On Entry", "While Browsing", "During Play", "On Exit", "No Challenge"]); $chart->addDataset("Counts", $stage_data, [ "background_colours" => [ self::COLOUR_GREEN, self::COLOUR_YELLOW, self::COLOUR_ORANGE, self::COLOUR_LIGHT_RED, self::COLOUR_RED, ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; } } return $charts; } private function getDataPassRateChart(array $data, string $entity_name): Chart { $data_values = []; $test_counts = []; $pass_counts = []; $fail_counts = []; foreach($data as $datum) { $total_test_count = array_sum(array_column($datum, "testCount")); $total_pass_count = array_sum(array_column($datum, "passCount")); $test_counts[] = $total_test_count; $pass_counts[] = $total_pass_count; $fail_counts[] = $total_test_count - $total_pass_count; $data_values[] = ($total_test_count === 0) ? 0 : round(($total_pass_count * 100) / $total_test_count); } $chart = new Chart(); $chart->addXAxis([ "type" => "category", "scale_label_config" => [ "display" => true, "labelString" => $entity_name, ] ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100] ]); $chart->setType("bar"); $chart->setTitle("{$entity_name} Pass Rate ({$this->dateRangeLabel})"); $chart->setLabels(array_keys($data)); $chart->addDataset("Pass %", $data_values , [ "background_colours" => self::COLOUR_BLUE ]); $chart->addPrintDataset("Tests", $test_counts); $chart->addPrintDataset("Pass", $pass_counts); $chart->addPrintDataset("Fail", $fail_counts); $chart->setDatalabelSuffixes("%"); $chart->print = true; $chart->printTotalColumn = true; return $chart; } public function getPeriodicDataPassRateChart(string $entity): Chart { switch($entity) { case "region": $data = $this->regionData; $entity_name = "Region"; $entity_keys = $this->getRegionKeys(); $x_labels = $this->getRegionXDataLabels(); break; case "areaManager": $data = $this->areaManagerData; $entity_name = "Area Manager"; $entity_keys = $this->getAreaManagerKeys(); $x_labels = $this->getAreaManagerKeys(); break; case "brand": $data = $this->brandData; $entity_name = "Brand"; $entity_keys = $this->getBrandKeys(); $x_labels = $this->getBrandKeys(); break; case "operationsManager": $data = $this->operationsManagerData; $entity_name = "Operations Manager"; $entity_keys = $x_labels = $this->getOperationsManagerKeys(); break; default: throw new RuntimeException("Invalid entity passed to getPeriodicDataPassRateChart: $entity"); } $chart = new Chart(); $chart->addXAxis([ "type" => "category", "scale_label_config" => [ "display" => true, "labelString" => $entity_name, ] ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100] ]); $chart->setType("bar"); $chart->setTitle("{$entity_name} Pass Rate by {$this->resolutionName}"); $chart->setLabels($x_labels); foreach($this->periodKeys as $index => $key) { $data_values = []; foreach($entity_keys as $entity_key) { $datum = $data[$entity_key][$key]; $data_values[] = ($datum->testCount === 0) ? 0 : round(($datum->passCount * 100) / $datum->testCount); } $chart->addDataset($this->periodLabels[$index], $data_values, [ "background_colours" => Chart::getColourByIndex($index), "datalabels" => [ "display" => false ] ]); } $chart->setDatalabelSuffixes(...array_fill(0, count($this->periodKeys), "%")); $chart->print = true; return $chart; } public function hasRegionData(): bool { return $this->regionData !== null; } public function getRegionPassRateChart(): Chart { return $this->getDataPassRateChart($this->regionData, "Region"); } public function getPeriodicRegionPassRateChart(): Chart { return $this->getPeriodicDataPassRateChart("region"); } public function hasAreaManagerData(): bool { return $this->areaManagerData !== null; } public function getAreaManagerPassRateChart(): Chart { return $this->getDataPassRateChart($this->areaManagerData, "Area Manager"); } public function getPeriodicAreaManagerPassRateChart(): Chart { return $this->getPeriodicDataPassRateChart("areaManager"); } public function hasBrandData(): bool { return $this->brandData !== null; } public function getBrandPassRateChart(): Chart { return $this->getDataPassRateChart($this->brandData, "Brand"); } public function getPeriodicBrandPassRateChart(): Chart { return $this->getPeriodicDataPassRateChart("brand"); } public function hasOperationsManagerData(): bool { return $this->operationsManagerData !== null; } public function getOperationsManagerPassRateChart(): Chart { return $this->getDataPassRateChart($this->operationsManagerData, "Operations Manager"); } public function getPeriodicOperationsManagerPassRateChart(): Chart { return $this->getPeriodicDataPassRateChart("operationsManager"); } public function getCleanlinessChart(): Chart { $chart = new Chart(); $chart->setType("doughnut"); $chart->setTitle("Tests by Cleanliness ({$this->dateRangeLabel})"); $chart->setLabels(["Very dirty", "Dirty", "Adequate", "Clean", "Very Clean"]); $chart->addDataset("Tests", [ $this->totalData->cleanlinessCounts[0], $this->totalData->cleanlinessCounts[1], $this->totalData->cleanlinessCounts[2], $this->totalData->cleanlinessCounts[3], $this->totalData->cleanlinessCounts[4], ], [ "background_colours" => [ self::COLOUR_RED, self::COLOUR_LIGHT_RED, self::COLOUR_ORANGE, self::COLOUR_YELLOW, self::COLOUR_GREEN, ], "datalabels" => Chart::DATALABELS_BOX, ]); $chart->setPrintSuffixes(""); $chart->print = true; $chart->printTotalColumn = true; $chart->printPercentages = true; return $chart; } /** * @return Chart[] * @throws Exception */ public function getPeriodicCleanlinessCharts(): array { $charts = []; foreach($this->periodKeys as $index => $key) { $key_label = $this->periodLabels[$index]; $period_data = $this->periodicData[$key]; if($period_data->testCount === 0) continue; $chart = new Chart(); $chart->setType("pie"); $chart->setTitle("$key_label Cleanliness"); $chart->setLabels(["Very dirty", "Dirty", "Adequate", "Clean", "Very Clean"]); $chart->addDataset("Counts", [ $period_data->cleanlinessCounts[0], $period_data->cleanlinessCounts[1], $period_data->cleanlinessCounts[2], $period_data->cleanlinessCounts[3], $period_data->cleanlinessCounts[4], ], [ "background_colours" => [ self::COLOUR_RED, self::COLOUR_LIGHT_RED, self::COLOUR_ORANGE, self::COLOUR_YELLOW, self::COLOUR_GREEN, ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; } return $charts; } public function getPeriodicStaffBadgeWornChart(): Chart { $staff_badge_worn_counts = array_column($this->periodicData, "staffBadgeWornCounts"); $unknown_counts = array_column($staff_badge_worn_counts, 0); $no_counts = array_column($staff_badge_worn_counts, 1); $yes_counts = array_column($staff_badge_worn_counts, 2); $chart = new Chart(); $chart->setType("bar"); $chart->setTitle("Staff Badge Worn by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addDataset("No challenge", $unknown_counts, [ "background_colours" => self::COLOUR_LIGHT_GREY ]); $chart->addDataset("No", $no_counts, [ "background_colours" => self::COLOUR_RED ]); $chart->addDataset("Yes", $yes_counts, [ "background_colours" => self::COLOUR_GREEN ]); return $chart; } public function getPeriodicStaffOfferedDrinkChart(): Chart { $counts = array_column($this->periodicData, "staffOfferedDrinkCounts"); return $this->getPeriodicBooleanChart("Staff Offered Drink", $counts); } public function getPeriodicStaffOfferedPromotionChart(): Chart { $counts = array_column($this->periodicData, "staffOfferedPromotionCounts"); return $this->getPeriodicBooleanChart("Staff Offered Promotion", $counts); } public function getPeriodicStaffOfferedHelpChart(): Chart { $counts = array_column($this->periodicData, "staffOfferedHelpCounts"); return $this->getPeriodicBooleanChart("Staff Offered Help", $counts); } public function getPeriodicStaffBehaviourCharts(): array { $charts = []; foreach($this->periodKeys as $index => $key) { $key_label = $this->periodLabels[$index]; $period_data = $this->periodicData[$key]; if($period_data->testCount === 0) continue; $chart = new Chart(); $chart->setType("pie"); $chart->setTitle("$key_label Staff Behaviour"); $chart->setLabels(["N/A", "Rude", "Slightly rude", "Neither rude or polite", "Polite", "Very polite"]); $chart->addDataset("Counts", [ $period_data->staffBehaviourCounts[0], $period_data->staffBehaviourCounts[1], $period_data->staffBehaviourCounts[2], $period_data->staffBehaviourCounts[3], $period_data->staffBehaviourCounts[4], $period_data->staffBehaviourCounts[5], ], [ "background_colours" => [ self::COLOUR_LIGHT_GREY, self::COLOUR_RED, self::COLOUR_LIGHT_RED, self::COLOUR_ORANGE, self::COLOUR_YELLOW, self::COLOUR_GREEN, ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; } return $charts; } public function getPeriodicStaffUniformChart(): Chart { $counts = array_column($this->periodicData, "staffUniformCounts"); return $this->getPeriodicBooleanChart("Staff Uniform", $counts); } // Private methods private function getPeriodicPassRates(): array { return array_values(array_map(static function($period) { if($period->testCount === 0) return 0; return round(($period->passCount / $period->testCount) * 100); }, $this->periodicData)); } private function getPeriodicFailRates(): array { return array_values(array_map(static function($period) { if($period->testCount === 0) return 0; $pass_rate = round(($period->passCount / $period->testCount) * 100); return 100 - $pass_rate; }, $this->periodicData)); } private function getPeriodicPassRate(string $prefix, int $index): array { $pass_field = $prefix . "PassCounts"; $fail_field = $prefix . "FailCounts"; return array_values(array_map(static function($data) use ($pass_field, $fail_field, $index) { if(!$data) return null; if(!isset($data->$pass_field)) return null; if(!isset($data->$fail_field)) return null; $pass_count = $data->$pass_field[$index]; $fail_count = $data->$fail_field[$index]; $test_count = $pass_count + $fail_count; if($test_count === 0) { return null; } return round(($pass_count / $test_count) * 100); }, $this->periodicData)); } private function getPeriodicPassRateByDoorSensorAlert(int $index): array { return $this->getPeriodicPassRate("doorSensorAlert", $index); } private function getPeriodicPassRateByEyeContact(int $index): array { return $this->getPeriodicPassRate("eyeContact", $index); } private function getPeriodicPassRateByLineOfSight(int $index): array { return $this->getPeriodicPassRate("lineOfSight", $index); } private function getPeriodicPassRateByBarPurchase(int $index): array { return $this->getPeriodicPassRate("barPurchase", $index); } private function getMachinePowerRates(): array { return $this->getBooleanRates("machinePowerCounts"); } private function getMachineSeatRates(): array { return $this->getBooleanRates("machineSeatCounts"); } private function getMachineTableRates(): array { return $this->getBooleanRates("machineTableCounts"); } private function getMachineAccessibleRates(): array { return $this->getBooleanRates("machineAccessibleCounts"); } private function getBooleanRates(string $field): array { return array_values(array_map(static function($period) use ($field) { if($period->testCount === 0) { return [0, 0, 0]; } $yes = round(($period->$field[0] / $period->testCount) * 100); $no = 100 - $yes; $na = 0; return [$yes, $no, $na]; }, $this->periodicData)); } private function getEyeContactRates(): array { return $this->getBooleanRates("eyeContactCounts"); } private function getPeriodicTestCounts(): array { return array_column($this->periodicData, "testCount"); } private function getPeriodicPassCounts(): array { return array_column($this->periodicData, "passCount"); } private function getPeriodicFailCounts(): array { return array_column($this->periodicData, "failCount"); } private function getPeriodicMaleTesterCount(): array { return array_values(array_map(static function($d) { return $d->maleTesterCount; }, $this->periodicData)); } private function getPeriodicFemaleTesterCount(): array { return array_values(array_map(static function($d) { return $d->femaleTesterCount; }, $this->periodicData)); } private function getRegionKeys(): array { if(!$this->regionData) return []; return array_keys($this->regionData); } private function getRegionXDataLabels(): array { return array_map(static function($key) { return "Region $key"; }, $this->getRegionKeys()); } private function getAreaManagerKeys(): array { if(!$this->areaManagerData) return []; return array_keys($this->areaManagerData); } private function getBrandKeys(): array { if(!$this->brandData) return []; return array_keys($this->brandData); } private function getOperationsManagerKeys(): array { return $this->operationsManagerData ? array_keys($this->operationsManagerData) : []; } private function getAreaManagerXDataLabels(): array { return $this->getAreaManagerKeys(); } private function getPeriodicBooleanChart(string $title, array $values): Chart { $no_counts = array_column($values, 0); $yes_counts = array_column($values, 1); $chart = new Chart(); $chart->setType("bar"); $chart->setTitle("{$title} by {$this->resolutionName}"); $chart->setLabels($this->xDataLabels); $chart->addDataset("Yes", $yes_counts, [ "background_colours" => self::COLOUR_GREEN ]); $chart->addDataset("No", $no_counts, [ "background_colours" => self::COLOUR_RED ]); $chart->setDatalabelSuffixes("%", "%"); return $chart; } private function getPeriodicPassRateChart(string $title, array $yes_rates, array $no_rates, ?array $null_rates = null): Chart { $chart = new Chart(); $chart->addYAxis([ "tick_config" => ["min" => 0, "max" => 100], ]); $chart->setType("bar"); $chart->setTitle($title); $chart->setLabels($this->xDataLabels); $chart->setDatalabelSuffixes("%", "%"); $chart->addDataset("Yes", $yes_rates, [ "background_colours" => self::COLOUR_GREEN, "border_colours" => self::COLOUR_GREEN, "line_tension" => 0, "datalabels" => ["display" => false], ]); $chart->addDataset("No", $no_rates, [ "background_colours" => self::COLOUR_RED, "border_colours" => self::COLOUR_RED, "line_tension" => 0, "datalabels" => ["display" => false], ]); if($null_rates !== null) { $chart->addDataset("No challenge", $null_rates, [ "background_colours" => self::COLOUR_CYAN, "border_colours" => self::COLOUR_CYAN, "line_tension" => 0, "datalabels" => ["display" => false], ]); $chart->setDatalabelSuffixes("%", "%", "%"); } $chart->print = true; return $chart; } /** * @param Template $template */ public function setTemplate(Template $template): void { $this->template = $template; } }