<!-- 线下还款处理搜索分页列表(财务管理模块)--><select id="queryOfflineRepay" resultType="com.i78dk.saasfinancecloud.inter.dto.RepayDto">
SELECT
u.user_name loanUserName,
fbr.id id,
fbr.bill_id billId,
fbr.order_id orderId,
m.merchant_name merchantName,
cgb.`name` productCategoryName,
o.audit_money loanAmount,
fbb.bill_number billNumber,
fbb.period billPeriod,
fbb.principal principal,
fbb.interest interest,
fbb.add_amount addAmount,
fbb.overdue_fee overdueFee,<!--总计应还=每期本金+每期利息+本期平台服务费+逾期手续费 -->CEIL(fbb.principal+fbb.interest+fbb.add_amount+fbb.overdue_fee) shouldPay,
fbb.status_overdue overdueStatus,
fbb.status_repay repayStatus,
fbr.create_time createTime
FROM fc_bm_repay fbr
left join `order` o on fbr.order_id = o.id
left join order_extend oe on o.id = oe.order_id
left join merchant m on o.merchant_id = m.id
left join `user` u on o.user_id = u.id
left join cp_goods_baseinfo cgb on oe.goods_id = cgb.id
left join fc_bm_bill fbb on o.id = fbb.order_id
where fbr.repay_type ='offline'<if test ="searchKey != null and searchKey != '' ">
AND (o.order_no = #{searchKey} OR u.real_name = #{searchKey} OR u.mobile = #{searchKey})</if><if test ="repayTimeStart != null">
AND fbr.repay_time <![CDATA[>=]]>DATE_FORMAT(#{repayTimeStart},'%Y-%m-%d')</if><if test ="repayTimeEnd != null">
AND fbr.repay_time <![CDATA[<=]]>DATE_FORMAT(#{repayTimeEnd},'%Y-%m-%d')</if>
ORDER BY fbr.repay_time DESC
</select>