public function getListByCategory($slug, $fields = [], $with = [], $page = false, $pageSize = false, $order = '')
{
$category = Category::getInstance()->getBySlug($slug);
$model = self::$model->find()->select($fields)->where(['type' => Content::TYPE_ARTICLE, 'status' => Content::STATUS_ACTIVE, 'meta_id' => $category['id']])->join('RIGHT JOIN', Relationship::tableName() . ' relation', 'content_id=id');
$countModel = clone $model;
$pagination = new Pagination(['totalCount' => $countModel->count(), 'pageSize' => $pageSize]);
if ($page) {
$pagination->setPage($page, true);
}
switch (strtoupper($order)) {
case 'VIEW':
$model->orderBy('view_total DESC');
break;
case 'COMMENT':
$model->orderBy('comment_total DESC');
break;
case 'CREATED':
$model->orderBy('created_at DESC');
break;
case 'UPDATED':
$model->orderBy('updated_at DESC');
break;
}
return ['data' => $model->with($with)->limit($pagination->getLimit())->offset($pagination->getOffset())->all(), 'pagination' => $pagination];
}
public function getPosts($isPublished = true)
{
$query = $this->hasMany(Post::className(), ['cid' => 'cid'])->with('categories')->with('tags')->with('author')->orderByCid();
if ($isPublished) {
$query = $query->published();
}
return $query->viaTable(Relationship::tableName(), ['mid' => 'mid']);
}
public function getTags()
{
return $this->hasMany(Tag::className(), ['mid' => 'mid'])->where('type=:type', [':type' => Tag::TYPE])->viaTable(Relationship::tableName(), ['cid' => 'cid']);
}
/**
* 保存或插入内容的标签
* @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;
}
