public function safeUp() { $this->execute("\n CREATE TABLE IF NOT EXISTS `Articles` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `type` int(11) NOT NULL DEFAULT 0 COMMENT 'Тип статьи, см. Articles',\n `title` text NOT NULL DEFAULT '' COMMENT 'Заголовок',\n `text` text NOT NULL DEFAULT '' COMMENT 'Текст',\n `visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Видимость',\n PRIMARY KEY (`id`),\n KEY `type` (`type`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n "); $this->execute("\n CREATE TABLE IF NOT EXISTS `Articles_lang` (\n `l_id` int(11) NOT NULL AUTO_INCREMENT,\n `articleId` int(11) NOT NULL,\n `lang_id` varchar(6) NOT NULL,\n `l_title` text NOT NULL default '',\n `l_text` text NOT NULL default '',\n PRIMARY KEY (`l_id`),\n KEY `menuId` (`articleId`),\n KEY `lang_id` (`lang_id`),\n CONSTRAINT `fk_articles_lang` FOREIGN KEY (`articleId`) REFERENCES `Articles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n "); $article = new Articles(); $article->multilang(); $attr = array_merge($this->createLangData('title', 'В разработке', 'content'), $this->createLangData('text', 'Раздел находится в разработке', 'content'), array('type' => Articles::TYPE_UNDER_CONSTRUCTION)); $article->setAttributes($attr); $article->save(); }
public function actionList_articles() { if (Yii::app()->user->isGuest) { $this->redirect($this->createAbsoluteUrl('default/index')); } $model = new Articles('search'); $model->unsetAttributes(); if (isset($_GET['Articles'])) { $model->setAttributes($_GET['Articles'], false); } $category = Categorys::getAllCategories(); $menus = Mainmenu::model()->getDropDownMenu(); $this->render('articles/list_articles', array('model' => $model, 'menus' => $menus, 'category' => $category)); }