- Review system: ReviewController (store/update/destroy), ReviewPolicy, Review model boot() hooks, review form with Alpine.js (spoiler toggle, edit/delete UX) - Search autocomplete: Alpine.js searchWidget in nav with 300ms debounce, keyboard navigation, 6-result dropdown - SEO: og:image, twitter:card in layout; og sections + Schema.org VideoGame JSON-LD on game show pages - Custom lists: UserList/UserListGame models, ListController, ListPolicy, lists index/show views, Add-to-List button on game pages Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
32 lines
895 B
PHP
32 lines
895 B
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
|
|
class Review extends Model
|
|
{
|
|
protected $fillable = ['user_id', 'game_id', 'body', 'rating', 'has_spoilers'];
|
|
|
|
protected $casts = ['has_spoilers' => 'boolean'];
|
|
|
|
protected static function boot(): void
|
|
{
|
|
parent::boot();
|
|
|
|
static::saved(function (Review $review) {
|
|
$review->game->recalculateRating();
|
|
});
|
|
|
|
static::deleted(function (Review $review) {
|
|
$review->game->recalculateRating();
|
|
});
|
|
}
|
|
|
|
public function user(): BelongsTo { return $this->belongsTo(User::class); }
|
|
public function game(): BelongsTo { return $this->belongsTo(Game::class); }
|
|
public function votes(): HasMany { return $this->hasMany(ReviewVote::class); }
|
|
}
|