Project

General

Profile

Bug #3365 » u.html

Michael Shestero, 10/06/2014 07:46 PM

 
1
<body>
2
Отчёт построен на основе <b>17196</b> предварительно отобранных записей.
3
Пользователь:	<b>test</b>.
4
<h3>Отчёт импорт по получателям с группировкой по регионам.</h3>
5
На сервере на формирование отчёта ушло <b>120.41</b> секунд.
6
Получено <b>58</b> строк.
7
Вместе с выводом потребовалось <b>120.42</b> секунд.
8
<table border="1" cellspacing="0" cellpadding="4">
9
<th align="center" valign="top">count_ND0 <br>Кол-во записей</th>
10
<th align="center" valign="top">V <br>Код региона</th>
11
<th align="center" valign="top">NAME <br>Название региона</th>
12
<th align="center" valign="top">sum_G38 <br>Вес нетто (G38)</th>
13
<th align="center" valign="top">sum_G42 <br>Фактурная стоимость (G42)</th>
14
<th align="center" valign="top">sum_G45 <br>Там.стоимость,руб. (G45)</th>
15
<th align="center" valign="top">sum_G46 <br>Стат.стоимость,USD (G46)</th>
16
<tr>
17
	<td valign="top">6394</td>
18
	<td valign="top">77</td>
19
	<td valign="top">Москва</td>
20
	<td valign="top">54387335,595</td>
21
	<td valign="top">562153927,90</td>
22
	<td valign="top">1982702214,47</td>
23
	<td valign="top">63868763,84</td>
24
</tr>
25
<tr>
26
	<td valign="top">2626</td>
27
	<td valign="top">78</td>
28
	<td valign="top">Санкт-Петербург</td>
29
	<td valign="top">15424112,0772</td>
30
	<td valign="top">131800886,69</td>
31
	<td valign="top">942753927,41</td>
32
	<td valign="top">30368998,43</td>
33
</tr>
34
<tr>
35
	<td valign="top">81</td>
36
	<td valign="top">57</td>
37
	<td valign="top">Орловская область</td>
38
	<td valign="top">878459,317</td>
39
	<td valign="top">854712,25</td>
40
	<td valign="top">893832840,99</td>
41
	<td valign="top">28793099,96</td>
42
</tr>
43
<tr>
44
	<td valign="top">2004</td>
45
	<td valign="top">39</td>
46
	<td valign="top">Калининградская область</td>
47
	<td valign="top">10049337,177</td>
48
	<td valign="top">18651125,22</td>
49
	<td valign="top">482255918,75</td>
50
	<td valign="top">15534943,82</td>
51
</tr>
52
<tr>
53
	<td valign="top">2016</td>
54
	<td valign="top">50</td>
55
	<td valign="top">Московская область</td>
56
	<td valign="top">25492346,5107</td>
57
	<td valign="top">105851548,13</td>
58
	<td valign="top">395403456,56</td>
59
	<td valign="top">12654857,03</td>
60
</tr>
61
<tr>
62
	<td valign="top">25</td>
63
	<td valign="top">31</td>
64
	<td valign="top">Белгородская область</td>
65
	<td valign="top">6941076,28</td>
66
	<td valign="top">263769856,19</td>
67
	<td valign="top">284731946,86</td>
68
	<td valign="top">9168697,56</td>
69
</tr>
70
<tr>
71
	<td valign="top">267</td>
72
	<td valign="top">23</td>
73
	<td valign="top">Краснодарский край</td>
74
	<td valign="top">9771147,505</td>
75
	<td valign="top">7720415,17</td>
76
	<td valign="top">215994766,64</td>
77
	<td valign="top">6984206,53</td>
78
</tr>
79
<tr>
80
	<td valign="top">299</td>
81
	<td valign="top"></td>
82
	<td valign="top"></td>
83
	<td valign="top">1455761,439</td>
84
	<td valign="top">5961463,83</td>
85
	<td valign="top">210101149,92</td>
86
	<td valign="top">6766083,43</td>
87
</tr>
88
<tr>
89
	<td valign="top">50</td>
90
	<td valign="top">32</td>
91
	<td valign="top">Брянская область</td>
92
	<td valign="top">5482994,29</td>
93
	<td valign="top">5342072,13</td>
94
	<td valign="top">172037758,14</td>
95
	<td valign="top">5541864,36</td>
96
</tr>
97
<tr>
98
	<td valign="top">410</td>
99
	<td valign="top">47</td>
100
	<td valign="top">Ленинградская область</td>
101
	<td valign="top">1121822,46</td>
102
	<td valign="top">2793252,78</td>
103
	<td valign="top">88570359,40</td>
104
	<td valign="top">2853123,21</td>
105
</tr>
106
<tr>
107
	<td valign="top">475</td>
108
	<td valign="top">25</td>
109
	<td valign="top">Приморский край</td>
110
	<td valign="top">1071844,17</td>
111
	<td valign="top">3426830,26</td>
112
	<td valign="top">78777240,36</td>
113
	<td valign="top">2391035,17</td>
114
</tr>
115
<tr>
116
	<td valign="top">225</td>
117
	<td valign="top">75</td>
118
	<td valign="top">Забайкальский край</td>
119
	<td valign="top">1170893</td>
120
	<td valign="top">1317123,62</td>
121
	<td valign="top">58778159,50</td>
122
	<td valign="top">1893424,99</td>
123
</tr>
124
<tr>
125
	<td valign="top">141</td>
126
	<td valign="top">63</td>
127
	<td valign="top">Самарская область</td>
128
	<td valign="top">407105,679</td>
129
	<td valign="top">32090529,04</td>
130
	<td valign="top">56513552,70</td>
131
	<td valign="top">1780872,27</td>
132
</tr>
133
<tr>
134
	<td valign="top">13</td>
135
	<td valign="top">41</td>
136
	<td valign="top">Камчатский край</td>
137
	<td valign="top">935651,8</td>
138
	<td valign="top">0,00</td>
139
	<td valign="top">52330026,28</td>
140
	<td valign="top">1685710,81</td>
141
</tr>
142
<tr>
143
	<td valign="top">34</td>
144
	<td valign="top">74</td>
145
	<td valign="top">Челябинская область</td>
146
	<td valign="top">398517,1</td>
147
	<td valign="top">1389100,25</td>
148
	<td valign="top">50320160,92</td>
149
	<td valign="top">1632170,28</td>
150
</tr>
151
<tr>
152
	<td valign="top">27</td>
153
	<td valign="top">40</td>
154
	<td valign="top">Калужская область</td>
155
	<td valign="top">2697212,065</td>
156
	<td valign="top">14411671,27</td>
157
	<td valign="top">38947048,17</td>
158
	<td valign="top">1254603,99</td>
159
</tr>
160
<tr>
161
	<td valign="top">13</td>
162
	<td valign="top">55</td>
163
	<td valign="top">Омская область</td>
164
	<td valign="top">346022,516</td>
165
	<td valign="top">937010,79</td>
166
	<td valign="top">35270407,38</td>
167
	<td valign="top">1133287,91</td>
168
</tr>
169
<tr>
170
	<td valign="top">44</td>
171
	<td valign="top">61</td>
172
	<td valign="top">Ростовская область</td>
173
	<td valign="top">114209,61</td>
174
	<td valign="top">362328,81</td>
175
	<td valign="top">30409930,24</td>
176
	<td valign="top">979597,21</td>
177
</tr>
178
<tr>
179
	<td valign="top">10</td>
180
	<td valign="top">14</td>
181
	<td valign="top">Республика Саха (Якутия)</td>
182
	<td valign="top">164862,49</td>
183
	<td valign="top">582364,07</td>
184
	<td valign="top">23532477,40</td>
185
	<td valign="top">758053,35</td>
186
</tr>
187
<tr>
188
	<td valign="top">99</td>
189
	<td valign="top">54</td>
190
	<td valign="top">Новосибирская область</td>
191
	<td valign="top">168519,036</td>
192
	<td valign="top">650118,13</td>
193
	<td valign="top">22391421,93</td>
194
	<td valign="top">721296,53</td>
195
</tr>
196
<tr>
197
	<td valign="top">52</td>
198
	<td valign="top">99</td>
199
	<td valign="top">Территории, находящиеся за пределами РФ и обслуживаемые Управлением режимных объектов МВД России, Байконур</td>
200
	<td valign="top">471962,509</td>
201
	<td valign="top">282284,63</td>
202
	<td valign="top">21542416,92</td>
203
	<td valign="top">696353,21</td>
204
</tr>
205
<tr>
206
	<td valign="top">31</td>
207
	<td valign="top">16</td>
208
	<td valign="top">Республика Татарстан</td>
209
	<td valign="top">60857,002</td>
210
	<td valign="top">562379,22</td>
211
	<td valign="top">21389164,72</td>
212
	<td valign="top">689010,68</td>
213
</tr>
214
<tr>
215
	<td valign="top">255</td>
216
	<td valign="top">66</td>
217
	<td valign="top">Свердловская область</td>
218
	<td valign="top">807284,63</td>
219
	<td valign="top">552328,26</td>
220
	<td valign="top">20436445,15</td>
221
	<td valign="top">658320,62</td>
222
</tr>
223
<tr>
224
	<td valign="top">3</td>
225
	<td valign="top">34</td>
226
	<td valign="top">Волгоградская область</td>
227
	<td valign="top">1100390</td>
228
	<td valign="top">19518454,00</td>
229
	<td valign="top">19807827,76</td>
230
	<td valign="top">638070,94</td>
231
</tr>
232
<tr>
233
	<td valign="top">36</td>
234
	<td valign="top">67</td>
235
	<td valign="top">Смоленская область</td>
236
	<td valign="top">775125,16</td>
237
	<td valign="top">2835965,98</td>
238
	<td valign="top">19058252,73</td>
239
	<td valign="top">613924,81</td>
240
</tr>
241
<tr>
242
	<td valign="top">231</td>
243
	<td valign="top">56</td>
244
	<td valign="top">Оренбургская область</td>
245
	<td valign="top">95243,6</td>
246
	<td valign="top">545692,48</td>
247
	<td valign="top">18056165,17</td>
248
	<td valign="top">581644,50</td>
249
</tr>
250
<tr>
251
	<td valign="top">20</td>
252
	<td valign="top">71</td>
253
	<td valign="top">Тульская область</td>
254
	<td valign="top">405818,651</td>
255
	<td valign="top">484677,85</td>
256
	<td valign="top">16882140,67</td>
257
	<td valign="top">543825,58</td>
258
</tr>
259
<tr>
260
	<td valign="top">76</td>
261
	<td valign="top">43</td>
262
	<td valign="top">Кировская область</td>
263
	<td valign="top">344897,3</td>
264
	<td valign="top">343242,49</td>
265
	<td valign="top">16112264,37</td>
266
	<td valign="top">519025,50</td>
267
</tr>
268
<tr>
269
	<td valign="top">25</td>
270
	<td valign="top">28</td>
271
	<td valign="top">Амурская область</td>
272
	<td valign="top">51795,89</td>
273
	<td valign="top">111887,90</td>
274
	<td valign="top">9348498,03</td>
275
	<td valign="top">507629,56</td>
276
</tr>
277
<tr>
278
	<td valign="top">74</td>
279
	<td valign="top">53</td>
280
	<td valign="top">Новгородская область</td>
281
	<td valign="top">179339,8</td>
282
	<td valign="top">401134,00</td>
283
	<td valign="top">14704621,28</td>
284
	<td valign="top">481271,44</td>
285
</tr>
286
<tr>
287
	<td valign="top">8</td>
288
	<td valign="top">36</td>
289
	<td valign="top">Воронежская область</td>
290
	<td valign="top">149475,32</td>
291
	<td valign="top">258575,25</td>
292
	<td valign="top">13115049,58</td>
293
	<td valign="top">422476,02</td>
294
</tr>
295
<tr>
296
	<td valign="top">5</td>
297
	<td valign="top">48</td>
298
	<td valign="top">Липецкая область</td>
299
	<td valign="top">147605</td>
300
	<td valign="top">393156,04</td>
301
	<td valign="top">11615018,70</td>
302
	<td valign="top">374155,42</td>
303
</tr>
304
<tr>
305
	<td valign="top">8</td>
306
	<td valign="top">26</td>
307
	<td valign="top">Ставропольский край</td>
308
	<td valign="top">7029500</td>
309
	<td valign="top">281097,12</td>
310
	<td valign="top">9218356,56</td>
311
	<td valign="top">296951,56</td>
312
</tr>
313
<tr>
314
	<td valign="top">35</td>
315
	<td valign="top">72</td>
316
	<td valign="top">Тюменская область</td>
317
	<td valign="top">21041,68</td>
318
	<td valign="top">132384,83</td>
319
	<td valign="top">8347505,72</td>
320
	<td valign="top">268898,81</td>
321
</tr>
322
<tr>
323
	<td valign="top">7</td>
324
	<td valign="top">33</td>
325
	<td valign="top">Владимирская область</td>
326
	<td valign="top">794096,5</td>
327
	<td valign="top">358547,70</td>
328
	<td valign="top">8288117,68</td>
329
	<td valign="top">266985,72</td>
330
</tr>
331
<tr>
332
	<td valign="top">29</td>
333
	<td valign="top">24</td>
334
	<td valign="top">Красноярский край</td>
335
	<td valign="top">160457</td>
336
	<td valign="top">250705,54</td>
337
	<td valign="top">7960305,45</td>
338
	<td valign="top">256425,89</td>
339
</tr>
340
<tr>
341
	<td valign="top">10</td>
342
	<td valign="top">52</td>
343
	<td valign="top">Нижегородская область</td>
344
	<td valign="top">163937</td>
345
	<td valign="top">201087,41</td>
346
	<td valign="top">7460581,31</td>
347
	<td valign="top">240328,23</td>
348
</tr>
349
<tr>
350
	<td valign="top">3</td>
351
	<td valign="top">05</td>
352
	<td valign="top">Республика Дагестан</td>
353
	<td valign="top">187091</td>
354
	<td valign="top">5685655,00</td>
355
	<td valign="top">5685655,00</td>
356
	<td valign="top">183152,41</td>
357
</tr>
358
<tr>
359
	<td valign="top">7</td>
360
	<td valign="top">11</td>
361
	<td valign="top">Республика Коми</td>
362
	<td valign="top">318112</td>
363
	<td valign="top">162988,04</td>
364
	<td valign="top">5640301,80</td>
365
	<td valign="top">181691,44</td>
366
</tr>
367
<tr>
368
	<td valign="top">6</td>
369
	<td valign="top">64</td>
370
	<td valign="top">Саратовская область</td>
371
	<td valign="top">156634,5</td>
372
	<td valign="top">101678,16</td>
373
	<td valign="top">4380650,80</td>
374
	<td valign="top">141114,21</td>
375
</tr>
376
<tr>
377
	<td valign="top">5</td>
378
	<td valign="top">65</td>
379
	<td valign="top">Сахалинская область</td>
380
	<td valign="top">218412</td>
381
	<td valign="top">0,00</td>
382
	<td valign="top">3108152,00</td>
383
	<td valign="top">100123,12</td>
384
</tr>
385
<tr>
386
	<td valign="top">2</td>
387
	<td valign="top">59</td>
388
	<td valign="top">Пермский край</td>
389
	<td valign="top">82780</td>
390
	<td valign="top">98908,80</td>
391
	<td valign="top">3099132,51</td>
392
	<td valign="top">99832,57</td>
393
</tr>
394
<tr>
395
	<td valign="top">3</td>
396
	<td valign="top">21</td>
397
	<td valign="top">Чувашская республика</td>
398
	<td valign="top">11579,97</td>
399
	<td valign="top">67854,46</td>
400
	<td valign="top">2911875,28</td>
401
	<td valign="top">93800,44</td>
402
</tr>
403
<tr>
404
	<td valign="top">3</td>
405
	<td valign="top">38</td>
406
	<td valign="top">Иркутская область</td>
407
	<td valign="top">60533</td>
408
	<td valign="top">60200,26</td>
409
	<td valign="top">2391403,81</td>
410
	<td valign="top">77034,46</td>
411
</tr>
412
<tr>
413
	<td valign="top">6</td>
414
	<td valign="top">51</td>
415
	<td valign="top">Мурманская область</td>
416
	<td valign="top">31214,97</td>
417
	<td valign="top">51488,16</td>
418
	<td valign="top">2040805,13</td>
419
	<td valign="top">65740,59</td>
420
</tr>
421
<tr>
422
	<td valign="top">12</td>
423
	<td valign="top">18</td>
424
	<td valign="top">Удмуртская республика</td>
425
	<td valign="top">13702,36</td>
426
	<td valign="top">62656,00</td>
427
	<td valign="top">2020058,87</td>
428
	<td valign="top">65072,30</td>
429
</tr>
430
<tr>
431
	<td valign="top">7</td>
432
	<td valign="top">76</td>
433
	<td valign="top">Ярославская область</td>
434
	<td valign="top">32306,898</td>
435
	<td valign="top">1204529,89</td>
436
	<td valign="top">1849643,84</td>
437
	<td valign="top">59582,72</td>
438
</tr>
439
<tr>
440
	<td valign="top">1</td>
441
	<td valign="top">35</td>
442
	<td valign="top">Вологодская область</td>
443
	<td valign="top">60000</td>
444
	<td valign="top">36120,00</td>
445
	<td valign="top">1467425,57</td>
446
	<td valign="top">47270,28</td>
447
</tr>
448
<tr>
449
	<td valign="top">2</td>
450
	<td valign="top">69</td>
451
	<td valign="top">Тверская область</td>
452
	<td valign="top">82500</td>
453
	<td valign="top">24475,00</td>
454
	<td valign="top">1315318,86</td>
455
	<td valign="top">42370,46</td>
456
</tr>
457
<tr>
458
	<td valign="top">1</td>
459
	<td valign="top">20</td>
460
	<td valign="top">Чеченская республика</td>
461
	<td valign="top">4740</td>
462
	<td valign="top">25394,80</td>
463
	<td valign="top">1073254,17</td>
464
	<td valign="top">34572,81</td>
465
</tr>
466
<tr>
467
	<td valign="top">3</td>
468
	<td valign="top">02</td>
469
	<td valign="top">Республика Башкортостан</td>
470
	<td valign="top">94448</td>
471
	<td valign="top">408521,96</td>
472
	<td valign="top">420121,96</td>
473
	<td valign="top">13533,42</td>
474
</tr>
475
<tr>
476
	<td valign="top">1</td>
477
	<td valign="top">62</td>
478
	<td valign="top">Рязанская область</td>
479
	<td valign="top">692000</td>
480
	<td valign="top">280260,00</td>
481
	<td valign="top">303678,26</td>
482
	<td valign="top">9782,41</td>
483
</tr>
484
<tr>
485
	<td valign="top">3</td>
486
	<td valign="top">44</td>
487
	<td valign="top">Костромская область</td>
488
	<td valign="top">75</td>
489
	<td valign="top">3352,09</td>
490
	<td valign="top">189200,75</td>
491
	<td valign="top">6094,73</td>
492
</tr>
493
<tr>
494
	<td valign="top">2</td>
495
	<td valign="top">09</td>
496
	<td valign="top">Карачаево-Черкесская республика</td>
497
	<td valign="top">1740000</td>
498
	<td valign="top">177480,00</td>
499
	<td valign="top">177480,00</td>
500
	<td valign="top">5717,17</td>
501
</tr>
502
<tr>
503
	<td valign="top">2</td>
504
	<td valign="top">84</td>
505
	<td valign="top">Красноярский край (?)</td>
506
	<td valign="top">1,402</td>
507
	<td valign="top">2808,93</td>
508
	<td valign="top">142635,72</td>
509
	<td valign="top">4594,73</td>
510
</tr>
511
<tr>
512
	<td valign="top">4</td>
513
	<td valign="top">60</td>
514
	<td valign="top">Псковская область</td>
515
	<td valign="top">769,07</td>
516
	<td valign="top">3422,85</td>
517
	<td valign="top">106256,56</td>
518
	<td valign="top">3422,85</td>
519
</tr>
520
<tr>
521
	<td valign="top">1</td>
522
	<td valign="top">00</td>
523
	<td valign="top"></td>
524
	<td valign="top">39</td>
525
	<td valign="top">785,00</td>
526
	<td valign="top">70064,68</td>
527
	<td valign="top">2257,00</td>
528
</tr>
529
<tr>
530
	<td valign="top">2</td>
531
	<td valign="top">15</td>
532
	<td valign="top">Республика Северная Осетия — Алания</td>
533
	<td valign="top">32,4</td>
534
	<td valign="top">70000,00</td>
535
	<td valign="top">70000,00</td>
536
	<td valign="top">2254,92</td>
537
</tr>
538
<tr>
539
	<td valign="top" colspan="5">ИТОГО:</td>
540
	<td valign="top">6397460611,39</td>
541
	<td valign="top">206059004,21</td>
542
</tr>
543
</table>
544
</body>
(4-4/4)