credit2.html 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252
  1. {template 'common/header'}
  2. <style>
  3. .account-stat-num > div{width:25%; float:left; font-size:16px; text-align:center;}
  4. .account-stat-num > div span{display:block; font-size:30px; font-weight:bold;}
  5. </style>
  6. <ul class="nav nav-tabs">
  7. <li {if $do == 'index'}class="active"{/if}><a href="{php echo url('stat/credit2')}">余额日志</a></li>
  8. <li {if $do == 'chart'}class="active"{/if}><a href="{php echo url('stat/credit2/chart')}">余额统计</a></li>
  9. </ul>
  10. {if $do == 'chart'}
  11. <div class="panel panel-default">
  12. <div class="panel-heading">
  13. 余额统计
  14. </div>
  15. <div class="panel-body">
  16. <div class="account-stat-num row">
  17. <div>今日充值总额<span>{$today_recharge}</span></div>
  18. <div>今日消费总额<span>{php echo abs($today_consume);}</span></div>
  19. <div>{php echo date('Y-m-d', $starttime);}~{php echo date('Y-m-d', $endtime);}<br>充值总额<span>{$total_recharge}</span></div>
  20. <div>{php echo date('Y-m-d', $starttime);}~{php echo date('Y-m-d', $endtime);}<br>消费总额<span>{php echo abs($total_consume)}</span></div>
  21. </div>
  22. </div>
  23. </div>
  24. <div class="panel panel-default">
  25. <div class="panel-heading">
  26. 余额统计
  27. </div>
  28. <div class="panel-body" id="scroll">
  29. <div class="pull-left">
  30. <form action="" id="form1">
  31. <input name="c" value="stat" type="hidden" />
  32. <input name="a" value="credit2" type="hidden" />
  33. <input name="do" value="chart" type="hidden" />
  34. {php echo tpl_form_field_daterange('time', array('start' => date('Y-m-d', $starttime),'end' => date('Y-m-d', $endtime)), '')}
  35. <input type="hidden" value="" name="scroll">
  36. </form>
  37. </div>
  38. <div class="pull-right">
  39. <div class="checkbox">
  40. <label style="color:rgba(149,192,0,1);;"><input checked type="checkbox"> 充值统计</label>&nbsp;
  41. <label style="color:rgba(203,48,48,1)"><input checked type="checkbox"> 消费统计</label>&nbsp;
  42. </div>
  43. </div>
  44. <div style="margin-top:20px">
  45. <canvas id="myChart" width="1200" height="300"></canvas>
  46. </div>
  47. </div>
  48. </div>
  49. <script>
  50. require(['chart', 'daterangepicker'], function(c) {
  51. $('.daterange').on('apply.daterangepicker', function(ev, picker) {
  52. $('#form1')[0].submit();
  53. });
  54. var chart = null;
  55. var chartDatasets = null;
  56. var templates = {
  57. consume: {
  58. label: '消费',
  59. fillColor : "rgba(203,48,48,0.1)",
  60. strokeColor : "rgba(203,48,48,1)",
  61. pointColor : "rgba(203,48,48,1)",
  62. pointStrokeColor : "#fff",
  63. pointHighlightFill : "#fff",
  64. pointHighlightStroke : "rgba(203,48,48,1)"
  65. },
  66. recharge: {
  67. label: '充值',
  68. fillColor : "rgba(149,192,0,0.1)",
  69. strokeColor : "rgba(149,192,0,1)",
  70. pointColor : "rgba(149,192,0,1)",
  71. pointStrokeColor : "#fff",
  72. pointHighlightFill : "#fff",
  73. pointHighlightStroke : "rgba(149,192,0,1)"
  74. }
  75. };
  76. function refreshData() {
  77. if(!chart || !chartDatasets) {
  78. return;
  79. }
  80. var visables = [];
  81. var i = 0;
  82. $('.checkbox input[type="checkbox"]').each(function(){
  83. if($(this).attr('checked')) {
  84. visables.push(i);
  85. }
  86. i++;
  87. });
  88. var ds = [];
  89. $.each(visables, function(){
  90. var o = chartDatasets[this];
  91. ds.push(o);
  92. });
  93. chart.datasets = ds;
  94. chart.update();
  95. }
  96. var url = location.href + '&#aaaa';
  97. $.post(url, function(data){
  98. var data = $.parseJSON(data)
  99. var datasets = data.datasets;
  100. if(!chart) {
  101. var label = data.label;
  102. var ds = $.extend(true, {}, templates);
  103. ds.consume.data = datasets.consume;
  104. ds.recharge.data = datasets.recharge;
  105. var lineChartData = {
  106. labels : label,
  107. datasets : [ds.consume, ds.recharge]
  108. };
  109. var ctx = document.getElementById("myChart").getContext("2d");
  110. chart = new Chart(ctx).Line(lineChartData, {
  111. responsive: true
  112. });
  113. chartDatasets = $.extend(true, {}, chart.datasets);
  114. }
  115. refreshData();
  116. });
  117. $('.checkbox input[type="checkbox"]').on('click', function(){
  118. $(this).attr('checked', !$(this).attr('checked'))
  119. refreshData();
  120. });
  121. });
  122. </script>
  123. {else}
  124. <div class="panel panel-info">
  125. <div class="panel-heading">筛选</div>
  126. <div class="panel-body">
  127. <form action="./index.php" method="get" class="form-horizontal" role="form">
  128. <input type="hidden" name="c" value="stat">
  129. <input type="hidden" name="a" value="credit2">
  130. <input type="hidden" name="do" value="stat">
  131. <input type="hidden" name="num" value="{$num}">
  132. <div class="form-group">
  133. <label class="col-xs-12 col-sm-3 col-md-2 control-label">类型</label>
  134. <div class="col-sm-8 col-lg-9 col-xs-12">
  135. <div class="btn-group">
  136. <a href="{php echo filter_url('num:0');}" class="btn {if !$_GPC['num']}btn-primary{else}btn-default{/if}">不限</a>
  137. <a href="{php echo filter_url('num:1');}" class="btn {if $_GPC['num'] == 1}btn-primary{else}btn-default{/if}">充值</a>
  138. <a href="{php echo filter_url('num:2');}" class="btn {if $_GPC['num'] == 2}btn-primary{else}btn-default{/if}">消费</a>
  139. </div>
  140. </div>
  141. </div>
  142. <div class="form-group">
  143. <label class="col-xs-12 col-sm-3 col-md-2 control-label">消费时间</label>
  144. <div class="col-sm-6 col-md-8 col-lg-8 col-xs-12">
  145. {php echo tpl_form_field_daterange('time', array('starttime' => date('Y-m-d', $starttime), 'endtime' => date('Y-m-d', $endtime),));}
  146. </div>
  147. </div>
  148. <div class="form-group">
  149. <label class="col-xs-12 col-sm-3 col-md-2 control-label">姓名/手机号码/UID</label>
  150. <div class="col-sm-6 col-md-8 col-lg-8 col-xs-12">
  151. <input type="text" class="form-control" name="user" value="{$_GPC['uid']}" />
  152. </div>
  153. </div>
  154. <div class="form-group">
  155. <label class="col-xs-12 col-sm-3 col-md-2 control-label">操作人</label>
  156. <div class="col-sm-6 col-md-8 col-lg-8 col-xs-12">
  157. <select class="form-control" name="clerk_id">
  158. <option value="">不限</option>
  159. {loop $clerks $clerk}
  160. <option value="{$clerk['id']}" {if $_GPC['clerk_id'] == $clerk['id']}selected{/if}>{$clerk['name']}</option>
  161. {/loop}
  162. </select>
  163. </div>
  164. </div>
  165. <div class="form-group">
  166. <label class="col-xs-12 col-sm-3 col-md-2 control-label">消费门店</label>
  167. <div class="col-sm-6 col-md-8 col-lg-8 col-xs-12">
  168. <select class="form-control" name="store_id">
  169. <option value="">不限</option>
  170. {loop $stores $store}
  171. <option value="{$store['id']}" {if $_GPC['store_id'] == $store['id']}selected{/if}>{$store['business_name']}</option>
  172. {/loop}
  173. </select>
  174. </div>
  175. </div>
  176. <div class="form-group">
  177. <label class="col-xs-12 col-sm-3 col-md-2 control-label">余额</label>
  178. <div class="col-sm-6 col-md-8 col-lg-8 col-xs-12">
  179. <div class="input-group">
  180. <input type="text" class="form-control" name="min" value="{$_GPC['min']}" />
  181. <span class="input-group-addon">至</span>
  182. <input type="text" class="form-control" name="max" value="{$_GPC['max']}" />
  183. </div>
  184. </div>
  185. </div>
  186. <div class="form-group">
  187. <label class="col-xs-12 col-sm-3 col-md-2 control-label"></label>
  188. <div class="col-xs-12 col-sm-3 col-md-2 col-lg-2">
  189. <button class="btn btn-default"><i class="fa fa-search"></i> 搜索</button>
  190. <button name="export" value="export" class="btn btn-default"><i class="fa fa-download"></i> 导出数据</button>
  191. <input type="hidden" name="token" value="{$_W['token']}"/>
  192. </div>
  193. </div>
  194. </form>
  195. </div>
  196. </div>
  197. <form method="post" class="form-horizontal" id="form1">
  198. <div class="panel panel-default ">
  199. <div class="table-responsive panel-body">
  200. <table class="table table-hover">
  201. <thead>
  202. <tr>
  203. <th style="width:80px;">会员编号</th>
  204. <th>姓名</th>
  205. <th>手机</th>
  206. <th>类型</th>
  207. <th>金额</th>
  208. <th width="200">消费门店</th>
  209. <th>操作人</th>
  210. <th>操作时间</th>
  211. <th width="400">备注</th>
  212. </tr>
  213. </thead>
  214. <tbody>
  215. {loop $data $row}
  216. <tr>
  217. <td>{$row['uid']}</td>
  218. <td>{$users[$row['uid']]['realname']}</td>
  219. <td>{$users[$row['uid']]['mobile']}</td>
  220. <td>
  221. {if $row['num'] > 0}
  222. <span class="label label-success">充值</span>
  223. {else}
  224. <span class="label label-danger">消费</span>
  225. {/if}
  226. </td>
  227. <td>{php echo abs($row['num']);}</td>
  228. <td>{$row['store_cn']}</td>
  229. <td>{$row['clerk_cn']}</td>
  230. <td>{php echo date('Y-m-d H:i', $row['createtime'])}</td>
  231. <td style="cursor: pointer"><span data-toggle="popover" data-placement="top" data-trigger="hover" data-content="{$row['remark']}">{php echo cutstr($row['remark'], 30, '...');}</span></td>
  232. </tr>
  233. {/loop}
  234. </tbody>
  235. </table>
  236. </div>
  237. </div>
  238. {$pager}
  239. </form>
  240. <script>
  241. require(['bootstrap'],function($){
  242. $('[data-toggle="popover"]').popover()
  243. });
  244. </script>
  245. {/if}
  246. {template 'common/footer'}