Subversion Repositories SmartDukaan

Rev

Rev 4196 | Rev 4241 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
3339 mandeep.dh 1
/**
2
 * 
3
 */
4
package in.shop2020.util;
5
 
6
import in.shop2020.crm.Activity;
7
import in.shop2020.crm.ActivityType;
8
import in.shop2020.crm.CRMService.Client;
3390 mandeep.dh 9
import in.shop2020.crm.SearchFilter;
3339 mandeep.dh 10
import in.shop2020.crm.Ticket;
11
import in.shop2020.crm.TicketCategory;
12
import in.shop2020.crm.TicketPriority;
13
import in.shop2020.crm.TicketStatus;
14
import in.shop2020.model.v1.user.User;
15
import in.shop2020.model.v1.user.UserContextException;
16
import in.shop2020.thrift.clients.CRMClient;
17
import in.shop2020.thrift.clients.UserClient;
18
 
19
import java.io.IOException;
20
import java.text.ParseException;
21
import java.util.Date;
3408 mandeep.dh 22
import java.util.List;
3339 mandeep.dh 23
import java.util.regex.Matcher;
24
import java.util.regex.Pattern;
25
 
26
import javax.mail.Message;
27
import javax.mail.MessagingException;
3368 mandeep.dh 28
import javax.mail.Multipart;
29
import javax.mail.Part;
3339 mandeep.dh 30
 
3546 mandeep.dh 31
import net.htmlparser.jericho.Source;
32
 
3339 mandeep.dh 33
import org.apache.commons.logging.Log;
34
import org.apache.commons.logging.LogFactory;
35
import org.apache.thrift.TException;
36
import org.apache.thrift.transport.TTransportException;
37
 
38
/**
39
 * @author mandeep
40
 * 
41
 */
42
public class CRMEmailProcessor {
3369 mandeep.dh 43
    private static final String MAILOR_DAEMON_EMAIL_ID = "mailer-daemon@googlemail.com";
3339 mandeep.dh 44
    private static final Log log                   = LogFactory
45
                                                           .getLog(CRMEmailProcessor.class);
46
    private Client           client;
47
 
48
    public void processEmail(Message message) throws MessagingException,
49
            IOException, TException, UserContextException {
3369 mandeep.dh 50
        // Ignoring mails from Mailor daemon
51
        if (MAILOR_DAEMON_EMAIL_ID.equals(parseEmailId(message.getFrom()[0].toString()))) {
52
            return;
53
        }
54
 
4142 mandeep.dh 55
        // Try parsing the ticket Id from email with subject like Saholic#123 ...
3339 mandeep.dh 56
        Long ticketId = parseTicketId(message);
57
 
58
        if (ticketId != null) {
59
            log.info("Response for Ticket: " + ticketId + ": " + message);
60
            updateTicket(ticketId, message);
61
        } else {
62
            log.info("Mail not recognized as CRM ticket response with subject: "
63
                    + message.getSubject());
64
            log.info("Creating ticket for the same");
65
            createTicket(message);
66
        }
67
    }
68
 
4142 mandeep.dh 69
    // Parses regex like ^.*Saholic#(\d+).*
3339 mandeep.dh 70
    private Long parseTicketId(Message message) throws MessagingException {
71
        Long ticketId = null;
72
        String subject = message.getSubject();
73
        if (subject != null) {
74
            Pattern p = Pattern.compile("^.*"
75
                    + CRMConstants.CRM_SUBJECT_PREFIX_FOR_TICKET_ID
76
                    + "(\\d+).*$");
77
            Matcher m = p.matcher(subject);
78
            if (m.matches()) {
79
                ticketId = Long.parseLong(m.group(1));
80
            }
81
        }
82
 
83
        return ticketId;
84
    }
85
 
86
    public Date getLastProcessedTimestamp() throws ParseException, TException {
3373 mandeep.dh 87
        client = new CRMClient().getClient();
3339 mandeep.dh 88
        return new Date(client.getLastEmailProcessedTimestamp());
89
    }
90
 
91
    public void updateLastProcessedTimestamp(Date date) throws TException {
3340 mandeep.dh 92
        client = new CRMClient().getClient();
3339 mandeep.dh 93
        client.updateLastEmailProcessedTimestamp(date.getTime());
94
    }
95
 
96
    private void updateTicket(Long ticketId, Message message) {
97
        try {
3390 mandeep.dh 98
            SearchFilter searchFilter = new SearchFilter();
99
            searchFilter.setTicketId(ticketId);
3373 mandeep.dh 100
            client = new CRMClient().getClient();
3408 mandeep.dh 101
            List<Ticket> tickets = client.getTickets(searchFilter);
102
            if (tickets == null || tickets.isEmpty()) {
103
                log.error("Invalid TicketId: " + ticketId);
104
                log.error("Not processing message with subject: " + message.getSubject());
105
                return;
106
            }
107
 
108
            Ticket ticket = tickets.get(0);
3339 mandeep.dh 109
            Activity activity = new Activity();
110
            activity.setTicketId(ticketId);
111
            activity.setTicketAssigneeId(ticket.getAssigneeId());
112
            activity.setTicketCategory(ticket.getCategory());
113
            activity.setTicketDescription(ticket.getDescription());
114
            activity.setTicketPriority(ticket.getPriority());
115
            activity.setType(ActivityType.RECEIVED_EMAIL_FROM_CUSTOMER);
116
            activity.setCreatorId(CRMConstants.ADMIN_AGENT_ID);
3398 mandeep.dh 117
            activity.setIsRead(false);
3339 mandeep.dh 118
 
119
            if (ticket.isSetCustomerId()) {
120
                activity.setCustomerId(ticket.getCustomerId());
121
            }
122
 
123
            activity.setDescription(convertMessageToText(message));
3368 mandeep.dh 124
 
125
            if (TicketStatus.CLOSED.equals(ticket.getStatus())) {
126
                ticket.setStatus(TicketStatus.REOPEN);
127
            }
128
 
4196 mandeep.dh 129
            activity.setTicketStatus(ticket.getStatus());
130
 
3373 mandeep.dh 131
            client = new CRMClient().getClient();
3339 mandeep.dh 132
            client.updateTicket(ticket, activity);
133
        } catch (TTransportException e) {
134
            log.error("Could not update ticket " + ticketId + " with mail "
135
                    + message, e);
136
        } catch (TException e) {
137
            log.error("Could not update ticket " + ticketId + " with mail "
138
                    + message, e);
139
        } catch (MessagingException e) {
140
            log.error("Could not update ticket " + ticketId + " with mail "
141
                    + message, e);
142
        } catch (IOException e) {
143
            log.error("Could not update ticket " + ticketId + " with mail "
144
                    + message, e);
145
        }
146
    }
147
 
148
    private void createTicket(Message message) throws MessagingException,
149
            IOException, TException, UserContextException {
150
        String description = convertMessageToText(message);
151
        Ticket ticket = new Ticket();
152
        ticket.setCreatorId(CRMConstants.ADMIN_AGENT_ID);
153
        ticket.setCategory(TicketCategory.OTHER);
154
        String customerEmailId = parseEmailId(message.getFrom()[0].toString());
155
 
156
        in.shop2020.model.v1.user.UserContextService.Client userClient = new UserClient()
157
                .getClient();
158
        User user = userClient.getUserByEmail(customerEmailId);
159
 
160
        if (user == null || user.getUserId() == -1) {
161
            ticket.setCustomerEmailId(customerEmailId);
162
        } else {
163
            ticket.setCustomerId(user.getUserId());
164
        }
165
 
166
        ticket.setDescription(description);
167
        ticket.setPriority(TicketPriority.MEDIUM);
168
        ticket.setStatus(TicketStatus.OPEN);
169
 
170
        log.info("Creating activity!");
171
        Activity activity = new Activity();
172
        activity.setDescription(description);
173
        activity.setTicketCategory(ticket.getCategory());
174
        activity.setTicketDescription(ticket.getDescription());
175
        activity.setTicketPriority(ticket.getPriority());
176
        activity.setTicketStatus(ticket.getStatus());
177
        activity.setType(ActivityType.RECEIVED_EMAIL_FROM_CUSTOMER);
178
        activity.setCreatorId(CRMConstants.ADMIN_AGENT_ID);
3398 mandeep.dh 179
        activity.setIsRead(false);
3339 mandeep.dh 180
 
3373 mandeep.dh 181
        client = new CRMClient().getClient();
3339 mandeep.dh 182
        client.insertTicket(ticket, activity);
183
    }
184
 
185
    // parsing email Id from strings like
3368 mandeep.dh 186
    // "Pankaj Jain <ponkoj@hotmail.com>"
3339 mandeep.dh 187
    private String parseEmailId(String address) {
188
        Pattern p = Pattern.compile("^.*<(.+)>.*$");
189
        Matcher m = p.matcher(address);
190
        if (m.matches()) {
191
            address = m.group(1);
192
        }
193
 
194
        return address;
195
    }
196
 
197
    private String convertMessageToText(Message message)
198
            throws MessagingException, IOException {
3368 mandeep.dh 199
        String messageContent = getText(message);
3339 mandeep.dh 200
 
3368 mandeep.dh 201
        String content = "From: " + message.getFrom()[0].toString()
202
                + "\n\nSubject: " + message.getSubject() + "\n\nBody: "
203
                + messageContent;
3339 mandeep.dh 204
 
4206 mandeep.dh 205
        if (content.length() > CRMConstants.DESCRIPTION_MAX_WIDTH) {
206
            content = content.substring(0, CRMConstants.DESCRIPTION_MAX_WIDTH);
3368 mandeep.dh 207
            content += "\n\nTHIS TEXT IS TRUNCATED. PLEASE VISIT INBOX TO SEE COMPLETE DETAILS.";
3339 mandeep.dh 208
        }
209
 
210
        return content;
211
    }
3368 mandeep.dh 212
 
213
    /**
214
     * Return the primary text content of the message.
215
     */
216
    private String getText(Part p) throws MessagingException, IOException {
217
        if (p.isMimeType("text/*")) {
218
            String s = (String) p.getContent();
3546 mandeep.dh 219
            if (p.isMimeType("text/html")) {
220
                return new Source(s).getTextExtractor().toString();
221
            }
222
            else {
223
                return s;
224
            }
3368 mandeep.dh 225
        }
226
 
227
        if (p.isMimeType("multipart/alternative")) {
228
            // prefer plain text over html text
229
            Multipart mp = (Multipart) p.getContent();
230
            String text = null;
231
            for (int i = 0; i < mp.getCount(); i++) {
232
                Part bp = mp.getBodyPart(i);
233
                if (bp.isMimeType("text/html")) {
234
                    if (text == null)
235
                        text = getText(bp);
236
                    continue;
237
                } else if (bp.isMimeType("text/plain")) {
238
                    String s = getText(bp);
239
                    if (s != null)
240
                        return s;
241
                } else {
242
                    return getText(bp);
243
                }
244
            }
245
            return text;
246
        } else if (p.isMimeType("multipart/*")) {
247
            Multipart mp = (Multipart) p.getContent();
248
            for (int i = 0; i < mp.getCount(); i++) {
249
                String s = getText(mp.getBodyPart(i));
250
                if (s != null)
251
                    return s;
252
            }
253
        }
254
 
255
        return null;
256
    }
3339 mandeep.dh 257
}