javascript - 如何从多选表单将数据插入到 2tables
问题描述
我想将此表单中的数据插入表:项目和表:projects_departments
这是我的表格
表:部门
表:projects_departments
表:项目
我的表格
{!! Form::open(['route' => 'project.store']) !!}
{{ csrf_field() }}
<div class="row" name="add_name" id="add_name">
<div class="col-md-12" >
<div class="form-group department-select-container">
{!! Form::label('departments_id', 'Department Name :'); !!}
<?= Form::select('departments_id', App\Department::all()->pluck('department_name', 'id'), null, [
'class' => 'form-control', 'placeholder' => '-- Please Select --']); ?>
<a href="#" class="btn btn-sm btn-info btn-add-more-department" onclick="createNew()">ADD</a>
<div id="mydiv"></div>
</div>
</div>
</div>
ProjectController 函数库
public function store(Request $request)
{
$this->validate($request, [
'departments_id' => 'required',
'years_id' => 'required',
'strategys_id' => 'required',
'objectives_id' => 'required',
'tactics_id' => 'required',
'projects_name' => 'required',
'target_group' => 'required',
'kpis_id' => 'required',
'kpiunits_id' => 'required',
'level_1' => 'required',
'level_2' => 'required',
'level_3' => 'required',
'level_4' => 'required',
'level_5' => 'required',
'level_1_detail' => 'required',
'level_2_detail' => 'required',
'level_3_detail' => 'required',
'level_4_detail' => 'required',
'level_5_detail' => 'required',
]);
Project::create($request->all());
return redirect()->route('project.index')->with('success','recorded successfully');
}
这是模型:项目
protected $table = 'projects';
protected $fillable = [
'departments_id',
'years_id',
'strategys_id',
'objectives_id',
'tactics_id',
'projects_name',
'target_group',
'kpis_id',
'kpiunits_id',
'level_1',
'level_2',
'level_3',
'level_4',
'level_5',
'level_1_detail',
'level_2_detail',
'level_3_detail',
'level_4_detail',
'level_5_detail',
];
public function years() {
return $this->hasOne('App\Year', 'id', 'years_id');
}
public function strategys() {
return $this->hasOne('App\Strategy', 'id', 'strategys_id');
}
public function objectives() {
return $this->hasOne('App\Objective', 'id', 'objectives_id');
}
public function departments() {
return $this->hasOne('App\Department', 'id', 'departments_id');
}
public function tactics() {
return $this->hasOne('App\Tactic', 'id', 'tactics_id');
}
public function kpis() {
return $this->hasOne('App\Kpi', 'id', 'kpis_id');
}
public function kpiunits() {
return $this->hasOne('App\Kpiunit', 'id', 'kpiunits_id');
}
public function projects_departments() {
return $this->belongsTo(Project_department::class, 'departments_id');
}
这是模型:Project_department
protected $table = 'projects_departments';
protected $fillable = [
'projects_id',
'departments_id',
];
public function projects()
{
return $this->belongsToMany('App\Project');
}
解决方案
推荐阅读
- php - laravel 验证不起作用
- javascript - 如何重定向干净的网址
- angular - 如何让 firebase serve 在 Angular 项目中接管 ng serve 以将本地开发列入白名单?
- python - 无法运行 Poincare 嵌入示例以获取分层表示
- wordpress - WordPress 站点图像随处加载,但在客户的本地办公室 PC 上
- c# - 如何调试 WPF NET 应用程序以检测锁等
- ios - WKWebView 获取 Javascript 错误
- android - 在 RecyclerView 里面添加一个持续刷新的 ListView 是不是一个好主意?
- python - Pandas:FutureWarning:将列表喜欢传递给 .loc 或 []
- qt - PaintEvent中的QListView和QTableView有什么区别?