130 lines
3.5 KiB
Go
130 lines
3.5 KiB
Go
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
|
|
}
|