DynamicCommentService.php 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | Laravel框架 [ Laravel ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 Laravel研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: wesmiler <12345678@qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services;
  12. use App\Models\DynamicCommentModel;
  13. use App\Models\DynamicModel;
  14. use App\Models\MemberModel;
  15. /**
  16. * 动态评论管理-服务类
  17. * @author wesmiler
  18. * @since 2020/11/11
  19. * Class DynamicCommentService
  20. * @package App\Services
  21. */
  22. class DynamicCommentService extends BaseService
  23. {
  24. protected static $instance = null;
  25. /**
  26. * 构造函数
  27. * @author wesmiler
  28. * @since 2020/11/11
  29. * DynamicCommentService constructor.
  30. */
  31. public function __construct()
  32. {
  33. $this->model = new DynamicCommentModel();
  34. }
  35. /**
  36. * 静态入口
  37. * @return DynamicService|null
  38. */
  39. public static function make(){
  40. if(!self::$instance){
  41. self::$instance = new DynamicService();
  42. }
  43. return self::$instance;
  44. }
  45. /**
  46. * 获取列表
  47. * @return array
  48. * @since 2020/11/11
  49. * @author wesmiler
  50. */
  51. public function getList()
  52. {
  53. $params = request()->all();
  54. return parent::getList();
  55. }
  56. /**
  57. * 获取列表
  58. * @return array
  59. * @since 2020/11/11
  60. * @author wesmiler
  61. */
  62. public function getDataList($params)
  63. {
  64. $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
  65. $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
  66. $where = ['a.mark'=>1,'a.status'=> 1,'m.mark'=> 1,'m.status'=> 1];
  67. $sourceId = isset($params['source_id'])? $params['source_id'] : 0;
  68. if($sourceId){
  69. $where['a.source_id'] = $sourceId;
  70. }
  71. $dataList = $this->model::from('dynamic_comment as a')
  72. ->leftJoin('member as m', 'm.id', '=', 'a.user_id')
  73. ->where($where)
  74. ->where('m.id','>',0)
  75. ->select(['a.id', 'a.user_id', 'm.nickname','m.avatar', 'a.source_id', 'a.content', 'a.status', 'a.create_time', 'a.update_time'])
  76. ->orderBy('a.create_time', 'desc')
  77. ->paginate($pageSize);
  78. $dataList = $dataList ? $dataList->toArray() : [];
  79. if ($dataList) {
  80. foreach ($dataList['data'] as &$item) {
  81. $item['avatar'] = $item['avatar'] ? get_image_url($item['avatar']) : '';
  82. $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : '';
  83. $item['create_time_text'] = $item['create_time'] ? format_time(strtotime($item['create_time'])) : '';
  84. }
  85. unset($item);
  86. }
  87. return [
  88. 'code' => 0,
  89. 'success'=> true,
  90. 'msg' => '操作成功',
  91. 'count' => isset($dataList['total']) ? $dataList['total'] : 0,
  92. 'data' => isset($dataList['data']) ? $dataList['data'] : 0,
  93. ];
  94. }
  95. /**
  96. * 添加或编辑
  97. * @return array
  98. * @since 2020/11/11
  99. * @author wesmiler
  100. */
  101. public function edit()
  102. {
  103. $data = request()->all();
  104. $data['update_time'] = time();
  105. return parent::edit($data); // TODO: Change the autogenerated stub
  106. }
  107. /**
  108. * 发布评论
  109. * @param $userId
  110. * @return array
  111. */
  112. public function comment($userId){
  113. $params = request()->all();
  114. $id = isset($params['id'])? $params['id'] : 0;
  115. $cacheKey = "caches:comments:dynamic_{$userId}";
  116. if(RedisService::get($cacheKey)){
  117. return message('您刚刚评论过,请30秒后再试', false);
  118. }
  119. // 验证信息
  120. $info = DynamicModel::where(['id'=> $id, 'mark'=>1, 'status'=>1])
  121. ->select(['id','comment_close','status'])
  122. ->first();
  123. if(!$info){
  124. return message('评论的动态不存在,请刷新重试', false);
  125. }
  126. if($info->comment_close == 2){
  127. return message('该动态未开放评论功能', false);
  128. }
  129. // 验证账户
  130. $memberInfo = MemberModel::where(['id'=> $userId,'mark'=> 1,'status'=> 1])
  131. ->select(['id','openid','nickname'])
  132. ->first();
  133. if(!$memberInfo){
  134. return message('账户不可操作或已冻结,请联系客服', false);
  135. }
  136. $data = [
  137. 'user_id'=> $userId,
  138. 'source_id'=> $id,
  139. 'reply_id'=> isset($params['reply_id'])? intval($params['reply_id']) : 0,
  140. 'content'=> isset($params['content'])? trim($params['content']) : '',
  141. 'create_time'=> time(),
  142. 'update_time'=> time(),
  143. 'status'=> 1,
  144. ];
  145. if($this->model::insertGetId($data)){
  146. RedisService::set($cacheKey, $data, 30);
  147. return message('评论成功', true);
  148. }
  149. return message('评论失败', false);
  150. }
  151. }