intraface / intraface.dk

    /**

     * @return array with attachments

     */

    function getAttachments()

    {

        $db = new DB_Sql;

        $db->query("SELECT file_id, filename FROM email_attachment

            WHERE intranet_id = " .$this->kernel->intranet->get('id') . " AND email_id = " . $this->id);

        $file = array();

        $i = 0;

        while ($db->nextRecord()) {

            $file[$i]['id'] = $db->f('file_id');

            $file[$i]['filename'] = $db->f('filename');

            $i++;

        }

        return $file;

    }

    /**

     * @deprecated

     *

     *

     * @return array

     */

    function needNewsletterOptin()

    {

        $db = new DB_Sql;

        $db->query("SELECT list_id, code FROM newsletter_subscriber WHERE optin = 0 AND contact_id = " . $this->id . " AND intranet_id =" . $this->kernel->intranet->get('id'));

        $lists = array();

        $i = 0;

        while ($db->nextRecord()) {

            $lists[$i]['list_id'] = $db->f('list_id');

            $lists[$i]['code'] = $db->f('code');

            $i++;

        }

        return $lists;

    }

    /**

     * Kontakten kan slettes, hvis man kun er indskrevet i nyhedsbrevet.

        return 1;

    }

    function getList()

    {

        $db = new DB_Sql;

        $db->query("SELECT id, name FROM cms_site WHERE intranet_id = " . $this->kernel->intranet->get('id'). " AND active = 1");

        $i = 0;

        $sites = array();

        while ($db->nextRecord()) {

            $sites[$i]['id'] = $db->f('id');

            $sites[$i]['name'] = $db->f('name');

            $i++;

        }

        return $sites;

    }

}