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(); }
<?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>";