-
-
进阶的小木桩 数据达人Lv4
发表于2019-11-18 15:31
悬赏50
已解决
楼主
本帖最后由 进阶的小木桩 于 2019-11-18 18:50 编辑
select c.subnet_name subnet_name,c.subnet_id subnet_id,d.file_date file_date,d.sum sum from subnet_view c
left join
(
select a.subnet_id,a.subnet_name,b.file_date file_date,count(1) sum from subnet_view a join
eva_equip_threephase_exceptional<#='_'+left(@pday,4)#> b on a.subnet_id = substring(b.subnet_id,1,6)
where a.parent_code ='<#=@sq2#>'
and (file_date>=str_to_date('<#=if(@m,@m+'01',@pday#>','%Y%m%d') and file_date<str_to_date('<#=if(@m,offsetdate(@m,0,1,0),offsetdate(@pday,0,0,1))#>','%Y%m%d'))
group by a.subnet_id,b.file_date
union
select a.subnet_id,a.subnet_name,b.file_date file_date,count(1) sum from subnet_view a join
eva_equip_threephase_exceptional<#='_'+left(@pday,4)#> b on a.subnet_id = b.subnet_id
where a.parent_code='<#=@sq2#>'
and (file_date>=str_to_date('<#=if(@m,@m+'01',@pday#>','%Y%m%d') and file_date<str_to_date('<#=if(@m,offsetdate(@m,0,1,0),offsetdate(@pday,0,0,1))#>','%Y%m%d'))
group by a.subnet_id,b.file_date
) d on c.subnet_id = d.subnet_id
where c.parent_code='<#=@sq2#>'
这个语句，@m是前一个页面钻取时的日期参数，@pday是日期组件的参数。
select c.subnet_name subnet_name,c.subnet_id subnet_id,d.file_date file_date,d.sum sum from subnet_view c
left join
(
select a.subnet_id,a.subnet_name,b.file_date file_date,count(1) sum from subnet_view a join
eva_equip_threephase_exceptional<#='_'+left(@pday,4)#> b on a.subnet_id = substring(b.subnet_id,1,6)
where a.parent_code ='<#=@sq2#>'
and (file_date>=str_to_date('<#=if(@m,@m+'01',@pday#>','%Y%m%d') and file_date<str_to_date('<#=if(@m,offsetdate(@m,0,1,0),offsetdate(@pday,0,0,1))#>','%Y%m%d'))
group by a.subnet_id,b.file_date
union
select a.subnet_id,a.subnet_name,b.file_date file_date,count(1) sum from subnet_view a join
eva_equip_threephase_exceptional<#='_'+left(@pday,4)#> b on a.subnet_id = b.subnet_id
where a.parent_code='<#=@sq2#>'
and (file_date>=str_to_date('<#=if(@m,@m+'01',@pday#>','%Y%m%d') and file_date<str_to_date('<#=if(@m,offsetdate(@m,0,1,0),offsetdate(@pday,0,0,1))#>','%Y%m%d'))
group by a.subnet_id,b.file_date
) d on c.subnet_id = d.subnet_id
where c.parent_code='<#=@sq2#>'
这个语句，@m是前一个页面钻取时的日期参数，@pday是日期组件的参数。
最近看过此主题的会员
最佳答案
把传参带入到sql中，并且if判断，应该可以做到，参考帖子
http://bbs.esensoft.com/thread-128117-1-1.html
http://bbs.esensoft.com/thread-128117-1-1.html
9个回答
大佬多施舍一点呀，至少50个还能转个转盘{:3_53:}
把传参带入到sql中，并且if判断，应该可以做到，参考帖子
http://bbs.esensoft.com/thread-128117-1-1.html
