删除Laravel中数据透视表中的行

Question

I have two tables. Table reports

report_id | user_id | item_id

and reports_messages

report_id | user_id | item_id | messages

I want when I delete report_id on reports all related rows which matching report_id in reports_messages to be deleted too.

In my ReportMessages Model I have this relation

public function reports(){
    return $this->belongsTo('App\Report');
}

public function item(){
    return $this->belongsTo('App\Item', 'item_id', 'id');
}   

In Report model

public function reportedItem(){

    return $this->belongsTo('App\Item');
}

public function user(){
    return $this->hasOne('App\User', 'id', 'user_id');
}

So far I've tried this solution founded here on SO

public function destroy($report_id){

    Report::destroy($report_id);
    ReportMessages::find(1)->reports()->where('report_id',$report_id)->delete();

    return redirect()->route('user.ports');

This deletes only in reports.. doesn't delete related report_id's in pivot table. }

Answer 1

Laravel has the functions detach and attach to deal with pivot tables. So you can do this to remove the record in the pivot table:

ReportMessages::find(1)->reports()->detach($report_id);

This will however not remove the row in the reports table because it could still be linked to another object.

Update:
So, I just noticed, you don't have pivot tables, you only have two models that are linked.

You don't have to load the reports() relation in your query to remove the ReportMessages, you can just do it like this:

Report::destroy($report_id);
ReportMessages::where('report_id',$report_id)->delete();

This will remove the report, and all corresponding reportmessages.