package gexcel

import (
	"bytes"
	"errors"
	"regexp"
	"strings"
)

type _CommonFileHandle struct {
	sh SheetHandle
}

func (p *_CommonFileHandle) Each(name string, idx int) (SheetHandle, error) {
	if idx > 0 {
		return nil, SheetIgnore
	}
	return p.sh, nil
}

func NewFileHandle(sh SheetHandle) FileHandle {
	return &_CommonFileHandle{sh: sh}
}

func Trim(val string) string {
	return strings.Trim(val, trimChar)
}

func NumberRemoveComma(val string) string {
	return strings.ReplaceAll(val, ",", "")
}

func FormatDate(val string) string {
	if val == "" {
		return val
	}
	if match, _ := regexp.MatchString(`^\d{4}-\d{1,2}-\d{1,2}$`, val); match {
		dVals := strings.Split(val, "-")
		if len(dVals[1]) < 2 {
			dVals[1] = "0" + dVals[1]
		}
		if len(dVals[2]) < 2 {
			dVals[2] = "0" + dVals[2]
		}
		return strings.Join(dVals, "-")
	} else if match, _ = regexp.MatchString(`^\d{4}/\d{1,2}/\d{1,2}$`, val); match {
		dVals := strings.Split(val, "/")
		if len(dVals[1]) < 2 {
			dVals[1] = "0" + dVals[1]
		}
		if len(dVals[2]) < 2 {
			dVals[2] = "0" + dVals[2]
		}
		return strings.Join(dVals, "-")
	} else if match, _ = regexp.MatchString(`^\d{4}\d{2}\d{2}$`, val); match {
		return val[0:4] + "-" + val[4:6] + "-" + val[6:8]
	}
	return ""
}

func Parse(ft string, buf *bytes.Buffer, h FileHandle, ignore bool, fps ...FileParse) *ParseError {
	if len(fps) == 0 {
		fps = defaultParsers
	}
	for _, v := range fps {
		if v.Type() == ft {
			if err := v.Init(buf); err != nil {
				return err
			}
			if v.Len() > 0 {
				return v.Parse(h, ignore)
			}
			return nil
		}
	}
	return &ParseError{Err: errors.New("文件格式错误")}
}