/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Location::firstOrCreate(['name' => "1 Yellow Brick Road, Cork City, Cork", 'latitude' => 51.898202, 'longitude' => -8.479321000000001, 'capacity' => "200", 'featured_image' => '/images/sample_images/venues/1.jpg']);
Location::firstOrCreate(['name' => "2 Yellow Brick Road, Cork City, Cork", 'latitude' => 52, 'longitude' => -9.479321000000001, 'capacity' => "200", 'featured_image' => '/images/sample_images/venues/1.jpg']);
Location::firstOrCreate(['name' => "3 Yellow Brick Road, Cork City, Cork", 'latitude' => 51.7, 'longitude' => -8.5, 'capacity' => "200", 'featured_image' => '/images/sample_images/venues/1.jpg']);
Location::firstOrCreate(['name' => "4 Yellow Brick Road, Cork City, Cork", 'latitude' => 51.6, 'longitude' => -8.579321, 'capacity' => "200", 'featured_image' => '/images/sample_images/venues/1.jpg']);
Location::firstOrCreate(['name' => "5 Yellow Brick Road, Cork City, Cork", 'latitude' => 51.998202, 'longitude' => -8.779320999999999, 'capacity' => "200", 'featured_image' => '/images/sample_images/venues/1.jpg']);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$raw = array_map('str_getcsv', file('data.csv'));
$data = array_slice($raw, 1);
foreach ($data as $row) {
$location = Location::firstOrCreate(['county' => $this->county($row[0]), 'city' => $this->city($row[1]), 'state' => $this->state($row[0])]);
$product = Product::create(['name' => $row[2], 'freight' => $this->float($row[4]), 'margin' => $this->float($row[5]), 'delivered_price' => $this->float($row[6]), 'location_id' => $location->id]);
}
$this->info(sprintf("Imported %d locations and %d products\r", Location::count(), Product::count()));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Location::firstOrCreate(['name' => "The 3 Arena", 'latitude' => 53.347714, 'longitude' => -6.22864783, 'capacity' => 30000]);
Location::firstOrCreate(['name' => "Lansdowne Road", 'latitude' => 53.335105, 'longitude' => -6.228423, 'capacity' => 400000]);
Location::firstOrCreate(['name' => "Musgrave Park", 'latitude' => 51.881045, 'longitude' => -8.470948, 'capacity' => 12000]);
}
public static function createLocation(Request $request)
{
$data = $request->only(['name', 'latitude', 'longitude', 'capacity', 'featured_image']);
$validator = Validator::make($data, ['name' => 'required', 'latitude' => 'required', 'longitude' => 'required', 'capacity' => 'required|numeric', 'featured_image' => 'image|sometimes']);
if ($validator->fails()) {
// If validation fails, return json array of errors
return Response::json(['errors' => $validator->errors()->all()]);
}
$location = Location::firstOrCreate($data);
return Response::json($location->toArray());
}
