【控制器】
import("ORG.Util.AjaxPage");// 导入分页类 注意导入的是自己写的AjaxPage类
$bill_withdraw = M('bill_withdraw');
$count = $bill_withdraw->where($condition)->count(); //计算记录数
$limitRows = 10; // 设置每页记录数
$p = new \Think\AjaxPage($count, $limitRows,"Withdrawal"); //第三个参数是你需要调用换页的ajax函数名
$limit_value = $p->firstRow . "," . $p->listRows;
$list = $bill_withdraw->where($condition)->field('withdraw_sn,withdraw_time,withdraw_money,withdraw_bank_num,withdraw_bank_name,withdraw_status,withdraw_mark')->order('withdraw_time desc')->limit($limit_value)->select(); // 查询数据
foreach($list as $key=>$value){
$new_list[$key]['withdraw_sn'] = $value['withdraw_sn'];
$new_list[$key]['withdraw_time'] = $value['withdraw_time'];
$new_list[$key]['withdraw_money'] = $value['withdraw_money'];
$new_list[$key]['withdraw_bank_num'] = substr($value['withdraw_bank_num'],-4,4);
$new_list[$key]['withdraw_bank_name'] = $value['withdraw_bank_name'];
$new_list[$key]['withdraw_status'] = $value['withdraw_status'];
$new_list[$key]['withdraw_mark'] = $value['withdraw_mark'];
}
$page = $p->show(); // 产生分页信息，AJAX的连接在此处生成
$this->assign('list',$new_list);
$this->assign('page',$page);【模板】<foreach name="list" item="vo">
<div class="wholeInfoRow" id='Withdrawal'>
<div class="col-sm-2 col-xs-2 longHide">{$vo.withdraw_sn}</div>
<div class="col-sm-3 col-xs-3 longHide"> {:date('Y年m月d日 H:i',$vo['withdraw_time'])}</div>
<div class="col-sm-2 col-xs-2 longHide">{$vo.withdraw_money}</div>
<div class="col-sm-3 col-xs-3 longHide mgTop20">{$vo.withdraw_bank_name}<br/>xxxx xxxx xxxx{$vo.withdraw_bank_num}</div>
<div class="col-sm-2 col-xs-2 longHide">
<if condition="$vo.withdraw_status eq 1">待审核
<elseif condition="$vo.withdraw_status eq 2"/>审核通过
<elseif condition="$vo.withdraw_status eq 3"/>拒绝提现<p style="font-size:10px;">{$vo.withdraw_mark}</p>
<elseif condition="$vo.withdraw_status eq 8"/>提现成功
<elseif condition="$vo.withdraw_status eq 9"/>提现失败
<else/>女
</if>
</div>
</div>
</foreach>
<div style="color:red;background: black;">
{$page}
</div>【js】<section class="wholeSection">
<script type="text/javascript" src="../Public/jquery-1.7.2.min.js"></script>
<script type="text/javascript">
function Withdrawal(id){ //user函数名 一定要和action中的第三个参数一致上面有
var id = id;
$.get('DrawCash/cw_drawRecord', {'p':id}, function(data){ //用get方法发送信息到UserAction中的user方法
$("#Withdrawal").replaceWith("<div id='Withdrawal'>"+data+"</div>"); //user一定要和tpl中的一致
});
}
</script>
qq.png
( 22.63 KB 下载：11 次 )
最佳答案
