# frozen_string_literal: true

require "zip"

module Xsv
  # An OOXML Spreadsheet document is called a Workbook. A Workbook consists of
  # multiple Sheets that are available in the array that's accessible through {#sheets}
  class Workbook
    include Enumerable

    # Access the Sheet objects contained in the workbook
    # @return [Array<Sheet>]
    attr_reader :sheets

    attr_reader :shared_strings, :xfs, :num_fmts, :trim_empty_rows

    # @deprecated Use {Xsv.open} instead
    def self.open(data, **kws, &block)
      Xsv.open(data, **kws, &block)
    end

    # Open a workbook from an instance of {Zip::File}. Generally it's recommended
    # to use the {.open} method instead of the constructor.
    #
    # @param trim_empty_rows [Boolean] Scan sheet for end of content and don't return trailing rows
    # @param parse_headers [Boolean] Call `parse_headers!` on all sheets on load
    def initialize(zip, trim_empty_rows: false, parse_headers: false)
      raise ArgumentError, "Passed argument is not an instance of Zip::File. Did you mean to use Workbook.open?" unless zip.is_a?(Zip::File)
      raise Xsv::Error, "Zip::File is empty" if zip.size.zero?

      @zip = zip
      @trim_empty_rows = trim_empty_rows

      @sheets = []
      @xfs, @num_fmts = fetch_styles
      @sheet_ids = fetch_sheet_ids
      @relationships = fetch_relationships
      @shared_strings = fetch_shared_strings
      @sheets = fetch_sheets(parse_headers ? :hash : :array)
    end

    # @return [String]
    def inspect
      "#<#{self.class.name}:#{object_id} sheets=#{sheets.count} trim_empty_rows=#{@trim_empty_rows}>"
    end

    # Close the handle to the workbook file and leave all resources for the GC to collect
    # @return [true]
    def close
      @zip.close
      @zip = nil
      @sheets = nil
      @xfs = nil
      @num_fmts = nil
      @relationships = nil
      @shared_strings = nil
      @sheet_ids = nil

      true
    end

    # Returns an array of sheets for the case of same name sheets.
    # @param [String] name
    # @return [Array<Xsv::Sheet>]
    def sheets_by_name(name)
      @sheets.select { |s| s.name == name }
    end

    # Get number format for given style index
    def get_num_fmt(style)
      @num_fmts[@xfs[style][:numFmtId]]
    end

    def each(&block)
      sheets.each(&block)
    end

    # Get a sheet by index or name
    # @param [String, Integer] index_or_name The name of the sheet or index in the workbook
    # @return [<Xsv::Sheet>, nil] returns the sheet instance or nil if it was not found
    def [](index_or_name)
      case index_or_name
      when Integer
        sheets[index_or_name]
      when String
        sheets_by_name(index_or_name).first
      else
        raise ArgumentError, "Sheets can be accessed by Integer of String only"
      end
    end

    private

    def fetch_shared_strings
      handle = @zip.glob("xl/sharedStrings.xml").first
      return if handle.nil?

      stream = handle.get_input_stream
      SharedStringsParser.parse(stream)
    ensure
      stream&.close
    end

    def fetch_styles
      stream = @zip.glob("xl/styles.xml").first.get_input_stream

      StylesHandler.get_styles(stream)
    ensure
      stream.close
    end

    def fetch_sheets(mode)
      @zip.glob("xl/worksheets/sheet*.xml").sort do |a, b|
        a.name[/\d+/].to_i <=> b.name[/\d+/].to_i
      end.map do |entry|
        rel = @relationships.detect do |r|
          entry.name.end_with?(r[:Target].sub(/^\//, "")) && # ignore leading / in some files
            r[:Type].end_with?("worksheet")
        end
        sheet_ids = @sheet_ids.detect { |i| i[:id] == rel[:Id] }
        Xsv::Sheet.new(self, entry.get_input_stream, sheet_ids).tap do |sheet|
          sheet.parse_headers! if mode == :hash
        end
      end
    end

    def fetch_sheet_ids
      stream = @zip.glob("xl/workbook.xml").first.get_input_stream
      SheetsIdsHandler.get_sheets_ids(stream)
    ensure
      stream.close
    end

    def fetch_relationships
      stream = @zip.glob("xl/_rels/workbook.xml.rels").first.get_input_stream
      RelationshipsHandler.get_relations(stream)
    ensure
      stream.close
    end
  end
end