How to filter null values with Kartik grid and select2 filter?

user_1675094 0
Viewed 298

I'm trying to add a custom option to my select2 filter (kartik grid). This option is meant to select all rows where something_id=null. It's a simple crud generated grid, modified to use kartik grid and select2 filter instead of yii2 default grid/filter.

I tried doing this in my table2_id column:

'filter' => [null => 'Nothing'] + Arrayhelper::map(Something::find()->orderBy('id)->asArray()->all(), 'id', 'thing')

But this new "null" option is not showing in the menu. I assume for select2 null just mean no filter and select2 just shows the placeholder for that. I can't find any option in select2 documentation to modify this behavior. The generated html for this option is:

<option value="" selected="" data-select2-id="5">Nothing</option>

But the css has the property visibility:hidden;. So I tried using:

'filter' => [0 => 'Nothing'] + Arrayhelper::map(Something::find()->orderBy('id)->asArray()->all(), 'id', 'thing')

But I can't manage to properly translate 'something_id'=>0 into a 'something_id'=>null condition neither in the controller or search model. Tried many things but everything failed at some point and I don't think my code deserves to be posted here, also I don't keep a copy of every failed piece of code so I'd like to ask what is the correct way of doing this from scratch. Thank you.

kartik-v yii2 jquery-select2 grid
1 Answers

Well, my answer got deleted because I made a joke. Here is the very very serious version of my answer.

// WatheverSearch.php
    if ( $this->something_id === '0' ) {
        $query->andWhere(['something_id' => null]);
    }else{
        $query->andFilterWhere(['something' => $this->something]);
    }
user_16750940
Related