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);
}
