Index: pom.xml =================================================================== diff -u -rd774ff7bf7165a72f9807914bf1c0e97e93b26ac -r958b4e8e93dadaa78507bf6e066d019f733dc8c1 --- pom.xml (.../pom.xml) (revision d774ff7bf7165a72f9807914bf1c0e97e93b26ac) +++ pom.xml (.../pom.xml) (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -10,7 +10,7 @@ 4.0.0 313devgrp java-service-tree-framework-backend-server - 22.01.11 + 22.01.12 pom java-service-tree-framework Index: web-module/pom.xml =================================================================== diff -u -rd774ff7bf7165a72f9807914bf1c0e97e93b26ac -r958b4e8e93dadaa78507bf6e066d019f733dc8c1 --- web-module/pom.xml (.../pom.xml) (revision d774ff7bf7165a72f9807914bf1c0e97e93b26ac) +++ web-module/pom.xml (.../pom.xml) (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -7,7 +7,7 @@ 313devgrp java-service-tree-framework-backend-server - 22.01.11 + 22.01.12 ../pom.xml Index: web-module/script/ddl/oracle/egovframework/api/Arms_DeviceList_DDL_Oracle.sql =================================================================== diff -u --- web-module/script/ddl/oracle/egovframework/api/Arms_DeviceList_DDL_Oracle.sql (revision 0) +++ web-module/script/ddl/oracle/egovframework/api/Arms_DeviceList_DDL_Oracle.sql (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,120 @@ +CREATE TABLE T_ARMS_MONITOR_DEVICELIST_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_ARMS_MONITOR_DEVICELIST_LOG IS '기본 트리 스키마 트리거 로그'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_TYPE IS '노드 타입'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_METHOD IS '노드 변경 행위'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_DATE IS '노드 변경 시'; + +CREATE TABLE T_ARMS_MONITOR_DEVICELIST +( + 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), + + c_monitor_name VARCHAR2(4000 BYTE), + c_monitor_update_date VARCHAR2(4000 BYTE), + c_monitor_update_beatname VARCHAR2(4000 BYTE), + c_monitor_device_hostname VARCHAR2(4000 BYTE), + c_monitor_device_ip VARCHAR2(4000 BYTE), + + c_monitor_url_filebeat VARCHAR2(4000 BYTE), + c_monitor_url_packetbeat VARCHAR2(4000 BYTE), + c_monitor_url_heartbeat VARCHAR2(4000 BYTE), + c_monitor_url_metricbeat VARCHAR2(4000 BYTE), + c_monitor_url_topbeat VARCHAR2(4000 BYTE), + c_monitor_url_apm VARCHAR2(4000 BYTE), + c_monitor_url_scouter VARCHAR2(4000 BYTE), + + CONSTRAINT T_ARMS_MONITOR_DEVICELISTU_PK PRIMARY KEY (C_ID) +); + +COMMENT ON TABLE T_ARMS_MONITOR_DEVICELIST IS '기본 트리 스키마'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_TYPE IS '노드 타입'; + +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_name IS '모니터링 이름'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_update_date IS '모니터링 최초 업데이트 날짜'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_update_beatname IS '모니터링 데이터 푸쉬 에이전트 이름'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_device_hostname IS '모니터링 데이터 푸쉬 호스트 이름'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_device_ip IS '모니터링 데이터 푸쉬 아이피 주소'; + +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_filebeat IS '파일비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_packetbeat IS '패킷비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_heartbeat IS '하트비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_metricbeat IS '메트릭비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_topbeat IS '탑비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_apm IS '성능 모니터링 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_scouter IS '스카우터 모니터링 접속 주소'; + + +CREATE SEQUENCE S_ARMS_MONITOR_DEVICELIST + START WITH 10 + MAXVALUE 999999999999999999999999999 + MINVALUE 0 + NOCYCLE + CACHE 20 + NOORDER; + + +CREATE OR REPLACE TRIGGER "TG_ARMS_MONITOR_DEVICELIST" +BEFORE DELETE OR INSERT OR UPDATE +ON T_ARMS_MONITOR_DEVICELIST_LOG +REFERENCING NEW AS NEW OLD AS OLD +FOR EACH ROW +DECLARE +tmpVar NUMBER; +BEGIN + tmpVar := 0; + IF UPDATING THEN + insert into T_ARMS_MONITOR_DEVICELIST_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_ARMS_MONITOR_DEVICELIST_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_ARMS_MONITOR_DEVICELIST_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_ARMS_MONITOR_DEVICELIST_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 + RAISE; +END TG_ARMS_MONITOR_DEVICELIST; \ No newline at end of file Index: web-module/script/ddl/oracle/egovframework/api/Arms_PdServiceJira_DDL_Oracle.sql =================================================================== diff -u --- web-module/script/ddl/oracle/egovframework/api/Arms_PdServiceJira_DDL_Oracle.sql (revision 0) +++ web-module/script/ddl/oracle/egovframework/api/Arms_PdServiceJira_DDL_Oracle.sql (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,135 @@ +/* + * JsTree 추적 로그 테이블 + * 트리거 Log를 저장합니다. + */ +CREATE TABLE T_ARMS_PDSERVICEJIRA_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_ARMS_PDSERVICEJIRA_LOG IS '기본 트리 스키마 트리거 로그'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_TYPE IS '노드 타입'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_METHOD IS '노드 변경 행위'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA_LOG.C_DATE IS '노드 변경 시'; + +/* + * JsTree + */ +CREATE TABLE T_ARMS_PDSERVICEJIRA +( + 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_PDSERVICEJIRA_DETAIL VARCHAR2(4000 BYTE), + C_PDSERVICEJIRA_CON_NAME VARCHAR2(4000 BYTE), + C_PDSERVICEJIRA_CON_USER VARCHAR2(4000 BYTE), + C_PDSERVICEJIRA_CON_PASS VARCHAR2(4000 BYTE), + C_PDSERVICEJIRA_CON_TOKEN VARCHAR2(4000 BYTE), + C_PDSERVICEJIRA_CON_JQL VARCHAR2(4000 BYTE), + CONSTRAINT T_ARMS_PDSERVICEJIRA_PK PRIMARY KEY (C_ID) + /* + * CONSTRAINT T_ARMS_PDSERVICEJIRA_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_ARMS_PDSERVICEJIRA(C_ID) ON DELETE CASCADE + */ +); + +COMMENT ON TABLE T_ARMS_PDSERVICEJIRA IS '기본 트리 스키마'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_ARMS_PDSERVICEJIRA.C_TYPE IS '노드 타입'; + +/* + * 인덱스는 되도록 걸지 말것. + * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_ARMS_PDSERVICEJIRA + * ("C_ID" ASC) + */ + /* +*DROP SEQUENCE S_ARMS_PDSERVICEJIRA; + */ +CREATE SEQUENCE S_ARMS_PDSERVICEJIRA + START WITH 10 + MAXVALUE 999999999999999999999999999 + MINVALUE 0 + NOCYCLE + CACHE 20 + NOORDER; + +/* + * JsTree 트리거 + */ +CREATE OR REPLACE TRIGGER "TRIGGER_ARMS_PDSERVICEJIRA" +BEFORE DELETE OR INSERT OR UPDATE +ON T_ARMS_PDSERVICEJIRA +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_ARMS_PDSERVICEJIRA (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_ARMS_PDSERVICEJIRA_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_ARMS_PDSERVICEJIRA_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_ARMS_PDSERVICEJIRA_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_ARMS_PDSERVICEJIRA_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_ARMS_PDSERVICEJIRA; +/ \ No newline at end of file Index: web-module/script/ddl/oracle/egovframework/api/Arms_PdService_DDL_Oracle.sql =================================================================== diff -u --- web-module/script/ddl/oracle/egovframework/api/Arms_PdService_DDL_Oracle.sql (revision 0) +++ web-module/script/ddl/oracle/egovframework/api/Arms_PdService_DDL_Oracle.sql (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,130 @@ +/* + * JsTree 추적 로그 테이블 + * 트리거 Log를 저장합니다. + */ +CREATE TABLE T_ARMS_PDSERVICE_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_ARMS_PDSERVICE_LOG IS '기본 트리 스키마 트리거 로그'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_TYPE IS '노드 타입'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_METHOD IS '노드 변경 행위'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)'; +COMMENT ON COLUMN T_ARMS_PDSERVICE_LOG.C_DATE IS '노드 변경 시'; + +/* + * JsTree + */ +CREATE TABLE T_ARMS_PDSERVICE +( + 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_PDSERVICE_DETAIL VARCHAR2(4000 BYTE), + CONSTRAINT T_ARMS_PDSERVICE_PK PRIMARY KEY (C_ID) + /* + * CONSTRAINT T_ARMS_PDSERVICE_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_ARMS_PDSERVICE(C_ID) ON DELETE CASCADE + */ +); + +COMMENT ON TABLE T_ARMS_PDSERVICE IS '기본 트리 스키마'; +COMMENT ON COLUMN T_ARMS_PDSERVICE.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_ARMS_PDSERVICE.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_ARMS_PDSERVICE.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_ARMS_PDSERVICE.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_PDSERVICE.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_PDSERVICE.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_ARMS_PDSERVICE.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_ARMS_PDSERVICE.C_TYPE IS '노드 타입'; + +/* + * 인덱스는 되도록 걸지 말것. + * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_ARMS_PDSERVICE + * ("C_ID" ASC) + */ + /* +*DROP SEQUENCE S_ARMS_PDSERVICE; + */ +CREATE SEQUENCE S_ARMS_PDSERVICE + START WITH 10 + MAXVALUE 999999999999999999999999999 + MINVALUE 0 + NOCYCLE + CACHE 20 + NOORDER; + +/* + * JsTree 트리거 + */ +CREATE OR REPLACE TRIGGER "TRIGGER_TREE_HIBER" +BEFORE DELETE OR INSERT OR UPDATE +ON T_ARMS_PDSERVICE +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_ARMS_PDSERVICE (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_ARMS_PDSERVICE_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_ARMS_PDSERVICE_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_ARMS_PDSERVICE_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_ARMS_PDSERVICE_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_HIBER; +/ \ No newline at end of file Index: web-module/script/dml/oracle/egovframework/api/Arms_DeviceList_DML_Oracle.sql =================================================================== diff -u --- web-module/script/dml/oracle/egovframework/api/Arms_DeviceList_DML_Oracle.sql (revision 0) +++ web-module/script/dml/oracle/egovframework/api/Arms_DeviceList_DML_Oracle.sql (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,49 @@ +Insert into T_ARMS_MONITOR_DEVICELIST + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, + c_monitor_name, c_monitor_update_date, c_monitor_update_beatname, c_monitor_device_hostname, c_monitor_device_ip, + c_monitor_url_filebeat, c_monitor_url_packetbeat, c_monitor_url_heartbeat, c_monitor_url_metricbeat, + c_monitor_url_topbeat, c_monitor_url_apm, c_monitor_url_scouter) +Values + (1, 0, 0, 1, 8, + 0, 'Root Node', 'root', + 'c_monitor_name', 'c_monitor_update_date', 'c_monitor_update_beatname', 'c_monitor_device_hostname', 'c_monitor_device_ip', + 'c_monitor_url_filebeat', 'c_monitor_url_packetbeat', 'c_monitor_url_heartbeat', 'c_monitor_url_metricbeat', + 'c_monitor_url_topbeat', 'c_monitor_url_apm', 'c_monitor_url_scouter'); +Insert into T_ARMS_MONITOR_DEVICELIST + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, + c_monitor_name, c_monitor_update_date, c_monitor_update_beatname, c_monitor_device_hostname, c_monitor_device_ip, + c_monitor_url_filebeat, c_monitor_url_packetbeat, c_monitor_url_heartbeat, c_monitor_url_metricbeat, + c_monitor_url_topbeat, c_monitor_url_apm, c_monitor_url_scouter) +Values + (2, 1, 0, 2, 7, + 1, 'First Child', 'drive', + 'c_monitor_name', 'c_monitor_update_date', 'c_monitor_update_beatname', 'c_monitor_device_hostname', 'c_monitor_device_ip', + 'c_monitor_url_filebeat', 'c_monitor_url_packetbeat', 'c_monitor_url_heartbeat', 'c_monitor_url_metricbeat', + 'c_monitor_url_topbeat', 'c_monitor_url_apm', 'c_monitor_url_scouter'); +Insert into T_ARMS_MONITOR_DEVICELIST + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, + c_monitor_name, c_monitor_update_date, c_monitor_update_beatname, c_monitor_device_hostname, c_monitor_device_ip, + c_monitor_url_filebeat, c_monitor_url_packetbeat, c_monitor_url_heartbeat, c_monitor_url_metricbeat, + c_monitor_url_topbeat, c_monitor_url_apm, c_monitor_url_scouter) +Values + (3, 2, 0, 3, 4, + 2, 'Leaf Node', 'default', + 'c_monitor_name', 'c_monitor_update_date', 'c_monitor_update_beatname', 'c_monitor_device_hostname', 'c_monitor_device_ip', + 'c_monitor_url_filebeat', 'c_monitor_url_packetbeat', 'c_monitor_url_heartbeat', 'c_monitor_url_metricbeat', + 'c_monitor_url_topbeat', 'c_monitor_url_apm', 'c_monitor_url_scouter'); +Insert into T_ARMS_MONITOR_DEVICELIST + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, + c_monitor_name, c_monitor_update_date, c_monitor_update_beatname, c_monitor_device_hostname, c_monitor_device_ip, + c_monitor_url_filebeat, c_monitor_url_packetbeat, c_monitor_url_heartbeat, c_monitor_url_metricbeat, + c_monitor_url_topbeat, c_monitor_url_apm, c_monitor_url_scouter) +Values + (4, 2, 1, 5, 6, + 2, 'Branch Node', 'folder', + 'c_monitor_name', 'c_monitor_update_date', 'c_monitor_update_beatname', 'c_monitor_device_hostname', 'c_monitor_device_ip', + 'c_monitor_url_filebeat', 'c_monitor_url_packetbeat', 'c_monitor_url_heartbeat', 'c_monitor_url_metricbeat', + 'c_monitor_url_topbeat', 'c_monitor_url_apm', 'c_monitor_url_scouter'); +COMMIT; \ No newline at end of file Index: web-module/script/dml/oracle/egovframework/api/Arms_PdServiceJira_DML_Oracle.sql =================================================================== diff -u --- web-module/script/dml/oracle/egovframework/api/Arms_PdServiceJira_DML_Oracle.sql (revision 0) +++ web-module/script/dml/oracle/egovframework/api/Arms_PdServiceJira_DML_Oracle.sql (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,25 @@ +Insert into T_ARMS_PDSERVICEJIRA + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE) +Values + (1, 0, 0, 1, 8, + 0, 'Root Node', 'root'); +Insert into T_ARMS_PDSERVICEJIRA + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE) +Values + (2, 1, 0, 2, 7, + 1, 'First Child', 'drive'); +Insert into T_ARMS_PDSERVICEJIRA + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE) +Values + (3, 2, 0, 3, 4, + 2, 'Leaf Node', 'default'); +Insert into T_ARMS_PDSERVICEJIRA + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE) +Values + (4, 2, 1, 5, 6, + 2, 'Branch Node', 'folder'); +COMMIT; \ No newline at end of file Index: web-module/script/dml/oracle/egovframework/api/Arms_PdService_DML_Oracle.sql =================================================================== diff -u --- web-module/script/dml/oracle/egovframework/api/Arms_PdService_DML_Oracle.sql (revision 0) +++ web-module/script/dml/oracle/egovframework/api/Arms_PdService_DML_Oracle.sql (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,25 @@ +Insert into T_ARMS_PDSERVICE + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE) +Values + (1, 0, 0, 1, 8, + 0, 'Root Node', 'root'); +Insert into T_ARMS_PDSERVICE + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE) +Values + (2, 1, 0, 2, 7, + 1, 'First Child', 'drive'); +Insert into T_ARMS_PDSERVICE + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE) +Values + (3, 2, 0, 3, 4, + 2, 'Leaf Node', 'default'); +Insert into T_ARMS_PDSERVICE + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE) +Values + (4, 2, 1, 5, 6, + 2, 'Branch Node', 'folder'); +COMMIT; \ No newline at end of file Index: web-module/script/yml/monitoring/server/allinone/fluent.conf =================================================================== diff -u --- web-module/script/yml/monitoring/server/allinone/fluent.conf (revision 0) +++ web-module/script/yml/monitoring/server/allinone/fluent.conf (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,47 @@ + + log_level debug + workers 2 + + + + @type forward + port 24224 + bind 0.0.0.0 + + + + @type record_transformer + + hostname "#{Socket.gethostname}" + tag ${tag} + stack_name ${tag_parts[1]} + service_name ${tag_parts[2]} + fluentd_hostname "#{ENV['FLUENTD_HOSTNAME']}" + + + + + @type copy + + @type elasticsearch + host es-coordinating + port 9200 + logstash_format true + logstash_prefix fluentd + logstash_dateformat %Y.%m.%d + time_key_exclud_timestamp false + time_key ts + time_key_format %Y-%m-%dT%H:%M:%S.%NZ + time_precision 6 + include_tag_key true + type_name access_log + tag_key @log_name + + flush_interval 1s + flush_thread_count 2 + + + + @type stdout + + Index: web-module/src/main/java/egovframework/api/arms/pdService/controller/AdminPdServiceController.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdService/controller/AdminPdServiceController.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdService/controller/AdminPdServiceController.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,4 @@ +package egovframework.api.arms.pdService.controller; + +public class AdminPdServiceController { +} Index: web-module/src/main/java/egovframework/api/arms/pdService/controller/AnonPdServiceController.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdService/controller/AnonPdServiceController.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdService/controller/AnonPdServiceController.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,4 @@ +package egovframework.api.arms.pdService.controller; + +public class AnonPdServiceController { +} Index: web-module/src/main/java/egovframework/api/arms/pdService/controller/UserPdServiceController.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdService/controller/UserPdServiceController.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdService/controller/UserPdServiceController.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,113 @@ +package egovframework.api.arms.pdService.controller; + +import egovframework.api.arms.menu.vo.MenuDTO; +import egovframework.api.arms.pdService.model.PdServiceDTO; +import egovframework.api.arms.pdService.service.PdService; +import egovframework.com.ext.jstree.springHibernate.core.controller.SHVAbstractController; +import egovframework.com.utl.fcc.service.EgovFileUploadUtil; +import egovframework.com.utl.fcc.service.EgovFormBasedFileVo; +import org.hibernate.criterion.Order; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Qualifier; +import org.springframework.stereotype.Controller; +import org.springframework.ui.Model; +import org.springframework.ui.ModelMap; +import org.springframework.validation.BindingResult; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RequestMethod; +import org.springframework.web.bind.annotation.RequestParam; +import org.springframework.web.bind.annotation.ResponseBody; +import org.springframework.web.servlet.ModelAndView; + +import javax.annotation.PostConstruct; +import javax.servlet.http.HttpServletRequest; +import java.util.Comparator; +import java.util.List; +import java.util.NoSuchElementException; + +@Controller +@RequestMapping(value = {"/auth-user/api/arms/pdService"}) +public class UserPdServiceController extends SHVAbstractController { + + @Autowired + @Qualifier("PdService") + private PdService pdService; + + @PostConstruct + public void initialize() { + setJsTreeHibernateService(pdService); + } + + private final Logger logger = LoggerFactory.getLogger(this.getClass()); + + private static final Long ROOT_NODE_ID = new Long(2); + private static final String NODE_TYPE = new String("default"); + + @ResponseBody + @RequestMapping(value = "/addEndNodeByRoot.do", method = RequestMethod.POST) + public ModelAndView addEndNodeByRoot(PdServiceDTO pdServiceDTO, + BindingResult bindingResult) throws Exception { + if (bindingResult.hasErrors()) + throw new RuntimeException(); + + //루트 노드를 기준으로 리스트를 검색 + PdServiceDTO paramPdServiceDTO = new PdServiceDTO(); + paramPdServiceDTO.setWhere("c_parentid", ROOT_NODE_ID); + List list = pdService.getChildNode(paramPdServiceDTO); + + //검색된 노드중 maxPosition을 찾는다. + PdServiceDTO maxPositionPdServiceDTO = list + .stream() + .max(Comparator.comparing(PdServiceDTO::getC_position)) + .orElseThrow(NoSuchElementException::new); + + logger.info("=======" + maxPositionPdServiceDTO); + + //노드 값 셋팅 + pdServiceDTO.setRef(ROOT_NODE_ID); + pdServiceDTO.setC_position(maxPositionPdServiceDTO.getC_position() + 1); + pdServiceDTO.setC_type(NODE_TYPE); + + ModelAndView modelAndView = new ModelAndView("jsonView"); + modelAndView.addObject("result", pdService.addNode(pdServiceDTO)); + + return modelAndView; + } + + /** + * 이미지 Upload를 처리한다. + * + * @param request + * @param model + * @return + * @throws Exception + */ + @RequestMapping(value="/uploadFileToNode.do", method=RequestMethod.POST) + public String uploadFileToNode(HttpServletRequest request, Model model) throws Exception { + // Spring multipartResolver 미사용 시 (commons-fileupload 활용) + //List list = EgovFormBasedFileUtil.uploadFiles(request, uploadDir, maxFileSize); + + // Spring multipartResolver 사용시 + String uploadDir = ""; + long maxFileSize = new Long(313); + List list = EgovFileUploadUtil.uploadFiles(request, uploadDir, maxFileSize); + + if (list.size() > 0) { + EgovFormBasedFileVo vo = list.get(0); // 첫번째 이미지 + + String url = request.getContextPath() + + "/utl/web/imageSrc.do?" + + "path=" + vo.getServerSubPath() + + "&physical=" + vo.getPhysicalName() + + "&contentType=" + vo.getContentType(); + + //model.addAttribute("CKEditorFuncNum", request.getParameter("CKEditorFuncNum")); + model.addAttribute("url", url); + } + + return "egovframework/com/utl/wed/EgovInsertImage"; + } + +} Index: web-module/src/main/java/egovframework/api/arms/pdService/model/PdServiceDTO.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdService/model/PdServiceDTO.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdService/model/PdServiceDTO.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,75 @@ +package egovframework.api.arms.pdService.model; + +import egovframework.com.ext.jstree.springHibernate.core.vo.JsTreeHibernateDTO; +import egovframework.com.ext.jstree.springHibernate.core.vo.JsTreeHibernateSearchDTO; +import org.hibernate.annotations.*; +import org.hibernate.annotations.Cache; + +import javax.persistence.*; +import javax.persistence.Entity; +import javax.persistence.Table; +import java.io.Serializable; + +@Entity +@Table(name = "T_ARMS_PDSERVICE") +@SelectBeforeUpdate(value=true) +@DynamicInsert(value=true) +@DynamicUpdate(value=true) +@Cache(usage = CacheConcurrencyStrategy.READ_WRITE) +@SequenceGenerator(name = "JsTreeSequence", sequenceName = "S_ARMS_PDSERVICE", allocationSize = 1) +public class PdServiceDTO extends JsTreeHibernateSearchDTO implements Serializable { + + private static final long serialVersionUID = -6859122566734590165L; + + public PdServiceDTO() { + super(); + } + + public PdServiceDTO(Boolean copyBooleanValue) { + super(); + this.copyBooleanValue = copyBooleanValue; + } + + //@Getter @Setter + + @Column(name = "c_pdservice_detail") + private String c_pdservice_detail; + + public String getC_pdservice_detail() { + return c_pdservice_detail; + } + + public void setC_pdservice_detail(String c_pdservice_detail) { + this.c_pdservice_detail = c_pdservice_detail; + } + + /* + * Extend Bean Field + */ + private Boolean copyBooleanValue; + + @Transient + public Boolean getCopyBooleanValue() { + copyBooleanValue = false; + if (this.getCopy() == 0) { + copyBooleanValue = false; + } else { + copyBooleanValue = true; + } + return copyBooleanValue; + } + + public void setCopyBooleanValue(Boolean copyBooleanValue) { + this.copyBooleanValue = copyBooleanValue; + } + + @Override + public void setFieldFromNewInstance(T paramInstance) { + if( paramInstance instanceof JsTreeHibernateDTO){ + if(paramInstance.isCopied()) { + this.setC_title("copy_" + this.getC_title()); + } + } + } + +} Index: web-module/src/main/java/egovframework/api/arms/pdService/model/PdServiceVO.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdService/model/PdServiceVO.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdService/model/PdServiceVO.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,4 @@ +package egovframework.api.arms.pdService.model; + +public class PdServiceVO { +} Index: web-module/src/main/java/egovframework/api/arms/pdService/service/PdService.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdService/service/PdService.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdService/service/PdService.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,7 @@ +package egovframework.api.arms.pdService.service; + +import egovframework.com.ext.jstree.springHibernate.core.service.JsTreeHibernateService; + +public interface PdService extends JsTreeHibernateService { + +} Index: web-module/src/main/java/egovframework/api/arms/pdService/service/PdServiceImpl.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdService/service/PdServiceImpl.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdService/service/PdServiceImpl.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,9 @@ +package egovframework.api.arms.pdService.service; + +import egovframework.com.ext.jstree.springHibernate.core.service.JsTreeHibernateServiceImpl; +import org.springframework.stereotype.Service; + +@Service("PdService") +public class PdServiceImpl extends JsTreeHibernateServiceImpl implements PdService{ + +} Index: web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/AdminPdServiceJiraController.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/AdminPdServiceJiraController.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/AdminPdServiceJiraController.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,4 @@ +package egovframework.api.arms.pdServiceJira.controller; + +public class AdminPdServiceJiraController { +} Index: web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/AnonPdServiceJiraController.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/AnonPdServiceJiraController.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/AnonPdServiceJiraController.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,4 @@ +package egovframework.api.arms.pdServiceJira.controller; + +public class AnonPdServiceJiraController { +} Index: web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/UserPdServiceJiraController.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/UserPdServiceJiraController.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdServiceJira/controller/UserPdServiceJiraController.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,52 @@ +package egovframework.api.arms.pdServiceJira.controller; + +import egovframework.api.arms.pdService.model.PdServiceDTO; +import egovframework.api.arms.pdServiceJira.model.PdServiceJiraDTO; +import egovframework.api.arms.pdServiceJira.service.PdServiceJira; +import egovframework.com.ext.jstree.springHibernate.core.controller.SHVAbstractController; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Qualifier; +import org.springframework.stereotype.Controller; +import org.springframework.validation.BindingResult; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RequestMethod; +import org.springframework.web.bind.annotation.ResponseBody; +import org.springframework.web.servlet.ModelAndView; + +import javax.annotation.PostConstruct; +import java.util.Comparator; +import java.util.List; +import java.util.NoSuchElementException; + +@Controller +@RequestMapping(value = {"/auth-user/api/arms/pdServiceJira"}) +public class UserPdServiceJiraController extends SHVAbstractController { + + @Autowired + @Qualifier("PdServiceJira") + private PdServiceJira pdServiceJira; + + @PostConstruct + public void initialize() { + setJsTreeHibernateService(pdServiceJira); + } + + private final Logger logger = LoggerFactory.getLogger(this.getClass()); + + @ResponseBody + @RequestMapping(value = "/getTestConnectionJira.do", method = RequestMethod.POST) + public ModelAndView addEndNodeByRoot(PdServiceJiraDTO pdServiceJiraDTO, + BindingResult bindingResult) throws Exception { + if (bindingResult.hasErrors()) + throw new RuntimeException(); + + + + ModelAndView modelAndView = new ModelAndView("jsonView"); + modelAndView.addObject("result", ""); + + return modelAndView; + } +} Index: web-module/src/main/java/egovframework/api/arms/pdServiceJira/model/PdServiceJiraDTO.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdServiceJira/model/PdServiceJiraDTO.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdServiceJira/model/PdServiceJiraDTO.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,111 @@ +package egovframework.api.arms.pdServiceJira.model; + +import egovframework.com.cmm.util.string.StringUtil; +import egovframework.com.ext.jstree.springHibernate.core.vo.JsTreeHibernateDTO; +import egovframework.com.ext.jstree.springHibernate.core.vo.JsTreeHibernateSearchDTO; +import lombok.Getter; +import lombok.Setter; +import org.apache.commons.lang.StringUtils; +import org.hibernate.annotations.*; +import org.hibernate.annotations.Cache; + +import javax.persistence.*; +import javax.persistence.Entity; +import javax.persistence.Table; +import java.io.Serializable; + +@Entity +@Table(name = "T_ARMS_PDSERVICEJIRA") +@SelectBeforeUpdate(value=true) +@DynamicInsert(value=true) +@DynamicUpdate(value=true) +@Cache(usage = CacheConcurrencyStrategy.READ_WRITE) +@SequenceGenerator(name = "JsTreeSequence", sequenceName = "S_ARMS_PDSERVICEJIRA", allocationSize = 1) +public class PdServiceJiraDTO extends JsTreeHibernateSearchDTO implements Serializable { + + private static final long serialVersionUID = -6859122566734590165L; + + public PdServiceJiraDTO() { + super(); + } + + public PdServiceJiraDTO(Boolean copyBooleanValue) { + super(); + this.copyBooleanValue = copyBooleanValue; + } + + @Getter @Setter + @Column(name = "c_pdservicejira_detail") + private String c_pdservicejira_detail; + + @Getter @Setter + @Column(name = "c_pdservicejira_con_name") + private String c_pdservicejira_con_name; + + @Getter @Setter + @Column(name = "c_pdservicejira_con_user") + private String c_pdservicejira_con_user; + + @Getter @Setter + @Column(name = "c_pdservicejira_con_pass") + private String c_pdservicejira_con_pass; + + @Getter @Setter + @Column(name = "c_pdservicejira_con_token") + private String c_pdservicejira_con_token; + + @Getter @Setter + @Column(name = "c_pdservicejira_con_jql") + private String c_pdservicejira_con_jql; + + + /* + * Extend Bean Field + */ + private Boolean jiraConPassMode; + + @Transient + public Boolean getJiraConPassMode() { + jiraConPassMode = false; + if (StringUtils.isEmpty(c_pdservicejira_con_pass)) { + jiraConPassMode = false; + } else { + jiraConPassMode = true; + } + return jiraConPassMode; + } + + public void setJiraConPassMode(Boolean jiraConPassMode) { + this.jiraConPassMode = jiraConPassMode; + } + + /* + * Extend Bean Field + */ + private Boolean copyBooleanValue; + + @Transient + public Boolean getCopyBooleanValue() { + copyBooleanValue = false; + if (this.getCopy() == 0) { + copyBooleanValue = false; + } else { + copyBooleanValue = true; + } + return copyBooleanValue; + } + + public void setCopyBooleanValue(Boolean copyBooleanValue) { + this.copyBooleanValue = copyBooleanValue; + } + + @Override + public void setFieldFromNewInstance(T paramInstance) { + if( paramInstance instanceof JsTreeHibernateDTO){ + if(paramInstance.isCopied()) { + this.setC_title("copy_" + this.getC_title()); + } + } + } + +} Index: web-module/src/main/java/egovframework/api/arms/pdServiceJira/model/PdServiceJiraVO.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdServiceJira/model/PdServiceJiraVO.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdServiceJira/model/PdServiceJiraVO.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,4 @@ +package egovframework.api.arms.pdServiceJira.model; + +public class PdServiceJiraVO { +} Index: web-module/src/main/java/egovframework/api/arms/pdServiceJira/service/PdServiceJira.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdServiceJira/service/PdServiceJira.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdServiceJira/service/PdServiceJira.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,7 @@ +package egovframework.api.arms.pdServiceJira.service; + +import egovframework.com.ext.jstree.springHibernate.core.service.JsTreeHibernateService; + +public interface PdServiceJira extends JsTreeHibernateService { + +} Index: web-module/src/main/java/egovframework/api/arms/pdServiceJira/service/PdServiceJiraImpl.java =================================================================== diff -u --- web-module/src/main/java/egovframework/api/arms/pdServiceJira/service/PdServiceJiraImpl.java (revision 0) +++ web-module/src/main/java/egovframework/api/arms/pdServiceJira/service/PdServiceJiraImpl.java (revision 958b4e8e93dadaa78507bf6e066d019f733dc8c1) @@ -0,0 +1,9 @@ +package egovframework.api.arms.pdServiceJira.service; + +import egovframework.com.ext.jstree.springHibernate.core.service.JsTreeHibernateServiceImpl; +import org.springframework.stereotype.Service; + +@Service("PdServiceJira") +public class PdServiceJiraImpl extends JsTreeHibernateServiceImpl implements PdServiceJira { + +}