Laravel 8 Livewire在下拉菜单中保存选中值的ID

Question

我的数据库中有两个表"emp_info"contains(user_id, firstname, lastname)和"load_schedule">包含(教员id，护士名，日期，房间，时间)。问题是我有一个编辑模式(弹出式)，它包含在我的主视图中，虽然它显示了教师列表($instructor)但是它不能用新的选择值更新教员列。

试过了:

<select class="shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline" name="faculty_id">
<option value="selected:" selected></option>
@foreach($instructors as $emp)
<option value="{{ $emp->user_id }}">{{ $emp->firstname.' '.$emp->lastname }}</option>
@endforeach
</select>

---

正如你所看到的，我试图使用user_id值插入到教员_id列。我做错了吗?我把$instructor作为全局数组在AppServiceProviders

---

控制器代码

class JoinTable extends Component
{
use WithPagination;
public $faculty_id,$firstname,$lastname,$fullnames,$emp_id,$emp,$appointmentid,$corsno,$corsdes,$day,$c_time,$hours,$room,$section,$size,$sem,$sy,$unit,$userid,$user_id;
public $openEdit=0;

public function render() 
{
$dupeSchedules = DB::table('load_schedule')
->select('room', 'hours', 'day','sy','sem')
->groupBy('room', 'hours', 'day','sy','sem')
->havingRaw('COUNT(*) > 1');
//Sub-Query for isolating duplicated schedules//
$dupliSchedules=DB::table('load_schedule')
->join('emp_info', 'load_schedule.faculty_id', '=','emp_info.user_id')
->select('load_schedule.*', 'emp_info.firstname', 'emp_info.lastname')
->joinSub($dupeSchedules, 'dupe_schedules', function ($join) {
$join->on('load_schedule.room','=', 'dupe_Schedules.room');
$join->on('load_schedule.day','=', 'dupe_Schedules.day');
$join->on('load_schedule.hours','=', 'dupe_Schedules.hours');
$join->on('load_schedule.sy','=', 'dupe_Schedules.sy');
$join->on('load_schedule.sem','=', 'dupe_Schedules.sem');
})->paginate(10);

return view('livewire.join-table',compact('dupliSchedules'));
}
public function edit($id)
{
$emp=Emp_sched::findorFail($id);
$this->emp_id=$emp->id;
$this->faculty_id=$emp->faculty_id;
$this->corsno=$emp->corsno;
$this->corsdes=$emp->corsdes;
$this->day=$emp->day;
$this->c_time=$emp->c_time;
$this->hours=$emp->hours;
$this->room=$emp->room;
$this->section=$emp->section;
$this->size=$emp->size;
$this->sem=$emp->sem;
$this->sy=$emp->sy;
$this->unit=$emp->unit;
$this->user_id=$emp->user_id;

$this->editModal();
}

public function editModal(){
$this->openEdit=true;
}

public function closeModal(){
$this->openEdit=false;
}

public function store(){

$this->validate([
'corsdes'=>'required',
'c_time'=>'required'
]);

Emp_sched::updateOrCreate(['id'=>$this->emp_id],[
'user_id'=>$this->user_id,
'faculty_id'=>$this->faculty_id,
'corsno'=>$this->corsno,
'corsdes'=>$this->corsdes,
'day'=>$this->day,
'c_time'=>$this->c_time,
'hours'=>$this->hours,
'room'=>$this->room,
'section'=>$this->section,
'size'=>$this->size,
'sem'=>$this->sem,
'sy'=>$this->sy,
'unit'=>$this->unit
]);

session()->flash('message', 
$this->emp_id ? 'Updated Successfully.' : 'Created Successfully.');

$this->closeModal();
$this->resetCreateForm();
}

public function create(){
$this->editModal();
}

public function delete($id){

Emp_sched::findorFail($id)->delete();
session()->flash('warning',  'Deleted Successfully.');

$this->closeModal();
}
private function resetCreateForm()
{
$this->user_id='';
$this->faculty_id= '';
$this->corsno= '';
$this->corsdes= '';
$this->day= '';
$this->c_time= '';
$this->hours= '';
$this->room= '';
$this->section= '';
$this->size= '';
$this->sem= '';
$this->sy= '';
$this->unit= '';
$this->userid= '';
}

}  
***************************************************

Answer 1

还有一个解决方案，你没有张贴你的控制器和模型在这里的例子。

protected $fillable = [
'faculty_id', 'corsname', 'day', 'room', 'time'
];

以上代码将在您的模型中。如果你的控制器代码没问题你的选择应该是这样的

<select class="" name="faculty_id" id="faculty_id" >

下面是一个例子

<select class="form-control" name="roles" id="roles" required="">
<option value="0" selected="" disabled="">Select Role</option> 
@foreach ($roles as $role)

<option value="{{$role->id}}" @if($roleid==$role->id) selected @endif>{{$role->name}}</option> 



@endforeach
</select>

试试下面的代码如果你的控制器和模型是好的

<option name ="faculty_id" value="{{ $emp->user_id }}">{{ $emp->firstname.' '.$emp->lastname }}</option>

我在这里添加一些建议来帮助人们，如果你是在Livewire组件中，select元素必须绑定到后端属性。

<select class="shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline" wire:model="faculty_id">
<option value=""></option>
@foreach($instructors as $emp)
<option value="{{ $emp->user_id }}">{{ $emp->firstname.' '.$emp->lastname }}</option>
@endforeach
</select>

then在livewire组件

public $faculty_id;
...///...
public function updatedFacultyId($value)
{
dd($value); // on select change, this line must be dumped
}

Answer 2

在检查了Ronny answer的类模型中的步骤之后，如果您在Livewire组件中，则必须将select元素绑定到后端属性。

<select class="shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline" wire:model="faculty_id">
<option value=""></option>
@foreach($instructors as $emp)
<option value="{{ $emp->user_id }}">{{ $emp->firstname.' '.$emp->lastname }}</option>
@endforeach
</select>

then在livewire组件

public $faculty_id;
...///...
public function updatedFacultyId($value)
{
dd($value); // on select change, this line must be dumped
}