<?php

namespace App\Modes;

use Carbon\Carbon;
use Illuminate\Database\Eloquent\Model;


/**
 * App\Modes\AdverActivity
 *
 * @property int $id
 * @property int $free_num 免费次数
 * @property string $start_time 活动开始时间
 * @property string|null $end_time 活动结束时间
 * @property \Illuminate\Support\Carbon $created_at
 * @property \Illuminate\Support\Carbon $updated_at
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity query()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity whereEndTime($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity whereFreeNum($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity whereStartTime($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\AdverActivity whereUpdatedAt($value)
 * @mixin \Eloquent
 */
class AdverActivity extends Model
{
    protected $table = 'adver_activity';

    /**
     * 获取当前活动id
     * @author lyh
     * @date 2019/4/22
     * @return mixed
     * @description
     */
    public static function getCurrentActivityId()
    {
        $now = Carbon::now();
        $activity = AdverActivity::where('start_time', '<', $now)->where('end_time', '>', $now)->orderBy('created_at','desc')->first();
        return $activity->id ?? 0;
    }
}