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;
}
@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 List<Model> deserializeNodesJSONArray(JSONArray rows) throws JSONException {
List<Model> toReturn = new ArrayList<Model>();
HashMap<String, Model> labels = new HashMap<String, Model>();
for (int i = 0; i < rows.length(); i++) {
JSONObject obj = (JSONObject) rows.get(i);
Model model = new Model();
// always present guiId
String guiId = obj.getString("id");
model.setGuiId(guiId);
try {
model.setId(obj.getInt("modelId"));
} catch (Throwable t) {
// nothing
model.setId(null);
}
try {
model.setParentId(obj.getInt("parentId"));
} catch (Throwable t) {
// nothing
model.setParentId(null);
}
try {
model.setCode(obj.getString("code"));
try {
model.setDescription(obj.getString("description"));
} catch (Throwable t) {
// nothing
model.setDescription(null);
}
String labelKey;
try {
labelKey = obj.getString("label");
} catch (Throwable t) {
labelKey = java.util.UUID.randomUUID().toString();
}
model.setLabel(labelKey);
if (!labels.containsKey(labelKey)) {
labels.put(labelKey, model);
} else {
// skip it
continue;
}
model.setName(obj.getString("name"));
model.setTypeCd(obj.getString("type"));
model.setTypeId(obj.getInt("typeId"));
try {
model.setTypeDescription(obj.getString("typeDescr"));
} catch (Throwable t) {
// nothing
model.setTypeDescription(null);
}
try {
model.setKpiId(obj.getInt("kpiId"));
} catch (Throwable t) {
// nothing
model.setKpiId(null);
}
// add the udpValues to Model Instance Definition, that will be serialized
List<UdpValue> udpValues = new ArrayList<UdpValue>();
JSONArray jsonArray = null;
try {
jsonArray = obj.getJSONArray("udpValues");
} catch (Throwable t) {
jsonArray = new JSONArray();
}
logger.debug("found udpValues Array containing number of Udp " + jsonArray.length());
for (int j = 0; j < jsonArray.length(); j++) {
JSONObject objJS = (JSONObject) jsonArray.get(j);
// only label and value information are retrieved by JSON object
String labelJ = objJS.getString("name");
String value = objJS.getString("value");
UdpValue udpValue = new UdpValue();
// reference id is the kpi id
udpValue.setLabel(obj.getString("label"));
udpValue.setValue(value);
udpValue.setReferenceId(model.getId());
// get the UDP to get ID (otherwise could be taken in js page)
Udp udp = DAOFactory.getUdpDAO().loadByLabelAndFamily(labelJ, "MODEL");
Domain familyDomain = DAOFactory.getDomainDAO().loadDomainById(udp.getFamilyId());
logger.debug(
"Udp value assigning value "
+ value
+ " to UDP with label "
+ udp.getLabel()
+ " and Model Instance with label "
+ model.getLabel());
udpValue.setLabel(udp.getLabel());
udpValue.setName(udp.getName());
udpValue.setFamily(familyDomain != null ? familyDomain.getValueCd() : null);
udpValue.setUdpId(udp.getUdpId());
udpValues.add(udpValue);
}
model.setUdpValues(udpValues);
String value = obj.getString("toSave");
} catch (Throwable t) {
logger.debug("Deserialization error on node: " + guiId);
}
toReturn.add(model);
}
return toReturn;
}