Revize 1084
Přidáno uživatelem Michal Kliment před asi 13 roky(ů)
| freenetis/branches/device_templates/application/models/device_admin.php | ||
|---|---|---|
|
ORDER BY d.name
|
||
|
", array($user_id));
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Returns all devices of which is user admin
|
||
|
*
|
||
|
* @author Michal Kliment
|
||
|
* @param integer $user_id
|
||
|
* @return MySQL Iterator object
|
||
|
*/
|
||
|
public function get_all_devices_by_admin ($user_id)
|
||
|
{
|
||
|
return $this->db->query("
|
||
|
SELECT
|
||
|
da.id, da.device_id, d.name AS device_name, d.user_id, CONCAT(u.name,' ',u.surname) AS user_name
|
||
|
FROM device_admins da
|
||
|
JOIN devices d ON da.device_id = d.id
|
||
|
JOIN users u ON d.user_id = u.id
|
||
|
WHERE da.user_id = ?
|
||
|
ORDER BY d.name
|
||
|
", array($user_id));
|
||
|
}
|
||
|
}
|
||
Také k dispozici: Unified diff
Commit nekterych necommitnutych veci...