// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x5e7f=['key','model','name','query','filters','intersection','attributes','fields','length','nolimit','order','sort','pick','select','field','color','from','tools_tags','u.id','u.fullname','ui.MailInteractionId','left_join','users','mail_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','a.id\x20=\x20i.MailAccountId','mail_messages','me.MailInteractionId\x20=\x20i.id','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','split','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','ContactId','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','find','UserId','plainBody','buildExpression','text','start','isEmpty','MailAccountId','where','i.MailAccountId\x20IN\x20?','createdAt','parse','$gte','$lte','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','filter','replace','\x27\x27\x27\x27','i.id\x20LIKE\x20?','isEmail','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','SELECT','clone','t.id\x20IN\x20?','resolve','journey','i.MailAccountId\x20IS\x20NOT\x20NULL','user','i.MailAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','i.createdAt','i.updatedAt','i.closedAt','i.attach','i.lastMsgDirection','i.subject','i.disposition','i.secondDisposition','i.thirdDisposition','i.substatus','i.to','i.MailAccountId','i.UserId','c.lastName','c.email','Contact.email','c.phone','Contact.phone','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','all','rows','params','keys','filtears','includeAll','include','options','create','body','describe','addMessage','omit','getMessages','MailMessage','rawAttributes','hasOwnProperty','YYYY-MM-DD\x20HH:mm:ss','addTags','setTags','ids','spread','findAll','emit','mailInteractionTags:save','removeTags','download','unix','join','server','tmp','root','files','attachments','format','Messages','bcc','get','mkdirSync','each','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','Attachments','existsSync','readFileSync','build','err','unlinkSync','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','to-csv','ejs','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','register','status','end','json','count','offset','limit','Content-Range','save','destroy','then','sendStatus','error','stack','send','Users','map','TagIds','Tags','forEach','push','MailInteraction','findOne','lastMsgBody','lastMsgText','trimStart','fromString','catch','index','type'];(function(_0x3b1aec,_0x4a66ff){var _0x574c45=function(_0x4c5495){while(--_0x4c5495){_0x3b1aec['push'](_0x3b1aec['shift']());}};_0x574c45(++_0x4a66ff);}(_0x5e7f,0xb3));var _0xf5e7=function(_0x537290,_0x2c33d0){_0x537290=_0x537290-0x0;var _0x41f53f=_0x5e7f[_0x537290];return _0x41f53f;};'use strict';var pdf=require(_0xf5e7('0x0'));var emlformat=require(_0xf5e7('0x1'));var rimraf=require(_0xf5e7('0x2'));var zipdir=require(_0xf5e7('0x3'));var jsonpatch=require(_0xf5e7('0x4'));var rp=require('request-promise');var moment=require(_0xf5e7('0x5'));var BPromise=require(_0xf5e7('0x6'));var Mustache=require(_0xf5e7('0x7'));var util=require(_0xf5e7('0x8'));var path=require(_0xf5e7('0x9'));var sox=require('sox');var csv=require(_0xf5e7('0xa'));var ejs=require(_0xf5e7('0xb'));var fs=require('fs');var _=require('lodash');var squel=require(_0xf5e7('0xc'));var crypto=require(_0xf5e7('0xd'));var jsforce=require(_0xf5e7('0xe'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xf5e7('0xf'));var Papa=require(_0xf5e7('0x10'));var htmlToText=require('html-to-text');var Redis=require(_0xf5e7('0x11'));var authService=require('../../components/auth/service');var qs=require(_0xf5e7('0x12'));var as=require(_0xf5e7('0x13'));var hardwareService=require(_0xf5e7('0x14'));var logger=require(_0xf5e7('0x15'))(_0xf5e7('0x16'));var utils=require(_0xf5e7('0x17'));var config=require(_0xf5e7('0x18'));var licenseUtil=require(_0xf5e7('0x19'));var db=require(_0xf5e7('0x1a'))['db'];config[_0xf5e7('0x1b')]=_[_0xf5e7('0x1c')](config['redis'],{'host':_0xf5e7('0x1d'),'port':0x18eb});var socket=require(_0xf5e7('0x1e'))(new Redis(config[_0xf5e7('0x1b')]));require(_0xf5e7('0x1f'))[_0xf5e7('0x20')](socket);function respondWithStatusCode(_0x4fafbf,_0xc088d){_0xc088d=_0xc088d||0xcc;return function(_0x44adb8){if(_0x44adb8){return _0x4fafbf['sendStatus'](_0xc088d);}return _0x4fafbf[_0xf5e7('0x21')](_0xc088d)[_0xf5e7('0x22')]();};}function respondWithResult(_0x30408a,_0x55d877){_0x55d877=_0x55d877||0xc8;return function(_0xc327c8){if(_0xc327c8){return _0x30408a['status'](_0x55d877)[_0xf5e7('0x23')](_0xc327c8);}};}function respondWithFilteredResult(_0x14bfc0,_0x56dab9){return function(_0x4a8eb9){if(_0x4a8eb9){var _0x47006a=_0x4a8eb9[_0xf5e7('0x24')],_0x506c85=_0x56dab9[_0xf5e7('0x25')],_0x1d2d7a=_0x56dab9[_0xf5e7('0x25')]+_0x56dab9[_0xf5e7('0x26')],_0x5d39fd;if(_0x1d2d7a>=_0x47006a){_0x1d2d7a=_0x47006a;_0x5d39fd=0xc8;}else{_0x5d39fd=0xce;}_0x14bfc0[_0xf5e7('0x21')](_0x5d39fd);return _0x14bfc0['set'](_0xf5e7('0x27'),_0x506c85+'-'+_0x1d2d7a+'/'+_0x47006a)['json'](_0x4a8eb9);}return null;};}function patchUpdates(_0x1f3753){return function(_0xdac2b9){try{jsonpatch['apply'](_0xdac2b9,_0x1f3753,!![]);}catch(_0x3a94e7){return BPromise['reject'](_0x3a94e7);}return _0xdac2b9[_0xf5e7('0x28')]();};}function saveUpdates(_0x3a14ab,_0x4e86e7){return function(_0x56a143){if(_0x56a143){return _0x56a143['update'](_0x3a14ab)['then'](function(_0x1f9151){return _0x1f9151;});}return null;};}function removeEntity(_0x40dbf2,_0x299d81){return function(_0xf80b7f){if(_0xf80b7f){return _0xf80b7f[_0xf5e7('0x29')]()[_0xf5e7('0x2a')](function(){_0x40dbf2[_0xf5e7('0x21')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1c861d,_0x22806f){return function(_0x3b0279){if(!_0x3b0279){_0x1c861d[_0xf5e7('0x2b')](0x194);}return _0x3b0279;};}function handleError(_0x3504eb,_0x35b9eb){_0x35b9eb=_0x35b9eb||0x1f4;return function(_0x4863ab){logger[_0xf5e7('0x2c')](_0x4863ab[_0xf5e7('0x2d')]);if(_0x4863ab['name']){delete _0x4863ab['name'];}_0x3504eb['status'](_0x35b9eb)[_0xf5e7('0x2e')](_0x4863ab);};}function getInteractionUsers(_0x828a45,_0x25884d){return new BPromise(function(_0xe58f9a,_0x41d41c){try{if(_0x25884d[_0x828a45['id']]){_0x828a45[_0xf5e7('0x2f')]=_[_0xf5e7('0x30')](_0x25884d[_0x828a45['id']],function(_0x3bfbd3){return{'id':_0x3bfbd3['id'],'fullname':_0x3bfbd3['fullname']};});}}catch(_0x1fdc29){_0x41d41c(_0x1fdc29);}_0xe58f9a(_0x828a45);});}function getInteractionTags(_0x406547,_0xebd810){return new BPromise(function(_0x21e4ac,_0x19966c){try{if(_0x406547[_0xf5e7('0x31')]){_0x406547[_0xf5e7('0x32')]=[];_0x406547[_0xf5e7('0x31')]['split'](',')[_0xf5e7('0x33')](function(_0x7ffd2f){_0x406547['Tags'][_0xf5e7('0x34')](_0xebd810[_0x7ffd2f]);});}delete _0x406547[_0xf5e7('0x31')];}catch(_0x530f57){_0x19966c(_0x530f57);}_0x21e4ac(_0x406547);});}function getLastMessageText(_0x30ea8d){return new BPromise(function(_0x54c3be,_0x33f40e){return db[_0xf5e7('0x35')][_0xf5e7('0x36')]({'where':{'id':_0x30ea8d['id']},'attributes':[_0xf5e7('0x37'),_0xf5e7('0x38')],'raw':!![]})['then'](function(_0x408d5b){if(!_0x408d5b[_0xf5e7('0x38')]){_0x30ea8d['lastMsgText']=_[_0xf5e7('0x39')](htmlToText[_0xf5e7('0x3a')](_0x408d5b[_0xf5e7('0x37')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x30ea8d[_0xf5e7('0x38')]=_0x408d5b[_0xf5e7('0x38')];}_0x54c3be(_0x30ea8d);})[_0xf5e7('0x3b')](function(_0x21139c){_0x33f40e(_0x21139c);});});}function updateMailInteraction(_0x12ede8,_0x54188d,_0x17bfac,_0x38b0af){return new BPromise(function(_0x4ab8e0,_0x510e20){return getInteractionUsers(_0x12ede8,_0x17bfac)[_0xf5e7('0x2a')](function(_0x346694){return getInteractionTags(_0x346694,_0x54188d);})[_0xf5e7('0x2a')](function(_0x4d56b8){if(_0x38b0af){_0x4ab8e0(getLastMessageText(_0x4d56b8));}else{_0x4ab8e0(_0x4d56b8);}})['catch'](function(_0x325f8c){_0x510e20(_0x325f8c);});});}exports[_0xf5e7('0x3c')]=function(_0x1132b7,_0x93bef1){var _0x3b00c4={},_0xf96c11={},_0x2c8148={'count':0x0,'rows':[]};var _0x27afcf=_[_0xf5e7('0x30')](db[_0xf5e7('0x35')]['rawAttributes'],function(_0xa19dd0){return{'name':_0xa19dd0['fieldName'],'type':_0xa19dd0[_0xf5e7('0x3d')][_0xf5e7('0x3e')]};});_0xf96c11[_0xf5e7('0x3f')]=_[_0xf5e7('0x30')](_0x27afcf,_0xf5e7('0x40'));_0xf96c11[_0xf5e7('0x41')]=_['keys'](_0x1132b7[_0xf5e7('0x41')]);_0xf96c11[_0xf5e7('0x42')]=_[_0xf5e7('0x43')](_0xf96c11[_0xf5e7('0x3f')],_0xf96c11[_0xf5e7('0x41')]);_0x3b00c4[_0xf5e7('0x44')]=_[_0xf5e7('0x43')](_0xf96c11[_0xf5e7('0x3f')],qs[_0xf5e7('0x45')](_0x1132b7['query'][_0xf5e7('0x45')]));_0x3b00c4[_0xf5e7('0x44')]=_0x3b00c4['attributes'][_0xf5e7('0x46')]?_0x3b00c4[_0xf5e7('0x44')]:_0xf96c11[_0xf5e7('0x3f')];if(!_0x1132b7[_0xf5e7('0x41')]['hasOwnProperty'](_0xf5e7('0x47'))){_0x3b00c4[_0xf5e7('0x26')]=qs['limit'](_0x1132b7['query']['limit']);_0x3b00c4[_0xf5e7('0x25')]=qs['offset'](_0x1132b7[_0xf5e7('0x41')]['offset']);}_0x3b00c4[_0xf5e7('0x48')]=qs[_0xf5e7('0x49')](_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x49')]);_0x3b00c4['where']=qs[_0xf5e7('0x42')](_[_0xf5e7('0x4a')](_0x1132b7[_0xf5e7('0x41')],_0xf96c11[_0xf5e7('0x42')]),_0x27afcf);var _0x199f01=[];var _0x3b3328=squel[_0xf5e7('0x4b')]()[_0xf5e7('0x4c')]('id')[_0xf5e7('0x4c')](_0xf5e7('0x40'))[_0xf5e7('0x4c')](_0xf5e7('0x4d'))[_0xf5e7('0x4e')](_0xf5e7('0x4f'));var _0x2f5be8=squel['select']()[_0xf5e7('0x4c')](_0xf5e7('0x50'))['field'](_0xf5e7('0x51'))[_0xf5e7('0x4c')](_0xf5e7('0x52'))[_0xf5e7('0x4e')]('user_has_mail_interactions','ui')[_0xf5e7('0x53')](_0xf5e7('0x54'),'u','u.id\x20=\x20ui.UserId');var _0x324ee2=squel['select']()[_0xf5e7('0x4e')](_0xf5e7('0x55'),'i')[_0xf5e7('0x53')](_0xf5e7('0x56'),'c',_0xf5e7('0x57'))[_0xf5e7('0x53')](_0xf5e7('0x54'),'o',_0xf5e7('0x58'))[_0xf5e7('0x53')](_0xf5e7('0x59'),'a',_0xf5e7('0x5a'))[_0xf5e7('0x53')](_0xf5e7('0x5b'),'me',_0xf5e7('0x5c'))[_0xf5e7('0x53')](_0xf5e7('0x5d'),'it',_0xf5e7('0x5e'))[_0xf5e7('0x53')](_0xf5e7('0x4f'),'t',_0xf5e7('0x5f'));var _0x4bbfba=squel[_0xf5e7('0x60')]();var _0x26bf5c=[];var _0x40df06=squel[_0xf5e7('0x60')]();var _0x5145e3;if(_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x61')]){_0x5145e3=as[_0xf5e7('0x62')](_0x1132b7[_0xf5e7('0x41')]['search']);var _0x4e9530=_0x5145e3[_0xf5e7('0x63')];for(var _0x40db2a=0x0;_0x40db2a<_0x5145e3[_0xf5e7('0x64')][_0xf5e7('0x46')];_0x40db2a++){var _0x3facaf=_0x5145e3[_0xf5e7('0x64')][_0x40db2a];var _0x358b86='i';var _0x442250=_['find'](_0x27afcf,[_0xf5e7('0x40'),_0x3facaf[_0xf5e7('0x4c')]]);if(!_0x442250){switch(_0x3facaf[_0xf5e7('0x4c')]){case _0xf5e7('0x65'):if(_0x3facaf[_0xf5e7('0x66')]==0x1){_0x324ee2[_0xf5e7('0x67')]('`'+_0x3facaf[_0xf5e7('0x4c')]+_0xf5e7('0x68'));}else{_0x324ee2['having']('`'+_0x3facaf[_0xf5e7('0x4c')]+_0xf5e7('0x69'));}break;case _0xf5e7('0x6a'):if(_0x3facaf[_0xf5e7('0x6b')]===_0xf5e7('0x6c')){if(_0x3facaf['value'][_0xf5e7('0x6d')]('\x20')['length']>0x1){_0x4bbfba[_0x4e9530](_0xf5e7('0x6e'),qs[_0xf5e7('0x6f')](_0x3facaf['value']),null);}else{var _0x6e4754='%'+_0x3facaf[_0xf5e7('0x66')]+'%';_0x4bbfba[_0x4e9530]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x6e4754,_0x6e4754,_0x6e4754);}}else{_0x442250=_['find'](_0x27afcf,['name','ContactId']);_0x3facaf[_0xf5e7('0x4c')]=_0xf5e7('0x70');_0x1e48f2=as['buildExpression'](_0x358b86,_0x442250['type'],_0x3facaf);_0x4bbfba[_0x4e9530](_0x1e48f2['text'],_0x1e48f2[_0xf5e7('0x66')]['start'],_0x1e48f2[_0xf5e7('0x66')][_0xf5e7('0x22')]);}break;case _0xf5e7('0x71'):var _0x1b7cb0=_0x3facaf['value']['split'](',')[_0xf5e7('0x30')](function(_0x53fc43){return Number(_0x53fc43);});_0x1b7cb0[_0xf5e7('0x33')](function(_0x3aa9c2){_0x40df06['or'](_0xf5e7('0x72'),'%,'+_0x3aa9c2+',%');});_0x26bf5c=_[_0xf5e7('0x73')](_0x26bf5c,_0x1b7cb0);break;case _0xf5e7('0x74'):if(_0x3facaf[_0xf5e7('0x6b')]===_0xf5e7('0x6c')){_0x4bbfba[_0x4e9530](_0xf5e7('0x75'),'%'+_0x3facaf[_0xf5e7('0x66')]+'%',null);}else{_0x442250=_[_0xf5e7('0x76')](_0x27afcf,[_0xf5e7('0x40'),_0xf5e7('0x77')]);_0x3facaf[_0xf5e7('0x4c')]=_0xf5e7('0x77');_0x1e48f2=as['buildExpression'](_0x358b86,_0x442250[_0xf5e7('0x3d')],_0x3facaf);_0x4bbfba[_0x4e9530](_0x1e48f2['text'],_0x1e48f2['value']['start'],_0x1e48f2[_0xf5e7('0x66')][_0xf5e7('0x22')]);}break;case _0xf5e7('0x78'):_0x1e48f2=as[_0xf5e7('0x79')]('me',null,_0x3facaf);_0x4bbfba[_0x4e9530](_0x1e48f2[_0xf5e7('0x7a')],_0x1e48f2[_0xf5e7('0x66')][_0xf5e7('0x7b')],_0x1e48f2[_0xf5e7('0x66')]['end']);break;}}else{var _0x1e48f2=as[_0xf5e7('0x79')](_0x358b86,_0x442250[_0xf5e7('0x3d')],_0x3facaf);_0x4bbfba[_0x4e9530](_0x1e48f2[_0xf5e7('0x7a')],_0x1e48f2['value'][_0xf5e7('0x7b')],_0x1e48f2[_0xf5e7('0x66')]['end']);}}}else{var _0x241564=_(_0x1132b7[_0xf5e7('0x41')])['keys']()[_0xf5e7('0x30')](function(_0x46ea13){return _['some'](_0x27afcf,[_0xf5e7('0x40'),_0x46ea13])?_0x46ea13:undefined;})['compact']()[_0xf5e7('0x66')]();if(!_[_0xf5e7('0x7c')](_0x241564)){_0x241564[_0xf5e7('0x33')](function(_0x274c02){if(_0x274c02===_0xf5e7('0x7d')){_0x324ee2[_0xf5e7('0x7e')](_0xf5e7('0x7f'),[]['concat'](_0x1132b7[_0xf5e7('0x41')][_0x274c02]));}else if(_0x274c02===_0xf5e7('0x80')){var _0x102332=JSON[_0xf5e7('0x81')](_0x1132b7[_0xf5e7('0x41')][_0x274c02])[_0xf5e7('0x82')];var _0x215455=JSON[_0xf5e7('0x81')](_0x1132b7[_0xf5e7('0x41')][_0x274c02])[_0xf5e7('0x83')];_0x324ee2[_0xf5e7('0x7e')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x102332,_0x215455);}else{if(_0x1132b7[_0xf5e7('0x41')][_0x274c02]==='null'){_0x324ee2[_0xf5e7('0x7e')]('i.'+_0x274c02+'\x20IS\x20NULL');}else{_0x324ee2['where']('i.'+_0x274c02+'\x20=\x20?',_0x1132b7[_0xf5e7('0x41')][_0x274c02]);}}});}if(_0x1132b7[_0xf5e7('0x41')]['read']){if(_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x84')]==0x1){_0x324ee2[_0xf5e7('0x67')](_0xf5e7('0x85'));}else{_0x324ee2[_0xf5e7('0x67')](_0xf5e7('0x86'));}}if(_0x1132b7['query'][_0xf5e7('0x87')]){_0x26bf5c=_[_0xf5e7('0x88')](_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x87')])?_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x87')]:new Array(_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x87')]);_0x26bf5c['forEach'](function(_0x335f57){_0x40df06['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x335f57+',%');});}if(_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x89')]){var _0x5a9be5=_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x89')][_0xf5e7('0x8a')]('\x5c','\x5c\x5c')[_0xf5e7('0x8a')]('\x27\x27',_0xf5e7('0x8b'));if(qs['isNumeric'](_0x5a9be5)){_0x4bbfba['or'](_0xf5e7('0x8c'),_0x5a9be5+'%');}else if(qs[_0xf5e7('0x8d')](_0x5a9be5)){_0x4bbfba['or']('c.email\x20LIKE\x20?',_0x5a9be5+'%');}else{_0x4bbfba['or'](_0xf5e7('0x8e'),qs[_0xf5e7('0x6f')](_0x5a9be5))['or'](_0xf5e7('0x8f'),qs[_0xf5e7('0x6f')](_0x5a9be5));}}}_0x324ee2[_0xf5e7('0x7e')](_0x4bbfba);_0x324ee2['group'](_0xf5e7('0x90'));var _0x4c7e84={'type':db[_0xf5e7('0x91')]['QueryTypes'][_0xf5e7('0x92')],'raw':!![]};var _0x5b033a=_0x324ee2[_0xf5e7('0x93')]();_0x5b033a[_0xf5e7('0x4c')](_0xf5e7('0x90'));_0x5b033a['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0xf5e7('0x65'));if(_0x3b00c4[_0xf5e7('0x48')]){_0x3b00c4[_0xf5e7('0x48')][_0xf5e7('0x33')](function(_0x573c24){_0x324ee2['order']('i.'+_0x573c24[0x0],_0x573c24[0x1]==='DESC'?![]:!![]);});}if(!_[_0xf5e7('0x7c')](_0x26bf5c)){_0x324ee2[_0xf5e7('0x67')](_0x40df06);_0x5b033a[_0xf5e7('0x7e')](_0xf5e7('0x94'),_0x26bf5c);}BPromise[_0xf5e7('0x95')]()['then'](function(){if(!_0x5145e3){if(_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x7d')]||_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x96')])return;_0x5b033a[_0xf5e7('0x7e')]('i.MailAccountId\x20IS\x20NOT\x20NULL');_0x324ee2['where'](_0xf5e7('0x97'));return;}return _0x1132b7[_0xf5e7('0x98')]['getMailAccounts']({'attributes':['id'],'raw':!![]})['then'](function(_0x4fffc1){if(_[_0xf5e7('0x7c')](_0x4fffc1)){_0x5b033a[_0xf5e7('0x7e')](_0xf5e7('0x99'));_0x324ee2[_0xf5e7('0x7e')](_0xf5e7('0x99'));}else{_0x5b033a['where'](_0xf5e7('0x7f'),_['map'](_0x4fffc1,'id'));_0x324ee2[_0xf5e7('0x7e')](_0xf5e7('0x7f'),_['map'](_0x4fffc1,'id'));}});})[_0xf5e7('0x2a')](function(){db[_0xf5e7('0x9a')][_0xf5e7('0x41')](_0x5b033a['toString'](),_0x4c7e84)[_0xf5e7('0x2a')](function(_0x11646a){_0x2c8148[_0xf5e7('0x24')]=_0x11646a['length'];if(_0x2c8148['count']===0x0)return[];return db['sequelize']['query'](_0x3b3328[_0xf5e7('0x9b')](),_0x4c7e84)[_0xf5e7('0x2a')](function(_0x8b1fff){_0x199f01=_[_0xf5e7('0x9c')](_0x8b1fff,'id');_0x4c7e84=_[_0xf5e7('0x9d')](_0x4c7e84,{'model':db['MailInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x1132b7[_0xf5e7('0x41')][_0xf5e7('0x45')]){_0x3b00c4[_0xf5e7('0x44')][_0xf5e7('0x33')](function(_0x419af3){_0x324ee2[_0xf5e7('0x4c')]('i.'+_0x419af3);});}else{_0x324ee2[_0xf5e7('0x4c')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0x9e'),_0xf5e7('0x9f'));_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xa0'),_0xf5e7('0xa1'));_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0x90'));_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xa2'));_0x324ee2['field'](_0xf5e7('0xa3'));_0x324ee2[_0xf5e7('0x4c')]('i.closed');_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xa4'));_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xa5'));_0x324ee2[_0xf5e7('0x4c')]('i.lastMsgAt');_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xa6'));_0x324ee2['field'](_0xf5e7('0xa7'));_0x324ee2['field'](_0xf5e7('0xa8'));_0x324ee2['field'](_0xf5e7('0xa9'));_0x324ee2['field'](_0xf5e7('0xaa'));_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xab'));_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xac'));_0x324ee2[_0xf5e7('0x4c')]('i.ContactId');_0x324ee2['field'](_0xf5e7('0xad'));_0x324ee2['field'](_0xf5e7('0xae'));_0x324ee2[_0xf5e7('0x4c')]('c.firstName','Contact.firstName');_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xaf'),'Contact.lastName');_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xb0'),_0xf5e7('0xb1'));_0x324ee2['field'](_0xf5e7('0xb2'),_0xf5e7('0xb3'));_0x324ee2['field']('c.mobile',_0xf5e7('0xb4'));_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xb5'),_0xf5e7('0xb6'));_0x324ee2[_0xf5e7('0x4c')]('o.fullname',_0xf5e7('0xb7'));_0x324ee2['field'](_0xf5e7('0xb8'),_0xf5e7('0xb9'));_0x324ee2[_0xf5e7('0x4c')](_0xf5e7('0xba'),'TagIds');}if(_0x3b00c4[_0xf5e7('0x26')])_0x324ee2[_0xf5e7('0x26')](_0x3b00c4[_0xf5e7('0x26')]);if(_0x3b00c4[_0xf5e7('0x25')])_0x324ee2[_0xf5e7('0x25')](_0x3b00c4[_0xf5e7('0x25')]);return db[_0xf5e7('0x9a')][_0xf5e7('0x41')](_0x324ee2[_0xf5e7('0x9b')](),_0x4c7e84);})[_0xf5e7('0x2a')](function(_0xed7032){_0x2f5be8[_0xf5e7('0x7e')](_0xf5e7('0xbb'),_[_0xf5e7('0x30')](_0xed7032,'id'));return db[_0xf5e7('0x9a')]['query'](_0x2f5be8[_0xf5e7('0x9b')](),_0x4c7e84)[_0xf5e7('0x2a')](function(_0x2ada18){var _0x45cf40=_[_0xf5e7('0xbc')](_0x2ada18,_0xf5e7('0xbd'));var _0x4edd0f=[];return db[_0xf5e7('0xbe')][_0xf5e7('0x36')]({'attributes':[_0xf5e7('0xbf')],'raw':!![]})[_0xf5e7('0x2a')](function(_0x463b7d){var _0x4d8026=_0x463b7d[_0xf5e7('0xbf')];_0xed7032[_0xf5e7('0x33')](function(_0x11c3b5){_0x4edd0f['push'](updateMailInteraction(_0x11c3b5,_0x199f01,_0x45cf40,_0x4d8026));});return BPromise[_0xf5e7('0xc0')](_0x4edd0f);});});});})[_0xf5e7('0x2a')](function(_0x2d3309){_0x2c8148[_0xf5e7('0xc1')]=_0x2d3309;return _0x2c8148;})[_0xf5e7('0x2a')](respondWithFilteredResult(_0x93bef1,_0x3b00c4));})[_0xf5e7('0x3b')](handleError(_0x93bef1,null));};exports['show']=function(_0x47a796,_0x3c5463){var _0x29ac3e={'raw':![],'where':{'id':_0x47a796[_0xf5e7('0xc2')]['id']}},_0x43c66e={};_0x43c66e[_0xf5e7('0x3f')]=_[_0xf5e7('0xc3')](db[_0xf5e7('0x35')]['rawAttributes']);_0x43c66e[_0xf5e7('0x41')]=_[_0xf5e7('0xc3')](_0x47a796[_0xf5e7('0x41')]);_0x43c66e[_0xf5e7('0xc4')]=_[_0xf5e7('0x43')](_0x43c66e['model'],_0x43c66e[_0xf5e7('0x41')]);_0x29ac3e[_0xf5e7('0x44')]=_[_0xf5e7('0x43')](_0x43c66e['model'],qs['fields'](_0x47a796[_0xf5e7('0x41')][_0xf5e7('0x45')]));_0x29ac3e[_0xf5e7('0x44')]=_0x29ac3e[_0xf5e7('0x44')][_0xf5e7('0x46')]?_0x29ac3e[_0xf5e7('0x44')]:_0x43c66e[_0xf5e7('0x3f')];if(_0x47a796[_0xf5e7('0x41')][_0xf5e7('0xc5')]){_0x29ac3e[_0xf5e7('0xc6')]=[{'all':!![]}];}_0x29ac3e=_[_0xf5e7('0x9d')]({},_0x29ac3e,_0x47a796[_0xf5e7('0xc7')]);return db[_0xf5e7('0x35')]['find'](_0x29ac3e)[_0xf5e7('0x2a')](handleEntityNotFound(_0x3c5463,null))['then'](respondWithResult(_0x3c5463,null))[_0xf5e7('0x3b')](handleError(_0x3c5463,null));};exports['create']=function(_0x242c25,_0x19762f){return db[_0xf5e7('0x35')][_0xf5e7('0xc8')](_0x242c25[_0xf5e7('0xc9')],{})['then'](respondWithResult(_0x19762f,0xc9))[_0xf5e7('0x3b')](handleError(_0x19762f,null));};exports['update']=function(_0x1e94b0,_0x37ab65){if(_0x1e94b0[_0xf5e7('0xc9')]['id']){delete _0x1e94b0['body']['id'];}return db[_0xf5e7('0x35')][_0xf5e7('0x76')]({'where':{'id':_0x1e94b0[_0xf5e7('0xc2')]['id']}})['then'](handleEntityNotFound(_0x37ab65,null))[_0xf5e7('0x2a')](saveUpdates(_0x1e94b0['body'],null))['then'](respondWithResult(_0x37ab65,null))[_0xf5e7('0x3b')](handleError(_0x37ab65,null));};exports['destroy']=function(_0x8cba66,_0x4f52d6){return db[_0xf5e7('0x35')][_0xf5e7('0x76')]({'where':{'id':_0x8cba66[_0xf5e7('0xc2')]['id']}})[_0xf5e7('0x2a')](handleEntityNotFound(_0x4f52d6,null))['then'](removeEntity(_0x4f52d6,null))['catch'](handleError(_0x4f52d6,null));};exports[_0xf5e7('0xca')]=function(_0x4285e4,_0x1865f2){return db[_0xf5e7('0x35')][_0xf5e7('0xca')]()[_0xf5e7('0x2a')](respondWithResult(_0x1865f2,null))['catch'](handleError(_0x1865f2,null));};exports['addMessage']=function(_0x429835,_0x2642e1,_0x4415ee){return db['MailMessage'][_0xf5e7('0x76')]({'where':{'id':_0x429835[_0xf5e7('0xc2')]['id']}})[_0xf5e7('0x2a')](handleEntityNotFound(_0x2642e1,null))[_0xf5e7('0x2a')](function(_0x52c92c){if(_0x52c92c){return _0x52c92c[_0xf5e7('0xcb')](_0x429835['body']['ids'],_[_0xf5e7('0xcc')](_0x429835['body'],['ids','id'])||{});}})['then'](respondWithResult(_0x2642e1,null))['catch'](handleError(_0x2642e1,null));};exports[_0xf5e7('0xcd')]=function(_0x41a850,_0x23bc47,_0x50dd99){var _0x509cc6={'raw':![],'where':{}};var _0x500b61={};var _0x22a8dd={'count':0x0,'rows':[]};return db[_0xf5e7('0x35')][_0xf5e7('0x36')]({'where':{'id':_0x41a850[_0xf5e7('0xc2')]['id']}})['then'](handleEntityNotFound(_0x23bc47,null))[_0xf5e7('0x2a')](function(_0x516b49){if(_0x516b49){_0x500b61[_0xf5e7('0x3f')]=_[_0xf5e7('0xc3')](db[_0xf5e7('0xce')][_0xf5e7('0xcf')]);_0x500b61[_0xf5e7('0x41')]=_[_0xf5e7('0xc3')](_0x41a850['query']);_0x500b61[_0xf5e7('0x42')]=_['intersection'](_0x500b61['model'],_0x500b61[_0xf5e7('0x41')]);_0x509cc6[_0xf5e7('0x44')]=_['intersection'](_0x500b61[_0xf5e7('0x3f')],qs['fields'](_0x41a850['query'][_0xf5e7('0x45')]));_0x509cc6[_0xf5e7('0x44')]=_0x509cc6[_0xf5e7('0x44')][_0xf5e7('0x46')]?_0x509cc6[_0xf5e7('0x44')]:_0x500b61['model'];if(!_0x41a850[_0xf5e7('0x41')][_0xf5e7('0xd0')]('nolimit')){_0x509cc6[_0xf5e7('0x26')]=qs[_0xf5e7('0x26')](_0x41a850[_0xf5e7('0x41')][_0xf5e7('0x26')]);_0x509cc6[_0xf5e7('0x25')]=qs[_0xf5e7('0x25')](_0x41a850['query']['offset']);}_0x509cc6[_0xf5e7('0x48')]=qs[_0xf5e7('0x49')](_0x41a850[_0xf5e7('0x41')][_0xf5e7('0x49')]);_0x509cc6[_0xf5e7('0x7e')]=qs[_0xf5e7('0x42')](_[_0xf5e7('0x4a')](_0x41a850[_0xf5e7('0x41')],_0x500b61['filters']));_0x509cc6[_0xf5e7('0x7e')][_0xf5e7('0xbd')]=_0x516b49['id'];if(_0x41a850[_0xf5e7('0x41')]['filter']){_0x509cc6['where']=_[_0xf5e7('0x9d')](_0x509cc6[_0xf5e7('0x7e')],{'$or':_[_0xf5e7('0x30')](_0x509cc6[_0xf5e7('0x44')],function(_0x4fa054){var _0x1e7b47={};_0x1e7b47[_0x4fa054]={'$like':'%'+_0x41a850['query'][_0xf5e7('0x89')]+'%'};return _0x1e7b47;})});}if(_0x41a850['query'][_0xf5e7('0x82')]){var _0x3a3ea0=_0x41a850['query'][_0xf5e7('0x82')][_0xf5e7('0x6d')](',');var _0x4ee2c9={};_0x4ee2c9[_0x3a3ea0[0x0]]={'$gte':moment(_0x3a3ea0[0x1])['format'](_0xf5e7('0xd1'))};_0x509cc6[_0xf5e7('0x7e')]=_[_0xf5e7('0x9d')](_0x509cc6['where'],_0x4ee2c9);}_0x509cc6=_['merge']({},_0x509cc6,_0x41a850[_0xf5e7('0xc7')]);return db[_0xf5e7('0xce')][_0xf5e7('0x24')]({'where':_0x509cc6[_0xf5e7('0x7e')]})[_0xf5e7('0x2a')](function(_0x5840b8){_0x22a8dd[_0xf5e7('0x24')]=_0x5840b8;if(_0x41a850[_0xf5e7('0x41')][_0xf5e7('0xc5')]){_0x509cc6[_0xf5e7('0xc6')]=[{'all':!![]}];}return db['MailMessage']['findAll'](_0x509cc6);})[_0xf5e7('0x2a')](function(_0x2e9477){_0x22a8dd[_0xf5e7('0xc1')]=_0x2e9477;return _0x22a8dd;});}})[_0xf5e7('0x2a')](respondWithFilteredResult(_0x23bc47,_0x509cc6))[_0xf5e7('0x3b')](handleError(_0x23bc47,null));};exports[_0xf5e7('0xd2')]=function(_0x13e192,_0x431b2f,_0x3de928){return db[_0xf5e7('0x35')][_0xf5e7('0x76')]({'where':{'id':_0x13e192['params']['id']}})[_0xf5e7('0x2a')](handleEntityNotFound(_0x431b2f,null))[_0xf5e7('0x2a')](function(_0xc9d7b){if(_0xc9d7b){return _0xc9d7b[_0xf5e7('0xd3')](_0x13e192[_0xf5e7('0xc9')][_0xf5e7('0xd4')],_['omit'](_0x13e192['body'],['ids','id'])||{})[_0xf5e7('0xd5')](function(){return db['Tag'][_0xf5e7('0xd6')]({'attributes':['id',_0xf5e7('0x40'),_0xf5e7('0x4d')],'where':{'id':_0x13e192[_0xf5e7('0xc9')][_0xf5e7('0xd4')]}});})['then'](function(_0xdb1d48){socket[_0xf5e7('0xd7')](_0xf5e7('0xd8'),{'id':Number(_0x13e192[_0xf5e7('0xc2')]['id']),'tags':_0xdb1d48||[]});return{'id':Number(_0x13e192[_0xf5e7('0xc2')]['id']),'tags':_0xdb1d48||[]};});}})[_0xf5e7('0x2a')](respondWithResult(_0x431b2f,null))['catch'](handleError(_0x431b2f,null));};exports['removeTags']=function(_0x5b27b7,_0x1b643a,_0xf317e2){return db[_0xf5e7('0x35')]['find']({'where':{'id':_0x5b27b7['params']['id']}})['then'](handleEntityNotFound(_0x1b643a,null))['then'](function(_0x11fecc){if(_0x11fecc){return _0x11fecc[_0xf5e7('0xd9')](_0x5b27b7[_0xf5e7('0x41')]['ids']);}})[_0xf5e7('0x2a')](respondWithStatusCode(_0x1b643a,null))[_0xf5e7('0x3b')](handleError(_0x1b643a,null));};exports[_0xf5e7('0xda')]=function(_0x351843,_0x2f8bc6){var _0x6b8605=moment()[_0xf5e7('0xdb')]()[_0xf5e7('0x9b')]();var _0x5f040d=path[_0xf5e7('0xdc')](config['root'],_0xf5e7('0xdd'),'files',_0xf5e7('0xde'));var _0x4f7454=path[_0xf5e7('0xdc')](config[_0xf5e7('0xdf')],_0xf5e7('0xdd'),_0xf5e7('0xe0'),_0xf5e7('0xe1'));var _0x3c9857=path[_0xf5e7('0xdc')](_0x5f040d,_0x6b8605);var _0x221247=util[_0xf5e7('0xe2')]('transcript-%d-%s.zip',_0x351843[_0xf5e7('0xc2')]['id'],_0x6b8605);var _0x36d5cc=path[_0xf5e7('0xdc')](_0x5f040d,_0x221247);var _0x488e45=[];if(_0x351843['query']['attachments']){_0x488e45[_0xf5e7('0x34')]({'model':db['Attachment'],'as':'Attachments','raw':!![]});}var _0x12ab36=[{'model':db['MailMessage'],'as':_0xf5e7('0xe3'),'attributes':['id',_0xf5e7('0xc9'),_0xf5e7('0x4e'),'to','cc',_0xf5e7('0xe4'),'subject','createdAt'],'where':{'secret':![]},'order':qs[_0xf5e7('0x49')]('id'),'include':_0x488e45}];return db[_0xf5e7('0x35')][_0xf5e7('0x76')]({'where':{'id':_0x351843[_0xf5e7('0xc2')]['id']},'include':_0x12ab36})[_0xf5e7('0x2a')](handleEntityNotFound(_0x2f8bc6,null))['then'](function(_0x17c304){if(_0x17c304&&_0x17c304['Messages']){var _0x22517b=_0x17c304[_0xf5e7('0xe5')]({'plain':!![]});fs[_0xf5e7('0xe6')](_0x3c9857);return BPromise[_0xf5e7('0xe7')](_0x22517b[_0xf5e7('0xe3')],function(_0x5a6b6b,_0x4fa644){var _0x1943e1={'from':_0x5a6b6b[_0xf5e7('0x4e')],'to':_0x5a6b6b['to'],'subject':_0x5a6b6b['subject'],'html':_0x5a6b6b['body'],'headers':{'Date':moment(_0x5a6b6b[_0xf5e7('0x80')])[_0xf5e7('0xe2')](_0xf5e7('0xe8'))},'attachments':[]};if(_0x5a6b6b['cc']){_0x1943e1[_0xf5e7('0xe9')]['Cc']=_0x5a6b6b['cc'];}if(_0x5a6b6b[_0xf5e7('0xe4')]){_0x1943e1[_0xf5e7('0xe9')][_0xf5e7('0xea')]=_0x5a6b6b['bcc'];}return new BPromise(function(_0x4273d8,_0x1d0117){if(_0x5a6b6b[_0xf5e7('0xeb')]){for(var _0x2c1110=0x0;_0x2c1110<_0x5a6b6b['Attachments'][_0xf5e7('0x46')];_0x2c1110++){var _0x8d000f=_0x5a6b6b[_0xf5e7('0xeb')][_0x2c1110];var _0x351bd6=path['join'](_0x4f7454,_0x8d000f['basename']);if(fs[_0xf5e7('0xec')](_0x351bd6)){_0x1943e1[_0xf5e7('0xe1')][_0xf5e7('0x34')]({'name':_0x8d000f[_0xf5e7('0x40')],'contentType':_0x8d000f[_0xf5e7('0x3d')],'data':fs[_0xf5e7('0xed')](_0x351bd6)});}}}emlformat[_0xf5e7('0xee')](_0x1943e1,function(_0x138abb,_0x4ef74f){if(_0x138abb)return _0x1d0117(_0x138abb);fs['writeFileSync'](path['join'](_0x3c9857,util['format']('message%d.eml',_0x4fa644)),_0x4ef74f);return _0x4273d8(_0x4ef74f);});});})[_0xf5e7('0x2a')](function(){return new BPromise(function(_0x393a97,_0x57704d){zipdir(_0x3c9857,{'saveTo':_0x36d5cc},function(_0x17af79,_0x23f68d){if(_0x17af79)return _0x57704d(_0x17af79);return _0x393a97(_0x23f68d);});})[_0xf5e7('0x2a')](function(){return new BPromise(function(_0x91e27a,_0x188388){rimraf(_0x3c9857,function(_0x584d33){if(_0x584d33)_0x188388(_0x584d33);return _0x91e27a();});});})[_0xf5e7('0x2a')](function(){return _0x2f8bc6['download'](_0x36d5cc,_0x221247,function(_0x397e57){if(_0x397e57){console['log'](_0xf5e7('0xef'),_0x397e57);}else{fs[_0xf5e7('0xf0')](_0x36d5cc);}});});});}else{return _0x2f8bc6[_0xf5e7('0x2b')](0xc8);}})[_0xf5e7('0x3b')](handleError(_0x2f8bc6,null));};
\ No newline at end of file
+var _0x0ca5=['headers','Bcc','Attachments','basename','build','writeFileSync','message%d.eml','log','err','unlinkSync','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','lodash','squel','jsforce','papaparse','html-to-text','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','register','sendStatus','status','end','json','offset','limit','set','Content-Range','apply','reject','save','update','destroy','error','stack','name','send','Users','map','fullname','TagIds','Tags','split','push','MailInteraction','findOne','lastMsgBody','lastMsgText','then','trimStart','fromString','catch','rawAttributes','fieldName','type','model','query','keys','filters','intersection','attributes','fields','length','nolimit','order','sort','where','pick','select','field','color','from','tools_tags','u.fullname','ui.MailInteractionId','user_has_mail_interactions','left_join','users','u.id\x20=\x20ui.UserId','mail_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','mail_accounts','mail_messages','me.MailInteractionId\x20=\x20i.id','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','expr','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','operator','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','text','start','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','$substring','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','buildExpression','plainBody','some','compact','isEmpty','forEach','i.MailAccountId\x20IN\x20?','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','tag','isArray','filter','replace','\x27\x27\x27\x27','isNumeric','i.id\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','DESC','t.id\x20IN\x20?','resolve','MailAccountId','journey','i.MailAccountId\x20IS\x20NOT\x20NULL','getMailAccounts','i.MailAccountId\x20IS\x20NULL','sequelize','toString','count','keyBy','merge','Account.key','a.mandatoryDisposition','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.disposition','i.secondDisposition','i.thirdDisposition','i.substatus','i.to','i.ContactId','i.MailAccountId','c.firstName','c.phone','Contact.phone','Contact.mobile','c.fax','o.fullname','Owner.fullname','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','MailInteractionId','Setting','enableEmailPreview','rows','show','params','filtears','includeAll','include','options','create','body','describe','addMessage','ids','omit','getMessages','MailMessage','hasOwnProperty','format','addTags','setTags','spread','Tag','findAll','emit','mailInteractionTags:save','removeTags','download','unix','join','server','tmp','root','files','attachments','transcript-%d-%s.zip','Attachment','Messages','bcc','subject','get','mkdirSync'];(function(_0xd016ec,_0x7f7454){var _0x5d84dd=function(_0x19dc34){while(--_0x19dc34){_0xd016ec['push'](_0xd016ec['shift']());}};_0x5d84dd(++_0x7f7454);}(_0x0ca5,0xfc));var _0x50ca=function(_0x49692d,_0x419ce9){_0x49692d=_0x49692d-0x0;var _0x277fca=_0x0ca5[_0x49692d];return _0x277fca;};'use strict';var pdf=require(_0x50ca('0x0'));var emlformat=require(_0x50ca('0x1'));var rimraf=require(_0x50ca('0x2'));var zipdir=require(_0x50ca('0x3'));var jsonpatch=require(_0x50ca('0x4'));var rp=require(_0x50ca('0x5'));var moment=require(_0x50ca('0x6'));var BPromise=require(_0x50ca('0x7'));var Mustache=require('mustache');var util=require(_0x50ca('0x8'));var path=require(_0x50ca('0x9'));var sox=require(_0x50ca('0xa'));var csv=require(_0x50ca('0xb'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x50ca('0xc'));var squel=require(_0x50ca('0xd'));var crypto=require('crypto');var jsforce=require(_0x50ca('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x50ca('0xb'));var querystring=require('querystring');var Papa=require(_0x50ca('0xf'));var htmlToText=require(_0x50ca('0x10'));var Redis=require(_0x50ca('0x11'));var authService=require(_0x50ca('0x12'));var qs=require(_0x50ca('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x50ca('0x14'))(_0x50ca('0x15'));var utils=require(_0x50ca('0x16'));var config=require(_0x50ca('0x17'));var licenseUtil=require(_0x50ca('0x18'));var db=require(_0x50ca('0x19'))['db'];config[_0x50ca('0x1a')]=_[_0x50ca('0x1b')](config[_0x50ca('0x1a')],{'host':_0x50ca('0x1c'),'port':0x18eb});var socket=require(_0x50ca('0x1d'))(new Redis(config[_0x50ca('0x1a')]));require(_0x50ca('0x1e'))[_0x50ca('0x1f')](socket);function respondWithStatusCode(_0x3653b9,_0x512344){_0x512344=_0x512344||0xcc;return function(_0x168436){if(_0x168436){return _0x3653b9[_0x50ca('0x20')](_0x512344);}return _0x3653b9[_0x50ca('0x21')](_0x512344)[_0x50ca('0x22')]();};}function respondWithResult(_0x1b9e58,_0x4ee39b){_0x4ee39b=_0x4ee39b||0xc8;return function(_0x1566f4){if(_0x1566f4){return _0x1b9e58['status'](_0x4ee39b)[_0x50ca('0x23')](_0x1566f4);}};}function respondWithFilteredResult(_0x13ea58,_0x1b1f61){return function(_0xc2407b){if(_0xc2407b){var _0x4d9cbc=_0xc2407b['count'],_0x32f613=_0x1b1f61['offset'],_0x9f19a9=_0x1b1f61[_0x50ca('0x24')]+_0x1b1f61[_0x50ca('0x25')],_0x2779f9;if(_0x9f19a9>=_0x4d9cbc){_0x9f19a9=_0x4d9cbc;_0x2779f9=0xc8;}else{_0x2779f9=0xce;}_0x13ea58[_0x50ca('0x21')](_0x2779f9);return _0x13ea58[_0x50ca('0x26')](_0x50ca('0x27'),_0x32f613+'-'+_0x9f19a9+'/'+_0x4d9cbc)[_0x50ca('0x23')](_0xc2407b);}return null;};}function patchUpdates(_0x48203d){return function(_0x52027a){try{jsonpatch[_0x50ca('0x28')](_0x52027a,_0x48203d,!![]);}catch(_0x2e522f){return BPromise[_0x50ca('0x29')](_0x2e522f);}return _0x52027a[_0x50ca('0x2a')]();};}function saveUpdates(_0x1f2c49,_0xd6353f){return function(_0x7e6bad){if(_0x7e6bad){return _0x7e6bad[_0x50ca('0x2b')](_0x1f2c49)['then'](function(_0x53e1e7){return _0x53e1e7;});}return null;};}function removeEntity(_0x8ad718,_0x5c6dcd){return function(_0x2c828a){if(_0x2c828a){return _0x2c828a[_0x50ca('0x2c')]()['then'](function(){_0x8ad718[_0x50ca('0x21')](0xcc)[_0x50ca('0x22')]();});}};}function handleEntityNotFound(_0x3b12d9,_0x5a5f19){return function(_0x32cd92){if(!_0x32cd92){_0x3b12d9['sendStatus'](0x194);}return _0x32cd92;};}function handleError(_0x34f536,_0x1ebf0d){_0x1ebf0d=_0x1ebf0d||0x1f4;return function(_0x17cfd0){logger[_0x50ca('0x2d')](_0x17cfd0[_0x50ca('0x2e')]);if(_0x17cfd0['name']){delete _0x17cfd0[_0x50ca('0x2f')];}_0x34f536[_0x50ca('0x21')](_0x1ebf0d)[_0x50ca('0x30')](_0x17cfd0);};}function getInteractionUsers(_0x2707d5,_0xf262a8){return new BPromise(function(_0x119d1f,_0x386d03){try{if(_0xf262a8[_0x2707d5['id']]){_0x2707d5[_0x50ca('0x31')]=_[_0x50ca('0x32')](_0xf262a8[_0x2707d5['id']],function(_0x34aad2){return{'id':_0x34aad2['id'],'fullname':_0x34aad2[_0x50ca('0x33')]};});}}catch(_0x5e4285){_0x386d03(_0x5e4285);}_0x119d1f(_0x2707d5);});}function getInteractionTags(_0x474a2a,_0x2c3133){return new BPromise(function(_0x16e8bf,_0x98b558){try{if(_0x474a2a[_0x50ca('0x34')]){_0x474a2a[_0x50ca('0x35')]=[];_0x474a2a[_0x50ca('0x34')][_0x50ca('0x36')](',')['forEach'](function(_0x7832eb){_0x474a2a[_0x50ca('0x35')][_0x50ca('0x37')](_0x2c3133[_0x7832eb]);});}delete _0x474a2a[_0x50ca('0x34')];}catch(_0x128d82){_0x98b558(_0x128d82);}_0x16e8bf(_0x474a2a);});}function getLastMessageText(_0x4bb24d){return new BPromise(function(_0x2b3f40,_0x55cda7){return db[_0x50ca('0x38')][_0x50ca('0x39')]({'where':{'id':_0x4bb24d['id']},'attributes':[_0x50ca('0x3a'),_0x50ca('0x3b')],'raw':!![]})[_0x50ca('0x3c')](function(_0x5b1d44){if(!_0x5b1d44[_0x50ca('0x3b')]){_0x4bb24d[_0x50ca('0x3b')]=_[_0x50ca('0x3d')](htmlToText[_0x50ca('0x3e')](_0x5b1d44[_0x50ca('0x3a')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x4bb24d['lastMsgText']=_0x5b1d44[_0x50ca('0x3b')];}_0x2b3f40(_0x4bb24d);})[_0x50ca('0x3f')](function(_0x5a14f0){_0x55cda7(_0x5a14f0);});});}function updateMailInteraction(_0x35a304,_0x242855,_0x1e59b8,_0x25b2f3){return new BPromise(function(_0x332830,_0x54a83a){return getInteractionUsers(_0x35a304,_0x1e59b8)[_0x50ca('0x3c')](function(_0x420d12){return getInteractionTags(_0x420d12,_0x242855);})[_0x50ca('0x3c')](function(_0x58726e){if(_0x25b2f3){_0x332830(getLastMessageText(_0x58726e));}else{_0x332830(_0x58726e);}})['catch'](function(_0x5470f4){_0x54a83a(_0x5470f4);});});}exports['index']=function(_0x3fac06,_0x54fd06){var _0x6c23a0={},_0x262c57={},_0x27149b={'count':0x0,'rows':[]};var _0xb80389=_[_0x50ca('0x32')](db[_0x50ca('0x38')][_0x50ca('0x40')],function(_0xc4d922){return{'name':_0xc4d922[_0x50ca('0x41')],'type':_0xc4d922[_0x50ca('0x42')]['key']};});_0x262c57[_0x50ca('0x43')]=_[_0x50ca('0x32')](_0xb80389,'name');_0x262c57[_0x50ca('0x44')]=_[_0x50ca('0x45')](_0x3fac06[_0x50ca('0x44')]);_0x262c57[_0x50ca('0x46')]=_[_0x50ca('0x47')](_0x262c57[_0x50ca('0x43')],_0x262c57[_0x50ca('0x44')]);_0x6c23a0[_0x50ca('0x48')]=_[_0x50ca('0x47')](_0x262c57['model'],qs['fields'](_0x3fac06[_0x50ca('0x44')][_0x50ca('0x49')]));_0x6c23a0[_0x50ca('0x48')]=_0x6c23a0[_0x50ca('0x48')][_0x50ca('0x4a')]?_0x6c23a0[_0x50ca('0x48')]:_0x262c57['model'];if(!_0x3fac06['query']['hasOwnProperty'](_0x50ca('0x4b'))){_0x6c23a0['limit']=qs[_0x50ca('0x25')](_0x3fac06[_0x50ca('0x44')][_0x50ca('0x25')]);_0x6c23a0[_0x50ca('0x24')]=qs[_0x50ca('0x24')](_0x3fac06[_0x50ca('0x44')][_0x50ca('0x24')]);}_0x6c23a0[_0x50ca('0x4c')]=qs[_0x50ca('0x4d')](_0x3fac06['query'][_0x50ca('0x4d')]);_0x6c23a0[_0x50ca('0x4e')]=qs[_0x50ca('0x46')](_[_0x50ca('0x4f')](_0x3fac06[_0x50ca('0x44')],_0x262c57['filters']),_0xb80389);var _0x36fe2e=[];var _0x102581=squel[_0x50ca('0x50')]()[_0x50ca('0x51')]('id')[_0x50ca('0x51')]('name')[_0x50ca('0x51')](_0x50ca('0x52'))[_0x50ca('0x53')](_0x50ca('0x54'));var _0x4b27cf=squel[_0x50ca('0x50')]()[_0x50ca('0x51')]('u.id')[_0x50ca('0x51')](_0x50ca('0x55'))[_0x50ca('0x51')](_0x50ca('0x56'))[_0x50ca('0x53')](_0x50ca('0x57'),'ui')[_0x50ca('0x58')](_0x50ca('0x59'),'u',_0x50ca('0x5a'));var _0x2c6f55=squel[_0x50ca('0x50')]()[_0x50ca('0x53')](_0x50ca('0x5b'),'i')[_0x50ca('0x58')](_0x50ca('0x5c'),'c',_0x50ca('0x5d'))[_0x50ca('0x58')](_0x50ca('0x59'),'o','o.id\x20=\x20i.UserId')[_0x50ca('0x58')](_0x50ca('0x5e'),'a','a.id\x20=\x20i.MailAccountId')[_0x50ca('0x58')](_0x50ca('0x5f'),'me',_0x50ca('0x60'))[_0x50ca('0x58')](_0x50ca('0x61'),'it',_0x50ca('0x62'))[_0x50ca('0x58')](_0x50ca('0x54'),'t','t.id\x20=\x20it.TagId');var _0x3e7552=squel[_0x50ca('0x63')]();var _0x535779=[];var _0x27755f=squel[_0x50ca('0x63')]();var _0x531ab7;if(_0x3fac06[_0x50ca('0x44')]['search']){_0x531ab7=as[_0x50ca('0x64')](_0x3fac06[_0x50ca('0x44')]['search']);var _0x497127=_0x531ab7[_0x50ca('0x65')];for(var _0x1c75aa=0x0;_0x1c75aa<_0x531ab7['conditions'][_0x50ca('0x4a')];_0x1c75aa++){var _0x33625f=_0x531ab7[_0x50ca('0x66')][_0x1c75aa];var _0x11811f='i';var _0x57a6fe=_[_0x50ca('0x67')](_0xb80389,[_0x50ca('0x2f'),_0x33625f[_0x50ca('0x51')]]);if(!_0x57a6fe){switch(_0x33625f[_0x50ca('0x51')]){case _0x50ca('0x68'):if(_0x33625f[_0x50ca('0x69')]==0x1){_0x2c6f55[_0x50ca('0x6a')]('`'+_0x33625f[_0x50ca('0x51')]+_0x50ca('0x6b'));}else{_0x2c6f55[_0x50ca('0x6a')]('`'+_0x33625f[_0x50ca('0x51')]+_0x50ca('0x6c'));}break;case'Contact':if(_0x33625f[_0x50ca('0x6d')]==='$substring'){if(_0x33625f[_0x50ca('0x69')][_0x50ca('0x36')]('\x20')[_0x50ca('0x4a')]>0x1){_0x3e7552[_0x497127]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x50ca('0x6e')](_0x33625f[_0x50ca('0x69')]),null);}else{var _0x3ef38d='%'+_0x33625f[_0x50ca('0x69')]+'%';_0x3e7552[_0x497127](_0x50ca('0x6f'),_0x3ef38d,_0x3ef38d,_0x3ef38d);}}else{_0x57a6fe=_['find'](_0xb80389,[_0x50ca('0x2f'),_0x50ca('0x70')]);_0x33625f[_0x50ca('0x51')]=_0x50ca('0x70');_0x50278e=as['buildExpression'](_0x11811f,_0x57a6fe[_0x50ca('0x42')],_0x33625f);_0x3e7552[_0x497127](_0x50278e[_0x50ca('0x71')],_0x50278e[_0x50ca('0x69')][_0x50ca('0x72')],_0x50278e[_0x50ca('0x69')][_0x50ca('0x22')]);}break;case'Tag':var _0x2ffd61=_0x33625f[_0x50ca('0x69')]['split'](',')[_0x50ca('0x32')](function(_0xfaa5ae){return Number(_0xfaa5ae);});_0x2ffd61['forEach'](function(_0x7ae92d){_0x27755f['or'](_0x50ca('0x73'),'%,'+_0x7ae92d+',%');});_0x535779=_['union'](_0x535779,_0x2ffd61);break;case'User':if(_0x33625f['operator']===_0x50ca('0x74')){_0x3e7552[_0x497127](_0x50ca('0x75'),'%'+_0x33625f['value']+'%',null);}else{_0x57a6fe=_['find'](_0xb80389,[_0x50ca('0x2f'),_0x50ca('0x76')]);_0x33625f[_0x50ca('0x51')]=_0x50ca('0x76');_0x50278e=as[_0x50ca('0x77')](_0x11811f,_0x57a6fe[_0x50ca('0x42')],_0x33625f);_0x3e7552[_0x497127](_0x50278e[_0x50ca('0x71')],_0x50278e[_0x50ca('0x69')]['start'],_0x50278e[_0x50ca('0x69')][_0x50ca('0x22')]);}break;case _0x50ca('0x78'):_0x50278e=as[_0x50ca('0x77')]('me',null,_0x33625f);_0x3e7552[_0x497127](_0x50278e[_0x50ca('0x71')],_0x50278e['value'][_0x50ca('0x72')],_0x50278e['value'][_0x50ca('0x22')]);break;}}else{var _0x50278e=as[_0x50ca('0x77')](_0x11811f,_0x57a6fe['type'],_0x33625f);_0x3e7552[_0x497127](_0x50278e[_0x50ca('0x71')],_0x50278e[_0x50ca('0x69')]['start'],_0x50278e['value'][_0x50ca('0x22')]);}}}else{var _0x18c67e=_(_0x3fac06['query'])[_0x50ca('0x45')]()[_0x50ca('0x32')](function(_0x27f51a){return _[_0x50ca('0x79')](_0xb80389,['name',_0x27f51a])?_0x27f51a:undefined;})[_0x50ca('0x7a')]()[_0x50ca('0x69')]();if(!_[_0x50ca('0x7b')](_0x18c67e)){_0x18c67e[_0x50ca('0x7c')](function(_0x4fe37d){if(_0x4fe37d==='MailAccountId'){_0x2c6f55[_0x50ca('0x4e')](_0x50ca('0x7d'),[][_0x50ca('0x7e')](_0x3fac06['query'][_0x4fe37d]));}else if(_0x4fe37d===_0x50ca('0x7f')){var _0x49e45d=JSON[_0x50ca('0x80')](_0x3fac06[_0x50ca('0x44')][_0x4fe37d])[_0x50ca('0x81')];var _0x26b26b=JSON[_0x50ca('0x80')](_0x3fac06[_0x50ca('0x44')][_0x4fe37d])[_0x50ca('0x82')];_0x2c6f55['where'](_0x50ca('0x83'),_0x49e45d,_0x26b26b);}else{if(_0x3fac06['query'][_0x4fe37d]==='null'){_0x2c6f55[_0x50ca('0x4e')]('i.'+_0x4fe37d+_0x50ca('0x84'));}else{_0x2c6f55[_0x50ca('0x4e')]('i.'+_0x4fe37d+_0x50ca('0x85'),_0x3fac06[_0x50ca('0x44')][_0x4fe37d]);}}});}if(_0x3fac06[_0x50ca('0x44')][_0x50ca('0x86')]){if(_0x3fac06[_0x50ca('0x44')]['read']==0x1){_0x2c6f55[_0x50ca('0x6a')](_0x50ca('0x87'));}else{_0x2c6f55['having']('`unreadMessages`\x20>\x200');}}if(_0x3fac06['query'][_0x50ca('0x88')]){_0x535779=_[_0x50ca('0x89')](_0x3fac06[_0x50ca('0x44')][_0x50ca('0x88')])?_0x3fac06[_0x50ca('0x44')][_0x50ca('0x88')]:new Array(_0x3fac06[_0x50ca('0x44')][_0x50ca('0x88')]);_0x535779[_0x50ca('0x7c')](function(_0x4651b9){_0x27755f['or'](_0x50ca('0x73'),'%,'+_0x4651b9+',%');});}if(_0x3fac06[_0x50ca('0x44')][_0x50ca('0x8a')]){var _0x1b8a32=_0x3fac06[_0x50ca('0x44')]['filter']['replace']('\x5c','\x5c\x5c')[_0x50ca('0x8b')]('\x27\x27',_0x50ca('0x8c'));if(qs[_0x50ca('0x8d')](_0x1b8a32)){_0x3e7552['or'](_0x50ca('0x8e'),_0x1b8a32+'%');}else if(qs[_0x50ca('0x8f')](_0x1b8a32)){_0x3e7552['or'](_0x50ca('0x90'),_0x1b8a32+'%');}else{_0x3e7552['or'](_0x50ca('0x91'),qs['getFullTextValue'](_0x1b8a32))['or'](_0x50ca('0x92'),qs['getFullTextValue'](_0x1b8a32));}}}_0x2c6f55[_0x50ca('0x4e')](_0x3e7552);_0x2c6f55[_0x50ca('0x93')](_0x50ca('0x94'));var _0x1a896d={'type':db['Sequelize']['QueryTypes'][_0x50ca('0x95')],'raw':!![]};var _0x59724b=_0x2c6f55[_0x50ca('0x96')]();_0x59724b[_0x50ca('0x51')](_0x50ca('0x94'));_0x59724b['field'](_0x50ca('0x97'),'unreadMessages');if(_0x6c23a0[_0x50ca('0x4c')]){_0x6c23a0[_0x50ca('0x4c')][_0x50ca('0x7c')](function(_0x26af28){_0x2c6f55[_0x50ca('0x4c')]('i.'+_0x26af28[0x0],_0x26af28[0x1]===_0x50ca('0x98')?![]:!![]);});}if(!_[_0x50ca('0x7b')](_0x535779)){_0x2c6f55[_0x50ca('0x6a')](_0x27755f);_0x59724b[_0x50ca('0x4e')](_0x50ca('0x99'),_0x535779);}BPromise[_0x50ca('0x9a')]()[_0x50ca('0x3c')](function(){if(!_0x531ab7){if(_0x3fac06['query'][_0x50ca('0x9b')]||_0x3fac06[_0x50ca('0x44')][_0x50ca('0x9c')])return;_0x59724b[_0x50ca('0x4e')](_0x50ca('0x9d'));_0x2c6f55[_0x50ca('0x4e')](_0x50ca('0x9d'));return;}return _0x3fac06['user'][_0x50ca('0x9e')]({'attributes':['id'],'raw':!![]})[_0x50ca('0x3c')](function(_0x544920){if(_[_0x50ca('0x7b')](_0x544920)){_0x59724b[_0x50ca('0x4e')]('i.MailAccountId\x20IS\x20NULL');_0x2c6f55[_0x50ca('0x4e')](_0x50ca('0x9f'));}else{_0x59724b[_0x50ca('0x4e')](_0x50ca('0x7d'),_[_0x50ca('0x32')](_0x544920,'id'));_0x2c6f55[_0x50ca('0x4e')](_0x50ca('0x7d'),_[_0x50ca('0x32')](_0x544920,'id'));}});})['then'](function(){db[_0x50ca('0xa0')][_0x50ca('0x44')](_0x59724b[_0x50ca('0xa1')](),_0x1a896d)[_0x50ca('0x3c')](function(_0x50f375){_0x27149b[_0x50ca('0xa2')]=_0x50f375[_0x50ca('0x4a')];if(_0x27149b[_0x50ca('0xa2')]===0x0)return[];return db['sequelize'][_0x50ca('0x44')](_0x102581[_0x50ca('0xa1')](),_0x1a896d)[_0x50ca('0x3c')](function(_0x292b2f){_0x36fe2e=_[_0x50ca('0xa3')](_0x292b2f,'id');_0x1a896d=_[_0x50ca('0xa4')](_0x1a896d,{'model':db[_0x50ca('0x38')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x3fac06[_0x50ca('0x44')][_0x50ca('0x49')]){_0x6c23a0['attributes'][_0x50ca('0x7c')](function(_0xf360eb){_0x2c6f55['field']('i.'+_0xf360eb);});}else{_0x2c6f55[_0x50ca('0x51')](_0x50ca('0x97'),'unreadMessages');_0x2c6f55['field']('a.key',_0x50ca('0xa5'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xa6'),'Account.mandatoryDisposition');_0x2c6f55['field'](_0x50ca('0x94'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xa7'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xa8'));_0x2c6f55['field'](_0x50ca('0xa9'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xaa'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xab'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xac'));_0x2c6f55[_0x50ca('0x51')]('i.lastMsgDirection');_0x2c6f55[_0x50ca('0x51')]('i.subject');_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xad'));_0x2c6f55['field'](_0x50ca('0xae'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xaf'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xb0'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xb1'));_0x2c6f55['field'](_0x50ca('0xb2'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xb3'));_0x2c6f55[_0x50ca('0x51')]('i.UserId');_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xb4'),'Contact.firstName');_0x2c6f55[_0x50ca('0x51')]('c.lastName','Contact.lastName');_0x2c6f55[_0x50ca('0x51')]('c.email','Contact.email');_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xb5'),_0x50ca('0xb6'));_0x2c6f55[_0x50ca('0x51')]('c.mobile',_0x50ca('0xb7'));_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xb8'),'Contact.fax');_0x2c6f55['field'](_0x50ca('0xb9'),_0x50ca('0xba'));_0x2c6f55['field']('o.internal','Owner.internal');_0x2c6f55[_0x50ca('0x51')](_0x50ca('0xbb'),'TagIds');}if(_0x6c23a0[_0x50ca('0x25')])_0x2c6f55[_0x50ca('0x25')](_0x6c23a0[_0x50ca('0x25')]);if(_0x6c23a0['offset'])_0x2c6f55[_0x50ca('0x24')](_0x6c23a0[_0x50ca('0x24')]);return db[_0x50ca('0xa0')]['query'](_0x2c6f55['toString'](),_0x1a896d);})[_0x50ca('0x3c')](function(_0x48fd7a){_0x4b27cf['where'](_0x50ca('0xbc'),_['map'](_0x48fd7a,'id'));return db[_0x50ca('0xa0')][_0x50ca('0x44')](_0x4b27cf['toString'](),_0x1a896d)[_0x50ca('0x3c')](function(_0x45a4c2){var _0x4e8c82=_['groupBy'](_0x45a4c2,_0x50ca('0xbd'));var _0x28c0ca=[];return db[_0x50ca('0xbe')][_0x50ca('0x39')]({'attributes':['enableEmailPreview'],'raw':!![]})[_0x50ca('0x3c')](function(_0x7da4d0){var _0x5c12e2=_0x7da4d0[_0x50ca('0xbf')];_0x48fd7a[_0x50ca('0x7c')](function(_0x1c7edb){_0x28c0ca[_0x50ca('0x37')](updateMailInteraction(_0x1c7edb,_0x36fe2e,_0x4e8c82,_0x5c12e2));});return BPromise['all'](_0x28c0ca);});});});})[_0x50ca('0x3c')](function(_0x7b1c63){_0x27149b[_0x50ca('0xc0')]=_0x7b1c63;return _0x27149b;})[_0x50ca('0x3c')](respondWithFilteredResult(_0x54fd06,_0x6c23a0));})[_0x50ca('0x3f')](handleError(_0x54fd06,null));};exports[_0x50ca('0xc1')]=function(_0x30ba4d,_0x316f5e){var _0x55eb09={'raw':![],'where':{'id':_0x30ba4d[_0x50ca('0xc2')]['id']}},_0x5da591={};_0x5da591[_0x50ca('0x43')]=_[_0x50ca('0x45')](db['MailInteraction']['rawAttributes']);_0x5da591[_0x50ca('0x44')]=_['keys'](_0x30ba4d['query']);_0x5da591[_0x50ca('0xc3')]=_[_0x50ca('0x47')](_0x5da591[_0x50ca('0x43')],_0x5da591[_0x50ca('0x44')]);_0x55eb09[_0x50ca('0x48')]=_[_0x50ca('0x47')](_0x5da591[_0x50ca('0x43')],qs[_0x50ca('0x49')](_0x30ba4d[_0x50ca('0x44')]['fields']));_0x55eb09[_0x50ca('0x48')]=_0x55eb09[_0x50ca('0x48')][_0x50ca('0x4a')]?_0x55eb09[_0x50ca('0x48')]:_0x5da591[_0x50ca('0x43')];if(_0x30ba4d[_0x50ca('0x44')][_0x50ca('0xc4')]){_0x55eb09[_0x50ca('0xc5')]=[{'all':!![]}];}_0x55eb09=_['merge']({},_0x55eb09,_0x30ba4d[_0x50ca('0xc6')]);return db[_0x50ca('0x38')][_0x50ca('0x67')](_0x55eb09)[_0x50ca('0x3c')](handleEntityNotFound(_0x316f5e,null))[_0x50ca('0x3c')](respondWithResult(_0x316f5e,null))[_0x50ca('0x3f')](handleError(_0x316f5e,null));};exports[_0x50ca('0xc7')]=function(_0x39df21,_0x3d2360){return db[_0x50ca('0x38')][_0x50ca('0xc7')](_0x39df21[_0x50ca('0xc8')],{})[_0x50ca('0x3c')](respondWithResult(_0x3d2360,0xc9))[_0x50ca('0x3f')](handleError(_0x3d2360,null));};exports[_0x50ca('0x2b')]=function(_0xb039cf,_0xce6e59){if(_0xb039cf[_0x50ca('0xc8')]['id']){delete _0xb039cf[_0x50ca('0xc8')]['id'];}return db[_0x50ca('0x38')][_0x50ca('0x67')]({'where':{'id':_0xb039cf[_0x50ca('0xc2')]['id']}})[_0x50ca('0x3c')](handleEntityNotFound(_0xce6e59,null))[_0x50ca('0x3c')](saveUpdates(_0xb039cf['body'],null))[_0x50ca('0x3c')](respondWithResult(_0xce6e59,null))[_0x50ca('0x3f')](handleError(_0xce6e59,null));};exports[_0x50ca('0x2c')]=function(_0xace756,_0x5c5963){return db[_0x50ca('0x38')]['find']({'where':{'id':_0xace756[_0x50ca('0xc2')]['id']}})[_0x50ca('0x3c')](handleEntityNotFound(_0x5c5963,null))[_0x50ca('0x3c')](removeEntity(_0x5c5963,null))[_0x50ca('0x3f')](handleError(_0x5c5963,null));};exports[_0x50ca('0xc9')]=function(_0x144723,_0x142cdf){return db[_0x50ca('0x38')][_0x50ca('0xc9')]()[_0x50ca('0x3c')](respondWithResult(_0x142cdf,null))[_0x50ca('0x3f')](handleError(_0x142cdf,null));};exports['addMessage']=function(_0x5685bf,_0x444845,_0x4a8a7){return db['MailMessage']['find']({'where':{'id':_0x5685bf['params']['id']}})['then'](handleEntityNotFound(_0x444845,null))[_0x50ca('0x3c')](function(_0x1457c4){if(_0x1457c4){return _0x1457c4[_0x50ca('0xca')](_0x5685bf[_0x50ca('0xc8')][_0x50ca('0xcb')],_[_0x50ca('0xcc')](_0x5685bf[_0x50ca('0xc8')],[_0x50ca('0xcb'),'id'])||{});}})[_0x50ca('0x3c')](respondWithResult(_0x444845,null))[_0x50ca('0x3f')](handleError(_0x444845,null));};exports[_0x50ca('0xcd')]=function(_0x3798ca,_0xdc9aef,_0x331037){var _0x82e5f7={'raw':![],'where':{}};var _0x52ccd4={};var _0x1b85cc={'count':0x0,'rows':[]};return db['MailInteraction'][_0x50ca('0x39')]({'where':{'id':_0x3798ca[_0x50ca('0xc2')]['id']}})[_0x50ca('0x3c')](handleEntityNotFound(_0xdc9aef,null))[_0x50ca('0x3c')](function(_0x31dce6){if(_0x31dce6){_0x52ccd4[_0x50ca('0x43')]=_[_0x50ca('0x45')](db[_0x50ca('0xce')][_0x50ca('0x40')]);_0x52ccd4[_0x50ca('0x44')]=_[_0x50ca('0x45')](_0x3798ca['query']);_0x52ccd4[_0x50ca('0x46')]=_[_0x50ca('0x47')](_0x52ccd4['model'],_0x52ccd4[_0x50ca('0x44')]);_0x82e5f7[_0x50ca('0x48')]=_[_0x50ca('0x47')](_0x52ccd4['model'],qs['fields'](_0x3798ca[_0x50ca('0x44')][_0x50ca('0x49')]));_0x82e5f7[_0x50ca('0x48')]=_0x82e5f7[_0x50ca('0x48')]['length']?_0x82e5f7[_0x50ca('0x48')]:_0x52ccd4[_0x50ca('0x43')];if(!_0x3798ca[_0x50ca('0x44')][_0x50ca('0xcf')]('nolimit')){_0x82e5f7['limit']=qs[_0x50ca('0x25')](_0x3798ca[_0x50ca('0x44')][_0x50ca('0x25')]);_0x82e5f7[_0x50ca('0x24')]=qs[_0x50ca('0x24')](_0x3798ca[_0x50ca('0x44')][_0x50ca('0x24')]);}_0x82e5f7[_0x50ca('0x4c')]=qs[_0x50ca('0x4d')](_0x3798ca[_0x50ca('0x44')]['sort']);_0x82e5f7[_0x50ca('0x4e')]=qs[_0x50ca('0x46')](_[_0x50ca('0x4f')](_0x3798ca[_0x50ca('0x44')],_0x52ccd4[_0x50ca('0x46')]));_0x82e5f7[_0x50ca('0x4e')][_0x50ca('0xbd')]=_0x31dce6['id'];if(_0x3798ca[_0x50ca('0x44')][_0x50ca('0x8a')]){_0x82e5f7[_0x50ca('0x4e')]=_[_0x50ca('0xa4')](_0x82e5f7['where'],{'$or':_[_0x50ca('0x32')](_0x82e5f7[_0x50ca('0x48')],function(_0x590731){var _0x17ce1a={};_0x17ce1a[_0x590731]={'$like':'%'+_0x3798ca[_0x50ca('0x44')][_0x50ca('0x8a')]+'%'};return _0x17ce1a;})});}if(_0x3798ca['query'][_0x50ca('0x81')]){var _0xe8fdab=_0x3798ca[_0x50ca('0x44')][_0x50ca('0x81')][_0x50ca('0x36')](',');var _0x18b2f7={};_0x18b2f7[_0xe8fdab[0x0]]={'$gte':moment(_0xe8fdab[0x1])[_0x50ca('0xd0')]('YYYY-MM-DD\x20HH:mm:ss')};_0x82e5f7[_0x50ca('0x4e')]=_[_0x50ca('0xa4')](_0x82e5f7['where'],_0x18b2f7);}_0x82e5f7=_[_0x50ca('0xa4')]({},_0x82e5f7,_0x3798ca[_0x50ca('0xc6')]);return db[_0x50ca('0xce')][_0x50ca('0xa2')]({'where':_0x82e5f7['where']})[_0x50ca('0x3c')](function(_0x1b49cf){_0x1b85cc[_0x50ca('0xa2')]=_0x1b49cf;if(_0x3798ca[_0x50ca('0x44')]['includeAll']){_0x82e5f7[_0x50ca('0xc5')]=[{'all':!![]}];}return db[_0x50ca('0xce')]['findAll'](_0x82e5f7);})[_0x50ca('0x3c')](function(_0x4edf5c){_0x1b85cc['rows']=_0x4edf5c;return _0x1b85cc;});}})['then'](respondWithFilteredResult(_0xdc9aef,_0x82e5f7))[_0x50ca('0x3f')](handleError(_0xdc9aef,null));};exports[_0x50ca('0xd1')]=function(_0x482746,_0x19d30e,_0x4b74fc){return db[_0x50ca('0x38')][_0x50ca('0x67')]({'where':{'id':_0x482746[_0x50ca('0xc2')]['id']}})[_0x50ca('0x3c')](handleEntityNotFound(_0x19d30e,null))['then'](function(_0x32fe5c){if(_0x32fe5c){return _0x32fe5c[_0x50ca('0xd2')](_0x482746[_0x50ca('0xc8')][_0x50ca('0xcb')],_[_0x50ca('0xcc')](_0x482746[_0x50ca('0xc8')],['ids','id'])||{})[_0x50ca('0xd3')](function(){return db[_0x50ca('0xd4')][_0x50ca('0xd5')]({'attributes':['id','name',_0x50ca('0x52')],'where':{'id':_0x482746[_0x50ca('0xc8')][_0x50ca('0xcb')]}});})[_0x50ca('0x3c')](function(_0x28332c){socket[_0x50ca('0xd6')](_0x50ca('0xd7'),{'id':Number(_0x482746[_0x50ca('0xc2')]['id']),'tags':_0x28332c||[]});return{'id':Number(_0x482746[_0x50ca('0xc2')]['id']),'tags':_0x28332c||[]};});}})[_0x50ca('0x3c')](respondWithResult(_0x19d30e,null))[_0x50ca('0x3f')](handleError(_0x19d30e,null));};exports[_0x50ca('0xd8')]=function(_0x24b5e2,_0x5311c0,_0x3f4cf1){return db[_0x50ca('0x38')][_0x50ca('0x67')]({'where':{'id':_0x24b5e2['params']['id']}})[_0x50ca('0x3c')](handleEntityNotFound(_0x5311c0,null))[_0x50ca('0x3c')](function(_0x438fe2){if(_0x438fe2){return _0x438fe2['removeTags'](_0x24b5e2[_0x50ca('0x44')][_0x50ca('0xcb')]);}})[_0x50ca('0x3c')](respondWithStatusCode(_0x5311c0,null))['catch'](handleError(_0x5311c0,null));};exports[_0x50ca('0xd9')]=function(_0x341337,_0x47cbcf){var _0x3caee3=moment()[_0x50ca('0xda')]()[_0x50ca('0xa1')]();var _0x363054=path[_0x50ca('0xdb')](config['root'],_0x50ca('0xdc'),'files',_0x50ca('0xdd'));var _0x348fa6=path[_0x50ca('0xdb')](config[_0x50ca('0xde')],'server',_0x50ca('0xdf'),_0x50ca('0xe0'));var _0x3babe0=path[_0x50ca('0xdb')](_0x363054,_0x3caee3);var _0x511381=util[_0x50ca('0xd0')](_0x50ca('0xe1'),_0x341337[_0x50ca('0xc2')]['id'],_0x3caee3);var _0x5a331a=path[_0x50ca('0xdb')](_0x363054,_0x511381);var _0x5015cc=[];if(_0x341337[_0x50ca('0x44')][_0x50ca('0xe0')]){_0x5015cc[_0x50ca('0x37')]({'model':db[_0x50ca('0xe2')],'as':'Attachments','raw':!![]});}var _0xa2dcbb=[{'model':db[_0x50ca('0xce')],'as':_0x50ca('0xe3'),'attributes':['id',_0x50ca('0xc8'),_0x50ca('0x53'),'to','cc',_0x50ca('0xe4'),_0x50ca('0xe5'),_0x50ca('0x7f')],'where':{'secret':![]},'order':qs[_0x50ca('0x4d')]('id'),'include':_0x5015cc}];return db[_0x50ca('0x38')][_0x50ca('0x67')]({'where':{'id':_0x341337[_0x50ca('0xc2')]['id']},'include':_0xa2dcbb})[_0x50ca('0x3c')](handleEntityNotFound(_0x47cbcf,null))[_0x50ca('0x3c')](function(_0x57248b){if(_0x57248b&&_0x57248b[_0x50ca('0xe3')]){var _0x4c93e3=_0x57248b[_0x50ca('0xe6')]({'plain':!![]});fs[_0x50ca('0xe7')](_0x3babe0);return BPromise['each'](_0x4c93e3[_0x50ca('0xe3')],function(_0x864829,_0x2b45ba){var _0x16ee21={'from':_0x864829[_0x50ca('0x53')],'to':_0x864829['to'],'subject':_0x864829['subject'],'html':_0x864829['body'],'headers':{'Date':moment(_0x864829[_0x50ca('0x7f')])[_0x50ca('0xd0')]('ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ')},'attachments':[]};if(_0x864829['cc']){_0x16ee21[_0x50ca('0xe8')]['Cc']=_0x864829['cc'];}if(_0x864829['bcc']){_0x16ee21[_0x50ca('0xe8')][_0x50ca('0xe9')]=_0x864829[_0x50ca('0xe4')];}return new BPromise(function(_0x1f53a,_0x1ff0ed){if(_0x864829['Attachments']){for(var _0x1acf57=0x0;_0x1acf57<_0x864829['Attachments']['length'];_0x1acf57++){var _0x581859=_0x864829[_0x50ca('0xea')][_0x1acf57];var _0x37c644=path['join'](_0x348fa6,_0x581859[_0x50ca('0xeb')]);if(fs['existsSync'](_0x37c644)){_0x16ee21[_0x50ca('0xe0')]['push']({'name':_0x581859[_0x50ca('0x2f')],'contentType':_0x581859[_0x50ca('0x42')],'data':fs['readFileSync'](_0x37c644)});}}}emlformat[_0x50ca('0xec')](_0x16ee21,function(_0x258593,_0x145c21){if(_0x258593)return _0x1ff0ed(_0x258593);fs[_0x50ca('0xed')](path[_0x50ca('0xdb')](_0x3babe0,util['format'](_0x50ca('0xee'),_0x2b45ba)),_0x145c21);return _0x1f53a(_0x145c21);});});})['then'](function(){return new BPromise(function(_0x37eb53,_0x490ee4){zipdir(_0x3babe0,{'saveTo':_0x5a331a},function(_0x143541,_0x34ba98){if(_0x143541)return _0x490ee4(_0x143541);return _0x37eb53(_0x34ba98);});})[_0x50ca('0x3c')](function(){return new BPromise(function(_0x5d2325,_0xeed98d){rimraf(_0x3babe0,function(_0x39288e){if(_0x39288e)_0xeed98d(_0x39288e);return _0x5d2325();});});})['then'](function(){return _0x47cbcf[_0x50ca('0xd9')](_0x5a331a,_0x511381,function(_0x40d9b5){if(_0x40d9b5){console[_0x50ca('0xef')](_0x50ca('0xf0'),_0x40d9b5);}else{fs[_0x50ca('0xf1')](_0x5a331a);}});});});}else{return _0x47cbcf[_0x50ca('0x20')](0xc8);}})[_0x50ca('0x3f')](handleError(_0x47cbcf,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff