118 lines
4.0 KiB
PHP
118 lines
4.0 KiB
PHP
<?php
|
|
/*
|
|
* Copyright (C) 2023 Xibo Signage Ltd
|
|
*
|
|
* Xibo - Digital Signage - https://xibosignage.com
|
|
*
|
|
* This file is part of Xibo.
|
|
*
|
|
* Xibo is free software: you can redistribute it and/or modify
|
|
* it under the terms of the GNU Affero General Public License as published by
|
|
* the Free Software Foundation, either version 3 of the License, or
|
|
* any later version.
|
|
*
|
|
* Xibo is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU Affero General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU Affero General Public License
|
|
* along with Xibo. If not, see <http://www.gnu.org/licenses/>.
|
|
*/
|
|
|
|
use Phinx\Migration\AbstractMigration;
|
|
|
|
/**
|
|
* Class FeaturesMigration
|
|
*/
|
|
class FeaturesMigration extends AbstractMigration
|
|
{
|
|
/**
|
|
* @inheritDoc
|
|
*/
|
|
public function change()
|
|
{
|
|
$this->table('group')
|
|
->addColumn('features', 'text', [
|
|
'null' => true,
|
|
'default' => null,
|
|
'limit' => \Phinx\Db\Adapter\MysqlAdapter::TEXT_LONG
|
|
])
|
|
->save();
|
|
|
|
$this->table('user')
|
|
->changeColumn('homePageId', 'string', [
|
|
'null' => true,
|
|
'default' => 'null',
|
|
'limit' => '255'
|
|
])
|
|
->save();
|
|
|
|
$this->execute('UPDATE `user` SET homePageId = (SELECT CONCAT(pages.name, \'.view\') FROM pages WHERE user.homePageId = pages.pageId)');
|
|
|
|
// Migrate Page Permissions
|
|
$entityId = $this->fetchRow('SELECT entityId FROM permissionentity WHERE entity LIKE \'%Page%\'')[0];
|
|
|
|
// Match old page permissions.
|
|
$pages = $this->query('
|
|
SELECT `group`.groupId, pages.name
|
|
FROM permission
|
|
INNER JOIN `group`
|
|
ON `group`.groupId = `permission`.groupId
|
|
INNER JOIN `pages`
|
|
ON `pages`.pageId = `permission`.objectId
|
|
WHERE entityId = 1
|
|
AND view = 1
|
|
ORDER BY groupId;
|
|
');
|
|
|
|
$groupId = 0;
|
|
$features = [];
|
|
while ($page = $pages->fetch()) {
|
|
// Track the group we're on
|
|
if ($groupId !== $page['groupId']) {
|
|
if ($groupId !== 0) {
|
|
// Save the group we've been working on.
|
|
$this->execute('UPDATE `group` SET features = \'' . json_encode($features) . '\' WHERE groupId = ' . $groupId);
|
|
}
|
|
|
|
// Clear the decks
|
|
$groupId = $page['groupId'];
|
|
$features = [];
|
|
}
|
|
|
|
if (in_array($page['name'], ['index', 'manual', 'clock', 'home'])) {
|
|
// Ignore pages which we're not interested in
|
|
continue;
|
|
} else if ($page['name'] === 'schedulenow') {
|
|
// Schedule Now has its own feature.
|
|
$features[] = 'schedule.now';
|
|
} else {
|
|
// Pluralise some pages.
|
|
$pageName = in_array($page['name'], ['user', 'display']) ? $page['name'] . 's' : $page['name'];
|
|
|
|
// Not all features will have a .add/.modify, but this will grant the more permissive option and get
|
|
// reset when a user edits.
|
|
$features[] = $pageName . '.view';
|
|
$features[] = $pageName . '.add';
|
|
$features[] = $pageName . '.modify';
|
|
}
|
|
}
|
|
|
|
// Do the last one
|
|
if ($groupId !== 0) {
|
|
// Save the group we've been working on.
|
|
$this->execute('UPDATE `group` SET features = \'' . json_encode($features) . '\' WHERE groupId = ' . $groupId);
|
|
}
|
|
|
|
// Delete Page Permissions
|
|
$this->execute('DELETE FROM permission WHERE entityId = ' . $entityId);
|
|
|
|
// Delete Page Permission Entity
|
|
$this->execute('DELETE FROM permissionentity WHERE entityId = ' . $entityId);
|
|
|
|
// Delete Page Table
|
|
$this->table('pages')->drop()->save();
|
|
}
|
|
}
|