| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054 |
- <?php
- Core::addScript("public/js/Chart.bundle.min.js");
- Core::addScript("public/js/chartjs-plugin-datalabels.min.js");
- Core::addScript("public/js/app-reports.js");
- Core::addBreadcrumb("/account", "Account");
- Core::addBreadcrumb("/account/reports", "Reports");
- $customer = Customer::getForAdmin();
- if(!$customer) throw new Exception("You do not have permission to access this page.");
- $page_title = "$customer->name Reports";
- Core::addBreadcrumb("/account/reports?customer_id=$customer->id", $page_title);
- $date_range = http::value("date_range");
- if(!$date_range) $date_range = "ytd";
- $date_resolution = http::value("date_resolution");
- $from_quarter = http::value("from_quarter");
- $to_quarter = http::value("to_quarter");
- $project_ids = http::value("project_ids", "int");
- if(!is_array($project_ids)) $project_ids = [];
- $all_projects = Project::query([
- "customer_id" => $customer->id
- ]);
- $data = [];
- $region_data = [];
- $area_manager_data = [];
- $total_data = false;
- $locations_missing_region = [];
- $locations_missing_area_manager = [];
- $charts = [];
- $colours = [
- "#f44336",
- "#673ab7",
- "#03a9f4",
- "#4caf50",
- "#ffeb3b",
- "#ff5722",
- "#607d8b",
- "#e91e63",
- "#3f51b5",
- "#00bcd4",
- "#8bc34a",
- "#ffc107",
- "#795548",
- "#9c27b0",
- "#2196f3",
- "#009688",
- "#cddc39",
- "#ff9800",
- "#9e9e9e",
- ];
- $submit = http::value("submit");
- if($submit) {
- try {
- Core::validateCSRFToken($submit);
- $form_exception = new FormException;
- if($form_exception->hasErrors()) throw $form_exception;
- // Get all tests
- $projects = Project::query([
- "customer_id" => $customer->id,
- "id" => $project_ids
- ]);
- $tests = Test::query([
- "project_id" => $project_ids,
- "status" => Test::STATUS_COMPLETED
- ]);
- $test_count = count($tests);
- User::load(array_column($tests, "tester_id"));
- $locations = Location::load(array_column($tests, "location_id"));
- $regions = array_filter(array_column($locations, "region"));
- $area_managers = array_filter(array_column($locations, "area_manager"));
- uksort($regions, "strnatcasecmp");
- uksort($area_managers, "strnatcasecmp");
- foreach($regions as $region) {
- $region_data[$region] = [];
- }
- foreach($area_managers as $area_manager) {
- $area_manager_data[$area_manager] = [];
- }
- $has_regions = !empty($region_data);
- $has_area_managers = !empty($area_manager_data);
- foreach($locations as $location) {
- if($has_regions && !$location->region) $locations_missing_region[] = $location;
- if($has_area_managers && !$location->area_manager) $locations_missing_area_manager[] = $location;
- }
- $min_year = date("Y");
- $max_year = date("Y");
- $min_unix = strtotime("$min_year-01-01 UTC");
- $max_unix = strtotime("$max_year-12-31 23:59:59 UTC");
- switch($date_range) {
- case "ytd":
- // Nothing to do
- $date_range_label = "YTD";
- break;
- case "unbound":
- // Work out year range
- foreach($tests as $test) {
- $dt = new DateTime($test->dts_start . " UTC");
- $dt->setTimezone(new DateTimeZone(TIMEZONE));
- $year = $dt->format("Y");
- if($year < $min_year) $min_year = $year;
- if($year > $max_year) $max_year = $year;
- }
- $date_range_label = "$min_year - $max_year";
- break;
- case "custom":
- $check = strcmp($from_quarter, $to_quarter);
- if($check > 0) {
- $temp = $to_quarter;
- $from_quarter = $to_quarter;
- $to_quarter = $temp;
- }
- list($min_year, $min_quarter) = explode("-", $from_quarter);
- list($max_year, $max_quarter) = explode("-", $to_quarter);
- switch($min_quarter) {
- case 1: $unix_string = "$min_year-01-01 UTC"; break;
- case 2: $unix_string = "$min_year-04-01 UTC"; break;
- case 3: $unix_string = "$min_year-07-01 UTC"; break;
- case 4: $unix_string = "$min_year-10-01 UTC"; break;
- }
- $min_unix = strtotime($unix_string);
- switch($max_quarter) {
- case 1: $unix_string = "$max_year-03-31 23:59:59 UTC"; break;
- case 2: $unix_string = "$max_year-06-30 23:59:59 UTC"; break;
- case 3: $unix_string = "$max_year-09-30 23:59:59 UTC"; break;
- case 4: $unix_string = "$max_year-12-31 23:59:59 UTC"; break;
- }
- $max_unix = strtotime($unix_string);
- $date_range_label = "$min_year Q$min_quarter - $max_year Q$max_quarter";
- break;
- }
- $same_year = ($min_year == $max_year);
- // Filter tests based on date range
- $tests = array_filter($tests, function($test) use ($min_unix, $max_unix) {
- $project = $test->getProject();
- $dts = $project->dts_report ?: $test->dts_start;
- $dt = new DateTime($dts . " UTC");
- $unix = $dt->format("U");
- if($unix < $min_unix) {
- return false;
- }
- if($unix > $max_unix) {
- return false;
- }
- return true;
- });
- $empty_data = (object) [
- "label" => "",
- "testCount" => 0,
- "passCount" => 0,
- "failCount" => 0,
- "maleTesterCount" => 0,
- "femaleTesterCount" => 0,
- "maleChallengerCount" => 0,
- "femaleChallengerCount" => 0,
- "unspecifiedChallengerCount" => 0,
- "maleChallengeMaleCount" => 0,
- "maleChallengeMalePassCount" => 0,
- "maleChallengeMaleStages" => [0, 0, 0, 0, 0],
- "maleChallengeFemaleCount" => 0,
- "maleChallengeFemalePassCount" => 0,
- "maleChallengeFemaleStages" => [0, 0, 0, 0, 0],
- "femaleChallengeMaleCount" => 0,
- "femaleChallengeMalePassCount" => 0,
- "femaleChallengeMaleStages" => [0, 0, 0, 0, 0],
- "femaleChallengeFemaleCount" => 0,
- "femaleChallengeFemalePassCount" => 0,
- "femaleChallengeFemaleStages" => [0, 0, 0, 0, 0],
- "unknownChallengeCount" => 0,
- "unknownChallengePassCount" => 0,
- "unknownChallengeStages" => [0, 0, 0, 0, 0],
- "stage1Count" => 0,
- "stage2Count" => 0,
- "stage3Count" => 0,
- "stage4Count" => 0,
- "stage5Count" => 0,
- ];
- $total_data = (object) [
- "maleTesterCount" => 0,
- "femaleTesterCount" => 0,
- "maleChallengerCount" => 0,
- "femaleChallengerCount" => 0,
- "unspecifiedChallengerCount" => 0,
- "testCount" => 0,
- "passCount" => 0,
- "failCount" => 0,
- "stage1Count" => 0,
- "stage2Count" => 0,
- "stage3Count" => 0,
- "stage4Count" => 0,
- "stage5Count" => 0,
- ];
- $resolution_name = "";
- // Initialise date-array based on date range and resolution
- $keys = [];
- $key_labels = [];
- for($year = $min_year; $year <= $max_year; $year++) {
- switch($date_resolution) {
- case "monthly":
- $resolution_name = "Month";
- foreach(range(1, 12) as $month) {
- if(!$same_year) $label = date("M Y", mktime(0, 0, 0, $month, 1, date("Y")));
- else $label = date("M", mktime(0, 0, 0, $month, 1, date("Y")));
- $month = str_pad($month, 2, "0", STR_PAD_LEFT);
- $key = "$year-$month";
- $data[$key] = clone $empty_data;
- $data[$key]->label = $label;
- foreach($region_data as &$r) {
- $r[$key] = clone $empty_data;
- $r[$key]->label = $label;
- }
- foreach($area_manager_data as &$a) {
- $a[$key] = clone $empty_data;
- $a[$key]->label = $label;
- }
- $keys[] = $key;
- $key_labels[] = $label;
- }
- break;
- case "quarterly":
- default:
- $resolution_name = "Quarter";
- foreach(range(1, 4) as $quarter) {
- if(!$same_year) $label = "Q$quarter $year";
- else $label = "Q$quarter";
- $key = "$year-$quarter";
- $data[$key] = clone $empty_data;
- $data[$key]->label = $label;
- foreach($region_data as &$r) {
- $r[$key] = clone $empty_data;
- $r[$key]->label = $label;
- }
- foreach($area_manager_data as &$a) {
- $a[$key] = clone $empty_data;
- $a[$key]->label = $label;
- }
- $keys[] = $key;
- $key_labels[] = $label;
- }
- break;
- }
- }
- $max_unix = 0;
- // Increment counts based on test results
- foreach($tests as $test) {
- $tester = $test->getTester();
- $location = $test->getLocation();
- $project = $test->getProject();
- $region = $location->region;
- $area_manager = $location->area_manager;
- $dts = $project->dts_report ?: $test->dts_start;
- $dt = new DateTime($dts . " UTC");
- $dt->setTimezone(new DateTimeZone(TIMEZONE));
- $unix = $dt->format("U");
- $year = $dt->format("Y");
- $month = $dt->format("m");
- $quarter = ceil($month / 3);
- if($unix > $max_unix) {
- $max_unix = $unix;
- }
- switch($date_resolution) {
- case "monthly":
- $key = "$year-$month";
- break;
- case "quarterly":
- default:
- $key = "$year-$quarter";
- break;
- }
- $total_data->testCount++;
- $data[$key]->testCount++;
- if($region) $region_data[$region][$key]->testCount++;
- if($area_manager) $area_manager_data[$area_manager][$key]->testCount++;
- $stage_key = "stage" . $test->challenge_stage . "Count";
- $data[$key]->$stage_key++;
- $total_data->{$stage_key}++;
- if($test->pass) {
- $data[$key]->passCount++;
- $total_data->passCount++;
- if($region) $region_data[$region][$key]->passCount++;
- if($area_manager) $area_manager_data[$area_manager][$key]->passCount++;
- }
- else {
- $data[$key]->failCount++;
- $total_data->failCount++;
- if($region) $region_data[$region][$key]->failCount++;
- if($area_manager) $area_manager_data[$area_manager][$key]->failCount++;
- }
- if($tester->gender == "M") {
- $data[$key]->maleTesterCount++;
- $total_data->maleTesterCount++;
- }
- if($tester->gender == "F") {
- $data[$key]->femaleTesterCount++;
- $total_data->femaleTesterCount++;
- }
- if($test->challenger_gender == "M") {
- $data[$key]->maleChallengerCount++;
- $total_data->maleChallengerCount++;
- }
- else if($test->challenger_gender == "F") {
- $data[$key]->femaleChallengerCount++;
- $total_data->femaleChallengerCount++;
- }
- else {
- $data[$key]->unspecifiedChallengerCount++;
- $total_data->unspecifiedChallengerCount++;
- }
- // Mutual Genders
- if($tester->gender == "M") {
- if($test->challenger_gender == "M") {
- $data[$key]->maleChallengeMaleCount++;
- $data[$key]->maleChallengeMaleStages[$test->challenge_stage - 1]++;
- if($test->pass) $data[$key]->maleChallengeMalePassCount++;
- }
- else if($test->challenger_gender == "F") {
- $data[$key]->femaleChallengeMaleCount++;
- $data[$key]->femaleChallengeMaleStages[$test->challenge_stage - 1]++;
- if($test->pass) $data[$key]->femaleChallengeMalePassCount++;
- }
- else {
- $data[$key]->unknownChallengeCount++;
- $data[$key]->unknownChallengeStages[$test->challenge_stage - 1]++;
- if($test->pass) $data[$key]->unknownChallengePassCount++;
- }
- }
- if($tester->gender == "F") {
- if($test->challenger_gender == "M") {
- $data[$key]->maleChallengeFemaleCount++;
- $data[$key]->maleChallengeFemaleStages[$test->challenge_stage - 1]++;
- if($test->pass) $data[$key]->maleChallengeFemalePassCount++;
- }
- else if($test->challenger_gender == "F") {
- $data[$key]->femaleChallengeFemaleCount++;
- $data[$key]->femaleChallengeFemaleStages[$test->challenge_stage - 1]++;
- if($test->pass) $data[$key]->femaleChallengeFemalePassCount++;
- }
- else {
- $data[$key]->unknownChallengeCount++;
- $data[$key]->unknownChallengeStages[$test->challenge_stage - 1]++;
- if($test->pass) $data[$key]->unknownChallengePassCount++;
- }
- }
- }
- $current_month = date("m", $max_unix);
- $current_quarter = ceil(date("n", $max_unix) / 3);
- $x_data_labels = array_values(array_map(function($d) {
- return $d->label;
- }, $data));
- // Current Period
- if($date_resolution == "monthly") {
- $key = date("Y") . "-" . $current_month;
- $current_period_name = date("M Y", $max_unix);
- }
- if($date_resolution == "quarterly") {
- $key = date("Y") . "-" . $current_quarter;
- $current_period_name = "Q" . $current_quarter . " " . date("Y", $max_unix);
- }
- // 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"));
- }
- // Mutual Genders 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("Mutual Genders $date_range_label");
- $chart->setLabels(array_column($gender_keys, "label"));
- $chart->addDataset("Tests", $gender_test_counts, [
- "background_colours" => "#2196F3"
- ]);
- $charts[] = $chart;
- // Mutual Genders 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("Mutual Genders 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;
- // Mutual Genders 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");
- /*
- header("Content-Type: text/plain");
- print_r($fcf_counts);
- print_r($fcf_pass_counts);
- die();
- */
- 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("Mutual Genders 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;
- // Mutual Genders 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;
- }
- }
- catch(FormException $e) {
- $e->generateAlerts();
- }
- catch(Exception $e) {
- Core::addAlert("danger", $e->getMessage());
- }
- // Export hook
- if(!empty($action)) {
- switch($action) {
- case "export-pptx":
- case "export-odp":
- require "reports_presentation.php";
- break;
- default:
- break;
- }
- }
- }
- View::includeOnce("header", compact("page_title"));
- View::include("reports", compact("customer", "date_range", "from_quarter", "to_quarter", "date_resolution", "all_projects", "project_ids", "charts", "data", "total_data", "locations_missing_region", "locations_missing_area_manager", "region_data", "area_manager_data", "key_labels"));
- View::includeOnce("footer");
- ?>
|