reports_presentation.php 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
  1. <?php /** @noinspection PhpUnhandledExceptionInspection */
  2. /** @noinspection PhpUndefinedMethodInspection */
  3. /**
  4. * @var string $date_range_label
  5. * @var string[] $key_labels
  6. */
  7. use PhpOffice\PhpPresentation\PhpPresentation;
  8. use PhpOffice\PhpPresentation\IOFactory;
  9. use PhpOffice\PhpPresentation\Style\Alignment;
  10. $presentation = new PhpPresentation(); // 960x720
  11. // Draw title slide
  12. $slide = $presentation->getActiveSlide();
  13. $shape = $slide->createDrawingShape();
  14. $shape->setName(APP_NAME . " logo")
  15. ->setDescription(APP_NAME . " logo")
  16. ->setPath("./public/img/logo.png")
  17. ->setWidth(200)
  18. ->setOffsetX(380)
  19. ->setOffsetY(10);
  20. $retests_title = "All Tests";
  21. if($retests !== null) {
  22. switch($retests) {
  23. case 0: $retests_title = "Excluding Retests"; break;
  24. case 1: $retests_title = "Retests Only"; break;
  25. }
  26. }
  27. $title = sprintf("%s %s %s Tests (%s)", $customer->name, $template->name, date("F Y"), $retests_title);
  28. if($has_logo) {
  29. $shape = $slide->createDrawingShape();
  30. $shape->setName("$customer->name logo")
  31. ->setDescription("$customer->name logo")
  32. ->setPath($logo_file_path)
  33. ->setWidth(720)
  34. ->setOffsetX(120)
  35. ->setOffsetY(180);
  36. $shape = $slide->createRichTextShape()
  37. ->setHeight(60)
  38. ->setWidth(940)
  39. ->setOffsetX(120)
  40. ->setOffsetY(120);
  41. $run = $shape->createTextRun($title);
  42. $run->getFont()->setBold(true)->setSize(16);
  43. }
  44. else {
  45. // Title
  46. $shape = $slide->createRichTextShape()
  47. ->setHeight(120)
  48. ->setWidth(940)
  49. ->setOffsetX(10)
  50. ->setOffsetY(315);
  51. $shape->getActiveParagraph()->getAlignment()->setHorizontal( Alignment::HORIZONTAL_CENTER );
  52. $run = $shape->createTextRun($title);
  53. $run->getFont()->setBold(true)
  54. ->setSize(16);
  55. }
  56. // Create summary slide
  57. $slide = $presentation->createSlide();
  58. // Title
  59. $shape = $slide->createRichTextShape()
  60. ->setHeight(60)->setWidth(900)
  61. ->setOffsetX(30)->setOffsetY(10);
  62. $run = $shape->createTextRun("Summary");
  63. $run->getFont()->setBold(true)->setSize(24);
  64. // Date range
  65. $shape = $slide->createRichTextShape()
  66. ->setHeight(60)->setWidth(900)
  67. ->setOffsetX(30)->setOffsetY(70);
  68. $run = $shape->createTextRun($date_range_label);
  69. $run->getFont()->setBold(true)->setSize(24);
  70. // Test Count
  71. $count_text = "Test Count: {$total_data->testCount}";
  72. // Pass/Fail count
  73. if(isset($total_data->passCount)) {
  74. $pass_percentage = 0;
  75. $fail_percentage = 0;
  76. if($total_data->testCount > 0) {
  77. $pass_percentage = number_format(($total_data->passCount * 100) / $total_data->testCount, 2);
  78. $fail_percentage = 100 - $pass_percentage;
  79. }
  80. $count_text .= "\nPass Count: {$total_data->passCount} ({$pass_percentage}%)";
  81. $count_text .= "\nFail Count: {$total_data->failCount} ({$fail_percentage}%)";
  82. }
  83. $shape = $slide->createRichTextShape()
  84. ->setHeight(60)->setWidth(900)
  85. ->setOffsetX(30)->setOffsetY(130);
  86. $run = $shape->createTextRun($count_text);
  87. $run->getFont()->setBold(true)->setSize(16);
  88. // Tests by stage
  89. foreach($charts as $chart) {
  90. if(stripos($chart->getTitle(), "Tests by Stage") === false) continue;
  91. $chart->addDataTable($slide, 30, 260);
  92. }
  93. // Totals by month/quarter
  94. foreach($charts as $chart) {
  95. if(stripos($chart->getTitle(), "Totals by") === false) continue;
  96. $chart->addDataTable($slide, 30, 360);
  97. }
  98. $names = [];
  99. $charts_b64 = http::value("charts_b64");
  100. foreach($charts_b64 as $index => $b64) {
  101. $chart = $charts[$index];
  102. $slide = $presentation->createSlide();
  103. // Write chart
  104. list($ignore, $png_b64) = explode("base64,", $b64);
  105. $name = tempnam("/tmp", "ppt");
  106. $name .= ".png";
  107. $handle = fopen($name, "w");
  108. fwrite($handle, base64_decode($png_b64));
  109. fclose($handle);
  110. $names[] = $name;
  111. $chart->addChart($slide, $name);
  112. // Write data table
  113. if($chart->print) {
  114. $chart->addDataTable($slide);
  115. }
  116. }
  117. // Region/Area Manager Stats
  118. foreach([0, 1] as $mode) {
  119. switch($mode) {
  120. case 0:
  121. $current_data = $region_data;
  122. $mode_text = "Region";
  123. break;
  124. case 1:
  125. $current_data = $area_manager_data;
  126. $mode_text = "Area Manager";
  127. break;
  128. }
  129. foreach($current_data as $data_id => $rows) {
  130. $slide = $presentation->createSlide();
  131. // Title
  132. $shape = $slide->createRichTextShape()
  133. ->setHeight(120)->setWidth(940)
  134. ->setOffsetX(30)->setOffsetY(30);
  135. $run = $shape->createTextRun("$mode_text: $data_id");
  136. $run->getFont()->setSize(36);
  137. // Table
  138. $shape = $slide->createTableShape(5)
  139. ->setWidth(900)
  140. ->setOffsetX(30)
  141. ->setOffsetY(110);
  142. // Create header row
  143. $row = $shape->createRow();
  144. $row->setHeight(20);
  145. foreach(["Period", "Tests", "Passes", "Fails", "Rate"] as $label) {
  146. $cell = $row->nextCell();
  147. $cell->getActiveParagraph()->getAlignment()
  148. ->setMarginBottom(4)
  149. ->setMarginLeft(4)
  150. ->setMarginRight(4)
  151. ->setMarginTop(4);
  152. $cell->createTextRun($label)
  153. ->getFont()->setBold(true);
  154. }
  155. $index = 0;
  156. foreach($rows as $key => $data) {
  157. $rate = ($data->testCount == 0) ? "0.00" : number_format(($data->passCount * 100) / $data->testCount, 2);
  158. $label = $key_labels[$index];
  159. $values = [$data->testCount, $data->passCount, $data->failCount, "$rate%"];
  160. $row = $shape->createRow();
  161. $row->setHeight(20);
  162. $cell = $row->nextCell();
  163. $cell->getActiveParagraph()->getAlignment()
  164. ->setMarginBottom(4)
  165. ->setMarginLeft(4)
  166. ->setMarginRight(4)
  167. ->setMarginTop(4);
  168. $cell->createTextRun($label)
  169. ->getFont()->setBold(true);
  170. foreach($values as $value) {
  171. $cell = $row->nextCell();
  172. $cell->getActiveParagraph()->getAlignment()
  173. ->setHorizontal(Alignment::HORIZONTAL_RIGHT)
  174. ->setMarginBottom(4)
  175. ->setMarginLeft(4)
  176. ->setMarginRight(4)
  177. ->setMarginTop(4);
  178. $cell->createTextRun($value);
  179. }
  180. $index++;
  181. }
  182. }
  183. }
  184. if($action == "export-pptx") {
  185. header("Content-Type: application/vnd.openxmlformats-officedocument.presentationml.presentation");
  186. http::setDownloadHeaders("report.pptx");
  187. $pptx_writer = IOFactory::createWriter($presentation, "PowerPoint2007");
  188. $pptx_writer->save("php://output");
  189. }
  190. if($action == "export-odp") {
  191. header("Content-Type: application/vnd.oasis.opendocument.presentation");
  192. http::setDownloadHeaders("report.odp");
  193. $odp_writer = IOFactory::createWriter($presentation, "ODPresentation");
  194. $odp_writer->save("php://output");
  195. }
  196. foreach($names as $name) {
  197. @unlink($name);
  198. }
  199. exit;