ilPRGAssignmentFilter Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilPRGAssignmentFilter:

Public Member Functions
	__construct (ilLanguage $lng)
	withValues (array $values)
	toConditions ()
	getItemConfig ()

Protected Member Functions
	getCleanedValues ()

Protected Attributes
ilLanguage	$lng
array	$values = []

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning

Definition at line 21 of file ilPRGAssignmentFilter.php.

Constructor & Destructor Documentation

__construct()

ilPRGAssignmentFilter::__construct

(

ilLanguage

$lng

)

Definition at line 26 of file ilPRGAssignmentFilter.php.

References $lng, and ILIAS\Repository\lng().

      {
        $this->lng = $lng;
    }

Here is the call graph for this function:

Member Function Documentation

getCleanedValues()

ilPRGAssignmentFilter::getCleanedValues ( )

protected

Definition at line 100 of file ilPRGAssignmentFilter.php.

References $id, $type, ilTable2GUI\FILTER_CHECKBOX, ilTable2GUI\FILTER_DATE_RANGE, ilTable2GUI\FILTER_SELECT, ilTable2GUI\FILTER_TEXT, getItemConfig(), and ilStudyProgrammeUserTable\OPTION_ALL.

Referenced by toConditions().

                                         : array
    {
        $ret = [];
        foreach ($this->getItemConfig() as list($id, $type, $options)) {
            if (array_key_exists($id, $this->values)) {
                if ($type === ilTable2GUI::FILTER_SELECT
                    && (
                        $this->values[$id] == ilStudyProgrammeUserTable::OPTION_ALL
                        || $this->values[$id] === false
                    )
                ) {
                    continue;
                }
                if ($type === ilTable2GUI::FILTER_TEXT
                    && $this->values[$id] == ''
                ) {
                    continue;
                }
                if ($type === ilTable2GUI::FILTER_CHECKBOX
                    && ($this->values[$id] == false || is_null($this->values[$id]))
                ) {
                    continue;
                }
                if ($type === ilTable2GUI::FILTER_DATE_RANGE
                    && $this->values[$id]['from'] == []
                    && $this->values[$id]['to'] == []
                ) {
                    continue;
                }
                $ret[$id] = $this->values[$id];
            }
        };
        return $ret;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getItemConfig()

ilPRGAssignmentFilter::getItemConfig

(

)

Returns

array <string $id, string $type, null | array $options>

Definition at line 138 of file ilPRGAssignmentFilter.php.

References ilTable2GUI\FILTER_CHECKBOX, ilTable2GUI\FILTER_DATE_RANGE, ilTable2GUI\FILTER_SELECT, ilTable2GUI\FILTER_TEXT, ILIAS\Repository\lng(), ilStudyProgrammeUserTable\OPTION_ALL, ilStudyProgrammeUserTable\OPTION_USR_ACTIVE, ilStudyProgrammeUserTable\OPTION_USR_INACTIVE, ilPRGAssignmentDBRepository\PROGRESS_FIELD_INVALIDATED, ilPRGAssignmentDBRepository\PROGRESS_FIELD_STATUS, ilPRGAssignmentDBRepository\PROGRESS_FIELD_VQ_DATE, ilPRGProgress\STATUS_ACCREDITED, ilPRGProgress\STATUS_COMPLETED, ilPRGProgress\STATUS_FAILED, ilPRGProgress\STATUS_IN_PROGRESS, ilPRGProgress\STATUS_NOT_RELEVANT, ilStudyProgrammeUserTable\VALIDITY_OPTION_INVALID, and ilStudyProgrammeUserTable\VALIDITY_OPTION_VALID.

Referenced by getCleanedValues().

                                   : array
    {
        $items = [];

        $items[] = [
            ilPRGAssignmentDBRepository::PROGRESS_FIELD_INVALIDATED, //invalidated
            ilTable2GUI::FILTER_SELECT,
            [
                ilStudyProgrammeUserTable::OPTION_ALL => $this->lng->txt("all"),
                ilStudyProgrammeUserTable::VALIDITY_OPTION_VALID => $this->lng->txt("prg_still_valid"),
                ilStudyProgrammeUserTable::VALIDITY_OPTION_INVALID => $this->lng->txt("prg_not_valid")
            ],
            $this->lng->txt('prg_validity')
        ];

        $items[] = [
            ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS, //status
            ilTable2GUI::FILTER_SELECT,
            [
                ilStudyProgrammeUserTable::OPTION_ALL => $this->lng->txt("all"),
                ilPRGProgress::STATUS_IN_PROGRESS => $this->lng->txt("prg_status_in_progress"),
                ilPRGProgress::STATUS_COMPLETED => $this->lng->txt("prg_status_completed"),
                ilPRGProgress::STATUS_ACCREDITED => $this->lng->txt("prg_status_accredited"),
                ilPRGProgress::STATUS_NOT_RELEVANT => $this->lng->txt("prg_status_not_relevant"),
                ilPRGProgress::STATUS_FAILED => $this->lng->txt("prg_status_failed")
            ],
            ''
        ];

        $items[] = ['prg_status_hide_irrelevant', ilTable2GUI::FILTER_CHECKBOX, null, ''];

        $items[] = [
             'usr_active',
             ilTable2GUI::FILTER_SELECT,
             [
                ilStudyProgrammeUserTable::OPTION_ALL => $this->lng->txt("all"),
                ilStudyProgrammeUserTable::OPTION_USR_ACTIVE => $this->lng->txt("active_only"),
                ilStudyProgrammeUserTable::OPTION_USR_INACTIVE => $this->lng->txt("inactive_only")
             ],
             ''
        ];

        $items[] = ['name', ilTable2GUI::FILTER_TEXT, null, ''];

        $items[] = [
            ilPRGAssignmentDBRepository::PROGRESS_FIELD_VQ_DATE, //vq_date
            ilTable2GUI::FILTER_DATE_RANGE,
            null,
            ''
        ];

        return $items;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

toConditions()

ilPRGAssignmentFilter::toConditions

(

)

Definition at line 39 of file ilPRGAssignmentFilter.php.

References getCleanedValues(), IL_CAL_DATE, ilStudyProgrammeUserTable\OPTION_USR_ACTIVE, ilStudyProgrammeUserTable\OPTION_USR_INACTIVE, ilPRGAssignmentDBRepository\PROGRESS_FIELD_INVALIDATED, ilPRGAssignmentDBRepository\PROGRESS_FIELD_STATUS, ilPRGProgress\STATUS_ACCREDITED, ilPRGProgress\STATUS_COMPLETED, ilPRGProgress\STATUS_NOT_RELEVANT, ilStudyProgrammeUserTable\VALIDITY_OPTION_INVALID, and ilStudyProgrammeUserTable\VALIDITY_OPTION_VALID.

                                  : array
    {
        $conditions = [];
        foreach ($this->getCleanedValues() as $field => $value) {
            switch ($field) {
                case 'status':
                    if ($value) {
                        $conditions[] = ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS . '=' . $value;
                    }
                    break;
                case 'prg_status_hide_irrelevant':
                    $conditions[] = ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS . '<>' . ilPRGProgress::STATUS_NOT_RELEVANT;
                    break;
                case 'name':
                    $conditions[] = '('
                        . 'memberdata.firstname LIKE \'%' . $value . '%\' OR' . PHP_EOL
                        . 'memberdata.lastname LIKE \'%' . $value . '%\' OR' . PHP_EOL
                        . 'memberdata.login LIKE \'%' . $value . '%\'' . PHP_EOL
                        . ')';
                    break;
                case 'invalidated':
                    if ((int) $value == ilStudyProgrammeUserTable::VALIDITY_OPTION_INVALID) {
                        $conditions[] = ilPRGAssignmentDBRepository::PROGRESS_FIELD_INVALIDATED . ' = 1';
                    }
                    if ((int) $value == ilStudyProgrammeUserTable::VALIDITY_OPTION_VALID) {
                        $conditions[] = ilPRGAssignmentDBRepository::PROGRESS_FIELD_INVALIDATED . ' = 0';
                        $conditions[] = '('
                            . ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS . '=' . ilPRGProgress::STATUS_COMPLETED
                            . ' OR '
                            . ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS . '=' . ilPRGProgress::STATUS_ACCREDITED
                        . ')';
                    }
                    break;

                case 'usr_active':
                    if ((int) $value === ilStudyProgrammeUserTable::OPTION_USR_ACTIVE) {
                        $conditions[] = 'memberdata.active = 1';
                    }
                    if ((int) $value === ilStudyProgrammeUserTable::OPTION_USR_INACTIVE) {
                        $conditions[] = 'memberdata.active = 0';
                    }
                    break;
                case 'vq_date':
                    list($from, $to) = array_values($value);
                    if ($from) {
                        $from = $from->get(IL_CAL_DATE);
                        $conditions[] = 'vq_date >= \'' . $from . ' 00:00:00\'';
                    }
                    if ($to) {
                        $to = $to->get(IL_CAL_DATE);
                        $conditions[] = 'vq_date <= \'' . $to . ' 23:59:59\'';
                    }
                    break;

                default:
                    throw new ilException("missing field in filter (to condition): " . $field, 1);
            }
        }
        return $conditions;
    }

Here is the call graph for this function:

withValues()

ilPRGAssignmentFilter::withValues

(

array

$values

)

Definition at line 32 of file ilPRGAssignmentFilter.php.

References $values.

                                             : self
    {
        $clone = clone $this;
        $clone->values = $values;
        return $clone;
    }

Field Documentation

$lng

ilLanguage ilPRGAssignmentFilter::$lng

protected

Definition at line 23 of file ilPRGAssignmentFilter.php.

Referenced by __construct().

$values

array ilPRGAssignmentFilter::$values = []

protected

Definition at line 24 of file ilPRGAssignmentFilter.php.

Referenced by withValues().

---

The documentation for this class was generated from the following file:

• Modules/StudyProgramme/classes/model/Assignments/ilPRGAssignmentFilter.php