/** * 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)); }