*

* @file WPaloServiceImpl.java

*

* Copyright (C) 2006-2009 Tensegrity Software GmbH

*

* This program is free software; you can redistribute it and/or modify it

* under the terms of the GNU General Public License (Version 2) as published

* by the Free Software Foundation at http://www.gnu.org/copyleft/gpl.html.

*

* This program is distributed in the hope that it will be useful, but WITHOUT

* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or

* FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for

* more details.

*

* You should have received a copy of the GNU General Public License along with

* this program; if not, write to the Free Software Foundation, Inc., 59 Temple

* Place, Suite 330, Boston, MA 02111-1307 USA

*

* If you are developing and distributing open source applications under the

* GPL License, then you are free to use JPalo Modules under the GPL License.  For OEMs,

* ISVs, and VARs who distribute JPalo Modules with their products, and do not license

* and distribute their source code under the GPL, Tensegrity provides a flexible

* OEM Commercial License.

*

* @author Philipp Bouillon <Philipp.Bouillon@tensegrity-software.com>

*

* @version $Id: WPaloServiceImpl.java,v 1.56 2010/04/12 11:13:36 PhilippBouillon Exp $

*

*/

  private static final long serialVersionUID = 389580199199443146L;

  private final WPaloPropertyServiceImpl properties;

  private static transient Logger logger = Logger.getLogger(WPaloServiceImpl.class);

 

  public WPaloServiceImpl() {

    properties = new WPaloPropertyServiceImpl();

  }

  public List<TreeNode> loadChildren(String sessionId, TreeNode node)

      throws SessionExpiredException, PaloGwtCoreException {

    XObject obj = node.getXObject();

    XObject[] result = ChildLoaderManager.getInstance().loadChildren(obj,

        getUserSession(sessionId));

    ArrayList<TreeNode> nodeList = new ArrayList<TreeNode>();

    try {

      for (XObject r : result) {

        nodeList.add(new TreeNode(node, r, true));

      }

    } catch (Throwable t) {

      logger.error(t.getMessage());

      t.printStackTrace();

    }

    return nodeList;

  }

  public List <TreeNode> loadChildren(String sessionId,

      String parentType, String viewId, String axisId, String parentId, String parentPath) throws SessionExpiredException,

      PaloGwtCoreException {

    XObject [] result = ChildLoaderManager.getInstance().loadChildren(

        parentType, viewId, axisId, parentId,

        getUserSession(sessionId));

    ArrayList<TreeNode> nodeList = new ArrayList<TreeNode>();

    try {

      HashMap <String, Integer> reps = new HashMap<String, Integer>();

      int rep;

      for (XObject r: result) {

        String id = ((XElementNode) r).getElement().getId();

        if (reps.containsKey(id)) {

          rep = reps.get(id);

        } else {

          rep = 0;

        }

        nodeList.add(new TreeNode(parentPath, r, rep));

        reps.put(id, rep + 1);

      }

    } catch (Throwable t) {

      logger.error(t.getMessage());

      t.printStackTrace();

    }

    // TODO Remember to set parent of each returned TreeNode!

    return nodeList;   

  }

 

  public List<TreeNode> loadHierarchyTree(String sessionId,

      String hierarchyId, String viewId, String axisId, int level)

      throws SessionExpiredException, PaloGwtCoreException {

    List <TreeNode> result = loadTreeNodesFrom(getUserSession(sessionId), hierarchyId, viewId, axisId, level);

    return result;

  }

  private final List <XElementNode> loadElementsFrom(UserSession userSession,

      XAxisHierarchy xHierarchy, int level) {

    List<XElementNode> nodes = new ArrayList<XElementNode>();

    CubeViewController viewController = getViewController(userSession,

        xHierarchy.getViewId());

    if (viewController != null) {

      nodes.addAll(viewController.loadElements(xHierarchy, level));

    }

    return nodes;

  }

 

  private final String fastCreatePath(TreeNode tNode, XElement xKidElement, HashMap <XElement, Integer> repCounter) {

    StringBuffer buffer = new StringBuffer();       

    buffer.append(xKidElement.getId());

    if (tNode.getParent() != null) {

      Integer rep = repCounter.get(xKidElement);

      if (rep == null) {

        rep = 0;

      }

      if (rep != 0) {

        buffer.append("(");

        buffer.append(rep);

        buffer.append(")");

      }

      buffer.append(":");

      return tNode.getParent().getPath() + buffer.toString();

    } else {

      buffer.append(":");

    }

    return buffer.toString();           

  }

 

  private final void addChildren(int currentDepth, int level, ElementNode [] rootNodes, List <TreeNode> nodes, String hierarchyId, String viewId, HashMap <ElementNode, TreeNode> parents) {

    if (currentDepth >= level && level != -1) {

      return;

    }

    ArrayList <ElementNode> nextLevel = new ArrayList<ElementNode>();

    for (ElementNode root: rootNodes) {     

      TreeNode parent = parents.get(root);

      XElementNode parentX = parent == null ? null : (XElementNode) parent.getXObject();

      HashMap <XElement, Integer> repCounter =

        new HashMap<XElement, Integer>();

      for (ElementNode kid: root.getChildren()) {

        if (kid.getChildCount() != 0) {

          nextLevel.add(kid);

        }

        XElementNode xKid = XElementFactory.createX(kid, hierarchyId, viewId);

        xKid.setParent(parentX);

        xKid.setChildCount(kid.getChildCount());       

        TreeNode n = new TreeNode(parent, xKid, false);

        XElement xKidElement = xKid.getElement();

        n.setPath(fastCreatePath(n, xKidElement, repCounter));       

        if (!repCounter.containsKey(xKidElement)) {

          repCounter.put(xKidElement, 1);

        } else {

          repCounter.put(xKidElement, repCounter.get(xKidElement) + 1);

        }

        if (parent != null) {

          parent.addChild(n);

          ((XElementNode) parent.getXObject()).forceAddChild(xKid);

        }       

        if (kid.getChildCount() != 0) {

          parents.put(kid, n);

        }       

        nodes.add(n);

      }

    }

    if (nextLevel.size() != 0 && ((currentDepth + 1) < level || level == -1)) {

      addChildren(currentDepth + 1, level, nextLevel.toArray(new ElementNode[0]), nodes, hierarchyId, viewId, parents);

    }

  }

 

  private final List <TreeNode> loadTreeNodes(CubeViewController cvc, String hierarchyId, String viewId, String axisId, int level) {

    List<TreeNode> nodes = new ArrayList<TreeNode>();

   

    Axis axis = cvc.getCubeView().getAxis(axisId);

    AxisHierarchy axisHierarchy = axis.getAxisHierarchy(hierarchyId);

    if(axisHierarchy != null) {

      ElementNode [] rootNodes = axisHierarchy.getRootNodes();

      HashMap<ElementNode, TreeNode> parents = new HashMap<ElementNode, TreeNode>();

      for (ElementNode rootElement: rootNodes) {

        XElementNode xRoot = XElementFactory.createX(rootElement, hierarchyId, viewId);       

        xRoot.setChildCount(rootElement.getChildCount());

        TreeNode n = new TreeNode(null, xRoot, true);

        if (xRoot.getChildCount() != 0) {

          parents.put(rootElement, n);

        }       

        nodes.add(n);

        cvc.elementNodes.put(xRoot.getId(), rootElement);

      }

      int currentDepth = 1;

      try {

        addChildren(currentDepth, level, rootNodes, nodes, hierarchyId, viewId, parents);

      } catch (Throwable t) {

        logger.error(t.getMessage());

        t.printStackTrace();

      }

    }

    return nodes;   

  }

 

  private final List <TreeNode> loadTreeNodesFrom(UserSession userSession,

      String hierarchyId, String viewId, String axisId, int level) {   

    CubeViewController viewController = getViewController(userSession,

        viewId);

    if (viewController != null) {

      return loadTreeNodes(viewController, hierarchyId, viewId, axisId, level);

    }

    return new ArrayList<TreeNode>();

  }

 

  private final CubeViewController getViewController(UserSession userSession,

      String view) {

    return CubeViewController.getController(userSession.getSessionId(), view);

  } 

 

  /** loads all accounts assigned to the currently logged in user

   * @throws SessionExpiredException */

  public XAccount[] loadAccounts(String sessionId) throws SessionExpiredException {

    List<Account> accounts = null;

    AuthUser user = getLoggedInUser(sessionId);

    if (isAdmin(user)) {

      AdministrationService adminService = ServiceProvider

          .getAdministrationService(user);

      accounts = adminService.getAccounts(user);

    } else

      accounts = user.getAccounts();

    XAccount[] xAccounts = new XAccount[accounts.size()];

    int index = 0;

    for(Account account : accounts)

      xAccounts[index++] = (XAccount) XConverter.createX(account);

    return xAccounts;

  }

  private final boolean isAdmin(AuthUser user) {

    return user.hasPermission(Right.READ, AdministrationService.class);

  }

  //  private final Account getAccountById(String accountId) {

//    List<Account> accounts = getLoggedInUser().getAccounts();

//    for(Account account : accounts) {

//      if(account.getId().equals(accountId))

//        return account;

//    }

//    return null;

//  }

 

  public List <XElement> loadElements(XDimension xdim) {

    ArrayList <XElement> elementList = new ArrayList<XElement>();

//    Database db = connection.getDatabaseById(xdim.getDbId());

//

//    Dimension dim = db.getDimensionById(xdim.getDimId());

//

//    int nElem = dim.getElementCount();

//   

//    for (int i = 0; i < nElem; i++) {

//      Element elem = dim.getElementAt(i);

//      XElement xelem = new XElement();

//      xelem.setName(elem.getName());     

//      xelem.setElementType(XElementType.fromString(elem.getTypeAsString()));

//      elementList.add(xelem);

//    }

   

    return elementList;

  }

 

  public List<XElement> loadRootElements(XHierarchy hierarchy) {

    ArrayList <XElement> roots = new ArrayList<XElement>();

//    Database db = connection.getDatabaseById(hierarchy.getDimension().getDatabase().getId());

//    Dimension dim = db.getDimensionById(hierarchy.getDimension().getId());

//    Hierarchy hier = dim.getHierarchyById(hierarchy.getId());

//   

//    XUser xUser = hierarchy.getUser();

//    AuthUser user = (AuthUser) XObjectMatcher.getNativeObject(xUser);

//   

//    for(Element root : hier.getRootElements()) {

//      XElement xElement = createXElement(root, hierarchy.getUser(), user);     

//      roots.add(xElement);

//    }

    return roots;

  }

 

//  {

//    ConnectionConfiguration config = ConnectionFactory.getInstance().getConfiguration("localhost",

//        "7777", "admin", "admin");

//    config.setLoadOnDemand(true);

//    return ConnectionFactory.getInstance().newConnection(config);

//  }

//  public XUser login(String login, String password)

//      throws AuthenticationFailedException {   

////    register(new WPaloSessionListener(this));

//    // try to authenticate:

//    try {

//      AuthUser usr = ServiceProvider.getAuthenticationService()

//          .authenticate(login, password);

//      setLoggedInUser(usr);

//      return (XUser)XConverter.createX(usr);

//    } catch (org.palo.viewapi.exceptions.AuthenticationFailedException e) {

//      throw new AuthenticationFailedException(e.getMessage(), e);

//    }

//  }

//

////  public void logout() {

////    AuthUser user = getLoggedInUser();

////    List<Account> accounts = user.getAccounts();

////    for(Account account : accounts) {

////      if(account.isLoggedIn())

////        account.logout();

////    }

////    invalidateSession();

////  }

//  private final void invalidateSession() {

//    HttpSession session = getSession();

//    session.invalidate();

//  }

  public XWorksheet loadWorksheet(XTemplate template) {

//    WSSTemplate temp = null;

////    (WSSTemplate)

////      XObjectMatcher.getNativeObject(template);

//    if (temp == null) {

//      return null;

//    }

//

//    WSSApplication tensegrityApp = temp.getConnection().getSystemApplication();

//    XApplication xapp = new XApplication(template.getUser(), template.getAccount(),

//        tensegrityApp.getId(), false, false);

//    xapp.setName(tensegrityApp.getName());

//    WSSWorkbook wb = tensegrityApp.getTemplateWorkbook(temp);

//    wb.select();

//    WSSWorksheet ws = wb.getDefaultWorksheet();

//    if (ws == null) {

//      // No worksheet present, so create one.

//      ws = wb.addWorksheet("Default");

//    }

//    XWorkbook xwb = new XWorkbook(wb.getId(), wb.getName(),

//        xapp, ws.getName());

//    xwb.setHasChildren(false);

//    XWorksheet xws = new XWorksheet(ws.getId(), ws.getName(), xwb);

//    xws.setHasChildren(false);

//    return xws;

//    } catch (Throwable t) {

//      t.printStackTrace();

//      return null;

//    }

    return null;

  }

////    for (XAccount xAcc: user.getAccounts()) {

////      if (xAcc.getConnection().getHost().equals(

////          wb.getApplication().getConnection().getHost())) {

////        XConnection xCon = xAcc.getConnection();

////        WSSConnection con = wb.getApplication().getConnection();

////        if (xCon.getService().equals(con.getService())) {

////          XApplication app = new XApplication(user, xAcc, wb.getApplication().getId(), true, false);

////          app.setName(wb.getApplication().getName());

////          return app;

////        }

////      }

////    }

//    return null;

//  }

 

  public XWorksheet loadWorksheet(XReport report, XUser user) {

//      return null;

//    }

//    FolderElement el = (FolderElement)

//      XObjectMatcher.getNativeObject(report);    

//    WSSWorkbook wb = (WSSWorkbook) ReportFolderChildLoader.getSourceObjectFromElement(

//        user, el);

//    wb.getApplication().select();

//    wb.select();

//    WSSWorksheet ws = wb.getDefaultWorksheet();

//    if (ws == null) {

//      // No worksheet present, so create one.

//      ws = wb.addWorksheet("Default");

//    }

//    XApplication xApp = findXApplication(wb, user);

//    XWorkbook xwb = new XWorkbook(wb.getId(), wb.getName(), xApp, ws.getName());

//    xwb.setHasChildren(false);

//    XWorksheet xws = new XWorksheet(ws.getId(), ws.getName(), xwb);

//    xws.setHasChildren(false);

//    return xws;

    return null;

  }

 

  public XStaticReportFolder createStaticFolder(String name, XObject parent, XUser usr) {

//    AuthUser user = (AuthUser) XObjectMatcher.getNativeObject(usr);

//    FolderService folderService = ServiceProvider.getFolderService(user);

//    if (o instanceof DynamicFolder) {

//      DynamicFolder df = (DynamicFolder) o;

//      StaticFolder sf;

//      try {

//        sf = folderService.createStaticFolder(name, df, null);

//        XStaticReportFolder xsf = new XStaticReportFolder(

//            sf.getName(), sf.getId(), false, false, usr);

//        XObjectMatcher.put(xsf, sf);

//        XObjectMatcher.put(parent, df);

//        ExplorerTreeNode root = df.getRoot();

//        folderService.save(root);

//        return xsf;

//      } catch (OperationFailedException e1) {

//        e1.printStackTrace();

//      }

//      return null;

//    } else if (o instanceof StaticFolder) {

//      StaticFolder par = (StaticFolder) o;

//      StaticFolder sf;

//      try {

//        sf = folderService.createStaticFolder(name, par, null);

//        XStaticReportFolder xsf = new XStaticReportFolder(

//            sf.getName(), sf.getId(), false, false, usr);

//        XObjectMatcher.put(xsf, sf);

//        XObjectMatcher.put(parent, par);

//        folderService.save(sf.getRoot());

//        return xsf;     

//      } catch (OperationFailedException e) {

//        e.printStackTrace();

//      }

//      return null;

//    }

    return null;

  }

  public XDynamicReportFolder createDynamicFolder(String name, XObject parent, XUser usr) {

//    AuthUser user = (AuthUser) XObjectMatcher.getNativeObject(usr);

//    FolderService folderService = ServiceProvider.getFolderService(user);

//    if (o instanceof DynamicFolder) {

//      DynamicFolder df = (DynamicFolder) o;     

//      DynamicFolder ddf;

//      try {

//        ddf = folderService.createDynamicFolder(name, df, null, null, null);

//        XDynamicReportFolder xdf = new XDynamicReportFolder(ddf.getName(),

//            ddf.getId(), false, false, null, null, usr);

//        XObjectMatcher.put(xdf, ddf);

//        XObjectMatcher.put(parent, df);

//        folderService.save(ddf.getRoot());

//        return xdf;

//      } catch (OperationFailedException e) {

//        e.printStackTrace();

//      }

//      return null;

//    } else if (o instanceof StaticFolder) {

//      StaticFolder par = (StaticFolder) o;

//      DynamicFolder ddf;

//      try {

//        ddf = folderService.createDynamicFolder(name, par, null, null, null);

//        XDynamicReportFolder xdf = new XDynamicReportFolder(ddf.getName(),

//            ddf.getId(), false, false, null, null, usr);

//        XObjectMatcher.put(xdf, ddf);

//        XObjectMatcher.put(parent, par);

//        folderService.save(ddf.getRoot());

//        return xdf;

//      } catch (OperationFailedException e) {

//        e.printStackTrace();

//      }

//      return null;

//    }

    return null;

  }

  public XReport [] addReceivers(XReportFolder parent, XObject [] receivers, XUser usr) {

//      (AbstractExplorerTreeNode) XObjectMatcher.getNativeObject(parent);

//    if (receivers == null || receivers.length == 0) {

//      return new XReport[0];

//    }

//    XReport [] result = new XReport[receivers.length];

//    AuthUser user = (AuthUser) XObjectMatcher.getNativeObject(usr);

//    FolderService folderService = ServiceProvider.getFolderService(user);

//    ExplorerTreeNode root = null;

//    for (int i = 0; i < receivers.length; i++) {

//      XObject receiver = receivers[i];

//      Object o = XObjectMatcher.getNativeObject(receiver);

//      ParameterReceiver pr = null;

//      if (o instanceof WSSTemplate) {

//        WSSTemplate temp = (WSSTemplate) o;

//        WSSApplication tensegrityApp = temp.getConnection().getSystemApplication();

//        tensegrityApp.select();

//        pr = tensegrityApp.loadWorkbook(temp);

//      } else if (o instanceof ParameterReceiver) {

//        pr = (ParameterReceiver) o;           

//      } else {

//        continue;

//      }

//      if (pr == null) {

//        result[i] = null;

//        continue;

//      }

//      String name = "<unknown>";

//      String type = "<unknown>";

//      if (pr instanceof WSSWorkbook) {

//        name = ((WSSWorkbook) pr).getName();

//        type = XConstants.TYPE_FOLDER_ELEMENT_SHEET;

//      } else if (pr instanceof View) {

//        name = ((View) pr).getName();

//        type = XConstants.TYPE_FOLDER_ELEMENT_VIEW;

//      }

//      if (node instanceof DynamicFolder) {

//        DynamicFolder df = (DynamicFolder) node;     

////        FolderElement fe;

////        try {

////          fe = folderService.createFolderElement(name, df, null);

////          fe.setSourceObject(pr);

////          List <XElement> elements = retrieveElements(fe, usr, user);         

////          XReport xr = new XReport(name, fe.getId(), type, elements.toArray(new XElement[0]));

////          XObjectMatcher.put(xr, fe);

////          XObjectMatcher.put(parent, df);

////          result[i] = xr;

////          if (root == null) {

////            root = fe.getRoot();

////          }

////        } catch (OperationFailedException e1) {

////          e1.printStackTrace();

////        }

//      } else if (node instanceof StaticFolder) {

//        StaticFolder sf = (StaticFolder) node;

//        FolderElement fe;

////        try {

////          fe = folderService.createFolderElement(name, sf, null);

////          fe.setSourceObject(pr);

////          List <XElement> elements = retrieveElements(fe, usr, user);

////          XReport xr = new XReport(name, fe.getId(), type,

////              elements.toArray(new XElement[0]));

////          XObjectMatcher.put(xr, fe);

////          XObjectMatcher.put(parent, sf);

////          result[i] = xr;

////          if (root == null) {

////            root = fe.getRoot();

////          }         

////        } catch (OperationFailedException e1) {

////          e1.printStackTrace();

////        }

//      }

//    }

//    if (root != null) {

//      try {

//        FolderModel.getInstance().save(user, root);

//      } catch (PaloIOException e) {

//        e.printStackTrace();

//      }

//    }

//    return result;

    return null;

  }

  private final String getValue(String key, String link) {

    String temp = link.toLowerCase();

    int index = temp.indexOf(key);

    if (index == -1) {

      return null;

    }

    int begin = temp.indexOf("\"", index);

    int end = temp.indexOf("\"", begin + 1);

    if (begin == -1 || end == -1) {

      return null;

    }

    return link.substring(begin + 1, end);

  }

   

  protected void myInitDbConnection(ServletContext globalContext, boolean createDefaultAccounts) {

    // HERE WE CREATE GLOBAL CONNECTIONs AND/OR GLOBAL CONNECTION POOLS

    try {

      DbConnection sqlConnection = (DbConnection) globalContext

          .getAttribute(SQL_CONNECTION);

      DbConnection dbConnection = null;

      if (sqlConnection == null && ServiceProvider.getDbConnection() == null) {

        dbConnection = createConnection();

        ServiceProvider.initialize(dbConnection, createDefaultAccounts);

        globalContext.setAttribute(SQL_CONNECTION, dbConnection);

      } else {

        if (sqlConnection == null) {

          sqlConnection = ServiceProvider.getDbConnection();

          globalContext.setAttribute(SQL_CONNECTION, dbConnection);

        }

        dbConnection = sqlConnection;

      }

    } catch (RuntimeException e) {

      e.printStackTrace();

      logger.error(e.getMessage());

      // TODO introduce an exception here...

      // throw new WPaloException("Couldn't start the application!!", e);

    }

  }

  private final DbConnection createConnection() {

    if (WPaloControllerServiceImpl.USE_MYSQL)

      return MySqlDbConnection.newInstance();

    else

      return HSqlDbConnection.newInstance();

  }

 

  private final View searchView(ExplorerTreeNode node, View view) {

    if (node == null) {

      return null;

    }

    if (node instanceof FolderElement) {

      ParameterReceiver pr = ((FolderElement) node).getSourceObject();

      if (pr != null && pr instanceof View) {

        if (view.getId().equals(((View) pr).getId())) {

          return view;

        }

      }

    }

    for (ExplorerTreeNode kid: node.getChildren()) {

      View v = searchView(kid, view);

      if (v != null) {

        return v;

      }   

    }

    return null;

  }

 

  private final boolean checkFlag(String name, String link) {

    String [] tokens = link.split(",");

    for (String t: tokens) {

      t = t.trim();

      if (t.startsWith("(")) {

        t = t.substring(1).trim();

      }

      if (t.endsWith(")")) {

        t = t.substring(0, t.length() - 1).trim();

      }

      if (t.equals(name)) {

        return true;

      }

    }

    return false;

  }

 

  private final boolean checkFlag(String name, Map <String, String> param) {

    return "1".equals(param.get(name));

  }

  private final List <Boolean> createDisplayFlags(String directLink) {

    String link = directLink.toLowerCase();

    List <Boolean> displayFlags = new ArrayList<Boolean>();                       

    displayFlags.add(checkFlag("hidetitlebar", link));

    displayFlags.add(checkFlag("hidetoolbar", link));

    displayFlags.add(checkFlag("hidesave", link));

    displayFlags.add(checkFlag("hidesaveas", link));

    displayFlags.add(checkFlag("hidefilter", link));

    displayFlags.add(checkFlag("hidestaticfilter", link));

    displayFlags.add(checkFlag("hidehorizontalaxis", link));

    displayFlags.add(checkFlag("hideverticalaxis", link));

    displayFlags.add(checkFlag("hideconnectionpicker", link));

    displayFlags.add(checkFlag("hideconnectionaccount", link));

    displayFlags.add(checkFlag("hideuserrights", link));

//    boolean hideOverview = checkFlag("hidenavigator", link);

//    if (!hideOverview) {

//      hideMulti = false;

//    }

//    displayFlags.add(hideMulti);

//    displayFlags.add(hideOverview);       

    return displayFlags;   

  }

 

  private final List <Boolean> createGlobalDisplayFlags(String directLink) {

    String link = directLink.toLowerCase();

    List <Boolean> displayFlags = new ArrayList<Boolean>();                       

    boolean hideMulti = checkFlag("hideviewtabs", link);

    boolean hideOverview = checkFlag("hidenavigator", link);

    boolean hideconnectionaccount = checkFlag("hideconnectionaccount", link);

    boolean hideuserrights = checkFlag("hideuserrights", link);

    if (!hideOverview) {

      hideMulti = false;

    }

    displayFlags.add(hideMulti);

    displayFlags.add(hideOverview); 

    displayFlags.add(hideconnectionaccount);

    displayFlags.add(hideuserrights); 

    return displayFlags;   

  }

  private final XDirectLinkData parseMultipleViews(String locale, AuthUser authUser, String link, XDirectLinkData data) {

    try {

      ViewService viewService = ServiceProvider.getViewService(authUser);

      int index = -1;

      List <XView> allViews = new ArrayList<XView>();

      while ((index = link.indexOf("[", index + 1)) != -1) {

        int rIndex = link.indexOf("]", index + 1);

        if (rIndex == -1) {

          data.addError(UserSession.trans(locale, "noMatchingClosingBracket"));             

          continue;

        }

        String linkToParse = link.substring(index + 1, rIndex);

        String view = getValue("openview", linkToParse);

        if (view == null) {

          data.addError(UserSession.trans(locale, "noViewIdSpecified"));       

          continue;

        }

        View v = viewService.getView(view);

        if (v == null) {

          data.addError(UserSession.trans(locale, "couldNotFindView", view));             

          continue;

        }

       

        String connectionId = v.getAccount().getConnection().getId();

        Account neededAccount = null;

        for (Account a: authUser.getAccounts()) {

          if (a.getConnection().getId().equals(connectionId)) {

            PaloConnection paloCon = a.getConnection();

            if (paloCon.getType() == PaloConnection.TYPE_WSS) {

              continue;

            } else {

              neededAccount = a;

              break;

            }

          }

        }

       

        if (neededAccount == null) {

          data.addError(UserSession.trans(locale, "noAccountForView", v.getName(), v.getId()));             

          continue;

        }

       

//        if (searchView(fs.getTreeRoot(), v) == null) {

//          data.addError("The view " + v.getName() + " (" + v.getId() + ") cannot be seen by this user.");

//          continue;

//        }

        boolean allowed = false;

        if (v.getOwner() != null) {

          if (authUser.getId().equals(v.getOwner().getId())) {

            allowed = true;

          }

        }

        if (!allowed) {       

          for (Role r: v.getRoles()) {

            for (Role r2: authUser.getRoles()) {

              if (r2.getId().equals(r.getId())) {

                if (r2.hasPermission(Right.READ)) {

                  allowed = true;

                  break;

                }

              }

            }

            for (Group g: authUser.getGroups()) {

              for (Role r2: g.getRoles()) {

                if (r2.getId().equals(r.getId())) {

                  if (r2.hasPermission(Right.READ)) {

                    allowed = true;

                    break;

                  }

                }               

              }

            }           

          }

        }

        if (!allowed) {

          data.addError(UserSession.trans(locale, "viewCannotBeSeen", v.getName(), v.getId()));             

          continue;

        }

       

        ViewConverter conv = new ViewConverter();

        XView xView = (XView) conv.toXObject(v);

        if (xView != null) {         

          xView.setDisplayFlags(createDisplayFlags(linkToParse));

          allViews.add(xView);

        }

      }

      data.setViews(allViews.toArray(new XView[0]));

      return data;

    } catch (Throwable t) {

      logger.error(t.getMessage());

      data.addError(UserSession.trans(locale, "errorWhileOpeningMultipleViews", t.getLocalizedMessage()));

    }

    return data;

  }

 

  private final XDirectLinkData parseSingleView(String locale, AuthUser authUser, String link, XDirectLinkData data) {

    String view = getValue("openview", link);

    if (view == null) {

      return data;

    }

    //SpagoBI informations

    String spagoBIUser = getValue("spagobiusr", link);

    if (spagoBIUser != null) {     

      getSession().setAttribute("spagobiuser", spagoBIUser);

    }

    String spagoBIDoc = getValue("spagobidoc", link);

    if (spagoBIDoc != null) {     

      getSession().setAttribute("spagobidocument", spagoBIDoc);

    }

    String spagoBISub = getValue("spagobisubobj", link);

    if (spagoBISub != null) {     

      getSession().setAttribute("spagobisubobj", spagoBISub);

    }

    try {

      ViewService viewService = ServiceProvider.getViewService(authUser);

      /*SpagoBI modification begin*/

      //View v = viewService.getView(view);

     

      //Account name

      String accountName = getValue("account", link);

      //Connection

      String connection = getValue("connection", link);

      String cubeName = null;

      Cube cube = null;

      String accountId = null;

      if(view.equalsIgnoreCase("")){

        //cube name --> create view dinamically

        cubeName = getValue("cubename", link);

      }

      View v = null;

      for (Account a: authUser.getAccounts()) {

        if(a != null){

          if(view != null && !view.equals("")){           

            //if view specified

            List<View> views = viewService.getViews(a);

            if(!views.isEmpty()){

              Iterator it = views.iterator();

              while(it.hasNext()){

                View selView = (View)it.next();

                if(view != null && !view.equals("")){

                  if(selView.getName().equals(view)){

                    v = selView;

                    break;

                  }

                }

              }

            }

          }else{

            ///tries to get cube

            if(a.getUser().getLoginName().equals(accountName)){

              if(a.getConnection().getName().equals(connection)){

                //use cube name

                accountId = a.getId();

                Connection con = ((PaloAccount) a).login();

                for (Database db: con.getDatabases()) {

                  int connectionType = db.getConnection().getType();

                  Cube c = db.getCubeByName(cubeName);

                  if(c != null){