webOffice_alt/includes/mailboxfolder.inc.php

<?php

class MailboxFolder {
    private $id         = NULL;
    private $folderName = NULL;
    private $mailboxId  = NULL;
    private $labelId    = NULL;

    public function __construct($id, $folderName, $mailboxId, $labelId) {
        $this->id = $id;
        $this->folderName = $folderName;
        $this->mailboxId = $mailboxId;
        $this->labelId = $labelId;

    }

    public function getId() {
        return $this->id;
    }

    public function getFolderName() {
        return $this->folderName;
    }

    public function getMailboxId() {
        return $this->mailboxId;
    }

    public function getLabelId() {
        return $this->labelId;
    }

    /**
     * Get MailboxFolder by Folder-name
     *
     *
     * @param string $folderName  Name of folder
     *
     * @return MailboxFolder  Selected MailboxFolder
     *
     */

     // TODO: sizeof handling

    public static function getMailboxFolderByName($folderName) {
        global $db;

        $return = array();
        $folders = $db->selectQuery("SELECT * FROM `mailbox-folders` WHERE `folder_name` = '" . $folderName . "';");

        if(!$folders) {
            return false;
        }

        foreach($folders as $folder) {
            $return[] = new MailboxFolder($folder->id, $folder->folder_name, $folder->mailbox_id, $folder->label_id);
        }

        return $return[0];
    }

    /**
     * Get MailboxFolder by Label ID
     *
     *
     * @param int $labelId  Label ID
     *
     * @return Array(MailboxFolder)  Array with selected MailboxFolder(s)
     *
     */

    public static function getMailboxFolderByLabelId($labelId) {
        global $db;

        $return = array();
        $folders = $db->selectQuery("SELECT * FROM `mailbox-folders` WHERE `label_id` = '" . $labelId . "';");

        if(!$folders) {
            return false;
        }

        foreach($folders as $folder) {
            $return[] = new MailboxFolder($folder->id, $folder->folder_name, $folder->mailbox_id, $folder->label_id);
        }

        return $return;
    }

    /**
     * Get MailboxFolder-Name by ID
     *
     *
     * @param int $mId  Mailbox-Folder-ID
     *
     * @return string  MailboxFolder-Name
     *
     */

    public static function getMailboxFolderNameFromId($mId) {
        global $db;

        $mailbox = $db->selectStringQuery("SELECT `folder_name` FROM `mailbox-folders` WHERE id=" . $mId);
        return $mailbox;
    }
}