File manager - Edit - /home/capoccitel/www/wp-admin/sppagebuilder.tar
Back
sppagebuilder.php 0000705 00000010457 15242034140 0010103 0 ustar 00 <?php /** * @package JoomShaper Plugin * @subpackage Search.sppagebuilder * * @copyright Copyright (C) 2015 Open Source Matters, Inc. All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE.txt */ defined('_JEXEC') or die('Restricted access'); /** * Sppagebuilder search plugins * * @since 1.0.4 */ class PlgSearchSppagebuilder extends JPlugin { protected $autoloadLanguage = true; protected $app; /** * Determine areas searchable by this plugin. * * @return array An array of search areas. * */ public function onContentSearchAreas() { static $areas = array( 'sppagebuilder' => 'SP_PAGEBUILDER_SEARCH_AREAS' ); return $areas; } /** * Search content (SP Pagebuilder). * * The SQL must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav. * * @param string $text Target search string. * @param string $phrase Matching option (possible values: exact|any|all). Default is "any". * @param string $ordering Ordering option (possible values: newest|oldest|popular|alpha|category). Default is "newest". * @param mixed $areas An array if the search is to be restricted to areas or null to search all areas. * * @return array Search results. * */ public function onContentSearch( $text, $phrase = '', $ordering = '', $areas = null ) { $db = JFactory::getDbo(); $limit = $this->params->def('search_limit', 50); $tag = JFactory::getLanguage()->getTag(); if (is_array($areas)) { if (!array_intersect($areas, array_keys($this->onContentSearchAreas()))) { return array(); } } $text = trim($text); if ($text == '') { return array(); } JLoader::register('ContentHelperRoute', JPATH_SITE . '/components/com_content/helpers/route.php'); switch ($phrase) { case 'exact': case 'all': case 'any': default: $text = $db->quote('%' . $db->escape($text, true) . '%', false); $wheres1 = array(); $wheres1[] = 's.title LIKE ' . $text; $wheres1[] = 's.text LIKE ' . $text; $where = '((' . implode(') OR (', $wheres1) . ')) AND s.published = 1'; break; } switch ($ordering) { case 'oldest': $order = 's.created_time ASC'; break; case 'alpha': $order = 's.title ASC'; break; case 'newest': case 'category': case 'popular': default: $order = 's.created_on DESC'; break; } $query = $db->getQuery(true); if ( $limit > 0 ) { $query->clear(); $query->select('s.id as id, c.id as cID, c.catid as catid, s.title AS title, s.created_on as created, \'\' AS browsernav, \'Page\' AS section, s.language as language'); $query->from($db->quoteName('#__sppagebuilder', 's')); $query->join('LEFT', $db->quoteName('#__content', 'c') . ' ON (' . $db->quoteName('s.view_id') . ' = ' . $db->quoteName('c.id') . ' AND ' .$db->quoteName('s.active') .'= 1)'); $query->where($where); if ($this->app->isClient('site') && JLanguageMultilang::isEnabled()) { $query->where('s.language in (' . $db->quote($tag) . ',' . $db->quote('*') . ')'); } $query->order($order); $db->setQuery($query, 0, $limit); } try { $list = $db->loadObjectList(); if (isset($list)) { foreach ($list as $key => $item) { if( $item->cID ) { $list[$key]->section = 'Page - Article'; $list[$key]->href = ContentHelperRoute::getArticleRoute($item->cID, $item->catid, $item->language); } else { $list[$key]->href = JRoute::_('index.php?option=com_sppagebuilder&view=page&id='.$item->id.((($item->language != '*'))? '&lang='.$item->language:'') . $this->getItemid($item->id)); } } } } catch (RuntimeException $e) { $list = array(); $this->app->enqueueMessage(JText::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error'); } return $list; } private function getItemid($id = null) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName(array('id'))); $query->from($db->quoteName('#__menu')); $query->where($db->quoteName('link') . ' LIKE '. $db->quote('%view=page&id='. $id .'%')); $query->where($db->quoteName('published') . ' = '. $db->quote('1')); $db->setQuery($query); $result = $db->loadResult(); if($result) { return '&Itemid=' . $result; } return; } } sppagebuilder.xml 0000705 00000001527 15242034140 0010112 0 ustar 00 <?xml version="1.0" encoding="utf-8"?> <extension version="3.3" type="plugin" group="search" method="upgrade"> <name>plg_search_sppagebuilder</name> <author>JoomShaper</author> <creationDate>July 2015</creationDate> <copyright>Copyright (C) 2015 Open Source Matters. All rights reserved.</copyright> <license>GNU General Public License version 2 or later; see LICENSE.txt</license> <authorEmail>support@joomshaper.com</authorEmail> <authorUrl>www.joomshaper.com</authorUrl> <version>1.4</version> <description>PLG_SEARCH_SPPAGEBUILDER_DESCRIPTION</description> <files> <filename plugin="sppagebuilder">sppagebuilder.php</filename> </files> <languages> <language tag="en-GB">language/en-GB.plg_search_sppagebuilder.ini</language> <language tag="en-GB">language/en-GB.plg_search_sppagebuilder.sys.ini</language> </languages> </extension>
| ver. 1.6 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings