数据透视表上的Laravel一对多插入 - Laravel One-To-Many insertion on a Pivot table

Laravel One-To-Many insertion on a Pivot table

我正在使用Laravel 5.3并且在通过hasMany关系保存时遇到问题。

我有表employee和activity，它们具有一对多关系，即每个员工将执行许多活动。

当我使用associate()添加针对员工的活动时，它发送给我一个错误:

BadMethodCallException in Builder.php line 2440:
Call to undefined method Illuminate'Database'Query'Builder::associate()

下面是DB结构和代码:

数据库结构:

employee (1st table)
– employee_id
– employee_name
- created_at
- updated_at
activity (2nd table)
– activity_id
– activity_name
- created_at
- updated_at
employee_activity (pivot table)
– employee_activity_employee_id
– employee_activity_activity_id

Model Class Employee:

class Employee extends Model
{
    protected $table = 'employee';
    protected $primaryKey = 'employee_id';
    public function activity() {
        return $this->hasMany('App'Models'Activity', 'employee_activity', 'employee_activity_employee_id', 'employee_id');
    }
}

模范班级活动:

class Activity extends Model
{
    protected $table = 'activity';
    protected $primaryKey = 'activity_id';
    public function employee() {
        return $this->belongsTo('App'Models'Employee', 'employee_activity', 'employee_activity_activity_id' ,'activity_id');
    }
}

控制器:

public function EmployeeActivityAssociation()
{
    $employee_id = Input::get('employee_id');
    $activity_ids = Input::get('activity_id'); // This is an array of activities
    $employee = Employee::find($employee_id);
    if (!empty($employee)) {
         //Adding activity under the employee
        foreach ($activity_ids as $id) {
            $activity = Activity::find($id);
            $employee->activity()->associate($activity);
            $employee->save();
        }
        return 'Activities asscoiated to employee';
    }   
    else {
        return 'Employee not found';
    }
}

我的关系定义不正确吗?

您的关系没有正确定义。通过查看表结构，它应该是many-to-many关系。

Model Class Employee:

public function activity() {
    return $this->belongsToMany('App'Models'Activity', 'employee_activity', 'employee_activity_employee_id', 'employee_id');
}

模范班级活动:

public function employee() {
    return $this->belongsToMany('App'Models'Employee', 'employee_activity', 'employee_activity_activity_id' ,'activity_id');
}

所以你的控制器应该是:

public function EmployeeActivityAssociation()
{
    $employee_id = Input::get('employee_id');
    $activity_ids = Input::get('activity_id'); // This is an array of activities
    $employee = Employee::find($employee_id);
    if (!empty($employee)) {
        $employee->activity()->attach($activity_ids);
      return 'Activities asscoiated to employee';
    }   
    else {
        return 'Employee not found';
    }
}

如果你想坚持一对多的关系，那么你必须改变你的表模式:

删除表employee_activity表，在活动表中添加列employee_id，然后定义一对多关系

使用多对多方案，并且在迁移时，将字段'activity_id'定义为'employee_activity'表上的'唯一':

$table->unsignedInteger('employe_id');    
$table->unsignedInteger('activity_id')->unique();

通过这种方式，您可以在'employee_activity'表上只注册与一个雇员相关联的一个活动，而一个雇员可以与多个活动相关联。