public function listStoresByCity(Request $request) { $city = $request['city']; if ($request['online-order'] == 1) { return $this->cafe->where('archive', 0)->where('draft', 0)->where('city', $city)->where('online_order', '!=', '')->orderby('store_number', 'asc')->get(); } return $this->cafe->where('archive', 0)->where('draft', 0)->where('city', $city)->orderby('store_number', 'asc')->get(); }
public function archived() { $cafes = $this->cafe->where('archive', 1)->orderby('name', 'asc')->get(); return view('admin.cafe.index', compact('cafes')); }
\App\Cafe::where('state', 'IN')->update(['state' => 'Indiana']); \App\Cafe::where('state', 'SC')->update(['state' => 'South Carolina']); \App\Cafe::where('state', 'AZ')->update(['state' => 'Arizona']); \App\Cafe::where('state', 'CO')->update(['state' => 'Colarado']); \App\Cafe::where('state', 'LA')->update(['state' => 'Louisiana']); \App\Cafe::where('state', 'NV')->update(['state' => 'Nevada']); \App\Cafe::where('state', 'KS')->update(['state' => 'Kansas']); \App\Cafe::where('state', 'NM')->update(['state' => 'New Mexico']); \App\Cafe::where('state', 'AL')->update(['state' => 'Alabama']); \App\Cafe::where('state', 'OK')->update(['state' => 'Oklahoma']); \App\Cafe::where('state', 'WA')->update(['state' => 'Washington']); \App\Cafe::where('state', 'AR')->update(['state' => 'Arkansas']); \App\Cafe::where('state', 'MO')->update(['state' => 'Missouri']); \App\Cafe::where('state', 'MN')->update(['state' => 'Minnesota']); \App\Cafe::where('state', 'ON')->update(['state' => 'Ontario']); \App\Cafe::where('state', 'like', '%GA%')->update(['state' => 'Georgia']); \App\Cafe::whereNull('country')->update(['country' => 'United States of America']); return 'done'; }); //SANDBOX Route::get('view-mailer', function () { return view('emails.contact'); }); //Snippets Route::get('snippet/menu-items', 'SnippetController@outputMenuItems'); Route::get('snippet/clean-store-image-urls', 'SnippetController@cleanImageUrl'); Route::get('snippet/fill-cafe-services', 'SnippetController@fillServiceColumns'); //301s Route::get('library/pdf/NutritionFactsGrid.pdf', function () { return redirect('uploads/documents/Nestle-Tollhouse-Cafe-by-Chip-Nutrition-Facts.pdf'); });