You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

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.financing_end_time @} from bank_acceptance_bill t join financings t2 on t.financing_id = t2.id where 1 = 1 #use("queryCondition")# @ if(!isEmpty(buyerName)){ and t.buyer_name like #'%'+buyerName+'%'#
@}

查询可新增发货的银行承兑汇票

select t.invoice_no, t.invoice_time, t.invoice_amount, t.buyer_id, t.buyer_name, t.seller_id, t.seller_name, t2.contract_no, t2.contract_id, t2.contract_amount, t2.financing_end_time, t3.express_id, t3.express_name, t3.bank_id, t3.bank_name, t3.protocol_no, t3.id protocol_id, t4.corporation seller_corporation from bank_acceptance_bill t join financings t2 on t.financing_id = t2.id join protocols t3 on t3.contract_id = t2.contract_id
join materials t4 on t4.id = t3.seller_id left join send_products t5 on t5.contract_id = t2.contract_id where t5.contract_id is null #use("queryCondition")#