$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();
});
});
