bike-api/app/Repositories/AdvertisementRepository.php

<?php

namespace App\Repositories;

use App\Models\Advertisement;
use Carbon\Carbon;

class AdvertisementRepository extends BaseRepository
{
    public function __construct(Advertisement $model)
    {
        $this->model = $model;
    }

    /**
     * 根据区域和位置获取广告
     * @param $position
     * @param $area_id
     * @return mixed
     * Author: Mead
     */
    public function byPositionIdGetActive($position, $area_id)
    {
        $now = Carbon::now()->toDateTimeString();
        $area_ids = array_unique([0, $area_id]);
        return $this->model->whereIn('area_id', $area_ids)->whereIn('advertisement_position_slug', $position)->where('start_time', '<=', $now)->where('end_time', '>', $now)->where('is_display', Advertisement::DISPLAY_OK)->orderBy('sort', 'desc')->get();
    }
}