public function actionIndex() { Yii::app()->page->title = Yii::t("page", "Частные туристические объявления"); $p = (int) Yii::app()->request->getParam("p", 1); $saved = (int) Yii::app()->request->getParam("saved", 0); $categoryId = "status_id = 1"; $categoryModel = new CatalogItemsCategory(); foreach ($_GET as $key => $item) { if (!empty($_GET[$key]) && $_GET[$key] != "null") { continue; } $categoryModel = CatalogItemsCategory::fetchBySlug($key); if ($categoryModel->id > 0) { $categoryId = $categoryModel->id; } break; } $addModel = new CatalogItemsAdd(); if (!empty($saved)) { $addModel->formMessage = Yii::t("addsuser", "Ваше объявление успешно опубликовано.<br/>Для добавления большого количества картинок для объявления или его редактирования пройдите по ссылке") . " <a href=\"" . SiteHelper::createUrl("/user/items/description", array("id" => $saved)) . "\">" . SiteHelper::createUrl("/user/items/description", array("id" => $saved)) . "</a>"; } $condition = ""; $params = array(); if ($categoryId > 0) { $params = array_merge($params, array(":category" => $categoryId)); $condition = " category_id=:category"; } $items = CatalogItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions($condition)->setParams($params)->setCache(0)->setLimit(25)->setPage($p)->setOrderBy("id DESC")); $this->render("index", array("items" => $items, "categoryModel" => $categoryModel, "addModel" => $addModel)); }
/** * This is the default 'index' action that is invoked * when an action is not explicitly requested by users. */ public function actionIndex() { Yii::app()->page->title = "Каталог продукции"; if (!Yii::app()->user->isGuest) { $itemModel = new CatalogItemsAdd(); if (!empty($_POST["save_profile"])) { $itemModel->setAttributesFromArray($_POST["CatalogItemsAdd"]); $itemModel->user_id = Yii::app()->user->id; $itemModel->status_id = 3; // По умолчанию не активен $itemModel->date = time(); if ($itemModel->saveParam()) { $itemModel->onAddItem(new CModelEvent($itemModel), array("id" => $itemModel->id, "subject" => $itemModel->name, "date" => date("d.m.Y"), "description" => SiteHelper::getSubTextOnWorld($itemModel->description, 200), "link" => Yii::app()->params["adminEmail"] . SiteHelper::createUrl("/user/items/description/", array("id" => $itemModel->id)))); $this->redirect(SiteHelper::createUrl("/catalog/add/save", array("id" => $itemModel->id))); } } $addDopParams = null; if ($itemModel->category_id && $itemModel->category_id->id > 0) { $categoryModel = CatalogItemsCategory::fetch($itemModel->category_id->id); if ($categoryModel->table_name) { $catalogClass = SiteHelper::getCamelCase($categoryModel->table_name); $addDopParams = new $catalogClass(); } } $this->render("add", array("form" => $itemModel, "addDopParams" => $addDopParams)); } else { Yii::app()->session['redirect'] = SiteHelper::createUrl("/catalog/add"); $this->render("addauthWidget"); } }
public function refreshParam() { if ($this->category_id > 0) { $categoryModel = CatalogItemsCategory::fetch($this->category_id); if ($categoryModel->table_name) { $categoryTable = SiteHelper::getCamelCase($categoryModel->table_name); $paramItem = $categoryTable::findByAttributes(array("item_id" => $this->id)); if (sizeof($paramItem) > 0) { $this->param = $paramItem[0]; } else { $this->param = new $categoryTable(); } } } }
public function textFind($findText) { Yii::app()->page->title = "Поиск продукции"; if (!empty($findText)) { $arrayData = array(); $listCid = CatalogItemsCategory::sql("SELECT c2.name as cid_name, c.name, c.id, count(i.id) as c FROM catalog_items_category c, catalog_items_category c2, catalog_items i WHERE ( i.name like '%" . $findText . "%' OR i.description like '%" . $findText . "%' ) AND c.id=i.category_id AND c2.id = c.owner GROUP BY i.category_id"); for ($i = 0; $i < sizeof($listCid); $i++) { $cidName = $listCid[$i]["cid_name"]; if (!empty($arrayData[$cidName]["count"])) { $arrayData[$cidName]["count"] += $listCid[$i]["c"]; } else { $arrayData[$cidName]["count"] = $listCid[$i]["c"]; } $arrayData[$cidName]["items"][] = $listCid[$i]; } $items = CatalogItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("name like '%" . $findText . "%' OR description like '%" . $findText . "%'")->setLimit(10)); $this->render("index", array("arrayData" => $arrayData, "items" => $items)); } else { $this->redirect(SiteHelper::createUrl("/")); } }
<div class="blockName">категории</div> <ul> <?php foreach (CatalogItemsCategory::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("owner=:cat AND id!=2")->setParams(array(":cat" => 0))->setOrderBy("name")) as $item) { ?> <li> <a href="#" class="BNcat" title="<?php echo $item->name; ?> "><?php echo $item->name; ?> </a> <?php $i = 0; foreach (CatalogItemsCategory::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("owner=:cat")->setParams(array(":cat" => $item->id))->setOrderBy("name")) as $item2) { ?> <?php if ($i == 0) { ?> <ul <?php if ($cidOwner->owner != $item->id) { ?> class="displayNone"<?php } ?> ><?php } ?> <li><a href="<?php echo SiteHelper::createUrl("/catalog/default/index", array("cid" => $item2->id));
<div class="leftBlock"> <?php $this->widget("authWidget"); ?> <div id="LMenu"> <div class="MNHeader"><?php echo Yii::t("page", "Категории объявлений"); ?> </div> <?php foreach (CatalogItemsCategory::fetchAll(DBQueryParamsClass::CreateParams()->setOrderBy("pos, name")) as $item) { ?> <div class="LMItem"> <a href="<?php echo SiteHelper::createUrl("/adsUsers") . "/" . $item->slug; ?> .html" title="<?php echo $item->name; ?> - <?php echo Yii::t("page", "категория частных объявлений"); ?> "><?php echo $item->name; ?> </a> </div> <?php } ?> </div>