Revize da67aedb

Grafické úpravy katalogu a filtrování v gridu transliterací

app/AdminModule/component/Transliteration/TransliterationGrid.php

@@ -148 +148 @@
         // ===============
         // Definice filtrů
         // ===============
+        $allFilter = ['' => 'All'];
         $this->addFilterText(TransliterationRepository::COLUMN_BOOK_ID, 'Book')
             ->setCondition(function (Selection $selection, $value) use ($bookRepository)
             {
@@ -157 +158 @@
                 $selection->where(BookRepository::COLUMN_ID, $bookIds);
             });
         $this->addFilterText(TransliterationRepository::COLUMN_CHAPTER, 'Chapter');
-        $this->addFilterText(TransliterationRepository::COLUMN_MUSEUM_ID, 'Museum')
-            ->setCondition(function (Selection $selection, $value) use ($museumRepository)
-            {
-                $museumIds = $museumRepository->getMuseumsLikeName($value)->fetchField(MuseumRepository::COLUMN_ID);
-                $museumIds = $museumIds ? $museumIds : NULL;
-
-                $selection->where(MuseumRepository::COLUMN_ID, $museumIds);
-            });
+        $this->addFilterSelect(TransliterationRepository::COLUMN_MUSEUM_ID, 'Museum', $allFilter + $this->museumRepository->getMuseumNameForSelect());
         $this->addFilterText(TransliterationRepository::COLUMN_MUSEUM_NO, 'Museum No');
-        $this->addFilterSelect(TransliterationRepository::COLUMN_ORIGIN_ID, 'Origin', $this->getOriginFilterArray());
-        $this->addFilterSelect(TransliterationRepository::COLUMN_BOOK_TYPE_ID, 'Book Type', $this->getBookTypeFilterArray());
+        $this->addFilterSelect(TransliterationRepository::COLUMN_ORIGIN_ID, 'Origin', $allFilter + $this->getOriginFilterArray());
+        $this->addFilterSelect(TransliterationRepository::COLUMN_BOOK_TYPE_ID, 'Book Type', $allFilter + $this->getBookTypeFilterArray());
         $this->addFilterText(TransliterationRepository::COLUMN_REG_NO, 'Reg No');
         $this->addFilterText(TransliterationRepository::COLUMN_DATE, 'Date');
 

app/model/repository/MuseumRepository.php

@@ -47 +47 @@
      */
     public function getMuseumNameForSelect()
     {
-        return $this->findAll()->order(self::TABLE_NAME)->fetchPairs(self::COLUMN_ID,self::COLUMN_NAME);
+        $selectArray = [];
+        $museums = $this->findAll()->order(self::COLUMN_NAME)->fetchAll();
+
+        foreach ($museums as $museum)
+        {
+            $label = $museum->{self::COLUMN_NAME};
+            if (!empty($museum->{self::COLUMN_PLACE}))
+            {
+                $label .= ' – ' . $museum->{self::COLUMN_PLACE};
+            }
+            $selectArray[$museum->{self::COLUMN_ID}] = $label;
+        }
+
+        return $selectArray;
     }
 }

app/model/repository/OriginRepository.php

@@ -24 +24 @@
      */
     public function getOriginsForSelect()
     {
-        $origins = $this->findAll()->order(self::COLUMN_ORIGIN)->fetchPairs(self::COLUMN_ID, self::COLUMN_ORIGIN);
-        $origins[0] = '- NOT SELECTED -';
-        return $origins;
+        $selectArray = [];
+
+        $origins = $this->findAll()->order(self::COLUMN_ORIGIN)->fetchAll();
+
+        foreach ($origins as $origin)
+        {
+            $label = $origin->{self::COLUMN_ORIGIN};
+            if (!empty($origin->{self::COLUMN_OLD_NAME}))
+            {
+                $label .= ' / ' . $origin->{self::COLUMN_OLD_NAME};
+            }
+            $selectArray[$origin->{self::COLUMN_ID}] = $label;
+        }
+
+        $selectArray[0] = '- NOT SELECTED -';
+        return $selectArray;
     }
 
     /** Vrací místa původu se názvem LIKE % $name %