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 actionDel()
{
if (Ibos::app()->request->isAjaxRequest) {
$typeid = intval(EnvUtil::getRequest("typeid"));
if (empty($typeid)) {
$this->ajaxReturn(array("isSuccess" => false, "msg" => Ibos::lang("Parameters error", "error")));
}
$removeSuccess = ReportType::model()->remove($typeid);
if ($removeSuccess) {
$reports = Report::model()->fetchRepidAndAidByTypeids($typeid);
if (!empty($reports)) {
if ($reports["aids"]) {
AttachUtil::delAttach($reports["aids"]);
}
ReportRecord::model()->deleteAll("repid IN('{$reports["repids"]}')");
Report::model()->deleteAll("repid IN('{$reports["repids"]}')");
}
$return["isSuccess"] = true;
$return["msg"] = Ibos::lang("Del succeed", "message");
} else {
$return["isSuccess"] = false;
$return["msg"] = Ibos::lang("Del failed", "message");
}
$this->ajaxReturn($return);
}
}
?>
</a></li>
</ul>
</article>-->
<!-- <article class="fcol-3">
<h3 class="color-1"><?php
echo $report;
?>
</h3>
<ul class="list-3">
<?php
$criteria = new CDbCriteria();
$criteria->condition = 'status=:status';
$criteria->params = array(':status' => 1);
$criteria->order = 'sort_order';
$report = ReportType::model()->findAll($criteria);
$count = -1;
foreach ($report as $key => $type) {
if ($lang == 'en' || $lang == 'EN' || $lang == 'En') {
$name = $type->name_en;
} else {
$name = $type->name_th;
}
?>
<li><a href="<?php
echo Yii::app()->createUrl('report', array('type_id' => $type->report_type_id));
?>
"><?php
echo $name;
?>
</a></li>
public function actionShow()
{
$repid = EnvUtil::getRequest("repid");
$uid = Ibos::app()->user->uid;
if (empty($repid)) {
$this->error(Ibos::lang("Parameters error", "error"), $this->createUrl("default/index"));
}
$report = Report::model()->fetchByPk($repid);
if (empty($report)) {
$this->error(Ibos::lang("File does not exists", "error"), $this->createUrl("default/index"));
}
if ($report["uid"] != $uid) {
$this->error(Ibos::lang("Request tainting", "error"), $this->createUrl("default/index"));
}
$record = ReportRecord::model()->fetchAllRecordByRep($report);
$attachs = $readers = array();
if (!empty($report["attachmentid"])) {
$attachments = AttachUtil::getAttach($report["attachmentid"], true, true, false, false, true);
$attachs = array_values($attachments);
}
if (!empty($report["readeruid"])) {
$readerArr = explode(",", $report["readeruid"]);
$readers = User::model()->fetchAllByPk($readerArr);
}
$stampUrl = "";
if (!empty($report["stamp"])) {
$stampUrl = Stamp::model()->fetchStampById($report["stamp"]);
}
$params = array("report" => $report, "preAndNextRep" => Report::model()->fetchPreAndNextRep($report), "orgPlanList" => $record["orgPlanList"], "outSidePlanList" => $record["outSidePlanList"], "nextPlanList" => $record["nextPlanList"], "attachs" => $attachs, "readers" => $readers, "stampUrl" => $stampUrl, "realname" => User::model()->fetchRealnameByUid($report["uid"]), "departmentName" => Department::model()->fetchDeptNameByUid($report["uid"]), "isInstallCalendar" => ModuleUtil::getIsEnabled("calendar"));
if (!empty($params["nextPlanList"])) {
$reportType = ReportType::model()->fetchByPk($report["typeid"]);
$firstPlan = $params["nextPlanList"][0];
$params["nextSubject"] = ICReport::handleShowSubject($reportType, $firstPlan["begindate"], $firstPlan["enddate"], 1);
}
$this->setPageTitle(Ibos::lang("Show report"));
$this->setPageState("breadCrumbs", array(array("name" => Ibos::lang("Personal Office")), array("name" => Ibos::lang("Work report"), "url" => $this->createUrl("default/index")), array("name" => Ibos::lang("Show report"))));
$this->render("show", $params);
}
public function run()
{
$module = $this->getController()->getModule()->getId();
$data = array("type" => $this->getType(), "uid" => implode(",", $this->getUid()), "lang" => Ibos::getLangSource("report.default"), "reportTypes" => ReportType::model()->fetchSysType());
$this->render(self::VIEW, $data);
}
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));
}
public function actionShow()
{
$repid = intval(EnvUtil::getRequest("repid"));
$uid = Ibos::app()->user->uid;
if (empty($repid)) {
$this->error(Ibos::lang("Parameters error", "error"), $this->createUrl("review/index"));
}
$report = Report::model()->fetchByPk($repid);
if (empty($report)) {
$this->error(Ibos::lang("No data found", "error"), $this->createUrl("review/index"));
}
if ($report["uid"] == $uid) {
$this->redirect($this->createUrl("default/show", array("repid" => $repid)));
}
$permission = ICReport::checkPermission($report, $uid);
if (!$permission) {
$this->error(Ibos::lang("You do not have permission to view the report"), $this->createUrl("review/index"));
}
$record = ReportRecord::model()->fetchAllRecordByRep($report);
$attachs = $readers = array();
if (!empty($report["attachmentid"])) {
$attachments = AttachUtil::getAttach($report["attachmentid"], true, true, false, false, true);
$attachs = array_values($attachments);
}
if (!empty($report["readeruid"])) {
$readerArr = explode(",", $report["readeruid"]);
$readers = User::model()->fetchAllByPk($readerArr);
}
$stampUrl = "";
if (!empty($report["stamp"])) {
$stampUrl = Stamp::model()->fetchStampById($report["stamp"]);
}
$params = array("report" => $report, "preAndNextRep" => Report::model()->fetchPreAndNextRep($report), "orgPlanList" => $record["orgPlanList"], "outSidePlanList" => $record["outSidePlanList"], "nextPlanList" => $record["nextPlanList"], "attachs" => $attachs, "readers" => $readers, "stampUrl" => $stampUrl, "realname" => User::model()->fetchRealnameByUid($report["uid"]), "departmentName" => Department::model()->fetchDeptNameByUid($report["uid"]));
if (!empty($params["nextPlanList"])) {
$reportType = ReportType::model()->fetchByPk($report["typeid"]);
$firstPlan = $params["nextPlanList"][0];
$params["nextSubject"] = ICReport::handleShowSubject($reportType, $firstPlan["begindate"], $firstPlan["enddate"], 1);
}
$dashboardConfig = $this->getReportConfig();
if ($dashboardConfig["stampenable"] && $dashboardConfig["autoreview"]) {
$this->changeIsreview($repid);
}
$this->setPageTitle(Ibos::lang("Show subordinate report"));
$this->setPageState("breadCrumbs", array(array("name" => Ibos::lang("Personal Office")), array("name" => Ibos::lang("Work report"), "url" => $this->createUrl("default/index")), array("name" => Ibos::lang("Show subordinate report"))));
$this->render("show", $params);
}
/**
* 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 ReportType the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = ReportType::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
.panel {background-color: #fff; border: 1px solid transparent;}
</style>
<?php
$form = $this->beginWidget('CActiveForm', array('action' => Yii::app()->createUrl($this->route), 'method' => 'post', 'id' => 'dashboarForm'));
?>
<table class="dashItem">
<td style="vertical-align:top; width:225px;">
<div id="filterRegion" style="overflow:auto; padding-right:30px">
<div>
<?php
echo $form->labelEx($filter, 'reportTypeId');
echo CHtml::activeDropDownList($filter, 'reportTypeId', ReportType::getReportTypes());
?>
</div>
<div>
<?php
echo $form->labelEx($filter, 'dim2ID');
echo CHtml::activeDropDownList($filter, 'dim2ID', array(0 => " "));
?>
</div>
<div>
<?php
echo $form->labelEx($filter, 'reportFormatId');
echo CHtml::activeDropDownList($filter, 'reportFormatId', ReportFormat::getReportFormats());
?>
public function _new()
{
// if (!$this->loadData())
// {
// $this->dataError();
// sendBack();
// }
parent::_new();
// an array of legacy search fields
$search_fields = array();
$flash = Flash::Instance();
// get the report model, lets not envoke it again... that's not cool
$report = $this->_uses[$this->modeltype];
if (!empty($this->_data['tablename'])) {
$report_options[$this->_data['tablename']] = $this->_data['tablename'];
} else {
$report_options = $report::getTables();
}
if (!$report->isLoaded()) {
$report->tablename = current($report_options);
$this->view->set('update', false);
} else {
$this->view->set('update', true);
}
$this->view->set('report_options', $report_options);
// get the fields for the tablename and sort them
$available_fields = $this->getColumns($report->tablename);
ksort($available_fields);
// unserialise the options from the db
$options = unserialize($report->options);
if ($options !== FALSE) {
// overlay the defaults so we've got a full set of options
$options = $this->expand_options($options, $report->tablename);
// sort options by position
$options = $this->sort_options($options);
// loop through used fields and remove them from the available fields array
foreach ($options as $field => $field_options) {
// remove the field from the available fields array
unset($available_fields[$field]);
// we need to check against legacy search options
if ($field_options['field_type'] === 'search') {
// build an array of broken search options
$search_fields[] = $field;
// update the legacy options
$options[$field] = array_merge($this->default_options, $options[$field]);
// ATTN: boolean values didn't work here... but that's what the defaults are set as
// set other specific search settings
$options[$field]['field_type'] = 'normal';
$options[$field]['normal_enable_search'] = 'true';
$options[$field]['normal_display_field'] = 'false';
// if a default value exists
if (isset($options[$field]['default_value'])) {
// set it to the new option name
$options[$field]['search_default_value'] = $options[$field]['default_value'];
// unset the old version
unset($options[$field]['default_value']);
}
}
}
unset($available_fields['filter']);
} else {
$options = array();
}
if (!empty($search_fields)) {
$flash->addError('Legacy search fields found, click save <strong>immediately</strong> to update');
}
$description = $report->description;
// set smarty vars
$this->view->set('description', $description);
$this->view->set('available_fields', $available_fields);
$this->view->set('selected_tablename', $report->tablename);
$this->view->set('options', $options);
$this->view->set('report', $report);
//Set report defintion list
$report_type_id = ReportType::getReportTypeID('Reports');
$definition_list = ReportDefinition::getReportsByType($report_type_id);
array_unshift($definition_list, "Default");
$this->view->set('report_definitions', $definition_list);
//Set currently selected report definition
$selected_def = ReportDefinition::getDefinitionByID($report->report_definition);
if ($selected_def->_data['name'] == 'PrintCollection') {
$this->view->set('selected_reportdef', 'Default');
} else {
$this->view->set('selected_reportdef', $selected_def->_data['name']);
}
}
public static function getReportTypes()
{
return array(ReportType::None => " ", ReportType::TicketsCreated => ReportType::getReportTypeDescription(ReportType::TicketsCreated), ReportType::TicketsClosed => ReportType::getReportTypeDescription(ReportType::TicketsClosed), ReportType::TicketsAVGDuration => ReportType::getReportTypeDescription(ReportType::TicketsAVGDuration), ReportType::TicketsAVGTimeMentorAnswer => ReportType::getReportTypeDescription(ReportType::TicketsAVGTimeMentorAnswer), ReportType::TicketsCurrentlyOpen => ReportType::getReportTypeDescription(ReportType::TicketsCurrentlyOpen), ReportType::TicketsUnanswered => ReportType::getReportTypeDescription(ReportType::TicketsUnanswered));
}
public function reportOptions()
{
$report = ReportDefinition::getDefinition('PrintCollection');
// set options
return array('type' => array('pdf' => '', 'xml' => '', 'csv' => ''), 'report_type' => ReportType::getReportTypes(), 'default_report_type' => $report->report_type_id, 'report_name' => $this->getReportsByType($report->report_type_id), 'output' => array('print' => '', 'save' => '', 'email' => '', 'view' => ''), 'report' => $report->name, 'filename' => $this->generate_collection_name(TRUE));
}
<?php
/* @var $this ReportController */
/* @var $model Report */
$this->breadcrumbs = array('การประกันคุณภาพการศึกษา' => array('index'), 'จัดการข้อมูล');
$this->menu = array(array('label' => 'เพิ่มข้อมูล', 'url' => array('create')), array('label' => 'เรียงลำดับข้อมูล', 'url' => array('order')));
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\$('#report-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, 'report_type_list' => $report_type_list));
?>
</div><!-- search-form -->
<?php
$this->widget('zii.widgets.grid.CGridView', array('id' => 'report-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array(array('name' => 'report_id', 'htmlOptions' => array('style' => 'text-align: center;width: 30px;')), array('name' => 'name_th', 'header' => 'ชื่อรายงาน'), array('name' => 'report_type_id', 'header' => 'ประเภทรายงาน', 'value' => '$data->reportType->name_th', 'htmlOptions' => array('style' => 'text-align: left;width: 150px;'), 'filter' => CHtml::listData(ReportType::model()->findAll('status=1'), 'report_type_id', 'name_th')), array('name' => 'status', 'value' => '($data->status)? \'แสดง\' : \'ไม่แสดง\'', 'htmlOptions' => array('style' => 'text-align: center;width: 60px;'), '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[7]) {
$report_type_list = array();
$criteria = new CDbCriteria();
$criteria->condition = 'status=:status';
$criteria->params = array(':status' => 1);
$criteria->order = 'name_th';
$report_type = ReportType::model()->findAll($criteria);
foreach ($report_type as $type) {
$report_type_list[$type->report_type_id] = $type->name_th;
}
$model = new Report('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Report'])) {
$model->attributes = $_GET['Report'];
}
$this->render('admin', array('model' => $model, 'report_type_list' => $report_type_list));
} else {
$this->redirect(array('site/index'));
}
}
