RTSELECT
y.kh_type,
y.kh_userid,
f_get_wlzid(y.kh_type,
y.kh_userid,
'2015-07-20 00:00:00',
'2015-09-14 23:59:59',
'0') qcjeid,
(case
when (SELECT fs_datetime
FROM kh_khwlzye
WHERE zkfx = '0'
AND khid = y.kh_userid) BETWEEN
'2015-07-20 00:00:00' AND
'2015-09-14 23:59:59' THEN
''
ELSE
f_get_wlzid(y.kh_type,
y.kh_userid,
'2015-07-20 00:00:00',
'2015-09-14 23:59:59',
'1')
END) qmyeid,
SUM(decode(y.sz_type, '1', y.szje, 0)) jffse,
SUM(decode(y.sz_type, '2', y.szje, 0)) dffse,
SUM(decode(y.yc_type, '1', y.yc_szje, 0)) yc_jffse,
SUM(decode(y.yc_type, '2', y.yc_szje, 0)) yc_dffse,
SUM(decode(y.bxyc_type,
'1',
nvl(y.bxyc_szje, 0),
0)) bxyc_jffse,
SUM(decode(y.bxyc_type,
'2',
nvl(y.bxyc_szje, 0),
0)) bxyc_dffse,
SUM(y.XYZJ) XYZJ,
SUM(y.XYJS) XYJS,
SUM(decode(y.dj_type,
'2',
-y.dj_szje,
y.dj_szje)) dj_szje
FROM ys_wlz y
WHERE 1 = 1
and fs_datetime >= '2015-07-20 00:00:00'
and fs_datetime ='2015-07-20 00:00:00' AND "FS_DATETIME"复制代码
|