DataService.java 9.1 KB

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