/** * Показывает контент * @return string * @TODO Нужно предусмотреть возможность вывода разного контента, привязаного к одной категории * */ public function actionShow() { $this->cat_id = Yii::$app->getRequest()->getQueryParam('id') ? Yii::$app->getRequest()->getQueryParam('id') : null; $cat_obg = Categories::find()->where('id = ' . $this->cat_id)->one(); $allContent = Articles::find()->where('cat_id = ' . $this->cat_id)->all(); $allArticlesForPager = Articles::find()->where(['cat_id' => $this->cat_id]); $countQueryCont = clone $allArticlesForPager; $pagesGlobal = new Pagination(['totalCount' => $countQueryCont->count(), 'pageSize' => 1, 'forcePageParam' => false, 'pageSizeParam' => false]); $artPages = $allArticlesForPager->offset($pagesGlobal->offset)->limit($pagesGlobal->limit)->all(); foreach ($allContent as $article) { //var_dump($this->cat_id); $this->article_id = $article->id; $article = Articles::findOne($this->article_id); $allArticles = ArticlesContent::find()->where(['articles_id' => $this->article_id])->orderBy(['id' => SORT_DESC]); //var_dump($allArticles); exit; $countQuery = clone $allArticles; $pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => isset($article->onepages) ? $article->onepages : 0, 'forcePageParam' => false, 'pageSizeParam' => false]); $models = $allArticles->offset($pages->offset)->limit($pages->limit)->all(); $this->source = Source::find()->where(['id' => $models[0]->source_id])->one()->title; $this->author = Author::find()->where(['id' => Source::find()->where(['id' => $models[0]->source_id])->one()->author_id])->one()->name; $this->articles[] = ['article' => $article, 'contents' => $models, 'pages' => $pages, 'source' => $this->source, 'author' => $this->author]; } //var_dump($this->articles); exit; return $this->renderPartial($cat_obg->action, ['articles' => $this->articles, 'cat' => $this->cat_id, 'pagesGlobal' => $pagesGlobal, 'artPages' => $artPages, 'cat_obg' => $cat_obg]); }
public function postForm(FormCategoryRequest $request) { if (!empty($request)) { $pathImage = $request->get('picture', null); $data = $request->all(); if ($request->hasfile('picture')) { $validator = Validator::make($request->all(), ['picture' => ['mimes:jpg,png,jpeg']]); if ($validator->fails()) { return redirect(action('Admin\\CategoryController@postForm'))->withErrors($validator)->withInput(); } $file = $request->file('picture'); $nameimage = date('Ymdhis') . rand(1, 1000) . '.' . $file->getClientOriginalExtension(); $file->move(public_path() . "/dinamic/category/", $nameimage); $pathImage = '/dinamic/category/' . $nameimage; $data['picture'] = $pathImage; } $data['flagactive'] = $request->get('flagactive', 1); if ($request->id) { $obj = Categories::find($request->id); $obj->update($data); $idTips = $obj->id; } else { $obj = Categories::create($data); $idTips = $obj->id; } return redirect('admpanel/' . self::NAMEC)->with('messageSuccess', 'Caracteristicas Guardado'); } return redirect('admpanel')->with('messageError', 'Error al guardar el tip'); }
/** * Lists all Categories models. * @return mixed */ public function actionIndex() { if (\Yii::$app->user->isGuest) { return $this->goHome(); } $dataProvider = new ActiveDataProvider(['query' => Categories::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }
public function actionList($id = 0) { if ($id != 0) { return $this->redirect(['album/list', 'id' => $id]); } $q = Categories::find()->where(['handler' => $this->id]); $dataProvider = new ActiveDataProvider(['query' => $q]); return $this->render('list', ['dataProvider' => $dataProvider]); }
public function actionKlavarosCats() { $res = []; $m = Categories::find()->where(['site_id' => 13])->all(); foreach ($m as $h) { $res[] = $h->name; } return json_encode($res); }
/** * Удаляет категорию * @param $id * @return \yii\web\Response * @throws \yii\web\HttpException */ public function actionDelete($id) { if ($model = $this->loadModel($id)->delete()) { $cats = Categories::find()->all(); return $this->render(['index', ['cats' => $cats]]); } else { throw new \yii\web\HttpException(404, 'Cant delete record.'); } }
/** * Updates an existing Categories model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $categoryId * @return mixed */ public function actionUpdate($categoryId) { $categories = Categories::find()->all(); //findAllExceptOne($categoryId); $model = $this->findModel($categoryId); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'categoryId' => $model->category_id]); } else { return $this->render('update', ['model' => $model, 'categories' => $categories]); } }
/** * Updates an existing Product model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $itemId * @return mixed */ public function actionUpdate($itemId) { $categories = Categories::find()->all(); // need this for dropDownList in views/product/_form.php $model = $this->findModel($itemId); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'itemId' => $model->item_id]); } else { return $this->render('update', ['model' => $model, 'categories' => $categories]); } }
public function actionList($categoryId = null) { /** @var Category $category */ $category = null; $categories = Categories::find()->indexBy('category_id')->orderBy('category_id')->all(); $productsQuery = Product::find(); if ($categoryId !== null && isset($categories[$categoryId])) { $category = $categories[$categoryId]; $productsQuery->where(['category_id' => $this->getCategoryIds($categories, $categoryId)]); } $productsDataProvider = new ActiveDataProvider(['query' => $productsQuery, 'pagination' => ['pageSize' => 10]]); return $this->render('list', ['category' => $category, 'menuItems' => $this->getMenuItems($categories, isset($category->category_id) ? $category->category_id : null), 'productsDataProvider' => $productsDataProvider]); }
public function remove($category_id) { $category = Categories::find($category_id); $category->delete(); if (Input::get('with_posts', '0') == '1') { Posts::where('category_id', $category_id)->delete(); Notifications::add('Category removed with posts', 'success'); } else { Posts::where('category_id', $category_id)->update(['category_id' => '1']); Notifications::add('Category removed. Posts moved to Uncategorized', 'success'); } return Redirect::route('root-categories'); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Categories::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['category_id' => $this->category_id, 'parent_category_id' => $this->parent_category_id, 'date_added' => $this->date_added, 'date_modified' => $this->date_modified, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by]); $query->andFilterWhere(['like', 'category_name', $this->category_name]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Categories::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'created_by' => $this->created_by, 'created_at' => $this->created_at]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Categories::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->joinWith('idArea'); $query->andFilterWhere(['id' => $this->id, 'category_id' => $this->category_id, 'service_level_agreement_asignment' => $this->service_level_agreement_asignment, 'service_level_agreement_completion' => $this->service_level_agreement_completion]); $query->andFilterWhere(['like', 'categories.name', $this->name])->andFilterWhere(['like', 'categories.description', $this->description])->andFilterWhere(['like', 'areas.name', $this->id_area]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Categories::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'lft' => $this->lft, 'rgt' => $this->rgt, 'depth' => $this->depth, 'tree' => $this->tree]); $query->andFilterWhere(['like', 'name', $this->name]); return $dataProvider; }
/** * @return string */ public function actionIndex() { $uploadFile = new UploadForm(); //var_dump($_POST); if (Yii::$app->request->isPost) { $uploadFile->file = UploadedFile::getInstance($uploadFile, 'file'); // var_dump($uploadFile->file); exit; if ($uploadFile->file && $uploadFile->validate()) { $uploadFile->file->saveAs('uploads/' . Yii::$app->translater->translit($uploadFile->file->baseName) . '.' . $uploadFile->file->extension); } else { print_r($uploadFile->getErrors()); exit; } } $cats = Categories::find()->where('site_id =' . $this->site->id)->roots()->all(); $articles = Articles::find()->where('site_id =' . $this->site->id . ' or site_id = 13')->all(); //$cats = Categories::find()->leaves()->all(); return $this->render('index', ['cats' => $cats, 'articles' => $articles, 'uploadFile' => $uploadFile]); }
/** * Updates an existing Bookings model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $model = $this->findModel($id); $customers = $this->getCustomers(); $categories = Categories::find(['ORDER BY' => 'name ASC'])->all(); $booking_items = $this->getBookingItems($id); $customer = Customers::findOne($model->idCustomer); $is_order = !empty(Orders::find()->where(['idBooking' => $model->id])->one()->id) ? true : false; $date_passed = strtotime($model->deliveryDate) < strtotime(date('Y-m-d')) ? true : false; $delivered = $is_order ? Orders::find()->where(['idBooking' => $model->id])->one()->delivered == 1 ? true : false : false; if (isset($_POST['Bookings'])) { $model->attributes = $_POST['Bookings']; if (isset($_POST['added-items-list'])) { $this->actionAddeditems(json_decode($_POST['added-items-list']), $id); } if ($model->save()) { return json_encode(1); } } else { return $this->renderAjax('update', ['model' => $model, 'customers' => $customers, 'categories' => $categories, 'customer' => $customer, 'booking_items' => $booking_items, 'is_order' => $is_order, 'date_passed' => $date_passed, 'delivered' => $delivered]); } }
public function index($categoryId) { $cacheTag = ['categories', 'category' . $categoryId, 'products']; $cacheKey = 'index'; $response = Cache::tags($cacheTag)->remember($cacheKey, 60 * 24 * 7, function () use($categoryId) { $_category = Categories::find($categoryId); if ($_category) { $data = $_category->products()->select(['id', 'name', 'description', 'price', 'more', 'image'])->where('active', 1)->get()->toArray(); if (count($data) > 0) { foreach ($data as $key => $value) { $data[$key]['category'] = $_category->description; } } return $data; } else { return new \Exception("Houve um erro ao localizar registro (id not found)"); } }); if ($response instanceof \Exception) { Cache::tags($cacheTag)->flush(); } return $response; }
/** * Creates a new InsightsDef model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate($idCategory = 4, $id = 0) { $model = new InsightsDef(); $content = new InsightsContent(); $model->name = $id; $model->id_category = $idCategory; if ($model->load(Yii::$app->request->post())) { $priorityCounter = 0; foreach (Yii::$app->request->post()['InsightsDef'] as $key => $value) { if (!in_array($key, ['id', 'id_category', 'priority', 'hospitals', 'units', 'specialities', 'name']) && $value != '') { $priorityCounter++; } } $model->priority = $priorityCounter; $model->save(); $content->id_insights_def = $model->id; $content->content = Yii::$app->request->post()['InsightsContent']['content']; $content->lang = 'pl'; $content->save(); return $this->redirect(['create', 'idCategory' => $model->id_category, 'id' => $model->id]); } else { $categories = Categories::find()->select(['name', 'id'])->indexBy('id')->column(); $indicatorNames = CategoriesIndicators::find()->where('id_categories = ' . $idCategory)->all(); $insights = InsightsDef::find()->where('id_category = ' . $idCategory)->all(); $insightsCollection = [0 => '']; foreach ($insights as $insight) { $name = ''; foreach ($insight->toArray() as $key => $value) { if (!in_array($key, ['id', 'id_category', 'priority', 'hospitals', 'units', 'specialities']) && $value !== null) { $name .= $key . '(' . $value . ')'; } } $insightsCollection[$insight->id] = $name; } return $this->render('create', ['model' => $model, 'content' => $content, 'categories' => $categories, 'indicatorNames' => $indicatorNames, 'insights' => $insightsCollection]); } }
public function actionList($id) { $q = Categories::find()->where(['handler' => $this->id, 'parent_id' => $id]); $dataProvider = new ActiveDataProvider(['query' => $q]); return $this->render('list', ['dataProvider' => $dataProvider, 'gallery' => Categories::findOne($id)]); }
/** * Choose a Category for an API. * @param integer $id * @return mixed */ public function actionChoosecategory($id) { $model = $this->findModel($id); $categories = Categories::find()->asArray()->all(); $categoriesList = ArrayHelper::map($categories, 'id', 'name'); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect('index'); } return $this->render('chooseCategory', ['model' => $model, 'categoriesList' => $categoriesList]); }
public function toCategory($post_id, $category_id) { $category = Categories::find($category_id); if (empty($category)) { Notifications::add('Category doesn\'t exist', 'danger'); return Redirect::back(); } $post = Posts::find($post_id); $post->category_id = $category_id; $post->save(); Notifications::add('Post "' . str_limit($post->title, '35', '...') . '" moved to category "' . e($category->title) . '"', 'info'); return Redirect::back(); }
?> <?= $form->field($request, 'name')->textInput(['value'=>$nameValue,'maxlength' => true]) ?> <?= $form->field($request, 'email')->textInput(['value'=> $emailValue,'maxlength' => true]) ?> <?= $form->field($request, 'area_id')->dropDownList( ArrayHelper::map( Areas::find()->all(), 'id', 'name' ), array('prompt'=> "")) ?> <?= $form->field($request, 'category_id')->dropDownList( ArrayHelper::map( Categories::find()->all(), 'id', 'name' ), array('prompt'=> "")) ?> <?= $form->field($request, 'subject')->textInput(['maxlength' => true]) ?> <?= $form->field($request, 'description')->textarea(['rows' => 6]) ?> <a id="agregarCampo" class="btn btn-info" >Agregar Archivo</a> <div id="contenedor"> <div class="added"> <!--<input type="file" name="Request[requestFile][]" id="campo_1" placeholder="Texto 1"/><a href="#" class="eliminar">×</a>--> </div>
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $category = Categories::find($id); $category->delete(); return redirect()->route('admin.categories.index')->with('success', 'Successfully deleted!'); }
public function listCategorySub($parent, $space = '|---') { global $arr; $children = Categories::find()->where(['parent_id' => $parent])->all(); foreach ($children as $child) { $data = array(); $data['id'] = $child->id; $data['title'] = $space . ' ' . $child->title; $arr[] = $data; Categories::listCategorySub($child->id, $space . '---'); } }
public function actionAll() { $dataProvider = new ActiveDataProvider(['query' => Categories::find()->where(['handler' => $this->id]), 'pagination' => false]); return $this->render('all', ['dataProvider' => $dataProvider]); }
</form> </div> <!-- Nav --> <nav id="nav"> <ul class="sf-menu sf-js-enabled"> <li <?php if (!Yii::$app->request->get('id')) { echo 'class="current"'; } ?> ><a href="/">Home.</a></li> <?php foreach (Categories::find()->orderBy(['updated_at' => SORT_DESC])->all() as $item) { ?> <li <?php if ($item->id == Yii::$app->request->get('id') && !Yii::$app->request->get('type')) { echo 'class="current"'; } ?> > <a href="<?php echo Url::to(['site/category', 'slug' => $item->slug, 'id' => $item->id]); ?> "><?php echo $item->name; ?> </a>
public function actionCreate() { $model = new Items(); $upload = new UploadForm(); $category = new Categories(); $subCat = new SubCatgories(); $category->find()->all(); $subCat->find()->all(); $model->is_aviable = 1; $description = new Description(); $description->item_id = 1; $description->sub_id = 1; $description->text = "s"; $description->save(); if ($model->load(Yii::$app->request->post()) && $model->save()) { if (isset($_POST['Description'])) { // print_r($_POST['Description']['sub_name']); $subCat = new SubCatgories(); $subCat->find()->where(['name' => $_POST['Description']['sub_name']])->all(); $s = $subCat->find()->where(['name' => $_POST['Description']['sub_name']])->all(); $description = new Description(); $description->item_id = $model->id; $description->sub_id = $s[0]['id']; $description->text = $_POST['Description']['text']; $description->category_name = $_POST['Description']['category_name']; $description->sub_name = $_POST['Description']['sub_name']; $description->save(); // echo "sssss"; // echo $description->sub_id; // echo $description->item_id; } if (isset($_POST['Description'])) { $upload = new UploadForm(); $upload->imageFiles = UploadedFile::getInstances($upload, 'imageFiles'); if ($upload->upload()) { echo "upload"; // file is uploaded successfully // return; } } // else // return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('create', ['model' => $model, 'category' => $category, 'subCat' => $subCat, 'description' => $description, 'upload' => $upload]); } }
?> </div> <div class="col-lg-10"> <?php $form = ActiveForm::begin(['options' => ['enctype' => 'multipart/form-data']]); ?> <?php echo $form->field($model, 'title')->textInput(); ?> <?php echo $form->field($model, 'site_id')->dropDownList(ArrayHelper::map(\app\models\Qpsites::find()->all(), 'id', 'title'), ['prompt' => 'Выбрать сайт']); ?> <?php echo $form->field($model, 'cat_id')->dropDownList(ArrayHelper::map(\app\models\Categories::find()->all(), 'id', 'name'), ['prompt' => 'Выбрать категорию']); ?> <?php echo $form->field($model, 'source_id')->dropDownList(ArrayHelper::map(\app\models\Source::find()->all(), 'id', 'title'), ['prompt' => 'Выбрать источник']); ?> <?php echo $form->field($model, 'redactor')->checkbox(); ?> <?php echo $form->field($model, 'text')->textarea(['rows' => 5, 'cols' => 5, 'id' => 'my-textarea-id']); ?> <?php echo $form->field($model, 'tags')->textInput(); ?> <?php echo $form->field($uploadFile, 'file')->fileInput();
use yii\widgets\ActiveForm; use app\models\Categories; use yii\helpers\ArrayHelper; /* @var $this yii\web\View */ /* @var $model app\models\Purchases */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="purchases-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'id_category')->dropDownList(ArrayHelper::map(Categories::find()->all(), 'id', 'name', 'parent.name')); ?> <?php echo $form->field($model, 'product')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'quantity')->textInput(); ?> <?php echo $form->field($model, 'price')->textInput(); ?> <?php
public function actionList($id = 0) { $dataProvider = new ActiveDataProvider(['query' => Categories::find()->where(['parent_id' => $id])->andWhere(['<>', 'alias', '0'])]); $model = Categories::findOne($id); return $this->render('list', ['dataProvider' => $dataProvider, 'model' => $model]); }