| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359 |
- <?php /** @noinspection PhpUnhandledExceptionInspection */
- /**
- * @var string $date_range_label
- * @var string[] $key_labels
- * @var ?bool $retests
- * @var Customer $customer
- * @var Template $template
- * @var object $template_config
- * @var bool $has_logo
- * @var string $logo_file_path
- * @var array $total_data
- * @var array $charts
- * @var array $region_data
- * @var array $area_manager_data
- * @var array $operations_manager_data
- * @var array $brand_data
- * @var array $gaming_manager_data
- * @var array $senior_gaming_manager_data
- * @var string $action
- */
- use Carbon\CarbonImmutable;
- use PhpOffice\PhpPresentation\PhpPresentation;
- use PhpOffice\PhpPresentation\IOFactory;
- use PhpOffice\PhpPresentation\Shape\RichText\Run;
- use PhpOffice\PhpPresentation\Style\Alignment;
- $charts = array_values($charts);
- $presentation = new PhpPresentation(); // 960x720
- // Draw title slide
- $slide = $presentation->getActiveSlide();
- $shape = $slide->createDrawingShape();
- $shape->setName(APP_NAME . " logo")
- ->setDescription(APP_NAME . " logo")
- ->setPath("./public/img/logo.png")
- ->setWidth(200)
- ->setOffsetX(380)
- ->setOffsetY(10);
- $retests_title = "All Tests";
- if($retests !== null) {
- switch($retests) {
- case 0: $retests_title = "Excluding Retests"; break;
- case 1: $retests_title = "Retests Only"; break;
- }
- }
- $dt_now = CarbonImmutable::now(TIMEZONE);
- if($has_logo) {
- $shape = $slide->createDrawingShape();
- $shape->setName("$customer->name logo")
- ->setDescription("$customer->name logo")
- ->setPath($logo_file_path)
- ->setWidth(720)
- ->setOffsetX(120)
- ->setOffsetY(180);
- $shape = $slide->createRichTextShape()
- ->setHeight(60)
- ->setWidth(940)
- ->setOffsetX(120)
- ->setOffsetY(120);
- }
- else {
- // Title
- $shape = $slide->createRichTextShape()
- ->setHeight(120)
- ->setWidth(940)
- ->setOffsetX(10)
- ->setOffsetY(315);
- }
- $title_lines = [
- $customer->name,
- $template->name,
- $date_range_label,
- $retests_title,
- "",
- __("Report Generated at %s", $dt_now->format("d/m/Y H:i")),
- ];
- foreach($title_lines as $title_line) {
- $paragraph = $shape->getActiveParagraph();
- $paragraph->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
- $run = new Run($title_line);
- $run->getFont()->setBold(true)->setSize(16);
- $paragraph->addText($run);
- $paragraph = $shape->createParagraph();
- }
- $create_summary_slide = static function(array $options) use ($presentation, $charts, $date_range_label, $total_data) {
- $title = $options["title"] ?? "Summary";
- $array_key = $options["array_key"] ?? null;
- $chart_prefix = $options["chart_prefix"] ?? "Totals by";
- if($array_key) {
- $pass_count = $total_data->$array_key["pass"];
- $fail_count = $total_data->$array_key["fail"];
- $test_count = $pass_count + $fail_count;
- $has_stages = false;
- }
- else {
- $test_count = $total_data->testCount;
- $pass_count = $total_data->passCount;
- $fail_count = $total_data->failCount;
- $has_stages = true;
- }
- // Create summary slide
- $slide = $presentation->createSlide();
- // Title
- $shape = $slide->createRichTextShape()
- ->setHeight(60)->setWidth(900)
- ->setOffsetX(30)->setOffsetY(10);
- $run = $shape->createTextRun($title);
- $run->getFont()->setBold(true)->setSize(24);
- // Date range
- $shape = $slide->createRichTextShape()
- ->setHeight(60)->setWidth(900)
- ->setOffsetX(30)->setOffsetY(70);
- $run = $shape->createTextRun($date_range_label);
- $run->getFont()->setBold(true)->setSize(24);
- // Test Count
- $count_text = "Test Count: {$test_count}";
- // Pass/Fail count
- if(isset($pass_count)) {
- $pass_percentage = 0;
- $fail_percentage = 0;
- if($test_count > 0) {
- $pass_percentage = number_format(($pass_count * 100) / $test_count, 2);
- $fail_percentage = 100 - $pass_percentage;
- }
- $count_text .= "\nPass Count: {$pass_count} ({$pass_percentage}%)";
- $count_text .= "\nFail Count: {$fail_count} ({$fail_percentage}%)";
- }
- $shape = $slide->createRichTextShape()
- ->setHeight(60)->setWidth(900)
- ->setOffsetX(30)->setOffsetY(130);
- $run = $shape->createTextRun($count_text);
- $run->getFont()->setBold(true)->setSize(16);
- $y = 220;
- if($has_stages) {
- // Tests by stage
- /** @var Chart $chart */
- foreach($charts as $chart) {
- if(stripos($chart->getTitle(), "Tests by Stage") === false) {
- continue;
- }
- $chart->addDataTable($slide, 30, $y);
- break;
- }
- $y += 180;
- }
- // Totals by period
- /** @var Chart $chart */
- foreach($charts as $chart) {
- if(stripos($chart->getTitle(), $chart_prefix) !== false) {
- $chart->addDataTable($slide, 30, $y);
- break;
- }
- }
- };
- $create_summary_slide([
- "title" => $template_config->reports->gamingStatsPage->title ?? null,
- "chart_prefix" => $template_config->reports->gamingStatsPage->chartPrefix ?? null
- ]);
- if(isset($template_config->reports->barStatsPage)) {
- $create_summary_slide([
- "title" => $template_config->reports->barStatsPage->title ?? null,
- "array_key" => "barCounts",
- "chart_prefix" => $template_config->reports->barStatsPage->chartPrefix ?? null
- ]);
- }
- if(isset($template_config->reports->combinedStatsPage)) {
- $create_summary_slide([
- "title" => $template_config->reports->combinedStatsPage->title ?? null,
- "array_key" => "combinedCounts",
- "chart_prefix" => $template_config->reports->combinedStatsPage->chartPrefix ?? null
- ]);
- }
- $names = [];
- $charts_b64 = http::value("charts_b64");
- foreach($charts_b64 as $index => $b64) {
- /** @var Chart $chart */
- $chart = $charts[$index] ?? null;
- if(!$chart) {
- continue;
- }
- $slide = $presentation->createSlide();
- // Write chart
- list($ignore, $png_b64) = explode("base64,", $b64);
- $name = tempnam("/tmp", "ppt");
- $name .= ".png";
- $handle = fopen($name, "wb");
- fwrite($handle, base64_decode($png_b64));
- fclose($handle);
- $names[] = $name;
- $chart->addChart($slide, $name);
- // Write data table
- if($chart->print) {
- $slide = $presentation->createSlide();
- $chart->addDataTable($slide, 30, 30);
- }
- }
- // Region/Area Manager Stats
- foreach([0, 1, 2, 3, 4, 5] as $mode) {
- switch($mode) {
- case 0:
- $current_data = $region_data;
- $mode_text = $customer->getRegionLabel(1);
- break;
- case 1:
- $current_data = $area_manager_data;
- $mode_text = $customer->getAreaManagerLabel(1);
- break;
- case 2:
- $current_data = $operations_manager_data;
- $mode_text = $customer->getOperationsManagerLabel(1);
- break;
- case 3:
- $current_data = $brand_data;
- $mode_text = $customer->getBrandLabel(1);
- break;
- case 4:
- $current_data = $gaming_manager_data;
- $mode_text = $customer->getGamingManagerLabel(1);
- break;
- case 5:
- $current_data = $senior_gaming_manager_data;
- $mode_text = $customer->getSeniorGamingManagerLabel(1);
- break;
- }
- foreach($current_data as $data_id => $rows) {
- $slide = $presentation->createSlide();
- // Title
- $shape = $slide->createRichTextShape()
- ->setHeight(120)->setWidth(940)
- ->setOffsetX(30)->setOffsetY(30);
- $run = $shape->createTextRun("$mode_text: $data_id");
- $run->getFont()->setSize(36);
- // Table
- $shape = $slide->createTableShape(5)
- ->setWidth(900)
- ->setOffsetX(30)
- ->setOffsetY(110);
- // Create header row
- $row = $shape->createRow();
- $row->setHeight(20);
- foreach(["Period", "Tests", "Passes", "Fails", "Rate"] as $label) {
- $cell = $row->nextCell();
- $cell->getActiveParagraph()->getAlignment()
- ->setMarginBottom(4)
- ->setMarginLeft(4)
- ->setMarginRight(4)
- ->setMarginTop(4);
- $cell->createTextRun($label)
- ->getFont()->setBold(true);
- }
- $index = 0;
- foreach($rows as $key => $data) {
- $rate = ($data->testCount == 0) ? "0.00" : number_format(($data->passCount * 100) / $data->testCount, 2);
- $label = $key_labels[$index];
- $values = [$data->testCount, $data->passCount, $data->failCount, "$rate%"];
- $row = $shape->createRow();
- $row->setHeight(20);
- $cell = $row->nextCell();
- $cell->getActiveParagraph()->getAlignment()
- ->setMarginBottom(4)
- ->setMarginLeft(4)
- ->setMarginRight(4)
- ->setMarginTop(4);
- $cell->createTextRun($label)
- ->getFont()->setBold(true);
- foreach($values as $value) {
- $cell = $row->nextCell();
- $cell->getActiveParagraph()->getAlignment()
- ->setHorizontal(Alignment::HORIZONTAL_RIGHT)
- ->setMarginBottom(4)
- ->setMarginLeft(4)
- ->setMarginRight(4)
- ->setMarginTop(4);
- $cell->createTextRun($value);
- }
- $index++;
- }
- }
- }
- if($action === "export-pptx") {
- header("Content-Type: application/vnd.openxmlformats-officedocument.presentationml.presentation");
- http::setDownloadHeaders("report.pptx");
- $pptx_writer = IOFactory::createWriter($presentation, "PowerPoint2007");
- $pptx_writer->save("php://output");
- }
- if($action === "export-odp") {
- header("Content-Type: application/vnd.oasis.opendocument.presentation");
- http::setDownloadHeaders("report.odp");
- $odp_writer = IOFactory::createWriter($presentation, "ODPresentation");
- $odp_writer->save("php://output");
- }
- foreach($names as $name) {
- @unlink($name);
- }
- exit;
|