thinkPHP交易详情查询功能详解
2018-09-20 23:44
本文实例分析了thinkPHP交易详情查询功能。分享给大家供大家参考，具体如下：
交易详情
一般都是按月的，包含，交易日期，交易金额，交易状态（可有可无）
总交易额等等。
如果数据多的话，最好能够分页。
最好能够查询具体的哪一个商户。
1.模拟sql实现查询功能
sql查询出来了，基本上就搞定了，剩下的就是用php，thinkphp实现这个查询功能，加入一些逻辑与条件。
// 商户交易 public function trade(){ if($type = $this->_request(type,trim)){ $s_year = $this->_request(s_year,trim); $s_month = $this->_request(s_month,trim); $s_user_id = $this->_request(s_user_id,trim,intval); $this->assign(s_user_id,$s_user_id); if($type == last){ // 获取上一月 if($s_month==1){ $useYear = $s_year-1; $useMonth = 12; }else{ $useYear = $s_year; $useMonth = $s_month-1; } } if($type == next){ // 获取下一月 if($s_month==12){ $useYear = $s_year+1; $useMonth = 1; }else{ $useYear = $s_year; $useMonth = $s_month+1; } } if ($type == selectuser){ $useYear = $s_year; $useMonth = $s_month; } }else{ // 获取当前年 月 $useYear = date(Y); $useMonth = date(m); } $this->assign(s_year,$useYear); $this->assign(s_month,$useMonth); $b_time = strtotime($useYear.-.$useMonth.-.1); $e_time = strtotime($useYear.-.$useMonth.-.date(t,strtotime($b_time)). 23:59:59); if(isset($s_user_id) && $s_user_id > 0){ $where[a.id] = $s_user_id; } $where[a.opener_id] = $this->opener_id; $where[a.status] = 1; // 合法的用户 $where[c.status] = 1; // 合法的订单 $where[c.paytime] = array(array(gt,$b_time),array(lt,$e_time),and); $count_and_totalprice = M()->table(sh_user a) ->join(sh_store b on a.id = b.user_id) ->join(sh_order c on b.id = c.store_id) ->where($where) ->field(count(b.id) as count ,sum(c.price) as totalprice) ->find(); $count = $count_and_totalprice[count]; $totalprice = $count_and_totalprice[totalprice] ? $count_and_totalprice[totalprice] : 0; $Page = new Page($count, 10); $list = M()->table(sh_user a) ->join(sh_store b on a.id = b.user_id) ->join(sh_order c on b.id = c.store_id) ->where($where) ->order(c.id desc) ->limit($Page->firstRow.,.$Page->listRows) ->field(a.id as user_id,a.username,b.name as store_name,c.id as order_id,c.price,c.paytime,c.sendtime,c.receivetime) ->select(); foreach ($list as $k => $v) { if($v[sendtime] == 0 && $v[receivetime] == 0){ $list[$k][progress] = 1; // 已付款,待发货 } if($v[sendtime] > 0 && $v[receivetime] == 0){ $list[$k][progress] = 2; // 已发货,待签收 } if($v[sendtime] > 0 && $v[receivetime] > 0){ $list[$k][progress] = 3; // 交易完成 } } // 获取拓展员用户 $user_list = M(User) ->where(array(opener_id=>$this->opener_id)) ->field(id,username) ->select(); $this->assign(user_list,$user_list); $this->assign(totalprice,$totalprice); $this->assign(page,$Page->show()); $this->assign(list, $list); $this->display(); }
html部分
<include file=Public:head title=交易详情{ background-color: #eee; height: 50px; line-height: 50px; font-size: 18px; border-bottom: #ddd 1px solid; margin-bottom: -1px; } .list-group{ border: 1px solid #DDDDDD; } .list-group .list-group-item { text-align: left; line-height: 25px; border: none; background-color: #F9F9F9; font-size: 14px; } #select-date { padding: 0px 10px; } #select-date .date-txt { font-size: 18px; } #total { width: 140px; height: 140px; background-color: #EC6C00; margin: auto; } #total .money-txt { color: white; padding-top: 10px; } #datalist { margin-top: 30px; } #relief .form-control{ margin-top: 10px; margin-bottom: 10px; /*background-color: #FFCE42;*/ } .page{ margin-right: 10px; margin-bottom: 20px; } .table th { color: #C4C4C4; } .table tbody tr td+td+td { color: #D3964F; } </style> <script type=text/javascript> function lastMonth(){ todo(last); } function nextMonth(){ todo(next); } function selectUser(){ todo(selectuser); } function todo(type){ var s_year = $(#s_year).val(); var s_month = $(#s_month).val(); var s_user_id = $(#s_user_id).val(); window.location.href={sh::U(User/trade)}&s_year=+s_year+&s_month=+s_month+&s_user_id=+s_user_id+&type=+type; } </script> <body> <div data-example-id=list-group-btns class=bs-example> <div id=select-date> <ul class=pager> <li class=previous><a onclick=lastMonth();><span aria-hidden=true>←</span> </a></li> <span class=date-txt><strong>{sh:$s_year}.{sh:$s_month}</strong> <present name=paymentData><span class=glyphicon glyphicon-ok-sign aria-hidden=true></span></present> </span> <input type=text id=s_year value={sh:$s_year} hidden=hidden> <input type=text id=s_month value={sh:$s_month} hidden=hidden> <li class=next><a onclick=nextMonth();><span aria-hidden=true>→</span></a></li> </ul> </div> <div id=relief> <select id=s_user_id onchange=selectUser(); class=form-control btn-success> <option value=>全部商户</option> <volist name=user_list id=vo> <option value={sh:$vo.id} <eq name=vo.id value=$s_user_id>selected=selected</eq>>{sh:$vo.username}</option> </volist> </select> </div> <div id=total class=img-circle> <div class=text-center money-txt> <h3>总交易金额</h3> <h2>￥{sh:$totalprice}</h2> </div> </div> <div id=datalist> <table class=table table-striped> <thead> <tr> <th>商户</th> <th>日期</th> <th>交易金额</th> <!-- <th>状态</th> --> </tr> </thead> <tbody> <empty name=list><tr><td class=text-center colspan=4>暂无数据</td></tr></empty> <volist name=list id=vo> <tr> <td>{sh:$vo.username}</td> <td>{sh:$vo.paytimedate=Y-m-d H:i,###}</td> <td>{sh:$vo.price}</td> <!-- <td> <if condition=$vo.progress eq 1><span class=text-primary>待发货</span> <elseif condition=$vo.progress eq 2/><span class=text-danger>待签收</span> <elseif condition=$vo.progress eq 3/><span class=text-success><strong>已完成</strong></span> </if> </td> --> </tr> </volist> </tbody> </table> <div class=page text-right> {sh:$page} </div> </div> </body> </html>
效果，多看看别人的设计，多学学，最重要的就是界面展示，一切的数据都是基于几面展示，所以先确定好需要什么数据，然后获取他们。
更多关于thinkPHP相关内容感兴趣的读者可查看本站专题：《ThinkPHP入门教程》、《thinkPHP模板操作技巧总结》、《ThinkPHP常用方法总结》、《codeigniter入门教程》、《CI(CodeIgniter)框架进阶教程》、《Zend FrameWork框架入门教程》、《smarty模板入门基础教程》及《PHP模板技术总结》。
希望本文所述对大家基于ThinkPHP框架的PHP程序设计有所帮助。