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 

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

MainFactory::load_class('AbstractAddonValueStorage');

/**
 * Class OrderItemAddonValueStorage
 *
 * @category   System
 * @package    Order
 * @subpackage Storages
 */
class OrderItemAddonValueStorage extends AbstractAddonValueStorage
{
    /**
     * Updates the fields specified in the external fields array $this->externalFields with the corresponding values
     * from the provided KeyValueCollection and removes the elements from the collection before the called method
     * writes into the addon_values_storage table.
     *
     * @param IdType             $containerId
     * @param KeyValueCollection $values
     */
    protected function _setExternalValues(IdType $containerId, KeyValueCollection $values)
    {
        foreach($this->externalFields as $tableName => $tableData)
        {
            $row = array();
            foreach($tableData['fields'] as $columnName => $addonValueKey)
            {
                if($values->keyExists($addonValueKey))
                {
                    $row[$columnName] = $values->getValue($addonValueKey);
                    $values->deleteValue($addonValueKey);
                }
            }
            
            $exists = $this->db->select($tableData['primary_key'])->from($tableName)->where($tableData['primary_key'], $containerId->asInt())->get()->row_array();
            
            if($exists)
            {
                $this->db->update($tableName, $row, array($tableData['primary_key'] => $containerId->asInt()));
            }
            // no need for orders_products_quantity_units entries without quantity unit name
            elseif($tableName !== 'orders_products_quantity_units')
            {
                $row[$tableData['primary_key']] = $containerId->asInt();
                $this->db->insert($tableName, $row);
            }
        }
    }
    
    
    /**
     * Get the container class type.
     *
     * @return string
     */
    protected function _getContainerType()
    {
        return 'OrderItemInterface';
    }
    
    
    /**
     * Returns a multidimensional array with the primary key of the orders_products table and the required column names
     * with the corresponding key used in the KeyValueCollection.
     *
     * @return array
     */
    protected function _getExternalFieldsArray()
    {
        $externalFields                                   = array();
        $externalFields['orders_products']['primary_key'] = 'orders_products_id';
        $externalFields['orders_products']['fields']      = array(
            'products_id' => 'productId',
            'product_type' => 'productType'
        );
        
        $externalFields['orders_products_quantity_units']['primary_key'] = 'orders_products_id';
        $externalFields['orders_products_quantity_units']['fields']      = array(
            'quantity_unit_id' => 'quantityUnitId'
        );
        
        return $externalFields;
    }
}