public function search($params) { $query = Catalog::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $this->addCondition($query, 'name_en'); $this->addCondition($query, 'name_en', true); $this->addCondition($query, 'name_zh'); $this->addCondition($query, 'name_zh', true); $this->addCondition($query, 'redirect_url'); $this->addCondition($query, 'redirect_url', true); $this->addCondition($query, 'tpl_page'); $this->addCondition($query, 'tpl_page', true); $this->addCondition($query, 'tpl_list'); $this->addCondition($query, 'tpl_list', true); $this->addCondition($query, 'tpl_content'); $this->addCondition($query, 'tpl_content', true); $this->addCondition($query, 'note'); $this->addCondition($query, 'note', true); $this->addCondition($query, 'note2'); $this->addCondition($query, 'note2', true); return $dataProvider; }
/** * Lists all Catalog models. * @return mixed */ public function actionIndex() { $searchModel = new CatalogSearch(); //$dataProvider = $searchModel->search(Yii::$app->request->queryParams); //var_dump(Catalog::find()->all());die(); $dataProvider = Catalog::get(0, Catalog::find()->all()); //var_dump($dataProvider);die(); return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Catalog::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'parent_id' => $this->parent_id, 'is_nav' => $this->is_nav, 'sort_order' => $this->sort_order, 'page_size' => $this->page_size, 'click' => $this->click, 'status' => $this->status, 'create_time' => $this->create_time, 'update_time' => $this->update_time]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'brief', $this->brief])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'seo_title', $this->seo_title])->andFilterWhere(['like', 'seo_keywords', $this->seo_keywords])->andFilterWhere(['like', 'seo_description', $this->seo_description])->andFilterWhere(['like', 'banner', $this->banner])->andFilterWhere(['like', 'page_type', $this->page_type])->andFilterWhere(['like', 'template_list', $this->template_list])->andFilterWhere(['like', 'template_show', $this->template_show])->andFilterWhere(['like', 'template_page', $this->template_page])->andFilterWhere(['like', 'redirect_url', $this->redirect_url]); return $dataProvider; }
public static function getMainNav($currentId = 0) { $mainMenu = [['label' => Yii::t('app', 'Home'), 'url' => array('/site/index'), 'active' => 0 == $currentId]]; $allCatalog = Catalog::find()->where("parent_id=0")->orderBy(['sort_order' => SORT_ASC, 'id' => SORT_ASC])->all(); foreach ($allCatalog as $catalog) { $item = []; if ($catalog->redirect_url) { // redirect to other site $item = ['label' => $catalog->title, 'url' => $catalog->redirect_url, 'active' => $catalog->id == $currentId]; } else { if ('list' == $catalog->page_type) { $item = ['label' => $catalog->title, 'url' => ['/site/list/', 'id' => $catalog->id], 'active' => $catalog->id == $currentId]; } else { $item = ['label' => $catalog->title, 'url' => ['/site/page/', 'id' => $catalog->id], 'active' => $catalog->id == $currentId]; } } if (!empty($item)) { array_push($mainMenu, $item); } } return $mainMenu; }
editor = K.create('textarea[name="content"]', { allowFileManager : true }); }); JS; $this->registerJs($js, View::POS_END); ?> <div class="catalog-form"> <?php $form = ActiveForm::begin(['options' => ['class' => 'form-horizontal', 'enctype' => 'multipart/form-data'], 'fieldConfig' => ['template' => "{label}\n<div class=\"col-lg-3\">{input}{hint}</div>\n<div class=\"col-lg-8\">abc{error}</div>", 'labelOptions' => ['class' => 'col-lg-1 control-label']]]); ?> <?php echo $form->field($model, 'parent_id')->dropDownList(ArrayHelper::merge([0 => Yii::t('app', 'Root Catalog')], ArrayHelper::map(Catalog::get(0, Catalog::find()->all()), 'id', 'str_label'))); ?> <?php echo $form->field($model, 'title')->textInput(['maxlength' => 255])->hint('test'); ?> <?php echo $form->field($model, 'brief')->textInput(['maxlength' => 1022]); ?> <!--<?php /*= $form->field($model, 'content')->widget(letyii\tinymce\Tinymce::className(), [ 'options' => [ 'id' => 'content', ],
private function getDataSource() { if ($this->dataSource !== null) { return $this->dataSource; } $_tableName = $this->tableName; if ($_tableName == null) { $_catalogId = $this->catalogId; $catalogModel = Catalog::find($_catalogId); } $sql = ' select ' . ($this->fields === null ? '*' : $this->fields) . ' from ' . $_tableName; if ($this->where !== null) { $sql .= ' where ' . $this->where; } if ($this->order !== null) { $sql .= ' order by ' . $this->order; } if ($this->limit !== null && $this->limit > 0) { $sql .= ' limit 0,' . $this->limit; } //$db=Yii::$app->db; }
public function actionShow() { $id = isset($_GET['id']) ? (int) $_GET['id'] : 0; if (0 >= $id) { $this->redirect(Yii::$app->homeUrl); } $show = Show::findOne(['id' => $id]); $catalog = Catalog::findOne(['id' => $show->catalog_id]); $templatePage = $show->template ? $show->template : $catalog->template_show ? $catalog->template_show : 'show'; $portlet = Catalog::getCatalogSub2($id, Catalog::find()->all()); $portletTitle = Catalog::findOne(['id' => Catalog::getRootCatalogId($id, Catalog::find()->all())])->title; return $this->render($templatePage, ['catalog' => $catalog, 'show' => $show, 'portlet' => $portlet, 'portletTitle' => $portletTitle]); }
editor = K.create('textarea[name="content"]', { allowFileManager : true }); }); JS; $this->registerJs($js, View::POS_END); ?> <div class="show-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'catalog_id')->dropDownList(ArrayHelper::map(Catalog::get(0, Catalog::find()->all()), 'id', 'str_label')); ?> <?php echo $form->field($model, 'title')->textInput(['maxlength' => 255]); ?> <?php echo $form->field($model, 'brief')->textInput(['maxlength' => 1022]); ?> <?php echo $form->field($model, 'content')->textArea(['name' => 'content', 'style' => 'width:800px;height:400px;visibility:hidden;']); ?> <?php