bantenprov /
sktm
| @@ 44-68 (lines=25) @@ | ||
| 41 | * |
|
| 42 | * @return \Illuminate\Http\Response |
|
| 43 | */ |
|
| 44 | public function index(Request $request) |
|
| 45 | { |
|
| 46 | if (request()->has('sort')) { |
|
| 47 | list($sortCol, $sortDir) = explode('|', request()->sort); |
|
| 48 | ||
| 49 | $query = $this->master_sktm->orderBy($sortCol, $sortDir); |
|
| 50 | } else { |
|
| 51 | $query = $this->master_sktm->orderBy('id', 'asc'); |
|
| 52 | } |
|
| 53 | ||
| 54 | if ($request->exists('filter')) { |
|
| 55 | $query->where(function($q) use($request) { |
|
| 56 | $value = "%{$request->filter}%"; |
|
| 57 | $q->where('nama', 'like', $value) |
|
| 58 | ->orWhere('nilai', 'like', $value); |
|
| 59 | }); |
|
| 60 | } |
|
| 61 | ||
| 62 | $perPage = request()->has('per_page') ? (int) request()->per_page : null; |
|
| 63 | $response = $query->with('user')->paginate($perPage); |
|
| 64 | ||
| 65 | return response()->json($response) |
|
| 66 | ->header('Access-Control-Allow-Origin', '*') |
|
| 67 | ->header('Access-Control-Allow-Methods', 'GET'); |
|
| 68 | } |
|
| 69 | ||
| 70 | /** |
|
| 71 | * Show the form for creating a new resource. |
|
| @@ 47-79 (lines=33) @@ | ||
| 44 | * |
|
| 45 | * @return \Illuminate\Http\Response |
|
| 46 | */ |
|
| 47 | public function index(Request $request) |
|
| 48 | { |
|
| 49 | if (request()->has('sort')) { |
|
| 50 | list($sortCol, $sortDir) = explode('|', request()->sort); |
|
| 51 | ||
| 52 | $query = $this->sktm->orderBy($sortCol, $sortDir); |
|
| 53 | } else { |
|
| 54 | $query = $this->sktm->orderBy('id', 'asc'); |
|
| 55 | } |
|
| 56 | ||
| 57 | if ($request->exists('filter')) { |
|
| 58 | $query->where(function($q) use($request) { |
|
| 59 | $value = "%{$request->filter}%"; |
|
| 60 | $q->where('nomor_un', 'like', $value) |
|
| 61 | ->orWhere('nilai', 'like', $value); |
|
| 62 | }); |
|
| 63 | } |
|
| 64 | ||
| 65 | $perPage = request()->has('per_page') ? (int) request()->per_page : null; |
|
| 66 | $response = $query->with('user')->with('master_sktm')->paginate($perPage); |
|
| 67 | ||
| 68 | /*foreach($response as $master_sktm){ |
|
| 69 | array_set($response->data, 'master_sktm', $master_sktm->master_sktm->nama); |
|
| 70 | } |
|
| 71 | ||
| 72 | foreach($response as $user){ |
|
| 73 | array_set($response->data, 'user', $user->user->name); |
|
| 74 | }*/ |
|
| 75 | ||
| 76 | return response()->json($response) |
|
| 77 | ->header('Access-Control-Allow-Origin', '*') |
|
| 78 | ->header('Access-Control-Allow-Methods', 'GET'); |
|
| 79 | } |
|
| 80 | ||
| 81 | /** |
|
| 82 | * Show the form for creating a new resource. |
|
