<?php
namespace Common\Votes;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\DB;
trait OrdersByWeightedScore
{
public function scopeOrderByWeightedScore(
Builder $query,
$direction = 'desc',
string $positiveCol = 'upvotes',
string $negativeCol = 'downvotes',
): Builder {
return $query
->select($query->getQuery()->columns ?? '*')
->addSelect([
DB::raw(
"(($positiveCol + 1.9208) / ($positiveCol + $negativeCol) -.96 * SQRT(($positiveCol * $negativeCol) / ($positiveCol + $negativeCol) + 0.9604) / ($positiveCol + $negativeCol)) / (1 + 3.8416 / ($positiveCol + $negativeCol)) AS weighted_score",
),
])
->orderBy('weighted_score', $direction);
}
}