Examples with Address javax.mail.Address used on opensource projects

Example 86 with Address

use of javax.mail.Address in project adempiere by adempiere.

the class RequestEMailProcessor method createRequest.

//	processInBox
/**
	 * 	Create request
	 *	@param msg message
	 * @return 
	 *	@return Type of Message
	 * @throws MessagingException 
	 */
private boolean createRequest(Message msg) throws MessagingException, SQLException {
    // Assign from variable
    Address[] from = msg.getFrom();
    String fromAddress;
    // Carlos Ruiz <c_ruiz@myrealbox.com>
    if (from[0].toString().indexOf('<') != -1 && from[0].toString().indexOf('>') != -1) {
        fromAddress = from[0].toString().substring(from[0].toString().indexOf('<') + 1, from[0].toString().indexOf('>'));
        log.info("fromAddress stripped: " + fromAddress);
    } else {
        fromAddress = from[0].toString();
    }
    // Message-ID as documentNo
    String[] hdrs = msg.getHeader("Message-ID");
    // Review if the e-mail was already created, comparing Message-ID+From+body
    int retValuedup = 0;
    String sqldup = "select r_request_id from r_request " + "where ad_client_id = ? " + "and documentno = ? " + "and startdate = ?";
    PreparedStatement pstmtdup = null;
    pstmtdup = DB.prepareStatement(sqldup, null);
    pstmtdup.setInt(1, getAD_Client_ID());
    pstmtdup.setString(2, hdrs[0].substring(0, 30));
    pstmtdup.setTimestamp(3, new Timestamp(msg.getSentDate().getTime()));
    ResultSet rsdup = pstmtdup.executeQuery();
    if (rsdup.next())
        retValuedup = rsdup.getInt(1);
    rsdup.close();
    pstmtdup.close();
    pstmtdup = null;
    if (retValuedup > 0) {
        log.info("request already existed for msg -> " + hdrs[0]);
        return true;
    }
    // Analyze subject if Re: find the original request by subject + e-mail and add an action
    int request_upd = 0;
    String sqlupd = "SELECT r_request_id " + "  FROM r_request " + " WHERE ad_client_id = ? " + "   AND summary LIKE 'FROM: ' || ? || '%' " + "   AND (   documentno = " + "              SUBSTR " + "                 (?, " + "                  INSTR " + "                      (?, " + "                       '<' " + "                      ) " + "                 ) " + "        OR (    ? LIKE 'Re: %' " + "            AND summary = " + "                      'FROM: ' " + "                   || ? " + "                   || CHR (10) " + "                   || SUBSTR (?, 5) " + "           ) " + "       ) ";
    PreparedStatement pstmtupd = null;
    pstmtupd = DB.prepareStatement(sqlupd, null);
    pstmtupd.setInt(1, getAD_Client_ID());
    pstmtupd.setString(2, fromAddress);
    pstmtupd.setString(3, msg.getSubject());
    pstmtupd.setString(4, msg.getSubject());
    pstmtupd.setString(5, msg.getSubject());
    pstmtupd.setString(6, fromAddress);
    pstmtupd.setString(7, msg.getSubject());
    ResultSet rsupd = pstmtupd.executeQuery();
    if (rsupd.next())
        request_upd = rsupd.getInt(1);
    rsupd.close();
    pstmtupd.close();
    pstmtupd = null;
    if (request_upd > 0) {
        log.info("msg -> " + hdrs[0] + " is an answer for req " + request_upd);
        return updateRequest(request_upd, msg);
    }
    MRequest req = new MRequest(getCtx(), 0, get_TrxName());
    // Subject as summary
    req.setSummary("FROM: " + fromAddress + "\n" + msg.getSubject());
    // Body as result
    req.setResult("FROM: " + from[0].toString() + "\n" + getMessage(msg));
    // Message-ID as documentNo
    if (hdrs != null)
        req.setDocumentNo(hdrs[0].substring(0, 30));
    // Default request type for this process
    if (R_RequestType_ID > 0)
        req.setR_RequestType_ID(R_RequestType_ID);
    else
        req.setR_RequestType_ID();
    // set Default sales representative 
    if (SalesRep_ID > 0)
        req.setSalesRep_ID(SalesRep_ID);
    // set Default role
    if (AD_Role_ID > 0)
        req.setAD_Role_ID(AD_Role_ID);
    // Look for user via e-mail
    if (from != null) {
        int retValueu = -1;
        String sqlu = "SELECT ad_user_id " + "  FROM ad_user " + " WHERE UPPER (email) = UPPER (?) " + "   AND ad_client_id = ?";
        PreparedStatement pstmtu = null;
        pstmtu = DB.prepareStatement(sqlu, null);
        pstmtu.setString(1, fromAddress);
        pstmtu.setInt(2, getAD_Client_ID());
        ResultSet rsu = pstmtu.executeQuery();
        if (rsu.next())
            retValueu = rsu.getInt(1);
        rsu.close();
        pstmtu.close();
        pstmtu = null;
        if (retValueu > 0) {
            req.setAD_User_ID(retValueu);
        } else {
            // set default user
            if (AD_User_ID > 0)
                req.setAD_User_ID(AD_User_ID);
        }
    }
    // Look BP
    if (req.getAD_User_ID() > 0) {
        MUser us = new MUser(getCtx(), req.getAD_User_ID(), get_TrxName());
        if (us.getC_BPartner_ID() > 0)
            req.setC_BPartner_ID(us.getC_BPartner_ID());
    }
    if (req.getC_BPartner_ID() <= 0 && C_BPartner_ID > 0) {
        // set default business partner
        req.setC_BPartner_ID(C_BPartner_ID);
    }
    // Set start date as sent date of e-mail
    req.setStartDate(new Timestamp(msg.getSentDate().getTime()));
    // defaults priority Medium, confidentiality partner
    if (p_DefaultConfidentiality != null) {
        req.setConfidentialType(p_DefaultConfidentiality);
        req.setConfidentialTypeEntry(p_DefaultConfidentiality);
    }
    if (p_DefaultPriority != null) {
        req.setPriority(p_DefaultPriority);
        req.setPriorityUser(p_DefaultPriority);
    }
    if (req.save(get_TrxName())) {
        log.info("created request " + req.getR_Request_ID() + " from msg -> " + hdrs[0]);
        // get simple attachments and attach to request
        if (msg.isMimeType("multipart/*")) {
            try {
                Multipart mp = (Multipart) msg.getContent();
                for (int i = 0, n = mp.getCount(); i < n; i++) {
                    Part part = mp.getBodyPart(i);
                    String disposition = part.getDisposition();
                    if ((disposition != null) && ((disposition.equals(Part.ATTACHMENT) || (disposition.equals(Part.INLINE))))) {
                        MAttachment attach = req.createAttachment();
                        InputStream in = part.getInputStream();
                        ByteArrayOutputStream out = new ByteArrayOutputStream();
                        //1KiB buffer
                        final int BUF_SIZE = 1 << 8;
                        byte[] buffer = new byte[BUF_SIZE];
                        int bytesRead = -1;
                        while ((bytesRead = in.read(buffer)) > -1) {
                            out.write(buffer, 0, bytesRead);
                        }
                        in.close();
                        byte[] bytes = out.toByteArray();
                        attach.addEntry(part.getFileName(), bytes);
                        attach.saveEx(get_TrxName());
                    }
                }
            } catch (IOException e) {
                log.log(Level.FINE, "Error extracting attachments", e);
            }
        }
        return true;
    } else {
        return false;
    }
}