WebSVN – LeadersLinked - Backend – Diff – /module/LeadersLinked/src/Controller/SurveyReportController.php

                         'name' => $record->name,
                         'form' => $surveyForm->name,
                         'status' => $record->status,
                         'actions' => [
                             'link_report_all' => $this->url()->fromRoute('survey/report/all', ['survey_id' => $record->uuid]),
-                            'link_report_csv' => $this->url()->fromRoute('survey/report/csv', ['survey_id' => $record->uuid]),
+                            'link_report_excel' => $this->url()->fromRoute('survey/report/excel', ['survey_id' => $record->uuid]),
                             'link_overview' => $this->url()->fromRoute('survey/report/overview', ['survey_id' => $record->uuid])
+                        ]
                     ];
             return new JsonModel($data);
+        }
-        if ($request->isGet()) {
-            $hydrator = new ObjectPropertyHydrator();
         if ($request->isGet()) {
             //get form data
             $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);
             $surveyForm = $surveyFormMapper->fetchOne($survey->form_id);
             if ($surveyForm) {
-                return $this->renderPDF($surveyForm, $surveyTests, $survey);
+                return $this->renderPDF($currentCompany, $surveyForm, $surveyTests, $survey);
         return new JsonModel($data);
     }
+    public function renderPDF($company, $surveyForm, $surveyTests, $survey) {
+        $target_path = $this->config['leaderslinked.fullpath.company'] . DIRECTORY_SEPARATOR . $company->uuid;
+        $header = $company->header ? $target_path . DIRECTORY_SEPARATOR . $company->header : '';
+        if(empty($header) || !file_exists($header)) {
+            $header = $this->config['leaderslinked.images_default.company_pdf_header'];
+        }
+        $footer = $company->footer ? $target_path . DIRECTORY_SEPARATOR . $company->footer : '';
+        if(empty($footer) || !file_exists($footer)) {
+            $footer = $this->config['leaderslinked.images_default.company_pdf_footer'];
+        }
+        //Generate New PDF
+        $pdf = new SurveyReport();
+        $pdf->header = $header;
-    public function renderPDF($surveyForm, $surveyTests, $survey) {
+        $pdf->footer = $footer;
-        $target_path = $this->config['leaderslinked.fullpath.company'] . DIRECTORY_SEPARATOR . $survey->uuid;
         $target_path = $this->config[ 'leaderslinked.fullpath.survey'] . DIRECTORY_SEPARATOR . $survey->uuid;
-        if(file_exists($target_path)) {
+        if(!file_exists($target_path)) {
-            Functions::deleteFiles($target_path);
+            mkdir($target_path, 0755, true);
         } else {
-            @mkdir($target_path, 0755, true);
+            Functions::deleteFiles($target_path);
+        }
         // Set Data
-        $headerFormName = utf8_decode($surveyForm->name);
+        $headerFormName = $this->cleanStringToPdf($surveyForm->name);
-        $headerSurveyName = utf8_decode('Informe de Encuesta: ' . trim($survey->name) . ' al ' . date("m-d-Y H:i:s", strtotime($survey->added_on)));
+        $headerSurveyName = $this->cleanStringToPdf('Informe de Encuesta: ' . trim($survey->name) . ' al ' . date("m-d-Y H:i:s", strtotime($survey->added_on)));
+        $sections = json_decode($surveyForm->content, true);
+        $allTests = array_map(
-        $sections = json_decode($surveyForm->content, true);
+            function($response) {
                 return json_decode($response->content, true);
-        $allTests = array_map(
+            },
+                }
+            }
-        }
         //Generate New PDF
         $pdf = new SurveyReport();
         $pdf->AliasNbPages();
         $pdf->AddPage();
+        // Set header secundary
+        $pdf->customHeader($headerFormName, $headerSurveyName);
         // Set header secundary
-        $pdf->customHeader($headerFormName, $headerSurveyName);
+        $countSection = 0;
-        $countSection = 0;
+        for ($i = 0, $max = count($sections);  $i < $max ; $i++) {
             $headerUserName = '';
                         case 'simple':
                             $labels = [];
                             $values = [];
                             foreach($question['options'] as $option) {
+                                $label = $this->cleanStringToPdf($option['text']) . "\n(%.1f%%)";
+                                $value = $averages[$question['slug_question']][$option['slug_option']];
+                                if(empty($value)) {
+                                    continue;
+                                }
-                                $labels []= strip_tags($option['text']) . "\n(%.1f%%)";
+                                array_push($labels, $label);
-                                $values []= $averages[$question['slug_question']][$option['slug_option']];
+                                array_push($values, $value);
+                            }
                             $filename = $target_path . DIRECTORY_SEPARATOR .  $question['slug_question'] . '.png';
-                            $pdf->Cell(0,10,strip_tags(trim(str_replace(' ', ' ', html_entity_decode($question['text'])))),0,1);
+                            $pdf->Cell(0,10, $this->cleanStringToPdf($question['text'], false),0,1);
                             $pdf->pieChart($labels, $values, '', $filename);
                             $pdf->SetFont('Arial', '', 12);
-                            $pdf->Image($filename, 45, $pdf->getY(), 120);
+                            $pdf->Image($filename, 10, $pdf->getY(), 190);
                             $pdf->setY($pdf->getY() + 90);
                             break;
+                        case 'multiple':
+                            $labels = [];
+                            $values = [];
+                            foreach($question['options'] as $option)
+                            {
+                                $label = $this->cleanStringToPdf($option['text']) . "\n(%.1f%%)";
-                        case 'multiple':
+                                $value = $averages[$question['slug_question']][$option['slug_option']];
-                            $labels = [];
+                                if(empty($value)) {
-                            $values = [];
+                                    continue;
+                                }
-                            foreach($question['options'] as $option) {
-                                $labels []= strip_tags($option['text']);
+                                array_push($labels, $label);
-                                $values []= $averages[$question['slug_question']][$option['slug_option']];
+                                array_push($values, $value);
+                            }
                             $filename = $target_path . DIRECTORY_SEPARATOR .  $question['slug_question'] . '.png';
+        }
         return $pdf->Output();
     }
-    public function csvAction() {
+    public function excelAction() {
         $request = $this->getRequest();
         $currentUserPlugin = $this->plugin('currentUserPlugin');
             return new JsonModel($data);
+        }
-        if ($request->isGet()) {
-            $hydrator = new ObjectPropertyHydrator();
         if ($request->isGet()) {
             //get form data
             $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);
             $surveyForm = $surveyFormMapper->fetchOne($survey->form_id);
+            if ($surveyForm) {
+                $filename = $this->excelRender($surveyForm, $surveyTests, $survey);
+                $content = file_get_contents($filename);
+                $response = $this->getResponse();
+                $headers = $response->getHeaders();
+                $headers->clearHeaders();
+                $headers->addHeaderLine('Content-Description: File Transfer');
+                $headers->addHeaderLine('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
+                $headers->addHeaderLine('Content-Disposition: attachment; filename='.$survey->uuid.'.xls');
+                $headers->addHeaderLine('Content-Transfer-Encoding: binary');
+                $headers->addHeaderLine('Expires: 0');
+                $headers->addHeaderLine('Cache-Control: must-revalidate');
+                $headers->addHeaderLine('Pragma: public');
+                $response->setStatusCode(200);
                 $response->setContent($content);
             if ($surveyForm) {
-                return $this->csvRender($surveyForm, $surveyTests, $survey);
+                return $response;
             } else {
                 $data = [
                     'success' => false,
         return new JsonModel($data);
     }
-    public function csvRender($surveyForm, $surveyTests, $survey)
+    public function excelRender($surveyForm, $surveyTests, $survey)
+    {
                 $question = $section['questions'][$j];
                 if (!in_array($question['type'], ['simple', 'multiple'])){
                     continue;
+                }
-                }
+                $row++;
-                $sheet->setCellValueByColumnAndRow(1, $row++, strip_tags($question['text']));
+                $sheet->setCellValue('A' . $row , $this->cleanStringToExcel($question['text']));
                 switch ($question['type']) {
-                    case 'simple':
-                        for($k = 0; $k < count($question['options']); $k++) {
-                            $option = $question['options'][$k];
-                            $sheet->setCellValueByColumnAndRow(1, $row, strip_tags($option['text']));
+                    case 'simple':
+                        for($k = 0; $k < count($question['options']); $k++) {
+                            $row++;
+                            $option = $question['options'][$k];
+                            $sheet->setCellValue('B' . $row , $this->cleanStringToExcel($option['text']));
-                            $sheet->setCellValueByColumnAndRow(2, $row, round($averages[$question['slug_question']][$option['slug_option']], 2) . '%');
+                            $sheet->setCellValue('C' . $row , round($averages[$question['slug_question']][$option['slug_option']], 2) . '%');
                             $row++;
+                        }
-                        break;
-                    case 'multiple':
+                        break;
                         for($k = 0; $k < count($question['options']); $k++) {
+                    case 'multiple':
+                        for($k = 0; $k < count($question['options']); $k++) {
+                            $row++;
                             $option = $question['options'][$k];
-                            $sheet->setCellValueByColumnAndRow(1, $row, strip_tags($option['text']));
+                            $sheet->setCellValue('B' . $row , $this->cleanStringToExcel($option['text']));
-                            $sheet->setCellValueByColumnAndRow(2, $row,$averages[$question['slug_question']][$option['slug_option']]);
+                            $sheet->setCellValue('C' . $row , round($averages[$question['slug_question']][$option['slug_option']]));
                             $row++;
+                        }
+                        break;
-                        break;
+                }
-                }
+            }
-            }
+        }
-        }
         header('Content-Description: File Transfer');
+        $target_path = $this->config[ 'leaderslinked.fullpath.survey'] . DIRECTORY_SEPARATOR . $survey->uuid;
+        if(!file_exists($target_path)) {
+            mkdir($target_path, 0755, true);
+        }
+        $filename = $target_path  . DIRECTORY_SEPARATOR . $survey->uuid . '.xls';
+        $writer = new Xlsx($spreadsheet);
+        $writer->save($filename);
+        return $filename;
+    }
-        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
+    private function cleanStringToPdf($s, $mbConvert = true)
+    {
+        $s = html_entity_decode($s);
-        header('Content-Disposition: attachment; filename=report.xls');
-        header('Content-Transfer-Encoding: binary');
-        header('Expires: 0');
+        if($mbConvert) {
+            $detect = mb_detect_encoding($s);
+            if(strtoupper($detect) != 'UTF8') {
+                $s = mb_convert_encoding($s, 'UTF8', $detect);
+            }
+        } else {
+            $s = utf8_decode($s);
+        }
         header('Cache-Control: must-revalidate');
-        header('Pragma: public');
+        return strip_tags($s);
+    }

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/SurveyReportController.php @ 15150 – Rev 14215 → 15150