<?php
$temp = explode("-", $message);
$Kode = $temp[0];
$NIM = $temp[1];
$nama_temp = Dim::model()->findByAttributes(array('NIM' => $NIM));
$nama_mhs = $nama_temp->NAMA;
$kelas_temp = Registrasi::model()->findByAttributes(array('NIM' => $NIM));
$kelas = $kelas_temp->KELAS;
$mk = Kurikulum::model()->findByAttributes(array('KODE_MK' => $Kode));
$nama_MK = $mk->NAMA_KUL_IND;
$tes = Yii::app()->db->createCommand("SELECT * FROM registrasi reg WHERE NIM = '{$NIM}' GROUP BY SEM DESC LIMIT 1")->queryAll();
// var_dump($tes);
//echo $tes[0]["SEM"];
$weektot = Yii::app()->db->createCommand("SELECT COUNT(DISTINCT WEEK) FROM m_jadwal mj JOIN d_jadwal dj ON mj.ID = dj.ID_JADWAL JOIN berita_acara_daftar_hadir badh ON badh.ID_DETAIL_JADWAL = dj.ID WHERE badh.NIM = '{$NIM}' AND dj.KODE_MK = '{$Kode}'")->queryAll();
$weekisi = Yii::app()->db->createCommand("SELECT DISTINCT WEEK FROM m_jadwal mj JOIN d_jadwal dj ON mj.ID = dj.ID_JADWAL JOIN berita_acara_daftar_hadir badh ON badh.ID_DETAIL_JADWAL = dj.ID WHERE badh.NIM = '{$NIM}' AND dj.KODE_MK = '{$Kode}'")->queryAll();
//echo var_dump($weektot)."<br>";
// echo var_dump($weekisi);
$listWeek = array();
$listCount = array();
$listCountAbsen = array();
$indWeek = 0;
$indCount = 0;
$indCountAbsen = 0;
foreach ($weekisi as $hitung) {
$testtemp = $hitung["WEEK"];
$listWeek[$indWeek] = "Week " . $testtemp;
$tempcount = Yii::app()->db->createCommand("SELECT COUNT(*) FROM berita_acara_daftar_hadir badh \n JOIN d_jadwal dj \n ON badh.ID_DETAIL_JADWAL = dj.ID\n JOIN m_jadwal mj\n ON dj.ID_JADWAL = mj.ID\n WHERE NIM = '{$NIM}' AND mj.WEEK = '{$testtemp}' AND dj.KODE_MK = '{$Kode}' AND badh.STATUS = 'H'")->queryAll();
$absencount = Yii::app()->db->createCommand("SELECT COUNT(*) FROM berita_acara_daftar_hadir badh \n JOIN d_jadwal dj \n ON badh.ID_DETAIL_JADWAL = dj.ID\n JOIN m_jadwal mj\n ON dj.ID_JADWAL = mj.ID\n WHERE NIM = '{$NIM}' AND mj.WEEK = '{$testtemp}' AND dj.KODE_MK = '{$Kode}' AND badh.STATUS = 'A'")->queryAll();
//var_dump($tempcount);
foreach ($tempcount as $abc) {
<td colspan="4"><b>Daftar Hadir Mahasiswa Semester <?php
echo $semester;
?>
T.A <?php
echo $TAjaran . "/";
echo "" . (int) $TAjaran + 1;
?>
</b></td>
</tr>
<tr>
<td align="left"><b>Mata Kuliah</b></td>
<td width="20" align="center"> : </td>
<td width="750" align="left">
<b>
<?php
$mk = Kurikulum::model()->findByAttributes(array('KODE_MK' => $mata_kuliah));
echo $mk->NAMA_KUL_IND;
?>
</b>
</td>
<td></td>
</tr>
<tr>
<td align="left"><b>Jumlah SKS</b></td>
<td align="center"> : </td>
<td align="left"><b><?php
echo $mk->SKS;
?>
</b></td>
<td></td>
</tr>
public function actionMatkul()
{
$data = Kurikulum::model()->findAll('ID_KUR=:id', array(':id' => (int) $_POST['Jadwal']['ID_KUR']));
$return = CHtml::listData($data, 'KODE_MK', 'KODE_MK');
foreach ($return as $value => $KODE_MK) {
echo Chtml::tag('option', array('value' => $value), CHtml::encode($KODE_MK), true);
}
echo Chtml::tag('option', array('value' => 'Kosong1'), CHtml::encode('Free'));
}
$idkur = CHtml::listData(Registrasi::model()->findAll(array('select' => 't.KELAS', 'condition' => "TA = 2013", 'order' => 'KELAS DESC', 'distinct' => true)), 'KELAS', 'KELAS');
echo $form->dropDownListGroup($model, 'KELAS', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $idkur, 'htmlOptions' => array())));
?>
<?php
$ta = CHtml::listData(Registrasi::model()->findAll(array('select' => 't.TA', 'order' => 'TA DESC', 'distinct' => true)), 'TA', 'TA');
echo $form->dropDownListGroup($model, 'TA', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $ta, 'htmlOptions' => array())));
?>
<?php
$idkur = CHtml::listData(Kurikulum::model()->findAll(array('select' => 't.ID_KUR', 'order' => 'ID_KUR DESC', 'distinct' => true)), 'ID_KUR', 'ID_KUR');
echo $form->dropDownListGroup($model, 'ID_KUR', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $idkur, 'htmlOptions' => array('prompt' => '--Select ID Kurikulum--'))));
?>
<?php
$kuliah = CHtml::listData(Kurikulum::model()->findAll(array('condition' => "ID_KUR = 2012")), 'KODE_MK', 'KODE_MK');
echo $form->dropDownListGroup($model, 'KODE_MK', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $kuliah, 'htmlOptions' => array('prompt' => '--ID Kurikulum Belum Dipilih--'))));
?>
<?php
// echo $form->select2Group(
// $model, 'KODE_MK', array(
// 'wrapperHtmlOptions' => array(
// 'class' => 'col-sm-5',
// ),
// 'widgetOptions' => array(
// 'data' => array(),
// 'htmlOptions' => array(
// 'multiple' => true,
// ),
// )
<?php
echo $form->datePickerGroup($model, 'TANGGAL', array('widgetOptions' => array('options' => array(), 'htmlOptions' => array('class' => 'span5')), 'prepend' => '<i class="glyphicon glyphicon-calendar"></i>', 'append' => 'Pilih Tanggal Jadwal.'));
?>
<?php
$ta = CHtml::listData(Registrasi::model()->findAll(array('select' => 't.TA', 'order' => 'TA DESC', 'distinct' => true)), 'TA', 'TA');
echo $form->dropDownListGroup($model, 'TA', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $ta, 'htmlOptions' => array())));
?>
<?php
$idkur = CHtml::listData(Registrasi::model()->findAll(array('select' => 't.KELAS', 'condition' => "TA = 2013", 'order' => 'KELAS DESC', 'distinct' => true)), 'KELAS', 'KELAS');
echo $form->dropDownListGroup($model, 'KELAS', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $idkur, 'htmlOptions' => array())));
?>
<?php
$idkur = CHtml::listData(Kurikulum::model()->findAll(array('select' => 't.ID_KUR', 'order' => 'ID_KUR DESC', 'distinct' => true)), 'ID_KUR', 'ID_KUR');
echo $form->dropDownListGroup($model, 'ID_KUR', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $idkur, 'htmlOptions' => array())));
?>
<!--<BR><BR>-->
<?php
// for ($i = 0; $i < 8; $i++) {
?>
<!-- <div class="well">
<fieldset>
<legend>Sesi <?php
// echo $i + 1
?>
</legend>
<?php
/**
* @param int id_kur
* @param string kode_mk
* @soap
*/
public function deleteKurikulum($id_kur, $kode_mk)
{
Kurikulum::model()->deleteAll("ID_KUR = '" . $id_kur . "' and KODE_MK = '" . $kode_mk . "'");
}
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'lokal-form', 'enableAjaxValidation' => false, 'htmlOptions' => array('class' => 'well well-small'), 'type' => 'horizontal'));
?>
<p class="help-block">Fields with <span class="required">*</span> are required.</p>
<?php
echo $form->errorSummary($model);
?>
<?php
echo $form->textFieldRow($model, 'kode_mapel', array('maxlength' => 5));
?>
<?php
echo $form->dropDownListRow($model, 'kurikulum', CHtml::listData(Kurikulum::model()->findAll(), 'kurikulum', 'kurikulum'), array('empty' => '-- KURIKULUM --'));
?>
<?php
echo $form->textFieldRow($model, 'mapel', array('maxlength' => 30));
?>
<?php
echo $form->textFieldRow($model, 'kkm', array('maxlength' => 2));
?>
<div class="form-actions">
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'submit', 'type' => 'primary', 'label' => $model->isNewRecord ? 'Create' : 'Save'));
?>
<?php
/**
* 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 = Kurikulum::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* Manages all models.
*/
public function actionAdmin()
{
$model = new Kurikulum('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Kurikulum'])) {
$model->attributes = $_GET['Kurikulum'];
}
$this->render('admin', array('model' => $model));
}
public function actionMatkuljadwal($kbk)
{
$id_kur = (int) $_POST['MJadwal']['ID_KUR'];
$kuliah = CHtml::listData(Kurikulum::model()->findAll(array('condition' => "ID_KUR = '{$id_kur}' AND (KBK_ID LIKE '{$kbk}' OR KBK_ID LIKE 'all')")), 'KODE_MK', 'KODE_MK');
// $kurikulum = Kurikulum::model()->findAllByAttributes(array('ID_KUR' => $id_kur));
// $data = Kurikulum::model()->findAll(
// "ID_KUR=:id ", array(':id' => (int) $_POST['MJadwal']['ID_KUR']));
// $return = CHtml::listData($kuliah, 'KODE_MK', 'KODE_MK');
foreach ($kuliah as $value => $KODE_MK) {
echo Chtml::tag('option', array('value' => $value), CHtml::encode($KODE_MK), true);
}
echo Chtml::tag('option', array('value' => 'Kosong'), CHtml::encode('Free'));
}
?>
</SMALL></legend>
<?php
// echo $form->textFieldGroup($djadwal, '[' . $i . ']SESSION', array('widgetOptions' => array('htmlOptions' => array('class' => 'span5', 'placeholder' => 'Sesi'))));
?>
Sesi Kosong ? <input type="checkbox" name="formsesi<?php
echo $i;
?>
" value="Yes" />
<BR>
<BR>
<?php
$kuliah = CHtml::listData(Kurikulum::model()->findAll(array('condition' => "ID_KUR = '{$last}' AND (KBK_ID LIKE '{$kbk->KBK_ID}' OR KBK_ID LIKE 'all')")), 'KODE_MK', 'KODE_MK');
echo $form->dropDownListGroup($djadwal, '[' . $i . ']KODE_MK', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $kuliah, 'htmlOptions' => array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('MJadwal/deskripsi&id=' . $i), 'update' => "#matkul{$i}")))));
?>
<div id="matkul<?php
echo $i;
?>
" class="alert alert-info"></div>
<?php
$data = CHtml::listData(Ruangan::model()->findAll(), 'ID', 'SHORT_NAME');
echo $form->dropDownListGroup($djadwal, '[' . $i . ']RUANGAN', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $data, 'htmlOptions' => array())));
?>
<?php
echo $form->dropDownListGroup($djadwal, '[' . $i . ']AKTIFITAS', array('widgetOptions' => array('data' => array("Teori" => "Teori", "Praktikum" => "Praktikum", "Mandiri" => "Mandiri"), 'htmlOptions' => array('class' => 'input-large', 'placeholder' => 'Aktifitas'))));
?>
