/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Nilai(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Nilai'])) { $valid = true; foreach ($_POST['Nilai'] as $i => $ii) { $model = new Nilai(); $model->attributes = $_POST['Nilai'][$i]; $model->kode_guru = $_POST['Nilai']['kode_guru']; $model->kode_mapel = $_POST['Nilai']['kode_mapel']; $valid = $model->validate() && $valid; $model->save(); } if ($valid || $model->save()) { $this->redirect(array('nilai/create')); } } $this->render('create', array('model' => $model)); }
public function saveAll($nilais, $dupak_id) { foreach ($nilais as $n) { $nilai = new Nilai(); $nilai->attributes = $n; $nilai->dupak_id = $dupak_id; var_dump($nilai->attributes); if (!$nilai->save()) { return false; } } return true; }
public function actionImportExcel() { error_reporting(E_ALL ^ E_NOTICE); $model = new Nilai(); if (isset($_POST['Nilai'])) { $bulan = date('m'); if ($bulan < 7) { $smt2 = 2; //jika th 2(1-6) maka tahun-1/tahun-2 2012/2013 $th_ajar2 = date('Y') - 1 . '/' . date('Y'); } elseif ($bulan < 13 && $bulan > 6) { $smt2 = 1; //jika th 1(7-12) maka tahun/tahun+1 2012/2013 $th_ajar2 = date('Y') . '/' . (date('Y') + 1); } Yii::import('ext.ocim.excelread.JPhpExcelReader'); $model->attributes = $_POST['Nilai']; if (strlen(trim(CUploadedFile::getInstance($model, 'filee'))) > 0) { //Proses upload dan rename file menjadi Karyawan.xls $unggah = CUploadedFile::getInstance($model, 'filee'); $path = Yii::app()->getBasePath() . '/extensions/ocim/excelread/nilai.xls'; $unggah->saveAs($path); //$data = new Spreadsheet_Excel_Reader($path); $data = new JPhpExcelReader($path); $nis = array(); $kode_mapel = array(); $kode_guru = array(); $kelas = array(); $lokal = array(); $na = array(); $un = array(); $uas = array(); $kurikulum = array(); $th_ajar = array(); $semester = array(); $kodemapel = array(); $setkurikulum = array(); //Pembacaan coloumb ex: A, B, C (Horizontal) for ($j = 1; $j <= $data->sheets[0]['numRows']; $j++) { //nama sheet(dimulai dari 0,1,dst) | array (jumlah row yang dibaca. Vertikal) | coloumb ke.. (Horizontal) $nis[$j] = $data->sheets[0]['cells'][$j][2]; //Ini 2 $kelas[$j] = $data->sheets[0]['cells'][$j][4]; //Ini 4 $lokal[$j] = $data->sheets[0]['cells'][$j][5]; //Ini 5 $kode_mapel[$j] = $data->sheets[0]['cells'][$j][6]; //ini 6 $na[$j] = $data->sheets[0]['cells'][$j][7]; //Ini 7 $un[$j] = $data->sheets[0]['cells'][$j][8]; //Ini 8 $uas[$j] = $data->sheets[0]['cells'][$j][9]; //Ini 9 $th_ajar[$j] = $th_ajar2; $semester[$j] = $smt2; $kodemapel[$j] = Yii::app()->user->id; $setkurikulum[$j] = Yii::app()->db->createCommand("select kurikulum from jadwal where kode_guru='" . Yii::app()->user->id . "' limit 1;")->queryScalar(); } $aku = $data->rowcount(0); $rowExist = array(); //try { //if($aku){ //mengambil data dari row ke A2 ke bawah sampai data file habis karena di baca oleh variabel aku dengan sintaks "rowcount" (menghitung jumlah row yang ada isinya) for ($i = 2; $i <= $aku; $i++) { $isExist = Nilai::model()->exists(array('condition' => 'nis = :nis AND kode_mapel = :kode_mapel AND th_ajar = :th_ajar AND semester = :semester', 'params' => array(':nis' => (string) $nis[$i], ':kode_mapel' => $kode_mapel[$i], ':th_ajar' => $th_ajar[$i], ':semester' => (string) $semester[$i]))); if ($isExist) { $rowExist[] = array('nis' => $nis[$i], 'kode_mapel' => $kode_mapel[$i], 'th_ajar' => $th_ajar[$i], 'semester' => $semester[$i]); $a = 0; } else { $model = new Nilai(); $model->nis = $nis[$i]; //2 $model->kelas = $kelas[$i]; //4 $model->lokal = $lokal[$i]; //5 $model->kode_mapel = $kode_mapel[$i]; //6 $model->na = $na[$i]; //7 $model->un = $un[$i]; //8 $model->uas = $uas[$i]; //9 $model->th_ajar = $th_ajar[$i]; $model->semester = $semester[$i]; //Deklarasi default $model->kode_guru = $kodemapel[$i]; $model->kurikulum = $setkurikulum[$i]; /*echo "<pre>"; print_r($model->getAttributes()); echo "</pre>"; die();*/ $model->save(); } } if ($a == 0) { Yii::app()->user->setFlash('error', '<strong>Beberapa data sudah ada dalam database.</strong> Silahkan periksa kembali.'); //$this->redirect(array('admin')); } else { Yii::app()->user->setFlash('success', 'Data <strong>berhasil</strong> di unggah. Terima kasih'); } unlink($path); //} /*} catch(CDbException $e) { Yii::app()->user->setFlash('warning', '<strong>Data sudah ada dalam database.</strong> Silahkan periksa kembali.'); $model->addError(null, "Data sudah ada dalam database. Silahkan periksa kembali"); }*/ } else { Yii::app()->user->setFlash('error', 'Data <strong>gagal</strong> di unggah. Silahkan periksa file anda.'); } } $this->render('ImportExcel', array('model' => $model, 'rowExist' => $rowExist)); }
/** * @param int * @param string * @param string * @param int * @param string * @param float * @param string * @param string * @param int * @param int * @param string * @param string * @param string * @param string * @param int * @param string * @param string * @soap */ public function insertNewNilai($id_kur, $kode_mk, $ta, $sem_ta, $nim, $na, $nilai, $kelas, $sks, $sem, $wali_approval, $dir_approval, $dosen_approval, $keterangan, $last_update, $user_id, $ws) { $model = new Nilai(); $model->ID_KUR = $id_kur; $model->KODE_MK = $kode_mk; $model->TA = $ta; $model->SEM_TA = $sem_ta; $model->NIM = $nim; $model->NA = $model->NA; $model->NILAI = $nilai; $model->KELAS = $kelas; $model->SKS = $sks; $model->SEM = $sem; $model->WALI_APPROVAL = $wali_approval; $model->DIR_APPROVAL = $dir_approval; $model->DOSEN_APPROVAL = $dosen_approval; $model->KETERANGAN = $keterangan; $model->LAST_UPDATE = $last_update; $model->USER_ID = $user_id; $model->WS = $ws; $model->save(); }
public function actionNilai() { $mahasiswa = Mahasiswa::model()->findAll(); $error = false; foreach ($mahasiswa as $mhs) { if (isset($_POST[$mhs->NIM])) { foreach ($_POST[$mhs->NIM] as $mk => $value) { $nilai = Nilai::model()->findByAttributes(array('NIM' => $mhs->NIM, 'kode_mk' => $mk)); if ($nilai) { $input = $nilai; } else { $input = new Nilai(); $input->NIM = $mhs->NIM; $input->kode_mk = $mk; } $input->Nilai = $value; if (!$input->save()) { $error = true; } } } if (!$error) { Yii::app()->user->setFlash('status', '<div class="alert alert-success">Data telah Tersimpan</div>'); } else { Yii::app()->user->setFlash('status', '<div class="alert alert-success">Data Gagal Tersimpan</div>'); } } $this->render('nilai', array('mahasiswa' => $mahasiswa)); }