| @@ 316-323 (lines=8) @@ | ||
| 313 | } |
|
| 314 | if (empty($this->config['view_empty_warehouse'])) { |
|
| 315 | $warehouseIds = []; |
|
| 316 | if (class_exists('Geography\City\Data')) { |
|
| 317 | $warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]); |
|
| 318 | if ($warehouses && $warehouses->data) { |
|
| 319 | foreach (explode(',', $warehouses->data) as $id) { |
|
| 320 | $warehouseIds[$id] = $id; |
|
| 321 | } |
|
| 322 | } |
|
| 323 | } |
|
| 324 | $selectOptions['where'][] = [ |
|
| 325 | '( |
|
| 326 | (SELECT COALESCE(sum(`' . \Ecommerce\Item\Offer\Warehouse::colPrefix() . 'count`),0) |
|
| @@ 106-113 (lines=8) @@ | ||
| 103 | public function warehouseCount($cart_id = 0) |
|
| 104 | { |
|
| 105 | $warehouseIds = []; |
|
| 106 | if (class_exists('Geography\City\Data')) { |
|
| 107 | $warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]); |
|
| 108 | if ($warehouses && $warehouses->data) { |
|
| 109 | foreach (explode(',', $warehouses->data) as $id) { |
|
| 110 | $warehouseIds[$id] = $id; |
|
| 111 | } |
|
| 112 | } |
|
| 113 | } |
|
| 114 | if ($warehouseIds) { |
|
| 115 | \App::$cur->db->where(\Ecommerce\Item\Offer\Warehouse::colPrefix() . \Ecommerce\Warehouse::index(), $warehouseIds, 'IN'); |
|
| 116 | } |
|