videoalliance/.svn/pristine/fd/fda38106fabd1b313955ab3c795e52965002b253.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<properties>

	<property name="order">
		<![CDATA[
			merge into TD_ORDER_RELATIONS a using (select #[cpid] cpid, #[spid] spid, #[userid] userid from dual) b
			on(a.cpid = b.cpid and a.spid = b.spid and a.userid = b.userid)
			when matched then update 
			set ordertime=to_date(#[ordertime], 'yyyymmddhh24miss'),
			effecttime=to_date(#[effecttime], 'yyyymmddhh24miss'), 
			canceltime='',
			#if($endtime && !$endtime.equals(""))endtime=to_date(#[endtime], 'yyyymmddhh24miss') #else endtime='' #end,
			status=#[status],synccount=0,syncsucceed='1',lastsynctime='',issms='1',
			smstime='',orderchannel=#[orderchannel],
			type=#[type],orderstatus=#[orderstatus],
			ordertype=#[ordertype],apptype=#[apptype],
			isexperience=#[isexperience],
			videoid=#[videoid],
			videoname=#[videoname],
			cachesucceed=1,
			showstatus=#[showstatus]
			when not matched then insert (id,cpid,spid,userid,ordertime,effecttime,endtime,status,province,area,orderchannel,synccount,syncsucceed,type,orderstatus,ordertype,apptype,isexperience,videoid,videoname,cachesucceed, showstatus)values(
			to_char(sysdate,'yyyyMMddhh24miss')||SEQ_COMMON6.nextval,
			#[cpid],#[spid],#[userid],
			to_date(#[ordertime], 'yyyymmddhh24miss'),
			to_date(#[effecttime], 'yyyymmddhh24miss'), 
			#if($endtime && !$endtime.equals(""))to_date(#[endtime], 'yyyymmddhh24miss') #else '' #end,
			#[status],#[province],#[area],#[orderchannel],0,1,#[type],#[orderstatus],#[ordertype],#[apptype],#[isexperience],#[videoid],#[videoname],1, #[showstatus])
		]]>
	</property>
	
</properties>