});
Route::get('{username}/itineraries', function ($username) {
$user = User::findFromData($username);
return $user->itinerariesWithSpotIds();
// ->each(function(&$item) {
// $item->isMine = $item->isMine();
// });
return $itineraries;
if (Request::wantsJson()) {
return $itineraries;
}
return View::make('site.itineraries.index', ['user' => $user, 'itineraries' => $itineraries]);
});
Route::get('{username}/itineraries/{id}', function ($username, $id) {
$user = User::findFromData($username);
$itinerary = Itinerary::find($id);
return View::make('site.itineraries.show', ['user' => $user, 'itinerary' => $itinerary]);
});
Route::get('{username}/itineraries/{id}/edit', function ($username, $id) {
return Redirect::to('/admin/itinerary/' . $id);
});
Route::get('{username}/itineraries/{id}/categories', function ($username, $id) {
$user = User::findFromData($username);
$itinerary = Itinerary::find($id);
// temp...
if ($itinerary == null) {
return View::make('admin.itinerary.index', ['active_link' => 'itinerary', 'user' => Auth::user()]);
}
return $itinerary->getAllCategories();
});
});
public function addTimestampToBlankSpotablesItineraries()
{
$query = DB::table('spotables')->where('spotable_type', '=', 'Itinerary')->get();
foreach ($query as $row) {
if ($row->created_at == '0000-00-00 00:00:00') {
$spot = Spot::find($row->spot_id);
$itin = Itinerary::find($row->spotable_id);
if ($itin && $itin->user) {
$user = $itin->user;
$new_date = $user->created_at->toDateTimeString();
DB::table('spotables')->where('id', $row->id)->update(array('created_at' => $new_date, 'updated_at' => $new_date));
} else {
dd($itin);
}
}
}
return $query;
}
