在表pivot use form中插入数据，并在laravel 5.7中显示index.blade.php

Question

我在下面创建team.blade.php

表单Team index.blade.php

显示一个团队用户与该用户的名称，并显示该用户正在完成的项目，以及显示该用户作为什么（角色）。

一个用户的关系有很多团队。一个团队有很多用户。因此，我选择多对多的关系。但是当我创建团队时，我想在透视user_teams表中插入user_id和team_id作为用户和团队之间的关系表。

但是，当我尝试创建团队失败时，他没有将数据保存到user_teams表。在团队索引中，他不显示与该用户一起使用的团队用户的名称，而是显示该用户正在执行的项目，并将用户显示为what。

我的用户模型

<?php

namespace App;

use Illuminate\Notifications\Notifiable;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Foundation\Auth\User as Authenticatable;
use App\Presence;
use App\Models\Project;
use App\Productivity;
use App\Sick_leave;
use App\Annual_leave;
use App\Models\Team;

class User extends Authenticatable
{
use Notifiable;

/**
 * The attributes that are mass assignable.
 *
 * @var array
 */
protected $fillable = [
    'name', 'email', 'password', 'role_id',
];

/**
 * The attributes that should be hidden for arrays.
 *
 * @var array
 */
protected $hidden = [
    'password', 'remember_token',
];

public function role()
    {
        return $this->belongsTo(Role::class, 'role_id');
    }

public function teams()
    {
        return $this->belongsToMany(Team::class, 'user_teams');
    }

public function projects()
    {
        return $this->belongsToMany(Project::Class, 'user_projects');
    }
    }

团队模型

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use App\User;
use App\Role;
use Auth;

class Team extends Model
{
use SoftDeletes;

protected $table = 'teams';
protected $fillable = [
    'id', 
    'project_id',  
];

public function users()
{
    return $this->belongsToMany(User::class, 'user_teams');
}

public function project()
{
    return $this->belongsTo(Project::class);
}

public function role()
{
    return $this->belongsTo(Role::class);
}

}

项目模型

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Project extends Model
{
use SoftDeletes;
protected $table = 'projects';
protected $fillable = [
    'project_id',
    'project_name',
    'start_date',
    'end_date',
    'project_category',
];

public function users()
{
    return $this->belongsToMany(User::class, 'user_projects');
}

public function team()
{
    return $this->hasOne(Team::class);
}
}

用户团队模型

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class UserTeam extends Model
{
use SoftDeletes;    
protected $table = "user_teams";

public function team()
{
    return $this->belongsTo(Team::class);
}

public function user()
{
    return $this->belongsTo(User::class);
}
}

团队控制员

public function index()
{
    $users = auth()->user()->name;
    $users = User::all();
    return view ('teams.index', compact ('teams', 'users', 'projects'));
}
public function create()
{
    $users = User::all();
    $projects = Project::pluck('project_name', 'id');
    return view ('teams.form', compact('projects', 'users'));
}
public function store(Request $request)
{
    $team = Team::create($request->all());
    $userIds = User::find(2);
    $team->users()->attach($userIds);
    return redirect()->route('team.create');
}

在用户组中，有user\u id和team\u id字段。我如何克服这个问题？？

Answer 1

你必须创建团队，然后附加属于它的用户。

文档中的示例：

附加

雄辩还提供了一些额外的助手方法，使使用相关模型更加方便。举个例子，我们想象一个用户可以有很多角色，一个角色可以有很多用户。若要通过在连接模型的中间表中插入记录将角色附加到用户，请使用附加方法：

$user = App\User::find(1);

$user->roles()->attach($roleId);

就你而言：

团队控制员

public function store(Request $request)
{
    $team = Team::create($request->except('user_id'));
    $team->users()->attach($request->get('user_id', []));
    return redirect()->route('team.create');
}