File manager - Edit - /var/www/payraty/helpdesk/common/Votes/OrdersByWeightedScore.php
Back
<?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); } }
| ver. 1.4 |
Github
|
.
| PHP 8.3.30 | Generation time: 0.06 |
proxy
|
phpinfo
|
Settings