DataService.java 10.0 KB

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