Ruby Ruport实践—报表参数实现（二）

本例在 Ruby Ruport实践—报表参数实现的基础上进行改造，实现报表执行定义时报表参数的增、删、改操作

一、修改views/report_executions/edit.html.erb

不仅显示在新建报表执行时保存的报表参数，还可动态显示剩余的参数（这里控制参数最多可定义5个），这样可避免遗忘定义报表参数或需要增加报表参数的现象

<h1>Editing report_execution</h1>

<% form_for(@report_execution) do |f| %>
  <%= f.error_messages %>

  <p>
    <%= f.label :execute_code %>:
    <%= f.text_field :execute_code %>
  </p>
  <p>
    <%= f.label :execute_name %>:
    <%= f.text_field :execute_name %>
  </p>
  <p>
    <%= f.label :report_definition_id %>:
    <%=report_definitions_control%>
  </p>
  <p>
    <%= f.label :report_template_id %>:
    <%=report_templates_control%>
  </p>
  <h3>Report Parameters</h3><p/>
  <!-- 显示已有的报表参数 -->
  <%if @report_parameters.length>0%>
  <%for i in 0..@report_parameters.length-1%>
  <p>
    <%=hidden_field_tag 'parameter_id[]',@report_parameters[i].report_parameter_id%>
    Parameter<%=i+1%>: <%=text_field_tag 'parameter_name[]',@report_parameters[i].parameter_name%>
    Value<%=i+1%>: <%=text_field_tag 'parameter_value[]',@report_parameters[i].parameter_value%>
  </p>
  <%end%>
  <%end%>
  <!--显示其他的参数框，若需要添加参数可在此操作-->
  <%for i in @report_parameters.length+1..5%>
  <p>
    Parameter<%=i%>: <%=text_field_tag 'parameter_other_name[]'%>
    Value<%=i%>: <%=text_field_tag 'parameter_other_value[]'%>
  </p>
  <%end%>
  <p>
    <%= f.submit 'Update' %>
  </p>
<% end %>

<%= link_to 'Show', @report_execution %> |
<%= link_to 'Back', report_executions_path %>

二、修改ReportExecutionsController

主要修改create_report_parameter、update、destroy方法

def index
    @report_executions = ReportExecution.all
    respond_to do |format|
      format.html # index.html.erb
      format.xml  { render :xml => @report_executions }
    end
  end

  # GET /report_executions/1
  # GET /report_executions/1.xml
  def show
    @report_execution = ReportExecution.find(params[:id])
    @report_definition = ReportDefinition.find(@report_execution.report_definition_id)
    @report_template = ReportTemplate.find(@report_execution.report_template_id)
    @report_parameters = ReportParameter.find_by_sql("select * from report_parameters where report_execute_id = #{params[:id]}")
    
    respond_to do |format|
      format.html # show.html.erb
      format.xml  { render :xml => @report_execution }
    end
  end

  # GET /report_executions/new
  # GET /report_executions/new.xml
  def new
    @report_execution = ReportExecution.new
    respond_to do |format|
      format.html # new.html.erb
      format.xml  { render :xml => @report_execution }
    end
  end

  # GET /report_executions/1/edit
  def edit
    @report_execution = ReportExecution.find(params[:id])
    report_definition = ReportDefinition.find(@report_execution.report_definition_id)
    report_template = ReportTemplate.find(@report_execution.report_template_id)
    @latest_report_name = report_definition.report_name
    @latest_template_name = report_template.template_name
    @report_parameters = ReportParameter.find_by_sql("select * from report_parameters where report_execute_id = #{params[:id]}")
   
    if (@report_parameters.length>0)
      puts "has parameters #{@report_parameters.length}========================="
      @report_parameters.each do |f|
        puts "#{f.parameter_name}: #{f.parameter_value}"
      end
      puts "has parameters========================="
    end

    
  end

  def create_report_parameters(parameter_name,parameter_value)
    flag=true
     if(parameter_name)
          for i in 0..parameter_name.length-1
            if(parameter_name[i]!="")
             puts "Create report parameter: #{parameter_name[i]}, #{parameter_value[i]}"
             report_parameter = ReportParameter.new
             report_parameter.write_attribute("report_execute_id",@report_execution.report_execute_id)
             report_parameter.write_attribute("parameter_name",parameter_name[i])
             report_parameter.write_attribute("parameter_value",parameter_value[i])
             if !report_parameter.save
               flag=false
             end
            end
          end
     end
    return flag
  end
  # POST /report_executions
  # POST /report_executions.xml
  def create
    @report_execution = ReportExecution.new(params[:report_execution])
    #@report_parameter = ReportParameter.new(params[:report_parameter])
    respond_to do |format|
      if @report_execution.save
        if create_report_parameters(params[:parameter_name],params[:parameter_value]) 
           flash[:notice] = 'ReportExecution was successfully created.'
        end
        format.html { redirect_to(@report_execution) }
        format.xml  { render :xml => @report_execution, :status => :created, :location => @report_execution }
      else
        format.html { render :action => "new" }
        format.xml  { render :xml => @report_execution.errors, :status => :unprocessable_entity }
      end
    end
  end

  # PUT /report_executions/1
  # PUT /report_executions/1.xml
  def update
    @report_execution = ReportExecution.find(params[:id])
    respond_to do |format|
      if @report_execution.update_attributes(params[:report_execution])
        flash[:notice] = 'ReportExecution was successfully updated.'

        if(params[:parameter_id])
          for i in 0..params[:parameter_id].length-1
            report_parameter = ReportParameter.find(params[:parameter_id][i])
            if(params[:parameter_name][i]!="")
              puts "#{report_parameter.report_parameter_id} should be updated"
              report_parameter.update_attribute("parameter_name",params[:parameter_name][i])
              report_parameter.update_attribute("parameter_value",params[:parameter_value][i])
            else
              puts "#{report_parameter.report_parameter_id} should be deleted"
              report_parameter.destroy
            end
          end
        end
        
        create_report_parameters(params[:parameter_other_name],params[:parameter_other_value])

        format.html { redirect_to(@report_execution) }
        format.xml  { head :ok }
      else
        format.html { render :action => "edit" }
        format.xml  { render :xml => @report_execution.errors, :status => :unprocessable_entity }
      end
    end
  end

  # DELETE /report_executions/1
  # DELETE /report_executions/1.xml
  def destroy
    @report_execution = ReportExecution.find(params[:id])
    @report_parameters = ReportParameter.find_by_sql("SELECT * FROM report_parameters WHERE report_execute_id = #{@report_execution.report_execute_id}")
    if(@report_parameters.length>0)
      @report_parameters.each do |report_parameter|
        puts "Destroy report_parameter #{report_parameter.report_parameter_id}"
        report_parameter.destroy
      end
    end
    @report_execution.destroy

    respond_to do |format|
      format.html { redirect_to(report_executions_url) }
      format.xml  { head :ok }
    end
  end

演示效果（主要演示edit界面）：