RUBY RUPORT實踐—Ruport::Controller及Template應用

開發環境：

OS：WindowsXP

Ruby:Ruby1.8.7

Rails:Rails2.3.5

Mysql:Mysql5.0.9

IDE:Rubymine2.0.1

 

一、建立ProductAggragator，實現資料抽取邏輯，本例中將Product.report_table的部分引數做了動態傳參處理

class ProductAggregator #Code here def initialize(options={}) @totalField=options[:totalField] @showField = options[:showField] @userField = options[:userField] @renameField=options[:renameField] @conditions=options[:conditions] end def generateTable @table=Product.report_table(:all,:only=>@showField, :include => { :user => {:only =>@userField } }, :conditions=>@conditions) unless @renameField.empty? replaceColumnName() end unless @totalField.empty? showTotal() end end def replaceColumnName unless @renameField.empty? @renameField.each do|key,value| @table.rename_column(key,value) transferShowField(key,value) end end end def transferShowField(key,value) for i in 0..@showField.length-1 if(@showField[i]==key) @showField[i]=value end end end def showTotal total = {} for i in 0..@showField.length-1 if(i==0) total.store(@showField[i],"Total") elsif(@showField[i]==@totalField) total.store(@showField[i],@table.sigma("price")) else total.store(@showField[i],"") end end @table<<total end end

 

二、建立BaseController，實現Ruport::Controller應用

class BaseController < Ruport::Controller stage :product_sheet def setup self.data = ProductAggregator.new(:showField=>options[:showFields], :userField=>options[:userFields], :totalField=>options[:totalField], :renameField=>options[:renameField], :conditions=>options[:conditions]).generateTable end #等效於 class HTML < Ruport::Formatter::HTML formatter :html do build :product_sheet do output << textile("h3. Products List") output << data.to_html end end #等效於 class PDF < Ruport::Formatter::PDF formatter :pdf do build :product_sheet do pad(10) { add_text "Products List" } draw_table data end end formatter :csv do build :product_sheet do output << data.to_csv end end end

 

三、在ProductsController中進行報表輸出應用

通過template的指定可動態傳遞不同的報表列印模板

def save_as_report Ruport::Formatter::Template.create(:simple) do |format| format.page = {:layout => :landscape} format.grouping = {:style => :separated} format.text = {:font_size => 16,:justification => :center} format.table = {:font_size => 10,:heading_font_size => 15,:maximum_width => 720,:width => 720} format.column = {:alignment => :center} format.heading = {:alignment => :center,:bold => true} end #介面傳引數 pdf =BaseController.render_pdf(:showFields=>["description","title","price"], :userFields=>["username"], :totalField=>"price", :renameField=>{"description"=>"type","title"=>"name","user.username"=>"user"}, :conditions=>["title like ?","%a%"], :template=>:simple) send_data pdf, :type => "application/pdf", :filename => "products.pdf" end

 

四、product/index.html.erb中呼叫報表列印

<%= link_to 'Save As Report', :controller=>"products",:action=>"save_as_report"%>

 

五、在routes.rb中指明save_as_report方法以get方式呼叫

#新增,:collection=>{:save_as_report=>:get}表示當遇到save_as_report時，用get方式，否則預設方式將跳轉到show.html執行查詢 map.resources :products ,:collection => { :save_as_report => :get }

 

報表列印結果：