Esempio n. 1
0
 public function getUserOptions()
 {
     return ArrayHelper::map(User::find()->where(['status' => '1'])->andWhere(['NOT', '_id', Yii::$app->user->id])->orderBy('email')->all(), '_id', 'email');
 }
Esempio n. 2
0
 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;
 }