/**
* Load the record
*/
private function loadData()
{
// get record
$this->id = $this->getParameter('id', 'int');
$this->isGod = BackendAuthentication::getUser()->isGod();
// check if something went wrong
if ($this->id === null || !BackendPagesModel::exists($this->id)) {
$this->redirect(BackendModel::createURLForAction('index') . '&error=non-existing');
}
// get the record
$this->record = BackendPagesModel::get($this->id);
// load blocks
$this->blocksContent = BackendPagesModel::getBlocks($this->id, $this->record['revision_id']);
// is there a revision specified?
$revisionToLoad = $this->getParameter('revision', 'int');
// if this is a valid revision
if ($revisionToLoad !== null) {
// overwrite the current record
$this->record = (array) BackendPagesModel::get($this->id, $revisionToLoad);
// load blocks
$this->blocksContent = BackendPagesModel::getBlocks($this->id, $revisionToLoad);
// show warning
$this->tpl->assign('appendRevision', true);
}
// is there a revision specified?
$draftToLoad = $this->getParameter('draft', 'int');
// if this is a valid revision
if ($draftToLoad !== null) {
// overwrite the current record
$this->record = (array) BackendPagesModel::get($this->id, $draftToLoad);
// load blocks
$this->blocksContent = BackendPagesModel::getBlocks($this->id, $draftToLoad);
// show warning
$this->tpl->assign('appendRevision', true);
}
// reset some vars
$this->record['full_url'] = BackendPagesModel::getFullURL($this->record['id']);
$this->record['is_hidden'] = $this->record['hidden'] == 'Y';
}
/**
* Execute the action
*
* @return void
*/
public function execute()
{
// call parent, this will probably add some general CSS/JS or other required files
parent::execute();
// get parameters
$from = $this->getParameter('from');
$to = $this->getParameter('to');
// validate
if ($from == '') {
throw new BackendException('Specify a from-parameter.');
}
if ($to == '') {
throw new BackendException('Specify a to-parameter.');
}
// get db
$db = BackendModel::getDB(true);
// get all old pages
$ids = $db->getColumn('SELECT id
FROM pages AS i
WHERE i.language = ? AND i.status = ?', array($to, 'active'));
// any old pages
if (!empty($ids)) {
// delete existing pages
foreach ($ids as $id) {
// redefine
$id = (int) $id;
// get revision ids
$revisionIDs = (array) $db->getColumn('SELECT i.revision_id
FROM pages AS i
WHERE i.id = ? AND i.language = ?', array($id, $to));
// get meta ids
$metaIDs = (array) $db->getColumn('SELECT i.meta_id
FROM pages AS i
WHERE i.id = ? AND i.language = ?', array($id, $to));
// delete meta records
if (!empty($metaIDs)) {
$db->delete('meta', 'id IN (' . implode(',', $metaIDs) . ')');
}
// delete blocks and their revisions
if (!empty($revisionIDs)) {
$db->delete('pages_blocks', 'revision_id IN (' . implode(',', $revisionIDs) . ')');
}
// delete page and the revisions
if (!empty($revisionIDs)) {
$db->delete('pages', 'revision_id IN (' . implode(',', $revisionIDs) . ')');
}
}
}
// delete search indexes
$db->delete('search_index', 'module = ? AND language = ?', array('pages', $to));
// get all active pages
$ids = BackendModel::getDB()->getColumn('SELECT id
FROM pages AS i
WHERE i.language = ? AND i.status = ?', array($from, 'active'));
// loop
foreach ($ids as $id) {
// get data
$sourceData = BackendPagesModel::get($id, $from);
// get and build meta
$meta = $db->getRecord('SELECT *
FROM meta
WHERE id = ?', $sourceData['meta_id']);
// remove id
unset($meta['id']);
// build page record
$page = array();
$page['id'] = $sourceData['id'];
$page['user_id'] = BackendAuthentication::getUser()->getUserId();
$page['parent_id'] = $sourceData['parent_id'];
$page['template_id'] = $sourceData['template_id'];
$page['meta_id'] = (int) $db->insert('meta', $meta);
$page['language'] = $to;
$page['type'] = $sourceData['type'];
$page['title'] = $sourceData['title'];
$page['navigation_title'] = $sourceData['navigation_title'];
$page['navigation_title_overwrite'] = $sourceData['navigation_title_overwrite'];
$page['hidden'] = $sourceData['hidden'];
$page['status'] = 'active';
$page['publish_on'] = BackendModel::getUTCDate();
$page['created_on'] = BackendModel::getUTCDate();
$page['edited_on'] = BackendModel::getUTCDate();
$page['allow_move'] = $sourceData['allow_move'];
$page['allow_children'] = $sourceData['allow_children'];
$page['allow_edit'] = $sourceData['allow_edit'];
$page['allow_delete'] = $sourceData['allow_delete'];
$page['sequence'] = $sourceData['sequence'];
$page['data'] = $sourceData['data'] !== null ? serialize($sourceData['data']) : null;
// insert page, store the id, we need it when building the blocks
$revisionId = BackendPagesModel::insert($page);
// init var
$blocks = array();
$hasBlock = $sourceData['has_extra'] == 'Y';
// get the blocks
$sourceBlocks = BackendPagesModel::getBlocks($id, $from);
// loop blocks
foreach ($sourceBlocks as $sourceBlock) {
// build block
$block = array();
$block['id'] = $sourceBlock['id'];
$block['revision_id'] = $revisionId;
$block['extra_id'] = $sourceBlock['extra_id'];
$block['html'] = $sourceBlock['html'];
$block['status'] = 'active';
$block['created_on'] = BackendModel::getUTCDate();
$block['edited_on'] = BackendModel::getUTCDate();
// add block
$blocks[] = $block;
}
// insert the blocks
BackendPagesModel::insertBlocks($blocks, $hasBlock);
// check if the method exists
if (method_exists('BackendSearchModel', 'addIndex')) {
// init var
$text = '';
// build search-text
foreach ($blocks as $block) {
$text .= ' ' . $block['html'];
}
// add
BackendSearchModel::addIndex('pages', (int) $page['id'], array('title' => $page['title'], 'text' => $text), $to);
}
// get tags
$tags = BackendTagsModel::getTags('pages', $id, 'string', $from);
// save tags
if ($tags != '') {
BackendTagsModel::saveTags($page['id'], $tags, 'pages');
}
}
// build cache
BackendPagesModel::buildCache($to);
}
/**
* Switch templates for all existing pages
*
* @param int $oldTemplateId The id of the new template to replace.
* @param int $newTemplateId The id of the new template to use.
* @param bool[optional] $overwrite Overwrite all pages with default blocks.
*/
public static function updatePagesTemplates($oldTemplateId, $newTemplateId, $overwrite = false)
{
$newTemplateId = (int) $newTemplateId;
$oldTemplateId = (int) $oldTemplateId;
$overwrite = (bool) $overwrite;
// fetch new template data
$newTemplate = BackendExtensionsModel::getTemplate($newTemplateId);
$newTemplate['data'] = @unserialize($newTemplate['data']);
// fetch all pages
$pages = (array) BackendModel::getDB()->getRecords('SELECT *
FROM pages
WHERE template_id = ? AND status IN (?, ?)', array($oldTemplateId, 'active', 'draft'));
// there is no active/draft page with the old template id
if (empty($pages)) {
return;
}
// loop pages
foreach ($pages as $page) {
// fetch blocks
$blocksContent = BackendPagesModel::getBlocks($page['id'], $page['revision_id'], $page['language']);
// unset revision id
unset($page['revision_id']);
// change template
$page['template_id'] = $newTemplateId;
// save new page revision
$page['revision_id'] = BackendPagesModel::update($page);
// overwrite all blocks with current defaults
if ($overwrite) {
// init var
$blocksContent = array();
// fetch default blocks for this page
$defaultBlocks = array();
if (isset($newTemplate['data']['default_extras_' . $page['language']])) {
$defaultBlocks = $newTemplate['data']['default_extras_' . $page['language']];
} elseif (isset($newTemplate['data']['default_extras'])) {
$defaultBlocks = $newTemplate['data']['default_extras'];
}
// loop positions
foreach ($defaultBlocks as $position => $blocks) {
// loop blocks
foreach ($blocks as $extraId) {
// build block
$block = array();
$block['revision_id'] = $page['revision_id'];
$block['position'] = $position;
$block['extra_id'] = $extraId;
$block['html'] = '';
$block['created_on'] = BackendModel::getUTCDate();
$block['edited_on'] = $block['created_on'];
$block['visible'] = 'Y';
$block['sequence'] = count($defaultBlocks[$position]) - 1;
// add to the list
$blocksContent[] = $block;
}
}
} else {
// set new page revision id
foreach ($blocksContent as &$block) {
$block['revision_id'] = $page['revision_id'];
}
}
// insert the blocks
BackendPagesModel::insertBlocks($blocksContent);
}
}