-const a489_0x15d9=['i.disposition','mail_accounts','catch','length','emit','SELECT','download','headers','show','util','i.secondDisposition','YYYY-MM-DD\x20HH:mm:ss','operator','it.MailInteractionId\x20=\x20i.id','eml-format','pick','filter','DESC','c.firstName','sqlOperator','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','count','Users','expr','get','join','attributes','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','groupBy','i.lastMsgDirection','parse','o.fullname','start','server','forEach','`\x20=\x200','u.id','../../components/parsers/advancedSearch','concat','limit','tag','like','set','getFullTextValue','format','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.MailAccountId\x20IN\x20?','c.mobile','i.createdAt','text','options','lastMsgBody','mailInteractionTags:save','select','i.to','toString','addTags','ui.MailInteractionId','find','squel','key','params','files','model','a.mandatoryDisposition','resolve','me.MailInteractionId\x20=\x20i.id','`unreadMessages`\x20=\x200','having','i.ContactId','zip-dir','Tag','fieldName','u.id\x20=\x20ui.UserId','Contact.lastName','a.key','writeFileSync','i.MailAccountId','i.substatus','sendStatus','sequelize','\x20IS\x20NULL','path','register','html-to-text','json','i.MailAccountId\x20IS\x20NOT\x20NULL','user','../../config/environment','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','left_join','mkdirSync','i.id','removeTags','Contact.email','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','include','trimStart','order','o.id\x20=\x20i.UserId','describe','push','MailMessage','unreadMessages','user_has_mail_interactions','i.attach','../../components/parsers/qs','i.MailAccountId\x20IS\x20NULL','Messages','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','Tags','transcript-%d-%s.zip','destroy','Attachment','body','isArray','User','where','unix','journey','mail_interactions','index','TagIds','update','i.subject','MailAccountId','cm_contacts','stack','unlinkSync','i.lastMsgAt','lastMsgText','users','all','c.phone','query','plainBody','value','$substring','attachments','$gte','err','Contact.fax','../../rediscache','UserId','merge','ids','from','includeAll','sort','basename','nolimit','addMessage','ui.MailInteractionId\x20IN\x20?','i.updatedAt','Owner.fullname','status','message%d.eml','isEmpty','offset','t.id\x20IN\x20?','search','rawAttributes','../../config/logger','Contact.mobile','rimraf','type','GROUP_CONCAT(DISTINCT\x20t.id)','union','keys','split','replace','c.fax','error','root','../../mysqldb','i.closedAt','buildExpression','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','end','Contact','./mailInteraction.socket','rows','subject','tmp','field','moment','then','getMessages','c.lastName','Contact.phone','existsSync','MailInteraction','findOne','createdAt','api','ContactId','enableEmailPreview','fields','i.id\x20LIKE\x20?','filters','conditions','isEmail','mail_interaction_has_tags','fullname','readFileSync','name','create','some','read','null','map','intersection','Attachments','MailInteractionId','findAll','bcc'];(function(_0x267992,_0x79a1e3){const _0x15d9d1=function(_0x2686ce){while(--_0x2686ce){_0x267992['push'](_0x267992['shift']());}};_0x15d9d1(++_0x79a1e3);}(a489_0x15d9,0x17b));const a489_0x2686=function(_0x267992,_0x79a1e3){_0x267992=_0x267992-0xfb;let _0x15d9d1=a489_0x15d9[_0x267992];return _0x15d9d1;};const a489_0x3f7ce3=a489_0x2686;'use strict';const emlformat=require(a489_0x3f7ce3(0x13e)),rimraf=require(a489_0x3f7ce3(0xfc)),zipdir=require(a489_0x3f7ce3(0x176)),moment=require(a489_0x3f7ce3(0x111)),util=require(a489_0x3f7ce3(0x139)),path=require(a489_0x3f7ce3(0x182)),fs=require('fs'),_=require('lodash'),squel=require(a489_0x3f7ce3(0x16b)),{htmlToText}=require(a489_0x3f7ce3(0x184)),{getSocket}=require(a489_0x3f7ce3(0x1be)),socket=getSocket(),qs=require(a489_0x3f7ce3(0x19a)),as=require(a489_0x3f7ce3(0x155)),logger=require(a489_0x3f7ce3(0x1d2))(a489_0x3f7ce3(0x11a)),config=require(a489_0x3f7ce3(0x188)),{db}=require(a489_0x3f7ce3(0x106)),{Op,QueryTypes}=require(a489_0x3f7ce3(0x180));require(a489_0x3f7ce3(0x10c))[a489_0x3f7ce3(0x183)](socket);function respondWithStatusCode(_0x59c945,_0x4f85c3){return _0x4f85c3=_0x4f85c3||0xcc,function(_0x34d0ad){const _0x39d25f=a489_0x2686;if(_0x34d0ad)return _0x59c945[_0x39d25f(0x17f)](_0x4f85c3);return _0x59c945[_0x39d25f(0x1cb)](_0x4f85c3)[_0x39d25f(0x10a)]();};}function respondWithResult(_0x3b21e6,_0x187182){return _0x187182=_0x187182||0xc8,function(_0x1eef09){const _0x514de0=a489_0x2686;if(_0x1eef09)return _0x3b21e6[_0x514de0(0x1cb)](_0x187182)[_0x514de0(0x185)](_0x1eef09);};}function respondWithFilteredResult(_0xa2b328,_0xdb5239){return function(_0xb1935){const _0x353074=a489_0x2686;if(_0xb1935){const _0x4e6ca0=_0xb1935[_0x353074(0x145)],_0x327d83=_0xdb5239[_0x353074(0x1ce)];let _0x4f7532=_0xdb5239[_0x353074(0x1ce)]+_0xdb5239[_0x353074(0x157)],_0x4f75c3;return _0x4f7532>=_0x4e6ca0?(_0x4f7532=_0x4e6ca0,_0x4f75c3=0xc8):_0x4f75c3=0xce,_0xa2b328[_0x353074(0x1cb)](_0x4f75c3),_0xa2b328[_0x353074(0x15a)]('Content-Range',_0x327d83+'-'+_0x4f7532+'/'+_0x4e6ca0)[_0x353074(0x185)](_0xb1935);}return null;};}function saveUpdates(_0x295ca9){return function(_0x3d2cfd){const _0x1b1b55=a489_0x2686;if(_0x3d2cfd)return _0x3d2cfd[_0x1b1b55(0x1ab)](_0x295ca9)[_0x1b1b55(0x112)](function(_0x3b0b12){return _0x3b0b12;});return null;};}function removeEntity(_0x14f75a){return function(_0x38fe43){const _0x3926c9=a489_0x2686;if(_0x38fe43)return _0x38fe43[_0x3926c9(0x1a0)]()[_0x3926c9(0x112)](function(){const _0x3d2432=_0x3926c9;_0x14f75a[_0x3d2432(0x1cb)](0xcc)[_0x3d2432(0x10a)]();});};}function handleEntityNotFound(_0x407535){return function(_0x198ba9){const _0x30879c=a489_0x2686;return!_0x198ba9&&_0x407535[_0x30879c(0x17f)](0x194),_0x198ba9;};}function handleError(_0x58c36d,_0x438a2c){return _0x438a2c=_0x438a2c||0x1f4,function(_0x55ad0c){const _0xb3f1f7=a489_0x2686;logger[_0xb3f1f7(0x104)](_0x55ad0c[_0xb3f1f7(0x1af)]),_0x55ad0c[_0xb3f1f7(0x125)]&&delete _0x55ad0c['name'],_0x58c36d[_0xb3f1f7(0x1cb)](_0x438a2c)['send'](_0x55ad0c);};}function getInteractionUsers(_0x195040,_0x118345){return new Promise(function(_0x19e14e,_0x44cd66){const _0x35a4f6=a489_0x2686;try{_0x118345[_0x195040['id']]&&(_0x195040[_0x35a4f6(0x146)]=_[_0x35a4f6(0x12a)](_0x118345[_0x195040['id']],function(_0x242e86){const _0x15f103=_0x35a4f6;return{'id':_0x242e86['id'],'fullname':_0x242e86[_0x15f103(0x123)]};}));}catch(_0x1d5627){_0x44cd66(_0x1d5627);}_0x19e14e(_0x195040);});}function getInteractionTags(_0x3a1611,_0x521a30){return new Promise(function(_0x13ac32,_0xabe2b5){const _0x28ea23=a489_0x2686;try{_0x3a1611['TagIds']&&(_0x3a1611[_0x28ea23(0x19e)]=[],_0x3a1611[_0x28ea23(0x1aa)][_0x28ea23(0x101)](',')['forEach'](function(_0x3f0d1a){const _0x52c64a=_0x28ea23;_0x3a1611[_0x52c64a(0x19e)]['push'](_0x521a30[_0x3f0d1a]);})),delete _0x3a1611[_0x28ea23(0x1aa)];}catch(_0x1b7acf){_0xabe2b5(_0x1b7acf);}_0x13ac32(_0x3a1611);});}function getLastMessageText(_0x2880c5){return new Promise(function(_0x2c3e08,_0x3b683a){const _0x1181c3=a489_0x2686;return db[_0x1181c3(0x117)][_0x1181c3(0x118)]({'where':{'id':_0x2880c5['id']},'attributes':[_0x1181c3(0x163),_0x1181c3(0x1b2)],'raw':!![]})[_0x1181c3(0x112)](function(_0xf68365){const _0x70d105=_0x1181c3;!_0xf68365[_0x70d105(0x1b2)]?_0x2880c5[_0x70d105(0x1b2)]=_[_0x70d105(0x191)](htmlToText(_0xf68365[_0x70d105(0x163)],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]})):_0x2880c5['lastMsgText']=_0xf68365['lastMsgText'],_0x2c3e08(_0x2880c5);})['catch'](function(_0x4d758c){_0x3b683a(_0x4d758c);});});}function updateMailInteraction(_0x12d27e,_0x32862d,_0x173c37,_0x452215){return new Promise(function(_0x2ada23,_0x29402d){const _0x33cc58=a489_0x2686;return getInteractionUsers(_0x12d27e,_0x173c37)['then'](function(_0x4205eb){return getInteractionTags(_0x4205eb,_0x32862d);})[_0x33cc58(0x112)](function(_0x1b2422){_0x452215?_0x2ada23(getLastMessageText(_0x1b2422)):_0x2ada23(_0x1b2422);})[_0x33cc58(0x132)](function(_0x4d30d4){_0x29402d(_0x4d30d4);});});}exports[a489_0x3f7ce3(0x1a9)]=function(_0x3b3f59,_0x15e608){const _0x2cb856=a489_0x3f7ce3,_0x549b0a={},_0xa75def={},_0x3e8879={'count':0x0,'rows':[]},_0x16cf97=_[_0x2cb856(0x12a)](db[_0x2cb856(0x117)][_0x2cb856(0x1d1)],function(_0x2cec71){const _0x44c5b3=_0x2cb856;return{'name':_0x2cec71[_0x44c5b3(0x178)],'type':_0x2cec71['type'][_0x44c5b3(0x16c)]};});_0xa75def[_0x2cb856(0x16f)]=_['map'](_0x16cf97,_0x2cb856(0x125)),_0xa75def[_0x2cb856(0x1b6)]=_['keys'](_0x3b3f59['query']),_0xa75def['filters']=_[_0x2cb856(0x12b)](_0xa75def[_0x2cb856(0x16f)],_0xa75def[_0x2cb856(0x1b6)]),_0x549b0a['attributes']=_[_0x2cb856(0x12b)](_0xa75def[_0x2cb856(0x16f)],qs[_0x2cb856(0x11d)](_0x3b3f59[_0x2cb856(0x1b6)]['fields'])),_0x549b0a[_0x2cb856(0x14a)]=_0x549b0a['attributes'][_0x2cb856(0x133)]?_0x549b0a[_0x2cb856(0x14a)]:_0xa75def[_0x2cb856(0x16f)];typeof _0x3b3f59[_0x2cb856(0x1b6)][_0x2cb856(0x1c6)]==='undefined'&&(_0x549b0a['limit']=qs[_0x2cb856(0x157)](_0x3b3f59[_0x2cb856(0x1b6)]['limit']),_0x549b0a['offset']=qs['offset'](_0x3b3f59[_0x2cb856(0x1b6)][_0x2cb856(0x1ce)]));_0x549b0a[_0x2cb856(0x192)]=qs[_0x2cb856(0x1c4)](_0x3b3f59[_0x2cb856(0x1b6)][_0x2cb856(0x1c4)]),_0x549b0a[_0x2cb856(0x1a5)]=qs['filters'](_[_0x2cb856(0x13f)](_0x3b3f59['query'],_0xa75def[_0x2cb856(0x11f)]),_0x16cf97);let _0xa2c1d9=[];const _0x2a6bc8=squel[_0x2cb856(0x165)]()['field']('id')['field']('name')[_0x2cb856(0x110)]('color')[_0x2cb856(0x1c2)]('tools_tags'),_0x26a95d=squel['select']()[_0x2cb856(0x110)](_0x2cb856(0x154))[_0x2cb856(0x110)]('u.fullname')[_0x2cb856(0x110)](_0x2cb856(0x169))[_0x2cb856(0x1c2)](_0x2cb856(0x198),'ui')[_0x2cb856(0x18a)](_0x2cb856(0x1b3),'u',_0x2cb856(0x179)),_0xb44c3f=squel['select']()[_0x2cb856(0x1c2)](_0x2cb856(0x1a8),'i')[_0x2cb856(0x18a)](_0x2cb856(0x1ae),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x2cb856(0x18a)](_0x2cb856(0x1b3),'o',_0x2cb856(0x193))['left_join'](_0x2cb856(0x131),'a','a.id\x20=\x20i.MailAccountId')['left_join']('mail_messages','me',_0x2cb856(0x172))[_0x2cb856(0x18a)](_0x2cb856(0x122),'it',_0x2cb856(0x13d))[_0x2cb856(0x18a)]('tools_tags','t','t.id\x20=\x20it.TagId'),_0x15a832=squel[_0x2cb856(0x147)]();let _0xed1cff=[];const _0xf43d9e=squel[_0x2cb856(0x147)]();let _0x32bbfc;if(_0x3b3f59[_0x2cb856(0x1b6)][_0x2cb856(0x1d0)]){_0x32bbfc=as['parseSearch'](_0x3b3f59['query'][_0x2cb856(0x1d0)]);const _0x245fa6=_0x32bbfc[_0x2cb856(0x143)];for(let _0x529b60=0x0;_0x529b60<_0x32bbfc[_0x2cb856(0x120)][_0x2cb856(0x133)];_0x529b60++){const _0x1e3378=_0x32bbfc[_0x2cb856(0x120)][_0x529b60],_0xac4392='i';let _0x75367c,_0x5aea1f=_[_0x2cb856(0x16a)](_0x16cf97,[_0x2cb856(0x125),_0x1e3378[_0x2cb856(0x110)]]);if(!_0x5aea1f)switch(_0x1e3378['field']){case _0x2cb856(0x197):_0x1e3378[_0x2cb856(0x1b8)]==0x1?_0xb44c3f['having']('`'+_0x1e3378[_0x2cb856(0x110)]+_0x2cb856(0x153)):_0xb44c3f['having']('`'+_0x1e3378[_0x2cb856(0x110)]+'`\x20>\x200');break;case _0x2cb856(0x10b):if(_0x1e3378[_0x2cb856(0x13c)]===_0x2cb856(0x1b9)){if(_0x1e3378[_0x2cb856(0x1b8)]['split']('\x20')['length']>0x1)_0x15a832[_0x245fa6](_0x2cb856(0x18f),qs[_0x2cb856(0x15b)](_0x1e3378[_0x2cb856(0x1b8)]),null);else{const _0x40b1dc='%'+_0x1e3378['value']+'%';_0x15a832[_0x245fa6](_0x2cb856(0x14b),_0x40b1dc,_0x40b1dc,_0x40b1dc);}}else _0x5aea1f=_[_0x2cb856(0x16a)](_0x16cf97,[_0x2cb856(0x125),_0x2cb856(0x11b)]),_0x1e3378[_0x2cb856(0x110)]=_0x2cb856(0x11b),_0x75367c=as['buildExpression'](_0xac4392,_0x5aea1f[_0x2cb856(0xfd)],_0x1e3378),_0x15a832[_0x245fa6](_0x75367c[_0x2cb856(0x161)],_0x75367c[_0x2cb856(0x1b8)][_0x2cb856(0x150)],_0x75367c[_0x2cb856(0x1b8)][_0x2cb856(0x10a)]);break;case _0x2cb856(0x177):{const _0x1c16c1=_0x1e3378[_0x2cb856(0x1b8)][_0x2cb856(0x101)](',')[_0x2cb856(0x12a)](function(_0x569a63){return Number(_0x569a63);});_0x1c16c1[_0x2cb856(0x152)](function(_0x2570b8){_0xf43d9e['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x2570b8+',%');}),_0xed1cff=_[_0x2cb856(0xff)](_0xed1cff,_0x1c16c1);}break;case _0x2cb856(0x1a4):_0x1e3378['operator']===_0x2cb856(0x1b9)?_0x15a832[_0x245fa6]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x1e3378[_0x2cb856(0x1b8)]+'%',null):(_0x5aea1f=_[_0x2cb856(0x16a)](_0x16cf97,[_0x2cb856(0x125),_0x2cb856(0x1bf)]),_0x1e3378['field']=_0x2cb856(0x1bf),_0x75367c=as[_0x2cb856(0x108)](_0xac4392,_0x5aea1f[_0x2cb856(0xfd)],_0x1e3378),_0x15a832[_0x245fa6](_0x75367c[_0x2cb856(0x161)],_0x75367c[_0x2cb856(0x1b8)][_0x2cb856(0x150)],_0x75367c[_0x2cb856(0x1b8)][_0x2cb856(0x10a)]));break;case _0x2cb856(0x1b7):_0x75367c=as['buildExpression']('me',null,_0x1e3378),_0x15a832[_0x245fa6](_0x75367c['text'],_0x75367c[_0x2cb856(0x1b8)][_0x2cb856(0x150)],_0x75367c[_0x2cb856(0x1b8)][_0x2cb856(0x10a)]);break;}else _0x75367c=as['buildExpression'](_0xac4392,_0x5aea1f['type'],_0x1e3378),_0x15a832[_0x245fa6](_0x75367c[_0x2cb856(0x161)],_0x75367c[_0x2cb856(0x1b8)][_0x2cb856(0x150)],_0x75367c[_0x2cb856(0x1b8)]['end']);}}else{const _0x4aafc9=_(_0x3b3f59[_0x2cb856(0x1b6)])[_0x2cb856(0x100)]()[_0x2cb856(0x12a)](function(_0x4730e2){const _0x258fa3=_0x2cb856;return _[_0x258fa3(0x127)](_0x16cf97,['name',_0x4730e2])?_0x4730e2:undefined;})['compact']()[_0x2cb856(0x1b8)]();!_[_0x2cb856(0x1cd)](_0x4aafc9)&&_0x4aafc9[_0x2cb856(0x152)](function(_0x55dc10){const _0x41c6ca=_0x2cb856;if(_0x55dc10===_0x41c6ca(0x1ad))_0xb44c3f[_0x41c6ca(0x1a5)](_0x41c6ca(0x15e),[][_0x41c6ca(0x156)](_0x3b3f59[_0x41c6ca(0x1b6)][_0x55dc10]));else{if(_0x55dc10===_0x41c6ca(0x119)){const _0x5eb26b=JSON[_0x41c6ca(0x14e)](_0x3b3f59['query'][_0x55dc10])[_0x41c6ca(0x1bb)],_0x2d7be2=JSON['parse'](_0x3b3f59[_0x41c6ca(0x1b6)][_0x55dc10])['$lte'];_0xb44c3f[_0x41c6ca(0x1a5)](_0x41c6ca(0x189),_0x5eb26b,_0x2d7be2);}else _0x3b3f59[_0x41c6ca(0x1b6)][_0x55dc10]===_0x41c6ca(0x129)?_0xb44c3f['where']('i.'+_0x55dc10+_0x41c6ca(0x181)):_0xb44c3f['where']('i.'+_0x55dc10+'\x20=\x20?',_0x3b3f59[_0x41c6ca(0x1b6)][_0x55dc10]);}});_0x3b3f59['query']['read']&&(_0x3b3f59[_0x2cb856(0x1b6)][_0x2cb856(0x128)]==0x1?_0xb44c3f[_0x2cb856(0x174)](_0x2cb856(0x173)):_0xb44c3f[_0x2cb856(0x174)]('`unreadMessages`\x20>\x200'));_0x3b3f59[_0x2cb856(0x1b6)]['tag']&&(_0xed1cff=_[_0x2cb856(0x1a3)](_0x3b3f59[_0x2cb856(0x1b6)][_0x2cb856(0x158)])?_0x3b3f59[_0x2cb856(0x1b6)]['tag']:new Array(_0x3b3f59[_0x2cb856(0x1b6)][_0x2cb856(0x158)]),_0xed1cff[_0x2cb856(0x152)](function(_0x2d0a28){const _0x15484a=_0x2cb856;_0xf43d9e['or'](_0x15484a(0x19d),'%,'+_0x2d0a28+',%');}));if(_0x3b3f59[_0x2cb856(0x1b6)]['filter']){const _0x945a38=_0x3b3f59[_0x2cb856(0x1b6)][_0x2cb856(0x140)][_0x2cb856(0x102)]('\x5c','\x5c\x5c')[_0x2cb856(0x102)](/'/g,'\x27\x27');if(qs['isNumeric'](_0x945a38))_0x15a832['or'](_0x2cb856(0x11e),_0x945a38+'%');else qs[_0x2cb856(0x121)](_0x945a38)?_0x15a832['or']('c.email\x20LIKE\x20?',_0x945a38+'%'):_0x15a832['or'](_0x2cb856(0x109),qs['getFullTextValue'](_0x945a38))['or'](_0x2cb856(0x15d),qs[_0x2cb856(0x15b)](_0x945a38));}}_0xb44c3f[_0x2cb856(0x1a5)](_0x15a832),_0xb44c3f['group'](_0x2cb856(0x18c));let _0x5bdb6f={'type':QueryTypes[_0x2cb856(0x135)],'raw':!![]};const _0x476317=_0xb44c3f['clone']();_0x476317['field'](_0x2cb856(0x18c)),_0x476317[_0x2cb856(0x110)](_0x2cb856(0x144),_0x2cb856(0x197)),_0x549b0a[_0x2cb856(0x192)]&&_0x549b0a['order'][_0x2cb856(0x152)](function(_0x18f29c){const _0x4df1f9=_0x2cb856;_0xb44c3f['order']('i.'+_0x18f29c[0x0],_0x18f29c[0x1]===_0x4df1f9(0x141)?![]:!![]);}),!_[_0x2cb856(0x1cd)](_0xed1cff)&&(_0xb44c3f[_0x2cb856(0x174)](_0xf43d9e),_0x476317['where'](_0x2cb856(0x1cf),_0xed1cff)),Promise[_0x2cb856(0x171)]()[_0x2cb856(0x112)](function(){const _0x2eb075=_0x2cb856;if(!_0x32bbfc){if(_0x3b3f59[_0x2eb075(0x1b6)][_0x2eb075(0x1ad)]||_0x3b3f59[_0x2eb075(0x1b6)][_0x2eb075(0x1a7)])return;_0x476317[_0x2eb075(0x1a5)](_0x2eb075(0x186)),_0xb44c3f['where'](_0x2eb075(0x186));return;}return _0x3b3f59[_0x2eb075(0x187)]['getMailAccounts']({'attributes':['id'],'raw':!![]})['then'](function(_0x683f85){const _0x44af7d=_0x2eb075;_[_0x44af7d(0x1cd)](_0x683f85)?(_0x476317[_0x44af7d(0x1a5)]('i.MailAccountId\x20IS\x20NULL'),_0xb44c3f[_0x44af7d(0x1a5)](_0x44af7d(0x19b))):(_0x476317[_0x44af7d(0x1a5)]('i.MailAccountId\x20IN\x20?',_['map'](_0x683f85,'id')),_0xb44c3f[_0x44af7d(0x1a5)](_0x44af7d(0x15e),_[_0x44af7d(0x12a)](_0x683f85,'id')));});})[_0x2cb856(0x112)](function(){const _0x2f8db9=_0x2cb856;db[_0x2f8db9(0x180)]['query'](_0x476317[_0x2f8db9(0x167)](),_0x5bdb6f)[_0x2f8db9(0x112)](function(_0x19cdcf){const _0x524a20=_0x2f8db9;_0x3e8879[_0x524a20(0x145)]=_0x19cdcf[_0x524a20(0x133)];if(_0x3e8879['count']===0x0)return[];return db['sequelize'][_0x524a20(0x1b6)](_0x2a6bc8[_0x524a20(0x167)](),_0x5bdb6f)[_0x524a20(0x112)](function(_0x52094b){const _0x531049=_0x524a20;_0xa2c1d9=_['keyBy'](_0x52094b,'id'),_0x5bdb6f=_[_0x531049(0x1c0)](_0x5bdb6f,{'model':db[_0x531049(0x117)],'mapToModel':!![],'raw':!![],'nest':!![]});_0x3b3f59[_0x531049(0x1b6)][_0x531049(0x11d)]?_0x549b0a[_0x531049(0x14a)][_0x531049(0x152)](function(_0x3ccd80){_0xb44c3f['field']('i.'+_0x3ccd80);}):(_0xb44c3f['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages'),_0xb44c3f[_0x531049(0x110)](_0x531049(0x17b),'Account.key'),_0xb44c3f[_0x531049(0x110)](_0x531049(0x170),'Account.mandatoryDisposition'),_0xb44c3f['field'](_0x531049(0x18c)),_0xb44c3f['field'](_0x531049(0x160)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x1c9)),_0xb44c3f['field']('i.closed'),_0xb44c3f['field'](_0x531049(0x107)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x199)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x1b1)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x14d)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x1ac)),_0xb44c3f['field'](_0x531049(0x130)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x13a)),_0xb44c3f[_0x531049(0x110)]('i.thirdDisposition'),_0xb44c3f[_0x531049(0x110)](_0x531049(0x17e)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x166)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x175)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x17d)),_0xb44c3f['field']('i.UserId'),_0xb44c3f['field'](_0x531049(0x142),'Contact.firstName'),_0xb44c3f['field'](_0x531049(0x114),_0x531049(0x17a)),_0xb44c3f['field']('c.email',_0x531049(0x18e)),_0xb44c3f['field'](_0x531049(0x1b5),_0x531049(0x115)),_0xb44c3f['field'](_0x531049(0x15f),_0x531049(0xfb)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x103),_0x531049(0x1bd)),_0xb44c3f[_0x531049(0x110)](_0x531049(0x14f),_0x531049(0x1ca)),_0xb44c3f[_0x531049(0x110)]('o.internal','Owner.internal'),_0xb44c3f[_0x531049(0x110)](_0x531049(0xfe),'TagIds'));if(_0x549b0a['limit'])_0xb44c3f[_0x531049(0x157)](_0x549b0a[_0x531049(0x157)]);if(_0x549b0a[_0x531049(0x1ce)])_0xb44c3f[_0x531049(0x1ce)](_0x549b0a['offset']);return db[_0x531049(0x180)]['query'](_0xb44c3f['toString'](),_0x5bdb6f);})[_0x524a20(0x112)](function(_0x5122bc){const _0x3f2ffb=_0x524a20;return _0x26a95d['where'](_0x3f2ffb(0x1c8),_['map'](_0x5122bc,'id')),db[_0x3f2ffb(0x180)][_0x3f2ffb(0x1b6)](_0x26a95d[_0x3f2ffb(0x167)](),_0x5bdb6f)[_0x3f2ffb(0x112)](function(_0x710235){const _0x1d868b=_0x3f2ffb,_0x142a03=_[_0x1d868b(0x14c)](_0x710235,'MailInteractionId'),_0x3b245f=[];return db['Setting'][_0x1d868b(0x118)]({'attributes':['enableEmailPreview'],'raw':!![]})[_0x1d868b(0x112)](function(_0x1bc811){const _0x5b05d9=_0x1d868b,_0x31a26f=_0x1bc811[_0x5b05d9(0x11c)];return _0x5122bc[_0x5b05d9(0x152)](function(_0x506d4d){const _0x3ab4b9=_0x5b05d9;_0x3b245f[_0x3ab4b9(0x195)](updateMailInteraction(_0x506d4d,_0xa2c1d9,_0x142a03,_0x31a26f));}),Promise['all'](_0x3b245f);});});});})[_0x2f8db9(0x112)](function(_0x3fbc44){const _0x2ab66f=_0x2f8db9;return _0x3e8879[_0x2ab66f(0x10d)]=_0x3fbc44,_0x3e8879;})[_0x2f8db9(0x112)](respondWithFilteredResult(_0x15e608,_0x549b0a));})[_0x2cb856(0x132)](handleError(_0x15e608,null));},exports[a489_0x3f7ce3(0x138)]=function(_0xc64c69,_0x592f9d){const _0x5ad0f3=a489_0x3f7ce3;let _0x3f48f2={'raw':![],'where':{'id':_0xc64c69[_0x5ad0f3(0x16d)]['id']}};const _0x41e415={};return _0x41e415[_0x5ad0f3(0x16f)]=_['keys'](db[_0x5ad0f3(0x117)]['rawAttributes']),_0x41e415['query']=_[_0x5ad0f3(0x100)](_0xc64c69['query']),_0x41e415['filters']=_[_0x5ad0f3(0x12b)](_0x41e415[_0x5ad0f3(0x16f)],_0x41e415[_0x5ad0f3(0x1b6)]),_0x3f48f2['attributes']=_[_0x5ad0f3(0x12b)](_0x41e415['model'],qs['fields'](_0xc64c69[_0x5ad0f3(0x1b6)]['fields'])),_0x3f48f2[_0x5ad0f3(0x14a)]=_0x3f48f2['attributes'][_0x5ad0f3(0x133)]?_0x3f48f2[_0x5ad0f3(0x14a)]:_0x41e415[_0x5ad0f3(0x16f)],_0xc64c69['query'][_0x5ad0f3(0x1c3)]&&(_0x3f48f2['include']=[{'all':!![]}]),_0x3f48f2=_['merge']({},_0x3f48f2,_0xc64c69['options']),db['MailInteraction']['findOne'](_0x3f48f2)['then'](handleEntityNotFound(_0x592f9d,null))['then'](respondWithResult(_0x592f9d,null))[_0x5ad0f3(0x132)](handleError(_0x592f9d,null));},exports['create']=function(_0x10b15a,_0x4878ff){const _0x584133=a489_0x3f7ce3;return db['MailInteraction'][_0x584133(0x126)](_0x10b15a[_0x584133(0x1a2)],{})[_0x584133(0x112)](respondWithResult(_0x4878ff,0xc9))[_0x584133(0x132)](handleError(_0x4878ff,null));},exports[a489_0x3f7ce3(0x1ab)]=function(_0x27bffb,_0x314647){const _0x495224=a489_0x3f7ce3;return _0x27bffb[_0x495224(0x1a2)]['id']&&delete _0x27bffb[_0x495224(0x1a2)]['id'],db[_0x495224(0x117)][_0x495224(0x118)]({'where':{'id':_0x27bffb[_0x495224(0x16d)]['id']}})[_0x495224(0x112)](handleEntityNotFound(_0x314647,null))[_0x495224(0x112)](saveUpdates(_0x27bffb[_0x495224(0x1a2)],null))[_0x495224(0x112)](respondWithResult(_0x314647,null))['catch'](handleError(_0x314647,null));},exports['destroy']=function(_0x51adbc,_0x5d6b1a){const _0x3fa90b=a489_0x3f7ce3;return db[_0x3fa90b(0x117)][_0x3fa90b(0x118)]({'where':{'id':_0x51adbc['params']['id']}})[_0x3fa90b(0x112)](handleEntityNotFound(_0x5d6b1a,null))[_0x3fa90b(0x112)](removeEntity(_0x5d6b1a,null))[_0x3fa90b(0x132)](handleError(_0x5d6b1a,null));},exports[a489_0x3f7ce3(0x194)]=function(_0x39a2a5,_0x3f9c2f){const _0x20c170=a489_0x3f7ce3;return db[_0x20c170(0x117)]['describe']()[_0x20c170(0x112)](respondWithResult(_0x3f9c2f,null))[_0x20c170(0x132)](handleError(_0x3f9c2f,null));},exports[a489_0x3f7ce3(0x1c7)]=function(_0x1a03cc,_0xb53905){const _0x172e3a=a489_0x3f7ce3;return db[_0x172e3a(0x196)]['findOne']({'where':{'id':_0x1a03cc['params']['id']}})['then'](function(_0x5e6e87){const _0x1afdb4=_0x172e3a;if(_0x5e6e87)return _0x5e6e87['addMessage'](_0x1a03cc[_0x1afdb4(0x1a2)][_0x1afdb4(0x1c1)],{'through':_['omit'](_0x1a03cc[_0x1afdb4(0x1a2)],[_0x1afdb4(0x1c1),'id'])});})[_0x172e3a(0x112)](respondWithResult(_0xb53905,null))['catch'](handleError(_0xb53905,null));},exports[a489_0x3f7ce3(0x113)]=function(_0x5aae79,_0x167f30){const _0x3b9773=a489_0x3f7ce3;let _0x336732={'raw':![],'where':{}};const _0x5b98f8={},_0x5eaa3c={'count':0x0,'rows':[]};return db[_0x3b9773(0x117)]['findOne']({'where':{'id':_0x5aae79['params']['id']}})[_0x3b9773(0x112)](handleEntityNotFound(_0x167f30,null))[_0x3b9773(0x112)](function(_0x2b3e9f){const _0x229c34=_0x3b9773;if(_0x2b3e9f){_0x5b98f8['model']=_[_0x229c34(0x100)](db[_0x229c34(0x196)][_0x229c34(0x1d1)]),_0x5b98f8['query']=_['keys'](_0x5aae79['query']),_0x5b98f8['filters']=_['intersection'](_0x5b98f8[_0x229c34(0x16f)],_0x5b98f8[_0x229c34(0x1b6)]),_0x336732[_0x229c34(0x14a)]=_[_0x229c34(0x12b)](_0x5b98f8[_0x229c34(0x16f)],qs[_0x229c34(0x11d)](_0x5aae79[_0x229c34(0x1b6)][_0x229c34(0x11d)])),_0x336732[_0x229c34(0x14a)]=_0x336732['attributes'][_0x229c34(0x133)]?_0x336732['attributes']:_0x5b98f8[_0x229c34(0x16f)];typeof _0x5aae79['query']['nolimit']==='undefined'&&(_0x336732[_0x229c34(0x157)]=qs[_0x229c34(0x157)](_0x5aae79[_0x229c34(0x1b6)][_0x229c34(0x157)]),_0x336732['offset']=qs['offset'](_0x5aae79[_0x229c34(0x1b6)][_0x229c34(0x1ce)]));_0x336732['order']=qs['sort'](_0x5aae79[_0x229c34(0x1b6)][_0x229c34(0x1c4)]),_0x336732[_0x229c34(0x1a5)]=qs[_0x229c34(0x11f)](_[_0x229c34(0x13f)](_0x5aae79[_0x229c34(0x1b6)],_0x5b98f8[_0x229c34(0x11f)])),_0x336732[_0x229c34(0x1a5)][_0x229c34(0x12d)]=_0x2b3e9f['id'];_0x5aae79[_0x229c34(0x1b6)][_0x229c34(0x140)]&&(_0x336732['where']=_[_0x229c34(0x1c0)](_0x336732['where'],{[Op['or']]:_[_0x229c34(0x12a)](_0x336732[_0x229c34(0x14a)],function(_0xb871af){const _0x828cbd=_0x229c34,_0x33acf9={};return _0x33acf9[_0xb871af]={[Op[_0x828cbd(0x159)]]:'%'+_0x5aae79[_0x828cbd(0x1b6)]['filter']+'%'},_0x33acf9;})}));if(_0x5aae79[_0x229c34(0x1b6)][_0x229c34(0x1bb)]){const _0x5805a7=_0x5aae79['query'][_0x229c34(0x1bb)]['split'](','),_0x62fe21={};_0x62fe21[_0x5805a7[0x0]]={[Op['gte']]:moment(_0x5805a7[0x1])[_0x229c34(0x15c)](_0x229c34(0x13b))},_0x336732['where']=_['merge'](_0x336732[_0x229c34(0x1a5)],_0x62fe21);}return _0x336732=_[_0x229c34(0x1c0)]({},_0x336732,_0x5aae79[_0x229c34(0x162)]),db[_0x229c34(0x196)][_0x229c34(0x145)]({'where':_0x336732[_0x229c34(0x1a5)]})['then'](function(_0x55a5f5){const _0x176398=_0x229c34;return _0x5eaa3c[_0x176398(0x145)]=_0x55a5f5,_0x5aae79[_0x176398(0x1b6)][_0x176398(0x1c3)]&&(_0x336732[_0x176398(0x190)]=[{'all':!![]}]),db[_0x176398(0x196)][_0x176398(0x12e)](_0x336732);})['then'](function(_0x2324bf){const _0x57bb88=_0x229c34;return _0x5eaa3c[_0x57bb88(0x10d)]=_0x2324bf,_0x5eaa3c;});}})['then'](respondWithFilteredResult(_0x167f30,_0x336732))[_0x3b9773(0x132)](handleError(_0x167f30,null));},exports[a489_0x3f7ce3(0x168)]=function(_0x579296,_0x517ea2){const _0x156cf9=a489_0x3f7ce3;return db[_0x156cf9(0x117)][_0x156cf9(0x118)]({'where':{'id':_0x579296['params']['id']}})[_0x156cf9(0x112)](function(_0x3580de){const _0x50988d=_0x156cf9;if(_0x3580de)return _0x3580de['setTags'](_0x579296[_0x50988d(0x1a2)]['ids'],{'through':_['omit'](_0x579296['body'],[_0x50988d(0x1c1),'id'])})['then'](function(){const _0xe2e90a=_0x50988d;return db[_0xe2e90a(0x177)][_0xe2e90a(0x12e)]({'attributes':['id',_0xe2e90a(0x125),'color'],'where':{'id':_0x579296[_0xe2e90a(0x1a2)]['ids']}});})['then'](function(_0x3bfdb8){const _0x3035e2=_0x50988d;return socket[_0x3035e2(0x134)](_0x3035e2(0x164),{'id':Number(_0x579296[_0x3035e2(0x16d)]['id']),'tags':_0x3bfdb8||[]}),{'id':Number(_0x579296['params']['id']),'tags':_0x3bfdb8||[]};});})[_0x156cf9(0x112)](respondWithResult(_0x517ea2,null))[_0x156cf9(0x132)](handleError(_0x517ea2,null));},exports[a489_0x3f7ce3(0x18d)]=function(_0x4f33d6,_0x4bf6d3){const _0x4d70ea=a489_0x3f7ce3;return db[_0x4d70ea(0x117)]['findOne']({'where':{'id':_0x4f33d6[_0x4d70ea(0x16d)]['id']}})[_0x4d70ea(0x112)](handleEntityNotFound(_0x4bf6d3,null))[_0x4d70ea(0x112)](function(_0x375dad){const _0x255b4b=_0x4d70ea;if(_0x375dad)return _0x375dad[_0x255b4b(0x18d)](_0x4f33d6[_0x255b4b(0x1b6)][_0x255b4b(0x1c1)]);})[_0x4d70ea(0x112)](respondWithStatusCode(_0x4bf6d3,null))[_0x4d70ea(0x132)](handleError(_0x4bf6d3,null));},exports[a489_0x3f7ce3(0x136)]=function(_0x6f2656,_0x42b21a){const _0x21ed65=a489_0x3f7ce3,_0x1ea096=moment()[_0x21ed65(0x1a6)]()[_0x21ed65(0x167)](),_0x2956e0=path[_0x21ed65(0x149)](config[_0x21ed65(0x105)],'files',_0x21ed65(0x10f)),_0x29b0ee=path[_0x21ed65(0x149)](config[_0x21ed65(0x105)],_0x21ed65(0x151),_0x21ed65(0x16e),_0x21ed65(0x1ba)),_0x1d4117=path[_0x21ed65(0x149)](_0x2956e0,_0x1ea096),_0x1b09a5=util[_0x21ed65(0x15c)](_0x21ed65(0x19f),_0x6f2656['params']['id'],_0x1ea096),_0x5c3a06=path['join'](_0x2956e0,_0x1b09a5),_0x4590e8=[];_0x6f2656['query'][_0x21ed65(0x1ba)]&&_0x4590e8[_0x21ed65(0x195)]({'model':db[_0x21ed65(0x1a1)],'as':_0x21ed65(0x12c),'raw':!![]});const _0x502db3=[{'model':db[_0x21ed65(0x196)],'as':_0x21ed65(0x19c),'attributes':['id',_0x21ed65(0x1a2),_0x21ed65(0x1c2),'to','cc',_0x21ed65(0x12f),_0x21ed65(0x10e),_0x21ed65(0x119)],'where':{'secret':![]},'order':qs['sort']('id'),'include':_0x4590e8}];return db['MailInteraction'][_0x21ed65(0x118)]({'where':{'id':_0x6f2656[_0x21ed65(0x16d)]['id']},'include':_0x502db3})[_0x21ed65(0x112)](handleEntityNotFound(_0x42b21a,null))['then'](function(_0x3993ce){const _0x2805c6=_0x21ed65;if(_0x3993ce&&_0x3993ce[_0x2805c6(0x19c)]){const _0x37fc28=_0x3993ce[_0x2805c6(0x148)]({'plain':!![]});return fs[_0x2805c6(0x18b)](_0x1d4117),Promise[_0x2805c6(0x1b4)](_0x37fc28[_0x2805c6(0x19c)][_0x2805c6(0x12a)]((_0x57e87b,_0x3a8f51)=>{const _0x48181f=_0x2805c6,_0x25b3c0={'from':_0x57e87b[_0x48181f(0x1c2)],'to':_0x57e87b['to'],'subject':_0x57e87b[_0x48181f(0x10e)],'html':_0x57e87b[_0x48181f(0x1a2)],'headers':{'Date':moment(_0x57e87b[_0x48181f(0x119)])['format']('ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ')},'attachments':[]};return _0x57e87b['cc']&&(_0x25b3c0[_0x48181f(0x137)]['Cc']=_0x57e87b['cc']),_0x57e87b[_0x48181f(0x12f)]&&(_0x25b3c0[_0x48181f(0x137)]['Bcc']=_0x57e87b['bcc']),new Promise(function(_0x5ea20d,_0xfdd371){const _0x62bcb=_0x48181f;if(_0x57e87b[_0x62bcb(0x12c)])for(let _0x9507b0=0x0;_0x9507b0<_0x57e87b[_0x62bcb(0x12c)][_0x62bcb(0x133)];_0x9507b0++){const _0x1ae198=_0x57e87b[_0x62bcb(0x12c)][_0x9507b0],_0x23bd16=path[_0x62bcb(0x149)](_0x29b0ee,_0x1ae198[_0x62bcb(0x1c5)]);fs[_0x62bcb(0x116)](_0x23bd16)&&_0x25b3c0[_0x62bcb(0x1ba)]['push']({'name':_0x1ae198['name'],'contentType':_0x1ae198[_0x62bcb(0xfd)],'data':fs[_0x62bcb(0x124)](_0x23bd16)});}emlformat['build'](_0x25b3c0,function(_0x213680,_0x6b8a00){const _0x1d7636=_0x62bcb;if(_0x213680)return _0xfdd371(_0x213680);return fs[_0x1d7636(0x17c)](path[_0x1d7636(0x149)](_0x1d4117,util['format'](_0x1d7636(0x1cc),_0x3a8f51)),_0x6b8a00),_0x5ea20d(_0x6b8a00);});});})[_0x2805c6(0x112)](function(){const _0x3b8753=_0x2805c6;return new Promise(function(_0x7885e5,_0x51c239){zipdir(_0x1d4117,{'saveTo':_0x5c3a06},function(_0x2fb2b4,_0xa7eccb){if(_0x2fb2b4)return _0x51c239(_0x2fb2b4);return _0x7885e5(_0xa7eccb);});})[_0x3b8753(0x112)](function(){return new Promise(function(_0x2a528f,_0x6f8827){rimraf(_0x1d4117,function(_0x3d7834){if(_0x3d7834)_0x6f8827(_0x3d7834);return _0x2a528f();});});})[_0x3b8753(0x112)](function(){const _0x3eab06=_0x3b8753;return _0x42b21a[_0x3eab06(0x136)](_0x5c3a06,_0x1b09a5,function(_0x5a2eea){const _0x3b2a1e=_0x3eab06;_0x5a2eea?console['log'](_0x3b2a1e(0x1bc),_0x5a2eea):fs[_0x3b2a1e(0x1b0)](_0x5c3a06);});});}));}else return _0x42b21a[_0x2805c6(0x17f)](0xc8);})['catch'](handleError(_0x42b21a,null));};
\ No newline at end of file
+const a489_0x25c7=['UserId','filters','fields','model','error','push','`\x20=\x200','mail_messages','findAll','contactName','u.id\x20=\x20ui.UserId','Account.key','`unreadMessages`\x20>\x200','map','eml-format','\x20IS\x20NULL','subject','find','rimraf','SELECT','addTags','all','plainBody','merge','ui.MailInteractionId','resolve','i.secondDisposition','left_join','sort','parse','order','type','index','mkdirSync','Contact.lastName','User','build','user','Attachments','i.disposition','omit','lastMsgBody','stack','mailInteractionTags:save','conditions','TagIds','parseSearch','mail_interactions','i.id','../../config/environment','union','where','tools_tags','attachments','i.attach','sendStatus','undefined','message%d.eml','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','query','get','buildExpression','download','`\x20>\x200','isEmail','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','forEach','rows','GROUP_CONCAT(DISTINCT\x20t.id)','Setting','removeTags','expr','show','o.internal','Tag','tag','../../components/parsers/qs','enableEmailPreview','a.mandatoryDisposition','writeFileSync','Contact.firstName','./mailInteraction.socket','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.MailAccountId\x20IS\x20NULL','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','server','include','i.thirdDisposition','catch','findOne','join','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','attributes','`unreadMessages`\x20=\x200','tmp','gte','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','name','offset','c.email','from','status','group','read','getMailAccounts','root','start','then','unlinkSync','../../components/parsers/advancedSearch','setTags','i.MailAccountId\x20IN\x20?','MailAccountId','select','i.UserId','o.fullname','sqlOperator','c.firstName','toString','../../config/logger','$gte','compact','field','value','mail_accounts','c.email\x20LIKE\x20?','options','destroy','createdAt','search','moment','Content-Range','Account.mandatoryDisposition','split','intersection','i.createdAt','i.MailAccountId\x20IS\x20NOT\x20NULL','json','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','some','files','i.subject','lastMsgText','replace','api','u.fullname','headers','having','register','basename','count','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','ui.MailInteractionId\x20IN\x20?','sequelize','concat','getFullTextValue','getMessages','log','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','rawAttributes','unreadMessages','like','ContactId','filter','Users','err','fieldName','ids','t.id\x20=\x20it.TagId','zip-dir','describe','existsSync','i.ContactId','MailInteraction','$lte','MailMessage','$substring','set','nolimit','send','key','end','c.fax','pick','readFileSync','isNumeric','keyBy','i.lastMsgDirection','mail_interaction_has_tags','a.id\x20=\x20i.MailAccountId','MailInteractionId','create','lodash','clone','i.closedAt','o.id\x20=\x20i.UserId','users','operator','t.id\x20IN\x20?','fullname','format','addMessage','c.mobile','text','length','Contact','params','limit','i.substatus','body','c.lastName','update','user_has_mail_interactions','keys','bcc','html-to-text','isEmpty'];(function(_0x370193,_0x3838a3){const _0x25c7ff=function(_0x423300){while(--_0x423300){_0x370193['push'](_0x370193['shift']());}};_0x25c7ff(++_0x3838a3);}(a489_0x25c7,0xfb));const a489_0x4233=function(_0x370193,_0x3838a3){_0x370193=_0x370193-0x75;let _0x25c7ff=a489_0x25c7[_0x370193];return _0x25c7ff;};const a489_0x10eea6=a489_0x4233;'use strict';const emlformat=require(a489_0x10eea6(0x13a)),rimraf=require(a489_0x10eea6(0x13e)),zipdir=require(a489_0x10eea6(0xfc)),moment=require(a489_0x10eea6(0xd5)),util=require('util'),path=require('path'),fs=require('fs'),_=require(a489_0x10eea6(0x113)),squel=require('squel'),{htmlToText}=require(a489_0x10eea6(0x12a)),{getSocket}=require('../../rediscache'),socket=getSocket(),qs=require(a489_0x10eea6(0x9f)),as=require(a489_0x10eea6(0xc0)),logger=require(a489_0x10eea6(0xca))(a489_0x10eea6(0xe3)),config=require(a489_0x10eea6(0x84)),{db}=require('../../mysqldb'),{Op,QueryTypes}=require('sequelize');require(a489_0x10eea6(0xa4))[a489_0x10eea6(0xe7)](socket);function respondWithStatusCode(_0x76e0ef,_0x33bed6){return _0x33bed6=_0x33bed6||0xcc,function(_0x1d6cba){const _0x51da04=a489_0x4233;if(_0x1d6cba)return _0x76e0ef[_0x51da04(0x8a)](_0x33bed6);return _0x76e0ef[_0x51da04(0xb8)](_0x33bed6)[_0x51da04(0x108)]();};}function respondWithResult(_0x145a64,_0x56bff2){return _0x56bff2=_0x56bff2||0xc8,function(_0x3d36d6){const _0x1d0ad4=a489_0x4233;if(_0x3d36d6)return _0x145a64[_0x1d0ad4(0xb8)](_0x56bff2)[_0x1d0ad4(0xdc)](_0x3d36d6);};}function respondWithFilteredResult(_0x270bc8,_0x4e79f9){return function(_0x195ee4){const _0x63fee2=a489_0x4233;if(_0x195ee4){const _0x5e02af=_0x195ee4['count'],_0x54816a=_0x4e79f9[_0x63fee2(0xb5)];let _0x1fcbd5=_0x4e79f9['offset']+_0x4e79f9[_0x63fee2(0x122)],_0xaeea4c;return _0x1fcbd5>=_0x5e02af?(_0x1fcbd5=_0x5e02af,_0xaeea4c=0xc8):_0xaeea4c=0xce,_0x270bc8[_0x63fee2(0xb8)](_0xaeea4c),_0x270bc8[_0x63fee2(0x104)](_0x63fee2(0xd6),_0x54816a+'-'+_0x1fcbd5+'/'+_0x5e02af)[_0x63fee2(0xdc)](_0x195ee4);}return null;};}function saveUpdates(_0xfdf395){return function(_0x4e1743){const _0xf524ed=a489_0x4233;if(_0x4e1743)return _0x4e1743[_0xf524ed(0x126)](_0xfdf395)[_0xf524ed(0xbe)](function(_0x456015){return _0x456015;});return null;};}function removeEntity(_0x272204){return function(_0x476a1e){const _0x52b0b0=a489_0x4233;if(_0x476a1e)return _0x476a1e[_0x52b0b0(0xd2)]()[_0x52b0b0(0xbe)](function(){const _0x4f4272=_0x52b0b0;_0x272204[_0x4f4272(0xb8)](0xcc)[_0x4f4272(0x108)]();});};}function handleEntityNotFound(_0x479257){return function(_0x3f527e){const _0x3f03d4=a489_0x4233;return!_0x3f527e&&_0x479257[_0x3f03d4(0x8a)](0x194),_0x3f527e;};}function handleError(_0x4f0733,_0x4919be){return _0x4919be=_0x4919be||0x1f4,function(_0x3c1614){const _0x41b333=a489_0x4233;logger[_0x41b333(0x130)](_0x3c1614[_0x41b333(0x7d)]),_0x3c1614[_0x41b333(0xb4)]&&delete _0x3c1614[_0x41b333(0xb4)],_0x4f0733[_0x41b333(0xb8)](_0x4919be)[_0x41b333(0x106)](_0x3c1614);};}function getInteractionUsers(_0x4dca67,_0x1aed27){return new Promise(function(_0x4699f8,_0x311155){const _0x3c15cf=a489_0x4233;try{_0x1aed27[_0x4dca67['id']]&&(_0x4dca67[_0x3c15cf(0xf7)]=_['map'](_0x1aed27[_0x4dca67['id']],function(_0xe2e6d4){const _0x43dbd2=_0x3c15cf;return{'id':_0xe2e6d4['id'],'fullname':_0xe2e6d4[_0x43dbd2(0x11a)]};}));}catch(_0x533be0){_0x311155(_0x533be0);}_0x4699f8(_0x4dca67);});}function getInteractionTags(_0x4c8431,_0x513826){return new Promise(function(_0x3cdab3,_0x612960){const _0x2aa97e=a489_0x4233;try{_0x4c8431[_0x2aa97e(0x80)]&&(_0x4c8431['Tags']=[],_0x4c8431[_0x2aa97e(0x80)][_0x2aa97e(0xd8)](',')[_0x2aa97e(0x95)](function(_0x1ec5b8){const _0x590b2a=_0x2aa97e;_0x4c8431['Tags'][_0x590b2a(0x131)](_0x513826[_0x1ec5b8]);})),delete _0x4c8431['TagIds'];}catch(_0x5fa32f){_0x612960(_0x5fa32f);}_0x3cdab3(_0x4c8431);});}function getLastMessageText(_0x5a996a){return new Promise(function(_0x76e19f,_0x5208ae){const _0x3d8240=a489_0x4233;return db['MailInteraction']['findOne']({'where':{'id':_0x5a996a['id']},'attributes':[_0x3d8240(0x7c),'lastMsgText'],'raw':!![]})[_0x3d8240(0xbe)](function(_0x329a57){const _0x499563=_0x3d8240;!_0x329a57[_0x499563(0xe1)]?_0x5a996a[_0x499563(0xe1)]=_['trimStart'](htmlToText(_0x329a57[_0x499563(0x7c)],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]})):_0x5a996a['lastMsgText']=_0x329a57['lastMsgText'],_0x76e19f(_0x5a996a);})[_0x3d8240(0xab)](function(_0x56aa84){_0x5208ae(_0x56aa84);});});}function updateMailInteraction(_0x58baa1,_0x3026e6,_0x293ae0,_0x23864b){return new Promise(function(_0x17dca0,_0x6c09e6){const _0x4eb6ca=a489_0x4233;return getInteractionUsers(_0x58baa1,_0x293ae0)[_0x4eb6ca(0xbe)](function(_0x4a3a44){return getInteractionTags(_0x4a3a44,_0x3026e6);})[_0x4eb6ca(0xbe)](function(_0xe79d92){_0x23864b?_0x17dca0(getLastMessageText(_0xe79d92)):_0x17dca0(_0xe79d92);})['catch'](function(_0x93fbaf){_0x6c09e6(_0x93fbaf);});});}exports[a489_0x10eea6(0x14c)]=function(_0x1705ef,_0x45e498){const _0x23811f=a489_0x10eea6,_0x195321={},_0xaeec06={},_0x154202={'count':0x0,'rows':[]},_0x51836d=_[_0x23811f(0x139)](db[_0x23811f(0x100)][_0x23811f(0xf2)],function(_0x21f732){const _0x3f8296=_0x23811f;return{'name':_0x21f732[_0x3f8296(0xf9)],'type':_0x21f732[_0x3f8296(0x14b)][_0x3f8296(0x107)]};});_0xaeec06[_0x23811f(0x12f)]=_[_0x23811f(0x139)](_0x51836d,_0x23811f(0xb4)),_0xaeec06[_0x23811f(0x8e)]=_['keys'](_0x1705ef[_0x23811f(0x8e)]),_0xaeec06[_0x23811f(0x12d)]=_['intersection'](_0xaeec06[_0x23811f(0x12f)],_0xaeec06[_0x23811f(0x8e)]),_0x195321[_0x23811f(0xaf)]=_[_0x23811f(0xd9)](_0xaeec06['model'],qs[_0x23811f(0x12e)](_0x1705ef['query'][_0x23811f(0x12e)])),_0x195321['attributes']=_0x195321['attributes']['length']?_0x195321[_0x23811f(0xaf)]:_0xaeec06['model'];typeof _0x1705ef[_0x23811f(0x8e)][_0x23811f(0x105)]===_0x23811f(0x8b)&&(_0x195321[_0x23811f(0x122)]=qs['limit'](_0x1705ef[_0x23811f(0x8e)][_0x23811f(0x122)]),_0x195321[_0x23811f(0xb5)]=qs['offset'](_0x1705ef[_0x23811f(0x8e)][_0x23811f(0xb5)]));_0x195321[_0x23811f(0x14a)]=qs[_0x23811f(0x148)](_0x1705ef[_0x23811f(0x8e)][_0x23811f(0x148)]),_0x195321['where']=qs[_0x23811f(0x12d)](_['pick'](_0x1705ef[_0x23811f(0x8e)],_0xaeec06[_0x23811f(0x12d)]),_0x51836d);let _0x4b01c8=[];const _0x25fe70=squel[_0x23811f(0xc4)]()[_0x23811f(0xcd)]('id')[_0x23811f(0xcd)]('name')[_0x23811f(0xcd)]('color')[_0x23811f(0xb7)](_0x23811f(0x87)),_0x1c32fa=squel[_0x23811f(0xc4)]()['field']('u.id')['field'](_0x23811f(0xe4))[_0x23811f(0xcd)](_0x23811f(0x144))[_0x23811f(0xb7)](_0x23811f(0x127),'ui')[_0x23811f(0x147)](_0x23811f(0x117),'u',_0x23811f(0x136)),_0x39767a=squel['select']()[_0x23811f(0xb7)](_0x23811f(0x82),'i')['left_join']('cm_contacts','c',_0x23811f(0x94))[_0x23811f(0x147)](_0x23811f(0x117),'o',_0x23811f(0x116))['left_join'](_0x23811f(0xcf),'a',_0x23811f(0x110))['left_join'](_0x23811f(0x133),'me','me.MailInteractionId\x20=\x20i.id')[_0x23811f(0x147)](_0x23811f(0x10f),'it','it.MailInteractionId\x20=\x20i.id')[_0x23811f(0x147)]('tools_tags','t',_0x23811f(0xfb)),_0x2f1ed0=squel[_0x23811f(0x9a)]();let _0x4148a9=[];const _0x168cfa=squel[_0x23811f(0x9a)]();let _0x2d1a2a;if(_0x1705ef[_0x23811f(0x8e)][_0x23811f(0xd4)]){_0x2d1a2a=as[_0x23811f(0x81)](_0x1705ef[_0x23811f(0x8e)][_0x23811f(0xd4)]);const _0x41a895=_0x2d1a2a[_0x23811f(0xc7)];for(let _0x224e8e=0x0;_0x224e8e<_0x2d1a2a[_0x23811f(0x7f)]['length'];_0x224e8e++){const _0x50e78a=_0x2d1a2a[_0x23811f(0x7f)][_0x224e8e],_0x3765f7='i';let _0x5ed4a0,_0xd63c7d=_['find'](_0x51836d,[_0x23811f(0xb4),_0x50e78a[_0x23811f(0xcd)]]);if(!_0xd63c7d)switch(_0x50e78a[_0x23811f(0xcd)]){case'unreadMessages':_0x50e78a['value']==0x1?_0x39767a[_0x23811f(0xe6)]('`'+_0x50e78a['field']+_0x23811f(0x132)):_0x39767a[_0x23811f(0xe6)]('`'+_0x50e78a['field']+_0x23811f(0x92));break;case _0x23811f(0x120):if(_0x50e78a[_0x23811f(0x118)]===_0x23811f(0x103)){if(_0x50e78a['value'][_0x23811f(0xd8)]('\x20')['length']>0x1)_0x2f1ed0[_0x41a895](_0x23811f(0xa7),qs[_0x23811f(0xee)](_0x50e78a[_0x23811f(0xce)]),null);else{const _0x1e55f6='%'+_0x50e78a[_0x23811f(0xce)]+'%';_0x2f1ed0[_0x41a895](_0x23811f(0xae),_0x1e55f6,_0x1e55f6,_0x1e55f6);}}else _0xd63c7d=_['find'](_0x51836d,[_0x23811f(0xb4),_0x23811f(0xf5)]),_0x50e78a[_0x23811f(0xcd)]=_0x23811f(0xf5),_0x5ed4a0=as[_0x23811f(0x90)](_0x3765f7,_0xd63c7d[_0x23811f(0x14b)],_0x50e78a),_0x2f1ed0[_0x41a895](_0x5ed4a0[_0x23811f(0x11e)],_0x5ed4a0[_0x23811f(0xce)][_0x23811f(0xbd)],_0x5ed4a0[_0x23811f(0xce)][_0x23811f(0x108)]);break;case _0x23811f(0x9d):{const _0x37bb9d=_0x50e78a['value'][_0x23811f(0xd8)](',')[_0x23811f(0x139)](function(_0x37957b){return Number(_0x37957b);});_0x37bb9d[_0x23811f(0x95)](function(_0x11e53b){const _0x244e30=_0x23811f;_0x168cfa['or'](_0x244e30(0x8d),'%,'+_0x11e53b+',%');}),_0x4148a9=_[_0x23811f(0x85)](_0x4148a9,_0x37bb9d);}break;case _0x23811f(0x76):_0x50e78a[_0x23811f(0x118)]==='$substring'?_0x2f1ed0[_0x41a895](_0x23811f(0xb3),'%'+_0x50e78a[_0x23811f(0xce)]+'%',null):(_0xd63c7d=_[_0x23811f(0x13d)](_0x51836d,['name',_0x23811f(0x12c)]),_0x50e78a[_0x23811f(0xcd)]=_0x23811f(0x12c),_0x5ed4a0=as[_0x23811f(0x90)](_0x3765f7,_0xd63c7d[_0x23811f(0x14b)],_0x50e78a),_0x2f1ed0[_0x41a895](_0x5ed4a0[_0x23811f(0x11e)],_0x5ed4a0[_0x23811f(0xce)][_0x23811f(0xbd)],_0x5ed4a0[_0x23811f(0xce)][_0x23811f(0x108)]));break;case _0x23811f(0x142):_0x5ed4a0=as[_0x23811f(0x90)]('me',null,_0x50e78a),_0x2f1ed0[_0x41a895](_0x5ed4a0[_0x23811f(0x11e)],_0x5ed4a0['value'][_0x23811f(0xbd)],_0x5ed4a0[_0x23811f(0xce)][_0x23811f(0x108)]);break;}else _0x5ed4a0=as[_0x23811f(0x90)](_0x3765f7,_0xd63c7d[_0x23811f(0x14b)],_0x50e78a),_0x2f1ed0[_0x41a895](_0x5ed4a0[_0x23811f(0x11e)],_0x5ed4a0[_0x23811f(0xce)][_0x23811f(0xbd)],_0x5ed4a0['value'][_0x23811f(0x108)]);}}else{const _0x122794=_(_0x1705ef[_0x23811f(0x8e)])[_0x23811f(0x128)]()[_0x23811f(0x139)](function(_0x3267c8){const _0xc027a1=_0x23811f;return _[_0xc027a1(0xde)](_0x51836d,['name',_0x3267c8])?_0x3267c8:undefined;})[_0x23811f(0xcc)]()[_0x23811f(0xce)]();!_[_0x23811f(0x12b)](_0x122794)&&_0x122794[_0x23811f(0x95)](function(_0x21e56a){const _0x15bb00=_0x23811f;if(_0x21e56a===_0x15bb00(0xc3))_0x39767a[_0x15bb00(0x86)](_0x15bb00(0xc2),[][_0x15bb00(0xed)](_0x1705ef[_0x15bb00(0x8e)][_0x21e56a]));else{if(_0x21e56a===_0x15bb00(0xd3)){const _0x4699d1=JSON[_0x15bb00(0x149)](_0x1705ef[_0x15bb00(0x8e)][_0x21e56a])[_0x15bb00(0xcb)],_0x11d561=JSON[_0x15bb00(0x149)](_0x1705ef[_0x15bb00(0x8e)][_0x21e56a])[_0x15bb00(0x101)];_0x39767a[_0x15bb00(0x86)](_0x15bb00(0xdd),_0x4699d1,_0x11d561);}else _0x1705ef['query'][_0x21e56a]==='null'?_0x39767a['where']('i.'+_0x21e56a+_0x15bb00(0x13b)):_0x39767a[_0x15bb00(0x86)]('i.'+_0x21e56a+'\x20=\x20?',_0x1705ef[_0x15bb00(0x8e)][_0x21e56a]);}});_0x1705ef[_0x23811f(0x8e)][_0x23811f(0xba)]&&(_0x1705ef[_0x23811f(0x8e)][_0x23811f(0xba)]==0x1?_0x39767a[_0x23811f(0xe6)](_0x23811f(0xb0)):_0x39767a[_0x23811f(0xe6)](_0x23811f(0x138)));_0x1705ef[_0x23811f(0x8e)][_0x23811f(0x9e)]&&(_0x4148a9=_['isArray'](_0x1705ef[_0x23811f(0x8e)][_0x23811f(0x9e)])?_0x1705ef[_0x23811f(0x8e)][_0x23811f(0x9e)]:new Array(_0x1705ef[_0x23811f(0x8e)][_0x23811f(0x9e)]),_0x4148a9[_0x23811f(0x95)](function(_0x17bf45){const _0xcdecf0=_0x23811f;_0x168cfa['or'](_0xcdecf0(0x8d),'%,'+_0x17bf45+',%');}));if(_0x1705ef[_0x23811f(0x8e)]['filter']){const _0x4d03fc=_0x1705ef[_0x23811f(0x8e)][_0x23811f(0xf6)][_0x23811f(0xe2)]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0x23811f(0x10c)](_0x4d03fc))_0x2f1ed0['or']('i.id\x20LIKE\x20?',_0x4d03fc+'%');else qs[_0x23811f(0x93)](_0x4d03fc)?_0x2f1ed0['or'](_0x23811f(0xd0),_0x4d03fc+'%'):_0x2f1ed0['or'](_0x23811f(0xea),qs[_0x23811f(0xee)](_0x4d03fc))['or'](_0x23811f(0xa5),qs[_0x23811f(0xee)](_0x4d03fc));}}_0x39767a[_0x23811f(0x86)](_0x2f1ed0),_0x39767a[_0x23811f(0xb9)](_0x23811f(0x83));let _0x25750b={'type':QueryTypes[_0x23811f(0x13f)],'raw':!![]};const _0xef5c=_0x39767a[_0x23811f(0x114)]();_0xef5c['field'](_0x23811f(0x83)),_0xef5c[_0x23811f(0xcd)](_0x23811f(0xf1),_0x23811f(0xf3)),_0x195321[_0x23811f(0x14a)]&&_0x195321[_0x23811f(0x14a)][_0x23811f(0x95)](function(_0x203fa0){const _0x26c171=_0x23811f,_0x5251bc=_0x203fa0[0x0]==='contactName'?_0x203fa0[0x0]:'i.'+_0x203fa0[0x0];_0x39767a[_0x26c171(0x14a)](_0x5251bc,_0x203fa0[0x1]==='DESC'?![]:!![]);}),!_['isEmpty'](_0x4148a9)&&(_0x39767a[_0x23811f(0xe6)](_0x168cfa),_0xef5c[_0x23811f(0x86)](_0x23811f(0x119),_0x4148a9)),Promise[_0x23811f(0x145)]()[_0x23811f(0xbe)](function(){const _0x171c83=_0x23811f;if(!_0x2d1a2a){if(_0x1705ef[_0x171c83(0x8e)]['MailAccountId']||_0x1705ef['query']['journey'])return;_0xef5c[_0x171c83(0x86)]('i.MailAccountId\x20IS\x20NOT\x20NULL'),_0x39767a[_0x171c83(0x86)](_0x171c83(0xdb));return;}return _0x1705ef[_0x171c83(0x78)][_0x171c83(0xbb)]({'attributes':['id'],'raw':!![]})[_0x171c83(0xbe)](function(_0x237a2e){const _0x32d4ec=_0x171c83;_[_0x32d4ec(0x12b)](_0x237a2e)?(_0xef5c[_0x32d4ec(0x86)](_0x32d4ec(0xa6)),_0x39767a['where']('i.MailAccountId\x20IS\x20NULL')):(_0xef5c['where'](_0x32d4ec(0xc2),_[_0x32d4ec(0x139)](_0x237a2e,'id')),_0x39767a['where'](_0x32d4ec(0xc2),_[_0x32d4ec(0x139)](_0x237a2e,'id')));});})[_0x23811f(0xbe)](function(){const _0x5bc638=_0x23811f;db[_0x5bc638(0xec)][_0x5bc638(0x8e)](_0xef5c[_0x5bc638(0xc9)](),_0x25750b)[_0x5bc638(0xbe)](function(_0x10ed3f){const _0x6a7150=_0x5bc638;_0x154202[_0x6a7150(0xe9)]=_0x10ed3f[_0x6a7150(0x11f)];if(_0x154202[_0x6a7150(0xe9)]===0x0)return[];return db[_0x6a7150(0xec)]['query'](_0x25fe70[_0x6a7150(0xc9)](),_0x25750b)['then'](function(_0x1156d5){const _0x26759d=_0x6a7150;_0x4b01c8=_[_0x26759d(0x10d)](_0x1156d5,'id'),_0x25750b=_['merge'](_0x25750b,{'model':db['MailInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});_0x1705ef[_0x26759d(0x8e)][_0x26759d(0x12e)]?_0x195321['attributes'][_0x26759d(0x95)](function(_0x1c71b9){const _0x5b4a36=_0x26759d;_0x39767a[_0x5b4a36(0xcd)]('i.'+_0x1c71b9);}):(_0x39767a['field'](_0x26759d(0xf1),_0x26759d(0xf3)),_0x39767a['field']('a.key',_0x26759d(0x137)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0xa1),_0x26759d(0xd7)),_0x39767a[_0x26759d(0xcd)]('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',_0x26759d(0x135)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x83)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0xda)),_0x39767a[_0x26759d(0xcd)]('i.updatedAt'),_0x39767a['field']('i.closed'),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x115)),_0x39767a['field'](_0x26759d(0x89)),_0x39767a['field']('i.lastMsgAt'),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x10e)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0xe0)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x7a)),_0x39767a['field'](_0x26759d(0x146)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0xaa)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x123)),_0x39767a['field']('i.to'),_0x39767a[_0x26759d(0xcd)](_0x26759d(0xff)),_0x39767a[_0x26759d(0xcd)]('i.MailAccountId'),_0x39767a['field'](_0x26759d(0xc5)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0xc8),_0x26759d(0xa3)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x125),_0x26759d(0x75)),_0x39767a[_0x26759d(0xcd)](_0x26759d(0xb6),'Contact.email'),_0x39767a[_0x26759d(0xcd)]('c.phone','Contact.phone'),_0x39767a['field'](_0x26759d(0x11d),'Contact.mobile'),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x109),'Contact.fax'),_0x39767a[_0x26759d(0xcd)](_0x26759d(0xc6),'Owner.fullname'),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x9c),'Owner.internal'),_0x39767a[_0x26759d(0xcd)](_0x26759d(0x97),'TagIds'));if(_0x195321['limit'])_0x39767a[_0x26759d(0x122)](_0x195321[_0x26759d(0x122)]);if(_0x195321['offset'])_0x39767a[_0x26759d(0xb5)](_0x195321[_0x26759d(0xb5)]);return db[_0x26759d(0xec)]['query'](_0x39767a['toString'](),_0x25750b);})['then'](function(_0x24b8ae){const _0x368a7d=_0x6a7150;return _0x1c32fa[_0x368a7d(0x86)](_0x368a7d(0xeb),_[_0x368a7d(0x139)](_0x24b8ae,'id')),db[_0x368a7d(0xec)][_0x368a7d(0x8e)](_0x1c32fa[_0x368a7d(0xc9)](),_0x25750b)[_0x368a7d(0xbe)](function(_0x3697b9){const _0x2e6faf=_0x368a7d,_0x259254=_['groupBy'](_0x3697b9,'MailInteractionId'),_0x1792e4=[];return db[_0x2e6faf(0x98)][_0x2e6faf(0xac)]({'attributes':[_0x2e6faf(0xa0)],'raw':!![]})[_0x2e6faf(0xbe)](function(_0x38b49b){const _0x25f276=_0x2e6faf,_0x209c92=_0x38b49b[_0x25f276(0xa0)];return _0x24b8ae[_0x25f276(0x95)](function(_0x370503){_0x1792e4['push'](updateMailInteraction(_0x370503,_0x4b01c8,_0x259254,_0x209c92));}),Promise[_0x25f276(0x141)](_0x1792e4);});});});})[_0x5bc638(0xbe)](function(_0x1116db){const _0x8d0b7a=_0x5bc638;return _0x154202[_0x8d0b7a(0x96)]=_0x1116db,_0x154202;})['then'](respondWithFilteredResult(_0x45e498,_0x195321));})['catch'](handleError(_0x45e498,null));},exports[a489_0x10eea6(0x9b)]=function(_0x222c8e,_0x4a837e){const _0x19d929=a489_0x10eea6;let _0x4793c9={'raw':![],'where':{'id':_0x222c8e['params']['id']}};const _0x28fede={};return _0x28fede[_0x19d929(0x12f)]=_[_0x19d929(0x128)](db[_0x19d929(0x100)][_0x19d929(0xf2)]),_0x28fede['query']=_['keys'](_0x222c8e[_0x19d929(0x8e)]),_0x28fede[_0x19d929(0x12d)]=_['intersection'](_0x28fede['model'],_0x28fede[_0x19d929(0x8e)]),_0x4793c9['attributes']=_[_0x19d929(0xd9)](_0x28fede[_0x19d929(0x12f)],qs[_0x19d929(0x12e)](_0x222c8e['query'][_0x19d929(0x12e)])),_0x4793c9[_0x19d929(0xaf)]=_0x4793c9[_0x19d929(0xaf)][_0x19d929(0x11f)]?_0x4793c9[_0x19d929(0xaf)]:_0x28fede['model'],_0x222c8e[_0x19d929(0x8e)]['includeAll']&&(_0x4793c9[_0x19d929(0xa9)]=[{'all':!![]}]),_0x4793c9=_[_0x19d929(0x143)]({},_0x4793c9,_0x222c8e[_0x19d929(0xd1)]),db[_0x19d929(0x100)][_0x19d929(0xac)](_0x4793c9)[_0x19d929(0xbe)](handleEntityNotFound(_0x4a837e,null))[_0x19d929(0xbe)](respondWithResult(_0x4a837e,null))[_0x19d929(0xab)](handleError(_0x4a837e,null));},exports[a489_0x10eea6(0x112)]=function(_0x3a27c8,_0x26bc78){const _0x1f6789=a489_0x10eea6;return db[_0x1f6789(0x100)][_0x1f6789(0x112)](_0x3a27c8[_0x1f6789(0x124)],{})['then'](respondWithResult(_0x26bc78,0xc9))['catch'](handleError(_0x26bc78,null));},exports[a489_0x10eea6(0x126)]=function(_0x3d82a6,_0x9627a9){const _0x334893=a489_0x10eea6;return _0x3d82a6[_0x334893(0x124)]['id']&&delete _0x3d82a6[_0x334893(0x124)]['id'],db[_0x334893(0x100)][_0x334893(0xac)]({'where':{'id':_0x3d82a6[_0x334893(0x121)]['id']}})['then'](handleEntityNotFound(_0x9627a9,null))[_0x334893(0xbe)](saveUpdates(_0x3d82a6[_0x334893(0x124)],null))[_0x334893(0xbe)](respondWithResult(_0x9627a9,null))[_0x334893(0xab)](handleError(_0x9627a9,null));},exports[a489_0x10eea6(0xd2)]=function(_0x2bb12f,_0x47662a){const _0x4571ef=a489_0x10eea6;return db[_0x4571ef(0x100)][_0x4571ef(0xac)]({'where':{'id':_0x2bb12f[_0x4571ef(0x121)]['id']}})[_0x4571ef(0xbe)](handleEntityNotFound(_0x47662a,null))['then'](removeEntity(_0x47662a,null))['catch'](handleError(_0x47662a,null));},exports[a489_0x10eea6(0xfd)]=function(_0x557e75,_0x2ee7f6){const _0x2223ea=a489_0x10eea6;return db[_0x2223ea(0x100)][_0x2223ea(0xfd)]()['then'](respondWithResult(_0x2ee7f6,null))[_0x2223ea(0xab)](handleError(_0x2ee7f6,null));},exports[a489_0x10eea6(0x11c)]=function(_0x4bafc5,_0x5a1dec){const _0x39454f=a489_0x10eea6;return db[_0x39454f(0x102)][_0x39454f(0xac)]({'where':{'id':_0x4bafc5[_0x39454f(0x121)]['id']}})[_0x39454f(0xbe)](function(_0x5072eb){const _0x2cc716=_0x39454f;if(_0x5072eb)return _0x5072eb[_0x2cc716(0x11c)](_0x4bafc5[_0x2cc716(0x124)][_0x2cc716(0xfa)],{'through':_[_0x2cc716(0x7b)](_0x4bafc5[_0x2cc716(0x124)],[_0x2cc716(0xfa),'id'])});})[_0x39454f(0xbe)](respondWithResult(_0x5a1dec,null))[_0x39454f(0xab)](handleError(_0x5a1dec,null));},exports[a489_0x10eea6(0xef)]=function(_0x1f6590,_0x2a5070){const _0x9c041b=a489_0x10eea6;let _0x482f4e={'raw':![],'where':{}};const _0x3db8be={},_0xa31c20={'count':0x0,'rows':[]};return db[_0x9c041b(0x100)][_0x9c041b(0xac)]({'where':{'id':_0x1f6590[_0x9c041b(0x121)]['id']}})[_0x9c041b(0xbe)](handleEntityNotFound(_0x2a5070,null))['then'](function(_0x54abe4){const _0x1b9695=_0x9c041b;if(_0x54abe4){_0x3db8be[_0x1b9695(0x12f)]=_['keys'](db[_0x1b9695(0x102)][_0x1b9695(0xf2)]),_0x3db8be[_0x1b9695(0x8e)]=_[_0x1b9695(0x128)](_0x1f6590[_0x1b9695(0x8e)]),_0x3db8be[_0x1b9695(0x12d)]=_[_0x1b9695(0xd9)](_0x3db8be['model'],_0x3db8be['query']),_0x482f4e[_0x1b9695(0xaf)]=_[_0x1b9695(0xd9)](_0x3db8be[_0x1b9695(0x12f)],qs['fields'](_0x1f6590[_0x1b9695(0x8e)][_0x1b9695(0x12e)])),_0x482f4e['attributes']=_0x482f4e[_0x1b9695(0xaf)][_0x1b9695(0x11f)]?_0x482f4e[_0x1b9695(0xaf)]:_0x3db8be['model'];typeof _0x1f6590[_0x1b9695(0x8e)][_0x1b9695(0x105)]===_0x1b9695(0x8b)&&(_0x482f4e['limit']=qs[_0x1b9695(0x122)](_0x1f6590['query'][_0x1b9695(0x122)]),_0x482f4e['offset']=qs['offset'](_0x1f6590[_0x1b9695(0x8e)]['offset']));_0x482f4e[_0x1b9695(0x14a)]=qs[_0x1b9695(0x148)](_0x1f6590['query'][_0x1b9695(0x148)]),_0x482f4e[_0x1b9695(0x86)]=qs[_0x1b9695(0x12d)](_[_0x1b9695(0x10a)](_0x1f6590[_0x1b9695(0x8e)],_0x3db8be[_0x1b9695(0x12d)])),_0x482f4e[_0x1b9695(0x86)][_0x1b9695(0x111)]=_0x54abe4['id'];_0x1f6590[_0x1b9695(0x8e)][_0x1b9695(0xf6)]&&(_0x482f4e[_0x1b9695(0x86)]=_[_0x1b9695(0x143)](_0x482f4e['where'],{[Op['or']]:_['map'](_0x482f4e[_0x1b9695(0xaf)],function(_0x45b604){const _0x1ca600=_0x1b9695,_0x58cdf1={};return _0x58cdf1[_0x45b604]={[Op[_0x1ca600(0xf4)]]:'%'+_0x1f6590[_0x1ca600(0x8e)][_0x1ca600(0xf6)]+'%'},_0x58cdf1;})}));if(_0x1f6590[_0x1b9695(0x8e)][_0x1b9695(0xcb)]){const _0x4b88b0=_0x1f6590['query'][_0x1b9695(0xcb)][_0x1b9695(0xd8)](','),_0x482c89={};_0x482c89[_0x4b88b0[0x0]]={[Op[_0x1b9695(0xb2)]]:moment(_0x4b88b0[0x1])[_0x1b9695(0x11b)]('YYYY-MM-DD\x20HH:mm:ss')},_0x482f4e[_0x1b9695(0x86)]=_['merge'](_0x482f4e[_0x1b9695(0x86)],_0x482c89);}return _0x482f4e=_['merge']({},_0x482f4e,_0x1f6590[_0x1b9695(0xd1)]),db[_0x1b9695(0x102)][_0x1b9695(0xe9)]({'where':_0x482f4e['where']})['then'](function(_0x2e9045){const _0x50cbea=_0x1b9695;return _0xa31c20['count']=_0x2e9045,_0x1f6590[_0x50cbea(0x8e)]['includeAll']&&(_0x482f4e[_0x50cbea(0xa9)]=[{'all':!![]}]),db['MailMessage'][_0x50cbea(0x134)](_0x482f4e);})['then'](function(_0x36453e){const _0x5a08a4=_0x1b9695;return _0xa31c20[_0x5a08a4(0x96)]=_0x36453e,_0xa31c20;});}})['then'](respondWithFilteredResult(_0x2a5070,_0x482f4e))['catch'](handleError(_0x2a5070,null));},exports[a489_0x10eea6(0x140)]=function(_0x3cca77,_0x1197b4){const _0x26019=a489_0x10eea6;return db[_0x26019(0x100)][_0x26019(0xac)]({'where':{'id':_0x3cca77[_0x26019(0x121)]['id']}})[_0x26019(0xbe)](function(_0x54b4e5){const _0x4a29d8=_0x26019;if(_0x54b4e5)return _0x54b4e5[_0x4a29d8(0xc1)](_0x3cca77[_0x4a29d8(0x124)][_0x4a29d8(0xfa)],{'through':_[_0x4a29d8(0x7b)](_0x3cca77[_0x4a29d8(0x124)],['ids','id'])})['then'](function(){const _0x1ff058=_0x4a29d8;return db[_0x1ff058(0x9d)]['findAll']({'attributes':['id',_0x1ff058(0xb4),'color'],'where':{'id':_0x3cca77[_0x1ff058(0x124)][_0x1ff058(0xfa)]}});})[_0x4a29d8(0xbe)](function(_0x5be753){const _0x146d40=_0x4a29d8;return socket['emit'](_0x146d40(0x7e),{'id':Number(_0x3cca77[_0x146d40(0x121)]['id']),'tags':_0x5be753||[]}),{'id':Number(_0x3cca77['params']['id']),'tags':_0x5be753||[]};});})[_0x26019(0xbe)](respondWithResult(_0x1197b4,null))[_0x26019(0xab)](handleError(_0x1197b4,null));},exports[a489_0x10eea6(0x99)]=function(_0x8ba170,_0x5c6b29){const _0x2b10a9=a489_0x10eea6;return db[_0x2b10a9(0x100)][_0x2b10a9(0xac)]({'where':{'id':_0x8ba170['params']['id']}})[_0x2b10a9(0xbe)](handleEntityNotFound(_0x5c6b29,null))[_0x2b10a9(0xbe)](function(_0x5a4b6f){const _0x4e33bd=_0x2b10a9;if(_0x5a4b6f)return _0x5a4b6f[_0x4e33bd(0x99)](_0x8ba170[_0x4e33bd(0x8e)][_0x4e33bd(0xfa)]);})[_0x2b10a9(0xbe)](respondWithStatusCode(_0x5c6b29,null))[_0x2b10a9(0xab)](handleError(_0x5c6b29,null));},exports['download']=function(_0x29bc83,_0x180db6){const _0x13ce4f=a489_0x10eea6,_0x1c3cce=moment()['unix']()['toString'](),_0x247d88=path['join'](config[_0x13ce4f(0xbc)],_0x13ce4f(0xdf),_0x13ce4f(0xb1)),_0x3bab9e=path['join'](config['root'],_0x13ce4f(0xa8),_0x13ce4f(0xdf),_0x13ce4f(0x88)),_0x5afb18=path[_0x13ce4f(0xad)](_0x247d88,_0x1c3cce),_0x70af46=util[_0x13ce4f(0x11b)]('transcript-%d-%s.zip',_0x29bc83[_0x13ce4f(0x121)]['id'],_0x1c3cce),_0x398ba1=path[_0x13ce4f(0xad)](_0x247d88,_0x70af46),_0x20385d=[];_0x29bc83[_0x13ce4f(0x8e)][_0x13ce4f(0x88)]&&_0x20385d[_0x13ce4f(0x131)]({'model':db['Attachment'],'as':_0x13ce4f(0x79),'raw':!![]});const _0x337f27=[{'model':db[_0x13ce4f(0x102)],'as':'Messages','attributes':['id','body',_0x13ce4f(0xb7),'to','cc',_0x13ce4f(0x129),_0x13ce4f(0x13c),_0x13ce4f(0xd3)],'where':{'secret':![]},'order':qs[_0x13ce4f(0x148)]('id'),'include':_0x20385d}];return db[_0x13ce4f(0x100)][_0x13ce4f(0xac)]({'where':{'id':_0x29bc83[_0x13ce4f(0x121)]['id']},'include':_0x337f27})[_0x13ce4f(0xbe)](handleEntityNotFound(_0x180db6,null))['then'](function(_0xbfa9db){const _0x139874=_0x13ce4f;if(_0xbfa9db&&_0xbfa9db['Messages']){const _0x53963b=_0xbfa9db[_0x139874(0x8f)]({'plain':!![]});return fs[_0x139874(0x14d)](_0x5afb18),Promise['all'](_0x53963b['Messages'][_0x139874(0x139)]((_0x303e1b,_0x1614d4)=>{const _0x546ab7=_0x139874,_0x383ba1={'from':_0x303e1b[_0x546ab7(0xb7)],'to':_0x303e1b['to'],'subject':_0x303e1b[_0x546ab7(0x13c)],'html':_0x303e1b[_0x546ab7(0x124)],'headers':{'Date':moment(_0x303e1b[_0x546ab7(0xd3)])[_0x546ab7(0x11b)]('ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ')},'attachments':[]};return _0x303e1b['cc']&&(_0x383ba1[_0x546ab7(0xe5)]['Cc']=_0x303e1b['cc']),_0x303e1b[_0x546ab7(0x129)]&&(_0x383ba1['headers']['Bcc']=_0x303e1b[_0x546ab7(0x129)]),new Promise(function(_0x64312a,_0x7b9c6b){const _0x1ea6a4=_0x546ab7;if(_0x303e1b[_0x1ea6a4(0x79)])for(let _0x5abfef=0x0;_0x5abfef<_0x303e1b[_0x1ea6a4(0x79)][_0x1ea6a4(0x11f)];_0x5abfef++){const _0xe158ef=_0x303e1b[_0x1ea6a4(0x79)][_0x5abfef],_0x43bdc0=path[_0x1ea6a4(0xad)](_0x3bab9e,_0xe158ef[_0x1ea6a4(0xe8)]);fs[_0x1ea6a4(0xfe)](_0x43bdc0)&&_0x383ba1[_0x1ea6a4(0x88)]['push']({'name':_0xe158ef[_0x1ea6a4(0xb4)],'contentType':_0xe158ef[_0x1ea6a4(0x14b)],'data':fs[_0x1ea6a4(0x10b)](_0x43bdc0)});}emlformat[_0x1ea6a4(0x77)](_0x383ba1,function(_0x10bc2c,_0x4ae56c){const _0x216fed=_0x1ea6a4;if(_0x10bc2c)return _0x7b9c6b(_0x10bc2c);return fs[_0x216fed(0xa2)](path[_0x216fed(0xad)](_0x5afb18,util[_0x216fed(0x11b)](_0x216fed(0x8c),_0x1614d4)),_0x4ae56c),_0x64312a(_0x4ae56c);});});})['then'](function(){const _0x4b7e91=_0x139874;return new Promise(function(_0x544710,_0x429077){zipdir(_0x5afb18,{'saveTo':_0x398ba1},function(_0xbd0840,_0x13850a){if(_0xbd0840)return _0x429077(_0xbd0840);return _0x544710(_0x13850a);});})['then'](function(){return new Promise(function(_0x25229f,_0x2ab9c3){rimraf(_0x5afb18,function(_0x27f160){if(_0x27f160)_0x2ab9c3(_0x27f160);return _0x25229f();});});})[_0x4b7e91(0xbe)](function(){const _0x26af01=_0x4b7e91;return _0x180db6[_0x26af01(0x91)](_0x398ba1,_0x70af46,function(_0x4378a9){const _0x4563e6=_0x26af01;_0x4378a9?console[_0x4563e6(0xf0)](_0x4563e6(0xf8),_0x4378a9):fs[_0x4563e6(0xbf)](_0x398ba1);});});}));}else return _0x180db6[_0x139874(0x8a)](0xc8);})['catch'](handleError(_0x180db6,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff