} $highestColumn = $worksheet->getHighestColumn(); // e.g 'F' $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); $detail_jadwal; for ($i = 5; $i < 50; $i = $i + 11) { echo "<BR/>"; $masterjadwal = new MJadwal(); $masterjadwal->KELAS = $worksheetTitle; $masterjadwal->WEEK = $worksheet->getCellByColumnAndRow(1, 1)->getValue(); $masterjadwal->TA = $worksheet->getCellByColumnAndRow(1, 2)->getValue(); $masterjadwal->ID_KUR = $worksheet->getCellByColumnAndRow(1, 3)->getValue(); echo $masterjadwal->KELAS . "<BR>"; $masterjadwal->TANGGAL = PHPExcel_Style_NumberFormat::ToFormattedString($worksheet->getCellByColumnAndRow(1, $i)->getValue(), "YYYY-MM-DD"); echo $masterjadwal->TANGGAL; $masterjadwal->save(); for ($j = $i + 2; $j < $i + 10; $j++) { for ($col = 0; $col < $highestColumnIndex; ++$col) { $detail_jadwal[$col] = $worksheet->getCellByColumnAndRow($col, $j)->getValue(); // echo $worksheet->getCellByColumnAndRow($col, $j)->getValue(); // echo "<BR>"; } // $this->cekMaster($masterjadwal); $this->createJadwal($detail_jadwal, $masterjadwal); } } } ?> <?php ?>
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)); }