-- 直接支付
SELECT
pvb.pay_cert_no,
pvb.create_time,
pvb.agency_code,
pvb.pay_summary,
pvb.pay_amt,
pvb.bgt_id,
bbi.summary,
pvb.exp_func_code,
pvb.exp_func_name,
pvb.dep_bgt_eco_code,
pvb.dep_bgt_eco_name,
pvb.set_mode_code,
pvb.set_mode_name,
pvb.pay_type_code,
pvb.pay_type_name,
pvb.payee_acct_name,
bbi.pro_code,
bbi.pro_name,
bbi.pro_cate_code,
bbi.pro_cate_name
FROM
pay_voucher_bill pvb,
bmp_quota.ba_bgt_info bbi
WHERE
pvb.bgt_id = bbi.bgt_id
AND pvb.pay_cert_id IN ( SELECT pay_cert_id FROM pay_voucher_bill WHERE JSON_EXTRACT ( extend, '$."PayStatus"' ) = '1' )
AND pvb.is_delete = 0
AND pvb.is_deleted = 0
AND pvb.clear_date IS NOT NULL
AND pvb.vt_status = '12'
AND bbi.is_deleted = 0
and pvb.pay_type_code like '%11'
-- 授权支付
SELECT
pvb.pay_cert_no,
pvb.create_time,
pvb.agency_code,
pvb.pay_summary,
pvb.pay_amt,
pvb.bgt_id,
bbi.summary,
pvb.exp_func_code,
pvb.exp_func_name,
pvb.dep_bgt_eco_code,
pvb.dep_bgt_eco_name,
pvb.set_mode_code,
pvb.set_mode_name,
pvb.pay_type_code,
pvb.pay_type_name,
pvb.payee_acct_name,
bbi.pro_code,
bbi.pro_name,
bbi.pro_cate_code,
bbi.pro_cate_name
FROM
pay_voucher_bill pvb,
bmp_quota.ba_bgt_info bbi
WHERE
pvb.bgt_id = bbi.bgt_id
AND pvb.pay_cert_id IN ( SELECT pay_cert_id FROM pay_voucher_bill WHERE JSON_EXTRACT ( extend, '$."PayStatus"' ) = '1' )
AND pvb.is_delete = 0
AND pvb.is_deleted = 0
AND pvb.clear_date IS NOT NULL
AND pvb.vt_status = '12'
AND bbi.is_deleted = 0
and pvb.pay_type_code like '%12'
