Index: pom.xml =================================================================== diff -u -r1e186118efb1dc91159fccd5c3aca7478ca78712 -rc3f0e0d5981e3098c59e76eef051db5ca40b46ff --- pom.xml (.../pom.xml) (revision 1e186118efb1dc91159fccd5c3aca7478ca78712) +++ pom.xml (.../pom.xml) (revision c3f0e0d5981e3098c59e76eef051db5ca40b46ff) @@ -10,7 +10,7 @@ 4.0.0 313devgrp standard-project - 20.09.15 + 20.10.01 pom standard-project Index: web-module/pom.xml =================================================================== diff -u -r1e186118efb1dc91159fccd5c3aca7478ca78712 -rc3f0e0d5981e3098c59e76eef051db5ca40b46ff --- web-module/pom.xml (.../pom.xml) (revision 1e186118efb1dc91159fccd5c3aca7478ca78712) +++ web-module/pom.xml (.../pom.xml) (revision c3f0e0d5981e3098c59e76eef051db5ca40b46ff) @@ -7,7 +7,7 @@ 313devgrp standard-project - 20.09.15 + 20.10.01 ../pom.xml @@ -114,7 +114,7 @@ 313devgrp scouter - 2.8.1 + 2.8.2 jar false ${project.build.directory} Index: web-module/script/ddl/oracle/egovframework/api/Monitor_DDL_Oracle.sql =================================================================== diff -u --- web-module/script/ddl/oracle/egovframework/api/Monitor_DDL_Oracle.sql (revision 0) +++ web-module/script/ddl/oracle/egovframework/api/Monitor_DDL_Oracle.sql (revision c3f0e0d5981e3098c59e76eef051db5ca40b46ff) @@ -0,0 +1,130 @@ +/* + * JsTree 추적 로그 테이블 + * 트리거 Log를 저장합니다. + */ +CREATE TABLE T_JSTREE_MONITOR_LOG +( + C_ID NUMBER NOT NULL, + C_PARENTID NUMBER NOT NULL, + C_POSITION NUMBER NOT NULL, + C_LEFT NUMBER NOT NULL, + C_RIGHT NUMBER NOT NULL, + C_LEVEL NUMBER NOT NULL, + C_TITLE VARCHAR2(4000 BYTE), + C_TYPE VARCHAR2(4000 BYTE), + C_METHOD VARCHAR2(4000 BYTE), + C_STATE VARCHAR2(4000 BYTE), + C_DATE DATE NOT NULL +); + +COMMENT ON TABLE T_JSTREE_MONITOR_LOG IS '기본 트리 스키마 트리거 로그'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_TYPE IS '노드 타입'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_METHOD IS '노드 변경 행위'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_DATE IS '노드 변경 시'; + +/* + * JsTree + */ +CREATE TABLE T_JSTREE_MONITOR +( + C_ID NUMBER NOT NULL, + C_PARENTID NUMBER NOT NULL, + C_POSITION NUMBER NOT NULL, + C_LEFT NUMBER NOT NULL, + C_RIGHT NUMBER NOT NULL, + C_LEVEL NUMBER NOT NULL, + C_TITLE VARCHAR2(4000 BYTE), + C_TYPE VARCHAR2(4000 BYTE), + C_LINK VARCHAR2(4000 BYTE), + CONSTRAINT T_JSTREE_MONITOR_PK PRIMARY KEY (C_ID) + /* + * CONSTRAINT T_JSTREE_MONITOR_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_JSTREE_MONITOR(C_ID) ON DELETE CASCADE + */ +); + +COMMENT ON TABLE T_JSTREE_MONITOR IS '기본 트리 스키마'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_TYPE IS '노드 타입'; + +/* + * 인덱스는 되도록 걸지 말것. + * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_JSTREE_MONITOR + * ("C_ID" ASC) + */ + /* +*DROP SEQUENCE S_JSTREE_MONITOR; + */ +CREATE SEQUENCE S_JSTREE_MONITOR + START WITH 10 + MAXVALUE 999999999999999999999999999 + MINVALUE 0 + NOCYCLE + CACHE 20 + NOORDER; + +/* + * JsTree 트리거 + */ +CREATE OR REPLACE TRIGGER "TRIGGER_TREE_MONITOR" +BEFORE DELETE OR INSERT OR UPDATE +ON T_JSTREE_MONITOR +REFERENCING NEW AS NEW OLD AS OLD +FOR EACH ROW +DECLARE +tmpVar NUMBER; +/****************************************************************************** + NAME: TRIGGER_COMPREHENSIVETREE + PURPOSE: + + REVISIONS: + Ver Date Author Description + --------- ---------- --------------- ------------------------------------ + 1.0 2012-08-29 1. Created this trigger. + + NOTES: + + Automatically available Auto Replace Keywords: + Object Name: TRIGGER_COMPREHENSIVETREE + Sysdate: 2012-08-29 + Date and Time: 2012-08-29, 오후 5:26:44, and 2012-08-29 오후 5:26:44 + Username: (set in TOAD Options, Proc Templates) + Table Name: T_JSTREE_MONITOR (set in the "New PL/SQL Object" dialog) + Trigger Options: (set in the "New PL/SQL Object" dialog) +******************************************************************************/ +BEGIN + tmpVar := 0; + IF UPDATING THEN + insert into T_JSTREE_MONITOR_LOG + values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate); + insert into T_JSTREE_MONITOR_LOG + values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate); + END IF; + IF DELETING THEN + insert into T_JSTREE_MONITOR_LOG + values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate); + END IF; + IF INSERTING THEN + insert into T_JSTREE_MONITOR_LOG + values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate); + END IF; + + EXCEPTION + WHEN OTHERS THEN + -- Consider logging the error and then re-raise + RAISE; +END TRIGGER_TREE_MONITOR; +/ \ No newline at end of file Index: web-module/script/dml/oracle/egovframework/api/Monitor_DML_ORacle.sql =================================================================== diff -u --- web-module/script/dml/oracle/egovframework/api/Monitor_DML_ORacle.sql (revision 0) +++ web-module/script/dml/oracle/egovframework/api/Monitor_DML_ORacle.sql (revision c3f0e0d5981e3098c59e76eef051db5ca40b46ff) @@ -0,0 +1,25 @@ +Insert into T_JSTREE_MONITOR + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (1, 0, 0, 1, 8, + 0, 'Root Node', 'root', 'blank_url'); +Insert into T_JSTREE_MONITOR + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (2, 1, 0, 2, 7, + 1, 'First Child', 'drive', 'blank_url'); +Insert into T_JSTREE_MONITOR + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (3, 2, 0, 3, 4, + 2, 'Leaf Node', 'default', 'blank_url'); +Insert into T_JSTREE_MONITOR + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (4, 2, 1, 5, 6, + 2, 'Branch Node', 'folder', 'blank_url'); +COMMIT; \ No newline at end of file