File manager - Edit - /home/verseaumee/ptitsanes/modules/mod_sr_experience_search/helper.php
Back
<?php /*------------------------------------------------------------------------ Solidres - Hotel booking extension for Joomla ------------------------------------------------------------------------ @Author Solidres Team @Website http://www.solidres.com @Copyright Copyright (C) 2013 - 2018 Solidres. All Rights Reserved. @License GNU General Public License version 3, or later ------------------------------------------------------------------------*/ defined('_JEXEC') or die; class ModSRExperienceSearchHelper { public static function getFilterRangeByPrice() { static $filterRange; if (null === $filterRange) { $app = JFactory::getApplication('site'); $currentCurrencyId = $app->input->cookie->get('solidres_currency', 0, 'int'); if (!$currentCurrencyId) { $currentCurrencyId = JComponentHelper::getParams('com_solidres')->get('default_currency_id', 0); } $db = JFactory::getDbo(); $query = $db->getQuery(true) ->select('filter_range') ->from('#__sr_currencies') ->where('id = ' . (int) $currentCurrencyId); $db->setQuery($query); $filterRange = explode("\r\n", $db->loadResult()); foreach ($filterRange as &$range) { $temp = explode('-', preg_replace('/\s+/', '', $range), 2); $range = array((float) $temp[0], (float) $temp[1]); } } return $filterRange; } public static function getLocations($type) { static $locations = array(); if (!isset($locations[$type])) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $solidresConfig = JComponentHelper::getParams('com_solidres'); $isMultilingualMode = $solidresConfig->get('enable_multilingual_mode', 1); $lang = JFactory::getLanguage(); if ($isMultilingualMode && ($lang->getDefault() != $lang->getTag()) && JComponentHelper::isEnabled('com_falang')) { $lang = JFactory::getLanguage(); $langTable = JTable::getInstance('Language', 'JTable'); $langTable->load(array('lang_code' => $lang->getTag())); $query->select('DISTINCT a.value') ->from($db->qn('#__falang_content', 'a')) ->where('a.reference_table = ' . $db->q('sr_experiences')) ->where('a.reference_field = ' . $db->q($type . '_location')) ->where('language_id = ' . $langTable->lang_id); } else { $query->select('DISTINCT a.' . $type . '_location') ->from($db->qn('#__sr_experiences', 'a')) ->where('a.state = 1'); } $db->setQuery($query); $columns = $db->loadColumn(); $locations[$type] = $columns ? $columns : array(); } return $locations[$type]; } public static function getCategories($ids) { $db = JFactory::getDbo(); $query = $db->getQuery(true) ->select('a.id, a.name') ->from($db->qn('#__sr_experience_categories', 'a')); if (!empty($ids)) { $query->where('a.id IN (' . join(',', Joomla\Utilities\ArrayHelper::toInteger($ids)) . ')'); } $db->setQuery($query); return $db->loadObjectList(); } }
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings