显示问题

对比下结果表生成的SQL

首页
分析平台
门户管理
用户权限
系统管理
运营监控
论坛
帮助
二次开发
您好，超级管理员！
   

       
简体中文

       
繁体中文

       
English


计算


详细信息
        2019-07-11 09:18:24 开始计算报表：nsgmfszfx_jianbiao（内存情况：FREE=283M TOTAL=4.4G MAX=14.1G）
2019-07-11 09:18:24 引用的主题表：SW_SK_SKXX_YUE 税收收入分月主题,SW_GJJ_QYJH 重点行业企业标签,SW_MAP_QYXX 企业法人信息,SW_GJJ_QYJH 重点行业企业标签,SW_MAP_QYXX 企业法人信息,SW_SK_SKXX_YUE 税收收入分月主题
2019-07-11 09:18:24 查询的数据级次范围：受理|筹建期|正常|停业|非正常|清算|注销|非正常户注销|报验|核销报验|中断缴费|恢复缴费|其他。
2019-07-11 09:18:24 正在生成SQL...
2019-07-11 09:18:24 计算表格GRID1
2019-07-11 09:18:24 生成SQL耗时30毫秒
2019-07-11 09:18:24 执行SQL:
select sum(a.SJ_JE_LJ-(CASE WHEN a.ZSXM_DM = '30217' THEN ROUND(a.SJ_JE_LJ,2) ELSE 0 END+CASE WHEN a.ZSXM_DM = '39900' THEN ROUND(a.SJ_JE_LJ,2) ELSE 0 END+CASE WHEN a.ZSXM_DM = '30218' THEN ROUND(a.SJ_JE_LJ,2) ELSE 0 END)) as G3,sum(a.SJ_JE_LJTQ-(CASE WHEN a.ZSXM_DM = '30217' THEN ROUND(a.SJ_JE_LJTQ,2) ELSE 0 END+CASE WHEN a.ZSXM_DM = '39900' THEN ROUND(a.SJ_JE_LJTQ,2) ELSE 0 END+CASE WHEN a.ZSXM_DM = '30218' THEN ROUND(a.SJ_JE_LJTQ,2) ELSE 0 END)) as H3
from SW_SK_SKXX_YUE a
where ((a.NY='201907') AND (a.SWJG_DM LIKE '136019109%'))
2019-07-11 09:18:24 SQL执行完毕，查询出1条数据，耗时：87毫秒（开始时间：2019-07-11 09:18:24.787；结束时间：2019-07-11 09:18:24.874）；其中生成SQL耗时30毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：56毫秒；
2019-07-11 09:18:24 正在生成SQL...
2019-07-11 09:18:24 计算表格GRID1
2019-07-11 09:18:24 生成SQL耗时20毫秒
2019-07-11 09:18:24 执行SQL:
select row_.*,rownum from ( select a.B5 as B5,a.E5 as E5,a.F5 as F5,b.C5 as C5,c.G5 as G5,c.H5 as H5,a.D5 as D5,a.mc_B50 as mc_B50
from (
select a.B5 as B5,b.E5 as E5,b.F5 as F5,a.D5 as D5,a.mc_B50 as mc_B50
from (
select max(a.XZQH_DM) as B5,a.TYSHXYDM as D5,max(b.MC) as mc_B50
from SW_MAP_QYXX a
,SW_SK_SKXX_YUE c
,SW_DM_XZQH b
where (C.TYSHXYDM(+)=A.FRDM) and (A.XZQH_DM=B.TYDM(+)) and ((c.NY='201907') AND (c.SWJG_DM LIKE '136019109%'))
group by a.TYSHXYDM) a
,(
select max(a.NSRMC) as E5,max(a.HYML_MC) as F5,a.TYSHXYDM as D5
from SW_SK_SKXX_YUE a
where ((a.NY='201907') AND (a.SWJG_DM LIKE '136019109%'))
group by a.TYSHXYDM) b
where (A.D5=B.D5(+))) a
,(
select max(a.SWJG_DM||' '||a.SWJG_MC) as C5,a.TYSHXYDM as D5
from SW_SK_SKXX_YUE a
where ((a.NY='201907') AND (a.SWJG_DM LIKE '国家税务总局南昌市税务局%') AND (a.SWJG_DM LIKE '136019109%'))
group by a.TYSHXYDM) b
,(
select sum(a.SJ_JE_LJ-(CASE WHEN a.ZSXM_DM = '30217' THEN ROUND(a.SJ_JE_LJ,2) ELSE 0 END+CASE WHEN a.ZSXM_DM = '39900' THEN ROUND(a.SJ_JE_LJ,2) ELSE 0 END+CASE WHEN a.ZSXM_DM = '30218' THEN ROUND(a.SJ_JE_LJ,2) ELSE 0 END)) as G5,sum(a.SJ_JE_LJTQ-(CASE WHEN a.ZSXM_DM = '30217' THEN ROUND(a.SJ_JE_LJTQ,2) ELSE 0 END+CASE WHEN a.ZSXM_DM = '39900' THEN ROUND(a.SJ_JE_LJTQ,2) ELSE 0 END+CASE WHEN a.ZSXM_DM = '30218' THEN ROUND(a.SJ_JE_LJTQ,2) ELSE 0 END)) as H5,a.TYSHXYDM as D5
from SW_SK_SKXX_YUE a
where ((a.NY='201907') AND (a.SWJG_DM LIKE '136019109%'))
group by a.TYSHXYDM) c
where (A.D5=B.D5(+)) and (A.D5=C.D5(+))
order by c.G5 desc nulls last )row_ where rownum <= 100
2019-07-11 09:18:25 执行SQL:
select count(*) as cn_
from (
select a.B5 as B5
from (
select a.B5 as B5,b.E5 as E5,b.F5 as F5,a.D5 as D5,a.mc_B50 as mc_B50
from (
select max(a.XZQH_DM) as B5,a.TYSHXYDM as D5,max(b.MC) as mc_B50
from SW_MAP_QYXX a
,SW_SK_SKXX_YUE c
,SW_DM_XZQH b
where (C.TYSHXYDM(+)=A.FRDM) and (A.XZQH_DM=B.TYDM(+)) and ((c.NY='201907') AND (c.SWJG_DM LIKE '136019109%'))
group by a.TYSHXYDM) a
,(
select max(a.NSRMC) as E5,max(a.HYML_MC) as F5,a.TYSHXYDM as D5
from SW_SK_SKXX_YUE a
where ((a.NY='201907') AND (a.SWJG_DM LIKE '136019109%'))
group by a.TYSHXYDM) b
where (A.D5=B.D5(+))) a) a
2019-07-11 09:18:25 SQL执行完毕，查询出330条数据，耗时：339毫秒（开始时间：2019-07-11 09:18:24.874；结束时间：2019-07-11 09:18:25.213）；其中生成SQL耗时20毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：209毫秒；执行计数sql耗时：107毫秒；
2019-07-11 09:18:25 执行查询耗时434毫秒。（内存情况：FREE=277.5M TOTAL=4.4G MAX=14.1G）
2019-07-11 09:18:25 构造结果表耗时16毫秒。
2019-07-11 09:18:25 计算“nsgmfszfx_jianbiao”耗时451毫秒。（内存情况：FREE=274M TOTAL=4.4G MAX=14.1G）

应该是显示问题吧，sql有计算

把这个sql放到数据库中去执行是有数据的？？然后在前台不显示，是这个意思吗？

是会执行，请问您可以远程看下这个问题吗？我怕我描述不清

会执行是什么意思呢，刚刚遇到一个问题是mysql没设置编码格式 导致前台数据没显示的
你把结果表的sql放到数据库中去执行  征收机关有没有数据  如果数据库中去执行也没有数据的话  那前台的效果就是正确的。

我大概查到了

截图201907111031423514.png (51.07 KB, 下载次数: )

下载附件

2019-7-11 10:31 上传

截图201907111032012788.png (5.68 KB, 下载次数: )

下载附件

2019-7-11 10:32 上传

您看下，我这边对应的是传来的id还是会自己计算一个汉字出来

如果是主题表关联了的维表的话 可以直接用dim(XXB.bbq)=@bbq这种写法 或者是把@zsjg后面的id去掉试试

关键是主题表没有关联维表他也可以筛选

也没有任何筛选条件，计算结果表删了