maya.public

Parameters

Name	Type	Mode
_interval	interval	IN
_iddevice	integer	OUT
_serialnumber	character varying	OUT
_lastgpsdate	timestamp with time zone	OUT
_now	timestamp with time zone	OUT
_status	integer	OUT
_device_external_battery	character varying	OUT
_device_internal_battery	character varying	OUT
_connected	character varying	OUT
_lastdateconnected	timestamp with time zone	OUT

Definition

DECLARE
_start_date timestamptz;
r record;
BEGIN
FOR r IN ( SELECT d.iddevice,d.serialnumber,d.lastgpsdate as lastgpsdate,now() as _now,CASE WHEN  now() - lastgpsdate > interval '24 hours' THEN 0 ELSE 1 END status,(CASE WHEN (d.others->'VOLTAGE_IN')::float < 12 THEN 'Low' WHEN (d.others->'VOLTAGE_IN')::float < 12.45 THEN 'Medium' ELSE 'High' END) || '(' || (d.others->'VOLTAGE_IN')::varchar(5) || ')' as device_external_battery ,(CASE WHEN (d.others->'INTERNAL_BATTERY')::float < 3.8 THEN 'Low' WHEN (d.others->'INTERNAL_BATTERY')::float < 4 THEN 'Medium' ELSE 'High' END) || '(' || (d.others->'INTERNAL_BATTERY')::varchar(5) || ')' as device_internal_battery ,d.others->'power_supply' Connected from device d  inner join unit u using(idunit) where idclient = 1527 and idmodeldevice = 7 and d.enabled = true and u.enabled = true order by  lastgpsdate desc,d.others->'VOLTAGE_IN') LOOP
IF r.status = 0 THEN
  _start_date := r.lastgpsdate - _interval;
  SELECT senddate INTO _lastdateconnected  from tmp.event where iddevice = r.iddevice and senddate between _start_date and r.lastgpsdate and reason = 48 order by senddate desc limit 1;
  RETURN QUERY(select r.iddevice,r.serialnumber,r.lastgpsdate,r._now,r.status,r.device_external_battery::varchar,r.device_internal_battery::varchar,r.connected::varchar,_lastdateconnected);
END IF;
END LOOP;
END;

ot_ro_ttg_health(interval)

Parameters

Definition