欢迎使用CSDN-markdown编辑器

最新推荐文章于 2021-01-07 23:01:28 发布

Ve_Sevan

最新推荐文章于 2021-01-07 23:01:28 发布

阅读量213

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/Ve_Sevan/article/details/77851078

版权

java 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

<select id="queryLists" parameterClass="hashmap" resultClass="hashmap">
        SELECT
            A.CONFIG_ID,
            A.NUM,
            A.PNUM,
            A.FIELD_NAME,
            A.FIELD_CODE,
            A.FIELD_TYPE,
            A.LIST_SHOW,
            A.FORM_SHOW,
            A.IS_REQUIRED,
            A.SORT_NO
        FROM
            B_FORM_DATA_CONFIG A
        WHERE
            1 = 1
        AND
            A.PNUM LIKE #pnum# + '%'
        <isNotNull property="name">
            <isNotEmpty property="name">
                AND A.FIELD_NAME LIKE '%' + #name# + '%'
            </isNotEmpty>
        </isNotNull>
        <isNotNull property="code">
            <isNotEmpty property="code">
                AND A.FIELD_CODE LIKE '%' + #code# + '%'
            </isNotEmpty>
        </isNotNull>
        ORDER BY A.$sortField$ $sortOrder$      
    </select>

<select id="queryList" resultType="java.util.Map">
          SELECT 
            A.CONTRACT_ID,
            A.CONTRACT_NUM,
            C.VNAME AS SUPPLY_NAME,
            A.CREATE_DATE,
            B.VNAME_CH AS CURRENCY_CH,
            D.PERSON_NAME AS SALES,
            E.PERSON_NAME AS OPERA,
            A.STATUS,
            F.TMONEY
          FROM TW_CONTRACT A
          LEFT JOIN TW_DIC_CURRENCY B ON A.CURRENCY_ID = B.CURRENCY_ID
          LEFT JOIN TW_DIC_SUPPLY C ON A.SUPPLY_ID = C.SUPPLY_ID
          LEFT JOIN TW_DIC_PERSON D ON A.SALESMAN_ID = D.PERSON_ID
          LEFT JOIN TW_DIC_PERSON E ON A.OPERATOR_ID = E.PERSON_ID
          LEFT JOIN (
            SELECT 
                CONTRACT_ID,
                SUM(TOTALMONEY) AS TMONEY 
            FROM 
                TW_CONTRACT_DETAIL 
            GROUP BY 
                CONTRACT_ID
            ) F ON A.CONTRACT_ID = F.CONTRACT_ID
          WHERE
            1=1
            <if test="params.CONTRACT_NUM !=null and params.CONTRACT_NUM != ''">
                AND A.CONTRACT_NUM LIKE '%'+#{params.CONTRACT_NUM}+'%'
            </if>
            <if test="params.SUPPLY_NAME !=null and params.SUPPLY_NAME != ''">
                AND C.VNAME LIKE '%'+#{params.SUPPLY_NAME}+'%'
            </if>
            <if test="params.STATUS !=null and params.STATUS != ''">
                AND A.STATUS=#{params.STATUS}
            </if>
            <if test="params.DATE_START !=null and params.DATE_START != ''">
                <![CDATA[AND CREATE_DATE>=#{params.DATE_START}]]>
            </if>
            <if test="params.DATE_END !=null and params.DATE_END != ''">
                <![CDATA[AND CREATE_DATE<=#{params.DATE_END}]]>
            </if> 
    </select>