/** * 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); }
/** * 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); }
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); }