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