public static function login($username, $password, $language)
{
if ($username and $password) {
$auth = new Auth();
if ($auth->login($username, $password) == true) {
$session_id = $auth->get_session_id();
$session = new Session($session_id);
$user = new User($session->get_user_id());
$regional = new Regional($session->get_user_id());
if (is_numeric($language)) {
$session->write_value("LANGUAGE", $language);
} else {
$session->write_value("LANGUAGE", $regional->get_language_id());
}
if ($user->get_boolean_user_entry("user_locked") == false) {
return "index.php?username="******"&session_id=" . $session_id;
} else {
return 0;
}
} else {
return 0;
}
} else {
return 0;
}
}
/**
* {@inheritDoc}
*/
public function getEspacialidadesById($id)
{
$sql = $this->getSqlById($id);
$this->bd->execSql($sql);
while ($row = $this->bd->proximo()) {
$obj = new Regional();
$obj->setGeoJson($row->geo_json);
$obj->setNome(wordwrap(trim($row->nome), 25, "<br>"));
$obj->setId($row->id);
$this->addEspacialidade($obj);
}
return $this;
}
/**
* This is the actionCompareRekapan to handle Perbandingan Rekapan.
* @return name regional on Regional model.
*/
public function getNameRegional()
{
$arrRegional = array();
$dataReader = Regional::model()->getRegional();
$i = 0;
while (($row = $dataReader->read()) !== false) {
$arrRegional[$i++] = $row['nama'];
}
return $arrRegional;
}
/**
* Updates a particular of deadline kegiatan.
* If update is successful, the browser will be redirected to the list of daedline page.
* @param integer $id the ID of the model deadline kegiatan to be updated
*/
public function actionUpdateDeadline($id)
{
$model = $this->loadModel($id);
$nama_regional = "";
$model2 = Regional::model()->findByPk($model->id_regional);
if ($model->id_regional == $model2->id_regional) {
$nama_regional = $model2->nama;
}
if (isset($_POST['Kegiatan'])) {
// Klik submit save
$model->deadline = $_POST['Kegiatan']['deadline'];
$arrDeadline01 = explode(" ", $model->deadline);
if (!empty($model->deadline)) {
if (preg_match("/-/", $arrDeadline01[0])) {
$arrDeadline02 = explode("-", $arrDeadline01[0]);
} else {
$arrDeadline02 = explode("/", $arrDeadline01[0]);
}
date_default_timezone_set("Asia/Jakarta");
$arrDeadline03 = explode(":", $arrDeadline01[1]);
$arrDatenow = explode("-", date("Y-m-d"));
$arrTimenow = explode(":", date("H:i"));
$sumDatenow = $arrDatenow[0] + $arrDatenow[1] + $arrDatenow[2];
$sumDeadline = $arrDeadline02[0] + $arrDeadline02[1] + $arrDeadline02[2];
if ($sumDatenow <= $sumDeadline) {
if ($arrTimenow[0] <= $arrDeadline03[0]) {
if ($arrTimenow[1] <= $arrDeadline03[1]) {
Yii::app()->user->setFlash('errorDeadline', 'Waktu menit deadline tidak boleh masa lalu.');
$this->redirect(array('UpdateDeadline', 'id' => $id));
} else {
if (!empty($model->deadline)) {
$model->save();
Yii::app()->user->setFlash('successDeadline', 'Deadline telah berhasil diubah.');
$this->redirect(array('deadline'));
} else {
Yii::app()->user->setFlash('errorDeadline', 'Salah masukan deadline.');
$this->redirect(array('UpdateDeadline', 'id' => $id));
}
}
} else {
Yii::app()->user->setFlash('errorDeadline', 'Waktu jam deadline tidak boleh masa lalu.');
$this->redirect(array('UpdateDeadline', 'id' => $id));
}
} else {
Yii::app()->user->setFlash('errorDeadline', 'Tanggal deadline tidak boleh masa lalu.');
$this->redirect(array('UpdateDeadline', 'id' => $id));
}
} else {
Yii::app()->user->setFlash('errorDeadline', 'Tanggal deadline tidak boleh kosong.');
$this->redirect(array('UpdateDeadline', 'id' => $id));
}
} else {
// Klik Edit di list
$this->render("formDeadline", array('model' => $model, 'nama_regional' => $nama_regional));
}
}
/**
* @return array of Regional Name options.
*/
public function Regionals()
{
return CHtml::listData(Regional::model()->findAll(), 'id_regional', 'nama');
}
public function actionCreate()
{
$model = new Kegiatan();
$id_user = Yii::app()->user->id;
$objRegional = Regional::model()->findByAttributes(array('id_user' => $id_user));
$id_regional = $objRegional->id_regional;
//peserta
if (Yii::app()->user->getLevel() == 3) {
$sql = "SELECT id_peserta,nama FROM peserta WHERE status_aktif=1 and id_regional = '" . $id_regional . "' order by nama";
} else {
$sql = "SELECT id_peserta,nama FROM peserta WHERE status_aktif=1 order by id_regional, nama";
}
$dbCommand = Yii::app()->db->createCommand($sql);
$peserta = $dbCommand->queryAll();
$absensi = array();
foreach ($peserta as $i => $item) {
$id = $item['id_peserta'];
$absensi[$id] = Absensi::model();
$absensi[$id]->id_peserta = $id;
}
//end peserta
if (isset($_POST['Absensi'])) {
$model->attributes = $_POST['Kegiatan'];
$model->id_regional = $id_regional;
if ($model->waktu_mulai > $model->waktu_selesai) {
Yii::app()->user->setFlash('errorWaktu', 'Waktu selesai lebih kecil atau sama dengan dari waktu mulai!');
$this->redirect(array('create'), array('model' => $model, 'absensi' => $absensi));
}
$model->deadline = date('Y-m-t 23:59:59');
$model->waktu_isi = date('Y-m-d H:i:s');
$model->status_isi = 1;
if ($model->save()) {
$valid = true;
foreach ($_POST['Absensi'] as $j => $item) {
if (isset($_POST['Absensi'][$j])) {
$absensi[$j] = new Absensi();
$absensi[$j]->id_peserta = $j;
$absensi[$j]->id_status = $_POST['Absensi'][$j]['id_status'];
$absensi[$j]->alasan = $_POST['Absensi'][$j]['alasan'];
$absensi[$j]->id_kegiatan = $model->id_kegiatan;
$absensi[$j]->save();
}
}
Yii::app()->user->setFlash('successTambah', 'Absensi sudah ditambahkan');
$this->actionView($model->id_kegiatan);
break;
} else {
Yii::app()->user->setFlash('gagalTambah', 'Gagal Simpan Kegiatan');
}
}
$this->render('create', array('model' => $model, 'absensi' => $absensi));
}
<h1>Escolha uma regional do Estado</h1>
<?php
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'regional-pesquisa-form', 'htmlOptions' => array('class' => 'well'), 'type' => 'horizontal'));
?>
<legend>Pesquisar concluintes do curso por Regional</legend>
<?php
?>
<?php
$regionais = CHtml::listData(Regional::model()->findAll(), 'id', 'sigla');
echo $form->dropDownListRow($model, 'id', $regionais);
?>
<div class="form-actions">
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'link', 'label' => 'Voltar', 'icon' => 'icon-chevron-left', 'url' => Yii::app()->baseUrl));
?>
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'submit', 'label' => 'Pesquisar', 'icon' => 'icon-search'));
?>
</div>
<?php
$this->endWidget();
/**
* 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 the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Regional::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* Manages all list Peserta.
*/
public function actionListPeserta()
{
$id_user = Yii::app()->user->id;
$objRegional = Regional::model()->findByAttributes(array('id_user' => $id_user));
if ($objRegional != null) {
$id_regional = $objRegional->id_regional;
} else {
throw new CHttpException(404, 'Anda belum jadi admin regional tertentu');
}
//$dataPeserta = Peserta::model()->findAllByAttributes(array('id_regional'=>$id_regional));
$model = new Peserta('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Peserta'])) {
$model->attributes = $_GET['Peserta'];
}
$model->id_regional = $id_regional;
$this->render('admin', array('model' => $model));
}
/**
* Lists all models of feedback.
*/
public function actionIndex()
{
$model = Feedback::model();
if (Yii::app()->user->getLevel() == 2) {
$this->actionCreate();
} else {
$dataProvider = new CActiveDataProvider('Feedback');
//$model = new Feedback;
$id_user = Yii::app()->user->id;
$objRegional = Regional::model()->findByAttributes(array('id_user' => $id_user));
if ($objRegional != null) {
$id_regional = $objRegional->id_regional;
} else {
throw new CHttpException(404, 'Anda belum jadi admin regional tertentu');
}
$criteria = new CDbCriteria();
$criteria->order = "id_feedback desc";
$count = Feedback::model()->count($criteria);
$pages = new CPagination($count);
// results per page
$pages->pageSize = 10;
$pages->applyLimit($criteria);
$dataFeedback = Feedback::model()->findAllByAttributes(array('id_regional' => $id_regional), $criteria);
$this->render('index', array('dataFeedback' => $dataFeedback, 'pages' => $pages));
}
}
<tbody>
<?php $i=0;?>
<?php foreach($models as $model): ?>
<?php $jenis_kegiatan = "";
if($model->jenis_kegiatan == "1") $jenis_kegiatan = "Bulanan";
if($model->jenis_kegiatan == "2") $jenis_kegiatan = "Pekanan";
if($model->jenis_kegiatan == "3") $jenis_kegiatan = "Lokal";
if($model->jenis_kegiatan == "4") $jenis_kegiatan = "Khusus";
?>
<?php
$nama_regional = "";
$model2 = Regional::model()->findByPk($model->id_regional);
if($model->id_regional == $model2->id_regional) $nama_regional = $model2->nama;
?>
<?php
$status_isi = "";
if($model->status_isi == "2") $status_isi = "<span style='color:red'>Telat Isi</span>";
if($model->status_isi == "1") $status_isi = "Sudah Diisi";
if($model->status_isi == "0") $status_isi = "<span style='color:red'>Belum Diisi</span>";
?>
<?php if($i%2==0){
echo "<tr class="."'active'".">";
}else{
echo "<tr>";
}?>
<h1><?php
echo $model->nome;
?>
</h1>
<?php
$this->widget('bootstrap.widgets.TbDetailView', array('data' => $model, 'attributes' => array('nome', array('name' => 'Regional', 'value' => Regional::model()->findByPk($model->regional_id)->sigla . ' - ' . Regional::model()->findByPk($model->regional_id)->nome_associacao), array('label' => 'Concluintes 1ª Edição', 'type' => 'raw', 'value' => $this->printaCursistas($model->id, '1')), array('label' => 'Concluintes 2ª Edição', 'type' => 'raw', 'value' => $this->printaCursistas($model->id, '2-1')))));
?>
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'link', 'label' => 'Voltar', 'icon' => 'icon-chevron-left', 'url' => 'index.php?r=municipio/pesquisa'));
/**
* @throws UserIDMissingException
*/
public static function change_timezone()
{
if ($_GET['id']) {
$user = new User($_GET['id']);
$regional = new Regional($_GET['id']);
if ($_GET['nextpage'] == 1) {
$page_1_passed = true;
} else {
$page_1_passed = false;
}
if ($page_1_passed == false) {
$template = new HTMLTemplate("base/user/admin/user/change_timezone.html");
$paramquery = $_GET;
$paramquery['nextpage'] = "1";
$params = http_build_query($paramquery, '', '&');
$template->set_var("params", $params);
$timezone_array = Timezone::list_timezones();
$result = array();
$counter = 0;
if (is_array($timezone_array)) {
foreach ($timezone_array as $key => $value) {
$timezone = new Timezone($value);
$result[$counter]['value'] = $value;
$result[$counter]['content'] = $timezone->get_name();
if ($value == $regional->get_timezone_id()) {
$result[$counter]['selected'] = "selected='selected'";
} else {
$result[$counter]['selected'] = "";
}
$counter++;
}
}
$template->set_var("option", $result);
$template->output();
} else {
$paramquery = $_GET;
$paramquery['action'] = "detail";
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
if ($user->set_timezone_id($_POST['timezone'])) {
Common_IO::step_proceed($params, "Change Timezone", "Operation Successful", null);
} else {
Common_IO::step_proceed($params, "Change Timezone", "Operation Failed", null);
}
}
} else {
throw new UserIDMissingException();
}
}
