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 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)

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

Constructor & Destructor Documentation

__construct()

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

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

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

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

Here is the call graph for this function:

Member Function Documentation

assignmentByRow()

ilPRGAssignmentDBRepository::assignmentByRow ( array  $row )

protected

Definition at line 485 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 558 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 520 of file class.ilPRGAssignmentDBRepository.php.

References Vendor\Package\$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 621 of file class.ilPRGAssignmentDBRepository.php.

References interimOrguLookup().

Referenced by assignmentByRow().

                                                       : ilPRGUserInformation
    {
        $udf_data = new ilUserDefinedData((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->get($udf_field_id);
                    break;
                default:
                    $user_data_values[$field] = $row[$field];
            }
        }
        return new ilPRGUserInformation(
            $user_data_values
        );
    }

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 447 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 230 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 86 of file class.ilPRGAssignmentDBRepository.php.

References Vendor\Package\$f, $res, ilObject\_lookupType(), assignmentByRow(), 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 = [];

        $user_fields = array_filter(
            $this->user_data_fields,
            fn($f) => !str_starts_with($f, 'udf_') && $f !== 'org_units'
        );

        $query = 'SELECT '
            . implode(',', $user_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;
    }

Here is the call graph for this function:

delete()

ilPRGAssignmentDBRepository::delete

(

ilPRGAssignment

$assignment

)

Implements PRGAssignmentRepository.

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

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

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

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 179 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 289 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 209 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 247 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:

getCertificateRelevantAssignmentIds()

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

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

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

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

getDashboardInstancesforUser()

ilPRGAssignmentDBRepository::getDashboardInstancesforUser

(

int

$usr_id

)

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

Definition at line 79 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

(

)

Returns

ilPRGAssignment[]

Implements PRGAssignmentRepository.

Definition at line 324 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 188 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:

getForUserOnNode()

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

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

References read().

Referenced by getLatestAssignment(), and getLongestValidAssignment().

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

Here is the call graph for this function:

Here is the caller graph for this function:

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

References Vendor\Package\$a, Vendor\Package\$b, getForUserOnNode(), and ilPRGAssignment\getProgressTree().

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

Here is the call graph for this function:

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

References Vendor\Package\$a, Vendor\Package\$b, $valid, getForUserOnNode(), and ilPRGAssignment\getProgressTree().

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

Here is the call graph for this function:

getObjIdFor()

ilPRGAssignmentDBRepository::getObjIdFor ( int  $ref_id )

protected

Definition at line 553 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 262 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 545 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 348 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 647 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 604 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 442 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 474 of file class.ilPRGAssignmentDBRepository.php.

References $q, $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 393 of file class.ilPRGAssignmentDBRepository.php.

References $q, and $res.

Referenced by count(), and read().

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

Here is the caller graph for this function:

read()

ilPRGAssignmentDBRepository::read ( array  $filter )

protected

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

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

Referenced by get(), getAboutToExpire(), getAllForNodeIsContained(), getAllForSpecificNode(), getExpiredAndNotInvalidated(), getForUser(), getForUserOnNode(), 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 764 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 793 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 125 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 748 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 679 of file class.ilPRGAssignmentDBRepository.php.

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().

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

References $q.

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

$progresses

array ilPRGAssignmentDBRepository::$progresses = []

protected

<id => ilPRGProgress>

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

$user_data_fields

array ilPRGAssignmentDBRepository::$user_data_fields

protected

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

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.

Referenced by ilPRGAssignmentFilter\getItemConfig().

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