Request for modification so that all members can be searched without limiting the exposure of cadet information to subscribers when entering official records input screen

M64

Request for modification so that all members can be searched without limiting the exposure of cadet information to subscribers when entering official records input screen

ZEROWIN.ART 2022. 2. 20. 14:31

728x90

File name

Tab_exercise_official_record_send.js

Function

function

const textInputMilitaryNo = (val) => {

DB query

let tempUrl = url +'/tbuser/info/'+ val;

DB_tb_user_getInfo(tempUrl, null, auth_token)

    @GetMapping("/info/{military_no}") // êµ°ë²ì ë°ë¥¸ ìë ì ë³´
    public TbUserDTO getById(@PathVariable("military_no") String military_no) {
        System.out.println("military_no="+military_no);
        return tbUserMapper.getByMilitaryNo(military_no);
    }

@Select("select * from tb_user where military_no = #{military_no}")
TbUserDTO getByMilitaryNo(@Param("military_no") String military_no);

생도 기록 정보

-- official_fitness_record definition

-- Drop table

-- DROP TABLE official_fitness_record;

CREATE TABLE official_fitness_record (
record_no INTEGER DEFAULT NULL NOT NULL,
measure_date DATETIME DEFAULT NULL,
measure_type CHAR(1) DEFAULT NULL NOT NULL,
record_val INTEGER DEFAULT NULL NOT NULL,
confirm INTEGER DEFAULT NULL NOT NULL,
military_no VARCHAR(10) DEFAULT NULL,
fit_cd SMALLINT DEFAULT NULL NOT NULL,
exercise_cd SMALLINT DEFAULT NULL NOT NULL,
reg_dt DATETIME DEFAULT NULL NOT NULL,
edit_dt DATETIME DEFAULT NULL,
CONSTRAINT pk_fitness_record PRIMARY KEY (record_no)
);
CREATE INDEX official_fitness_record_military_no_idx ON official_fitness_record (military_no);

-- official_fitness_record foreign keys

ALTER TABLE official_fitness_record ADD CONSTRAINT fk_fitness_code_to_fitness_record FOREIGN KEY (fit_cd,exercise_cd) REFERENCES fitness_code(fit_cd,exercise_cd) ON DELETE RESTRICT ON UPDATE RESTRICT;

Tbuser

List of prospective candidates

tb_user_prelist

예비 대상자 리스트

생도 기록 추가 샘플

생도 DB PRELIST 파일

Spring boot

DB 추가 & 중복시 스킵

생도 프리리스트 추가

INSERT INTO tb_user_prelist
( military_no, user_nm, user_type, reg_dt)
VALUES(29992, 'torry', '0', now());

생도 공식 기록 추가

INSERT INTO official_fitness_record
(measure_date, measure_type, record_val, confirm, military_no, fit_cd, exercise_cd, reg_dt, edit_dt)
VALUES(now(), 0, 100, 1, 29992, 0, 0, now(), now());

생도 공식 기록 확인

select * from official_fitness_record order by reg_dt desc limit 10;