Redmine之报表应用研究

近来将RedMine的源代码下下来进行研究，主要目的是研究它的Report功能是如何实现的

目前研究结果总结为几点：

1）Remine界面上支持PDF，CSV，HTML输出，但没有单独的报表运行中心，只有在Issue及Gant界面有报表输出功能

2）新建两个用户a和b，a用户在创建时默认语言选择“English”，b用户选择"Chinese(Simple)"，进行报表打印时发现第一个用户打印出来的PDF报表中文显示为乱码，第二个用户打印的PDF报表中文显示正常

 

对于以上两点，进行了代码跟踪，得出了以下结论

1）报表输出的代码写在IssuesController，关键代码如下：

respond_to do |format| format.html { render :template => 'issues/index.rhtml', :layout => !request.xhr? } format.atom { render_feed(@issues, :title => "#{@project || Setting.app_title}: #{l(:label_issue_plural)}") } format.csv { send_data(issues_to_csv(@issues, @project), :type => 'text/csv; header=present', :filename => 'export.csv') } format.pdf { send_data(issues_to_pdf(@issues, @project, @query), :type => 'application/pdf', :filename => 'export.pdf') } end

 

代码中很清晰看到CSV、PDF 的输出调用的是 issues_to_csv,issues_to_pdf（Gant界面的报表调用的是gant_to_pdf）

从名字可猜测Redmine中的报表打印并不通用，只是针对特定的报表进行了固定的输出处理

 

issue_to_pdf，issues_to_pdf，gant_to_pdf都包含在pdf.rb中，代码如下：

# encoding: utf-8 # # Redmine - project management software # Copyright (C) 2006-2009 Jean-Philippe Lang # # This program is free software; you can redistribute it and/or # modify it under the terms of the GNU General Public License # as published by the Free Software Foundation; either version 2 # of the License, or (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. require 'iconv' require 'rfpdf/fpdf' require 'rfpdf/chinese' module Redmine module Export module PDF include ActionView::Helpers::TextHelper include ActionView::Helpers::NumberHelper class IFPDF < FPDF include Redmine::I18n attr_accessor :footer_date def initialize(lang) super() set_language_if_valid lang puts "=============================Current Language #{current_language.to_s.downcase}" #current_language = 'zh' case current_language.to_s.downcase when 'ko' extend(PDF_Korean) AddUHCFont() @font_for_content = 'UHC' @font_for_footer = 'UHC' when 'ja' extend(PDF_Japanese) AddSJISFont() @font_for_content = 'SJIS' @font_for_footer = 'SJIS' when 'zh' extend(PDF_Chinese) AddGBFont() @font_for_content = 'GB' @font_for_footer = 'GB' puts "=========================AddGBFont()" when 'zh-tw' extend(PDF_Chinese) AddBig5Font() @font_for_content = 'Big5' @font_for_footer = 'Big5' else @font_for_content = 'Arial' @font_for_footer = 'Helvetica' end SetCreator(Redmine::Info.app_name) SetFont(@font_for_content) end def SetFontStyle(style, size) SetFont(@font_for_content, style, size) end def SetTitle(txt) txt = begin utf16txt = Iconv.conv('UTF-16BE', 'UTF-8', txt) hextxt = "<FEFF" # FEFF is BOM hextxt << utf16txt.unpack("C*").map {|x| sprintf("%02X",x) }.join hextxt << ">" rescue txt end || '' super(txt) end def textstring(s) # Format a text string if s =~ /^</ # This means the string is hex-dumped. return s else return '('+escape(s)+')' end end def Cell(w,h=0,txt='',border=0,ln=0,align='',fill=0,link='') puts ":general_pdf_encoding==================#{l(:general_pdf_encoding)}" @ic ||= Iconv.new(l(:general_pdf_encoding), 'UTF-8') # these quotation marks are not correctly rendered in the pdf txt = txt.gsub(/[“�]/, '"') if txt txt = begin # 0x5c char