public function udtateSuggestion() { $titleSuggestion = Input::get('titleSuggestion'); $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $neighbor = Neighbors::where('user_id', '=', $user_id)->first(); $html = ''; if ($titleSuggestion == "Recibidos") { $suggestions = Suggestion::where('bd_inbox', '=', 2)->where('tray', '<>', 0)->where('id_receptor', '=', Auth::user()->id)->orderBy('created_at', 'desc')->get(); foreach ($suggestions as $suggestion) { $neighbors = Neighbors::join('neighbors_properties', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('urbanisms', 'neighbors_properties.urbanism_id', '=', 'urbanisms.id')->select('neighbors.name as name', 'neighbors.last_name', 'urbanisms.name as urbanisms')->where('user_id', '=', $suggestion->id_receptor)->first(); $html .= '<tr class="' . $suggestion->mark . '"> <td> <div class="user-image"><img alt="User" src="http://placehold.it/150x150"/> <input id="' . $suggestion->id . '" type="checkbox" class="checkbox" name="check-row" /> <label for="' . $suggestion->id . '"></label> </div> </td> <td class="star"><a class="fa fa-flag flagged-grey"></a></td> <td><a href="' . URL::route('config.colony.suggestions.view', $suggestion->id_mensaje) . '">Administrador del Sistema</a></small></td> <td width="40%"><a href="' . URL::route('config.colony.suggestions.view', $suggestion->id_mensaje) . '">' . $suggestion->asunto . '</a></td> <td>' . $suggestion->created_at . '</td> </tr>'; } } if ($titleSuggestion == "Enviados") { $suggestions = Suggestion::where('user_id', '=', Auth::user()->id)->where('tray', '<>', 0)->where('bd_inbox', '=', 1)->orderBy('created_at', 'desc')->get(); foreach ($suggestions as $suggestion) { $html .= ' <tr class="' . $suggestion->mark . '"> <td><div class="user-image"><img alt="User" src="http://placehold.it/150x150"/> <input id="' . $suggestion->id . '" type="checkbox" class="checkbox" name="check-row" /> <label for="' . $suggestion->id . '"></label> </div> </td> <td class="star"><a class="fa fa-flag flagged-grey"></a></td> <td><a href="' . URL::route('config.colony.suggestions.view.sent', $suggestion->id_mensaje) . '">' . $neighbor->name . ' ' . $neighbor->last_name . '</a> <small><a href="' . URL::route('config.colony.suggestions.view.sent', $suggestion->id_mensaje) . '">' . $urbanism->name . '</a></small></td> <td width="50%"><a href="' . URL::route('config.colony.suggestions.view.sent', $suggestion->id_mensaje) . '">' . $suggestion->asunto . '</a></td> <td>' . $suggestion->created_at . '</td> </tr>'; } } if ($titleSuggestion == "Papelera") { $suggestions = Suggestion::where('user_id', '=', $user_id)->where('tray', '=', 0)->where('bd_inbox', '=', 1)->orderBy('created_at', 'desc')->get(); foreach ($suggestions as $suggestion) { $html .= '<tr class="' . $suggestion->mark . '"> <td><div class="user-image"><img alt="User" src="http://placehold.it/150x150"/> <input id="' . $suggestion->id . '" type="checkbox" class="checkbox" name="check-row" /> <label for="' . $suggestion->id . '"></label> </div> </td> <td class="star"><a class="fa fa-flag flagged-grey"></a></td> <td><a href="' . URL::route('config.colony.suggestions.view.sent', $suggestion->id_mensaje) . '">' . $neighbor->name . ' ' . $neighbor->last_name . '</a> <small><a href="' . URL::route('config.colony.suggestions.view.sent', $suggestion->id_mensaje) . '">' . $urbanism->name . '</a></small></td> <td width="50%"><a href="' . URL::route('config.colony.suggestions.view.sent', $suggestion->id_mensaje) . '">' . $suggestion->asunto . '</a></td> <td>' . $suggestion->created_at . '</td> </tr>'; } } $count = Suggestion::where('bd_inbox', '=', 2)->where('tray', '<>', 0)->where('id_receptor', '=', Auth::user()->id)->where('mark', '=', 'unread')->count(); $data = ['data' => $count, 'html' => $html]; return $data; }
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'); }