Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select sum(case ps.nota when '4' then 1 else 0 end ) otimo,sum(case ps.nota when '3' then 1 else 0 end )bom ,sum( case ps.nota when '2' then 1 else 0 end )regular ,
- sum( case ps.nota when '1' then 1 else 0 end )ruim, count( distinct ss.idsolicitacaoservico) total,
- ( CASE
- WHEN ( ss.datahorafim <= ss.datahoralimite ) THEN 'Sim'
- ELSE 'Não'
- END ) AS prazosla, case ss.idtipodemandaservico when 1 then 'incidente' when 3 then 'requisição' end Tipo
- from solicitacaoservico ss left join pesquisasatisfacao ps on ps.idsolicitacaoservico = ss.idsolicitacaoservico
- JOIN servicocontrato sc ON sc.idservicocontrato = ss.idservicocontrato
- JOIN contratos co ON co.idcontrato = sc.idcontrato
- left JOIN (select a.idgrupo grupoexecutor, ss1.idsolicitacaoservico, i.datahorafinalizacao
- from solicitacaoservico ss1 join bpm_atribuicaofluxo a on ss1.idtarefaencerramento = a.iditemtrabalho
- left Join bpm_itemtrabalhofluxo i on a.iditemtrabalho = i.iditemtrabalho
- where a.idtype=1) cp on ss.idsolicitacaoservico = cp.idsolicitacaoservico
- left join grupo grupo on grupo.idgrupo = cp.grupoexecutor group by
- prazosla, ss.idtipodemandaservico limit 200
- SELECT COUNT (nota) FROM pesquisasatisfacao
- LEFT JOIN
- SELECT idsolicitacaoservico AS tipo FROM solicitacaoservico LEFT JOIN pesquisasatisfacao AS pesquisa ON pesquisa.idsolicitacaoservico = tipo
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement