Goods.php 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. <?php
  2. namespace App\Http\Models;
  3. use Eloquent;
  4. use Illuminate\Database\Eloquent\Collection;
  5. use Illuminate\Database\Eloquent\Model;
  6. use Illuminate\Database\Eloquent\SoftDeletes;
  7. use Illuminate\Database\Query\Builder;
  8. use Illuminate\Support\Carbon;
  9. /**
  10. * 商品
  11. * Class Goods
  12. *
  13. * @package App\Http\Models
  14. * @mixin Eloquent
  15. * @property int $id
  16. * @property string $sku 商品服务SKU
  17. * @property string $name 商品名称
  18. * @property string $logo 商品图片地址
  19. * @property int $traffic 商品内含多少流量,单位MiB
  20. * @property int $type 商品类型:1-流量包、2-套餐、3-余额充值
  21. * @property int $price 售价,单位分
  22. * @property int $renew 流量重置价格,单位分
  23. * @property int $period 流量自动重置周期
  24. * @property string|null $info 商品
  25. * @property string|null $desc 商品描述
  26. * @property int $days 有效期
  27. * @property int $invite_num 赠送邀请码数
  28. * @property int $limit_num 限购数量,默认为0不限购
  29. * @property string $color 商品颜色
  30. * @property int $sort 排序
  31. * @property int $is_hot 是否热销:0-否、1-是
  32. * @property int $status 状态:0-下架、1-上架
  33. * @property Carbon|null $created_at 创建时间
  34. * @property Carbon|null $updated_at 最后更新时间
  35. * @property Carbon|null $deleted_at 删除时间
  36. * @property-read mixed $traffic_label
  37. * @property-read Collection|GoodsLabel[] $label
  38. * @property-read int|null $label_count
  39. * @method static bool|null forceDelete()
  40. * @method static \Illuminate\Database\Eloquent\Builder|Goods newModelQuery()
  41. * @method static \Illuminate\Database\Eloquent\Builder|Goods newQuery()
  42. * @method static Builder|Goods onlyTrashed()
  43. * @method static \Illuminate\Database\Eloquent\Builder|Goods query()
  44. * @method static bool|null restore()
  45. * @method static \Illuminate\Database\Eloquent\Builder|Goods type($type)
  46. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereColor($value)
  47. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereCreatedAt($value)
  48. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereDays($value)
  49. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereDeletedAt($value)
  50. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereDesc($value)
  51. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereId($value)
  52. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereInfo($value)
  53. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereInviteNum($value)
  54. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereIsHot($value)
  55. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereLimitNum($value)
  56. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereLogo($value)
  57. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereName($value)
  58. * @method static \Illuminate\Database\Eloquent\Builder|Goods wherePeriod($value)
  59. * @method static \Illuminate\Database\Eloquent\Builder|Goods wherePrice($value)
  60. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereRenew($value)
  61. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereSku($value)
  62. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereSort($value)
  63. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereStatus($value)
  64. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereTraffic($value)
  65. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereType($value)
  66. * @method static \Illuminate\Database\Eloquent\Builder|Goods whereUpdatedAt($value)
  67. * @method static Builder|Goods withTrashed()
  68. * @method static Builder|Goods withoutTrashed()
  69. */
  70. class Goods extends Model
  71. {
  72. use SoftDeletes;
  73. protected $table = 'goods';
  74. protected $primaryKey = 'id';
  75. protected $dates = ['deleted_at'];
  76. function scopeType($query, $type)
  77. {
  78. return $query->whereType($type)->whereStatus(1)->orderBy('sort', 'desc');
  79. }
  80. function label()
  81. {
  82. return $this->hasMany(GoodsLabel::class, 'goods_id', 'id');
  83. }
  84. function getPriceAttribute($value)
  85. {
  86. return $value/100;
  87. }
  88. function setPriceAttribute($value)
  89. {
  90. $this->attributes['price'] = $value*100;
  91. }
  92. function getRenewAttribute($value)
  93. {
  94. return $value/100;
  95. }
  96. function setRenewAttribute($value)
  97. {
  98. return $this->attributes['renew'] = $value*100;
  99. }
  100. function getTrafficLabelAttribute()
  101. {
  102. return flowAutoShow($this->attributes['traffic']*1048576);
  103. }
  104. }