OptionsParser::order() - Code Metrics - injitools/cms-Inji - Measure and Improve Code Quality continuously with Scrutinizer

OptionsParser::order() C
last analyzed 2018-01-12 15:45 UTC

↳ Parent: OptionsParser

Complexity

Conditions	12
Paths	18

Size

Total Lines	40
Code Lines	32

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	12
eloc	32
nc	18
nop	2
dl	0
loc	40
rs	5.1612
c	0
b	0
f	0

How to fix Complexity

<?php

/**
 * Helper for module methods
 *
 * @author Alexey Krupskiy <[email protected]>
 * @link http://inji.ru/
 * @copyright 2016 Alexey Krupskiy
 * @license https://github.com/injitools/cms-Inji/blob/master/LICENSE
 */

namespace Ecommerce;

class OptionsParser extends \InjiObject {
filter:
    dependency_paths: ["lib/*"]

    public static function parse($options = [], $forCount = false) {
        $selectOptions = self::getDefault($options);

        //parse order options
        self::order($options, $selectOptions);

        //joined offers
        $selectOptions['join'][] = [Item\Offer::table(), Item::index() . ' = ' . Item\Offer::colPrefix() . Item::index(), 'inner'];
filter:
    dependency_paths: ["lib/*"]

        //joined prices, check price configs
        $comparision = Item\Offer::index() . ' = ' . Item\Offer\Price::colPrefix() . Item\Offer::index();
filter:
    dependency_paths: ["lib/*"]
        if (empty(\App::$cur->Ecommerce->config['show_zero_price'])) {
            $comparision .= ' and ' . Item\Offer\Price::colPrefix() . 'price>0';
        }
        if (!empty(\App::$cur->Ecommerce->config['available_price_types'])) {
            $comparision .= ' and ' . Item\Offer\Price::colPrefix() . 'item_offer_price_type_id in (' . implode(',', \App::$cur->Ecommerce->config['available_price_types']) . ')';
        }
        $selectOptions['join'][] = [Item\Offer\Price::table(), $comparision,
            empty(\App::$cur->Ecommerce->config['show_without_price']) ? 'inner' : 'left'];

        //join item types
        $selectOptions['join'][] = [
            Item\Offer\Price\Type::table(), Item\Offer\Price::colPrefix() . Item\Offer\Price\Type::index() . ' = ' . Item\Offer\Price\Type::index()
filter:
    dependency_paths: ["lib/*"]
        ];

        //add filter for item type user roles by current user role
        $selectOptions['where'][] = [
            [Item\Offer\Price\Type::index(), null, 'is'],
            [
                [Item\Offer\Price\Type::colPrefix() . 'roles', '', '=', 'OR'],
                [Item\Offer\Price\Type::colPrefix() . 'roles', '%|' . \Users\User::$cur->role_id . '|%', 'LIKE', 'OR'],
            ],
        ];

        //add custom preset filters from config on where
        self::presetFilters($selectOptions);

        //parse filters
        self::filters($options, $selectOptions);

        //categories paths
        self::categories($options, $selectOptions);

        //search
        self::search($options, $selectOptions);

        self::warehouse($selectOptions);
        if ($forCount) {
            $selectOptions['distinct'] = \Ecommerce\Item::index();
        } else {
            $selectOptions['group'] = Item::index();
        }
        if (isset($options['array'])) {
            $selectOptions['array'] = $options['array'];
        }

        return $selectOptions;
    }

    public static function getDefault(&$options) {
        $selectOptions = [
            'where' => !empty($options['where']) ? $options['where'] : [],
            'distinct' => false,
            'join' => [],
            'order' => [],
            'start' => isset($options['start']) ? (int) $options['start'] : 0,
            'key' => isset($options['key']) ? $options['key'] : null,
            'limit' => !empty($options['count']) ? (int) $options['count'] : 0,
        ];

        //only not deleted items
        $selectOptions['where'][] = ['deleted', 0];

        //check config of view items without images
        if (empty(\App::$cur->Ecommerce->config['view_empty_image'])) {
            $selectOptions['where'][] = ['image_file_id', 0, '!='];
        }

        return $selectOptions;
    }

    public static function order(&$options, &$selectOptions) {
        if (empty($options['sort']) || !is_array($options['sort'])) {
            return;
        }
        foreach ($options['sort'] as $col => $direction) {
            $direction = strtolower($direction) == 'desc' ? 'desc' : 'asc';
            switch ($col) {
                case 'price':
                    $selectOptions['order'][] = [Item\Offer\Price::colPrefix() . 'price', $direction];
                    break;
                case 'new':
                    $selectOptions['order'][] = ['date_create', $direction];
                    break;
                case 'isset':
                    $warehouseIds = self::getWarehouses('order');
                    $selectOptions['order'][] = [
                        '(
          (SELECT COALESCE(sum(`' . Item\Offer\Warehouse::colPrefix() . 'count`),0) 
filter:
    dependency_paths: ["lib/*"]
            FROM ' . \App::$cur->db->table_prefix . Item\Offer\Warehouse::table() . ' iciw 
            WHERE iciw.' . Item\Offer\Warehouse::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . '
                ' . ($warehouseIds ? ' AND iciw.' . Item\Offer\Warehouse::colPrefix() . Warehouse::index() . ' IN(' . implode(',', $warehouseIds) . ')' : '') . '
filter:
    dependency_paths: ["lib/*"]
            )
          -
          (SELECT COALESCE(sum(' . Warehouse\Block::colPrefix() . 'count) ,0)
filter:
    dependency_paths: ["lib/*"]
            FROM ' . \App::$cur->db->table_prefix . Warehouse\Block::table() . ' iewb
            inner JOIN ' . \App::$cur->db->table_prefix . Cart::table() . ' icc ON icc.' . Cart::index() . ' = iewb.' . Warehouse\Block::colPrefix() . Cart::index() . ' AND (
                (`' . Cart::colPrefix() . 'warehouse_block` = 1 and `' . Cart::colPrefix() . 'cart_status_id` in(2,3,6)) ||
                (`' . Cart::colPrefix() . Cart\Status::index() . '` in(0,1) and `' . Cart::colPrefix() . 'date_last_activ` >=subdate(now(),INTERVAL 30 MINUTE))
filter:
    dependency_paths: ["lib/*"]
            )
            WHERE iewb.' . Warehouse\Block::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . ')
          )', $direction
                    ];
                    break;
                case 'name':
                case 'sales':
                case 'weight':
                    $selectOptions['order'][] = [$col, $direction];
            }
        }
        $selectOptions['order'][] = ['offers:prices:type:weight', 'ASC'];
    }

    public static function presetFilters(&$selectOptions) {
        if (empty(\App::$cur->Ecommerce->config['view_filter'])) {
            return;
        }
        if (!empty(\App::$cur->Ecommerce->config['view_filter']['options'])) {
            foreach (\App::$cur->Ecommerce->config['view_filter']['options'] as $optionId => $optionValue) {
                $selectOptions['join'][] = [Item\Param::table(), Item::index() . ' = ' . 'option' . $optionId . '.' . Item\Param::colPrefix() . Item::index() . ' AND ' .
filter:
    dependency_paths: ["lib/*"]
                    'option' . $optionId . '.' . Item\Param::colPrefix() . Item\Option::index() . ' = "' . (int) $optionId . '" AND ' .
filter:
    dependency_paths: ["lib/*"]
                    'option' . $optionId . '.' . Item\Param::colPrefix() . 'value = "' . (int) $optionValue . '"',
                    'inner', 'option' . $optionId];
            }
        }
    }

    public static function filters(&$options, &$selectOptions) {
        if (empty($options['filters'])) {
            return;
        }
        foreach ($options['filters'] as $col => $filter) {
            switch ($col) {
                case 'best':
                    if ($filter) {
                        $selectOptions['where'][] = ['best', 1];
                    }
                    break;
                case 'badge':
                    $selectOptions['where'][] = ['item_badge_id', (int) $filter];
                    break;
                case 'price':
                    $colName = Item\Offer\Price::colPrefix() . 'price';
                    if (!empty($filter['min'])) {
                        $selectOptions['where'][] = [$colName, (float) $filter['min'], '>='];
                    }
                    if (!empty($filter['max'])) {
                        $selectOptions['where'][] = [$colName, (float) $filter['max'], '<='];
                    }
                    break;
                case 'options':
                case 'offerOptions':
                    if ($col == 'offerOptions') {
                        $paramPrefix = Item\Offer\Param::colPrefix();
filter:
    dependency_paths: ["lib/*"]
                        $itemIndex = Item\Offer::index();
                        $optionIndex = Item\Offer\Option::index();
filter:
    dependency_paths: ["lib/*"]
                        $table = Item\Offer\Param::table();
                    } else {
                        $paramPrefix = Item\Param::colPrefix();
                        $itemIndex = Item::index();
                        $optionIndex = Item\Option::index();
                        $table = Item\Param::table();
                    }
                    if ($filter) {
                        foreach ($filter as $optionId => $optionValue) {
                            $optionId = (int) $optionId;
                            if (is_array($optionValue)) {
                                $optionValueArr = [];
                                foreach ($optionValue as $val) {
                                    $optionValueArr[] = \App::$cur->db->connection->pdo->quote($val);
                                }
                                $qstr = 'IN (' . implode(',', $optionValueArr) . ')';
                            } else {
                                $qstr = '= ' . \App::$cur->db->connection->pdo->quote($optionValue);
                            }
                            $selectOptions['join'][] = [$table, $itemIndex . ' = ' . 'option' . $optionId . '.' . $paramPrefix . $itemIndex . ' AND ' .
                                'option' . $optionId . '.' . $paramPrefix . $optionIndex . ' = "' . (int) $optionId . '" AND ' .
                                'option' . $optionId . '.' . $paramPrefix . 'value ' . $qstr . '',
                                'inner', 'option' . $optionId];
                        }
                    }
            }
        }
    }

    public static function categories(&$options, &$selectOptions) {
        if (empty($options['parent'])) {
            return;
        }
        if (is_array($options['parent']) || strpos($options['parent'], ',') !== false) {
            $list = is_array($options['parent']) ? $options['parent'] : explode(',', $options['parent']);
            $first = true;
            $where = [];
            foreach ($list as $categoryId) {
                if (!$categoryId) {
                    continue;
                }
                $category = Category::get($categoryId);
filter:
    dependency_paths: ["lib/*"]
                $where[] = ['tree_path', $category->tree_path . (int) $categoryId . '/%', 'LIKE', $first ? 'AND' : 'OR'];
                $first = false;
            }
            $selectOptions['where'][] = $where;
        } else {
            $category = Category::get($options['parent']);
            if ($category) {
                $selectOptions['where'][] = ['tree_path', $category->tree_path . (int) $options['parent'] . '/%', 'LIKE'];
            }
        }
    }

    public static function search(&$options, &$selectOptions) {
        if (empty($options['search'])) {
            return;
        }
        $searchStr = preg_replace('![^A-zА-я0-9 ]!iSu', ' ', $options['search']);
        $searchArr = [];
        foreach (explode(' ', $searchStr) as $part) {
            $part = trim($part);
            if ($part && strlen($part) > 2) {
                $searchArr[] = ['search_index', '%' . $part . '%', 'LIKE'];
            }
        }
        if (!empty($searchArr)) {
            $selectOptions['where'][] = $searchArr;
        }
    }

    public static function warehouse(&$selectOptions) {
        if (!empty(\App::$cur->Ecommerce->config['view_empty_warehouse'])) {
            return;
        }
        $warehouseIds = self::getWarehouses();

        $selectOptions['where'][] = [
            '(
          (SELECT COALESCE(sum(`' . Item\Offer\Warehouse::colPrefix() . 'count`),0) 
            FROM ' . \App::$cur->db->table_prefix . Item\Offer\Warehouse::table() . ' iciw 
            WHERE iciw.' . Item\Offer\Warehouse::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . '
                ' . ($warehouseIds ? ' AND iciw.' . Item\Offer\Warehouse::colPrefix() . Warehouse::index() . ' IN(' . implode(',', $warehouseIds) . ')' : '') . '
            )
          -
          (SELECT COALESCE(sum(' . Warehouse\Block::colPrefix() . 'count) ,0)
            FROM ' . \App::$cur->db->table_prefix . Warehouse\Block::table() . ' iewb
            inner JOIN ' . \App::$cur->db->table_prefix . Cart::table() . ' icc ON icc.' . Cart::index() . ' = iewb.' . Warehouse\Block::colPrefix() . Cart::index() . ' AND (
                (`' . Cart::colPrefix() . 'warehouse_block` = 1 and `' . Cart::colPrefix() . 'cart_status_id` in(2,3,6)) ||
                (`' . Cart::colPrefix() . Cart\Status::index() . '` in(0,1) and `' . Cart::colPrefix() . 'date_last_activ` >=subdate(now(),INTERVAL 30 MINUTE))
            )
            WHERE iewb.' . Warehouse\Block::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . ')
          )',
            0,
            '>'
        ];
    }

    public static function getWarehouses($type = 'all') {
        if ($type === 'order') {
            $warehouses = Warehouse::getList(['where' => ['type', 'order']]);
            return array_keys($warehouses);
        }
        if (!\App::$cur->geography || !\Geography\City::$cur) {
            return [];
        }
        $warehouseIds = [];
        $warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]);
        if ($warehouses && $warehouses->data) {
            foreach (explode(',', $warehouses->data) as $id) {
                $warehouseIds[$id] = $id;
            }
        }
        return $warehouseIds;
    }
}

1			<?php
2
3			/**
4			* Helper for module methods
5			*
6			* @author Alexey Krupskiy <[email protected]>
7			* @link http://inji.ru/
8			* @copyright 2016 Alexey Krupskiy
9			* @license https://github.com/injitools/cms-Inji/blob/master/LICENSE
10			*/
11
12			namespace Ecommerce;
13
14			class OptionsParser extends \InjiObject {
			0 ignored issues – show Bug introduced 2018-01-07 17:18 UTC by Report Bug Copy Issue Report The type `InjiObject` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
15
16			public static function parse($options = [], $forCount = false) {
17			$selectOptions = self::getDefault($options);
18
19			//parse order options
20			self::order($options, $selectOptions);
21
22			//joined offers
23			$selectOptions['join'][] = [Item\Offer::table(), Item::index() . ' = ' . Item\Offer::colPrefix() . Item::index(), 'inner'];
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history... Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item\Offer` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
24
25			//joined prices, check price configs
26			$comparision = Item\Offer::index() . ' = ' . Item\Offer\Price::colPrefix() . Item\Offer::index();
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item\Offer\Price` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
27			if (empty(\App::$cur->Ecommerce->config['show_zero_price'])) {
28			$comparision .= ' and ' . Item\Offer\Price::colPrefix() . 'price>0';
29			}
30			if (!empty(\App::$cur->Ecommerce->config['available_price_types'])) {
31			$comparision .= ' and ' . Item\Offer\Price::colPrefix() . 'item_offer_price_type_id in (' . implode(',', \App::$cur->Ecommerce->config['available_price_types']) . ')';
32			}
33			$selectOptions['join'][] = [Item\Offer\Price::table(), $comparision,
34			empty(\App::$cur->Ecommerce->config['show_without_price']) ? 'inner' : 'left'];
35
36			//join item types
37			$selectOptions['join'][] = [
38			Item\Offer\Price\Type::table(), Item\Offer\Price::colPrefix() . Item\Offer\Price\Type::index() . ' = ' . Item\Offer\Price\Type::index()
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item\Offer\Price\Type` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
39			];
40
41			//add filter for item type user roles by current user role
42			$selectOptions['where'][] = [
43			[Item\Offer\Price\Type::index(), null, 'is'],
44			[
45			[Item\Offer\Price\Type::colPrefix() . 'roles', '', '=', 'OR'],
46			[Item\Offer\Price\Type::colPrefix() . 'roles', '%\|' . \Users\User::$cur->role_id . '\|%', 'LIKE', 'OR'],
47			],
48			];
49
50			//add custom preset filters from config on where
51			self::presetFilters($selectOptions);
52
53			//parse filters
54			self::filters($options, $selectOptions);
55
56			//categories paths
57			self::categories($options, $selectOptions);
58
59			//search
60			self::search($options, $selectOptions);
61
62			self::warehouse($selectOptions);
63			if ($forCount) {
64			$selectOptions['distinct'] = \Ecommerce\Item::index();
65			} else {
66			$selectOptions['group'] = Item::index();
67			}
68			if (isset($options['array'])) {
69			$selectOptions['array'] = $options['array'];
70			}
71
72			return $selectOptions;
73			}
74
75			public static function getDefault(&$options) {
76			$selectOptions = [
77			'where' => !empty($options['where']) ? $options['where'] : [],
78			'distinct' => false,
79			'join' => [],
80			'order' => [],
81			'start' => isset($options['start']) ? (int) $options['start'] : 0,
82			'key' => isset($options['key']) ? $options['key'] : null,
83			'limit' => !empty($options['count']) ? (int) $options['count'] : 0,
84			];
85
86			//only not deleted items
87			$selectOptions['where'][] = ['deleted', 0];
88
89			//check config of view items without images
90			if (empty(\App::$cur->Ecommerce->config['view_empty_image'])) {
91			$selectOptions['where'][] = ['image_file_id', 0, '!='];
92			}
93
94			return $selectOptions;
95			}
96
97			public static function order(&$options, &$selectOptions) {
98			if (empty($options['sort']) \|\| !is_array($options['sort'])) {
99			return;
100			}
101			foreach ($options['sort'] as $col => $direction) {
102			$direction = strtolower($direction) == 'desc' ? 'desc' : 'asc';
103			switch ($col) {
104			case 'price':
105			$selectOptions['order'][] = [Item\Offer\Price::colPrefix() . 'price', $direction];
106			break;
107			case 'new':
108			$selectOptions['order'][] = ['date_create', $direction];
109			break;
110			case 'isset':
111			$warehouseIds = self::getWarehouses('order');
112			$selectOptions['order'][] = [
113			'(
114			(SELECT COALESCE(sum(`' . Item\Offer\Warehouse::colPrefix() . 'count`),0)
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item\Offer\Warehouse` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
115			FROM ' . \App::$cur->db->table_prefix . Item\Offer\Warehouse::table() . ' iciw
116			WHERE iciw.' . Item\Offer\Warehouse::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . '
117			' . ($warehouseIds ? ' AND iciw.' . Item\Offer\Warehouse::colPrefix() . Warehouse::index() . ' IN(' . implode(',', $warehouseIds) . ')' : '') . '
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Warehouse` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
118			)
119			-
120			(SELECT COALESCE(sum(' . Warehouse\Block::colPrefix() . 'count) ,0)
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Warehouse\Block` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
121			FROM ' . \App::$cur->db->table_prefix . Warehouse\Block::table() . ' iewb
122			inner JOIN ' . \App::$cur->db->table_prefix . Cart::table() . ' icc ON icc.' . Cart::index() . ' = iewb.' . Warehouse\Block::colPrefix() . Cart::index() . ' AND (
123			(`' . Cart::colPrefix() . 'warehouse_block` = 1 and `' . Cart::colPrefix() . 'cart_status_id` in(2,3,6)) \|\|
124			(`' . Cart::colPrefix() . Cart\Status::index() . '` in(0,1) and `' . Cart::colPrefix() . 'date_last_activ` >=subdate(now(),INTERVAL 30 MINUTE))
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Cart\Status` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
125			)
126			WHERE iewb.' . Warehouse\Block::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . ')
127			)', $direction
128			];
129			break;
130			case 'name':
131			case 'sales':
132			case 'weight':
133			$selectOptions['order'][] = [$col, $direction];
134			}
135			}
136			$selectOptions['order'][] = ['offers:prices:type:weight', 'ASC'];
137			}
138
139			public static function presetFilters(&$selectOptions) {
140			if (empty(\App::$cur->Ecommerce->config['view_filter'])) {
141			return;
142			}
143			if (!empty(\App::$cur->Ecommerce->config['view_filter']['options'])) {
144			foreach (\App::$cur->Ecommerce->config['view_filter']['options'] as $optionId => $optionValue) {
145			$selectOptions['join'][] = [Item\Param::table(), Item::index() . ' = ' . 'option' . $optionId . '.' . Item\Param::colPrefix() . Item::index() . ' AND ' .
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item\Param` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
146			'option' . $optionId . '.' . Item\Param::colPrefix() . Item\Option::index() . ' = "' . (int) $optionId . '" AND ' .
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item\Option` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
147			'option' . $optionId . '.' . Item\Param::colPrefix() . 'value = "' . (int) $optionValue . '"',
148			'inner', 'option' . $optionId];
149			}
150			}
151			}
152
153			public static function filters(&$options, &$selectOptions) {
154			if (empty($options['filters'])) {
155			return;
156			}
157			foreach ($options['filters'] as $col => $filter) {
158			switch ($col) {
159			case 'best':
160			if ($filter) {
161			$selectOptions['where'][] = ['best', 1];
162			}
163			break;
164			case 'badge':
165			$selectOptions['where'][] = ['item_badge_id', (int) $filter];
166			break;
167			case 'price':
168			$colName = Item\Offer\Price::colPrefix() . 'price';
169			if (!empty($filter['min'])) {
170			$selectOptions['where'][] = [$colName, (float) $filter['min'], '>='];
171			}
172			if (!empty($filter['max'])) {
173			$selectOptions['where'][] = [$colName, (float) $filter['max'], '<='];
174			}
175			break;
176			case 'options':
177			case 'offerOptions':
178			if ($col == 'offerOptions') {
179			$paramPrefix = Item\Offer\Param::colPrefix();
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item\Offer\Param` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
180			$itemIndex = Item\Offer::index();
181			$optionIndex = Item\Offer\Option::index();
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Item\Offer\Option` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
182			$table = Item\Offer\Param::table();
183			} else {
184			$paramPrefix = Item\Param::colPrefix();
185			$itemIndex = Item::index();
186			$optionIndex = Item\Option::index();
187			$table = Item\Param::table();
188			}
189			if ($filter) {
190			foreach ($filter as $optionId => $optionValue) {
191			$optionId = (int) $optionId;
192			if (is_array($optionValue)) {
193			$optionValueArr = [];
194			foreach ($optionValue as $val) {
195			$optionValueArr[] = \App::$cur->db->connection->pdo->quote($val);
196			}
197			$qstr = 'IN (' . implode(',', $optionValueArr) . ')';
198			} else {
199			$qstr = '= ' . \App::$cur->db->connection->pdo->quote($optionValue);
200			}
201			$selectOptions['join'][] = [$table, $itemIndex . ' = ' . 'option' . $optionId . '.' . $paramPrefix . $itemIndex . ' AND ' .
202			'option' . $optionId . '.' . $paramPrefix . $optionIndex . ' = "' . (int) $optionId . '" AND ' .
203			'option' . $optionId . '.' . $paramPrefix . 'value ' . $qstr . '',
204			'inner', 'option' . $optionId];
205			}
206			}
207			}
208			}
209			}
210
211			public static function categories(&$options, &$selectOptions) {
212			if (empty($options['parent'])) {
213			return;
214			}
215			if (is_array($options['parent']) \|\| strpos($options['parent'], ',') !== false) {
216			$list = is_array($options['parent']) ? $options['parent'] : explode(',', $options['parent']);
217			$first = true;
218			$where = [];
219			foreach ($list as $categoryId) {
220			if (!$categoryId) {
221			continue;
222			}
223			$category = Category::get($categoryId);
			0 ignored issues – show Bug introduced 2018-01-09 09:00 UTC by Report Bug Copy Issue Report The type `Ecommerce\Category` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
224			$where[] = ['tree_path', $category->tree_path . (int) $categoryId . '/%', 'LIKE', $first ? 'AND' : 'OR'];
225			$first = false;
226			}
227			$selectOptions['where'][] = $where;
228			} else {
229			$category = Category::get($options['parent']);
230			if ($category) {
231			$selectOptions['where'][] = ['tree_path', $category->tree_path . (int) $options['parent'] . '/%', 'LIKE'];
232			}
233			}
234			}
235
236			public static function search(&$options, &$selectOptions) {
237			if (empty($options['search'])) {
238			return;
239			}
240			$searchStr = preg_replace('![^A-zА-я0-9 ]!iSu', ' ', $options['search']);
241			$searchArr = [];
242			foreach (explode(' ', $searchStr) as $part) {
243			$part = trim($part);
244			if ($part && strlen($part) > 2) {
245			$searchArr[] = ['search_index', '%' . $part . '%', 'LIKE'];
246			}
247			}
248			if (!empty($searchArr)) {
249			$selectOptions['where'][] = $searchArr;
250			}
251			}
252
253			public static function warehouse(&$selectOptions) {
254			if (!empty(\App::$cur->Ecommerce->config['view_empty_warehouse'])) {
255			return;
256			}
257			$warehouseIds = self::getWarehouses();
258
259			$selectOptions['where'][] = [
260			'(
261			(SELECT COALESCE(sum(`' . Item\Offer\Warehouse::colPrefix() . 'count`),0)
262			FROM ' . \App::$cur->db->table_prefix . Item\Offer\Warehouse::table() . ' iciw
263			WHERE iciw.' . Item\Offer\Warehouse::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . '
264			' . ($warehouseIds ? ' AND iciw.' . Item\Offer\Warehouse::colPrefix() . Warehouse::index() . ' IN(' . implode(',', $warehouseIds) . ')' : '') . '
265			)
266			-
267			(SELECT COALESCE(sum(' . Warehouse\Block::colPrefix() . 'count) ,0)
268			FROM ' . \App::$cur->db->table_prefix . Warehouse\Block::table() . ' iewb
269			inner JOIN ' . \App::$cur->db->table_prefix . Cart::table() . ' icc ON icc.' . Cart::index() . ' = iewb.' . Warehouse\Block::colPrefix() . Cart::index() . ' AND (
270			(`' . Cart::colPrefix() . 'warehouse_block` = 1 and `' . Cart::colPrefix() . 'cart_status_id` in(2,3,6)) \|\|
271			(`' . Cart::colPrefix() . Cart\Status::index() . '` in(0,1) and `' . Cart::colPrefix() . 'date_last_activ` >=subdate(now(),INTERVAL 30 MINUTE))
272			)
273			WHERE iewb.' . Warehouse\Block::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . ')
274			)',
275			0,
276			'>'
277			];
278			}
279
280			public static function getWarehouses($type = 'all') {
281			if ($type === 'order') {
282			$warehouses = Warehouse::getList(['where' => ['type', 'order']]);
283			return array_keys($warehouses);
284			}
285			if (!\App::$cur->geography \|\| !\Geography\City::$cur) {
286			return [];
287			}
288			$warehouseIds = [];
289			$warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]);
290			if ($warehouses && $warehouses->data) {
291			foreach (explode(',', $warehouses->data) as $id) {
292			$warehouseIds[$id] = $id;
293			}
294			}
295			return $warehouseIds;
296			}
297			}

injitools / cms-Inji

OptionsParser::order() C last analyzed 2018-01-12 15:45 UTC

Complexity

Size

Duplication

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like

OptionsParser::order() C
last analyzed 2018-01-12 15:45 UTC