Advertisement
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 = \DB::table('m_supplier')->select([
- DB::raw('@rownum := @rownum + 1 AS rownum'),
- 'id_supplier',
- 'nama',
- 'email',
- 'website',
- 'no_hp',
- 'kota',
- 'alamat',
- 'created_at']);
- $datatables = Datatables::of($users)->addColumn('active',function($dt){
- $data = '<p><input type="checkbox" class="aktif"></p>';
- return $data;
- })->rawColumns(['active']);
- 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
Advertisement