/** * Lists all models. */ public function actionIndex() { $criteria = new CDbCriteria(); $criteria->condition = ' 1=1 '; if (isset($_GET['keyword']) || !empty($_GET['keyword']) || strlen($_GET['keyword']) > 0) { $keyword = trim($_GET['keyword']); $criteria->condition .= ' AND question like :keyword '; $criteria->params = array(':keyword' => "%{$keyword}%"); $opt['tpl_params']['keyword'] = $_REQUEST['keyword']; } $criteria->order = 'a_time DESC'; $_is_answer =& str_replace('.html', '', $_GET['is_answer']); $opt['tpl_params']['is_answer'] =& $_is_answer; if ($_is_answer == "1") { $criteria->condition .= " AND answer != '' "; } elseif ($_is_answer == "0") { $criteria->condition .= " AND answer = '' "; } $opt['criteria'] = $criteria; parent::actionIndex($opt); }
public function url($controller = '', $action = '', $params = array()) { return GController::instance()->url($controller, $action, $params); }
/** * Lists all models. */ public function actionIndex() { $criteria = new CDbCriteria(); $criteria->condition = ' 1=1 '; if (isset($_REQUEST['keyword']) || !empty($_REQUEST['keyword']) || strlen($_REQUEST['keyword']) > 0) { $keyword = trim($_REQUEST['keyword']); $criteria->condition .= ' AND ( username like :keyword OR email like :keyword )'; $criteria->params = array(':keyword' => "%{$keyword}%"); //$opt['is_partial'] = true; $keyword = $opt['tpl_params']['keyword'] =& $_REQUEST['keyword']; } $criteria->order = 'id desc'; $opt['criteria'] = $criteria; parent::actionIndex($opt); }
<?php foreach (CActiveRecord::model(Yii::import($this->model))->relations() as $key => $relation) { if ($relation[0] == 'CManyManyRelation' || $relation[0] == 'CHasManyRelation') { $model = CActiveRecord::model($relation[1]); if (!($pk = $model->tableSchema->primaryKey)) { $pk = 'id'; } $suggestedtitle = $this->suggestName($model->tableSchema->columns); echo '<h2>'; echo "<?php echo CHtml::link(Yii::t('app','{relation}',array('{relation}'=>'" . ucfirst($key) . "')), array('" . GController::resolveRelationController($relation) . "/admin'));?>"; echo "</h2>\n"; echo CHtml::openTag('ul'); echo "<?php if (is_array(\$model->{$key})) foreach(\$model->{$key} as \$foreignobj) { \n\r\n\t\t\t\t\techo '<li>';\r\n\t\t\t\t\techo CHtml::link(\r\n\t\t\t\t\t\t\$foreignobj->{$suggestedtitle->name}?\$foreignobj->{$suggestedtitle->name}:\$foreignobj->{$pk},\r\n\t\t\t\t\t\tarray('" . GController::resolveRelationController($relation) . "/view', 'id' => \$foreignobj->{$pk}));\n\r\n\t\t\t\t\t}; ?>"; echo CHtml::closeTag('ul'); echo "<p><?php echo CHtml::link(\r\n\t\t\t\tYii::t('app','Create'),\r\n\t\t\t\tarray('" . GController::resolveRelationController($relation) . "/create', '{$relation['1']}' => array('{$relation['2']}'=>\$model->id))\r\n\t\t\t\t); ?></p>"; } if ($relation[0] == 'CHasOneRelation') { $model = CActiveRecord::model($relation[1]); if (!($pk = $model->tableSchema->primaryKey)) { $pk = 'id'; } $suggestedtitle = $this->suggestName($model->tableSchema->columns); echo '<h2>'; echo "<?php echo CHtml::link(Yii::t('app','{relation}',array('{relation}'=>'" . $relation[1] . "')),'/\$this->resolveRelationController(\$relation)/admin');?>"; echo "</h2>\n"; echo CHtml::openTag('ul'); echo "<?php \$foreignobj = \$model->{$key}; \n\r\n\t\t\t\t\tif (\$foreignobj !== null) {\r\n\t\t\t\t\techo '<li>';\r\n\t\t\t\t\techo CHtml::link(\r\n\t\t\t\t\t\t\$foreignobj->{$suggestedtitle->name}?\$foreignobj->{$suggestedtitle->name}:\$foreignobj->{$pk},\r\n\t\t\t\t\t\tarray('\$this->resolveRelationController(\$relation)/view', 'id' => \$foreignobj->{$pk}));\n\r\n\t\t\t\t\t} ?>"; echo CHtml::closeTag('ul'); echo "<p><?php if(\$model->{$key} === null) echo CHtml::link(\r\n\t\t\t\tYii::t('app','Create'),\r\n\t\t\t\tarray('" . GController::resolveRelationController($relation) . "/create', '{$relation['1']}' => array('{$relation['2']}'=>\$model->{\$model->tableSchema->primaryKey}))\r\n\t\t\t\t); ?></p>"; } }
public function actionIndex($top_leaf_id = '', $cur_leaf_id = '') { // fetch top leaf if (strlen($top_leaf_id) > 0) { $top_leaf = Category::model()->findByPk($top_leaf_id); } else { $top_leaf = Category::model()->findByPk(1); } // fetch current leaf if (strlen(trim($cur_leaf_id)) > 0) { $cur_leaf = $category = Category::model()->findByPk($cur_leaf_id); } else { $cur_leaf_id = strlen($_GET['category_id']) > 0 ? $_GET['category_id'] : 1; $cur_leaf = $category = Category::model()->findByPk($cur_leaf_id); } $this->path = Category::model()->getPath($cur_leaf_id, $top_leaf->id); $criteria = new CDbCriteria(); $criteria->condition = " 1=1 "; if (isset($_GET['keyword']) || !empty($_GET['keyword']) || strlen($_GET['keyword']) > 0 || strlen($_GET['leaf_id']) > 0) { $keyword = trim($_GET['keyword']); $criteria->condition .= ' AND title like :keyword '; $criteria->params = array(':keyword' => "%{$keyword}%"); $opt['tpl_params']['keyword'] =& $_REQUEST['keyword']; } $opt['page_size'] = 15; // $is_include = $_GET['is_include']; $is_include = true; if (strlen($cur_leaf_id) > 0) { $mul_category = ManyCategoryArticle::model()->findAllByAttributes(array('category_id' => $cur_leaf->id)); $all_articles = ''; foreach ($mul_category as $_mc) { $all_articles .= $_mc->article_id . ','; } $criteria->condition .= ' AND find_in_set(category_id, :category_id) '; if ($all_articles != '') { $criteria->condition .= ' OR find_in_set(id,:all_articles)'; $criteria->params[':all_articles'] = $all_articles; } if ($is_include) { $leafs = Category::model()->findAll(array('select' => 'id, name', 'condition' => ' rgt <= :rgt AND lft >= :lft ', 'params' => array(':rgt' => $cur_leaf->rgt, ':lft' => $cur_leaf->lft))); $all_leafs = ''; foreach ($leafs as $_leaf) { $all_leafs .= $_leaf->id . ','; } $criteria->params[':category_id'] = $all_leafs; } else { $criteria->params[':category_id'] = $cur_leaf_id; } } $_is_star =& str_replace('.html', '', $_GET['is_star']); if ($_is_star == 0) { $criteria->condition .= " AND is_star = 0 "; } elseif ($_is_star == 1) { $criteria->condition .= " AND is_star = 1 "; } $opt['tpl_params']['is_star'] = $_is_star; $criteria->order = 'update_time DESC'; $opt['criteria'] = $criteria; $leaf_tree =& $this->getTree($top_leaf_id); $opt['tpl_params']['top_leaf'] = $top_leaf; $opt['tpl_params']['cur_leaf'] = $cur_leaf; $opt['tpl_params']['leaf_tree'] = $leaf_tree; // $opt['tpl_params'] = array( 'top_leaf' => $top_leaf, 'cur_leaf' => $cur_leaf, 'leaf_tree' => $leaf_tree ); parent::actionIndex($opt); }
public function actionIndex($top_leaf_id = '', $cur_leaf_id = '') { //fetch top leaf if (strlen($top_leaf_id) == 0) { $top_leaf_id = 30; } $top_leaf = Category::model()->findByPk($top_leaf_id); //fetch current leaf if (strlen($cur_leaf_id) == 0) { $cur_leaf_id = $_GET['category_id'] ? $_GET['category_id'] : 30; } $cur_leaf = Category::model()->findByPk($cur_leaf_id); $this->path = Category::model()->getPath($cur_leaf_id, $top_leaf->id); $criteria = new CDbCriteria(); $criteria->condition = " 1=1 "; if (isset($_GET['keyword']) || !empty($_GET['keyword']) || strlen($_GET['keyword']) > 0 || strlen($_GET['leaf_id']) > 0) { $keyword = trim($_GET['keyword']); $criteria->condition .= ' AND screen_name like :keyword '; $criteria->params = array(':keyword' => "%{$keyword}%"); $opt['tpl_params']['keyword'] =& $_REQUEST['keyword']; } $opt['page_size'] = 20; $is_include = true; if (strlen($cur_leaf_id) > 0) { $criteria->condition .= ' AND find_in_set(category_id, :category_id)'; if ($is_include) { $leafs = Category::model()->findAll(array('select' => 'id, name', 'condition' => ' rgt <= :rgt AND lft >= :lft ', 'params' => array(':rgt' => $cur_leaf->rgt, ':lft' => $cur_leaf->lft))); $all_leafs = ''; foreach ($leafs as $_leaf) { $all_leafs .= $_leaf->id . ','; } $criteria->params[':category_id'] = $all_leafs; } else { $criteria->params[':category_id'] = $cur_leaf_id; } } $_ext =& str_replace('.html', '', $_GET['ext']); $opt['tpl_params']['ext'] =& $_ext; if ($_ext == "image") { $criteria->condition .= " AND find_in_set(extension,'jpg,jpeg,png,gif') "; } $criteria->order = ' c_time DESC '; $leaf_tree =& $this->getTree($top_leaf_id); $opt['criteria'] = $criteria; $opt['tpl_params']['top_leaf'] =& $top_leaf; $opt['tpl_params']['cur_leaf'] =& $cur_leaf; $opt['tpl_params']['leaf_tree'] =& $leaf_tree; parent::actionIndex($opt); }
public static function instance($model = null) { if (self::$instance) { if ($model) { self::$instance->model = $model; } return self::$instance; } self::$instance = new GController($model); return self::$instance; }