Rails and ireport

rails 使用iReport的方法：

本方法使用ireport设计生成报表文件，使用applet方式呈现报表，可以导出报表。

报表的输入数据暂时支持XML，mysql。

 

 

1.在controller目录下 新增document.rb 

# document.rb class Document include Config def self.generate_report(xml_data, report_design, output_type, select_criteria) report_design << '.jasper' if !report_design.match(//.jasper$/) interface_classpath=Dir.getwd+"/public/lib" workDir=Dir.getwd pipe = IO.popen "java -jar #{interface_classpath}/ruport.jar -o#{output_type} -f#{workDir}/reports/#{report_design} -x#{select_criteria}", "w+b" pipe.write xml_data pipe.close_write result = pipe.read pipe.close result end def self.generate_reportFile(xml_data, report_design, output_type, select_criteria,output_file) report_design << '.jasper' if !report_design.match(//.jasper$/) interface_classpath=Dir.getwd+"/public/lib" workDir=Dir.getwd out_file=workDir+"/reports/"+output_file pipe = IO.popen "java -jar #{interface_classpath}/ruport.jar -o#{output_type} -f#{workDir}/reports/#{report_design} -x#{select_criteria} -e#{out_file}", "w+b" pipe.write xml_data pipe.close_write pipe.close out_file end def self.generate_DBreportFile(connStr, report_design, output_type,output_file) report_design << '.jasper' if !report_design.match(//.jasper$/) interface_classpath=Dir.getwd+"/public/lib" workDir=Dir.getwd out_file=workDir+"/reports/"+output_file pipe = IO.popen "java -jar #{interface_classpath}/ruport.jar DBRJReport -o#{output_type} -f#{workDir}/reports/#{report_design} -d#{connStr} -e#{out_file}", "w+b" pipe.close out_file end end 

2. 在controller目录下新增send_doc.rb

require "document.rb" module SendDoc protected def cache_hack # if @request.env['HTTP_USER_AGENT'] =~ /msie/i @headers['Pragma'] = '' @headers['Cache-Control'] = '' # else # @headers['Pragma'] = 'no-cache' # @headers['Cache-Control'] = 'no-cache, must-revalidate' # end end def send_doc(xml, xml_start_path, report, filename, output_type = 'pdf') case output_type when 'rtf' extension = 'rtf' mime_type = 'application/rtf' jasper_type = 'rtf' when 'csv' extension = 'csv' mime_type = 'application/csv' jasper_type = 'csv' when 'xls' extension = 'xls' mime_type = 'application/xls' jasper_type = 'xls' else # pdf extension = 'pdf' mime_type = 'application/pdf' jasper_type = 'pdf' end # cache_hack send_data Document.generate_report(xml, report, jasper_type, xml_start_path), :filename => "#{filename}.#{extension}", :type => mime_type, :disposition => 'attachment' end def get_report(xml, xml_start_path, report, filename, output_type = 'none') path=Document.generate_reportFile(xml, report, output_type, xml_start_path,filename) render :text=>proc {|response, output| len =4096 File.open(path, 'rb') do |file| while buf = file.read(len) output.write(buf) end end } end def get_dbreport(connStr,report,filename,output_type='none') path=Document.generate_DBreportFile(connStr, report, output_type,filename) render :text=>proc {|response, output| len =4096 File.open(path, 'rb') do |file| while buf = file.read(len) output.write(buf) end end } end end 

3. 在action controller中加入 如下代码：

def report # @user=User.find(:all) # table = User.report_table(:all,:only=>['screen_name','email']) # send_data table.to_pdf, :type => "application/pdf", :disposition => "inline", :filename => "report.pdf" # render :text => table.as(:html), :layout => true # @people = Person.find(:all) # respond_to do |format| # format.html #default # format.xml { render :text => @user.to_xml } ## format.pdf { render_jasper_report :collection => @user } # end # render_jasper_report({:collection => @user}),:type => "application/pdf", :disposition => "inline", :filename => "report.pdf" # send_doc(@user.to_xml,'/users/user', 'user.jasper', "userReport", 'pdf') # send_data send_doc(@user.to_xml,'/users/user', 'user.jasper', "userReport", 'csv'),:type => "application/csv", :disposition => "inline",:filename => "report.csv" @dataURL=url_for :action=>"applet" # render :text=>@dataURL end def applet @user=User.find(:all) # Mime::Type.register 'application/pdf', :pdf # Mime::Type.register 'application/vnd.ms-excel', :xls # Mime::Type.register 'application/vnd.ms-excel', :csv respond_to do |format| # format.html {get_report(@user.to_xml,'/users/user', 'user.jasper', "userReport", 'none')} format.html {get_dbreport("jdbc:mysql://localhost:3306/rails_space_development&root&root", 'dbreport.jasper', "userDBReport", 'none')} format.xls { send_doc(@user.to_xml,'/users/user', 'user.jasper', "userReport", 'xls') } format.csv { send_doc(@user.to_xml,'/users/user', 'user.jasper', "userReport", 'csv') } format.pdf { send_doc(@user.to_xml,'/users/user', 'user.jasper', "userReport", 'pdf') } format.json {render :text=>'{"identifier":"id","label":"screen_name","items":'+@user.to_json+'}'} end # get_report(@user.to_xml,'/users/user', 'user.jasper', "userReport", 'none') end 

4. 把ireport的包放在/public/lib下

5. 把applet文件放入html.erb文件中

<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=GBK"> <title> HTML Test Page </title> </head> <body> <applet code = "hv.report.ReportApplet.class" name = "TestApplet" width = "100%" height = "100%" hspace = "0" vspace = "0" align = "middle" ARCHIVE = "/lib/reportApplet.jar" > <param name = "Report_URL" value = "<%=@dataURL%>"> <param name = "Export_URL" value = "<%=@dataURL%>"> </applet> <!--/report.jar,/jasperreports-1.3.3.jar,/poi-2.0.jar,/jfreechart-1.0.0.jar,/jcommon-1.0.0.jar,/iTextAsian.jar --> </body> </html> 

6. 在根目录下新增reports目录，用于存放ireport编译过的jasper文件

 

7.如果要导出报表需要增加mimetype, 在environment.rb中增加：

Mime::Type.register 'application/pdf', :pdf Mime::Type.register 'application/vnd.ms-excel', :xls

8.在route.rb中最后增加：

map.connect ':controller/:action.:format' 

 

 

访问方法： http://localhost:3000/action/report