laravel-admin的filter關聯

元件

$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:同僚吵吵鬧鬧的學東西好慢，隻能每天晚上他們回去了加班安安靜靜學習