public List getUserList() {
List<Map> list = new ArrayList<Map>();
try {
/*
String apiUrl=rallyApiHost+"/user?query="+
"((TeamMemberships%20%3D%20https%3A%2F%2Frally1.rallydev.com%2Fslm%2Fwebservice%2F1.34%2Fproject%2F6169133135)%20or%20"+
"(TeamMemberships%20%3D%20https%3A%2F%2Frally1.rallydev.com%2Fslm%2Fwebservice%2F1.34%2Fproject%2F6083311244))"+
"&fetch=true&order=Name&start=1&pagesize=100";
*/
String apiUrl =
rallyApiHost
+ "/user?query=(Disabled%20=%20false)"
+ "&fetch=true&order=Name&start=1&pagesize=100";
log.info("apiUrl=" + apiUrl);
String responseXML = getRallyXML(apiUrl);
org.jdom.input.SAXBuilder bSAX = new org.jdom.input.SAXBuilder();
org.jdom.Document doc = bSAX.build(new StringReader(responseXML));
Element root = doc.getRootElement();
XPath xpath = XPath.newInstance("//Object");
List xlist = xpath.selectNodes(root);
Iterator iter = xlist.iterator();
while (iter.hasNext()) {
Map map = new HashMap();
Element item = (Element) iter.next();
String userRef = item.getAttribute("ref").getValue();
String userName = item.getAttribute("refObjectName").getValue();
String userObjectId = item.getChildText("ObjectID");
map.put("userRef", userRef);
map.put("userObjectId", userObjectId);
map.put("userName", userName);
list.add(map);
}
} catch (Exception ex) {
log.error("", ex);
}
return list;
}
public List getIterationList(String projectId) {
List<Map> list = new ArrayList<Map>();
try {
String apiUrl =
rallyApiHost
+ "/iteration?"
+ "project="
+ rallyApiHost
+ "/project/"
+ projectId
+ "&fetch=true&order=Name%20desc&start=1&pagesize=100";
String checkProjectRef = rallyApiHost + "/project/" + projectId;
log.info("rallyApiUrl:" + apiUrl);
log.info("checkProjectRef:" + checkProjectRef);
String responseXML = getRallyXML(apiUrl);
SimpleDateFormat ISO8601FORMAT = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'");
Date currentDate = new Date();
org.jdom.input.SAXBuilder bSAX = new org.jdom.input.SAXBuilder();
org.jdom.Document doc = bSAX.build(new StringReader(responseXML));
Element root = doc.getRootElement();
XPath xpath = XPath.newInstance("//Object");
List xlist = xpath.selectNodes(root);
Iterator iter = xlist.iterator();
while (iter.hasNext()) {
Map map = new HashMap();
Element item = (Element) iter.next();
String objId = item.getChildText("ObjectID");
String name = item.getChildText("Name");
String state = item.getChildText("State");
String startDateStr = item.getChildText("StartDate");
String endDateStr = item.getChildText("EndDate");
Date startDate = ISO8601FORMAT.parse(startDateStr);
Date endDate = ISO8601FORMAT.parse(endDateStr);
boolean isCurrent = false;
int startCheck = startDate.compareTo(currentDate);
int endCheck = endDate.compareTo(currentDate);
if (startCheck < 0 && endCheck > 0) {
isCurrent = true;
}
log.info("name=" + name + " isCurrent=" + isCurrent);
String releaseRef = item.getAttribute("ref").getValue();
// In child project, parent object have to be filiered
Element projectElement = item.getChild("Project");
String projectRef = projectElement.getAttributeValue("ref");
if (projectRef.equals(checkProjectRef)) {
map.put("objId", objId);
map.put("rallyRef", releaseRef);
map.put("name", name);
map.put("state", state);
map.put("isCurrent", "" + isCurrent);
list.add(map);
}
}
log.info("-----------");
} catch (Exception ex) {
log.error("ERROR: ", ex);
}
return list;
}
public static String getBarSeries(Map dataSource, String objectName, HttpSession session)
throws Exception {
DefaultKeyedValues barValues = new DefaultKeyedValues();
DefaultKeyedValues seriesValues = new DefaultKeyedValues();
Element chartObject =
XMLHandler.getElementByAttribute(getChartObjectList(), "name", objectName);
Element barField = chartObject.getChild("BarFields").getChild("Field");
Element seriesField = chartObject.getChild("SeriesFields").getChild("Field");
for (int i = 0; i < dataSource.size(); i++) {
Map rec = (Map) dataSource.get("ROW" + i);
barValues.addValue(
DataFilter.show(rec, chartObject.getChildText("ColumnLabel")),
Double.parseDouble(rec.get(barField.getAttributeValue("name")).toString()));
seriesValues.addValue(
DataFilter.show(rec, chartObject.getChildText("ColumnLabel")),
Double.parseDouble(rec.get(seriesField.getAttributeValue("name")).toString()));
}
CategoryDataset dataset =
DatasetUtilities.createCategoryDataset(barField.getAttributeValue("label"), barValues);
PlotOrientation plotOrientation =
chartObject.getAttributeValue("plotOrientation").equalsIgnoreCase("VERTICAL")
? PlotOrientation.VERTICAL
: PlotOrientation.HORIZONTAL;
JFreeChart chart =
ChartFactory.createBarChart3D(
chartObject.getAttributeValue("title"),
chartObject.getAttributeValue("categoryAxisLabel"),
chartObject.getAttributeValue("valueAxisLabel"),
dataset,
plotOrientation,
chartObject.getAttribute("showLegend").getBooleanValue(),
chartObject.getAttribute("showToolTips").getBooleanValue(),
chartObject.getAttribute("urls").getBooleanValue());
CategoryPlot categoryplot = chart.getCategoryPlot();
LineRenderer3D lineRenderer = new LineRenderer3D();
CategoryDataset datasetSeries =
DatasetUtilities.createCategoryDataset(
seriesField.getAttributeValue("label"), seriesValues);
categoryplot.setDataset(1, datasetSeries);
categoryplot.setRangeAxis(1, new NumberAxis3D(seriesField.getAttributeValue("label")));
categoryplot.setRenderer(1, lineRenderer);
categoryplot.mapDatasetToRangeAxis(1, 1);
BarRenderer3D barrenderer = (BarRenderer3D) categoryplot.getRenderer();
barrenderer.setLabelGenerator(new StandardCategoryLabelGenerator());
barrenderer.setItemLabelsVisible(true);
barrenderer.setPositiveItemLabelPosition(
new ItemLabelPosition(ItemLabelAnchor.OUTSIDE1, TextAnchor.BASELINE_CENTER));
// lineRenderer.setLabelGenerator(new StandardCategoryLabelGenerator());
// lineRenderer.setItemLabelsVisible(true);
// lineRenderer.setPositiveItemLabelPosition(
// new ItemLabelPosition(ItemLabelAnchor.OUTSIDE10, TextAnchor.CENTER));
float alpha = 0.7F;
if (chartObject.getAttribute("alpha") != null) {
alpha = chartObject.getAttribute("alpha").getFloatValue();
}
categoryplot.setForegroundAlpha(alpha);
int width, height;
if (chartObject.getAttributeValue("width").equalsIgnoreCase("auto")) {
width = (50 * dataSource.size()) + 100;
} else {
width = Integer.parseInt(chartObject.getAttributeValue("width"));
}
if (chartObject.getAttributeValue("height").equalsIgnoreCase("auto")) {
height = (50 * dataSource.size()) + 100;
} else {
height = Integer.parseInt(chartObject.getAttributeValue("height"));
}
return ServletUtilities.saveChartAsPNG(chart, width, height, session);
}
public static String getSimplePieChart(Map dataSource, String objectName, HttpSession session)
throws Throwable {
DefaultPieDataset dataset = new DefaultPieDataset();
Element chartObject =
XMLHandler.getElementByAttribute(getChartObjectList(), "name", objectName);
String title = chartObject.getAttributeValue("title");
int width = Integer.parseInt(chartObject.getAttributeValue("width"));
int height = Integer.parseInt(chartObject.getAttributeValue("height"));
Element LabelKeys = chartObject.getChild("Labels");
Element ValueKeys = chartObject.getChild("Values");
String valueKey = ValueKeys.getText();
String valueType = ValueKeys.getAttributeValue("type");
List labelKeys = LabelKeys.getChildren("Label");
String labelKey = LabelKeys.getText();
if (valueType.equalsIgnoreCase("number")) {
for (int i = 0; i < dataSource.size(); i++) {
Map rec = (Map) dataSource.get("ROW" + i);
Number value = (Number) rec.get(valueKey);
String label;
if (labelKeys.isEmpty()) {
label = DataFilter.show(rec, labelKey);
} else {
label = ((Element) labelKeys.get(i)).getText();
}
dataset.setValue(label, value);
}
} else {
for (int i = 0; i < dataSource.size(); i++) {
Map rec = (Map) dataSource.get("ROW" + i);
double value = (Double) rec.get(valueKey);
String label;
if (labelKeys.isEmpty()) {
label = DataFilter.show(rec, labelKey);
} else {
label = ((Element) labelKeys.get(i)).getText();
}
dataset.setValue(label, value);
}
}
JFreeChart chart =
ChartFactory.createPieChart3D(
title,
dataset,
chartObject.getAttribute("showLegend").getBooleanValue(),
chartObject.getAttribute("showToolTips").getBooleanValue(),
chartObject.getAttribute("urls").getBooleanValue());
PiePlot3D pie3dplot = (PiePlot3D) chart.getPlot();
float alpha = 0.7F;
if (chartObject.getAttribute("alpha") != null) {
alpha = chartObject.getAttribute("alpha").getFloatValue();
}
pie3dplot.setForegroundAlpha(alpha);
return ServletUtilities.saveChartAsPNG(chart, width, height, null, session);
}
public static String getSimpleBarChart(Map dataSource, String objectName, HttpSession session)
throws Throwable {
Element chartObject =
XMLHandler.getElementByAttribute(getChartObjectList(), "name", objectName);
List invokeFields = chartObject.getChild("InvokeFields").getChildren("Field");
double[][] data = new double[invokeFields.size()][dataSource.size()];
String[] rowKeys = new String[invokeFields.size()];
String[] columnKeys = new String[dataSource.size()];
String columnLabel = chartObject.getChildText("ColumnLabel");
for (int i = 0; i < dataSource.size(); i++) {
Map rec = (Map) dataSource.get("ROW" + i);
columnKeys[i] = DataFilter.show(rec, columnLabel);
for (int j = 0; j < invokeFields.size(); j++) {
data[j][i] =
Double.parseDouble(
rec.get(((Element) invokeFields.get(j)).getAttributeValue("name")).toString());
}
}
for (int i = 0; i < invokeFields.size(); i++) {
rowKeys[i] = ((Element) invokeFields.get(i)).getAttributeValue("label");
}
CategoryDataset dataset = DatasetUtilities.createCategoryDataset(rowKeys, columnKeys, data);
PlotOrientation plotOrientation =
chartObject.getAttributeValue("plotOrientation").equalsIgnoreCase("VERTICAL")
? PlotOrientation.VERTICAL
: PlotOrientation.HORIZONTAL;
JFreeChart chart =
ChartFactory.createBarChart3D(
chartObject.getAttributeValue("title"),
chartObject.getAttributeValue("categoryAxisLabel"),
chartObject.getAttributeValue("valueAxisLabel"),
dataset,
plotOrientation,
chartObject.getAttribute("showLegend").getBooleanValue(),
chartObject.getAttribute("showToolTips").getBooleanValue(),
chartObject.getAttribute("urls").getBooleanValue());
CategoryPlot C3dplot = (CategoryPlot) chart.getPlot();
if (chartObject.getAttribute("alpha") != null) {
C3dplot.setForegroundAlpha(chartObject.getAttribute("alpha").getFloatValue());
}
BarRenderer3D barrenderer = (BarRenderer3D) C3dplot.getRenderer();
barrenderer.setLabelGenerator(new StandardCategoryLabelGenerator());
barrenderer.setItemLabelsVisible(true);
barrenderer.setPositiveItemLabelPosition(
new ItemLabelPosition(ItemLabelAnchor.OUTSIDE1, TextAnchor.BASELINE_CENTER));
int width, height;
if (chartObject.getAttributeValue("width").equalsIgnoreCase("auto")) {
width = (50 * dataSource.size()) * invokeFields.size() + 100;
} else {
width = Integer.parseInt(chartObject.getAttributeValue("width"));
}
if (chartObject.getAttributeValue("height").equalsIgnoreCase("auto")) {
height = (50 * dataSource.size()) * invokeFields.size() + 100;
} else {
height = Integer.parseInt(chartObject.getAttributeValue("height"));
}
return ServletUtilities.saveChartAsPNG(chart, width, height, session);
}
