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.
69 lines
1.6 KiB
Markdown
69 lines
1.6 KiB
Markdown
2 years ago
|
queryCondition
|
||
|
|
===
|
||
|
|
|
||
|
|
* 查询条件
|
||
|
|
|
||
|
|
@if(!isEmpty(examinationId)){
|
||
|
|
and t.examination_id =#examinationId#
|
||
|
|
@}
|
||
|
|
@if(!isEmpty(flowId)){
|
||
|
|
and t.flow_id =#flowId#
|
||
|
|
@}
|
||
|
|
@ if(!isEmpty(inWarehouseStatus)){
|
||
|
|
and t.in_warehouse_status like #'%'+inWarehouseStatus+'%'#
|
||
|
|
@}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
pageQueryByCondition
|
||
|
|
===
|
||
|
|
|
||
|
|
* 分页查询
|
||
|
|
|
||
|
|
select
|
||
|
|
@pageTag(){
|
||
|
|
t.*,
|
||
|
|
t2.bank_name, t2.express_id, t2.express_name, t2.buyer_name,
|
||
|
|
t3.pickup_apply_amount, t3.had_pickup_amount,
|
||
|
|
t4.corporation seller_corporation,
|
||
|
|
t5.financing_no
|
||
|
|
@}
|
||
|
|
from warehouse_shipment t
|
||
|
|
join protocols t2 on t2.id = t.protocol_id
|
||
|
|
join pickup_products t3 on t3.id = t.pickup_product_id
|
||
|
|
join materials t4 on t4.id = t2.seller_id
|
||
|
|
join financings t5 on t5.id = t3.financing_id
|
||
|
|
where 1 = 1
|
||
|
|
#use("queryCondition")#
|
||
|
|
@ if(!isEmpty(sellerName)){
|
||
|
|
and t2.seller_name like #'%'+sellerName+'%'#
|
||
|
|
@}
|
||
|
|
@ if(!isEmpty(buyerName)){
|
||
|
|
and t2.buyer_name like #'%'+buyerName+'%'#
|
||
|
|
@}
|
||
|
|
@ if(!isEmpty(outWarehouseStatusGreater)){
|
||
|
|
and t.out_warehouse_status > #outWarehouseStatusGreater#
|
||
|
|
@}
|
||
|
|
|
||
|
|
|
||
|
|
getNewPickupShipmentPage
|
||
|
|
===
|
||
|
|
|
||
|
|
* 分页查询可新增出库发货的提货申请
|
||
|
|
|
||
|
|
select
|
||
|
|
@pageTag(){
|
||
|
|
t.pickup_apply_amount, t.pickup_no, t.id pickup_product_id,
|
||
|
|
t.pickup_time, t.pickup_bank_file, t.had_pickup_amount,
|
||
|
|
t2.seller_name, t2.bank_name, t2.express_name, t2.buyer_name,
|
||
|
|
t2.express_id,t2.seller_id, t2.bank_id, t2.protocol_no, t2.id protocol_id,
|
||
|
|
t4.corporation seller_corporation
|
||
|
|
@}
|
||
|
|
from pickup_products t
|
||
|
|
join protocols t2 on t2.id = t.protocol_id
|
||
|
|
left join warehouse_shipment t3 on t3.pickup_product_id = t.id
|
||
|
|
join materials t4 on t4.id = t2.seller_id
|
||
|
|
where t.pickup_status = 9
|
||
|
|
and t3.pickup_product_id is null
|
||
|
|
#use("queryCondition")#
|