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 

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

/**
 * Class OrderConfigurationProvider
 */
class OrderConfigurationProvider
{
    /**
     * @var \CI_DB_query_builder
     */
    protected $db;
    
    /**
     * @var string
     */
    protected $table = 'configuration';
    
    /**
     * @var string
     */
    protected $keyField = 'configuration_key';
    
    /**
     * @var string
     */
    protected $valueField = 'configuration_value';
    
    
    /**
     * OrderConfigurationProvider constructor.
     *
     * @param \CI_DB_query_builder $db
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }
    
    
    /**
     * Returns the default order status id.
     *
     * @return int
     */
    public function defaultOrderStatusId()
    {
        return $this->_getConfigurationValue('DEFAULT_ORDERS_STATUS_ID');
    }
    
    
    /**
     * Returns the default customer status id.
     *
     * @return int
     */
    public function defaultCustomerStatusId()
    {
        return $this->_getConfigurationValue('DEFAULT_CUSTOMERS_STATUS_ID');
    }
    
    
    /**
     * Returns the default guest status id.
     *
     * @return int
     */
    public function defaultGuestStatusId()
    {
        
        return $this->_getConfigurationValue('DEFAULT_CUSTOMERS_STATUS_ID_GUEST');
    }
    
    
    /**
     * Returns the value of the given configuration key.
     * The result will be cast to an integer.
     *
     * @param string $configurationKey Key of expected configuration value.
     *
     * @return int
     */
    protected function _getConfigurationValue($configurationKey)
    {
        $result = $this->db->select($this->valueField)
                           ->from($this->table)
                           ->where($this->keyField, $configurationKey)
                           ->get()
                           ->row_array();
        
        return array_key_exists($this->valueField, $result) ? (int)$result[$this->valueField] : 0;
    }
}