| 12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- <?xml version="1.0" encoding="UTF-8"?>
- <properties>
-
- <property name="queryorder">
- <![CDATA[
- select userid,cpid ,spid,to_char(ordertime,'yyyymmddhh24miss') ordertime,to_char(canceltime,'yyyymmddhh24miss') canceltime,orderchannel,cancelchannel,status,orderstatus from td_order_relations
- where userid = #[userid]
- #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,orderchannel,cancelchannel,to_char(status) status,orderstatus from wosdk.td_order_relations
- where userid = #[userid]
- #if($cpid && !$cpid.equals("")) and cpid=#[cpid] #end
- #if($spid && !$spid.equals("")) and productid=#[spid] #end
- ]]>
- </property>
-
- <property name="queryefforder">
- <![CDATA[
- select userid,cpid ,spid,to_char(ordertime,'yyyymmddhh24miss') ordertime,to_char(canceltime,'yyyymmddhh24miss') canceltime,status from 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 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
- ]]>
- </property>
-
- <property name="queryorders">
- <![CDATA[
- select userid,cpid ,spid,to_char(ordertime,'yyyymmddhh24miss') ordertime,to_char(canceltime,'yyyymmddhh24miss') canceltime,orderchannel,cancelchannel,status,orderstatus from td_order_relations
- where userid = #[userid]
- ]]>
- </property>
-
-
- </properties>
|
