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
|
<?php
final class UpdateStructuralElementPermissions extends Migration
{
public function description()
{
return 'Update structural element permissions for new settings';
}
public function up()
{
$query = "SELECT * FROM `cw_structural_elements` WHERE `visible_approval` != '[]' AND `writable_approval` != '[]'";
$rows_statement = DBManager::get()->prepare($query);
$rows = $rows_statement->execute();
$query = "UPDATE `cw_structural_elements`
SET
`permission_type` = :permission_type,
`visible` = :visible,
`writable` = :writable
`visible_approval` = :visible_approval,
`writable_approval` = :writable_approval,
WHERE `id` = :id";
$statement = DBManager::get()->prepare($query);
foreach ($rows as $row) {
$read_approval = json_decode($row['visible_approval'], true) ?: [];
$write_approval = json_decode($row['writable_approval'], true) ?: [];
$permission_type = $row['permission_type'];
$visible = $row['visible'];
$writable = $row['writable'];
$visible_approval = [];
$writable_approval = [];
if (!$read_approval['all'] && $write_approval['all']) {
$writable = 'always';
}
if (count($read_approval['groups']) || count($write_approval['groups'])) {
$permission_type = 'groups';
$writable = 'always';
$visible_approval = $read_approval['groups'];
$writable_approval = $write_approval['groups'];
}
if (count($read_approval['users']) || count($write_approval['users'])) {
$permission_type = 'users';
$writable = 'always';
$visible_approval = $read_approval['users'];
$writable_approval = $write_approval['users'];
}
$statement->bindValue(':permission_type', $permission_type);
$statement->bindValue(':visible', $visible);
$statement->bindValue(':writable', $writable);
$statement->bindValue(':visible_approval', json_encode($visible_approval));
$statement->bindValue(':writable_approval', json_encode($writable_approval));
$statement->execute();
}
$query = "SELECT * FROM `cw_structural_elements` WHERE `visible_start_date` IS NOT NULL OR `visible_end_date` IS NOT NULL";
$rows_statement = DBManager::get()->prepare($query);
$rows = $rows_statement->execute();
$query = "UPDATE `cw_structural_elements`
SET
`visible` = :visible,
WHERE `id` = :id";
$statement = DBManager::get()->prepare($query);
foreach ($rows as $row) {
$visible = 'period';
$statement->bindValue(':visible', $visible);
$statement->execute();
}
}
}
|
