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