// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x9dfd=['color','from','tools_tags','ui.MailInteractionId','user_has_mail_interactions','left_join','u.id\x20=\x20ui.UserId','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','a.id\x20=\x20i.MailAccountId','mail_messages','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','`\x20=\x200','`\x20>\x200','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?','text','start','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','User','operator','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','buildExpression','some','compact','isEmpty','MailAccountId','concat','parse','$lte','null','\x20=\x20?','read','having','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','filter','replace','i.id\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','QueryTypes','SELECT','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','DESC','t.id\x20IN\x20?','resolve','i.MailAccountId\x20IS\x20NOT\x20NULL','user','role','getMailAccounts','i.MailAccountId\x20IN\x20?','sequelize','toString','keyBy','a.key','Account.key','a.mandatoryDisposition','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20(\x27%\x27\x20+\x20a.email\x20+\x20\x27%\x27)\x20THEN\x20SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201)\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.createdAt','i.updatedAt','i.closedAt','i.lastMsgDirection','i.subject','i.disposition','i.secondDisposition','i.thirdDisposition','i.UserId','c.firstName','Contact.firstName','Contact.lastName','Contact.email','c.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','all','show','params','includeAll','include','options','create','describe','addMessage','ids','omit','getMessages','rawAttributes','$gte','format','YYYY-MM-DD\x20HH:mm:ss','findAll','inlineCss','rows','addTags','setTags','spread','emit','removeTags','download','unix','join','root','server','tmp','files','attachments','transcript-%d-%s.zip','Attachment','Attachments','Messages','bcc','subject','createdAt','get','mkdirSync','each','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','existsSync','build','writeFileSync','message%d.eml','log','err','rimraf','fast-json-patch','moment','bluebird','util','sox','ejs','fs-extra','lodash','crypto','jsforce','to-csv','papaparse','html-to-text','juice','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','sendStatus','end','json','offset','undefined','count','status','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','render','merge','body','contact','agent','account','Users','map','fullname','TagIds','Tags','split','forEach','push','MailMessage','findOne','plainBody','catch','index','MailInteraction','fieldName','type','model','keys','intersection','attributes','fields','length','query','hasOwnProperty','nolimit','limit','order','sort','where','filters','pick','select','field'];(function(_0x30e1c3,_0x386355){var _0x46ece2=function(_0xb8a692){while(--_0xb8a692){_0x30e1c3['push'](_0x30e1c3['shift']());}};_0x46ece2(++_0x386355);}(_0x9dfd,0x190));var _0xd9df=function(_0x3ace5e,_0x2f54e9){_0x3ace5e=_0x3ace5e-0x0;var _0x5c64d3=_0x9dfd[_0x3ace5e];return _0x5c64d3;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xd9df('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xd9df('0x1'));var rp=require('request-promise');var moment=require(_0xd9df('0x2'));var BPromise=require(_0xd9df('0x3'));var Mustache=require('mustache');var util=require(_0xd9df('0x4'));var path=require('path');var sox=require(_0xd9df('0x5'));var csv=require('to-csv');var ejs=require(_0xd9df('0x6'));var fs=require('fs');var fs_extra=require(_0xd9df('0x7'));var _=require(_0xd9df('0x8'));var squel=require('squel');var crypto=require(_0xd9df('0x9'));var jsforce=require(_0xd9df('0xa'));var deskjs=require('desk.js');var toCsv=require(_0xd9df('0xb'));var querystring=require('querystring');var Papa=require(_0xd9df('0xc'));var htmlToText=require(_0xd9df('0xd'));var juice=require(_0xd9df('0xe'));var Redis=require('ioredis');var authService=require(_0xd9df('0xf'));var qs=require(_0xd9df('0x10'));var as=require(_0xd9df('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xd9df('0x12'))(_0xd9df('0x13'));var utils=require(_0xd9df('0x14'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xd9df('0x15'))['db'];config[_0xd9df('0x16')]=_[_0xd9df('0x17')](config['redis'],{'host':_0xd9df('0x18'),'port':0x18eb});var socket=require(_0xd9df('0x19'))(new Redis(config[_0xd9df('0x16')]));require('./mailInteraction.socket')[_0xd9df('0x1a')](socket);function respondWithStatusCode(_0x4e3db3,_0x3fe310){_0x3fe310=_0x3fe310||0xcc;return function(_0xbe0884){if(_0xbe0884){return _0x4e3db3[_0xd9df('0x1b')](_0x3fe310);}return _0x4e3db3['status'](_0x3fe310)[_0xd9df('0x1c')]();};}function respondWithResult(_0x51508f,_0x2086a0){_0x2086a0=_0x2086a0||0xc8;return function(_0x30d1e1){if(_0x30d1e1){return _0x51508f['status'](_0x2086a0)[_0xd9df('0x1d')](_0x30d1e1);}};}function respondWithFilteredResult(_0x3b2910,_0x4fd500){return function(_0x3320b5){if(_0x3320b5){var _0x8ad506=typeof _0x4fd500[_0xd9df('0x1e')]===_0xd9df('0x1f')&&typeof _0x4fd500['limit']===_0xd9df('0x1f');var _0xfe2298=_0x3320b5[_0xd9df('0x20')];var _0xf52339=_0x8ad506?0x0:_0x4fd500['offset'];var _0x55b295=_0x8ad506?_0x3320b5[_0xd9df('0x20')]:_0x4fd500['offset']+_0x4fd500['limit'];var _0x3897fb;if(_0x55b295>=_0xfe2298){_0x55b295=_0xfe2298;_0x3897fb=0xc8;}else{_0x3897fb=0xce;}_0x3b2910[_0xd9df('0x21')](_0x3897fb);return _0x3b2910['set'](_0xd9df('0x22'),_0xf52339+'-'+_0x55b295+'/'+_0xfe2298)[_0xd9df('0x1d')](_0x3320b5);}return null;};}function patchUpdates(_0x270ad4){return function(_0x5f1354){try{jsonpatch[_0xd9df('0x23')](_0x5f1354,_0x270ad4,!![]);}catch(_0xdd556){return BPromise[_0xd9df('0x24')](_0xdd556);}return _0x5f1354[_0xd9df('0x25')]();};}function saveUpdates(_0x53da92,_0x53214a){return function(_0x20701c){if(_0x20701c){return _0x20701c[_0xd9df('0x26')](_0x53da92)[_0xd9df('0x27')](function(_0x142250){return _0x142250;});}return null;};}function removeEntity(_0x3648e6,_0x21aecd){return function(_0xbbb07c){if(_0xbbb07c){return _0xbbb07c[_0xd9df('0x28')]()['then'](function(){_0x3648e6[_0xd9df('0x21')](0xcc)[_0xd9df('0x1c')]();});}};}function handleEntityNotFound(_0x1fae9d,_0x3a846e){return function(_0x54615d){if(!_0x54615d){_0x1fae9d[_0xd9df('0x1b')](0x194);}return _0x54615d;};}function handleError(_0x48eb80,_0x50693d){_0x50693d=_0x50693d||0x1f4;return function(_0xb1ac77){logger[_0xd9df('0x29')](_0xb1ac77[_0xd9df('0x2a')]);if(_0xb1ac77['name']){delete _0xb1ac77[_0xd9df('0x2b')];}_0x48eb80[_0xd9df('0x21')](_0x50693d)[_0xd9df('0x2c')](_0xb1ac77);};}function getMustacheRender(_0x34e746,_0x2a36e9){return Mustache[_0xd9df('0x2d')](_0x34e746,_[_0xd9df('0x2e')](_0x2a36e9[_0xd9df('0x2f')],{'contact':_0x2a36e9[_0xd9df('0x30')],'message':_0x2a36e9['message'],'agent':_0x2a36e9[_0xd9df('0x31')],'interaction':_0x2a36e9['interaction'],'account':_0x2a36e9[_0xd9df('0x32')]}))||'';}function getInteractionUsers(_0x14dd15,_0x52cc58){return new BPromise(function(_0x2244b3,_0x4c22bd){try{if(_0x52cc58[_0x14dd15['id']]){_0x14dd15[_0xd9df('0x33')]=_[_0xd9df('0x34')](_0x52cc58[_0x14dd15['id']],function(_0x30887b){return{'id':_0x30887b['id'],'fullname':_0x30887b[_0xd9df('0x35')]};});}}catch(_0x40ae10){_0x4c22bd(_0x40ae10);}_0x2244b3(_0x14dd15);});}function getInteractionTags(_0x5ed73f,_0x213b4d){return new BPromise(function(_0x3aa071,_0x5ee8bb){try{if(_0x5ed73f[_0xd9df('0x36')]){_0x5ed73f[_0xd9df('0x37')]=[];_0x5ed73f['TagIds'][_0xd9df('0x38')](',')[_0xd9df('0x39')](function(_0x5f3bcf){_0x5ed73f[_0xd9df('0x37')][_0xd9df('0x3a')](_0x213b4d[_0x5f3bcf]);});}delete _0x5ed73f[_0xd9df('0x36')];}catch(_0x2358b9){_0x5ee8bb(_0x2358b9);}_0x3aa071(_0x5ed73f);});}function getLastMessageText(_0x533150){return new BPromise(function(_0x2e232f,_0x31fe6a){return db[_0xd9df('0x3b')][_0xd9df('0x3c')]({'where':{'$and':[{'MailInteractionId':_0x533150['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':'out'},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0xd9df('0x3d')],'order':'-id','raw':!![]})[_0xd9df('0x27')](function(_0x33989e){if(_0x33989e&&_0x33989e[_0xd9df('0x3d')]){_0x533150['lastMsgText']=_['trimStart'](_0x33989e[_0xd9df('0x3d')]);}_0x2e232f(_0x533150);})[_0xd9df('0x3e')](function(_0x3109bf){_0x31fe6a(_0x3109bf);});});}function updateMailInteraction(_0x3a8c67,_0x57397e,_0x900784,_0x5ddf8f){return new BPromise(function(_0x54ef8a,_0xd35fb2){return getInteractionUsers(_0x3a8c67,_0x900784)[_0xd9df('0x27')](function(_0x566f41){return getInteractionTags(_0x566f41,_0x57397e);})[_0xd9df('0x27')](function(_0x130b1b){if(_0x5ddf8f){_0x54ef8a(getLastMessageText(_0x130b1b));}else{_0x54ef8a(_0x130b1b);}})[_0xd9df('0x3e')](function(_0x48001d){_0xd35fb2(_0x48001d);});});}exports[_0xd9df('0x3f')]=function(_0x58d25e,_0x4668e4){var _0x1addc6={},_0x42e312={},_0x1b5830={'count':0x0,'rows':[]};var _0x307404=_[_0xd9df('0x34')](db[_0xd9df('0x40')]['rawAttributes'],function(_0x52d3c5){return{'name':_0x52d3c5[_0xd9df('0x41')],'type':_0x52d3c5[_0xd9df('0x42')]['key']};});_0x42e312[_0xd9df('0x43')]=_[_0xd9df('0x34')](_0x307404,_0xd9df('0x2b'));_0x42e312['query']=_[_0xd9df('0x44')](_0x58d25e['query']);_0x42e312['filters']=_[_0xd9df('0x45')](_0x42e312[_0xd9df('0x43')],_0x42e312['query']);_0x1addc6[_0xd9df('0x46')]=_[_0xd9df('0x45')](_0x42e312[_0xd9df('0x43')],qs[_0xd9df('0x47')](_0x58d25e['query'][_0xd9df('0x47')]));_0x1addc6[_0xd9df('0x46')]=_0x1addc6['attributes'][_0xd9df('0x48')]?_0x1addc6[_0xd9df('0x46')]:_0x42e312[_0xd9df('0x43')];if(!_0x58d25e[_0xd9df('0x49')][_0xd9df('0x4a')](_0xd9df('0x4b'))){_0x1addc6[_0xd9df('0x4c')]=qs['limit'](_0x58d25e['query'][_0xd9df('0x4c')]);_0x1addc6[_0xd9df('0x1e')]=qs[_0xd9df('0x1e')](_0x58d25e['query'][_0xd9df('0x1e')]);}_0x1addc6[_0xd9df('0x4d')]=qs[_0xd9df('0x4e')](_0x58d25e[_0xd9df('0x49')][_0xd9df('0x4e')]);_0x1addc6[_0xd9df('0x4f')]=qs[_0xd9df('0x50')](_[_0xd9df('0x51')](_0x58d25e['query'],_0x42e312[_0xd9df('0x50')]),_0x307404);var _0x2f0f5f=[];var _0x4aeb24=squel[_0xd9df('0x52')]()[_0xd9df('0x53')]('id')[_0xd9df('0x53')](_0xd9df('0x2b'))[_0xd9df('0x53')](_0xd9df('0x54'))[_0xd9df('0x55')](_0xd9df('0x56'));var _0x24aa00=squel[_0xd9df('0x52')]()['field']('u.id')[_0xd9df('0x53')]('u.fullname')[_0xd9df('0x53')](_0xd9df('0x57'))[_0xd9df('0x55')](_0xd9df('0x58'),'ui')[_0xd9df('0x59')]('users','u',_0xd9df('0x5a'));var _0x393264=squel[_0xd9df('0x52')]()['from']('mail_interactions','i')['left_join']('cm_contacts','c',_0xd9df('0x5b'))[_0xd9df('0x59')]('users','o',_0xd9df('0x5c'))['left_join'](_0xd9df('0x5d'),'a',_0xd9df('0x5e'))[_0xd9df('0x59')](_0xd9df('0x5f'),'me','me.MailInteractionId\x20=\x20i.id')['left_join'](_0xd9df('0x60'),'it',_0xd9df('0x61'))[_0xd9df('0x59')](_0xd9df('0x56'),'t',_0xd9df('0x62'));var _0x176d6c=squel[_0xd9df('0x63')]();var _0x5596e7=[];var _0x26f0df=squel[_0xd9df('0x63')]();var _0x30cd8f;if(_0x58d25e[_0xd9df('0x49')][_0xd9df('0x64')]){_0x30cd8f=as[_0xd9df('0x65')](_0x58d25e['query']['search']);var _0x44076c=_0x30cd8f[_0xd9df('0x66')];for(var _0x264fe5=0x0;_0x264fe5<_0x30cd8f[_0xd9df('0x67')]['length'];_0x264fe5++){var _0x15d45b=_0x30cd8f['conditions'][_0x264fe5];var _0x5cf5e7='i';var _0x15d8b0=_[_0xd9df('0x68')](_0x307404,[_0xd9df('0x2b'),_0x15d45b[_0xd9df('0x53')]]);if(!_0x15d8b0){switch(_0x15d45b[_0xd9df('0x53')]){case _0xd9df('0x69'):if(_0x15d45b[_0xd9df('0x6a')]==0x1){_0x393264['having']('`'+_0x15d45b['field']+_0xd9df('0x6b'));}else{_0x393264['having']('`'+_0x15d45b[_0xd9df('0x53')]+_0xd9df('0x6c'));}break;case _0xd9df('0x6d'):if(_0x15d45b['operator']===_0xd9df('0x6e')){if(_0x15d45b['value'][_0xd9df('0x38')]('\x20')[_0xd9df('0x48')]>0x1){_0x176d6c[_0x44076c](_0xd9df('0x6f'),qs[_0xd9df('0x70')](_0x15d45b[_0xd9df('0x6a')]),null);}else{var _0x44fef9='%'+_0x15d45b[_0xd9df('0x6a')]+'%';_0x176d6c[_0x44076c](_0xd9df('0x71'),_0x44fef9,_0x44fef9,_0x44fef9);}}else{_0x15d8b0=_[_0xd9df('0x68')](_0x307404,[_0xd9df('0x2b'),'ContactId']);_0x15d45b[_0xd9df('0x53')]='ContactId';_0x32bc7f=as['buildExpression'](_0x5cf5e7,_0x15d8b0[_0xd9df('0x42')],_0x15d45b);_0x176d6c[_0x44076c](_0x32bc7f[_0xd9df('0x72')],_0x32bc7f['value'][_0xd9df('0x73')],_0x32bc7f[_0xd9df('0x6a')]['end']);}break;case'Tag':var _0x5ad23f=_0x15d45b[_0xd9df('0x6a')]['split'](',')[_0xd9df('0x34')](function(_0x44e3bd){return Number(_0x44e3bd);});_0x5ad23f[_0xd9df('0x39')](function(_0x3874dd){_0x26f0df['or'](_0xd9df('0x74'),'%,'+_0x3874dd+',%');});_0x5596e7=_['union'](_0x5596e7,_0x5ad23f);break;case _0xd9df('0x75'):if(_0x15d45b[_0xd9df('0x76')]===_0xd9df('0x6e')){_0x176d6c[_0x44076c](_0xd9df('0x77'),'%'+_0x15d45b[_0xd9df('0x6a')]+'%',null);}else{_0x15d8b0=_[_0xd9df('0x68')](_0x307404,['name',_0xd9df('0x78')]);_0x15d45b[_0xd9df('0x53')]=_0xd9df('0x78');_0x32bc7f=as[_0xd9df('0x79')](_0x5cf5e7,_0x15d8b0[_0xd9df('0x42')],_0x15d45b);_0x176d6c[_0x44076c](_0x32bc7f[_0xd9df('0x72')],_0x32bc7f[_0xd9df('0x6a')]['start'],_0x32bc7f[_0xd9df('0x6a')][_0xd9df('0x1c')]);}break;case _0xd9df('0x3d'):_0x32bc7f=as[_0xd9df('0x79')]('me',null,_0x15d45b);_0x176d6c[_0x44076c](_0x32bc7f['text'],_0x32bc7f[_0xd9df('0x6a')][_0xd9df('0x73')],_0x32bc7f[_0xd9df('0x6a')][_0xd9df('0x1c')]);break;}}else{var _0x32bc7f=as[_0xd9df('0x79')](_0x5cf5e7,_0x15d8b0[_0xd9df('0x42')],_0x15d45b);_0x176d6c[_0x44076c](_0x32bc7f[_0xd9df('0x72')],_0x32bc7f[_0xd9df('0x6a')][_0xd9df('0x73')],_0x32bc7f[_0xd9df('0x6a')][_0xd9df('0x1c')]);}}}else{var _0x32e7d7=_(_0x58d25e['query'])['keys']()[_0xd9df('0x34')](function(_0x425ea6){return _[_0xd9df('0x7a')](_0x307404,[_0xd9df('0x2b'),_0x425ea6])?_0x425ea6:undefined;})[_0xd9df('0x7b')]()[_0xd9df('0x6a')]();if(!_[_0xd9df('0x7c')](_0x32e7d7)){_0x32e7d7[_0xd9df('0x39')](function(_0x1590b2){if(_0x1590b2===_0xd9df('0x7d')){_0x393264[_0xd9df('0x4f')]('i.MailAccountId\x20IN\x20?',[][_0xd9df('0x7e')](_0x58d25e[_0xd9df('0x49')][_0x1590b2]));}else if(_0x1590b2==='createdAt'){var _0x534b1b=JSON[_0xd9df('0x7f')](_0x58d25e['query'][_0x1590b2])['$gte'];var _0x3657c8=JSON['parse'](_0x58d25e['query'][_0x1590b2])[_0xd9df('0x80')];_0x393264[_0xd9df('0x4f')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x534b1b,_0x3657c8);}else{if(_0x58d25e[_0xd9df('0x49')][_0x1590b2]===_0xd9df('0x81')){_0x393264['where']('i.'+_0x1590b2+'\x20IS\x20NULL');}else{_0x393264[_0xd9df('0x4f')]('i.'+_0x1590b2+_0xd9df('0x82'),_0x58d25e[_0xd9df('0x49')][_0x1590b2]);}}});}if(_0x58d25e[_0xd9df('0x49')][_0xd9df('0x83')]){if(_0x58d25e[_0xd9df('0x49')][_0xd9df('0x83')]==0x1){_0x393264[_0xd9df('0x84')](_0xd9df('0x85'));}else{_0x393264[_0xd9df('0x84')](_0xd9df('0x86'));}}if(_0x58d25e[_0xd9df('0x49')][_0xd9df('0x87')]){_0x5596e7=_[_0xd9df('0x88')](_0x58d25e[_0xd9df('0x49')][_0xd9df('0x87')])?_0x58d25e[_0xd9df('0x49')][_0xd9df('0x87')]:new Array(_0x58d25e[_0xd9df('0x49')]['tag']);_0x5596e7[_0xd9df('0x39')](function(_0x174013){_0x26f0df['or'](_0xd9df('0x74'),'%,'+_0x174013+',%');});}if(_0x58d25e[_0xd9df('0x49')][_0xd9df('0x89')]){var _0x6cd0a=_0x58d25e[_0xd9df('0x49')][_0xd9df('0x89')][_0xd9df('0x8a')]('\x5c','\x5c\x5c')[_0xd9df('0x8a')](/'/g,'\x27\x27');if(qs['isNumeric'](_0x6cd0a)){_0x176d6c['or'](_0xd9df('0x8b'),_0x6cd0a+'%');}else if(qs[_0xd9df('0x8c')](_0x6cd0a)){_0x176d6c['or'](_0xd9df('0x8d'),_0x6cd0a+'%');}else{_0x176d6c['or'](_0xd9df('0x8e'),qs['getFullTextValue'](_0x6cd0a))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xd9df('0x70')](_0x6cd0a));}}}_0x393264[_0xd9df('0x4f')](_0x176d6c);_0x393264[_0xd9df('0x8f')](_0xd9df('0x90'));var _0x14c05e={'type':db['Sequelize'][_0xd9df('0x91')][_0xd9df('0x92')],'raw':!![]};var _0x1aeb38=_0x393264['clone']();_0x1aeb38[_0xd9df('0x53')](_0xd9df('0x90'));_0x1aeb38[_0xd9df('0x53')](_0xd9df('0x93'),_0xd9df('0x69'));if(_0x1addc6[_0xd9df('0x4d')]){_0x1addc6[_0xd9df('0x4d')][_0xd9df('0x39')](function(_0x2fac51){var _0x3ca200=_0x2fac51[0x0]==='contactName'?_0x2fac51[0x0]:'i.'+_0x2fac51[0x0];_0x393264[_0xd9df('0x4d')](_0x3ca200,_0x2fac51[0x1]===_0xd9df('0x94')?![]:!![]);});}if(!_[_0xd9df('0x7c')](_0x5596e7)){_0x393264[_0xd9df('0x84')](_0x26f0df);_0x1aeb38['where'](_0xd9df('0x95'),_0x5596e7);}BPromise[_0xd9df('0x96')]()['then'](function(){if(!_0x30cd8f){if(_0x58d25e[_0xd9df('0x49')][_0xd9df('0x7d')])return;_0x1aeb38[_0xd9df('0x4f')]('i.MailAccountId\x20IS\x20NOT\x20NULL');_0x393264['where'](_0xd9df('0x97'));return;}if(_0x58d25e[_0xd9df('0x98')][_0xd9df('0x99')]!==_0xd9df('0x31'))return;return _0x58d25e[_0xd9df('0x98')][_0xd9df('0x9a')]({'attributes':['id'],'raw':!![]})['then'](function(_0x4898e7){if(_[_0xd9df('0x7c')](_0x4898e7)){_0x1aeb38['where']('i.MailAccountId\x20IS\x20NULL');_0x393264[_0xd9df('0x4f')]('i.MailAccountId\x20IS\x20NULL');}else{_0x1aeb38['where'](_0xd9df('0x9b'),_[_0xd9df('0x34')](_0x4898e7,'id'));_0x393264[_0xd9df('0x4f')](_0xd9df('0x9b'),_['map'](_0x4898e7,'id'));}});})[_0xd9df('0x27')](function(){if(_0x58d25e[_0xd9df('0x98')][_0xd9df('0x99')]===_0xd9df('0x31')&&!_0x30cd8f&&!_0x58d25e[_0xd9df('0x49')][_0xd9df('0x7d')])return[];return db[_0xd9df('0x9c')][_0xd9df('0x49')](_0x1aeb38[_0xd9df('0x9d')](),_0x14c05e);})['then'](function(_0x1a1caa){_0x1b5830[_0xd9df('0x20')]=_0x1a1caa[_0xd9df('0x48')];if(_0x1b5830[_0xd9df('0x20')]===0x0)return[];return db[_0xd9df('0x9c')]['query'](_0x4aeb24[_0xd9df('0x9d')](),_0x14c05e)[_0xd9df('0x27')](function(_0x2be184){_0x2f0f5f=_[_0xd9df('0x9e')](_0x2be184,'id');_0x14c05e=_[_0xd9df('0x2e')](_0x14c05e,{'model':db[_0xd9df('0x40')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x58d25e['query']['fields']){_0x1addc6[_0xd9df('0x46')][_0xd9df('0x39')](function(_0x42120e){_0x393264[_0xd9df('0x53')]('i.'+_0x42120e);});}else{_0x393264[_0xd9df('0x53')](_0xd9df('0x93'),_0xd9df('0x69'));_0x393264[_0xd9df('0x53')](_0xd9df('0x9f'),_0xd9df('0xa0'));_0x393264['field'](_0xd9df('0xa1'),'Account.mandatoryDisposition');_0x393264[_0xd9df('0x53')](_0xd9df('0xa2'),_0xd9df('0xa3'));_0x393264['field']('i.id');_0x393264[_0xd9df('0x53')](_0xd9df('0xa4'));_0x393264[_0xd9df('0x53')](_0xd9df('0xa5'));_0x393264[_0xd9df('0x53')]('i.closed');_0x393264[_0xd9df('0x53')](_0xd9df('0xa6'));_0x393264[_0xd9df('0x53')]('i.attach');_0x393264[_0xd9df('0x53')]('i.lastMsgAt');_0x393264['field'](_0xd9df('0xa7'));_0x393264[_0xd9df('0x53')](_0xd9df('0xa8'));_0x393264['field'](_0xd9df('0xa9'));_0x393264[_0xd9df('0x53')](_0xd9df('0xaa'));_0x393264[_0xd9df('0x53')](_0xd9df('0xab'));_0x393264[_0xd9df('0x53')]('i.substatus');_0x393264['field']('i.to');_0x393264[_0xd9df('0x53')]('i.ContactId');_0x393264[_0xd9df('0x53')]('i.MailAccountId');_0x393264[_0xd9df('0x53')](_0xd9df('0xac'));_0x393264['field'](_0xd9df('0xad'),_0xd9df('0xae'));_0x393264['field']('c.lastName',_0xd9df('0xaf'));_0x393264[_0xd9df('0x53')]('c.email',_0xd9df('0xb0'));_0x393264[_0xd9df('0x53')](_0xd9df('0xb1'),'Contact.phone');_0x393264[_0xd9df('0x53')](_0xd9df('0xb2'),_0xd9df('0xb3'));_0x393264['field'](_0xd9df('0xb4'),_0xd9df('0xb5'));_0x393264[_0xd9df('0x53')]('o.fullname',_0xd9df('0xb6'));_0x393264[_0xd9df('0x53')](_0xd9df('0xb7'),_0xd9df('0xb8'));_0x393264[_0xd9df('0x53')](_0xd9df('0xb9'),_0xd9df('0x36'));}if(_0x1addc6[_0xd9df('0x4c')])_0x393264[_0xd9df('0x4c')](_0x1addc6[_0xd9df('0x4c')]);if(_0x1addc6[_0xd9df('0x1e')])_0x393264['offset'](_0x1addc6[_0xd9df('0x1e')]);return db['sequelize']['query'](_0x393264[_0xd9df('0x9d')](),_0x14c05e);})[_0xd9df('0x27')](function(_0x3d639d){if(_0x3d639d[_0xd9df('0x48')]>0x0)_0x24aa00[_0xd9df('0x4f')](_0xd9df('0xba'),_['map'](_0x3d639d,'id'));return db['sequelize'][_0xd9df('0x49')](_0x24aa00['toString'](),_0x14c05e)[_0xd9df('0x27')](function(_0x2e7c04){var _0x366bab=_[_0xd9df('0xbb')](_0x2e7c04,_0xd9df('0xbc'));var _0x599cd4=[];return db[_0xd9df('0xbd')][_0xd9df('0x3c')]({'attributes':[_0xd9df('0xbe')],'raw':!![]})[_0xd9df('0x27')](function(_0x2a2749){var _0x15f0b6=_0x2a2749[_0xd9df('0xbe')];_0x3d639d[_0xd9df('0x39')](function(_0x4e0b15){_0x599cd4[_0xd9df('0x3a')](updateMailInteraction(_0x4e0b15,_0x2f0f5f,_0x366bab,_0x15f0b6));});return BPromise[_0xd9df('0xbf')](_0x599cd4);});});});})[_0xd9df('0x27')](function(_0x1fd745){_0x1b5830['rows']=_0x1fd745;return _0x1b5830;})[_0xd9df('0x27')](respondWithFilteredResult(_0x4668e4,_0x1addc6))[_0xd9df('0x3e')](handleError(_0x4668e4,null));};exports[_0xd9df('0xc0')]=function(_0x3eed75,_0x58ee0e){var _0x3f356a={'raw':![],'where':{'id':_0x3eed75[_0xd9df('0xc1')]['id']}},_0x3626ee={};_0x3626ee[_0xd9df('0x43')]=_[_0xd9df('0x44')](db[_0xd9df('0x40')]['rawAttributes']);_0x3626ee[_0xd9df('0x49')]=_[_0xd9df('0x44')](_0x3eed75[_0xd9df('0x49')]);_0x3626ee[_0xd9df('0x50')]=_['intersection'](_0x3626ee[_0xd9df('0x43')],_0x3626ee[_0xd9df('0x49')]);_0x3f356a[_0xd9df('0x46')]=_[_0xd9df('0x45')](_0x3626ee[_0xd9df('0x43')],qs['fields'](_0x3eed75[_0xd9df('0x49')]['fields']));_0x3f356a['attributes']=_0x3f356a['attributes']['length']?_0x3f356a[_0xd9df('0x46')]:_0x3626ee[_0xd9df('0x43')];if(_0x3eed75[_0xd9df('0x49')][_0xd9df('0xc2')]){_0x3f356a[_0xd9df('0xc3')]=[{'all':!![]}];}_0x3f356a=_['merge']({},_0x3f356a,_0x3eed75[_0xd9df('0xc4')]);return db[_0xd9df('0x40')][_0xd9df('0x68')](_0x3f356a)['then'](handleEntityNotFound(_0x58ee0e,null))[_0xd9df('0x27')](respondWithResult(_0x58ee0e,null))[_0xd9df('0x3e')](handleError(_0x58ee0e,null));};exports[_0xd9df('0xc5')]=function(_0x26def5,_0xb2c313){return db[_0xd9df('0x40')][_0xd9df('0xc5')](_0x26def5[_0xd9df('0x2f')],{})['then'](respondWithResult(_0xb2c313,0xc9))['catch'](handleError(_0xb2c313,null));};exports[_0xd9df('0x26')]=function(_0x8de17b,_0x2360c0){if(_0x8de17b[_0xd9df('0x2f')]['id']){delete _0x8de17b['body']['id'];}return db['MailInteraction'][_0xd9df('0x68')]({'where':{'id':_0x8de17b['params']['id']}})['then'](handleEntityNotFound(_0x2360c0,null))[_0xd9df('0x27')](saveUpdates(_0x8de17b[_0xd9df('0x2f')],null))[_0xd9df('0x27')](respondWithResult(_0x2360c0,null))[_0xd9df('0x3e')](handleError(_0x2360c0,null));};exports[_0xd9df('0x28')]=function(_0x257d97,_0x3dd320){return db[_0xd9df('0x40')][_0xd9df('0x68')]({'where':{'id':_0x257d97['params']['id']}})[_0xd9df('0x27')](handleEntityNotFound(_0x3dd320,null))[_0xd9df('0x27')](removeEntity(_0x3dd320,null))[_0xd9df('0x3e')](handleError(_0x3dd320,null));};exports[_0xd9df('0xc6')]=function(_0x5d8622,_0x34782b){return db[_0xd9df('0x40')][_0xd9df('0xc6')]()['then'](respondWithResult(_0x34782b,null))[_0xd9df('0x3e')](handleError(_0x34782b,null));};exports[_0xd9df('0xc7')]=function(_0x43b4e4,_0x3e2de5,_0xe5b13d){return db['MailMessage']['find']({'where':{'id':_0x43b4e4[_0xd9df('0xc1')]['id']}})[_0xd9df('0x27')](handleEntityNotFound(_0x3e2de5,null))[_0xd9df('0x27')](function(_0x42f307){if(_0x42f307){return _0x42f307[_0xd9df('0xc7')](_0x43b4e4[_0xd9df('0x2f')][_0xd9df('0xc8')],_[_0xd9df('0xc9')](_0x43b4e4[_0xd9df('0x2f')],[_0xd9df('0xc8'),'id'])||{});}})[_0xd9df('0x27')](respondWithResult(_0x3e2de5,null))[_0xd9df('0x3e')](handleError(_0x3e2de5,null));};exports[_0xd9df('0xca')]=function(_0xd4dc4b,_0x3e1140,_0x5085e7){var _0xc320f7={'raw':![],'where':{}};var _0x5a75bc={};var _0x1bd17f={'count':0x0,'rows':[]};return db['MailInteraction'][_0xd9df('0x3c')]({'where':{'id':_0xd4dc4b[_0xd9df('0xc1')]['id']}})['then'](handleEntityNotFound(_0x3e1140,null))[_0xd9df('0x27')](function(_0x1e7326){if(_0x1e7326){_0x5a75bc[_0xd9df('0x43')]=_[_0xd9df('0x44')](db[_0xd9df('0x3b')][_0xd9df('0xcb')]);_0x5a75bc['query']=_[_0xd9df('0x44')](_0xd4dc4b[_0xd9df('0x49')]);_0x5a75bc[_0xd9df('0x50')]=_[_0xd9df('0x45')](_0x5a75bc[_0xd9df('0x43')],_0x5a75bc[_0xd9df('0x49')]);_0xc320f7[_0xd9df('0x46')]=_[_0xd9df('0x45')](_0x5a75bc[_0xd9df('0x43')],qs[_0xd9df('0x47')](_0xd4dc4b['query'][_0xd9df('0x47')]));_0xc320f7['attributes']=_0xc320f7[_0xd9df('0x46')][_0xd9df('0x48')]?_0xc320f7[_0xd9df('0x46')]:_0x5a75bc['model'];if(!_0xd4dc4b[_0xd9df('0x49')][_0xd9df('0x4a')](_0xd9df('0x4b'))){_0xc320f7['limit']=qs[_0xd9df('0x4c')](_0xd4dc4b[_0xd9df('0x49')][_0xd9df('0x4c')]);_0xc320f7['offset']=qs[_0xd9df('0x1e')](_0xd4dc4b['query']['offset']);}_0xc320f7[_0xd9df('0x4d')]=qs[_0xd9df('0x4e')](_0xd4dc4b[_0xd9df('0x49')][_0xd9df('0x4e')]);_0xc320f7[_0xd9df('0x4f')]=qs[_0xd9df('0x50')](_[_0xd9df('0x51')](_0xd4dc4b[_0xd9df('0x49')],_0x5a75bc['filters']));_0xc320f7[_0xd9df('0x4f')][_0xd9df('0xbc')]=_0x1e7326['id'];if(_0xd4dc4b[_0xd9df('0x49')][_0xd9df('0x89')]){_0xc320f7[_0xd9df('0x4f')]=_['merge'](_0xc320f7[_0xd9df('0x4f')],{'$or':_[_0xd9df('0x34')](_0xc320f7[_0xd9df('0x46')],function(_0x4ba2fd){var _0x43582d={};_0x43582d[_0x4ba2fd]={'$like':'%'+_0xd4dc4b[_0xd9df('0x49')]['filter']+'%'};return _0x43582d;})});}if(_0xd4dc4b[_0xd9df('0x49')][_0xd9df('0xcc')]){var _0x12ce5b=_0xd4dc4b['query'][_0xd9df('0xcc')]['split'](',');var _0x16a7aa={};_0x16a7aa[_0x12ce5b[0x0]]={'$gte':moment(_0x12ce5b[0x1])[_0xd9df('0xcd')](_0xd9df('0xce'))};_0xc320f7[_0xd9df('0x4f')]=_[_0xd9df('0x2e')](_0xc320f7['where'],_0x16a7aa);}_0xc320f7=_['merge']({},_0xc320f7,_0xd4dc4b[_0xd9df('0xc4')]);return db['MailMessage'][_0xd9df('0x20')]({'where':_0xc320f7[_0xd9df('0x4f')]})['then'](function(_0x473a3f){_0x1bd17f[_0xd9df('0x20')]=_0x473a3f;if(_0xd4dc4b['query']['includeAll']){_0xc320f7[_0xd9df('0xc3')]=[{'all':!![]}];}return db[_0xd9df('0x3b')][_0xd9df('0xcf')](_0xc320f7);})[_0xd9df('0x27')](function(_0x784015){if(_0xd4dc4b[_0xd9df('0x49')][_0xd9df('0xd0')]==='true'){for(var _0x2f552a=0x0;_0x2f552a<_0x784015[_0xd9df('0x48')];_0x2f552a++){_0x784015[_0x2f552a][_0xd9df('0x2f')]=juice(_0x784015[_0x2f552a]['body']);}}_0x1bd17f[_0xd9df('0xd1')]=_0x784015;return _0x1bd17f;});}})[_0xd9df('0x27')](respondWithFilteredResult(_0x3e1140,_0xc320f7))[_0xd9df('0x3e')](handleError(_0x3e1140,null));};exports[_0xd9df('0xd2')]=function(_0x4575a7,_0x1ddf92,_0x449621){return db['MailInteraction']['find']({'where':{'id':_0x4575a7[_0xd9df('0xc1')]['id']}})[_0xd9df('0x27')](handleEntityNotFound(_0x1ddf92,null))[_0xd9df('0x27')](function(_0x295895){if(_0x295895){return _0x295895[_0xd9df('0xd3')](_0x4575a7[_0xd9df('0x2f')]['ids'],_[_0xd9df('0xc9')](_0x4575a7[_0xd9df('0x2f')],['ids','id'])||{})[_0xd9df('0xd4')](function(){return db['Tag']['findAll']({'attributes':['id',_0xd9df('0x2b'),_0xd9df('0x54')],'where':{'id':_0x4575a7[_0xd9df('0x2f')][_0xd9df('0xc8')]}});})[_0xd9df('0x27')](function(_0x44c220){socket[_0xd9df('0xd5')]('mailInteractionTags:save',{'id':Number(_0x4575a7['params']['id']),'tags':_0x44c220||[]});return{'id':Number(_0x4575a7['params']['id']),'tags':_0x44c220||[]};});}})['then'](respondWithResult(_0x1ddf92,null))[_0xd9df('0x3e')](handleError(_0x1ddf92,null));};exports['removeTags']=function(_0x2e9231,_0x33faca,_0x396e86){return db['MailInteraction']['find']({'where':{'id':_0x2e9231[_0xd9df('0xc1')]['id']}})[_0xd9df('0x27')](handleEntityNotFound(_0x33faca,null))[_0xd9df('0x27')](function(_0x3605b4){if(_0x3605b4){return _0x3605b4[_0xd9df('0xd6')](_0x2e9231[_0xd9df('0x49')]['ids']);}})['then'](respondWithStatusCode(_0x33faca,null))['catch'](handleError(_0x33faca,null));};exports[_0xd9df('0xd7')]=function(_0x2fa7de,_0x3afe22){var _0x4c424d=moment()[_0xd9df('0xd8')]()[_0xd9df('0x9d')]();var _0x5760b4=path[_0xd9df('0xd9')](config[_0xd9df('0xda')],_0xd9df('0xdb'),'files',_0xd9df('0xdc'));var _0x24020e=path[_0xd9df('0xd9')](config[_0xd9df('0xda')],_0xd9df('0xdb'),_0xd9df('0xdd'),_0xd9df('0xde'));var _0x54660d=path[_0xd9df('0xd9')](_0x5760b4,_0x4c424d);var _0x40ea0e=util['format'](_0xd9df('0xdf'),_0x2fa7de['params']['id'],_0x4c424d);var _0x55f537=path[_0xd9df('0xd9')](_0x5760b4,_0x40ea0e);var _0x5aa4b5=[];if(_0x2fa7de['query'][_0xd9df('0xde')]){_0x5aa4b5[_0xd9df('0x3a')]({'model':db[_0xd9df('0xe0')],'as':_0xd9df('0xe1'),'raw':!![]});}var _0x2d8cb0=[{'model':db['MailMessage'],'as':_0xd9df('0xe2'),'attributes':['id',_0xd9df('0x2f'),_0xd9df('0x55'),'to','cc',_0xd9df('0xe3'),_0xd9df('0xe4'),_0xd9df('0xe5')],'where':{'secret':![]},'order':qs['sort']('id'),'include':_0x5aa4b5}];return db['MailInteraction'][_0xd9df('0x68')]({'where':{'id':_0x2fa7de['params']['id']},'include':_0x2d8cb0})['then'](handleEntityNotFound(_0x3afe22,null))['then'](function(_0x3aaf71){if(_0x3aaf71&&_0x3aaf71[_0xd9df('0xe2')]){var _0x37cfce=_0x3aaf71[_0xd9df('0xe6')]({'plain':!![]});fs[_0xd9df('0xe7')](_0x54660d);return BPromise[_0xd9df('0xe8')](_0x37cfce[_0xd9df('0xe2')],function(_0x11afdf,_0xb41533){var _0x4c000e={'from':_0x11afdf[_0xd9df('0x55')],'to':_0x11afdf['to'],'subject':_0x11afdf['subject'],'html':_0x11afdf['body'],'headers':{'Date':moment(_0x11afdf[_0xd9df('0xe5')])[_0xd9df('0xcd')](_0xd9df('0xe9'))},'attachments':[]};if(_0x11afdf['cc']){_0x4c000e[_0xd9df('0xea')]['Cc']=_0x11afdf['cc'];}if(_0x11afdf[_0xd9df('0xe3')]){_0x4c000e[_0xd9df('0xea')][_0xd9df('0xeb')]=_0x11afdf[_0xd9df('0xe3')];}return new BPromise(function(_0x5b2957,_0x185835){if(_0x11afdf[_0xd9df('0xe1')]){for(var _0x42d821=0x0;_0x42d821<_0x11afdf[_0xd9df('0xe1')][_0xd9df('0x48')];_0x42d821++){var _0x58f7db=_0x11afdf[_0xd9df('0xe1')][_0x42d821];var _0x4a4244=path[_0xd9df('0xd9')](_0x24020e,_0x58f7db['basename']);if(fs[_0xd9df('0xec')](_0x4a4244)){_0x4c000e[_0xd9df('0xde')][_0xd9df('0x3a')]({'name':_0x58f7db[_0xd9df('0x2b')],'contentType':_0x58f7db['type'],'data':fs['readFileSync'](_0x4a4244)});}}}emlformat[_0xd9df('0xed')](_0x4c000e,function(_0x4506b4,_0xc648e2){if(_0x4506b4)return _0x185835(_0x4506b4);fs[_0xd9df('0xee')](path[_0xd9df('0xd9')](_0x54660d,util[_0xd9df('0xcd')](_0xd9df('0xef'),_0xb41533)),_0xc648e2);return _0x5b2957(_0xc648e2);});});})['then'](function(){return new BPromise(function(_0x3ae180,_0x511c4a){zipdir(_0x54660d,{'saveTo':_0x55f537},function(_0x32b0ca,_0x8080cf){if(_0x32b0ca)return _0x511c4a(_0x32b0ca);return _0x3ae180(_0x8080cf);});})['then'](function(){return new BPromise(function(_0x54b1ba,_0x2e11ca){rimraf(_0x54660d,function(_0x10a605){if(_0x10a605)_0x2e11ca(_0x10a605);return _0x54b1ba();});});})['then'](function(){return _0x3afe22[_0xd9df('0xd7')](_0x55f537,_0x40ea0e,function(_0x12448c){if(_0x12448c){console[_0xd9df('0xf0')](_0xd9df('0xf1'),_0x12448c);}else{fs['unlinkSync'](_0x55f537);}});});});}else{return _0x3afe22[_0xd9df('0x1b')](0xc8);}})[_0xd9df('0x3e')](handleError(_0x3afe22,null));};
\ No newline at end of file
+var _0x0360=['parseSearch','conditions','unreadMessages','value','having','`\x20=\x200','Contact','operator','split','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','find','ContactId','buildExpression','start','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','$substring','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','text','some','compact','isEmpty','MailAccountId','createdAt','parse','$lte','where','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','read','`unreadMessages`\x20>\x200','tag','isArray','filter','replace','isNumeric','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','Sequelize','QueryTypes','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','DESC','t.id\x20IN\x20?','resolve','i.MailAccountId\x20IS\x20NOT\x20NULL','user','getMailAccounts','i.MailAccountId\x20IS\x20NULL','i.MailAccountId\x20IN\x20?','sequelize','toString','keyBy','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20(\x27%\x27\x20+\x20a.email\x20+\x20\x27%\x27)\x20THEN\x20SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201)\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.createdAt','i.closed','i.lastMsgAt','i.lastMsgDirection','i.subject','i.disposition','i.secondDisposition','i.substatus','i.to','i.ContactId','i.MailAccountId','i.UserId','c.firstName','Contact.firstName','c.lastName','Contact.email','c.phone','Contact.phone','c.mobile','o.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','all','rows','show','includeAll','include','options','catch','create','params','describe','addMessage','ids','omit','pick','$gte','format','YYYY-MM-DD\x20HH:mm:ss','findAll','inlineCss','true','addTags','spread','emit','mailInteractionTags:save','unix','join','files','root','server','attachments','transcript-%d-%s.zip','push','Messages','subject','get','mkdirSync','each','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','bcc','Attachments','basename','existsSync','readFileSync','build','writeFileSync','err','unlinkSync','rimraf','zip-dir','fast-json-patch','bluebird','util','sox','to-csv','ejs','fs-extra','squel','jsforce','desk.js','papaparse','juice','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./mailInteraction.socket','register','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','destroy','end','error','stack','name','send','render','merge','body','contact','message','agent','interaction','account','Users','map','fullname','TagIds','Tags','forEach','MailMessage','findOne','out','plainBody','-id','trimStart','MailInteraction','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','field','color','from','select','u.id','u.fullname','ui.MailInteractionId','left_join','users','u.id\x20=\x20ui.UserId','mail_interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','a.id\x20=\x20i.MailAccountId','me.MailInteractionId\x20=\x20i.id','tools_tags','t.id\x20=\x20it.TagId','expr','search'];(function(_0x3193dd,_0x590238){var _0x1baffa=function(_0x2523f1){while(--_0x2523f1){_0x3193dd['push'](_0x3193dd['shift']());}};_0x1baffa(++_0x590238);}(_0x0360,0x181));var _0x0036=function(_0xf017ad,_0x12f42f){_0xf017ad=_0xf017ad-0x0;var _0x29e990=_0x0360[_0xf017ad];return _0x29e990;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x0036('0x0'));var zipdir=require(_0x0036('0x1'));var jsonpatch=require(_0x0036('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x0036('0x3'));var Mustache=require('mustache');var util=require(_0x0036('0x4'));var path=require('path');var sox=require(_0x0036('0x5'));var csv=require(_0x0036('0x6'));var ejs=require(_0x0036('0x7'));var fs=require('fs');var fs_extra=require(_0x0036('0x8'));var _=require('lodash');var squel=require(_0x0036('0x9'));var crypto=require('crypto');var jsforce=require(_0x0036('0xa'));var deskjs=require(_0x0036('0xb'));var toCsv=require(_0x0036('0x6'));var querystring=require('querystring');var Papa=require(_0x0036('0xc'));var htmlToText=require('html-to-text');var juice=require(_0x0036('0xd'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x0036('0xe'));var hardwareService=require(_0x0036('0xf'));var logger=require(_0x0036('0x10'))(_0x0036('0x11'));var utils=require('../../config/utils');var config=require(_0x0036('0x12'));var licenseUtil=require('../../config/license/util');var db=require(_0x0036('0x13'))['db'];config[_0x0036('0x14')]=_[_0x0036('0x15')](config[_0x0036('0x14')],{'host':'localhost','port':0x18eb});var socket=require(_0x0036('0x16'))(new Redis(config[_0x0036('0x14')]));require(_0x0036('0x17'))[_0x0036('0x18')](socket);function respondWithStatusCode(_0x4ec321,_0x186ce1){_0x186ce1=_0x186ce1||0xcc;return function(_0x421e62){if(_0x421e62){return _0x4ec321[_0x0036('0x19')](_0x186ce1);}return _0x4ec321[_0x0036('0x1a')](_0x186ce1)['end']();};}function respondWithResult(_0x578b9d,_0x3cff4b){_0x3cff4b=_0x3cff4b||0xc8;return function(_0x3905b4){if(_0x3905b4){return _0x578b9d[_0x0036('0x1a')](_0x3cff4b)[_0x0036('0x1b')](_0x3905b4);}};}function respondWithFilteredResult(_0x4b9421,_0xde2c32){return function(_0x47d490){if(_0x47d490){var _0x5be1de=typeof _0xde2c32[_0x0036('0x1c')]===_0x0036('0x1d')&&typeof _0xde2c32[_0x0036('0x1e')]===_0x0036('0x1d');var _0x2dab73=_0x47d490[_0x0036('0x1f')];var _0x592007=_0x5be1de?0x0:_0xde2c32[_0x0036('0x1c')];var _0x33b6f9=_0x5be1de?_0x47d490['count']:_0xde2c32[_0x0036('0x1c')]+_0xde2c32['limit'];var _0x369e1a;if(_0x33b6f9>=_0x2dab73){_0x33b6f9=_0x2dab73;_0x369e1a=0xc8;}else{_0x369e1a=0xce;}_0x4b9421['status'](_0x369e1a);return _0x4b9421[_0x0036('0x20')](_0x0036('0x21'),_0x592007+'-'+_0x33b6f9+'/'+_0x2dab73)[_0x0036('0x1b')](_0x47d490);}return null;};}function patchUpdates(_0x172d6d){return function(_0x58a88b){try{jsonpatch[_0x0036('0x22')](_0x58a88b,_0x172d6d,!![]);}catch(_0x39b614){return BPromise[_0x0036('0x23')](_0x39b614);}return _0x58a88b['save']();};}function saveUpdates(_0x5a06b3,_0x4a59cd){return function(_0x181034){if(_0x181034){return _0x181034[_0x0036('0x24')](_0x5a06b3)[_0x0036('0x25')](function(_0x54603b){return _0x54603b;});}return null;};}function removeEntity(_0x30100a,_0x4fc74e){return function(_0x4cf1af){if(_0x4cf1af){return _0x4cf1af[_0x0036('0x26')]()['then'](function(){_0x30100a[_0x0036('0x1a')](0xcc)[_0x0036('0x27')]();});}};}function handleEntityNotFound(_0x3a3b9e,_0x479d07){return function(_0x33da67){if(!_0x33da67){_0x3a3b9e[_0x0036('0x19')](0x194);}return _0x33da67;};}function handleError(_0x385ba6,_0x242a5d){_0x242a5d=_0x242a5d||0x1f4;return function(_0x3a767b){logger[_0x0036('0x28')](_0x3a767b[_0x0036('0x29')]);if(_0x3a767b[_0x0036('0x2a')]){delete _0x3a767b[_0x0036('0x2a')];}_0x385ba6[_0x0036('0x1a')](_0x242a5d)[_0x0036('0x2b')](_0x3a767b);};}function getMustacheRender(_0x4e8faf,_0x57df2a){return Mustache[_0x0036('0x2c')](_0x4e8faf,_[_0x0036('0x2d')](_0x57df2a[_0x0036('0x2e')],{'contact':_0x57df2a[_0x0036('0x2f')],'message':_0x57df2a[_0x0036('0x30')],'agent':_0x57df2a[_0x0036('0x31')],'interaction':_0x57df2a[_0x0036('0x32')],'account':_0x57df2a[_0x0036('0x33')]}))||'';}function getInteractionUsers(_0x16c65f,_0x4078c4){return new BPromise(function(_0x1d7120,_0x4a9877){try{if(_0x4078c4[_0x16c65f['id']]){_0x16c65f[_0x0036('0x34')]=_[_0x0036('0x35')](_0x4078c4[_0x16c65f['id']],function(_0x5122c2){return{'id':_0x5122c2['id'],'fullname':_0x5122c2[_0x0036('0x36')]};});}}catch(_0x319874){_0x4a9877(_0x319874);}_0x1d7120(_0x16c65f);});}function getInteractionTags(_0x3ee814,_0x53423a){return new BPromise(function(_0x412773,_0x571143){try{if(_0x3ee814[_0x0036('0x37')]){_0x3ee814[_0x0036('0x38')]=[];_0x3ee814['TagIds']['split'](',')[_0x0036('0x39')](function(_0x310039){_0x3ee814['Tags']['push'](_0x53423a[_0x310039]);});}delete _0x3ee814[_0x0036('0x37')];}catch(_0xec0db3){_0x571143(_0xec0db3);}_0x412773(_0x3ee814);});}function getLastMessageText(_0x30b82c){return new BPromise(function(_0xf33aa7,_0xc3e366){return db[_0x0036('0x3a')][_0x0036('0x3b')]({'where':{'$and':[{'MailInteractionId':_0x30b82c['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':_0x0036('0x3c')},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0x0036('0x3d')],'order':_0x0036('0x3e'),'raw':!![]})[_0x0036('0x25')](function(_0x51c03e){if(_0x51c03e&&_0x51c03e[_0x0036('0x3d')]){_0x30b82c['lastMsgText']=_[_0x0036('0x3f')](_0x51c03e['plainBody']);}_0xf33aa7(_0x30b82c);})['catch'](function(_0x7b4b78){_0xc3e366(_0x7b4b78);});});}function updateMailInteraction(_0x555e3e,_0x26dc8f,_0x4d9c8f,_0x2ba52a){return new BPromise(function(_0x5c1e79,_0x3e96f9){return getInteractionUsers(_0x555e3e,_0x4d9c8f)[_0x0036('0x25')](function(_0x23fb99){return getInteractionTags(_0x23fb99,_0x26dc8f);})[_0x0036('0x25')](function(_0x59d99b){if(_0x2ba52a){_0x5c1e79(getLastMessageText(_0x59d99b));}else{_0x5c1e79(_0x59d99b);}})['catch'](function(_0x970cc4){_0x3e96f9(_0x970cc4);});});}exports['index']=function(_0x1da95c,_0x9cdeb2){var _0x550d11={},_0x406afd={},_0x519ff3={'count':0x0,'rows':[]};var _0x2082a3=_[_0x0036('0x35')](db[_0x0036('0x40')][_0x0036('0x41')],function(_0x3ab8d8){return{'name':_0x3ab8d8[_0x0036('0x42')],'type':_0x3ab8d8[_0x0036('0x43')][_0x0036('0x44')]};});_0x406afd[_0x0036('0x45')]=_[_0x0036('0x35')](_0x2082a3,_0x0036('0x2a'));_0x406afd['query']=_[_0x0036('0x46')](_0x1da95c[_0x0036('0x47')]);_0x406afd[_0x0036('0x48')]=_[_0x0036('0x49')](_0x406afd['model'],_0x406afd[_0x0036('0x47')]);_0x550d11[_0x0036('0x4a')]=_[_0x0036('0x49')](_0x406afd[_0x0036('0x45')],qs[_0x0036('0x4b')](_0x1da95c['query'][_0x0036('0x4b')]));_0x550d11['attributes']=_0x550d11['attributes'][_0x0036('0x4c')]?_0x550d11[_0x0036('0x4a')]:_0x406afd[_0x0036('0x45')];if(!_0x1da95c[_0x0036('0x47')][_0x0036('0x4d')](_0x0036('0x4e'))){_0x550d11[_0x0036('0x1e')]=qs[_0x0036('0x1e')](_0x1da95c[_0x0036('0x47')][_0x0036('0x1e')]);_0x550d11[_0x0036('0x1c')]=qs[_0x0036('0x1c')](_0x1da95c[_0x0036('0x47')][_0x0036('0x1c')]);}_0x550d11[_0x0036('0x4f')]=qs[_0x0036('0x50')](_0x1da95c['query'][_0x0036('0x50')]);_0x550d11['where']=qs['filters'](_['pick'](_0x1da95c['query'],_0x406afd[_0x0036('0x48')]),_0x2082a3);var _0x3605b3=[];var _0xbf8c17=squel['select']()[_0x0036('0x51')]('id')[_0x0036('0x51')](_0x0036('0x2a'))[_0x0036('0x51')](_0x0036('0x52'))[_0x0036('0x53')]('tools_tags');var _0xc3009b=squel[_0x0036('0x54')]()[_0x0036('0x51')](_0x0036('0x55'))[_0x0036('0x51')](_0x0036('0x56'))['field'](_0x0036('0x57'))[_0x0036('0x53')]('user_has_mail_interactions','ui')[_0x0036('0x58')](_0x0036('0x59'),'u',_0x0036('0x5a'));var _0x30d9ad=squel[_0x0036('0x54')]()[_0x0036('0x53')](_0x0036('0x5b'),'i')[_0x0036('0x58')]('cm_contacts','c',_0x0036('0x5c'))[_0x0036('0x58')](_0x0036('0x59'),'o',_0x0036('0x5d'))['left_join'](_0x0036('0x5e'),'a',_0x0036('0x5f'))[_0x0036('0x58')]('mail_messages','me',_0x0036('0x60'))[_0x0036('0x58')]('mail_interaction_has_tags','it','it.MailInteractionId\x20=\x20i.id')[_0x0036('0x58')](_0x0036('0x61'),'t',_0x0036('0x62'));var _0x145f03=squel['expr']();var _0x5e344f=[];var _0x23744f=squel[_0x0036('0x63')]();var _0x52a209;if(_0x1da95c[_0x0036('0x47')][_0x0036('0x64')]){_0x52a209=as[_0x0036('0x65')](_0x1da95c[_0x0036('0x47')][_0x0036('0x64')]);var _0x7d2576=_0x52a209['sqlOperator'];for(var _0x5ef39a=0x0;_0x5ef39a<_0x52a209[_0x0036('0x66')][_0x0036('0x4c')];_0x5ef39a++){var _0xbd2d34=_0x52a209['conditions'][_0x5ef39a];var _0x2cfc89='i';var _0x381b1a=_['find'](_0x2082a3,[_0x0036('0x2a'),_0xbd2d34['field']]);if(!_0x381b1a){switch(_0xbd2d34['field']){case _0x0036('0x67'):if(_0xbd2d34[_0x0036('0x68')]==0x1){_0x30d9ad[_0x0036('0x69')]('`'+_0xbd2d34['field']+_0x0036('0x6a'));}else{_0x30d9ad['having']('`'+_0xbd2d34[_0x0036('0x51')]+'`\x20>\x200');}break;case _0x0036('0x6b'):if(_0xbd2d34[_0x0036('0x6c')]==='$substring'){if(_0xbd2d34['value'][_0x0036('0x6d')]('\x20')[_0x0036('0x4c')]>0x1){_0x145f03[_0x7d2576](_0x0036('0x6e'),qs[_0x0036('0x6f')](_0xbd2d34[_0x0036('0x68')]),null);}else{var _0x32d2f0='%'+_0xbd2d34['value']+'%';_0x145f03[_0x7d2576]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x32d2f0,_0x32d2f0,_0x32d2f0);}}else{_0x381b1a=_[_0x0036('0x70')](_0x2082a3,[_0x0036('0x2a'),_0x0036('0x71')]);_0xbd2d34[_0x0036('0x51')]=_0x0036('0x71');_0x176ae2=as[_0x0036('0x72')](_0x2cfc89,_0x381b1a['type'],_0xbd2d34);_0x145f03[_0x7d2576](_0x176ae2['text'],_0x176ae2[_0x0036('0x68')][_0x0036('0x73')],_0x176ae2[_0x0036('0x68')][_0x0036('0x27')]);}break;case _0x0036('0x74'):var _0xa29e41=_0xbd2d34[_0x0036('0x68')][_0x0036('0x6d')](',')[_0x0036('0x35')](function(_0x42132a){return Number(_0x42132a);});_0xa29e41[_0x0036('0x39')](function(_0x61d588){_0x23744f['or'](_0x0036('0x75'),'%,'+_0x61d588+',%');});_0x5e344f=_[_0x0036('0x76')](_0x5e344f,_0xa29e41);break;case _0x0036('0x77'):if(_0xbd2d34[_0x0036('0x6c')]===_0x0036('0x78')){_0x145f03[_0x7d2576](_0x0036('0x79'),'%'+_0xbd2d34[_0x0036('0x68')]+'%',null);}else{_0x381b1a=_[_0x0036('0x70')](_0x2082a3,[_0x0036('0x2a'),'UserId']);_0xbd2d34[_0x0036('0x51')]='UserId';_0x176ae2=as[_0x0036('0x72')](_0x2cfc89,_0x381b1a[_0x0036('0x43')],_0xbd2d34);_0x145f03[_0x7d2576](_0x176ae2[_0x0036('0x7a')],_0x176ae2[_0x0036('0x68')][_0x0036('0x73')],_0x176ae2[_0x0036('0x68')][_0x0036('0x27')]);}break;case _0x0036('0x3d'):_0x176ae2=as[_0x0036('0x72')]('me',null,_0xbd2d34);_0x145f03[_0x7d2576](_0x176ae2[_0x0036('0x7a')],_0x176ae2[_0x0036('0x68')]['start'],_0x176ae2[_0x0036('0x68')][_0x0036('0x27')]);break;}}else{var _0x176ae2=as[_0x0036('0x72')](_0x2cfc89,_0x381b1a['type'],_0xbd2d34);_0x145f03[_0x7d2576](_0x176ae2[_0x0036('0x7a')],_0x176ae2[_0x0036('0x68')]['start'],_0x176ae2[_0x0036('0x68')]['end']);}}}else{var _0x32c7d2=_(_0x1da95c[_0x0036('0x47')])[_0x0036('0x46')]()[_0x0036('0x35')](function(_0x217509){return _[_0x0036('0x7b')](_0x2082a3,['name',_0x217509])?_0x217509:undefined;})[_0x0036('0x7c')]()[_0x0036('0x68')]();if(!_[_0x0036('0x7d')](_0x32c7d2)){_0x32c7d2['forEach'](function(_0x4aa92f){if(_0x4aa92f===_0x0036('0x7e')){_0x30d9ad['where']('i.MailAccountId\x20IN\x20?',[]['concat'](_0x1da95c[_0x0036('0x47')][_0x4aa92f]));}else if(_0x4aa92f===_0x0036('0x7f')){var _0x52082a=JSON[_0x0036('0x80')](_0x1da95c[_0x0036('0x47')][_0x4aa92f])['$gte'];var _0x29cc1e=JSON[_0x0036('0x80')](_0x1da95c[_0x0036('0x47')][_0x4aa92f])[_0x0036('0x81')];_0x30d9ad[_0x0036('0x82')](_0x0036('0x83'),_0x52082a,_0x29cc1e);}else{if(_0x1da95c[_0x0036('0x47')][_0x4aa92f]===_0x0036('0x84')){_0x30d9ad[_0x0036('0x82')]('i.'+_0x4aa92f+'\x20IS\x20NULL');}else{_0x30d9ad['where']('i.'+_0x4aa92f+_0x0036('0x85'),_0x1da95c[_0x0036('0x47')][_0x4aa92f]);}}});}if(_0x1da95c[_0x0036('0x47')][_0x0036('0x86')]){if(_0x1da95c[_0x0036('0x47')]['read']==0x1){_0x30d9ad[_0x0036('0x69')]('`unreadMessages`\x20=\x200');}else{_0x30d9ad[_0x0036('0x69')](_0x0036('0x87'));}}if(_0x1da95c['query'][_0x0036('0x88')]){_0x5e344f=_[_0x0036('0x89')](_0x1da95c[_0x0036('0x47')][_0x0036('0x88')])?_0x1da95c[_0x0036('0x47')][_0x0036('0x88')]:new Array(_0x1da95c['query'][_0x0036('0x88')]);_0x5e344f[_0x0036('0x39')](function(_0x1295b8){_0x23744f['or'](_0x0036('0x75'),'%,'+_0x1295b8+',%');});}if(_0x1da95c[_0x0036('0x47')][_0x0036('0x8a')]){var _0x5dd363=_0x1da95c[_0x0036('0x47')][_0x0036('0x8a')][_0x0036('0x8b')]('\x5c','\x5c\x5c')[_0x0036('0x8b')](/'/g,'\x27\x27');if(qs[_0x0036('0x8c')](_0x5dd363)){_0x145f03['or']('i.id\x20LIKE\x20?',_0x5dd363+'%');}else if(qs[_0x0036('0x8d')](_0x5dd363)){_0x145f03['or'](_0x0036('0x8e'),_0x5dd363+'%');}else{_0x145f03['or'](_0x0036('0x8f'),qs[_0x0036('0x6f')](_0x5dd363))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x0036('0x6f')](_0x5dd363));}}}_0x30d9ad[_0x0036('0x82')](_0x145f03);_0x30d9ad[_0x0036('0x90')](_0x0036('0x91'));var _0x3efc56={'type':db[_0x0036('0x92')][_0x0036('0x93')][_0x0036('0x94')],'raw':!![]};var _0x3ec91c=_0x30d9ad[_0x0036('0x95')]();_0x3ec91c[_0x0036('0x51')]('i.id');_0x3ec91c[_0x0036('0x51')](_0x0036('0x96'),_0x0036('0x67'));if(_0x550d11[_0x0036('0x4f')]){_0x550d11[_0x0036('0x4f')]['forEach'](function(_0x58b2f6){var _0x432396=_0x58b2f6[0x0]==='contactName'?_0x58b2f6[0x0]:'i.'+_0x58b2f6[0x0];_0x30d9ad[_0x0036('0x4f')](_0x432396,_0x58b2f6[0x1]===_0x0036('0x97')?![]:!![]);});}if(!_['isEmpty'](_0x5e344f)){_0x30d9ad[_0x0036('0x69')](_0x23744f);_0x3ec91c[_0x0036('0x82')](_0x0036('0x98'),_0x5e344f);}BPromise[_0x0036('0x99')]()['then'](function(){if(!_0x52a209){if(_0x1da95c[_0x0036('0x47')][_0x0036('0x7e')])return;_0x3ec91c[_0x0036('0x82')](_0x0036('0x9a'));_0x30d9ad[_0x0036('0x82')](_0x0036('0x9a'));return;}if(_0x1da95c[_0x0036('0x9b')]['role']!=='agent')return;return _0x1da95c['user'][_0x0036('0x9c')]({'attributes':['id'],'raw':!![]})[_0x0036('0x25')](function(_0x1f832e){if(_[_0x0036('0x7d')](_0x1f832e)){_0x3ec91c['where'](_0x0036('0x9d'));_0x30d9ad['where'](_0x0036('0x9d'));}else{_0x3ec91c[_0x0036('0x82')](_0x0036('0x9e'),_[_0x0036('0x35')](_0x1f832e,'id'));_0x30d9ad[_0x0036('0x82')](_0x0036('0x9e'),_['map'](_0x1f832e,'id'));}});})[_0x0036('0x25')](function(){if(_0x1da95c[_0x0036('0x9b')]['role']===_0x0036('0x31')&&!_0x52a209&&!_0x1da95c['query'][_0x0036('0x7e')])return[];return db[_0x0036('0x9f')][_0x0036('0x47')](_0x3ec91c[_0x0036('0xa0')](),_0x3efc56);})[_0x0036('0x25')](function(_0xe773b8){_0x519ff3[_0x0036('0x1f')]=_0xe773b8[_0x0036('0x4c')];if(_0x519ff3[_0x0036('0x1f')]===0x0)return[];return db['sequelize']['query'](_0xbf8c17[_0x0036('0xa0')](),_0x3efc56)[_0x0036('0x25')](function(_0x44dac3){_0x3605b3=_[_0x0036('0xa1')](_0x44dac3,'id');_0x3efc56=_[_0x0036('0x2d')](_0x3efc56,{'model':db['MailInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x1da95c[_0x0036('0x47')][_0x0036('0x4b')]){_0x550d11['attributes'][_0x0036('0x39')](function(_0x1de7e3){_0x30d9ad['field']('i.'+_0x1de7e3);});}else{_0x30d9ad[_0x0036('0x51')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x0036('0x67'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xa2'),_0x0036('0xa3'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xa4'),_0x0036('0xa5'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xa6'),_0x0036('0xa7'));_0x30d9ad[_0x0036('0x51')](_0x0036('0x91'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xa8'));_0x30d9ad[_0x0036('0x51')]('i.updatedAt');_0x30d9ad[_0x0036('0x51')](_0x0036('0xa9'));_0x30d9ad[_0x0036('0x51')]('i.closedAt');_0x30d9ad[_0x0036('0x51')]('i.attach');_0x30d9ad[_0x0036('0x51')](_0x0036('0xaa'));_0x30d9ad['field'](_0x0036('0xab'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xac'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xad'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xae'));_0x30d9ad[_0x0036('0x51')]('i.thirdDisposition');_0x30d9ad[_0x0036('0x51')](_0x0036('0xaf'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb0'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb1'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb2'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb3'));_0x30d9ad['field'](_0x0036('0xb4'),_0x0036('0xb5'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb6'),'Contact.lastName');_0x30d9ad[_0x0036('0x51')]('c.email',_0x0036('0xb7'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xb8'),_0x0036('0xb9'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xba'),'Contact.mobile');_0x30d9ad[_0x0036('0x51')]('c.fax','Contact.fax');_0x30d9ad['field'](_0x0036('0xbb'),'Owner.fullname');_0x30d9ad[_0x0036('0x51')]('o.internal',_0x0036('0xbc'));_0x30d9ad[_0x0036('0x51')](_0x0036('0xbd'),_0x0036('0x37'));}if(_0x550d11['limit'])_0x30d9ad[_0x0036('0x1e')](_0x550d11[_0x0036('0x1e')]);if(_0x550d11[_0x0036('0x1c')])_0x30d9ad[_0x0036('0x1c')](_0x550d11[_0x0036('0x1c')]);return db[_0x0036('0x9f')]['query'](_0x30d9ad['toString'](),_0x3efc56);})[_0x0036('0x25')](function(_0x3524d8){if(_0x3524d8[_0x0036('0x4c')]>0x0)_0xc3009b[_0x0036('0x82')](_0x0036('0xbe'),_['map'](_0x3524d8,'id'));return db['sequelize'][_0x0036('0x47')](_0xc3009b[_0x0036('0xa0')](),_0x3efc56)[_0x0036('0x25')](function(_0x4b31d2){var _0x2e9776=_[_0x0036('0xbf')](_0x4b31d2,_0x0036('0xc0'));var _0x3f116d=[];return db[_0x0036('0xc1')]['findOne']({'attributes':[_0x0036('0xc2')],'raw':!![]})[_0x0036('0x25')](function(_0xe56710){var _0xc414fd=_0xe56710[_0x0036('0xc2')];_0x3524d8[_0x0036('0x39')](function(_0x14ed82){_0x3f116d['push'](updateMailInteraction(_0x14ed82,_0x3605b3,_0x2e9776,_0xc414fd));});return BPromise[_0x0036('0xc3')](_0x3f116d);});});});})['then'](function(_0x1b2015){_0x519ff3[_0x0036('0xc4')]=_0x1b2015;return _0x519ff3;})['then'](respondWithFilteredResult(_0x9cdeb2,_0x550d11))['catch'](handleError(_0x9cdeb2,null));};exports[_0x0036('0xc5')]=function(_0x1c90f2,_0x580fe7){var _0x5451bc={'raw':![],'where':{'id':_0x1c90f2['params']['id']}},_0x344e7e={};_0x344e7e[_0x0036('0x45')]=_['keys'](db[_0x0036('0x40')]['rawAttributes']);_0x344e7e['query']=_[_0x0036('0x46')](_0x1c90f2[_0x0036('0x47')]);_0x344e7e[_0x0036('0x48')]=_[_0x0036('0x49')](_0x344e7e[_0x0036('0x45')],_0x344e7e['query']);_0x5451bc[_0x0036('0x4a')]=_['intersection'](_0x344e7e[_0x0036('0x45')],qs[_0x0036('0x4b')](_0x1c90f2[_0x0036('0x47')][_0x0036('0x4b')]));_0x5451bc['attributes']=_0x5451bc['attributes'][_0x0036('0x4c')]?_0x5451bc[_0x0036('0x4a')]:_0x344e7e[_0x0036('0x45')];if(_0x1c90f2[_0x0036('0x47')][_0x0036('0xc6')]){_0x5451bc[_0x0036('0xc7')]=[{'all':!![]}];}_0x5451bc=_['merge']({},_0x5451bc,_0x1c90f2[_0x0036('0xc8')]);return db[_0x0036('0x40')][_0x0036('0x70')](_0x5451bc)[_0x0036('0x25')](handleEntityNotFound(_0x580fe7,null))[_0x0036('0x25')](respondWithResult(_0x580fe7,null))[_0x0036('0xc9')](handleError(_0x580fe7,null));};exports[_0x0036('0xca')]=function(_0x1b4b24,_0x1430df){return db['MailInteraction'][_0x0036('0xca')](_0x1b4b24[_0x0036('0x2e')],{})[_0x0036('0x25')](respondWithResult(_0x1430df,0xc9))['catch'](handleError(_0x1430df,null));};exports[_0x0036('0x24')]=function(_0x397c3f,_0x5a58fd){if(_0x397c3f[_0x0036('0x2e')]['id']){delete _0x397c3f[_0x0036('0x2e')]['id'];}return db[_0x0036('0x40')]['find']({'where':{'id':_0x397c3f[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x5a58fd,null))[_0x0036('0x25')](saveUpdates(_0x397c3f['body'],null))[_0x0036('0x25')](respondWithResult(_0x5a58fd,null))[_0x0036('0xc9')](handleError(_0x5a58fd,null));};exports[_0x0036('0x26')]=function(_0x5f07bb,_0x441ccc){return db[_0x0036('0x40')][_0x0036('0x70')]({'where':{'id':_0x5f07bb[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x441ccc,null))[_0x0036('0x25')](removeEntity(_0x441ccc,null))[_0x0036('0xc9')](handleError(_0x441ccc,null));};exports[_0x0036('0xcc')]=function(_0x13c628,_0x1cf9fc){return db[_0x0036('0x40')][_0x0036('0xcc')]()[_0x0036('0x25')](respondWithResult(_0x1cf9fc,null))[_0x0036('0xc9')](handleError(_0x1cf9fc,null));};exports[_0x0036('0xcd')]=function(_0x3ce8a3,_0x1ecf54,_0x47adda){return db[_0x0036('0x3a')]['find']({'where':{'id':_0x3ce8a3[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x1ecf54,null))[_0x0036('0x25')](function(_0x3344f5){if(_0x3344f5){return _0x3344f5['addMessage'](_0x3ce8a3[_0x0036('0x2e')][_0x0036('0xce')],_[_0x0036('0xcf')](_0x3ce8a3[_0x0036('0x2e')],[_0x0036('0xce'),'id'])||{});}})['then'](respondWithResult(_0x1ecf54,null))['catch'](handleError(_0x1ecf54,null));};exports['getMessages']=function(_0x5f1e2d,_0xc9cb48,_0x40ad95){var _0x5b2527={'raw':![],'where':{}};var _0x338f46={};var _0x47179f={'count':0x0,'rows':[]};return db[_0x0036('0x40')]['findOne']({'where':{'id':_0x5f1e2d[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0xc9cb48,null))[_0x0036('0x25')](function(_0x2ab355){if(_0x2ab355){_0x338f46[_0x0036('0x45')]=_[_0x0036('0x46')](db[_0x0036('0x3a')][_0x0036('0x41')]);_0x338f46[_0x0036('0x47')]=_['keys'](_0x5f1e2d[_0x0036('0x47')]);_0x338f46[_0x0036('0x48')]=_[_0x0036('0x49')](_0x338f46[_0x0036('0x45')],_0x338f46[_0x0036('0x47')]);_0x5b2527['attributes']=_['intersection'](_0x338f46['model'],qs[_0x0036('0x4b')](_0x5f1e2d[_0x0036('0x47')][_0x0036('0x4b')]));_0x5b2527[_0x0036('0x4a')]=_0x5b2527['attributes'][_0x0036('0x4c')]?_0x5b2527[_0x0036('0x4a')]:_0x338f46['model'];if(!_0x5f1e2d[_0x0036('0x47')][_0x0036('0x4d')]('nolimit')){_0x5b2527[_0x0036('0x1e')]=qs[_0x0036('0x1e')](_0x5f1e2d['query'][_0x0036('0x1e')]);_0x5b2527[_0x0036('0x1c')]=qs['offset'](_0x5f1e2d[_0x0036('0x47')][_0x0036('0x1c')]);}_0x5b2527[_0x0036('0x4f')]=qs[_0x0036('0x50')](_0x5f1e2d[_0x0036('0x47')][_0x0036('0x50')]);_0x5b2527[_0x0036('0x82')]=qs[_0x0036('0x48')](_[_0x0036('0xd0')](_0x5f1e2d[_0x0036('0x47')],_0x338f46[_0x0036('0x48')]));_0x5b2527[_0x0036('0x82')][_0x0036('0xc0')]=_0x2ab355['id'];if(_0x5f1e2d[_0x0036('0x47')]['filter']){_0x5b2527[_0x0036('0x82')]=_[_0x0036('0x2d')](_0x5b2527[_0x0036('0x82')],{'$or':_['map'](_0x5b2527[_0x0036('0x4a')],function(_0x108153){var _0x5f2dec={};_0x5f2dec[_0x108153]={'$like':'%'+_0x5f1e2d[_0x0036('0x47')]['filter']+'%'};return _0x5f2dec;})});}if(_0x5f1e2d['query'][_0x0036('0xd1')]){var _0x59a49e=_0x5f1e2d[_0x0036('0x47')][_0x0036('0xd1')][_0x0036('0x6d')](',');var _0x450159={};_0x450159[_0x59a49e[0x0]]={'$gte':moment(_0x59a49e[0x1])[_0x0036('0xd2')](_0x0036('0xd3'))};_0x5b2527[_0x0036('0x82')]=_['merge'](_0x5b2527['where'],_0x450159);}_0x5b2527=_[_0x0036('0x2d')]({},_0x5b2527,_0x5f1e2d[_0x0036('0xc8')]);return db[_0x0036('0x3a')][_0x0036('0x1f')]({'where':_0x5b2527[_0x0036('0x82')]})['then'](function(_0x434d1b){_0x47179f[_0x0036('0x1f')]=_0x434d1b;if(_0x5f1e2d[_0x0036('0x47')][_0x0036('0xc6')]){_0x5b2527['include']=[{'all':!![]}];}return db[_0x0036('0x3a')][_0x0036('0xd4')](_0x5b2527);})['then'](function(_0x46e1d5){if(_0x5f1e2d[_0x0036('0x47')][_0x0036('0xd5')]===_0x0036('0xd6')){for(var _0x2e2c11=0x0;_0x2e2c11<_0x46e1d5[_0x0036('0x4c')];_0x2e2c11++){_0x46e1d5[_0x2e2c11]['body']=juice(_0x46e1d5[_0x2e2c11]['body']);}}_0x47179f[_0x0036('0xc4')]=_0x46e1d5;return _0x47179f;});}})[_0x0036('0x25')](respondWithFilteredResult(_0xc9cb48,_0x5b2527))[_0x0036('0xc9')](handleError(_0xc9cb48,null));};exports[_0x0036('0xd7')]=function(_0x59e51c,_0x42e91c,_0x24a41d){return db[_0x0036('0x40')][_0x0036('0x70')]({'where':{'id':_0x59e51c[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x42e91c,null))[_0x0036('0x25')](function(_0x679bb){if(_0x679bb){return _0x679bb['setTags'](_0x59e51c['body'][_0x0036('0xce')],_[_0x0036('0xcf')](_0x59e51c['body'],[_0x0036('0xce'),'id'])||{})[_0x0036('0xd8')](function(){return db[_0x0036('0x74')]['findAll']({'attributes':['id',_0x0036('0x2a'),'color'],'where':{'id':_0x59e51c[_0x0036('0x2e')][_0x0036('0xce')]}});})[_0x0036('0x25')](function(_0x1f933d){socket[_0x0036('0xd9')](_0x0036('0xda'),{'id':Number(_0x59e51c[_0x0036('0xcb')]['id']),'tags':_0x1f933d||[]});return{'id':Number(_0x59e51c[_0x0036('0xcb')]['id']),'tags':_0x1f933d||[]};});}})[_0x0036('0x25')](respondWithResult(_0x42e91c,null))['catch'](handleError(_0x42e91c,null));};exports['removeTags']=function(_0x47fd14,_0x4c31a0,_0xc885ee){return db[_0x0036('0x40')][_0x0036('0x70')]({'where':{'id':_0x47fd14[_0x0036('0xcb')]['id']}})[_0x0036('0x25')](handleEntityNotFound(_0x4c31a0,null))['then'](function(_0x4d9f73){if(_0x4d9f73){return _0x4d9f73['removeTags'](_0x47fd14[_0x0036('0x47')][_0x0036('0xce')]);}})[_0x0036('0x25')](respondWithStatusCode(_0x4c31a0,null))[_0x0036('0xc9')](handleError(_0x4c31a0,null));};exports['download']=function(_0x269613,_0x300446){var _0xa88dc9=moment()[_0x0036('0xdb')]()[_0x0036('0xa0')]();var _0x2c1104=path[_0x0036('0xdc')](config['root'],'server',_0x0036('0xdd'),'tmp');var _0x372ea9=path[_0x0036('0xdc')](config[_0x0036('0xde')],_0x0036('0xdf'),_0x0036('0xdd'),_0x0036('0xe0'));var _0x2b9764=path[_0x0036('0xdc')](_0x2c1104,_0xa88dc9);var _0x7257d5=util[_0x0036('0xd2')](_0x0036('0xe1'),_0x269613[_0x0036('0xcb')]['id'],_0xa88dc9);var _0xbf296d=path[_0x0036('0xdc')](_0x2c1104,_0x7257d5);var _0x40161e=[];if(_0x269613['query']['attachments']){_0x40161e[_0x0036('0xe2')]({'model':db['Attachment'],'as':'Attachments','raw':!![]});}var _0x1ffbd2=[{'model':db[_0x0036('0x3a')],'as':_0x0036('0xe3'),'attributes':['id','body',_0x0036('0x53'),'to','cc','bcc',_0x0036('0xe4'),'createdAt'],'where':{'secret':![]},'order':qs[_0x0036('0x50')]('id'),'include':_0x40161e}];return db[_0x0036('0x40')][_0x0036('0x70')]({'where':{'id':_0x269613[_0x0036('0xcb')]['id']},'include':_0x1ffbd2})['then'](handleEntityNotFound(_0x300446,null))[_0x0036('0x25')](function(_0xa4b36c){if(_0xa4b36c&&_0xa4b36c[_0x0036('0xe3')]){var _0x55777b=_0xa4b36c[_0x0036('0xe5')]({'plain':!![]});fs[_0x0036('0xe6')](_0x2b9764);return BPromise[_0x0036('0xe7')](_0x55777b[_0x0036('0xe3')],function(_0xffaf8d,_0x15b0ea){var _0x1a0d28={'from':_0xffaf8d['from'],'to':_0xffaf8d['to'],'subject':_0xffaf8d[_0x0036('0xe4')],'html':_0xffaf8d[_0x0036('0x2e')],'headers':{'Date':moment(_0xffaf8d['createdAt'])[_0x0036('0xd2')](_0x0036('0xe8'))},'attachments':[]};if(_0xffaf8d['cc']){_0x1a0d28['headers']['Cc']=_0xffaf8d['cc'];}if(_0xffaf8d['bcc']){_0x1a0d28[_0x0036('0xe9')]['Bcc']=_0xffaf8d[_0x0036('0xea')];}return new BPromise(function(_0x57643a,_0x1f0ea6){if(_0xffaf8d[_0x0036('0xeb')]){for(var _0x1ac0bb=0x0;_0x1ac0bb<_0xffaf8d[_0x0036('0xeb')][_0x0036('0x4c')];_0x1ac0bb++){var _0x3ff740=_0xffaf8d['Attachments'][_0x1ac0bb];var _0x437f02=path[_0x0036('0xdc')](_0x372ea9,_0x3ff740[_0x0036('0xec')]);if(fs[_0x0036('0xed')](_0x437f02)){_0x1a0d28[_0x0036('0xe0')]['push']({'name':_0x3ff740[_0x0036('0x2a')],'contentType':_0x3ff740[_0x0036('0x43')],'data':fs[_0x0036('0xee')](_0x437f02)});}}}emlformat[_0x0036('0xef')](_0x1a0d28,function(_0x479527,_0x391f47){if(_0x479527)return _0x1f0ea6(_0x479527);fs[_0x0036('0xf0')](path[_0x0036('0xdc')](_0x2b9764,util[_0x0036('0xd2')]('message%d.eml',_0x15b0ea)),_0x391f47);return _0x57643a(_0x391f47);});});})['then'](function(){return new BPromise(function(_0x5bcb43,_0x337db6){zipdir(_0x2b9764,{'saveTo':_0xbf296d},function(_0x2bdf31,_0x3b3a44){if(_0x2bdf31)return _0x337db6(_0x2bdf31);return _0x5bcb43(_0x3b3a44);});})[_0x0036('0x25')](function(){return new BPromise(function(_0x253267,_0x44b119){rimraf(_0x2b9764,function(_0x5b01ad){if(_0x5b01ad)_0x44b119(_0x5b01ad);return _0x253267();});});})[_0x0036('0x25')](function(){return _0x300446['download'](_0xbf296d,_0x7257d5,function(_0xa84a18){if(_0xa84a18){console['log'](_0x0036('0xf1'),_0xa84a18);}else{fs[_0x0036('0xf2')](_0xbf296d);}});});});}else{return _0x300446['sendStatus'](0xc8);}})[_0x0036('0xc9')](handleError(_0x300446,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff