DataService.java 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240
  1. package cz.hsrs.servlet.provider;
  2. import java.io.IOException;
  3. import java.io.PrintWriter;
  4. import java.sql.SQLException;
  5. import java.util.List;
  6. import javax.naming.AuthenticationException;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.http.HttpServletRequest;
  9. import javax.servlet.http.HttpServletResponse;
  10. import javax.ws.rs.core.HttpHeaders;
  11. import javax.ws.rs.core.MediaType;
  12. import cz.hsrs.db.DBJsonUtils;
  13. import cz.hsrs.db.model.UnitPosition;
  14. import cz.hsrs.db.model.UnitTrack;
  15. import cz.hsrs.db.model.composite.LastPosition;
  16. import cz.hsrs.db.model.composite.RealUnit;
  17. import cz.hsrs.db.model.custom.UnitPositionSimple;
  18. import cz.hsrs.db.util.UnitUtil;
  19. import cz.hsrs.db.util.UserUtil;
  20. import cz.hsrs.db.util.UtilFactory;
  21. import cz.hsrs.servlet.feeder.ServiceParameters;
  22. import cz.hsrs.servlet.security.LoginUser;
  23. /**
  24. * Servlet implementation class DataService
  25. *
  26. * /DataService?Operation=GetDataByUserName&user=pepa&limit=100
  27. * /DataService?Operation=GetUnitsList
  28. * /DataService?Operation=GetUnits
  29. * /DataService?Operation=GetUnitsGeoJson
  30. * /DataService?Operation=GetUnitTypes
  31. */
  32. public class DataService extends DBServlet {
  33. private static final long serialVersionUID = 1L;
  34. private static final String ASC = "ASC";
  35. private static final String DESC = "DESC";
  36. public static final String GET_TRACK = "GetTracks";
  37. public static final String GET_LAST_POSTION = "GetLastPositions";
  38. public static final String GET_LAST_POSTION_WITH_STATUS = "GetLastPositionsWithStatus";
  39. public static final String GET_UNITS = "GetUnits";
  40. public static final String GET_RECENT_TRACK = "GetRecentTracks";
  41. public static final String GET_POSITIONS = "GetPositions";
  42. public static final String GET_POSITIONS_RANGE = "GetPositionsDay";
  43. public static final String GET_UNITS_LIST = "GetUnitsList";
  44. public static final String GET_UNITS_GEOJSON = "GetUnitsGeoJson";
  45. public static final String GET_UNIT_TYPES = "GetUnitTypes";
  46. private UtilFactory db;
  47. public DataService() {
  48. super();
  49. }
  50. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  51. /* CORS Filtering */
  52. String originDomain = request.getHeader("origin");
  53. originDomain = originDomain == null ? "*" : originDomain;
  54. response.addHeader("Access-Control-Allow-Origin", originDomain);
  55. response.addHeader("Access-Control-Allow-Headers", "origin, content-type, accept, authorization");
  56. response.addHeader("Access-Control-Allow-Credentials", "true");
  57. response.addHeader("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS, HEAD");
  58. request.setCharacterEncoding("UTF-8");
  59. response.setCharacterEncoding("UTF-8");
  60. response.addHeader(HttpHeaders.CONTENT_TYPE, MediaType.APPLICATION_JSON);
  61. /*
  62. * /DataService?Operation=GetUnits&user=telemetry&unit_id=356173060488215
  63. * /DataService?Operation=GetTracks&user=telemetry&limit=500
  64. * /DataService?Operation=GetLastPositions&user=telemetry
  65. * /DataService?Operation=GetLastPositionsWithStatus&user=telemetry
  66. * /DataService?Operation=GetRecentTracks&user=telemetry
  67. * /DataService?Operation=GetPositions&user=telemetry&limit=500
  68. * /DataService?Operation=GetPositionsDay&user=telemetry&unit_id=356173060488215&fromTime=2016-02-01&toTime=2016-02-04&ordering=desc
  69. * /DataService?Operation=GetUnitsList&user=telemetry
  70. * /DataService?Operation=GetUnitsGeoJson
  71. */
  72. PrintWriter out = response.getWriter();
  73. RequestParameters params = new RequestParameters(request);
  74. String userId = request.getAttribute("userId").toString();
  75. try {
  76. switch (request.getParameter(ServiceParameters.OPERATION)) {
  77. case GET_UNITS: {
  78. DBJsonUtils.writeJSON(out, new RealUnit(), db.userUtil.getLastPositionsByUserNameRes(userId, params.getUnitId()));
  79. } break;
  80. case GET_TRACK: {
  81. DBJsonUtils.writeJSON(out, new UnitTrack(), db.userUtil.getTracksByUserName(userId, params.limit));
  82. } break;
  83. case GET_LAST_POSTION: {
  84. DBJsonUtils.writeJSON(out, db.userUtil.getLastPositionsByUserName(userId));
  85. } break;
  86. case GET_LAST_POSTION_WITH_STATUS: {
  87. List<LastPosition> posList = db.userUtil.getLastPositionWithStatus(userId);
  88. DBJsonUtils.writeJSON(out, posList);
  89. } break;
  90. case GET_RECENT_TRACK: {
  91. DBJsonUtils.writeJSON(out, new UnitTrack(), db.userUtil.getTracksByUserName(userId, 1000));
  92. } break;
  93. case GET_POSITIONS: {
  94. DBJsonUtils.writeJSON(out, new UnitPosition(), db.userUtil.getPositionsByUserName(userId, params.limit));
  95. } break;
  96. case GET_POSITIONS_RANGE: {
  97. DBJsonUtils.writeJSON(out, new UnitPositionSimple(), db.userUtil.getPositionsTimeRangeByUserName(userId, params.fromTime, params.toTime, params.getUnitId(), params.getOrdering()));
  98. } break;
  99. case GET_UNITS_LIST: {
  100. DBJsonUtils.writeJSON(out, db.userUtil.getUnitsByUser(userId));
  101. } break;
  102. case GET_UNITS_GEOJSON:{
  103. out.write(UserUtil.getUnitsGeoJson(userId));
  104. //DBJsonUtils.writeJSON(out, UserUtil.getUnitsGeoJson(userId));
  105. } break;
  106. case GET_UNIT_TYPES:{
  107. out.write(UnitUtil.getUnitTypes());
  108. } break;
  109. default:
  110. throw new NullPointerException("No operation specified.");
  111. }
  112. } catch (SQLException e) {
  113. solveGetException(e, out);
  114. }
  115. }
  116. @Override
  117. public void init() throws ServletException {
  118. super.init();
  119. try {
  120. db = new UtilFactory();
  121. } catch (Exception e) {
  122. throw new ServletException(e);
  123. }
  124. }
  125. /**
  126. * Request Parameter subclass
  127. * Parses parameter from the request
  128. * @author jezekjan
  129. *
  130. */
  131. static class RequestParameters {
  132. private String user;
  133. private String fromTime;
  134. private String toTime;
  135. private Integer limit;
  136. private Long unitId;
  137. private String ordering;
  138. RequestParameters(HttpServletRequest request) throws NullPointerException{
  139. Object limO = request.getParameter("limit");
  140. if (limO != null) {
  141. limit = Integer.parseInt(limO.toString());
  142. }
  143. Object fromTimeO = request.getParameter("fromTime");
  144. if (fromTimeO != null) {
  145. fromTime = fromTimeO.toString();
  146. }
  147. Object toTimeO = request.getParameter("toTime");
  148. if (toTimeO != null) {
  149. toTime = toTimeO.toString();
  150. }
  151. Object orderingO = request.getParameter("ordering");
  152. if (orderingO != null) {
  153. String orderingS = orderingO.toString();
  154. if(orderingS.isEmpty()){
  155. ordering = ASC;
  156. } else{
  157. ordering = orderingS.equalsIgnoreCase(DESC) ? DESC : ASC;
  158. }
  159. }else{
  160. ordering = ASC;
  161. }
  162. Object unitO = request.getParameter("unit_id");
  163. unitId = unitO != null ? Long.parseLong(unitO.toString()) : null;
  164. }
  165. public Long getUnitId() {
  166. return unitId;
  167. }
  168. public void setUnitId(long unitId) {
  169. this.unitId = unitId;
  170. }
  171. public void setUser(String user) {
  172. this.user = user;
  173. }
  174. public Integer getLimit() {
  175. return limit;
  176. }
  177. public void setLimit(Integer limit) {
  178. this.limit = limit;
  179. }
  180. public String getFromTime() {
  181. return fromTime;
  182. }
  183. public void setFromTime(String fromTime) {
  184. this.fromTime = fromTime;
  185. }
  186. public String getToTime() {
  187. return toTime;
  188. }
  189. public void setToTime(String toTime) {
  190. this.toTime = toTime;
  191. }
  192. public String getOrdering() {
  193. return ordering;
  194. }
  195. public void setOrdering(String ordering) {
  196. this.ordering = ordering;
  197. }
  198. @Override
  199. public String toString() {
  200. return "RequestParameters [user=" + user + ", fromTime=" + fromTime
  201. + ", toTime=" + toTime + ", limit=" + limit + ", unit_id="
  202. + unitId + ", ordering=" + ordering + "]";
  203. }
  204. }
  205. }