Built motion from commit df3e9871f6bcc3432fec345b2f4facbd4dba8b5c. Version 3.0.0...
[motion-next.git] / server / api / mailInteraction / mailInteraction.controller.js
index 7c035f5..37126c0 100644 (file)
@@ -1 +1 @@
-const a406_0x5d7b=['CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','YYYY-MM-DD\x20HH:mm:ss','`unreadMessages`\x20=\x200','rimraf','basename','path','ui.MailInteractionId','Attachment','lastMsgText','include','unlinkSync','o.internal','i.id\x20LIKE\x20?','tmp','expr','text','$lte','push','download','conditions','compact','getFullTextValue','options','MailMessage','User','headers','Owner.internal','start','i.MailAccountId','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','fromString','sqlOperator','Account.mandatoryDisposition','`\x20>\x200','createdAt','fieldName','MailAccountId','unreadMessages','i.id','limit','sendStatus','i.closed','ContactId','isEmail','i.lastMsgAt','Contact.lastName','users','Owner.fullname','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','pick','Contact.email','findAll','show','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','get','Contact','left_join','Bcc','end','nolimit','tools_tags','i.UserId','i.to','u.id\x20=\x20ui.UserId','update','a.id\x20=\x20i.MailAccountId','key','../../components/parsers/qs','Messages','../../config/logger','operator','u.fullname','keys','like','includeAll','filter','journey','i.createdAt','MailInteraction','files','getMailAccounts','u.id','ids','gte','trimStart','buildExpression','../../mysqldb','forEach','SELECT','Users','find','omit','groupBy','where','catch','c.email','user','MailInteractionId','addMessage','lastMsgBody','mail_interactions','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','name','Attachments','mkdirSync','$substring','sequelize','it.MailInteractionId\x20=\x20i.id','json','c.email\x20LIKE\x20?','describe','writeFileSync','replace','a.key','sort','select','having','fields','undefined','QueryTypes','toString','o.id\x20=\x20i.UserId','../../components/parsers/advancedSearch','root','\x27\x27\x27\x27','`\x20=\x200','../../rediscache','color','i.updatedAt','mail_interaction_has_tags','i.MailAccountId\x20IS\x20NOT\x20NULL','stack','value','query','Contact.mobile','err','split','field','i.closedAt','findOne','params','squel','then','i.subject','filters','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','tag','attributes','register','Tag','union','isArray','TagIds','set','$gte','t.id\x20IN\x20?','i.secondDisposition','i.substatus','ui.MailInteractionId\x20IN\x20?','c.fax','attachments','from','bcc','t.id\x20=\x20it.TagId','Content-Range','intersection','count','i.thirdDisposition','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','i.MailAccountId\x20IN\x20?','all','map','status','rows','a.mandatoryDisposition','model','null','Tags','rawAttributes','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','`unreadMessages`\x20>\x200','UserId','body','c.mobile','search','c.phone','subject','merge','html-to-text','parse','moment','transcript-%d-%s.zip','join','destroy','message%d.eml','concat','fullname','mail_messages','enableEmailPreview','format','mail_accounts','emit','i.MailAccountId\x20IS\x20NULL','read','create','zip-dir','length','setTags','clone','cm_contacts','util','../../config/environment','offset','order','resolve','addTags','group','isEmpty','isNumeric','c.lastName','type','Sequelize'];(function(_0x37ef20,_0x5d7bbd){const _0x5e22fe=function(_0xd9378f){while(--_0xd9378f){_0x37ef20['push'](_0x37ef20['shift']());}};_0x5e22fe(++_0x5d7bbd);}(a406_0x5d7b,0x1f2));const a406_0x5e22=function(_0x37ef20,_0x5d7bbd){_0x37ef20=_0x37ef20-0x0;let _0x5e22fe=a406_0x5d7b[_0x37ef20];return _0x5e22fe;};const _0x44782d=a406_0x5e22;'use strict';const emlformat=require('eml-format'),rimraf=require(_0x44782d('0xab')),zipdir=require(_0x44782d('0x97')),moment=require(_0x44782d('0x88')),util=require(_0x44782d('0x9c')),path=require(_0x44782d('0xad')),fs=require('fs'),_=require('lodash'),squel=require(_0x44782d('0x57')),htmlToText=require(_0x44782d('0x86')),{getSocket}=require(_0x44782d('0x48')),socket=getSocket(),qs=require(_0x44782d('0xd')),as=require(_0x44782d('0x44')),logger=require(_0x44782d('0xf'))('api'),config=require(_0x44782d('0x9d')),db=require(_0x44782d('0x20'))['db'],{Op}=require(_0x44782d('0x34'));require('./mailInteraction.socket')[_0x44782d('0x5e')](socket);function respondWithStatusCode(_0xd9378f,_0x334ed1){return _0x334ed1=_0x334ed1||0xcc,function(_0x164f82){const _0x5d95d2=a406_0x5e22;if(_0x164f82)return _0xd9378f[_0x5d95d2('0xd0')](_0x334ed1);return _0xd9378f[_0x5d95d2('0x76')](_0x334ed1)[_0x5d95d2('0x4')]();};}function respondWithResult(_0x2092ea,_0x15ad55){return _0x15ad55=_0x15ad55||0xc8,function(_0xb4b989){const _0x180d19=a406_0x5e22;if(_0xb4b989)return _0x2092ea[_0x180d19('0x76')](_0x15ad55)[_0x180d19('0x36')](_0xb4b989);};}function respondWithFilteredResult(_0x50aa5c,_0x1ed38b){return function(_0x1fa819){const _0x43da25=a406_0x5e22;if(_0x1fa819){const _0x2afaf3=_0x1fa819[_0x43da25('0x70')],_0x21b4fd=_0x1ed38b['offset'];let _0x42e3e3=_0x1ed38b[_0x43da25('0x9e')]+_0x1ed38b[_0x43da25('0xcf')],_0x1a9884;return _0x42e3e3>=_0x2afaf3?(_0x42e3e3=_0x2afaf3,_0x1a9884=0xc8):_0x1a9884=0xce,_0x50aa5c[_0x43da25('0x76')](_0x1a9884),_0x50aa5c[_0x43da25('0x63')](_0x43da25('0x6e'),_0x21b4fd+'-'+_0x42e3e3+'/'+_0x2afaf3)['json'](_0x1fa819);}return null;};}function saveUpdates(_0x37d447){return function(_0x2fa193){const _0x5281b9=a406_0x5e22;if(_0x2fa193)return _0x2fa193[_0x5281b9('0xa')](_0x37d447)[_0x5281b9('0x58')](function(_0x1219bd){return _0x1219bd;});return null;};}function removeEntity(_0x3c5fd8){return function(_0x590042){const _0x2183a5=a406_0x5e22;if(_0x590042)return _0x590042[_0x2183a5('0x8b')]()[_0x2183a5('0x58')](function(){const _0x16fc69=_0x2183a5;_0x3c5fd8[_0x16fc69('0x76')](0xcc)['end']();});};}function handleEntityNotFound(_0xea0a8c){return function(_0x5210d4){return!_0x5210d4&&_0xea0a8c['sendStatus'](0x194),_0x5210d4;};}function handleError(_0xf95dc1,_0x251788){return _0x251788=_0x251788||0x1f4,function(_0xc76911){const _0x35b65a=a406_0x5e22;logger['error'](_0xc76911[_0x35b65a('0x4d')]),_0xc76911[_0x35b65a('0x30')]&&delete _0xc76911['name'],_0xf95dc1[_0x35b65a('0x76')](_0x251788)['send'](_0xc76911);};}function getInteractionUsers(_0x486759,_0x1f76a6){return new Promise(function(_0x7b007f,_0x4aaf12){const _0x545c56=a406_0x5e22;try{_0x1f76a6[_0x486759['id']]&&(_0x486759[_0x545c56('0x23')]=_[_0x545c56('0x75')](_0x1f76a6[_0x486759['id']],function(_0x417702){const _0x1a99e4=_0x545c56;return{'id':_0x417702['id'],'fullname':_0x417702[_0x1a99e4('0x8e')]};}));}catch(_0x45a8da){_0x4aaf12(_0x45a8da);}_0x7b007f(_0x486759);});}function getInteractionTags(_0x4649ee,_0x3df0c8){return new Promise(function(_0x5cbb03,_0x5c3a10){const _0x5244e7=a406_0x5e22;try{_0x4649ee[_0x5244e7('0x62')]&&(_0x4649ee[_0x5244e7('0x7b')]=[],_0x4649ee[_0x5244e7('0x62')]['split'](',')[_0x5244e7('0x21')](function(_0x5d8aea){const _0x3fd1e1=_0x5244e7;_0x4649ee[_0x3fd1e1('0x7b')][_0x3fd1e1('0xb9')](_0x3df0c8[_0x5d8aea]);})),delete _0x4649ee['TagIds'];}catch(_0x5f0c0d){_0x5c3a10(_0x5f0c0d);}_0x5cbb03(_0x4649ee);});}function getLastMessageText(_0x4033f1){return new Promise(function(_0x5a833e,_0x21d0d9){const _0xc60ac2=a406_0x5e22;return db['MailInteraction']['findOne']({'where':{'id':_0x4033f1['id']},'attributes':[_0xc60ac2('0x2d'),'lastMsgText'],'raw':!![]})[_0xc60ac2('0x58')](function(_0x120174){const _0x58b57b=_0xc60ac2;!_0x120174[_0x58b57b('0xb0')]?_0x4033f1[_0x58b57b('0xb0')]=_[_0x58b57b('0x1e')](htmlToText[_0x58b57b('0xc6')](_0x120174[_0x58b57b('0x2d')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]})):_0x4033f1[_0x58b57b('0xb0')]=_0x120174[_0x58b57b('0xb0')],_0x5a833e(_0x4033f1);})[_0xc60ac2('0x28')](function(_0x4fc83e){_0x21d0d9(_0x4fc83e);});});}function updateMailInteraction(_0x2ef898,_0x1bba4c,_0x5a9363,_0xde2883){return new Promise(function(_0x1f3005,_0x5af49f){return getInteractionUsers(_0x2ef898,_0x5a9363)['then'](function(_0xdb8679){return getInteractionTags(_0xdb8679,_0x1bba4c);})['then'](function(_0x108a44){_0xde2883?_0x1f3005(getLastMessageText(_0x108a44)):_0x1f3005(_0x108a44);})['catch'](function(_0x239b00){_0x5af49f(_0x239b00);});});}exports['index']=function(_0x58886d,_0x11d339){const _0x578656=_0x44782d,_0x3ba9d2={},_0x36b007={},_0x1c6a9b={'count':0x0,'rows':[]},_0x20781a=_['map'](db['MailInteraction'][_0x578656('0x7c')],function(_0x6ed3d2){const _0x33e125=_0x578656;return{'name':_0x6ed3d2[_0x33e125('0xcb')],'type':_0x6ed3d2[_0x33e125('0xa6')][_0x33e125('0xc')]};});_0x36b007[_0x578656('0x79')]=_[_0x578656('0x75')](_0x20781a,_0x578656('0x30')),_0x36b007[_0x578656('0x4f')]=_[_0x578656('0x12')](_0x58886d['query']),_0x36b007[_0x578656('0x5a')]=_['intersection'](_0x36b007[_0x578656('0x79')],_0x36b007[_0x578656('0x4f')]),_0x3ba9d2['attributes']=_[_0x578656('0x6f')](_0x36b007[_0x578656('0x79')],qs[_0x578656('0x3f')](_0x58886d[_0x578656('0x4f')][_0x578656('0x3f')])),_0x3ba9d2[_0x578656('0x5d')]=_0x3ba9d2[_0x578656('0x5d')]['length']?_0x3ba9d2[_0x578656('0x5d')]:_0x36b007[_0x578656('0x79')];typeof _0x58886d[_0x578656('0x4f')]['nolimit']==='undefined'&&(_0x3ba9d2[_0x578656('0xcf')]=qs[_0x578656('0xcf')](_0x58886d[_0x578656('0x4f')][_0x578656('0xcf')]),_0x3ba9d2[_0x578656('0x9e')]=qs[_0x578656('0x9e')](_0x58886d[_0x578656('0x4f')][_0x578656('0x9e')]));_0x3ba9d2[_0x578656('0x9f')]=qs[_0x578656('0x3c')](_0x58886d['query'][_0x578656('0x3c')]),_0x3ba9d2['where']=qs[_0x578656('0x5a')](_['pick'](_0x58886d[_0x578656('0x4f')],_0x36b007[_0x578656('0x5a')]),_0x20781a);let _0x59845d=[];const _0x18def4=squel[_0x578656('0x3d')]()['field']('id')[_0x578656('0x53')](_0x578656('0x30'))[_0x578656('0x53')](_0x578656('0x49'))['from'](_0x578656('0x6')),_0x8c647d=squel[_0x578656('0x3d')]()[_0x578656('0x53')](_0x578656('0x1b'))[_0x578656('0x53')](_0x578656('0x11'))[_0x578656('0x53')](_0x578656('0xae'))['from']('user_has_mail_interactions','ui')['left_join']('users','u',_0x578656('0x9')),_0x558d3e=squel[_0x578656('0x3d')]()[_0x578656('0x6b')](_0x578656('0x2e'),'i')[_0x578656('0x2')](_0x578656('0x9b'),'c',_0x578656('0x7d'))['left_join'](_0x578656('0xd6'),'o',_0x578656('0x43'))[_0x578656('0x2')](_0x578656('0x92'),'a',_0x578656('0xb'))[_0x578656('0x2')](_0x578656('0x8f'),'me','me.MailInteractionId\x20=\x20i.id')[_0x578656('0x2')](_0x578656('0x4b'),'it',_0x578656('0x35'))[_0x578656('0x2')]('tools_tags','t',_0x578656('0x6d')),_0x2a8712=squel[_0x578656('0xb6')]();let _0x5d34b2=[];const _0x20665a=squel[_0x578656('0xb6')]();let _0x2ba027;if(_0x58886d[_0x578656('0x4f')][_0x578656('0x82')]){_0x2ba027=as['parseSearch'](_0x58886d[_0x578656('0x4f')][_0x578656('0x82')]);const _0x1f3dab=_0x2ba027[_0x578656('0xc7')];for(let _0x2cd51c=0x0;_0x2cd51c<_0x2ba027[_0x578656('0xbb')][_0x578656('0x98')];_0x2cd51c++){const _0x34d557=_0x2ba027[_0x578656('0xbb')][_0x2cd51c],_0x1f34cf='i';let _0x39d681,_0x56668b=_[_0x578656('0x24')](_0x20781a,[_0x578656('0x30'),_0x34d557['field']]);if(!_0x56668b)switch(_0x34d557['field']){case'unreadMessages':_0x34d557[_0x578656('0x4e')]==0x1?_0x558d3e[_0x578656('0x3e')]('`'+_0x34d557[_0x578656('0x53')]+_0x578656('0x47')):_0x558d3e[_0x578656('0x3e')]('`'+_0x34d557[_0x578656('0x53')]+_0x578656('0xc9'));break;case _0x578656('0x1'):if(_0x34d557['operator']==='$substring'){if(_0x34d557[_0x578656('0x4e')][_0x578656('0x52')]('\x20')[_0x578656('0x98')]>0x1)_0x2a8712[_0x1f3dab](_0x578656('0xc5'),qs['getFullTextValue'](_0x34d557[_0x578656('0x4e')]),null);else{const _0xcc6d75='%'+_0x34d557['value']+'%';_0x2a8712[_0x1f3dab](_0x578656('0x5b'),_0xcc6d75,_0xcc6d75,_0xcc6d75);}}else _0x56668b=_[_0x578656('0x24')](_0x20781a,['name',_0x578656('0xd2')]),_0x34d557['field']=_0x578656('0xd2'),_0x39d681=as[_0x578656('0x1f')](_0x1f34cf,_0x56668b[_0x578656('0xa6')],_0x34d557),_0x2a8712[_0x1f3dab](_0x39d681[_0x578656('0xb7')],_0x39d681[_0x578656('0x4e')][_0x578656('0xc3')],_0x39d681['value']['end']);break;case _0x578656('0x5f'):{const _0x3f0454=_0x34d557[_0x578656('0x4e')]['split'](',')['map'](function(_0x23cd1f){return Number(_0x23cd1f);});_0x3f0454['forEach'](function(_0x20d993){_0x20665a['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x20d993+',%');}),_0x5d34b2=_[_0x578656('0x60')](_0x5d34b2,_0x3f0454);}break;case _0x578656('0xc0'):_0x34d557[_0x578656('0x10')]===_0x578656('0x33')?_0x2a8712[_0x1f3dab](_0x578656('0xa8'),'%'+_0x34d557[_0x578656('0x4e')]+'%',null):(_0x56668b=_['find'](_0x20781a,[_0x578656('0x30'),_0x578656('0x7f')]),_0x34d557['field']=_0x578656('0x7f'),_0x39d681=as[_0x578656('0x1f')](_0x1f34cf,_0x56668b[_0x578656('0xa6')],_0x34d557),_0x2a8712[_0x1f3dab](_0x39d681[_0x578656('0xb7')],_0x39d681[_0x578656('0x4e')][_0x578656('0xc3')],_0x39d681['value'][_0x578656('0x4')]));break;case'plainBody':_0x39d681=as[_0x578656('0x1f')]('me',null,_0x34d557),_0x2a8712[_0x1f3dab](_0x39d681[_0x578656('0xb7')],_0x39d681['value']['start'],_0x39d681['value'][_0x578656('0x4')]);break;}else _0x39d681=as[_0x578656('0x1f')](_0x1f34cf,_0x56668b[_0x578656('0xa6')],_0x34d557),_0x2a8712[_0x1f3dab](_0x39d681[_0x578656('0xb7')],_0x39d681[_0x578656('0x4e')][_0x578656('0xc3')],_0x39d681[_0x578656('0x4e')]['end']);}}else{const _0x678608=_(_0x58886d[_0x578656('0x4f')])[_0x578656('0x12')]()[_0x578656('0x75')](function(_0x10caf0){return _['some'](_0x20781a,['name',_0x10caf0])?_0x10caf0:undefined;})[_0x578656('0xbc')]()['value']();!_[_0x578656('0xa3')](_0x678608)&&_0x678608[_0x578656('0x21')](function(_0x4af7ad){const _0x177249=_0x578656;if(_0x4af7ad===_0x177249('0xcc'))_0x558d3e[_0x177249('0x27')](_0x177249('0x73'),[][_0x177249('0x8d')](_0x58886d[_0x177249('0x4f')][_0x4af7ad]));else{if(_0x4af7ad===_0x177249('0xca')){const _0x2829f7=JSON[_0x177249('0x87')](_0x58886d[_0x177249('0x4f')][_0x4af7ad])[_0x177249('0x64')],_0x17a0af=JSON[_0x177249('0x87')](_0x58886d[_0x177249('0x4f')][_0x4af7ad])[_0x177249('0xb8')];_0x558d3e[_0x177249('0x27')](_0x177249('0xd8'),_0x2829f7,_0x17a0af);}else _0x58886d[_0x177249('0x4f')][_0x4af7ad]===_0x177249('0x7a')?_0x558d3e['where']('i.'+_0x4af7ad+'\x20IS\x20NULL'):_0x558d3e[_0x177249('0x27')]('i.'+_0x4af7ad+'\x20=\x20?',_0x58886d[_0x177249('0x4f')][_0x4af7ad]);}});_0x58886d[_0x578656('0x4f')]['read']&&(_0x58886d[_0x578656('0x4f')][_0x578656('0x95')]==0x1?_0x558d3e[_0x578656('0x3e')](_0x578656('0xaa')):_0x558d3e[_0x578656('0x3e')](_0x578656('0x7e')));_0x58886d['query'][_0x578656('0x5c')]&&(_0x5d34b2=_[_0x578656('0x61')](_0x58886d['query']['tag'])?_0x58886d['query'][_0x578656('0x5c')]:new Array(_0x58886d['query'][_0x578656('0x5c')]),_0x5d34b2[_0x578656('0x21')](function(_0x457178){_0x20665a['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x457178+',%');}));if(_0x58886d[_0x578656('0x4f')][_0x578656('0x15')]){const _0x229cae=_0x58886d[_0x578656('0x4f')][_0x578656('0x15')][_0x578656('0x3a')]('\x5c','\x5c\x5c')[_0x578656('0x3a')]('\x27\x27',_0x578656('0x46'));if(qs[_0x578656('0xa4')](_0x229cae))_0x2a8712['or'](_0x578656('0xb4'),_0x229cae+'%');else qs[_0x578656('0xd3')](_0x229cae)?_0x2a8712['or'](_0x578656('0x37'),_0x229cae+'%'):_0x2a8712['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x578656('0xbd')](_0x229cae))['or'](_0x578656('0xdd'),qs[_0x578656('0xbd')](_0x229cae));}}_0x558d3e[_0x578656('0x27')](_0x2a8712),_0x558d3e[_0x578656('0xa2')](_0x578656('0xce'));let _0x5f450d={'type':db[_0x578656('0xa7')][_0x578656('0x41')][_0x578656('0x22')],'raw':!![]};const _0x451f34=_0x558d3e[_0x578656('0x9a')]();_0x451f34[_0x578656('0x53')]('i.id'),_0x451f34['field'](_0x578656('0x2f'),_0x578656('0xcd')),_0x3ba9d2['order']&&_0x3ba9d2['order'][_0x578656('0x21')](function(_0x32d4fa){const _0x432f07=_0x578656;_0x558d3e[_0x432f07('0x9f')]('i.'+_0x32d4fa[0x0],_0x32d4fa[0x1]==='DESC'?![]:!![]);}),!_[_0x578656('0xa3')](_0x5d34b2)&&(_0x558d3e[_0x578656('0x3e')](_0x20665a),_0x451f34[_0x578656('0x27')](_0x578656('0x65'),_0x5d34b2)),Promise[_0x578656('0xa0')]()[_0x578656('0x58')](function(){const _0x47660e=_0x578656;if(!_0x2ba027){if(_0x58886d[_0x47660e('0x4f')]['MailAccountId']||_0x58886d[_0x47660e('0x4f')][_0x47660e('0x16')])return;_0x451f34[_0x47660e('0x27')](_0x47660e('0x4c')),_0x558d3e[_0x47660e('0x27')](_0x47660e('0x4c'));return;}return _0x58886d[_0x47660e('0x2a')][_0x47660e('0x1a')]({'attributes':['id'],'raw':!![]})[_0x47660e('0x58')](function(_0x58caa1){const _0x5ddb46=_0x47660e;_['isEmpty'](_0x58caa1)?(_0x451f34['where'](_0x5ddb46('0x94')),_0x558d3e[_0x5ddb46('0x27')](_0x5ddb46('0x94'))):(_0x451f34['where']('i.MailAccountId\x20IN\x20?',_[_0x5ddb46('0x75')](_0x58caa1,'id')),_0x558d3e[_0x5ddb46('0x27')](_0x5ddb46('0x73'),_[_0x5ddb46('0x75')](_0x58caa1,'id')));});})[_0x578656('0x58')](function(){const _0x57cdc6=_0x578656;db[_0x57cdc6('0x34')][_0x57cdc6('0x4f')](_0x451f34[_0x57cdc6('0x42')](),_0x5f450d)['then'](function(_0x386c88){const _0xfcbb4d=_0x57cdc6;_0x1c6a9b[_0xfcbb4d('0x70')]=_0x386c88[_0xfcbb4d('0x98')];if(_0x1c6a9b[_0xfcbb4d('0x70')]===0x0)return[];return db[_0xfcbb4d('0x34')][_0xfcbb4d('0x4f')](_0x18def4['toString'](),_0x5f450d)[_0xfcbb4d('0x58')](function(_0x1211be){const _0x1d91df=_0xfcbb4d;_0x59845d=_['keyBy'](_0x1211be,'id'),_0x5f450d=_[_0x1d91df('0x85')](_0x5f450d,{'model':db[_0x1d91df('0x18')],'mapToModel':!![],'raw':!![],'nest':!![]});_0x58886d[_0x1d91df('0x4f')][_0x1d91df('0x3f')]?_0x3ba9d2[_0x1d91df('0x5d')][_0x1d91df('0x21')](function(_0x27832e){const _0x229a42=_0x1d91df;_0x558d3e[_0x229a42('0x53')]('i.'+_0x27832e);}):(_0x558d3e['field'](_0x1d91df('0x2f'),_0x1d91df('0xcd')),_0x558d3e['field'](_0x1d91df('0x3b'),'Account.key'),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x78'),_0x1d91df('0xc8')),_0x558d3e['field']('i.id'),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x17')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x4a')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0xd1')),_0x558d3e['field'](_0x1d91df('0x54')),_0x558d3e[_0x1d91df('0x53')]('i.attach'),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0xd4')),_0x558d3e['field']('i.lastMsgDirection'),_0x558d3e['field'](_0x1d91df('0x59')),_0x558d3e['field']('i.disposition'),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x66')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x71')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x67')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x8')),_0x558d3e[_0x1d91df('0x53')]('i.ContactId'),_0x558d3e['field'](_0x1d91df('0xc4')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x7')),_0x558d3e[_0x1d91df('0x53')]('c.firstName','Contact.firstName'),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0xa5'),_0x1d91df('0xd5')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x29'),_0x1d91df('0xda')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x83'),'Contact.phone'),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x81'),_0x1d91df('0x50')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0x69'),'Contact.fax'),_0x558d3e[_0x1d91df('0x53')]('o.fullname',_0x1d91df('0xd7')),_0x558d3e[_0x1d91df('0x53')](_0x1d91df('0xb3'),_0x1d91df('0xc2')),_0x558d3e[_0x1d91df('0x53')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x1d91df('0x62')));if(_0x3ba9d2[_0x1d91df('0xcf')])_0x558d3e[_0x1d91df('0xcf')](_0x3ba9d2[_0x1d91df('0xcf')]);if(_0x3ba9d2[_0x1d91df('0x9e')])_0x558d3e[_0x1d91df('0x9e')](_0x3ba9d2[_0x1d91df('0x9e')]);return db[_0x1d91df('0x34')][_0x1d91df('0x4f')](_0x558d3e['toString'](),_0x5f450d);})['then'](function(_0x102c72){const _0x3b5341=_0xfcbb4d;return _0x8c647d[_0x3b5341('0x27')](_0x3b5341('0x68'),_['map'](_0x102c72,'id')),db[_0x3b5341('0x34')][_0x3b5341('0x4f')](_0x8c647d['toString'](),_0x5f450d)[_0x3b5341('0x58')](function(_0x3574bf){const _0x4e2712=_0x3b5341,_0x1d7b27=_[_0x4e2712('0x26')](_0x3574bf,_0x4e2712('0x2b')),_0x42f07e=[];return db['Setting'][_0x4e2712('0x55')]({'attributes':[_0x4e2712('0x90')],'raw':!![]})[_0x4e2712('0x58')](function(_0x48203d){const _0x28aa85=_0x4e2712,_0x2b9bfb=_0x48203d['enableEmailPreview'];return _0x102c72['forEach'](function(_0x25df35){_0x42f07e['push'](updateMailInteraction(_0x25df35,_0x59845d,_0x1d7b27,_0x2b9bfb));}),Promise[_0x28aa85('0x74')](_0x42f07e);});});});})[_0x57cdc6('0x58')](function(_0x5c1110){const _0x1f1d8d=_0x57cdc6;return _0x1c6a9b[_0x1f1d8d('0x77')]=_0x5c1110,_0x1c6a9b;})[_0x57cdc6('0x58')](respondWithFilteredResult(_0x11d339,_0x3ba9d2));})[_0x578656('0x28')](handleError(_0x11d339,null));},exports[_0x44782d('0xdc')]=function(_0x2ee40,_0xcd2834){const _0x414cfe=_0x44782d;let _0x159902={'raw':![],'where':{'id':_0x2ee40[_0x414cfe('0x56')]['id']}};const _0x3fab9b={};return _0x3fab9b[_0x414cfe('0x79')]=_[_0x414cfe('0x12')](db[_0x414cfe('0x18')][_0x414cfe('0x7c')]),_0x3fab9b[_0x414cfe('0x4f')]=_['keys'](_0x2ee40[_0x414cfe('0x4f')]),_0x3fab9b[_0x414cfe('0x5a')]=_[_0x414cfe('0x6f')](_0x3fab9b['model'],_0x3fab9b['query']),_0x159902['attributes']=_['intersection'](_0x3fab9b[_0x414cfe('0x79')],qs['fields'](_0x2ee40['query'][_0x414cfe('0x3f')])),_0x159902[_0x414cfe('0x5d')]=_0x159902[_0x414cfe('0x5d')][_0x414cfe('0x98')]?_0x159902[_0x414cfe('0x5d')]:_0x3fab9b['model'],_0x2ee40[_0x414cfe('0x4f')][_0x414cfe('0x14')]&&(_0x159902[_0x414cfe('0xb1')]=[{'all':!![]}]),_0x159902=_[_0x414cfe('0x85')]({},_0x159902,_0x2ee40[_0x414cfe('0xbe')]),db[_0x414cfe('0x18')][_0x414cfe('0x55')](_0x159902)[_0x414cfe('0x58')](handleEntityNotFound(_0xcd2834,null))['then'](respondWithResult(_0xcd2834,null))['catch'](handleError(_0xcd2834,null));},exports[_0x44782d('0x96')]=function(_0xa2ee03,_0x4bf1d4){const _0x5bf34d=_0x44782d;return db[_0x5bf34d('0x18')]['create'](_0xa2ee03['body'],{})[_0x5bf34d('0x58')](respondWithResult(_0x4bf1d4,0xc9))[_0x5bf34d('0x28')](handleError(_0x4bf1d4,null));},exports[_0x44782d('0xa')]=function(_0x39efb9,_0x4212e3){const _0x125a2a=_0x44782d;return _0x39efb9[_0x125a2a('0x80')]['id']&&delete _0x39efb9[_0x125a2a('0x80')]['id'],db[_0x125a2a('0x18')][_0x125a2a('0x55')]({'where':{'id':_0x39efb9[_0x125a2a('0x56')]['id']}})[_0x125a2a('0x58')](handleEntityNotFound(_0x4212e3,null))[_0x125a2a('0x58')](saveUpdates(_0x39efb9[_0x125a2a('0x80')],null))[_0x125a2a('0x58')](respondWithResult(_0x4212e3,null))[_0x125a2a('0x28')](handleError(_0x4212e3,null));},exports[_0x44782d('0x8b')]=function(_0x53c655,_0x1304a7){const _0x271f47=_0x44782d;return db[_0x271f47('0x18')][_0x271f47('0x55')]({'where':{'id':_0x53c655['params']['id']}})[_0x271f47('0x58')](handleEntityNotFound(_0x1304a7,null))['then'](removeEntity(_0x1304a7,null))['catch'](handleError(_0x1304a7,null));},exports[_0x44782d('0x38')]=function(_0x1fda29,_0x1f0547){const _0x1857a6=_0x44782d;return db['MailInteraction'][_0x1857a6('0x38')]()[_0x1857a6('0x58')](respondWithResult(_0x1f0547,null))[_0x1857a6('0x28')](handleError(_0x1f0547,null));},exports['addMessage']=function(_0x5b799d,_0x3c93ad){const _0x585b59=_0x44782d;return db['MailMessage']['findOne']({'where':{'id':_0x5b799d[_0x585b59('0x56')]['id']}})[_0x585b59('0x58')](function(_0x103db8){const _0x46f9bd=_0x585b59;if(_0x103db8)return _0x103db8[_0x46f9bd('0x2c')](_0x5b799d['body']['ids'],{'through':_[_0x46f9bd('0x25')](_0x5b799d[_0x46f9bd('0x80')],[_0x46f9bd('0x1c'),'id'])});})['then'](respondWithResult(_0x3c93ad,null))['catch'](handleError(_0x3c93ad,null));},exports['getMessages']=function(_0xe55c9f,_0x686384){const _0x2d062c=_0x44782d;let _0x4a45ae={'raw':![],'where':{}};const _0x39606c={},_0x169682={'count':0x0,'rows':[]};return db[_0x2d062c('0x18')]['findOne']({'where':{'id':_0xe55c9f['params']['id']}})[_0x2d062c('0x58')](handleEntityNotFound(_0x686384,null))[_0x2d062c('0x58')](function(_0x5a8647){const _0x5456f3=_0x2d062c;if(_0x5a8647){_0x39606c[_0x5456f3('0x79')]=_[_0x5456f3('0x12')](db['MailMessage'][_0x5456f3('0x7c')]),_0x39606c[_0x5456f3('0x4f')]=_['keys'](_0xe55c9f[_0x5456f3('0x4f')]),_0x39606c[_0x5456f3('0x5a')]=_[_0x5456f3('0x6f')](_0x39606c['model'],_0x39606c[_0x5456f3('0x4f')]),_0x4a45ae[_0x5456f3('0x5d')]=_['intersection'](_0x39606c['model'],qs['fields'](_0xe55c9f[_0x5456f3('0x4f')][_0x5456f3('0x3f')])),_0x4a45ae[_0x5456f3('0x5d')]=_0x4a45ae[_0x5456f3('0x5d')][_0x5456f3('0x98')]?_0x4a45ae[_0x5456f3('0x5d')]:_0x39606c[_0x5456f3('0x79')];typeof _0xe55c9f[_0x5456f3('0x4f')][_0x5456f3('0x5')]===_0x5456f3('0x40')&&(_0x4a45ae['limit']=qs[_0x5456f3('0xcf')](_0xe55c9f['query'][_0x5456f3('0xcf')]),_0x4a45ae[_0x5456f3('0x9e')]=qs[_0x5456f3('0x9e')](_0xe55c9f['query']['offset']));_0x4a45ae[_0x5456f3('0x9f')]=qs[_0x5456f3('0x3c')](_0xe55c9f[_0x5456f3('0x4f')][_0x5456f3('0x3c')]),_0x4a45ae['where']=qs[_0x5456f3('0x5a')](_[_0x5456f3('0xd9')](_0xe55c9f['query'],_0x39606c[_0x5456f3('0x5a')])),_0x4a45ae['where']['MailInteractionId']=_0x5a8647['id'];_0xe55c9f[_0x5456f3('0x4f')][_0x5456f3('0x15')]&&(_0x4a45ae[_0x5456f3('0x27')]=_[_0x5456f3('0x85')](_0x4a45ae[_0x5456f3('0x27')],{[Op['or']]:_[_0x5456f3('0x75')](_0x4a45ae[_0x5456f3('0x5d')],function(_0x13ecc6){const _0x1a2597=_0x5456f3,_0x268ca6={};return _0x268ca6[_0x13ecc6]={[Op[_0x1a2597('0x13')]]:'%'+_0xe55c9f[_0x1a2597('0x4f')][_0x1a2597('0x15')]+'%'},_0x268ca6;})}));if(_0xe55c9f[_0x5456f3('0x4f')][_0x5456f3('0x64')]){const _0x52926a=_0xe55c9f[_0x5456f3('0x4f')][_0x5456f3('0x64')][_0x5456f3('0x52')](','),_0x2fccb7={};_0x2fccb7[_0x52926a[0x0]]={[Op[_0x5456f3('0x1d')]]:moment(_0x52926a[0x1])[_0x5456f3('0x91')](_0x5456f3('0xa9'))},_0x4a45ae[_0x5456f3('0x27')]=_['merge'](_0x4a45ae[_0x5456f3('0x27')],_0x2fccb7);}return _0x4a45ae=_[_0x5456f3('0x85')]({},_0x4a45ae,_0xe55c9f[_0x5456f3('0xbe')]),db[_0x5456f3('0xbf')][_0x5456f3('0x70')]({'where':_0x4a45ae[_0x5456f3('0x27')]})[_0x5456f3('0x58')](function(_0x3b2dd6){const _0x47513c=_0x5456f3;return _0x169682[_0x47513c('0x70')]=_0x3b2dd6,_0xe55c9f[_0x47513c('0x4f')][_0x47513c('0x14')]&&(_0x4a45ae[_0x47513c('0xb1')]=[{'all':!![]}]),db[_0x47513c('0xbf')][_0x47513c('0xdb')](_0x4a45ae);})[_0x5456f3('0x58')](function(_0x1e16b3){return _0x169682['rows']=_0x1e16b3,_0x169682;});}})[_0x2d062c('0x58')](respondWithFilteredResult(_0x686384,_0x4a45ae))[_0x2d062c('0x28')](handleError(_0x686384,null));},exports[_0x44782d('0xa1')]=function(_0xe57700,_0x1505ad){const _0x2ebfd7=_0x44782d;return db[_0x2ebfd7('0x18')]['findOne']({'where':{'id':_0xe57700[_0x2ebfd7('0x56')]['id']}})['then'](function(_0x4e5d2f){const _0x310d46=_0x2ebfd7;if(_0x4e5d2f)return _0x4e5d2f[_0x310d46('0x99')](_0xe57700[_0x310d46('0x80')][_0x310d46('0x1c')],{'through':_[_0x310d46('0x25')](_0xe57700[_0x310d46('0x80')],[_0x310d46('0x1c'),'id'])})[_0x310d46('0x58')](function(){const _0x9eb23d=_0x310d46;return db[_0x9eb23d('0x5f')][_0x9eb23d('0xdb')]({'attributes':['id',_0x9eb23d('0x30'),_0x9eb23d('0x49')],'where':{'id':_0xe57700[_0x9eb23d('0x80')]['ids']}});})[_0x310d46('0x58')](function(_0x32acef){const _0x5127cb=_0x310d46;return socket[_0x5127cb('0x93')]('mailInteractionTags:save',{'id':Number(_0xe57700[_0x5127cb('0x56')]['id']),'tags':_0x32acef||[]}),{'id':Number(_0xe57700['params']['id']),'tags':_0x32acef||[]};});})[_0x2ebfd7('0x58')](respondWithResult(_0x1505ad,null))['catch'](handleError(_0x1505ad,null));},exports['removeTags']=function(_0xc53ad0,_0x5b754b){const _0x5d05e3=_0x44782d;return db['MailInteraction']['findOne']({'where':{'id':_0xc53ad0[_0x5d05e3('0x56')]['id']}})[_0x5d05e3('0x58')](handleEntityNotFound(_0x5b754b,null))[_0x5d05e3('0x58')](function(_0x499010){const _0x24b4d6=_0x5d05e3;if(_0x499010)return _0x499010['removeTags'](_0xc53ad0[_0x24b4d6('0x4f')][_0x24b4d6('0x1c')]);})[_0x5d05e3('0x58')](respondWithStatusCode(_0x5b754b,null))[_0x5d05e3('0x28')](handleError(_0x5b754b,null));},exports['download']=function(_0x37516e,_0x4da220){const _0x515abf=_0x44782d,_0x347bbd=moment()['unix']()[_0x515abf('0x42')](),_0x5c67a7=path[_0x515abf('0x8a')](config[_0x515abf('0x45')],_0x515abf('0x19'),_0x515abf('0xb5')),_0x33080b=path[_0x515abf('0x8a')](config[_0x515abf('0x45')],'server',_0x515abf('0x19'),_0x515abf('0x6a')),_0x28f58f=path['join'](_0x5c67a7,_0x347bbd),_0x58b7b1=util[_0x515abf('0x91')](_0x515abf('0x89'),_0x37516e['params']['id'],_0x347bbd),_0x376896=path[_0x515abf('0x8a')](_0x5c67a7,_0x58b7b1),_0x2f3d4c=[];_0x37516e[_0x515abf('0x4f')][_0x515abf('0x6a')]&&_0x2f3d4c[_0x515abf('0xb9')]({'model':db[_0x515abf('0xaf')],'as':_0x515abf('0x31'),'raw':!![]});const _0x271b6d=[{'model':db[_0x515abf('0xbf')],'as':_0x515abf('0xe'),'attributes':['id',_0x515abf('0x80'),_0x515abf('0x6b'),'to','cc',_0x515abf('0x6c'),_0x515abf('0x84'),_0x515abf('0xca')],'where':{'secret':![]},'order':qs['sort']('id'),'include':_0x2f3d4c}];return db[_0x515abf('0x18')][_0x515abf('0x55')]({'where':{'id':_0x37516e[_0x515abf('0x56')]['id']},'include':_0x271b6d})[_0x515abf('0x58')](handleEntityNotFound(_0x4da220,null))[_0x515abf('0x58')](function(_0xfc3db4){const _0x2a7c62=_0x515abf;if(_0xfc3db4&&_0xfc3db4[_0x2a7c62('0xe')]){const _0x1e6d8b=_0xfc3db4[_0x2a7c62('0x0')]({'plain':!![]});return fs[_0x2a7c62('0x32')](_0x28f58f),Promise['each'](_0x1e6d8b[_0x2a7c62('0xe')],function(_0x3031a2,_0x1cdca2){const _0x9b94cd=_0x2a7c62,_0x29613={'from':_0x3031a2[_0x9b94cd('0x6b')],'to':_0x3031a2['to'],'subject':_0x3031a2[_0x9b94cd('0x84')],'html':_0x3031a2['body'],'headers':{'Date':moment(_0x3031a2[_0x9b94cd('0xca')])['format'](_0x9b94cd('0x72'))},'attachments':[]};return _0x3031a2['cc']&&(_0x29613[_0x9b94cd('0xc1')]['Cc']=_0x3031a2['cc']),_0x3031a2[_0x9b94cd('0x6c')]&&(_0x29613[_0x9b94cd('0xc1')][_0x9b94cd('0x3')]=_0x3031a2[_0x9b94cd('0x6c')]),new Promise(function(_0x3f9022,_0x25b161){const _0x3cb4b1=_0x9b94cd;if(_0x3031a2['Attachments'])for(let _0x4a0cf4=0x0;_0x4a0cf4<_0x3031a2['Attachments']['length'];_0x4a0cf4++){const _0x425e9b=_0x3031a2[_0x3cb4b1('0x31')][_0x4a0cf4],_0x389357=path[_0x3cb4b1('0x8a')](_0x33080b,_0x425e9b[_0x3cb4b1('0xac')]);fs['existsSync'](_0x389357)&&_0x29613[_0x3cb4b1('0x6a')][_0x3cb4b1('0xb9')]({'name':_0x425e9b[_0x3cb4b1('0x30')],'contentType':_0x425e9b['type'],'data':fs['readFileSync'](_0x389357)});}emlformat['build'](_0x29613,function(_0x13b6ff,_0xd76d72){const _0x239a49=_0x3cb4b1;if(_0x13b6ff)return _0x25b161(_0x13b6ff);return fs[_0x239a49('0x39')](path[_0x239a49('0x8a')](_0x28f58f,util[_0x239a49('0x91')](_0x239a49('0x8c'),_0x1cdca2)),_0xd76d72),_0x3f9022(_0xd76d72);});});})['then'](function(){const _0x10c797=_0x2a7c62;return new Promise(function(_0x524988,_0x57f419){zipdir(_0x28f58f,{'saveTo':_0x376896},function(_0x2c5743,_0x5d5b23){if(_0x2c5743)return _0x57f419(_0x2c5743);return _0x524988(_0x5d5b23);});})[_0x10c797('0x58')](function(){return new Promise(function(_0x5106a5,_0x4b1e9d){rimraf(_0x28f58f,function(_0x1b4845){if(_0x1b4845)_0x4b1e9d(_0x1b4845);return _0x5106a5();});});})[_0x10c797('0x58')](function(){const _0x2aa493=_0x10c797;return _0x4da220[_0x2aa493('0xba')](_0x376896,_0x58b7b1,function(_0x30b2a3){const _0x527422=_0x2aa493;_0x30b2a3?console['log'](_0x527422('0x51'),_0x30b2a3):fs[_0x527422('0xb2')](_0x376896);});});});}else return _0x4da220[_0x2a7c62('0xd0')](0xc8);})[_0x515abf('0x28')](handleError(_0x4da220,null));};
\ No newline at end of file
+const a406_0x4286=['sequelize','lastMsgBody','./mailInteraction.socket','c.phone','operator','value','length','fieldName','i.substatus','filter','text','tools_tags','forEach','merge','MailInteraction','mail_messages','isEmpty','lodash','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','intersection','t.id\x20=\x20it.TagId','SELECT','Sequelize','c.lastName','trimStart','some','rows','get','body','fullname','Contact.lastName','split','stack','pick','ids','rawAttributes','\x27\x27\x27\x27','i.to','buildExpression','moment','left_join','YYYY-MM-DD\x20HH:mm:ss','transcript-%d-%s.zip','c.firstName','from','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','`unreadMessages`\x20>\x200','getMailAccounts','sqlOperator','User','Account.mandatoryDisposition','unix','create','GROUP_CONCAT(DISTINCT\x20t.id)','Contact.firstName','getMessages','conditions','Messages','i.subject','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.ContactId','destroy','`\x20>\x200','journey','user','concat','../../mysqldb','findAll','o.internal','field','ContactId','format','status','server','Account.key','map','\x20=\x20?','color','a.mandatoryDisposition','findOne','nolimit','end','$substring','options','Users','$gte','query','isArray','eml-format','filters','omit','path','Contact','groupBy','Attachments','index','then','json','createdAt','download','unlinkSync','setTags','ui.MailInteractionId','mailInteractionTags:save','compact','../../components/parsers/qs','include','bcc','root','lastMsgText','order','mkdirSync','name','c.mobile','where','attributes','i.MailAccountId','fromString','offset','count','c.email\x20LIKE\x20?','MailMessage','DESC','having','limit','Tags','i.createdAt','parse','plainBody','i.MailAccountId\x20IN\x20?','unreadMessages','c.email','error','u.id\x20=\x20ui.UserId','`unreadMessages`\x20=\x200','model','register','Contact.mobile','`\x20=\x200','fields','addMessage','parseSearch','build','gte','emit','TagIds','Contact.phone','find','start','../../components/parsers/advancedSearch','files','users','err','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','keys','cm_contacts','MailInteractionId','u.id','existsSync','it.MailInteractionId\x20=\x20i.id','sendStatus','clone','i.closedAt','Bcc','Setting','select','attachments','params','zip-dir','MailAccountId','i.MailAccountId\x20IS\x20NULL','mail_interactions','squel','removeTags','Contact.fax','all','catch','Tag','tag','api','i.secondDisposition','getFullTextValue','util','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','update','writeFileSync','push','read','log','replace','sort','join','search','o.fullname','Owner.fullname','i.thirdDisposition','like','i.lastMsgDirection','i.id','each','describe','UserId','enableEmailPreview','keyBy','type','includeAll','ui.MailInteractionId\x20IN\x20?','undefined','headers','html-to-text','toString','subject','union','message%d.eml','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','i.lastMsgAt','rimraf','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','expr','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','a.key','o.id\x20=\x20i.UserId','i.MailAccountId\x20IS\x20NOT\x20NULL'];(function(_0x3fa7f9,_0x42867f){const _0x2d14fa=function(_0x1faf3c){while(--_0x1faf3c){_0x3fa7f9['push'](_0x3fa7f9['shift']());}};_0x2d14fa(++_0x42867f);}(a406_0x4286,0x1b8));const a406_0x2d14=function(_0x3fa7f9,_0x42867f){_0x3fa7f9=_0x3fa7f9-0x0;let _0x2d14fa=a406_0x4286[_0x3fa7f9];return _0x2d14fa;};const _0x31ee7c=a406_0x2d14;'use strict';const emlformat=require(_0x31ee7c('0x5e')),rimraf=require(_0x31ee7c('0xde')),zipdir=require(_0x31ee7c('0xae')),moment=require(_0x31ee7c('0x2d')),util=require(_0x31ee7c('0xbc')),path=require(_0x31ee7c('0x61')),fs=require('fs'),_=require(_0x31ee7c('0x17')),squel=require(_0x31ee7c('0xb2')),htmlToText=require(_0x31ee7c('0xd7')),{getSocket}=require('../../rediscache'),socket=getSocket(),qs=require(_0x31ee7c('0x6f')),as=require(_0x31ee7c('0x9b')),logger=require('../../config/logger')(_0x31ee7c('0xb9')),config=require('../../config/environment'),db=require(_0x31ee7c('0x48'))['db'],{Op}=require(_0x31ee7c('0x6'));require(_0x31ee7c('0x8'))[_0x31ee7c('0x8e')](socket);function respondWithStatusCode(_0x1faf3c,_0x34c487){return _0x34c487=_0x34c487||0xcc,function(_0xa02f63){const _0x5c12e9=a406_0x2d14;if(_0xa02f63)return _0x1faf3c[_0x5c12e9('0xa6')](_0x34c487);return _0x1faf3c[_0x5c12e9('0x4e')](_0x34c487)['end']();};}function respondWithResult(_0x42d324,_0xe3bd8d){return _0xe3bd8d=_0xe3bd8d||0xc8,function(_0x274ee9){const _0x5f3f19=a406_0x2d14;if(_0x274ee9)return _0x42d324['status'](_0xe3bd8d)[_0x5f3f19('0x67')](_0x274ee9);};}function respondWithFilteredResult(_0x3cfd6e,_0x514120){return function(_0x18a4a5){const _0x198e30=a406_0x2d14;if(_0x18a4a5){const _0x4115aa=_0x18a4a5[_0x198e30('0x7d')],_0x598ca9=_0x514120[_0x198e30('0x7c')];let _0x39b32a=_0x514120[_0x198e30('0x7c')]+_0x514120['limit'],_0x42ae18;return _0x39b32a>=_0x4115aa?(_0x39b32a=_0x4115aa,_0x42ae18=0xc8):_0x42ae18=0xce,_0x3cfd6e[_0x198e30('0x4e')](_0x42ae18),_0x3cfd6e['set']('Content-Range',_0x598ca9+'-'+_0x39b32a+'/'+_0x4115aa)[_0x198e30('0x67')](_0x18a4a5);}return null;};}function saveUpdates(_0x1cbc7c){return function(_0x3ffe18){const _0x4a274c=a406_0x2d14;if(_0x3ffe18)return _0x3ffe18[_0x4a274c('0xbe')](_0x1cbc7c)[_0x4a274c('0x66')](function(_0x5442ca){return _0x5442ca;});return null;};}function removeEntity(_0x8758d5){return function(_0x34dcff){const _0x50ba34=a406_0x2d14;if(_0x34dcff)return _0x34dcff['destroy']()[_0x50ba34('0x66')](function(){const _0x222db0=_0x50ba34;_0x8758d5[_0x222db0('0x4e')](0xcc)['end']();});};}function handleEntityNotFound(_0x2aadbb){return function(_0x42a122){return!_0x42a122&&_0x2aadbb['sendStatus'](0x194),_0x42a122;};}function handleError(_0x5dc660,_0x2ee911){return _0x2ee911=_0x2ee911||0x1f4,function(_0x4ec3c7){const _0x131fd2=a406_0x2d14;logger[_0x131fd2('0x8a')](_0x4ec3c7[_0x131fd2('0x26')]),_0x4ec3c7[_0x131fd2('0x76')]&&delete _0x4ec3c7[_0x131fd2('0x76')],_0x5dc660[_0x131fd2('0x4e')](_0x2ee911)['send'](_0x4ec3c7);};}function getInteractionUsers(_0x33965d,_0xcb5cbf){return new Promise(function(_0x13422e,_0x1e79ce){const _0x414a3c=a406_0x2d14;try{_0xcb5cbf[_0x33965d['id']]&&(_0x33965d[_0x414a3c('0x5a')]=_['map'](_0xcb5cbf[_0x33965d['id']],function(_0x1b8ed2){const _0x52aa5c=_0x414a3c;return{'id':_0x1b8ed2['id'],'fullname':_0x1b8ed2[_0x52aa5c('0x23')]};}));}catch(_0x4c835c){_0x1e79ce(_0x4c835c);}_0x13422e(_0x33965d);});}function getInteractionTags(_0x70ea64,_0x45d224){return new Promise(function(_0x48a547,_0x3e3ba5){const _0x4a2704=a406_0x2d14;try{_0x70ea64[_0x4a2704('0x97')]&&(_0x70ea64[_0x4a2704('0x83')]=[],_0x70ea64['TagIds'][_0x4a2704('0x25')](',')['forEach'](function(_0x6bfe6f){const _0x85e3af=_0x4a2704;_0x70ea64[_0x85e3af('0x83')][_0x85e3af('0xc0')](_0x45d224[_0x6bfe6f]);})),delete _0x70ea64[_0x4a2704('0x97')];}catch(_0x232490){_0x3e3ba5(_0x232490);}_0x48a547(_0x70ea64);});}function getLastMessageText(_0x4a7fd7){return new Promise(function(_0x38ef06,_0x4f8db1){const _0xc72a35=a406_0x2d14;return db[_0xc72a35('0x14')][_0xc72a35('0x55')]({'where':{'id':_0x4a7fd7['id']},'attributes':[_0xc72a35('0x7'),_0xc72a35('0x73')],'raw':!![]})[_0xc72a35('0x66')](function(_0x276131){const _0x4beb85=_0xc72a35;!_0x276131[_0x4beb85('0x73')]?_0x4a7fd7[_0x4beb85('0x73')]=_[_0x4beb85('0x1e')](htmlToText[_0x4beb85('0x7b')](_0x276131[_0x4beb85('0x7')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]})):_0x4a7fd7[_0x4beb85('0x73')]=_0x276131[_0x4beb85('0x73')],_0x38ef06(_0x4a7fd7);})[_0xc72a35('0xb6')](function(_0x397492){_0x4f8db1(_0x397492);});});}function updateMailInteraction(_0x171ae7,_0xee83f1,_0x4e43a2,_0x2e8af8){return new Promise(function(_0x4a20da,_0x6ea0f){const _0x1a45b2=a406_0x2d14;return getInteractionUsers(_0x171ae7,_0x4e43a2)[_0x1a45b2('0x66')](function(_0x58caa7){return getInteractionTags(_0x58caa7,_0xee83f1);})['then'](function(_0x1a0c63){_0x2e8af8?_0x4a20da(getLastMessageText(_0x1a0c63)):_0x4a20da(_0x1a0c63);})[_0x1a45b2('0xb6')](function(_0x31d603){_0x6ea0f(_0x31d603);});});}exports[_0x31ee7c('0x65')]=function(_0x29adc6,_0x5adb46){const _0x271b96=_0x31ee7c,_0x2a89af={},_0x143a6e={},_0x5e7403={'count':0x0,'rows':[]},_0x4f0c44=_[_0x271b96('0x51')](db[_0x271b96('0x14')][_0x271b96('0x29')],function(_0x1db761){const _0x419ca1=_0x271b96;return{'name':_0x1db761[_0x419ca1('0xd')],'type':_0x1db761[_0x419ca1('0xd2')]['key']};});_0x143a6e[_0x271b96('0x8d')]=_[_0x271b96('0x51')](_0x4f0c44,_0x271b96('0x76')),_0x143a6e['query']=_[_0x271b96('0xa0')](_0x29adc6[_0x271b96('0x5c')]),_0x143a6e[_0x271b96('0x5f')]=_['intersection'](_0x143a6e[_0x271b96('0x8d')],_0x143a6e['query']),_0x2a89af[_0x271b96('0x79')]=_[_0x271b96('0x19')](_0x143a6e[_0x271b96('0x8d')],qs[_0x271b96('0x91')](_0x29adc6['query'][_0x271b96('0x91')])),_0x2a89af['attributes']=_0x2a89af[_0x271b96('0x79')]['length']?_0x2a89af[_0x271b96('0x79')]:_0x143a6e[_0x271b96('0x8d')];typeof _0x29adc6[_0x271b96('0x5c')][_0x271b96('0x56')]===_0x271b96('0xd5')&&(_0x2a89af[_0x271b96('0x82')]=qs[_0x271b96('0x82')](_0x29adc6[_0x271b96('0x5c')][_0x271b96('0x82')]),_0x2a89af[_0x271b96('0x7c')]=qs[_0x271b96('0x7c')](_0x29adc6['query'][_0x271b96('0x7c')]));_0x2a89af[_0x271b96('0x74')]=qs[_0x271b96('0xc4')](_0x29adc6['query']['sort']),_0x2a89af[_0x271b96('0x78')]=qs['filters'](_[_0x271b96('0x27')](_0x29adc6[_0x271b96('0x5c')],_0x143a6e[_0x271b96('0x5f')]),_0x4f0c44);let _0x41412f=[];const _0x3711d2=squel[_0x271b96('0xab')]()['field']('id')[_0x271b96('0x4b')](_0x271b96('0x76'))[_0x271b96('0x4b')](_0x271b96('0x53'))[_0x271b96('0x32')](_0x271b96('0x11')),_0x5c697c=squel[_0x271b96('0xab')]()['field'](_0x271b96('0xa3'))['field']('u.fullname')['field'](_0x271b96('0x6c'))[_0x271b96('0x32')]('user_has_mail_interactions','ui')['left_join'](_0x271b96('0x9d'),'u',_0x271b96('0x8b')),_0x37d20c=squel[_0x271b96('0xab')]()[_0x271b96('0x32')](_0x271b96('0xb1'),'i')[_0x271b96('0x2e')](_0x271b96('0xa1'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')['left_join'](_0x271b96('0x9d'),'o',_0x271b96('0x4'))['left_join']('mail_accounts','a','a.id\x20=\x20i.MailAccountId')[_0x271b96('0x2e')](_0x271b96('0x15'),'me','me.MailInteractionId\x20=\x20i.id')[_0x271b96('0x2e')]('mail_interaction_has_tags','it',_0x271b96('0xa5'))[_0x271b96('0x2e')](_0x271b96('0x11'),'t',_0x271b96('0x1a')),_0x90f271=squel['expr']();let _0x468373=[];const _0x4b234e=squel[_0x271b96('0x1')]();let _0x4724ef;if(_0x29adc6[_0x271b96('0x5c')][_0x271b96('0xc6')]){_0x4724ef=as[_0x271b96('0x93')](_0x29adc6['query'][_0x271b96('0xc6')]);const _0x2e89bf=_0x4724ef[_0x271b96('0x36')];for(let _0x5e4812=0x0;_0x5e4812<_0x4724ef[_0x271b96('0x3e')][_0x271b96('0xc')];_0x5e4812++){const _0x432fea=_0x4724ef['conditions'][_0x5e4812],_0x19c651='i';let _0x2237b5,_0x18cdde=_[_0x271b96('0x99')](_0x4f0c44,[_0x271b96('0x76'),_0x432fea[_0x271b96('0x4b')]]);if(!_0x18cdde)switch(_0x432fea[_0x271b96('0x4b')]){case _0x271b96('0x88'):_0x432fea[_0x271b96('0xb')]==0x1?_0x37d20c['having']('`'+_0x432fea[_0x271b96('0x4b')]+_0x271b96('0x90')):_0x37d20c[_0x271b96('0x81')]('`'+_0x432fea[_0x271b96('0x4b')]+_0x271b96('0x44'));break;case _0x271b96('0x62'):if(_0x432fea['operator']===_0x271b96('0x58')){if(_0x432fea[_0x271b96('0xb')]['split']('\x20')[_0x271b96('0xc')]>0x1)_0x90f271[_0x2e89bf](_0x271b96('0x2'),qs[_0x271b96('0xbb')](_0x432fea['value']),null);else{const _0x583b4b='%'+_0x432fea[_0x271b96('0xb')]+'%';_0x90f271[_0x2e89bf]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x583b4b,_0x583b4b,_0x583b4b);}}else _0x18cdde=_[_0x271b96('0x99')](_0x4f0c44,[_0x271b96('0x76'),_0x271b96('0x4c')]),_0x432fea[_0x271b96('0x4b')]=_0x271b96('0x4c'),_0x2237b5=as[_0x271b96('0x2c')](_0x19c651,_0x18cdde[_0x271b96('0xd2')],_0x432fea),_0x90f271[_0x2e89bf](_0x2237b5[_0x271b96('0x10')],_0x2237b5[_0x271b96('0xb')][_0x271b96('0x9a')],_0x2237b5[_0x271b96('0xb')]['end']);break;case _0x271b96('0xb7'):{const _0x42f595=_0x432fea[_0x271b96('0xb')][_0x271b96('0x25')](',')[_0x271b96('0x51')](function(_0x16946e){return Number(_0x16946e);});_0x42f595[_0x271b96('0x12')](function(_0x4900e5){const _0x7a82cf=_0x271b96;_0x4b234e['or'](_0x7a82cf('0x0'),'%,'+_0x4900e5+',%');}),_0x468373=_[_0x271b96('0xda')](_0x468373,_0x42f595);}break;case _0x271b96('0x37'):_0x432fea[_0x271b96('0xa')]===_0x271b96('0x58')?_0x90f271[_0x2e89bf](_0x271b96('0x18'),'%'+_0x432fea[_0x271b96('0xb')]+'%',null):(_0x18cdde=_[_0x271b96('0x99')](_0x4f0c44,['name','UserId']),_0x432fea[_0x271b96('0x4b')]=_0x271b96('0xcf'),_0x2237b5=as[_0x271b96('0x2c')](_0x19c651,_0x18cdde[_0x271b96('0xd2')],_0x432fea),_0x90f271[_0x2e89bf](_0x2237b5[_0x271b96('0x10')],_0x2237b5[_0x271b96('0xb')][_0x271b96('0x9a')],_0x2237b5[_0x271b96('0xb')][_0x271b96('0x57')]));break;case _0x271b96('0x86'):_0x2237b5=as[_0x271b96('0x2c')]('me',null,_0x432fea),_0x90f271[_0x2e89bf](_0x2237b5['text'],_0x2237b5[_0x271b96('0xb')][_0x271b96('0x9a')],_0x2237b5[_0x271b96('0xb')][_0x271b96('0x57')]);break;}else _0x2237b5=as[_0x271b96('0x2c')](_0x19c651,_0x18cdde[_0x271b96('0xd2')],_0x432fea),_0x90f271[_0x2e89bf](_0x2237b5['text'],_0x2237b5[_0x271b96('0xb')]['start'],_0x2237b5['value'][_0x271b96('0x57')]);}}else{const _0x41022d=_(_0x29adc6['query'])[_0x271b96('0xa0')]()[_0x271b96('0x51')](function(_0x2f3e84){const _0x4adbf2=_0x271b96;return _[_0x4adbf2('0x1f')](_0x4f0c44,[_0x4adbf2('0x76'),_0x2f3e84])?_0x2f3e84:undefined;})[_0x271b96('0x6e')]()[_0x271b96('0xb')]();!_['isEmpty'](_0x41022d)&&_0x41022d[_0x271b96('0x12')](function(_0x3b2bf0){const _0x1cfa2f=_0x271b96;if(_0x3b2bf0===_0x1cfa2f('0xaf'))_0x37d20c['where'](_0x1cfa2f('0x87'),[][_0x1cfa2f('0x47')](_0x29adc6[_0x1cfa2f('0x5c')][_0x3b2bf0]));else{if(_0x3b2bf0==='createdAt'){const _0x2458f3=JSON[_0x1cfa2f('0x85')](_0x29adc6[_0x1cfa2f('0x5c')][_0x3b2bf0])[_0x1cfa2f('0x5b')],_0xfb6a8e=JSON[_0x1cfa2f('0x85')](_0x29adc6[_0x1cfa2f('0x5c')][_0x3b2bf0])['$lte'];_0x37d20c['where'](_0x1cfa2f('0x33'),_0x2458f3,_0xfb6a8e);}else _0x29adc6[_0x1cfa2f('0x5c')][_0x3b2bf0]==='null'?_0x37d20c[_0x1cfa2f('0x78')]('i.'+_0x3b2bf0+'\x20IS\x20NULL'):_0x37d20c[_0x1cfa2f('0x78')]('i.'+_0x3b2bf0+_0x1cfa2f('0x52'),_0x29adc6['query'][_0x3b2bf0]);}});_0x29adc6[_0x271b96('0x5c')][_0x271b96('0xc1')]&&(_0x29adc6['query'][_0x271b96('0xc1')]==0x1?_0x37d20c['having'](_0x271b96('0x8c')):_0x37d20c[_0x271b96('0x81')](_0x271b96('0x34')));_0x29adc6[_0x271b96('0x5c')][_0x271b96('0xb8')]&&(_0x468373=_[_0x271b96('0x5d')](_0x29adc6[_0x271b96('0x5c')][_0x271b96('0xb8')])?_0x29adc6[_0x271b96('0x5c')]['tag']:new Array(_0x29adc6[_0x271b96('0x5c')][_0x271b96('0xb8')]),_0x468373['forEach'](function(_0x802e89){const _0x4c3798=_0x271b96;_0x4b234e['or'](_0x4c3798('0x0'),'%,'+_0x802e89+',%');}));if(_0x29adc6[_0x271b96('0x5c')][_0x271b96('0xf')]){const _0x737b31=_0x29adc6[_0x271b96('0x5c')]['filter'][_0x271b96('0xc3')]('\x5c','\x5c\x5c')[_0x271b96('0xc3')]('\x27\x27',_0x271b96('0x2a'));if(qs['isNumeric'](_0x737b31))_0x90f271['or']('i.id\x20LIKE\x20?',_0x737b31+'%');else qs['isEmail'](_0x737b31)?_0x90f271['or'](_0x271b96('0x7e'),_0x737b31+'%'):_0x90f271['or'](_0x271b96('0x9f'),qs[_0x271b96('0xbb')](_0x737b31))['or'](_0x271b96('0x41'),qs[_0x271b96('0xbb')](_0x737b31));}}_0x37d20c[_0x271b96('0x78')](_0x90f271),_0x37d20c['group'](_0x271b96('0xcc'));let _0xd5b446={'type':db[_0x271b96('0x1c')]['QueryTypes'][_0x271b96('0x1b')],'raw':!![]};const _0x5e1dea=_0x37d20c[_0x271b96('0xa7')]();_0x5e1dea[_0x271b96('0x4b')](_0x271b96('0xcc')),_0x5e1dea['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x271b96('0x88')),_0x2a89af[_0x271b96('0x74')]&&_0x2a89af['order']['forEach'](function(_0x3250c3){const _0x355284=_0x271b96;_0x37d20c['order']('i.'+_0x3250c3[0x0],_0x3250c3[0x1]===_0x355284('0x80')?![]:!![]);}),!_[_0x271b96('0x16')](_0x468373)&&(_0x37d20c[_0x271b96('0x81')](_0x4b234e),_0x5e1dea[_0x271b96('0x78')]('t.id\x20IN\x20?',_0x468373)),Promise['resolve']()['then'](function(){const _0x156cfd=_0x271b96;if(!_0x4724ef){if(_0x29adc6['query'][_0x156cfd('0xaf')]||_0x29adc6[_0x156cfd('0x5c')][_0x156cfd('0x45')])return;_0x5e1dea['where'](_0x156cfd('0x5')),_0x37d20c[_0x156cfd('0x78')](_0x156cfd('0x5'));return;}return _0x29adc6[_0x156cfd('0x46')][_0x156cfd('0x35')]({'attributes':['id'],'raw':!![]})[_0x156cfd('0x66')](function(_0x41272c){const _0x172b68=_0x156cfd;_[_0x172b68('0x16')](_0x41272c)?(_0x5e1dea[_0x172b68('0x78')](_0x172b68('0xb0')),_0x37d20c[_0x172b68('0x78')](_0x172b68('0xb0'))):(_0x5e1dea['where'](_0x172b68('0x87'),_['map'](_0x41272c,'id')),_0x37d20c[_0x172b68('0x78')](_0x172b68('0x87'),_[_0x172b68('0x51')](_0x41272c,'id')));});})['then'](function(){const _0x173124=_0x271b96;db[_0x173124('0x6')][_0x173124('0x5c')](_0x5e1dea[_0x173124('0xd8')](),_0xd5b446)[_0x173124('0x66')](function(_0x146b13){const _0x2dc174=_0x173124;_0x5e7403[_0x2dc174('0x7d')]=_0x146b13[_0x2dc174('0xc')];if(_0x5e7403['count']===0x0)return[];return db['sequelize'][_0x2dc174('0x5c')](_0x3711d2[_0x2dc174('0xd8')](),_0xd5b446)[_0x2dc174('0x66')](function(_0x158281){const _0x1e78cf=_0x2dc174;_0x41412f=_[_0x1e78cf('0xd1')](_0x158281,'id'),_0xd5b446=_['merge'](_0xd5b446,{'model':db[_0x1e78cf('0x14')],'mapToModel':!![],'raw':!![],'nest':!![]});_0x29adc6['query'][_0x1e78cf('0x91')]?_0x2a89af[_0x1e78cf('0x79')][_0x1e78cf('0x12')](function(_0x26497c){const _0x56b00c=_0x1e78cf;_0x37d20c[_0x56b00c('0x4b')]('i.'+_0x26497c);}):(_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0xbd'),'unreadMessages'),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x3'),_0x1e78cf('0x50')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x54'),_0x1e78cf('0x38')),_0x37d20c['field']('i.id'),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x84')),_0x37d20c[_0x1e78cf('0x4b')]('i.updatedAt'),_0x37d20c[_0x1e78cf('0x4b')]('i.closed'),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0xa8')),_0x37d20c['field']('i.attach'),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0xdd')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0xcb')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x40')),_0x37d20c[_0x1e78cf('0x4b')]('i.disposition'),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0xba')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0xc9')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0xe')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x2b')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x42')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x7a')),_0x37d20c[_0x1e78cf('0x4b')]('i.UserId'),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x31'),_0x1e78cf('0x3c')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x1d'),_0x1e78cf('0x24')),_0x37d20c['field'](_0x1e78cf('0x89'),'Contact.email'),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x9'),_0x1e78cf('0x98')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x77'),_0x1e78cf('0x8f')),_0x37d20c['field']('c.fax',_0x1e78cf('0xb4')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0xc7'),_0x1e78cf('0xc8')),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x4a'),'Owner.internal'),_0x37d20c[_0x1e78cf('0x4b')](_0x1e78cf('0x3b'),'TagIds'));if(_0x2a89af[_0x1e78cf('0x82')])_0x37d20c[_0x1e78cf('0x82')](_0x2a89af[_0x1e78cf('0x82')]);if(_0x2a89af[_0x1e78cf('0x7c')])_0x37d20c[_0x1e78cf('0x7c')](_0x2a89af[_0x1e78cf('0x7c')]);return db[_0x1e78cf('0x6')][_0x1e78cf('0x5c')](_0x37d20c[_0x1e78cf('0xd8')](),_0xd5b446);})[_0x2dc174('0x66')](function(_0x1d24ad){const _0x4ab063=_0x2dc174;return _0x5c697c[_0x4ab063('0x78')](_0x4ab063('0xd4'),_[_0x4ab063('0x51')](_0x1d24ad,'id')),db[_0x4ab063('0x6')][_0x4ab063('0x5c')](_0x5c697c[_0x4ab063('0xd8')](),_0xd5b446)[_0x4ab063('0x66')](function(_0xa74663){const _0x7f7309=_0x4ab063,_0x5a216e=_[_0x7f7309('0x63')](_0xa74663,_0x7f7309('0xa2')),_0x105a9d=[];return db[_0x7f7309('0xaa')][_0x7f7309('0x55')]({'attributes':[_0x7f7309('0xd0')],'raw':!![]})[_0x7f7309('0x66')](function(_0x574081){const _0x1125ba=_0x7f7309,_0x57a7d6=_0x574081[_0x1125ba('0xd0')];return _0x1d24ad[_0x1125ba('0x12')](function(_0x21fe1f){const _0x44597e=_0x1125ba;_0x105a9d[_0x44597e('0xc0')](updateMailInteraction(_0x21fe1f,_0x41412f,_0x5a216e,_0x57a7d6));}),Promise[_0x1125ba('0xb5')](_0x105a9d);});});});})[_0x173124('0x66')](function(_0x4f3ccd){return _0x5e7403['rows']=_0x4f3ccd,_0x5e7403;})['then'](respondWithFilteredResult(_0x5adb46,_0x2a89af));})[_0x271b96('0xb6')](handleError(_0x5adb46,null));},exports['show']=function(_0xcf59b8,_0x4fef02){const _0x394081=_0x31ee7c;let _0x5e57b9={'raw':![],'where':{'id':_0xcf59b8[_0x394081('0xad')]['id']}};const _0x4d81b7={};return _0x4d81b7[_0x394081('0x8d')]=_['keys'](db[_0x394081('0x14')]['rawAttributes']),_0x4d81b7['query']=_[_0x394081('0xa0')](_0xcf59b8['query']),_0x4d81b7['filters']=_['intersection'](_0x4d81b7[_0x394081('0x8d')],_0x4d81b7['query']),_0x5e57b9['attributes']=_[_0x394081('0x19')](_0x4d81b7[_0x394081('0x8d')],qs[_0x394081('0x91')](_0xcf59b8[_0x394081('0x5c')]['fields'])),_0x5e57b9[_0x394081('0x79')]=_0x5e57b9[_0x394081('0x79')]['length']?_0x5e57b9[_0x394081('0x79')]:_0x4d81b7[_0x394081('0x8d')],_0xcf59b8['query'][_0x394081('0xd3')]&&(_0x5e57b9['include']=[{'all':!![]}]),_0x5e57b9=_[_0x394081('0x13')]({},_0x5e57b9,_0xcf59b8['options']),db['MailInteraction'][_0x394081('0x55')](_0x5e57b9)[_0x394081('0x66')](handleEntityNotFound(_0x4fef02,null))[_0x394081('0x66')](respondWithResult(_0x4fef02,null))[_0x394081('0xb6')](handleError(_0x4fef02,null));},exports[_0x31ee7c('0x3a')]=function(_0x4a587a,_0x39f4a8){const _0x439b1b=_0x31ee7c;return db[_0x439b1b('0x14')]['create'](_0x4a587a[_0x439b1b('0x22')],{})[_0x439b1b('0x66')](respondWithResult(_0x39f4a8,0xc9))[_0x439b1b('0xb6')](handleError(_0x39f4a8,null));},exports[_0x31ee7c('0xbe')]=function(_0x1883fe,_0x5462ca){const _0x837129=_0x31ee7c;return _0x1883fe[_0x837129('0x22')]['id']&&delete _0x1883fe[_0x837129('0x22')]['id'],db[_0x837129('0x14')][_0x837129('0x55')]({'where':{'id':_0x1883fe[_0x837129('0xad')]['id']}})[_0x837129('0x66')](handleEntityNotFound(_0x5462ca,null))[_0x837129('0x66')](saveUpdates(_0x1883fe['body'],null))[_0x837129('0x66')](respondWithResult(_0x5462ca,null))['catch'](handleError(_0x5462ca,null));},exports[_0x31ee7c('0x43')]=function(_0xf5b757,_0x2cbb1d){const _0x568f66=_0x31ee7c;return db[_0x568f66('0x14')]['findOne']({'where':{'id':_0xf5b757[_0x568f66('0xad')]['id']}})[_0x568f66('0x66')](handleEntityNotFound(_0x2cbb1d,null))[_0x568f66('0x66')](removeEntity(_0x2cbb1d,null))[_0x568f66('0xb6')](handleError(_0x2cbb1d,null));},exports[_0x31ee7c('0xce')]=function(_0x1a0653,_0x3a1743){const _0x2c8103=_0x31ee7c;return db[_0x2c8103('0x14')][_0x2c8103('0xce')]()[_0x2c8103('0x66')](respondWithResult(_0x3a1743,null))[_0x2c8103('0xb6')](handleError(_0x3a1743,null));},exports[_0x31ee7c('0x92')]=function(_0x1a21df,_0x24d9fc){const _0x42b6fd=_0x31ee7c;return db[_0x42b6fd('0x7f')][_0x42b6fd('0x55')]({'where':{'id':_0x1a21df[_0x42b6fd('0xad')]['id']}})[_0x42b6fd('0x66')](function(_0x54bafd){const _0x4e1d48=_0x42b6fd;if(_0x54bafd)return _0x54bafd[_0x4e1d48('0x92')](_0x1a21df[_0x4e1d48('0x22')][_0x4e1d48('0x28')],{'through':_[_0x4e1d48('0x60')](_0x1a21df[_0x4e1d48('0x22')],[_0x4e1d48('0x28'),'id'])});})[_0x42b6fd('0x66')](respondWithResult(_0x24d9fc,null))[_0x42b6fd('0xb6')](handleError(_0x24d9fc,null));},exports[_0x31ee7c('0x3d')]=function(_0xb6a324,_0x8066c7){const _0x3c1e8f=_0x31ee7c;let _0x2351b5={'raw':![],'where':{}};const _0x22cf60={},_0x2acc3f={'count':0x0,'rows':[]};return db[_0x3c1e8f('0x14')][_0x3c1e8f('0x55')]({'where':{'id':_0xb6a324[_0x3c1e8f('0xad')]['id']}})[_0x3c1e8f('0x66')](handleEntityNotFound(_0x8066c7,null))[_0x3c1e8f('0x66')](function(_0x581dcd){const _0x1e7ecd=_0x3c1e8f;if(_0x581dcd){_0x22cf60[_0x1e7ecd('0x8d')]=_[_0x1e7ecd('0xa0')](db[_0x1e7ecd('0x7f')][_0x1e7ecd('0x29')]),_0x22cf60[_0x1e7ecd('0x5c')]=_[_0x1e7ecd('0xa0')](_0xb6a324[_0x1e7ecd('0x5c')]),_0x22cf60['filters']=_[_0x1e7ecd('0x19')](_0x22cf60[_0x1e7ecd('0x8d')],_0x22cf60[_0x1e7ecd('0x5c')]),_0x2351b5[_0x1e7ecd('0x79')]=_[_0x1e7ecd('0x19')](_0x22cf60['model'],qs['fields'](_0xb6a324[_0x1e7ecd('0x5c')]['fields'])),_0x2351b5['attributes']=_0x2351b5[_0x1e7ecd('0x79')][_0x1e7ecd('0xc')]?_0x2351b5[_0x1e7ecd('0x79')]:_0x22cf60[_0x1e7ecd('0x8d')];typeof _0xb6a324['query']['nolimit']===_0x1e7ecd('0xd5')&&(_0x2351b5['limit']=qs[_0x1e7ecd('0x82')](_0xb6a324['query'][_0x1e7ecd('0x82')]),_0x2351b5[_0x1e7ecd('0x7c')]=qs[_0x1e7ecd('0x7c')](_0xb6a324[_0x1e7ecd('0x5c')]['offset']));_0x2351b5[_0x1e7ecd('0x74')]=qs[_0x1e7ecd('0xc4')](_0xb6a324[_0x1e7ecd('0x5c')][_0x1e7ecd('0xc4')]),_0x2351b5[_0x1e7ecd('0x78')]=qs[_0x1e7ecd('0x5f')](_[_0x1e7ecd('0x27')](_0xb6a324['query'],_0x22cf60[_0x1e7ecd('0x5f')])),_0x2351b5[_0x1e7ecd('0x78')][_0x1e7ecd('0xa2')]=_0x581dcd['id'];_0xb6a324[_0x1e7ecd('0x5c')]['filter']&&(_0x2351b5[_0x1e7ecd('0x78')]=_[_0x1e7ecd('0x13')](_0x2351b5[_0x1e7ecd('0x78')],{[Op['or']]:_[_0x1e7ecd('0x51')](_0x2351b5['attributes'],function(_0x37a505){const _0x3f487b=_0x1e7ecd,_0x2cfb80={};return _0x2cfb80[_0x37a505]={[Op[_0x3f487b('0xca')]]:'%'+_0xb6a324['query'][_0x3f487b('0xf')]+'%'},_0x2cfb80;})}));if(_0xb6a324[_0x1e7ecd('0x5c')][_0x1e7ecd('0x5b')]){const _0x183914=_0xb6a324[_0x1e7ecd('0x5c')][_0x1e7ecd('0x5b')][_0x1e7ecd('0x25')](','),_0x20adea={};_0x20adea[_0x183914[0x0]]={[Op[_0x1e7ecd('0x95')]]:moment(_0x183914[0x1])[_0x1e7ecd('0x4d')](_0x1e7ecd('0x2f'))},_0x2351b5['where']=_[_0x1e7ecd('0x13')](_0x2351b5[_0x1e7ecd('0x78')],_0x20adea);}return _0x2351b5=_[_0x1e7ecd('0x13')]({},_0x2351b5,_0xb6a324[_0x1e7ecd('0x59')]),db[_0x1e7ecd('0x7f')]['count']({'where':_0x2351b5[_0x1e7ecd('0x78')]})[_0x1e7ecd('0x66')](function(_0x2c5a11){const _0x54c4ce=_0x1e7ecd;return _0x2acc3f[_0x54c4ce('0x7d')]=_0x2c5a11,_0xb6a324[_0x54c4ce('0x5c')][_0x54c4ce('0xd3')]&&(_0x2351b5[_0x54c4ce('0x70')]=[{'all':!![]}]),db[_0x54c4ce('0x7f')][_0x54c4ce('0x49')](_0x2351b5);})['then'](function(_0xa98a3d){const _0x267b02=_0x1e7ecd;return _0x2acc3f[_0x267b02('0x20')]=_0xa98a3d,_0x2acc3f;});}})[_0x3c1e8f('0x66')](respondWithFilteredResult(_0x8066c7,_0x2351b5))[_0x3c1e8f('0xb6')](handleError(_0x8066c7,null));},exports['addTags']=function(_0x1dd3e6,_0x172969){const _0x5eef41=_0x31ee7c;return db[_0x5eef41('0x14')][_0x5eef41('0x55')]({'where':{'id':_0x1dd3e6[_0x5eef41('0xad')]['id']}})[_0x5eef41('0x66')](function(_0x13776e){const _0x2aba63=_0x5eef41;if(_0x13776e)return _0x13776e[_0x2aba63('0x6b')](_0x1dd3e6[_0x2aba63('0x22')][_0x2aba63('0x28')],{'through':_['omit'](_0x1dd3e6['body'],[_0x2aba63('0x28'),'id'])})['then'](function(){const _0x204ab3=_0x2aba63;return db['Tag']['findAll']({'attributes':['id',_0x204ab3('0x76'),_0x204ab3('0x53')],'where':{'id':_0x1dd3e6[_0x204ab3('0x22')][_0x204ab3('0x28')]}});})[_0x2aba63('0x66')](function(_0x1a85a0){const _0x2cd1eb=_0x2aba63;return socket[_0x2cd1eb('0x96')](_0x2cd1eb('0x6d'),{'id':Number(_0x1dd3e6['params']['id']),'tags':_0x1a85a0||[]}),{'id':Number(_0x1dd3e6[_0x2cd1eb('0xad')]['id']),'tags':_0x1a85a0||[]};});})[_0x5eef41('0x66')](respondWithResult(_0x172969,null))['catch'](handleError(_0x172969,null));},exports[_0x31ee7c('0xb3')]=function(_0xe40fc8,_0x416ca6){const _0x4b75e7=_0x31ee7c;return db[_0x4b75e7('0x14')]['findOne']({'where':{'id':_0xe40fc8[_0x4b75e7('0xad')]['id']}})[_0x4b75e7('0x66')](handleEntityNotFound(_0x416ca6,null))[_0x4b75e7('0x66')](function(_0x459e1d){const _0x3c6fe4=_0x4b75e7;if(_0x459e1d)return _0x459e1d['removeTags'](_0xe40fc8[_0x3c6fe4('0x5c')][_0x3c6fe4('0x28')]);})[_0x4b75e7('0x66')](respondWithStatusCode(_0x416ca6,null))[_0x4b75e7('0xb6')](handleError(_0x416ca6,null));},exports[_0x31ee7c('0x69')]=function(_0xb83e97,_0x5c0c02){const _0x3e67f8=_0x31ee7c,_0x5d3951=moment()[_0x3e67f8('0x39')]()[_0x3e67f8('0xd8')](),_0x5537db=path[_0x3e67f8('0xc5')](config[_0x3e67f8('0x72')],_0x3e67f8('0x9c'),'tmp'),_0x51413d=path[_0x3e67f8('0xc5')](config[_0x3e67f8('0x72')],_0x3e67f8('0x4f'),_0x3e67f8('0x9c'),_0x3e67f8('0xac')),_0x5755e6=path['join'](_0x5537db,_0x5d3951),_0x5cae71=util[_0x3e67f8('0x4d')](_0x3e67f8('0x30'),_0xb83e97[_0x3e67f8('0xad')]['id'],_0x5d3951),_0x54b335=path[_0x3e67f8('0xc5')](_0x5537db,_0x5cae71),_0x1c2a8e=[];_0xb83e97[_0x3e67f8('0x5c')][_0x3e67f8('0xac')]&&_0x1c2a8e[_0x3e67f8('0xc0')]({'model':db['Attachment'],'as':'Attachments','raw':!![]});const _0x2201b3=[{'model':db[_0x3e67f8('0x7f')],'as':_0x3e67f8('0x3f'),'attributes':['id','body',_0x3e67f8('0x32'),'to','cc',_0x3e67f8('0x71'),_0x3e67f8('0xd9'),'createdAt'],'where':{'secret':![]},'order':qs[_0x3e67f8('0xc4')]('id'),'include':_0x1c2a8e}];return db[_0x3e67f8('0x14')][_0x3e67f8('0x55')]({'where':{'id':_0xb83e97[_0x3e67f8('0xad')]['id']},'include':_0x2201b3})[_0x3e67f8('0x66')](handleEntityNotFound(_0x5c0c02,null))[_0x3e67f8('0x66')](function(_0x1ee838){const _0xccbb21=_0x3e67f8;if(_0x1ee838&&_0x1ee838['Messages']){const _0xd59dfa=_0x1ee838[_0xccbb21('0x21')]({'plain':!![]});return fs[_0xccbb21('0x75')](_0x5755e6),Promise[_0xccbb21('0xcd')](_0xd59dfa['Messages'],function(_0x149c46,_0x4731f3){const _0x115ca6=_0xccbb21,_0x82b09a={'from':_0x149c46[_0x115ca6('0x32')],'to':_0x149c46['to'],'subject':_0x149c46['subject'],'html':_0x149c46[_0x115ca6('0x22')],'headers':{'Date':moment(_0x149c46[_0x115ca6('0x68')])[_0x115ca6('0x4d')](_0x115ca6('0xdc'))},'attachments':[]};return _0x149c46['cc']&&(_0x82b09a[_0x115ca6('0xd6')]['Cc']=_0x149c46['cc']),_0x149c46[_0x115ca6('0x71')]&&(_0x82b09a['headers'][_0x115ca6('0xa9')]=_0x149c46['bcc']),new Promise(function(_0x521e64,_0x68cf31){const _0x2bfde3=_0x115ca6;if(_0x149c46[_0x2bfde3('0x64')])for(let _0x424da2=0x0;_0x424da2<_0x149c46['Attachments'][_0x2bfde3('0xc')];_0x424da2++){const _0x256862=_0x149c46[_0x2bfde3('0x64')][_0x424da2],_0x5b6a11=path['join'](_0x51413d,_0x256862['basename']);fs[_0x2bfde3('0xa4')](_0x5b6a11)&&_0x82b09a[_0x2bfde3('0xac')][_0x2bfde3('0xc0')]({'name':_0x256862[_0x2bfde3('0x76')],'contentType':_0x256862['type'],'data':fs['readFileSync'](_0x5b6a11)});}emlformat[_0x2bfde3('0x94')](_0x82b09a,function(_0x524ed1,_0x14d672){const _0x362fa2=_0x2bfde3;if(_0x524ed1)return _0x68cf31(_0x524ed1);return fs[_0x362fa2('0xbf')](path[_0x362fa2('0xc5')](_0x5755e6,util['format'](_0x362fa2('0xdb'),_0x4731f3)),_0x14d672),_0x521e64(_0x14d672);});});})[_0xccbb21('0x66')](function(){const _0x384277=_0xccbb21;return new Promise(function(_0x16a899,_0x46bc2e){zipdir(_0x5755e6,{'saveTo':_0x54b335},function(_0x18459f,_0x109c15){if(_0x18459f)return _0x46bc2e(_0x18459f);return _0x16a899(_0x109c15);});})[_0x384277('0x66')](function(){return new Promise(function(_0x18d46f,_0x4caf43){rimraf(_0x5755e6,function(_0x45249a){if(_0x45249a)_0x4caf43(_0x45249a);return _0x18d46f();});});})[_0x384277('0x66')](function(){return _0x5c0c02['download'](_0x54b335,_0x5cae71,function(_0x3b4d12){const _0xeed42d=a406_0x2d14;_0x3b4d12?console[_0xeed42d('0xc2')](_0xeed42d('0x9e'),_0x3b4d12):fs[_0xeed42d('0x6a')](_0x54b335);});});});}else return _0x5c0c02['sendStatus'](0xc8);})[_0x3e67f8('0xb6')](handleError(_0x5c0c02,null));};
\ No newline at end of file