config-service/app/Repositories/BannerRepository.php

<?php
namespace App\Repositories;
use App\Models\Banner;
use Illuminate\Support\Facades\DB;

/**
 * Created by PhpStorm.
 * User: durong
 * Date: 2019/6/15
 * Time: 下午5:39
 */

class BannerRepository
{
    public function __construct(Banner $banner)
    {
        $this->banner = $banner;
    }

    public function bannerData($request)
    {
        $ids = explode(",", $request['ids']);
        $where = [];
        $where[] = ['is_open', 1];
        $where[] = ['use_background', 1];
        return $this->banner
            ->select('image', 'type', 'link_content_id')
            ->where($where)
            ->whereIn('id', $ids)
            ->orderByRaw(DB::raw("FIELD(id,{$ids})"))
            ->get();
    }

}