Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function yajra(Request $request)
- {
- DB::statement(DB::raw('set @rownum=0'));
- $users = M_keluhan::select([
- DB::raw('@rownum := @rownum + 1 AS rownum'),
- 'id',
- 'nama',
- 'created_at',
- 'updated_at']);
- $datatables = Datatables::of($users)->addColumn('details_url', function($e) {
- return url('master/keluhan-tarif/yajra/' . $e->id);
- // return $e->pendaftarans->users->name;
- })->addColumn('action',function($e){
- $url = url('master/keluhan-tarif/add/'.$e->id);
- $dt = '<div style="width:60px"><a href="'.$url.'" class="btn btn-primary btn-xs btn-edit" id="edit"><i class="fa fa-plus"></i> Tambah Tarif</a></div>';
- return $dt;
- });
- if ($keyword = $request->get('search')['value']) {
- $datatables->filterColumn('rownum', 'whereRaw', '@rownum + 1 like ?', ["%{$keyword}%"]);
- }
- return $datatables->make(true);
- }
Advertisement
Add Comment
Please, Sign In to add comment