// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4b20=['redis','defaults','localhost','socket.io-emitter','register','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','save','update','destroy','then','error','stack','name','send','Users','map','fullname','Tags','split','forEach','push','MailInteraction','lastMsgBody','lastMsgText','trimStart','fromString','catch','index','rawAttributes','fieldName','type','key','model','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','where','pick','select','field','color','from','tools_tags','u.id','u.fullname','ui.MailInteractionId','left_join','users','u.id\x20=\x20ui.UserId','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','a.id\x20=\x20i.MailAccountId','me.MailInteractionId\x20=\x20i.id','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','expr','search','parseSearch','sqlOperator','conditions','unreadMessages','value','having','`\x20=\x200','Contact','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','ContactId','buildExpression','text','start','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','UserId','plainBody','keys','isEmpty','MailAccountId','parse','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','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','Sequelize','QueryTypes','SELECT','order','DESC','t.id\x20IN\x20?','resolve','journey','i.MailAccountId\x20IS\x20NOT\x20NULL','getMailAccounts','i.MailAccountId\x20IS\x20NULL','i.MailAccountId\x20IN\x20?','toString','keyBy','merge','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','i.createdAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.substatus','i.ContactId','i.UserId','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','Contact.phone','c.mobile','Contact.mobile','Contact.fax','o.fullname','Owner.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','ui.MailInteractionId\x20IN\x20?','sequelize','groupBy','Setting','enableEmailPreview','rows','show','params','includeAll','options','find','create','body','describe','addMessage','MailMessage','ids','omit','getMessages','MailInteractionId','filter','$gte','format','YYYY-MM-DD\x20HH:mm:ss','include','findAll','setTags','spread','emit','mailInteractionTags:save','removeTags','download','unix','root','server','files','tmp','join','attachments','transcript-%d-%s.zip','Attachments','bcc','subject','createdAt','get','mkdirSync','each','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','basename','existsSync','readFileSync','writeFileSync','message%d.eml','log','err','zip-dir','fast-json-patch','bluebird','mustache','util','sox','ejs','lodash','crypto','to-csv','papaparse','html-to-text','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb'];(function(_0x4166f6,_0x16207d){var _0x34df0d=function(_0x52eddf){while(--_0x52eddf){_0x4166f6['push'](_0x4166f6['shift']());}};_0x34df0d(++_0x16207d);}(_0x4b20,0xdb));var _0x04b2=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x4b20[_0x3dd15e];return _0x231fd0;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x04b2('0x0'));var jsonpatch=require(_0x04b2('0x1'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x04b2('0x2'));var Mustache=require(_0x04b2('0x3'));var util=require(_0x04b2('0x4'));var path=require('path');var sox=require(_0x04b2('0x5'));var csv=require('to-csv');var ejs=require(_0x04b2('0x6'));var fs=require('fs');var _=require(_0x04b2('0x7'));var squel=require('squel');var crypto=require(_0x04b2('0x8'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x04b2('0x9'));var querystring=require('querystring');var Papa=require(_0x04b2('0xa'));var htmlToText=require(_0x04b2('0xb'));var Redis=require(_0x04b2('0xc'));var authService=require(_0x04b2('0xd'));var qs=require(_0x04b2('0xe'));var as=require(_0x04b2('0xf'));var hardwareService=require(_0x04b2('0x10'));var logger=require(_0x04b2('0x11'))('api');var utils=require(_0x04b2('0x12'));var config=require(_0x04b2('0x13'));var db=require(_0x04b2('0x14'))['db'];config[_0x04b2('0x15')]=_[_0x04b2('0x16')](config[_0x04b2('0x15')],{'host':_0x04b2('0x17'),'port':0x18eb});var socket=require(_0x04b2('0x18'))(new Redis(config[_0x04b2('0x15')]));require('./mailInteraction.socket')[_0x04b2('0x19')](socket);function respondWithStatusCode(_0x52fdc7,_0x294046){_0x294046=_0x294046||0xcc;return function(_0x2fb5d3){if(_0x2fb5d3){return _0x52fdc7[_0x04b2('0x1a')](_0x294046);}return _0x52fdc7['status'](_0x294046)[_0x04b2('0x1b')]();};}function respondWithResult(_0x4ec02d,_0x14caac){_0x14caac=_0x14caac||0xc8;return function(_0x3fede8){if(_0x3fede8){return _0x4ec02d[_0x04b2('0x1c')](_0x14caac)[_0x04b2('0x1d')](_0x3fede8);}};}function respondWithFilteredResult(_0x108ce2,_0x1ab749){return function(_0x8c5794){if(_0x8c5794){var _0x17e956=_0x8c5794[_0x04b2('0x1e')],_0x43d4c4=_0x1ab749['offset'],_0x476820=_0x1ab749[_0x04b2('0x1f')]+_0x1ab749[_0x04b2('0x20')],_0x44cca8;if(_0x476820>=_0x17e956){_0x476820=_0x17e956;_0x44cca8=0xc8;}else{_0x44cca8=0xce;}_0x108ce2[_0x04b2('0x1c')](_0x44cca8);return _0x108ce2[_0x04b2('0x21')](_0x04b2('0x22'),_0x43d4c4+'-'+_0x476820+'/'+_0x17e956)['json'](_0x8c5794);}return null;};}function patchUpdates(_0x139212){return function(_0x3e6f09){try{jsonpatch[_0x04b2('0x23')](_0x3e6f09,_0x139212,!![]);}catch(_0x4f4ceb){return BPromise['reject'](_0x4f4ceb);}return _0x3e6f09[_0x04b2('0x24')]();};}function saveUpdates(_0x3def72,_0x1e52ce){return function(_0x2e7e7e){if(_0x2e7e7e){return _0x2e7e7e[_0x04b2('0x25')](_0x3def72)['then'](function(_0x4d7aeb){return _0x4d7aeb;});}return null;};}function removeEntity(_0x8ca15a,_0x4a316d){return function(_0x3a6aeb){if(_0x3a6aeb){return _0x3a6aeb[_0x04b2('0x26')]()[_0x04b2('0x27')](function(){_0x8ca15a[_0x04b2('0x1c')](0xcc)[_0x04b2('0x1b')]();});}};}function handleEntityNotFound(_0x3003cb,_0x13689a){return function(_0x444a60){if(!_0x444a60){_0x3003cb[_0x04b2('0x1a')](0x194);}return _0x444a60;};}function handleError(_0x3e1a91,_0x3f6a61){_0x3f6a61=_0x3f6a61||0x1f4;return function(_0x30daa0){logger[_0x04b2('0x28')](_0x30daa0[_0x04b2('0x29')]);if(_0x30daa0[_0x04b2('0x2a')]){delete _0x30daa0[_0x04b2('0x2a')];}_0x3e1a91['status'](_0x3f6a61)[_0x04b2('0x2b')](_0x30daa0);};}function getInteractionUsers(_0x1438f7,_0x26a745){return new BPromise(function(_0x364ba5,_0x4a8d65){try{if(_0x26a745[_0x1438f7['id']]){_0x1438f7[_0x04b2('0x2c')]=_[_0x04b2('0x2d')](_0x26a745[_0x1438f7['id']],function(_0x3cd478){return{'id':_0x3cd478['id'],'fullname':_0x3cd478[_0x04b2('0x2e')]};});}}catch(_0x7a9df5){_0x4a8d65(_0x7a9df5);}_0x364ba5(_0x1438f7);});}function getInteractionTags(_0x3bb2d0,_0xdd957d){return new BPromise(function(_0x40e976,_0x54695c){try{if(_0x3bb2d0['TagIds']){_0x3bb2d0[_0x04b2('0x2f')]=[];_0x3bb2d0['TagIds'][_0x04b2('0x30')](',')[_0x04b2('0x31')](function(_0x1df0ee){_0x3bb2d0[_0x04b2('0x2f')][_0x04b2('0x32')](_0xdd957d[_0x1df0ee]);});}delete _0x3bb2d0['TagIds'];}catch(_0x34963b){_0x54695c(_0x34963b);}_0x40e976(_0x3bb2d0);});}function getLastMessageText(_0x5b2158){return new BPromise(function(_0x163f7f,_0x12d3ee){return db[_0x04b2('0x33')]['findOne']({'where':{'id':_0x5b2158['id']},'attributes':[_0x04b2('0x34'),_0x04b2('0x35')],'raw':!![]})[_0x04b2('0x27')](function(_0x20f577){if(!_0x20f577[_0x04b2('0x35')]){_0x5b2158[_0x04b2('0x35')]=_[_0x04b2('0x36')](htmlToText[_0x04b2('0x37')](_0x20f577['lastMsgBody'],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x5b2158[_0x04b2('0x35')]=_0x20f577[_0x04b2('0x35')];}_0x163f7f(_0x5b2158);})[_0x04b2('0x38')](function(_0xf53af2){_0x12d3ee(_0xf53af2);});});}function updateMailInteraction(_0x3879ae,_0x40f4f3,_0x4328c8,_0x30e7d7){return new BPromise(function(_0x5c5635,_0x55b637){return getInteractionUsers(_0x3879ae,_0x4328c8)['then'](function(_0x5bcff5){return getInteractionTags(_0x5bcff5,_0x40f4f3);})['then'](function(_0x53fbd2){if(_0x30e7d7){_0x5c5635(getLastMessageText(_0x53fbd2));}else{_0x5c5635(_0x53fbd2);}})['catch'](function(_0x8f0ba1){_0x55b637(_0x8f0ba1);});});}exports[_0x04b2('0x39')]=function(_0x507cce,_0x5ea011){var _0x331d5c={},_0x17686c={},_0x390dd6={'count':0x0,'rows':[]};var _0x290c77=_['map'](db[_0x04b2('0x33')][_0x04b2('0x3a')],function(_0x11ea6f){return{'name':_0x11ea6f[_0x04b2('0x3b')],'type':_0x11ea6f[_0x04b2('0x3c')][_0x04b2('0x3d')]};});_0x17686c[_0x04b2('0x3e')]=_['map'](_0x290c77,_0x04b2('0x2a'));_0x17686c[_0x04b2('0x3f')]=_['keys'](_0x507cce['query']);_0x17686c[_0x04b2('0x40')]=_[_0x04b2('0x41')](_0x17686c['model'],_0x17686c[_0x04b2('0x3f')]);_0x331d5c['attributes']=_['intersection'](_0x17686c[_0x04b2('0x3e')],qs[_0x04b2('0x42')](_0x507cce[_0x04b2('0x3f')]['fields']));_0x331d5c['attributes']=_0x331d5c[_0x04b2('0x43')][_0x04b2('0x44')]?_0x331d5c[_0x04b2('0x43')]:_0x17686c[_0x04b2('0x3e')];if(!_0x507cce[_0x04b2('0x3f')][_0x04b2('0x45')](_0x04b2('0x46'))){_0x331d5c[_0x04b2('0x20')]=qs[_0x04b2('0x20')](_0x507cce['query']['limit']);_0x331d5c['offset']=qs[_0x04b2('0x1f')](_0x507cce[_0x04b2('0x3f')]['offset']);}_0x331d5c['order']=qs[_0x04b2('0x47')](_0x507cce[_0x04b2('0x3f')][_0x04b2('0x47')]);_0x331d5c[_0x04b2('0x48')]=qs[_0x04b2('0x40')](_[_0x04b2('0x49')](_0x507cce[_0x04b2('0x3f')],_0x17686c[_0x04b2('0x40')]));var _0x4285ad=[];var _0x53cef2=squel[_0x04b2('0x4a')]()[_0x04b2('0x4b')]('id')['field'](_0x04b2('0x2a'))[_0x04b2('0x4b')](_0x04b2('0x4c'))[_0x04b2('0x4d')](_0x04b2('0x4e'));var _0x2bcae2=squel[_0x04b2('0x4a')]()[_0x04b2('0x4b')](_0x04b2('0x4f'))['field'](_0x04b2('0x50'))[_0x04b2('0x4b')](_0x04b2('0x51'))['from']('user_has_mail_interactions','ui')[_0x04b2('0x52')](_0x04b2('0x53'),'u',_0x04b2('0x54'));var _0x5179a1=squel['select']()[_0x04b2('0x4d')]('mail_interactions','i')[_0x04b2('0x52')](_0x04b2('0x55'),'c',_0x04b2('0x56'))[_0x04b2('0x52')](_0x04b2('0x53'),'o',_0x04b2('0x57'))[_0x04b2('0x52')]('mail_accounts','a',_0x04b2('0x58'))[_0x04b2('0x52')]('mail_messages','me',_0x04b2('0x59'))[_0x04b2('0x52')](_0x04b2('0x5a'),'it',_0x04b2('0x5b'))['left_join'](_0x04b2('0x4e'),'t','t.id\x20=\x20it.TagId');var _0x24709c=squel[_0x04b2('0x5c')]();var _0x133f82=[];var _0xa8c71=squel[_0x04b2('0x5c')]();var _0x3486d8;if(_0x507cce[_0x04b2('0x3f')][_0x04b2('0x5d')]){_0x3486d8=as[_0x04b2('0x5e')](_0x507cce[_0x04b2('0x3f')][_0x04b2('0x5d')]);var _0x44bc64=_0x3486d8[_0x04b2('0x5f')];for(var _0x29e081=0x0;_0x29e081<_0x3486d8[_0x04b2('0x60')][_0x04b2('0x44')];_0x29e081++){var _0x5bd2e5=_0x3486d8[_0x04b2('0x60')][_0x29e081];var _0xf1cdb6='i';var _0x57cd1c=_['find'](_0x290c77,[_0x04b2('0x2a'),_0x5bd2e5[_0x04b2('0x4b')]]);if(!_0x57cd1c){switch(_0x5bd2e5[_0x04b2('0x4b')]){case _0x04b2('0x61'):if(_0x5bd2e5[_0x04b2('0x62')]==0x1){_0x5179a1[_0x04b2('0x63')]('`'+_0x5bd2e5[_0x04b2('0x4b')]+_0x04b2('0x64'));}else{_0x5179a1[_0x04b2('0x63')]('`'+_0x5bd2e5[_0x04b2('0x4b')]+'`\x20>\x200');}break;case _0x04b2('0x65'):if(_0x5bd2e5[_0x04b2('0x66')]===_0x04b2('0x67')){if(_0x5bd2e5['value'][_0x04b2('0x30')]('\x20')[_0x04b2('0x44')]>0x1){_0x24709c[_0x44bc64](_0x04b2('0x68'),qs[_0x04b2('0x69')](_0x5bd2e5[_0x04b2('0x62')]),null);}else{var _0x74860f='%'+_0x5bd2e5['value']+'%';_0x24709c[_0x44bc64]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x74860f,_0x74860f,_0x74860f);}}else{_0x57cd1c=_['find'](_0x290c77,[_0x04b2('0x2a'),_0x04b2('0x6a')]);_0x5bd2e5[_0x04b2('0x4b')]=_0x04b2('0x6a');_0x576068=as[_0x04b2('0x6b')](_0xf1cdb6,_0x57cd1c[_0x04b2('0x3c')],_0x5bd2e5);_0x24709c[_0x44bc64](_0x576068[_0x04b2('0x6c')],_0x576068[_0x04b2('0x62')][_0x04b2('0x6d')],_0x576068['value']['end']);}break;case _0x04b2('0x6e'):var _0x364c5f=_0x5bd2e5[_0x04b2('0x62')][_0x04b2('0x30')](',')[_0x04b2('0x2d')](function(_0xd9cd8c){return Number(_0xd9cd8c);});_0x364c5f['forEach'](function(_0x1102da){_0xa8c71['or'](_0x04b2('0x6f'),'%,'+_0x1102da+',%');});_0x133f82=_[_0x04b2('0x70')](_0x133f82,_0x364c5f);break;case _0x04b2('0x71'):if(_0x5bd2e5[_0x04b2('0x66')]==='$substring'){_0x24709c[_0x44bc64]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x5bd2e5[_0x04b2('0x62')]+'%',null);}else{_0x57cd1c=_['find'](_0x290c77,[_0x04b2('0x2a'),_0x04b2('0x72')]);_0x5bd2e5[_0x04b2('0x4b')]=_0x04b2('0x72');_0x576068=as[_0x04b2('0x6b')](_0xf1cdb6,_0x57cd1c[_0x04b2('0x3c')],_0x5bd2e5);_0x24709c[_0x44bc64](_0x576068['text'],_0x576068['value'][_0x04b2('0x6d')],_0x576068[_0x04b2('0x62')][_0x04b2('0x1b')]);}break;case _0x04b2('0x73'):_0x576068=as[_0x04b2('0x6b')]('me',null,_0x5bd2e5);_0x24709c[_0x44bc64](_0x576068[_0x04b2('0x6c')],_0x576068[_0x04b2('0x62')][_0x04b2('0x6d')],_0x576068[_0x04b2('0x62')][_0x04b2('0x1b')]);break;}}else{var _0x576068=as[_0x04b2('0x6b')](_0xf1cdb6,_0x57cd1c[_0x04b2('0x3c')],_0x5bd2e5);_0x24709c[_0x44bc64](_0x576068[_0x04b2('0x6c')],_0x576068['value']['start'],_0x576068[_0x04b2('0x62')][_0x04b2('0x1b')]);}}}else{var _0x28648d=_(_0x507cce[_0x04b2('0x3f')])[_0x04b2('0x74')]()[_0x04b2('0x2d')](function(_0x12de9f){return _['some'](_0x290c77,[_0x04b2('0x2a'),_0x12de9f])?_0x12de9f:undefined;})['compact']()[_0x04b2('0x62')]();if(!_[_0x04b2('0x75')](_0x28648d)){_0x28648d['forEach'](function(_0x20cfc6){if(_0x20cfc6===_0x04b2('0x76')){_0x5179a1[_0x04b2('0x48')]('i.MailAccountId\x20IN\x20?',[]['concat'](_0x507cce['query'][_0x20cfc6]));}else if(_0x20cfc6==='createdAt'){var _0x4cb7dc=JSON[_0x04b2('0x77')](_0x507cce[_0x04b2('0x3f')][_0x20cfc6])['$gte'];var _0x16087c=JSON[_0x04b2('0x77')](_0x507cce[_0x04b2('0x3f')][_0x20cfc6])['$lte'];_0x5179a1[_0x04b2('0x48')](_0x04b2('0x78'),_0x4cb7dc,_0x16087c);}else{if(_0x507cce['query'][_0x20cfc6]===_0x04b2('0x79')){_0x5179a1[_0x04b2('0x48')]('i.'+_0x20cfc6+_0x04b2('0x7a'));}else{_0x5179a1[_0x04b2('0x48')]('i.'+_0x20cfc6+_0x04b2('0x7b'),_0x507cce['query'][_0x20cfc6]);}}});}if(_0x507cce[_0x04b2('0x3f')][_0x04b2('0x7c')]){if(_0x507cce[_0x04b2('0x3f')][_0x04b2('0x7c')]==0x1){_0x5179a1['having'](_0x04b2('0x7d'));}else{_0x5179a1[_0x04b2('0x63')](_0x04b2('0x7e'));}}if(_0x507cce[_0x04b2('0x3f')][_0x04b2('0x7f')]){_0x133f82=_[_0x04b2('0x80')](_0x507cce['query'][_0x04b2('0x7f')])?_0x507cce[_0x04b2('0x3f')]['tag']:new Array(_0x507cce[_0x04b2('0x3f')][_0x04b2('0x7f')]);_0x133f82[_0x04b2('0x31')](function(_0x93b0f9){_0xa8c71['or'](_0x04b2('0x6f'),'%,'+_0x93b0f9+',%');});}if(_0x507cce['query']['filter']){var _0x578580=_0x507cce[_0x04b2('0x3f')]['filter'][_0x04b2('0x81')]('\x5c','\x5c\x5c')[_0x04b2('0x81')]('\x27\x27',_0x04b2('0x82'));if(qs[_0x04b2('0x83')](_0x578580)){_0x24709c['or'](_0x04b2('0x84'),_0x578580+'%');}else if(qs[_0x04b2('0x85')](_0x578580)){_0x24709c['or'](_0x04b2('0x86'),_0x578580+'%');}else{_0x24709c['or'](_0x04b2('0x87'),qs[_0x04b2('0x69')](_0x578580))['or'](_0x04b2('0x88'),qs[_0x04b2('0x69')](_0x578580));}}}_0x5179a1[_0x04b2('0x48')](_0x24709c);_0x5179a1[_0x04b2('0x89')](_0x04b2('0x8a'));var _0x181515={'type':db[_0x04b2('0x8b')][_0x04b2('0x8c')][_0x04b2('0x8d')],'raw':!![]};var _0x55aab8=_0x5179a1['clone']();_0x55aab8[_0x04b2('0x4b')](_0x04b2('0x8a'));_0x55aab8[_0x04b2('0x4b')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x04b2('0x61'));if(_0x331d5c[_0x04b2('0x8e')]){_0x331d5c[_0x04b2('0x8e')][_0x04b2('0x31')](function(_0x400812){_0x5179a1['order']('i.'+_0x400812[0x0],_0x400812[0x1]===_0x04b2('0x8f')?![]:!![]);});}if(!_[_0x04b2('0x75')](_0x133f82)){_0x5179a1['having'](_0xa8c71);_0x55aab8[_0x04b2('0x48')](_0x04b2('0x90'),_0x133f82);}BPromise[_0x04b2('0x91')]()[_0x04b2('0x27')](function(){if(!_0x3486d8){if(_0x507cce[_0x04b2('0x3f')]['MailAccountId']||_0x507cce[_0x04b2('0x3f')][_0x04b2('0x92')])return;_0x55aab8[_0x04b2('0x48')](_0x04b2('0x93'));_0x5179a1[_0x04b2('0x48')]('i.MailAccountId\x20IS\x20NOT\x20NULL');return;}return _0x507cce['user'][_0x04b2('0x94')]({'attributes':['id'],'raw':!![]})[_0x04b2('0x27')](function(_0x1fb7e1){if(_['isEmpty'](_0x1fb7e1)){_0x55aab8[_0x04b2('0x48')](_0x04b2('0x95'));_0x5179a1[_0x04b2('0x48')]('i.MailAccountId\x20IS\x20NULL');}else{_0x55aab8[_0x04b2('0x48')]('i.MailAccountId\x20IN\x20?',_[_0x04b2('0x2d')](_0x1fb7e1,'id'));_0x5179a1[_0x04b2('0x48')](_0x04b2('0x96'),_[_0x04b2('0x2d')](_0x1fb7e1,'id'));}});})[_0x04b2('0x27')](function(){db['sequelize'][_0x04b2('0x3f')](_0x55aab8[_0x04b2('0x97')](),_0x181515)[_0x04b2('0x27')](function(_0x7a799e){_0x390dd6[_0x04b2('0x1e')]=_0x7a799e['length'];if(_0x390dd6['count']===0x0)return[];return db['sequelize']['query'](_0x53cef2[_0x04b2('0x97')](),_0x181515)[_0x04b2('0x27')](function(_0x2a7ee8){_0x4285ad=_[_0x04b2('0x98')](_0x2a7ee8,'id');_0x181515=_[_0x04b2('0x99')](_0x181515,{'model':db[_0x04b2('0x33')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x507cce[_0x04b2('0x3f')]['fields']){_0x331d5c[_0x04b2('0x43')][_0x04b2('0x31')](function(_0xc281b2){_0x5179a1['field']('i.'+_0xc281b2);});}else{_0x5179a1[_0x04b2('0x4b')](_0x04b2('0x9a'),_0x04b2('0x61'));_0x5179a1[_0x04b2('0x4b')]('a.key',_0x04b2('0x9b'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0x9c'),_0x04b2('0x9d'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0x8a'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0x9e'));_0x5179a1[_0x04b2('0x4b')]('i.updatedAt');_0x5179a1[_0x04b2('0x4b')](_0x04b2('0x9f'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xa0'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xa1'));_0x5179a1['field'](_0x04b2('0xa2'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xa3'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xa4'));_0x5179a1[_0x04b2('0x4b')]('i.disposition');_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xa5'));_0x5179a1[_0x04b2('0x4b')]('i.to');_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xa6'));_0x5179a1[_0x04b2('0x4b')]('i.MailAccountId');_0x5179a1['field'](_0x04b2('0xa7'));_0x5179a1['field'](_0x04b2('0xa8'),_0x04b2('0xa9'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xaa'),_0x04b2('0xab'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xac'),_0x04b2('0xad'));_0x5179a1[_0x04b2('0x4b')]('c.phone',_0x04b2('0xae'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xaf'),_0x04b2('0xb0'));_0x5179a1['field']('c.fax',_0x04b2('0xb1'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xb2'),_0x04b2('0xb3'));_0x5179a1['field']('o.internal',_0x04b2('0xb4'));_0x5179a1[_0x04b2('0x4b')](_0x04b2('0xb5'),_0x04b2('0xb6'));}_0x5179a1['limit'](_0x331d5c[_0x04b2('0x20')]);_0x5179a1[_0x04b2('0x1f')](_0x331d5c[_0x04b2('0x1f')]);return db['sequelize'][_0x04b2('0x3f')](_0x5179a1['toString'](),_0x181515);})[_0x04b2('0x27')](function(_0x19dad2){_0x2bcae2[_0x04b2('0x48')](_0x04b2('0xb7'),_[_0x04b2('0x2d')](_0x19dad2,'id'));return db[_0x04b2('0xb8')][_0x04b2('0x3f')](_0x2bcae2[_0x04b2('0x97')](),_0x181515)[_0x04b2('0x27')](function(_0x948cbb){var _0x3c6c2e=_[_0x04b2('0xb9')](_0x948cbb,'MailInteractionId');var _0x15c0f5=[];return db[_0x04b2('0xba')]['findOne']({'attributes':[_0x04b2('0xbb')],'raw':!![]})['then'](function(_0x11df55){var _0x304cf8=_0x11df55['enableEmailPreview'];_0x19dad2[_0x04b2('0x31')](function(_0x574a7f){_0x15c0f5[_0x04b2('0x32')](updateMailInteraction(_0x574a7f,_0x4285ad,_0x3c6c2e,_0x304cf8));});return BPromise['all'](_0x15c0f5);});});});})['then'](function(_0x4dc4b3){_0x390dd6[_0x04b2('0xbc')]=_0x4dc4b3;return _0x390dd6;})[_0x04b2('0x27')](respondWithFilteredResult(_0x5ea011,_0x331d5c));})[_0x04b2('0x38')](handleError(_0x5ea011,null));};exports[_0x04b2('0xbd')]=function(_0xd9bc33,_0x487dad){var _0x1c62b6={'raw':![],'where':{'id':_0xd9bc33[_0x04b2('0xbe')]['id']}},_0xb68974={};_0xb68974[_0x04b2('0x3e')]=_[_0x04b2('0x74')](db['MailInteraction'][_0x04b2('0x3a')]);_0xb68974[_0x04b2('0x3f')]=_[_0x04b2('0x74')](_0xd9bc33[_0x04b2('0x3f')]);_0xb68974[_0x04b2('0x40')]=_['intersection'](_0xb68974[_0x04b2('0x3e')],_0xb68974[_0x04b2('0x3f')]);_0x1c62b6[_0x04b2('0x43')]=_[_0x04b2('0x41')](_0xb68974[_0x04b2('0x3e')],qs[_0x04b2('0x42')](_0xd9bc33[_0x04b2('0x3f')][_0x04b2('0x42')]));_0x1c62b6[_0x04b2('0x43')]=_0x1c62b6['attributes'][_0x04b2('0x44')]?_0x1c62b6[_0x04b2('0x43')]:_0xb68974[_0x04b2('0x3e')];if(_0xd9bc33[_0x04b2('0x3f')][_0x04b2('0xbf')]){_0x1c62b6['include']=[{'all':!![]}];}_0x1c62b6=_[_0x04b2('0x99')]({},_0x1c62b6,_0xd9bc33[_0x04b2('0xc0')]);return db[_0x04b2('0x33')][_0x04b2('0xc1')](_0x1c62b6)[_0x04b2('0x27')](handleEntityNotFound(_0x487dad,null))[_0x04b2('0x27')](respondWithResult(_0x487dad,null))[_0x04b2('0x38')](handleError(_0x487dad,null));};exports[_0x04b2('0xc2')]=function(_0x32680c,_0x45bd98){return db[_0x04b2('0x33')][_0x04b2('0xc2')](_0x32680c[_0x04b2('0xc3')],{})[_0x04b2('0x27')](respondWithResult(_0x45bd98,0xc9))['catch'](handleError(_0x45bd98,null));};exports[_0x04b2('0x25')]=function(_0x54b9e1,_0x1f5db2){if(_0x54b9e1[_0x04b2('0xc3')]['id']){delete _0x54b9e1['body']['id'];}return db[_0x04b2('0x33')][_0x04b2('0xc1')]({'where':{'id':_0x54b9e1[_0x04b2('0xbe')]['id']}})[_0x04b2('0x27')](handleEntityNotFound(_0x1f5db2,null))[_0x04b2('0x27')](saveUpdates(_0x54b9e1['body'],null))[_0x04b2('0x27')](respondWithResult(_0x1f5db2,null))[_0x04b2('0x38')](handleError(_0x1f5db2,null));};exports['destroy']=function(_0x53f6c9,_0x37ba6c){return db[_0x04b2('0x33')]['find']({'where':{'id':_0x53f6c9[_0x04b2('0xbe')]['id']}})[_0x04b2('0x27')](handleEntityNotFound(_0x37ba6c,null))[_0x04b2('0x27')](removeEntity(_0x37ba6c,null))[_0x04b2('0x38')](handleError(_0x37ba6c,null));};exports[_0x04b2('0xc4')]=function(_0x40ffeb,_0x241323){return db[_0x04b2('0x33')]['describe']()[_0x04b2('0x27')](respondWithResult(_0x241323,null))[_0x04b2('0x38')](handleError(_0x241323,null));};exports[_0x04b2('0xc5')]=function(_0x13fd94,_0x4c2ec9,_0x1098ae){return db[_0x04b2('0xc6')]['find']({'where':{'id':_0x13fd94[_0x04b2('0xbe')]['id']}})[_0x04b2('0x27')](handleEntityNotFound(_0x4c2ec9,null))[_0x04b2('0x27')](function(_0x1e3697){if(_0x1e3697){return _0x1e3697[_0x04b2('0xc5')](_0x13fd94[_0x04b2('0xc3')][_0x04b2('0xc7')],_[_0x04b2('0xc8')](_0x13fd94['body'],[_0x04b2('0xc7'),'id'])||{});}})[_0x04b2('0x27')](respondWithResult(_0x4c2ec9,null))[_0x04b2('0x38')](handleError(_0x4c2ec9,null));};exports[_0x04b2('0xc9')]=function(_0x1ad872,_0x15b247,_0x5e4b06){var _0x503620={'raw':![],'where':{}};var _0x3bf13b={};var _0x157e12={'count':0x0,'rows':[]};return db[_0x04b2('0x33')]['findOne']({'where':{'id':_0x1ad872[_0x04b2('0xbe')]['id']}})[_0x04b2('0x27')](handleEntityNotFound(_0x15b247,null))[_0x04b2('0x27')](function(_0x581060){if(_0x581060){_0x3bf13b[_0x04b2('0x3e')]=_[_0x04b2('0x74')](db[_0x04b2('0xc6')]['rawAttributes']);_0x3bf13b[_0x04b2('0x3f')]=_[_0x04b2('0x74')](_0x1ad872[_0x04b2('0x3f')]);_0x3bf13b[_0x04b2('0x40')]=_[_0x04b2('0x41')](_0x3bf13b['model'],_0x3bf13b['query']);_0x503620['attributes']=_[_0x04b2('0x41')](_0x3bf13b['model'],qs[_0x04b2('0x42')](_0x1ad872[_0x04b2('0x3f')][_0x04b2('0x42')]));_0x503620['attributes']=_0x503620[_0x04b2('0x43')]['length']?_0x503620['attributes']:_0x3bf13b[_0x04b2('0x3e')];if(!_0x1ad872[_0x04b2('0x3f')][_0x04b2('0x45')](_0x04b2('0x46'))){_0x503620['limit']=qs[_0x04b2('0x20')](_0x1ad872[_0x04b2('0x3f')][_0x04b2('0x20')]);_0x503620[_0x04b2('0x1f')]=qs[_0x04b2('0x1f')](_0x1ad872[_0x04b2('0x3f')][_0x04b2('0x1f')]);}_0x503620[_0x04b2('0x8e')]=qs[_0x04b2('0x47')](_0x1ad872[_0x04b2('0x3f')][_0x04b2('0x47')]);_0x503620[_0x04b2('0x48')]=qs['filters'](_[_0x04b2('0x49')](_0x1ad872['query'],_0x3bf13b[_0x04b2('0x40')]));_0x503620[_0x04b2('0x48')][_0x04b2('0xca')]=_0x581060['id'];if(_0x1ad872[_0x04b2('0x3f')][_0x04b2('0xcb')]){_0x503620[_0x04b2('0x48')]=_[_0x04b2('0x99')](_0x503620[_0x04b2('0x48')],{'$or':_[_0x04b2('0x2d')](_0x503620[_0x04b2('0x43')],function(_0x4650a8){var _0x6e5d51={};_0x6e5d51[_0x4650a8]={'$like':'%'+_0x1ad872['query'][_0x04b2('0xcb')]+'%'};return _0x6e5d51;})});}if(_0x1ad872['query'][_0x04b2('0xcc')]){var _0x45ec9d=_0x1ad872['query'][_0x04b2('0xcc')][_0x04b2('0x30')](',');var _0x3a68c2={};_0x3a68c2[_0x45ec9d[0x0]]={'$gte':moment(_0x45ec9d[0x1])[_0x04b2('0xcd')](_0x04b2('0xce'))};_0x503620[_0x04b2('0x48')]=_[_0x04b2('0x99')](_0x503620[_0x04b2('0x48')],_0x3a68c2);}_0x503620=_['merge']({},_0x503620,_0x1ad872[_0x04b2('0xc0')]);return db[_0x04b2('0xc6')][_0x04b2('0x1e')]({'where':_0x503620[_0x04b2('0x48')]})[_0x04b2('0x27')](function(_0x479538){_0x157e12['count']=_0x479538;if(_0x1ad872[_0x04b2('0x3f')][_0x04b2('0xbf')]){_0x503620[_0x04b2('0xcf')]=[{'all':!![]}];}return db[_0x04b2('0xc6')][_0x04b2('0xd0')](_0x503620);})[_0x04b2('0x27')](function(_0x7cdb55){_0x157e12['rows']=_0x7cdb55;return _0x157e12;});}})[_0x04b2('0x27')](respondWithFilteredResult(_0x15b247,_0x503620))[_0x04b2('0x38')](handleError(_0x15b247,null));};exports['addTags']=function(_0x28aa5a,_0x5d42e7,_0x573116){return db[_0x04b2('0x33')][_0x04b2('0xc1')]({'where':{'id':_0x28aa5a[_0x04b2('0xbe')]['id']}})['then'](handleEntityNotFound(_0x5d42e7,null))[_0x04b2('0x27')](function(_0x570b16){if(_0x570b16){return _0x570b16[_0x04b2('0xd1')](_0x28aa5a[_0x04b2('0xc3')]['ids'],_[_0x04b2('0xc8')](_0x28aa5a[_0x04b2('0xc3')],[_0x04b2('0xc7'),'id'])||{})[_0x04b2('0xd2')](function(){return db['Tag'][_0x04b2('0xd0')]({'attributes':['id',_0x04b2('0x2a'),_0x04b2('0x4c')],'where':{'id':_0x28aa5a[_0x04b2('0xc3')][_0x04b2('0xc7')]}});})[_0x04b2('0x27')](function(_0xdb1851){socket[_0x04b2('0xd3')](_0x04b2('0xd4'),{'id':Number(_0x28aa5a[_0x04b2('0xbe')]['id']),'tags':_0xdb1851||[]});return{'id':Number(_0x28aa5a[_0x04b2('0xbe')]['id']),'tags':_0xdb1851||[]};});}})['then'](respondWithResult(_0x5d42e7,null))['catch'](handleError(_0x5d42e7,null));};exports[_0x04b2('0xd5')]=function(_0x1d0e1d,_0x50d1db,_0x257313){return db[_0x04b2('0x33')][_0x04b2('0xc1')]({'where':{'id':_0x1d0e1d[_0x04b2('0xbe')]['id']}})['then'](handleEntityNotFound(_0x50d1db,null))[_0x04b2('0x27')](function(_0x4c41be){if(_0x4c41be){return _0x4c41be['removeTags'](_0x1d0e1d[_0x04b2('0x3f')][_0x04b2('0xc7')]);}})[_0x04b2('0x27')](respondWithStatusCode(_0x50d1db,null))['catch'](handleError(_0x50d1db,null));};exports[_0x04b2('0xd6')]=function(_0x3d545f,_0x399ef8){var _0x1379ef=moment()[_0x04b2('0xd7')]()['toString']();var _0x31cf7a=path['join'](config[_0x04b2('0xd8')],_0x04b2('0xd9'),_0x04b2('0xda'),_0x04b2('0xdb'));var _0x7be1e2=path[_0x04b2('0xdc')](config[_0x04b2('0xd8')],_0x04b2('0xd9'),_0x04b2('0xda'),_0x04b2('0xdd'));var _0x1568cf=path[_0x04b2('0xdc')](_0x31cf7a,_0x1379ef);var _0x3f6f40=util[_0x04b2('0xcd')](_0x04b2('0xde'),_0x3d545f[_0x04b2('0xbe')]['id'],_0x1379ef);var _0x37e1e3=path[_0x04b2('0xdc')](_0x31cf7a,_0x3f6f40);var _0x57be54=[];if(_0x3d545f['query'][_0x04b2('0xdd')]){_0x57be54[_0x04b2('0x32')]({'model':db['Attachment'],'as':_0x04b2('0xdf'),'raw':!![]});}var _0x15281e=[{'model':db[_0x04b2('0xc6')],'as':'Messages','attributes':['id',_0x04b2('0xc3'),_0x04b2('0x4d'),'to','cc',_0x04b2('0xe0'),_0x04b2('0xe1'),_0x04b2('0xe2')],'where':{'secret':![]},'order':qs[_0x04b2('0x47')]('id'),'include':_0x57be54}];return db[_0x04b2('0x33')][_0x04b2('0xc1')]({'where':{'id':_0x3d545f[_0x04b2('0xbe')]['id']},'include':_0x15281e})['then'](handleEntityNotFound(_0x399ef8,null))[_0x04b2('0x27')](function(_0x15ed70){if(_0x15ed70&&_0x15ed70['Messages']){var _0x2ce44b=_0x15ed70[_0x04b2('0xe3')]({'plain':!![]});fs[_0x04b2('0xe4')](_0x1568cf);return BPromise[_0x04b2('0xe5')](_0x2ce44b['Messages'],function(_0x456221,_0x5286ba){var _0x4a948a={'from':_0x456221[_0x04b2('0x4d')],'to':_0x456221['to'],'subject':_0x456221[_0x04b2('0xe1')],'html':_0x456221[_0x04b2('0xc3')],'headers':{'Date':moment(_0x456221['createdAt'])[_0x04b2('0xcd')](_0x04b2('0xe6'))},'attachments':[]};if(_0x456221['cc']){_0x4a948a[_0x04b2('0xe7')]['Cc']=_0x456221['cc'];}if(_0x456221['bcc']){_0x4a948a[_0x04b2('0xe7')][_0x04b2('0xe8')]=_0x456221['bcc'];}return new BPromise(function(_0x2289d8,_0x4c61d0){if(_0x456221['Attachments']){for(var _0x2beffb=0x0;_0x2beffb<_0x456221[_0x04b2('0xdf')][_0x04b2('0x44')];_0x2beffb++){var _0x186939=_0x456221[_0x04b2('0xdf')][_0x2beffb];var _0x182af7=path[_0x04b2('0xdc')](_0x7be1e2,_0x186939[_0x04b2('0xe9')]);if(fs[_0x04b2('0xea')](_0x182af7)){_0x4a948a[_0x04b2('0xdd')][_0x04b2('0x32')]({'name':_0x186939[_0x04b2('0x2a')],'contentType':_0x186939[_0x04b2('0x3c')],'data':fs[_0x04b2('0xeb')](_0x182af7)});}}}emlformat['build'](_0x4a948a,function(_0x3e4404,_0xecf4ea){if(_0x3e4404)return _0x4c61d0(_0x3e4404);fs[_0x04b2('0xec')](path[_0x04b2('0xdc')](_0x1568cf,util['format'](_0x04b2('0xed'),_0x5286ba)),_0xecf4ea);return _0x2289d8(_0xecf4ea);});});})['then'](function(){return new BPromise(function(_0x8c9997,_0x3de20){zipdir(_0x1568cf,{'saveTo':_0x37e1e3},function(_0x2b7170,_0xee07df){if(_0x2b7170)return _0x3de20(_0x2b7170);return _0x8c9997(_0xee07df);});})[_0x04b2('0x27')](function(){return new BPromise(function(_0xb21921,_0x16f74e){rimraf(_0x1568cf,function(_0x1a051b){if(_0x1a051b)_0x16f74e(_0x1a051b);return _0xb21921();});});})['then'](function(){return _0x399ef8[_0x04b2('0xd6')](_0x37e1e3,_0x3f6f40,function(_0x41b563){if(_0x41b563){console[_0x04b2('0xee')](_0x04b2('0xef'),_0x41b563);}else{fs['unlinkSync'](_0x37e1e3);}});});});}else{return _0x399ef8[_0x04b2('0x1a')](0xc8);}})[_0x04b2('0x38')](handleError(_0x399ef8,null));};
\ No newline at end of file
+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
git://repos.xcallymotion.com / motion2.git / blobdiff