public function save()
{
$colonia = Session::get('colonia');
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$user_id = Auth::user()->id;
$bd_inbox = Input::get('bd_inbox');
$asunto = Input::get('asunto');
$contenido = Input::get('contenido');
$tray = Input::get('tray');
$status = Input::get('status');
$id_receptor = Input::get('id_receptor');
$admin = NeighborProperty::join('neighbors', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('assigned_roles', 'neighbors.user_id', '=', 'assigned_roles.user_id')->where('assigned_roles.colony_id', '=', $colonia)->where('urbanism_id', '=', $urbanism->id)->where('assigned_roles.role_id', '=', 2)->first();
$neighbor_id = Neighbors::where('user_id', '=', $user_id)->pluck('id');
$neighbor = NeighborProperty::with('Urbanism.Colony')->where('neighbors_id', '=', $neighbor_id)->get();
try {
$sugerencia = new Suggestion();
$sugerencia->user_id = $user_id;
$sugerencia->bd_inbox = $bd_inbox;
$sugerencia->asunto = $asunto;
$sugerencia->contenido = $contenido;
$sugerencia->tray = $tray;
$sugerencia->status = $status;
$sugerencia->id_receptor = $admin->user_id;
$sugerencia->id_mensaje = uniqid('msn');
$sugerencia->mark = 'unread';
$sugerencia->save();
return 1;
} catch (Exception $exc) {
return 0;
}
}
public function sendEmails()
{
$colonia = Session::get("colonia");
$coloniaName = Colony::find($colonia);
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$state = State::where('id', $coloniaName->City->state_id)->first()->name;
$ciudad = $coloniaName->City->name;
$contenido = Input::get('contenido');
$user_id = Input::get('email');
$asunto = Input::get('asunto');
$admin_colonia = Neighbors::where('user_id', '=', Auth::user()->id)->first();
$optGroup = Input::get('optGroup');
if ($user_id == 'Todos' && $optGroup == NULL) {
$neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanism->id)->where('neighbors_id', '!=', $admin_colonia->id)->get();
foreach ($neighbors as $neighbor) {
$email = $neighbor->Neighbors->User->email;
$data = array('email' => $email, 'link' => 'ConfirmationController@confirm', 'code' => "jhhjdhsdhhdsjhdsh", 'name_inv' => $admin_colonia->name, 'lname_inv' => $admin_colonia->last_name, 'urbanism' => $urbanism->name, 'contenido' => $contenido, 'asunto' => $asunto, 'coloniaName' => $coloniaName, 'estado' => $state, 'ciudad' => $ciudad);
Mail::send('emails.email_masivos', $data, function ($message) use($email, $asunto) {
$message->subject($asunto);
$message->to($email);
});
}
}
if ($optGroup == 'Vecinos') {
$email = User::findOrFail($user_id)->email;
$data = array('email' => $email, 'link' => 'ConfirmationController@confirm', 'code' => "jhhjdhsdhhdsjhdsh", 'name_inv' => $admin_colonia->name, 'lname_inv' => $admin_colonia->last_name, 'urbanism' => $urbanism->name, 'contenido' => $contenido, 'asunto' => $asunto, 'coloniaName' => $coloniaName, 'estado' => $state, 'ciudad' => $ciudad);
Mail::send('emails.email_masivos', $data, function ($message) use($email, $asunto) {
$message->subject($asunto);
$message->to($email);
});
}
if ($optGroup == 'Roles') {
$neighbors = NeighborProperty::join('neighbors', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('assigned_roles', 'neighbors.user_id', '=', 'assigned_roles.user_id')->where('assigned_roles.colony_id', '=', $colonia)->where('urbanism_id', '=', $urbanism->id)->where('assigned_roles.role_id', '=', $user_id)->get();
foreach ($neighbors as $neighbor) {
$email = $neighbor->Neighbors->User->email;
$data = array('email' => $email, 'link' => 'ConfirmationController@confirm', 'code' => "jhhjdhsdhhdsjhdsh", 'name_inv' => $admin_colonia->name, 'lname_inv' => $admin_colonia->last_name, 'urbanism' => $urbanism->name, 'contenido' => $contenido, 'asunto' => $asunto, 'coloniaName' => $coloniaName, 'estado' => $state, 'ciudad' => $ciudad);
Mail::send('emails.email_masivos', $data, function ($message) use($email, $asunto) {
$message->subject($asunto);
$message->to($email);
});
}
}
}
