http://joxi.ru/nAykJRwiXQ7WQm
Код: Выделить всё
public function actionIndex()
{
$searchModel = new UserSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', [
'searchModel' => $searchModel,
'dataProvider' => $dataProvider,
]);
}
Код: Выделить всё
public function search($params)
{
$query = self::find()
->leftJoin('consultant', 'consultant.user_id=user.id')
->select(['user.*', 'consultant.create_time as new_consultant']);
$dataProvider = new ActiveDataProvider([
'query' => $query,
]);
$dataProvider->getSort()->attributes['new_consultant'] = [
'asc' => [
'new_consultant' => SORT_ASC
],
'desc' => [
'new_consultant' => SORT_DESC
],
'default' => SORT_DESC
];
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere([
self::FIELD_USERNAME => $this->username,
self::FIELD_ID => $this->id,
]);
return $dataProvider;
}