ILIAS  release_6 Revision v6.24-5-g0c8bfefb3b8
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

 $database
 

Detailed Description

Persistence for online/activation period.

Author
Nils Haagen nils..nosp@m.haag.nosp@m.en@co.nosp@m.ncep.nosp@m.ts-an.nosp@m.d-tr.nosp@m.ainin.nosp@m.g.de

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

Constructor & Destructor Documentation

◆ __construct()

ilLearningSequenceActivationDB::__construct ( ilDBInterface  $database)

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

References $database.

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 126 of file class.ilLearningSequenceActivationDB.php.

134 $ref_id,
135 $online,
136 $effective_online,
137 $activation_start,
138 $activation_end
139 );
140 }

Referenced by getActivationForRefId().

+ Here is the caller graph for this function:

◆ deleteForRefId()

ilLearningSequenceActivationDB::deleteForRefId ( int  $ref_id)

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

58 {
59 $query = "DELETE FROM " . static::TABLE_NAME . PHP_EOL
60 . "WHERE ref_id = " . $this->database->quote($ref_id, "integer") . PHP_EOL
61 ;
62 $this->database->manipulate($query);
63 }
$query

References $query.

◆ getActivationForRefId()

ilLearningSequenceActivationDB::getActivationForRefId ( int  $ref_id)

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

25 {
26 $data = $this->select($ref_id);
27 if (count($data) == 0) {
28 $settings = $this->buildActivationSettings($ref_id);
29 $this->insert($settings);
30 } else {
31 if ($data['activation_start_ts']) {
32 $start = new \DateTime();
33 $start->setTimestamp((int) $data['activation_start_ts']);
34 } else {
35 $start = null;
36 }
37
38 if ($data['activation_end_ts']) {
39 $end = new \DateTime();
40 $end->setTimestamp((int) $data['activation_end_ts']);
41 } else {
42 $end = null;
43 }
44
45 $settings = $this->buildActivationSettings(
46 (int) $data['ref_id'],
47 (bool) $data['online'],
48 (bool) $data['effective_online'],
49 $start,
50 $end
51 );
52 }
53
54 return $settings;
55 }
insert(ilLearningSequenceActivation $settings)
buildActivationSettings(int $ref_id, bool $online=false, bool $effective_online=false, \DateTime $activation_start=null, \DateTime $activation_end=null)
$data
Definition: storeScorm.php:23

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

+ Here is the call graph for this function:

◆ insert()

ilLearningSequenceActivationDB::insert ( ilLearningSequenceActivation  $settings)
protected

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

89 {
90 $start = $settings->getActivationStart();
91 $end = $settings->getActivationEnd();
92 if ($start) {
93 $start = $start->getTimestamp();
94 }
95 if ($end) {
96 $end = $end->getTimestamp();
97 }
98 $values = array(
99 "ref_id" => array("integer", $settings->getRefId()),
100 "online" => array("integer", $settings->getIsOnline()),
101 "effective_online" => array("integer", $settings->getEffectiveOnlineStatus()),
102 "activation_start_ts" => array("integer", $start),
103 "activation_end_ts" => array("integer", $end)
104 );
105 $this->database->insert(static::TABLE_NAME, $values);
106 }

References 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

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

108 : array
109 {
110 $ret = [];
111 $query =
112 "SELECT ref_id, online, effective_online, activation_start_ts, activation_end_ts" . PHP_EOL
113 . "FROM " . static::TABLE_NAME . PHP_EOL
114 . "WHERE ref_id = " . $this->database->quote($ref_id, "integer") . PHP_EOL
115 ;
116
117 $result = $this->database->query($query);
118
119 if ($result->numRows() !== 0) {
120 $ret = $this->database->fetchAssoc($result);
121 }
122
123 return $ret;
124 }
$result
$ret
Definition: parser.php:6

References $query, $result, and $ret.

Referenced by getActivationForRefId().

+ Here is the caller graph for this function:

◆ setEffectiveOnlineStatus()

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

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

143 {
144 $where = array(
145 "ref_id" => array("integer", $ref_id)
146 );
147
148 $values = array(
149 "effective_online" => array("integer", $status),
150 );
151
152 $this->database->update(static::TABLE_NAME, $values, $where);
153 }

◆ store()

ilLearningSequenceActivationDB::store ( ilLearningSequenceActivation  $settings)

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

66 {
67 $where = array(
68 "ref_id" => array("integer", $settings->getRefId())
69 );
70
71 $start = $settings->getActivationStart();
72 $end = $settings->getActivationEnd();
73
74 if ($start) {
75 $start = $start->getTimestamp();
76 }
77 if ($end) {
78 $end = $end->getTimestamp();
79 }
80 $values = array(
81 "online" => array("integer", $settings->getIsOnline()),
82 "activation_start_ts" => array("integer", $start),
83 "activation_end_ts" => array("integer", $end)
84 );
85 $this->database->update(static::TABLE_NAME, $values, $where);
86 }

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

+ Here is the call graph for this function:

Field Documentation

◆ $database

ilLearningSequenceActivationDB::$database
protected

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

Referenced by __construct().

◆ TABLE_NAME

const ilLearningSequenceActivationDB::TABLE_NAME = 'lso_activation'

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


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