// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xbd99=['../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/license/util','redis','defaults','socket.io-emitter','./mailInteraction.socket','register','sendStatus','status','json','count','offset','limit','set','apply','reject','save','then','destroy','end','error','stack','send','Users','fullname','TagIds','Tags','push','findOne','out','lastMsgText','trimStart','plainBody','catch','index','MailInteraction','rawAttributes','fieldName','type','key','model','map','name','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','where','select','field','color','from','tools_tags','u.id','u.fullname','user_has_mail_interactions','left_join','u.id\x20=\x20ui.UserId','mail_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','mail_accounts','a.id\x20=\x20i.MailAccountId','me.MailInteractionId\x20=\x20i.id','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','unreadMessages','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','value','split','getFullTextValue','ContactId','buildExpression','start','Tag','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','find','UserId','text','some','isEmpty','MailAccountId','i.MailAccountId\x20IN\x20?','concat','createdAt','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','isArray','tag','filter','replace','isNumeric','c.email\x20LIKE\x20?','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','Sequelize','QueryTypes','SELECT','clone','order','DESC','t.id\x20IN\x20?','resolve','i.MailAccountId\x20IS\x20NOT\x20NULL','user','role','agent','getMailAccounts','i.MailAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','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.updatedAt','i.closed','i.closedAt','i.subject','i.disposition','i.secondDisposition','i.thirdDisposition','i.to','i.MailAccountId','c.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','o.fullname','Owner.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','all','rows','show','params','includeAll','include','options','create','body','update','describe','addMessage','MailMessage','ids','getMessages','pick','format','YYYY-MM-DD\x20HH:mm:ss','findAll','inlineCss','true','setTags','spread','emit','mailInteractionTags:save','removeTags','download','unix','join','server','files','tmp','transcript-%d-%s.zip','Attachment','Messages','bcc','get','each','subject','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','Attachments','basename','existsSync','readFileSync','writeFileSync','message%d.eml','log','unlinkSync','html-pdf','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','html-to-text','juice','ioredis','../../components/auth/service','../../components/parsers/qs'];(function(_0x32b59a,_0x55dbaa){var _0x450483=function(_0x10b12b){while(--_0x10b12b){_0x32b59a['push'](_0x32b59a['shift']());}};_0x450483(++_0x55dbaa);}(_0xbd99,0x1df));var _0x9bd9=function(_0x5800bd,_0x57bfde){_0x5800bd=_0x5800bd-0x0;var _0x47adb8=_0xbd99[_0x5800bd];return _0x47adb8;};'use strict';var pdf=require(_0x9bd9('0x0'));var emlformat=require(_0x9bd9('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x9bd9('0x2'));var jsonpatch=require(_0x9bd9('0x3'));var rp=require('request-promise');var moment=require(_0x9bd9('0x4'));var BPromise=require(_0x9bd9('0x5'));var Mustache=require(_0x9bd9('0x6'));var util=require(_0x9bd9('0x7'));var path=require(_0x9bd9('0x8'));var sox=require(_0x9bd9('0x9'));var csv=require(_0x9bd9('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x9bd9('0xb'));var _=require(_0x9bd9('0xc'));var squel=require(_0x9bd9('0xd'));var crypto=require(_0x9bd9('0xe'));var jsforce=require(_0x9bd9('0xf'));var deskjs=require(_0x9bd9('0x10'));var toCsv=require('to-csv');var querystring=require(_0x9bd9('0x11'));var Papa=require('papaparse');var htmlToText=require(_0x9bd9('0x12'));var juice=require(_0x9bd9('0x13'));var Redis=require(_0x9bd9('0x14'));var authService=require(_0x9bd9('0x15'));var qs=require(_0x9bd9('0x16'));var as=require(_0x9bd9('0x17'));var hardwareService=require(_0x9bd9('0x18'));var logger=require('../../config/logger')(_0x9bd9('0x19'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x9bd9('0x1a'));var db=require('../../mysqldb')['db'];config[_0x9bd9('0x1b')]=_[_0x9bd9('0x1c')](config[_0x9bd9('0x1b')],{'host':'localhost','port':0x18eb});var socket=require(_0x9bd9('0x1d'))(new Redis(config['redis']));require(_0x9bd9('0x1e'))[_0x9bd9('0x1f')](socket);function respondWithStatusCode(_0x4bab02,_0x197bcc){_0x197bcc=_0x197bcc||0xcc;return function(_0xf3949c){if(_0xf3949c){return _0x4bab02[_0x9bd9('0x20')](_0x197bcc);}return _0x4bab02[_0x9bd9('0x21')](_0x197bcc)['end']();};}function respondWithResult(_0x57ffcb,_0x334927){_0x334927=_0x334927||0xc8;return function(_0x221d94){if(_0x221d94){return _0x57ffcb[_0x9bd9('0x21')](_0x334927)[_0x9bd9('0x22')](_0x221d94);}};}function respondWithFilteredResult(_0x3cba37,_0x3e52ae){return function(_0x4bb159){if(_0x4bb159){var _0x4296aa=_0x4bb159[_0x9bd9('0x23')],_0x323e88=_0x3e52ae[_0x9bd9('0x24')],_0x3b3b38=_0x3e52ae[_0x9bd9('0x24')]+_0x3e52ae[_0x9bd9('0x25')],_0x5d43b7;if(_0x3b3b38>=_0x4296aa){_0x3b3b38=_0x4296aa;_0x5d43b7=0xc8;}else{_0x5d43b7=0xce;}_0x3cba37[_0x9bd9('0x21')](_0x5d43b7);return _0x3cba37[_0x9bd9('0x26')]('Content-Range',_0x323e88+'-'+_0x3b3b38+'/'+_0x4296aa)['json'](_0x4bb159);}return null;};}function patchUpdates(_0x4e6032){return function(_0x4f05dc){try{jsonpatch[_0x9bd9('0x27')](_0x4f05dc,_0x4e6032,!![]);}catch(_0x3c8cab){return BPromise[_0x9bd9('0x28')](_0x3c8cab);}return _0x4f05dc[_0x9bd9('0x29')]();};}function saveUpdates(_0x4506d3,_0x50fd9e){return function(_0x299573){if(_0x299573){return _0x299573['update'](_0x4506d3)[_0x9bd9('0x2a')](function(_0x511d05){return _0x511d05;});}return null;};}function removeEntity(_0x2a06e9,_0x2a39ba){return function(_0x4896d8){if(_0x4896d8){return _0x4896d8[_0x9bd9('0x2b')]()[_0x9bd9('0x2a')](function(){_0x2a06e9[_0x9bd9('0x21')](0xcc)[_0x9bd9('0x2c')]();});}};}function handleEntityNotFound(_0x2ff274,_0x439cb8){return function(_0x48cd59){if(!_0x48cd59){_0x2ff274[_0x9bd9('0x20')](0x194);}return _0x48cd59;};}function handleError(_0x2dd667,_0x52880d){_0x52880d=_0x52880d||0x1f4;return function(_0x2d9a99){logger[_0x9bd9('0x2d')](_0x2d9a99[_0x9bd9('0x2e')]);if(_0x2d9a99['name']){delete _0x2d9a99['name'];}_0x2dd667['status'](_0x52880d)[_0x9bd9('0x2f')](_0x2d9a99);};}function getInteractionUsers(_0x4399bb,_0x159eac){return new BPromise(function(_0x2e025f,_0x3d3968){try{if(_0x159eac[_0x4399bb['id']]){_0x4399bb[_0x9bd9('0x30')]=_['map'](_0x159eac[_0x4399bb['id']],function(_0x1e9450){return{'id':_0x1e9450['id'],'fullname':_0x1e9450[_0x9bd9('0x31')]};});}}catch(_0x23b35b){_0x3d3968(_0x23b35b);}_0x2e025f(_0x4399bb);});}function getInteractionTags(_0x125f67,_0x3a8222){return new BPromise(function(_0x9f5b7f,_0x407499){try{if(_0x125f67['TagIds']){_0x125f67['Tags']=[];_0x125f67[_0x9bd9('0x32')]['split'](',')['forEach'](function(_0x4c9a5a){_0x125f67[_0x9bd9('0x33')][_0x9bd9('0x34')](_0x3a8222[_0x4c9a5a]);});}delete _0x125f67['TagIds'];}catch(_0x5dbdd8){_0x407499(_0x5dbdd8);}_0x9f5b7f(_0x125f67);});}function getLastMessageText(_0x192399){return new BPromise(function(_0x2a4094,_0x501df3){return db['MailMessage'][_0x9bd9('0x35')]({'where':{'$and':[{'MailInteractionId':_0x192399['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':_0x9bd9('0x36')},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':['plainBody'],'order':'-id','raw':!![]})[_0x9bd9('0x2a')](function(_0x48d734){if(_0x48d734&&_0x48d734['plainBody']){_0x192399[_0x9bd9('0x37')]=_[_0x9bd9('0x38')](_0x48d734[_0x9bd9('0x39')]);}_0x2a4094(_0x192399);})[_0x9bd9('0x3a')](function(_0xceaf7c){_0x501df3(_0xceaf7c);});});}function updateMailInteraction(_0x55c40f,_0x519b82,_0xb91bed,_0x2b72c1){return new BPromise(function(_0xbfd337,_0x21ac29){return getInteractionUsers(_0x55c40f,_0xb91bed)[_0x9bd9('0x2a')](function(_0x2cb421){return getInteractionTags(_0x2cb421,_0x519b82);})[_0x9bd9('0x2a')](function(_0x69f496){if(_0x2b72c1){_0xbfd337(getLastMessageText(_0x69f496));}else{_0xbfd337(_0x69f496);}})[_0x9bd9('0x3a')](function(_0x1211db){_0x21ac29(_0x1211db);});});}exports[_0x9bd9('0x3b')]=function(_0x9c69a0,_0x31bf2f){var _0x2f285a={},_0x10dc61={},_0x313fc0={'count':0x0,'rows':[]};var _0x58f4a7=_['map'](db[_0x9bd9('0x3c')][_0x9bd9('0x3d')],function(_0x484929){return{'name':_0x484929[_0x9bd9('0x3e')],'type':_0x484929[_0x9bd9('0x3f')][_0x9bd9('0x40')]};});_0x10dc61[_0x9bd9('0x41')]=_[_0x9bd9('0x42')](_0x58f4a7,_0x9bd9('0x43'));_0x10dc61[_0x9bd9('0x44')]=_[_0x9bd9('0x45')](_0x9c69a0['query']);_0x10dc61[_0x9bd9('0x46')]=_[_0x9bd9('0x47')](_0x10dc61[_0x9bd9('0x41')],_0x10dc61['query']);_0x2f285a['attributes']=_[_0x9bd9('0x47')](_0x10dc61[_0x9bd9('0x41')],qs[_0x9bd9('0x48')](_0x9c69a0['query']['fields']));_0x2f285a[_0x9bd9('0x49')]=_0x2f285a[_0x9bd9('0x49')][_0x9bd9('0x4a')]?_0x2f285a[_0x9bd9('0x49')]:_0x10dc61[_0x9bd9('0x41')];if(!_0x9c69a0[_0x9bd9('0x44')][_0x9bd9('0x4b')](_0x9bd9('0x4c'))){_0x2f285a[_0x9bd9('0x25')]=qs['limit'](_0x9c69a0['query']['limit']);_0x2f285a[_0x9bd9('0x24')]=qs[_0x9bd9('0x24')](_0x9c69a0[_0x9bd9('0x44')][_0x9bd9('0x24')]);}_0x2f285a['order']=qs[_0x9bd9('0x4d')](_0x9c69a0[_0x9bd9('0x44')]['sort']);_0x2f285a[_0x9bd9('0x4e')]=qs[_0x9bd9('0x46')](_['pick'](_0x9c69a0[_0x9bd9('0x44')],_0x10dc61['filters']),_0x58f4a7);var _0x3bc80b=[];var _0x2751c9=squel[_0x9bd9('0x4f')]()[_0x9bd9('0x50')]('id')['field'](_0x9bd9('0x43'))['field'](_0x9bd9('0x51'))[_0x9bd9('0x52')](_0x9bd9('0x53'));var _0x366b7f=squel[_0x9bd9('0x4f')]()[_0x9bd9('0x50')](_0x9bd9('0x54'))[_0x9bd9('0x50')](_0x9bd9('0x55'))[_0x9bd9('0x50')]('ui.MailInteractionId')['from'](_0x9bd9('0x56'),'ui')[_0x9bd9('0x57')]('users','u',_0x9bd9('0x58'));var _0x503198=squel[_0x9bd9('0x4f')]()[_0x9bd9('0x52')](_0x9bd9('0x59'),'i')[_0x9bd9('0x57')](_0x9bd9('0x5a'),'c',_0x9bd9('0x5b'))[_0x9bd9('0x57')](_0x9bd9('0x5c'),'o',_0x9bd9('0x5d'))[_0x9bd9('0x57')](_0x9bd9('0x5e'),'a',_0x9bd9('0x5f'))[_0x9bd9('0x57')]('mail_messages','me',_0x9bd9('0x60'))['left_join'](_0x9bd9('0x61'),'it',_0x9bd9('0x62'))[_0x9bd9('0x57')](_0x9bd9('0x53'),'t',_0x9bd9('0x63'));var _0x4dda2e=squel['expr']();var _0x4fe177=[];var _0x4df5dd=squel[_0x9bd9('0x64')]();var _0x4a4cf9;if(_0x9c69a0['query'][_0x9bd9('0x65')]){_0x4a4cf9=as[_0x9bd9('0x66')](_0x9c69a0[_0x9bd9('0x44')][_0x9bd9('0x65')]);var _0xe06ed4=_0x4a4cf9[_0x9bd9('0x67')];for(var _0x5144ae=0x0;_0x5144ae<_0x4a4cf9[_0x9bd9('0x68')][_0x9bd9('0x4a')];_0x5144ae++){var _0xa2a92a=_0x4a4cf9[_0x9bd9('0x68')][_0x5144ae];var _0x25a56e='i';var _0x216709=_['find'](_0x58f4a7,[_0x9bd9('0x43'),_0xa2a92a['field']]);if(!_0x216709){switch(_0xa2a92a[_0x9bd9('0x50')]){case _0x9bd9('0x69'):if(_0xa2a92a['value']==0x1){_0x503198[_0x9bd9('0x6a')]('`'+_0xa2a92a[_0x9bd9('0x50')]+_0x9bd9('0x6b'));}else{_0x503198['having']('`'+_0xa2a92a['field']+_0x9bd9('0x6c'));}break;case _0x9bd9('0x6d'):if(_0xa2a92a[_0x9bd9('0x6e')]===_0x9bd9('0x6f')){if(_0xa2a92a[_0x9bd9('0x70')][_0x9bd9('0x71')]('\x20')[_0x9bd9('0x4a')]>0x1){_0x4dda2e[_0xe06ed4]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x9bd9('0x72')](_0xa2a92a['value']),null);}else{var _0x5bddc0='%'+_0xa2a92a[_0x9bd9('0x70')]+'%';_0x4dda2e[_0xe06ed4]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x5bddc0,_0x5bddc0,_0x5bddc0);}}else{_0x216709=_['find'](_0x58f4a7,[_0x9bd9('0x43'),_0x9bd9('0x73')]);_0xa2a92a[_0x9bd9('0x50')]=_0x9bd9('0x73');_0x32c6fe=as[_0x9bd9('0x74')](_0x25a56e,_0x216709[_0x9bd9('0x3f')],_0xa2a92a);_0x4dda2e[_0xe06ed4](_0x32c6fe['text'],_0x32c6fe[_0x9bd9('0x70')][_0x9bd9('0x75')],_0x32c6fe[_0x9bd9('0x70')][_0x9bd9('0x2c')]);}break;case _0x9bd9('0x76'):var _0x3d313b=_0xa2a92a['value']['split'](',')[_0x9bd9('0x42')](function(_0x31f0a6){return Number(_0x31f0a6);});_0x3d313b[_0x9bd9('0x77')](function(_0x3d5afa){_0x4df5dd['or'](_0x9bd9('0x78'),'%,'+_0x3d5afa+',%');});_0x4fe177=_['union'](_0x4fe177,_0x3d313b);break;case _0x9bd9('0x79'):if(_0xa2a92a[_0x9bd9('0x6e')]===_0x9bd9('0x6f')){_0x4dda2e[_0xe06ed4](_0x9bd9('0x7a'),'%'+_0xa2a92a['value']+'%',null);}else{_0x216709=_[_0x9bd9('0x7b')](_0x58f4a7,['name',_0x9bd9('0x7c')]);_0xa2a92a['field']=_0x9bd9('0x7c');_0x32c6fe=as[_0x9bd9('0x74')](_0x25a56e,_0x216709[_0x9bd9('0x3f')],_0xa2a92a);_0x4dda2e[_0xe06ed4](_0x32c6fe[_0x9bd9('0x7d')],_0x32c6fe['value'][_0x9bd9('0x75')],_0x32c6fe[_0x9bd9('0x70')][_0x9bd9('0x2c')]);}break;case _0x9bd9('0x39'):_0x32c6fe=as['buildExpression']('me',null,_0xa2a92a);_0x4dda2e[_0xe06ed4](_0x32c6fe['text'],_0x32c6fe[_0x9bd9('0x70')]['start'],_0x32c6fe[_0x9bd9('0x70')][_0x9bd9('0x2c')]);break;}}else{var _0x32c6fe=as['buildExpression'](_0x25a56e,_0x216709[_0x9bd9('0x3f')],_0xa2a92a);_0x4dda2e[_0xe06ed4](_0x32c6fe[_0x9bd9('0x7d')],_0x32c6fe['value']['start'],_0x32c6fe[_0x9bd9('0x70')][_0x9bd9('0x2c')]);}}}else{var _0x50e694=_(_0x9c69a0[_0x9bd9('0x44')])[_0x9bd9('0x45')]()['map'](function(_0xba5799){return _[_0x9bd9('0x7e')](_0x58f4a7,[_0x9bd9('0x43'),_0xba5799])?_0xba5799:undefined;})['compact']()[_0x9bd9('0x70')]();if(!_[_0x9bd9('0x7f')](_0x50e694)){_0x50e694[_0x9bd9('0x77')](function(_0x15f68e){if(_0x15f68e===_0x9bd9('0x80')){_0x503198['where'](_0x9bd9('0x81'),[][_0x9bd9('0x82')](_0x9c69a0['query'][_0x15f68e]));}else if(_0x15f68e===_0x9bd9('0x83')){var _0x4edf7a=JSON[_0x9bd9('0x84')](_0x9c69a0[_0x9bd9('0x44')][_0x15f68e])[_0x9bd9('0x85')];var _0x3f4cf7=JSON[_0x9bd9('0x84')](_0x9c69a0['query'][_0x15f68e])['$lte'];_0x503198[_0x9bd9('0x4e')](_0x9bd9('0x86'),_0x4edf7a,_0x3f4cf7);}else{if(_0x9c69a0['query'][_0x15f68e]===_0x9bd9('0x87')){_0x503198['where']('i.'+_0x15f68e+'\x20IS\x20NULL');}else{_0x503198[_0x9bd9('0x4e')]('i.'+_0x15f68e+_0x9bd9('0x88'),_0x9c69a0[_0x9bd9('0x44')][_0x15f68e]);}}});}if(_0x9c69a0[_0x9bd9('0x44')]['read']){if(_0x9c69a0['query'][_0x9bd9('0x89')]==0x1){_0x503198[_0x9bd9('0x6a')](_0x9bd9('0x8a'));}else{_0x503198[_0x9bd9('0x6a')](_0x9bd9('0x8b'));}}if(_0x9c69a0['query']['tag']){_0x4fe177=_[_0x9bd9('0x8c')](_0x9c69a0['query'][_0x9bd9('0x8d')])?_0x9c69a0[_0x9bd9('0x44')][_0x9bd9('0x8d')]:new Array(_0x9c69a0[_0x9bd9('0x44')][_0x9bd9('0x8d')]);_0x4fe177[_0x9bd9('0x77')](function(_0x4fe3e1){_0x4df5dd['or'](_0x9bd9('0x78'),'%,'+_0x4fe3e1+',%');});}if(_0x9c69a0[_0x9bd9('0x44')]['filter']){var _0x49c720=_0x9c69a0['query'][_0x9bd9('0x8e')][_0x9bd9('0x8f')]('\x5c','\x5c\x5c')[_0x9bd9('0x8f')](/'/g,'\x27\x27');if(qs[_0x9bd9('0x90')](_0x49c720)){_0x4dda2e['or']('i.id\x20LIKE\x20?',_0x49c720+'%');}else if(qs['isEmail'](_0x49c720)){_0x4dda2e['or'](_0x9bd9('0x91'),_0x49c720+'%');}else{_0x4dda2e['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x9bd9('0x72')](_0x49c720))['or'](_0x9bd9('0x92'),qs[_0x9bd9('0x72')](_0x49c720));}}}_0x503198[_0x9bd9('0x4e')](_0x4dda2e);_0x503198[_0x9bd9('0x93')](_0x9bd9('0x94'));var _0x5ddae9={'type':db[_0x9bd9('0x95')][_0x9bd9('0x96')][_0x9bd9('0x97')],'raw':!![]};var _0x17fab0=_0x503198[_0x9bd9('0x98')]();_0x17fab0[_0x9bd9('0x50')](_0x9bd9('0x94'));_0x17fab0[_0x9bd9('0x50')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x9bd9('0x69'));if(_0x2f285a['order']){_0x2f285a['order'][_0x9bd9('0x77')](function(_0x398d13){var _0x8bc086=_0x398d13[0x0]==='contactName'?_0x398d13[0x0]:'i.'+_0x398d13[0x0];_0x503198[_0x9bd9('0x99')](_0x8bc086,_0x398d13[0x1]===_0x9bd9('0x9a')?![]:!![]);});}if(!_['isEmpty'](_0x4fe177)){_0x503198['having'](_0x4df5dd);_0x17fab0['where'](_0x9bd9('0x9b'),_0x4fe177);}BPromise[_0x9bd9('0x9c')]()['then'](function(){if(!_0x4a4cf9){if(_0x9c69a0[_0x9bd9('0x44')][_0x9bd9('0x80')])return;_0x17fab0[_0x9bd9('0x4e')](_0x9bd9('0x9d'));_0x503198[_0x9bd9('0x4e')]('i.MailAccountId\x20IS\x20NOT\x20NULL');return;}if(_0x9c69a0[_0x9bd9('0x9e')][_0x9bd9('0x9f')]!==_0x9bd9('0xa0'))return;return _0x9c69a0[_0x9bd9('0x9e')][_0x9bd9('0xa1')]({'attributes':['id'],'raw':!![]})[_0x9bd9('0x2a')](function(_0x171874){if(_[_0x9bd9('0x7f')](_0x171874)){_0x17fab0[_0x9bd9('0x4e')](_0x9bd9('0xa2'));_0x503198['where'](_0x9bd9('0xa2'));}else{_0x17fab0[_0x9bd9('0x4e')]('i.MailAccountId\x20IN\x20?',_[_0x9bd9('0x42')](_0x171874,'id'));_0x503198[_0x9bd9('0x4e')](_0x9bd9('0x81'),_[_0x9bd9('0x42')](_0x171874,'id'));}});})[_0x9bd9('0x2a')](function(){if(_0x9c69a0[_0x9bd9('0x9e')]['role']===_0x9bd9('0xa0')&&!_0x4a4cf9&&!_0x9c69a0[_0x9bd9('0x44')][_0x9bd9('0x80')])return[];return db[_0x9bd9('0xa3')]['query'](_0x17fab0[_0x9bd9('0xa4')](),_0x5ddae9);})[_0x9bd9('0x2a')](function(_0x300e8e){_0x313fc0[_0x9bd9('0x23')]=_0x300e8e[_0x9bd9('0x4a')];if(_0x313fc0[_0x9bd9('0x23')]===0x0)return[];return db[_0x9bd9('0xa3')][_0x9bd9('0x44')](_0x2751c9[_0x9bd9('0xa4')](),_0x5ddae9)['then'](function(_0x357ec9){_0x3bc80b=_[_0x9bd9('0xa5')](_0x357ec9,'id');_0x5ddae9=_[_0x9bd9('0xa6')](_0x5ddae9,{'model':db[_0x9bd9('0x3c')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x9c69a0[_0x9bd9('0x44')]['fields']){_0x2f285a['attributes'][_0x9bd9('0x77')](function(_0x12db51){_0x503198[_0x9bd9('0x50')]('i.'+_0x12db51);});}else{_0x503198[_0x9bd9('0x50')](_0x9bd9('0xa7'),_0x9bd9('0x69'));_0x503198[_0x9bd9('0x50')]('a.key','Account.key');_0x503198[_0x9bd9('0x50')](_0x9bd9('0xa8'),_0x9bd9('0xa9'));_0x503198['field'](_0x9bd9('0xaa'),_0x9bd9('0xab'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0x94'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xac'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xad'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xae'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xaf'));_0x503198[_0x9bd9('0x50')]('i.attach');_0x503198[_0x9bd9('0x50')]('i.lastMsgAt');_0x503198[_0x9bd9('0x50')]('i.lastMsgDirection');_0x503198[_0x9bd9('0x50')](_0x9bd9('0xb0'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xb1'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xb2'));_0x503198['field'](_0x9bd9('0xb3'));_0x503198[_0x9bd9('0x50')]('i.substatus');_0x503198['field'](_0x9bd9('0xb4'));_0x503198[_0x9bd9('0x50')]('i.ContactId');_0x503198['field'](_0x9bd9('0xb5'));_0x503198[_0x9bd9('0x50')]('i.UserId');_0x503198['field'](_0x9bd9('0xb6'),'Contact.firstName');_0x503198[_0x9bd9('0x50')](_0x9bd9('0xb7'),_0x9bd9('0xb8'));_0x503198['field'](_0x9bd9('0xb9'),_0x9bd9('0xba'));_0x503198['field'](_0x9bd9('0xbb'),_0x9bd9('0xbc'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xbd'),_0x9bd9('0xbe'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xbf'),'Contact.fax');_0x503198['field'](_0x9bd9('0xc0'),_0x9bd9('0xc1'));_0x503198[_0x9bd9('0x50')]('o.internal',_0x9bd9('0xc2'));_0x503198[_0x9bd9('0x50')](_0x9bd9('0xc3'),_0x9bd9('0x32'));}if(_0x2f285a[_0x9bd9('0x25')])_0x503198[_0x9bd9('0x25')](_0x2f285a[_0x9bd9('0x25')]);if(_0x2f285a['offset'])_0x503198['offset'](_0x2f285a[_0x9bd9('0x24')]);return db[_0x9bd9('0xa3')][_0x9bd9('0x44')](_0x503198[_0x9bd9('0xa4')](),_0x5ddae9);})['then'](function(_0xccd01a){_0x366b7f['where'](_0x9bd9('0xc4'),_[_0x9bd9('0x42')](_0xccd01a,'id'));return db['sequelize'][_0x9bd9('0x44')](_0x366b7f[_0x9bd9('0xa4')](),_0x5ddae9)['then'](function(_0x6fac1d){var _0x5cff65=_[_0x9bd9('0xc5')](_0x6fac1d,_0x9bd9('0xc6'));var _0x31e74a=[];return db[_0x9bd9('0xc7')]['findOne']({'attributes':[_0x9bd9('0xc8')],'raw':!![]})[_0x9bd9('0x2a')](function(_0x5b9ef0){var _0xafba32=_0x5b9ef0[_0x9bd9('0xc8')];_0xccd01a[_0x9bd9('0x77')](function(_0x5066ea){_0x31e74a['push'](updateMailInteraction(_0x5066ea,_0x3bc80b,_0x5cff65,_0xafba32));});return BPromise[_0x9bd9('0xc9')](_0x31e74a);});});});})[_0x9bd9('0x2a')](function(_0x356c09){_0x313fc0[_0x9bd9('0xca')]=_0x356c09;return _0x313fc0;})['then'](respondWithFilteredResult(_0x31bf2f,_0x2f285a))[_0x9bd9('0x3a')](handleError(_0x31bf2f,null));};exports[_0x9bd9('0xcb')]=function(_0x45b83d,_0x121e44){var _0x15056e={'raw':![],'where':{'id':_0x45b83d[_0x9bd9('0xcc')]['id']}},_0x4ffc30={};_0x4ffc30[_0x9bd9('0x41')]=_['keys'](db[_0x9bd9('0x3c')][_0x9bd9('0x3d')]);_0x4ffc30[_0x9bd9('0x44')]=_[_0x9bd9('0x45')](_0x45b83d[_0x9bd9('0x44')]);_0x4ffc30[_0x9bd9('0x46')]=_['intersection'](_0x4ffc30[_0x9bd9('0x41')],_0x4ffc30[_0x9bd9('0x44')]);_0x15056e[_0x9bd9('0x49')]=_[_0x9bd9('0x47')](_0x4ffc30['model'],qs[_0x9bd9('0x48')](_0x45b83d[_0x9bd9('0x44')][_0x9bd9('0x48')]));_0x15056e[_0x9bd9('0x49')]=_0x15056e[_0x9bd9('0x49')]['length']?_0x15056e[_0x9bd9('0x49')]:_0x4ffc30[_0x9bd9('0x41')];if(_0x45b83d[_0x9bd9('0x44')][_0x9bd9('0xcd')]){_0x15056e[_0x9bd9('0xce')]=[{'all':!![]}];}_0x15056e=_['merge']({},_0x15056e,_0x45b83d[_0x9bd9('0xcf')]);return db[_0x9bd9('0x3c')][_0x9bd9('0x7b')](_0x15056e)[_0x9bd9('0x2a')](handleEntityNotFound(_0x121e44,null))[_0x9bd9('0x2a')](respondWithResult(_0x121e44,null))[_0x9bd9('0x3a')](handleError(_0x121e44,null));};exports[_0x9bd9('0xd0')]=function(_0x2a6b86,_0x2c8ee3){return db[_0x9bd9('0x3c')]['create'](_0x2a6b86[_0x9bd9('0xd1')],{})[_0x9bd9('0x2a')](respondWithResult(_0x2c8ee3,0xc9))[_0x9bd9('0x3a')](handleError(_0x2c8ee3,null));};exports[_0x9bd9('0xd2')]=function(_0x3712f5,_0x456718){if(_0x3712f5[_0x9bd9('0xd1')]['id']){delete _0x3712f5[_0x9bd9('0xd1')]['id'];}return db[_0x9bd9('0x3c')][_0x9bd9('0x7b')]({'where':{'id':_0x3712f5[_0x9bd9('0xcc')]['id']}})[_0x9bd9('0x2a')](handleEntityNotFound(_0x456718,null))[_0x9bd9('0x2a')](saveUpdates(_0x3712f5[_0x9bd9('0xd1')],null))[_0x9bd9('0x2a')](respondWithResult(_0x456718,null))[_0x9bd9('0x3a')](handleError(_0x456718,null));};exports[_0x9bd9('0x2b')]=function(_0x299521,_0x6c3236){return db[_0x9bd9('0x3c')][_0x9bd9('0x7b')]({'where':{'id':_0x299521[_0x9bd9('0xcc')]['id']}})[_0x9bd9('0x2a')](handleEntityNotFound(_0x6c3236,null))[_0x9bd9('0x2a')](removeEntity(_0x6c3236,null))['catch'](handleError(_0x6c3236,null));};exports[_0x9bd9('0xd3')]=function(_0x25d861,_0x1e498c){return db[_0x9bd9('0x3c')][_0x9bd9('0xd3')]()[_0x9bd9('0x2a')](respondWithResult(_0x1e498c,null))[_0x9bd9('0x3a')](handleError(_0x1e498c,null));};exports[_0x9bd9('0xd4')]=function(_0x7906a9,_0x4d6c85,_0x5b11f2){return db[_0x9bd9('0xd5')][_0x9bd9('0x7b')]({'where':{'id':_0x7906a9[_0x9bd9('0xcc')]['id']}})[_0x9bd9('0x2a')](handleEntityNotFound(_0x4d6c85,null))[_0x9bd9('0x2a')](function(_0x3333ed){if(_0x3333ed){return _0x3333ed[_0x9bd9('0xd4')](_0x7906a9[_0x9bd9('0xd1')][_0x9bd9('0xd6')],_['omit'](_0x7906a9['body'],['ids','id'])||{});}})['then'](respondWithResult(_0x4d6c85,null))['catch'](handleError(_0x4d6c85,null));};exports[_0x9bd9('0xd7')]=function(_0x32d340,_0xc0cbe,_0x5068d9){var _0x536781={'raw':![],'where':{}};var _0x467d75={};var _0xc2f888={'count':0x0,'rows':[]};return db[_0x9bd9('0x3c')][_0x9bd9('0x35')]({'where':{'id':_0x32d340[_0x9bd9('0xcc')]['id']}})[_0x9bd9('0x2a')](handleEntityNotFound(_0xc0cbe,null))[_0x9bd9('0x2a')](function(_0x504a93){if(_0x504a93){_0x467d75[_0x9bd9('0x41')]=_[_0x9bd9('0x45')](db[_0x9bd9('0xd5')][_0x9bd9('0x3d')]);_0x467d75[_0x9bd9('0x44')]=_['keys'](_0x32d340[_0x9bd9('0x44')]);_0x467d75[_0x9bd9('0x46')]=_[_0x9bd9('0x47')](_0x467d75['model'],_0x467d75[_0x9bd9('0x44')]);_0x536781[_0x9bd9('0x49')]=_['intersection'](_0x467d75[_0x9bd9('0x41')],qs['fields'](_0x32d340[_0x9bd9('0x44')][_0x9bd9('0x48')]));_0x536781[_0x9bd9('0x49')]=_0x536781[_0x9bd9('0x49')][_0x9bd9('0x4a')]?_0x536781[_0x9bd9('0x49')]:_0x467d75['model'];if(!_0x32d340[_0x9bd9('0x44')]['hasOwnProperty'](_0x9bd9('0x4c'))){_0x536781[_0x9bd9('0x25')]=qs[_0x9bd9('0x25')](_0x32d340[_0x9bd9('0x44')][_0x9bd9('0x25')]);_0x536781[_0x9bd9('0x24')]=qs['offset'](_0x32d340[_0x9bd9('0x44')][_0x9bd9('0x24')]);}_0x536781['order']=qs[_0x9bd9('0x4d')](_0x32d340[_0x9bd9('0x44')][_0x9bd9('0x4d')]);_0x536781[_0x9bd9('0x4e')]=qs[_0x9bd9('0x46')](_[_0x9bd9('0xd8')](_0x32d340[_0x9bd9('0x44')],_0x467d75[_0x9bd9('0x46')]));_0x536781[_0x9bd9('0x4e')]['MailInteractionId']=_0x504a93['id'];if(_0x32d340[_0x9bd9('0x44')][_0x9bd9('0x8e')]){_0x536781[_0x9bd9('0x4e')]=_[_0x9bd9('0xa6')](_0x536781[_0x9bd9('0x4e')],{'$or':_[_0x9bd9('0x42')](_0x536781['attributes'],function(_0x2351f9){var _0x3acd7c={};_0x3acd7c[_0x2351f9]={'$like':'%'+_0x32d340['query']['filter']+'%'};return _0x3acd7c;})});}if(_0x32d340[_0x9bd9('0x44')][_0x9bd9('0x85')]){var _0x36cef2=_0x32d340[_0x9bd9('0x44')][_0x9bd9('0x85')][_0x9bd9('0x71')](',');var _0x32782a={};_0x32782a[_0x36cef2[0x0]]={'$gte':moment(_0x36cef2[0x1])[_0x9bd9('0xd9')](_0x9bd9('0xda'))};_0x536781['where']=_['merge'](_0x536781['where'],_0x32782a);}_0x536781=_['merge']({},_0x536781,_0x32d340[_0x9bd9('0xcf')]);return db[_0x9bd9('0xd5')][_0x9bd9('0x23')]({'where':_0x536781[_0x9bd9('0x4e')]})['then'](function(_0x3166e3){_0xc2f888[_0x9bd9('0x23')]=_0x3166e3;if(_0x32d340[_0x9bd9('0x44')][_0x9bd9('0xcd')]){_0x536781[_0x9bd9('0xce')]=[{'all':!![]}];}return db[_0x9bd9('0xd5')][_0x9bd9('0xdb')](_0x536781);})[_0x9bd9('0x2a')](function(_0x357741){if(_0x32d340['query'][_0x9bd9('0xdc')]===_0x9bd9('0xdd')){for(var _0x1a2cc9=0x0;_0x1a2cc9<_0x357741[_0x9bd9('0x4a')];_0x1a2cc9++){_0x357741[_0x1a2cc9][_0x9bd9('0xd1')]=juice(_0x357741[_0x1a2cc9]['body']);}}_0xc2f888[_0x9bd9('0xca')]=_0x357741;return _0xc2f888;});}})[_0x9bd9('0x2a')](respondWithFilteredResult(_0xc0cbe,_0x536781))[_0x9bd9('0x3a')](handleError(_0xc0cbe,null));};exports['addTags']=function(_0x47fc05,_0x49f9b8,_0xc3e71d){return db[_0x9bd9('0x3c')]['find']({'where':{'id':_0x47fc05[_0x9bd9('0xcc')]['id']}})[_0x9bd9('0x2a')](handleEntityNotFound(_0x49f9b8,null))[_0x9bd9('0x2a')](function(_0x269b52){if(_0x269b52){return _0x269b52[_0x9bd9('0xde')](_0x47fc05[_0x9bd9('0xd1')]['ids'],_['omit'](_0x47fc05[_0x9bd9('0xd1')],[_0x9bd9('0xd6'),'id'])||{})[_0x9bd9('0xdf')](function(){return db[_0x9bd9('0x76')][_0x9bd9('0xdb')]({'attributes':['id','name','color'],'where':{'id':_0x47fc05['body'][_0x9bd9('0xd6')]}});})[_0x9bd9('0x2a')](function(_0x4b9b5d){socket[_0x9bd9('0xe0')](_0x9bd9('0xe1'),{'id':Number(_0x47fc05[_0x9bd9('0xcc')]['id']),'tags':_0x4b9b5d||[]});return{'id':Number(_0x47fc05[_0x9bd9('0xcc')]['id']),'tags':_0x4b9b5d||[]};});}})[_0x9bd9('0x2a')](respondWithResult(_0x49f9b8,null))[_0x9bd9('0x3a')](handleError(_0x49f9b8,null));};exports['removeTags']=function(_0xfb163,_0x2347d6,_0xe863c5){return db['MailInteraction']['find']({'where':{'id':_0xfb163[_0x9bd9('0xcc')]['id']}})['then'](handleEntityNotFound(_0x2347d6,null))['then'](function(_0x1f787c){if(_0x1f787c){return _0x1f787c[_0x9bd9('0xe2')](_0xfb163[_0x9bd9('0x44')][_0x9bd9('0xd6')]);}})[_0x9bd9('0x2a')](respondWithStatusCode(_0x2347d6,null))[_0x9bd9('0x3a')](handleError(_0x2347d6,null));};exports[_0x9bd9('0xe3')]=function(_0x588935,_0x28759c){var _0x534ccf=moment()[_0x9bd9('0xe4')]()[_0x9bd9('0xa4')]();var _0x3746ac=path[_0x9bd9('0xe5')](config['root'],_0x9bd9('0xe6'),_0x9bd9('0xe7'),_0x9bd9('0xe8'));var _0x1355ba=path['join'](config['root'],_0x9bd9('0xe6'),_0x9bd9('0xe7'),'attachments');var _0x13c14f=path[_0x9bd9('0xe5')](_0x3746ac,_0x534ccf);var _0x267b49=util['format'](_0x9bd9('0xe9'),_0x588935[_0x9bd9('0xcc')]['id'],_0x534ccf);var _0x52770e=path[_0x9bd9('0xe5')](_0x3746ac,_0x267b49);var _0x1aab97=[];if(_0x588935[_0x9bd9('0x44')]['attachments']){_0x1aab97[_0x9bd9('0x34')]({'model':db[_0x9bd9('0xea')],'as':'Attachments','raw':!![]});}var _0x506fbf=[{'model':db[_0x9bd9('0xd5')],'as':_0x9bd9('0xeb'),'attributes':['id',_0x9bd9('0xd1'),_0x9bd9('0x52'),'to','cc',_0x9bd9('0xec'),'subject',_0x9bd9('0x83')],'where':{'secret':![]},'order':qs[_0x9bd9('0x4d')]('id'),'include':_0x1aab97}];return db['MailInteraction'][_0x9bd9('0x7b')]({'where':{'id':_0x588935[_0x9bd9('0xcc')]['id']},'include':_0x506fbf})[_0x9bd9('0x2a')](handleEntityNotFound(_0x28759c,null))[_0x9bd9('0x2a')](function(_0x4ce004){if(_0x4ce004&&_0x4ce004[_0x9bd9('0xeb')]){var _0x2dc0b2=_0x4ce004[_0x9bd9('0xed')]({'plain':!![]});fs['mkdirSync'](_0x13c14f);return BPromise[_0x9bd9('0xee')](_0x2dc0b2[_0x9bd9('0xeb')],function(_0x3af1,_0x5f3021){var _0xec0d23={'from':_0x3af1[_0x9bd9('0x52')],'to':_0x3af1['to'],'subject':_0x3af1[_0x9bd9('0xef')],'html':_0x3af1[_0x9bd9('0xd1')],'headers':{'Date':moment(_0x3af1[_0x9bd9('0x83')])['format'](_0x9bd9('0xf0'))},'attachments':[]};if(_0x3af1['cc']){_0xec0d23['headers']['Cc']=_0x3af1['cc'];}if(_0x3af1[_0x9bd9('0xec')]){_0xec0d23[_0x9bd9('0xf1')][_0x9bd9('0xf2')]=_0x3af1[_0x9bd9('0xec')];}return new BPromise(function(_0x14d64c,_0x2427fd){if(_0x3af1[_0x9bd9('0xf3')]){for(var _0x34e31d=0x0;_0x34e31d<_0x3af1['Attachments'][_0x9bd9('0x4a')];_0x34e31d++){var _0x33aedc=_0x3af1[_0x9bd9('0xf3')][_0x34e31d];var _0x1845fb=path[_0x9bd9('0xe5')](_0x1355ba,_0x33aedc[_0x9bd9('0xf4')]);if(fs[_0x9bd9('0xf5')](_0x1845fb)){_0xec0d23['attachments'][_0x9bd9('0x34')]({'name':_0x33aedc['name'],'contentType':_0x33aedc[_0x9bd9('0x3f')],'data':fs[_0x9bd9('0xf6')](_0x1845fb)});}}}emlformat['build'](_0xec0d23,function(_0x408133,_0xb632){if(_0x408133)return _0x2427fd(_0x408133);fs[_0x9bd9('0xf7')](path[_0x9bd9('0xe5')](_0x13c14f,util[_0x9bd9('0xd9')](_0x9bd9('0xf8'),_0x5f3021)),_0xb632);return _0x14d64c(_0xb632);});});})[_0x9bd9('0x2a')](function(){return new BPromise(function(_0x1b1f44,_0x32582f){zipdir(_0x13c14f,{'saveTo':_0x52770e},function(_0x51e616,_0x1f6d18){if(_0x51e616)return _0x32582f(_0x51e616);return _0x1b1f44(_0x1f6d18);});})['then'](function(){return new BPromise(function(_0x230ddd,_0x5e1898){rimraf(_0x13c14f,function(_0x639c8a){if(_0x639c8a)_0x5e1898(_0x639c8a);return _0x230ddd();});});})[_0x9bd9('0x2a')](function(){return _0x28759c[_0x9bd9('0xe3')](_0x52770e,_0x267b49,function(_0x25a261){if(_0x25a261){console[_0x9bd9('0xf9')]('err',_0x25a261);}else{fs[_0x9bd9('0xfa')](_0x52770e);}});});});}else{return _0x28759c[_0x9bd9('0x20')](0xc8);}})[_0x9bd9('0x3a')](handleError(_0x28759c,null));};
\ No newline at end of file
+var _0x896e=['readFileSync','build','writeFileSync','message%d.eml','err','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','lodash','squel','crypto','jsforce','to-csv','querystring','papaparse','juice','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','redis','defaults','socket.io-emitter','./mailInteraction.socket','end','json','count','offset','limit','set','apply','save','update','then','status','sendStatus','stack','name','send','map','fullname','TagIds','split','forEach','push','lastMsgText','fromString','lastMsgBody','catch','index','MailInteraction','rawAttributes','fieldName','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','from','tools_tags','u.fullname','ui.MailInteractionId','user_has_mail_interactions','users','u.id\x20=\x20ui.UserId','left_join','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','a.id\x20=\x20i.MailAccountId','mail_messages','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','`\x20=\x200','Contact','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','text','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','UserId','type','start','plainBody','some','compact','isEmpty','i.MailAccountId\x20IN\x20?','parse','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','filter','replace','isNumeric','i.id\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.id','Sequelize','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','resolve','MailAccountId','i.MailAccountId\x20IS\x20NOT\x20NULL','user','role','agent','getMailAccounts','i.MailAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','a.key','Account.key','Account.mandatoryDisposition','contactName','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.disposition','i.secondDisposition','i.substatus','i.to','i.ContactId','i.UserId','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','groupBy','MailInteractionId','Setting','findOne','enableEmailPreview','all','rows','show','params','includeAll','options','create','body','destroy','describe','MailMessage','addMessage','ids','omit','getMessages','$gte','format','YYYY-MM-DD\x20HH:mm:ss','include','findAll','inlineCss','true','setTags','spread','emit','mailInteractionTags:save','removeTags','unix','root','server','files','tmp','join','transcript-%d-%s.zip','attachments','Attachment','bcc','subject','createdAt','get','mkdirSync','each','Messages','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Attachments','basename'];(function(_0xd1d19a,_0x1933f0){var _0x52a79d=function(_0x5199e2){while(--_0x5199e2){_0xd1d19a['push'](_0xd1d19a['shift']());}};_0x52a79d(++_0x1933f0);}(_0x896e,0x1e9));var _0xe896=function(_0xa4320d,_0x1247e5){_0xa4320d=_0xa4320d-0x0;var _0x5ec385=_0x896e[_0xa4320d];return _0x5ec385;};'use strict';var pdf=require(_0xe896('0x0'));var emlformat=require(_0xe896('0x1'));var rimraf=require(_0xe896('0x2'));var zipdir=require(_0xe896('0x3'));var jsonpatch=require(_0xe896('0x4'));var rp=require(_0xe896('0x5'));var moment=require(_0xe896('0x6'));var BPromise=require(_0xe896('0x7'));var Mustache=require(_0xe896('0x8'));var util=require(_0xe896('0x9'));var path=require(_0xe896('0xa'));var sox=require(_0xe896('0xb'));var csv=require('to-csv');var ejs=require(_0xe896('0xc'));var fs=require('fs');var _=require(_0xe896('0xd'));var squel=require(_0xe896('0xe'));var crypto=require(_0xe896('0xf'));var jsforce=require(_0xe896('0x10'));var deskjs=require('desk.js');var toCsv=require(_0xe896('0x11'));var querystring=require(_0xe896('0x12'));var Papa=require(_0xe896('0x13'));var htmlToText=require('html-to-text');var juice=require(_0xe896('0x14'));var Redis=require('ioredis');var authService=require(_0xe896('0x15'));var qs=require('../../components/parsers/qs');var as=require(_0xe896('0x16'));var hardwareService=require(_0xe896('0x17'));var logger=require(_0xe896('0x18'))('api');var utils=require(_0xe896('0x19'));var config=require(_0xe896('0x1a'));var licenseUtil=require(_0xe896('0x1b'));var db=require('../../mysqldb')['db'];config[_0xe896('0x1c')]=_[_0xe896('0x1d')](config[_0xe896('0x1c')],{'host':'localhost','port':0x18eb});var socket=require(_0xe896('0x1e'))(new Redis(config[_0xe896('0x1c')]));require(_0xe896('0x1f'))['register'](socket);function respondWithStatusCode(_0x5a7957,_0x446ce2){_0x446ce2=_0x446ce2||0xcc;return function(_0x25606b){if(_0x25606b){return _0x5a7957['sendStatus'](_0x446ce2);}return _0x5a7957['status'](_0x446ce2)[_0xe896('0x20')]();};}function respondWithResult(_0x16e272,_0x57f04b){_0x57f04b=_0x57f04b||0xc8;return function(_0x50d224){if(_0x50d224){return _0x16e272['status'](_0x57f04b)[_0xe896('0x21')](_0x50d224);}};}function respondWithFilteredResult(_0x32f86d,_0x2d4cf0){return function(_0x5dc89d){if(_0x5dc89d){var _0x782813=_0x5dc89d[_0xe896('0x22')],_0x9714f1=_0x2d4cf0[_0xe896('0x23')],_0xdcdba8=_0x2d4cf0[_0xe896('0x23')]+_0x2d4cf0[_0xe896('0x24')],_0xbebbe1;if(_0xdcdba8>=_0x782813){_0xdcdba8=_0x782813;_0xbebbe1=0xc8;}else{_0xbebbe1=0xce;}_0x32f86d['status'](_0xbebbe1);return _0x32f86d[_0xe896('0x25')]('Content-Range',_0x9714f1+'-'+_0xdcdba8+'/'+_0x782813)['json'](_0x5dc89d);}return null;};}function patchUpdates(_0x3117cc){return function(_0x346463){try{jsonpatch[_0xe896('0x26')](_0x346463,_0x3117cc,!![]);}catch(_0xeeec7c){return BPromise['reject'](_0xeeec7c);}return _0x346463[_0xe896('0x27')]();};}function saveUpdates(_0x4ad156,_0x5001f7){return function(_0x45dd49){if(_0x45dd49){return _0x45dd49[_0xe896('0x28')](_0x4ad156)[_0xe896('0x29')](function(_0x2e2c10){return _0x2e2c10;});}return null;};}function removeEntity(_0x20e295,_0x4d9f03){return function(_0x781096){if(_0x781096){return _0x781096['destroy']()[_0xe896('0x29')](function(){_0x20e295[_0xe896('0x2a')](0xcc)[_0xe896('0x20')]();});}};}function handleEntityNotFound(_0x569d5f,_0x26635e){return function(_0xd50fe2){if(!_0xd50fe2){_0x569d5f[_0xe896('0x2b')](0x194);}return _0xd50fe2;};}function handleError(_0xe93aa0,_0x2d8a7b){_0x2d8a7b=_0x2d8a7b||0x1f4;return function(_0x3f8ceb){logger['error'](_0x3f8ceb[_0xe896('0x2c')]);if(_0x3f8ceb[_0xe896('0x2d')]){delete _0x3f8ceb[_0xe896('0x2d')];}_0xe93aa0[_0xe896('0x2a')](_0x2d8a7b)[_0xe896('0x2e')](_0x3f8ceb);};}function getInteractionUsers(_0x5e0d9b,_0x47c268){return new BPromise(function(_0x5c7dae,_0x504d7c){try{if(_0x47c268[_0x5e0d9b['id']]){_0x5e0d9b['Users']=_[_0xe896('0x2f')](_0x47c268[_0x5e0d9b['id']],function(_0x29a18e){return{'id':_0x29a18e['id'],'fullname':_0x29a18e[_0xe896('0x30')]};});}}catch(_0x76c781){_0x504d7c(_0x76c781);}_0x5c7dae(_0x5e0d9b);});}function getInteractionTags(_0x3cd88e,_0x1a6090){return new BPromise(function(_0x322ebc,_0x45c6d3){try{if(_0x3cd88e['TagIds']){_0x3cd88e['Tags']=[];_0x3cd88e[_0xe896('0x31')][_0xe896('0x32')](',')[_0xe896('0x33')](function(_0x76c0c3){_0x3cd88e['Tags'][_0xe896('0x34')](_0x1a6090[_0x76c0c3]);});}delete _0x3cd88e['TagIds'];}catch(_0x57c6e8){_0x45c6d3(_0x57c6e8);}_0x322ebc(_0x3cd88e);});}function getLastMessageText(_0x166b86){return new BPromise(function(_0x363fd8,_0x266c0e){return db['MailInteraction']['findOne']({'where':{'id':_0x166b86['id']},'attributes':['lastMsgBody',_0xe896('0x35')],'raw':!![]})[_0xe896('0x29')](function(_0x10fa64){if(!_0x10fa64[_0xe896('0x35')]){_0x166b86[_0xe896('0x35')]=_['trimStart'](htmlToText[_0xe896('0x36')](_0x10fa64[_0xe896('0x37')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x166b86[_0xe896('0x35')]=_0x10fa64[_0xe896('0x35')];}_0x363fd8(_0x166b86);})[_0xe896('0x38')](function(_0x2cce09){_0x266c0e(_0x2cce09);});});}function updateMailInteraction(_0x3aeccc,_0x3e28f0,_0x5ea3ce,_0x42f3fb){return new BPromise(function(_0x1ad362,_0x5a2dd2){return getInteractionUsers(_0x3aeccc,_0x5ea3ce)[_0xe896('0x29')](function(_0x4baad4){return getInteractionTags(_0x4baad4,_0x3e28f0);})[_0xe896('0x29')](function(_0x4f164f){if(_0x42f3fb){_0x1ad362(getLastMessageText(_0x4f164f));}else{_0x1ad362(_0x4f164f);}})[_0xe896('0x38')](function(_0x5ba71e){_0x5a2dd2(_0x5ba71e);});});}exports[_0xe896('0x39')]=function(_0x470c29,_0x403ff4){var _0x3f158b={},_0xeb9bbf={},_0x533173={'count':0x0,'rows':[]};var _0x480b8a=_[_0xe896('0x2f')](db[_0xe896('0x3a')][_0xe896('0x3b')],function(_0x15b6c5){return{'name':_0x15b6c5[_0xe896('0x3c')],'type':_0x15b6c5['type']['key']};});_0xeb9bbf[_0xe896('0x3d')]=_[_0xe896('0x2f')](_0x480b8a,'name');_0xeb9bbf['query']=_[_0xe896('0x3e')](_0x470c29[_0xe896('0x3f')]);_0xeb9bbf[_0xe896('0x40')]=_[_0xe896('0x41')](_0xeb9bbf[_0xe896('0x3d')],_0xeb9bbf[_0xe896('0x3f')]);_0x3f158b[_0xe896('0x42')]=_[_0xe896('0x41')](_0xeb9bbf[_0xe896('0x3d')],qs[_0xe896('0x43')](_0x470c29[_0xe896('0x3f')][_0xe896('0x43')]));_0x3f158b['attributes']=_0x3f158b[_0xe896('0x42')][_0xe896('0x44')]?_0x3f158b['attributes']:_0xeb9bbf['model'];if(!_0x470c29['query'][_0xe896('0x45')](_0xe896('0x46'))){_0x3f158b[_0xe896('0x24')]=qs['limit'](_0x470c29[_0xe896('0x3f')][_0xe896('0x24')]);_0x3f158b['offset']=qs['offset'](_0x470c29['query'][_0xe896('0x23')]);}_0x3f158b[_0xe896('0x47')]=qs[_0xe896('0x48')](_0x470c29[_0xe896('0x3f')][_0xe896('0x48')]);_0x3f158b[_0xe896('0x49')]=qs['filters'](_[_0xe896('0x4a')](_0x470c29[_0xe896('0x3f')],_0xeb9bbf['filters']),_0x480b8a);var _0x43bca4=[];var _0x429f1a=squel[_0xe896('0x4b')]()[_0xe896('0x4c')]('id')['field'](_0xe896('0x2d'))[_0xe896('0x4c')](_0xe896('0x4d'))[_0xe896('0x4e')](_0xe896('0x4f'));var _0xc6829e=squel['select']()[_0xe896('0x4c')]('u.id')[_0xe896('0x4c')](_0xe896('0x50'))[_0xe896('0x4c')](_0xe896('0x51'))[_0xe896('0x4e')](_0xe896('0x52'),'ui')['left_join'](_0xe896('0x53'),'u',_0xe896('0x54'));var _0x4818cd=squel[_0xe896('0x4b')]()[_0xe896('0x4e')]('mail_interactions','i')[_0xe896('0x55')]('cm_contacts','c',_0xe896('0x56'))[_0xe896('0x55')](_0xe896('0x53'),'o',_0xe896('0x57'))[_0xe896('0x55')]('mail_accounts','a',_0xe896('0x58'))[_0xe896('0x55')](_0xe896('0x59'),'me','me.MailInteractionId\x20=\x20i.id')[_0xe896('0x55')]('mail_interaction_has_tags','it','it.MailInteractionId\x20=\x20i.id')[_0xe896('0x55')](_0xe896('0x4f'),'t','t.id\x20=\x20it.TagId');var _0x343adb=squel[_0xe896('0x5a')]();var _0x5bfd1e=[];var _0x58497a=squel[_0xe896('0x5a')]();var _0x3a368c;if(_0x470c29['query'][_0xe896('0x5b')]){_0x3a368c=as[_0xe896('0x5c')](_0x470c29[_0xe896('0x3f')][_0xe896('0x5b')]);var _0x16d1c8=_0x3a368c[_0xe896('0x5d')];for(var _0xaf35a4=0x0;_0xaf35a4<_0x3a368c[_0xe896('0x5e')][_0xe896('0x44')];_0xaf35a4++){var _0x3837e7=_0x3a368c[_0xe896('0x5e')][_0xaf35a4];var _0x54a93d='i';var _0x1d7e31=_[_0xe896('0x5f')](_0x480b8a,[_0xe896('0x2d'),_0x3837e7[_0xe896('0x4c')]]);if(!_0x1d7e31){switch(_0x3837e7[_0xe896('0x4c')]){case _0xe896('0x60'):if(_0x3837e7[_0xe896('0x61')]==0x1){_0x4818cd[_0xe896('0x62')]('`'+_0x3837e7[_0xe896('0x4c')]+_0xe896('0x63'));}else{_0x4818cd[_0xe896('0x62')]('`'+_0x3837e7[_0xe896('0x4c')]+'`\x20>\x200');}break;case _0xe896('0x64'):if(_0x3837e7[_0xe896('0x65')]===_0xe896('0x66')){if(_0x3837e7['value']['split']('\x20')['length']>0x1){_0x343adb[_0x16d1c8](_0xe896('0x67'),qs[_0xe896('0x68')](_0x3837e7[_0xe896('0x61')]),null);}else{var _0x2496d4='%'+_0x3837e7['value']+'%';_0x343adb[_0x16d1c8](_0xe896('0x69'),_0x2496d4,_0x2496d4,_0x2496d4);}}else{_0x1d7e31=_[_0xe896('0x5f')](_0x480b8a,[_0xe896('0x2d'),_0xe896('0x6a')]);_0x3837e7['field']=_0xe896('0x6a');_0x27d90d=as[_0xe896('0x6b')](_0x54a93d,_0x1d7e31['type'],_0x3837e7);_0x343adb[_0x16d1c8](_0x27d90d[_0xe896('0x6c')],_0x27d90d[_0xe896('0x61')]['start'],_0x27d90d['value'][_0xe896('0x20')]);}break;case _0xe896('0x6d'):var _0x313da7=_0x3837e7[_0xe896('0x61')][_0xe896('0x32')](',')['map'](function(_0xdadb92){return Number(_0xdadb92);});_0x313da7[_0xe896('0x33')](function(_0x113b00){_0x58497a['or'](_0xe896('0x6e'),'%,'+_0x113b00+',%');});_0x5bfd1e=_['union'](_0x5bfd1e,_0x313da7);break;case'User':if(_0x3837e7[_0xe896('0x65')]===_0xe896('0x66')){_0x343adb[_0x16d1c8]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x3837e7[_0xe896('0x61')]+'%',null);}else{_0x1d7e31=_['find'](_0x480b8a,[_0xe896('0x2d'),_0xe896('0x6f')]);_0x3837e7[_0xe896('0x4c')]=_0xe896('0x6f');_0x27d90d=as[_0xe896('0x6b')](_0x54a93d,_0x1d7e31[_0xe896('0x70')],_0x3837e7);_0x343adb[_0x16d1c8](_0x27d90d[_0xe896('0x6c')],_0x27d90d[_0xe896('0x61')][_0xe896('0x71')],_0x27d90d[_0xe896('0x61')][_0xe896('0x20')]);}break;case _0xe896('0x72'):_0x27d90d=as[_0xe896('0x6b')]('me',null,_0x3837e7);_0x343adb[_0x16d1c8](_0x27d90d[_0xe896('0x6c')],_0x27d90d[_0xe896('0x61')][_0xe896('0x71')],_0x27d90d[_0xe896('0x61')][_0xe896('0x20')]);break;}}else{var _0x27d90d=as[_0xe896('0x6b')](_0x54a93d,_0x1d7e31[_0xe896('0x70')],_0x3837e7);_0x343adb[_0x16d1c8](_0x27d90d[_0xe896('0x6c')],_0x27d90d['value']['start'],_0x27d90d[_0xe896('0x61')][_0xe896('0x20')]);}}}else{var _0x496e2c=_(_0x470c29[_0xe896('0x3f')])[_0xe896('0x3e')]()[_0xe896('0x2f')](function(_0x186ddc){return _[_0xe896('0x73')](_0x480b8a,[_0xe896('0x2d'),_0x186ddc])?_0x186ddc:undefined;})[_0xe896('0x74')]()[_0xe896('0x61')]();if(!_[_0xe896('0x75')](_0x496e2c)){_0x496e2c[_0xe896('0x33')](function(_0x1479c8){if(_0x1479c8==='MailAccountId'){_0x4818cd[_0xe896('0x49')](_0xe896('0x76'),[]['concat'](_0x470c29[_0xe896('0x3f')][_0x1479c8]));}else if(_0x1479c8==='createdAt'){var _0x47b8b7=JSON[_0xe896('0x77')](_0x470c29[_0xe896('0x3f')][_0x1479c8])['$gte'];var _0x56223c=JSON[_0xe896('0x77')](_0x470c29['query'][_0x1479c8])['$lte'];_0x4818cd[_0xe896('0x49')](_0xe896('0x78'),_0x47b8b7,_0x56223c);}else{if(_0x470c29[_0xe896('0x3f')][_0x1479c8]==='null'){_0x4818cd[_0xe896('0x49')]('i.'+_0x1479c8+_0xe896('0x79'));}else{_0x4818cd[_0xe896('0x49')]('i.'+_0x1479c8+'\x20=\x20?',_0x470c29[_0xe896('0x3f')][_0x1479c8]);}}});}if(_0x470c29[_0xe896('0x3f')][_0xe896('0x7a')]){if(_0x470c29[_0xe896('0x3f')]['read']==0x1){_0x4818cd[_0xe896('0x62')](_0xe896('0x7b'));}else{_0x4818cd[_0xe896('0x62')](_0xe896('0x7c'));}}if(_0x470c29['query'][_0xe896('0x7d')]){_0x5bfd1e=_[_0xe896('0x7e')](_0x470c29['query'][_0xe896('0x7d')])?_0x470c29[_0xe896('0x3f')][_0xe896('0x7d')]:new Array(_0x470c29[_0xe896('0x3f')]['tag']);_0x5bfd1e[_0xe896('0x33')](function(_0x234a3a){_0x58497a['or'](_0xe896('0x6e'),'%,'+_0x234a3a+',%');});}if(_0x470c29[_0xe896('0x3f')][_0xe896('0x7f')]){var _0x1f8792=_0x470c29['query']['filter']['replace']('\x5c','\x5c\x5c')[_0xe896('0x80')](/'/g,'\x27\x27');if(qs[_0xe896('0x81')](_0x1f8792)){_0x343adb['or'](_0xe896('0x82'),_0x1f8792+'%');}else if(qs[_0xe896('0x83')](_0x1f8792)){_0x343adb['or'](_0xe896('0x84'),_0x1f8792+'%');}else{_0x343adb['or'](_0xe896('0x85'),qs[_0xe896('0x68')](_0x1f8792))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x1f8792));}}}_0x4818cd[_0xe896('0x49')](_0x343adb);_0x4818cd['group'](_0xe896('0x86'));var _0x5c5c90={'type':db[_0xe896('0x87')]['QueryTypes'][_0xe896('0x88')],'raw':!![]};var _0x36994f=_0x4818cd[_0xe896('0x89')]();_0x36994f[_0xe896('0x4c')](_0xe896('0x86'));_0x36994f['field'](_0xe896('0x8a'),_0xe896('0x60'));if(_0x3f158b[_0xe896('0x47')]){_0x3f158b[_0xe896('0x47')][_0xe896('0x33')](function(_0x27a9a7){var _0x73ef35=_0x27a9a7[0x0]==='contactName'?_0x27a9a7[0x0]:'i.'+_0x27a9a7[0x0];_0x4818cd[_0xe896('0x47')](_0x73ef35,_0x27a9a7[0x1]==='DESC'?![]:!![]);});}if(!_[_0xe896('0x75')](_0x5bfd1e)){_0x4818cd[_0xe896('0x62')](_0x58497a);_0x36994f[_0xe896('0x49')]('t.id\x20IN\x20?',_0x5bfd1e);}BPromise[_0xe896('0x8b')]()[_0xe896('0x29')](function(){if(!_0x3a368c){if(_0x470c29[_0xe896('0x3f')][_0xe896('0x8c')])return;_0x36994f[_0xe896('0x49')](_0xe896('0x8d'));_0x4818cd[_0xe896('0x49')](_0xe896('0x8d'));return;}if(_0x470c29[_0xe896('0x8e')][_0xe896('0x8f')]!==_0xe896('0x90'))return;return _0x470c29['user'][_0xe896('0x91')]({'attributes':['id'],'raw':!![]})[_0xe896('0x29')](function(_0x3d3a1b){if(_[_0xe896('0x75')](_0x3d3a1b)){_0x36994f['where'](_0xe896('0x92'));_0x4818cd[_0xe896('0x49')](_0xe896('0x92'));}else{_0x36994f[_0xe896('0x49')](_0xe896('0x76'),_[_0xe896('0x2f')](_0x3d3a1b,'id'));_0x4818cd[_0xe896('0x49')](_0xe896('0x76'),_[_0xe896('0x2f')](_0x3d3a1b,'id'));}});})[_0xe896('0x29')](function(){if(_0x470c29[_0xe896('0x8e')][_0xe896('0x8f')]==='agent'&&!_0x3a368c&&!_0x470c29[_0xe896('0x3f')][_0xe896('0x8c')])return[];return db[_0xe896('0x93')]['query'](_0x36994f[_0xe896('0x94')](),_0x5c5c90);})['then'](function(_0x50e997){_0x533173[_0xe896('0x22')]=_0x50e997[_0xe896('0x44')];if(_0x533173[_0xe896('0x22')]===0x0)return[];return db['sequelize'][_0xe896('0x3f')](_0x429f1a[_0xe896('0x94')](),_0x5c5c90)['then'](function(_0x5dc3b7){_0x43bca4=_[_0xe896('0x95')](_0x5dc3b7,'id');_0x5c5c90=_[_0xe896('0x96')](_0x5c5c90,{'model':db[_0xe896('0x3a')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x470c29[_0xe896('0x3f')][_0xe896('0x43')]){_0x3f158b[_0xe896('0x42')][_0xe896('0x33')](function(_0x4a0c0d){_0x4818cd['field']('i.'+_0x4a0c0d);});}else{_0x4818cd[_0xe896('0x4c')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');_0x4818cd[_0xe896('0x4c')](_0xe896('0x97'),_0xe896('0x98'));_0x4818cd[_0xe896('0x4c')]('a.mandatoryDisposition',_0xe896('0x99'));_0x4818cd[_0xe896('0x4c')]('CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20(\x27%\x27\x20+\x20a.email\x20+\x20\x27%\x27)\x20THEN\x20SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201)\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END',_0xe896('0x9a'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x86'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9b'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9c'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9d'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9e'));_0x4818cd[_0xe896('0x4c')](_0xe896('0x9f'));_0x4818cd['field'](_0xe896('0xa0'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa1'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa2'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa3'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa4'));_0x4818cd[_0xe896('0x4c')]('i.thirdDisposition');_0x4818cd['field'](_0xe896('0xa5'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xa6'));_0x4818cd['field'](_0xe896('0xa7'));_0x4818cd[_0xe896('0x4c')]('i.MailAccountId');_0x4818cd[_0xe896('0x4c')](_0xe896('0xa8'));_0x4818cd['field'](_0xe896('0xa9'),_0xe896('0xaa'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xab'),_0xe896('0xac'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xad'),_0xe896('0xae'));_0x4818cd['field'](_0xe896('0xaf'),_0xe896('0xb0'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xb1'),_0xe896('0xb2'));_0x4818cd['field'](_0xe896('0xb3'),_0xe896('0xb4'));_0x4818cd[_0xe896('0x4c')]('o.fullname',_0xe896('0xb5'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xb6'),_0xe896('0xb7'));_0x4818cd[_0xe896('0x4c')](_0xe896('0xb8'),_0xe896('0x31'));}if(_0x3f158b[_0xe896('0x24')])_0x4818cd[_0xe896('0x24')](_0x3f158b['limit']);if(_0x3f158b[_0xe896('0x23')])_0x4818cd['offset'](_0x3f158b[_0xe896('0x23')]);return db[_0xe896('0x93')][_0xe896('0x3f')](_0x4818cd[_0xe896('0x94')](),_0x5c5c90);})['then'](function(_0x132b50){_0xc6829e[_0xe896('0x49')]('ui.MailInteractionId\x20IN\x20?',_[_0xe896('0x2f')](_0x132b50,'id'));return db[_0xe896('0x93')][_0xe896('0x3f')](_0xc6829e['toString'](),_0x5c5c90)[_0xe896('0x29')](function(_0x5dc2f4){var _0x575983=_[_0xe896('0xb9')](_0x5dc2f4,_0xe896('0xba'));var _0x5c4826=[];return db[_0xe896('0xbb')][_0xe896('0xbc')]({'attributes':['enableEmailPreview'],'raw':!![]})['then'](function(_0x5b4e01){var _0x52d37e=_0x5b4e01[_0xe896('0xbd')];_0x132b50[_0xe896('0x33')](function(_0x69a70d){_0x5c4826[_0xe896('0x34')](updateMailInteraction(_0x69a70d,_0x43bca4,_0x575983,_0x52d37e));});return BPromise[_0xe896('0xbe')](_0x5c4826);});});});})[_0xe896('0x29')](function(_0x315ecc){_0x533173[_0xe896('0xbf')]=_0x315ecc;return _0x533173;})['then'](respondWithFilteredResult(_0x403ff4,_0x3f158b))[_0xe896('0x38')](handleError(_0x403ff4,null));};exports[_0xe896('0xc0')]=function(_0xa952a7,_0x2a1d41){var _0x5a254b={'raw':![],'where':{'id':_0xa952a7[_0xe896('0xc1')]['id']}},_0x4f4d26={};_0x4f4d26[_0xe896('0x3d')]=_['keys'](db['MailInteraction'][_0xe896('0x3b')]);_0x4f4d26[_0xe896('0x3f')]=_[_0xe896('0x3e')](_0xa952a7[_0xe896('0x3f')]);_0x4f4d26[_0xe896('0x40')]=_['intersection'](_0x4f4d26[_0xe896('0x3d')],_0x4f4d26[_0xe896('0x3f')]);_0x5a254b[_0xe896('0x42')]=_['intersection'](_0x4f4d26[_0xe896('0x3d')],qs[_0xe896('0x43')](_0xa952a7[_0xe896('0x3f')][_0xe896('0x43')]));_0x5a254b[_0xe896('0x42')]=_0x5a254b['attributes'][_0xe896('0x44')]?_0x5a254b[_0xe896('0x42')]:_0x4f4d26[_0xe896('0x3d')];if(_0xa952a7['query'][_0xe896('0xc2')]){_0x5a254b['include']=[{'all':!![]}];}_0x5a254b=_[_0xe896('0x96')]({},_0x5a254b,_0xa952a7[_0xe896('0xc3')]);return db[_0xe896('0x3a')][_0xe896('0x5f')](_0x5a254b)[_0xe896('0x29')](handleEntityNotFound(_0x2a1d41,null))[_0xe896('0x29')](respondWithResult(_0x2a1d41,null))['catch'](handleError(_0x2a1d41,null));};exports['create']=function(_0x43fe9a,_0x54c61f){return db[_0xe896('0x3a')][_0xe896('0xc4')](_0x43fe9a['body'],{})[_0xe896('0x29')](respondWithResult(_0x54c61f,0xc9))[_0xe896('0x38')](handleError(_0x54c61f,null));};exports['update']=function(_0x219d8c,_0x4bcd8c){if(_0x219d8c[_0xe896('0xc5')]['id']){delete _0x219d8c[_0xe896('0xc5')]['id'];}return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x219d8c['params']['id']}})[_0xe896('0x29')](handleEntityNotFound(_0x4bcd8c,null))[_0xe896('0x29')](saveUpdates(_0x219d8c[_0xe896('0xc5')],null))[_0xe896('0x29')](respondWithResult(_0x4bcd8c,null))[_0xe896('0x38')](handleError(_0x4bcd8c,null));};exports[_0xe896('0xc6')]=function(_0x15058a,_0x3c8951){return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x15058a[_0xe896('0xc1')]['id']}})[_0xe896('0x29')](handleEntityNotFound(_0x3c8951,null))[_0xe896('0x29')](removeEntity(_0x3c8951,null))[_0xe896('0x38')](handleError(_0x3c8951,null));};exports[_0xe896('0xc7')]=function(_0xc0cb7c,_0x16b398){return db['MailInteraction'][_0xe896('0xc7')]()[_0xe896('0x29')](respondWithResult(_0x16b398,null))['catch'](handleError(_0x16b398,null));};exports['addMessage']=function(_0x32ab46,_0xdd4767,_0x3df01d){return db[_0xe896('0xc8')][_0xe896('0x5f')]({'where':{'id':_0x32ab46[_0xe896('0xc1')]['id']}})[_0xe896('0x29')](handleEntityNotFound(_0xdd4767,null))[_0xe896('0x29')](function(_0x4bc803){if(_0x4bc803){return _0x4bc803[_0xe896('0xc9')](_0x32ab46[_0xe896('0xc5')][_0xe896('0xca')],_[_0xe896('0xcb')](_0x32ab46['body'],[_0xe896('0xca'),'id'])||{});}})['then'](respondWithResult(_0xdd4767,null))['catch'](handleError(_0xdd4767,null));};exports[_0xe896('0xcc')]=function(_0x18a32c,_0x120699,_0x30236c){var _0x3e55b7={'raw':![],'where':{}};var _0x1861c0={};var _0x7561d6={'count':0x0,'rows':[]};return db['MailInteraction'][_0xe896('0xbc')]({'where':{'id':_0x18a32c[_0xe896('0xc1')]['id']}})[_0xe896('0x29')](handleEntityNotFound(_0x120699,null))[_0xe896('0x29')](function(_0xe78476){if(_0xe78476){_0x1861c0[_0xe896('0x3d')]=_[_0xe896('0x3e')](db[_0xe896('0xc8')][_0xe896('0x3b')]);_0x1861c0['query']=_[_0xe896('0x3e')](_0x18a32c[_0xe896('0x3f')]);_0x1861c0['filters']=_[_0xe896('0x41')](_0x1861c0['model'],_0x1861c0['query']);_0x3e55b7[_0xe896('0x42')]=_['intersection'](_0x1861c0['model'],qs[_0xe896('0x43')](_0x18a32c[_0xe896('0x3f')][_0xe896('0x43')]));_0x3e55b7['attributes']=_0x3e55b7[_0xe896('0x42')]['length']?_0x3e55b7[_0xe896('0x42')]:_0x1861c0[_0xe896('0x3d')];if(!_0x18a32c['query'][_0xe896('0x45')](_0xe896('0x46'))){_0x3e55b7['limit']=qs[_0xe896('0x24')](_0x18a32c['query']['limit']);_0x3e55b7['offset']=qs[_0xe896('0x23')](_0x18a32c['query'][_0xe896('0x23')]);}_0x3e55b7[_0xe896('0x47')]=qs[_0xe896('0x48')](_0x18a32c[_0xe896('0x3f')]['sort']);_0x3e55b7[_0xe896('0x49')]=qs[_0xe896('0x40')](_[_0xe896('0x4a')](_0x18a32c[_0xe896('0x3f')],_0x1861c0['filters']));_0x3e55b7[_0xe896('0x49')]['MailInteractionId']=_0xe78476['id'];if(_0x18a32c[_0xe896('0x3f')][_0xe896('0x7f')]){_0x3e55b7[_0xe896('0x49')]=_[_0xe896('0x96')](_0x3e55b7['where'],{'$or':_[_0xe896('0x2f')](_0x3e55b7['attributes'],function(_0x3b65a5){var _0x4e5eca={};_0x4e5eca[_0x3b65a5]={'$like':'%'+_0x18a32c[_0xe896('0x3f')][_0xe896('0x7f')]+'%'};return _0x4e5eca;})});}if(_0x18a32c[_0xe896('0x3f')]['$gte']){var _0x22c54c=_0x18a32c['query'][_0xe896('0xcd')][_0xe896('0x32')](',');var _0x4db104={};_0x4db104[_0x22c54c[0x0]]={'$gte':moment(_0x22c54c[0x1])[_0xe896('0xce')](_0xe896('0xcf'))};_0x3e55b7['where']=_[_0xe896('0x96')](_0x3e55b7[_0xe896('0x49')],_0x4db104);}_0x3e55b7=_[_0xe896('0x96')]({},_0x3e55b7,_0x18a32c[_0xe896('0xc3')]);return db[_0xe896('0xc8')][_0xe896('0x22')]({'where':_0x3e55b7[_0xe896('0x49')]})[_0xe896('0x29')](function(_0x46b7d2){_0x7561d6['count']=_0x46b7d2;if(_0x18a32c['query'][_0xe896('0xc2')]){_0x3e55b7[_0xe896('0xd0')]=[{'all':!![]}];}return db['MailMessage'][_0xe896('0xd1')](_0x3e55b7);})[_0xe896('0x29')](function(_0x4b5af4){if(_0x18a32c['query'][_0xe896('0xd2')]===_0xe896('0xd3')){for(var _0x5577f9=0x0;_0x5577f9<_0x4b5af4[_0xe896('0x44')];_0x5577f9++){_0x4b5af4[_0x5577f9][_0xe896('0xc5')]=juice(_0x4b5af4[_0x5577f9]['body']);}}_0x7561d6[_0xe896('0xbf')]=_0x4b5af4;return _0x7561d6;});}})[_0xe896('0x29')](respondWithFilteredResult(_0x120699,_0x3e55b7))[_0xe896('0x38')](handleError(_0x120699,null));};exports['addTags']=function(_0x3c9e8e,_0x40bdca,_0x569a12){return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x3c9e8e[_0xe896('0xc1')]['id']}})[_0xe896('0x29')](handleEntityNotFound(_0x40bdca,null))[_0xe896('0x29')](function(_0x90a856){if(_0x90a856){return _0x90a856[_0xe896('0xd4')](_0x3c9e8e[_0xe896('0xc5')][_0xe896('0xca')],_[_0xe896('0xcb')](_0x3c9e8e[_0xe896('0xc5')],[_0xe896('0xca'),'id'])||{})[_0xe896('0xd5')](function(){return db[_0xe896('0x6d')]['findAll']({'attributes':['id',_0xe896('0x2d'),'color'],'where':{'id':_0x3c9e8e[_0xe896('0xc5')][_0xe896('0xca')]}});})['then'](function(_0x3ac2d5){socket[_0xe896('0xd6')](_0xe896('0xd7'),{'id':Number(_0x3c9e8e['params']['id']),'tags':_0x3ac2d5||[]});return{'id':Number(_0x3c9e8e[_0xe896('0xc1')]['id']),'tags':_0x3ac2d5||[]};});}})[_0xe896('0x29')](respondWithResult(_0x40bdca,null))[_0xe896('0x38')](handleError(_0x40bdca,null));};exports[_0xe896('0xd8')]=function(_0x42652e,_0xad4b50,_0x28b26d){return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x42652e['params']['id']}})['then'](handleEntityNotFound(_0xad4b50,null))['then'](function(_0x4260ca){if(_0x4260ca){return _0x4260ca['removeTags'](_0x42652e['query'][_0xe896('0xca')]);}})['then'](respondWithStatusCode(_0xad4b50,null))['catch'](handleError(_0xad4b50,null));};exports['download']=function(_0x348cd5,_0x4a5f7f){var _0x4a52c6=moment()[_0xe896('0xd9')]()[_0xe896('0x94')]();var _0x29cf8c=path['join'](config[_0xe896('0xda')],_0xe896('0xdb'),_0xe896('0xdc'),_0xe896('0xdd'));var _0x14fd54=path['join'](config['root'],_0xe896('0xdb'),_0xe896('0xdc'),'attachments');var _0x21b078=path[_0xe896('0xde')](_0x29cf8c,_0x4a52c6);var _0x71d912=util[_0xe896('0xce')](_0xe896('0xdf'),_0x348cd5[_0xe896('0xc1')]['id'],_0x4a52c6);var _0x554b57=path[_0xe896('0xde')](_0x29cf8c,_0x71d912);var _0x2f9697=[];if(_0x348cd5[_0xe896('0x3f')][_0xe896('0xe0')]){_0x2f9697[_0xe896('0x34')]({'model':db[_0xe896('0xe1')],'as':'Attachments','raw':!![]});}var _0x3eaa77=[{'model':db[_0xe896('0xc8')],'as':'Messages','attributes':['id',_0xe896('0xc5'),_0xe896('0x4e'),'to','cc',_0xe896('0xe2'),_0xe896('0xe3'),_0xe896('0xe4')],'where':{'secret':![]},'order':qs[_0xe896('0x48')]('id'),'include':_0x2f9697}];return db[_0xe896('0x3a')][_0xe896('0x5f')]({'where':{'id':_0x348cd5[_0xe896('0xc1')]['id']},'include':_0x3eaa77})[_0xe896('0x29')](handleEntityNotFound(_0x4a5f7f,null))['then'](function(_0x47315b){if(_0x47315b&&_0x47315b['Messages']){var _0xdbb639=_0x47315b[_0xe896('0xe5')]({'plain':!![]});fs[_0xe896('0xe6')](_0x21b078);return BPromise[_0xe896('0xe7')](_0xdbb639[_0xe896('0xe8')],function(_0x43f8a9,_0x274e7f){var _0x6e53ae={'from':_0x43f8a9['from'],'to':_0x43f8a9['to'],'subject':_0x43f8a9[_0xe896('0xe3')],'html':_0x43f8a9[_0xe896('0xc5')],'headers':{'Date':moment(_0x43f8a9[_0xe896('0xe4')])[_0xe896('0xce')](_0xe896('0xe9'))},'attachments':[]};if(_0x43f8a9['cc']){_0x6e53ae[_0xe896('0xea')]['Cc']=_0x43f8a9['cc'];}if(_0x43f8a9[_0xe896('0xe2')]){_0x6e53ae[_0xe896('0xea')]['Bcc']=_0x43f8a9[_0xe896('0xe2')];}return new BPromise(function(_0x2d9eae,_0x27743a){if(_0x43f8a9['Attachments']){for(var _0x52f6d6=0x0;_0x52f6d6<_0x43f8a9[_0xe896('0xeb')][_0xe896('0x44')];_0x52f6d6++){var _0x37cd92=_0x43f8a9['Attachments'][_0x52f6d6];var _0x52a5b9=path[_0xe896('0xde')](_0x14fd54,_0x37cd92[_0xe896('0xec')]);if(fs['existsSync'](_0x52a5b9)){_0x6e53ae[_0xe896('0xe0')][_0xe896('0x34')]({'name':_0x37cd92[_0xe896('0x2d')],'contentType':_0x37cd92[_0xe896('0x70')],'data':fs[_0xe896('0xed')](_0x52a5b9)});}}}emlformat[_0xe896('0xee')](_0x6e53ae,function(_0x4d31dc,_0x272bc8){if(_0x4d31dc)return _0x27743a(_0x4d31dc);fs[_0xe896('0xef')](path['join'](_0x21b078,util[_0xe896('0xce')](_0xe896('0xf0'),_0x274e7f)),_0x272bc8);return _0x2d9eae(_0x272bc8);});});})['then'](function(){return new BPromise(function(_0x5c5b99,_0x4bc513){zipdir(_0x21b078,{'saveTo':_0x554b57},function(_0x4d3ca3,_0x2973b8){if(_0x4d3ca3)return _0x4bc513(_0x4d3ca3);return _0x5c5b99(_0x2973b8);});})[_0xe896('0x29')](function(){return new BPromise(function(_0x26bd9b,_0x27fd0e){rimraf(_0x21b078,function(_0x393021){if(_0x393021)_0x27fd0e(_0x393021);return _0x26bd9b();});});})[_0xe896('0x29')](function(){return _0x4a5f7f['download'](_0x554b57,_0x71d912,function(_0x135de9){if(_0x135de9){console['log'](_0xe896('0xf1'),_0x135de9);}else{fs['unlinkSync'](_0x554b57);}});});});}else{return _0x4a5f7f[_0xe896('0x2b')](0xc8);}})[_0xe896('0x38')](handleError(_0x4a5f7f,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff