pinkary-project/pinkary.com

use App\Models\Question;
use App\Models\User;
use Illuminate\Database\Eloquent\Builder;

final readonly class QuestionsForYouFeed
{
    public function __construct(
        private User $user,
    ) {}

    public function builder(): Builder
    {
        return Question::query()
            ->where(function (Builder $query): void {
                $query->whereHas('to', function (Builder $toQuery): void {
                    $toQuery
                        ->whereHas('questionsSent.likes', function (Builder $questionsQuery): void {
                            $questionsQuery
                                ->where('user_id', $this->user->id)
                                ->where('created_at', '>=', now()->subDays(60));
                        })
                        ->orWhereHas('questionsReceived.likes', function (Builder $questionsQuery): void {
                            $questionsQuery
                                ->where('user_id', $this->user->id)
                                ->where('created_at', '>=', now()->subDays(60));
                        });
                })
                    ->orWhereHas('to', function (Builder $toQuery): void {
                        $toQuery->whereIn('id', $this->user->following()->select('users.id'));
                    });
            })
            ->orderByDesc('updated_at')
            ->whereNotNull('answer')
            ->where('is_reported', false)
            ->where('is_ignored', false);
    }
}