PHP Authors::find方法代码示例

 /**
  * @return array(['id' => 'fullname])
  */
 public static function getAuthorsForDropDownList()
 {
     $authorsModels = Authors::find()->all();
     $authors = ArrayHelper::toArray($authorsModels, ['app\\models\\Authors' => ['id', 'fullname' => function ($model) {
         return "{$model->firstname} {$model->lastname}";
     }]]);
     return ArrayHelper::map($authors, 'id', 'fullname');
 }

 public static function getAuthorsName($id = null)
 {
     $results = ['' => 'Не указан'];
     foreach (Authors::find()->all() as $data) {
         $results[$data->id] = $data->lastname . ' ' . $data->firstname;
     }
     return !empty($id) ? $results[$id] : $results;
 }

 public static function map()
 {
     $authors = Authors::find()->all();
     $map = array();
     array_walk($authors, function ($val) use(&$map) {
         $map[$val->id] = $val->firstname . ' ' . $val->lastname;
     });
     return $map;
 }

 public static function getAuthors()
 {
     $result = ['' => ''];
     $x = Authors::find()->all();
     foreach ($x as $author) {
         $result[$author->id] = "{$author->firstname} {$author->lastname}";
     }
     return $result;
 }

 public static function getList()
 {
     $list = [];
     $authors = Authors::find()->all();
     foreach ($authors as $author) {
         $list[$author->id] = $author->firstname . ' ' . $author->lastname;
     }
     return $list;
 }

 /**
  * Updates an existing Books model.
  * If update is successful, the browser will be redirected to the 'view' page.
  * @param integer $id
  * @return mixed
  */
 public function actionUpdate($id)
 {
     $model = $this->findModel($id);
     if ($model->load(Yii::$app->request->post()) && $model->save()) {
         return $this->redirect(['view', 'id' => $model->id]);
     } else {
         return $this->render('update', ['model' => $model, 'authors' => $this->getAuthorsArray(Authors::find()->all())]);
     }
 }

 public static function getAuthorList()
 {
     $list = array();
     $authors = Authors::find()->all();
     //Все авторы
     foreach ($authors as $value) {
         $list[$value->id] = $value->firstname . " " . $value->lastname;
     }
     return $list;
 }

 public function getAuthors()
 {
     $authors = Authors::find()->orderBy('firstname')->all();
     $lastname = ArrayHelper::map($authors, 'id', 'lastname');
     $firstname = ArrayHelper::map($authors, 'id', 'firstname');
     foreach ($lastname as $key => $value) {
         $fullName[$key] = $firstname[$key] . ' ' . $lastname[$key];
     }
     return $fullName;
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Authors::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id]);
     $query->andFilterWhere(['like', 'firstname', $this->firstname])->andFilterWhere(['like', 'lastname', $this->lastname]);
     return $dataProvider;
 }

 public static function getNameAuthor($id = NULL)
 {
     if ($id == NULL) {
         return NULL;
     }
     $author = Authors::find()->where(['id' => $id])->asArray()->one();
     if (!empty($author)) {
         return $author['firstname'] . ' ' . $author['lastname'];
     } else {
         return NULL;
     }
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Authors::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $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');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'date_create' => $this->date_create, 'date_update' => $this->date_update]);
     $query->andFilterWhere(['like', 'name', $this->name]);
     return $dataProvider;
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Authors::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $dataProvider->setSort(['attributes' => ['id', 'fullName' => ['asc' => ['first_name' => SORT_ASC, 'last_name' => SORT_ASC], 'desc' => ['first_name' => SORT_DESC, 'last_name' => SORT_DESC], 'label' => 'Full Name', 'default' => SORT_ASC]]]);
     $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');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id]);
     $query->andFilterWhere(['like', 'firstname', $this->firstname])->andFilterWhere(['like', 'lastname', $this->lastname])->andWhere('first_name LIKE "%' . $this->fullName . '%" ' . 'OR last_name LIKE "%' . $this->fullName . '%"');
     return $dataProvider;
 }

 public function search($params)
 {
     $query = Authors::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $dataProvider->setSort(['attributes' => ['id', 'fullName' => ['asc' => ['firstname' => SORT_ASC, 'lastname' => SORT_ASC], 'desc' => ['firstname' => SORT_DESC, 'lastname' => SORT_DESC], 'default' => SORT_ASC], 'firstname', 'lastname']]);
     $this->load($params);
     if (!$this->validate()) {
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id]);
     $query->andFilterWhere(['like', 'firstname', $this->firstname]);
     $query->andFilterWhere(['like', 'lastname', $this->lastname]);
     $query->andWhere('firstname LIKE "%' . $this->fullName . '%" ' . 'OR lastname LIKE "%' . $this->fullName . '%"');
     return $dataProvider;
 }

 public function actionEdit($id = null)
 {
     if (empty($id)) {
         $model = new Books();
     } else {
         $model = Books::find()->where(['id' => $id])->one();
     }
     if ($model->load(Yii::$app->request->post()) && $model->validate()) {
         $model->date_create = date('Y-m-d H:i:s');
         $model->save();
         return $this->redirect('index.php?r=site%2Fbooks');
     }
     $authors = Authors::find()->all();
     $selected_authors = array();
     foreach ($authors as $author) {
         $selected_authors[$author->id] = $author['firstname'] . " " . $author['lastname'];
     }
     return $this->render('edit', ['model' => $model, 'authors' => $selected_authors, 'book_id' => $id]);
 }

 public function actionBooks()
 {
     $session = Yii::$app->session;
     $search = new SearchForm();
     if ($search->load(Yii::$app->request->post()) && $search->validate()) {
         $session['search'] = Yii::$app->request->post();
     } elseif (!empty($session['search']['SearchForm'])) {
         $search->load($session['search']);
     }
     if (empty($session['search']['SearchForm'])) {
         $books = Books::find()->all();
     } else {
         $books = Books::findWithFilters($session['search']['SearchForm']);
     }
     $authors = Authors::find()->all();
     $selected_authors = array();
     foreach ($authors as $author) {
         $selected_authors[$author->id] = $author['firstname'] . " " . $author['lastname'];
     }
     return $this->render('books', ['model' => $search, 'authors' => $selected_authors, 'books' => $books]);
 }