@@ -10,172 +10,172 @@ discard block |
||
10 | 10 | */ |
11 | 11 | class Ecommerce extends Module { |
12 | 12 | |
13 | - public function init() { |
|
13 | + public function init() { |
|
14 | 14 | App::$primary->view->customAsset('js', '/moduleAsset/Ecommerce/js/cart.js'); |
15 | - } |
|
15 | + } |
|
16 | 16 | |
17 | - public function getPayTypeHandlers($forSelect = false) { |
|
17 | + public function getPayTypeHandlers($forSelect = false) { |
|
18 | 18 | if (!$forSelect) { |
19 | - return $this->getSnippets('payTypeHandler'); |
|
19 | + return $this->getSnippets('payTypeHandler'); |
|
20 | 20 | } |
21 | 21 | $handlers = ['' => 'Не выбрано']; |
22 | 22 | foreach ($this->getSnippets('payTypeHandler') as $key => $handler) { |
23 | - if (empty($handler)) { |
|
23 | + if (empty($handler)) { |
|
24 | 24 | continue; |
25 | - } |
|
26 | - $handlers[$key] = $handler['name']; |
|
25 | + } |
|
26 | + $handlers[$key] = $handler['name']; |
|
27 | 27 | } |
28 | 28 | return $handlers; |
29 | - } |
|
29 | + } |
|
30 | 30 | |
31 | - public function cartPayRecive($data) { |
|
31 | + public function cartPayRecive($data) { |
|
32 | 32 | $cart = Ecommerce\Cart::get($data['pay']->data); |
33 | 33 | if ($cart) { |
34 | - $payed = true; |
|
35 | - foreach ($cart->pays as $pay) { |
|
34 | + $payed = true; |
|
35 | + foreach ($cart->pays as $pay) { |
|
36 | 36 | if ($pay->pay_status_id != 2) { |
37 | - $payed = false; |
|
38 | - break; |
|
37 | + $payed = false; |
|
38 | + break; |
|
39 | 39 | } |
40 | - } |
|
41 | - $cart->payed = $payed; |
|
42 | - $cart->save(); |
|
40 | + } |
|
41 | + $cart->payed = $payed; |
|
42 | + $cart->save(); |
|
43 | + } |
|
43 | 44 | } |
44 | - } |
|
45 | 45 | |
46 | - public function parseFields($data, $cart) { |
|
46 | + public function parseFields($data, $cart) { |
|
47 | 47 | $fields = \Ecommerce\UserAdds\Field::getList(); |
48 | 48 | $name = ''; |
49 | 49 | foreach ($fields as $field) { |
50 | - if ($field->save && !empty($data[$field->id])) { |
|
50 | + if ($field->save && !empty($data[$field->id])) { |
|
51 | 51 | $name .= htmlspecialchars($data[$field->id]) . ' '; |
52 | - } |
|
52 | + } |
|
53 | 53 | } |
54 | 54 | $name = trim($name); |
55 | 55 | |
56 | 56 | $userAdds = Ecommerce\UserAdds::get([['user_id', $cart->user->id], ['name', $name]]); |
57 | 57 | if (!$userAdds) { |
58 | - $userAdds = new Ecommerce\UserAdds(); |
|
59 | - $userAdds->user_id = $cart->user->id; |
|
60 | - $userAdds->name = $name; |
|
61 | - $userAdds->save(); |
|
62 | - foreach ($fields as $field) { |
|
58 | + $userAdds = new Ecommerce\UserAdds(); |
|
59 | + $userAdds->user_id = $cart->user->id; |
|
60 | + $userAdds->name = $name; |
|
61 | + $userAdds->save(); |
|
62 | + foreach ($fields as $field) { |
|
63 | 63 | if (!$field->save) { |
64 | - continue; |
|
64 | + continue; |
|
65 | 65 | } |
66 | 66 | $userAddsValue = new Ecommerce\UserAdds\Value(); |
67 | 67 | $userAddsValue->value = htmlspecialchars($data[$field->id]); |
68 | 68 | $userAddsValue->useradds_field_id = $field->id; |
69 | 69 | $userAddsValue->useradds_id = $userAdds->id; |
70 | 70 | $userAddsValue->save(); |
71 | - } |
|
71 | + } |
|
72 | 72 | } |
73 | 73 | $user = \Users\User::get($cart->user_id); |
74 | 74 | foreach ($fields as $field) { |
75 | - $info = new \Ecommerce\Cart\Info(); |
|
76 | - $info->name = $field->name; |
|
77 | - $info->value = htmlspecialchars($data[$field->id]); |
|
78 | - $info->useradds_field_id = $field->id; |
|
79 | - $info->cart_id = $cart->id; |
|
80 | - $info->save(); |
|
81 | - $relations = []; |
|
82 | - if ($field->userfield) { |
|
75 | + $info = new \Ecommerce\Cart\Info(); |
|
76 | + $info->name = $field->name; |
|
77 | + $info->value = htmlspecialchars($data[$field->id]); |
|
78 | + $info->useradds_field_id = $field->id; |
|
79 | + $info->cart_id = $cart->id; |
|
80 | + $info->save(); |
|
81 | + $relations = []; |
|
82 | + if ($field->userfield) { |
|
83 | 83 | if (strpos($field->userfield, ':')) { |
84 | - $path = explode(':', $field->userfield); |
|
85 | - if (!$user->{$path[0]}->{$path[1]}) { |
|
84 | + $path = explode(':', $field->userfield); |
|
85 | + if (!$user->{$path[0]}->{$path[1]}) { |
|
86 | 86 | $user->{$path[0]}->{$path[1]} = $info->value; |
87 | 87 | $relations[$path[0]] = $path[0]; |
88 | - } |
|
88 | + } |
|
89 | 89 | } else { |
90 | - if (!$user->{$field->userfield}) { |
|
90 | + if (!$user->{$field->userfield}) { |
|
91 | 91 | $user->{$field->userfield} = $info->value; |
92 | - } |
|
92 | + } |
|
93 | 93 | } |
94 | - } |
|
95 | - foreach ($relations as $rel) { |
|
94 | + } |
|
95 | + foreach ($relations as $rel) { |
|
96 | 96 | $user->$rel->save(); |
97 | - } |
|
98 | - $user->save(); |
|
97 | + } |
|
98 | + $user->save(); |
|
99 | 99 | } |
100 | 100 | return $userAdds; |
101 | - } |
|
101 | + } |
|
102 | 102 | |
103 | - public function parseDeliveryFields($data, $cart, $fields) { |
|
103 | + public function parseDeliveryFields($data, $cart, $fields) { |
|
104 | 104 | $name = ''; |
105 | 105 | foreach ($fields as $field) { |
106 | - if ($field->save && !empty($data[$field->id])) { |
|
106 | + if ($field->save && !empty($data[$field->id])) { |
|
107 | 107 | $name .= htmlspecialchars($data[$field->id]) . ' '; |
108 | - } |
|
108 | + } |
|
109 | 109 | } |
110 | 110 | $name = trim($name); |
111 | 111 | |
112 | 112 | $save = Ecommerce\Delivery\Save::get([['user_id', $cart->user->id], ['name', $name]]); |
113 | 113 | if (!$save) { |
114 | - $save = new Ecommerce\Delivery\Save(); |
|
115 | - $save->user_id = $cart->user->id; |
|
116 | - $save->name = $name; |
|
117 | - $save->save(); |
|
118 | - foreach ($fields as $field) { |
|
114 | + $save = new Ecommerce\Delivery\Save(); |
|
115 | + $save->user_id = $cart->user->id; |
|
116 | + $save->name = $name; |
|
117 | + $save->save(); |
|
118 | + foreach ($fields as $field) { |
|
119 | 119 | if (!$field->save) { |
120 | - continue; |
|
120 | + continue; |
|
121 | 121 | } |
122 | 122 | $saveValue = new Ecommerce\Delivery\Value(); |
123 | 123 | $saveValue->value = htmlspecialchars($data[$field->id]); |
124 | 124 | $saveValue->delivery_field_id = $field->id; |
125 | 125 | $saveValue->delivery_save_id = $save->id; |
126 | 126 | $saveValue->save(); |
127 | - } |
|
127 | + } |
|
128 | 128 | } |
129 | 129 | $user = \Users\User::get($cart->user_id); |
130 | 130 | foreach ($fields as $field) { |
131 | - $info = new \Ecommerce\Cart\DeliveryInfo(); |
|
132 | - $info->name = $field->name; |
|
133 | - $info->value = htmlspecialchars($data[$field->id]); |
|
134 | - $info->delivery_field_id = $field->id; |
|
135 | - $info->cart_id = $cart->id; |
|
136 | - $info->save(); |
|
137 | - $relations = []; |
|
138 | - if ($field->userfield) { |
|
131 | + $info = new \Ecommerce\Cart\DeliveryInfo(); |
|
132 | + $info->name = $field->name; |
|
133 | + $info->value = htmlspecialchars($data[$field->id]); |
|
134 | + $info->delivery_field_id = $field->id; |
|
135 | + $info->cart_id = $cart->id; |
|
136 | + $info->save(); |
|
137 | + $relations = []; |
|
138 | + if ($field->userfield) { |
|
139 | 139 | if (strpos($field->userfield, ':')) { |
140 | - $path = explode(':', $field->userfield); |
|
141 | - if (!$user->{$path[0]}->{$path[1]}) { |
|
140 | + $path = explode(':', $field->userfield); |
|
141 | + if (!$user->{$path[0]}->{$path[1]}) { |
|
142 | 142 | $user->{$path[0]}->{$path[1]} = $info->value; |
143 | 143 | $relations[$path[0]] = $path[0]; |
144 | - } |
|
144 | + } |
|
145 | 145 | } else { |
146 | - if (!$user->{$field->userfield}) { |
|
146 | + if (!$user->{$field->userfield}) { |
|
147 | 147 | $user->{$field->userfield} = $info->value; |
148 | - } |
|
148 | + } |
|
149 | 149 | } |
150 | - } |
|
151 | - foreach ($relations as $rel) { |
|
150 | + } |
|
151 | + foreach ($relations as $rel) { |
|
152 | 152 | $user->$rel->save(); |
153 | - } |
|
154 | - $user->save(); |
|
153 | + } |
|
154 | + $user->save(); |
|
155 | 155 | } |
156 | 156 | return $save; |
157 | - } |
|
157 | + } |
|
158 | 158 | |
159 | - public function getCurCart($create = true) { |
|
159 | + public function getCurCart($create = true) { |
|
160 | 160 | $cart = false; |
161 | 161 | if (!empty($_SESSION['cart']['cart_id'])) { |
162 | - $cart = Ecommerce\Cart::get((int) $_SESSION['cart']['cart_id']); |
|
162 | + $cart = Ecommerce\Cart::get((int) $_SESSION['cart']['cart_id']); |
|
163 | 163 | } |
164 | 164 | if (!$cart && $create) { |
165 | - $cart = new Ecommerce\Cart(); |
|
166 | - $cart->cart_status_id = 1; |
|
167 | - $cart->user_id = Users\User::$cur->id; |
|
168 | - $userCard = \Ecommerce\Card\Item::get(\Users\User::$cur->id, 'user_id'); |
|
169 | - if ($userCard) { |
|
165 | + $cart = new Ecommerce\Cart(); |
|
166 | + $cart->cart_status_id = 1; |
|
167 | + $cart->user_id = Users\User::$cur->id; |
|
168 | + $userCard = \Ecommerce\Card\Item::get(\Users\User::$cur->id, 'user_id'); |
|
169 | + if ($userCard) { |
|
170 | 170 | $cart->card_item_id = $userCard->id; |
171 | - } |
|
172 | - $cart->save(); |
|
173 | - $_SESSION['cart']['cart_id'] = $cart->id; |
|
171 | + } |
|
172 | + $cart->save(); |
|
173 | + $_SESSION['cart']['cart_id'] = $cart->id; |
|
174 | 174 | } |
175 | 175 | return $cart; |
176 | - } |
|
176 | + } |
|
177 | 177 | |
178 | - public function parseOptions($options = []) { |
|
178 | + public function parseOptions($options = []) { |
|
179 | 179 | $selectOptions = [ |
180 | 180 | 'where' => !empty($options['where']) ? $options['where'] : [], |
181 | 181 | 'distinct' => false, |
@@ -186,26 +186,26 @@ discard block |
||
186 | 186 | 'limit' => !empty($options['count']) ? (int) $options['count'] : 0, |
187 | 187 | ]; |
188 | 188 | if (!empty($options['sort']) && is_array($options['sort'])) { |
189 | - foreach ($options['sort'] as $col => $direction) { |
|
189 | + foreach ($options['sort'] as $col => $direction) { |
|
190 | 190 | switch ($col) { |
191 | - case 'price': |
|
191 | + case 'price': |
|
192 | 192 | $selectOptions['order'][] = [Ecommerce\Item\Offer\Price::colPrefix() . 'price', strtolower($direction) == 'desc' ? 'desc' : 'asc']; |
193 | 193 | break; |
194 | - case 'name': |
|
194 | + case 'name': |
|
195 | 195 | $selectOptions['order'][] = ['name', strtolower($direction) == 'desc' ? 'desc' : 'asc']; |
196 | 196 | break; |
197 | - case 'sales': |
|
197 | + case 'sales': |
|
198 | 198 | $selectOptions['order'][] = ['sales', strtolower($direction) == 'desc' ? 'desc' : 'asc']; |
199 | 199 | break; |
200 | - case 'weight': |
|
200 | + case 'weight': |
|
201 | 201 | $selectOptions['order'][] = ['weight', strtolower($direction) == 'desc' ? 'desc' : 'asc']; |
202 | 202 | break; |
203 | 203 | } |
204 | - } |
|
204 | + } |
|
205 | 205 | } |
206 | 206 | $selectOptions['where'][] = ['deleted', 0]; |
207 | 207 | if (empty($this->config['view_empty_image'])) { |
208 | - $selectOptions['where'][] = ['image_file_id', 0, '!=']; |
|
208 | + $selectOptions['where'][] = ['image_file_id', 0, '!=']; |
|
209 | 209 | } |
210 | 210 | |
211 | 211 | $selectOptions['join'][] = [Ecommerce\Item\Offer::table(), Ecommerce\Item::index() . ' = ' . Ecommerce\Item\Offer::colPrefix() . Ecommerce\Item::index(), 'inner']; |
@@ -229,111 +229,111 @@ discard block |
||
229 | 229 | |
230 | 230 | |
231 | 231 | if (!empty($this->config['view_filter'])) { |
232 | - if (!empty($this->config['view_filter']['options'])) { |
|
232 | + if (!empty($this->config['view_filter']['options'])) { |
|
233 | 233 | foreach ($this->config['view_filter']['options'] as $optionId => $optionValue) { |
234 | - $selectOptions['join'][] = [Ecommerce\Item\Param::table(), Ecommerce\Item::index() . ' = ' . 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item::index() . ' AND ' . |
|
235 | - 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
236 | - 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . 'value = "' . (int) $optionValue . '"', |
|
237 | - 'inner', 'option' . $optionId]; |
|
234 | + $selectOptions['join'][] = [Ecommerce\Item\Param::table(), Ecommerce\Item::index() . ' = ' . 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item::index() . ' AND ' . |
|
235 | + 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
236 | + 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . 'value = "' . (int) $optionValue . '"', |
|
237 | + 'inner', 'option' . $optionId]; |
|
238 | + } |
|
238 | 239 | } |
239 | - } |
|
240 | 240 | } |
241 | 241 | //filters |
242 | 242 | if (!empty($options['filters'])) { |
243 | - foreach ($options['filters'] as $col => $filter) { |
|
243 | + foreach ($options['filters'] as $col => $filter) { |
|
244 | 244 | switch ($col) { |
245 | - case 'price': |
|
245 | + case 'price': |
|
246 | 246 | if (!empty($filter['min'])) { |
247 | - $selectOptions['where'][] = [Ecommerce\Item\Offer\Price::colPrefix() . 'price', (float) $filter['min'], '>=']; |
|
247 | + $selectOptions['where'][] = [Ecommerce\Item\Offer\Price::colPrefix() . 'price', (float) $filter['min'], '>=']; |
|
248 | 248 | } |
249 | 249 | if (!empty($filter['max'])) { |
250 | - $selectOptions['where'][] = [Ecommerce\Item\Offer\Price::colPrefix() . 'price', (float) $filter['max'], '<=']; |
|
250 | + $selectOptions['where'][] = [Ecommerce\Item\Offer\Price::colPrefix() . 'price', (float) $filter['max'], '<=']; |
|
251 | 251 | } |
252 | 252 | break; |
253 | - case 'options': |
|
253 | + case 'options': |
|
254 | 254 | foreach ($filter as $optionId => $optionValue) { |
255 | - $optionId = (int) $optionId; |
|
256 | - if (is_array($optionValue)) { |
|
255 | + $optionId = (int) $optionId; |
|
256 | + if (is_array($optionValue)) { |
|
257 | 257 | $optionValueArr = []; |
258 | 258 | foreach ($optionValue as $val) { |
259 | - $optionValueArr[] = \App::$cur->db->connection->pdo->quote($val); |
|
259 | + $optionValueArr[] = \App::$cur->db->connection->pdo->quote($val); |
|
260 | 260 | } |
261 | 261 | $qstr = 'IN (' . implode(',', $optionValueArr) . ')'; |
262 | - } else { |
|
262 | + } else { |
|
263 | 263 | $qstr = '= ' . \App::$cur->db->connection->pdo->quote($optionValue); |
264 | - } |
|
265 | - $selectOptions['join'][] = [Ecommerce\Item\Param::table(), Ecommerce\Item::index() . ' = ' . 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item::index() . ' AND ' . |
|
266 | - 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
267 | - 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . 'value ' . $qstr . '', |
|
268 | - 'inner', 'option' . $optionId]; |
|
264 | + } |
|
265 | + $selectOptions['join'][] = [Ecommerce\Item\Param::table(), Ecommerce\Item::index() . ' = ' . 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item::index() . ' AND ' . |
|
266 | + 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
267 | + 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . 'value ' . $qstr . '', |
|
268 | + 'inner', 'option' . $optionId]; |
|
269 | 269 | } |
270 | 270 | break; |
271 | - case 'offerOptions': |
|
271 | + case 'offerOptions': |
|
272 | 272 | //$selectOptions['join'][] = [Ecommerce\Item\Offer::table(), Ecommerce\Item::index() . ' = offer.' . Ecommerce\Item\Offer::colPrefix() . Ecommerce\Item::index(), 'left', 'offer']; |
273 | 273 | foreach ($filter as $optionId => $optionValue) { |
274 | - $optionId = (int) $optionId; |
|
275 | - if (is_array($optionValue)) { |
|
274 | + $optionId = (int) $optionId; |
|
275 | + if (is_array($optionValue)) { |
|
276 | 276 | $optionValueArr = []; |
277 | 277 | foreach ($optionValue as $val) { |
278 | - $optionValueArr[] = \App::$cur->db->connection->pdo->quote($val); |
|
278 | + $optionValueArr[] = \App::$cur->db->connection->pdo->quote($val); |
|
279 | 279 | } |
280 | 280 | $qstr = 'IN (' . implode(',', $optionValueArr) . ')'; |
281 | - } else { |
|
281 | + } else { |
|
282 | 282 | $qstr = '= ' . \App::$cur->db->connection->pdo->quote($optionValue); |
283 | - } |
|
284 | - $selectOptions['join'][] = [Ecommerce\Item\Offer\Param::table(), Ecommerce\Item\Offer::index() . ' = ' . 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . Ecommerce\Item\Offer::index() . ' AND ' . |
|
285 | - 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . Ecommerce\Item\Offer\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
286 | - 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . 'value ' . $qstr, |
|
287 | - 'inner', 'offerOption' . $optionId]; |
|
283 | + } |
|
284 | + $selectOptions['join'][] = [Ecommerce\Item\Offer\Param::table(), Ecommerce\Item\Offer::index() . ' = ' . 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . Ecommerce\Item\Offer::index() . ' AND ' . |
|
285 | + 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . Ecommerce\Item\Offer\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
286 | + 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . 'value ' . $qstr, |
|
287 | + 'inner', 'offerOption' . $optionId]; |
|
288 | 288 | } |
289 | 289 | break; |
290 | 290 | } |
291 | - } |
|
291 | + } |
|
292 | 292 | } |
293 | 293 | //parents |
294 | 294 | if (!empty($options['parent']) && strpos($options['parent'], ',') !== false) { |
295 | - $first = true; |
|
296 | - $where = []; |
|
297 | - foreach (explode(',', $options['parent']) as $categoryId) { |
|
295 | + $first = true; |
|
296 | + $where = []; |
|
297 | + foreach (explode(',', $options['parent']) as $categoryId) { |
|
298 | 298 | if (!$categoryId) { |
299 | - continue; |
|
299 | + continue; |
|
300 | 300 | } |
301 | 301 | $category = \Ecommerce\Category::get($categoryId); |
302 | 302 | $where[] = ['tree_path', $category->tree_path . (int) $categoryId . '/%', 'LIKE', $first ? 'AND' : 'OR']; |
303 | 303 | $first = false; |
304 | - } |
|
305 | - $selectOptions['where'][] = $where; |
|
304 | + } |
|
305 | + $selectOptions['where'][] = $where; |
|
306 | 306 | } elseif (!empty($options['parent'])) { |
307 | - $category = \Ecommerce\Category::get($options['parent']); |
|
308 | - $selectOptions['where'][] = ['tree_path', $category->tree_path . (int) $options['parent'] . '/%', 'LIKE']; |
|
307 | + $category = \Ecommerce\Category::get($options['parent']); |
|
308 | + $selectOptions['where'][] = ['tree_path', $category->tree_path . (int) $options['parent'] . '/%', 'LIKE']; |
|
309 | 309 | } |
310 | 310 | |
311 | 311 | //search |
312 | 312 | if (!empty($options['search'])) { |
313 | - $searchStr = preg_replace('![^A-zА-я0-9 ]!iSu', ' ', $options['search']); |
|
314 | - $searchArr = []; |
|
315 | - foreach (explode(' ', $searchStr) as $part) { |
|
313 | + $searchStr = preg_replace('![^A-zА-я0-9 ]!iSu', ' ', $options['search']); |
|
314 | + $searchArr = []; |
|
315 | + foreach (explode(' ', $searchStr) as $part) { |
|
316 | 316 | $part = trim($part); |
317 | 317 | if ($part && strlen($part) > 2) { |
318 | - $searchArr[] = ['search_index', '%' . $part . '%', 'LIKE']; |
|
318 | + $searchArr[] = ['search_index', '%' . $part . '%', 'LIKE']; |
|
319 | + } |
|
319 | 320 | } |
320 | - } |
|
321 | - if (!empty($searchArr)) { |
|
321 | + if (!empty($searchArr)) { |
|
322 | 322 | $selectOptions['where'][] = $searchArr; |
323 | - } |
|
323 | + } |
|
324 | 324 | } |
325 | 325 | if (empty($this->config['view_empty_warehouse'])) { |
326 | - $warehouseIds = []; |
|
327 | - if (class_exists('Geography\City\Data')) { |
|
326 | + $warehouseIds = []; |
|
327 | + if (class_exists('Geography\City\Data')) { |
|
328 | 328 | $warehouses = \Geography\City\Data::get([['code', 'warehouses'], ['city_id', \Geography\City::$cur->id]]); |
329 | 329 | if ($warehouses && $warehouses->data) { |
330 | - foreach (explode(',', $warehouses->data) as $id) { |
|
330 | + foreach (explode(',', $warehouses->data) as $id) { |
|
331 | 331 | $warehouseIds[$id] = $id; |
332 | - } |
|
332 | + } |
|
333 | + } |
|
333 | 334 | } |
334 | - } |
|
335 | - $selectOptions['where'][] = [ |
|
336 | - '( |
|
335 | + $selectOptions['where'][] = [ |
|
336 | + '( |
|
337 | 337 | (SELECT COALESCE(sum(`' . \Ecommerce\Item\Offer\Warehouse::colPrefix() . 'count`),0) |
338 | 338 | FROM ' . \App::$cur->db->table_prefix . \Ecommerce\Item\Offer\Warehouse::table() . ' iciw |
339 | 339 | WHERE iciw.' . \Ecommerce\Item\Offer\Warehouse::colPrefix() . \Ecommerce\Item\Offer::index() . ' = ' . \Ecommerce\Item\Offer::index() . ' |
@@ -348,9 +348,9 @@ discard block |
||
348 | 348 | ) |
349 | 349 | WHERE iewb.' . \Ecommerce\Warehouse\Block::colPrefix() . \Ecommerce\Item\Offer::index() . ' = ' . \Ecommerce\Item\Offer::index() . ') |
350 | 350 | )', |
351 | - 0, |
|
352 | - '>' |
|
353 | - ]; |
|
351 | + 0, |
|
352 | + '>' |
|
353 | + ]; |
|
354 | 354 | } |
355 | 355 | |
356 | 356 | |
@@ -361,15 +361,15 @@ discard block |
||
361 | 361 | $selectOptions['group'] = Ecommerce\Item::index(); |
362 | 362 | |
363 | 363 | return $selectOptions; |
364 | - } |
|
365 | - |
|
366 | - /** |
|
367 | - * Getting items params with params |
|
368 | - * |
|
369 | - * @param array $params |
|
370 | - * @return array |
|
371 | - */ |
|
372 | - public function getItemsParams($params = []) { |
|
364 | + } |
|
365 | + |
|
366 | + /** |
|
367 | + * Getting items params with params |
|
368 | + * |
|
369 | + * @param array $params |
|
370 | + * @return array |
|
371 | + */ |
|
372 | + public function getItemsParams($params = []) { |
|
373 | 373 | $selectOptions = $this->parseOptions($params); |
374 | 374 | $items = Ecommerce\Item::getList($selectOptions); |
375 | 375 | $items = Ecommerce\Item\Param::getList([ |
@@ -378,58 +378,58 @@ discard block |
||
378 | 378 | 'distinct' => \Ecommerce\Item\Option::index() |
379 | 379 | ]); |
380 | 380 | return $items; |
381 | - } |
|
382 | - |
|
383 | - /** |
|
384 | - * Getting items with params |
|
385 | - * |
|
386 | - * @param array $params |
|
387 | - * @return array |
|
388 | - */ |
|
389 | - public function getItems($params = []) { |
|
381 | + } |
|
382 | + |
|
383 | + /** |
|
384 | + * Getting items with params |
|
385 | + * |
|
386 | + * @param array $params |
|
387 | + * @return array |
|
388 | + */ |
|
389 | + public function getItems($params = []) { |
|
390 | 390 | $selectOptions = $this->parseOptions($params); |
391 | 391 | $items = Ecommerce\Item::getList($selectOptions); |
392 | 392 | return $items; |
393 | - } |
|
394 | - |
|
395 | - /** |
|
396 | - * Return count of items with params |
|
397 | - * |
|
398 | - * @param array $params |
|
399 | - * @return int |
|
400 | - */ |
|
401 | - public function getItemsCount($params = []) { |
|
393 | + } |
|
394 | + |
|
395 | + /** |
|
396 | + * Return count of items with params |
|
397 | + * |
|
398 | + * @param array $params |
|
399 | + * @return int |
|
400 | + */ |
|
401 | + public function getItemsCount($params = []) { |
|
402 | 402 | $selectOptions = $this->parseOptions($params); |
403 | 403 | $selectOptions['distinct'] = \Ecommerce\Item::index(); |
404 | 404 | $counts = Ecommerce\Item::getCount($selectOptions); |
405 | 405 | if (is_array($counts)) { |
406 | - $sum = 0; |
|
407 | - foreach ($counts as $count) { |
|
406 | + $sum = 0; |
|
407 | + foreach ($counts as $count) { |
|
408 | 408 | $sum +=$count['count']; |
409 | - } |
|
410 | - return $sum; |
|
409 | + } |
|
410 | + return $sum; |
|
411 | 411 | } |
412 | 412 | return $counts; |
413 | - } |
|
413 | + } |
|
414 | 414 | |
415 | - public function viewsCategoryList($inherit = true) { |
|
415 | + public function viewsCategoryList($inherit = true) { |
|
416 | 416 | $return = []; |
417 | 417 | if ($inherit) { |
418 | - $return['inherit'] = 'Как у родителя'; |
|
418 | + $return['inherit'] = 'Как у родителя'; |
|
419 | 419 | } |
420 | 420 | $return['itemList'] = 'Список товаров'; |
421 | 421 | $conf = App::$primary->view->template->config; |
422 | 422 | if (!empty($conf['files']['modules']['Ecommerce'])) { |
423 | - foreach ($conf['files']['modules']['Ecommerce'] as $file) { |
|
423 | + foreach ($conf['files']['modules']['Ecommerce'] as $file) { |
|
424 | 424 | if ($file['type'] == 'Category') { |
425 | - $return[$file['file']] = $file['name']; |
|
425 | + $return[$file['file']] = $file['name']; |
|
426 | + } |
|
426 | 427 | } |
427 | - } |
|
428 | 428 | } |
429 | 429 | return $return; |
430 | - } |
|
430 | + } |
|
431 | 431 | |
432 | - public function templatesCategoryList() { |
|
432 | + public function templatesCategoryList() { |
|
433 | 433 | $return = [ |
434 | 434 | 'inherit' => 'Как у родителя', |
435 | 435 | 'current' => 'Текущая тема' |
@@ -438,107 +438,107 @@ discard block |
||
438 | 438 | $conf = App::$primary->view->template->config; |
439 | 439 | |
440 | 440 | if (!empty($conf['files']['aditionTemplateFiels'])) { |
441 | - foreach ($conf['files']['aditionTemplateFiels'] as $file) { |
|
441 | + foreach ($conf['files']['aditionTemplateFiels'] as $file) { |
|
442 | 442 | $return[$file['file']] = '- ' . $file['name']; |
443 | - } |
|
443 | + } |
|
444 | 444 | } |
445 | 445 | return $return; |
446 | - } |
|
446 | + } |
|
447 | 447 | |
448 | - public function cartStatusDetector($event) { |
|
448 | + public function cartStatusDetector($event) { |
|
449 | 449 | $cart = $event['eventObject']; |
450 | 450 | if (!empty($cart->_changedParams['cart_cart_status_id'])) { |
451 | - $cart->date_status = date('Y-m-d H:i:s'); |
|
452 | - $event = new Ecommerce\Cart\Event(['cart_id' => $cart->id, 'user_id' => \Users\User::$cur->id, 'cart_event_type_id' => 5, 'info' => $cart->cart_status_id]); |
|
453 | - $event->save(); |
|
451 | + $cart->date_status = date('Y-m-d H:i:s'); |
|
452 | + $event = new Ecommerce\Cart\Event(['cart_id' => $cart->id, 'user_id' => \Users\User::$cur->id, 'cart_event_type_id' => 5, 'info' => $cart->cart_status_id]); |
|
453 | + $event->save(); |
|
454 | 454 | |
455 | - $prev_status_id = $cart->_changedParams['cart_cart_status_id']; |
|
456 | - $now_status_id = $cart->cart_status_id; |
|
455 | + $prev_status_id = $cart->_changedParams['cart_cart_status_id']; |
|
456 | + $now_status_id = $cart->cart_status_id; |
|
457 | 457 | |
458 | - $status = Ecommerce\Cart\Status::getList(['where' => ['id', implode(',', [$prev_status_id, $now_status_id]), 'IN']]); |
|
458 | + $status = Ecommerce\Cart\Status::getList(['where' => ['id', implode(',', [$prev_status_id, $now_status_id]), 'IN']]); |
|
459 | 459 | |
460 | - $prefix = isset(App::$cur->ecommerce->config['orderPrefix']) ? $config = App::$cur->ecommerce->config['orderPrefix'] : ''; |
|
461 | - \App::$cur->users->AddUserActivity($cart->user_id, 3, "Статус вашего заказа номер {$prefix}{$cart->id} изменился с {$status[$prev_status_id]->name} на {$status[$now_status_id]->name}"); |
|
460 | + $prefix = isset(App::$cur->ecommerce->config['orderPrefix']) ? $config = App::$cur->ecommerce->config['orderPrefix'] : ''; |
|
461 | + \App::$cur->users->AddUserActivity($cart->user_id, 3, "Статус вашего заказа номер {$prefix}{$cart->id} изменился с {$status[$prev_status_id]->name} на {$status[$now_status_id]->name}"); |
|
462 | 462 | |
463 | - if ($cart->cart_status_id == 5) { |
|
463 | + if ($cart->cart_status_id == 5) { |
|
464 | 464 | Inji::$inst->event('ecommerceCartClosed', $cart); |
465 | - } |
|
465 | + } |
|
466 | 466 | } |
467 | 467 | return $cart; |
468 | - } |
|
468 | + } |
|
469 | 469 | |
470 | - public function cardTrigger($event) { |
|
470 | + public function cardTrigger($event) { |
|
471 | 471 | $cart = $event['eventObject']; |
472 | 472 | if ($cart->card) { |
473 | - $sum = 0; |
|
474 | - foreach ($cart->cartItems as $cartItem) { |
|
473 | + $sum = 0; |
|
474 | + foreach ($cart->cartItems as $cartItem) { |
|
475 | 475 | $sum += $cartItem->final_price * $cartItem->count; |
476 | - } |
|
477 | - $cardItemHistory = new Ecommerce\Card\Item\History(); |
|
478 | - $cardItemHistory->amount = $sum; |
|
479 | - $cardItemHistory->card_item_id = $cart->card_item_id; |
|
480 | - $cardItemHistory->save(); |
|
481 | - $cart->card->sum += $sum; |
|
482 | - $cart->card->save(); |
|
476 | + } |
|
477 | + $cardItemHistory = new Ecommerce\Card\Item\History(); |
|
478 | + $cardItemHistory->amount = $sum; |
|
479 | + $cardItemHistory->card_item_id = $cart->card_item_id; |
|
480 | + $cardItemHistory->save(); |
|
481 | + $cart->card->sum += $sum; |
|
482 | + $cart->card->save(); |
|
483 | 483 | } |
484 | 484 | return $cart; |
485 | - } |
|
485 | + } |
|
486 | 486 | |
487 | - public function bonusTrigger($event) { |
|
487 | + public function bonusTrigger($event) { |
|
488 | 488 | $cart = $event['eventObject']; |
489 | 489 | foreach ($cart->cartItems as $cartItem) { |
490 | - foreach ($cartItem->price->offer->bonuses as $bonus) { |
|
490 | + foreach ($cartItem->price->offer->bonuses as $bonus) { |
|
491 | 491 | if ($bonus->limited && $bonus->left <= 0) { |
492 | - continue; |
|
492 | + continue; |
|
493 | 493 | } elseif ($bonus->limited && $bonus->left > 0) { |
494 | - $bonus->left -= 1; |
|
495 | - $bonus->save(); |
|
494 | + $bonus->left -= 1; |
|
495 | + $bonus->save(); |
|
496 | 496 | } |
497 | 497 | switch ($bonus->type) { |
498 | - case'currency': |
|
498 | + case'currency': |
|
499 | 499 | $currency = \Money\Currency::get($bonus->value); |
500 | 500 | $wallets = App::$cur->money->getUserWallets($cart->user->id); |
501 | 501 | $wallets[$currency->id]->diff($bonus->count, 'Бонус за покупку'); |
502 | 502 | break; |
503 | 503 | } |
504 | - } |
|
504 | + } |
|
505 | 505 | } |
506 | 506 | return $cart; |
507 | - } |
|
507 | + } |
|
508 | 508 | |
509 | - function sitemap() { |
|
509 | + function sitemap() { |
|
510 | 510 | $map = []; |
511 | 511 | $zeroItems = \Ecommerce\Item::getList(['where' => ['category_id', 0]]); |
512 | 512 | foreach ($zeroItems as $item) { |
513 | - $map[] = [ |
|
514 | - 'name' => $item->name, |
|
515 | - 'url' => [ |
|
516 | - 'loc' => (!empty($_SERVER['HTTPS']) ? 'https' : 'http') . '://' . INJI_DOMAIN_NAME . ($item->getHref()) |
|
517 | - ], |
|
518 | - ]; |
|
513 | + $map[] = [ |
|
514 | + 'name' => $item->name, |
|
515 | + 'url' => [ |
|
516 | + 'loc' => (!empty($_SERVER['HTTPS']) ? 'https' : 'http') . '://' . INJI_DOMAIN_NAME . ($item->getHref()) |
|
517 | + ], |
|
518 | + ]; |
|
519 | 519 | } |
520 | 520 | |
521 | 521 | $categorys = \Ecommerce\Category::getList(['where' => ['parent_id', 0]]); |
522 | 522 | $scan = function($category, $scan) { |
523 | - $map = []; |
|
523 | + $map = []; |
|
524 | 524 | |
525 | - foreach ($category->items as $item) { |
|
525 | + foreach ($category->items as $item) { |
|
526 | 526 | $map[] = [ |
527 | 527 | 'name' => $item->name, |
528 | 528 | 'url' => [ |
529 | 529 | 'loc' => (!empty($_SERVER['HTTPS']) ? 'https' : 'http') . '://' . INJI_DOMAIN_NAME . ($item->getHref()) |
530 | 530 | ], |
531 | 531 | ]; |
532 | - } |
|
533 | - foreach ($category->catalogs as $child) { |
|
532 | + } |
|
533 | + foreach ($category->catalogs as $child) { |
|
534 | 534 | $map = array_merge($map, $scan($child, $scan)); |
535 | - } |
|
536 | - return $map; |
|
535 | + } |
|
536 | + return $map; |
|
537 | 537 | }; |
538 | 538 | foreach ($categorys as $category) { |
539 | - $map = array_merge($map, $scan($category, $scan)); |
|
539 | + $map = array_merge($map, $scan($category, $scan)); |
|
540 | 540 | } |
541 | 541 | return $map; |
542 | - } |
|
542 | + } |
|
543 | 543 | |
544 | 544 | } |
@@ -48,7 +48,7 @@ discard block |
||
48 | 48 | $name = ''; |
49 | 49 | foreach ($fields as $field) { |
50 | 50 | if ($field->save && !empty($data[$field->id])) { |
51 | - $name .= htmlspecialchars($data[$field->id]) . ' '; |
|
51 | + $name .= htmlspecialchars($data[$field->id]).' '; |
|
52 | 52 | } |
53 | 53 | } |
54 | 54 | $name = trim($name); |
@@ -104,7 +104,7 @@ discard block |
||
104 | 104 | $name = ''; |
105 | 105 | foreach ($fields as $field) { |
106 | 106 | if ($field->save && !empty($data[$field->id])) { |
107 | - $name .= htmlspecialchars($data[$field->id]) . ' '; |
|
107 | + $name .= htmlspecialchars($data[$field->id]).' '; |
|
108 | 108 | } |
109 | 109 | } |
110 | 110 | $name = trim($name); |
@@ -189,7 +189,7 @@ discard block |
||
189 | 189 | foreach ($options['sort'] as $col => $direction) { |
190 | 190 | switch ($col) { |
191 | 191 | case 'price': |
192 | - $selectOptions['order'][] = [Ecommerce\Item\Offer\Price::colPrefix() . 'price', strtolower($direction) == 'desc' ? 'desc' : 'asc']; |
|
192 | + $selectOptions['order'][] = [Ecommerce\Item\Offer\Price::colPrefix().'price', strtolower($direction) == 'desc' ? 'desc' : 'asc']; |
|
193 | 193 | break; |
194 | 194 | case 'name': |
195 | 195 | $selectOptions['order'][] = ['name', strtolower($direction) == 'desc' ? 'desc' : 'asc']; |
@@ -208,22 +208,22 @@ discard block |
||
208 | 208 | $selectOptions['where'][] = ['image_file_id', 0, '!=']; |
209 | 209 | } |
210 | 210 | |
211 | - $selectOptions['join'][] = [Ecommerce\Item\Offer::table(), Ecommerce\Item::index() . ' = ' . Ecommerce\Item\Offer::colPrefix() . Ecommerce\Item::index(), 'inner']; |
|
211 | + $selectOptions['join'][] = [Ecommerce\Item\Offer::table(), Ecommerce\Item::index().' = '.Ecommerce\Item\Offer::colPrefix().Ecommerce\Item::index(), 'inner']; |
|
212 | 212 | |
213 | 213 | $selectOptions['join'][] = [Ecommerce\Item\Offer\Price::table(), |
214 | - Ecommerce\Item\Offer::index() . ' = ' . Ecommerce\Item\Offer\Price::colPrefix() . Ecommerce\Item\Offer::index() . |
|
215 | - (empty($this->config['show_zero_price']) ? ' and ' . Ecommerce\Item\Offer\Price::colPrefix() . 'price>0' : ''), |
|
214 | + Ecommerce\Item\Offer::index().' = '.Ecommerce\Item\Offer\Price::colPrefix().Ecommerce\Item\Offer::index(). |
|
215 | + (empty($this->config['show_zero_price']) ? ' and '.Ecommerce\Item\Offer\Price::colPrefix().'price>0' : ''), |
|
216 | 216 | empty($this->config['show_without_price']) ? 'inner' : 'left']; |
217 | 217 | |
218 | 218 | $selectOptions['join'][] = [ |
219 | - Ecommerce\Item\Offer\Price\Type::table(), Ecommerce\Item\Offer\Price::colPrefix() . Ecommerce\Item\Offer\Price\Type::index() . ' = ' . Ecommerce\Item\Offer\Price\Type::index() |
|
219 | + Ecommerce\Item\Offer\Price\Type::table(), Ecommerce\Item\Offer\Price::colPrefix().Ecommerce\Item\Offer\Price\Type::index().' = '.Ecommerce\Item\Offer\Price\Type::index() |
|
220 | 220 | ]; |
221 | 221 | |
222 | 222 | $selectOptions['where'][] = [ |
223 | 223 | [Ecommerce\Item\Offer\Price\Type::index(), NULL, 'is'], |
224 | 224 | [ |
225 | - [Ecommerce\Item\Offer\Price\Type::colPrefix() . 'roles', '', '=', 'OR'], |
|
226 | - [Ecommerce\Item\Offer\Price\Type::colPrefix() . 'roles', '%|' . \Users\User::$cur->role_id . '|%', 'LIKE', 'OR'], |
|
225 | + [Ecommerce\Item\Offer\Price\Type::colPrefix().'roles', '', '=', 'OR'], |
|
226 | + [Ecommerce\Item\Offer\Price\Type::colPrefix().'roles', '%|'.\Users\User::$cur->role_id.'|%', 'LIKE', 'OR'], |
|
227 | 227 | ], |
228 | 228 | ]; |
229 | 229 | |
@@ -231,10 +231,10 @@ discard block |
||
231 | 231 | if (!empty($this->config['view_filter'])) { |
232 | 232 | if (!empty($this->config['view_filter']['options'])) { |
233 | 233 | foreach ($this->config['view_filter']['options'] as $optionId => $optionValue) { |
234 | - $selectOptions['join'][] = [Ecommerce\Item\Param::table(), Ecommerce\Item::index() . ' = ' . 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item::index() . ' AND ' . |
|
235 | - 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
236 | - 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . 'value = "' . (int) $optionValue . '"', |
|
237 | - 'inner', 'option' . $optionId]; |
|
234 | + $selectOptions['join'][] = [Ecommerce\Item\Param::table(), Ecommerce\Item::index().' = '.'option'.$optionId.'.'.Ecommerce\Item\Param::colPrefix().Ecommerce\Item::index().' AND '. |
|
235 | + 'option'.$optionId.'.'.Ecommerce\Item\Param::colPrefix().Ecommerce\Item\Option::index().' = "'.(int) $optionId.'" AND '. |
|
236 | + 'option'.$optionId.'.'.Ecommerce\Item\Param::colPrefix().'value = "'.(int) $optionValue.'"', |
|
237 | + 'inner', 'option'.$optionId]; |
|
238 | 238 | } |
239 | 239 | } |
240 | 240 | } |
@@ -244,10 +244,10 @@ discard block |
||
244 | 244 | switch ($col) { |
245 | 245 | case 'price': |
246 | 246 | if (!empty($filter['min'])) { |
247 | - $selectOptions['where'][] = [Ecommerce\Item\Offer\Price::colPrefix() . 'price', (float) $filter['min'], '>=']; |
|
247 | + $selectOptions['where'][] = [Ecommerce\Item\Offer\Price::colPrefix().'price', (float) $filter['min'], '>=']; |
|
248 | 248 | } |
249 | 249 | if (!empty($filter['max'])) { |
250 | - $selectOptions['where'][] = [Ecommerce\Item\Offer\Price::colPrefix() . 'price', (float) $filter['max'], '<=']; |
|
250 | + $selectOptions['where'][] = [Ecommerce\Item\Offer\Price::colPrefix().'price', (float) $filter['max'], '<=']; |
|
251 | 251 | } |
252 | 252 | break; |
253 | 253 | case 'options': |
@@ -258,14 +258,14 @@ discard block |
||
258 | 258 | foreach ($optionValue as $val) { |
259 | 259 | $optionValueArr[] = \App::$cur->db->connection->pdo->quote($val); |
260 | 260 | } |
261 | - $qstr = 'IN (' . implode(',', $optionValueArr) . ')'; |
|
261 | + $qstr = 'IN ('.implode(',', $optionValueArr).')'; |
|
262 | 262 | } else { |
263 | - $qstr = '= ' . \App::$cur->db->connection->pdo->quote($optionValue); |
|
263 | + $qstr = '= '.\App::$cur->db->connection->pdo->quote($optionValue); |
|
264 | 264 | } |
265 | - $selectOptions['join'][] = [Ecommerce\Item\Param::table(), Ecommerce\Item::index() . ' = ' . 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item::index() . ' AND ' . |
|
266 | - 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . Ecommerce\Item\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
267 | - 'option' . $optionId . '.' . Ecommerce\Item\Param::colPrefix() . 'value ' . $qstr . '', |
|
268 | - 'inner', 'option' . $optionId]; |
|
265 | + $selectOptions['join'][] = [Ecommerce\Item\Param::table(), Ecommerce\Item::index().' = '.'option'.$optionId.'.'.Ecommerce\Item\Param::colPrefix().Ecommerce\Item::index().' AND '. |
|
266 | + 'option'.$optionId.'.'.Ecommerce\Item\Param::colPrefix().Ecommerce\Item\Option::index().' = "'.(int) $optionId.'" AND '. |
|
267 | + 'option'.$optionId.'.'.Ecommerce\Item\Param::colPrefix().'value '.$qstr.'', |
|
268 | + 'inner', 'option'.$optionId]; |
|
269 | 269 | } |
270 | 270 | break; |
271 | 271 | case 'offerOptions': |
@@ -277,14 +277,14 @@ discard block |
||
277 | 277 | foreach ($optionValue as $val) { |
278 | 278 | $optionValueArr[] = \App::$cur->db->connection->pdo->quote($val); |
279 | 279 | } |
280 | - $qstr = 'IN (' . implode(',', $optionValueArr) . ')'; |
|
280 | + $qstr = 'IN ('.implode(',', $optionValueArr).')'; |
|
281 | 281 | } else { |
282 | - $qstr = '= ' . \App::$cur->db->connection->pdo->quote($optionValue); |
|
282 | + $qstr = '= '.\App::$cur->db->connection->pdo->quote($optionValue); |
|
283 | 283 | } |
284 | - $selectOptions['join'][] = [Ecommerce\Item\Offer\Param::table(), Ecommerce\Item\Offer::index() . ' = ' . 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . Ecommerce\Item\Offer::index() . ' AND ' . |
|
285 | - 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . Ecommerce\Item\Offer\Option::index() . ' = "' . (int) $optionId . '" AND ' . |
|
286 | - 'offerOption' . $optionId . '.' . Ecommerce\Item\Offer\Param::colPrefix() . 'value ' . $qstr, |
|
287 | - 'inner', 'offerOption' . $optionId]; |
|
284 | + $selectOptions['join'][] = [Ecommerce\Item\Offer\Param::table(), Ecommerce\Item\Offer::index().' = '.'offerOption'.$optionId.'.'.Ecommerce\Item\Offer\Param::colPrefix().Ecommerce\Item\Offer::index().' AND '. |
|
285 | + 'offerOption'.$optionId.'.'.Ecommerce\Item\Offer\Param::colPrefix().Ecommerce\Item\Offer\Option::index().' = "'.(int) $optionId.'" AND '. |
|
286 | + 'offerOption'.$optionId.'.'.Ecommerce\Item\Offer\Param::colPrefix().'value '.$qstr, |
|
287 | + 'inner', 'offerOption'.$optionId]; |
|
288 | 288 | } |
289 | 289 | break; |
290 | 290 | } |
@@ -299,13 +299,13 @@ discard block |
||
299 | 299 | continue; |
300 | 300 | } |
301 | 301 | $category = \Ecommerce\Category::get($categoryId); |
302 | - $where[] = ['tree_path', $category->tree_path . (int) $categoryId . '/%', 'LIKE', $first ? 'AND' : 'OR']; |
|
302 | + $where[] = ['tree_path', $category->tree_path.(int) $categoryId.'/%', 'LIKE', $first ? 'AND' : 'OR']; |
|
303 | 303 | $first = false; |
304 | 304 | } |
305 | 305 | $selectOptions['where'][] = $where; |
306 | 306 | } elseif (!empty($options['parent'])) { |
307 | 307 | $category = \Ecommerce\Category::get($options['parent']); |
308 | - $selectOptions['where'][] = ['tree_path', $category->tree_path . (int) $options['parent'] . '/%', 'LIKE']; |
|
308 | + $selectOptions['where'][] = ['tree_path', $category->tree_path.(int) $options['parent'].'/%', 'LIKE']; |
|
309 | 309 | } |
310 | 310 | |
311 | 311 | //search |
@@ -315,7 +315,7 @@ discard block |
||
315 | 315 | foreach (explode(' ', $searchStr) as $part) { |
316 | 316 | $part = trim($part); |
317 | 317 | if ($part && strlen($part) > 2) { |
318 | - $searchArr[] = ['search_index', '%' . $part . '%', 'LIKE']; |
|
318 | + $searchArr[] = ['search_index', '%'.$part.'%', 'LIKE']; |
|
319 | 319 | } |
320 | 320 | } |
321 | 321 | if (!empty($searchArr)) { |
@@ -334,19 +334,19 @@ discard block |
||
334 | 334 | } |
335 | 335 | $selectOptions['where'][] = [ |
336 | 336 | '( |
337 | - (SELECT COALESCE(sum(`' . \Ecommerce\Item\Offer\Warehouse::colPrefix() . 'count`),0) |
|
338 | - FROM ' . \App::$cur->db->table_prefix . \Ecommerce\Item\Offer\Warehouse::table() . ' iciw |
|
339 | - WHERE iciw.' . \Ecommerce\Item\Offer\Warehouse::colPrefix() . \Ecommerce\Item\Offer::index() . ' = ' . \Ecommerce\Item\Offer::index() . ' |
|
340 | - ' . ($warehouseIds ? ' AND iciw.' . \Ecommerce\Item\Offer\Warehouse::colPrefix() . \Ecommerce\Warehouse::index() . ' IN(' . implode(',', $warehouseIds) . ')' : '') . ' |
|
337 | + (SELECT COALESCE(sum(`' . \Ecommerce\Item\Offer\Warehouse::colPrefix().'count`),0) |
|
338 | + FROM ' . \App::$cur->db->table_prefix.\Ecommerce\Item\Offer\Warehouse::table().' iciw |
|
339 | + WHERE iciw.' . \Ecommerce\Item\Offer\Warehouse::colPrefix().\Ecommerce\Item\Offer::index().' = '.\Ecommerce\Item\Offer::index().' |
|
340 | + ' . ($warehouseIds ? ' AND iciw.'.\Ecommerce\Item\Offer\Warehouse::colPrefix().\Ecommerce\Warehouse::index().' IN('.implode(',', $warehouseIds).')' : '').' |
|
341 | 341 | ) |
342 | 342 | - |
343 | - (SELECT COALESCE(sum(' . \Ecommerce\Warehouse\Block::colPrefix() . 'count) ,0) |
|
344 | - FROM ' . \App::$cur->db->table_prefix . \Ecommerce\Warehouse\Block::table() . ' iewb |
|
345 | - inner JOIN ' . \App::$cur->db->table_prefix . \Ecommerce\Cart::table() . ' icc ON icc.' . \Ecommerce\Cart::index() . ' = iewb.' . \Ecommerce\Warehouse\Block::colPrefix() . \Ecommerce\Cart::index() . ' AND ( |
|
346 | - (`' . \Ecommerce\Cart::colPrefix() . 'warehouse_block` = 1 and `' . \Ecommerce\Cart::colPrefix() . 'cart_status_id` in(2,3,6)) || |
|
347 | - (`' . \Ecommerce\Cart::colPrefix() . \Ecommerce\Cart\Status::index() . '` in(0,1) and `' . \Ecommerce\Cart::colPrefix() . 'date_last_activ` >=subdate(now(),INTERVAL 30 MINUTE)) |
|
343 | + (SELECT COALESCE(sum(' . \Ecommerce\Warehouse\Block::colPrefix().'count) ,0) |
|
344 | + FROM ' . \App::$cur->db->table_prefix.\Ecommerce\Warehouse\Block::table().' iewb |
|
345 | + inner JOIN ' . \App::$cur->db->table_prefix.\Ecommerce\Cart::table().' icc ON icc.'.\Ecommerce\Cart::index().' = iewb.'.\Ecommerce\Warehouse\Block::colPrefix().\Ecommerce\Cart::index().' AND ( |
|
346 | + (`' . \Ecommerce\Cart::colPrefix().'warehouse_block` = 1 and `'.\Ecommerce\Cart::colPrefix().'cart_status_id` in(2,3,6)) || |
|
347 | + (`' . \Ecommerce\Cart::colPrefix().\Ecommerce\Cart\Status::index().'` in(0,1) and `'.\Ecommerce\Cart::colPrefix().'date_last_activ` >=subdate(now(),INTERVAL 30 MINUTE)) |
|
348 | 348 | ) |
349 | - WHERE iewb.' . \Ecommerce\Warehouse\Block::colPrefix() . \Ecommerce\Item\Offer::index() . ' = ' . \Ecommerce\Item\Offer::index() . ') |
|
349 | + WHERE iewb.' . \Ecommerce\Warehouse\Block::colPrefix().\Ecommerce\Item\Offer::index().' = '.\Ecommerce\Item\Offer::index().') |
|
350 | 350 | )', |
351 | 351 | 0, |
352 | 352 | '>' |
@@ -374,7 +374,7 @@ discard block |
||
374 | 374 | $items = Ecommerce\Item::getList($selectOptions); |
375 | 375 | $items = Ecommerce\Item\Param::getList([ |
376 | 376 | 'where' => ['item_id', array_keys($items), 'IN'], |
377 | - 'join' => [[Ecommerce\Item\Option::table(), Ecommerce\Item\Option::index() . ' = ' . \Ecommerce\Item\Param::colPrefix() . Ecommerce\Item\Option::index() . ' and ' . \Ecommerce\Item\Option::colPrefix() . 'searchable = 1', 'inner']], |
|
377 | + 'join' => [[Ecommerce\Item\Option::table(), Ecommerce\Item\Option::index().' = '.\Ecommerce\Item\Param::colPrefix().Ecommerce\Item\Option::index().' and '.\Ecommerce\Item\Option::colPrefix().'searchable = 1', 'inner']], |
|
378 | 378 | 'distinct' => \Ecommerce\Item\Option::index() |
379 | 379 | ]); |
380 | 380 | return $items; |
@@ -405,7 +405,7 @@ discard block |
||
405 | 405 | if (is_array($counts)) { |
406 | 406 | $sum = 0; |
407 | 407 | foreach ($counts as $count) { |
408 | - $sum +=$count['count']; |
|
408 | + $sum += $count['count']; |
|
409 | 409 | } |
410 | 410 | return $sum; |
411 | 411 | } |
@@ -439,7 +439,7 @@ discard block |
||
439 | 439 | |
440 | 440 | if (!empty($conf['files']['aditionTemplateFiels'])) { |
441 | 441 | foreach ($conf['files']['aditionTemplateFiels'] as $file) { |
442 | - $return[$file['file']] = '- ' . $file['name']; |
|
442 | + $return[$file['file']] = '- '.$file['name']; |
|
443 | 443 | } |
444 | 444 | } |
445 | 445 | return $return; |
@@ -513,7 +513,7 @@ discard block |
||
513 | 513 | $map[] = [ |
514 | 514 | 'name' => $item->name, |
515 | 515 | 'url' => [ |
516 | - 'loc' => (!empty($_SERVER['HTTPS']) ? 'https' : 'http') . '://' . INJI_DOMAIN_NAME . ($item->getHref()) |
|
516 | + 'loc' => (!empty($_SERVER['HTTPS']) ? 'https' : 'http').'://'.INJI_DOMAIN_NAME.($item->getHref()) |
|
517 | 517 | ], |
518 | 518 | ]; |
519 | 519 | } |
@@ -526,7 +526,7 @@ discard block |
||
526 | 526 | $map[] = [ |
527 | 527 | 'name' => $item->name, |
528 | 528 | 'url' => [ |
529 | - 'loc' => (!empty($_SERVER['HTTPS']) ? 'https' : 'http') . '://' . INJI_DOMAIN_NAME . ($item->getHref()) |
|
529 | + 'loc' => (!empty($_SERVER['HTTPS']) ? 'https' : 'http').'://'.INJI_DOMAIN_NAME.($item->getHref()) |
|
530 | 530 | ], |
531 | 531 | ]; |
532 | 532 | } |