public static function afterTopicDelete($topicId) { $tagTopics = static::find()->select(['tag_id'])->where(['topic_id' => $topicId])->asArray()->all(); if (empty($tagTopics)) { return; } $tagIds = ArrayHelper::getColumn($tagTopics, 'tag_id'); Tag::updateAllCounters(['topic_count' => -1], ['and', ['id' => $tagIds], ['>', 'topic_count', 0]]); static::deleteAll(['topic_id' => $topicId]); }
public function afterSave($insert, $changedAttributes) { if (!$insert) { Yii::$app->db->createCommand()->delete('author_book', ['bookId' => $this->id])->execute(); Yii::$app->db->createCommand()->delete('book_format', ['bookId' => $this->id])->execute(); Yii::$app->db->createCommand()->delete('book_tag', ['bookId' => $this->id])->execute(); } if (!empty($this->authors)) { $authorInsert = []; foreach ($this->authors as $author) { array_push($authorInsert, [$author, $this->id]); } Yii::$app->db->createCommand()->batchInsert('author_book', ['authorId', 'bookId'], $authorInsert)->execute(); } if (!empty($this->formats)) { $formatInsert = []; foreach ($this->formats as $format) { array_push($formatInsert, [$format, $this->id]); } Yii::$app->db->createCommand()->batchInsert('book_format', ['formatId', 'bookId'], $formatInsert)->execute(); } if (!empty($this->tags)) { $tagInsert = []; foreach ($this->tags as $tag) { array_push($tagInsert, [$tag, $this->id]); } Yii::$app->db->createCommand()->batchInsert('book_tag', ['tagId', 'bookId'], $tagInsert)->execute(); Tag::updateAllCounters(['frequency' => 1], ['id' => array_map('intval', $this->tags)]); } parent::afterSave($insert, $changedAttributes); }