Goods.php 4.6 KB

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