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

	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)

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.

References $db.

     {
         $this->db = $db;
     }

Member Function Documentation

◆ buildByRow()

ilStudyProgrammeProgressDBRepository::buildByRow ( array $row )

protected

Exceptions

ilException

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

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

Referenced by createFor(), read(), readByAssignmentId(), readByPrgId(), readByPrgIdAndAssignmentId(), readByPrgIdAndUserId(), readExpiredSuccessfull(), readFirstByPrgId(), readPassedDeadline(), and readRiskyToFailInstances().

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

Here is the call graph for this function:

Here is the caller 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.

References buildByRow(), ilStudyProgrammeSettings\getAssessmentSettings(), ilStudyProgrammeAssignment\getId(), ilStudyProgrammeSettings\getObjId(), ilStudyProgrammeAssignment\getUserId(), insertRowDB(), nextId(), ilUtil\now(), and ilStudyProgrammeProgress\STATUS_IN_PROGRESS.

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

Here is the call graph for this function:

◆ 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.

References deleteDB().

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

Here is the call graph for this function:

◆ deleteDB()

ilStudyProgrammeProgressDBRepository::deleteDB ( int $id )

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

Referenced by delete().

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

Here is the caller graph for this function:

◆ getSQLHeader()

ilStudyProgrammeProgressDBRepository::getSQLHeader ( )

protected

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

Referenced by loadByFilter(), loadExpiredSuccessful(), loadPassedDeadline(), and loadRiskyToFailInstance().

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

Here is the caller graph for this function:

◆ insertRowDB()

ilStudyProgrammeProgressDBRepository::insertRowDB ( array $row )

protected

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

Referenced by createFor().

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

Here is the caller graph for this function:

◆ loadByFilter()

ilStudyProgrammeProgressDBRepository::loadByFilter ( array $filter )

protected

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

References $res, and getSQLHeader().

Referenced by read(), readByAssignmentId(), readByPrgId(), readByPrgIdAndAssignmentId(), readByPrgIdAndUserId(), and readFirstByPrgId().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadExpiredSuccessful()

ilStudyProgrammeProgressDBRepository::loadExpiredSuccessful ( )

protected

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

References $res, ilStudyProgrammeProgress\DATE_FORMAT, getSQLHeader(), ilStudyProgrammeProgress\STATUS_ACCREDITED, and ilStudyProgrammeProgress\STATUS_COMPLETED.

Referenced by readExpiredSuccessfull().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadPassedDeadline()

ilStudyProgrammeProgressDBRepository::loadPassedDeadline ( )

protected

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

References $res, ilStudyProgrammeProgress\DATE_FORMAT, getSQLHeader(), ilStudyProgrammeProgress\STATUS_ACCREDITED, and ilStudyProgrammeProgress\STATUS_IN_PROGRESS.

Referenced by readPassedDeadline().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadRiskyToFailInstance()

ilStudyProgrammeProgressDBRepository::loadRiskyToFailInstance ( )

protected

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

References $res, ilStudyProgrammeProgress\DATE_FORMAT, getSQLHeader(), ilStudyProgrammeProgress\STATUS_ACCREDITED, and ilStudyProgrammeProgress\STATUS_COMPLETED.

Referenced by readRiskyToFailInstances().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ nextId()

ilStudyProgrammeProgressDBRepository::nextId ( )

protected

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

Referenced by createFor().

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

Here is the caller graph for this function:

◆ 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.

References buildByRow(), and loadByFilter().

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

Here is the call graph for this function:

◆ 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.

References buildByRow(), and loadByFilter().

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

Here is the call graph for this function:

◆ 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.

References readByPrgIdAndAssignmentId().

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

Here is the call graph for this function:

◆ 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.

References buildByRow(), and loadByFilter().

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

Here is the call graph for this function:

◆ 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.

References $rows, buildByRow(), and loadByFilter().

Referenced by readByIds().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ 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.

References buildByRow(), and loadByFilter().

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

Here is the call graph for this function:

◆ 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.

References buildByRow(), and loadExpiredSuccessful().

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

Here is the call graph for this function:

◆ readFirstByPrgId()

ilStudyProgrammeProgressDBRepository::readFirstByPrgId ( int $prg_id )

Returns: ilStudyProgrammeProgress | void

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

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

References buildByRow(), and loadByFilter().

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

Here is the call graph for this function:

◆ readPassedDeadline()

ilStudyProgrammeProgressDBRepository::readPassedDeadline ( )

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

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

References buildByRow(), and loadPassedDeadline().

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

Here is the call graph for this function:

◆ readRiskyToFailInstances()

ilStudyProgrammeProgressDBRepository::readRiskyToFailInstances ( )

Exceptions

ilException

Implements ilStudyProgrammeProgressRepository.

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

References buildByRow(), and loadRiskyToFailInstance().

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

Here is the call graph for this function:

◆ 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.

Referenced by update().

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