jQuery EasyUI使用教程：添加分页到树网格中

最新推荐文章于 2022-04-25 16:44:35 发布

界面开发小八哥

最新推荐文章于 2022-04-25 16:44:35 发布

阅读量1.1k

点赞数

本教程展示如何在带有动态加载特性的树网格中添加分页。

jQuery EasyUI最新试用版下载请猛戳>>

点击查看示例

创建树网格

想要启动树网格的分页功能，首先必须添加 'pagination:true' 属性，这样页面加载时就会向服务器发送 'page' 和 'rows' 参数。

 
   
        < 
        table 
         title 
        = 
        "Products" 
         class 
        = 
        "easyui-treegrid" 
         style 
        = 
        "width:700px;height:300px" 
         data-options=" 
       
 
        url: 'treegrid4_getdata.php', 
       
 
        rownumbers: true, 
       
 
        pagination: true, 
       
 
        pageSize: 2, 
       
 
        pageList: [2,10,20], 
       
 
        idField: 'id', 
       
 
        treeField: 'name', 
       
 
        onBeforeLoad: function(row,param){ 
       
 
        if (!row) { // load top level rows 
       
 
        param.id 
         =  
        0 
        ; // set  
        id 
        = 
        0 
        , indicate to load new page rows 
       
 
        } 
       
 
        } 
       
 
        "> 
       
 
        < 
        thead 
        > 
       
 
        < 
        tr 
        > 
       
 
        < 
        th 
         field 
        = 
        "name" 
         width 
        = 
        "250" 
        >Name</ 
        th 
        > 
       
 
        < 
        th 
         field 
        = 
        "quantity" 
         width 
        = 
        "100" 
         align 
        = 
        "right" 
        >Quantity</ 
        th 
        > 
       
 
        < 
        th 
         field 
        = 
        "price" 
         width 
        = 
        "150" 
         align 
        = 
        "right" 
         formatter 
        = 
        "formatDollar" 
        >Price</ 
        th 
        > 
       
 
        < 
        th 
         field 
        = 
        "total" 
         width 
        = 
        "150" 
         align 
        = 
        "right" 
         formatter 
        = 
        "formatDollar" 
        >Total</ 
        th 
        > 
       
 
        </ 
        tr 
        > 
       
 
        </ 
        thead 
        > 
       
 
        </ 
        table 
        > 
       
 
 

服务器代码

treegrid4_getdata.php

 
   
        $page 
         = isset( 
        $_POST 
        [ 
        'page' 
        ]) ?  
        intval 
        ( 
        $_POST 
        [ 
        'page' 
        ]) : 1; 
       
 
        $rows 
         = isset( 
        $_POST 
        [ 
        'rows' 
        ]) ?  
        intval 
        ( 
        $_POST 
        [ 
        'rows' 
        ]) : 10; 
       
 
        $offset 
         = ( 
        $page 
        -1)* 
        $rows 
        ; 
       

           
       
 
        $id 
         = isset( 
        $_POST 
        [ 
        'id' 
        ]) ?  
        intval 
        ( 
        $_POST 
        [ 
        'id' 
        ]) : 0; 
       

           
       
 
        include 
         'conn.php' 
        ; 
       

           
       
 
        $result 
         =  
        array 
        (); 
       
 
        if 
         ( 
        $id 
         == 0){ 
       
 
        $rs 
         = mysql_query( 
        "select count(*) from products where parentId=0" 
        ); 
       
 
        $row 
         = mysql_fetch_row( 
        $rs 
        ); 
       
 
        $result 
        [ 
        "total" 
        ] =  
        $row 
        [0]; 
       

           
       
 
        $rs 
         = mysql_query( 
        "select * from products where parentId=0 limit $offset,$rows" 
        ); 
       
 
        $items 
         =  
        array 
        (); 
       
 
        while 
        ( 
        $row 
         = mysql_fetch_array( 
        $rs 
        )){ 
       
 
        $row 
        [ 
        'state' 
        ] = has_child( 
        $row 
        [ 
        'id' 
        ]) ?  
        'closed' 
         :  
        'open' 
        ; 
       
 
        array_push 
        ( 
        $items 
        ,  
        $row 
        ); 
       
 
        } 
       
 
        $result 
        [ 
        "rows" 
        ] =  
        $items 
        ; 
       
 
        }  
        else 
         { 
       
 
        $rs 
         = mysql_query( 
        "select * from products where parentId=$id" 
        ); 
       
 
        while 
        ( 
        $row 
         = mysql_fetch_array( 
        $rs 
        )){ 
       
 
        $row 
        [ 
        'state' 
        ] = has_child( 
        $row 
        [ 
        'id' 
        ]) ?  
        'closed' 
         :  
        'open' 
        ; 
       
 
        $row 
        [ 
        'total' 
        ] =  
        $row 
        [ 
        'price' 
        ]* 
        $row 
        [ 
        'quantity' 
        ]; 
       
 
        array_push 
        ( 
        $result 
        ,  
        $row 
        ); 
       
 
        } 
       
 
        } 
       

           
       
 
        echo 
         json_encode( 
        $result 
        ); 
       

           
       
 
        function 
         has_child( 
        $id 
        ){ 
       
 
        $rs 
         = mysql_query( 
        "select count(*) from products where parentId=$id" 
        ); 
       
 
        $row 
         = mysql_fetch_array( 
        $rs 
        ); 
       
 
        return 
         $row 
        [0] > 0 ? true : false; 
       
 
        } 
       
 
 