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 store_familiar() { $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $post = Input::All(); $invited_id = md5(uniqid(mt_rand(), true)); $encrypted = Crypt::encrypt(md5(uniqid(mt_rand(), true))); $user_id = Auth::user()->id; $user_admin = Neighbors::where('user_id', '=', $user_id)->first(); $invited = new InvitedNeighbors(); $invited->neighbor_id = $user_admin->id; $invited->invited_id = $invited_id; $invited->urbanism_id = Input::get('urbanism'); $invited->email = Input::get('email'); $invited->confirmed = 0; $invited->confirmation_code = $encrypted; $invited->save(); $user = new UserNeighbors(); $user->email = Input::get('email'); $user->status_id = '1'; $user->confirmed = '1'; $user->confirmation_code = md5(uniqid(mt_rand(), true)); $user->save(); $last_user_add = $user->id; $role = Role::where('name', '=', 'vecino')->first(); $rol = new AssigmentRole(); $rol->user_id = $last_user_add; $rol->role_id = $role->id; $rol->colony_id = $colonia; $rol->save(); $neighbor = new Neighbors(); $neighbor->user_id = $last_user_add; $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'); $num_floor_id = null; $num_street_id = null; if ($urbanism_type == 3) { $num_floor_id = Input::get('piso'); $neighbor_properties->num_floor_id = $num_floor_id; } else { $num_street_id = Input::get('calle'); $neighbor_properties->num_street_id = $num_street_id; } $house = Input::get('casa'); $neighbor_properties->num_house_or_apartment = $house; $buscardomicilio = NeighborProperty::select('neighbors_properties.id')->where('neighbors_properties.urbanism_id', '=', $urbanism->id)->where('neighbors_properties.num_floor_id', '=', $num_floor_id)->where('neighbors_properties.num_street_id', '=', $num_street_id)->where('neighbors_properties.num_house_or_apartment', '=', $house)->first(); if ($buscardomicilio) { $status = 0; } else { $status = 1; } $neighbor_properties->status = $status; $neighbor_properties->save(); $neighbor_reg = InvitedNeighbors::where('invited_id', '=', $invited_id)->first(); $urbanism = Urbanism::where('id', '=', $neighbor_reg->urbanism_id)->first(); $email = $neighbor_reg->email; $data = array('email' => $email, 'link' => 'ConfirmationController@confirm_data_fam', 'code' => $neighbor_reg->confirmation_code, 'name_inv' => $user_admin->name, 'lname_inv' => $user_admin->last_name, 'urbanism' => $urbanism->name); Mail::send('emails.confirm_neighbors', $data, function ($message) use($email) { $message->subject('Invitación HABITARIA'); $message->to($email); }); $notice_msg = 'Datos guardados exitosamente'; return Redirect::action('ColonyController@reg_familiar')->with('error', false)->with('msg', $notice_msg)->with('class', 'info'); }
public function profile() { $user_id = Auth::user()->id; $user_data = Data_users::where('user_id', '=', $user_id)->first(); $role = AssigmentRole::where('user_id', '=', $user_id)->first(); $user_role = ucfirst($role->Role->name); return View::make('users.profile', ['role' => $user_role, 'user' => $user_data]); }
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'); } }