performance.php 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320
  1. <?php
  2. Core::addScript("public/js/Chart.bundle.min.js");
  3. Core::addScript("public/js/app-performance.js");
  4. Core::addBreadcrumb("/account", "Account");
  5. Core::addBreadcrumb("/account/performance", "Performance");
  6. $customer = Customer::getForAdmin();
  7. if(!$customer) throw new Exception("You do not have permission to access this page.");
  8. $page_title = "$customer->name Performance";
  9. Core::addBreadcrumb("/account/performance?customer_id=$customer->id", $page_title);
  10. $date_range = http::value("date_range");
  11. $date_resolution = http::value("date_resolution");
  12. $project_ids = http::value("project_ids", "int");
  13. if(!is_array($project_ids)) $project_ids = [];
  14. $all_projects = Project::query([
  15. "customer_id" => $customer->id
  16. ]);
  17. $data = [];
  18. $charts = [];
  19. $submit = http::value("submit");
  20. if($submit) {
  21. try {
  22. Core::validateCSRFToken($submit);
  23. $form_exception = new FormException;
  24. if($form_exception->hasErrors()) throw $form_exception;
  25. // Get all tests
  26. $projects = Project::query([
  27. "customer_id" => $customer->id,
  28. "id" => $project_ids,
  29. ]);
  30. $tests = Test::query([
  31. "project_id" => $project_ids,
  32. "status" => Test::STATUS_COMPLETED
  33. ]);
  34. User::load(array_column($tests, "tester_id"));
  35. $min_year = date("Y");
  36. $max_year = date("Y");
  37. switch($date_range) {
  38. case "ytd":
  39. // Nothing to do
  40. break;
  41. case "unbound":
  42. // Work out year range
  43. foreach($tests as $test) {
  44. $dt = new DateTime($test->dts_start . " UTC");
  45. $dt->setTimezone(new DateTimeZone(TIMEZONE));
  46. $year = $dt->format("Y");
  47. if($year < $min_year) $min_year = $year;
  48. if($year > $max_year) $max_year = $year;
  49. }
  50. break;
  51. case "custom":
  52. // TODO
  53. break;
  54. }
  55. $empty_data = (object) [
  56. "label" => "",
  57. "testCount" => 0,
  58. "passCount" => 0,
  59. "failCount" => 0,
  60. "maleTesterCount" => 0,
  61. "femaleTesterCount" => 0,
  62. "maleChallengerCount" => 0,
  63. "femaleChallengerCount" => 0,
  64. "maleChallengeMaleCount" => 0,
  65. "maleChallengeMalePassCount" => 0,
  66. "maleChallengeFemaleCount" => 0,
  67. "maleChallengeFemalePassCount" => 0,
  68. "femaleChallengeMaleCount" => 0,
  69. "femaleChallengeMalePassCount" => 0,
  70. "femaleChallengeFemaleCount" => 0,
  71. "femaleChallengeFemalePassCount" => 0,
  72. ];
  73. $total_data = (object) [
  74. "maleTesterCount" => 0,
  75. "femaleTesterCount" => 0,
  76. "maleChallengerCount" => 0,
  77. "femaleChallengerCount" => 0,
  78. "passCount" => 0,
  79. "failCount" => 0,
  80. ];
  81. // Initialise date-array based on date range and resolution
  82. for($year = $min_year; $year <= $max_year; $year++) {
  83. switch($date_resolution) {
  84. case "monthly":
  85. foreach(range(1, 12) as $month) {
  86. $month = str_pad($month, 2, "0", STR_PAD_LEFT);
  87. $key = "$year-$month";
  88. $data[$key] = clone $empty_data;
  89. $data[$key]->label = date("M Y", mktime(0, 0, 0, $month, 1, date("Y")));
  90. }
  91. break;
  92. case "quarterly":
  93. default:
  94. foreach(range(1, 4) as $quarter) {
  95. $key = "$year-$quarter";
  96. $data[$key] = clone $empty_data;
  97. $data[$key]->label = "Q$quarter $year";
  98. }
  99. break;
  100. }
  101. }
  102. // Increment counts based on test results
  103. foreach($tests as $test) {
  104. $tester = $test->getTester();
  105. $dt = new DateTime($test->dts_start . " UTC");
  106. $dt->setTimezone(new DateTimeZone(TIMEZONE));
  107. $year = $dt->format("Y");
  108. $month = $dt->format("m");
  109. $quarter = ceil($month / 3);
  110. switch($date_resolution) {
  111. case "monthly":
  112. $key = "$year-$month";
  113. break;
  114. case "quarterly":
  115. default:
  116. $key = "$year-$quarter";
  117. break;
  118. }
  119. $data[$key]->testCount++;
  120. if($test->pass) {
  121. $data[$key]->passCount++;
  122. $total_data->passCount++;
  123. }
  124. else {
  125. $data[$key]->failCount++;
  126. $total_data->failCount++;
  127. }
  128. if($tester->gender == "M") {
  129. $data[$key]->maleTesterCount++;
  130. $total_data->maleTesterCount++;
  131. }
  132. if($tester->gender == "F") {
  133. $data[$key]->femaleTesterCount++;
  134. $total_data->femaleTesterCount++;
  135. }
  136. if($test->challenger_gender == "M") {
  137. $data[$key]->maleChallengerCount++;
  138. $total_data->maleChallengerCount++;
  139. }
  140. if($test->challenger_gender == "F") {
  141. $data[$key]->femaleChallengerCount++;
  142. $total_data->femaleChallengerCount++;
  143. }
  144. if($tester->gender == "M") {
  145. if($test->challenger_gender == "M") {
  146. $data[$key]->maleChallengeMaleCount++;
  147. if($test->pass) $data[$key]->maleChallengeMalePassCount++;
  148. }
  149. if($test->challenger_gender == "F") {
  150. $data[$key]->femaleChallengeMaleCount++;
  151. if($test->pass) $data[$key]->femaleChallengeMalePassCount++;
  152. }
  153. }
  154. if($tester->gender == "F") {
  155. if($test->challenger_gender == "M") {
  156. $data[$key]->maleChallengeFemaleCount++;
  157. if($test->pass) $data[$key]->maleChallengeFemalePassCount++;
  158. }
  159. if($test->challenger_gender == "F") {
  160. $data[$key]->femaleChallengeFemaleCount++;
  161. if($test->pass) $data[$key]->femaleChallengeFemalePassCount++;
  162. }
  163. }
  164. }
  165. $x_data_labels = array_values(array_map(function($d) {
  166. return $d->label;
  167. }, $data));
  168. // Challenger Gender
  169. $chart = new Chart;
  170. $chart->setType("pie");
  171. $chart->setTitle("Staff Gender");
  172. $chart->setLabels(["Male", "Female"]);
  173. $chart->addDataset("Counts", [
  174. $total_data->maleChallengerCount,
  175. $total_data->femaleChallengerCount,
  176. ], [
  177. "background_colours" => [
  178. "#2196F3",
  179. "#E91E63",
  180. ]
  181. ]);
  182. $charts[] = $chart;
  183. // Tester Gender
  184. $chart = new Chart;
  185. $chart->setType("pie");
  186. $chart->setTitle("Tester Gender");
  187. $chart->setLabels(["Male", "Female"]);
  188. $chart->addDataset("Counts", [
  189. $total_data->maleTesterCount,
  190. $total_data->femaleTesterCount,
  191. ], [
  192. "background_colours" => [
  193. "#2196F3",
  194. "#E91E63",
  195. ]
  196. ]);
  197. $charts[] = $chart;
  198. // Pass / Fail
  199. $chart = new Chart;
  200. $chart->setType("pie");
  201. $chart->setTitle("Pass / Fail");
  202. $chart->setLabels(["Pass", "Fail"]);
  203. $chart->addDataset("Counts", [
  204. $total_data->passCount,
  205. $total_data->failCount,
  206. ], [
  207. "background_colours" => [
  208. "#4CAF50",
  209. "#F44336",
  210. ]
  211. ]);
  212. $charts[] = $chart;
  213. // Tester Genders by Month
  214. $male_counts = array_values(array_map(function($d) {
  215. return $d->maleTesterCount;
  216. }, $data));
  217. $female_counts = array_values(array_map(function($d) {
  218. return $d->femaleTesterCount;
  219. }, $data));
  220. $chart = new Chart;
  221. $chart->setType("bar");
  222. $chart->setTitle("Tester Gender by Month");
  223. $chart->setLabels($x_data_labels);
  224. $chart->addDataset("Male", $male_counts, [
  225. "background_colours" => "#2196F3"
  226. ]);
  227. $chart->addDataset("Female", $female_counts, [
  228. "background_colours" => "#E91E63"
  229. ]);
  230. $charts[] = $chart;
  231. // Test Count
  232. $test_counts = array_values(array_map(function($d) {
  233. return $d->testCount;
  234. }, $data));
  235. $chart = new Chart;
  236. $chart->setType("bar");
  237. $chart->setTitle("Tests by Month");
  238. $chart->setLabels($x_data_labels);
  239. $chart->addDataset("Tests", $test_counts, [
  240. "background_colours" => "#2196F3"
  241. ]);
  242. $charts[] = $chart;
  243. }
  244. catch(FormException $e) {
  245. $e->generateAlerts();
  246. }
  247. catch(Exception $e) {
  248. Core::addAlert("danger", $e->getMessage());
  249. }
  250. }
  251. View::includeOnce("header", compact("page_title"));
  252. View::include("performance", compact("customer", "date_range", "date_resolution", "all_projects", "project_ids", "charts", "data", "total_data"));
  253. View::includeOnce("footer");
  254. ?>