public static function countPublicUserReports($userId)
{
$c = new Criteria();
$c->add(ReportPeer::USER_ID, $userId);
$c->add(ReportPeer::PUBLIC_RECORD, true);
return ReportPeer::doCount($c);
}
/**
* @action list
* @param KalturaReportFilter $filter
* @param KalturaReport $report
* @return KalturaReportListResponse
*/
function listAction(KalturaReportFilter $filter = null, KalturaFilterPager $pager = null)
{
if (!$filter) {
$filter = new KalturaReportFilter();
}
if (!$pager) {
$pager = new KalturaFilterPager();
}
$reportFilter = new ReportFilter();
$filter->toObject($reportFilter);
$c = new Criteria();
$reportFilter->attachToCriteria($c);
$pager->attachToCriteria($c);
$dbList = ReportPeer::doSelect($c);
$c->setLimit(null);
$totalCount = ReportPeer::doCount($c);
$list = KalturaReportArray::fromDbArray($dbList, $this->getResponseProfile());
$response = new KalturaReportListResponse();
$response->objects = $list;
$response->totalCount = $totalCount;
return $response;
}
<?php $c = new Criteria(); $c->add(ReportQueryPeer::QUERY_ID, $query->getId()); $c->addJoin(ReportPeer::ID, ReportQueryPeer::REPORT_ID); echo ReportPeer::doCount($c);
public function executeStatistics($request)
{
$this->statistics = array('reports' => ReportPeer::doCount(new Criteria()), 'queries' => QueryPeer::doCount(new Criteria()), 'query_results' => QueryResultBulkPeer::doCount(new Criteria()));
}
