<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

/**
 * Search results for managers are shown in a table (student search results use the template searchresults_student).
 *
 * @package mod_booking
 * @copyright 2023 Wunderbyte GmbH
 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

namespace mod_booking\table;
use core_completion\progress;
use mod_booking\booking_answers\booking_answers;
use core_plugin_manager;
use mod_booking\local\modechecker;
use mod_booking\local\override_user_field;
use mod_booking\output\col_responsiblecontacts;
use mod_booking\output\renderer;
use mod_booking\placeholders\placeholders_info;

defined('MOODLE_INTERNAL') || die();

global $CFG;

use cache;
use coding_exception;
use context_system;
use context_module;
use dml_exception;
use html_writer;
use local_wunderbyte_table\wunderbyte_table;
use moodle_exception;
use moodle_url;
use stdClass;
use mod_booking\booking;
use mod_booking\booking_bookit;
use mod_booking\booking_option;
use mod_booking\option\dates_handler;
use mod_booking\output\col_availableplaces;
use mod_booking\output\col_teacher;
use mod_booking\price;
use mod_booking\singleton_service;

defined('MOODLE_INTERNAL') || die();

/**
 * Class to handle search results for managers are shown in a table.
 *
 * @package mod_booking
 * @copyright 2023 Wunderbyte GmbH
 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */
class bookingoptions_wbtable extends wunderbyte_table {
    /**
     * This function is called for each data row to allow processing of the
     * invisible value. It's called 'invisibleoption' so it does not interfere with
     * the bootstrap class 'invisible'.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $invisible Returns visibility of the booking option as string.
     * @throws coding_exception
     */
    public function col_invisibleoption($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_invisibleoption: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);

        if (!empty($settings->invisible)) {
            return get_string('invisibleoption', 'mod_booking');
        } else {
            return '';
        }
    }

    /**
     * Column for image.
     *
     * @param object $values
     *
     * @return string
     *
     */
    public function col_image($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_image: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);

        if (empty($settings->imageurl)) {
            return null;
        }

        return $settings->imageurl;
    }

    /**
     * This function is called for each data row to allow processing of the
     * teacher value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $string Return name of the booking option.
     * @throws dml_exception
     */
    public function col_teacher($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_teacher: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id);
        $ret = '';

        if ($this->is_downloading()) {
            // When we download, we want to render teachers as plain text.
            if (!empty($settings->teachers)) {
                $teacherstrings = [];
                foreach ($settings->teachers as $teacher) {
                    $teacherstrings[] = "$teacher->firstname $teacher->lastname ($teacher->email)";
                }
                $ret = implode(' | ', $teacherstrings);
            }
        } else {
            // Render col_teacher using a template.
            $data = new col_teacher($values->id, $settings);
            /** @var \mod_booking\output\renderer $output */
            $output = singleton_service::get_renderer('mod_booking');
            $ret = $output->render_col_teacher($data);
        }
        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * responsiblecontact value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $string Return a link to the responsible contact's user profile.
     * @throws dml_exception
     */
    public function col_responsiblecontact($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_responsiblecontact: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id);
        if (empty($settings->responsiblecontact)) {
            return '';
        }
        $responsiblestrings = [];
        foreach ($settings->responsiblecontact as $contactid) {
            $user = singleton_service::get_instance_of_user((int) $contactid);
            if (empty($user)) {
                continue;
            }
            if (empty($user->firstname)) {
                debugging(
                    " musi_table function col_responsiblecontact: " .
                    "firstname is missing for user with id $contactid in bookingoption $values->id ",
                    DEBUG_DEVELOPER
                );
                $user->firstname = '';
            }
            if (empty($user->lastname)) {
                debugging(
                    " musi_table function col_responsiblecontact: " .
                    "lastname is missing for user with id $contactid in bookingoption $values->id ",
                    DEBUG_DEVELOPER
                );
                $user->lastname = '';
            }
            if (empty($user->email)) {
                debugging(
                    " musi_table function col_responsiblecontact: " .
                    "email is missing for user with id $contactid in bookingoption $values->id ",
                    DEBUG_DEVELOPER
                );
                $user->email = '';
            }
            $responsiblestrings[] = "$user->firstname $user->lastname ($user->email)";
        }
        if ($this->is_downloading()) {
            $ret = implode(', ', $responsiblestrings);
        } else {
            $data = new col_responsiblecontacts($values->id, $settings);
            /** @var renderer $output */
            $output = singleton_service::get_renderer('mod_booking');
            $ret = $output->render_col_responsiblecontacts($data);
        }
        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * booknow value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $string Return name of the booking option.
     * @throws dml_exception
     */
    public function col_booknow($values) {
        global $USER;
        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_booknow: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);

        // We get the user ID from the table instance.
        // It is 0 by default but can be set, for example,
        // when rendering booking options for a specific user via the cashier page.
        $buyforuser = $this->foruserid;

        // We need to make sure that a user is set for the rendering of the button. When it is equal to 0,
        // we use the logged-in user. Leaving it as 0 may cause problems in the booking process,
        // for example when a pre-form is involved.
        if ($buyforuser == 0) {
            $buyforuser = $USER->id;
        }

        return booking_bookit::render_bookit_button($settings, $buyforuser);
    }

    /**
     * This function is called for each data row to allow processing of the
     * price value.
     *
     * @param object $values
     * @return string
     */
    public function col_price($values) {
        if (!$this->is_downloading()) {
            return '';
        }

        $prices = price::get_prices_from_cache_or_db('option', $values->id);
        if (empty($prices)) {
            return '';
        }
        $formattedprices = array_map(fn($a) => $a->name . ': ' . format_float($a->price, 2) . ' ' . $a->currency . ' ', $prices);

        return implode(PHP_EOL, $formattedprices);
    }

    /**
     * This function is called for each data row to allow processing of the
     * invisible value.
     *
     * @param object $values
     * @return string
     */
    public function col_invisible($values) {
        if (!$this->is_downloading()) {
            return '';
        }
        switch ($values->invisible) {
            case MOD_BOOKING_OPTION_VISIBLE:
                $status = get_string('optionvisible', 'mod_booking');
                break;
            case MOD_BOOKING_OPTION_INVISIBLE:
                $status = get_string('optioninvisible', 'mod_booking');
                break;
            case MOD_BOOKING_OPTION_VISIBLEWITHLINK:
                $status = get_string('optionvisibledirectlink', 'mod_booking');
                break;
        }
        return $status;
    }

    /**
     * This function is called for each data row to allow processing of the
     * text value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $string Return name of the booking option.
     * @throws dml_exception
     */
    public function col_text($values) {

        global $PAGE;

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_text: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $title = format_string($values->text);

        // If we download, we return the raw title without link or prefix.
        if ($this->is_downloading()) {
            return $title;
        }

        // NOTE: Do not use $this->cmid and $this->context because it might be that booking options come from different instances!
        // So we always need to retrieve them via singleton service for the current booking option ($values->id).
        $optionid = $values->id;
        $settings = singleton_service::get_instance_of_booking_option_settings($optionid);

        // If $settings->cmid is missing, we show the settings object in debug mode, so we can investigate what happens.
        if (empty($settings->cmid)) {
            $debugmessage = "bookingoptions_wbtable function col_text: ";
            $debugmessage .= "cmid is missing from settings object - settings: ";
            $debugmessage .= json_encode($settings);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $buyforuser = price::return_user_to_buy_for();
        $cmid = $settings->cmid;
        $booking = singleton_service::get_instance_of_booking_by_cmid($cmid);

        if ($booking) {
            if (!modechecker::is_ajax_or_webservice_request()) {
                $returnurl = $PAGE->url->out();
            } else {
                $returnurl = '/';
            }

            // The current page is not /mod/booking/optionview.php.
            $url = new moodle_url("/mod/booking/optionview.php", [
                "optionid" => (int) $settings->id,
                "cmid" => (int) $cmid,
                "userid" => (int) $buyforuser->id,
                'returnto' => 'url',
                'returnurl' => $returnurl,
            ]);
        } else {
            $url = '#';
        }

        if (!empty($values->titleprefix)) {
            $titleprefix = format_string($values->titleprefix);
            $title = $titleprefix . ' - ' . $title;
        }

        if (!get_config('booking', 'openbookingdetailinsametab')) {
            $title = "<div class='bookingoptions-wbtable-option-title'><a href='$url' target='_blank'>$title</a></div>";
        } else {
            $title = "<div class='bookingoptions-wbtable-option-title'><a href='$url'>$title</a></div>";
        }

        return $title;
    }

    /**
     * This function is called for each data row to allow processing of the
     * progressbar value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string the progress bar HTML
     * @throws dml_exception
     */
    public function col_progressbar($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_progressbar: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        // Progress bar showing the consumed quota visually.
        $progressbarhtml = '';
        if (get_config('booking', 'showprogressbars')) {
            $collapsible = false;
            if (get_config('booking', 'progressbarscollapsible')) {
                $collapsible = true;
            }
            $progressbarhtml = booking_option::get_progressbar_html($values->id, 'primary', 'white', $collapsible);
        }
        return $progressbarhtml;
    }

    /**
     * This function is called for each data row to allow processing of the
     * comments value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string the comments HTML
     * @throws dml_exception
     */
    public function col_comments($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_comments: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $commentshtml = '';

        // NOTE: Do not use $this->cmid and $this->context because it might be that booking options come from different instances!
        // So we always need to retrieve them via singleton service for the current booking option ($values->id).

        // phpcs:disable
        // TODO: We still need to figure out how we can fix comments in combination with wb-table-search.
        // Notice: We already have a webservice called init_comments which might help us!
        //     // Important: Without init commenting won't work.
        //     global $CFG;
        //     require_once($CFG->dirroot. '/comment/lib.php');

        //     comment::init();

        // phpcs:ignore Squiz.PHP.CommentedOutCode.Found
        /* if (!empty($this->cm) && !empty($this->cmid) && !empty($this->context)) {

            // Important: Without init commenting won't work.
            comment::init();

            // Comment booking options.
            $commentoptions = new stdClass();
            $commentoptions->area = 'booking_option';
            $commentoptions->context = $this->context;
            $commentoptions->itemid = $values->id;
            $commentoptions->component = 'mod_booking';
            $commentoptions->showcount = true;
            $commentoptions->displaycancel = true;
            $comment = new comment($commentoptions);
            if (!empty($comment)) {
                $commentshtml = $comment->output(true);
            }
        }*/
        // phpcs:enable

        return $commentshtml;
    }

    /**
     * This function is called for each data row to allow processing of the
     * ratings value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string the ratings HTML
     * @throws dml_exception
     */
    public function col_ratings($values) {
        global $DB, $USER;

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_ratings: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        // NOTE: Do not use $this->cmid and $this->context because it might be that booking options come from different instances!
        // So we always need to retrieve them via singleton service for the current booking option ($values->id).
        $optionid = $values->id;
        $settings = singleton_service::get_instance_of_booking_option_settings($optionid);

        // If $settings->cmid is missing, we show the settings object in debug mode, so we can investigate what happens.
        if (empty($settings->cmid)) {
            $debugmessage = "bookingoptions_wbtable function col_ratings: ";
            $debugmessage .= "cmid is missing from settings object - settings: ";
            $debugmessage .= json_encode($settings);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $cmid = $settings->cmid;
        $bookingsettings = singleton_service::get_instance_of_booking_settings_by_cmid($cmid);

        if (empty($bookingsettings->ratings)) {
            return '';
        }

        // Todo: Ratings need to be cached for acceptable performance.
        $context = context_module::instance($cmid);

        $ratingshtml = '';

        $isteacher = booking_check_if_teacher($values);

        $params = ['optionid' => $values->id];

        $sql = "SELECT AVG(rate) AS rating, COUNT(rate) AS ratingcount
        FROM {booking_ratings} br
        WHERE br.optionid = :optionid";

        if ($record = $DB->get_record_sql($sql, $params)) {
            $rating = $record->rating;
            $ratingcount = $record->ratingcount;
        } else {
            $rating = null;
            $ratingcount = null;
        }

        // Now add userid to params.
        $params['userid'] = $USER->id;

        $sql = "SELECT rate AS myrating
            FROM {booking_ratings} br
            WHERE br.optionid = :optionid
            AND br.userid = :userid";

        if ($record = $DB->get_record_sql($sql, $params)) {
            $myrating = $record->myrating;
        } else {
            $myrating = null;
        }

        if (!empty($cmid)) {
            $bookingsettings = singleton_service::get_instance_of_booking_settings_by_cmid($cmid);
            if (!empty($context) && !empty($bookingsettings)) {
                if ($bookingsettings->ratings > 0) {
                    $ratingshtml =
                        "<div>
                        <select class='starrating' id='rate$values->id' data-current-rating='$myrating' data-itemid='$values->id'>
                            <option value='1'>1</option>
                            <option value='2'>2</option>
                            <option value='3'>3</option>
                            <option value='4'>4</option>
                            <option value='5'>5</option>
                        </select>
                    </div>";

                    if (has_capability('mod/booking:readresponses', $context) || $isteacher) {
                        $ratingshtml .= get_string('aggregateavg', 'rating') . ' ' .
                            number_format((float) $rating, 2, '.', '') . " ($ratingcount)";
                    }
                }
            }
        }

        return $ratingshtml;
    }

    /**
     * This function is called for each data row to allow processing of the
     * coursestarttime value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $coursestarttime Returns course start time as a readable string.
     * @throws coding_exception
     */
    public function col_bookings($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_bookings: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        /** @var \mod_booking\output\renderer $output */
        $output = singleton_service::get_renderer('mod_booking');

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);
        $buyforuser = price::return_user_to_buy_for();
        // Render col_bookings using a template.
        $data = new col_availableplaces($values, $settings, $buyforuser);

        $ret = '';
        if ($this->is_downloading()) {
            $bookinginformation = $data->get_bookinginformation();

            $booked = $bookinginformation['booked'] ?? 0;
            $maxanswers = $bookinginformation['maxanswers'] ?? 0;
            $waiting = $bookinginformation['waiting'] ?? 0;
            $maxoverbooking = $bookinginformation['maxoverbooking'] ?? 0;

            $ret .= "$booked / ";
            $ret .= $maxanswers ?? get_string('unlimitedplaces', 'mod_booking');
            if ($maxoverbooking > 0) {
                $ret .= " (" . get_string('waitinglist', 'mod_booking') . ": $waiting / $maxoverbooking)";
            } else if ($maxoverbooking < 0) {
                $ret .= " ("
                    . get_string('waitinglist', 'mod_booking')
                    . ": $waiting / " . get_string('unlimitedplaces', 'mod_booking')
                    . ")";
            }
        } else {
            $ret = $output->render_col_availableplaces($data);
        }
        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * location value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string location
     * @throws coding_exception
     */
    public function col_location($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_location: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);

        if (isset($settings->entity) && (count($settings->entity) > 0)) {
            $url = new moodle_url('/local/entities/view.php', ['id' => $settings->entity['id']]);
            // Full name of the entity (NOT the shortname).

            if (!empty($settings->entity['parentname'])) {
                $nametobeshown = $settings->entity['parentname'] . " (" . $settings->entity['name'] . ")";
            } else {
                $nametobeshown = $settings->entity['name'];
            }

            if ($this->is_downloading()) {
                // No hyperlink when downloading.
                return $nametobeshown;
            }

            // Add link to entity.
            return html_writer::tag('a', $nametobeshown, ['href' => $url->out(false)]);
        }

        // If no entity is set, we show the value stored in location.
        return $settings->location;
    }

    /**
     * This function is called for each data row to allow processing of the
     * institution value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string institution
     * @throws coding_exception
     */
    public function col_institution($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_institution: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);
        return format_string($settings->institution);
    }

    /**
     * This function is called for each data row to allow processing of the
     * associated Moodle course.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a link to the Moodle course - if there is one
     * @throws coding_exception
     */
    public function col_course($values) {
        global $USER;

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_course: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);

        $ret = '';

        $moodleurl = new moodle_url('/course/view.php', ['id' => $settings->courseid]);
        $courseurl = $moodleurl->out(false);
        // If we download, we want to return the plain URL.
        if ($this->is_downloading()) {
            return $courseurl;
        }

        $isteacherofthisoption = booking_check_if_teacher($values);

        if (!empty($settings->cmid)) {
            $context = context_module::instance($settings->cmid);
        } else {
            $context = $this->get_context();
        }

        // When we have this seeting, we never show the link here.
        if (
            get_config('booking', 'linktomoodlecourseonbookedbutton')
            && (!has_capability('mod/booking:updatebooking', $context)
                && !$isteacherofthisoption)
        ) {
            return '';
        }

        $answersobject = singleton_service::get_instance_of_booking_answers($settings);
        $status = $answersobject->user_status($USER->id);

        $isteacherofthisoption = booking_check_if_teacher($values);

        if (
            $status == MOD_BOOKING_STATUSPARAM_BOOKED
            && get_config('booking', 'linktomoodlecourseonbookedbutton')
        ) {
            return '';
        }

        if (
            !empty($settings->courseid)
            && (
                $status == MOD_BOOKING_STATUSPARAM_BOOKED
                || has_capability('mod/booking:updatebooking', $context)
                || $isteacherofthisoption
            )
        ) {
            // The link will be shown to everyone who...
            // ...has booked this option.
            // ...is a teacher of this option.
            // ...has the "updatebooking" capability (admins).
            $gotomoodlecourse = get_string('gotomoodlecourse', 'mod_booking');
            $ret = "<a href='$courseurl' target='_self' class='btn btn-primary p-1 mt-2 mb-2 w-100'>
                <i class='fa fa-graduation-cap fa-fw' aria-hidden='true'></i>&nbsp;&nbsp;$gotomoodlecourse
            </a>";
        }

        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * associated Moodle course's shortname.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a link to the Moodle course - if there is one
     * @throws coding_exception
     */
    public function col_courseshortname($values) {
        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_courseshortname: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);

        $ret = '';

        $courseid = $settings->courseid;
        if (empty($courseid)) {
            // If there is no courseid, we return an empty string.
            return '';
        }
        $course = get_course($courseid);
        $shortname = $course->shortname;
        if (empty($shortname)) {
            // If there is no shortname, we return an empty string.
            return '';
        }
        return $shortname;
    }

    /**
     * This function is called for each data row to allow processing of the
     * dayofweektime value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $dayofweektime String for date series, e.g. "Mon, 16:00 - 17:00"
     * @throws coding_exception
     */
    public function col_dayofweektime($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_dayofweektime: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $ret = '';
        $settings = singleton_service::get_instance_of_booking_option_settings($values->id, $values);

        if (!empty($settings->dayofweektime)) {
            $ret = dates_handler::render_dayofweektime_strings($settings->dayofweektime, ' | ');
        }

        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * showdates value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a string containing collapsible dates
     * @throws coding_exception
     */
    public function col_showdates($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_showdates: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        // NOTE: Do not use $this->cmid and $this->context because it might be that booking options come from different instances!
        // So we always need to retrieve them via singleton service for the current booking option ($values->id).
        $optionid = $values->id;
        $settings = singleton_service::get_instance_of_booking_option_settings($optionid);

        // If $settings->cmid is missing, we show the settings object in debug mode, so we can investigate what happens.
        if (empty($settings->cmid)) {
            $debugmessage = "bookingoptions_wbtable function col_showdates: ";
            $debugmessage .= "cmid is missing from settings object - settings: ";
            $debugmessage .= json_encode($settings);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $cmid = $settings->cmid;
        $booking = singleton_service::get_instance_of_booking_by_cmid($cmid);

        $ret = '';
        if ($this->is_downloading()) {
            $datestrings = dates_handler::return_array_of_sessions_datestrings($optionid);
            $ret = implode(' | ', $datestrings);
        } else {
            // Use the renderer to output this column.
            $lang = current_language();

            $cachekey = "sessiondates$optionid$lang";
            $cache = cache::make($this->cachecomponent, $this->rawcachename);

            if (
                !empty($settings->selflearningcourse)
                || !$ret = $cache->get($cachekey)
            ) {
                $data = new \mod_booking\output\col_coursestarttime($optionid, $booking);
                /** @var \mod_booking\output\renderer $output */
                $output = singleton_service::get_renderer('mod_booking');
                $ret = $output->render_col_coursestarttime($data);
                if (empty($settings->selflearningcourse)) {
                    $cache->set($cachekey, $ret);
                }
            }
        }
        return $ret;
    }

    /**
     * This function is called for each data row to add a link
     * for managing responses (booking_answers).
     *
     * @param object $values Contains object with all the values of record.
     * @return string $link Returns a link to report.php (manage responses).
     * @throws moodle_exception
     * @throws coding_exception
     */
    public function col_manageresponses($values) {
        global $CFG, $DB;

        // Link is empty on default.
        $link = '';

        $settings = singleton_service::get_instance_of_booking_option_settings($values->optionid, $values);
        $bookinganswers = singleton_service::get_instance_of_booking_answers($settings);

        if (booking_answers::count_places($bookinganswers->get_usersonlist()) > 0) {
            // Add a link to redirect to the booking option.
            $link = new moodle_url($CFG->wwwroot . '/mod/booking/report.php', [
                'id' => $values->cmid,
                'optionid' => $values->optionid,
            ]);
            // Use html_entity_decode to convert "&amp;" to a simple "&" character.
            if ($CFG->version >= 2023042400) {
                // Moodle 4.2 needs second param.
                $link = html_entity_decode($link->out(), ENT_QUOTES);
            } else {
                // Moodle 4.1 and older.
                $link = html_entity_decode($link->out(), ENT_COMPAT);
            }

            if (!$this->is_downloading()) {
                // Only format as a button if it's not an export.
                $link = '<a href="' . $link . '" class="btn btn-secondary">'
                    . get_string('bstmanageresponses', 'mod_booking')
                    . '</a>';
            }
        }
        // Do not show a link if there are no answers.

        return $link;
    }

    /**
     * This function is called for each data row to allow processing of the
     * action button.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $action Returns formatted action button.
     * @throws moodle_exception
     * @throws coding_exception
     */
    public function col_action($values) {
        global $OUTPUT, $USER;

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_action: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        // NOTE: Do not use $this->cmid and $this->context because it might be that booking options come from different instances!
        // So we always need to retrieve them via singleton service for the current booking option ($values->id).
        $optionid = $values->id;
        $settings = singleton_service::get_instance_of_booking_option_settings($optionid);

        // If $settings->cmid is missing, we show the settings object in debug mode, so we can investigate what happens.
        if (empty($settings->cmid)) {
            $debugmessage = "bookingoptions_wbtable function col_action: ";
            $debugmessage .= "cmid is missing from settings object - settings: ";
            $debugmessage .= json_encode($settings);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $cmid = $settings->cmid;
        $context = context_module::instance($cmid);
        $answersobject = singleton_service::get_instance_of_booking_answers($settings);
        $status = $answersobject->user_status($USER->id);

        // Set the returnurl to navigate back to after form is saved.

        $returnurloptions = ['id' => $cmid];
        if (!empty(optional_param('whichview', '', PARAM_ALPHAEXT))) {
            $returnurloptions['whichview'] = optional_param('whichview', '', PARAM_ALPHAEXT);
        }

        if (!empty(optional_param('optionid', '', PARAM_INT))) {
            $returnurloptions['optionid'] = optional_param('optionid', '', PARAM_INT);
        }

        $viewphpurl = new moodle_url('/mod/booking/view.php', $returnurloptions);
        $returnurl = $viewphpurl->out(false);

        // Capabilities.
        $canupdate = has_capability('mod/booking:updatebooking', $context);
        $isteacherandcanedit = (has_capability('mod/booking:addeditownoption', $context) &&
            booking_check_if_teacher($values));

        $ddoptions = [];
        $ret = '<div class="menubar pe-2" id="action-menu-' . $optionid . '-menubar" role="menubar">';

        if ($status == MOD_BOOKING_STATUSPARAM_BOOKED) {
            $ret .= html_writer::link(
                new moodle_url(
                    '/mod/booking/viewconfirmation.php',
                    ['id' => $cmid, 'optionid' => $optionid]
                ),
                $OUTPUT->pix_icon('t/print', get_string('bookedtext', 'mod_booking')),
                [
                    'target' => '_blank',
                    'class' => 'text-primary pe-3',
                    'aria-label' => get_string('bookedtext', 'mod_booking'),
                ]
            );
        }

        if ($canupdate || $isteacherandcanedit) {
            $ret .= html_writer::link(
                new moodle_url(
                    '/mod/booking/editoptions.php',
                    [
                        'id' => $cmid,
                        'optionid' => $optionid,
                        'returnto' => 'url',
                        'returnurl' => $returnurl,
                    ]
                ),
                $OUTPUT->pix_icon('i/edit', get_string('editbookingoption', 'mod_booking')),
                [
                    'target' => '_self',
                    'class' => 'text-primary',
                    'aria-label' => get_string('editbookingoption', 'mod_booking'),
                ]
            );
        }

        if ($canupdate || $isteacherandcanedit) {
            $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                new moodle_url(
                    '/mod/booking/editoptions.php',
                    [
                        'id' => $cmid,
                        'optionid' => $optionid,
                        'returnto' => 'url',
                        'returnurl' => $returnurl,
                    ]
                ),
                $OUTPUT->pix_icon('t/editstring', get_string('editbookingoption', 'mod_booking')) .
                get_string('editbookingoption', 'mod_booking')
            ) . '</div>';

            $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                new moodle_url(
                    '/mod/booking/report.php',
                    [
                        'id' => $cmid,
                        'optionid' => $optionid,
                    ]
                ),
                '<i class="icon fa fa-ticket fa-fw" aria-hidden="true"
                    aria-label="' . get_string('manageresponses', 'mod_booking') .
                '" title="' . get_string('manageresponses', 'mod_booking') . '" >
                </i>' .
                get_string('manageresponses', 'mod_booking')
            ) . '</div>';

            if (get_config('booking', 'bookingstracker')) {
                $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                    new moodle_url(
                        '/mod/booking/report2.php',
                        [
                            'cmid' => $cmid,
                            'optionid' => $optionid,
                        ]
                    ),
                    '<i class="icon fa fa-sitemap fa-fw" aria-hidden="true"
                        aria-label="' . get_string('bookingstracker', 'mod_booking') .
                    '" title="' . get_string('bookingstracker', 'mod_booking') . '" >
                    </i>' .
                    get_string('bookingstracker', 'mod_booking')
                ) . '</div>';
            }

            // Book other users.
            if (
                has_capability('mod/booking:bookforothers', $context) &&
                (has_capability('mod/booking:subscribeusers', $context) ||
                    booking_check_if_teacher($values))
            ) {
                $subscribeusersurl = new moodle_url(
                    '/mod/booking/subscribeusers.php',
                    [
                        'id' => $cmid,
                        'optionid' => $optionid,
                        'returnto' => 'url',
                        'returnurl' => $returnurl,
                    ]
                );
                $ddoptions[] = '<div class="dropdown-item">' .
                    html_writer::link(
                        $subscribeusersurl,
                        $OUTPUT->pix_icon(
                            'i/users',
                            get_string('bookotherusers', 'mod_booking')
                        ) .
                        get_string('bookotherusers', 'mod_booking')
                    ) . '</div>';
            }

            // Create booking option from each option date.
            $createfromoptiondateurl = new moodle_url(
                '/mod/booking/editoptions.php',
                ['id' => $cmid, 'optionid' => $optionid, 'createfromoptiondates' => 1]
            );
            $override = new override_user_field($cmid);
            $link = $override->get_circumvent_link($optionid);
            if (!empty($link)) {
                $ddoptions[] = '<div class="dropdown-item">' .
                    html_writer::link(
                        '#',
                        $OUTPUT->pix_icon(
                            'i/link',
                            get_string('copycircumventlink', 'mod_booking')
                        ) .
                        get_string('copycircumventlink', 'mod_booking'),
                        [
                            'class' => 'copy_to_clipboard',
                            'onclick' => "navigator.clipboard.writeText('$link'); return false;",
                        ]
                    ) . '</div>';
            }

            $ddoptions[] = '<div class="dropdown-item">' .
                html_writer::link(
                    $createfromoptiondateurl,
                    $OUTPUT->pix_icon(
                        'i/withsubcat',
                        get_string('createoptionsfromoptiondate', 'mod_booking')
                    ) .
                    get_string('createoptionsfromoptiondate', 'mod_booking')
                ) . '</div>';

            if (get_config('booking', 'teachersallowmailtobookedusers')) {
                $mailtolink = booking_option::get_mailto_link_for_partipants($optionid);
                if (!empty($mailtolink)) {
                    $ddoptions[] = '<div class="dropdown-item">' .
                        html_writer::link($mailtolink, $OUTPUT->pix_icon(
                            't/email',
                            get_string('sendmailtoallbookedusers', 'mod_booking')
                        ) .
                            get_string('sendmailtoallbookedusers', 'booking')) .
                        '</div>';
                }
            }

            // Show link to optiondates-teachers-report (teacher substitutions).
            $optiondatesteachersmoodleurl = new moodle_url(
                '/mod/booking/optiondates_teachers_report.php',
                ['cmid' => $cmid, 'optionid' => $optionid, 'returnto' => 'url', 'returnurl' => $returnurl]
            );
            $ddoptions[] = '<div class="dropdown-item">' .
                html_writer::link(
                    $optiondatesteachersmoodleurl,
                    $OUTPUT->pix_icon(
                        'i/grades',
                        get_string('optiondatesteachersreport', 'mod_booking')
                    ) .
                    get_string('optiondatesteachersreport', 'mod_booking')
                ) . '</div>';

            // Show only one option.
            $onlyoneurl = new moodle_url(
                '/mod/booking/view.php',
                ['id' => $cmid, 'optionid' => $optionid, 'whichview' => 'showonlyone']
            );
            $ddoptions[] = '<div class="dropdown-item">' .
                html_writer::link(
                    $onlyoneurl,
                    $OUTPUT->pix_icon(
                        'i/publish',
                        get_string('onlythisbookingoption', 'mod_booking')
                    ) .
                    get_string('onlythisbookingoption', 'mod_booking')
                ) . '</div>';

            if ($canupdate) {
                // Cancel booking options.
                // Find out if the booking option has a price or not.
                $optioninfo = $settings->return_booking_option_information($USER, false);
                $optionhasprice = empty($optioninfo['price']) ? false : true;

                if ($optionhasprice && class_exists('local_shopping_cart\shopping_cart')) {
                    // The option costs something and shopping cart is installed:
                    // We have to cancel the shopping-cart way!
                    if ($values->status == 1) {
                        // If booking option is already cancelled, we want to show the "undo cancel" button.
                        $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                            '#',
                            $OUTPUT->pix_icon('i/reload', '') .
                            get_string('undocancelthisbookingoption', 'mod_booking'),
                            [
                                'class' => 'undocancelallusers',
                                'data-id' => $optionid,
                                'data-componentname' => 'mod_booking',
                                'data-area' => 'option',
                                'onclick' =>
                                    "require(['mod_booking/confirm_cancel'], function(init) {
                                        init.init('" . $optionid . "', '" . $values->status . "');
                                    });",
                            ]
                        ) . "</div>";
                    } else {
                        // Else we show the cancel button.
                        $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                            '#',
                            $OUTPUT->pix_icon('t/block', '') .
                            get_string('cancelallusers', 'mod_booking'),
                            [
                                'class' => 'cancelallusers',
                                'data-id' => $optionid,
                                'data-componentname' => 'mod_booking',
                                'data-area' => 'option',
                                'onclick' =>
                                    "require(['local_shopping_cart/menu'], function(menu) {
                                        menu.confirmCancelAllUsersAndSetCreditModal('" . $optionid . "', 'mod_booking', 'option');
                                    });",
                            ]
                        ) . "</div>";
                    }
                } else {
                    // The option has no price or shopping cart is not installed, so we cancel the default booking way.
                    if ($values->status == 1) {
                        // If booking option is already cancelled, we want to show the "undo cancel" button.
                        $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                            '#',
                            $OUTPUT->pix_icon('i/reload', '') .
                            get_string('undocancelthisbookingoption', 'mod_booking'),
                            [
                                'onclick' =>
                                    "require(['mod_booking/confirm_cancel'], function(init) {
                                        init.init('" . $optionid . "', '" . $values->status . "');
                                    });",
                            ]
                        ) . "</div>";
                    } else {
                        // Else we show the cancel button.
                        $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                            '#',
                            $OUTPUT->pix_icon('t/block', '') .
                            get_string('cancelthisbookingoption', 'mod_booking'),
                            [
                                'onclick' =>
                                    "require(['mod_booking/confirm_cancel'], function(init) {
                                        init.init('" . $optionid . "', '" . $values->status . "');
                                    });",
                            ]
                        ) . "</div>";
                    }
                }

                $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(new moodle_url(
                    '/mod/booking/editoptions.php',
                    [
                        'id' => $cmid,
                        'optionid' => -1,
                        'copyoptionid' => $optionid,
                        'returnto' => 'url',
                        'returnurl' => $returnurl,
                    ]
                ), $OUTPUT->pix_icon(
                    't/copy',
                    get_string('duplicatebookingoption', 'mod_booking')
                ) .
                    get_string('duplicatebookingoption', 'mod_booking')) . '</div>';

                $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                    new moodle_url('/mod/booking/report.php', [
                        'id' => $cmid,
                        'optionid' => $optionid,
                        'action' => 'deletebookingoption',
                        'sesskey' => sesskey(),
                        'returnto' => 'url',
                        'returnurl' => $returnurl,
                    ]),
                    $OUTPUT->pix_icon('t/delete', get_string('deletethisbookingoption', 'mod_booking')) .
                    get_string('deletethisbookingoption', 'mod_booking')
                ) . '</div>';
            }
            // phpcs:ignore moodle.Commenting.TodoComment.MissingInfoInline
            // TODO: Move booking options to another option currently does not work correcly.
            // We temporarily remove it from booking until we are sure, it works.
            // We need to make sure it works for: teachers, optiondates, prices, answers customfields etc.
            // phpcs:ignore Squiz.PHP.CommentedOutCode.Found
            /* $modinfo = get_fast_modinfo($this->booking->course);
            $bookinginstances = isset($modinfo->instances['booking']) ? count($modinfo->instances['booking']) : 0;
            if (has_capability('mod/booking:updatebooking', context_course::instance($this->booking->course->id)) &&
                $bookinginstances > 1) {
                $ddoptions[] = '<div class="dropdown-item">' . html_writer::link(
                        new moodle_url('/mod/booking/moveoption.php',
                            array('id' => $cmid, 'optionid' => $optionid, 'sesskey' => sesskey())),
                        $OUTPUT->pix_icon('t/move', get_string('moveoptionto', 'booking')) .
                        get_string('moveoptionto', 'booking')) . '</div>';
            } */
        }
        foreach (core_plugin_manager::instance()->get_plugins_of_type('bookingextension') as $plugin) {
            $class = "\\bookingextension_{$plugin->name}\\{$plugin->name}";
            if (!class_exists($class)) {
                continue;
            }
            $ddoptionsfromplugin = $class::add_options_to_col_actions($settings, $context);
            if (!empty($ddoptionsfromplugin)) {
                $ddoptions[] = $ddoptionsfromplugin;
            }
        }
        if (!empty($ddoptions)) {
            $ret .= '<div class="dropdown d-inline">
                    <button class="bookingoption-edit-button dropdown-toggle btn btn-light btn-sm" id="action-menu-toggle-' .
                        $optionid .
                        '" title="" role="button" data-toggle="dropdown" data-bs-toggle="dropdown"
                        aria-haspopup="true" aria-expanded="false">
                        <i class="icon fa fa-cog fa-fw" aria-hidden="true"
                            aria-label="' . get_string('settings') . '" title="' . get_string('settings') . '" >
                        </i>
                    </button>
                    <div class="dropdown-menu dropdown-menu-right dropdown-menu-end menu align-tr-br" id="action-menu-' .
                $optionid .
                '-menu" data-rel="menu-content"
                        aria-labelledby="action-menu-toggle-3" role="menu" data-align="tr-br">';
            $ret .= implode($ddoptions);
            $ret .= '</div></div>';
        }

        $ret .= '</div>';

        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * minanswers value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a string containing the minanswers description and value
     * @throws coding_exception
     */
    public function col_minanswers($values) {
        $ret = '';
        if (!empty($values->minanswers)) {
            if (!$this->is_downloading()) {
                $ret .= get_string('minanswers', 'mod_booking') . ": ";
            }
            $ret .= $values->minanswers;
        }
        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * "text depending on user status (statusdescription)" value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a string containing the text depending on userstatus
     * @throws coding_exception
     */
    public function col_statusdescription($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_statusdescription: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $ret = '';
        // NOTE: Do not use $this->cmid and $this->context because it might be that booking options come from different instances!
        // So we always need to retrieve them via singleton service for the current booking option ($values->id).
        $optionid = $values->id;
        $settings = singleton_service::get_instance_of_booking_option_settings($optionid);

        // If $settings->cmid is missing, we show the settings object in debug mode, so we can investigate what happens.
        if (empty($settings->cmid)) {
            $debugmessage = "bookingoptions_wbtable function col_statusdescription: ";
            $debugmessage .= "cmid is missing from settings object - settings: ";
            $debugmessage .= json_encode($settings);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        $cmid = $settings->cmid;
        $bookingoption = singleton_service::get_instance_of_booking_option($cmid, $optionid);
        $bookinganswers = singleton_service::get_instance_of_booking_answers($settings);

        $statusdescription = $bookingoption->get_text_depending_on_status($bookinganswers);
        if (!empty($statusdescription)) {
            $ret = $statusdescription;
        }
        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * "description" value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $ret the return string
     * @throws coding_exception
     */
    public function col_description($values) {
        $optionid = $values->id;
        $settings = singleton_service::get_instance_of_booking_option_settings($optionid);
        $cmid = $settings->cmid;
        $values->description = placeholders_info::render_text($values->description, $cmid, $optionid);

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_description: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }
        if (empty(get_config("booking", "changedescriptionfield"))) {
            $description = $values->description;
        } else {
            $customfieldshortname = get_config("booking", "changedescriptionfield");
            $description = $settings->customfields[$customfieldshortname] ?? "";
        }
        // If we download, we want to show text only without HTML tags.
        if ($this->is_downloading()) {
            $description = strip_tags($description, '<br>');
            $description = str_replace('<br>', '\r\n', $description);
            return strip_tags($description);
        }

        $formatted = format_text($description);
        $ret = $formatted;

        if (!empty(get_config('booking', 'collapsedescriptionmaxlength'))) {
            // Use the renderer to output this column.
            $lang = current_language();
            $optionid = $values->id;

            $cachekey = "shortdescription$optionid$lang";
            $cache = cache::make($this->cachecomponent, $this->rawcachename);

            if (
                !$ret = $cache->get($cachekey)
            ) {
                $maxlength = (int) get_config('booking', 'collapsedescriptionmaxlength');
                $ret = $formatted;
                // Show collapsible for long descriptions.
                $shortdescription = strip_tags($ret, '<br>');
                if (strlen($shortdescription) > $maxlength) {
                    $ret =
                        '<div>
                            <a data-toggle="collapse" data-bs-toggle="collapse"
								href="#collapseDescription' . $values->id . '" role="button"
                                aria-expanded="false" aria-controls="collapseDescription">
                                <i class="fa fa-info-circle" aria-hidden="true"></i>&nbsp;' .
                        get_string('showdescription', 'mod_booking') . '...</a>
                        </div>
                        <div class="collapse" id="collapseDescription' . $values->id . '">
                            <div class="card card-body border-1 mt-1 mb-1 me-3">' . $ret . '</div>
                        </div>';
                }

                $cache->set($cachekey, $ret);
            }
        }

        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * "bookingopeningtime" value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a string containing the booking opening time
     * @throws coding_exception
     */
    public function col_bookingopeningtime($values) {
        $bookingopeningtime = $values->bookingopeningtime;
        if (empty($bookingopeningtime)) {
            return '';
        }

        // Get userdate for the correct locale and language.
        $renderedbookingopeningtime = userdate($bookingopeningtime, get_string('strftimedatetime', 'langconfig'));
        if ($this->is_downloading()) {
            $ret = $renderedbookingopeningtime;
        } else {
            $ret = get_string('bookingopeningtime', 'mod_booking') . ": " . $renderedbookingopeningtime;
        }
        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * "col_bookingclosingtime" value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a string containing the booking closing time
     * @throws coding_exception
     */
    public function col_bookingclosingtime($values) {
        $bookingclosingtime = $values->bookingclosingtime;
        if (empty($bookingclosingtime)) {
            return '';
        }

        // Get userdate for the correct locale and language.
        $renderedbookingclosingtime = userdate($bookingclosingtime, get_string('strftimedatetime', 'langconfig'));
        if ($this->is_downloading()) {
            $ret = $renderedbookingclosingtime;
        } else {
            $ret = get_string('bookingclosingtime', 'mod_booking') . ": " . $renderedbookingclosingtime;
        }
        return $ret;
    }

    /**
     * This function is called for each data row to allow processing of the
     * "attachment" value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a string containing a link to the attachment
     * @throws coding_exception
     */
    public function col_attachment($values) {

        // If $values->id is missing, we show the values object in debug mode, so we can investigate what happens.
        if (empty($values->id)) {
            $debugmessage = "bookingoptions_wbtable function col_attachment: ";
            $debugmessage .= "id (optionid) is missing from values object - values: ";
            $debugmessage .= json_encode($values);
            debugging($debugmessage, DEBUG_DEVELOPER);
            return '';
        }

        return booking_option::render_attachments($values->id, 'mod-booking-option-attachments mb-2');
    }

    /**
     * This function is called for each data row to allow processing of the
     * "attachment" value.
     *
     * @param object $values Contains object with all the values of record.
     * @return string a string containing a link to the attachment
     * @throws coding_exception
     */
    public function col_competencies($values) {
        if (empty($values->competencies)) {
            return '';
        }

        // Button triggers filter for these checkboxes.
        $label = get_string('showsimilaroptions', 'mod_booking');
        return '<button id="loadcompetencybutton_' . $values->id . '"
            class="btn btn-light booking-competencies-trigger-filter-button"
            data-competency-ids="' . $values->competencies . '"
            data-table-uniqueid="' . $this->uniqueid . '"
            data-table-idstring="' . $this->idstring . '"
            data-bookingoptionid="' . $values->id . '">
            ' . $label . '</button>

            <div> Competencies: ' . $values->competencies . '</div>';
    }

    /**
     * Shows course progress if courseid is set.
     *
     * @param object $values Contains object with all the values of record.
     * @return string $invisible Returns visibility of the booking option as string.
     * @throws coding_exception
     */
    public function col_progress($values) {
        global $USER;
        if ($values->courseid) {
            $completion = round(progress::get_course_progress_percentage(get_course($values->courseid), $USER->id), 2);
            return ($completion === null) ? '' : '| ' . $completion . get_string('postprogressstring', 'mod_booking');
        }
        return '';
    }
}
