@RequestMapping(
value = "/getCityApi",
method = {RequestMethod.GET, RequestMethod.POST})
public String getCityApi(
HttpServletRequest request,
@RequestParam(value = "locationname") String locationname,
ModelMap model) {
Map<Object, Object> map = new HashMap<Object, Object>();
JSONArray jSONArray = new JSONArray();
try {
String status = "active";
List<City> cityList = cityService.getCityApi(locationname, status);
if (cityList != null && cityList.size() > 0) {
for (int i = 0; i < cityList.size(); i++) {
City city = (City) cityList.get(i);
String cityName = (String) city.getCity();
String stateName = (String) city.getState();
int ID = (Integer) (city.getId());
JSONObject jSONObject = new JSONObject();
jSONObject.put("id", ID);
jSONObject.put("text", cityName);
jSONArray.put(jSONObject);
}
utilities.setSuccessResponse(response, jSONArray.toString());
} else {
throw new ConstException(ConstException.ERR_CODE_NO_DATA, ConstException.ERR_MSG_NO_DATA);
}
} catch (Exception ex) {
logger.error("getCity :" + ex.getMessage());
utilities.setErrResponse(ex, response);
}
model.addAttribute("model", jSONArray.toString());
return "home";
}
public Map getTaskMapBatch(String objectId) throws Exception {
Map map = new HashMap();
String apiURL = "https://rally1.rallydev.com/slm/webservice/1.34/adhoc";
String requestJSON =
"{"
+ "\"task\" : \"/task?query=(ObjectID%20=%20"
+ objectId
+ ")&fetch=true\","
+ "\"userstory\" : \"/hierarchicalrequirement?query=(ObjectID%20=%20${task.WorkProduct.ObjectID})&fetch=FormattedID\","
+ "\"timeentryitem\":\"/timeentryitem?query=(Task.ObjectID%20=%20"
+ objectId
+ ")&fetch=Values\","
+ "\"timespent\":\"${timeentryitem.Values.Hours}\""
+ "}";
log.info("apiURL=" + apiURL);
log.info("requestJSON=" + requestJSON);
String responseJSON = postRallyXML(apiURL, requestJSON);
// log.info("responseJSON="+responseJSON);
// Map jsonMap=JsonUtil.jsonToMap(responseJSON);
JSONParser parser = new JSONParser();
Map jsonMap = (Map) parser.parse(responseJSON);
// log.info("jsonMap="+jsonMap);
String taskObjId = "";
String taskFormattedId = "";
String taskName = "";
String estimate = "";
String toDo = "";
String taskState = "";
String taskOwner = "";
String userstoryFormattedId = "";
// Get task info
JSONObject taskMap = (JSONObject) jsonMap.get("task");
JSONArray taskArray = (JSONArray) taskMap.get("Results");
if (taskArray != null && taskArray.size() > 0) {
JSONObject taskInfo = (JSONObject) taskArray.get(0);
// log.info("taskMap="+taskMap);
// log.info("taskInfo="+taskInfo);
taskObjId = (taskInfo.get("ObjectID")).toString();
taskFormattedId = (taskInfo.get("FormattedID")).toString();
taskState = (taskInfo.get("State")).toString();
Object taskNameObj = taskInfo.get("Name");
taskName = taskNameObj == null ? "" : taskNameObj.toString();
Object estimateObject = taskInfo.get("Estimate");
estimate = estimateObject == null ? "" : estimateObject.toString();
Object toDoObject = taskInfo.get("ToDo");
toDo = toDoObject == null ? "" : toDoObject.toString();
JSONObject ownerMap = (JSONObject) taskInfo.get("Owner");
log.info("ownerMap=" + ownerMap);
if (ownerMap != null) {
taskOwner = (String) ownerMap.get("_refObjectName");
if (taskOwner == null) {
taskOwner = "";
}
}
}
// Get user story info
JSONObject userstoryMap = (JSONObject) jsonMap.get("userstory");
JSONArray userstoryArray = (JSONArray) userstoryMap.get("Results");
if (userstoryArray != null && userstoryArray.size() > 0) {
JSONObject userstoryInfo = (JSONObject) userstoryArray.get(0);
userstoryFormattedId = (userstoryInfo.get("FormattedID")).toString();
log.info("userstoryFormattedId=" + userstoryFormattedId);
}
// Calculate timeSpent
JSONArray timeSpentList = (JSONArray) jsonMap.get("timespent");
log.info("timeSpentList=" + timeSpentList);
double timeSpent = 0.0;
for (int i = 0; i < timeSpentList.size(); i++) {
String timeSpentString = (String) timeSpentList.get(i);
if (timeSpentString != null) {
timeSpent += Double.parseDouble(timeSpentString);
}
}
map.put("type", "task");
map.put("formattedId", taskFormattedId);
map.put("usId", userstoryFormattedId);
map.put("name", taskName);
map.put("taskStatus", taskState);
map.put("owner", taskOwner);
map.put("taskEstimateTotal", estimate);
map.put("taskRemainingTotal", toDo);
map.put("taskTimeSpentTotal", "" + timeSpent);
return map;
}
public Map getUserStoryTaskMap(String timeEntryItemRef) throws Exception {
Map taskMap = new HashMap();
String[] objectIdArr = timeEntryItemRef.split("/");
String objectId = objectIdArr[objectIdArr.length - 1];
log.info("objectId=" + objectId);
String apiURL = "https://rally1.rallydev.com/slm/webservice/1.34/adhoc";
String requestJSON =
"{"
+ "\"timeentryitem\" : \"/timeentryitem?query=(ObjectID%20=%20"
+ objectId
+ ")&fetch=true\","
+ "\"task\" : \"/task?query=(ObjectID%20=%20${timeentryitem.Task.ObjectID})&fetch=true\","
+ "\"userstory\" : \"/hierarchicalrequirement?query=(ObjectID%20=%20${task.WorkProduct.ObjectID})&fetch=true\","
+ "\"defect\" : \"/defect?query=(ObjectID%20=%20${task.WorkProduct.ObjectID})&fetch=true\""
+ "}";
log.info("apiURL=" + apiURL);
log.info("requestJSON=" + requestJSON);
String responseJSON = postRallyXML(apiURL, requestJSON);
// Bypass"%;" to avoid exception
responseJSON = responseJSON.replace("%;", ";");
responseJSON = responseJSON.replace("%", "");
Map jsonMap = JsonUtil.jsonToMap(responseJSON);
String usRef = "";
String usName = "";
String usFormattedId = "";
String usPlanEstimate = "";
String usTaskEstimateTotal = "";
String usTaskRemainingTotal = "";
String usState = "";
String usOwner = "";
Map usMap = new HashMap();
// Get user story info
JSONObject userstoryMap = (JSONObject) jsonMap.get("userstory");
JSONArray userstoryArray = (JSONArray) userstoryMap.get("Results");
if (userstoryArray == null || userstoryArray.size() == 0) {
userstoryMap = (JSONObject) jsonMap.get("defect");
userstoryArray = (JSONArray) userstoryMap.get("Results");
}
if (userstoryArray != null && userstoryArray.size() > 0) {
JSONObject userstoryInfo = (JSONObject) userstoryArray.get(0);
// log.info("userstoryInfo="+userstoryInfo);
usRef = (userstoryInfo.get("_ref")).toString();
usFormattedId = (userstoryInfo.get("FormattedID")).toString();
usName = (userstoryInfo.get("Name")).toString();
usState = (userstoryInfo.get("ScheduleState")).toString();
if (userstoryInfo.get("PlanEstimate") != null)
usPlanEstimate = (userstoryInfo.get("PlanEstimate")).toString();
if (userstoryInfo.get("TaskEstimateTotal") != null)
usTaskEstimateTotal = (userstoryInfo.get("TaskEstimateTotal")).toString();
if (userstoryInfo.get("TaskRemainingTotal") != null)
usTaskRemainingTotal = (userstoryInfo.get("TaskRemainingTotal")).toString();
JSONObject ownerMap = (JSONObject) userstoryInfo.get("Owner");
if (ownerMap != null) {
usOwner = (String) ownerMap.get("_refObjectName");
if (usOwner == null) {
usOwner = "";
}
}
}
Map usDetailMap = new HashMap();
usDetailMap.put("usFormattedId", usFormattedId);
usDetailMap.put("usName", usName);
usDetailMap.put("usPlanEstimate", usPlanEstimate);
usDetailMap.put("usTaskEstimateTotal", usTaskEstimateTotal);
usDetailMap.put("usTaskRemainingTotal", usTaskRemainingTotal);
usDetailMap.put("usOwner", usOwner);
usDetailMap.put("usState", usState);
usMap.put(usRef, usDetailMap);
// log.info("usMap="+usMap);
String taskObjId = "";
String taskFormattedId = "";
String taskName = "";
String estimate = "";
String toDo = "";
String taskState = "";
String taskOwner = "";
String projectName = "";
String iterationName = "";
String workProductRef = "";
List taskList = new ArrayList();
// Get task info
JSONObject taskJsonMap = (JSONObject) jsonMap.get("task");
JSONArray taskArray = (JSONArray) taskJsonMap.get("Results");
if (taskArray != null && taskArray.size() > 0) {
for (int i = 0; i < taskArray.size(); i++) {
JSONObject taskInfo = (JSONObject) taskArray.get(0);
// log.info("taskMap="+taskMap);
// log.info("taskInfo="+taskInfo);
taskObjId = (taskInfo.get("ObjectID")).toString();
taskFormattedId = (taskInfo.get("FormattedID")).toString();
taskState = (taskInfo.get("State")).toString();
Object taskNameObj = taskInfo.get("Name");
taskName = taskNameObj == null ? "" : taskNameObj.toString();
Object estimateObject = taskInfo.get("Estimate");
estimate = estimateObject == null ? "" : estimateObject.toString();
Object toDoObject = taskInfo.get("ToDo");
toDo = toDoObject == null ? "" : toDoObject.toString();
JSONObject ownerMap = (JSONObject) taskInfo.get("Owner");
// log.info("ownerMap="+ownerMap);
if (ownerMap != null) {
taskOwner = (String) ownerMap.get("_refObjectName");
if (taskOwner == null) {
taskOwner = "";
}
}
JSONObject workProductMap = (JSONObject) taskInfo.get("WorkProduct");
// log.info("workProductMap="+workProductMap);
if (workProductMap != null) {
workProductRef = (String) workProductMap.get("_ref");
if (workProductRef == null) {
workProductRef = "";
}
}
JSONObject projectMap = (JSONObject) taskInfo.get("Project");
// log.info("projectMap="+projectMap);
if (projectMap != null) {
projectName = (String) projectMap.get("_refObjectName");
if (projectName == null) {
projectName = "";
}
}
JSONObject iterationMap = (JSONObject) taskInfo.get("Iteration");
// log.info("iterationMap="+iterationMap);
if (iterationMap != null) {
iterationName = (String) iterationMap.get("_refObjectName");
if (iterationName == null) {
iterationName = "";
}
}
taskMap.put("taskFormattedId", taskFormattedId);
taskMap.put("taskName", taskName);
taskMap.put("taskState", taskState);
taskMap.put("owner", taskOwner);
taskMap.put("taskEstimate", estimate);
taskMap.put("taskRemaining", toDo);
taskMap.put("projectName", projectName);
taskMap.put("iterationName", iterationName);
Map map = (Map) usMap.get(workProductRef);
taskMap.put("usName", map.get("usFormattedId") + " " + map.get("usName"));
log.info("taskMap=" + taskMap);
} // for taskArray
}
return taskMap;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
System.out.println("called eventGroupUpload");
response.setContentType("application/json");
response.setHeader("Access-Control-Allow-Origin", "*");
PrintWriter out = response.getWriter();
JSONObject obj = new JSONObject();
ArrayList<String> data = new ArrayList<String>();
String appId = request.getParameter("appId");
String name = request.getParameter("name");
String imgUrl = request.getParameter("imgUrl");
String about = request.getParameter("about");
String rules = request.getParameter("rules");
String contact = request.getParameter("contact");
String callback = request.getParameter("callback");
String responseType = request.getParameter("responseType");
accessToken token = new accessToken();
String accessToken = request.getParameter("accessToken");
if ((accessToken != null) && token.get(accessToken)) {
if (appId == null) {
data.add("appId");
}
if (name == null) {
data.add("name");
}
if (imgUrl == null) {
data.add("imgUrl");
}
if (about == null) {
data.add("about");
}
if (rules == null) {
data.add("rules");
}
if (contact == null) {
data.add("contact");
}
if (data.size() != 0) {
obj.put("response", "error");
obj.put("responseString", "Insufficient Data");
obj.put("data", data);
} else {
try {
beanEventGroupUpload bean = new beanEventGroupUpload();
bean.setAppId(appId);
bean.setName(name);
bean.setImgUrl(imgUrl);
bean.setAbout(about);
bean.setRules(rules);
bean.setContact(contact);
daoEventGroupUpload dao = new daoEventGroupUpload();
bean = dao.create(bean);
if (bean.getValid()) {
obj.put("response", "success");
obj.put("responseString", "event uploaded successfully");
} else {
System.out.println("I am here");
obj.put("response", "error");
obj.put("responseString", bean.getException());
}
} catch (Throwable theException) {
System.out.println("I am here1");
obj.put("response", "error");
obj.put("responseString", theException.toString());
}
}
} else {
obj.put("response", "error");
obj.put("responseString", "Session expired");
}
if (responseType.equals("jsonp")) out.print(callback + "(" + obj + ")");
else out.print(obj);
}
