$sql = 'SELECT * FROM `post` WHERE `date` LIKE '2017%''
$sql_count = 'SELECT COUNT(\*) FROM `post` WHERE `date` LIKE '2017%'';
$params=[':one' => 1];
$count = Yii::$app->db->createCommand($sql_count)
    ->bindValues($params)
    ->queryScalar();
$dataProvider = new SqlDataProvider([
    'sql' => $sql,
    'params' => $params,
    'totalCount' => $count,
    'pagination' => [
        'pageSize' =>25,
    ],
    'sort' => [
        'attributes' => [
            'title',
            'view_count',
            'created_at',
        ],
        'defaultOrder'=>[
            'title' => SORT_ASC,
        ],
    ],
]);