public function postIndex()
{
// update blocks
AdminLog::new_log('Updated Site-wide Content');
$versionId = PageVersion::add_new(0)->version_id;
Block::submit(0, $versionId);
$this->addAlert('success', 'Site-wide Content Updated');
return \redirect()->route('coaster.admin.blocks');
}
/**
* @param string $content
*/
public function updateContent($content)
{
if (!$this->_versionId) {
$this->_versionId = PageVersion::add_new($this->_pageId)->version_id;
}
if ($this->_repeaterId && $this->_repeaterRowId) {
PageBlockRepeaterData::updateBlockData($content, $this->id, $this->_versionId, $this->_repeaterId, $this->_repeaterRowId);
} elseif ($this->_pageId) {
PageBlock::updateBlockData($content, $this->id, $this->_versionId, $this->_pageId);
} else {
PageBlockDefault::updateBlockData($content, $this->id, $this->_versionId);
}
}
public function postEdit($pageId)
{
$existingPage = Page::find($pageId);
if (!$existingPage) {
return 'Page not found';
}
$publish = false;
$publishing = (bool) config('coaster::admin.publishing');
$canPublish = Auth::action('pages.version-publish', ['page_id' => $pageId]);
if ($publishing && $existingPage->link == 0) {
// check if publish
if (Request::input('publish') != '' && $canPublish) {
$publish = true;
// check if there were requests to publish the version being edited
$overwriting_page_version = PageVersion::where('version_id', '=', Request::input('versionFrom'))->where('page_id', '=', $pageId)->first();
$requests = PagePublishRequests::where('page_version_id', '=', $overwriting_page_version->id)->where('status', '=', 'awaiting')->get();
if (!$requests->isEmpty()) {
foreach ($requests as $request) {
$request->status = 'approved';
$request->mod_id = Auth::user()->id;
$request->save();
}
}
}
} elseif (!$publishing || $existingPage->link == 1 && $canPublish) {
$publish = true;
}
$page_info = Request::input('page_info') ?: [];
$page_info_lang = Request::input('page_info_lang') ?: [];
$page_groups = Request::input('page_groups') ?: [];
$page_info_other = Request::input('page_info_other') ?: [];
// run if duplicate button was hit
if (Request::input('duplicate') == 1) {
if ($existingPage->canDuplicate()) {
if ($duplicatePage = $existingPage->saveDuplicateFromPostData($page_info, $page_info_lang, $page_groups, $page_info_other)) {
Repeater::setDuplicate();
Block::submit($duplicatePage->id, 1, $publish);
return \redirect()->route('coaster.admin.pages.edit', ['pageId' => $duplicatePage->id]);
} else {
$this->addAlert('danger', 'Duplication failed');
return $this->getEdit($pageId);
}
} else {
return abort(403, 'Action not permitted');
}
}
$version = PageVersion::add_new($pageId);
// save page info
if ($existingPage->savePostData($version, $page_info, $page_info_lang, $page_groups, $page_info_other)) {
AdminLog::new_log('Updated page \'' . $existingPage->pageLang()->name . '\' (Page ID ' . $existingPage->id . ')');
} else {
$this->addAlert('warning', '"Page Info" not updated (check tab for errors)');
}
// update blocks
Block::submit($pageId, $version->version_id, $publish);
$this->addAlert('success', 'Page Content Updated');
if ($publish) {
if (Request::input('publish_request') != '') {
PagePublishRequests::add($pageId, $version->version_id, Request::input('request_note'));
}
$version->publish();
}
// display page edit form
return $this->getEdit($pageId, $version->version_id);
}
public static function _pageImportData($theme)
{
$importPath = $themePath = base_path() . '/resources/views/themes/' . $theme->theme . '/import/';
if (is_dir($importPath)) {
// wipe data
DB::table((new Page())->getTable())->truncate();
DB::table((new PageLang())->getTable())->truncate();
DB::table((new PageVersion())->getTable())->truncate();
DB::table((new PagePublishRequests())->getTable())->truncate();
DB::table((new PageGroup())->getTable())->truncate();
DB::table((new PageGroupAttribute())->getTable())->truncate();
DB::table((new PageGroupPage())->getTable())->truncate();
DB::table((new Menu())->getTable())->truncate();
DB::table((new MenuItem())->getTable())->truncate();
DB::table((new PageBlockDefault())->getTable())->truncate();
DB::table((new PageBlock())->getTable())->truncate();
DB::table((new PageBlockRepeaterData())->getTable())->truncate();
DB::table((new PageBlockRepeaterRows())->getTable())->truncate();
$templateIds = [];
$templates = Template::where('theme_id', '=', $theme->id)->get();
foreach ($templates as $template) {
$templateIds[$template->template] = $template->id;
}
$blockIds = [];
$blocks = Block::all();
foreach ($blocks as $block) {
$blockIds[$block->name] = $block->id;
}
$pagesCsv = $importPath . 'pages.csv';
$groupsCsv = $importPath . 'pages/groups.csv';
$groupAttributesCsv = $importPath . 'pages/group_attributes.csv';
$menusCsv = $importPath . 'pages/menus.csv';
$menuItemsCsv = $importPath . 'pages/menu_items.csv';
$pageBlocksCsv = $importPath . 'pages/page_blocks.csv';
$repeaterBlocksCsv = $importPath . 'pages/repeater_blocks.csv';
// checks
$error = 'pages data not imported, invalid columns in: ';
if (!($pagesFileHandle = Csv::check($pagesCsv, 14))) {
if (file_exists($pagesCsv)) {
throw new \Exception($error . $pagesCsv);
}
}
if (!($groupsHandle = Csv::check($groupsCsv, 5))) {
if (file_exists($groupsCsv)) {
throw new \Exception($error . $groupsCsv);
}
}
if (!($groupAttributesHandle = Csv::check($groupAttributesCsv, 6))) {
if (file_exists($groupAttributesCsv)) {
throw new \Exception($error . $groupAttributesCsv);
}
}
if (!($menusHandle = Csv::check($menusCsv, 3))) {
if (file_exists($menusCsv)) {
throw new \Exception($error . $menusCsv);
}
}
if (!($menuItemsCsvHandle = Csv::check($menuItemsCsv, 5))) {
if (file_exists($menuItemsCsv)) {
throw new \Exception($error . $menuItemsCsv);
}
}
if (!($pageBlocksCsvHandle = Csv::check($pageBlocksCsv, 3))) {
if (file_exists($pageBlocksCsv)) {
throw new \Exception($error . $pageBlocksCsv);
}
}
if (!($repeaterBlocksCsvHandle = Csv::check($repeaterBlocksCsv, 4))) {
if (file_exists($repeaterBlocksCsv)) {
throw new \Exception($error . $repeaterBlocksCsv);
}
}
// add pages
if ($pagesFileHandle) {
$row = 0;
while (($data = fgetcsv($pagesFileHandle)) !== false) {
if ($row++ == 0 && $data[0] == 'Page Id') {
continue;
}
list($pageId, $pageName, $pageUrl, $templateName, $parentId, $defaultChildTemplateName, $order, $link, $live, $sitemap, $groupContainer, $groupContainerUrlPriority, $canonicalParentPageId, $groupIds) = $data;
$newPage = new Page();
$newPage->id = $pageId;
$newPage->template = !empty($templateIds[$templateName]) ? $templateIds[$templateName] : 0;
$newPage->parent = $parentId ?: 0;
$newPage->child_template = !empty($templateIds[$defaultChildTemplateName]) ? $templateIds[$defaultChildTemplateName] : 0;
$newPage->order = $order;
$newPage->link = $link;
$newPage->live = $live;
$newPage->sitemap = $sitemap;
$newPage->group_container = $groupContainer ?: 0;
$newPage->group_container_url_priority = $groupContainerUrlPriority ?: 0;
$newPage->canonical_parent = $canonicalParentPageId ?: 0;
$newPage->save();
$newPageLang = new PageLang();
$newPageLang->page_id = $pageId;
$newPageLang->language_id = Language::current();
$newPageLang->name = $pageName;
$newPageLang->url = $pageUrl;
$newPageLang->live_version = 1;
$newPageLang->save();
PageVersion::add_new($pageId);
$groupIds = trim($groupIds);
$groupIds = $groupIds ? explode(',', $groupIds) : [];
foreach ($groupIds as $groupId) {
$newPageGroupPage = new PageGroupPage();
$newPageGroupPage->page_id = $pageId;
$newPageGroupPage->group_id = $groupId;
$newPageGroupPage->save();
}
}
}
// add page groups
if ($groupsHandle) {
$row = 0;
while (($data = fgetcsv($groupsHandle)) !== false) {
if ($row++ == 0 && $data[0] == 'Group Id') {
continue;
}
list($groupId, $groupName, $itemName, $defaultContainerPageId, $defaultTemplate) = $data;
$newGroup = new PageGroup();
$newGroup->id = $groupId;
$newGroup->name = $groupName;
$newGroup->item_name = $itemName;
$newGroup->url_priority = $defaultContainerPageId;
$newGroup->default_template = !empty($templateIds[$defaultTemplate]) ? $templateIds[$defaultTemplate] : 0;
$newGroup->save();
}
}
if ($groupAttributesHandle) {
$row = 0;
while (($data = fgetcsv($groupAttributesHandle)) !== false) {
if ($row++ == 0 && $data[0] == 'Attribute Id') {
continue;
}
list($attributeId, $groupId, $blockName, $orderPriority, $orderDir, $filerByBlockName) = $data;
$newGroupAttribute = new PageGroupAttribute();
$newGroupAttribute->id = $attributeId;
$newGroupAttribute->group_id = $groupId;
$newGroupAttribute->item_block_id = !empty($blockIds[$blockName]) ? $blockIds[$blockName] : 0;
$newGroupAttribute->item_block_order_priority = $orderPriority;
$newGroupAttribute->item_block_order_dir = $orderDir == 'desc' ? $orderDir : 'asc';
$newGroupAttribute->filter_by_block_id = !empty($blockIds[$filerByBlockName]) ? $blockIds[$filerByBlockName] : 0;
$newGroupAttribute->save();
}
}
// add menus
if ($menusHandle) {
$menuIds = [];
$row = 0;
while (($data = fgetcsv($menusHandle)) !== false) {
if ($row++ == 0 && $data[0] == 'Menu Identifier') {
continue;
}
list($name, $label, $maxSublevel) = $data;
$newMenu = new Menu();
$newMenu->label = $label;
$newMenu->name = $name;
$newMenu->max_sublevel = $maxSublevel;
$newMenu->save();
$menuIds[$name] = $newMenu->id;
}
}
if ($menuItemsCsvHandle) {
$row = 0;
while (($data = fgetcsv($menuItemsCsvHandle)) !== false) {
if ($row++ == 0 && $data[0] == 'Menu Identifier') {
continue;
}
list($menuIdentifier, $pageId, $order, $subLevels, $customName) = $data;
if (!empty($menuIds[$menuIdentifier])) {
$newMenuItem = new MenuItem();
$newMenuItem->menu_id = $menuIds[$menuIdentifier];
$newMenuItem->page_id = $pageId;
$newMenuItem->order = $order;
$newMenuItem->sub_levels = $subLevels;
$newMenuItem->custom_name = $customName;
$newMenuItem->save();
}
}
}
// add page content
if ($pageBlocksCsvHandle) {
$row = 0;
while (($data = fgetcsv($pageBlocksCsvHandle)) !== false) {
if ($row++ == 0 && $data[0] == 'Page Id') {
continue;
}
list($pageId, $blockName, $content) = $data;
if (!empty($blockIds[$blockName])) {
if ($pageId) {
$newPageBlock = new PageBlock();
$newPageBlock->page_id = $pageId;
} else {
$newPageBlock = new PageBlockDefault();
}
$newPageBlock->block_id = $blockIds[$blockName];
$newPageBlock->version = 1;
$newPageBlock->content = $content;
$newPageBlock->save();
}
}
}
if ($repeaterBlocksCsvHandle) {
$row = 0;
$existingRepeaterRowKeys = [];
while (($data = fgetcsv($repeaterBlocksCsvHandle)) !== false) {
if ($row++ == 0 && $data[0] == 'Repeater Id') {
continue;
}
list($repeaterId, $repeaterRowId, $blockName, $content) = $data;
if (!empty($blockIds[$blockName])) {
if ($decodedContent = json_decode($content)) {
if (!is_string($decodedContent)) {
$content = serialize($decodedContent);
}
}
if (!isset($existingRepeaterRowKeys[$repeaterId . '-' . $repeaterRowId])) {
$newRepeaterRow = new PageBlockRepeaterRows();
$newRepeaterRow->repeater_id = $repeaterId;
$newRepeaterRow->row_id = $repeaterRowId;
$newRepeaterRow->save();
$existingRepeaterRowKeys[$repeaterId . '-' . $repeaterRowId] = $newRepeaterRow->id;
$newRepeaterData = new PageBlockRepeaterData();
$newRepeaterData->row_key = $existingRepeaterRowKeys[$repeaterId . '-' . $repeaterRowId];
$newRepeaterData->block_id = 0;
$newRepeaterData->version = 1;
$newRepeaterData->content = $repeaterRowId;
$newRepeaterData->save();
}
$newRepeaterData = new PageBlockRepeaterData();
$newRepeaterData->row_key = $existingRepeaterRowKeys[$repeaterId . '-' . $repeaterRowId];
$newRepeaterData->block_id = $blockIds[$blockName];
$newRepeaterData->version = 1;
$newRepeaterData->content = $content;
$newRepeaterData->save();
}
}
}
PageSearchData::updateAllSearchData();
}
}
