Revize 1556
Přidáno uživatelem David Raška před asi 12 roky(ů)
| freenetis/branches/testing/application/models/device.php | ||
|---|---|---|
|
LEFT JOIN ifaces i ON i.device_id = d.id
|
||
|
LEFT JOIN ip_addresses ip ON ip.iface_id = i.id $where
|
||
|
GROUP BY d.id
|
||
|
ORDER BY IF(u.id <> ?, 1, 0),
|
||
|
IF(u.id <> ?, IF(ISNULL(d.name) OR LENGTH(d.name) = 0, 1, 0),
|
||
|
IF(ISNULL(ip.ip_address) OR LENGTH(ip.ip_address) = 0, 1, 0)),
|
||
|
IF(i.id <> ?, d.name, INET_ATON(ip.ip_address)),
|
||
|
ORDER BY IF(u.id <> ?, 1, 0), u.surname, u.name,
|
||
|
IF(u.id <> ?, IF(ISNULL(ip.ip_address) OR LENGTH(ip.ip_address) = 0, 1, 0), 1),
|
||
|
IF(u.id <> ?, INET_ATON(ip.ip_address), d.name),
|
||
|
d.name, u.id
|
||
|
", User_Model::MAIN_USER, User_Model::MAIN_USER, User_Model::MAIN_USER);
|
||
|
|
||
Také k dispozici: Unified diff
Upravy:
- Uprava razeni zarizeni