EasyUI Forum
April 28, 2024, 04:49:12 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: sample code using easyui datagrid pagination in laravel  (Read 3371 times)
shivavalkyre
Newbie
*
Posts: 39


View Profile
« on: September 03, 2020, 09:41:58 PM »

Hi,

is there any sample code how to use easyui datagrid pagination in laravel?

Thanks
Logged
bljcchen
Newbie
*
Posts: 1


View Profile Email
« Reply #1 on: July 21, 2022, 06:57:49 PM »

It works for me.

1. route/api.php
    Route::get('/user', [UserController::class, 'getusers'])->name('getusers;);

2. app\Http\Controllers\UserController.php

    public function getusers(Request $req) {
        $srcData = DB::table('user')->paginate($req->get('rows'));
        return json_encode($srcData);
    }

   note:  $req->get('rows')  is corespond for pageSize of datagrid

3. resources/view/user.blad.php

    <table id="dg2" class="easyui-datagrid"></table>

    <script>
    $(document).ready(function(){

        $('#dg2").datagrid({
            url: "{{route('getusers')}}",
            method: 'get',
            pagination: true,
            pagePosition: 'bottom',
            pageSize: 10,
            pageList: [10, 20, 50],
            loadFilter: function(data){
                return {"total": data.total, "rows": data.data}
            },
            ... other configurations ...
        });

    });
    </script>

    note:  loadFilter function is needed

Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!