ecshop 分页小记

ecshop 分页是ajax请求的，必须在主文件里有个 act = query 处理，分页会请求这个act

 

<?php
//获取列表
if($_REQUEST['act']=='list'){
    
    //权限设置
   admin_priv('issued_invite_code');
    
    $res = get_list();
   
    $smarty-> assign('list',$res['list']);
    $smarty-> assign('filter',       $res['filter']);
    $smarty-> assign('record_count', $res['filter']['record_count']);
    $smarty-> assign('page_count',   $res['filter']['page_count']);
    
    assign_query_info();
    $smarty->display('aa.html');
}


//分页ajax查询
if($_REQUEST['act'] == 'query'){
    
    admin_priv('issued_invite_code');
    
    $list = get_list();
     
    $smarty-> assign('list',$res['list']);
    $smarty-> assign('filter',       $res['filter']);
    $smarty-> assign('record_count', $res['filter']['record_count']);
    $smarty-> assign('page_count',   $res['filter']['page_count']);
    
    $smarty->assign('is_ajax' ,true);
    
    assign_query_info();
    make_json_result($smarty->fetch('aa.html'), '',
        array('filter' => $res['filter'], 'page_count' => $res['filter']['page_count']));   
}

function get_list(){
    
    $filter['record_count'] = $GLOBALS['db']->getOne("select count(*) from aa");
    $filter = page_and_size($filter);
    
    $sql = "select * from aa  LIMIT  $filter[start] , $filter[page_size]";
    
    $list = $GLOBALS['db']-> getAll($sql);
    
    return array('list'=>$list,'filter'=>$filter);
}

?>

 

{insert_scripts files="jquery.js,jquery.json.js,../js/transport.js,common.js"}  //引入 必要的js
{insert_scripts files="../js/utils.js,listtable.js"}      //引入 listtable.js

 {if !$is_ajax}     //如果是ajax分页就不显示表头
    <h2 class="go-list">下发记录</h2>
 {/if}
 
<div class="list-div" id="listDiv">
    <table cellpadding="3" cellspacing="1">
      <tr>
        <th>id</th>
        <th>名称</th>
      </tr>
      {if $list}
         {foreach from=$list item=data}
            <tr>
            <td style="background-color: rgb(255, 255, 255);text-align: center;">{$data.id}</td>
            <td style="background-color: rgb(255, 255, 255);text-align: center;">{$data.name}</td>
          </tr>
         {/foreach}
     {else}
         <tr>
            <td>记录为空</td>
         </tr>
     {/if}
    </table>

    <table cellpadding="4" cellspacing="0">
        <tr>
            <td align="right">{include file="page.htm"}</td>      //引入分页模板
        </tr>
    </table>
</div>