@Override
public void doService() {
logger.debug("IN");
try {
modelDao = DAOFactory.getModelDAO();
modelDao.setUserProfile(getUserProfile());
} catch (EMFUserError e1) {
logger.error(e1.getMessage(), e1);
throw new SpagoBIServiceException(SERVICE_NAME, "Error occurred");
}
Locale locale = getLocale();
String serviceType = this.getAttributeAsString(MESSAGE_DET);
logger.debug("Service type " + serviceType);
if (serviceType != null && serviceType.equalsIgnoreCase(MODELS_LIST)) {
try {
List modelRootsList = modelDao.loadModelsRoot();
logger.debug("Loaded models list");
JSONArray modelsListJSON =
(JSONArray)
SerializerFactory.getSerializer("application/json")
.serialize(modelRootsList, locale);
JSONObject modelsResponseJSON =
createJSONResponseModelsList(modelsListJSON, new Integer(6));
writeBackToClient(new JSONSuccess(modelsResponseJSON));
} catch (Throwable e) {
logger.error("Exception occurred while retrieving model tree", e);
throw new SpagoBIServiceException(
SERVICE_NAME, "Exception occurred while retrieving model tree", e);
}
} else if (serviceType != null && serviceType.equalsIgnoreCase(MODEL_NODES_LIST)) {
try {
String parentId = (String) getAttributeAsString("modelId");
if (parentId == null || parentId.startsWith("xnode")) {
writeBackToClient(new JSONSuccess("'OK'"));
return;
}
Model aModel = modelDao.loadModelWithChildrenById(Integer.parseInt(parentId));
logger.debug("Loaded model tree");
JSONArray modelChildrenJSON =
(JSONArray)
SerializerFactory.getSerializer("application/json")
.serialize(aModel.getChildrenNodes(), locale);
writeBackToClient(new JSONSuccess(modelChildrenJSON));
} catch (Throwable e) {
logger.error("Exception occurred while retrieving model tree", e);
throw new SpagoBIServiceException(
SERVICE_NAME, "Exception occurred while retrieving model tree", e);
}
} else if (serviceType != null && serviceType.equalsIgnoreCase(MODEL_NODES_LIST_WITH_KPI)) {
try {
String parentId = (String) getAttributeAsString("modelId");
if (parentId == null || parentId.startsWith("xnode")) {
writeBackToClient(new JSONSuccess("'OK'"));
return;
}
Model dbModel = modelDao.loadModelWithChildrenById(Integer.parseInt(parentId));
ModelExtended aModel = new ModelExtended(dbModel);
aModel.setExtendedChildrenNodes(dbModel.getChildrenNodes());
logger.debug("Loaded model tree");
JSONArray modelChildrenJSON =
(JSONArray)
SerializerFactory.getSerializer("application/json")
.serialize(aModel.getExtendedChildrenNodes(), locale);
writeBackToClient(new JSONSuccess(modelChildrenJSON));
} catch (Throwable e) {
logger.error("Exception occurred while retrieving model tree", e);
throw new SpagoBIServiceException(
SERVICE_NAME, "Exception occurred while retrieving model tree", e);
}
} else if (serviceType != null && serviceType.equalsIgnoreCase(MODEL_NODES_SAVE)) {
JSONArray nodesToSaveJSON = getAttributeAsJSONArray(NODES_TO_SAVE);
List<Model> modelNodes = null;
if (nodesToSaveJSON != null) {
try {
modelNodes = deserializeNodesJSONArray(nodesToSaveJSON);
// save them
JSONObject response = saveModelNodes(modelNodes);
writeBackToClient(new JSONSuccess(response));
} catch (Exception e) {
logger.error(e.getMessage(), e);
writeErrorsBackToClient();
throw new SpagoBIServiceException(SERVICE_NAME, "Exception saving model nodes", e);
}
}
} else if (serviceType != null && serviceType.equalsIgnoreCase(MODEL_NODE_DELETE)) {
Integer modelId = getAttributeAsInteger("modelId");
logger.warn("DELETING NODE WITH MODEL_ID:" + modelId);
try {
modelDao.deleteModel(modelId);
logger.debug("Model deleted");
writeBackToClient(new JSONSuccess("'Operation succeded'"));
} catch (Throwable e) {
logger.error("Exception occurred while retrieving model to delete", e);
throw new SpagoBIServiceException(
SERVICE_NAME, "Exception occurred while retrieving model to delete", e);
}
} else if (serviceType == null) {
try {
List nodeTypesNodes =
DAOFactory.getDomainDAO().loadListDomainsByType(MODEL_DOMAIN_TYPE_NODE);
List nodeTypesRoot =
DAOFactory.getDomainDAO().loadListDomainsByType(MODEL_DOMAIN_TYPE_ROOT);
List nodeTypes = new ArrayList();
nodeTypes.addAll(nodeTypesNodes);
nodeTypes.addAll(nodeTypesRoot);
getSessionContainer().setAttribute("nodeTypesList", nodeTypes);
List kpiTypesList = DAOFactory.getDomainDAO().loadListDomainsByType(KPI_DOMAIN_TYPE);
getSessionContainer().setAttribute("kpiTypesList", kpiTypesList);
List thrSeverityTypes =
DAOFactory.getDomainDAO().loadListDomainsByType(THRESHOLD_SEVERITY_TYPE);
getSessionContainer().setAttribute("thrSeverityTypes", thrSeverityTypes);
List measureTypesList =
DAOFactory.getDomainDAO().loadListDomainsByType(MEASURE_DOMAIN_TYPE);
getSessionContainer().setAttribute("measureTypesList", measureTypesList);
List metricScaleTypesList =
DAOFactory.getDomainDAO().loadListDomainsByType(METRIC_SCALE_DOMAIN_TYPE);
getSessionContainer().setAttribute("metricScaleTypesList", metricScaleTypesList);
List thrTypesList = DAOFactory.getDomainDAO().loadListDomainsByType(THRESHOLD_DOMAIN_TYPE);
getSessionContainer().setAttribute("thrTypesList", thrTypesList);
// Add Udp Values to sessionContainer
List udpModelList = DAOFactory.getUdpDAO().loadAllByFamily("Model");
getSessionContainer().setAttribute("udpModelList", udpModelList);
List udpKpiList = DAOFactory.getUdpDAO().loadAllByFamily("Kpi");
getSessionContainer().setAttribute("udpKpiList", udpKpiList);
} catch (EMFUserError e) {
logger.error(e.getMessage(), e);
throw new SpagoBIServiceException(SERVICE_NAME, "Exception retrieving model types", e);
}
}
logger.debug("OUT");
}
private JSONObject saveModelNodes(List<Model> nodesToSave) throws JSONException {
JSONArray errorNodes = new JSONArray();
JSONObject respObj = new JSONObject();
// loop over nodes and order them ascending
TreeMap<Integer, Model> treeMap = new TreeMap<Integer, Model>();
for (int i = 0; i < nodesToSave.size(); i++) {
Model model = (Model) nodesToSave.get(i);
// loads all nodes guiid with type error
respObj.put(model.getGuiId(), "OK");
respObj.put("label", model.getLabel());
if (model.getParentId() != null) {
// look up for its id: if null --> newly created node
Integer id = model.getId();
if (id == null) {
treeMap.put(Integer.valueOf("-" + i + 1), model);
} else {
// else to modify node
treeMap.put(model.getId(), model);
}
} else {
// root node --> save first
try {
if (model.getId() != null) {
modelDao.modifyModel(model);
respObj.put(model.getGuiId(), model.getId());
respObj.put(model.getId() + "", model.getLabel());
} else {
Integer index = modelDao.insertModel(model);
respObj.put(model.getGuiId(), index);
respObj.put(index + "", model.getLabel());
}
} catch (Exception e) {
// send error!!!
respObj.put(model.getGuiId(), "KO");
}
}
}
Set set = treeMap.entrySet();
// Get an iterator
Iterator it = set.iterator();
// loop again over treemap
while (it.hasNext()) {
Map.Entry orderedEntry = (Map.Entry) it.next();
// check that parent exists
Model orderedNode = (Model) orderedEntry.getValue();
// GET JSON OBJECT VALUE
Integer parentId = orderedNode.getParentId();
try {
Model parent = modelDao.loadModelWithoutChildrenById(parentId);
if (parent != null) {
// if parent exists--> save
// if node id is negative --> insert
if (orderedNode.getId() == null) {
Integer newId = modelDao.insertModel(orderedNode);
if (newId != null) {
orderedNode.setId(newId);
respObj.put(orderedNode.getGuiId(), newId);
respObj.put(newId + "", orderedNode.getLabel());
} else {
respObj.put(orderedNode.getGuiId(), "KO");
}
} else {
// else update
modelDao.modifyModel(orderedNode);
respObj.put(orderedNode.getGuiId(), orderedNode.getId());
respObj.put(orderedNode.getId() + "", orderedNode.getLabel());
}
}
} catch (Exception e) {
// if parentId != null but no parent node stored on db --> exception
respObj.put(orderedNode.getGuiId(), "KO");
}
}
return respObj;
}