$filter_arr = explode(':', $filter); switch ($filter_arr[0]) { case 'province': $province = DB::table('provinces')->where('id', $filter_arr[1])->first(); $data['cities'] = DB::table('cities')->where('description', 'like', '%' . strtolower($province->name) . '%')->get(); break; case 'branches': $data['branches'] = DB::table('users')->select('branch')->where('branch', '!=', 'null')->where('branch', '!=', '')->groupBy('branch')->orderBy('branch', 'asc')->get(); break; } echo json_encode($data); }); Route::get('/update', function () { switch ($_GET['type']) { case 'tag': $data = App\Item::find($_GET['id']); $data->is_sold = 1; $data->save(); break; } echo json_encode($data); }); Route::get('/', function () { $data['items'] = DB::table('items')->where(['is_sold' => 0])->orderBy('ticket_no', 'desc')->paginate(6); //$data['provinces'] = DB::table('provinces')->lists('name', 'id'); $provinces = DB::table('provinces')->orderBy('name', 'asc')->get(); $data['pawnshops'] = DB::table('pawnshops')->lists('name', 'id'); foreach ($provinces as $value) { $res = DB::table('cities')->where('description', 'like', '%' . strtolower($value->name) . '%')->get(); if ($res) { foreach ($res as $val) {
<?php Route::group(['prefix' => 'awesomelist'], function () { get('', function () { return view('home'); }); get('items', function () { return App\Item::all(); }); post('items', function () { $item = App\Item::create(Request::all()); return $item->id; }); put('items/{id}', function ($id) { $item = App\Item::find($id); $item->completed = $item->completed ? false : true; $item->update(); }); delete('items/{id}', function ($id) { $item = App\Item::find($id); $item->delete(); }); });