FreenetIS

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