1 files changed, 16 insertions, 1 deletions
diff --git a/database/user.go b/database/user.go
index 4fe7e18..cae46ae 100644
--- a/database/user.go
+++ b/database/user.go
@@ -1,6 +1,9 @@
 package database
 
-import "imageboard/models"
+import (
+	"imageboard/config"
+	"imageboard/models"
+)
 
 func GetUserByUsername(username string) (*models.User, error) {
 	var user models.User
@@ -10,6 +13,18 @@ func GetUserByUsername(username string) (*models.User, error) {
 	return &user, nil
 }
 
+func ListAllUsers() ([]models.User, error) {
+	var users []models.User
+	err := DB.Where("is_deleted = ?", false).Order("LOWER(username) ASC").Find(&users).Error
+	return users, err
+}
+
+func ListAllApprovers() ([]models.User, error) {
+	var users []models.User
+	err := DB.Where("is_deleted = ? AND level >= ?", false, config.UserLevelJanitor).Order("LOWER(username) ASC").Find(&users).Error
+	return users, err
+}
+
 func GetUserByID(userID uint) (*models.User, error) {
 	var user models.User
 	if err := DB.Where("id = ?", userID).First(&user).Error; err != nil {