目前有一个这样的含有10个项目的页面,其中一个输入框可关联类下的十个对应目标,可是无法关联外键。
模型命名: Student
从左至右命名分别为:name, tel, contact_name, contact_relation, payment_status_id(外键), star_lv, notification, project_id(外键), project_type_id(外键), user_id(信息录入人)
控制器:
//学生信息索引
public function studentIndex(Request $request)
{
//学生信息索引
$table_search = $request->get('table_search');
$data = Student::when($table_search, function (Builder $query) use ($table_search) {
$query->where('name', 'like', '%' . $table_search . '%');
$query->orwhere('tel','like','%' . $table_search . '%');
$query->orWhere('contact_name', 'like', '%' . $table_search . '%');
$query->orWhere('contact_relation', 'like', '%' . $table_search . '%');
$query->orWhere('star_lv', 'like', '%' . $table_search . '%');
$query->orWhere('notification', 'like', '%' . $table_search . '%');
})->orderByDesc('updated_at')->paginate(9);
//$data = Student::paginate(5);
return view('student.student_index', compact('data', 'table_search'));
}
请教如何关联到外键(如:payment_status 等 ), 谢谢~!