[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * @package     Joomla.Administrator
   4   * @subpackage  com_finder
   5   *
   6   * @copyright   Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.
   7   * @license     GNU General Public License version 2 or later; see LICENSE
   8   */
   9  
  10  // no direct access
  11  defined('_JEXEC') or die;
  12  
  13  jimport('joomla.application.component.model');
  14  
  15  /**
  16   * Statistics model class for Finder.
  17   *
  18   * @package     Joomla.Administrator
  19   * @subpackage  com_finder
  20   * @since       2.5
  21   */
  22  class FinderModelStatistics extends JModel
  23  {
  24      /**
  25       * Method to get the component statistics
  26       *
  27       * @return  object  The component statistics
  28       *
  29       * @since   2.5
  30       */
  31  	public function getData()
  32      {
  33          // Initialise
  34          $db = $this->getDbo();
  35          $query = $db->getQuery(true);
  36          $data = new JObject;
  37  
  38          $query->select('COUNT(term_id)');
  39          $query->from($db->quoteName('#__finder_terms'));
  40          $db->setQuery($query);
  41          $data->term_count = $db->loadResult();
  42  
  43          $query->clear();
  44          $query->select('COUNT(link_id)');
  45          $query->from($db->quoteName('#__finder_links'));
  46          $db->setQuery($query);
  47          $data->link_count = $db->loadResult();
  48  
  49          $query->clear();
  50          $query->select('COUNT(id)');
  51          $query->from($db->quoteName('#__finder_taxonomy'));
  52          $query->where($db->quoteName('parent_id') . ' = 1');
  53          $db->setQuery($query);
  54          $data->taxonomy_branch_count = $db->loadResult();
  55  
  56          $query->clear();
  57          $query->select('COUNT(id)');
  58          $query->from($db->quoteName('#__finder_taxonomy'));
  59          $query->where($db->quoteName('parent_id') . ' > 1');
  60          $db->setQuery($query);
  61          $data->taxonomy_node_count = $db->loadResult();
  62  
  63          $query->clear();
  64          $query->select('t.title AS type_title, COUNT(a.link_id) AS link_count');
  65          $query->from($db->quoteName('#__finder_links') . ' AS a');
  66          $query->join('INNER', $db->quoteName('#__finder_types') . ' AS t ON t.id = a.type_id');
  67          $query->group('a.type_id, t.title');
  68          $query->order($db->quoteName('type_title'), 'ASC');
  69          $db->setQuery($query);
  70          $data->type_list = $db->loadObjectList();
  71  
  72          return $data;
  73      }
  74  }