ilIndividualAssessmentMembersStorageDB Class Reference

Store member infos to DB . More...

Inheritance diagram for ilIndividualAssessmentMembersStorageDB:

Collaboration diagram for ilIndividualAssessmentMembersStorageDB:

Public Member Functions
	__construct ($ilDB)
	loadMembers (ilObjIndividualAssessment $obj)
	Get ilIndividualAssessmentMembers-object containing meberinfo associated with $obj. Parameters ilObjIndividualAssessment $obj Returns ilIndividualAssessmentMembers More...
	loadMember (ilObjIndividualAssessment $obj, ilObjUser $usr)
	Get ilIndividualAssessmentMember-object containing meberinfo associated with $obj and $usr. Parameters ilObjIndividualAssessment $obj ilObjUser $usr Returns ilIndividualAssessmentMember More...
	updateMember (ilIndividualAssessmentMember $member)
	Create a new storage entry for member-object. Parameters ilIndividualAssessmentMember $member More...
	deleteMembers (ilObjIndividualAssessment $obj)
	Delete entries associated with members-object. Parameters ilObjIndividualAssessment $obj More...
	insertMembersRecord (ilObjIndividualAssessment $iass, array $record)
	Create a membership inside storage. Parameters ilObjIndividualAssessment $iass string|int[] $record More...
	removeMembersRecord (ilObjIndividualAssessment $iass, array $record)
	Remove a membership associated with a IndividualAssessment object inside storage. Parameters ilObjIndividualAssessment $iass string|int[] $record More...

Protected Member Functions
	loadMembersQuery ($obj_id)

Protected Attributes
	$db

Detailed Description

Store member infos to DB .

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

Constructor & Destructor Documentation

__construct()

ilIndividualAssessmentMembersStorageDB::__construct

(

$ilDB

)

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

References $ilDB.

                                           {
                $this->db = $ilDB;
        }

Member Function Documentation

deleteMembers()

ilIndividualAssessmentMembersStorageDB::deleteMembers

(

ilObjIndividualAssessment

$obj

)

Delete entries associated with members-object.

Parameters

ilObjIndividualAssessment

$obj

Implements ilIndividualAssessmentMembersStorage.

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

References ilObject\getId().

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

Here is the call graph for this function:

insertMembersRecord()

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

Create a membership inside storage.

Parameters

ilObjIndividualAssessment	$iass
	string|int[]	$record

Implements ilIndividualAssessmentMembersStorage.

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

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

                                                                                            {
                $sql = 'INSERT INTO iass_members (obj_id,usr_id,record,learning_progress,notify) '
                                .'      VALUES ('
                                .'              '.$this->db->quote($iass->getId(),'integer')
                                .'              ,'.$this->db->quote($record[ilIndividualAssessmentMembers::FIELD_USR_ID],'integer')
                                .'              ,'.$this->db->quote($record[ilIndividualAssessmentMembers::FIELD_RECORD],'text')
                                .'              ,'.$this->db->quote($record[ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS],'integer')
                                .'              ,'.$this->db->quote(0,'integer')
                                .'      )';
                $this->db->manipulate($sql);
        }

Here is the call graph for this function:

loadMember()

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

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

Parameters

ilObjIndividualAssessment	$obj
ilObjUser	$usr

Returns

ilIndividualAssessmentMember

Implements ilIndividualAssessmentMembersStorage.

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

References ilObject\getId().

                                                                                   {
                $obj_id = $obj->getId();
                $usr_id = $usr->getId();
                $sql = 'SELECT iassme.*'
                                .' 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'
                                .'      WHERE obj_id = '.$this->db->quote($obj_id, 'integer')
                                .'              AND iassme.usr_id = '.$this->db->quote($usr_id,'integer');
                $rec = $this->db->fetchAssoc($this->db->query($sql));
                if($rec) {
                        $member = new ilIndividualAssessmentMember($obj, $usr, $rec);
                        return $member;
                } else {
                        throw new ilIndividualAssessmentException("invalid usr-obj combination");
                }
        }

Here is the call graph for this function:

loadMembers()

ilIndividualAssessmentMembersStorageDB::loadMembers

(

ilObjIndividualAssessment

$obj

)

Get ilIndividualAssessmentMembers-object containing meberinfo associated with $obj.

Parameters

ilObjIndividualAssessment

$obj

Returns

ilIndividualAssessmentMembers

Implements ilIndividualAssessmentMembersStorage.

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

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

                                                                    {
                $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;
        }

Here is the call graph for this function:

loadMembersQuery()

ilIndividualAssessmentMembersStorageDB::loadMembersQuery (   $obj_id )

protected

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

References ilIndividualAssessmentMembers\FIELD_EXAMINER_LASTNAME, ilIndividualAssessmentMembers\FIELD_FIRSTNAME, ilIndividualAssessmentMembers\FIELD_LASTNAME, and ilIndividualAssessmentMembers\FIELD_LOGIN.

Referenced by loadMembers().

                                                     {
                return 'SELECT ex.firstname as '.ilIndividualAssessmentMembers::FIELD_EXAMINER_FIRSTNAME
                                .'      , ex.lastname as '.ilIndividualAssessmentMembers::FIELD_EXAMINER_LASTNAME
                                .'      ,usr.firstname as '.ilIndividualAssessmentMembers::FIELD_FIRSTNAME
                                .'      ,usr.lastname as '.ilIndividualAssessmentMembers::FIELD_LASTNAME
                                .'      ,usr.login as '.ilIndividualAssessmentMembers::FIELD_LOGIN
                                .'      ,iassme.*'
                                .' 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'
                                .'      WHERE obj_id = '.$this->db->quote($obj_id, 'integer');
        }

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

ilObjIndividualAssessment	$iass
	string|int[]	$record

Implements ilIndividualAssessmentMembersStorage.

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

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

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

Here is the call graph for this function:

updateMember()

ilIndividualAssessmentMembersStorageDB::updateMember

(

ilIndividualAssessmentMember

$member

)

Create a new storage entry for member-object.

Parameters

ilIndividualAssessmentMember

$member

Implements ilIndividualAssessmentMembersStorage.

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

References ilIndividualAssessmentMember\assessmentId(), ilIndividualAssessmentMember\examinerId(), ilIndividualAssessmentMembers\FIELD_EXAMINER_ID, ilIndividualAssessmentMembers\FIELD_FINALIZED, ilIndividualAssessmentMembers\FIELD_INTERNAL_NOTE, ilIndividualAssessmentMembers\FIELD_LEARNING_PROGRESS, ilIndividualAssessmentMembers\FIELD_NOTIFICATION_TS, ilIndividualAssessmentMembers\FIELD_NOTIFY, ilIndividualAssessmentMembers\FIELD_RECORD, ilIndividualAssessmentMember\finalized(), ilIndividualAssessmentMember\id(), ilIndividualAssessmentMember\internalNote(), ilIndividualAssessmentMember\LPStatus(), ilIndividualAssessmentMember\notificationTS(), ilIndividualAssessmentMember\notify(), and ilIndividualAssessmentMember\record().

                                                                           {
                $sql = 'UPDATE iass_members SET '
                                .'      '.ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS.' = '.$this->db->quote($member->LPStatus(),'text')
                                .'      ,'.ilIndividualAssessmentMembers::FIELD_EXAMINER_ID.' = '.$this->db->quote($member->examinerId(),'integer')
                                .'      ,'.ilIndividualAssessmentMembers::FIELD_RECORD.' = '.$this->db->quote($member->record(),'text')
                                .'      ,'.ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE.' = '.$this->db->quote($member->internalNote(),'text')
                                .'      ,'.ilIndividualAssessmentMembers::FIELD_NOTIFY.' = '.$this->db->quote($member->notify() ? 1 : 0,'integer')
                                .'      ,'.ilIndividualAssessmentMembers::FIELD_FINALIZED.' = '.$this->db->quote($member->finalized() ? 1 : 0,'integer')
                                .'      ,'.ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS.' = '.$this->db->quote($member->notificationTS(),'integer')
                                .'      WHERE obj_id = '.$this->db->quote($member->assessmentId(),'integer')
                                .'              AND usr_id = '.$this->db->quote($member->id(),'integer');
                $this->db->manipulate($sql);
        }

Here is the call graph for this function:

Field Documentation

$db

ilIndividualAssessmentMembersStorageDB::$db

protected

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

---

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

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