Revize f0d8e0f6

Re #7511 Export vyfiltrovaných textů v gridu

app/AdminModule/component/Transliteration/TransliterationGrid.php

@@ -4 +4 @@
 namespace App\AdminModule\Components;
 
 
+use App\Enum\EFlashMessage;
+use App\Enum\ESurfaceTypes;
 use App\Model\Repository\BookRepository;
 use App\Model\Repository\BookTypeRepository;
+use App\Model\Repository\LineRepository;
 use App\Model\Repository\MuseumRepository;
 use App\Model\Repository\OriginRepository;
 use App\Model\Repository\TransliterationRepository;
@@ -36 +39 @@
      * @var BookTypeRepository
      */
     private $bookTypeRepository;
+    /**
+     * @var LineRepository
+     */
+    private $lineRepository;
+
+    const EXPORT_FILE_PATH = __DIR__ . '/../../../../temp/export/';
+    const EXPORT_FILE_TYPE = '.txt';
 
     public function __construct(TransliterationRepository $transliterationRepository,
                                 BookRepository $bookRepository,
                                 MuseumRepository $museumRepository,
                                 OriginRepository $originRepository,
-                                BookTypeRepository $bookTypeRepository
+                                BookTypeRepository $bookTypeRepository,
+                                LineRepository $lineRepository
     )
     {
         $this->transliterationRepository = $transliterationRepository;
@@ -49 +60 @@
         $this->museumRepository = $museumRepository;
         $this->originRepository = $originRepository;
         $this->bookTypeRepository = $bookTypeRepository;
+        $this->lineRepository = $lineRepository;
 
         parent::__construct(FALSE);
     }
@@ -172 +184 @@
             ->setConfirm('Do you really want to delete transliteration?')
             ->setTitle('Delete')
             ->setClass('btn btn-xs btn-danger ajax');
+
+        $this->addExportCallback(
+            'Export dat',
+            function ($dataSource, $grid)
+            {
+                $this->exportData($dataSource, $grid);
+            },
+            TRUE);
     }
 
     /**
@@ -221 +241 @@
             return "";
         }
     }
+
+    /**
+     * @param $dataSource
+     * @param DataGrid $grid
+     */
+    private function exportData($dataSource, $grid)
+    {
+        $exportData = [];
+        /** @var ActiveRow $activeRow */
+        foreach ($dataSource as $activeRow)
+        {
+            $lines = $this->lineRepository->getAllLinesForTransliteration($activeRow->getPrimary());
+            $chapterLines = [];
+            foreach ($lines as $line)
+            {
+                $chapterLines[$line->object_type][$line->surface_type][] = array('transliteration' => $line->transliteration, 'line_number' => $line->line_number);
+            }
+            $exportData[] = [
+                'bookName' => $activeRow->ref('id_book')->book_abrev,
+                'chapter' => $activeRow->chapter,
+                'transliterationData' => $chapterLines
+            ];
+        }
+
+        $uniqueBooks = array_unique(array_map(function ($i) { return $i['bookName']; }, $exportData));
+
+        $currentDate = new \DateTime();
+        $exportFileName =  'text-export-' .
+            $currentDate->format('Y-m-d-H-i-s') .
+            self::EXPORT_FILE_TYPE;
+        try
+        {
+            if (!file_exists(self::EXPORT_FILE_PATH)) {
+                mkdir(self::EXPORT_FILE_PATH, 0777, true);
+            }
+            $exportFile = fopen(self::EXPORT_FILE_PATH . $exportFileName, 'w');
+            foreach ($uniqueBooks as $book)
+            {
+                $bookData = [];
+                foreach ($exportData as $data)
+                {
+                    if ($data['bookName'] == $book)
+                    {
+                        $bookData[] = $data;
+                    }
+                }
+                fwrite($exportFile, "|" . $book . "\n");
+                foreach ($bookData as $chapterData)
+                {
+                    fwrite($exportFile, "|" . $chapterData['chapter'] . "\n");
+                    foreach ($chapterData['transliterationData'] as $surfaces)
+                    {
+                        foreach ($surfaces as $type => $surface)
+                        {
+                            for ($i = 0; $i < sizeof($surface); $i++)
+                            {
+                                $line =
+                                    $surface[$i][LineRepository::COLUMN_LINE_NUMBER] .
+                                    " " .
+                                    $surface[$i][LineRepository::COLUMN_TRANSLITERATION];
+                                if($i == 0 && $type != ESurfaceTypes::OBVERSE) {
+                                    $line .= " " . ESurfaceTypes::getTypeAbbrevForExport($type);
+                                }
+                                fwrite($exportFile, $line . "\n");
+                            }
+                        }
+                    }
+                }
+                fwrite($exportFile, "\n");
+            }
+
+            fclose($exportFile);
+            header("Content-type: text/plain");
+            header("Content-disposition: attachment; filename = " . $exportFileName);
+            readfile(self::EXPORT_FILE_PATH . $exportFileName);
+            die();
+        }
+        catch (\Exception $e)
+        {
+            $this->presenter->flashMessage('There was an error creating the export file', EFlashMessage::ERROR);
+        }
+
+        $this->presenter->flashMessage('There was an error downloading the export file', EFlashMessage::ERROR);
+    }
 }
 
 interface ITransliterationGridFactory

app/enum/ESurfaceTypes.php

@@ +1 @@
+<?php
+
+namespace App\Enum;
+
+
+class ESurfaceTypes
+{
+    const REVERSE = 'reverse';
+    const UPPER_EDGE = 'upper edge';
+    const LOWER_EDGE = 'lower edge';
+    const LEFT_EDGE = 'left edge';
+    const RIGHT_EDGE = 'right edge';
+    const SEAL_IMPRESSION_1 = 'seal impression 1';
+    const SEAL_IMPRESSION_2 = 'seal impression 2';
+    const SEAL_IMPRESSION_3 = 'seal impression 3';
+    const SEAL_IMPRESSION_4 = 'seal impression 4';
+    const SEAL_IMPRESSION_5 = 'seal impression 5';
+    const SEAL_IMPRESSION_6 = 'seal impression 6';
+    const SEAL_IMPRESSION_7 = 'seal impression 7';
+    const SEAL_IMPRESSION_8 = 'seal impression 8';
+    const OBVERSE = 'obverse';
+
+    public static $exportFileAbbrev = [
+        self::REVERSE => 'rev.',
+        self::UPPER_EDGE => 'u.e.',
+        self::LOWER_EDGE => 'lo.e.',
+        self::LEFT_EDGE => 'le.e.',
+        self::RIGHT_EDGE => 'r.e.',
+        self::SEAL_IMPRESSION_1 => 's.i.1',
+        self::SEAL_IMPRESSION_2 => 's.i.2',
+        self::SEAL_IMPRESSION_3 => 's.i.3',
+        self::SEAL_IMPRESSION_4 => 's.i.4',
+        self::SEAL_IMPRESSION_5 => 's.i.5',
+        self::SEAL_IMPRESSION_6 => 's.i.6',
+        self::SEAL_IMPRESSION_7 => 's.i.7',
+        self::SEAL_IMPRESSION_8 => 's.i.8',
+    ];
+
+    public static function getTypeAbbrevForExport($type)
+    {
+        if($type == self::OBVERSE)
+        {
+            return '';
+        }
+
+        return "&" . self::$exportFileAbbrev[$type] . "$";
+    }
+}