diff options
Diffstat (limited to 'app/controllers/questionnaire.php')
| -rw-r--r-- | app/controllers/questionnaire.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/app/controllers/questionnaire.php b/app/controllers/questionnaire.php index b0cbeba..3f1be16 100644 --- a/app/controllers/questionnaire.php +++ b/app/controllers/questionnaire.php @@ -34,7 +34,7 @@ class QuestionnaireController extends AuthenticatedController if (!$GLOBALS['perm']->have_perm('autor')) { throw new AccessDeniedException('Only for logged in users.'); } - $this->questionnaires = Questionnaire::findBySQL("user_id = ? ORDER BY mkdate DESC", [$GLOBALS['user']->id]); + $this->questionnaires = Questionnaire::findBySQL("user_id = ? ORDER BY title ASC", [$GLOBALS['user']->id]); foreach ($this->questionnaires as $questionnaire) { if (!$questionnaire['visible'] && $questionnaire->isRunning()) { $questionnaire->start(); @@ -55,7 +55,7 @@ class QuestionnaireController extends AuthenticatedController Navigation::activateItem("/course/admin/questionnaires"); $this->statusgruppen = Statusgruppen::findByRange_id($this->range_id); $this->questionnaires = Questionnaire::findBySQL( - "INNER JOIN questionnaire_assignments USING (questionnaire_id) WHERE (questionnaire_assignments.range_id = ? AND questionnaire_assignments.range_type = ?) OR (questionnaire_assignments.range_id IN (?) AND questionnaire_assignments.range_type = 'statusgruppe') ORDER BY questionnaires.mkdate DESC", + "INNER JOIN questionnaire_assignments USING (questionnaire_id) WHERE (questionnaire_assignments.range_id = ? AND questionnaire_assignments.range_type = ?) OR (questionnaire_assignments.range_id IN (?) AND questionnaire_assignments.range_type = 'statusgruppe') ORDER BY questionnaires.title ASC", [$this->range_id, $this->range_type, array_map(function ($g) { return $g->getId(); }, $this->statusgruppen)] ); foreach ($this->questionnaires as $questionnaire) { |