package spreadsheet

import (
	"archive/zip"
	"fmt"
	"io"
	"io/ioutil"
	"os"
	"path/filepath"

	"go.devnw.com/ooxml"
	"go.devnw.com/ooxml/zippkg"
)

// Read reads a workbook from an io.Reader(.xlsx).
func Read(r io.ReaderAt, size int64) (*Workbook, error) {
	wb := New()
	td, err := ioutil.TempDir("", "gooxml-xlsx")
	if err != nil {
		return nil, err
	}
	wb.TmpPath = td

	zr, err := zip.NewReader(r, size)
	if err != nil {
		return nil, fmt.Errorf("parsing zip: %s", err)
	}

	files := []*zip.File{}
	files = append(files, zr.File...)
	decMap := zippkg.DecodeMap{}
	decMap.SetOnNewRelationshipFunc(wb.onNewRelationship)
	// we should discover all contents by starting with these two files
	decMap.AddTarget(office.ContentTypesFilename, wb.ContentTypes.X(), "", 0)
	decMap.AddTarget(office.BaseRelsFilename, wb.Rels.X(), "", 0)
	if err := decMap.Decode(files); err != nil {
		return nil, err
	}

	// etra files are things we don't handle yet, or files that happened to have
	// been in the zip before.  We just round-trip them.
	for _, f := range files {
		if f == nil {
			continue
		}
		if err := wb.AddExtraFileFromZip(f); err != nil {
			return nil, err
		}
	}
	return wb, nil
}

// Open opens and reads a workbook from a file (.xlsx).
func Open(filename string) (*Workbook, error) {
	f, err := os.Open(filename)
	if err != nil {
		return nil, fmt.Errorf("error opening %s: %s", filename, err)
	}
	defer f.Close()
	fi, err := os.Stat(filename)
	if err != nil {
		return nil, fmt.Errorf("error opening %s: %s", filename, err)
	}
	wb, err := Read(f, fi.Size())
	if err != nil {
		return nil, err
	}
	dir, _ := filepath.Abs(filepath.Dir(filename))
	wb.filename = filepath.Join(dir, filename)
	return wb, nil
}
