areatext中间不能加空格
areatext中间不能加空格;
js出错看行数时，用看源代码；
?^p，ue里加空格时用这个；
?
CREATE OR REPLACE VIEW V_ACDM_CHARGE_STAT AS
select R.RK,
?????? R.ID,
?????? R.FLOW_ID, --流程id
?????? R.CHARGE, --罪名id
?????? R.AMOUNT, --金额
?????? R.FLAG, --状态
?????? R.TACHE_ID, --环节id
?????? R.OTHER_CHARGE, --其他罪名
?????? D.CHARGE_NAME --罪名名称
? from (select rank() over(partition by T.TACHE_ID order by T.ID ASC) rk,
?????????????? T.*
????????? from t_acdm_charge_info T
???????? WHERE T.FLAG IS NULL) R,
?????? T_ACDM_CHARGE_DIC D
?where R.CHARGE = D.ID
?? AND R.rk = 1
UNION ALL
SELECT R.RK,
?????? R.ID,
?????? R.FLOW_ID, --流程id
?????? R.CHARGE, --罪名id
?????? R.AMOUNT, --金额
?????? R.FLAG, --状态
?????? R.TACHE_ID, --环节id
?????? R.OTHER_CHARGE, --其他罪名
?????? D.CHARGE_NAME --罪名名称
? FROM (select rank() over(partition by T.TACHE_ID order by T.FLAG DESC, T.ID ASC) rk,
?????????????? T.*
????????? from t_acdm_charge_info T
???????? WHERE T.FLAG IS NOT NULL) R,
?????? T_ACDM_CHARGE_DIC D
?where R.CHARGE = D.ID
?? AND R.rk = 1;
