1.6 KiB
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")#