public function actionClear() { $table = StatTime::model()->tableName(); StatTime::model()->getDbConnection()->createCommand("truncate table {$table}")->execute(); $this->renderJson(); }
public static function statDayList() { return StatTime::model()->findAll(['select' => ['date(datetime) as datetime', 'action', 'sum(count) as count', 'min(time_min) as time_min', 'max(time_max) as time_max', 'sum(time_total) as time_total', 'time_last as time_last'], 'condition' => implode(' and ', ['datetime > date_sub(utc_timestamp(), interval 1 day)']), 'group' => 'action']); }