reports.php 28 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054
  1. <?php
  2. Core::addScript("public/js/Chart.bundle.min.js");
  3. Core::addScript("public/js/chartjs-plugin-datalabels.min.js");
  4. Core::addScript("public/js/app-reports.js");
  5. Core::addBreadcrumb("/account", "Account");
  6. Core::addBreadcrumb("/account/reports", "Reports");
  7. $customer = Customer::getForAdmin();
  8. if(!$customer) throw new Exception("You do not have permission to access this page.");
  9. $page_title = "$customer->name Reports";
  10. Core::addBreadcrumb("/account/reports?customer_id=$customer->id", $page_title);
  11. $date_range = http::value("date_range");
  12. if(!$date_range) $date_range = "ytd";
  13. $date_resolution = http::value("date_resolution");
  14. $from_quarter = http::value("from_quarter");
  15. $to_quarter = http::value("to_quarter");
  16. $project_ids = http::value("project_ids", "int");
  17. if(!is_array($project_ids)) $project_ids = [];
  18. $all_projects = Project::query([
  19. "customer_id" => $customer->id
  20. ]);
  21. $data = [];
  22. $region_data = [];
  23. $area_manager_data = [];
  24. $total_data = false;
  25. $locations_missing_region = [];
  26. $locations_missing_area_manager = [];
  27. $charts = [];
  28. $colours = [
  29. "#f44336",
  30. "#673ab7",
  31. "#03a9f4",
  32. "#4caf50",
  33. "#ffeb3b",
  34. "#ff5722",
  35. "#607d8b",
  36. "#e91e63",
  37. "#3f51b5",
  38. "#00bcd4",
  39. "#8bc34a",
  40. "#ffc107",
  41. "#795548",
  42. "#9c27b0",
  43. "#2196f3",
  44. "#009688",
  45. "#cddc39",
  46. "#ff9800",
  47. "#9e9e9e",
  48. ];
  49. $submit = http::value("submit");
  50. if($submit) {
  51. try {
  52. Core::validateCSRFToken($submit);
  53. $form_exception = new FormException;
  54. if($form_exception->hasErrors()) throw $form_exception;
  55. // Get all tests
  56. $projects = Project::query([
  57. "customer_id" => $customer->id,
  58. "id" => $project_ids
  59. ]);
  60. $tests = Test::query([
  61. "project_id" => $project_ids,
  62. "status" => Test::STATUS_COMPLETED
  63. ]);
  64. $test_count = count($tests);
  65. User::load(array_column($tests, "tester_id"));
  66. $locations = Location::load(array_column($tests, "location_id"));
  67. $regions = array_filter(array_column($locations, "region"));
  68. $area_managers = array_filter(array_column($locations, "area_manager"));
  69. uksort($regions, "strnatcasecmp");
  70. uksort($area_managers, "strnatcasecmp");
  71. foreach($regions as $region) {
  72. $region_data[$region] = [];
  73. }
  74. foreach($area_managers as $area_manager) {
  75. $area_manager_data[$area_manager] = [];
  76. }
  77. $has_regions = !empty($region_data);
  78. $has_area_managers = !empty($area_manager_data);
  79. foreach($locations as $location) {
  80. if($has_regions && !$location->region) $locations_missing_region[] = $location;
  81. if($has_area_managers && !$location->area_manager) $locations_missing_area_manager[] = $location;
  82. }
  83. $min_year = date("Y");
  84. $max_year = date("Y");
  85. $min_unix = strtotime("$min_year-01-01 UTC");
  86. $max_unix = strtotime("$max_year-12-31 23:59:59 UTC");
  87. switch($date_range) {
  88. case "ytd":
  89. // Nothing to do
  90. $date_range_label = "YTD";
  91. break;
  92. case "unbound":
  93. // Work out year range
  94. foreach($tests as $test) {
  95. $dt = new DateTime($test->dts_start . " UTC");
  96. $dt->setTimezone(new DateTimeZone(TIMEZONE));
  97. $year = $dt->format("Y");
  98. if($year < $min_year) $min_year = $year;
  99. if($year > $max_year) $max_year = $year;
  100. }
  101. $date_range_label = "$min_year - $max_year";
  102. break;
  103. case "custom":
  104. $check = strcmp($from_quarter, $to_quarter);
  105. if($check > 0) {
  106. $temp = $to_quarter;
  107. $from_quarter = $to_quarter;
  108. $to_quarter = $temp;
  109. }
  110. list($min_year, $min_quarter) = explode("-", $from_quarter);
  111. list($max_year, $max_quarter) = explode("-", $to_quarter);
  112. switch($min_quarter) {
  113. case 1: $unix_string = "$min_year-01-01 UTC"; break;
  114. case 2: $unix_string = "$min_year-04-01 UTC"; break;
  115. case 3: $unix_string = "$min_year-07-01 UTC"; break;
  116. case 4: $unix_string = "$min_year-10-01 UTC"; break;
  117. }
  118. $min_unix = strtotime($unix_string);
  119. switch($max_quarter) {
  120. case 1: $unix_string = "$max_year-03-31 23:59:59 UTC"; break;
  121. case 2: $unix_string = "$max_year-06-30 23:59:59 UTC"; break;
  122. case 3: $unix_string = "$max_year-09-30 23:59:59 UTC"; break;
  123. case 4: $unix_string = "$max_year-12-31 23:59:59 UTC"; break;
  124. }
  125. $max_unix = strtotime($unix_string);
  126. $date_range_label = "$min_year Q$min_quarter - $max_year Q$max_quarter";
  127. break;
  128. }
  129. $same_year = ($min_year == $max_year);
  130. // Filter tests based on date range
  131. $tests = array_filter($tests, function($test) use ($min_unix, $max_unix) {
  132. $project = $test->getProject();
  133. $dts = $project->dts_report ?: $test->dts_start;
  134. $dt = new DateTime($dts . " UTC");
  135. $unix = $dt->format("U");
  136. if($unix < $min_unix) {
  137. return false;
  138. }
  139. if($unix > $max_unix) {
  140. return false;
  141. }
  142. return true;
  143. });
  144. $empty_data = (object) [
  145. "label" => "",
  146. "testCount" => 0,
  147. "passCount" => 0,
  148. "failCount" => 0,
  149. "maleTesterCount" => 0,
  150. "femaleTesterCount" => 0,
  151. "maleChallengerCount" => 0,
  152. "femaleChallengerCount" => 0,
  153. "unspecifiedChallengerCount" => 0,
  154. "maleChallengeMaleCount" => 0,
  155. "maleChallengeMalePassCount" => 0,
  156. "maleChallengeMaleStages" => [0, 0, 0, 0, 0],
  157. "maleChallengeFemaleCount" => 0,
  158. "maleChallengeFemalePassCount" => 0,
  159. "maleChallengeFemaleStages" => [0, 0, 0, 0, 0],
  160. "femaleChallengeMaleCount" => 0,
  161. "femaleChallengeMalePassCount" => 0,
  162. "femaleChallengeMaleStages" => [0, 0, 0, 0, 0],
  163. "femaleChallengeFemaleCount" => 0,
  164. "femaleChallengeFemalePassCount" => 0,
  165. "femaleChallengeFemaleStages" => [0, 0, 0, 0, 0],
  166. "unknownChallengeCount" => 0,
  167. "unknownChallengePassCount" => 0,
  168. "unknownChallengeStages" => [0, 0, 0, 0, 0],
  169. "stage1Count" => 0,
  170. "stage2Count" => 0,
  171. "stage3Count" => 0,
  172. "stage4Count" => 0,
  173. "stage5Count" => 0,
  174. ];
  175. $total_data = (object) [
  176. "maleTesterCount" => 0,
  177. "femaleTesterCount" => 0,
  178. "maleChallengerCount" => 0,
  179. "femaleChallengerCount" => 0,
  180. "unspecifiedChallengerCount" => 0,
  181. "testCount" => 0,
  182. "passCount" => 0,
  183. "failCount" => 0,
  184. "stage1Count" => 0,
  185. "stage2Count" => 0,
  186. "stage3Count" => 0,
  187. "stage4Count" => 0,
  188. "stage5Count" => 0,
  189. ];
  190. $resolution_name = "";
  191. // Initialise date-array based on date range and resolution
  192. $keys = [];
  193. $key_labels = [];
  194. for($year = $min_year; $year <= $max_year; $year++) {
  195. switch($date_resolution) {
  196. case "monthly":
  197. $resolution_name = "Month";
  198. foreach(range(1, 12) as $month) {
  199. if(!$same_year) $label = date("M Y", mktime(0, 0, 0, $month, 1, date("Y")));
  200. else $label = date("M", mktime(0, 0, 0, $month, 1, date("Y")));
  201. $month = str_pad($month, 2, "0", STR_PAD_LEFT);
  202. $key = "$year-$month";
  203. $data[$key] = clone $empty_data;
  204. $data[$key]->label = $label;
  205. foreach($region_data as &$r) {
  206. $r[$key] = clone $empty_data;
  207. $r[$key]->label = $label;
  208. }
  209. foreach($area_manager_data as &$a) {
  210. $a[$key] = clone $empty_data;
  211. $a[$key]->label = $label;
  212. }
  213. $keys[] = $key;
  214. $key_labels[] = $label;
  215. }
  216. break;
  217. case "quarterly":
  218. default:
  219. $resolution_name = "Quarter";
  220. foreach(range(1, 4) as $quarter) {
  221. if(!$same_year) $label = "Q$quarter $year";
  222. else $label = "Q$quarter";
  223. $key = "$year-$quarter";
  224. $data[$key] = clone $empty_data;
  225. $data[$key]->label = $label;
  226. foreach($region_data as &$r) {
  227. $r[$key] = clone $empty_data;
  228. $r[$key]->label = $label;
  229. }
  230. foreach($area_manager_data as &$a) {
  231. $a[$key] = clone $empty_data;
  232. $a[$key]->label = $label;
  233. }
  234. $keys[] = $key;
  235. $key_labels[] = $label;
  236. }
  237. break;
  238. }
  239. }
  240. $max_unix = 0;
  241. // Increment counts based on test results
  242. foreach($tests as $test) {
  243. $tester = $test->getTester();
  244. $location = $test->getLocation();
  245. $project = $test->getProject();
  246. $region = $location->region;
  247. $area_manager = $location->area_manager;
  248. $dts = $project->dts_report ?: $test->dts_start;
  249. $dt = new DateTime($dts . " UTC");
  250. $dt->setTimezone(new DateTimeZone(TIMEZONE));
  251. $unix = $dt->format("U");
  252. $year = $dt->format("Y");
  253. $month = $dt->format("m");
  254. $quarter = ceil($month / 3);
  255. if($unix > $max_unix) {
  256. $max_unix = $unix;
  257. }
  258. switch($date_resolution) {
  259. case "monthly":
  260. $key = "$year-$month";
  261. break;
  262. case "quarterly":
  263. default:
  264. $key = "$year-$quarter";
  265. break;
  266. }
  267. $total_data->testCount++;
  268. $data[$key]->testCount++;
  269. if($region) $region_data[$region][$key]->testCount++;
  270. if($area_manager) $area_manager_data[$area_manager][$key]->testCount++;
  271. $stage_key = "stage" . $test->challenge_stage . "Count";
  272. $data[$key]->$stage_key++;
  273. $total_data->{$stage_key}++;
  274. if($test->pass) {
  275. $data[$key]->passCount++;
  276. $total_data->passCount++;
  277. if($region) $region_data[$region][$key]->passCount++;
  278. if($area_manager) $area_manager_data[$area_manager][$key]->passCount++;
  279. }
  280. else {
  281. $data[$key]->failCount++;
  282. $total_data->failCount++;
  283. if($region) $region_data[$region][$key]->failCount++;
  284. if($area_manager) $area_manager_data[$area_manager][$key]->failCount++;
  285. }
  286. if($tester->gender == "M") {
  287. $data[$key]->maleTesterCount++;
  288. $total_data->maleTesterCount++;
  289. }
  290. if($tester->gender == "F") {
  291. $data[$key]->femaleTesterCount++;
  292. $total_data->femaleTesterCount++;
  293. }
  294. if($test->challenger_gender == "M") {
  295. $data[$key]->maleChallengerCount++;
  296. $total_data->maleChallengerCount++;
  297. }
  298. else if($test->challenger_gender == "F") {
  299. $data[$key]->femaleChallengerCount++;
  300. $total_data->femaleChallengerCount++;
  301. }
  302. else {
  303. $data[$key]->unspecifiedChallengerCount++;
  304. $total_data->unspecifiedChallengerCount++;
  305. }
  306. // Mutual Genders
  307. if($tester->gender == "M") {
  308. if($test->challenger_gender == "M") {
  309. $data[$key]->maleChallengeMaleCount++;
  310. $data[$key]->maleChallengeMaleStages[$test->challenge_stage - 1]++;
  311. if($test->pass) $data[$key]->maleChallengeMalePassCount++;
  312. }
  313. else if($test->challenger_gender == "F") {
  314. $data[$key]->femaleChallengeMaleCount++;
  315. $data[$key]->femaleChallengeMaleStages[$test->challenge_stage - 1]++;
  316. if($test->pass) $data[$key]->femaleChallengeMalePassCount++;
  317. }
  318. else {
  319. $data[$key]->unknownChallengeCount++;
  320. $data[$key]->unknownChallengeStages[$test->challenge_stage - 1]++;
  321. if($test->pass) $data[$key]->unknownChallengePassCount++;
  322. }
  323. }
  324. if($tester->gender == "F") {
  325. if($test->challenger_gender == "M") {
  326. $data[$key]->maleChallengeFemaleCount++;
  327. $data[$key]->maleChallengeFemaleStages[$test->challenge_stage - 1]++;
  328. if($test->pass) $data[$key]->maleChallengeFemalePassCount++;
  329. }
  330. else if($test->challenger_gender == "F") {
  331. $data[$key]->femaleChallengeFemaleCount++;
  332. $data[$key]->femaleChallengeFemaleStages[$test->challenge_stage - 1]++;
  333. if($test->pass) $data[$key]->femaleChallengeFemalePassCount++;
  334. }
  335. else {
  336. $data[$key]->unknownChallengeCount++;
  337. $data[$key]->unknownChallengeStages[$test->challenge_stage - 1]++;
  338. if($test->pass) $data[$key]->unknownChallengePassCount++;
  339. }
  340. }
  341. }
  342. $current_month = date("m", $max_unix);
  343. $current_quarter = ceil(date("n", $max_unix) / 3);
  344. $x_data_labels = array_values(array_map(function($d) {
  345. return $d->label;
  346. }, $data));
  347. // Current Period
  348. if($date_resolution == "monthly") {
  349. $key = date("Y") . "-" . $current_month;
  350. $current_period_name = date("M Y", $max_unix);
  351. }
  352. if($date_resolution == "quarterly") {
  353. $key = date("Y") . "-" . $current_quarter;
  354. $current_period_name = "Q" . $current_quarter . " " . date("Y", $max_unix);
  355. }
  356. // Tests by Stage
  357. $chart = new Chart;
  358. $chart->setType("doughnut");
  359. $chart->setTitle("Tests by Stage $date_range_label");
  360. $chart->setLabels(["1 - On Entry", "2 - While Browsing", "3 - During Play", "4 - On Exit", "5 - No Challenge"]);
  361. $chart->addDataset("Tests", [
  362. $total_data->stage1Count,
  363. $total_data->stage2Count,
  364. $total_data->stage3Count,
  365. $total_data->stage4Count,
  366. $total_data->stage5Count,
  367. ], [
  368. "background_colours" => [
  369. "#4CAF50",
  370. "#FFEB3B",
  371. "#FBC02D",
  372. "#FFAB91",
  373. "#F44336",
  374. ],
  375. "datalabels" => Chart::DATALABELS_BOX,
  376. ]);
  377. $chart->setPrintSuffixes("");
  378. $chart->print = true;
  379. $chart->printPercentages = true;
  380. $chart->setPrintLabels(["Stage 1", "Stage 2", "Stage 3", "Stage 4", "Stage 5"]);
  381. $charts[] = $chart;
  382. // Challenger Gender
  383. $chart = new Chart;
  384. $chart->setType("pie");
  385. $chart->setTitle("Staff Gender $date_range_label");
  386. $chart->setLabels(["Male", "Female", "Unspecified"]);
  387. $chart->addDataset("Counts", [
  388. $total_data->maleChallengerCount,
  389. $total_data->femaleChallengerCount,
  390. $total_data->unspecifiedChallengerCount,
  391. ], [
  392. "background_colours" => [
  393. "#2196F3",
  394. "#E91E63",
  395. "#9E9E9E",
  396. ],
  397. "datalabels" => Chart::DATALABELS_BOX,
  398. ]);
  399. $charts[] = $chart;
  400. // Tester Gender
  401. $chart = new Chart;
  402. $chart->setType("pie");
  403. $chart->setTitle("Tester Gender $date_range_label");
  404. $chart->setLabels(["Male", "Female"]);
  405. $chart->addDataset("Counts", [
  406. $total_data->maleTesterCount,
  407. $total_data->femaleTesterCount,
  408. ], [
  409. "background_colours" => [
  410. "#2196F3",
  411. "#E91E63",
  412. ],
  413. "datalabels" => Chart::DATALABELS_BOX,
  414. ]);
  415. $charts[] = $chart;
  416. // Pass / Fail
  417. $chart = new Chart;
  418. $chart->setType("pie");
  419. $chart->setTitle("Pass / Fail $date_range_label");
  420. $chart->setLabels(["Pass", "Fail"]);
  421. $chart->addDataset("Counts", [
  422. $total_data->passCount,
  423. $total_data->failCount,
  424. ], [
  425. "background_colours" => [
  426. "#4CAF50",
  427. "#F44336",
  428. ],
  429. "datalabels" => Chart::DATALABELS_BOX,
  430. ]);
  431. $charts[] = $chart;
  432. // Pass Rate Period
  433. $pass_rates = array_values(array_map(function($d) {
  434. if($d->testCount == 0) return 0;
  435. return round(($d->passCount / $d->testCount) * 100);
  436. }, $data));
  437. $fail_rates = array_values(array_map(function($d) {
  438. if($d->testCount == 0) return 0;
  439. $pass_rate = round(($d->passCount / $d->testCount) * 100);
  440. return 100 - $pass_rate;
  441. }, $data));
  442. $chart = new Chart;
  443. $chart->addXAxis([
  444. "type" => "category",
  445. "stacked" => true,
  446. ]);
  447. $chart->addYAxis([
  448. "id" => "y-axis-1",
  449. "tick_config" => ["min" => 0, "max" => 100],
  450. "stacked" => true,
  451. ]);
  452. $chart->setType("bar");
  453. $chart->setTitle("Pass / Fail by $resolution_name");
  454. $chart->setLabels($x_data_labels);
  455. $chart->addDataset("Pass Rate (%)", $pass_rates, [
  456. "background_colours" => "#4CAF50"
  457. ]);
  458. $chart->addDataset("Fail Rate (%)", $fail_rates, [
  459. "background_colours" => "#F44336"
  460. ]);
  461. $chart->setDatalabelSuffixes("%", "%");
  462. $charts[] = $chart;
  463. // Totals by Period
  464. $test_counts = array_column($data, "testCount");
  465. $pass_counts = array_column($data, "passCount");
  466. $fail_counts = array_column($data, "failCount");
  467. $chart = new Chart;
  468. $chart->setType("bar");
  469. $chart->setTitle("Totals by $resolution_name");
  470. $chart->setLabels($x_data_labels);
  471. $chart->addYAxis([
  472. "id" => "y-axis-1",
  473. "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10]
  474. ]);
  475. $chart->addYAxis([
  476. "position" => "right",
  477. "id" => "y-axis-2",
  478. "grid_lines" => false,
  479. "tick_config" => ["min" => 0, "max" => 100]
  480. ]);
  481. $chart->addDataset("Pass Rate (%)", $pass_rates, [
  482. "border_colours" => "#FFEB3B",
  483. "background_colours" => "transparent",
  484. "type" => "line",
  485. "y_axis_id" => "y-axis-2",
  486. "datalabels" => [
  487. "display" => false
  488. ],
  489. "line_tension" => 0,
  490. ]);
  491. $chart->addDataset("Test Count", $test_counts, [
  492. "background_colours" => "#2196F3",
  493. "type" => "bar",
  494. "y_axis_id" => "y-axis-1",
  495. "datalabels" => [
  496. "display" => false
  497. ],
  498. ]);
  499. $chart->addDataset("Pass", $pass_counts, [
  500. "background_colours" => "#4CAF50",
  501. "type" => "bar",
  502. "y_axis_id" => "y-axis-1",
  503. "datalabels" => [
  504. "display" => false
  505. ],
  506. ]);
  507. $chart->addDataset("Fail", $fail_counts, [
  508. "background_colours" => "#F44336",
  509. "type" => "bar",
  510. "y_axis_id" => "y-axis-1",
  511. "datalabels" => [
  512. "display" => false
  513. ],
  514. ]);
  515. $chart->setDatalabelSuffixes("%", "", "", "");
  516. $chart->print = true;
  517. $charts[] = $chart;
  518. // Point of Challenge (Each Period)
  519. foreach($keys as $index => $key) {
  520. $key_label = $key_labels[$index];
  521. $period_data = $data[$key];
  522. if($period_data->testCount == 0) continue;
  523. $chart = new Chart;
  524. $chart->setType("pie");
  525. $chart->setTitle("$key_label Point of Challenge");
  526. $chart->setLabels(["On Entry", "While Browsing", "During Play", "On Exit", "No Challenge"]);
  527. $chart->addDataset("Counts", [
  528. $period_data->stage1Count,
  529. $period_data->stage2Count,
  530. $period_data->stage3Count,
  531. $period_data->stage4Count,
  532. $period_data->stage5Count,
  533. ], [
  534. "background_colours" => [
  535. "#4CAF50",
  536. "#FFEB3B",
  537. "#FBC02D",
  538. "#FFAB91",
  539. "#F44336",
  540. ],
  541. "datalabels" => Chart::DATALABELS_BOX,
  542. ]);
  543. $charts[] = $chart;
  544. }
  545. // Tester Genders by Period
  546. $male_counts = array_values(array_map(function($d) {
  547. return $d->maleTesterCount;
  548. }, $data));
  549. $female_counts = array_values(array_map(function($d) {
  550. return $d->femaleTesterCount;
  551. }, $data));
  552. $chart = new Chart;
  553. $chart->addYAxis([
  554. "id" => "y-axis-1",
  555. "tick_config" => ["min" => 0, "max" => ceil(max(max($male_counts), max($female_counts)) / 10) * 10]
  556. ]);
  557. $chart->setType("bar");
  558. $chart->setTitle("Tester Gender by $resolution_name");
  559. $chart->setLabels($x_data_labels);
  560. $chart->addDataset("Male", $male_counts, [
  561. "background_colours" => "#2196F3"
  562. ]);
  563. $chart->addDataset("Female", $female_counts, [
  564. "background_colours" => "#E91E63"
  565. ]);
  566. $charts[] = $chart;
  567. // Test Count by Period
  568. $test_counts = array_values(array_map(function($d) {
  569. return $d->testCount;
  570. }, $data));
  571. $chart = new Chart;
  572. $chart->addYAxis([
  573. "id" => "y-axis-1",
  574. "tick_config" => ["min" => 0, "max" => ceil(max($test_counts) / 10) * 10]
  575. ]);
  576. $chart->setType("bar");
  577. $chart->setTitle("Tests by $resolution_name");
  578. $chart->setLabels($x_data_labels);
  579. $chart->addDataset("Tests", $test_counts, [
  580. "background_colours" => "#2196F3"
  581. ]);
  582. $charts[] = $chart;
  583. // Gender Graphs
  584. $gender_keys = [
  585. "maleChallengeMale" => [
  586. "title" => "Male Challenge Male",
  587. "label" => "M Cha. M",
  588. ],
  589. "maleChallengeFemale" => [
  590. "title" => "Male Challenge Female",
  591. "label" => "M Cha. F",
  592. ],
  593. "femaleChallengeMale" => [
  594. "title" => "Female Challenge Male",
  595. "label" => "F Cha. M",
  596. ],
  597. "femaleChallengeFemale" => [
  598. "title" => "Female Challenge Female",
  599. "label" => "F Cha. F",
  600. ],
  601. "unknownChallenge" => [
  602. "title" => "Gender Not Specified",
  603. "label" => "Gender Not Specified",
  604. ],
  605. ];
  606. $gender_test_counts = [];
  607. foreach($gender_keys as $gk => $gv) {
  608. $gender_test_counts[] = array_sum(array_column($data, "{$gk}Count"));
  609. }
  610. // Mutual Genders by Date Range
  611. $chart = new Chart;
  612. $chart->addYAxis([
  613. "id" => "y-axis-1",
  614. "tick_config" => ["min" => 0, "max" => ceil(max($gender_test_counts) / 10) * 10]
  615. ]);
  616. $chart->setType("bar");
  617. $chart->setTitle("Mutual Genders $date_range_label");
  618. $chart->setLabels(array_column($gender_keys, "label"));
  619. $chart->addDataset("Tests", $gender_test_counts, [
  620. "background_colours" => "#2196F3"
  621. ]);
  622. $charts[] = $chart;
  623. // Mutual Genders by Resolution
  624. $mcm_counts = array_column($data, "maleChallengeMaleCount");
  625. $mcf_counts = array_column($data, "maleChallengeFemaleCount");
  626. $fcm_counts = array_column($data, "femaleChallengeMaleCount");
  627. $fcf_counts = array_column($data, "femaleChallengeFemaleCount");
  628. $ns_counts = array_column($data, "unknownChallengeCount");
  629. $chart = new Chart;
  630. $chart->addYAxis([
  631. "id" => "y-axis-1",
  632. "tick_config" => ["min" => 0, "max" => ceil(max(max($mcm_counts), max($mcf_counts), max($fcm_counts), max($fcf_counts)) / 10) * 10]
  633. ]);
  634. $chart->setType("bar");
  635. $chart->setTitle("Mutual Genders by $resolution_name");
  636. $chart->setLabels($x_data_labels);
  637. $chart->addDataset("M Cha. M", $mcm_counts, ["background_colours" => "#2196F3"]);
  638. $chart->addDataset("M Cha. F", $mcf_counts, ["background_colours" => "#3F51B5"]);
  639. $chart->addDataset("F Cha. M", $fcm_counts, ["background_colours" => "#9C27B0"]);
  640. $chart->addDataset("F Cha. F", $fcf_counts, ["background_colours" => "#E91E63"]);
  641. $chart->addDataset("Not Specified", $ns_counts, ["background_colours" => "#9E9E9E"]);
  642. $chart->print = true;
  643. $charts[] = $chart;
  644. // Mutual Genders Pass Rate by Resolution
  645. $mcm_pass_counts = array_column($data, "maleChallengeMalePassCount");
  646. $mcf_pass_counts = array_column($data, "maleChallengeFemalePassCount");
  647. $fcm_pass_counts = array_column($data, "femaleChallengeMalePassCount");
  648. $fcf_pass_counts = array_column($data, "femaleChallengeFemalePassCount");
  649. $ns_pass_counts = array_column($data, "unknownChallengePassCount");
  650. /*
  651. header("Content-Type: text/plain");
  652. print_r($fcf_counts);
  653. print_r($fcf_pass_counts);
  654. die();
  655. */
  656. foreach(["mcm", "mcf", "fcm", "fcf", "ns"] as $prefix) {
  657. $pass_rates = [];
  658. $pass_counts = ${$prefix . "_pass_counts"};
  659. $test_counts = ${$prefix . "_counts"};
  660. foreach($test_counts as $index => $test_count) {
  661. if($test_count == 0) {
  662. $pass_rates[] = 0;
  663. continue;
  664. }
  665. $pass_rates[] = number_format(($pass_counts[$index] * 100) / $test_count, 2);
  666. }
  667. ${$prefix . "_pass_rates"} = $pass_rates;
  668. }
  669. $chart = new Chart;
  670. $chart->addYAxis([
  671. "id" => "y-axis-1",
  672. "tick_config" => ["min" => 0, "max" => 100],
  673. ]);
  674. $chart->setType("bar");
  675. $chart->setTitle("Mutual Genders Pass Rate by $resolution_name");
  676. $chart->setLabels($x_data_labels);
  677. $chart->addDataset("M Cha. M", $mcm_pass_rates, ["background_colours" => "#2196F3", "datalabels" => ["display" => false], "line_tension" => 0]);
  678. $chart->addDataset("M Cha. F", $mcf_pass_rates, ["background_colours" => "#3F51B5", "datalabels" => ["display" => false], "line_tension" => 0]);
  679. $chart->addDataset("F Cha. M", $fcm_pass_rates, ["background_colours" => "#9C27B0", "datalabels" => ["display" => false], "line_tension" => 0]);
  680. $chart->addDataset("F Cha. F", $fcf_pass_rates, ["background_colours" => "#E91E63", "datalabels" => ["display" => false], "line_tension" => 0]);
  681. $chart->addDataset("Not Specified", $ns_pass_rates, ["background_colours" => "#9E9E9E", "datalabels" => ["display" => false], "line_tension" => 0]);
  682. $chart->print = true;
  683. $chart->setDatalabelSuffixes("%", "%", "%", "%", "%");
  684. $charts[] = $chart;
  685. // Mutual Genders Point of Challenge
  686. foreach($keys as $index => $key) {
  687. $key_label = $key_labels[$index];
  688. $period_data = $data[$key];
  689. foreach($gender_keys as $prefix => $gv) {
  690. $title = $gv["label"];
  691. $test_count = $period_data->{$prefix . "Count"};
  692. $stage_data = $period_data->{$prefix . "Stages"};
  693. if($test_count == 0) continue;
  694. $chart = new Chart;
  695. $chart->setType("pie");
  696. $chart->setTitle("$key_label $title Point of Challenge");
  697. $chart->setLabels(["On Entry", "While Browsing", "During Play", "On Exit", "No Challenge"]);
  698. $chart->addDataset("Counts", $stage_data, [
  699. "background_colours" => [
  700. "#4CAF50",
  701. "#FFEB3B",
  702. "#FBC02D",
  703. "#FFAB91",
  704. "#F44336",
  705. ],
  706. "datalabels" => Chart::DATALABELS_BOX,
  707. ]);
  708. $charts[] = $chart;
  709. }
  710. }
  711. // Region Graphs
  712. if($has_regions) {
  713. ksort($region_data, SORT_NATURAL);
  714. $region_keys = array_keys($region_data);
  715. $x_data_labels = array_map(function($key) {
  716. return "Region $key";
  717. }, $region_keys);
  718. // Region Pass Rate (Selected Date Range)
  719. $data_values = [];
  720. $test_counts = [];
  721. $pass_counts = [];
  722. $fail_counts = [];
  723. foreach($region_data as $region => $r_data) {
  724. $total_region_test_count = array_sum(array_column($r_data, "testCount"));
  725. $total_region_pass_count = array_sum(array_column($r_data, "passCount"));
  726. $test_counts[] = $total_region_test_count;
  727. $pass_counts[] = $total_region_pass_count;
  728. $fail_counts[] = $total_region_test_count - $total_region_pass_count;
  729. $data_values[] = ($total_region_test_count == 0) ? 0 : round(($total_region_pass_count * 100) / $total_region_test_count);
  730. }
  731. $chart = new Chart;
  732. $chart->addYAxis([
  733. "id" => "y-axis-1",
  734. "tick_config" => ["min" => 0, "max" => 100]
  735. ]);
  736. $chart->setType("bar");
  737. $chart->setTitle("Region Pass Rate $date_range_label");
  738. $chart->setLabels($x_data_labels);
  739. $chart->addDataset("Pass %", $data_values , [
  740. "background_colours" => "#2196F3"
  741. ]);
  742. $chart->addPrintDataset("Tests", $test_counts);
  743. $chart->addPrintDataset("Pass", $pass_counts);
  744. $chart->addPrintDataset("Fail", $fail_counts);
  745. $chart->setDatalabelSuffixes("%");
  746. $chart->print = true;
  747. $chart->printTotalColumn = true;
  748. $charts[] = $chart;
  749. // Region Pass Rate Period
  750. $chart = new Chart;
  751. $chart->addYAxis([
  752. "id" => "y-axis-1",
  753. "tick_config" => ["min" => 0, "max" => 100]
  754. ]);
  755. $chart->setType("bar");
  756. $chart->setTitle("Region Pass Rate by $resolution_name");
  757. $chart->setLabels($x_data_labels);
  758. foreach($keys as $index => $key) {
  759. $data_values = [];
  760. foreach($region_keys as $region) {
  761. $r_data = $region_data[$region][$key];
  762. $data_values[] = ($r_data->testCount == 0) ? 0 : round(($r_data->passCount * 100) / $r_data->testCount);
  763. }
  764. $chart->addDataset($key_labels[$index], $data_values, ["background_colours" => $colours[$index]]);
  765. }
  766. $chart->setDatalabelSuffixes(...array_fill(0, count($keys), "%"));
  767. $charts[] = $chart;
  768. }
  769. // Area Manager Graphs
  770. if($has_area_managers) {
  771. ksort($area_manager_data, SORT_NATURAL);
  772. $area_manager_keys = array_keys($area_manager_data);
  773. $x_data_labels = array_map(function($key) {
  774. return "$key";
  775. }, $area_manager_keys);
  776. // Area Pass Rate (Selected Date Range)
  777. $data_values = [];
  778. $test_counts = [];
  779. $pass_counts = [];
  780. $fail_counts = [];
  781. foreach($area_manager_data as $area_manager => $a_data) {
  782. $total_area_manager_test_count = array_sum(array_column($a_data, "testCount"));
  783. $total_area_manager_pass_count = array_sum(array_column($a_data, "passCount"));
  784. $total_area_manager_fail_count = array_sum(array_column($a_data, "failCount"));
  785. $test_counts[] = $total_area_manager_test_count;
  786. $pass_counts[] = $total_area_manager_pass_count;
  787. $fail_counts[] = $total_area_manager_fail_count;
  788. $data_values[] = ($total_region_test_count == 0) ? 0 : round(($total_area_manager_pass_count * 100) / $total_area_manager_test_count);
  789. }
  790. $chart = new Chart;
  791. $chart->addXAxis([
  792. "type" => "category",
  793. "scale_label_config" => [
  794. "display" => true,
  795. "labelString" => "Area Manager",
  796. ]
  797. ]);
  798. $chart->addYAxis([
  799. "id" => "y-axis-1",
  800. "tick_config" => ["min" => 0, "max" => 100]
  801. ]);
  802. $chart->setType("bar");
  803. $chart->setTitle("Area Manager Pass Rate $date_range_label");
  804. $chart->setLabels($x_data_labels);
  805. $chart->addDataset("Pass %", $data_values , [
  806. "background_colours" => "#2196F3"
  807. ]);
  808. $chart->addPrintDataset("Tests", $test_counts);
  809. $chart->addPrintDataset("Pass", $pass_counts);
  810. $chart->addPrintDataset("Fail", $fail_counts);
  811. $chart->setDatalabelSuffixes("%");
  812. $chart->print = true;
  813. $chart->printTotalColumn = true;
  814. $charts[] = $chart;
  815. // Area Pass Rate Period
  816. $chart = new Chart;
  817. $chart->addXAxis([
  818. "type" => "category",
  819. "scale_label_config" => [
  820. "display" => true,
  821. "labelString" => "Area Manager",
  822. ]
  823. ]);
  824. $chart->addYAxis([
  825. "id" => "y-axis-1",
  826. "tick_config" => ["min" => 0, "max" => 100]
  827. ]);
  828. $chart->setType("bar");
  829. $chart->setTitle("Area Manager Pass Rate by $resolution_name");
  830. $chart->setLabels($x_data_labels);
  831. foreach($keys as $index => $key) {
  832. $data_values = [];
  833. foreach($area_manager_keys as $area_manager) {
  834. $a_data = $area_manager_data[$area_manager][$key];
  835. $data_values[] = ($a_data->testCount == 0) ? 0 : round(($a_data->passCount * 100) / $a_data->testCount);
  836. }
  837. $chart->addDataset($key_labels[$index], $data_values, [
  838. "background_colours" => $colours[$index],
  839. "datalabels" => [
  840. "display" => false,
  841. ],
  842. ]);
  843. }
  844. $chart->setDatalabelSuffixes(...array_fill(0, count($keys), "%"));
  845. $charts[] = $chart;
  846. }
  847. }
  848. catch(FormException $e) {
  849. $e->generateAlerts();
  850. }
  851. catch(Exception $e) {
  852. Core::addAlert("danger", $e->getMessage());
  853. }
  854. // Export hook
  855. if(!empty($action)) {
  856. switch($action) {
  857. case "export-pptx":
  858. case "export-odp":
  859. require "reports_presentation.php";
  860. break;
  861. default:
  862. break;
  863. }
  864. }
  865. }
  866. View::includeOnce("header", compact("page_title"));
  867. 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"));
  868. View::includeOnce("footer");
  869. ?>