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