/** * Display the list of Visualizations */ function display() { $app =& JFactory::getApplication(); $db =& JFactory::getDBO(); $context = 'com_fabrik.vizualization.list.'; $filter_plugin = $app->getUserStateFromRequest($context . "filter_plugin", 'filter_plugin', ''); //get active vizulalization plugins $pluginManager =& JModel::getInstance('Pluginmanager', 'FabrikModel'); $pluginManager->_group = 'visualization'; $pluginManager->loadPlugInGroup('visualization'); $lists['vizualizations'] = $pluginManager->getElementTypeDd($filter_plugin, 'filter_plugin', 'class="inputbox" onchange="document.adminForm.submit();"', '- ' . JText::_('SELECT PLUGIN TYPE') . ' -'); $where = $filter_plugin == '' ? '' : ' WHERE plugin = "' . $filter_plugin . '"'; // get the total number of records $db->setQuery("SELECT count(*) FROM #__fabrik_visualizations {$where}"); $total = $db->loadResult(); echo $db->getErrorMsg(); $limit = $app->getUserStateFromRequest($context . 'limit', 'limit', $app->getCfg('list_limit'), 'int'); $limitstart = $app->getUserStateFromRequest($context . 'limitstart', 'limitstart', 0, 'int'); $sql = "SELECT * FROM #__fabrik_visualizations {$where}"; $db->setQuery($sql, $limitstart, $limit); jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); $rows = $db->loadObjectList(); require_once JPATH_COMPONENT . DS . 'views' . DS . 'visualization.php'; FabrikViewVisualization::show($rows, $pageNav, $lists); }