Maybe you are looking for something like this:
add in to your model
public static function getYearsList()
{
$years = (new Query())->select('DISTINCT YEAR(`birthday`) as years')->from('{{%yourTable}}')->column();
return array_combine($years, $years);
}
and then in gridview
[
'attribute' => 'birthday',
'filter' => YourModel::getYearsList(),
]
And then in your search model add andFilterWhere()
to compare birthday with year. It can look like this:
$query->andFilterWhere('YEAR(`birthday`)' => $year);
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…