//判断前端传来的搜索条件值是否为null,如果为null,1=1;如果不为null,supplier_id=#{supplierId}
where if (#{supplierId} is not null,b.supplier_id=#{supplierId},1=1)
07-30
258
11-25
1933
02-19
1532
03-17