DynamicCommentService.php 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  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\MemberModel;
  14. /**
  15. * 动态评论管理-服务类
  16. * @author wesmiler
  17. * @since 2020/11/11
  18. * Class DynamicCommentService
  19. * @package App\Services
  20. */
  21. class DynamicCommentService extends BaseService
  22. {
  23. protected static $instance = null;
  24. /**
  25. * 构造函数
  26. * @author wesmiler
  27. * @since 2020/11/11
  28. * DynamicCommentService constructor.
  29. */
  30. public function __construct()
  31. {
  32. $this->model = new DynamicCommentModel();
  33. }
  34. /**
  35. * 静态入口
  36. * @return DynamicService|null
  37. */
  38. public static function make(){
  39. if(!self::$instance){
  40. self::$instance = new DynamicService();
  41. }
  42. return self::$instance;
  43. }
  44. /**
  45. * 获取列表
  46. * @return array
  47. * @since 2020/11/11
  48. * @author wesmiler
  49. */
  50. public function getList()
  51. {
  52. $params = request()->all();
  53. return parent::getList();
  54. }
  55. /**
  56. * 获取列表
  57. * @return array
  58. * @since 2020/11/11
  59. * @author wesmiler
  60. */
  61. public function getDataList($params)
  62. {
  63. $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
  64. $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
  65. $dataList = $this->model::from('dynamic_comment as a')
  66. ->leftJoin('member as m', 'm.id', '=', 'a.user_id')
  67. ->where(['a.mark'=>1,'a.status'=> 1,'m.mark'=> 1,'m.status'=> 1])
  68. ->where('m.user_id','>',0)
  69. ->select(['a.id', 'a.user_id', 'm.nickname','m.avatar', 'a.source_id', 'a.content', 'a.status', 'a.create_time', 'a.update_time'])
  70. ->orderBy('a.create_time', 'desc')
  71. ->paginate($pageSize);
  72. $dataList = $dataList ? $dataList->toArray() : [];
  73. if ($dataList) {
  74. foreach ($dataList['data'] as &$item) {
  75. $item['avatar'] = $item['avatar'] ? get_image_url($item['avatar']) : '';
  76. $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : '';
  77. }
  78. unset($item);
  79. }
  80. return [
  81. 'code' => 0,
  82. 'success'=> true,
  83. 'msg' => '操作成功',
  84. 'count' => isset($dataList['total']) ? $dataList['total'] : 0,
  85. 'data' => isset($dataList['data']) ? $dataList['data'] : 0,
  86. ];
  87. }
  88. /**
  89. * 添加或编辑
  90. * @return array
  91. * @since 2020/11/11
  92. * @author wesmiler
  93. */
  94. public function edit()
  95. {
  96. $data = request()->all();
  97. $data['update_time'] = time();
  98. return parent::edit($data); // TODO: Change the autogenerated stub
  99. }
  100. }