publish_statistics.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244
  1. <?php
  2. // by 请勿倒卖,已申请软著,否则追究法律责任
  3. namespace app\index;
  4. class publish_statistics extends BaseUser
  5. {
  6. function index()
  7. {
  8. $id = bees_decrypt(SafeRequest("id", "get"));
  9. $row = db('appid')->where('in_uid', $this->userid)->where('in_id', $id)->find();
  10. $row || exit(include_once dirname(__FILE__) . '/../pack/error/404.php');
  11. $sid = bees_encrypt($row['in_id']);
  12. $start_date = SafeRequest("start_date", "get");
  13. $end_date = SafeRequest("end_date", "get");
  14. $starttime = $start_date . ' 00:00:00';
  15. $endtime = $end_date . ' 23:59:59';
  16. $specified = '';
  17. if (!empty($start_date) && !empty($end_date)) {
  18. $specified = "addtime>'" . $starttime . "' and addtime<'" . $endtime . "' ";
  19. }
  20. $total = db('downhistory')->where($specified)->where('appid', $id)->where('uid', $this->userid)->count();
  21. $num = 10;
  22. $cpage = isset($_GET['page']) ? $_GET['page'] : 1;
  23. $pagenum = ceil($total / $num);
  24. $offset = ($cpage - 1) * $num;
  25. $result = db('downhistory')->where($specified)->where('appid', $id)->where('uid', $this->userid)->order('addtime desc')->limit($offset, $num)->select();
  26. $start = $offset + 1;
  27. $end = $cpage == $pagenum ? $total : $cpage * $num;
  28. $next = $cpage == $pagenum ? 0 : $cpage + 1;
  29. $prev = $cpage == 1 ? 0 : $cpage - 1;
  30. ?> <!DOCTYPE html>
  31. <html lang="">
  32. <head>
  33. <meta charset="utf-8">
  34. <meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=0"/>
  35. <meta name="keywords" content="<?php echo IN_KEYWORDS;?>"/>
  36. <meta name="description" content="<?php echo IN_DESCRIPTION;?>"/>
  37. <title><?php echo $row['in_name'];?>应用详情 - <?php echo IN_NAME;?></title>
  38. <?php
  39. $this->static_();
  40. ?> </head>
  41. <body>
  42. <?php
  43. $this->header();
  44. ?> <link rel="stylesheet" href="/static/pack/font-awesome-4.7.0/css/font-awesome.css"/>
  45. <link rel="stylesheet" type="text/css" href="/static/index/css/jquery.datetimepicker.css?20190530"/>
  46. <script src="/static/index/js/jquery.datetimepicker.js?20190530"></script>
  47. <script src="/static/index/js/bootstrap-paginator.js"></script>
  48. <div class="release-app-wrap">
  49. <div class="container">
  50. <div class="release-app2">
  51. <div class="crumbs">
  52. <a href="/index/apps/apps">我的应用</a>
  53. <span>/</span>
  54. <a href="/index/apps/apps">应用列表</a>
  55. <span>/</span>
  56. <?php echo $row['in_name'];?> </div>
  57. <div class="row clearfix">
  58. <?php
  59. $this->publish_left();
  60. ?> <div class="col-sm-10">
  61. <div class="aside-right">
  62. <div class="app-details app-details2">
  63. <?php
  64. $this->publish_top($row);
  65. ?> <hr>
  66. <div class="download-details">
  67. <div class="d-top clearfix">
  68. <div class="date date1">
  69. <input class="form-control" type="text" id="datetimepicker1"
  70. value="<?php
  71. if (empty($start_date)) {
  72. ?><?php echo date("Y/m/d", strtotime(date("Y/m/d") . '-1 week'));?><?php
  73. } else {
  74. ?><?php echo $start_date;?><?php
  75. }
  76. ?>">
  77. <span class="iconfont icon-date"></span>
  78. </div>
  79. <div class="fl line">
  80. _
  81. </div>
  82. <div class="date date2">
  83. <input class="form-control" type="text" id="datetimepicker2"
  84. value="<?php
  85. if (empty($end_date)) {
  86. ?><?php echo date("Y/m/d");?><?php
  87. } else {
  88. ?><?php echo $end_date;?><?php
  89. }
  90. ?>">
  91. <span class="iconfont icon-date"></span>
  92. </div>
  93. <button type="button" class="ms-btn ms-btn-secondary fl query">查询</button>
  94. <span class="fl num">累计总下载 <i><?php echo $row['in_downloads'];?></i> 次</span>
  95. <button type="button" class="ms-btn ms-btn-secondary fr cleanUp"
  96. data-app-id="<?php echo bees_encrypt($row['in_id']);?>">清空统计数据
  97. </button>
  98. </div>
  99. <div class="table-responsive">
  100. <table class="table">
  101. <tr>
  102. <th>
  103. 时间
  104. </th>
  105. <th>
  106. 应用名称
  107. </th>
  108. <th>
  109. 版本
  110. </th>
  111. <th>
  112. 大小
  113. </th>
  114. <th>
  115. 浏览次数
  116. </th>
  117. <th>
  118. 下载次数
  119. </th>
  120. </tr>
  121. <?php
  122. foreach ($result as $key => $value) {
  123. ?> <tr>
  124. <td>
  125. <?php echo $value['addtime'];?> </td>
  126. <td>
  127. <?php echo $value['appname'];?> </td>
  128. <td>
  129. <?php echo $value['appversion'];?> </td>
  130. <td>
  131. <?php echo formatsize($value['appsize']);?> </td>
  132. <td>
  133. <?php echo $value['liulan'];?> </td>
  134. <td>
  135. <?php echo $value['down'];?> </td>
  136. </tr>
  137. <?php
  138. }
  139. ?> </table>
  140. <?php
  141. if ($total == 0) {
  142. ?> <div class="text-center no-content">
  143. <img src="/static/index/image/invoice-1.png" alt="">
  144. <p class="color-333 mt10">
  145. 暂无任何数据
  146. </p>
  147. </div>
  148. <?php
  149. }
  150. ?> </div>
  151. <?php
  152. if ($pagenum != 1) {
  153. ?> <?php
  154. if ($total !== 0) {
  155. ?> <?php
  156. if (empty($start_date)) {
  157. ?> <div style="text-align: center"><ul id="pager" class="pagination"><li><a>共<b><?php echo $total;?></b>条记录</b> <?php echo $cpage;?>/<?php echo $pagenum;?></a></li><?php
  158. if ($cpage == 1) {
  159. ?><li class='active'><a>首页</a></li><?php
  160. } else {
  161. ?><li><a href='?page=1&id=<?php echo $sid;?>'>首页</a></li><?php
  162. }
  163. if ($prev) {
  164. ?><li><a href='?page=<?php echo $prev;?>&id=<?php echo $sid;?>'>上一页</a></li><?php
  165. } else {
  166. }
  167. if ($next) {
  168. ?><li><a href='?page=<?php echo $next;?>&id=<?php echo $sid;?>'>下一页</a></li><?php
  169. } else {
  170. }
  171. if ($cpage == $pagenum) {
  172. ?><li class='active'><a>尾页</a></li><?php
  173. } else {
  174. ?><li><a href='?page=<?php echo $pagenum;?>&id=<?php echo $sid;?>'>尾页</a></li><?php
  175. }
  176. ?></ul></div> <?php
  177. } else {
  178. ?> <div style="text-align: center"><ul id="pager" class="pagination"><li><a>共<b><?php echo $total;?></b>条记录</b> <?php echo $cpage;?>/<?php echo $pagenum;?></a></li><?php
  179. if ($cpage == 1) {
  180. ?><li class='active'><a>首页</a></li><?php
  181. } else {
  182. ?><li><a href='?page=1&id=<?php echo $sid;?>&start_date=<?php echo $start_date;?>&end_date=<?php echo $end_date;?>'>首页</a></li><?php
  183. }
  184. if ($prev) {
  185. ?><li><a href='?page=<?php echo $prev;?>&id=<?php echo $sid;?>&start_date=<?php echo $start_date;?>&end_date=<?php echo $end_date;?>'>上一页</a></li><?php
  186. } else {
  187. }
  188. if ($next) {
  189. ?><li><a href='?page=<?php echo $next;?>&id=<?php echo $sid;?>&start_date=<?php echo $start_date;?>&end_date=<?php echo $end_date;?>'>下一页</a></li><?php
  190. } else {
  191. }
  192. if ($cpage == $pagenum) {
  193. ?><li class='active'><a>尾页</a></li><?php
  194. } else {
  195. ?><li><a href='?page=<?php echo $pagenum;?>&id=<?php echo $sid;?>&start_date=<?php echo $start_date;?>&end_date=<?php echo $end_date;?>'>尾页</a></li><?php
  196. }
  197. ?></ul></div> <?php
  198. }
  199. ?> <?php
  200. }
  201. ?> <?php
  202. }
  203. ?> </div>
  204. </div>
  205. </div>
  206. </div>
  207. </div>
  208. </div>
  209. </div>
  210. </div>
  211. <?php
  212. $this->inc_merge();
  213. ?> <script>
  214. $(function () {
  215. $(".download-details div:first").on('click', '.query', function () {
  216. var start_date = $(this).parent().find("input:first").val();
  217. var end_date = $(this).parent().find("input:last").val();
  218. window.location.href = "/index/publish_statistics?id=<?php echo bees_encrypt($row['in_id']);?>&start_date=" + start_date + "&end_date=" + end_date + "&page=1";
  219. });
  220. $(".download-details div:first").on('click', '.cleanUp', function () {
  221. var appId = $(this).data('app-id');
  222. alert('确认清空统计数据吗?', function () {
  223. $.post('/index/ajax_profile/cleanStatistics', {appId: appId}, function (data) {
  224. if (data.code == 200) {
  225. window.location.reload();
  226. } else {
  227. alert(data.msg);
  228. }
  229. }, 'json')
  230. }, function () {
  231. }, 'center', '确定', '取消');
  232. });
  233. })
  234. </script>
  235. <?php
  236. $this->footer();
  237. ?> </body>
  238. </html>
  239. <?php
  240. }
  241. }