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