ilPRGAssignmentDBRepository Class Reference

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

Inheritance diagram for ilPRGAssignmentDBRepository:

Collaboration diagram for ilPRGAssignmentDBRepository:

Public Member Functions
	__construct (ilDBInterface $db, ilTree $tree, ilStudyProgrammeSettingsRepository $settings_repo, PRGEventsDelayed $events)
	getDashboardInstancesforUser (int $usr_id)
	createFor (int $prg_obj_id, int $usr_id, int $assigning_usr_id)
	store (ilPRGAssignment $assignment)
	delete (ilPRGAssignment $assignment)
	deleteAllAssignmentsForProgrammeId (int $prg_obj_id)
	get (int $id)
	getForUser (int $usr_id)
	get all assignments for a user More...
	getAllForNodeIsContained (int $prg_obj_id, array $user_filter=null, ilPRGAssignmentFilter $custom_filters=null)
	get all assignments for all (or given) users, where the given node is part of the assignment More...
	countAllForNodeIsContained (int $prg_obj_id, array $user_filter=null, ilPRGAssignmentFilter $custom_filters=null)
	Count all assignments for all (or given) users, where the given node is part of the assignment. More...
	getAllForSpecificNode (int $prg_obj_id, array $user_filter=null)
	get all assignments for all (or given) users, where the given node is the root-node of the assignment More...
	getPassedDeadline (\DateTimeImmutable $deadline)
	getAboutToExpire (array $programmes_and_due, bool $discard_formerly_notified=true)
	getExpiredAndNotInvalidated ()
	getRiskyToFail (array $programmes_and_due, bool $discard_formerly_notified=true)
	storeExpiryInfoSentFor (ilPRGAssignment $ass)
	resetExpiryInfoSentFor (ilPRGAssignment $ass)
	storeRiskyToFailSentFor (ilPRGAssignment $ass)
	resetRiskyToFailSentFor (ilPRGAssignment $ass)

Data Fields
const	ASSIGNMENT_TABLE = 'prg_usr_assignments'
const	ASSIGNMENT_FIELD_ID = 'id'
const	ASSIGNMENT_FIELD_USR_ID = 'usr_id'
const	ASSIGNMENT_FIELD_ROOT_PRG_ID = 'root_prg_id'
const	ASSIGNMENT_FIELD_LAST_CHANGE = 'last_change'
const	ASSIGNMENT_FIELD_LAST_CHANGE_BY = 'last_change_by'
const	ASSIGNMENT_FIELD_RESTART_DATE = 'restart_date'
const	ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID = 'restarted_assignment_id'
const	ASSIGNMENT_FIELD_RESTART_MAIL = 'restart_mail_send'
const	ASSIGNMENT_FIELD_MANUALLY_ASSIGNED = 'assigned_manually'
const	PROGRESS_TABLE = 'prg_usr_progress'
const	PROGRESS_FIELD_ASSIGNMENT_ID = 'assignment_id'
const	PROGRESS_FIELD_USR_ID = 'usr_id'
const	PROGRESS_FIELD_PRG_ID = 'prg_id'
const	PROGRESS_FIELD_POINTS = 'points'
const	PROGRESS_FIELD_POINTS_CUR = 'points_cur'
const	PROGRESS_FIELD_STATUS = 'status'
const	PROGRESS_FIELD_COMPLETION_BY = 'completion_by'
const	PROGRESS_FIELD_ASSIGNMENT_DATE = 'assignment_date'
const	PROGRESS_FIELD_LAST_CHANGE = 'last_change'
const	PROGRESS_FIELD_LAST_CHANGE_BY = 'last_change_by'
const	PROGRESS_FIELD_COMPLETION_DATE = 'completion_date'
const	PROGRESS_FIELD_DEADLINE = 'deadline'
const	PROGRESS_FIELD_VQ_DATE = 'vq_date'
const	PROGRESS_FIELD_INVALIDATED = 'invalidated'
const	PROGRESS_FIELD_MAIL_SENT_RISKYTOFAIL = 'sent_mail_risky_to_fail'
const	PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE = 'sent_mail_expires'
const	PROGRESS_FIELD_IS_INDIVIDUAL = 'individual'
const	DATE_FORMAT_ENDOFDAY = 'Y-m-d 23:59:59'

Protected Member Functions
	deleteAllOrphanedProgresses ()
	query ($filter)
	nextId ()
	count (array $filter)
	read (array $filter)
	prebuildProgressesForAssingment (int $assignment_id)
	assignmentByRow (array $row)
	buildProgressTreeFor (int $node_obj_id)
	getRefIdFor (int $obj_id)
	getObjIdFor (int $ref_id)
	buildProgressByRow (array $row)
	interimOrguLookup (int $usr_id)
	buildUserInformation (array $row)
	insertAssignmentRowDB (array $row)
	updateAssignmentRowDB (array $values)
	storeProgressRow (int $assignment_id, int $usr_id, ilPRGProgress $pgs)

Protected Attributes
ilDBInterface	$db
ilTree	$tree
ilStudyProgrammeSettingsRepository	$settings_repo
array	$progresses = []
	<id => ilPRGProgress> More...
StudyProgrammeEvents	$events

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 Assignments are relations of users to a PRG; They hold progress-information for (sub-)nodes of the PRG-tree.

Definition at line 25 of file class.ilPRGAssignmentDBRepository.php.

Constructor & Destructor Documentation

__construct()

ilPRGAssignmentDBRepository::__construct	(	ilDBInterface	$db,
		ilTree	$tree,
		ilStudyProgrammeSettingsRepository	$settings_repo,
		PRGEventsDelayed	$events
	)

Definition at line 68 of file class.ilPRGAssignmentDBRepository.php.

References $db, $events, $settings_repo, and $tree.

      {
        $this->db = $db;
        $this->tree = $tree;
        $this->settings_repo = $settings_repo;
        $this->events = $events;
    }

Member Function Documentation

assignmentByRow()

ilPRGAssignmentDBRepository::assignmentByRow ( array  $row )

protected

Definition at line 469 of file class.ilPRGAssignmentDBRepository.php.

References buildProgressTreeFor(), buildUserInformation(), ilPRGAssignment\DATE_TIME_FORMAT, and ILIAS\Repository\int().

Referenced by createFor(), and read().

                                                  : ilPRGAssignment
    {
        $ass = new ilPRGAssignment(
            (int) $row[self::ASSIGNMENT_FIELD_ID],
            (int) $row[self::ASSIGNMENT_FIELD_USR_ID]
        );
        $ass = $ass
            ->withEvents($this->events)
            ->withLastChange(
                (int) $row[self::ASSIGNMENT_FIELD_LAST_CHANGE_BY],
                \DateTimeImmutable::createFromFormat(
                    ilPRGAssignment::DATE_TIME_FORMAT,
                    $row[self::ASSIGNMENT_FIELD_LAST_CHANGE]
                )
            )
            ->withRestarted(
                (int) $row[self::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID],
                $row[self::ASSIGNMENT_FIELD_RESTART_DATE] ?
                    \DateTimeImmutable::createFromFormat(ilPRGAssignment::DATE_TIME_FORMAT, $row[self::ASSIGNMENT_FIELD_RESTART_DATE]) :
                    null
            )
            ->withManuallyAssigned((bool) $row[self::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED]);


        $root_pgs_id = (int) $row[self::ASSIGNMENT_FIELD_ROOT_PRG_ID];
        $pgs = $this->buildProgressTreeFor($root_pgs_id);

        $user_information = $this->buildUserInformation($row);

        $ass = $ass
            ->withProgressTree($pgs)
            ->withUserInformation($user_information);
        return $ass;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

buildProgressByRow()

ilPRGAssignmentDBRepository::buildProgressByRow ( array  $row )

protected

Definition at line 544 of file class.ilPRGAssignmentDBRepository.php.

References ilPRGProgress\DATE_FORMAT, and ilPRGProgress\DATE_TIME_FORMAT.

Referenced by prebuildProgressesForAssingment().

                                                     : ilPRGProgress
    {
        $pgs = new ilPRGProgress(
            (int) $row[self::PROGRESS_FIELD_PRG_ID],
            (int) $row[self::PROGRESS_FIELD_STATUS]
        );

        $pgs = $pgs
            ->withAmountOfPoints((int) $row[self::PROGRESS_FIELD_POINTS])
            ->withCurrentAmountOfPoints((int) $row[self::PROGRESS_FIELD_POINTS_CUR])
            ->withAssignmentDate(
                $row[self::PROGRESS_FIELD_ASSIGNMENT_DATE] ?
                    \DateTimeImmutable::createFromFormat(ilPRGProgress::DATE_TIME_FORMAT, $row[self::PROGRESS_FIELD_ASSIGNMENT_DATE]) :
                    null
            )
            ->withDeadline(
                $row[self::PROGRESS_FIELD_DEADLINE] ?
                    \DateTimeImmutable::createFromFormat(ilPRGProgress::DATE_FORMAT, $row[self::PROGRESS_FIELD_DEADLINE]) :
                    null
            )
            ->withCompletion(
                (int) $row[self::PROGRESS_FIELD_COMPLETION_BY],
                $row[self::PROGRESS_FIELD_COMPLETION_DATE] ?
                    \DateTimeImmutable::createFromFormat(ilPRGProgress::DATE_TIME_FORMAT, $row[self::PROGRESS_FIELD_COMPLETION_DATE]) :
                    null
            )
            ->withLastChange(
                (int) $row[self::PROGRESS_FIELD_LAST_CHANGE_BY],
                $row[self::PROGRESS_FIELD_LAST_CHANGE] ?
                    \DateTimeImmutable::createFromFormat(ilPRGProgress::DATE_TIME_FORMAT, $row[self::PROGRESS_FIELD_LAST_CHANGE]) :
                    null
            )
            ->withValidityOfQualification(
                $row[self::PROGRESS_FIELD_VQ_DATE] ?
                    \DateTimeImmutable::createFromFormat(ilPRGProgress::DATE_TIME_FORMAT, $row[self::PROGRESS_FIELD_VQ_DATE]) :
                    null
            )
            ->withIndividualModifications((bool) $row[self::PROGRESS_FIELD_IS_INDIVIDUAL])
            ->withInvalidated((bool) $row[self::PROGRESS_FIELD_INVALIDATED]);

        return $pgs;
    }

Here is the caller graph for this function:

buildProgressTreeFor()

ilPRGAssignmentDBRepository::buildProgressTreeFor ( int  $node_obj_id )

protected

Definition at line 505 of file class.ilPRGAssignmentDBRepository.php.

References $c, and ilContainerReference\_lookupTargetId().

Referenced by assignmentByRow().

                                                             : ilPRGProgress
    {
        $children = array_filter(
            $this->tree->getChilds($this->getRefIdFor($node_obj_id)),
            fn ($c) => in_array($c['type'], ['prg', 'prgr']),
        );
        $children = array_map(
            fn ($c) => $c['type'] === 'prg' ? (int) $c['obj_id'] : ilContainerReference::_lookupTargetId((int) $c['obj_id']),
            $children
        );

        $pgss = [];
        foreach ($children as $child_obj_id) {
            $pgss[] = $this->buildProgressTreeFor($child_obj_id);
        }

        if (!array_key_exists($node_obj_id, $this->progresses)) {
            $pgs = new ilPRGProgress((int) $node_obj_id);
        } else {
            $pgs = $this->progresses[$node_obj_id];
        }
        $pgs->setSubnodes($pgss);
        return $pgs;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

buildUserInformation()

ilPRGAssignmentDBRepository::buildUserInformation ( array  $row )

protected

Definition at line 608 of file class.ilPRGAssignmentDBRepository.php.

References interimOrguLookup(), and ilObjUser\lookupOrgUnitsRepresentation().

Referenced by assignmentByRow().

                                                       : ilPRGUserInformation
    {
        $udf_data = new ilUserDefinedData((int) $row[self::ASSIGNMENT_FIELD_USR_ID]);
        $orgu_repr = ilObjUser::lookupOrgUnitsRepresentation((int) $row[self::ASSIGNMENT_FIELD_USR_ID]);

        $orgu_repr = $this->interimOrguLookup((int) $row[self::ASSIGNMENT_FIELD_USR_ID]);

        return new ilPRGUserInformation(
            $udf_data,
            $orgu_repr,
            (string) $row['firstname'],
            (string) $row['lastname'],
            (string) $row['login'],
            (bool) $row['active'],
            (string) $row['email'],
            (string) $row['gender'],
            (string) $row['title']
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

count()

ilPRGAssignmentDBRepository::count ( array  $filter )

protected

Definition at line 430 of file class.ilPRGAssignmentDBRepository.php.

References $res, and query().

Referenced by countAllForNodeIsContained(), getAboutToExpire(), getRefIdFor(), and getRiskyToFail().

                                           : int
    {
        $res = $this->query($filter);
        return $this->db->numRows($res);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

countAllForNodeIsContained()

ilPRGAssignmentDBRepository::countAllForNodeIsContained	(	int	$prg_obj_id,
		array	$user_filter = null,
		ilPRGAssignmentFilter	$custom_filters = null
	)

Count all assignments for all (or given) users, where the given node is part of the assignment.

Implements PRGAssignmentRepository.

Definition at line 215 of file class.ilPRGAssignmentDBRepository.php.

References count().

     : int {
        $conditions = [
            'pgs.' . self::PROGRESS_FIELD_PRG_ID . ' = ' . $this->db->quote($prg_obj_id, 'integer')
        ];
        if ($user_filter) {
            $conditions[] = $this->db->in('ass.' . self::ASSIGNMENT_FIELD_USR_ID, $user_filter, false, 'integer');
        }
        if ($custom_filters) {
            $conditions = array_merge($conditions, $custom_filters->toConditions());
        }
        return $this->count($conditions);
    }

Here is the call graph for this function:

createFor()

ilPRGAssignmentDBRepository::createFor	(	int	$prg_obj_id,
		int	$usr_id,
		int	$assigning_usr_id
	)

Implements PRGAssignmentRepository.

Definition at line 87 of file class.ilPRGAssignmentDBRepository.php.

References $query, $res, ilObject\_lookupType(), assignmentByRow(), ilPRGUserInformation\COLNAMES, insertAssignmentRowDB(), nextId(), ilPRGAssignment\NO_RESTARTED_ASSIGNMENT, and ilUtil\now().

     : ilPRGAssignment {
        $manually = false;
        if (ilObject::_lookupType($assigning_usr_id) === "usr") {
            $manually = true;
        }
        $row = [
            self::ASSIGNMENT_FIELD_ID => $this->nextId(),
            self::ASSIGNMENT_FIELD_USR_ID => $usr_id,
            self::ASSIGNMENT_FIELD_ROOT_PRG_ID => $prg_obj_id,
            self::ASSIGNMENT_FIELD_LAST_CHANGE_BY => $assigning_usr_id,
            self::ASSIGNMENT_FIELD_LAST_CHANGE => ilUtil::now(),
            self::ASSIGNMENT_FIELD_RESTART_DATE => null,
            self::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID => ilPRGAssignment::NO_RESTARTED_ASSIGNMENT,
            self::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED => $manually
        ];
        $this->insertAssignmentRowDB($row);
        $this->progresses = [];

        //add user_colums : ilPRGUserInformation::COLNAMES
        $query = 'SELECT ' . implode(' ,', ilPRGUserInformation::COLNAMES) . PHP_EOL
            . 'FROM usr_data WHERE usr_id = ' . $this->db->quote($usr_id, 'integer');
        $res = $this->db->query($query);
        $row = array_merge($row, $this->db->fetchAssoc($res));


        $ass = $this->assignmentByRow($row);
        return $ass;
    }

Here is the call graph for this function:

delete()

ilPRGAssignmentDBRepository::delete

(

ilPRGAssignment

$assignment

)

Implements PRGAssignmentRepository.

Definition at line 144 of file class.ilPRGAssignmentDBRepository.php.

References $query.

Referenced by ilObjStudyProgramme\removeMemberFromProgrammes().

                                                       : void
    {
        $ass_id = $assignment->getId();
        $query = 'DELETE FROM ' . self::ASSIGNMENT_TABLE . PHP_EOL
         . 'WHERE ' . self::ASSIGNMENT_FIELD_ID . ' = ' . $ass_id;
        $this->db->manipulate($query);

        $query = 'DELETE FROM ' . self::PROGRESS_TABLE . PHP_EOL
         . 'WHERE ' . self::PROGRESS_FIELD_ASSIGNMENT_ID . ' = ' . $ass_id;
        $this->db->manipulate($query);
    }

Here is the caller graph for this function:

deleteAllAssignmentsForProgrammeId()

ilPRGAssignmentDBRepository::deleteAllAssignmentsForProgrammeId

(

int

$prg_obj_id

)

Implements PRGAssignmentRepository.

Definition at line 156 of file class.ilPRGAssignmentDBRepository.php.

References $query, and deleteAllOrphanedProgresses().

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

Here is the call graph for this function:

deleteAllOrphanedProgresses()

ilPRGAssignmentDBRepository::deleteAllOrphanedProgresses ( )

protected

Definition at line 163 of file class.ilPRGAssignmentDBRepository.php.

References $query.

Referenced by deleteAllAssignmentsForProgrammeId().

                                                    : void
    {
        $query = 'DELETE FROM ' . self::PROGRESS_TABLE . PHP_EOL
            . 'WHERE ' . self::PROGRESS_FIELD_ASSIGNMENT_ID . PHP_EOL
            . 'NOT IN (' . PHP_EOL
            . 'SELECT ' . $this->db->quoteIdentifier(self::ASSIGNMENT_FIELD_ID)
            . ' FROM ' . $this->db->quoteIdentifier(self::ASSIGNMENT_TABLE) . PHP_EOL
            . ');' . PHP_EOL;
        $this->db->manipulate($query);
    }

Here is the caller graph for this function:

get()

ilPRGAssignmentDBRepository::get

(

int

$id

)

Implements PRGAssignmentRepository.

Definition at line 175 of file class.ilPRGAssignmentDBRepository.php.

References $id, and read().

                                : ilPRGAssignment
    {
        $ass = $this->read([
            'ass.' . self::ASSIGNMENT_FIELD_ID . ' = ' . $this->db->quote($id, 'integer')
        ]);

        return $ass->current();
    }

Here is the call graph for this function:

getAboutToExpire()

ilPRGAssignmentDBRepository::getAboutToExpire	(	array	$programmes_and_due,
		bool	$discard_formerly_notified = true
	)

Parameters

array

<int $prg_obj_id, DateTimeImmutable $due>

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

Definition at line 274 of file class.ilPRGAssignmentDBRepository.php.

References count(), and read().

     : array {
        $ret = [];
        if (count($programmes_and_due) == 0) {
            return $ret;
        }

        $where = [];
        foreach ($programmes_and_due as $prg_obj_id => $due) {
            $due = $due->format(self::DATE_FORMAT_ENDOFDAY);

            $where_clause = '('
                . self::PROGRESS_FIELD_VQ_DATE . '<=' . $this->db->quote($due, 'text')
                . ' AND (pgs.' . self::PROGRESS_FIELD_PRG_ID . '=' . $prg_obj_id
                . ' OR ' . self::ASSIGNMENT_FIELD_ROOT_PRG_ID . '=' . $prg_obj_id . ')';

            if ($discard_formerly_notified) {
                $where_clause .= ' AND ' . self::PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE . ' IS NULL';
            }

            $where_clause .= ')';
            $where[] = $where_clause;
        }

        $conditions = [
            implode(' OR ', $where)
        ];
        $assignments = array_filter(iterator_to_array(
            $this->read($conditions)
        ));
        return $assignments;
    }

Here is the call graph for this function:

getAllForNodeIsContained()

ilPRGAssignmentDBRepository::getAllForNodeIsContained	(	int	$prg_obj_id,
		array	$user_filter = null,
		ilPRGAssignmentFilter	$custom_filters = null
	)

get all assignments for all (or given) users, where the given node is part of the assignment

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

Definition at line 194 of file class.ilPRGAssignmentDBRepository.php.

References read().

     : array {
        $conditions = [
            'pgs.' . self::PROGRESS_FIELD_PRG_ID . ' = ' . $this->db->quote($prg_obj_id, 'integer')
        ];
        if ($user_filter) {
            $conditions[] = $this->db->in('ass.' . self::ASSIGNMENT_FIELD_USR_ID, $user_filter, false, 'integer');
        }
        if ($custom_filters) {
            $conditions = array_merge($conditions, $custom_filters->toConditions());
        }

        $assignments = array_filter(iterator_to_array(
            $this->read($conditions)
        ));
        return $assignments;
    }

Here is the call graph for this function:

getAllForSpecificNode()

ilPRGAssignmentDBRepository::getAllForSpecificNode	(	int	$prg_obj_id,
		array	$user_filter = null
	)

get all assignments for all (or given) users, where the given node is the root-node of the assignment

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

Definition at line 232 of file class.ilPRGAssignmentDBRepository.php.

References read().

                                                                                     : array
    {
        $conditions = [
            self::ASSIGNMENT_FIELD_ROOT_PRG_ID . ' = ' . $this->db->quote($prg_obj_id, 'integer')
        ];
        if ($user_filter) {
            $conditions[] = $this->db->in('ass.' . self::ASSIGNMENT_FIELD_USR_ID, $user_filter, false, 'integer');
        }

        $assignments = array_filter(iterator_to_array(
            $this->read($conditions)
        ));
        return $assignments;
    }

Here is the call graph for this function:

getDashboardInstancesforUser()

ilPRGAssignmentDBRepository::getDashboardInstancesforUser

(

int

$usr_id

)

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

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

References getForUser().

                                                             : array
    {
        $assignments = $this->getForUser($usr_id);
        //TODO: decide, which ones are relevant for the dashboard
        return $assignments;
    }

Here is the call graph for this function:

getExpiredAndNotInvalidated()

ilPRGAssignmentDBRepository::getExpiredAndNotInvalidated

(

)

Implements PRGAssignmentRepository.

Definition at line 309 of file class.ilPRGAssignmentDBRepository.php.

References read(), ilPRGProgress\STATUS_ACCREDITED, and ilPRGProgress\STATUS_COMPLETED.

                                                 : array
    {
        $now = (new \DateTimeImmutable())->format(self::DATE_FORMAT_ENDOFDAY);
        $conditions = [
            $this->db->in(
                self::PROGRESS_FIELD_STATUS,
                [
                    ilPRGProgress::STATUS_COMPLETED,
                    ilPRGProgress::STATUS_ACCREDITED
                ],
                false,
                'integer'
            ),
            self::PROGRESS_FIELD_VQ_DATE . ' IS NOT NULL',
            self::PROGRESS_FIELD_VQ_DATE . ' < ' . $this->db->quote($now, 'text'),
            self::PROGRESS_FIELD_INVALIDATED . ' = 0 ',
        ];

        $assignments = array_filter(iterator_to_array(
            $this->read($conditions)
        ));
        return $assignments;
    }

Here is the call graph for this function:

getForUser()

ilPRGAssignmentDBRepository::getForUser

(

int

$usr_id

)

get all assignments for a user

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

Definition at line 184 of file class.ilPRGAssignmentDBRepository.php.

References read().

Referenced by getDashboardInstancesforUser().

                                           : array
    {
        $assignments = array_filter(iterator_to_array(
            $this->read([
                'ass.' . self::ASSIGNMENT_FIELD_USR_ID . ' = ' . $this->db->quote($usr_id, 'integer')
            ])
        ));
        return $assignments;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getObjIdFor()

ilPRGAssignmentDBRepository::getObjIdFor ( int  $ref_id )

protected

Definition at line 539 of file class.ilPRGAssignmentDBRepository.php.

References ilObject\_lookupObjectId().

                                               : int
    {
        return (int) ilObject::_lookupObjectId($ref_id);
    }

Here is the call graph for this function:

getPassedDeadline()

ilPRGAssignmentDBRepository::getPassedDeadline

(

\DateTimeImmutable

$deadline

)

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

Definition at line 247 of file class.ilPRGAssignmentDBRepository.php.

References ilPRGProgress\DATE_FORMAT, read(), ilPRGProgress\STATUS_ACCREDITED, and ilPRGProgress\STATUS_IN_PROGRESS.

                                                                   : array
    {
        $deadline = $this->db->quote(
            $deadline->format(ilPRGProgress::DATE_FORMAT),
            'text'
        );

        $conditions = [
            $this->db->in(
                self::PROGRESS_FIELD_STATUS,
                [
                    ilPRGProgress::STATUS_IN_PROGRESS,
                    ilPRGProgress::STATUS_ACCREDITED
                ],
                false,
                'integer'
            ),
            self::PROGRESS_FIELD_DEADLINE . ' IS NOT NULL',
            self::PROGRESS_FIELD_DEADLINE . ' < ' . $deadline
        ];

        $assignments = array_filter(iterator_to_array(
            $this->read($conditions)
        ));
        return $assignments;
    }

Here is the call graph for this function:

getRefIdFor()

ilPRGAssignmentDBRepository::getRefIdFor ( int  $obj_id )

protected

Definition at line 531 of file class.ilPRGAssignmentDBRepository.php.

References ilObject\_getAllReferences(), and count().

                                               : int
    {
        $refs = ilObject::_getAllReferences($obj_id);
        if (count($refs) < 1) {
            throw new ilException("Could not find ref_id for programme with obj_id $obj_id");
        }
        return (int) array_shift($refs);
    }

Here is the call graph for this function:

getRiskyToFail()

ilPRGAssignmentDBRepository::getRiskyToFail	(	array	$programmes_and_due,
		bool	$discard_formerly_notified = true
	)

Definition at line 334 of file class.ilPRGAssignmentDBRepository.php.

References count(), ilPRGProgress\DATE_FORMAT, read(), ilPRGProgress\STATUS_ACCREDITED, ilPRGProgress\STATUS_COMPLETED, and ilPRGProgress\STATUS_NOT_RELEVANT.

     : array {
        $ret = [];
        if (count($programmes_and_due) == 0) {
            return $ret;
        }

        $where = [];
        foreach ($programmes_and_due as $prg_obj_id => $due) {
            $due = $due->format(ilPRGProgress::DATE_FORMAT);

            $where_clause = '('
                . self::PROGRESS_FIELD_DEADLINE . '<=' . $this->db->quote($due, 'text')
                . 'AND (pgs.' . self::PROGRESS_FIELD_PRG_ID . '=' . $prg_obj_id
                . ' OR ' . self::ASSIGNMENT_FIELD_ROOT_PRG_ID . '=' . $prg_obj_id . ')'
                . ' AND ' . $this->db->in(
                    self::PROGRESS_FIELD_STATUS,
                    [
                        ilPRGProgress::STATUS_ACCREDITED,
                        ilPRGProgress::STATUS_COMPLETED,
                        ilPRGProgress::STATUS_NOT_RELEVANT
                    ],
                    true,
                    'integer'
                );

            if ($discard_formerly_notified) {
                $where_clause .= ' AND ' . self::PROGRESS_FIELD_MAIL_SENT_RISKYTOFAIL . ' IS NULL';
            }

            $where_clause .= ')';
            $where[] = $where_clause;
        }

        $conditions = [
            implode(' OR ', $where)
        ];
        $assignments = array_filter(iterator_to_array(
            $this->read($conditions)
        ));
        return $assignments;
    }

Here is the call graph for this function:

insertAssignmentRowDB()

ilPRGAssignmentDBRepository::insertAssignmentRowDB ( array  $row )

protected

Definition at line 628 of file class.ilPRGAssignmentDBRepository.php.

Referenced by createFor().

    {
        $this->db->insert(
            self::ASSIGNMENT_TABLE,
            [
                self::ASSIGNMENT_FIELD_ID => ['integer', $row[self::ASSIGNMENT_FIELD_ID]]
                , self::ASSIGNMENT_FIELD_USR_ID => ['integer', $row[self::ASSIGNMENT_FIELD_USR_ID]]
                , self::ASSIGNMENT_FIELD_ROOT_PRG_ID => ['integer', $row[self::ASSIGNMENT_FIELD_ROOT_PRG_ID]]
                , self::ASSIGNMENT_FIELD_LAST_CHANGE => ['text', $row[self::ASSIGNMENT_FIELD_LAST_CHANGE]]
                , self::ASSIGNMENT_FIELD_LAST_CHANGE_BY => ['integer', $row[self::ASSIGNMENT_FIELD_LAST_CHANGE_BY]]
                , self::ASSIGNMENT_FIELD_RESTART_DATE => ['timestamp', $row[self::ASSIGNMENT_FIELD_RESTART_DATE]]
                , self::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID => ['integer', $row[self::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID]]
                , self::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED => ['integer', $row[self::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED]]
            ]
        );
    }

Here is the caller graph for this function:

interimOrguLookup()

ilPRGAssignmentDBRepository::interimOrguLookup ( int  $usr_id )

protected

Deprecated:

; fix ilObjUser::lookupOrgUnitsRepresentation

Definition at line 591 of file class.ilPRGAssignmentDBRepository.php.

References ilObject\_lookupObjId(), ilObject\_lookupTitle(), and OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository\getInstance().

Referenced by buildUserInformation().

                                                     : string
    {
        $orgu_repo = OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getInstance();
        $orgus = array_values($orgu_repo->findAllUserAssingmentsByUserIds([$usr_id]));
        if ($orgus) {
            $orgu_ref_ids =  array_map(
                fn ($orgu_assignment) => $orgu_assignment->getOrguId(),
                $orgus[0]
            );
            $orgus = array_map(
                fn ($orgu_ref_id) => ilObject::_lookupTitle(ilObject::_lookupObjId($orgu_ref_id)),
                $orgu_ref_ids
            );
        }
        return implode(', ', $orgus);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

nextId()

ilPRGAssignmentDBRepository::nextId ( )

protected

Definition at line 425 of file class.ilPRGAssignmentDBRepository.php.

Referenced by createFor().

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

Here is the caller graph for this function:

prebuildProgressesForAssingment()

ilPRGAssignmentDBRepository::prebuildProgressesForAssingment ( int  $assignment_id )

protected

Definition at line 458 of file class.ilPRGAssignmentDBRepository.php.

References $res, and buildProgressByRow().

Referenced by read().

                                                                          : array
    {
        $q = 'SELECT * FROM ' . self::PROGRESS_TABLE
            . ' WHERE ' . self::PROGRESS_FIELD_ASSIGNMENT_ID . ' = ' . $assignment_id;
        $res = $this->db->query($q);
        while ($row = $this->db->fetchAssoc($res)) {
            $ret[$row[self::PROGRESS_FIELD_PRG_ID]] = $this->buildProgressByRow($row);
        }
        return $ret;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

query()

ilPRGAssignmentDBRepository::query (   $filter )

protected

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

References $res, and ilPRGUserInformation\COLNAMES.

Referenced by count(), and read().

                                     : ilDBStatement
    {
        $q = 'SELECT'
            . '  ass.' . self::ASSIGNMENT_FIELD_ID . ' AS ' . self::ASSIGNMENT_FIELD_ID
            . ', ass.' . self::ASSIGNMENT_FIELD_USR_ID . ' AS ' . self::ASSIGNMENT_FIELD_USR_ID
            . ',' . self::ASSIGNMENT_FIELD_ROOT_PRG_ID
            . ', ass.' . self::ASSIGNMENT_FIELD_LAST_CHANGE
            . ', ass.' . self::ASSIGNMENT_FIELD_LAST_CHANGE_BY
            . ',' . self::ASSIGNMENT_FIELD_RESTART_DATE
            . ',' . self::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID
            . ',' . self::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED
            . ',' . self::PROGRESS_FIELD_PRG_ID
            . ',' . self::PROGRESS_FIELD_POINTS
            . ',' . self::PROGRESS_FIELD_POINTS_CUR
            . ',' . self::PROGRESS_FIELD_STATUS
            . ',' . self::PROGRESS_FIELD_COMPLETION_BY
            . ',' . self::PROGRESS_FIELD_ASSIGNMENT_DATE
            . ', pgs.' . self::PROGRESS_FIELD_LAST_CHANGE . ' AS p_' . self::PROGRESS_FIELD_LAST_CHANGE
            . ', pgs.' . self::PROGRESS_FIELD_LAST_CHANGE_BY . ' AS p_' . self::PROGRESS_FIELD_LAST_CHANGE_BY
            . ',' . self::PROGRESS_FIELD_COMPLETION_DATE
            . ',' . self::PROGRESS_FIELD_DEADLINE
            . ',' . self::PROGRESS_FIELD_VQ_DATE
            . ',' . self::PROGRESS_FIELD_INVALIDATED
            . ',' . self::PROGRESS_FIELD_MAIL_SENT_RISKYTOFAIL
            . ',' . self::PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE
            . ',' . self::PROGRESS_FIELD_IS_INDIVIDUAL

            . ', ' . implode(', ', ilPRGUserInformation::COLNAMES)

            . ' FROM ' . self::ASSIGNMENT_TABLE . ' ass '
            . ' JOIN ' . self::PROGRESS_TABLE . ' pgs '
            . ' ON ass.' . self::ASSIGNMENT_FIELD_ID . ' = pgs.' . self::PROGRESS_FIELD_ASSIGNMENT_ID


            . ' JOIN usr_data memberdata ON ass.usr_id = memberdata.usr_id '

            . ' WHERE TRUE AND ';
        $q = $q . implode(' AND ', $filter);
        $q = $q . ' ORDER BY assignment_id, ass.usr_id';

        $res = $this->db->query($q);
        return $res;
    }

Here is the caller graph for this function:

read()

ilPRGAssignmentDBRepository::read ( array  $filter )

protected

Definition at line 436 of file class.ilPRGAssignmentDBRepository.php.

References $res, assignmentByRow(), prebuildProgressesForAssingment(), and query().

Referenced by get(), getAboutToExpire(), getAllForNodeIsContained(), getAllForSpecificNode(), getExpiredAndNotInvalidated(), getForUser(), getPassedDeadline(), and getRiskyToFail().

                                          : Generator
    {
        $res = $this->query($filter);

        $current_ass = -1;
        $ass = null;

        while ($row = $this->db->fetchAssoc($res)) {
            if ($row[self::ASSIGNMENT_FIELD_ID] !== $current_ass) {
                $current_ass = $row[self::ASSIGNMENT_FIELD_ID];
                if (!is_null($ass)) {
                    yield $ass;
                }
                $this->progresses = $this->prebuildProgressesForAssingment((int) $row[self::ASSIGNMENT_FIELD_ID]);
                $ass = $this->assignmentByRow($row); //amend all progresses based on tree
            }
        }

        yield $ass;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

resetExpiryInfoSentFor()

ilPRGAssignmentDBRepository::resetExpiryInfoSentFor

(

ilPRGAssignment

$ass

)

Definition at line 746 of file class.ilPRGAssignmentDBRepository.php.

References ilPRGAssignment\getId(), and ilPRGAssignment\getRootId().

                                                                : void
    {
        $where = [
            self::PROGRESS_FIELD_ASSIGNMENT_ID => ['integer', $ass->getId()],
            self::PROGRESS_FIELD_PRG_ID => ['integer', $ass->getRootId()]
        ];

        $values = [
            self::PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE => ['null', null]
        ];
        $this->db->update(self::PROGRESS_TABLE, $values, $where);
    }

Here is the call graph for this function:

resetRiskyToFailSentFor()

ilPRGAssignmentDBRepository::resetRiskyToFailSentFor

(

ilPRGAssignment

$ass

)

Definition at line 775 of file class.ilPRGAssignmentDBRepository.php.

References ilPRGAssignment\getId(), and ilPRGAssignment\getRootId().

                                                                 : void
    {
        $where = [
            self::PROGRESS_FIELD_ASSIGNMENT_ID => ['integer', $ass->getId()],
            self::PROGRESS_FIELD_PRG_ID => ['integer', $ass->getRootId()]
        ];

        $values = [
            self::PROGRESS_FIELD_MAIL_SENT_RISKYTOFAIL => ['null', null]
        ];
        $this->db->update(self::PROGRESS_TABLE, $values, $where);
    }

Here is the call graph for this function:

store()

ilPRGAssignmentDBRepository::store

(

ilPRGAssignment

$assignment

)

Implements PRGAssignmentRepository.

Definition at line 120 of file class.ilPRGAssignmentDBRepository.php.

References ilPRGAssignment\DATE_TIME_FORMAT, ilPRGAssignment\getId(), ilPRGAssignment\getLastChange(), ilPRGAssignment\getLastChangeBy(), ilPRGAssignment\getProgresses(), ilPRGAssignment\getRestartDate(), ilPRGAssignment\getRestartedAssignmentId(), ilPRGAssignment\getRootId(), ilPRGAssignment\getUserId(), ilPRGAssignment\isManuallyAssigned(), storeProgressRow(), and updateAssignmentRowDB().

Referenced by ilObjStudyProgramme\removeMemberFromProgrammes().

                                                      : void
    {
        $row = [
            self::ASSIGNMENT_FIELD_ID => $assignment->getId(),
            self::ASSIGNMENT_FIELD_USR_ID => $assignment->getUserId(),
            self::ASSIGNMENT_FIELD_ROOT_PRG_ID => $assignment->getRootId(),
            self::ASSIGNMENT_FIELD_LAST_CHANGE_BY => $assignment->getLastChangeBy(),
            self::ASSIGNMENT_FIELD_LAST_CHANGE => $assignment->getLastChange()->format(ilPRGAssignment::DATE_TIME_FORMAT),
            self::ASSIGNMENT_FIELD_RESTART_DATE => $assignment->getRestartDate() ? $assignment->getRestartDate()->format(ilPRGAssignment::DATE_TIME_FORMAT) : null,
            self::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID => $assignment->getRestartedAssignmentId(),
            self::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED => $assignment->isManuallyAssigned()
        ];
        $this->updateAssignmentRowDB($row);
        foreach ($assignment->getProgresses() as $pgs) {
            $this->storeProgressRow(
                $assignment->getId(),
                $assignment->getUserId(),
                $pgs
            );
        }

        $this->events->raiseCollected();
    }

Here is the call graph for this function:

Here is the caller graph for this function:

storeExpiryInfoSentFor()

ilPRGAssignmentDBRepository::storeExpiryInfoSentFor

(

ilPRGAssignment

$ass

)

Definition at line 730 of file class.ilPRGAssignmentDBRepository.php.

References ilPRGAssignment\getId(), and ilPRGAssignment\getRootId().

                                                                : void
    {
        $where = [
            self::PROGRESS_FIELD_ASSIGNMENT_ID => ['integer', $ass->getId()],
            self::PROGRESS_FIELD_PRG_ID => ['integer', $ass->getRootId()]
        ];

        $values = [
            self::PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE => [
                'timestamp',
                date('Y-m-d H:i:s')
            ]
        ];
        $this->db->update(self::PROGRESS_TABLE, $values, $where);
    }

Here is the call graph for this function:

storeProgressRow()

ilPRGAssignmentDBRepository::storeProgressRow ( int  $assignment_id, int  $usr_id, ilPRGProgress  $pgs  )

protected

Definition at line 660 of file class.ilPRGAssignmentDBRepository.php.

References ilPRGProgress\DATE_FORMAT, ilPRGProgress\DATE_TIME_FORMAT, ilPRGProgress\getAmountOfPoints(), ilPRGProgress\getAssignmentDate(), ilPRGProgress\getCompletionBy(), ilPRGProgress\getCompletionDate(), ilPRGProgress\getCurrentAmountOfPoints(), ilPRGProgress\getDeadline(), ilPRGProgress\getLastChange(), ilPRGProgress\getLastChangeBy(), ilPRGProgress\getNodeId(), ilPRGProgress\getStatus(), ilPRGProgress\getValidityOfQualification(), ilPRGProgress\hasIndividualModifications(), and ilPRGProgress\isInvalidated().

Referenced by store().

      {
        //TODO: move into type?
        $lastchange = is_null($pgs->getLastChange()) ? 'NULL' : $this->db->quote($pgs->getLastChange()->format(ilPRGProgress::DATE_TIME_FORMAT), 'text');
        $assign_date = is_null($pgs->getAssignmentDate()) ? 'NULL' : $this->db->quote($pgs->getAssignmentDate()->format(ilPRGProgress::DATE_TIME_FORMAT), 'text');
        $completion_date = is_null($pgs->getCompletionDate()) ? 'NULL' : $this->db->quote($pgs->getCompletionDate()->format(ilPRGProgress::DATE_TIME_FORMAT), 'text');
        $deadline = is_null($pgs->getDeadline()) ? 'NULL' : $this->db->quote($pgs->getDeadline()->format(ilPRGProgress::DATE_FORMAT), 'text');
        $validity = is_null($pgs->getValidityOfQualification()) ? 'NULL' : $this->db->quote($pgs->getValidityOfQualification()->format(ilPRGProgress::DATE_FORMAT), 'text');
        $invalidated = $pgs->isInvalidated() ? 1 : 0;
        $individual = $pgs->hasIndividualModifications() ? 1 : 0;
        $completion = $pgs->getCompletionBy() ?? 'NULL';

        $q = 'INSERT INTO ' . self::PROGRESS_TABLE
            . '('
            . self::PROGRESS_FIELD_ASSIGNMENT_ID . ','
            . self::PROGRESS_FIELD_USR_ID . ','
            . self::PROGRESS_FIELD_PRG_ID . ','

            . self::PROGRESS_FIELD_STATUS . ','
            . self::PROGRESS_FIELD_POINTS . ','
            . self::PROGRESS_FIELD_POINTS_CUR . ','
            . self::PROGRESS_FIELD_COMPLETION_BY . ','
            . self::PROGRESS_FIELD_LAST_CHANGE_BY . ','
            . self::PROGRESS_FIELD_LAST_CHANGE . ','
            . self::PROGRESS_FIELD_ASSIGNMENT_DATE . ','
            . self::PROGRESS_FIELD_COMPLETION_DATE . ','
            . self::PROGRESS_FIELD_DEADLINE . ','
            . self::PROGRESS_FIELD_VQ_DATE . ','
            . self::PROGRESS_FIELD_INVALIDATED . ','
            . self::PROGRESS_FIELD_IS_INDIVIDUAL

            . PHP_EOL . ') VALUES (' . PHP_EOL
            . $assignment_id
            . ' ,' . $usr_id
            . ' ,' . $pgs->getNodeId()

            . ' ,' . $pgs->getStatus()
            . ' ,' . $pgs->getAmountOfPoints()
            . ' ,' . $pgs->getCurrentAmountOfPoints()
            . ' ,' . $completion
            . ' ,' . $pgs->getLastChangeBy()
            . ' ,' . $lastchange
            . ' ,' . $assign_date
            . ' ,' . $completion_date
            . ' ,' . $deadline
            . ' ,' . $validity
            . ' ,' . $invalidated
            . ' ,' . $individual
            . ')' . PHP_EOL
            . 'ON DUPLICATE KEY UPDATE' . PHP_EOL
            . self::PROGRESS_FIELD_STATUS . '=' . $pgs->getStatus() . ','
            . self::PROGRESS_FIELD_POINTS . '=' . $pgs->getAmountOfPoints() . ','
            . self::PROGRESS_FIELD_POINTS_CUR . '=' . $pgs->getCurrentAmountOfPoints() . ','
            . self::PROGRESS_FIELD_COMPLETION_BY . '=' . $completion . ','
            . self::PROGRESS_FIELD_LAST_CHANGE_BY . '=' . $pgs->getLastChangeBy() . ','
            . self::PROGRESS_FIELD_LAST_CHANGE . '=' . $lastchange . ','
            . self::PROGRESS_FIELD_ASSIGNMENT_DATE . '=' . $assign_date . ','
            . self::PROGRESS_FIELD_COMPLETION_DATE . '=' . $completion_date . ','
            . self::PROGRESS_FIELD_DEADLINE . '=' . $deadline . ','
            . self::PROGRESS_FIELD_VQ_DATE . '=' . $validity . ','
            . self::PROGRESS_FIELD_INVALIDATED . '=' . $invalidated . ','
            . self::PROGRESS_FIELD_IS_INDIVIDUAL . '=' . $individual
            ;
        $this->db->manipulate($q);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

storeRiskyToFailSentFor()

ilPRGAssignmentDBRepository::storeRiskyToFailSentFor

(

ilPRGAssignment

$ass

)

Definition at line 759 of file class.ilPRGAssignmentDBRepository.php.

References ilPRGAssignment\getId(), and ilPRGAssignment\getRootId().

                                                                 : void
    {
        $where = [
            self::PROGRESS_FIELD_ASSIGNMENT_ID => ['integer', $ass->getId()],
            self::PROGRESS_FIELD_PRG_ID => ['integer', $ass->getRootId()]
        ];

        $values = [
            self::PROGRESS_FIELD_MAIL_SENT_RISKYTOFAIL => [
                'timestamp',
                date('Y-m-d H:i:s')
            ]
        ];
        $this->db->update(self::PROGRESS_TABLE, $values, $where);
    }

Here is the call graph for this function:

updateAssignmentRowDB()

ilPRGAssignmentDBRepository::updateAssignmentRowDB ( array  $values )

protected

Definition at line 645 of file class.ilPRGAssignmentDBRepository.php.

Referenced by store().

    {
        $q = 'UPDATE ' . self::ASSIGNMENT_TABLE
            . ' SET'
            . ' ' . self::ASSIGNMENT_FIELD_USR_ID . ' = ' . $this->db->quote($values[self::ASSIGNMENT_FIELD_USR_ID], 'integer')
            . ' ,' . self::ASSIGNMENT_FIELD_ROOT_PRG_ID . ' = ' . $this->db->quote($values[self::ASSIGNMENT_FIELD_ROOT_PRG_ID], 'integer')
            . ' ,' . self::ASSIGNMENT_FIELD_LAST_CHANGE . ' = ' . $this->db->quote($values[self::ASSIGNMENT_FIELD_LAST_CHANGE], 'text')
            . ' ,' . self::ASSIGNMENT_FIELD_LAST_CHANGE_BY . ' = ' . $this->db->quote($values[self::ASSIGNMENT_FIELD_LAST_CHANGE_BY], 'integer')
            . ' ,' . self::ASSIGNMENT_FIELD_RESTART_DATE . ' = ' . $this->db->quote($values[self::ASSIGNMENT_FIELD_RESTART_DATE], 'timestamp')
            . ' ,' . self::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID . ' = ' . $this->db->quote($values[self::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID], 'integer')
            . ' ,' . self::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED . ' = ' . $this->db->quote($values[self::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED], 'integer')
            . ' WHERE ' . self::ASSIGNMENT_FIELD_ID . ' = ' . $this->db->quote($values[self::ASSIGNMENT_FIELD_ID], 'integer');
        $this->db->manipulate($q);
    }

Here is the caller graph for this function:

Field Documentation

$db

ilDBInterface ilPRGAssignmentDBRepository::$db

protected

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

Referenced by __construct().

$events

StudyProgrammeEvents ilPRGAssignmentDBRepository::$events

protected

Definition at line 66 of file class.ilPRGAssignmentDBRepository.php.

Referenced by __construct().

$progresses

array ilPRGAssignmentDBRepository::$progresses = []

protected

<id => ilPRGProgress>

Definition at line 65 of file class.ilPRGAssignmentDBRepository.php.

$settings_repo

ilStudyProgrammeSettingsRepository ilPRGAssignmentDBRepository::$settings_repo

protected

Definition at line 61 of file class.ilPRGAssignmentDBRepository.php.

Referenced by __construct().

$tree

ilTree ilPRGAssignmentDBRepository::$tree

protected

Definition at line 60 of file class.ilPRGAssignmentDBRepository.php.

Referenced by __construct().

ASSIGNMENT_FIELD_ID

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_ID = 'id'

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

ASSIGNMENT_FIELD_LAST_CHANGE

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_LAST_CHANGE = 'last_change'

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

ASSIGNMENT_FIELD_LAST_CHANGE_BY

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_LAST_CHANGE_BY = 'last_change_by'

Definition at line 32 of file class.ilPRGAssignmentDBRepository.php.

ASSIGNMENT_FIELD_MANUALLY_ASSIGNED

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED = 'assigned_manually'

Definition at line 36 of file class.ilPRGAssignmentDBRepository.php.

ASSIGNMENT_FIELD_RESTART_DATE

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_RESTART_DATE = 'restart_date'

Definition at line 33 of file class.ilPRGAssignmentDBRepository.php.

ASSIGNMENT_FIELD_RESTART_MAIL

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_RESTART_MAIL = 'restart_mail_send'

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

ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID = 'restarted_assignment_id'

Definition at line 34 of file class.ilPRGAssignmentDBRepository.php.

ASSIGNMENT_FIELD_ROOT_PRG_ID

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_ROOT_PRG_ID = 'root_prg_id'

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

ASSIGNMENT_FIELD_USR_ID

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_USR_ID = 'usr_id'

Definition at line 29 of file class.ilPRGAssignmentDBRepository.php.

ASSIGNMENT_TABLE

const ilPRGAssignmentDBRepository::ASSIGNMENT_TABLE = 'prg_usr_assignments'

Definition at line 27 of file class.ilPRGAssignmentDBRepository.php.

DATE_FORMAT_ENDOFDAY

const ilPRGAssignmentDBRepository::DATE_FORMAT_ENDOFDAY = 'Y-m-d 23:59:59'

Definition at line 57 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_ASSIGNMENT_DATE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_ASSIGNMENT_DATE = 'assignment_date'

Definition at line 46 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_ASSIGNMENT_ID

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_ASSIGNMENT_ID = 'assignment_id'

Definition at line 39 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_COMPLETION_BY

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_COMPLETION_BY = 'completion_by'

Definition at line 45 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_COMPLETION_DATE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_COMPLETION_DATE = 'completion_date'

Definition at line 49 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_DEADLINE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_DEADLINE = 'deadline'

Definition at line 50 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_INVALIDATED

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_INVALIDATED = 'invalidated'

Definition at line 52 of file class.ilPRGAssignmentDBRepository.php.

Referenced by ilPRGAssignmentFilter\getItemConfig(), and ilPRGAssignmentFilter\toConditions().

PROGRESS_FIELD_IS_INDIVIDUAL

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_IS_INDIVIDUAL = 'individual'

Definition at line 55 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_LAST_CHANGE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_LAST_CHANGE = 'last_change'

Definition at line 47 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_LAST_CHANGE_BY

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_LAST_CHANGE_BY = 'last_change_by'

Definition at line 48 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_MAIL_SENT_RISKYTOFAIL

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_MAIL_SENT_RISKYTOFAIL = 'sent_mail_risky_to_fail'

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

PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE = 'sent_mail_expires'

Definition at line 54 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_POINTS

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_POINTS = 'points'

Definition at line 42 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_POINTS_CUR

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_POINTS_CUR = 'points_cur'

Definition at line 43 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_PRG_ID

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_PRG_ID = 'prg_id'

Definition at line 41 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_STATUS

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS = 'status'

Definition at line 44 of file class.ilPRGAssignmentDBRepository.php.

Referenced by ilPRGAssignmentFilter\getItemConfig(), and ilPRGAssignmentFilter\toConditions().

PROGRESS_FIELD_USR_ID

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_USR_ID = 'usr_id'

Definition at line 40 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_VQ_DATE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_VQ_DATE = 'vq_date'

Definition at line 51 of file class.ilPRGAssignmentDBRepository.php.

Referenced by ilPRGAssignmentFilter\getItemConfig().

PROGRESS_TABLE

const ilPRGAssignmentDBRepository::PROGRESS_TABLE = 'prg_usr_progress'

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

---

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

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