/**
* Display a listing of the resource.
* Display every conversation/topics with the first Thread related
* @return Response
*/
public function index(Request $request)
{
$Threads = array();
$Result = array();
$count = 0;
$admin = Role::select('id')->where('description', '=', 'admin')->firstorFail();
// if we are admin we want to see everything
if (\Auth::id() == $admin->id) {
$Conversations = User::select('*')->join('conversations', 'conversations.user_id', '=', 'users.id')->get();
} else {
// we are not admin but we want to see published messages and the status of our posted messages
if (\Auth::guest()) {
$Conversations = User::select('*')->join('conversations', 'conversations.user_id', '=', 'users.id')->where('conversations.Pending', '=', 0)->get();
} else {
$Conversations = User::select('*')->join('conversations', 'conversations.user_id', '=', 'users.id')->where('conversations.Pending', '=', 0)->orwhere('conversations.user_id', '=', \Auth::id())->get();
}
}
// we recover the first Thread according to the conversations which passed the previous tests
foreach ($Conversations as $Conversation) {
$Threads[$count] = Thread::where('conversation_id', '=', $Conversation->id)->firstOrFail();
$Result[$count] = array($Conversation, $Threads[$count]);
$count++;
}
return view('dashboard')->with(['dashboard' => $Result, 'adminID' => $admin]);
}
public function getUsers(Request $request)
{
$yetkiler = Role::all();
$count = $request->get('count');
$page = $request->get('page');
$filters = $request->get('filter');
$sorting = $request->get('sorting');
$results = new User();
if (is_array($filters)) {
foreach ($filters as $key => $filter) {
$results = $results->where($key, 'like', "%" . urldecode($filter) . "%");
}
}
if (is_array($sorting)) {
foreach ($sorting as $key => $sort) {
$results = $results->orderBy($key, $sort);
}
} else {
$results = $results->orderBy('id', 'desc');
}
if ($request->has('count') && $request->has('page')) {
$results = $results->skip($count * ($page - 1))->take($count);
}
$results = $results->get();
$filter_yetkiler = Role::select('id', 'display_name as title')->get();
return array('results' => $results, 'inlineCount' => User::count(), 'yetkiler' => $yetkiler, 'filter_yetkiler' => $filter_yetkiler);
}
/**
* Compare the role_id of the user with the admin role id of the database
* return true if user is Admin
*/
public function isAdmin()
{
$adminID = Role::select('id')->where('description', '=', 'admin')->firstOrFail();
if ($this->role_id == $adminID->id) {
return true;
}
return false;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
*
* @return void
*/
public function edit($id)
{
$roles = Role::select('id', 'name', 'label')->get();
$user = User::with('roles')->select('id', 'name', 'email')->findOrFail($id);
$user_roles = [];
foreach ($user->roles as $role) {
$user_roles[] = $role->name;
}
return view('admin.users.edit', compact('user', 'roles', 'user_roles'));
}
/**
* Returns board uris with this permission.
*
* @param \App\Contracts\PermissionUser|null $user User roles must belong to. Defaults to null.
* @param bool $anonymous Determines if we should allow generic, unassigned roles. Defaults true.
* @return Collection of \App\Board->board_uri strings
*/
public function getBoardsWithPermissions(PermissionUser $user = null, $anonymous = true)
{
// Identify roles which affect this user.
// Sometimes we will only want direct assignments.
// This includes null user_id assignments for anonymouse users.
$userRoles = UserRole::select('role_id')->where(function ($query) use($user, $anonymous) {
if ($anonymous) {
$query->whereNull('user_id');
}
if ($user instanceof PermissionUser && !$user->isAnonymous()) {
$query->orWhere('user_id', $user->user_id);
} else {
if (!$anonymous) {
$query->where(\DB::raw('0'), '1');
}
}
})->get()->pluck('role_id');
if (!$userRoles) {
return collect();
}
$inheritRoles = Role::select('role_id', 'inherit_id')->whereIn('role_id', $userRoles)->get()->pluck('inherit_id')->filter(function ($item) {
return !is_null($item);
});
// Identify roles which use this permission,
// or which borrow inherited roles.
$validRoles = RolePermission::select('role_id', 'permission_id')->where(function ($query) use($userRoles, $inheritRoles) {
$query->orWhereIn('role_id', $userRoles);
if ($inheritRoles) {
$query->orWhereIn('role_id', $inheritRoles);
}
})->where('permission_id', $this->permission_id)->get()->pluck('role_id');
if (!$validRoles) {
return collect();
}
// Find the intersection of roles we have and roles we want.
$intersectIdents = collect($userRoles)->intersect(collect($validRoles));
$inheritIdents = collect($inheritRoles)->intersect(collect($validRoles));
$intersectRoles = collect();
if ($intersectIdents) {
// These are only roles which are directly assigned to us with
// this permission.
$intersectRoles = collect(Role::select('role_id', 'board_uri')->whereIn('role_id', $intersectIdents)->get()->pluck('board_uri'));
}
if ($inheritIdents) {
$intersectRoles = collect(Role::select('role_id', 'board_uri')->whereIn('inherit_id', $inheritIdents)->whereIn('role_id', $userRoles)->get()->pluck('board_uri'))->merge($intersectRoles);
}
return $intersectRoles;
}
/**
* Display the specified resource.
*
* @param int $id which is the id of the conversation
* @return Response
*/
public function show($id)
{
$admin = Role::select('id')->where('description', '=', 'admin')->firstOrFail();
// if we are admin we want to see everything
if (\Auth::id() == $admin->id) {
$listofMessages = User::select("*")->Join('threads', 'threads.user_id', '=', 'users.id')->where("threads.conversation_id", '=', $id)->get();
} else {
// we are not admin but we want to see published messages and the status of our posted messages
if (\Auth::guest()) {
$listofMessages = User::select("*")->Join('threads', 'threads.user_id', '=', 'users.id')->where("threads.conversation_id", '=', $id)->where('threads.Pending', '=', 0)->get();
} else {
$listofMessages = User::select("*")->Join('threads', 'threads.user_id', '=', 'users.id')->where("threads.conversation_id", '=', $id)->where('threads.Pending', '=', 0)->orwhere('threads.user_id', '=', \Auth::id())->get();
}
}
// We want the list of message related to this conversation with their writers
//$listofMessages= Thread::select("*")->Join('users', 'Threads.user_id', '=', 'users.id')->where("threads.conversation_id",'=',$id)->get();
return view('Thread')->with(['lstOfMessages' => $listofMessages, 'adminID' => $admin]);
}
/**
* Display a listing of the resource.
*
* @param Request $request
* @return Datatables
*/
public function index(Request $request)
{
$roles = Role::select(['id', 'name', 'slug', 'created_at']);
// roles visibility
if (!Sentinel::getUser()->is_super_admin) {
$roles->whereNotIn('slug', config('laravel-user-module.non_visibility.role_slugs'));
}
// if is filter action
if ($request->has('action') && $request->input('action') === 'filter') {
$roles->filter($request);
}
$addColumns = ['addUrls' => $this->urls];
$editColumns = ['name' => function ($model) {
return $model->name_uc_first;
}, 'created_at' => function ($model) {
return $model->created_at_table;
}];
$removeColumns = [];
return $this->getDatatables($roles, $addColumns, $editColumns, $removeColumns);
}
/**
* Display given permissions to role.
*
* @return void
*/
public function getGiveRolePermissions()
{
$roles = Role::select('id', 'name', 'label')->get();
$permissions = Permission::select('id', 'name', 'label')->get();
return view('admin.permissions.role-give-permissions', compact('roles', 'permissions'));
}
/**
* Show a list of all the languages posts formatted for Datatables.
*
* @return Datatables JSON
*/
public function data()
{
$roles = Role::select(array('roles.id', 'roles.name', 'roles.created_at'));
return Datatables::of($roles)->add_column('actions', '<a href="{{{ URL::to(\'admin/roles/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm iframe" ><span class="glyphicon glyphicon-pencil"></span> {{ Lang::get("admin/modal.edit") }}</a>
<a href="{{{ URL::to(\'admin/roles/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger iframe"><span class="glyphicon glyphicon-trash"></span> {{ Lang::get("admin/modal.delete") }}</a>
')->remove_column('id')->make();
}
/**
* Show a list of all the roles formatted for Datatables.
*
* @return Datatables JSON
*/
public function getData()
{
$roles = Role::select(array('roles.id', 'roles.name', 'roles.id as users', 'roles.created_at'));
return Datatables::of($roles)->edit_column('users', '{{{ DB::table(\'role_user\')->where(\'role_id\', \'=\', $id)->count() }}}')->add_column('actions', '<a href="{{{ URL::to(\'admin/roles/\' . $id . \'/edit\' ) }}}" class="iframe btn btn-xs btn-default">{{{ Lang::get(\'button.edit\') }}}</a>
<a href="{{{ URL::to(\'admin/roles/\' . $id . \'/delete\' ) }}}" class="iframe btn btn-xs btn-danger">{{{ Lang::get(\'button.delete\') }}}</a>
')->remove_column('id')->make();
}
public function destroy(Request $request, $id)
{
$version = Episodever::select('user_id')->where('episode_id', $id)->where('first', 1)->first();
if ($version->user_id != $request->user()->id) {
return '抱歉, 目前仅支持添加此条目的用户删除分集> <';
}
$favorite = Epfav::select('user_id')->where('episode_id', $id)->first();
if ($favorite) {
return '抱歉, 已有人收藏本集，不能删除> <';
}
$review = Review::select('id')->where('episode_id', $id)->first();
if ($review) {
return '抱歉，已有人评论本集，不能删除> <';
}
$role = Role::select('id')->where('episode_id', $id)->first();
if ($role) {
return '抱歉，请先逐一删除SC关联后再删除本集';
}
$item = Item::select('id')->where('episode_id', $id)->first();
if ($item) {
return '抱歉，已有剧单收录本集，不能删除> <';
}
$ed = Ed::select('id')->where('episode_id', $id)->first();
if ($ed) {
return '抱歉，请先逐一删除歌曲关联后再删除本集';
}
$episode = Episode::find($id, ['id', 'drama_id']);
if ($episode->delete()) {
DB::table('users')->where('id', $version->user_id)->decrement('episodevers');
return redirect()->route('drama.show', [$episode->drama_id]);
} else {
return '删除失败';
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$user = User::findOrFail($id);
$roles = Role::select('id', 'name')->lists('name', 'id');
return view('user.edit', compact('user', 'roles'));
}
/**
* Display given permissions to role.
*
* @return void
*/
public function getUserRolePermissions()
{
$roles = Role::select('id', 'name', 'label')->get();
$permissions = Permission::select('id', 'name', 'label')->get();
return \View::make('admin.permissions.role-assign-permissions', ['roles' => $roles, 'permissions' => $permissions, 'title' => 'assign']);
}
/**
* Get the query object to be processed by dataTables.
*
* @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection
*/
public function query()
{
$query = Role::select('*');
return $this->applyScopes($query);
}
