Imap datasource for CakePHP. Ripped from Infinitas. Changes since then

Requires CakePHP 1.3

Warning

This datasource automatically closes the imap connection with CL_EXPUNGE. This means that if you ->delete() mails, they will really be gone from your mailserver, and are not just marked for deletion.

Todo

• Better conditions support
  'Complex' conditions such as: NOT, OR, arrays as values Full support for all the imap_search keys

Install

• Unpack / Clone / Copy so that my files are at app/plugins/emails/*

Config

• Edit your database.php file like so:

<?php
class DATABASE_CONFIG {
    // ... your normal database config here ...

    // Imap email connection
    public $emailTicket = array(
        'datasource' => 'Emails.Imap',
        'server' => 'imap.example.com',
        'connect' => 'imap/tls/novalidate-cert',
        'username' => 'tickets',
        'password' => 'xxxxxxxxxx',
        'port' => '143',
        'ssl' => true,
        'encoding' => 'UTF-8',
        'error_handler' => 'php',
        'auto_mark_as' => array(
            'Seen',
            // 'Answered',
            // 'Flagged',
            // 'Deleted',
            // 'Draft',
        ),
    );
}

Implement

<?php
class TicketEmail extends AppModel {
    // Important:
    public $useDbConfig = 'emailTicket';
    public $useTable    = false;

    // Whatever:
    public $displayField = 'subject';
    public $limit        = 10;

    // Semi-important:
    // You want to use the datasource schema, and still be able to set
    // $useTable to false. So we override Cake's schema with that exception:
    function schema ($field = false) {
        if (!is_array($this->_schema) || $field === true) {
            $db =& ConnectionManager::getDataSource($this->useDbConfig);
            $db->cacheSources = ($this->cacheSources && $db->cacheSources);
            $this->_schema = $db->describe($this, $field);
        }
        if (is_string($field)) {
            if (isset($this->_schema[$field])) {
                return $this->_schema[$field];
            } else {
                return null;
            }
        }
        return $this->_schema;
    }
}

Integrate

Here are a couple of supported examples:

<?php
// Get many
$ticketEmails = $this->TicketEmail->find('all', array(
    // Set recursive to 1 to also gets attachments,
    // presented in a separate [Attachment][0] model.
    // Recursive attachments (someone forwarded an email as 
    // an attachment, which in turn had a pdf attached) are just
    // squashed to 1 list of files.
    'recursive' => -1,
    'conditions' => array(
        'answered' => 0,
        'deleted' => 0,
        'draft' => 0,
        'flagged' => 0,
        'recent' => 0,
        'seen' => 0,

        'from' => 'kevin@true.nl',
    ),
));
print_r(compact('ticketEmails'));

// Get one
$ticketEmail = $this->TicketEmail->find('first', array(
    'conditions' => array(
        'id' => 21879,
    ),
));
print_r(compact('ticketEmail'));

// Get subject
$this->TicketEmail->id = 21879;
$subject = $this->TicketEmail->field('subject');
print(compact('subject'));


// Delete one
$this->TicketEmail->delete(21879);

// Delete many
$this->TicketEmail->deleteAll(array(
    'deleted' => 0,
    'seen' => 0,
    'from' => 'kevin@true.nl',
));