①通过sql语句来获取
select to_char(sysdate, 'yyyy') || '-' || #{type} || '-' ||
lpad(count(*), 6, 0)
from table1 t
where t.type_id = #{type}
and (t.first_audit_time is not null or t.final_audit_time is not null)
①通过sql语句来获取
select to_char(sysdate, 'yyyy') || '-' || #{type} || '-' ||
lpad(count(*), 6, 0)
from table1 t
where t.type_id = #{type}
and (t.first_audit_time is not null or t.final_audit_time is not null)