public static function getTags($fields = [], $with = [], $pageSize = false, $page = false) { $model = Meta::find()->where(['type' => Meta::TYPE_TAG, 'status' => Meta::STATUS_ACTIVE]); $countModel = clone $model; $pagination = new Pagination(['totalCount' => $countModel->count('id'), 'pageSize' => $pageSize]); if ($page) { $pagination->setPage($page, true); } return ['data' => $model->select($fields)->with($with)->limit($pagination->getLimit())->offset($pagination->getOffset())->orderBy('created_at desc')->asArray()->all(), 'pagination' => $pagination]; }
public function search($params) { $query = Meta::find(); $query->andFilterWhere(['type' => Meta::TYPE_ARTICLE_CATEGORIES]); $query->with('parent'); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'content_total' => $this->content_total, 'created_at' => $this->created_at, 'parent_id' => $this->parent_id]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
public function search($params) { $query = Meta::find(); switch ($this->scenario) { case self::SCENARIO_TAG: $query->andFilterWhere(['type' => self::TYPE_TAG]); break; case self::SCENARIO_LINK_CATEGORIES: $query->andFilterWhere(['type' => self::TYPE_LINK_CATEGORIES]); break; case self::SCENARIO_ARTICLE_CATEGORIES: case self::SCENARIO_DEFAULT: default: $query->andFilterWhere(['type' => self::TYPE_ARTICLE_CATEGORIES]); } $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'parent_id' => $this->parent_id, 'content_total' => $this->content_total]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
<?php use yii\helpers\Html; use kartik\widgets\ActiveForm; use kartik\builder\Form; use kartik\datecontrol\DateControl; /** * @var yii\web\View $this * @var common\models\Meta $model * @var yii\widgets\ActiveForm $form */ $parents = \yii\helpers\ArrayHelper::map(\common\models\Meta::find()->where(['status' => \common\models\Meta::STATUS_ACTIVE, 'type' => \common\models\Meta::TYPE_ARTICLE_CATEGORIES, 'parent_id' => 0])->asArray()->all(), 'id', 'name'); $parents = \yii\helpers\ArrayHelper::merge([0 => '顶级分类'], $parents); ?> <div class="meta-form"> <?php $form = ActiveForm::begin(['type' => ActiveForm::TYPE_HORIZONTAL]); echo Form::widget(['model' => $model, 'form' => $form, 'columns' => 1, 'attributes' => ['name' => ['type' => Form::INPUT_TEXT, 'options' => ['maxlength' => 32, 'placeholder' => 'Enter Name...']], 'slug' => ['type' => Form::INPUT_TEXT, 'options' => ['maxlength' => 255, 'placeholder' => 'Enter Slug...']], 'parent_id' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => \kartik\widgets\Select2::className(), 'options' => ['data' => $parents]], 'description' => ['type' => Form::INPUT_TEXTAREA, 'options' => ['rows' => 5, 'maxlength' => 255, 'placeholder' => 'Enter Description...']]]]); ?> <div class="form-group"> <div class="col-sm-offset-2 col-sm-10"> <?php echo Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> </div> <?php ActiveForm::end(); ?>
/** * 保存或插入内容的标签 * @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; }
public function getAll($fields = [], $with = []) { return self::$model->find()->select($fields)->with($with)->where(['type' => Meta::TYPE_ARTICLE_CATEGORIES, 'status' => Meta::STATUS_ACTIVE])->asArray()->all(); }