Revize 36c6c78d

refs #6844: Opraveno razeni v SQL query.

backend/app/Model/Zaznam.php

@@ -85 +85 @@
         // pridat grouping a razeni nakonec
         $query = $query
                 ->groupBy('timeFrom', 'timeTo', 'typeVehicleId')
-                ->orderBy('dateFrom','timeFrom', 'typeVehicleId');
+                ->orderBy('dateFrom', 'asc')
+                ->orderBy('timeFrom', 'asc')
+                ->orderBy('typeVehicleId', 'asc');
 
         return $query->get();
     }
@@ -141 +143 @@
             $query = $query->where('zaznam_cas.smer', '=', $direction);
         }
 
+        $query = $query->orderBy('datetimeFrom', 'asc');
+
         return $query->get();
     }