<?php

namespace App\Models;

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

/**
 * 商品
 *
 * @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                             $renew       流量重置价格，单位分
 * @property int|null                        $period      流量自动重置周期
 * @property string|null                     $info        商品信息
 * @property string|null                     $description 商品描述
 * @property int                             $days        有效期
 * @property int                             $invite_num  赠送邀请码数
 * @property int                             $limit_num   限购数量，默认为0不限购
 * @property string                          $color       商品颜色
 * @property int                             $sort        排序
 * @property int                             $is_hot      是否热销：0-否、1-是
 * @property int                             $status      状态：0-下架、1-上架
 * @property \Illuminate\Support\Carbon|null $created_at  创建时间
 * @property \Illuminate\Support\Carbon|null $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 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 Builder|Goods withTrashed()
 * @method static Builder|Goods withoutTrashed()
 * @mixin \Eloquent
 */
class Goods extends Model {
	use SoftDeletes;

	protected $table = 'goods';
	protected $primaryKey = 'id';
	protected $dates = ['deleted_at'];

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

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

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

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

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

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