Advertisement
fadlyshafa

Untitled

Jul 30th, 2019
317
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.67 KB | None | 0 0
  1. public function yajra(Request $request)
  2.     {
  3.         DB::statement(DB::raw('set @rownum=0'));
  4.         $users = \DB::table('m_supplier')->select([
  5.             DB::raw('@rownum  := @rownum  + 1 AS rownum'),
  6.             'id_supplier',
  7.             'nama',
  8.             'email',
  9.             'website',
  10.             'no_hp',
  11.             'kota',
  12.             'alamat',
  13.             'created_at']);
  14.         $datatables = Datatables::of($users)->addColumn('active',function($dt){
  15.             $data = '<p><input type="checkbox" class="aktif"></p>';
  16.             return $data;
  17.         })->rawColumns(['active']);
  18.  
  19.         if ($keyword = $request->get('search')['value']) {
  20.             $datatables->filterColumn('rownum', 'whereRaw', '@rownum  + 1 like ?', ["%{$keyword}%"]);
  21.         }
  22.  
  23.         return $datatables->make(true);
  24.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement