Done !
| Server IP : 46.105.57.169 / Your IP : 216.73.216.67 Web Server : Apache System : Linux webm002.cluster120.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64 User : verseaumee ( 152031) PHP Version : 8.5.7 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/verseaumee/ptitsanes/modules/mod_sr_experience_search/ |
Upload File : |
<?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();
}
}