<% content_for :head do %> <%= stylesheet_link_tag "index" , :media => "all"%> <%= stylesheet_link_tag "filters" , :media => "all"%> <%= stylesheet_link_tag "materialsTable" , :media => "all"%> <%= stylesheet_link_tag "DataTables", :media => "all" %> <%= javascript_include_tag "table2CSV"%> <%= javascript_include_tag "dataTables.numericComma"%> <% end %>
<% form_tag "/soft/rt_dynamic", :method => :get do -%> <%= label_tag 'Дата с:' %><%= calendar_field_tag 'date_from', Russian::strftime(@date_from), { :class => 'plaintext', :size=> 9 }, {} %> <%= label_tag 'Дата по:' %><%= calendar_field_tag 'date_to', Russian::strftime(@date_to), { :class => 'plaintext', :size=> 9 }, {} %>
<%= button_to "Фильтр" %> <% end -%>
">

Динамика софтовых заявок для ЭрТел:

<% @weeks_and_dates.each do |cnumber| %> <% reports = @reports2.select{|i| i.date.to_date.cweek == cnumber[0]}%> <% old_reps = @reports1.select{|i| i.date.to_date >= cnumber[1] && i.date.to_date <= cnumber[2]}%> <% end %> <% (1..12).each do |month| %> <% reports = @reports2year[month].to_a%> <% old_reps = @reports1year[month].to_a%> <% end %>
Даты Сумма всех заявок все, кроме обслуживания все Корп все частные Ринет-офис, Ринет-халява и ОКК-халява Осмотры LTE KPI
<%= @year1 %> <%= @year2 %> <%= @year1 %> <%= @year2 %> <%= @year1 %> <%= @year2 %> <%= @year1 %> <%= @year2 %> <%= @year1 %> <%= @year2 %> <%= @year1 %> <%= @year2 %> <%= @year1 %> <%= @year2 %> <4 4-24 24-48 >48 Доля продолбов
Данные по неделям
<%= cnumber[3]%> <%= old_reps.size%> <%= reports.size%> <%= old_reps.select{|i| i.category != 25}.size%> <%= reports.select{|i| i.category != 25}.size%> <%= old_reps.select{|i| i.client_type == 1}.size%> <%= reports.select{|i| i.client_type == 1}.size%> <%= old_reps.select{|i| i.client_type == 0}.size%> <%= reports.select{|i| i.client_type == 0}.size%> <%= old_reps.select{|i| ([26, 27, 93].include? i.category)}.size%> <%= reports.select{|i| ([26, 27, 93].include? i.category)}.size%> <%= old_reps.select{|i| i.payment_detail == 4}.size%> <%= reports.select{|i| i.payment_detail == 4}.size%> <%= old_reps.select{|i| i.payment_detail == 10}.size%> <%= reports.select{|i| i.payment_detail == 10}.size%> <%= a=reports.select{|i| ([26, 27, 93].include? i.category) && (i.kpi/3600) < 4 }.size %> <%= b=reports.select{|i| ([26, 27, 93].include? i.category) && (i.kpi/3600) > 4 && (i.kpi/3600) < 24}.size %> <%= c=reports.select{|i| ([26, 27, 93].include? i.category) && (i.kpi/3600) > 24 && (i.kpi/3600) < 48}.size %> <%= d=reports.select{|i| ([26, 27, 93].include? i.category) && (i.kpi/3600) > 48}.size %> <%= (((c.to_f+d)/(a.to_f+b))*100).round(2) if (a+b > 0)%>
Данные по месяцам
<%= h Russian::strftime(Date.new(@date_from.year, month), "%B %Y") %> <%= old_reps.size%> <%= reports.size%> <%= old_reps.select{|i| i.category != 25}.size%> <%= reports.select{|i| i.category != 25}.size%> <%= old_reps.select{|i| i.client_type == 1}.size%> <%= reports.select{|i| i.client_type == 1}.size%> <%= old_reps.select{|i| i.client_type == 0}.size%> <%= reports.select{|i| i.client_type == 0}.size%> <%= old_reps.select{|i| ([26, 27, 93].include? i.category)}.size%> <%= reports.select{|i| ([26, 27, 93].include? i.category)}.size%> <%= old_reps.select{|i| i.payment_detail == 4}.size%> <%= reports.select{|i| i.payment_detail == 4}.size%> <%= old_reps.select{|i| i.payment_detail == 10}.size%> <%= reports.select{|i| i.payment_detail == 10}.size%> <%= a=reports.select{|i| ([26, 27, 93].include? i.category) && (i.kpi/3600) < 4 }.size %> <%= b=reports.select{|i| ([26, 27, 93].include? i.category) && (i.kpi/3600) > 4 && (i.kpi/3600) < 24}.size %> <%= c=reports.select{|i| ([26, 27, 93].include? i.category) && (i.kpi/3600) > 24 && (i.kpi/3600) < 48}.size %> <%= d=reports.select{|i| ([26, 27, 93].include? i.category) && (i.kpi/3600) > 48}.size %> <%= (((c.to_f+d)/(a.to_f+b))*100).round(2) if (a+b > 0)%>