public static function getChartData($query_id, $frequency, $start_date, $end_date) { if ($frequency == QueryResultPeer::FREQUENCY_MONTH) { return QueryResultPeer::monthly($query_id, $start_date, $end_date); } else { if ($frequency == QueryResultPeer::FREQUENCY_WEEK) { return QueryResultPeer::weekly($query_id, $start_date, $end_date); } else { return QueryResultPeer::daily($query_id, $start_date, $end_date); } } }
public function save($con = null) { parent::save($con); $c = new Criteria(); $c->add(QueryResultPeer::RESULT_DATE, $this->getCreatedAt('Y-m-d')); $c->add(QueryResultPeer::QUERY_ID, $this->getQueryId()); $daily = QueryResultPeer::doSelectOne($c); if ($daily) { $daily->setResultSize(($daily->getResultSize() * $daily->getResultCount() + $this->getResultSize()) / ($daily->getResultCount() + 1)); $daily->setResultCount($daily->getResultCount() + 1); } else { $daily = new QueryResult(); $daily->setQueryId($this->getQueryId()); $daily->setResultCount(1); $daily->setResultSize($this->getResultSize()); $daily->setResultDate($this->getCreatedAt('Y-m-d')); } $daily->save(); }
private static function getQueryResults($report_id, $start_date, $end_date, $frequency = QueryResultPeer::FREQUENCY_DAY) { $report = ReportPeer::retrieveByPK($report_id); $temp = array(); foreach ($report->getReportQuerys() as $report_query) { $arr = QueryResultPeer::getChartData($report_query->getQueryId(), $frequency, $start_date, $end_date); $temp[] = $arr; } return $temp; }
<?php $c = new Criteria(); $c->add(QueryResultPeer::QUERY_ID, $query->getId()); echo QueryResultPeer::doCount($c);
<?php include_once 'func.php'; $c = new Criteria(); $c->add(QueryResultPeer::QUERY_ID, $query->getId()); $c->addDescendingOrderByColumn(QueryResultPeer::CREATED_AT); $c->setLimit(1); $query_result = QueryResultPeer::doSelectOne($c); echo "<pre>" . addTrailingSpaces(number_format($query_result->getResultSize())) . "</pre>";