при регистрации. В виде я вывожу этот код, но как по нему сделать сортировку и поиск?
Код: Выделить всё
<?= GridView::widget([
'dataProvider' => $dataProvider,
'filterModel' => $searchModel,
'columns' => [
['class' => 'yii\grid\SerialColumn'],
'id',
[
'attribute' => 'codeName',
'value' => function($dataProvider){
return User::getPassword2($dataProvider->password, $dataProvider->password_hash);
},
],
'surname:ntext',
'name:ntext',
'thirdname:ntext',
[
'attribute' => 'companiesName',
'value' => function($data_c){
return $data_c->companies->shortname;
},
],
['class' => 'yii\grid\ActionColumn'],
],
]); ?>
Код: Выделить всё
<?php
namespace app\models;
use yii\base\Model;
use yii\data\ActiveDataProvider;
use app\models\User;
use common\models\User as UserAlias;
/**
* UserSearch represents the model behind the search form of `app\models\User`.
*/
class UserSearch extends User
{
public $companiesName;
public $codeName;
public $poisk;
/**
* {@inheritdoc}
*/
public function rules()
{
return [
[['id', 'status', 'created_at', 'updated_at', 'time_create', 'id_companies', 'basket'], 'integer'],
[['password', 'auth_key', 'password_hash', 'password_reset_token', 'verification_token', 'surname', 'name', 'thirdname', 'job'], 'safe'],
[['companiesName'], 'safe'],
[['codeName'], 'safe'],
];
}
/**
* {@inheritdoc}
*/
public function scenarios()
{
// bypass scenarios() implementation in the parent class
return Model::scenarios();
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = User::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider([
'query' => $query,
'key' => function ($query) {
return UserAlias::getPassword2('$query->password','$query->password_hash');
}
]);
$poisk = UserAlias::getPassword2('$query->password','$query->password_hash');
$dataProvider->setSort([
'attributes' => [
'id',
'surname',
'name',
'thirdname',
'companiesName' => [
'asc' => ['companies.shortname' => SORT_ASC],
'desc' => ['companies.shortname' => SORT_DESC],
'label' => 'Компания'
],
'codeName' => [
'asc' => [ 'query.key' => SORT_ASC],
'desc' => [ 'query.key' => SORT_DESC],
'label' => 'Код пользователя'
],
// 'password',
// 'password_hash',
// 'time_create',
]
]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
$query->joinWith(['companies']);
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere([
'id' => $this->id,
'id_companies' => $this->id_companies,
]);
$poisk = UserAlias::getPassword2('password','password_hash');
$query->andFilterWhere(['like', 'surname', $this->surname])
->andFilterWhere(['like', 'name', $this->name])
->andFilterWhere(['like', 'thirdname', $this->thirdname]);
// ->andFilterWhere(['like', UserAlias::getPassword2('password','password_hash'), $this->codeName]);
$query->joinWith(['companies' => function ($q) {
$q->where('companies.shortname LIKE "%' . $this->companiesName . '%"');
}]);
return $dataProvider;
}
}