public static function treeselectbox(&$params, $id = 0, $level = 0)
{
$mainframe = JFactory::getApplication();
$root_id = (int) $params->get('root_id2');
$option = JRequest::getCmd('option');
$view = JRequest::getCmd('view');
$category = JRequest::getInt('id');
$id = (int) $id;
$user = JFactory::getUser();
$aid = (int) $user->get('aid');
$db = JFactory::getDBO();
if ($root_id != 0 && $level == 0) {
$query = "SELECT * FROM #__k2_categories WHERE parent={$root_id} AND published=1 AND trash=0 ";
} else {
$query = "SELECT * FROM #__k2_categories WHERE parent={$id} AND published=1 AND trash=0 ";
}
if (K2_JVERSION != '15') {
$query .= " AND access IN(" . implode(',', $user->getAuthorisedViewLevels()) . ") ";
if ($mainframe->getLanguageFilter()) {
$languageTag = JFactory::getLanguage()->getTag();
$query .= " AND language IN (" . $db->Quote($languageTag) . ", " . $db->Quote('*') . ") ";
}
} else {
$query .= " AND access <= {$aid}";
}
$query .= " ORDER BY ordering";
$db->setQuery($query);
$rows = $db->loadObjectList();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
if ($level == 0) {
echo '
<div class="k2CategorySelectBlock ' . $params->get('moduleclass_sfx') . '">
<form action="' . JRoute::_('index.php') . '" method="get">
<select name="category" onchange="window.location=this.form.category.value;">
<option value="' . JURI::base(true) . '/">' . JText::_('K2_SELECT_CATEGORY') . '</option>
';
}
$indent = "";
for ($i = 0; $i < $level; $i++) {
$indent .= '– ';
}
foreach ($rows as $row) {
if ($option == 'com_k2' && $category == $row->id) {
$selected = ' selected="selected"';
} else {
$selected = '';
}
if (modK2ToolsHelper::hasChildren($row->id)) {
echo '<option value="' . urldecode(JRoute::_(K2HelperRoute::getCategoryRoute($row->id . ':' . urlencode($row->alias)))) . '"' . $selected . '>' . $indent . $row->name . '</option>';
modK2ToolsHelper::treeselectbox($params, $row->id, $level + 1);
} else {
echo '<option value="' . urldecode(JRoute::_(K2HelperRoute::getCategoryRoute($row->id . ':' . urlencode($row->alias)))) . '"' . $selected . '>' . $indent . $row->name . '</option>';
}
}
if ($level == 0) {
echo '
</select>
<input name="option" value="com_k2" type="hidden" />
<input name="view" value="itemlist" type="hidden" />
<input name="task" value="category" type="hidden" />
<input name="Itemid" value="' . JRequest::getInt('Itemid') . '" type="hidden" />';
// For Joom!Fish compatibility
if (JRequest::getCmd('lang')) {
echo '<input name="lang" value="' . JRequest::getCmd('lang') . '" type="hidden" />';
}
echo '
</form>
</div>
';
}
}
$calendar = modK2ToolsHelper::calendar($params);
require JModuleHelper::getLayoutPath('mod_k2_tools', 'calendar');
break;
case '3':
//if (JRequest::getVar('option') == 'com_k2' && (JRequest::getCmd('task') == 'category' || JRequest::getInt('id'))) {
$breadcrumbs = modK2ToolsHelper::breadcrumbs($params);
$path = $breadcrumbs[0];
$title = $breadcrumbs[1];
require JModuleHelper::getLayoutPath('mod_k2_tools', 'breadcrumbs');
//}
break;
case '4':
$output = modK2ToolsHelper::treerecurse($params, 0, 0, true);
require JModuleHelper::getLayoutPath('mod_k2_tools', 'categories');
break;
case '5':
echo modK2ToolsHelper::treeselectbox($params);
break;
case '6':
if ($imagebutton) {
$img = modK2ToolsHelper::getSearchImage($button_text);
}
require JModuleHelper::getLayoutPath('mod_k2_tools', 'search');
break;
case '7':
$tags = modK2ToolsHelper::tagCloud($params);
if (count($tags)) {
require JModuleHelper::getLayoutPath('mod_k2_tools', 'tags');
}
break;
}
function treeselectbox(&$params, $id = 0, $level = 0)
{
$root_id = $params->get('root_id2');
$option = JRequest::getCmd('option');
$view = JRequest::getCmd('view');
$category = JRequest::getInt('id');
$user =& JFactory::getUser();
$aid = $user->get('aid');
$db =& JFactory::getDBO();
if ($root_id != 0 && $level == 0) {
$query = "SELECT * FROM #__k2_categories WHERE parent={$root_id} AND published=1 AND trash=0 AND access<={$aid} ORDER BY ordering ";
} else {
$query = "SELECT * FROM #__k2_categories WHERE parent={$id} AND published=1 AND trash=0 AND access<={$aid} ORDER BY ordering ";
}
$db->setQuery($query);
$rows = $db->loadObjectList();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
if ($level == 0) {
echo '
<div class="k2CategorySelectBlock ' . $params->get('moduleclass_sfx') . '">
<form action="' . JRoute::_('index.php') . '" method="get">
<select name="category" onchange="window.location=this.form.category.value;">
<option value="' . JURI::root() . '">' . JText::_("-- Select category --") . '</option>
';
}
$indent = "";
for ($i = 0; $i < $level; $i++) {
$indent .= '– ';
}
foreach ($rows as $row) {
if ($option == 'com_k2' && $category == $row->id) {
$selected = ' selected="selected"';
} else {
$selected = '';
}
if (modK2ToolsHelper::hasChildren($row->id)) {
echo '<option value="' . urldecode(JRoute::_(K2HelperRoute::getCategoryRoute($row->id . ':' . urlencode($row->alias)))) . '"' . $selected . '>' . $indent . $row->name . '</option>';
modK2ToolsHelper::treeselectbox($params, $row->id, $level + 1);
} else {
echo '<option value="' . urldecode(JRoute::_(K2HelperRoute::getCategoryRoute($row->id . ':' . urlencode($row->alias)))) . '"' . $selected . '>' . $indent . $row->name . '</option>';
}
}
if ($level == 0) {
echo '
</select>
<input name="option" value="com_k2" type="hidden" />
<input name="view" value="itemlist" type="hidden" />
<input name="task" value="category" type="hidden" />
<input name="Itemid" value="' . JRequest::getInt('Itemid') . '" type="hidden" />';
// For Joom!Fish compatibility
if (JRequest::getCmd('lang')) {
echo '<input name="lang" value="' . JRequest::getCmd('lang') . '" type="hidden" />';
}
echo '
</form>
</div>
';
}
}
