/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new DJadwal();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['DJadwal'])) {
$model->attributes = $_POST['DJadwal'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->ID));
}
}
$this->render('create', array('model' => $model));
}
public function actionCreatejadwal($kbk)
{
$model = new MJadwal();
$djadwal = new DJadwal();
$kbkmodel = RefKbk::model()->findByPk($kbk);
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['MJadwal'])) {
$model->attributes = $_POST['MJadwal'];
if ($model->save()) {
if (isset($_POST['DJadwal'])) {
for ($i = 0; $i < 8; $i++) {
if (!isset($_POST["formsesi{$i}"])) {
echo $i;
$detail = new DJadwal();
$detail->KODE_MK = $_POST['DJadwal'][$i]['KODE_MK'];
$detail->RUANGAN = $_POST['DJadwal'][$i]['RUANGAN'];
$detail->AKTIFITAS = $_POST['DJadwal'][$i]['AKTIFITAS'];
$detail->SESSION = $i + 1;
$detail->ID_JADWAL = $model->ID;
$detail->START_TIME = $this->start_time($i + 1);
$detail->END_TIME = $this->end_time($i + 1);
// MAHASISWA
$sql = "SELECT DISTINCT(nilai.NIM),nilai.`SEM` FROM nilai JOIN registrasi ON nilai.`NIM` = registrasi.`NIM` WHERE KODE_MK LIKE \n'{$detail->KODE_MK}' AND registrasi.`TA` = {$model->TA} AND registrasi.`KELAS` LIKE '{$model->KELAS}'";
$list = Yii::app()->db->createCommand($sql)->queryAll();
//PENGAJAR
$sql_pengajar = "SELECT * FROM pengajar WHERE TA LIKE '{$model->TA}' AND ID_KUR LIKE '{$model->ID_KUR}' AND KODE_MK LIKE '{$detail->KODE_MK}' ORDER BY ROLE ASC";
$list_pengajar = Yii::app()->db->createCommand($sql_pengajar)->queryAll();
$detail->PIC = $list_pengajar[0]['DOSEN_ID'];
if ($detail->validate()) {
$detail->save();
foreach ($list as $s) {
$daftarhadir = new BeritaAcaraDaftarHadir();
$daftarhadir->ID_DETAIL_JADWAL = $detail->ID;
$daftarhadir->NIM = $s['NIM'];
if ($daftarhadir->validate()) {
$daftarhadir->save();
} else {
echo CHtml::errorSummary($daftarhadir);
}
}
$kuliah = new BeritaAcaraKuliah();
$kuliah->ID_DETAIL_JADWAL = $detail->ID;
$kuliah->TIPE_KULIAH = 1;
if ($kuliah->validate()) {
$kuliah->save();
} else {
echo CHtml::errorSummary($kuliah);
}
} else {
echo CHtml::errorSummary($detail);
}
}
}
}
$this->redirect(array('view', 'id' => $model->ID));
} else {
echo CHtml::errorSummary($model);
}
}
$this->render('createjadwal', array('model' => $model, 'djadwal' => $djadwal, 'kbk' => $kbkmodel));
}
