当我想保存对票据的反应时,我有三个表(在laravel中):
-Tickets
-Reaction
-Reaction_Tickets (pivot table)
当我想保存一个反应时,我这样做:
public function addReaction(Request $request, $slug)
{
$ticket = Ticket::whereSlug($slug)->firstOrFail();
$reaction = new reactions(array(
'user_id' => Auth::user()->id,
'content' => $request->get('content')
));
return redirect('/ticket/'.$slug)->with('Reactie is toegevoegd.');
}
但是现在它当然没有被添加到数据透视表中。我不能添加它,因为我没有它的模型。正确的做法是什么?
编辑:-Tickets
public function reactions()
{
return $this->belongsToMany('App'reactions');
}
-Reactions
public function tickets()
{
return $this->hasOne('App'tickets');
}
在Laravel文档中,您需要保存Reaction
并将其附加到Ticket
:
$reaction = new reactions(array(
'user_id' => Auth::user()->id,
'content' => $request->get('content')
));
$reaction->save(); // Now has an ID
$tickets->reactions()->attach($reaction->id);
在您的Ticket
模型中,您需要定义关系:
class Ticket extends Model {
protected $table = "tickets";
public function reactions(){
return $this->belongsToMany("App'Reaction");
}
}
您应该在Reaction
上定义逆:
class Reaction extends Model {
protected $table = "reactions";
public function tickets(){
return $this->belongsToMany("App'Ticket");
}
}
如果你的模型是这样设置的,你应该没有任何问题,通过数据透视表将新的Reaction
附加到现有的Ticket
。