/PHP/Yii2 GridView Filtering on Relational Column

Yii2 GridView Filtering on Relational Column

class UserSearch extends User
{
    public $company_name;
    public function rules()
    {
        return [
            [['first_name', 'last_name', 'email', 'company_name'], 'safe']
        ];
    }

    public function search()
    {
        $query = User::find();
        $query->joinWith(['client c']); //set relation alias

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);

        if (!($this->load($params) && $this->validate())) {
            return $dataProvider;
        }

        $query
            ->andFilterWhere(['like', 'first_name', $this->first_name])
            ->andFilterWhere(['like', 'last_name', $this->last_name])
            ->andFilterWhere(['like', 'email', $this->email])
            ->andFilterWhere(['like', "c.company_name", $this->company_name]);

        return $dataProvider;
    }
}

Source: stackoverflow.com

Similar codes

1 vote306 views4 answers
Generate random color php
PHP
6 votes287 views1 answer
How to get input value in php variable
PHP
0 vote304 views1 answer
The plugin generated 14 characters of unexpected output during activation. if you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin
PHP
0 vote338 views1 answer
Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks.
PHP
100 votes364 views6 answers
Strpos php
PHP
0 vote308 views1 answer
Dorf SMS Plugin
PHP
0 vote346 views1 answer
Syntax error, unexpected variable "$result" in D:\wordpress\xampp\htdocs\templete\user_delete.php on line 13
PHP Wordpress
1 vote300 views1 answer
How to open php in browser
PHP
0 vote332 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
63 votes427 views6 answers
Laravel clear cache
PHP Laravel