<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">

<!-- ========================================================== -->
<!-- Configuration for ibatis sqlmap mapping. -->
<!-- ========================================================== -->

<!-- ============================================================================= -->
<!-- This file is generated by <tt>borncrm-dalgen</tt>, a DAL (Data Access Layer) -->
<!-- code generation utility specially developed for <tt>rent</tt> project. -->
<!-- -->
<!-- PLEASE DO NOT MODIFY THIS FILE MANUALLY, or else your modification may be -->
<!-- OVERWRITTEN by someone else. To modify the file, you should go to directory -->
<!-- <tt>(project-home)/biz/dal/src/conf/dalgen</tt>, and find the corresponding -->
<!-- configuration files. Modify those files according to your needs, then run -->
<!-- <tt>borncrm-dalgen</tt> to generate this file. -->
<!-- -->
<!-- @author peigen -->
<!-- ============================================================================= -->

<sqlMap namespace="borncrm">
<!-- ============================================= -->
<!-- RESULT MAPS -->
<!-- ============================================= -->

<!-- result maps for database table custom_sale_clew -->
<resultMap id="RM-CUSTOM-SALE-CLEW" class="com.yjf.borncrm.dal.dataobject.CustomSaleClewDO">

<result property="baseId" column="base_id" javaType="java.lang.String" jdbcType="VARCHAR" nullValue="0"/>
<result property="realName" column="real_name" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="gender" column="gender" javaType="int" jdbcType="INT" nullValue="0"/>
<result property="age" column="age" javaType="int" jdbcType="INT" nullValue="0"/>
<result property="referees" column="referees" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="mobile" column="mobile" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="mail" column="mail" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="certNo" column="cert_no" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="qq" column="qq" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="rawAddTime" column="raw_add_time" javaType="java.util.Date" jdbcType="TIMESTAMP"/>
<result property="rawUpdateTime" column="raw_update_time" javaType="java.util.Date" jdbcType="TIMESTAMP"/>
<result property="userId" column="user_id" javaType="java.lang.String" jdbcType="VARCHAR" nullValue="0"/>
<result property="platformId" column="platform_id" javaType="long" jdbcType="BIGINT" nullValue="0"/>

<result property="inputPerson" column="input_person" javaType="java.lang.String" jdbcType="VARCHAR" nullValue=""/>
<result property="inputPersonName" column="input_person_name" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="salePerson" column="sale_person" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="salePersonName" column="sale_person_name" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="clewType" column="clew_type" javaType="java.lang.String" jdbcType="VARCHAR"/>

<result property="status" column="status" javaType="java.lang.String" jdbcType="CHAR"/>
<result property="userName" column="user_name" javaType="java.lang.String" jdbcType="VARCHAR"/>
</resultMap>

<!-- ============================================= -->
<!-- mapped statements for IbatisCustomSaleClewDAO -->
<!-- ============================================= -->
<!-- mapped statement for IbatisCustomSaleClewDAO.insert -->
<insert id="MS-CUSTOM-SALE-CLEW-INSERT">
INSERT /*MS-BORNCRM-CUSTOM-SALE-CLEW-INSERT*/ INTO custom_sale_clew (base_id,real_name,gender,age,referees,mobile,mail,cert_no,qq,raw_add_time,user_id,platform_id,input_person,input_person_name,sale_person,sale_person_name,clew_type,status,user_name)
VALUES(#baseId#,#realName#,#gender#,#age#,#referees#,#mobile#,#mail#,#certNo#,#qq#,CURRENT_TIMESTAMP,#userId#,#platformId#,#inputPerson#,#inputPersonName#,#salePerson#,#salePersonName#,#clewType#,#status#,#userName#)
</insert>

<!-- mapped statement for IbatisCustomSaleClewDAO.update -->
<update id="MS-CUSTOM-SALE-CLEW-UPDATE">
UPDATE /*MS-BORNCRM-CUSTOM-SALE-CLEW-UPDATE*/ custom_sale_clew SET real_name=#realName#, gender=#gender#, age=#age#, referees=#referees#, mobile=#mobile#, mail=#mail#, cert_no=#certNo#, qq=#qq#, user_id=#userId#, platform_id=#platformId#,
input_person=#inputPerson#, input_person_name=#inputPersonName#, sale_person=#salePerson#, sale_person_name=#salePersonName#, clew_type=#clewType#, status=#status#, user_name=#userName# WHERE (base_id = #baseId#)
</update>

<update id="MS-CUSTOM-SALE-CLEW-UPDATE-SALE-PERSON">
UPDATE /*MS-CUSTOM-SALE-CLEW-UPDATE-SALE-PERSON*/ custom_sale_clew SET sale_person=#salePerson#, sale_person_name=#salePersonName# WHERE (base_id = #baseId#)
</update>

<!-- mapped statement for IbatisCustomSaleClewDAO.deleteBybaseId -->
<delete id="MS-CUSTOM-SALE-CLEW-DELETE-BYBASE-ID">
<![CDATA[
DELETE /*MS-BORNCRM-CUSTOM-SALE-CLEW-DELETE-BYBASE-ID*/ FROM custom_sale_clew WHERE (base_id = #value#)
]]>
</delete>

<!-- mapped statement for IbatisCustomSaleClewDAO.findByBaseId -->
<select id="MS-CUSTOM-SALE-CLEW-FIND-BY-BASE-ID" resultMap="RM-CUSTOM-SALE-CLEW">

SELECT /*MS-BORNCRM-CUSTOM-SALE-CLEW-FIND-BY-CONDITION*/ base_id ,real_name ,gender ,age ,referees ,mobile ,mail ,cert_no ,qq ,raw_add_time ,raw_update_time ,user_id ,platform_id ,input_person,input_person_name ,sale_person ,sale_person_name ,clew_type ,status ,user_name FROM custom_sale_clew WHERE status ='1' and (base_id = #baseId#)
</select>

<!-- mapped statement for IbatisCustomSaleClewDAO.SELECTCount -->
<select id="MS-CUSTOM-SALE-CLEW-SELECT-COUNT" resultClass="long">
<![CDATA[
SELECT /*MS-BORNCRM-CUSTOM-SALE-CLEW-SELECT-COUNT*/ COUNT(*) FROM custom_sale_clew where status='1'
]]>
</select>

<!-- mapped statement for IbatisCustomSaleClewDAO.findByCondition -->
<select id="MS-CUSTOM-SALE-CLEW-FIND-BY-CONDITION" resultMap="RM-CUSTOM-SALE-CLEW">
SELECT /*MS-BORNCRM-CUSTOM-SALE-CLEW-FIND-BY-CONDITION*/ base_id ,real_name ,gender ,age ,referees ,mobile ,mail ,cert_no ,qq ,raw_add_time ,raw_update_time ,user_id ,platform_id ,input_person,input_person_name ,sale_person ,sale_person_name ,clew_type ,status ,user_name FROM custom_sale_clew
where 1=1 and status='1'
<dynamic>
<isGreaterThan property="customSaleClew.baseId" compareValue="0" prepend=" and ">
base_id=#customSaleClew.baseId#
</isGreaterThan>
<isGreaterThan property="customSaleClew.platformId" compareValue="0" prepend=" and ">
platform_id=#customSaleClew.platformId#
</isGreaterThan>
<isGreaterThan property="customSaleClew.userId" compareValue="0" prepend=" and ">
user_id=#customSaleClew.userId#
</isGreaterThan>
<isNotEmpty property="customSaleClew.realName" prepend=" and ">
real_name=#customSaleClew.realName#
</isNotEmpty>
<isNotEmpty property="customSaleClew.mobile" prepend=" and ">
mobile=#customSaleClew.mobile#
</isNotEmpty>
<isNotEmpty property="customSaleClew.mail" prepend=" and ">
mail=#customSaleClew.mail#
</isNotEmpty>
<isNotEmpty property="customSaleClew.clewType" prepend=" and ">
clew_type=#customSaleClew.clewType#
</isNotEmpty>
<isNotEmpty property="customSaleClew.salePerson" prepend=" and ">
sale_person=#customSaleClew.salePerson#
</isNotEmpty>
</dynamic>
LIMIT #limitStart#,#pageSize#
</select>

<!-- mapped statement for IbatisCustomSaleClewDAO.findCountByCondition -->
<select id="MS-CUSTOM-SALE-CLEW-FIND-COUNT-BY-CONDITION" resultClass="long">
SELECT /*MS-BORNCRM-CUSTOM-SALE-CLEW-FIND-COUNT-BY-CONDITION*/ COUNT(*) FROM custom_sale_clew WHERE 1=1
<dynamic>
<isNotEmpty property="minAawAddTime" prepend=" and ">
to_days(raw_add_time) &gt;=to_days(#minAawAddTime#)
</isNotEmpty>
<isNotEmpty property="maxAawAddTime" prepend=" and ">
to_days(raw_add_time) &lt;= to_days(#maxAawAddTime#)
</isNotEmpty>
<isNotEmpty property="startLatelyInvestTime" prepend=" and ">
to_days(now())-to_days(raw_add_time) &lt;= #days#
</isNotEmpty>

<isGreaterThan property="customSaleClew.baseId" compareValue="0" prepend=" and ">
base_id=#customSaleClew.baseId#
</isGreaterThan>
<isGreaterThan property="customSaleClew.platformId" compareValue="0" prepend=" and ">
platform_id=#customSaleClew.platformId#
</isGreaterThan>
<isGreaterThan property="customSaleClew.userId" compareValue="0" prepend=" and ">
user_id=#customSaleClew.userId#
</isGreaterThan>
<isNotEmpty property="customSaleClew.realName" prepend=" and ">
real_name=#customSaleClew.realName#
</isNotEmpty>
<isNotEmpty property="customSaleClew.mobile" prepend=" and ">
mobile=#customSaleClew.mobile#
</isNotEmpty>
<isNotEmpty property="customSaleClew.mail" prepend=" and ">
mail=#customSaleClew.mail#
</isNotEmpty>
<isNotEmpty property="customSaleClew.clewType" prepend=" and ">
clew_type=#customSaleClew.clewType#
</isNotEmpty>
<isNotEmpty property="customSaleClew.salePerson" prepend=" and ">
sale_person=#customSaleClew.salePerson#
</isNotEmpty>
</dynamic>
</select>

</sqlMap>

最新文章

1. memo的一般方法
2. linux 用户之间的切换
3. 2016年12月24日 星期六 --出埃及记 Exodus 21:19
4. 利用MyEclipes的反转工程来配置Hibernate各种配置
5. Java使用基本JDK操作ZIP文件以及zip文件的加密、解密等功能
6. lib库依赖解决
7. 篇4 安卓app自动化测试-Appium API进阶
8. POJ1850-Code 递推数学
9. API 自动化框架
10. apache----------在apache环境下安装https支持
11. Spring Http Invoke 请求过程图
12. CSS3滚动条美化,CSS3滚动条皮肤
13. docker私库harbor的搭建
14. DHCP分配固定IP
15. Visual Studio 2012使用NUnit单元测试实践01，安装NUnit并使用
16. Delphi编程实现是否开启“平滑屏幕字体边缘“
17. logback将日志写入不同文件夹里
18. 简易安装ubuntu- -(虚拟机实现)
19. ios一些噁心记录
20. Nginx&quot; upstream prematurely closed connection while reading response header from upstream&quot;问题排查

热门文章

1. elementui表格表头合并
2. Spring Data JPA查询关联数据
3. P4363 [九省联考2018]一双木棋
4. python 3和python 2 的不同之 f - strings
5. Neo4J(Cypher语句)初识
6. sudo: unable to resolve host 枝桠
7. es7 async 前置依赖
8. 从URL输入到页面展现，过程中发生了什么？
9. teb教程8
10. STL_map