// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x0360=['parseSearch','conditions','unreadMessages','value','having','`\x20=\x200','Contact','operator','split','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','find','ContactId','buildExpression','start','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','$substring','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','text','some','compact','isEmpty','MailAccountId','createdAt','parse','$lte','where','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','read','`unreadMessages`\x20>\x200','tag','isArray','filter','replace','isNumeric','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','Sequelize','QueryTypes','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','DESC','t.id\x20IN\x20?','resolve','i.MailAccountId\x20IS\x20NOT\x20NULL','user','getMailAccounts','i.MailAccountId\x20IS\x20NULL','i.MailAccountId\x20IN\x20?','sequelize','toString','keyBy','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20(\x27%\x27\x20+\x20a.email\x20+\x20\x27%\x27)\x20THEN\x20SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201)\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.createdAt','i.closed','i.lastMsgAt','i.lastMsgDirection','i.subject','i.disposition','i.secondDisposition','i.substatus','i.to','i.ContactId','i.MailAccountId','i.UserId','c.firstName','Contact.firstName','c.lastName','Contact.email','c.phone','Contact.phone','c.mobile','o.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','all','rows','show','includeAll','include','options','catch','create','params','describe','addMessage','ids','omit','pick','$gte','format','YYYY-MM-DD\x20HH:mm:ss','findAll','inlineCss','true','addTags','spread','emit','mailInteractionTags:save','unix','join','files','root','server','attachments','transcript-%d-%s.zip','push','Messages','subject','get','mkdirSync','each','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','bcc','Attachments','basename','existsSync','readFileSync','build','writeFileSync','err','unlinkSync','rimraf','zip-dir','fast-json-patch','bluebird','util','sox','to-csv','ejs','fs-extra','squel','jsforce','desk.js','papaparse','juice','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./mailInteraction.socket','register','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','destroy','end','error','stack','name','send','render','merge','body','contact','message','agent','interaction','account','Users','map','fullname','TagIds','Tags','forEach','MailMessage','findOne','out','plainBody','-id','trimStart','MailInteraction','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','field','color','from','select','u.id','u.fullname','ui.MailInteractionId','left_join','users','u.id\x20=\x20ui.UserId','mail_interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','a.id\x20=\x20i.MailAccountId','me.MailInteractionId\x20=\x20i.id','tools_tags','t.id\x20=\x20it.TagId','expr','search'];(function(_0x3193dd,_0x590238){var _0x1baffa=function(_0x2523f1){while(--_0x2523f1){_0x3193dd['push'](_0x3193dd['shift']());}};_0x1baffa(++_0x590238);}(_0x0360,0x181));var _0x0036=function(_0xf017ad,_0x12f42f){_0xf017ad=_0xf017ad-0x0;var _0x29e990=_0x0360[_0xf017ad];return _0x29e990;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x0036('0x0'));var zipdir=require(_0x0036('0x1'));var jsonpatch=require(_0x0036('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x0036('0x3'));var Mustache=require('mustache');var util=require(_0x0036('0x4'));var path=require('path');var sox=require(_0x0036('0x5'));var csv=require(_0x0036('0x6'));var ejs=require(_0x0036('0x7'));var fs=require('fs');var fs_extra=require(_0x0036('0x8'));var _=require('lodash');var squel=require(_0x0036('0x9'));var crypto=require('crypto');var jsforce=require(_0x0036('0xa'));var deskjs=require(_0x0036('0xb'));var toCsv=require(_0x0036('0x6'));var querystring=require('querystring');var Papa=require(_0x0036('0xc'));var htmlToText=require('html-to-text');var juice=require(_0x0036('0xd'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x0036('0xe'));var hardwareService=require(_0x0036('0xf'));var logger=require(_0x0036('0x10'))(_0x0036('0x11'));var utils=require('../../config/utils');var config=require(_0x0036('0x12'));var licenseUtil=require('../../config/license/util');var db=require(_0x0036('0x13'))['db'];config[_0x0036('0x14')]=_[_0x0036('0x15')](config[_0x0036('0x14')],{'host':'localhost','port':0x18eb});var socket=require(_0x0036('0x16'))(new Redis(config[_0x0036('0x14')]));require(_0x0036('0x17'))[_0x0036('0x18')](socket);function respondWithStatusCode(_0x4ec321,_0x186ce1){_0x186ce1=_0x186ce1||0xcc;return function(_0x421e62){if(_0x421e62){return _0x4ec321[_0x0036('0x19')](_0x186ce1);}return _0x4ec321[_0x0036('0x1a')](_0x186ce1)['end']();};}function respondWithResult(_0x578b9d,_0x3cff4b){_0x3cff4b=_0x3cff4b||0xc8;return function(_0x3905b4){if(_0x3905b4){return _0x578b9d[_0x0036('0x1a')](_0x3cff4b)[_0x0036('0x1b')](_0x3905b4);}};}function respondWithFilteredResult(_0x4b9421,_0xde2c32){return function(_0x47d490){if(_0x47d490){var _0x5be1de=typeof _0xde2c32[_0x0036('0x1c')]===_0x0036('0x1d')&&typeof _0xde2c32[_0x0036('0x1e')]===_0x0036('0x1d');var _0x2dab73=_0x47d490[_0x0036('0x1f')];var _0x592007=_0x5be1de?0x0:_0xde2c32[_0x0036('0x1c')];var _0x33b6f9=_0x5be1de?_0x47d490['count']:_0xde2c32[_0x0036('0x1c')]+_0xde2c32['limit'];var _0x369e1a;if(_0x33b6f9>=_0x2dab73){_0x33b6f9=_0x2dab73;_0x369e1a=0xc8;}else{_0x369e1a=0xce;}_0x4b9421['status'](_0x369e1a);return _0x4b9421[_0x0036('0x20')](_0x0036('0x21'),_0x592007+'-'+_0x33b6f9+'/'+_0x2dab73)[_0x0036('0x1b')](_0x47d490);}return null;};}function patchUpdates(_0x172d6d){return function(_0x58a88b){try{jsonpatch[_0x0036('0x22')](_0x58a88b,_0x172d6d,!![]);}catch(_0x39b614){return BPromise[_0x0036('0x23')](_0x39b614);}return _0x58a88b['save']();};}function saveUpdates(_0x5a06b3,_0x4a59cd){return function(_0x181034){if(_0x181034){return _0x181034[_0x0036('0x24')](_0x5a06b3)[_0x0036('0x25')](function(_0x54603b){return _0x54603b;});}return null;};}function removeEntity(_0x30100a,_0x4fc74e){return function(_0x4cf1af){if(_0x4cf1af){return _0x4cf1af[_0x0036('0x26')]()['then'](function(){_0x30100a[_0x0036('0x1a')](0xcc)[_0x0036('0x27')]();});}};}function handleEntityNotFound(_0x3a3b9e,_0x479d07){return function(_0x33da67){if(!_0x33da67){_0x3a3b9e[_0x0036('0x19')](0x194);}return _0x33da67;};}function handleError(_0x385ba6,_0x242a5d){_0x242a5d=_0x242a5d||0x1f4;return function(_0x3a767b){logger[_0x0036('0x28')](_0x3a767b[_0x0036('0x29')]);if(_0x3a767b[_0x0036('0x2a')]){delete _0x3a767b[_0x0036('0x2a')];}_0x385ba6[_0x0036('0x1a')](_0x242a5d)[_0x0036('0x2b')](_0x3a767b);};}function getMustacheRender(_0x4e8faf,_0x57df2a){return Mustache[_0x0036('0x2c')](_0x4e8faf,_[_0x0036('0x2d')](_0x57df2a[_0x0036('0x2e')],{'contact':_0x57df2a[_0x0036('0x2f')],'message':_0x57df2a[_0x0036('0x30')],'agent':_0x57df2a[_0x0036('0x31')],'interaction':_0x57df2a[_0x0036('0x32')],'account':_0x57df2a[_0x0036('0x33')]}))||'';}function getInteractionUsers(_0x16c65f,_0x4078c4){return new BPromise(function(_0x1d7120,_0x4a9877){try{if(_0x4078c4[_0x16c65f['id']]){_0x16c65f[_0x0036('0x34')]=_[_0x0036('0x35')](_0x4078c4[_0x16c65f['id']],function(_0x5122c2){return{'id':_0x5122c2['id'],'fullname':_0x5122c2[_0x0036('0x36')]};});}}catch(_0x319874){_0x4a9877(_0x319874);}_0x1d7120(_0x16c65f);});}function getInteractionTags(_0x3ee814,_0x53423a){return new BPromise(function(_0x412773,_0x571143){try{if(_0x3ee814[_0x0036('0x37')]){_0x3ee814[_0x0036('0x38')]=[];_0x3ee814['TagIds']['split'](',')[_0x0036('0x39')](function(_0x310039){_0x3ee814['Tags']['push'](_0x53423a[_0x310039]);});}delete _0x3ee814[_0x0036('0x37')];}catch(_0xec0db3){_0x571143(_0xec0db3);}_0x412773(_0x3ee814);});}function getLastMessageText(_0x30b82c){return new BPromise(function(_0xf33aa7,_0xc3e366){return db[_0x0036('0x3a')][_0x0036('0x3b')]({'where':{'$and':[{'MailInteractionId':_0x30b82c['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':_0x0036('0x3c')},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0x0036('0x3d')],'order':_0x0036('0x3e'),'raw':!![]})[_0x0036('0x25')](function(_0x51c03e){if(_0x51c03e&&_0x51c03e[_0x0036('0x3d')]){_0x30b82c['lastMsgText']=_[_0x0036('0x3f')](_0x51c03e['plainBody']);}_0xf33aa7(_0x30b82c);})['catch'](function(_0x7b4b78){_0xc3e366(_0x7b4b78);});});}function updateMailInteraction(_0x555e3e,_0x26dc8f,_0x4d9c8f,_0x2ba52a){return new BPromise(function(_0x5c1e79,_0x3e96f9){return getInteractionUsers(_0x555e3e,_0x4d9c8f)[_0x0036('0x25')](function(_0x23fb99){return getInteractionTags(_0x23fb99,_0x26dc8f);})[_0x0036('0x25')](function(_0x59d99b){if(_0x2ba52a){_0x5c1e79(getLastMessageText(_0x59d99b));}else{_0x5c1e79(_0x59d99b);}})['catch'](function(_0x970cc4){_0x3e96f9(_0x970cc4);});});}exports['index']=function(_0x1da95c,_0x9cdeb2){var _0x550d11={},_0x406afd={},_0x519ff3={'count':0x0,'rows':[]};var _0x2082a3=_[_0x0036('0x35')](db[_0x0036('0x40')][_0x0036('0x41')],function(_0x3ab8d8){return{'name':_0x3ab8d8[_0x0036('0x42')],'type':_0x3ab8d8[_0x0036('0x43')][_0x0036('0x44')]};});_0x406afd[_0x0036('0x45')]=_[_0x0036('0x35')](_0x2082a3,_0x0036('0x2a'));_0x406afd['query']=_[_0x0036('0x46')](_0x1da95c[_0x0036('0x47')]);_0x406afd[_0x0036('0x48')]=_[_0x0036('0x49')](_0x406afd['model'],_0x406afd[_0x0036('0x47')]);_0x550d11[_0x0036('0x4a')]=_[_0x0036('0x49')](_0x406afd[_0x0036('0x45')],qs[_0x0036('0x4b')](_0x1da95c['query'][_0x0036('0x4b')]));_0x550d11['attributes']=_0x550d11['attributes'][_0x0036('0x4c')]?_0x550d11[_0x0036('0x4a')]:_0x406afd[_0x0036('0x45')];if(!_0x1da95c[_0x0036('0x47')][_0x0036('0x4d')](_0x0036('0x4e'))){_0x550d11[_0x0036('0x1e')]=qs[_0x0036('0x1e')](_0x1da95c[_0x0036('0x47')][_0x0036('0x1e')]);_0x550d11[_0x0036('0x1c')]=qs[_0x0036('0x1c')](_0x1da95c[_0x0036('0x47')][_0x0036('0x1c')]);}_0x550d11[_0x0036('0x4f')]=qs[_0x0036('0x50')](_0x1da95c['query'][_0x0036('0x50')]);_0x550d11['where']=qs['filters'](_['pick'](_0x1da95c['query'],_0x406afd[_0x0036('0x48')]),_0x2082a3);var _0x3605b3=[];var _0xbf8c17=squel['select']()[_0x0036('0x51')]('id')[_0x0036('0x51')](_0x0036('0x2a'))[_0x0036('0x51')](_0x0036('0x52'))[_0x0036('0x53')]('tools_tags');var _0xc3009b=squel[_0x0036('0x54')]()[_0x0036('0x51')](_0x0036('0x55'))[_0x0036('0x51')](_0x0036('0x56'))['field'](_0x0036('0x57'))[_0x0036('0x53')]('user_has_mail_interactions','ui')[_0x0036('0x58')](_0x0036('0x59'),'u',_0x0036('0x5a'));var _0x30d9ad=squel[_0x0036('0x54')]()[_0x0036('0x53')](_0x0036('0x5b'),'i')[_0x0036('0x58')]('cm_contacts','c',_0x0036('0x5c'))[_0x0036('0x58')](_0x0036('0x59'),'o',_0x0036('0x5d'))['left_join'](_0x0036('0x5e'),'a',_0x0036('0x5f'))[_0x0036('0x58')]('mail_messages','me',_0x0036('0x60'))[_0x0036('0x58')]('mail_interaction_has_tags','it','it.MailInteractionId\x20=\x20i.id')[_0x0036('0x58')](_0x0036('0x61'),'t',_0x0036('0x62'));var _0x145f03=squel['expr']();var _0x5e344f=[];var _0x23744f=squel[_0x0036('0x63')]();var _0x52a209;if(_0x1da95c[_0x0036('0x47')][_0x0036('0x64')]){_0x52a209=as[_0x0036('0x65')](_0x1da95c[_0x0036('0x47')][_0x0036('0x64')]);var _0x7d2576=_0x52a209['sqlOperator'];for(var _0x5ef39a=0x0;_0x5ef39a<_0x52a209[_0x0036('0x66')][_0x0036('0x4c')];_0x5ef39a++){var _0xbd2d34=_0x52a209['conditions'][_0x5ef39a];var _0x2cfc89='i';var _0x381b1a=_['find'](_0x2082a3,[_0x0036('0x2a'),_0xbd2d34['field']]);if(!_0x381b1a){switch(_0xbd2d34['field']){case _0x0036('0x67'):if(_0xbd2d34[_0x0036('0x68')]==0x1){_0x30d9ad[_0x0036('0x69')]('`'+_0xbd2d34['field']+_0x0036('0x6a'));}else{_0x30d9ad['having']('`'+_0xbd2d34[_0x0036('0x51')]+'`\x20>\x200');}break;case _0x0036('0x6b'):if(_0xbd2d34[_0x0036('0x6c')]==='$substring'){if(_0xbd2d34['value'][_0x0036('0x6d')]('\x20')[_0x0036('0x4c')]>0x1){_0x145f03[_0x7d2576](_0x0036('0x6e'),qs[_0x0036('0x6f')](_0xbd2d34[_0x0036('0x68')]),null);}else{var _0x32d2f0='%'+_0xbd2d34['value']+'%';_0x145f03[_0x7d2576]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x32d2f0,_0x32d2f0,_0x32d2f0);}}else{_0x381b1a=_[_0x0036('0x70')](_0x2082a3,[_0x0036('0x2a'),_0x0036('0x71')]);_0xbd2d34[_0x0036('0x51')]=_0x0036('0x71');_0x176ae2=as[_0x0036('0x72')](_0x2cfc89,_0x381b1a['type'],_0xbd2d34);_0x145f03[_0x7d2576](_0x176ae2['text'],_0x176ae2[_0x0036('0x68')][_0x0036('0x73')],_0x176ae2[_0x0036('0x68')][_0x0036('0x27')]);}break;case _0x0036('0x74'):var _0xa29e41=_0xbd2d34[_0x0036('0x68')][_0x0036('0x6d')](',')[_0x0036('0x35')](function(_0x42132a){return Number(_0x42132a);});_0xa29e41[_0x0036('0x39')](function(_0x61d588){_0x23744f['or'](_0x0036('0x75'),'%,'+_0x61d588+',%');});_0x5e344f=_[_0x0036('0x76')](_0x5e344f,_0xa29e41);break;case _0x0036('0x77'):if(_0xbd2d34[_0x0036('0x6c')]===_0x0036('0x78')){_0x145f03[_0x7d2576](_0x0036('0x79'),'%'+_0xbd2d34[_0x0036('0x68')]+'%',null);}else{_0x381b1a=_[_0x0036('0x70')](_0x2082a3,[_0x0036('0x2a'),'UserId']);_0xbd2d34[_0x0036('0x51')]='UserId';_0x176ae2=as[_0x0036('0x72')](_0x2cfc89,_0x381b1a[_0x0036('0x43')],_0xbd2d34);_0x145f03[_0x7d2576](_0x176ae2[_0x0036('0x7a')],_0x176ae2[_0x0036('0x68')][_0x0036('0x73')],_0x176ae2[_0x0036('0x68')][_0x0036('0x27')]);}break;case _0x0036('0x3d'):_0x176ae2=as[_0x0036('0x72')]('me',null,_0xbd2d34);_0x145f03[_0x7d2576](_0x176ae2[_0x0036('0x7a')],_0x176ae2[_0x0036('0x68')]['start'],_0x176ae2[_0x0036('0x68')][_0x0036('0x27')]);break;}}else{var _0x176ae2=as[_0x0036('0x72')](_0x2cfc89,_0x381b1a['type'],_0xbd2d34);_0x145f03[_0x7d2576](_0x176ae2[_0x0036('0x7a')],_0x176ae2[_0x0036('0x68')]['start'],_0x176ae2[_0x0036('0x68')]['end']);}}}else{var _0x32c7d2=_(_0x1da95c[_0x0036('0x47')])[_0x0036('0x46')]()[_0x0036('0x35')](function(_0x217509){return _[_0x0036('0x7b')](_0x2082a3,['name',_0x217509])?_0x217509:undefined;})[_0x0036('0x7c')]()[_0x0036('0x68')]();if(!_[_0x0036('0x7d')](_0x32c7d2)){_0x32c7d2['forEach'](function(_0x4aa92f){if(_0x4aa92f===_0x0036('0x7e')){_0x30d9ad['where']('i.MailAccountId\x20IN\x20?',[]['concat'](_0x1da95c[_0x0036('0x47')][_0x4aa92f]));}else if(_0x4aa92f===_0x0036('0x7f')){var _0x52082a=JSON[_0x0036('0x80')](_0x1da95c[_0x0036('0x47')][_0x4aa92f])['$gte'];var _0x29cc1e=JSON[_0x0036('0x80')](_0x1da95c[_0x0036('0x47')][_0x4aa92f])[_0x0036('0x81')];_0x30d9ad[_0x0036('0x82')](_0x0036('0x83'),_0x52082a,_0x29cc1e);}else{if(_0x1da95c[_0x0036('0x47')][_0x4aa92f]===_0x0036('0x84')){_0x30d9ad[_0x0036('0x82')]('i.'+_0x4aa92f+'\x20IS\x20NULL');}else{_0x30d9ad['where']('i.'+_0x4aa92f+_0x0036('0x85'),_0x1da95c[_0x0036('0x47')][_0x4aa92f]);}}});}if(_0x1da95c[_0x0036('0x47')][_0x0036('0x86')]){if(_0x1da95c[_0x0036('0x47')]['read']==0x1){_0x30d9ad[_0x0036('0x69')]('`unreadMessages`\x20=\x200');}else{_0x30d9ad[_0x0036('0x69')](_0x0036('0x87'));}}if(_0x1da95c['query'][_0x0036('0x88')]){_0x5e344f=_[_0x0036('0x89')](_0x1da95c[_0x0036('0x47')][_0x0036('0x88')])?_0x1da95c[_0x0036('0x47')][_0x0036('0x88')]:new Array(_0x1da95c['query'][_0x0036('0x88')]);_0x5e344f[_0x0036('0x39')](function(_0x1295b8){_0x23744f['or'](_0x0036('0x75'),'%,'+_0x1295b8+',%');});}if(_0x1da95c[_0x0036('0x47')][_0x0036('0x8a')]){var _0x5dd363=_0x1da95c[_0x0036('0x47')][_0x0036('0x8a')][_0x0036('0x8b')]('\x5c','\x5c\x5c')[_0x0036('0x8b')](/'/g,'\x27\x27');if(qs[_0x0036('0x8c')](_0x5dd363)){_0x145f03['or']('i.id\x20LIKE\x20?',_0x5dd363+'%');}else if(qs[_0x0036('0x8d')](_0x5dd363)){_0x145f03['or'](_0x0036('0x8e'),_0x5dd363+'%');}else{_0x145f03['or'](_0x0036('0x8f'),qs[_0x0036('0x6f')](_0x5dd363))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x0036('0x6f')](_0x5dd363));}}}_0x30d9ad[_0x0036('0x82')](_0x145f03);_0x30d9ad[_0x0036('0x90')](_0x0036('0x91'));var _0x3efc56={'type':db[_0x0036('0x92')][_0x0036('0x93')][_0x0036('0x94')],'raw':!![]};var _0x3ec91c=_0x30d9ad[_0x0036('0x95')]();_0x3ec91c[_0x0036('0x51')]('i.id');_0x3ec91c[_0x0036('0x51')](_0x0036('0x96'),_0x0036('0x67'));if(_0x550d11[_0x0036('0x4f')]){_0x550d11[_0x0036('0x4f')]['forEach'](function(_0x58b2f6){var _0x432396=_0x58b2f6[0x0]==='contactName'?_0x58b2f6[0x0]:'i.'+_0x58b2f6[0x0];_0x30d9ad[_0x0036('0x4f')](_0x432396,_0x58b2f6[0x1]===_0x0036('0x97')?![]:!![]);});}if(!_['isEmpty'](_0x5e344f)){_0x30d9ad[_0x0036('0x69')](_0x23744f);_0x3ec91c[_0x0036('0x82')](_0x0036('0x98'),_0x5e344f);}BPromise[_0x0036('0x99')]()['then'](function(){if(!_0x52a209){if(_0x1da95c[_0x0036('0x47')][_0x0036('0x7e')])return;_0x3ec91c[_0x0036('0x82')](_0x0036('0x9a'));_0x30d9ad[_0x0036('0x82')](_0x0036('0x9a'));return;}if(_0x1da95c[_0x0036('0x9b')]['role']!=='agent')return;return _0x1da95c['user'][_0x0036('0x9c')]({'attributes':['id'],'raw':!![]})[_0x0036('0x25')](function(_0x1f832e){if(_[_0x0036('0x7d')](_0x1f832e)){_0x3ec91c['where'](_0x0036('0x9d'));_0x30d9ad['where'](_0x0036('0x9d'));}else{_0x3ec91c[_0x0036('0x82')](_0x0036('0x9e'),_[_0x0036('0x35')](_0x1f832e,'id'));_0x30d9ad[_0x0036('0x82')](_0x0036('0x9e'),_['map'](_0x1f832e,'id'));}});})[_0x0036('0x25')](function(){if(_0x1da95c[_0x0036('0x9b')]['role']===_0x0036('0x31')&&!_0x52a209&&!_0x1da95c['query'][_0x0036('0x7e')])return[];return db[_0x0036('0x9f')][_0x0036('0x47')](_0x3ec91c[_0x0036('0xa0')](),_0x3efc56);})[_0x0036('0x25')](function(_0xe773b8){_0x519ff3[_0x0036('0x1f')]=_0xe773b8[_0x0036('0x4c')];if(_0x519ff3[_0x0036('0x1f')]===0x0)return[];return db['sequelize']['query'](_0xbf8c17[_0x0036('0xa0')](),_0x3efc56)[_0x0036('0x25')](function(_0x44dac3){_0x3605b3=_[_0x0036('0xa1')](_0x44dac3,'id');_0x3efc56=_[_0x0036('0x2d')](_0x3efc56,{'model':db['MailInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x1da95c[_0x0036('0x47')][_0x0036('0x4b')]){_0x550d11['attributes'][_0x0036('0x39')](function(_0x1de7e3){_0x30d9ad['field']('i.'+_0x1de7e3);});}else{_0x30d9ad[_0x0036('0x51')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x0036('0x67'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xa2'),_0x0036('0xa3'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xa4'),_0x0036('0xa5'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xa6'),_0x0036('0xa7'));_0x30d9ad[_0x0036('0x51')](_0x0036('0x91'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xa8'));_0x30d9ad[_0x0036('0x51')]('i.updatedAt');_0x30d9ad[_0x0036('0x51')](_0x0036('0xa9'));_0x30d9ad[_0x0036('0x51')]('i.closedAt');_0x30d9ad[_0x0036('0x51')]('i.attach');_0x30d9ad[_0x0036('0x51')](_0x0036('0xaa'));_0x30d9ad['field'](_0x0036('0xab'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xac'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xad'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xae'));_0x30d9ad[_0x0036('0x51')]('i.thirdDisposition');_0x30d9ad[_0x0036('0x51')](_0x0036('0xaf'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb0'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb1'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb2'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb3'));_0x30d9ad['field'](_0x0036('0xb4'),_0x0036('0xb5'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb6'),'Contact.lastName');_0x30d9ad[_0x0036('0x51')]('c.email',_0x0036('0xb7'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb8'),_0x0036('0xb9'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xba'),'Contact.mobile');_0x30d9ad[_0x0036('0x51')]('c.fax','Contact.fax');_0x30d9ad['field'](_0x0036('0xbb'),'Owner.fullname');_0x30d9ad[_0x0036('0x51')]('o.internal',_0x0036('0xbc'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xbd'),_0x0036('0x37'));}if(_0x550d11['limit'])_0x30d9ad[_0x0036('0x1e')](_0x550d11[_0x0036('0x1e')]);if(_0x550d11[_0x0036('0x1c')])_0x30d9ad[_0x0036('0x1c')](_0x550d11[_0x0036('0x1c')]);return db[_0x0036('0x9f')]['query'](_0x30d9ad['toString'](),_0x3efc56);})[_0x0036('0x25')](function(_0x3524d8){if(_0x3524d8[_0x0036('0x4c')]>0x0)_0xc3009b[_0x0036('0x82')](_0x0036('0xbe'),_['map'](_0x3524d8,'id'));return db['sequelize'][_0x0036('0x47')](_0xc3009b[_0x0036('0xa0')](),_0x3efc56)[_0x0036('0x25')](function(_0x4b31d2){var _0x2e9776=_[_0x0036('0xbf')](_0x4b31d2,_0x0036('0xc0'));var _0x3f116d=[];return db[_0x0036('0xc1')]['findOne']({'attributes':[_0x0036('0xc2')],'raw':!![]})[_0x0036('0x25')](function(_0xe56710){var _0xc414fd=_0xe56710[_0x0036('0xc2')];_0x3524d8[_0x0036('0x39')](function(_0x14ed82){_0x3f116d['push'](updateMailInteraction(_0x14ed82,_0x3605b3,_0x2e9776,_0xc414fd));});return BPromise[_0x0036('0xc3')](_0x3f116d);});});});})['then'](function(_0x1b2015){_0x519ff3[_0x0036('0xc4')]=_0x1b2015;return _0x519ff3;})['then'](respondWithFilteredResult(_0x9cdeb2,_0x550d11))['catch'](handleError(_0x9cdeb2,null));};exports[_0x0036('0xc5')]=function(_0x1c90f2,_0x580fe7){var _0x5451bc={'raw':![],'where':{'id':_0x1c90f2['params']['id']}},_0x344e7e={};_0x344e7e[_0x0036('0x45')]=_['keys'](db[_0x0036('0x40')]['rawAttributes']);_0x344e7e['query']=_[_0x0036('0x46')](_0x1c90f2[_0x0036('0x47')]);_0x344e7e[_0x0036('0x48')]=_[_0x0036('0x49')](_0x344e7e[_0x0036('0x45')],_0x344e7e['query']);_0x5451bc[_0x0036('0x4a')]=_['intersection'](_0x344e7e[_0x0036('0x45')],qs[_0x0036('0x4b')](_0x1c90f2[_0x0036('0x47')][_0x0036('0x4b')]));_0x5451bc['attributes']=_0x5451bc['attributes'][_0x0036('0x4c')]?_0x5451bc[_0x0036('0x4a')]:_0x344e7e[_0x0036('0x45')];if(_0x1c90f2[_0x0036('0x47')][_0x0036('0xc6')]){_0x5451bc[_0x0036('0xc7')]=[{'all':!![]}];}_0x5451bc=_['merge']({},_0x5451bc,_0x1c90f2[_0x0036('0xc8')]);return db[_0x0036('0x40')][_0x0036('0x70')](_0x5451bc)[_0x0036('0x25')](handleEntityNotFound(_0x580fe7,null))[_0x0036('0x25')](respondWithResult(_0x580fe7,null))[_0x0036('0xc9')](handleError(_0x580fe7,null));};exports[_0x0036('0xca')]=function(_0x1b4b24,_0x1430df){return db['MailInteraction'][_0x0036('0xca')](_0x1b4b24[_0x0036('0x2e')],{})[_0x0036('0x25')](respondWithResult(_0x1430df,0xc9))['catch'](handleError(_0x1430df,null));};exports[_0x0036('0x24')]=function(_0x397c3f,_0x5a58fd){if(_0x397c3f[_0x0036('0x2e')]['id']){delete _0x397c3f[_0x0036('0x2e')]['id'];}return db[_0x0036('0x40')]['find']({'where':{'id':_0x397c3f[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x5a58fd,null))[_0x0036('0x25')](saveUpdates(_0x397c3f['body'],null))[_0x0036('0x25')](respondWithResult(_0x5a58fd,null))[_0x0036('0xc9')](handleError(_0x5a58fd,null));};exports[_0x0036('0x26')]=function(_0x5f07bb,_0x441ccc){return db[_0x0036('0x40')][_0x0036('0x70')]({'where':{'id':_0x5f07bb[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x441ccc,null))[_0x0036('0x25')](removeEntity(_0x441ccc,null))[_0x0036('0xc9')](handleError(_0x441ccc,null));};exports[_0x0036('0xcc')]=function(_0x13c628,_0x1cf9fc){return db[_0x0036('0x40')][_0x0036('0xcc')]()[_0x0036('0x25')](respondWithResult(_0x1cf9fc,null))[_0x0036('0xc9')](handleError(_0x1cf9fc,null));};exports[_0x0036('0xcd')]=function(_0x3ce8a3,_0x1ecf54,_0x47adda){return db[_0x0036('0x3a')]['find']({'where':{'id':_0x3ce8a3[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x1ecf54,null))[_0x0036('0x25')](function(_0x3344f5){if(_0x3344f5){return _0x3344f5['addMessage'](_0x3ce8a3[_0x0036('0x2e')][_0x0036('0xce')],_[_0x0036('0xcf')](_0x3ce8a3[_0x0036('0x2e')],[_0x0036('0xce'),'id'])||{});}})['then'](respondWithResult(_0x1ecf54,null))['catch'](handleError(_0x1ecf54,null));};exports['getMessages']=function(_0x5f1e2d,_0xc9cb48,_0x40ad95){var _0x5b2527={'raw':![],'where':{}};var _0x338f46={};var _0x47179f={'count':0x0,'rows':[]};return db[_0x0036('0x40')]['findOne']({'where':{'id':_0x5f1e2d[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0xc9cb48,null))[_0x0036('0x25')](function(_0x2ab355){if(_0x2ab355){_0x338f46[_0x0036('0x45')]=_[_0x0036('0x46')](db[_0x0036('0x3a')][_0x0036('0x41')]);_0x338f46[_0x0036('0x47')]=_['keys'](_0x5f1e2d[_0x0036('0x47')]);_0x338f46[_0x0036('0x48')]=_[_0x0036('0x49')](_0x338f46[_0x0036('0x45')],_0x338f46[_0x0036('0x47')]);_0x5b2527['attributes']=_['intersection'](_0x338f46['model'],qs[_0x0036('0x4b')](_0x5f1e2d[_0x0036('0x47')][_0x0036('0x4b')]));_0x5b2527[_0x0036('0x4a')]=_0x5b2527['attributes'][_0x0036('0x4c')]?_0x5b2527[_0x0036('0x4a')]:_0x338f46['model'];if(!_0x5f1e2d[_0x0036('0x47')][_0x0036('0x4d')]('nolimit')){_0x5b2527[_0x0036('0x1e')]=qs[_0x0036('0x1e')](_0x5f1e2d['query'][_0x0036('0x1e')]);_0x5b2527[_0x0036('0x1c')]=qs['offset'](_0x5f1e2d[_0x0036('0x47')][_0x0036('0x1c')]);}_0x5b2527[_0x0036('0x4f')]=qs[_0x0036('0x50')](_0x5f1e2d[_0x0036('0x47')][_0x0036('0x50')]);_0x5b2527[_0x0036('0x82')]=qs[_0x0036('0x48')](_[_0x0036('0xd0')](_0x5f1e2d[_0x0036('0x47')],_0x338f46[_0x0036('0x48')]));_0x5b2527[_0x0036('0x82')][_0x0036('0xc0')]=_0x2ab355['id'];if(_0x5f1e2d[_0x0036('0x47')]['filter']){_0x5b2527[_0x0036('0x82')]=_[_0x0036('0x2d')](_0x5b2527[_0x0036('0x82')],{'$or':_['map'](_0x5b2527[_0x0036('0x4a')],function(_0x108153){var _0x5f2dec={};_0x5f2dec[_0x108153]={'$like':'%'+_0x5f1e2d[_0x0036('0x47')]['filter']+'%'};return _0x5f2dec;})});}if(_0x5f1e2d['query'][_0x0036('0xd1')]){var _0x59a49e=_0x5f1e2d[_0x0036('0x47')][_0x0036('0xd1')][_0x0036('0x6d')](',');var _0x450159={};_0x450159[_0x59a49e[0x0]]={'$gte':moment(_0x59a49e[0x1])[_0x0036('0xd2')](_0x0036('0xd3'))};_0x5b2527[_0x0036('0x82')]=_['merge'](_0x5b2527['where'],_0x450159);}_0x5b2527=_[_0x0036('0x2d')]({},_0x5b2527,_0x5f1e2d[_0x0036('0xc8')]);return db[_0x0036('0x3a')][_0x0036('0x1f')]({'where':_0x5b2527[_0x0036('0x82')]})['then'](function(_0x434d1b){_0x47179f[_0x0036('0x1f')]=_0x434d1b;if(_0x5f1e2d[_0x0036('0x47')][_0x0036('0xc6')]){_0x5b2527['include']=[{'all':!![]}];}return db[_0x0036('0x3a')][_0x0036('0xd4')](_0x5b2527);})['then'](function(_0x46e1d5){if(_0x5f1e2d[_0x0036('0x47')][_0x0036('0xd5')]===_0x0036('0xd6')){for(var _0x2e2c11=0x0;_0x2e2c11<_0x46e1d5[_0x0036('0x4c')];_0x2e2c11++){_0x46e1d5[_0x2e2c11]['body']=juice(_0x46e1d5[_0x2e2c11]['body']);}}_0x47179f[_0x0036('0xc4')]=_0x46e1d5;return _0x47179f;});}})[_0x0036('0x25')](respondWithFilteredResult(_0xc9cb48,_0x5b2527))[_0x0036('0xc9')](handleError(_0xc9cb48,null));};exports[_0x0036('0xd7')]=function(_0x59e51c,_0x42e91c,_0x24a41d){return db[_0x0036('0x40')][_0x0036('0x70')]({'where':{'id':_0x59e51c[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x42e91c,null))[_0x0036('0x25')](function(_0x679bb){if(_0x679bb){return _0x679bb['setTags'](_0x59e51c['body'][_0x0036('0xce')],_[_0x0036('0xcf')](_0x59e51c['body'],[_0x0036('0xce'),'id'])||{})[_0x0036('0xd8')](function(){return db[_0x0036('0x74')]['findAll']({'attributes':['id',_0x0036('0x2a'),'color'],'where':{'id':_0x59e51c[_0x0036('0x2e')][_0x0036('0xce')]}});})[_0x0036('0x25')](function(_0x1f933d){socket[_0x0036('0xd9')](_0x0036('0xda'),{'id':Number(_0x59e51c[_0x0036('0xcb')]['id']),'tags':_0x1f933d||[]});return{'id':Number(_0x59e51c[_0x0036('0xcb')]['id']),'tags':_0x1f933d||[]};});}})[_0x0036('0x25')](respondWithResult(_0x42e91c,null))['catch'](handleError(_0x42e91c,null));};exports['removeTags']=function(_0x47fd14,_0x4c31a0,_0xc885ee){return db[_0x0036('0x40')][_0x0036('0x70')]({'where':{'id':_0x47fd14[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x4c31a0,null))['then'](function(_0x4d9f73){if(_0x4d9f73){return _0x4d9f73['removeTags'](_0x47fd14[_0x0036('0x47')][_0x0036('0xce')]);}})[_0x0036('0x25')](respondWithStatusCode(_0x4c31a0,null))[_0x0036('0xc9')](handleError(_0x4c31a0,null));};exports['download']=function(_0x269613,_0x300446){var _0xa88dc9=moment()[_0x0036('0xdb')]()[_0x0036('0xa0')]();var _0x2c1104=path[_0x0036('0xdc')](config['root'],'server',_0x0036('0xdd'),'tmp');var _0x372ea9=path[_0x0036('0xdc')](config[_0x0036('0xde')],_0x0036('0xdf'),_0x0036('0xdd'),_0x0036('0xe0'));var _0x2b9764=path[_0x0036('0xdc')](_0x2c1104,_0xa88dc9);var _0x7257d5=util[_0x0036('0xd2')](_0x0036('0xe1'),_0x269613[_0x0036('0xcb')]['id'],_0xa88dc9);var _0xbf296d=path[_0x0036('0xdc')](_0x2c1104,_0x7257d5);var _0x40161e=[];if(_0x269613['query']['attachments']){_0x40161e[_0x0036('0xe2')]({'model':db['Attachment'],'as':'Attachments','raw':!![]});}var _0x1ffbd2=[{'model':db[_0x0036('0x3a')],'as':_0x0036('0xe3'),'attributes':['id','body',_0x0036('0x53'),'to','cc','bcc',_0x0036('0xe4'),'createdAt'],'where':{'secret':![]},'order':qs[_0x0036('0x50')]('id'),'include':_0x40161e}];return db[_0x0036('0x40')][_0x0036('0x70')]({'where':{'id':_0x269613[_0x0036('0xcb')]['id']},'include':_0x1ffbd2})['then'](handleEntityNotFound(_0x300446,null))[_0x0036('0x25')](function(_0xa4b36c){if(_0xa4b36c&&_0xa4b36c[_0x0036('0xe3')]){var _0x55777b=_0xa4b36c[_0x0036('0xe5')]({'plain':!![]});fs[_0x0036('0xe6')](_0x2b9764);return BPromise[_0x0036('0xe7')](_0x55777b[_0x0036('0xe3')],function(_0xffaf8d,_0x15b0ea){var _0x1a0d28={'from':_0xffaf8d['from'],'to':_0xffaf8d['to'],'subject':_0xffaf8d[_0x0036('0xe4')],'html':_0xffaf8d[_0x0036('0x2e')],'headers':{'Date':moment(_0xffaf8d['createdAt'])[_0x0036('0xd2')](_0x0036('0xe8'))},'attachments':[]};if(_0xffaf8d['cc']){_0x1a0d28['headers']['Cc']=_0xffaf8d['cc'];}if(_0xffaf8d['bcc']){_0x1a0d28[_0x0036('0xe9')]['Bcc']=_0xffaf8d[_0x0036('0xea')];}return new BPromise(function(_0x57643a,_0x1f0ea6){if(_0xffaf8d[_0x0036('0xeb')]){for(var _0x1ac0bb=0x0;_0x1ac0bb<_0xffaf8d[_0x0036('0xeb')][_0x0036('0x4c')];_0x1ac0bb++){var _0x3ff740=_0xffaf8d['Attachments'][_0x1ac0bb];var _0x437f02=path[_0x0036('0xdc')](_0x372ea9,_0x3ff740[_0x0036('0xec')]);if(fs[_0x0036('0xed')](_0x437f02)){_0x1a0d28[_0x0036('0xe0')]['push']({'name':_0x3ff740[_0x0036('0x2a')],'contentType':_0x3ff740[_0x0036('0x43')],'data':fs[_0x0036('0xee')](_0x437f02)});}}}emlformat[_0x0036('0xef')](_0x1a0d28,function(_0x479527,_0x391f47){if(_0x479527)return _0x1f0ea6(_0x479527);fs[_0x0036('0xf0')](path[_0x0036('0xdc')](_0x2b9764,util[_0x0036('0xd2')]('message%d.eml',_0x15b0ea)),_0x391f47);return _0x57643a(_0x391f47);});});})['then'](function(){return new BPromise(function(_0x5bcb43,_0x337db6){zipdir(_0x2b9764,{'saveTo':_0xbf296d},function(_0x2bdf31,_0x3b3a44){if(_0x2bdf31)return _0x337db6(_0x2bdf31);return _0x5bcb43(_0x3b3a44);});})[_0x0036('0x25')](function(){return new BPromise(function(_0x253267,_0x44b119){rimraf(_0x2b9764,function(_0x5b01ad){if(_0x5b01ad)_0x44b119(_0x5b01ad);return _0x253267();});});})[_0x0036('0x25')](function(){return _0x300446['download'](_0xbf296d,_0x7257d5,function(_0xa84a18){if(_0xa84a18){console['log'](_0x0036('0xf1'),_0xa84a18);}else{fs[_0x0036('0xf2')](_0xbf296d);}});});});}else{return _0x300446['sendStatus'](0xc8);}})[_0x0036('0xc9')](handleError(_0x300446,null));};
\ No newline at end of file
+var _0x8d42=['search','sqlOperator','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','operator','$substring','length','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','ContactId','text','start','Tag','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','buildExpression','some','compact','isEmpty','MailAccountId','concat','createdAt','$gte','parse','$lte','null','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','filter','replace','isNumeric','i.id\x20LIKE\x20?','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.id','Sequelize','QueryTypes','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','contactName','t.id\x20IN\x20?','resolve','i.MailAccountId\x20IS\x20NOT\x20NULL','user','role','getMailAccounts','i.MailAccountId\x20IS\x20NULL','i.MailAccountId\x20IN\x20?','agent','sequelize','toString','keyBy','MailInteraction','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.subject','i.disposition','i.secondDisposition','i.substatus','i.to','i.ContactId','Contact.firstName','c.lastName','Contact.lastName','c.email','c.phone','Contact.phone','c.mobile','c.fax','Owner.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','all','rows','show','params','include','create','describe','addMessage','ids','getMessages','hasOwnProperty','nolimit','sort','pick','format','options','findAll','true','omit','spread','color','emit','mailInteractionTags:save','download','unix','join','root','server','files','tmp','attachments','transcript-%d-%s.zip','Attachment','Attachments','bcc','subject','get','mkdirSync','each','Messages','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','basename','existsSync','readFileSync','build','writeFileSync','message%d.eml','log','unlinkSync','eml-format','rimraf','fast-json-patch','request-promise','moment','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','html-to-text','juice','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','./mailInteraction.socket','register','sendStatus','status','end','json','offset','count','limit','Content-Range','apply','update','then','destroy','error','stack','name','send','render','merge','body','contact','message','interaction','account','Users','map','fullname','TagIds','Tags','split','forEach','push','MailMessage','findOne','out','plainBody','-id','lastMsgText','trimStart','catch','index','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','attributes','order','where','select','field','from','tools_tags','u.id','u.fullname','user_has_mail_interactions','mail_interactions','left_join','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','a.id\x20=\x20i.MailAccountId','mail_messages','me.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','parseSearch'];(function(_0x2e0ffa,_0x451f12){var _0x24d627=function(_0x4d0f09){while(--_0x4d0f09){_0x2e0ffa['push'](_0x2e0ffa['shift']());}};_0x24d627(++_0x451f12);}(_0x8d42,0x18d));var _0x28d4=function(_0xf0bcac,_0x531755){_0xf0bcac=_0xf0bcac-0x0;var _0x4e4c65=_0x8d42[_0xf0bcac];return _0x4e4c65;};'use strict';var emlformat=require(_0x28d4('0x0'));var rimraf=require(_0x28d4('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x28d4('0x2'));var rp=require(_0x28d4('0x3'));var moment=require(_0x28d4('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x28d4('0x5'));var path=require(_0x28d4('0x6'));var sox=require(_0x28d4('0x7'));var csv=require(_0x28d4('0x8'));var ejs=require(_0x28d4('0x9'));var fs=require('fs');var fs_extra=require(_0x28d4('0xa'));var _=require('lodash');var squel=require(_0x28d4('0xb'));var crypto=require(_0x28d4('0xc'));var jsforce=require(_0x28d4('0xd'));var deskjs=require(_0x28d4('0xe'));var toCsv=require(_0x28d4('0x8'));var querystring=require(_0x28d4('0xf'));var Papa=require(_0x28d4('0x10'));var htmlToText=require(_0x28d4('0x11'));var juice=require(_0x28d4('0x12'));var Redis=require(_0x28d4('0x13'));var authService=require(_0x28d4('0x14'));var qs=require(_0x28d4('0x15'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x28d4('0x16'));var logger=require('../../config/logger')(_0x28d4('0x17'));var utils=require(_0x28d4('0x18'));var config=require(_0x28d4('0x19'));var licenseUtil=require(_0x28d4('0x1a'));var db=require(_0x28d4('0x1b'))['db'];config[_0x28d4('0x1c')]=_[_0x28d4('0x1d')](config[_0x28d4('0x1c')],{'host':_0x28d4('0x1e'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x28d4('0x1c')]));require(_0x28d4('0x1f'))[_0x28d4('0x20')](socket);function respondWithStatusCode(_0x257f00,_0x2cab07){_0x2cab07=_0x2cab07||0xcc;return function(_0x4079b3){if(_0x4079b3){return _0x257f00[_0x28d4('0x21')](_0x2cab07);}return _0x257f00[_0x28d4('0x22')](_0x2cab07)[_0x28d4('0x23')]();};}function respondWithResult(_0x2aa68d,_0x40330b){_0x40330b=_0x40330b||0xc8;return function(_0x1a7918){if(_0x1a7918){return _0x2aa68d[_0x28d4('0x22')](_0x40330b)[_0x28d4('0x24')](_0x1a7918);}};}function respondWithFilteredResult(_0x4fef35,_0x42b86d){return function(_0x1436c8){if(_0x1436c8){var _0x546002=typeof _0x42b86d[_0x28d4('0x25')]==='undefined'&&typeof _0x42b86d['limit']==='undefined';var _0x5cca64=_0x1436c8[_0x28d4('0x26')];var _0x23a439=_0x546002?0x0:_0x42b86d[_0x28d4('0x25')];var _0x48ddda=_0x546002?_0x1436c8[_0x28d4('0x26')]:_0x42b86d[_0x28d4('0x25')]+_0x42b86d[_0x28d4('0x27')];var _0x165f59;if(_0x48ddda>=_0x5cca64){_0x48ddda=_0x5cca64;_0x165f59=0xc8;}else{_0x165f59=0xce;}_0x4fef35['status'](_0x165f59);return _0x4fef35['set'](_0x28d4('0x28'),_0x23a439+'-'+_0x48ddda+'/'+_0x5cca64)[_0x28d4('0x24')](_0x1436c8);}return null;};}function patchUpdates(_0x1263ff){return function(_0x24fcd1){try{jsonpatch[_0x28d4('0x29')](_0x24fcd1,_0x1263ff,!![]);}catch(_0x34db2a){return BPromise['reject'](_0x34db2a);}return _0x24fcd1['save']();};}function saveUpdates(_0x12476e,_0x4a83ba){return function(_0x25f0fc){if(_0x25f0fc){return _0x25f0fc[_0x28d4('0x2a')](_0x12476e)[_0x28d4('0x2b')](function(_0x410e7e){return _0x410e7e;});}return null;};}function removeEntity(_0x31508d,_0x18dd3d){return function(_0x45f898){if(_0x45f898){return _0x45f898[_0x28d4('0x2c')]()[_0x28d4('0x2b')](function(){_0x31508d[_0x28d4('0x22')](0xcc)['end']();});}};}function handleEntityNotFound(_0x14cc76,_0x3aaf20){return function(_0x3d6236){if(!_0x3d6236){_0x14cc76[_0x28d4('0x21')](0x194);}return _0x3d6236;};}function handleError(_0x2002f5,_0x1ed1cb){_0x1ed1cb=_0x1ed1cb||0x1f4;return function(_0x142755){logger[_0x28d4('0x2d')](_0x142755[_0x28d4('0x2e')]);if(_0x142755['name']){delete _0x142755[_0x28d4('0x2f')];}_0x2002f5[_0x28d4('0x22')](_0x1ed1cb)[_0x28d4('0x30')](_0x142755);};}function getMustacheRender(_0x221761,_0x1804e2){return Mustache[_0x28d4('0x31')](_0x221761,_[_0x28d4('0x32')](_0x1804e2[_0x28d4('0x33')],{'contact':_0x1804e2[_0x28d4('0x34')],'message':_0x1804e2[_0x28d4('0x35')],'agent':_0x1804e2['agent'],'interaction':_0x1804e2[_0x28d4('0x36')],'account':_0x1804e2[_0x28d4('0x37')]}))||'';}function getInteractionUsers(_0x5e483d,_0x57b48d){return new BPromise(function(_0x158d45,_0x1e205a){try{if(_0x57b48d[_0x5e483d['id']]){_0x5e483d[_0x28d4('0x38')]=_[_0x28d4('0x39')](_0x57b48d[_0x5e483d['id']],function(_0x5b4e55){return{'id':_0x5b4e55['id'],'fullname':_0x5b4e55[_0x28d4('0x3a')]};});}}catch(_0x4971b4){_0x1e205a(_0x4971b4);}_0x158d45(_0x5e483d);});}function getInteractionTags(_0x27e810,_0x1f0d76){return new BPromise(function(_0x27f439,_0x10f2eb){try{if(_0x27e810[_0x28d4('0x3b')]){_0x27e810[_0x28d4('0x3c')]=[];_0x27e810[_0x28d4('0x3b')][_0x28d4('0x3d')](',')[_0x28d4('0x3e')](function(_0x4ac170){_0x27e810['Tags'][_0x28d4('0x3f')](_0x1f0d76[_0x4ac170]);});}delete _0x27e810[_0x28d4('0x3b')];}catch(_0x303309){_0x10f2eb(_0x303309);}_0x27f439(_0x27e810);});}function getLastMessageText(_0xc97a9d){return new BPromise(function(_0x1de0bb,_0x11eb12){return db[_0x28d4('0x40')][_0x28d4('0x41')]({'where':{'$and':[{'MailInteractionId':_0xc97a9d['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':_0x28d4('0x42')},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0x28d4('0x43')],'order':_0x28d4('0x44'),'raw':!![]})['then'](function(_0x41c4f7){if(_0x41c4f7&&_0x41c4f7['plainBody']){_0xc97a9d[_0x28d4('0x45')]=_[_0x28d4('0x46')](_0x41c4f7['plainBody']);}_0x1de0bb(_0xc97a9d);})[_0x28d4('0x47')](function(_0x586f66){_0x11eb12(_0x586f66);});});}function updateMailInteraction(_0x4c6182,_0x391bf1,_0x1465a0,_0x31096a){return new BPromise(function(_0x1bc63a,_0x1b5376){return getInteractionUsers(_0x4c6182,_0x1465a0)[_0x28d4('0x2b')](function(_0x55b15b){return getInteractionTags(_0x55b15b,_0x391bf1);})[_0x28d4('0x2b')](function(_0x361adf){if(_0x31096a){_0x1bc63a(getLastMessageText(_0x361adf));}else{_0x1bc63a(_0x361adf);}})['catch'](function(_0x554e1d){_0x1b5376(_0x554e1d);});});}exports[_0x28d4('0x48')]=function(_0x3f8167,_0x1d2a32){var _0x438cb7={},_0x50e499={},_0x3451a7={'count':0x0,'rows':[]};var _0x211383=_[_0x28d4('0x39')](db['MailInteraction'][_0x28d4('0x49')],function(_0x121177){return{'name':_0x121177[_0x28d4('0x4a')],'type':_0x121177[_0x28d4('0x4b')]['key']};});_0x50e499[_0x28d4('0x4c')]=_['map'](_0x211383,_0x28d4('0x2f'));_0x50e499[_0x28d4('0x4d')]=_[_0x28d4('0x4e')](_0x3f8167[_0x28d4('0x4d')]);_0x50e499[_0x28d4('0x4f')]=_[_0x28d4('0x50')](_0x50e499[_0x28d4('0x4c')],_0x50e499[_0x28d4('0x4d')]);_0x438cb7['attributes']=_[_0x28d4('0x50')](_0x50e499[_0x28d4('0x4c')],qs[_0x28d4('0x51')](_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x51')]));_0x438cb7[_0x28d4('0x52')]=_0x438cb7[_0x28d4('0x52')]['length']?_0x438cb7[_0x28d4('0x52')]:_0x50e499[_0x28d4('0x4c')];if(!_0x3f8167[_0x28d4('0x4d')]['hasOwnProperty']('nolimit')){_0x438cb7[_0x28d4('0x27')]=qs[_0x28d4('0x27')](_0x3f8167[_0x28d4('0x4d')]['limit']);_0x438cb7[_0x28d4('0x25')]=qs[_0x28d4('0x25')](_0x3f8167[_0x28d4('0x4d')]['offset']);}_0x438cb7[_0x28d4('0x53')]=qs['sort'](_0x3f8167[_0x28d4('0x4d')]['sort']);_0x438cb7[_0x28d4('0x54')]=qs[_0x28d4('0x4f')](_['pick'](_0x3f8167['query'],_0x50e499[_0x28d4('0x4f')]),_0x211383);var _0x2e604e=[];var _0x59493f=squel[_0x28d4('0x55')]()[_0x28d4('0x56')]('id')['field']('name')[_0x28d4('0x56')]('color')[_0x28d4('0x57')](_0x28d4('0x58'));var _0x591712=squel['select']()[_0x28d4('0x56')](_0x28d4('0x59'))[_0x28d4('0x56')](_0x28d4('0x5a'))[_0x28d4('0x56')]('ui.MailInteractionId')[_0x28d4('0x57')](_0x28d4('0x5b'),'ui')['left_join']('users','u','u.id\x20=\x20ui.UserId');var _0x4d2c56=squel['select']()[_0x28d4('0x57')](_0x28d4('0x5c'),'i')[_0x28d4('0x5d')](_0x28d4('0x5e'),'c',_0x28d4('0x5f'))['left_join'](_0x28d4('0x60'),'o','o.id\x20=\x20i.UserId')['left_join']('mail_accounts','a',_0x28d4('0x61'))[_0x28d4('0x5d')](_0x28d4('0x62'),'me',_0x28d4('0x63'))[_0x28d4('0x5d')]('mail_interaction_has_tags','it','it.MailInteractionId\x20=\x20i.id')[_0x28d4('0x5d')]('tools_tags','t',_0x28d4('0x64'));var _0x3bdca1=squel[_0x28d4('0x65')]();var _0x4b3d54=[];var _0x1c8b60=squel['expr']();var _0x5a21a9;if(_0x3f8167['query']['search']){_0x5a21a9=as[_0x28d4('0x66')](_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x67')]);var _0x410de1=_0x5a21a9[_0x28d4('0x68')];for(var _0x2d5a95=0x0;_0x2d5a95<_0x5a21a9['conditions']['length'];_0x2d5a95++){var _0x8780c9=_0x5a21a9['conditions'][_0x2d5a95];var _0xceedd5='i';var _0x8005a5=_[_0x28d4('0x69')](_0x211383,[_0x28d4('0x2f'),_0x8780c9['field']]);if(!_0x8005a5){switch(_0x8780c9['field']){case _0x28d4('0x6a'):if(_0x8780c9[_0x28d4('0x6b')]==0x1){_0x4d2c56[_0x28d4('0x6c')]('`'+_0x8780c9[_0x28d4('0x56')]+_0x28d4('0x6d'));}else{_0x4d2c56[_0x28d4('0x6c')]('`'+_0x8780c9[_0x28d4('0x56')]+_0x28d4('0x6e'));}break;case'Contact':if(_0x8780c9[_0x28d4('0x6f')]===_0x28d4('0x70')){if(_0x8780c9[_0x28d4('0x6b')][_0x28d4('0x3d')]('\x20')[_0x28d4('0x71')]>0x1){_0x3bdca1[_0x410de1](_0x28d4('0x72'),qs[_0x28d4('0x73')](_0x8780c9[_0x28d4('0x6b')]),null);}else{var _0x3c7ad0='%'+_0x8780c9[_0x28d4('0x6b')]+'%';_0x3bdca1[_0x410de1]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x3c7ad0,_0x3c7ad0,_0x3c7ad0);}}else{_0x8005a5=_[_0x28d4('0x69')](_0x211383,[_0x28d4('0x2f'),_0x28d4('0x74')]);_0x8780c9[_0x28d4('0x56')]='ContactId';_0x20b2b0=as['buildExpression'](_0xceedd5,_0x8005a5[_0x28d4('0x4b')],_0x8780c9);_0x3bdca1[_0x410de1](_0x20b2b0[_0x28d4('0x75')],_0x20b2b0[_0x28d4('0x6b')][_0x28d4('0x76')],_0x20b2b0[_0x28d4('0x6b')]['end']);}break;case _0x28d4('0x77'):var _0x460e80=_0x8780c9[_0x28d4('0x6b')][_0x28d4('0x3d')](',')[_0x28d4('0x39')](function(_0xb29ae1){return Number(_0xb29ae1);});_0x460e80[_0x28d4('0x3e')](function(_0x407f3e){_0x1c8b60['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x407f3e+',%');});_0x4b3d54=_['union'](_0x4b3d54,_0x460e80);break;case _0x28d4('0x78'):if(_0x8780c9['operator']===_0x28d4('0x70')){_0x3bdca1[_0x410de1](_0x28d4('0x79'),'%'+_0x8780c9[_0x28d4('0x6b')]+'%',null);}else{_0x8005a5=_['find'](_0x211383,[_0x28d4('0x2f'),_0x28d4('0x7a')]);_0x8780c9[_0x28d4('0x56')]=_0x28d4('0x7a');_0x20b2b0=as[_0x28d4('0x7b')](_0xceedd5,_0x8005a5[_0x28d4('0x4b')],_0x8780c9);_0x3bdca1[_0x410de1](_0x20b2b0['text'],_0x20b2b0['value'][_0x28d4('0x76')],_0x20b2b0['value'][_0x28d4('0x23')]);}break;case _0x28d4('0x43'):_0x20b2b0=as['buildExpression']('me',null,_0x8780c9);_0x3bdca1[_0x410de1](_0x20b2b0[_0x28d4('0x75')],_0x20b2b0[_0x28d4('0x6b')][_0x28d4('0x76')],_0x20b2b0[_0x28d4('0x6b')][_0x28d4('0x23')]);break;}}else{var _0x20b2b0=as[_0x28d4('0x7b')](_0xceedd5,_0x8005a5[_0x28d4('0x4b')],_0x8780c9);_0x3bdca1[_0x410de1](_0x20b2b0['text'],_0x20b2b0['value']['start'],_0x20b2b0[_0x28d4('0x6b')]['end']);}}}else{var _0x15f192=_(_0x3f8167[_0x28d4('0x4d')])[_0x28d4('0x4e')]()[_0x28d4('0x39')](function(_0x49278a){return _[_0x28d4('0x7c')](_0x211383,[_0x28d4('0x2f'),_0x49278a])?_0x49278a:undefined;})[_0x28d4('0x7d')]()['value']();if(!_[_0x28d4('0x7e')](_0x15f192)){_0x15f192[_0x28d4('0x3e')](function(_0x5f5350){if(_0x5f5350===_0x28d4('0x7f')){_0x4d2c56['where']('i.MailAccountId\x20IN\x20?',[][_0x28d4('0x80')](_0x3f8167[_0x28d4('0x4d')][_0x5f5350]));}else if(_0x5f5350===_0x28d4('0x81')){var _0x1d6f3c=JSON['parse'](_0x3f8167[_0x28d4('0x4d')][_0x5f5350])[_0x28d4('0x82')];var _0x453923=JSON[_0x28d4('0x83')](_0x3f8167[_0x28d4('0x4d')][_0x5f5350])[_0x28d4('0x84')];_0x4d2c56[_0x28d4('0x54')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x1d6f3c,_0x453923);}else{if(_0x3f8167[_0x28d4('0x4d')][_0x5f5350]===_0x28d4('0x85')){_0x4d2c56['where']('i.'+_0x5f5350+'\x20IS\x20NULL');}else{_0x4d2c56['where']('i.'+_0x5f5350+'\x20=\x20?',_0x3f8167[_0x28d4('0x4d')][_0x5f5350]);}}});}if(_0x3f8167['query'][_0x28d4('0x86')]){if(_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x86')]==0x1){_0x4d2c56[_0x28d4('0x6c')](_0x28d4('0x87'));}else{_0x4d2c56[_0x28d4('0x6c')](_0x28d4('0x88'));}}if(_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x89')]){_0x4b3d54=_[_0x28d4('0x8a')](_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x89')])?_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x89')]:new Array(_0x3f8167[_0x28d4('0x4d')]['tag']);_0x4b3d54[_0x28d4('0x3e')](function(_0x1cc5ab){_0x1c8b60['or'](_0x28d4('0x8b'),'%,'+_0x1cc5ab+',%');});}if(_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x8c')]){var _0xb07c82=_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x8c')][_0x28d4('0x8d')]('\x5c','\x5c\x5c')[_0x28d4('0x8d')](/'/g,'\x27\x27');if(qs[_0x28d4('0x8e')](_0xb07c82)){_0x3bdca1['or'](_0x28d4('0x8f'),_0xb07c82+'%');}else if(qs['isEmail'](_0xb07c82)){_0x3bdca1['or'](_0x28d4('0x90'),_0xb07c82+'%');}else{_0x3bdca1['or'](_0x28d4('0x91'),qs[_0x28d4('0x73')](_0xb07c82))['or'](_0x28d4('0x92'),qs['getFullTextValue'](_0xb07c82));}}}_0x4d2c56['where'](_0x3bdca1);_0x4d2c56['group'](_0x28d4('0x93'));var _0x3ceb7c={'type':db[_0x28d4('0x94')][_0x28d4('0x95')][_0x28d4('0x96')],'raw':!![]};var _0x37a926=_0x4d2c56[_0x28d4('0x97')]();_0x37a926[_0x28d4('0x56')](_0x28d4('0x93'));_0x37a926[_0x28d4('0x56')](_0x28d4('0x98'),_0x28d4('0x6a'));if(_0x438cb7[_0x28d4('0x53')]){_0x438cb7[_0x28d4('0x53')][_0x28d4('0x3e')](function(_0x9bc024){var _0x4ad242=_0x9bc024[0x0]===_0x28d4('0x99')?_0x9bc024[0x0]:'i.'+_0x9bc024[0x0];_0x4d2c56[_0x28d4('0x53')](_0x4ad242,_0x9bc024[0x1]==='DESC'?![]:!![]);});}if(!_[_0x28d4('0x7e')](_0x4b3d54)){_0x4d2c56[_0x28d4('0x6c')](_0x1c8b60);_0x37a926[_0x28d4('0x54')](_0x28d4('0x9a'),_0x4b3d54);}BPromise[_0x28d4('0x9b')]()['then'](function(){if(!_0x5a21a9){if(_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x7f')])return;_0x37a926['where']('i.MailAccountId\x20IS\x20NOT\x20NULL');_0x4d2c56['where'](_0x28d4('0x9c'));return;}if(_0x3f8167[_0x28d4('0x9d')][_0x28d4('0x9e')]!=='agent')return;return _0x3f8167[_0x28d4('0x9d')][_0x28d4('0x9f')]({'attributes':['id'],'raw':!![]})['then'](function(_0x15bb1e){if(_[_0x28d4('0x7e')](_0x15bb1e)){_0x37a926[_0x28d4('0x54')](_0x28d4('0xa0'));_0x4d2c56[_0x28d4('0x54')]('i.MailAccountId\x20IS\x20NULL');}else{_0x37a926['where'](_0x28d4('0xa1'),_['map'](_0x15bb1e,'id'));_0x4d2c56[_0x28d4('0x54')](_0x28d4('0xa1'),_[_0x28d4('0x39')](_0x15bb1e,'id'));}});})[_0x28d4('0x2b')](function(){if(_0x3f8167[_0x28d4('0x9d')][_0x28d4('0x9e')]===_0x28d4('0xa2')&&!_0x5a21a9&&!_0x3f8167[_0x28d4('0x4d')]['MailAccountId'])return[];return db[_0x28d4('0xa3')][_0x28d4('0x4d')](_0x37a926[_0x28d4('0xa4')](),_0x3ceb7c);})[_0x28d4('0x2b')](function(_0x51a9ac){_0x3451a7['count']=_0x51a9ac[_0x28d4('0x71')];if(_0x3451a7[_0x28d4('0x26')]===0x0)return[];return db[_0x28d4('0xa3')][_0x28d4('0x4d')](_0x59493f[_0x28d4('0xa4')](),_0x3ceb7c)[_0x28d4('0x2b')](function(_0x4b304b){_0x2e604e=_[_0x28d4('0xa5')](_0x4b304b,'id');_0x3ceb7c=_[_0x28d4('0x32')](_0x3ceb7c,{'model':db[_0x28d4('0xa6')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x3f8167[_0x28d4('0x4d')][_0x28d4('0x51')]){_0x438cb7[_0x28d4('0x52')][_0x28d4('0x3e')](function(_0x4c0fcb){_0x4d2c56['field']('i.'+_0x4c0fcb);});}else{_0x4d2c56['field'](_0x28d4('0x98'),_0x28d4('0x6a'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xa7'),_0x28d4('0xa8'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xa9'),_0x28d4('0xaa'));_0x4d2c56['field']('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',_0x28d4('0x99'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0x93'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xab'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xac'));_0x4d2c56['field'](_0x28d4('0xad'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xae'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xaf'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xb0'));_0x4d2c56[_0x28d4('0x56')]('i.lastMsgDirection');_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xb1'));_0x4d2c56['field'](_0x28d4('0xb2'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xb3'));_0x4d2c56[_0x28d4('0x56')]('i.thirdDisposition');_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xb4'));_0x4d2c56['field'](_0x28d4('0xb5'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xb6'));_0x4d2c56[_0x28d4('0x56')]('i.MailAccountId');_0x4d2c56[_0x28d4('0x56')]('i.UserId');_0x4d2c56[_0x28d4('0x56')]('c.firstName',_0x28d4('0xb7'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xb8'),_0x28d4('0xb9'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xba'),'Contact.email');_0x4d2c56['field'](_0x28d4('0xbb'),_0x28d4('0xbc'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xbd'),'Contact.mobile');_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xbe'),'Contact.fax');_0x4d2c56[_0x28d4('0x56')]('o.fullname',_0x28d4('0xbf'));_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xc0'),'Owner.internal');_0x4d2c56[_0x28d4('0x56')](_0x28d4('0xc1'),'TagIds');}if(_0x438cb7[_0x28d4('0x27')])_0x4d2c56[_0x28d4('0x27')](_0x438cb7['limit']);if(_0x438cb7[_0x28d4('0x25')])_0x4d2c56[_0x28d4('0x25')](_0x438cb7[_0x28d4('0x25')]);return db['sequelize'][_0x28d4('0x4d')](_0x4d2c56['toString'](),_0x3ceb7c);})[_0x28d4('0x2b')](function(_0x4caa60){if(_0x4caa60[_0x28d4('0x71')]>0x0)_0x591712['where'](_0x28d4('0xc2'),_[_0x28d4('0x39')](_0x4caa60,'id'));return db[_0x28d4('0xa3')][_0x28d4('0x4d')](_0x591712[_0x28d4('0xa4')](),_0x3ceb7c)[_0x28d4('0x2b')](function(_0x279bf7){var _0x41b863=_[_0x28d4('0xc3')](_0x279bf7,_0x28d4('0xc4'));var _0x34363e=[];return db[_0x28d4('0xc5')][_0x28d4('0x41')]({'attributes':[_0x28d4('0xc6')],'raw':!![]})[_0x28d4('0x2b')](function(_0x3fa357){var _0x379d65=_0x3fa357[_0x28d4('0xc6')];_0x4caa60[_0x28d4('0x3e')](function(_0x49d0c8){_0x34363e['push'](updateMailInteraction(_0x49d0c8,_0x2e604e,_0x41b863,_0x379d65));});return BPromise[_0x28d4('0xc7')](_0x34363e);});});});})[_0x28d4('0x2b')](function(_0x53e9fd){_0x3451a7[_0x28d4('0xc8')]=_0x53e9fd;return _0x3451a7;})[_0x28d4('0x2b')](respondWithFilteredResult(_0x1d2a32,_0x438cb7))[_0x28d4('0x47')](handleError(_0x1d2a32,null));};exports[_0x28d4('0xc9')]=function(_0x416d90,_0x39a782){var _0x531967={'raw':![],'where':{'id':_0x416d90[_0x28d4('0xca')]['id']}},_0xb70f57={};_0xb70f57[_0x28d4('0x4c')]=_[_0x28d4('0x4e')](db[_0x28d4('0xa6')][_0x28d4('0x49')]);_0xb70f57[_0x28d4('0x4d')]=_[_0x28d4('0x4e')](_0x416d90[_0x28d4('0x4d')]);_0xb70f57[_0x28d4('0x4f')]=_[_0x28d4('0x50')](_0xb70f57[_0x28d4('0x4c')],_0xb70f57[_0x28d4('0x4d')]);_0x531967[_0x28d4('0x52')]=_[_0x28d4('0x50')](_0xb70f57['model'],qs[_0x28d4('0x51')](_0x416d90[_0x28d4('0x4d')][_0x28d4('0x51')]));_0x531967[_0x28d4('0x52')]=_0x531967[_0x28d4('0x52')]['length']?_0x531967[_0x28d4('0x52')]:_0xb70f57[_0x28d4('0x4c')];if(_0x416d90[_0x28d4('0x4d')]['includeAll']){_0x531967[_0x28d4('0xcb')]=[{'all':!![]}];}_0x531967=_[_0x28d4('0x32')]({},_0x531967,_0x416d90['options']);return db[_0x28d4('0xa6')][_0x28d4('0x69')](_0x531967)[_0x28d4('0x2b')](handleEntityNotFound(_0x39a782,null))['then'](respondWithResult(_0x39a782,null))[_0x28d4('0x47')](handleError(_0x39a782,null));};exports[_0x28d4('0xcc')]=function(_0x3ef219,_0x17cf9f){return db[_0x28d4('0xa6')][_0x28d4('0xcc')](_0x3ef219[_0x28d4('0x33')],{})['then'](respondWithResult(_0x17cf9f,0xc9))['catch'](handleError(_0x17cf9f,null));};exports[_0x28d4('0x2a')]=function(_0x57b871,_0x1830c8){if(_0x57b871[_0x28d4('0x33')]['id']){delete _0x57b871[_0x28d4('0x33')]['id'];}return db[_0x28d4('0xa6')][_0x28d4('0x69')]({'where':{'id':_0x57b871[_0x28d4('0xca')]['id']}})[_0x28d4('0x2b')](handleEntityNotFound(_0x1830c8,null))[_0x28d4('0x2b')](saveUpdates(_0x57b871[_0x28d4('0x33')],null))[_0x28d4('0x2b')](respondWithResult(_0x1830c8,null))[_0x28d4('0x47')](handleError(_0x1830c8,null));};exports[_0x28d4('0x2c')]=function(_0x228be5,_0x4c8e4c){return db['MailInteraction'][_0x28d4('0x69')]({'where':{'id':_0x228be5[_0x28d4('0xca')]['id']}})[_0x28d4('0x2b')](handleEntityNotFound(_0x4c8e4c,null))[_0x28d4('0x2b')](removeEntity(_0x4c8e4c,null))[_0x28d4('0x47')](handleError(_0x4c8e4c,null));};exports[_0x28d4('0xcd')]=function(_0x4f4f88,_0x15bc82){return db[_0x28d4('0xa6')]['describe']()[_0x28d4('0x2b')](respondWithResult(_0x15bc82,null))['catch'](handleError(_0x15bc82,null));};exports[_0x28d4('0xce')]=function(_0x34ef16,_0x13ee6f,_0xeca2dd){return db[_0x28d4('0x40')]['find']({'where':{'id':_0x34ef16[_0x28d4('0xca')]['id']}})[_0x28d4('0x2b')](handleEntityNotFound(_0x13ee6f,null))[_0x28d4('0x2b')](function(_0x356fdf){if(_0x356fdf){return _0x356fdf[_0x28d4('0xce')](_0x34ef16[_0x28d4('0x33')][_0x28d4('0xcf')],_['omit'](_0x34ef16[_0x28d4('0x33')],[_0x28d4('0xcf'),'id'])||{});}})[_0x28d4('0x2b')](respondWithResult(_0x13ee6f,null))[_0x28d4('0x47')](handleError(_0x13ee6f,null));};exports[_0x28d4('0xd0')]=function(_0x8a0887,_0x88ec7e,_0x1fdd96){var _0x2d1631={'raw':![],'where':{}};var _0x316480={};var _0x427050={'count':0x0,'rows':[]};return db[_0x28d4('0xa6')]['findOne']({'where':{'id':_0x8a0887[_0x28d4('0xca')]['id']}})[_0x28d4('0x2b')](handleEntityNotFound(_0x88ec7e,null))[_0x28d4('0x2b')](function(_0x4188db){if(_0x4188db){_0x316480[_0x28d4('0x4c')]=_[_0x28d4('0x4e')](db[_0x28d4('0x40')][_0x28d4('0x49')]);_0x316480[_0x28d4('0x4d')]=_[_0x28d4('0x4e')](_0x8a0887[_0x28d4('0x4d')]);_0x316480['filters']=_['intersection'](_0x316480['model'],_0x316480[_0x28d4('0x4d')]);_0x2d1631[_0x28d4('0x52')]=_[_0x28d4('0x50')](_0x316480[_0x28d4('0x4c')],qs[_0x28d4('0x51')](_0x8a0887[_0x28d4('0x4d')]['fields']));_0x2d1631[_0x28d4('0x52')]=_0x2d1631[_0x28d4('0x52')][_0x28d4('0x71')]?_0x2d1631[_0x28d4('0x52')]:_0x316480[_0x28d4('0x4c')];if(!_0x8a0887[_0x28d4('0x4d')][_0x28d4('0xd1')](_0x28d4('0xd2'))){_0x2d1631[_0x28d4('0x27')]=qs[_0x28d4('0x27')](_0x8a0887[_0x28d4('0x4d')][_0x28d4('0x27')]);_0x2d1631[_0x28d4('0x25')]=qs[_0x28d4('0x25')](_0x8a0887[_0x28d4('0x4d')][_0x28d4('0x25')]);}_0x2d1631[_0x28d4('0x53')]=qs[_0x28d4('0xd3')](_0x8a0887[_0x28d4('0x4d')][_0x28d4('0xd3')]);_0x2d1631[_0x28d4('0x54')]=qs['filters'](_[_0x28d4('0xd4')](_0x8a0887[_0x28d4('0x4d')],_0x316480[_0x28d4('0x4f')]));_0x2d1631[_0x28d4('0x54')]['MailInteractionId']=_0x4188db['id'];if(_0x8a0887[_0x28d4('0x4d')][_0x28d4('0x8c')]){_0x2d1631[_0x28d4('0x54')]=_[_0x28d4('0x32')](_0x2d1631[_0x28d4('0x54')],{'$or':_[_0x28d4('0x39')](_0x2d1631[_0x28d4('0x52')],function(_0xa50b2b){var _0x1afd61={};_0x1afd61[_0xa50b2b]={'$like':'%'+_0x8a0887[_0x28d4('0x4d')][_0x28d4('0x8c')]+'%'};return _0x1afd61;})});}if(_0x8a0887[_0x28d4('0x4d')][_0x28d4('0x82')]){var _0x3a504e=_0x8a0887[_0x28d4('0x4d')][_0x28d4('0x82')]['split'](',');var _0x1a39c6={};_0x1a39c6[_0x3a504e[0x0]]={'$gte':moment(_0x3a504e[0x1])[_0x28d4('0xd5')]('YYYY-MM-DD\x20HH:mm:ss')};_0x2d1631[_0x28d4('0x54')]=_[_0x28d4('0x32')](_0x2d1631[_0x28d4('0x54')],_0x1a39c6);}_0x2d1631=_[_0x28d4('0x32')]({},_0x2d1631,_0x8a0887[_0x28d4('0xd6')]);return db[_0x28d4('0x40')]['count']({'where':_0x2d1631[_0x28d4('0x54')]})[_0x28d4('0x2b')](function(_0x50b6be){_0x427050[_0x28d4('0x26')]=_0x50b6be;if(_0x8a0887['query']['includeAll']){_0x2d1631['include']=[{'all':!![]}];}return db[_0x28d4('0x40')][_0x28d4('0xd7')](_0x2d1631);})['then'](function(_0x16891a){if(_0x8a0887[_0x28d4('0x4d')]['inlineCss']===_0x28d4('0xd8')){for(var _0x4b3deb=0x0;_0x4b3deb<_0x16891a[_0x28d4('0x71')];_0x4b3deb++){_0x16891a[_0x4b3deb]['body']=juice(_0x16891a[_0x4b3deb]['body']);}}_0x427050[_0x28d4('0xc8')]=_0x16891a;return _0x427050;});}})[_0x28d4('0x2b')](respondWithFilteredResult(_0x88ec7e,_0x2d1631))[_0x28d4('0x47')](handleError(_0x88ec7e,null));};exports['addTags']=function(_0x22d4bf,_0x329d02,_0x4094f7){return db['MailInteraction']['find']({'where':{'id':_0x22d4bf[_0x28d4('0xca')]['id']}})[_0x28d4('0x2b')](handleEntityNotFound(_0x329d02,null))['then'](function(_0x2eab03){if(_0x2eab03){return _0x2eab03['setTags'](_0x22d4bf[_0x28d4('0x33')]['ids'],_[_0x28d4('0xd9')](_0x22d4bf[_0x28d4('0x33')],[_0x28d4('0xcf'),'id'])||{})[_0x28d4('0xda')](function(){return db['Tag'][_0x28d4('0xd7')]({'attributes':['id',_0x28d4('0x2f'),_0x28d4('0xdb')],'where':{'id':_0x22d4bf[_0x28d4('0x33')][_0x28d4('0xcf')]}});})[_0x28d4('0x2b')](function(_0xab7564){socket[_0x28d4('0xdc')](_0x28d4('0xdd'),{'id':Number(_0x22d4bf[_0x28d4('0xca')]['id']),'tags':_0xab7564||[]});return{'id':Number(_0x22d4bf[_0x28d4('0xca')]['id']),'tags':_0xab7564||[]};});}})[_0x28d4('0x2b')](respondWithResult(_0x329d02,null))['catch'](handleError(_0x329d02,null));};exports['removeTags']=function(_0xd2d3c0,_0x1d9b6d,_0x27c0cf){return db[_0x28d4('0xa6')][_0x28d4('0x69')]({'where':{'id':_0xd2d3c0[_0x28d4('0xca')]['id']}})[_0x28d4('0x2b')](handleEntityNotFound(_0x1d9b6d,null))[_0x28d4('0x2b')](function(_0xcebee9){if(_0xcebee9){return _0xcebee9['removeTags'](_0xd2d3c0[_0x28d4('0x4d')][_0x28d4('0xcf')]);}})[_0x28d4('0x2b')](respondWithStatusCode(_0x1d9b6d,null))[_0x28d4('0x47')](handleError(_0x1d9b6d,null));};exports[_0x28d4('0xde')]=function(_0x12cd15,_0x1a9299){var _0x2f0a8b=moment()[_0x28d4('0xdf')]()[_0x28d4('0xa4')]();var _0x4e59bf=path[_0x28d4('0xe0')](config[_0x28d4('0xe1')],_0x28d4('0xe2'),_0x28d4('0xe3'),_0x28d4('0xe4'));var _0x1662e5=path['join'](config[_0x28d4('0xe1')],_0x28d4('0xe2'),_0x28d4('0xe3'),_0x28d4('0xe5'));var _0x455c27=path[_0x28d4('0xe0')](_0x4e59bf,_0x2f0a8b);var _0x1661ca=util['format'](_0x28d4('0xe6'),_0x12cd15[_0x28d4('0xca')]['id'],_0x2f0a8b);var _0x1c698c=path[_0x28d4('0xe0')](_0x4e59bf,_0x1661ca);var _0x2f7ae3=[];if(_0x12cd15[_0x28d4('0x4d')][_0x28d4('0xe5')]){_0x2f7ae3['push']({'model':db[_0x28d4('0xe7')],'as':_0x28d4('0xe8'),'raw':!![]});}var _0x27fcca=[{'model':db['MailMessage'],'as':'Messages','attributes':['id','body','from','to','cc',_0x28d4('0xe9'),_0x28d4('0xea'),_0x28d4('0x81')],'where':{'secret':![]},'order':qs[_0x28d4('0xd3')]('id'),'include':_0x2f7ae3}];return db[_0x28d4('0xa6')][_0x28d4('0x69')]({'where':{'id':_0x12cd15['params']['id']},'include':_0x27fcca})[_0x28d4('0x2b')](handleEntityNotFound(_0x1a9299,null))[_0x28d4('0x2b')](function(_0x3e1323){if(_0x3e1323&&_0x3e1323['Messages']){var _0x44f97e=_0x3e1323[_0x28d4('0xeb')]({'plain':!![]});fs[_0x28d4('0xec')](_0x455c27);return BPromise[_0x28d4('0xed')](_0x44f97e[_0x28d4('0xee')],function(_0x53d85a,_0x28bb85){var _0x30e51c={'from':_0x53d85a['from'],'to':_0x53d85a['to'],'subject':_0x53d85a[_0x28d4('0xea')],'html':_0x53d85a[_0x28d4('0x33')],'headers':{'Date':moment(_0x53d85a[_0x28d4('0x81')])[_0x28d4('0xd5')](_0x28d4('0xef'))},'attachments':[]};if(_0x53d85a['cc']){_0x30e51c[_0x28d4('0xf0')]['Cc']=_0x53d85a['cc'];}if(_0x53d85a[_0x28d4('0xe9')]){_0x30e51c['headers'][_0x28d4('0xf1')]=_0x53d85a[_0x28d4('0xe9')];}return new BPromise(function(_0x18860a,_0x4086fa){if(_0x53d85a[_0x28d4('0xe8')]){for(var _0x263c77=0x0;_0x263c77<_0x53d85a[_0x28d4('0xe8')][_0x28d4('0x71')];_0x263c77++){var _0x17fc86=_0x53d85a[_0x28d4('0xe8')][_0x263c77];var _0x1b525a=path[_0x28d4('0xe0')](_0x1662e5,_0x17fc86[_0x28d4('0xf2')]);if(fs[_0x28d4('0xf3')](_0x1b525a)){_0x30e51c[_0x28d4('0xe5')][_0x28d4('0x3f')]({'name':_0x17fc86[_0x28d4('0x2f')],'contentType':_0x17fc86[_0x28d4('0x4b')],'data':fs[_0x28d4('0xf4')](_0x1b525a)});}}}emlformat[_0x28d4('0xf5')](_0x30e51c,function(_0x1ef163,_0x41ced5){if(_0x1ef163)return _0x4086fa(_0x1ef163);fs[_0x28d4('0xf6')](path[_0x28d4('0xe0')](_0x455c27,util[_0x28d4('0xd5')](_0x28d4('0xf7'),_0x28bb85)),_0x41ced5);return _0x18860a(_0x41ced5);});});})['then'](function(){return new BPromise(function(_0x2f6066,_0x37f09d){zipdir(_0x455c27,{'saveTo':_0x1c698c},function(_0x4c2df3,_0xdbaf06){if(_0x4c2df3)return _0x37f09d(_0x4c2df3);return _0x2f6066(_0xdbaf06);});})['then'](function(){return new BPromise(function(_0x2ab830,_0x3fe286){rimraf(_0x455c27,function(_0x12bcf2){if(_0x12bcf2)_0x3fe286(_0x12bcf2);return _0x2ab830();});});})['then'](function(){return _0x1a9299[_0x28d4('0xde')](_0x1c698c,_0x1661ca,function(_0x4556f3){if(_0x4556f3){console[_0x28d4('0xf8')]('err',_0x4556f3);}else{fs[_0x28d4('0xf9')](_0x1c698c);}});});});}else{return _0x1a9299[_0x28d4('0x21')](0xc8);}})[_0x28d4('0x47')](handleError(_0x1a9299,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff