부동산 가격 조회 페이지 추가

[eunja511005]

• Any 오픈 메뉴 추가

• message.properties 파일에 메뉴ID에 해당하는 메뉴 이름 추가

• 서버 재시작 후 Admin 유저로 로그인

• 해당 메뉴 접속 하면 관리자 > 접근 제어 > 액션 제어 메뉴에서 조회됨 . 로그인 후 해당 메뉴 접속 해야 ZTHH_MENU_CTONTROL 테이블에 저장 됨

• 권한 설정 후 관리자 > 메뉴 > 메뉴 맵핑 메뉴에서 그냐 저장 한번 함 . 이때 서버 재시작 없이 메뉴 컨트롤 테이블 내용 다시 읽어서 접근 제어 업데이트 해 줌 . 그런데 현재 정상 동작 안하고 있는거 같음.

• 로그아웃해서 Any 유저로 접속하면 정상 접속안되어 서버 재시작 (결국 서버 재시작을 해 줘야 정상적으로 접근 제어에 재 등록되는거 같음)

[eunja511005]

Common Code 추가

각 지역별 코드 행정표준코드관리시스템([www.code.go.kr](http://www.code.go.kr/))의 법정동코드 10자리 중 앞 5자리

SELECT * FROM COMMON_CODE cc WHERE CODE_GROUP ='LAWCODE';

INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(138, 'LAWCODE', '41111', '장안구', '0', TIMESTAMP '2023-07-04 21:14:57.301304', TIMESTAMP '2023-07-04 21:14:57.301304', 3);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(143, 'LAWCODE', '11710', '송파구', '0', TIMESTAMP '2023-07-04 21:19:19.030097', TIMESTAMP '2023-07-04 21:19:19.030097', 8);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(145, 'LAWCODE', '11650', '서초구', '0', TIMESTAMP '2023-07-04 21:20:24.166940', TIMESTAMP '2023-07-04 21:20:24.166940', 10);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(137, 'LAWCODE', '41115', '팔달구', '0', TIMESTAMP '2023-07-04 10:04:29.098608', TIMESTAMP '2023-07-04 21:17:23.195161', 5);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(136, 'LAWCODE', '11110', '종로구', '0', TIMESTAMP '2023-07-04 10:03:16.872765', TIMESTAMP '2023-07-04 21:23:02.387230', 16);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(142, 'LAWCODE', '11680', '강남구', '0', TIMESTAMP '2023-07-04 21:18:49.896942', TIMESTAMP '2023-07-04 21:18:49.896942', 7);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(146, 'LAWCODE', '11620', '관악구', '0', TIMESTAMP '2023-07-04 21:20:49.458131', TIMESTAMP '2023-07-04 21:20:49.458131', 11);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(147, 'LAWCODE', '11590', '동작구', '0', TIMESTAMP '2023-07-04 21:21:11.994495', TIMESTAMP '2023-07-04 21:21:21.295827', 12);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(148, 'LAWCODE', '11560', '영등포구', '0', TIMESTAMP '2023-07-04 21:21:54.588405', TIMESTAMP '2023-07-04 21:21:54.588405', 13);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(149, 'LAWCODE', '11530', '구로구', '0', TIMESTAMP '2023-07-04 21:22:20.355711', TIMESTAMP '2023-07-04 21:22:20.355711', 14);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(150, 'LAWCODE', '11500', '강서구', '0', TIMESTAMP '2023-07-04 21:22:55.728367', TIMESTAMP '2023-07-04 21:22:55.728367', 15);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(151, 'LAWCODE', '11470', '양천구', '0', TIMESTAMP '2023-07-04 21:23:32.837379', TIMESTAMP '2023-07-04 21:23:32.837379', 17);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(152, 'LAWCODE', '11440', '마포구', '0', TIMESTAMP '2023-07-04 21:23:57.360151', TIMESTAMP '2023-07-04 21:23:57.360151', 18);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(153, 'LAWCODE', '11410', '서대문구', '0', TIMESTAMP '2023-07-04 21:24:24.099297', TIMESTAMP '2023-07-04 21:24:24.099297', 19);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(154, 'LAWCODE', '11380', '은평구', '0', TIMESTAMP '2023-07-04 21:24:47.904800', TIMESTAMP '2023-07-04 21:24:47.904800', 20);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(155, 'LAWCODE', '11350', '노원구', '0', TIMESTAMP '2023-07-04 21:25:08.366183', TIMESTAMP '2023-07-04 21:25:08.366183', 21);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(156, 'LAWCODE', '11320', '도봉구', '0', TIMESTAMP '2023-07-04 21:25:38.464024', TIMESTAMP '2023-07-04 21:25:38.464024', 22);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(157, 'LAWCODE', '11305', '강북구', '0', TIMESTAMP '2023-07-04 21:25:59.053808', TIMESTAMP '2023-07-04 21:25:59.053808', 23);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(158, 'LAWCODE', '11290', '성북구', '0', TIMESTAMP '2023-07-04 21:26:22.738684', TIMESTAMP '2023-07-04 21:26:22.738684', 24);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(159, 'LAWCODE', '11260', '중랑구', '0', TIMESTAMP '2023-07-04 21:26:51.769149', TIMESTAMP '2023-07-04 21:26:51.769149', 25);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(160, 'LAWCODE', '11230', '동대문', '0', TIMESTAMP '2023-07-04 21:27:27.800823', TIMESTAMP '2023-07-04 21:27:27.800823', 26);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(161, 'LAWCODE', '11215', '광진구', '0', TIMESTAMP '2023-07-04 21:27:45.794116', TIMESTAMP '2023-07-04 21:27:45.794116', 27);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(162, 'LAWCODE', '11200', '성동구', '0', TIMESTAMP '2023-07-04 21:28:12.165440', TIMESTAMP '2023-07-04 21:28:12.165440', 28);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(163, 'LAWCODE', '11170', '용산구', '0', TIMESTAMP '2023-07-04 21:28:38.296894', TIMESTAMP '2023-07-04 21:28:38.296894', 29);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(164, 'LAWCODE', '11140', '중구', '0', TIMESTAMP '2023-07-04 21:29:01.673939', TIMESTAMP '2023-07-04 21:29:01.673939', 30);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(139, 'LAWCODE', '41110', '수원시', '0', TIMESTAMP '2023-07-04 21:15:59.154316', TIMESTAMP '2023-07-04 21:17:13.730696', 2);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(140, 'LAWCODE', '41113', '권선구', '0', TIMESTAMP '2023-07-04 21:16:48.160243', TIMESTAMP '2023-07-04 21:17:19.561239', 4);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(141, 'LAWCODE', '41117', '영통구', '0', TIMESTAMP '2023-07-04 21:17:52.296480', TIMESTAMP '2023-07-04 21:17:52.296480', 6);
INSERT INTO WASADMIN.COMMON_CODE
(ID, CODE_GROUP, CODE, VALUE, DEL_YN, CREATED_AT, UPDATED_AT, CODE_ORDER)
VALUES(144, 'LAWCODE', '11740', '강동구', '0', TIMESTAMP '2023-07-04 21:19:51.340944', TIMESTAMP '2023-07-04 21:19:51.340944', 9);

---

---