ilStudyProgrammeAssignmentDBRepository Class Reference

Inheritance diagram for ilStudyProgrammeAssignmentDBRepository:

Collaboration diagram for ilStudyProgrammeAssignmentDBRepository:

Public Member Functions
	__construct (ilDBInterface $db)
	createFor (int $root_prg_id, int $usr_id, int $assigning_usr_id)
	Create a record corresponding to a SP-Object and return represending settings.Will throw if a record allready exists. More...
	get (int $id)
	Load settings belonging to a SP-Object.Will throw if the record does not exist yet. Returns ilStudyProgrammeAssignment | null More...
	getByUsrId (int $usr_id)
	Get all assignments of a user. More...
	getByPrgId (int $prg_id)
	Get all assignments to a prg. More...
	getByUsrIdAndPrgId (int $usr_id, int $prg_id)
	getDueToRestart ()
	Get all assignments due to restart and not restrted yet. Returns ilStudyProgrammeAssignment[] More...
	getDueToRestartAndMail ()
	getDueToManuelRestart (int $days_before_end)
	Get all assignments due to restart and not restrted yet. More...
	update (ilStudyProgrammeAssignment $assignment)
	Update settings belonging to a SP-Object.Will throw if the record does not exist yet. More...
	delete (ilStudyProgrammeAssignment $assignment)
	Delete record corresponding to settings.Will throw if the record does not exist yet. More...
	reminderSendFor (int $assignment_id)
	getDashboardInstancesforUser (int $usr_id)
	deleteAllAssignmentsForProgrammeId (int $prg_obj_id)
	getTableAndFieldOfAssignmentIds ()
	getInstanceById (int $id)
	Backport ilStudyProgrammeUserAssignmentDB More...
	getInstanceByModel (\ilStudyProgrammeAssignment $assignment)
	getInstancesOfUser (int $user_id)

Data Fields
const	TABLE = 'prg_usr_assignments'
const	FIELD_ID = 'id'
const	FIELD_USR_ID = 'usr_id'
const	FIELD_ROOT_PRG_ID = 'root_prg_id'
const	FIELD_LAST_CHANGE = 'last_change'
const	FIELD_LAST_CHANGE_BY = 'last_change_by'
const	FIELD_RESTART_DATE = 'restart_date'
const	FIELD_RESTARTED_ASSIGNMENT_ID = 'restarted_assignment_id'
const	FIELD_RESTART_MAIL = 'restart_mail_send'

Protected Member Functions
	loadDueToRestart ()
	loadDueToRestartAndMail ()
	getSQLHeader ()
	getDueToRestartBaseSQL ()
	loadDueToManuelRestart (int $days_before_end)
	assignmentByRow (array $row)
	loadByFilterDB (array $filter)
	insertRowDB (array $row)
	updatedRowDB (array $values)
	deleteDB (int $id)
	nextId ()

Protected Attributes
	$db

Detailed Description

Definition at line 3 of file class.ilStudyProgrammeAssignmentDBRepository.php.

Constructor & Destructor Documentation

__construct()

ilStudyProgrammeAssignmentDBRepository::__construct

(

ilDBInterface

$db

)

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

References $db.

    {
        $this->db = $db;
    }

Member Function Documentation

assignmentByRow()

ilStudyProgrammeAssignmentDBRepository::assignmentByRow ( array  $row )

protected

Exceptions

ilException

Definition at line 311 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References ilStudyProgrammeAssignment\DATE_TIME_FORMAT, and ilStudyProgrammeAssignment\withRootId().

Referenced by createFor(), get(), getByPrgId(), getByUsrId(), getByUsrIdAndPrgId(), getDashboardInstancesforUser(), getDueToManuelRestart(), getDueToRestart(), and getDueToRestartAndMail().

                                                   : ilStudyProgrammeAssignment
    {
        return (new ilStudyProgrammeAssignment((int) $row[self::FIELD_ID]))
            ->withRootId((int) $row[self::FIELD_ROOT_PRG_ID])
            ->withUserId((int) $row[self::FIELD_USR_ID])
            ->withLastChange(
                (int) $row[self::FIELD_LAST_CHANGE_BY],
                DateTimeImmutable::createFromFormat(
                    ilStudyProgrammeAssignment::DATE_TIME_FORMAT,
                    $row[self::FIELD_LAST_CHANGE]
                )
            )
            ->withRestarted(
                (int) $row[self::FIELD_RESTARTED_ASSIGNMENT_ID],
                $row[self::FIELD_RESTART_DATE] ?
                    DateTimeImmutable::createFromFormat(ilStudyProgrammeAssignment::DATE_TIME_FORMAT, $row[self::FIELD_RESTART_DATE]) :
                    null
            );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

createFor()

ilStudyProgrammeAssignmentDBRepository::createFor	(	int	$root_prg_id,
		int	$usr_id,
		int	$assigning_usr_id
	)

Create a record corresponding to a SP-Object and return represending settings.Will throw if a record allready exists.

Exceptions

ilException

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 31 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References ilObject\_lookupType(), assignmentByRow(), insertRowDB(), nextId(), ilStudyProgrammeAssignment\NO_RESTARTED_ASSIGNMENT, and ilUtil\now().

                                                                                    : ilStudyProgrammeAssignment
    {
        if (ilObject::_lookupType($usr_id) != "usr") {
            throw new ilException("ilStudyProgrammeAssignment::createFor: '$usr_id' "
                . "is no id of a user.");
        }
        if (ilObject::_lookupType($root_prg_id) != "prg") {
            throw new ilException("ilStudyProgrammeAssignment::createFor: '$root_prg_id' "
                . "is no id of a prg.");
        }

        $row = [
            self::FIELD_ID => $this->nextId(),
            self::FIELD_USR_ID => $usr_id,
            self::FIELD_ROOT_PRG_ID => $root_prg_id,
            self::FIELD_LAST_CHANGE_BY => $assigning_usr_id,
            self::FIELD_LAST_CHANGE => ilUtil::now(),
            self::FIELD_RESTART_DATE => null,
            self::FIELD_RESTARTED_ASSIGNMENT_ID => ilStudyProgrammeAssignment::NO_RESTARTED_ASSIGNMENT
        ];
        $this->insertRowDB($row);
        return $this->assignmentByRow($row);
    }

Here is the call graph for this function:

delete()

ilStudyProgrammeAssignmentDBRepository::delete

(

ilStudyProgrammeAssignment

$assignment

)

Delete record corresponding to settings.Will throw if the record does not exist yet.

Implements ilStudyProgrammeAssignmentRepository.

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

References deleteDB().

    {
        $this->deleteDB($assignment->getId());
    }

Here is the call graph for this function:

deleteAllAssignmentsForProgrammeId()

ilStudyProgrammeAssignmentDBRepository::deleteAllAssignmentsForProgrammeId

(

int

$prg_obj_id

)

Definition at line 392 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References $query.

                                                                        : void
    {
        $query = 'DELETE FROM ' . self::TABLE . PHP_EOL
            . 'WHERE ' . self::FIELD_ROOT_PRG_ID . '=' . $this->db->quote($prg_obj_id, 'integer');
        $this->db->manipulate($query);
    }

deleteDB()

ilStudyProgrammeAssignmentDBRepository::deleteDB ( int  $id )

protected

Definition at line 381 of file class.ilStudyProgrammeAssignmentDBRepository.php.

Referenced by delete().

    {
        $this->db->manipulate('DELETE FROM ' . self::TABLE . ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($id, 'integer'));
    }

Here is the caller graph for this function:

get()

ilStudyProgrammeAssignmentDBRepository::get

(

int

$id

)

Load settings belonging to a SP-Object.Will throw if the record does not exist yet.

Returns

ilStudyProgrammeAssignment | null

Exceptions

ilException

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 59 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References assignmentByRow(), and loadByFilterDB().

    {
        foreach ($this->loadByFilterDB([self::FIELD_ID => $id]) as $row) {
            return $this->assignmentByRow($row);
        }
        return null;
    }

Here is the call graph for this function:

getByPrgId()

ilStudyProgrammeAssignmentDBRepository::getByPrgId

(

int

$prg_id

)

Get all assignments to a prg.

Exceptions

ilException

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 84 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References assignmentByRow(), and loadByFilterDB().

                                            : array
    {
        $return = [];
        foreach ($this->loadByFilterDB([self::FIELD_ROOT_PRG_ID => $prg_id]) as $row) {
            $return[] = $this->assignmentByRow($row);
        }
        return $return;
    }

Here is the call graph for this function:

getByUsrId()

ilStudyProgrammeAssignmentDBRepository::getByUsrId

(

int

$usr_id

)

Get all assignments of a user.

Exceptions

ilException

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 71 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References assignmentByRow(), and loadByFilterDB().

Referenced by getInstancesOfUser().

                                            : array
    {
        $return = [];
        foreach ($this->loadByFilterDB([self::FIELD_USR_ID => $usr_id]) as $row) {
            $return[] = $this->assignmentByRow($row);
        }
        return $return;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getByUsrIdAndPrgId()

ilStudyProgrammeAssignmentDBRepository::getByUsrIdAndPrgId	(	int	$usr_id,
		int	$prg_id
	)

Exceptions

ilException

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

References assignmentByRow(), and loadByFilterDB().

    {
        $return = [];
        foreach ($this->loadByFilterDB(
            [self::FIELD_USR_ID => $usr_id
                , self::FIELD_ROOT_PRG_ID => $prg_id]
        ) as $row) {
            $return[] = $this->assignmentByRow($row);
        }
        return $return;
    }

Here is the call graph for this function:

getDashboardInstancesforUser()

ilStudyProgrammeAssignmentDBRepository::getDashboardInstancesforUser

(

int

$usr_id

)

Exceptions

ilException

Definition at line 271 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References $db, $DIC, $res, $ret, and assignmentByRow().

    {
        global $DIC;
        $db = $DIC['ilDB'];
        $q = 'SELECT ' . self::FIELD_ID
            . ', ' . self::FIELD_USR_ID
            . ', ' . self::FIELD_ROOT_PRG_ID
            . ', ' . self::FIELD_LAST_CHANGE
            . ', ' . self::FIELD_LAST_CHANGE_BY
            . ', ' . self::FIELD_RESTART_DATE
            . ', ' . self::FIELD_RESTARTED_ASSIGNMENT_ID
            . ' FROM ' . self::TABLE
            . ' WHERE ' . self::FIELD_USR_ID . ' = ' . $usr_id
            . ' ORDER BY ' . self::FIELD_ROOT_PRG_ID . ', ' . self::FIELD_ID
        ;
        $ret = [];
        $assignments = [];
        $res = $db->query($q);
        $prg = 0;
        while ($row = $db->fetchAssoc($res)) {
            if ($prg == 0) {
                $prg = $row['root_prg_id'];
            }
            if ($prg != $row['root_prg_id']) {
                $ret[$prg] = $assignments;
                $prg = $row['root_prg_id'];
                $assignments = [];
            }
            $assignments[(int) $row['id']] = $this->assignmentByRow($row);
        }
        if (count($assignments) > 0) {
            $ret[$prg] = $assignments;
        }

        return $ret;
    }

Here is the call graph for this function:

getDueToManuelRestart()

ilStudyProgrammeAssignmentDBRepository::getDueToManuelRestart

(

int

$days_before_end

)

Get all assignments due to restart and not restrted yet.

Exceptions

Exception

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 188 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References assignmentByRow(), and loadDueToManuelRestart().

                                                                : array
    {
        $return = [];
        foreach ($this->loadDueToManuelRestart($days_before_end) as $row) {
            $return[] = $this->assignmentByRow($row);
        }
        return $return;
    }

Here is the call graph for this function:

getDueToRestart()

ilStudyProgrammeAssignmentDBRepository::getDueToRestart

(

)

Get all assignments due to restart and not restrted yet.

Returns

ilStudyProgrammeAssignment[]

Exceptions

ilException

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 113 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References assignmentByRow(), and loadDueToRestart().

                                      : array
    {
        $return = [];
        foreach ($this->loadDueToRestart() as $row) {
            $return[] = $this->assignmentByRow($row);
        }
        return $return;
    }

Here is the call graph for this function:

getDueToRestartAndMail()

ilStudyProgrammeAssignmentDBRepository::getDueToRestartAndMail

(

)

Returns

ilStudyProgrammeAssignment[]

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

References assignmentByRow(), and loadDueToRestartAndMail().

                                             : array
    {
        $return = [];
        foreach ($this->loadDueToRestartAndMail() as $row) {
            $return[] = $this->assignmentByRow($row);
        }
        return $return;
    }

Here is the call graph for this function:

getDueToRestartBaseSQL()

ilStudyProgrammeAssignmentDBRepository::getDueToRestartBaseSQL ( )

protected

Definition at line 166 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References ilStudyProgrammeAssignment\DATE_FORMAT, getSQLHeader(), and ilStudyProgrammeAssignment\NO_RESTARTED_ASSIGNMENT.

Referenced by loadDueToRestart(), and loadDueToRestartAndMail().

                                                : string
    {
        return $this->getSQLHeader()
            . ' WHERE ' . self::FIELD_RESTARTED_ASSIGNMENT_ID
            . ' = ' . $this->db->quote(
                ilStudyProgrammeAssignment::NO_RESTARTED_ASSIGNMENT,
                'integer'
            ) . PHP_EOL
            . '    AND ' . self::FIELD_RESTART_DATE . ' IS NOT NULL' . PHP_EOL
            . '    AND DATE(' . self::FIELD_RESTART_DATE . ') <= '
            . $this->db->quote(
                (new DateTime())->format(
                    ilStudyProgrammeAssignment::DATE_FORMAT
                ),
                'text'
            );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getInstanceById()

ilStudyProgrammeAssignmentDBRepository::getInstanceById

(

int

$id

)

---

Backport ilStudyProgrammeUserAssignmentDB

Definition at line 411 of file class.ilStudyProgrammeAssignmentDBRepository.php.

    {
        return $this->get($id);
    }

getInstanceByModel()

ilStudyProgrammeAssignmentDBRepository::getInstanceByModel

(

\ilStudyProgrammeAssignment

$assignment

)

Definition at line 416 of file class.ilStudyProgrammeAssignmentDBRepository.php.

    {
        return $assignment;
    }

getInstancesOfUser()

ilStudyProgrammeAssignmentDBRepository::getInstancesOfUser

(

int

$user_id

)

Definition at line 421 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References $DIC, $ret, ilObject\_getAllReferences(), and getByUsrId().

    {
        global $DIC;
        $tree = $DIC['tree'];

        $assignments = $this->getByUsrId($user_id);

        //if parent object is deleted or in trash
        //the assignment for the user should not be returned
        $ret = [];
        foreach ($assignments as $ass) {
            foreach (ilObject::_getAllReferences($ass->getRootId()) as $value) {
                if ($tree->isInTree($value)) {
                    $ret[] = $ass;
                    continue 2;
                }
            }
        }
        return $ret;
    }

Here is the call graph for this function:

getSQLHeader()

ilStudyProgrammeAssignmentDBRepository::getSQLHeader ( )

protected

Definition at line 154 of file class.ilStudyProgrammeAssignmentDBRepository.php.

Referenced by getDueToRestartBaseSQL(), and loadDueToManuelRestart().

                                      : string
    {
        return 'SELECT ' . self::FIELD_ID
            . ', ' . self::FIELD_USR_ID
            . ', ' . self::FIELD_ROOT_PRG_ID
            . ', ' . self::FIELD_LAST_CHANGE
            . ', ' . self::FIELD_LAST_CHANGE_BY
            . ', ' . self::FIELD_RESTART_DATE
            . ', ' . self::FIELD_RESTARTED_ASSIGNMENT_ID . PHP_EOL
            . ' FROM ' . self::TABLE . PHP_EOL;
    }

Here is the caller graph for this function:

getTableAndFieldOfAssignmentIds()

ilStudyProgrammeAssignmentDBRepository::getTableAndFieldOfAssignmentIds

(

)

Definition at line 399 of file class.ilStudyProgrammeAssignmentDBRepository.php.

                                                      : array
    {
        return  [self::TABLE, self::FIELD_ID];
    }

insertRowDB()

ilStudyProgrammeAssignmentDBRepository::insertRowDB ( array  $row )

protected

Definition at line 351 of file class.ilStudyProgrammeAssignmentDBRepository.php.

Referenced by createFor().

    {
        $this->db->insert(
            self::TABLE,
            [
                self::FIELD_ID => ['integer', $row[self::FIELD_ID]]
                , self::FIELD_USR_ID => ['integer', $row[self::FIELD_USR_ID]]
                , self::FIELD_ROOT_PRG_ID => ['integer', $row[self::FIELD_ROOT_PRG_ID]]
                , self::FIELD_LAST_CHANGE => ['text', $row[self::FIELD_LAST_CHANGE]]
                , self::FIELD_LAST_CHANGE_BY => ['integer', $row[self::FIELD_LAST_CHANGE_BY]]
                , self::FIELD_RESTART_DATE => ['timestamp', $row[self::FIELD_RESTART_DATE]]
                , self::FIELD_RESTARTED_ASSIGNMENT_ID => ['integer', $row[self::FIELD_RESTARTED_ASSIGNMENT_ID]]
            ]
        );
    }

Here is the caller graph for this function:

loadByFilterDB()

ilStudyProgrammeAssignmentDBRepository::loadByFilterDB ( array  $filter )

protected

Definition at line 331 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References $res.

Referenced by get(), getByPrgId(), getByUsrId(), and getByUsrIdAndPrgId().

    {
        $q = 'SELECT ' . self::FIELD_ID
            . ' ,' . self::FIELD_USR_ID
            . ' ,' . self::FIELD_ROOT_PRG_ID
            . ' ,' . self::FIELD_LAST_CHANGE
            . ' ,' . self::FIELD_LAST_CHANGE_BY
            . ' ,' . self::FIELD_RESTART_DATE
            . ' ,' . self::FIELD_RESTARTED_ASSIGNMENT_ID
            . ' FROM ' . self::TABLE
            . ' WHERE TRUE';
        foreach ($filter as $field => $value) {
            $q .= '     AND ' . $field . ' = ' . $this->db->quote($value, 'text');
        }
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

Here is the caller graph for this function:

loadDueToManuelRestart()

ilStudyProgrammeAssignmentDBRepository::loadDueToManuelRestart ( int  $days_before_end )

protected

Exceptions

Exception

Definition at line 200 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References $res, ilStudyProgrammeAssignment\DATE_FORMAT, getSQLHeader(), and ilStudyProgrammeAssignment\NO_RESTARTED_ASSIGNMENT.

Referenced by getDueToManuelRestart().

    {
        $date = new DateTime();
        $date->sub(new DateInterval('P' . $days_before_end . 'D'));
        $q = $this->getSQLHeader()
            . ' WHERE ' . self::FIELD_RESTARTED_ASSIGNMENT_ID
            . ' = ' . $this->db->quote(
                ilStudyProgrammeAssignment::NO_RESTARTED_ASSIGNMENT,
                'integer'
            ) . PHP_EOL
            . '    AND ' . self::FIELD_RESTART_DATE . ' IS NOT NULL' . PHP_EOL
            . '    AND DATE(' . self::FIELD_RESTART_DATE . ') <= '
            . $this->db->quote(
                $date->format(
                    ilStudyProgrammeAssignment::DATE_FORMAT
                ),
                'text'
            );
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

loadDueToRestart()

ilStudyProgrammeAssignmentDBRepository::loadDueToRestart ( )

protected

Definition at line 134 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References $res, and getDueToRestartBaseSQL().

Referenced by getDueToRestart().

    {
        $q = $this->getDueToRestartBaseSQL();
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

loadDueToRestartAndMail()

ilStudyProgrammeAssignmentDBRepository::loadDueToRestartAndMail ( )

protected

Definition at line 143 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References $res, and getDueToRestartBaseSQL().

Referenced by getDueToRestartAndMail().

    {
        $q = $this->getDueToRestartBaseSQL();
        $q .= '    AND ' . self::FIELD_RESTART_MAIL . ' IS NULL';

        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

nextId()

ilStudyProgrammeAssignmentDBRepository::nextId ( )

protected

Definition at line 386 of file class.ilStudyProgrammeAssignmentDBRepository.php.

Referenced by createFor().

    {
        return $this->db->nextId(self::TABLE);
    }

Here is the caller graph for this function:

reminderSendFor()

ilStudyProgrammeAssignmentDBRepository::reminderSendFor

(

int

$assignment_id

)

Definition at line 249 of file class.ilStudyProgrammeAssignmentDBRepository.php.

                                                        : void
    {
        $where = [
            self::FIELD_ID => [
                'integer',
                $assignment_id
            ]
        ];

        $values = [
            self::FIELD_RESTART_MAIL => [
                'timestamp',
                date('Y-m-d H:i:s')
            ]
        ];

        $this->db->update(self::TABLE, $values, $where);
    }

update()

ilStudyProgrammeAssignmentDBRepository::update

(

ilStudyProgrammeAssignment

$assignment

)

Update settings belonging to a SP-Object.Will throw if the record does not exist yet.

Implements ilStudyProgrammeAssignmentRepository.

Definition at line 227 of file class.ilStudyProgrammeAssignmentDBRepository.php.

References ilStudyProgrammeAssignment\DATE_TIME_FORMAT, ilStudyProgrammeAssignment\getId(), ilStudyProgrammeAssignment\getLastChange(), ilStudyProgrammeAssignment\getLastChangeBy(), ilStudyProgrammeAssignment\getRestartDate(), ilStudyProgrammeAssignment\getRestartedAssignmentId(), ilStudyProgrammeAssignment\getRootId(), ilStudyProgrammeAssignment\getUserId(), and updatedRowDB().

    {
        $row = [
            self::FIELD_ID => $assignment->getId(),
            self::FIELD_USR_ID => $assignment->getUserId(),
            self::FIELD_ROOT_PRG_ID => $assignment->getRootId(),
            self::FIELD_LAST_CHANGE_BY => $assignment->getLastChangeBy(),
            self::FIELD_LAST_CHANGE => $assignment->getLastChange()->format(ilStudyProgrammeAssignment::DATE_TIME_FORMAT),
            self::FIELD_RESTART_DATE => $assignment->getRestartDate() ? $assignment->getRestartDate()->format(ilStudyProgrammeAssignment::DATE_TIME_FORMAT) : null,
            self::FIELD_RESTARTED_ASSIGNMENT_ID => $assignment->getRestartedAssignmentId()
        ];
        $this->updatedRowDB($row);
    }

Here is the call graph for this function:

updatedRowDB()

ilStudyProgrammeAssignmentDBRepository::updatedRowDB ( array  $values )

protected

Definition at line 367 of file class.ilStudyProgrammeAssignmentDBRepository.php.

Referenced by update().

    {
        $q = 'UPDATE ' . self::TABLE
            . ' SET'
            . ' ' . self::FIELD_USR_ID . ' = ' . $this->db->quote($values[self::FIELD_USR_ID], 'integer')
            . ' ,' . self::FIELD_ROOT_PRG_ID . ' = ' . $this->db->quote($values[self::FIELD_ROOT_PRG_ID], 'integer')
            . ' ,' . self::FIELD_LAST_CHANGE . ' = ' . $this->db->quote($values[self::FIELD_LAST_CHANGE], 'text')
            . ' ,' . self::FIELD_LAST_CHANGE_BY . ' = ' . $this->db->quote($values[self::FIELD_LAST_CHANGE_BY], 'integer')
            . ' ,' . self::FIELD_RESTART_DATE . ' = ' . $this->db->quote($values[self::FIELD_RESTART_DATE], 'timestamp')
            . ' ,' . self::FIELD_RESTARTED_ASSIGNMENT_ID . ' = ' . $this->db->quote($values[self::FIELD_RESTARTED_ASSIGNMENT_ID], 'integer')
            . ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($values[self::FIELD_ID], 'integer');
        $this->db->manipulate($q);
    }

Here is the caller graph for this function:

Field Documentation

$db

ilStudyProgrammeAssignmentDBRepository::$db

protected

Definition at line 8 of file class.ilStudyProgrammeAssignmentDBRepository.php.

Referenced by __construct(), and getDashboardInstancesforUser().

FIELD_ID

const ilStudyProgrammeAssignmentDBRepository::FIELD_ID = 'id'

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

Referenced by ilStudyProgrammeAssignmentRepositoryTest\tearDownAfterClass().

FIELD_LAST_CHANGE

const ilStudyProgrammeAssignmentDBRepository::FIELD_LAST_CHANGE = 'last_change'

Definition at line 15 of file class.ilStudyProgrammeAssignmentDBRepository.php.

FIELD_LAST_CHANGE_BY

const ilStudyProgrammeAssignmentDBRepository::FIELD_LAST_CHANGE_BY = 'last_change_by'

Definition at line 16 of file class.ilStudyProgrammeAssignmentDBRepository.php.

FIELD_RESTART_DATE

const ilStudyProgrammeAssignmentDBRepository::FIELD_RESTART_DATE = 'restart_date'

Definition at line 17 of file class.ilStudyProgrammeAssignmentDBRepository.php.

FIELD_RESTART_MAIL

const ilStudyProgrammeAssignmentDBRepository::FIELD_RESTART_MAIL = 'restart_mail_send'

Definition at line 19 of file class.ilStudyProgrammeAssignmentDBRepository.php.

FIELD_RESTARTED_ASSIGNMENT_ID

const ilStudyProgrammeAssignmentDBRepository::FIELD_RESTARTED_ASSIGNMENT_ID = 'restarted_assignment_id'

Definition at line 18 of file class.ilStudyProgrammeAssignmentDBRepository.php.

FIELD_ROOT_PRG_ID

const ilStudyProgrammeAssignmentDBRepository::FIELD_ROOT_PRG_ID = 'root_prg_id'

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

FIELD_USR_ID

const ilStudyProgrammeAssignmentDBRepository::FIELD_USR_ID = 'usr_id'

Definition at line 13 of file class.ilStudyProgrammeAssignmentDBRepository.php.

TABLE

const ilStudyProgrammeAssignmentDBRepository::TABLE = 'prg_usr_assignments'

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

Referenced by ilStudyProgrammeMembersTableGUI\getFrom(), ilStudyProgrammeAssignmentRepositoryTest\tearDownAfterClass(), ilStudyProgrammeUserAssignmentTest\testDeassignRemovesEntriesInPrgUsrAssignment(), and ilStudyProgrammeUserAssignmentTest\testDeleteOfProgrammeRemovesEntriesInPrgUsrAssignment().

---

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

• Modules/StudyProgramme/classes/model/Assignments/class.ilStudyProgrammeAssignmentDBRepository.php