public function actionDescription()
{
Yii::app()->page->setInfo(array("description" => $this->description, "keyWord" => $this->keyWord));
$id = 0;
$class = $this->classModel;
if (!empty($_GET["slug"])) {
// echo $class."|".$_GET[ "slug" ]."-";
$model = $class::fetchBySlug(trim($_GET["slug"]));
if ($model->id > 0) {
$_GET["id"] = $model->id;
$id = $model->id;
}
}
//die;
if ($id > 0) {
$item = CatalogItems::fetch($id);
$item->setColView();
if ($item->id > 0) {
Yii::app()->page->title = $item->name;
$this->render('description', array("item" => $item, "otherHotels" => CatalogItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("category_id=:category_id AND id!=:id")->setParams(array(":category_id" => $item->category_id->id, ":id" => $item->id))->setOrderBy("col DESC")->setLimit(8)), "usersOther" => CatalogItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("user_id=:user_id AND id!=:id")->setParams(array(":user_id" => $item->user_id->id, ":id" => $item->id))->setOrderBy("col DESC")->setLimit(8))));
} else {
throw new CHttpException("Ошибка", Yii::t("page", "Ошибка перехода на страницу"));
}
} else {
throw new CHttpException("Ошибка", Yii::t("page", "Ошибка перехода на страницу"));
}
}
public function actionIndex()
{
if (!Yii::app()->user->isGuest) {
$message = "";
Yii::app()->page->title = Yii::t("user", "Избранное");
$userModel = CatalogUsers::fetch(Yii::app()->user->id);
$del = (int) Yii::app()->request->getParam("del", 0);
if ($del > 0) {
Yii::app()->favorites->delete($del, "catalog_items");
}
$list = Yii::app()->favorites->getListId("catalog=:catalog", array(":catalog" => "catalog_items"));
if (sizeof($list) > 0) {
$sql = " ( ";
foreach ($list as $key => $value) {
if ($sql != " ( ") {
$sql .= " OR ";
}
$sql .= "id='" . $value . "'";
}
$sql .= " )";
$items = CatalogItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("status_id=1")->setConditions($sql)->setCache(0));
} else {
$items = array();
}
$this->render("index", array("message" => $message, "items" => $items, "userModel" => $userModel));
}
}
/**
* 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 = "Описание продукции";
$id = (int) Yii::app()->request->getParam("id", 0);
if ($id > 0) {
$item = CatalogItems::fetchParam($id);
$otherItem = CatalogItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("id!=:id AND category_id=:cid")->setParams(array(":id" => $item->id, ":cid" => $item->category_id->id))->setOrderBy("price")->setLimit(10));
$hotItem = CatalogItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("id!=:id AND is_hot=:hot")->setParams(array(":id" => $item->id, ":hot" => 1))->setOrderBy("price")->setLimit(10));
if ($item->id > 0) {
$favorites = Yii::app()->request->getParam("favorites", "");
if ($favorites == "add") {
$res = Yii::app()->favorites->add("catalog_items", $item->id);
}
$newComment = new CatalogItemsCommentsAdd();
// Сохраняем комментарий
if (!empty($_POST["sentComment"])) {
$newComment->setAttributesFromArray($_POST["CatalogItemsCommentsAdd"]);
$newComment->date = time();
$newComment->user_id = Yii::app()->user->id;
$newComment->item_id = $id;
if ($newComment->save()) {
$newComment->formMessage = "Комментарий успешно отправлен.";
$newComment->onNewComment(new CModelEvent($newComment), array("id" => $item->id, "name" => $item->name, "subject" => $newComment->subject, "link" => SiteHelper::createUrl("/user/items/index", array("id" => $newComment->item_id))));
}
}
$listComments = CatalogItemsComments::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("item_id=:item_id AND is_valid=1")->setParams(array(":item_id" => $item->id))->setOrderBy("date DESC"));
$this->render("item", array("item" => $item, "otherItem" => $otherItem, "hotItem" => $hotItem, "addForm" => $newComment, "listComments" => $listComments));
} else {
$this->redirect("/");
}
} else {
$this->redirect("/");
}
}
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("/"));
}
}
