/**
  * Seeds the table.
  *
  * @return void
  */
 public function run()
 {
     $author = new Author();
     $author->first_name = 'Dan';
     $author->last_name = 'Gebhardt';
     $author->twitter = 'dgeb';
     $author->save();
 }

 public function actionIndex()
 {
     $searchModel = new SearchBook();
     $author = new Author();
     $author->surname = '';
     $authors_data = $author->find()->select(['id', "name"])->all();
     $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
     return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'author' => $author, 'authors_data' => $authors_data]);
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     $result = Validator::make(Input::all(), ['title' => 'required', 'author' => 'required', 'publisher' => 'required', 'isbn' => "required|max:13|min:13|regex:/^[1-9][0-9]{12}\$/"], ['title.required' => 'Book title is required', 'author.required' => 'Book author is required', 'isbn.required' => 'ISBN is required', 'isbn.max' => 'ISBN must be exactly 13 characters', 'isbn.min' => 'ISBN must be exactly 13 characters', 'isbn.regex' => 'ISBN must contain numbers only.', 'publisher.required' => 'Publisher is required']);
     if ($result->fails()) {
         $result->errors()->add('submitted', 1);
         $result->errors()->add('desc', Input::get('description') !== "" ? TRUE : FALSE);
         return redirect()->route('books.new')->withErrors($result->errors())->withInput();
     }
     $author_id = $request->get('author_id');
     if (intval($author_id) == -1) {
         $new_author = new Author();
         $new_author->author_name = $request->get('author');
         $new_author->save();
         $author_id = $new_author->id;
         // Create copy of newly created author
         $new_author = new Author();
         $new_author->author_name = $request->get('author');
         $new_author->record_id = $author_id;
         $new_author->save();
     }
     $publisher_id = $request->get('publisher_id');
     if (intval($publisher_id) == -1) {
         $new_publisher = new Publisher();
         $new_publisher->name = $request->get('publisher');
         $new_publisher->save();
         $publisher_id = $new_publisher->id;
         // Create copy of newly created publisher
         $new_publisher = new Publisher();
         $new_publisher->name = $request->get('publisher');
         $new_publisher->record_id = $publisher_id;
         $new_publisher->save();
     }
     $book = new Books();
     $book->title = $request->get("title");
     $book->author_id = $author_id;
     $book->publisher_id = $publisher_id;
     $book->isbn = $request->get("isbn");
     $book->description = $request->get('description');
     $book->date_published = $request->get('date_published');
     $book->save();
     $book_id = $book->id;
     // Create copy of newly created book
     $book = new Books();
     $book->title = $request->get("title");
     $book->author_id = $author_id;
     $book->publisher_id = $publisher_id;
     $book->isbn = $request->get("isbn");
     $book->description = $request->get('description');
     $book->date_published = $request->get('date_published');
     $book->record_id = $book_id;
     $book->save();
     return redirect()->route('books.home')->with('status', "New book created");
 }

 public function actionLogin()
 {
     $user_name = \Yii::$app->request->post()['user_name'];
     $password = \Yii::$app->request->post()['pwd'];
     $author_info = new Author();
     $author_info->name = $user_name;
     $author_info->pwd = $password;
     if ($author_info->save()) {
         $author_id = Author::findBySql("select id from author ORDER BY id DESC LIMIT 0,1")->asArray()->all();
         $array = ['error_no' => 0, 'error_msg' => '', 'data' => $author_id[0]];
         echo json_encode($array);
     }
 }

 /**
  * @inheritdoc
  */
 public function getRelationships($post, array $includeRelationships = [])
 {
     /** @var Post $post */
     // that's an example how $includeRelationships could be used for reducing requests to database
     if (isset($includeRelationships['author']) === true) {
         // as author will be included as full resource we have to give full resource
         $author = $post->author;
     } else {
         // as author will be included as just id and type so it's not necessary to load it from database
         $author = new Author();
         $author->setAttribute($author->getKeyName(), $post->author_id);
     }
     return ['author' => [self::DATA => $author], 'comments' => [self::DATA => $post->comments->all()]];
 }

 /**
  * Показывает контент
  * @return string
  * @TODO Нужно предусмотреть возможность вывода разного контента, привязаного к одной категории
  *
  */
 public function actionShow()
 {
     $this->cat_id = Yii::$app->getRequest()->getQueryParam('id') ? Yii::$app->getRequest()->getQueryParam('id') : null;
     $cat_obg = Categories::find()->where('id = ' . $this->cat_id)->one();
     $allContent = Articles::find()->where('cat_id = ' . $this->cat_id)->all();
     $allArticlesForPager = Articles::find()->where(['cat_id' => $this->cat_id]);
     $countQueryCont = clone $allArticlesForPager;
     $pagesGlobal = new Pagination(['totalCount' => $countQueryCont->count(), 'pageSize' => 1, 'forcePageParam' => false, 'pageSizeParam' => false]);
     $artPages = $allArticlesForPager->offset($pagesGlobal->offset)->limit($pagesGlobal->limit)->all();
     foreach ($allContent as $article) {
         //var_dump($this->cat_id);
         $this->article_id = $article->id;
         $article = Articles::findOne($this->article_id);
         $allArticles = ArticlesContent::find()->where(['articles_id' => $this->article_id])->orderBy(['id' => SORT_DESC]);
         //var_dump($allArticles); exit;
         $countQuery = clone $allArticles;
         $pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => isset($article->onepages) ? $article->onepages : 0, 'forcePageParam' => false, 'pageSizeParam' => false]);
         $models = $allArticles->offset($pages->offset)->limit($pages->limit)->all();
         $this->source = Source::find()->where(['id' => $models[0]->source_id])->one()->title;
         $this->author = Author::find()->where(['id' => Source::find()->where(['id' => $models[0]->source_id])->one()->author_id])->one()->name;
         $this->articles[] = ['article' => $article, 'contents' => $models, 'pages' => $pages, 'source' => $this->source, 'author' => $this->author];
     }
     //var_dump($this->articles); exit;
     return $this->renderPartial($cat_obg->action, ['articles' => $this->articles, 'cat' => $this->cat_id, 'pagesGlobal' => $pagesGlobal, 'artPages' => $artPages, 'cat_obg' => $cat_obg]);
 }

 /**
  * Создание автораа
  * @return string
  */
 public function actionCreate()
 {
     $model = new Author();
     if ($model->load(Yii::$app->request->post())) {
         $model->name = Yii::$app->request->post('Author')['name'];
         $model->status = Yii::$app->request->post('Author')['status'];
         $model->description = Yii::$app->request->post('Author')['description'];
         $model->country_id = Yii::$app->request->post('Author')['country_id'];
         $model->save(false);
         $authors = Author::find();
         $dataProvider = new ActiveDataProvider(['query' => $authors]);
         return $this->redirect(Url::toRoute('author/index'));
     } else {
         return $this->render('_form', ['model' => $model]);
     }
 }

 /**
  * @param $name
  * @return Author
  */
 public function __get($name)
 {
     if ('author' === $name && null !== $this->author_id) {
         return Author::findByID($this->author_id);
     }
     return false;
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $faker = Faker\Factory::create();
     foreach (range(1, 100) as $index) {
         DB::table('books')->insert(['title' => $faker->word(), 'preview' => $faker->sentence(), 'author_id' => \App\Models\Author::orderByRaw("RAND()")->first()->id, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now()]);
     }
 }

 public function search($params)
 {
     $query = Author::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     $query->andFilterWhere(['like', 'name', $this->name]);
     return $dataProvider;
 }

 public function getAuthor()
 {
     if (!empty($this->data['author_id'])) {
         return Author::findOneById($this->data['author_id']);
     } else {
         return false;
     }
 }

 /**
  * Test samples for all models have been seeded.
  */
 public function testModelSeed()
 {
     $message = 'Haven\'t you forgotten to run artisan migrate and db::seed?';
     $this->assertNotEmpty(Author::all(), $message);
     $this->assertNotEmpty(Comment::all(), $message);
     $this->assertNotEmpty(Post::all(), $message);
     $this->assertNotEmpty(Site::all(), $message);
 }

 /**
  * @param string $q
  * @return array
  */
 public function actionIndex($q = null)
 {
     Yii::$app->getResponse()->format = Response::FORMAT_JSON;
     $model = Author::find()->limit(10);
     if (!is_null($q)) {
         $model->where(['or', ['like', 'firstname', $q], ['like', 'lastname', $q]]);
     }
     return ['results' => $model->all()];
 }

 /**
  * Удаление автора.
  *
  * @param int $id
  * @return \yii\web\Response
  */
 public function actionDelete($id)
 {
     /** @var Author $modelAuthor */
     $modelAuthor = Author::findOne($id);
     if ($modelAuthor->delete()) {
         return $this->redirect(['back-author/index']);
     }
     return $this->refresh();
 }

 /**
  * Updates an existing Book 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);
     $authors = \app\models\Author::find()->all();
     if ($model->load(Yii::$app->request->post()) && $model->save()) {
         return $this->redirect(['index']);
     } else {
         return $this->render('update', ['model' => $model, 'authors' => $authors]);
     }
 }

 public function actionIndex()
 {
     $this->view->news = Article::findAllWithGenerator();
     $this->view->table = (new AdminDataTable(Author::findAll(), [function ($model) {
         return $model->getName();
     }, function ($model) {
         return $model->getEmail();
     }]))->render();
     $this->view->display(__DIR__ . '/../../templates/admin.php');
 }

 /**
  * Test samples for all models have been seeded.
  */
 public function testModelSeed()
 {
     $message = 'Haven\'t you forgotten to run artisan migrate and db::seed?';
     $this->assertNotEmpty(Author::all(), $message);
     $this->assertNotEmpty(Comment::all(), $message);
     $this->assertNotEmpty(Post::all(), $message);
     $this->assertNotEmpty(Site::all(), $message);
     $isAuthenticated = Auth::attempt(['email' => UsersTableSeeder::SAMPLE_LOGIN, 'password' => UsersTableSeeder::SAMPLE_PASSWORD]);
     $this->assertTrue($isAuthenticated);
 }

 /**
  * Это магический метод __get, доработанный под данную модель. При запросе
  * свойства author проверяет, не пустое ли у объекта свойство $author_id, и
  * если не пустое, то возвращает объект класса Author
  *
  * @param $k string Имя свойства
  * @return null  Если имя свойства не равно 'author'
  * @return object Authors, если имя свойства равно author
  */
 public function __get($k)
 {
     switch ($k) {
         case 'author':
             return Author::findById($this->author_id);
             break;
         default:
             return null;
     }
 }

 /**
  * Updates an existing Book 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()) {
         $file = UploadedFile::getInstance($model, 'preview');
         if ($model->upload($file) && $model->save()) {
             return $this->redirect(Url::previous());
         }
     }
     return $this->render('update', ['model' => $model, 'authors' => Author::find()->all()]);
 }

 public function actionUpdate($id)
 {
     $book = Book::findOne(['id' => $id]);
     $filtredModel = Yii::$app->request->get('filtredModel');
     if (Yii::$app->request->isPost) {
         $book->load(Yii::$app->request->post());
         $book->save();
         $this->redirect(Url::to(array_merge(['books/index'], $filtredModel)));
     }
     return $this->render('update', ['book' => $book, 'authors' => Author::find()->all(), 'Book' => $filtredModel]);
 }