public function sendMailInvitation()
{
$last_invited_add = Input::get('invited_id');
$inv_admin = Input::get('admin_colonia');
$admin_colonia = Neighbors::where('id', '=', $inv_admin)->first();
$neighbors = InvitedNeighbors::where('invited_id', '=', $last_invited_add)->get();
$urbanism_id = Input::get('urbanismo');
$urbanism = Urbanism::findOrFail($urbanism_id);
$code = Session::get('code');
foreach ($neighbors as $inv_neighbor) {
$email = $inv_neighbor->email;
$data = array('email' => $email, 'link' => 'ConfirmationController@confirm', 'code' => $inv_neighbor->confirmation_code, 'name_inv' => $admin_colonia->name, 'lname_inv' => $admin_colonia->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 = "<h4>A concluido el proceso de registro</h4><p>Vecinos invitados con éxito</p>";
return Redirect::action('NeighborController@admin_neighbor', array('admin_colonia' => $inv_admin, 'urbanismo' => $urbanism_id));
}
public function editColonyInfo()
{
$data = Input::all();
$user_id = Auth::user()->id;
$colonia = Session::get("colonia");
$neighbors = Neighbors::join('neighbors_properties', 'neighbors_properties.neighbors_id', '=', 'neighbors.id')->join('urbanisms', 'urbanisms.id', '=', 'neighbors_properties.urbanism_id')->join('colonies', 'colonies.id', '=', 'urbanisms.colony_id')->select('urbanisms.id as urbanisms_id', 'neighbors.id as neighbors_id', 'neighbors_properties.id as neighbors_properties_id', 'colonies.id as colonies_id')->where('colonies.id', '=', $colonia)->where('user_id', '=', $user_id)->first();
$colony = Colony::findOrFail($neighbors->colonies_id);
$colony->location_id = Input::get('city');
$colony->name = Input::get('colony_name');
$colony->update(['id']);
$urbanism = Urbanism::findOrFail($neighbors->urbanisms_id);
$urbanism->urbanism_type_id = Input::get('urbanism_type');
$urbanism->update(['id']);
$notice_msg = 'Datos guardados exitosamente';
return Redirect::action('ColonyController@edit_informacion')->with('error', false)->with('msg', $notice_msg)->with('class', 'info');
}
public function confirm_data_fam($code)
{
if (!$code) {
$error_msg = new InvalidConfirmationCodeException();
return Redirect::action('UsersController@login')->with('error', $error_msg);
}
$confirm = InvitedNeighbors::where('Confirmation_code', '=', $code)->first();
if (!$confirm) {
$error_msg = Lang::get('confide::confide.alerts.wrong_confirmation');
return Redirect::action('UsersController@login')->with('error', $error_msg);
}
if (!$confirm->confirmed) {
$email = $confirm->email;
$reg_user = User::where('email', '=', $email)->first();
if ($reg_user) {
$reg_neighbor = Neighbors::where('user_id', '=', $reg_user->id)->first();
$property = NeighborProperty::where('neighbors_id', '=', $reg_neighbor->id)->first();
$urbanism_id = $confirm->urbanism_id;
$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)->first();
} else {
$catalog = StreetCatalog::where('urbanism_id', '=', $urbanism_id)->first();
}
$notice_msg = Lang::get('confide::confide.alerts.confirmation_invitation');
return View::make('dashboard.neighbors.edit_fam', ['email' => $email, 'urbanism' => $urbanism_name, 'urbanism_id' => $urbanism_id, 'code' => $code, 'urbanism_type' => $urbanism_type, 'catalog' => $catalog, 'neighbor' => $reg_neighbor, 'property' => $property, 'notice' => $notice_msg]);
} else {
return Redirect::action('ConfirmationController@confirm', $code);
}
} else {
$notice_msg = 'Acceda a Habitaria con su usuario creado';
return Redirect::action('UsersController@login')->with('notice', $notice_msg);
}
}
public function register_neighbors()
{
$user = Input::get('user');
$urbanism_id = Input::get('urbanism_id');
$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';
}
return View::make('dashboard.neighbors.create_register', ['urbanism' => $urbanism_name, 'urbanism_id' => $urbanism_id, 'urbanism_type' => $urbanism_type, 'catalog' => $catalog, 'user' => $user, 'select_name' => $select_name, 'select' => ['' => $select]]);
}
