Inheritance diagram for ilStudyProgrammeSettingsDBRepository:

Collaboration diagram for ilStudyProgrammeSettingsDBRepository:

Public Member Functions
	__construct (ilDBInterface $db)

	createFor (int $obj_id)
	Create a record corresponding to a SP-Object and return representing settings.Will throw if a record allready exists. More...

	read (int $obj_id)
	Load settings belonging to a SP-Object.Will throw if the record does not exist yet. More...

	update (ilStudyProgrammeSettings $settings)
	Update settings belonging to a SP-Object.Will throw if the record does not exist yet. More...

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

	loadByType (int $type_id)
	Load SP settings by assigned type. More...

	loadIdsByType (int $type_id)
	Load SP setting-ids by assigned type. More...

	createFor (int $obj_id)
	Create a record corresponding to a SP-Object and return representing settings. More...

	read (int $obj_id)
	Load settings belonging to a SP-Object. More...

	update (ilStudyProgrammeSettings $settings)
	Update settings belonging to a SP-Object. More...

	delete (ilStudyProgrammeSettings $settings)
	Delete record corresponding to settings. More...

	loadByType (int $type_id)
	Load SP settings by assigned type. More...

	loadIdsByType (int $type_id)
	Load SP setting-ids by assigned type. More...

Static Public Member Functions
static	clearCache ()

Data Fields
const	TABLE = 'prg_settings'

const	FIELD_OBJ_ID = 'obj_id'

const	FIELD_SUBTYPE_ID = 'subtype_id'

const	FIELD_STATUS = 'status'

const	FIELD_LP_MODE = 'lp_mode'

const	FIELD_POINTS = 'points'

const	FIELD_LAST_CHANGED = 'last_change'

const	FIELD_DEADLINE_PERIOD = 'deadline_period'

const	FIELD_DEADLINE_DATE = 'deadline_date'

const	FIELD_VALIDITY_QUALIFICATION_DATE = 'vq_date'

const	FIELD_VALIDITY_QUALIFICATION_PERIOD = 'vq_period'

const	FIELD_VQ_RESTART_PERIOD = 'vq_restart_period'

const	FIELD_RM_NOT_RESTARTED_BY_USER_DAY = 'rm_nr_by_usr_days'

const	FIELD_PROC_ENDS_NOT_SUCCESSFUL = 'proc_end_no_success'

const	FIELD_SEND_RE_ASSIGNED_MAIL = "send_re_assigned_mail"

const	FIELD_SEND_INFO_TO_RE_ASSIGN_MAIL = "send_info_to_re_assign_mail"

const	FIELD_SEND_RISKY_TO_FAIL_MAIL = "send_risky_to_fail_mail"

Protected Member Functions
	insertDB (int $obj_id, int $subtype_id, int $status, int $lp_mode, int $points, string $last_change, int $deadline_period, int $vq_period, int $vq_restart_period, string $deadline_date=null, string $vq_date=null, int $rm_nr_by_usr_days=null, int $proc_end_no_success=null, bool $send_re_assigned_mail=false, bool $send_info_to_re_assign_mail=false, bool $send_risky_to_fail_mail=false)

	loadDB (int $obj_id)

	createByRow (array $row)

	deleteDB (int $obj_id)

	updateDB (int $obj_id, int $subtype_id, int $status, int $lp_mode, int $points, string $last_change, int $deadline_period, int $vq_period, int $vq_restart_period, string $deadline_date=null, string $vq_date=null, int $rm_nr_by_usr_days=null, int $proc_end_no_success=null, bool $send_re_assigned_mail=false, bool $send_info_to_re_assign_mail=false, bool $send_risky_to_fail_mail=false)
	@pthrows LogicException More...

	checkExists (int $obj_id)

Protected Attributes
	$db

Static Protected Attributes
static	$cache = []

Detailed Description

Definition at line 8 of file class.ilStudyProgrammeSettingsDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilStudyProgrammeSettingsDBRepository::__construct ( ilDBInterface $db )

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

    {
        $this->db = $db;
    }

References $db.

Member Function Documentation

◆ checkExists()

ilStudyProgrammeSettingsDBRepository::checkExists ( int $obj_id )

protected

Definition at line 486 of file class.ilStudyProgrammeSettingsDBRepository.php.

    {
        $rec = $this->db->fetchAssoc(
            $this->db->query(
                'SELECT ' . self::FIELD_OBJ_ID
                . '     FROM ' . self::TABLE
                . '     WHERE ' . self::FIELD_OBJ_ID . ' = ' . $this->db->quote($obj_id, 'integer')
            )
        );
        if ($rec) {
            return true;
        }
        return false;
    }

Referenced by deleteDB(), and updateDB().

Here is the caller graph for this function:

◆ clearCache()

static ilStudyProgrammeSettingsDBRepository::clearCache ( )

static

Definition at line 501 of file class.ilStudyProgrammeSettingsDBRepository.php.

    {
        self::$cache = [];
    }

Referenced by ilStudyProgrammeSettingsRepositoryTest\test_edit_and_update().

Here is the caller graph for this function:

◆ createByRow()

ilStudyProgrammeSettingsDBRepository::createByRow ( array $row )

protected

Exceptions

ilException

Definition at line 279 of file class.ilStudyProgrammeSettingsDBRepository.php.

                                               : ilStudyProgrammeSettings
    {
        $type_settings = new \ilStudyProgrammeTypeSettings(
            ilStudyProgrammeSettings::DEFAULT_SUBTYPE
        );
        $assessment_settings = new \ilStudyProgrammeAssessmentSettings(
            ilStudyProgrammeSettings::DEFAULT_POINTS,
            ilStudyProgrammeSettings::STATUS_DRAFT
        );
        $deadline_settings = new \ilStudyProgrammeDeadlineSettings(null, null);
        $validity_of_achieved_qualification_settings =
            new \ilStudyProgrammeValidityOfAchievedQualificationSettings(null, null, null)
        ;
        $automail = new \ilStudyProgrammeAutoMailSettings(false, null, null);
 
        $prg = new ilStudyProgrammeSettings(
            (int) $row[self::FIELD_OBJ_ID],
            $type_settings,
            $assessment_settings,
            $deadline_settings,
            $validity_of_achieved_qualification_settings,
            $automail
        );
 
        $return = $prg
            ->setLPMode((int) $row[self::FIELD_LP_MODE])
            ->setLastChange(DateTime::createFromFormat(
                ilStudyProgrammeSettings::DATE_TIME_FORMAT,
                $row[self::FIELD_LAST_CHANGED]
            ))
        ;
 
        $type = $return->getTypeSettings();
        $type = $type->withTypeId((int) $row['subtype_id']);
        $return = $return->withTypeSettings($type);
 
        $points = $return->getAssessmentSettings();
        $points = $points->withPoints((int) $row['points'])->withStatus((int) $row['status']);
        $return = $return->withAssessmentSettings($points);
 
        $deadline = $return->getDeadlineSettings();
        if ($row[self::FIELD_DEADLINE_DATE] !== null) {
            $deadline = $deadline->withDeadlineDate(DateTime::createFromFormat(
                ilStudyProgrammeSettings::DATE_TIME_FORMAT,
                $row[self::FIELD_DEADLINE_DATE]
            ))
            ;
        } else {
            $deadline_period = (int) $row[self::FIELD_DEADLINE_PERIOD];
            if ($deadline_period == -1) {
                $deadline_period = null;
            }
            $deadline = $deadline->withDeadlinePeriod($deadline_period);
        }
        $return = $return->withDeadlineSettings($deadline);
 
        $vqs = $return->getValidityOfQualificationSettings();
        if ($row[self::FIELD_VALIDITY_QUALIFICATION_DATE] !== null) {
            $vqs = $vqs->withQualificationDate(
                DateTime::createFromFormat(
                    ilStudyProgrammeSettings::DATE_TIME_FORMAT,
                    $row[self::FIELD_VALIDITY_QUALIFICATION_DATE]
            )
            );
        } else {
            $qualification_period = (int) $row[self::FIELD_VALIDITY_QUALIFICATION_PERIOD];
            if ($qualification_period == -1) {
                $qualification_period = null;
            }
            $vqs = $vqs->withQualificationPeriod($qualification_period);
        }
        $restart_period = (int) $row[self::FIELD_VQ_RESTART_PERIOD];
        if ($restart_period == -1) {
            $restart_period = null;
        }
        $vqs = $vqs->withRestartPeriod($restart_period);
        $return = $return->withValidityOfQualificationSettings($vqs);
 
        $rm_nr_by_usr_days = $row[self::FIELD_RM_NOT_RESTARTED_BY_USER_DAY];
        if (!is_null($rm_nr_by_usr_days)) {
            $rm_nr_by_usr_days = (int) $rm_nr_by_usr_days;
        }
        $proc_end_no_success = $row[self::FIELD_PROC_ENDS_NOT_SUCCESSFUL];
        if (!is_null($proc_end_no_success)) {
            $proc_end_no_success = (int) $proc_end_no_success;
        }
 
        return $return->withAutoMailSettings(
            new \ilStudyProgrammeAutoMailSettings(
                (bool) $row[self::FIELD_SEND_RE_ASSIGNED_MAIL],
                $rm_nr_by_usr_days,
                $proc_end_no_success
            )
        );
    }

References $type, ilStudyProgrammeSettings\DATE_TIME_FORMAT, ilStudyProgrammeSettings\DEFAULT_POINTS, ilStudyProgrammeSettings\DEFAULT_SUBTYPE, FIELD_PROC_ENDS_NOT_SUCCESSFUL, FIELD_RM_NOT_RESTARTED_BY_USER_DAY, FIELD_SEND_RE_ASSIGNED_MAIL, and ilStudyProgrammeSettings\STATUS_DRAFT.

Referenced by loadByType(), and loadDB().

Here is the caller graph for this function:

◆ createFor()

ilStudyProgrammeSettingsDBRepository::createFor ( int $obj_id )

Create a record corresponding to a SP-Object and return representing settings.Will throw if a record allready exists.

Exceptions

ilException

Implements ilStudyProgrammeSettingsRepository.

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

                                           : ilStudyProgrammeSettings
    {
        $type_settings = new \ilStudyProgrammeTypeSettings(
            ilStudyProgrammeSettings::DEFAULT_SUBTYPE
        );
        $assessment_settings = new \ilStudyProgrammeAssessmentSettings(
            ilStudyProgrammeSettings::DEFAULT_POINTS,
            ilStudyProgrammeSettings::STATUS_DRAFT
        );
        $deadline_settings = new \ilStudyProgrammeDeadlineSettings(null, null);
        $validity_of_achieved_qualification_settings =
            new \ilStudyProgrammeValidityOfAchievedQualificationSettings(null, null, null)
        ;
        $automail = new \ilStudyProgrammeAutoMailSettings(false, null, null);
 
        $prg = new ilStudyProgrammeSettings(
            $obj_id,
            $type_settings,
            $assessment_settings,
            $deadline_settings,
            $validity_of_achieved_qualification_settings,
            $automail
        );
 
        $this->insertDB(
            $obj_id,
            ilStudyProgrammeSettings::DEFAULT_SUBTYPE,
            ilStudyProgrammeSettings::STATUS_DRAFT,
            ilStudyProgrammeSettings::MODE_UNDEFINED,
            ilStudyProgrammeSettings::DEFAULT_POINTS,
            (new DateTime())->format(ilStudyProgrammeSettings::DATE_TIME_FORMAT),
            0,
            ilStudyProgrammeSettings::NO_VALIDITY_OF_QUALIFICATION_PERIOD,
            ilStudyProgrammeSettings::NO_RESTART,
            null,
            null,
            null,
            null
        );
 
        $prg = $prg->setLPMode(ilStudyProgrammeSettings::MODE_UNDEFINED);
        self::$cache[$obj_id] = $prg;
        return $prg;
    }

References ilStudyProgrammeSettings\DATE_TIME_FORMAT, ilStudyProgrammeSettings\DEFAULT_POINTS, ilStudyProgrammeSettings\DEFAULT_SUBTYPE, insertDB(), ilStudyProgrammeSettings\MODE_UNDEFINED, ilStudyProgrammeSettings\NO_RESTART, ilStudyProgrammeSettings\NO_VALIDITY_OF_QUALIFICATION_PERIOD, and ilStudyProgrammeSettings\STATUS_DRAFT.

Here is the call graph for this function:

◆ delete()

ilStudyProgrammeSettingsDBRepository::delete ( ilStudyProgrammeSettings $settings )

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

Implements ilStudyProgrammeSettingsRepository.

Definition at line 159 of file class.ilStudyProgrammeSettingsDBRepository.php.

                                                               : void
    {
        unset(self::$cache[$settings->getObjId()]);
        $this->deleteDB($settings->getObjId());
    }

References deleteDB().

Here is the call graph for this function:

◆ deleteDB()

ilStudyProgrammeSettingsDBRepository::deleteDB ( int $obj_id )

protected

Exceptions

LogicException

Definition at line 378 of file class.ilStudyProgrammeSettingsDBRepository.php.

    {
        if (!$this->checkExists($obj_id)) {
            throw new LogicException('invaid obj_id to delete: ' . $obj_id);
        }
        $this->db->manipulate(
            'DELETE FROM ' . self::TABLE
            . ' WHERE ' . self::FIELD_OBJ_ID . ' = ' . $this->db->quote($obj_id, 'integer')
        );
    }

References checkExists().

Referenced by delete().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ insertDB()

ilStudyProgrammeSettingsDBRepository::insertDB	(	int	$obj_id,
		int	$subtype_id,
		int	$status,
		int	$lp_mode,
		int	$points,
		string	$last_change,
		int	$deadline_period,
		int	$vq_period,
		int	$vq_restart_period,
		string	$deadline_date = `null`,
		string	$vq_date = `null`,
		int	$rm_nr_by_usr_days = `null`,
		int	$proc_end_no_success = `null`,
		bool	$send_re_assigned_mail = `false`,
		bool	$send_info_to_re_assign_mail = `false`,
		bool	$send_risky_to_fail_mail = `false`
	)

protected

Definition at line 201 of file class.ilStudyProgrammeSettingsDBRepository.php.

      {
        $this->db->insert(
            self::TABLE,
            [
                self::FIELD_OBJ_ID => ['integer', $obj_id],
                self::FIELD_SUBTYPE_ID => ['integer', $subtype_id],
                self::FIELD_STATUS => ['integer', $status],
                self::FIELD_POINTS => ['integer', $points],
                self::FIELD_LP_MODE => ['integer', $lp_mode],
                self::FIELD_LAST_CHANGED => ['timestamp', $last_change],
                self::FIELD_DEADLINE_PERIOD => ['integer', $deadline_period],
                self::FIELD_DEADLINE_DATE => ['timestamp', $deadline_date],
                self::FIELD_VALIDITY_QUALIFICATION_DATE => ['timestamp', $vq_date],
                self::FIELD_VALIDITY_QUALIFICATION_PERIOD => ['integer', $vq_period],
                self::FIELD_VQ_RESTART_PERIOD => ['integer', $vq_restart_period],
                self::FIELD_RM_NOT_RESTARTED_BY_USER_DAY => ['integer', $rm_nr_by_usr_days],
                self::FIELD_PROC_ENDS_NOT_SUCCESSFUL => ['integer', $proc_end_no_success],
                self::FIELD_SEND_RE_ASSIGNED_MAIL => ['integer', $send_re_assigned_mail],
                self::FIELD_SEND_INFO_TO_RE_ASSIGN_MAIL => ['integer', $send_info_to_re_assign_mail],
                self::FIELD_SEND_RISKY_TO_FAIL_MAIL => ['integer', $send_risky_to_fail_mail]
            ]
        );
    }

Referenced by createFor().

Here is the caller graph for this function:

◆ loadByType()

ilStudyProgrammeSettingsDBRepository::loadByType ( int $type_id )

Load SP settings by assigned type.

Exceptions

ilException

Implements ilStudyProgrammeSettingsRepository.

Definition at line 169 of file class.ilStudyProgrammeSettingsDBRepository.php.

                                             : array
    {
        $q = 'SELECT ' . self::FIELD_SUBTYPE_ID
            . ' ,' . self::FIELD_STATUS
            . ' ,' . self::FIELD_POINTS
            . ' ,' . self::FIELD_LP_MODE
            . ' ,' . self::FIELD_LAST_CHANGED
            . ' ,' . self::FIELD_OBJ_ID
            . ' ,' . self::FIELD_DEADLINE_PERIOD
            . ' ,' . self::FIELD_DEADLINE_DATE
            . ' ,' . self::FIELD_VALIDITY_QUALIFICATION_PERIOD
            . ' ,' . self::FIELD_VALIDITY_QUALIFICATION_DATE
            . ' ,' . self::FIELD_VQ_RESTART_PERIOD
            . ', ' . self::FIELD_SEND_RE_ASSIGNED_MAIL
            . ', ' . self::FIELD_SEND_INFO_TO_RE_ASSIGN_MAIL
            . ', ' . self::FIELD_SEND_RISKY_TO_FAIL_MAIL
            . ' FROM ' . self::TABLE
            . ' WHERE ' . self::FIELD_SUBTYPE_ID . ' = ' . $this->db->quote($type_id, 'integer');
        $res = $this->db->query($q);
        $return = [];
        while ($rec = $this->db->fetchAssoc($res)) {
            $return[] = $this->createByRow($rec);
        }
        return $return;
    }

References $res, and createByRow().

Here is the call graph for this function:

◆ loadDB()

ilStudyProgrammeSettingsDBRepository::loadDB ( int $obj_id )

protected

Exceptions

ilException @thorws LogicException

Definition at line 246 of file class.ilStudyProgrammeSettingsDBRepository.php.

                                           : ilStudyProgrammeSettings
    {
        $rec = $this->db->fetchAssoc(
            $this->db->query(
                'SELECT ' . self::FIELD_SUBTYPE_ID
                . ', ' . self::FIELD_STATUS
                . ', ' . self::FIELD_POINTS
                . ', ' . self::FIELD_LP_MODE
                . ', ' . self::FIELD_LAST_CHANGED
                . ', ' . self::FIELD_OBJ_ID
                . ', ' . self::FIELD_DEADLINE_PERIOD
                . ', ' . self::FIELD_DEADLINE_DATE
                . ', ' . self::FIELD_VALIDITY_QUALIFICATION_PERIOD
                . ', ' . self::FIELD_VALIDITY_QUALIFICATION_DATE
                . ', ' . self::FIELD_VQ_RESTART_PERIOD
                . ', ' . self::FIELD_RM_NOT_RESTARTED_BY_USER_DAY
                . ', ' . self::FIELD_PROC_ENDS_NOT_SUCCESSFUL
                . ', ' . self::FIELD_SEND_RE_ASSIGNED_MAIL
                . ', ' . self::FIELD_SEND_INFO_TO_RE_ASSIGN_MAIL
                . ', ' . self::FIELD_SEND_RISKY_TO_FAIL_MAIL
                . '     FROM ' . self::TABLE
                . '     WHERE ' . self::FIELD_OBJ_ID . ' = ' . $this->db->quote($obj_id, 'integer')
            )
        );
        if (!$rec) {
            throw new LogicException('invaid obj_id to load: ' . $obj_id);
        }
        return $this->createByRow($rec);
    }

References createByRow().

Referenced by read().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadIdsByType()

ilStudyProgrammeSettingsDBRepository::loadIdsByType ( int $type_id )

Load SP setting-ids by assigned type.

Implements ilStudyProgrammeSettingsRepository.

Definition at line 196 of file class.ilStudyProgrammeSettingsDBRepository.php.

◆ read()

ilStudyProgrammeSettingsDBRepository::read ( int $obj_id )

Load settings belonging to a SP-Object.Will throw if the record does not exist yet.

Exceptions

ilException

Implements ilStudyProgrammeSettingsRepository.

Definition at line 97 of file class.ilStudyProgrammeSettingsDBRepository.php.

                                      : ilStudyProgrammeSettings
    {
        if (!array_key_exists($obj_id, self::$cache)) {
            self::$cache[$obj_id] = $this->loadDB($obj_id);
        }
        return self::$cache[$obj_id];
    }

References loadDB().

Here is the call graph for this function:

◆ update()

ilStudyProgrammeSettingsDBRepository::update ( ilStudyProgrammeSettings $settings )

Update settings belonging to a SP-Object.Will throw if the record does not exist yet.

Implements ilStudyProgrammeSettingsRepository.

Definition at line 108 of file class.ilStudyProgrammeSettingsDBRepository.php.

                                                               : void
    {
        $deadline_period = $settings->getDeadlineSettings()->getDeadlinePeriod();
        if (is_null($deadline_period)) {
            $deadline_period = 0;
        }
 
        $deadline_date = $settings->getDeadlineSettings()->getDeadlineDate();
        if (!is_null($deadline_date)) {
            $deadline_date = $deadline_date->format(ilStudyProgrammeSettings::DATE_TIME_FORMAT);
        }
 
        $vq_date = $settings->getValidityOfQualificationSettings()->getQualificationDate();
        if (!is_null($vq_date)) {
            $vq_date = $vq_date->format(ilStudyProgrammeSettings::DATE_TIME_FORMAT);
        }
 
        $qp = $settings->getValidityOfQualificationSettings()->getQualificationPeriod();
        if (is_null($qp)) {
            $qp = 0;
        }
 
        $rp = $settings->getValidityOfQualificationSettings()->getRestartPeriod();
        if (is_null($rp)) {
            $rp = 0;
        }
 
        $this->updateDB(
            $settings->getObjId(),
            $settings->getTypeSettings()->getTypeId(),
            $settings->getAssessmentSettings()->getStatus(),
            $settings->getLPMode(),
            $settings->getAssessmentSettings()->getPoints(),
            $settings->getLastChange()->format(ilStudyProgrammeSettings::DATE_TIME_FORMAT),
            $deadline_period,
            $qp,
            $rp,
            $deadline_date,
            $vq_date,
            $settings->getAutoMailSettings()->getReminderNotRestartedByUserDays(),
            $settings->getAutoMailSettings()->getProcessingEndsNotSuccessfulDays(),
            $settings->getAutoMailSettings()->getSendReAssignedMail(),
            false,
            false
        );
        self::$cache[$settings->getObjId()] = $settings;
    }

References ilStudyProgrammeSettings\DATE_TIME_FORMAT, ilStudyProgrammeSettings\getAssessmentSettings(), ilStudyProgrammeSettings\getAutoMailSettings(), ilStudyProgrammeSettings\getDeadlineSettings(), ilStudyProgrammeSettings\getLastChange(), ilStudyProgrammeSettings\getLPMode(), ilStudyProgrammeSettings\getObjId(), ilStudyProgrammeSettings\getTypeSettings(), ilStudyProgrammeSettings\getValidityOfQualificationSettings(), and updateDB().

Here is the call graph for this function:

◆ updateDB()

ilStudyProgrammeSettingsDBRepository::updateDB	(	int	$obj_id,
		int	$subtype_id,
		int	$status,
		int	$lp_mode,
		int	$points,
		string	$last_change,
		int	$deadline_period,
		int	$vq_period,
		int	$vq_restart_period,
		string	$deadline_date = `null`,
		string	$vq_date = `null`,
		int	$rm_nr_by_usr_days = `null`,
		int	$proc_end_no_success = `null`,
		bool	$send_re_assigned_mail = `false`,
		bool	$send_info_to_re_assign_mail = `false`,
		bool	$send_risky_to_fail_mail = `false`
	)

protected

@pthrows LogicException

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

      {
        if (!$this->checkExists($obj_id)) {
            throw new LogicException('invalid obj_id to update: ' . $obj_id);
        }
        $where = [
            self::FIELD_OBJ_ID => [
                'integer',
                $obj_id
            ]
        ];
 
        $values = [
            self::FIELD_SUBTYPE_ID => [
                'integer',
                $subtype_id
            ],
            self::FIELD_STATUS => [
                'integer',
                $status
            ],
            self::FIELD_LP_MODE => [
                'integer',
                $lp_mode
            ],
            self::FIELD_POINTS => [
                'integer',
                $points
            ],
            self::FIELD_LAST_CHANGED => [
                'timestamp',
                $last_change
            ],
            self::FIELD_DEADLINE_PERIOD => [
                'integer',
                $deadline_period
            ],
            self::FIELD_DEADLINE_DATE => [
                'timestamp',
                $deadline_date
            ],
            self::FIELD_VALIDITY_QUALIFICATION_PERIOD => [
                'integer',
                $vq_period
            ],
            self::FIELD_VALIDITY_QUALIFICATION_DATE => [
                'timestamp',
                $vq_date
            ],
            self::FIELD_VQ_RESTART_PERIOD => [
                'integer',
                $vq_restart_period
            ],
            self::FIELD_RM_NOT_RESTARTED_BY_USER_DAY => [
                'integer',
                $rm_nr_by_usr_days
            ],
            self::FIELD_PROC_ENDS_NOT_SUCCESSFUL => [
                'integer',
                $proc_end_no_success
            ],
            self::FIELD_SEND_RE_ASSIGNED_MAIL => [
                'integer',
                $send_re_assigned_mail
            ],
            self::FIELD_SEND_INFO_TO_RE_ASSIGN_MAIL => [
                'integer',
                $send_info_to_re_assign_mail
            ],
            self::FIELD_SEND_RISKY_TO_FAIL_MAIL => [
                'integer',
                $send_risky_to_fail_mail
            ]
        ];
 
        $this->db->update(self::TABLE, $values, $where);
    }