source: backend/src/main/java/mk/finki/roomreservation/service/UserService.java@ 09e02d7

package mk.finki.roomreservation.service;

import mk.finki.roomreservation.model.UserOption;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService {

    private final JdbcTemplate jdbcTemplate;

    public UserService(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public List<UserOption> findAllUsers() {
        String sql = """
                SELECT
                    user_id,
                    username,
                    email,
                    full_name,
                    role
                FROM project.users
                ORDER BY user_id
                """;

        return jdbcTemplate.query(sql, (rs, rowNum) ->
                new UserOption(
                        rs.getInt("user_id"),
                        rs.getString("username"),
                        rs.getString("email"),
                        rs.getString("full_name"),
                        rs.getString("role")
                )
        );
    }

    public List<UserOption> findApprovers() {
        String sql = """
                SELECT
                    user_id,
                    username,
                    email,
                    full_name,
                    role
                FROM project.users
                WHERE role IN ('admin', 'approver')
                ORDER BY user_id
                """;

        return jdbcTemplate.query(sql, (rs, rowNum) ->
                new UserOption(
                        rs.getInt("user_id"),
                        rs.getString("username"),
                        rs.getString("email"),
                        rs.getString("full_name"),
                        rs.getString("role")
                )
        );
    }
}