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); }