Revize b5cbce29

Re #7328 Řazení sousedních řádek podle line_number

app/model/repository/LineRepository.php

@@ -60 +60 @@
             ->select('line_number, transliteration')
             ->where('id_surface = ? AND id_line < ?', $surfaceId, $lineId)
             ->limit($numberOfLines)
-            ->order('id_line DESC')
+            ->order('line_number * 1 DESC')
             ->fetchAll();
         $adjacentLines['linesBefore'] = array_reverse($linesBefore);
 
@@ -68 +68 @@
             ->select('line_number, transliteration')
             ->where('id_surface = ? AND id_line > ?', $surfaceId, $lineId)
             ->limit($numberOfLines)
-            ->order('id_line ASC')
+            ->order('line_number * 1 ASC')
             ->fetchAll();
         $adjacentLines['linesAfter'] = $linesAfter;