<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * App\Models\Ad
 *
 * @property int $id
 * @property string $theme 主题
 * @property string $alias 调用名
 * @property int $is_display 是否显示 (1:显示 0:不显示)
 * @property int $category_id 广告分类
 * @property int $type_id 广告属性
 * @property string $title 广告标题
 * @property string $note 备注
 * @property int $list_order 显示顺序
 * @property int $started_at 开始日期
 * @property int $ended_at 结束日期
 * @property string $content 文字广告内容或者其它类型的图片信息等
 * @property string $url 广告链接
 * @property string $text_color 文字颜色
 * @property int $subsite_id 分站信息(0:总站)
 * @property int $uid 会员UID
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property string|null $deleted_at
 * @property string|null $explain 图片文字说明
 * @property-read \App\Models\AdCategory $show_category
 * @method static bool|null forceDelete()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad newQuery()
 * @method static \Illuminate\Database\Query\Builder|\App\Models\Ad onlyTrashed()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad query()
 * @method static bool|null restore()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereAlias($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereCategoryId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereContent($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereDeletedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereEndedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereExplain($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereIsDisplay($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereListOrder($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereNote($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereStartedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereSubsiteId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereTextColor($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereTheme($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereTitle($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereTypeId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereUid($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereUpdatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Ad whereUrl($value)
 * @method static \Illuminate\Database\Query\Builder|\App\Models\Ad withTrashed()
 * @method static \Illuminate\Database\Query\Builder|\App\Models\Ad withoutTrashed()
 * @mixin \Eloquent
 */
class Ad extends Model
{
    use SoftDeletes;
    protected $guarded = [''];
    public function getStartedAtAttribute($value)
    {
        if ($value>0) {
            return date('Y-m-d', $value);
        } else {
            return '';
        }
    }
    public function getEndedAtAttribute($value)
    {
        if ($value>0) {
            return date('Y-m-d', $value);
        } else {
            return '';
        }
    }
    public function show_category()
    {
        return $this->belongsTo(AdCategory::class, 'category_id');
    }
    public function subsites()
    {
        return $this->hasMany(SubsiteAd::class, 'ad_id');
    }
}