1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 

<?php
/* --------------------------------------------------------------
   EmailDeleter.inc.php 2015-01-29 gm
   Gambio GmbH
   http://www.gambio.de
   Copyright (c) 2015 Gambio GmbH
   Released under the GNU General Public License (Version 2)
   [http://www.gnu.org/licenses/gpl-2.0.html]
   --------------------------------------------------------------
*/

MainFactory::load_class('EmailDeleterInterface');

/**
 * Class EmailDeleter
 *
 * Deletes email records from the database.
 *
 * @category   System
 * @package    Email
 * @subpackage Repository
 */
class EmailDeleter implements EmailDeleterInterface
{
    /**
     * Query builder.
     * @var CI_DB_query_builder
     */
    protected $db;


    /**
     * Class Constructor
     *
     * @param CI_DB_query_builder $db Query builder.
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }


    /**
     * Removes a record from the database.
     *
     * This method will delete all the email relevant entities from the database. It will
     * not throw an exception if the given record is not found.
     *
     * @param EmailInterface $email E-Mail.
     */
    public function delete(EmailInterface $email)
    {
        $this->db->delete(array('emails', 'email_contacts', 'email_attachments'),
                          array('email_id' => $email->getId()));
    }
    
    
    /**
     * Removes all emails from the data base that have the given email address as sender or recipient.
     * 
     * @param CustomerEmail $email E-Mail address.
     */
    public function deleteEmailsByEmailAddress(CustomerEmail $email)
    {
        $this->db->query('
            DELETE `emails`.*, `email_contacts`.*, `email_attachments`.* FROM `email_contacts`
                LEFT JOIN `emails` ON (`email_contacts`.`email_id` = `emails`.`email_id`)
                LEFT JOIN `email_attachments` ON (`email_contacts`.`email_id` = `email_attachments`.`email_id`)
            WHERE `email_contacts`.`email_address` = "' . $email . '"');
    }
}