72 lines
1.8 KiB
PHP
72 lines
1.8 KiB
PHP
<?php
|
|
/**
|
|
* @package Joomla.Administrator
|
|
* @subpackage com_finder
|
|
*
|
|
* @copyright Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.
|
|
* @license GNU General Public License version 2 or later; see LICENSE
|
|
*/
|
|
|
|
defined('_JEXEC') or die;
|
|
|
|
/**
|
|
* Statistics model class for Finder.
|
|
*
|
|
* @package Joomla.Administrator
|
|
* @subpackage com_finder
|
|
* @since 2.5
|
|
*/
|
|
class FinderModelStatistics extends JModelLegacy
|
|
{
|
|
/**
|
|
* Method to get the component statistics
|
|
*
|
|
* @return object The component statistics
|
|
*
|
|
* @since 2.5
|
|
*/
|
|
public function getData()
|
|
{
|
|
// Initialise
|
|
$db = $this->getDbo();
|
|
$query = $db->getQuery(true);
|
|
$data = new JObject;
|
|
|
|
$query->select('COUNT(term_id)')
|
|
->from($db->quoteName('#__finder_terms'));
|
|
$db->setQuery($query);
|
|
$data->term_count = $db->loadResult();
|
|
|
|
$query->clear()
|
|
->select('COUNT(link_id)')
|
|
->from($db->quoteName('#__finder_links'));
|
|
$db->setQuery($query);
|
|
$data->link_count = $db->loadResult();
|
|
|
|
$query->clear()
|
|
->select('COUNT(id)')
|
|
->from($db->quoteName('#__finder_taxonomy'))
|
|
->where($db->quoteName('parent_id') . ' = 1');
|
|
$db->setQuery($query);
|
|
$data->taxonomy_branch_count = $db->loadResult();
|
|
|
|
$query->clear()
|
|
->select('COUNT(id)')
|
|
->from($db->quoteName('#__finder_taxonomy'))
|
|
->where($db->quoteName('parent_id') . ' > 1');
|
|
$db->setQuery($query);
|
|
$data->taxonomy_node_count = $db->loadResult();
|
|
|
|
$query->clear()
|
|
->select('t.title AS type_title, COUNT(a.link_id) AS link_count')
|
|
->from($db->quoteName('#__finder_links') . ' AS a')
|
|
->join('INNER', $db->quoteName('#__finder_types') . ' AS t ON t.id = a.type_id')
|
|
->group('a.type_id, t.title')
|
|
->order($db->quoteName('type_title'), 'ASC');
|
|
$db->setQuery($query);
|
|
$data->type_list = $db->loadObjectList();
|
|
|
|
return $data;
|
|
}
|
|
}
|