/** * This function generates the products grid * based on the criteria. It also generates the * pagination object need for the users to navigate * through products. * * @return void */ public function generateProductGrid() { $this->_numberOfRecords = Product::model()->count($this->_productGridCriteria); $this->_pages = new CPagination($this->_numberOfRecords); $this->_pages->setPageSize(CPropertyValue::ensureInteger(Yii::app()->params['PRODUCTS_PER_PAGE'])); $this->_pages->applyLimit($this->_productGridCriteria); $this->_productsGrid = self::createBookends(Product::model()->findAll($this->_productGridCriteria)); }
public function actionPosts($name) { $tag = urldecode($name); $this->setSiteTitle(t('tag_posts', 'main', array('{name}' => $tag))); // @todo 关键字的描述没有指定 $this->setPageKeyWords($tag); $this->setPageDescription(t('tag_posts_page_description', 'main', array('{name}' => $tag))); cs()->registerMetaTag('all', 'robots'); $cmd = app()->getDb()->createCommand()->select('p.id')->from(TABLE_TAG . ' t')->where('t.name = :tagname', array(':tagname' => $tag))->join(TABLE_POST_TAG . ' pt', 'pt.tag_id = t.id')->join(TABLE_POST . ' p', 'p.id = pt.post_id'); $ids = $cmd->queryColumn(); if (count($ids) > 0) { $criteria = new CDbCriteria(); if (param('post_list_type') == POST_LIST_TYPE_TITLE) { $criteria->select = array('t.id', 't.title', 't.visit_nums', 't.comment_nums', 't.create_time'); } $criteria->order = 't.istop, t.create_time desc, t.id desc'; $criteria->addInCondition('t.id', $ids)->addCondition('t.state = :state'); $criteria->params += array(':state' => POST_STATE_ENABLED); $count = Post::model()->count($criteria); $pages = new CPagination($count); $pages->setPageSize(param('postCountOfTitleListPage')); $pages->applyLimit($criteria); $posts = Post::model()->findAll($criteria); } $listType = param('post_list_type'); $view = $listType == POST_LIST_TYPE_SUMMARY ? '/post/_summary_list' : '/post/_title_list'; $blockTitle = t('tag_posts', 'main', array('{name}' => $tag)); $data = array('blockTitle' => $blockTitle, 'posts' => $posts, 'pages' => $pages); $postListHtml = $this->renderPartial($view, $data, true); $this->render('posts', array('postListHtml' => $postListHtml)); }
public function actionPersonnel() { if (isset($_GET['id'])) { $model = $this->loadPersonnelModel($_GET['id']); $this->render('personnel_detail', array('model' => $model)); } else { if (isset($_GET['type_id'])) { $type_id = $_GET['type_id']; $type = PersonnelType::model()->findByPk($_GET['type_id']); $criteria = new CDbCriteria(); $criteria->condition = 'status = 1 AND personnel_type_id =' . $type_id; $criteria->order = 'sort_order'; $total = Personnel::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(10); $pages->applyLimit($criteria); $model = Personnel::model()->findAll($criteria); $this->render('personnel', array('model' => $model, 'type' => $type, 'pages' => $pages)); } else { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1'; $criteria->order = 'sort_order'; $total = Personnel::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(10); $pages->applyLimit($criteria); $model = Personnel::model()->findAll($criteria); $this->render('personnel', array('model' => $model, 'pages' => $pages)); } } }
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); } }
public function actionIndex($id = null) { if (!empty($this->arrSystem)) { $this->pageTitle = "Hình ảnh - " . $this->arrSystem->title; } $criteria = new CDBCriteria(); $title = ""; if ($id == null) { $criteria->addCondition("is_product = 1"); $title = "Hình ảnh hoạt động"; } else { if ($id == 2) { $criteria->addCondition("is_product = 2"); $title = "Sản phẩm mới"; } else { throw new CHttpException(404, 'Không tìm thấy trang!.'); } } $countItem = Slides::model()->count($criteria); $pages = new CPagination($countItem); $pages->setPageSize(12); $pages->applyLimit($criteria); $arrNew = Slides::model()->findAll($criteria); $arrImage = Slides::model()->findALl($criteria); $this->render("index", array('arrImage' => $arrImage, 'item_count' => $countItem, 'page_size' => 12, 'pages' => $pages, 'title' => $title)); }
public function actionList() { $_default_item_perpage = 10; if (isset($_GET['limit']) && (int) $_GET['limit'] > 0) { Yii::app()->session['current'] = $_GET['limit']; $_default_item_perpage = Yii::app()->session['current']; } else { if (isset(Yii::app()->session['current'])) { $_default_item_perpage = Yii::app()->session['current']; } else { Yii::app()->session['current'] = $_default_item_perpage; } } $criteria = new CDbCriteria(); $criteria->addCondition('current=1 AND web=1'); $q = Yii::app()->getRequest()->getQuery('q'); if ($q) { $criteria->addCondition('`title` LIKE "%' . $q . '%" OR `code` LIKE "%' . $q . '%" OR `description_short` LIKE "%' . $q . '%"'); } $criteria->order = _xls_get_sort_order(); $item_count = Product::model()->count($criteria); $pages = new CPagination($item_count); $pages->setPageSize($_default_item_perpage); $pages->applyLimit($criteria); $model = Product::model()->findAll($criteria); $this->render('list', array('model' => $model, 'item_count' => $item_count, 'page_size' => $_default_item_perpage, 'items_count' => $item_count, 'pages' => $pages)); }
/** * Action for the members section of the directory * * @todo Dont pass lucene hits to view, build user array inside of action */ public function actionMembers() { $details = Yii::app()->db->createCommand()->select('companyname, username, firstname, lastname, title, guid')->from('user, profile')->where('user.id=profile.user_id and group_id=3')->order('companyname')->queryAll(); $companycount = Yii::app()->db->createCommand()->select('count(distinct(companyname)) as count')->from('profile')->where('companyname not like \'student\'')->order('companyname')->queryAll(); $item_count = (int) $companycount[0]["count"]; $page_size = (int) $companycount[0]["count"]; $pages = new CPagination($item_count); $pages->setPageSize($page_size); $end = $pages->offset + $pages->limit <= $item_count ? $pages->offset + $pages->limit : $item_count; $sample = array(); $y = ""; $i = 0; $j = 0; foreach ($details as $x) { if ($x["companyname"] != $y) { $sample[$i++] = array('cname' => $x["companyname"], 'detail' => array()); $j = 0; } $sample[$i - 1]["detail"][$j++] = $x; $y = $x["companyname"]; } $pg_content = array(); for ($i = $pages->offset; $i < $end; $i++) { $pg_content[$i] = $sample[$i]; } $this->render('members', array('item_count' => $item_count, 'page_size' => $page_size, 'items_count' => $item_count, 'pages' => $pages, 'sample' => $pg_content)); }
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 actionIndex() { if (isset($_GET['type_id'])) { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1 AND report_type_id =' . $_GET['type_id']; $criteria->order = 'sort_order'; $total = Report::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(20); $pages->applyLimit($criteria); $model = Report::model()->findAll($criteria); $type = ReportType::model()->findByPK($_GET['type_id']); $this->render('index', array('model' => $model, 'type' => $type, 'pages' => $pages)); } else { if (isset($_GET['id'])) { $model = Report::model()->findByPk($_GET['id']); $this->render('detail', array('model' => $model)); } else { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1'; $criteria->order = 'sort_order'; $total = Report::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(20); $pages->applyLimit($criteria); $model = Report::model()->findAll($criteria); $this->render('index', array('model' => $model, 'pages' => $pages)); } } }
public function actionTag() { $data = array(); $alias = urlGETParams('alias'); $query = "SELECT * FROM tbl_tags_youtube WHERE alias = :alias"; $values = array(':alias' => $alias); $row = $this->db->createCommand($query)->bindValues($values)->queryRow(); if (empty($row)) { $this->redirect($this->createUrl('video/index')); } $data['row'] = $row; $tag_id = $row['id']; $where = " AND tags LIKE '%," . $tag_id . ",%' "; $query_count = "SELECT COUNT(id) FROM tbl_youtube WHERE 1 " . $where; $item_count = $this->db->createCommand($query_count)->queryScalar(); $pages = new CPagination($item_count); $perPage = 30; $pages->setPageSize($perPage); $page = isset($_GET['page']) ? intval($_GET['page']) : 0; if ($page <= 0) { $page = 1; } $offset = ($page - 1) * $perPage; $query = "SELECT * FROM tbl_youtube WHERE 1 " . $where . " " . " ORDER BY id DESC " . "LIMIT " . $offset . "," . $perPage; $data['listVideo'] = $this->db->createCommand($query)->queryAll(); $title = $data['row']['name'] . ' videos'; if ($page > 1) { $title .= ' - page ' . $page; } $this->_meta = array('title' => $title . ' - Techz24', 'description' => 'All videos in topic . ' . $data['row']['name'] . ' on Techz24'); $this->_style_class = 'page right-sidebar singular fade-imgs-in-appear one-side-wide both-sidebars archive-page'; $this->render('tag', array('data' => $data, 'item_count' => $item_count, 'page_size' => $perPage, 'pages' => $pages)); }
public function search($begin, $end) { $condition = 'time>=:begin AND time<=:end'; $params = ['begin' => $begin, 'end' => $end]; $model = Logging::model(); $pager = new CPagination($model->count($condition, $params)); $pager->setPageSize(100); $logging = $model->findAll(['condition' => $condition, 'params' => $params, 'offset' => $pager->getOffset(), 'limit' => $pager->getLimit(), 'order' => 'time desc']); $this->render('index', ['logging' => new RedArrayDataProvider($logging), 'pager' => $pager]); }
public function actionIndex() { $criteria = new CDbCriteria(); $criteria->order = 'id DESC'; if ($_GET['find']) { if ($_GET['activity_type'] != NULL and $_GET['start_date'] == NULL and $_GET['end_date'] == NULL) { $type = $_GET['activity_type']; $criteria->condition = 'activity_type LIKE :type'; $criteria->params[':type'] = $type; } elseif ($_GET['activity_type'] == NULL and $_GET['start_date'] != NULL and $_GET['end_date'] != NULL) { $start_date = date('Y-m-d', strtotime($_GET['start_date'])); $end_date = date('Y-m-d', strtotime($_GET['end_date'])); if ($start_date == $end_date) { $criteria->condition = 'DATE(activity_time) LIKE :date'; $criteria->params[':date'] = $start_date; } else { $criteria->condition = 'DATE(activity_time) BETWEEN :start_date AND :end_date'; $criteria->params[':start_date'] = $start_date; $criteria->params[':end_date'] = $end_date; } } elseif ($_GET['activity_type'] == NULL and $_GET['start_date'] != NULL and $_GET['end_date'] == NULL) { $start_date = date('Y-m-d', strtotime($_GET['start_date'])); $criteria->condition = 'DATE(activity_time) >= :date'; $criteria->params[':date'] = $start_date; } elseif ($_GET['activity_type'] == NULL and $_GET['start_date'] == NULL and $_GET['end_date'] != NULL) { $end_date = date('Y-m-d', strtotime($_GET['end_date'])); $criteria->condition = 'DATE(activity_time) <= :date'; $criteria->params[':date'] = $end_date; } elseif ($_GET['activity_type'] != NULL and $_GET['start_date'] != NULL and $_GET['end_date'] != NULL) { $type = $_GET['activity_type']; $start_date = date('Y-m-d', strtotime($_GET['start_date'])); $end_date = date('Y-m-d', strtotime($_GET['end_date'])); $criteria->condition = 'activity_type LIKE :type'; $criteria->params[':type'] = $type; if ($start_date == $end_date) { $criteria->condition = $criteria->condition . ' AND DATE(activity_time) LIKE :date'; $criteria->params[':date'] = $start_date; } else { $criteria->condition = $criteria->condition . ' AND DATE(activity_time) BETWEEN :start_date AND :end_date'; $criteria->params[':start_date'] = $start_date; $criteria->params[':end_date'] = $end_date; } } } $total = ActivityFeed::model()->count($criteria); // Count feeds $pages = new CPagination($total); $pages->setPageSize(Yii::app()->params['listPerPage']); $pages->applyLimit($criteria); $feeds = ActivityFeed::model()->findAll($criteria); // Get feeds /*echo $pages->getCurrentPage().'-'.$pages->getPageCount().'---'.count($feeds).'....'; echo $total;exit;*/ $this->render('index', array('feeds' => $feeds, 'type' => $type, 'start_date' => $_GET['start_date'], 'end_date' => $_GET['end_date'], 'pages' => $pages, 'criteria' => $criteria)); }
public function actionHlist() { $this->layout = '//layouts/blank'; $criteria = Advertisement::model()->setFetchCondition(); $count = Advertisement::model()->count($criteria); $pagination = new CPagination($count); $pagination->setPageSize(15); $pagination->applyLimit($criteria); $dataProvider = Advertisement::model()->findAll($criteria); $this->render('hlist', array('model' => $model, 'dataProvider' => $dataProvider, 'pagination' => $pagination)); }
public function actionBasicPager() { $item_count = 32; $page_size = 5; $pages = new CPagination($item_count); $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); $this->render('basic_pager', array('item_count' => $item_count, 'page_size' => $page_size, 'items_count' => $item_count, 'pages' => $pages, 'sample' => $sample)); }
/** * Constructor. * @param CDataProvider $dataProvider the data provider to iterate over * @param integer $pageSize pageSize to use for iteration. This is the number of objects loaded into memory at the same time. */ public function __construct(CDataProvider $dataProvider, $pageSize = null) { $this->_dataProvider = $dataProvider; $this->_totalItemCount = $dataProvider->getTotalItemCount(); if (($pagination = $this->_dataProvider->getPagination()) === false) { $this->_dataProvider->setPagination($pagination = new CPagination()); } if ($pageSize !== null) { $pagination->setPageSize($pageSize); } }
/** * Page which shows all people */ public function actionPeople() { $criteria = new CDbCriteria(); //$criteria->condition = 'visibility != '.Space::VISIBILITY_NONE; $criteria->order = 'firstname ASC'; $userCount = User::model()->count($criteria); $pages = new CPagination($userCount); $pages->setPageSize(HSetting::Get('paginationSize')); $pages->applyLimit($criteria); // the trick is here! $users = User::model()->findAll($criteria); $this->render('people', array('users' => $users, 'pages' => $pages, 'userCount' => $userCount, 'pageSize' => HSetting::Get('paginationSize'))); }
private static function fetchTopicPosts($tid) { $criteria = new CDbCriteria(); $criteria->order = 't.state desc, t.create_time desc, t.id desc'; $criteria->limit = param('postCountOfPage'); $criteria->addColumnCondition(array('topic_id' => $tid))->addCondition('t.state != :state'); $count = Post::model()->count($criteria, array(':state' => Post::STATE_DISABLED)); $pages = new CPagination($count); $pages->setPageSize(param('postCountOfPage')); $pages->applyLimit($criteria); $posts = Post::model()->with('category', 'topic')->findAll($criteria, array(':state' => Post::STATE_DISABLED)); return array('posts' => $posts, 'pages' => $pages); }
public function actionGroup3() { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1 AND know_group=3'; $criteria->order = 'sort_order'; $total = Knowledge::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(20); $pages->applyLimit($criteria); $model = Knowledge::model()->findAll($criteria); $this->render('index', array('model' => $model, 'pages' => $pages)); }
private function view() { $query = $this->request->getPost('Setting', []); $model = Setting::model(); $model->attributes = $query; $condition = $this->createSearchCriteria($query); $pager = new CPagination($model->count($condition)); $pager->setPageSize(20); $condition['offset'] = $pager->getOffset(); $condition['limit'] = $pager->getLimit(); $data = $model->findAll($condition); $this->render('setting', ['data' => new RedArrayDataProvider($data), 'pager' => $pager, 'model' => $model]); }
public function actionIndex() { if (Yii::app()->user->isGuest) { $this->redirect('/'); } $criteria = new CDbCriteria(); $criteria->order = 'update_time DESC'; $item_count = SupportTicket::model()->count($criteria); $pages = new CPagination($item_count); $pages->setPageSize(Yii::app()->params['defaultListPerPage']); $pages->applyLimit($criteria); // the trick is here! $this->render('index', array('model' => SupportTicket::model()->findAll($criteria), 'item_count' => $item_count, 'page_size' => Yii::app()->params['defaultListPerPage'], 'items_count' => $item_count, 'pages' => $pages)); }
public function actionBilling() { $query = ['uid' => $this->user->getId()]; $model = Traffic::model(); $model->attributes = $query; $condition = ['condition' => 'uid=:uid', 'params' => ['uid' => $query['uid']]]; $pager = new CPagination($model->count($condition)); $pager->setPageSize(20); $condition['offset'] = $pager->getOffset(); $condition['limit'] = $pager->getLimit(); $condition['order'] = 'date desc'; $data = $model->findAll($condition); $this->render('billing', ['data' => new RedArrayDataProvider($data), 'pager' => $pager]); }
public function run() { $query = $this->request->getQuery('Service', []); $model = Service::model(); $model->attributes = $query; $condition = $this->createSearchCriteria($query); $pager = new CPagination($model->count($condition)); $pager->setPageSize(20); $condition['offset'] = $pager->getOffset(); $condition['limit'] = $pager->getLimit(); $condition['order'] = 'status asc, uid asc'; $data = $model->findAll($condition); $this->render('pac', ['data' => new RedArrayDataProvider($data), 'pager' => $pager, 'model' => $model]); }
public function fetchAllByPage($condition, $pageSize = 0) { $conditionArray = array("condition" => $condition, "order" => "addtime DESC"); $criteria = new CDbCriteria(); foreach ($conditionArray as $key => $value) { $criteria->{$key} = $value; } $count = $this->count($criteria); $pagination = new CPagination($count); $everyPage = empty($pageSize) ? Ibos::app()->params["basePerPage"] : $pageSize; $pagination->setPageSize(intval($everyPage)); $pagination->applyLimit($criteria); $reportList = $this->fetchAll($criteria); return array("pagination" => $pagination, "data" => $reportList); }
public function actionIndex() { $pageSize = 10; $criteria = new CDbCriteria(); //$criteria->condition = 'collumnName1 = :id'; $criteria->order = 'id DESC'; //$criteria->params = array(':id' => $id); $itemCount = Logging::model()->count($criteria); $pagination = new CPagination($itemCount); $pagination->setPageSize($pageSize); $pagination->applyLimit($criteria); // the trick is here! $logEntries = Logging::model()->findAll($criteria); $this->render('index', array('entries' => $logEntries, 'itemCount' => $itemCount, 'pageSize' => $pageSize, 'pagination' => $pagination)); }
public function fetchAllAndPage($conditions = "", $pageSize = null) { $conditionArray = array("condition" => $conditions, "order" => "istop DESC,toptime ASC,addtime DESC"); $criteria = new CDbCriteria(); foreach ($conditionArray as $key => $value) { $criteria->{$key} = $value; } $count = $this->count($criteria); $pages = new CPagination($count); $everyPage = is_null($pageSize) ? Yii::app()->params["basePerPage"] : $pageSize; $pages->setPageSize(intval($everyPage)); $pages->applyLimit($criteria); $datas = $this->fetchAll($criteria); return array("pages" => $pages, "datas" => $datas); }
private static function fetchCategoryPosts($id) { $criteria = new CDbCriteria(); if (param('post_list_type') == POST_LIST_TYPE_TITLE) { $criteria->select = array('t.id', 't.title', 't.visit_nums', 't.comment_nums', 't.create_time'); } $criteria->order = 't.istop, t.create_time desc, t.id desc'; $criteria->addColumnCondition(array('category_id' => $id))->addCondition('t.state = :state'); $criteria->params += array(':state' => POST_STATE_ENABLED); $count = Post::model()->count($criteria); $pages = new CPagination($count); $pages->setPageSize(param('postCountOfTitleListPage')); $pages->applyLimit($criteria); $posts = Post::model()->findAll($criteria); return array('posts' => $posts, 'pages' => $pages); }
public function actionIndex() { $data = array(); $alias = urlGETParams('alias'); $query = "SELECT * FROM tbl_tags WHERE alias = :alias"; $values = array(':alias' => $alias); $row = $this->db->createCommand($query)->bindValues($values)->queryRow(); if (empty($row)) { $this->redirect($this->createUrl('index/index')); } $data['row'] = $row; $tag_id = $row['id']; $where = " AND tags LIKE '%," . $tag_id . ",%' "; $query_count = "SELECT COUNT(id) FROM tbl_archive WHERE 1 " . $where; $item_count = $this->db->createCommand($query_count)->queryScalar(); $pages = new CPagination($item_count); $perPage = 20; $pages->setPageSize($perPage); $page = isset($_GET['page']) ? intval($_GET['page']) : 0; if ($page <= 0) { $page = 1; } $offset = ($page - 1) * $perPage; $query = "SELECT id, cate_id, title, alias, thumbnail,short_text,created,tags FROM tbl_archive WHERE 1 " . $where . " " . " ORDER BY id DESC " . "LIMIT " . $offset . "," . $perPage; $data['newpost'] = $this->db->createCommand($query)->queryAll(); $tags = array(); if (!empty($data['newpost'])) { foreach ($data['newpost'] as $item) { $arr = explode(',', trim($item['tags'], ',')); if (!empty($arr)) { foreach ($arr as $t) { $tags[] = $t; } } } $tags = array_unique($tags); $data['tags'] = $this->getListTags($tags); } $data['category'] = $this->getListCategory(); $title = $data['row']['name'] . ' News'; if ($page > 1) { $title .= ' - page ' . $page; } $this->_meta = array('title' => $title . ' - Techz24', 'description' => 'Techz24 news editors and reporters provide top ' . $data['row']['name'] . ' news, with in-depth coverage of issues and events.'); $this->_style_class = 'page right-sidebar singular fade-imgs-in-appear one-side-wide both-sidebars archive-page'; $this->render('index', array('data' => $data, 'item_count' => $item_count, 'page_size' => $perPage, 'pages' => $pages)); }
public function actionJob() { if (isset($_GET['id'])) { $model = News::model()->findByPk($_GET['id']); $this->render('detail', array('model' => $model)); } else { $news_criteria = new CDbCriteria(); $news_criteria->condition = "status = 1 AND news_type_id = 3"; $news_criteria->order = "create_date desc,news_id desc"; $news_total = News::model()->count($news_criteria); $pages = new CPagination($news_total); $pages->setPageSize(20); $pages->applyLimit($news_criteria); $news = News::model()->findAll($news_criteria); $this->render('job', array('news' => $news, 'pages' => $pages)); } }
public function actionGridProduct() { $search = null; $criteria = new CDbCriteria(); if (!empty($_POST)) { $search = Util::input($_POST['search']); $criteria->condition = "\n product_code LIKE(:search)\n OR product_name LIKE(:search)\n "; $criteria->params = array('search' => '%' . $search . '%'); } $product = new Product(); $model = new CActiveDataProvider($product, array('sort' => array('defaultOrder' => 'product_id DESC'))); $pagination = new CPagination(); $pagination->setPageSize(40); $model->setPagination($pagination); $model->setCriteria($criteria); $this->render('//Dialog/GridProduct', array('model' => $model)); }
/** * 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); } } }