在kartikv的gridview中使用时间区间filter [ 2.0 版本 ]

废话少说，放代码

view:

[
    'attribute'=>'join_at',
    'format' => ['date', 'php:Y-m-d H:i:s'],
    'filterType' => \kartik\grid\GridView::FILTER_DATE_RANGE,
    'filterWidgetOptions' =>([
        'model'=>$searchModel,
        'attribute'=>'join_at',
        'presetDropdown'=>TRUE,
        'convertFormat'=>true,
        'pluginOptions'=>[
            'format'=>'Y-m-d',
            'locale' => [
                'cancelLabel' => 'Clear',
                'format' => 'Y-m-d',
            ]
        ],
    ]),
],

SearchModal:

if ( ! is_null($this->join_at) && strpos($this->join_at, ' - ') !== false ) {
    list($start_date, $end_date) = explode(' - ', $this->join_at);
    $query->andFilterWhere(['between', 'join_at', strtotime($start_date), strtotime($end_date.' 23:59:59')]);
}