select '首次检查提醒' taskType,(a.sum+b.sum)as sum,(a.finishSum+b.finishsum)as finishSum,
(a.nonFinishSum+b.nonFinishSum)as nonFinishSum
from (select
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=1)sum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=1 and ct.status=5)finishSum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=1 and ct.status!=5)nonFinishSum
from dual)a,
(select
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=1)sum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=1 and ct.status=5)finishSum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=1 and ct.status!=5)nonFinishSum from dual)b
union
select '首次检查预警' taskType,(a.sum+b.sum)as sum,(a.finishSum+b.finishsum)as finishSum,
(a.nonFinishSum+b.nonFinishSum)as nonFinishSum
from (select
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=2)sum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=2 and ct.status=5)finishSum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=2 and ct.status!=5)nonFinishSum
from dual)a,
(select
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=2)sum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=2 and ct.status=5)finishSum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=2 and ct.status!=5)nonFinishSum from dual)b
union
select '定期检查' taskType,(a.sum+b.sum)as sum,(a.finishSum+b.finishsum)as finishSum,
(a.nonFinishSum+b.nonFinishSum)as nonFinishSum
from (select
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=3)sum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=3 and ct.status=5)finishSum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=3 and ct.status!=5)nonFinishSum
from dual)a,
(select
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=3)sum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=3 and ct.status=5)finishSum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=3 and ct.status!=5)nonFinishSum from dual)b
union
select '不定期检查' taskType,(a.sum+b.sum)as sum,(a.finishSum+b.finishsum)as finishSum,
(a.nonFinishSum+b.nonFinishSum)as nonFinishSum
from (select
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=4)sum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=4 and ct.status=5)finishSum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=4 and ct.status!=5)nonFinishSum
from dual)a,
(select
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=4)sum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=4 and ct.status=5)finishSum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=4 and ct.status!=5)nonFinishSum from dual)b
