stat.income.php 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  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. <?php echo $output['top_link'];?> </div>
  7. </div>
  8. <div class="fixed-empty"></div>
  9. <form method="get" action="index.php" name="formSearch" id="formSearch">
  10. <input type="hidden" name="act" value="stat_trade" />
  11. <input type="hidden" name="op" value="income" />
  12. <input type="hidden" name="" value="" />
  13. <div class="w100pre" style="width: 100%;">
  14. <table class="tb-type1 noborder search left">
  15. <tbody>
  16. <tr>
  17. <th>年份</th>
  18. <td><select name="search_year" id="search_year" class="querySelect">
  19. <?php for ($i=2009;$i<=2020;$i++){ ?>
  20. <option value="<?php echo $i; ?>" <?php echo $_GET['search_year'] == $i?'selected':''; ?>><?php echo $i; ?></option>
  21. <?php } ?>
  22. </select></td>
  23. <th>月份</th>
  24. <td><select name="search_month" id="search_month" class="querySelect">
  25. <option value="01" <?php echo $_GET['search_month']=='01'?'selected':''; ?>>1</option>
  26. <option value="02" <?php echo $_GET['search_month']=='02'?'selected':''; ?>>2</option>
  27. <option value="03" <?php echo $_GET['search_month']=='03'?'selected':''; ?>>3</option>
  28. <option value="04" <?php echo $_GET['search_month']=='04'?'selected':''; ?>>4</option>
  29. <option value="05" <?php echo $_GET['search_month']=='05'?'selected':''; ?>>5</option>
  30. <option value="06" <?php echo $_GET['search_month']=='06'?'selected':''; ?>>6</option>
  31. <option value="07" <?php echo $_GET['search_month']=='07'?'selected':''; ?>>7</option>
  32. <option value="08" <?php echo $_GET['search_month']=='08'?'selected':''; ?>>8</option>
  33. <option value="09" <?php echo $_GET['search_month']=='09'?'selected':''; ?>>9</option>
  34. <option value="10" <?php echo $_GET['search_month']=='10'?'selected':''; ?>>10</option>
  35. <option value="11" <?php echo $_GET['search_month']=='11'?'selected':''; ?>>11</option>
  36. <option value="12" <?php echo $_GET['search_month']=='12'?'selected':''; ?>>12</option>
  37. </select></td>
  38. <td><a href="javascript:void(0);" id="ncsubmit" class="btn-search tooltip" title="<?php echo $lang['nc_query'];?>">&nbsp;</a></td>
  39. </tr>
  40. </tbody>
  41. </table>
  42. <span class="right" style="margin:12px 0px 6px 4px;"> </span> </div>
  43. </form>
  44. <div class="stat-info"><span>收款金额:<strong><?php echo number_format($output['plat_data']['oot'],2); ?></strong>元</span><span>退款金额:<strong><?php echo number_format($output['plat_data']['oort'],2); ?></strong>元</span><span>实收金额:<strong><?php echo number_format($output['plat_data']['oot']-$output['plat_data']['oort'],2); ?></strong>元</span><span>佣金总额:<strong><?php echo number_format($output['plat_data']['oct'],2); ?></strong>元</span><span>店铺费用:<strong><?php echo number_format($output['plat_data']['osct'],2); ?></strong>元</span><span>总收入:<strong><?php echo number_format($output['plat_data']['ort'],2); ?></strong>元</span></div>
  45. <div id="container" class="w100pre close_float" style="height:50px"></div>
  46. <div style="text-align:right;">
  47. <input type="hidden" id="export_type" name="export_type" data-param='{"url":"index.php?act=stat_trade&op=income&search_year=<?php echo intval($_GET['search_year']); ?>&search_month=<?php echo trim($_GET['search_month']); ?>&exporttype=excel"}' value="excel"/>
  48. <a class="btns" href="javascript:void(0);" id="export_btn"><span>导出Excel</span></a> </div>
  49. <table class="table tb-type2 nobdb">
  50. <thead>
  51. <tr class="thead">
  52. <th class="align-center">店铺名称</th>
  53. <th class="align-center">卖家账号</th>
  54. <th class="align-center">订单金额</th>
  55. <th class="align-center">收取佣金</th>
  56. <th class="align-center">退单金额</th>
  57. <th class="align-center">退回佣金</th>
  58. <th class="align-center">店铺费用</th>
  59. <th class="align-center">结算金额</th>
  60. <th class="align-center">操作</th>
  61. </tr>
  62. </thead>
  63. <tbody id="datatable">
  64. <?php if(!empty($output['store_list'])){ ?>
  65. <?php foreach ($output['store_list'] as $k=>$v){?>
  66. <tr class="hover">
  67. <td class="align-center"><a href="<?php echo SHOP_SITE_URL; ?>/index.php?act=show_store&store_id=<?php echo $v['ob_store_id']; ?>" target="_blank"><?php echo $v['ob_store_name']; ?></a></td>
  68. <td class="align-center"><?php echo $v['member_name']; ?></td>
  69. <td class="align-center"><?php echo $v['ob_order_totals']; ?></td>
  70. <td class="align-center"><?php echo $v['ob_commis_totals']; ?></td>
  71. <td class="align-center"><?php echo $v['ob_order_return_totals']; ?></td>
  72. <td class="align-center"><?php echo $v['ob_commis_return_totals']; ?></td>
  73. <td class="align-center"><?php echo $v['ob_store_cost_totals']; ?></td>
  74. <td class="align-center"><?php echo $v['ob_result_totals']; ?></td>
  75. <td class="align-center"><a href="index.php?act=stat_trade&op=sale&search_type=month&search_time_month=<?php echo intval($_GET['search_month']); ?>&search_time_year=<?php echo intval($_GET['search_year']); ?>&store_name=<?php echo $v['ob_store_name']; ?>">详细</a></td>
  76. </tr>
  77. <?php } ?>
  78. <?php }else { ?>
  79. <tr class="no_data">
  80. <td colspan="15"><?php echo $lang['nc_no_record'];?></td>
  81. </tr>
  82. <?php } ?>
  83. </tbody>
  84. <?php if(!empty($output['store_list']) && is_array($output['store_list'])){ ?>
  85. <tfoot>
  86. <tr class="tfoot">
  87. <td colspan="15" id="dataFuncs"><div class="pagination"> <?php echo $output['show_page'];?> </div></td>
  88. </tr>
  89. </tfoot>
  90. <?php } ?>
  91. </table>
  92. <script type="text/javascript" src="<?php echo RESOURCE_SITE_URL;?>/js/jquery-ui/jquery.ui.js"></script>
  93. <script type="text/javascript" src="<?php echo RESOURCE_SITE_URL;?>/js/jquery-ui/i18n/zh-CN.js" charset="utf-8"></script>
  94. <link rel="stylesheet" type="text/css" href="<?php echo RESOURCE_SITE_URL;?>/js/jquery-ui/themes/ui-lightness/jquery.ui.css" />
  95. <script type="text/javascript" src="<?php echo RESOURCE_SITE_URL;?>/highcharts/highcharts.js"></script>
  96. <script type="text/javascript" src="<?php echo RESOURCE_SITE_URL;?>/js/statistics.js"></script>
  97. </div>
  98. <script>
  99. $(function () {
  100. $('#ncsubmit').click(function(){
  101. $('#formSearch').submit();
  102. });
  103. //导出图表
  104. $("#export_btn").click(function(){
  105. var item = $("#export_type");
  106. var type = $(item).val();
  107. if(type == 'excel'){
  108. download_excel(item);
  109. }
  110. });
  111. $('#ncexport').click(function(){
  112. $("#")
  113. $('#formSearch').submit();
  114. });
  115. });
  116. </script>