Need a little help with a query involving withCount

Doing a search query right now and I am trying to get the count of the hires of the profile that owns the project.

        $query = Project::with('profile');

                    $query->with(['profile' => function ($q) {
                        $q->withCount('hires', function ($qr) {
                            $qr->where('hires_count', '=', '0');
                        });

the hires function belonging to the profile

    public function hires()
    {
        return $this->projects()->where('status', '<>', 'available')->whereHas('bids');
    }

and I am getting this error:

"mb_strpos() expects parameter 1 to be string, object given"

tykus

7 years ago

Level 104

I have read this a couple of times and still don't understand what you are attempting to achieve; why are you eager-loading profile twice? The whereHas method takes a Closure; did you mean to use the has method instead?

Reprise

7 years ago

Level 1

tried eager loading it second time because it wasn't letting me use it. And for the whereHas I was not aware that it takes a Closure, I simply wanted to return the projects that have the relationship 'bids'.

staudenmeir

7 years ago

Level 24

withCount expects an array:

$query->with(['profile' => function ($q) {
    $q->withCount(['hires' => function ($qr) {
        $qr->where('hires_count', '=', '0');
    }]);

Please or to participate in this conversation.