// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x8b88=['parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','isArray','tag','filter','replace','\x27\x27\x27\x27','isNumeric','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','Sequelize','QueryTypes','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','order','journey','i.MailAccountId\x20IS\x20NOT\x20NULL','getMailAccounts','toString','sequelize','keyBy','merge','a.key','Account.mandatoryDisposition','i.createdAt','i.updatedAt','i.closed','i.lastMsgAt','i.lastMsgDirection','i.subject','i.disposition','i.substatus','i.to','i.MailAccountId','i.UserId','Contact.firstName','c.lastName','Contact.lastName','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','all','rows','show','params','includeAll','include','create','body','describe','addMessage','ids','omit','getMessages','nolimit','sort','format','options','findAll','addTags','spread','emit','mailInteractionTags:save','removeTags','unix','join','root','server','files','tmp','attachments','Attachment','MailMessage','Messages','subject','get','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','bcc','Attachments','basename','existsSync','readFileSync','writeFileSync','download','log','err','unlinkSync','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','desk.js','querystring','html-to-text','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./mailInteraction.socket','register','sendStatus','status','json','count','offset','limit','set','apply','reject','save','update','then','destroy','end','Users','map','fullname','TagIds','Tags','split','push','MailInteraction','findOne','lastMsgText','trimStart','lastMsgBody','catch','rawAttributes','key','name','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','where','pick','select','field','tools_tags','u.id','u.fullname','from','user_has_mail_interactions','left_join','users','u.id\x20=\x20ui.UserId','mail_interactions','o.id\x20=\x20i.UserId','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','conditions','find','unreadMessages','value','`\x20=\x200','having','Contact','$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','type','text','Tag','forEach','union','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','start','some','compact','isEmpty','MailAccountId','i.MailAccountId\x20IN\x20?','concat','createdAt'];(function(_0x4264bf,_0x39db0f){var _0x515e5f=function(_0x130168){while(--_0x130168){_0x4264bf['push'](_0x4264bf['shift']());}};_0x515e5f(++_0x39db0f);}(_0x8b88,0x14f));var _0x88b8=function(_0x599c67,_0x581093){_0x599c67=_0x599c67-0x0;var _0x58306d=_0x8b88[_0x599c67];return _0x58306d;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x88b8('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x88b8('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x88b8('0x2'));var moment=require(_0x88b8('0x3'));var BPromise=require(_0x88b8('0x4'));var Mustache=require(_0x88b8('0x5'));var util=require(_0x88b8('0x6'));var path=require(_0x88b8('0x7'));var sox=require(_0x88b8('0x8'));var csv=require(_0x88b8('0x9'));var ejs=require(_0x88b8('0xa'));var fs=require('fs');var _=require(_0x88b8('0xb'));var squel=require(_0x88b8('0xc'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x88b8('0xd'));var toCsv=require(_0x88b8('0x9'));var querystring=require(_0x88b8('0xe'));var Papa=require('papaparse');var htmlToText=require(_0x88b8('0xf'));var Redis=require(_0x88b8('0x10'));var authService=require(_0x88b8('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x88b8('0x12'));var hardwareService=require(_0x88b8('0x13'));var logger=require(_0x88b8('0x14'))('api');var utils=require('../../config/utils');var config=require(_0x88b8('0x15'));var db=require(_0x88b8('0x16'))['db'];config[_0x88b8('0x17')]=_[_0x88b8('0x18')](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0x88b8('0x19'))(new Redis(config['redis']));require(_0x88b8('0x1a'))[_0x88b8('0x1b')](socket);function respondWithStatusCode(_0x499d1f,_0x797423){_0x797423=_0x797423||0xcc;return function(_0xf1b8b2){if(_0xf1b8b2){return _0x499d1f[_0x88b8('0x1c')](_0x797423);}return _0x499d1f['status'](_0x797423)['end']();};}function respondWithResult(_0x25b288,_0x5bc06b){_0x5bc06b=_0x5bc06b||0xc8;return function(_0x1469c1){if(_0x1469c1){return _0x25b288[_0x88b8('0x1d')](_0x5bc06b)[_0x88b8('0x1e')](_0x1469c1);}};}function respondWithFilteredResult(_0x52f363,_0x8005a2){return function(_0x36bd56){if(_0x36bd56){var _0xcbae35=_0x36bd56[_0x88b8('0x1f')],_0x24969f=_0x8005a2[_0x88b8('0x20')],_0x5854d7=_0x8005a2[_0x88b8('0x20')]+_0x8005a2[_0x88b8('0x21')],_0x416633;if(_0x5854d7>=_0xcbae35){_0x5854d7=_0xcbae35;_0x416633=0xc8;}else{_0x416633=0xce;}_0x52f363[_0x88b8('0x1d')](_0x416633);return _0x52f363[_0x88b8('0x22')]('Content-Range',_0x24969f+'-'+_0x5854d7+'/'+_0xcbae35)['json'](_0x36bd56);}return null;};}function patchUpdates(_0x182333){return function(_0x2ae25d){try{jsonpatch[_0x88b8('0x23')](_0x2ae25d,_0x182333,!![]);}catch(_0x158443){return BPromise[_0x88b8('0x24')](_0x158443);}return _0x2ae25d[_0x88b8('0x25')]();};}function saveUpdates(_0x4a1f5a,_0x22101a){return function(_0x1bd263){if(_0x1bd263){return _0x1bd263[_0x88b8('0x26')](_0x4a1f5a)[_0x88b8('0x27')](function(_0x46541c){return _0x46541c;});}return null;};}function removeEntity(_0x5a5377,_0x29d20c){return function(_0x5e6dde){if(_0x5e6dde){return _0x5e6dde[_0x88b8('0x28')]()[_0x88b8('0x27')](function(){_0x5a5377['status'](0xcc)[_0x88b8('0x29')]();});}};}function handleEntityNotFound(_0x4a90b2,_0x3bdb10){return function(_0x2c5a8a){if(!_0x2c5a8a){_0x4a90b2[_0x88b8('0x1c')](0x194);}return _0x2c5a8a;};}function handleError(_0x465a8e,_0x2cee15){_0x2cee15=_0x2cee15||0x1f4;return function(_0x1139b9){logger['error'](_0x1139b9['stack']);if(_0x1139b9['name']){delete _0x1139b9['name'];}_0x465a8e['status'](_0x2cee15)['send'](_0x1139b9);};}function getInteractionUsers(_0x44f8ce,_0x1cf641){return new BPromise(function(_0x21ff44,_0x5e9585){try{if(_0x1cf641[_0x44f8ce['id']]){_0x44f8ce[_0x88b8('0x2a')]=_[_0x88b8('0x2b')](_0x1cf641[_0x44f8ce['id']],function(_0x52510f){return{'id':_0x52510f['id'],'fullname':_0x52510f[_0x88b8('0x2c')]};});}}catch(_0x9efe4b){_0x5e9585(_0x9efe4b);}_0x21ff44(_0x44f8ce);});}function getInteractionTags(_0x16e96c,_0x165235){return new BPromise(function(_0x16a7c8,_0x25dadc){try{if(_0x16e96c[_0x88b8('0x2d')]){_0x16e96c[_0x88b8('0x2e')]=[];_0x16e96c[_0x88b8('0x2d')][_0x88b8('0x2f')](',')['forEach'](function(_0x39030c){_0x16e96c[_0x88b8('0x2e')][_0x88b8('0x30')](_0x165235[_0x39030c]);});}delete _0x16e96c[_0x88b8('0x2d')];}catch(_0x15b0e5){_0x25dadc(_0x15b0e5);}_0x16a7c8(_0x16e96c);});}function getLastMessageText(_0x1dbc94){return new BPromise(function(_0x2129ea,_0x18fd8e){return db[_0x88b8('0x31')][_0x88b8('0x32')]({'where':{'id':_0x1dbc94['id']},'attributes':['lastMsgBody',_0x88b8('0x33')],'raw':!![]})[_0x88b8('0x27')](function(_0x490dc2){if(!_0x490dc2[_0x88b8('0x33')]){_0x1dbc94[_0x88b8('0x33')]=_[_0x88b8('0x34')](htmlToText['fromString'](_0x490dc2[_0x88b8('0x35')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x1dbc94['lastMsgText']=_0x490dc2['lastMsgText'];}_0x2129ea(_0x1dbc94);})[_0x88b8('0x36')](function(_0x4a4e0d){_0x18fd8e(_0x4a4e0d);});});}function updateMailInteraction(_0x45b006,_0x7e2a8c,_0x506622,_0x36be10){return new BPromise(function(_0x2cd17f,_0x2c6077){return getInteractionUsers(_0x45b006,_0x506622)[_0x88b8('0x27')](function(_0x1081d1){return getInteractionTags(_0x1081d1,_0x7e2a8c);})['then'](function(_0x9291c2){if(_0x36be10){_0x2cd17f(getLastMessageText(_0x9291c2));}else{_0x2cd17f(_0x9291c2);}})[_0x88b8('0x36')](function(_0x1206fd){_0x2c6077(_0x1206fd);});});}exports['index']=function(_0x407351,_0x2cde67){var _0x349c56={},_0x2bfbcf={},_0x3ed77c={'count':0x0,'rows':[]};var _0x5247a6=_[_0x88b8('0x2b')](db['MailInteraction'][_0x88b8('0x37')],function(_0x33a3ab){return{'name':_0x33a3ab['fieldName'],'type':_0x33a3ab['type'][_0x88b8('0x38')]};});_0x2bfbcf['model']=_['map'](_0x5247a6,_0x88b8('0x39'));_0x2bfbcf[_0x88b8('0x3a')]=_[_0x88b8('0x3b')](_0x407351[_0x88b8('0x3a')]);_0x2bfbcf[_0x88b8('0x3c')]=_[_0x88b8('0x3d')](_0x2bfbcf[_0x88b8('0x3e')],_0x2bfbcf['query']);_0x349c56[_0x88b8('0x3f')]=_[_0x88b8('0x3d')](_0x2bfbcf[_0x88b8('0x3e')],qs[_0x88b8('0x40')](_0x407351['query'][_0x88b8('0x40')]));_0x349c56[_0x88b8('0x3f')]=_0x349c56[_0x88b8('0x3f')][_0x88b8('0x41')]?_0x349c56[_0x88b8('0x3f')]:_0x2bfbcf['model'];if(!_0x407351['query'][_0x88b8('0x42')]('nolimit')){_0x349c56[_0x88b8('0x21')]=qs[_0x88b8('0x21')](_0x407351[_0x88b8('0x3a')][_0x88b8('0x21')]);_0x349c56[_0x88b8('0x20')]=qs[_0x88b8('0x20')](_0x407351['query'][_0x88b8('0x20')]);}_0x349c56['order']=qs['sort'](_0x407351[_0x88b8('0x3a')]['sort']);_0x349c56[_0x88b8('0x43')]=qs[_0x88b8('0x3c')](_[_0x88b8('0x44')](_0x407351['query'],_0x2bfbcf[_0x88b8('0x3c')]));var _0x569c7a=[];var _0xde9620=squel[_0x88b8('0x45')]()[_0x88b8('0x46')]('id')['field'](_0x88b8('0x39'))[_0x88b8('0x46')]('color')['from'](_0x88b8('0x47'));var _0x1e2633=squel['select']()[_0x88b8('0x46')](_0x88b8('0x48'))[_0x88b8('0x46')](_0x88b8('0x49'))[_0x88b8('0x46')]('ui.MailInteractionId')[_0x88b8('0x4a')](_0x88b8('0x4b'),'ui')[_0x88b8('0x4c')](_0x88b8('0x4d'),'u',_0x88b8('0x4e'));var _0x2931a9=squel[_0x88b8('0x45')]()[_0x88b8('0x4a')](_0x88b8('0x4f'),'i')[_0x88b8('0x4c')]('cm_contacts','c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x88b8('0x4c')](_0x88b8('0x4d'),'o',_0x88b8('0x50'))[_0x88b8('0x4c')]('mail_accounts','a',_0x88b8('0x51'))[_0x88b8('0x4c')](_0x88b8('0x52'),'me',_0x88b8('0x53'))[_0x88b8('0x4c')](_0x88b8('0x54'),'it',_0x88b8('0x55'))['left_join'](_0x88b8('0x47'),'t',_0x88b8('0x56'));var _0x522158=squel[_0x88b8('0x57')]();var _0x491d57=[];var _0x2eb686=squel['expr']();var _0x1275da;if(_0x407351[_0x88b8('0x3a')][_0x88b8('0x58')]){_0x1275da=as['parseSearch'](_0x407351[_0x88b8('0x3a')][_0x88b8('0x58')]);var _0x4a1fc8=_0x1275da['sqlOperator'];for(var _0x54d69e=0x0;_0x54d69e<_0x1275da['conditions'][_0x88b8('0x41')];_0x54d69e++){var _0x873698=_0x1275da[_0x88b8('0x59')][_0x54d69e];var _0x3cb790='i';var _0x47672e=_[_0x88b8('0x5a')](_0x5247a6,[_0x88b8('0x39'),_0x873698[_0x88b8('0x46')]]);if(!_0x47672e){switch(_0x873698[_0x88b8('0x46')]){case _0x88b8('0x5b'):if(_0x873698[_0x88b8('0x5c')]==0x1){_0x2931a9['having']('`'+_0x873698[_0x88b8('0x46')]+_0x88b8('0x5d'));}else{_0x2931a9[_0x88b8('0x5e')]('`'+_0x873698[_0x88b8('0x46')]+'`\x20>\x200');}break;case _0x88b8('0x5f'):if(_0x873698['operator']===_0x88b8('0x60')){if(_0x873698[_0x88b8('0x5c')][_0x88b8('0x2f')]('\x20')[_0x88b8('0x41')]>0x1){_0x522158[_0x4a1fc8](_0x88b8('0x61'),qs[_0x88b8('0x62')](_0x873698['value']),null);}else{var _0x17da3f='%'+_0x873698[_0x88b8('0x5c')]+'%';_0x522158[_0x4a1fc8](_0x88b8('0x63'),_0x17da3f,_0x17da3f,_0x17da3f);}}else{_0x47672e=_['find'](_0x5247a6,[_0x88b8('0x39'),_0x88b8('0x64')]);_0x873698[_0x88b8('0x46')]='ContactId';_0x409480=as[_0x88b8('0x65')](_0x3cb790,_0x47672e[_0x88b8('0x66')],_0x873698);_0x522158[_0x4a1fc8](_0x409480[_0x88b8('0x67')],_0x409480['value']['start'],_0x409480[_0x88b8('0x5c')][_0x88b8('0x29')]);}break;case _0x88b8('0x68'):var _0x59ece9=_0x873698[_0x88b8('0x5c')][_0x88b8('0x2f')](',')[_0x88b8('0x2b')](function(_0x521f1d){return Number(_0x521f1d);});_0x59ece9[_0x88b8('0x69')](function(_0x2097ae){_0x2eb686['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x2097ae+',%');});_0x491d57=_[_0x88b8('0x6a')](_0x491d57,_0x59ece9);break;case'User':if(_0x873698['operator']==='$substring'){_0x522158[_0x4a1fc8](_0x88b8('0x6b'),'%'+_0x873698[_0x88b8('0x5c')]+'%',null);}else{_0x47672e=_[_0x88b8('0x5a')](_0x5247a6,[_0x88b8('0x39'),_0x88b8('0x6c')]);_0x873698[_0x88b8('0x46')]=_0x88b8('0x6c');_0x409480=as[_0x88b8('0x65')](_0x3cb790,_0x47672e[_0x88b8('0x66')],_0x873698);_0x522158[_0x4a1fc8](_0x409480[_0x88b8('0x67')],_0x409480[_0x88b8('0x5c')][_0x88b8('0x6d')],_0x409480[_0x88b8('0x5c')][_0x88b8('0x29')]);}break;case'plainBody':_0x409480=as[_0x88b8('0x65')]('me',null,_0x873698);_0x522158[_0x4a1fc8](_0x409480['text'],_0x409480['value'][_0x88b8('0x6d')],_0x409480[_0x88b8('0x5c')][_0x88b8('0x29')]);break;}}else{var _0x409480=as['buildExpression'](_0x3cb790,_0x47672e[_0x88b8('0x66')],_0x873698);_0x522158[_0x4a1fc8](_0x409480[_0x88b8('0x67')],_0x409480['value'][_0x88b8('0x6d')],_0x409480[_0x88b8('0x5c')][_0x88b8('0x29')]);}}}else{var _0x2f2c3d=_(_0x407351[_0x88b8('0x3a')])[_0x88b8('0x3b')]()[_0x88b8('0x2b')](function(_0x45bb62){return _[_0x88b8('0x6e')](_0x5247a6,[_0x88b8('0x39'),_0x45bb62])?_0x45bb62:undefined;})[_0x88b8('0x6f')]()['value']();if(!_[_0x88b8('0x70')](_0x2f2c3d)){_0x2f2c3d[_0x88b8('0x69')](function(_0x10c988){if(_0x10c988===_0x88b8('0x71')){_0x2931a9[_0x88b8('0x43')](_0x88b8('0x72'),[][_0x88b8('0x73')](_0x407351[_0x88b8('0x3a')][_0x10c988]));}else if(_0x10c988===_0x88b8('0x74')){var _0x1015e9=JSON[_0x88b8('0x75')](_0x407351[_0x88b8('0x3a')][_0x10c988])[_0x88b8('0x76')];var _0x264edf=JSON['parse'](_0x407351[_0x88b8('0x3a')][_0x10c988])[_0x88b8('0x77')];_0x2931a9['where'](_0x88b8('0x78'),_0x1015e9,_0x264edf);}else{if(_0x407351['query'][_0x10c988]===_0x88b8('0x79')){_0x2931a9[_0x88b8('0x43')]('i.'+_0x10c988+'\x20IS\x20NULL');}else{_0x2931a9[_0x88b8('0x43')]('i.'+_0x10c988+_0x88b8('0x7a'),_0x407351[_0x88b8('0x3a')][_0x10c988]);}}});}if(_0x407351[_0x88b8('0x3a')]['read']){if(_0x407351[_0x88b8('0x3a')][_0x88b8('0x7b')]==0x1){_0x2931a9[_0x88b8('0x5e')](_0x88b8('0x7c'));}else{_0x2931a9[_0x88b8('0x5e')](_0x88b8('0x7d'));}}if(_0x407351[_0x88b8('0x3a')]['tag']){_0x491d57=_[_0x88b8('0x7e')](_0x407351[_0x88b8('0x3a')][_0x88b8('0x7f')])?_0x407351[_0x88b8('0x3a')][_0x88b8('0x7f')]:new Array(_0x407351[_0x88b8('0x3a')]['tag']);_0x491d57[_0x88b8('0x69')](function(_0x4dc86e){_0x2eb686['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x4dc86e+',%');});}if(_0x407351[_0x88b8('0x3a')][_0x88b8('0x80')]){var _0x37310e=_0x407351[_0x88b8('0x3a')]['filter'][_0x88b8('0x81')]('\x5c','\x5c\x5c')['replace']('\x27\x27',_0x88b8('0x82'));if(qs[_0x88b8('0x83')](_0x37310e)){_0x522158['or']('i.id\x20LIKE\x20?',_0x37310e+'%');}else if(qs['isEmail'](_0x37310e)){_0x522158['or'](_0x88b8('0x84'),_0x37310e+'%');}else{_0x522158['or'](_0x88b8('0x85'),qs['getFullTextValue'](_0x37310e))['or'](_0x88b8('0x86'),qs[_0x88b8('0x62')](_0x37310e));}}}_0x2931a9['where'](_0x522158);_0x2931a9[_0x88b8('0x87')](_0x88b8('0x88'));var _0x20d934={'type':db[_0x88b8('0x89')][_0x88b8('0x8a')]['SELECT'],'raw':!![]};var _0x591acc=_0x2931a9[_0x88b8('0x8b')]();_0x591acc[_0x88b8('0x46')](_0x88b8('0x88'));_0x591acc['field'](_0x88b8('0x8c'),_0x88b8('0x5b'));if(_0x349c56[_0x88b8('0x8d')]){_0x349c56[_0x88b8('0x8d')]['forEach'](function(_0x27d249){_0x2931a9[_0x88b8('0x8d')]('i.'+_0x27d249[0x0],_0x27d249[0x1]==='DESC'?![]:!![]);});}if(!_[_0x88b8('0x70')](_0x491d57)){_0x2931a9['having'](_0x2eb686);_0x591acc[_0x88b8('0x43')]('t.id\x20IN\x20?',_0x491d57);}BPromise['resolve']()[_0x88b8('0x27')](function(){if(!_0x1275da){if(_0x407351['query']['MailAccountId']||_0x407351[_0x88b8('0x3a')][_0x88b8('0x8e')])return;_0x591acc[_0x88b8('0x43')](_0x88b8('0x8f'));_0x2931a9['where'](_0x88b8('0x8f'));return;}return _0x407351['user'][_0x88b8('0x90')]({'attributes':['id'],'raw':!![]})[_0x88b8('0x27')](function(_0x2eb078){if(_[_0x88b8('0x70')](_0x2eb078)){_0x591acc[_0x88b8('0x43')]('i.MailAccountId\x20IS\x20NULL');_0x2931a9['where']('i.MailAccountId\x20IS\x20NULL');}else{_0x591acc[_0x88b8('0x43')](_0x88b8('0x72'),_[_0x88b8('0x2b')](_0x2eb078,'id'));_0x2931a9[_0x88b8('0x43')](_0x88b8('0x72'),_['map'](_0x2eb078,'id'));}});})[_0x88b8('0x27')](function(){db['sequelize']['query'](_0x591acc[_0x88b8('0x91')](),_0x20d934)[_0x88b8('0x27')](function(_0x429b3f){_0x3ed77c[_0x88b8('0x1f')]=_0x429b3f[_0x88b8('0x41')];if(_0x3ed77c[_0x88b8('0x1f')]===0x0)return[];return db[_0x88b8('0x92')][_0x88b8('0x3a')](_0xde9620['toString'](),_0x20d934)[_0x88b8('0x27')](function(_0x7c530e){_0x569c7a=_[_0x88b8('0x93')](_0x7c530e,'id');_0x20d934=_[_0x88b8('0x94')](_0x20d934,{'model':db[_0x88b8('0x31')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x407351[_0x88b8('0x3a')][_0x88b8('0x40')]){_0x349c56[_0x88b8('0x3f')]['forEach'](function(_0x551c3d){_0x2931a9['field']('i.'+_0x551c3d);});}else{_0x2931a9['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');_0x2931a9[_0x88b8('0x46')](_0x88b8('0x95'),'Account.key');_0x2931a9[_0x88b8('0x46')]('a.mandatoryDisposition',_0x88b8('0x96'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0x88'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0x97'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0x98'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0x99'));_0x2931a9[_0x88b8('0x46')]('i.closedAt');_0x2931a9[_0x88b8('0x46')]('i.attach');_0x2931a9[_0x88b8('0x46')](_0x88b8('0x9a'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0x9b'));_0x2931a9['field'](_0x88b8('0x9c'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0x9d'));_0x2931a9['field'](_0x88b8('0x9e'));_0x2931a9['field'](_0x88b8('0x9f'));_0x2931a9[_0x88b8('0x46')]('i.ContactId');_0x2931a9[_0x88b8('0x46')](_0x88b8('0xa0'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0xa1'));_0x2931a9[_0x88b8('0x46')]('c.firstName',_0x88b8('0xa2'));_0x2931a9['field'](_0x88b8('0xa3'),_0x88b8('0xa4'));_0x2931a9[_0x88b8('0x46')]('c.email','Contact.email');_0x2931a9[_0x88b8('0x46')](_0x88b8('0xa5'),_0x88b8('0xa6'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0xa7'),_0x88b8('0xa8'));_0x2931a9[_0x88b8('0x46')](_0x88b8('0xa9'),_0x88b8('0xaa'));_0x2931a9[_0x88b8('0x46')]('o.fullname',_0x88b8('0xab'));_0x2931a9['field'](_0x88b8('0xac'),'Owner.internal');_0x2931a9[_0x88b8('0x46')](_0x88b8('0xad'),_0x88b8('0x2d'));}_0x2931a9[_0x88b8('0x21')](_0x349c56[_0x88b8('0x21')]);_0x2931a9[_0x88b8('0x20')](_0x349c56['offset']);return db[_0x88b8('0x92')][_0x88b8('0x3a')](_0x2931a9[_0x88b8('0x91')](),_0x20d934);})[_0x88b8('0x27')](function(_0x5b1c0a){_0x1e2633[_0x88b8('0x43')](_0x88b8('0xae'),_[_0x88b8('0x2b')](_0x5b1c0a,'id'));return db['sequelize']['query'](_0x1e2633[_0x88b8('0x91')](),_0x20d934)[_0x88b8('0x27')](function(_0x1aa6dd){var _0x239cc6=_[_0x88b8('0xaf')](_0x1aa6dd,_0x88b8('0xb0'));var _0x402502=[];return db[_0x88b8('0xb1')][_0x88b8('0x32')]({'attributes':[_0x88b8('0xb2')],'raw':!![]})[_0x88b8('0x27')](function(_0x4f9637){var _0x3192cd=_0x4f9637[_0x88b8('0xb2')];_0x5b1c0a[_0x88b8('0x69')](function(_0x129d92){_0x402502[_0x88b8('0x30')](updateMailInteraction(_0x129d92,_0x569c7a,_0x239cc6,_0x3192cd));});return BPromise[_0x88b8('0xb3')](_0x402502);});});});})[_0x88b8('0x27')](function(_0x423eae){_0x3ed77c[_0x88b8('0xb4')]=_0x423eae;return _0x3ed77c;})[_0x88b8('0x27')](respondWithFilteredResult(_0x2cde67,_0x349c56));})['catch'](handleError(_0x2cde67,null));};exports[_0x88b8('0xb5')]=function(_0x15c246,_0x4d47a6){var _0x3d8336={'raw':![],'where':{'id':_0x15c246[_0x88b8('0xb6')]['id']}},_0x523e37={};_0x523e37['model']=_[_0x88b8('0x3b')](db[_0x88b8('0x31')][_0x88b8('0x37')]);_0x523e37[_0x88b8('0x3a')]=_[_0x88b8('0x3b')](_0x15c246['query']);_0x523e37['filters']=_[_0x88b8('0x3d')](_0x523e37[_0x88b8('0x3e')],_0x523e37[_0x88b8('0x3a')]);_0x3d8336[_0x88b8('0x3f')]=_[_0x88b8('0x3d')](_0x523e37['model'],qs['fields'](_0x15c246[_0x88b8('0x3a')]['fields']));_0x3d8336[_0x88b8('0x3f')]=_0x3d8336[_0x88b8('0x3f')][_0x88b8('0x41')]?_0x3d8336[_0x88b8('0x3f')]:_0x523e37[_0x88b8('0x3e')];if(_0x15c246['query'][_0x88b8('0xb7')]){_0x3d8336[_0x88b8('0xb8')]=[{'all':!![]}];}_0x3d8336=_[_0x88b8('0x94')]({},_0x3d8336,_0x15c246['options']);return db[_0x88b8('0x31')][_0x88b8('0x5a')](_0x3d8336)[_0x88b8('0x27')](handleEntityNotFound(_0x4d47a6,null))[_0x88b8('0x27')](respondWithResult(_0x4d47a6,null))[_0x88b8('0x36')](handleError(_0x4d47a6,null));};exports[_0x88b8('0xb9')]=function(_0x3a375c,_0x17d9fc){return db[_0x88b8('0x31')][_0x88b8('0xb9')](_0x3a375c[_0x88b8('0xba')],{})['then'](respondWithResult(_0x17d9fc,0xc9))[_0x88b8('0x36')](handleError(_0x17d9fc,null));};exports[_0x88b8('0x26')]=function(_0x5c6399,_0x368de4){if(_0x5c6399[_0x88b8('0xba')]['id']){delete _0x5c6399[_0x88b8('0xba')]['id'];}return db['MailInteraction'][_0x88b8('0x5a')]({'where':{'id':_0x5c6399[_0x88b8('0xb6')]['id']}})['then'](handleEntityNotFound(_0x368de4,null))[_0x88b8('0x27')](saveUpdates(_0x5c6399['body'],null))[_0x88b8('0x27')](respondWithResult(_0x368de4,null))[_0x88b8('0x36')](handleError(_0x368de4,null));};exports['destroy']=function(_0x433475,_0x4e9085){return db[_0x88b8('0x31')][_0x88b8('0x5a')]({'where':{'id':_0x433475['params']['id']}})[_0x88b8('0x27')](handleEntityNotFound(_0x4e9085,null))[_0x88b8('0x27')](removeEntity(_0x4e9085,null))[_0x88b8('0x36')](handleError(_0x4e9085,null));};exports[_0x88b8('0xbb')]=function(_0x97d4ad,_0x5e22dd){return db[_0x88b8('0x31')][_0x88b8('0xbb')]()[_0x88b8('0x27')](respondWithResult(_0x5e22dd,null))[_0x88b8('0x36')](handleError(_0x5e22dd,null));};exports['addMessage']=function(_0x7ae4bf,_0x155e45,_0x2206fd){return db['MailMessage'][_0x88b8('0x5a')]({'where':{'id':_0x7ae4bf[_0x88b8('0xb6')]['id']}})[_0x88b8('0x27')](handleEntityNotFound(_0x155e45,null))['then'](function(_0x1a5dbd){if(_0x1a5dbd){return _0x1a5dbd[_0x88b8('0xbc')](_0x7ae4bf[_0x88b8('0xba')][_0x88b8('0xbd')],_[_0x88b8('0xbe')](_0x7ae4bf[_0x88b8('0xba')],[_0x88b8('0xbd'),'id'])||{});}})['then'](respondWithResult(_0x155e45,null))['catch'](handleError(_0x155e45,null));};exports[_0x88b8('0xbf')]=function(_0x2765e4,_0x4b3260,_0x194bf9){var _0x3b6ee9={'raw':![],'where':{}};var _0x282020={};var _0x1b38a2={'count':0x0,'rows':[]};return db[_0x88b8('0x31')]['findOne']({'where':{'id':_0x2765e4[_0x88b8('0xb6')]['id']}})[_0x88b8('0x27')](handleEntityNotFound(_0x4b3260,null))[_0x88b8('0x27')](function(_0x2b538e){if(_0x2b538e){_0x282020[_0x88b8('0x3e')]=_[_0x88b8('0x3b')](db['MailMessage'][_0x88b8('0x37')]);_0x282020['query']=_[_0x88b8('0x3b')](_0x2765e4[_0x88b8('0x3a')]);_0x282020[_0x88b8('0x3c')]=_['intersection'](_0x282020[_0x88b8('0x3e')],_0x282020[_0x88b8('0x3a')]);_0x3b6ee9['attributes']=_[_0x88b8('0x3d')](_0x282020[_0x88b8('0x3e')],qs[_0x88b8('0x40')](_0x2765e4[_0x88b8('0x3a')][_0x88b8('0x40')]));_0x3b6ee9[_0x88b8('0x3f')]=_0x3b6ee9[_0x88b8('0x3f')][_0x88b8('0x41')]?_0x3b6ee9['attributes']:_0x282020[_0x88b8('0x3e')];if(!_0x2765e4[_0x88b8('0x3a')][_0x88b8('0x42')](_0x88b8('0xc0'))){_0x3b6ee9[_0x88b8('0x21')]=qs[_0x88b8('0x21')](_0x2765e4[_0x88b8('0x3a')][_0x88b8('0x21')]);_0x3b6ee9[_0x88b8('0x20')]=qs[_0x88b8('0x20')](_0x2765e4['query'][_0x88b8('0x20')]);}_0x3b6ee9[_0x88b8('0x8d')]=qs['sort'](_0x2765e4['query'][_0x88b8('0xc1')]);_0x3b6ee9[_0x88b8('0x43')]=qs[_0x88b8('0x3c')](_[_0x88b8('0x44')](_0x2765e4[_0x88b8('0x3a')],_0x282020[_0x88b8('0x3c')]));_0x3b6ee9[_0x88b8('0x43')][_0x88b8('0xb0')]=_0x2b538e['id'];if(_0x2765e4[_0x88b8('0x3a')][_0x88b8('0x80')]){_0x3b6ee9[_0x88b8('0x43')]=_[_0x88b8('0x94')](_0x3b6ee9[_0x88b8('0x43')],{'$or':_[_0x88b8('0x2b')](_0x3b6ee9[_0x88b8('0x3f')],function(_0x5c69d1){var _0x4bf050={};_0x4bf050[_0x5c69d1]={'$like':'%'+_0x2765e4[_0x88b8('0x3a')]['filter']+'%'};return _0x4bf050;})});}if(_0x2765e4['query'][_0x88b8('0x76')]){var _0x4db4e6=_0x2765e4[_0x88b8('0x3a')][_0x88b8('0x76')][_0x88b8('0x2f')](',');var _0x203502={};_0x203502[_0x4db4e6[0x0]]={'$gte':moment(_0x4db4e6[0x1])[_0x88b8('0xc2')]('YYYY-MM-DD\x20HH:mm:ss')};_0x3b6ee9[_0x88b8('0x43')]=_[_0x88b8('0x94')](_0x3b6ee9[_0x88b8('0x43')],_0x203502);}_0x3b6ee9=_[_0x88b8('0x94')]({},_0x3b6ee9,_0x2765e4[_0x88b8('0xc3')]);return db['MailMessage']['count']({'where':_0x3b6ee9['where']})['then'](function(_0x5769ee){_0x1b38a2[_0x88b8('0x1f')]=_0x5769ee;if(_0x2765e4[_0x88b8('0x3a')][_0x88b8('0xb7')]){_0x3b6ee9[_0x88b8('0xb8')]=[{'all':!![]}];}return db['MailMessage'][_0x88b8('0xc4')](_0x3b6ee9);})['then'](function(_0x4dc139){_0x1b38a2['rows']=_0x4dc139;return _0x1b38a2;});}})[_0x88b8('0x27')](respondWithFilteredResult(_0x4b3260,_0x3b6ee9))[_0x88b8('0x36')](handleError(_0x4b3260,null));};exports[_0x88b8('0xc5')]=function(_0x1208ea,_0xd15b47,_0x4085f6){return db[_0x88b8('0x31')]['find']({'where':{'id':_0x1208ea[_0x88b8('0xb6')]['id']}})[_0x88b8('0x27')](handleEntityNotFound(_0xd15b47,null))[_0x88b8('0x27')](function(_0x26ff2d){if(_0x26ff2d){return _0x26ff2d['setTags'](_0x1208ea[_0x88b8('0xba')]['ids'],_['omit'](_0x1208ea[_0x88b8('0xba')],[_0x88b8('0xbd'),'id'])||{})[_0x88b8('0xc6')](function(){return db[_0x88b8('0x68')][_0x88b8('0xc4')]({'attributes':['id',_0x88b8('0x39'),'color'],'where':{'id':_0x1208ea['body'][_0x88b8('0xbd')]}});})['then'](function(_0x35e074){socket[_0x88b8('0xc7')](_0x88b8('0xc8'),{'id':Number(_0x1208ea['params']['id']),'tags':_0x35e074||[]});return{'id':Number(_0x1208ea[_0x88b8('0xb6')]['id']),'tags':_0x35e074||[]};});}})[_0x88b8('0x27')](respondWithResult(_0xd15b47,null))['catch'](handleError(_0xd15b47,null));};exports[_0x88b8('0xc9')]=function(_0x4a499f,_0x25cb3c,_0x5cc4e8){return db[_0x88b8('0x31')][_0x88b8('0x5a')]({'where':{'id':_0x4a499f[_0x88b8('0xb6')]['id']}})[_0x88b8('0x27')](handleEntityNotFound(_0x25cb3c,null))[_0x88b8('0x27')](function(_0x50e978){if(_0x50e978){return _0x50e978[_0x88b8('0xc9')](_0x4a499f[_0x88b8('0x3a')][_0x88b8('0xbd')]);}})[_0x88b8('0x27')](respondWithStatusCode(_0x25cb3c,null))[_0x88b8('0x36')](handleError(_0x25cb3c,null));};exports['download']=function(_0x542e66,_0x48b260){var _0x2e529e=moment()[_0x88b8('0xca')]()['toString']();var _0x28d2f1=path[_0x88b8('0xcb')](config[_0x88b8('0xcc')],_0x88b8('0xcd'),_0x88b8('0xce'),_0x88b8('0xcf'));var _0xcb3114=path['join'](config['root'],_0x88b8('0xcd'),_0x88b8('0xce'),'attachments');var _0x1cefd1=path['join'](_0x28d2f1,_0x2e529e);var _0x17f307=util[_0x88b8('0xc2')]('transcript-%d-%s.zip',_0x542e66[_0x88b8('0xb6')]['id'],_0x2e529e);var _0x3815d8=path[_0x88b8('0xcb')](_0x28d2f1,_0x17f307);var _0x4f997e=[];if(_0x542e66[_0x88b8('0x3a')][_0x88b8('0xd0')]){_0x4f997e[_0x88b8('0x30')]({'model':db[_0x88b8('0xd1')],'as':'Attachments','raw':!![]});}var _0x4e325a=[{'model':db[_0x88b8('0xd2')],'as':_0x88b8('0xd3'),'attributes':['id',_0x88b8('0xba'),_0x88b8('0x4a'),'to','cc','bcc',_0x88b8('0xd4'),_0x88b8('0x74')],'where':{'secret':![]},'order':qs[_0x88b8('0xc1')]('id'),'include':_0x4f997e}];return db['MailInteraction'][_0x88b8('0x5a')]({'where':{'id':_0x542e66[_0x88b8('0xb6')]['id']},'include':_0x4e325a})['then'](handleEntityNotFound(_0x48b260,null))['then'](function(_0xde1953){if(_0xde1953&&_0xde1953[_0x88b8('0xd3')]){var _0x2aae2b=_0xde1953[_0x88b8('0xd5')]({'plain':!![]});fs['mkdirSync'](_0x1cefd1);return BPromise['each'](_0x2aae2b[_0x88b8('0xd3')],function(_0x14f256,_0x53813d){var _0x28b040={'from':_0x14f256[_0x88b8('0x4a')],'to':_0x14f256['to'],'subject':_0x14f256[_0x88b8('0xd4')],'html':_0x14f256[_0x88b8('0xba')],'headers':{'Date':moment(_0x14f256['createdAt'])[_0x88b8('0xc2')](_0x88b8('0xd6'))},'attachments':[]};if(_0x14f256['cc']){_0x28b040[_0x88b8('0xd7')]['Cc']=_0x14f256['cc'];}if(_0x14f256[_0x88b8('0xd8')]){_0x28b040[_0x88b8('0xd7')]['Bcc']=_0x14f256['bcc'];}return new BPromise(function(_0x2bba78,_0x3d1093){if(_0x14f256['Attachments']){for(var _0x578777=0x0;_0x578777<_0x14f256[_0x88b8('0xd9')][_0x88b8('0x41')];_0x578777++){var _0x2a1aef=_0x14f256['Attachments'][_0x578777];var _0x1c9a71=path['join'](_0xcb3114,_0x2a1aef[_0x88b8('0xda')]);if(fs[_0x88b8('0xdb')](_0x1c9a71)){_0x28b040[_0x88b8('0xd0')][_0x88b8('0x30')]({'name':_0x2a1aef[_0x88b8('0x39')],'contentType':_0x2a1aef['type'],'data':fs[_0x88b8('0xdc')](_0x1c9a71)});}}}emlformat['build'](_0x28b040,function(_0x673a08,_0x2702ba){if(_0x673a08)return _0x3d1093(_0x673a08);fs[_0x88b8('0xdd')](path[_0x88b8('0xcb')](_0x1cefd1,util[_0x88b8('0xc2')]('message%d.eml',_0x53813d)),_0x2702ba);return _0x2bba78(_0x2702ba);});});})[_0x88b8('0x27')](function(){return new BPromise(function(_0x438c1b,_0x1721b7){zipdir(_0x1cefd1,{'saveTo':_0x3815d8},function(_0x116dbd,_0x1ec7b6){if(_0x116dbd)return _0x1721b7(_0x116dbd);return _0x438c1b(_0x1ec7b6);});})['then'](function(){return new BPromise(function(_0x550028,_0x4a65d8){rimraf(_0x1cefd1,function(_0x213ba0){if(_0x213ba0)_0x4a65d8(_0x213ba0);return _0x550028();});});})['then'](function(){return _0x48b260[_0x88b8('0xde')](_0x3815d8,_0x17f307,function(_0x28f8a4){if(_0x28f8a4){console[_0x88b8('0xdf')](_0x88b8('0xe0'),_0x28f8a4);}else{fs[_0x88b8('0xe1')](_0x3815d8);}});});});}else{return _0x48b260[_0x88b8('0x1c')](0xc8);}})[_0x88b8('0x36')](handleError(_0x48b260,null));};
\ No newline at end of file
+var _0x3d36=['redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','register','sendStatus','status','end','json','offset','limit','Content-Range','apply','reject','save','then','destroy','error','name','send','Users','map','TagIds','split','forEach','Tags','findOne','lastMsgBody','lastMsgText','trimStart','catch','index','MailInteraction','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','from','tools_tags','ui.MailInteractionId','user_has_mail_interactions','left_join','users','u.id\x20=\x20ui.UserId','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_messages','me.MailInteractionId\x20=\x20i.id','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','expr','search','parseSearch','conditions','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','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?','find','ContactId','start','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','$substring','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','text','plainBody','buildExpression','keys','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','\x27\x27\x27\x27','isNumeric','isEmail','c.email\x20LIKE\x20?','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','QueryTypes','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','t.id\x20IN\x20?','resolve','journey','i.MailAccountId\x20IS\x20NOT\x20NULL','user','getMailAccounts','i.MailAccountId\x20IS\x20NULL','toString','count','sequelize','keyBy','merge','a.key','Account.key','i.updatedAt','i.attach','i.subject','i.substatus','i.ContactId','i.MailAccountId','i.UserId','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','Contact.phone','c.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','enableEmailPreview','push','all','rows','params','fields','includeAll','include','options','create','body','describe','addMessage','MailMessage','ids','omit','getMessages','format','addTags','setTags','spread','emit','removeTags','download','unix','join','root','server','files','attachments','transcript-%d-%s.zip','Attachment','Attachments','Messages','bcc','subject','get','mkdirSync','each','headers','Bcc','basename','existsSync','readFileSync','build','writeFileSync','message%d.eml','log','err','html-pdf','eml-format','rimraf','zip-dir','request-promise','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb'];(function(_0x5a94ac,_0x57438d){var _0x1d6ff4=function(_0x3c0112){while(--_0x3c0112){_0x5a94ac['push'](_0x5a94ac['shift']());}};_0x1d6ff4(++_0x57438d);}(_0x3d36,0xd1));var _0x63d3=function(_0x29d94e,_0xf386d6){_0x29d94e=_0x29d94e-0x0;var _0x106237=_0x3d36[_0x29d94e];return _0x106237;};'use strict';var pdf=require(_0x63d3('0x0'));var emlformat=require(_0x63d3('0x1'));var rimraf=require(_0x63d3('0x2'));var zipdir=require(_0x63d3('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x63d3('0x4'));var moment=require('moment');var BPromise=require(_0x63d3('0x5'));var Mustache=require(_0x63d3('0x6'));var util=require(_0x63d3('0x7'));var path=require('path');var sox=require(_0x63d3('0x8'));var csv=require(_0x63d3('0x9'));var ejs=require(_0x63d3('0xa'));var fs=require('fs');var _=require(_0x63d3('0xb'));var squel=require(_0x63d3('0xc'));var crypto=require(_0x63d3('0xd'));var jsforce=require(_0x63d3('0xe'));var deskjs=require(_0x63d3('0xf'));var toCsv=require(_0x63d3('0x9'));var querystring=require(_0x63d3('0x10'));var Papa=require(_0x63d3('0x11'));var htmlToText=require('html-to-text');var Redis=require(_0x63d3('0x12'));var authService=require(_0x63d3('0x13'));var qs=require(_0x63d3('0x14'));var as=require(_0x63d3('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x63d3('0x16'))(_0x63d3('0x17'));var utils=require(_0x63d3('0x18'));var config=require(_0x63d3('0x19'));var db=require(_0x63d3('0x1a'))['db'];config[_0x63d3('0x1b')]=_[_0x63d3('0x1c')](config[_0x63d3('0x1b')],{'host':_0x63d3('0x1d'),'port':0x18eb});var socket=require(_0x63d3('0x1e'))(new Redis(config[_0x63d3('0x1b')]));require(_0x63d3('0x1f'))[_0x63d3('0x20')](socket);function respondWithStatusCode(_0x467c73,_0x53206d){_0x53206d=_0x53206d||0xcc;return function(_0x1099f5){if(_0x1099f5){return _0x467c73[_0x63d3('0x21')](_0x53206d);}return _0x467c73[_0x63d3('0x22')](_0x53206d)[_0x63d3('0x23')]();};}function respondWithResult(_0x4a42db,_0x58b11e){_0x58b11e=_0x58b11e||0xc8;return function(_0x1bb2a3){if(_0x1bb2a3){return _0x4a42db['status'](_0x58b11e)[_0x63d3('0x24')](_0x1bb2a3);}};}function respondWithFilteredResult(_0x14ecce,_0x12a121){return function(_0x3de355){if(_0x3de355){var _0x53aae6=_0x3de355['count'],_0x2d2cd3=_0x12a121[_0x63d3('0x25')],_0xf129fa=_0x12a121[_0x63d3('0x25')]+_0x12a121[_0x63d3('0x26')],_0x3d0e76;if(_0xf129fa>=_0x53aae6){_0xf129fa=_0x53aae6;_0x3d0e76=0xc8;}else{_0x3d0e76=0xce;}_0x14ecce[_0x63d3('0x22')](_0x3d0e76);return _0x14ecce['set'](_0x63d3('0x27'),_0x2d2cd3+'-'+_0xf129fa+'/'+_0x53aae6)['json'](_0x3de355);}return null;};}function patchUpdates(_0x4b817d){return function(_0x4b8314){try{jsonpatch[_0x63d3('0x28')](_0x4b8314,_0x4b817d,!![]);}catch(_0x4aceda){return BPromise[_0x63d3('0x29')](_0x4aceda);}return _0x4b8314[_0x63d3('0x2a')]();};}function saveUpdates(_0x4e5e0e,_0x4fdf38){return function(_0xe7b94b){if(_0xe7b94b){return _0xe7b94b['update'](_0x4e5e0e)[_0x63d3('0x2b')](function(_0xad9c70){return _0xad9c70;});}return null;};}function removeEntity(_0x49fefa,_0x184ebb){return function(_0x43e542){if(_0x43e542){return _0x43e542[_0x63d3('0x2c')]()['then'](function(){_0x49fefa[_0x63d3('0x22')](0xcc)[_0x63d3('0x23')]();});}};}function handleEntityNotFound(_0x116fe7,_0x35b4d2){return function(_0x3b95d1){if(!_0x3b95d1){_0x116fe7[_0x63d3('0x21')](0x194);}return _0x3b95d1;};}function handleError(_0x40877b,_0x16b73b){_0x16b73b=_0x16b73b||0x1f4;return function(_0x79a825){logger[_0x63d3('0x2d')](_0x79a825['stack']);if(_0x79a825[_0x63d3('0x2e')]){delete _0x79a825[_0x63d3('0x2e')];}_0x40877b[_0x63d3('0x22')](_0x16b73b)[_0x63d3('0x2f')](_0x79a825);};}function getInteractionUsers(_0x475318,_0x1f3dc5){return new BPromise(function(_0x281f26,_0x503254){try{if(_0x1f3dc5[_0x475318['id']]){_0x475318[_0x63d3('0x30')]=_[_0x63d3('0x31')](_0x1f3dc5[_0x475318['id']],function(_0x46aec2){return{'id':_0x46aec2['id'],'fullname':_0x46aec2['fullname']};});}}catch(_0x33abf7){_0x503254(_0x33abf7);}_0x281f26(_0x475318);});}function getInteractionTags(_0x371fe5,_0x28a9ad){return new BPromise(function(_0xdb88a9,_0x46793f){try{if(_0x371fe5[_0x63d3('0x32')]){_0x371fe5['Tags']=[];_0x371fe5['TagIds'][_0x63d3('0x33')](',')[_0x63d3('0x34')](function(_0x5ea76b){_0x371fe5[_0x63d3('0x35')]['push'](_0x28a9ad[_0x5ea76b]);});}delete _0x371fe5[_0x63d3('0x32')];}catch(_0x2259a9){_0x46793f(_0x2259a9);}_0xdb88a9(_0x371fe5);});}function getLastMessageText(_0x2a9fc){return new BPromise(function(_0x13788d,_0x2ad8e5){return db['MailInteraction'][_0x63d3('0x36')]({'where':{'id':_0x2a9fc['id']},'attributes':[_0x63d3('0x37'),_0x63d3('0x38')],'raw':!![]})['then'](function(_0xbd1c1a){if(!_0xbd1c1a[_0x63d3('0x38')]){_0x2a9fc[_0x63d3('0x38')]=_[_0x63d3('0x39')](htmlToText['fromString'](_0xbd1c1a['lastMsgBody'],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x2a9fc[_0x63d3('0x38')]=_0xbd1c1a[_0x63d3('0x38')];}_0x13788d(_0x2a9fc);})[_0x63d3('0x3a')](function(_0x3cc0c2){_0x2ad8e5(_0x3cc0c2);});});}function updateMailInteraction(_0x1151b5,_0x27751b,_0xaa3602,_0x47de5e){return new BPromise(function(_0xe5db88,_0x23c816){return getInteractionUsers(_0x1151b5,_0xaa3602)[_0x63d3('0x2b')](function(_0x31e4be){return getInteractionTags(_0x31e4be,_0x27751b);})[_0x63d3('0x2b')](function(_0x263a8c){if(_0x47de5e){_0xe5db88(getLastMessageText(_0x263a8c));}else{_0xe5db88(_0x263a8c);}})['catch'](function(_0x2bc70e){_0x23c816(_0x2bc70e);});});}exports[_0x63d3('0x3b')]=function(_0x34c3c3,_0x273af8){var _0x3c3cbd={},_0x4a40c1={},_0x4395c4={'count':0x0,'rows':[]};var _0x525b99=_[_0x63d3('0x31')](db[_0x63d3('0x3c')][_0x63d3('0x3d')],function(_0x40dcdb){return{'name':_0x40dcdb[_0x63d3('0x3e')],'type':_0x40dcdb[_0x63d3('0x3f')][_0x63d3('0x40')]};});_0x4a40c1[_0x63d3('0x41')]=_['map'](_0x525b99,_0x63d3('0x2e'));_0x4a40c1[_0x63d3('0x42')]=_['keys'](_0x34c3c3[_0x63d3('0x42')]);_0x4a40c1[_0x63d3('0x43')]=_[_0x63d3('0x44')](_0x4a40c1['model'],_0x4a40c1['query']);_0x3c3cbd[_0x63d3('0x45')]=_[_0x63d3('0x44')](_0x4a40c1['model'],qs['fields'](_0x34c3c3[_0x63d3('0x42')]['fields']));_0x3c3cbd['attributes']=_0x3c3cbd[_0x63d3('0x45')][_0x63d3('0x46')]?_0x3c3cbd[_0x63d3('0x45')]:_0x4a40c1[_0x63d3('0x41')];if(!_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x47')](_0x63d3('0x48'))){_0x3c3cbd[_0x63d3('0x26')]=qs['limit'](_0x34c3c3['query'][_0x63d3('0x26')]);_0x3c3cbd[_0x63d3('0x25')]=qs[_0x63d3('0x25')](_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x25')]);}_0x3c3cbd[_0x63d3('0x49')]=qs[_0x63d3('0x4a')](_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x4a')]);_0x3c3cbd[_0x63d3('0x4b')]=qs[_0x63d3('0x43')](_[_0x63d3('0x4c')](_0x34c3c3[_0x63d3('0x42')],_0x4a40c1['filters']));var _0x181ffe=[];var _0x5a612d=squel[_0x63d3('0x4d')]()['field']('id')[_0x63d3('0x4e')](_0x63d3('0x2e'))[_0x63d3('0x4e')](_0x63d3('0x4f'))[_0x63d3('0x50')](_0x63d3('0x51'));var _0x41e986=squel['select']()['field']('u.id')[_0x63d3('0x4e')]('u.fullname')[_0x63d3('0x4e')](_0x63d3('0x52'))[_0x63d3('0x50')](_0x63d3('0x53'),'ui')[_0x63d3('0x54')](_0x63d3('0x55'),'u',_0x63d3('0x56'));var _0x4febbc=squel[_0x63d3('0x4d')]()[_0x63d3('0x50')]('mail_interactions','i')[_0x63d3('0x54')]('cm_contacts','c',_0x63d3('0x57'))[_0x63d3('0x54')]('users','o',_0x63d3('0x58'))[_0x63d3('0x54')]('mail_accounts','a','a.id\x20=\x20i.MailAccountId')[_0x63d3('0x54')](_0x63d3('0x59'),'me',_0x63d3('0x5a'))[_0x63d3('0x54')](_0x63d3('0x5b'),'it',_0x63d3('0x5c'))['left_join'](_0x63d3('0x51'),'t','t.id\x20=\x20it.TagId');var _0xb91aa6=squel[_0x63d3('0x5d')]();var _0x173ee5=[];var _0x1a5315=squel[_0x63d3('0x5d')]();var _0x5cb29f;if(_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x5e')]){_0x5cb29f=as[_0x63d3('0x5f')](_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x5e')]);var _0x1bc7ea=_0x5cb29f['sqlOperator'];for(var _0x11d312=0x0;_0x11d312<_0x5cb29f[_0x63d3('0x60')][_0x63d3('0x46')];_0x11d312++){var _0x4cbf59=_0x5cb29f[_0x63d3('0x60')][_0x11d312];var _0x3ae17d='i';var _0x23ff01=_['find'](_0x525b99,['name',_0x4cbf59[_0x63d3('0x4e')]]);if(!_0x23ff01){switch(_0x4cbf59['field']){case _0x63d3('0x61'):if(_0x4cbf59[_0x63d3('0x62')]==0x1){_0x4febbc[_0x63d3('0x63')]('`'+_0x4cbf59[_0x63d3('0x4e')]+_0x63d3('0x64'));}else{_0x4febbc['having']('`'+_0x4cbf59[_0x63d3('0x4e')]+_0x63d3('0x65'));}break;case _0x63d3('0x66'):if(_0x4cbf59[_0x63d3('0x67')]==='$substring'){if(_0x4cbf59[_0x63d3('0x62')]['split']('\x20')[_0x63d3('0x46')]>0x1){_0xb91aa6[_0x1bc7ea](_0x63d3('0x68'),qs[_0x63d3('0x69')](_0x4cbf59[_0x63d3('0x62')]),null);}else{var _0x4b8994='%'+_0x4cbf59[_0x63d3('0x62')]+'%';_0xb91aa6[_0x1bc7ea](_0x63d3('0x6a'),_0x4b8994,_0x4b8994,_0x4b8994);}}else{_0x23ff01=_[_0x63d3('0x6b')](_0x525b99,[_0x63d3('0x2e'),'ContactId']);_0x4cbf59['field']=_0x63d3('0x6c');_0x341707=as['buildExpression'](_0x3ae17d,_0x23ff01['type'],_0x4cbf59);_0xb91aa6[_0x1bc7ea](_0x341707['text'],_0x341707[_0x63d3('0x62')][_0x63d3('0x6d')],_0x341707[_0x63d3('0x62')][_0x63d3('0x23')]);}break;case'Tag':var _0xc20b93=_0x4cbf59[_0x63d3('0x62')]['split'](',')['map'](function(_0x317768){return Number(_0x317768);});_0xc20b93['forEach'](function(_0x5d2dac){_0x1a5315['or'](_0x63d3('0x6e'),'%,'+_0x5d2dac+',%');});_0x173ee5=_[_0x63d3('0x6f')](_0x173ee5,_0xc20b93);break;case _0x63d3('0x70'):if(_0x4cbf59[_0x63d3('0x67')]===_0x63d3('0x71')){_0xb91aa6[_0x1bc7ea](_0x63d3('0x72'),'%'+_0x4cbf59[_0x63d3('0x62')]+'%',null);}else{_0x23ff01=_[_0x63d3('0x6b')](_0x525b99,[_0x63d3('0x2e'),'UserId']);_0x4cbf59[_0x63d3('0x4e')]=_0x63d3('0x73');_0x341707=as['buildExpression'](_0x3ae17d,_0x23ff01['type'],_0x4cbf59);_0xb91aa6[_0x1bc7ea](_0x341707[_0x63d3('0x74')],_0x341707[_0x63d3('0x62')]['start'],_0x341707['value'][_0x63d3('0x23')]);}break;case _0x63d3('0x75'):_0x341707=as[_0x63d3('0x76')]('me',null,_0x4cbf59);_0xb91aa6[_0x1bc7ea](_0x341707[_0x63d3('0x74')],_0x341707['value'][_0x63d3('0x6d')],_0x341707[_0x63d3('0x62')][_0x63d3('0x23')]);break;}}else{var _0x341707=as[_0x63d3('0x76')](_0x3ae17d,_0x23ff01[_0x63d3('0x3f')],_0x4cbf59);_0xb91aa6[_0x1bc7ea](_0x341707['text'],_0x341707[_0x63d3('0x62')]['start'],_0x341707[_0x63d3('0x62')][_0x63d3('0x23')]);}}}else{var _0x8d7ae4=_(_0x34c3c3[_0x63d3('0x42')])[_0x63d3('0x77')]()[_0x63d3('0x31')](function(_0x1c8ff7){return _[_0x63d3('0x78')](_0x525b99,[_0x63d3('0x2e'),_0x1c8ff7])?_0x1c8ff7:undefined;})['compact']()[_0x63d3('0x62')]();if(!_[_0x63d3('0x79')](_0x8d7ae4)){_0x8d7ae4['forEach'](function(_0x2b5205){if(_0x2b5205===_0x63d3('0x7a')){_0x4febbc[_0x63d3('0x4b')](_0x63d3('0x7b'),[][_0x63d3('0x7c')](_0x34c3c3[_0x63d3('0x42')][_0x2b5205]));}else if(_0x2b5205===_0x63d3('0x7d')){var _0x284f52=JSON[_0x63d3('0x7e')](_0x34c3c3[_0x63d3('0x42')][_0x2b5205])[_0x63d3('0x7f')];var _0x3ef3db=JSON[_0x63d3('0x7e')](_0x34c3c3[_0x63d3('0x42')][_0x2b5205])['$lte'];_0x4febbc[_0x63d3('0x4b')](_0x63d3('0x80'),_0x284f52,_0x3ef3db);}else{if(_0x34c3c3[_0x63d3('0x42')][_0x2b5205]===_0x63d3('0x81')){_0x4febbc[_0x63d3('0x4b')]('i.'+_0x2b5205+'\x20IS\x20NULL');}else{_0x4febbc[_0x63d3('0x4b')]('i.'+_0x2b5205+_0x63d3('0x82'),_0x34c3c3[_0x63d3('0x42')][_0x2b5205]);}}});}if(_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x83')]){if(_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x83')]==0x1){_0x4febbc[_0x63d3('0x63')](_0x63d3('0x84'));}else{_0x4febbc[_0x63d3('0x63')](_0x63d3('0x85'));}}if(_0x34c3c3[_0x63d3('0x42')]['tag']){_0x173ee5=_[_0x63d3('0x86')](_0x34c3c3[_0x63d3('0x42')]['tag'])?_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x87')]:new Array(_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x87')]);_0x173ee5[_0x63d3('0x34')](function(_0x30db08){_0x1a5315['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x30db08+',%');});}if(_0x34c3c3[_0x63d3('0x42')]['filter']){var _0x2abfbf=_0x34c3c3['query'][_0x63d3('0x88')][_0x63d3('0x89')]('\x5c','\x5c\x5c')[_0x63d3('0x89')]('\x27\x27',_0x63d3('0x8a'));if(qs[_0x63d3('0x8b')](_0x2abfbf)){_0xb91aa6['or']('i.id\x20LIKE\x20?',_0x2abfbf+'%');}else if(qs[_0x63d3('0x8c')](_0x2abfbf)){_0xb91aa6['or'](_0x63d3('0x8d'),_0x2abfbf+'%');}else{_0xb91aa6['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x63d3('0x69')](_0x2abfbf))['or'](_0x63d3('0x8e'),qs[_0x63d3('0x69')](_0x2abfbf));}}}_0x4febbc[_0x63d3('0x4b')](_0xb91aa6);_0x4febbc[_0x63d3('0x8f')](_0x63d3('0x90'));var _0x2d8a4b={'type':db['Sequelize'][_0x63d3('0x91')][_0x63d3('0x92')],'raw':!![]};var _0x161644=_0x4febbc[_0x63d3('0x93')]();_0x161644[_0x63d3('0x4e')](_0x63d3('0x90'));_0x161644['field'](_0x63d3('0x94'),'unreadMessages');if(_0x3c3cbd['order']){_0x3c3cbd[_0x63d3('0x49')]['forEach'](function(_0x513194){_0x4febbc[_0x63d3('0x49')]('i.'+_0x513194[0x0],_0x513194[0x1]==='DESC'?![]:!![]);});}if(!_[_0x63d3('0x79')](_0x173ee5)){_0x4febbc[_0x63d3('0x63')](_0x1a5315);_0x161644['where'](_0x63d3('0x95'),_0x173ee5);}BPromise[_0x63d3('0x96')]()[_0x63d3('0x2b')](function(){if(!_0x5cb29f){if(_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x7a')]||_0x34c3c3[_0x63d3('0x42')][_0x63d3('0x97')])return;_0x161644[_0x63d3('0x4b')]('i.MailAccountId\x20IS\x20NOT\x20NULL');_0x4febbc[_0x63d3('0x4b')](_0x63d3('0x98'));return;}return _0x34c3c3[_0x63d3('0x99')][_0x63d3('0x9a')]({'attributes':['id'],'raw':!![]})[_0x63d3('0x2b')](function(_0x5c7ef7){if(_[_0x63d3('0x79')](_0x5c7ef7)){_0x161644[_0x63d3('0x4b')](_0x63d3('0x9b'));_0x4febbc[_0x63d3('0x4b')](_0x63d3('0x9b'));}else{_0x161644[_0x63d3('0x4b')](_0x63d3('0x7b'),_[_0x63d3('0x31')](_0x5c7ef7,'id'));_0x4febbc['where'](_0x63d3('0x7b'),_[_0x63d3('0x31')](_0x5c7ef7,'id'));}});})['then'](function(){db['sequelize'][_0x63d3('0x42')](_0x161644[_0x63d3('0x9c')](),_0x2d8a4b)[_0x63d3('0x2b')](function(_0x12779a){_0x4395c4[_0x63d3('0x9d')]=_0x12779a[_0x63d3('0x46')];if(_0x4395c4[_0x63d3('0x9d')]===0x0)return[];return db[_0x63d3('0x9e')]['query'](_0x5a612d[_0x63d3('0x9c')](),_0x2d8a4b)[_0x63d3('0x2b')](function(_0x2ff2a4){_0x181ffe=_[_0x63d3('0x9f')](_0x2ff2a4,'id');_0x2d8a4b=_[_0x63d3('0xa0')](_0x2d8a4b,{'model':db[_0x63d3('0x3c')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x34c3c3[_0x63d3('0x42')]['fields']){_0x3c3cbd[_0x63d3('0x45')]['forEach'](function(_0x2edb8e){_0x4febbc[_0x63d3('0x4e')]('i.'+_0x2edb8e);});}else{_0x4febbc['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');_0x4febbc['field'](_0x63d3('0xa1'),_0x63d3('0xa2'));_0x4febbc[_0x63d3('0x4e')]('a.mandatoryDisposition','Account.mandatoryDisposition');_0x4febbc[_0x63d3('0x4e')](_0x63d3('0x90'));_0x4febbc[_0x63d3('0x4e')]('i.createdAt');_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xa3'));_0x4febbc[_0x63d3('0x4e')]('i.closed');_0x4febbc[_0x63d3('0x4e')]('i.closedAt');_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xa4'));_0x4febbc['field']('i.lastMsgAt');_0x4febbc[_0x63d3('0x4e')]('i.lastMsgDirection');_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xa5'));_0x4febbc['field']('i.disposition');_0x4febbc['field'](_0x63d3('0xa6'));_0x4febbc['field']('i.to');_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xa7'));_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xa8'));_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xa9'));_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xaa'),_0x63d3('0xab'));_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xac'),_0x63d3('0xad'));_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xae'),_0x63d3('0xaf'));_0x4febbc[_0x63d3('0x4e')]('c.phone',_0x63d3('0xb0'));_0x4febbc['field'](_0x63d3('0xb1'),'Contact.mobile');_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xb2'),_0x63d3('0xb3'));_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xb4'),_0x63d3('0xb5'));_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xb6'),'Owner.internal');_0x4febbc[_0x63d3('0x4e')](_0x63d3('0xb7'),'TagIds');}_0x4febbc['limit'](_0x3c3cbd[_0x63d3('0x26')]);_0x4febbc[_0x63d3('0x25')](_0x3c3cbd[_0x63d3('0x25')]);return db['sequelize'][_0x63d3('0x42')](_0x4febbc[_0x63d3('0x9c')](),_0x2d8a4b);})[_0x63d3('0x2b')](function(_0x5d234a){_0x41e986[_0x63d3('0x4b')](_0x63d3('0xb8'),_[_0x63d3('0x31')](_0x5d234a,'id'));return db['sequelize']['query'](_0x41e986[_0x63d3('0x9c')](),_0x2d8a4b)[_0x63d3('0x2b')](function(_0x2ad545){var _0x149348=_[_0x63d3('0xb9')](_0x2ad545,_0x63d3('0xba'));var _0x22044d=[];return db['Setting']['findOne']({'attributes':[_0x63d3('0xbb')],'raw':!![]})[_0x63d3('0x2b')](function(_0x1d7a68){var _0x390363=_0x1d7a68[_0x63d3('0xbb')];_0x5d234a[_0x63d3('0x34')](function(_0x9bd65f){_0x22044d[_0x63d3('0xbc')](updateMailInteraction(_0x9bd65f,_0x181ffe,_0x149348,_0x390363));});return BPromise[_0x63d3('0xbd')](_0x22044d);});});});})[_0x63d3('0x2b')](function(_0x18f93c){_0x4395c4[_0x63d3('0xbe')]=_0x18f93c;return _0x4395c4;})[_0x63d3('0x2b')](respondWithFilteredResult(_0x273af8,_0x3c3cbd));})[_0x63d3('0x3a')](handleError(_0x273af8,null));};exports['show']=function(_0x428e70,_0x24f4ef){var _0x3bc3c3={'raw':![],'where':{'id':_0x428e70[_0x63d3('0xbf')]['id']}},_0x417007={};_0x417007[_0x63d3('0x41')]=_[_0x63d3('0x77')](db[_0x63d3('0x3c')][_0x63d3('0x3d')]);_0x417007[_0x63d3('0x42')]=_[_0x63d3('0x77')](_0x428e70[_0x63d3('0x42')]);_0x417007[_0x63d3('0x43')]=_[_0x63d3('0x44')](_0x417007[_0x63d3('0x41')],_0x417007['query']);_0x3bc3c3['attributes']=_[_0x63d3('0x44')](_0x417007[_0x63d3('0x41')],qs[_0x63d3('0xc0')](_0x428e70['query'][_0x63d3('0xc0')]));_0x3bc3c3[_0x63d3('0x45')]=_0x3bc3c3['attributes']['length']?_0x3bc3c3[_0x63d3('0x45')]:_0x417007[_0x63d3('0x41')];if(_0x428e70['query'][_0x63d3('0xc1')]){_0x3bc3c3[_0x63d3('0xc2')]=[{'all':!![]}];}_0x3bc3c3=_[_0x63d3('0xa0')]({},_0x3bc3c3,_0x428e70[_0x63d3('0xc3')]);return db['MailInteraction']['find'](_0x3bc3c3)[_0x63d3('0x2b')](handleEntityNotFound(_0x24f4ef,null))[_0x63d3('0x2b')](respondWithResult(_0x24f4ef,null))[_0x63d3('0x3a')](handleError(_0x24f4ef,null));};exports[_0x63d3('0xc4')]=function(_0x238ddb,_0x189fcd){return db['MailInteraction'][_0x63d3('0xc4')](_0x238ddb['body'],{})[_0x63d3('0x2b')](respondWithResult(_0x189fcd,0xc9))[_0x63d3('0x3a')](handleError(_0x189fcd,null));};exports['update']=function(_0x152c9d,_0xd3a649){if(_0x152c9d[_0x63d3('0xc5')]['id']){delete _0x152c9d['body']['id'];}return db[_0x63d3('0x3c')][_0x63d3('0x6b')]({'where':{'id':_0x152c9d[_0x63d3('0xbf')]['id']}})[_0x63d3('0x2b')](handleEntityNotFound(_0xd3a649,null))[_0x63d3('0x2b')](saveUpdates(_0x152c9d[_0x63d3('0xc5')],null))[_0x63d3('0x2b')](respondWithResult(_0xd3a649,null))['catch'](handleError(_0xd3a649,null));};exports[_0x63d3('0x2c')]=function(_0x475fbb,_0x42515d){return db[_0x63d3('0x3c')]['find']({'where':{'id':_0x475fbb[_0x63d3('0xbf')]['id']}})[_0x63d3('0x2b')](handleEntityNotFound(_0x42515d,null))[_0x63d3('0x2b')](removeEntity(_0x42515d,null))[_0x63d3('0x3a')](handleError(_0x42515d,null));};exports[_0x63d3('0xc6')]=function(_0x92cd38,_0x5c6be5){return db[_0x63d3('0x3c')]['describe']()['then'](respondWithResult(_0x5c6be5,null))['catch'](handleError(_0x5c6be5,null));};exports[_0x63d3('0xc7')]=function(_0x20f582,_0x342c6b,_0x4c31ef){return db[_0x63d3('0xc8')]['find']({'where':{'id':_0x20f582[_0x63d3('0xbf')]['id']}})[_0x63d3('0x2b')](handleEntityNotFound(_0x342c6b,null))[_0x63d3('0x2b')](function(_0xc992e2){if(_0xc992e2){return _0xc992e2[_0x63d3('0xc7')](_0x20f582[_0x63d3('0xc5')][_0x63d3('0xc9')],_[_0x63d3('0xca')](_0x20f582['body'],['ids','id'])||{});}})[_0x63d3('0x2b')](respondWithResult(_0x342c6b,null))[_0x63d3('0x3a')](handleError(_0x342c6b,null));};exports[_0x63d3('0xcb')]=function(_0x3de4a7,_0x5b079e,_0x305d9c){var _0x59f91b={'raw':![],'where':{}};var _0x128a74={};var _0x5ef331={'count':0x0,'rows':[]};return db[_0x63d3('0x3c')][_0x63d3('0x36')]({'where':{'id':_0x3de4a7[_0x63d3('0xbf')]['id']}})[_0x63d3('0x2b')](handleEntityNotFound(_0x5b079e,null))['then'](function(_0x820b1b){if(_0x820b1b){_0x128a74[_0x63d3('0x41')]=_[_0x63d3('0x77')](db['MailMessage']['rawAttributes']);_0x128a74[_0x63d3('0x42')]=_[_0x63d3('0x77')](_0x3de4a7[_0x63d3('0x42')]);_0x128a74[_0x63d3('0x43')]=_[_0x63d3('0x44')](_0x128a74[_0x63d3('0x41')],_0x128a74[_0x63d3('0x42')]);_0x59f91b[_0x63d3('0x45')]=_['intersection'](_0x128a74[_0x63d3('0x41')],qs['fields'](_0x3de4a7[_0x63d3('0x42')][_0x63d3('0xc0')]));_0x59f91b[_0x63d3('0x45')]=_0x59f91b[_0x63d3('0x45')]['length']?_0x59f91b[_0x63d3('0x45')]:_0x128a74[_0x63d3('0x41')];if(!_0x3de4a7[_0x63d3('0x42')][_0x63d3('0x47')]('nolimit')){_0x59f91b[_0x63d3('0x26')]=qs[_0x63d3('0x26')](_0x3de4a7['query'][_0x63d3('0x26')]);_0x59f91b[_0x63d3('0x25')]=qs['offset'](_0x3de4a7[_0x63d3('0x42')][_0x63d3('0x25')]);}_0x59f91b[_0x63d3('0x49')]=qs[_0x63d3('0x4a')](_0x3de4a7[_0x63d3('0x42')][_0x63d3('0x4a')]);_0x59f91b['where']=qs[_0x63d3('0x43')](_['pick'](_0x3de4a7[_0x63d3('0x42')],_0x128a74['filters']));_0x59f91b[_0x63d3('0x4b')][_0x63d3('0xba')]=_0x820b1b['id'];if(_0x3de4a7[_0x63d3('0x42')][_0x63d3('0x88')]){_0x59f91b[_0x63d3('0x4b')]=_[_0x63d3('0xa0')](_0x59f91b[_0x63d3('0x4b')],{'$or':_[_0x63d3('0x31')](_0x59f91b[_0x63d3('0x45')],function(_0x3deb88){var _0x3ce012={};_0x3ce012[_0x3deb88]={'$like':'%'+_0x3de4a7[_0x63d3('0x42')][_0x63d3('0x88')]+'%'};return _0x3ce012;})});}if(_0x3de4a7[_0x63d3('0x42')][_0x63d3('0x7f')]){var _0x197adf=_0x3de4a7['query'][_0x63d3('0x7f')]['split'](',');var _0x461d51={};_0x461d51[_0x197adf[0x0]]={'$gte':moment(_0x197adf[0x1])[_0x63d3('0xcc')]('YYYY-MM-DD\x20HH:mm:ss')};_0x59f91b['where']=_[_0x63d3('0xa0')](_0x59f91b[_0x63d3('0x4b')],_0x461d51);}_0x59f91b=_[_0x63d3('0xa0')]({},_0x59f91b,_0x3de4a7[_0x63d3('0xc3')]);return db[_0x63d3('0xc8')][_0x63d3('0x9d')]({'where':_0x59f91b[_0x63d3('0x4b')]})[_0x63d3('0x2b')](function(_0x291d08){_0x5ef331['count']=_0x291d08;if(_0x3de4a7[_0x63d3('0x42')][_0x63d3('0xc1')]){_0x59f91b['include']=[{'all':!![]}];}return db[_0x63d3('0xc8')]['findAll'](_0x59f91b);})[_0x63d3('0x2b')](function(_0x2d660d){_0x5ef331[_0x63d3('0xbe')]=_0x2d660d;return _0x5ef331;});}})['then'](respondWithFilteredResult(_0x5b079e,_0x59f91b))[_0x63d3('0x3a')](handleError(_0x5b079e,null));};exports[_0x63d3('0xcd')]=function(_0x2a8c89,_0x138dcf,_0x29ec26){return db[_0x63d3('0x3c')][_0x63d3('0x6b')]({'where':{'id':_0x2a8c89[_0x63d3('0xbf')]['id']}})[_0x63d3('0x2b')](handleEntityNotFound(_0x138dcf,null))[_0x63d3('0x2b')](function(_0x55fb4c){if(_0x55fb4c){return _0x55fb4c[_0x63d3('0xce')](_0x2a8c89[_0x63d3('0xc5')][_0x63d3('0xc9')],_[_0x63d3('0xca')](_0x2a8c89[_0x63d3('0xc5')],[_0x63d3('0xc9'),'id'])||{})[_0x63d3('0xcf')](function(){return db['Tag']['findAll']({'attributes':['id',_0x63d3('0x2e'),'color'],'where':{'id':_0x2a8c89[_0x63d3('0xc5')][_0x63d3('0xc9')]}});})[_0x63d3('0x2b')](function(_0x434185){socket[_0x63d3('0xd0')]('mailInteractionTags:save',{'id':Number(_0x2a8c89[_0x63d3('0xbf')]['id']),'tags':_0x434185||[]});return{'id':Number(_0x2a8c89[_0x63d3('0xbf')]['id']),'tags':_0x434185||[]};});}})['then'](respondWithResult(_0x138dcf,null))[_0x63d3('0x3a')](handleError(_0x138dcf,null));};exports[_0x63d3('0xd1')]=function(_0x1a7ef8,_0x4b8f4e,_0x5d1ea6){return db[_0x63d3('0x3c')]['find']({'where':{'id':_0x1a7ef8['params']['id']}})[_0x63d3('0x2b')](handleEntityNotFound(_0x4b8f4e,null))['then'](function(_0x41defc){if(_0x41defc){return _0x41defc[_0x63d3('0xd1')](_0x1a7ef8[_0x63d3('0x42')][_0x63d3('0xc9')]);}})[_0x63d3('0x2b')](respondWithStatusCode(_0x4b8f4e,null))[_0x63d3('0x3a')](handleError(_0x4b8f4e,null));};exports[_0x63d3('0xd2')]=function(_0x208ef3,_0x1588c0){var _0x1c1fac=moment()[_0x63d3('0xd3')]()[_0x63d3('0x9c')]();var _0x7dc1cc=path[_0x63d3('0xd4')](config[_0x63d3('0xd5')],_0x63d3('0xd6'),_0x63d3('0xd7'),'tmp');var _0x36fe3d=path[_0x63d3('0xd4')](config['root'],_0x63d3('0xd6'),_0x63d3('0xd7'),_0x63d3('0xd8'));var _0x17b3c7=path[_0x63d3('0xd4')](_0x7dc1cc,_0x1c1fac);var _0x30c155=util['format'](_0x63d3('0xd9'),_0x208ef3['params']['id'],_0x1c1fac);var _0x396cc0=path[_0x63d3('0xd4')](_0x7dc1cc,_0x30c155);var _0x38352e=[];if(_0x208ef3['query']['attachments']){_0x38352e[_0x63d3('0xbc')]({'model':db[_0x63d3('0xda')],'as':_0x63d3('0xdb'),'raw':!![]});}var _0x1ea00b=[{'model':db[_0x63d3('0xc8')],'as':_0x63d3('0xdc'),'attributes':['id','body',_0x63d3('0x50'),'to','cc',_0x63d3('0xdd'),_0x63d3('0xde'),_0x63d3('0x7d')],'where':{'secret':![]},'order':qs['sort']('id'),'include':_0x38352e}];return db[_0x63d3('0x3c')]['find']({'where':{'id':_0x208ef3['params']['id']},'include':_0x1ea00b})[_0x63d3('0x2b')](handleEntityNotFound(_0x1588c0,null))[_0x63d3('0x2b')](function(_0x6991ed){if(_0x6991ed&&_0x6991ed[_0x63d3('0xdc')]){var _0x3e1afb=_0x6991ed[_0x63d3('0xdf')]({'plain':!![]});fs[_0x63d3('0xe0')](_0x17b3c7);return BPromise[_0x63d3('0xe1')](_0x3e1afb['Messages'],function(_0x1f1d5f,_0x13aafd){var _0x597813={'from':_0x1f1d5f[_0x63d3('0x50')],'to':_0x1f1d5f['to'],'subject':_0x1f1d5f[_0x63d3('0xde')],'html':_0x1f1d5f[_0x63d3('0xc5')],'headers':{'Date':moment(_0x1f1d5f[_0x63d3('0x7d')])[_0x63d3('0xcc')]('ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ')},'attachments':[]};if(_0x1f1d5f['cc']){_0x597813['headers']['Cc']=_0x1f1d5f['cc'];}if(_0x1f1d5f[_0x63d3('0xdd')]){_0x597813[_0x63d3('0xe2')][_0x63d3('0xe3')]=_0x1f1d5f[_0x63d3('0xdd')];}return new BPromise(function(_0x3e671c,_0x41742b){if(_0x1f1d5f[_0x63d3('0xdb')]){for(var _0x27543c=0x0;_0x27543c<_0x1f1d5f[_0x63d3('0xdb')][_0x63d3('0x46')];_0x27543c++){var _0x1f2d2c=_0x1f1d5f['Attachments'][_0x27543c];var _0x1d8f89=path[_0x63d3('0xd4')](_0x36fe3d,_0x1f2d2c[_0x63d3('0xe4')]);if(fs[_0x63d3('0xe5')](_0x1d8f89)){_0x597813[_0x63d3('0xd8')][_0x63d3('0xbc')]({'name':_0x1f2d2c[_0x63d3('0x2e')],'contentType':_0x1f2d2c['type'],'data':fs[_0x63d3('0xe6')](_0x1d8f89)});}}}emlformat[_0x63d3('0xe7')](_0x597813,function(_0x572e3d,_0x324bb1){if(_0x572e3d)return _0x41742b(_0x572e3d);fs[_0x63d3('0xe8')](path[_0x63d3('0xd4')](_0x17b3c7,util[_0x63d3('0xcc')](_0x63d3('0xe9'),_0x13aafd)),_0x324bb1);return _0x3e671c(_0x324bb1);});});})[_0x63d3('0x2b')](function(){return new BPromise(function(_0x349496,_0x5a4bc1){zipdir(_0x17b3c7,{'saveTo':_0x396cc0},function(_0x8f9a0a,_0xf91757){if(_0x8f9a0a)return _0x5a4bc1(_0x8f9a0a);return _0x349496(_0xf91757);});})['then'](function(){return new BPromise(function(_0x3ab6d6,_0x5c8a16){rimraf(_0x17b3c7,function(_0x1e4cb2){if(_0x1e4cb2)_0x5c8a16(_0x1e4cb2);return _0x3ab6d6();});});})['then'](function(){return _0x1588c0['download'](_0x396cc0,_0x30c155,function(_0x1bb272){if(_0x1bb272){console[_0x63d3('0xea')](_0x63d3('0xeb'),_0x1bb272);}else{fs['unlinkSync'](_0x396cc0);}});});});}else{return _0x1588c0[_0x63d3('0x21')](0xc8);}})[_0x63d3('0x3a')](handleError(_0x1588c0,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff