Method getAllUsers

api/mysql.go:717–744

(paging bool, query string, order string, offset, limit int)

}

func (d *db) getAllUsers(paging bool, query string, order string, offset, limit int) (int, []User) {
	var (
		users = make([]User, 0)
		cnt   int
		err   error
	)
	rawSQL := fmt.Sprintf("select id, username, display_name, role, wechat, type, mail, phone, status, create_at, update_at from user")
	cntSQL := fmt.Sprintf("select count(*) from user")
	if len(query) > 0 {
		rawSQL = fmt.Sprintf("%s where username like '%%%s%%' or display_name like '%%%s%%' or phone like '%%%s%%'", rawSQL, query, query, query)
		cntSQL = fmt.Sprintf("%s where username like '%%%s%%' or display_name like '%%%s%%' or phone like '%%%s%%'", cntSQL, query, query, query)
	}
	if len(order) > 0 {
		rawSQL = fmt.Sprintf("%s order by %s", rawSQL, order)
	}
	if paging {
		rawSQL = fmt.Sprintf("%s limit %d, %d", rawSQL, offset, limit)
	}
	log.Println(rawSQL)
	log.Println(cntSQL)
	if err = d.Select(&users, rawSQL); err != nil {
		log.Println(err)
	}
	if err = d.Get(&cnt, cntSQL); err != nil {
		log.Println(err)
	}
	return cnt, users
}

// get user profile
func (d *db) getUserProfile(username string) *User {