public function actionNewsDelete($id) { if (SacredNews::model()->findByPk($id)->delete()) { $this->redirect(array('sacred/indexNews')); } }
public function actionNews() { $where_condition = ' 1=1 '; $pagin_page_size = 15; $pagin_page_current = empty($_GET['page']) ? '1' : $_GET['page']; $criteria = new CDbCriteria(); $criteria->select = 'n.*'; $criteria->alias = 'n'; $criteria->order = 'n.news_updatedate desc'; $criteria->limit = $pagin_page_size; $criteria->offset = ($pagin_page_current - 1) * $pagin_page_size; $this->data['listSacredNews'] = SacredNews::model()->findAll($criteria); /* * pagination logic */ $count_object = Yii::app()->db->createCommand()->select('count(*)')->from('sacred_news')->where($where_condition)->queryScalar(); $pagin_page_count = $count_object; $pagin_page_all = ceil($pagin_page_count / $pagin_page_size); $paramsBegin = array(); if (1 == $pagin_page_current) { $paramsBegin['page'] = 1; } else { $paramsBegin['page'] = $pagin_page_current - 1; } $paramsEnd = array(); if ($pagin_page_all == $pagin_page_current) { $paramsEnd['page'] = $pagin_page_all; } else { $paramsEnd['page'] = $pagin_page_current + 1; } $pagin_url_begin = Yii::app()->createUrl('site/news', $paramsBegin); $pagin_url_end = Yii::app()->createUrl('site/news', $paramsEnd); $this->data['pagination'] = array('page_size' => $pagin_page_size, 'page_count' => $pagin_page_count, 'page_current' => $pagin_page_current, 'page_all' => $pagin_page_all, 'page_url_begin' => $pagin_url_begin, 'page_url_end' => $pagin_url_end); /* * pagiation logic */ $this->render('list-news', $this->data); }