Dočasně lze použít tento SQL dotaz:
SELECT SUBSTR(ASWKT(ap.gps), 7, LENGTH(ASWKT(ap.gps)) - 7) AS coordinates,
i.mac AS device_mac,
l.wireless_ssid AS device_ssid,
l.wireless_frequency AS device_zone,
d.trade_name AS device_type,
IF(i.wireless_antenna = 1, 'směrová',
IF(i.wireless_antenna = 2, 'všesměrová',
IF(i.wireless_antenna = 3, 'sektorová', '')
)
) AS device_antena_type,
IF(l.wireless_polarization = 1, 'horizontální',
IF(l.wireless_polarization = 2, 'vertikální',
IF(l.wireless_polarization = 3, 'kruhová',
IF(l.wireless_polarization > 3, 'vertikální a horizontální', '')
)
)
) AS device_polarization,
'???' AS device_direction
FROM devices d
JOIN users u ON d.user_id = u.id
JOIN address_points ap ON d.address_point_id = ap.id
JOIN ifaces i ON i.device_id = d.id
JOIN links l ON i.link_id = l.id
JOIN ip_addresses ip ON ip.iface_id = i.id
WHERE i.type = 1 AND i.wireless_mode = 1 AND u.member_id = 1