Vážené skóre a trendy

Post::orderByLikeScore()->get();    // rank by a weighted sum of reactions (desc)
Post::orderByTrending()->get();     // rank by recency-weighted activity (desc)

Post::orderByLikeScore('asc')->get();
Post::orderByTrending('desc', 'love')->get();   // trending loves

// config/likes.php
'weights' => ['like' => 1, 'love' => 4],
'default_weight' => 1,

// config/likes.php
'trending' => [
    'window' => '3 days',        // what counts as "recent"
    'recent_multiplier' => 5,    // recent likes weigh 5x on top of all-time activity
    'driver_expressions' => [],
],

$top = Post::orderByLikeScore()->first();
$top->like_score;        // the weighted score the rows were ranked by

$hot = Post::whereNotLikedBy($user)->orderByTrending()->limit(10)->get();
$hot->first()->trending_score;

// config/likes.php
'trending' => [
    'window' => '7 days',
    'recent_multiplier' => 3,
    'driver_expressions' => [
        // Gravity: each like decays with its age in hours.
        'pgsql' => 'SUM(1 / POWER(EXTRACT(EPOCH FROM (NOW() - created_at)) / 3600 + 2, 1.8))',
        // Recent likes count 10x, bound to the window cut-off.
        'sqlite' => 'SUM(CASE WHEN created_at >= ? THEN 10 ELSE 1 END)',
    ],
],

use RoundlyConsulting\Likes\Support\TrendingScore;

['expression' => $expression, 'bindings' => $bindings] = TrendingScore::trending();        // the likes model's driver
['expression' => $expression, 'bindings' => $bindings] = TrendingScore::trending('pgsql');
// your driver_expressions entry for that driver (every ? bound to the window cut-off)
// when one is configured, otherwise the portable expression