dongou1970
2017-01-26 15:06
浏览 100
已采纳

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

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. }

图片转代码服务由CSDN问答提供 功能建议

我有两张桌子。 表 reports

  report_id |  user_id |  item_id 
   
 
 

reports_messages

  report_id |  user_id |  item_id | 消息
   
 
 

我想删除 report 上的 report_id 所有与 report_id <匹配的相关行 / code> in reports_messages 也将被删除。

在我的ReportMessages模型中我有这种关系

  公共函数报告(){
返回$ this-&gt; belongsTo('App \ Report'); 
} 
 
公共函数项(){
返回$ this-&gt; belongsTo('App \ Item')  ,'item_id','id'); 
} 
   
 
 

在报表模型中

  public function reportedItem  (){
 
返回$ this-&gt; belongsTo('App \ Item'); 
} 
 
公共函数user(){
返回$ this-&gt; hasOne('App \ User',  'id','user_id'); 
} 
   
 
 

到目前为止,我已尝试在此处创建此解决方案 public function destroy($ report_id){ Report :: destroy($ report_id); ReportMessages :: find(1) - &gt; reports() - &gt; where('report_id', $ report_id) - &gt; delete(); 返回redirect() - &gt; route('user.ports'); \ n

仅在 reports 中删除..不会删除数据透视表中的相关report_id。 }

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • duansaxf095988 2017-01-26 15:08
    已采纳

    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.

    点赞 打赏 评论
  • douxiuyu2028 2018-07-08 13:23

    I'm know I'm late but the best option with this kind of relationship, it is best to define foreign keys to particular linking tables in your table " reports_messages" like below

    > $table->integer('report_id')->unsigned()->index(); $table->foreign('report_id')->references('id')->on('reports')->onDelete('cascade'); $table->integer('message_id')->unsigned()->index(); $table->foreign('message_id')->references('id')->on('messages')->onDelete('cascade');

    When you do something like this, the pivot table data will be removed as long as either message or report is deleted from database without a need of detaching methods. Best option in case message or report has relationship with other data,such that when data is deleted message should be deleted automatically, in this case we do not have to worry about detaching data again

    点赞 打赏 评论

相关推荐 更多相似问题