public function run()
{
$criteria = new CDbCriteria();
$criteria->select = '*';
$criteria->condition = '`visible` = 1';
$criteria->order = "id desc";
$this->render("slider", array("slides" => Slide::model()->findAll($criteria)));
}
/**
* This is the default 'index' action that is invoked
* when an action is not explicitly requested by users.
*/
public function actionIndex()
{
date_default_timezone_set('America/Bogota');
$slides = Slide::model()->findAllByAttributes(array('status_slide' => 1), array('order' => 't.id_slide DESC'));
$lastNews = News::model()->findAllByAttributes(array('status_new' => 1), array('order' => 't.id_new DESC', 'limit' => 2));
$dateNow = new DateTime("now");
$date = Dates::model()->findByAttributes(array('date_date' => $dateNow->format('Y-m-d'), 'status_date' => 1));
if ($date != null) {
$events = Events::model()->findAllByAttributes(array('dates_id_date' => $date->id_date, 'status_event' => 1), array('order' => 't.hour_event ASC'));
} else {
$events = null;
}
$this->render('index', array('date_now' => $dateNow, 'events' => $events, 'lastNews' => $lastNews, 'slides' => $slides));
}
public static function model($className = __CLASS__)
{
return parent::model($className);
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Slide the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Slide::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
$this->breadcrumbs = array('Slides' => array('index'), 'Create');
$this->menu = array(array('label' => 'List Slides', 'url' => array('index')), array('label' => 'Manage Slides', 'url' => array('admin')));
?>
<h1>Create <?php
echo Formatter::formatOrdinal(Slide::model()->count() + 1);
?>
Slide</h1>
<?php
echo $this->renderPartial('_form', array('model' => $model));
public function actionHomenew()
{
$Criteria = new CDbCriteria();
$Criteria->condition = "status = 1";
$Criteria->order = "sort_order";
$Criteria->offset = 0;
$Criteria->limit = 4;
$model = Slide::model()->findAll($Criteria);
$condition = new CDbCriteria();
$condition->condition = "news_type_id =2 AND status = 1";
$condition->order = "create_date desc,news_id desc";
$condition->offset = 0;
$condition->limit = 4;
$student_news = News::model()->findAll($condition);
$news_criteria = new CDbCriteria();
$news_criteria->condition = "news_type_id <>2 AND news_type_id <>3 AND status = 1";
$news_criteria->order = "create_date desc,news_id desc";
$news_criteria->offset = 0;
$news_criteria->limit = 8;
$news = News::model()->findAll($news_criteria);
$job_criteria = new CDbCriteria();
$job_criteria->condition = "news_type_id =3 AND status = 1";
$job_criteria->order = "create_date desc,news_id desc";
$job_criteria->offset = 0;
$job_criteria->limit = 4;
$job = News::model()->findAll($job_criteria);
$event_criteria = new CDbCriteria();
$event_criteria->condition = "event_start >= " . date('Y-m-d') . " AND event_status = 1";
$event_criteria->order = "event_start ,event_id";
$event_criteria->offset = 0;
$event_criteria->limit = 5;
$events = Event::model()->findAll($event_criteria);
// $pr_criteria = new CDbCriteria();
// $pr_criteria->condition = "news_type_id =5 AND status = 1";
// $pr_criteria->order = "create_date desc,news_id desc";
// $pr_criteria->offset = 0;
// $pr_criteria->limit = 4;
// $newsInSide = News::model()->findAll($pr_criteria);
$link_criteria = new CDbCriteria();
$link_criteria->condition = "status = 1";
$link_criteria->order = "sort_order";
$links = Link::model()->findAll($link_criteria);
$vdo_criteria = new CDbCriteria();
$vdo_criteria->condition = "page_id = 3 AND status = 1";
$vdo = Page::model()->find($vdo_criteria);
// echo "<br> ===> ";
// echo "<pre>";
// print_r($vdo);
// echo "</pre>";
// exit;
$this->render('index_new', array('model' => $model, 'news' => $news, 'job' => $job, 'student_news' => $student_news, 'links' => $links, 'vdo' => $vdo, 'events' => $events));
}
public function actionEditorSlides()
{
if (!Yii::app()->request->isAjaxRequest) {
Yii::app()->end();
}
$slides = Slide::model()->findAll();
if (count($slides) > 0) {
$this->renderPartial('_editorSlides', array('slides' => $slides, true, true));
} else {
echo CJSON::encode('');
}
Yii::app()->end();
}
public function actionShow($id)
{
$slide = Slide::model()->findByPk($id);
$slide->visible = 1;
$slide->update();
$this->redirect('/slider/');
}
/**
* Protected method to load the associated Slide model class
* @id the primary identifier of the associeted Slide
* @return object the Slide data model based on the primary key
*/
protected function loadSlide($slide_id)
{
// if the screen property is null, create it based on the input id
if ($this->_slide === NULL) {
$this->_slide = Slide::model()->findByPk($slide_id);
if ($this->_slide === NULL) {
throw new CHttpException(404, YII::t('bannerModule.slide', 'The requested Slide does not exist.'));
}
}
return $this->_slide;
}
public function loadModel($id)
{
$model = Slide::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'Запись не найдена.');
}
return $model;
}
