Rails and ireport

来源：互联网发布：卢旺达种族灭绝知乎编辑：程序博客网时间：2024/04/29 11:14

rails 使用iReport的方法：

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

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

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

# document.rbclass 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 endend

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 } endend

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=>@dataURLenddef 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文件中

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

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

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

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

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

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