config-manage/app/Repositories/MessageRuleRepository.php

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/6/12
 * Time: 9:13
 */

namespace App\Repositories;

use App\Models\MessageRule;
use Illuminate\Database\QueryException;
use Dingo\Api\Http\Response;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Redis;
use Symfony\Component\HttpKernel\Exception\HttpException;
use Tymon\JWTAuth\Facades\JWTAuth;

class MessageRuleRepository
{
    public function __construct(MessageRule $messageRule)
    {
        $this->messageRule = $messageRule;
    }

    /**
     * 内容列表
     */
    public function lists($request)
    {
        $perPage = isset($request['per_page']) ? $request['per_page'] : 20;
        $where = [];
        if(isset($request['title'])){
            $where[] = ['title', 'like', "%{$request['title']}%"];
        }
        if(isset($request['message_type'])){
            $where[] = ['message_type', $request['message_type']];
        }
        return $this->messageRule
            ->where($where)
            ->orderBy('id','desc')
            ->paginate($perPage);
    }
}