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
|
<?php
class AddMissingLogActions extends Migration
{
static $log_actions = [
[
'name' => 'USER_CHANGE_PASSWORD',
'description' => 'Nutzerpasswort geändert',
'template' => '%user ändert/setzt das Passwort für %user(%affected)',
'active' => 0
], [
'name' => 'SEM_CHANGE_CYCLE',
'description' => 'Regelmäßige Zeit geändert',
'template' => '%user hat in %sem(%affected) die regelmäßige Zeit %info geändert',
'active' => 1
]
];
function description()
{
return 'adds two missing log actions to the database';
}
function up()
{
$db = DBManager::get();
$query = $db->prepare("INSERT INTO log_actions (action_id, name, description, info_template, active) VALUES (?, ?, ?, ?, ?)");
foreach (self::$log_actions as $action) {
$query->execute([md5($action['name']), $action['name'], $action['description'], $action['template'], $action['active']]);
}
// fix misuse of %coaffected in SEM_ADD_CYCLE and SEM_DELETE_CYCLE
$db->exec("UPDATE log_actions SET info_template = REPLACE(info_template, '<em>%coaffected</em>', '%info')
WHERE name IN ('SEM_ADD_CYCLE', 'SEM_DELETE_CYCLE')");
$db->exec("UPDATE log_events SET info = coaffected_range_id WHERE action_id IN (MD5('SEM_ADD_CYCLE'), MD5('SEM_DELETE_CYCLE'))");
$db->exec("UPDATE log_events SET coaffected_range_id = NULL WHERE action_id IN (MD5('SEM_ADD_CYCLE'), MD5('SEM_DELETE_CYCLE'))");
}
function down()
{
$db = DBManager::get();
$query = $db->prepare("DELETE FROM log_actions WHERE action_id = ?");
foreach (self::$log_actions as $action) {
$query->execute([md5($action['name'])]);
}
// restore misuse of %coaffected in SEM_ADD_CYCLE and SEM_DELETE_CYCLE
$db->exec("UPDATE log_actions SET info_template = REPLACE(info_template, '%info', '<em>%coaffected</em>')
WHERE name IN ('SEM_ADD_CYCLE', 'SEM_DELETE_CYCLE')");
$db->exec("UPDATE log_events SET coaffected_range_id = info WHERE action_id IN (MD5('SEM_ADD_CYCLE'), MD5('SEM_DELETE_CYCLE'))");
$db->exec("UPDATE log_events SET info = NULL WHERE action_id IN (MD5('SEM_ADD_CYCLE'), MD5('SEM_DELETE_CYCLE'))");
}
}
?>
|
