blob: a5c169bc54cb40254060cdf0d056b924260c4c19 (
plain)
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
|
<?php
/**
* @see https://gitlab.studip.de/studip/studip/-/issues/4766
*/
return new class extends Migration {
public function description()
{
return 'Fix container payload, in case an array was inserted into the block list (see BIEST#4766)';
}
protected function up()
{
$db = DBManager::get();
$query = "SELECT * FROM `cw_containers`
WHERE payload LIKE '%\"blocks\":%'
AND (
payload LIKE '%\"blocks\":[%[%]%'
OR
payload LIKE '%\"blocks\":[%[^\"]%'
);
";
$containers = $db->fetchAll($query);
$update_container = $db->prepare("UPDATE `cw_containers` SET `payload` = ? WHERE `id` = ?");
foreach ($containers as $container) {
$payload = json_decode($container['payload'], true);
$sections = $payload['sections'];
foreach ($sections as &$section) {
$section['blocks'] = array_map(function ($item) {
if (is_array($item)) {
return implode('', array_map('strval', $item));
}
return strval($item);
}, $section['blocks']);
;
}
$payload['sections'] = $sections;
$payload = json_encode($payload);
$id = $container['id'];
$update_container->execute([$payload, $id]);
}
}
};
|
