<?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>
예제 #3
0
 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'));
 }
예제 #4
0
$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,
//            ),
//        )
예제 #5
0
<?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 
예제 #6
0
 /**
  * @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 . "'");
 }
예제 #7
0
파일: _form.php 프로젝트: robebeye/isims
$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 
예제 #8
0
 /**
  * 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;
 }
예제 #9
0
 /**
 * 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));
 }
예제 #10
0
 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'));
 }
예제 #11
0
    ?>
</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'))));
    ?>