| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210 | 
							- // Copyright 2016 The Gogs Authors. All rights reserved.
 
- // Use of this source code is governed by a MIT-style
 
- // license that can be found in the LICENSE file.
 
- package db
 
- import (
 
- 	"fmt"
 
- 	"strings"
 
- 	"gogs.io/gogs/internal/db/errors"
 
- )
 
- // EmailAdresses is the list of all email addresses of a user. Can contain the
 
- // primary email address, but is not obligatory.
 
- type EmailAddress struct {
 
- 	ID          int64
 
- 	UID         int64  `xorm:"INDEX NOT NULL"`
 
- 	Email       string `xorm:"UNIQUE NOT NULL"`
 
- 	IsActivated bool
 
- 	IsPrimary   bool `xorm:"-" json:"-"`
 
- }
 
- // GetEmailAddresses returns all email addresses belongs to given user.
 
- func GetEmailAddresses(uid int64) ([]*EmailAddress, error) {
 
- 	emails := make([]*EmailAddress, 0, 5)
 
- 	if err := x.Where("uid=?", uid).Find(&emails); err != nil {
 
- 		return nil, err
 
- 	}
 
- 	u, err := GetUserByID(uid)
 
- 	if err != nil {
 
- 		return nil, err
 
- 	}
 
- 	isPrimaryFound := false
 
- 	for _, email := range emails {
 
- 		if email.Email == u.Email {
 
- 			isPrimaryFound = true
 
- 			email.IsPrimary = true
 
- 		} else {
 
- 			email.IsPrimary = false
 
- 		}
 
- 	}
 
- 	// We alway want the primary email address displayed, even if it's not in
 
- 	// the emailaddress table (yet).
 
- 	if !isPrimaryFound {
 
- 		emails = append(emails, &EmailAddress{
 
- 			Email:       u.Email,
 
- 			IsActivated: true,
 
- 			IsPrimary:   true,
 
- 		})
 
- 	}
 
- 	return emails, nil
 
- }
 
- func isEmailUsed(e Engine, email string) (bool, error) {
 
- 	if len(email) == 0 {
 
- 		return true, nil
 
- 	}
 
- 	has, err := e.Get(&EmailAddress{Email: email})
 
- 	if err != nil {
 
- 		return false, err
 
- 	} else if has {
 
- 		return true, nil
 
- 	}
 
- 	// We need to check primary email of users as well.
 
- 	return e.Where("type=?", USER_TYPE_INDIVIDUAL).And("email=?", email).Get(new(User))
 
- }
 
- // IsEmailUsed returns true if the email has been used.
 
- func IsEmailUsed(email string) (bool, error) {
 
- 	return isEmailUsed(x, email)
 
- }
 
- func addEmailAddress(e Engine, email *EmailAddress) error {
 
- 	email.Email = strings.ToLower(strings.TrimSpace(email.Email))
 
- 	used, err := isEmailUsed(e, email.Email)
 
- 	if err != nil {
 
- 		return err
 
- 	} else if used {
 
- 		return ErrEmailAlreadyUsed{email.Email}
 
- 	}
 
- 	_, err = e.Insert(email)
 
- 	return err
 
- }
 
- func AddEmailAddress(email *EmailAddress) error {
 
- 	return addEmailAddress(x, email)
 
- }
 
- func AddEmailAddresses(emails []*EmailAddress) error {
 
- 	if len(emails) == 0 {
 
- 		return nil
 
- 	}
 
- 	// Check if any of them has been used
 
- 	for i := range emails {
 
- 		emails[i].Email = strings.ToLower(strings.TrimSpace(emails[i].Email))
 
- 		used, err := IsEmailUsed(emails[i].Email)
 
- 		if err != nil {
 
- 			return err
 
- 		} else if used {
 
- 			return ErrEmailAlreadyUsed{emails[i].Email}
 
- 		}
 
- 	}
 
- 	if _, err := x.Insert(emails); err != nil {
 
- 		return fmt.Errorf("Insert: %v", err)
 
- 	}
 
- 	return nil
 
- }
 
- func (email *EmailAddress) Activate() error {
 
- 	user, err := GetUserByID(email.UID)
 
- 	if err != nil {
 
- 		return err
 
- 	}
 
- 	if user.Rands, err = GetUserSalt(); err != nil {
 
- 		return err
 
- 	}
 
- 	sess := x.NewSession()
 
- 	defer sess.Close()
 
- 	if err = sess.Begin(); err != nil {
 
- 		return err
 
- 	}
 
- 	email.IsActivated = true
 
- 	if _, err := sess.ID(email.ID).AllCols().Update(email); err != nil {
 
- 		return err
 
- 	} else if err = updateUser(sess, user); err != nil {
 
- 		return err
 
- 	}
 
- 	return sess.Commit()
 
- }
 
- func DeleteEmailAddress(email *EmailAddress) (err error) {
 
- 	if email.ID > 0 {
 
- 		_, err = x.Id(email.ID).Delete(new(EmailAddress))
 
- 	} else {
 
- 		_, err = x.Where("email=?", email.Email).Delete(new(EmailAddress))
 
- 	}
 
- 	return err
 
- }
 
- func DeleteEmailAddresses(emails []*EmailAddress) (err error) {
 
- 	for i := range emails {
 
- 		if err = DeleteEmailAddress(emails[i]); err != nil {
 
- 			return err
 
- 		}
 
- 	}
 
- 	return nil
 
- }
 
- func MakeEmailPrimary(email *EmailAddress) error {
 
- 	has, err := x.Get(email)
 
- 	if err != nil {
 
- 		return err
 
- 	} else if !has {
 
- 		return errors.EmailNotFound{Email: email.Email}
 
- 	}
 
- 	if !email.IsActivated {
 
- 		return errors.EmailNotVerified{Email: email.Email}
 
- 	}
 
- 	user := &User{ID: email.UID}
 
- 	has, err = x.Get(user)
 
- 	if err != nil {
 
- 		return err
 
- 	} else if !has {
 
- 		return errors.UserNotExist{UserID: email.UID}
 
- 	}
 
- 	// Make sure the former primary email doesn't disappear.
 
- 	formerPrimaryEmail := &EmailAddress{Email: user.Email}
 
- 	has, err = x.Get(formerPrimaryEmail)
 
- 	if err != nil {
 
- 		return err
 
- 	}
 
- 	sess := x.NewSession()
 
- 	defer sess.Close()
 
- 	if err = sess.Begin(); err != nil {
 
- 		return err
 
- 	}
 
- 	if !has {
 
- 		formerPrimaryEmail.UID = user.ID
 
- 		formerPrimaryEmail.IsActivated = user.IsActive
 
- 		if _, err = sess.Insert(formerPrimaryEmail); err != nil {
 
- 			return err
 
- 		}
 
- 	}
 
- 	user.Email = email.Email
 
- 	if _, err = sess.ID(user.ID).AllCols().Update(user); err != nil {
 
- 		return err
 
- 	}
 
- 	return sess.Commit()
 
- }
 
 
  |