intraface / intraface.dk

     *

     * @return array Array with groups

     */

    function getGroups()

    {

        $result = $this->db->query("SELECT id, group_name AS ".$this->db->quoteIdentifier('group')." FROM module_package_group WHERE active = 1 ORDER BY sorting_index");

        if (PEAR::isError($result)) {

            throw new Exception('Error in db query: '.$result->getUserInfo());

            exit;

        }

        return $result->fetchAll();

    }

}

    /**

     * TODO M�ske kan det g�res enklere, s� der ikke skal bruges s� mange tabeller

     */

    public function getList()

    {

        $i = 0;

        $result = $this->db->query("SELECT DISTINCT user.id, user.email, address.name

            FROM user

            INNER JOIN permission ON permission.user_id = user.id

            LEFT JOIN address ON user.id = address.belong_to_id AND address.type = 2

            WHERE (address.active = 1 OR address.type IS NULL) AND permission.intranet_id = ".$this->intranet_id."

            ORDER BY address.name");

        if (PEAR::isError($result)) {

            throw new Exception($result->getUserInfo());

        }

        return $result->fetchAll();

    }

    public function isFilledIn()

    {