public function actionPickAtt()
{
$return_id = $_GET['return_id'];
$rtype = $_GET['rtype'];
$criteria = new CDbCriteria();
if (isset($_GET['keyword'])) {
$screen_name = trim($_GET['keyword']);
$criteria->condition = 'screen_name like :screen_name';
$criteria->params = array(':screen_name' => "%{$screen_name}%");
$partial_tpl = '_att';
//$atts = Attachment::model()->findAll($criteria);
//$this->renderPartial('_att',array('return_id' => $return_id,'atts' => $atts,'rtype' => $rtype ),false,true);
} else {
$partial_tpl = 'pickatt';
//$atts = Attachment::model()->findAll();
//$this->renderPartial('pickatt',array('return_id' => $return_id,'atts' => $atts ,'rtype' => $rtype ),false,true);
}
$item_count = Attachment::model()->count($criteria);
$page_size = 10;
$pages = new CPagination($item_count);
$pages->setPageSize($page_size);
$pagination = new CLinkPager();
$pagination->cssFile = false;
$pagination->setPages($pages);
$pagination->init();
$criteria->limit = $page_size;
$criteria->offset = $pages->offset;
$select_pagination = new CListPager();
$select_pagination->htmlOptions['onchange'] = "";
$select_pagination->setPages($pages);
$select_pagination->init();
$atts = Attachment::model()->findAll($criteria);
$this->renderPartial($partial_tpl, array('return_id' => $return_id, 'atts' => $atts, 'rtype' => $rtype, 'pagination' => $pagination, 'select_pagination' => $select_pagination), false, true);
}
public function actioncxIndex()
{
//print_r( ucfirst($this->getId() ) );
//$this->actionId = $this->getAction()->getId();
$controllerId = $this->controllerId;
$criteria = new CDbCriteria();
if (isset($_GET['keyword']) || !empty($_GET['keyword']) || strlen($_GET['keyword']) > 0) {
$keyword = trim($_GET['keyword']);
$criteria->condition = 'title like :keyword ';
$criteria->params = array(':keyword' => "%{$keyword}%");
$is_partial = true;
}
$imodel = new $controllerId();
$item_count = call_user_func(array($imodel, 'count'), $criteria);
$page_size = 10;
$pages = new CPagination($item_count);
$pages->setPageSize($page_size);
$pagination = new CLinkPager();
$pagination->cssFile = false;
$pagination->setPages($pages);
$pagination->init();
$criteria->limit = $page_size;
$criteria->offset = $pages->offset;
$select_pagination = new CListPager();
$select_pagination->header = '跳转到:';
$select_pagination->htmlOptions['onchange'] = "";
$select_pagination->setPages($pages);
$select_pagination->init();
$list = call_user_func(array($imodel, 'findAll'), $criteria);
if ($is_partial) {
$this->renderPartial('_index', array('list' => $list, 'pagination' => $pagination, 'select_pagination' => $select_pagination), false, true);
} else {
$this->render('index', array('list' => $list, 'pagination' => $pagination, 'select_pagination' => $select_pagination), false, true);
}
}
/**
* Lists all models.
*/
public function actionIndex($opt = null)
{
$controllerId = strlen($opt['controllerId']) > 0 ? $opt['controllerId'] : $this->controllerId;
if (!is_array($opt)) {
$criteria = new CDbCriteria();
$keyword = trim($_GET['keyword']);
} else {
extract($opt);
}
$imodel = new $controllerId();
$item_count = call_user_func(array($imodel, 'count'), $criteria);
$page_size = strlen($opt['page_size']) > 0 ? $opt['page_size'] : 10;
$pages = new CPagination($item_count);
$pages->setPageSize($page_size);
$pagination = new CLinkPager();
$pagination->cssFile = false;
$pagination->setPages($pages);
$pagination->init();
$criteria->limit = $page_size;
$criteria->offset = $pages->offset;
$select_pagination = new CListPager();
$select_pagination->header = Yii::t('cp', 'Go to:');
$select_pagination->htmlOptions['onchange'] = "";
$select_pagination->setPages($pages);
$select_pagination->init();
$list = call_user_func(array($imodel, 'findAll'), $criteria);
if (!is_array($opt['tpl_params'])) {
$opt['tpl_params'] = array();
}
$opt['tpl_params']['list'] = $list;
$opt['tpl_params']['pagination'] = $pagination;
$opt['tpl_params']['select_pagination'] = $select_pagination;
// echo Chtml::listBox('category_id',1,$leafs)
//print_r($opt['tpl_params']);
if ($is_partial) {
$this->renderPartial('_index', $opt['tpl_params'], false, true);
} else {
$tpl = strlen($opt['tpl']) > 0 ? $opt['tpl'] : 'index';
if ($_GET['ajax'] == 'ajax') {
$this->renderPartial($tpl, $opt['tpl_params'], false, true);
} else {
$this->render($tpl, $opt['tpl_params'], false, true);
}
}
}
public function actionPhotos()
{
$criteria = new CDbCriteria();
$criteria->condition = 'user_id = :user_id';
$criteria->params = array(':user_id' => User()->id);
$criteria->order = 'c_time DESC';
if (isset($_GET['keyword'])) {
$partial_tpl = '_photos';
} else {
$partial_tpl = 'photos';
}
$item_count = Attachment::model()->count($criteria);
$pages = new CPagination($item_count);
$pages->setPageSize($page_size);
$pagination = new CLinkPager();
$pagination->cssFile = false;
$pagination->setPages($pages);
$pagination->init();
$criteria->limit = 6;
$criteria->offset = $pages->offset;
$select_pagination = new CListPager();
$photos = Attachment::model()->findAll($criteria);
$this->renderPartial($partial_tpl, array('photos' => $photos, 'pagination' => $pagination, 'select_pagination' => $select_pagination), false, true);
}
public function actionAPIx()
{
$item_count = 32;
$page_size = 2;
$pages = new CPagination($item_count);
//$pages->pageVar = 'iook=8&ok';
//$pages->createPageUrl(CController::createUrl('blog/index',$pages) );
$pages->setPageSize($page_size);
// simulate the effect of LIMIT in a sql query
//$end =($pages->offset+$pages->limit <= $item_count ? $pages->offset+$pages->limit : $item_count);
//$sample =range($pages->offset+1, $end);
$pagination = new CLinkPager();
//print_r("<pre>");
//print_r($pagination);
//print_r("</pre>");
//$pages->pageVar='stat='.$_GET[stat]."&page";
$pagination->setPages($pages);
$pagination->init();
$pagination->run();
print_r("--");
print_r($pages->offset);
print_r("--");
$pagination = new CListPager();
$pages->pageVar = 'ioof';
$pagination->setPages($pages);
$pagination->init();
$pagination->run();
exit;
echo 'find id=2 essay <br>';
echo '<pre>';
$a = API::essay(array('id' => '2'));
$a->print;
echo 'find id=2,3,4 essay <br>';
$a = API::essay(array('id' => ',1,2,3,4,5,6,7,,8,,9,0,0,-,-,,,,r,r,r,w,,3,2,3'));
foreach ($a as $t) {
print_r("<hr>");
$t->print;
}
echo '</pre>';
exit;
}
public function essays($opt = null)
{
$include = empty($opt['include']) ? false : true;
$split = empty($opt['split']) ? false : true;
$order = empty($opt['order']) ? ' id DESC ' : $opt['order'];
if ($include) {
$ids = $this->sub_nodes();
$criteria = new CDbCriteria();
$criteria->condition = 'find_in_set(category_id,:ids)';
$criteria->order = $order;
$criteria->params = array(':ids' => $ids);
if ($split) {
$item_count = Article::model()->count($criteria);
$page_size = 2;
$pages = new CPagination($item_count);
$pages->setPageSize($page_size);
$pagination = new CLinkPager();
$pagination->setPages($pages);
$pagination->init();
//$pagination->run(); // display the html pagination
$criteria->limit = $page_size;
$criteria->offset = $pages->offset;
$articles = Article::model()->findall($criteria);
} else {
$articles = Article::model()->findall($criteria);
}
} else {
$articles = $this->articles;
}
if ($split) {
return array($articles, $pagination);
} else {
return $articles;
}
}
/**
* Lists all models.
*/
public function actionIndex($opt = null)
{
$controllerId = strlen($opt['controllerId']) > 0 ? $opt['controllerId'] : $this->controllerId;
if (!is_array($opt)) {
$criteria = new CDbCriteria();
$keyword = trim($_GET['keyword']);
} else {
extract($opt);
}
if (isset($_GET['id_start']) && !empty($_GET['id_start'])) {
$criteria->condition .= " AND id >= :id_start ";
$criteria->params[':id_start'] =& $_GET['id_start'];
$tpl_params['id_start'] =& $_GET['id_start'];
}
if (isset($_GET['id_end']) && !empty($_GET['id_end'])) {
$criteria->condition .= " AND id <= :id_end ";
$criteria->params[':id_end'] =& $_GET['id_end'];
$tpl_params['id_end'] =& $_GET['id_end'];
}
//if( isset($_GET['account_type']) && !empty($_GET['account_type']) ) {
if (strlen($_GET['account_type']) > 0) {
$criteria->condition .= " AND account_type = :account_type ";
$criteria->params[':account_type'] =& str_replace('.html', '', $_GET['account_type']);
$tpl_params['account_type'] =& str_replace('.html', '', $_GET['account_type']);
}
$tpl_params['is_hide_adv'] =& $_GET['is_hide_adv'];
$imodel = new $controllerId();
$item_count = call_user_func(array($imodel, 'count'), $criteria);
$page_size = strlen($opt['page_size']) > 0 ? $opt['page_size'] : 10;
$pages = new CPagination($item_count);
$pages->setPageSize($page_size);
$pagination = new CLinkPager();
$pagination->header = '';
$pagination->cssFile = false;
$pagination->setPages($pages);
$pagination->init();
$criteria->limit = $page_size;
$criteria->offset = $pages->offset;
$select_pagination = new CListPager();
$select_pagination->header = '<span>跳到:</span>';
// $select_pagination->htmlOptions['onchange']="";
$select_pagination->setPages($pages);
$select_pagination->init();
$list = call_user_func(array($imodel, 'findAll'), $criteria);
if (!is_array($opt['tpl_params'])) {
$opt['tpl_params'] = array();
}
$opt['tpl_params']['item_count'] = '第 <span class="fwB">' . ($page_size * $pagination->currentPage + 1) . ' - ' . $page_size * ($pagination->currentPage + 1);
$opt['tpl_params']['item_count'] .= '</span>，共 <span class="fwB" >' . $item_count . '</span> 条 ';
$opt['tpl_params']['list'] = $list;
$opt['tpl_params']['pagination'] = $pagination;
$opt['tpl_params']['select_pagination'] = $select_pagination;
// echo Chtml::listBox('category_id',1,$leafs)
//print_r($opt['tpl_params']);
$this->tpl_params =& $tpl_params;
if ($is_partial) {
$this->renderPartial('_index', $opt['tpl_params'], false, true);
} else {
$tpl = strlen($opt['tpl']) > 0 ? $opt['tpl'] : 'index';
if ($_GET['ajax'] == 'ajax') {
$this->renderPartial($tpl, $opt['tpl_params'], false, true);
} else {
$this->render($tpl, $opt['tpl_params'], false, true);
}
}
}
public static function essay($opt)
{
$order = empty($opt['order']) ? ' id DESC ' : $opt['order'];
if (is_array($opt)) {
if (!empty($opt['id'])) {
$id = $opt['id'];
if (strpos($id, ',') === false) {
return Article::model()->findbyPk($id);
} else {
$criteria = new CDbCriteria();
$criteria->condition = 'find_in_set(id, :id)';
$criteria->params = array(':id' => $id);
$criteria->order = $order;
$item_count = Article::model()->count($criteria);
$page_size = 2;
$pages = new CPagination($item_count);
//$pages->pageVar = 'iook=8&ok';
$pages->setPageSize($page_size);
$pagination = new CLinkPager();
$pagination->setPages($pages);
$pagination->init();
//$pagination->run(); // display the html pagination
$criteria->limit = $page_size;
$criteria->offset = $pages->offset;
//print_r($page_size);
//print_r($pages->offset);
$list = Article::model()->findall($criteria);
return array($list, $pagination);
}
} else {
if (!empty($opt['ident'])) {
$ident = $opt['ident'];
if (strpos($id, ',') === false) {
return Article::model()->find(array('condition' => ' ident =:ident ', 'params' => array('ident' => $ident)));
} else {
return Article::model()->findall(array('condition' => 'find_in_set(ident, :ident)', 'params' => array(':ident' => $ident), 'order' => $order));
}
}
}
} else {
echo "ERROR PHP File:" . dirname(__FILE__) . '/API.php';
echo "ERROR Fuction essay";
exit;
}
}
