1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
use yii\db\Migration; |
4
|
|
|
|
5
|
|
|
/** |
6
|
|
|
* Class m190204_134239_firefly_interface_change_db_fix |
7
|
|
|
* Converts old API firefly action links to new api links. |
8
|
|
|
* These become hardcoded when adding images to wysiwyg |
9
|
|
|
*/ |
10
|
|
|
class m190204_134239_firefly_interface_change_db_fix extends Migration |
11
|
|
|
{ |
12
|
|
|
/** |
13
|
|
|
* This is the old api url that will no longer exist |
14
|
|
|
* @var string |
15
|
|
|
*/ |
16
|
|
|
private $upSearch = '/firefly/get/img'; |
17
|
|
|
/** |
18
|
|
|
* This is the new api link to convert to |
19
|
|
|
* @var string |
20
|
|
|
*/ |
21
|
|
|
private $upReplace = '/firefly/file/img'; |
22
|
|
|
|
23
|
|
|
public function safeUp() |
24
|
|
|
{ |
25
|
|
|
return $this->convertFireflyGetsToFiles($this->upSearch, $this->upReplace); |
26
|
|
|
} |
27
|
|
|
|
28
|
|
|
public function safeDown() |
29
|
|
|
{ |
30
|
|
|
return $this->convertFireflyGetsToFiles($this->upReplace, $this->upSearch); |
31
|
|
|
} |
32
|
|
|
|
33
|
|
|
private function convertFireflyGetsToFiles($search, $replace) |
34
|
|
|
{ |
35
|
|
|
$potentiallyAffected = $this->db->createCommand("SELECT `class_type`, `member_ref` FROM `dds_member` WHERE `data_type_ref`='textlong'")->queryAll(); |
36
|
|
|
if (count($potentiallyAffected)==0) |
37
|
|
|
return; |
38
|
|
|
$classes = []; |
39
|
|
|
foreach ($potentiallyAffected as $pa) |
40
|
|
|
$classes[$pa['class_type']][] = $pa['member_ref']; |
41
|
|
|
$phoebeClasses = array_keys($classes); |
42
|
|
|
$phoebe = neon('phoebe')->getIPhoebeType('daedalus'); |
43
|
|
|
|
44
|
|
|
$phoebeDefinition = []; |
45
|
|
|
foreach ($phoebeClasses as $pc) |
46
|
|
|
$phoebeDefinition[$pc] = $phoebe->getClass($pc, null, false); |
47
|
|
|
|
48
|
|
|
$potentiallyAffectedLookup = []; |
49
|
|
|
foreach ($potentiallyAffected as $pa) { |
50
|
|
|
if (empty($potentiallyAffectedLookup[$pa['class_type']])) |
51
|
|
|
$potentiallyAffectedLookup[$pa['class_type']] = []; |
52
|
|
|
$potentiallyAffectedLookup[$pa['class_type']][] = $pa['member_ref']; |
53
|
|
|
} |
54
|
|
|
|
55
|
|
|
$wysiwygFields = []; |
56
|
|
|
foreach ($phoebeDefinition as $pdKey => $pd) { |
57
|
|
|
$fields = !empty($pd->definition['fields']) ? $pd->definition['fields'] : null; |
58
|
|
|
if ($fields) { |
59
|
|
|
$potentials = !empty($potentiallyAffectedLookup[$pdKey]) ? $potentiallyAffectedLookup[$pdKey] : []; |
60
|
|
|
foreach ($fields as $field) { |
61
|
|
|
if (in_array($field['name'], $potentials)) { |
62
|
|
|
if ($field['definition']['class'] == "neon\\core\\form\\fields\\Wysiwyg") { |
63
|
|
|
$wysiwygFields[$pdKey] = !empty($wysiwygFields[$pdKey]) ? $wysiwygFields[$pdKey] : []; |
64
|
|
|
$wysiwygFields[$pdKey][] = $field['name']; |
65
|
|
|
} |
66
|
|
|
} |
67
|
|
|
} |
68
|
|
|
} |
69
|
|
|
} |
70
|
|
|
|
71
|
|
|
$dds = neon('dds')->IDdsObjectManagement; |
|
|
|
|
72
|
|
|
foreach ($wysiwygFields as $classType => $fields) { |
73
|
|
|
$start=0; |
74
|
|
|
do { |
75
|
|
|
$found = $dds->listObjects($classType, $total, true, true, $start, 100); |
|
|
|
|
76
|
|
|
$start += count($found); |
77
|
|
|
foreach ($found as $objectData) { |
78
|
|
|
$changes = []; |
79
|
|
|
foreach ($fields as $field) { |
80
|
|
|
if (!empty($objectData[$field]) && strpos($objectData[$field],$search)!==false) |
81
|
|
|
$changes[$field] = str_replace($search, $replace, $objectData[$field]); |
82
|
|
|
} |
83
|
|
|
if (count($changes)) { |
84
|
|
|
$dds->editObject($objectData['_uuid'], $changes); |
85
|
|
|
} |
86
|
|
|
} |
87
|
|
|
} while (count($found)>0); |
88
|
|
|
} |
89
|
|
|
|
90
|
|
|
return true; |
91
|
|
|
} |
92
|
|
|
|
93
|
|
|
} |
94
|
|
|
|