Laravel避免重复的查询判断

常用查询方案

if ($request->type) {
    $query = $query->where('type', $request->type);
}
if ($request->wave) {
    $query = $query->where('wave', $request->wave);
}

if ($request->spu) {
    $query = $query->where('spu','like', "%".$request->spu."%");
}
if ($request->sku) {
    $query = $query->where('sku','like', "%".$request->sku."%");
}

优化查询方案

foreach(['type', 'wave'] as $where){
    if ($request->{$where}) {
        $query = $query->where($where, $request->{$where});
    }
}

foreach(['spu', 'sku'] as $where){
    if ($request->{$where}) {
        $query = $query->where($where, 'like',"%".$request->{$where}."%");
    }
}