File Services/Core/InfoBox/Deleter/InfoBoxDeleter.php

  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  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99 100 101 102 103 104 105

<?php

/* --------------------------------------------------------------
   InfoBoxDeleter.php 2016-04-22
   Gambio GmbH
   http://www.gambio.de
   Copyright (c) 2016 Gambio GmbH
   Released under the GNU General Public License (Version 2)
   [http://www.gnu.org/licenses/gpl-2.0.html]
   --------------------------------------------------------------
*/

/**
 * Class InfoBoxDeleter
 *
 * @category System
 * @package  InfoBox
 */
class InfoBoxDeleter implements InfoBoxDeleterInterface
{

    /**
     * Database connection.
     * @var CI_DB_query_builder
     */
    protected $db;

    /**
     * Name of the table for the info box messages entries.
     * @var string
     */
    protected $infoBoxTable = 'infobox_messages';

    /**
     * Name of the table for the info box description entries.
     * @var string
     */
    protected $infoBoxTableDescription = 'infobox_messages_description';

    /**
     * Name of the ID column.
     * @var string
     */
    protected $id_column = 'infobox_messages_id';


    /**
     * InfoBoxDeleter constructor.
     *
     * @param CI_DB_query_builder $db Database connection.
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }


    /**
     * Deletes messages by source.
     *
     * @param StringType $source Source.
     *
     * @NOTE Find a better solution to delete the rows.
     */
    public function deleteBySource(StringType $source)
    {
        $query = 'DELETE FROM ' . $this->infoBoxTable . ' , ' . $this->infoBoxTableDescription . ' USING '
                 . $this->infoBoxTable . ',' . $this->infoBoxTableDescription . ' WHERE ' . $this->infoBoxTable . '.'
                 . 'source = "' . $source->asString() . '"' . ' AND ' . $this->infoBoxTable . '.' . $this->id_column
                 . ' = ' . $this->infoBoxTableDescription . '.' . $this->id_column;

        $this->db->query($query);
    }


    /**
     * Deletes a message by ID.
     *
     * @param IdType $id Message ID.
     */
    public function deleteById(IdType $id)
    {
        $tables = array($this->infoBoxTable, $this->infoBoxTableDescription);
        $where  = array($this->id_column => $id->asInt());
        $this->db->delete($tables, $where);
    }


    /**
     * Deletes a message based  on its identifier
     *
     * @param StringType $identifier Message identifier
     *
     * @NOTE Find a better solution to delete the rows.
     */
    public function deleteByIdentifier(StringType $identifier)
    {
        $query = 'DELETE FROM ' . $this->infoBoxTable . ' , ' . $this->infoBoxTableDescription . ' USING '
                 . $this->infoBoxTable . ',' . $this->infoBoxTableDescription . ' WHERE ' . $this->infoBoxTable . '.'
                 . 'identifier  = "' . $identifier->asString() . '"' . ' AND ' . $this->infoBoxTable . '.'
                 . $this->id_column . ' = ' . $this->infoBoxTableDescription . '.' . $this->id_column;

        $this->db->query($query);
    }
}

Packages

Classes

Interfaces

Exceptions