<?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.account.AccountPaymentMapper">
    <select id="getPage" resultType="com.fjhx.account.entity.account.vo.AccountPaymentVo">
        select ap.*
        from account_payment ap
            ${ew.customSqlSegment}
    </select>
    <select id="detail" resultType="com.fjhx.account.entity.account.po.AccountPayment">
        select ap.id,
               ap.tenant_id,
               ap.account_management_id,
               ap.department_id,
               ap.corporation_id,
               ap.business_id,
               ap.expenses_time,
               ap.currency,
               ap.payment_time,
               ap.amount,
               ap.status,
               ap.type,
               ap.remark,
               ap.create_user,
               ap.create_time,
               ap.update_user,
               ap.payment_remark,
               ap.update_time,

               ap.payment_method,
               ap.income_amount,
               ap.name,
               ap.business_management_id,
               ap.opening_bank,
               ap.business_currency,
               ap.account_opening,
               ap.interbank_number
        from account_payment ap
        where ap.id = #{id}
    </select>

</mapper>
