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

Inheritance diagram for ilIndividualAssessmentMembersStorageDB:

Collaboration diagram for ilIndividualAssessmentMembersStorageDB:

Public Member Functions

__construct (ilDBInterface $ilDB)

loadMembers (ilObjIndividualAssessment $obj)

Get ilIndividualAssessmentMembers-object containing member info associated with $obj. More...

loadMembersAsSingleObjects (ilObjIndividualAssessment $obj, string $filter=null, string $sort=null)

Get ilIndividualAssessmentMember-object for each obj member associated with $obj.

Returns: ilIndividualAssessmentMember[]

More...

loadMember (ilObjIndividualAssessment $obj, ilObjUser $usr)

Get ilIndividualAssessmentMember-object containing member info associated with $obj and $usr. More...

updateMember (ilIndividualAssessmentMember $member)

Create a new storage entry for member-object. More...

deleteMembers (ilObjIndividualAssessment $obj)

Delete entries associated with members-object. More...

insertMembersRecord (ilObjIndividualAssessment $iass, array $record)

Create a membership inside storage.

Parameters

string[] | int[] $record

More...

removeMembersRecord (ilObjIndividualAssessment $iass, array $record)

Remove a membership associated with a IndividualAssessment object inside storage.

Parameters

string[] | int[] $record

More...

loadMembers (ilObjIndividualAssessment $obj)

Get ilIndividualAssessmentMembers-object containing member info associated with $obj. More...

loadMembersAsSingleObjects (ilObjIndividualAssessment $obj, string $filter=null, string $sort=null)

Get ilIndividualAssessmentMember-object for each obj member associated with $obj. More...

loadMember (ilObjIndividualAssessment $obj, ilObjUser $usr)

Get ilIndividualAssessmentMember-object containing member info associated with $obj and $usr. More...

updateMember (ilIndividualAssessmentMember $member)

Create a new storage entry for member-object. More...

deleteMembers (ilObjIndividualAssessment $obj)

Delete entries associated with members-object. More...

insertMembersRecord (ilObjIndividualAssessment $iass, array $record)

Create a membership inside storage. More...

removeMembersRecord (ilObjIndividualAssessment $iass, array $record)

Remove a membership associated with a IndividualAssessment object inside storage. More...

Data Fields
const	MEMBERS_TABLE = "iass_members"

Protected Member Functions
	createAssessmentMember (ilObjIndividualAssessment $obj, ilObjUser $usr, array $record)

	createGrading (array $record, string $user_fullname)

	getActualDateTime ()

	loadMemberQuery ()

	loadMembersQuery (int $obj_id)

	getWhereFromFilter ($filter)

	getOrderByFromSort (string $sort)

Protected Attributes
ilDBInterface	$db

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 Store member infos to DB

Definition at line 24 of file class.ilIndividualAssessmentMembersStorageDB.php.

Constructor & Destructor Documentation

◆ __construct()

ilIndividualAssessmentMembersStorageDB::__construct ( ilDBInterface $ilDB )

Definition at line 30 of file class.ilIndividualAssessmentMembersStorageDB.php.

    {
        $this->db = $ilDB;
    }

References $ilDB.

Member Function Documentation

◆ createAssessmentMember()

ilIndividualAssessmentMembersStorageDB::createAssessmentMember	(	ilObjIndividualAssessment	$obj,
		ilObjUser	$usr,
		array	$record
	)

protected

Definition at line 96 of file class.ilIndividualAssessmentMembersStorageDB.php.

     : ilIndividualAssessmentMember {
        $changer_id = $record[ilIndividualAssessmentMembers::FIELD_CHANGER_ID];
        if (!is_null($changer_id)) {
            $changer_id = (int) $changer_id;
        }
        $change_time = null;
        $change_time_db = $record[ilIndividualAssessmentMembers::FIELD_CHANGE_TIME];
        if (!is_null($change_time_db)) {
            $change_time = new DateTimeImmutable($change_time_db);
        }
        $examiner_id = $record[ilIndividualAssessmentMembers::FIELD_EXAMINER_ID];
        if (!is_null($examiner_id)) {
            $examiner_id = (int) $examiner_id;
        }
        return new ilIndividualAssessmentMember(
            $obj,
            $usr,
            $this->createGrading($record, $usr->getFullname()),
            (int) $record[ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS],
            $examiner_id,
            $changer_id,
            $change_time
        );
    }

References ILIAS\Repository\int().

Here is the call graph for this function:

◆ createGrading()

ilIndividualAssessmentMembersStorageDB::createGrading	(	array	$record,
		string	$user_fullname
	)

protected

Definition at line 125 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                                          : ilIndividualAssessmentUserGrading
    {
        $event_time = null;
        $event_time_db = $record[ilIndividualAssessmentMembers::FIELD_EVENTTIME];
        if (!is_null($event_time_db)) {
            $event_time = new DateTimeImmutable();
            $event_time = $event_time->setTimestamp((int) $event_time_db);
        }
        return new ilIndividualAssessmentUserGrading(
            $user_fullname,
            (string) $record[ilIndividualAssessmentMembers::FIELD_RECORD],
            (string) $record[ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE],
            (string) $record[ilIndividualAssessmentMembers::FIELD_FILE_NAME],
            (bool) $record[ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE],
            (int) $record[ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS],
            (string) $record[ilIndividualAssessmentMembers::FIELD_PLACE],
            $event_time,
            (bool) $record[ilIndividualAssessmentMembers::FIELD_NOTIFY],
            (bool) $record[ilIndividualAssessmentMembers::FIELD_FINALIZED]
        );
    }

References ilIndividualAssessmentMembers\FIELD_EVENTTIME, ilIndividualAssessmentMembers\FIELD_FILE_NAME, ilIndividualAssessmentMembers\FIELD_FINALIZED, ilIndividualAssessmentMembers\FIELD_INTERNAL_NOTE, ilIndividualAssessmentMembers\FIELD_LEARNING_PROGRESS, ilIndividualAssessmentMembers\FIELD_NOTIFY, ilIndividualAssessmentMembers\FIELD_PLACE, ilIndividualAssessmentMembers\FIELD_RECORD, and ilIndividualAssessmentMembers\FIELD_USER_VIEW_FILE.

◆ deleteMembers()

ilIndividualAssessmentMembersStorageDB::deleteMembers ( ilObjIndividualAssessment $obj )

Delete entries associated with members-object.

Implements ilIndividualAssessmentMembersStorage.

Definition at line 189 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                                 : void
    {
        $sql = "DELETE FROM " . self::MEMBERS_TABLE . " WHERE obj_id = " . $this->db->quote($obj->getId(), 'integer');
        $this->db->manipulate($sql);
    }

References ilObject\getId().

Here is the call graph for this function:

◆ getActualDateTime()

ilIndividualAssessmentMembersStorageDB::getActualDateTime ( )

protected

Reimplemented in ilIndividualAssessmentMembersStorageDBWrapper.

Definition at line 181 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                          : string
    {
        return date("Y-m-d H:i:s");
    }

◆ getOrderByFromSort()

ilIndividualAssessmentMembersStorageDB::getOrderByFromSort ( string $sort )

protected

Definition at line 373 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                       : string
    {
        $vals = explode(":", $sort);
 
        return " ORDER BY " . $vals[0] . " " . $vals[1];
    }

◆ getWhereFromFilter()

ilIndividualAssessmentMembersStorageDB::getWhereFromFilter ( $filter )

protected

Parameters

string | int $filter

Definition at line 357 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                  : string
    {
        switch ($filter) {
            case ilIndividualAssessmentMembers::LP_ASSESSMENT_NOT_COMPLETED:
                return "      AND finalized = 0 AND examiner_id IS NULL\n";
            case ilIndividualAssessmentMembers::LP_IN_PROGRESS:
                return "      AND finalized = 0 AND examiner_id IS NOT NULL\n";
            case ilIndividualAssessmentMembers::LP_COMPLETED:
                return "      AND finalized = 1 AND learning_progress = 2\n";
            case ilIndividualAssessmentMembers::LP_FAILED:
                return "      AND finalized = 1 AND learning_progress = 3\n";
            default:
                return "";
        }
    }

References ilIndividualAssessmentMembers\LP_ASSESSMENT_NOT_COMPLETED, ilIndividualAssessmentMembers\LP_COMPLETED, ilIndividualAssessmentMembers\LP_FAILED, and ilIndividualAssessmentMembers\LP_IN_PROGRESS.

◆ insertMembersRecord()

ilIndividualAssessmentMembersStorageDB::insertMembersRecord	(	ilObjIndividualAssessment	$iass,
		array	$record
	)

Create a membership inside storage.

Parameters

string[] | int[] $record

Implements ilIndividualAssessmentMembersStorage.

Definition at line 244 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                                                       : void
    {
        $values = [
            "obj_id" => [
                "integer",
                $iass->getId()
            ],
            "usr_id" => [
                "integer",
                $record[ilIndividualAssessmentMembers::FIELD_USR_ID]
            ],
            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => [
                "text",
                $record[ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS]
            ],
            ilIndividualAssessmentMembers::FIELD_NOTIFY => [
                "integer",
                $record[ilIndividualAssessmentMembers::FIELD_NOTIFY] ?? 0
            ],
            ilIndividualAssessmentMembers::FIELD_FINALIZED => [
                "integer",
                0
            ],
            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => [
                "integer",
                -1
            ]
        ];
 
        if (isset($record[ilIndividualAssessmentMembers::FIELD_EXAMINER_ID])) {
            $values[ilIndividualAssessmentMembers::FIELD_EXAMINER_ID] =
                [
                    "integer",
                    $record[ilIndividualAssessmentMembers::FIELD_EXAMINER_ID]
                ];
        }
        if (isset($record[ilIndividualAssessmentMembers::FIELD_RECORD])) {
            $values[ilIndividualAssessmentMembers::FIELD_RECORD] =
                [
                    "text",
                    $record[ilIndividualAssessmentMembers::FIELD_RECORD]
                ];
        }
        if (isset($record[ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE])) {
            $values[ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE] =
                [
                    "text",
                    $record[ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE]
                ];
        }
        if (isset($record[ilIndividualAssessmentMembers::FIELD_PLACE])) {
            $values[ilIndividualAssessmentMembers::FIELD_PLACE] =
                [
                    "text",
                    $record[ilIndividualAssessmentMembers::FIELD_PLACE]
                ];
        }
        if (isset($record[ilIndividualAssessmentMembers::FIELD_EVENTTIME])) {
            $values[ilIndividualAssessmentMembers::FIELD_EVENTTIME] =
                [
                    "integer",
                    $record[ilIndividualAssessmentMembers::FIELD_EVENTTIME]
                ];
        }
        if (isset($record[ilIndividualAssessmentMembers::FIELD_FILE_NAME])) {
            $values[ilIndividualAssessmentMembers::FIELD_FILE_NAME] =
                [
                    "text",
                    $record[ilIndividualAssessmentMembers::FIELD_FILE_NAME]
                ];
        }
        if (isset($record[ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE])) {
            $values[ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE] =
                [
                    "integer",
                    $record[ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE]
                ];
        }
        if (isset($record[ilIndividualAssessmentMembers::FIELD_CHANGER_ID])) {
            $values[ilIndividualAssessmentMembers::FIELD_CHANGER_ID] =
                [
                    "integer",
                    $record[ilIndividualAssessmentMembers::FIELD_CHANGER_ID]
                ];
        }
        if (isset($record[ilIndividualAssessmentMembers::FIELD_CHANGE_TIME])) {
            $values[ilIndividualAssessmentMembers::FIELD_CHANGE_TIME] =
                [
                    "text",
                    $record[ilIndividualAssessmentMembers::FIELD_CHANGE_TIME]
                ];
        }
 
        $this->db->insert(self::MEMBERS_TABLE, $values);
    }

Here is the call graph for this function:

◆ loadMember()

ilIndividualAssessmentMembersStorageDB::loadMember	(	ilObjIndividualAssessment	$obj,
		ilObjUser	$usr
	)

Get ilIndividualAssessmentMember-object containing member info associated with $obj and $usr.

Implements ilIndividualAssessmentMembersStorage.

Definition at line 80 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                                              : ilIndividualAssessmentMember
    {
        $obj_id = $obj->getId();
        $usr_id = $usr->getId();
        $sql = $this->loadMemberQuery();
        $sql .= "       WHERE obj_id = " . $this->db->quote($obj_id, 'integer') . "\n"
            . "         AND iassme.usr_id = " . $this->db->quote($usr_id, 'integer');
 
        $rec = $this->db->fetchAssoc($this->db->query($sql));
        if ($rec) {
            return $this->createAssessmentMember($obj, $usr, $rec);
        } else {
            throw new ilIndividualAssessmentException("invalid usr-obj combination");
        }
    }

References ilObject\getId().

Here is the call graph for this function:

◆ loadMemberQuery()

ilIndividualAssessmentMembersStorageDB::loadMemberQuery ( )

protected

Definition at line 195 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                        : string
    {
        return "SELECT "
            . "iassme.obj_id,"
            . "iassme.usr_id,"
            . "iassme.examiner_id,"
            . "iassme.record,"
            . "iassme.internal_note,"
            . "iassme.notify,"
            . "iassme.notification_ts,"
            . "iassme.learning_progress,"
            . "iassme.finalized,"
            . "iassme.place,"
            . "iassme.event_time,"
            . "iassme.user_view_file,"
            . "iassme.file_name,"
            . "iassme.changer_id,"
            . "iassme.change_time,"
            . "usr.login AS user_login,"
            . "ex.login AS examiner_login"
            . " FROM " . self::MEMBERS_TABLE . " iassme\n"
            . " JOIN usr_data usr ON iassme.usr_id = usr.usr_id\n"
            . " LEFT JOIN usr_data ex ON iassme.examiner_id = ex.usr_id\n"
        ;
    }

◆ loadMembers()

ilIndividualAssessmentMembersStorageDB::loadMembers ( ilObjIndividualAssessment $obj )

Get ilIndividualAssessmentMembers-object containing member info associated with $obj.

Implements ilIndividualAssessmentMembersStorage.

Definition at line 38 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                               : ilIndividualAssessmentMembers
    {
        $members = new ilIndividualAssessmentMembers($obj);
        $obj_id = $obj->getId();
        $sql = $this->loadMembersQuery($obj_id);
        $res = $this->db->query($sql);
        while ($rec = $this->db->fetchAssoc($res)) {
            $members = $members->withAdditionalRecord($rec);
        }
        return $members;
    }

References $res, ilObject\getId(), and loadMembersQuery().

Here is the call graph for this function:

◆ loadMembersAsSingleObjects()

ilIndividualAssessmentMembersStorageDB::loadMembersAsSingleObjects	(	ilObjIndividualAssessment	$obj,
		string	$filter = `null`,
		string	$sort = `null`
	)

Get ilIndividualAssessmentMember-object for each obj member associated with $obj.

Returns: ilIndividualAssessmentMember[]

Implements ilIndividualAssessmentMembersStorage.

Definition at line 53 of file class.ilIndividualAssessmentMembersStorageDB.php.

     : array {
        $members = [];
        $sql = $this->loadMemberQuery();
        $sql .= "       WHERE obj_id = " . $this->db->quote($obj->getId(), 'integer');
 
        if (!is_null($filter)) {
            $sql .= $this->getWhereFromFilter($filter);
        }
 
        if (!is_null($sort)) {
            $sql .= $this->getOrderByFromSort($sort);
        }
        $res = $this->db->query($sql);
        while ($rec = $this->db->fetchAssoc($res)) {
            $usr = new ilObjUser((int)$rec["usr_id"]);
            $members[] = $this->createAssessmentMember($obj, $usr, $rec);
        }
        return $members;
    }

◆ loadMembersQuery()

ilIndividualAssessmentMembersStorageDB::loadMembersQuery ( int $obj_id )

protected

Definition at line 221 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                    : string
    {
        return "SELECT ex.firstname as " . ilIndividualAssessmentMembers::FIELD_EXAMINER_FIRSTNAME
                . "     , ex.lastname as " . ilIndividualAssessmentMembers::FIELD_EXAMINER_LASTNAME
                . "     , ud.firstname as " . ilIndividualAssessmentMembers::FIELD_CHANGER_FIRSTNAME
                . "     , ud.lastname as " . ilIndividualAssessmentMembers::FIELD_CHANGER_LASTNAME
                . "     ,usr.firstname as " . ilIndividualAssessmentMembers::FIELD_FIRSTNAME
                . "     ,usr.lastname as " . ilIndividualAssessmentMembers::FIELD_LASTNAME
                . "     ,usr.login as " . ilIndividualAssessmentMembers::FIELD_LOGIN
                . "        ,iassme." . ilIndividualAssessmentMembers::FIELD_FILE_NAME
                . "     ,iassme.obj_id, iassme.usr_id, iassme.examiner_id, iassme.record, iassme.internal_note, iassme.notify"
                . "     ,iassme.notification_ts, iassme.learning_progress, iassme.finalized,iassme.place"
                . "     ,iassme.event_time, iassme.changer_id, iassme.change_time\n"
                . " FROM iass_members iassme"
                . " JOIN usr_data usr ON iassme.usr_id = usr.usr_id"
                . " LEFT JOIN usr_data ex ON iassme.examiner_id = ex.usr_id"
                . " LEFT JOIN usr_data ud ON iassme.changer_id = ud.usr_id"
                . " WHERE obj_id = " . $this->db->quote($obj_id, 'integer');
    }

References ilIndividualAssessmentMembers\FIELD_CHANGER_FIRSTNAME, ilIndividualAssessmentMembers\FIELD_CHANGER_LASTNAME, ilIndividualAssessmentMembers\FIELD_EXAMINER_FIRSTNAME, ilIndividualAssessmentMembers\FIELD_EXAMINER_LASTNAME, ilIndividualAssessmentMembers\FIELD_FILE_NAME, ilIndividualAssessmentMembers\FIELD_FIRSTNAME, ilIndividualAssessmentMembers\FIELD_LASTNAME, and ilIndividualAssessmentMembers\FIELD_LOGIN.

Referenced by loadMembers().

Here is the caller graph for this function:

◆ removeMembersRecord()

ilIndividualAssessmentMembersStorageDB::removeMembersRecord	(	ilObjIndividualAssessment	$iass,
		array	$record
	)

Remove a membership associated with a IndividualAssessment object inside storage.

Parameters

string[] | int[] $record

Implements ilIndividualAssessmentMembersStorage.

Definition at line 343 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                                                       : void
    {
        $sql =
             "DELETE FROM " . self::MEMBERS_TABLE . PHP_EOL
            . "WHERE obj_id = " . $this->db->quote($iass->getId(), 'integer') . PHP_EOL
            . "AND usr_id = " . $this->db->quote($record[ilIndividualAssessmentMembers::FIELD_USR_ID], 'integer') . PHP_EOL
        ;
 
        $this->db->manipulate($sql);
    }

References ilIndividualAssessmentMembers\FIELD_USR_ID, and ilObject\getId().

Here is the call graph for this function:

◆ updateMember()

ilIndividualAssessmentMembersStorageDB::updateMember ( ilIndividualAssessmentMember $member )

Create a new storage entry for member-object.

Implements ilIndividualAssessmentMembersStorage.

Definition at line 150 of file class.ilIndividualAssessmentMembersStorageDB.php.

                                                                      : void
    {
        $where = [
            "obj_id" => ["integer", $member->assessmentId()],
            "usr_id" => ["integer", $member->id()]
        ];
 
        $event_time = $member->eventTime();
        if (!is_null($event_time)) {
            $event_time = $event_time->getTimestamp();
        }
 
        $values = [
            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => ["text", $member->LPStatus()],
            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => ["integer", $member->examinerId() ?? "NULL"],
            ilIndividualAssessmentMembers::FIELD_RECORD => ["text", $member->record()],
            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => ["text", $member->internalNote()],
            ilIndividualAssessmentMembers::FIELD_PLACE => ["text", $member->place()],
            ilIndividualAssessmentMembers::FIELD_EVENTTIME => ["integer", $event_time],
            ilIndividualAssessmentMembers::FIELD_NOTIFY => ["integer", $member->notify()],
            ilIndividualAssessmentMembers::FIELD_FINALIZED => ["integer", $member->finalized()],
            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => ["integer", $member->notificationTS()],
            ilIndividualAssessmentMembers::FIELD_FILE_NAME => ["text", $member->fileName()],
            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => ["integer", $member->viewFile()],
            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => ["integer", $member->changerId()],
            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => ["string", $this->getActualDateTime()]
        ];
 
        $this->db->update(self::MEMBERS_TABLE, $values, $where);
    }

Here is the call graph for this function:

Field Documentation

◆ $db

ilDBInterface ilIndividualAssessmentMembersStorageDB::$db

protected

Definition at line 28 of file class.ilIndividualAssessmentMembersStorageDB.php.

◆ MEMBERS_TABLE

const ilIndividualAssessmentMembersStorageDB::MEMBERS_TABLE = "iass_members"

Definition at line 26 of file class.ilIndividualAssessmentMembersStorageDB.php.

Referenced by ilIndividualAssessmentMembersStorageDBTest\test_loadMember(), ilIndividualAssessmentMembersStorageDBTest\test_loadMember_exception(), and ilIndividualAssessmentMembersStorageDBTest\test_loadMembersAsSingleObjects().

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

Modules/IndividualAssessment/classes/Members/class.ilIndividualAssessmentMembersStorageDB.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ createAssessmentMember()

◆ createGrading()

◆ deleteMembers()

◆ getActualDateTime()

◆ getOrderByFromSort()

◆ getWhereFromFilter()

◆ insertMembersRecord()

◆ loadMember()

◆ loadMemberQuery()

◆ loadMembers()

◆ loadMembersAsSingleObjects()

◆ loadMembersQuery()

◆ removeMembersRecord()

◆ updateMember()

Field Documentation

◆ $db

◆ MEMBERS_TABLE