Inheritance diagram for ilStudyProgrammeProgressDBRepository:

Collaboration diagram for ilStudyProgrammeProgressDBRepository:

Public Member Functions
	__construct (ilDBInterface $db)

	createFor (ilStudyProgrammeSettings $prg, ilStudyProgrammeAssignment $ass)
	Create a record corresponding to a progress and return corresponding object.Will throw if a record allready exists. More...

	read (int $id)
	Load progress belonging to a id.Will throw if the record does not exist yet. More...

	readByIds (int $prg_id, int $assignment_id, int $usr_id)
	Load progress belonging to a prg id and assignment.Will throw if the record does not exist yet. More...

	readByPrgIdAndAssignmentId (int $prg_id, int $assignment_id)
	Load progress belonging to a prg id and assignment.Will throw if the record does not exist yet. More...

	readByPrgIdAndUserId (int $prg_id, int $usr_id)
	Load progress objects belonging to a prg id and a user id. More...

	readByPrgId (int $prg_id)
	Load progress objects belonging to a prg id. More...

	readFirstByPrgId (int $prg_id)

	readByAssignmentId (int $assignment_id)
	Load progress objects belonging to an assignment id.Will throw if the record does not exist yet. More...

	readExpiredSuccessfull ()
	Load all progress objects which are successfull and whose validity is expired. More...

	readPassedDeadline ()
	@inheritDoc More...

	readRiskyToFailInstances ()

	update (ilStudyProgrammeProgress $progress)
	Update record corresponding to progress.Will throw if the record does not exist yet. More...

	delete (ilStudyProgrammeProgress $progress)
	Delete record corresponding to progress.Will throw if the record does not exist yet. More...

	deleteDB (int $id)

	reminderSendFor (int $progress_id)

	createFor (ilStudyProgrammeSettings $prg, ilStudyProgrammeAssignment $ass)
	Create a record corresponding to a progress and return corresponding object. More...

	read (int $id)
	Load progress belonging to a id. More...

	readByIds (int $prg_id, int $assignment_id, int $usr_id)
	Load progress belonging to a prg id and assignment. More...

	readByPrgIdAndAssignmentId (int $prg_id, int $assignment_id)
	Load progress belonging to a prg id and assignment. More...

	readByPrgIdAndUserId (int $prg_id, int $usr_id)
	Load progress objects belonging to a prg id and a user id. More...

	readByPrgId (int $prg_id)
	Load progress objects belonging to a prg id. More...

	readFirstByPrgId (int $prg_id)
	Load the first progress objects belonging to a prg id. More...

	readByAssignmentId (int $assignment_id)
	Load progress objects belonging to an assignment id. More...

	readExpiredSuccessfull ()
	Load all progress objects which are successfull and whose validity is expired. More...

	readRiskyToFailInstances ()

	readPassedDeadline ()

	update (ilStudyProgrammeProgress $progress)
	Update record corresponding to progress. More...

	delete (ilStudyProgrammeProgress $progress)
	Delete record corresponding to progress. More...

Data Fields
const	TABLE = 'prg_usr_progress'

const	FIELD_ID = 'id'

const	FIELD_ASSIGNMENT_ID = 'assignment_id'

const	FIELD_PRG_ID = 'prg_id'

const	FIELD_USR_ID = 'usr_id'

const	FIELD_POINTS = 'points'

const	FIELD_POINTS_CUR = 'points_cur'

const	FIELD_STATUS = 'status'

const	FIELD_COMPLETION_BY = 'completion_by'

const	FIELD_ASSIGNMENT_DATE = 'assignment_date'

const	FIELD_LAST_CHANGE = 'last_change'

const	FIELD_LAST_CHANGE_BY = 'last_change_by'

const	FIELD_COMPLETION_DATE = 'completion_date'

const	FIELD_DEADLINE = 'deadline'

const	FIELD_VQ_DATE = 'vq_date'

const	FIELD_INVALIDATED = 'invalidated'

const	FIELD_MAIL_SEND = 'risky_to_fail_mail_send'

Protected Member Functions
	insertRowDB (array $row)

	updateRowDB (array $data)

	buildByRow (array $row)

	loadByFilter (array $filter)

	loadExpiredSuccessful ()

	loadPassedDeadline ()

	loadRiskyToFailInstance ()

	getSQLHeader ()

	nextId ()

Protected Attributes
	$db

Static Protected Attributes
static	$cache = []

Detailed Description

Definition at line 5 of file class.ilStudyProgrammeProgressDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilStudyProgrammeProgressDBRepository::__construct ( ilDBInterface $db )

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

    {
        $this->db = $db;
    }

References $db.

Member Function Documentation

◆ buildByRow()

ilStudyProgrammeProgressDBRepository::buildByRow ( array $row )

protected

Exceptions

ilException

Definition at line 368 of file class.ilStudyProgrammeProgressDBRepository.php.

                                              : ilStudyProgrammeProgress
    {
        $prgrs = (new ilStudyProgrammeProgress((int) $row[self::FIELD_ID]))
            ->setAssignmentId((int) $row[self::FIELD_ASSIGNMENT_ID])
            ->setNodeId((int) $row[self::FIELD_PRG_ID])
            ->setUserId((int) $row[self::FIELD_USR_ID])
            ->setStatus((int) $row[self::FIELD_STATUS])
            ->setAmountOfPoints((int) $row[self::FIELD_POINTS])
            ->setCurrentAmountOfPoints((int) $row[self::FIELD_POINTS_CUR])
            ->setCompletionBy((int) $row[self::FIELD_COMPLETION_BY])
            ->setDeadline(
                $row[self::FIELD_DEADLINE] ?
                    DateTime::createFromFormat(ilStudyProgrammeProgress::DATE_FORMAT, $row[self::FIELD_DEADLINE]) :
                    null
            )
            ->setAssignmentDate(
                DateTime::createFromFormat(ilStudyProgrammeProgress::DATE_TIME_FORMAT, $row[self::FIELD_ASSIGNMENT_DATE])
            )
            ->setCompletionDate(
                $row[self::FIELD_COMPLETION_DATE] ?
                    DateTime::createFromFormat(ilStudyProgrammeProgress::DATE_TIME_FORMAT, $row[self::FIELD_COMPLETION_DATE]) :
                    null
            )
            ->setLastChange(
                $row[self::FIELD_LAST_CHANGE] ?
                    DateTime::createFromFormat(ilStudyProgrammeProgress::DATE_TIME_FORMAT, $row[self::FIELD_LAST_CHANGE]) :
                    null
            )
            ->setValidityOfQualification(
                $row[self::FIELD_VQ_DATE] ?
                    DateTime::createFromFormat(ilStudyProgrammeProgress::DATE_TIME_FORMAT, $row[self::FIELD_VQ_DATE]) :
                    null
            );
        if ((int) $row[self::FIELD_INVALIDATED] === 1) {
            $prgrs = $prgrs->invalidate();
        }
 
        if (!is_null($row[self::FIELD_LAST_CHANGE_BY])) {
            $prgrs = $prgrs->setLastChangeBy((int) $row[self::FIELD_LAST_CHANGE_BY]);
        }
 
        return $prgrs;
    }

References ilStudyProgrammeProgress\DATE_FORMAT, ilStudyProgrammeProgress\DATE_TIME_FORMAT, and ilStudyProgrammeProgress\invalidate().

Here is the call graph for this function:

◆ createFor()

ilStudyProgrammeProgressDBRepository::createFor	(	ilStudyProgrammeSettings	$prg,
		ilStudyProgrammeAssignment	$ass
	)

Create a record corresponding to a progress and return corresponding object.Will throw if a record allready exists.

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

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

      : ilStudyProgrammeProgress {
        $id = $this->nextId();
        $row = [
            self::FIELD_ID => $id,
            self::FIELD_ASSIGNMENT_ID => $ass->getId(),
            self::FIELD_PRG_ID => $prg->getObjId(),
            self::FIELD_USR_ID => $ass->getUserId(),
            self::FIELD_POINTS => $prg->getAssessmentSettings()->getPoints(),
            self::FIELD_POINTS_CUR => 0,
            self::FIELD_STATUS => ilStudyProgrammeProgress::STATUS_IN_PROGRESS,
            self::FIELD_COMPLETION_BY => null,
            self::FIELD_LAST_CHANGE => ilUtil::now(),
            self::FIELD_ASSIGNMENT_DATE => ilUtil::now(),
            self::FIELD_LAST_CHANGE_BY => null,
            self::FIELD_COMPLETION_DATE => null,
            self::FIELD_DEADLINE => null,
            self::FIELD_VQ_DATE => null,
            self::FIELD_INVALIDATED => 0
        ];
        $this->insertRowDB($row);
        return $this->buildByRow($row);
    }

◆ delete()

ilStudyProgrammeProgressDBRepository::delete ( ilStudyProgrammeProgress $progress )

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

Implements ilStudyProgrammeProgressRepository.

Definition at line 239 of file class.ilStudyProgrammeProgressDBRepository.php.

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

◆ deleteDB()

ilStudyProgrammeProgressDBRepository::deleteDB ( int $id )

Definition at line 268 of file class.ilStudyProgrammeProgressDBRepository.php.

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

◆ getSQLHeader()

ilStudyProgrammeProgressDBRepository::getSQLHeader ( )

protected

Definition at line 502 of file class.ilStudyProgrammeProgressDBRepository.php.

                                      : string
    {
        return 'SELECT ' . self::FIELD_ID
            . ', ' . self::FIELD_ASSIGNMENT_ID
            . ', ' . self::FIELD_PRG_ID
            . ', ' . self::FIELD_USR_ID
            . ', ' . self::FIELD_STATUS
            . ', ' . self::FIELD_POINTS
            . ', ' . self::FIELD_POINTS_CUR
            . ', ' . self::FIELD_COMPLETION_BY
            . ', ' . self::FIELD_LAST_CHANGE
            . ', ' . self::FIELD_LAST_CHANGE_BY
            . ', ' . self::FIELD_ASSIGNMENT_DATE
            . ', ' . self::FIELD_COMPLETION_DATE
            . ', ' . self::FIELD_DEADLINE
            . ', ' . self::FIELD_VQ_DATE
            . ', ' . self::FIELD_INVALIDATED
            . ' FROM ' . self::TABLE;
    }

◆ insertRowDB()

ilStudyProgrammeProgressDBRepository::insertRowDB ( array $row )

protected

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

    {
        $this->db->insert(
            self::TABLE,
            [
                self::FIELD_ID => ['integer', $row[self::FIELD_ID]]
                , self::FIELD_ASSIGNMENT_ID => ['integer', $row[self::FIELD_ASSIGNMENT_ID]]
                , self::FIELD_PRG_ID => ['integer', $row[self::FIELD_PRG_ID]]
                , self::FIELD_USR_ID => ['integer', $row[self::FIELD_USR_ID]]
                , self::FIELD_STATUS => ['integer', $row[self::FIELD_STATUS]]
                , self::FIELD_POINTS => ['integer', $row[self::FIELD_POINTS]]
                , self::FIELD_POINTS_CUR => ['integer', $row[self::FIELD_POINTS_CUR]]
                , self::FIELD_COMPLETION_BY => ['integer', $row[self::FIELD_COMPLETION_BY]]
                , self::FIELD_LAST_CHANGE_BY => ['integer', $row[self::FIELD_LAST_CHANGE_BY]]
                , self::FIELD_LAST_CHANGE => ['text', $row[self::FIELD_LAST_CHANGE]]
                , self::FIELD_ASSIGNMENT_DATE => ['timestamp', $row[self::FIELD_ASSIGNMENT_DATE]]
                , self::FIELD_COMPLETION_DATE => ['timestamp', $row[self::FIELD_COMPLETION_DATE]]
                , self::FIELD_DEADLINE => ['text', $row[self::FIELD_DEADLINE]]
                , self::FIELD_VQ_DATE => ['timestamp', $row[self::FIELD_VQ_DATE]]
                , self::FIELD_INVALIDATED => ['timestamp', $row[self::FIELD_INVALIDATED]]
            ]
        );
    }

◆ loadByFilter()

ilStudyProgrammeProgressDBRepository::loadByFilter ( array $filter )

protected

Definition at line 412 of file class.ilStudyProgrammeProgressDBRepository.php.

    {
        $q = $this->getSQLHeader()
            . ' WHERE TRUE';
        foreach ($filter as $field => $value) {
            $q .= '     AND ' . $field . ' = ' . $this->db->quote($value, 'text');
        }
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

References $res.

◆ loadExpiredSuccessful()

ilStudyProgrammeProgressDBRepository::loadExpiredSuccessful ( )

protected

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

    {
        $q = $this->getSQLHeader()
            . ' WHERE ' . $this->db->in(
                self::FIELD_STATUS,
                [
                    ilStudyProgrammeProgress::STATUS_ACCREDITED,
                    ilStudyProgrammeProgress::STATUS_COMPLETED
                ],
                false,
                'integer'
            )
            . '     AND ' . self::FIELD_VQ_DATE . ' IS NOT NULL'
            . '     AND DATE(' . self::FIELD_VQ_DATE . ') < '
            . $this->db->quote(
                (new DateTime())->format(ilStudyProgrammeProgress::DATE_FORMAT),
                'text'
            )
            . '    AND ' . self::FIELD_INVALIDATED . ' != 1 OR ' . self::FIELD_INVALIDATED . ' IS NULL';
 
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

References $res, ilStudyProgrammeProgress\DATE_FORMAT, ilStudyProgrammeProgress\STATUS_ACCREDITED, and ilStudyProgrammeProgress\STATUS_COMPLETED.

◆ loadPassedDeadline()

ilStudyProgrammeProgressDBRepository::loadPassedDeadline ( )

protected

Definition at line 451 of file class.ilStudyProgrammeProgressDBRepository.php.

    {
        $q =
             $this->getSQLHeader() . PHP_EOL
            . 'WHERE ' . $this->db->in(
                self::FIELD_STATUS,
                [
                    ilStudyProgrammeProgress::STATUS_IN_PROGRESS,
                    ilStudyProgrammeProgress::STATUS_ACCREDITED
                ],
                false,
                'integer'
             ) . PHP_EOL
            . 'AND ' . self::FIELD_DEADLINE . ' IS NOT NULL' . PHP_EOL
            . 'AND DATE(' . self::FIELD_DEADLINE . ') < ' . $this->db->quote(
                (new DateTime())->format(ilStudyProgrammeProgress::DATE_FORMAT),
                'text'
             ) . PHP_EOL
        ;
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

References $res, ilStudyProgrammeProgress\DATE_FORMAT, ilStudyProgrammeProgress\STATUS_ACCREDITED, and ilStudyProgrammeProgress\STATUS_IN_PROGRESS.

◆ loadRiskyToFailInstance()

ilStudyProgrammeProgressDBRepository::loadRiskyToFailInstance ( )

protected

Definition at line 476 of file class.ilStudyProgrammeProgressDBRepository.php.

    {
        $q = $this->getSQLHeader()
            . ' WHERE ' . $this->db->in(
                self::FIELD_STATUS,
                [
                    ilStudyProgrammeProgress::STATUS_ACCREDITED,
                    ilStudyProgrammeProgress::STATUS_COMPLETED
                ],
                true,
                'integer'
            )
            . '     AND ' . self::FIELD_DEADLINE . ' IS NOT NULL'
            . '     AND DATE(' . self::FIELD_DEADLINE . ') < '
            . $this->db->quote(
                (new DateTime())->format(ilStudyProgrammeProgress::DATE_FORMAT),
                'text'
            )
            . '    AND ' . self::FIELD_MAIL_SEND . ' IS NULL'
        ;
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

References $res, ilStudyProgrammeProgress\DATE_FORMAT, ilStudyProgrammeProgress\STATUS_ACCREDITED, and ilStudyProgrammeProgress\STATUS_COMPLETED.

◆ nextId()

ilStudyProgrammeProgressDBRepository::nextId ( )

protected

Definition at line 522 of file class.ilStudyProgrammeProgressDBRepository.php.

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

◆ read()

ilStudyProgrammeProgressDBRepository::read ( int $id )

Load progress belonging to a id.Will throw if the record does not exist yet.

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

Definition at line 70 of file class.ilStudyProgrammeProgressDBRepository.php.

                                  : ilStudyProgrammeProgress
    {
        foreach ($this->loadByFilter([self::FIELD_ID => $id]) as $row) {
            return $this->buildByRow($row);
        }
        throw new ilException('invalid id ' . $id);
    }

◆ readByAssignmentId()

ilStudyProgrammeProgressDBRepository::readByAssignmentId ( int $assignment_id )

Load progress objects belonging to an assignment id.Will throw if the record does not exist yet.

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

Definition at line 157 of file class.ilStudyProgrammeProgressDBRepository.php.

                                                           : array
    {
        $return = [];
        foreach ($this->loadByFilter([self::FIELD_ASSIGNMENT_ID => $assignment_id]) as $row) {
            $return[] = $this->buildByRow($row);
        }
        return $return;
    }

◆ readByIds()

ilStudyProgrammeProgressDBRepository::readByIds	(	int	$prg_id,
		int	$assignment_id,
		int	$usr_id
	)

Load progress belonging to a prg id and assignment.Will throw if the record does not exist yet.

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

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

      : ilStudyProgrammeProgress {
        return $this->readByPrgIdAndAssignmentId($prg_id, $assignment_id);
    }

◆ readByPrgId()

ilStudyProgrammeProgressDBRepository::readByPrgId ( int $prg_id )

Load progress objects belonging to a prg id.

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

Definition at line 132 of file class.ilStudyProgrammeProgressDBRepository.php.

                                             : array
    {
        $return = [];
        foreach ($this->loadByFilter([self::FIELD_PRG_ID => $prg_id]) as $row) {
            $return[] = $this->buildByRow($row);
        }
        return $return;
    }

◆ readByPrgIdAndAssignmentId()

ilStudyProgrammeProgressDBRepository::readByPrgIdAndAssignmentId	(	int	$prg_id,
		int	$assignment_id
	)

Load progress belonging to a prg id and assignment.Will throw if the record does not exist yet.

Exceptions

ilException

Returns: ilStudyProgrammeProgress | void

Implements ilStudyProgrammeProgressRepository.

Definition at line 99 of file class.ilStudyProgrammeProgressDBRepository.php.

    {
        $rows = $this->loadByFilter(
            [
                self::FIELD_PRG_ID => $prg_id,
                self::FIELD_ASSIGNMENT_ID => $assignment_id
            ]
        );
 
        foreach ($rows as $row) {
            return $this->buildByRow($row);
        }
    }

References $rows.

◆ readByPrgIdAndUserId()

ilStudyProgrammeProgressDBRepository::readByPrgIdAndUserId	(	int	$prg_id,
		int	$usr_id
	)

Load progress objects belonging to a prg id and a user id.

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

Definition at line 118 of file class.ilStudyProgrammeProgressDBRepository.php.

                                                                   : array
    {
        $return = [];
        foreach ($this->loadByFilter([self::FIELD_PRG_ID => $prg_id, self::FIELD_USR_ID => $usr_id]) as $row) {
            $return[] = $this->buildByRow($row);
        }
        return $return;
    }

◆ readExpiredSuccessfull()

ilStudyProgrammeProgressDBRepository::readExpiredSuccessfull ( )

Load all progress objects which are successfull and whose validity is expired.

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

Definition at line 171 of file class.ilStudyProgrammeProgressDBRepository.php.

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

◆ readFirstByPrgId()

ilStudyProgrammeProgressDBRepository::readFirstByPrgId ( int $prg_id )

Returns: ilStudyProgrammeProgress | void

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

Definition at line 145 of file class.ilStudyProgrammeProgressDBRepository.php.

    {
        foreach ($this->loadByFilter([self::FIELD_PRG_ID => $prg_id]) as $row) {
            return $this->buildByRow($row);
        }
    }

◆ readPassedDeadline()

ilStudyProgrammeProgressDBRepository::readPassedDeadline ( )

@inheritDoc

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

Definition at line 185 of file class.ilStudyProgrammeProgressDBRepository.php.

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

◆ readRiskyToFailInstances()

ilStudyProgrammeProgressDBRepository::readRiskyToFailInstances ( )

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

Definition at line 199 of file class.ilStudyProgrammeProgressDBRepository.php.

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

◆ reminderSendFor()

ilStudyProgrammeProgressDBRepository::reminderSendFor ( int $progress_id )

Definition at line 275 of file class.ilStudyProgrammeProgressDBRepository.php.

                                                      : void
    {
        $where = [
            self::FIELD_ID => [
                'integer',
                $progress_id
            ]
        ];
 
        $values = [
            self::FIELD_MAIL_SEND => [
                'timestamp',
                date('Y-m-d H:i:s')
            ]
        ];
 
        $this->db->update(self::TABLE, $values, $where);
    }

◆ update()

ilStudyProgrammeProgressDBRepository::update ( ilStudyProgrammeProgress $progress )

Update record corresponding to progress.Will throw if the record does not exist yet.

Implements ilStudyProgrammeProgressRepository.

Definition at line 211 of file class.ilStudyProgrammeProgressDBRepository.php.

    {
        $this->updateRowDB(
            [
                self::FIELD_ID => $progress->getId(),
                self::FIELD_ASSIGNMENT_ID => $progress->getAssignmentId(),
                self::FIELD_PRG_ID => $progress->getNodeId(),
                self::FIELD_USR_ID => $progress->getUserId(),
                self::FIELD_STATUS => $progress->getStatus(),
                self::FIELD_POINTS => $progress->getAmountOfPoints(),
                self::FIELD_POINTS_CUR => $progress->getCurrentAmountOfPoints(),
                self::FIELD_COMPLETION_BY => $progress->getCompletionBy(),
                self::FIELD_LAST_CHANGE_BY => $progress->getLastChangeBy(),
                self::FIELD_LAST_CHANGE => $progress->getLastChange()->format(ilStudyProgrammeProgress::DATE_TIME_FORMAT),
                self::FIELD_ASSIGNMENT_DATE => $progress->getAssignmentDate()->format(ilStudyProgrammeProgress::DATE_TIME_FORMAT),
                self::FIELD_COMPLETION_DATE =>
                    $progress->getCompletionDate() ?
                        $progress->getCompletionDate()->format(ilStudyProgrammeProgress::DATE_TIME_FORMAT) : null,
                self::FIELD_DEADLINE => $progress->getDeadline() ? $progress->getDeadline()->format(ilStudyProgrammeProgress::DATE_FORMAT) : null,
                self::FIELD_VQ_DATE => $progress->getValidityOfQualification() ? $progress->getValidityOfQualification()->format(ilStudyProgrammeProgress::DATE_TIME_FORMAT) : null,
                self::FIELD_INVALIDATED => $progress->isInvalidated() ? 1 : 0
            ]
        );
    }

Here is the call graph for this function:

◆ updateRowDB()

ilStudyProgrammeProgressDBRepository::updateRowDB ( array $data )

protected

Definition at line 294 of file class.ilStudyProgrammeProgressDBRepository.php.

    {
        $where = [
            self::FIELD_ID => [
                'integer',
                $data[self::FIELD_ID]
            ]
        ];
 
        $values = [
            self::FIELD_ASSIGNMENT_ID => [
                'integer',
                $data[self::FIELD_ASSIGNMENT_ID]
            ],
            self::FIELD_PRG_ID => [
                'integer',
                $data[self::FIELD_PRG_ID]
            ],
            self::FIELD_USR_ID => [
                'integer',
                $data[self::FIELD_USR_ID]
            ],
            self::FIELD_STATUS => [
                'integer',
                $data[self::FIELD_STATUS]
            ],
            self::FIELD_POINTS => [
                'integer',
                $data[self::FIELD_POINTS]
            ],
            self::FIELD_POINTS_CUR => [
                'integer',
                $data[self::FIELD_POINTS_CUR]
            ],
            self::FIELD_COMPLETION_BY => [
                'integer',
                $data[self::FIELD_COMPLETION_BY]
            ],
            self::FIELD_LAST_CHANGE_BY => [
                'integer',
                $data[self::FIELD_LAST_CHANGE_BY]
            ],
            self::FIELD_LAST_CHANGE => [
                'text',
                $data[self::FIELD_LAST_CHANGE]
            ],
            self::FIELD_ASSIGNMENT_DATE => [
                'timestamp',
                $data[self::FIELD_ASSIGNMENT_DATE]
            ],
            self::FIELD_COMPLETION_DATE => [
                'timestamp',
                $data[self::FIELD_COMPLETION_DATE]
            ],
            self::FIELD_DEADLINE => [
                'text',
                $data[self::FIELD_DEADLINE]
            ],
            self::FIELD_VQ_DATE => [
                'timestamp',
                $data[self::FIELD_VQ_DATE]
            ],
            self::FIELD_INVALIDATED => [
                'integer',
                $data[self::FIELD_INVALIDATED]
            ],
        ];
 
        $this->db->update(self::TABLE, $values, $where);
    }