base-inbox.inc.php

Go to the documentation of this file.

<?
class BaseInbox extends MyManager
{
    public function __construct($class = 'Message')
    {
        parent::__construct($class);
    }

    public function initSearchPage()
    {
        $this->assertLogin();
        
        parent::initSearchPage();

        $this->pageTitle = 'Inbox';
    }

    public function getSearchParamXml()
    { 
        $xml = parent::getSearchParamXml();

        $xml .= <<<XML
            <param name="status">
                <option value="read"/>
                <option value="unread"/>
            </param>
XML;
        return $xml;
    }

    protected function getSearchSelect($params)
    { 
        $sql = parent::getSearchSelect($params);
        
        $sql .= ", i.read ";

        return $sql;
    }

    protected function getSearchFrom($params)
    {
        $from = "FROM {$this->object->inboxTable} i\n";
        $from .= "INNER JOIN {$this->object->tableName} o\n";
        $from .= "ON o.id = i.message_id\n";

        return $from;
    }

    protected function getSearchWhere($params)
    {
        global $me;
        
        $where = parent::getSearchWhere($params);
        
        $where .= " AND i.user_id = '$me->id'\n";

        if ($params['status'] == 'unread')
            $where .= " AND i.read = 0 ";
        
        if ($params['status'] == 'read')
            $where .= " AND i.read = 1 ";

        return $where;
    }

    protected function getSortFieldsArray()
    {
        $data = parent::getSortFieldsArray();

        $data['read'] = 'Sort by read status';

        return $data;
    }

    protected function loadObjects($data)
    {
        $objs = parent::loadObjects($data);

        foreach ($data AS $row)
            $objs[$row['id']]->read = $row['read'];

        return $objs;
    }

    public function drawRows($rs)
    {
        if (count($rs))
        {
            echo "<form id=\"deleteAll\" method=\"post\" action=\"" . $this->getUrl(array('page' => 'delete')) . "\">\n";
            
            echo "<table class=\"InOutBox\">";
            $this->object->drawHeaderRow('inbox');
            foreach ($rs AS $ar)
            {
                $on = !$on;
                $ar->drawRow('inbox', $on);
            }
            echo "</table>";

            echo "<input type=\"submit\" name=\"submit\" value=\"Delete Selected\"/>\n";
            echo "</form>\n";
        }
    }

    public function getPagesXml()
    {
        $xml = parent::getPagesXml();

        $xml .= "<page name=\"delete\" description=\"delete inbox messages.\"/>\n";

        return $xml;
    }

    public function initDeletePage()
    {
        global $me;
        
        $this->pageTitle = 'Delete Inbox Messages';

        $this->assertLogin();
        
        if (!count($_POST['message']))
            throw new PageError('You must select at least 1 message to delete.');
        else
        {
            foreach ($_POST['message'] AS $messageId)
            {
                dbExecute("
                    DELETE FROM {$this->object->inboxTable}
                    WHERE user_id = '$me->id'
                        AND message_id = '$messageId'
                ");
            }

            Util::redirect($this->getUrl(".main"));
        }
    }

    public function drawDeletePage()
    {
        echo 'Messages deleted.';
    }
}
?>

---