protected function getInput()
{
$db = JFactory::getDBO();
//build the list of categories
$query = 'SELECT a.title AS text, a.id AS value, a.parent_id as parentid' . ' FROM #__phocadownload_categories AS a' . ' WHERE a.published = 1' . ' ORDER BY a.ordering';
$db->setQuery($query);
$data = $db->loadObjectList();
// TODO - check for other views than category edit
$view = JRequest::getVar('view');
$catId = -1;
if ($view == 'phocadownloadcat') {
$id = $this->form->getValue('id');
// id of current category
if ((int) $id > 0) {
$catId = $id;
}
}
/*if ($view == 'phocadownloadfile') {
$id = $this->form->getValue('catid'); // id of current category
if ((int)$id > 0) {
$catId = $id;
}
}*/
$required = (string) $this->element['required'] == 'true' ? TRUE : FALSE;
$tree = array();
$text = '';
$tree = PhocaDownloadCategory::CategoryTreeOption($data, $tree, 0, $text, $catId);
//if ($required == TRUE) {
//} else {
array_unshift($tree, JHTML::_('select.option', '', '- ' . JText::_('COM_PHOCADOWNLOAD_SELECT_CATEGORY') . ' -', 'value', 'text'));
//}
return JHTML::_('select.genericlist', $tree, $this->name, 'class="inputbox"', 'value', 'text', $this->value, $this->id);
}
function display($tpl = null) {
$app = JFactory::getApplication();
JHtml::_('behavior.tooltip');
JHtml::_('behavior.formvalidation');
JHtml::_('behavior.keepalive');
JHtml::_('formbehavior.chosen', 'select');
//Frontend Changes
$tUri = '';
if (!$app->isAdmin()) {
$tUri = JURI::base();
}
$document = JFactory::getDocument();
$uri = JFactory::getURI();
JHTML::stylesheet( 'media/com_phocadownload/css/administrator/phocadownload.css' );
$eName = JRequest::getVar('e_name');
$this->t['ename'] = preg_replace( '#[^A-Z0-9\-\_\[\]]#i', '', $eName );
$this->t['backlink'] = $tUri.'index.php?option=com_phocadownload&view=phocadownloadlinks&tmpl=component&e_name='.$this->t['ename'];
// Category Tree
$db = JFactory::getDBO();
$query = 'SELECT a.title AS text, a.id AS value, a.parent_id as parentid'
. ' FROM #__phocadownload_categories AS a'
// . ' WHERE a.published = 1' You can hide not published and not authorized categories too
// . ' AND a.approved = 1'
. ' ORDER BY a.ordering';
$db->setQuery( $query );
$categories = $db->loadObjectList();
$tree = array();
$text = '';
$tree = PhocaDownloadCategory::CategoryTreeOption($categories, $tree, 0, $text, -1);
//-----------------------------------------------------------------------
// Multiple
$ctrl = 'hidecategories';
$attribs = ' ';
$attribs .= ' size="5"';
//$attribs .= 'class="'.$v.'"';
$attribs .= ' class="inputbox"';
$attribs .= ' multiple="multiple"';
$ctrl .= '';
//$value = implode( '|', )
$categoriesOutput = JHTML::_('select.genericlist', $tree, $ctrl, $attribs, 'value', 'text', 0, 'hidecategories' );
$this->assignRef('categoriesoutput', $categoriesOutput);
parent::display($tpl);
}
function display($tpl = null) {
$app = JFactory::getApplication();
$db = JFactory::getDBO();
JHtml::_('behavior.tooltip');
JHtml::_('behavior.formvalidation');
JHtml::_('behavior.keepalive');
JHtml::_('formbehavior.chosen', 'select');
//Frontend Changes
$tUri = '';
if (!$app->isAdmin()) {
$tUri = JURI::base();
}
$document = JFactory::getDocument();
$uri = JFactory::getURI();
JHTML::stylesheet( 'media/com_phocadownload/css/administrator/phocadownload.css' );
$eName = JRequest::getVar('e_name');
$this->t['ename'] = preg_replace( '#[^A-Z0-9\-\_\[\]]#i', '', $eName );
$this->t['backlink'] = $tUri.'index.php?option=com_phocadownload&view=phocadownloadlinks&tmpl=component&e_name='.$this->t['ename'];
$model = $this->getModel();
// build list of categories
//$javascript = 'class="inputbox" size="1" onchange="submitform( );"';
$javascript = 'class="inputbox" size="1"';
$filter_catid = '';
$query = 'SELECT a.title AS text, a.id AS value, a.parent_id as parentid'
. ' FROM #__phocadownload_categories AS a'
. ' WHERE a.published = 1'
//. ' AND a.approved = 1'
. ' ORDER BY a.ordering';
$db->setQuery( $query );
$phocadownloads = $db->loadObjectList();
$tree = array();
$text = '';
$tree = PhocaDownloadCategory::CategoryTreeOption($phocadownloads, $tree, 0, $text, -1);
array_unshift($tree, JHTML::_('select.option', '0', '- '.JText::_('COM_PHOCADOWNLOAD_SELECT_CATEGORY').' -', 'value', 'text'));
$lists['catid'] = JHTML::_( 'select.genericlist', $tree, 'catid', $javascript , 'value', 'text', $filter_catid );
//-----------------------------------------------------------------------
$this->assignRef('lists', $lists);
parent::display($tpl);
}
public static function item($published, $category = 0)
{
// Create the copy/move options.
$options = array(JHtml::_('select.option', 'c', JText::_('JLIB_HTML_BATCH_COPY')), JHtml::_('select.option', 'm', JText::_('JLIB_HTML_BATCH_MOVE')));
$db = JFactory::getDBO();
//build the list of categories
$query = 'SELECT a.title AS text, a.id AS value, a.parent_id as parentid' . ' FROM #__phocadownload_categories AS a' . ' ORDER BY a.ordering';
$db->setQuery($query);
$data = $db->loadObjectList();
$tree = array();
$text = '';
$catId = -1;
$tree = PhocaDownloadCategory::CategoryTreeOption($data, $tree, 0, $text, $catId);
if ($category == 1) {
array_unshift($tree, JHTML::_('select.option', 0, JText::_('JLIB_HTML_ADD_TO_ROOT'), 'value', 'text'));
}
// Create the batch selector to change select the category by which to move or copy.
$lines = array('<label id="batch-choose-action-lbl" for="batch-choose-action">', JText::_('JLIB_HTML_BATCH_MENU_LABEL'), '</label>', '<fieldset id="batch-choose-action" class="combo">', '<select name="batch[category_id]" class="inputbox" id="batch-category-id">', '<option value="">' . JText::_('JSELECT') . '</option>', JHTML::_('select.options', $tree), '</select>', JHTML::_('select.radiolist', $options, 'batch[move_copy]', '', 'value', 'text', 'm'), '</fieldset>');
return implode("\n", $lines);
}
function display($tpl = null)
{
$app = JFactory::getApplication();
$uri = JFactory::getURI();
$document = JFactory::getDocument();
$db = JFactory::getDBO();
JHtml::_('behavior.tooltip');
JHtml::_('behavior.formvalidation');
JHtml::_('behavior.keepalive');
JHtml::_('formbehavior.chosen', 'select');
//Frontend Changes
$tUri = '';
if (!$app->isAdmin()) {
$tUri = JURI::base();
}
JHTML::stylesheet('media/com_phocadownload/css/administrator/phocadownload.css');
$eName = $app->input->get('e_name');
$this->t['ename'] = preg_replace('#[^A-Z0-9\\-\\_\\[\\]]#i', '', $eName);
$this->t['type'] = $app->input->get('type', 1, '', 'int');
$this->t['backlink'] = $tUri . 'index.php?option=com_phocadownload&view=phocadownloadlinks&tmpl=component&e_name=' . $this->t['ename'];
$params = JComponentHelper::getParams('com_phocadownload');
//Filter
$context = 'com_phocadownload.phocadownload.list.';
//$sectionid = $app->input->get( 'sectionid', -1, '', 'int' );
//$redirect = $sectionid;
$option = JRequest::getCmd('option');
$filter_state = $app->getUserStateFromRequest($this->_context . '.filter_state', 'filter_state', '', 'word');
$filter_catid = $app->getUserStateFromRequest($this->_context . '.filter_catid', 'filter_catid', 0, 'int');
$catid = $app->getUserStateFromRequest($this->_context . '.catid', 'catid', 0, 'int');
// $filter_sectionid = $app->getUserStateFromRequest( $this->_context.'.filter_sectionid','filter_sectionid', -1, 'int');
$filter_order = $app->getUserStateFromRequest($this->_context . '.filter_order', 'filter_order', 'a.ordering', 'cmd');
$filter_order_Dir = $app->getUserStateFromRequest($this->_context . '.filter_order_Dir', 'filter_order_Dir', '', 'word');
$search = $app->getUserStateFromRequest($this->_context . '.search', 'search', '', 'string');
$search = JString::strtolower($search);
// Get data from the model
$items = $this->get('Data');
$total = $this->get('Total');
$pagination = $this->get('Pagination');
// build list of categories
if ($this->t['type'] != 4) {
$javascript = 'class="inputbox" size="1" onchange="submitform( );"';
} else {
$javascript = '';
}
// get list of categories for dropdown filter
$filter = '';
//if ($filter_sectionid > 0) {
// $filter = ' WHERE cc.section = '.$db->Quote($filter_sectionid);
//}
// get list of categories for dropdown filter
$query = 'SELECT cc.id AS value, cc.title AS text' . ' FROM #__phocadownload_categories AS cc' . $filter . ' ORDER BY cc.ordering';
if ($this->t['type'] != 4) {
$lists['catid'] = PhocaDownloadCategory::filterCategory($query, $catid, null, true, true);
} else {
$lists['catid'] = PhocaDownloadCategory::filterCategory($query, $catid, null, false, true);
}
/*
if ($this->t['type'] != 4) {
$lists['catid'] = PhocaDownloadCategory::filterCategory($query, $catid, null, true);
} else {
$lists['catid'] = PhocaDownloadCategory::filterCategory($query, $catid, null, false);
}*/
// sectionid
/*$query = 'SELECT s.title AS text, s.id AS value'
. ' FROM #__phocadownload_sections AS s'
. ' WHERE s.published = 1'
. ' ORDER BY s.ordering';
$lists['sectionid'] = PhocaDownloadCategory::filterSection($query, $filter_sectionid);*/
// state filter
$lists['state'] = JHTML::_('grid.state', $filter_state);
// table ordering
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
// search filter
$lists['search'] = $search;
$this->assignRef('user', JFactory::getUser());
$this->assignRef('lists', $lists);
$this->assignRef('tmpl', $this->t);
$this->assignRef('items', $items);
$this->assignRef('pagination', $pagination);
$this->assignRef('request_url', $uri->toString());
parent::display($tpl);
}
function display($tpl = null)
{
$app = JFactory::getApplication();
$document = JFactory::getDocument();
$uri = JFactory::getURI();
$menus = $app->getMenu();
$menu = $menus->getActive();
$this->t['p'] = $app->getParams();
$user = JFactory::getUser();
$db = JFactory::getDBO();
$user = JFactory::getUser();
$userLevels = implode(',', $user->getAuthorisedViewLevels());
$this->t['pi'] = 'media/com_phocadownload/images/';
$this->t['pp'] = 'index.php?option=com_phocadownload&view=user&controller=user';
$this->t['pl'] = 'index.php?option=com_users&view=login&return=' . base64_encode($this->t['pp'] . '&Itemid=' . $app->input->get('Itemid', 0, 'int'));
$neededAccessLevels = PhocaDownloadAccess::getNeededAccessLevels();
$access = PhocaDownloadAccess::isAccess($user->getAuthorisedViewLevels(), $neededAccessLevels);
if (!$access) {
$app->redirect(JRoute::_($this->t['pl'], false), JText::_("COM_PHOCADOWNLOAD_NOT_AUTHORISED_ACTION"));
return;
}
PhocaDownloadRenderFront::renderAllCSS();
// = = = = = = = = = = =
// PANE
// = = = = = = = = = = =
// - - - - - - - - - -
// ALL TABS
// - - - - - - - - - -
// UCP is disabled (security reasons)
if ((int) $this->t['p']->get('enable_user_cp', 0) == 0) {
$app->redirect(JURI::base(false), JText::_("COM_PHOCADOWNLOAD_USER_UPLOAD_DISABLED"));
exit;
}
$this->t['tab'] = $app->input->get('tab', 0, 'string');
$this->t['maxuploadchar'] = $this->t['p']->get('max_upload_char', 1000);
$this->t['enableuseruploadapprove'] = $this->t['p']->get('enable_user_upload_approve', 0);
$this->t['showpageheading'] = $this->t['p']->get('show_page_heading', 1);
$this->t['uploadmaxsize'] = $this->t['p']->get('user_file_upload_size', 3145728);
$this->t['uploadmaxsizeread'] = PhocaDownloadFile::getFileSizeReadable($this->t['uploadmaxsize']);
$this->t['userfilesmaxcount'] = $this->t['p']->get('user_files_max_count', 5);
$this->t['userfilesmaxsize'] = $this->t['p']->get('user_files_max_size', 20971520);
$this->t['send_mail_upload'] = $this->t['p']->get('send_mail_upload', 0);
$this->t['pw'] = PhocaDownloadRenderFront::renderPhocaDownload();
//Subcateogry
//$this->t['parentid'] = $app->input->get('parentcategoryid', 0, 'int');
//$document->addScript(JURI::base(true).'/components/com_phocadownload/assets/js/comments.js');
$document->addCustomTag(PhocaDownloadRenderFront::renderOnUploadJS());
$document->addCustomTag(PhocaDownloadRenderFront::renderDescriptionUploadJS((int) $this->t['maxuploadchar']));
$document->addCustomTag(PhocaDownloadRenderFront::userTabOrdering());
$model = $this->getModel('user');
// Upload Form - - - - - - - - - - - - - - -
$ftp = !JClientHelper::hasCredentials('ftp');
// Set FTP form
$session = JFactory::getSession();
$this->assignRef('session', $session);
// END Upload Form - - - - - - - - - - - - -
$this->t['displayupload'] = 1;
// - - - - - - - - - -
// FORM
// - - - - - - - - - -
// No Controller because of returning back the values in case some form field is not OK
// Set default for returning back
$formData = new JObject();
$formData->set('title', '');
$formData->set('description', '');
$formData->set('author', '');
$formData->set('email', '');
$formData->set('license', '');
$formData->set('website', '');
$formData->set('version', '');
$this->t['errorcatid'] = '';
$this->t['erroremail'] = '';
$this->t['errorwebsite'] = '';
$this->t['errorfile'] = '';
$task = $app->input->get('task', '', 'string');
if ($task == 'upload') {
$post['title'] = $app->input->get('phocadownloaduploadtitle', '', 'string');
$post['description'] = $app->input->get('phocadownloaduploaddescription', '', 'string');
$post['catidfiles'] = $app->input->get('catidfiles', 0, 'int');
$post['description'] = substr($post['description'], 0, (int) $this->t['maxuploadchar']);
$post['approved'] = 0;
$post['published'] = 1;
$post['owner_id'] = $user->id;
if ($this->t['enableuseruploadapprove'] == 0) {
$post['approved'] = 1;
}
$post['author'] = $app->input->get('phocadownloaduploadauthor', '', 'string');
$post['email'] = $app->input->get('phocadownloaduploademail', '', 'string');
$post['website'] = $app->input->get('phocadownloaduploadwebsite', '', 'string');
$post['license'] = $app->input->get('phocadownloaduploadlicense', '', 'string');
$post['version'] = $app->input->get('phocadownloaduploadversion', '', 'string');
if ($post['title'] != '') {
$formData->set('title', $post['title']);
}
if ($post['description'] != '') {
$formData->set('description', $post['description']);
}
if ($post['author'] != '') {
$formData->set('author', $post['author']);
}
if ($post['email'] != '') {
$formData->set('email', $post['email']);
}
if ($post['website'] != '') {
$formData->set('website', $post['website']);
}
if ($post['license'] != '') {
$formData->set('license', $post['license']);
}
if ($post['version'] != '') {
$formData->set('version', $post['version']);
}
//catid
$returnForm = 0;
if ($post['catidfiles'] < 1) {
$this->t['errorcatid'] = JText::_('COM_PHOCADOWNLOAD_PLEASE_SELECT_CATEGORY');
$returnForm = 1;
}
jimport('joomla.mail.helper');
if ($post['email'] != '' && !JMailHelper::isEmailAddress($post['email'])) {
$this->t['erroremail'] = JText::_('COM_PHOCADOWNLOAD_PLEASE_ENTER_VALID_EMAIL_ADDRESS');
$returnForm = 1;
}
if ($post['website'] != '' && !PhocaDownloadUtils::isURLAddress($post['website'])) {
$this->t['errorwebsite'] = JText::_('COM_PHOCADOWNLOAD_PLEASE_ENTER_VALID_WEBSITE');
$returnForm = 1;
}
// Upload
$errUploadMsg = '';
$redirectUrl = '';
$fileArray = JRequest::getVar('Filedata', '', 'files', 'array');
if (empty($fileArray) || isset($fileArray['name']) && $fileArray['name'] == '') {
$this->t['errorfile'] = JText::_('COM_PHOCADOWNLOAD_PLEASE_ADD_FILE');
$returnForm = 1;
}
if ($post['title'] == '') {
$post['title'] = PhocaDownloadFile::removeExtension($fileArray['name']);
}
$post['alias'] = PhocaDownloadUtils::getAliasName($post['title']);
if ($returnForm == 0) {
$errorUploadMsg = '';
if ($model->singleFileUpload($errorUploadMsg, $fileArray, $post)) {
if ($this->t['send_mail_upload'] > 0) {
PhocaDownloadMail::sendMail((int) $this->t['send_mail_upload'], $post['title'], 2);
}
$Itemid = $app->input->get('Itemid', 0, 'int');
$limitStart = $app->input->get('limitstart', 0, 'int');
if ($limitStart > 0) {
$limitStartUrl = '&limitstart=' . $limitStart;
} else {
$limitStartUrl = '';
}
$link = 'index.php?option=com_phocadownload&view=user&Itemid=' . $Itemid . $limitStartUrl;
$app->redirect(JRoute::_($link, false), JText::_("COM_PHOCADOWNLOAD_SUCCESS_FILE_UPLOADED"));
exit;
} else {
$this->t['errorfile'] = JText::_('COM_PHOCADOWNLOAD_ERROR_FILE_UPLOADED');
if ($errorUploadMsg != '') {
$this->t['errorfile'] .= '<br />' . $errorUploadMsg;
}
}
}
}
// - - - - - - - - - - -
// FILES
// - - - - - - - - - - -
$this->t['filesitems'] = $model->getDataFiles($user->id);
$this->t['filestotal'] = $model->getTotalFiles($user->id);
$this->t['filespagination'] = $model->getPaginationFiles($user->id);
$filter_state_files = $app->getUserStateFromRequest($this->_context_files . '.filter_state', 'filter_state', '', 'word');
$filter_catid_files = $app->getUserStateFromRequest($this->_context_files . '.filter_catid', 'filter_catid', 0, 'int');
$catid_files = $app->getUserStateFromRequest($this->_context_files . '.catid', 'catid', 0, 'int');
//$filter_sectionid_files = $app->getUserStateFromRequest( $this->_context_files.'.filter_sectionid', 'filter_sectionid', 0, 'int' );
$filter_order_files = $app->getUserStateFromRequest($this->_context_files . '.filter_order', 'filter_order', 'a.ordering', 'cmd');
$filter_order_Dir_files = $app->getUserStateFromRequest($this->_context_files . '.filter_order_Dir', 'filter_order_Dir', '', 'word');
$search_files = $app->getUserStateFromRequest($this->_context_files . '.search', 'search', '', 'string');
$search_files = JString::strtolower($search_files);
// build list of categories
$javascript = 'class="inputbox" size="1" onchange="document.phocadownloadfilesform.submit();"';
// get list of categories for dropdown filter
$whereC = array();
//if ($filter_sectionid_files > 0) {
// $whereC[] = ' cc.section = '.$db->Quote($filter_sectionid_files);
//}
//$whereC[] = "(cc.uploaduserid LIKE '%-1%' OR cc.uploaduserid LIKE '%".(int)$user->id."%')";
//$whereC[] = "(cc.uploaduserid LIKE '%-1%' OR cc.uploaduserid LIKE '%,{".(int)$user->id."}' OR cc.uploaduserid LIKE '{".(int)$user->id."},%' OR cc.uploaduserid LIKE '%,{".(int)$user->id."},%' OR cc.uploaduserid ={".(int)$user->id."} )";
$whereC[] = "(cc.uploaduserid LIKE '%-1%' OR cc.uploaduserid LIKE '%," . (int) $user->id . "' OR cc.uploaduserid LIKE '" . (int) $user->id . ",%' OR cc.uploaduserid LIKE '%," . (int) $user->id . ",%' OR cc.uploaduserid =" . (int) $user->id . " )";
$whereC = count($whereC) ? ' WHERE ' . implode(' AND ', $whereC) : '';
// get list of categories for dropdown filter
$query = 'SELECT cc.id AS value, cc.title AS text, cc.parent_id as parentid' . ' FROM #__phocadownload_categories AS cc' . $whereC . ' ORDER BY cc.ordering';
$lists_files['catid'] = PhocaDownloadCategory::filterCategory($query, $catid_files, TRUE, TRUE, TRUE);
/*$whereS = array();
//$whereS[] = "(cc.uploaduserid LIKE '%-1%' OR cc.uploaduserid LIKE '%".(int)$user->id."%')";
$whereS[] = "(cc.uploaduserid LIKE '%-1%' OR cc.uploaduserid LIKE '%,".(int)$user->id."' OR cc.uploaduserid LIKE '".(int)$user->id.",%' OR cc.uploaduserid LIKE '%,".(int)$user->id.",%' OR cc.uploaduserid =".(int)$user->id." )";
$whereS[] = 's.published = 1';
$whereS = ( count( $whereS ) ? ' WHERE '. implode( ' AND ', $whereS ) : '' );
// sectionid
$query = 'SELECT s.title AS text, s.id AS value'
. ' FROM #__phocadownload_sections AS s'
. ' LEFT JOIN #__phocadownload_categories AS cc ON cc.section = s.id'
. $whereS
. ' GROUP BY s.id'
. ' ORDER BY s.ordering';
// state filter
/* $state_files[] = JHTML::_('select.option', '', '- '. JText::_( 'Select State' ) .' -' );
$state_files[] = JHTML::_('select.option', 'P', JText::_( 'Published' ) );
$state_files[] = JHTML::_('select.option', 'U', JText::_( 'Unpublished') );
$lists_image['state'] = JHTML::_('select.genericlist', $state_files, 'filter_state', 'class="inputbox" size="1" onchange="document.phocadownloadfilesform.submit();"', 'value', 'text', $filter_state );*/
//$lists_files['sectionid'] = PhocaDownloadCategory::filterSection($query, $filter_sectionid_files, TRUE);
// state filter
$lists_files['state'] = JHTML::_('grid.state', $filter_state_files);
// table ordering
$lists_files['order_Dir'] = $filter_order_Dir_files;
$lists_files['order'] = $filter_order_files;
// search filter
$lists_files['search'] = $search_files;
$this->t['catidfiles'] = $catid_files;
$this->t['filestab'] = 1;
// Tabs
$displayTabs = 0;
if ((int) $this->t['filestab'] == 0) {
$currentTab['files'] = -1;
} else {
$currentTab['files'] = $displayTabs;
$displayTabs++;
}
$this->t['displaytabs'] = $displayTabs;
$this->t['currenttab'] = $currentTab;
// ACTION
$this->t['action'] = $uri->toString();
// SEF problem
$isThereQM = false;
$isThereQM = preg_match("/\\?/i", $this->t['action']);
if ($isThereQM) {
$amp = '&';
} else {
$amp = '?';
}
$this->t['actionamp'] = htmlspecialchars($this->t['action']) . $amp;
$this->t['istheretab'] = false;
$this->t['istheretab'] = preg_match("/tab=/i", $this->t['action']);
$this->t['ps'] = '&tab=' . $this->t['currenttab']['files'] . '&limitstart=' . $this->t['filespagination']->limitstart;
// ASIGN
$this->assignRef('listsfiles', $lists_files);
$this->assignRef('formdata', $formData);
$this->assignRef('tmpl', $this->t);
$this->assignRef('params', $this->t['p']);
$session = JFactory::getSession();
$this->assignRef('session', $session);
parent::display($tpl);
}
echo $r->startFilter();
echo $r->endFilter();
echo $r->startMainContainer();
echo $r->startFilterBar();
echo $r->inputFilterSearch($this->t['l'].'_FILTER_SEARCH_LABEL', $this->t['l'].'_FILTER_SEARCH_DESC',
$this->escape($this->state->get('filter.search')));
echo $r->inputFilterSearchClear('JSEARCH_FILTER_SUBMIT', 'JSEARCH_FILTER_CLEAR');
echo $r->inputFilterSearchLimit('JFIELD_PLG_SEARCH_SEARCHLIMIT_DESC', $this->pagination->getLimitBox());
echo $r->selectFilterDirection('JFIELD_ORDERING_DESC', 'JGLOBAL_ORDER_ASCENDING', 'JGLOBAL_ORDER_DESCENDING', $listDirn);
echo $r->selectFilterSortBy('JGLOBAL_SORT_BY', $sortFields, $listOrder);
echo $r->startFilterBar(2);
echo $r->selectFilterPublished('JOPTION_SELECT_PUBLISHED', $this->state->get('filter.state'));
echo $r->selectFilterLanguage('JOPTION_SELECT_LANGUAGE', $this->state->get('filter.language'));
echo $r->selectFilterCategory(PhocaDownloadCategory::options(1), $this->t['l'].'_FILTER_SELECT_TYPE', $this->state->get('filter.category_id'));
echo $r->endFilterBar();
echo $r->endFilterBar();
echo $r->startTable('categoryList');
echo $r->startTblHeader();
echo $r->thOrdering('JGRID_HEADING_ORDERING', $listDirn, $listOrder);
echo $r->thCheck('JGLOBAL_CHECK_ALL');
echo '<th class="ph-title-short">'.JHTML::_('grid.sort', $this->t['l'].'_TITLE', 'a.title', $listDirn, $listOrder ).'</th>'."\n";
echo '<th class="ph-filename-long">'.JHTML::_('grid.sort', $this->t['l'].'_FILENAME', 'a.title', $listDirn, $listOrder ).'</th>'."\n";
echo '<th class="ph-published">'.JHTML::_('grid.sort', $this->t['l'].'_PUBLISHED', 'a.published', $listDirn, $listOrder ).'</th>'."\n";
echo '<th class="ph-parentcattitle">'.JHTML::_('grid.sort', $this->t['l'].'_TYPE', 'a.type', $listDirn, $listOrder ).'</th>'."\n";
echo '<div class="alert alert-error"><a class="close" data-dismiss="alert" href="#">×</a>'.JText::_($this->t['l'].'_NOT_APPROVED_FILES_COUNT').': '
.(int)$this->tmpl['notapproved']->count.'</div>';
}
echo $r->startFilterBar();
echo $r->inputFilterSearch($this->t['l'].'_FILTER_SEARCH_LABEL', $this->t['l'].'_FILTER_SEARCH_DESC',
$this->escape($this->state->get('filter.search')));
echo $r->inputFilterSearchClear('JSEARCH_FILTER_SUBMIT', 'JSEARCH_FILTER_CLEAR');
echo $r->inputFilterSearchLimit('JFIELD_PLG_SEARCH_SEARCHLIMIT_DESC', $this->pagination->getLimitBox());
echo $r->selectFilterDirection('JFIELD_ORDERING_DESC', 'JGLOBAL_ORDER_ASCENDING', 'JGLOBAL_ORDER_DESCENDING', $listDirn);
echo $r->selectFilterSortBy('JGLOBAL_SORT_BY', $sortFields, $listOrder);
echo $r->startFilterBar(2);
echo $r->selectFilterPublished('JOPTION_SELECT_PUBLISHED', $this->state->get('filter.state'));
echo $r->selectFilterLanguage('JOPTION_SELECT_LANGUAGE', $this->state->get('filter.language'));
echo $r->selectFilterCategory(PhocaDownloadCategory::options($this->t['o']), 'JOPTION_SELECT_CATEGORY', $this->state->get('filter.category_id'));
echo $r->endFilterBar();
echo $r->endFilterBar();
echo $r->startTable('categoryList');
echo $r->startTblHeader();
echo $r->thOrdering('JGRID_HEADING_ORDERING', $listDirn, $listOrder);
echo $r->thCheck('JGLOBAL_CHECK_ALL');
echo '<th class="ph-title">'.JHTML::_('grid.sort', $this->t['l'].'_TITLE', 'a.title', $listDirn, $listOrder ).'</th>'."\n";
echo '<th class="ph-filename-long">'.JHTML::_('grid.sort', $this->t['l'].'_FILENAME', 'a.filename', $listDirn, $listOrder ).'</th>'."\n";
echo '<th class="ph-published">'.JHTML::_('grid.sort', $this->t['l'].'_PUBLISHED', 'a.published', $listDirn, $listOrder ).'</th>'."\n";
echo '<th class="ph-approved">'.JHTML::_('grid.sort', $this->t['l'].'_APPROVED', 'a.approved', $listDirn, $listOrder ).'</th>'."\n";
echo '<th class="ph-parentcattitle">'.JHTML::_('grid.sort', $this->t['l'].'_CATEGORY', 'category_id', $listDirn, $listOrder ).'</th>'."\n";
if ($rightDisplay == 1) {
// Test if we have information about category - if we are displaying items by e.g. search outcomes - tags
// we don't have any ID of category so we need to load it for each file.
$this->catitem[$v->id] = new StdClass();
$this->catitem[$v->id]->id = 0;
$this->catitem[$v->id]->alias = '';
if (isset($this->category[0]->id) && isset($this->category[0]->alias)) {
$this->catitem[$v->id]->id = (int)$this->category[0]->id;
$this->catitem[$v->id]->alias = $this->category[0]->alias;
} else {
$catDb = PhocaDownloadCategory::getCategoryByFile($v->id);
if (isset($catDb->id) && isset($catDb->alias)) {
$this->catitem[$v->id]->id = (int)$catDb->id;
$this->catitem[$v->id]->alias = $catDb->alias;
}
$categorySetTemp = 1;
}
// General
$linkDownloadB = '';
$linkDownloadE = '';
if ((int)$v->confirm_license > 0 || $this->t['display_file_view'] == 1) {
$linkDownloadB = '<a class="" href="'. JRoute::_(PhocaDownloadRoute::getFileRoute($v->id, $v->catid,$v->alias, $v->categoryalias, $v->sectionid). $this->t['limitstarturl']).'" >'; // we need pagination to go back
$linkDownloadE ='</a>';
} else {
public static function options($type = 0)
{
if ($type == 1) {
$tree[0] = new JObject();
$tree[0]->text = JText::_('COM_PHOCADOWNLOAD_MAIN_CSS');
$tree[0]->value = 1;
$tree[1] = new JObject();
$tree[1]->text = JText::_('COM_PHOCADOWNLOAD_CUSTOM_CSS');
$tree[1]->value = 2;
return $tree;
}
$db = JFactory::getDBO();
//build the list of categories
$query = 'SELECT a.title AS text, a.id AS value, a.parent_id as parentid'
. ' FROM #__phocadownload_categories AS a'
. ' WHERE a.published = 1'
. ' ORDER BY a.ordering';
$db->setQuery( $query );
$items = $db->loadObjectList();
$catId = -1;
$javascript = 'class="inputbox" size="1" onchange="submitform( );"';
$tree = array();
$text = '';
$tree = PhocaDownloadCategory::CategoryTreeOption($items, $tree, 0, $text, $catId);
return $tree;
}
