Пример #1
0
 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);
         }
     }
 }
Пример #2
0
 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();
 }
Пример #3
0
 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;
 }
Пример #4
0
<?php

$c = new Criteria();
$c->add(QueryResultPeer::QUERY_ID, $query->getId());
echo QueryResultPeer::doCount($c);
Пример #5
0
<?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>";