ilLearningSequenceActivationDB Class Reference

Persistence for online/activation period. More...

Collaboration diagram for ilLearningSequenceActivationDB:

Public Member Functions
	__construct (ilDBInterface $database)
	getActivationForRefId (int $ref_id)
	deleteForRefId (int $ref_id)
	store (ilLearningSequenceActivation $settings)
	setEffectiveOnlineStatus (int $ref_id, bool $status)

Data Fields
const	TABLE_NAME = 'lso_activation'

Protected Member Functions
	insert (ilLearningSequenceActivation $settings)
	select (int $ref_id)
	buildActivationSettings (int $ref_id, bool $online=false, bool $effective_online=false, ?\DateTime $activation_start=null, ?\DateTime $activation_end=null)

Protected Attributes
ilDBInterface	$database

Detailed Description

Persistence for online/activation period.

Definition at line 24 of file class.ilLearningSequenceActivationDB.php.

Constructor & Destructor Documentation

__construct()

ilLearningSequenceActivationDB::__construct

(

ilDBInterface

$database

)

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

    {
        $this->database = $database;
    }

References $database, and ILIAS\Repository\database().

Here is the call graph for this function:

Member Function Documentation

buildActivationSettings()

ilLearningSequenceActivationDB::buildActivationSettings ( int  $ref_id, bool  $online = false, bool  $effective_online = false, ?\DateTime  $activation_start = null, ?\DateTime  $activation_end = null  )

protected

Definition at line 147 of file class.ilLearningSequenceActivationDB.php.

     : ilLearningSequenceActivation {
        return new ilLearningSequenceActivation(
            $ref_id,
            $online,
            $effective_online,
            $activation_start,
            $activation_end
        );
    }

Referenced by getActivationForRefId().

Here is the caller graph for this function:

deleteForRefId()

ilLearningSequenceActivationDB::deleteForRefId

(

int

$ref_id

)

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

                                               : void
    {
        $query = "DELETE FROM " . static::TABLE_NAME . PHP_EOL
            . "WHERE ref_id = " . $this->database->quote($ref_id, "integer") . PHP_EOL
        ;
        $this->database->manipulate($query);
    }

References ILIAS\Repository\database().

Here is the call graph for this function:

getActivationForRefId()

ilLearningSequenceActivationDB::getActivationForRefId

(

int

$ref_id

)

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

                                                      : ilLearningSequenceActivation
    {
        $data = $this->select($ref_id);
        if (count($data) == 0) {
            $settings = $this->buildActivationSettings($ref_id);
            $this->insert($settings);
        } else {
            if ($data['activation_start_ts']) {
                $start = new \DateTime();
                $start->setTimestamp((int) $data['activation_start_ts']);
            } else {
                $start = null;
            }
 
            if ($data['activation_end_ts']) {
                $end = new \DateTime();
                $end->setTimestamp((int) $data['activation_end_ts']);
            } else {
                $end = null;
            }
 
            $settings = $this->buildActivationSettings(
                (int) $data['ref_id'],
                (bool) $data['online'],
                (bool) $data['effective_online'],
                $start,
                $end
            );
        }
 
        return $settings;
    }

References $data, buildActivationSettings(), insert(), and select().

Here is the call graph for this function:

insert()

ilLearningSequenceActivationDB::insert ( ilLearningSequenceActivation  $settings )

protected

Definition at line 102 of file class.ilLearningSequenceActivationDB.php.

                                                                     : void
    {
        $start = $settings->getActivationStart();
        $end = $settings->getActivationEnd();
 
        if ($start) {
            $start = $start->getTimestamp();
        }
 
        if ($end) {
            $end = $end->getTimestamp();
        }
 
        $values = [
            "ref_id" => ["integer", $settings->getRefId()],
            "online" => ["integer", $settings->getIsOnline()],
            "effective_online" => ["integer", $settings->getEffectiveOnlineStatus()],
            "activation_start_ts" => ["integer", $start],
            "activation_end_ts" => ["integer", $end]
        ];
 
        $this->database->insert(static::TABLE_NAME, $values);
    }

References ILIAS\Repository\database(), ilLearningSequenceActivation\getActivationEnd(), ilLearningSequenceActivation\getActivationStart(), ilLearningSequenceActivation\getEffectiveOnlineStatus(), ilLearningSequenceActivation\getIsOnline(), and ilLearningSequenceActivation\getRefId().

Referenced by getActivationForRefId().

Here is the call graph for this function:

Here is the caller graph for this function:

select()

ilLearningSequenceActivationDB::select ( int  $ref_id )

protected

Returns

string[]

Definition at line 129 of file class.ilLearningSequenceActivationDB.php.

                                          : array
    {
        $ret = [];
        $query =
             "SELECT ref_id, online, effective_online, activation_start_ts, activation_end_ts" . PHP_EOL
            . "FROM " . static::TABLE_NAME . PHP_EOL
            . "WHERE ref_id = " . $this->database->quote($ref_id, "integer") . PHP_EOL
        ;
 
        $result = $this->database->query($query);
 
        if ($this->database->numRows($result) !== 0) {
            $ret = $this->database->fetchAssoc($result);
        }
 
        return $ret;
    }

References ILIAS\Repository\database().

Referenced by getActivationForRefId().

Here is the call graph for this function:

Here is the caller graph for this function:

setEffectiveOnlineStatus()

ilLearningSequenceActivationDB::setEffectiveOnlineStatus	(	int	$ref_id,
		bool	$status
	)

Definition at line 163 of file class.ilLearningSequenceActivationDB.php.

                                                                       : void
    {
        $where = ["ref_id" => ["integer", $ref_id]];
        $values = ["effective_online" => ["integer", $status]];
 
        $this->database->update(static::TABLE_NAME, $values, $where);
    }

References $ref_id, and ILIAS\Repository\database().

Here is the call graph for this function:

store()

ilLearningSequenceActivationDB::store

(

ilLearningSequenceActivation

$settings

)

Definition at line 76 of file class.ilLearningSequenceActivationDB.php.

                                                                 : void
    {
        $where = [
            "ref_id" => ["integer", $settings->getRefId()]
        ];
 
        $start = $settings->getActivationStart();
        $end = $settings->getActivationEnd();
 
        if ($start) {
            $start = $start->getTimestamp();
        }
 
        if ($end) {
            $end = $end->getTimestamp();
        }
 
        $values = [
            "online" => ["integer", $settings->getIsOnline()],
            "activation_start_ts" => ["integer", $start],
            "activation_end_ts" => ["integer", $end]
        ];
 
        $this->database->update(static::TABLE_NAME, $values, $where);
    }

References ILIAS\Repository\database(), ilLearningSequenceActivation\getActivationEnd(), ilLearningSequenceActivation\getActivationStart(), ilLearningSequenceActivation\getIsOnline(), and ilLearningSequenceActivation\getRefId().

Here is the call graph for this function:

Field Documentation

$database

ilDBInterface ilLearningSequenceActivationDB::$database

protected

Definition at line 28 of file class.ilLearningSequenceActivationDB.php.

Referenced by __construct().

TABLE_NAME

const ilLearningSequenceActivationDB::TABLE_NAME = 'lso_activation'

Definition at line 26 of file class.ilLearningSequenceActivationDB.php.

---

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

• components/ILIAS/LearningSequence/classes/Activation/class.ilLearningSequenceActivationDB.php