/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('facilities')->delete();
Facility::create(['name' => 'Air Conditioning', 'slug' => str_slug('Air Conditioning')]);
Facility::create(['name' => 'Bath Towel', 'slug' => str_slug('Bath Towel')]);
Facility::create(['name' => 'Alarm Radio', 'slug' => str_slug('Alarm Radio')]);
Facility::create(['name' => 'Cable TV', 'slug' => str_slug('Cable TV')]);
Facility::create(['name' => 'Coffee Maker', 'slug' => str_slug('Coffee Maker')]);
Facility::create(['name' => 'Coffee Set', 'slug' => str_slug('Coffee Set')]);
Facility::create(['name' => 'Complimentary Bottled Water', 'slug' => str_slug('Complimentary Bottled Water')]);
Facility::create(['name' => 'Directory of Service', 'slug' => str_slug('Directory of Service')]);
Facility::create(['name' => 'Guest Amenities', 'slug' => str_slug('Guest Amenities')]);
Facility::create(['name' => 'Hair Dryer', 'slug' => str_slug('Hair Dryer')]);
Facility::create(['name' => 'Hand Towel', 'slug' => str_slug('Hand Towel')]);
Facility::create(['name' => 'Hot & Cold Shower', 'slug' => str_slug('Hot & Cold Shower')]);
Facility::create(['name' => 'Iron/Ironing Board', 'slug' => str_slug('Iron/Ironing Board')]);
Facility::create(['name' => 'LED TV', 'slug' => str_slug('LED TV')]);
Facility::create(['name' => 'Mini Bar', 'slug' => str_slug('Mini Bar')]);
Facility::create(['name' => 'Non-Smoking', 'slug' => str_slug('Non-Smoking')]);
Facility::create(['name' => 'Refrigerator', 'slug' => str_slug('Refrigerator')]);
Facility::create(['name' => 'Safe Deposit Box', 'slug' => str_slug('Safe Deposit Box')]);
Facility::create(['name' => 'Shower', 'slug' => str_slug('Shower')]);
Facility::create(['name' => 'Slippers', 'slug' => str_slug('Slippers')]);
Facility::create(['name' => 'Sofa', 'slug' => str_slug('Sofa')]);
Facility::create(['name' => 'Bathtub', 'slug' => str_slug('Bathtub')]);
Facility::create(['name' => 'Bath Robe', 'slug' => str_slug('Bath Robe')]);
Facility::create(['name' => 'Face Towel', 'slug' => str_slug('Face Towel')]);
Facility::create(['name' => 'Kitchen Equipment', 'slug' => str_slug('Kitchen Equipment')]);
Facility::create(['name' => 'Daily Newspaper', 'slug' => str_slug('Daily Newspaper')]);
Facility::create(['name' => 'Ergonomic Desk Chair', 'slug' => str_slug('Ergonomic Desk Chair')]);
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$this->validate($request, ['name' => 'required|unique:facilities,name']);
$input = $request->all();
$input['slug'] = str_slug($input['name']);
Facility::create($input);
return redirect('/facility');
}
/**
* [readFile description]
* @param [type] $file [description]
* @param [type] $connection [description]
* @return [type] [description]
*/
public function readFile($file, $connection)
{
// if($file['extension']=='csv'||$file['extension']=='xls'){
$path = Config::get('flysystem.connections.' . $connection . '.path');
Excel::filter('chunk')->load($path . '/' . $file['path'])->chunk(50, function ($results) {
// return $results;
$results->each(function ($row) {
$facility = Facility::create($row->toArray());
});
});
// return $data;
// }
}
public function store()
{
$input = Request::all();
Facility::create($input);
return redirect('regions');
}
