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.
56 lines
1.2 KiB
Markdown
56 lines
1.2 KiB
Markdown
2 years ago
|
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")#
|