sanya-data-management-back/sql/pgsql/0_init.sql

-- 7.24

-- 8.8
-- 添加表
-- vector.TB_CZKFBJ_ONE
-- vector.TB_GYX
-- vector.TB_FJFW
-- 同步数据
-- base.t_fzss_fzxz_sjy
-- base.t_fzss_fzxz_factor_temp
-- base.t_fzss_fzxz_factor
-- base.t_fzss_fzxz_factor_use


--8.13
UPDATE base.t_jsc_sql
SET jsc_sql='SELECT round(coalesce(sum(zy_gdmj),0),2)zy_gdmj,round(coalesce(sum(zy_st),0),2) zy_st,round(coalesce(sum(zy_cn),0)/1000,2) zy_cn, round(coalesce(sum(cb_gdmj),0),2) cb_gdmj,round(coalesce(sum(cb_st),0),2) cb_st,round(coalesce(sum(cb_cn),0)/1000,2) cb_cn, #{id} as id ,#{begin_time} as create_time FROM vector.gdbh_zbph x where xzqhdm like #{id}||''%'' AND pzrq >= #{begin_time} AND pzrq < #{end_time}'
-- 同步数据
-- base.t_fzss_fzxz_factor_temp
-- base.t_fzss_fzxz_factor