Supply_chain_finance/web/target/classes/sql/flow/contractsFactoring.md

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+'%'#
  @} @ if(!isEmpty(sellerId)){ and t.seller_id like #'%'+sellerId+'%'# @} @ if(!isEmpty(buyerId)){ and t.buyer_id like #'%'+buyerId+'%'#
  @} @ if(!isEmpty(contractStartTime)){ and t.contract_time >= #contractStartTime#
  @} @ if(!isEmpty(contractEndTime)){ and t.contract_time <= #contractEndTime#
  @} @ if(!isEmpty(contractStatus)){ and t.contract_status = #contractStatus#
  @}

pageQueryByCondition

• 正向保理分页查询

  select @pageTag(){ t.*, t2.accept_amount, t2.contract_no, t2.contract_id, t2.yfzk_amount, t2.financing_end_time, t2.financing_start_time @} from contracts_factoring t join financings t2 on t.accept_no = t2.accept_no where 1 = 1 #use("queryCondition")#

fxblPageQueryByCondition

• 反向保理分页查询

  select @pageTag(){ t.*, t2.yfzk_amount @} from contracts_factoring t join recommend_supplier t2 on t.contract_id = t2.contract_id where 1 = 1 #use("queryCondition")#

queryByCondition

• 不分页查询

  select t.* from contracts_factoring t where 1 = 1 #use("queryCondition")#

yszkApplyList

• 可新增应收账款转移的保理合同列表

  select t.* from contracts_factoring t left join yszk_transfer t2 on t2.bl_contract_no = t.bl_contract_no where t2.bl_contract_no is null #use("queryCondition")#