Num.php 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115
  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. $where['journal_id'] = $id;
  23. if ($uid > 0) {
  24. $where['uid'] = $uid;
  25. }
  26. $data = Dever::db('act/journal_num')->getAll($where);
  27. if ($data) {
  28. foreach ($data as $k => $v) {
  29. $user = Dever::load('passport/api')->info($v['uid']);
  30. $data[$k]['username'] = $user['username'];
  31. $data[$k]['avatar'] = $user['avatar'];
  32. $data[$k]['mobile'] = $user['mobile'];
  33. }
  34. }
  35. return $data;
  36. }
  37. public function submit($id, $uid = false, $num = false)
  38. {
  39. $where['uid'] = $uid;
  40. $where['journal_id'] = $id;
  41. $db = Dever::db($table);
  42. $info = $db->one($where);
  43. if (!$info) {
  44. $where['num'] = $num;
  45. $db->insert($where);
  46. } else {
  47. $where['where_id'] = $info['id'];
  48. $where['num'] = $info['num'] + $num;
  49. $db->update($where);
  50. }
  51. return true;
  52. }
  53. # 矫正数据用的,放到计划任务中
  54. public function cron()
  55. {
  56. return true;
  57. }
  58. /**
  59. * 导出成excel
  60. *
  61. * @return mixed
  62. */
  63. public function out_api()
  64. {
  65. $id = Dever::input('id');
  66. $journal = Dever::db('journal/info')->one($id);
  67. if (!$journal) {
  68. return;
  69. }
  70. $score = $this->getList($id);
  71. $header = $data = array();
  72. $name = $journal['name'];
  73. if ($score) {
  74. $i = 0;
  75. foreach ($score as $k => $v) {
  76. $data[$i] = array
  77. (
  78. $i+1,
  79. $v['username'],
  80. $v['mobile'],
  81. $v['num'],
  82. );
  83. $i++;
  84. }
  85. }
  86. $header = array
  87. (
  88. '排序', '用户名', '手机号', '本数'
  89. );
  90. $file = $name . '_排行榜';
  91. if (Dever::input('test')) {
  92. print_r($header);
  93. print_r($data);die;
  94. }
  95. Dever::excelExport($data, $header, $file, $sheet = 0, $sheetName = $name);
  96. return;
  97. }
  98. }