Index: .idea/sonarIssues.xml
===================================================================
diff -u -r24324f07809f2da4099c98e98327a32c9a4329cd -r9b9b8da01d85c0ddf56c2230d1312b99d8f29fce
--- .idea/sonarIssues.xml (.../sonarIssues.xml) (revision 24324f07809f2da4099c98e98327a32c9a4329cd)
+++ .idea/sonarIssues.xml (.../sonarIssues.xml) (revision 9b9b8da01d85c0ddf56c2230d1312b99d8f29fce)
@@ -933,6 +933,11 @@
+
+
+
+
+
Index: standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/aggregateResult/AggregateResult_DDL_Oracle.sql
===================================================================
diff -u -r6b8c4d7b039335012a2a19df87003435e1255391 -r9b9b8da01d85c0ddf56c2230d1312b99d8f29fce
--- standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/aggregateResult/AggregateResult_DDL_Oracle.sql (.../AggregateResult_DDL_Oracle.sql) (revision 6b8c4d7b039335012a2a19df87003435e1255391)
+++ standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/aggregateResult/AggregateResult_DDL_Oracle.sql (.../AggregateResult_DDL_Oracle.sql) (revision 9b9b8da01d85c0ddf56c2230d1312b99d8f29fce)
@@ -44,10 +44,45 @@
C_TITLE VARCHAR2(4000 BYTE),
C_TYPE VARCHAR2(4000 BYTE),
- C_NUMBER_OF_ADVANTAGES NUMBER,
- C_LIKE_COUNT NUMBER,
- C_TOTAL_REGISTERED_POSTS NUMBER,
- C_REGISTERED_HASH_TAG NUMBER,
+ TOP_NUMBER_OF_ADVANTAGES NUMBER,
+ TOP_LIKE_COUNT NUMBER,
+ TOP_TOTAL_REGISTERED_POSTS NUMBER,
+ TOP_REGISTERED_HASH_TAG NUMBER,
+
+ MID_NUMBER_OF_ADVANTAGES NUMBER,
+ MID_LIKE_COUNT NUMBER,
+ MID_TOTAL_REGISTERED_POSTS NUMBER,
+ MID_REGISTERED_HASH_TAG NUMBER,
+
+ BOT_NUMBER_OF_ADVANTAGES NUMBER,
+ BOT_LIKE_COUNT NUMBER,
+ BOT_TOTAL_REGISTERED_POSTS NUMBER,
+ BOT_REGISTERED_HASH_TAG NUMBER,
+
+ TOP_GRAPH_PERCENT NUMBER,
+ MID_GRAPH_PERCENT NUMBER,
+ BOT_GRAPH_PERCENT NUMBER,
+
+ TOP_VERSUS_SCORE NUMBER,
+ MID_VERSUS_SCORE NUMBER,
+ BOT_VERSUS_SCORE NUMBER,
+
+ TOTAL_TRAFFIC NUMBER,
+ UNIQUE_VISIT NUMBER,
+ REVISIT_COUNT NUMBER,
+ PAGE_VIEW NUMBER,
+
+ TOTAL_ARTICLE NUMBER,
+ TOTAL_LIKE_COUNT NUMBER,
+ TOTAL_SPEC_COUNT NUMBER,
+ TOTAL_HASH_COUNT NUMBER,
+
+ STANDARD_ERROR NUMBER,
+ EQUILIBRIUM_ASSUMPTION NUMBER,
+ PROBABILITY NUMBER,
+ LOWER_LIMIT NUMBER,
+ HIGHER_LIMIT NUMBER,
+ DISTRIBUTION_T_RESULT NUMBER,
CONSTRAINT T_JSTREE_AGGREGATE_RESULT_PK PRIMARY KEY (C_ID)
/*
* CONSTRAINT T_JSTREE_AGGREGATE_RESULT_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_JSTREE_AGGREGATE_RESULT(C_ID) ON DELETE CASCADE
@@ -64,10 +99,45 @@
COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.C_TITLE IS '노드 명';
COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.C_TYPE IS '노드 타입';
-COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.C_NUMBER_OF_ADVANTAGES IS '우위 스펙 개수';
-COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.C_LIKE_COUNT IS '좋아요 개수';
-COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.C_TOTAL_REGISTERED_POSTS IS '등록된 글 총 개수';
-COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.C_REGISTERED_HASH_TAG IS '등록된 해쉬 태그 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOP_NUMBER_OF_ADVANTAGES IS '우위 스펙 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOP_LIKE_COUNT IS '우위 좋아요 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOP_TOTAL_REGISTERED_POSTS IS '우위 등록 글 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOP_REGISTERED_HASH_TAG IS '우위 등록 해시태그 개수';
+
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.MID_NUMBER_OF_ADVANTAGES IS '중위 스펙 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.MID_LIKE_COUNT IS '중위 좋아요 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.MID_TOTAL_REGISTERED_POSTS IS '중위 등록 글 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.MID_REGISTERED_HASH_TAG IS '중위 등록 해시태그 개수';
+
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.BOT_NUMBER_OF_ADVANTAGES IS '하위 스펙 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.BOT_LIKE_COUNT IS '하위 좋아요 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.BOT_TOTAL_REGISTERED_POSTS IS '하위 등록 글 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.BOT_REGISTERED_HASH_TAG IS '하위 등록 해시태그 개수';
+
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOP_GRAPH_PERCENT IS '상위 그래프 퍼센트';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.MID_GRAPH_PERCENT IS '중위 그래프 퍼센트';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.BOT_GRAPH_PERCENT IS '하위 그래프 퍼센트';
+
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOP_VERSUS_SCORE IS '상위 비교 스코어';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.MID_VERSUS_SCORE IS '중위 비교 스코어';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.BOT_VERSUS_SCORE IS '하위 비교 스코어';
+
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOTAL_TRAFFIC IS '총 트래픽';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.UNIQUE_VISIT IS '유니크 방문 카운트';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.REVISIT_COUNT IS '재 방문 카운트';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.PAGE_VIEW IS '페이지 뷰 카운트';
+
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOTAL_ARTICLE IS '총 등록 글 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOTAL_LIKE_COUNT IS '총 좋아요 등록 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOTAL_SPEC_COUNT IS '총 스펙 등록 개수';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.TOTAL_HASH_COUNT IS '총 해시 태그 등록 개수';
+
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.STANDARD_ERROR IS '표준 오차';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.EQUILIBRIUM_ASSUMPTION IS '등분상 가정 유의확률';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.PROBABILITY IS '유의 확률';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.LOWER_LIMIT IS '신뢰구간 하한';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.HIGHER_LIMIT IS '신뢰구간 상한';
+COMMENT ON COLUMN T_JSTREE_AGGREGATE_RESULT.DISTRIBUTION_T_RESULT IS 'T분포결과';
/*
* 인덱스는 되도록 걸지 말것.
* CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_JSTREE_AGGREGATE_RESULT
@@ -135,4 +205,12 @@
-- Consider logging the error and then re-raise
RAISE;
END TG_JSTREE_AGGREGATE_RESULT;
+
+/**
+PK - FK
+**/
+ALTER TABLE T_JSTREE_MENU ADD (
+ CONSTRAINT T_JSTREE_MENU_FK_AR
+ FOREIGN KEY (AGGREGATE_RESULT_ID)
+ REFERENCES T_JSTREE_AGGREGATE_RESULT (C_ID));
/
\ No newline at end of file
Index: standard/project/web/script/dml/oracle/egovframework/api/rivalWar/aggregateResult/AggregateResult_Data_Script_Oracle.sql
===================================================================
diff -u -r6b8c4d7b039335012a2a19df87003435e1255391 -r9b9b8da01d85c0ddf56c2230d1312b99d8f29fce
--- standard/project/web/script/dml/oracle/egovframework/api/rivalWar/aggregateResult/AggregateResult_Data_Script_Oracle.sql (.../AggregateResult_Data_Script_Oracle.sql) (revision 6b8c4d7b039335012a2a19df87003435e1255391)
+++ standard/project/web/script/dml/oracle/egovframework/api/rivalWar/aggregateResult/AggregateResult_Data_Script_Oracle.sql (.../AggregateResult_Data_Script_Oracle.sql) (revision 9b9b8da01d85c0ddf56c2230d1312b99d8f29fce)
@@ -1,25 +1,67 @@
+
Insert into T_JSTREE_AGGREGATE_RESULT
- (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT,
- C_LEVEL, C_TITLE, C_TYPE, C_NUMBER_OF_ADVANTAGES, C_LIKE_COUNT, C_TOTAL_REGISTERED_POSTS, C_REGISTERED_HASH_TAG)
+ ( C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE,
+ TOP_NUMBER_OF_ADVANTAGES, TOP_LIKE_COUNT, TOP_TOTAL_REGISTERED_POSTS, TOP_REGISTERED_HASH_TAG,
+ MID_NUMBER_OF_ADVANTAGES, MID_LIKE_COUNT, MID_TOTAL_REGISTERED_POSTS, MID_REGISTERED_HASH_TAG,
+ BOT_NUMBER_OF_ADVANTAGES, BOT_LIKE_COUNT, BOT_TOTAL_REGISTERED_POSTS, BOT_REGISTERED_HASH_TAG, TOP_GRAPH_PERCENT,
+ MID_GRAPH_PERCENT, BOT_GRAPH_PERCENT, TOP_VERSUS_SCORE, MID_VERSUS_SCORE, BOT_VERSUS_SCORE, TOTAL_TRAFFIC,
+ UNIQUE_VISIT, REVISIT_COUNT, PAGE_VIEW, TOTAL_ARTICLE, TOTAL_LIKE_COUNT, TOTAL_SPEC_COUNT, TOTAL_HASH_COUNT,
+ STANDARD_ERROR, EQUILIBRIUM_ASSUMPTION, PROBABILITY, LOWER_LIMIT, HIGHER_LIMIT, DISTRIBUTION_T_RESULT)
Values
- (1, 0, 0, 1, 8,
- 0, 'Root Node', 'root', 3, 313, 131, 1);
+ (1, 0, 0, 1, 8, 0, 'Root Node', 'root',
+ 0, 0, 0, 0,
+ 0, 0, 0, 0,
+ 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0);
+
Insert into T_JSTREE_AGGREGATE_RESULT
- (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT,
- C_LEVEL, C_TITLE, C_TYPE, C_NUMBER_OF_ADVANTAGES, C_LIKE_COUNT, C_TOTAL_REGISTERED_POSTS, C_REGISTERED_HASH_TAG)
+ ( C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE,
+ TOP_NUMBER_OF_ADVANTAGES, TOP_LIKE_COUNT, TOP_TOTAL_REGISTERED_POSTS, TOP_REGISTERED_HASH_TAG,
+ MID_NUMBER_OF_ADVANTAGES, MID_LIKE_COUNT, MID_TOTAL_REGISTERED_POSTS, MID_REGISTERED_HASH_TAG,
+ BOT_NUMBER_OF_ADVANTAGES, BOT_LIKE_COUNT, BOT_TOTAL_REGISTERED_POSTS, BOT_REGISTERED_HASH_TAG, TOP_GRAPH_PERCENT,
+ MID_GRAPH_PERCENT, BOT_GRAPH_PERCENT, TOP_VERSUS_SCORE, MID_VERSUS_SCORE, BOT_VERSUS_SCORE, TOTAL_TRAFFIC,
+ UNIQUE_VISIT, REVISIT_COUNT, PAGE_VIEW, TOTAL_ARTICLE, TOTAL_LIKE_COUNT, TOTAL_SPEC_COUNT, TOTAL_HASH_COUNT,
+ STANDARD_ERROR, EQUILIBRIUM_ASSUMPTION, PROBABILITY, LOWER_LIMIT, HIGHER_LIMIT, DISTRIBUTION_T_RESULT)
Values
- (2, 1, 0, 2, 7,
- 1, 'First Child', 'drive', 3, 313, 131, 1);
+ (2, 1, 0, 2, 7, 1, 'First Child', 'drive',
+ 0, 0, 0, 0,
+ 0, 0, 0, 0,
+ 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0);
Insert into T_JSTREE_AGGREGATE_RESULT
- (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT,
- C_LEVEL, C_TITLE, C_TYPE, C_NUMBER_OF_ADVANTAGES, C_LIKE_COUNT, C_TOTAL_REGISTERED_POSTS, C_REGISTERED_HASH_TAG)
+ (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE,
+ TOP_NUMBER_OF_ADVANTAGES, TOP_LIKE_COUNT, TOP_TOTAL_REGISTERED_POSTS, TOP_REGISTERED_HASH_TAG,
+ MID_NUMBER_OF_ADVANTAGES, MID_LIKE_COUNT, MID_TOTAL_REGISTERED_POSTS, MID_REGISTERED_HASH_TAG,
+ BOT_NUMBER_OF_ADVANTAGES, BOT_LIKE_COUNT, BOT_TOTAL_REGISTERED_POSTS, BOT_REGISTERED_HASH_TAG, TOP_GRAPH_PERCENT,
+ MID_GRAPH_PERCENT, BOT_GRAPH_PERCENT, TOP_VERSUS_SCORE, MID_VERSUS_SCORE, BOT_VERSUS_SCORE, TOTAL_TRAFFIC,
+ UNIQUE_VISIT, REVISIT_COUNT, PAGE_VIEW, TOTAL_ARTICLE, TOTAL_LIKE_COUNT, TOTAL_SPEC_COUNT, TOTAL_HASH_COUNT,
+ STANDARD_ERROR, EQUILIBRIUM_ASSUMPTION, PROBABILITY, LOWER_LIMIT, HIGHER_LIMIT, DISTRIBUTION_T_RESULT)
Values
- (3, 2, 0, 3, 4,
- 2, 'Leaf Node', 'default', 3, 313, 131, 1);
+ (3, 2, 0, 3, 4, 2, 'Leaf Node', 'default',
+ 0, 0, 0, 0,
+ 0, 0, 0, 0,
+ 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0);
Insert into T_JSTREE_AGGREGATE_RESULT
- (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT,
- C_LEVEL, C_TITLE, C_TYPE, C_NUMBER_OF_ADVANTAGES, C_LIKE_COUNT, C_TOTAL_REGISTERED_POSTS, C_REGISTERED_HASH_TAG)
+ (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, C_LEVEL, C_TITLE, C_TYPE,
+ TOP_NUMBER_OF_ADVANTAGES, TOP_LIKE_COUNT, TOP_TOTAL_REGISTERED_POSTS, TOP_REGISTERED_HASH_TAG,
+ MID_NUMBER_OF_ADVANTAGES, MID_LIKE_COUNT, MID_TOTAL_REGISTERED_POSTS, MID_REGISTERED_HASH_TAG,
+ BOT_NUMBER_OF_ADVANTAGES, BOT_LIKE_COUNT, BOT_TOTAL_REGISTERED_POSTS, BOT_REGISTERED_HASH_TAG, TOP_GRAPH_PERCENT,
+ MID_GRAPH_PERCENT, BOT_GRAPH_PERCENT, TOP_VERSUS_SCORE, MID_VERSUS_SCORE, BOT_VERSUS_SCORE, TOTAL_TRAFFIC,
+ UNIQUE_VISIT, REVISIT_COUNT, PAGE_VIEW, TOTAL_ARTICLE, TOTAL_LIKE_COUNT, TOTAL_SPEC_COUNT, TOTAL_HASH_COUNT,
+ STANDARD_ERROR, EQUILIBRIUM_ASSUMPTION, PROBABILITY, LOWER_LIMIT, HIGHER_LIMIT, DISTRIBUTION_T_RESULT)
Values
- (4, 2, 1, 5, 6,
- 2, 'Branch Node', 'folder', 3, 313, 131, 1);
+ (4, 2, 1, 5, 6, 2, 'Branch Node', 'folder',
+ 0, 0, 0, 0,
+ 0, 0, 0, 0,
+ 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0, 0,
+ 0, 0, 0, 0, 0, 0);
COMMIT;
Index: standard/project/web/script/dml/oracle/egovframework/api/rivalWar/menu/Menu_Data_Script_Oracle.sql
===================================================================
diff -u -r6b8c4d7b039335012a2a19df87003435e1255391 -r9b9b8da01d85c0ddf56c2230d1312b99d8f29fce
--- standard/project/web/script/dml/oracle/egovframework/api/rivalWar/menu/Menu_Data_Script_Oracle.sql (.../Menu_Data_Script_Oracle.sql) (revision 6b8c4d7b039335012a2a19df87003435e1255391)
+++ standard/project/web/script/dml/oracle/egovframework/api/rivalWar/menu/Menu_Data_Script_Oracle.sql (.../Menu_Data_Script_Oracle.sql) (revision 9b9b8da01d85c0ddf56c2230d1312b99d8f29fce)
@@ -1,25 +1,25 @@
Insert into T_JSTREE_MENU
(C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT,
- C_LEVEL, C_TITLE, C_TYPE, C_VOTE_START_DATE, C_VOTE_END_DATE)
+ C_LEVEL, C_TITLE, C_TYPE, C_VOTE_START_DATE, C_VOTE_END_DATE, AGGREGATE_RESULT_ID)
Values
(1, 0, 0, 1, 8,
- 0, 'Root Node', 'root', '2017-01-01', '2017-03-13');
+ 0, 'Root Node', 'root', '2017-01-01', '2017-03-13', 3);
Insert into T_JSTREE_MENU
(C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT,
- C_LEVEL, C_TITLE, C_TYPE, C_VOTE_START_DATE, C_VOTE_END_DATE)
+ C_LEVEL, C_TITLE, C_TYPE, C_VOTE_START_DATE, C_VOTE_END_DATE, AGGREGATE_RESULT_ID)
Values
(2, 1, 0, 2, 7,
- 1, 'First Child', 'drive', '2017-01-01', '2017-03-13');
+ 1, 'First Child', 'drive', '2017-01-01', '2017-03-13', 3);
Insert into T_JSTREE_MENU
(C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT,
- C_LEVEL, C_TITLE, C_TYPE, C_VOTE_START_DATE, C_VOTE_END_DATE)
+ C_LEVEL, C_TITLE, C_TYPE, C_VOTE_START_DATE, C_VOTE_END_DATE, AGGREGATE_RESULT_ID)
Values
(3, 2, 0, 3, 4,
- 2, 'Leaf Node', 'default', '2017-01-01', '2017-03-13');
+ 2, 'Leaf Node', 'default', '2017-01-01', '2017-03-13', 3);
Insert into T_JSTREE_MENU
(C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT,
- C_LEVEL, C_TITLE, C_TYPE, C_VOTE_START_DATE, C_VOTE_END_DATE)
+ C_LEVEL, C_TITLE, C_TYPE, C_VOTE_START_DATE, C_VOTE_END_DATE, AGGREGATE_RESULT_ID)
Values
(4, 2, 1, 5, 6,
- 2, 'Branch Node', 'folder', '2017-01-01', '2017-03-13');
+ 2, 'Branch Node', 'folder', '2017-01-01', '2017-03-13', 3);
COMMIT;
\ No newline at end of file
Index: standard/project/web/src/main/java/egovframework/api/rivalWar/aggregateResult/vo/AggregateResultDTO.java
===================================================================
diff -u -r7e5a2eeb1c1806e39e41d4ad45d84be95a676b99 -r9b9b8da01d85c0ddf56c2230d1312b99d8f29fce
--- standard/project/web/src/main/java/egovframework/api/rivalWar/aggregateResult/vo/AggregateResultDTO.java (.../AggregateResultDTO.java) (revision 7e5a2eeb1c1806e39e41d4ad45d84be95a676b99)
+++ standard/project/web/src/main/java/egovframework/api/rivalWar/aggregateResult/vo/AggregateResultDTO.java (.../AggregateResultDTO.java) (revision 9b9b8da01d85c0ddf56c2230d1312b99d8f29fce)
@@ -54,63 +54,276 @@
}
//우위 스펙 갯수: 6, 좋아요 획득 갯수 : 3133,총 등록 글 : 10,490, 총 등록된 해시 태그 : 4300
- private Long numberOfAdvantages;
- private Long likeCount;
- private Long totalRegisteredPosts;
- private Long registeredHashTag;
+ private Long topNumberOfAdvantages;
+ private Long topLikeCount;
+ private Long topTotalRegisteredPosts;
+ private Long topRegisteredHashTag;
- @Column(name = "c_number_of_advantages")
- public Long getNumberOfAdvantages() {
- return numberOfAdvantages;
+ private Long midNumberOfAdvantages;
+ private Long midLikeCount;
+ private Long midTotalRegisteredPosts;
+ private Long midRegisteredHashTag;
+
+ private Long botNumberOfAdvantages;
+ private Long botLikeCount;
+ private Long botTotalRegisteredPosts;
+ private Long botRegisteredHashTag;
+
+ @Column(name = "top_number_of_advantages")
+ public Long getTopNumberOfAdvantages() {
+ return topNumberOfAdvantages;
}
- public void setNumberOfAdvantages(Long numberOfAdvantages) {
- this.numberOfAdvantages = numberOfAdvantages;
+ public void setTopNumberOfAdvantages(Long topNumberOfAdvantages) {
+ this.topNumberOfAdvantages = topNumberOfAdvantages;
}
- @Column(name = "c_like_count")
- public Long getLikeCount() {
- return likeCount;
+ @Column(name = "top_like_count")
+ public Long getTopLikeCount() {
+ return topLikeCount;
}
- public void setLikeCount(Long likeCount) {
- this.likeCount = likeCount;
+ public void setTopLikeCount(Long topLikeCount) {
+ this.topLikeCount = topLikeCount;
}
- @Column(name = "c_total_registered_posts")
- public Long getTotalRegisteredPosts() {
- return totalRegisteredPosts;
+ @Column(name = "top_total_registered_posts")
+ public Long getTopTotalRegisteredPosts() {
+ return topTotalRegisteredPosts;
}
- public void setTotalRegisteredPosts(Long totalRegisteredPosts) {
- this.totalRegisteredPosts = totalRegisteredPosts;
+ public void setTopTotalRegisteredPosts(Long topTotalRegisteredPosts) {
+ this.topTotalRegisteredPosts = topTotalRegisteredPosts;
}
- @Column(name = "c_registered_hash_tag")
- public Long getRegisteredHashTag() {
- return registeredHashTag;
+ @Column(name = "top_registered_hash_tag")
+ public Long getTopRegisteredHashTag() {
+ return topRegisteredHashTag;
}
- public void setRegisteredHashTag(Long registeredHashTag) {
- this.registeredHashTag = registeredHashTag;
+ public void setTopRegisteredHashTag(Long topRegisteredHashTag) {
+ this.topRegisteredHashTag = topRegisteredHashTag;
}
+ @Column(name = "mid_number_of_advantages")
+ public Long getMidNumberOfAdvantages() {
+ return midNumberOfAdvantages;
+ }
+
+ public void setMidNumberOfAdvantages(Long midNumberOfAdvantages) {
+ this.midNumberOfAdvantages = midNumberOfAdvantages;
+ }
+
+ @Column(name = "mid_like_count")
+ public Long getMidLikeCount() {
+ return midLikeCount;
+ }
+
+ public void setMidLikeCount(Long midLikeCount) {
+ this.midLikeCount = midLikeCount;
+ }
+
+ @Column(name = "mid_total_registered_posts")
+ public Long getMidTotalRegisteredPosts() {
+ return midTotalRegisteredPosts;
+ }
+
+ public void setMidTotalRegisteredPosts(Long midTotalRegisteredPosts) {
+ this.midTotalRegisteredPosts = midTotalRegisteredPosts;
+ }
+
+ @Column(name = "mid_registered_hash_tag")
+ public Long getMidRegisteredHashTag() {
+ return midRegisteredHashTag;
+ }
+
+ public void setMidRegisteredHashTag(Long midRegisteredHashTag) {
+ this.midRegisteredHashTag = midRegisteredHashTag;
+ }
+
+ @Column(name = "bot_number_of_advantages")
+ public Long getBotNumberOfAdvantages() {
+ return botNumberOfAdvantages;
+ }
+
+ public void setBotNumberOfAdvantages(Long botNumberOfAdvantages) {
+ this.botNumberOfAdvantages = botNumberOfAdvantages;
+ }
+
+ @Column(name = "bot_like_count")
+ public Long getBotLikeCount() {
+ return botLikeCount;
+ }
+
+ public void setBotLikeCount(Long botLikeCount) {
+ this.botLikeCount = botLikeCount;
+ }
+
+ @Column(name = "bot_total_registered_posts")
+ public Long getBotTotalRegisteredPosts() {
+ return botTotalRegisteredPosts;
+ }
+
+ public void setBotTotalRegisteredPosts(Long botTotalRegisteredPosts) {
+ this.botTotalRegisteredPosts = botTotalRegisteredPosts;
+ }
+
+ @Column(name = "bot_registered_hash_tag")
+ public Long getBotRegisteredHashTag() {
+ return botRegisteredHashTag;
+ }
+
+ public void setBotRegisteredHashTag(Long botRegisteredHashTag) {
+ this.botRegisteredHashTag = botRegisteredHashTag;
+ }
+
//graph percent: 15%, score point: 21304 point,
- private Long graphPercent;
- private Long versusScore;
+ private Long topGraphPercent;
+ private Long midGraphPercent;
+ private Long botGraphPercent;
+ private Long topVersusScore;
+ private Long midVersusScore;
+ private Long botVersusScore;
+
+ @Column(name = "top_graph_percent")
+ public Long getTopGraphPercent() {
+ return topGraphPercent;
+ }
+
+ public void setTopGraphPercent(Long topGraphPercent) {
+ this.topGraphPercent = topGraphPercent;
+ }
+
+ @Column(name = "mid_graph_percent")
+ public Long getMidGraphPercent() {
+ return midGraphPercent;
+ }
+
+ public void setMidGraphPercent(Long midGraphPercent) {
+ this.midGraphPercent = midGraphPercent;
+ }
+
+ @Column(name = "bot_graph_percent")
+ public Long getBotGraphPercent() {
+ return botGraphPercent;
+ }
+
+ public void setBotGraphPercent(Long botGraphPercent) {
+ this.botGraphPercent = botGraphPercent;
+ }
+
+ @Column(name = "top_versus_score")
+ public Long getTopVersusScore() {
+ return topVersusScore;
+ }
+
+ public void setTopVersusScore(Long topVersusScore) {
+ this.topVersusScore = topVersusScore;
+ }
+
+ @Column(name = "mid_versus_score")
+ public Long getMidVersusScore() {
+ return midVersusScore;
+ }
+
+ public void setMidVersusScore(Long midVersusScore) {
+ this.midVersusScore = midVersusScore;
+ }
+
+ @Column(name = "bot_versus_score")
+ public Long getBotVersusScore() {
+ return botVersusScore;
+ }
+
+ public void setBotVersusScore(Long botVersusScore) {
+ this.botVersusScore = botVersusScore;
+ }
+
//Total Traffic : 24 541, Unique Visits : 14 778, Revenue : $3 583.18, Total Sales : $59 871.12
private Long totalTraffic;
private Long uniqueVisit;
private Long revisitCount;
private Long pageView;
+ @Column(name = "total_traffic")
+ public Long getTotalTraffic() {
+ return totalTraffic;
+ }
+
+ public void setTotalTraffic(Long totalTraffic) {
+ this.totalTraffic = totalTraffic;
+ }
+
+ @Column(name = "unique_visit")
+ public Long getUniqueVisit() {
+ return uniqueVisit;
+ }
+
+ public void setUniqueVisit(Long uniqueVisit) {
+ this.uniqueVisit = uniqueVisit;
+ }
+
+ @Column(name = "revisit_count")
+ public Long getRevisitCount() {
+ return revisitCount;
+ }
+
+ public void setRevisitCount(Long revisitCount) {
+ this.revisitCount = revisitCount;
+ }
+
+ @Column(name = "page_view")
+ public Long getPageView() {
+ return pageView;
+ }
+
+ public void setPageView(Long pageView) {
+ this.pageView = pageView;
+ }
+
//등록된 글 총합: 19,23 좋아요 선택 총합: 2,443(21.2%) 추가된 스펙개수: 7개 등록된 해시태그 총합: 13,233개
private Long totalArticle;
- private Long likeArticleCount;
- private Long specCount;
- private Long hashCount;
+ private Long totalLikeCount;
+ private Long totalSpecCount;
+ private Long totalHashCount;
+ @Column(name = "total_article")
+ public Long getTotalArticle() {
+ return totalArticle;
+ }
+
+ public void setTotalArticle(Long totalArticle) {
+ this.totalArticle = totalArticle;
+ }
+
+ @Column(name = "total_like_count")
+ public Long getTotalLikeCount() {
+ return totalLikeCount;
+ }
+
+ public void setTotalLikeCount(Long totalLikeCount) {
+ this.totalLikeCount = totalLikeCount;
+ }
+
+ @Column(name = "total_spec_count")
+ public Long getTotalSpecCount() {
+ return totalSpecCount;
+ }
+
+ public void setTotalSpecCount(Long totalSpecCount) {
+ this.totalSpecCount = totalSpecCount;
+ }
+
+ @Column(name = "total_hash_count")
+ public Long getTotalHashCount() {
+ return totalHashCount;
+ }
+
+ public void setTotalHashCount(Long totalHashCount) {
+ this.totalHashCount = totalHashCount;
+ }
+
// 표준오차: 64821, 등분상 가정 유의확률: 124 유의확률: 823, 99% 신뢰구간 하한: -23134 상한: 235421 T분포결과: 8.423
private Long standardError;
private Long equilibriumAssumption;
@@ -119,14 +332,106 @@
private Long higherLimit;
private Long distributionTResult;
+ @Column(name = "standard_error")
+ public Long getStandardError() {
+ return standardError;
+ }
+ public void setStandardError(Long standardError) {
+ this.standardError = standardError;
+ }
+
+ @Column(name = "equilibrium_assumption")
+ public Long getEquilibriumAssumption() {
+ return equilibriumAssumption;
+ }
+
+ public void setEquilibriumAssumption(Long equilibriumAssumption) {
+ this.equilibriumAssumption = equilibriumAssumption;
+ }
+
+ @Column(name = "probability")
+ public Long getProbability() {
+ return probability;
+ }
+
+ public void setProbability(Long probability) {
+ this.probability = probability;
+ }
+
+ @Column(name = "lower_limit")
+ public Long getLowerLimit() {
+ return lowerLimit;
+ }
+
+ public void setLowerLimit(Long lowerLimit) {
+ this.lowerLimit = lowerLimit;
+ }
+
+ @Column(name = "higher_limit")
+ public Long getHigherLimit() {
+ return higherLimit;
+ }
+
+ public void setHigherLimit(Long higherLimit) {
+ this.higherLimit = higherLimit;
+ }
+
+ @Column(name = "distribution_t_result")
+ public Long getDistributionTResult() {
+ return distributionTResult;
+ }
+
+ public void setDistributionTResult(Long distributionTResult) {
+ this.distributionTResult = distributionTResult;
+ }
+
@Override
public void setFieldFromNewInstance(T paramInstance) {
if (paramInstance instanceof AggregateResultDTO) {
- this.setNumberOfAdvantages(this.getNumberOfAdvantages());
- this.setLikeCount(this.getLikeCount());
- this.setTotalRegisteredPosts(this.getTotalRegisteredPosts());
- this.setRegisteredHashTag(this.getRegisteredHashTag());
+ this.setTopNumberOfAdvantages(this.getTopNumberOfAdvantages());
+ this.setTopLikeCount(this.getTopLikeCount());
+ this.setTopTotalRegisteredPosts(this.getTopTotalRegisteredPosts());
+ this.setTopRegisteredHashTag(this.getTopRegisteredHashTag());
+
+ this.setMidNumberOfAdvantages(this.getMidNumberOfAdvantages());
+ this.setMidLikeCount(this.getMidLikeCount());
+ this.setMidTotalRegisteredPosts(this.getMidTotalRegisteredPosts());
+ this.setMidRegisteredHashTag(this.getMidRegisteredHashTag());
+
+ this.setBotNumberOfAdvantages(this.getBotNumberOfAdvantages());
+ this.setBotLikeCount(this.getBotLikeCount());
+ this.setBotTotalRegisteredPosts(this.getBotTotalRegisteredPosts());
+ this.setBotRegisteredHashTag(this.getBotRegisteredHashTag());
+
+ this.setTopGraphPercent(this.getTopGraphPercent());
+ this.setMidGraphPercent(this.getMidGraphPercent());
+ this.setBotGraphPercent(this.getBotGraphPercent());
+
+ this.setTopVersusScore(this.getTopVersusScore());
+ this.setMidVersusScore(this.getMidVersusScore());
+ this.setBotVersusScore(this.getBotVersusScore());
+
+ this.setTotalTraffic(this.getTotalTraffic());
+ this.setUniqueVisit(this.getUniqueVisit());
+ this.setRevisitCount(this.getRevisitCount());
+ this.setPageView(this.getPageView());
+
+ this.setTotalArticle(this.getTotalArticle());
+ this.setTotalLikeCount(this.getTotalLikeCount());
+ this.setTotalSpecCount(this.getTotalSpecCount());
+ this.setTotalHashCount(this.getTotalHashCount());
+
+ this.setStandardError(this.getStandardError());
+ this.setEquilibriumAssumption(this.getEquilibriumAssumption());
+ this.setProbability(this.getProbability());
+ this.setLowerLimit(this.getLowerLimit());
+ this.setHigherLimit(this.getHigherLimit());
+
+ this.setDistributionTResult(this.getDistributionTResult());
+
+
+
}
}
}