ArticleCategoryService.php 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. <?php
  2. namespace App\Services\Common;
  3. use App\Models\ActionLogModel;
  4. use App\Models\ArticleCateModel;
  5. use App\Services\BaseService;
  6. /**
  7. * 文章分类-服务类
  8. */
  9. class ArticleCategoryService extends BaseService
  10. {
  11. public function __construct()
  12. {
  13. $this->model = new ArticleCateModel();
  14. }
  15. public static function make()
  16. {
  17. if (!self::$instance) {
  18. self::$instance = (new static());
  19. }
  20. return self::$instance;
  21. }
  22. /**
  23. * 获取数据列表
  24. */
  25. public function getDataList($params, $pageSize = 15)
  26. {
  27. $query = $this->model->where('mark', 1);
  28. // 状态筛选
  29. if (isset($params['status']) && $params['status'] > 0) {
  30. $query->where('status', $params['status']);
  31. }
  32. // 关键词搜索
  33. if (isset($params['keyword']) && $params['keyword']) {
  34. $query->where('name', 'like', '%' . $params['keyword'] . '%');
  35. }
  36. // 上级分类筛选
  37. if (isset($params['pid']) && $params['pid']>0) {
  38. $query->where('pid', $params['pid']);
  39. }
  40. if (isset($params['type']) && $params['type']>0) {
  41. $query->where('type', $params['type']);
  42. }
  43. $list = $query->orderBy('sort', 'desc')
  44. ->orderBy('id', 'desc')
  45. ->paginate($pageSize);
  46. $list = $list ? $list->toArray() : [];
  47. if ($list && isset($list['data'])) {
  48. $typrArr = [
  49. 1=>'行业资讯中心',
  50. 2=>'行业政策专栏',
  51. 3=>'用户注册协议',
  52. 4=>'提现协议',
  53. 5=>'隐私协议',
  54. 9=>'关于我们'
  55. ];
  56. foreach ($list['data'] as &$item) {
  57. $item['create_time'] = $item['create_time'] ? date('Y-m-d H:i:s', strtotime($item['create_time'])) : '';
  58. $item['update_time'] = $item['update_time'] ? date('Y-m-d H:i:s', strtotime($item['update_time'])) : '';
  59. $item['type_name'] = isset($typrArr[$item['type']]) ? $typrArr[$item['type']] : '其他';
  60. }
  61. }
  62. return [
  63. 'msg' => '操作成功',
  64. 'code' => 0,
  65. 'data' => $list['data'] ?? [],
  66. 'count' => $list['total'] ?? 0,
  67. ];
  68. }
  69. /**
  70. * 添加或编辑
  71. */
  72. public function edit($data = [])
  73. {
  74. if (empty($data)) {
  75. $data = request()->all();
  76. }
  77. $data['update_time'] = time();
  78. if (empty($data['id'])) {
  79. $data['create_time'] = time();
  80. }
  81. ActionLogModel::setTitle("编辑文章分类");
  82. ActionLogModel::record();
  83. return parent::edit($data);
  84. }
  85. /**
  86. * 删除
  87. */
  88. public function delete()
  89. {
  90. $id = request()->post('id');
  91. if (!$id) {
  92. return ['code' => 1, 'msg' => '参数错误'];
  93. }
  94. // 支持批量删除
  95. if (is_array($id)) {
  96. $result = $this->model->whereIn('id', $id)->update(['mark' => 0]);
  97. } else {
  98. $result = $this->model->where('id', $id)->update(['mark' => 0]);
  99. }
  100. if ($result) {
  101. ActionLogModel::setTitle("删除文章分类");
  102. ActionLogModel::record();
  103. return ['code' => 0, 'msg' => '删除成功'];
  104. }
  105. return ['code' => 1, 'msg' => '删除失败'];
  106. }
  107. /**
  108. * 获取分类选项
  109. */
  110. public function options()
  111. {
  112. $type = request()->post('type',1);
  113. $list = $this->model->where(['type'=>$type,'status'=>1,'mark'=>1])
  114. ->orderBy('sort', 'desc')
  115. ->orderBy('id', 'asc')
  116. ->select(['id', 'name', 'pid'])
  117. ->get()
  118. ->toArray();
  119. return $list;
  120. }
  121. }