Project

General

Profile

Bug #3365 » u.html

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

 
<body>
Отчёт построен на основе <b>17196</b> предварительно отобранных записей.
Пользователь: <b>test</b>.
<h3>Отчёт импорт по получателям с группировкой по регионам.</h3>
На сервере на формирование отчёта ушло <b>120.41</b> секунд.
Получено <b>58</b> строк.
Вместе с выводом потребовалось <b>120.42</b> секунд.
<table border="1" cellspacing="0" cellpadding="4">
<th align="center" valign="top">count_ND0 <br>Кол-во записей</th>
<th align="center" valign="top">V <br>Код региона</th>
<th align="center" valign="top">NAME <br>Название региона</th>
<th align="center" valign="top">sum_G38 <br>Вес нетто (G38)</th>
<th align="center" valign="top">sum_G42 <br>Фактурная стоимость (G42)</th>
<th align="center" valign="top">sum_G45 <br>Там.стоимость,руб. (G45)</th>
<th align="center" valign="top">sum_G46 <br>Стат.стоимость,USD (G46)</th>
<tr>
<td valign="top">6394</td>
<td valign="top">77</td>
<td valign="top">Москва</td>
<td valign="top">54387335,595</td>
<td valign="top">562153927,90</td>
<td valign="top">1982702214,47</td>
<td valign="top">63868763,84</td>
</tr>
<tr>
<td valign="top">2626</td>
<td valign="top">78</td>
<td valign="top">Санкт-Петербург</td>
<td valign="top">15424112,0772</td>
<td valign="top">131800886,69</td>
<td valign="top">942753927,41</td>
<td valign="top">30368998,43</td>
</tr>
<tr>
<td valign="top">81</td>
<td valign="top">57</td>
<td valign="top">Орловская область</td>
<td valign="top">878459,317</td>
<td valign="top">854712,25</td>
<td valign="top">893832840,99</td>
<td valign="top">28793099,96</td>
</tr>
<tr>
<td valign="top">2004</td>
<td valign="top">39</td>
<td valign="top">Калининградская область</td>
<td valign="top">10049337,177</td>
<td valign="top">18651125,22</td>
<td valign="top">482255918,75</td>
<td valign="top">15534943,82</td>
</tr>
<tr>
<td valign="top">2016</td>
<td valign="top">50</td>
<td valign="top">Московская область</td>
<td valign="top">25492346,5107</td>
<td valign="top">105851548,13</td>
<td valign="top">395403456,56</td>
<td valign="top">12654857,03</td>
</tr>
<tr>
<td valign="top">25</td>
<td valign="top">31</td>
<td valign="top">Белгородская область</td>
<td valign="top">6941076,28</td>
<td valign="top">263769856,19</td>
<td valign="top">284731946,86</td>
<td valign="top">9168697,56</td>
</tr>
<tr>
<td valign="top">267</td>
<td valign="top">23</td>
<td valign="top">Краснодарский край</td>
<td valign="top">9771147,505</td>
<td valign="top">7720415,17</td>
<td valign="top">215994766,64</td>
<td valign="top">6984206,53</td>
</tr>
<tr>
<td valign="top">299</td>
<td valign="top"></td>
<td valign="top"></td>
<td valign="top">1455761,439</td>
<td valign="top">5961463,83</td>
<td valign="top">210101149,92</td>
<td valign="top">6766083,43</td>
</tr>
<tr>
<td valign="top">50</td>
<td valign="top">32</td>
<td valign="top">Брянская область</td>
<td valign="top">5482994,29</td>
<td valign="top">5342072,13</td>
<td valign="top">172037758,14</td>
<td valign="top">5541864,36</td>
</tr>
<tr>
<td valign="top">410</td>
<td valign="top">47</td>
<td valign="top">Ленинградская область</td>
<td valign="top">1121822,46</td>
<td valign="top">2793252,78</td>
<td valign="top">88570359,40</td>
<td valign="top">2853123,21</td>
</tr>
<tr>
<td valign="top">475</td>
<td valign="top">25</td>
<td valign="top">Приморский край</td>
<td valign="top">1071844,17</td>
<td valign="top">3426830,26</td>
<td valign="top">78777240,36</td>
<td valign="top">2391035,17</td>
</tr>
<tr>
<td valign="top">225</td>
<td valign="top">75</td>
<td valign="top">Забайкальский край</td>
<td valign="top">1170893</td>
<td valign="top">1317123,62</td>
<td valign="top">58778159,50</td>
<td valign="top">1893424,99</td>
</tr>
<tr>
<td valign="top">141</td>
<td valign="top">63</td>
<td valign="top">Самарская область</td>
<td valign="top">407105,679</td>
<td valign="top">32090529,04</td>
<td valign="top">56513552,70</td>
<td valign="top">1780872,27</td>
</tr>
<tr>
<td valign="top">13</td>
<td valign="top">41</td>
<td valign="top">Камчатский край</td>
<td valign="top">935651,8</td>
<td valign="top">0,00</td>
<td valign="top">52330026,28</td>
<td valign="top">1685710,81</td>
</tr>
<tr>
<td valign="top">34</td>
<td valign="top">74</td>
<td valign="top">Челябинская область</td>
<td valign="top">398517,1</td>
<td valign="top">1389100,25</td>
<td valign="top">50320160,92</td>
<td valign="top">1632170,28</td>
</tr>
<tr>
<td valign="top">27</td>
<td valign="top">40</td>
<td valign="top">Калужская область</td>
<td valign="top">2697212,065</td>
<td valign="top">14411671,27</td>
<td valign="top">38947048,17</td>
<td valign="top">1254603,99</td>
</tr>
<tr>
<td valign="top">13</td>
<td valign="top">55</td>
<td valign="top">Омская область</td>
<td valign="top">346022,516</td>
<td valign="top">937010,79</td>
<td valign="top">35270407,38</td>
<td valign="top">1133287,91</td>
</tr>
<tr>
<td valign="top">44</td>
<td valign="top">61</td>
<td valign="top">Ростовская область</td>
<td valign="top">114209,61</td>
<td valign="top">362328,81</td>
<td valign="top">30409930,24</td>
<td valign="top">979597,21</td>
</tr>
<tr>
<td valign="top">10</td>
<td valign="top">14</td>
<td valign="top">Республика Саха (Якутия)</td>
<td valign="top">164862,49</td>
<td valign="top">582364,07</td>
<td valign="top">23532477,40</td>
<td valign="top">758053,35</td>
</tr>
<tr>
<td valign="top">99</td>
<td valign="top">54</td>
<td valign="top">Новосибирская область</td>
<td valign="top">168519,036</td>
<td valign="top">650118,13</td>
<td valign="top">22391421,93</td>
<td valign="top">721296,53</td>
</tr>
<tr>
<td valign="top">52</td>
<td valign="top">99</td>
<td valign="top">Территории, находящиеся за пределами РФ и обслуживаемые Управлением режимных объектов МВД России, Байконур</td>
<td valign="top">471962,509</td>
<td valign="top">282284,63</td>
<td valign="top">21542416,92</td>
<td valign="top">696353,21</td>
</tr>
<tr>
<td valign="top">31</td>
<td valign="top">16</td>
<td valign="top">Республика Татарстан</td>
<td valign="top">60857,002</td>
<td valign="top">562379,22</td>
<td valign="top">21389164,72</td>
<td valign="top">689010,68</td>
</tr>
<tr>
<td valign="top">255</td>
<td valign="top">66</td>
<td valign="top">Свердловская область</td>
<td valign="top">807284,63</td>
<td valign="top">552328,26</td>
<td valign="top">20436445,15</td>
<td valign="top">658320,62</td>
</tr>
<tr>
<td valign="top">3</td>
<td valign="top">34</td>
<td valign="top">Волгоградская область</td>
<td valign="top">1100390</td>
<td valign="top">19518454,00</td>
<td valign="top">19807827,76</td>
<td valign="top">638070,94</td>
</tr>
<tr>
<td valign="top">36</td>
<td valign="top">67</td>
<td valign="top">Смоленская область</td>
<td valign="top">775125,16</td>
<td valign="top">2835965,98</td>
<td valign="top">19058252,73</td>
<td valign="top">613924,81</td>
</tr>
<tr>
<td valign="top">231</td>
<td valign="top">56</td>
<td valign="top">Оренбургская область</td>
<td valign="top">95243,6</td>
<td valign="top">545692,48</td>
<td valign="top">18056165,17</td>
<td valign="top">581644,50</td>
</tr>
<tr>
<td valign="top">20</td>
<td valign="top">71</td>
<td valign="top">Тульская область</td>
<td valign="top">405818,651</td>
<td valign="top">484677,85</td>
<td valign="top">16882140,67</td>
<td valign="top">543825,58</td>
</tr>
<tr>
<td valign="top">76</td>
<td valign="top">43</td>
<td valign="top">Кировская область</td>
<td valign="top">344897,3</td>
<td valign="top">343242,49</td>
<td valign="top">16112264,37</td>
<td valign="top">519025,50</td>
</tr>
<tr>
<td valign="top">25</td>
<td valign="top">28</td>
<td valign="top">Амурская область</td>
<td valign="top">51795,89</td>
<td valign="top">111887,90</td>
<td valign="top">9348498,03</td>
<td valign="top">507629,56</td>
</tr>
<tr>
<td valign="top">74</td>
<td valign="top">53</td>
<td valign="top">Новгородская область</td>
<td valign="top">179339,8</td>
<td valign="top">401134,00</td>
<td valign="top">14704621,28</td>
<td valign="top">481271,44</td>
</tr>
<tr>
<td valign="top">8</td>
<td valign="top">36</td>
<td valign="top">Воронежская область</td>
<td valign="top">149475,32</td>
<td valign="top">258575,25</td>
<td valign="top">13115049,58</td>
<td valign="top">422476,02</td>
</tr>
<tr>
<td valign="top">5</td>
<td valign="top">48</td>
<td valign="top">Липецкая область</td>
<td valign="top">147605</td>
<td valign="top">393156,04</td>
<td valign="top">11615018,70</td>
<td valign="top">374155,42</td>
</tr>
<tr>
<td valign="top">8</td>
<td valign="top">26</td>
<td valign="top">Ставропольский край</td>
<td valign="top">7029500</td>
<td valign="top">281097,12</td>
<td valign="top">9218356,56</td>
<td valign="top">296951,56</td>
</tr>
<tr>
<td valign="top">35</td>
<td valign="top">72</td>
<td valign="top">Тюменская область</td>
<td valign="top">21041,68</td>
<td valign="top">132384,83</td>
<td valign="top">8347505,72</td>
<td valign="top">268898,81</td>
</tr>
<tr>
<td valign="top">7</td>
<td valign="top">33</td>
<td valign="top">Владимирская область</td>
<td valign="top">794096,5</td>
<td valign="top">358547,70</td>
<td valign="top">8288117,68</td>
<td valign="top">266985,72</td>
</tr>
<tr>
<td valign="top">29</td>
<td valign="top">24</td>
<td valign="top">Красноярский край</td>
<td valign="top">160457</td>
<td valign="top">250705,54</td>
<td valign="top">7960305,45</td>
<td valign="top">256425,89</td>
</tr>
<tr>
<td valign="top">10</td>
<td valign="top">52</td>
<td valign="top">Нижегородская область</td>
<td valign="top">163937</td>
<td valign="top">201087,41</td>
<td valign="top">7460581,31</td>
<td valign="top">240328,23</td>
</tr>
<tr>
<td valign="top">3</td>
<td valign="top">05</td>
<td valign="top">Республика Дагестан</td>
<td valign="top">187091</td>
<td valign="top">5685655,00</td>
<td valign="top">5685655,00</td>
<td valign="top">183152,41</td>
</tr>
<tr>
<td valign="top">7</td>
<td valign="top">11</td>
<td valign="top">Республика Коми</td>
<td valign="top">318112</td>
<td valign="top">162988,04</td>
<td valign="top">5640301,80</td>
<td valign="top">181691,44</td>
</tr>
<tr>
<td valign="top">6</td>
<td valign="top">64</td>
<td valign="top">Саратовская область</td>
<td valign="top">156634,5</td>
<td valign="top">101678,16</td>
<td valign="top">4380650,80</td>
<td valign="top">141114,21</td>
</tr>
<tr>
<td valign="top">5</td>
<td valign="top">65</td>
<td valign="top">Сахалинская область</td>
<td valign="top">218412</td>
<td valign="top">0,00</td>
<td valign="top">3108152,00</td>
<td valign="top">100123,12</td>
</tr>
<tr>
<td valign="top">2</td>
<td valign="top">59</td>
<td valign="top">Пермский край</td>
<td valign="top">82780</td>
<td valign="top">98908,80</td>
<td valign="top">3099132,51</td>
<td valign="top">99832,57</td>
</tr>
<tr>
<td valign="top">3</td>
<td valign="top">21</td>
<td valign="top">Чувашская республика</td>
<td valign="top">11579,97</td>
<td valign="top">67854,46</td>
<td valign="top">2911875,28</td>
<td valign="top">93800,44</td>
</tr>
<tr>
<td valign="top">3</td>
<td valign="top">38</td>
<td valign="top">Иркутская область</td>
<td valign="top">60533</td>
<td valign="top">60200,26</td>
<td valign="top">2391403,81</td>
<td valign="top">77034,46</td>
</tr>
<tr>
<td valign="top">6</td>
<td valign="top">51</td>
<td valign="top">Мурманская область</td>
<td valign="top">31214,97</td>
<td valign="top">51488,16</td>
<td valign="top">2040805,13</td>
<td valign="top">65740,59</td>
</tr>
<tr>
<td valign="top">12</td>
<td valign="top">18</td>
<td valign="top">Удмуртская республика</td>
<td valign="top">13702,36</td>
<td valign="top">62656,00</td>
<td valign="top">2020058,87</td>
<td valign="top">65072,30</td>
</tr>
<tr>
<td valign="top">7</td>
<td valign="top">76</td>
<td valign="top">Ярославская область</td>
<td valign="top">32306,898</td>
<td valign="top">1204529,89</td>
<td valign="top">1849643,84</td>
<td valign="top">59582,72</td>
</tr>
<tr>
<td valign="top">1</td>
<td valign="top">35</td>
<td valign="top">Вологодская область</td>
<td valign="top">60000</td>
<td valign="top">36120,00</td>
<td valign="top">1467425,57</td>
<td valign="top">47270,28</td>
</tr>
<tr>
<td valign="top">2</td>
<td valign="top">69</td>
<td valign="top">Тверская область</td>
<td valign="top">82500</td>
<td valign="top">24475,00</td>
<td valign="top">1315318,86</td>
<td valign="top">42370,46</td>
</tr>
<tr>
<td valign="top">1</td>
<td valign="top">20</td>
<td valign="top">Чеченская республика</td>
<td valign="top">4740</td>
<td valign="top">25394,80</td>
<td valign="top">1073254,17</td>
<td valign="top">34572,81</td>
</tr>
<tr>
<td valign="top">3</td>
<td valign="top">02</td>
<td valign="top">Республика Башкортостан</td>
<td valign="top">94448</td>
<td valign="top">408521,96</td>
<td valign="top">420121,96</td>
<td valign="top">13533,42</td>
</tr>
<tr>
<td valign="top">1</td>
<td valign="top">62</td>
<td valign="top">Рязанская область</td>
<td valign="top">692000</td>
<td valign="top">280260,00</td>
<td valign="top">303678,26</td>
<td valign="top">9782,41</td>
</tr>
<tr>
<td valign="top">3</td>
<td valign="top">44</td>
<td valign="top">Костромская область</td>
<td valign="top">75</td>
<td valign="top">3352,09</td>
<td valign="top">189200,75</td>
<td valign="top">6094,73</td>
</tr>
<tr>
<td valign="top">2</td>
<td valign="top">09</td>
<td valign="top">Карачаево-Черкесская республика</td>
<td valign="top">1740000</td>
<td valign="top">177480,00</td>
<td valign="top">177480,00</td>
<td valign="top">5717,17</td>
</tr>
<tr>
<td valign="top">2</td>
<td valign="top">84</td>
<td valign="top">Красноярский край (?)</td>
<td valign="top">1,402</td>
<td valign="top">2808,93</td>
<td valign="top">142635,72</td>
<td valign="top">4594,73</td>
</tr>
<tr>
<td valign="top">4</td>
<td valign="top">60</td>
<td valign="top">Псковская область</td>
<td valign="top">769,07</td>
<td valign="top">3422,85</td>
<td valign="top">106256,56</td>
<td valign="top">3422,85</td>
</tr>
<tr>
<td valign="top">1</td>
<td valign="top">00</td>
<td valign="top"></td>
<td valign="top">39</td>
<td valign="top">785,00</td>
<td valign="top">70064,68</td>
<td valign="top">2257,00</td>
</tr>
<tr>
<td valign="top">2</td>
<td valign="top">15</td>
<td valign="top">Республика Северная Осетия — Алания</td>
<td valign="top">32,4</td>
<td valign="top">70000,00</td>
<td valign="top">70000,00</td>
<td valign="top">2254,92</td>
</tr>
<tr>
<td valign="top" colspan="5">ИТОГО:</td>
<td valign="top">6397460611,39</td>
<td valign="top">206059004,21</td>
</tr>
</table>
</body>
(4-4/4)