<?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="com.ruoyi.ibs.list.mapper.ImportantInfoLoan932Mapper">

    <resultMap id="ImportantInfoLoan932Result" type="com.ruoyi.ibs.list.domain.ImportantInfoLoan932">
        <result property="custId" column="cust_id"/>
        <result property="custIsn" column="cust_isn"/>
        <result property="contractNo" column="contract_no"/>
        <result property="conStartDt" column="con_start_dt"/>
        <result property="conEndDt" column="con_end_dt"/>
        <result property="loanBal" column="loan_bal"/>
        <result property="loanRate" column="loan_rate"/>
        <result property="assureWay" column="assure_way"/>
        <result property="loanPurpose" column="loan_purpose"/>
        <result property="orgCode" column="org_code"/>
        <result property="dataDate" column="data_date"/>
    </resultMap>

    <select id="selectByCustId" resultMap="ImportantInfoLoan932Result">
        select cust_id,
               cust_isn,
               contract_no,
               con_start_dt,
               con_end_dt,
               loan_bal,
               loan_rate,
               assure_way,
               loan_purpose,
               org_code,
               data_date
        from important_info_list_for_loan_932
        where cust_id = #{custId}
        order by data_date desc, contract_no desc
    </select>

</mapper>
