current code from svn, revision 62608

4 files changed, 1112 insertions, 0 deletions

diff --git a/app/controllers/consultation/admin.php b/app/controllers/consultation/admin.php
new file mode 100644
index 0000000..5ff0e37
--- /dev/null
+++ b/app/controllers/consultation/admin.php
@@ -0,0 +1,777 @@
+<?php
+require_once __DIR__ . '/consultation_controller.php';
+
+/**
+ * Administration controller for the consultation app.
+ *
+ * @author  Jan-Hendrik Willms <tleilax+studip@gmail.com>
+ * @license GPL2 or any later version
+ * @since   Stud.IP 4.3
+ */
+class Consultation_AdminController extends ConsultationController
+{
+    const SLOT_COUNT_THRESHOLD = 1000;
+
+    public function before_filter(&$action, &$args)
+    {
+        parent::before_filter($action, $args);
+
+        if (!$this->range->isEditableByUser()) {
+            throw new AccessDeniedException();
+        }
+
+        $this->activateNavigation('admin');
+        PageLayout::setTitle(_('Verwaltung der Termine'));
+
+        $this->range_config = $this->range->getConfiguration();
+
+        $this->setupSidebar($action, $this->range_config);
+    }
+
+    private function groupSlots(array $slots)
+    {
+        $blocks = [];
+        foreach ($slots as $slot) {
+            if (!isset($blocks[$slot->block_id])) {
+                $blocks[$slot->block_id] = [
+                    'block' => $slot->block,
+                    'slots' => [],
+                ];
+            }
+            $blocks[$slot->block_id]['slots'][] = $slot;
+        }
+        return $blocks;
+    }
+
+    public function index_action($page = 0)
+    {
+        $this->count = ConsultationSlot::countByRange($this->range);
+        $this->limit = Config::get()->ENTRIES_PER_PAGE;
+
+        if ($page >= ceil($this->count / $this->limit)) {
+            $page = 0;
+        }
+
+        $this->page = max($page, 0);
+
+        if ($GLOBALS['user']->cfg->CONSULTATION_SHOW_GROUPED) {
+            $this->blocks = $this->groupSlots(ConsultationSlot::findByRange(
+                $this->range,
+                "ORDER BY start ASC LIMIT " . ($this->page * $this->limit) . ", {$this->limit}"
+            ));
+        } else {
+            $this->blocks = ConsultationBlock::findByRange(
+                $this->range,
+                'ORDER BY start ASC'
+            );
+            $this->slots = ConsultationSlot::findByRange(
+                $this->range,
+                "ORDER BY start ASC LIMIT " . ($this->page * $this->limit) . ", {$this->limit}"
+            );
+        }
+
+        $action = $GLOBALS['user']->cfg->CONSULTATION_SHOW_GROUPED ? 'index' : 'ungrouped';
+        $this->render_action($action);
+    }
+
+    public function expired_action($page = 0)
+    {
+        $this->count = ConsultationSlot::countByRange($this->range, true);
+        $this->limit = Config::get()->ENTRIES_PER_PAGE;
+
+        if ($page >= ceil($this->count / $this->limit)) {
+            $page = 0;
+        }
+
+        $this->page = max($page, 0);
+
+        if ($GLOBALS['user']->cfg->CONSULTATION_SHOW_GROUPED) {
+            $this->blocks = $this->groupSlots(ConsultationSlot::findByRange(
+                $this->range,
+                "ORDER BY start ASC LIMIT " . ($this->page * $this->limit) . ", {$this->limit}",
+                true
+            ));
+        } else {
+            $this->blocks = ConsultationBlock::findByRange(
+                $this->range,
+                'ORDER BY start ASC',
+                true
+            );
+            $this->slots = ConsultationSlot::findByRange(
+                $this->range,
+                "ORDER BY start ASC LIMIT " . ($this->page * $this->limit) . ", {$this->limit}",
+                true
+            );
+        }
+
+        $action = $GLOBALS['user']->cfg->CONSULTATION_SHOW_GROUPED ? 'index' : 'ungrouped';
+        $this->render_action($action);
+    }
+
+    public function create_action()
+    {
+        PageLayout::setTitle(_('Neue Terminblöcke anlegen'));
+
+        $this->room = '';
+        $this->responsible = false;
+
+        // TODO: inst_default?
+        if ($this->range instanceof User) {
+            $rooms = $this->range->institute_memberships->pluck('Raum');
+            $rooms = array_filter($rooms);
+            $this->room = $rooms ? reset($rooms) : '';
+        } elseif ($this->range instanceof Course) {
+            $this->room = $this->range->ort;
+
+            $block = new ConsultationBlock();
+            $block->range = $this->range;
+            $this->responsible = $block->responsible_persons;
+        } elseif ($this->range instanceof Institute) {
+            $block = new ConsultationBlock();
+            $block->range = $this->range;
+            $this->responsible = $block->responsible_persons;
+        }
+    }
+
+    public function store_action()
+    {
+        CSRFProtection::verifyUnsafeRequest();
+
+        try {
+            $slot_count = ConsultationBlock::countBlocks(
+                $this->getDateAndTime('start'),
+                $this->getDateAndTime('end'),
+                Request::int('day-of-week'),
+                Request::int('interval'),
+                Request::int('duration')
+            );
+            if ($slot_count >= self::SLOT_COUNT_THRESHOLD && !Request::int('confirmed')) {
+                $this->flash['confirm-many'] = $slot_count;
+                throw new Exception('', -1);
+            }
+
+            $blocks = ConsultationBlock::generateBlocks(
+                $this->range,
+                $this->getDateAndTime('start'),
+                $this->getDateAndTime('end'),
+                Request::int('day-of-week'),
+                Request::int('interval')
+            );
+
+            $stored = 0;
+            foreach ($blocks as $block) {
+                $block->room              = Request::get('room');
+                $block->calendar_events   = Request::bool('calender-events', false);
+                $block->show_participants = Request::bool('show-participants', false);
+                $block->require_reason    = Request::option('require-reason');
+                $block->confirmation_text = trim(Request::get('confirmation-text')) ?: null;
+                $block->note              = Request::get('note');
+                $block->size              = Request::int('size', 1);
+                $block->teacher_id        = Request::option('teacher_id') ?: null;
+
+                $block->createSlots(Request::int('duration'));
+                $stored += $block->store();
+            }
+        } catch (OverlapException $e) {
+            $this->keepRequest();
+
+            PageLayout::postError($e->getMessage(), $e->getDetails());
+            $this->redirect('consultation/admin/create');
+            return;
+        } catch (Exception $e) {
+            $this->keepRequest();
+
+            if ($e->getCode() !== -1) {
+                PageLayout::postError($e->getMessage());
+            }
+            $this->redirect('consultation/admin/create');
+            return;
+        }
+
+        if ($stored === 0) {
+            PageLayout::postError(_('In dem von Ihnen gewählten Zeitraum konnten für den gewählten Wochentag keine Termine erzeugt werden.'));
+        } else {
+            PageLayout::postSuccess(_('Die Terminblöcke wurden erfolgreich angelegt.'));
+        }
+        $this->relocate('consultation/admin');
+    }
+
+    public function note_action($block_id, $slot_id = null, $page = 0)
+    {
+        if ($slot_id) {
+            PageLayout::setTitle(_('Anmerkung zu diesem Termin bearbeiten'));
+        } else {
+            PageLayout::setTitle(_('Anmerkung zu diesem Block bearbeiten'));
+        }
+
+        $this->block   = $this->loadBlock($block_id);
+        $this->slot_id = $slot_id;
+        $this->page    = $page;
+
+        if (Request::isPost()) {
+            CSRFProtection::verifyUnsafeRequest();
+
+            $note = trim(Request::get('note'));
+
+            $changed = false;
+            if ($slot_id) {
+                $slot = $this->block->slots->find($slot_id);
+                $slot->note = $note;
+                $changed = $slot->store();
+            } else {
+                $this->block->note = $note;
+                foreach ($this->block->slots as $slot) {
+                    $slot->note = '';
+                }
+                $changed = $this->block->store();
+            }
+            if ($changed) {
+                PageLayout::postSuccess(_('Der Block wurde bearbeitet'));
+            }
+
+            if ($this->block->is_expired) {
+                $this->redirect("consultation/admin/expired/{$page}#block-{$block_id}");
+            } else {
+                $this->redirect("consultation/admin/index/{$page}#block-{$block_id}");
+            }
+        }
+    }
+
+    public function remove_action($block_id, $slot_id = null, $page = 0)
+    {
+        if (!Request::isPost()) {
+            throw new MethodNotAllowedException();
+        }
+
+        $is_expired = false;
+        if (!$slot_id) {
+            $block = $this->loadBlock($block_id);
+            $is_expired = $block->is_expired;
+
+            $invalid = 0;
+            foreach ($block->slots as $slot) {
+                if (!$slot->is_expired && $slot->has_bookings) {
+                    $invalid += 1;
+                } else {
+                    $slot->delete();
+                }
+            }
+
+            if ($invalid > 0) {
+                PageLayout::postError(implode(' ', [
+                    _('Sie können mindestens einen Termin nicht löschen, da er bereits belegt ist.'),
+                    _('Bitte sagen Sie diese Termine erst ab.')
+                ]));
+            } else {
+                $block->delete();
+                PageLayout::postSuccess(_('Die Termine wurden gelöscht'));
+            }
+
+        } else {
+            $this->slot = $this->loadSlot($block_id, $slot_id);
+            $is_expired = $this->slot->is_expired;
+
+            if (!$this->slot->is_expired && $this->slot->has_bookings) {
+                PageLayout::postError(implode(' ', [
+                    _('Sie können diesen Termin nicht löschen, da er bereits belegt ist.'),
+                    _('Bitte sagen Sie den Termin erst ab.')
+                ]));
+            } else {
+                $this->slot->delete();
+                PageLayout::postSuccess(_('Der Termin wurde gelöscht'));
+            }
+        }
+
+        if ($is_expired) {
+            $this->redirect("consultation/admin/expired/{$page}#block-{$block_id}");
+        } else {
+            $this->redirect("consultation/admin/index/{$page}#block-{$block_id}");
+        }
+    }
+
+    public function book_action($block_id, $slot_id, $page = 0)
+    {
+        PageLayout::setTitle(_('Termin reservieren'));
+
+        $this->slot = $this->loadSlot($block_id, $slot_id);
+        $this->page = $page;
+
+        $permissions = ['user', 'autor', 'tutor'];
+        if (Config::get()->CONSULTATION_ALLOW_DOCENTS_RESERVING) {
+            $permissions[] = 'dozent';
+        }
+
+        $this->search_object = new PermissionSearch('user', _('Person suchen'), 'user_id', ['permission' => $permissions]);
+        if ($this->range instanceof Course) {
+            $this->search_object = new PermissionSearch('user_in_sem', _('Person suchen'), 'user_id', [
+                'seminar_id' => $this->range->getRangeId(),
+                'sem_perm'   => ['user', 'autor'],
+            ]);
+
+        }
+
+        if (Request::isPost()) {
+            CSRFProtection::verifyUnsafeRequest();
+
+            if ($this->slot->isOccupied()) {
+                PageLayout::postError(_('Dieser Termin ist bereits belegt.'));
+            } else {
+                $booking = new ConsultationBooking();
+                $booking->slot_id = $this->slot->id;
+                $booking->user_id = Request::option('user_id');
+                $booking->reason  = trim(Request::get('reason'));
+                $booking->store();
+
+                PageLayout::postSuccess(_('Der Termin wurde reserviert.'));
+            }
+
+            $this->redirect("consultation/admin/index/{$page}#slot-{$this->slot->id}");
+        }
+    }
+
+    public function edit_room_action($block_id, $page = 0)
+    {
+        PageLayout::setTitle(_('Ort des Blocks bearbeiten'));
+
+        $this->block = $this->loadBlock($block_id);
+        $this->page  = $page;
+    }
+
+    public function store_room_action($block_id, $page = 0)
+    {
+        CSRFProtection::verifyUnsafeRequest();
+
+        $this->block = $this->loadBlock($block_id);
+        $this->block->room = Request::get('room');
+        $this->block->store();
+
+        PageLayout::postSuccess(_('Der Block wurde gespeichert.'));
+
+        if ($this->block->is_expired) {
+            $this->redirect("consultation/admin/expired/{$page}#block-{$block_id}");
+        } else {
+            $this->redirect("consultation/admin/index/{$page}#block-{$block_id}");
+        }
+    }
+
+    public function cancel_block_action($block_id, $page = 0)
+    {
+        PageLayout::setTitle(_('Termine absagen'));
+
+        $this->block = $this->loadBlock($block_id);
+        $this->page  = $page;
+
+        if (Request::isPost()) {
+            CSRFProtection::verifyUnsafeRequest();
+
+            $reason = trim(Request::get('reason'));
+            foreach ($this->block->slots as $slot) {
+                foreach ($slot->bookings as $booking) {
+                    $booking->cancel($reason);
+                }
+            }
+
+            PageLayout::postSuccess(_('Die Termine wurden abgesagt.'));
+            $this->redirect("consultation/admin/index/{$page}#block-{$block_id}");
+        }
+    }
+
+    public function cancel_slot_action($block_id, $slot_id, $page = 0)
+    {
+        PageLayout::setTitle(_('Termin absagen'));
+
+        $this->slot = $this->loadSlot($block_id, $slot_id);
+        $this->page = $page;
+
+        if (Request::isPost()) {
+            CSRFProtection::verifyUnsafeRequest();
+
+            $ids = false;
+            if (count($this->slot->bookings) > 1) {
+                $ids = Request::intArray('ids');
+            }
+
+            $removed = 0;
+            $reason  = trim(Request::get('reason'));
+            foreach ($this->slot->bookings as $booking) {
+                if ($ids !== false && !in_array($booking->id, $ids)) {
+                    continue;
+                }
+
+                $removed += $booking->cancel($reason);
+            }
+
+            if ($removed === count($this->slot->bookings)) {
+                PageLayout::postSuccess(_('Der Termin wurde abgesagt.'));
+            } elseif ($removed > 1) {
+                PageLayout::postSuccess(sprintf(
+                    _('Der Termin wurde für %u Personen abgesagt.'),
+                    $removed
+                ));
+            } elseif ($removed === 1) {
+                PageLayout::postSuccess(_('Der Termin wurde für eine Person abgesagt.'));
+            }
+            $this->redirect("consultation/admin/index/{$page}#slot-{$this->slot->id}");
+        }
+    }
+
+    public function reason_action($block_id, $slot_id, $booking_id, $page = 0)
+    {
+        PageLayout::setTitle(_('Grund für die Buchung bearbeiten'));
+
+        $this->booking = $this->loadBooking($block_id, $slot_id, $booking_id);
+        $this->page    = $page;
+
+        if (Request::isPost()) {
+            CSRFProtection::tokenTag();
+
+            $this->booking->reason = trim(Request::get('reason'));
+            $this->booking->store();
+
+            PageLayout::postSuccess(_('Der Grund für die Buchung wurde bearbeitet.'));
+
+            if ($this->booking->slot->block->is_expired) {
+                $this->redirect("consultation/admin/expired/{$page}#slot-{$this->booking->slot->id}");
+            } else {
+                $this->redirect("consultation/admin/index/{$page}#slot-{$this->booking->slot->id}");
+            }
+        }
+    }
+
+    public function toggle_action($what, $state, $expired = false)
+    {
+        if ($what === 'messages') {
+            // TODO: Applicable     everywhere?
+            $GLOBALS['user']->cfg->store(
+                'CONSULTATION_SEND_MESSAGES',
+                (bool) $state
+            );
+        } elseif ($what === 'garbage') {
+            // TODO: Not available for course
+            $this->range_config->store(
+                'CONSULTATION_GARBAGE_COLLECT',
+                (bool) $state
+            );
+        } elseif ($what === 'grouped') {
+            $GLOBALS['user']->cfg->store(
+                'CONSULTATION_SHOW_GROUPED',
+                (bool) $state
+            );
+        }
+
+        $this->redirect('consultation/admin/' . ($expired ? 'expired' : 'index'));
+    }
+
+    public function bulk_action($page, $expired = false)
+    {
+        if (!Request::isPost()) {
+            throw new MethodNotAllowedException();
+        }
+
+        $this->slots = $this->getSlotsFromBulk();
+
+        if (count($this->slots) === 0) {
+            PageLayout::postInfo(_('Sie haben keine Termine gewählt.'));
+        } elseif (Request::submitted('delete')) {
+            $has_bookings = $this->slots->any(function ($slot) {
+                return !$slot->is_expired
+                    && $slot->has_bookings;
+            });
+
+            if (!$has_bookings) {
+                $deleted = 0;
+                foreach ($this->slots as $slot) {
+                    $deleted += $slot->delete();
+                }
+                PageLayout::postSuccess(_('Die Termine wurden gelöscht'));
+            } elseif (Request::option('delete') === 'skip') {
+                $deleted = 0;
+                foreach ($this->slots as $slot) {
+                    if ($slot->is_expired || !$slot->has_bookings) {
+                        $deleted += $slot->delete();
+                    }
+                }
+
+                if ($deleted === 1) {
+                    PageLayout::postSuccess(_('Der freie Termin wurde gelöscht'));
+                } elseif ($deleted > 0) {
+                    PageLayout::postSuccess(_('Die freien Termine wurden gelöscht'));
+                }
+            } elseif (Request::option('delete') === 'cancel' && Request::submitted('reason')) {
+                $reason = trim(Request::get('reason'));
+
+                $deleted = 0;
+                foreach ($this->slots as $slot) {
+                    if (!$slot->is_expired && $slot->has_bookings) {
+                        foreach ($slot->bookings as $booking) {
+                            $booking->cancel($reason);
+                        }
+                    }
+                    $deleted += $slot->delete();
+                }
+
+                PageLayout::postSuccess(_('Die Termine wurden gelöscht'));
+            } else {
+                PageLayout::setTitle(_('Termine löschen'));
+                $this->action = $this->bulk($page, $expired);
+                $this->allow_delete = true;
+                $this->mixed = $this->slots->any(function ($slot) {
+                    return !$slot->has_bookings;
+                });
+                $this->render_action('cancel_slots');
+                return;
+            }
+        } elseif (Request::submitted('cancel')) {
+            if (!Request::submitted('reason')) {
+                PageLayout::setTitle(_('Termine absagen'));
+                $this->action = $this->bulk($page, $expired);
+                $this->render_action('cancel_slots');
+                return;
+            } else {
+                $reason = trim(Request::get('reason'));
+
+                $canceled = 0;
+                foreach ($this->slots as $slot) {
+                    foreach ($slot->bookings as $booking) {
+                        $canceled += $booking->cancel($reason);
+                    }
+                }
+
+                if ($canceled === 1) {
+                    PageLayout::postSuccess(_('Der Termin wurde abgesagt.'));
+                } elseif ($canceled > 0) {
+                    PageLayout::postSuccess(_('Die Termine wurden abgesagt.'));
+                }
+            }
+        }
+
+        if ($expired) {
+            $this->relocate("consultation/admin/expired/{$page}");
+        } else {
+            $this->relocate("consultation/admin/index/{$page}");
+        }
+    }
+
+    public function purge_action()
+    {
+        CSRFProtection::verifyUnsafeRequest();
+
+        $deleted = ['current' => 0, 'expired' => 0];
+
+        ConsultationSlot::findEachBySQL(
+            function ($slot) use (&$deleted) {
+                $index = $slot->is_expired ? 'expired' : 'current';
+
+                $slot->removeEvent();
+                $deleted[$index] += $slot->delete();
+            },
+            "JOIN consultation_blocks USING (block_id) WHERE range_id = ? AND range_type = ?",
+            [$this->range->getRangeId(), $this->range->getRangeType()]
+        );
+
+        if (array_sum($deleted) > 0) {
+            $message = [];
+            if ($deleted['current'] > 0) {
+                PageLayout::postSuccess(sprintf(
+                    _('%u aktuelle Termine wurden gelöscht'),
+                    $deleted['current']
+                ));
+            }
+            if ($deleted['expired'] > 0) {
+                PageLayout::postSuccess(sprintf(
+                    _('%u vergangene Termine wurden gelöscht'),
+                    $deleted['expired']
+                ));
+            }
+        }
+
+        $this->redirect('consultation/admin/index');
+    }
+
+    public function mail_action($block_id, $slot_id = null)
+    {
+        // Get matching slots
+        if ($block_id === 'bulk') {
+            $slots = $this->getSlotsFromBulk();
+        } else {
+            $block = $this->loadBlock($block_id);
+
+            foreach ($block->slots as $slot) {
+                if ($slot_id && $slot->id != $slot_id) {
+                    continue;
+                }
+
+                $slots[] = $slot;
+            }
+        }
+
+        // Get user names and timestamps
+        $p_rec = [];
+        $timestamps = [];
+        if(!empty($slots)) {
+            foreach ($slots as $slot) {
+                if (count($slot->bookings) === 0) {
+                    continue;
+                }
+
+                $timestamps[] = $slot->start_time;
+                foreach ($slot->bookings as $booking) {
+                    $p_rec[] = $booking->user->username;
+                }
+            }
+        }
+
+        // Get unique usernames
+        $p_rec = array_unique($p_rec);
+
+        // Get correct default subject
+        $default_subject = _('Termin');
+        if (count($timestamps) === 1) {
+            $default_subject = sprintf(
+                _('Termin am %s um %s'),
+                strftime('%x', $timestamps[0]),
+                strftime('%R', $timestamps[0])
+            );
+        } else {
+            $days = array_unique(array_map(function ($timestamp) {
+                return strftime('%x', $timestamp);
+            }, $timestamps));
+            if (count($days) === 1) {
+                $default_subject = sprintf(
+                    _('Termin am %s'),
+                    $days[0]
+                );
+            }
+        }
+
+        // Redirect to message write
+        $_SESSION['sms_data'] = compact('p_rec');
+        page_close();
+        $this->redirect(URLHelper::getURL(
+            'dispatch.php/messages/write',
+            compact('default_subject')
+        ));
+    }
+
+    public function tab_action($from_expired)
+    {
+        if (Request::isPost()) {
+            $this->range_config->store('CONSULTATION_TAB_TITLE', Request::i18n('tab_title'));
+
+            PageLayout::postSuccess(_('Der Name wurde gespeichert'));
+            if ($from_expired) {
+                $this->redirect('consultation/admin/expired');
+            } else {
+                $this->redirect('consultation/admin/index');
+            }
+            return;
+        }
+
+        $this->current_title = $this->range_config->getValue('CONSULTATION_TAB_TITLE');
+        $this->from_expired  = $from_expired;
+    }
+
+    private function getSlotsFromBulk()
+    {
+        $slots = [];
+
+        $block_ids = Request::intArray('block-id');
+        $slot_ids  = Request::getArray('slot-id');
+
+        foreach ($this->loadBlock($block_ids) as $block) {
+            foreach ($block->slots as $slot) {
+                $slots[$slot->id] = $slot;
+            }
+        }
+
+        foreach ($slot_ids as $slot_id) {
+            list($block_id, $slot_id) = explode('-', $slot_id);
+            try {
+                if ($slot = $this->loadSlot($block_id, $slot_id)) {
+                    $slots[$slot->id] = $slot;
+                }
+            } catch (Exception $e) {
+            }
+        }
+
+        return SimpleCollection::createFromArray($slots);
+    }
+
+    private function setupSidebar($action, $config)
+    {
+        $sidebar = Sidebar::get();
+
+        $views = $sidebar->addWidget(new ViewsWidget());
+        $views->addLink(
+            _('Aktuelle Termine'),
+            $this->indexURL()
+        )->setActive($action !== 'expired');
+        $views->addLink(
+            _('Vergangene Termine'),
+            $this->expiredURL()
+        )->setActive($action === 'expired');
+
+        $actions = $sidebar->addWidget(new ActionsWidget());
+        $actions->addLink(
+            _('Terminblöcke anlegen'),
+            $this->createURL(),
+            Icon::create('add')
+        )->asDialog('size=auto');
+        $actions->addLink(
+            _('Namen des Reiters ändern'),
+            $this->tabURL($action === 'expired'),
+            Icon::create('edit')
+        )->asDialog('size=auto');
+
+        $actions->addLink(
+            _('Alle Termine löschen'),
+            $this->purgeURL(),
+            Icon::create('trash'),
+            ['onclick' => 'return STUDIP.Dialog.confirmAsPost(' . json_encode(_('Wollen Sie wirklich alle Termine löschen?')) . ', this.href);']
+        );
+
+        $options = $sidebar->addWidget(new OptionsWidget());
+        $options->addCheckbox(
+            _('Benachrichtungen über Buchungen'),
+            $GLOBALS['user']->cfg->CONSULTATION_SEND_MESSAGES,
+            $this->toggleURL('messages/1', $action === 'expired'),
+            $this->toggleURL('messages/0', $action === 'expired')
+        );
+        $options->addCheckbox(
+            _('Abgelaufene Terminblöcke automatisch löschen'),
+            $config->CONSULTATION_GARBAGE_COLLECT,
+            $this->toggleURL('garbage/1', $action === 'expired'),
+            $this->toggleURL('garbage/0', $action === 'expired')
+        );
+        $options->addCheckbox(
+            _('Termine gruppiert anzeigen'),
+            $GLOBALS['user']->cfg->CONSULTATION_SHOW_GROUPED,
+            $this->toggleURL('grouped/1', $action === 'expired'),
+            $this->toggleURL('grouped/0', $action === 'expired')
+        );
+
+        $export = $sidebar->addWidget(new ExportWidget());
+        $export->addLink(
+            _('Anmeldungen exportieren'),
+            $this->url_for('consultation/export/bookings'),
+            Icon::create('file-excel+export')
+        );
+        $export->addLink(
+            _('Alle Termine exportieren'),
+            $this->url_for('consultation/export/all'),
+            Icon::create('file-excel+export')
+        );
+    }
+
+    private function getDateAndTime($index)
+    {
+        if (!Request::submitted("{$index}-date") || !Request::submitted("{$index}-time")) {
+            throw new Exception("Date with index '{$index}' was not submitted properly");
+        }
+
+        return strtotime(implode(' ', [
+            Request::get("{$index}-date"),
+            Request::get("{$index}-time")
+        ]));
+    }
+}
diff --git a/app/controllers/consultation/consultation_controller.php b/app/controllers/consultation/consultation_controller.php
new file mode 100644
index 0000000..5d3f20a
--- /dev/null
+++ b/app/controllers/consultation/consultation_controller.php
@@ -0,0 +1,112 @@
+<?php
+/**
+ * Abstract controller for the consultation app.
+ *
+ * @author  Jan-Hendrik Willms <tleilax+studip@gmail.com>
+ * @license GPL2 or any later version
+ * @since   Stud.IP 4.3
+ */
+abstract class ConsultationController extends AuthenticatedController
+{
+    public function before_filter(&$action, &$args)
+    {
+        parent::before_filter($action, $args);
+
+        $this->range = Context::get() ?: User::findByUsername(Request::username('username', $GLOBALS['user']->username));
+
+        if ($this->range instanceof User) {
+            URLHelper::addLinkParam('username', $this->range->username);
+        } elseif ($this->range instanceof Course || $this->range instanceof Institute) {
+            URLHelper::addLinkParam('cid', $this->range->id);
+        }
+
+        // Restore request if present
+        if (isset($this->flash['request'])) {
+            foreach ($this->flash['request'] as $key => $value) {
+                Request::set($key, $value);
+            }
+        }
+
+        // This defines the function to display a note. Not really a partial,
+        // not a controller method. This has no real place...
+        $this->displayNote = function ($what, $length = 40, $position = 'above') {
+            $what = trim($what);
+            if (!$what) {
+                return '';
+            }
+
+            if (mb_strlen($what)  < $length) {
+                return '<div class="consultation-note consultation-note-' . $position . '">' . formatLinks($what) . '</div>';
+            }
+
+            return sprintf(
+                '<div class="consultation-note consultation-note-%s shortened" data-tooltip=\'%s\'>%s&hellip;</div>',
+                $position,
+                json_encode(['html' => formatLinks($what)]),
+                htmlReady(substr($what, 0, $length))
+            );
+        };
+    }
+
+    protected function activateNavigation($path)
+    {
+        $path = ltrim($path, '/');
+
+        if ($this->range instanceof User) {
+            Navigation::activateItem("/profile/consultation/{$path}");
+        } elseif ($this->range instanceof Course || $this->range instanceof Institute) {
+            Navigation::activateItem("/course/consultation/{$path}");
+        } else {
+            throw new Exception('Not implemented yet');
+        }
+    }
+
+    protected function getConsultationTitle()
+    {
+        return $this->range->getConfiguration()->CONSULTATION_TAB_TITLE;
+    }
+
+    protected function keepRequest()
+    {
+        $this->flash['request'] = Request::getInstance()->getIterator()->getArrayCopy();
+    }
+
+    protected function loadBlock($block_id)
+    {
+        if (is_array($block_id)) {
+            return array_map([$this, 'loadBlock'], $block_id);
+        }
+
+        $block = ConsultationBlock::find($block_id);
+
+        if (!$block->range->isAccessibleToUser()) {
+            throw new AccessDeniedException();
+        }
+
+        return $block;
+    }
+
+    protected function loadSlot($block_id, $slot_id)
+    {
+        $block = $this->loadBlock($block_id);
+        $slot  = $block->slots->find($slot_id);
+
+        if (!$slot) {
+            throw new Exception(_('Dieser Termin existiert nicht'));
+        }
+
+        return $slot;
+    }
+
+    protected function loadBooking($block_id, $slot_id, $booking_id)
+    {
+        $slot    = $this->loadSlot($block_id, $slot_id);
+        $booking = $slot->bookings->find($booking_id);
+
+        if (!$booking) {
+            throw new Exception(_('Diese Buchung existiert nicht'));
+        }
+
+        return $booking;
+    }
+}
diff --git a/app/controllers/consultation/export.php b/app/controllers/consultation/export.php
new file mode 100644
index 0000000..109f2f2
--- /dev/null
+++ b/app/controllers/consultation/export.php
@@ -0,0 +1,97 @@
+<?php
+require_once __DIR__ . '/consultation_controller.php';
+
+/**
+ * Export controller for the consultation app.
+ *
+ * @author  Jan-Hendrik Willms <tleilax+studip@gmail.com>
+ * @license GPL2 or any later version
+ * @since   Stud.IP 4.3
+ */
+class Consultation_ExportController extends ConsultationController
+{
+    public function before_filter(&$action, &$args)
+    {
+        parent::before_filter($action, $args);
+
+        if (!$this->range->isEditableByUser()) {
+            throw new AccessDeniedException();
+        }
+    }
+
+    public function bookings_action()
+    {
+        $csv = [];
+        $csv[] = [
+            _('Datum'),
+            _('Beginn'),
+            _('Ende'),
+            _('Person'),
+            _('Ort'),
+            _('Notiz'),
+            _('Grund'),
+        ];
+
+        $blocks = ConsultationBlock::findByRange($this->range, 'ORDER BY start ASC');
+        foreach ($blocks as $block) {
+            foreach ($block->slots as $slot) {
+                foreach ($slot->bookings as $booking) {
+                    $csv[] = [
+                        strftime('%x', $slot->start_time),
+                        date('H:i', $slot->start_time),
+                        date('H:i', $slot->end_time),
+                        $booking->user->getFullName(),
+                        $slot->block->room,
+                        $slot->note ?: $slot->block->note,
+                        $booking->reason
+                    ];
+                }
+            }
+        }
+
+        $this->render_csv($csv, 'Terminvergabe-Anmeldungen-' . date('Ymd') . '.csv');
+    }
+
+    public function all_action()
+    {
+        $csv = [];
+        $csv[] = [
+            _('Datum'),
+            _('Beginn'),
+            _('Ende'),
+            _('Person'),
+            _('Ort'),
+            _('Notiz'),
+            _('Grund'),
+        ];
+
+        $blocks = ConsultationBlock::findByRange($this->range, 'ORDER BY start ASC');
+        foreach ($blocks as $block) {
+            foreach ($block->slots as $slot) {
+                $csv[] = [
+                    strftime('%x', $slot->start_time),
+                    date('H:i', $slot->start_time),
+                    date('H:i', $slot->end_time),
+                    implode("\n", $slot->bookings->map(function ($booking) {
+                        return $booking->user->getFullName();
+                    })),
+                    $slot->block->room,
+                    $slot->note ?: $slot->block->note,
+                    implode("\n", $slot->bookings->map(function ($booking) {
+                        return $booking->reason;
+                    })),
+                ];
+            }
+        }
+
+        $this->render_csv($csv, 'Terminvergabe-' . date('Ymd') . '.csv');
+    }
+
+    public function print_action($block_id)
+    {
+        $this->blocks = $block_id === 'bulk'
+                      ? $this->loadBlock(Request::intArray('ids'))
+                      : [$this->loadBlock($block_id)];
+        $this->set_layout(null);
+    }
+}
diff --git a/app/controllers/consultation/overview.php b/app/controllers/consultation/overview.php
new file mode 100644
index 0000000..8f80d26
--- /dev/null
+++ b/app/controllers/consultation/overview.php
@@ -0,0 +1,126 @@
+<?php
+require_once __DIR__ . '/consultation_controller.php';
+
+/**
+ * Overview/Student controller for the consultation app.
+ *
+ * @author  Jan-Hendrik Willms <tleilax+studip@gmail.com>
+ * @license GPL2 or any later version
+ * @since   Stud.IP 4.3
+ */
+class Consultation_OverviewController extends ConsultationController
+{
+    public function before_filter(&$action, &$args)
+    {
+        parent::before_filter($action, $args);
+
+        PageLayout::setTitle(sprintf(
+            '%s: %s',
+            $this->getConsultationTitle(),
+            $this->range->getFullName()
+        ));
+    }
+
+    public function index_action($page = 0)
+    {
+        $this->activateNavigation('overview');
+        $this->setupSidebar();
+
+        $this->count = ConsultationBlock::countByRange($this->range);
+        $this->limit = Config::get()->ENTRIES_PER_PAGE;
+
+        if ($page >= ceil($this->count / $this->limit)) {
+            $page = 0;
+        }
+
+        $this->page   = max($page, 0);
+        $this->blocks = ConsultationBlock::findbyRange(
+            $this->range,
+            "ORDER BY start ASC LIMIT " . ($this->page * $this->limit) . ", {$this->limit}"
+        );
+
+        $action = $GLOBALS['user']->cfg->CONSULTATION_SHOW_GROUPED ? 'index' : 'ungrouped';
+        $this->render_action($action);
+    }
+
+    public function booked_action($page = 0)
+    {
+        $this->activateNavigation('booked');
+
+        $this->slots = ConsultationSlot::findOccupiedSlotsByUserAndRange(
+            $GLOBALS['user']->id,
+            $this->range
+        );
+    }
+
+    public function book_action($block_id, $slot_id)
+    {
+        $this->slot = $this->loadSlot($block_id, $slot_id);
+
+        if (Request::isPost()) {
+            CSRFProtection::verifyUnsafeRequest();
+
+            if ($this->slot->isOccupied()) {
+                PageLayout::postError(_('Dieser Termin ist bereits belegt.'));
+            } else {
+                $booking = new ConsultationBooking();
+                $booking->slot_id = $this->slot->id;
+                $booking->user_id = $GLOBALS['user']->id;
+                $booking->reason  = trim(Request::get('reason')) ?: null;
+                $booking->store();
+
+                PageLayout::postSuccess(_('Der Termin wurde reserviert.'));
+            }
+
+            $this->redirect("consultation/overview#block-{$block_id}");
+        }
+    }
+
+    public function cancel_action($block_id, $slot_id, $from_booked = false)
+    {
+        $this->slot        = $this->loadSlot($block_id, $slot_id);
+        $this->from_booked = $from_booked;
+
+        if (Request::isPost()) {
+            CSRFProtection::verifyUnsafeRequest();
+
+            if (!$this->slot->isOccupied($GLOBALS['user']->id)) {
+                PageLayout::postError(_('Dieser Termin ist nicht von Ihnen belegt.'));
+            } else {
+                $booking = $this->slot->bookings->findOneBy('user_id', $GLOBALS['user']->id);
+
+                $booking->cancel(Request::get('reason'));
+
+                PageLayout::postSuccess(_('Der Termin wurde abgesagt.'));
+            }
+
+            if ($from_booked) {
+                $this->redirect("consultation/overview/booked#block-{$block_id}");
+            } else {
+                $this->redirect("consultation/overview#block-{$block_id}");
+            }
+        }
+    }
+
+    public function toggle_action($what, $state = null)
+    {
+        if ($what === 'grouped') {
+            $GLOBALS['user']->cfg->store(
+                'CONSULTATION_SHOW_GROUPED',
+                $state === null ? !$GLOBALS['user']->cfg->CONSULTATION_SHOW_GROUPED : (bool) $state
+            );
+        }
+
+        $this->redirect('consultation/overview');
+    }
+
+    private function setupSidebar()
+    {
+        $options = Sidebar::get()->addWidget(new OptionsWidget());
+        $options->addCheckbox(
+            _('Termine gruppiert anzeigen'),
+            $GLOBALS['user']->cfg->CONSULTATION_SHOW_GROUPED,
+            $this->toggleURL('grouped')
+        );
+    }
+}