/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(SitioUpdateRequest $request)
{
$id_site = \Session::get('id_site');
$sitio = Sites::find($id_site);
$sitio->fill($request->all());
$sitio->save();
Session::flash('update', 'Cambios realizados exitosamente');
return Redirect::to('/admin/contenidos');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$id_site = \Session::get('id_site');
$noti_show = Noticia::where('id', $id)->get();
$sitios = Sites::where('id', $id_site)->get();
if ($this->auth->user()->role == 1) {
return view('admin.noticia.show', ['noti_show' => $noti_show, 'sitios' => $sitios]);
} else {
return view('noticia.show', ['noti_show' => $noti_show, 'sitios' => $sitios]);
}
}
public function sort($sort)
{
$id_site = \Session::get('id_site');
$id_user = $this->auth->user()->id;
$sitios = Sites::where('id', $id_site)->get();
$sites = Sites_users::where('id_user', $id_user)->count();
$sitio_plan = DB::table('sites')->where('id', $id_site)->value('plan');
$plan = Plans::where('id', $sitio_plan)->get();
$user_count = DB::table('sites_users')->where('id_site', $id_site)->count();
$tipos = Cuotas::orderBy('id', 'ASC')->lists('concepto', 'id');
$users = DB::select('select users.*, sites_users.status, sites_users.role, sites_users.type FROM users JOIN sites_users ON sites_users.id_user = users.id AND sites_users.id_site = :id', ['id' => $id_site]);
$users = collect($users);
if ($sort == 'name') {
$users = $users->sortBy('name');
} else {
if ($sort == 'desc') {
$users = $users->sortByDesc('name');
} else {
if ($sort == 'email') {
$users = $users->sortBy('email');
} else {
if ($sort == 'email_desc') {
$users = $users->sortByDesc('email');
} else {
if ($sort == 'all') {
$users = $users;
} else {
if ($sort == 'adeudo') {
$users = $users->where('status', 0);
} else {
if ($sort == 'corriente') {
$users = $users->where('status', 1);
}
}
}
}
}
}
}
return view('/admin/usuarios', ['users' => $users, 'tipos' => $tipos, 'user_count' => $user_count, 'plan' => $plan, 'sitios' => $sitios, 'sites' => $sites]);
}
public function usuarios()
{
$id_site = \Session::get('id_site');
$id_user = $this->auth->user()->id;
$user_role = Sites_users::where('id_site', $id_site)->where('id_user', $id_user)->value('role');
$sites = Sites_users::where('id_user', $id_user)->count();
if ($user_role == 1) {
$id_site = \Session::get('id_site');
$sitios = Sites::where('id', $id_site)->get();
$sitio_plan = DB::table('sites')->where('id', $id_site)->value('plan');
$plan = Plans::where('id', $sitio_plan)->get();
$user_count = DB::table('sites_users')->where('id_site', $id_site)->count();
$users = DB::select('select users.*, sites_users.status, sites_users.role, sites_users.type FROM users JOIN sites_users ON sites_users.id_user = users.id AND sites_users.id_site = :id', ['id' => $id_site]);
$tipos = Cuotas::where('id_site', $id_site)->lists('concepto', 'id');
return view('/admin/usuarios', ['users' => $users, 'tipos' => $tipos, 'user_count' => $user_count, 'plan' => $plan, 'sitios' => $sitios, 'sites' => $sites]);
} else {
return Redirect::to('home');
}
}
