public function actionLog_db()
{
$query = Log::query()->orderBy(['log_time' => SORT_DESC]);
$category = self::getParam('category', '');
if ($category) {
$query->where(['like', 'category', $category . '%', false]);
}
$type = self::getParam('type', '');
if ($type) {
switch ($type) {
case 'INFO':
$type = \yii\log\Logger::LEVEL_INFO;
break;
case 'ERROR':
$type = \yii\log\Logger::LEVEL_ERROR;
break;
case 'WARNING':
$type = \yii\log\Logger::LEVEL_WARNING;
break;
case 'PROFILE':
$type = \yii\log\Logger::LEVEL_PROFILE;
break;
default:
$type = null;
break;
}
if ($type) {
$query->where(['type' => $type]);
}
}
return $this->render(['dataProvider' => new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 50]])]);
}
