public function fillServiceColumns()
{
$cafes = $this->cafe->all();
foreach ($cafes as $cafe) {
if (strpos($cafe->legacy_services, 'curbside')) {
$cafe->curbside = 1;
}
if (strpos($cafe->legacy_services, 'icecream')) {
$cafe->icecream = 1;
}
if (strpos($cafe->legacy_services, 'coffee')) {
$cafe->coffee = 1;
}
if (strpos($cafe->legacy_services, 'frozenyogurt')) {
$cafe->frozenyogurt = 1;
}
if (strpos($cafe->legacy_services, 'smoothies')) {
$cafe->smoothies = 1;
}
if (strpos($cafe->legacy_services, 'wifi')) {
$cafe->wifi = 1;
}
if (strpos($cafe->legacy_services, 'cookie')) {
$cafe->cookie = 1;
}
if (strpos($cafe->legacy_services, 'savory')) {
$cafe->savory = 1;
}
if (strpos($cafe->legacy_services, 'bakery')) {
$cafe->bakery = 1;
}
$cafe->save();
}
return "cafes' services cleaned";
}
public function phoneHelper()
{
$cafes = $this->cafe->all();
$array = array();
foreach ($cafes as $cafe) {
if ($cafe->country == "USA" || strlen($cafe->phone) == 10) {
if (strlen($cafe->phone) == 10) {
$origPhone = $cafe->phone;
$phone = preg_replace('/[^+.,0-9]/', '', $origPhone);
$phone = str_replace('+', '', $phone);
$phone = str_replace('.', '', $phone);
$phone = str_replace(',', '', $phone);
if (preg_match('/^(\\d{3})(\\d{3})(\\d{4})$/', $phone, $matches)) {
$result = '(' . $matches[1] . ') ' . $matches[2] . '-' . $matches[3];
$phone = $result;
$cafe->phone = $phone;
}
}
$cafe->save();
}
}
return back()->with('success', 'Phone Numbers Formatted');
}
Route::get('slides/{id}/archive', 'Admin\\SlideController@archive');
Route::get('slides/archives', 'Admin\\SlideController@archived');
Route::resource('slides', 'Admin\\SlideController');
Route::get('cafes/format/phone-numbers', 'Admin\\CafeController@phoneHelper');
Route::get('cafes/{id}/archive', 'Admin\\CafeController@archive');
Route::get('cafes/geolocate', 'Admin\\CafeController@geolocate');
Route::post('cafes/{id}/update-services', ['as' => 'cafe.update-services', 'uses' => 'Admin\\CafeController@updateServices']);
Route::post('cafes/{id}/update-hours', ['as' => 'cafe.update-hours', 'uses' => 'Admin\\CafeController@updateHours']);
Route::get('cafes/archives', 'Admin\\CafeController@archived');
Route::resource('cafes', 'Admin\\CafeController');
Route::get('/', 'Admin\\PagesController@index');
});
});
//DEV FIXES
Route::get('fix-cafes', function () {
$cafes = \App\Cafe::all();
\App\Cafe::where('country', 'like', '%TX%')->update(['country' => 'United States']);
\App\Cafe::where('country', 'like', '%FL%')->update(['country' => 'United States']);
\App\Cafe::where('country', 'like', '%USA%')->update(['country' => 'United States of America']);
\App\Cafe::where('country', 'like', '%Canada%')->update(['country' => 'Canada']);
\App\Cafe::where('country', 'like', '%CANADA%')->update(['country' => 'Canada']);
\App\Cafe::where('country', 'like', '%United States%')->update(['country' => 'United States of America']);
\App\Cafe::where('country', 'like', '')->update(['country' => 'United States of America']);
\App\Cafe::where('state', 'TX')->update(['state' => 'Texas']);
\App\Cafe::where('state', 'CA')->update(['state' => 'California']);
\App\Cafe::where('state', 'FL')->update(['state' => 'Florida']);
\App\Cafe::where('state', 'MI')->update(['state' => 'Michigan']);
\App\Cafe::where('state', 'NY')->update(['state' => 'New York']);
\App\Cafe::where('state', 'IL')->update(['state' => 'Illinois']);
\App\Cafe::where('state', 'AK')->update(['state' => 'Alaska']);
\App\Cafe::where('state', 'MD')->update(['state' => 'Maryland']);
