I deleted some record(with SoftDeletes), But it won't disapear...?

[ginuwine72]

Sorry for my english.

I want to know when i deleted some record (with SoftDeletes).
Then i call like this:

>>> Building::find(385)->building_owners
[!] Aliasing 'Building' to 'App\Models\Building' for this Tinker session.
=> Illuminate\Database\Eloquent\Collection {#4706
     all: [
       App\Models\BuildingOwner {#4707
         id: 6,
         building_id: 385,
         people_id: 136,
         created_at: "2021-09-11 20:48:50",
         updated_at: "2021-09-11 20:48:50",
         deleted_at: null,
       },
       App\Models\BuildingOwner {#4708
         id: 7,
         building_id: 385,
         people_id: 137,
         created_at: "2021-09-11 20:48:55",
         updated_at: "2021-09-11 20:48:55",
         deleted_at: null,
       },
     ],
   }

and this:

>>> Building::find(385)->peoples
=> Illuminate\Database\Eloquent\Collection {#4691
     all: [
       App\Models\People {#4716
         id: 134,
         people_first_name: "Friedrich",
         people_last_name: "Romaguera",
         people_id_card: "9780163259415",
         people_phone: "0799109525",
         created_at: "2021-08-29 15:53:02",
         updated_at: "2021-08-29 15:53:02",
         deleted_at: null,
         pivot: Illuminate\Database\Eloquent\Relations\Pivot {#4715
           building_id: 385,
           people_id: 134,
         },
       },
       App\Models\People {#4717
         id: 135,
         people_first_name: "Turner",
         people_last_name: "Marquardt",
         people_id_card: "9795544876136",
         people_phone: "5955762752",
         created_at: "2021-08-29 15:53:02",
         updated_at: "2021-08-29 15:53:02",
         deleted_at: null,
         pivot: Illuminate\Database\Eloquent\Relations\Pivot {#4699
           building_id: 385,
           people_id: 135,
         },
       },
       App\Models\People {#4718
         id: 136,
         people_first_name: "Harley",
         people_last_name: "Kub",
         people_id_card: "9791607832330",
         people_phone: "9373910477",
         created_at: "2021-08-29 15:53:02",
         updated_at: "2021-08-29 15:53:02",
         deleted_at: null,
         pivot: Illuminate\Database\Eloquent\Relations\Pivot {#4684
           building_id: 385,
           people_id: 136,
         },
       },
       App\Models\People {#4719
         id: 137,
         people_first_name: "Jennyfer",
         people_last_name: "Considine",
         people_id_card: "9783206107254",
         people_phone: "8448049276",
         created_at: "2021-08-29 15:53:02",
         updated_at: "2021-08-29 15:53:02",
         deleted_at: null,
         pivot: Illuminate\Database\Eloquent\Relations\Pivot {#4685
           building_id: 385,
           people_id: 137,
         },
       },
     ],
   }
>>> 

my database is:
buildings:

• id

people:

• id

building_owners

• building_id

• people_id

I deleted it at building_owners's model.
I call it at buildings's model.
like this:

$building->building_owners

and

$building->peoples

as it as a function in building's model

    public function peoples()
    {
        return $this->belongsToMany(People::class, 'building_owners', 'building_id', 'people_id');
    }

    public function building_owners()
    {
        return $this->hasMany(BuildingOwner::class, 'building_id');
    }

I want to know why these 2 methods are different or.
Do i wrong? Or i missed something? Please help.

[dennisprudlo]

Do you soft delete the records in your pivot table (building_owners)? If so, as far as I know soft deletes doesn't work in pivot tables. You will have to update your relationship and explicitly exclude entries with a value in the deleted_at column (->wherePivotNull('deleted_at'))

https://laravel.com/docs/8.x/eloquent-relationships#filtering-queries-via-intermediate-table-columns

[ginuwine72]

Many Thanks.