sysdate) #if($cpid && !$cpid.equals(""))and cpid=#[cpid] #end #if($spid && !$spid.equals("")) and spid=#[spid] #end union all select userid,cpid ,productid spid,to_char(ordertime,'yyyymmddhh24miss') ordertime,to_char(canceltime,'yyyymmddhh24miss') canceltime,to_char(status) status from wosdk.td_order_relations where userid = #[userid] and (endtime is null or endtime > sysdate) #if($cpid && !$cpid.equals("")) and cpid=#[cpid] #end #if($spid && !$spid.equals("")) and productid=#[spid] #end ]]>