report.rb

  def show
    begin
      month = Date.parse(params[:month])
    rescue
      flash[:error] = 'Invalid date.'
      redirect_to admin_reports_path and return
    end

    @auctions = Auction.completed.where("updated_at > ? and updated_at <= ?", month, month.end_of_month)

    @headers = [
      "ID", "Nonprofit", "Payee Name", "Nonprofit Phone", "Nonprofit address 1", "Nonprofit address 2", "Nonprofit City",
      "Nonprofit State", "Nonprofit ZIP", "Auction City", "Auction State", "Auction Zip", "Auction Name", "Amount ($)"
    ]

    respond_to do |format|
      format.xls { send_data render_to_string('report') }
    end
  end