// --------------------------------------------------------------------------
// ---
// --- Service
// ---
// --------------------------------------------------------------------------
@Override
public Element serviceSpecificExec(Element params, ServiceContext context) throws Exception {
boolean readOnlyMode = super.exec(params, context) == null;
if (readOnlyMode) {
return null;
}
String message = "";
GeonetContext gc = (GeonetContext) context.getHandlerContext(Geonet.CONTEXT_NAME);
// gets the total popularity count (=100)
Dbms dbms = (Dbms) context.getResourceManager().open(Geonet.Res.MAIN_DB);
// wont work if there is no metadata
List l = dbms.select("select sum(popularity) as sumpop from metadata").getChildren();
if (l.size() != 1) {
message = "cannot get popularity count";
return null;
}
int cnt = Integer.parseInt(((Element) l.get(0)).getChildText("sumpop"));
if (Log.isDebugEnabled(Geonet.SEARCH_LOGGER))
Log.debug(Geonet.SEARCH_LOGGER, "query to get popularity by group:\n" + query);
dbms = (Dbms) context.getResourceManager().open(Geonet.Res.MAIN_DB);
DefaultPieDataset dataset = new DefaultPieDataset();
List resultSet = dbms.select(query).getChildren();
for (int i = 0; i < resultSet.size(); i++) {
Element record = (Element) resultSet.get(i);
String popularity = (record).getChildText("popu");
Double d = 0.0;
if (popularity.length() > 0) {
d = (Double.parseDouble(popularity) / cnt) * 100;
}
dataset.setValue(record.getChildText("source"), d);
// System.out.println(record.getChildText("groupname") + ", " + d);
}
// create a chart...
JFreeChart chart =
ChartFactory.createPieChart(
null,
dataset,
true, // legend?
true, // tooltips?
false // URLs?
);
// hard coded values for the moment. should come from a configuration file.
chart.setBackgroundPaint(Color.decode("#E7EDF5"));
String chartFilename = "popubycatalog_" + System.currentTimeMillis() + ".png";
File statFolder =
new File(
gc.getHandlerConfig().getMandatoryValue(Geonet.Config.RESOURCES_DIR)
+ File.separator
+ "images"
+ File.separator
+ "statTmp");
if (!statFolder.exists()) {
statFolder.mkdirs();
}
File f = new File(statFolder, chartFilename);
this.imageMap =
org.fao.geonet.services.statistics.ChartFactory.writeChartImage(
chart,
f,
this.chartWidth,
this.chartHeight,
this.createTooltips,
"graphPopuByCatalogImageMap");
// will return some info to the XSLT:
// dateFrom, dateTo, graphicType, chartUrl, tooltipImageMap,
// message, chartWidth, chartHeight
Element elResp = new Element(Jeeves.Elem.RESPONSE);
Element elchartUrl =
new Element("popuByCatalogUrl")
.setText(context.getBaseUrl() + "/images/statTmp/" + chartFilename);
Element elTooltipImageMap =
new Element("tooltipImageMap").addContent(this.createTooltips ? this.imageMap : "");
Element elMessage = new Element("message").setText(message);
Element elChartWidth = new Element("chartWidth").setText("" + this.chartWidth);
Element elChartHeight = new Element("chartHeight").setText("" + this.chartHeight);
elResp.addContent(elchartUrl);
elResp.addContent(elTooltipImageMap);
elResp.addContent(elMessage);
elResp.addContent(elChartWidth);
elResp.addContent(elChartHeight);
return elResp;
}
