1.2 KiB
queryCondition
-
查询条件
@if(!isEmpty(examinationId)){ and t.examination_id =#examinationId# @} @if(!isEmpty(flowId)){ and t.flow_id =#flowId# @} @ if(!isEmpty(sellerName)){ and t.seller_name like #'%'+sellerName+'%'# @} @ if(!isEmpty(buyerName)){ and t.buyer_name like #'%'+buyerName+'%'#
@}
pageQueryByCondition
-
分页查询
select @pageTag(){ t.*, t2.accept_no, t3.contract_no @} from contracts_pledge t join financings t2 on t.financing_id = t2.id join contracts_purchase_sales t3 on t.contract_id = t3.id where 1 = 1 #use("queryCondition")#
contractsPledgeApplyList
- 可以签订质押合同的融资申请
select t.accept_no, t.bank_name, t.bank_id, t.yfzk_amount yszk_amount, t.financing_start_time, t.id financing_id, t3.id contract_id, t3.contract_no, t3.pay_time, t3.seller_name, t3.buyer_name, t3.seller_id, t3.buyer_id, t5.accept_time from financings t left join contracts_pledge t2 on t2.financing_id = t.id join contracts_purchase_sales t3 on t3.id = t.contract_id join send_products t5 on t5.contract_id = t3.id where t2.financing_id is null #use("queryCondition")#