admin/functions.php ➔ lx_GetStatistics()

Complexity

Conditions	9
Paths	256

Size

Total Lines	88
Code Lines	62

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
function lx_GetStatistics($limit){
    $ret=array();
    $db =& XoopsDatabaseFactory::getDatabaseConnection();
    $tbls=$db->prefix('lxentries');
    $tblt=$db->prefix('lxcategories');

    $db =& XoopsDatabaseFactory::getDatabaseConnection();
    // Number of Definitions per Category, including offline and submitted terms
    $ret2=array();
    $sql="SELECT count(s.entryID) as cpt, s.categoryID, t.name FROM $tbls s, $tblt t WHERE s.categoryID=t.categoryID GROUP BY s.categoryID ORDER BY t.name";
    $result = $db->query($sql);
    while ($myrow = $db->fetchArray($result) ) {
        $ret2[$myrow['categoryID']]=$myrow;
    }
    $ret['termspercategory']=$ret2;
    unset($ret2);

    // Total reads per category
    $ret2=array();
    $sql="SELECT Sum(counter) as cpt, categoryID FROM $tbls GROUP BY categoryID ORDER BY categoryID";
    $result = $db->query($sql);
    while ($myrow = $db->fetchArray($result) ) {
        $ret2[$myrow['categoryID']]=$myrow['cpt'];
    }
    $ret['readspercategory']=$ret2;

    // unused terms per category i.e. offline or submitted
    $ret2=array();
    $sql="SELECT Count(entryID) as cpt, categoryID FROM $tbls WHERE offline > 0 OR submit > 0 GROUP BY categoryID ORDER BY categoryID";
    $result = $db->query($sql);
    while ($myrow = $db->fetchArray($result) ) {
        $ret2[$myrow['categoryID']]=$myrow['cpt'];
    }
    $ret['offlinepercategory']=$ret2;
    unset($ret2);

    // Number of unique authors per category
    $ret2=array();
    $sql="SELECT Count(Distinct(uid)) as cpt, categoryID FROM $tbls GROUP BY categoryID ORDER BY categoryID";
    $result = $db->query($sql);
    while ($myrow = $db->fetchArray($result) ) {
        $ret2[$myrow['categoryID']]=$myrow['cpt'];
    }
    $ret['authorspercategory']=$ret2;
    unset($ret2);

    // Most read terms
    $ret2=array();
    $sql="SELECT s.entryID, s.uid, s.term, s.counter, s.categoryID, t.name  FROM $tbls s, $tblt t WHERE s.categoryID=t.categoryID ORDER BY s.counter DESC";
    $result = $db->query($sql,intval($limit));
    while ($myrow = $db->fetchArray($result) ) {
        $ret2[$myrow['entryID']]=$myrow;
    }
    $ret['mostreadterms']=$ret2;
    unset($ret2);

    // Less read terms
    $ret2=array();
    $sql="SELECT s.entryID, s.uid, s.term, s.counter, s.categoryID, t.name  FROM $tbls s, $tblt t WHERE s.categoryID=t.categoryID ORDER BY s.counter";
    $result = $db->query($sql,intval($limit));
    while ($myrow = $db->fetchArray($result) ) {
        $ret2[$myrow['entryID']]=$myrow;
    }
    $ret['lessreadterms']=$ret2;
    unset($ret2);

    // Most read authors
    $ret2=array();
    $sql="SELECT Sum(counter) as cpt, uid FROM $tbls GROUP BY uid ORDER BY cpt DESC";
    $result = $db->query($sql,intval($limit));
    while ($myrow = $db->fetchArray($result) ) {
        $ret2[$myrow['uid']]=$myrow['cpt'];
    }
    $ret['mostreadauthors']=$ret2;
    unset($ret2);

    // Biggest contributors
    $ret2=array();
    $sql="SELECT Count(*) as cpt, uid FROM $tbls GROUP BY uid ORDER BY cpt DESC";
    $result = $db->query($sql,intval($limit));
    while ($myrow = $db->fetchArray($result) ) {
        $ret2[$myrow['uid']]=$myrow['cpt'];
    }
    $ret['biggestcontributors']=$ret2;
    unset($ret2);

    return $ret;
}