13092399373(提问者)select month,shbm,dkdate,sqrmc,bmmc,kmmc,cwmoney,proportion from (select e.name as shbm,
a.month,
a.sqr,
a.DKDATE,
b.name as sqrmc,
a.bm,
c.name as bmmc,
a.km,
d.EN_NAME as kmmc,
a.cwmoney,
f.totalcwmoney,
round(decode(a.cwmoney,0,0,a.cwmoney/f.totalcwmoney),4) as proportion
from (select month,sqr, bm, km, sum(cwmoney) as cwmoney,DKDATE
from v_staff_costs_items
where 1=1
${IF (len (开始时间) == 0,\"\",\"and to_char(DKDATE,\'YYYY/MM/DD\') >=\'\" + 开始时间 +\"\'\") }
${IF (len (结束时间) == 0,\"\",\"and to_char(DKDATE,\'YYYY/MM/DD\') <= \'\" + 结束时间+ \"\'\")}
group by sqr, bm, km,DKDATE,month) a
inner join ORG_MEMBER b
on a.sqr = b.id
and b.IS_ENABLE = 1
and b.is_deleted = 0
inner join ORG_UNIT e
on b. ORG_DEPARTMENT_ID = e.id
inner join ORG_UNIT c
on a.bm = c.id
inner join vya_enum d
on a.km = d.ID
inner join (select bm, sum(cwmoney) as totalcwmoney
from v_staff_costs_items where 1=1
group by bm) f
on a.bm = f.bm
order by a.bm) where 1=1
${IF (len (开始时间) == 0,\"\",\"and to_char(DKDATE,\'YYYY/MM/DD\') >=\'\" + 开始时间 +\"\'\") }
${IF (len (结束时间) == 0,\"\",\"and to_char(DKDATE,\'YYYY/MM/DD\') <= \'\" + 结束时间+ \"\'\")}
${if(len(所属部门)==0,\"\",\"and shbm in (\'\"+SUBSTITUTE(所属部门,\",\",\"\',\'\")+\"\')\")}
${if(len(费用部门)==0,\"\",\"and bmmc in (\'\"+SUBSTITUTE(费用部门,\",\",\"\',\'\")+\"\')\")}
${if(len(人员)==0,\"\",\"and sqrmc in (\'\"+SUBSTITUTE(人员,\",\",\"\',\'\")+\"\')\")}
1min目标场景问卷
立即参与
