yii2-girdView的使用(4)——单时间选择器的使用

使用场景：按日期来筛选数据
以下为个人常用代码块：

<?php
use yii\helpers\Html;
use kartik\grid\GridView;
$visible ? $url = 'awards' : $url = 'index';
?>
<div class="awards-record-index">
<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        'id',
        [
            'label'=>'手机号',
            'value'=>function($model) {
                return $model->user->mobile;
            },
            'visible'=> $visible,
        ],
        //----------------------------------------------单时间选择器的使用---------------------------------------------------------
        [
            'attribute' => 'created_at',
            'value'=>function($model) {
                return date('Y-m-d H:i:s',$model->created_at);//时间戳转格式化日期 注意：$searchModel获取到时做时间戳话处理后再做区间查询
            },
            'filterType' => GridView::FILTER_DATE,
            'filterWidgetOptions' => [
                'pluginOptions' => [
                    'format' => 'yyyy-mm-dd',//日期格式
                    'autoclose' => true,
                    'todayHighlight' => true,//当天高亮
                ]
            ],
        ],
        //----------------------------------------------单时间选择器的使用---------------------------------------------------------
        [
            'attribute'=>'is_send',
            'value' => function($model) {
                return $model->is_send ==1 ? '是' : '否';
            },
        ],
        [
            'class' => 'yii\grid\ActionColumn',
            'visible' => function($model) use($visible) {
              if ($visible && $model->is_send !=0) {
                  return true;
              }
                return false;
            },
            'template' => '{send}',
            'buttons' =>[
                'send'=> function($url, $model, $key) {
                    $options = [
                       'title'=> Yii::t('yii','发奖'),
                        'aria-label' => Yii::t('yii', '查看'),
                        'data-method' => 'post',
                        'data-pjax' => 0,
                        'class' => 'btn btn-primary ',
                    ];
                    if ($model->status==1 && $model->is_send == 0) {
                        return Html::a('发奖', $url, $options);
                    }
                }
            ]
        ],
    ],
    'toolbar' => [
        ['content' =>
            Html::a('<i class="glyphicon glyphicon-repeat"></i>', [$url], ['data-pjax' => 0, 'class' => 'btn btn-default', 'title' => '刷新']),
        ],
        '{export}',
        '{toggleData}'
    ],
    'exportConfig'=> [
        GridView::EXCEL => ['filename' =>'抽奖记录'],
    ],
    'bordered' => true,
    'striped' => false,
    'condensed' => false,
    'hover' => true,
    'panel' => [
        'type' => GridView::TYPE_DEFAULT
    ]
]); ?>

$searchModel修改如下
public function rules()
{
    return [
        [['created_at'],'save']//修改created_at为该规则，其他不变不然规则不合法则无法执行搜索
    ];
}
在search() 方法中加一下代码可以实现查询某一天时间区间内的所有数据：
if ($this->created_at) {
        $ctime = strtotime($this->created_at);
        $etime = $ctime + 24*60*60;
        $query->andWhere(['between','created_at',$ctime,$etime]);
    }