$$config title: OGYM 프로젝트 기술서 keywords: - IT - ... $$ # ? 개요 ## ? 소개 **헬스인들을 위한 종합 커뮤니티 서비스입니다.** - 스프링 시큐리티를 통한 회원가입 및 권한 처리 - 이메일 인증, 소셜 계정 연결 및 로그인 기능 - 게시판 질문, 답글, 댓글, 대댓글 CRUD 기능 - 트레이너 정보 CRUD 기능 (이미지 파일 업로드 포함) - 카테고리, 정렬, 검색 기능 - 주소 및 지도 API 도입 ## ? 관련 링크 - 서비스: [https://ogym.one](https://ogym.one) - 레포지토리: [https://github.com/pintordev/OGYM](https://github.com/pintordev/OGYM) ## ?‍?‍?‍? 프로젝트 팀 **김호현** - email: pintor.dev@gmail.com - github: [https://github.com/pintordev](https://github.com/pintordev) - youtube: [https://www.youtube.com/@pintor.dev_study-log](https://www.youtube.com/@pintor.dev_study-log) **오길환** - email: ohgilhwan1957@gmail.com - github: [https://github.com/ohgil](https://github.com/ohgil) - youtube: [https://www.youtube.com/@user-sg2qz8kv1x](https://www.youtube.com/@user-sg2qz8kv1x) **최기범** - email: taecoo3@naver.com - github: [https://github.com/osoreee3](https://github.com/osoreee3) - youtube: [https://www.youtube.com/@osoree-vlog](https://www.youtube.com/@osoree-vlog) **문창빈** - email: vv4704@gmail.com - github: [https://github.com/MunChangBin](https://github.com/MunChangBin) - youtube: [https://www.youtube.com/@user-bv7vi1mn2p](https://www.youtube.com/@user-bv7vi1mn2p) ## ? 프로젝트 관리 - 트렐로: [https://trello.com/b/ehBlIb74/ogym-중급프로젝트](https://trello.com/b/ehBlIb74/ogym-중급프로젝트) ![img](https://i.imgur.com/7qNZSRR.jpg) # ? 개발 환경 ## ? 형상 관리 ``` - Git - GitHub ``` ## ? 기술 스택 ``` - JAVA - SpringBoot - Spring Security - Spring Data JPA - Oauth 2.0 - Thymeleaf - HTML5 - CSS3 - JavaScript - jQuery - Ajax - MariaDB ``` ## ? 개발 도구 ``` - IntelliJ - Gradle - DBeaver ``` ## ? 배포 환경 ``` - Google Domains - Naver Cloud Platform - CentOS - Termius - Docker - Nginx Proxy Manager - Jenkins CI / CD ``` # ? 요구 사항 정의서 | 목록 | 요구사항 | 이용대상 | 기능종류 | 구현여부 | 비고 | | ------- | --------------------------------------------------------- | ------------- | ---------- | -------- | ---- | | RQ-001 | 자체 회원가입이 가능하다 | 모든 유저 | 회원가입 | ✅ | 아이디(영문 대소문자, 숫자 조합 4~20자리), 비밀번호(영문 대소문자, 숫자, 특수문자 조합 8~30자리. 각 1개 이상 필수)비밀번호확인, 닉네임(한글, 영문 대소문자, 숫자 조합 2~15자리), 이름(한글, 영문만 입력가능), 휴대폰번호, 생년월일(YYYY-MM-DD), 주소, 이메일, 발송된 인증번호 입력 후 회원가입 가능. ajax를 통해 아이디, 닉네임, 휴대폰번호, 이메일 중복유무를 확인한다 | RQ-002 | 이메일 인증이 가능하다 | 모든 유저 | 회원가입 | ✅ | 입력한 이메일로 영문 대소문자, 숫자 랜덤 8자리 발송 | RQ-003 | 자체 로그인이 가능하다 | 회원 | 로그인 | ✅ | 아이디, 비밀번호를 입력하면 로그인 처리 후 메인페이지로 이동 | RQ-004 | 소셜 로그인이 가능하다 | 회원 | 로그인 | ✅ | 페이스북, 인스타 인증문제로 카카오톡, 네이버, 구글만 구현, 로그인 후 마이페이지에서 소셜 아이콘을 클릭해 활성화되면 소셜 로그인 가능 | RQ-005 | 아이디 찾기가 가능하다 | 회원 | 로그인 | ✅ | 회원가입 시 입력한 이메일을 입력하면 현재창에서 아이디를 출력한다 | RQ-006 | 비밀번호 찾기가 가능하다 | 회원 | 로그인 | ✅ | 회원가입 시 입력한 이메일, 아이디를 입력하면 임시비밀번호가 메일로 발송되며, 기존 비밀번호에서 임시비밀번호로 변경 | RQ-007 | 페이지 상단에는 네비게이션 바를 구현하고 좌측부터 로고 커뮤니티, 트레이너가 있고 우측에는 로그인 관련 버튼이 있다. | 모든 유저 | 레이아웃 | ✅ | 로고를 클릭하면 메인페이지로 이동한다 | RQ-008 | 페이지 하단에는 상호명을 포함한 사업자 정보를 표시한다 | 모든 유저 | 레이아웃 | ✅ | | RQ-009 | 상단에는 이미지 배너가 있다 | 모든 유저 | 메인 페이지 | ✅ | 슬라이딩 이미지바 생성 | RQ-010 | 중단 좌측에는 Best 게시글이 출력된다 | 모든 유저 | 메인 페이지 | ✅ | 최다 추천 게시글 | RQ-011 | 중단 우측에는 최신글이 출력된다 | 모든 유저 | 메인 페이지 | ✅ | | RQ-012 | 자주 묻는 질문을 출력한다 | 모든 유저 | 자주 묻는 질문 | ✅ | | RQ-013 | 게시글 등록이 가능하다 | 회원 | 게시글 | ✅ | 카테고리, 제목, 내용 입력 후 등록 | RQ-014 | 게시글에 답글 등록이 가능하다 | 회원 | 게시글 | ✅ | | RQ-015 | 답글에 댓글 등록이 가능하다 | 회원 | 게시글 | ✅ | | RQ-016 | 게시글을 추천할 수 있다 | 회원 | 게시글 | ✅ | | RQ-017 | 답글을 추천할 수 있다 | 회원 | 게시글 | ✅ | | RQ-018 | 댓글을 추천할 수 있다 | 회원 | 게시글 | ✅ | | RQ-019 | 게시글은 최신순으로 정렬 되어있다 | 모든 유저 | 게시글 | ✅ | 번호, 분류, 제목[댓글 개수], 작성자, 작성 시간, 조회수, 추천수. 작성시간은 방금 전(1분 미만), $분 전(1시간 미만), $분 전(1시간 미만), $시간 전(1일 미만), $일 전(일주일 미만), 이외는 날짜만 표기 | RQ-020 | 게시글 출력 수를 설정할 수 있다 | 모든 유저 | 게시글 | ✅ | 기본 20개씩으로 설정. 50개씩, 100개씩으로 변경 가능 | RQ-021 | 페이징 버튼을 클릭하면 해당 페이지로 이동할 수 있다 | 모든 유저 | 게시글 | ✅ | 처음, 10페이지 이전, 이전, 현재 페이지, 다음, 10페이지 다음, 끝 | RQ-022 | 카테고리를 선택하면 해당 카테고리 게시글로 정렬할 수 있다 | 모든 유저 | 게시글 | ✅ | | RQ-023 | 게시글을 추천수로 내림차순 정렬할 수 있다 | 모든 유저 | 게시글 | ✅ | | RQ-024 | 게시글을 댓글수로 내림차순 정렬할 수 있다 | 모든 유저 | 게시글 | ✅ | | RQ-025 | 게시글 제목으로 검색이 가능하다 | 모든 유저 | 게시글 | ✅ | | RQ-026 | 게시글 내용으로 검색이 가능하다 | 모든 유저 | 게시글 | ✅ | | RQ-027 | 게시글 제목이나 내용과 일치하는 조건으로 검색할 수 있다 | 모든 유저 | 게시글 | ✅ | | RQ-028 | 게시글 작성자로 검색이 가능하다 | 모든 유저 | 게시글 | ✅ | | RQ-029 | 게시글 답글 내용으로 검색이 가능하다 | 모든 유저 | 게시글 | ✅ | | RQ-030 | 게시글을 작성한 작성자가 본인이 작성한 게시글을 수정할 수 있다 | 회원 | 게시글 | ✅ | | RQ-031 | 게시글을 작성한 작성자가 본인이 작성한 게시글을 삭제할 수 있다 | 회원 | 게시글 | ✅ | | RQ-032 | 답글을 작성한 작성자가 본인이 작성한 게시글을 수정할 수 있다 | 회원 | 게시글 | ✅ | | RQ-033 | 답글을 작성한 작성자가 본인이 작성한 게시글을 삭제할 수 있다 | 회원 | 게시글 | ✅ | | RQ-034 | 댓글을 작성한 작성자가 본인이 작성한 게시글을 수정할 수 있다 | 회원 | 게시글 | ✅ | | RQ-035 | 댓글을 작성한 작성자가 본인이 작성한 게시글을 삭제할 수 있다 | 회원 | 게시글 | ✅ | | RQ-036 | 트레이너 등록이 가능하다 | 회원 | 트레이너 | ✅ | 이름(회원가입 시 입력한 이름으로 자동 입력), 소속센터, 성별, 주소, 프로필 사진, 간략한 소개, 자세한 소개, 트레이닝 종목, 레슨 비용, 자격증, 연락처(SNS, 휴대폰번호 등)을 입력 후 트레이너 등록 가능 | RQ-037 | 트레이너 리스트는 최신순으로 정렬 되어있다 | 모든 유저 | 트레이너 | ✅ | 트레이너 이름, 소속센터, 주소(구까지 표기), 프로필 사진, 간략한 소개, 트레이닝 종목, 레슨 비용 | RQ-038 | 트레이닝 종목을 선택하면 해당 트레이너로 정렬할 수 있다 | 모든 유저 | 트레이너 | ✅ | | RQ-039 | 트레이너의 지역으로 검색이 가능하다 | 모든 유저 | 트레이너 | ✅ | | RQ-040 | 트레이너의 소속으로 검색이 가능하다 | 모든 유저 | 트레이너 | ✅ | | RQ-041 | 트레이너의 이름으로 검색이 가능하다 | 모든 유저 | 트레이너 | ✅ | | RQ-042 | 회원의 간단 정보를 출력한다 | 회원 | 마이페이지 | ✅ | 아이디, 닉네임, 가입일, 최근 로그인 시간 | RQ-043 | 소셜 로그인을 활성화 할 수 있다 | 회원 | 마이페이지 | ✅ | | RQ-044 | 닉네임 변경을 할 수 있다 | 회원 | 마이페이지 | ✅ | 회원가입 유효성 검사 동일 | RQ-045 | 비밀번호 변경을 할 수 있다 | 회원 | 마이페이지 | ✅ | 회원가입 유효성 검사 동일 | RQ-046 | 회원의 정보를 출력한다 | 회원 | 마이페이지 | ✅ | | RQ-047 | 회원이 작성한 게시물 제목을 출력하고 선택하면 해당 게시글로 이동한다 | 회원 | 마이페이지 | ✅ | | RQ-048 | 회원이 작성한 답글을 출력하고 선택하면 해당 게시글로 이동한다 | 회원 | 마이페이지 | ✅ | | RQ-049 | 회원이 작성한 댓글을 출력하고 선택하면 해당 게시글로 이동한다 | 회원 | 마이페이지 | ✅ | # ? ERD 구성 ![img](https://i.imgur.com/p38ceJD.png) # ? 페이지 별 동작 화면 및 소스 코드 ## ? 메인페이지 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/Xftidog.jpg)
### ? 소스 코드 --- - index.html ```html

Best 게시글

" + code + "

"; content += "

"; helper.setTo(email); helper.setSubject(title); helper.setText(content, true); javaMailSender.send(mimeMessage); } catch (MessagingException e) { // 예외 처리 e.printStackTrace(); } } public static void main(String[] args) { // JavaMailSender 구현체를 생성하고 필요한 정보를 설정 JavaMailSender javaMailSender = createJavaMailSender(); // UserEmailService 인스턴스 생성 UserEmailService userEmailService = new UserEmailService(javaMailSender); // HTML 형식의 이메일 전송 String email = "example@example.com"; String type = "이메일 인증"; String code = "ABC123"; // 이메일 인증 코드 String type2=""; userEmailService.mailSend(email, type, type2, code); } // JavaMailSender 구현체 생성 private static JavaMailSender createJavaMailSender() { // JavaMailSenderImpl 인스턴스 생성 JavaMailSenderImpl mailSender = new JavaMailSenderImpl(); // 필요한 정보 설정 mailSender.setHost("your-mail-server-host"); mailSender.setPort(587); mailSender.setUsername("your-username"); mailSender.setPassword("your-password"); // 추가적인 설정 (옵션) Properties properties = new Properties(); properties.put("mail.transport.protocol", "smtp"); properties.put("mail.smtp.auth", "true"); properties.put("mail.smtp.starttls.enable", "true"); properties.put("mail.debug", "true"); mailSender.setJavaMailProperties(properties); return mailSender; } } ``` - EmailConfig.java ```java @Configuration public class EmailConfig { private final Logger logger = LoggerFactory.getLogger(this.getClass()); public EmailConfig() throws IOException { logger.info("EmailConfig.java constructor called"); } @Value("${spring.mail.transport.protocol}") private String protocol; @Value("${spring.mail.properties.mail.smtp.auth}") private boolean auth; @Value("${spring.mail.properties.mail.smtp.starttls.enable}") private boolean starttls; @Value("${spring.mail.debug}") private boolean debug; @Value("${spring.mail.host}") private String host; @Value("${spring.mail.port}") private int port; @Value("${spring.mail.username}") private String username; @Value("${spring.mail.password}") private String password; @Value("${spring.mail.default.encoding}") private String encoding; @Bean public JavaMailSender javaMailSender(){ JavaMailSenderImpl mailSender = new JavaMailSenderImpl(); Properties properties = new Properties(); properties.put("mail.transport.protocol", protocol); properties.put("mail.smtp.auth", auth); properties.put("mail.smtp.starttls.enable", starttls); properties.put("mail.smtp.debug", debug); mailSender.setHost(host); mailSender.setUsername(username); mailSender.setPassword(password); mailSender.setPort(port); mailSender.setJavaMailProperties(properties); mailSender.setDefaultEncoding(encoding); return mailSender; } } ```
## ? 로그인 페이지 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/D3MG7Nr.png)
### ? 소스 코드 --- - login_form.html ```html

oGym

``` - UserController.java ```java @GetMapping("/login") public String login(HttpServletRequest request, Model model, @RequestParam(value = "error", defaultValue = "") String error, @RequestParam(value = "exception", defaultValue = "") String exception) { String uri = request.getHeader("Referer"); if (uri != null && !uri.contains("/login")) { request.getSession().setAttribute("prevPage", uri); } return "login"; } @GetMapping("/login/authenticate") @ResponseBody public String idAndPasswordAuthenticate(@RequestParam("loginId") String loginId, @RequestParam("password") String password) { if (this.userService.authenticateLoginIdAndPassword(loginId, password)) { return ""; } else { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "아이디, 비밀번호를 다시 확인해주세요"); } } @GetMapping("/log/loginDate") public String loginDate(Principal principal) { SiteUser user = this.userService.getUser(principal.getName()); this.userService.updateLoginDate(user); return "redirect:/"; } @GetMapping("/find") public String findUser() { return "user_find"; } //아이디찾기, 비밀번호 찾기 둘다 쓸 수 있도록 만듬 @PostMapping("/find") @ResponseBody //프론트에서 받아온 email, loginId 값을 담아온다 public String findUser(@RequestParam(value = "email", required = false) String email, @RequestParam(value = "loginId", required = false) String loginId) { try { //아이디찾기 loginId만 입력됐을때 없는경우 아이디만 반환하도록 진행 if (email != null && loginId == null) { SiteUser user = userService.getUserByEmail(email); return user.getLoginId(); //비밀번호찾기 email, loginId 둘다 값이 있을 경우 로직 } else if (email != null && loginId != null) { SiteUser user = userService.getUserByLoginAndEmail(loginId, email); if (user != null) { String tempPassword = userService.genConfirmCode(8); //임시 비밀번호 발송, 이후 기존 비밀번호를 임시비밀번호로 교체하는것도 추가해야함 this.userEmailService.mailSend(email, "임시 비밀번호 발송", "임시 비밀번호", tempPassword); System.out.println(tempPassword); this.userService.modifyPassword(tempPassword, user); return "임시 비밀번호를 이메일로 발송했습니다."; } else { return ""; } } else { return ""; } } catch (DataNotFoundException e) { return ""; } } @PreAuthorize("isAuthenticated()") @GetMapping("/modify/password") public String modifyPassword(UserPasswordForm userPasswordForm) { return "modify_password_form"; } @PreAuthorize("isAuthenticated()") @PostMapping("/modify/password") public String modifyPassword(@Valid UserPasswordForm userPasswordForm, BindingResult bindingResult, Principal principal) { if (bindingResult.hasErrors()) { return "modify_password_form"; } SiteUser user = this.userService.getUser(principal.getName()); if (!this.userService.confirmPassword(userPasswordForm.getPresentPW(), user)) { bindingResult.rejectValue("presentPW", "passwordInCorrect", "현재 비밀번호를 바르게 입력해주세요."); return "modify_password_form"; } // 비밀번호와 비밀번호 확인에 입력한 문자열이 서로 다르면 다시 입력 하도록 if (!userPasswordForm.getNewPW1().equals(userPasswordForm.getNewPW2())) { bindingResult.rejectValue("newPW2", "passwordInCorrect", "입력한 비밀번호가 일치하지 않습니다."); return "modify_password_form"; } userService.modifyPassword(userPasswordForm.getNewPW1(), user); return "redirect:/user/logout"; } @PreAuthorize("isAuthenticated()") @GetMapping("/modify/nickname") public String modifyNickname() {return "modify_nickname_form"; } @PreAuthorize("isAuthenticated()") @PostMapping("/modify/nickname") public String modifyNickname(@RequestParam("newNickname") String newNickname, Principal principal) { SiteUser user = this.userService.getUser(principal.getName()); System.out.println(newNickname); if (newNickname.matches(".*[ㄱ-ㅎㅏ-ㅣ!\"#$%&'()*+,-./:;<=>?@\\[\\\\\\]^_`{|}~\\s]+.*")) { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "사용할 수 없는 닉네임입니다."); } if (!this.userService.isNickNameDuplicate(newNickname)) { // 닉네임 변경 로직 추가 user.setNickname(newNickname); this.userService.modifyNickname(newNickname, user); return "redirect:/user/mypage"; } else { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "사용중인 닉네임입니다."); } } @GetMapping("/modify/nickname-check") @ResponseBody public String modifyNicknameCheck(@RequestParam("newNickname") String newNickname, Principal principal) { SiteUser user = this.userService.getUser(principal.getName()); if (newNickname.matches(".*[ㄱ-ㅎㅏ-ㅣ!\"#$%&'()*+,-./:;<=>?@\\[\\\\\\]^_`{|}~\\s]+.*")) { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "사용할 수 없는 닉네임입니다."); } if (!this.userService.isNickNameDuplicate(newNickname)) { return "사용 가능한 닉네임입니다."; } else { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "사용중인 닉네임입니다."); } } @GetMapping("/mypage") public String myPage(Model model, Principal principal, @RequestParam(value = "section", defaultValue = "information") String section, @RequestParam(value = "bPage", defaultValue = "0") int bPage, @RequestParam(value = "cPage", defaultValue = "0") int cPage, @RequestParam(value = "rPage", defaultValue = "0") int rPage) { SiteUser user = this.userService.getUserByLoginId(principal.getName()); model.addAttribute("user", user); List socialLinked = new ArrayList<>(); for (Oauth2Account socialAccount : user.getSocialAccount()) { socialLinked.add(socialAccount.getProvider()); } model.addAttribute("socialLinked", socialLinked); Page boardPaging = this.boardService.getListByUser(bPage, user); model.addAttribute("boardPaging", boardPaging); Page commentPaging = this.commentService.getListByUser(cPage, user); model.addAttribute("commentPaging", commentPaging); Page reCommentPaging = this.reCommentService.getListByUser(rPage, user); model.addAttribute("reCommentPaging", reCommentPaging); model.addAttribute("section", section); model.addAttribute("bPage", bPage); model.addAttribute("cPage", cPage); model.addAttribute("rPage", rPage); return "my_page"; } } ``` - UserSecurityService.java ```java @RequiredArgsConstructor @Service public class UserSecurityService implements UserDetailsService { private final UserRepository userRepository; @Override public UserDetails loadUserByUsername(String loginId) throws UsernameNotFoundException { Optional _siteUser = this.userRepository.findByLoginId(loginId); if (_siteUser.isEmpty()) { throw new UsernameNotFoundException("사용자를 찾을 수 없습니다."); } SiteUser siteUser = _siteUser.get(); List authorityList = new ArrayList<>(); authorityList.add(new SimpleGrantedAuthority(siteUser.getAuthority().getValue())); return new User(siteUser.getLoginId(), siteUser.getPassword(), authorityList); } } ``` - UserRole.java ```java @Getter public enum UserRole { ADMIN("admin"), COMMUNITY_MANAGER("community manager"), TRAINER("trainer"), SELLER("seller"), USER("user"); private final String value; UserRole(String value) { this.value = value; } public String getValue() { return value; } } ``` - UserService.java ```java public String genConfirmCode(int length) { String candidateCode = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"; SecureRandom secureRandom = new SecureRandom(); String code = ""; for (int i = 0; i < length; i++) { int index = secureRandom.nextInt(candidateCode.length()); code += candidateCode.charAt(index); } return code; } public SiteUser getUser(String loginId) { Optional siteUser = this.userRepository.findByLoginId(loginId); if (siteUser.isPresent()) { return siteUser.get(); } else { throw new DataNotFoundException("siteuser not found"); } } //email 값으로 데이터베이스에서 siteuser 조회하려는 기능 public SiteUser getUserByEmail(String email) { Optional siteUser = this.userRepository.findByEmail(email); if (siteUser.isPresent()) { return siteUser.get(); } else { throw new DataNotFoundException("siteuser not found"); } } //loginId 값으로 데이터베이스에서 user 조회하려는 기능 public SiteUser getUserByLoginId(String loginId) { Optional _siteUser = this.userRepository.findByLoginId(loginId); if (_siteUser.isPresent()) { return _siteUser.get(); } else { throw new DataNotFoundException("user not found"); } } //loginId + email 값으로 데이터베이스에서 siteuser 조회하려는 기능 public SiteUser getUserByLoginAndEmail(String loginId, String email) { return this.userRepository.findByLoginIdAndEmail(loginId, email); } public void modifyPassword(String password, SiteUser user) { user.setPassword(passwordEncoder.encode(password)); this.userRepository.save(user); } public void modifyNickname(String newNickname, SiteUser user) { user.setNickname(newNickname); this.userRepository.save(user); } public boolean confirmCertificationCode(String inputCode, String genCode) { return passwordEncoder.matches(inputCode, genCode); } public boolean confirmPassword(String password, SiteUser user) { return passwordEncoder.matches(password, user.getPassword()); } public void updateLoginDate(SiteUser user) { user.setLastLoginDate(LocalDateTime.now()); this.userRepository.save(user); } ``` - UserRepository.java ```java public interface UserRepository extends JpaRepository { Optional findByusername(String username); } ```
- GoogleUserInfo.java ```java @AllArgsConstructor public class GoogleUserInfo implements OAuth2UserInfo { private Map attributes; @Override public String getProviderId() { return (String) attributes.get("sub"); } @Override public String getProvider() { return "google"; } @Override public String getEmail() { return (String) attributes.get("email"); } @Override public String getName() { return (String) attributes.get("name"); } } ``` - GoogleOauth.java ```java @Component @RequiredArgsConstructor public class GoogleOauth2 implements SocialOauth2 { @Value("${custom.google.authorization-uri}") private String authorizationUri; @Value("${spring.security.oauth2.client.registration.google.client-id}") private String clientId; @Value("${spring.security.oauth2.client.registration.google.client-secret}") private String clientSecret; @Value("${custom.google.redirect-uri-code}") private String redirectUriCode; @Value("${custom.google.token-uri}") private String tokenUri; @Value("${custom.google.user-info-uri}") private String userInfoUri; @Override public String getRedirectUrlCode() { Map params = new HashMap<>(); params.put("scope", "email profile"); params.put("access_type", "offline"); params.put("include_granted_scopes", "true"); params.put("response_type", "code"); params.put("state", "state_parameter_passthrough_value"); params.put("redirect_uri", redirectUriCode); params.put("client_id", clientId); String paramsString = params.entrySet().stream() .map(x -> x.getKey() + "=" + x.getValue()) .collect(Collectors.joining("&")); return authorizationUri + "?" + paramsString; } @Override public String getAccessToken(String code, String state) { RestTemplate restTemplate = new RestTemplate(); HttpHeaders httpHeaders = new HttpHeaders(); MultiValueMap params = new LinkedMultiValueMap<>(); params.set("code", code); params.set("client_id", clientId); params.set("client_secret", clientSecret); params.set("redirect_uri", redirectUriCode); params.set("grant_type", "authorization_code"); HttpEntity> restRequest = new HttpEntity<>(params, httpHeaders); ResponseEntity responseEntity = restTemplate.postForEntity(tokenUri, restRequest, JSONObject.class); if (responseEntity.getStatusCode() == HttpStatus.OK) { return (String) responseEntity.getBody().get("access_token"); } return ""; } @Override public Map getUserAttribute(String accessToken) { RestTemplate restTemplate = new RestTemplate(); HttpHeaders httpHeaders = new HttpHeaders(); httpHeaders.add("Authorization", "Bearer " + accessToken); HttpEntity> restRequest = new HttpEntity<>(httpHeaders); System.out.println("들어옴"); ResponseEntity responseEntity = restTemplate.exchange(userInfoUri, HttpMethod.GET, restRequest, JSONObject.class); if (responseEntity.getStatusCode() == HttpStatus.OK) { Map userAttributes = new HashMap<>(); userAttributes.put("provider", "google"); userAttributes.put("providerId", responseEntity.getBody().get("id")); userAttributes.put("email", responseEntity.getBody().get("email")); userAttributes.put("name", responseEntity.getBody().get("name")); return userAttributes; } return new HashMap<>(); } } ``` - Oauth2Controller.java ```java @Slf4j @RequestMapping("/user/oauth2") @RequiredArgsConstructor @Controller public class Oauth2AccountController { private final Oauth2AccountService oauth2AccountService; private final UserService userService; @PreAuthorize("isAuthenticated") @GetMapping("/{socialType}") public void requestCode(@PathVariable("socialType") String socialType, HttpServletResponse response) { String redirectUri = this.oauth2AccountService.getRedirectUrlCode(socialType); log.info(socialType + "redirectUri: " + redirectUri); try { response.sendRedirect(redirectUri); } catch (IOException e) { e.printStackTrace(); } } @PreAuthorize("isAuthenticated") @GetMapping("/code/{socialType}") public String createOauth2Account(@PathVariable("socialType") String socialType, @RequestParam(value = "code") String code, @RequestParam(value = "state", defaultValue = "") String state, Principal principal) { log.info(socialType + "code: " + code); log.info(socialType + "state: " + state); String accessToken = this.oauth2AccountService.getAccessToken(socialType, code, state); log.info(socialType + "accessToken: " + accessToken); Map userAttributes = this.oauth2AccountService.getUserAttribute(socialType, accessToken); log.info(socialType + "userAttributes: " + userAttributes); SiteUser parent = this.userService.getUserByLoginId(principal.getName()); String provider = (String) userAttributes.get("provider"); String providerId = (String) userAttributes.get("providerId"); String email = (String) userAttributes.get("email"); String name = (String) userAttributes.get("name"); this.oauth2AccountService.create(provider, providerId, email, name, parent); return "redirect:/user/mypage"; } } ``` - Oauth2AccountService.java ```java @RequiredArgsConstructor @Service public class Oauth2AccountService { private final Oauth2AccountRepository oauth2AccountRepository; private final GoogleOauth2 googleOauth2; private final KaKaoOauth2 kaKaoOauth2; private final NaverOauth2 naverOauth2; public String getRedirectUrlCode(String socialType) { if (socialType.equals("google")) { return this.googleOauth2.getRedirectUrlCode(); } else if (socialType.equals("kakao")) { return this.kaKaoOauth2.getRedirectUrlCode(); } else if (socialType.equals("naver")) { return this.naverOauth2.getRedirectUrlCode(); } else { throw new IllegalArgumentException("알 수 없는 소셜 로그인 타입입니다."); } } public String getAccessToken(String socialType, String code, String state) { if (socialType.equals("google")) { return this.googleOauth2.getAccessToken(code, state); } else if (socialType.equals("kakao")) { return this.kaKaoOauth2.getAccessToken(code, state); } else if (socialType.equals("naver")) { return this.naverOauth2.getAccessToken(code, state); } else { throw new IllegalArgumentException("알 수 없는 소셜 로그인 타입입니다."); } } public Map getUserAttribute(String socialType, String accessToken) { if (socialType.equals("google")) { return this.googleOauth2.getUserAttribute(accessToken); } else if (socialType.equals("kakao")) { return this.kaKaoOauth2.getUserAttribute(accessToken); } else if (socialType.equals("naver")) { return this.naverOauth2.getUserAttribute(accessToken); } else { throw new IllegalArgumentException("알 수 없는 소셜 로그인 타입입니다."); } } public void create(String provider, String providerId, String email, String name, SiteUser parent) { Oauth2Account socialAccount = new Oauth2Account(); socialAccount.setProvider(provider); socialAccount.setProviderId(providerId); socialAccount.setEmail(email); socialAccount.setName(name); socialAccount.setParent(parent); this.oauth2AccountRepository.save(socialAccount); } } ``` - KaKaoUserInfo.java ```java @Component @RequiredArgsConstructor public class KaKaoOauth2 implements SocialOauth2 { @Value("${spring.security.oauth2.client.provider.kakao.authorization-uri}") private String authorizationUri; @Value("${spring.security.oauth2.client.registration.kakao.client-id}") private String clientId; @Value("${spring.security.oauth2.client.registration.kakao.redirect-uri-code}") private String redirectUriCode; @Value("${spring.security.oauth2.client.provider.kakao.token-uri}") private String tokenUri; @Value("${spring.security.oauth2.client.provider.kakao.user-info-uri}") private String userInfoUri; @Override public String getRedirectUrlCode() { Map params = new HashMap<>(); params.put("response_type", "code"); params.put("client_id", clientId); params.put("redirect_uri", redirectUriCode); String paramsString = params.entrySet().stream() .map(x -> x.getKey() + "=" + x.getValue()) .collect(Collectors.joining("&")); return authorizationUri + "?" + paramsString; } @Override public String getAccessToken(String code, String state) { RestTemplate restTemplate = new RestTemplate(); HttpHeaders httpHeaders = new HttpHeaders(); MultiValueMap params = new LinkedMultiValueMap<>(); params.set("grant_type", "authorization_code"); params.set("client_id", clientId); params.set("redirect_uri", redirectUriCode); params.set("code", code); HttpEntity> restRequest = new HttpEntity<>(params, httpHeaders); ResponseEntity responseEntity = restTemplate.postForEntity(tokenUri, restRequest, JSONObject.class); if (responseEntity.getStatusCode() == HttpStatus.OK) { return (String) responseEntity.getBody().get("access_token"); } return ""; } @Override public Map getUserAttribute(String accessToken) { RestTemplate restTemplate = new RestTemplate(); HttpHeaders httpHeaders = new HttpHeaders(); httpHeaders.add("Authorization", "Bearer " + accessToken); HttpEntity> restRequest = new HttpEntity<>(httpHeaders); ResponseEntity responseEntity = restTemplate.exchange(userInfoUri, HttpMethod.GET, restRequest, JSONObject.class); if (responseEntity.getStatusCode() == HttpStatus.OK) { Map userAttributes = new HashMap<>(); userAttributes.put("provider", "kakao"); userAttributes.put("providerId", responseEntity.getBody().get("id").toString()); Map kakaoAccount = (Map) responseEntity.getBody().get("kakao_account"); userAttributes.put("email", kakaoAccount.get("email")); Map properties = (Map) responseEntity.getBody().get("properties"); userAttributes.put("name", properties.get("nickname")); return userAttributes; } return new HashMap<>(); } } ``` - KaKaoOauth.java ```java @Component @RequiredArgsConstructor public class KaKaoOauth2 implements SocialOauth2 { @Value("${spring.security.oauth2.client.provider.kakao.authorization-uri}") private String authorizationUri; @Value("${spring.security.oauth2.client.registration.kakao.client-id}") private String clientId; @Value("${spring.security.oauth2.client.registration.kakao.redirect-uri-code}") private String redirectUriCode; @Value("${spring.security.oauth2.client.provider.kakao.token-uri}") private String tokenUri; @Value("${spring.security.oauth2.client.provider.kakao.user-info-uri}") private String userInfoUri; @Override public String getRedirectUrlCode() { Map params = new HashMap<>(); params.put("response_type", "code"); params.put("client_id", clientId); params.put("redirect_uri", redirectUriCode); String paramsString = params.entrySet().stream() .map(x -> x.getKey() + "=" + x.getValue()) .collect(Collectors.joining("&")); return authorizationUri + "?" + paramsString; } @Override public String getAccessToken(String code, String state) { RestTemplate restTemplate = new RestTemplate(); HttpHeaders httpHeaders = new HttpHeaders(); MultiValueMap params = new LinkedMultiValueMap<>(); params.set("grant_type", "authorization_code"); params.set("client_id", clientId); params.set("redirect_uri", redirectUriCode); params.set("code", code); HttpEntity> restRequest = new HttpEntity<>(params, httpHeaders); ResponseEntity responseEntity = restTemplate.postForEntity(tokenUri, restRequest, JSONObject.class); if (responseEntity.getStatusCode() == HttpStatus.OK) { return (String) responseEntity.getBody().get("access_token"); } return ""; } @Override public Map getUserAttribute(String accessToken) { RestTemplate restTemplate = new RestTemplate(); HttpHeaders httpHeaders = new HttpHeaders(); httpHeaders.add("Authorization", "Bearer " + accessToken); HttpEntity> restRequest = new HttpEntity<>(httpHeaders); ResponseEntity responseEntity = restTemplate.exchange(userInfoUri, HttpMethod.GET, restRequest, JSONObject.class); if (responseEntity.getStatusCode() == HttpStatus.OK) { Map userAttributes = new HashMap<>(); userAttributes.put("provider", "kakao"); userAttributes.put("providerId", responseEntity.getBody().get("id").toString()); Map kakaoAccount = (Map) responseEntity.getBody().get("kakao_account"); userAttributes.put("email", kakaoAccount.get("email")); Map properties = (Map) responseEntity.getBody().get("properties"); userAttributes.put("name", properties.get("nickname")); return userAttributes; } return new HashMap<>(); } } ``` - NaverUserInfo.java ```java @AllArgsConstructor public class NaverUserInfo implements OAuth2UserInfo{ private Map attributes; @Override public String getProviderId() { return (String) attributes.get("id"); } @Override public String getProvider() { return "naver"; } @Override public String getEmail() { return (String) attributes.get("email"); } @Override public String getName() { return (String) attributes.get("name"); } } ``` - NaverOauth.java ```java @Component @RequiredArgsConstructor public class NaverOauth2 implements SocialOauth2 { private final UserService userService; @Value("${spring.security.oauth2.client.provider.naver.authorization-uri}") private String authorizationUri; @Value("${spring.security.oauth2.client.registration.naver.client-id}") private String clientId; @Value("${spring.security.oauth2.client.registration.naver.client-secret}") private String clientSecret; @Value("${spring.security.oauth2.client.registration.naver.redirect-uri-code}") private String redirectUriCode; @Value("${spring.security.oauth2.client.provider.naver.token-uri}") private String tokenUri; @Value("${spring.security.oauth2.client.provider.naver.user-info-uri}") private String userInfoUri; @Override public String getRedirectUrlCode() { Map params = new HashMap<>(); params.put("response_type", "code"); params.put("client_id", clientId); params.put("state", this.userService.genConfirmCode(12)); params.put("redirect_uri", redirectUriCode); String paramsString = params.entrySet().stream() .map(x -> x.getKey() + "=" + x.getValue()) .collect(Collectors.joining("&")); return authorizationUri + "?" + paramsString; } @Override public String getAccessToken(String code, String state) { RestTemplate restTemplate = new RestTemplate(); HttpHeaders httpHeaders = new HttpHeaders(); MultiValueMap params = new LinkedMultiValueMap<>(); params.set("grant_type", "authorization_code"); params.set("client_id", clientId); params.set("client_secret", clientSecret); params.set("code", code); params.set("state", state); HttpEntity> restRequest = new HttpEntity<>(params, httpHeaders); ResponseEntity responseEntity = restTemplate.postForEntity(tokenUri, restRequest, JSONObject.class); if (responseEntity.getStatusCode() == HttpStatus.OK) { return (String) responseEntity.getBody().get("access_token"); } return ""; } @Override public Map getUserAttribute(String accessToken) { RestTemplate restTemplate = new RestTemplate(); HttpHeaders httpHeaders = new HttpHeaders(); httpHeaders.add("Authorization", "Bearer " + accessToken); HttpEntity> restRequest = new HttpEntity<>(httpHeaders); ResponseEntity responseEntity = restTemplate.exchange(userInfoUri, HttpMethod.GET, restRequest, JSONObject.class); if (responseEntity.getStatusCode() == HttpStatus.OK) { Map userAttributes = new HashMap<>(); Map response = (Map) responseEntity.getBody().get("response"); userAttributes.put("provider", "naver"); userAttributes.put("providerId", response.get("id")); userAttributes.put("email", response.get("email")); userAttributes.put("name", response.get("name")); return userAttributes; } return new HashMap<>(); } } ``` ## ? 트레이너 등록 페이지 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/o0m4qfI.png)
### ? 소스 코드 --- - trainer_form.html ```html

Road to WrestleMania VIXIV

이름

소속 센터

성별
남자

여자

주소

프로필 사진
프로필 사진을 업로드 해주세요.

간략한 소개

자세한 소개

트레이닝 종목

레슨 비용
회

총 원

자격증
자격증 이미지를 업로드 해주세요.

연락처

``` - TrainerController.java ```java @PreAuthorize("isAuthenticated()") @GetMapping("/register") public String register(Model model, TrainerForm trainerForm, Principal principal) { SiteUser userInfo = this.userService.getUserByLoginId(principal.getName()); trainerForm.setUsername(userInfo.getUsername()); List fieldList = this.fieldService.getList(); model.addAttribute("fieldList", fieldList); List lessonList = new ArrayList<>(); List certificateList = new ArrayList<>(); List contactList = new ArrayList<>(); for (int i = 0; i < 3; i++) { lessonList.add(new LessonForm()); certificateList.add(new CertificateForm()); contactList.add(new ContactForm()); } model.addAttribute("lessonList", lessonList); model.addAttribute("certificateList", certificateList); model.addAttribute("contactList", contactList); return "trainer_form"; } @PreAuthorize("isAuthenticated()") @PostMapping("/register") public String register(Model model, @Valid TrainerForm trainerForm, BindingResult bindingResult, Principal principal) throws IOException { int length; System.out.println("들어옴"); System.out.println("username = " + trainerForm.getUsername()); System.out.println("center = " + trainerForm.getCenter()); System.out.println("gender = " + trainerForm.getGender()); System.out.println("introAbstract = " + trainerForm.getIntroAbstract()); System.out.println("introDetail = " + trainerForm.getIntroDetail()); System.out.println("zoneCodeAddress = " + trainerForm.getAddress().getZoneCode()); System.out.println("MainAddress = " + trainerForm.getAddress().getMainAddress()); System.out.println("subAddress = " + trainerForm.getAddress().getSubAddress()); System.out.println("latitude = " + trainerForm.getAddress().getLatitude()); System.out.println("longitude = " + trainerForm.getAddress().getLongitude()); int index = 0; for (LessonForm lessonForm : trainerForm.getLessonList()) { if (lessonForm.getTime() != null && lessonForm.getPrice() != null) { System.out.printf("Lesson #%d: time = %s, price = %s\n", ++index, lessonForm.getTime(), lessonForm.getPrice()); } } index = 0; for (ContactForm contactForm : trainerForm.getContactList()) { if (!contactForm.getType().equals("") && !contactForm.getContent().equals("")) { System.out.printf("contact #%d : type = %s, content = %s\n", ++index, contactForm.getType(), contactForm.getContent()); } } index = 0; for (CertificateForm certificateForm : trainerForm.getCertificateList()) { if (!certificateForm.getName().equals("") && certificateForm.getImage() != null) { System.out.printf("name #%d : name = %s, imgUrl = %s\n", ++index, certificateForm.getName(), certificateForm.getImage().getOriginalFilename()); } } SiteUser userInfo = this.userService.getUserByLoginId(principal.getName()); if (bindingResult.hasErrors()) { System.out.println(bindingResult); List fieldList = this.fieldService.getList(); model.addAttribute("fieldList", fieldList); List lessonList = new ArrayList<>(); length = trainerForm.getLessonList().size() > 3 ? trainerForm.getLessonList().size() : 3; for (int i = 0; i < length; i++) { if (i < trainerForm.getLessonList().size()) { lessonList.add(trainerForm.getLessonList().get(i)); } else { lessonList.add(new LessonForm()); } } model.addAttribute("lessonList", lessonList); List certificateList = new ArrayList<>(); length = trainerForm.getCertificateList().size() > 3 ? trainerForm.getCertificateList().size() : 3; for (int i = 0; i < length; i++) { if (i < trainerForm.getCertificateList().size()) { certificateList.add(trainerForm.getCertificateList().get(i)); } else { certificateList.add(new CertificateForm()); } } model.addAttribute("certificateList", certificateList); List contactList = new ArrayList<>(); length = trainerForm.getContactList().size() > 3 ? trainerForm.getContactList().size() : 3; for (int i = 0; i < length; i++) { if (i < trainerForm.getContactList().size()) { contactList.add(trainerForm.getContactList().get(i)); } else { contactList.add(new ContactForm()); } } model.addAttribute("contactList", contactList); return "trainer_form"; } if (this.trainerService.isRegistered(userInfo)) { bindingResult.rejectValue("username", "duplicated", "이미 트레이너로 등록된 계정입니다."); List fieldList = this.fieldService.getList(); model.addAttribute("fieldList", fieldList); List lessonList = new ArrayList<>(); length = trainerForm.getLessonList().size() > 3 ? trainerForm.getLessonList().size() : 3; for (int i = 0; i < length; i++) { if (i < trainerForm.getLessonList().size()) { lessonList.add(trainerForm.getLessonList().get(i)); } else { lessonList.add(new LessonForm()); } } model.addAttribute("lessonList", lessonList); List certificateList = new ArrayList<>(); length = trainerForm.getCertificateList().size() > 3 ? trainerForm.getCertificateList().size() : 3; for (int i = 0; i < length; i++) { if (i < trainerForm.getCertificateList().size()) { certificateList.add(trainerForm.getCertificateList().get(i)); } else { certificateList.add(new CertificateForm()); } } model.addAttribute("certificateList", certificateList); List contactList = new ArrayList<>(); length = trainerForm.getContactList().size() > 3 ? trainerForm.getContactList().size() : 3; for (int i = 0; i < length; i++) { if (i < trainerForm.getContactList().size()) { contactList.add(trainerForm.getContactList().get(i)); } else { contactList.add(new ContactForm()); } } model.addAttribute("contactList", contactList); return "trainer_form"; } // Form 데이터를 실제 객체로 변환 List fieldList = new ArrayList<>(); for (String field : trainerForm.getFieldList()) { fieldList.add(this.fieldService.getField(field)); } // 레슨 평균 값 저장 Integer unit = 0; Integer totalPrice = 0; for (LessonForm lessonForm : trainerForm.getLessonList()) { if (lessonForm.getTime() != null && lessonForm.getPrice() != null) { unit += lessonForm.getTime(); totalPrice += lessonForm.getPrice(); } } Integer avgLessonPrice = totalPrice / 1000 / unit * 10000; // 주소 저장 AddressForm addressForm = trainerForm.getAddress(); Address address = null; if (addressForm.getZoneCode() != null && !addressForm.getMainAddress().equals("") && addressForm.getLatitude() != null && addressForm.getLongitude() != null) { address = this.addressService.create(addressForm.getZoneCode(), addressForm.getMainAddress(), addressForm.getSubAddress(), addressForm.getLatitude(), addressForm.getLongitude()); } // 트레이너 기본 정보 저장 Trainer trainer = this.trainerService.create(userInfo, trainerForm.getCenter(), trainerForm.getGender(), trainerForm.getProfileImage(), trainerForm.getIntroAbstract(), trainerForm.getIntroDetail(), fieldList, avgLessonPrice, address); // 레슨 정보 저장 for (LessonForm lessonForm : trainerForm.getLessonList()) { if (lessonForm.getTime() != null && lessonForm.getPrice() != null) { this.lessonService.create(lessonForm.getTime(), lessonForm.getPrice(), trainer); } } // 연락처 정보 저장 for (ContactForm contactForm : trainerForm.getContactList()) { if (!contactForm.getType().equals("") && !contactForm.getContent().equals("")) { this.contactService.create(contactForm.getType(), contactForm.getContent(), trainer); } } // 자격증 정보 저장 for (CertificateForm certificateForm : trainerForm.getCertificateList()) { if (!certificateForm.getName().equals("") && certificateForm.getImage() != null) { this.certificateService.create(certificateForm.getName(), certificateForm.getImage(), trainer); } } return String.format("redirect:/trainer/%s", trainer.getId()); } ``` - UserService.java ```java @RequiredArgsConstructor @Service public class TrainerService { private final TrainerRepository trainerRepository; private final FileService fileService; public Trainer create(SiteUser userInfo, String center, String gender, MultipartFile file, String introAbstract, String introDetail, List fieldList, Integer avgLessonPrice, Address address) throws IOException { UploadedFile profileImage = this.fileService.upload(file, "trainer", "profile", userInfo.getLoginId()); Trainer trainer = new Trainer(); trainer.setUserInfo(userInfo); trainer.setCenter(center); trainer.setGender(gender); trainer.setProfileImage(profileImage); trainer.setIntroAbstract(introAbstract); trainer.setIntroDetail(introDetail); trainer.setFieldList(fieldList); trainer.setAvgLessonPrice(avgLessonPrice); trainer.setAddress(address); trainer.setCreateDate(LocalDateTime.now()); this.trainerRepository.save(trainer); return trainer; } public boolean isRegistered(SiteUser userInfo) { Optional ot = this.trainerRepository.findByUserInfo(userInfo); return ot.isPresent(); } ```
## ? 트레이너 등록 후 리스트 페이지 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/3tmPixU.png)
### ? 소스 코드 --- - trainer_list.html ```html

전체

처음
끝

``` - TrainerController.java ```java @RequestMapping("/trainer") @RequiredArgsConstructor @Controller public class TrainerController { private final FieldService fieldService; @GetMapping("") public String main(Model model, @RequestParam(value = "tPage", defaultValue = "0") int tPage, @RequestParam(value = "tKw", defaultValue = "") String tKw, @RequestParam(value = "tField", defaultValue = "") String tField) { List fieldList = this.fieldService.getList(); model.addAttribute("fieldList", fieldList); Page trainerPaging = this.trainerService.getList(tPage, tKw, tField); model.addAttribute("trainerPaging", trainerPaging); model.addAttribute("tPage", tPage); model.addAttribute("tKw", tKw); model.addAttribute("tField", tField); return "trainer_list"; } ``` - TrainerService.java ```java @RequiredArgsConstructor @Service public class UserService { private final UserRepository userRepository; public Trainer getTrainer(Long id){ Optional ot = this.trainerRepository.findById(id); if(ot.isPresent()){ return ot.get(); }else{ throw new DataNotFoundException("trainer not found"); } } public List getListWithRadius() { return null; } public Page getList(int tPage, String tKw, String tField) { Pageable pageable = PageRequest.of(tPage, 10); return this.trainerRepository.findAllByKeywordAndFieldOrderByCreateDate(tField, tKw, pageable); } } ``` - TrainerRepository.java ```java public interface TrainerRepository extends JpaRepository { Optional findByUserInfo(SiteUser userInfo); @Query(value = "select " + "distinct t.* " + "from trainer t " + "left outer join site_user u on t.user_info_id = u.id " + "left outer join address a on t.address_id = a.id " + "left outer join trainer_field_list tfl on t.id = tfl.trainer_id " + "left outer join field f on tfl.field_list_id = f.id " + "where f.name like %:tField% and " + "(u.username like %:tKw% " + "or a.main_address like %:tKw% " + "or t.center like %:tKw%) " + "order by t.create_date desc " , countQuery = "select count(*) from trainer" , nativeQuery = true) Page findAllByKeywordAndFieldOrderByCreateDate(@Param("tField") String tField, @Param("tKw") String tKw, Pageable pageable); } ```
## ? 트레이너 상세페이지 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/15tJvmq.png)
### ? 소스 코드 --- - trainer_detail.html ```html

트레이닝 종목

소속 센터

보유 자격증

레슨 이용가격

연락처

``` - TrainerController.java ```java @GetMapping("/{id}") public String detail(Model model, @PathVariable("id") Long id) { List fieldList = this.fieldService.getList(); model.addAttribute("fieldList", fieldList); Trainer trainer = this.trainerService.getTrainer(id); model.addAttribute("trainer", trainer); model.addAttribute("tKw", ""); model.addAttribute("tField", ""); return "trainer_detail"; } ```
## ? 커뮤니티 페이지 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/NSP6VL7.png)
### ? 소스 코드 --- - board_list.html ```html

글쓰기 글쓰기

번호
분류
제목
작성자
작성시간
조회수
추천수

처음
끝

``` - BoardController.java ```java @RequestMapping("/board") @RequiredArgsConstructor @Controller public class BoardController { private final BoardService boardService; private final CategoryService categoryService; @GetMapping("") public String main(Model model, @RequestParam(value = "bPageSize", defaultValue = "20") int bPageSize, @RequestParam(value = "bPage", defaultValue = "0") int bPage, @RequestParam(value = "bSearch", defaultValue = "all") String bSearch, @RequestParam(value = "bKw", defaultValue = "") String bKw, @RequestParam(value = "bSort", defaultValue = "createDate") String bSort, @RequestParam(value = "bCategory", defaultValue = "") String bCategory) { List categoryList = this.categoryService.getList(); model.addAttribute("categoryList", categoryList); Map bcc = new HashMap<>(); for (Category category : categoryList) { if (!category.getName().equals("공지")) { Long count = this.boardService.getCount(category); bcc.put(category, count); } } model.addAttribute("bcc", bcc); model.addAttribute("presentBoard", new Board()); Page boardPaging = this.boardService.getList(bPageSize, bPage, bSearch, bKw, bSort, bCategory); model.addAttribute("boardPaging", boardPaging); model.addAttribute("bPageSize", bPageSize); model.addAttribute("bPage", bPage); model.addAttribute("bSearch", bSearch); model.addAttribute("bKw", bKw); model.addAttribute("bSort", bSort); model.addAttribute("bCategory", bCategory); return "board_main"; } ``` - BoardForm.java ```java @Getter @Setter public class BoardForm { @NotEmpty(message = "제목이 입력되지 않았습니다") @Size(max = 200) private String title; @NotEmpty(message = "내용이 입력되지 않았습니다") private String content; @NotEmpty(message = "카테고리가 입력되지 않았습니다") private String category; } ``` - BoardService.java ```java @RequiredArgsConstructor @Service public class BoardService { private final BoardRepository boardRepository; private final CategoryRepository categoryRepository; public Board create(String title, String content, SiteUser author, Category category) { Board board = new Board(); board.setTitle(title); board.setContent(content); board.setAuthor(author); board.setCategory(category); board.setCreateDate(LocalDateTime.now()); board.setHit(0); this.boardRepository.save(board); return board; } ``` - UserRepository.java ```java public interface BoardRepository extends JpaRepository { // all, voter count @Query(value = "select " + "distinct b.*, count(bv.board_id) as voter_count " + "from board b " + "left outer join board_voter bv on b.id = bv.board_id " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "(b.title like %:btKw% " + "or b.content like %:bcKw% " + "or u.nickname like %:baKw% " + "or c.content like %:ccKw%) " + "group by b.id, bv.board_id " + "order by voter_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByOrderByVoterCount(@Param("bCategory") String bCategory, @Param("btKw") String btKw, @Param("bcKw") String bcKw, @Param("baKw") String baKw, @Param("ccKw") String ccKw, Pageable pageable); // all, comment count @Query(value = "select " + "distinct b.*, count(c.board_id) as comment_count " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "(b.title like %:btKw% " + "or b.content like %:bcKw% " + "or u.nickname like %:baKw% " + "or c.content like %:ccKw%) " + "group by b.id, c.board_id " + "order by comment_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByOrderByCommentCount(@Param("bCategory") String bCategory, @Param("btKw") String btKw, @Param("bcKw") String bcKw, @Param("baKw") String baKw, @Param("ccKw") String ccKw, Pageable pageable); // all, create date @Query(value = "select " + "distinct b.* " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "(b.title like %:btKw% " + "or b.content like %:bcKw% " + "or u.nickname like %:baKw% " + "or c.content like %:ccKw%) " + "order by b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByOrderByCreateDate(@Param("bCategory") String bCategory, @Param("btKw") String btKw, @Param("bcKw") String bcKw, @Param("baKw") String baKw, @Param("ccKw") String ccKw, Pageable pageable); // board title, voter count @Query(value = "select " + "distinct b.*, count(bv.board_id) as voter_count " + "from board b " + "left outer join board_voter bv on b.id = bv.board_id " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "b.title like %:btKw% " + "group by b.id, bv.board_id " + "order by voter_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardTitleOrderByVoterCount(@Param("bCategory") String bCategory, @Param("btKw") String btKw, Pageable pageable); // board title, comment count @Query(value = "select " + "distinct b.*, count(c.board_id) as comment_count " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "b.title like %:btKw% " + "group by b.id, c.board_id " + "order by comment_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardTitleOrderByCommentCount(@Param("bCategory") String bCategory, @Param("btKw") String btKw, Pageable pageable); // board title, create date @Query(value = "select " + "distinct b.* " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "b.title like %:btKw% " + "order by b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardTitleOrderByCreateDate(@Param("bCategory") String bCategory, @Param("btKw") String btKw, Pageable pageable); // board content, voter count @Query(value = "select " + "distinct b.*, count(bv.board_id) as voter_count " + "from board b " + "left outer join board_voter bv on b.id = bv.board_id " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "b.content like %:bcKw% " + "group by b.id, bv.board_id " + "order by voter_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardContentOrderByVoterCount(@Param("bCategory") String bCategory, @Param("bcKw") String bcKw, Pageable pageable); // board content, comment count @Query(value = "select " + "distinct b.*, count(c.board_id) as comment_count " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "b.content like %:bcKw% " + "group by b.id, c.board_id " + "order by comment_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardContentOrderByCommentCount(@Param("bCategory") String bCategory, @Param("bcKw") String bcKw, Pageable pageable); // board content, create date @Query(value = "select " + "distinct b.* " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "b.content like %:bcKw% " + "order by b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardContentOrderByCreateDate(@Param("bCategory") String bCategory, @Param("bcKw") String bcKw, Pageable pageable); // title & content, voter count @Query(value = "select " + "distinct b.*, count(bv.board_id) as voter_count " + "from board b " + "left outer join board_voter bv on b.id = bv.board_id " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "(b.title like %:btKw% " + "or b.content like %:bcKw%) " + "group by b.id, bv.board_id " + "order by voter_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardTitleAndBoardContentOrderByVoterCount(@Param("bCategory") String bCategory, @Param("btKw") String btKw, @Param("bcKw") String bcKw, Pageable pageable); // title & content, comment count @Query(value = "select " + "distinct b.*, count(c.board_id) as comment_count " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "(b.title like %:btKw% " + "or b.content like %:bcKw%) " + "group by b.id, c.board_id " + "order by comment_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardTitleAndBoardContentOrderByCommentCount(@Param("bCategory") String bCategory, @Param("btKw") String btKw, @Param("bcKw") String bcKw, Pageable pageable); // title & content, create date @Query(value = "select " + "distinct b.* " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "(b.title like %:btKw% " + "or b.content like %:bcKw%) " + "order by b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardTitleAndBoardContentOrderByCreateDate(@Param("bCategory") String bCategory, @Param("btKw") String btKw, @Param("bcKw") String bcKw, Pageable pageable); // board author, voter count @Query(value = "select " + "distinct b.*, count(bv.board_id) as voter_count " + "from board b " + "left outer join board_voter bv on b.id = bv.board_id " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "u.nickname like %:baKw% " + "group by b.id, bv.board_id " + "order by voter_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardAuthorOrderByVoterCount(@Param("bCategory") String bCategory, @Param("baKw") String baKw, Pageable pageable); // board author, comment count @Query(value = "select " + "distinct b.*, count(c.board_id) as comment_count " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "u.nickname like %:baKw% " + "group by b.id, c.board_id " + "order by comment_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardAuthorOrderByCommentCount(@Param("bCategory") String bCategory, @Param("baKw") String baKw, Pageable pageable); // board author, create date @Query(value = "select " + "distinct b.* " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "u.nickname like %:baKw% " + "order by b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByBoardAuthorOrderByCreateDate(@Param("bCategory") String bCategory, @Param("baKw") String baKw, Pageable pageable); // comment content, voter count @Query(value = "select " + "distinct b.*, count(bv.board_id) as voter_count " + "from board b " + "left outer join board_voter bv on b.id = bv.board_id " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "c.content like %:ccKw% " + "group by b.id, bv.board_id " + "order by voter_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByCommentContentOrderByVoterCount(@Param("bCategory") String bCategory, @Param("ccKw") String ccKw, Pageable pageable); // comment content, comment count @Query(value = "select " + "distinct b.*, count(c.board_id) as comment_count " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "c.content like %:ccKw% " + "group by b.id, c.board_id " + "order by comment_count desc, b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByCommentContentOrderByCommentCount(@Param("bCategory") String bCategory, @Param("ccKw") String ccKw, Pageable pageable); // comment content, create date @Query(value = "select " + "distinct b.* " + "from board b " + "left outer join site_user u on b.author_id = u.id " + "left outer join comment c on b.id = c.board_id " + "left outer join category bc on b.category_id = bc.id " + "where bc.name like %:bCategory% and " + "c.content like %:ccKw% " + "order by b.create_date desc " , countQuery = "select count(*) from board" , nativeQuery = true) Page findAllByCommentContentOrderByCreateDate(@Param("bCategory") String bCategory, @Param("ccKw") String ccKw, Pageable pageable); Long countByCategory(Category category); Page findAllByAuthor(SiteUser author, Pageable pageable); @Query(value = "select " + "distinct b.*, count(bv.board_id) as voter_count " + "from board b " + "left outer join board_voter bv on b.id = bv.board_id " + "group by b.id, bv.board_id " + "order by voter_count desc, b.create_date desc " + "limit 10 " , countQuery = "select count(*) from board" , nativeQuery = true) List findTop10OrderByVoterCount(); List findTop10ByOrderByCreateDateDesc(); } ```
## ? 커뮤니티 디테일 페이지 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/zzIz1lS.png)
### ? 소스 코드 --- - board_detail.html ```html

답글

처음
끝

``` - board_Controller ```java @RequestMapping("/board") @RequiredArgsConstructor @Controller public class BoardController { private final CategoryService categoryService; private final CommentService commentService; @GetMapping("/{id}") public String detail(Model model, CommentForm commentForm, ReCommentForm reCommentForm, @PathVariable("id") Long id, @RequestParam(value = "bPageSize", defaultValue = "20") int bPageSize, @RequestParam(value = "bPage", defaultValue = "0") int bPage, @RequestParam(value = "bSearch", defaultValue = "all") String bSearch, @RequestParam(value = "bKw", defaultValue = "") String bKw, @RequestParam(value = "bSort", defaultValue = "createDate") String bSort, @RequestParam(value = "bCategory", defaultValue = "") String bCategory, @RequestParam(value = "cPage", defaultValue = "0") int cPage, @RequestParam(value = "cSort", defaultValue = "createDate") String cSort, HttpServletRequest request, HttpServletResponse response) { Board presentBoard; if (hitCountJudge(id, request, response)) { presentBoard = this.boardService.hit(id); } else { presentBoard = this.boardService.getBoard(id); } model.addAttribute("presentBoard", presentBoard); List categoryList = this.categoryService.getList(); model.addAttribute("categoryList", categoryList); Map bcc = new HashMap<>(); for (Category category : categoryList) { if (!category.getName().equals("공지")) { Long count = this.boardService.getCount(category); bcc.put(category, count); } } model.addAttribute("bcc", bcc); Page boardPaging = this.boardService.getList(bPageSize, bPage, bSearch, bKw, bSort, bCategory); model.addAttribute("boardPaging", boardPaging); Page commentPaging = this.commentService.getList(presentBoard, cPage, cSort); model.addAttribute("commentPaging", commentPaging); model.addAttribute("bPageSize", bPageSize); model.addAttribute("bPage", bPage); model.addAttribute("bSearch", bSearch); model.addAttribute("bKw", bKw); model.addAttribute("bSort", bSort); model.addAttribute("bCategory", bCategory); model.addAttribute("cPage", cPage); model.addAttribute("cSort", cSort); return "board_detail"; } @PreAuthorize("isAuthenticated()") @GetMapping("/write") public String writeBoard(Model model, BoardForm boardForm) { List categoryList = this.categoryService.getList(); model.addAttribute("categoryList", categoryList); Map bcc = new HashMap<>(); for (Category category : categoryList) { if (!category.getName().equals("공지")) { Long count = this.boardService.getCount(category); bcc.put(category, count); } } model.addAttribute("bcc", bcc); return "board_form"; } @PreAuthorize("isAuthenticated()") @PostMapping("/write") public String writeBoard(Model model, @Valid BoardForm boardForm, BindingResult bindingResult, Principal principal) { // If exists Form Validation Error if (bindingResult.hasErrors()) { List categoryList = this.categoryService.getList(); model.addAttribute("categoryList", categoryList); Map bcc = new HashMap<>(); for (Category category : categoryList) { if (!category.getName().equals("공지")) { Long count = this.boardService.getCount(category); bcc.put(category, count); } } model.addAttribute("bcc", bcc); return "board_form"; } // Write Board Category category = this.categoryService.getCategory(boardForm.getCategory()); SiteUser author = this.userService.getUserByLoginId(principal.getName()); Board board = this.boardService.create(boardForm.getTitle(), boardForm.getContent(), author, category); // Redirect to created board detail return String.format("redirect:/board/%s", board.getId()); } @PreAuthorize("isAuthenticated()") @GetMapping("/modify/{id}") public String modifyBoard(Model model, BoardForm boardForm, @PathVariable("id") Long id, Principal principal) { Board board = this.boardService.getBoard(id); if (!board.getAuthor().getLoginId().equals(principal.getName())) { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "수정 권한이 없습니다."); } List categoryList = this.categoryService.getList(); model.addAttribute("categoryList", categoryList); Map bcc = new HashMap<>(); for (Category category : categoryList) { if (!category.getName().equals("공지")) { Long count = this.boardService.getCount(category); bcc.put(category, count); } } model.addAttribute("bcc", bcc); boardForm.setCategory(board.getCategory().getName()); boardForm.setTitle(board.getTitle()); boardForm.setContent(board.getContent()); return "board_form"; } @PreAuthorize("isAuthenticated()") @PostMapping("/modify/{id}") public String modifyBoard(Model model, @Valid BoardForm boardForm, BindingResult bindingResult, @PathVariable("id") Long id, Principal principal) { Board board = this.boardService.getBoard(id); if (!board.getAuthor().getLoginId().equals(principal.getName())) { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "수정 권한이 없습니다."); } // If exists Form Validation Error if (bindingResult.hasErrors()) { List categoryList = this.categoryService.getList(); model.addAttribute("categoryList", categoryList); Map bcc = new HashMap<>(); for (Category category : categoryList) { if (!category.getName().equals("공지")) { Long count = this.boardService.getCount(category); bcc.put(category, count); } } model.addAttribute("bcc", bcc); return "board_form"; } // Modify Board Category category = this.categoryService.getCategory(boardForm.getCategory()); this.boardService.modify(board, boardForm.getTitle(), boardForm.getContent(), category); // Redirect to modified board detail return String.format("redirect:/board/%s", board.getId()); } @PreAuthorize("isAuthenticated()") @GetMapping("/delete/{id}") public String deleteBoard(@PathVariable("id") Long id, Principal principal) { Board board = this.boardService.getBoard(id); if (!board.getAuthor().getLoginId().equals(principal.getName())) { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "삭제 권한이 없습니다."); } this.boardService.delete(board); return "redirect:/board"; } @PreAuthorize("isAuthenticated()") @GetMapping("/vote/{id}") public String voteBoard(Model model, @PathVariable("id") Long id, Principal principal) { Board presentBoard = this.boardService.getBoard(id); SiteUser voter = this.userService.getUserByLoginId(principal.getName()); if (presentBoard.getAuthor().getLoginId().equals(voter.getLoginId())) { throw new RuntimeException("본인이 작성한 글은 추천할 수 없습니다."); } this.boardService.vote(presentBoard, voter); model.addAttribute("presentBoard", presentBoard); return "board_detail :: #board_detail"; } private boolean hitCountJudge(Long id, HttpServletRequest request, HttpServletResponse response) { // 요청 이전 url을 확인해서 제대로 된 게시물 접근인지 확인 String refer = request.getHeader("REFERER"); if (refer == null) return false; String path = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort(); String referUri = refer.replaceFirst(path, ""); System.out.println(referUri); // 게시판에서 접근한 경우가 아니면 reject if (!referUri.startsWith("/board") && !referUri.equals("/index") && !referUri.startsWith("/user/mypage")) return false; Cookie oldCookie = null; Cookie[] cookies = request.getCookies(); if (cookies != null) { for (Cookie cookie : cookies) { if (cookie.getName().equals("boardHit")) { oldCookie = cookie; } } } // 관련 쿠기가 있다면 if (oldCookie != null) { // 해당 쿠키가 해당 게시물 id를 조회할 때 생성된 쿠기인지 판단 if (!oldCookie.getValue().contains("[" + id + "]")) { // 아니라면 해당 게시물 id를 조회한 결과를 쿠기에 저장 oldCookie.setValue(oldCookie.getValue() + "_[" + id + "]"); oldCookie.setPath("/"); oldCookie.setMaxAge(30); // 지속시간 30초 response.addCookie(oldCookie); // 쿠키를 브라우저에 저장 return true; } // 맞다면 reject return false; } else { // 쿠키가 없다면 새로 생성해서 해당 게시물 id를 조회한 결과를 쿠기에 저장 Cookie newCookie = new Cookie("boardHit", "[" + id + "]"); newCookie.setPath("/"); newCookie.setMaxAge(30); // 지속시간 30초 response.addCookie(newCookie); // 쿠키를 브라우저에 저장 return true; } } } ``` - BoardService.java ```java public void modify(Board board, String title, String content, Category category) { board.setTitle(title); board.setContent(content); board.setCategory(category); board.setModifyDate(LocalDateTime.now()); this.boardRepository.save(board); } public void delete(Board board) { this.boardRepository.delete(board); } public Page getList(int bPageSize, int bPage, String bSearch, String bKw, String bSort, String bCategory) { String btKw = "", bcKw = "", baKw = "", ccKw = ""; Pageable pageable = PageRequest.of(bPage, bPageSize); if (bSearch.equals("all")) { btKw = bKw; bcKw = bKw; baKw = bKw; ccKw = bKw; if (bSort.equals("vote")) { return this.boardRepository.findAllByOrderByVoterCount(bCategory, btKw, bcKw, baKw, ccKw, pageable); } else if (bSort.equals("comment")) { return this.boardRepository.findAllByOrderByCommentCount(bCategory, btKw, bcKw, baKw, ccKw, pageable); } else { return this.boardRepository.findAllByOrderByCreateDate(bCategory, btKw, bcKw, baKw, ccKw, pageable); } } else if (bSearch.equals("title")) { btKw = bKw; if (bSort.equals("vote")) { return this.boardRepository.findAllByBoardTitleOrderByVoterCount(bCategory, btKw, pageable); } else if (bSort.equals("comment")) { return this.boardRepository.findAllByBoardTitleOrderByCommentCount(bCategory, btKw, pageable); } else { return this.boardRepository.findAllByBoardTitleOrderByCreateDate(bCategory, btKw, pageable); } } else if (bSearch.equals("content")) { bcKw = bKw; if (bSort.equals("vote")) { return this.boardRepository.findAllByBoardContentOrderByVoterCount(bCategory, bcKw, pageable); } else if (bSort.equals("comment")) { return this.boardRepository.findAllByBoardContentOrderByCommentCount(bCategory, bcKw, pageable); } else { return this.boardRepository.findAllByBoardContentOrderByCreateDate(bCategory, bcKw, pageable); } } else if (bSearch.equals("title_content")) { btKw = bKw; bcKw = bKw; if (bSort.equals("vote")) { return this.boardRepository.findAllByBoardTitleAndBoardContentOrderByVoterCount(bCategory, btKw, bcKw, pageable); } else if (bSort.equals("comment")) { return this.boardRepository.findAllByBoardTitleAndBoardContentOrderByCommentCount(bCategory, btKw, bcKw, pageable); } else { return this.boardRepository.findAllByBoardTitleAndBoardContentOrderByCreateDate(bCategory, btKw, bcKw, pageable); } } else if (bSearch.equals("author")) { baKw = bKw; if (bSort.equals("vote")) { return this.boardRepository.findAllByBoardAuthorOrderByVoterCount(bCategory, baKw, pageable); } else if (bSort.equals("comment")) { return this.boardRepository.findAllByBoardAuthorOrderByCommentCount(bCategory, baKw, pageable); } else { return this.boardRepository.findAllByBoardAuthorOrderByCreateDate(bCategory, baKw, pageable); } } else if (bSearch.equals("comment")) { ccKw = bKw; if (bSort.equals("vote")) { return this.boardRepository.findAllByCommentContentOrderByVoterCount(bCategory, ccKw, pageable); } else if (bSort.equals("comment")) { return this.boardRepository.findAllByCommentContentOrderByCommentCount(bCategory, ccKw, pageable); } else { return this.boardRepository.findAllByCommentContentOrderByCreateDate(bCategory, ccKw, pageable); } } return null; } public Board getBoard(Long id) { Optional ob = this.boardRepository.findById(id); if (ob.isPresent()) { return ob.get(); } else { throw new DataNotFoundException("board not found"); } } public void vote(Board board, SiteUser voter) { if (board.getVoter().contains(voter)) { board.getVoter().remove(voter); } else { board.getVoter().add(voter); } this.boardRepository.save(board); } public Long getCount(Category category) { return this.boardRepository.countByCategory(category); } public Page getListByUser(int bPage, SiteUser user) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(bPage, 10, Sort.by(sorts)); return this.boardRepository.findAllByAuthor(user, pageable); } public Board hit(Long id) { Board board = this.getBoard(id); board.setHit(board.getHit() + 1); this.boardRepository.save(board); return board; } } ``` ## ? 마이 페이지 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/mat27AW.png)
### ? 소스 코드 --- - my_page.html ```html

로그인 ID

닉네임

가입일

최근 로그인

소셜 계정

권한

로그인 ID

닉네임

이름

생일

이메일

전화번호

주소

가입일

최근 로그인

소셜 계정

``` - UserController.java ```java @GetMapping("/mypage") public String myPage(Model model, Principal principal, @RequestParam(value = "section", defaultValue = "information") String section, @RequestParam(value = "bPage", defaultValue = "0") int bPage, @RequestParam(value = "cPage", defaultValue = "0") int cPage, @RequestParam(value = "rPage", defaultValue = "0") int rPage) { SiteUser user = this.userService.getUserByLoginId(principal.getName()); model.addAttribute("user", user); List socialLinked = new ArrayList<>(); for (Oauth2Account socialAccount : user.getSocialAccount()) { socialLinked.add(socialAccount.getProvider()); } model.addAttribute("socialLinked", socialLinked); Page boardPaging = this.boardService.getListByUser(bPage, user); model.addAttribute("boardPaging", boardPaging); Page commentPaging = this.commentService.getListByUser(cPage, user); model.addAttribute("commentPaging", commentPaging); Page reCommentPaging = this.reCommentService.getListByUser(rPage, user); model.addAttribute("reCommentPaging", reCommentPaging); model.addAttribute("section", section); model.addAttribute("bPage", bPage); model.addAttribute("cPage", cPage); model.addAttribute("rPage", rPage); return "my_page"; } ```
## ? 문의하기 ### ?️ 동작 화면 --- ![img](https://i.imgur.com/Al35maf.png)
### ? 소스 코드 - inquiry_main.html ```html

자주 묻는 질문

Q. 회원가입은 어떻게하나요?

상단 배너 오른쪽 회원가입 버튼을 클릭하여 회원가입을 진행하실 수 있습니다. 또한 카카오톡, 네이버, 구글로 연동하여 이용이 가능합니다.
Q. 커뮤니티를 이용하기 위해서는 회원가입을 해야하나요?

커뮤니티 뿐만 아니라 트레이너를 이용하더라도 회원가입은 필수입니다.
Q. 비밀번호는 어떻게 찾나요?

비밀번호 찾기는 로그인 페이지에 들어가서 비밀번호 찾기를 누르시면, 고객님의 ID와 회원가입 했을 때의 이메일을 입력하시면 찾으실 수 있습니다.
Q. 트레이너 등록은 어떻게 하나요?

고객님께서 로그인을 진행 후 상단 배너 왼쪽 트레이너 버튼을 클릭하여 트레이너 페이지로 이동 후 오른쪽 상단에 위치한 트레이너 등록하기 버튼을 클릭하여 필요한 정보를 입력한 다음 등록하기를 눌러주시면 됩니다.
Q. 등록된 트레이너는 믿어도 되나요?

등록된 트레이너는 활동중인 센터, 자격증 등을 확인 후 등록을 해드리고 있습니다.
Q. 커뮤니티에 악성 글들이 많습니다.

매일 커뮤니티를 확인하며 경고 후 제제를 하고 있습니다.
Q. 헬스운동 품목을 구매하고 싶어요

상단 배너 왼쪽 스토어 버튼을 클릭 원하시는 물품을 선택하여 구매하기 버튼을 누르시면 됩니다. (현재는 스토어 기능은 구현 예정입니다.)
Q. 트레이너 pt 회당 가격은 얼마인가요?

트레이너 pt 회당 가격은 트레이너 상세페이지에서 확인하실 수 있습니다.
Q. 트레이너 상담은 대면으로만 진행되나요?

트레이너 상담은 트레이너 상세 페이지에있는 연락처를 통해 서로 조율하실 수 있습니다.

```
# ? 배포 ## ? 서버 구조 ![img](https://i.imgur.com/AspJjQQ.png)
$$uml !theme mars frame 클라이언트 { frame OS { frame 브라우저 { } } } frame 서버 { frame CentOS7 { circle CentOS7――3306 circle CentOS7――8083 circle CentOS7――443 frame 도커 { frame npm_1 { circle npm_1――443 } frame ogym { circle ogym――14641 } frame mariadb_1 { circle mariadb_1――3306 } } } } 브라우저 --> "CentOS7――443":1． https://ogym.one 으로 접속 "CentOS7――443" --> "npm_1――443" : 2． 외부(CentOS7)의 443포트는\nnpm_1의 443포트로 연결되어 있다. "npm_1――443" --> "CentOS7――8083" : 3． npm_1이 도메인(ogym.one)을 보고\n172．17．0．1:8083 으로 토스해야 겠다고 판단. "CentOS7――8083" --> "ogym――14641" : 4． 외부(CentOS7)의 8083포트는\nogym의 14641포트로 연결되어 있다. "ogym――14641" --> "CentOS7――3306" : 5． DB 쿼리, 내부 14641 => 외부 3306 "CentOS7――3306" --> "mariadb_1――3306" : 6． 외부 3306 => mariadb_1 내부 3306 $$
## ? Google Domains ![img](https://i.imgur.com/ZDDk01e.png)
## ? Naver Cloud PlatForm ![img](https://i.imgur.com/OeV13m3.png)
## ? Termius ![img](https://i.imgur.com/9P0BS4r.png)
## ? Nginx Proxy Manager ![img](https://i.imgur.com/RSdLocL.png)
## ? Jenkins CI / CD ### ? Build Triggers --- ``` - GitHub hook trigger for GITScm polling ```
### ? Pipeline Script --- ```java pipeline { agent any environment { timestamp = "${System.currentTimeMillis() / 1000L}" } stages { stage('Prepare') { steps { script { // Get the ID of the ogym:latest image def oldImageId = sh(script: "docker images ogym:latest -q", returnStdout: true).trim() env.oldImageId = oldImageId } git branch: 'main', url: 'https://github.com/pintordev/OGYM' } post { success { sh 'echo "Successfully Cloned Repository"' } failure { sh 'echo "Fail Cloned Repository"' } } } stage('Build Gradle') { steps { dir('src/main/resources') { sh """ echo spring.profiles.include=prod > application.properties echo secret keys >> application-prod.properties """ } dir('.') { sh """ chmod +x gradlew """ } dir('.') { sh """ ./gradlew clean build """ } } post { success { sh 'echo "Successfully Build Gradle Test"' } failure { sh 'echo "Fail Build Gradle Test"' } } } stage('Build Docker Image') { steps { script { sh "docker build -t ogym:${timestamp} ." } } } stage('Run Docker Container') { steps { script { // Check if the container is already running def isRunning = sh(script: "docker ps -q -f name=ogym", returnStdout: true).trim() if (isRunning) { sh "docker rm -f ogym" } // Run the new container try { sh """ docker run \ --name=ogym \ -p 8083:14641 \ -v /docker_projects/ogym/volumes/file:/file \ --restart unless-stopped \ -e TZ=Asia/Seoul \ -d \ ogym:${timestamp} """ } catch (Exception e) { // If the container failed to run, remove it and the image isRunning = sh(script: "docker ps -q -f name=ogym", returnStdout: true).trim() if (isRunning) { sh "docker rm -f ogym" } def imageExists = sh(script: "docker images -q ogym:${timestamp}", returnStdout: true).trim() if (imageExists) { sh "docker rmi ogym:${timestamp}" } error("Failed to run the Docker container.") } // If there's an existing 'latest' image, remove it def latestExists = sh(script: "docker images -q ogym:latest", returnStdout: true).trim() if (latestExists) { sh "docker rmi ogym:latest" if(!oldImageId.isEmpty()) { sh "docker rmi ${oldImageId}" } } // Tag the new image as 'latest' sh "docker tag ogym:${env.timestamp} ogym:latest" } } } } } ```
### ? Deployment Process; Test Fail --- $$uml !theme toy autonumber box "작업PC" actor 개발자 entity 작업PC end box entity Github_Repository box "서버" entity Jenkins entity 테스트용_서버컨테이너 entity 실서버용_서버컨테이너 end box 개발자 -> 작업PC : Commit! 작업PC -> Github_Repository : Push! Github_Repository -> Jenkins : Webhook에 의해서 Commit Signal 전송 Jenkins -> 테스트용_서버컨테이너 : 재배포 스크립트 실행 테스트용_서버컨테이너 -> Jenkins : 테스트가 실패했습니다... Jenkins -> Jenkins : 이번 빌드는 실패로 처리하고, 작업을 종료합니다. 개발자 -> Jenkins : 해당 빌드의 콘솔기록을 확인하여 테스트가 왜 실패했는지 분석 $$
### ? Deployment Process; Test Success --- $$uml !theme toy autonumber box "작업PC" actor 개발자 entity 작업PC end box entity Github_Repository box "서버" entity Jenkins entity 테스트용_서버컨테이너 entity 실서버용_서버컨테이너 end box 개발자 -> 작업PC : Commit! 작업PC -> Github_Repository : Push! Github_Repository -> Jenkins : Webhook에 의해서 Commit Signal 전송 Jenkins -> 테스트용_서버컨테이너 : 재배포 스크립트 실행 테스트용_서버컨테이너 -> Jenkins : All Clear Jenkins -> 실서버용_서버컨테이너 : 리빌드 후 다시 실행하세요! 개발자 -> 실서버용_서버컨테이너 : Web Brouser로 Build 되었는지 확인 $$
### ? Stage View --- ![img](https://i.imgur.com/tPCAAjk.png)
# ?? 감사합니다 ??