TechDivision\Import\Product\Bundle\Utils\SqlStatements

Complexity

Total Complexity

2

Size/Duplication

Total Lines	204
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	8	2

<?php

/**
 * TechDivision\Import\Product\Bundle\Utils\SqlStatements
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is available through the world-wide-web at this URL:
 * http://opensource.org/licenses/osl-3.0.php
 *
 * PHP version 5
 *
 * @author    Tim Wagner <t.wagner@techdivision.com>
 * @copyright 2016 TechDivision GmbH <info@techdivision.com>
 * @license   http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 * @link      https://github.com/techdivision/import-product-bundle
 * @link      http://www.techdivision.com
 */

namespace TechDivision\Import\Product\Bundle\Utils;

use TechDivision\Import\Utils\AbstractSqlStatements;

/**
 * Utility class with the SQL statements to use.
 *
 * @author    Tim Wagner <t.wagner@techdivision.com>
 * @copyright 2016 TechDivision GmbH <info@techdivision.com>
 * @license   http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 * @link      https://github.com/techdivision/import-product-bundle
 * @link      http://www.techdivision.com
 */
class SqlStatements extends AbstractSqlStatements
{

    /**
     * The SQL statement to load the bundle option with the passed name/parent/store ID.
     *
     * @var string
     */
    const BUNDLE_OPTION = 'bundle_option';

    /**
     * The SQL statement to load the bundle option value with the passed name/parent/store ID.
     *
     * @var string
     */
    const BUNDLE_OPTION_VALUE = 'bundle_option_value';

    /**
     * The SQL statement to load the bundle selection with the passed option/parent product/product ID.
     *
     * @var string
     */
    const BUNDLE_SELECTION = 'bundle_selection';

    /**
     * The SQL statement to load the bundle selection price with the passed selection/website ID.
     *
     * @var string
     */
    const BUNDLE_SELECTION_PRICE = 'bundle_selection_price';

    /**
     * The SQL statement to create a new product bundle option.
     *
     * @var string
     */
    const CREATE_PRODUCT_BUNDLE_OPTION = 'create.product_bundle_option';

    /**
     * The SQL statement to update an existion product bundle option.
     *
     * @var string
     */
    const UPDATE_PRODUCT_BUNDLE_OPTION = 'update.product_bundle_option';

    /**
     * The SQL statement to create a new product bundle option value.
     *
     * @var string
     */
    const CREATE_PRODUCT_BUNDLE_OPTION_VALUE = 'create.product_bundle_option_value';

    /**
     * The SQL statement to create a new product bundle selection.
     *
     * @var string
     */
    const CREATE_PRODUCT_BUNDLE_SELECTION = 'create.product_bundle_selection';

    /**
     * The SQL statement to update an existion product bundle selection.
     *
     * @var string
     */
    const UPDATE_PRODUCT_BUNDLE_SELECTION = 'update.product_bundle_selection';

    /**
     * The SQL statement to create a new product bundle selection price.
     *
     * @var string
     */
    const CREATE_PRODUCT_BUNDLE_SELECTION_PRICE = 'insert.product_bundle_selection_price';

    /**
     * The SQL statement to update an existion product bundle selection price.
     *
     * @var string
     */
    const UPDATE_PRODUCT_BUNDLE_SELECTION_PRICE = 'update.product_bundle_selection_price';

    /**
     * The SQL statements.
     *
     * @var array
     */
    private $statements = array(
        SqlStatements::BUNDLE_OPTION =>
            'SELECT t0.*
               FROM catalog_product_bundle_option t0
         INNER JOIN catalog_product_bundle_option_value t1
                 ON t0.parent_id = :parent_id
                AND t0.option_id = t1.option_id
                AND t1.title = :title
                AND t1.store_id = :store_id',
        SqlStatements::BUNDLE_OPTION_VALUE =>
            'SELECT t0.*
               FROM catalog_product_bundle_option_value t0
         INNER JOIN catalog_product_bundle_option t1
                 ON t1.parent_id = :parent_id
                AND t0.option_id = t1.option_id
                AND t0.title = :title
                AND t0.store_id = :store_id',
        SqlStatements::BUNDLE_SELECTION =>
            'SELECT *
               FROM catalog_product_bundle_selection
              WHERE option_id = :option_id
                AND parent_product_id = :parent_product_id
                AND product_id = :product_id',
        SqlStatements::BUNDLE_SELECTION_PRICE =>
            'SELECT *
               FROM catalog_product_bundle_selection_price
              WHERE selection_id = :selection_id
                AND website_id = :website_id',
        SqlStatements::CREATE_PRODUCT_BUNDLE_OPTION =>
            'INSERT
               INTO catalog_product_bundle_option
                    (parent_id,
                     required,
                     position,
                     type)
             VALUES (:parent_id,
                     :required,
                     :position,
                     :type)',
        SqlStatements::UPDATE_PRODUCT_BUNDLE_OPTION =>
            'UPDATE catalog_product_bundle_option
                SET parent_id = :parent_id,
                    required = :required,
                    position = :position,
                    type = :type
              WHERE option_id = :option_id',
        SqlStatements::CREATE_PRODUCT_BUNDLE_OPTION_VALUE =>
            'INSERT
               INTO catalog_product_bundle_option_value
                    (option_id,
                     store_id,
                     title)
             VALUES (:option_id,
                     :store_id,
                     :title)',
        SqlStatements::CREATE_PRODUCT_BUNDLE_SELECTION =>
            'INSERT
               INTO catalog_product_bundle_selection
                    (option_id,
                     parent_product_id,
                     product_id,
                     position,
                     is_default,
                     selection_price_type,
                     selection_price_value,
                     selection_qty,
                     selection_can_change_qty)
             VALUES (:option_id,
                     :parent_product_id,
                     :product_id,
                     :position,
                     :is_default,
                     :selection_price_type,
                     :selection_price_value,
                     :selection_qty,
                     :selection_can_change_qty)',
        SqlStatements::UPDATE_PRODUCT_BUNDLE_SELECTION =>
            'UPDATE catalog_product_bundle_selection
                SET option_id = :option_id,
                    parent_product_id = :parent_product_id,
                    product_id = :product_id,
                    position = :position,
                    is_default = :is_default,
                    selection_price_type = :selection_price_type,
                    selection_price_value = :selection_price_value,
                    selection_qty = :selection_qty,
                    selection_can_change_qty = :selection_can_change_qty
              WHERE selection_id = :selection_id',
        SqlStatements::CREATE_PRODUCT_BUNDLE_SELECTION_PRICE =>
            'INSERT
               INTO catalog_product_bundle_selection_price
                    (selection_id,
                     website_id,
                     selection_price_type,
                     selection_price_value)
             VALUES (:selection_id,
                     :website_id,
                     :selection_price_type,
                     :selection_price_value)',
        SqlStatements::UPDATE_PRODUCT_BUNDLE_SELECTION_PRICE =>
            'UPDATE catalog_product_bundle_selection_price
                SET selection_price_type = :selection_price_type,
                    selection_price_value = :selection_price_value
              WHERE selection_id = :selection_id
                AND website_id = :website_id'
    );

    /**
     * Initialize the the SQL statements.
     */
    public function __construct()
    {

        // merge the class statements
        foreach ($this->statements as $key => $statement) {
            $this->preparedStatements[$key] = $statement;
        }
    }
}