Ch 4. 가상 코드 관리 — 신규 메뉴 만들기¶

[1] hera-commons        Domain.java           ← PT_0101 상수 추가 (수정)

[2] hera-domain-data    PtCodeVO.java         ← ViewObject
[3] hera-domain-data    PtCodeSP.java         ← SearchParams

[4] hera-system         PtCode.java           ← Entity
[5] hera-system         PtCodeMapper.java     ← Mapper (MinuBaseMapper 상속)
[6] hera-system         PtCodeService.java    ← Service interface
[7] hera-system         PtCodeServiceImpl.java ← ServiceImpl
[8] hera-system         PtCodeApiController.java ← System API Controller

[9] hera-api-client     PtCodeClient.java     ← Feign Client

[10] hera-webapp        Pt0101ViewRouter.java ← View Router
[11] hera-webapp        pt0101.html           ← Thymeleaf 템플릿
[12] hera-webapp        pt0101.js             ← 화면 JS
[13] hera-webapp        Pt0101ApiController.java ← Webapp API Controller

// hera-commons/.../code/Domain.java

public enum Domain {
    // ... 기존 상수들 ...
    SYS_0101("SYS0101"),
    SYS_0102("SYS0102"),
    // ...

    PT_0101("PT0101"),   // ← 추가
    ;

    private final String value;
    Domain(String value) { this.value = value; }
    public String getValue() { return value; }
}

// hera-domain-data/.../pt/PtCodeVO.java
package com.dandisoft.hera.domain.data.pt;

import com.dandisoft.hera.core.audit.vo.AuditVO;
import lombok.Data;
import lombok.EqualsAndHashCode;

@Data
@EqualsAndHashCode(callSuper = false)
public class PtCodeVO extends AuditVO {

    private String ptCodeId;
    private String code;
    private String name;
    private String useYn;
}

// hera-domain-data/.../pt/PtCodeSP.java
package com.dandisoft.hera.domain.data.pt;

import com.dandisoft.hera.core.model.BaseSP;
import lombok.Data;
import lombok.EqualsAndHashCode;

@Data
@EqualsAndHashCode(callSuper = false)
public class PtCodeSP extends BaseSP {

    private String code;
    private String name;
    private String useYn;
}

// hera-system/.../pt/PtCode.java
package com.dandisoft.hera.system.pt;

import com.dandisoft.hera.core.audit.model.AuditModel;
import com.mybatisflex.annotation.Column;
import com.mybatisflex.annotation.Id;
import com.mybatisflex.annotation.Table;
import com.dandisoft.hera.core.audit.listener.AuditingEntityListener;
import lombok.Data;
import lombok.EqualsAndHashCode;

@Data
@EqualsAndHashCode(callSuper = false)
@Table(
    value = "pt_code",
    onInsert = AuditingEntityListener.class,
    onUpdate = AuditingEntityListener.class
)
public class PtCode extends AuditModel<String> {

    @Id
    @Column(value = "pt_code_id", onInsertValue = "uuidv7()")
    private String ptCodeId;

    @Column("code")
    private String code;

    @Column("name")
    private String name;

    @Column("use_yn")
    private String useYn;
}

// hera-system/.../pt/PtCodeMapper.java
package com.dandisoft.hera.system.pt;

import com.dandisoft.hera.core.mapper.MinuBaseMapper;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface PtCodeMapper extends MinuBaseMapper<PtCode> {
}

// hera-system/.../pt/PtCodeService.java
package com.dandisoft.hera.system.pt;

import com.dandisoft.hera.core.service.AuditService;
import com.dandisoft.hera.domain.data.pt.PtCodeSP;
import com.dandisoft.hera.domain.data.pt.PtCodeVO;

public interface PtCodeService
        extends AuditService<PtCode, PtCodeVO, PtCodeSP> {
}

// hera-system/.../pt/PtCodeServiceImpl.java
package com.dandisoft.hera.system.pt;

import com.dandisoft.hera.core.service.AuditServiceImpl;
import com.dandisoft.hera.domain.data.pt.PtCodeSP;
import com.dandisoft.hera.domain.data.pt.PtCodeVO;
import com.mybatisflex.core.query.If;
import com.mybatisflex.core.query.QueryWrapper;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Service;

@Service
@RequiredArgsConstructor
public class PtCodeServiceImpl
        extends AuditServiceImpl<PtCode, PtCodeVO, PtCodeSP, PtCodeMapper>
        implements PtCodeService {

    @Override
    protected QueryWrapper searchCondition(PtCodeSP sp) {
        return QueryWrapper.create()
                .like(PtCode::getCode,   sp.getCode(),   If::hasText)
                .like(PtCode::getName,   sp.getName(),   If::hasText)
                .eq(PtCode::getUseYn,    sp.getUseYn(),  If::hasText);
    }
}

// hera-system/.../pt/PtCodeApiController.java
package com.dandisoft.hera.system.pt;

import com.dandisoft.hera.core.controller.AuditApiController;
import com.dandisoft.hera.core.model.PageRequest;
import com.dandisoft.hera.core.model.PageResponse;
import com.dandisoft.hera.domain.data.pt.PtCodeSP;
import com.dandisoft.hera.domain.data.pt.PtCodeVO;
import com.dandisoft.hera.hera_api_client.config.UrlConstant;
import lombok.RequiredArgsConstructor;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;

@RestController
@RequestMapping(UrlConstant.SYS_API_V1)
@RequiredArgsConstructor
public class PtCodeApiController
        extends AuditApiController<PtCode, PtCodeVO, PtCodeSP, PtCodeService> {

    @PreAuthorize("hasRole('ROLE_PT0101_READ')")
    @GetMapping("/pt-codes/pageable")
    public PageResponse<PtCodeVO> findAllOnPageable(
            @RequestBody PageRequest<PtCodeSP> pageRequest) {
        return super.doFindAllOnPageable(pageRequest);
    }

    @PreAuthorize("hasRole('ROLE_PT0101_CREATE')")
    @PostMapping("/pt-codes")
    public PtCodeVO save(@RequestBody PtCodeVO vo) {
        return super.doSave(vo);
    }

    @PreAuthorize("hasRole('ROLE_PT0101_UPDATE')")
    @PutMapping("/pt-codes/{id}")
    public PtCodeVO update(@PathVariable String id, @RequestBody PtCodeVO vo) {
        return super.doUpdate(id, vo);
    }

    @PreAuthorize("hasRole('ROLE_PT0101_DELETE')")
    @DeleteMapping("/pt-codes/{id}")
    public void delete(@PathVariable String id) {
        super.doDelete(id);
    }
}

// hera-api-client/.../pt/PtCodeClient.java
package com.dandisoft.hera.hera_api_client.pt;

import com.dandisoft.hera.core.model.PageRequest;
import com.dandisoft.hera.core.model.PageResponse;
import com.dandisoft.hera.domain.data.pt.PtCodeSP;
import com.dandisoft.hera.domain.data.pt.PtCodeVO;
import com.dandisoft.hera.hera_api_client.config.UrlConstant;
import org.springframework.cloud.openfeign.FeignClient;
import org.springframework.web.bind.annotation.*;

@FeignClient(
    name    = "msa-api-gateway",
    path    = UrlConstant.SYS_API_V1,
    url     = "${api-gateway.sys:}",
    contextId = "ptCodeClient"           // ← 필수: 동일 서비스를 향하는 Feign Client가 복수일 때 충돌 방지
)
public interface PtCodeClient {

    @GetMapping("/pt-codes/pageable")
    PageResponse<PtCodeVO> findAllOnPageable(
            @RequestBody PageRequest<PtCodeSP> pageRequest);

    @PostMapping("/pt-codes")
    PtCodeVO save(@RequestBody PtCodeVO vo);

    @PutMapping("/pt-codes/{id}")
    PtCodeVO update(@PathVariable("id") String id, @RequestBody PtCodeVO vo);

    @DeleteMapping("/pt-codes/{id}")
    void delete(@PathVariable("id") String id);
}

// hera-webapp/.../pt/Pt0101ViewRouter.java
package com.dandisoft.hera.webapp.pt;

import com.dandisoft.hera.webapp.core.controller.BaseController;
import static com.dandisoft.hera.domain.code.Domain.PT_0101;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;

@Controller
@RequestMapping("/pt")
@RequiredArgsConstructor
public class Pt0101ViewRouter extends BaseController {

    @GetMapping("/0101")
    public String view(ModelMap model) throws Exception {
        prepareBaseInfo(model, PT_0101);
        return "pt/pt0101";
    }
}

<!-- hera-webapp/src/main/resources/templates/pt/pt0101.html -->
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org"
      xmlns:layout="http://www.ultraq.net.nz/thymeleaf/layout"
      layout:decorate="~{layout/base}">

<head>
    <title th:text="${pageTitle}">PT0101</title>
</head>

<body>
<section layout:fragment="content">

    <!-- 검색 영역 -->
    <div class="card card-search">
        <div class="card-body">
            <div class="row g-2">
                <div class="col-md-3">
                    <label class="form-label">코드</label>
                    <input type="text" id="searchCode" class="form-control form-control-sm">
                </div>
                <div class="col-md-3">
                    <label class="form-label">코드명</label>
                    <input type="text" id="searchName" class="form-control form-control-sm">
                </div>
                <div class="col-md-3">
                    <label class="form-label">사용여부</label>
                    <select id="searchUseYn" class="form-select form-select-sm">
                        <option value="">전체</option>
                        <option value="Y">사용</option>
                        <option value="N">미사용</option>
                    </select>
                </div>
                <div class="col-md-3 d-flex align-items-end">
                    <button id="btnSearch" class="btn btn-primary btn-sm">
                        <i class="bi bi-search"></i> 조회
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- 그리드 영역 -->
    <div class="card mt-2">
        <div class="card-header d-flex justify-content-between align-items-center">
            <span>코드 목록</span>
            <div>
                <button id="btnAdd"    class="btn btn-sm btn-success">추가</button>
                <button id="btnSave"   class="btn btn-sm btn-primary">저장</button>
                <button id="btnDelete" class="btn btn-sm btn-danger">삭제</button>
            </div>
        </div>
        <div class="card-body p-0">
            <div id="grid"></div>
        </div>
    </div>

</section>

<th:block layout:fragment="script">
    <script th:src="@{/js/pt/pt0101.js}"></script>
</th:block>

</body>
</html>

// hera-webapp/src/main/resources/static/js/pt/pt0101.js

const apiUrl = contextPath + '/api/sys';    // Webapp API Controller 경로

/* ── 조회 ─────────────────────────────── */
const findAll = (params) =>
    $.get(apiUrl + '/pt-codes/pageable', params, function (res) {
        grid.resetData(res.data);
    });

/* ── 그리드 초기화 ───────────────────── */
const grid = new tui.Grid({
    el        : document.getElementById('grid'),
    rowHeaders: ['checkbox'],
    columns   : [
        { header: '코드ID',  name: 'ptCodeId',  hidden: true },
        { header: '코드',    name: 'code',       editor: 'text' },
        { header: '코드명',  name: 'name',       editor: 'text' },
        { header: '사용여부', name: 'useYn',
          editor: { type: 'select', options: { listItems: [
              { text: '사용', value: 'Y' },
              { text: '미사용', value: 'N' }
          ]}}
        },
    ],
    pageOptions: { useClient: false, perPage: 20 },
});

/* ── 버튼 이벤트 ─────────────────────── */
$('#btnSearch').on('click', function () {
    const params = {
        'searchParam.code'   : $('#searchCode').val(),
        'searchParam.name'   : $('#searchName').val(),
        'searchParam.useYn'  : $('#searchUseYn').val(),
        page  : 1,
        size  : 20,
    };
    findAll(params);
});

$('#btnAdd').on('click', function () {
    grid.addRow({ useYn: 'Y' }, { at: 0 });
});

$('#btnSave').on('click', function () {
    const rows = grid.getModifiedRows();

    rows.createdRows.forEach(row => {
        $.post(apiUrl + '/pt-codes', JSON.stringify(row),
            () => findAll({}), 'json');
    });

    rows.updatedRows.forEach(row => {
        $.ajax({
            url    : apiUrl + '/pt-codes/' + row.ptCodeId,
            method : 'PUT',
            data   : JSON.stringify(row),
            contentType: 'application/json',
            success: () => findAll({}),
        });
    });
});

$('#btnDelete').on('click', function () {
    grid.getCheckedRows().forEach(row => {
        $.ajax({
            url    : apiUrl + '/pt-codes/' + row.ptCodeId,
            method : 'DELETE',
            success: () => findAll({}),
        });
    });
});

/* ── 페이지 로드 시 초기 조회 ─────────── */
$(document).ready(function () {
    findAll({});
});

// hera-webapp/.../pt/Pt0101ApiController.java
package com.dandisoft.hera.webapp.pt;

import com.dandisoft.hera.core.model.PageRequest;
import com.dandisoft.hera.core.model.PageResponse;
import com.dandisoft.hera.domain.data.pt.PtCodeSP;
import com.dandisoft.hera.domain.data.pt.PtCodeVO;
import com.dandisoft.hera.hera_api_client.pt.PtCodeClient;
import com.dandisoft.hera.hera_api_client.config.UrlConstant;
import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.*;

@RestController
@RequestMapping(UrlConstant.SYS_API)
@RequiredArgsConstructor
public class Pt0101ApiController {

    private final PtCodeClient ptCodeClient;

    @GetMapping("/pt-codes/pageable")
    public PageResponse<PtCodeVO> findAllOnPageable(
            PageRequest<PtCodeSP> pageRequest) {
        return ptCodeClient.findAllOnPageable(pageRequest);
    }

    @PostMapping("/pt-codes")
    public PtCodeVO save(@RequestBody PtCodeVO vo) {
        return ptCodeClient.save(vo);
    }

    @PutMapping("/pt-codes/{id}")
    public PtCodeVO update(@PathVariable String id, @RequestBody PtCodeVO vo) {
        return ptCodeClient.update(id, vo);
    }

    @DeleteMapping("/pt-codes/{id}")
    public void delete(@PathVariable String id) {
        ptCodeClient.delete(id);
    }
}

CREATE TABLE pt_code (
    pt_code_id  VARCHAR(36)  NOT NULL DEFAULT uuidv7(),
    code        VARCHAR(50)  NOT NULL,
    name        VARCHAR(200) NOT NULL,
    use_yn      CHAR(1)      NOT NULL DEFAULT 'Y',

    -- AuditModel 공통 컬럼 (AuditingEntityListener가 자동 채움)
    created_at  TIMESTAMP,
    created_by  VARCHAR(36),
    updated_at  TIMESTAMP,
    updated_by  VARCHAR(36),

    CONSTRAINT pk_pt_code PRIMARY KEY (pt_code_id)
);

COMMENT ON TABLE  pt_code           IS '가상 코드';
COMMENT ON COLUMN pt_code.pt_code_id IS 'PK';
COMMENT ON COLUMN pt_code.code       IS '코드';
COMMENT ON COLUMN pt_code.name       IS '코드명';
COMMENT ON COLUMN pt_code.use_yn     IS '사용여부 (Y/N)';

./gradlew build -x test

./gradlew :hera-webapp:bootRun