| @@ 103-110 (lines=8) @@ | ||
| 100 | ||
| 101 | public function warehouseCount($cart_id = 0) { |
|
| 102 | $warehouseIds = []; |
|
| 103 | if (\App::$cur->geography && \Geography\City::$cur) { |
|
| 104 | $warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]); |
|
| 105 | if ($warehouses && $warehouses->data) { |
|
| 106 | foreach (explode(',', $warehouses->data) as $id) { |
|
| 107 | $warehouseIds[$id] = $id; |
|
| 108 | } |
|
| 109 | } |
|
| 110 | } |
|
| 111 | if ($warehouseIds) { |
|
| 112 | \App::$cur->db->where(\Ecommerce\Item\Offer\Warehouse::colPrefix() . \Ecommerce\Warehouse::index(), $warehouseIds, 'IN'); |
|
| 113 | } |
|
| @@ 206-213 (lines=8) @@ | ||
| 203 | return; |
|
| 204 | } |
|
| 205 | $warehouseIds = []; |
|
| 206 | if (\App::$cur->geography && \Geography\City::$cur) { |
|
| 207 | $warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]); |
|
| 208 | if ($warehouses && $warehouses->data) { |
|
| 209 | foreach (explode(',', $warehouses->data) as $id) { |
|
| 210 | $warehouseIds[$id] = $id; |
|
| 211 | } |
|
| 212 | } |
|
| 213 | } |
|
| 214 | $selectOptions['where'][] = [ |
|
| 215 | '( |
|
| 216 | (SELECT COALESCE(sum(`' . Item\Offer\Warehouse::colPrefix() . 'count`),0) |
|