public function postSimpan(Request $request)
{
$this->validate($request, ['name' => 'required', 'username' => 'required|unique:users', 'email' => 'required|unique:users|email', 'password' => 'required|min:6', 'repassword' => 'required|same:password']);
$User = new User();
$User->name = $request->name;
$User->email = $request->email;
$User->username = $request->username;
$User->password = bcrypt($request->password);
$User->profesi = 'Admin';
$User->save();
$id = $User->id;
$data = new Permissions();
$data->id_user = $id;
$data->blog = 1;
$data->save();
$request->session()->flash('success', 'Berhasil menyimpan pengguna');
return redirect(route('user'));
}
public static function permissionsByUser($userId)
{
$pages = self::orderBy('title', 'ASC')->get();
$noPermission = new Permissions();
foreach ($pages as &$page) {
$permission = Permissions::permissionByUserAndPage($userId, $page->pagesAdminId);
$page->permission = null == $permission ? $noPermission : $permission;
}
return $pages;
}
public function postStore(Request $r)
{
/* Validasi */
// Validasi NIK
$vn = User::where('nik', $r->nik)->count();
if ($vn > 0) {
$r->session()->flash('error_nik', $r->nik);
return redirect()->back()->withInput();
}
// Validasi Jabatan
$vj = DB::table('users as u')->leftJoin('app_kelompok as ak', 'u.id_kelompok', '=', 'ak.id_kelompok')->leftJoin('app_jabatan as aj', 'u.id_jabatan', '=', 'aj.id')->select('u.name', 'ak.nama as nama_kelompok', 'aj.nama as nama_jabatan')->where('ak.id_kelompok', $r->id_kelompok)->where('u.id_jabatan', $r->id_jabatan)->where('aj.nama', '<>', "Anggota")->where('u.profesi', 'Pengolah')->first();
if ($vj) {
$r->session()->flash('gagal', 'GAGAL!!! Jabatan <b>' . $vj->nama_jabatan . '</b> pada kelompok <b>' . $vj->nama_kelompok . '</b> telah ada');
return redirect()->back()->withInput();
exit;
}
/* end validasi */
$pb = new User();
$pb->name = $r->name;
$pb->username = $r->nik;
$pb->email = $r->nik . "@mail.com";
$pb->password = bcrypt($r->nik);
$pb->nik = $r->nik;
$pb->alamat = $r->alamat;
$pb->erte = $r->erte;
$pb->tlp = $r->tlp;
$pb->pos = $r->pos;
$pb->id_kelompok = $r->id_kelompok;
$pb->id_jabatan = $r->id_jabatan;
$pb->id_jenis_olahan = $r->jenis_olahan;
$pb->id_merek_dagang = $r->merek_dagang;
$pb->legalitas_produksi = $r->legalitas_produksi;
$pb->modal_dimiliki = $r->modal_dimiliki;
$pb->modal_pinjaman = $r->modal_pinjaman;
$pb->omzet_perbulan = $r->omzet_perbulan;
$pb->profesi = "Pengolah";
$pb->save();
$id = $pb->id;
// Simpan role
$role = new Permissions();
$role->id_user = $id;
$role->pengolah = 1;
$role->save();
// Simpan sarana
if ($r->id_sarana) {
foreach ($r->id_sarana as $val) {
$record['id_sarana'] = $val;
$record['id_user'] = $id;
$records[] = $record;
}
DB::table('app_kepemilikan_sarana')->insert($records);
}
$r->session()->flash('success', 'Data tersimpan');
return redirect(route('pengolah'));
}
public function run()
{
DB::table('permissions')->delete();
Permissions::create(['id_rl' => 1, 'id_mdl' => 1, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
Permissions::create(['id_rl' => 1, 'id_mdl' => 2, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
Permissions::create(['id_rl' => 1, 'id_mdl' => 3, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
Permissions::create(['id_rl' => 1, 'id_mdl' => 4, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
Permissions::create(['id_rl' => 1, 'id_mdl' => 5, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
Permissions::create(['id_rl' => 2, 'id_mdl' => 2, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
Permissions::create(['id_rl' => 2, 'id_mdl' => 3, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
Permissions::create(['id_rl' => 2, 'id_mdl' => 4, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
Permissions::create(['id_rl' => 2, 'id_mdl' => 5, 'pm_access' => 1, 'pm_create' => 1, 'pm_read' => 1, 'pm_update' => 1, 'pm_destroy' => 1]);
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
// validate
$rules = array('name' => 'required|max:50');
$validator = Validator::make(Input::all(), $rules);
// process the update
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
} else {
// update
$update = Roles::find($id);
$update->rl_name = Input::get('name');
$update->rl_description = Input::get('description');
$update->rl_enabled = Input::get('enabled');
$update->updated_by = \Auth::user()->id;
$update->save();
$usr_role = \Auth::user()->usr_role;
$MdlsCnt = Modules::where('mdl_enabled', 1)->join('permissions', 'permissions.id_mdl', '=', 'modules.id')->where('pm_access', 1)->where('mdl_isadmin', 0)->where('id_rl', $usr_role)->get(['modules.id as id']);
$PreviousPermsDelete = Permissions::where('id_rl', $update->id)->delete();
foreach ($MdlsCnt as $Mdl) {
$permission = new Permissions();
$permission->id_rl = $update->id;
$permission->id_mdl = $Mdl->id;
$permission->pm_access = Input::has('access_' . $Mdl->id) ? '1' : '0';
if (Input::has('access_' . $Mdl->id)) {
$permission->pm_create = Input::has('create_' . $Mdl->id) ? '1' : '0';
$permission->pm_read = Input::has('read_' . $Mdl->id) ? '1' : '0';
$permission->pm_update = Input::has('update_' . $Mdl->id) ? '1' : '0';
$permission->pm_destroy = Input::has('destroy_' . $Mdl->id) ? '1' : '0';
}
$permission->save();
}
// redirect
Session::flash('message', 'Rol Actualizado Con Exito.');
return Redirect::to('roles');
}
}
public function getEdit($id)
{
$data['user'] = User::find($id);
$data['role'] = Permissions::where('id_user', $id)->first();
return view('app.administrator.edit', $data);
}
public function delete(Request $request)
{
if (!ACL::hasPermission('users', 'delete')) {
return redirect(route('users'))->withErrors(['Você não tem permissão para deletar usuários.']);
}
Permissions::deletePermissionByUser($request->get('userId'));
User::find($request->get('userId'))->delete();
$success = "Usuário excluído com sucesso.";
return redirect(route('users'))->with(compact('success'));
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
// validate
$rules = array('name' => 'required|max:50');
if (Input::get('parent') == 0) {
$rules = array_add($rules, 'slug', 'required|min:4|max:50|alpha_dash|unique:modules,mdl_slug');
}
$validator = Validator::make(Input::all(), $rules);
// process the store
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
} else {
// store
$module = new Modules();
$module->mdl_name = Input::get('name');
$module->mdl_slug = Input::get('slug');
$module->mdl_description = Input::get('description');
$module->mdl_enabled = Input::get('enabled');
$module->mdl_menu = Input::get('menu');
$module->mdl_parent = Input::get('parent');
$module->mdl_order = Input::get('order');
$module->mdl_faicon = Input::get('faicon');
$module->mdl_plural = Input::get('plural');
$module->mdl_singular = Input::get('singular');
$module->created_by = \Auth::user()->id;
$module->save();
$Permission = new Permissions();
//Adding permissions auto for SAdmin
$Permission->id_rl = 1;
$Permission->id_mdl = $module->id;
$Permission->pm_access = 1;
$Permission->pm_create = 1;
$Permission->pm_read = 1;
$Permission->pm_update = 1;
$Permission->pm_destroy = 1;
$Permission->save();
// redirect
Session::flash('message', 'Modulo Agregado Con Exito.');
return Redirect::to('modules');
}
}
public static function loadPermissions()
{
Session::set('pagesAdmin', Permissions::getUserPermission());
self::$permissions = Session::get('pagesAdmin');
}
public function delete(Request $request)
{
if (!ACL::hasPermission('users', 'delete')) {
return redirect(route('users'))->withErrors(['You don\'t have permission for delete the users.']);
}
Permissions::deletePermissionByUser($request->get('userId'));
User::find($request->get('userId'))->delete();
$success = "User deleted successfully.";
return redirect(route('users'))->with(compact('success'));
}
