public function actionClear()
 {
     $table = StatTime::model()->tableName();
     StatTime::model()->getDbConnection()->createCommand("truncate table {$table}")->execute();
     $this->renderJson();
 }
예제 #2
0
 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']);
 }