Num.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. <?php
  2. namespace Act\Lib;
  3. use Dever;
  4. class Num
  5. {
  6. # 获取我在这个小刊中的本数
  7. public function get($id, $uid)
  8. {
  9. $where['uid'] = $uid;
  10. $where['journal_id'] = $id;
  11. $where['state'] = 1;
  12. $data = Dever::db('act/journal_num')->one($where);
  13. if ($data) {
  14. return $data['num'];
  15. } else {
  16. return 0;
  17. }
  18. }
  19. # 获取小刊的积分排行
  20. public function getList($id, $uid = false)
  21. {
  22. $key = 'journal_num_' . $id;
  23. $data = Dever::cache($key);
  24. if (!$data) {
  25. $where['journal_id'] = $id;
  26. if ($uid > 0) {
  27. $where['uid'] = $uid;
  28. }
  29. $data = Dever::db('act/journal_num')->getAll($where);
  30. if ($data) {
  31. foreach ($data as $k => $v) {
  32. $user = Dever::load('passport/api')->info($v['uid']);
  33. $data[$k]['username'] = $user['username'];
  34. $data[$k]['avatar'] = $user['avatar'];
  35. $data[$k]['mobile'] = $user['mobile'];
  36. }
  37. Dever::cache($key, $data, 600);
  38. }
  39. }
  40. return $data;
  41. }
  42. public function submit($id, $uid = false, $num = false, $update = true)
  43. {
  44. $where['uid'] = $uid;
  45. $where['journal_id'] = $id;
  46. $table = 'act/journal_num';
  47. $db = Dever::db($table);
  48. $info = $db->one($where);
  49. if (!$info) {
  50. $where['num'] = $num;
  51. $db->insert($where);
  52. } else {
  53. if ($update) {
  54. $where['where_id'] = $info['id'];
  55. $where['num'] = $info['num'] + $num;
  56. $db->update($where);
  57. }
  58. }
  59. return true;
  60. }
  61. # 矫正数据用的,放到计划任务中
  62. public function cron()
  63. {
  64. return true;
  65. }
  66. # 订阅数计数器
  67. public function setCounter($id, $num = 0)
  68. {
  69. $key = 'journal_buy_num2_' . $id;
  70. $callback = function() use($id) {
  71. $journal = Dever::db('journal/info')->one($id);
  72. return $journal['num_ding'];
  73. };
  74. Dever::counter($key, $num, $callback);
  75. return true;
  76. }
  77. # 订阅数计数器
  78. public function getCounter($id)
  79. {
  80. $key = 'journal_buy_num2_' . $id;
  81. return Dever::counter($key);
  82. }
  83. /**
  84. * 导出成excel
  85. *
  86. * @return mixed
  87. */
  88. public function out_api()
  89. {
  90. $id = Dever::input('id');
  91. $journal = Dever::db('journal/info')->one($id);
  92. if (!$journal) {
  93. return;
  94. }
  95. $score = $this->getList($id);
  96. $header = $data = array();
  97. $name = $journal['name'];
  98. if ($score) {
  99. $i = 0;
  100. foreach ($score as $k => $v) {
  101. $data[$i] = array
  102. (
  103. $i+1,
  104. $v['username'],
  105. $v['mobile'],
  106. $v['num'],
  107. );
  108. $i++;
  109. }
  110. }
  111. $header = array
  112. (
  113. '排序', '用户名', '手机号', '本数'
  114. );
  115. $file = $name . '_排行榜';
  116. if (Dever::input('test')) {
  117. print_r($header);
  118. print_r($data);die;
  119. }
  120. Dever::excelExport($data, $header, $file, $sheet = 0, $sheetName = $name);
  121. return;
  122. }
  123. }