diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
index e76bd4c..849d74b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
@@ -21,12 +21,8 @@
@Service
public class PgInPgPersonManager extends HibernateEntityDao {
- private PgInPgStatusManager pgInPgStatusManager;
-
@Resource
- public void setPgInPgStatusManager(PgInPgStatusManager pgInPgStatusManager) {
- this.pgInPgStatusManager = pgInPgStatusManager;
- }
+ private PgInPgStatusManager pgInPgStatusManager;
public PgInPgPerson getPersonByUserName(String userName) {
List pgInPgPersonList = null;
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
index e76bd4c..849d74b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
@@ -21,12 +21,8 @@
@Service
public class PgInPgPersonManager extends HibernateEntityDao {
- private PgInPgStatusManager pgInPgStatusManager;
-
@Resource
- public void setPgInPgStatusManager(PgInPgStatusManager pgInPgStatusManager) {
- this.pgInPgStatusManager = pgInPgStatusManager;
- }
+ private PgInPgStatusManager pgInPgStatusManager;
public PgInPgPerson getPersonByUserName(String userName) {
List pgInPgPersonList = null;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
index 05a5901..dd5dc67 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
@@ -21,20 +21,16 @@
@Service
public class PgLogManager extends HibernateEntityDao {
- private PgUserManager pgPatrolerManager;
-
@Resource
- public void setPgPatrolerManager(PgUserManager pgPatrolerManager) {
- this.pgPatrolerManager = pgPatrolerManager;
- }
+ private PgUserManager pgUserManager;
+
//获取当前设备列表
- //TODO LIST getAllLOgs
public List getAllLogs(String userName,String startTime,String endTime) {
try {
Criteria criteria = createCriteria(PgLog.class);
if (StringUtils.isNotBlank(userName)) {
- criteria.add(Restrictions.eq("userId", pgPatrolerManager.getPatrolerByuserName(userName)));
+ criteria.add(Restrictions.eq("userId", pgUserManager.getPatrolerByuserName(userName)));
}
if (StringUtils.isNotBlank(startTime)) {
@@ -53,7 +49,7 @@
List pgLogList = criteria.list();
List pgLogDtoList = new ArrayList();
for (PgLog pgLog : pgLogList) {
- pgLogDtoList.add(new PgLogDto(pgLog));
+ pgLogDtoList.add(new PgLogDto(pgLog,pgUserManager));
}
return pgLogDtoList;
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
index e76bd4c..849d74b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
@@ -21,12 +21,8 @@
@Service
public class PgInPgPersonManager extends HibernateEntityDao {
- private PgInPgStatusManager pgInPgStatusManager;
-
@Resource
- public void setPgInPgStatusManager(PgInPgStatusManager pgInPgStatusManager) {
- this.pgInPgStatusManager = pgInPgStatusManager;
- }
+ private PgInPgStatusManager pgInPgStatusManager;
public PgInPgPerson getPersonByUserName(String userName) {
List pgInPgPersonList = null;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
index 05a5901..dd5dc67 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
@@ -21,20 +21,16 @@
@Service
public class PgLogManager extends HibernateEntityDao {
- private PgUserManager pgPatrolerManager;
-
@Resource
- public void setPgPatrolerManager(PgUserManager pgPatrolerManager) {
- this.pgPatrolerManager = pgPatrolerManager;
- }
+ private PgUserManager pgUserManager;
+
//获取当前设备列表
- //TODO LIST getAllLOgs
public List getAllLogs(String userName,String startTime,String endTime) {
try {
Criteria criteria = createCriteria(PgLog.class);
if (StringUtils.isNotBlank(userName)) {
- criteria.add(Restrictions.eq("userId", pgPatrolerManager.getPatrolerByuserName(userName)));
+ criteria.add(Restrictions.eq("userId", pgUserManager.getPatrolerByuserName(userName)));
}
if (StringUtils.isNotBlank(startTime)) {
@@ -53,7 +49,7 @@
List pgLogList = criteria.list();
List pgLogDtoList = new ArrayList();
for (PgLog pgLog : pgLogList) {
- pgLogDtoList.add(new PgLogDto(pgLog));
+ pgLogDtoList.add(new PgLogDto(pgLog,pgUserManager));
}
return pgLogDtoList;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
index d2b9db4..cb42943 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
@@ -8,6 +8,7 @@
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -17,6 +18,9 @@
@Service
public class PgUserManager extends HibernateEntityDao {
+ @Resource
+ private PgRoleManager pgRoleManager;
+
//获取当前人员列表
//TODO LIST List getAll()
public List getAllUser() {
@@ -26,9 +30,9 @@
criteria.addOrder(Order.desc("id"));
List pgUserList=criteria.list();
- List pgUserDtoList = new ArrayList();
+ List pgUserDtoList = new ArrayList<>();
for (PgUser pgUser : pgUserList){
- pgUserDtoList.add(new PgUserDto(pgUser));
+ pgUserDtoList.add(new PgUserDto(pgUser,pgRoleManager));
}
return pgUserDtoList;
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
index e76bd4c..849d74b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
@@ -21,12 +21,8 @@
@Service
public class PgInPgPersonManager extends HibernateEntityDao {
- private PgInPgStatusManager pgInPgStatusManager;
-
@Resource
- public void setPgInPgStatusManager(PgInPgStatusManager pgInPgStatusManager) {
- this.pgInPgStatusManager = pgInPgStatusManager;
- }
+ private PgInPgStatusManager pgInPgStatusManager;
public PgInPgPerson getPersonByUserName(String userName) {
List pgInPgPersonList = null;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
index 05a5901..dd5dc67 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
@@ -21,20 +21,16 @@
@Service
public class PgLogManager extends HibernateEntityDao {
- private PgUserManager pgPatrolerManager;
-
@Resource
- public void setPgPatrolerManager(PgUserManager pgPatrolerManager) {
- this.pgPatrolerManager = pgPatrolerManager;
- }
+ private PgUserManager pgUserManager;
+
//获取当前设备列表
- //TODO LIST getAllLOgs
public List getAllLogs(String userName,String startTime,String endTime) {
try {
Criteria criteria = createCriteria(PgLog.class);
if (StringUtils.isNotBlank(userName)) {
- criteria.add(Restrictions.eq("userId", pgPatrolerManager.getPatrolerByuserName(userName)));
+ criteria.add(Restrictions.eq("userId", pgUserManager.getPatrolerByuserName(userName)));
}
if (StringUtils.isNotBlank(startTime)) {
@@ -53,7 +49,7 @@
List pgLogList = criteria.list();
List pgLogDtoList = new ArrayList();
for (PgLog pgLog : pgLogList) {
- pgLogDtoList.add(new PgLogDto(pgLog));
+ pgLogDtoList.add(new PgLogDto(pgLog,pgUserManager));
}
return pgLogDtoList;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
index d2b9db4..cb42943 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
@@ -8,6 +8,7 @@
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -17,6 +18,9 @@
@Service
public class PgUserManager extends HibernateEntityDao {
+ @Resource
+ private PgRoleManager pgRoleManager;
+
//获取当前人员列表
//TODO LIST List getAll()
public List getAllUser() {
@@ -26,9 +30,9 @@
criteria.addOrder(Order.desc("id"));
List pgUserList=criteria.list();
- List pgUserDtoList = new ArrayList();
+ List pgUserDtoList = new ArrayList<>();
for (PgUser pgUser : pgUserList){
- pgUserDtoList.add(new PgUserDto(pgUser));
+ pgUserDtoList.add(new PgUserDto(pgUser,pgRoleManager));
}
return pgUserDtoList;
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
index d64dc52..d18ebb8 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
@@ -102,52 +102,6 @@
return resultMap;
}
-/*
- */
-/**
- * 新增报警
- *//*
-
- @POST
- @Path("addAlarm")
- @Produces(MediaType.APPLICATION_JSON)
- public Map addAlarm(@FormParam("alarmType") String alarmType,
- @FormParam("alarmValue") String alarmValue,
- @FormParam("alarmDate") String alarmDate,
- @FormParam("description") String description,
- @FormParam("devCode") String devCode,
- @FormParam("userName") String userName) throws Exception {
- Map resultMap = new HashMap();
- String result = "";
- String msg = "";
-
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- try {
- PgAlarm pgAlarm = new PgAlarm();
- pgAlarm.setAlarmTypeId(pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType));
- pgAlarm.setAlarmValue(alarmValue);
- pgAlarm.setAlarmDate(sdf.parse(alarmDate));
- pgAlarm.setDescription(description);
- pgAlarm.setUserId(pgPatrolerManager.getPatrolerByuserName(userName));
- pgAlarm.setAlarmDevId(pgDeviceManager.getDeviceBydevCode(devCode));
- pgAlarm.setActive(1);
-
- logger.info("成功保存");
- pgAlarmManager.save(pgAlarm);
- result = "true";
- msg = "保存成功";
- } catch (Exception e) {
- result = "false";
- msg = "保存失败";
- e.printStackTrace();
- }
-
- resultMap.put("result", result);
- resultMap.put("msg", msg);
- return resultMap;
- }
-*/
-
/*
* 根据报警类型和时间查询报警记录
*/
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
index e76bd4c..849d74b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
@@ -21,12 +21,8 @@
@Service
public class PgInPgPersonManager extends HibernateEntityDao {
- private PgInPgStatusManager pgInPgStatusManager;
-
@Resource
- public void setPgInPgStatusManager(PgInPgStatusManager pgInPgStatusManager) {
- this.pgInPgStatusManager = pgInPgStatusManager;
- }
+ private PgInPgStatusManager pgInPgStatusManager;
public PgInPgPerson getPersonByUserName(String userName) {
List pgInPgPersonList = null;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
index 05a5901..dd5dc67 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
@@ -21,20 +21,16 @@
@Service
public class PgLogManager extends HibernateEntityDao {
- private PgUserManager pgPatrolerManager;
-
@Resource
- public void setPgPatrolerManager(PgUserManager pgPatrolerManager) {
- this.pgPatrolerManager = pgPatrolerManager;
- }
+ private PgUserManager pgUserManager;
+
//获取当前设备列表
- //TODO LIST getAllLOgs
public List getAllLogs(String userName,String startTime,String endTime) {
try {
Criteria criteria = createCriteria(PgLog.class);
if (StringUtils.isNotBlank(userName)) {
- criteria.add(Restrictions.eq("userId", pgPatrolerManager.getPatrolerByuserName(userName)));
+ criteria.add(Restrictions.eq("userId", pgUserManager.getPatrolerByuserName(userName)));
}
if (StringUtils.isNotBlank(startTime)) {
@@ -53,7 +49,7 @@
List pgLogList = criteria.list();
List pgLogDtoList = new ArrayList();
for (PgLog pgLog : pgLogList) {
- pgLogDtoList.add(new PgLogDto(pgLog));
+ pgLogDtoList.add(new PgLogDto(pgLog,pgUserManager));
}
return pgLogDtoList;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
index d2b9db4..cb42943 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
@@ -8,6 +8,7 @@
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -17,6 +18,9 @@
@Service
public class PgUserManager extends HibernateEntityDao {
+ @Resource
+ private PgRoleManager pgRoleManager;
+
//获取当前人员列表
//TODO LIST List getAll()
public List getAllUser() {
@@ -26,9 +30,9 @@
criteria.addOrder(Order.desc("id"));
List pgUserList=criteria.list();
- List pgUserDtoList = new ArrayList();
+ List pgUserDtoList = new ArrayList<>();
for (PgUser pgUser : pgUserList){
- pgUserDtoList.add(new PgUserDto(pgUser));
+ pgUserDtoList.add(new PgUserDto(pgUser,pgRoleManager));
}
return pgUserDtoList;
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
index d64dc52..d18ebb8 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
@@ -102,52 +102,6 @@
return resultMap;
}
-/*
- */
-/**
- * 新增报警
- *//*
-
- @POST
- @Path("addAlarm")
- @Produces(MediaType.APPLICATION_JSON)
- public Map addAlarm(@FormParam("alarmType") String alarmType,
- @FormParam("alarmValue") String alarmValue,
- @FormParam("alarmDate") String alarmDate,
- @FormParam("description") String description,
- @FormParam("devCode") String devCode,
- @FormParam("userName") String userName) throws Exception {
- Map resultMap = new HashMap();
- String result = "";
- String msg = "";
-
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- try {
- PgAlarm pgAlarm = new PgAlarm();
- pgAlarm.setAlarmTypeId(pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType));
- pgAlarm.setAlarmValue(alarmValue);
- pgAlarm.setAlarmDate(sdf.parse(alarmDate));
- pgAlarm.setDescription(description);
- pgAlarm.setUserId(pgPatrolerManager.getPatrolerByuserName(userName));
- pgAlarm.setAlarmDevId(pgDeviceManager.getDeviceBydevCode(devCode));
- pgAlarm.setActive(1);
-
- logger.info("成功保存");
- pgAlarmManager.save(pgAlarm);
- result = "true";
- msg = "保存成功";
- } catch (Exception e) {
- result = "false";
- msg = "保存失败";
- e.printStackTrace();
- }
-
- resultMap.put("result", result);
- resultMap.put("msg", msg);
- return resultMap;
- }
-*/
-
/*
* 根据报警类型和时间查询报警记录
*/
diff --git a/src/main/java/com/casic/PgInterface/rs/PgLogRs.java b/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
index 998345b..1621666 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
@@ -41,8 +41,6 @@
@FormParam("operate") String operate)
throws Exception {
- //SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
-
Map resultMap = new HashMap();
String result = "";
String msg = "";
@@ -51,7 +49,7 @@
PgUser pgUser = new PgUser();
pgUser = pgPatrolerManager.getPatrolerByuserName(userName);
- pgLog.setUserId(pgUser);
+ pgLog.setUserId(pgUser.getId());
pgLog.setOperate(operate);
pgLog.setOperateTime(new Date());
pgLog.setActive(1);
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
index e76bd4c..849d74b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
@@ -21,12 +21,8 @@
@Service
public class PgInPgPersonManager extends HibernateEntityDao {
- private PgInPgStatusManager pgInPgStatusManager;
-
@Resource
- public void setPgInPgStatusManager(PgInPgStatusManager pgInPgStatusManager) {
- this.pgInPgStatusManager = pgInPgStatusManager;
- }
+ private PgInPgStatusManager pgInPgStatusManager;
public PgInPgPerson getPersonByUserName(String userName) {
List pgInPgPersonList = null;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
index 05a5901..dd5dc67 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
@@ -21,20 +21,16 @@
@Service
public class PgLogManager extends HibernateEntityDao {
- private PgUserManager pgPatrolerManager;
-
@Resource
- public void setPgPatrolerManager(PgUserManager pgPatrolerManager) {
- this.pgPatrolerManager = pgPatrolerManager;
- }
+ private PgUserManager pgUserManager;
+
//获取当前设备列表
- //TODO LIST getAllLOgs
public List getAllLogs(String userName,String startTime,String endTime) {
try {
Criteria criteria = createCriteria(PgLog.class);
if (StringUtils.isNotBlank(userName)) {
- criteria.add(Restrictions.eq("userId", pgPatrolerManager.getPatrolerByuserName(userName)));
+ criteria.add(Restrictions.eq("userId", pgUserManager.getPatrolerByuserName(userName)));
}
if (StringUtils.isNotBlank(startTime)) {
@@ -53,7 +49,7 @@
List pgLogList = criteria.list();
List pgLogDtoList = new ArrayList();
for (PgLog pgLog : pgLogList) {
- pgLogDtoList.add(new PgLogDto(pgLog));
+ pgLogDtoList.add(new PgLogDto(pgLog,pgUserManager));
}
return pgLogDtoList;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
index d2b9db4..cb42943 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
@@ -8,6 +8,7 @@
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -17,6 +18,9 @@
@Service
public class PgUserManager extends HibernateEntityDao {
+ @Resource
+ private PgRoleManager pgRoleManager;
+
//获取当前人员列表
//TODO LIST List getAll()
public List getAllUser() {
@@ -26,9 +30,9 @@
criteria.addOrder(Order.desc("id"));
List pgUserList=criteria.list();
- List pgUserDtoList = new ArrayList();
+ List pgUserDtoList = new ArrayList<>();
for (PgUser pgUser : pgUserList){
- pgUserDtoList.add(new PgUserDto(pgUser));
+ pgUserDtoList.add(new PgUserDto(pgUser,pgRoleManager));
}
return pgUserDtoList;
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
index d64dc52..d18ebb8 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
@@ -102,52 +102,6 @@
return resultMap;
}
-/*
- */
-/**
- * 新增报警
- *//*
-
- @POST
- @Path("addAlarm")
- @Produces(MediaType.APPLICATION_JSON)
- public Map addAlarm(@FormParam("alarmType") String alarmType,
- @FormParam("alarmValue") String alarmValue,
- @FormParam("alarmDate") String alarmDate,
- @FormParam("description") String description,
- @FormParam("devCode") String devCode,
- @FormParam("userName") String userName) throws Exception {
- Map resultMap = new HashMap();
- String result = "";
- String msg = "";
-
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- try {
- PgAlarm pgAlarm = new PgAlarm();
- pgAlarm.setAlarmTypeId(pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType));
- pgAlarm.setAlarmValue(alarmValue);
- pgAlarm.setAlarmDate(sdf.parse(alarmDate));
- pgAlarm.setDescription(description);
- pgAlarm.setUserId(pgPatrolerManager.getPatrolerByuserName(userName));
- pgAlarm.setAlarmDevId(pgDeviceManager.getDeviceBydevCode(devCode));
- pgAlarm.setActive(1);
-
- logger.info("成功保存");
- pgAlarmManager.save(pgAlarm);
- result = "true";
- msg = "保存成功";
- } catch (Exception e) {
- result = "false";
- msg = "保存失败";
- e.printStackTrace();
- }
-
- resultMap.put("result", result);
- resultMap.put("msg", msg);
- return resultMap;
- }
-*/
-
/*
* 根据报警类型和时间查询报警记录
*/
diff --git a/src/main/java/com/casic/PgInterface/rs/PgLogRs.java b/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
index 998345b..1621666 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
@@ -41,8 +41,6 @@
@FormParam("operate") String operate)
throws Exception {
- //SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
-
Map resultMap = new HashMap();
String result = "";
String msg = "";
@@ -51,7 +49,7 @@
PgUser pgUser = new PgUser();
pgUser = pgPatrolerManager.getPatrolerByuserName(userName);
- pgLog.setUserId(pgUser);
+ pgLog.setUserId(pgUser.getId());
pgLog.setOperate(operate);
pgLog.setOperateTime(new Date());
pgLog.setActive(1);
diff --git a/src/main/java/com/casic/PgInterface/rs/PgUserRs.java b/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
index cac8922..10aff34 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
@@ -1,5 +1,6 @@
package com.casic.PgInterface.rs;
+import com.casic.PgInterface.patroler.domain.PgRole;
import com.casic.PgInterface.patroler.domain.PgUser;
import com.casic.PgInterface.patroler.dto.PgUserDto;
import com.casic.PgInterface.patroler.manager.PgRoleManager;
@@ -64,17 +65,18 @@
@Path("addUser")
@Produces(MediaType.APPLICATION_JSON)
public Map addUser(@FormParam("userName") String userName,
- @FormParam("password") String password,
- @FormParam("department") String department,
- @FormParam("post") String post,
- @FormParam("phoneNumber") String phoneNumber
+ @FormParam("password") String password,
+ @FormParam("department") String department,
+ @FormParam("post") String post,
+ @FormParam("phoneNumber") String phoneNumber,
+ @FormParam("role") String role
)throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap<>();
String result = "";
String msg = "";
try {
-// PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
+ PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
if (pgUserManager.userNameIsExits(userName)) {
result = "false";
@@ -83,12 +85,14 @@
PgUser pgUser = new PgUser();
pgUser.setUserName(userName);
- //String pass = StringUtils.getMD5(password);
pgUser.setPassword(password);
pgUser.setDepartment(department);
pgUser.setPost(post);
pgUser.setPhoneNumber(phoneNumber);
-// pgUser.setPgRoleId(pgRole);
+ if(pgRole==null)
+ pgUser.setRoleId(null);
+ else
+ pgUser.setRoleId(pgRole.getId());
pgUser.setActive(1);
logger.info("成功保存");
@@ -114,19 +118,20 @@
@Path("editUser")
@Produces(MediaType.APPLICATION_JSON)
public Map editUser(@FormParam("id") String id,
- @FormParam("userName") String userName,
- @FormParam("password") String password,
- @FormParam("department") String department,
- @FormParam("post") String post,
- @FormParam("phoneNumber") String phoneNumber
+ @FormParam("userName") String userName,
+ @FormParam("password") String password,
+ @FormParam("department") String department,
+ @FormParam("post") String post,
+ @FormParam("phoneNumber") String phoneNumber,
+ @FormParam("role") String role
) throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap<>();
String result = "";
String msg = "";
try {
-// PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
+ PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
PgUser pgUser = pgUserManager.get(Long.valueOf(id));
pgUser.setUserName(userName);
@@ -134,7 +139,10 @@
pgUser.setDepartment(department);
pgUser.setPost(post);
pgUser.setPhoneNumber(phoneNumber);
-// pgUser.setPgRoleId(pgRole);
+ if(pgRole==null)
+ pgUser.setRoleId(null);
+ else
+ pgUser.setRoleId(pgRole.getId());
pgUserManager.save(pgUser);
result = "true";
msg = "编辑成功";
@@ -158,7 +166,7 @@
@Produces(MediaType.APPLICATION_JSON)
public Map deleteUser(@FormParam("id") String id)throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap();
String msg="";
String result="false";
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
index e76bd4c..849d74b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
@@ -21,12 +21,8 @@
@Service
public class PgInPgPersonManager extends HibernateEntityDao {
- private PgInPgStatusManager pgInPgStatusManager;
-
@Resource
- public void setPgInPgStatusManager(PgInPgStatusManager pgInPgStatusManager) {
- this.pgInPgStatusManager = pgInPgStatusManager;
- }
+ private PgInPgStatusManager pgInPgStatusManager;
public PgInPgPerson getPersonByUserName(String userName) {
List pgInPgPersonList = null;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
index 05a5901..dd5dc67 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
@@ -21,20 +21,16 @@
@Service
public class PgLogManager extends HibernateEntityDao {
- private PgUserManager pgPatrolerManager;
-
@Resource
- public void setPgPatrolerManager(PgUserManager pgPatrolerManager) {
- this.pgPatrolerManager = pgPatrolerManager;
- }
+ private PgUserManager pgUserManager;
+
//获取当前设备列表
- //TODO LIST getAllLOgs
public List getAllLogs(String userName,String startTime,String endTime) {
try {
Criteria criteria = createCriteria(PgLog.class);
if (StringUtils.isNotBlank(userName)) {
- criteria.add(Restrictions.eq("userId", pgPatrolerManager.getPatrolerByuserName(userName)));
+ criteria.add(Restrictions.eq("userId", pgUserManager.getPatrolerByuserName(userName)));
}
if (StringUtils.isNotBlank(startTime)) {
@@ -53,7 +49,7 @@
List pgLogList = criteria.list();
List pgLogDtoList = new ArrayList();
for (PgLog pgLog : pgLogList) {
- pgLogDtoList.add(new PgLogDto(pgLog));
+ pgLogDtoList.add(new PgLogDto(pgLog,pgUserManager));
}
return pgLogDtoList;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
index d2b9db4..cb42943 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
@@ -8,6 +8,7 @@
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -17,6 +18,9 @@
@Service
public class PgUserManager extends HibernateEntityDao {
+ @Resource
+ private PgRoleManager pgRoleManager;
+
//获取当前人员列表
//TODO LIST List getAll()
public List getAllUser() {
@@ -26,9 +30,9 @@
criteria.addOrder(Order.desc("id"));
List pgUserList=criteria.list();
- List pgUserDtoList = new ArrayList();
+ List pgUserDtoList = new ArrayList<>();
for (PgUser pgUser : pgUserList){
- pgUserDtoList.add(new PgUserDto(pgUser));
+ pgUserDtoList.add(new PgUserDto(pgUser,pgRoleManager));
}
return pgUserDtoList;
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
index d64dc52..d18ebb8 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
@@ -102,52 +102,6 @@
return resultMap;
}
-/*
- */
-/**
- * 新增报警
- *//*
-
- @POST
- @Path("addAlarm")
- @Produces(MediaType.APPLICATION_JSON)
- public Map addAlarm(@FormParam("alarmType") String alarmType,
- @FormParam("alarmValue") String alarmValue,
- @FormParam("alarmDate") String alarmDate,
- @FormParam("description") String description,
- @FormParam("devCode") String devCode,
- @FormParam("userName") String userName) throws Exception {
- Map resultMap = new HashMap();
- String result = "";
- String msg = "";
-
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- try {
- PgAlarm pgAlarm = new PgAlarm();
- pgAlarm.setAlarmTypeId(pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType));
- pgAlarm.setAlarmValue(alarmValue);
- pgAlarm.setAlarmDate(sdf.parse(alarmDate));
- pgAlarm.setDescription(description);
- pgAlarm.setUserId(pgPatrolerManager.getPatrolerByuserName(userName));
- pgAlarm.setAlarmDevId(pgDeviceManager.getDeviceBydevCode(devCode));
- pgAlarm.setActive(1);
-
- logger.info("成功保存");
- pgAlarmManager.save(pgAlarm);
- result = "true";
- msg = "保存成功";
- } catch (Exception e) {
- result = "false";
- msg = "保存失败";
- e.printStackTrace();
- }
-
- resultMap.put("result", result);
- resultMap.put("msg", msg);
- return resultMap;
- }
-*/
-
/*
* 根据报警类型和时间查询报警记录
*/
diff --git a/src/main/java/com/casic/PgInterface/rs/PgLogRs.java b/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
index 998345b..1621666 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
@@ -41,8 +41,6 @@
@FormParam("operate") String operate)
throws Exception {
- //SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
-
Map resultMap = new HashMap();
String result = "";
String msg = "";
@@ -51,7 +49,7 @@
PgUser pgUser = new PgUser();
pgUser = pgPatrolerManager.getPatrolerByuserName(userName);
- pgLog.setUserId(pgUser);
+ pgLog.setUserId(pgUser.getId());
pgLog.setOperate(operate);
pgLog.setOperateTime(new Date());
pgLog.setActive(1);
diff --git a/src/main/java/com/casic/PgInterface/rs/PgUserRs.java b/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
index cac8922..10aff34 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
@@ -1,5 +1,6 @@
package com.casic.PgInterface.rs;
+import com.casic.PgInterface.patroler.domain.PgRole;
import com.casic.PgInterface.patroler.domain.PgUser;
import com.casic.PgInterface.patroler.dto.PgUserDto;
import com.casic.PgInterface.patroler.manager.PgRoleManager;
@@ -64,17 +65,18 @@
@Path("addUser")
@Produces(MediaType.APPLICATION_JSON)
public Map addUser(@FormParam("userName") String userName,
- @FormParam("password") String password,
- @FormParam("department") String department,
- @FormParam("post") String post,
- @FormParam("phoneNumber") String phoneNumber
+ @FormParam("password") String password,
+ @FormParam("department") String department,
+ @FormParam("post") String post,
+ @FormParam("phoneNumber") String phoneNumber,
+ @FormParam("role") String role
)throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap<>();
String result = "";
String msg = "";
try {
-// PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
+ PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
if (pgUserManager.userNameIsExits(userName)) {
result = "false";
@@ -83,12 +85,14 @@
PgUser pgUser = new PgUser();
pgUser.setUserName(userName);
- //String pass = StringUtils.getMD5(password);
pgUser.setPassword(password);
pgUser.setDepartment(department);
pgUser.setPost(post);
pgUser.setPhoneNumber(phoneNumber);
-// pgUser.setPgRoleId(pgRole);
+ if(pgRole==null)
+ pgUser.setRoleId(null);
+ else
+ pgUser.setRoleId(pgRole.getId());
pgUser.setActive(1);
logger.info("成功保存");
@@ -114,19 +118,20 @@
@Path("editUser")
@Produces(MediaType.APPLICATION_JSON)
public Map editUser(@FormParam("id") String id,
- @FormParam("userName") String userName,
- @FormParam("password") String password,
- @FormParam("department") String department,
- @FormParam("post") String post,
- @FormParam("phoneNumber") String phoneNumber
+ @FormParam("userName") String userName,
+ @FormParam("password") String password,
+ @FormParam("department") String department,
+ @FormParam("post") String post,
+ @FormParam("phoneNumber") String phoneNumber,
+ @FormParam("role") String role
) throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap<>();
String result = "";
String msg = "";
try {
-// PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
+ PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
PgUser pgUser = pgUserManager.get(Long.valueOf(id));
pgUser.setUserName(userName);
@@ -134,7 +139,10 @@
pgUser.setDepartment(department);
pgUser.setPost(post);
pgUser.setPhoneNumber(phoneNumber);
-// pgUser.setPgRoleId(pgRole);
+ if(pgRole==null)
+ pgUser.setRoleId(null);
+ else
+ pgUser.setRoleId(pgRole.getId());
pgUserManager.save(pgUser);
result = "true";
msg = "编辑成功";
@@ -158,7 +166,7 @@
@Produces(MediaType.APPLICATION_JSON)
public Map deleteUser(@FormParam("id") String id)throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap();
String msg="";
String result="false";
diff --git "a/\346\216\245\345\217\243\350\257\264\346\230\21620190726.docx" "b/\346\216\245\345\217\243\350\257\264\346\230\21620190726.docx"
index 60b395f..75b67e4 100644
--- "a/\346\216\245\345\217\243\350\257\264\346\230\21620190726.docx"
+++ "b/\346\216\245\345\217\243\350\257\264\346\230\21620190726.docx"
Binary files differ
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index a53145d..8d28b45 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,11 +7,20 @@
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -26,7 +35,7 @@
-
+
@@ -34,31 +43,32 @@
-
+
-
+
-
+
-
-
+
+
-
-
+
+
+
@@ -69,13 +79,54 @@
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
@@ -115,7 +165,6 @@
-
@@ -129,6 +178,17 @@
+
+
+
+
+
+
+
+
+
+
+
@@ -166,15 +226,14 @@
-
-
+
+
-
@@ -214,12 +273,61 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -349,7 +457,9 @@
-
+
+
+
1564361618083
@@ -358,16 +468,23 @@
1564361618083
-
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
-
+
-
+
@@ -378,7 +495,7 @@
-
+
@@ -389,7 +506,7 @@
-
+
@@ -403,7 +520,7 @@
-
+
@@ -414,19 +531,19 @@
-
+
-
+
-
-
+
+
@@ -447,7 +564,8 @@
-
+
+
@@ -462,46 +580,48 @@
-
-
+
+
+
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
@@ -512,150 +632,59 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
@@ -666,168 +695,247 @@
-
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
+
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
-
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
index a18be20..4bd8498 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgLog.java
@@ -18,7 +18,7 @@
private long id;
private String operate;//操作
private Date operateTime;//时间
- private PgUser userId;//操作人员
+ private Long userId;//操作人员
private int active;//状态位
@Id
@@ -58,14 +58,13 @@
this.active = active;
}
- @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
- @NotFound(action = NotFoundAction.IGNORE)
- @JoinColumn(name = "USERID")
- public PgUser getUserId() {
+ @Column(name = "USERID")
+ public Long getUserId() {
return userId;
}
- public void setUserId(PgUser userId) {
+ public void setUserId(Long userId) {
this.userId = userId;
}
+
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
index 6ecca34..bdaf56a 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgRole.java
@@ -19,7 +19,6 @@
private String role;
private int active;
private PgAuthority pgAuthorityId;
-// private List pgUsers;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_ROLE_ID")
@@ -59,14 +58,5 @@
public void setPgAuthorityId(PgAuthority pgAuthorityId) {
this.pgAuthorityId = pgAuthorityId;
}
-//
-// @OneToMany(fetch = FetchType.LAZY, mappedBy = "pgRoleId")
-// public List getPgUsers() {
-// return pgUsers;
-// }
-//
-// public void setPgUsers(List pgUsers) {
-// this.pgUsers = pgUsers;
-// }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
index 9fdc491..1174d01 100644
--- a/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
+++ b/src/main/java/com/casic/PgInterface/patroler/domain/PgUser.java
@@ -21,10 +21,9 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private Long roleId;//角色
private int active;//状态位
-// private PgRole pgRoleId;//权限
private List pgAlarms;
- private List pgLogs;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_PG_USER_ID")
@@ -90,16 +89,14 @@
this.active = active;
}
-// @ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.PERSIST})
-// @NotFound(action = NotFoundAction.IGNORE)
-// @JoinColumn(name = "ROLEID")
-// public PgRole getPgRoleId() {
-// return pgRoleId;
-// }
-//
-// public void setPgRoleId(PgRole pgRoleId) {
-// this.pgRoleId = pgRoleId;
-// }
+ @Column(name = "ROLEID")
+ public Long getRoleId() {
+ return roleId;
+ }
+
+ public void setRoleId(Long roleId) {
+ this.roleId = roleId;
+ }
@OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
public List getPgAlarms() {
@@ -110,12 +107,4 @@
this.pgAlarms = pgAlarms;
}
- @OneToMany(fetch = FetchType.LAZY, mappedBy = "userId")
- public List getPgLogs() {
- return pgLogs;
- }
-
- public void setPgLogs(List pgLogs) {
- this.pgLogs = pgLogs;
- }
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
index 9484c9e..4f99951 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgLogDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgLog;
+import com.casic.PgInterface.patroler.manager.PgUserManager;
import java.text.SimpleDateFormat;
@@ -55,14 +56,15 @@
this.active = active;
}
- public PgLogDto(PgLog pgLog) {
+ public PgLogDto(PgLog pgLog, PgUserManager pgUserManager) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
this.setId(String.valueOf(pgLog.getId()));
this.setOperate(pgLog.getOperate());
if(pgLog.getUserId()==null)
this.setUserName("");
else
- this.setUserName(pgLog.getUserId().getUserName());
+ this.setUserName(pgUserManager.get(pgLog.getUserId()).getUserName());
+
if (pgLog.getOperateTime() != null)
this.setOperateTime(sdf.format(pgLog.getOperateTime()));
else
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
index d75f2aa..9ecf4a1 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgUserDto.java
@@ -1,6 +1,7 @@
package com.casic.PgInterface.patroler.dto;
import com.casic.PgInterface.patroler.domain.PgUser;
+import com.casic.PgInterface.patroler.manager.PgRoleManager;
/**
* Created by yxw on 2017/11/2.
@@ -13,6 +14,7 @@
private String department;//部门
private String post;//职务
private String phoneNumber;//电话
+ private String role;//角色
private String active;//状态位
public String getId() {
@@ -71,15 +73,27 @@
this.active = active;
}
- public PgUserDto(PgUser pgPatroler)
+ public String getRole() {
+ return role;
+ }
+
+ public void setRole(String role) {
+ this.role = role;
+ }
+
+ public PgUserDto(PgUser pgUser, PgRoleManager pgRoleManager)
{
- this.setId(String.valueOf(pgPatroler.getId()));
- this.setUserName(pgPatroler.getUserName());
- this.setPassword(pgPatroler.getPassword());
- this.setDepartment(pgPatroler.getDepartment());
- this.setPhoneNumber(pgPatroler.getPhoneNumber());
- this.setPost(pgPatroler.getPost());
- this.setActive(String.valueOf(pgPatroler.getActive()));
+ this.setId(String.valueOf(pgUser.getId()));
+ this.setUserName(pgUser.getUserName());
+ this.setPassword(pgUser.getPassword());
+ this.setDepartment(pgUser.getDepartment());
+ this.setPhoneNumber(pgUser.getPhoneNumber());
+ this.setPost(pgUser.getPost());
+ this.setActive(String.valueOf(pgUser.getActive()));
+ if(pgUser.getRoleId()==null)
+ this.setRole("");
+ else
+ this.setRole(pgRoleManager.get(pgUser.getRoleId()).getRole());
}
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
index e76bd4c..849d74b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgInPgPersonManager.java
@@ -21,12 +21,8 @@
@Service
public class PgInPgPersonManager extends HibernateEntityDao {
- private PgInPgStatusManager pgInPgStatusManager;
-
@Resource
- public void setPgInPgStatusManager(PgInPgStatusManager pgInPgStatusManager) {
- this.pgInPgStatusManager = pgInPgStatusManager;
- }
+ private PgInPgStatusManager pgInPgStatusManager;
public PgInPgPerson getPersonByUserName(String userName) {
List pgInPgPersonList = null;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
index 05a5901..dd5dc67 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgLogManager.java
@@ -21,20 +21,16 @@
@Service
public class PgLogManager extends HibernateEntityDao {
- private PgUserManager pgPatrolerManager;
-
@Resource
- public void setPgPatrolerManager(PgUserManager pgPatrolerManager) {
- this.pgPatrolerManager = pgPatrolerManager;
- }
+ private PgUserManager pgUserManager;
+
//获取当前设备列表
- //TODO LIST getAllLOgs
public List getAllLogs(String userName,String startTime,String endTime) {
try {
Criteria criteria = createCriteria(PgLog.class);
if (StringUtils.isNotBlank(userName)) {
- criteria.add(Restrictions.eq("userId", pgPatrolerManager.getPatrolerByuserName(userName)));
+ criteria.add(Restrictions.eq("userId", pgUserManager.getPatrolerByuserName(userName)));
}
if (StringUtils.isNotBlank(startTime)) {
@@ -53,7 +49,7 @@
List pgLogList = criteria.list();
List pgLogDtoList = new ArrayList();
for (PgLog pgLog : pgLogList) {
- pgLogDtoList.add(new PgLogDto(pgLog));
+ pgLogDtoList.add(new PgLogDto(pgLog,pgUserManager));
}
return pgLogDtoList;
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
index d2b9db4..cb42943 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgUserManager.java
@@ -8,6 +8,7 @@
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -17,6 +18,9 @@
@Service
public class PgUserManager extends HibernateEntityDao {
+ @Resource
+ private PgRoleManager pgRoleManager;
+
//获取当前人员列表
//TODO LIST List getAll()
public List getAllUser() {
@@ -26,9 +30,9 @@
criteria.addOrder(Order.desc("id"));
List pgUserList=criteria.list();
- List pgUserDtoList = new ArrayList();
+ List pgUserDtoList = new ArrayList<>();
for (PgUser pgUser : pgUserList){
- pgUserDtoList.add(new PgUserDto(pgUser));
+ pgUserDtoList.add(new PgUserDto(pgUser,pgRoleManager));
}
return pgUserDtoList;
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
index d64dc52..d18ebb8 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
@@ -102,52 +102,6 @@
return resultMap;
}
-/*
- */
-/**
- * 新增报警
- *//*
-
- @POST
- @Path("addAlarm")
- @Produces(MediaType.APPLICATION_JSON)
- public Map addAlarm(@FormParam("alarmType") String alarmType,
- @FormParam("alarmValue") String alarmValue,
- @FormParam("alarmDate") String alarmDate,
- @FormParam("description") String description,
- @FormParam("devCode") String devCode,
- @FormParam("userName") String userName) throws Exception {
- Map resultMap = new HashMap();
- String result = "";
- String msg = "";
-
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- try {
- PgAlarm pgAlarm = new PgAlarm();
- pgAlarm.setAlarmTypeId(pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType));
- pgAlarm.setAlarmValue(alarmValue);
- pgAlarm.setAlarmDate(sdf.parse(alarmDate));
- pgAlarm.setDescription(description);
- pgAlarm.setUserId(pgPatrolerManager.getPatrolerByuserName(userName));
- pgAlarm.setAlarmDevId(pgDeviceManager.getDeviceBydevCode(devCode));
- pgAlarm.setActive(1);
-
- logger.info("成功保存");
- pgAlarmManager.save(pgAlarm);
- result = "true";
- msg = "保存成功";
- } catch (Exception e) {
- result = "false";
- msg = "保存失败";
- e.printStackTrace();
- }
-
- resultMap.put("result", result);
- resultMap.put("msg", msg);
- return resultMap;
- }
-*/
-
/*
* 根据报警类型和时间查询报警记录
*/
diff --git a/src/main/java/com/casic/PgInterface/rs/PgLogRs.java b/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
index 998345b..1621666 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgLogRs.java
@@ -41,8 +41,6 @@
@FormParam("operate") String operate)
throws Exception {
- //SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
-
Map resultMap = new HashMap();
String result = "";
String msg = "";
@@ -51,7 +49,7 @@
PgUser pgUser = new PgUser();
pgUser = pgPatrolerManager.getPatrolerByuserName(userName);
- pgLog.setUserId(pgUser);
+ pgLog.setUserId(pgUser.getId());
pgLog.setOperate(operate);
pgLog.setOperateTime(new Date());
pgLog.setActive(1);
diff --git a/src/main/java/com/casic/PgInterface/rs/PgUserRs.java b/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
index cac8922..10aff34 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgUserRs.java
@@ -1,5 +1,6 @@
package com.casic.PgInterface.rs;
+import com.casic.PgInterface.patroler.domain.PgRole;
import com.casic.PgInterface.patroler.domain.PgUser;
import com.casic.PgInterface.patroler.dto.PgUserDto;
import com.casic.PgInterface.patroler.manager.PgRoleManager;
@@ -64,17 +65,18 @@
@Path("addUser")
@Produces(MediaType.APPLICATION_JSON)
public Map addUser(@FormParam("userName") String userName,
- @FormParam("password") String password,
- @FormParam("department") String department,
- @FormParam("post") String post,
- @FormParam("phoneNumber") String phoneNumber
+ @FormParam("password") String password,
+ @FormParam("department") String department,
+ @FormParam("post") String post,
+ @FormParam("phoneNumber") String phoneNumber,
+ @FormParam("role") String role
)throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap<>();
String result = "";
String msg = "";
try {
-// PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
+ PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
if (pgUserManager.userNameIsExits(userName)) {
result = "false";
@@ -83,12 +85,14 @@
PgUser pgUser = new PgUser();
pgUser.setUserName(userName);
- //String pass = StringUtils.getMD5(password);
pgUser.setPassword(password);
pgUser.setDepartment(department);
pgUser.setPost(post);
pgUser.setPhoneNumber(phoneNumber);
-// pgUser.setPgRoleId(pgRole);
+ if(pgRole==null)
+ pgUser.setRoleId(null);
+ else
+ pgUser.setRoleId(pgRole.getId());
pgUser.setActive(1);
logger.info("成功保存");
@@ -114,19 +118,20 @@
@Path("editUser")
@Produces(MediaType.APPLICATION_JSON)
public Map editUser(@FormParam("id") String id,
- @FormParam("userName") String userName,
- @FormParam("password") String password,
- @FormParam("department") String department,
- @FormParam("post") String post,
- @FormParam("phoneNumber") String phoneNumber
+ @FormParam("userName") String userName,
+ @FormParam("password") String password,
+ @FormParam("department") String department,
+ @FormParam("post") String post,
+ @FormParam("phoneNumber") String phoneNumber,
+ @FormParam("role") String role
) throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap<>();
String result = "";
String msg = "";
try {
-// PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
+ PgRole pgRole=pgRoleManager.getPgRoleByRole(role);
PgUser pgUser = pgUserManager.get(Long.valueOf(id));
pgUser.setUserName(userName);
@@ -134,7 +139,10 @@
pgUser.setDepartment(department);
pgUser.setPost(post);
pgUser.setPhoneNumber(phoneNumber);
-// pgUser.setPgRoleId(pgRole);
+ if(pgRole==null)
+ pgUser.setRoleId(null);
+ else
+ pgUser.setRoleId(pgRole.getId());
pgUserManager.save(pgUser);
result = "true";
msg = "编辑成功";
@@ -158,7 +166,7 @@
@Produces(MediaType.APPLICATION_JSON)
public Map deleteUser(@FormParam("id") String id)throws Exception {
- Map resultMap = new HashMap();
+ Map resultMap = new HashMap();
String msg="";
String result="false";
diff --git "a/\346\216\245\345\217\243\350\257\264\346\230\21620190726.docx" "b/\346\216\245\345\217\243\350\257\264\346\230\21620190726.docx"
index 60b395f..75b67e4 100644
--- "a/\346\216\245\345\217\243\350\257\264\346\230\21620190726.docx"
+++ "b/\346\216\245\345\217\243\350\257\264\346\230\21620190726.docx"
Binary files differ
diff --git "a/\347\256\241\345\273\212\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241\350\257\264\346\230\21620190612.docx" "b/\347\256\241\345\273\212\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241\350\257\264\346\230\21620190612.docx"
index 87182ff..4f60807 100644
--- "a/\347\256\241\345\273\212\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241\350\257\264\346\230\21620190612.docx"
+++ "b/\347\256\241\345\273\212\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241\350\257\264\346\230\21620190612.docx"
Binary files differ