public function getUserOptions() { return ArrayHelper::map(User::find()->where(['status' => '1'])->andWhere(['NOT', '_id', Yii::$app->user->id])->orderBy('email')->all(), '_id', 'email'); }
public function actionUserList($q = null) { Yii::$app->response->format = Response::FORMAT_JSON; $out = ['results' => ['id' => '', 'text' => '']]; if (!is_null($q)) { $q = filter_var($q, FILTER_SANITIZE_SPECIAL_CHARS); $query = User::find(); $query->where(['status' => '1']); $query->andWhere(['NOT', '_id', Yii::$app->user->id]); $query->andWhere(['LIKE', 'email', $q]); $query->orderBy('email'); $query->limit(100); $data = []; if (($models = $query->all()) != null) { foreach ($models as $model) { $data[] = ['id' => $model->primaryKey, 'text' => "{$model->display_name} ({$model->email})"]; } } $out['results'] = $data; } return $out; }