Exemplo n.º 1
0
 /**
  * Updates an existing Book model.
  * If update is successful, the browser will be redirected to the 'view' page.
  *
  * @var Author[] $modelsAuthorNew
  * @param string $id Book id
  * @return mixed
  */
 public function actionUpdate($id)
 {
     $modelBook = $this->findModel($id);
     $modelBookForm = new BookForm($modelBook);
     $authorsId = $modelBook->getAuthors()->select('id')->asArray()->all();
     $modelsAuthor = Author::findAll($authorsId);
     //$modelBook->getAuthors()->asArray()->all();
     if ($modelBook->load(Yii::$app->request->post())) {
         $modelsAuthorNew = Model::createMultiple(Author::className());
         Model::loadMultiple($modelsAuthorNew, Yii::$app->request->post());
         //process, separate book keyWords
         $modelsKeyWordsNew = [new KeyWord()];
         if ($wordsArray = $modelBookForm->prepareKeyWords(Yii::$app->request->post('KeyWord')['words'])) {
             $modelsKeyWordsNew = Model::createMultiple(KeyWord::className(), [], $wordsArray);
             // KeyWord[0]['word' =>'php']
             Model::loadMultiple($modelsKeyWordsNew, $wordsArray, '');
         }
         $valid = $modelBook->validate();
         $valid = Model::validateMultiple($modelsAuthorNew) && $valid;
         $valid = $wordsArray === false ? $valid : Model::validateMultiple($modelsKeyWordsNew) && $valid;
         if ($valid && $modelBookForm->updateBook($modelsAuthor, $modelsAuthorNew, $modelsKeyWordsNew)) {
             Yii::$app->session->setFlash('success', Yii::t('app', Yii::t('app', 'Book was updated successfully.')));
             Yii::info($id . '_update', 'book');
             return $this->redirect(['view', 'id' => $modelBook->id]);
         } else {
             //get all errors from multiple models
             if (($msg = BookForm::getErrorsMessages($modelsAuthorNew)) !== false) {
                 Yii::$app->session->addFlash('danger', $msg);
             }
             if (($msg = BookForm::getErrorsMessages($modelsKeyWordsNew)) !== false) {
                 Yii::$app->session->addFlash('danger', $msg);
             }
         }
         Yii::$app->session->addFlash('danger', Yii::t('app', 'Book was not updated.'));
     }
     return $this->render('update', ['modelBook' => $modelBook, 'modelsAuthor' => empty($modelsAuthor) ? [new Author()] : $modelsAuthor, 'keyWords' => $modelBookForm->getKeyWords()]);
 }
Exemplo n.º 2
0
 /**
  * update book and all related parameters
  * if unchanged Author already exist do nothing, otherwise delete all old authors and create new
  * the same with KeyWord-s
  * - if author or key word already exist new book is assigned to him, if not they are created
  * - transaction is for consistent data (book, authors, key words)
  *
  * @param Author[] $modelsAuthor
  * @param Author[] $modelsAuthorNew
  * @var KeyWord[] $modelsKeyWordsNew
  * @return bool - true if transaction(update) is successful otherwise false
  * @throws \yii\db\Exception
  */
 public function updateBook($modelsAuthor, &$modelsAuthorNew, &$modelsKeyWordsNew)
 {
     $db = \Yii::$app->db;
     $transaction = $db->beginTransaction();
     try {
         if ($flag = $this->modelBook->save(false)) {
             //Authors - filter unchanged Authors
             foreach ($modelsAuthorNew as $authorNewKey => $authorNew) {
                 foreach ($modelsAuthor as $authorKey => $author) {
                     if ($authorNew->first_name === $author->first_name && $authorNew->last_name === $author->last_name) {
                         unset($modelsAuthorNew[$authorNewKey], $modelsAuthor[$authorKey]);
                     }
                 }
             }
             //delete all unused (old) Authors(link table record), if model Author is the last one, delete Author itself too
             foreach ($modelsAuthor as $ma) {
                 $maid = $ma->id;
                 if (($count = $db->createCommand('SELECT COUNT(*) FROM book_author WHERE author_id = :author_id')->bindParam(':author_id', $maid)->queryScalar()) !== false) {
                     $db->createCommand()->delete('book_author', ['author_id' => $ma->id, 'book_id' => $this->modelBook->id])->execute();
                     if ($count == 1) {
                         $ma->delete();
                     }
                 }
             }
             //add new Authors
             foreach ($modelsAuthorNew as $authorNew) {
                 if (($existA = Author::findOne(['first_name' => $authorNew->first_name, 'last_name' => $authorNew->last_name])) !== null) {
                     $this->modelBook->link('authors', $existA);
                 } else {
                     if (!($flag = $authorNew->save(false))) {
                         throw new Exception("Failed save new Authors in update book model action.");
                     }
                     $this->modelBook->link('authors', $authorNew);
                 }
             }
             //KeyWords - filter unchanged words
             $keyWordIds = $this->modelBook->getKeyWords()->select('id')->asArray()->all();
             $modelsKeyWords = KeyWord::findAll($keyWordIds);
             foreach ($modelsKeyWordsNew as $keyWordNewKey => $keyWordNew) {
                 foreach ($modelsKeyWords as $keyWordKey => $keyWord) {
                     if ($keyWordNew->word === $keyWord->word) {
                         unset($modelsKeyWordsNew[$keyWordNewKey], $modelsKeyWords[$keyWordKey]);
                     }
                 }
             }
             //delete all old KeyWords
             foreach ($modelsKeyWords as $mkw) {
                 $mkwid = $mkw->id;
                 if (($count = $db->createCommand('SELECT COUNT(*) FROM book_key_word WHERE key_word_id = :key_word_id')->bindParam(':key_word_id', $mkwid)->queryScalar()) !== false) {
                     $db->createCommand()->delete('book_key_word', ['key_word_id' => $mkw->id, 'book_id' => $this->modelBook->id])->execute();
                     if ($count == 1) {
                         $mkw->delete();
                     }
                 }
             }
             //save new keys
             if ($flag) {
                 foreach ($modelsKeyWordsNew as $keyWordNew) {
                     if (($existKey = KeyWord::findOne(['word' => $keyWordNew->word])) !== null) {
                         $this->modelBook->link('keyWords', $existKey);
                     } else {
                         if (!($flag = $keyWordNew->save(false))) {
                             throw new Exception("Failed save key words in update book action.");
                         }
                         $this->modelBook->link('keyWords', $keyWordNew);
                     }
                 }
             }
         }
         if ($flag) {
             $transaction->commit();
             return true;
         }
     } catch (\Exception $e) {
         \Yii::warning($e->getMessage());
         $transaction->rollBack();
         return false;
     }
     return false;
 }
Exemplo n.º 3
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getAuthors()
 {
     return $this->hasMany(Author::className(), ['id' => 'author_id'])->viaTable('book_author', ['book_id' => 'id']);
 }