组件
$filter->equal('project_number','项目名字')->select(function(){
$sql = "SELECT distinct p.project_number,p.project_name
FROM product_prices p
GROUP BY p.project_number,p.project_name
";
$reArr = [];
// $arr = Db::table("product_prices")->distinct()->get(["project_number","project_name"])->toarray();
$arr = Db::select($sql);
foreach($arr as $v){
$reArr[
$v->project_number
] = $v->project_name;
}
//sql
return $reArr;
}
)->load("product_number","/admin/productPrice/secondSelect");
$filter->equal("product_number","产品名字")->select();
//方法
//二级联动
public function secondSelect(Request $request){
$provinceId = $request->get('q');
// $provinceId = "ltkf123";
$sql = "SELECT distinct p.product_number,p.product_name
FROM product_prices p
where p.project_number=ltkf123
group by p.product_number,p.product_name
";
$arr = Db::table("product_prices")->where(["project_number"=>$provinceId])->distinct()->get([Db::raw('product_number as id'),Db::raw('product_name as text')]);
return $arr;
}
//路由
$router->any('/productPrice/secondSelect','Capacity\[email protected]');
总结:按照laravel-admin文档去做就行,laravel所有的组件都是通用的,不要拘泥于是form,还是filter,名字相同的能起到同样的作用
by:同事吵吵闹闹的学东西好慢,只能每天晚上他们回去了加班安安静静学习