Revize c6ccd192

Re #7328 opravený offset pro první stránku

app/FrontModule/component/Transliteration/TransliterationSearchResultList.php

@@ -59 +59 @@
         $this->resultRows = $this->transliterationRepository->transliterationsFulltextSearch($this->searchTerms, $this->paginator->getOffset(), $this->paginator->getPageSize());
         $this->paginator->setPageCount($this->totalCount);
 
-        Debugger::barDump($this->paginator->getOffset(), 'offset');
-        Debugger::barDump($this->paginator->getPageSize(), 'limit');
         $this->template->resultRows = $this->resultRows;
         $this->template->paginator = $this->paginator;
         $this->template->render();

app/model/repository/TransliterationRepository.php

@@ -37 +37 @@
      * @param $limit null|int
      * @return \Nette\Database\ResultSet
      */
-    public function transliterationsFulltextSearch(ArrayHash $queryParams, $offset = null, $limit = null)
+    public function transliterationsFulltextSearch(ArrayHash $queryParams,int $offset = null,int $limit = null)
     {
         $where = '';
         $whereArgs = [];
@@ -127 +127 @@
                   LEFT JOIN surface s ON s.id_transliteration = t.id_transliteration
                   LEFT JOIN line l ON l.id_surface = s.id_surface
                   LEFT JOIN book b ON t.id_book = b.id_book
-                  WHERE " . $where;
+                  WHERE " . $where .
+                 " ORDER BY id DESC ";
 
-        if($offset != null && $limit != null)
+        if($offset !== null && $limit !== null)
         {
-            Debugger::barDump('tu');
-            $query .= ' LIMIT ?, ?';
+            $query .= ' LIMIT ?, ? ';
             $whereArgs[] = (int) $offset;
             $whereArgs[] = (int) $limit;
         }
 
-        Debugger::barDump($offset);
-        Debugger::barDump($limit);
-        Debugger::barDump($query);
-
         return $this->context->queryArgs($query, $whereArgs);
     }