Contents

require 'query_report/report'

module QueryReport
  module Helper
    def reporter(query, options={}, &block)
      @report ||= QueryReport::Report.new(params, options)
      @report.query = query
      @report.instance_eval &block
      render_report
    end

    def render_report
      respond_to do |format|
        format.js { render 'query_report/list' }
        format.html { render 'query_report/list' }
        format.json { render json: @report.records }
        format.csv { send_data generate_csv_for_report(@report.all_records), :disposition => "attachment;" }
        format.pdf { render_pdf(ReportPdf.new(@report).standard) }
      end
    end

    def generate_csv_for_report(records)
      if records.size > 0
        columns = records.first.keys
        CSV.generate do |csv|
          csv << columns
          records.each do |record|
            csv << record.values
          end
        end
      else
        nil
      end
    end
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
query_report-0.0.9	lib/query_report/helper.rb
query_report-0.0.8	lib/query_report/helper.rb
query_report-0.0.7	lib/query_report/helper.rb
query_report-0.0.6	lib/query_report/helper.rb
query_report-0.0.5	lib/query_report/helper.rb
query_report-0.0.4	lib/query_report/helper.rb