| @@ 284-291 (lines=8) @@ | ||
| 281 | } |
|
| 282 | if (empty($this->config['view_empty_warehouse'])) { |
|
| 283 | $warehouseIds = []; |
|
| 284 | if (class_exists('Geography\City\Data')) { |
|
| 285 | $warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]); |
|
| 286 | if ($warehouses && $warehouses->data) { |
|
| 287 | foreach (explode(',', $warehouses->data) as $id) { |
|
| 288 | $warehouseIds[$id] = $id; |
|
| 289 | } |
|
| 290 | } |
|
| 291 | } |
|
| 292 | $selectOptions['where'][] = [ |
|
| 293 | '( |
|
| 294 | (SELECT COALESCE(sum(`' . \Ecommerce\Item\Offer\Warehouse::colPrefix() . 'count`),0) |
|
| @@ 95-102 (lines=8) @@ | ||
| 92 | public function warehouseCount($cart_id = 0) |
|
| 93 | { |
|
| 94 | $warehouseIds = []; |
|
| 95 | if (class_exists('Geography\City\Data')) { |
|
| 96 | $warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]); |
|
| 97 | if ($warehouses && $warehouses->data) { |
|
| 98 | foreach (explode(',', $warehouses->data) as $id) { |
|
| 99 | $warehouseIds[$id] = $id; |
|
| 100 | } |
|
| 101 | } |
|
| 102 | } |
|
| 103 | if ($warehouseIds) { |
|
| 104 | \App::$cur->db->where(\Ecommerce\Item\Offer\Warehouse::colPrefix() . \Ecommerce\Warehouse::index(), $warehouseIds, 'IN'); |
|
| 105 | } |
|