public function getStats()
{
$date = new Siberian_Date();
$date->addDay(1);
$endDate = $date->toString("yyyy-MM-dd HH:mm:ss");
$date->setDay(1);
$startDate = $date->toString("yyyy-MM-dd HH:mm:ss");
//select MONTH(`created_at`), count(*) as count from admin group by MONTH(`created_at`)
$select = $this->select()->from($this->_name, array("count" => new Zend_Db_Expr("COUNT(*)"), "day" => new Zend_Db_Expr("DATE(created_at)")))->where("created_at <= ?", $endDate)->where("created_at > ?", $startDate)->order("created_at")->group("created_at");
return $this->fetchAll($select);
}
public function getFromDateToDate()
{
$start = new Siberian_Date();
$end = new Siberian_Date();
switch ($this->getPeriodId()) {
case self::PERIOD_WEEKLY:
$start->setWeekday(1);
break;
case self::PERIOD_MONTHLY:
$start->setDay(1);
break;
}
$start->setBeginningOfTheDay();
$end->setEndOfTheDay();
return array($start, $end);
}
