Episode.php 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  1. <?php
  2. namespace App\Models;
  3. use App\Casts\HttpToHttps;
  4. use Dcat\Admin\Traits\HasDateTimeFormatter;
  5. use Illuminate\Database\Eloquent\SoftDeletes;
  6. use Illuminate\Database\Eloquent\Model;
  7. /**
  8. * App\Models\Episode
  9. *
  10. * @property int $id
  11. * @property int $category_id 分类
  12. * @property int $platform 所属平台
  13. * @property string $name 名称
  14. * @property string $cover_img 名称
  15. * @property int $status 状态 0-更新中 1-已完结
  16. * @property int $is_opend 上架状态 0-下架 1-上架
  17. * @property int $sort 排序
  18. * @property int $is_vip_watch 是否限定VIP观看
  19. * @property int $free_episodes 免费集数
  20. * @property int $paid_episodes 付费集数
  21. * @property string $episodes_price 单集价格设置
  22. * @property \Illuminate\Support\Carbon|null $updated_at
  23. * @property \Illuminate\Support\Carbon|null $deleted_at
  24. * @property \Illuminate\Support\Carbon|null $created_at
  25. * @property-read \App\Models\EpisodesCategory|null $category
  26. * @property-read \App\Models\EpisodesList|null $lists
  27. * @property-read int|null $lists_count
  28. * @method static \Illuminate\Database\Eloquent\Builder|Episode newModelQuery()
  29. * @method static \Illuminate\Database\Eloquent\Builder|Episode newQuery()
  30. * @method static \Illuminate\Database\Query\Builder|Episode onlyTrashed()
  31. * @method static \Illuminate\Database\Eloquent\Builder|Episode query()
  32. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereCategoryId($value)
  33. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereCoverImg($value)
  34. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereCreatedAt($value)
  35. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereDeletedAt($value)
  36. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereEpisodesPrice($value)
  37. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereFreeEpisodes($value)
  38. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereId($value)
  39. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereIsOpend($value)
  40. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereIsVipWatch($value)
  41. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereName($value)
  42. * @method static \Illuminate\Database\Eloquent\Builder|Episode wherePaidEpisodes($value)
  43. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereSort($value)
  44. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereStatus($value)
  45. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereUpdatedAt($value)
  46. * @method static \Illuminate\Database\Query\Builder|Episode withTrashed()
  47. * @method static \Illuminate\Database\Query\Builder|Episode withoutTrashed()
  48. * @mixin \Eloquent
  49. * @property-read \App\Models\UserEpisodesRecord|null $userEpisodesRecords
  50. * @property-read int|null $user_episodes_records_count
  51. * @method static \Illuminate\Database\Eloquent\Builder|Episode wherePlatform($value)
  52. * @property-write mixed $status_text
  53. * @property-write mixed $total
  54. * @property-read \App\Models\UserCollect|null $userCollect
  55. * @property-read \App\Models\UserFavorite|null $userFavorite
  56. * @property int $share_count 分享数量
  57. * @method static \Illuminate\Database\Eloquent\Builder|Episode whereShareCount($value)
  58. * @property-read \App\Models\UserWatchRecord|null $userWatchRecord
  59. * @method static \Illuminate\Database\Eloquent\Builder|Episode filterPlatform()
  60. */
  61. class Episode extends Model
  62. {
  63. use HasDateTimeFormatter,SoftDeletes;
  64. protected $hidden = [
  65. 'updated_at','deleted_at'
  66. ];
  67. protected $casts = [
  68. 'platform' => 'json',
  69. 'share_count' => 'integer',
  70. 'cover_img' => HttpToHttps::class,
  71. ];
  72. public static function complete($episodes)
  73. {
  74. /* @var Episode $episode*/
  75. foreach ($episodes as $episode){
  76. $episode->status_text = $episode->status;
  77. $episode->total = $episode->lists_count;
  78. }
  79. return $episodes;
  80. }
  81. public function scopeFilterPlatform($query)
  82. {
  83. return $query->where('platform', 'like','%'.\user()->info->platform.'%');
  84. }
  85. public function category()
  86. {
  87. return $this->belongsTo(EpisodesCategory::class,'category_id','id');
  88. }
  89. public function lists()
  90. {
  91. return $this->hasMany(EpisodesList::class,'episodes_id','id');
  92. }
  93. public function setStatusTextAttribute($value)
  94. {
  95. $config = config('global.episode_status');
  96. $this->attributes['status_text'] = $config[$value]??'未知';
  97. }
  98. public function setTotalAttribute($value)
  99. {
  100. $this->attributes['total'] = $value;
  101. }
  102. /* 购买记录 */
  103. public function userEpisodesRecords()
  104. {
  105. return $this->hasMany(UserEpisodesRecord::class,'episodes_id','id');
  106. }
  107. // 收藏
  108. public function userCollect()
  109. {
  110. return $this->belongsTo(UserCollect::class,'id','episode_id');
  111. }
  112. // 喜欢
  113. public function userFavorite()
  114. {
  115. return $this->belongsTo(UserFavorite::class,'id','episode_id');
  116. }
  117. // 观看记录
  118. public function userWatchRecord()
  119. {
  120. return $this->belongsTo(UserWatchRecord::class,'id','episode_id');
  121. }
  122. }