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']); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Mahasiswa::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id]); $query->andFilterWhere(['like', 'nama', $this->nama])->andFilterWhere(['like', 'kata_sandi', $this->kata_sandi])->andFilterWhere(['like', 'nomor_induk_mahasiswa', $this->nomor_induk_mahasiswa])->andFilterWhere(['like', 'fakultas_program_studi', $this->fakultas_program_studi])->andFilterWhere(['like', 'tempat_tanggal_lahir', $this->tempat_tanggal_lahir])->andFilterWhere(['like', 'jenis_kelamin', $this->jenis_kelamin])->andFilterWhere(['like', 'alamat', $this->alamat]); return $dataProvider; }
public function isiKuis($kode_matakuliah) { $nimuser = Sentry::getUser()->nim; $getprofil = Mahasiswa::where('nim', '=', $nimuser)->get()->first(); $pertanyaan = Pertanyaan::all(); $pilihmatkul = DB::table('prodi')->join('mahasiswa', 'prodi.kode_prodi', '=', 'mahasiswa.kode_prodi')->join('krs', 'krs.nim', '=', 'mahasiswa.nim')->join('matakuliah', 'matakuliah.kode_matakuliah', '=', 'krs.kode_matakuliah')->join('jadwal', 'jadwal.id_krs', '=', 'krs.id_krs')->join('dosen', 'dosen.nik', '=', 'jadwal.nik')->join('kelas', 'kelas.idkelas', '=', 'jadwal.idkelas')->where('mahasiswa.nim', '=', $nimuser)->where('matakuliah.kode_matakuliah', '=', $kode_matakuliah)->get(); $datakuesioner = ['getprofil' => $getprofil, 'pertanyaan' => $pertanyaan, 'pilihmatkul' => $pilihmatkul]; // dd($pilihmatkul); if ($pilihmatkul == null) { Session::flash('msge', 'Maaf....<br> Belum ada jadwal pengisian kuesioner untuk matakuliah bersangkutan.'); return Redirect::to('mahasiswa/kuesioner'); } else { return View::make('kuesioner.isiKuis', $datakuesioner); } }
public function addTagihanUKT() { DB::table('Mahasiswa')->update(['Aktif' => 0]); //looping semua mahasiswa $mhs = Mahasiswa::all(); $tgl = Carbon::today(); $smt = $tgl->month > 6 ? 1 : 2; $thn = $smt == 1 ? $tgl->year . $tgl->year + 1 : $tgl->year - 1 . $tgl->year; foreach ($mhs as $mhs) { $tagihan = new Tagihan(); $tagihan->NIM = $mhs->NIM; $tagihan->JenisTagihanID = 1; $tagihan->ThnAkademik = $thn; $tagihan->SmtAkademik = $smt; $tagihan->Nominal = $mhs->ukt->Nominal; $tagihan->save(); } return redirect('tagihan/ukt'); }
public function registermhs() { $rules = array('nim' => 'required', 'first_name' => 'required', 'last_name' => 'required', 'email' => 'required|email', 'password' => 'required|min:5'); $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::to('/')->with('msge', 'Ada kesalahan, silahkan mencoba kembali dan perhatikan ketentuan yang berlaku'); } else { # validasi nim yang tidak terdaftar $in = Input::all(); $maha = new Mahasiswa(); $ceknim = Mahasiswa::find($maha->nim = $in['nim']); # validasi nim yang sudah digunakan $input = Input::get('nim'); $user = DB::table('users')->where('nim', '=', $input)->count(); if (!$ceknim) { return Redirect::to('/')->with('msge', 'NIM anda tidak terdaftar didatabase.'); } elseif ($user >= 1) { return Redirect::to('/')->with('msge', 'NIM anda sudah digunakan untuk daftarkan akun'); } else { try { #mencari group mahasiswa $mahasiswaGroup = Sentry::findGroupByName('mahasiswa'); $mahasiswa = Sentry::register(array('nim' => Input::get('nim'), 'first_name' => Input::get('first_name'), 'last_name' => Input::get('last_name'), 'email' => Input::get('email'), 'password' => Input::get('password')), false); #memasukkan data dalam group $mahasiswa->addGroup($mahasiswaGroup); $emailVariables = ['first_name' => $mahasiswa->first_name, 'email' => $mahasiswa->email, 'code' => $mahasiswa->getActivationCode()]; } catch (Cartalyst\Sentry\Users\UserExistsException $e) { return Redirect::to('/')->with('msge', 'Email anda sudah pernah digunakan, silahkan coba email yang lain.'); } Mail::send('mailTemplate.activation', $emailVariables, function ($pesan) use($mahasiswa) { $pesan->to($mahasiswa->email, $mahasiswa->first_name . ' ' . $mahasiswa->last_name)->subject('Aktifasi akun AKOSTMIK anda :)'); }); return Redirect::to('/')->with('msgs', 'Selamat, anda berhasil mendaftar. Agar bisa login silahkan buka link aktivasi yang kami kirim ke email ' . $mahasiswa->email); } } }
public function detail($nim) { $mahasiswa = Mahasiswa::find($nim); return View::make('mahasiswa.detail')->with('mahasiswa', $mahasiswa); }
/** * Finds the Mahasiswa model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Mahasiswa the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Mahasiswa::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $mahasiswa = Mahasiswa::find($id); return view('Mahasiswa.edit', compact('mahasiswa')); //return $mahasiswa; }