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
+ (
+
+
+
+ )
+
+
+
+
+
+
+
+
+ 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 @@
-
-
+
-
-
+
+
-
-
+
+