Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function yajra_details(Request $request,$id)
- {
- DB::statement(DB::raw('set @rownum=0'));
- $users = M_keluhan_tarif::where('keluhan',$id)->select([
- DB::raw('@rownum := @rownum + 1 AS rownum'),
- 'harga',
- 'nama',
- 'created_at',
- 'updated_at']);
- $datatables = Datatables::of($users)->editColumn('harga',function($e){
- $dt = $e->harga;
- $dt = number_format($dt,0);
- $dt = 'Rp. '.$dt;
- 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