ilPRGAssignmentDBRepository Class Reference

Assignments are relations of users to a PRG; They hold progress-information for (sub-)nodes of the PRG-tree. More...

Inheritance diagram for ilPRGAssignmentDBRepository:

Collaboration diagram for ilPRGAssignmentDBRepository:

Public Member Functions
	__construct (protected ilDBInterface $db, protected ilTree $tree, protected Profile $profile, protected ilStudyProgrammeSettingsRepository $settings_repo, protected PRGEventsDelayed $events, ilExportFieldsInfo $user_field_info)
	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...
	getForUserOnNode (int $usr_id, int $root_prg_obj_id)
	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)
	getLatestAssignment (int $root_prg_obj_id, int $usr_id)
	Get the user's assignment on a prg that was created last. More...
	getLongestValidAssignment (int $root_prg_obj_id, int $usr_id)
	Get the user's assignment on a prg with the longest lasting qualification. More...
	getCertificateRelevantAssignmentIds (int $prg_obj_id, int ... $usr_id)
	createFor (int $prg_obj_id, int $usr_id, int $assigning_usr_id)
	get (int $id)
	store (ilPRGAssignment $assignment)
	delete (ilPRGAssignment $assignment)
	deleteAllAssignmentsForProgrammeId (int $prg_obj_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)
	getDashboardInstancesforUser (int $usr_id)
	getAboutToExpire (array $programmes_and_due, bool $discard_formerly_notified=true)
	getExpiredAndNotInvalidated ()
	getLatestAssignment (int $root_prg_obj_id, int $usr_id)
	Get the user's assignment on a prg that was created last. More...
	getLongestValidAssignment (int $root_prg_obj_id, int $usr_id)
	Get the user's assignment on a prg with the longest lasting qualification. More...

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
array	$user_data_fields
array	$progresses = []
	<id => ilPRGProgress> More...

Detailed Description

Assignments are relations of users to a PRG; They hold progress-information for (sub-)nodes of the PRG-tree.

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

Constructor & Destructor Documentation

__construct()

ilPRGAssignmentDBRepository::__construct	(	protected ilDBInterface	$db,
		protected ilTree	$tree,
		protected Profile	$profile,
		protected ilStudyProgrammeSettingsRepository	$settings_repo,
		protected PRGEventsDelayed	$events,
		ilExportFieldsInfo	$user_field_info
	)

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

      {
        $this->user_data_fields = array_merge(
            array_keys($user_field_info->getSelectableFieldsInfo()),
            ilPRGUserInformation::MANDATORY_FIELDS
        );
    }

References ilExportFieldsInfo\getSelectableFieldsInfo(), and ilPRGUserInformation\MANDATORY_FIELDS.

Here is the call graph for this function:

Member Function Documentation

assignmentByRow()

ilPRGAssignmentDBRepository::assignmentByRow ( array  $row )

protected

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

                                                  : 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;
    }

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

Here is the call graph for this function:

buildProgressByRow()

ilPRGAssignmentDBRepository::buildProgressByRow ( array  $row )

protected

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

                                                     : 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;
    }

References ilPRGProgress\DATE_FORMAT, and ilPRGProgress\DATE_TIME_FORMAT.

buildProgressTreeFor()

ilPRGAssignmentDBRepository::buildProgressTreeFor ( int  $node_obj_id )

protected

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

                                                             : 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;
    }

References $c, and ilContainerReference\_lookupTargetId().

Here is the call graph for this function:

buildUserInformation()

ilPRGAssignmentDBRepository::buildUserInformation ( array  $row )

protected

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

                                                       : ilPRGUserInformation
    {
        $udf_data = $this->profile->getDataFor((int) $row[self::ASSIGNMENT_FIELD_USR_ID]);
        $user_data_values = [];
        foreach ($this->user_data_fields as $field) {
            switch ($field) {
                case 'active':
                    $user_data_values[$field] = (bool) $row[$field];
                    break;
                case 'org_units':
                    //$user_data_values[$field] = ilObjUser::lookupOrgUnitsRepresentation((int) $row[self::ASSIGNMENT_FIELD_USR_ID]);
                    $user_data_values[$field] = $this->interimOrguLookup((int) $row[self::ASSIGNMENT_FIELD_USR_ID]);
                    break;
                case str_starts_with($field, 'udf_'):
                    $udf_field_id = str_replace('udf_', 'f_', $field);
                    $user_data_values[$field] = $udf_data->getAdditionalFieldByIdentifier($udf_field_id);
                    break;
                default:
                    $user_data_values[$field] = $row[$field];
            }
        }
        return new ilPRGUserInformation(
            $user_data_values
        );
    }

References ILIAS\Repository\profile().

Here is the call graph for this function:

count()

ilPRGAssignmentDBRepository::count ( array  $filter )

protected

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

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

References $res.

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 229 of file class.ilPRGAssignmentDBRepository.php.

     : 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);
    }

createFor()

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

Implements PRGAssignmentRepository.

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

     : 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 = [];
 
        $user_data_fields = array_filter(
            $this->user_data_fields,
            static fn($field) => !str_starts_with($field, 'udf_') && $field !== 'org_units'
        );
        $query = 'SELECT ' . implode(',', $user_data_fields) . 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;
    }

delete()

ilPRGAssignmentDBRepository::delete

(

ilPRGAssignment

$assignment

)

Implements PRGAssignmentRepository.

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

                                                       : 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);
    }

References $ass_id.

Referenced by ilObjStudyProgramme\removeMemberFromProgrammes().

Here is the caller graph for this function:

deleteAllAssignmentsForProgrammeId()

ilPRGAssignmentDBRepository::deleteAllAssignmentsForProgrammeId

(

int

$prg_obj_id

)

Implements PRGAssignmentRepository.

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

                                                                       : 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();
    }

deleteAllOrphanedProgresses()

ilPRGAssignmentDBRepository::deleteAllOrphanedProgresses ( )

protected

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

                                                    : 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);
    }

get()

ilPRGAssignmentDBRepository::get

(

int

$id

)

Implements PRGAssignmentRepository.

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

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

References $id.

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 288 of file class.ilPRGAssignmentDBRepository.php.

     : 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;
    }

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 208 of file class.ilPRGAssignmentDBRepository.php.

     : 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;
    }

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 246 of file class.ilPRGAssignmentDBRepository.php.

                                                                                      : 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;
    }

getCertificateRelevantAssignmentIds()

ilPRGAssignmentDBRepository::getCertificateRelevantAssignmentIds	(	int	$prg_obj_id,
		int ...	$usr_id
	)

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

                                                                                        : array
    {
        $query = 'SELECT assignment_id FROM (' . PHP_EOL
            . 'SELECT usr_id, assignment_id, ROW_NUMBER() OVER (' . PHP_EOL
                . 'PARTITION BY usr_id' . PHP_EOL
                . 'ORDER BY' . PHP_EOL
                . 'CASE WHEN vq_date IS NULL THEN 1 ELSE 0 END DESC,' . PHP_EOL
                . 'vq_date DESC,' . PHP_EOL
                . 'completion_date DESC' . PHP_EOL
            . ') AS row_numbers' . PHP_EOL
        . 'FROM prg_usr_progress' . PHP_EOL
        . 'WHERE prg_id = ' . $this->db->quote($prg_obj_id, 'integer') . PHP_EOL
        . 'AND ' . $this->db->in('usr_id', $usr_id, false, 'integer') . PHP_EOL
        . 'AND ' . $this->db->in('status', [ilPRGProgress::STATUS_COMPLETED, ilPRGProgress::STATUS_ACCREDITED], false, 'integer') . PHP_EOL
        . ') ranked ' . PHP_EOL
        . 'WHERE row_numbers = 1';
 
        $res = $this->db->query($query);
        $row = array_map(
            fn($r) => $r['assignment_id'],
            $this->db->fetchAll($res)
        );
 
        return $row;
    }

References $res, ilPRGProgress\STATUS_ACCREDITED, and ilPRGProgress\STATUS_COMPLETED.

getDashboardInstancesforUser()

ilPRGAssignmentDBRepository::getDashboardInstancesforUser

(

int

$usr_id

)

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

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

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

References getForUser().

Here is the call graph for this function:

getExpiredAndNotInvalidated()

ilPRGAssignmentDBRepository::getExpiredAndNotInvalidated

(

)

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

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

                                                 : 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;
    }

References ilPRGProgress\STATUS_ACCREDITED, and ilPRGProgress\STATUS_COMPLETED.

getForUser()

ilPRGAssignmentDBRepository::getForUser

(

int

$usr_id

)

get all assignments for a user

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

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

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

Referenced by getDashboardInstancesforUser().

Here is the caller graph for this function:

getForUserOnNode()

ilPRGAssignmentDBRepository::getForUserOnNode	(	int	$usr_id,
		int	$root_prg_obj_id
	)

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

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

getLatestAssignment()

ilPRGAssignmentDBRepository::getLatestAssignment	(	int	$root_prg_obj_id,
		int	$usr_id
	)

Get the user's assignment on a prg that was created last.

Implements PRGAssignmentRepository.

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

                                                                          : ?ilPRGAssignment
    {
        $assignments = $this->getForUserOnNode($usr_id, $root_prg_obj_id);
        if ($assignments === []) {
            return null;
        }
        usort(
            $assignments,
            fn(ilPRGAssignment $a, ilPRGAssignment $b)
            => $a->getProgressTree()->getAssignmentDate() <=> $b->getProgressTree()->getAssignmentDate()
        );
        $assignments = array_reverse($assignments);
        return current($assignments);
    }

References Vendor\Package\$a, and Vendor\Package\$b.

getLongestValidAssignment()

ilPRGAssignmentDBRepository::getLongestValidAssignment	(	int	$root_prg_obj_id,
		int	$usr_id
	)

Get the user's assignment on a prg with the longest lasting qualification.

If there is more than one assignment with e.g. unlimited qualification, the valid assignment that was created (not finished) last is returned.

Implements PRGAssignmentRepository.

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

                                                                                : ?ilPRGAssignment
    {
        $assignments = $this->getForUserOnNode($usr_id, $root_prg_obj_id);
        if ($assignments === []) {
            return null;
        }
 
        $now = new \DateTimeImmutable();
        $valid = array_filter($assignments, fn($ass) => $ass->getProgressTree()->hasValidQualification($now));
        if ($valid === []) {
            return null;
        }
 
        $unlimited = array_filter($valid, fn($ass) => $ass->getProgressTree()->getValidityOfQualification() === null);
        if ($unlimited !== []) {
            usort(
                $unlimited,
                fn(ilPRGAssignment $a, ilPRGAssignment $b)
                => $a->getProgressTree()->getAssignmentDate() <=> $b->getProgressTree()->getAssignmentDate()
            );
            $unlimited = array_reverse($unlimited);
            return current($unlimited);
        }
 
        usort(
            $valid,
            fn(ilPRGAssignment $a, ilPRGAssignment $b)
            => $a->getProgressTree()->getValidityOfQualification() <=> $b->getProgressTree()->getValidityOfQualification()
        );
        $valid = array_reverse($valid);
        return current($valid);
    }

References Vendor\Package\$a, Vendor\Package\$b, and $valid.

getObjIdFor()

ilPRGAssignmentDBRepository::getObjIdFor ( int  $ref_id )

protected

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

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

References $ref_id, and ilObject\_lookupObjectId().

Here is the call graph for this function:

getPassedDeadline()

ilPRGAssignmentDBRepository::getPassedDeadline

(

\DateTimeImmutable

$deadline

)

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

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

                                                                   : 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;
    }

References ilPRGProgress\DATE_FORMAT, ilPRGProgress\STATUS_ACCREDITED, and ilPRGProgress\STATUS_IN_PROGRESS.

getRefIdFor()

ilPRGAssignmentDBRepository::getRefIdFor ( int  $obj_id )

protected

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

                                               : 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);
    }

References ilObject\_getAllReferences().

Here is the call graph for this function:

getRiskyToFail()

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

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

     : 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;
    }

insertAssignmentRowDB()

ilPRGAssignmentDBRepository::insertAssignmentRowDB ( array  $row )

protected

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

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

interimOrguLookup()

ilPRGAssignmentDBRepository::interimOrguLookup ( int  $usr_id )

protected

Deprecated:

; fix ilObjUser::lookupOrgUnitsRepresentation

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

                                                     : 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);
    }

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

Here is the call graph for this function:

nextId()

ilPRGAssignmentDBRepository::nextId ( )

protected

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

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

prebuildProgressesForAssingment()

ilPRGAssignmentDBRepository::prebuildProgressesForAssingment ( int  $assignment_id )

protected

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

                                                                          : 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;
    }

References $q, and $res.

query()

ilPRGAssignmentDBRepository::query (   $filter )

protected

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

                                     : ilDBStatement
    {
        $user_fields_without_udf = array_filter(
            $this->user_data_fields,
            static fn($field) => !str_starts_with($field, 'udf_') && $field !== 'org_units'
        );
 
        $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(', ', $user_fields_without_udf)
 
            . ' 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;
    }

References $q, and $res.

read()

ilPRGAssignmentDBRepository::read ( array  $filter )

protected

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

                                          : 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;
    }

References $res.

resetExpiryInfoSentFor()

ilPRGAssignmentDBRepository::resetExpiryInfoSentFor

(

ilPRGAssignment

$ass

)

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

                                                                : 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);
    }

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

Here is the call graph for this function:

resetRiskyToFailSentFor()

ilPRGAssignmentDBRepository::resetRiskyToFailSentFor

(

ilPRGAssignment

$ass

)

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

                                                                 : 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);
    }

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

Here is the call graph for this function:

store()

ilPRGAssignmentDBRepository::store

(

ilPRGAssignment

$assignment

)

Implements PRGAssignmentRepository.

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

                                                      : 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();
    }

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

Referenced by ilObjStudyProgramme\removeMemberFromProgrammes().

Here is the call graph for this function:

Here is the caller graph for this function:

storeExpiryInfoSentFor()

ilPRGAssignmentDBRepository::storeExpiryInfoSentFor

(

ilPRGAssignment

$ass

)

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

                                                                : 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);
    }

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

Here is the call graph for this function:

storeProgressRow()

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

protected

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

      {
        //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);
    }

References $q, 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().

Here is the call graph for this function:

storeRiskyToFailSentFor()

ilPRGAssignmentDBRepository::storeRiskyToFailSentFor

(

ilPRGAssignment

$ass

)

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

                                                                 : 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);
    }

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

Here is the call graph for this function:

updateAssignmentRowDB()

ilPRGAssignmentDBRepository::updateAssignmentRowDB ( array  $values )

protected

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

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

References $q.

Field Documentation

$progresses

array ilPRGAssignmentDBRepository::$progresses = []

protected

<id => ilPRGProgress>

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

$user_data_fields

array ilPRGAssignmentDBRepository::$user_data_fields

protected

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

ASSIGNMENT_FIELD_ID

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_ID = 'id'

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

ASSIGNMENT_FIELD_LAST_CHANGE

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_LAST_CHANGE = 'last_change'

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

ASSIGNMENT_FIELD_LAST_CHANGE_BY

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_LAST_CHANGE_BY = 'last_change_by'

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

ASSIGNMENT_FIELD_MANUALLY_ASSIGNED

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_MANUALLY_ASSIGNED = 'assigned_manually'

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

ASSIGNMENT_FIELD_RESTART_DATE

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_RESTART_DATE = 'restart_date'

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

ASSIGNMENT_FIELD_RESTART_MAIL

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_RESTART_MAIL = 'restart_mail_send'

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

ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_RESTARTED_ASSIGNMENT_ID = 'restarted_assignment_id'

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

ASSIGNMENT_FIELD_ROOT_PRG_ID

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_ROOT_PRG_ID = 'root_prg_id'

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

ASSIGNMENT_FIELD_USR_ID

const ilPRGAssignmentDBRepository::ASSIGNMENT_FIELD_USR_ID = 'usr_id'

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

ASSIGNMENT_TABLE

const ilPRGAssignmentDBRepository::ASSIGNMENT_TABLE = 'prg_usr_assignments'

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

DATE_FORMAT_ENDOFDAY

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

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

PROGRESS_FIELD_ASSIGNMENT_DATE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_ASSIGNMENT_DATE = 'assignment_date'

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

PROGRESS_FIELD_ASSIGNMENT_ID

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_ASSIGNMENT_ID = 'assignment_id'

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

PROGRESS_FIELD_COMPLETION_BY

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_COMPLETION_BY = 'completion_by'

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

PROGRESS_FIELD_COMPLETION_DATE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_COMPLETION_DATE = 'completion_date'

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

PROGRESS_FIELD_DEADLINE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_DEADLINE = 'deadline'

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

Referenced by ilPRGAssignmentFilter\getItemConfig().

PROGRESS_FIELD_INVALIDATED

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_INVALIDATED = 'invalidated'

Definition at line 54 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 57 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_LAST_CHANGE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_LAST_CHANGE = 'last_change'

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

PROGRESS_FIELD_LAST_CHANGE_BY

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_LAST_CHANGE_BY = 'last_change_by'

Definition at line 50 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 55 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_MAIL_SENT_WILLEXPIRE = 'sent_mail_expires'

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

PROGRESS_FIELD_POINTS

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_POINTS = 'points'

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

PROGRESS_FIELD_POINTS_CUR

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_POINTS_CUR = 'points_cur'

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

PROGRESS_FIELD_PRG_ID

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_PRG_ID = 'prg_id'

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

PROGRESS_FIELD_STATUS

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS = 'status'

Definition at line 46 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 42 of file class.ilPRGAssignmentDBRepository.php.

PROGRESS_FIELD_VQ_DATE

const ilPRGAssignmentDBRepository::PROGRESS_FIELD_VQ_DATE = 'vq_date'

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

Referenced by ilPRGAssignmentFilter\getItemConfig().

PROGRESS_TABLE

const ilPRGAssignmentDBRepository::PROGRESS_TABLE = 'prg_usr_progress'

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

---

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

• components/ILIAS/StudyProgramme/classes/model/Assignments/class.ilPRGAssignmentDBRepository.php