@php $companyType = Auth::user()->company ? Auth::user()->company->companyType : 'Business'; $name = $id = 'fillAcademicExamId'; $label = isset($element['label']) ? $element['label'] . '*' : 'Academic Exam'; $class = 'form-control custom-select2'; if (isset($element['attributes']['class'])) { $class .= ' ' . $element['attributes']['class']; } $attributes = ['id' => $id, 'class' => $class, 'placeholder' => 'Please select academic exam']; if (isset($element['attributes'])) { $attributes = array_merge($attributes, $element['attributes']); } $data = []; $data = DB::table('eims_academic_exam') ->leftJoin('eims_calendar_activities', 'eims_academic_exam.academic_exam_activities_id', '=', 'eims_calendar_activities.id') // Adjust table and column names accordingly ->where('eims_academic_exam.status', 1) ->select('eims_calendar_activities.name as name', 'eims_calendar_activities.id as id', 'eims_academic_exam.id as exam_id') ->groupBy('eims_calendar_activities.id') // ->get(); ->pluck('name', 'id'); $options = $data; if (isset($element['options'])) { $options = $element['options']; } $defaultValue = isset($element['defaultValue']) ? $element['defaultValue'] : ''; @endphp
{{-- {!! Form::label('fillSemesterClassId', 'Semester/Class: *', ['class' => 'col-sm-3 control-label'],false) !!} --}} {!! Form::label($name, $label, ['class' => 'control-label'], false) !!}
{!! Form::select($name, $options, $defaultValue, $attributes) !!}