setType("doughnut"); $chart->setTitle("Tests by Stage $date_range_label"); $chart->setLabels(["1 - On Entry", "2 - While Browsing", "3 - During Play", "4 - On Exit", "5 - No Challenge"]); $chart->addDataset("Tests", [ $total_data->stage1Count, $total_data->stage2Count, $total_data->stage3Count, $total_data->stage4Count, $total_data->stage5Count, ], [ "background_colours" => [ "#4CAF50", "#FFEB3B", "#FBC02D", "#FFAB91", "#F44336", ], "datalabels" => Chart::DATALABELS_BOX, ]); $chart->setPrintSuffixes(""); $chart->print = true; $chart->printPercentages = true; $chart->setPrintLabels(["Stage 1", "Stage 2", "Stage 3", "Stage 4", "Stage 5"]); $charts[] = $chart; // Challenger Gender $chart = new Chart; $chart->setType("pie"); $chart->setTitle("Staff Gender $date_range_label"); $chart->setLabels(["Male", "Female", "Unspecified"]); $chart->addDataset("Counts", [ $total_data->maleChallengerCount, $total_data->femaleChallengerCount, $total_data->unspecifiedChallengerCount, ], [ "background_colours" => [ "#2196F3", "#E91E63", "#9E9E9E", ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; // Tester Gender $chart = new Chart; $chart->setType("pie"); $chart->setTitle("Tester Gender $date_range_label"); $chart->setLabels(["Male", "Female"]); $chart->addDataset("Counts", [ $total_data->maleTesterCount, $total_data->femaleTesterCount, ], [ "background_colours" => [ "#2196F3", "#E91E63", ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; // Pass / Fail $chart = new Chart; $chart->setType("pie"); $chart->setTitle("Pass / Fail $date_range_label"); $chart->setLabels(["Pass", "Fail"]); $chart->addDataset("Counts", [ $total_data->passCount, $total_data->failCount, ], [ "background_colours" => [ "#4CAF50", "#F44336", ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; // Pass Rate Period $pass_rates = array_values(array_map(function($d) { if($d->testCount == 0) return 0; return round(($d->passCount / $d->testCount) * 100); }, $data)); $fail_rates = array_values(array_map(function($d) { if($d->testCount == 0) return 0; $pass_rate = round(($d->passCount / $d->testCount) * 100); return 100 - $pass_rate; }, $data)); $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("Pass / Fail by $resolution_name"); $chart->setLabels($x_data_labels); $chart->addDataset("Pass Rate (%)", $pass_rates, [ "background_colours" => "#4CAF50" ]); $chart->addDataset("Fail Rate (%)", $fail_rates, [ "background_colours" => "#F44336" ]); $chart->setDatalabelSuffixes("%", "%"); $charts[] = $chart; // Totals by Period $test_counts = array_column($data, "testCount"); $pass_counts = array_column($data, "passCount"); $fail_counts = array_column($data, "failCount"); $chart = new Chart; $chart->setType("bar"); $chart->setTitle("Totals by $resolution_name"); $chart->setLabels($x_data_labels); $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" => "#FFEB3B", "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" => "#2196F3", "type" => "bar", "y_axis_id" => "y-axis-1", "datalabels" => [ "display" => false ], ]); $chart->addDataset("Pass", $pass_counts, [ "background_colours" => "#4CAF50", "type" => "bar", "y_axis_id" => "y-axis-1", "datalabels" => [ "display" => false ], ]); $chart->addDataset("Fail", $fail_counts, [ "background_colours" => "#F44336", "type" => "bar", "y_axis_id" => "y-axis-1", "datalabels" => [ "display" => false ], ]); $chart->setDatalabelSuffixes("%", "", "", ""); $chart->print = true; $charts[] = $chart; // Point of Challenge (Each Period) foreach($keys as $index => $key) { $key_label = $key_labels[$index]; $period_data = $data[$key]; if($period_data->testCount == 0) continue; $chart = new Chart; $chart->setType("pie"); $chart->setTitle("$key_label Point of Challenge"); $chart->setLabels(["On Entry", "While Browsing", "During Play", "On Exit", "No Challenge"]); $chart->addDataset("Counts", [ $period_data->stage1Count, $period_data->stage2Count, $period_data->stage3Count, $period_data->stage4Count, $period_data->stage5Count, ], [ "background_colours" => [ "#4CAF50", "#FFEB3B", "#FBC02D", "#FFAB91", "#F44336", ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; } // Tester Genders by Period $male_counts = array_values(array_map(function($d) { return $d->maleTesterCount; }, $data)); $female_counts = array_values(array_map(function($d) { return $d->femaleTesterCount; }, $data)); $chart = new Chart; $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => ceil(max(max($male_counts), max($female_counts)) / 10) * 10] ]); $chart->setType("bar"); $chart->setTitle("Tester Gender by $resolution_name"); $chart->setLabels($x_data_labels); $chart->addDataset("Male", $male_counts, [ "background_colours" => "#2196F3" ]); $chart->addDataset("Female", $female_counts, [ "background_colours" => "#E91E63" ]); $charts[] = $chart; // Test Count by Period $test_counts = array_values(array_map(function($d) { return $d->testCount; }, $data)); $chart = new Chart; $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10] ]); $chart->setType("bar"); $chart->setTitle("Tests by $resolution_name"); $chart->setLabels($x_data_labels); $chart->addDataset("Tests", $test_counts, [ "background_colours" => "#2196F3" ]); $charts[] = $chart; // Gender Graphs $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($data, "{$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 $date_range_label"); $chart->setLabels(array_column($gender_keys, "label")); $chart->addDataset("Tests", $gender_test_counts, [ "background_colours" => "#2196F3" ]); $charts[] = $chart; // Gender Comparison by Resolution $mcm_counts = array_column($data, "maleChallengeMaleCount"); $mcf_counts = array_column($data, "maleChallengeFemaleCount"); $fcm_counts = array_column($data, "femaleChallengeMaleCount"); $fcf_counts = array_column($data, "femaleChallengeFemaleCount"); $ns_counts = array_column($data, "unknownChallengeCount"); $chart = new Chart; $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => ceil(max(max($mcm_counts), max($mcf_counts), max($fcm_counts), max($fcf_counts)) / 10) * 10] ]); $chart->setType("bar"); $chart->setTitle("Gender Comparison by $resolution_name"); $chart->setLabels($x_data_labels); $chart->addDataset("M Cha. M", $mcm_counts, ["background_colours" => "#2196F3"]); $chart->addDataset("M Cha. F", $mcf_counts, ["background_colours" => "#3F51B5"]); $chart->addDataset("F Cha. M", $fcm_counts, ["background_colours" => "#9C27B0"]); $chart->addDataset("F Cha. F", $fcf_counts, ["background_colours" => "#E91E63"]); $chart->addDataset("Not Specified", $ns_counts, ["background_colours" => "#9E9E9E"]); $chart->print = true; $charts[] = $chart; // Gender Comparison Pass Rate by Resolution $mcm_pass_counts = array_column($data, "maleChallengeMalePassCount"); $mcf_pass_counts = array_column($data, "maleChallengeFemalePassCount"); $fcm_pass_counts = array_column($data, "femaleChallengeMalePassCount"); $fcf_pass_counts = array_column($data, "femaleChallengeFemalePassCount"); $ns_pass_counts = array_column($data, "unknownChallengePassCount"); 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 $resolution_name"); $chart->setLabels($x_data_labels); $chart->addDataset("M Cha. M", $mcm_pass_rates, ["background_colours" => "#2196F3", "datalabels" => ["display" => false], "line_tension" => 0]); $chart->addDataset("M Cha. F", $mcf_pass_rates, ["background_colours" => "#3F51B5", "datalabels" => ["display" => false], "line_tension" => 0]); $chart->addDataset("F Cha. M", $fcm_pass_rates, ["background_colours" => "#9C27B0", "datalabels" => ["display" => false], "line_tension" => 0]); $chart->addDataset("F Cha. F", $fcf_pass_rates, ["background_colours" => "#E91E63", "datalabels" => ["display" => false], "line_tension" => 0]); $chart->addDataset("Not Specified", $ns_pass_rates, ["background_colours" => "#9E9E9E", "datalabels" => ["display" => false], "line_tension" => 0]); $chart->print = true; $chart->setDatalabelSuffixes("%", "%", "%", "%", "%"); $charts[] = $chart; // Gender Comparison Point of Challenge foreach($keys as $index => $key) { $key_label = $key_labels[$index]; $period_data = $data[$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" => [ "#4CAF50", "#FFEB3B", "#FBC02D", "#FFAB91", "#F44336", ], "datalabels" => Chart::DATALABELS_BOX, ]); $charts[] = $chart; } } // Region Graphs if($has_regions) { ksort($region_data, SORT_NATURAL); $region_keys = array_keys($region_data); $x_data_labels = array_map(function($key) { return "Region $key"; }, $region_keys); // Region Pass Rate (Selected Date Range) $data_values = []; $test_counts = []; $pass_counts = []; $fail_counts = []; foreach($region_data as $region => $r_data) { $total_region_test_count = array_sum(array_column($r_data, "testCount")); $total_region_pass_count = array_sum(array_column($r_data, "passCount")); $test_counts[] = $total_region_test_count; $pass_counts[] = $total_region_pass_count; $fail_counts[] = $total_region_test_count - $total_region_pass_count; $data_values[] = ($total_region_test_count == 0) ? 0 : round(($total_region_pass_count * 100) / $total_region_test_count); } $chart = new Chart; $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100] ]); $chart->setType("bar"); $chart->setTitle("Region Pass Rate $date_range_label"); $chart->setLabels($x_data_labels); $chart->addDataset("Pass %", $data_values , [ "background_colours" => "#2196F3" ]); $chart->addPrintDataset("Tests", $test_counts); $chart->addPrintDataset("Pass", $pass_counts); $chart->addPrintDataset("Fail", $fail_counts); $chart->setDatalabelSuffixes("%"); $chart->print = true; $chart->printTotalColumn = true; $charts[] = $chart; // Region Pass Rate Period $chart = new Chart; $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100] ]); $chart->setType("bar"); $chart->setTitle("Region Pass Rate by $resolution_name"); $chart->setLabels($x_data_labels); foreach($keys as $index => $key) { $data_values = []; foreach($region_keys as $region) { $r_data = $region_data[$region][$key]; $data_values[] = ($r_data->testCount == 0) ? 0 : round(($r_data->passCount * 100) / $r_data->testCount); } $chart->addDataset($key_labels[$index], $data_values, ["background_colours" => $colours[$index]]); } $chart->setDatalabelSuffixes(...array_fill(0, count($keys), "%")); $charts[] = $chart; } // Area Manager Graphs if($has_area_managers) { ksort($area_manager_data, SORT_NATURAL); $area_manager_keys = array_keys($area_manager_data); $x_data_labels = array_map(function($key) { return "$key"; }, $area_manager_keys); // Area Pass Rate (Selected Date Range) $data_values = []; $test_counts = []; $pass_counts = []; $fail_counts = []; foreach($area_manager_data as $area_manager => $a_data) { $total_area_manager_test_count = array_sum(array_column($a_data, "testCount")); $total_area_manager_pass_count = array_sum(array_column($a_data, "passCount")); $total_area_manager_fail_count = array_sum(array_column($a_data, "failCount")); $test_counts[] = $total_area_manager_test_count; $pass_counts[] = $total_area_manager_pass_count; $fail_counts[] = $total_area_manager_fail_count; $data_values[] = ($total_region_test_count == 0) ? 0 : round(($total_area_manager_pass_count * 100) / $total_area_manager_test_count); } $chart = new Chart; $chart->addXAxis([ "type" => "category", "scale_label_config" => [ "display" => true, "labelString" => "Area Manager", ] ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100] ]); $chart->setType("bar"); $chart->setTitle("Area Manager Pass Rate $date_range_label"); $chart->setLabels($x_data_labels); $chart->addDataset("Pass %", $data_values , [ "background_colours" => "#2196F3" ]); $chart->addPrintDataset("Tests", $test_counts); $chart->addPrintDataset("Pass", $pass_counts); $chart->addPrintDataset("Fail", $fail_counts); $chart->setDatalabelSuffixes("%"); $chart->print = true; $chart->printTotalColumn = true; $charts[] = $chart; // Area Pass Rate Period $chart = new Chart; $chart->addXAxis([ "type" => "category", "scale_label_config" => [ "display" => true, "labelString" => "Area Manager", ] ]); $chart->addYAxis([ "id" => "y-axis-1", "tick_config" => ["min" => 0, "max" => 100] ]); $chart->setType("bar"); $chart->setTitle("Area Manager Pass Rate by $resolution_name"); $chart->setLabels($x_data_labels); foreach($keys as $index => $key) { $data_values = []; foreach($area_manager_keys as $area_manager) { $a_data = $area_manager_data[$area_manager][$key]; $data_values[] = ($a_data->testCount == 0) ? 0 : round(($a_data->passCount * 100) / $a_data->testCount); } $chart->addDataset($key_labels[$index], $data_values, [ "background_colours" => $colours[$index], "datalabels" => [ "display" => false, ], ]); } $chart->setDatalabelSuffixes(...array_fill(0, count($keys), "%")); $charts[] = $chart; } ?>