Example #1
0
 public function deleteRole(Request $request)
 {
     $data = $request->all();
     DB::beginTransaction();
     try {
         UserRoleRight::where(['ROLE_ID' => $data['ID']])->delete();
         UserUserRole::where(['ROLE_ID' => $data['ID']])->delete();
         UserRole::where(['ID' => $data['ID']])->delete();
     } catch (\Exception $e) {
         DB::rollback();
     }
     DB::commit();
     $userRole = UserRole::where(['ACTIVE' => 1])->get(['ID', 'NAME']);
     return response()->json(array('userRole' => $userRole));
 }
Example #2
0
File: User.php Project: hunglmtb/eb
 public function hasRole($roleCode)
 {
     if ($this->ID) {
         $user_user_role = UserUserRole::getTableName();
         $user_role = UserRole::getTableName();
         $rows = UserUserRole::join($user_role, "{$user_user_role}.ROLE_ID", '=', "{$user_role}.ID")->where([$user_role . ".CODE" => $roleCode, $user_user_role . ".USER_ID" => $this->ID])->select($user_role . ".CODE")->distinct()->get();
         if (count($rows) > 0) {
             return true;
         } else {
             return false;
         }
     }
     return false;
 }