ArticleService.php 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 LARAVEL研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: laravel开发员 <laravel.qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services\Common;
  12. use App\Models\ActionLogModel;
  13. use App\Models\ArticleModel;
  14. use App\Services\BaseService;
  15. /**
  16. * 文章管理-服务类
  17. * @author laravel开发员
  18. * @since 2020/11/11
  19. * Class ArticleService
  20. * @package App\Services\Common
  21. */
  22. class ArticleService extends BaseService
  23. {
  24. /**
  25. * 构造函数
  26. * @author laravel开发员
  27. * @since 2020/11/11
  28. * ArticleService constructor.
  29. */
  30. public function __construct()
  31. {
  32. $this->model = new ArticleModel();
  33. }
  34. /**
  35. * 静态入口
  36. * @return static|null
  37. */
  38. public static function make()
  39. {
  40. if (!self::$instance) {
  41. self::$instance = (new static());
  42. }
  43. return self::$instance;
  44. }
  45. /**
  46. * @param $params
  47. * @param int $pageSize
  48. * @return array
  49. */
  50. public function getDataList($params, $pageSize = 15)
  51. {
  52. $where = ['a.mark' => 1];
  53. $status = isset($params['status']) ? $params['status'] : 0;
  54. $type = isset($params['type']) ? $params['type'] : 0;
  55. $cateId = isset($params['cate_id']) ? $params['cate_id'] : 0;
  56. if ($status > 0) {
  57. $where['a.status'] = $status;
  58. }
  59. if ($cateId > 0) {
  60. $where['a.cate_id'] = $cateId;
  61. }
  62. $list = $this->model->with(['category'])->from('article as a')
  63. ->where($where)
  64. ->where(function ($query) use ($type) {
  65. if ($type>0) {
  66. $query->where('a.type', $type);
  67. } else if ($type<0) {
  68. $query->whereIn('a.type', [1,2]);
  69. } else {
  70. $query->where('a.type','>=',3)->whereNotIn('a.type',[9]);
  71. }
  72. })
  73. ->where(function ($query) use ($params) {
  74. $keyword = isset($params['keyword']) ? $params['keyword'] : '';
  75. if ($keyword) {
  76. $query->where('a.title', 'like', "%{$keyword}%")->orWhere('a.tags', 'like', "%{$keyword}%");
  77. }
  78. })
  79. ->select(['a.*'])
  80. ->orderBy('a.sort', 'desc')
  81. ->orderBy('a.publish_at', 'desc')
  82. ->orderBy('a.id', 'desc')
  83. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  84. $list = $list ? $list->toArray() : [];
  85. if ($list) {
  86. $typrArr = [
  87. 1=>'行业资讯中心',
  88. 2=>'行业政策专栏',
  89. 3=>'用户注册协议',
  90. 4=>'提现协议',
  91. 5=>'隐私协议',
  92. 9=>'关于我们',
  93. 10=>'营业执照'
  94. ];
  95. foreach ($list['data'] as &$item) {
  96. $item['create_time'] = $item['publish_at'] ? datetime($item['publish_at']) : datetime($item['create_time']);
  97. $item['publish_at'] = $item['publish_at'] ? datetime($item['publish_at']) : datetime($item['create_time']);
  98. $item['cover'] = $item['cover'] ? get_image_url($item['cover']) : '';
  99. $item['content'] = $item['content'] ? ($item['content_type']==2? json_decode(format_content($item['content']),true):get_format_content($item['content'])) : '';
  100. $item['type_name'] = isset($typrArr[$item['type']]) ? $typrArr[$item['type']] : '其他';
  101. }
  102. }
  103. return [
  104. 'pageSize' => $pageSize,
  105. 'total' => isset($list['total']) ? $list['total'] : 0,
  106. 'list' => isset($list['data']) ? $list['data'] : []
  107. ];
  108. }
  109. /**
  110. * 添加或编辑
  111. * @return array
  112. * @since 2020/11/11
  113. * @author laravel开发员
  114. */
  115. public function edit()
  116. {
  117. $data = request()->all();
  118. $content = isset($data['content']) ? $data['content'] : '';
  119. if ($content) {
  120. $data['content'] = $data['content_type'] == 2? set_format_content(json_encode($data['content'], 256)) : set_format_content($content);
  121. } else {
  122. // 确保content字段存在(即使为空字符串)
  123. $data['content'] = '';
  124. }
  125. $data['author'] = isset($data['author']) && $data['author']?$data['author'] : \App\Services\ConfigService::make()->getConfigByCode('app_name');
  126. $data['cover'] = $data['cover']? get_image_path($data['cover']) : '';
  127. $data['publish_at'] = !empty($data['publish_at'])? datetime($data['publish_at']) : date('Y-m-d H:i:s');
  128. // 设置日志标题
  129. ActionLogModel::setTitle("编辑文章信息");
  130. ActionLogModel::record();
  131. return parent::edit($data); // TODO: Change the autogenerated stub
  132. }
  133. /**
  134. * 删除
  135. * @return array
  136. */
  137. public function delete()
  138. {
  139. $id = request()->post('id');
  140. if (!$id) {
  141. return ['code' => 1, 'msg' => '参数错误'];
  142. }
  143. // 支持批量删除
  144. if (is_array($id)) {
  145. $result = $this->model->whereIn('id', $id)->update(['mark' => 0]);
  146. } else {
  147. $result = $this->model->where('id', $id)->update(['mark' => 0]);
  148. }
  149. if ($result) {
  150. // 设置日志标题
  151. ActionLogModel::setTitle("删除文章内容");
  152. ActionLogModel::record();
  153. return ['code' => 0, 'msg' => '删除成功'];
  154. }
  155. return ['code' => 1, 'msg' => '删除失败'];
  156. }
  157. }