Etc

package com.subject1.images.config;

import com.fasterxml.jackson.annotation.JsonCreator;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import com.fasterxml.jackson.annotation.JsonProperty;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageImpl;
import org.springframework.data.domain.PageRequest;

import java.util.List;

// PageImpl<T>이 기본 생성자가 없어 만들기 위해 생성.
// 해당 클래스가 없다면 Redis에서 PageImpl<T>를 직렬화하지 못해 오류가 발생한다.
@JsonIgnoreProperties(ignoreUnknown = true, value = {"pageable"})
public class CustomPageImpl<T> extends PageImpl<T> {

    @JsonCreator(mode = JsonCreator.Mode.PROPERTIES)
    public CustomPageImpl(@JsonProperty("content") List<T> content,
                          @JsonProperty("number") int number,
                          @JsonProperty("size") int size,
                          @JsonProperty("totalElements") long totalElements
    ) {
        super(content, PageRequest.of(number, size), totalElements);
    }

    public CustomPageImpl(Page<T> page) {
        super(page.getContent(), page.getPageable(), page.getTotalElements());
    }
}

Controller

// 이미지 목록 조회 API
@GetMapping("/projects/{projectId}/images")
public ResponseEntity<?> getListImg(
    @PathVariable Long projectId,
    @ModelAttribute SearchParam searchParam,
    @PageableDefault(size = 10) Pageable pageable) {
    // Offset 방식
    CustomPageImpl<Image> offsetPage 
		    = imageService.getListImgListOffset(projectId, searchParam, pageable);
		    
    return ResponseEntity.ok(offsetPage);
}

Service

// 이미지 목록 조회(Offset)
@Cacheable(value = "imageListOffset", key = "{#searchParam, #pageable}")
public CustomPageImpl<Image> getListImgListOffset(Long projectId, SearchParam searchParam, Pageable pageable) {
    System.out.println("...: DB에서 데이터 조회 중...");
    
    Page<Image> resultPage 
		    = imageRepository.searchListOffset(projectId, searchParam, pageable);
		    
    return new CustomPageImpl<>(resultPage);
    }

Repository

@Override
public Page<Image> searchListOffset(
	Long projectId, SearchParam searchParam, Pageable pageable
) {

    String thumbnailStatusName = Optional.ofNullable(searchParam.getThumbnailStatus())
        .map(Image.ThumbnailStatus::name)
        .orElse(null);

    BooleanBuilder builder = basicWhere(
        projectId,
        searchParam.getTag(),
        thumbnailStatusName
    );

    List<Image> content = queryFactory
            .selectFrom(image)
            .where(builder)
            .orderBy(image.imageId.asc())
            .offset(pageable.getOffset())
            .limit(pageable.getPageSize())
            .fetch();

    JPAQuery<Long> countQuery = queryFactory
        .select(image.count())
        .from(image)
        .where(builder);

    return PageableExecutionUtils.getPage(content, pageable, countQuery::fetchOne);
}

private BooleanBuilder basicWhere(Long projectId, String tag, String status) {
    BooleanBuilder builder = new BooleanBuilder();

    builder.and(image.softDelete.isNull()
        .or(image.softDelete.eq(Boolean.FALSE)));

    if (projectId != null) {
        builder.and(image.projectId.eq(projectId));
    }
    if (StringUtils.isNotBlank(tag)) {
        builder.and(image.tag.eq(tag));
    }
    if (StringUtils.isNotBlank(status)) {
        builder.and(image.thumbnailStatus.eq(Image.ThumbnailStatus.valueOf(status)));
    }

    return builder;
}