reports_presentation.php 5.9 KB

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