/**
* Display a listing of the resource.
*
* @return Response
*/
public function listItem()
{
$currUser = Auth::user();
if ($currUser->is_admin == 0) {
return Redirect::route('user-dashboard', array());
}
$oQuery = Cities::join('regions', 'regions.id', '=', 'region_id')->join('country', 'country.id', '=', 'country_id')->join('users', 'users.id', '=', 'user_id')->select('cities.id as id', 'cities.name', 'cities.description', 'regions.name as region_name', 'regions.id as region_id', 'country.name as country_name', 'users.name as user_name');
$aCity = $oQuery->paginate(10);
return View::make('/city/list', array('aCity' => $aCity));
}
