/**
* Lists all models.
*/
public function actionIndex($value = '')
{
list($leafs) = $this->getRelData();
$criteria = new CDbCriteria();
if (isset($_GET['keyword']) || !empty($_GET['keyword']) || strlen($_GET['keyword']) > 0 || strlen($_GET['leaf_id']) > 0) {
$keyword = trim($_GET['keyword']);
$criteria->condition = 'title like :keyword ';
$criteria->params = array(':keyword' => "%{$keyword}%");
$opt['is_partial'] = true;
}
$opt['page_size'] = 20;
$leaf_id = $_GET['leaf_id'];
$is_include = $_GET['is_include'];
if (strlen($leaf_id) > 0) {
$criteria->condition .= ' AND find_in_set(category_id, :category_id)';
if ($is_include) {
$leaf = Category::model()->findbypk($leaf_id);
$leafs = Category::model()->findAll(array('select' => 'id, name', 'condition' => ' rgt <= :rgt AND lft >= :lft ', 'params' => array(':rgt' => $leaf->rgt, ':lft' => $leaf->lft)));
$all_leafs = '';
foreach ($leafs as $_leaf) {
$all_leafs .= $_leaf->id . ',';
}
$criteria->params[':category_id'] = $all_leafs;
} else {
$criteria->params[':category_id'] = $leaf_id;
}
}
$criteria->order = 'update_time DESC';
$opt['criteria'] = $criteria;
$opt['tpl_params'] = array('leafs' => $leafs);
parent::actionIndex($opt);
}
/**
* Lists all models.
*/
public function actionIndex()
{
$criteria = new CDbCriteria();
if (isset($_GET['keyword']) || !empty($_GET['keyword']) || strlen($_GET['keyword']) > 0) {
$keyword = trim($_GET['keyword']);
$criteria->condition = 'question like :keyword OR answer like :keyword';
$criteria->params = array(':keyword' => "%{$keyword}%");
$opt['is_partial'] = true;
}
$criteria->order = 'a_time DESC';
$opt['criteria'] = $criteria;
parent::actionIndex($opt);
}
/**
* Displays a particular model.
*/
public function actionView()
{
$criteria = new CDbCriteria();
$model = $this->loadModel();
$keyword = trim($_GET['keyword']);
$criteria->params = array();
$is_include = $_GET['is_include'];
$criteria->condition = ' 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' => $model->rgt, ':lft' => $model->lft)));
$all_leafs = '';
foreach ($leafs as $_leaf) {
$all_leafs .= $_leaf->id . ',';
}
$criteria->params[':category_id'] = $all_leafs;
} else {
$criteria->params[':category_id'] = $model->id;
}
if ($_GET['model_type'] == 'attachment') {
$opt['tpl'] = 'ajaxview_attachment';
$opt['controllerId'] = 'Attachment';
if (strlen($keyword) > 0) {
$criteria->condition .= " AND t.screen_name like :keyword ";
$criteria->params[':keyword'] = "%{$keyword}%";
}
} else {
$opt['tpl'] = 'ajaxview';
$opt['controllerId'] = 'Article';
if (strlen($keyword) > 0) {
$criteria->condition .= " AND t.title like :keyword ";
$criteria->params[':keyword'] = "%{$keyword}%";
}
$criteria->order = 'create_time DESC';
$criteria->order = " t.sort_id DESC ";
$opt['page_size'] = 12;
}
$opt['criteria'] = $criteria;
$opt['tpl_params']['model'] = $model;
parent::actionIndex($opt);
}
/**
* Lists all models.
*/
public function actionIndex()
{
$criteria = new CDbCriteria();
if (isset($_GET['keyword']) || !empty($_GET['keyword']) || strlen($_GET['keyword']) > 0) {
$keyword = trim($_GET['keyword']);
$criteria->condition = 'username like :keyword OR email like :keyword ';
$criteria->params = array(':keyword' => "%{$keyword}%");
$opt['is_partial'] = true;
}
$criteria->order = 'id desc';
$opt['criteria'] = $criteria;
parent::actionIndex($opt);
}
