if(
T4.Time is null,
case when now()<=T4.Time then 1 else 0 end,
case when now()>T4.Time then 1 else 0 end,
) as ontime
if(
T4.Time is null,
case when now()<=T4.Time then 1 else 0 end,
case when now()>T4.Time then 1 else 0 end,
) as ontime