Index: .idea/sonarIssues.xml =================================================================== diff -u -r6c37b487413112e31458241829514d61d36ed9e5 -r3dec79090f9a1d2a90c3fef612d0de77863cae68 --- .idea/sonarIssues.xml (.../sonarIssues.xml) (revision 6c37b487413112e31458241829514d61d36ed9e5) +++ .idea/sonarIssues.xml (.../sonarIssues.xml) (revision 3dec79090f9a1d2a90c3fef612d0de77863cae68) @@ -1443,11 +1443,21 @@ + + + + + + + + + + @@ -1463,11 +1473,21 @@ + + + + + + + + + + FishEye: Tag 3dec79090f9a1d2a90c3fef612d0de77863cae68 refers to a dead (removed) revision in file `standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeCoreManage_SQL_Oracle.xml'. FishEye: No comparison available. Pass `N' to diff? Index: standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml =================================================================== diff -u --- standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml (revision 0) +++ standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml (revision 3dec79090f9a1d2a90c3fef612d0de77863cae68) @@ -0,0 +1,448 @@ + + + + + + + + /* getChildNode */ + SELECT A.c_id + , A.c_parentid + , A.c_position + , A.c_left + , A.c_right + , A.c_level + , A.c_title + , A.c_type + /* user filed add + point*/ + + + , ( SELECT CASE + WHEN COUNT(*) > 0 THEN 'InChild' + ELSE + 'NoChild' + END AS YesNo + /* inline table from filed add point*/ + + + WHERE B.C_PARENTID = A.C_ID + ) AS childcount + /* table from + filed add point*/ + + + WHERE A.C_PARENTID = #c_id# + ORDER BY A.C_POSITION ASC + + + + + + + + + + + + + + + + + + /* alterNode */ + UPDATE + T_COMPREHENSIVETREE_SPRING + SET C_TYPE = #c_type# + , C_TITLE = #c_title# + WHERE C_ID = #c_id# + + + + + + + + + + + /* removeNode */ + DELETE + FROM T_COMPREHENSIVETREE_SPRING + WHERE C_LEFT >= #c_left# + AND C_RIGHT + <= #c_right# + + + + + /* + removedAfterLeftFix */ + UPDATE T_COMPREHENSIVETREE_SPRING + SET C_LEFT = + C_LEFT - #spaceOfTargetNode# + WHERE C_LEFT > #c_right# + + + + + /* + removedAfterRightFix */ + UPDATE T_COMPREHENSIVETREE_SPRING + SET C_RIGHT = + C_RIGHT - #spaceOfTargetNode# + WHERE C_RIGHT > #c_left# + + + + + /* + removedAfterPositionFix */ + UPDATE T_COMPREHENSIVETREE_SPRING + SET + C_POSITION = C_POSITION - 1 + WHERE C_PARENTID = #c_parentid# + AND + C_POSITION > #c_position# + + + + + + + + /* cutMyselfPositionFix moveNode case. parameterClass is nodeById*/ + UPDATE T_COMPREHENSIVETREE_SPRING + SET C_POSITION + = C_POSITION - 1 + WHERE C_PARENTID = #c_parentid# + AND C_POSITION > + #c_position# + + + + + /* cutMyselfLeftFix moveNode case. parameterClass is nodeById*/ + UPDATE T_COMPREHENSIVETREE_SPRING + SET C_LEFT = C_LEFT - #spaceOfTargetNode# + WHERE C_LEFT > #c_right# + + + + + /* cutMyselfRightFix moveNode case. parameterClass is nodeById*/ + UPDATE T_COMPREHENSIVETREE_SPRING + SET C_RIGHT = C_RIGHT - #spaceOfTargetNode# + WHERE C_RIGHT > #c_left# + + #c_idsByChildNodeFromNodeById[]# + + + + + + /* stretchPositionForMyselfFromJstree */ + UPDATE + T_COMPREHENSIVETREE_SPRING + SET C_POSITION = C_POSITION + 1 + WHERE + C_PARENTID = #ref# AND C_POSITION >= #c_position# + + AND C_ID NOT IN + + (-1) + + + + #c_idsByChildNodeFromNodeById[]# + + + + + + + + /* stretchLeftForMyselfFromJstree */ + UPDATE T_COMPREHENSIVETREE_SPRING + SET C_LEFT = C_LEFT + #spaceOfTargetNode# + WHERE C_LEFT >= + #rightPositionFromNodeByRef# + + + + #c_idsByChildNodeFromNodeById[]# + + + + + + + + /* stretchRightForMyselfFromJstree */ + UPDATE T_COMPREHENSIVETREE_SPRING + SET C_RIGHT = C_RIGHT + #spaceOfTargetNode# + WHERE C_RIGHT >= + #rightPositionFromNodeByRef# + + + + #c_idsByChildNodeFromNodeById[]# + + + + + + + + /* pasteMyselfFromJstree */ + INSERT INTO T_COMPREHENSIVETREE_SPRING ( + C_ID, C_PARENTID, C_POSITION, + C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE + ) + SELECT S_COMPREHENSIVETREE_SPRING.NEXTVAL AS C_ID + , A.* + FROM ( + SELECT + #ref# AS C_PARENTID + , C_POSITION + , C_LEFT - #idifLeft# AS C_LEFT + , + C_RIGHT - + #idifRight# AS C_RIGHT + , C_LEVEL - #ldif# AS C_LEVEL + , C_TITLE + , C_TYPE + FROM T_COMPREHENSIVETREE_SPRING + + #c_idsByChildNodeFromNodeById[]# + + ORDER BY C_LEVEL DESC + ) A + + /* pasteMyselfFromJstree SEQ */ + SELECT S_COMPREHENSIVETREE_SPRING.CURRVAL AS SEQ + FROM DUAL + + + + + + /* + enterMyselfFixPosition */ + UPDATE T_COMPREHENSIVETREE_SPRING + SET + C_PARENTID = #ref# + , C_POSITION = #c_position# + WHERE C_ID = #c_id# + + + + /* enterMyselfFixLeftRight */ + UPDATE T_COMPREHENSIVETREE_SPRING + SET + C_LEFT = C_LEFT - (#idif#) + , C_RIGHT = C_RIGHT - (#idif#) + , C_LEVEL = + C_LEVEL - (#ldif#) + + #c_idsByChildNodeFromNodeById[]# + + + + + + /* addMyselfFromJstree */ + INSERT INTO T_COMPREHENSIVETREE_SPRING ( + C_ID, C_PARENTID, C_POSITION, + C_LEFT, C_RIGHT, C_LEVEL ) + VALUES ( + S_COMPREHENSIVETREE_SPRING.NEXTVAL, #c_parentid#, #c_position#, + #c_left#, #c_right#, #c_level# ) + + /* addMyselfFromJstree SEQ */ + SELECT + S_COMPREHENSIVETREE_SPRING.CURRVAL AS SEQ + FROM DUAL + + + + + + /* alterNodeType */ + UPDATE T_COMPREHENSIVETREE_SPRING + SET C_TYPE = #c_type# + WHERE C_ID = + #c_id# + + + + + /* fixCopyIF */ + UPDATE + T_COMPREHENSIVETREE_SPRING + SET C_POSITION = #fixCopyPosition# + WHERE C_ID + = #fixCopyId# + + + + + /* fixCopy */ + UPDATE + T_COMPREHENSIVETREE_SPRING + SET C_PARENTID = #fixCopyId# + WHERE C_ID = + #c_id# + + + + + SELECT COUNT(*) + FROM + ( + + + + ) + + + + SELECT * + FROM + ( + SELECT ROWNUM AS RN + , DATA.* + FROM + ( + + + + ) DATA + ) + WHERE RN BETWEEN #firstIndex# + 1 AND #firstIndex# + #recordCountPerPage# + + + + + FROM T_COMPREHENSIVETREE_SPRING A + WHERE C_LEFT > #c_left# + AND C_RIGHT < #c_right# + AND C_LEVEL = #c_level# + + + + + + \ No newline at end of file FishEye: Tag 3dec79090f9a1d2a90c3fef612d0de77863cae68 refers to a dead (removed) revision in file `standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeMonitorManage_SQL_Oracle.xml'. FishEye: No comparison available. Pass `N' to diff? Index: standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeMonitorManage_SQL_Oracle_iBatis.xml =================================================================== diff -u --- standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeMonitorManage_SQL_Oracle_iBatis.xml (revision 0) +++ standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/jstreeMonitorManage_SQL_Oracle_iBatis.xml (revision 3dec79090f9a1d2a90c3fef612d0de77863cae68) @@ -0,0 +1,22 @@ + + + + + + + + \ No newline at end of file FishEye: Tag 3dec79090f9a1d2a90c3fef612d0de77863cae68 refers to a dead (removed) revision in file `standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/strutsiBatis/jstreeCoreManage_SQL_Oracle.xml'. FishEye: No comparison available. Pass `N' to diff? Index: standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/strutsiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml =================================================================== diff -u --- standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/strutsiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml (revision 0) +++ standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/strutsiBatis/jstreeCoreManage_SQL_Oracle_iBatis.xml (revision 3dec79090f9a1d2a90c3fef612d0de77863cae68) @@ -0,0 +1,308 @@ + + + + + + + + + + + + + + /* { jsTree - alterNode } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET + C_TYPE = #c_type# , + C_TITLE = #c_title# + WHERE + C_ID = #c_id# + + + + + + + + /* { jsTree - removeNode } */ + DELETE + FROM T_COMPREHENSIVETREE_STRUTS + WHERE C_LEFT >= #c_left# + AND C_RIGHT <= #c_right# + + + /* { jsTree - "removedAfterLeftFix" } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_LEFT = C_LEFT - #spaceOfTargetNode# + WHERE C_LEFT > #c_right# + + + /* { jsTree - "removedAfterRightFix" } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_RIGHT = C_RIGHT - #spaceOfTargetNode# + WHERE C_RIGHT > #c_left# + + + /* { jsTree - "removedAfterPositionFix" } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_POSITION = C_POSITION - 1 + WHERE C_PARENTID = #c_parentid# + AND C_POSITION > #c_position# + + + + + + /* { jsTree - cutMyselfPositionFix } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_POSITION = C_POSITION - 1 + WHERE C_PARENTID = #c_parentid# + AND C_POSITION > #c_position# + + + /* { jsTree - cutMyselfLeftFix } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_LEFT = C_LEFT - #spaceOfTargetNode# + WHERE C_LEFT > #c_right# + + + /* { jsTree - cutMyselfRightFix } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_RIGHT = C_RIGHT - #spaceOfTargetNode# + WHERE C_RIGHT > #c_left# + + #c_idsByChildNodeFromNodeById[]# + + + + + + /* { jsTree - stretchPositionForMyselfFromJstree } */ + UPDATE T_COMPREHENSIVETREE_STRUTS SET C_POSITION = C_POSITION + 1 + + C_PARENTID = #ref# AND C_POSITION >= #c_position# + + AND C_ID NOT IN + + (-1) + + + + #c_idsByChildNodeFromNodeById[]# + + + + + + + + + /* { jsTree - stretchLeftForMyselfFromJstree } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_LEFT = C_LEFT + #spaceOfTargetNode# + WHERE C_LEFT >= #rightPositionFromNodeByRef# + + + + #c_idsByChildNodeFromNodeById[]# + + + + + + + /* { jsTree - stretchRightForMyselfFromJstree } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_RIGHT = C_RIGHT + #spaceOfTargetNode# + WHERE C_RIGHT >= #rightPositionFromNodeByRef# + + + + #c_idsByChildNodeFromNodeById[]# + + + + + + + /* { jsTree - pasteMyselfFromJstree } */ + INSERT INTO T_COMPREHENSIVETREE_STRUTS + ( C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, + C_TYPE ) + + SELECT S_COMPREHENSIVETREE_STRUTS.NEXTVAL AS C_ID, + A.* + FROM + ( + SELECT #ref#, + C_POSITION, + C_LEFT - #idifLeft# AS C_LEFT, + C_RIGHT - #idifRight# AS C_RIGHT, + C_LEVEL - #ldif# AS C_LEVEL, + C_TITLE, + C_TYPE + FROM T_COMPREHENSIVETREE_STRUTS + + #c_idsByChildNodeFromNodeById[]# + + ORDER BY C_LEVEL DESC + ) A + + /* { jsTree - pasteMyselfFromJstree + SEQ} */ + SELECT S_COMPREHENSIVETREE_STRUTS.CURRVAL AS SEQ + FROM DUAL + + + + + /* { jsTree - enterMyselfFixPosition } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_PARENTID = #ref#, + C_POSITION = #c_position# + WHERE C_ID = #c_id# + + + /* { jsTree - enterMyselfFixLeftRight } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_LEFT = C_LEFT - (#idif#), + C_RIGHT = C_RIGHT - (#idif#), + C_LEVEL = C_LEVEL - (#ldif#) + + #c_idsByChildNodeFromNodeById[]# + + + + + /* { jsTree - addMyselfFromJstree } */ + INSERT INTO T_COMPREHENSIVETREE_STRUTS (C_ID, C_PARENTID, C_POSITION, C_LEFT, + C_RIGHT, C_LEVEL) + VALUES (S_COMPREHENSIVETREE_STRUTS.NEXTVAL, #c_parentid#, #c_position#, #c_left#, + #c_right#, #c_level#) + + /* { jsTree - addMyselfFromJstree SEQ} */ + SELECT S_COMPREHENSIVETREE_STRUTS.CURRVAL AS SEQ + FROM DUAL + + + + + /* { jsTree - alterNodeType } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET + C_TYPE = #c_type# + WHERE + C_ID = #c_id# + + + + + /* { jsTree - fixCopyIF } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_POSITION = #fixCopyPosition# + WHERE C_ID = #fixCopyId# + + + + /* { jsTree - fixCopy } */ + UPDATE T_COMPREHENSIVETREE_STRUTS + SET C_PARENTID = #fixCopyId# + WHERE C_ID = #c_id# + + + FishEye: Tag 3dec79090f9a1d2a90c3fef612d0de77863cae68 refers to a dead (removed) revision in file `standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/strutsiBatis/jstreeMonitorManage_SQL_Oracle.xml'. FishEye: No comparison available. Pass `N' to diff? Index: standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/strutsiBatis/jstreeMonitorManage_SQL_Oracle_iBatis.xml =================================================================== diff -u --- standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/strutsiBatis/jstreeMonitorManage_SQL_Oracle_iBatis.xml (revision 0) +++ standard/project/web/src/main/resources/egovframework/sqlmap/com/ext/jstree/strutsiBatis/jstreeMonitorManage_SQL_Oracle_iBatis.xml (revision 3dec79090f9a1d2a90c3fef612d0de77863cae68) @@ -0,0 +1,22 @@ + + + + + + + Index: standard/project/web/src/main/resources/egovframework/sqlmap/config/oracle/sql-map-config-oracle-ext-jstree.xml =================================================================== diff -u -r95cf86234bf1d2485c1ed4c94856a1a9ccc7718e -r3dec79090f9a1d2a90c3fef612d0de77863cae68 --- standard/project/web/src/main/resources/egovframework/sqlmap/config/oracle/sql-map-config-oracle-ext-jstree.xml (.../sql-map-config-oracle-ext-jstree.xml) (revision 95cf86234bf1d2485c1ed4c94856a1a9ccc7718e) +++ standard/project/web/src/main/resources/egovframework/sqlmap/config/oracle/sql-map-config-oracle-ext-jstree.xml (.../sql-map-config-oracle-ext-jstree.xml) (revision 3dec79090f9a1d2a90c3fef612d0de77863cae68) @@ -1,15 +1,13 @@ - - + - - + + - - + +