reports_presentation.php 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359
  1. <?php /** @noinspection PhpUnhandledExceptionInspection */
  2. /**
  3. * @var string $date_range_label
  4. * @var string[] $key_labels
  5. * @var ?bool $retests
  6. * @var Customer $customer
  7. * @var Template $template
  8. * @var object $template_config
  9. * @var bool $has_logo
  10. * @var string $logo_file_path
  11. * @var array $total_data
  12. * @var array $charts
  13. * @var array $region_data
  14. * @var array $area_manager_data
  15. * @var array $operations_manager_data
  16. * @var array $brand_data
  17. * @var array $gaming_manager_data
  18. * @var array $senior_gaming_manager_data
  19. * @var string $action
  20. */
  21. use Carbon\CarbonImmutable;
  22. use PhpOffice\PhpPresentation\PhpPresentation;
  23. use PhpOffice\PhpPresentation\IOFactory;
  24. use PhpOffice\PhpPresentation\Shape\RichText\Run;
  25. use PhpOffice\PhpPresentation\Style\Alignment;
  26. $charts = array_values($charts);
  27. $presentation = new PhpPresentation(); // 960x720
  28. // Draw title slide
  29. $slide = $presentation->getActiveSlide();
  30. $shape = $slide->createDrawingShape();
  31. $shape->setName(APP_NAME . " logo")
  32. ->setDescription(APP_NAME . " logo")
  33. ->setPath("./public/img/logo.png")
  34. ->setWidth(200)
  35. ->setOffsetX(380)
  36. ->setOffsetY(10);
  37. $retests_title = "All Tests";
  38. if($retests !== null) {
  39. switch($retests) {
  40. case 0: $retests_title = "Excluding Retests"; break;
  41. case 1: $retests_title = "Retests Only"; break;
  42. }
  43. }
  44. $dt_now = CarbonImmutable::now(TIMEZONE);
  45. if($has_logo) {
  46. $shape = $slide->createDrawingShape();
  47. $shape->setName("$customer->name logo")
  48. ->setDescription("$customer->name logo")
  49. ->setPath($logo_file_path)
  50. ->setWidth(720)
  51. ->setOffsetX(120)
  52. ->setOffsetY(180);
  53. $shape = $slide->createRichTextShape()
  54. ->setHeight(60)
  55. ->setWidth(940)
  56. ->setOffsetX(120)
  57. ->setOffsetY(120);
  58. }
  59. else {
  60. // Title
  61. $shape = $slide->createRichTextShape()
  62. ->setHeight(120)
  63. ->setWidth(940)
  64. ->setOffsetX(10)
  65. ->setOffsetY(315);
  66. }
  67. $title_lines = [
  68. $customer->name,
  69. $template->name,
  70. $date_range_label,
  71. $retests_title,
  72. "",
  73. __("Report Generated at %s", $dt_now->format("d/m/Y H:i")),
  74. ];
  75. foreach($title_lines as $title_line) {
  76. $paragraph = $shape->getActiveParagraph();
  77. $paragraph->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
  78. $run = new Run($title_line);
  79. $run->getFont()->setBold(true)->setSize(16);
  80. $paragraph->addText($run);
  81. $paragraph = $shape->createParagraph();
  82. }
  83. $create_summary_slide = static function(array $options) use ($presentation, $charts, $date_range_label, $total_data) {
  84. $title = $options["title"] ?? "Summary";
  85. $array_key = $options["array_key"] ?? null;
  86. $chart_prefix = $options["chart_prefix"] ?? "Totals by";
  87. if($array_key) {
  88. $pass_count = $total_data->$array_key["pass"];
  89. $fail_count = $total_data->$array_key["fail"];
  90. $test_count = $pass_count + $fail_count;
  91. $has_stages = false;
  92. }
  93. else {
  94. $test_count = $total_data->testCount;
  95. $pass_count = $total_data->passCount;
  96. $fail_count = $total_data->failCount;
  97. $has_stages = true;
  98. }
  99. // Create summary slide
  100. $slide = $presentation->createSlide();
  101. // Title
  102. $shape = $slide->createRichTextShape()
  103. ->setHeight(60)->setWidth(900)
  104. ->setOffsetX(30)->setOffsetY(10);
  105. $run = $shape->createTextRun($title);
  106. $run->getFont()->setBold(true)->setSize(24);
  107. // Date range
  108. $shape = $slide->createRichTextShape()
  109. ->setHeight(60)->setWidth(900)
  110. ->setOffsetX(30)->setOffsetY(70);
  111. $run = $shape->createTextRun($date_range_label);
  112. $run->getFont()->setBold(true)->setSize(24);
  113. // Test Count
  114. $count_text = "Test Count: {$test_count}";
  115. // Pass/Fail count
  116. if(isset($pass_count)) {
  117. $pass_percentage = 0;
  118. $fail_percentage = 0;
  119. if($test_count > 0) {
  120. $pass_percentage = number_format(($pass_count * 100) / $test_count, 2);
  121. $fail_percentage = 100 - $pass_percentage;
  122. }
  123. $count_text .= "\nPass Count: {$pass_count} ({$pass_percentage}%)";
  124. $count_text .= "\nFail Count: {$fail_count} ({$fail_percentage}%)";
  125. }
  126. $shape = $slide->createRichTextShape()
  127. ->setHeight(60)->setWidth(900)
  128. ->setOffsetX(30)->setOffsetY(130);
  129. $run = $shape->createTextRun($count_text);
  130. $run->getFont()->setBold(true)->setSize(16);
  131. $y = 220;
  132. if($has_stages) {
  133. // Tests by stage
  134. /** @var Chart $chart */
  135. foreach($charts as $chart) {
  136. if(stripos($chart->getTitle(), "Tests by Stage") === false) {
  137. continue;
  138. }
  139. $chart->addDataTable($slide, 30, $y);
  140. break;
  141. }
  142. $y += 180;
  143. }
  144. // Totals by period
  145. /** @var Chart $chart */
  146. foreach($charts as $chart) {
  147. if(stripos($chart->getTitle(), $chart_prefix) !== false) {
  148. $chart->addDataTable($slide, 30, $y);
  149. break;
  150. }
  151. }
  152. };
  153. $create_summary_slide([
  154. "title" => $template_config->reports->gamingStatsPage->title ?? null,
  155. "chart_prefix" => $template_config->reports->gamingStatsPage->chartPrefix ?? null
  156. ]);
  157. if(isset($template_config->reports->barStatsPage)) {
  158. $create_summary_slide([
  159. "title" => $template_config->reports->barStatsPage->title ?? null,
  160. "array_key" => "barCounts",
  161. "chart_prefix" => $template_config->reports->barStatsPage->chartPrefix ?? null
  162. ]);
  163. }
  164. if(isset($template_config->reports->combinedStatsPage)) {
  165. $create_summary_slide([
  166. "title" => $template_config->reports->combinedStatsPage->title ?? null,
  167. "array_key" => "combinedCounts",
  168. "chart_prefix" => $template_config->reports->combinedStatsPage->chartPrefix ?? null
  169. ]);
  170. }
  171. $names = [];
  172. $charts_b64 = http::value("charts_b64");
  173. foreach($charts_b64 as $index => $b64) {
  174. /** @var Chart $chart */
  175. $chart = $charts[$index] ?? null;
  176. if(!$chart) {
  177. continue;
  178. }
  179. $slide = $presentation->createSlide();
  180. // Write chart
  181. list($ignore, $png_b64) = explode("base64,", $b64);
  182. $name = tempnam("/tmp", "ppt");
  183. $name .= ".png";
  184. $handle = fopen($name, "wb");
  185. fwrite($handle, base64_decode($png_b64));
  186. fclose($handle);
  187. $names[] = $name;
  188. $chart->addChart($slide, $name);
  189. // Write data table
  190. if($chart->print) {
  191. $slide = $presentation->createSlide();
  192. $chart->addDataTable($slide, 30, 30);
  193. }
  194. }
  195. // Region/Area Manager Stats
  196. foreach([0, 1, 2, 3, 4, 5] as $mode) {
  197. switch($mode) {
  198. case 0:
  199. $current_data = $region_data;
  200. $mode_text = $customer->getRegionLabel(1);
  201. break;
  202. case 1:
  203. $current_data = $area_manager_data;
  204. $mode_text = $customer->getAreaManagerLabel(1);
  205. break;
  206. case 2:
  207. $current_data = $operations_manager_data;
  208. $mode_text = $customer->getOperationsManagerLabel(1);
  209. break;
  210. case 3:
  211. $current_data = $brand_data;
  212. $mode_text = $customer->getBrandLabel(1);
  213. break;
  214. case 4:
  215. $current_data = $gaming_manager_data;
  216. $mode_text = $customer->getGamingManagerLabel(1);
  217. break;
  218. case 5:
  219. $current_data = $senior_gaming_manager_data;
  220. $mode_text = $customer->getSeniorGamingManagerLabel(1);
  221. break;
  222. }
  223. foreach($current_data as $data_id => $rows) {
  224. $slide = $presentation->createSlide();
  225. // Title
  226. $shape = $slide->createRichTextShape()
  227. ->setHeight(120)->setWidth(940)
  228. ->setOffsetX(30)->setOffsetY(30);
  229. $run = $shape->createTextRun("$mode_text: $data_id");
  230. $run->getFont()->setSize(36);
  231. // Table
  232. $shape = $slide->createTableShape(5)
  233. ->setWidth(900)
  234. ->setOffsetX(30)
  235. ->setOffsetY(110);
  236. // Create header row
  237. $row = $shape->createRow();
  238. $row->setHeight(20);
  239. foreach(["Period", "Tests", "Passes", "Fails", "Rate"] as $label) {
  240. $cell = $row->nextCell();
  241. $cell->getActiveParagraph()->getAlignment()
  242. ->setMarginBottom(4)
  243. ->setMarginLeft(4)
  244. ->setMarginRight(4)
  245. ->setMarginTop(4);
  246. $cell->createTextRun($label)
  247. ->getFont()->setBold(true);
  248. }
  249. $index = 0;
  250. foreach($rows as $key => $data) {
  251. $rate = ($data->testCount == 0) ? "0.00" : number_format(($data->passCount * 100) / $data->testCount, 2);
  252. $label = $key_labels[$index];
  253. $values = [$data->testCount, $data->passCount, $data->failCount, "$rate%"];
  254. $row = $shape->createRow();
  255. $row->setHeight(20);
  256. $cell = $row->nextCell();
  257. $cell->getActiveParagraph()->getAlignment()
  258. ->setMarginBottom(4)
  259. ->setMarginLeft(4)
  260. ->setMarginRight(4)
  261. ->setMarginTop(4);
  262. $cell->createTextRun($label)
  263. ->getFont()->setBold(true);
  264. foreach($values as $value) {
  265. $cell = $row->nextCell();
  266. $cell->getActiveParagraph()->getAlignment()
  267. ->setHorizontal(Alignment::HORIZONTAL_RIGHT)
  268. ->setMarginBottom(4)
  269. ->setMarginLeft(4)
  270. ->setMarginRight(4)
  271. ->setMarginTop(4);
  272. $cell->createTextRun($value);
  273. }
  274. $index++;
  275. }
  276. }
  277. }
  278. if($action === "export-pptx") {
  279. header("Content-Type: application/vnd.openxmlformats-officedocument.presentationml.presentation");
  280. http::setDownloadHeaders("report.pptx");
  281. $pptx_writer = IOFactory::createWriter($presentation, "PowerPoint2007");
  282. $pptx_writer->save("php://output");
  283. }
  284. if($action === "export-odp") {
  285. header("Content-Type: application/vnd.oasis.opendocument.presentation");
  286. http::setDownloadHeaders("report.odp");
  287. $odp_writer = IOFactory::createWriter($presentation, "ODPresentation");
  288. $odp_writer->save("php://output");
  289. }
  290. foreach($names as $name) {
  291. @unlink($name);
  292. }
  293. exit;