system.order.stats.php 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. <?php defined('InShopNC') or exit('Access Invalid!'); ?>
  2. <div class="page">
  3. <div class="fixed-bar">
  4. <div class="item-title">
  5. <h3>对账管理</h3>
  6. <ul class="tab-base">
  7. <li><a href="index.php?act=merchant&op=provider_evidence"><span>上游充值申请记录</span></a></li>
  8. <li><a href="index.php?act=merchant&op=provider_evidence_add"><span>新增上游充值申请</span></a></li>
  9. <li><a href="JavaScript:void(0);" class="current"><span>平台对账记录</span></a></li>
  10. <li><a href="index.php?act=merchant&op=OrderStats&type=provider"><span>通道对账记录</span></a></li>
  11. <li><a href="index.php?act=merchant&op=OrderStats&type=merchant"><span>商户对账记录</span></a></li>
  12. </ul>
  13. </div>
  14. </div>
  15. <div class="fixed-empty"></div>
  16. <form method="get" name="formSearch" id="formSearch">
  17. <input type="hidden" value="merchant" name="act">
  18. <input type="hidden" value="OrderStats" name="op">
  19. <table class="tb-type1 noborder search">
  20. <tbody>
  21. <tr>
  22. <th><label for="query_start_time">统计时间</label></th>
  23. <td>
  24. <input class="txt date" type="text" value="<?php echo $_GET['query_start_time']; ?>"
  25. id="startTime" name="query_start_time" autocomplete="off" style="width:120px" />
  26. <label for="query_start_time">~</label>
  27. <input class="txt date" type="text" value="<?php echo $_GET['query_end_time']; ?>"
  28. id="endTime" name="query_end_time" autocomplete="off" style="width:120px" /></td>
  29. <td><a href="javascript:void(0);" id="ncsubmit" class="btn-search "
  30. title="<?php echo $lang['nc_query']; ?>">&nbsp;</a>
  31. <?php if ($output['mch_name'] != '') { ?>
  32. <a href="index.php?act=merchant&op=orderstats" class="btns "
  33. title="<?php echo $lang['nc_cancel_search']; ?>"><span><?php echo $lang['nc_cancel_search']; ?></span></a>
  34. <?php } ?></td>
  35. </tr>
  36. </tbody>
  37. </table>
  38. </form>
  39. <table class="table tb-type2" id="prompt">
  40. <tbody>
  41. <tr class="space odd">
  42. <th colspan="12"><div class="title">
  43. <h5>总量统计</h5>
  44. <span class="arrow"></span></div></th>
  45. </tr>
  46. <tr>
  47. <td>
  48. <ul>
  49. <li class="lineLi" style="color:#000;">总计成功订单量: <?php echo $output['total_stats']['success_count_total'] ?? 0?></li>
  50. <li class="lineLi" style="color:#000;">总计成功订单金额:<?php echo $output['total_stats']['success_refill_amounts_total'] ?? 0?></li>
  51. <li class="lineLi" style="color:#000;">总计机构扣款金额:<?php echo $output['total_stats']['success_mch_amounts_toatl'] ?? 0?></li>
  52. <li class="lineLi" style="color:#000;">总计通道扣款金额:<?php echo $output['total_stats']['success_channel_amounts_total'] ?? 0?></li>
  53. </ul>
  54. </td>
  55. </tr>
  56. </tbody>
  57. </table>
  58. <form method="post" id="merchant_name_form">
  59. <input type="hidden" name="form_submit" value="ok"/>
  60. <table class="table tb-type2">
  61. <thead>
  62. <tr class="thead">
  63. <th>统计日期</th>
  64. <th>主体名称</th>
  65. <th>主体ID</th>
  66. <th class="align-center">成功订单数</th>
  67. <th class="align-center">成功金额</th>
  68. <th class="align-center">商户金额</th>
  69. <th class="align-center">通道金额</th>
  70. <th class="align-center">利润</th>
  71. <th class="align-center">服务费</th>
  72. <th class="align-center">订单总量</th>
  73. <th class="align-center">失败订单数量</th>
  74. <th class="align-center">成功占比</th>
  75. <th class="align-center"><?php echo $lang['operation']; ?></th>
  76. </tr>
  77. </thead>
  78. <tbody>
  79. <?php if (!empty($output['stats_list']) && is_array($output['stats_list'])) { ?>
  80. <?php foreach ($output['stats_list'] as $k => $v) { ?>
  81. <tr class="trFlex">
  82. <td><?php echo $v['time_text']; ?></td>
  83. <td><?php echo $v['cname']; ?></td>
  84. <td><?php echo $v['cid']; ?></td>
  85. <td class="align-center"><?php echo $v['success_count']; ?></td>
  86. <td class="align-center"><?php echo $v['success_refill_amounts']; ?></td>
  87. <td class="align-center"><?php echo $v['success_mch_amounts']; ?></td>
  88. <td class="align-center"><?php echo $v['success_channel_amounts']; ?></td>
  89. <td class="align-center"><?php echo $v['profit_amounts']; ?></td>
  90. <td class="align-center"><?php echo $v['service_amounts']; ?></td>
  91. <td class="align-center"><?php echo $v['order_count']; ?></td>
  92. <td class="align-center"><?php echo $v['cancel_count']; ?></td>
  93. <td class="align-center"><?php echo $v['success_ratio']; ?></td>
  94. <td class="align-center w200">
  95. <a href="index.php?act=merchant&op=OrderStatsReload&stat_id=<?php echo $v['stat_id'];?>">重新统计</a>
  96. </td>
  97. </tr>
  98. <?php } ?>
  99. <?php } else { ?>
  100. <tr class="no_data">
  101. <td colspan="15"><?php echo $lang['nc_no_record']; ?></td>
  102. </tr>
  103. <?php } ?>
  104. </tbody>
  105. <tfoot>
  106. <tr class="tfoot">
  107. <td></td>
  108. <td colspan="16">
  109. <div class="pagination"><?php echo $output['page']; ?></div>
  110. </td>
  111. </tr>
  112. </tfoot>
  113. </table>
  114. </form>
  115. </div>
  116. <script type="text/javascript" src="<?php echo RESOURCE_SITE_URL; ?>/js/jquery.edit.js" charset="utf-8"></script>
  117. <script type="text/javascript" src="<?php echo RESOURCE_SITE_URL; ?>/laydate/laydate.js"></script>
  118. <script>
  119. $(function () {
  120. $('#ncsubmit').click(function () {
  121. $('input[name="op"]').val('OrderStats');
  122. $('#formSearch').submit();
  123. });
  124. // 日期选择器
  125. laydate.render({
  126. elem: '#startTime',
  127. type: 'datetime'
  128. });
  129. laydate.render({
  130. elem: '#endTime',
  131. type: 'datetime'
  132. });
  133. // 表格hover时背景
  134. $('.trFlex').each(function () {
  135. $(this).hover(function () {
  136. $(this)[0].style.backgroundColor = '#cbe9f3'
  137. },function() {
  138. $(this)[0].style.backgroundColor = '#fff'
  139. })
  140. })
  141. });
  142. </script>