i need to create a batch(team) for finishing a job , their are many team members in a single batch

Viewed 18

I have a 3 table in my database Job_requisition , Batch , Batch members. first i created a new model for selecting multiple team members for a batch. Now we need to store team members id in Batch members table. Batch table contains batch_id which is foreign key of batch members table.

index.blade

enter code h    <div class="modal fade" id="mymodal" tabindex="-1" role="dialog" aria-labelledby="batchMembersModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="batchMembersModalLabel">Batch Members Details</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                {{-- @dd($member) --}}
                <form id="batchDetailsForm" action="{{ route('requisition.storeBatchDetails', ["id" => $member->id]) }}" method="post">
                    @csrf
                    <input type="hidden" id="batchId" name="batchId" value="{{$member->id}}">
                    <label for="teamMembersDropdown">Select Team Members</label>
                    <select class="form-control"  name="teamMembers[]" multiple="multiple">
                        @foreach ($employees as $employee)
                            <option value="{{ $employee->id }}">{{ $employee->name }}</option>
                        @endforeach
                    </select><br>
                    <div>
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                        <button type="submit" class="btn btn-primary">Save changes</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

after submiting a form batch table id should auto update currently its not working. my controller

    public function storeBatchDetails(Request $request ,$id)
{
    // dd($request->all());
    $requisitions = $this->service->showCompletedRequisition();
    
    $batchMembers = $request->get('teamMembers');
    $id = $request->get('batchId');
    
    foreach($batchMembers as $batchMember){
        EmployeeBatchMembers::create([
            'batch_id' => $id,
            'employee_id' => $batchMember,
        ]);
    }

i want when a select a team member those members id should go in batch_members table and that batch id will go in batch table .

0 Answers
Related