trigger op5EmailTrigger on EmailMessage (before insert) {
op5EmailHandler.getEmailData(Trigger.new);
}
global class op5EmailHandler {
public static void getEmailData(EmailMessage messageList) {
for(EmailMessage email : messageList) {
try {
if(email.fromAddress == 'hidden@for.now') {
String emailSubject = email.Subject;
String emailBody = email.TextBody;
Pattern assetPattern = Pattern.compile('((e)\\: )(.*)');
Pattern serialPattern = Pattern.compile('((l)\\: )(.*)');
// define separate matchers for asset and serial
Matcher assetMatcher = assetPattern.matcher(emailBody);
Matcher serialMatcher = serialPattern.matcher(emailBody);
if(assetMatcher.find() && serialMatcher.find()) {
String asset = assetMatcher.group(3);
String serial = serialMatcher.group(3);
Asset findAsset = [SELECT Id,AccountId FROM Asset WHERE (Serial_No__c=:serial AND Name=:asset)];
String assetAccount = findAsset.AccountId;
String assetFound = findAsset.Id;
// array, as it may include multiple cases
Case[] returnedCases = [SELECT Id,CaseNumber FROM Case WHERE (AssetId=:assetFound AND Origin='Monitoring OP5' AND (Status!='Closed' OR Status!='No fault found') AND Type='Incident')];
if(returnedCases.size() == 2) {
// create a new case
Case newCase = new Case(Subject=emailSubject, AccountId=assetAccount, AssetId=assetFound, Description=emailBody);
insert newCase;
// post to chatter
String multipleCasesExists = 'There is multiple open cases for Asset: ' + assetMatcher.group(1) + ' with S/N: ' + serialMatcher.group(1) + ' and a new case has been created with Case Number: ' + newCase.CaseNumber + '. Please delete the cases that are irrelevant and use one case to track the alerts for this Asset.';
ConnectApi.FeedElement sendToChatter = ConnectApi.ChatterFeeds.postFeedElement(Network.getNetworkId(), '0F925000000049v', ConnectApi.FeedElementType.FeedItem, multipleCasesExists);
} else if(returnedCases.size() == 1) {
EmailMessage newEmail = new EmailMessage(FromAddress = email.FromAddress,
FromName = email.FromName,
ToAddress = email.ToAddress,
Subject = email.Subject,
TextBody = email.TextBody,
HtmlBody = email.HtmlBody,
Incoming = true,
MessageDate = System.now(),
ParentId = returnedCases[0].Id);
insert newEmail;
// post to chatter
String chatterMessage = 'New email from OP5 have been inserted into case: ' + returnedCases[0].CaseNumber + '. Please investigate if further action is needed.';
ConnectApi.FeedElement sendToChatter = ConnectApi.ChatterFeeds.postFeedElement(Network.getNetworkId(), '0F925000000049v', ConnectApi.FeedElementType.FeedItem, chatterMessage);
// send email to case owner
} else {
// create new case
Case newCase = new Case(Subject=emailSubject, AccountId=assetAccount, AssetId=assetFound, Description=emailBody);
insert newCase;
// post to chatter
String newCaseFromOP5 = 'New case: ' + newCase.CaseNumber + ' for Asset: ' + assetMatcher.group(1) + ' with S/N: ' + serialMatcher.group(1) + ' has been created, please take action asap.';
ConnectApi.FeedElement sendToChatter = ConnectApi.ChatterFeeds.postFeedElement(Network.getNetworkId(), '0F925000000049v', ConnectApi.FeedElementType.FeedItem, newCaseFromOP5);
}
}
}
return email;
} catch (Exception e) {
return email;
}
}
}
}
SELECT Id,Name,Account.Name,SerialNumber FROM Asset
^
ERROR at Row:1:Column:29
No such column 'SerialNumber' on entity 'Asset'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
SELECT Id,Name,Account.Name,SerialNumber FROM Asset
^
ERROR at Row:1:Column:29
No such column 'SerialNumber' on entity 'Asset'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.