// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x86c4=['api','../../config/utils','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','sendStatus','status','end','count','offset','Content-Range','json','apply','reject','update','then','destroy','stack','name','send','Users','map','TagIds','Tags','split','push','MailInteraction','findOne','lastMsgBody','lastMsgText','trimStart','fromString','catch','index','rawAttributes','keys','query','intersection','model','attributes','nolimit','limit','order','sort','where','filters','pick','select','field','color','tools_tags','COUNT(*)','from','mail_messages','me.MailInteractionId\x20=\x20i.id','me.direction\x20=\x20\x27in\x27','u.id','ui.MailInteractionId','left_join','u.id\x20=\x20ui.UserId','mail_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','mail_accounts','me.MailInteractionId\x20=\x20i.id\x20AND\x20me.direction\x20=\x20\x27in\x27\x20AND\x20me.read\x20=\x20false','expr','advancedFilter','parse','forEach','createdAt','value','dateStart','startOf','day','utc','format','endOf','and','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','condition','TagId','unreadMessages','isArray','length','tableAlias','\x20IN\x20?','LIKE','ContactId','c.firstName','\x20LIKE\x20?','c.email','\x20>\x20?','\x20<\x20?','\x20=\x20?','hasOwnProperty','filter','isNil','isEmpty','MailAccountId','$gte','null','\x20IS\x20NULL','replace','\x27\x27\x27\x27','isNumeric','i.id\x20LIKE\x20?','isEmail','toString','join','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','DESC','group','i.id','Sequelize','QueryTypes','SELECT','clone','COUNT(me.id)','having','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','t.id\x20IN\x20?','mail_interaction_has_tags','sequelize','keyBy','merge','a.key','Account.key','i.createdAt','i.closedAt','i.attach','i.lastMsgDirection','i.subject','i.disposition','i.substatus','i.MailAccountId','i.UserId','Contact.firstName','c.lastName','Contact.lastName','Contact.email','c.phone','Contact.phone','Contact.mobile','c.fax','Contact.fax','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','all','rows','show','params','fields','includeAll','options','find','create','body','describe','addMessage','MailMessage','ids','omit','include','findAll','addTags','setTags','Tag','mailInteractionTags:save','removeTags','download','server','root','files','tmp','interaction-%s.zip','getMessages','bcc','attachments','Attachment','mkdirSync','each','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','Attachments','type','readFileSync','build','message%d.eml','log','err','unlinkSync','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger'];(function(_0x3ab51d,_0x2fa01d){var _0x29a04e=function(_0x7807b0){while(--_0x7807b0){_0x3ab51d['push'](_0x3ab51d['shift']());}};_0x29a04e(++_0x2fa01d);}(_0x86c4,0xce));var _0x486c=function(_0x4565bf,_0x5ad9d6){_0x4565bf=_0x4565bf-0x0;var _0x5610ba=_0x86c4[_0x4565bf];return _0x5610ba;};'use strict';var pdf=require(_0x486c('0x0'));var emlformat=require(_0x486c('0x1'));var rimraf=require(_0x486c('0x2'));var zipdir=require(_0x486c('0x3'));var jsonpatch=require(_0x486c('0x4'));var rp=require(_0x486c('0x5'));var moment=require(_0x486c('0x6'));var BPromise=require(_0x486c('0x7'));var Mustache=require(_0x486c('0x8'));var util=require(_0x486c('0x9'));var path=require('path');var sox=require(_0x486c('0xa'));var csv=require(_0x486c('0xb'));var ejs=require(_0x486c('0xc'));var fs=require('fs');var _=require(_0x486c('0xd'));var squel=require(_0x486c('0xe'));var crypto=require(_0x486c('0xf'));var jsforce=require(_0x486c('0x10'));var deskjs=require(_0x486c('0x11'));var toCsv=require(_0x486c('0xb'));var querystring=require(_0x486c('0x12'));var Papa=require('papaparse');var htmlToText=require('html-to-text');var Redis=require('ioredis');var authService=require(_0x486c('0x13'));var qs=require(_0x486c('0x14'));var hardwareService=require(_0x486c('0x15'));var logger=require(_0x486c('0x16'))(_0x486c('0x17'));var utils=require(_0x486c('0x18'));var config=require(_0x486c('0x19'));var db=require(_0x486c('0x1a'))['db'];config[_0x486c('0x1b')]=_['defaults'](config[_0x486c('0x1b')],{'host':_0x486c('0x1c'),'port':0x18eb});var socket=require(_0x486c('0x1d'))(new Redis(config[_0x486c('0x1b')]));require('./mailInteraction.socket')['register'](socket);function respondWithStatusCode(_0x360744,_0x3e8a8b){_0x3e8a8b=_0x3e8a8b||0xcc;return function(_0x1f39fb){if(_0x1f39fb){return _0x360744[_0x486c('0x1e')](_0x3e8a8b);}return _0x360744[_0x486c('0x1f')](_0x3e8a8b)[_0x486c('0x20')]();};}function respondWithResult(_0x55ccbe,_0x296a01){_0x296a01=_0x296a01||0xc8;return function(_0x3b66fd){if(_0x3b66fd){return _0x55ccbe[_0x486c('0x1f')](_0x296a01)['json'](_0x3b66fd);}};}function respondWithFilteredResult(_0x21352c,_0x305ec2){return function(_0x29601d){if(_0x29601d){var _0x1fab57=_0x29601d[_0x486c('0x21')],_0x391cc1=_0x305ec2[_0x486c('0x22')],_0x4bedc5=_0x305ec2[_0x486c('0x22')]+_0x305ec2['limit'],_0x1d8dd5;if(_0x4bedc5>=_0x1fab57){_0x4bedc5=_0x1fab57;_0x1d8dd5=0xc8;}else{_0x1d8dd5=0xce;}_0x21352c[_0x486c('0x1f')](_0x1d8dd5);return _0x21352c['set'](_0x486c('0x23'),_0x391cc1+'-'+_0x4bedc5+'/'+_0x1fab57)[_0x486c('0x24')](_0x29601d);}return null;};}function patchUpdates(_0x259b55){return function(_0x7be1b7){try{jsonpatch[_0x486c('0x25')](_0x7be1b7,_0x259b55,!![]);}catch(_0x1fb7d3){return BPromise[_0x486c('0x26')](_0x1fb7d3);}return _0x7be1b7['save']();};}function saveUpdates(_0x5c9b08,_0x5e56d9){return function(_0x364f60){if(_0x364f60){return _0x364f60[_0x486c('0x27')](_0x5c9b08)[_0x486c('0x28')](function(_0x168598){return _0x168598;});}return null;};}function removeEntity(_0x3e58a2,_0x2ad766){return function(_0x55acab){if(_0x55acab){return _0x55acab[_0x486c('0x29')]()[_0x486c('0x28')](function(){_0x3e58a2[_0x486c('0x1f')](0xcc)[_0x486c('0x20')]();});}};}function handleEntityNotFound(_0x104218,_0x3dd164){return function(_0x308143){if(!_0x308143){_0x104218[_0x486c('0x1e')](0x194);}return _0x308143;};}function handleError(_0x3b04db,_0x27d7cb){_0x27d7cb=_0x27d7cb||0x1f4;return function(_0x5c3a89){logger['error'](_0x5c3a89[_0x486c('0x2a')]);if(_0x5c3a89[_0x486c('0x2b')]){delete _0x5c3a89[_0x486c('0x2b')];}_0x3b04db[_0x486c('0x1f')](_0x27d7cb)[_0x486c('0x2c')](_0x5c3a89);};}function getInteractionUsers(_0x3e00e6,_0x308e45){return new BPromise(function(_0xdc4b4,_0x5ac1d4){try{if(_0x308e45[_0x3e00e6['id']]){_0x3e00e6[_0x486c('0x2d')]=_[_0x486c('0x2e')](_0x308e45[_0x3e00e6['id']],function(_0x27c02b){return{'id':_0x27c02b['id']};});}}catch(_0x33df68){_0x5ac1d4(_0x33df68);}_0xdc4b4(_0x3e00e6);});}function getInteractionTags(_0x462e85,_0x33ba0a){return new BPromise(function(_0x54484f,_0x36db35){try{if(_0x462e85[_0x486c('0x2f')]){_0x462e85[_0x486c('0x30')]=[];_0x462e85[_0x486c('0x2f')][_0x486c('0x31')](',')['forEach'](function(_0x1ac2e7){_0x462e85[_0x486c('0x30')][_0x486c('0x32')](_0x33ba0a[_0x1ac2e7]);});}delete _0x462e85['TagIds'];}catch(_0x3d2c58){_0x36db35(_0x3d2c58);}_0x54484f(_0x462e85);});}function getLastMessageText(_0x2d99ef){return new BPromise(function(_0xd4ad63,_0x189dcb){return db[_0x486c('0x33')][_0x486c('0x34')]({'where':{'id':_0x2d99ef['id']},'attributes':[_0x486c('0x35'),_0x486c('0x36')],'raw':!![]})[_0x486c('0x28')](function(_0x104c4d){if(!_0x104c4d[_0x486c('0x36')]){_0x2d99ef[_0x486c('0x36')]=_[_0x486c('0x37')](htmlToText[_0x486c('0x38')](_0x104c4d[_0x486c('0x35')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x2d99ef[_0x486c('0x36')]=_0x104c4d['lastMsgText'];}_0xd4ad63(_0x2d99ef);})[_0x486c('0x39')](function(_0x11c11f){_0x189dcb(_0x11c11f);});});}function updateMailInteraction(_0x1c0515,_0x382bf9,_0x5eaccb,_0x1c27ab){return new BPromise(function(_0x2447f3,_0x526a2a){return getInteractionUsers(_0x1c0515,_0x5eaccb)['then'](function(_0x416be3){return getInteractionTags(_0x416be3,_0x382bf9);})[_0x486c('0x28')](function(_0x298754){if(_0x1c27ab){_0x2447f3(getLastMessageText(_0x298754));}else{_0x2447f3(_0x298754);}})[_0x486c('0x39')](function(_0x1f10ca){_0x526a2a(_0x1f10ca);});});}exports[_0x486c('0x3a')]=function(_0x2151dc,_0x4a8098){var _0xe0f26f={},_0x29e994={},_0x7183f5={'count':0x0,'rows':[]};var _0x29732d=db['MailInteraction'][_0x486c('0x3b')];_0x29e994['model']=_[_0x486c('0x3c')](_0x29732d);_0x29e994[_0x486c('0x3d')]=_[_0x486c('0x3c')](_0x2151dc[_0x486c('0x3d')]);_0x29e994['filters']=_[_0x486c('0x3e')](_0x29e994[_0x486c('0x3f')],_0x29e994[_0x486c('0x3d')]);_0xe0f26f[_0x486c('0x40')]=_[_0x486c('0x3e')](_0x29e994['model'],qs['fields'](_0x2151dc[_0x486c('0x3d')]['fields']));_0xe0f26f[_0x486c('0x40')]=_0xe0f26f[_0x486c('0x40')]['length']?_0xe0f26f[_0x486c('0x40')]:_0x29e994[_0x486c('0x3f')];if(!_0x2151dc[_0x486c('0x3d')]['hasOwnProperty'](_0x486c('0x41'))){_0xe0f26f[_0x486c('0x42')]=qs['limit'](_0x2151dc[_0x486c('0x3d')][_0x486c('0x42')]);_0xe0f26f[_0x486c('0x22')]=qs['offset'](_0x2151dc[_0x486c('0x3d')][_0x486c('0x22')]);}_0xe0f26f[_0x486c('0x43')]=qs[_0x486c('0x44')](_0x2151dc[_0x486c('0x3d')][_0x486c('0x44')]);_0xe0f26f[_0x486c('0x45')]=qs[_0x486c('0x46')](_[_0x486c('0x47')](_0x2151dc['query'],_0x29e994[_0x486c('0x46')]));var _0x24b730=[];var _0x3e8db9=squel[_0x486c('0x48')]()[_0x486c('0x49')]('id')[_0x486c('0x49')](_0x486c('0x2b'))[_0x486c('0x49')](_0x486c('0x4a'))['from'](_0x486c('0x4b'));var _0x22cd75=squel[_0x486c('0x48')]()[_0x486c('0x49')](_0x486c('0x4c'))[_0x486c('0x4d')](_0x486c('0x4e'),'me')['where'](_0x486c('0x4f'))[_0x486c('0x45')](_0x486c('0x50'))['where']('me.read\x20=\x20false');var _0xc5d311=squel[_0x486c('0x48')]()[_0x486c('0x49')](_0x486c('0x51'))[_0x486c('0x49')](_0x486c('0x52'))['from']('user_has_mail_interactions','ui')[_0x486c('0x53')]('users','u',_0x486c('0x54'));var _0x125e57=squel[_0x486c('0x48')]()['from'](_0x486c('0x55'),'i')['left_join'](_0x486c('0x56'),'c',_0x486c('0x57'))['left_join'](_0x486c('0x58'),'o',_0x486c('0x59'))[_0x486c('0x53')](_0x486c('0x5a'),'a','a.id\x20=\x20i.MailAccountId')['left_join']('mail_messages','me',_0x486c('0x5b'));var _0x457b77=squel[_0x486c('0x5c')]();if(_0x2151dc[_0x486c('0x3d')][_0x486c('0x5d')]){var _0x1b8a77=JSON[_0x486c('0x5e')](_0x2151dc[_0x486c('0x3d')][_0x486c('0x5d')]);_[_0x486c('0x3c')](_0x1b8a77)[_0x486c('0x5f')](function(_0x286db1){var _0x428323=_0x1b8a77[_0x286db1];if(_0x286db1===_0x486c('0x60')){var _0x125a8e=moment(_0x428323[_0x486c('0x61')][_0x486c('0x62')])[_0x486c('0x63')](_0x486c('0x64'))[_0x486c('0x65')]()[_0x486c('0x66')]();var _0x53f629=moment(_0x53f629)[_0x486c('0x65')]()[_0x486c('0x67')]('day')[_0x486c('0x66')]();_0x457b77[_0x486c('0x68')](_0x486c('0x69'),_0x125a8e,_0x53f629);}else{if(_['isArray'](_0x428323[_0x486c('0x6a')])){_0x428323[_0x486c('0x6a')][_0x486c('0x5f')](function(_0x31940e){switch(_0x428323['condition'][_0x486c('0x61')]){case'IS':if(_0x286db1!==_0x486c('0x6b')&&_0x286db1!==_0x486c('0x6c')){if(_[_0x486c('0x6d')](_0x428323[_0x486c('0x61')])&&_0x428323['value'][_0x486c('0x6e')]>0x1){_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+_0x486c('0x70'),_0x428323[_0x486c('0x61')]);}else{_0x457b77[_0x486c('0x68')](_0x428323['tableAlias']+'.'+_0x286db1+'\x20=\x20?',_0x428323['value'][0x0]);}}break;case'=':_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+'\x20=\x20?',_0x428323[_0x486c('0x61')]);break;case _0x486c('0x71'):if(_0x286db1===_0x486c('0x72')){_0x457b77[_0x486c('0x68')](_0x486c('0x73')+_0x486c('0x74'),'%'+_0x428323[_0x486c('0x61')]+'%');_0x457b77['or']('c.lastName'+'\x20LIKE\x20?','%'+_0x428323['value']+'%');_0x457b77['or'](_0x486c('0x75')+_0x486c('0x74'),'%'+_0x428323['value']+'%');}else{_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+_0x486c('0x74'),'%'+_0x428323['value']+'%');}break;case'>':_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+_0x486c('0x76'),_0x428323['value']);break;case'<':_0x457b77['and'](_0x428323['tableAlias']+'.'+_0x286db1+_0x486c('0x77'),_0x428323['value']);break;}});}else{switch(_0x428323['condition'][_0x486c('0x61')]){case'IS':if(_0x286db1!==_0x486c('0x6b')&&_0x286db1!=='unreadMessages'){if(_['isArray'](_0x428323[_0x486c('0x61')])&&_0x428323['value']['length']>0x1){_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+'\x20IN\x20?',_0x428323[_0x486c('0x61')]);}else{_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+_0x486c('0x78'),_0x428323[_0x486c('0x61')][0x0]);}}break;case'=':_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+_0x486c('0x78'),_0x428323[_0x486c('0x61')]);break;case _0x486c('0x71'):if(_0x286db1===_0x486c('0x72')){_0x457b77['and'](_0x486c('0x73')+_0x486c('0x74'),'%'+_0x428323['value']+'%');_0x457b77['or']('c.lastName'+_0x486c('0x74'),'%'+_0x428323[_0x486c('0x61')]+'%');_0x457b77['or']('c.email'+_0x486c('0x74'),'%'+_0x428323[_0x486c('0x61')]+'%');}else{_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+_0x486c('0x74'),'%'+_0x428323[_0x486c('0x61')]+'%');}break;case'>':_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+_0x486c('0x76'),_0x428323[_0x486c('0x61')]);break;case'<':_0x457b77[_0x486c('0x68')](_0x428323[_0x486c('0x6f')]+'.'+_0x286db1+_0x486c('0x77'),_0x428323[_0x486c('0x61')]);break;}}}});}else{var _0x2fff85=_(Object['keys'](_0x2151dc[_0x486c('0x3d')]))['map'](function(_0x1dcd34){return _0x29732d[_0x486c('0x79')](_0x1dcd34)?_0x1dcd34:undefined;})[_0x486c('0x7a')](function(_0x5810f9){return!_[_0x486c('0x7b')](_0x5810f9);})[_0x486c('0x61')]();if(!_[_0x486c('0x7c')](_0x2fff85)){_0x2fff85['forEach'](function(_0x1f5b58){if(_0x1f5b58===_0x486c('0x7d')){_0x125e57[_0x486c('0x45')]('i.MailAccountId\x20IN\x20?',[]['concat'](_0x2151dc[_0x486c('0x3d')][_0x1f5b58]));}else if(_0x1f5b58===_0x486c('0x60')){var _0x49c1dc=JSON[_0x486c('0x5e')](_0x2151dc[_0x486c('0x3d')][_0x1f5b58])[_0x486c('0x7e')];var _0x1eb7db=JSON[_0x486c('0x5e')](_0x2151dc[_0x486c('0x3d')][_0x1f5b58])['$lte'];_0x125e57['where']('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x49c1dc,_0x1eb7db);}else{if(_0x2151dc['query'][_0x1f5b58]===_0x486c('0x7f')){_0x125e57[_0x486c('0x45')]('i.'+_0x1f5b58+_0x486c('0x80'));}else{_0x125e57[_0x486c('0x45')]('i.'+_0x1f5b58+_0x486c('0x78'),_0x2151dc[_0x486c('0x3d')][_0x1f5b58]);}}});}if(_0x2151dc['query']['filter']){var _0x44f855=_0x2151dc['query'][_0x486c('0x7a')][_0x486c('0x81')]('\x5c','\x5c\x5c')[_0x486c('0x81')]('\x27\x27',_0x486c('0x82'));if(qs[_0x486c('0x83')](_0x44f855)){_0x457b77['or'](_0x486c('0x84'),_0x44f855+'%');}else if(qs[_0x486c('0x85')](_0x44f855)){_0x457b77['or']('c.email\x20LIKE\x20?',_0x44f855+'%');}else{var _0x9f4af4=[];_0x44f855[_0x486c('0x31')]('\x20')[_0x486c('0x5f')](function(_0x2e6775){_0x9f4af4[_0x486c('0x32')]('+'+_0x2e6775[_0x486c('0x86')]());});var _0x4433cf=_0x9f4af4[_0x486c('0x87')]('\x20');_0x457b77['or'](_0x486c('0x88'),_0x4433cf)['or'](_0x486c('0x89'),_0x4433cf);}}}_0x125e57['where'](_0x457b77);if(_0xe0f26f['order']){_0xe0f26f[_0x486c('0x43')][_0x486c('0x5f')](function(_0x37621c){_0x125e57['order']('i.'+_0x37621c[0x0],_0x37621c[0x1]===_0x486c('0x8a')?![]:!![]);});}_0x125e57[_0x486c('0x8b')](_0x486c('0x8c'));var _0x4ab36e={'type':db[_0x486c('0x8d')][_0x486c('0x8e')][_0x486c('0x8f')],'raw':!![]};var _0x1bdd24=_0x125e57[_0x486c('0x90')]()[_0x486c('0x49')](_0x486c('0x4c'))[_0x486c('0x49')](_0x486c('0x91'),'unreadMessages');if(!_0x2151dc['query'][_0x486c('0x5d')]){if(_0x2151dc[_0x486c('0x3d')]['read']){if(_0x2151dc[_0x486c('0x3d')]['read']==0x1){_0x1bdd24[_0x486c('0x92')](_0x486c('0x93'));_0x125e57[_0x486c('0x92')](_0x486c('0x93'));}else{_0x1bdd24[_0x486c('0x92')]('`unreadMessages`\x20>\x200');_0x125e57[_0x486c('0x92')](_0x486c('0x94'));}}if(_0x2151dc[_0x486c('0x3d')][_0x486c('0x95')]){var _0x8d63bb=_[_0x486c('0x6d')](_0x2151dc[_0x486c('0x3d')][_0x486c('0x95')])?_0x2151dc['query'][_0x486c('0x95')]:new Array(_0x2151dc['query'][_0x486c('0x95')]);var _0x29e23f=squel[_0x486c('0x5c')]();_0x8d63bb['forEach'](function(_0x5debb0){_0x29e23f['or'](_0x486c('0x96'),'%,'+_0x5debb0+',%');});_0x125e57[_0x486c('0x92')](_0x29e23f);_0x1bdd24['left_join']('mail_interaction_has_tags','it',_0x486c('0x97'));_0x1bdd24[_0x486c('0x53')](_0x486c('0x4b'),'t',_0x486c('0x98'));_0x1bdd24[_0x486c('0x45')](_0x486c('0x99'),_0x8d63bb);}}else{var _0x1b8a77=JSON['parse'](_0x2151dc['query'][_0x486c('0x5d')]);_['keys'](_0x1b8a77)[_0x486c('0x5f')](function(_0x30c9a9){var _0x521205=_0x1b8a77[_0x30c9a9];if(_0x30c9a9===_0x486c('0x6b')){var _0x5bf7fe=_0x521205['value'];var _0x20c028=squel[_0x486c('0x5c')]();_0x5bf7fe[_0x486c('0x5f')](function(_0x2f3f77){_0x20c028['or'](_0x486c('0x96'),'%,'+_0x2f3f77+',%');});_0x125e57[_0x486c('0x92')](_0x20c028);_0x1bdd24[_0x486c('0x53')](_0x486c('0x9a'),'it',_0x486c('0x97'));_0x1bdd24['left_join'](_0x486c('0x4b'),'t',_0x486c('0x98'));_0x1bdd24[_0x486c('0x45')](_0x486c('0x99'),_0x5bf7fe);}else if(_0x30c9a9==='unreadMessages'){if(_0x521205['value']['length']===0x1){if(_0x521205[_0x486c('0x61')][0x0]===0x1){_0x1bdd24[_0x486c('0x92')]('`unreadMessages`\x20=\x200');_0x125e57['having'](_0x486c('0x93'));}else{_0x1bdd24[_0x486c('0x92')](_0x486c('0x94'));_0x125e57[_0x486c('0x92')]('`unreadMessages`\x20>\x200');}}}});}db[_0x486c('0x9b')][_0x486c('0x3d')](_0x1bdd24[_0x486c('0x86')](),_0x4ab36e)[_0x486c('0x28')](function(_0xf8e58a){_0x7183f5[_0x486c('0x21')]=_0xf8e58a[_0x486c('0x6e')];if(_0x7183f5[_0x486c('0x21')]===0x0)return[];return db['sequelize'][_0x486c('0x3d')](_0x3e8db9[_0x486c('0x86')](),_0x4ab36e)['then'](function(_0x2ac038){_0x24b730=_[_0x486c('0x9c')](_0x2ac038,'id');_0x4ab36e=_[_0x486c('0x9d')](_0x4ab36e,{'model':db[_0x486c('0x33')],'mapToModel':!![],'raw':!![],'nest':!![]});_0x125e57['field'](_0x486c('0x91'),_0x486c('0x6c'));_0x125e57[_0x486c('0x49')](_0x486c('0x9e'),_0x486c('0x9f'));_0x125e57[_0x486c('0x49')](_0x486c('0x8c'));_0x125e57[_0x486c('0x49')](_0x486c('0xa0'));_0x125e57['field']('i.updatedAt');_0x125e57[_0x486c('0x49')]('i.closed');_0x125e57['field'](_0x486c('0xa1'));_0x125e57[_0x486c('0x49')](_0x486c('0xa2'));_0x125e57[_0x486c('0x49')]('i.lastMsgAt');_0x125e57[_0x486c('0x49')](_0x486c('0xa3'));_0x125e57[_0x486c('0x49')](_0x486c('0xa4'));_0x125e57['field'](_0x486c('0xa5'));_0x125e57[_0x486c('0x49')](_0x486c('0xa6'));_0x125e57[_0x486c('0x49')]('i.to');_0x125e57[_0x486c('0x49')]('i.ContactId');_0x125e57[_0x486c('0x49')](_0x486c('0xa7'));_0x125e57[_0x486c('0x49')](_0x486c('0xa8'));_0x125e57[_0x486c('0x49')](_0x486c('0x73'),_0x486c('0xa9'));_0x125e57[_0x486c('0x49')](_0x486c('0xaa'),_0x486c('0xab'));_0x125e57['field']('c.email',_0x486c('0xac'));_0x125e57['field'](_0x486c('0xad'),_0x486c('0xae'));_0x125e57['field']('c.mobile',_0x486c('0xaf'));_0x125e57[_0x486c('0x49')](_0x486c('0xb0'),_0x486c('0xb1'));_0x125e57[_0x486c('0x49')](_0x486c('0xb2'),_0x486c('0x2f'));_0x125e57[_0x486c('0x53')](_0x486c('0x9a'),'it',_0x486c('0x97'));_0x125e57[_0x486c('0x53')](_0x486c('0x4b'),'t','t.id\x20=\x20it.TagId');_0x125e57[_0x486c('0x42')](_0xe0f26f['limit']);_0x125e57[_0x486c('0x22')](_0xe0f26f[_0x486c('0x22')]);return db[_0x486c('0x9b')][_0x486c('0x3d')](_0x125e57[_0x486c('0x86')](),_0x4ab36e);})[_0x486c('0x28')](function(_0x449748){_0xc5d311[_0x486c('0x45')](_0x486c('0xb3'),_[_0x486c('0x2e')](_0x449748,'id'));return db[_0x486c('0x9b')]['query'](_0xc5d311[_0x486c('0x86')](),_0x4ab36e)[_0x486c('0x28')](function(_0x53a4ff){var _0x2c2a96=_[_0x486c('0xb4')](_0x53a4ff,_0x486c('0xb5'));var _0x59d3f7=[];return db[_0x486c('0xb6')][_0x486c('0x34')]({'attributes':[_0x486c('0xb7')],'raw':!![]})[_0x486c('0x28')](function(_0x51c6e5){var _0x27a4ac=_0x51c6e5[_0x486c('0xb7')];_0x449748['forEach'](function(_0x4b4cb6){_0x59d3f7['push'](updateMailInteraction(_0x4b4cb6,_0x24b730,_0x2c2a96,_0x27a4ac));});return BPromise[_0x486c('0xb8')](_0x59d3f7);});});});})[_0x486c('0x28')](function(_0x34b49c){_0x7183f5[_0x486c('0xb9')]=_0x34b49c;return _0x7183f5;})[_0x486c('0x28')](respondWithFilteredResult(_0x4a8098,_0xe0f26f))[_0x486c('0x39')](handleError(_0x4a8098,null));};exports[_0x486c('0xba')]=function(_0x59dbb9,_0x464961){var _0xeccd87={'raw':![],'where':{'id':_0x59dbb9[_0x486c('0xbb')]['id']}},_0x4f5727={};_0x4f5727[_0x486c('0x3f')]=_['keys'](db[_0x486c('0x33')][_0x486c('0x3b')]);_0x4f5727[_0x486c('0x3d')]=_[_0x486c('0x3c')](_0x59dbb9[_0x486c('0x3d')]);_0x4f5727[_0x486c('0x46')]=_['intersection'](_0x4f5727['model'],_0x4f5727[_0x486c('0x3d')]);_0xeccd87['attributes']=_[_0x486c('0x3e')](_0x4f5727[_0x486c('0x3f')],qs[_0x486c('0xbc')](_0x59dbb9[_0x486c('0x3d')][_0x486c('0xbc')]));_0xeccd87[_0x486c('0x40')]=_0xeccd87[_0x486c('0x40')][_0x486c('0x6e')]?_0xeccd87[_0x486c('0x40')]:_0x4f5727[_0x486c('0x3f')];if(_0x59dbb9[_0x486c('0x3d')][_0x486c('0xbd')]){_0xeccd87['include']=[{'all':!![]}];}_0xeccd87=_[_0x486c('0x9d')]({},_0xeccd87,_0x59dbb9[_0x486c('0xbe')]);return db[_0x486c('0x33')][_0x486c('0xbf')](_0xeccd87)[_0x486c('0x28')](handleEntityNotFound(_0x464961,null))['then'](respondWithResult(_0x464961,null))['catch'](handleError(_0x464961,null));};exports[_0x486c('0xc0')]=function(_0xce443b,_0x4df9eb){return db[_0x486c('0x33')][_0x486c('0xc0')](_0xce443b[_0x486c('0xc1')],{})[_0x486c('0x28')](respondWithResult(_0x4df9eb,0xc9))[_0x486c('0x39')](handleError(_0x4df9eb,null));};exports[_0x486c('0x27')]=function(_0x163366,_0x201a72){if(_0x163366[_0x486c('0xc1')]['id']){delete _0x163366[_0x486c('0xc1')]['id'];}return db[_0x486c('0x33')][_0x486c('0xbf')]({'where':{'id':_0x163366[_0x486c('0xbb')]['id']}})[_0x486c('0x28')](handleEntityNotFound(_0x201a72,null))[_0x486c('0x28')](saveUpdates(_0x163366[_0x486c('0xc1')],null))[_0x486c('0x28')](respondWithResult(_0x201a72,null))['catch'](handleError(_0x201a72,null));};exports['destroy']=function(_0x25968a,_0x449810){return db['MailInteraction'][_0x486c('0xbf')]({'where':{'id':_0x25968a[_0x486c('0xbb')]['id']}})[_0x486c('0x28')](handleEntityNotFound(_0x449810,null))['then'](removeEntity(_0x449810,null))[_0x486c('0x39')](handleError(_0x449810,null));};exports[_0x486c('0xc2')]=function(_0x2e27d3,_0x52457a){return db[_0x486c('0x33')][_0x486c('0xc2')]()['then'](respondWithResult(_0x52457a,null))[_0x486c('0x39')](handleError(_0x52457a,null));};exports[_0x486c('0xc3')]=function(_0x3bc39a,_0x336ab6,_0x4bec60){return db[_0x486c('0xc4')]['find']({'where':{'id':_0x3bc39a['params']['id']}})['then'](handleEntityNotFound(_0x336ab6,null))[_0x486c('0x28')](function(_0x4d8558){if(_0x4d8558){return _0x4d8558['addMessage'](_0x3bc39a[_0x486c('0xc1')][_0x486c('0xc5')],_[_0x486c('0xc6')](_0x3bc39a[_0x486c('0xc1')],[_0x486c('0xc5'),'id'])||{});}})[_0x486c('0x28')](respondWithResult(_0x336ab6,null))[_0x486c('0x39')](handleError(_0x336ab6,null));};exports['getMessages']=function(_0x56f784,_0x421e14,_0x245f45){var _0x13ffbe={'raw':![],'where':{}};var _0x511ee3={};var _0x3e688b={'count':0x0,'rows':[]};return db[_0x486c('0x33')]['findOne']({'where':{'id':_0x56f784['params']['id']}})[_0x486c('0x28')](handleEntityNotFound(_0x421e14,null))[_0x486c('0x28')](function(_0x58b1b4){if(_0x58b1b4){_0x511ee3['model']=_[_0x486c('0x3c')](db[_0x486c('0xc4')][_0x486c('0x3b')]);_0x511ee3[_0x486c('0x3d')]=_[_0x486c('0x3c')](_0x56f784[_0x486c('0x3d')]);_0x511ee3[_0x486c('0x46')]=_[_0x486c('0x3e')](_0x511ee3[_0x486c('0x3f')],_0x511ee3[_0x486c('0x3d')]);_0x13ffbe[_0x486c('0x40')]=_['intersection'](_0x511ee3[_0x486c('0x3f')],qs[_0x486c('0xbc')](_0x56f784['query']['fields']));_0x13ffbe['attributes']=_0x13ffbe['attributes'][_0x486c('0x6e')]?_0x13ffbe[_0x486c('0x40')]:_0x511ee3[_0x486c('0x3f')];if(!_0x56f784['query'][_0x486c('0x79')](_0x486c('0x41'))){_0x13ffbe['limit']=qs[_0x486c('0x42')](_0x56f784[_0x486c('0x3d')][_0x486c('0x42')]);_0x13ffbe['offset']=qs[_0x486c('0x22')](_0x56f784[_0x486c('0x3d')][_0x486c('0x22')]);}_0x13ffbe[_0x486c('0x43')]=qs[_0x486c('0x44')](_0x56f784[_0x486c('0x3d')][_0x486c('0x44')]);_0x13ffbe[_0x486c('0x45')]=qs[_0x486c('0x46')](_[_0x486c('0x47')](_0x56f784[_0x486c('0x3d')],_0x511ee3[_0x486c('0x46')]));_0x13ffbe['where'][_0x486c('0xb5')]=_0x58b1b4['id'];if(_0x56f784[_0x486c('0x3d')]['filter']){_0x13ffbe[_0x486c('0x45')]=_[_0x486c('0x9d')](_0x13ffbe[_0x486c('0x45')],{'$or':_[_0x486c('0x2e')](_0x13ffbe[_0x486c('0x40')],function(_0x20930b){var _0x1febe9={};_0x1febe9[_0x20930b]={'$like':'%'+_0x56f784[_0x486c('0x3d')][_0x486c('0x7a')]+'%'};return _0x1febe9;})});}if(_0x56f784[_0x486c('0x3d')][_0x486c('0x7e')]){var _0x1d9689=_0x56f784[_0x486c('0x3d')][_0x486c('0x7e')][_0x486c('0x31')](',');var _0x3d0203={};_0x3d0203[_0x1d9689[0x0]]={'$gte':moment(_0x1d9689[0x1])[_0x486c('0x66')]('YYYY-MM-DD\x20HH:mm:ss')};_0x13ffbe[_0x486c('0x45')]=_['merge'](_0x13ffbe['where'],_0x3d0203);}_0x13ffbe=_['merge']({},_0x13ffbe,_0x56f784[_0x486c('0xbe')]);return db[_0x486c('0xc4')][_0x486c('0x21')]({'where':_0x13ffbe[_0x486c('0x45')]})[_0x486c('0x28')](function(_0x3d7b98){_0x3e688b[_0x486c('0x21')]=_0x3d7b98;if(_0x56f784[_0x486c('0x3d')][_0x486c('0xbd')]){_0x13ffbe[_0x486c('0xc7')]=[{'all':!![]}];}return db[_0x486c('0xc4')][_0x486c('0xc8')](_0x13ffbe);})[_0x486c('0x28')](function(_0x58aee6){_0x3e688b[_0x486c('0xb9')]=_0x58aee6;return _0x3e688b;});}})[_0x486c('0x28')](respondWithFilteredResult(_0x421e14,_0x13ffbe))[_0x486c('0x39')](handleError(_0x421e14,null));};exports[_0x486c('0xc9')]=function(_0x1f05f9,_0x391048,_0x2c15eb){return db['MailInteraction'][_0x486c('0xbf')]({'where':{'id':_0x1f05f9['params']['id']}})[_0x486c('0x28')](handleEntityNotFound(_0x391048,null))[_0x486c('0x28')](function(_0x3bb97f){if(_0x3bb97f){return _0x3bb97f[_0x486c('0xca')](_0x1f05f9[_0x486c('0xc1')]['ids'],_[_0x486c('0xc6')](_0x1f05f9['body'],[_0x486c('0xc5'),'id'])||{})['spread'](function(){return db[_0x486c('0xcb')][_0x486c('0xc8')]({'attributes':['id','name','color'],'where':{'id':_0x1f05f9[_0x486c('0xc1')][_0x486c('0xc5')]}});})[_0x486c('0x28')](function(_0x58ab39){socket['emit'](_0x486c('0xcc'),{'id':Number(_0x1f05f9[_0x486c('0xbb')]['id']),'tags':_0x58ab39||[]});return{'id':Number(_0x1f05f9['params']['id']),'tags':_0x58ab39||[]};});}})[_0x486c('0x28')](respondWithResult(_0x391048,null))['catch'](handleError(_0x391048,null));};exports[_0x486c('0xcd')]=function(_0x59a11d,_0x4699d9,_0x4ca191){return db[_0x486c('0x33')][_0x486c('0xbf')]({'where':{'id':_0x59a11d[_0x486c('0xbb')]['id']}})['then'](handleEntityNotFound(_0x4699d9,null))[_0x486c('0x28')](function(_0x471d35){if(_0x471d35){return _0x471d35[_0x486c('0xcd')](_0x59a11d[_0x486c('0x3d')][_0x486c('0xc5')]);}})[_0x486c('0x28')](respondWithStatusCode(_0x4699d9,null))['catch'](handleError(_0x4699d9,null));};exports[_0x486c('0xce')]=function(_0x51297c,_0x585000){var _0x3bb576=moment()['unix']()['toString']();var _0x135f2c=path['join'](config['root'],_0x486c('0xcf'),'files','attachments');var _0x34338a=path[_0x486c('0x87')](config[_0x486c('0xd0')],_0x486c('0xcf'),_0x486c('0xd1'),_0x486c('0xd2'));var _0x1de614=path[_0x486c('0x87')](_0x34338a,_0x3bb576);var _0x59d970=util[_0x486c('0x66')](_0x486c('0xd3'),_0x3bb576);var _0x117554=path[_0x486c('0x87')](_0x34338a,_0x59d970);var _0x4bcc89=![];return db[_0x486c('0x33')][_0x486c('0xbf')]({'where':{'id':_0x51297c[_0x486c('0xbb')]['id']}})[_0x486c('0x28')](handleEntityNotFound(_0x585000,null))[_0x486c('0x28')](function(_0x83b31){if(_0x83b31){return _0x83b31[_0x486c('0xd4')]({'attributes':['id',_0x486c('0xc1'),_0x486c('0x4d'),'to','cc',_0x486c('0xd5'),'subject','createdAt'],'where':{'secret':![]},'include':_0x51297c[_0x486c('0x3d')][_0x486c('0xd6')]?[{'model':db[_0x486c('0xd7')],'as':'Attachments'}]:undefined,'order':qs[_0x486c('0x44')]('id')});}return[];})[_0x486c('0x28')](function(_0x3e02fc){_0x4bcc89=_0x3e02fc['length'];if(_0x3e02fc[_0x486c('0x6e')]){fs[_0x486c('0xd8')](_0x1de614);return BPromise[_0x486c('0xd9')](_0x3e02fc,function(_0x488a6d,_0x3a06e5){var _0x429dad=_0x488a6d;var _0x2f78d1={'from':_0x429dad['from'],'to':_0x429dad['to'],'subject':_0x429dad['subject'],'html':_0x429dad[_0x486c('0xc1')],'headers':{'Date':moment(_0x429dad['createdAt'])[_0x486c('0x66')](_0x486c('0xda'))},'attachments':[]};if(_0x488a6d['cc']){_0x2f78d1[_0x486c('0xdb')]['Cc']=_0x488a6d['cc'];}if(_0x488a6d[_0x486c('0xd5')]){_0x2f78d1[_0x486c('0xdb')][_0x486c('0xdc')]=_0x488a6d[_0x486c('0xd5')];}return new BPromise(function(_0x173e93,_0x88d52c){if(_0x488a6d[_0x486c('0xdd')]){for(var _0x122946=0x0;_0x122946<_0x488a6d[_0x486c('0xdd')][_0x486c('0x6e')];_0x122946++){var _0x3c6a3c=_0x488a6d[_0x486c('0xdd')][_0x122946];var _0x1997fc=path['join'](_0x135f2c,_0x3c6a3c['basename']);if(fs['existsSync'](_0x1997fc)){_0x2f78d1['attachments'][_0x486c('0x32')]({'name':_0x3c6a3c[_0x486c('0x2b')],'contentType':_0x3c6a3c[_0x486c('0xde')],'data':fs[_0x486c('0xdf')](_0x1997fc)});}}}emlformat[_0x486c('0xe0')](_0x2f78d1,function(_0x3795e5,_0xfb53e0){if(_0x3795e5)return _0x88d52c(_0x3795e5);fs['writeFileSync'](path[_0x486c('0x87')](_0x1de614,util['format'](_0x486c('0xe1'),_0x3a06e5)),_0xfb53e0);return _0x173e93(_0xfb53e0);});});});}})['then'](function(){if(_0x4bcc89){return new BPromise(function(_0x56b138,_0x1e7b57){zipdir(_0x1de614,{'saveTo':_0x117554},function(_0x1aa4b5,_0x2f230c){if(_0x1aa4b5)return _0x1e7b57(_0x1aa4b5);return _0x56b138(_0x2f230c);});});}})[_0x486c('0x28')](function(){if(_0x4bcc89){return new BPromise(function(_0x2fad81,_0x2092a8){rimraf(_0x1de614,function(_0x2b6d6f){if(_0x2b6d6f)_0x2092a8(_0x2b6d6f);return _0x2fad81();});});}})[_0x486c('0x28')](function(){if(_0x4bcc89){return _0x585000[_0x486c('0xce')](_0x117554,_0x59d970,function(_0x15cb72){if(_0x15cb72){console[_0x486c('0xe2')](_0x486c('0xe3'),_0x15cb72);}else{fs[_0x486c('0xe4')](_0x117554);}});}else{return _0x585000[_0x486c('0x1e')](0xc8);}})[_0x486c('0x39')](handleError(_0x585000,null));};
\ No newline at end of file
+var _0xde1a=['tmp','subject','Attachment','Attachments','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','bcc','Bcc','existsSync','type','build','writeFileSync','log','err','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','ejs','lodash','squel','crypto','to-csv','papaparse','html-to-text','ioredis','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','register','sendStatus','status','count','offset','set','json','apply','reject','save','then','error','stack','name','Users','map','TagIds','Tags','split','forEach','MailInteraction','findOne','lastMsgText','fromString','lastMsgBody','catch','index','rawAttributes','model','keys','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','sort','field','color','from','tools_tags','COUNT(*)','mail_messages','me.MailInteractionId\x20=\x20i.id','where','me.read\x20=\x20false','select','u.id','ui.MailInteractionId','user_has_mail_interactions','left_join','users','u.id\x20=\x20ui.UserId','mail_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','mail_accounts','a.id\x20=\x20i.MailAccountId','me.MailInteractionId\x20=\x20i.id\x20AND\x20me.direction\x20=\x20\x27in\x27\x20AND\x20me.read\x20=\x20false','expr','parse','advancedFilter','createdAt','dateStart','startOf','utc','format','endOf','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','condition','value','TagId','unreadMessages','isArray','length','and','tableAlias','\x20IN\x20?','\x20=\x20?','LIKE','ContactId','c.firstName','\x20LIKE\x20?','c.lastName','c.email','\x20<\x20?','filter','isNil','isEmpty','concat','\x20IS\x20NULL','replace','\x27\x27\x27\x27','isNumeric','i.id\x20LIKE\x20?','isEmail','push','toString','join','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','order','DESC','group','i.id','Sequelize','QueryTypes','SELECT','clone','read','having','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','t.id\x20IN\x20?','sequelize','keyBy','merge','COUNT(me.id)','i.createdAt','i.updatedAt','i.closedAt','i.attach','i.lastMsgDirection','i.subject','i.substatus','i.to','i.ContactId','i.MailAccountId','i.UserId','Contact.firstName','Contact.lastName','Contact.email','c.phone','Contact.phone','Contact.mobile','c.fax','Contact.fax','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','Setting','enableEmailPreview','rows','show','params','includeAll','options','find','create','update','body','describe','addMessage','MailMessage','ids','omit','getMessages','$gte','YYYY-MM-DD\x20HH:mm:ss','include','addTags','spread','Tag','findAll','emit','mailInteractionTags:save','removeTags','download','unix','root','files','server'];(function(_0x1e7714,_0x33d293){var _0x484364=function(_0x5dbec2){while(--_0x5dbec2){_0x1e7714['push'](_0x1e7714['shift']());}};_0x484364(++_0x33d293);}(_0xde1a,0xeb));var _0xade1=function(_0x3b997e,_0x92c5ef){_0x3b997e=_0x3b997e-0x0;var _0x34fcb9=_0xde1a[_0x3b997e];return _0x34fcb9;};'use strict';var pdf=require(_0xade1('0x0'));var emlformat=require(_0xade1('0x1'));var rimraf=require(_0xade1('0x2'));var zipdir=require(_0xade1('0x3'));var jsonpatch=require(_0xade1('0x4'));var rp=require(_0xade1('0x5'));var moment=require(_0xade1('0x6'));var BPromise=require(_0xade1('0x7'));var Mustache=require(_0xade1('0x8'));var util=require(_0xade1('0x9'));var path=require('path');var sox=require(_0xade1('0xa'));var csv=require('to-csv');var ejs=require(_0xade1('0xb'));var fs=require('fs');var _=require(_0xade1('0xc'));var squel=require(_0xade1('0xd'));var crypto=require(_0xade1('0xe'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xade1('0xf'));var querystring=require('querystring');var Papa=require(_0xade1('0x10'));var htmlToText=require(_0xade1('0x11'));var Redis=require(_0xade1('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xade1('0x13'));var hardwareService=require(_0xade1('0x14'));var logger=require('../../config/logger')(_0xade1('0x15'));var utils=require(_0xade1('0x16'));var config=require(_0xade1('0x17'));var db=require(_0xade1('0x18'))['db'];config[_0xade1('0x19')]=_[_0xade1('0x1a')](config['redis'],{'host':_0xade1('0x1b'),'port':0x18eb});var socket=require(_0xade1('0x1c'))(new Redis(config[_0xade1('0x19')]));require(_0xade1('0x1d'))[_0xade1('0x1e')](socket);function respondWithStatusCode(_0x3f525e,_0x4a3e57){_0x4a3e57=_0x4a3e57||0xcc;return function(_0x577787){if(_0x577787){return _0x3f525e[_0xade1('0x1f')](_0x4a3e57);}return _0x3f525e[_0xade1('0x20')](_0x4a3e57)['end']();};}function respondWithResult(_0x3cb3d1,_0x4ba5a2){_0x4ba5a2=_0x4ba5a2||0xc8;return function(_0x557fe4){if(_0x557fe4){return _0x3cb3d1['status'](_0x4ba5a2)['json'](_0x557fe4);}};}function respondWithFilteredResult(_0xe54214,_0x4acf13){return function(_0x82a772){if(_0x82a772){var _0x4c48af=_0x82a772[_0xade1('0x21')],_0x31ed86=_0x4acf13[_0xade1('0x22')],_0xbeceb1=_0x4acf13[_0xade1('0x22')]+_0x4acf13['limit'],_0x16a264;if(_0xbeceb1>=_0x4c48af){_0xbeceb1=_0x4c48af;_0x16a264=0xc8;}else{_0x16a264=0xce;}_0xe54214[_0xade1('0x20')](_0x16a264);return _0xe54214[_0xade1('0x23')]('Content-Range',_0x31ed86+'-'+_0xbeceb1+'/'+_0x4c48af)[_0xade1('0x24')](_0x82a772);}return null;};}function patchUpdates(_0x1524e1){return function(_0x4e0855){try{jsonpatch[_0xade1('0x25')](_0x4e0855,_0x1524e1,!![]);}catch(_0x122947){return BPromise[_0xade1('0x26')](_0x122947);}return _0x4e0855[_0xade1('0x27')]();};}function saveUpdates(_0x2a6f2b,_0x298144){return function(_0x5b6e09){if(_0x5b6e09){return _0x5b6e09['update'](_0x2a6f2b)['then'](function(_0x50ed64){return _0x50ed64;});}return null;};}function removeEntity(_0x35f3a7,_0x1ae56c){return function(_0x41b4b9){if(_0x41b4b9){return _0x41b4b9['destroy']()[_0xade1('0x28')](function(){_0x35f3a7[_0xade1('0x20')](0xcc)['end']();});}};}function handleEntityNotFound(_0x572f41,_0x4b6838){return function(_0x502ad1){if(!_0x502ad1){_0x572f41['sendStatus'](0x194);}return _0x502ad1;};}function handleError(_0x4c0217,_0x270257){_0x270257=_0x270257||0x1f4;return function(_0xcc41d0){logger[_0xade1('0x29')](_0xcc41d0[_0xade1('0x2a')]);if(_0xcc41d0[_0xade1('0x2b')]){delete _0xcc41d0[_0xade1('0x2b')];}_0x4c0217[_0xade1('0x20')](_0x270257)['send'](_0xcc41d0);};}function getInteractionUsers(_0x3bebed,_0x4ddf75){return new BPromise(function(_0x415f2b,_0x16f60d){try{if(_0x4ddf75[_0x3bebed['id']]){_0x3bebed[_0xade1('0x2c')]=_[_0xade1('0x2d')](_0x4ddf75[_0x3bebed['id']],function(_0x5b4e0e){return{'id':_0x5b4e0e['id']};});}}catch(_0x572001){_0x16f60d(_0x572001);}_0x415f2b(_0x3bebed);});}function getInteractionTags(_0x244a8c,_0x32e191){return new BPromise(function(_0x358cb9,_0x5905a1){try{if(_0x244a8c[_0xade1('0x2e')]){_0x244a8c[_0xade1('0x2f')]=[];_0x244a8c['TagIds'][_0xade1('0x30')](',')[_0xade1('0x31')](function(_0xedbcfa){_0x244a8c['Tags']['push'](_0x32e191[_0xedbcfa]);});}delete _0x244a8c[_0xade1('0x2e')];}catch(_0x9bcbae){_0x5905a1(_0x9bcbae);}_0x358cb9(_0x244a8c);});}function getLastMessageText(_0x5c84e4){return new BPromise(function(_0x3baebb,_0x721e1c){return db[_0xade1('0x32')][_0xade1('0x33')]({'where':{'id':_0x5c84e4['id']},'attributes':['lastMsgBody','lastMsgText'],'raw':!![]})[_0xade1('0x28')](function(_0x3b085c){if(!_0x3b085c[_0xade1('0x34')]){_0x5c84e4[_0xade1('0x34')]=_['trimStart'](htmlToText[_0xade1('0x35')](_0x3b085c[_0xade1('0x36')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x5c84e4['lastMsgText']=_0x3b085c[_0xade1('0x34')];}_0x3baebb(_0x5c84e4);})[_0xade1('0x37')](function(_0x363977){_0x721e1c(_0x363977);});});}function updateMailInteraction(_0xbccfba,_0x205d77,_0x14adaf,_0xeca6eb){return new BPromise(function(_0x1189f7,_0x290a53){return getInteractionUsers(_0xbccfba,_0x14adaf)[_0xade1('0x28')](function(_0x496067){return getInteractionTags(_0x496067,_0x205d77);})['then'](function(_0x361a28){if(_0xeca6eb){_0x1189f7(getLastMessageText(_0x361a28));}else{_0x1189f7(_0x361a28);}})[_0xade1('0x37')](function(_0x3bc628){_0x290a53(_0x3bc628);});});}exports[_0xade1('0x38')]=function(_0xbb4487,_0x3f599f){var _0x4efa5d={},_0x204fa3={},_0x37cf06={'count':0x0,'rows':[]};var _0x38c574=db[_0xade1('0x32')][_0xade1('0x39')];_0x204fa3[_0xade1('0x3a')]=_[_0xade1('0x3b')](_0x38c574);_0x204fa3['query']=_['keys'](_0xbb4487[_0xade1('0x3c')]);_0x204fa3[_0xade1('0x3d')]=_[_0xade1('0x3e')](_0x204fa3[_0xade1('0x3a')],_0x204fa3[_0xade1('0x3c')]);_0x4efa5d[_0xade1('0x3f')]=_['intersection'](_0x204fa3[_0xade1('0x3a')],qs['fields'](_0xbb4487[_0xade1('0x3c')][_0xade1('0x40')]));_0x4efa5d[_0xade1('0x3f')]=_0x4efa5d[_0xade1('0x3f')]['length']?_0x4efa5d[_0xade1('0x3f')]:_0x204fa3[_0xade1('0x3a')];if(!_0xbb4487[_0xade1('0x3c')][_0xade1('0x41')](_0xade1('0x42'))){_0x4efa5d[_0xade1('0x43')]=qs[_0xade1('0x43')](_0xbb4487[_0xade1('0x3c')][_0xade1('0x43')]);_0x4efa5d[_0xade1('0x22')]=qs[_0xade1('0x22')](_0xbb4487[_0xade1('0x3c')][_0xade1('0x22')]);}_0x4efa5d['order']=qs[_0xade1('0x44')](_0xbb4487['query'][_0xade1('0x44')]);_0x4efa5d['where']=qs[_0xade1('0x3d')](_['pick'](_0xbb4487[_0xade1('0x3c')],_0x204fa3[_0xade1('0x3d')]));var _0x28741e=[];var _0x231595=squel['select']()[_0xade1('0x45')]('id')[_0xade1('0x45')](_0xade1('0x2b'))[_0xade1('0x45')](_0xade1('0x46'))[_0xade1('0x47')](_0xade1('0x48'));var _0x5eb561=squel['select']()['field'](_0xade1('0x49'))[_0xade1('0x47')](_0xade1('0x4a'),'me')['where'](_0xade1('0x4b'))['where']('me.direction\x20=\x20\x27in\x27')[_0xade1('0x4c')](_0xade1('0x4d'));var _0x49c547=squel[_0xade1('0x4e')]()[_0xade1('0x45')](_0xade1('0x4f'))['field'](_0xade1('0x50'))[_0xade1('0x47')](_0xade1('0x51'),'ui')[_0xade1('0x52')](_0xade1('0x53'),'u',_0xade1('0x54'));var _0x5675f2=squel[_0xade1('0x4e')]()[_0xade1('0x47')](_0xade1('0x55'),'i')[_0xade1('0x52')](_0xade1('0x56'),'c',_0xade1('0x57'))[_0xade1('0x52')](_0xade1('0x53'),'o','o.id\x20=\x20i.UserId')['left_join'](_0xade1('0x58'),'a',_0xade1('0x59'))[_0xade1('0x52')](_0xade1('0x4a'),'me',_0xade1('0x5a'));var _0x44307e=squel[_0xade1('0x5b')]();if(_0xbb4487[_0xade1('0x3c')]['advancedFilter']){var _0x1de4de=JSON[_0xade1('0x5c')](_0xbb4487[_0xade1('0x3c')][_0xade1('0x5d')]);_[_0xade1('0x3b')](_0x1de4de)['forEach'](function(_0x225b22){var _0x417dc6=_0x1de4de[_0x225b22];if(_0x225b22===_0xade1('0x5e')){var _0x1c7a85=moment(_0x417dc6['value'][_0xade1('0x5f')])[_0xade1('0x60')]('day')[_0xade1('0x61')]()[_0xade1('0x62')]();var _0x34a165=moment(_0x34a165)[_0xade1('0x61')]()[_0xade1('0x63')]('day')[_0xade1('0x62')]();_0x44307e['and'](_0xade1('0x64'),_0x1c7a85,_0x34a165);}else{if(_['isArray'](_0x417dc6[_0xade1('0x65')])){_0x417dc6['condition'][_0xade1('0x31')](function(_0x40568e){switch(_0x417dc6[_0xade1('0x65')][_0xade1('0x66')]){case'IS':if(_0x225b22!==_0xade1('0x67')&&_0x225b22!==_0xade1('0x68')){if(_[_0xade1('0x69')](_0x417dc6[_0xade1('0x66')])&&_0x417dc6['value'][_0xade1('0x6a')]>0x1){_0x44307e[_0xade1('0x6b')](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+_0xade1('0x6d'),_0x417dc6[_0xade1('0x66')]);}else{_0x44307e['and'](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+_0xade1('0x6e'),_0x417dc6[_0xade1('0x66')][0x0]);}}break;case'=':_0x44307e[_0xade1('0x6b')](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+_0xade1('0x6e'),_0x417dc6[_0xade1('0x66')]);break;case _0xade1('0x6f'):if(_0x225b22===_0xade1('0x70')){_0x44307e[_0xade1('0x6b')](_0xade1('0x71')+_0xade1('0x72'),'%'+_0x417dc6[_0xade1('0x66')]+'%');_0x44307e['or']('c.lastName'+'\x20LIKE\x20?','%'+_0x417dc6[_0xade1('0x66')]+'%');_0x44307e['or']('c.email'+'\x20LIKE\x20?','%'+_0x417dc6[_0xade1('0x66')]+'%');}else{_0x44307e[_0xade1('0x6b')](_0x417dc6['tableAlias']+'.'+_0x225b22+_0xade1('0x72'),'%'+_0x417dc6[_0xade1('0x66')]+'%');}break;case'>':_0x44307e[_0xade1('0x6b')](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+'\x20>\x20?',_0x417dc6[_0xade1('0x66')]);break;case'<':_0x44307e[_0xade1('0x6b')](_0x417dc6['tableAlias']+'.'+_0x225b22+'\x20<\x20?',_0x417dc6[_0xade1('0x66')]);break;}});}else{switch(_0x417dc6[_0xade1('0x65')][_0xade1('0x66')]){case'IS':if(_0x225b22!==_0xade1('0x67')&&_0x225b22!==_0xade1('0x68')){if(_[_0xade1('0x69')](_0x417dc6['value'])&&_0x417dc6['value']['length']>0x1){_0x44307e[_0xade1('0x6b')](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+_0xade1('0x6d'),_0x417dc6['value']);}else{_0x44307e['and'](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+_0xade1('0x6e'),_0x417dc6[_0xade1('0x66')][0x0]);}}break;case'=':_0x44307e[_0xade1('0x6b')](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+_0xade1('0x6e'),_0x417dc6[_0xade1('0x66')]);break;case _0xade1('0x6f'):if(_0x225b22===_0xade1('0x70')){_0x44307e[_0xade1('0x6b')](_0xade1('0x71')+'\x20LIKE\x20?','%'+_0x417dc6[_0xade1('0x66')]+'%');_0x44307e['or'](_0xade1('0x73')+'\x20LIKE\x20?','%'+_0x417dc6['value']+'%');_0x44307e['or'](_0xade1('0x74')+_0xade1('0x72'),'%'+_0x417dc6[_0xade1('0x66')]+'%');}else{_0x44307e['and'](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+'\x20LIKE\x20?','%'+_0x417dc6['value']+'%');}break;case'>':_0x44307e[_0xade1('0x6b')](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+'\x20>\x20?',_0x417dc6['value']);break;case'<':_0x44307e['and'](_0x417dc6[_0xade1('0x6c')]+'.'+_0x225b22+_0xade1('0x75'),_0x417dc6['value']);break;}}}});}else{var _0x2e3b3b=_(Object[_0xade1('0x3b')](_0xbb4487[_0xade1('0x3c')]))[_0xade1('0x2d')](function(_0x3c75d3){return _0x38c574[_0xade1('0x41')](_0x3c75d3)?_0x3c75d3:undefined;})[_0xade1('0x76')](function(_0x99c46b){return!_[_0xade1('0x77')](_0x99c46b);})['value']();if(!_[_0xade1('0x78')](_0x2e3b3b)){_0x2e3b3b['forEach'](function(_0x3d7e95){if(_0x3d7e95==='MailAccountId'){_0x5675f2[_0xade1('0x4c')]('i.MailAccountId\x20IN\x20?',[][_0xade1('0x79')](_0xbb4487[_0xade1('0x3c')][_0x3d7e95]));}else if(_0x3d7e95==='createdAt'){var _0x347537=JSON[_0xade1('0x5c')](_0xbb4487[_0xade1('0x3c')][_0x3d7e95])['$gte'];var _0x38d228=JSON[_0xade1('0x5c')](_0xbb4487[_0xade1('0x3c')][_0x3d7e95])['$lte'];_0x5675f2['where']('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x347537,_0x38d228);}else{if(_0xbb4487[_0xade1('0x3c')][_0x3d7e95]==='null'){_0x5675f2['where']('i.'+_0x3d7e95+_0xade1('0x7a'));}else{_0x5675f2[_0xade1('0x4c')]('i.'+_0x3d7e95+_0xade1('0x6e'),_0xbb4487[_0xade1('0x3c')][_0x3d7e95]);}}});}if(_0xbb4487[_0xade1('0x3c')][_0xade1('0x76')]){var _0x407453=_0xbb4487[_0xade1('0x3c')][_0xade1('0x76')][_0xade1('0x7b')]('\x5c','\x5c\x5c')[_0xade1('0x7b')]('\x27\x27',_0xade1('0x7c'));if(qs[_0xade1('0x7d')](_0x407453)){_0x44307e['or'](_0xade1('0x7e'),_0x407453+'%');}else if(qs[_0xade1('0x7f')](_0x407453)){_0x44307e['or']('c.email\x20LIKE\x20?',_0x407453+'%');}else{var _0x1e17aa=[];_0x407453[_0xade1('0x30')]('\x20')[_0xade1('0x31')](function(_0x3c03c0){_0x1e17aa[_0xade1('0x80')]('+'+_0x3c03c0[_0xade1('0x81')]());});var _0x7f0a98=_0x1e17aa[_0xade1('0x82')]('\x20');_0x44307e['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',_0x7f0a98)['or'](_0xade1('0x83'),_0x7f0a98);}}}_0x5675f2[_0xade1('0x4c')](_0x44307e);if(_0x4efa5d[_0xade1('0x84')]){_0x4efa5d[_0xade1('0x84')][_0xade1('0x31')](function(_0x2b9638){_0x5675f2['order']('i.'+_0x2b9638[0x0],_0x2b9638[0x1]===_0xade1('0x85')?![]:!![]);});}_0x5675f2[_0xade1('0x86')](_0xade1('0x87'));var _0x5aab51={'type':db[_0xade1('0x88')][_0xade1('0x89')][_0xade1('0x8a')],'raw':!![]};var _0x1b2b28=_0x5675f2[_0xade1('0x8b')]()[_0xade1('0x45')](_0xade1('0x49'))[_0xade1('0x45')]('COUNT(me.id)','unreadMessages');if(!_0xbb4487[_0xade1('0x3c')][_0xade1('0x5d')]){if(_0xbb4487[_0xade1('0x3c')]['read']){if(_0xbb4487[_0xade1('0x3c')][_0xade1('0x8c')]==0x1){_0x1b2b28[_0xade1('0x8d')](_0xade1('0x8e'));_0x5675f2[_0xade1('0x8d')](_0xade1('0x8e'));}else{_0x1b2b28['having']('`unreadMessages`\x20>\x200');_0x5675f2[_0xade1('0x8d')](_0xade1('0x8f'));}}if(_0xbb4487[_0xade1('0x3c')][_0xade1('0x90')]){var _0x255bac=_['isArray'](_0xbb4487['query']['tag'])?_0xbb4487['query']['tag']:new Array(_0xbb4487[_0xade1('0x3c')]['tag']);var _0x224a6=squel[_0xade1('0x5b')]();_0x255bac[_0xade1('0x31')](function(_0x9309be){_0x224a6['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x9309be+',%');});_0x5675f2[_0xade1('0x8d')](_0x224a6);_0x1b2b28[_0xade1('0x52')](_0xade1('0x91'),'it',_0xade1('0x92'));_0x1b2b28['left_join'](_0xade1('0x48'),'t',_0xade1('0x93'));_0x1b2b28[_0xade1('0x4c')]('t.id\x20IN\x20?',_0x255bac);}}else{var _0x1de4de=JSON[_0xade1('0x5c')](_0xbb4487[_0xade1('0x3c')][_0xade1('0x5d')]);_[_0xade1('0x3b')](_0x1de4de)[_0xade1('0x31')](function(_0x5157e9){var _0x1729d9=_0x1de4de[_0x5157e9];if(_0x5157e9===_0xade1('0x67')){var _0x13388d=_0x1729d9[_0xade1('0x66')];var _0x4beab1=squel[_0xade1('0x5b')]();_0x13388d[_0xade1('0x31')](function(_0x141ed8){_0x4beab1['or'](_0xade1('0x94'),'%,'+_0x141ed8+',%');});_0x5675f2[_0xade1('0x8d')](_0x4beab1);_0x1b2b28['left_join']('mail_interaction_has_tags','it','it.MailInteractionId\x20=\x20i.id');_0x1b2b28['left_join'](_0xade1('0x48'),'t',_0xade1('0x93'));_0x1b2b28['where'](_0xade1('0x95'),_0x13388d);}else if(_0x5157e9===_0xade1('0x68')){if(_0x1729d9[_0xade1('0x66')][_0xade1('0x6a')]===0x1){if(_0x1729d9[_0xade1('0x66')][0x0]===0x1){_0x1b2b28[_0xade1('0x8d')](_0xade1('0x8e'));_0x5675f2[_0xade1('0x8d')](_0xade1('0x8e'));}else{_0x1b2b28[_0xade1('0x8d')](_0xade1('0x8f'));_0x5675f2[_0xade1('0x8d')](_0xade1('0x8f'));}}}});}db['sequelize'][_0xade1('0x3c')](_0x1b2b28[_0xade1('0x81')](),_0x5aab51)[_0xade1('0x28')](function(_0xff4b33){_0x37cf06[_0xade1('0x21')]=_0xff4b33[_0xade1('0x6a')];if(_0x37cf06[_0xade1('0x21')]===0x0)return[];return db[_0xade1('0x96')][_0xade1('0x3c')](_0x231595[_0xade1('0x81')](),_0x5aab51)[_0xade1('0x28')](function(_0x240d8d){_0x28741e=_[_0xade1('0x97')](_0x240d8d,'id');_0x5aab51=_[_0xade1('0x98')](_0x5aab51,{'model':db[_0xade1('0x32')],'mapToModel':!![],'raw':!![],'nest':!![]});_0x5675f2[_0xade1('0x45')](_0xade1('0x99'),'unreadMessages');_0x5675f2['field']('a.key','Account.key');_0x5675f2['field'](_0xade1('0x87'));_0x5675f2[_0xade1('0x45')](_0xade1('0x9a'));_0x5675f2['field'](_0xade1('0x9b'));_0x5675f2[_0xade1('0x45')]('i.closed');_0x5675f2[_0xade1('0x45')](_0xade1('0x9c'));_0x5675f2[_0xade1('0x45')](_0xade1('0x9d'));_0x5675f2['field']('i.lastMsgAt');_0x5675f2['field'](_0xade1('0x9e'));_0x5675f2[_0xade1('0x45')](_0xade1('0x9f'));_0x5675f2['field']('i.disposition');_0x5675f2[_0xade1('0x45')](_0xade1('0xa0'));_0x5675f2[_0xade1('0x45')](_0xade1('0xa1'));_0x5675f2[_0xade1('0x45')](_0xade1('0xa2'));_0x5675f2[_0xade1('0x45')](_0xade1('0xa3'));_0x5675f2[_0xade1('0x45')](_0xade1('0xa4'));_0x5675f2[_0xade1('0x45')](_0xade1('0x71'),_0xade1('0xa5'));_0x5675f2[_0xade1('0x45')]('c.lastName',_0xade1('0xa6'));_0x5675f2[_0xade1('0x45')](_0xade1('0x74'),_0xade1('0xa7'));_0x5675f2['field'](_0xade1('0xa8'),_0xade1('0xa9'));_0x5675f2['field']('c.mobile',_0xade1('0xaa'));_0x5675f2[_0xade1('0x45')](_0xade1('0xab'),_0xade1('0xac'));_0x5675f2[_0xade1('0x45')](_0xade1('0xad'),'TagIds');_0x5675f2['left_join'](_0xade1('0x91'),'it',_0xade1('0x92'));_0x5675f2[_0xade1('0x52')](_0xade1('0x48'),'t',_0xade1('0x93'));_0x5675f2[_0xade1('0x43')](_0x4efa5d['limit']);_0x5675f2[_0xade1('0x22')](_0x4efa5d[_0xade1('0x22')]);return db[_0xade1('0x96')][_0xade1('0x3c')](_0x5675f2['toString'](),_0x5aab51);})[_0xade1('0x28')](function(_0x4efc5a){_0x49c547[_0xade1('0x4c')](_0xade1('0xae'),_[_0xade1('0x2d')](_0x4efc5a,'id'));return db[_0xade1('0x96')][_0xade1('0x3c')](_0x49c547[_0xade1('0x81')](),_0x5aab51)['then'](function(_0x535d8d){var _0x80fbb8=_['groupBy'](_0x535d8d,'MailInteractionId');var _0x397f9d=[];return db[_0xade1('0xaf')]['findOne']({'attributes':[_0xade1('0xb0')],'raw':!![]})[_0xade1('0x28')](function(_0x2d9c6a){var _0x36469a=_0x2d9c6a['enableEmailPreview'];_0x4efc5a[_0xade1('0x31')](function(_0x1edf06){_0x397f9d[_0xade1('0x80')](updateMailInteraction(_0x1edf06,_0x28741e,_0x80fbb8,_0x36469a));});return BPromise['all'](_0x397f9d);});});});})['then'](function(_0x259098){_0x37cf06[_0xade1('0xb1')]=_0x259098;return _0x37cf06;})[_0xade1('0x28')](respondWithFilteredResult(_0x3f599f,_0x4efa5d))[_0xade1('0x37')](handleError(_0x3f599f,null));};exports[_0xade1('0xb2')]=function(_0x4226e5,_0x5e80ab){var _0x26ca64={'raw':![],'where':{'id':_0x4226e5[_0xade1('0xb3')]['id']}},_0x22bba1={};_0x22bba1[_0xade1('0x3a')]=_[_0xade1('0x3b')](db[_0xade1('0x32')]['rawAttributes']);_0x22bba1['query']=_[_0xade1('0x3b')](_0x4226e5[_0xade1('0x3c')]);_0x22bba1[_0xade1('0x3d')]=_[_0xade1('0x3e')](_0x22bba1[_0xade1('0x3a')],_0x22bba1[_0xade1('0x3c')]);_0x26ca64['attributes']=_[_0xade1('0x3e')](_0x22bba1[_0xade1('0x3a')],qs[_0xade1('0x40')](_0x4226e5[_0xade1('0x3c')][_0xade1('0x40')]));_0x26ca64[_0xade1('0x3f')]=_0x26ca64[_0xade1('0x3f')]['length']?_0x26ca64[_0xade1('0x3f')]:_0x22bba1[_0xade1('0x3a')];if(_0x4226e5[_0xade1('0x3c')][_0xade1('0xb4')]){_0x26ca64['include']=[{'all':!![]}];}_0x26ca64=_['merge']({},_0x26ca64,_0x4226e5[_0xade1('0xb5')]);return db[_0xade1('0x32')][_0xade1('0xb6')](_0x26ca64)[_0xade1('0x28')](handleEntityNotFound(_0x5e80ab,null))[_0xade1('0x28')](respondWithResult(_0x5e80ab,null))[_0xade1('0x37')](handleError(_0x5e80ab,null));};exports[_0xade1('0xb7')]=function(_0x55de26,_0x18a5e7){return db[_0xade1('0x32')][_0xade1('0xb7')](_0x55de26['body'],{})[_0xade1('0x28')](respondWithResult(_0x18a5e7,0xc9))[_0xade1('0x37')](handleError(_0x18a5e7,null));};exports[_0xade1('0xb8')]=function(_0x7b2fa5,_0x31fabb){if(_0x7b2fa5[_0xade1('0xb9')]['id']){delete _0x7b2fa5['body']['id'];}return db[_0xade1('0x32')][_0xade1('0xb6')]({'where':{'id':_0x7b2fa5[_0xade1('0xb3')]['id']}})[_0xade1('0x28')](handleEntityNotFound(_0x31fabb,null))[_0xade1('0x28')](saveUpdates(_0x7b2fa5['body'],null))['then'](respondWithResult(_0x31fabb,null))[_0xade1('0x37')](handleError(_0x31fabb,null));};exports['destroy']=function(_0x969afd,_0x433fca){return db[_0xade1('0x32')][_0xade1('0xb6')]({'where':{'id':_0x969afd['params']['id']}})[_0xade1('0x28')](handleEntityNotFound(_0x433fca,null))[_0xade1('0x28')](removeEntity(_0x433fca,null))[_0xade1('0x37')](handleError(_0x433fca,null));};exports[_0xade1('0xba')]=function(_0x138cd2,_0x176317){return db[_0xade1('0x32')][_0xade1('0xba')]()[_0xade1('0x28')](respondWithResult(_0x176317,null))['catch'](handleError(_0x176317,null));};exports[_0xade1('0xbb')]=function(_0x1041d2,_0x40e734,_0x4b3986){return db[_0xade1('0xbc')]['find']({'where':{'id':_0x1041d2[_0xade1('0xb3')]['id']}})[_0xade1('0x28')](handleEntityNotFound(_0x40e734,null))[_0xade1('0x28')](function(_0x5905a9){if(_0x5905a9){return _0x5905a9[_0xade1('0xbb')](_0x1041d2[_0xade1('0xb9')][_0xade1('0xbd')],_[_0xade1('0xbe')](_0x1041d2[_0xade1('0xb9')],['ids','id'])||{});}})['then'](respondWithResult(_0x40e734,null))['catch'](handleError(_0x40e734,null));};exports[_0xade1('0xbf')]=function(_0x4c46dd,_0x548ed7,_0x1713e1){var _0x8e3296={'raw':![],'where':{}};var _0x53bd8d={};var _0x7ad097={'count':0x0,'rows':[]};return db['MailInteraction'][_0xade1('0x33')]({'where':{'id':_0x4c46dd[_0xade1('0xb3')]['id']}})[_0xade1('0x28')](handleEntityNotFound(_0x548ed7,null))[_0xade1('0x28')](function(_0xeb7ca2){if(_0xeb7ca2){_0x53bd8d['model']=_['keys'](db['MailMessage'][_0xade1('0x39')]);_0x53bd8d[_0xade1('0x3c')]=_[_0xade1('0x3b')](_0x4c46dd[_0xade1('0x3c')]);_0x53bd8d[_0xade1('0x3d')]=_[_0xade1('0x3e')](_0x53bd8d[_0xade1('0x3a')],_0x53bd8d[_0xade1('0x3c')]);_0x8e3296[_0xade1('0x3f')]=_[_0xade1('0x3e')](_0x53bd8d[_0xade1('0x3a')],qs[_0xade1('0x40')](_0x4c46dd[_0xade1('0x3c')]['fields']));_0x8e3296['attributes']=_0x8e3296[_0xade1('0x3f')][_0xade1('0x6a')]?_0x8e3296['attributes']:_0x53bd8d[_0xade1('0x3a')];if(!_0x4c46dd[_0xade1('0x3c')]['hasOwnProperty']('nolimit')){_0x8e3296[_0xade1('0x43')]=qs[_0xade1('0x43')](_0x4c46dd['query'][_0xade1('0x43')]);_0x8e3296['offset']=qs[_0xade1('0x22')](_0x4c46dd[_0xade1('0x3c')][_0xade1('0x22')]);}_0x8e3296['order']=qs[_0xade1('0x44')](_0x4c46dd[_0xade1('0x3c')][_0xade1('0x44')]);_0x8e3296['where']=qs['filters'](_['pick'](_0x4c46dd[_0xade1('0x3c')],_0x53bd8d[_0xade1('0x3d')]));_0x8e3296[_0xade1('0x4c')]['MailInteractionId']=_0xeb7ca2['id'];if(_0x4c46dd[_0xade1('0x3c')]['filter']){_0x8e3296[_0xade1('0x4c')]=_[_0xade1('0x98')](_0x8e3296[_0xade1('0x4c')],{'$or':_[_0xade1('0x2d')](_0x8e3296[_0xade1('0x3f')],function(_0x47d1c9){var _0x71211e={};_0x71211e[_0x47d1c9]={'$like':'%'+_0x4c46dd['query'][_0xade1('0x76')]+'%'};return _0x71211e;})});}if(_0x4c46dd[_0xade1('0x3c')][_0xade1('0xc0')]){var _0x295eb9=_0x4c46dd[_0xade1('0x3c')][_0xade1('0xc0')][_0xade1('0x30')](',');var _0x7effc8={};_0x7effc8[_0x295eb9[0x0]]={'$gte':moment(_0x295eb9[0x1])[_0xade1('0x62')](_0xade1('0xc1'))};_0x8e3296['where']=_[_0xade1('0x98')](_0x8e3296[_0xade1('0x4c')],_0x7effc8);}_0x8e3296=_[_0xade1('0x98')]({},_0x8e3296,_0x4c46dd[_0xade1('0xb5')]);return db[_0xade1('0xbc')][_0xade1('0x21')]({'where':_0x8e3296[_0xade1('0x4c')]})['then'](function(_0x44406d){_0x7ad097[_0xade1('0x21')]=_0x44406d;if(_0x4c46dd[_0xade1('0x3c')][_0xade1('0xb4')]){_0x8e3296[_0xade1('0xc2')]=[{'all':!![]}];}return db[_0xade1('0xbc')]['findAll'](_0x8e3296);})['then'](function(_0x5e590e){_0x7ad097['rows']=_0x5e590e;return _0x7ad097;});}})['then'](respondWithFilteredResult(_0x548ed7,_0x8e3296))[_0xade1('0x37')](handleError(_0x548ed7,null));};exports[_0xade1('0xc3')]=function(_0x4f1297,_0x4b879a,_0x4c7a60){return db[_0xade1('0x32')][_0xade1('0xb6')]({'where':{'id':_0x4f1297[_0xade1('0xb3')]['id']}})['then'](handleEntityNotFound(_0x4b879a,null))[_0xade1('0x28')](function(_0x5b1f10){if(_0x5b1f10){return _0x5b1f10['setTags'](_0x4f1297[_0xade1('0xb9')][_0xade1('0xbd')],_[_0xade1('0xbe')](_0x4f1297[_0xade1('0xb9')],[_0xade1('0xbd'),'id'])||{})[_0xade1('0xc4')](function(){return db[_0xade1('0xc5')][_0xade1('0xc6')]({'attributes':['id','name',_0xade1('0x46')],'where':{'id':_0x4f1297['body'][_0xade1('0xbd')]}});})[_0xade1('0x28')](function(_0x83ecf9){socket[_0xade1('0xc7')](_0xade1('0xc8'),{'id':Number(_0x4f1297['params']['id']),'tags':_0x83ecf9||[]});return{'id':Number(_0x4f1297[_0xade1('0xb3')]['id']),'tags':_0x83ecf9||[]};});}})[_0xade1('0x28')](respondWithResult(_0x4b879a,null))[_0xade1('0x37')](handleError(_0x4b879a,null));};exports[_0xade1('0xc9')]=function(_0xe3c369,_0xaaaa7,_0x34817e){return db[_0xade1('0x32')][_0xade1('0xb6')]({'where':{'id':_0xe3c369['params']['id']}})['then'](handleEntityNotFound(_0xaaaa7,null))[_0xade1('0x28')](function(_0x1394d9){if(_0x1394d9){return _0x1394d9['removeTags'](_0xe3c369[_0xade1('0x3c')]['ids']);}})['then'](respondWithStatusCode(_0xaaaa7,null))['catch'](handleError(_0xaaaa7,null));};exports[_0xade1('0xca')]=function(_0x5091f1,_0x51af7e){var _0xdaaa00=moment()[_0xade1('0xcb')]()['toString']();var _0x5c8bb9=path['join'](config[_0xade1('0xcc')],'server',_0xade1('0xcd'),'attachments');var _0x440756=path[_0xade1('0x82')](config[_0xade1('0xcc')],_0xade1('0xce'),_0xade1('0xcd'),_0xade1('0xcf'));var _0x1465c3=path[_0xade1('0x82')](_0x440756,_0xdaaa00);var _0x1da138=util[_0xade1('0x62')]('interaction-%s.zip',_0xdaaa00);var _0x3e2a4a=path[_0xade1('0x82')](_0x440756,_0x1da138);var _0x8fec0a=![];return db['MailInteraction'][_0xade1('0xb6')]({'where':{'id':_0x5091f1[_0xade1('0xb3')]['id']}})[_0xade1('0x28')](handleEntityNotFound(_0x51af7e,null))['then'](function(_0x41d8c9){if(_0x41d8c9){return _0x41d8c9[_0xade1('0xbf')]({'attributes':['id',_0xade1('0xb9'),_0xade1('0x47'),'to','cc','bcc',_0xade1('0xd0'),'createdAt'],'where':{'secret':![]},'include':_0x5091f1[_0xade1('0x3c')]['attachments']?[{'model':db[_0xade1('0xd1')],'as':_0xade1('0xd2')}]:undefined,'order':qs['sort']('id')});}return[];})['then'](function(_0x31805e){_0x8fec0a=_0x31805e[_0xade1('0x6a')];if(_0x31805e['length']){fs['mkdirSync'](_0x1465c3);return BPromise['each'](_0x31805e,function(_0x2f5712,_0x4176f0){var _0x27d5bd=_0x2f5712;var _0x3c40f8={'from':_0x27d5bd[_0xade1('0x47')],'to':_0x27d5bd['to'],'subject':_0x27d5bd[_0xade1('0xd0')],'html':_0x27d5bd[_0xade1('0xb9')],'headers':{'Date':moment(_0x27d5bd[_0xade1('0x5e')])[_0xade1('0x62')](_0xade1('0xd3'))},'attachments':[]};if(_0x2f5712['cc']){_0x3c40f8[_0xade1('0xd4')]['Cc']=_0x2f5712['cc'];}if(_0x2f5712[_0xade1('0xd5')]){_0x3c40f8['headers'][_0xade1('0xd6')]=_0x2f5712[_0xade1('0xd5')];}return new BPromise(function(_0x4e1cd0,_0x45b0ab){if(_0x2f5712[_0xade1('0xd2')]){for(var _0x36b7e9=0x0;_0x36b7e9<_0x2f5712[_0xade1('0xd2')][_0xade1('0x6a')];_0x36b7e9++){var _0x445315=_0x2f5712[_0xade1('0xd2')][_0x36b7e9];var _0x34e512=path[_0xade1('0x82')](_0x5c8bb9,_0x445315['basename']);if(fs[_0xade1('0xd7')](_0x34e512)){_0x3c40f8['attachments'][_0xade1('0x80')]({'name':_0x445315[_0xade1('0x2b')],'contentType':_0x445315[_0xade1('0xd8')],'data':fs['readFileSync'](_0x34e512)});}}}emlformat[_0xade1('0xd9')](_0x3c40f8,function(_0x17bd4c,_0x58e779){if(_0x17bd4c)return _0x45b0ab(_0x17bd4c);fs[_0xade1('0xda')](path[_0xade1('0x82')](_0x1465c3,util[_0xade1('0x62')]('message%d.eml',_0x4176f0)),_0x58e779);return _0x4e1cd0(_0x58e779);});});});}})['then'](function(){if(_0x8fec0a){return new BPromise(function(_0x26557c,_0xb87f68){zipdir(_0x1465c3,{'saveTo':_0x3e2a4a},function(_0x48b345,_0x395d21){if(_0x48b345)return _0xb87f68(_0x48b345);return _0x26557c(_0x395d21);});});}})[_0xade1('0x28')](function(){if(_0x8fec0a){return new BPromise(function(_0x27dd84,_0x2d8de1){rimraf(_0x1465c3,function(_0x2fb7ea){if(_0x2fb7ea)_0x2d8de1(_0x2fb7ea);return _0x27dd84();});});}})[_0xade1('0x28')](function(){if(_0x8fec0a){return _0x51af7e[_0xade1('0xca')](_0x3e2a4a,_0x1da138,function(_0xf5113b){if(_0xf5113b){console[_0xade1('0xdb')](_0xade1('0xdc'),_0xf5113b);}else{fs['unlinkSync'](_0x3e2a4a);}});}else{return _0x51af7e[_0xade1('0x1f')](0xc8);}})[_0xade1('0x37')](handleError(_0x51af7e,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff