/**
* 保存或插入内容的标签
* @param string|array $tags 标签
* @return bool
* @throws ErrorException
* @throws \Exception
*/
public function saveTags($tags)
{
if (is_string($tags)) {
if (($tags = trim($tags)) === '') {
$tags = [];
} else {
$tags = explode(',', $tags);
}
}
//对标签去除空格并去重
$tags = array_unique(array_map('trim', $tags));
//如果标签为空并且是新增内容，则直接返回真
if (empty($tags) && !$this->id) {
return true;
}
$relationshipModel = new Relationship();
$metaModel = new Meta(['scenario' => Meta::SCENARIO_TAG]);
//取出Meta表已经有的同名标签
$existTags = $metaModel->find()->where(['type' => Meta::TYPE_TAG])->andFilterWhere(['in', 'name', $tags])->select(['name'])->asArray()->column();
//取出数据库没有的标签名称（要添加到Meta表的标签）
$newTags = array_diff($tags, $existTags);
if (!empty($newTags)) {
//如果有新增的标签
foreach ($newTags as $tag) {
$model = clone $metaModel;
$model->setAttributes(['name' => $tag]);
if (!$model->insert()) {
throw new ErrorException(current($model->getFirstErrors()));
}
}
}
//如果标签不为空
if (!empty($tags)) {
//找出本内容的标签
$contentTags = $metaModel->find()->where(['type' => Meta::TYPE_TAG, 'name' => $tags, 'status' => Meta::STATUS_ACTIVE])->select(['id', 'name'])->asArray()->all();
} else {
$contentTags = [];
}
//取出久的标签
$oldTags = ArrayHelper::getColumn($this->tags, 'name');
$updateCountersTagIds = [];
if (!empty($contentTags)) {
//准备插入的文章关联标签
$relationshipInsertData = [];
foreach ($contentTags as $tag) {
//如果要加的标签之前就有则跳过
if (in_array($tag['name'], $oldTags)) {
continue;
}
$relationshipInsertData[] = ['content_id' => $this->id, 'meta_id' => $tag['id']];
$updateCountersTagIds[] = $tag['id'];
}
if (!empty($relationshipInsertData)) {
if (!$relationshipModel->getDb()->createCommand()->batchInsert($relationshipModel->tableName(), ['content_id', 'meta_id'], $relationshipInsertData)->execute()) {
throw new \ErrorException('插入文章标签关联失败');
}
}
}
$deleteTagIds = [];
foreach ($this->tags as $tag) {
if (!in_array($tag->name, $tags)) {
$deleteTagIds[] = $tag->id;
}
}
//内容新增的标签的内容统计+1
if (!empty($updateCountersTagIds)) {
if (!$metaModel->updateAllCounters(['content_total' => 1], ['id' => $updateCountersTagIds])) {
throw new ErrorException('更新标签内容统计失败');
}
}
if (!empty($deleteTagIds)) {
//内容之前的标签被删除则内容统计-1
$metaModel->updateAllCounters(['content_total' => -1], ['id' => $deleteTagIds]);
//然后删除内容里这些不要的标签
$relationshipModel->deleteAll(['content_id' => $this->id, 'meta_id' => $deleteTagIds]);
}
return true;
}
