publish_superlog.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244
  1. <?php
  2. // by 请勿倒卖,已申请软著,否则追究法律责任
  3. namespace app\index;
  4. class publish_superlog 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 = "create_time>'" . strtotime($starttime) . "' and create_time<'" . strtotime($endtime) . "' ";
  19. }
  20. $total = db('super_sign')->where($specified)->where('app_id', $id)->count();
  21. $complateCount = db('super_sign')->where($specified)->where('status', '5')->where('app_id', $id)->count();
  22. $num = 10;
  23. $cpage = isset($_GET['page']) ? $_GET['page'] : 1;
  24. $pagenum = ceil($total / $num);
  25. $offset = ($cpage - 1) * $num;
  26. $result = db('super_sign')->where($specified)->where('app_id', $id)->order('sign_time desc')->limit($offset, $num)->select();
  27. $start = $offset + 1;
  28. $end = $cpage == $pagenum ? $total : $cpage * $num;
  29. $next = $cpage == $pagenum ? 0 : $cpage + 1;
  30. $prev = $cpage == 1 ? 0 : $cpage - 1;
  31. ?> <!DOCTYPE html>
  32. <html lang="">
  33. <head>
  34. <meta charset="utf-8">
  35. <meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=0"/>
  36. <meta name="keywords" content="<?php echo IN_KEYWORDS;?>"/>
  37. <meta name="description" content="<?php echo IN_DESCRIPTION;?>"/>
  38. <title><?php echo $row['in_name'];?>应用详情 - <?php echo IN_NAME;?></title>
  39. <?php
  40. $this->static_();
  41. ?> </head>
  42. <body>
  43. <?php
  44. $this->header();
  45. ?> <link rel="stylesheet" href="/static/pack/font-awesome-4.7.0/css/font-awesome.css"/>
  46. <link rel="stylesheet" type="text/css" href="/static/index/css/jquery.datetimepicker.css?20190530"/>
  47. <script src="/static/index/js/jquery.datetimepicker.js?20190530"></script>
  48. <script src="/static/index/js/bootstrap-paginator.js"></script>
  49. <div class="release-app-wrap">
  50. <div class="container">
  51. <div class="release-app2">
  52. <div class="crumbs">
  53. <a href="/index/apps/apps">我的应用</a>
  54. <span>/</span>
  55. <a href="/index/apps/apps">应用列表</a>
  56. <span>/</span>
  57. <?php echo $row['in_name'];?> </div>
  58. <div class="row clearfix">
  59. <?php
  60. $this->publish_left();
  61. ?> <div class="col-sm-10">
  62. <div class="aside-right">
  63. <div class="app-details app-details2">
  64. <?php
  65. $this->publish_top($row);
  66. ?> <hr>
  67. <div class="download-details">
  68. <div class="d-top clearfix">
  69. <div class="date date1">
  70. <input class="form-control" type="text" id="datetimepicker1"
  71. value="<?php
  72. if (empty($start_date)) {
  73. ?><?php echo date("Y/m/d", strtotime(date("Y/m/d") . '-1 week'));?><?php
  74. } else {
  75. ?><?php echo $start_date;?><?php
  76. }
  77. ?>">
  78. <span class="iconfont icon-date"></span>
  79. </div>
  80. <div class="fl line">
  81. _
  82. </div>
  83. <div class="date date2">
  84. <input class="form-control" type="text" id="datetimepicker2"
  85. value="<?php
  86. if (empty($end_date)) {
  87. ?><?php echo date("Y/m/d");?><?php
  88. } else {
  89. ?><?php echo $end_date;?><?php
  90. }
  91. ?>">
  92. <span class="iconfont icon-date"></span>
  93. </div>
  94. <button type="button" class="ms-btn ms-btn-secondary fl query">查询</button>
  95. <span class="fl num">累计签名 <i><?php echo $total;?></i> 次,签名完成 <i><?php echo $complateCount;?></i> 次</span>
  96. <button type="button" class="ms-btn ms-btn-secondary fr cleanUp"
  97. data-app-id="
  98. <?php echo $row['in_id'];?>">删除过期签名包
  99. </button>
  100. </div>
  101. <div class="table-responsive">
  102. <table class="table">
  103. <tr>
  104. <th>
  105. 时间
  106. </th>
  107. <th>
  108. 应用
  109. </th>
  110. <th>
  111. 证书
  112. </th>
  113. <th>
  114. udid
  115. </th>
  116. <th>
  117. 类型
  118. </th>
  119. <th>
  120. 状态
  121. </th>
  122. </tr>
  123. <?php
  124. foreach ($result as $key => $value) {
  125. ?> <tr>
  126. <td>
  127. <?php echo date('Y-m-d H:i', $value['sign_time']);?> </td>
  128. <td>
  129. <?php echo $value['app_name'];?><br><?php echo $value['app_version'];?> </td>
  130. <td>
  131. <?php echo substr_replace($value['cert_iss'], '******', 10, 16);?> </td>
  132. <td>
  133. <?php echo $value['udid'];?> </td>
  134. <td>
  135. <?php echo $value['type'] ? '首次' : '重复下载';?> </td>
  136. <td value="<?php echo $value['status'];?>">
  137. <?php echo $value['status'] == 5 ? '签名完成' : ($value['status'] < 0 ? '签名失败' : '正在签名');?> </td>
  138. </tr>
  139. <?php
  140. }
  141. ?> </table>
  142. <?php
  143. if ($total == 0) {
  144. ?> <div class="text-center no-content">
  145. <img src="/static/index/image/invoice-1.png" alt="">
  146. <p class="color-333 mt10">
  147. 暂无任何数据
  148. </p>
  149. </div>
  150. <?php
  151. }
  152. ?> </div>
  153. <?php
  154. if ($pagenum != 1) {
  155. ?> <?php
  156. if ($total !== 0) {
  157. ?> <?php
  158. if (empty($start_date)) {
  159. ?> <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
  160. if ($cpage == 1) {
  161. ?><li class='active'><a>首页</a></li><?php
  162. } else {
  163. ?><li><a href='?page=1&id=<?php echo $sid;?>'>首页</a></li><?php
  164. }
  165. if ($prev) {
  166. ?><li><a href='?page=<?php echo $prev;?>&id=<?php echo $sid;?>'>上一页</a></li><?php
  167. } else {
  168. }
  169. if ($next) {
  170. ?><li><a href='?page=<?php echo $next;?>&id=<?php echo $sid;?>'>下一页</a></li><?php
  171. } else {
  172. }
  173. if ($cpage == $pagenum) {
  174. ?><li class='active'><a>尾页</a></li><?php
  175. } else {
  176. ?><li><a href='?page=<?php echo $pagenum;?>&id=<?php echo $sid;?>'>尾页</a></li><?php
  177. }
  178. ?></ul></div> <?php
  179. } else {
  180. ?> <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
  181. if ($cpage == 1) {
  182. ?><li class='active'><a>首页</a></li><?php
  183. } else {
  184. ?><li><a href='?page=1&id=<?php echo $sid;?>&start_date=<?php echo $start_date;?>&end_date=<?php echo $end_date;?>'>首页</a></li><?php
  185. }
  186. if ($prev) {
  187. ?><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
  188. } else {
  189. }
  190. if ($next) {
  191. ?><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
  192. } else {
  193. }
  194. if ($cpage == $pagenum) {
  195. ?><li class='active'><a>尾页</a></li><?php
  196. } else {
  197. ?><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
  198. }
  199. ?></ul></div> <?php
  200. }
  201. ?> <?php
  202. }
  203. ?> <?php
  204. }
  205. ?> </div>
  206. </div>
  207. </div>
  208. </div>
  209. </div>
  210. </div>
  211. </div>
  212. </div>
  213. <?php
  214. $this->inc_merge();
  215. ?> <script>
  216. $(function () {
  217. $(".download-details div:first").on('click', '.query', function () {
  218. var start_date = $(this).parent().find("input:first").val();
  219. var end_date = $(this).parent().find("input:last").val();
  220. window.location.href = "/index/publish_superlog/super?id=<?php echo bees_encrypt($row['in_id']);?>&start_date=" + start_date + "&end_date=" + end_date + "&page=1";
  221. });
  222. $(".download-details div:first").on('click', '.cleanUp', function () {
  223. var app_id = $(this).data('app-id');
  224. alert('确认删除过期签名包吗?', function () {
  225. $.post('/index/super_sign/clear_sign_ipa', {app_id: app_id}, function (data) {
  226. if (data.msg) {
  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. }