// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x896e=['readFileSync','build','writeFileSync','message%d.eml','err','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','lodash','squel','crypto','jsforce','to-csv','querystring','papaparse','juice','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','redis','defaults','socket.io-emitter','./mailInteraction.socket','end','json','count','offset','limit','set','apply','save','update','then','status','sendStatus','stack','name','send','map','fullname','TagIds','split','forEach','push','lastMsgText','fromString','lastMsgBody','catch','index','MailInteraction','rawAttributes','fieldName','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','from','tools_tags','u.fullname','ui.MailInteractionId','user_has_mail_interactions','users','u.id\x20=\x20ui.UserId','left_join','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','a.id\x20=\x20i.MailAccountId','mail_messages','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','`\x20=\x200','Contact','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','text','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','UserId','type','start','plainBody','some','compact','isEmpty','i.MailAccountId\x20IN\x20?','parse','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','filter','replace','isNumeric','i.id\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.id','Sequelize','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','resolve','MailAccountId','i.MailAccountId\x20IS\x20NOT\x20NULL','user','role','agent','getMailAccounts','i.MailAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','a.key','Account.key','Account.mandatoryDisposition','contactName','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.disposition','i.secondDisposition','i.substatus','i.to','i.ContactId','i.UserId','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','groupBy','MailInteractionId','Setting','findOne','enableEmailPreview','all','rows','show','params','includeAll','options','create','body','destroy','describe','MailMessage','addMessage','ids','omit','getMessages','$gte','format','YYYY-MM-DD\x20HH:mm:ss','include','findAll','inlineCss','true','setTags','spread','emit','mailInteractionTags:save','removeTags','unix','root','server','files','tmp','join','transcript-%d-%s.zip','attachments','Attachment','bcc','subject','createdAt','get','mkdirSync','each','Messages','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Attachments','basename'];(function(_0xd1d19a,_0x1933f0){var _0x52a79d=function(_0x5199e2){while(--_0x5199e2){_0xd1d19a['push'](_0xd1d19a['shift']());}};_0x52a79d(++_0x1933f0);}(_0x896e,0x1e9));var _0xe896=function(_0xa4320d,_0x1247e5){_0xa4320d=_0xa4320d-0x0;var _0x5ec385=_0x896e[_0xa4320d];return _0x5ec385;};'use strict';var pdf=require(_0xe896('0x0'));var emlformat=require(_0xe896('0x1'));var rimraf=require(_0xe896('0x2'));var zipdir=require(_0xe896('0x3'));var jsonpatch=require(_0xe896('0x4'));var rp=require(_0xe896('0x5'));var moment=require(_0xe896('0x6'));var BPromise=require(_0xe896('0x7'));var Mustache=require(_0xe896('0x8'));var util=require(_0xe896('0x9'));var path=require(_0xe896('0xa'));var sox=require(_0xe896('0xb'));var csv=require('to-csv');var ejs=require(_0xe896('0xc'));var fs=require('fs');var _=require(_0xe896('0xd'));var squel=require(_0xe896('0xe'));var crypto=require(_0xe896('0xf'));var jsforce=require(_0xe896('0x10'));var deskjs=require('desk.js');var toCsv=require(_0xe896('0x11'));var querystring=require(_0xe896('0x12'));var Papa=require(_0xe896('0x13'));var htmlToText=require('html-to-text');var juice=require(_0xe896('0x14'));var Redis=require('ioredis');var authService=require(_0xe896('0x15'));var qs=require('../../components/parsers/qs');var as=require(_0xe896('0x16'));var hardwareService=require(_0xe896('0x17'));var logger=require(_0xe896('0x18'))('api');var utils=require(_0xe896('0x19'));var config=require(_0xe896('0x1a'));var licenseUtil=require(_0xe896('0x1b'));var db=require('../../mysqldb')['db'];config[_0xe896('0x1c')]=_[_0xe896('0x1d')](config[_0xe896('0x1c')],{'host':'localhost','port':0x18eb});var socket=require(_0xe896('0x1e'))(new Redis(config[_0xe896('0x1c')]));require(_0xe896('0x1f'))['register'](socket);function respondWithStatusCode(_0x5a7957,_0x446ce2){_0x446ce2=_0x446ce2||0xcc;return function(_0x25606b){if(_0x25606b){return _0x5a7957['sendStatus'](_0x446ce2);}return _0x5a7957['status'](_0x446ce2)[_0xe896('0x20')]();};}function respondWithResult(_0x16e272,_0x57f04b){_0x57f04b=_0x57f04b||0xc8;return function(_0x50d224){if(_0x50d224){return _0x16e272['status'](_0x57f04b)[_0xe896('0x21')](_0x50d224);}};}function respondWithFilteredResult(_0x32f86d,_0x2d4cf0){return function(_0x5dc89d){if(_0x5dc89d){var _0x782813=_0x5dc89d[_0xe896('0x22')],_0x9714f1=_0x2d4cf0[_0xe896('0x23')],_0xdcdba8=_0x2d4cf0[_0xe896('0x23')]+_0x2d4cf0[_0xe896('0x24')],_0xbebbe1;if(_0xdcdba8>=_0x782813){_0xdcdba8=_0x782813;_0xbebbe1=0xc8;}else{_0xbebbe1=0xce;}_0x32f86d['status'](_0xbebbe1);return _0x32f86d[_0xe896('0x25')]('Content-Range',_0x9714f1+'-'+_0xdcdba8+'/'+_0x782813)['json'](_0x5dc89d);}return null;};}function patchUpdates(_0x3117cc){return function(_0x346463){try{jsonpatch[_0xe896('0x26')](_0x346463,_0x3117cc,!![]);}catch(_0xeeec7c){return BPromise['reject'](_0xeeec7c);}return _0x346463[_0xe896('0x27')]();};}function saveUpdates(_0x4ad156,_0x5001f7){return function(_0x45dd49){if(_0x45dd49){return _0x45dd49[_0xe896('0x28')](_0x4ad156)[_0xe896('0x29')](function(_0x2e2c10){return _0x2e2c10;});}return null;};}function removeEntity(_0x20e295,_0x4d9f03){return function(_0x781096){if(_0x781096){return _0x781096['destroy']()[_0xe896('0x29')](function(){_0x20e295[_0xe896('0x2a')](0xcc)[_0xe896('0x20')]();});}};}function handleEntityNotFound(_0x569d5f,_0x26635e){return function(_0xd50fe2){if(!_0xd50fe2){_0x569d5f[_0xe896('0x2b')](0x194);}return _0xd50fe2;};}function handleError(_0xe93aa0,_0x2d8a7b){_0x2d8a7b=_0x2d8a7b||0x1f4;return function(_0x3f8ceb){logger['error'](_0x3f8ceb[_0xe896('0x2c')]);if(_0x3f8ceb[_0xe896('0x2d')]){delete _0x3f8ceb[_0xe896('0x2d')];}_0xe93aa0[_0xe896('0x2a')](_0x2d8a7b)[_0xe896('0x2e')](_0x3f8ceb);};}function getInteractionUsers(_0x5e0d9b,_0x47c268){return new BPromise(function(_0x5c7dae,_0x504d7c){try{if(_0x47c268[_0x5e0d9b['id']]){_0x5e0d9b['Users']=_[_0xe896('0x2f')](_0x47c268[_0x5e0d9b['id']],function(_0x29a18e){return{'id':_0x29a18e['id'],'fullname':_0x29a18e[_0xe896('0x30')]};});}}catch(_0x76c781){_0x504d7c(_0x76c781);}_0x5c7dae(_0x5e0d9b);});}function getInteractionTags(_0x3cd88e,_0x1a6090){return new BPromise(function(_0x322ebc,_0x45c6d3){try{if(_0x3cd88e['TagIds']){_0x3cd88e['Tags']=[];_0x3cd88e[_0xe896('0x31')][_0xe896('0x32')](',')[_0xe896('0x33')](function(_0x76c0c3){_0x3cd88e['Tags'][_0xe896('0x34')](_0x1a6090[_0x76c0c3]);});}delete _0x3cd88e['TagIds'];}catch(_0x57c6e8){_0x45c6d3(_0x57c6e8);}_0x322ebc(_0x3cd88e);});}function getLastMessageText(_0x166b86){return new BPromise(function(_0x363fd8,_0x266c0e){return db['MailInteraction']['findOne']({'where':{'id':_0x166b86['id']},'attributes':['lastMsgBody',_0xe896('0x35')],'raw':!![]})[_0xe896('0x29')](function(_0x10fa64){if(!_0x10fa64[_0xe896('0x35')]){_0x166b86[_0xe896('0x35')]=_['trimStart'](htmlToText[_0xe896('0x36')](_0x10fa64[_0xe896('0x37')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x166b86[_0xe896('0x35')]=_0x10fa64[_0xe896('0x35')];}_0x363fd8(_0x166b86);})[_0xe896('0x38')](function(_0x2cce09){_0x266c0e(_0x2cce09);});});}function updateMailInteraction(_0x3aeccc,_0x3e28f0,_0x5ea3ce,_0x42f3fb){return new BPromise(function(_0x1ad362,_0x5a2dd2){return getInteractionUsers(_0x3aeccc,_0x5ea3ce)[_0xe896('0x29')](function(_0x4baad4){return getInteractionTags(_0x4baad4,_0x3e28f0);})[_0xe896('0x29')](function(_0x4f164f){if(_0x42f3fb){_0x1ad362(getLastMessageText(_0x4f164f));}else{_0x1ad362(_0x4f164f);}})[_0xe896('0x38')](function(_0x5ba71e){_0x5a2dd2(_0x5ba71e);});});}exports[_0xe896('0x39')]=function(_0x470c29,_0x403ff4){var _0x3f158b={},_0xeb9bbf={},_0x533173={'count':0x0,'rows':[]};var _0x480b8a=_[_0xe896('0x2f')](db[_0xe896('0x3a')][_0xe896('0x3b')],function(_0x15b6c5){return{'name':_0x15b6c5[_0xe896('0x3c')],'type':_0x15b6c5['type']['key']};});_0xeb9bbf[_0xe896('0x3d')]=_[_0xe896('0x2f')](_0x480b8a,'name');_0xeb9bbf['query']=_[_0xe896('0x3e')](_0x470c29[_0xe896('0x3f')]);_0xeb9bbf[_0xe896('0x40')]=_[_0xe896('0x41')](_0xeb9bbf[_0xe896('0x3d')],_0xeb9bbf[_0xe896('0x3f')]);_0x3f158b[_0xe896('0x42')]=_[_0xe896('0x41')](_0xeb9bbf[_0xe896('0x3d')],qs[_0xe896('0x43')](_0x470c29[_0xe896('0x3f')][_0xe896('0x43')]));_0x3f158b['attributes']=_0x3f158b[_0xe896('0x42')][_0xe896('0x44')]?_0x3f158b['attributes']:_0xeb9bbf['model'];if(!_0x470c29['query'][_0xe896('0x45')](_0xe896('0x46'))){_0x3f158b[_0xe896('0x24')]=qs['limit'](_0x470c29[_0xe896('0x3f')][_0xe896('0x24')]);_0x3f158b['offset']=qs['offset'](_0x470c29['query'][_0xe896('0x23')]);}_0x3f158b[_0xe896('0x47')]=qs[_0xe896('0x48')](_0x470c29[_0xe896('0x3f')][_0xe896('0x48')]);_0x3f158b[_0xe896('0x49')]=qs['filters'](_[_0xe896('0x4a')](_0x470c29[_0xe896('0x3f')],_0xeb9bbf['filters']),_0x480b8a);var _0x43bca4=[];var _0x429f1a=squel[_0xe896('0x4b')]()[_0xe896('0x4c')]('id')['field'](_0xe896('0x2d'))[_0xe896('0x4c')](_0xe896('0x4d'))[_0xe896('0x4e')](_0xe896('0x4f'));var _0xc6829e=squel['select']()[_0xe896('0x4c')]('u.id')[_0xe896('0x4c')](_0xe896('0x50'))[_0xe896('0x4c')](_0xe896('0x51'))[_0xe896('0x4e')](_0xe896('0x52'),'ui')['left_join'](_0xe896('0x53'),'u',_0xe896('0x54'));var _0x4818cd=squel[_0xe896('0x4b')]()[_0xe896('0x4e')]('mail_interactions','i')[_0xe896('0x55')]('cm_contacts','c',_0xe896('0x56'))[_0xe896('0x55')](_0xe896('0x53'),'o',_0xe896('0x57'))[_0xe896('0x55')]('mail_accounts','a',_0xe896('0x58'))[_0xe896('0x55')](_0xe896('0x59'),'me','me.MailInteractionId\x20=\x20i.id')[_0xe896('0x55')]('mail_interaction_has_tags','it','it.MailInteractionId\x20=\x20i.id')[_0xe896('0x55')](_0xe896('0x4f'),'t','t.id\x20=\x20it.TagId');var _0x343adb=squel[_0xe896('0x5a')]();var _0x5bfd1e=[];var _0x58497a=squel[_0xe896('0x5a')]();var _0x3a368c;if(_0x470c29['query'][_0xe896('0x5b')]){_0x3a368c=as[_0xe896('0x5c')](_0x470c29[_0xe896('0x3f')][_0xe896('0x5b')]);var _0x16d1c8=_0x3a368c[_0xe896('0x5d')];for(var _0xaf35a4=0x0;_0xaf35a4<_0x3a368c[_0xe896('0x5e')][_0xe896('0x44')];_0xaf35a4++){var _0x3837e7=_0x3a368c[_0xe896('0x5e')][_0xaf35a4];var _0x54a93d='i';var _0x1d7e31=_[_0xe896('0x5f')](_0x480b8a,[_0xe896('0x2d'),_0x3837e7[_0xe896('0x4c')]]);if(!_0x1d7e31){switch(_0x3837e7[_0xe896('0x4c')]){case _0xe896('0x60'):if(_0x3837e7[_0xe896('0x61')]==0x1){_0x4818cd[_0xe896('0x62')]('`'+_0x3837e7[_0xe896('0x4c')]+_0xe896('0x63'));}else{_0x4818cd[_0xe896('0x62')]('`'+_0x3837e7[_0xe896('0x4c')]+'`\x20>\x200');}break;case _0xe896('0x64'):if(_0x3837e7[_0xe896('0x65')]===_0xe896('0x66')){if(_0x3837e7['value']['split']('\x20')['length']>0x1){_0x343adb[_0x16d1c8](_0xe896('0x67'),qs[_0xe896('0x68')](_0x3837e7[_0xe896('0x61')]),null);}else{var _0x2496d4='%'+_0x3837e7['value']+'%';_0x343adb[_0x16d1c8](_0xe896('0x69'),_0x2496d4,_0x2496d4,_0x2496d4);}}else{_0x1d7e31=_[_0xe896('0x5f')](_0x480b8a,[_0xe896('0x2d'),_0xe896('0x6a')]);_0x3837e7['field']=_0xe896('0x6a');_0x27d90d=as[_0xe896('0x6b')](_0x54a93d,_0x1d7e31['type'],_0x3837e7);_0x343adb[_0x16d1c8](_0x27d90d[_0xe896('0x6c')],_0x27d90d[_0xe896('0x61')]['start'],_0x27d90d['value'][_0xe896('0x20')]);}break;case _0xe896('0x6d'):var _0x313da7=_0x3837e7[_0xe896('0x61')][_0xe896('0x32')](',')['map'](function(_0xdadb92){return Number(_0xdadb92);});_0x313da7[_0xe896('0x33')](function(_0x113b00){_0x58497a['or'](_0xe896('0x6e'),'%,'+_0x113b00+',%');});_0x5bfd1e=_['union'](_0x5bfd1e,_0x313da7);break;case'User':if(_0x3837e7[_0xe896('0x65')]===_0xe896('0x66')){_0x343adb[_0x16d1c8]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x3837e7[_0xe896('0x61')]+'%',null);}else{_0x1d7e31=_['find'](_0x480b8a,[_0xe896('0x2d'),_0xe896('0x6f')]);_0x3837e7[_0xe896('0x4c')]=_0xe896('0x6f');_0x27d90d=as[_0xe896('0x6b')](_0x54a93d,_0x1d7e31[_0xe896('0x70')],_0x3837e7);_0x343adb[_0x16d1c8](_0x27d90d[_0xe896('0x6c')],_0x27d90d[_0xe896('0x61')][_0xe896('0x71')],_0x27d90d[_0xe896('0x61')][_0xe896('0x20')]);}break;case _0xe896('0x72'):_0x27d90d=as[_0xe896('0x6b')]('me',null,_0x3837e7);_0x343adb[_0x16d1c8](_0x27d90d[_0xe896('0x6c')],_0x27d90d[_0xe896('0x61')][_0xe896('0x71')],_0x27d90d[_0xe896('0x61')][_0xe896('0x20')]);break;}}else{var _0x27d90d=as[_0xe896('0x6b')](_0x54a93d,_0x1d7e31[_0xe896('0x70')],_0x3837e7);_0x343adb[_0x16d1c8](_0x27d90d[_0xe896('0x6c')],_0x27d90d['value']['start'],_0x27d90d[_0xe896('0x61')][_0xe896('0x20')]);}}}else{var _0x496e2c=_(_0x470c29[_0xe896('0x3f')])[_0xe896('0x3e')]()[_0xe896('0x2f')](function(_0x186ddc){return _[_0xe896('0x73')](_0x480b8a,[_0xe896('0x2d'),_0x186ddc])?_0x186ddc:undefined;})[_0xe896('0x74')]()[_0xe896('0x61')]();if(!_[_0xe896('0x75')](_0x496e2c)){_0x496e2c[_0xe896('0x33')](function(_0x1479c8){if(_0x1479c8==='MailAccountId'){_0x4818cd[_0xe896('0x49')](_0xe896('0x76'),[]['concat'](_0x470c29[_0xe896('0x3f')][_0x1479c8]));}else if(_0x1479c8==='createdAt'){var _0x47b8b7=JSON[_0xe896('0x77')](_0x470c29[_0xe896('0x3f')][_0x1479c8])['$gte'];var _0x56223c=JSON[_0xe896('0x77')](_0x470c29['query'][_0x1479c8])['$lte'];_0x4818cd[_0xe896('0x49')](_0xe896('0x78'),_0x47b8b7,_0x56223c);}else{if(_0x470c29[_0xe896('0x3f')][_0x1479c8]==='null'){_0x4818cd[_0xe896('0x49')]('i.'+_0x1479c8+_0xe896('0x79'));}else{_0x4818cd[_0xe896('0x49')]('i.'+_0x1479c8+'\x20=\x20?',_0x470c29[_0xe896('0x3f')][_0x1479c8]);}}});}if(_0x470c29[_0xe896('0x3f')][_0xe896('0x7a')]){if(_0x470c29[_0xe896('0x3f')]['read']==0x1){_0x4818cd[_0xe896('0x62')](_0xe896('0x7b'));}else{_0x4818cd[_0xe896('0x62')](_0xe896('0x7c'));}}if(_0x470c29['query'][_0xe896('0x7d')]){_0x5bfd1e=_[_0xe896('0x7e')](_0x470c29['query'][_0xe896('0x7d')])?_0x470c29[_0xe896('0x3f')][_0xe896('0x7d')]:new Array(_0x470c29[_0xe896('0x3f')]['tag']);_0x5bfd1e[_0xe896('0x33')](function(_0x234a3a){_0x58497a['or'](_0xe896('0x6e'),'%,'+_0x234a3a+',%');});}if(_0x470c29[_0xe896('0x3f')][_0xe896('0x7f')]){var _0x1f8792=_0x470c29['query']['filter']['replace']('\x5c','\x5c\x5c')[_0xe896('0x80')](/'/g,'\x27\x27');if(qs[_0xe896('0x81')](_0x1f8792)){_0x343adb['or'](_0xe896('0x82'),_0x1f8792+'%');}else if(qs[_0xe896('0x83')](_0x1f8792)){_0x343adb['or'](_0xe896('0x84'),_0x1f8792+'%');}else{_0x343adb['or'](_0xe896('0x85'),qs[_0xe896('0x68')](_0x1f8792))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x1f8792));}}}_0x4818cd[_0xe896('0x49')](_0x343adb);_0x4818cd['group'](_0xe896('0x86'));var _0x5c5c90={'type':db[_0xe896('0x87')]['QueryTypes'][_0xe896('0x88')],'raw':!![]};var _0x36994f=_0x4818cd[_0xe896('0x89')]();_0x36994f[_0xe896('0x4c')](_0xe896('0x86'));_0x36994f['field'](_0xe896('0x8a'),_0xe896('0x60'));if(_0x3f158b[_0xe896('0x47')]){_0x3f158b[_0xe896('0x47')][_0xe896('0x33')](function(_0x27a9a7){var _0x73ef35=_0x27a9a7[0x0]==='contactName'?_0x27a9a7[0x0]:'i.'+_0x27a9a7[0x0];_0x4818cd[_0xe896('0x47')](_0x73ef35,_0x27a9a7[0x1]==='DESC'?![]:!![]);});}if(!_[_0xe896('0x75')](_0x5bfd1e)){_0x4818cd[_0xe896('0x62')](_0x58497a);_0x36994f[_0xe896('0x49')]('t.id\x20IN\x20?',_0x5bfd1e);}BPromise[_0xe896('0x8b')]()[_0xe896('0x29')](function(){if(!_0x3a368c){if(_0x470c29[_0xe896('0x3f')][_0xe896('0x8c')])return;_0x36994f[_0xe896('0x49')](_0xe896('0x8d'));_0x4818cd[_0xe896('0x49')](_0xe896('0x8d'));return;}if(_0x470c29[_0xe896('0x8e')][_0xe896('0x8f')]!==_0xe896('0x90'))return;return _0x470c29['user'][_0xe896('0x91')]({'attributes':['id'],'raw':!![]})[_0xe896('0x29')](function(_0x3d3a1b){if(_[_0xe896('0x75')](_0x3d3a1b)){_0x36994f['where'](_0xe896('0x92'));_0x4818cd[_0xe896('0x49')](_0xe896('0x92'));}else{_0x36994f[_0xe896('0x49')](_0xe896('0x76'),_[_0xe896('0x2f')](_0x3d3a1b,'id'));_0x4818cd[_0xe896('0x49')](_0xe896('0x76'),_[_0xe896('0x2f')](_0x3d3a1b,'id'));}});})[_0xe896('0x29')](function(){if(_0x470c29[_0xe896('0x8e')][_0xe896('0x8f')]==='agent'&&!_0x3a368c&&!_0x470c29[_0xe896('0x3f')][_0xe896('0x8c')])return[];return db[_0xe896('0x93')]['query'](_0x36994f[_0xe896('0x94')](),_0x5c5c90);})['then'](function(_0x50e997){_0x533173[_0xe896('0x22')]=_0x50e997[_0xe896('0x44')];if(_0x533173[_0xe896('0x22')]===0x0)return[];return db['sequelize'][_0xe896('0x3f')](_0x429f1a[_0xe896('0x94')](),_0x5c5c90)['then'](function(_0x5dc3b7){_0x43bca4=_[_0xe896('0x95')](_0x5dc3b7,'id');_0x5c5c90=_[_0xe896('0x96')](_0x5c5c90,{'model':db[_0xe896('0x3a')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x470c29[_0xe896('0x3f')][_0xe896('0x43')]){_0x3f158b[_0xe896('0x42')][_0xe896('0x33')](function(_0x4a0c0d){_0x4818cd['field']('i.'+_0x4a0c0d);});}else{_0x4818cd[_0xe896('0x4c')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');_0x4818cd[_0xe896('0x4c')](_0xe896('0x97'),_0xe896('0x98'));_0x4818cd[_0xe896('0x4c')]('a.mandatoryDisposition',_0xe896('0x99'));_0x4818cd[_0xe896('0x4c')]('CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20(\x27%\x27\x20+\x20a.email\x20+\x20\x27%\x27)\x20THEN\x20SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201)\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END',_0xe896('0x9a'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x86'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9b'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9c'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9d'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9e'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9f'));_0x4818cd['field'](_0xe896('0xa0'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa1'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa2'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa3'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa4'));_0x4818cd[_0xe896('0x4c')]('i.thirdDisposition');_0x4818cd['field'](_0xe896('0xa5'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa6'));_0x4818cd['field'](_0xe896('0xa7'));_0x4818cd[_0xe896('0x4c')]('i.MailAccountId');_0x4818cd[_0xe896('0x4c')](_0xe896('0xa8'));_0x4818cd['field'](_0xe896('0xa9'),_0xe896('0xaa'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xab'),_0xe896('0xac'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xad'),_0xe896('0xae'));_0x4818cd['field'](_0xe896('0xaf'),_0xe896('0xb0'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xb1'),_0xe896('0xb2'));_0x4818cd['field'](_0xe896('0xb3'),_0xe896('0xb4'));_0x4818cd[_0xe896('0x4c')]('o.fullname',_0xe896('0xb5'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xb6'),_0xe896('0xb7'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xb8'),_0xe896('0x31'));}if(_0x3f158b[_0xe896('0x24')])_0x4818cd[_0xe896('0x24')](_0x3f158b['limit']);if(_0x3f158b[_0xe896('0x23')])_0x4818cd['offset'](_0x3f158b[_0xe896('0x23')]);return db[_0xe896('0x93')][_0xe896('0x3f')](_0x4818cd[_0xe896('0x94')](),_0x5c5c90);})['then'](function(_0x132b50){_0xc6829e[_0xe896('0x49')]('ui.MailInteractionId\x20IN\x20?',_[_0xe896('0x2f')](_0x132b50,'id'));return db[_0xe896('0x93')][_0xe896('0x3f')](_0xc6829e['toString'](),_0x5c5c90)[_0xe896('0x29')](function(_0x5dc2f4){var _0x575983=_[_0xe896('0xb9')](_0x5dc2f4,_0xe896('0xba'));var _0x5c4826=[];return db[_0xe896('0xbb')][_0xe896('0xbc')]({'attributes':['enableEmailPreview'],'raw':!![]})['then'](function(_0x5b4e01){var _0x52d37e=_0x5b4e01[_0xe896('0xbd')];_0x132b50[_0xe896('0x33')](function(_0x69a70d){_0x5c4826[_0xe896('0x34')](updateMailInteraction(_0x69a70d,_0x43bca4,_0x575983,_0x52d37e));});return BPromise[_0xe896('0xbe')](_0x5c4826);});});});})[_0xe896('0x29')](function(_0x315ecc){_0x533173[_0xe896('0xbf')]=_0x315ecc;return _0x533173;})['then'](respondWithFilteredResult(_0x403ff4,_0x3f158b))[_0xe896('0x38')](handleError(_0x403ff4,null));};exports[_0xe896('0xc0')]=function(_0xa952a7,_0x2a1d41){var _0x5a254b={'raw':![],'where':{'id':_0xa952a7[_0xe896('0xc1')]['id']}},_0x4f4d26={};_0x4f4d26[_0xe896('0x3d')]=_['keys'](db['MailInteraction'][_0xe896('0x3b')]);_0x4f4d26[_0xe896('0x3f')]=_[_0xe896('0x3e')](_0xa952a7[_0xe896('0x3f')]);_0x4f4d26[_0xe896('0x40')]=_['intersection'](_0x4f4d26[_0xe896('0x3d')],_0x4f4d26[_0xe896('0x3f')]);_0x5a254b[_0xe896('0x42')]=_['intersection'](_0x4f4d26[_0xe896('0x3d')],qs[_0xe896('0x43')](_0xa952a7[_0xe896('0x3f')][_0xe896('0x43')]));_0x5a254b[_0xe896('0x42')]=_0x5a254b['attributes'][_0xe896('0x44')]?_0x5a254b[_0xe896('0x42')]:_0x4f4d26[_0xe896('0x3d')];if(_0xa952a7['query'][_0xe896('0xc2')]){_0x5a254b['include']=[{'all':!![]}];}_0x5a254b=_[_0xe896('0x96')]({},_0x5a254b,_0xa952a7[_0xe896('0xc3')]);return db[_0xe896('0x3a')][_0xe896('0x5f')](_0x5a254b)[_0xe896('0x29')](handleEntityNotFound(_0x2a1d41,null))[_0xe896('0x29')](respondWithResult(_0x2a1d41,null))['catch'](handleError(_0x2a1d41,null));};exports['create']=function(_0x43fe9a,_0x54c61f){return db[_0xe896('0x3a')][_0xe896('0xc4')](_0x43fe9a['body'],{})[_0xe896('0x29')](respondWithResult(_0x54c61f,0xc9))[_0xe896('0x38')](handleError(_0x54c61f,null));};exports['update']=function(_0x219d8c,_0x4bcd8c){if(_0x219d8c[_0xe896('0xc5')]['id']){delete _0x219d8c[_0xe896('0xc5')]['id'];}return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x219d8c['params']['id']}})[_0xe896('0x29')](handleEntityNotFound(_0x4bcd8c,null))[_0xe896('0x29')](saveUpdates(_0x219d8c[_0xe896('0xc5')],null))[_0xe896('0x29')](respondWithResult(_0x4bcd8c,null))[_0xe896('0x38')](handleError(_0x4bcd8c,null));};exports[_0xe896('0xc6')]=function(_0x15058a,_0x3c8951){return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x15058a[_0xe896('0xc1')]['id']}})[_0xe896('0x29')](handleEntityNotFound(_0x3c8951,null))[_0xe896('0x29')](removeEntity(_0x3c8951,null))[_0xe896('0x38')](handleError(_0x3c8951,null));};exports[_0xe896('0xc7')]=function(_0xc0cb7c,_0x16b398){return db['MailInteraction'][_0xe896('0xc7')]()[_0xe896('0x29')](respondWithResult(_0x16b398,null))['catch'](handleError(_0x16b398,null));};exports['addMessage']=function(_0x32ab46,_0xdd4767,_0x3df01d){return db[_0xe896('0xc8')][_0xe896('0x5f')]({'where':{'id':_0x32ab46[_0xe896('0xc1')]['id']}})[_0xe896('0x29')](handleEntityNotFound(_0xdd4767,null))[_0xe896('0x29')](function(_0x4bc803){if(_0x4bc803){return _0x4bc803[_0xe896('0xc9')](_0x32ab46[_0xe896('0xc5')][_0xe896('0xca')],_[_0xe896('0xcb')](_0x32ab46['body'],[_0xe896('0xca'),'id'])||{});}})['then'](respondWithResult(_0xdd4767,null))['catch'](handleError(_0xdd4767,null));};exports[_0xe896('0xcc')]=function(_0x18a32c,_0x120699,_0x30236c){var _0x3e55b7={'raw':![],'where':{}};var _0x1861c0={};var _0x7561d6={'count':0x0,'rows':[]};return db['MailInteraction'][_0xe896('0xbc')]({'where':{'id':_0x18a32c[_0xe896('0xc1')]['id']}})[_0xe896('0x29')](handleEntityNotFound(_0x120699,null))[_0xe896('0x29')](function(_0xe78476){if(_0xe78476){_0x1861c0[_0xe896('0x3d')]=_[_0xe896('0x3e')](db[_0xe896('0xc8')][_0xe896('0x3b')]);_0x1861c0['query']=_[_0xe896('0x3e')](_0x18a32c[_0xe896('0x3f')]);_0x1861c0['filters']=_[_0xe896('0x41')](_0x1861c0['model'],_0x1861c0['query']);_0x3e55b7[_0xe896('0x42')]=_['intersection'](_0x1861c0['model'],qs[_0xe896('0x43')](_0x18a32c[_0xe896('0x3f')][_0xe896('0x43')]));_0x3e55b7['attributes']=_0x3e55b7[_0xe896('0x42')]['length']?_0x3e55b7[_0xe896('0x42')]:_0x1861c0[_0xe896('0x3d')];if(!_0x18a32c['query'][_0xe896('0x45')](_0xe896('0x46'))){_0x3e55b7['limit']=qs[_0xe896('0x24')](_0x18a32c['query']['limit']);_0x3e55b7['offset']=qs[_0xe896('0x23')](_0x18a32c['query'][_0xe896('0x23')]);}_0x3e55b7[_0xe896('0x47')]=qs[_0xe896('0x48')](_0x18a32c[_0xe896('0x3f')]['sort']);_0x3e55b7[_0xe896('0x49')]=qs[_0xe896('0x40')](_[_0xe896('0x4a')](_0x18a32c[_0xe896('0x3f')],_0x1861c0['filters']));_0x3e55b7[_0xe896('0x49')]['MailInteractionId']=_0xe78476['id'];if(_0x18a32c[_0xe896('0x3f')][_0xe896('0x7f')]){_0x3e55b7[_0xe896('0x49')]=_[_0xe896('0x96')](_0x3e55b7['where'],{'$or':_[_0xe896('0x2f')](_0x3e55b7['attributes'],function(_0x3b65a5){var _0x4e5eca={};_0x4e5eca[_0x3b65a5]={'$like':'%'+_0x18a32c[_0xe896('0x3f')][_0xe896('0x7f')]+'%'};return _0x4e5eca;})});}if(_0x18a32c[_0xe896('0x3f')]['$gte']){var _0x22c54c=_0x18a32c['query'][_0xe896('0xcd')][_0xe896('0x32')](',');var _0x4db104={};_0x4db104[_0x22c54c[0x0]]={'$gte':moment(_0x22c54c[0x1])[_0xe896('0xce')](_0xe896('0xcf'))};_0x3e55b7['where']=_[_0xe896('0x96')](_0x3e55b7[_0xe896('0x49')],_0x4db104);}_0x3e55b7=_[_0xe896('0x96')]({},_0x3e55b7,_0x18a32c[_0xe896('0xc3')]);return db[_0xe896('0xc8')][_0xe896('0x22')]({'where':_0x3e55b7[_0xe896('0x49')]})[_0xe896('0x29')](function(_0x46b7d2){_0x7561d6['count']=_0x46b7d2;if(_0x18a32c['query'][_0xe896('0xc2')]){_0x3e55b7[_0xe896('0xd0')]=[{'all':!![]}];}return db['MailMessage'][_0xe896('0xd1')](_0x3e55b7);})[_0xe896('0x29')](function(_0x4b5af4){if(_0x18a32c['query'][_0xe896('0xd2')]===_0xe896('0xd3')){for(var _0x5577f9=0x0;_0x5577f9<_0x4b5af4[_0xe896('0x44')];_0x5577f9++){_0x4b5af4[_0x5577f9][_0xe896('0xc5')]=juice(_0x4b5af4[_0x5577f9]['body']);}}_0x7561d6[_0xe896('0xbf')]=_0x4b5af4;return _0x7561d6;});}})[_0xe896('0x29')](respondWithFilteredResult(_0x120699,_0x3e55b7))[_0xe896('0x38')](handleError(_0x120699,null));};exports['addTags']=function(_0x3c9e8e,_0x40bdca,_0x569a12){return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x3c9e8e[_0xe896('0xc1')]['id']}})[_0xe896('0x29')](handleEntityNotFound(_0x40bdca,null))[_0xe896('0x29')](function(_0x90a856){if(_0x90a856){return _0x90a856[_0xe896('0xd4')](_0x3c9e8e[_0xe896('0xc5')][_0xe896('0xca')],_[_0xe896('0xcb')](_0x3c9e8e[_0xe896('0xc5')],[_0xe896('0xca'),'id'])||{})[_0xe896('0xd5')](function(){return db[_0xe896('0x6d')]['findAll']({'attributes':['id',_0xe896('0x2d'),'color'],'where':{'id':_0x3c9e8e[_0xe896('0xc5')][_0xe896('0xca')]}});})['then'](function(_0x3ac2d5){socket[_0xe896('0xd6')](_0xe896('0xd7'),{'id':Number(_0x3c9e8e['params']['id']),'tags':_0x3ac2d5||[]});return{'id':Number(_0x3c9e8e[_0xe896('0xc1')]['id']),'tags':_0x3ac2d5||[]};});}})[_0xe896('0x29')](respondWithResult(_0x40bdca,null))[_0xe896('0x38')](handleError(_0x40bdca,null));};exports[_0xe896('0xd8')]=function(_0x42652e,_0xad4b50,_0x28b26d){return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x42652e['params']['id']}})['then'](handleEntityNotFound(_0xad4b50,null))['then'](function(_0x4260ca){if(_0x4260ca){return _0x4260ca['removeTags'](_0x42652e['query'][_0xe896('0xca')]);}})['then'](respondWithStatusCode(_0xad4b50,null))['catch'](handleError(_0xad4b50,null));};exports['download']=function(_0x348cd5,_0x4a5f7f){var _0x4a52c6=moment()[_0xe896('0xd9')]()[_0xe896('0x94')]();var _0x29cf8c=path['join'](config[_0xe896('0xda')],_0xe896('0xdb'),_0xe896('0xdc'),_0xe896('0xdd'));var _0x14fd54=path['join'](config['root'],_0xe896('0xdb'),_0xe896('0xdc'),'attachments');var _0x21b078=path[_0xe896('0xde')](_0x29cf8c,_0x4a52c6);var _0x71d912=util[_0xe896('0xce')](_0xe896('0xdf'),_0x348cd5[_0xe896('0xc1')]['id'],_0x4a52c6);var _0x554b57=path[_0xe896('0xde')](_0x29cf8c,_0x71d912);var _0x2f9697=[];if(_0x348cd5[_0xe896('0x3f')][_0xe896('0xe0')]){_0x2f9697[_0xe896('0x34')]({'model':db[_0xe896('0xe1')],'as':'Attachments','raw':!![]});}var _0x3eaa77=[{'model':db[_0xe896('0xc8')],'as':'Messages','attributes':['id',_0xe896('0xc5'),_0xe896('0x4e'),'to','cc',_0xe896('0xe2'),_0xe896('0xe3'),_0xe896('0xe4')],'where':{'secret':![]},'order':qs[_0xe896('0x48')]('id'),'include':_0x2f9697}];return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x348cd5[_0xe896('0xc1')]['id']},'include':_0x3eaa77})[_0xe896('0x29')](handleEntityNotFound(_0x4a5f7f,null))['then'](function(_0x47315b){if(_0x47315b&&_0x47315b['Messages']){var _0xdbb639=_0x47315b[_0xe896('0xe5')]({'plain':!![]});fs[_0xe896('0xe6')](_0x21b078);return BPromise[_0xe896('0xe7')](_0xdbb639[_0xe896('0xe8')],function(_0x43f8a9,_0x274e7f){var _0x6e53ae={'from':_0x43f8a9['from'],'to':_0x43f8a9['to'],'subject':_0x43f8a9[_0xe896('0xe3')],'html':_0x43f8a9[_0xe896('0xc5')],'headers':{'Date':moment(_0x43f8a9[_0xe896('0xe4')])[_0xe896('0xce')](_0xe896('0xe9'))},'attachments':[]};if(_0x43f8a9['cc']){_0x6e53ae[_0xe896('0xea')]['Cc']=_0x43f8a9['cc'];}if(_0x43f8a9[_0xe896('0xe2')]){_0x6e53ae[_0xe896('0xea')]['Bcc']=_0x43f8a9[_0xe896('0xe2')];}return new BPromise(function(_0x2d9eae,_0x27743a){if(_0x43f8a9['Attachments']){for(var _0x52f6d6=0x0;_0x52f6d6<_0x43f8a9[_0xe896('0xeb')][_0xe896('0x44')];_0x52f6d6++){var _0x37cd92=_0x43f8a9['Attachments'][_0x52f6d6];var _0x52a5b9=path[_0xe896('0xde')](_0x14fd54,_0x37cd92[_0xe896('0xec')]);if(fs['existsSync'](_0x52a5b9)){_0x6e53ae[_0xe896('0xe0')][_0xe896('0x34')]({'name':_0x37cd92[_0xe896('0x2d')],'contentType':_0x37cd92[_0xe896('0x70')],'data':fs[_0xe896('0xed')](_0x52a5b9)});}}}emlformat[_0xe896('0xee')](_0x6e53ae,function(_0x4d31dc,_0x272bc8){if(_0x4d31dc)return _0x27743a(_0x4d31dc);fs[_0xe896('0xef')](path['join'](_0x21b078,util[_0xe896('0xce')](_0xe896('0xf0'),_0x274e7f)),_0x272bc8);return _0x2d9eae(_0x272bc8);});});})['then'](function(){return new BPromise(function(_0x5c5b99,_0x4bc513){zipdir(_0x21b078,{'saveTo':_0x554b57},function(_0x4d3ca3,_0x2973b8){if(_0x4d3ca3)return _0x4bc513(_0x4d3ca3);return _0x5c5b99(_0x2973b8);});})[_0xe896('0x29')](function(){return new BPromise(function(_0x26bd9b,_0x27fd0e){rimraf(_0x21b078,function(_0x393021){if(_0x393021)_0x27fd0e(_0x393021);return _0x26bd9b();});});})[_0xe896('0x29')](function(){return _0x4a5f7f['download'](_0x554b57,_0x71d912,function(_0x135de9){if(_0x135de9){console['log'](_0xe896('0xf1'),_0x135de9);}else{fs['unlinkSync'](_0x554b57);}});});});}else{return _0x4a5f7f[_0xe896('0x2b')](0xc8);}})[_0xe896('0x38')](handleError(_0x4a5f7f,null));};
\ No newline at end of file
+var _0x0e6f=['MailInteraction','rawAttributes','fieldName','type','key','query','keys','filters','attributes','intersection','model','fields','length','nolimit','order','sort','where','pick','field','color','from','tools_tags','select','u.id','u.fullname','user_has_mail_interactions','users','u.id\x20=\x20ui.UserId','mail_interactions','left_join','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','mail_messages','me.MailInteractionId\x20=\x20i.id','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','ContactId','buildExpression','text','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','find','UserId','start','compact','isEmpty','i.MailAccountId\x20IN\x20?','concat','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','replace','i.id\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','Sequelize','QueryTypes','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','DESC','t.id\x20IN\x20?','i.MailAccountId\x20IS\x20NOT\x20NULL','role','agent','user','getMailAccounts','i.MailAccountId\x20IS\x20NULL','sequelize','toString','merge','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20(\x27%\x27\x20+\x20a.email\x20+\x20\x27%\x27)\x20THEN\x20SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201)\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.subject','i.disposition','i.secondDisposition','i.thirdDisposition','i.substatus','i.to','i.ContactId','i.MailAccountId','c.firstName','Contact.firstName','Contact.lastName','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','enableEmailPreview','all','catch','params','include','options','body','describe','addMessage','MailMessage','omit','ids','getMessages','hasOwnProperty','MailInteractionId','filter','format','YYYY-MM-DD\x20HH:mm:ss','includeAll','findAll','inlineCss','true','rows','addTags','spread','Tag','emit','mailInteractionTags:save','removeTags','unix','root','server','join','files','attachments','transcript-%d-%s.zip','Attachment','Messages','subject','createdAt','mkdirSync','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','bcc','Attachments','basename','existsSync','push','message%d.eml','download','log','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','querystring','papaparse','html-to-text','juice','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','register','end','status','json','offset','limit','undefined','count','set','apply','update','then','destroy','sendStatus','stack','name','Users','map','fullname','TagIds','Tags','split','forEach','findOne','plainBody','-id','lastMsgText'];(function(_0x216915,_0x20a816){var _0x5e1847=function(_0x3fd71f){while(--_0x3fd71f){_0x216915['push'](_0x216915['shift']());}};_0x5e1847(++_0x20a816);}(_0x0e6f,0x1b3));var _0xf0e6=function(_0x313df3,_0x4fca45){_0x313df3=_0x313df3-0x0;var _0x241d59=_0x0e6f[_0x313df3];return _0x241d59;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xf0e6('0x0'));var jsonpatch=require(_0xf0e6('0x1'));var rp=require(_0xf0e6('0x2'));var moment=require(_0xf0e6('0x3'));var BPromise=require(_0xf0e6('0x4'));var Mustache=require(_0xf0e6('0x5'));var util=require(_0xf0e6('0x6'));var path=require('path');var sox=require(_0xf0e6('0x7'));var csv=require(_0xf0e6('0x8'));var ejs=require(_0xf0e6('0x9'));var fs=require('fs');var fs_extra=require(_0xf0e6('0xa'));var _=require('lodash');var squel=require(_0xf0e6('0xb'));var crypto=require(_0xf0e6('0xc'));var jsforce=require(_0xf0e6('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xf0e6('0x8'));var querystring=require(_0xf0e6('0xe'));var Papa=require(_0xf0e6('0xf'));var htmlToText=require(_0xf0e6('0x10'));var juice=require(_0xf0e6('0x11'));var Redis=require(_0xf0e6('0x12'));var authService=require(_0xf0e6('0x13'));var qs=require(_0xf0e6('0x14'));var as=require(_0xf0e6('0x15'));var hardwareService=require(_0xf0e6('0x16'));var logger=require(_0xf0e6('0x17'))(_0xf0e6('0x18'));var utils=require(_0xf0e6('0x19'));var config=require(_0xf0e6('0x1a'));var licenseUtil=require(_0xf0e6('0x1b'));var db=require(_0xf0e6('0x1c'))['db'];config[_0xf0e6('0x1d')]=_[_0xf0e6('0x1e')](config[_0xf0e6('0x1d')],{'host':_0xf0e6('0x1f'),'port':0x18eb});var socket=require(_0xf0e6('0x20'))(new Redis(config['redis']));require(_0xf0e6('0x21'))[_0xf0e6('0x22')](socket);function respondWithStatusCode(_0xa13000,_0x586d2e){_0x586d2e=_0x586d2e||0xcc;return function(_0x92275f){if(_0x92275f){return _0xa13000['sendStatus'](_0x586d2e);}return _0xa13000['status'](_0x586d2e)[_0xf0e6('0x23')]();};}function respondWithResult(_0x326bbe,_0x1d5cc5){_0x1d5cc5=_0x1d5cc5||0xc8;return function(_0x21b8b5){if(_0x21b8b5){return _0x326bbe[_0xf0e6('0x24')](_0x1d5cc5)[_0xf0e6('0x25')](_0x21b8b5);}};}function respondWithFilteredResult(_0x183097,_0x4a042e){return function(_0x3cc2bf){if(_0x3cc2bf){var _0x5170ed=typeof _0x4a042e[_0xf0e6('0x26')]==='undefined'&&typeof _0x4a042e[_0xf0e6('0x27')]===_0xf0e6('0x28');var _0x2e388c=_0x3cc2bf['count'];var _0x27e77f=_0x5170ed?0x0:_0x4a042e['offset'];var _0xdbf2c2=_0x5170ed?_0x3cc2bf[_0xf0e6('0x29')]:_0x4a042e[_0xf0e6('0x26')]+_0x4a042e[_0xf0e6('0x27')];var _0x3623b2;if(_0xdbf2c2>=_0x2e388c){_0xdbf2c2=_0x2e388c;_0x3623b2=0xc8;}else{_0x3623b2=0xce;}_0x183097['status'](_0x3623b2);return _0x183097[_0xf0e6('0x2a')]('Content-Range',_0x27e77f+'-'+_0xdbf2c2+'/'+_0x2e388c)[_0xf0e6('0x25')](_0x3cc2bf);}return null;};}function patchUpdates(_0xdc6afc){return function(_0x13f69d){try{jsonpatch[_0xf0e6('0x2b')](_0x13f69d,_0xdc6afc,!![]);}catch(_0x54668c){return BPromise['reject'](_0x54668c);}return _0x13f69d['save']();};}function saveUpdates(_0x467fe8,_0x33bab5){return function(_0x4bf1d6){if(_0x4bf1d6){return _0x4bf1d6[_0xf0e6('0x2c')](_0x467fe8)[_0xf0e6('0x2d')](function(_0x1eae3d){return _0x1eae3d;});}return null;};}function removeEntity(_0x297c75,_0x2901f2){return function(_0x391189){if(_0x391189){return _0x391189[_0xf0e6('0x2e')]()[_0xf0e6('0x2d')](function(){_0x297c75[_0xf0e6('0x24')](0xcc)[_0xf0e6('0x23')]();});}};}function handleEntityNotFound(_0xbbee9a,_0x5d61d6){return function(_0x5ea97d){if(!_0x5ea97d){_0xbbee9a[_0xf0e6('0x2f')](0x194);}return _0x5ea97d;};}function handleError(_0x348d0e,_0x2ea95a){_0x2ea95a=_0x2ea95a||0x1f4;return function(_0x1cb02a){logger['error'](_0x1cb02a[_0xf0e6('0x30')]);if(_0x1cb02a[_0xf0e6('0x31')]){delete _0x1cb02a[_0xf0e6('0x31')];}_0x348d0e[_0xf0e6('0x24')](_0x2ea95a)['send'](_0x1cb02a);};}function getInteractionUsers(_0x3c6adf,_0x247d81){return new BPromise(function(_0x52f9e7,_0x2b9645){try{if(_0x247d81[_0x3c6adf['id']]){_0x3c6adf[_0xf0e6('0x32')]=_[_0xf0e6('0x33')](_0x247d81[_0x3c6adf['id']],function(_0x17e190){return{'id':_0x17e190['id'],'fullname':_0x17e190[_0xf0e6('0x34')]};});}}catch(_0x397c8c){_0x2b9645(_0x397c8c);}_0x52f9e7(_0x3c6adf);});}function getInteractionTags(_0x2c582d,_0x5e44fd){return new BPromise(function(_0xd932e5,_0x57e85b){try{if(_0x2c582d[_0xf0e6('0x35')]){_0x2c582d[_0xf0e6('0x36')]=[];_0x2c582d[_0xf0e6('0x35')][_0xf0e6('0x37')](',')[_0xf0e6('0x38')](function(_0x469104){_0x2c582d['Tags']['push'](_0x5e44fd[_0x469104]);});}delete _0x2c582d[_0xf0e6('0x35')];}catch(_0xc2b0cf){_0x57e85b(_0xc2b0cf);}_0xd932e5(_0x2c582d);});}function getLastMessageText(_0x5e7c7b){return new BPromise(function(_0x5cd4f7,_0x21d136){return db['MailMessage'][_0xf0e6('0x39')]({'where':{'$and':[{'MailInteractionId':_0x5e7c7b['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':'out'},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0xf0e6('0x3a')],'order':_0xf0e6('0x3b'),'raw':!![]})[_0xf0e6('0x2d')](function(_0x5d08b8){if(_0x5d08b8&&_0x5d08b8[_0xf0e6('0x3a')]){_0x5e7c7b[_0xf0e6('0x3c')]=_['trimStart'](_0x5d08b8[_0xf0e6('0x3a')]);}_0x5cd4f7(_0x5e7c7b);})['catch'](function(_0x144578){_0x21d136(_0x144578);});});}function updateMailInteraction(_0x52daab,_0x2e6649,_0x1a8f3c,_0x54ef1a){return new BPromise(function(_0x44cf75,_0x273339){return getInteractionUsers(_0x52daab,_0x1a8f3c)[_0xf0e6('0x2d')](function(_0x3369e7){return getInteractionTags(_0x3369e7,_0x2e6649);})[_0xf0e6('0x2d')](function(_0x8b3a30){if(_0x54ef1a){_0x44cf75(getLastMessageText(_0x8b3a30));}else{_0x44cf75(_0x8b3a30);}})['catch'](function(_0x242a71){_0x273339(_0x242a71);});});}exports['index']=function(_0x186243,_0x584493){var _0xf75877={},_0x1140e9={},_0xeb984={'count':0x0,'rows':[]};var _0x4f85e7=_[_0xf0e6('0x33')](db[_0xf0e6('0x3d')][_0xf0e6('0x3e')],function(_0x3ebb20){return{'name':_0x3ebb20[_0xf0e6('0x3f')],'type':_0x3ebb20[_0xf0e6('0x40')][_0xf0e6('0x41')]};});_0x1140e9['model']=_[_0xf0e6('0x33')](_0x4f85e7,_0xf0e6('0x31'));_0x1140e9[_0xf0e6('0x42')]=_[_0xf0e6('0x43')](_0x186243['query']);_0x1140e9[_0xf0e6('0x44')]=_['intersection'](_0x1140e9['model'],_0x1140e9[_0xf0e6('0x42')]);_0xf75877[_0xf0e6('0x45')]=_[_0xf0e6('0x46')](_0x1140e9[_0xf0e6('0x47')],qs[_0xf0e6('0x48')](_0x186243[_0xf0e6('0x42')]['fields']));_0xf75877[_0xf0e6('0x45')]=_0xf75877[_0xf0e6('0x45')][_0xf0e6('0x49')]?_0xf75877[_0xf0e6('0x45')]:_0x1140e9[_0xf0e6('0x47')];if(!_0x186243['query']['hasOwnProperty'](_0xf0e6('0x4a'))){_0xf75877[_0xf0e6('0x27')]=qs['limit'](_0x186243['query']['limit']);_0xf75877[_0xf0e6('0x26')]=qs[_0xf0e6('0x26')](_0x186243[_0xf0e6('0x42')][_0xf0e6('0x26')]);}_0xf75877[_0xf0e6('0x4b')]=qs[_0xf0e6('0x4c')](_0x186243[_0xf0e6('0x42')][_0xf0e6('0x4c')]);_0xf75877[_0xf0e6('0x4d')]=qs['filters'](_[_0xf0e6('0x4e')](_0x186243[_0xf0e6('0x42')],_0x1140e9[_0xf0e6('0x44')]),_0x4f85e7);var _0x1a5c3c=[];var _0x446773=squel['select']()[_0xf0e6('0x4f')]('id')[_0xf0e6('0x4f')](_0xf0e6('0x31'))['field'](_0xf0e6('0x50'))[_0xf0e6('0x51')](_0xf0e6('0x52'));var _0x5bd54a=squel[_0xf0e6('0x53')]()[_0xf0e6('0x4f')](_0xf0e6('0x54'))['field'](_0xf0e6('0x55'))[_0xf0e6('0x4f')]('ui.MailInteractionId')[_0xf0e6('0x51')](_0xf0e6('0x56'),'ui')['left_join'](_0xf0e6('0x57'),'u',_0xf0e6('0x58'));var _0x3c5ffe=squel['select']()['from'](_0xf0e6('0x59'),'i')[_0xf0e6('0x5a')](_0xf0e6('0x5b'),'c',_0xf0e6('0x5c'))['left_join']('users','o',_0xf0e6('0x5d'))[_0xf0e6('0x5a')](_0xf0e6('0x5e'),'a','a.id\x20=\x20i.MailAccountId')[_0xf0e6('0x5a')](_0xf0e6('0x5f'),'me',_0xf0e6('0x60'))['left_join'](_0xf0e6('0x61'),'it',_0xf0e6('0x62'))[_0xf0e6('0x5a')](_0xf0e6('0x52'),'t',_0xf0e6('0x63'));var _0x1f210b=squel[_0xf0e6('0x64')]();var _0x4c81ea=[];var _0x4fd74d=squel[_0xf0e6('0x64')]();var _0x1c97e9;if(_0x186243[_0xf0e6('0x42')][_0xf0e6('0x65')]){_0x1c97e9=as[_0xf0e6('0x66')](_0x186243['query'][_0xf0e6('0x65')]);var _0x5e15a3=_0x1c97e9[_0xf0e6('0x67')];for(var _0x580002=0x0;_0x580002<_0x1c97e9[_0xf0e6('0x68')]['length'];_0x580002++){var _0x339b96=_0x1c97e9[_0xf0e6('0x68')][_0x580002];var _0xe8c0='i';var _0x1f9e12=_['find'](_0x4f85e7,[_0xf0e6('0x31'),_0x339b96['field']]);if(!_0x1f9e12){switch(_0x339b96['field']){case _0xf0e6('0x69'):if(_0x339b96[_0xf0e6('0x6a')]==0x1){_0x3c5ffe[_0xf0e6('0x6b')]('`'+_0x339b96['field']+_0xf0e6('0x6c'));}else{_0x3c5ffe[_0xf0e6('0x6b')]('`'+_0x339b96[_0xf0e6('0x4f')]+_0xf0e6('0x6d'));}break;case _0xf0e6('0x6e'):if(_0x339b96[_0xf0e6('0x6f')]===_0xf0e6('0x70')){if(_0x339b96[_0xf0e6('0x6a')][_0xf0e6('0x37')]('\x20')[_0xf0e6('0x49')]>0x1){_0x1f210b[_0x5e15a3](_0xf0e6('0x71'),qs[_0xf0e6('0x72')](_0x339b96[_0xf0e6('0x6a')]),null);}else{var _0x522807='%'+_0x339b96['value']+'%';_0x1f210b[_0x5e15a3]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x522807,_0x522807,_0x522807);}}else{_0x1f9e12=_['find'](_0x4f85e7,[_0xf0e6('0x31'),_0xf0e6('0x73')]);_0x339b96[_0xf0e6('0x4f')]=_0xf0e6('0x73');_0x543a9c=as[_0xf0e6('0x74')](_0xe8c0,_0x1f9e12['type'],_0x339b96);_0x1f210b[_0x5e15a3](_0x543a9c[_0xf0e6('0x75')],_0x543a9c[_0xf0e6('0x6a')]['start'],_0x543a9c[_0xf0e6('0x6a')]['end']);}break;case'Tag':var _0x490fb2=_0x339b96[_0xf0e6('0x6a')][_0xf0e6('0x37')](',')[_0xf0e6('0x33')](function(_0x3db403){return Number(_0x3db403);});_0x490fb2['forEach'](function(_0x23586e){_0x4fd74d['or'](_0xf0e6('0x76'),'%,'+_0x23586e+',%');});_0x4c81ea=_[_0xf0e6('0x77')](_0x4c81ea,_0x490fb2);break;case _0xf0e6('0x78'):if(_0x339b96[_0xf0e6('0x6f')]===_0xf0e6('0x70')){_0x1f210b[_0x5e15a3](_0xf0e6('0x79'),'%'+_0x339b96[_0xf0e6('0x6a')]+'%',null);}else{_0x1f9e12=_[_0xf0e6('0x7a')](_0x4f85e7,[_0xf0e6('0x31'),_0xf0e6('0x7b')]);_0x339b96[_0xf0e6('0x4f')]=_0xf0e6('0x7b');_0x543a9c=as[_0xf0e6('0x74')](_0xe8c0,_0x1f9e12[_0xf0e6('0x40')],_0x339b96);_0x1f210b[_0x5e15a3](_0x543a9c[_0xf0e6('0x75')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x7c')],_0x543a9c['value'][_0xf0e6('0x23')]);}break;case _0xf0e6('0x3a'):_0x543a9c=as['buildExpression']('me',null,_0x339b96);_0x1f210b[_0x5e15a3](_0x543a9c[_0xf0e6('0x75')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x7c')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x23')]);break;}}else{var _0x543a9c=as[_0xf0e6('0x74')](_0xe8c0,_0x1f9e12[_0xf0e6('0x40')],_0x339b96);_0x1f210b[_0x5e15a3](_0x543a9c[_0xf0e6('0x75')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x7c')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x23')]);}}}else{var _0x41f490=_(_0x186243[_0xf0e6('0x42')])[_0xf0e6('0x43')]()[_0xf0e6('0x33')](function(_0x4053bf){return _['some'](_0x4f85e7,[_0xf0e6('0x31'),_0x4053bf])?_0x4053bf:undefined;})[_0xf0e6('0x7d')]()[_0xf0e6('0x6a')]();if(!_[_0xf0e6('0x7e')](_0x41f490)){_0x41f490[_0xf0e6('0x38')](function(_0x5e43e5){if(_0x5e43e5==='MailAccountId'){_0x3c5ffe['where'](_0xf0e6('0x7f'),[][_0xf0e6('0x80')](_0x186243['query'][_0x5e43e5]));}else if(_0x5e43e5==='createdAt'){var _0x25ccb5=JSON[_0xf0e6('0x81')](_0x186243[_0xf0e6('0x42')][_0x5e43e5])[_0xf0e6('0x82')];var _0x4da613=JSON[_0xf0e6('0x81')](_0x186243[_0xf0e6('0x42')][_0x5e43e5])[_0xf0e6('0x83')];_0x3c5ffe[_0xf0e6('0x4d')](_0xf0e6('0x84'),_0x25ccb5,_0x4da613);}else{if(_0x186243[_0xf0e6('0x42')][_0x5e43e5]===_0xf0e6('0x85')){_0x3c5ffe[_0xf0e6('0x4d')]('i.'+_0x5e43e5+'\x20IS\x20NULL');}else{_0x3c5ffe[_0xf0e6('0x4d')]('i.'+_0x5e43e5+_0xf0e6('0x86'),_0x186243[_0xf0e6('0x42')][_0x5e43e5]);}}});}if(_0x186243[_0xf0e6('0x42')][_0xf0e6('0x87')]){if(_0x186243[_0xf0e6('0x42')][_0xf0e6('0x87')]==0x1){_0x3c5ffe[_0xf0e6('0x6b')](_0xf0e6('0x88'));}else{_0x3c5ffe[_0xf0e6('0x6b')](_0xf0e6('0x89'));}}if(_0x186243['query'][_0xf0e6('0x8a')]){_0x4c81ea=_[_0xf0e6('0x8b')](_0x186243[_0xf0e6('0x42')][_0xf0e6('0x8a')])?_0x186243[_0xf0e6('0x42')][_0xf0e6('0x8a')]:new Array(_0x186243['query'][_0xf0e6('0x8a')]);_0x4c81ea[_0xf0e6('0x38')](function(_0x4c8f6b){_0x4fd74d['or'](_0xf0e6('0x76'),'%,'+_0x4c8f6b+',%');});}if(_0x186243[_0xf0e6('0x42')]['filter']){var _0x1648de=_0x186243[_0xf0e6('0x42')]['filter'][_0xf0e6('0x8c')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs['isNumeric'](_0x1648de)){_0x1f210b['or'](_0xf0e6('0x8d'),_0x1648de+'%');}else if(qs[_0xf0e6('0x8e')](_0x1648de)){_0x1f210b['or'](_0xf0e6('0x8f'),_0x1648de+'%');}else{_0x1f210b['or'](_0xf0e6('0x90'),qs[_0xf0e6('0x72')](_0x1648de))['or'](_0xf0e6('0x91'),qs[_0xf0e6('0x72')](_0x1648de));}}}_0x3c5ffe[_0xf0e6('0x4d')](_0x1f210b);_0x3c5ffe[_0xf0e6('0x92')](_0xf0e6('0x93'));var _0x4cf681={'type':db[_0xf0e6('0x94')][_0xf0e6('0x95')]['SELECT'],'raw':!![]};var _0x48aed2=_0x3c5ffe[_0xf0e6('0x96')]();_0x48aed2[_0xf0e6('0x4f')](_0xf0e6('0x93'));_0x48aed2['field'](_0xf0e6('0x97'),_0xf0e6('0x69'));if(_0xf75877[_0xf0e6('0x4b')]){_0xf75877['order'][_0xf0e6('0x38')](function(_0x5a4284){var _0xe90cac=_0x5a4284[0x0]==='contactName'?_0x5a4284[0x0]:'i.'+_0x5a4284[0x0];_0x3c5ffe[_0xf0e6('0x4b')](_0xe90cac,_0x5a4284[0x1]===_0xf0e6('0x98')?![]:!![]);});}if(!_[_0xf0e6('0x7e')](_0x4c81ea)){_0x3c5ffe[_0xf0e6('0x6b')](_0x4fd74d);_0x48aed2['where'](_0xf0e6('0x99'),_0x4c81ea);}BPromise['resolve']()['then'](function(){if(!_0x1c97e9){if(_0x186243['query']['MailAccountId'])return;_0x48aed2[_0xf0e6('0x4d')](_0xf0e6('0x9a'));_0x3c5ffe['where'](_0xf0e6('0x9a'));return;}if(_0x186243['user'][_0xf0e6('0x9b')]!==_0xf0e6('0x9c'))return;return _0x186243[_0xf0e6('0x9d')][_0xf0e6('0x9e')]({'attributes':['id'],'raw':!![]})[_0xf0e6('0x2d')](function(_0x5d1085){if(_[_0xf0e6('0x7e')](_0x5d1085)){_0x48aed2[_0xf0e6('0x4d')](_0xf0e6('0x9f'));_0x3c5ffe['where'](_0xf0e6('0x9f'));}else{_0x48aed2[_0xf0e6('0x4d')](_0xf0e6('0x7f'),_['map'](_0x5d1085,'id'));_0x3c5ffe['where'](_0xf0e6('0x7f'),_['map'](_0x5d1085,'id'));}});})['then'](function(){if(_0x186243[_0xf0e6('0x9d')]['role']==='agent'&&!_0x1c97e9&&!_0x186243[_0xf0e6('0x42')]['MailAccountId'])return[];return db[_0xf0e6('0xa0')][_0xf0e6('0x42')](_0x48aed2['toString'](),_0x4cf681);})['then'](function(_0x1efaa6){_0xeb984[_0xf0e6('0x29')]=_0x1efaa6[_0xf0e6('0x49')];if(_0xeb984[_0xf0e6('0x29')]===0x0)return[];return db[_0xf0e6('0xa0')][_0xf0e6('0x42')](_0x446773[_0xf0e6('0xa1')](),_0x4cf681)[_0xf0e6('0x2d')](function(_0x43c503){_0x1a5c3c=_['keyBy'](_0x43c503,'id');_0x4cf681=_[_0xf0e6('0xa2')](_0x4cf681,{'model':db['MailInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x186243[_0xf0e6('0x42')][_0xf0e6('0x48')]){_0xf75877[_0xf0e6('0x45')][_0xf0e6('0x38')](function(_0x256e18){_0x3c5ffe[_0xf0e6('0x4f')]('i.'+_0x256e18);});}else{_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0x97'),'unreadMessages');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xa3'),_0xf0e6('0xa4'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xa5'),_0xf0e6('0xa6'));_0x3c5ffe['field'](_0xf0e6('0xa7'),_0xf0e6('0xa8'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0x93'));_0x3c5ffe['field']('i.createdAt');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xa9'));_0x3c5ffe['field'](_0xf0e6('0xaa'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xab'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xac'));_0x3c5ffe['field'](_0xf0e6('0xad'));_0x3c5ffe[_0xf0e6('0x4f')]('i.lastMsgDirection');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xae'));_0x3c5ffe['field'](_0xf0e6('0xaf'));_0x3c5ffe['field'](_0xf0e6('0xb0'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb1'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb2'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb3'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb4'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb5'));_0x3c5ffe[_0xf0e6('0x4f')]('i.UserId');_0x3c5ffe['field'](_0xf0e6('0xb6'),_0xf0e6('0xb7'));_0x3c5ffe['field']('c.lastName',_0xf0e6('0xb8'));_0x3c5ffe['field']('c.email','Contact.email');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb9'),_0xf0e6('0xba'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xbb'),_0xf0e6('0xbc'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xbd'),_0xf0e6('0xbe'));_0x3c5ffe['field'](_0xf0e6('0xbf'),'Owner.fullname');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xc0'),'Owner.internal');_0x3c5ffe['field'](_0xf0e6('0xc1'),_0xf0e6('0x35'));}if(_0xf75877[_0xf0e6('0x27')])_0x3c5ffe[_0xf0e6('0x27')](_0xf75877[_0xf0e6('0x27')]);if(_0xf75877['offset'])_0x3c5ffe[_0xf0e6('0x26')](_0xf75877[_0xf0e6('0x26')]);return db[_0xf0e6('0xa0')][_0xf0e6('0x42')](_0x3c5ffe[_0xf0e6('0xa1')](),_0x4cf681);})['then'](function(_0x2570f8){if(_0x2570f8['length']>0x0)_0x5bd54a['where'](_0xf0e6('0xc2'),_[_0xf0e6('0x33')](_0x2570f8,'id'));return db[_0xf0e6('0xa0')][_0xf0e6('0x42')](_0x5bd54a[_0xf0e6('0xa1')](),_0x4cf681)['then'](function(_0x5c15ef){var _0x2624cd=_[_0xf0e6('0xc3')](_0x5c15ef,'MailInteractionId');var _0x2c8554=[];return db['Setting'][_0xf0e6('0x39')]({'attributes':[_0xf0e6('0xc4')],'raw':!![]})[_0xf0e6('0x2d')](function(_0x5c097e){var _0x5bcac2=_0x5c097e[_0xf0e6('0xc4')];_0x2570f8['forEach'](function(_0xd9a66d){_0x2c8554['push'](updateMailInteraction(_0xd9a66d,_0x1a5c3c,_0x2624cd,_0x5bcac2));});return BPromise[_0xf0e6('0xc5')](_0x2c8554);});});});})['then'](function(_0x9e463d){_0xeb984['rows']=_0x9e463d;return _0xeb984;})[_0xf0e6('0x2d')](respondWithFilteredResult(_0x584493,_0xf75877))[_0xf0e6('0xc6')](handleError(_0x584493,null));};exports['show']=function(_0x16b0c7,_0xa41166){var _0x4977bf={'raw':![],'where':{'id':_0x16b0c7[_0xf0e6('0xc7')]['id']}},_0x159b9b={};_0x159b9b[_0xf0e6('0x47')]=_[_0xf0e6('0x43')](db[_0xf0e6('0x3d')][_0xf0e6('0x3e')]);_0x159b9b[_0xf0e6('0x42')]=_['keys'](_0x16b0c7[_0xf0e6('0x42')]);_0x159b9b['filters']=_[_0xf0e6('0x46')](_0x159b9b[_0xf0e6('0x47')],_0x159b9b['query']);_0x4977bf[_0xf0e6('0x45')]=_[_0xf0e6('0x46')](_0x159b9b[_0xf0e6('0x47')],qs['fields'](_0x16b0c7[_0xf0e6('0x42')][_0xf0e6('0x48')]));_0x4977bf['attributes']=_0x4977bf[_0xf0e6('0x45')]['length']?_0x4977bf[_0xf0e6('0x45')]:_0x159b9b[_0xf0e6('0x47')];if(_0x16b0c7[_0xf0e6('0x42')]['includeAll']){_0x4977bf[_0xf0e6('0xc8')]=[{'all':!![]}];}_0x4977bf=_[_0xf0e6('0xa2')]({},_0x4977bf,_0x16b0c7[_0xf0e6('0xc9')]);return db['MailInteraction'][_0xf0e6('0x7a')](_0x4977bf)['then'](handleEntityNotFound(_0xa41166,null))[_0xf0e6('0x2d')](respondWithResult(_0xa41166,null))[_0xf0e6('0xc6')](handleError(_0xa41166,null));};exports['create']=function(_0x5994f5,_0x3fabf9){return db[_0xf0e6('0x3d')]['create'](_0x5994f5[_0xf0e6('0xca')],{})['then'](respondWithResult(_0x3fabf9,0xc9))['catch'](handleError(_0x3fabf9,null));};exports[_0xf0e6('0x2c')]=function(_0x4113a5,_0x1f23f2){if(_0x4113a5['body']['id']){delete _0x4113a5['body']['id'];}return db[_0xf0e6('0x3d')][_0xf0e6('0x7a')]({'where':{'id':_0x4113a5[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x1f23f2,null))[_0xf0e6('0x2d')](saveUpdates(_0x4113a5[_0xf0e6('0xca')],null))[_0xf0e6('0x2d')](respondWithResult(_0x1f23f2,null))[_0xf0e6('0xc6')](handleError(_0x1f23f2,null));};exports[_0xf0e6('0x2e')]=function(_0x4c8212,_0x4a5fbd){return db['MailInteraction'][_0xf0e6('0x7a')]({'where':{'id':_0x4c8212['params']['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x4a5fbd,null))[_0xf0e6('0x2d')](removeEntity(_0x4a5fbd,null))[_0xf0e6('0xc6')](handleError(_0x4a5fbd,null));};exports[_0xf0e6('0xcb')]=function(_0x4f47b6,_0x2cdb03){return db[_0xf0e6('0x3d')][_0xf0e6('0xcb')]()[_0xf0e6('0x2d')](respondWithResult(_0x2cdb03,null))[_0xf0e6('0xc6')](handleError(_0x2cdb03,null));};exports[_0xf0e6('0xcc')]=function(_0x411ed0,_0x2dcfdd,_0x27ff1e){return db[_0xf0e6('0xcd')][_0xf0e6('0x7a')]({'where':{'id':_0x411ed0[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x2dcfdd,null))[_0xf0e6('0x2d')](function(_0x373948){if(_0x373948){return _0x373948[_0xf0e6('0xcc')](_0x411ed0[_0xf0e6('0xca')]['ids'],_[_0xf0e6('0xce')](_0x411ed0[_0xf0e6('0xca')],[_0xf0e6('0xcf'),'id'])||{});}})[_0xf0e6('0x2d')](respondWithResult(_0x2dcfdd,null))[_0xf0e6('0xc6')](handleError(_0x2dcfdd,null));};exports[_0xf0e6('0xd0')]=function(_0x550610,_0x53e278,_0x242d5d){var _0x2992b1={'raw':![],'where':{}};var _0x4434a9={};var _0x2bb5fb={'count':0x0,'rows':[]};return db[_0xf0e6('0x3d')][_0xf0e6('0x39')]({'where':{'id':_0x550610[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x53e278,null))[_0xf0e6('0x2d')](function(_0x3ed3d7){if(_0x3ed3d7){_0x4434a9[_0xf0e6('0x47')]=_[_0xf0e6('0x43')](db[_0xf0e6('0xcd')][_0xf0e6('0x3e')]);_0x4434a9[_0xf0e6('0x42')]=_[_0xf0e6('0x43')](_0x550610[_0xf0e6('0x42')]);_0x4434a9['filters']=_[_0xf0e6('0x46')](_0x4434a9[_0xf0e6('0x47')],_0x4434a9['query']);_0x2992b1[_0xf0e6('0x45')]=_['intersection'](_0x4434a9['model'],qs[_0xf0e6('0x48')](_0x550610['query']['fields']));_0x2992b1[_0xf0e6('0x45')]=_0x2992b1['attributes'][_0xf0e6('0x49')]?_0x2992b1[_0xf0e6('0x45')]:_0x4434a9[_0xf0e6('0x47')];if(!_0x550610[_0xf0e6('0x42')][_0xf0e6('0xd1')]('nolimit')){_0x2992b1[_0xf0e6('0x27')]=qs[_0xf0e6('0x27')](_0x550610['query'][_0xf0e6('0x27')]);_0x2992b1['offset']=qs['offset'](_0x550610[_0xf0e6('0x42')]['offset']);}_0x2992b1[_0xf0e6('0x4b')]=qs['sort'](_0x550610[_0xf0e6('0x42')][_0xf0e6('0x4c')]);_0x2992b1[_0xf0e6('0x4d')]=qs[_0xf0e6('0x44')](_['pick'](_0x550610[_0xf0e6('0x42')],_0x4434a9[_0xf0e6('0x44')]));_0x2992b1['where'][_0xf0e6('0xd2')]=_0x3ed3d7['id'];if(_0x550610['query']['filter']){_0x2992b1[_0xf0e6('0x4d')]=_[_0xf0e6('0xa2')](_0x2992b1[_0xf0e6('0x4d')],{'$or':_[_0xf0e6('0x33')](_0x2992b1[_0xf0e6('0x45')],function(_0x2e898e){var _0x422951={};_0x422951[_0x2e898e]={'$like':'%'+_0x550610['query'][_0xf0e6('0xd3')]+'%'};return _0x422951;})});}if(_0x550610[_0xf0e6('0x42')]['$gte']){var _0x43fbf7=_0x550610['query'][_0xf0e6('0x82')][_0xf0e6('0x37')](',');var _0xb1ce22={};_0xb1ce22[_0x43fbf7[0x0]]={'$gte':moment(_0x43fbf7[0x1])[_0xf0e6('0xd4')](_0xf0e6('0xd5'))};_0x2992b1['where']=_[_0xf0e6('0xa2')](_0x2992b1['where'],_0xb1ce22);}_0x2992b1=_[_0xf0e6('0xa2')]({},_0x2992b1,_0x550610[_0xf0e6('0xc9')]);return db[_0xf0e6('0xcd')][_0xf0e6('0x29')]({'where':_0x2992b1['where']})['then'](function(_0x4e71ad){_0x2bb5fb[_0xf0e6('0x29')]=_0x4e71ad;if(_0x550610[_0xf0e6('0x42')][_0xf0e6('0xd6')]){_0x2992b1[_0xf0e6('0xc8')]=[{'all':!![]}];}return db['MailMessage'][_0xf0e6('0xd7')](_0x2992b1);})[_0xf0e6('0x2d')](function(_0x5deb66){if(_0x550610['query'][_0xf0e6('0xd8')]===_0xf0e6('0xd9')){for(var _0x1a1176=0x0;_0x1a1176<_0x5deb66['length'];_0x1a1176++){_0x5deb66[_0x1a1176][_0xf0e6('0xca')]=juice(_0x5deb66[_0x1a1176][_0xf0e6('0xca')]);}}_0x2bb5fb[_0xf0e6('0xda')]=_0x5deb66;return _0x2bb5fb;});}})[_0xf0e6('0x2d')](respondWithFilteredResult(_0x53e278,_0x2992b1))[_0xf0e6('0xc6')](handleError(_0x53e278,null));};exports[_0xf0e6('0xdb')]=function(_0x17ed25,_0x174aff,_0x4296a7){return db[_0xf0e6('0x3d')][_0xf0e6('0x7a')]({'where':{'id':_0x17ed25[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x174aff,null))[_0xf0e6('0x2d')](function(_0x272f7c){if(_0x272f7c){return _0x272f7c['setTags'](_0x17ed25[_0xf0e6('0xca')][_0xf0e6('0xcf')],_[_0xf0e6('0xce')](_0x17ed25[_0xf0e6('0xca')],[_0xf0e6('0xcf'),'id'])||{})[_0xf0e6('0xdc')](function(){return db[_0xf0e6('0xdd')][_0xf0e6('0xd7')]({'attributes':['id',_0xf0e6('0x31'),'color'],'where':{'id':_0x17ed25[_0xf0e6('0xca')][_0xf0e6('0xcf')]}});})[_0xf0e6('0x2d')](function(_0x579262){socket[_0xf0e6('0xde')](_0xf0e6('0xdf'),{'id':Number(_0x17ed25['params']['id']),'tags':_0x579262||[]});return{'id':Number(_0x17ed25[_0xf0e6('0xc7')]['id']),'tags':_0x579262||[]};});}})[_0xf0e6('0x2d')](respondWithResult(_0x174aff,null))[_0xf0e6('0xc6')](handleError(_0x174aff,null));};exports[_0xf0e6('0xe0')]=function(_0x1d5e2d,_0x1bc886,_0x509fe8){return db[_0xf0e6('0x3d')][_0xf0e6('0x7a')]({'where':{'id':_0x1d5e2d[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x1bc886,null))[_0xf0e6('0x2d')](function(_0x32aa03){if(_0x32aa03){return _0x32aa03[_0xf0e6('0xe0')](_0x1d5e2d[_0xf0e6('0x42')][_0xf0e6('0xcf')]);}})[_0xf0e6('0x2d')](respondWithStatusCode(_0x1bc886,null))[_0xf0e6('0xc6')](handleError(_0x1bc886,null));};exports['download']=function(_0x45f686,_0x297c3d){var _0x14183f=moment()[_0xf0e6('0xe1')]()['toString']();var _0x1273b0=path['join'](config[_0xf0e6('0xe2')],_0xf0e6('0xe3'),'files','tmp');var _0x47127f=path[_0xf0e6('0xe4')](config['root'],'server',_0xf0e6('0xe5'),_0xf0e6('0xe6'));var _0x2385b1=path['join'](_0x1273b0,_0x14183f);var _0x3cff12=util[_0xf0e6('0xd4')](_0xf0e6('0xe7'),_0x45f686[_0xf0e6('0xc7')]['id'],_0x14183f);var _0x56631f=path['join'](_0x1273b0,_0x3cff12);var _0x9375ec=[];if(_0x45f686[_0xf0e6('0x42')][_0xf0e6('0xe6')]){_0x9375ec['push']({'model':db[_0xf0e6('0xe8')],'as':'Attachments','raw':!![]});}var _0x2ababf=[{'model':db[_0xf0e6('0xcd')],'as':_0xf0e6('0xe9'),'attributes':['id',_0xf0e6('0xca'),_0xf0e6('0x51'),'to','cc','bcc',_0xf0e6('0xea'),_0xf0e6('0xeb')],'where':{'secret':![]},'order':qs[_0xf0e6('0x4c')]('id'),'include':_0x9375ec}];return db['MailInteraction'][_0xf0e6('0x7a')]({'where':{'id':_0x45f686[_0xf0e6('0xc7')]['id']},'include':_0x2ababf})[_0xf0e6('0x2d')](handleEntityNotFound(_0x297c3d,null))[_0xf0e6('0x2d')](function(_0x1e89f0){if(_0x1e89f0&&_0x1e89f0[_0xf0e6('0xe9')]){var _0x48df7c=_0x1e89f0['get']({'plain':!![]});fs[_0xf0e6('0xec')](_0x2385b1);return BPromise['each'](_0x48df7c[_0xf0e6('0xe9')],function(_0x5006fc,_0xd58acb){var _0x131845={'from':_0x5006fc['from'],'to':_0x5006fc['to'],'subject':_0x5006fc[_0xf0e6('0xea')],'html':_0x5006fc[_0xf0e6('0xca')],'headers':{'Date':moment(_0x5006fc[_0xf0e6('0xeb')])[_0xf0e6('0xd4')](_0xf0e6('0xed'))},'attachments':[]};if(_0x5006fc['cc']){_0x131845[_0xf0e6('0xee')]['Cc']=_0x5006fc['cc'];}if(_0x5006fc['bcc']){_0x131845['headers'][_0xf0e6('0xef')]=_0x5006fc[_0xf0e6('0xf0')];}return new BPromise(function(_0x217c5d,_0x1ba2a1){if(_0x5006fc[_0xf0e6('0xf1')]){for(var _0x41df91=0x0;_0x41df91<_0x5006fc[_0xf0e6('0xf1')][_0xf0e6('0x49')];_0x41df91++){var _0x22b9f9=_0x5006fc[_0xf0e6('0xf1')][_0x41df91];var _0x444fc6=path['join'](_0x47127f,_0x22b9f9[_0xf0e6('0xf2')]);if(fs[_0xf0e6('0xf3')](_0x444fc6)){_0x131845[_0xf0e6('0xe6')][_0xf0e6('0xf4')]({'name':_0x22b9f9[_0xf0e6('0x31')],'contentType':_0x22b9f9[_0xf0e6('0x40')],'data':fs['readFileSync'](_0x444fc6)});}}}emlformat['build'](_0x131845,function(_0x14d3f5,_0x407605){if(_0x14d3f5)return _0x1ba2a1(_0x14d3f5);fs['writeFileSync'](path['join'](_0x2385b1,util['format'](_0xf0e6('0xf5'),_0xd58acb)),_0x407605);return _0x217c5d(_0x407605);});});})[_0xf0e6('0x2d')](function(){return new BPromise(function(_0x53c569,_0xcec9dc){zipdir(_0x2385b1,{'saveTo':_0x56631f},function(_0x2f2739,_0x11010a){if(_0x2f2739)return _0xcec9dc(_0x2f2739);return _0x53c569(_0x11010a);});})[_0xf0e6('0x2d')](function(){return new BPromise(function(_0x59d909,_0x2b5246){rimraf(_0x2385b1,function(_0x2ab3f1){if(_0x2ab3f1)_0x2b5246(_0x2ab3f1);return _0x59d909();});});})[_0xf0e6('0x2d')](function(){return _0x297c3d[_0xf0e6('0xf6')](_0x56631f,_0x3cff12,function(_0x17dc8b){if(_0x17dc8b){console[_0xf0e6('0xf7')]('err',_0x17dc8b);}else{fs['unlinkSync'](_0x56631f);}});});});}else{return _0x297c3d['sendStatus'](0xc8);}})[_0xf0e6('0xc6')](handleError(_0x297c3d,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff