public function index() { if (Auth::check()) { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); //obtener el rol que desempeña en la colonia $rol_id = AssigmentRole::where('user_id', '=', $user_id)->where('colony_id', '=', $colonia)->pluck('role_id'); Session::put("rol_usuario", $rol_id); $permisos = array(); $permisos = DB::table('permission_role')->where("role_id", "=", $rol_id)->select("permission_role.id", "permission_role.state")->orderBy("permission_role.id")->get(); Session::put("dato", $permisos); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $urbanismo = $urbanism->id; $urb_name = $urbanism->Colony->name; $breadcrumbs = Neighbors::where('user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urb_name . " ]"; $Total = DB::table('neighbors_properties')->select(DB::raw('Count(neighbors_properties.id) as total'))->where('neighbors_properties.urbanism_id', '=', $urbanismo)->get(); $Total = $Total[0]->total; $PorAceptar = DB::table('invited_neighbors')->select(DB::raw('count(invited_neighbors.id) as porAceptar'))->where('invited_neighbors.confirmed', '=', 0)->where('invited_neighbors.urbanism_id', '=', $urbanismo)->get(); $PorAceptar = $PorAceptar[0]->porAceptar; $Aceptadas = DB::table('invited_neighbors')->select(DB::raw('count(invited_neighbors.id) as Aceptadas'))->where('invited_neighbors.confirmed', '=', 1)->where('invited_neighbors.urbanism_id', '=', $urbanismo)->get(); $Aceptadas = $Aceptadas[0]->Aceptadas; $ano = date("Y"); $monthly_all = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->get(); $months = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Decem"); $cuotas = array(); foreach ($monthly_all as $cuota_mensual) { $ini = (int) date("m", strtotime($cuota_mensual->since)); $fin = (int) date("m", strtotime($cuota_mensual->until)); if ($cuota_mensual->until == NULL) { $fin = (int) date("m"); } for ($i = $ini; $i <= $fin; $i++) { $cuotas[$months[$i - 1]] = $cuota_mensual->amount; } } $j = (int) date("m"); $monthly_fee = $cuotas[$months[$j - 1]]; $mes = date("M"); $pagoMensual = PaymentStates::join('neighbors_properties', 'payment_states.neighbor_property_id', '=', 'neighbors_properties.id')->where($mes, '>=', $monthly_fee)->where('neighbors_properties.urbanism_id', '=', $urbanismo)->select(DB::raw('count(neighbors_properties.id) as cant'))->get(); if ($pagoMensual) { $pagoMensual = $pagoMensual[0]->cant; } else { $pagoMensual = 0; } $Egresos = Expense::join('sub_accounts', 'expenses.sub_account_id', '=', 'sub_accounts.id')->where('expenses.urbanism_id', '=', $urbanismo)->select(DB::raw('sum(expenses.amount) as amount'), 'sub_accounts.description')->groupBy('sub_accounts.description')->get(); $Ingresos = Payment::join('sub_accounts', 'payments.sub_account_id', '=', 'sub_accounts.id')->join('neighbors_properties', 'payments.neighbor_property_id', '=', 'neighbors_properties.id')->where('neighbors_properties.urbanism_id', '=', $urbanismo)->select(DB::raw('sum(payments.amount) as amount'), 'sub_accounts.description')->groupBy('sub_accounts.description')->get(); $EgresosMensual = Expense::where('expenses.urbanism_id', '=', $urbanismo)->select(DB::raw('sum(expenses.amount) as amount'), DB::raw('DATE_FORMAT(expenses.created_at,\'%m\') as mes'))->groupBy(DB::raw('Month(expenses.created_at)'))->get(); $IngresosMensual = Payment::join('neighbors_properties', 'payments.neighbor_property_id', '=', 'neighbors_properties.id')->where('neighbors_properties.urbanism_id', '=', $urbanismo)->select(DB::raw('sum(payments.amount) as amount'), DB::raw('DATE_FORMAT(payments.created_at,\'%m\') as mes'))->groupBy(DB::raw('Month(payments.created_at)'))->get(); return View::make('dashboard.home', ['Total' => $Total, 'PorAceptar' => $PorAceptar, 'Aceptadas' => $Aceptadas, 'monthly_fee' => $monthly_fee, 'pagoMensual' => $pagoMensual, 'Egresos' => $Egresos, 'Ingresos' => $Ingresos, 'EgresosMensual' => $EgresosMensual, 'IngresosMensual' => $IngresosMensual, 'Nombre' => $breadcrumbs_data]); } else { return Redirect::action('UsersController@login'); } }
public function confirm($code) { $confirm = InvitedNeighbors::where('Confirmation_code', '=', $code)->first(); if (!$confirm->confirmed) { //$confirm->confirmed = true; //$confirm->update(['id']); $email = $confirm->email; $urbanism_id = $confirm->urbanism_id; $colony = Urbanism::where('id', '=', $urbanism_id)->pluck('colony_id'); $expiration = Expiration::where('colony_id', '=', $colony)->first(); $datetime2 = new DateTime($expiration->expiration); $datetime1 = new DateTime(date('Y-m-d')); $interval = $datetime1->diff($datetime2); $days_expiration = $interval->format('%a'); Session::put('days_expiration', $days_expiration); $usuario = UserNeighbors::where('email', '=', $email)->first(); if ($usuario) { $rol_vecino = AssigmentRole::where('colony_id', '=', $colony)->where('user_id', '=', $usuario->id)->where('role_id', '=', 6)->first(); if ($rol_vecino) { $notice_msg = 'Ya se encuentra como vecino en la Colonia, acceda ahora a Habitaria'; return Redirect::action('UsersController@login')->with('notice', $notice_msg); } else { $neighbor = Neighbors::where('user_id', '=', $usuario->id)->first(); if ($neighbor) { $neighborP = NeighborProperty::where('neighbors_id', '=', $neighbor->id)->where('urbanism_id', '=', $urbanism_id)->first(); if (!$neighborP) { return Redirect::action('NeighborController@register_properties', array('neighbor' => $neighbor->id, 'urbanism_id' => $urbanism_id)); } } else { return Redirect::action('NeighborController@register_neighbors', array('user' => $usuario->id, 'urbanism_id' => $urbanism_id)); } } } else { $urbanism = Urbanism::findOrFail($urbanism_id); $urbanism_name = $urbanism->name; $urbanism_type = $urbanism->urbanism_type_id; if ($urbanism_type == 3) { $catalog = BuildingCatalog::where('urbanism_id', '=', $urbanism_id)->orderBy('id', 'ASC')->lists('description', 'id'); $select = '¿Piso donde vive?'; $select_name = 'name_floor'; } else { $catalog = StreetCatalog::where('urbanism_id', '=', $urbanism_id)->orderBy('id', 'ASC')->lists('name', 'id'); $select = '¿Calle donde vive?'; $select_name = 'name_street'; } $notice_msg = Lang::get('confide::confide.alerts.confirmation_invitation'); return View::make('dashboard.neighbors.create', ['email' => $email, 'urbanism' => $urbanism_name, 'urbanism_id' => $urbanism_id, 'urbanism_type' => $urbanism_type, 'catalog' => $catalog, 'code' => $code, 'select_name' => $select_name, 'select' => ['' => $select], 'notice' => $notice_msg]); } } else { $notice_msg = 'Acceda a Habitaria con su usuario creado'; return Redirect::action('UsersController@login')->with('notice', $notice_msg); } }
public function vistaAsignar() { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $urbanismo = $urbanism->id; $urb_name = $urbanism->name; $users = Neighbors::select('neighbors.user_id', 'roles.name', 'users.email', 'neighbors_properties.urbanism_id', 'assigned_roles.role_id')->where("neighbors_properties.urbanism_id", "=", $urbanismo)->join("users", "neighbors.user_id", "=", "users.id")->join("assigned_roles", "assigned_roles.user_id", "=", "users.id")->join("roles", "assigned_roles.role_id", "=", "roles.id")->join("neighbors_properties", "neighbors_properties.neighbors_id", "=", "neighbors.id")->get(); $roles = Role::all(); $breadcrumbs = Neighbors::with('NeighborProperty')->where('user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urb_name . " ]"; return View::make("dashboard.roles.asignarRol")->with(array("users" => $users, "roles" => $roles, 'breadcrumbs_data' => $breadcrumbs_data)); }
public function asignarRol() { $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $datos = (string) Input::get("rol"); $array = explode(",", $datos); $num = count($array); for ($i = 0; $i < $num; $i++) { $roles = explode(".", $array[$i]); $id = (int) $roles[1]; $rol = (int) $roles[0]; $urb = (int) $roles[2]; //$permisos = Permisos::all(); //$permisos = Permisos::find($id); Permisos::where("user_id", "=", $id)->where("colony_id", "=", Session::get("colonia"))->update(array("role_id" => $rol)); $BuscarCollector = Collector::where("user_id", "=", $id)->where('urbanism_id', '=', $urbanism->id)->orderBy('updated_at', 'desc')->first(); if ($rol == 2 || $rol == 3 || $rol == 4 || $rol == 5) { if (!$BuscarCollector) { $Collector = new Collector(); $Collector->user_id = $id; $Collector->urbanism_id = $urb; $Collector->save(); } } if ($rol == 6) { if ($BuscarCollector) { $cobrador = Collector::findOrFail($BuscarCollector->id); $cobrador->delete(['id']); } } //$permisos->role_id = $rol; //$permisos->save(); } return Response::json(array("estado" => 1)); }
$accion = "Visito Mi Historial"; break; case 'dashboard/payments/neighbors': $accion = "Visito Mis Vecinos"; break; case 'dashboard/incomes/charge': $accion = "Visito Ingresos Cobrar"; break; case 'dashboard/incomes/record': $accion = "Visito Ingresos Historial"; break; case 'dashboard/incomes/charge/balances': $accion = "Visito Ingresos Saldos"; break; case 'dashboard/expenses': $accion = "Visito Egresos Registrar Gasto"; break; } if ($accion != '' and Auth::check()) { $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); Logs::create(['user' => Auth::user()->Neighbors->name . ' ' . Auth::user()->Neighbors->last_name, 'rol_user' => Role::find(Auth::user()->AssigmentRole[0]->role_id)->name, 'urbanism_id' => $urbanism->id, 'user_email' => Auth::user()->email, 'accion' => $accion, 'fecha' => (new DateTime())->format('d-m-Y H:i:s')]); } return false; }); Event::fire('illuminate.controller'); Event::listen('logs', function ($accion) { $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); Logs::create(['user' => Auth::user()->Neighbors->name . ' ' . Auth::user()->Neighbors->last_name, 'rol_user' => Role::find(Auth::user()->AssigmentRole[0]->role_id)->name, 'urbanism_id' => $urbanism->id, 'user_email' => Auth::user()->email, 'accion' => $accion, 'fecha' => (new DateTime())->format('d-m-Y H:i:s')]); });
public function modalEstadoCuenta() { $neighbor_property_id = Input::get('neighbor_property_id'); $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $urbanismo = $urbanism->id; $urb_name = $urbanism->name; $property_id = NeighborProperty::where('urbanism_id', '=', $urbanismo)->pluck('id'); $vigencia = date("Y-m"); $months = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Decem"); $today = date("Y-m-d"); $ano = date("Y"); $selano = Payment::select(DB::raw('DATE_FORMAT(payments.created_at,\'%Y\') as y'))->groupBy(DB::raw('Year(payments.created_at)'))->orderBy(DB::raw('Year(payments.created_at)'))->get(); $monthly_all = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->get(); $monthly_ini = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->orderBy('monthly_fee.created_at', 'ASC')->pluck('since'); $mes_ini = (int) date("m", strtotime($monthly_ini)); $cuotas = array(); foreach ($monthly_all as $cuota_mensual) { $ini = (int) date("m", strtotime($cuota_mensual->since)); $fin = (int) date("m", strtotime($cuota_mensual->until)); if ($cuota_mensual->until == NULL) { $fin = (int) date("m"); } for ($i = $ini; $i <= $fin; $i++) { $cuotas[$months[$i - 1]] = $cuota_mensual->amount; } } for ($j = 0; $j <= 11; $j++) { if ($j + 1 < $mes_ini) { $saldoAnteriol[$j] = ""; $cuataMes[$j] = ""; $totalDebe[$j] = ""; $pagos[$j] = ""; $saldoTotal[$j] = ""; } elseif ($j + 1 <= date("m")) { $saldoAnteriol[$j] = $saldoTotal[$j - 1]; $cuataMes[$j] = -$cuotas[$months[$j]]; $totalDebe[$j] = $saldoAnteriol[$j] + $cuataMes[$j]; $neighbor_payments = PaymentStates::with('NeighborProperty')->where('neighbor_property_id', '=', $neighbor_property_id)->first(); if ($neighbor_payments) { $pagos[$j] = $neighbor_payments->{$months}[$j] == NULL ? 0 : $neighbor_payments->{$months}[$j]; } else { $pagos[$j] = 0; } $saldoTotal[$j] = $totalDebe[$j] + $pagos[$j]; } elseif ($j + 1 > date("m")) { $saldoAnteriol[$j] = ""; $cuataMes[$j] = ""; $totalDebe[$j] = ""; $pagos[$j] = ""; $saldoTotal[$j] = ""; } } $neighbor = NeighborProperty::find($neighbor_property_id); return View::make('dashboard.payments.neighbors.table_neigbor', compact('breadcrumbs_data', 'saldoAnteriol', 'cuataMes', 'totalDebe', 'pagos', 'saldoTotal', 'mes_ini', 'ini', 'months', 'color', 'neighbor')); }
public function catologo_egreso() { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $catalog = SubAccount::where('urbanism_id', '=', $urbanism->id)->where('account_id', '=', 2)->orderBy('id', 'ASC')->get(); $breadcrumbs = Neighbors::where('user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urbanism->Colony->name . " ]"; return View::make('dashboard.expenses.catalogo_egresos', ['usuario' => $breadcrumbs_data, 'urbanism_id' => $urbanism->id, 'catalog' => $catalog]); }
public function record_index() { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $AssigmentRole = Auth::user()->AssigmentRole[0]->role_id; $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $urb_name = $urbanism->Colony->name; $collector = Collector::where('user_id', '=', $user_id)->where('urbanism_id', '=', $urbanism->id)->first(); $collector_neighbor = Neighbors::where('user_id', '=', $user_id)->first(); $collector_properties = NeighborProperty::where('neighbors_id', '=', $collector_neighbor->id)->pluck('id'); $neighbors_payments = Payment::join('neighbors_properties', 'payments.neighbor_property_id', '=', 'neighbors_properties.id')->join('neighbors', 'neighbors_properties.neighbors_id', '=', 'neighbors.id')->join('sub_accounts', 'payments.sub_account_id', '=', 'sub_accounts.id')->select('payments.id', 'payments.created_at', 'payments.amount', 'payments.coments', 'neighbors.name', 'neighbors.last_name', 'sub_accounts.description')->where('neighbors_properties.urbanism_id', '=', $urbanism->id)->orderBy('created_at')->get(); $breadcrumbs = Neighbors::with('NeighborProperty')->where('user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [" . $urb_name . "]"; return View::make('dashboard.incomes.record.index', ['incomes' => $neighbors_payments, 'breadcrumbs_data' => $breadcrumbs_data, 'AssigmentRole' => $AssigmentRole, 'total' => 0]); }
public function sugerenciasPapelera() { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $neighbor = Neighbors::where('user_id', '=', $user_id)->first(); $neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanism->id)->where('neighbors_id', '!=', $neighbor->id)->get(); $breadcrumbs = Neighbors::where('user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urbanism->Colony->name . " ]"; $suggestions = Suggestion::where('user_id', '=', $user_id)->where('tray', '=', 0)->where('bd_inbox', '=', 1)->orderBy('created_at', 'desc')->paginate(10); $count = Suggestion::where('id_receptor', '=', $user_id)->where('tray', '<>', 0)->where('bd_inbox', '=', 2)->where('mark', '<>', 'read')->count(); return View::make('dashboard.colonies.suggestions.suggestions_trash', ['usuario' => $breadcrumbs_data, 'urbanism' => $urbanism, 'admin' => $neighbor->id, 'suggestions' => $suggestions, 'count' => $count, 'contador' => 1, 'neighbor' => $neighbor]); }
public function suggestion() { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $neighbor = Neighbors::where('user_id', '=', $user_id)->first(); $neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanism->id)->where('neighbors_id', '!=', $neighbor->id)->get(); $breadcrumbs = Neighbors::where('user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urbanism->Colony->name . " ]"; $suggestions = DB::table('suggestions')->select('suggestions.id', 'suggestions.user_id', 'neighbors.name', 'neighbors.last_name', 'suggestions.asunto', 'suggestions.contenido', 'suggestions.id_mensaje', 'suggestions.mark', 'suggestions.created_at')->join('neighbors', 'neighbors.user_id', '=', 'suggestions.user_id')->where('id_receptor', '=', $user_id)->where('tray', '<>', 0)->orderBy('created_at', 'desc')->paginate(10); $count = Suggestion::where('id_receptor', '=', $user_id)->where('tray', '<>', 0)->where('mark', '<>', 'read')->count(); $suggestionsSent = Suggestion::where('user_id', '=', $user_id)->where('tray', '<>', 0)->get(); return View::make('dashboard.colonies.suggestions.suggestion', ['usuario' => $breadcrumbs_data, 'urbanism' => $urbanism->id, 'admin' => $neighbor->id, 'suggestions' => $suggestions, 'count' => $count, 'suggestionsSent' => $suggestionsSent, 'contador' => 1]); }
public function reportStatus() { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $urbanismo = $urbanism->id; $urb_name = $urbanism->name; $property_id = NeighborProperty::where('urbanism_id', '=', $urbanismo)->pluck('id'); $vigencia = date("Y-m"); $months = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Decem"); $today = date("Y-m-d"); $ano = date("Y"); $selano = Payment::select(DB::raw('DATE_FORMAT(payments.created_at,\'%Y\') as y'))->groupBy(DB::raw('Year(payments.created_at)'))->orderBy(DB::raw('Year(payments.created_at)'))->get(); $monthly_all = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->get(); $monthly_ini = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->orderBy('monthly_fee.created_at', 'ASC')->pluck('since'); $mes_ini = (int) date("m", strtotime($monthly_ini)); $cuotas = array(); foreach ($monthly_all as $cuota_mensual) { $ini = (int) date("m", strtotime($cuota_mensual->since)); $fin = (int) date("m", strtotime($cuota_mensual->until)); if ($cuota_mensual->until == NULL) { $fin = (int) date("m"); } for ($i = $ini; $i <= $fin; $i++) { $cuotas[$months[$i - 1]] = $cuota_mensual->amount; } } $neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanismo)->get(); $breadcrumbs = Neighbors::select('neighbors.name as name_ne', 'neighbors.last_name', 'urbanisms.name as name_ur ')->join('neighbors_properties', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('urbanisms', 'neighbors_properties.urbanism_id', '=', 'urbanisms.id')->where('neighbors.user_id', '=', self::getUserId())->first(); $breadcrumbs_data = $breadcrumbs->name_ne . " " . $breadcrumbs->last_name . " [" . $breadcrumbs->name_ur . "]"; $data = ['mes_ini' => $mes_ini, 'months' => $months, 'cuotas' => $cuotas, 'selano' => $selano, 'urbanism' => $urbanismo, 'breadcrumbs_data' => $breadcrumbs_data, 'neighbors' => $neighbors, 'ini' => $ini, 'fin' => $fin, 'ano' => $ano, 'breadcrumbs_data' => $breadcrumbs_data]; $pdf = PDF::loadView('dashboard.reports.status.pdf', $data); return $pdf->download('reporte_Estato_cuanta_general.pdf'); }
public function store_register_neighbors() { $post = Input::All(); $urbanismNeigh = Input::get('urbanism'); $neighbor = new Neighbors(); $neighbor->user_id = Input::get('user_id'); //$neighbor->urbanism_id = Input::get('urbanism'); $neighbor->name = Input::get('firstname'); $neighbor->last_name = Input::get('lastname'); $neighbor->phone = Input::get('phone'); $neighbor->save(); $last_neighbor_add = $neighbor->id; $urbanism_type = Input::get('urbanism_type'); $neighbor_properties = new NeighborProperty(); $neighbor_properties->neighbors_id = $last_neighbor_add; $neighbor_properties->urbanism_id = Input::get('urbanism'); if ($urbanism_type == 3) { $neighbor_properties->num_floor_id = Input::get('name_floor'); } else { $neighbor_properties->num_street_id = Input::get('name_street'); } $neighbor_properties->num_house_or_apartment = Input::get('num_house_or_apartment'); if ($neighbor_properties->save()) { $role = Role::where('name', '=', 'vecino')->first(); $colony = Urbanism::where('id', '=', Input::get('urbanism'))->pluck('colony_id'); $rol = new AssigmentRole(); $rol->user_id = Input::get('user_id'); $rol->role_id = $role->id; $rol->colony_id = $colony; $rol->save(); } $colonies = Colony::select('colonies.id')->join('urbanisms', 'urbanisms.colony_id', '=', 'colonies.id')->join('neighbors_properties', 'urbanisms.id', '=', 'neighbors_properties.urbanism_id')->where('neighbors_properties.urbanism_id', '=', $urbanismNeigh)->first(); $user = Neighbors::where('id', '=', $last_neighbor_add)->pluck('user_id'); $user_auth = User::where('id', '=', $user)->first(); Auth::login($user_auth); if (Auth::check()) { Session::put('colonia', $colonies->id); return Redirect::action('HomeController@index'); } else { return Redirect::action('UsersController@login'); } }