class.ilLPTableBaseGUI.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once("./Services/Table/classes/class.ilTable2GUI.php");
include_once  './Services/Search/classes/class.ilSearchSettings.php';
require_once('./Services/Repository/classes/class.ilObjectPlugin.php');

class ilLPTableBaseGUI extends ilTable2GUI
{
    protected $filter; // array
    protected $anonymized; // [bool]

    public function __construct($a_parent_obj, $a_parent_cmd = "", $a_template_context = "")
    {
        parent::__construct($a_parent_obj, $a_parent_cmd, $a_template_context);

        // country names
        $this->lng->loadLanguageModule("meta");
        
        include_once("./Services/Object/classes/class.ilObjectLP.php");
        
        $this->anonymized = (bool) !ilObjUserTracking::_enabledUserRelatedData();
        if (!$this->anonymized && $this->obj_id) {
            include_once "Services/Object/classes/class.ilObjectLP.php";
            $olp = ilObjectLP::getInstance($this->obj_id);
            $this->anonymized = $olp->isAnonymized();
        }
    }

    public function executeCommand()
    {
        global $DIC;

        $ilCtrl = $DIC['ilCtrl'];
        $lng = $DIC['lng'];

        $this->determineSelectedFilters();

        if (!$ilCtrl->getNextClass($this)) {
            $to_hide = false;

            switch ($ilCtrl->getCmd()) {
                case "applyFilter":
                    $this->resetOffset();
                    $this->writeFilterToSession();
                    break;

                case "resetFilter":
                    $this->resetOffset();
                    $this->resetFilter();
                    break;

                case "hideSelected":
                    $to_hide = $_POST["item_id"];
                    break;

                case "hide":
                    $to_hide = array((int) $_GET["hide"]);
                    break;
                
                case "mailselectedusers":
                    if (!sizeof($_POST["uid"])) {
                        ilUtil::sendFailure($lng->txt("no_checkbox"), true);
                    } else {
                        $this->sendMail($_POST["uid"], $this->parent_obj, $this->parent_cmd);
                    }
                    break;
                    
                case 'addToClipboard':
                    if (!sizeof($_POST['uid'])) {
                        ilUtil::sendFailure($lng->txt('no_checkbox'), true);
                    } else {
                        $this->addToClipboard();
                    }
                    break;
                
                // page selector
                default:
                    $this->determineOffsetAndOrder();
                    $this->storeNavParameter();
                    break;
            }

            if ($to_hide) {
                $obj = $this->getFilterItemByPostVar("hide");
                $value = array_unique(array_merge((array) $obj->getValue(), $to_hide));
                $obj->setValue($value);
                $obj->writeToSession();
            }

            if (isset($_REQUEST["tbltplcrt"])) {
                $ilCtrl->setParameter($this->parent_obj, "tbltplcrt", $_REQUEST["tbltplcrt"]);
            }
            if (isset($_REQUEST["tbltpldel"])) {
                $ilCtrl->setParameter($this->parent_obj, "tbltpldel", $_REQUEST["tbltpldel"]);
            }

            $ilCtrl->redirect($this->parent_obj, $this->parent_cmd);
        } else {
            // e.g. repository selector
            return parent::executeCommand();
        }
    }
    
    protected function sendMail(array $a_user_ids, $a_parent_obj, $a_parent_cmd)
    {
        // see ilObjCourseGUI::sendMailToSelectedUsersObject()
        
        require_once 'Services/Mail/classes/class.ilMailFormCall.php';
        
        $rcps = array();
        foreach ($a_user_ids as $usr_id) {
            $rcps[] = ilObjUser::_lookupLogin($usr_id);
        }
        
        $template = array();
        $sig = null;
        
        // repository-object-specific
        $ref_id = (int) $_REQUEST["ref_id"];
        if ($ref_id) {
            $obj_lp = ilObjectLP::getInstance(ilObject::_lookupObjectId($ref_id));
            $tmpl_id = $obj_lp->getMailTemplateId();
    
            if ($tmpl_id) {
                $template = array(
                    ilMailFormCall::CONTEXT_KEY => $tmpl_id,
                    'ref_id' => $ref_id,
                    'ts' => time()
                );
            } else {
                include_once './Services/Link/classes/class.ilLink.php';
                $sig = ilLink::_getLink($ref_id);
                $sig = rawurlencode(base64_encode($sig));
            }
        }
        
        ilUtil::redirect(
            ilMailFormCall::getRedirectTarget(
                $a_parent_obj,
                $a_parent_cmd,
                array(),
                array(
                    'type' => 'new',
                    'rcp_to' => implode(',', $rcps),
                    'sig' => $sig
                ),
                $template
            )
        );
    }

    protected function searchObjects(array $filter, $permission, array $preset_obj_ids = null, $a_check_lp_activation = true)
    {
        global $DIC;

        $ilObjDataCache = $DIC['ilObjDataCache'];
                
        include_once './Services/Search/classes/class.ilQueryParser.php';

        $query_parser = new ilQueryParser($filter["query"]);
        $query_parser->setMinWordLength(0);
        $query_parser->setCombination(QP_COMBINATION_AND);
        $query_parser->parse();
        if (!$query_parser->validate()) {
            ilLoggerFactory::getLogger('trac')->notice($query_parser->getMessage());
            // echo $query_parser->getMessage();
            return false;
        }

        if ($filter["type"] == "lres") {
            $filter["type"] = array('lm','sahs','htlm');
        } else {
            $filter["type"] = array($filter["type"]);
        }

        include_once 'Services/Search/classes/Like/class.ilLikeObjectSearch.php';
        $object_search = new ilLikeObjectSearch($query_parser);
        $object_search->setFilter($filter["type"]);
        if ($preset_obj_ids) {
            $object_search->setIdFilter($preset_obj_ids);
        }
        $res = &$object_search->performSearch();

        if ($permission) {
            $res->setRequiredPermission($permission);
        }

        $res->setMaxHits(1000);
        
        if ($a_check_lp_activation) {
            $res->addObserver($this, "searchFilterListener");
        }
        
        if (!$this->filter["area"]) {
            $res->filter(ROOT_FOLDER_ID, false);
        } else {
            $res->filter($this->filter["area"], false);
        }

        $objects = array();
        foreach ($res->getResults() as $obj_data) {
            $objects[$obj_data['obj_id']][] = $obj_data['ref_id'];
        }

        // Check if search max hits is reached
        if ($res->isLimitReached()) {
            $this->lng->loadLanguageModule("search");
            ilUtil::sendFailure(sprintf($this->lng->txt("search_limit_reached"), 1000));
        }

        return $objects ? $objects : array();
    }

    public function searchFilterListener($a_ref_id, $a_data)
    {
        if (is_array($this->filter["hide"]) && in_array($a_data["obj_id"], $this->filter["hide"])) {
            return false;
        }
        $olp = ilObjectLP::getInstance($a_data["obj_id"]);
        if (get_class($olp) != "ilObjectLP" && // #13654 - LP could be unsupported
            !$olp->isActive()) {
            return false;
        }
        return true;
    }
    
    public function initBaseFilter($a_split_learning_resources = false, $a_include_no_status_filter = true)
    {
        global $DIC;

        $lng = $DIC['lng'];
        $ilObjDataCache = $DIC['ilObjDataCache'];
        
        $this->setDisableFilterHiding(true);
        
        // object type selection
        include_once("./Services/Form/classes/class.ilSelectInputGUI.php");
        $si = new ilSelectInputGUI($this->lng->txt("obj_type"), "type");
        $si->setOptions($this->getPossibleTypes($a_split_learning_resources));
        $this->addFilterItem($si);
        $si->readFromSession();
        if (!$si->getValue()) {
            $si->setValue("crs");
        }
        $this->filter["type"] = $si->getValue();

        // hidden items
        include_once("./Services/Form/classes/class.ilMultiSelectInputGUI.php");
        $msi = new ilMultiSelectInputGUI($lng->txt("trac_filter_hidden"), "hide");
        $this->addFilterItem($msi);
        $msi->readFromSession();
        $this->filter["hide"] = $msi->getValue();
        if ($this->filter["hide"]) {
            // create options from current value
            $types = $this->getCurrentFilter(true);
            $type = $types["type"];
            $options = array();
            if ($type == 'lres') {
                $type = array('lm','sahs','htlm');
            } else {
                $type = array($type);
            }
            foreach ($this->filter["hide"] as $obj_id) {
                if (in_array($ilObjDataCache->lookupType($obj_id), $type)) {
                    $options[$obj_id] = $ilObjDataCache->lookupTitle($obj_id);
                }
            }
            $msi->setOptions($options);
        }

        // title/description
        include_once("./Services/Form/classes/class.ilTextInputGUI.php");
        $ti = new ilTextInputGUI($lng->txt("trac_title_description"), "query");
        $ti->setMaxLength(64);
        $ti->setSize(20);
        $this->addFilterItem($ti);
        $ti->readFromSession();
        $this->filter["query"] = $ti->getValue();
        
        // repository area selection
        include_once("./Services/Form/classes/class.ilRepositorySelectorInputGUI.php");
        $rs = new ilRepositorySelectorInputGUI($lng->txt("trac_filter_area"), "area");
        $rs->setSelectText($lng->txt("trac_select_area"));
        $this->addFilterItem($rs);
        $rs->readFromSession();
        $this->filter["area"] = $rs->getValue();
        
        // hide "not started yet"
        if ($a_include_no_status_filter) {
            include_once("./Services/Form/classes/class.ilCheckboxInputGUI.php");
            $cb = new ilCheckboxInputGUI($lng->txt("trac_filter_has_status"), "status");
            $this->addFilterItem($cb);
            $cb->readFromSession();
            $this->filter["status"] = $cb->getChecked();
        }
    }

    protected function buildPath($ref_ids)
    {
        global $DIC;

        $tree = $DIC['tree'];
        $ilCtrl = $DIC['ilCtrl'];

        include_once './Services/Link/classes/class.ilLink.php';
        
        if (!count($ref_ids)) {
            return false;
        }
        foreach ($ref_ids as $ref_id) {
            $path = "...";
            $counter = 0;
            $path_full = $tree->getPathFull($ref_id);
            foreach ($path_full as $data) {
                if (++$counter < (count($path_full) - 1)) {
                    continue;
                }
                $path .= " &raquo; ";
                if ($ref_id != $data['ref_id']) {
                    $path .= $data['title'];
                } else {
                    $path .= ('<a target="_top" href="' .
                              ilLink::_getLink($data['ref_id'], $data['type']) . '">' .
                              $data['title'] . '</a>');
                }
            }

            $result[$ref_id] = $path;
        }
        return $result;
    }

    protected function getPossibleTypes($a_split_learning_resources = false, $a_include_digilib = false, $a_allow_undefined_lp = false)
    {
        global $DIC;

        $lng = $DIC['lng'];
        $ilPluginAdmin = $DIC['ilPluginAdmin'];

        $options = array();

        if ($a_split_learning_resources) {
            $options['lm'] = $lng->txt('objs_lm');
            $options['sahs'] = $lng->txt('objs_sahs');
            $options['htlm'] = $lng->txt('objs_htlm');
        } else {
            $options['lres'] = $lng->txt('obj_lrss');
        }

        $options['crs'] = $lng->txt('objs_crs');
        $options['grp'] = $lng->txt('objs_grp');
        $options['exc'] = $lng->txt('objs_exc');
        $options['file'] = $lng->txt('objs_file');
        $options['mcst'] = $lng->txt('objs_mcst');
        $options['svy'] = $lng->txt('objs_svy');
        $options['tst'] = $lng->txt('objs_tst');
        $options['prg'] = $lng->txt('objs_prg');
        $options['iass'] = $lng->txt('objs_iass');
        $options['copa'] = $lng->txt('objs_copa');
        $options['cmix'] = $lng->txt('objs_cmix');
        $options['lti'] = $lng->txt('objs_lti');
        $options['lso'] = $lng->txt('objs_lso');

        if ($a_allow_undefined_lp) {
            $options["webr"] = $lng->txt("objs_webr");
            $options["wiki"] = $lng->txt("objs_wiki");
            $options["blog"] = $lng->txt("objs_blog");
            $options["prtf"] = $lng->txt("objs_prtf");
            $options["prtt"] = $lng->txt("objs_prtt");
        }
        
        // repository plugins (currently only active)
        include_once 'Services/Repository/classes/class.ilRepositoryObjectPluginSlot.php';
        $pl_names = $ilPluginAdmin->getActivePluginsForSlot(IL_COMP_SERVICE, "Repository", "robj");
        foreach ($pl_names as $pl) {
            $pl_id = $ilPluginAdmin->getId(IL_COMP_SERVICE, "Repository", "robj", $pl);
            if (ilRepositoryObjectPluginSlot::isTypePluginWithLP($pl_id)) {
                $options[$pl_id] = ilObjectPlugin::lookupTxtById($pl_id, "objs_" . $pl_id);
            }
        }
        
        asort($options);
        return $options;
    }

    protected function parseValue($id, $value, $type)
    {
        global $DIC;

        $lng = $DIC['lng'];

        // get rid of aggregation
        $pos = strrpos($id, "_");
        if ($pos !== false) {
            $function = strtoupper(substr($id, $pos + 1));
            if (in_array($function, array("MIN", "MAX", "SUM", "AVG", "COUNT"))) {
                $id = substr($id, 0, $pos);
            }
        }

        if (trim($value) == "" && $id != "status") {
            if ($id == "title" &&
                get_class($this) != "ilTrObjectUsersPropsTableGUI" &&
                get_class($this) != "ilTrMatrixTableGUI") {
                return "--" . $lng->txt("none") . "--";
            }
            return " ";
        }

        switch ($id) {
            case "first_access":
            case "create_date":
            case 'status_changed':
                $value = ilDatePresentation::formatDate(new ilDateTime($value, IL_CAL_DATETIME));
                break;

            case "last_access":
                $value = ilDatePresentation::formatDate(new ilDateTime($value, IL_CAL_UNIX));
                break;

            case "birthday":
                $value = ilDatePresentation::formatDate(new ilDate($value, IL_CAL_DATE));
                break;

            case "spent_seconds":
                if (!ilObjectLP::supportsSpentSeconds($type)) {
                    $value = "-";
                } else {
                    $value = ilDatePresentation::secondsToString($value, ($value < 3600 ? true : false)); // #14858
                }
                break;

            case "percentage":
                if (false /* $this->isPercentageAvailable() */) {
                    $value = "-";
                } else {
                    $value = $value . "%";
                }
                break;

            case "mark":
                if (!ilObjectLP::supportsMark($type)) {
                    $value = "-";
                }
                break;

            case "gender":
                $value = $lng->txt("gender_" . $value);
                break;

            case "status":
                include_once("./Services/Tracking/classes/class.ilLearningProgressBaseGUI.php");
                $path = ilLearningProgressBaseGUI::_getImagePathForStatus($value);
                $text = ilLearningProgressBaseGUI::_getStatusText($value);
                $value = ilUtil::img($path, $text);
                break;

            case "language":
                $lng->loadLanguageModule("meta");
                $value = $lng->txt("meta_l_" . $value);
                break;

            case "sel_country":
                $value = $lng->txt("meta_c_" . $value);
                break;
        }

        return $value;
    }

    public function getCurrentFilter($as_query = false)
    {
        $result = array();
        foreach ((array) $this->filter as $id => $value) {
            $item = $this->getFilterItemByPostVar($id);
            switch ($id) {
                case "title":
                case "country":
                case "gender":
                case "city":
                case "language":
                case "login":
                case "firstname":
                case "lastname":
                case "mark":
                case "u_comment":
                case "institution":
                case "department":
                case "title":
                case "street":
                case "zipcode":
                case "email":
                case "matriculation":
                case "sel_country":
                case "query":
                case "type":
                case "area":
                    if ($value) {
                        $result[$id] = $value;
                    }
                    break;

                case "status":
                    if ($value !== false) {
                        $result[$id] = $value;
                    }
                    break;

                case "user_total":
                case "read_count":
                case "percentage":
                case "hide":
                case "spent_seconds":
                    if (is_array($value) && implode("", $value)) {
                        $result[$id] = $value;
                    }
                    break;

                 case "registration":
                 case "create_date":
                 case "first_access":
                 case "last_access":
                 case 'status_changed':
                     if ($value) {
                         if ($value["from"]) {
                             $result[$id]["from"] = $value["from"]->get(IL_CAL_DATETIME);
                         }
                         if ($value["to"]) {
                             $result[$id]["to"] = $value["to"]->get(IL_CAL_DATETIME);
                         }
                     }
                     break;
                     
                 case "birthday":
                     if ($value) {
                         if ($value["from"]) {
                             $result[$id]["from"] = $value["from"]->get(IL_CAL_DATETIME);
                             $result[$id]["from"] = substr($result[$id]["from"], 0, -8) . "00:00:00";
                         }
                         if ($value["to"]) {
                             $result[$id]["to"] = $value["to"]->get(IL_CAL_DATETIME);
                             $result[$id]["to"] = substr($result[$id]["to"], 0, -8) . "23:59:59";
                         }
                     }
                     break;
          }
        }

        return $result;
    }

    protected function isPercentageAvailable($a_obj_id)
    {
        // :TODO:
        $olp = ilObjectLP::getInstance($a_obj_id);
        $mode = $olp->getCurrentMode();
        if (in_array($mode, array(ilLPObjSettings::LP_MODE_TLT,
            ilLPObjSettings::LP_MODE_VISITS,
            ilLPObjSettings::LP_MODE_SCORM,
            ilLPObjSettings::LP_MODE_LTI_OUTCOME,
            ilLPObjSettings::LP_MODE_CMIX_COMPLETED,
            ilLPObjSettings::LP_MODE_CMIX_COMPL_WITH_FAILED,
            ilLPObjSettings::LP_MODE_CMIX_PASSED,
            ilLPObjSettings::LP_MODE_CMIX_PASSED_WITH_FAILED,
            ilLPObjSettings::LP_MODE_CMIX_COMPLETED_OR_PASSED,
            ilLPObjSettings::LP_MODE_CMIX_COMPL_OR_PASSED_WITH_FAILED,
            ilLPObjSettings::LP_MODE_VISITED_PAGES,
            ilLPObjSettings::LP_MODE_TEST_PASSED))) {
            return true;
        }
        return false;
    }

    protected function parseTitle($a_obj_id, $action, $a_user_id = false)
    {
        global $DIC;

        $lng = $DIC['lng'];
        $ilObjDataCache = $DIC['ilObjDataCache'];
        $ilUser = $DIC['ilUser'];

        $user = "";
        if ($a_user_id) {
            if ($a_user_id != $ilUser->getId()) {
                $a_user = ilObjectFactory::getInstanceByObjId($a_user_id);
            } else {
                $a_user = $ilUser;
            }
            $user .= ", " . $a_user->getFullName(); // " [".$a_user->getLogin()."]";
        }

        if ($a_obj_id != ROOT_FOLDER_ID) {
            $this->setTitle($lng->txt($action) . ": " . $ilObjDataCache->lookupTitle($a_obj_id) . $user);
            
            $olp = ilObjectLP::getInstance($a_obj_id);
            $this->setDescription($this->lng->txt('trac_mode') . ": " . $olp->getModeText($olp->getCurrentMode()));
        } else {
            $this->setTitle($lng->txt($action));
        }
    }

    protected function getExportMeta()
    {
        global $DIC;

        $lng = $DIC['lng'];
        $ilObjDataCache = $DIC['ilObjDataCache'];
        $ilUser = $DIC['ilUser'];
        $ilClientIniFile = $DIC['ilClientIniFile'];

        /* see spec
            Name of installation
            Name of the course
            Permalink to course
            Owner of course object
            Date of report generation
            Reporting period
            Name of person who generated the report.
        */

        ilDatePresentation::setUseRelativeDates(false);
        include_once './Services/Link/classes/class.ilLink.php';
        
        $data = array();
        $data[$lng->txt("trac_name_of_installation")] = $ilClientIniFile->readVariable('client', 'name');
        
        if ($this->obj_id) {
            $data[$lng->txt("trac_object_name")] = $ilObjDataCache->lookupTitle($this->obj_id);
            if ($this->ref_id) {
                $data[$lng->txt("trac_object_link")] = ilLink::_getLink($this->ref_id, ilObject::_lookupType($this->obj_id));
            }
            $data[$lng->txt("trac_object_owner")] = ilObjUser::_lookupFullname(ilObject::_lookupOwner($this->obj_id));
        }
        
        $data[$lng->txt("trac_report_date")] = ilDatePresentation::formatDate(new ilDateTime(time(), IL_CAL_UNIX));
        $data[$lng->txt("trac_report_owner")] = $ilUser->getFullName();
        
        return $data;
    }

    protected function fillMetaExcel(ilExcel $a_excel, &$a_row)
    {
        foreach ($this->getExportMeta() as $caption => $value) {
            $a_excel->setCell($a_row, 0, $caption);
            $a_excel->setCell($a_row, 1, $value);
            $a_row++;
        }
        $a_row++;
    }
    
    protected function fillMetaCSV($a_csv)
    {
        foreach ($this->getExportMeta() as $caption => $value) {
            $a_csv->addColumn(strip_tags($caption));
            $a_csv->addColumn(strip_tags($value));
            $a_csv->addRow();
        }
        $a_csv->addRow();
    }

    protected function showTimingsWarning($a_ref_id, $a_user_id)
    {
        $timing_cache = ilTimingCache::getInstanceByRefId($a_ref_id);
        if ($timing_cache->isWarningRequired($a_user_id)) {
            $timings = ilTimingCache::_getTimings($a_ref_id);
            if ($timings['item']['changeable'] && $timings['user'][$a_user_id]['end']) {
                $end = $timings['user'][$a_user_id]['end'];
            } elseif ($timings['item']['suggestion_end']) {
                $end = $timings['item']['suggestion_end'];
            } else {
                $end = true;
            }
            return $end;
        }
    }
    
    protected function formatSeconds($seconds, $a_shorten_zero = false)
    {
        $seconds = ((int) $seconds > 0) ? $seconds : 0;
        if ($a_shorten_zero && !$seconds) {
            return "-";
        }
        
        $hours = floor($seconds / 3600);
        $rest = $seconds % 3600;
        
        $minutes = floor($rest / 60);
        $rest = $rest % 60;
        
        if ($rest) {
            $minutes++;
        }
        
        return sprintf("%dh%02dm", $hours, $minutes);
    }
    
    protected function anonymizeValue($a_value, $a_force_number = false)
    {
        // currently inactive
        return $a_value;
        
        if (is_numeric($a_value)) {
            $threshold = 3;
            $a_value = (int) $a_value;
            if ($a_value <= $threshold) {
                if (!$a_force_number) {
                    return "0-" . $threshold;
                } else {
                    return $threshold;
                }
            }
        }
        return $a_value;
    }
    
    protected function buildValueScale($a_max_value, $a_anonymize = false, $a_format_seconds = false)
    {
        $step = 0;
        if ($a_max_value) {
            $step = $a_max_value / 10;
            $base = ceil(log($step, 10));
            $fac = ceil($step / pow(10, ($base - 1)));
            $step = pow(10, $base - 1) * $fac;
        }
        if ($step <= 1) {
            $step = 1;
        }
        $ticks = range(0, $a_max_value + $step, $step);
        
        $value_ticks = array(0 => 0);
        foreach ($ticks as $tick) {
            $value = $tvalue = $tick;
            if ($a_anonymize) {
                $value = $this->anonymizeValue($value, true);
                $tvalue = $this->anonymizeValue($tvalue);
            }
            if ($a_format_seconds) {
                $tvalue = $this->formatSeconds($value);
            }
            $value_ticks[$value] = $tvalue;
        }
    
        return $value_ticks;
    }
    
    protected function getMonthsFilter($a_short = false)
    {
        global $DIC;

        $lng = $DIC['lng'];
        
        $options = array();
        for ($loop = 0; $loop < 10; $loop++) {
            $year = date("Y") - $loop;
            $options[$year] = $year;
            for ($loop2 = 12; $loop2 > 0; $loop2--) {
                $month = str_pad($loop2, 2, "0", STR_PAD_LEFT);
                if ($year . $month <= date("Ym")) {
                    if (!$a_short) {
                        $caption = $year . " / " . $lng->txt("month_" . $month . "_long");
                    } else {
                        $caption = $year . "/" . $month;
                    }
                    $options[$year . "-" . $month] = $caption;
                }
            }
        }
        return $options;
    }
    
    protected function getMonthsYear($a_year = null, $a_short = false)
    {
        global $DIC;

        $lng = $DIC['lng'];
        
        if (!$a_year) {
            $a_year = date("Y");
        }
        
        $all = array();
        for ($loop = 1; $loop < 13; $loop++) {
            $month = str_pad($loop, 2, "0", STR_PAD_LEFT);
            if ($a_year . "-" . $month <= date("Y-m")) {
                if (!$a_short) {
                    $caption = $lng->txt("month_" . $month . "_long");
                } else {
                    $caption = $lng->txt("month_" . $month . "_short");
                }
                $all[$a_year . "-" . $month] = $caption;
            }
        }
        return $all;
    }
        
    protected function getSelectableUserColumns($a_in_course = false, $a_in_group = false)
    {
        global $DIC;

        $lng = $DIC['lng'];
        $ilSetting = $DIC['ilSetting'];
        
        $cols = $privacy_fields = array();
        
        include_once("./Services/User/classes/class.ilUserProfile.php");
        $up = new ilUserProfile();
        $up->skipGroup("preferences");
        $up->skipGroup("settings");
        $up->skipGroup("interests");
        $ufs = $up->getStandardFields();

        // default fields
        $cols["login"] = array(
            "txt" => $lng->txt("login"),
            "default" => true);

        if (!$this->anonymized) {
            $cols["firstname"] = array(
                "txt" => $lng->txt("firstname"),
                "default" => true);
            $cols["lastname"] = array(
                "txt" => $lng->txt("lastname"),
                "default" => true);
        }

        // show only if extended data was activated in lp settings
        include_once 'Services/Tracking/classes/class.ilObjUserTracking.php';
        $tracking = new ilObjUserTracking();
        if ($tracking->hasExtendedData(ilObjUserTracking::EXTENDED_DATA_LAST_ACCESS)) {
            $cols["first_access"] = array(
                "txt" => $lng->txt("trac_first_access"),
                "default" => true);
            $cols["last_access"] = array(
                "txt" => $lng->txt("trac_last_access"),
                "default" => true);
        }
        if ($tracking->hasExtendedData(ilObjUserTracking::EXTENDED_DATA_READ_COUNT)) {
            $cols["read_count"] = array(
                "txt" => $lng->txt("trac_read_count"),
                "default" => true);
        }
        if ($tracking->hasExtendedData(ilObjUserTracking::EXTENDED_DATA_SPENT_SECONDS) &&
            ilObjectLP::supportsSpentSeconds($this->type)) {
            $cols["spent_seconds"] = array(
                "txt" => $lng->txt("trac_spent_seconds"),
                "default" => true);
        }

        if ($this->isPercentageAvailable($this->obj_id)) {
            $cols["percentage"] = array(
                "txt" => $lng->txt("trac_percentage"),
                "default" => true);
        }

        // do not show status if learning progress is deactivated
        $olp = ilObjectLP::getInstance($this->obj_id);
        if ($olp->isActive()) {
            $cols["status"] = array(
                "txt" => $lng->txt("trac_status"),
                "default" => true);

            $cols['status_changed'] = array(
                'txt' => $lng->txt('trac_status_changed'),
                'default' => false);
        }

        if (ilObjectLP::supportsMark($this->type)) {
            $cols["mark"] = array(
                "txt" => $lng->txt("trac_mark"),
                "default" => true);
        }

        $cols["u_comment"] = array(
            "txt" => $lng->txt("trac_comment"),
            "default" => false);

        $cols["create_date"] = array(
            "txt" => $lng->txt("create_date"),
            "default" => false);
        $cols["language"] = array(
            "txt" => $lng->txt("language"),
            "default" => false);

        // add user data only if object is [part of] course
        if (!$this->anonymized &&
            ($a_in_course || $a_in_group)) {
            // only show if export permission is granted
            include_once('Services/PrivacySecurity/classes/class.ilPrivacySettings.php');
            if (ilPrivacySettings::_getInstance()->checkExportAccess($this->ref_id)) {
                // other user profile fields
                foreach ($ufs as $f => $fd) {
                    if (!isset($cols[$f]) && $f != "username" && !$fd["lists_hide"]) {
                        if ($a_in_course &&
                            !($fd["course_export_fix_value"] || $ilSetting->get("usr_settings_course_export_" . $f))) {
                            continue;
                        }
                        if ($a_in_group &&
                            !($fd["group_export_fix_value"] || $ilSetting->get("usr_settings_group_export_" . $f))) {
                            continue;
                        }

                        $cols[$f] = array(
                            "txt" => $lng->txt($f),
                            "default" => false);

                        $privacy_fields[] = $f;
                    }
                }

                // additional defined user data fields
                include_once './Services/User/classes/class.ilUserDefinedFields.php';
                $user_defined_fields = ilUserDefinedFields::_getInstance();
                if ($a_in_course) {
                    $user_defined_fields = $user_defined_fields->getCourseExportableFields();
                } else {
                    $user_defined_fields = $user_defined_fields->getGroupExportableFields();
                }
                foreach ($user_defined_fields as $definition) {
                    if ($definition["field_type"] != UDF_TYPE_WYSIWYG) {
                        $f = "udf_" . $definition["field_id"];
                        $cols[$f] = array(
                                "txt" => $definition["field_name"],
                                "default" => false);

                        $privacy_fields[] = $f;
                    }
                }
            }
        }

        return array($cols, $privacy_fields);
    }
    
    protected function addToClipboard()
    {
        $users = (array) $_POST['uid'];
        include_once './Services/User/classes/class.ilUserClipboard.php';
        $clip = ilUserClipboard::getInstance($GLOBALS['DIC']['ilUser']->getId());
        $clip->add($users);
        $clip->save();
        
        $GLOBALS['DIC']['lng']->loadLanguageModule('user');
        ilUtil::sendSuccess($this->lng->txt('clipboard_user_added'), true);
    }
}