@Override
public List<List<String>> getSummary(String page, Object object) {
List<List<String>> list = null;
if (page.equals("viewOrganization.jsp")) {
if (!(object instanceof Unit)) {
return null;
}
Unit unit = (Unit) object;
Person currentUser = UserView.getCurrentUser().getExpenditurePerson();
if (!(unit.isResponsible(currentUser)
|| unit.getObserversSet().contains(currentUser)
|| UserView.getCurrentUser().hasRoleType(RoleType.MANAGER))) {
return null;
}
list = new ArrayList<List<String>>();
list.add(new ArrayList<String>());
list.add(new ArrayList<String>());
ReportViewerComponent projectSummary;
Project project = getProjectFromID(unit.getExternalId());
if (project != null) {
String projectCode = project.getProjectCode();
System.out.println(projectCode);
projectSummary =
new ReportViewerComponent(
"SELECT V.\"Orçamento\", V.\"Máximo Financiável\" AS \"Máx. Financiável\", V.\"Receita\", V.\"Transf. Parceiros\", V.\"Despesa\", V.\"Adiantamentos por Justificar\", V.\"Cabimentos por Executar\", V.\"Saldo Tesouraria\", V.\"Saldo Orçamental\" FROM V_RESPROJPROF V WHERE V.\"NºProj\"='"
+ projectCode
+ "'",
new NoBehaviourCustomTableFormatter());
Table t = projectSummary.getTable();
if (t.getItemIds().size() > 0) {
for (Object a : t.getItemIds()) {
Item item = t.getItem(a);
for (Object column : item.getItemPropertyIds()) {
String itemString =
ReportType.formatCurrency(item.getItemProperty(column).toString());
list.get(0).add(t.getColumnHeader(column));
list.get(1).add(itemString);
}
}
}
}
}
return list;
}
private void cachingForTriples(Table table, String endpoint) {
Model model = ModelFactory.createDefaultModel();
List<String> resources = null;
FileWriter fstream = null;
try {
fstream = new FileWriter("/home/mofeed/TrialStart/zicozico.nt");
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
BufferedWriter out = new BufferedWriter(fstream);
try {
for (Object id : table.getItemIds()) {
Item item = table.getItem(id);
Property sourceURI = item.getItemProperty("sourceURI"); // vaadin property not jena
Resource resource = model.createResource();
try {
String sparqlQuery = "select distinct * where { <" + sourceURI.getValue() + "> ?p ?o .}";
Query query = QueryFactory.create(sparqlQuery);
QueryExecution qexec = QueryExecutionFactory.sparqlService(endpoint, query);
com.hp.hpl.jena.query.ResultSet results = qexec.execSelect();
com.hp.hpl.jena.query.QuerySolution binding = null;
while (results.hasNext()) {
binding = results.next();
String property = binding.getResource("?p").toString();
String value;
if (binding.get("?o").isResource()) value = binding.getResource("?o").toString();
else value = binding.getLiteral("?o").toString();
com.hp.hpl.jena.rdf.model.Property pt = ResourceFactory.createProperty(property);
// resource.addProperty(pt, value);
model.add(resource, pt, value);
}
qexec.close();
model.write(out, null, "TURTLE");
} catch (Exception e) {
Notification.show(e.toString());
}
// model.add(s, p, o);
// Property destinationURI = item.getItemProperty("destinationURI");
// out.write(sourceURI.getValue()+"\n");
}
/*out.flush();
fstream.flush();*/
out.close();
} catch (Exception e) { // Catch exception if any
System.err.println("Error: " + e.getMessage());
}
}
private void setTablePageLengths() {
myTranscoderTable.setPageLength(Math.min(myTranscoderTable.getItemIds().size(), 10));
}