RUBY-ON-RAILS

Building Reports Accessible from the Internet

In this second part of a two-part series, we'll finish creating reports that can be accessed via the Internet. This article is excerpted from chapter 5 of the book Practical Reporting with Ruby and Rails, written by David Berube (Apress; ISBN: 1590599330).

Author Info:

By: Apress Publishing

Poor Best

Rating:

/ 1

March 26, 2010

TABLE OF CONTENTS:

<div id="top">
<%=select 'player', 'id',
            [['Click here to select a player',""]] +
            @available_players.map { |p|
                                    [p.name, p.id] },
            {:include_blank=>false} %>
<%=select 'game', 'id',
            [['Click here to select a game',""]] +
            @available_games.map { |g|
                                    [g.name, g.id] },
            {:include_blank=>false} %> </div>
<div id="chart">
</div>

function show_report(){
    $('chart').hide();
    var player_id = $('player_id').value;
    var game_id = $('game_id').value
    if( player_id && game_id ) {
      new Ajax.Updater("chart",
                       '/performance'+
                       '/' + $('game_id').value +
                       '/' + $('player_id').value,

                        {evalScripts:true,
                         method:'get',
                         onComplete:function(){
                            setTimeout("$('chart').show();",
                                     400); }
                         }
                      );

}
}
Event.observe("player_id", "change", show_report);
Event.observe("game_id", "change", show_report);
</script>

The code shown in Listing 5-18 goes in app/views/performance/show.html.erb.

Listing 5-18. Performance Controller Show HTML View (app/views/performance/show.html.erb)

<%if @events.length>1%>

<div>
<% graph_params = { 'AllowScriptAccess'=>'SameDomain' } %>
<%=flashobject_tag "/flash/openflashchart.swf",
                :size=>"850x400",
                :parameters=>graph_params,
                :variables=>{'data'=>"/performance/#{@game.id}
                     /#{@player.id}.text"} %
</div>

<%else%>
<p> <%=@player.name%> has no recorded data for <%=@game.name%>.</p>
<%end%>

The code shown in Listing 5-19 goes in app/views/layouts/show.text.erb.

Listing 5-9. Performance Controller Show Text View (app/views/performance/show.text.erb)

<%
   labels = @events.map { |e| e[:event] }
   values = @events.map { |e| e[:average_time] }
   min = 0
   max = values.max

   graph_variables = { "title"=>",{margin:10px;}",
               "bar_3d"=>"60,#8E9BF0,#000000",
                       "values"=>"#{values.join(',')}",
                       "x_labels"=>"#{labels.join(',')}",
                       "y_max"=>max,
                       "y_min"=>min,

                       "x_axis_3d"=>"16",
                     "tool_tip"=>"#x_label#: #val#s Average Time",
                  "y_axis_colour"=>"#F0F0F0",
                 "y_grid_colour"=>"#E9E9E9",
              "y_label_style"=>"12,#000000",
                 "x_axis_colour"=>"#6F6F7F",
                  "x_grid_colour"=>"#E9E9E9",
               "x_label_style"=>"15,#000000",

"bg_colour"=>"#F8F8FF" }

%>
&<%=graph_variables.to_a.map { |key,val| "#{key}=#{val}" }.join("& &") %>&

Finally, the code shown in Listing 5-20 goes in app/views/layouts/application.html.erb.

Listing 5-20. Layout for the Team Performance View (app/views/layouts/application.html.erb)

<html>
<head>
    <title>Team Performance Web Analyzer</title>
    <style>
      body { font-family: verdana; }
      h1 { margin-bottom:0.5em; }
      #top { margin-bottom: 0; width:802px;
             background-color:#efefef; padding:10px 24px; }
    </style>
    <%=javascript_include_tag :defaults %>
</head>
<body>
    <%=yield%>
</body>
</html>