常用语句

(case ct.transferring_stat
				when '1' then '未转增过的客户' 
				when '2' then '待初审'
				when '3' then '待复审'
				when '4' then '转增失败'
				when '5' then '转增成功'
				else '空'
				end		
			   ) as transferringStat
			   
<choose>
				<when test="newUpdateOrderBy !=null and newUpdateOrderBy !=''">
					,a.UPDATE_TIME
					<if test="newUpdateOrderBy == 'asc'">ASC</if>
					<if test="newUpdateOrderBy == 'desc'">DESC</if>
				</when>
				<when test="registOrderBy !=null and registOrderBy !=''">
					,a.REGISTER_DATE 
					<if test="registOrderBy == 'asc'">ASC</if>
					<if test="registOrderBy == 'desc'">DESC</if>
				</when>
				<otherwise>
					,a.REGISTER_DATE DESC
				</otherwise>
			</choose>
			
insert into CRM_USER_ORG_ROLE 
		(ID,USER_ID,ORG_ID,ROLE_ID,STATUS,CREATE_TIME,UPDATE_TIME)
		values (
			seq_cf_id.nextval,
			(SELECT cu.ID FROM CF_USER cu where cu.OU_ID = #{id,jdbcType = VARCHAR} and rownum=1),
			(SELECT co.ID FROM CF_ORG co where co.OO_ID = #{orgId,jdbcType = VARCHAR} and rownum=1),
			(SELECT cr.ID FROM CF_ROLE cr where cr.OR_ID = #{roleId,jdbcType = VARCHAR} and rownum=1),
			'0',
			sysdate,
			sysdate
		) 

		
 WHERE CUST_MOBILE IN(
		SELECT CUST_MOBILE FROM CRM_CUSTOMER WHERE 1 = 1 
		<if test="list != null and '' != list ">  
	        AND CARD_NUMBER in  
	        <foreach collection="list" item="item" open="(" separator="," close=")">  
	            #{item.CARD_NUMBER}   
	        </foreach>  
	    </if>  
		) 
		
select * from dddd co 
		start with co.ID=(SELECT co.ID FROM dddd co where co.OO_ID = #{orgId,jdbcType = VARCHAR} and rownum=1)
		connect by prior co.PARENTID=co.id

		
decode(a.dock_sys,'1',a.cust_ask_code,'9',a.cust_ask_code,a.cust_login_name) custCode,


	<insert id="insertIntoDeliveryUploadBatch" parameterType="java.util.List">
		insert into aaaa
		(batch_number)
		<foreach collection="list" item="item" index="index" separator="union all">
			select
			  #{item.batchNumber,jdbcType=VARCHAR}		      
  			  from dual
		</foreach>
	</insert>
	
	
	<!-- 数据非空校验 -->
	<insert id="insertDataIsNull" parameterType="java.util.Map">
		insert into aaa
		    (
		     id,
		     batch_number
		    )
		    select seq_cf_id.nextval,A.* from (select batch_number,
		            group_id		           
		       from sss
		      where batch_number = #{batchNumber}
		        and process = '1') A
	</insert>
	
	
	@Override
	public String aaaaaa(List<String> list, String imei,String operator) {
		List<Map> deliveryList = new ArrayList<Map>();
		int j = 0;
		for (int i=0;i<list.size();i++) {
			String [] deliveryArray = list.get(i).split("\\|");
			int size=deliveryArray.length;
			Map<String, String> deliverMap = new HashMap<String, String>();
			deliverMap.put("groupId", size-1>0?deliveryArray[1].trim():"");
			deliverMap.put("custCode", size-2>0?deliveryArray[2].trim():"");			
			deliverMap.put("batchNumber", imei);			
			deliveryList.add(deliverMap);
			if(++j%3000==0||j==list.size()){
				customerDeliveryMapper.insertIntoDeliveryUploadBatch(deliveryList);		
				deliveryList.clear();
			}
		}
		return "success";
	}