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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
<?php
class Step00202EnhancedSeminarCycle extends Migration
{
function description()
{
return 'adds new table seminar_cycle_dates and converts old metadata_dates';
}
function up()
{
$db = DBManager::get();
$options[] =
[
'name' => 'ALLOW_METADATE_SORTING',
'type' => 'boolean',
'value' => 0,
'section' => 'permissions',
'description' => 'Soll es erlaubt sein, dass regelmäßige Zeiten einer Veranstaltung frei sortiert werden können?'
];
$stmt = $db->prepare("
INSERT IGNORE INTO config
(config_id, field, value, is_default, type, section, mkdate, chdate, description)
VALUES
(MD5(:name), :name, :value, 1, :type, :section, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), :description)
");
foreach ($options as $option) {
$stmt->execute($option);
}
$db->exec("CREATE TABLE IF NOT EXISTS `seminar_cycle_dates` (
`metadate_id` varchar(32) NOT NULL,
`seminar_id` varchar(32) NOT NULL,
`start_time` time NOT NULL,
`end_time` time NOT NULL,
`weekday` tinyint(3) unsigned NOT NULL,
`description` varchar(255) NOT NULL DEFAULT '',
`sws` decimal(2,1) NOT NULL DEFAULT '0.0',
`cycle` tinyint(3) unsigned NOT NULL DEFAULT '0',
`week_offset` tinyint(3) unsigned NOT NULL DEFAULT '0',
`sorter` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mkdate` int(10) unsigned NOT NULL,
`chdate` int(10) unsigned NOT NULL,
PRIMARY KEY (`metadate_id`),
KEY `seminar_id` (`seminar_id`)
) ENGINE=MyISAM;");
$stmt = $db->prepare("INSERT INTO `seminar_cycle_dates`
(`metadate_id`, `seminar_id`, `start_time`, `end_time`, `weekday`,
`description`, `cycle`, `week_offset`, `mkdate`, `chdate`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
foreach ($db->query("SELECT Seminar_id, metadata_dates, mkdate, chdate FROM seminare") as $row) {
$md = @unserialize($row['metadata_dates']);
if (is_array($md['turnus_data'])) {
foreach ($md['turnus_data'] as $c) {
if ($c['metadate_id']) {
$stmt->execute([$c['metadate_id'],
$row['Seminar_id'],
sprintf('%02s:%02s', (int)$c['start_stunde'], (int)$c['start_minute']),
sprintf('%02s:%02s', (int)$c['end_stunde'], (int)$c['end_minute']),
(int)$c['day'],
(string)$c['desc'],
(int)$md['turnus'],
(int)$md['start_woche'],
$row['mkdate'],
$row['chdate']
]
);
}
}
}
}
//So Long, and Thanks for All the Fish
$db->exec("ALTER TABLE `seminare` DROP `metadata_dates`");
}
function down()
{
$db = DBManager::get();
$db->exec("DROP TABLE `seminar_cycle_dates`");
$db->exec("ALTER TABLE `seminare` ADD `metadata_dates` TEXT NOT NULL DEFAULT ''");
$db->exec("DELETE FROM config WHERE field LIKE 'ALLOW_METADATE_SORTING'");
}
}
?>
|
