/**
* @param string $keyword
* @param int $keywordAdditionalWeight
*/
public function run($keyword, $keywordAdditionalWeight = 0)
{
$searchData = PageSearchData::with('block')->where('search_text', 'LIKE', '%' . $keyword . '%')->get();
foreach ($searchData as $searchRow) {
$page = Page::preload($searchRow->page_id);
if (!$this->_onlyLive || $page->is_live()) {
$this->_addWeight($page, (($b = $searchRow->block) ? $b->search_weight : 2) + $keywordAdditionalWeight);
}
}
}
public function publish($set_live = false, $ignore_auth = false)
{
$page_lang = PageLang::where('page_id', '=', $this->page_id)->where('language_id', '=', Language::current())->first();
$page = Page::find($this->page_id);
$publishingOn = config('coaster::admin.publishing') > 0 ? true : false;
$haveAuth = $ignore_auth || ($publishingOn && Auth::action('pages.version-publish', ['page_id' => $this->page_id]) || !$publishingOn && Auth::action('pages.edit', ['page_id' => $this->page_id]));
if (!empty($page_lang) && !empty($page) && $haveAuth) {
$page_lang->live_version = $this->version_id;
$page_lang->save();
PageSearchData::updateText(strip_tags($page_lang->name), 0, $page->id);
$page->template = $this->template;
if ($set_live && $page->live == 0) {
if (!empty($page->live_start) || !empty($page->live_end)) {
$page->live = 2;
} else {
$page->live = 1;
}
}
$page->save();
return 1;
}
return 0;
}
/**
* @param string $searchText
* @return bool
*/
public function publishContent($searchText)
{
if ($this->_pageId) {
if (!$this->_repeaterId) {
PageSearchData::updateText($searchText, $this->id, $this->_pageId);
}
$pageVersion = PageVersion::getLiveVersion($this->_pageId);
if ($this->_versionId != $pageVersion->version_id) {
return $pageVersion->publish();
}
}
return false;
}
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();
}
}
public function getSearch()
{
PageSearchData::updateAllSearchData();
AdminLog::new_log('Search index updated');
// as ajax call
return 1;
}
/**
* Saves page data
* @param PageVersion $pageVersion
* @param array $pagePost
* @param array $pageLangPost
* @param array $pageGroupsPost
* @param array $pageInfoOther
* @return bool
*/
public function savePostData($pageVersion, $pagePost, $pageLangPost, $pageGroupsPost, $pageInfoOther = [])
{
/*
* Post data fixes
*/
foreach ($pagePost as $k => $pagePostField) {
if (is_array($pagePostField) && array_key_exists('exists', $pagePostField)) {
$pagePost[$k] = array_key_exists('select', $pagePostField) ? $pagePostField['select'] : 0;
}
}
if (array_key_exists('live_start', $pagePost)) {
$pagePost['live_start'] = DateTimeHelper::jQueryToMysql($pagePost['live_start']) ?: null;
}
if (array_key_exists('live_end', $pagePost)) {
$pagePost['live_end'] = DateTimeHelper::jQueryToMysql($pagePost['live_end']) ?: null;
}
foreach ($pageInfoOther as $k => $pageInfoOtherField) {
if (is_array($pageInfoOtherField) && array_key_exists('exists', $pageInfoOtherField) && array_key_exists('select', $pageInfoOtherField)) {
$pageInfoOther[$k] = $pageInfoOtherField['select'];
}
}
/*
* Overwrite default/existing data with posted data
*/
$pageDefaults = array_merge(['template' => 0, 'parent' => 0, 'child_template' => 0, 'order' => 0, 'group_container' => 0, 'group_container_url_priority' => 0, 'canonical_parent' => 0, 'link' => 0, 'live' => 0, 'sitemap' => 1, 'live_start' => null, 'live_end' => null], $this->getAttributes());
foreach ($pageDefaults as $pageAttribute => $pageDefault) {
$this->{$pageAttribute} = $pageDefault;
switch ($pageAttribute) {
case 'template':
$pageVersion->{$pageAttribute} = $pagePost[$pageAttribute];
break;
default:
$this->{$pageAttribute} = array_key_exists($pageAttribute, $pagePost) ? $pagePost[$pageAttribute] : $this->{$pageAttribute};
}
}
if (!$this->pageCurrentLang) {
$this->setRelation('pageCurrentLang', ($d = $this->pageDefaultLang) ? $d->replicate() : new PageLang());
unset($this->pageCurrentLang->language_id);
}
$pageLang = $this->pageLang();
$pageLangDefaults = array_merge(['language_id' => Language::current(), 'url' => '', 'name' => '', 'live_version' => 1], $pageLang->getAttributes());
foreach ($pageLangDefaults as $pageLangAttribute => $pageLangDefault) {
$pageLang->{$pageLangAttribute} = array_key_exists($pageLangAttribute, $pageLangPost) ? $pageLangPost[$pageLangAttribute] : $pageLangDefault;
}
/*
* Check page parent exists if set and page limit is not hit
*/
$parent = static::find($this->parent);
if ($this->parent > 0 && !$parent) {
return false;
}
if (!$this->id && !$this->link && static::at_limit($this->parent == -1)) {
return false;
}
/*
* Check page name/url set and does not conflict
*/
$pageLang->url = trim($pageLang->url);
if (!$this->link) {
$pageLang->url = strtolower(str_replace(['/', ' '], '-', $pageLang->url));
if (preg_match('#^[-]+$#', $pageLang->url)) {
$pageLang->url = '';
}
if ($pageLang->url == '' && !$this->parent) {
$pageLang->url = '/';
}
$siblings = [];
foreach ($pageGroupsPost as $pageGroupId => $checkedVal) {
$pageGroup = PageGroup::preload($pageGroupId);
$siblings = array_merge($pageGroup->exists ? $pageGroup->itemPageIds() : [], $siblings);
}
if ($this->parent >= 0) {
$siblings = array_merge(static::getChildPageIds($this->parent), $siblings);
}
$siblings = array_unique($siblings);
}
if (!$pageLang->name) {
FormMessage::add('page_info_lang[name]', 'page name required');
}
if (!$pageLang->url) {
FormMessage::add('page_info_lang[url]', 'page url required');
}
if (!empty($siblings)) {
$same_level = PageLang::where('url', '=', $pageLang->url)->whereIn('page_id', $siblings);
$same_level = $this->id ? $same_level->where('page_id', '!=', $this->id) : $same_level;
if (!$same_level->get()->isEmpty()) {
FormMessage::add('page_info_lang[url]', 'url in use by another page!');
$pageLang->url = '';
}
}
if (!$pageLang->name || !$pageLang->url) {
return false;
}
/*
* If adding a page as a group container, create container / check exists
*/
if ($this->group_container == -1) {
$groupContainer = new PageGroup();
$groupContainer->name = $pageLang->name;
$groupContainer->item_name = 'Page';
$groupContainer->default_template = 0;
$groupContainer->save();
$this->group_container = $groupContainer->id;
} elseif ($this->group_container) {
$groupContainer = PageGroup::preload($this->group_container);
if (!$groupContainer->exists || $pageDefaults['group_container'] != $this->group_container && !$groupContainer->canEditItems()) {
$this->group_container = 0;
}
}
/*
* Check if page info can be updated (based on publishing auth action, or allowed if new page)
*/
$authPageIdCheck = $this->id ?: ($this->parent > 0 ? $this->parent : 0);
$canPublish = config('coaster::admin.publishing') > 0 && Auth::action('pages.version-publish', ['page_id' => $authPageIdCheck]) || config('coaster::admin.publishing') == 0 && Auth::action('pages.edit', ['page_id' => $authPageIdCheck]);
$canPublish = $canPublish || isset($groupContainer) && (config('coaster::admin.publishing') > 0 && $groupContainer->canPublishItems() || config('coaster::admin.publishing') == 0 && $groupContainer->canEditItems());
$willPublish = !$this->id || $canPublish;
/*
* Check and save page changes
*/
if ($willPublish) {
// if new page set as last ordered page
if ($this->parent >= 0 && !$this->id) {
$lastSibling = static::where('parent', '=', $this->parent)->orderBy('order', 'desc')->first();
$this->order = $lastSibling ? $lastSibling->order + 1 : 1;
}
// if new page publish template
$this->template = $this->id ? $this->template : $pageVersion->template;
// if link remove live template
$this->template = $this->link ? 0 : $this->template;
// set page live between but no dates set set as hidden, or if can't publish set as hidden
$this->live = $this->live == 2 && is_null($this->live_end) && is_null($this->live_start) ? 0 : $this->live;
$this->live = $canPublish ? $this->live : 0;
// save page data
$this->save();
$pageLang->page_id = $this->id;
$pageLang->save();
}
$pageVersion->page_id = $this->id;
$pageVersion->save();
/*
* Update title block to the page name is new page
*/
if (!$this->id && ($titleBlock = Block::where('name', '=', config('coaster::admin.title_block'))->first())) {
$titleBlock->setVersionId($pageVersion->version_id)->setPageId($this->id)->getTypeObject()->save($pageLang->name);
PageSearchData::updateText(strip_tags($pageLang->name), 0, $this->id);
}
/*
* Save Page Groups
*/
$currentGroupIds = $this->groupIds();
$newGroupIds = array_keys($pageGroupsPost);
PageGroupPage::where('page_id', '=', $this->id)->whereIn('group_id', array_diff($currentGroupIds, $newGroupIds))->delete();
foreach (array_diff($newGroupIds, $currentGroupIds) as $addGroupId) {
$this->groups()->attach($addGroupId);
}
/*
* Save other page info
*/
if ($willPublish && Auth::action('menus')) {
MenuItem::set_page_menus($this->id, array_key_exists('menus', $pageInfoOther) ? $pageInfoOther['menus'] : []);
}
if ($canPublish && array_key_exists('beacons', $pageInfoOther) && Auth::action('themes.beacons-update')) {
BlockBeacon::updatePage($this->id, $pageInfoOther['beacons']);
}
return true;
}
/**
* @param array $options
* @return string
*/
public function search($options = [])
{
Search::searchBlockFound();
$pages = [];
if ($this->searchQuery !== false) {
$pages = PageSearchData::lookup($this->searchQuery);
if (!empty($pages)) {
if (!empty($options['templates'])) {
foreach ($pages as $k => $page) {
if (!isset($page->template) || !in_array($page->template, $options['templates'])) {
unset($pages[$k]);
}
}
}
if (!empty($options['groups'])) {
$pageIds = [];
$pageGroupPages = PageGroupPage::whereIn('group_id', $options['groups'])->get();
foreach ($pageGroupPages as $pageGroupPage) {
$pageIds[] = $pageGroupPage->page_id;
}
foreach ($pages as $k => $page) {
if (!in_array($page->id, $pageIds)) {
unset($pages[$k]);
}
}
}
$results = count($pages);
$showing = "";
if ($results > 20) {
$page = (int) Request::input('page');
$page = $page < 1 ? 1 : $page;
$max = $page * 20 > $results ? $results : $page * 20;
$showing = " [showing " . (($page - 1) * 20 + 1) . " - " . $max . "]";
}
$options['content'] = "Search results for '" . $this->searchQuery . "' (" . $results . " match" . (count($pages) > 1 ? 'es' : null) . " found)" . $showing . ":";
} else {
$options['content'] = "No results found for '" . $this->searchQuery . "'.";
}
} else {
$options['content'] = array_key_exists('content', $options) ? $options['content'] : "No search query entered.";
}
return $this->_renderCategory(0, $pages, $options);
}