Subversion Repositories SmartDukaan

Rev

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