2021-03-19

UPDATE bmp_payment.pay_appr_apply set is_direct_fund='1' WHERE ind_bid in (

SELECT bgt_id FROM bmp_quota.ba_bgt_info WHERE  manage_categories ->>'$.isDirectFund' !='09' and manage_categories ->>'$.isDirectFund' !=''

) and is_direct_fund is null;

UPDATE bmp_payment.pay_appr_apply set is_direct_fund='1' WHERE ind_bid in (

SELECT manage_categories ->>'$.isDirectFund',bgt_id FROM bmp_quota.ba_bgt_info WHERE manage_categories ->>'$.isDirectFund' is null or manage_categories ->>'$.isDirectFund' ='' or manage_categories ->>'$.isDirectFund' ='09'

) and is_direct_fund is null;