Index: .classpath =================================================================== diff -u --- .classpath (revision 0) +++ .classpath (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,5 @@ + + + + + Index: .idea/sonarIssues.xml =================================================================== diff -u -rab75504e01d2637d6caed5809db4dc598757a90f -r1e4e7228e282b9ec53b7bb0eb4642b2fece30f47 --- .idea/sonarIssues.xml (.../sonarIssues.xml) (revision ab75504e01d2637d6caed5809db4dc598757a90f) +++ .idea/sonarIssues.xml (.../sonarIssues.xml) (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -953,6 +953,11 @@ + + + + + Index: .project =================================================================== diff -u --- .project (revision 0) +++ .project (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,15 @@ + + + github + + + + + org.eclipse.jdt.core.javabuilder + + + + + org.eclipse.jdt.core.javanature + + Index: _BT__SP_488__close__time_1h__comment_Compare_Spec__RV___review_SR__admin.patch =================================================================== diff -u --- _BT__SP_488__close__time_1h__comment_Compare_Spec__RV___review_SR__admin.patch (revision 0) +++ _BT__SP_488__close__time_1h__comment_Compare_Spec__RV___review_SR__admin.patch (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,296 @@ +Index: api/rivalWar/menu/getRootCompareSpec.do +IDEA additional info: +Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP +<+>UTF-8 +=================================================================== +--- api/rivalWar/menu/getRootCompareSpec.do (revision 36315f383b0801cf5bdc512772d1bd72cc33f425) ++++ api/rivalWar/menu/getRootCompareSpec.do (revision ) +@@ -30,7 +30,7 @@ + "id" : "node_3" + }, + "copyBooleanValue" : false, +- "calTime" : null, ++ "calTime" : "2017-09-22 17:30:29", + "topSpecName" : "상위 스펙 명", + "topSpec1Title" : "상위 스펙 이름1", + "topSpec1Amount" : 313, +Index: index.html +IDEA additional info: +Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP +<+>UTF-8 +=================================================================== +--- index.html (revision 36315f383b0801cf5bdc512772d1bd72cc33f425) ++++ index.html (revision ) +@@ -474,7 +474,6 @@ + + Spec + Amount +- Percent + Trend + + +@@ -482,7 +481,6 @@ + + + +- + + +
+@@ -493,7 +491,6 @@ + + + +- + + +
+@@ -504,7 +501,6 @@ + + + +- + + +
+@@ -515,7 +511,6 @@ + + + +- + + +
+@@ -525,7 +520,6 @@ + + + +- + + +
+@@ -546,7 +540,6 @@ + + Spec + Amount +- Percent + Trend + + +@@ -554,7 +547,6 @@ + + + +- + + +
+@@ -565,7 +557,6 @@ + + + +- + + +
+@@ -576,7 +567,6 @@ + + + +- + + +
+@@ -587,7 +577,6 @@ + + + +- + + +
+@@ -597,7 +586,6 @@ + + + +- + + +
+@@ -618,7 +606,6 @@ + + Spec + Amount +- Percent + Trend + + +@@ -626,7 +613,6 @@ + + + +- + + +
+@@ -637,7 +623,6 @@ + + + +- + + +
+@@ -648,7 +633,6 @@ + + + +- + + +
+@@ -659,7 +643,6 @@ + + + +- + + +
+@@ -669,7 +652,6 @@ + + + +- + + +
+@@ -1127,67 +1109,83 @@ + console.log(responseData); + $("#compareSpecTime").text(responseData.calTime); + +- $("#botImage").attr("src", responseData.botImageUrl1); ++ //bot ++ $("#botSpec1Title").html(responseData.botSpec1Title); ++ $("#botSpec1Amount").html(responseData.botSpec1Amount); ++ $("#botSpec1Trend").html(responseData.botSpec1Trend); ++ $("#botSpec1Graph").css("width", responseData.botSpec1Graph+"%"); + +- $("#botVender").attr("src", responseData.botVenderUrl); +- $("#botVender").html(responseData.botVenderText + " "); ++ $("#botSpec2Title").html(responseData.botSpec2Title); ++ $("#botSpec2Amount").html(responseData.botSpec2Amount); ++ $("#botSpec2Trend").html(responseData.botSpec2Trend); ++ $("#botSpec2Graph").css("width", responseData.botSpec2Graph+"%"); + +- $("#botPost1").attr("src", responseData.botPost1Url); +- $("#botPost1").html(" "+ responseData.botPost1Text); ++ $("#botSpec3Title").html(responseData.botSpec3Title); ++ $("#botSpec3Amount").html(responseData.botSpec3Amount); ++ $("#botSpec3Trend").html(responseData.botSpec3Trend); ++ $("#botSpec3Graph").css("width", responseData.botSpec3Graph+"%"); + +- $("#botPost2").attr("src", responseData.botPost2Url); +- $("#botPost2").html(" "+ responseData.botPost2Text); ++ $("#botSpec4Title").html(responseData.botSpec4Title); ++ $("#botSpec4Amount").html(responseData.botSpec4Amount); ++ $("#botSpec4Trend").html(responseData.botSpec4Trend); ++ $("#botSpec4Graph").css("width", responseData.botSpec4Graph+"%"); + +- $("#botPost3").attr("src", responseData.botPost3Url); +- $("#botPost3").html(" "+ responseData.botPost3Text); ++ $("#botSpec5Title").html(responseData.botSpec5Title); ++ $("#botSpec5Amount").html(responseData.botSpec5Amount); ++ $("#botSpec5Trend").html(responseData.botSpec5Trend); ++ $("#botSpec5Graph").css("width", responseData.botSpec5Graph+"%"); + +- $("#botPost4").attr("src", responseData.botPost4Url); +- $("#botPost4").html(" "+ responseData.botPost4Text); +- +- $("#botPost5").attr("src", responseData.botPost5Url); +- $("#botPost5").html(" "+ responseData.botPost5Text); +- + //mid +- $("#midImage").attr("src", responseData.midImageUrl1); ++ $("#midSpec1Title").html(responseData.midSpec1Title); ++ $("#midSpec1Amount").html(responseData.midSpec1Amount); ++ $("#midSpec1Trend").html(responseData.midSpec1Trend); ++ $("#midSpec1Graph").css("width", responseData.midSpec1Graph+"%"); + +- $("#midVender").attr("src", responseData.midVenderUrl); +- $("#midVender").html(responseData.midVenderText + " "); ++ $("#midSpec2Title").html(responseData.midSpec2Title); ++ $("#midSpec2Amount").html(responseData.midSpec2Amount); ++ $("#midSpec2Trend").html(responseData.midSpec2Trend); ++ $("#midSpec2Graph").css("width", responseData.midSpec2Graph+"%"); + +- $("#midPost1").attr("src", responseData.midPost1Url); +- $("#midPost1").html(" "+ responseData.midPost1Text); ++ $("#midSpec3Title").html(responseData.midSpec3Title); ++ $("#midSpec3Amount").html(responseData.midSpec3Amount); ++ $("#midSpec3Trend").html(responseData.midSpec3Trend); ++ $("#midSpec3Graph").css("width", responseData.midSpec3Graph+"%"); + +- $("#midPost2").attr("src", responseData.midPost2Url); +- $("#midPost2").html(" "+ responseData.midPost2Text); ++ $("#midSpec4Title").html(responseData.midSpec4Title); ++ $("#midSpec4Amount").html(responseData.midSpec4Amount); ++ $("#midSpec4Trend").html(responseData.midSpec4Trend); ++ $("#midSpec4Graph").css("width", responseData.midSpec4Graph+"%"); + +- $("#midPost3").attr("src", responseData.midPost3Url); +- $("#midPost3").html(" "+ responseData.midPost3Text); ++ $("#midSpec5Title").html(responseData.midSpec5Title); ++ $("#midSpec5Amount").html(responseData.midSpec5Amount); ++ $("#midSpec5Trend").html(responseData.midSpec5Trend); ++ $("#midSpec5Graph").css("width", responseData.midSpec5Graph+"%"); + +- $("#midPost4").attr("src", responseData.midPost4Url); +- $("#midPost4").html(" "+ responseData.midPost4Text); +- +- $("#midPost5").attr("src", responseData.midPost5Url); +- $("#midPost5").html(" "+ responseData.midPost5Text); +- + //top +- $("#topImage").attr("src", responseData.topImageUrl1); ++ $("#topSpec1Title").html(responseData.topSpec1Title); ++ $("#topSpec1Amount").html(responseData.topSpec1Amount); ++ $("#topSpec1Trend").html(responseData.topSpec1Trend); ++ $("#topSpec1Graph").css("width", responseData.topSpec1Graph+"%"); + +- $("#topVender").attr("src", responseData.topVenderUrl); +- $("#topVender").html(responseData.topVenderText + " "); ++ $("#topSpec2Title").html(responseData.topSpec2Title); ++ $("#topSpec2Amount").html(responseData.topSpec2Amount); ++ $("#topSpec2Trend").html(responseData.topSpec2Trend); ++ $("#topSpec2Graph").css("width", responseData.topSpec2Graph+"%"); + +- $("#topPost1").attr("src", responseData.topPost1Url); +- $("#topPost1").html(" "+ responseData.topPost1Text); ++ $("#topSpec3Title").html(responseData.topSpec3Title); ++ $("#topSpec3Amount").html(responseData.topSpec3Amount); ++ $("#topSpec3Trend").html(responseData.topSpec3Trend); ++ $("#topSpec3Graph").css("width", responseData.topSpec3Graph+"%"); + +- $("#topPost2").attr("src", responseData.topPost2Url); +- $("#topPost2").html(" "+ responseData.topPost2Text); ++ $("#topSpec4Title").html(responseData.topSpec4Title); ++ $("#topSpec4Amount").html(responseData.topSpec4Amount); ++ $("#topSpec4Trend").html(responseData.topSpec4Trend); ++ $("#topSpec4Graph").css("width", responseData.topSpec4Graph+"%"); + +- $("#topPost3").attr("src", responseData.topPost3Url); +- $("#topPost3").html(" "+ responseData.topPost3Text); +- +- $("#topPost4").attr("src", responseData.topPost4Url); +- $("#topPost4").html(" "+ responseData.topPost4Text); +- +- $("#topPost5").attr("src", responseData.topPost5Url); +- $("#topPost5").html(" "+ responseData.topPost5Text); ++ $("#topSpec5Title").html(responseData.topSpec5Title); ++ $("#topSpec5Amount").html(responseData.topSpec5Amount); ++ $("#topSpec5Trend").html(responseData.topSpec5Trend); ++ $("#topSpec5Graph").css("width", responseData.topSpec5Graph+"%"); + } + function compareSpecErrorCallback(){ console.log("errorCallback"); } + function compareSpecCompleteCallback(){ console.log("completeCallback"); } Index: backend.userlibraries =================================================================== diff -u --- backend.userlibraries (revision 0) +++ backend.userlibraries (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,565 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: github.eml =================================================================== diff -u --- github.eml (revision 0) +++ github.eml (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,5 @@ + + + + + Index: standard/.classpath =================================================================== diff -u --- standard/.classpath (revision 0) +++ standard/.classpath (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,5 @@ + + + + + Index: standard/.project =================================================================== diff -u --- standard/.project (revision 0) +++ standard/.project (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,15 @@ + + + standard + + + + + org.eclipse.jdt.core.javabuilder + + + + + org.eclipse.jdt.core.javanature + + Index: standard/project/.classpath =================================================================== diff -u --- standard/project/.classpath (revision 0) +++ standard/project/.classpath (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,5 @@ + + + + + Index: standard/project/.project =================================================================== diff -u --- standard/project/.project (revision 0) +++ standard/project/.project (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,15 @@ + + + project + + + + + org.eclipse.jdt.core.javabuilder + + + + + org.eclipse.jdt.core.javanature + + Index: standard/project/project.eml =================================================================== diff -u --- standard/project/project.eml (revision 0) +++ standard/project/project.eml (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,7 @@ + + + + + + + Index: standard/project/support/.classpath =================================================================== diff -u --- standard/project/support/.classpath (revision 0) +++ standard/project/support/.classpath (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,183 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: standard/project/support/.project =================================================================== diff -u --- standard/project/support/.project (revision 0) +++ standard/project/support/.project (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,15 @@ + + + support + + + + + org.eclipse.jdt.core.javabuilder + + + + + org.eclipse.jdt.core.javanature + + Index: standard/project/support/support.eml =================================================================== diff -u --- standard/project/support/support.eml (revision 0) +++ standard/project/support/support.eml (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,187 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/menuCompareItem/MenuCompareItem_DDL_Oracle.sql =================================================================== diff -u --- standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/menuCompareItem/MenuCompareItem_DDL_Oracle.sql (revision 0) +++ standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/menuCompareItem/MenuCompareItem_DDL_Oracle.sql (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,138 @@ +/* + * JsTree 추적 로그 테이블 + * 트리거 Log를 저장합니다. + */ +CREATE TABLE T_M_MENU_COMPAREITEM_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_M_MENU_COMPAREITEM_LOG IS '기본 트리 스키마 트리거 로그'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_TYPE IS '노드 타입'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_METHOD IS '노드 변경 행위'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM_LOG.C_DATE IS '노드 변경 시'; + +/* + * JsTree + */ +CREATE TABLE T_M_MENU_COMPAREITEM +( + 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), + + MAPPING_MENU_ID NUMBER, + COMPARE_ITEM_NAME VARCHAR2(4000 BYTE), + + CONSTRAINT T_M_MENU_COMPAREITEM_PK PRIMARY KEY (C_ID) + /* + * CONSTRAINT T_M_MENU_COMPAREITEM_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_M_MENU_COMPAREITEM(C_ID) ON DELETE CASCADE + */ +); + +COMMENT ON TABLE T_M_MENU_COMPAREITEM IS '기본 트리 스키마'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.C_TYPE IS '노드 타입'; + +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.MAPPING_MENU_ID IS '맵핑할 메뉴의 아이디'; +COMMENT ON COLUMN T_M_MENU_COMPAREITEM.COMPARE_ITEM_NAME IS '비교 하위 아이템 이름'; + +/* + * 인덱스는 되도록 걸지 말것. + * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_M_MENU_COMPAREITEM + * ("C_ID" ASC) + * DROP SEQUENCE S_M_MENU_COMPAREITEM; + */ + + +CREATE SEQUENCE S_M_MENU_COMPAREITEM + START WITH 10 + MAXVALUE 999999999999999999999999999 + MINVALUE 0 + NOCYCLE + CACHE 20 + NOORDER; + +/* + * JsTree 트리거 + */ +CREATE OR REPLACE TRIGGER "TG_M_MENU_COMPAREITEM" +BEFORE DELETE OR INSERT OR UPDATE +ON T_M_MENU_COMPAREITEM +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_M_MENU_COMPAREITEM (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_M_MENU_COMPAREITEM_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_M_MENU_COMPAREITEM_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_M_MENU_COMPAREITEM_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_M_MENU_COMPAREITEM_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 TG_M_MENU_COMPAREITEM; + + +/ \ No newline at end of file Index: standard/standard.eml =================================================================== diff -u --- standard/standard.eml (revision 0) +++ standard/standard.eml (revision 1e4e7228e282b9ec53b7bb0eb4642b2fece30f47) @@ -0,0 +1,7 @@ + + + + + + +