ArticleCategoryService.php 3.8 KB

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