$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 . "'");
}
