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); }); } } }