rageframe2 数据库配置_rageframe YII2框架后台

1.时间搜索

页面:

[

'attribute' => 'start_time',

'filter' => \kartik\widgets\DatePicker::widget([

'name' => 'SearchModel[st_time]',

'value' => Yii::$app->request->get('SearchModel')['st_time'] ? Yii::$app->request->get('SearchModel')['st_time'] : '',

'language' => 'zh-CN',

'layout' => '{picker}{input}',

'pluginOptions' => [

'format' => 'yyyy-mm-dd',

'todayHighlight' => true,// 今日高亮

'autoclose' => true,// 选择后自动关闭

'todayBtn' => true,// 今日按钮显示

],

'options' => [

'class' => 'form-control no_bor',

]

]),

'value'=>function($model){

return date('Y-m-d H:i:s',$model->start_time);

},

'format' => 'raw',

],

控制器：

public function actionIndex()

{

$searchModel = new SearchModel([

'model' => $this->modelClass,

'scenario' => 'default',

'partialMatchAttributes' => ['promotion_name'], // 模糊查询

'defaultOrder' => [

'updated_at' => SORT_DESC

],

'pageSize' => $this->pageSize

]);

$dataProvider = $searchModel

->search(Yii::$app->request->queryParams);

$dataProvider->query

->andWhere(['>=', 'status', StatusEnum::DISABLED]);

$st_time = Yii::$app->request->get('SearchModel')['st_time'];

$st_time && $dataProvider->query->andFilterWhere(['between','start_time',strtotime($st_time),strtotime($st_time)+86399]);

$et_time = Yii::$app->request->get('SearchModel')['et_time'];

$et_time && $dataProvider->query->andFilterWhere(['between','end_time',strtotime($et_time),strtotime($et_time)+86399]);

return $this->render($this->action->id, [

'dataProvider' => $dataProvider,

'searchModel' => $searchModel,

]);

}