예제 #1
0
 /**
  * Deletes the email account with the given id.
  *
  * @param accountID acoount id
  * @throws com.funambol.email.exception.EntityException
  * @return number of deleted rows
  */
 public int deleteAccount(long accountID) throws EntityException {
   int numDeleted = 0;
   try {
     long[] principalIds = cdao.getPrincipals(accountID);
     numDeleted = cdao.deleteUser(accountID, principalIds);
   } catch (DBAccessException e) {
     throw new EntityException("Error deleting account with id " + accountID, e);
   }
   return numDeleted;
 }
예제 #2
0
 /**
  * the UI cannot delete the entry. it will be marked as deleted. the push listener framework will
  * remove the entry.
  *
  * @param accountID String
  * @return int
  * @throws EntityException
  */
 public int markUserAsDelete(long accountID) throws EntityException {
   int result = 0;
   try {
     MailServerAccount msa = cdao.getUserFromID(accountID);
     if (msa == null) {
       return 0;
     }
     msa.setStatus(RegistryEntryStatus.DELETED);
     msa.setLastUpdate(System.currentTimeMillis());
     result = cdao.markUserAsDelete(msa);
   } catch (DBAccessException ee) {
     throw new EntityException("Error marking account as delete.", ee);
   }
   return result;
 }
예제 #3
0
 /**
  * get public mail server
  *
  * @param mailServerId String
  * @return all the info about the public mail server MailServer
  * @throws EntityException
  */
 public MailServer getPubMailServer(String mailServerId) throws EntityException {
   MailServer pms = null;
   try {
     pms = cdao.getPubMailServer(mailServerId);
   } catch (DBAccessException ee) {
     throw new EntityException("Error getting Mail Server ", ee);
   }
   return pms;
 }
예제 #4
0
 /**
  * get public mail servers
  *
  * @return list with all the mail server in the filter ArrayList
  * @throws EntityException
  */
 public MailServer[] getPubMailServers(Clause clause) throws EntityException {
   MailServer[] msl = null;
   try {
     msl = cdao.getPubMailServers(clause);
   } catch (DBAccessException ee) {
     throw new EntityException("Error getting Mail Server List", ee);
   }
   return msl;
 }
예제 #5
0
 /**
  * get user
  *
  * @param accountID String
  * @return all the info about the user and the related mail server MailServerAccount
  * @throws EntityException
  */
 public MailServerAccount getUserFromID(long accountID) throws EntityException {
   MailServerAccount msa = null;
   try {
     msa = cdao.getUserFromID(accountID);
   } catch (DBAccessException ee) {
     throw new EntityException("Error getting Account ", ee);
   }
   return msa;
 }
예제 #6
0
 /**
  * get user
  *
  * @param username String
  * @return all the info about the user and the related mail server MailServerAccount
  * @throws EntityException
  */
 public MailServerAccount getUser(String username) throws EntityException {
   MailServerAccount msa = null;
   try {
     msa = cdao.getUser(username);
   } catch (DBAccessException ee) {
     throw new EntityException("Error getting Account ", ee);
   }
   return msa;
 }
예제 #7
0
 /**
  * enable account
  *
  * @param accountID String
  * @return int
  * @throws EntityException
  */
 public int enableUser(long accountID) throws EntityException {
   int result = 0;
   try {
     result = cdao.enableUser(accountID);
   } catch (DBAccessException ee) {
     throw new EntityException("Error enabling account", ee);
   }
   return result;
 }
예제 #8
0
 /**
  * get the cached info for the specified username
  *
  * @param username String
  * @param protocol String
  * @return array qith all the info
  * @throws EntityException
  */
 public SyncItemInfoAdmin[] getCachedInfo(String username, String protocol)
     throws EntityException {
   SyncItemInfoAdmin[] infos = null;
   try {
     infos = cdao.getCachedInfo(username, protocol);
   } catch (DBAccessException ee) {
     throw new EntityException("Error getting Cache Info for Administration", ee);
   }
   return infos;
 }
예제 #9
0
  /**
   * get users in the filter
   *
   * @param clause Clause
   * @return list with all the user in the filter ArrayList
   * @throws EntityException
   */
  public MailServerAccount[] getUsers(Clause clause) throws EntityException {

    MailServerAccount[] msal = null;
    try {
      msal = cdao.getUsers(clause);
    } catch (DBAccessException ee) {
      throw new EntityException("Error getting Account List", ee);
    }
    return msal;
  }
예제 #10
0
  /**
   * Retrieves the number of the unread emails.
   *
   * @param username is the username
   * @return the number of unread emails.
   * @throws com.funambol.email.exception.EntityException if any error occurs.
   */
  public int getNumUnreadEmail(String username) throws EntityException {
    int numberUnreadEmails = 0;

    try {
      numberUnreadEmails = cdao.getNumUnreadEmail(username);
    } catch (DBAccessException e) {
      throw new EntityException("Error getting the number of unread emails.", e);
    }
    return numberUnreadEmails;
  }
예제 #11
0
  /**
   * Returns all the folders names for the given IMAP account.
   *
   * @param msa mail server account
   * @return list of the folders names for this account
   */
  public List getImapFolders(MailServerAccount msa) throws EntityException, InboxListenerException {

    List folders = null;
    try {
      folders = cdao.getImapFolderList(msa);
    } catch (Exception e) {
      throw new EntityException("Error getting IMAP folders", e);
    }
    return folders;
  }
예제 #12
0
  /**
   * Retrieves the number of the unread emails for the given account.
   *
   * @param account is the account associated to the user we are interested in.
   * @return the number of unread emails.
   * @throws com.funambol.email.exception.EntityException if any error occurs.
   */
  public int getNumUnreadEmail(MailServerAccount account) throws EntityException {
    int numberUnreadEmails = 0;

    try {
      numberUnreadEmails = cdao.getNumUnreadEmail(account);
    } catch (DBAccessException e) {
      throw new EntityException("Error getting the number of unread emails.", e);
    }
    return numberUnreadEmails;
  }
예제 #13
0
  /**
   * Retrieves date/time of the last received email.
   *
   * @param username the username
   * @return the date/time of the last received email
   * @throws EntityException if an error occurs
   */
  public long getTimeOfLastReceivedEmail(String username) throws EntityException {

    long lastReceivedEmailTime = 0;

    try {
      lastReceivedEmailTime = cdao.getTimeOfLastReceivedEmail(username);
    } catch (DBAccessException e) {
      throw new EntityException("Error getting date/time of the last received email.", e);
    }
    return lastReceivedEmailTime;
  }
예제 #14
0
 private boolean noUsers(String mailServerId) throws EntityException {
   boolean check = false;
   int userNum = 0;
   try {
     userNum = cdao.checkUsersForMailServer(mailServerId);
     if (userNum == 0) {
       check = true;
     }
   } catch (DBAccessException ee) {
     throw new EntityException("Error checking Users for the Mail Server ", ee);
   }
   return check;
 }
예제 #15
0
 /**
  * delete mail server
  *
  * @param mailServerId String
  * @return int
  * @throws EntityException
  */
 public int deletePubMailServer(String mailServerId) throws EntityException {
   int result = 0;
   try {
     if (noUsers(mailServerId)) {
       result = cdao.deletePubMailServer(mailServerId);
     } else {
       // There are some Users related to this Mail Server
       result = Def.ERR_SERVER_DELETION;
     }
   } catch (DBAccessException ee) {
     throw new EntityException("Error deleting MailServer ", ee);
   }
   return result;
 }
예제 #16
0
  /**
   * update user regarding the mail server connection
   *
   * @param msa MailServerAccount
   * @return int
   * @throws EntityException
   */
  public int updateUser(MailServerAccount msa) throws EntityException {

    int result = 0;
    boolean needCacheRefresh = false;

    try {

      if (msa.getMailServer().getMailServerId() == null
          || msa.getMailServer().getMailServerId().equals("")) {

        // this case happens when there is a swith from public
        // to custom in the UI so the cache refresh is required
        needCacheRefresh = true;
        msa.getMailServer().setMailServerId("" + this.idMailServerSpace.next());

      } else {

        //  check if a refresh is required
        needCacheRefresh = needCacheRefreshing(msa);

        //
        // update custom or update public
        // - if custom:
        // leave the input values that the UI sends
        // - if public;
        // get info from DB, replace the input from UI
        // except the folder names settings
        //
        if (msa.getMailServer().getIsPublic()) {

          String msId = msa.getMailServer().getMailServerId();
          MailServer msFromDB = cdao.getPubMailServer(msId);
          msa.getMailServer().setMailServerId(msId);
          msa.getMailServer().setMailServerType(msFromDB.getMailServerType());
          msa.getMailServer().setDescription(msFromDB.getDescription());
          msa.getMailServer().setIsSoftDelete(msFromDB.getIsSoftDelete());
          msa.getMailServer().setIsPublic(msFromDB.getIsPublic());
          msa.getMailServer().setProtocol(msFromDB.getProtocol());
          msa.getMailServer().setOutServer(msFromDB.getOutServer());
          msa.getMailServer().setOutPort(msFromDB.getOutPort());
          msa.getMailServer().setOutAuth(msFromDB.getOutAuth());
          msa.getMailServer().setInServer(msFromDB.getInServer());
          msa.getMailServer().setInPort(msFromDB.getInPort());
          msa.getMailServer().setIsSSLIn(msFromDB.getIsSSLIn());
          msa.getMailServer().setIsSSLOut(msFromDB.getIsSSLOut());
        }
      }

      // set the period (push listener framework)
      msa.setPeriod(Utility.setMillis(msa.getPeriod()));

      // check serverType
      checkMailServerInfo(msa);

      // check folder names
      checkFoldersName(msa);

      msa.setTaskBeanFile(Def.DEFAULT_INBOX_LISTENER_BEAN_FILE);
      msa.setStatus(RegistryEntryStatus.UPDATED);
      msa.setLastUpdate(System.currentTimeMillis());

      // update user
      result = cdao.updateUser(msa);

      // refresh cache if it's required
      if (needCacheRefresh) {
        cdao.clearCache(msa.getUsername());
        // get the principal
        long[] principals = cdao.getPrincipals(msa.getUsername());
        for (long principalID : principals) {
          cdao.clearFolder(msa.getUsername(), principalID);
        }
      }

    } catch (DBIDGeneratorException ee) {
      throw new EntityException("Error handling ID ", ee);
    } catch (EntityException ee) {
      throw new EntityException("Error updating Account", ee);
    } catch (Exception ee) {
      throw new EntityException("Error checking the folders name of the Account", ee);
    }

    return result;
  }
예제 #17
0
  /**
   * update public mail server
   *
   * @param ms PublicMailServer
   * @return int
   * @throws EntityException
   */
  public int updatePubMailServer(MailServer ms) throws EntityException {

    int result = 0;

    try {

      if (ms.getMailServerId() == null || ms.getMailServerId().equals("")) {

        throw new EntityException("Error: Mail Server ID is null in an update operation");

      } else {

        // check serverType
        if (ms.getMailServerType() == null
            || ms.getMailServerType().equals("")
            || ms.getMailServerType().equals("null")) {
          ms.setMailServerType(Def.SERVER_TYPE_OTHER);
        }

        // check description
        if (ms.getDescription() == null
            || ms.getDescription().equals("")
            || ms.getDescription().equals("null")) {
          ms.setDescription(Def.SERVER_TYPE_OTHER);
        }

        // check folder names
        if (ms.getOutboxPath() == null
            || ms.getOutboxPath().equals("")
            || ms.getOutboxPath().equals("null")) {
          ms.setOutboxPath(Def.FOLDER_OUTBOX_ENG);
          ms.setOutboxActivation(true);
        }
        if (ms.getSentPath() == null
            || ms.getSentPath().equals("")
            || ms.getSentPath().equals("null")) {
          if (ms.getMailServerType().equals(Def.SERVER_TYPE_EXCHANGE)) {
            ms.setSentPath(Def.FOLDER_SENT_ENG_EXC);
          } else {
            ms.setSentPath(Def.FOLDER_SENT_ENG);
          }
        }

        if (ms.getDraftsPath() == null
            || ms.getDraftsPath().equals("")
            || ms.getDraftsPath().equals("null")) {
          ms.setDraftsPath(Def.FOLDER_DRAFTS_ENG);
        }

        if (ms.getTrashPath() == null
            || ms.getTrashPath().equals("")
            || ms.getTrashPath().equals("null")) {
          if (ms.getMailServerType().equals(Def.SERVER_TYPE_EXCHANGE)) {
            ms.setTrashPath(Def.FOLDER_TRASH_ENG_EXC);
          } else {
            ms.setTrashPath(Def.FOLDER_TRASH_ENG);
          }
        }
      }

      result = cdao.updatePubMailServer(ms);

    } catch (DBAccessException ee) {
      throw new EntityException("Error updating Mail Server ", ee);
    }
    return result;
  }
예제 #18
0
  /**
   * insert public mail server configuration
   *
   * @param ms PublicMailServer
   * @return int
   * @throws EntityException
   */
  public int insertPubMailServer(MailServer ms) throws EntityException {

    int result = 0;

    try {

      ms.setMailServerId("" + this.idMailServerSpace.next());

      // check serverType
      if (ms.getMailServerType() == null
          || ms.getMailServerType().equals("")
          || ms.getMailServerType().equals("null")) {
        ms.setMailServerType(Def.SERVER_TYPE_OTHER);
      }

      // check description
      if (ms.getDescription() == null
          || ms.getDescription().equals("")
          || ms.getDescription().equals("null")) {
        ms.setDescription(Def.SERVER_TYPE_OTHER);
      }

      // check folder names
      if (ms.getOutboxPath() == null
          || ms.getOutboxPath().equals("")
          || ms.getOutboxPath().equals("null")) {
        ms.setOutboxPath(Def.FOLDER_OUTBOX_ENG);
        ms.setOutboxActivation(true);
      }

      if (ms.getSentPath() == null
          || ms.getSentPath().equals("")
          || ms.getSentPath().equals("null")) {
        if (ms.getMailServerType().equals(Def.SERVER_TYPE_EXCHANGE)) {
          ms.setSentPath(Def.FOLDER_SENT_ENG_EXC);
        } else {
          ms.setSentPath(Def.FOLDER_SENT_ENG);
        }
      }

      if (ms.getDraftsPath() == null
          || ms.getDraftsPath().equals("")
          || ms.getDraftsPath().equals("null")) {
        ms.setDraftsPath(Def.FOLDER_DRAFTS_ENG);
      }

      if (ms.getTrashPath() == null
          || ms.getTrashPath().equals("")
          || ms.getTrashPath().equals("null")) {
        if (ms.getMailServerType().equals(Def.SERVER_TYPE_EXCHANGE)) {
          ms.setTrashPath(Def.FOLDER_TRASH_ENG_EXC);
        } else {
          ms.setTrashPath(Def.FOLDER_TRASH_ENG);
        }
      }

      result = cdao.insertPubMailServer(ms);

    } catch (DBIDGeneratorException ee) {
      throw new EntityException("Error handling ID ", ee);
    } catch (DBAccessException ee) {
      throw new EntityException("Error inserting Mail Server ", ee);
    }
    return result;
  }
예제 #19
0
  /**
   * check if the fnbl_email_inbox must be refreshed for the given user
   *
   * @param currMsa
   * @throws com.funambol.email.exception.EntityException
   * @return true if the table must be refreshed
   */
  private boolean needCacheRefreshing(MailServerAccount currMsa) throws EntityException {

    boolean check = false;

    MailServerAccount prevMsa = null;
    String prevMailServerID = null;
    String prevProtocol = null;
    String currMailServerID = null;
    String currProtocol = null;
    try {

      // get all info from DB
      prevMsa = cdao.getUserFromID(currMsa.getId());

      prevMailServerID = prevMsa.getMailServer().getMailServerId();
      prevProtocol = prevMsa.getMailServer().getProtocol();

      currMailServerID = currMsa.getMailServer().getMailServerId();
      currProtocol = currMsa.getMailServer().getProtocol();

      if (currMailServerID != null && prevMailServerID != null) {
        if (!currMailServerID.equals(prevMailServerID)) {
          check = true;
        }
      }

      // same mail server but differt protocol
      if (currProtocol != null && prevProtocol != null) {
        if (!currProtocol.equals(prevProtocol)) {
          check = true;
        }
      }

      // different login or mail address
      String currMsLogin = currMsa.getMsLogin();
      String prevMsLogin = prevMsa.getMsLogin();

      if (currMsLogin != null && prevMsLogin != null) {
        if (!currMsLogin.equals(prevMsLogin)) {
          check = true;
        }
      }

      String currMsAddress = currMsa.getMsAddress();
      String prevMsAddress = prevMsa.getMsAddress();

      if (currMsAddress != null && prevMsAddress != null) {
        if (!currMsAddress.equals(prevMsAddress)) {
          check = true;
        }
      }

    } catch (DBAccessException ee) {
      throw new EntityException(
          "Error checking if the cache for the "
              + "account "
              + currMsa.getId()
              + " must be freshed",
          ee);
    }
    return check;
  }
예제 #20
0
  /**
   * insert user and the mail server configuration
   *
   * @param msa MailServerAccount
   * @return int
   * @throws EntityException
   */
  public int insertUser(MailServerAccount msa) throws EntityException {
    int result = 0;
    try {

      if (msa.getMailServer().getMailServerId() == null
          || msa.getMailServer().getMailServerId().equals("")) {

        msa.getMailServer().setMailServerId("" + this.idMailServerSpace.next());

      } else {

        String msId = msa.getMailServer().getMailServerId();

        if (msa.getMailServer().getIsPublic()) {

          MailServer msFromDB = cdao.getPubMailServer(msId);

          MailServer ms = msa.getMailServer();

          // replace the imput info with the db info
          msa.getMailServer().setMailServerId(msId);
          msa.getMailServer().setMailServerType(msFromDB.getMailServerType());
          msa.getMailServer().setDescription(msFromDB.getDescription());
          msa.getMailServer().setIsSoftDelete(msFromDB.getIsSoftDelete());
          msa.getMailServer().setIsPublic(msFromDB.getIsPublic());
          msa.getMailServer().setProtocol(msFromDB.getProtocol());
          msa.getMailServer().setOutServer(msFromDB.getOutServer());
          msa.getMailServer().setOutPort(msFromDB.getOutPort());
          msa.getMailServer().setOutAuth(msFromDB.getOutAuth());
          msa.getMailServer().setInServer(msFromDB.getInServer());
          msa.getMailServer().setInPort(msFromDB.getInPort());
          msa.getMailServer().setIsSSLIn(msFromDB.getIsSSLIn());
          msa.getMailServer().setIsSSLOut(msFromDB.getIsSSLOut());

          msa.getMailServer()
              .setInboxPath(getValueOrDefault(ms.getInboxPath(), msFromDB.getInboxPath()));

          msa.getMailServer().setInboxActivation(msFromDB.getInboxActivation());

          msa.getMailServer()
              .setOutboxPath(getValueOrDefault(ms.getOutboxPath(), msFromDB.getOutboxPath()));

          msa.getMailServer().setOutboxActivation(msFromDB.getOutboxActivation());

          msa.getMailServer()
              .setSentPath(getValueOrDefault(ms.getSentPath(), msFromDB.getSentPath()));

          msa.getMailServer().setSentActivation(msFromDB.getSentActivation());

          msa.getMailServer()
              .setDraftsPath(getValueOrDefault(ms.getDraftsPath(), msFromDB.getDraftsPath()));

          msa.getMailServer().setDraftsActivation(msFromDB.getDraftsActivation());

          msa.getMailServer()
              .setTrashPath(getValueOrDefault(ms.getTrashPath(), msFromDB.getTrashPath()));

          msa.getMailServer().setTrashActivation(msFromDB.getTrashActivation());
        }
      }

      // from UI we get the minutes but in the DB we save the seconds
      msa.setPeriod(Utility.setMillis(msa.getPeriod()));

      // check serverType
      checkMailServerInfo(msa);

      // check folder names
      checkFoldersName(msa);

      // set the push listener framework properties
      msa.setTaskBeanFile(Def.DEFAULT_INBOX_LISTENER_BEAN_FILE);
      msa.setStatus(RegistryEntryStatus.NEW);
      msa.setLastUpdate(System.currentTimeMillis());

      // insert the account
      result = cdao.insertUser(msa);

    } catch (DBIDGeneratorException ee) {
      throw new EntityException("Error handling ID ", ee);
    } catch (EntityException ee) {
      throw new EntityException("Error addind Account", ee);
    } catch (Exception ee) {
      throw new EntityException("Error checking input values of the Account", ee);
    }

    return result;
  }