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