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