Goods.php 4.8 KB

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