de/d21/ilIndividualAssessmentMembersStorageDBTest_8php_source.html

<?php


declare(strict_types=1);


use PHPUnit\Framework\TestCase;


class ilIndividualAssessmentMembersStorageDBWrapper extends ilIndividualAssessmentMembersStorageDB

{

    public function createAssessmentMemberWrapper(

        ilObjIndividualAssessment $obj,

        ilObjUser $usr,

        array $record

    ): ilIndividualAssessmentMember {

        return $this->createAssessmentMember($obj, $usr, $record);

    }


    // The access modifier is changed to public here to allow the actual test

    // to access this.

    public function getActualDateTime(): string

    {

        return "2021-12-02 12:55:33";

    }


    public function getWhereFromFilterWrapper($filter): string

    {

        return $this->getWhereFromFilter($filter);

    }


    public function getOrderByFromSortWrapper(string $sort): string

    {

        return $this->getOrderByFromSort($sort);

    }

}


class ilIndividualAssessmentMembersStorageDBTest extends TestCase

{

    public function testCreateObject(): void

    {

        $db = $this->createMock(ilDBInterface::class);

        $obj = new ilIndividualAssessmentMembersStorageDB($db);

        $this->assertInstanceOf(ilIndividualAssessmentMembersStorageDB::class, $obj);

    }


    public function test_loadMembers(): void

    {

        $sql = "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 = 22";


        $iass = $this->createMock(ilObjIndividualAssessment::class);

        $iass

            ->expects($this->once())

            ->method("getId")

            ->willReturn(22)

        ;


        $db_statement = $this->createMock(ilDBStatement::class);


        $db = $this->createMock(ilDBInterface::class);

        $db

            ->expects($this->once())

            ->method("quote")

            ->with(22, "integer")

            ->willReturn("22")

        ;

        $db

            ->expects($this->once())

            ->method("query")

            ->with($sql)

            ->willReturn($db_statement)

        ;

        $db

            ->expects($this->any())

            ->method("fetchAssoc")

            ->with($db_statement)

            ->willReturn(null)

        ;


        $obj = new ilIndividualAssessmentMembersStorageDB($db);

        $result = $obj->loadMembers($iass);

        $this->assertInstanceOf(ilIndividualAssessmentMembers::class, $result);

    }


    public function test_loadMembersAsSingleObjects(): void

    {

        $sql = "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 " . ilIndividualAssessmentMembersStorageDB::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"

            . " WHERE obj_id = 22"

        ;


        $iass = $this->createMock(ilObjIndividualAssessment::class);

        $iass

            ->expects($this->once())

            ->method("getId")

            ->willReturn(22)

        ;


        $db_statement = $this->createMock(ilDBStatement::class);


        $db = $this->createMock(ilDBInterface::class);

        $db

            ->expects($this->once())

            ->method("quote")

            ->with(22, "integer")

            ->willReturn("22")

        ;

        $db

            ->expects($this->once())

            ->method("query")

            ->with($sql)

            ->willReturn($db_statement)

        ;

        $db

            ->expects($this->once())

            ->method("fetchAssoc")

            ->with($db_statement)

            ->willReturn(null)

        ;


        $obj = new ilIndividualAssessmentMembersStorageDB($db);

        $result = $obj->loadMembersAsSingleObjects($iass);


        $this->assertIsArray($result);

        $this->assertEmpty($result);

    }


    public function test_loadMember_exception(): void

    {

        $sql = "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 " . ilIndividualAssessmentMembersStorageDB::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"

            . " WHERE obj_id = 22\n"

            . "         AND iassme.usr_id = 33"

        ;


        $iass = $this->createMock(ilObjIndividualAssessment::class);

        $iass

            ->expects($this->once())

            ->method("getId")

            ->willReturn(22)

        ;


        $usr = $this->createMock(ilObjUser::class);

        $usr

            ->expects($this->once())

            ->method("getId")

            ->willReturn(33)

        ;


        $db_statement = $this->createMock(ilDBStatement::class);


        $db = $this->createMock(ilDBInterface::class);

        $db

            ->expects($this->exactly(2))

            ->method("quote")

            ->withConsecutive([22, "integer"], [33, "integer"])

            ->willReturnOnConsecutiveCalls("22", "33")

        ;

        $db

            ->expects($this->once())

            ->method("query")

            ->with($sql)

            ->willReturn($db_statement)

        ;

        $db

            ->expects($this->once())

            ->method("fetchAssoc")

            ->with($db_statement)

            ->willReturn(null)

        ;


        $obj = new ilIndividualAssessmentMembersStorageDB($db);


        $this->expectException(ilIndividualAssessmentException::class);

        $this->expectExceptionMessage("invalid usr-obj combination");

        $obj->loadMember($iass, $usr);

    }


    public function test_loadMember(): void

    {

        $sql = "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 " . ilIndividualAssessmentMembersStorageDB::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"

            . " WHERE obj_id = 22\n"

            . "         AND iassme.usr_id = 33"

        ;


        $iass = $this->createMock(ilObjIndividualAssessment::class);

        $iass

            ->expects($this->once())

            ->method("getId")

            ->willReturn(22)

        ;


        $usr = $this->createMock(ilObjUser::class);

        $usr

            ->expects($this->once())

            ->method("getId")

            ->willReturn(33)

        ;


        $db_statement = $this->createMock(ilDBStatement::class);


        $db = $this->createMock(ilDBInterface::class);

        $db

            ->expects($this->exactly(2))

            ->method("quote")

            ->withConsecutive([22, "integer"], [33, "integer"])

            ->willReturnOnConsecutiveCalls("22", "33")

        ;

        $db

            ->expects($this->once())

            ->method("query")

            ->with($sql)

            ->willReturn($db_statement)

        ;

        $db

            ->expects($this->once())

            ->method("fetchAssoc")

            ->with($db_statement)

            ->willReturn(null)

        ;


        $obj = new ilIndividualAssessmentMembersStorageDB($db);


        $this->expectException(ilIndividualAssessmentException::class);

        $this->expectExceptionMessage("invalid usr-obj combination");

        $obj->loadMember($iass, $usr);

    }


    public function test_createAssessmentMember(): void

    {

        $iass = $this->createMock(ilObjIndividualAssessment::class);

        $usr = $this->createMock(ilObjUser::class);

        $usr

            ->expects($this->once())

            ->method("getFullname")

            ->willReturn("Full Name")

        ;


        $timestamp = 1638431626;


        $record = [

            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => 11,

            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => "2021-12-02",

            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => 22,

            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => $timestamp,

            ilIndividualAssessmentMembers::FIELD_EVENTTIME => $timestamp,

            ilIndividualAssessmentMembers::FIELD_RECORD => "record",

            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => "internal_note",

            ilIndividualAssessmentMembers::FIELD_FILE_NAME => "file_name",

            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => true,

            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => 33,

            ilIndividualAssessmentMembers::FIELD_PLACE => "place",

            ilIndividualAssessmentMembers::FIELD_NOTIFY => true,

            ilIndividualAssessmentMembers::FIELD_FINALIZED => true

        ];


        $db = $this->createMock(ilDBInterface::class);

        $obj = new ilIndividualAssessmentMembersStorageDBWrapper($db);


        $member = $obj->createAssessmentMemberWrapper($iass, $usr, $record);


        $this->assertEquals("Full Name", $member->getGrading()->getName());

        $this->assertEquals(11, $member->changerId());

        $this->assertEquals("2021-12-02", $member->changeTime()->format("Y-m-d"));

        $this->assertEquals(22, $member->examinerId());

        $this->assertEquals($timestamp, $member->notificationTS());

        $this->assertEquals($timestamp, $member->eventTime()->getTimestamp());

        $this->assertEquals("record", $member->record());

        $this->assertEquals("internal_note", $member->internalNote());

        $this->assertEquals("file_name", $member->fileName());

        $this->assertTrue($member->viewFile());

        $this->assertEquals(33, $member->LPStatus());

        $this->assertTrue($member->notify());

        $this->assertTrue($member->finalized());

    }


    public function test_updateMember(): void

    {

        $timestamp = 1638431626;

        $date = (new DateTimeImmutable())->setTimestamp($timestamp);


        $member = $this->createMock(ilIndividualAssessmentMember::class);

        $member

            ->expects($this->once())

            ->method("assessmentId")

            ->willReturn(11)

        ;

        $member

            ->expects($this->once())

            ->method("id")

            ->willReturn(22)

        ;

        $member

            ->expects($this->once())

            ->method("eventTime")

            ->willReturn($date)

        ;

        $member

            ->expects($this->once())

            ->method("LPStatus")

            ->willReturn(33)

        ;

        $member

            ->expects($this->once())

            ->method("examinerId")

            ->willReturn(44)

        ;

        $member

            ->expects($this->once())

            ->method("record")

            ->willReturn("record")

        ;

        $member

            ->expects($this->once())

            ->method("internalNote")

            ->willReturn("internalNote")

        ;

        $member

            ->expects($this->once())

            ->method("place")

            ->willReturn("place")

        ;

        $member

            ->expects($this->once())

            ->method("notify")

            ->willReturn(true)

        ;

        $member

            ->expects($this->once())

            ->method("finalized")

            ->willReturn(true)

        ;

        $member

            ->expects($this->once())

            ->method("notificationTS")

            ->willReturn($timestamp)

        ;

        $member

            ->expects($this->once())

            ->method("fileName")

            ->willReturn("fileName")

        ;

        $member

            ->expects($this->once())

            ->method("viewFile")

            ->willReturn(true)

        ;

        $member

            ->expects($this->once())

            ->method("changerId")

            ->willReturn(55)

        ;


        $db = $this->createMock(ilDBInterface::class);

        $obj = new ilIndividualAssessmentMembersStorageDBWrapper($db);


        $where = [

            "obj_id" => ["integer", 11],

            "usr_id" => ["integer", 22]

        ];


        $values = [

            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => ["text", 33],

            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => ["integer", 44],

            ilIndividualAssessmentMembers::FIELD_RECORD => ["text", "record"],

            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => ["text", "internalNote"],

            ilIndividualAssessmentMembers::FIELD_PLACE => ["text", "place"],

            ilIndividualAssessmentMembers::FIELD_EVENTTIME => ["integer", $timestamp],

            ilIndividualAssessmentMembers::FIELD_NOTIFY => ["integer", true],

            ilIndividualAssessmentMembers::FIELD_FINALIZED => ["integer", true],

            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => ["integer", $timestamp],

            ilIndividualAssessmentMembers::FIELD_FILE_NAME => ["text", "fileName"],

            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => ["integer", true],

            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => ["integer", 55],

            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => ["string", $obj->getActualDateTime()]

        ];


        $db

            ->expects($this->once())

            ->method("update")

            ->with("iass_members", $values, $where)

        ;


        $obj->updateMember($member);

    }


    public function test_deleteMembers(): void

    {

        $iass = $this->createMock(ilObjIndividualAssessment::class);

        $iass

            ->expects($this->once())

            ->method("getId")

            ->willReturn(22)

        ;


        $sql = "DELETE FROM iass_members WHERE obj_id = 22";


        $db = $this->createMock(ilDBInterface::class);

        $db

            ->expects($this->once())

            ->method("quote")

            ->with(22, "integer")

            ->willReturn("22")

        ;

        $db

            ->expects($this->once())

            ->method("manipulate")

            ->with($sql)

        ;


        $obj = new ilIndividualAssessmentMembersStorageDB($db);

        $obj->deleteMembers($iass);

    }


    public function test_insertMembersRecord(): void

    {

        $timestamp = 1638431626;


        $iass = $this->createMock(ilObjIndividualAssessment::class);

        $iass

            ->expects($this->once())

            ->method("getId")

            ->willReturn(11)

        ;


        $db = $this->createMock(ilDBInterface::class);

        $obj = new ilIndividualAssessmentMembersStorageDBWrapper($db);


        $record = [

            ilIndividualAssessmentMembers::FIELD_USR_ID => 22,

            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => 33,

            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => 44,

            ilIndividualAssessmentMembers::FIELD_RECORD => "record",

            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => "internalNote",

            ilIndividualAssessmentMembers::FIELD_PLACE => "place",

            ilIndividualAssessmentMembers::FIELD_EVENTTIME => $timestamp,

            ilIndividualAssessmentMembers::FIELD_NOTIFY => true,

            ilIndividualAssessmentMembers::FIELD_FINALIZED => 0,

            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => -1,

            ilIndividualAssessmentMembers::FIELD_FILE_NAME => "fileName",

            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => true,

            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => 55,

            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => $obj->getActualDateTime()

        ];


        $values = [

            "obj_id" => ["integer", 11],

            ilIndividualAssessmentMembers::FIELD_USR_ID => ["integer", 22],

            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => ["text", 33],

            ilIndividualAssessmentMembers::FIELD_NOTIFY => ["integer", true],

            ilIndividualAssessmentMembers::FIELD_FINALIZED => ["integer", 0],

            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => ["integer", -1],

            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => ["integer", 44],

            ilIndividualAssessmentMembers::FIELD_RECORD => ["text", "record"],

            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => ["text", "internalNote"],

            ilIndividualAssessmentMembers::FIELD_PLACE => ["text", "place"],

            ilIndividualAssessmentMembers::FIELD_EVENTTIME => ["integer", $timestamp],

            ilIndividualAssessmentMembers::FIELD_FILE_NAME => ["text", "fileName"],

            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => ["integer", true],

            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => ["integer", 55],

            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => ["text", $obj->getActualDateTime()]

        ];


        $db

            ->expects($this->once())

            ->method("insert")

            ->with("iass_members", $values)

        ;


        $obj->insertMembersRecord($iass, $record);

    }


    public function test_removeMembersRecord(): void

    {

        $iass = $this->createMock(ilObjIndividualAssessment::class);

        $iass

            ->expects($this->once())

            ->method("getId")

            ->willReturn(11)

        ;


        $record[ilIndividualAssessmentMembers::FIELD_USR_ID] = 22;


        $sql =

            "DELETE FROM iass_members" . PHP_EOL

            . "WHERE obj_id = 11" . PHP_EOL

            . "AND usr_id = 22" . PHP_EOL

        ;


        $db = $this->createMock(ilDBInterface::class);

        $db

            ->expects($this->exactly(2))

            ->method("quote")

            ->withConsecutive([11, "integer"], [22, "integer"])

            ->willReturnOnConsecutiveCalls("11", "22")

        ;

        $db

            ->expects($this->once())

            ->method("manipulate")

            ->with($sql)

        ;


        $obj = new ilIndividualAssessmentMembersStorageDB($db);

        $obj->removeMembersRecord($iass, $record);

    }


    public function dataFor_getWhereFromFilter(): array

    {

        return [

            [

                ilIndividualAssessmentMembers::LP_ASSESSMENT_NOT_COMPLETED,

                "      AND finalized = 0 AND examiner_id IS NULL\n"

            ],

            [

                ilIndividualAssessmentMembers::LP_IN_PROGRESS,

                "      AND finalized = 0 AND examiner_id IS NOT NULL\n"

            ],

            [

                ilIndividualAssessmentMembers::LP_COMPLETED,

                "      AND finalized = 1 AND learning_progress = 2\n"

            ],

            [

                ilIndividualAssessmentMembers::LP_FAILED,

                "      AND finalized = 1 AND learning_progress = 3\n"

            ],

            [

                "test",

                ""

            ]

        ];

    }


    public function test_getWhereFromFilter($filter, $result): void

    {

        $db = $this->createMock(ilDBInterface::class);

        $obj = new ilIndividualAssessmentMembersStorageDBWrapper($db);

        $res = $obj->getWhereFromFilterWrapper($filter);


        $this->assertEquals($result, $res);

    }


    public function test_getOrderByFromSort(): void

    {

        $db = $this->createMock(ilDBInterface::class);

        $obj = new ilIndividualAssessmentMembersStorageDBWrapper($db);


        $sort = "test:foo";


        $res = $obj->getOrderByFromSortWrapper($sort);


        $this->assertEquals(" ORDER BY test foo", $res);

    }

}

$timestamp
foreach($mandatory_scripts as $file) $timestamp
Definition: buildRTE.php:70

true
return true
Definition: class.ilIniFile.php:164

ilIndividualAssessmentMember
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
Definition: class.ilIndividualAssessmentMember.php:25

ilIndividualAssessmentMembersStorageDBTest
Definition: ilIndividualAssessmentMembersStorageDBTest.php:55

ilIndividualAssessmentMembersStorageDBTest\test_deleteMembers
test_deleteMembers()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:478

ilIndividualAssessmentMembersStorageDBTest\test_getOrderByFromSort
test_getOrderByFromSort()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:636

ilIndividualAssessmentMembersStorageDBTest\test_loadMembers
test_loadMembers()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:63

ilIndividualAssessmentMembersStorageDBTest\test_loadMember
test_loadMember()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:249

ilIndividualAssessmentMembersStorageDBTest\test_loadMember_exception
test_loadMember_exception()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:179

ilIndividualAssessmentMembersStorageDBTest\test_removeMembersRecord
test_removeMembersRecord()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:564

ilIndividualAssessmentMembersStorageDBTest\test_loadMembersAsSingleObjects
test_loadMembersAsSingleObjects()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:117

ilIndividualAssessmentMembersStorageDBTest\dataFor_getWhereFromFilter
dataFor_getWhereFromFilter()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:598

ilIndividualAssessmentMembersStorageDBTest\test_insertMembersRecord
test_insertMembersRecord()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:506

ilIndividualAssessmentMembersStorageDBTest\test_getWhereFromFilter
test_getWhereFromFilter($filter, $result)
@dataProvider dataFor_getWhereFromFilter
Definition: ilIndividualAssessmentMembersStorageDBTest.php:627

ilIndividualAssessmentMembersStorageDBTest\testCreateObject
testCreateObject()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:56

ilIndividualAssessmentMembersStorageDBTest\test_createAssessmentMember
test_createAssessmentMember()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:319

ilIndividualAssessmentMembersStorageDBTest\test_updateMember
test_updateMember()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:367

ilIndividualAssessmentMembersStorageDBWrapper
Definition: ilIndividualAssessmentMembersStorageDBTest.php:24

ilIndividualAssessmentMembersStorageDBWrapper\getWhereFromFilterWrapper
getWhereFromFilterWrapper($filter)
Definition: ilIndividualAssessmentMembersStorageDBTest.php:43

ilIndividualAssessmentMembersStorageDBWrapper\getActualDateTime
getActualDateTime()
Definition: ilIndividualAssessmentMembersStorageDBTest.php:35

ilIndividualAssessmentMembersStorageDBWrapper\createAssessmentMemberWrapper
createAssessmentMemberWrapper(ilObjIndividualAssessment $obj, ilObjUser $usr, array $record)
Definition: ilIndividualAssessmentMembersStorageDBTest.php:25

ilIndividualAssessmentMembersStorageDBWrapper\getOrderByFromSortWrapper
getOrderByFromSortWrapper(string $sort)
Definition: ilIndividualAssessmentMembersStorageDBTest.php:48

ilIndividualAssessmentMembersStorageDB
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
Definition: class.ilIndividualAssessmentMembersStorageDB.php:25

ilIndividualAssessmentMembersStorageDB\MEMBERS_TABLE
const MEMBERS_TABLE
Definition: class.ilIndividualAssessmentMembersStorageDB.php:26

ilIndividualAssessmentMembersStorageDB\createAssessmentMember
createAssessmentMember(ilObjIndividualAssessment $obj, ilObjUser $usr, array $record)
Definition: class.ilIndividualAssessmentMembersStorageDB.php:96

ilIndividualAssessmentMembers\FIELD_EVENTTIME
const FIELD_EVENTTIME
Definition: class.ilIndividualAssessmentMembers.php:45

ilIndividualAssessmentMembers\FIELD_USR_ID
const FIELD_USR_ID
Definition: class.ilIndividualAssessmentMembers.php:30

ilIndividualAssessmentMembers\FIELD_FILE_NAME
const FIELD_FILE_NAME
Definition: class.ilIndividualAssessmentMembers.php:46

ilIndividualAssessmentMembers\LP_COMPLETED
const LP_COMPLETED
Definition: class.ilIndividualAssessmentMembers.php:51

ilIndividualAssessmentMembers\FIELD_NOTIFY
const FIELD_NOTIFY
Definition: class.ilIndividualAssessmentMembers.php:41

ilIndividualAssessmentMembers\FIELD_CHANGE_TIME
const FIELD_CHANGE_TIME
Definition: class.ilIndividualAssessmentMembers.php:38

ilIndividualAssessmentMembers\FIELD_RECORD
const FIELD_RECORD
Definition: class.ilIndividualAssessmentMembers.php:39

ilIndividualAssessmentMembers\FIELD_EXAMINER_ID
const FIELD_EXAMINER_ID
Definition: class.ilIndividualAssessmentMembers.php:32

ilIndividualAssessmentMembers\FIELD_INTERNAL_NOTE
const FIELD_INTERNAL_NOTE
Definition: class.ilIndividualAssessmentMembers.php:40

ilIndividualAssessmentMembers\FIELD_CHANGER_LASTNAME
const FIELD_CHANGER_LASTNAME
Definition: class.ilIndividualAssessmentMembers.php:37

ilIndividualAssessmentMembers\FIELD_LOGIN
const FIELD_LOGIN
Definition: class.ilIndividualAssessmentMembers.php:29

ilIndividualAssessmentMembers\FIELD_USER_VIEW_FILE
const FIELD_USER_VIEW_FILE
Definition: class.ilIndividualAssessmentMembers.php:47

ilIndividualAssessmentMembers\LP_FAILED
const LP_FAILED
Definition: class.ilIndividualAssessmentMembers.php:52

ilIndividualAssessmentMembers\FIELD_CHANGER_FIRSTNAME
const FIELD_CHANGER_FIRSTNAME
Definition: class.ilIndividualAssessmentMembers.php:36

ilIndividualAssessmentMembers\LP_ASSESSMENT_NOT_COMPLETED
const LP_ASSESSMENT_NOT_COMPLETED
Definition: class.ilIndividualAssessmentMembers.php:53

ilIndividualAssessmentMembers\FIELD_EXAMINER_FIRSTNAME
const FIELD_EXAMINER_FIRSTNAME
Definition: class.ilIndividualAssessmentMembers.php:33

ilIndividualAssessmentMembers\FIELD_LASTNAME
const FIELD_LASTNAME
Definition: class.ilIndividualAssessmentMembers.php:28

ilIndividualAssessmentMembers\FIELD_NOTIFICATION_TS
const FIELD_NOTIFICATION_TS
Definition: class.ilIndividualAssessmentMembers.php:43

ilIndividualAssessmentMembers\FIELD_LEARNING_PROGRESS
const FIELD_LEARNING_PROGRESS
Definition: class.ilIndividualAssessmentMembers.php:31

ilIndividualAssessmentMembers\LP_IN_PROGRESS
const LP_IN_PROGRESS
Definition: class.ilIndividualAssessmentMembers.php:50

ilIndividualAssessmentMembers\FIELD_FINALIZED
const FIELD_FINALIZED
Definition: class.ilIndividualAssessmentMembers.php:42

ilIndividualAssessmentMembers\FIELD_FIRSTNAME
const FIELD_FIRSTNAME
Definition: class.ilIndividualAssessmentMembers.php:27

ilIndividualAssessmentMembers\FIELD_CHANGER_ID
const FIELD_CHANGER_ID
Definition: class.ilIndividualAssessmentMembers.php:35

ilIndividualAssessmentMembers\FIELD_PLACE
const FIELD_PLACE
Definition: class.ilIndividualAssessmentMembers.php:44

ilIndividualAssessmentMembers\FIELD_EXAMINER_LASTNAME
const FIELD_EXAMINER_LASTNAME
Definition: class.ilIndividualAssessmentMembers.php:34

ilObjIndividualAssessment
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
Definition: class.ilObjIndividualAssessment.php:27

ilObjUser
User class.
Definition: class.ilObjUser.php:28

return
return['3gp', '7z', 'ai', 'aif', 'aifc', 'aiff', 'au', 'arw', 'avi', 'backup', 'bak', 'bas', 'bpmn', 'bpmn2', 'bmp', 'bib', 'bibtex', 'bz', 'bz2', 'c', 'c++', 'cc', 'cct', 'cdf', 'cer', 'class', 'cls', 'conf', 'cpp', 'crt', 'crs', 'crw', 'cr2', 'css', 'cst', 'csv', 'cur', 'db', 'dcr', 'des', 'dng', 'doc', 'docx', 'dot', 'dotx', 'dtd', 'dvi', 'el', 'eps', 'epub', 'f', 'f77', 'f90', 'flv', 'for', 'g3', 'gif', 'gl', 'gan', 'ggb', 'gsd', 'gsm', 'gtar', 'gz', 'gzip', 'h', 'hpp', 'htm', 'html', 'htmls', 'ibooks', 'ico', 'ics', 'ini', 'ipynb', 'java', 'jbf', 'jpeg', 'jpg', 'js', 'jsf', 'jso', 'json', 'latex', 'lang', 'less', 'log', 'lsp', 'ltx', 'm1v', 'm2a', 'm2v', 'm3u', 'm4a', 'm4v', 'markdown', 'm', 'mat', 'md', 'mdl', 'mdown', 'mid', 'min', 'midi', 'mobi', 'mod', 'mov', 'movie', 'mp2', 'mp3', 'mp4', 'mpa', 'mpeg', 'mpg', 'mph', 'mpga', 'mpp', 'mpt', 'mpv', 'mpx', 'mv', 'mw', 'mv4', 'nb', 'nbp', 'nef', 'nif', 'niff', 'obj', 'obm', 'odt', 'ods', 'odp', 'odg', 'odf', 'oga', 'ogg', 'ogv', 'old', 'p', 'pas', 'pbm', 'pcl', 'pct', 'pcx', 'pdf', 'pgm', 'pic', 'pict', 'png', 'por', 'pov', 'project', 'properties', 'ppa', 'ppm', 'pps', 'ppsx', 'ppt', 'pptx', 'ppz', 'ps', 'psd', 'pwz', 'qt', 'qtc', 'qti', 'qtif', 'r', 'ra', 'ram', 'rar', 'rast', 'rda', 'rev', 'rexx', 'ris', 'rf', 'rgb', 'rm', 'rmd', 'rmi', 'rmm', 'rmp', 'rt', 'rtf', 'rtx', 'rv', 's', 's3m', 'sav', 'sbs', 'sec', 'sdml', 'sgm', 'sgml', 'smi', 'smil', 'srt', 'sps', 'spv', 'stl', 'svg', 'swa', 'swf', 'swz', 'tar', 'tex', 'texi', 'texinfo', 'text', 'tgz', 'tif', 'tiff', 'ttf', 'txt', 'tmp', 'uvproj', 'vdf', 'vimeo', 'viv', 'vivo', 'vrml', 'vsdx', 'wav', 'webm', 'wmv', 'wmx', 'wmz', 'woff', 'wwd', 'xhtml', 'xif', 'xls', 'xlsx', 'xmind', 'xml', 'xsl', 'xsd', 'zip']
Definition: default_whitelist.php:244

$res
$res
Definition: ltiservices.php:69