public function store(ItemRequest $request)
{
try {
$customers = Customer::all();
Item::create($request->all());
$item = Item::orderBy('created_at', 'desc')->first();
foreach ($customers as $customer) {
Price::create(['item_id' => $item->id, 'customer_id' => $customer->id, 'custom_price' => $item->price, 'sellable' => '1', 'is_custom' => '0']);
}
return redirect('item')->with('message', 'Data berhasil dibuat!');
} catch (\Illuminate\Database\QueryException $e) {
return redirect('item')->with('message', 'Data dengan nama tersebut sudah digunakan!');
} catch (\PDOException $e) {
return redirect('item')->with('message', 'Data dengan nama tersebut sudah digunakan!');
}
}
public function store(Request $request)
{
$publish = 0;
$index_page = 0;
$extension = "";
if ($request['publish'] == 'on') {
$publish = 1;
}
if ($request['index_page'] == 'on') {
$index_page = 1;
}
//obtenemos el campo file definido en el formulario
$flag = 1;
$orderBy = DB::table('cms_categories')->where('active', '=', $flag)->max('order_by') + 1;
$file = $request->file('file');
if ($file != "") {
$media = \App\Media::find($request->id_album);
$path = $media->path . uniqid() . '.' . $file->getClientOriginalExtension();
$extension = $file->getClientOriginalExtension();
//indicamos que queremos guardar un nuevo archivo en el disco local
Storage::disk('local')->put($path, File::get($file));
} else {
$path = "";
}
$flag = 1;
$orderBy = DB::table('med_pictures')->where('active', '=', $flag)->max('order_by') + 1;
\App\Item::create(['id_album' => $request['id_album'], 'title' => $request['title'], 'description' => $request['description'], 'uri' => $path, 'publish' => $publish, 'publish_date' => $request['publish_date'], 'path' => $path, 'mime_type' => $extension, 'extension' => $extension, 'hits' => '0', 'order_by' => $orderBy, 'active' => '1', 'register_by' => '1', 'modify_by' => '1']);
return redirect('/admin/item/' . $request->id_album);
}
/**
* Update podcast items
*
* @return mixed
*/
public function handle()
{
$uniquePodcasts = DB::table('podcasts')->select('id', 'feed_url', 'machine_name')->groupBy('machine_name')->get();
foreach ($uniquePodcasts as $podcast) {
$usersSubscribedToThisPodcast = DB::table('podcasts')->select('user_id', 'id as podcast_id')->where('machine_name', '=', $podcast->machine_name)->get();
$items = Feeds::make($podcast->feed_url)->get_items();
// Calculate 48 hours ago
$yesterday = time() - 24 * 2 * 60 * 60;
foreach ($items as $item) {
$itemPubDate = $item->get_date();
if ($item->get_date('U') > $yesterday) {
// new items
foreach ($usersSubscribedToThisPodcast as $subscriber) {
$podcastItemsCount = DB::table('items')->select('user_id', 'title', 'podcast_id')->where('title', '=', strip_tags($item->get_title()))->where('user_id', '=', $subscriber->user_id)->where('podcast_id', '=', $subscriber->podcast_id)->count();
// if this item is not already in the DB
if ($podcastItemsCount == 0) {
Item::create(['user_id' => $subscriber->user_id, 'title' => strip_tags($item->get_title()), 'description' => strip_tags(str_limit($item->get_description(), 100)), 'published_at' => $item->get_date('Y-m-d'), 'url' => $item->get_permalink(), 'audio_url' => $item->get_enclosure()->get_link(), 'podcast_id' => $subscriber->podcast_id]);
}
}
} else {
break;
}
}
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
for ($i = 0; $i < 300; $i++) {
Item::create(['name' => $faker->shuffle($faker->name()), 'description' => $faker->text(), 'icon' => $faker->imageUrl(100, 100, 'abstract')]);
}
}
/**
*
* Store - Processes $_POSTs from the Add Item page
* Parameter - CreateItemRequest
*/
public function store(Requests\CreateItemRequest $request)
{
$input = $request->all();
$input['user_id'] = Auth::id();
Item::create($input);
return redirect('items');
}
public function run()
{
DB::table('items')->delete();
Item::create(['name' => 'Truc', 'description' => 'non applicable', 'price' => '99.99', 'stock' => 5, 'img_url' => '/images/filler.jpg', 'category_id' => 1]);
Item::create(['name' => 'Machin', 'description' => 'non applicable', 'price' => '23.99', 'stock' => 3, 'img_url' => '/images/filler.jpg', 'category_id' => 2]);
Item::create(['name' => 'Bidule', 'description' => 'non applicable', 'price' => '123.99', 'stock' => 0, 'img_url' => '/images/filler.jpg', 'category_id' => 3]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('items')->delete();
for ($i = 1; $i <= 100; $i++) {
Item::create(array('title' => 'item test ' . $i));
}
}
public function store(ItemCreateRequest $request)
{
$item = Item::create($request->postFillData());
$itemid = $item->id;
$employeeid = Auth::user()->id;
$logs = ActivityLog::create(['employee_id' => $employeeid, 'activity' => 'Add Item', 'table_affected' => 'item', 'primary_key' => $itemid, 'column_affected' => 'all']);
return redirect()->route('erp_system.item.index')->withSuccess('New Item Successfully Created.');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, ['category_id' => 'required', 'name' => 'required', 'description' => 'required', 'cost' => 'required']);
$extension = $request->file('image')->getClientOriginalExtension();
$item = Item::create(['category_id' => $request->input('category_id'), 'name' => $request->input('name'), 'description' => $request->input('description'), 'cost' => $request->input('cost'), 'image_type' => $extension]);
$storage = Storage::disk('s3')->put('/items/' . $item->id . '.' . $extension, file_get_contents($request->file('image')->getRealPath()), 'public');
return redirect('items')->with('flash_message', 'New Item added: ' . $item->name);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(ItemRequest $request, $course_url, $stage_url)
{
$name = $request->name;
$url = UrlSanitizer::sanitize($name);
$request["url"] = $url;
$item = Item::create($request->all());
return redirect()->route('items.index', ['course_url' => $course_url, 'stage_url' => $stage_url]);
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$category_ids = explode(',', $request->input('category_ids'));
$item = App\Item::create($request->all());
foreach ($category_ids as $category_id) {
$item->categories()->attach($category_id);
}
flash()->success("Success!", "New item <strong>" . e($item->name) . "</strong> has been created.");
return redirect()->action('ItemsController@index');
}
protected static function newItem($id, $name, $headers, $entries)
{
$item = Item::create(['section_id' => $id, 'name' => $name]);
foreach ($headers as $header => $value) {
ItemHeader::create(['item_id' => $item->id, 'name' => $header, 'value' => $value]);
}
foreach ($entries as $key => $entry) {
Entry::create(['item_id' => $item->id, 'entry' => $entry, 'ordered' => $key]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Item::create(['articulo_id' => 1, 'romano' => 'I', 'descripcion' => 'Cumplir con las normas de trabajo aplicables.']);
Item::create(['articulo_id' => 1, 'romano' => 'II', 'descripcion' => 'Expedir y dar a conocer entre los trabajadores las normas que permitan el cumplimiento de las condiciones, políticas, criterios y procedimientos en general encaminados a mantener el orden, la disciplina y el buen funcionamiento del centro de trabajo.']);
Item::create(['articulo_id' => 1, 'romano' => 'III', 'descripcion' => 'Expedir a favor del trabajador que tenga derecho, el nombramiento de acuerdo a la categoría que desempeñe.']);
Item::create(['articulo_id' => 1, 'romano' => 'IV', 'descripcion' => 'Cubrir el salario de los trabajadores y las demás prestaciones y beneficios a que tenga derecho el trabajador.']);
Item::create(['articulo_id' => 2, 'romano' => 'I', 'descripcion' => 'Cumplir con las normas de trabajo que les sean aplicables.']);
Item::create(['articulo_id' => 2, 'romano' => 'II', 'descripcion' => 'Cumplir con todas las normas de orden técnico y administrativo que dicte la Institución a través de manuales, reglamentos, circulares o reglas de carácter general o especial.']);
Item::create(['articulo_id' => 2, 'romano' => 'III', 'descripcion' => 'Acatar las órdenes e instrucciones que reciban de superiores, en atención al servicio que prestan.']);
Item::create(['articulo_id' => 2, 'romano' => 'IV', 'descripcion' => 'Observar las medidas preventivas de seguridad e higiene que contemplen las normas a que están sujetos, así como las que indiquen las autoridades competentes y la institución en beneficio de los trabajadores y del centro de trabajo.']);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
//$input = Request::all();
$request->merge(['user' => Auth::id()]);
$this->validate($request, ['item_name' => 'required', 'sku' => 'required|numeric|unique:items,sku', 'price' => 'required', 'quantity' => 'required|numeric', 'user' => 'required']);
Item::create($request->all());
//delete scanner
$email = User::where('id', Auth::id())->first()->email;
$scan = Scan::where('userEmail', $email)->delete();
return redirect('inventory');
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(ItemRequest $request)
{
//
$input = $request->all();
$item = Item::create($input);
$warehouse = Warehouse::first();
if ($warehouse != null) {
$data = ['item_id' => $item->id, 'warehouse_id' => $warehouse->id, 'qtyonhand' => 0.0];
Itemsite::create($data);
}
return redirect('items');
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(ItemFormRequest $request)
{
$data = $request->input();
$data['childable'] = empty($data['childable']) ? false : true;
if (empty($data['quantity'])) {
$data['quantity'] = 1;
}
//Debug
// dd($data);
Item::create(['name' => $data['name'], 'quantity' => $data['quantity'], 'parent_id' => $data['parent_id'], 'parent_name' => $data['parent_name'], 'location_id' => $data['location_id'], 'location_name' => $data['location_name'], 'childable' => $data['childable']]);
return redirect()->route('items.add');
}
public function run()
{
DB::table('facturas')->delete();
$faker = Faker::create();
for ($admin = 1; $admin < 11; $admin++) {
for ($factura = 1; $factura < 6; $factura++) {
Factura::create(['fecha' => $faker->date($format = 'Y-m-d', $max = 'now'), 'total' => 150, 'vencimiento' => $faker->date($format = 'Y-m-d', $max = 'now'), 'estado' => "PAGA", 'administrador_id' => $admin]);
for ($item = 0; $item < 2; $item++) {
Item::create(['cantidad' => 3, 'precio' => 5, 'descripcion' => "Descripcion", 'factura_id' => $factura]);
}
}
}
}
public function run()
{
DB::table('users')->delete();
DB::table('markets')->delete();
DB::table('default_attributes')->delete();
DB::table('items')->delete();
DB::table('item_attributes')->delete();
DB::table('item_photos')->delete();
$oscar = User::create(['id' => 1, 'first_name' => 'Oscar', 'last_name' => 'van Ruiten', 'email' => '*****@*****.**', 'password' => bcrypt('secret'), 'country' => 'The Netherlands', 'state' => 'South-Holland', 'postal_code' => '3000', 'phone' => '0479671567']);
$udo = User::create(['id' => 2, 'first_name' => 'Steven', 'last_name' => 'Grauwmans', 'email' => '*****@*****.**', 'password' => bcrypt('secret'), 'country' => 'Belgium', 'state' => 'Antwerp', 'postal_code' => '2323', 'phone' => '0479343719', 'created_at' => '2015-10-10']);
$bikes = Market::create(['id' => 1, 'name' => 'Bikes', 'description' => 'Market for bikes.', 'upvote' => 500]);
$cars = Market::create(['id' => 2, 'name' => 'Cars', 'description' => 'Market for cars.', 'upvote' => 500]);
$retro = Market::create(['id' => 3, 'name' => 'Retro', 'description' => 'Market for retro stuff.', 'upvote' => 234]);
$design = Market::create(['id' => 4, 'name' => 'Designer furniture', 'description' => 'Market for expensive sheeeeeet.', 'upvote' => 499]);
$fruit = Market::create(['id' => 5, 'name' => 'Fruit', 'description' => 'Market for fresh bananas.', 'upvote' => 350]);
DefaultAttribute::create(['id' => 1, 'name' => 'Color', 'market_id' => $bikes->id]);
DefaultAttribute::create(['id' => 2, 'name' => 'Frame size', 'market_id' => $bikes->id]);
DefaultAttribute::create(['id' => 3, 'name' => 'Brand', 'market_id' => $cars->id]);
$trek = Item::create(['id' => 1, 'name' => 'Trek Bike', 'description' => 'This is an add for a Trek Bike.', 'price' => 500, 'by_mail' => 0, 'views' => 10, 'user_id' => $oscar->id]);
$ferrari = Item::create(['id' => 2, 'name' => 'Ferrari 3000', 'description' => 'This is an add for a Ferrari 3000.', 'price' => 19999999, 'by_mail' => 0, 'views' => 1000, 'user_id' => $udo->id]);
$saddle = Item::create(['id' => 3, 'name' => 'Brooks saddle', 'description' => 'This is an add for a Brooks saddle.', 'price' => 50, 'by_mail' => 1, 'views' => 50, 'user_id' => $oscar->id]);
$tire = Item::create(['id' => 4, 'name' => 'Rubber tire', 'description' => 'This is an add for a rubber tire.', 'price' => 10, 'by_mail' => 1, 'views' => 20, 'user_id' => $oscar->id]);
$toyota = Item::create(['id' => 5, 'name' => 'Toyota Celica', 'description' => 'This is an add for a Japanse car.', 'price' => 1500, 'by_mail' => 0, 'views' => 150, 'user_id' => $udo->id]);
$chair = Item::create(['id' => 6, 'name' => 'Two seat', 'description' => 'This is an add for a leather two seater.', 'price' => 70, 'by_mail' => 0, 'views' => 35, 'user_id' => $udo->id]);
$banana = Item::create(['id' => 7, 'name' => 'Chiquita', 'description' => 'This is an add for a box of bananas.', 'price' => 5, 'by_mail' => 1, 'views' => 6, 'user_id' => $oscar->id]);
$armaniTable = Item::create(['id' => 8, 'name' => 'Table', 'description' => 'This is an add for a Armani table.', 'price' => 50, 'by_mail' => 1, 'views' => 50, 'user_id' => $oscar->id]);
ItemAttribute::create(['id' => 1, 'name' => 'Color', 'value' => 'black', 'item_id' => $trek->id]);
ItemAttribute::create(['id' => 2, 'name' => 'Brand', 'value' => 'Ferrari', 'item_id' => $ferrari->id]);
ItemAttribute::create(['id' => 3, 'name' => 'Frame size', 'value' => '58', 'item_id' => $saddle->id]);
ItemAttribute::create(['id' => 4, 'name' => 'Color', 'value' => 'green', 'item_id' => $tire->id]);
ItemAttribute::create(['id' => 5, 'name' => 'Color', 'value' => 'yellow', 'item_id' => $toyota->id]);
ItemAttribute::create(['id' => 6, 'name' => 'Color', 'value' => 'pink', 'item_id' => $chair->id]);
ItemAttribute::create(['id' => 7, 'name' => 'Color', 'value' => 'orange', 'item_id' => $banana->id]);
ItemAttribute::create(['id' => 8, 'name' => 'Color', 'value' => 'white', 'item_id' => $armaniTable->id]);
ItemPhoto::create(['id' => 1, 'filename' => 'no_image.png', 'item_id' => $trek->id]);
ItemPhoto::create(['id' => 2, 'filename' => 'no_image.png', 'item_id' => $ferrari->id]);
ItemPhoto::create(['id' => 3, 'filename' => 'no_image.png', 'item_id' => $saddle->id]);
ItemPhoto::create(['id' => 4, 'filename' => 'no_image.png', 'item_id' => $tire->id]);
ItemPhoto::create(['id' => 5, 'filename' => 'no_image.png', 'item_id' => $toyota->id]);
ItemPhoto::create(['id' => 6, 'filename' => 'no_image.png', 'item_id' => $chair->id]);
ItemPhoto::create(['id' => 7, 'filename' => 'no_image.png', 'item_id' => $banana->id]);
ItemPhoto::create(['id' => 8, 'filename' => 'no_image.png', 'item_id' => $armaniTable->id]);
$trek->markets()->attach($bikes->id);
$ferrari->markets()->attach($cars->id);
$saddle->markets()->attach($bikes->id);
$tire->markets()->attach($bikes->id);
$toyota->markets()->attach($cars->id);
$chair->markets()->attach($design->id);
$banana->markets()->attach($fruit->id);
$armaniTable->markets()->attach($design->id);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::statement("SET foreign_key_checks = 0");
Item::truncate();
DB::statement("SET foreign_key_checks = 1");
$cause = Cause::where('cause_title', 'Liberation of minor sex')->get()->first();
Item::create(['cause_id' => $cause->cause_id, 'item_name' => 'blanket', 'item_description' => 'for minor sex', 'item_required' => 20, 'item_received' => 7, 'item_worth' => 11]);
Item::create(['cause_id' => $cause->cause_id, 'item_name' => 'bedsheets', 'item_description' => 'for minor sex', 'item_required' => 45, 'item_received' => 23, 'item_worth' => 9]);
$cause = Cause::where('cause_title', 'Child Support')->get()->first();
Item::create(['cause_id' => $cause->cause_id, 'item_name' => 'books', 'item_description' => 'for child support', 'item_required' => 200, 'item_received' => 159, 'item_worth' => 14]);
Item::create(['cause_id' => $cause->cause_id, 'item_name' => 'desks', 'item_description' => 'for child support', 'item_required' => 100, 'item_received' => 67, 'item_worth' => 15]);
// $cause = Cause::where('cause_title',
// 'Flood Donation PK')->get()->first();
// Item::create([
// 'cause_id' => $cause->cause_id,
// 'item_name' => 'blanket',
// 'item_description' => 'for flood donation',
// 'item_required' => 500,
// 'item_received' => 322,
// 'item_worth' => 12
// ]);
// Item::create([
// 'cause_id' => $cause->cause_id,
// 'item_name' => 'clothes',
// 'item_description' => 'for flood donation',
// 'item_required' => 900,
// 'item_received' => 545,
// 'item_worth' => 15
// ]);
// $cause = Cause::where('cause_title',
// 'Earthquake PK')->get()->first();
// Item::create([
// 'cause_id' => $cause->cause_id,
// 'item_name' => 'cash',
// 'item_description' => 'for earthquake',
// 'item_required' => 500000,
// 'item_received' => 123410,
// 'item_worth' => 1
// ]);
// Item::create([
// 'cause_id' => $cause->cause_id,
// 'item_name' => 'clothes',
// 'item_description' => 'for earthquake',
// 'item_required' => 100,
// 'item_received' => 67,
// 'item_worth' => 15
// ]);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(ItemRequest $request, $course_url, $stage_url)
{
$item = Item::create($request->all());
return redirect()->route('items.index', ['course_url' => $course_url, 'stage_url' => $stage_url]);
}
/**
* Create a new item with the next content
* @return Item
*/
public static function createNewItem(string $content) : Item
{
return Item::create(['content' => $content, 'complete_by' => Carbon::today()->addYear(), 'state_id' => State::of('new')->id]);
}
Route::get('auth/twitter/callback', 'Auth\\AuthController@twitterCallback');
Route::get('auth/logout', 'Auth\\AuthController@getLogout');
Route::group(['prefix' => 'user', 'middleware' => 'auth'], function () {
Route::get('{category_id}/{book}/{chapter}/{verses}/items', function ($category_id, $book, $chapter, $verses) {
$user = \Auth::user();
$items = \App\Item::where('user_id', $user->id)->where('category_id', $category_id)->where('book', $book)->where('chapter', $chapter)->get();
return response()->json($items);
});
Route::post('item/add', function () {
$category_id = Input::get('category_id');
$book = Input::get('book');
$chapter = Input::get('chapter');
$verses = Input::get('verses');
$content = Input::get('content');
$user = \Auth::user();
$item = \App\Item::create(['user_id' => $user->id, 'category_id' => $category_id, 'book' => $book, 'chapter' => $chapter, 'verses' => $verses, 'content' => $content]);
if ($item) {
return response()->json(['success' => true]);
} else {
return response()->json(['success' => false]);
}
});
});
Route::group(['prefix' => 'api', 'middleware' => 'auth'], function () {
Route::get('books', function () {
$books = \App\Bible::books();
return response()->json($books->response);
});
Route::get('chapters/{book}', function ($book) {
$chapters = \App\Bible::chapters($book);
return response()->json($chapters->response);
public function postItem(Request $request)
{
$this->validate($request, ['romano' => 'required|max:4', 'descripcion' => 'required|min:3']);
$item = Item::create(['articulo_id' => $request->get('id'), 'romano' => $request->get('romano'), 'descripcion' => $request->get('descripcion')]);
return response()->json($item);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$input = $request->all();
$create = Item::create($input);
return response($create);
}
public function myinventory(Request $request)
{
if ($request->getMethod() == 'GET') {
return view('pages.myinventory');
} else {
if (!\Cache::has('inventory_' . $this->user->steamid64)) {
$jsonInventory = file_get_contents('http://steamcommunity.com/profiles/' . $this->user->steamid64 . '/inventory/json/730/2?l=russian');
$items = json_decode($jsonInventory, true);
if ($items['success']) {
foreach ($items['rgDescriptions'] as $class_instance => $item) {
$info = Item::where('market_hash_name', $item['market_hash_name'])->first();
if (is_null($info)) {
$info = new SteamItem($item);
if ($info->price != null) {
Item::create((array) $info);
}
}
$items['rgDescriptions'][$class_instance]['price'] = $info->price;
}
}
\Cache::put('inventory_' . $this->user->steamid64, $items, 15);
} else {
$items = \Cache::get('inventory_' . $this->user->steamid64);
}
return $items;
}
}
public function itemstore(Request $request)
{
$this->validate($request, ['item' => 'required|unique:items']);
Item::create(['item' => $request->item]);
Flash::success('আইটেম সঠিক ভাবে ইনপুট দেওয়া হয়েছে!');
return redirect()->back();
}
private function _parseItems(&$items, &$missing = false, &$price = false)
{
$itemInfo = [];
$total_price = 0;
$i = 0;
foreach ($items as $item) {
$value = $item['classid'];
if ($item['appid'] != GameController::APPID) {
$missing = true;
break;
}
$dbItemInfo = Item::where('market_hash_name', $item['market_hash_name'])->first();
if (is_null($dbItemInfo)) {
if (!isset($itemInfo[$item['classid']])) {
$itemInfo[$value] = new SteamItem($item);
}
$dbItemInfo = Item::create((array) $itemInfo[$item['classid']]);
if (!$itemInfo[$value]->price) {
$price = true;
}
} else {
if ($dbItemInfo->updated_at->getTimestamp() < Carbon::now()->subHours(5)->getTimestamp()) {
$si = new SteamItem($item);
if (!$si->price) {
$price = true;
}
if (!$si->price) {
$price = true;
}
$dbItemInfo->price = $si->price;
$dbItemInfo->save();
}
}
$itemInfo[$value] = $dbItemInfo;
if (!isset($itemInfo[$value])) {
$itemInfo[$value] = new SteamItem($item);
}
if (!$itemInfo[$value]->price) {
$price = true;
}
if ($itemInfo[$value]->price < 1) {
$itemInfo[$value]->price = 1;
}
//Если цена меньше единицы, ставим единицу
//if($itemInfo[$value]->name == "Хромированный оружейный кейс" || $itemInfo[$value]->name == "Оружейный кейс операции «Прорыв»" || $itemInfo[$value]->name == "Кейс «Фальшион»" || $itemInfo[$value]->name == "Оружейный кейс операции «Феникс»") $itemInfo[$value]->price = 1; //Если кейс ставим 1 рубль
$total_price = $total_price + $itemInfo[$value]->price;
$items[$i]['price'] = $itemInfo[$value]->price;
unset($items[$i]['appid']);
$i++;
}
return $total_price;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//
DB::table('items')->delete();
Item::create(array('title' => 'Agliè', 'location' => '45.3681,7.7681'));
Item::create(array('title' => 'Airasca', 'location' => '44.9181,7.4855'));
Item::create(array('title' => '"Ala di Stura"', 'location' => '45.3154,7.3026'));
Item::create(array('title' => '"Albiano dIvrea"', 'location' => '45.4339,7.9517'));
Item::create(array('title' => '"Alice Superiore"', 'location' => '45.4599,7.7774'));
Item::create(array('title' => 'Almese', 'location' => '45.1169,7.3954'));
Item::create(array('title' => 'Alpette', 'location' => '45.4106,7.5808'));
Item::create(array('title' => 'Alpignano', 'location' => '45.0943,7.5244'));
Item::create(array('title' => 'Andezeno', 'location' => '45.0373,7.8731'));
Item::create(array('title' => 'Andrate', 'location' => '45.5285,7.8814'));
Item::create(array('title' => 'Angrogna', 'location' => '44.8438,7.2246'));
Item::create(array('title' => 'Arignano', 'location' => '45.0438,7.9011'));
Item::create(array('title' => 'Avigliana', 'location' => '45.0793,7.3967'));
Item::create(array('title' => 'Azeglio', 'location' => '45.4246,7.995'));
Item::create(array('title' => 'Bairo', 'location' => '45.387,7.7564'));
Item::create(array('title' => 'Balangero', 'location' => '45.2714,7.5186'));
Item::create(array('title' => '"Baldissero Canavese"', 'location' => '45.4112,7.7453'));
Item::create(array('title' => '"Baldissero Torinese"', 'location' => '45.0685,7.817'));
Item::create(array('title' => 'Balme', 'location' => '45.3022,7.2181'));
Item::create(array('title' => 'Banchette', 'location' => '45.4545,7.8575'));
Item::create(array('title' => 'Barbania', 'location' => '45.2924,7.6314'));
Item::create(array('title' => 'Bardonecchia', 'location' => '45.0788,6.7043'));
Item::create(array('title' => '"Barone Canavese"', 'location' => '45.3267,7.8745'));
Item::create(array('title' => 'Beinasco', 'location' => '45.0228,7.5878'));
Item::create(array('title' => 'Bibiana', 'location' => '44.8,7.2894'));
Item::create(array('title' => '"Bobbio Pellice"', 'location' => '44.8078,7.1178'));
Item::create(array('title' => 'Bollengo', 'location' => '45.4703,7.9466'));
Item::create(array('title' => '"Borgaro Torinese"', 'location' => '45.1517,7.6578'));
Item::create(array('title' => 'Borgiallo', 'location' => '45.4181,7.6697'));
Item::create(array('title' => '"Borgofranco dIvrea"', 'location' => '45.5139,7.8592'));
Item::create(array('title' => 'Borgomasino', 'location' => '45.3642,7.9888'));
Item::create(array('title' => '"Borgone Susa"', 'location' => '45.1212,7.2398'));
Item::create(array('title' => 'Bosconero', 'location' => '45.268,7.7641'));
Item::create(array('title' => 'Brandizzo', 'location' => '45.1783,7.8389'));
Item::create(array('title' => 'Bricherasio', 'location' => '44.8245,7.3066'));
Item::create(array('title' => 'Brosso', 'location' => '45.494,7.8039'));
Item::create(array('title' => 'Brozolo', 'location' => '45.1177,8.0725'));
Item::create(array('title' => 'Bruino', 'location' => '45.0212,7.4646'));
Item::create(array('title' => 'Brusasco', 'location' => '45.1558,8.0595'));
Item::create(array('title' => 'Bruzolo', 'location' => '45.1434,7.1938'));
Item::create(array('title' => 'Buriasco', 'location' => '44.8747,7.4114'));
Item::create(array('title' => 'Burolo', 'location' => '45.4822,7.935'));
Item::create(array('title' => 'Busano', 'location' => '45.3331,7.6571'));
Item::create(array('title' => 'Bussoleno', 'location' => '45.1414,7.1475'));
Item::create(array('title' => '"Buttigliera Alta"', 'location' => '45.071,7.4295'));
Item::create(array('title' => 'Cafasse', 'location' => '45.2461,7.5184'));
Item::create(array('title' => 'Caluso', 'location' => '45.3059,7.8969'));
Item::create(array('title' => 'Cambiano', 'location' => '44.9694,7.7731'));
Item::create(array('title' => 'Campiglione-Fenile', 'location' => '44.8025,7.3235'));
Item::create(array('title' => '"Candia Canavese"', 'location' => '45.3288,7.8863'));
Item::create(array('title' => 'Candiolo', 'location' => '44.9603,7.6028'));
Item::create(array('title' => 'Canischio', 'location' => '45.3745,7.5958'));
Item::create(array('title' => 'Cantalupa', 'location' => '44.947,7.3314'));
Item::create(array('title' => 'Cantoira', 'location' => '45.3395,7.387'));
Item::create(array('title' => 'Caprie', 'location' => '45.1198,7.3331'));
Item::create(array('title' => 'Caravino', 'location' => '45.3992,7.9614'));
Item::create(array('title' => 'Carema', 'location' => '45.5845,7.8119'));
Item::create(array('title' => 'Carignano', 'location' => '44.908,7.6744'));
Item::create(array('title' => 'Carmagnola', 'location' => '44.8455,7.7192'));
Item::create(array('title' => 'Casalborgone', 'location' => '45.1312,7.9414'));
Item::create(array('title' => '"Cascinette dIvrea"', 'location' => '45.4813,7.9067'));
Item::create(array('title' => 'Caselette', 'location' => '45.1058,7.4821'));
Item::create(array('title' => '"Caselle Torinese"', 'location' => '45.1774,7.6475'));
Item::create(array('title' => '"Castagneto Po"', 'location' => '45.1603,7.8906'));
Item::create(array('title' => '"Castagnole Piemonte"', 'location' => '44.8992,7.5674'));
Item::create(array('title' => 'Castellamonte', 'location' => '45.383,7.7133'));
Item::create(array('title' => '"Castelnuovo Nigra"', 'location' => '45.4392,7.6958'));
Item::create(array('title' => '"Castiglione Torinese"', 'location' => '45.1202,7.8155'));
Item::create(array('title' => 'Cavagnolo', 'location' => '45.1529,8.0501'));
Item::create(array('title' => 'Cavour', 'location' => '44.7857,7.375'));
Item::create(array('title' => 'Cercenasco', 'location' => '44.8606,7.5049'));
Item::create(array('title' => 'Ceres', 'location' => '45.313,7.3889'));
Item::create(array('title' => '"Ceresole Reale"', 'location' => '45.4325,7.2361'));
Item::create(array('title' => '"Cesana Torinese"', 'location' => '44.9529,6.7937'));
Item::create(array('title' => 'Chialamberto', 'location' => '45.3641,7.3406'));
Item::create(array('title' => 'Chianocco', 'location' => '45.1483,7.1687'));
Item::create(array('title' => 'Chiaverano', 'location' => '45.4986,7.9048'));
Item::create(array('title' => 'Chieri', 'location' => '45.0116,7.8229'));
Item::create(array('title' => 'Chiesanuova', 'location' => '38.018,12.6594'));
Item::create(array('title' => 'Chiomonte', 'location' => '45.1192,6.9815'));
Item::create(array('title' => '"Chiusa di San Michele"', 'location' => '45.1053,7.3283'));
Item::create(array('title' => 'Chivasso', 'location' => '45.1899,7.8843'));
Item::create(array('title' => 'Ciconio', 'location' => '45.3312,7.7597'));
Item::create(array('title' => 'Cintano', 'location' => '45.4285,7.6903'));
Item::create(array('title' => 'Cinzano', 'location' => '45.0953,7.9267'));
Item::create(array('title' => 'Ciriè', 'location' => '45.2336,7.6046'));
Item::create(array('title' => 'Claviere', 'location' => '44.9388,6.7503'));
Item::create(array('title' => '"Coassolo Torinese"', 'location' => '45.2988,7.4616'));
Item::create(array('title' => 'Coazze', 'location' => '45.0556,7.3081'));
Item::create(array('title' => 'Collegno', 'location' => '45.0777,7.5704'));
Item::create(array('title' => '"Colleretto Castelnuovo"', 'location' => '45.4235,7.6809'));
Item::create(array('title' => '"Colleretto Giacosa"', 'location' => '45.4339,7.7997'));
Item::create(array('title' => 'Condove', 'location' => '45.1185,7.3088'));
Item::create(array('title' => 'Corio', 'location' => '45.3149,7.5335'));
Item::create(array('title' => '"Cossano Canavese"', 'location' => '45.3888,7.9927'));
Item::create(array('title' => 'Cuceglio', 'location' => '45.3604,7.8163'));
Item::create(array('title' => 'Cumiana', 'location' => '44.9808,7.3778'));
Item::create(array('title' => 'Cuorgnè', 'location' => '45.3907,7.6496'));
Item::create(array('title' => 'Druento', 'location' => '45.1343,7.5765'));
Item::create(array('title' => 'Exilles', 'location' => '45.0986,6.9303'));
Item::create(array('title' => 'Favria', 'location' => '45.3322,7.6917'));
Item::create(array('title' => 'Feletto', 'location' => '45.3048,7.746'));
Item::create(array('title' => 'Fenestrelle', 'location' => '45.0345,7.0522'));
Item::create(array('title' => 'Fiano', 'location' => '45.2178,7.5239'));
Item::create(array('title' => '"Fiorano Canavese"', 'location' => '45.4688,7.8349'));
Item::create(array('title' => 'Foglizzo', 'location' => '45.273,7.8209'));
Item::create(array('title' => '"Forno Canavese"', 'location' => '45.3464,7.5922'));
Item::create(array('title' => 'Frassinetto', 'location' => '45.4378,7.6078'));
Item::create(array('title' => 'Front', 'location' => '45.2819,7.6641'));
Item::create(array('title' => 'Frossasco', 'location' => '44.9341,7.3513'));
Item::create(array('title' => 'Garzigliana', 'location' => '44.8371,7.3741'));
Item::create(array('title' => '"Gassino Torinese"', 'location' => '45.1298,7.8243'));
Item::create(array('title' => 'Germagnano', 'location' => '45.2648,7.4706'));
Item::create(array('title' => 'Giaglione', 'location' => '45.1362,7.0087'));
Item::create(array('title' => 'Giaveno', 'location' => '45.0418,7.3525'));
Item::create(array('title' => 'Givoletto', 'location' => '45.1608,7.495'));
Item::create(array('title' => 'Gravere', 'location' => '45.1267,7.019'));
Item::create(array('title' => 'Groscavallo', 'location' => '45.3684,7.2591'));
Item::create(array('title' => 'Grosso', 'location' => '45.2575,7.5584'));
Item::create(array('title' => 'Grugliasco', 'location' => '45.0623,7.5783'));
Item::create(array('title' => 'Ingria', 'location' => '45.4663,7.5712'));
Item::create(array('title' => '"Inverso Pinasca"', 'location' => '44.945,7.2181'));
Item::create(array('title' => 'Isolabella', 'location' => '44.9075,7.9102'));
Item::create(array('title' => 'Issiglio', 'location' => '45.4463,7.7553'));
Item::create(array('title' => 'Ivrea', 'location' => '45.4666,7.8759'));
Item::create(array('title' => '"La Cassa"', 'location' => '45.1814,7.5175'));
Item::create(array('title' => '"La Loggia"', 'location' => '44.9588,7.6684'));
Item::create(array('title' => '"Lanzo Torinese"', 'location' => '45.2741,7.4812'));
Item::create(array('title' => 'Lauriano', 'location' => '45.1592,7.9928'));
Item::create(array('title' => 'Leini', 'location' => '45.1838,7.7153'));
Item::create(array('title' => 'Lemie', 'location' => '45.2289,7.2942'));
Item::create(array('title' => 'Lessolo', 'location' => '45.476,7.8137'));
Item::create(array('title' => 'Levone', 'location' => '45.3177,7.6075'));
Item::create(array('title' => 'Locana', 'location' => '45.4163,7.46'));
Item::create(array('title' => 'Lombardore', 'location' => '45.2364,7.7414'));
Item::create(array('title' => 'Lombriasco', 'location' => '44.8422,7.6367'));
Item::create(array('title' => 'Loranzè', 'location' => '45.4427,7.8139'));
Item::create(array('title' => 'Lugnacco', 'location' => '45.4445,7.7818'));
Item::create(array('title' => '"Luserna San Giovanni"', 'location' => '44.8085,7.2454'));
Item::create(array('title' => 'Lusernetta', 'location' => '44.8025,7.2487'));
Item::create(array('title' => 'Lusigliè', 'location' => '45.3196,7.7658'));
Item::create(array('title' => 'Macello', 'location' => '44.8522,7.3992'));
Item::create(array('title' => 'Maglione', 'location' => '45.3477,8.0146'));
Item::create(array('title' => 'Marentino', 'location' => '45.0563,7.8781'));
Item::create(array('title' => 'Massello', 'location' => '44.9586,7.0566'));
Item::create(array('title' => 'Mathi', 'location' => '45.2563,7.5431'));
Item::create(array('title' => 'Mattie', 'location' => '45.1192,7.1163'));
Item::create(array('title' => 'Mazzè', 'location' => '45.3012,7.9339'));
Item::create(array('title' => '"Meana di Susa"', 'location' => '45.1231,7.0629'));
Item::create(array('title' => 'Mercenasco', 'location' => '45.3575,7.8813'));
Item::create(array('title' => 'Meugliano', 'location' => '45.4904,7.7795'));
Item::create(array('title' => 'Mezzenile', 'location' => '45.296,7.3967'));
Item::create(array('title' => '"Mombello di Torino"', 'location' => '45.0464,7.9212'));
Item::create(array('title' => 'Mompantero', 'location' => '45.1486,7.0419'));
Item::create(array('title' => '"Monastero di Lanzo"', 'location' => '45.3016,7.4404'));
Item::create(array('title' => 'Moncalieri', 'location' => '44.9994,7.6801'));
Item::create(array('title' => 'Moncenisio', 'location' => '45.2033,6.9843'));
Item::create(array('title' => '"Montaldo Torinese"', 'location' => '45.0664,7.8514'));
Item::create(array('title' => 'Montalenghe', 'location' => '45.3384,7.84'));
Item::create(array('title' => '"Montalto Dora"', 'location' => '45.4917,7.8639'));
Item::create(array('title' => 'Montanaro', 'location' => '45.2345,7.8546'));
Item::create(array('title' => '"Monteu da Po"', 'location' => '45.1516,8.0181'));
Item::create(array('title' => '"Moriondo Torinese"', 'location' => '45.0388,7.9413'));
Item::create(array('title' => 'Nichelino', 'location' => '44.9951,7.6471'));
Item::create(array('title' => 'Noasca', 'location' => '45.4547,7.3134'));
Item::create(array('title' => 'Nole', 'location' => '45.2424,7.5742'));
Item::create(array('title' => 'Nomaglio', 'location' => '45.536,7.8603'));
Item::create(array('title' => 'None', 'location' => '44.9342,7.5413'));
Item::create(array('title' => 'Novalesa', 'location' => '45.1912,7.0148'));
Item::create(array('title' => 'Oglianico', 'location' => '45.3434,7.6958'));
Item::create(array('title' => 'Orbassano', 'location' => '45.0074,7.5374'));
Item::create(array('title' => '"Orio Canavese"', 'location' => '45.3303,7.8628'));
Item::create(array('title' => 'Osasco', 'location' => '44.8484,7.3438'));
Item::create(array('title' => 'Osasio', 'location' => '44.8725,7.6092'));
Item::create(array('title' => 'Oulx', 'location' => '45.0333,6.8336'));
Item::create(array('title' => 'Ozegna', 'location' => '45.35,7.7464'));
Item::create(array('title' => '"Palazzo Canavese"', 'location' => '45.4586,7.9797'));
Item::create(array('title' => 'Pancalieri', 'location' => '44.8346,7.587'));
Item::create(array('title' => 'Parella', 'location' => '45.4303,7.7942'));
Item::create(array('title' => 'Pavarolo', 'location' => '45.0695,7.8362'));
Item::create(array('title' => '"Pavone Canavese"', 'location' => '45.4354,7.8529'));
Item::create(array('title' => 'Pecco', 'location' => '45.4518,7.7772'));
Item::create(array('title' => '"Pecetto Torinese"', 'location' => '45.0172,7.7504'));
Item::create(array('title' => '"Perosa Argentina"', 'location' => '44.9569,7.1919'));
Item::create(array('title' => '"Perosa Canavese"', 'location' => '45.3981,7.8321'));
Item::create(array('title' => 'Perrero', 'location' => '44.9383,7.1148'));
Item::create(array('title' => 'Pertusio', 'location' => '45.3567,7.6427'));
Item::create(array('title' => 'Pessinetto', 'location' => '45.2892,7.4039'));
Item::create(array('title' => 'Pianezza', 'location' => '45.0986,7.5484'));
Item::create(array('title' => 'Pinasca', 'location' => '44.9424,7.2275'));
Item::create(array('title' => 'Pinerolo', 'location' => '44.8846,7.3309'));
Item::create(array('title' => '"Pino Torinese"', 'location' => '45.0406,7.7783'));
Item::create(array('title' => '"Piobesi Torinese"', 'location' => '44.9339,7.6113'));
Item::create(array('title' => 'Piossasco', 'location' => '44.9911,7.4635'));
Item::create(array('title' => 'Piscina', 'location' => '44.913,7.3647'));
Item::create(array('title' => 'Piverone', 'location' => '45.4474,8.0069'));
Item::create(array('title' => 'Poirino', 'location' => '44.9219,7.8481'));
Item::create(array('title' => 'Pomaretto', 'location' => '44.956,7.1829'));
Item::create(array('title' => 'Pont-Canavese', 'location' => '45.4239,7.5974'));
Item::create(array('title' => 'Porte', 'location' => '44.8879,7.2703'));
Item::create(array('title' => 'Pragelato', 'location' => '45.0155,6.942'));
Item::create(array('title' => 'Prali', 'location' => '44.8891,7.0489'));
Item::create(array('title' => 'Pralormo', 'location' => '44.8608,7.9025'));
Item::create(array('title' => 'Pramollo', 'location' => '44.904,7.2146'));
Item::create(array('title' => 'Prarostino', 'location' => '44.8666,7.2684'));
Item::create(array('title' => 'Prascorsano', 'location' => '45.3688,7.6181'));
Item::create(array('title' => 'Pratiglione', 'location' => '45.3536,7.5962'));
Item::create(array('title' => 'Quagliuzzo', 'location' => '45.4278,7.7834'));
Item::create(array('title' => 'Quassolo', 'location' => '45.5239,7.8334'));
Item::create(array('title' => 'Quincinetto', 'location' => '45.5622,7.8075'));
Item::create(array('title' => 'Reano', 'location' => '45.0522,7.4302'));
Item::create(array('title' => 'Ribordone', 'location' => '45.4332,7.5026'));
Item::create(array('title' => 'Rivalba', 'location' => '45.1194,7.8892'));
Item::create(array('title' => '"Rivalta di Torino"', 'location' => '45.033,7.5232'));
Item::create(array('title' => '"Riva presso Chieri"', 'location' => '44.9859,7.8734'));
Item::create(array('title' => 'Rivara', 'location' => '45.3334,7.6258'));
Item::create(array('title' => '"Rivarolo Canavese"', 'location' => '45.332,7.7232'));
Item::create(array('title' => 'Rivarossa', 'location' => '45.2527,7.7159'));
Item::create(array('title' => 'Rivoli', 'location' => '45.0705,7.5192'));
Item::create(array('title' => 'Robassomero', 'location' => '45.2007,7.5686'));
Item::create(array('title' => '"Rocca Canavese"', 'location' => '45.3108,7.5774'));
Item::create(array('title' => 'Roletto', 'location' => '44.9251,7.3309'));
Item::create(array('title' => '"Romano Canavese"', 'location' => '45.3902,7.8655'));
Item::create(array('title' => '"Ronco Canavese"', 'location' => '45.4997,7.5473'));
Item::create(array('title' => 'Rondissone', 'location' => '45.2478,7.9642'));
Item::create(array('title' => 'Rorà', 'location' => '44.7931,7.2002'));
Item::create(array('title' => 'Roure', 'location' => '45.0022,7.1284'));
Item::create(array('title' => 'Rosta', 'location' => '45.0689,7.4663'));
Item::create(array('title' => 'Rubiana', 'location' => '45.1388,7.3827'));
Item::create(array('title' => 'Rueglio', 'location' => '45.468,7.7561'));
Item::create(array('title' => 'Salassa', 'location' => '45.3567,7.6903'));
Item::create(array('title' => 'Salbertrand', 'location' => '45.0732,6.8842'));
Item::create(array('title' => '"Salerano Canavese"', 'location' => '45.4588,7.8512'));
Item::create(array('title' => '"Salza di Pinerolo"', 'location' => '44.941,7.0536'));
Item::create(array('title' => 'Samone', 'location' => '46.0813,11.5212'));
Item::create(array('title' => '"San Benigno Canavese"', 'location' => '45.2281,7.7863'));
Item::create(array('title' => '"San Carlo Canavese"', 'location' => '45.2456,7.6069'));
Item::create(array('title' => '"San Colombano Belmonte"', 'location' => '45.383,7.623'));
Item::create(array('title' => '"San Didero"', 'location' => '45.1354,7.2147'));
Item::create(array('title' => '"San Francesco al Campo"', 'location' => '45.2295,7.6533'));
Item::create(array('title' => 'Sangano', 'location' => '45.027,7.4505'));
Item::create(array('title' => '"San Germano Chisone"', 'location' => '44.9031,7.2378'));
Item::create(array('title' => '"San Gillio"', 'location' => '45.1438,7.5371'));
Item::create(array('title' => '"San Giorgio Canavese"', 'location' => '45.3352,7.798'));
Item::create(array('title' => '"San Giorio di Susa"', 'location' => '45.1292,7.1794'));
Item::create(array('title' => '"San Giusto Canavese"', 'location' => '45.3163,7.8103'));
Item::create(array('title' => '"San Martino Canavese"', 'location' => '45.3961,7.8178'));
Item::create(array('title' => '"San Maurizio Canavese"', 'location' => '45.2181,7.6317'));
Item::create(array('title' => '"San Mauro Torinese"', 'location' => '45.1019,7.7656'));
Item::create(array('title' => '"San Pietro Val Lemina"', 'location' => '44.9075,7.312'));
Item::create(array('title' => '"San Ponso"', 'location' => '45.3508,7.6709'));
Item::create(array('title' => '"San Raffaele Cimena"', 'location' => '45.1688,7.859'));
Item::create(array('title' => '"San Sebastiano da Po"', 'location' => '45.1683,7.9583'));
Item::create(array('title' => '"San Secondo di Pinerolo"', 'location' => '44.8675,7.2995'));
Item::create(array('title' => '"SantAmbrogio di Torino"', 'location' => '45.0978,7.3622'));
Item::create(array('title' => '"SantAntonino di Susa"', 'location' => '45.1081,7.2749'));
Item::create(array('title' => 'Santena', 'location' => '44.949,7.7728'));
Item::create(array('title' => '"Sauze di Cesana"', 'location' => '44.9417,6.8602'));
Item::create(array('title' => '"Sauze dOulx"', 'location' => '45.0275,6.8596'));
Item::create(array('title' => 'Scalenghe', 'location' => '44.8873,7.4968'));
Item::create(array('title' => 'Scarmagno', 'location' => '45.3855,7.8424'));
Item::create(array('title' => 'Sciolze', 'location' => '45.0942,7.8816'));
Item::create(array('title' => 'Sestriere', 'location' => '44.9569,6.8801'));
Item::create(array('title' => '"Settimo Rottaro"', 'location' => '45.4092,7.9938'));
Item::create(array('title' => '"Settimo Torinese"', 'location' => '45.1371,7.7709'));
Item::create(array('title' => '"Settimo Vittone"', 'location' => '45.5508,7.8335'));
Item::create(array('title' => 'Sparone', 'location' => '45.4148,7.5445'));
Item::create(array('title' => 'Strambinello', 'location' => '45.424,7.7721'));
Item::create(array('title' => 'Strambino', 'location' => '45.3816,7.8848'));
Item::create(array('title' => 'Susa', 'location' => '45.1385,7.0484'));
Item::create(array('title' => 'Tavagnasco', 'location' => '45.546,7.8239'));
Item::create(array('title' => 'Torino', 'location' => '45.05,7.6667'));
Item::create(array('title' => '"Torrazza Piemonte"', 'location' => '45.2164,7.9778'));
Item::create(array('title' => '"Torre Canavese"', 'location' => '45.3931,7.7609'));
Item::create(array('title' => '"Torre Pellice"', 'location' => '44.8206,7.2237'));
Item::create(array('title' => 'Trana', 'location' => '45.04,7.423'));
Item::create(array('title' => 'Trausella', 'location' => '45.4908,7.7632'));
Item::create(array('title' => 'Traversella', 'location' => '45.5096,7.7506'));
Item::create(array('title' => 'Traves', 'location' => '45.2683,7.4308'));
Item::create(array('title' => 'Trofarello', 'location' => '44.9847,7.7464'));
Item::create(array('title' => 'Usseaux', 'location' => '45.0486,7.0267'));
Item::create(array('title' => 'Usseglio', 'location' => '45.2328,7.2172'));
Item::create(array('title' => 'Vaie', 'location' => '45.1016,7.2898'));
Item::create(array('title' => '"Val della Torre"', 'location' => '45.1563,7.4463'));
Item::create(array('title' => 'Valgioie', 'location' => '45.0761,7.3407'));
Item::create(array('title' => '"Vallo Torinese"', 'location' => '45.2245,7.4975'));
Item::create(array('title' => 'Valperga', 'location' => '45.3701,7.6579'));
Item::create(array('title' => '"Valprato Soana"', 'location' => '45.5222,7.5502'));
Item::create(array('title' => 'Varisella', 'location' => '45.2096,7.4861'));
Item::create(array('title' => '"Vauda Canavese"', 'location' => '45.2792,7.6164'));
Item::create(array('title' => 'Venaus', 'location' => '45.1596,7.0092'));
Item::create(array('title' => '"Venaria Reale"', 'location' => '45.1342,7.629'));
Item::create(array('title' => 'Verolengo', 'location' => '45.1911,7.9694'));
Item::create(array('title' => '"Verrua Savoia"', 'location' => '45.1578,8.0935'));
Item::create(array('title' => 'Vestignè', 'location' => '45.3867,7.9559'));
Item::create(array('title' => 'Vialfrè', 'location' => '45.3812,7.8177'));
Item::create(array('title' => '"Vico Canavese"', 'location' => '45.397,7.4668'));
Item::create(array('title' => 'Vidracco', 'location' => '45.4317,7.7586'));
Item::create(array('title' => 'Vigone', 'location' => '44.8455,7.4961'));
Item::create(array('title' => '"Villafranca Piemonte"', 'location' => '44.78,7.5016'));
Item::create(array('title' => '"Villanova Canavese"', 'location' => '45.2445,7.5533'));
Item::create(array('title' => 'Villarbasse', 'location' => '45.0463,7.4695'));
Item::create(array('title' => '"Villar Dora"', 'location' => '45.1156,7.3847'));
Item::create(array('title' => 'Villareggia', 'location' => '45.3111,7.9778'));
Item::create(array('title' => '"Villar Focchiardo"', 'location' => '45.1103,7.2328'));
Item::create(array('title' => '"Villar Pellice"', 'location' => '44.8094,7.1533'));
Item::create(array('title' => '"Villar Perosa"', 'location' => '44.9193,7.2481'));
Item::create(array('title' => 'Villastellone', 'location' => '44.9218,7.7446'));
Item::create(array('title' => 'Vinovo', 'location' => '44.9482,7.6338'));
Item::create(array('title' => '"Virle Piemonte"', 'location' => '44.8656,7.5713'));
Item::create(array('title' => 'Vische', 'location' => '45.3352,7.9459'));
Item::create(array('title' => 'Vistrorio', 'location' => '45.443,7.7685'));
Item::create(array('title' => 'Viù', 'location' => '45.2389,7.3766'));
Item::create(array('title' => 'Volpiano', 'location' => '45.2015,7.7773'));
Item::create(array('title' => 'Volvera', 'location' => '44.956,7.5125'));
Item::create(array('title' => '"Alagna Valsesia"', 'location' => '45.8542,7.9374'));
Item::create(array('title' => '"Albano Vercellese"', 'location' => '45.4272,8.3807'));
Item::create(array('title' => '"Alice Castello"', 'location' => '45.3663,8.0741'));
Item::create(array('title' => 'Arborio', 'location' => '45.4959,8.3864'));
Item::create(array('title' => '"Asigliano Vercellese"', 'location' => '45.2625,8.4097'));
Item::create(array('title' => 'Balmuccia', 'location' => '45.8189,8.1427'));
Item::create(array('title' => 'Balocco', 'location' => '45.4562,8.2813'));
Item::create(array('title' => 'Bianzè', 'location' => '45.3096,8.1238'));
Item::create(array('title' => 'Boccioleto', 'location' => '45.8302,8.113'));
Item::create(array('title' => '"Borgo dAle"', 'location' => '45.3527,8.0519'));
Item::create(array('title' => 'Borgosesia', 'location' => '45.7153,8.2772'));
Item::create(array('title' => '"Borgo Vercelli"', 'location' => '45.3589,8.4642'));
Item::create(array('title' => 'Breia', 'location' => '45.7667,8.3108'));
Item::create(array('title' => 'Buronzo', 'location' => '45.4819,8.2683'));
Item::create(array('title' => 'Campertogno', 'location' => '45.7999,8.0333'));
Item::create(array('title' => 'Carcoforo', 'location' => '45.9096,8.0457'));
Item::create(array('title' => 'Caresana', 'location' => '45.2219,8.5064'));
Item::create(array('title' => 'Caresanablot', 'location' => '45.3585,8.3931'));
Item::create(array('title' => 'Carisio', 'location' => '45.4103,8.2002'));
Item::create(array('title' => '"Casanova Elvo"', 'location' => '45.402,8.2947'));
Item::create(array('title' => '"San Giacomo Vercellese"', 'location' => '45.4992,8.3278'));
Item::create(array('title' => 'Cellio', 'location' => '45.7571,8.3117'));
Item::create(array('title' => 'Cervatto', 'location' => '45.8829,8.1633'));
Item::create(array('title' => 'Cigliano', 'location' => '45.3094,8.0222'));
Item::create(array('title' => 'Civiasco', 'location' => '45.8069,8.2932'));
Item::create(array('title' => 'Collobiano', 'location' => '45.397,8.3493'));
Item::create(array('title' => 'Costanzana', 'location' => '45.2372,8.3711'));
Item::create(array('title' => 'Cravagliana', 'location' => '45.8485,8.203'));
Item::create(array('title' => 'Crescentino', 'location' => '45.1914,8.1011'));
Item::create(array('title' => 'Crova', 'location' => '45.3317,8.2121'));
Item::create(array('title' => 'Desana', 'location' => '45.2706,8.361'));
Item::create(array('title' => 'Fobello', 'location' => '45.8902,8.1578'));
Item::create(array('title' => '"Fontanetto Po"', 'location' => '45.1942,8.1927'));
Item::create(array('title' => 'Formigliana', 'location' => '45.4294,8.2928'));
Item::create(array('title' => 'Gattinara', 'location' => '45.6189,8.3686'));
Item::create(array('title' => 'Ghislarengo', 'location' => '45.53,8.3863'));
Item::create(array('title' => 'Greggio', 'location' => '45.4517,8.3842'));
Item::create(array('title' => 'Guardabosone', 'location' => '45.702,8.2493'));
Item::create(array('title' => 'Lamporo', 'location' => '45.2306,8.0974'));
Item::create(array('title' => 'Lenta', 'location' => '45.556,8.3836'));
Item::create(array('title' => 'Lignana', 'location' => '45.287,8.345'));
Item::create(array('title' => '"Livorno Ferraris"', 'location' => '45.285,8.0786'));
Item::create(array('title' => 'Lozzolo', 'location' => '45.6265,8.324'));
Item::create(array('title' => 'Mollia', 'location' => '45.8151,8.0308'));
Item::create(array('title' => 'Moncrivello', 'location' => '45.3335,7.9967'));
Item::create(array('title' => '"Motta de Conti"', 'location' => '45.1945,8.522'));
Item::create(array('title' => 'Olcenengo', 'location' => '45.3646,8.3109'));
Item::create(array('title' => 'Oldenico', 'location' => '45.4038,8.3822'));
Item::create(array('title' => '"Palazzolo Vercellese"', 'location' => '45.1856,8.2308'));
Item::create(array('title' => 'Pertengo', 'location' => '45.236,8.4176'));
Item::create(array('title' => 'Pezzana', 'location' => '45.2631,8.4863'));
Item::create(array('title' => 'Pila', 'location' => '45.7705,8.0833'));
Item::create(array('title' => 'Piode', 'location' => '45.772,8.0517'));
Item::create(array('title' => 'Postua', 'location' => '45.7139,8.2317'));
Item::create(array('title' => 'Prarolo', 'location' => '45.281,8.4777'));
Item::create(array('title' => 'Quarona', 'location' => '45.7589,8.2669'));
Item::create(array('title' => '"Quinto Vercellese"', 'location' => '45.3806,8.3628'));
Item::create(array('title' => 'Rassa', 'location' => '45.7684,8.012'));
Item::create(array('title' => '"Rima San Giuseppe"', 'location' => '45.8847,7.9989'));
Item::create(array('title' => 'Rimasco', 'location' => '45.86,8.0639'));
Item::create(array('title' => 'Rimella', 'location' => '45.9091,8.1835'));
Item::create(array('title' => '"Riva Valdobbia"', 'location' => '45.832,7.9578'));
Item::create(array('title' => 'Rive', 'location' => '45.2152,8.4188'));
Item::create(array('title' => 'Roasio', 'location' => '45.6058,8.2871'));
Item::create(array('title' => 'Ronsecco', 'location' => '45.2531,8.2781'));
Item::create(array('title' => 'Rossa', 'location' => '45.833,8.1206'));
Item::create(array('title' => 'Rovasenda', 'location' => '45.5399,8.3188'));
Item::create(array('title' => 'Sabbia', 'location' => '45.857,8.2361'));
Item::create(array('title' => 'Salasco', 'location' => '45.3259,8.2652'));
Item::create(array('title' => '"Sali Vercellese"', 'location' => '45.311,8.33'));
Item::create(array('title' => 'Saluggia', 'location' => '45.2386,8.0122'));
Item::create(array('title' => '"San Germano Vercellese"', 'location' => '45.3514,8.2489'));
Item::create(array('title' => 'Santhià', 'location' => '45.3674,8.1738'));
Item::create(array('title' => 'Scopa', 'location' => '45.7939,8.1152'));
Item::create(array('title' => 'Scopello', 'location' => '45.7736,8.096'));
Item::create(array('title' => '"Serravalle Sesia"', 'location' => '45.6875,8.3094'));
Item::create(array('title' => 'Stroppiana', 'location' => '45.2312,8.455'));
Item::create(array('title' => 'Tricerro', 'location' => '45.2367,8.3264'));
Item::create(array('title' => 'Trino', 'location' => '45.1931,8.2974'));
Item::create(array('title' => '"Tronzano Vercellese"', 'location' => '45.3424,8.1742'));
Item::create(array('title' => 'Valduggia', 'location' => '45.7294,8.3311'));
Item::create(array('title' => 'Varallo', 'location' => '45.8138,8.2535'));
Item::create(array('title' => 'Vercelli', 'location' => '45.321,8.4263'));
Item::create(array('title' => 'Villarboit', 'location' => '45.4385,8.3384'));
Item::create(array('title' => 'Villata', 'location' => '45.3888,8.4338'));
Item::create(array('title' => 'Vocca', 'location' => '45.8328,8.1958'));
Item::create(array('title' => '"Agrate Conturbia"', 'location' => '45.6774,8.5584'));
Item::create(array('title' => 'Ameno', 'location' => '45.7897,8.442'));
Item::create(array('title' => 'Armeno', 'location' => '45.8225,8.44'));
Item::create(array('title' => 'Arona', 'location' => '45.757,8.56'));
Item::create(array('title' => 'Barengo', 'location' => '45.577,8.5152'));
Item::create(array('title' => '"Bellinzago Novarese"', 'location' => '45.5699,8.6444'));
Item::create(array('title' => 'Biandrate', 'location' => '45.4538,8.4636'));
Item::create(array('title' => 'Boca', 'location' => '45.6796,8.4093'));
Item::create(array('title' => 'Bogogno', 'location' => '45.6644,8.5357'));
Item::create(array('title' => '"Bolzano Novarese"', 'location' => '45.765,8.4461'));
Item::create(array('title' => 'Borgolavezzaro', 'location' => '45.3206,8.7006'));
Item::create(array('title' => 'Borgomanero', 'location' => '45.6987,8.4626'));
Item::create(array('title' => '"Borgo Ticino"', 'location' => '45.6903,8.603'));
Item::create(array('title' => '"Briga Novarese"', 'location' => '45.7333,8.4509'));
Item::create(array('title' => 'Briona', 'location' => '45.5434,8.481'));
Item::create(array('title' => 'Caltignaga', 'location' => '45.5199,8.5899'));
Item::create(array('title' => 'Cameri', 'location' => '45.5042,8.6639'));
Item::create(array('title' => '"Carpignano Sesia"', 'location' => '45.5353,8.4195'));
Item::create(array('title' => 'Casalbeltrame', 'location' => '45.4388,8.4663'));
Item::create(array('title' => '"Casaleggio Novara"', 'location' => '45.4899,8.4931'));
Item::create(array('title' => 'Casalino', 'location' => '45.3594,8.525'));
Item::create(array('title' => 'Casalvolone', 'location' => '45.4017,8.4645'));
Item::create(array('title' => '"Castellazzo Novarese"', 'location' => '45.5144,8.4881'));
Item::create(array('title' => '"Castelletto sopra Ticino"', 'location' => '45.7187,8.6368'));
Item::create(array('title' => 'Cavaglietto', 'location' => '45.6031,8.5033'));
Item::create(array('title' => '"Cavaglio dAgogna"', 'location' => '45.6142,8.4874'));
Item::create(array('title' => 'Cavallirio', 'location' => '45.6644,8.3956'));
Item::create(array('title' => 'Cerano', 'location' => '45.412,8.7813'));
Item::create(array('title' => 'Colazza', 'location' => '45.7936,8.5014'));
Item::create(array('title' => 'Comignago', 'location' => '45.716,8.5652'));
Item::create(array('title' => 'Cressa', 'location' => '45.6492,8.5102'));
Item::create(array('title' => 'Cureggio', 'location' => '45.676,8.461'));
Item::create(array('title' => 'Divignano', 'location' => '45.6635,8.6028'));
Item::create(array('title' => 'Dormelletto', 'location' => '45.7272,8.5803'));
Item::create(array('title' => '"Fara Novarese"', 'location' => '45.5528,8.4599'));
Item::create(array('title' => '"Fontaneto dAgogna"', 'location' => '45.6583,8.4803'));
Item::create(array('title' => 'Galliate', 'location' => '45.4781,8.696'));
Item::create(array('title' => '"Garbagna Novarese"', 'location' => '45.3851,8.6608'));
Item::create(array('title' => 'Gargallo', 'location' => '45.7299,8.4264'));
Item::create(array('title' => 'Gattico', 'location' => '45.7081,8.5213'));
Item::create(array('title' => 'Ghemme', 'location' => '45.6006,8.4227'));
Item::create(array('title' => 'Gozzano', 'location' => '45.7475,8.4378'));
Item::create(array('title' => '"Granozzo con Monticello"', 'location' => '45.3613,8.5746'));
Item::create(array('title' => 'Grignasco', 'location' => '45.6808,8.3442'));
Item::create(array('title' => 'Invorio', 'location' => '45.7579,8.4895'));
Item::create(array('title' => 'Landiona', 'location' => '45.4975,8.4234'));
Item::create(array('title' => 'Lesa', 'location' => '45.8241,8.5609'));
Item::create(array('title' => 'Maggiora', 'location' => '45.6903,8.4234'));
Item::create(array('title' => '"Mandello Vitta"', 'location' => '45.4967,8.4609'));
Item::create(array('title' => '"Marano Ticino"', 'location' => '45.631,8.6328'));
Item::create(array('title' => '"Massino Visconti"', 'location' => '45.8222,8.54'));
Item::create(array('title' => 'Meina', 'location' => '45.7899,8.54'));
Item::create(array('title' => 'Mezzomerico', 'location' => '45.6197,8.6067'));
Item::create(array('title' => 'Miasino', 'location' => '45.803,8.431'));
Item::create(array('title' => 'Momo', 'location' => '45.5766,8.5545'));
Item::create(array('title' => 'Nebbiuno', 'location' => '45.8044,8.5234'));
Item::create(array('title' => 'Nibbiola', 'location' => '45.3727,8.6575'));
Item::create(array('title' => 'Novara', 'location' => '45.4451,8.6187'));
Item::create(array('title' => 'Oleggio', 'location' => '45.5967,8.6376'));
Item::create(array('title' => '"Oleggio Castello"', 'location' => '45.7485,8.5269'));
Item::create(array('title' => '"Orta San Giulio"', 'location' => '45.7989,8.4199'));
Item::create(array('title' => 'Paruzzaro', 'location' => '45.7497,8.5177'));
Item::create(array('title' => 'Pella', 'location' => '45.8001,8.3859'));
Item::create(array('title' => 'Pettenasco', 'location' => '45.8175,8.4081'));
Item::create(array('title' => 'Pisano', 'location' => '45.7936,8.5115'));
Item::create(array('title' => 'Pogno', 'location' => '45.7566,8.3858'));
Item::create(array('title' => 'Pombia', 'location' => '45.652,8.6335'));
Item::create(array('title' => '"Prato Sesia"', 'location' => '45.6474,8.3738'));
Item::create(array('title' => 'Recetto', 'location' => '45.4614,8.4369'));
Item::create(array('title' => '"Romagnano Sesia"', 'location' => '45.632,8.3899'));
Item::create(array('title' => 'Romentino', 'location' => '45.465,8.7202'));
Item::create(array('title' => '"San Maurizio dOpaglio"', 'location' => '45.7722,8.3988'));
Item::create(array('title' => '"San Nazzaro Sesia"', 'location' => '45.4389,8.4255'));
Item::create(array('title' => '"San Pietro Mosezzo"', 'location' => '45.4659,8.5242'));
Item::create(array('title' => 'Sillavengo', 'location' => '45.5217,8.4422'));
Item::create(array('title' => 'Sizzano', 'location' => '45.5779,8.4379'));
Item::create(array('title' => 'Soriso', 'location' => '45.7414,8.4106'));
Item::create(array('title' => 'Sozzago', 'location' => '45.3995,8.7209'));
Item::create(array('title' => 'Suno', 'location' => '45.6344,8.5439'));
Item::create(array('title' => 'Terdobbiate', 'location' => '45.3775,8.6964'));
Item::create(array('title' => 'Tornaco', 'location' => '45.3586,8.717'));
Item::create(array('title' => 'Trecate', 'location' => '45.4327,8.7382'));
Item::create(array('title' => '"Vaprio dAgogna"', 'location' => '45.6047,8.5547'));
Item::create(array('title' => '"Varallo Pombia"', 'location' => '45.6678,8.63'));
Item::create(array('title' => 'Veruno', 'location' => '45.6898,8.5299'));
Item::create(array('title' => 'Vespolate', 'location' => '45.3514,8.6689'));
Item::create(array('title' => 'Vicolungo', 'location' => '45.4786,8.4639'));
Item::create(array('title' => 'Vinzaglio', 'location' => '45.3239,8.5203'));
Item::create(array('title' => 'Acceglio', 'location' => '44.4752,6.9907'));
Item::create(array('title' => 'Aisone', 'location' => '44.3135,7.2191'));
Item::create(array('title' => 'Alba', 'location' => '44.7009,8.0353'));
Item::create(array('title' => '"Albaretto della Torre"', 'location' => '44.5968,8.0645'));
Item::create(array('title' => 'Alto', 'location' => '44.1089,8.0028'));
Item::create(array('title' => 'Argentera', 'location' => '44.8898,6.9341'));
Item::create(array('title' => 'Arguello', 'location' => '44.5831,8.1086'));
Item::create(array('title' => 'Bagnasco', 'location' => '44.3073,8.0463'));
Item::create(array('title' => '"Bagnolo Piemonte"', 'location' => '44.7616,7.315'));
Item::create(array('title' => '"Baldissero d Alba"', 'location' => '44.7639,7.9086'));
Item::create(array('title' => 'Barbaresco', 'location' => '44.725,8.0809'));
Item::create(array('title' => 'Barge', 'location' => '44.7253,7.3242'));
Item::create(array('title' => 'Barolo', 'location' => '44.6104,7.9426'));
Item::create(array('title' => '"Bastia Mondovì"', 'location' => '44.443,7.8956'));
Item::create(array('title' => 'Battifollo', 'location' => '44.3215,8.0071'));
Item::create(array('title' => 'Beinette', 'location' => '44.366,7.6478'));
Item::create(array('title' => 'Bellino', 'location' => '44.5805,7.0172'));
Item::create(array('title' => '"Belvedere Langhe"', 'location' => '44.4946,7.9721'));
Item::create(array('title' => '"Bene Vagienna"', 'location' => '44.5444,7.8296'));
Item::create(array('title' => 'Benevello', 'location' => '44.631,8.1053'));
Item::create(array('title' => 'Bergolo', 'location' => '44.5488,8.1843'));
Item::create(array('title' => 'Bernezzo', 'location' => '44.3863,7.4366'));
Item::create(array('title' => 'Bonvicino', 'location' => '44.5047,8.0171'));
Item::create(array('title' => 'Borgomale', 'location' => '44.6215,8.1324'));
Item::create(array('title' => '"Borgo San Dalmazzo"', 'location' => '44.3296,7.4885'));
Item::create(array('title' => 'Bosia', 'location' => '44.6025,8.1479'));
Item::create(array('title' => 'Bossolasco', 'location' => '44.5292,8.0521'));
Item::create(array('title' => 'Boves', 'location' => '44.3292,7.5518'));
Item::create(array('title' => 'Bra', 'location' => '44.6978,7.8545'));
Item::create(array('title' => 'Briaglia', 'location' => '44.3951,7.8769'));
Item::create(array('title' => '"Briga Alta"', 'location' => '44.0834,7.7495'));
Item::create(array('title' => 'Brondello', 'location' => '44.6017,7.407'));
Item::create(array('title' => 'Brossasco', 'location' => '44.5697,7.3628'));
Item::create(array('title' => 'Busca', 'location' => '45.1347,9.2169'));
Item::create(array('title' => 'Camerana', 'location' => '44.4228,8.1406'));
Item::create(array('title' => 'Camo', 'location' => '44.6954,8.1949'));
Item::create(array('title' => 'Canale', 'location' => '42.6888,12.1338'));
Item::create(array('title' => 'Canosio', 'location' => '44.4556,7.0824'));
Item::create(array('title' => 'Caprauna', 'location' => '44.117,7.9559'));
Item::create(array('title' => 'Caraglio', 'location' => '44.4205,7.4341'));
Item::create(array('title' => '"Caramagna Piemonte"', 'location' => '44.7803,7.739'));
Item::create(array('title' => 'Cardè', 'location' => '44.7455,7.4788'));
Item::create(array('title' => 'Carrù', 'location' => '44.4796,7.8771'));
Item::create(array('title' => 'Cartignano', 'location' => '44.4789,7.2861'));
Item::create(array('title' => 'Casalgrasso', 'location' => '44.8183,7.626'));
Item::create(array('title' => 'Castagnito', 'location' => '44.7564,8.0325'));
Item::create(array('title' => 'Casteldelfino', 'location' => '44.5906,7.0709'));
Item::create(array('title' => 'Castellar', 'location' => '44.6217,7.4373'));
Item::create(array('title' => '"Castelletto Stura"', 'location' => '44.4448,7.6403'));
Item::create(array('title' => '"Castelletto Uzzone"', 'location' => '44.499,8.1879'));
Item::create(array('title' => 'Castellinaldo', 'location' => '44.776,8.031'));
Item::create(array('title' => '"Castellino Tanaro"', 'location' => '44.4281,7.9813'));
Item::create(array('title' => 'Castelmagno', 'location' => '44.4088,7.2122'));
Item::create(array('title' => '"Castelnuovo di Ceva"', 'location' => '44.3541,8.1293'));
Item::create(array('title' => '"Castiglione Falletto"', 'location' => '44.6236,7.9764'));
Item::create(array('title' => '"Castiglione Tinella"', 'location' => '44.7264,8.1913'));
Item::create(array('title' => 'Castino', 'location' => '44.6189,8.1836'));
Item::create(array('title' => 'Cavallerleone', 'location' => '44.7413,7.665'));
Item::create(array('title' => 'Cavallermaggiore', 'location' => '44.711,7.6875'));
Item::create(array('title' => '"Celle di Macra"', 'location' => '44.4828,7.1806'));
Item::create(array('title' => 'Centallo', 'location' => '44.5036,7.5864'));
Item::create(array('title' => '"Ceresole Alba"', 'location' => '44.8008,7.8236'));
Item::create(array('title' => '"Cerretto Langhe"', 'location' => '44.5755,8.0986'));
Item::create(array('title' => 'Cervasca', 'location' => '44.382,7.4724'));
Item::create(array('title' => 'Cervere', 'location' => '44.6364,7.7931'));
Item::create(array('title' => 'Ceva', 'location' => '44.3874,8.035'));
Item::create(array('title' => 'Cherasco', 'location' => '44.6516,7.8583'));
Item::create(array('title' => '"Chiusa di Pesio"', 'location' => '44.3235,7.677'));
Item::create(array('title' => 'Cigliè', 'location' => '44.4375,7.9277'));
Item::create(array('title' => 'Cissone', 'location' => '44.5625,8.0308'));
Item::create(array('title' => 'Clavesana', 'location' => '44.4834,7.9018'));
Item::create(array('title' => '"Corneliano d Alba"', 'location' => '44.7372,7.9585'));
Item::create(array('title' => 'Cortemilia', 'location' => '44.5798,8.1913'));
Item::create(array('title' => '"Cossano Belbo"', 'location' => '44.6698,8.1993'));
Item::create(array('title' => '"Costigliole Saluzzo"', 'location' => '44.5656,7.4866'));
Item::create(array('title' => 'Cravanzana', 'location' => '44.5736,8.1284'));
Item::create(array('title' => 'Crissolo', 'location' => '44.6986,7.1587'));
Item::create(array('title' => 'Cuneo', 'location' => '44.3888,7.5471'));
Item::create(array('title' => 'Demonte', 'location' => '44.3151,7.2954'));
Item::create(array('title' => '"Diano d Alba"', 'location' => '44.6511,8.0284'));
Item::create(array('title' => 'Dogliani', 'location' => '44.5306,7.9459'));
Item::create(array('title' => 'Dronero', 'location' => '44.4667,7.3525'));
Item::create(array('title' => 'Elva', 'location' => '44.5399,7.0898'));
Item::create(array('title' => 'Entracque', 'location' => '44.2406,7.3976'));
Item::create(array('title' => 'Envie', 'location' => '44.6833,7.3724'));
Item::create(array('title' => 'Farigliano', 'location' => '44.5112,7.9162'));
Item::create(array('title' => 'Faule', 'location' => '44.807,7.5823'));
Item::create(array('title' => 'Feisoglio', 'location' => '44.5449,8.1061'));
Item::create(array('title' => 'Fossano', 'location' => '44.55,7.7238'));
Item::create(array('title' => '"Frabosa Soprana"', 'location' => '44.2887,7.8062'));
Item::create(array('title' => '"Frabosa Sottana"', 'location' => '44.3019,7.7979'));
Item::create(array('title' => 'Frassino', 'location' => '44.5727,7.2772'));
Item::create(array('title' => 'Gaiola', 'location' => '44.3362,7.4081'));
Item::create(array('title' => 'Gambasca', 'location' => '44.6299,7.3484'));
Item::create(array('title' => 'Garessio', 'location' => '44.2062,8.0153'));
Item::create(array('title' => 'Genola', 'location' => '44.5896,7.6654'));
Item::create(array('title' => 'Gorzegno', 'location' => '44.5124,8.1346'));
Item::create(array('title' => 'Gottasecca', 'location' => '44.4614,8.1684'));
Item::create(array('title' => 'Govone', 'location' => '44.8051,8.0951'));
Item::create(array('title' => '"Grinzane Cavour"', 'location' => '44.6566,7.9817'));
Item::create(array('title' => 'Guarene', 'location' => '44.7407,8.0341'));
Item::create(array('title' => 'Igliano', 'location' => '44.4438,8.0137'));
Item::create(array('title' => 'Isasca', 'location' => '44.5874,7.3809'));
Item::create(array('title' => 'Lagnasco', 'location' => '44.6261,7.5559'));
Item::create(array('title' => '"La Morra"', 'location' => '44.6396,7.9338'));
Item::create(array('title' => '"Lequio Berria"', 'location' => '44.6075,8.0981'));
Item::create(array('title' => '"Lequio Tanaro"', 'location' => '44.5601,7.8847'));
Item::create(array('title' => 'Lesegno', 'location' => '44.4017,7.9656'));
Item::create(array('title' => 'Levice', 'location' => '44.5388,8.1562'));
Item::create(array('title' => '"Limone Piemonte"', 'location' => '44.2014,7.5762'));
Item::create(array('title' => 'Lisio', 'location' => '44.3078,7.9785'));
Item::create(array('title' => 'Macra', 'location' => '44.5013,7.1806'));
Item::create(array('title' => '"Magliano Alfieri"', 'location' => '44.7703,8.0713'));
Item::create(array('title' => '"Magliano Alpi"', 'location' => '44.4606,7.8064'));
Item::create(array('title' => 'Mango', 'location' => '44.6867,8.1518'));
Item::create(array('title' => 'Manta', 'location' => '44.6169,7.4881'));
Item::create(array('title' => 'Marene', 'location' => '44.6627,7.7335'));
Item::create(array('title' => 'Margarita', 'location' => '44.4046,7.6861'));
Item::create(array('title' => 'Marmora', 'location' => '44.4581,7.0935'));
Item::create(array('title' => 'Marsaglia', 'location' => '44.7128,9.3831'));
Item::create(array('title' => '"Martiniana Po"', 'location' => '44.6274,7.3673'));
Item::create(array('title' => 'Melle', 'location' => '44.5627,7.3214'));
Item::create(array('title' => 'Moiola', 'location' => '44.3225,7.3902'));
Item::create(array('title' => 'Mombarcaro', 'location' => '44.4682,8.0867'));
Item::create(array('title' => 'Mombasiglio', 'location' => '44.3677,7.9691'));
Item::create(array('title' => '"Monastero di Vasco"', 'location' => '44.3408,7.8228'));
Item::create(array('title' => '"Monasterolo Casotto"', 'location' => '44.3255,7.9455'));
Item::create(array('title' => '"Monasterolo di Savigliano"', 'location' => '44.6874,7.6206'));
Item::create(array('title' => 'Monchiero', 'location' => '44.5729,7.9171'));
Item::create(array('title' => 'Mondovì', 'location' => '44.3896,7.8206'));
Item::create(array('title' => 'Monesiglio', 'location' => '44.4657,8.1189'));
Item::create(array('title' => '"Monforte d Alba"', 'location' => '44.5831,7.9678'));
Item::create(array('title' => 'Montà', 'location' => '44.8147,7.9585'));
Item::create(array('title' => '"Montaldo di Mondovì"', 'location' => '44.3195,7.8653'));
Item::create(array('title' => '"Montaldo Roero"', 'location' => '44.7694,7.9259'));
Item::create(array('title' => 'Montanera', 'location' => '44.4633,7.6667'));
Item::create(array('title' => '"Montelupo Albese"', 'location' => '44.622,8.0479'));
Item::create(array('title' => '"Montemale di Cuneo"', 'location' => '44.4373,7.3749'));
Item::create(array('title' => '"Monterosso Grana"', 'location' => '44.4092,7.3241'));
Item::create(array('title' => '"Monteu Roero"', 'location' => '44.7803,7.9375'));
Item::create(array('title' => 'Montezemolo', 'location' => '44.3781,8.1414'));
Item::create(array('title' => '"Monticello d Alba"', 'location' => '44.719,7.9437'));
Item::create(array('title' => 'Moretta', 'location' => '44.7648,7.5383'));
Item::create(array('title' => 'Morozzo', 'location' => '44.4231,7.7101'));
Item::create(array('title' => 'Murazzano', 'location' => '44.474,8.0205'));
Item::create(array('title' => 'Murello', 'location' => '44.7531,7.602'));
Item::create(array('title' => 'Narzole', 'location' => '44.5964,7.8709'));
Item::create(array('title' => 'Neive', 'location' => '44.7264,8.1158'));
Item::create(array('title' => 'Neviglie', 'location' => '44.6922,8.118'));
Item::create(array('title' => '"Niella Belbo"', 'location' => '44.5138,8.0805'));
Item::create(array('title' => '"Niella Tanaro"', 'location' => '44.4138,7.9235'));
Item::create(array('title' => 'Novello', 'location' => '44.5888,7.9275'));
Item::create(array('title' => 'Nucetto', 'location' => '44.3419,8.061'));
Item::create(array('title' => 'Oncino', 'location' => '44.6762,7.1905'));
Item::create(array('title' => 'Ormea', 'location' => '44.1485,7.9136'));
Item::create(array('title' => 'Ostana', 'location' => '44.6931,7.1868'));
Item::create(array('title' => 'Paesana', 'location' => '44.6863,7.2759'));
Item::create(array('title' => 'Pagno', 'location' => '44.6128,7.4269'));
Item::create(array('title' => 'Pamparato', 'location' => '44.2777,7.9136'));
Item::create(array('title' => 'Paroldo', 'location' => '44.4331,8.0736'));
Item::create(array('title' => 'Perletto', 'location' => '44.6003,8.2142'));
Item::create(array('title' => 'Perlo', 'location' => '44.3328,8.0836'));
Item::create(array('title' => 'Peveragno', 'location' => '44.3325,7.6209'));
Item::create(array('title' => '"Pezzolo Valle Uzzone"', 'location' => '44.5398,8.1948'));
Item::create(array('title' => 'Pianfei', 'location' => '44.3731,7.7125'));
Item::create(array('title' => 'Piasco', 'location' => '44.5641,7.455'));
Item::create(array('title' => 'Pietraporzio', 'location' => '44.3445,7.0318'));
Item::create(array('title' => '"Piobesi d Alba"', 'location' => '44.7363,7.9808'));
Item::create(array('title' => 'Piozzo', 'location' => '44.5148,7.8938'));
Item::create(array('title' => 'Pocapaglia', 'location' => '44.7162,7.8841'));
Item::create(array('title' => 'Polonghera', 'location' => '44.8035,7.5969'));
Item::create(array('title' => 'Pontechianale', 'location' => '44.647,6.9989'));
Item::create(array('title' => 'Pradleves', 'location' => '44.4188,7.2814'));
Item::create(array('title' => 'Prazzo', 'location' => '44.4832,7.056'));
Item::create(array('title' => 'Priero', 'location' => '44.3754,8.0958'));
Item::create(array('title' => 'Priocca', 'location' => '44.7874,8.0653'));
Item::create(array('title' => 'Priola', 'location' => '44.2447,8.0224'));
Item::create(array('title' => 'Prunetto', 'location' => '44.4912,8.1449'));
Item::create(array('title' => 'Racconigi', 'location' => '44.7711,7.6841'));
Item::create(array('title' => 'Revello', 'location' => '44.6556,7.3927'));
Item::create(array('title' => 'Rifreddo', 'location' => '40.5738,15.8267'));
Item::create(array('title' => 'Rittana', 'location' => '44.3512,7.3985'));
Item::create(array('title' => 'Roaschia', 'location' => '44.2702,7.4543'));
Item::create(array('title' => 'Roascio', 'location' => '44.4153,8.0295'));
Item::create(array('title' => 'Robilante', 'location' => '44.2945,7.5113'));
Item::create(array('title' => 'Roburent', 'location' => '44.3078,7.8923'));
Item::create(array('title' => 'Roccabruna', 'location' => '44.4806,7.3363'));
Item::create(array('title' => '"Rocca Cigliè"', 'location' => '44.4467,7.9508'));
Item::create(array('title' => '"Rocca de Baldi"', 'location' => '44.4243,7.7619'));
Item::create(array('title' => '"Roccaforte Mondovì"', 'location' => '44.3189,7.746'));
Item::create(array('title' => 'Roccasparvera', 'location' => '44.3414,7.4414'));
Item::create(array('title' => 'Roccavione', 'location' => '44.3156,7.4836'));
Item::create(array('title' => '"Rocchetta Belbo"', 'location' => '44.637,8.1764'));
Item::create(array('title' => 'Roddi', 'location' => '44.6806,7.9766'));
Item::create(array('title' => 'Roddino', 'location' => '44.5739,8.0191'));
Item::create(array('title' => 'Rodello', 'location' => '44.6295,8.058'));
Item::create(array('title' => 'Rossana', 'location' => '44.5441,7.4324'));
Item::create(array('title' => 'Ruffia', 'location' => '44.7077,7.6052'));
Item::create(array('title' => '"Sale delle Langhe"', 'location' => '44.3962,8.0813'));
Item::create(array('title' => '"Sale San Giovanni"', 'location' => '44.4002,8.0791'));
Item::create(array('title' => 'Saliceto', 'location' => '44.4144,8.1699'));
Item::create(array('title' => 'Salmour', 'location' => '44.5786,7.7932'));
Item::create(array('title' => 'Saluzzo', 'location' => '44.6446,7.4926'));
Item::create(array('title' => 'Sambuco', 'location' => '44.3371,7.079'));
Item::create(array('title' => 'Sampeyre', 'location' => '44.5793,7.1878'));
Item::create(array('title' => '"San Benedetto Belbo"', 'location' => '44.4913,8.0589'));
Item::create(array('title' => '"San Damiano Macra"', 'location' => '44.4889,7.2576'));
Item::create(array('title' => 'Sanfrè', 'location' => '44.7509,7.8038'));
Item::create(array('title' => 'Sanfront', 'location' => '44.6481,7.3222'));
Item::create(array('title' => '"San Michele Mondovì"', 'location' => '44.3781,7.9122'));
Item::create(array('title' => '"Sant Albano Stura"', 'location' => '44.51,7.7234'));
Item::create(array('title' => '"Santa Vittoria dAlba"', 'location' => '44.6997,7.9384'));
Item::create(array('title' => '"Santo Stefano Belbo"', 'location' => '44.7085,8.2302'));
Item::create(array('title' => '"Santo Stefano Roero"', 'location' => '44.7891,7.9408'));
Item::create(array('title' => 'Savigliano', 'location' => '44.648,7.6584'));
Item::create(array('title' => 'Scagnello', 'location' => '44.3342,7.9847'));
Item::create(array('title' => 'Scarnafigi', 'location' => '44.6799,7.567'));
Item::create(array('title' => '"Serralunga d Alba"', 'location' => '44.6111,8.0006'));
Item::create(array('title' => '"Serravalle Langhe"', 'location' => '44.5601,8.0584'));
Item::create(array('title' => 'Sinio', 'location' => '44.6012,8.0218'));
Item::create(array('title' => 'Somano', 'location' => '44.5364,8.0089'));
Item::create(array('title' => '"Sommariva del Bosco"', 'location' => '44.7699,7.7864'));
Item::create(array('title' => '"Sommariva Perno"', 'location' => '44.7467,7.9017'));
Item::create(array('title' => 'Stroppo', 'location' => '44.5058,7.1267'));
Item::create(array('title' => 'Tarantasca', 'location' => '44.4945,7.5447'));
Item::create(array('title' => '"Torre Bormida"', 'location' => '44.5631,8.1569'));
Item::create(array('title' => '"Torre Mondovì"', 'location' => '44.3539,7.9008'));
Item::create(array('title' => '"Torre San Giorgio"', 'location' => '44.7367,7.5292'));
Item::create(array('title' => 'Torresina', 'location' => '44.4347,8.0378'));
Item::create(array('title' => 'Treiso', 'location' => '44.6894,8.0869'));
Item::create(array('title' => '"Trezzo Tinella"', 'location' => '44.6779,8.1076'));
Item::create(array('title' => 'Trinità', 'location' => '40.3731,15.6102'));
Item::create(array('title' => 'Valdieri', 'location' => '44.2788,7.3988'));
Item::create(array('title' => 'Valgrana', 'location' => '44.4124,7.3813'));
Item::create(array('title' => 'Valloriate', 'location' => '44.338,7.3721'));
Item::create(array('title' => 'Valmala', 'location' => '44.5441,7.3464'));
Item::create(array('title' => 'Venasca', 'location' => '44.565,7.405'));
Item::create(array('title' => 'Verduno', 'location' => '44.6672,7.9319'));
Item::create(array('title' => 'Vernante', 'location' => '44.245,7.5345'));
Item::create(array('title' => 'Verzuolo', 'location' => '44.6012,7.4831'));
Item::create(array('title' => '"Vezza dAlba"', 'location' => '44.7638,8.0091'));
Item::create(array('title' => 'Vicoforte', 'location' => '44.3629,7.8636'));
Item::create(array('title' => 'Vignolo', 'location' => '44.3633,7.4739'));
Item::create(array('title' => 'Villafalletto', 'location' => '44.5449,7.5413'));
Item::create(array('title' => '"Villanova Mondovì"', 'location' => '44.348,7.7675'));
Item::create(array('title' => '"Villanova Solaro"', 'location' => '44.7309,7.5756'));
Item::create(array('title' => '"Villar San Costanzo"', 'location' => '44.4841,7.3811'));
Item::create(array('title' => 'Vinadio', 'location' => '44.3066,7.1737'));
Item::create(array('title' => 'Viola', 'location' => '44.2912,7.9652'));
Item::create(array('title' => 'Vottignasco', 'location' => '44.5652,7.5803'));
Item::create(array('title' => '"Agliano Terme"', 'location' => '44.7915,8.2497'));
Item::create(array('title' => 'Albugnano', 'location' => '45.078,7.9712'));
Item::create(array('title' => 'Antignano', 'location' => '44.8452,8.1355'));
Item::create(array('title' => 'Aramengo', 'location' => '45.1001,8.0011'));
Item::create(array('title' => 'Asti', 'location' => '44.9009,8.2068'));
Item::create(array('title' => '"Azzano d Asti"', 'location' => '44.8754,8.2679'));
Item::create(array('title' => '"Baldichieri d Asti"', 'location' => '44.9054,8.0908'));
Item::create(array('title' => 'Belveglio', 'location' => '44.8309,8.3296'));
Item::create(array('title' => '"Berzano di San Pietro"', 'location' => '45.0952,7.9531'));
Item::create(array('title' => 'Bruno', 'location' => '44.7939,8.441'));
Item::create(array('title' => 'Bubbio', 'location' => '44.6642,8.295'));
Item::create(array('title' => '"Buttigliera d Asti"', 'location' => '45.0223,7.9507'));
Item::create(array('title' => 'Calamandrana', 'location' => '44.7381,8.3399'));
Item::create(array('title' => 'Calliano', 'location' => '45.0094,8.2558'));
Item::create(array('title' => 'Calosso', 'location' => '44.7393,8.2281'));
Item::create(array('title' => '"Camerano Casasco"', 'location' => '44.9925,8.0909'));
Item::create(array('title' => 'Canelli', 'location' => '44.7193,8.287'));
Item::create(array('title' => 'Cantarana', 'location' => '45.1994,12.0987'));
Item::create(array('title' => 'Capriglio', 'location' => '44.4778,10.2041'));
Item::create(array('title' => 'Casorzo', 'location' => '45.0234,8.3381'));
Item::create(array('title' => 'Cassinasco', 'location' => '44.6895,8.3018'));
Item::create(array('title' => '"Castagnole delle Lanze"', 'location' => '44.7522,8.1514'));
Item::create(array('title' => '"Castagnole Monferrato"', 'location' => '44.96,8.3048'));
Item::create(array('title' => '"Castel Boglione"', 'location' => '44.723,8.3811'));
Item::create(array('title' => 'Castell Alfero', 'location' => '44.9824,8.2102'));
Item::create(array('title' => 'Castellero', 'location' => '44.9257,8.0743'));
Item::create(array('title' => '"Castelletto Molina"', 'location' => '44.751,8.4325'));
Item::create(array('title' => '"Castello di Annone"', 'location' => '44.8792,8.3138'));
Item::create(array('title' => '"Castelnuovo Belbo"', 'location' => '44.8006,8.4116'));
Item::create(array('title' => '"Castelnuovo Calcea"', 'location' => '44.7892,8.2851'));
Item::create(array('title' => '"Castelnuovo Don Bosco"', 'location' => '45.041,7.9643'));
Item::create(array('title' => '"Castel Rocchero"', 'location' => '44.7196,8.4149'));
Item::create(array('title' => 'Cellarengo', 'location' => '44.8651,7.9451'));
Item::create(array('title' => '"Celle Enomondo"', 'location' => '44.8578,8.1249'));
Item::create(array('title' => '"Cerreto d Asti"', 'location' => '45.0496,8.0367'));
Item::create(array('title' => '"Cerro Tanaro"', 'location' => '44.8739,8.3597'));
Item::create(array('title' => 'Cessole', 'location' => '44.6501,8.2454'));
Item::create(array('title' => '"Chiusano d Asti"', 'location' => '44.985,8.1181'));
Item::create(array('title' => 'Cinaglio', 'location' => '44.9762,8.1013'));
Item::create(array('title' => '"Cisterna d Asti"', 'location' => '44.8251,8.0038'));
Item::create(array('title' => 'Coazzolo', 'location' => '44.7283,8.1455'));
Item::create(array('title' => 'Cocconato', 'location' => '45.0886,8.0395'));
Item::create(array('title' => 'Corsione', 'location' => '45.003,8.146'));
Item::create(array('title' => 'Cortandone', 'location' => '44.96,8.0574'));
Item::create(array('title' => 'Cortanze', 'location' => '45.0153,8.0892'));
Item::create(array('title' => 'Cortazzone', 'location' => '44.9798,8.0618'));
Item::create(array('title' => 'Cortiglione', 'location' => '44.8235,8.3583'));
Item::create(array('title' => 'Cossombrato', 'location' => '44.9927,8.1366'));
Item::create(array('title' => '"Costigliole d Asti"', 'location' => '44.785,8.182'));
Item::create(array('title' => 'Cunico', 'location' => '45.0404,8.0969'));
Item::create(array('title' => '"Dusino San Michele"', 'location' => '44.9267,7.9727'));
Item::create(array('title' => 'Ferrere', 'location' => '44.8783,7.9942'));
Item::create(array('title' => 'Fontanile', 'location' => '44.7539,8.4225'));
Item::create(array('title' => 'Frinco', 'location' => '45.0049,8.1719'));
Item::create(array('title' => 'Grana', 'location' => '44.9994,8.3006'));
Item::create(array('title' => '"Grazzano Badoglio"', 'location' => '45.0404,8.312'));
Item::create(array('title' => '"Incisa Scapaccino"', 'location' => '44.8088,8.3751'));
Item::create(array('title' => '"Isola d Asti"', 'location' => '44.8291,8.1778'));
Item::create(array('title' => 'Loazzolo', 'location' => '44.6698,8.2582'));
Item::create(array('title' => 'Maranzana', 'location' => '44.7605,8.4787'));
Item::create(array('title' => 'Maretto', 'location' => '44.9453,8.0348'));
Item::create(array('title' => 'Moasca', 'location' => '44.7631,8.2787'));
Item::create(array('title' => 'Mombaldone', 'location' => '44.5721,8.3366'));
Item::create(array('title' => 'Mombaruzzo', 'location' => '44.7721,8.4484'));
Item::create(array('title' => 'Mombercelli', 'location' => '44.8174,8.2944'));
Item::create(array('title' => 'Monale', 'location' => '44.9353,8.0727'));
Item::create(array('title' => '"Monastero Bormida"', 'location' => '44.6487,8.3258'));
Item::create(array('title' => 'Moncalvo', 'location' => '45.0512,8.2664'));
Item::create(array('title' => '"Moncucco Torinese"', 'location' => '45.0649,7.9331'));
Item::create(array('title' => 'Mongardino', 'location' => '44.8487,8.2178'));
Item::create(array('title' => 'Montabone', 'location' => '44.6988,8.3901'));
Item::create(array('title' => 'Montafia', 'location' => '44.9897,8.0241'));
Item::create(array('title' => '"Montaldo Scarampi"', 'location' => '44.8314,8.2602'));
Item::create(array('title' => '"Montechiaro d Asti"', 'location' => '45.0083,8.1125'));
Item::create(array('title' => '"Montegrosso d Asti"', 'location' => '44.8217,8.2388'));
Item::create(array('title' => 'Montemagno', 'location' => '43.8475,10.94'));
Item::create(array('title' => 'Moransengo', 'location' => '45.1158,8.0246'));
Item::create(array('title' => '"Nizza Monferrato"', 'location' => '44.7748,8.355'));
Item::create(array('title' => '"Olmo Gentile"', 'location' => '44.5862,8.2484'));
Item::create(array('title' => '"Passerano Marmorito"', 'location' => '45.071,8.0213'));
Item::create(array('title' => 'Penango', 'location' => '45.0315,8.2506'));
Item::create(array('title' => 'Piea', 'location' => '45.0232,8.0681'));
Item::create(array('title' => '"Pino d Asti"', 'location' => '45.0575,7.9863'));
Item::create(array('title' => '"Piovà Massaia"', 'location' => '45.0536,8.0492'));
Item::create(array('title' => 'Portacomaro', 'location' => '44.9582,8.2576'));
Item::create(array('title' => 'Quaranti', 'location' => '44.751,8.45'));
Item::create(array('title' => 'Refrancore', 'location' => '44.9365,8.3438'));
Item::create(array('title' => '"Revigliasco d Asti"', 'location' => '44.859,8.1586'));
Item::create(array('title' => 'Roatto', 'location' => '44.9524,8.027'));
Item::create(array('title' => 'Robella', 'location' => '45.1014,8.1028'));
Item::create(array('title' => '"Rocca d Arazzo"', 'location' => '44.8721,8.2848'));
Item::create(array('title' => 'Roccaverano', 'location' => '44.5925,8.272'));
Item::create(array('title' => '"Rocchetta Palafea"', 'location' => '44.7077,8.3437'));
Item::create(array('title' => '"Rocchetta Tanaro"', 'location' => '44.8596,8.3448'));
Item::create(array('title' => '"San Damiano d Asti"', 'location' => '44.8347,8.065'));
Item::create(array('title' => '"San Giorgio Scarampi"', 'location' => '44.6122,8.2419'));
Item::create(array('title' => '"San Martino Alfieri"', 'location' => '44.8182,8.1092'));
Item::create(array('title' => '"San Marzano Oliveto"', 'location' => '44.7543,8.2959'));
Item::create(array('title' => '"San Paolo Solbrito"', 'location' => '44.9517,7.9719'));
Item::create(array('title' => 'Scurzolengo', 'location' => '44.9657,8.2788'));
Item::create(array('title' => 'Serole', 'location' => '44.5546,8.2601'));
Item::create(array('title' => 'Sessame', 'location' => '44.6712,8.3374'));
Item::create(array('title' => 'Settime', 'location' => '44.9632,8.1138'));
Item::create(array('title' => 'Soglio', 'location' => '44.9974,8.0795'));
Item::create(array('title' => 'Tigliole', 'location' => '44.8866,8.0767'));
Item::create(array('title' => 'Tonco', 'location' => '45.0248,8.1909'));
Item::create(array('title' => 'Tonengo', 'location' => '45.1188,8.0019'));
Item::create(array('title' => '"Vaglio Serra"', 'location' => '44.7974,8.34'));
Item::create(array('title' => 'Valfenera', 'location' => '44.903,7.9674'));
Item::create(array('title' => 'Vesime', 'location' => '44.6361,8.2283'));
Item::create(array('title' => 'Viale', 'location' => '45.0011,8.0502'));
Item::create(array('title' => 'Viarigi', 'location' => '44.9813,8.358'));
Item::create(array('title' => '"Vigliano d Asti"', 'location' => '44.835,8.2303'));
Item::create(array('title' => '"Villafranca d Asti"', 'location' => '44.913,8.0328'));
Item::create(array('title' => '"Villanova d Asti"', 'location' => '44.9422,7.9377'));
Item::create(array('title' => '"Villa San Secondo"', 'location' => '45.0049,8.135'));
Item::create(array('title' => 'Vinchio', 'location' => '44.812,8.322'));
Item::create(array('title' => '"Montiglio Monferrato"', 'location' => '45.0662,8.0985'));
Item::create(array('title' => '"Acqui Terme"', 'location' => '44.6755,8.4707'));
Item::create(array('title' => '"Albera Ligure"', 'location' => '44.7032,9.066'));
Item::create(array('title' => 'Alessandria', 'location' => '44.9132,8.617'));
Item::create(array('title' => '"Alfiano Natta"', 'location' => '45.0476,8.2083'));
Item::create(array('title' => '"Alice Bel Colle"', 'location' => '44.727,8.4519'));
Item::create(array('title' => '"Alluvioni Cambiò"', 'location' => '45.0024,8.7963'));
Item::create(array('title' => '"Altavilla Monferrato"', 'location' => '44.9945,8.377'));
Item::create(array('title' => '"Alzano Scrivia"', 'location' => '45.0191,8.8817'));
Item::create(array('title' => '"Arquata Scrivia"', 'location' => '44.688,8.8857'));
Item::create(array('title' => 'Avolasca', 'location' => '44.8037,8.9656'));
Item::create(array('title' => 'Balzola', 'location' => '45.1845,8.4045'));
Item::create(array('title' => 'Basaluzzo', 'location' => '44.7686,8.7023'));
Item::create(array('title' => 'Bassignana', 'location' => '45.0022,8.732'));
Item::create(array('title' => '"Belforte Monferrato"', 'location' => '44.6261,8.6611'));
Item::create(array('title' => 'Bergamasco', 'location' => '44.8283,8.456'));
Item::create(array('title' => '"Berzano di Tortona"', 'location' => '44.8785,8.9523'));
Item::create(array('title' => 'Bistagno', 'location' => '44.6613,8.3714'));
Item::create(array('title' => '"Borghetto di Borbera"', 'location' => '44.7307,8.9438'));
Item::create(array('title' => '"Borgoratto Alessandrino"', 'location' => '44.8374,8.5397'));
Item::create(array('title' => '"Borgo San Martino"', 'location' => '45.0887,8.5238'));
Item::create(array('title' => '"Bosco Marengo"', 'location' => '44.8245,8.6776'));
Item::create(array('title' => 'Bosio', 'location' => '44.6508,8.7939'));
Item::create(array('title' => 'Bozzole', 'location' => '45.071,8.6071'));
Item::create(array('title' => 'Brignano-Frascata', 'location' => '44.8139,9.041'));
Item::create(array('title' => '"Cabella Ligure"', 'location' => '44.6749,9.0969'));
Item::create(array('title' => '"Camagna Monferrato"', 'location' => '45.0188,8.431'));
Item::create(array('title' => 'Camino', 'location' => '41.3848,13.9337'));
Item::create(array('title' => '"Cantalupo Ligure"', 'location' => '44.7192,9.0461'));
Item::create(array('title' => '"Capriata d Orba"', 'location' => '44.7288,8.6895'));
Item::create(array('title' => '"Carbonara Scrivia"', 'location' => '44.8502,8.871'));
Item::create(array('title' => 'Carentino', 'location' => '44.8281,8.4701'));
Item::create(array('title' => 'Carezzano', 'location' => '44.8082,8.9013'));
Item::create(array('title' => 'Carpeneto', 'location' => '45.9964,13.1775'));
Item::create(array('title' => '"Carrega Ligure"', 'location' => '44.6192,9.1758'));
Item::create(array('title' => 'Carrosio', 'location' => '44.6592,8.8327'));
Item::create(array('title' => 'Cartosio', 'location' => '44.5912,8.4217'));
Item::create(array('title' => '"Casal Cermelli"', 'location' => '44.8352,8.6256'));
Item::create(array('title' => '"Casaleggio Boiro"', 'location' => '44.6345,8.7316'));
Item::create(array('title' => '"Casale Monferrato"', 'location' => '45.1372,8.4509'));
Item::create(array('title' => 'Casalnoceto', 'location' => '44.9141,8.9833'));
Item::create(array('title' => 'Casasco', 'location' => '44.8289,9.006'));
Item::create(array('title' => '"Cassano Spinola"', 'location' => '44.7634,8.8615'));
Item::create(array('title' => 'Cassine', 'location' => '44.7509,8.5289'));
Item::create(array('title' => 'Cassinelle', 'location' => '44.6025,8.5645'));
Item::create(array('title' => 'Castellania', 'location' => '44.7984,8.9298'));
Item::create(array('title' => '"Castellar Guidobono"', 'location' => '44.906,8.9471'));
Item::create(array('title' => '"Castellazzo Bormida"', 'location' => '44.8461,8.5785'));
Item::create(array('title' => '"Castelletto d Erro"', 'location' => '44.6274,8.3949'));
Item::create(array('title' => '"Castelletto d Orba"', 'location' => '44.6856,8.7045'));
Item::create(array('title' => '"Castelletto Merli"', 'location' => '45.0748,8.2413'));
Item::create(array('title' => '"Castelletto Monferrato"', 'location' => '44.9822,8.5656'));
Item::create(array('title' => '"Castelnuovo Bormida"', 'location' => '44.7437,8.5467'));
Item::create(array('title' => '"Castelnuovo Scrivia"', 'location' => '44.9814,8.8824'));
Item::create(array('title' => 'Castelspina', 'location' => '44.8072,8.5842'));
Item::create(array('title' => 'Cavatore', 'location' => '44.6312,8.4523'));
Item::create(array('title' => '"Cella Monte"', 'location' => '45.075,8.3927'));
Item::create(array('title' => 'Cereseto', 'location' => '44.5758,9.678'));
Item::create(array('title' => '"Cerreto Grue"', 'location' => '44.8436,8.9314'));
Item::create(array('title' => '"Cerrina Monferrato"', 'location' => '45.1204,8.2156'));
Item::create(array('title' => 'Coniolo', 'location' => '45.383,9.9749'));
Item::create(array('title' => 'Conzano', 'location' => '45.0213,8.4543'));
Item::create(array('title' => '"Costa Vescovato"', 'location' => '44.8171,8.9273'));
Item::create(array('title' => 'Cremolino', 'location' => '44.637,8.5864'));
Item::create(array('title' => '"Cuccaro Monferrato"', 'location' => '44.9932,8.4569'));
Item::create(array('title' => 'Denice', 'location' => '44.5996,8.3333'));
Item::create(array('title' => 'Dernice', 'location' => '44.7675,9.0514'));
Item::create(array('title' => '"Fabbrica Curone"', 'location' => '44.7849,9.1476'));
Item::create(array('title' => 'Felizzano', 'location' => '44.9003,8.4371'));
Item::create(array('title' => 'Fraconalto', 'location' => '44.5919,8.8779'));
Item::create(array('title' => '"Francavilla Bisio"', 'location' => '44.7356,8.7324'));
Item::create(array('title' => 'Frascaro', 'location' => '44.8275,8.5335'));
Item::create(array('title' => '"Frassinello Monferrato"', 'location' => '45.033,8.3869'));
Item::create(array('title' => '"Frassineto Po"', 'location' => '45.1347,8.5355'));
Item::create(array('title' => 'Fresonara', 'location' => '44.7839,8.6874'));
Item::create(array('title' => 'Frugarolo', 'location' => '44.8381,8.6827'));
Item::create(array('title' => 'Fubine', 'location' => '44.9658,8.4269'));
Item::create(array('title' => 'Gabiano', 'location' => '45.1578,8.1964'));
Item::create(array('title' => 'Gamalero', 'location' => '44.8098,8.5418'));
Item::create(array('title' => 'Garbagna', 'location' => '44.7814,8.9989'));
Item::create(array('title' => 'Gavazzana', 'location' => '44.7767,8.8857'));
Item::create(array('title' => 'Gavi', 'location' => '44.6887,8.8029'));
Item::create(array('title' => 'Giarole', 'location' => '45.0616,8.5677'));
Item::create(array('title' => 'Gremiasco', 'location' => '44.7969,9.1059'));
Item::create(array('title' => 'Grognardo', 'location' => '44.6314,8.4935'));
Item::create(array('title' => 'Grondona', 'location' => '44.6972,8.966'));
Item::create(array('title' => 'Guazzora', 'location' => '45.0147,8.8525'));
Item::create(array('title' => '"Isola SantAntonio"', 'location' => '45.0307,8.8502'));
Item::create(array('title' => 'Lerma', 'location' => '44.6365,8.7153'));
Item::create(array('title' => 'Lu', 'location' => '45.0025,8.4858'));
Item::create(array('title' => 'Malvicino', 'location' => '44.5592,8.4144'));
Item::create(array('title' => 'Masio', 'location' => '44.8706,8.4089'));
Item::create(array('title' => 'Melazzo', 'location' => '44.645,8.4261'));
Item::create(array('title' => 'Merana', 'location' => '44.5188,8.298'));
Item::create(array('title' => '"Mirabello Monferrato"', 'location' => '45.0366,8.5244'));
Item::create(array('title' => 'Molare', 'location' => '44.6197,8.6017'));
Item::create(array('title' => '"Molino dei Torti"', 'location' => '45.0253,8.8949'));
Item::create(array('title' => '"Mombello Monferrato"', 'location' => '45.1339,8.2514'));
Item::create(array('title' => 'Momperone', 'location' => '44.8389,9.0353'));
Item::create(array('title' => 'Moncestino', 'location' => '45.1556,8.1625'));
Item::create(array('title' => '"Mongiardino Ligure"', 'location' => '44.6391,9.0602'));
Item::create(array('title' => 'Monleale', 'location' => '44.8853,8.975'));
Item::create(array('title' => 'Montacuto', 'location' => '44.7667,9.1051'));
Item::create(array('title' => 'Montaldeo', 'location' => '44.6681,8.73'));
Item::create(array('title' => '"Montaldo Bormida"', 'location' => '44.6838,8.5889'));
Item::create(array('title' => 'Montecastello', 'location' => '43.6352,10.6956'));
Item::create(array('title' => '"Montechiaro d Acqui"', 'location' => '44.5955,8.3799'));
Item::create(array('title' => 'Montegioco', 'location' => '44.8419,8.9629'));
Item::create(array('title' => 'Montemarzino', 'location' => '44.8489,8.9926'));
Item::create(array('title' => '"Morano sul Po"', 'location' => '45.1683,8.3674'));
Item::create(array('title' => 'Morbello', 'location' => '44.6066,8.511'));
Item::create(array('title' => 'Mornese', 'location' => '44.6376,8.7565'));
Item::create(array('title' => 'Morsasco', 'location' => '44.6664,8.5521'));
Item::create(array('title' => 'Murisengo', 'location' => '45.0828,8.1361'));
Item::create(array('title' => '"Novi Ligure"', 'location' => '44.7618,8.7861'));
Item::create(array('title' => 'Occimiano', 'location' => '45.0612,8.5088'));
Item::create(array('title' => '"Odalengo Grande"', 'location' => '45.11,8.1681'));
Item::create(array('title' => '"Odalengo Piccolo"', 'location' => '45.072,8.2072'));
Item::create(array('title' => 'Olivola', 'location' => '45.038,8.3681'));
Item::create(array('title' => '"Orsara Bormida"', 'location' => '44.6913,8.5639'));
Item::create(array('title' => 'Ottiglio', 'location' => '45.0525,8.3384'));
Item::create(array('title' => 'Ovada', 'location' => '44.6375,8.6465'));
Item::create(array('title' => 'Oviglio', 'location' => '44.8624,8.4889'));
Item::create(array('title' => '"Ozzano Monferrato"', 'location' => '45.1068,8.3716'));
Item::create(array('title' => 'Paderna', 'location' => '44.8216,8.8924'));
Item::create(array('title' => 'Pareto', 'location' => '44.5175,8.383'));
Item::create(array('title' => '"Parodi Ligure"', 'location' => '44.6707,8.7581'));
Item::create(array('title' => 'Pasturana', 'location' => '44.7519,8.7503'));
Item::create(array('title' => '"Pecetto di Valenza"', 'location' => '44.9908,8.672'));
Item::create(array('title' => '"Pietra Marazzi"', 'location' => '44.9438,8.6697'));
Item::create(array('title' => 'Piovera', 'location' => '44.9596,8.737'));
Item::create(array('title' => '"Pomaro Monferrato"', 'location' => '45.0635,8.5968'));
Item::create(array('title' => 'Pontecurone', 'location' => '44.9613,8.935'));
Item::create(array('title' => 'Pontestura', 'location' => '45.1434,8.3344'));
Item::create(array('title' => 'Ponti', 'location' => '44.6294,8.3653'));
Item::create(array('title' => '"Ponzano Monferrato"', 'location' => '45.0855,8.2632'));
Item::create(array('title' => 'Ponzone', 'location' => '45.6557,8.1896'));
Item::create(array('title' => '"Pozzol Groppo"', 'location' => '44.8776,9.0292'));
Item::create(array('title' => '"Pozzolo Formigaro"', 'location' => '44.7963,8.7859'));
Item::create(array('title' => 'Prasco', 'location' => '44.6397,8.5524'));
Item::create(array('title' => 'Predosa', 'location' => '44.7524,8.6566'));
Item::create(array('title' => 'Quargnento', 'location' => '44.9459,8.4881'));
Item::create(array('title' => 'Quattordio', 'location' => '44.8974,8.4061'));
Item::create(array('title' => 'Ricaldone', 'location' => '44.7335,8.4692'));
}
/**
* Add a podcast to the database
*/
public function add()
{
// create "images" directory under "public" directory if it doesn't exist
if (!File::exists(public_path() . '/images')) {
File::makeDirectory(public_path() . '/images');
}
if (Request::get('feed_url')) {
$feed = Feeds::make(Request::get('feed_url'));
$feed->force_feed(true);
$feed->handle_content_type();
$podcastName = $feed->get_title();
if ($podcastName && $podcastName != '') {
// check if the feed's first item has an audio file in its enclosure
if (strpos($feed->get_items()[0]->get_enclosure()->get_type(), 'audio') !== false) {
$podcastMachineName = strtolower(preg_replace('/\\s+/', '', $podcastName));
// Save the feed thumbnail to file system and save file path to database
$img = Image::make($feed->get_image_url())->resize(100, 100);
$img->save(public_path('images/' . $podcastMachineName . '.png'));
Podcast::create(['name' => $podcastName ? $podcastName : '', 'machine_name' => $podcastMachineName, 'feed_url' => Request::get('feed_url'), 'feed_thumbnail_location' => 'images/' . $podcastMachineName . '.png', 'user_id' => Auth::user()->id, 'web_url' => $feed->get_link()]);
foreach ($feed->get_items() as $item) {
Item::create(['podcast_id' => DB::table('podcasts')->select('id', 'machine_name')->where('machine_name', '=', $podcastMachineName)->first()->id, 'user_id' => Auth::user()->id, 'url' => $item->get_permalink(), 'audio_url' => $item->get_enclosure()->get_link(), 'title' => $item->get_title(), 'description' => strip_tags(str_limit($item->get_description(), 100)), 'published_at' => $item->get_date('Y-m-d H:i:s')]);
}
// @todo Podcast was added
return redirect('podcast/player');
} else {
// @todo flash msg
return 'This doesn\'t seem to be an RSS feed with audio files. Please try another feed.';
}
} else {
// @todo Could not add podcast
return 'Sorry, this feed cannot be imported. Please try another feed';
}
} else {
// @todo use validation
return 'Invalid feed URL given.';
}
}
public function run()
{
DB::table('item')->delete();
$items = array(array('number_in_row' => 1, 'title' => 'Box', 'image' => '/img/design-img/items/small_goods/1.png', 'type' => 1, 'status' => 0), array('number_in_row' => 2, 'title' => 'Small bag', 'image' => '/img/design-img/items/small_goods/2.png', 'type' => 1, 'status' => 0), array('number_in_row' => 3, 'title' => 'Big bag', 'image' => '/img/design-img/items/small_goods/3.png', 'type' => 1, 'status' => 0), array('number_in_row' => 4, 'title' => 'Small book shelf', 'image' => '/img/design-img/items/small_goods/4.png', 'type' => 1, 'status' => 0), array('number_in_row' => 5, 'title' => 'TV Stand', 'image' => '/img/design-img/items/small_goods/5.png', 'type' => 1, 'status' => 0), array('number_in_row' => 6, 'title' => 'Bed', 'image' => '/img/design-img/items/small_goods/6.png', 'type' => 1, 'status' => 0), array('number_in_row' => 7, 'title' => 'Small drawer', 'image' => '/img/design-img/items/small_goods/7.png', 'type' => 1, 'status' => 0), array('number_in_row' => 8, 'title' => 'Chair/s', 'image' => '/img/design-img/items/small_goods/8.png', 'type' => 1, 'status' => 0), array('number_in_row' => 9, 'title' => 'Couch', 'image' => '/img/design-img/items/small_goods/9.png', 'type' => 1, 'status' => 0), array('number_in_row' => 10, 'title' => 'Desk/table', 'image' => '/img/design-img/items/small_goods/10.png', 'type' => 1, 'status' => 0), array('number_in_row' => 11, 'title' => 'Small fridge', 'image' => '/img/design-img/items/small_goods/11.png', 'type' => 1, 'status' => 0), array('number_in_row' => 12, 'title' => 'Smaller than 40 inch TV', 'image' => '/img/design-img/items/small_goods/12.png', 'type' => 1, 'status' => 0), array('number_in_row' => 13, 'title' => 'Computer', 'image' => '/img/design-img/items/small_goods/13.png', 'type' => 1, 'status' => 0), array('number_in_row' => 14, 'title' => 'Microwave', 'image' => '/img/design-img/items/small_goods/14.png', 'type' => 1, 'status' => 0), array('number_in_row' => 15, 'title' => 'Fan', 'image' => '/img/design-img/items/small_goods/15.png', 'type' => 1, 'status' => 0), array('number_in_row' => 16, 'title' => 'Miscellaneous', 'image' => '/img/design-img/items/small_goods/16.png', 'type' => 1, 'status' => 0), array('number_in_row' => 17, 'title' => 'Big book shelf', 'image' => '/img/design-img/items/larger_goods/1.png', 'type' => 2, 'status' => 0), array('number_in_row' => 18, 'title' => 'Big bed', 'image' => '/img/design-img/items/larger_goods/2.png', 'type' => 2, 'status' => 0), array('number_in_row' => 19, 'title' => 'Wardrobe', 'image' => '/img/design-img/items/larger_goods/3.png', 'type' => 2, 'status' => 0), array('number_in_row' => 20, 'title' => 'Big drawer', 'image' => '/img/design-img/items/larger_goods/4.png', 'type' => 2, 'status' => 0), array('number_in_row' => 21, 'title' => 'Big couch', 'image' => '/img/design-img/items/larger_goods/5.png', 'type' => 2, 'status' => 0), array('number_in_row' => 22, 'title' => 'Big desk/table', 'image' => '/img/design-img/items/larger_goods/6.png', 'type' => 2, 'status' => 0), array('number_in_row' => 23, 'title' => 'Big fridge', 'image' => '/img/design-img/items/larger_goods/7.png', 'type' => 2, 'status' => 0), array('number_in_row' => 24, 'title' => '2-Door fidge', 'image' => '/img/design-img/items/larger_goods/8.png', 'type' => 2, 'status' => 0), array('number_in_row' => 25, 'title' => 'Bigger than 40 inch TV', 'image' => '/img/design-img/items/larger_goods/9.png', 'type' => 2, 'status' => 0), array('number_in_row' => 26, 'title' => 'Washing machine', 'image' => '/img/design-img/items/larger_goods/10.png', 'type' => 2, 'status' => 0), array('number_in_row' => 27, 'title' => 'Miscellaneous', 'image' => '/img/design-img/items/larger_goods/11.png', 'type' => 2, 'status' => 0), array('number_in_row' => 28, 'title' => 'Bed', 'image' => '/img/design-img/items/assemble/1.png', 'type' => 3, 'status' => 0), array('number_in_row' => 29, 'title' => 'Wall type AC', 'image' => '/img/design-img/items/assemble/2.png', 'type' => 3, 'status' => 0), array('number_in_row' => 30, 'title' => 'Stand type AC', 'image' => '/img/design-img/items/assemble/3.png', 'type' => 3, 'status' => 0), array('number_in_row' => 31, 'title' => 'Wall type TV', 'image' => '/img/design-img/items/assemble/4.png', 'type' => 3, 'status' => 0), array('number_in_row' => 32, 'title' => 'Furniture', 'image' => '/img/design-img/items/assemble/5.png', 'type' => 3, 'status' => 0));
foreach ($items as $item) {
Item::create($item);
}
}