Guriddo » Topic: How to Paginate please

How to Paginate please

Guriddo
How to Paginate please

This topic has 5 replies, 3 voices, and was last updated 11 years, 7 months ago by tony.

Creator

Topic

September 3, 2014 at 1:52 pm #81783

Participant

How can I get my data grid to paginate and show data please?Â Â My laravel controller sends back the following for pagination and below is my jqgrid config.Â I have tried prmNames but I must be doing something wrong.Â When I don’t use pagination and just send back data, it jqgrid displays the data but when I send pagination and data I get no data displayed and no pagination.Â Thanks for any help.

{ Â "total": 91, Â "per_page": 10, Â "current_page": 1, Â "last_page": 10, Â "from": 1, Â "to": 10, Â "data": [ Â Â Â { Â Â Â Â Â "id": "ALFKI", Â Â Â Â Â "CompanyName": "Alfreds Futterkiste", Â Â Â Â Â "ContactName": "Maria Anders" Â Â Â }, Â Â Â { Â Â Â Â Â "id": "ANATR", Â Â Â Â Â "CompanyName": "Ana Trujillo Emparedados y helados", Â Â Â Â Â "ContactName": "Ana Trujillo" Â Â Â } Â Â Â } ] jqgrid code......... <div class="container"> Â Â Â Â Â Â My Grid Â Â Â Â Â Â Â Â Â Â Â Â <table id="list"><tr><td></td></tr></table> Â Â Â Â Â Â <div id="pager"></div> Â Â Â </div> Â $("#list").jqGrid({ Â Â Â Â Â Â Â Â Â Â Â Â Â url: "customersData", Â Â Â Â Â Â Â Â Â Â Â Â Â datatype: "json", Â Â Â Â Â Â Â Â Â Â Â Â Â mtype: "GET", Â Â Â Â Â Â Â Â Â Â Â Â Â prmNames: {page: "current_page", rows: "per_page"}, Â Â Â Â Â Â Â Â Â Â Â Â Â //prmNames: {page: "pageIndex", sort: "sortCol", order: "sortDir", rows: "pageSize"}, Â Â Â Â Â Â Â Â Â Â Â Â Â colNames:, Â Â Â Â Â Â Â Â Â Â Â Â Â colModel: [ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "id", width: 55 }, Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "CompanyName", width: 55 }, Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "ContactName", width: 55 } Â Â Â Â Â Â Â Â Â Â Â Â Â ], Â Â Â Â Â Â Â Â Â Â Â Â Â pager: "#pager", Â Â Â Â Â Â Â Â Â Â Â Â Â rowNum: 3, Â Â Â Â Â Â Â Â Â Â Â Â Â rowList: [10, 20, 30], Â Â Â Â Â Â Â Â Â Â Â Â Â //width: 600, Â Â Â Â Â Â Â Â Â Â Â Â Â autowidth: true, Â Â Â Â Â Â Â Â Â Â Â Â Â height: "100%", Â Â Â Â Â Â Â Â Â Â Â Â Â sortname: "CompanyName", Â Â Â Â Â Â Â Â Â Â Â Â Â sortorder: "desc", Â Â Â Â Â Â Â Â Â Â Â Â Â viewrecords: true, Â Â Â Â Â Â Â Â Â Â Â Â Â gridview: true, Â Â Â Â Â Â Â Â Â Â Â Â // autoencode: true, Â Â Â Â Â Â Â Â Â Â Â Â Â caption: "My first grid" Â Â Â Â Â Â Â Â Â }); Â Â Â Â Â Â Â Â Â $("#list").jqGrid('navGrid','#pager',{edit:true,add:true,del:true}); 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

{ 
Â "total": 91, 
Â "per_page": 10, 
Â "current_page": 1, 
Â "last_page": 10, 
Â "from": 1, 
Â "to": 10, 
Â "data": [ 
Â Â Â { 
Â Â Â Â Â "id": "ALFKI", 
Â Â Â Â Â "CompanyName": "Alfreds Futterkiste", 
Â Â Â Â Â "ContactName": "Maria Anders" 
Â Â Â }, 
Â Â Â { 
Â Â Â Â Â "id": "ANATR", 
Â Â Â Â Â "CompanyName": "Ana Trujillo Emparedados y helados", 
Â Â Â Â Â "ContactName": "Ana Trujillo" 
Â Â Â } 
Â Â Â } 
] 
 
jqgrid code......... 
 
<div class="container"> 
Â Â Â Â Â Â My Grid 
Â Â Â Â Â Â 
 
Â Â Â Â Â Â <table id="list"><tr><td></td></tr></table> 
Â Â Â Â Â Â <div id="pager"></div> 
 
Â Â Â </div> 
 
Â $("#list").jqGrid({ 
Â Â Â Â Â Â Â Â Â Â Â Â Â url: "customersData", 
Â Â Â Â Â Â Â Â Â Â Â Â Â datatype: "json", 
Â Â Â Â Â Â Â Â Â Â Â Â Â mtype: "GET", 
Â Â Â Â Â Â Â Â Â Â Â Â Â prmNames: {page: "current_page", rows: "per_page"}, 
Â Â Â Â Â Â Â Â Â Â Â Â Â //prmNames: {page: "pageIndex", sort: "sortCol", order: "sortDir", rows: "pageSize"}, 
Â Â Â Â Â Â Â Â Â Â Â Â Â colNames:, 
Â Â Â Â Â Â Â Â Â Â Â Â Â colModel: [ 
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "id", width: 55 }, 
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "CompanyName", width: 55 }, 
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "ContactName", width: 55 } 
Â Â Â Â Â Â Â Â Â Â Â Â Â ], 
Â Â Â Â Â Â Â Â Â Â Â Â Â pager: "#pager", 
Â Â Â Â Â Â Â Â Â Â Â Â Â rowNum: 3, 
Â Â Â Â Â Â Â Â Â Â Â Â Â rowList: [10, 20, 30], 
Â Â Â Â Â Â Â Â Â Â Â Â Â //width: 600, 
Â Â Â Â Â Â Â Â Â Â Â Â Â autowidth: true, 
Â Â Â Â Â Â Â Â Â Â Â Â Â height: "100%", 
Â Â Â Â Â Â Â Â Â Â Â Â Â sortname: "CompanyName", 
Â Â Â Â Â Â Â Â Â Â Â Â Â sortorder: "desc", 
Â Â Â Â Â Â Â Â Â Â Â Â Â viewrecords: true, 
Â Â Â Â Â Â Â Â Â Â Â Â Â gridview: true, 
Â Â Â Â Â Â Â Â Â Â Â Â // autoencode: true, 
Â Â Â Â Â Â Â Â Â Â Â Â Â caption: "My first grid" 
Â Â Â Â Â Â Â Â Â }); 
 
Â Â Â Â Â Â Â Â Â $("#list").jqGrid('navGrid','#pager',{edit:true,add:true,del:true});

Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies

September 5, 2014 at 5:30 pm #102222

wexwell

Participant

Mine works fine and this is what I am sending back (and how I am sending it). I doubt my queries will do much good, I’m using mssql.

$page = $_POST;<br />
$rows = $_POST;<br />
<br />
$data=$rowcnt;<br />
$data=$page;<br />
$data=$rowcnt/$rows;<br />
$data=$result; //this is the data set from the query<br />
echo json_encode($data);

$page = $_POST;

$rows = $_POST;

$data=$rowcnt;

$data=$page;

$data=$rowcnt/$rows;

$data=$result; //this is the data set from the query

echo json_encode($data);

September 9, 2014 at 1:45 pm #102247

coachz

Participant

I’m sorry but that didn’t help me solve my problem.Â I have pasted what the server is returning to the grid and what my grid config is.Â Why do I not get any pagination or data showing up please ?

September 9, 2014 at 4:46 pm #102248

wexwell

Participant

This is what you are returning with your code;

"total": 91,<br />
Â  "per_page": 10,<br />
Â  "current_page": 1,<br />
Â  "last_page": 10,<br />
Â  "from": 1,<br />
Â  "to": 10,<br />
Â  "data": [

"total": 91,

Â "per_page": 10,

Â "current_page": 1,

Â "last_page": 10,

Â "from": 1,

Â "to": 10,

Â "data": [

If you would have actually compared to what I was sending you would have noticed your parameters are not set correctly for pagination to work.Â One example – total is the total number of pages (the way I set it), you are setting it to the total number of records. The parameter I am setting (note – I didn’t simply name my own I set them according to the documentation) for the current page is simply ‘page’, you are using current_page. If you analyze and adapt what I posted, or read the documentation on naming conventions, you should have no problem getting it to work.

September 12, 2014 at 10:12 pm #102253

coachz

Participant

I had to write the entire paginator…….

Â Â Â // coming in from jqGrid
Â Â Â Â Â Â Log::info(Input::all());
Â Â Â Â Â Â Â Â Â // array (
Â Â Â Â Â Â Â Â Â //Â Â ‘_search’ => ‘false’,Â Â Â Â Â Â Â Â Â // search enabled
Â Â Â Â Â Â Â Â Â //Â Â ‘nd’ => ‘1410449702065’,
Â Â Â Â Â Â Â Â Â //Â Â ‘per_page’ => ’10’,
Â Â Â Â Â Â Â Â Â //Â Â ‘current_page’ => ‘1’,
Â Â Â Â Â Â Â Â Â //Â Â ‘sidx’ => ‘CompanyName’,
Â Â Â Â Â Â Â Â Â //Â Â ‘sord’ => ‘desc’,
Â Â Â Â Â Â Â Â Â // )

Â Â Â Â Â Â $page = Input::get(“page”, 1);Â Â Â // get the requested page
Â Â Â Â Â Â $limit = Input::get(“rows”); // get how many rows we want to have into the grid
Â Â Â Â Â Â $sidx = Input::get(“sidx”, 1); // get index row – i.e. user click to sort
Â Â Â Â Â Â $sord = Input::get(“sord”, “asc”); // get the direction
Â Â Â Â Â Â Â Â if (!$limit) $limit = 25;

Â Â Â Â Â Â $count = DB::table(‘customers’)->count();
Â Â Â Â Â Â
Â Â Â Â Â Â // calculate the total pages for the query
Â Â Â Â Â Â if( $count > 0 && $limit > 0) {
Â Â Â Â Â Â Â Â Â Â $count = ceil($count/$limit);
Â Â Â Â Â Â } else {
Â Â Â Â Â Â Â Â Â Â $count = 0;
Â Â Â Â Â Â }
Â Â Â Â Â Â
Â Â Â Â Â Â // if for some reasons the requested page is greater than the total
Â Â Â Â Â Â Â // set the requested page to total page
Â Â Â Â Â Â if ($page > $count) $page=$count;

Â Â Â Â Â Â // calculate the starting position of the rows
Â Â Â Â Â Â Â Â $start = $limit * $page – $limit; // do not put $limit*($page – 1)

Â Â Â Â Â Â // if for some reasons start position is negative set it to 0
Â Â Â Â Â Â Â Â // typical case is that the user type 0 for the requested page
Â Â Â Â Â Â Â Â if($start <0) $start = 0;

Â Â Â Â Â Â Â Â Log::info($sidx . “|” . $sord . “|” . $limit . “|” . $start);

Â Â Â Â Â Â $results = DB::table(‘customers’)->orderBy($sidx, $sord)->take($limit)->skip($start)->get();
Â Â Â Â Â Â
Â Â Â Â Â Â Log::info($results);
Â Â Â Â Â Â //$paginationResults = Paginator::make( $rows, $count, $page);
Â Â Â Â Â Â Â Â Â //$items – record set of query result
Â Â Â Â Â Â Â Â Â //$total – number of records into fetch result
Â Â Â Â Â Â Â Â Â //$per_page – number of records per page you want

Â Â Â Â Â Â //$results = Customer::all();
Â Â Â Â Â Â //$arr = [“page” => 1, “records” => 4, ‘total’=> 2, ‘rows’ => $results];
Â Â Â Â Â Â $arr = [“page” => $page, “records” => $limit, ‘total’=> $count, ‘rows’ => $results];
Â Â Â Â Â Â //return Response::json($arr);

Â Â Â Â Â Â return Response::json($arr);

September 13, 2014 at 1:41 pm #102268

How to Paginate please

Search Forum

Recent Replies

Forum Statistics

UserOnline