공부방

@RestController
@RequestMapping("/team")
public class TeamController {

    private final TeamService service;

    public TeamController(TeamService service) {
        this.service = service;
    }

    @PostMapping
    public void registerTeam(@RequestBody Map<String, String> requestJson){
        service.registerTeam(requestJson.get("teamName"));
    }
}

public interface TeamRepository extends JpaRepository<Team,Long> {
    Team findByTeamName(String teamName);
    
    //팀 이름을 조회하여 있으면 true 없으면 false를 리턴
    Boolean existsByTeamName(String teamName);
}

@Service
public class TeamService {

    private final TeamRepository repository;

    public TeamService(TeamRepository repository) {
        this.repository = repository;
    }

    public void registerTeam(String teamName) {
    	//이미 있는 팀이름을 등록하는 경우 에러처리
   	//팀 이름을 키로 지정해도 같은 문제를 해결할수있을것같다.
        if(isExistTeam(teamName)){
            throw new IllegalArgumentException("이미 존재하는 팀 이름입니다: " + teamName);
        }
        repository.save(new Team(teamName));
    }
    
    private boolean isExistTeam(String name){
        return repository.existsByTeamName(name);
    }
}

@RestControllerAdvice
public class commuteServiceException {

    @ExceptionHandler(IllegalArgumentException.class)
    public ResponseEntity<String> illegalArgumentExceptionHandle(IllegalArgumentException e) {
        return ResponseEntity.badRequest().body("error : " + e.getMessage());
    }

}

//DTO
public class TeamSetDto {
    private String teamName;
    private Integer leaderCode; // 팀장의 이름이나 id 둘중의 하나만 가지면 될것같음
    //private String leaderName;
}

//jpa를 통해서 id 나 이름이 있다면 직원정보를 조회할수있기때문에 두개중에 하나만있다면 
//조회해서 다른정보를 불러서 사용이 가능하다.

//Controller
@PostMapping("/setLeader")
public void setTeamLeader(@RequestBody TeamSetDto request){
    service.registerTeamLeader(request);
}

//Service
@Transactional
    public void registerTeamLeader(TeamSetDto request) {
        Team team = repository.findByTeamName(request.getTeamName());
        team.setTeamLeader(request.getLeaderCode());
    }
    
//팀원의 이름이나 정보로조회해서 저장하는경우.
@Transactional
    public void registerTeamLeader(TeamSetDto request) {
        Team team = repository.findByTeamName(request.getTeamName());
        Employee employee = memberRepository.findByName(request.getName());
        team.setTeamLeader(employee.getId());
    }

//DTO
@Getter
@AllArgsConstructor // Jpa매핑용 , 모든파라미터생성자
public class TeamResponse {
    private String name;
    private String manager;
    private Long count;
}

//Controller
@GetMapping
public List<TeamResponse> getTeam(){
    return service.getTeam();
}

//Service
public List<TeamResponse> getTeam(){
        return repository.getAllTeam();
    }
    
//Repository
// Jpql사용
@Query("SELECT new Company.demo.commute.dto.response.TeamResponse(a.teamName, b.name, COUNT(c.id)) " +
                  "FROM Team a " +
                  "LEFT JOIN Employee b ON a.teamLeader = b " +
                  "LEFT JOIN Employee c ON a.teamId = c.team.teamId " +
                  "GROUP BY a.teamName, b.name")
    List<TeamResponse> getAllTeam();

@Entity
@Getter
@NoArgsConstructor
public class Team {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long teamId;
    
    private String teamName;
    
    @OneToOne
    @JoinColumn(name = "team_leader_id")
    private Employee teamLeader;
    //private Integer teamLeaderId;
    
    private Integer annualLeaveBefore;

    @OneToMany(mappedBy = "team")
    private List<Employee> employeeList;

    public Team(String positionName) {
        this.teamName = positionName;
    }

    public void setTeamLeader(Employee leader) {
        this.teamLeader = leader;
    }
    // public void setTeamLeader(Integer leaderCode){
    //  this.teamLeaderId = leaderCode;
    // }
}