AAAAhome/academiac/www/administrator/components/com_finder/models/statistics.php000064400000003620151453264300023553 0ustar00getDbo(); $query = $db->getQuery(true); $data = new JObject; $query->select('COUNT(term_id)'); $query->from($db->quoteName('#__finder_terms')); $db->setQuery($query); $data->term_count = $db->loadResult(); $query->clear(); $query->select('COUNT(link_id)'); $query->from($db->quoteName('#__finder_links')); $db->setQuery($query); $data->link_count = $db->loadResult(); $query->clear(); $query->select('COUNT(id)'); $query->from($db->quoteName('#__finder_taxonomy')); $query->where($db->quoteName('parent_id') . ' = 1'); $db->setQuery($query); $data->taxonomy_branch_count = $db->loadResult(); $query->clear(); $query->select('COUNT(id)'); $query->from($db->quoteName('#__finder_taxonomy')); $query->where($db->quoteName('parent_id') . ' > 1'); $db->setQuery($query); $data->taxonomy_node_count = $db->loadResult(); $query->clear(); $query->select('t.title AS type_title, COUNT(a.link_id) AS link_count'); $query->from($db->quoteName('#__finder_links') . ' AS a'); $query->join('INNER', $db->quoteName('#__finder_types') . ' AS t ON t.id = a.type_id'); $query->group('a.type_id, t.title'); $query->order($db->quoteName('type_title'), 'ASC'); $db->setQuery($query); $data->type_list = $db->loadObjectList(); return $data; } }