Example #1
0
 /**
  * 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);
 }