1.1 KiB
queryCondition
-
查询条件
@if(!isEmpty(examinationId)){ and t.examination_id =#examinationId# @} @if(!isEmpty(flowId)){ and t.flow_id =#flowId# @}
pageQueryByCondition
-
分页查询
select @pageTag(){ t.*, t2.accept_no, t2.bank_name, t2.apply_amount, t2.bail_amount, t2.contract_id, t2.contract_amount @} from assure t join financings t2 on t2.id = t.financing_id where 1 = 1 #use("queryCondition")# @ if(!isEmpty(expressName)){ and t.express_name like #'%'+expressName+'%'# @} @ if(!isEmpty(buyerName)){ and t.buyer_name like #'%'+buyerName+'%'#
@}
getNewAssureFinancingList
- 可以签订质押合同的融资申请
select t.id financing_id, t.financing_end_time assure_end_time, t.bail_amount, t.bail_rate, t.accept_no, t.bank_id, t.bank_name, t.buyer_id, t.buyer_name, t.contract_amount, t.apply_amount, t3.express_id, t3.express_name, t4.credit_level buyer_credit_level from financings t left join assure t2 on t2.financing_id = t.id join protocols t3 on t.protocol_id = t3.id join materials t4 on t4.id = t.buyer_id where t2.financing_id is null #use("queryCondition")#