SELECT
a.fiscal_year,
a.tenant_id,
a.mof_dep_code,
a.bgt_id,
bbi.cor_bgt_doc_no,
a.agency_code,
a.pro_code,
a.pro_name,
a.fund_type_code,
a.exp_func_code,
a.gov_bgt_exp_eco_code,
a.gov_bgt_eco_code,
a.pay_type_code,
a.set_mode_code,
bbi.amount,
a.actual_payee_account_bank AS '收款方银行代码',
a.actual_payee_account_bank AS '收款方银行名称',
a.actual_payee_acct_no,
a.actual_payee_account_name,
NULL AS '付款方银行代码',
a.payer_open_bank,
a.payer_acc_no,
a.payer_name,
NULL AS '付款方账户类型代码',
a.pay_cert_id,
a.pay_cert_no,
a.ori_vou_bid,
a.pay_amt,
a.act_pay_date,
a.use_fund,
NULL AS '系统标识',
UNIX_TIMESTAMP( NOW( ) ),
JSON_EXTRACT ( bbi.manage_categories, '$.isPovery' ),
JSON_EXTRACT ( bbi.manage_categories, '$.isDirectFund' ),
JSON_EXTRACT ( bbi.manage_categories, '$.isIndAndEnterSub' ),
JSON_EXTRACT ( bbi.manage_categories, '$.isDirectAndSuppFund' )
FROM
(
SELECT
pvb.*
FROM
pay_voucher_bill pvb
INNER JOIN pay_voucher pv ON pvb.pay_cert_id = pv.pay_cert_id
WHERE
pvb.pay_cert_id NOT IN ( SELECT pay_cert_id FROM pay_voucher_bill WHERE JSON_EXTRACT ( extend, '$."PovertyAlleviationStatus"' ) = '1' )
AND pvb.is_delete = 0
AND pvb.is_deleted = 0
AND pv.is_delete = 0
AND pv.is_deleted = 0
AND pvb.clear_date IS NOT NULL
AND pvb.vt_status = '12'
) AS a,
bmp_quota.ba_bgt_info AS bbi
WHERE
bbi.bgt_id = a.bgt_id
AND is_delete = 0
