require 'spreadsheet'
 
class ExcelExport
  # http://spreadsheet.rubyforge.org/files/GUIDE_txt.html
  # http://spreadsheet.rubyforge.org/
  # http://github.com/jacobat/ruby-spreadsheet/tree/master
  
  class << self
 
    #
    # This method will take all export all queries from a report.
    #   * Each query will be a seperate workbook sheet
    #
    def full_report_export(site, report, query_data)
      workbook = Spreadsheet::Workbook.new
 
      # create a new worksheet for each query
      query_data.each_key do |key|
        sheet = workbook.create_worksheet( :name => key.to_s )
 
        # set the header row
        sheet.row(0).concat query_data[key].first.instance_variable_get(:@attributes).keys 
 
        # populate the data rows
        query_data[key].each_with_index do | arr, idx |
          sheet.row(idx+1).concat arr.instance_variable_get(:@attributes).values
        end 
      end
 
      prefix = Rails.env.production? ? '' : "#{Rails.env}-"
      file_path = "#{RAILS_ROOT}/public/system/export/#{prefix}#{site.slug}-#{report.slug}-report-export.xls"
      workbook.write file_path
 
      # return the file path to the controller
      file_path
    end
 
  end
end
 

before(:all) do
  @report = mock_model(Report, :slug => 'occupancy')
  @report.stub!(:query_data).and_return( YAML.load_file( "#{RAILS_ROOT}/spec/data_dumps/occupancy.yml") )
  @site = mock_model(Site, :slug => 'chatswood', :dw_site_id => 1)
  @query_data = @report.query_data( :site_id => @site.dw_site_id, :date1 => 1.week.ago.to_s(:dw) , :date2 => 1.day.ago.to_s(:dw) )
end