fadlyshafa

Untitled

Dec 6th, 2019
266
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.73 KB | None | 0 0
  1. public function yajra_details(Request $request,$id)
  2.     {
  3.         DB::statement(DB::raw('set @rownum=0'));
  4.         $users = M_keluhan_tarif::where('keluhan',$id)->select([
  5.             DB::raw('@rownum  := @rownum  + 1 AS rownum'),
  6.             'harga',
  7.             'nama',
  8.             'created_at',
  9.             'updated_at']);
  10.         $datatables = Datatables::of($users)->editColumn('harga',function($e){
  11.             $dt = $e->harga;
  12.             $dt = number_format($dt,0);
  13.             $dt = 'Rp. '.$dt;
  14.             return $dt;
  15.         });
  16.  
  17.         if ($keyword = $request->get('search')['value']) {
  18.             $datatables->filterColumn('rownum', 'whereRaw', '@rownum  + 1 like ?', ["%{$keyword}%"]);
  19.         }
  20.  
  21.         return $datatables->make(true);
  22.     }
Advertisement
Add Comment
Please, Sign In to add comment