commit 3b2a94cb775e122d31bc308994372445cc02e605
author avm99963 <me@avm99963.com> Wed Sep 30 00:54:27 2020 +0200
committer avm99963 <me@avm99963.com> Wed Sep 30 00:54:27 2020 +0200
tree 714c79d7c8649f379f3f326f32bb87cdb6a783d6
parent 449d43268905bd08f2d3469df3a700e717082465

Ordenar llista de classes per nom i prioritzar les seleccionades

Ara les assignatures de la llista de clases actuals s'ordenen per nom, i
les assignatures afegides a la llista de l'usuari apareixen primer.

Change-Id: Id3a6c2b7088f405843646c4f82bb46f820be3f74

inc/Classes.php

diff --git a/inc/Classes.php b/inc/Classes.php
index b7e05a9..b7fde79 100644
--- a/inc/Classes.php
+++ b/inc/Classes.php
@@ -20,7 +20,8 @@
           (
             u_s.user_id = :user_id OR
             u_s.subject_id IS NULL
-          )': '');
+          )': '').'
+        ORDER BY '.($isSignedIn ? 'u_s.subject_id IS NULL, ' : '').'s.friendly_name ASC';
     $query = $con->prepare($sentence);
     
     if (!$query->execute(($isSignedIn ? ['user_id' => Users::getUserId()] : [])))