memberranking.html
4.56 KB
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
{template 'common/header'}
<ul class="nav nav-tabs">
<li {if $op == 'salereport'}class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'salereport'))}">零售生意报告</a></li>
<li {if $op == 'orderstatistics' }class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'orderstatistics'))}">订单统计</a></li>
<li {if $op == 'saledetails' }class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'saledetails'))}">商品销售明细</a></li>
<li {if op == 'saletargets' }class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'saletargets'))}">销售指标分析</a></li>
<li {if $op == 'productsaleranking' }class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'productsaleranking'))}">商品销售排行</a></li>
<li {if $op == 'productsalestatistics'}class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'productsalestatistics'))}">商品访问与购买比</a></li>
<li {if $op == 'memberranking' }class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'memberranking'))}">会员消费排行</a></li>
<li {if $op == 'fansrange' }class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'fansrange'))}">代理粉丝排行</a></li>
<li {if $op == 'userincreasestatistics'&&$usertype=='user' }class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'userincreasestatistics'))}">会员增长统计</a></li>
<li {if $op == 'userincreasestatistics'&&$usertype=='agent' }class="active"{/if}><a href="{php echo $this->createWebUrl('statistics', array('op' => 'userincreasestatistics','usertype'=>'agent'))}">代理增长统计</a></li>
</ul>
<div class="main">
<form action="./index.php" method="get" class="form-horizontal" role="form" id="form1">
<input type="hidden" name="c" value="site" />
<input type="hidden" name="a" value="entry" />
<input type="hidden" name="m" value="wwx_fxxt" />
<input type="hidden" name="do" value="statistics" />
<input type="hidden" name="op" value="memberranking" />
<input name="token" type="hidden" value="{$_W['token']}" />
<div class="alert alert-info">
<i class="icon-lightbulb"></i>查询有成交记录的会员的订单数和购物金额,并按购物金额从高到低排行!
</div>
<div class="panel panel-default">
<div class="panel-heading">筛选</div>
<div class="panel-body">
<div class="form-group">
<label class="col-xs-12 col-sm-2 col-md-2 col-lg-1 control-label">起始日期</label>
<div class="col-sm-7 col-lg-9 col-xs-12">
{php echo tpl_form_field_daterange('time', array('start'=>date('Y-m-d', $start_time),'end'=>date('Y-m-d', $end_time)));}
</div>
</div>
<div class="form-group">
<label class="col-xs-12 col-sm-2 col-md-2 col-lg-1 control-label">排行方式</label>
<div class="col-sm-8 col-lg-9 col-xs-12">
<select name="sortname" style="width:150px;">
<option {if $sortname == 'ordermoney'}selected="selected"{/if} value="ordermoney">消费金额</option>
<option {if $sortname == 'ordercount'}selected="selected"{/if}value="ordercount">订单数</option>
</select>
</div>
</div>
<div class="form-group">
<input type="submit" name="" value="查询" class="btn btn-primary" style="height:30px">
<button type="submit" name="memberrankingEXP01" value="memberrankingEXP01" class="btn btn-warning btn-lg">导出excel</button>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading">会员消费排行</div>
<div class="panel-body">
<div class="form-group">
<table class="table table-hover">
<thead class="navbar-inner">
<tr>
<th style="width:10%;">排行</th>
<th style="width:20%;">会员</th>
<th style="width:10%;">订单数</th>
<th style="width:10%;">消费金额</th>
</tr>
</thead>
<tbody>
{php $index=1}
{loop $list $item}
<tr>
<td>
{$index} {if $index==1||$index==2||$index==3}
<img src="{WWX_FXXT_ROOT}/recouse/images/000{$index}.gif" style="border-width:0px;">
{/if}{php $index++}
</td>
<td>{$item['realname']}</td>
<td>{$item['ordercount']}</td>
<td>{if empty($item['ordermoney'])}0 {else}{$item['ordermoney']}{/if}</td>
</tr>
{/loop}
</table>
{$pager}
</div>
</div>
</div>
</form>
</div>
{template 'common/footer'}