Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * from (
- SELECT
- va.*,
- p.nome,
- p.tel1,
- p.tel2,
- pp.codigo,
- i.id AS idImovel,
- i.quadra,
- i.lote,
- CASE
- WHEN
- ((va.acesso_expira = "s" AND curdate() >= va.data_inicio AND curdate() <= va.data_final ) OR (va.acesso_expira = "n")) AND
- ((va.dia_todo = "n" AND curtime() >= va.hora_inicio AND curtime() <= va.hora_final) OR (va.dia_todo = "s")) AND
- ((va.todos_dias = "n" AND va.seg = "s") OR (va.todos_dias = "s"))
- THEN 1
- ELSE 0
- END as valido_agora
- FROM
- validade_acesso_permanente va
- INNER JOIN pessoa p
- ON va.id_pessoa_autorizante = p.id
- INNER JOIN imovel i
- ON va.id_imovel = i.id
- INNER JOIN pessoa_permanente pp
- ON p.id = pp.id_pessoa
- WHERE
- va.id_pessoa = 70990 AND
- va.softdeleted = 0
- ORDER BY quadra, lote
- ) as t
- WHERE valido_agora = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement