$model = Yii::app()->db->createCommand('SELECT distinct NIM FROM berita_acara_daftar_hadir badh JOIN d_jadwal dj ON badh.ID_DETAIL_JADWAL = dj.ID JOIN m_jadwal mj ON dj.ID_JADWAL = mj.ID WHERE mj.TA = "' . $TAjaran . '" and dj.KODE_MK = "' . $mata_kuliah . '" and mj.KELAS = "' . $kelas . '"')->queryAll(); $no = 1; foreach ($model as $modelN) { ?> <tr> <td border="0.5" align="center"><?php echo $no; ?> </td> <td border="0.5" align="center"><?php echo $modelN['NIM']; ?> </td> <td border="0.5" align=left" colspan="2"> <?php $modelNama = Dim::model()->findByAttributes(array('NIM' => $modelN['NIM'])); echo $modelNama->NAMA; ?> </td> <?php $DistinctTanggal = Yii::app()->db->createCommand('SELECT DISTINCT mj.TANGGAL FROM berita_acara_daftar_hadir badh JOIN d_jadwal dj ON badh.ID_DETAIL_JADWAL = dj.ID JOIN m_jadwal mj ON dj.ID_JADWAL = mj.ID WHERE mj.TA = "' . $TAjaran . '" and dj.KODE_MK = "' . $mata_kuliah . '" and mj.KELAS = "' . $kelas . '"')->queryAll(); foreach ($DistinctTanggal as $itemDTanggal) { $countSessionByDate = Yii::app()->db->createCommand('SELECT DISTINCT dj.SESSION FROM berita_acara_daftar_hadir badh JOIN d_jadwal dj ON badh.ID_DETAIL_JADWAL = dj.ID JOIN m_jadwal mj ON dj.ID_JADWAL = mj.ID WHERE mj.TANGGAL = "' . $itemDTanggal['TANGGAL'] . '" AND dj.KODE_MK="' . $mata_kuliah . '" and mj.KELAS = "' . $kelas . '"')->queryAll(); foreach ($countSessionByDate as $itemCSBD) { ?> <td border="0.5" width="30" align="center"> <?php // $hasil = BeritaAcaraDaftarHadir::model()->findAllBySql(" SELECT * FROM berita_acara_daftar_hadir badh JOIN d_jadwal dj ON badh.`ID_DETAIL_JADWAL`=dj.`ID` JOIN m_jadwal mj ON dj.`ID_JADWAL`=mj.`ID` // WHERE mj.`TA`= '$TAjaran' AND dj.`KODE_MK` = '$mata_kuliah' AND mj.`KELAS` = '$kelas'"); $modelnim = $modelN['NIM']; $tggl = $itemDTanggal['TANGGAL'];
</tr> <?php $x = 1; foreach ($model as $item) { ?> <tr> <td><?php echo $x; ?> </td> <td><?php echo $item['NIM']; ?> </td> <td colspan="2"><?php $nama = Dim::model()->findByAttributes(array('NIM' => $item['NIM'])); echo $nama->NAMA; ?> </td> <td><?php echo $item['STATUS']; ?> </td> <td><?php echo $item['STATUS']; ?> </td> <td><?php echo $item['STATUS']; ?> </td>
/** * 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 = Dim::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
<?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) {
/** * @param string nim * @soap */ public function deleteDim($nim) { Dim::model()->deleteAll("NIM = '" . $nim . "'"); }