1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
<?php
class Step00283UpdateCalendarSettings extends Migration {
function description() {
return 'Registers new calendar settings for each user and adds mkdate.';
}
function up() {
DBManager::get()->exec("ALTER TABLE `event_data` CHANGE `autor_id` `author_id` VARCHAR(32) NOT NULL");
DBManager::get()->exec("ALTER TABLE `calendar_event` ADD `mkdate` INT NOT NULL AFTER `group_status`");
DBManager::get()->exec("UPDATE calendar_event ce LEFT JOIN event_data ed USING(event_id) SET ce.mkdate = ed.mkdate");
$replace = [
'showlist' => 'list',
'showday' => 'day',
'showweek' => 'week',
'showmonth' => 'month',
'showyear' => 'year'];
$res = DBManager::get()->query("SELECT user_id FROM `user_config` WHERE field = 'CALENDAR_SETTINGS'");
$default_settings = Calendar::getDefaultUserSettings();
Config::get()->store('CALENDAR_SETTINGS', $default_settings);
foreach ($res as $row) {
$config = new UserConfig($row['user_id']);
$settings = $config->getValue('CALENDAR_SETTINGS');
if (isset($settings['view'])) {
$default_settings['view'] = $replace[$settings['view']];
$config->store('CALENDAR_SETTINGS', $default_settings);
}
}
}
function down() {
DBManager::get()->execute("ALTER TABLE `event_data` CHANGE `author_id` `autor_id` VARCHAR(32) NOT NULL");
DBManager::get()->execute("ALTER TABLE `calendar_event` DROP `mkdate`");
$replace = [
'list' => 'showlist',
'day' => 'showday',
'week' => 'showweek',
'month' => 'showmonth',
'year' => 'showyear'];
$default_settings = [
'view' => 'week',
'start' => '9',
'end' => '20',
'step_day' => '900',
'step_week' => '1800',
'type_week' => 'LONG',
'delete' => '0',
'step_week_group' => '3600',
'step_day_group' => '3600'
];
$res = DBManager::get()->query("SELECT user_id FROM `user_config` WHERE field = 'CALENDAR_SETTINGS'");
foreach ($res as $row) {
$config = UserConfig::get($row['user_id']);
$settings = $config->getValue('CALENDAR_SETTINGS');
if (isset($settings['view'])) {
$default_settings['view'] = $replace[$settings['view']];
$config->store('CALENDAR_SETTINGS', $default_settings);
}
}
}
}
|
