OptionsParser - Code Metrics - Inspection of "fix word" - injitools/cms-Inji - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 918fe4...07100e )

by Alexey

created 2017-01-27 11:10 UTC

OptionsParser F

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	258
Duplicated Lines	2.33 %

Coupling/Cohesion

Components	1
Dependencies	19

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
dl	6
loc	258
rs	2.4812
c	2
b	0
f	0
wmc	61
lcom	1
cbo	19

9 Methods

Rating	Name	Duplication	Size	Complexity
A	parse()	0	47	3
B	getDefault()	0	21	6
C	order()	0	40	12
A	presetFilters()	0	13	4
C	filters()	6	47	12
C	categories()	0	24	9
B	search()	0	16	6
B	warehouse()	0	26	3
B	getWarehouses()	0	13	6

How to fix Duplicated Code Complexity

Duplicated Code

Duplicate code is one of the most pungent code smells. A rule that is often used is to re-structure code once it is duplicated in three or more places.

Common duplication problems, and corresponding solutions are:

If you have the same expression in different places: Extract expression to a method
If you have the same method in different sub-classes: Extract method, and pull up field to the parent class
If you have the same code in unrelated classes: Consider extracting the code to a new class, and injecting that class

Complex Class

Tip: Before tackling complexity, make sure that you eliminate any duplication first. This often can reduce the size of classes significantly.

Complex classes like OptionsParser often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes. You can also have a look at the cohesion graph to spot any un-connected, or weakly-connected components.

Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.

While breaking up the class, it is a good idea to analyze how other classes use OptionsParser, and based on these observations, apply Extract Interface, too.

<?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 \Object {

    public static function parse($options = []) {
        $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'];

        //joined prices, check price configs
        $selectOptions['join'][] = [Item\Offer\Price::table(),
            Item\Offer::index() . ' = ' . Item\Offer\Price::colPrefix() . Item\Offer::index() .
            (empty(\App::$cur->Ecommerce->config['show_zero_price']) ? ' and ' . Item\Offer\Price::colPrefix() . 'price>0' : ''),
            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()
        ];

        //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);

        $selectOptions['group'] = Item::index();

        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();
                    $selectOptions['order'][] = [
                        '(
          (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() . ')
          )', $direction
                    ];
                    break;
                case 'name':
                case 'sales':
                case 'weight':
                    $selectOptions['order'][] = [$col, $direction];
            }
        }
    }

    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 ' .
                    'option' . $optionId . '.' . Item\Param::colPrefix() . Item\Option::index() . ' = "' . (int) $optionId . '" AND ' .
                    '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 '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();
                        $itemIndex = Item\Offer::index();
                        $optionIndex = Item\Offer\Option::index();
                        $table = Item\Offer\Param::table();
                    } else {
                        $paramPrefix = Item\Param::colPrefix();
                        $itemIndex = Item::index();
                        $optionIndex = Item\Option::index();
                        $table = Item\Param::table();
                    }
                    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);
                $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() {
        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 \Object {
15
16		public static function parse($options = []) {
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'];
24
25		//joined prices, check price configs
26		$selectOptions['join'][] = [Item\Offer\Price::table(),
27		Item\Offer::index() . ' = ' . Item\Offer\Price::colPrefix() . Item\Offer::index() .
28		(empty(\App::$cur->Ecommerce->config['show_zero_price']) ? ' and ' . Item\Offer\Price::colPrefix() . 'price>0' : ''),
29		empty(\App::$cur->Ecommerce->config['show_without_price']) ? 'inner' : 'left'];
30
31		//join item types
32		$selectOptions['join'][] = [
33		Item\Offer\Price\Type::table(), Item\Offer\Price::colPrefix() . Item\Offer\Price\Type::index() . ' = ' . Item\Offer\Price\Type::index()
34		];
35
36		//add filter for item type user roles by current user role
37		$selectOptions['where'][] = [
38		[Item\Offer\Price\Type::index(), null, 'is'],
39		[
40		[Item\Offer\Price\Type::colPrefix() . 'roles', '', '=', 'OR'],
41		[Item\Offer\Price\Type::colPrefix() . 'roles', '%\|' . \Users\User::$cur->role_id . '\|%', 'LIKE', 'OR'],
42		],
43		];
44
45		//add custom preset filters from config on where
46		self::presetFilters($selectOptions);
47
48		//parse filters
49		self::filters($options, $selectOptions);
50
51		//categories paths
52		self::categories($options, $selectOptions);
53
54		//search
55		self::search($options, $selectOptions);
56
57		self::warehouse($selectOptions);
58
59		$selectOptions['group'] = Item::index();
60
61		return $selectOptions;
62		}
63
64		public static function getDefault(&$options) {
65		$selectOptions = [
66		'where' => !empty($options['where']) ? $options['where'] : [],
67		'distinct' => false,
68		'join' => [],
69		'order' => [],
70		'start' => isset($options['start']) ? (int) $options['start'] : 0,
71		'key' => isset($options['key']) ? $options['key'] : null,
72		'limit' => !empty($options['count']) ? (int) $options['count'] : 0,
73		];
74
75		//only not deleted items
76		$selectOptions['where'][] = ['deleted', 0];
77
78		//check config of view items without images
79		if (empty(\App::$cur->Ecommerce->config['view_empty_image'])) {
80		$selectOptions['where'][] = ['image_file_id', 0, '!='];
81		}
82
83		return $selectOptions;
84		}
85
86		public static function order(&$options, &$selectOptions) {
87		if (empty($options['sort']) \|\| !is_array($options['sort'])) {
88		return;
89		}
90		foreach ($options['sort'] as $col => $direction) {
91		$direction = strtolower($direction) == 'desc' ? 'desc' : 'asc';
92		switch ($col) {
93		case 'price':
94		$selectOptions['order'][] = [Item\Offer\Price::colPrefix() . 'price', $direction];
95		break;
96		case 'new':
97		$selectOptions['order'][] = ['date_create', $direction];
98		break;
99		case 'isset':
100		$warehouseIds = self::getWarehouses();
101		$selectOptions['order'][] = [
102		'(
103		(SELECT COALESCE(sum(`' . Item\Offer\Warehouse::colPrefix() . 'count`),0)
104		FROM ' . \App::$cur->db->table_prefix . Item\Offer\Warehouse::table() . ' iciw
105		WHERE iciw.' . Item\Offer\Warehouse::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . '
106		' . ($warehouseIds ? ' AND iciw.' . Item\Offer\Warehouse::colPrefix() . Warehouse::index() . ' IN(' . implode(',', $warehouseIds) . ')' : '') . '
107		)
108		-
109		(SELECT COALESCE(sum(' . Warehouse\Block::colPrefix() . 'count) ,0)
110		FROM ' . \App::$cur->db->table_prefix . Warehouse\Block::table() . ' iewb
111		inner JOIN ' . \App::$cur->db->table_prefix . Cart::table() . ' icc ON icc.' . Cart::index() . ' = iewb.' . Warehouse\Block::colPrefix() . Cart::index() . ' AND (
112		(`' . Cart::colPrefix() . 'warehouse_block` = 1 and `' . Cart::colPrefix() . 'cart_status_id` in(2,3,6)) \|\|
113		(`' . Cart::colPrefix() . Cart\Status::index() . '` in(0,1) and `' . Cart::colPrefix() . 'date_last_activ` >=subdate(now(),INTERVAL 30 MINUTE))
114		)
115		WHERE iewb.' . Warehouse\Block::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . ')
116		)', $direction
117		];
118		break;
119		case 'name':
120		case 'sales':
121		case 'weight':
122		$selectOptions['order'][] = [$col, $direction];
123		}
124		}
125		}
126
127		public static function presetFilters(&$selectOptions) {
128		if (empty(\App::$cur->Ecommerce->config['view_filter'])) {
129		return;
130		}
131		if (!empty(\App::$cur->Ecommerce->config['view_filter']['options'])) {
132		foreach (\App::$cur->Ecommerce->config['view_filter']['options'] as $optionId => $optionValue) {
133		$selectOptions['join'][] = [Item\Param::table(), Item::index() . ' = ' . 'option' . $optionId . '.' . Item\Param::colPrefix() . Item::index() . ' AND ' .
134		'option' . $optionId . '.' . Item\Param::colPrefix() . Item\Option::index() . ' = "' . (int) $optionId . '" AND ' .
135		'option' . $optionId . '.' . Item\Param::colPrefix() . 'value = "' . (int) $optionValue . '"',
136		'inner', 'option' . $optionId];
137		}
138		}
139		}
140
141		public static function filters(&$options, &$selectOptions) {
142		if (empty($options['filters'])) {
143		return;
144		}
145		foreach ($options['filters'] as $col => $filter) {
146		switch ($col) {
147		case 'price':
148		$colName = Item\Offer\Price::colPrefix() . 'price';
149	View Code Duplication	if (!empty($filter['min'])) {
		0 ignored issues – show Duplication introduced 2016-11-29 17:52 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
150		$selectOptions['where'][] = [$colName, (float) $filter['min'], '>='];
151		}
152	View Code Duplication	if (!empty($filter['max'])) {
		0 ignored issues – show Duplication introduced 2016-11-29 17:52 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
153		$selectOptions['where'][] = [$colName, (float) $filter['max'], '<='];
154		}
155		break;
156		case 'options':
157		case 'offerOptions':
158		if ($col == 'offerOptions') {
159		$paramPrefix = Item\Offer\Param::colPrefix();
160		$itemIndex = Item\Offer::index();
161		$optionIndex = Item\Offer\Option::index();
162		$table = Item\Offer\Param::table();
163		} else {
164		$paramPrefix = Item\Param::colPrefix();
165		$itemIndex = Item::index();
166		$optionIndex = Item\Option::index();
167		$table = Item\Param::table();
168		}
169		foreach ($filter as $optionId => $optionValue) {
170		$optionId = (int) $optionId;
171		if (is_array($optionValue)) {
172		$optionValueArr = [];
173		foreach ($optionValue as $val) {
174		$optionValueArr[] = \App::$cur->db->connection->pdo->quote($val);
175		}
176		$qstr = 'IN (' . implode(',', $optionValueArr) . ')';
177		} else {
178		$qstr = '= ' . \App::$cur->db->connection->pdo->quote($optionValue);
179		}
180		$selectOptions['join'][] = [$table, $itemIndex . ' = ' . 'option' . $optionId . '.' . $paramPrefix . $itemIndex . ' AND ' .
181		'option' . $optionId . '.' . $paramPrefix . $optionIndex . ' = "' . (int) $optionId . '" AND ' .
182		'option' . $optionId . '.' . $paramPrefix . 'value ' . $qstr . '',
183		'inner', 'option' . $optionId];
184		}
185		}
186		}
187		}
188
189		public static function categories(&$options, &$selectOptions) {
190		if (empty($options['parent'])) {
191		return;
192		}
193		if (is_array($options['parent']) \|\| strpos($options['parent'], ',') !== false) {
194		$list = is_array($options['parent']) ? $options['parent'] : explode(',', $options['parent']);
195		$first = true;
196		$where = [];
197		foreach ($list as $categoryId) {
198		if (!$categoryId) {
199		continue;
200		}
201		$category = Category::get($categoryId);
202		$where[] = ['tree_path', $category->tree_path . (int) $categoryId . '/%', 'LIKE', $first ? 'AND' : 'OR'];
203		$first = false;
204		}
205		$selectOptions['where'][] = $where;
206		} else {
207		$category = Category::get($options['parent']);
208		if ($category) {
209		$selectOptions['where'][] = ['tree_path', $category->tree_path . (int) $options['parent'] . '/%', 'LIKE'];
210		}
211		}
212		}
213
214		public static function search(&$options, &$selectOptions) {
215		if (empty($options['search'])) {
216		return;
217		}
218		$searchStr = preg_replace('![^A-zА-я0-9 ]!iSu', ' ', $options['search']);
219		$searchArr = [];
220		foreach (explode(' ', $searchStr) as $part) {
221		$part = trim($part);
222		if ($part && strlen($part) > 2) {
223		$searchArr[] = ['search_index', '%' . $part . '%', 'LIKE'];
224		}
225		}
226		if (!empty($searchArr)) {
227		$selectOptions['where'][] = $searchArr;
228		}
229		}
230
231		public static function warehouse(&$selectOptions) {
232		if (!empty(\App::$cur->Ecommerce->config['view_empty_warehouse'])) {
233		return;
234		}
235		$warehouseIds = self::getWarehouses();
236
237		$selectOptions['where'][] = [
238		'(
239		(SELECT COALESCE(sum(`' . Item\Offer\Warehouse::colPrefix() . 'count`),0)
240		FROM ' . \App::$cur->db->table_prefix . Item\Offer\Warehouse::table() . ' iciw
241		WHERE iciw.' . Item\Offer\Warehouse::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . '
242		' . ($warehouseIds ? ' AND iciw.' . Item\Offer\Warehouse::colPrefix() . Warehouse::index() . ' IN(' . implode(',', $warehouseIds) . ')' : '') . '
243		)
244		-
245		(SELECT COALESCE(sum(' . Warehouse\Block::colPrefix() . 'count) ,0)
246		FROM ' . \App::$cur->db->table_prefix . Warehouse\Block::table() . ' iewb
247		inner JOIN ' . \App::$cur->db->table_prefix . Cart::table() . ' icc ON icc.' . Cart::index() . ' = iewb.' . Warehouse\Block::colPrefix() . Cart::index() . ' AND (
248		(`' . Cart::colPrefix() . 'warehouse_block` = 1 and `' . Cart::colPrefix() . 'cart_status_id` in(2,3,6)) \|\|
249		(`' . Cart::colPrefix() . Cart\Status::index() . '` in(0,1) and `' . Cart::colPrefix() . 'date_last_activ` >=subdate(now(),INTERVAL 30 MINUTE))
250		)
251		WHERE iewb.' . Warehouse\Block::colPrefix() . Item\Offer::index() . ' = ' . Item\Offer::index() . ')
252		)',
253		0,
254		'>'
255		];
256		}
257
258		public static function getWarehouses() {
259		if (!\App::$cur->geography \|\| !\Geography\City::$cur) {
260		return [];
261		}
262		$warehouseIds = [];
263		$warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]);
264		if ($warehouses && $warehouses->data) {
265		foreach (explode(',', $warehouses->data) as $id) {
266		$warehouseIds[$id] = $id;
267		}
268		}
269		return $warehouseIds;
270		}
271		}

injitools / cms-Inji