NN2026041501/app/Services/Common/ComplaintService.php

<?php
namespace App\Services\Common;

use App\Models\ComplaintModel;
use App\Models\ActionLogModel;
use App\Services\BaseService;
use Carbon\Carbon;
use Illuminate\Support\Facades\DB;

class ComplaintService extends BaseService
{
    public function __construct()
    {
        $this->model = new ComplaintModel();
    }

    public static function make()
    {
        if (!self::$instance) {
            self::$instance = (new static());
        }
        return self::$instance;
    }
    public function getDataList($params, $pageSize = 15)
    {
        $query = $this->model->from('complaint as c')
            ->leftJoin('member as m', 'c.user_id', '=', 'm.id')
            ->where('c.mark', 1);

        // 类型筛选
        if (!empty($params['type'])) {
            $query->where('c.type', $params['type']);
        }

        // 状态筛选
        if (!empty($params['status'])) {
            $query->where('c.status', $params['status']);
        }

        // 标题搜索
        if (!empty($params['title'])) {
            $query->where('c.title', 'like', "%{$params['title']}%");
        }

        // 用户姓名搜索 (realname 或 nickname)
        if (!empty($params['user_name'])) {
            $query->where(function ($q) use ($params) {
                $q->where('m.realname', 'like', "%{$params['user_name']}%")
                    ->orWhere('m.nickname', 'like', "%{$params['user_name']}%");
            });
        }

        $list = $query->select([
            'c.*',
            DB::raw('COALESCE(lev_m.realname, lev_m.nickname) as user_name')
        ])
            ->orderBy('c.create_time', 'desc')
            ->paginate($pageSize > 0 ? $pageSize : 9999999)
            ->toArray();

        // 格式化时间
        if (!empty($list['data'])) {
            foreach ($list['data'] as &$item) {
                $item['create_time'] = !empty($item['create_time'])
                    ? Carbon::parse($item['create_time'])->timezone('Asia/Shanghai')->format('Y-m-d H:i:s')
                    : '';
                $typeArr = [1 => '功能BUG', 2 => '题库问题', 3 => '产品问题', 4 => 'VIP问题', 5 => '费用相关', 99 => '其他'];
                $item['type_name'] = $typeArr[$item['type']] ?? '其他';
            }
        }

        return [
            'pageSize' => $pageSize,
            'total' => $list['total'] ?? 0,
            'list' => $list['data'] ?? []
        ];
    }

    /**
     * 添加或编辑
     */
    public function edit()
    {
        $data = request()->all();

        if (!empty($data['content'])) {
            $data['content'] = set_format_content($data['content']); // 可自定义处理
        }

        $data['update_time'] = time();
        if (empty($data['id'])) {
            $data['create_time'] = time();
        }

        // 设置日志标题
        ActionLogModel::setTitle("发布或编辑投诉建议");
        ActionLogModel::record();

        return parent::edit($data);
    }

    /**
     * 删除七天之前标记软删除的数据
     */
    public function delete()
    {
        // 设置日志标题
        ActionLogModel::setRecord(session('userId'), ['type' => 1, 'title' => "删除投诉建议信息", 'content' => json_encode(request()->post(), 256), 'module' => 'admin']);
        ActionLogModel::record();
        $this->model->where('mark', 0)->where('update_time', '<=', time() - 7 * 86400)->delete();
        return parent::delete();
    }
}