/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$user = User::find($id);
$role = Role::find($user->type);
$roles = Role::all();
return view('user.edit', compact('user', 'role', 'roles'));
}
public function deleteRole()
{
$id = \Input::get('id');
$role = Role::find($id);
$retData['status'] = $role->delete() ? 200 : 500;
return \Response::json($retData);
}
public function revokePermission($id, $permission_id)
{
$role = Role::find($id);
$permission = Permission::find($permission_id);
$role->revokePermission($permission);
return redirect()->back();
}
public function checklogin(Request $request)
{
//print_r($request->all());
$name = $request->get('name');
$code = $request->get('code');
$password = $request->input('password');
if ($code == session('captcha')) {
//$manager = \DB::table('managers')->select('name','password','status')->where('name','=',$name)->get();
$manager = Models\Manager::select('id', 'role_id', 'name', 'password', 'status')->where('name', '=', $name)->first();
if (count($manager) == 1) {
if ($manager->status == 1) {
if ($manager->password == md5(md5($password))) {
session(array('adminid' => $manager->id, 'adminname' => $manager->name));
//获取当前角色拥有的权限并存入session
$role = Models\Role::find($manager->role_id);
$authAllows = array();
foreach ($role->auths as $v) {
$authAllows[] = $v['module_name'] . '.' . $v['controller_name'] . '.' . $v['action_name'];
}
session(array('authAllows' => $authAllows));
return redirect(action('Admin\\IndexController@index'));
} else {
return $this->loginRedirectTo('账号密码错误');
}
} else {
return $this->loginRedirectTo('账号未激活');
}
} else {
return $this->loginRedirectTo('用户不存在');
}
} else {
return $this->loginRedirectTo('验证码不正确');
}
}
public function update($role_id, $name)
{
$role = Role::find($role_id);
$role->name = $name;
$role->save();
return $role;
}
public function delete($id)
{
/* @var Role $role */
$role = Role::find($id);
$role->delete();
return $role;
}
public function getEdit($id)
{
$this->redirectIfCant('edit', '');
$role = Role::find($id);
$menus = Menu::ofParent(null)->sort()->get();
$this->setSubtitle('Detail - ' . $role->display_label);
return $this->render('backend.pages.security.roles.form', compact('menus', 'role'));
}
public function save_per_role()
{
$role = Input::get('role');
$prmission = Input::get('permission');
$rolesP = Role::find(Input::get('role'));
$rolesP->attachPermission(Input::get('permission'));
//return view('assign_per_role');
return redirect()->route('assign_per_role');
}
public function brokers()
{
$category = Role::find(Config::get('constants.ROLE_BROKER'));
$results = Article::where('category_id', '=', $category->id)->paginate(18);
if (Request::ajax()) {
return Response::json(View::make('articles.category')->withResults($results)->render());
}
return View::make('articles.category')->withCategory($category)->withArticles($results);
}
public function getAllRoles()
{
$allRolesobj = Role::find()->select(['RoleId', 'RoleName'])->where(['status' => 'Active'])->all();
$data = ArrayHelper::toArray($allRolesobj, ['RoleId', 'RoleName']);
$roleIdCol = array_column($data, 'RoleId');
$RoleNameCol = array_column($data, 'RoleName');
$RolesData = array_combine($roleIdCol, $RoleNameCol);
return $RolesData;
}
public function IndexAdmin()
{
$opex = Opex::whereYear('fecha', '=', date('Y'))->selectRaw('sum(monto) as monto, fecha as mes')->groupBy(\DB::raw('MONTH(fecha)'))->get();
$alumnos_activos = Role::find(1)->users()->where('cuenta_activa', true)->count();
$alumnos_totales = Role::find(1)->users()->count();
$coachs = Role::find(2)->users()->where('cuenta_activa', true)->count();
$pagos = PagoMensualidad::whereYear('fecha_pago', '=', date('Y'))->selectRaw('sum(monto) as monto, fecha_pago as mes')->groupBy(\DB::raw('MONTH(fecha_pago)'))->get();
return view('admin_home', compact('opex', 'alumnos_activos', 'alumnos_totales', 'pagos', 'coachs'));
}
public static function rolesArrayBuilder()
{
$roles = Role::find()->all();
$rolesIndex = [];
foreach ($roles as $id => $role) {
$rolesIndex[$role->role] = $id + 1;
}
return $rolesIndex;
}
/**
* List all users
*
* @return response
*/
public function usersByRole($role_id)
{
$role = Role::find($role_id);
if ($role === null) {
throw new NotFoundHttpException();
}
$users = User::where('role_id', $role_id)->paginate(config('back.default_pagination'));
return view('backend::user.index', ['users' => $users, 'avatar_path' => config('back.avatar_path')]);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$role = Role::find($id);
if ($role) {
return response()->json(["data" => $role, "result" => "success"], 200);
} else {
return response()->json(["result" => "error"], 200);
}
}
/**
* Delete role
*
* @param int $id
* @throws SaveException
*/
public function delete($id)
{
try {
$role = RoleModel::find($id);
$role->delete();
} catch (Exception $e) {
throw $e;
}
}
public function postUpdate(Request $request, $id)
{
$inputs = $request->all();
$validation = \Validator::make($inputs, $this->model->rules($id));
if ($validation->fails()) {
return redirect()->back()->withErrors($validation)->withInput();
}
Role::find($id)->update($inputs);
return redirect(Helper::urlAction('index'))->withMessage('Data has been Updated');
}
public function destroy($id)
{
$roles = Role::find($id);
if ($roles->id != 1) {
$roles->delete();
return redirect()->action('Admin\\RolesController@index');
} else {
return redirect()->action('Admin\\RolesController@index')->with('error', 'Something went wrong.');
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Role::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'params', $this->params]);
return $dataProvider;
}
public function delete()
{
$roles = Role::find(Input::get('id'));
$getUsers = $roles->users()->get()->toArray();
if (empty($getUsers)) {
$roles->delete();
return redirect()->back()->with("message", "Role deleted sucessfully");
} else {
return redirect()->back()->with("message", "Sorry,You can not delete role!");
}
}
/**
* @return \Illuminate\Http\JsonResponse
*/
public function postStore(Request $request, Registrar $registrar)
{
$is_exist = $this->user->where('email', $request->input('email'))->first();
if ($is_exist) {
return response()->json(['status' => false, 'message' => '邮箱已存在！']);
}
$user = $registrar->create($request->all());
//添加默认用户组
$user->attachRole(Role::find(2));
return response()->json(['status' => $user ? 1 : 0]);
}
/**
* @param $id
* @param bool|false $withPermissions
* @return \Illuminate\Database\Eloquent\Collection|\Illuminate\Database\Eloquent\Model|null
* @throws GeneralException
*/
public function find($id, $withPermissions = false)
{
$role = Role::find($id);
if (!is_null($role)) {
if ($withPermissions) {
return Role::with('permissions')->find($id);
}
return $role;
}
throw new GeneralException('That role does not exist.');
}
public function permissionUpdate(Request $request, $role_id)
{
//删除所有的角色菜单
$role = Role::find($role_id);
$role->menus()->detach();
//添加权限
$menus = $request->input('sys_fun_id');
//dd($menus);
$role->menus()->attach($menus);
flash()->success('操作成功');
return redirect()->back();
}
public function putRemoveroletouser($role_id)
{
$rol = Role::find($role_id);
$user = User::find(Request::input('user_id'));
if (!$user->hasRole($rol->name)) {
abort(400, 'Usuario no tiene ese role para eliminar.');
} else {
$user->detachRole($rol);
$user->save();
}
return $user;
}
/**
* Store a newly created resource in storage.
*
* @param CreateRolePermissionRequest|Requests\CreateRolePermissionRequestRequest $request
* @return Response
*/
public function store(CreateRolePermissionRequest $request)
{
$input = $request->all();
$role = Role::find($input['role_id']);
$permission_array = array();
foreach ($input as $key => $value) {
$permission_array[] = $value;
}
array_shift($permission_array);
array_shift($permission_array);
$role->savePermissions($permission_array);
return redirect('roles');
}
public static function chkPerm($route)
{
$user = \App\Models\User::with('roles')->find(Session::get('loggedinUserId'));
$roles = $user->roles;
$roles_data = $roles->toArray();
$r = \App\Models\Role::find($roles_data[0]['id']);
$per = $r->perms()->get(['name'])->toArray();
if (in_array($route, array_flatten($per))) {
return TRUE;
} else {
return FALSE;
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Role::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Role::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(['like', '_id', $this->_id])->andFilterWhere(['like', 'role_name', $this->role_name])->andFilterWhere(['like', 'status', $this->status])->andFilterWhere(['like', 'remark', $this->remark])->andFilterWhere(['like', 'create_time', $this->create_time])->andFilterWhere(['like', 'update_time', $this->update_time]);
return $dataProvider;
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$user = \Auth::user();
if ($user->role_id != 1) {
$controller = \Request::segment(2);
if (!empty($controller)) {
$cek = Role::find($user->role_id);
if (empty($cek->menus()->whereSlug($controller)->first()->id)) {
return redirect('auth/authorized');
}
}
}
return $next($request);
}
public function store(Request $request)
{
$validator = Validator::make($request->all(), self::validator()['give']['permissions']);
if ($validator->fails()) {
return back()->withErrors($validator)->withInput();
} else {
// return redirect('ratecard')->with('status', 'Successfully add new ratecard');
$user = User::find($request->user_id);
$role = Role::find($request->role);
//$user->role()->attach($role);
$user->roles->save($role);
return view('admin.user.index', compact('data'));
}
}
/**
* The role request validation rules.
*
* @return array
*/
public function rules()
{
$roles = $this->route('roles');
$role = Role::find($roles);
$rules = ['name' => "required|unique:roles,name,{$roles}", 'label' => 'required'];
if ($role instanceof Role && $role->isAdministrator()) {
// If the user is editing an administrator, we need to
// remove the name validation from the request
// because they aren't allowed to edit
// the administrators name.
unset($rules['name']);
}
return $rules;
}
