sdr/update/SDRServiceStats.php5

<?php

abstract class SDRServiceStats extends SObject {

    public static function countCatalogItems($type = null, $passedConstraints = array()) {
        $constraints = array();
        $from = 'SDRResource';
        switch($type) {
            case 'live':
                $constraints = array('releaseFlag' => 1);
                break;
            case 'pending':
                $from = 'view_numpendingversions';
                break;
            case 'dev':
                $from = 'view_numdevversions';
                break;
            case 'approved':
                $from = 'view_numliveversions';
                break;
            case 'fields':
                $from = 'SDRField';
                break;
            case 'values':
                $from = 'SDRValue';
                break;
            case 'cachedValues':
                $from = 'SDRValueCache';
                break;
            case 'cachedResources':
                $from = 'SDRResourceCache';
                break;
            case 'cachedSearchTerms':
                $from = 'SDRSearchWord';
                break;
            default:
                if(count($passedConstraints))
                    $constraints = array_merge($constraints, $passedConstraints);
                break;
        }
        $DBI = SDRService::getDBI();
        $result = $DBI->select($from, DBI2::NUM_RESULTS, $constraints);
        return $result;
    }

    public static function projectsAndResourceCounts() {
        $from = 'view_sdrresourcesperproject';
        $constraints = array();
        $DBI = SDRService::getDBI();
        $result = $DBI->select($from, array('id', 'name', 'count'), $constraints);
        $output = array();
        foreach($result as $r) {
            $output[$r['id']] = array('name' => $r['name'], 'count' => $r['count']);
        }
        return $output;
    }
}
?>

---