eTB Manager » e TB Manager Bangladesh

Create the following 3 tags to bangladesh after daily update is implemented...

Cases without culture results by over than 120 days - If the last culture exam has more than 120 days.
select *
from tbcase a
where
a.state in (0,1,2)
and exists(select *
from examculture ecu
where ecu.datecollected = (select max(ecu2.datecollected) from examculture ecu2 where ecu2.case_id = ecu.case_id)

and (DATE_ADD(ecu.datecollected, INTERVAL 120 DAY)) <= curdate()

and a.id = ecu.case_id);

Cases without microscopy results by over than 60 days - If the last microscopy exam has more than 60 days until today
select *
from tbcase a
where
a.state in (1,2)

and exists(select *
from exammicroscopy em
where em.datecollected = (select max(em2.datecollected) from exammicroscopy em2 where em2.case_id = em.case_id)

and (DATE_ADD(em.datecollected, INTERVAL 60 DAY)) <= curdate()

and a.id = em.case_id);

Cases without outcome by the end of treatment - Cases that the treatment end date is before today.
select * from tbcase a where
a.state < 3
and a.endtreatmentdate > curdate();