| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558 |
- <?php
- // Tests by Stage
- $chart = new Chart;
- $chart->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;
- }
- ?>
|