public function actionIndex()
{
if (isset($_GET['id'])) {
$model = Document::model()->findByPk($_GET['id']);
$this->render('detail', array('model' => $model));
} else {
if ($_GET['type_id']) {
$criteria = new CDbCriteria();
$criteria->select = '*';
$criteria->condition = 'status = 1 AND doc_group=\'service\' AND doc_type_id=' . $_GET['type_id'];
$criteria->order = 'sort_order';
$total = Document::model()->count($criteria);
$pages = new CPagination($total);
$pages->setPageSize(20);
$pages->applyLimit($criteria);
$model = Document::model()->findAll($criteria);
$type = DocumentType::model()->findByPk($_GET['type_id']);
$this->render('index', array('model' => $model, 'type' => $type, 'pages' => $pages));
} else {
$criteria = new CDbCriteria();
$criteria->select = '*';
$criteria->condition = 'status = 1 AND doc_group=\'service\'';
$criteria->order = 'sort_order';
$total = Document::model()->count($criteria);
$pages = new CPagination($total);
$pages->setPageSize(20);
$pages->applyLimit($criteria);
$model = Document::model()->findAll($criteria);
$this->render('index', array('model' => $model, 'pages' => $pages));
}
}
}
public function actionType($id)
{
$criteria = new CDbCriteria();
$criteria->select = '*';
$criteria->condition = 'status = 1 AND doc_type_id =' . $id;
$criteria->order = 'sort_order ASC ,last_update DESC';
$model = Document::model()->findAll($criteria);
$type = DocumentType::model()->findByPK($id);
$this->render('index', array('model' => $model, 'type' => $type));
}
}
?>
href="<?php
echo Yii::app()->createUrl('information');
?>
"><?php
echo $admission;
?>
</a>
<ul>
<?php
$criteria = new CDbCriteria();
$criteria->condition = 'status=:status AND doc_group=\'service\'';
$criteria->params = array(':status' => 1);
$criteria->order = 'sort_order';
$doc_type = DocumentType::model()->findAll($criteria);
foreach ($doc_type as $type) {
?>
<li><a href="<?php
echo Yii::app()->createUrl('information', array('type_id' => $type->doc_type_id));
?>
"><?php
echo $type->name_th;
?>
</a></li>
<?php
}
?>
<!--li><a href="<?php
echo Yii::app()->createUrl('admission');
?>
<?php
/* @var $this DocumentController */
/* @var $model Document */
$this->breadcrumbs = array('สื่อเผยแพร่/ดาวน์โหลด' => array('index'), 'จัดการข้อมูล');
$this->menu = array(array('label' => 'เพิ่มข้อมูล', 'url' => array('create')));
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$('#document-grid').yiiGridView('update', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
?>
<h1>จัดการสื่อเผยแพร่/ดาวน์โหลด</h1>
<?php
echo CHtml::link('ค้นหาแบบละเอียด', '#', array('class' => 'search-button'));
?>
<div class="search-form" style="display:none">
<?php
$this->renderPartial('_search', array('model' => $model, 'doc_type_list' => $doc_type_list));
?>
</div><!-- search-form -->
<?php
$this->widget('zii.widgets.grid.CGridView', array('id' => 'document-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array(array('header' => 'ลำดับ', 'type' => 'raw', 'value' => '$this->grid->dataProvider->pagination->currentPage*$this->grid->dataProvider->pagination->pageSize + $row+1', 'htmlOptions' => array('style' => 'text-align: center;width: 30px;')), array('name' => 'name_th', 'header' => 'สื่อเผยแพร่/ดาวน์โหลด'), array('name' => 'doc_type_id', 'header' => 'ประเภท', 'value' => '$data->documentType->name_th', 'htmlOptions' => array('style' => 'text-align: left;width: 150px;'), 'filter' => CHtml::listData(DocumentType::model()->findAll('status=1'), 'doc_type_id', 'name_th')), array('name' => 'last_update', 'header' => 'วันที่ปรับปรุง', 'value' => 'Controller::getThaiDate($data->last_update,"dmY")', 'htmlOptions' => array('style' => 'text-align: center;width: 80px;')), array('name' => 'status', 'value' => '($data->status)? \'แสดง\' : \'ไม่แสดง\'', 'htmlOptions' => array('style' => 'text-align: center;width: 50px;'), 'filter' => array('1' => 'แสดง', '0' => 'ไม่แสดง')), array('class' => 'CButtonColumn', 'template' => '{update} {delete}', 'headerHtmlOptions' => array('style' => 'width:40px;'), 'htmlOptions' => array('style' => 'width:40px; text-align:center')))));
/**
* Manages all models.
*/
public function actionAdmin()
{
if ($this->menu_use[4]) {
$doc_type_list = array();
$criteria = new CDbCriteria();
$criteria->condition = 'status=:status AND doc_group=\'download\'';
$criteria->params = array(':status' => 1);
$criteria->order = 'name_th';
$doc_type = DocumentType::model()->findAll($criteria);
foreach ($doc_type as $type) {
$doc_type_list[$type->doc_type_id] = $type->name_th;
}
$model = new Document('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Document'])) {
$model->attributes = $_GET['Document'];
}
$this->render('admin', array('model' => $model, 'doc_type_list' => $doc_type_list));
} else {
$this->redirect(array('site/index'));
}
}
public function actionSitemap()
{
$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 = 6;
$student_news = News::model()->findAll($condition);
$news_criteria = new CDbCriteria();
$news_criteria->condition = "news_type_id =1 AND status = 1";
$news_criteria->order = "create_date desc,news_id desc";
$news_criteria->offset = 0;
$news_criteria->limit = 3;
$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 = 6;
$job_news = News::model()->findAll($job_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 = 3;
$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);
$criteria = new CDbCriteria();
$criteria->condition = "status = 1 AND doc_group ='download'";
$criteria->order = "sort_order";
$doc = DocumentType::model()->findAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "status = 1";
$criteria->order = "sort_order";
$org = Organization::model()->findAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "status = 1";
$criteria->order = "sort_order";
$report = ReportType::model()->findAll($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('sitemap', array('news' => $news, 'newsInSide' => $newsInSide, 'job' => $job_news, 'student_news' => $student_news, 'doc' => $doc, 'org' => $org, 'links' => $links, 'report' => $report, 'vdo' => $vdo));
}
/**
* 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 DocumentType the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = DocumentType::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
