fadlyshafa

Untitled

Dec 6th, 2019
273
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.95 KB | None | 0 0
  1. public function yajra(Request $request)
  2.     {
  3.         DB::statement(DB::raw('set @rownum=0'));
  4.         $users = M_keluhan::select([
  5.             DB::raw('@rownum  := @rownum  + 1 AS rownum'),
  6.             'id',
  7.             'nama',
  8.             'created_at',
  9.             'updated_at']);
  10.         $datatables = Datatables::of($users)->addColumn('details_url', function($e) {
  11.             return url('master/keluhan-tarif/yajra/' . $e->id);
  12.             // return $e->pendaftarans->users->name;
  13.         })->addColumn('action',function($e){
  14.             $url = url('master/keluhan-tarif/add/'.$e->id);
  15.  
  16.             $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>';
  17.  
  18.             return $dt;
  19.         });
  20.  
  21.         if ($keyword = $request->get('search')['value']) {
  22.             $datatables->filterColumn('rownum', 'whereRaw', '@rownum  + 1 like ?', ["%{$keyword}%"]);
  23.         }
  24.  
  25.         return $datatables->make(true);
  26.     }
Advertisement
Add Comment
Please, Sign In to add comment