Admidio/admidio

View on GitHub
adm_program/modules/events/events.php

Summary

Maintainability
F
3 days
Test Coverage
<?php
/**
 ***********************************************************************************************
 * Show a list of all events
 *
 * @copyright The Admidio Team
 * @see https://www.admidio.org/
 * @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License v2.0 only
 ***********************************************************************************************
 * Parameters:
 *
 * mode      - actual : (Default) shows actual events and all events in future
 *             old    : shows events in the past
 *             all    : shows all events in past and future
 * start     - Position of query recordset where the visual output should start
 * cat_uuid  - show all events of calendar with this UUID
 * dat_uuid  - UUID of a single event that should be shown
 * show      - all               : (Default) show all events
 *           - maybe_participate : Show only events where the current user participates or could participate
 *           - only_participate  : Show only events where the current user participates
 * date_from - set the minimum date of the events that should be shown
 *             if this parameter is not set than the actual date is set
 * date_to   - set the maximum date of the events that should be shown
 *             if this parameter is not set than this date is set to 31.12.9999
 * view_mode - Content output in 'html' or 'print' view
 * view      - Content output in different views like 'detail', 'list'
 *             (Default: according to preferences)
 *****************************************************************************/
use Admidio\Exception;
use Admidio\UserInterface\Form;

try {
    require_once(__DIR__ . '/../../system/common.php');

    // Initialize and check the parameters
    $getMode = admFuncVariableIsValid($_GET, 'mode', 'string', array('defaultValue' => 'actual', 'validValues' => array('actual', 'old', 'all')));
    $getStart = admFuncVariableIsValid($_GET, 'start', 'int');
    $getCatUuid = admFuncVariableIsValid($_GET, 'cat_uuid', 'uuid');
    $getEventUuid = admFuncVariableIsValid($_GET, 'dat_uuid', 'uuid');
    $getShow = admFuncVariableIsValid($_GET, 'show', 'string', array('defaultValue' => 'all', 'validValues' => array('all', 'maybe_participate', 'only_participate')));
    $getDateFrom = admFuncVariableIsValid($_GET, 'date_from', 'date');
    $getDateTo = admFuncVariableIsValid($_GET, 'date_to', 'date');
    $getViewMode = admFuncVariableIsValid($_GET, 'view_mode', 'string', array('defaultValue' => 'html', 'validValues' => array('html', 'print')));
    $getView = admFuncVariableIsValid($_GET, 'view', 'string', array('defaultValue' => $gSettingsManager->getString('events_view'), 'validValues' => array('detail', 'compact', 'room', 'participants', 'description')));

    // check if module is active
    if ((int)$gSettingsManager->get('events_module_enabled') === 0) {
        throw new Exception('SYS_MODULE_DISABLED');
    } elseif ((int)$gSettingsManager->get('events_module_enabled') === 2) {
        // module only for valid Users
        require(__DIR__ . '/../../system/login_valid.php');
    }

    // create object and get recordset of available events

    $calendar = new TableCategory($gDb);

    if ($getCatUuid !== '') {
        $calendar->readDataByUuid($getCatUuid);
    }

    $events = new ModuleEvents();
    $events->setParameter('mode', $getMode);
    $events->setParameter('cat_id', $calendar->getValue('cat_id'));
    $events->setParameter('dat_uuid', $getEventUuid);
    $events->setParameter('show', $getShow);
    $events->setParameter('view_mode', $getViewMode);
    $events->setDateRange($getDateFrom, $getDateTo);

    // Number of events each page for default view 'html' or 'compact' view
    if ($getViewMode === 'html' && $getView === 'detail') {
        $eventsPerPage = $gSettingsManager->getInt('events_per_page');
    } else {
        $eventsPerPage = $events->getDataSetCount();
    }

    // read relevant events from database
    $eventsResult = $events->getDataSet($getStart, $eventsPerPage);

    if ($getViewMode === 'html') {
        if ($getEventUuid !== '') {
            $gNavigation->addUrl(CURRENT_URL, $events->getHeadline($gL10n->get('SYS_EVENTS')));
        } else {
            // Navigation of the module starts here
            $gNavigation->addStartUrl(CURRENT_URL, $events->getHeadline($gL10n->get('SYS_EVENTS')), 'bi-calendar-week-fill');
        }
    }

    // create html page object
    $page = new HtmlPage('admidio-events', $events->getHeadline($gL10n->get('SYS_EVENTS')));

    if ($getViewMode === 'html') {
        $datatable = true;
        $hoverRows = true;
        $classTable = 'table';

        if ($gSettingsManager->getBool('enable_rss') && (int)$gSettingsManager->get('events_module_enabled') === 1) {
            $page->addRssFile(
                ADMIDIO_URL . FOLDER_MODULES . '/events/events_rss.php?organization_short_name=' . $gCurrentOrganization->getValue('org_shortname'),
                $gL10n->get('SYS_RSS_FEED_FOR_VAR', array($gCurrentOrganization->getValue('org_longname') . ' - ' . $gL10n->get('SYS_EVENTS')))
            );
        }

        $page->addJavascript('
        $("#sel_change_view").change(function() {
            self.location.href = "' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events.php', array('mode' => $getMode, 'date_from' => $events->getParameter('dateStartFormatAdmidio'), 'date_to' => $events->getParameter('dateEndFormatAdmidio'), 'cat_uuid' => $getCatUuid)) . '&view=" + $("#sel_change_view").val();
        });

        $("#menu_item_event_print_view").click(function() {
            window.open("' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events.php', array('view_mode' => 'print', 'view' => $getView, 'mode' => $getMode, 'cat_uuid' => $getCatUuid, 'dat_uuid' => $getEventUuid, 'date_from' => $events->getParameter('dateStartFormatEnglish'), 'date_to' => $events->getParameter('dateEndFormatEnglish'))) . '", "_blank");
        });', true);

        // If default view mode is set to compact we need a back navigation if one date is selected for detail view
        if ($getEventUuid !== '') {
            // add back link to module menu
            $page->addPageFunctionsMenuItem('menu_item_event_print_view', $gL10n->get('SYS_PRINT_PREVIEW'), 'javascript:void(0);', 'bi-printer-fill');
        }

        // Add new event
        if (count($gCurrentUser->getAllEditableCategories('EVT')) > 0 && $getEventUuid === '') {
            $page->addPageFunctionsMenuItem(
                'menu_item_event_add',
                $gL10n->get('SYS_CREATE_EVENT'),
                ADMIDIO_URL . FOLDER_MODULES . '/events/events_new.php',
                'bi-plus-circle-fill'
            );
        }

        if ($getEventUuid === '') {
            // show print button
            $page->addPageFunctionsMenuItem('menu_item_event_print_view', $gL10n->get('SYS_PRINT_PREVIEW'), 'javascript:void(0);', 'bi-printer-fill');

            // iCal Download
            if ($gSettingsManager->getBool('events_ical_export_enabled')) {
                $param = array('mode' => 'export');
                ($getCatUuid !== '' ? $param['cat_uuid'] = $getCatUuid : '');
                ($getDateFrom !== '' ? $param['date_from'] = $getDateFrom : '');
                ($getDateTo !== '' ? $param['date_to'] = $getDateTo : '');

                $page->addPageFunctionsMenuItem(
                    'menu_item_event_ical',
                    $gL10n->get('SYS_DOWNLOAD_ICAL'),
                    SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_function.php', $param),
                    'bi-download'
                );
            }

            if ($gCurrentUser->editEvents()) {
                // if no calendar select box is shown, then show link to edit calendars
                $page->addPageFunctionsMenuItem(
                    'menu_item_event_categories',
                    $gL10n->get('SYS_EDIT_CALENDARS'),
                    SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/categories/categories.php', array('type' => 'EVT')),
                    'bi-hdd-stack-fill'
                );
            }

            // create filter menu with elements for calendar and start/end date
            $form = new Form(
                'navbar_filter_form',
                'sys-template-parts/form.filter.tpl',
                ADMIDIO_URL . FOLDER_MODULES . '/events/events.php',
                $page,
                array('type' => 'navbar', 'setFocus' => false)
            );
            if ($gSettingsManager->getBool('events_rooms_enabled')) {
                $selectBoxEntries = array(
                    'detail' => $gL10n->get('SYS_DETAILED'),
                    'compact' => $gL10n->get('SYS_COMPACT'),
                    'room' => $gL10n->get('SYS_COMPACT') . ' - ' . $gL10n->get('SYS_ROOM'),
                    'participants' => $gL10n->get('SYS_COMPACT') . ' - ' . $gL10n->get('SYS_PARTICIPANTS'),
                    'description' => $gL10n->get('SYS_COMPACT') . ' - ' . $gL10n->get('SYS_DESCRIPTION')
                );
            } else {
                $selectBoxEntries = array(
                    'detail' => $gL10n->get('SYS_DETAILED'),
                    'compact' => $gL10n->get('SYS_COMPACT'),
                    'participants' => $gL10n->get('SYS_COMPACT') . ' - ' . $gL10n->get('SYS_PARTICIPANTS'),
                    'description' => $gL10n->get('SYS_COMPACT') . ' - ' . $gL10n->get('SYS_DESCRIPTION')
                );
            }
            $form->addSelectBox(
                'sel_change_view',
                $gL10n->get('SYS_VIEW'),
                $selectBoxEntries,
                array('defaultValue' => $getView, 'showContextDependentFirstEntry' => false)
            );
            $form->addSelectBoxForCategories(
                'cat_uuid',
                $gL10n->get('SYS_CALENDAR'),
                $gDb,
                'EVT',
                Form::SELECT_BOX_MODUS_FILTER,
                array('defaultValue' => $getCatUuid)
            );
            $form->addInput(
                'date_from',
                $gL10n->get('SYS_START'),
                $events->getParameter('dateStartFormatEnglish'),
                array('type' => 'date', 'maxLength' => 10)
            );
            $form->addInput(
                'date_to',
                $gL10n->get('SYS_END'),
                $events->getParameter('dateEndFormatEnglish'),
                array('type' => 'date', 'maxLength' => 10)
            );
            $form->addInput('view', '', $getView, array('property' => Form::FIELD_HIDDEN));
            $form->addSubmitButton('btn_send', $gL10n->get('SYS_OK'));
            $form->addToHtmlPage();
        }
    } else { // $getViewMode = 'print'
        $datatable = false;
        $hoverRows = false;
        $classTable = 'table table-condensed table-striped';

        // create html page object without the custom theme files
        $page->setPrintMode();

        if ($getEventUuid === '') {
            $page->addHtml('<h3>' . $gL10n->get('SYS_PERIOD_FROM_TO', array($events->getParameter('dateStartFormatAdmidio'), $events->getParameter('dateEndFormatAdmidio'))) . '</h3>');
        }
    }

    if ($eventsResult['totalCount'] === 0) {
        // No events found
        if ($getEventUuid !== '') {
            $page->addHtml('<p>' . $gL10n->get('SYS_NO_ENTRY') . '</p>');
        } else {
            $page->addHtml('<p>' . $gL10n->get('SYS_NO_ENTRIES') . '</p>');
        }
    } else {
        // Output table header for compact view
        if ($getView !== 'detail') { // $getView = 'compact' or 'room' or 'participants' or 'description'
            $compactTable = new HtmlTable('events_compact_table', $page, $hoverRows, $datatable, $classTable);
            $compactTable->setDatatablesRowsPerPage($gSettingsManager->getInt('events_per_page'));

            $columnHeading = array();
            $columnAlign = array();

            switch ($getView) {
                case 'compact':
                    $columnHeading = array('&nbsp;', $gL10n->get('SYS_PERIOD'), $gL10n->get('SYS_EVENT'), $gL10n->get('SYS_PARTICIPANTS'), $gL10n->get('SYS_VENUE'));
                    $columnAlign = array('center', 'left', 'left', 'left', 'left');
                    $compactTable->disableDatatablesColumnsSort(array(6));
                    $compactTable->setDatatablesColumnsNotHideResponsive(array(6));
                    break;
                case 'room':
                    $columnHeading = array('&nbsp;', $gL10n->get('SYS_PERIOD'), $gL10n->get('SYS_EVENT'), $gL10n->get('SYS_ROOM'), $gL10n->get('SYS_LEADERS'), $gL10n->get('SYS_PARTICIPANTS'));
                    $columnAlign = array('center', 'left', 'left', 'left', 'left', 'left');
                    $compactTable->disableDatatablesColumnsSort(array(7));
                    $compactTable->setDatatablesColumnsNotHideResponsive(array(7));
                    break;
                case 'participants':
                    $columnHeading = array('&nbsp;', $gL10n->get('SYS_PERIOD'), $gL10n->get('SYS_EVENT'), $gL10n->get('SYS_PARTICIPANTS'));
                    $columnAlign = array('center', 'left', 'left', 'left');
                    $compactTable->disableDatatablesColumnsSort(array(5));
                    $compactTable->setDatatablesColumnsNotHideResponsive(array(5));
                    $compactTable->setColumnWidth(4, '35%');
                    break;
                case 'description':
                    $columnHeading = array('&nbsp;', $gL10n->get('SYS_PERIOD'), $gL10n->get('SYS_EVENT'), $gL10n->get('SYS_DESCRIPTION'));
                    $columnAlign = array('center', 'left', 'left', 'left');
                    $compactTable->disableDatatablesColumnsSort(array(5));
                    $compactTable->setDatatablesColumnsNotHideResponsive(array(5));
                    $compactTable->setColumnWidth(4, '35%');
                    break;
            }

            if ($getViewMode === 'html') {
                $columnHeading[] = '&nbsp;';
                $columnAlign[] = 'right';
            }

            $compactTable->setColumnAlignByArray($columnAlign);
            $compactTable->addRowHeadingByArray($columnHeading);
        }

        // create dummy date object
        $event = new TableEvent($gDb);

        foreach ($eventsResult['recordset'] as $row) {
            // write of current event data to date object
            $event->clear();
            $event->setArray($row);

            $dateUuid = $event->getValue('dat_uuid');
            $eventRolId = $event->getValue('dat_rol_id');
            $eventRoleUUID = $row['rol_uuid'];
            $dateHeadline = $event->getValue('dat_headline');

            // initialize all output elements
            $attentionDeadline = '';
            $outputEndDate = '';
            $outputButtonICal = '';
            $outputButtonEdit = '';
            $outputButtonDelete = '';
            $outputButtonCopy = '';
            $outputButtonParticipation = '';
            $outputButtonParticipants = '';
            $outputButtonParticipantsEmail = '';
            $outputButtonParticipantsAssign = '';
            $outputLinkLocation = '';
            $outputLinkRoom = '';
            $outputNumberMembers = '';
            $outputNumberLeaders = '';
            $outputDeadline = '';
            $eventElements = array();
            $participantsArray = array();
            $participateModalForm = false;

            // If extended options for participation are allowed then use a modal form instead the dropdown button
            if ((int)$event->getValue('dat_allow_comments') === 1 || (int)$event->getValue('dat_additional_guests') === 1) {
                $participateModalForm = true;
            }

            // set end date of event
            if ($event->getValue('dat_begin', $gSettingsManager->getString('system_date')) !== $event->getValue('dat_end', $gSettingsManager->getString('system_date'))) {
                $outputEndDate = ' - ' . $event->getValue('dat_end', $gSettingsManager->getString('system_date'));
            }

            if ($getViewMode === 'html') {
                // iCal Download
                if ($gSettingsManager->getBool('events_ical_export_enabled')) {
                    $outputButtonICal = '
                    <a href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_function.php', array('dat_uuid' => $dateUuid, 'mode' => 'export')) . '">
                        <i class="bi bi-download" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_DOWNLOAD_ICAL') . '"></i></a>';
                }

                // change and delete is only for users with additional rights
                if ($event->isEditable()) {
                    $outputButtonCopy = '
                    <a href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_new.php', array('dat_uuid' => $dateUuid, 'copy' => 1)) . '">
                        <i class="bi bi-copy" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_COPY') . '"></i></a>';
                    $outputButtonEdit = '
                    <a href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_new.php', array('dat_uuid' => $dateUuid)) . '">
                        <i class="bi bi-pencil-square" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_EDIT') . '"></i></a>';
                    $outputButtonDelete = '
                    <a class="openPopup" href="javascript:void(0);"
                        data-href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . '/adm_program/system/popup_message.php', array('type' => 'dat', 'element_id' => 'dat_' . $dateUuid,
                            'name' => $event->getValue('dat_begin', $gSettingsManager->getString('system_date')) . ' ' . $dateHeadline, 'database_id' => $dateUuid)) . '">
                        <i class="bi bi-trash" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_DELETE') . '"></i></a>';
                }
            }

            $eventLocation = (string)$event->getValue('dat_location', 'database');
            if ($eventLocation !== '') {
                // Show map link, when at least 2 words available
                // having more than 3 characters each
                $countLocationWords = 0;
                foreach (preg_split('/[,; ]/', $eventLocation) as $value) {
                    if (strlen($value) > 3) {
                        ++$countLocationWords;
                    }
                }

                if ($gSettingsManager->getBool('events_show_map_link') && $countLocationWords > 1 && $getViewMode === 'html') {
                    $urlParam = $eventLocation;

                    $eventCountry = $event->getValue('dat_country');
                    if ($eventCountry) {
                        // Better results with additional country information
                        $urlParam .= ', ' . $eventCountry;
                    }
                    $locationUrl = SecurityUtils::encodeUrl('https://www.google.com/maps/search/', array('api' => 1, 'query' => $urlParam));

                    $outputLinkLocation = '
                    <a href="' . $locationUrl . '" target="_blank" title="' . $gL10n->get('SYS_SHOW_MAP') . '">' . $eventLocation . '</a>';

                    // if valid login and enough information about address exist - calculate the route
                    if ($gValidLogin && $gCurrentUser->getValue('STREET') !== ''
                        && ($gCurrentUser->getValue('POSTCODE') !== '' || $gCurrentUser->getValue('CITY') !== '')) {
                        $routeOriginParam = array($gCurrentUser->getValue('STREET'));

                        if ($gCurrentUser->getValue('POSTCODE') !== '') {
                            $routeOriginParam[] = $gCurrentUser->getValue('POSTCODE');
                        }
                        if ($gCurrentUser->getValue('CITY') !== '') {
                            $routeOriginParam[] = $gCurrentUser->getValue('CITY');
                        }
                        if ($gCurrentUser->getValue('COUNTRY') !== '') {
                            $routeOriginParam[] = $gCurrentUser->getValue('COUNTRY');
                        }

                        $routeUrl = SecurityUtils::encodeUrl('https://www.google.com/maps/dir/', array('api' => 1, 'origin' => implode(', ', $routeOriginParam), 'destination' => $urlParam));

                        $outputLinkLocation .= '
                        <a class="admidio-icon-link" href="' . $routeUrl . '" target="_blank">
                            <i class="bi bi-sign-turn-right-fill" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_SHOW_ROUTE') . '"></i>
                        </a>';
                    }
                } else {
                    $outputLinkLocation = $eventLocation;
                }
            }

            // if active, then show room information
            $eventRoomId = $event->getValue('dat_room_id');
            if ($eventRoomId > 0) {
                $room = new TableRooms($gDb, $eventRoomId);

                if ($getViewMode === 'html') {
                    $roomLink = SecurityUtils::encodeUrl(ADMIDIO_URL . '/adm_program/system/msg_window.php', array('message_id' => 'room_detail', 'message_title' => 'SYS_ROOM_INFORMATION', 'message_var1' => $eventRoomId, 'inline' => 'true'));
                    $outputLinkRoom = '<a class="openPopup" href="javascript:void(0);" data-href="' . $roomLink . '">' . $room->getValue('room_name') . '</a>';
                } else { // $getViewMode = 'print'
                    $outputLinkRoom = $room->getValue('room_name');
                }
            }

            if ($eventRolId > 0) {
                $participants = new Participants($gDb, $eventRolId);

                // check the rights if the user is allowed to view the participants, or he is allowed to participate
                if ($gCurrentUser->hasRightViewRole((int)$event->getValue('dat_rol_id'))
                    || $row['mem_leader'] == 1
                    || $gCurrentUser->editEvents()
                    || $event->allowedToParticipate()) {
                    $outputNumberMembers = $participants->getCount();
                    $outputNumberLeaders = $participants->getNumLeaders();
                    $participantsArray = $participants->getParticipantsArray();
                }

                // If user is invited to the event then the approval state is not initialized and has value "null" in data table
                if ($row['member_date_role'] > 0 && $row['member_approval_state'] == null) {
                    $row['member_approval_state'] = ModuleEvents::MEMBER_APPROVAL_STATE_INVITED;
                }

                // set status of participation
                switch ($row['member_approval_state']) {
                    case ModuleEvents::MEMBER_APPROVAL_STATE_INVITED:
                        $buttonText = $gL10n->get('SYS_PARTICIPATE_QUESTION');
                        $buttonClass = '';
                        $iconParticipationStatus = '<i class="bi bi-person-plus-fill"></i>';
                        break;
                    case ModuleEvents::MEMBER_APPROVAL_STATE_ATTEND:
                        $buttonText = $gL10n->get('SYS_EVENT_PARTICIPATION_ATTEND');
                        $buttonClass = 'admidio-event-approval-state-attend';
                        $iconParticipationStatus = '<i class="bi bi-check-circle-fill"></i>';
                        break;
                    case ModuleEvents::MEMBER_APPROVAL_STATE_TENTATIVE:
                        $buttonText = $gL10n->get('SYS_EVENT_PARTICIPATION_TENTATIVE');
                        $buttonClass = 'admidio-event-approval-state-tentative';
                        $iconParticipationStatus = '<i class="bi bi-question-circle-fill"></i>';
                        break;
                    case ModuleEvents::MEMBER_APPROVAL_STATE_REFUSED:
                        $buttonText = $gL10n->get('SYS_EVENT_PARTICIPATION_CANCELED');
                        $buttonClass = 'admidio-event-approval-state-cancel';
                        $iconParticipationStatus = '<i class="bi bi-x-circle-fill"></i>';
                        break;
                    default:
                        $buttonText = $gL10n->get('SYS_PARTICIPATE');
                        $buttonClass = '';
                        $iconParticipationStatus = '<i class="bi bi-pencil-square"></i>';
                }

                if ($getView !== 'detail') {
                    // Status text only in detail view
                    $buttonText = '';
                }

                // show notice that no new participation could be assigned to the event because the deadline exceeded or
                // the max number of participants is reached.
                if ($event->deadlineExceeded() || $event->participantLimitReached()) {
                    // Show warning for member of the date role if deadline is exceeded and now no changes are possible anymore
                    if ($participants->isMemberOfEvent($gCurrentUserId)) {
                        if ($getView !== 'detail') {
                            $outputButtonParticipation = '<span class="' . $buttonClass . '">' . $iconParticipationStatus . '</span>';
                        }
                        $attentionDeadline = '
                            <div class="alert alert-info" role="alert">
                                <span class="' . $buttonClass . '">' . $iconParticipationStatus . ' ' . $buttonText . '</span>
                                <i class="bi bi-info-circle-fill admidio-info-icon" data-bs-toggle="popover"
                                    data-bs-html="true" data-bs-trigger="hover click" data-bs-placement="auto"
                                    title="' . $gL10n->get('SYS_NOTE') . '" data-bs-content="' . SecurityUtils::encodeHTML($gL10n->get('SYS_DEADLINE_ATTENTION')) . '"></i>
                            </div>';
                    } elseif ($event->allowedToParticipate()) {
                        $attentionDeadline = '<div class="alert alert-info" role="alert">' . $gL10n->get('SYS_REGISTRATION_NOT_POSSIBLE') . '</div>';
                        $iconParticipationStatus = '';
                    }
                }

                // if current user is allowed to participate or user could edit this event then show buttons for participation
                if ($event->possibleToParticipate() || $gCurrentUser->editEvents() || $participants->isLeader($gCurrentUserId)) {
                    if ($event->getValue('dat_deadline') !== null) {
                        $outputDeadline = $event->getValue('dat_deadline', $gSettingsManager->getString('system_date') . ' ' . $gSettingsManager->getString('system_time'));
                    }

                    // Links for the participation only in html mode
                    if ($getViewMode === 'html') {
                        if ($event->possibleToParticipate()) {


                            $disableStatusAttend = '';
                            $disableStatusTentative = '';

                            // Check limit of participants
                            if ($event->participantLimitReached()) {
                                // Check current user. If user is member of the event role then get his current approval status and set the options
                                if (array_key_exists($gCurrentUserId, $participantsArray)) {
                                    switch ($participantsArray[$gCurrentUserId]['approved']) {
                                        case Participants::PARTICIPATION_MAYBE:
                                            $disableStatusTentative = 'disabled';
                                            break;
                                        case Participants::PARTICIPATION_YES:
                                            $disableStatusAttend = 'disabled';
                                            break;
                                        case Participants::PARTICIPATION_NO:
                                            $disableStatusAttend = 'disabled';
                                            $disableStatusTentative = 'disabled';
                                            break;
                                    }
                                }
                            }

                            if ($participateModalForm === false) {
                                $outputButtonParticipation = '
                            <div class="btn-group" role="group">
                                <button class="btn btn-primary dropdown-toggle ' . $buttonClass . '" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">' . $iconParticipationStatus . $buttonText . '</button>
                                <ul class="dropdown-menu">
                                    <li>
                                        <a class="icon-link dropdown-item admidio-event-approval-state-attend ' . $disableStatusAttend . '" href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_function.php', array('mode' => 'participate', 'dat_uuid' => $dateUuid)) . '">
                                            <i class="bi bi-check-circle-fill" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_EDIT') . '"></i>' . $gL10n->get('SYS_PARTICIPATE') . '
                                        </a>
                                    </li>';
                                if ($gSettingsManager->getBool('events_may_take_part')) {
                                    $outputButtonParticipation .= '<li>
                                            <a class="icon-link dropdown-item admidio-event-approval-state-tentative ' . $disableStatusTentative . '" href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_function.php', array('mode' => 'participate_maybe', 'dat_uuid' => $dateUuid)) . '">
                                                <i class="bi bi-question-circle-fill" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_EVENT_PARTICIPATION_TENTATIVE') . '"></i>' . $gL10n->get('SYS_EVENT_PARTICIPATION_TENTATIVE') . '
                                            </a>
                                        </li>';
                                }
                                $outputButtonParticipation .= '<li>
                                        <a class="icon-link dropdown-item admidio-event-approval-state-cancel" href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_function.php', array('mode' => 'participate_cancel', 'dat_uuid' => $dateUuid)) . '">
                                            <i class="bi bi-x-circle-fill" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_CANCEL') . '"></i>' . $gL10n->get('SYS_CANCEL') . '
                                        </a>
                                    </li>
                                </ul>
                            </div>';
                            } else {
                                $outputButtonParticipation = '
                            <div class="btn-group" role="group">
                                <button class="btn btn-primary openPopup ' . $buttonClass . '"
                                    data-href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_participation.php', array('dat_uuid' => $dateUuid)) . '">' . $iconParticipationStatus . $buttonText . '
                            </div>';
                            }
                        }

                        // Link to participants list
                        if ($gCurrentUser->hasRightViewRole($eventRolId)) {
                            if ($outputNumberMembers > 0 || $outputNumberLeaders > 0) {
                                $buttonURL = SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/groups-roles/lists_show.php', array('mode' => 'html', 'role_list' => $eventRoleUUID));

                                if ($getView === 'detail') {
                                    $outputButtonParticipants = '
                                    <button class="btn btn-primary" onclick="window.location.href=\'' . $buttonURL . '\'">
                                        <i class="bi bi-list-task"></i>' . $gL10n->get('SYS_SHOW_PARTICIPANTS') . '</button>';
                                } else {
                                    $outputButtonParticipants = '
                                    <a class="admidio-icon-link" href="' . $buttonURL . '">
                                        <i class="bi bi-list-task" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_SHOW_PARTICIPANTS') . '"></i></a>';
                                }
                            }
                        }

                        // Link to send email to participants
                        if ($gCurrentUser->hasRightSendMailToRole($eventRolId)) {
                            if ($outputNumberMembers > 0 || $outputNumberLeaders > 0) {
                                $buttonURL = SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/messages/messages_write.php', array('role_uuid' => $event->getValue('rol_uuid')));

                                if ($getView === 'detail') {
                                    $outputButtonParticipantsEmail = '
                                    <button class="btn btn-primary" onclick="window.location.href=\'' . $buttonURL . '\'">
                                        <i class="bi bi-envelope-fill"></i>' . $gL10n->get('SYS_WRITE_EMAIL') . '</button>';
                                } else {
                                    $outputButtonParticipantsEmail = '
                                    <a class="admidio-icon-link" href="' . $buttonURL . '">
                                        <i class="bi bi-envelope-fill" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_WRITE_EMAIL') . '"></i></a>';
                                }
                            }
                        }

                        // Link for managing new participants
                        if ($participants->isLeader($gCurrentUserId)) {
                            $buttonURL = SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/groups-roles/members_assignment.php', array('role_uuid' => $event->getValue('rol_uuid')));

                            if ($getView === 'detail') {
                                $outputButtonParticipantsAssign = '
                                <button class="btn btn-primary" onclick="window.location.href=\'' . $buttonURL . '\'">
                                    <i class="bi bi-person-plus-fill"></i>' . $gL10n->get('SYS_ASSIGN_PARTICIPANTS') . '</button>';
                            } else {
                                $outputButtonParticipantsAssign = '
                                <a class="admidio-icon-link" href="' . $buttonURL . '">
                                    <i class="bi bi-person-plus-fill" data-bs-toggle="tooltip" title="' . $gL10n->get('SYS_ASSIGN_PARTICIPANTS') . '"></i></a>';
                            }
                        }
                    }
                }
            }

            if ($getView === 'detail') {
                if (!$event->getValue('dat_all_day')) {
                    // Write start in array
                    $eventElements[] = array($gL10n->get('SYS_START'), '<strong>' . $event->getValue('dat_begin', $gSettingsManager->getString('system_time')) . '</strong> ' . $gL10n->get('SYS_CLOCK'));
                    // Write end in array
                    $eventElements[] = array($gL10n->get('SYS_END'), '<strong>' . $event->getValue('dat_end', $gSettingsManager->getString('system_time')) . '</strong> ' . $gL10n->get('SYS_CLOCK'));
                }

                $eventElements[] = array($gL10n->get('SYS_CALENDAR'), '<strong>' . $event->getValue('cat_name') . '</strong>');
                if ($outputLinkLocation !== '') {
                    $eventElements[] = array($gL10n->get('SYS_VENUE'), $outputLinkLocation);
                }
                if ($outputLinkRoom !== '') {
                    $eventElements[] = array($gL10n->get('SYS_ROOM'), $outputLinkRoom);
                }
                if ($outputDeadline !== '') {
                    $eventElements[] = array($gL10n->get('SYS_DEADLINE'), '<strong>' . $outputDeadline . '</strong>');
                }

                if ($outputNumberLeaders !== '') {
                    $eventElements[] = array($gL10n->get('SYS_LEADERS'), '<strong>' . $outputNumberLeaders . '</strong>');
                }
                if ($outputNumberMembers !== '') {
                    $eventElements[] = array($gL10n->get('SYS_PARTICIPANTS'), '<strong>' . $outputNumberMembers . '</strong>');
                }

                // show panel view of events

                // Output of elements
                // always 2 then line break
                $firstElement = true;
                $htmlDateElements = '';

                foreach ($eventElements as $element) {
                    if ($element[1] !== '') {
                        if ($firstElement) {
                            $htmlDateElements .= '<div class="row">';
                        }

                        $htmlDateElements .= '<div class="col-sm-2 col-4">' . $element[0] . '</div>
                        <div class="col-sm-4 col-8">' . $element[1] . '</div>';

                        if ($firstElement) {
                            $firstElement = false;
                        } else {
                            $htmlDateElements .= '</div>';
                            $firstElement = true;
                        }
                    }
                }

                if (!$firstElement) {
                    $htmlDateElements .= '</div>';
                }

                $page->addHtml('
                <div class="card admidio-blog ' . ($row['dat_highlight'] ? 'admidio-event-highlight' : '') . '" id="dat_' . $dateUuid . '">
                    <div class="card-header">
                        <i class="bi bi-calendar-week-fill"></i>' .
                    $event->getValue('dat_begin', $gSettingsManager->getString('system_date')) . $outputEndDate . ' ' . $dateHeadline);

                if ($event->isEditable() || $gSettingsManager->getBool('events_ical_export_enabled')) {
                    $page->addHtml('
                            <div class="dropdown float-end">
                                <a class="admidio-icon-link" href="#" role="button" id="dropdownMenuButton" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                    <i class="bi bi-three-dots" data-bs-toggle="tooltip"></i></a>
                                <ul class="dropdown-menu" aria-labelledby="dropdownMenuButton">');
                    // iCal Download
                    if ($gSettingsManager->getBool('events_ical_export_enabled')) {
                        $page->addHtml('
                                            <li><a class="dropdown-item" href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_function.php', array('dat_uuid' => $dateUuid, 'mode' => 'export')) . '">
                                                    <i class="bi bi-download" data-bs-toggle="tooltip"></i> ' . $gL10n->get('SYS_DOWNLOAD_ICAL') . '</a>
                                            </li>');
                    }

                    // change and delete is only for users with additional rights
                    if ($event->isEditable()) {
                        $page->addHtml('
                                            <li><a class="dropdown-item" href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_new.php', array('dat_uuid' => $dateUuid, 'copy' => 1)) . '">
                                                <i class="bi bi-copy" data-bs-toggle="tooltip"></i> ' . $gL10n->get('SYS_COPY') . '</a>
                                            </li>
                                            <li><a class="dropdown-item" href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events_new.php', array('dat_uuid' => $dateUuid)) . '">
                                                <i class="bi bi-pencil-square" data-bs-toggle="tooltip"></i> ' . $gL10n->get('SYS_EDIT') . '</a>
                                            </li>
                                            <li><a class="dropdown-item openPopup" href="javascript:void(0);"
                                                data-href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . '/adm_program/system/popup_message.php', array('type' => 'dat', 'element_id' => 'dat_' . $dateUuid,
                                'name' => $event->getValue('dat_begin', $gSettingsManager->getString('system_date')) . ' ' . $dateHeadline, 'database_id' => $dateUuid)) . '">
                                                <i class="bi bi-trash" data-bs-toggle="tooltip"></i> ' . $gL10n->get('SYS_DELETE') . '</a>
                                            </li>');
                    }
                    $page->addHtml('</ul>
                            </div>');
                }
                $page->addHtml('</div>

                    <div class="card-body">
                        ' . $htmlDateElements . '<br />
                        <p>' . $event->getValue('dat_description') . '</p>' . $attentionDeadline);

                if ($outputButtonParticipation !== '' || $outputButtonParticipants !== ''
                    || $outputButtonParticipantsEmail !== '' || $outputButtonParticipantsAssign !== '') {
                    $page->addHtml('<div class="btn-group">' . $outputButtonParticipation . $outputButtonParticipants . $outputButtonParticipantsEmail . $outputButtonParticipantsAssign . '</div>');
                }
                $page->addHtml('
                </div>
                <div class="card-footer">' .
                    // show information about user who created the recordset and changed it
                    admFuncShowCreateChangeInfoByName(
                        $row['create_name'],
                        $event->getValue('dat_timestamp_create'),
                        (string)$row['change_name'],
                        $event->getValue('dat_timestamp_change'),
                        $row['create_uuid'],
                        (string)$row['change_uuid']
                    ) . '
                    </div>
                </div>');
            } else { // $getView = 'compact' or 'room' or 'participants' or 'description'
                // show table view of events

                // Change css class if date is highlighted
                $cssClass = '';
                if ($row['dat_highlight']) {
                    $cssClass = 'admidio-event-highlight';
                }

                $dateBegin = $event->getValue('dat_begin', $gSettingsManager->getString('system_date'));
                $timeBegin = $event->getValue('dat_begin', $gSettingsManager->getString('system_time'));
                $dateEnd = $event->getValue('dat_end', $gSettingsManager->getString('system_date'));
                $timeEnd = $event->getValue('dat_end', $gSettingsManager->getString('system_time'));

                $columnValues = array();

                if ($outputButtonParticipation !== '') {
                    $columnValues[] = $outputButtonParticipation;
                } else {
                    $columnValues[] = '';
                }

                $columnValues[] = $event->getDateTimePeriod();

                if ($getViewMode === 'html') {
                    if ($outputDeadline !== '') {
                        $columnValues[] = '<a href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events.php', array('dat_uuid' => $dateUuid, 'view_mode' => 'html', 'view' => 'detail', 'headline' => $dateHeadline)) . '">' . $dateHeadline . '<br />' . $gL10n->get('SYS_DEADLINE') . ': ' . $outputDeadline . '</a>';
                    } else {
                        $columnValues[] = '<a href="' . SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events.php', array('dat_uuid' => $dateUuid, 'view_mode' => 'html', 'view' => 'detail', 'headline' => $dateHeadline)) . '">' . $dateHeadline . '</a>';
                    }
                } else {
                    $columnValues[] = $dateHeadline;
                }

                if ($getView === 'room') {
                    $columnValues[] = $outputLinkRoom;
                    $columnValues[] = $outputNumberLeaders;
                }

                switch ($getView) {
                    case 'compact': // fallthrough
                    case 'room':
                        if ($eventRolId > 0) {
                            if ($event->getValue('dat_max_members') > 0) {
                                $htmlParticipants = $outputNumberMembers . ' / ' . $event->getValue('dat_max_members');
                            } else {
                                $htmlParticipants = $outputNumberMembers . '&nbsp;';
                            }

                            if ($outputNumberMembers > 0) {
                                $htmlParticipants .= $outputButtonParticipants . $outputButtonParticipantsEmail;
                            }

                            $columnValues[] = $htmlParticipants;
                        } else {
                            $columnValues[] = '';
                        }
                        break;
                    case 'participants':
                        $columnValue = array();

                        if (is_array($participantsArray)) {
                            // Only show participants if user has right to view the list, is leader or has permission to create/edit events
                            if ($gCurrentUser->hasRightViewRole((int)$event->getValue('dat_rol_id'))
                                || $row['mem_leader'] == 1
                                || $gCurrentUser->editEvents()) {
                                foreach ($participantsArray as $participant) {
                                    if ($participant['approved'] === Participants::PARTICIPATION_YES) {
                                        $columnValue[] = $participant['firstname'] . ' ' . $participant['surname'];
                                    } elseif ($participant['approved'] === Participants::PARTICIPATION_MAYBE) {
                                        $columnValue[] = $participant['firstname'] . ' ' . $participant['surname'] . ' (' . $gL10n->get('SYS_EVENT_PARTICIPATION_TENTATIVE') . ')';
                                    }
                                }
                            }
                        }
                        $columnValues[] = implode(', ', $columnValue);
                        break;
                    case 'description':
                        $columnValues[] = $event->getValue('dat_description');
                        break;
                }

                if ($getView === 'compact') {
                    if ($outputLinkLocation !== '') {
                        $columnValues[] = $outputLinkLocation;
                    } else {
                        $columnValues[] = '';
                    }
                }

                if ($getViewMode === 'html') {
                    $columnValues[] = $outputButtonICal . $outputButtonCopy . $outputButtonEdit . $outputButtonDelete;
                }

                $compactTable->addRowByArray($columnValues, 'dat_' . $event->getValue('dat_uuid'), array('class' => $cssClass));
            }
        }  // End foreach

        // Output table bottom for compact view
        if ($getView !== 'detail') { // $getView = 'compact' or 'room' or 'participants' or 'description'
            $page->addHtml($compactTable->show());
        }
    }

    if ($getView === 'detail') {
        // If necessary show links to navigate to next and previous recordset of the query
        $baseUrl = SecurityUtils::encodeUrl(ADMIDIO_URL . FOLDER_MODULES . '/events/events.php', array('view' => $getView, 'mode' => $getMode, 'cat_uuid' => $getCatUuid, 'date_from' => $events->getParameter('dateStartFormatEnglish'), 'date_to' => $events->getParameter('dateEndFormatEnglish'), 'view_mode' => $getViewMode));
        $page->addHtml(admFuncGeneratePagination($baseUrl, $eventsResult['totalCount'], $eventsResult['limit'], $getStart));
    }
    $page->show();
} catch (Exception $e) {
    $gMessage->show($e->getMessage());
}