Treegrid分页的分页其实就是tree的顶级节点分页,下面的子节点其实是不分页的...
js
02 | url: 'treegrid-data.php' , |
09 | onLoadSuccess: function () { |
10 | delete $( this ).treegrid( 'options' ).queryParams[ 'id' ]; |
后台处理:
02 | $parentid = isset( $_POST [ 'id' ]) ? $_POST [ 'id' ] : 0; |
03 | $page = $_POST [ 'page' ]; |
04 | $rows = $_POST [ 'rows' ]; |
05 | $start = ( intval ( $page )-1)* intval ( $rows ); |
07 | $mysql = new SaeMysql(); |
08 | $sql = "select CASE WHEN (SELECT COUNT(1) FROM area WHERE parentid = a.areaid) > 0 THEN 'closed' ELSE 'open' END 'state' , a.* from area a where parentid=$parentid order by vieworder" ; |
11 | $sql = $sql . " limit $start,$rows" ; |
13 | $data = $mysql ->getData( $sql ); |
17 | $sql = "select COUNT(1) 'count' from area WHERE parentid = 0" ; |
18 | $ct = $mysql ->getVar( $sql ); |
23 | echo json_encode( $pdate ); |
25 | echo json_encode( $data ); |