neiyou_user_web/app/Models/Goods.php

<?php

namespace App\Models;

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

/**
 * 商品
 *
 * @property int $id
 * @property string $name 商品名称
 * @property string|null $logo 商品图片地址
 * @property int $traffic 商品内含多少流量，单位MiB
 * @property int $type 商品类型：1-流量包、2-套餐
 * @property int $price 售价，单位分
 * @property int $level 购买后给用户授权的等级
 * @property int|null $renew 流量重置价格，单位分
 * @property int|null $period 流量自动重置周期
 * @property string|null $info 商品信息
 * @property string|null $description 商品描述
 * @property int $days 有效期
 * @property int|null $invite_num 赠送邀请码数
 * @property int|null $limit_num 限购数量，默认为null不限购
 * @property string $color 商品颜色
 * @property int $sort 排序
 * @property int $is_hot 是否热销：0-否、1-是
 * @property int $status 状态：0-下架、1-上架
 * @property \Illuminate\Support\Carbon $created_at 创建时间
 * @property \Illuminate\Support\Carbon $updated_at 最后更新时间
 * @property \Illuminate\Support\Carbon|null $deleted_at 删除时间
 * @property-read mixed $traffic_label
 * @method static \Illuminate\Database\Eloquent\Builder|Goods newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|Goods newQuery()
 * @method static \Illuminate\Database\Query\Builder|Goods onlyTrashed()
 * @method static \Illuminate\Database\Eloquent\Builder|Goods query()
 * @method static \Illuminate\Database\Eloquent\Builder|Goods type($type)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereColor($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereDays($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereDeletedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereDescription($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereInfo($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereInviteNum($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereIsHot($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereLevel($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereLimitNum($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereLogo($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods wherePeriod($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods wherePrice($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereRenew($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereSort($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereStatus($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereTraffic($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereType($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Goods whereUpdatedAt($value)
 * @method static \Illuminate\Database\Query\Builder|Goods withTrashed()
 * @method static \Illuminate\Database\Query\Builder|Goods withoutTrashed()
 * @mixin \Eloquent
 */
class Goods extends Model
{
    use SoftDeletes;

    protected $table = 'goods';
    protected $dates = ['deleted_at'];
    protected $guarded = [];

    public function scopeType($query, $type)
    {
        return $query->whereType($type)->whereStatus(1)->orderByDesc('sort');
    }

    public function getPriceAttribute($value)
    {
        return $value / 100;
    }

    public function setPriceAttribute($value)
    {
        $this->attributes['price'] = $value * 100;
    }

    public function getRenewAttribute($value)
    {
        return $value / 100;
    }

    public function setRenewAttribute($value)
    {
        $this->attributes['renew'] = $value * 100;
    }

    public function getTrafficLabelAttribute()
    {
        return flowAutoShow($this->attributes['traffic'] * MB);
    }
}