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

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;

• Edit Server

DTO 추가

Controller

Mapper

• 생도 정보 구하기

 

테스트

Postman

프리리스트 생도 확인

Edit React Native App 

소스코드 적용