<?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.fjhx.account.mapper.tax.TaxRefundDetailsMapper">
    <select id="getPage" resultType="com.fjhx.account.entity.tax.vo.TaxRefundDetailsVo">
        select trd.id,
               trd.account_running_water_id,
               trd.contract_id,
               trd.amount,
               trd.create_user,
               trd.create_time,
               trd.update_user,
               trd.update_time
        from tax_refund_details trd
            ${ew.customSqlSegment}
    </select>

    <select id="getSumMoneyByContractIds" resultType="com.fjhx.account.entity.tax.po.TaxRefundDetails">
        SELECT
            t1.*,
            t2.rate AS rate,
            t2.currency AS currency
        FROM
            tax_refund_details t1
        LEFT JOIN account_running_water t2 ON t1.account_running_water_id = t2.id
            ${ew.customSqlSegment}
    </select>
</mapper>
