fj-dc/.svn/pristine/3a/3a979fea69c26e7609031fd4e164b88f4d3e50ae.svn-base

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.com.goldenwater.dcproj.dao.IndexTotalQhJcDao">

    <select id="getObjPblmData" resultType="java.util.Map">
        SELECT
        R.ID AS RGSTR_ID,
        R.NAME,
        R.AD_CODE,
        A.ID,
        A.LIST_TYPE,
        A.PBLM_PASI,
        A.INTM
        FROM
        TAC_INSP_YEAR_BATCH_OBJ O
        LEFT JOIN TAC_PAWP_RGSTR R ON O.ID = R.OBJ_ID
        LEFT JOIN TAC_PROVINCE_PBLM_INFO A ON A.RGSTR_ID = R.ID
        <where>
            <if test="province != null and province != ''">AND AD_CODE LIKE '${province}%'</if>
            <if test="year != null and year != ''">and O.YEAR = #{year}</if>
            <if test="batch != null and batch != ''">and O.BATCH = #{batch}</if>
            <if test="adCode != null and adCode != ''">and R.AD_CODE LIKE '${adCode}%'</if>
            <if test="sttm != null">and A.INTM &gt;= #{sttm}</if>
            <if test="entm != null">and A.INTM &lt; DATE_ADD(#{entm}, INTERVAL 1 DAY )</if>
        </where>
    </select>

    <select id="getJCStepId" resultType="String">
        SELECT NOW_ID
        FROM TAC_PROVINCE_PLAN_PROCESS
        WHERE NEXT_ID = '1'
        <if test="orgId != null and orgId != ''">AND ORG_ID = #{orgId}</if>
        <if test="province != null and province != ''">AND AD_CODE LIKE '${province}%'</if>
    </select>
</mapper>