public function actionCreate() { $Orang = new Orang(); $Mahasiswa = new Mahasiswa(); $MhsDoktor = new MhsDoktor(); // Uncomment the following line if AJAX validation is needed $this->performAjaxValidation(array($Orang, $MhsDoktor)); //$this->performAjaxValidation($MhsDoktor); if (isset($_POST['Orang'], $_POST['MhsDoktor'])) { $Orang->attributes = $_POST['Orang']; $MhsDoktor->attributes = $_POST['MhsDoktor']; //validate both $valid = $Orang->validate(); $valid = $MhsDoktor->validate() && $valid; if ($valid) { //use false param to disabel validation $Orang->save(false); $Mahasiswa->ID = $Orang->ID; $Mahasiswa->save(false); $MhsDoktor->ID = $Mahasiswa->ID; $MhsDoktor->save(false); //redirect //die("Sukses nyimpan"); $this->redirect(array('view', 'id' => $Orang->ID)); } } $this->render('create', array('Orang' => $Orang, 'MhsDoktor' => $MhsDoktor)); }
public function actionImport() { $field = ['fileImport' => 'File Import']; $modelImport = DynamicModel::validateData($field, [[['fileImport'], 'required'], [['fileImport'], 'file', 'extensions' => 'xls,xlsx', 'maxSize' => 1024 * 1024]]); if (Yii::$app->request->post()) { $modelImport->fileImport = \yii\web\UploadedFile::getInstance($modelImport, 'fileImport'); if ($modelImport->fileImport && $modelImport->validate()) { $inputFileType = \PHPExcel_IOFactory::identify($modelImport->fileImport->tempName); $objReader = \PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcel = $objReader->load($modelImport->fileImport->tempName); $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true); $baseRow = 2; while (!empty($sheetData[$baseRow]['A'])) { $model = new Mahasiswa(); $model->nama = (string) $sheetData[$baseRow]['B']; $model->nim = (string) $sheetData[$baseRow]['C']; $model->save(); //die(print_r($model->errors)); $baseRow++; } Yii::$app->getSession()->setFlash('success', 'Success'); } else { Yii::$app->getSession()->setFlash('error', 'Error'); } } return $this->redirect(['index']); }
$app->get('/halo(/:nama)', function ($nama = null) { echo "Hallo " . $nama . "!"; }); $app->get('/home(/:nama)', function ($nama = null) use($app) { $app->view()->appendData(array('nama' => $nama)); $app->render("home.php"); }); $app->get('/show', function () use($app) { // with activerecord // $data = Mahasiswa::all(); // echo json_encode(array_map(function($res){ // return $res->to_array(); // },$data)); // // with elequent echo Mahasiswa::all()->toJson(); }); $app->post('/insert', function () use($app) { $mhs = new Mahasiswa(); $mhs->nama = $app->request->post('nama'); echo $mhs->save(); }); $app->put('/update/:kode', function ($kode) use($app) { $mhs = Mahasiswa::find($kode); $mhs->nama = $app->request->put('nama'); echo $mhs->save(); }); $app->delete('hapus/:kode', function ($kode) use($app) { echo Mahasiswa::find($kode)->delete(); }); $app->run();
public function actionDatamahasiswa() { $mahasiswa = new Mahasiswa(); if (isset($_POST['Mahasiswa'])) { $mahasiswa->NIM = $_POST['Mahasiswa']['NIM']; $mahasiswa->Nama_lengkap = $_POST['Mahasiswa']['Nama_lengkap']; $mahasiswa->Jenis_kelamin = $_POST['Mahasiswa']['Jenis_kelamin']; $mahasiswa->Tempat_lahir = $_POST['Mahasiswa']['Tempat_lahir']; $date = date_create($_POST['Mahasiswa']['Tanggal_lahir']); $mahasiswa->Tanggal_lahir = date_format($date, 'Y-m-d'); $mahasiswa->Nama_orangtua = $_POST['Mahasiswa']['Nama_orangtua']; $mahasiswa->Pekerjaan_orangtua = $_POST['Mahasiswa']['Pekerjaan_orangtua']; $mahasiswa->Alamat_orangtua = $_POST['Mahasiswa']['Alamat_orangtua']; $mahasiswa->Kota_orangtua = $_POST['Mahasiswa']['Kota_orangtua']; $mahasiswa->Profinsi_orangtua = $_POST['Mahasiswa']['Profinsi_orangtua']; $mahasiswa->Tahun_masuk = $_POST['Mahasiswa']['Tahun_masuk']; $mahasiswa->Jurusan = "Teknik Informatika"; $mahasiswa->Pendidikan_terakhir = $_POST['Mahasiswa']['Pendidikan_terakhir']; $mahasiswa->Alamat_dmalang = $_POST['Mahasiswa']['Alamat_dmalang']; $mahasiswa->Alamat_asal = $_POST['Mahasiswa']['Alamat_asal']; $mahasiswa->No_tlp = $_POST['Mahasiswa']['No_tlp']; $mahasiswa->Email = $_POST['Mahasiswa']['Email']; if ($mahasiswa->save()) { $user = new User(); $user->username = $mahasiswa->NIM; $user->password = md5($mahasiswa->NIM); $user->Level = 'mahasiswa'; $user->status = '1'; $user->id_user = $mahasiswa->id_mahasiswa; if ($user->save()) { Yii::app()->user->setFlash('status', '<div class="alert alert-success">Data telah Tersimpan</div>'); } else { Yii::app()->user->setFlash('status', '<div class="alert alert-danger">gagal jadi mahasiswa </div>'); } } else { Yii::app()->user->setFlash('status', '<div class="alert alert-danger">gagal jadi mahasiswa </div>'); } } $user = User::model()->findAllByAttributes(array('Level' => 'mahasiswa')); if (isset($_POST['status'])) { foreach ($_POST['status'] as $status => $value) { $konvirmasi = User::model()->findByPk($status); if ($value == 'on') { $konvirmasi->status = '1'; } else { $konvirmasi->status = '0'; } if ($konvirmasi->save()) { 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>'); } } } $upload = new Item(); if (isset($_POST['Item'])) { $upload->attributes = $_POST['Item']; $upload->sql = CUploadedFile::getInstance($upload, 'file'); $upload->sql->saveAs('D:/' . $upload->sql); if (DLDatabaseHelper::import('D:/' . $upload->sql)) { 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('datamahasiswa', array('user' => $user, 'mahasiswa' => $mahasiswa, 'upload' => $upload)); }