· 7 years ago · Jan 22, 2019, 09:52 AM
1set @deliveryTypeHermesId = 51;
2set @deliveryTypeHermesGsId = 52;
3
4/* тарифы Ð´Ð»Ñ Ð·Ð¾Ð½ по веÑу */
5DROP TABLE IF EXISTS `delivery_config_hermes`;
6CREATE TABLE `delivery_config_hermes` (
7 `delivery_config_hermes_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
8 `delivery_points_config_zones_id` INT(10) NOT NULL COMMENT 'Id зоны доÑтавки Hermes',
9 `weight` INT(10) NOT NULL COMMENT 'ВеÑ',
10 `price` DECIMAL(15,2) NOT NULL DEFAULT 0 COMMENT 'СтоимоÑÑ‚ÑŒ доÑтавки',
11 PRIMARY KEY (`delivery_config_hermes_id`),
12 UNIQUE INDEX `delivery_points_config_zones_id_weight` (`delivery_points_config_zones_id`, `weight`)
13)
14 COLLATE='utf8_general_ci'
15 ENGINE=InnoDB
16;
17
18INSERT IGNORE INTO `delivery_config_hermes` (`delivery_points_config_zones_id`, `weight`, `price`) VALUES
19(1, 1, 129.14),
20(1, 2, 129.14),
21(1, 3, 129.14),
22(1, 4, 129.14),
23(1, 5, 129.14),
24(1, 6, 147.62),
25(1, 7, 147.62),
26(1, 8, 147.62),
27(1, 9, 147.62),
28(1, 10, 147.62),
29(1, 11, 152.38),
30(1, 12, 152.38),
31(1, 13, 152.38),
32(1, 14, 152.38),
33(1, 15, 152.38),
34(1, 16, 169.52),
35(1, 17, 169.52),
36(1, 18, 169.52),
37(1, 19, 169.52),
38(1, 20, 169.52),
39(1, 21, 429.52),
40(1, 22, 429.52),
41(1, 23, 429.52),
42(1, 24, 429.52),
43(1, 25, 429.52),
44(1, 26, 429.52),
45(1, 27, 429.52),
46(1, 28, 429.52),
47(1, 29, 429.52),
48(1, 30, 429.52),
49
50(2, 1, 129.14),
51(2, 2, 129.14),
52(2, 3, 129.14),
53(2, 4, 129.14),
54(2, 5, 129.14),
55(2, 6, 147.62),
56(2, 7, 147.62),
57(2, 8, 147.62),
58(2, 9, 147.62),
59(2, 10, 147.62),
60(2, 11, 152.38),
61(2, 12, 152.38),
62(2, 13, 152.38),
63(2, 14, 152.38),
64(2, 15, 152.38),
65(2, 16, 169.52),
66(2, 17, 169.52),
67(2, 18, 169.52),
68(2, 19, 169.52),
69(2, 20, 169.52),
70(2, 21, 429.52),
71(2, 22, 429.52),
72(2, 23, 429.52),
73(2, 24, 429.52),
74(2, 25, 429.52),
75(2, 26, 429.52),
76(2, 27, 429.52),
77(2, 28, 429.52),
78(2, 29, 429.52),
79(2, 30, 429.52),
80
81(3, 1, 165.46),
82(3, 2, 165.46),
83(3, 3, 165.46),
84(3, 4, 165.46),
85(3, 5, 165.46),
86(3, 6,167.62),
87(3, 7,167.62),
88(3, 8,167.62),
89(3, 9,167.62),
90(3, 10,167.62),
91(3, 11, 200),
92(3, 12, 200),
93(3, 13, 200),
94(3, 14, 200),
95(3, 15, 200),
96(3, 16, 232.38),
97(3, 17, 232.38),
98(3, 18, 232.38),
99(3, 19, 232.38),
100(3, 20, 232.38),
101(3, 21, 469.52),
102(3, 22, 469.52),
103(3, 23, 469.52),
104(3, 24, 469.52),
105(3, 25, 469.52),
106(3, 26, 469.52),
107(3, 27, 469.52),
108(3, 28, 469.52),
109(3, 29, 469.52),
110(3, 30, 469.52),
111
112(4, 1, 177.56),
113(4, 2, 177.56),
114(4, 3, 177.56),
115(4, 4, 177.56),
116(4, 5, 177.56),
117(4, 6, 200),
118(4, 7, 200),
119(4, 8, 200),
120(4, 9, 200),
121(4, 10, 200),
122(4, 11, 251.43),
123(4, 12, 251.43),
124(4, 13, 251.43),
125(4, 14, 251.43),
126(4, 15, 251.43),
127(4, 16, 271.43),
128(4, 17, 271.43),
129(4, 18, 271.43),
130(4, 19, 271.43),
131(4, 20, 271.43),
132(4, 21, 573.33),
133(4, 22, 573.33),
134(4, 23, 573.33),
135(4, 24, 573.33),
136(4, 25, 573.33),
137(4, 26, 573.33),
138(4, 27, 573.33),
139(4, 28, 573.33),
140(4, 29, 573.33),
141(4, 30, 573.33),
142
143(5, 1, 213.88),
144(5, 2, 213.88),
145(5, 3, 213.88),
146(5, 4, 213.88),
147(5, 5, 213.88),
148(5, 6, 229.52),
149(5, 7, 229.52),
150(5, 8, 229.52),
151(5, 9, 229.52),
152(5, 10, 229.52),
153(5, 11, 309.52),
154(5, 12, 309.52),
155(5, 13, 309.52),
156(5, 14, 309.52),
157(5, 15, 309.52),
158(5, 16, 323.81),
159(5, 17, 323.81),
160(5, 18, 323.81),
161(5, 19, 323.81),
162(5, 20, 323.81),
163(5, 21, 780.95),
164(5, 22, 780.95),
165(5, 23, 780.95),
166(5, 24, 780.95),
167(5, 25, 780.95),
168(5, 26, 780.95),
169(5, 27, 780.95),
170(5, 28, 780.95),
171(5, 29, 780.95),
172(5, 30, 780.95),
173
174(6, 1, 242.13),
175(6, 2, 242.13),
176(6, 3, 242.13),
177(6, 4, 242.13),
178(6, 5, 242.13),
179(6, 6, 314.29),
180(6, 7, 314.29),
181(6, 8, 314.29),
182(6, 9, 314.29),
183(6, 10, 314.29),
184(6, 11, 357.14),
185(6, 12, 357.14),
186(6, 13, 357.14),
187(6, 14, 357.14),
188(6, 15, 357.14),
189(6, 16, 454.29),
190(6, 17, 454.29),
191(6, 18, 454.29),
192(6, 19, 454.29),
193(6, 20, 454.29),
194(6, 21, 1427.62),
195(6, 22, 1427.62),
196(6, 23, 1427.62),
197(6, 24, 1427.62),
198(6, 25, 1427.62),
199(6, 26, 1427.62),
200(6, 27, 1427.62),
201(6, 28, 1427.62),
202(6, 29, 1427.62),
203(6, 30, 1427.62),
204
205(7, 1, 129.14),
206(7, 2, 129.14),
207(7, 3, 129.14),
208(7, 4, 129.14),
209(7, 5, 129.14),
210(7, 6, 147.62),
211(7, 7, 147.62),
212(7, 8, 147.62),
213(7, 9, 147.62),
214(7, 10, 147.62),
215(7, 11, 152.38),
216(7, 12, 152.38),
217(7, 13, 152.38),
218(7, 14, 152.38),
219(7, 15, 152.38),
220(7, 16, 169.52),
221(7, 17, 169.52),
222(7, 18, 169.52),
223(7, 19, 169.52),
224(7, 20, 169.52),
225(7, 21, 429.52),
226(7, 22, 429.52),
227(7, 23, 429.52),
228(7, 24, 429.52),
229(7, 25, 429.52),
230(7, 26, 429.52),
231(7, 27, 429.52),
232(7, 28, 429.52),
233(7, 29, 429.52),
234(7, 30, 429.52),
235
236(8, 1, 129.14),
237(8, 2, 129.14),
238(8, 3, 129.14),
239(8, 4, 129.14),
240(8, 5, 129.14),
241(8, 6, 147.62),
242(8, 7, 147.62),
243(8, 8, 147.62),
244(8, 9, 147.62),
245(8, 10, 147.62),
246(8, 11, 152.38),
247(8, 12, 152.38),
248(8, 13, 152.38),
249(8, 14, 152.38),
250(8, 15, 152.38),
251(8, 16, 169.52),
252(8, 17, 169.52),
253(8, 18, 169.52),
254(8, 19, 169.52),
255(8, 20, 169.52),
256(8, 21, 429.52),
257(8, 22, 429.52),
258(8, 23, 429.52),
259(8, 24, 429.52),
260(8, 25, 429.52),
261(8, 26, 429.52),
262(8, 27, 429.52),
263(8, 28, 429.52),
264(8, 29, 429.52),
265(8, 30, 429.52),
266
267(9, 1, 165.46),
268(9, 2, 165.46),
269(9, 3, 165.46),
270(9, 4, 165.46),
271(9, 5, 165.46),
272(9, 6,167.62),
273(9, 7,167.62),
274(9, 8,167.62),
275(9, 9,167.62),
276(9, 10,167.62),
277(9, 11, 200),
278(9, 12, 200),
279(9, 13, 200),
280(9, 14, 200),
281(9, 15, 200),
282(9, 16, 232.38),
283(9, 17, 232.38),
284(9, 18, 232.38),
285(9, 19, 232.38),
286(9, 20, 232.38),
287(9, 21, 469.52),
288(9, 22, 469.52),
289(9, 23, 469.52),
290(9, 24, 469.52),
291(9, 25, 469.52),
292(9, 26, 469.52),
293(9, 27, 469.52),
294(9, 28, 469.52),
295(9, 29, 469.52),
296(9, 30, 469.52),
297
298(10, 1, 177.56),
299(10, 2, 177.56),
300(10, 3, 177.56),
301(10, 4, 177.56),
302(10, 5, 177.56),
303(10, 6, 200),
304(10, 7, 200),
305(10, 8, 200),
306(10, 9, 200),
307(10, 10, 200),
308(10, 11, 251.43),
309(10, 12, 251.43),
310(10, 13, 251.43),
311(10, 14, 251.43),
312(10, 15, 251.43),
313(10, 16, 271.43),
314(10, 17, 271.43),
315(10, 18, 271.43),
316(10, 19, 271.43),
317(10, 20, 271.43),
318(10, 21, 573.33),
319(10, 22, 573.33),
320(10, 23, 573.33),
321(10, 24, 573.33),
322(10, 25, 573.33),
323(10, 26, 573.33),
324(10, 27, 573.33),
325(10, 28, 573.33),
326(10, 29, 573.33),
327(10, 30, 573.33),
328
329(11, 1, 213.88),
330(11, 2, 213.88),
331(11, 3, 213.88),
332(11, 4, 213.88),
333(11, 5, 213.88),
334(11, 6, 229.52),
335(11, 7, 229.52),
336(11, 8, 229.52),
337(11, 9, 229.52),
338(11, 10, 229.52),
339(11, 11, 309.52),
340(11, 12, 309.52),
341(11, 13, 309.52),
342(11, 14, 309.52),
343(11, 15, 309.52),
344(11, 16, 323.81),
345(11, 17, 323.81),
346(11, 18, 323.81),
347(11, 19, 323.81),
348(11, 20, 323.81),
349(11, 21, 780.95),
350(11, 22, 780.95),
351(11, 23, 780.95),
352(11, 24, 780.95),
353(11, 25, 780.95),
354(11, 26, 780.95),
355(11, 27, 780.95),
356(11, 28, 780.95),
357(11, 29, 780.95),
358(11, 30, 780.95),
359
360(12, 1, 242.13),
361(12, 2, 242.13),
362(12, 3, 242.13),
363(12, 4, 242.13),
364(12, 5, 242.13),
365(12, 6, 314.29),
366(12, 7, 314.29),
367(12, 8, 314.29),
368(12, 9, 314.29),
369(12, 10, 314.29),
370(12, 11, 357.14),
371(12, 12, 357.14),
372(12, 13, 357.14),
373(12, 14, 357.14),
374(12, 15, 357.14),
375(12, 16, 454.29),
376(12, 17, 454.29),
377(12, 18, 454.29),
378(12, 19, 454.29),
379(12, 20, 454.29),
380(12, 21, 1427.62),
381(12, 22, 1427.62),
382(12, 23, 1427.62),
383(12, 24, 1427.62),
384(12, 25, 1427.62),
385(12, 26, 1427.62),
386(12, 27, 1427.62),
387(12, 28, 1427.62),
388(12, 29, 1427.62),
389(12, 30, 1427.62)
390;
391
392/* Ð½Ð¾Ð²Ð°Ñ Ð¿Ñ€Ð°Ð²Ð¸Ð»ÑŒÐ½Ð°Ñ Ð³ÐµÐ¾Ð³Ñ€Ð°Ñ„Ð¸Ñ */
393INSERT IGNORE INTO delivery_points_config (`delivery_types_id`, `fias_id`, `tc_city_code`, `price`, `zone`, `is_active`) VALUES
394(52, "378499", "1900000100000", 1000000, 11, 1),
395(52, "745943", "2300300100000", 1000000, 10, 1),
396(52, "672943", "2300000200000", 1000000, 10, 1),
397(52, "926302", "2900000100000", 1000000, 10, 1),
398(52, "900469", "3000000100000", 1000000, 10, 1),
399(52, "811925", "6400000400000", 1000000, 10, 1),
400(52, "202406", "5200400100000", 1000000, 9, 1),
401(52, "1030433", "5000003600000", 1000000, 8, 1),
402(52, "912369", "2200000100000", 1000000, 11, 1),
403(52, "309046", "3100000100000", 1000000, 9, 1),
404(52, "945867", "5400000200000", 1000000, 11, 1),
405(52, "172289", "2200000400000", 1000000, 11, 1),
406(52, "68882", "5200000500000", 1000000, 9, 1),
407(52, "539541", "3200000100000", 1000000, 9, 1),
408(52, "712657", "5300000100000", 1000000, 9, 1),
409(52, "1054838", "5001400100000", 1000000, 8, 1),
410(52, "888680", "2500000100000", 1000000, 12, 1),
411(52, "579588", "1500000100000", 1000000, 11, 1),
412(52, "911103", "3300000100000", 1000000, 9, 1),
413(52, "530876", "3400000100000", 1000000, 10, 1),
414(52, "42702", "3500000100000", 1000000, 9, 1),
415(52, "694643", "5000300100000", 1000000, 8, 1),
416(52, "902295", "6400000600000", 1000000, 10, 1),
417(52, "468731", "3600000100000", 1000000, 9, 1),
418(52, "578053", "5000400100000", 1000000, 8, 1),
419(52, "666950", "4700500100000", 1000000, 9, 1),
420(52, "10654", "4700600100000", 1000000, 10, 1),
421(52, "307147", "4700700100000", 1000000, 9, 1),
422(52, "404188", "2300000300000", 1000000, 10, 1),
423(52, "17770", "5200000200000", 1000000, 9, 1),
424(52, "410381", "5000002300000", 1000000, 9, 1),
425(52, "625195", "7300000200000", 1000000, 10, 1),
426(52, "371781", "5000500100000", 1000000, 8, 1),
427(52, "773415", "5000002900000", 1000000, 8, 1),
428(52, "586213", "5000000300000", 1000000, 8, 1),
429(52,"167892", "3102200002400", 1000000, 9, 1),
430(52, "434756", "5000700100000", 1000000, 8, 1),
431(52, "517995", "2301100100000", 1000000, 10, 1),
432(52, "318338", "6600000100000", 1000000, 10, 1),
433(52, "543089", "5000000400000", 1000000, 8, 1),
434(52, "215458", "5000000500000", 1000000, 8, 1),
435(52, "424029", "7700000200000", 1000000, 8, 1),
436(52, "837671", "3700000100000", 1000000, 9, 1),
437(52, "336991", "1800000100000", 1000000, 10, 1),
438(52, "370074", "3800000300000", 1000000, 11, 1),
439(52, "135545", "1200000100000", 1000000, 10, 1),
440(52, "605127", "1600000100000", 1000000, 10, 1),
441(52, "63957", "4000000100000", 1000000, 9, 1),
442(52, "865865", "6600002200000", 1000000, 10, 1),
443(52, "81949", "3400000300000", 1000000, 10, 1),
444(52, "751553", "4200000900000", 1000000, 11, 1),
445(52, "294693", "4300000100000", 1000000, 10, 1),
446(52,236419, "4301300100051", 1000000, 10, 1),
447(52, "838047", "2600000400000", 1000000, 10, 1),
448(52,315171, "5001100100000", 1000000, 8, 1),
449(52, "756939", "3300000400000", 1000000, 9, 1),
450(52, "52064", "5000002700000", 1000000, 8, 1),
451(52, "657030", "3300900100000", 1000000, 9, 1),
452(52, "294167", "2700000500000", 1000000, 12, 1),
453(52, "163853", "5000000900000", 1000000, 8, 1),
454(52, "770152", "4400000300000", 1000000, 9, 1),
455(52, "30546", "5000003200000", 1000000, 8, 1),
456(52, "54530", "5001300100000", 1000000, 8, 1),
457(52, "650931", "2300000100000", 1000000, 10, 1),
458(52, "36918", "7800000400000", 1000000, 9, 1),
459(52, "591716", "2400000100000", 1000000, 11, 1),
460(52, "571443", "5202700100000", 1000000, 9, 1),
461(52, "214532", "4600000100000", 1000000, 9, 1),
462(52, "112358", "4800000100000", 1000000, 9, 1),
463(52, "745758", "5000001200000", 1000000, 8, 1),
464(52, "866593", "5001700100000", 1000000, 8, 1),
465(52, "277682", "7400000900000", 1000000, 10, 1),
466(52, "271793", "0100000100000", 1000000, 11, 1),
467(52, "991724", "4001500100000", 1000000, 9, 1),
468(52, "229161", "0500000100000", 1000000, 11, 1),
469(52, "209192", "2600001000000", 1000000, 10, 1),
470(52, "225912", "6800000600000", 1000000, 9, 1),
471(52, "171328", "5004000006000", 1000000, 8, 1),
472(52, "452231", "7700000000000", 1000000, 8, 1),
473(52, "20842", "7701100100000", 1000000, 8, 1),
474(52, "374517", "5100000100000", 1000000, 10, 1),
475(52, "293176", "3300000500000", 1000000, 9, 1),
476(52, "815727", "5001900100000", 1000000, 8, 1),
477(52, "2187", "1600000200000", 1000000, 10, 1),
478(52, "621099", "0700000100000", 1000000, 11, 1),
479(52, "889894", "2500000400000", 1000000, 12, 1),
480(52, "414828", "8600001400000", 1000000, 10, 1),
481(52, "355960", "8600001100000", 1000000, 10, 1),
482(52, "703100", "1603100100000", 1000000, 10, 1),
483(52, "734400", "5200000100000", 1000000, 9, 1),
484(52, "44031", "4200001200000", 1000000, 11, 1),
485(52, "147685", "7101700100000", 1000000, 9, 1),
486(52, "825368", "2300000600000", 1000000, 10, 1),
487(52, "978363", "5400000100000", 1000000, 11, 1),
488(52, "676900", "2100002400000", 1000000, 10, 1),
489(52,679313, "6100000900000", 1000000, 10, 1),
490(52, "784235", "5002100100000", 1000000, 8, 1),
491(52, "583590", "4000000200000", 1000000, 9, 1),
492(52, "657840", "5002200100000", 1000000, 8, 1),
493(52, "531666", "5500000100000", 1000000, 11, 1),
494(52, "890385", "5700000100000", 1000000, 9, 1),
495(52, "39489", "5600000100000", 1000000, 10, 1),
496(52, "427741", "5000002600000", 1000000, 8, 1),
497(52, "425427", "5600000400000", 1000000, 10, 1),
498(52, "264450", "5800000100000", 1000000, 10, 1),
499(52, "964424", "6600001600000", 1000000, 10, 1),
500(52, "860613", "7600000200000", 1000000, 9, 1),
501(52, "664002", "5900000100000", 1000000, 10, 1),
502(52, "436308", "7800000800000", 1000000, 9, 1),
503(52, "362254", "1000000100000", 1000000, 10, 1),
504(52, "235762", "5000002400000", 1000000, 8, 1),
505(52, "690606", "6000000100000", 1000000, 10, 1),
506(52, "619837", "7800000900000", 1000000, 9, 1),
507(52, "479388", "5002700100000", 1000000, 8, 1),
508(52, "84034", "2600000700000", 1000000, 10, 1),
509(52, "313226", "5002800100000", 1000000, 8, 1),
510(52, "250611", "5000001600000", 1000000, 8, 1),
511(52, "261052", "7601400100000", 1000000, 9, 1),
512(52, "869170", "6100000100000", 1000000, 10, 1),
513(52, "586571", "7601500100000", 1000000, 9, 1),
514(52, "785125", "6200000100000", 1000000, 9, 1),
515(52, "249370", "0200000500000", 1000000, 10, 1),
516(52, "308251", "6300000100000", 1000000, 10, 1),
517(52, "891320", "7800000000000", 1000000, 9, 1),
518(52, "484515", "1300000100000", 1000000, 10, 1),
519(52, "741005", "6400000100000", 1000000, 10, 1),
520(52, "193435", "5200000300000", 1000000, 9, 1),
521(52, "875318", "2900000400000", 1000000, 10, 1),
522(52, "1072635", "5003000500000", 1000000, 8, 1),
523(52, "797271", "5000002800000", 1000000, 8, 1),
524(52, "1067750", "9100000700000", 1000000, 10, 1),
525(52, "388827", "6700000300000", 1000000, 9, 1),
526(52, "147634", "5003300100000", 1000000, 8, 1),
527(52, "1072637", "4700000400000", 1000000, 9, 1),
528(52, "279754", "2300000700000", 1000000, 10, 1),
529(52, "980448", "2600000100000", 1000000, 10, 1),
530(52, "185119", "3100000200000", 1000000, 9, 1),
531(52, "205367", "0200001400000", 1000000, 10, 1),
532(52, "336877", "5003400100000", 1000000, 8, 1),
533(52, "362948", "8600001000000", 1000000, 10, 1),
534(52, "748279", "6300000800000", 1000000, 10, 1),
535(52, "386347", "1100000100000", 1000000, 10, 1),
536(52, "985992", "6100001100000", 1000000, 10, 1),
537(52, "110581", "6800000400000", 1000000, 9, 1),
538(52, "726902", "6900000100000", 1000000, 9, 1),
539(52, "220599", "6300000700000", 1000000, 10, 1),
540(52, "314662", "7000000100000", 1000000, 11, 1),
541(52, "698830", "7100000100000", 1000000, 9, 1),
542(52, "649727", "7200000100000", 1000000, 10, 1),
543(52, "674862", "0300000100000", 1000000, 11, 1),
544(52,465798, "7102200100000", 1000000, 9, 1),
545(52, "684600", "7300000100000", 1000000, 10, 1),
546(52, "510493", "2500001100000", 1000000, 12, 1),
547(52, "1009595", "0200000100000", 1000000, 10, 1),
548(52, "175074", "1100000800000", 1000000, 10, 1),
549(52, "535544", "5000001900000", 1000000, 8, 1),
550(52, "7687", "2700000100000", 1000000, 12, 1),
551(52,69794, "8600000100000", 1000000, 10, 1),
552(52, "444369", "5000003000000", 1000000, 8, 1),
553(52, "244445", "6300000600000", 1000000, 10, 1),
554(52, "554977", "2100000100000", 1000000, 10, 1),
555(52, "926982", "7400000100000", 1000000, 10, 1),
556(52, "524228", "3500000200000", 1000000, 9, 1),
557(52, "382872", "5003700100000", 1000000, 8, 1),
558(52, "322940", "7500000100000", 1000000, 11, 1),
559(52, "724297", "6100001200000", 1000000, 10, 1),
560(52, "3518", "5004000100000", 1000000, 8, 1),
561(52, "552926", "5000002100000", 1000000, 8, 1),
562(52, "541829", "6400001300000", 1000000, 10, 1),
563(52, "655320", "7600000100000", 1000000, 9, 1),
564
565(52, "1008197", "0200000300000", 295+25, 10, 1),
566(52, "221432", "0400000100000", 1000000, 11, 0),
567(52, "1031914", "0700500100000", 495+25, 11, 1),
568(52, "900507", "1602100100000", 295+25, 10, 1),
569(52, "264196", "2200000900000", 1000000, 11, 0),
570(52, "509302", "2500000300000", 545+25, 12, 1),
571(52, "824857", "2800000100000", 1000000, 12, 0),
572(52, "956329", "3701700100000", 345+25, 9, 1),
573(52, "266580", "4100000100000", 1000000, 12, 0),
574(52, "776983", "4700200100000", 295+25, 9, 1),
575(52, "899598", "4700500008200", 295+25, 9, 1),
576(52, "20415", "4701000300000", 295+25, 9, 1),
577(52, "33593", "4701700100000", 295+25, 9, 1),
578(52, "109472", "5000000101100", 355+25, 8, 1),
579(52, "723861", "5200000400000", 245+25, 9, 1),
580(52, "860684", "5200000700000", 245+25, 9, 1),
581(52, "179636", "6500000100000", 1000000, 12, 0),
582(52, "416292", "6600000300000", 295+25, 10, 1),
583(52, "942515", "6800000200000", 345+25, 9, 1),
584(52, "307849", "6900000600000", 295+25, 9, 1),
585(52, "672193", "7600500100000", 295+25, 9, 1)
586;
587
588/* там где еÑÑ‚ÑŒ Ñовпадение по пикпойнту - проÑтавлÑем цены Ð´Ð»Ñ Ð¿Ð¾Ð»ÑŒÐ·Ð¾Ð²Ð°Ñ‚ÐµÐ»Ñ ÐºÐ°Ðº у пикпойнта + 25 Ñ€. */
589UPDATE delivery_points_config dpc JOIN fias f ON dpc.fias_id = f.id
590 LEFT JOIN delivery_points_config dpc_pickpoint ON dpc.fias_id = dpc_pickpoint.fias_id AND dpc_pickpoint.delivery_types_id = 21
591SET dpc.price = dpc_pickpoint.price + 25
592WHERE dpc.delivery_types_id = 52
593 AND dpc_pickpoint.price IS NOT NULL;
594
595
596
597/* пороги беÑплатной доÑтавки */
598INSERT IGNORE INTO `delivery_config_free` (`fias_id`, `delivery_type`, `sum`, `is_active`) VALUES
599(266580, @deliveryTypeHermesGsId, 5000, 1),
600(315462, @deliveryTypeHermesGsId, 5000, 1),
601(983798, @deliveryTypeHermesGsId, 7000, 1),
602(984704, @deliveryTypeHermesGsId, 5000, 1)
603;
604
605INSERT INTO `package_costs` (`shipping_class`, `single_order`, `cost`, `date_start`, `date_end`) VALUES
606('deliverypoint_hermes', 1, 9, '2019-01-01 00:00:00', '2033-01-01 00:00:00'),
607('deliverypoint_hermes', 0, 9, '2019-01-01 00:00:00', '2033-01-01 00:00:00'),
608('deliverypoint_hermesgs', 1, 9, '2019-01-01 00:00:00', '2033-01-01 00:00:00'),
609('deliverypoint_hermesgs', 0, 9, '2019-01-01 00:00:00', '2033-01-01 00:00:00')
610;
611
612/* права на Ñтраницу обмена */
613INSERT IGNORE INTO acl_rules (`module`, `controller`, `action`, `acl_rules_fake`) VALUES ('call', 'logistic', 'integration-with-hermes', 'N');
614set @newRuleId = last_insert_id();
615INSERT IGNORE INTO acl_settings (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES (57, @newRuleId, 'ALLOW', '');
616INSERT INTO `admin_menu` (`pid`, `name`, `url`) VALUES (351, 'Обмен Ñ Hermes', '/call/logistic/integration-with-hermes');
617
618INSERT IGNORE INTO acl_rules (`module`, `controller`, `action`, `acl_rules_fake`) VALUES ('call', 'logistic', 'unload-hermes-integration-data', 'N');
619set @newRuleId = last_insert_id();
620INSERT IGNORE INTO acl_settings (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES (57, @newRuleId, 'ALLOW', '');
621
622INSERT IGNORE INTO acl_rules (`module`, `controller`, `action`, `acl_rules_fake`) VALUES ('call', 'logistic', 'integration-with-hermes-archive', 'N');
623set @newRuleId = last_insert_id();
624INSERT IGNORE INTO acl_settings (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES (57, @newRuleId, 'ALLOW', '');
625
626ALTER TABLE log_api_requests_to_objects ADD COLUMN `status` VARCHAR(25) NOT NULL DEFAULT '' COMMENT 'КаÑтомный ÑÑ‚Ð°Ñ‚ÑƒÑ Ð´Ð»Ñ ÐºÐ°Ð¶Ð´Ð¾Ð³Ð¾ объекта в маÑÑовом запроÑе';