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