Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- public function index_data(Request $request ){
- $draw=$request->input('draw');
- $start=$request->input('start');
- $limit=$request->input('length');
- //dd($user_login);
- $clData = new \App\Modelku;
- $param=[
- 'limit'=>$limit,
- 'start'=>$start,
- 'search'=>$request->input('search')['value'],
- 'order'=>$request->input('order')[0]['column'],
- 'order_dir'=>$request->input('order')[0]['dir'],
- 'raw'=>$user[0]
- ];
- $total_filtered= $clData->dataTableUserid($param,TRUE);
- $data= $clData->dataTableUserid($param);
- unset($param['search'] );
- $total= $clData->dataTableUserid($param,TRUE);
- return view('admin.json.data',compact('draw','user_login','data','total','total_filtered','param','sql_query'));
- /*nama view bisa diganti*/
- }
- //==================MODEL================
- <?php
- namespace App;
- use Illuminate\Database\Eloquent\Model;
- use Illuminate\Support\Facades\DB;
- class Modelku extends Model
- {
- public function dataTableUserid($params=array(),$count=FALSE ){
- //default order
- $order_by='id';
- $order_dir='asc';
- $ord=isset($params['order'])?$params['order']:-1;
- $ord_dir=isset($params['order_dir'])?$params['order_dir']:-1;
- //custom.. update sendiri
- if($ord==1){
- $order_by='id';
- }
- if($ord==2){
- $order_by='name';
- }
- if($ord_dir!=-1){
- $order_dir=$ord_dir;
- }
- $data = $this->orderBy($order_by,$order_dir);
- //search bila ada pencarian
- $search=isset($params['search'])?$params['search']:'';
- if($search!=''&&strlen($search)>3){
- $data->Where('name','like', '%'.$search.'%')
- ->orWhere('detail','like', '%'.$search.'%') ;
- }
- //show data or count
- if($count==FALSE){
- $data->skip($params['start'])->take($params['limit']);
- }else{
- return $data->count();
- }
- $show_query=isset($params['show_query'])?$params['show_query']:FALSE;
- if($show_query){
- return $data->toSql();
- }else{
- return $data->get();
- }
- }
- }
- //==================VIEW=================
- <?php //dd($user_login);
- $clData = new \App\Modelku;
- $datatable=[
- 'data'=>[],
- 'draw'=>$draw,
- 'recordsFiltered'=>$total_filtered,
- 'recordsTotal'=>$total
- ];
- $pil = $clData->typeKapal();
- //dd($datatable);
- foreach($data as $row){
- $tmp=[
- /*data apa aja yang kamu keluarkan*/
- 'id'=>$row->id
- ];
- }
- echo json_encode($datatable);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement