44 lines
1.3 KiB
PHP
Executable File
44 lines
1.3 KiB
PHP
Executable File
<?php
|
|
|
|
namespace Common\Comments;
|
|
|
|
use Illuminate\Database\Eloquent\Builder;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Support\Collection;
|
|
|
|
class LoadChildComments
|
|
{
|
|
public function execute(
|
|
Model $commentable,
|
|
Collection $rootComments,
|
|
): Collection {
|
|
$paths = $rootComments
|
|
->map(function (Comment $comment) {
|
|
$path = $comment->getRawOriginal('path');
|
|
return "LIKE '$path%'";
|
|
})
|
|
->implode(' OR path ');
|
|
|
|
$childComments = app(Comment::class)
|
|
->with(['user' => fn($builder) => $builder->compact()])
|
|
->where('commentable_id', $commentable->id)
|
|
->where('commentable_type', $commentable->getMorphClass())
|
|
->childrenOnly()
|
|
->where(fn(Builder $builder) => $builder->whereRaw("path $paths"))
|
|
->orderBy('path', 'asc')
|
|
->orderBy('created_at', 'desc')
|
|
->orderByWeightedScore()
|
|
->limit(100)
|
|
->get();
|
|
|
|
$childComments->each(function ($child) use ($rootComments) {
|
|
$index = $rootComments->search(
|
|
fn($parent) => $parent['id'] === $child['parent_id'],
|
|
);
|
|
$rootComments->splice($index + 1, 0, [$child]);
|
|
});
|
|
|
|
return $rootComments;
|
|
}
|
|
}
|