ILIAS  release_5-4 Revision v5.4.26-12-gabc799a52e6
class.ilLearningSequenceActivationDB.php
Go to the documentation of this file.
1<?php
2
3declare(strict_types=1);
4
11{
12 const TABLE_NAME = 'lso_activation';
13
17 protected $database;
18
20 {
21 $this->database = $database;
22 }
23
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 }
56
57 public function deleteForRefId(int $ref_id)
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 }
64
65 public function store(ilLearningSequenceActivation $settings)
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 }
87
88 protected function insert(ilLearningSequenceActivation $settings)
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 }
107
108 protected function select(int $ref_id) : 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 }
125
126 protected function buildActivationSettings(
127 int $ref_id,
128 bool $online = false,
129 bool $effective_online = false,
130 \DateTime $activation_start = null,
131 \DateTime $activation_end = null
134 $ref_id,
135 $online,
136 $effective_online,
137 $activation_start,
138 $activation_end
139 );
140 }
141
142 public function setEffectiveOnlineStatus(int $ref_id, bool $status)
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 }
154}
$result
An exception for terminatinating execution or to throw for unit testing.
Persistence for online/activation period.
insert(ilLearningSequenceActivation $settings)
store(ilLearningSequenceActivation $settings)
buildActivationSettings(int $ref_id, bool $online=false, bool $effective_online=false, \DateTime $activation_start=null, \DateTime $activation_end=null)
PHP_EOL
Definition: complexTest.php:7
return['Universal Coordinated Time'=> 'UTC', 'Casablanca, Monrovia'=> 'Africa/Casablanca', 'Greenwich Mean Time:Dublin, Edinburgh, Lisbon, London'=> 'Europe/Lisbon', 'Greenwich Mean Time;Dublin, Edinburgh, London'=> 'Europe/London', 'Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna'=> 'Europe/Berlin', 'Belgrade, Pozsony, Budapest, Ljubljana, Prague'=> 'Europe/Prague', 'Brussels, Copenhagen, Madrid, Paris'=> 'Europe/Paris', 'Paris, Madrid, Brussels, Copenhagen'=> 'Europe/Paris', 'Prague, Central Europe'=> 'Europe/Prague', 'Sarajevo, Skopje, Sofija, Vilnius, Warsaw, Zagreb'=> 'Europe/Sarajevo', 'West Central Africa'=> 'Africa/Luanda', 'Athens, Istanbul, Minsk'=> 'Europe/Athens', 'Bucharest'=> 'Europe/Bucharest', 'Cairo'=> 'Africa/Cairo', 'Harare, Pretoria'=> 'Africa/Harare', 'Helsinki, Riga, Tallinn'=> 'Europe/Helsinki', 'Israel, Jerusalem Standard Time'=> 'Asia/Jerusalem', 'Baghdad'=> 'Asia/Baghdad', 'Arab, Kuwait, Riyadh'=> 'Asia/Kuwait', 'Moscow, St. Petersburg, Volgograd'=> 'Europe/Moscow', 'East Africa, Nairobi'=> 'Africa/Nairobi', 'Tehran'=> 'Asia/Tehran', 'Abu Dhabi, Muscat'=> 'Asia/Muscat', 'Baku, Tbilisi, Yerevan'=> 'Asia/Baku', 'Kabul'=> 'Asia/Kabul', 'Ekaterinburg'=> 'Asia/Yekaterinburg', 'Islamabad, Karachi, Tashkent'=> 'Asia/Karachi', 'Kolkata, Chennai, Mumbai, New Delhi, India Standard Time'=> 'Asia/Calcutta', 'Kathmandu, Nepal'=> 'Asia/Kathmandu', 'Almaty, Novosibirsk, North Central Asia'=> 'Asia/Almaty', 'Astana, Dhaka'=> 'Asia/Dhaka', 'Sri Jayawardenepura, Sri Lanka'=> 'Asia/Colombo', 'Rangoon'=> 'Asia/Rangoon', 'Bangkok, Hanoi, Jakarta'=> 'Asia/Bangkok', 'Krasnoyarsk'=> 'Asia/Krasnoyarsk', 'Beijing, Chongqing, Hong Kong SAR, Urumqi'=> 'Asia/Shanghai', 'Irkutsk, Ulaan Bataar'=> 'Asia/Irkutsk', 'Kuala Lumpur, Singapore'=> 'Asia/Singapore', 'Perth, Western Australia'=> 'Australia/Perth', 'Taipei'=> 'Asia/Taipei', 'Osaka, Sapporo, Tokyo'=> 'Asia/Tokyo', 'Seoul, Korea Standard time'=> 'Asia/Seoul', 'Yakutsk'=> 'Asia/Yakutsk', 'Adelaide, Central Australia'=> 'Australia/Adelaide', 'Darwin'=> 'Australia/Darwin', 'Brisbane, East Australia'=> 'Australia/Brisbane', 'Canberra, Melbourne, Sydney, Hobart(year 2000 only)'=> 'Australia/Sydney', 'Guam, Port Moresby'=> 'Pacific/Guam', 'Hobart, Tasmania'=> 'Australia/Hobart', 'Vladivostok'=> 'Asia/Vladivostok', 'Magadan, Solomon Is., New Caledonia'=> 'Asia/Magadan', 'Auckland, Wellington'=> 'Pacific/Auckland', 'Fiji Islands, Kamchatka, Marshall Is.'=> 'Pacific/Fiji', 'Nuku\ 'alofa, Tonga'=> 'Pacific/Tongatapu', 'Azores'=> 'Atlantic/Azores', 'Cape Verde Is.'=> 'Atlantic/Cape_Verde', 'Mid-Atlantic'=> 'America/Noronha', 'Brasilia'=> 'America/Sao_Paulo', 'Buenos Aires'=> 'America/Argentina/Buenos_Aires', 'Greenland'=> 'America/Godthab', 'Newfoundland'=> 'America/St_Johns', 'Atlantic Time(Canada)'=> 'America/Halifax', 'Caracas, La Paz'=> 'America/Caracas', 'Santiago'=> 'America/Santiago', 'Bogota, Lima, Quito'=> 'America/Bogota', 'Eastern Time(US &Canada)'=> 'America/New_York', 'Indiana(East)'=> 'America/Indiana/Indianapolis', 'Central America'=> 'America/Guatemala', 'Central Time(US &Canada)'=> 'America/Chicago', 'Mexico City, Tegucigalpa'=> 'America/Mexico_City', 'Saskatchewan'=> 'America/Edmonton', 'Arizona'=> 'America/Phoenix', 'Mountain Time(US &Canada)'=> 'America/Denver', 'Pacific Time(US &Canada)'=> 'America/Los_Angeles', 'Pacific Time(US &Canada);Tijuana'=> 'America/Los_Angeles', 'Alaska'=> 'America/Anchorage', 'Hawaii'=> 'Pacific/Honolulu', 'Midway Island, Samoa'=> 'Pacific/Midway', 'Eniwetok, Kwajalein, Dateline Time'=> 'Pacific/Kwajalein',]
Microsoft exchange timezones Source: http://msdn.microsoft.com/en-us/library/ms988620%28v=exchg....
Interface ilDBInterface.
$ret
Definition: parser.php:6
$query
$values
$start
Definition: bench.php:8
$data
Definition: bench.php:6