Mercurial > lada > lada-server

annotate src/main/java/de/intevation/lada/rest/AuditTrailService.java @ 1308:db46646375e3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added action to probe audit trail.
author Raimund Renkert <raimund.renkert@intevation.de>
date Wed, 08 Mar 2017 09:44:11 +0100
parents e51c56914e52
children d531e8e8afa2
rev   line source
1301
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
1 /* Copyright (C) 2013 by Bundesamt fuer Strahlenschutz
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
2 * Software engineering by Intevation GmbH
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
3 *
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
4 * This file is Free Software under the GNU GPL (v>=3)
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
5 * and comes with ABSOLUTELY NO WARRANTY! Check out
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
6 * the documentation coming with IMIS-Labordaten-Application for details.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
7 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
8 package de.intevation.lada.rest;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
9
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
10 import java.util.HashMap;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
11 import java.util.Iterator;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
12 import java.util.List;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
13 import java.util.Map;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
14
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
15 import javax.annotation.PostConstruct;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
16 import javax.enterprise.context.RequestScoped;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
17 import javax.inject.Inject;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
18 import javax.persistence.EntityManager;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
19 import javax.servlet.http.HttpServletRequest;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
20 import javax.ws.rs.GET;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
21 import javax.ws.rs.Path;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
22 import javax.ws.rs.PathParam;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
23 import javax.ws.rs.Produces;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
24 import javax.ws.rs.core.Context;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
25 import javax.ws.rs.core.MediaType;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
26
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
27 import org.apache.log4j.Logger;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
28
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
29 import com.fasterxml.jackson.databind.ObjectMapper;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
30 import com.fasterxml.jackson.databind.node.ArrayNode;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
31 import com.fasterxml.jackson.databind.node.ObjectNode;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
32
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
33 import de.intevation.lada.model.land.AuditTrailMessung;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
34 import de.intevation.lada.model.land.AuditTrailProbe;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
35 import de.intevation.lada.model.land.Messung;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
36 import de.intevation.lada.model.land.Probe;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
37 import de.intevation.lada.util.annotation.AuthorizationConfig;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
38 import de.intevation.lada.util.annotation.RepositoryConfig;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
39 import de.intevation.lada.util.auth.Authorization;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
40 import de.intevation.lada.util.auth.AuthorizationType;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
41 import de.intevation.lada.util.data.QueryBuilder;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
42 import de.intevation.lada.util.data.Repository;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
43 import de.intevation.lada.util.data.RepositoryType;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
44
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
45 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
46 * REST service for AuditTrail.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
47 * <p>
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
48 * The services produce data in the application/json media type.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
49 * All HTTP methods use the authorization module to determine if the user is
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
50 * allowed to perform the requested action.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
51 * A typical response holds information about the action performed and the data.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
52 * <pre>
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
53 * <code>
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
54 * {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
55 * "success": [boolean];
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
56 * "message": [string],
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
57 * "data":[{
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
58 * "id": [number],
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
59 * "identifier: [string]
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
60 * "audit": [array]
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
61 * }],
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
62 * }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
63 * </code>
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
64 * </pre>
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
65 *
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
66 * @author <a href="mailto:rrenkert@intevation.de">Raimund Renkert</a>
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
67 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
68 @Path("rest/audit")
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
69 @RequestScoped
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
70 public class AuditTrailService {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
71
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
72 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
73 * Class to store tablename and value field for foreign key mappings.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
74 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
75 private class TableMapper {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
76 public String mappingTable;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
77 public String valueField;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
78
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
79 public TableMapper(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
80 String mappingTable,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
81 String valueField
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
82 ) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
83 this.mappingTable = mappingTable;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
84 this.valueField = valueField;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
85 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
86 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
87
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
88 @Inject Logger logger;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
89 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
90 * The data repository granting read/write access.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
91 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
92 @Inject
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
93 @RepositoryConfig(type=RepositoryType.RO)
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
94 private Repository repository;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
95
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
96 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
97 * The authorization module.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
98 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
99 @Inject
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
100 @AuthorizationConfig(type=AuthorizationType.HEADER)
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
101 private Authorization authorization;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
102
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
103 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
104 * Map foreign key to their associated table and the display value.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
105 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
106 private Map<String, TableMapper> mappings;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
107
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
108 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
109 * Initialize the object with key <-> table mappings.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
110 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
111 @PostConstruct
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
112 public void initialize() {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
113 mappings = new HashMap<String, TableMapper>();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
114 mappings.put("messgroesse_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
115 new TableMapper("messgroesse", "messgroesse"));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
116 mappings.put("meh_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
117 new TableMapper("mess_einheit", "einheit"));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
118 mappings.put("ort_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
119 new TableMapper("ort", "ort_id"));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
120 mappings.put("datenbasis_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
121 new TableMapper("datenbasis", "datenbasis"));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
122 mappings.put("ba_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
123 new TableMapper("betriebsart", "name"));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
124 mappings.put("mpl_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
125 new TableMapper("messprogramm_kategorie", "code"));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
126 mappings.put("probenart_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
127 new TableMapper("probenart", "probenart"));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
128 mappings.put("probe_nehmer_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
129 new TableMapper("probenehmer", "prn_id"));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
130 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
131
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
132 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
133 * Service to generate audit trail for probe objects.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
134 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
135 @GET
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
136 @Path("/probe/{id}")
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
137 @Produces(MediaType.APPLICATION_JSON)
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
138 public String getProbe(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
139 @Context HttpServletRequest request,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
140 @PathParam("id") String id
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
141 ) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
142 if (id == null || "".equals(id)) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
143 String ret = "{\"success\": false," +
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
144 "\"message\":698,\"data\":null}";
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
145 return ret;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
146 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
147 Integer pId = null;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
148 try {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
149 pId = Integer.valueOf(id);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
150 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
151 catch(NumberFormatException nfe) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
152 String ret = "{\"success\": false," +
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
153 "\"message\":600,\"data\":null}";
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
154 return ret;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
155 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
156
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
157 // Get all entries for the probe and its sub objects.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
158 QueryBuilder<AuditTrailProbe> builder =
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
159 new QueryBuilder<AuditTrailProbe>(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
160 repository.entityManager("land"),
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
161 AuditTrailProbe.class);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
162 builder.and("objectId", id);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
163 builder.and("tableName", "probe");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
164 builder.or("probeId", id);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
165 builder.orderBy("tstamp", true);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
166 List<AuditTrailProbe> audit =
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
167 repository.filterPlain(builder.getQuery(), "land");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
168
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
169 // Get the plain probe object to have the hauptproben_nr.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
170 // If only subobjects
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
171 Probe probe = repository.getByIdPlain(Probe.class, pId, "land");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
172 // Create an empty JsonObject
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
173 ObjectMapper mapper = new ObjectMapper();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
174 ObjectNode responseNode = mapper.createObjectNode();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
175 responseNode.put("success", true);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
176 responseNode.put("message", 200);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
177 ObjectNode auditJson = responseNode.putObject("data");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
178 ArrayNode entries = auditJson.putArray("audit");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
179 auditJson.put("id", probe.getId());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
180 auditJson.put("identifier", probe.getHauptprobenNr());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
181 for (AuditTrailProbe a : audit) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
182 entries.add(createEntry(a, mapper));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
183 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
184 return responseNode.toString();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
185 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
186
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
187 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
188 * Create a JSON object for an AuditTrailProbe entry.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
189 *
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
190 * @param audit The table entry
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
191 * @param mapper JSON object mapper
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
192 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
193 private ObjectNode createEntry(AuditTrailProbe audit, ObjectMapper mapper) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
194 ObjectNode node = mapper.createObjectNode();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
195 node.put("timestamp", audit.getTstamp().getTime());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
196 node.put("type", audit.getTableName());
1308
db46646375e3 Added action to probe audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 1304
diff changeset
197 node.put("action", audit.getAction());
1301
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
198 ObjectNode data = (ObjectNode)audit.getChangedFields();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
199 data = translateIds(data);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
200 node.putPOJO("changedFields", data);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
201 if ("kommentar_p".equals(audit.getTableName())) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
202 node.put("identifier", audit.getRowData().get("datum").toString());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
203 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
204 if ("zusatz_wert".equals(audit.getTableName())) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
205 node.put("identifier", audit.getRowData().get("pzs_id").toString());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
206 }
1304
e51c56914e52 Fixed typo in audit trail service.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 1301
diff changeset
207 if ("ortszuordnung".equals(audit.getTableName())) {
1301
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
208 String value = translateId(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
209 "ort",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
210 "ort_id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
211 audit.getRowData().get("ort_id").toString(),
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
212 "id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
213 "stamm");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
214 node.put("identifier", value);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
215 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
216 if ("messung".equals(audit.getTableName())) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
217 logger.debug("npr: " + audit.getRowData());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
218 node.put("identifier",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
219 audit.getRowData()
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
220 .get("nebenproben_nr").toString().replaceAll("\"", ""));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
221 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
222 if (audit.getMessungsId() != null) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
223 Messung m = repository.getByIdPlain(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
224 Messung.class, audit.getMessungsId(), "land");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
225 ObjectNode identifier = node.putObject("identifier");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
226 identifier.put("messung", m.getNebenprobenNr());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
227 if ("kommentar_m".equals(audit.getTableName())) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
228 identifier.put("identifier",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
229 audit.getRowData().get("datum").toString());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
230 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
231 if ("messwert".equals(audit.getTableName())) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
232 String value = translateId(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
233 "messgroesse",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
234 "messgroesse",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
235 audit.getRowData().get("messgroesse_id").toString(),
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
236 "id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
237 "stamm");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
238 identifier.put("identifier", value);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
239 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
240 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
241 return node;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
242 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
243
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
244 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
245 * Service to generate audit trail for messung objects.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
246 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
247 @GET
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
248 @Path("/messung/{id}")
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
249 @Produces(MediaType.APPLICATION_JSON)
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
250 public String getMessung(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
251 @Context HttpServletRequest request,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
252 @PathParam("id") String id
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
253 ) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
254 if (id == null || "".equals(id)) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
255 String ret = "{\"success\": false," +
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
256 "\"message\":698,\"data\":null}";
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
257 return ret;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
258 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
259 Integer mId = null;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
260 try {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
261 mId = Integer.valueOf(id);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
262 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
263 catch(NumberFormatException nfe) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
264 String ret = "{\"success\": false," +
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
265 "\"message\":600,\"data\":null}";
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
266 return ret;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
267 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
268 QueryBuilder<AuditTrailMessung> builder =
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
269 new QueryBuilder<AuditTrailMessung>(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
270 repository.entityManager("land"),
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
271 AuditTrailMessung.class);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
272 builder.and("objectId", mId);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
273 builder.and("tableName", "messung");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
274 builder.or("messungsId", mId);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
275 builder.orderBy("tstamp", true);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
276 List<AuditTrailMessung> audit =
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
277 repository.filterPlain(builder.getQuery(), "land");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
278
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
279 Messung messung = repository.getByIdPlain(Messung.class, mId, "land");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
280 // Create an empty JsonObject
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
281 ObjectMapper mapper = new ObjectMapper();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
282 ObjectNode responseNode = mapper.createObjectNode();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
283 responseNode.put("success", true);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
284 responseNode.put("message", 200);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
285 ObjectNode auditJson = responseNode.putObject("data");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
286 ArrayNode entries = auditJson.putArray("audit");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
287 auditJson.put("id", messung.getId());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
288 auditJson.put("identifier", messung.getNebenprobenNr());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
289 for (AuditTrailMessung a : audit) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
290 entries.add(createEntry(a, mapper));
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
291 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
292 return responseNode.toString();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
293 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
294
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
295 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
296 * Create a JSON object for an AuditTrailMessung entry.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
297 *
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
298 * @param audit The table entry
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
299 * @param mapper JSON object mapper
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
300 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
301 private ObjectNode createEntry(AuditTrailMessung audit, ObjectMapper mapper) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
302 ObjectNode node = mapper.createObjectNode();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
303 node.put("timestamp", audit.getTstamp().getTime());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
304 node.put("type", audit.getTableName());
1308
db46646375e3 Added action to probe audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 1304
diff changeset
305 node.put("action", audit.getAction());
1301
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
306 ObjectNode data = (ObjectNode)audit.getChangedFields();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
307 node.putPOJO("changedFields", data);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
308 if ("kommentar_m".equals(audit.getTableName())) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
309 node.put("identifier", audit.getRowData().get("datum").toString());
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
310 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
311 if ("messwert".equals(audit.getTableName())) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
312 String value = translateId(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
313 "messgroesse",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
314 "messgroesse",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
315 audit.getRowData().get("messgroesse_id").toString(),
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
316 "id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
317 "stamm");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
318 node.put("identifier", value);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
319 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
320 return node;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
321 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
322
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
323 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
324 * Translate a foreign key into the associated value.
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
325 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
326 private String translateId(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
327 String table,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
328 String field,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
329 String id,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
330 String idField,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
331 String source
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
332 ) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
333 EntityManager manager = repository.entityManager(source);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
334 String sql = "SELECT " + field + " FROM " + table +
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
335 " WHERE " + idField + " = " + id + ";";
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
336 javax.persistence.Query query = manager.createNativeQuery(sql);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
337 List<String> result = query.getResultList();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
338 return result.get(0);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
339 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
340
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
341 /**
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
342 * Translate all known foreign keys
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
343 */
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
344 private ObjectNode translateIds(ObjectNode node) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
345 for (Iterator<String> i = node.fieldNames(); i.hasNext();) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
346 String key = i.next();
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
347 if (mappings.containsKey(key)) {
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
348 TableMapper m = mappings.get(key);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
349 String value = translateId(
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
350 m.mappingTable,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
351 m.valueField,
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
352 node.get(key).asText(),
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
353 "id",
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
354 "stamm");
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
355 node.put(key, value);
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
356 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
357 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
358 return node;
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
359 }
a3f281b350f2 Added service for audit trail.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
360 }
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)