我想搜索服務(wù)提供商和產(chǎn)品，并按位置和服務(wù)或按位置和副產(chǎn)品進(jìn)行過(guò)濾。我正在使用下面的代碼` $results = new ClientProfile; if (request()->has('service-provider')) { $results = $results->where('jobsc_id', request('service-provider')); } elseif(request()->has('product')) { $results = $results->where('product_id', request('product')); } elseif(request()->has('city')){ $results = $results->where('divsec_id', request('city')); } else { $results = ClientProfile::searched(); } $results = $results->where('profile_state', 'active')->paginate(10)->appends([ 'service-provider' => request('service-provider'), 'product' => request('product'), 'city' => request('city'), ]); return view('results')->with('results', $results);`雖然它顯示的 URL 為domain.com/results?product=2&city=78，但它顯示了所有沒(méi)有按城市過(guò)濾的產(chǎn)品
2 回答
德瑪西亞99
TA貢獻(xiàn)1770條經(jīng)驗(yàn) 獲得超3個(gè)贊
因此，當(dāng)你找到一個(gè)時(shí)你使用if elseif它，第二個(gè)也不會(huì)出現(xiàn)。
改用when_if else
$results = new ClientProfile::when(request()->has('service-provider'), function($q){
$q->where('jobsc_id', request('service-provider'));
})
->when(request()->has('product'), function($q){
$q->where('product_id', request('product'));
})
->when(request()->has('city'), function($q){
$q->where('divsec_id', request('city'));
})
->when(count($request->all()) === 0, function($q){
$q->searched();
})
->where('profile_state', 'active')->paginate(10)->appends([
'service-provider' => request('service-provider'),
'product' => request('product'),
'city' => request('city'),
]);
return view('results')->with('results', $results);`
紅顏莎娜
TA貢獻(xiàn)1842條經(jīng)驗(yàn) 獲得超13個(gè)贊
這段代碼對(duì)我有用
$results = ClientProfile::when(request()->has('service-provider'), function($q){
$q->where('jobsc_id', request('service-provider'));
})->when(request()->has('product'), function($q){
$q->where('product_id', request('product'));
})->when(request()->has('city'), function($q){
$q->where('divsec_id', request('city'));
})->when(count(request()->all()) === 0, function($q){
$q->searched();
})->where('profile_state', 'active')->paginate(10)->appends([
'service-provider' => request('service-provider'),
'product' => request('product'),
'city' => request('city'),
]);
- 2 回答
- 0 關(guān)注
- 150 瀏覽
添加回答
舉報(bào)
0/150
提交
取消