/**
* 获取管理员
*
* @date 2015-10-17
* @version [version]
* @return [type] [description]
*/
public function admin()
{
if ($this->category == 1) {
return Admin::where('user_id', $this->id)->first();
}
return null;
}
/**
* Create a new admin level user.
*
* @param Request $request
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
*/
public function createNewAdmin(Request $request)
{
$data = $request->all();
$adminUser = User::where('role', 'admin')->first();
$admin = Admin::where('email', $adminUser->email)->first();
// Edit the admin account details
$admin->email = $data['email'];
$ts = $admin->last_login_ts;
$admin->delete();
// Edit admin details in the login table
$adminUser->email = $data['email'];
$adminUser->save();
// Create new Admin entry for the above user
Admin::create(['email' => $data['email'], 'last_login_ts' => $ts]);
/*// Create new User
User::create([
'email' => $data['email'],
'password' => bcrypt($data['password']),
'role' => "admin"
]);*/
// Send notification mail to the newly created Admin.
Mail::send('emails.newAdmin', [], function ($message) use($data) {
$message->from(env('MAIL_FROM'), env('MAIL_NAME'));
$message->to($data['email'])->subject('Welcome to the team!');
});
return redirect('admin_users')->with('status', 'Email Account changed.');
}
/**
* 检查登录是否成功
*
* @date 2015-10-09
* @return [type] [description]
*/
public function checkLogin()
{
if (!Request::has('username', 'password')) {
return failure('请输入用户名或密码');
}
// $rules = [
// 'captcha' => 'required|captcha',
// ];
// $validator = Validator::make(Request::all(), $rules);
// if ($validator->fails()) {
// return $this->failure('验证码错误');
// }
$admin = Admin::where('username', Request::input('username'))->first();
if (!$admin) {
return failure('用户不存在');
}
if (!Hash::check(Request::input('password'), $admin->password)) {
return failure('用户名或密码错误');
}
$admin->increment('sign_in_cnt');
$admin->last_sign_in_at = Carbon::now();
$admin->last_sign_in_ip = Request::getClientIp();
$admin->save();
Auth::loginUsingId($admin->user_id);
return success('登录成功');
}
public function isAdmin($id)
{
$admin = Admin::where('id_user', '=', $id)->first();
if ($admin == null) {
return 0;
}
return 1;
}
protected static function user()
{
if (session(config('app.admin_session'))) {
return Admin::where('username', session(config('app.admin_session')))->first();
} else {
return false;
}
}
public static function isAdmin($user)
{
$isUser = Admin::where("id", "=", $user->id)->get();
if (sizeof($isUser) > 0) {
return true;
} else {
return false;
}
}
public function adminAuthroized(User $user)
{
$admin = Admin::where('id', $user->id)->first();
if ($admin) {
// 登陆且为管理员, 授权成功
return true;
} else {
return false;
}
}
public function postSuperadmin(Request $request)
{
$admin = Admin::all();
$superadmin = $admin[1]->role;
$password = $request->get('password');
$login = Admin::where('role', '=', $superadmin)->where('password', '=', $password)->first();
if ($login) {
return redirect('/admission/feestructure');
}
return redirect('/admin/superadmin')->with('message', 'Incorrect Password');
}
public function updateAdmin(Request $request, $id)
{
$admin = Admin::findOrFail($id);
$format_tgl_info_old = Input::get('tanggal_lahir');
$this->validate($request, ['nama_admin' => 'required', 'nik' => 'required|max:16|min:16', 'jenis_kelamin' => 'required', 'tanggal_lahir' => 'required', 'alamat' => 'required', 'telepon' => 'required', 'email' => 'required']);
$input = $request->all();
$admin->fill($input)->save();
Admin::where('id', $id)->update(array('tanggal_lahir' => date("Y-m-d", strtotime($format_tgl_info_old))));
Session::flash('edit_message', 'Admin ' . $id . ' berhasil dimutakhirkan!');
return redirect(action('UsersController@editAdmin', $admin->id));
}
public static function attempt($email, $password)
{
if (Admin::where('email', '=', $email)->count() > 0) {
$user = Admin::where('email', '=', $email)->firstOrFail();
if (Hash::check($password, $user->password)) {
return $user;
}
return null;
} else {
return null;
}
}
public function attempt($data)
{
$where = array();
$password = $data['password'];
unset($data['password'], $data['_token']);
$result = Admin::where($data)->first();
if (Hash::check($password, $result['password'])) {
$this->setSession($result->id);
return true;
}
return false;
}
public function addVideo($ev)
{
//returns create view.
$rsvp = Rsvp::where('eventid', $ev)->where('userid', Auth::user()->id)->get();
$admin = Admin::where('userid', Auth::user()->id)->get();
// Checks if the user is either an admin and/or attended the past event
//If true then the user can post videos
//Else redirect them
if ($rsvp || $admin) {
if (Event::where('id', $ev)->onlyTrashed()->firstorfail()) {
return view('addVideo', ['ev' => $ev]);
}
} else {
return redirect('past');
}
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
if (Session::has('ADMIN_ACCESS_ID')) {
$admin_id = Session::get('ADMIN_ACCESS_ID');
$adminList = Admin::where("id", "=", $admin_id)->get();
if ($adminList[0]->image != '') {
$adminProfileImg = \Config::get('constants.ADMIN_PROFILE_TH_IMG_PATH') . $adminList[0]->image;
} else {
$adminProfileImg = \Config::get('constants.ADMIN_DEFAULT_PICTURE');
}
\Config::set('constants.ADMIN_PROFILE_PICTURE', $adminProfileImg);
} else {
return redirect('/admin');
}
return $next($request);
}
public function postAdminLogin(Request $request)
{
$admin = Admin::where('role', '=', 'admin')->first();
//encrypt and hash method from framework is a one way hash and dynamic value
$admin_email = Input::get('email');
$admin_password = sha1(Input::get('password'));
if ($admin->email != $admin_email || $admin->password != $admin_password) {
return Redirect::action('AdminController@getAdminLogin')->with('error_message', 'Your email / password is incorrect');
} else {
//store a session in a variable
$request->session()->put('email', $admin_email);
return Redirect::action('AdminController@index');
//retrive a session and put it into a variable
//$value = $request->session()->get('email', 'default');
}
}
public function auth(Request $request)
{
$username = $request->get('username');
$password = $request->get('password');
if ($username == env('ADMIN_USERNAME') && $password == env('ADMIN_PASSWORD')) {
Session::put('super_admin', $username);
Session::put('admin_team', 'all');
return redirect('/admin/create');
} else {
$admin = Admin::where('username', $username)->where('password', $password)->first();
if ($admin) {
Session::set('admin_team', $admin->team);
return Redirect::to("/admin/{$admin->team}");
} else {
return Redirect::to('/admin')->with('message', '<font color="red">Incorrect username or password</font>');
}
}
}
public function login(Request $request)
{
$validator = Validator::make($request->all(), ['username' => 'required', 'password' => 'required']);
if ($validator->fails()) {
session()->flash('message', 'Please fill in all the details');
return redirect()->back();
} else {
$credentials = ['username' => $request->input('username'), 'password' => $request->input('password')];
$auth = Admin::where('username', $credentials['username'])->where('password', sha1($credentials['password']))->first();
if ($auth) {
$request->session()->put('username', $credentials['username']);
return view('admin.home')->with('requirements', $requirements);
} else {
session()->flash('message', 'Username or Password is incorrect!');
return redirect()->back();
}
}
}
/**
* Redirect a logged in user to the appropriate start page depending on the role.
* @link https://laracasts.com/discuss/channels/laravel/how-best-to-redirect-admins-from-users-after-login-authentication
*
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
*/
protected function authenticated()
{
if (Auth::check()) {
if (Auth::user()->role == "admin") {
// If user is an admin, last_login_ts field in ADMIN table is updated
Admin::where('email', Auth::user()->email)->update(['last_login_ts' => Carbon::now()]);
return redirect()->intended('admin');
} else {
$user_email = Auth::user()->email;
$block_status = Customer::where('email', $user_email)->first()->block_status;
// If user has been blocked, user is redirected to a page announcing so.
if ($block_status == $this->blocked_true) {
Auth::logout();
return redirect('blocked_user');
} else {
return redirect()->intended('/');
}
}
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index(CookieJar $cookieJar, Request $request)
{
if (Session::has('ADMIN_ACCESS_ID')) {
return redirect('admin/dashboard');
}
if ($request->isMethod('post')) {
$admin_email = $request->get('admin_email');
$admin_password = $request->get('admin_password');
$checkAgentExists = Admin::where("email", "=", $admin_email);
$checkAgentExists = $checkAgentExists->get();
if ($request->get('remember_login')) {
$cookieJar->queue(Cookie::make('admin_email', $admin_email, 60));
$cookieJar->queue(Cookie::make('admin_password', $admin_password, 60));
} else {
$cookieJar->queue(Cookie::forget('admin_email'));
$cookieJar->queue(Cookie::forget('admin_password'));
}
if (count($checkAgentExists) > 0) {
if (Hash::check($admin_password, $checkAgentExists[0]->password)) {
Session::put('ADMIN_ACCESS_ID', $checkAgentExists[0]->id);
Session::put('ADMIN_ACCESS_FNAME', $checkAgentExists[0]->first_name);
Session::put('ADMIN_ACCESS_LNAME', $checkAgentExists[0]->last_name);
return redirect::route('dashboard');
} else {
return redirect::route('admin')->with('errorMessage', 'Invalid password provided.');
}
} else {
return redirect::route('admin')->with('errorMessage', 'Invalid email address or/and password provided.');
}
}
$data = array();
$data['admin_email'] = '';
$data['admin_password'] = '';
$admin_email = Cookie::get('admin_email');
$admin_password = Cookie::get('admin_password');
if ($admin_email && $admin_password) {
$data['admin_email'] = $admin_email;
$data['admin_password'] = $admin_password;
}
return view('admin/login', $data);
}
public function login(Request $request)
{
if ($request->isMethod('GET')) {
return view('admin/login');
} else {
if ($request->isMethod('POST')) {
$validator = Validator::make($request->all(), ['username' => 'required', 'password' => 'required']);
$validator->after(function ($validator) use($request) {
if (!Admin::where('username', $request->username)->where('password', $request->password)->first()) {
$validator->errors()->add('login', 'The credentials you provided are incorrect');
}
});
if ($validator->fails()) {
return redirect('/admin/login')->withErrors($validator, 'login');
} else {
$admin = Admin::where('username', $request->username)->where('password', $request->password)->first();
Session::put('admin', true);
return redirect('/admin/home');
}
}
}
}
public function doLogin(Request $request)
{
if (empty($request->input('username'))) {
$error_msg = "The username field can't be blank";
} else {
if (empty($request->input('password'))) {
$error_msg = "The password field can't be blank";
} else {
$admin = Admin::where('username', $request->input('username'))->first();
if ($admin) {
if ($admin->password === md5($request->input('password'))) {
session([config('app.admin_session') => $admin->username]);
return redirect('/admin');
} else {
$error_msg = "The user doesn't match the password";
}
} else {
$error_msg = "The username doesn't exist";
}
}
}
return redirect()->back()->withErrors($error_msg);
}
public function foundAdminWithEmail()
{
$output = new \Symfony\Component\Console\Output\ConsoleOutput(2);
// Getting all post data
$email = Input::get('email');
$column = 'email';
// This is the name of the column you wish to search
$n = Admin::where($column, '=', $email)->count();
$output->writeln($n);
$result = null;
if ($n > 0) {
$result = 'Email sudah terdaftar';
} else {
$output->writeln('else');
}
echo json_encode($result);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$data = Employee::find($id);
$province = Province::all();
$cities = City::all();
$citmin = City::whereRaw('id = (select min(`id`) from cities)')->get();
$citmax = City::whereRaw('id = (select max(`id`) from cities)')->get();
$grade = Grade::all();
$jabatans = Jabatan::all();
$pt = array('sd' => 'SD', 'smp' => 'SMP', 'sma' => 'SMA', 'd3' => 'D3', 's1' => 'S1', 'S2' => 'S2');
$citsel = unserialize($data->id_cities);
$tls = Teamleader::where('id_users', $data->id)->get();
$pos = ProjectOfficer::where('id_users', $data->id)->get();
$adms = Admin::where('id_users', $data->id)->get();
return view('dropmin/data/edit')->with('data', $data)->with('province', $province)->with('grade', $grade)->with('tls', $tls)->with('pos', $pos)->with('adms', $adms)->with('jabatans', $jabatans)->with('pt', $pt)->with('citsel', $citsel)->with('cities', $cities);
}
/**
* Updates the admin column of the user table to 0 for a given user.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function demote($id)
{
Admin::where('userid', $id)->delete();
return redirect('admin/manage');
}
public function adminDelete()
{
$request = Request::all();
$id = $request['id'];
$username = $request['username'];
$deletedRows = Admin::where('id', $id)->where('username', $username)->delete();
return $deletedRows;
}
public function home()
{
$id_pasien = Input::get('id_pasien');
$id_bpjs = Input::get('id_bpjs');
if (isset($id_pasien) and empty($id_bpjs)) {
$pasien = Pasien::where('id', '=', $id_pasien)->get();
$pasienid = DB::table('pasien')->where('id', $id_pasien)->value('id');
$pasienexists = Pasien::where('id', $id_pasien)->count();
if ($pasienexists == 1) {
$info = "Pasien ditemukan";
$tambah = true;
} else {
$info = "Pasien tidak ditemukan";
$tambah = false;
}
if ($tambah) {
$poli = Poli::all();
return view('dashboard.tambah-ke-poli')->with('pasienid', $pasienid)->with('poli', $poli);
} else {
return view('dashboard.home')->with('pasien', $pasien)->with('info', $info)->with('tambah', $tambah)->with('pasienid', $pasienid);
}
return view('dashboard.tambah-ke-poli')->with('pasien', $pasien)->with('info', $info)->with('tambah', $tambah);
} else {
if (isset($id_bpjs) and isset($id_pasien)) {
$pasien = Pasien::where('id', '=', $id_pasien)->get();
$bpjs = BPJS::where('id', '=', $id_bpjs)->get();
$pasieninfo = DB::table('pasien')->where('id', $id_pasien)->value('nik');
$bpjsinfo = DB::table('bpjs')->where('id', $id_bpjs)->value('nik');
$bpjsstatus = DB::table('bpjs')->where('id', $id_bpjs)->value('status_premi');
$bpjsexists = BPJS::where('id', $id_bpjs)->count();
$pasienexists = Pasien::where('id', $id_pasien)->count();
$pasienid = DB::table('pasien')->where('id', $id_pasien)->value('id');
$bpjsid = BPJS::where('id', $id_bpjs)->value('id');
if ($pasienexists == 1) {
if ($bpjsexists == 1) {
if ($bpjsstatus == 0) {
$info = "BPJS tidak aktif";
$tambah = false;
} else {
if ($pasieninfo == $bpjsinfo) {
$info = "Data sama";
$tambah = true;
} else {
$info = "Data tidak sama";
$tambah = false;
}
}
} else {
$info = "BPJS tidak ditemukan";
$tambah = false;
}
} else {
$info = "Pasien tidak ditemukan";
$tambah = false;
}
if ($tambah) {
$poli = Poli::all();
return view('dashboard.tambah-ke-poli')->with('pasienid', $pasienid)->with('bpjsid', $bpjsid)->with('poli', $poli);
} else {
return view('dashboard.home')->with('pasien', $pasien)->with('bpjs', $bpjs)->with('info', $info)->with('tambah', $tambah)->with('pasienid', $pasienid)->with('bpjsid', $bpjsid);
}
} else {
if (empty($id_bpjs) and empty($id_pasien)) {
//if form is still empty
if (Auth::user()->is('dokter')) {
$email = Auth::user()->email;
$id_dokter = Dokter::where('email', $email)->value('id');
$temp = RMTemp::where('id_dokter', $id_dokter)->where('status_cek', 0)->get();
} else {
if (Auth::user()->is('admin')) {
$email = Auth::user()->email;
$id_admin = Admin::where('email', $email)->value('id');
$temp = RMTemp::where('id_admin', $id_admin)->where('status_cek', 1)->get();
}
}
if (isset($temp) and count($temp) > 0) {
return view('dashboard.home')->with('temp', $temp);
} else {
return view('dashboard.home');
}
}
}
}
}
public function addAjuanBubar(CreateAjuanBubarRequest $request)
{
$request->file('file')->move(public_path('upload/ajuan'), $request->file('file')->getClientOriginalName());
$r = $request->except('file');
$r['file'] = $request->file('file')->getClientOriginalName();
$pengguna = Admin::where('nik', $r['id_pengaju'])->first();
if (!is_null($pengguna)) {
$ajuan = new Ajuan();
$ajuan->fill($r);
$ajuan->id = NULL;
$ajuan->id_staff = NULL;
$ajuan->jenis_ajuan = 'Pembubaran';
$ajuan->jenis_koperasi = Koperasi::getJenisByNama(Input::get('nama_koperasi'));
$ajuan->status = 'Sedang Diproses';
$ajuan->save();
return redirect()->back()->with('message', 'Ajuan berhasil dikirimkan');
} else {
return redirect()->back()->with('messagefail', 'The input ID is not valid')->withInput(Input::except('id_pengaju'));
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
// Start Check Authorization
/**
* 1. FullAccess - 1
* 2. HRD - 3
* 3. Creator - 5
* 4. Handler - 7
*/
$invalid_auth = 1;
$authRole = Auth::user()->UserRoles->role;
if ($authRole == 7 or $authRole == 1 or $authRole == 3) {
$invalid_auth = 0;
}
if ($invalid_auth == 1) {
Alert::error('Anda tidak memilik akses ini')->persistent('close');
return redirect('data/list');
}
// End Check Authorization
$data = Employee::find($id);
$province = Province::all();
$cities = City::all();
$citmin = City::whereRaw('id = (select min(`id`) from cities)')->get();
$citmax = City::whereRaw('id = (select max(`id`) from cities)')->get();
$grade = Grade::all();
$jabatans = Jabatan::all();
$pt = array('sd' => 'SD', 'smp' => 'SMP', 'sma' => 'SMA', 'd3' => 'D3', 's1' => 'S1', 'S2' => 'S2');
$citsel = unserialize($data->id_cities);
$tls = Teamleader::where('id_users', $data->id)->get();
$pos = ProjectOfficer::where('id_users', $data->id)->get();
$adms = Admin::where('id_users', $data->id)->get();
return view('dropmin/data/edit')->with('data', $data)->with('province', $province)->with('grade', $grade)->with('tls', $tls)->with('pos', $pos)->with('adms', $adms)->with('jabatans', $jabatans)->with('pt', $pt)->with('citsel', $citsel)->with('cities', $cities);
}
public function update(Request $request, $id, $id_dokter, $kode_visit)
{
if (Input::get('ok')) {
RMTemp::where('id', $id)->where('id_dokter', $id_dokter)->where('kode_visit', $kode_visit)->delete();
$updateRM = ['status_validasi' => 1];
$rekamMedik = RekamMedik::where('id', $id)->where('id_dokter', $id_dokter)->where('kode_visit', $kode_visit)->update($updateRM);
return redirect('dashboard');
}
//fetch the data from the form first
$rekamMedik = RekamMedik::where('id', $id)->where('id_dokter', $id_dokter)->where('kode_visit', $kode_visit)->get()->first();
$kode_visit = $request->input('kode_visit');
$this->validate($request, ['id' => 'required', 'id_dokter' => 'required', 'usia_berobat' => 'required', 'tgl_visit' => 'required', 'diagnosis' => 'required', 'tindakan' => 'required']);
$format_tgl_info_old = Input::get('tgl_visit');
//then check the type of user trying to update the data
if (Auth::user()->is('admin')) {
$updateRM = ['status_validasi' => 0];
$kode_visit = $request->kode_visit;
$id_dokter = $request->id_dokter;
RekamMedik::where('id', $id)->where('id_dokter', $id_dokter)->where('kode_visit', $kode_visit)->update($updateRM);
//fetch email from admin
$email = Auth::user()->email;
$id_admin = Admin::where('email', $email)->value('id');
$temp = RMTemp::create(['id' => $request->input('id'), 'kode_visit' => $request->input('kode_visit'), 'id_dokter' => $request->input('id_dokter'), 'usia_berobat' => $request->input('usia_berobat'), 'tgl_visit' => date("Y-m-d", strtotime($format_tgl_info_old)), 'tinggi_badan' => $request->input('tinggi_badan'), 'berat_badan' => $request->input('berat_badan'), 'tekanan_darah' => $request->input('tekanan_darah'), 'resep' => $request->input('resep'), 'anamnesis' => $request->input('anamnesis'), 'diagnosis' => $request->input('diagnosis'), 'tindakan' => $request->input('tindakan'), 'id_admin' => $id_admin]);
Session::flash('message', 'Permintaan pengubahan record rekam medik akan diproses! Silahkan menunggu konfirmasi dari dokter yang bersangkutan!');
return redirect('rekam-medik');
} else {
if (Auth::user()->is('super.user')) {
$format_tgl_info_old = Input::get('tgl_visit');
$updateRM = ['usia_berobat' => $request->input('usia_berobat'), 'tgl_visit' => date("Y-m-d", strtotime($format_tgl_info_old)), 'tinggi_badan' => $request->input('tinggi_badan'), 'berat_badan' => $request->input('berat_badan'), 'tekanan_darah' => $request->input('tekanan_darah'), 'resep' => $request->input('resep'), 'anamnesis' => $request->input('anamnesis'), 'diagnosis' => $request->input('diagnosis'), 'tindakan' => $request->input('tindakan')];
RekamMedik::where('id', $id)->where('id_dokter', $id_dokter)->where('kode_visit', $kode_visit)->update($updateRM);
Session::flash('message', 'Rekam Medik ' . $id . '-' . $id_dokter . '-' . $kode_visit . ' berhasil dimutakhirkan!');
// return redirect(action('RekamMedikController@edit', $rekamMedik->id, $rekamMedik->kode_visit));
return redirect('rekam-medik');
}
}
return view('rekam-medik');
}
/**
* Créer une liste d'utilisateurs non administrateur
*
* @return array
*/
public function loadListUserNonAdmin()
{
$listeAllUser = User::all();
$listeUser = [];
foreach ($listeAllUser as $user) {
$alreadyAdmin = Admin::where(['email' => $user['email'], 'delete' => 0]);
if ($alreadyAdmin->count() == 0) {
$listeUser[] = $user;
}
}
return $listeUser;
}
