本文实例分析了thinkphp交易详情查询功能。分享给大家供大家参考,具体如下:
交易详情
一般都是按月的,包含,交易日期,交易金额,交易状态(可有可无)
总交易额等等。
如果数据多的话,最好能够分页。
最好能够查询具体的哪一个商户。
1.模拟sql实现查询功能
1
2
3
4
5
6
7
8
|
select 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 from sh_user a
left join sh_store b on a.id = b.user_id
left join sh_order c on b.id = c.store_id
where a.opener_id = 1 and a.`status` = 1 and c.status = 1 order by c.id desc;
select count (b.id) as count ,sum(c.price) as total_price from sh_user a
left join sh_store b on a.id = b.user_id
left join sh_order c on b.id = c.store_id
where a.opener_id = 1 and a.`status` = 1 and c.status = 1;
|
sql查询出来了,基本上就搞定了,剩下的就是用php,thinkphp实现这个查询功能,加入一些逻辑与条件。
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
// 商户交易
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部分
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
< include file= "public:head" title= "交易详情" />
<style>
.top {
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 .paytime| date = "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框架的php程序设计有所帮助。