-- 7.24

-- Auto-generated SQL script #202407240932
UPDATE base.t_jsc_sql
SET jsc_sql='select #{id} as id, coalesce( t.xmsl,0) xmsl,round(coalesce( t.sdfw,0),2) sdfw,round(coalesce( t.tzje,0)/10000,2) tzje,round(coalesce( t.mj,0),2) mj from ( select sum(xmsl) xmsl,sum(mj) mj,sum(sdfw) sdfw,sum(tzje) tzje FROM vector."AFTER_TDZZHZ" x where xzqdm like #{id}||''%'' )t '
WHERE id='7a8b3776-048a-4b7a-b231-506d9da308c0';

UPDATE base.t_jsc_sql
SET jsc_sql='select t0.*, #{id} as id, #{begin_time} as create_time from ( select count(*) sj_number, round(coalesce(sum(x.ydmj),0)/1000000,2) sj_mj from vector."AFTER_BJXM_SZ" x where xzqdm like #{id} || ''%'' and x.bpsj >= #{begin_time} and x.bpsj< #{end_time})t0'
WHERE id='b84ae1b9-1bc1-4154-a070-561a42a24fbd';