switch($p,'含关联交易',"",'不含关联交易',"and s.FNAME_L2 not in('WWHC-202309-00125','WWHC-202309-00124','WWHC-202309-00123')" ,'只含关联交易',"and s.FNAME_L2 in('WWHC-202309-00125','WWHC-202309-00124','WWHC-202309-00123')") 简化如下: switch($p, '含关联交易',"" ,'不含关联交易',"and 1=1" ,'只含关联交易',"and 1=1" ) 放在SQL中执行也会提示缺失右括号,如何解决? |