modularsoftware / genealogy

app/Tables/Builders/FamilyTable.php

<?php

namespace App\Tables\Builders;

use App\Family;
use Illuminate\Database\Eloquent\Builder;
use LaravelEnso\Tables\Contracts\Table;

class FamilyTable implements Table
{
    protected const TemplatePath = __DIR__.'/../Templates/families.json';

    public function query(): Builder
    {
        return Family::leftJoin('people as husband', function ($join) {

The expression return App\Family::leftJoin('people as husband', function(...) { /* ... */ })->leftJoin('people as wife', function(...) { /* ... */ })->select(DB::raw(' families.id, families.id as "dtRowId", families.description as description, husband.name as husband_name, wife.name as wife_name, families.is_active ')) could return the type Illuminate\Database\Query\Builder which is incompatible with the type-hinted return Illuminate\Database\Eloquent\Builder. Consider adding an additional type-check to rule them out.

            $join->on('husband.id', '=', 'families.husband_id');
        })
            ->leftJoin('people as wife', function ($join) {
                $join->on('wife.id', '=', 'families.wife_id');
            })
            ->select(\DB::raw('
            families.id, families.id as "dtRowId", families.description as description, husband.name as husband_name,
 wife.name as wife_name, families.is_active
            '));
    }

    public function templatePath(): string
    {
        return static::TemplatePath;
    }
}