package handlers

import (
	"errors"
	"fmt"

	"gitea.tecamino.com/paadi/memberDB/models"
	"gitea.tecamino.com/paadi/memberDB/utils"
)

// AddNewMember adds a new member to memeber table at least fist, las name and birthday has to be entered
func (dh *DatabaseHandler) AddNewMember(members ...models.Member) error {
	if !dh.DatabaseOpened() {
		return errors.New("database not opened")
	}

	for _, member := range members {

		exists, err := dh.memberExists(member)
		if err != nil {
			return err
		} else if exists {
			return fmt.Errorf("member %s %s %s exists already", member.FirstName, member.LastName, member.Birthday)
		}

		//check correct birtday format
		if member.Birthday != "" && !utils.IsValidBirthday(member.Birthday) {
			return errors.New("incorrect birthday format")
		}

		//check correct email format
		if member.Email != "" && !utils.IsValidEmail(member.Email) {
			return errors.New("incorrect email format")
		}

		now := utils.GetCurrentTime(dh.timeLocation)
		member.FirstVisit = now
		member.LastVisit = now

		member.Encrypt(dh.token)

		err = dh.database.AddNewColum(&member)
		if err != nil {
			return err
		}
	}
	return nil
}

// DeleteMember removes members by given ids
func (dh *DatabaseHandler) DeleteMember(ids ...uint) error {
	if !dh.DatabaseOpened() {
		return errors.New("database not opened")
	}

	if len(ids) == 0 {
		return errors.New("no ids given to be deleted")
	}
	return dh.database.DeleteById(&models.Member{}, "", ids...)
}

// GetMember returns one member by given id
func (dh *DatabaseHandler) GetMember(id uint) (members []models.Member, err error) {
	if !dh.DatabaseOpened() {
		return members, errors.New("database not opened")
	}

	err = dh.database.GetById(&members, id, "Group", "Responsible", "Responsible.Member", "Events")
	if err != nil {
		return
	}

	for i := range members {
		if err := members[i].Decrypt(dh.token); err != nil {
			return members, err
		}
		if members[i].Responsible != nil {
			members[i].Responsible.Member.Decrypt(dh.token)
		}
	}
	return
}

// UpdateMember updates/overrides all information given meber id
func (dh *DatabaseHandler) UpdateMember(id uint, member models.Member) (err error) {
	if !dh.DatabaseOpened() {
		return errors.New("database not opened")
	}

	//check correct birtday format
	if member.Birthday != "" && !utils.IsValidBirthday(member.Birthday) {
		return errors.New("incorrect birthday format")
	}

	//check correct email format
	if member.Email != "" && !utils.IsValidEmail(member.Email) {
		return errors.New("incorrect email format")
	}

	if member.Group != nil {
		member.GroupId = &member.Group.Id
	}

	if member.Responsible != nil {
		member.ResponsibleId = &member.Responsible.Id
	}
	member.Encrypt(dh.token)
	return dh.database.UpdateValuesById(&member, uint(member.Id), "Group", "Responsible", "Responsible.Member")
}

// memberExists helper to check wheter member already exists
func (dh *DatabaseHandler) memberExists(checkMember models.Member) (bool, error) {
	if !dh.DatabaseOpened() {
		return false, errors.New("database not opened")
	}

	var members []models.Member
	if !dh.database.Exists(&members, "birthdayHash", dh.hashField(checkMember.Birthday), false) {
		return false, nil
	}

	for _, member := range members {
		if dh.hashField(checkMember.FirstName) == member.FirstNameHash && dh.hashField(checkMember.LastName) == member.LastNameHash && dh.hashField(checkMember.Birthday) == member.BirthdayHash {
			return true, nil
		}
	}

	return false, nil
}