Sha256: 00e014b732a74380562794a3555bfb830e3ee61d72d040086bb38f86f2f0f9d4
Contents?: true
Size: 1.68 KB
Versions: 6
Compression:
Stored size: 1.68 KB
Contents
ActiveAdmin.register ReportResult do
actions :show
menu false
member_action :excel do
report_result = ReportResult.find(params[:id])
report = report_result.report
result = report_result.data
fields = result.first.try(:keys) || []
package = Axlsx::Package.new do |p|
p.workbook.add_worksheet(:name => "Report") do |ws|
bold = ws.styles.add_style :b => true, :alignment=> {:horizontal => :center}
ws.add_row fields.map{|x| report_result.human_column_name(x)}, :style => bold
result.each do |r|
row = []
fields.each{|f| row << report_result.human_field_value(f, r[f])}
ws.add_row row
end
end
end
package.use_shared_strings = true
send_data package.to_stream.read, :filename => 'report.xlsx',
:type => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
end
#
# SHOW
#
action_item :only => [:show] do
link_to I18n.t('smartkiosk.admin.actions.report_results.excel'),
excel_admin_report_result_path(report_result)
end
show do
attributes_table do
row :rows
row :report
row :created_at
end
panel I18n.t('smartkiosk.admin.panels.report_results.data') do
report = report_result.report
result = report_result.data
fields = result.first.try(:keys) || []
table do
tr do
fields.each do |field|
th report_result.human_column_name(field)
end
end
result.each do |row|
tr do
fields.each do |field|
td report_result.human_field_value(field, row[field])
end
end
end
end
end
end
end
Version data entries
6 entries across 6 versions & 1 rubygems