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