Custom Filter Datatables using yajrabox package in laravel 5 -


excuse me, have problem when wan't make custom filter in datatables. wan't show data based on selected input. data has not changed expected.

here view code

<div class="panel-body">     <div class="row">         <div class="col-md-10">             {!! form::open(['method'=>'post','class'=>'form-horizontal','role'=>'form','id'=>'filter-form']) !!}             <div class="form-group{{ $errors->has('filter') ? ' has-error' : '' }}">                 {!! form::label('filter', 'filter:', ['class'=>'col-md-1 control-label']) !!}                 <div class="col-md-3">                 {!! form::select('filter', ['all'=>'semua waktu','bulanan'=>'per bulan ini','tahunan'=>'per tahun ini','tanggal'=>'berdasarkan tanggal'], 'all', ['id'=>'filter','class'=>'form-control','placeholder' => 'pilih waktu','onchange'=>'submitform(this)']) !!}                 {!! $errors->first('filter', '<p class="help-block">:message</p>') !!}                 </div>             </div>             {!! form::close() !!}         </div>     </div>     {!! $html->table(['id'=>'datapeserta','class'=>'table-striped']) !!} </div>

and controller

public function index(request $request, builder $htmlbuilder) {     $getfilter = $request->get('filter');     $getdari = $request->get('dari');     $getsampai = $request->get('sampai');     $getmonth = date('m');     $getyear = date('y');     if($getfilter == 'all'){         $datapeserta = peserta::with('jeniskelas');     }elseif($getfilter == 'bulanan'){         $datapeserta = peserta::with('jeniskelas')->whereyear('created_at','=',$getyear)->wheremonth('created_at','=',$getmonth)->get();     }elseif($getfilter == 'tahunan'){         $datapeserta = peserta::with('jeniskelas')->whereyear('created_at','=',$getyear)->get();     }elseif($getfilter == 'tanggal'){         $datajeniskelamin = peserta::with('jeniskelas')->wherebetween('created_at',array($getdari,$getsampai))->get();     }else{         $datapeserta = peserta::with('jeniskelas');     }      if($request->ajax()){         return datatables::of($datapeserta)->addcolumn('action', function($datapeserta){             return view('datatable._actiondatapeserta', [                 'model' => $datapeserta,                 'form_url' => route('datapeserta.destroy', $datapeserta->id),                 'edit_url' => route('datapeserta.edit', $datapeserta->id),                 ]);         })->make(true);     }     $html = $htmlbuilder->addcolumn(['data'=>'nis', 'name'=>'nis', 'title'=>'nis'])     ->addcolumn(['data'=>'nama', 'name'=>'nama', 'title'=>'nama'])     ->addcolumn(['data'=>'nohp', 'name'=>'nohp', 'title'=>'no. hp'])     ->addcolumn(['data'=>'jeniskelas.name', 'name'=>'jeniskelas.name', 'title'=>'jenis kelas'])      return view('datapeserta.index')->with(compact('html','getyear')); }

anyone can solve this?


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more