18 var _0x0e6f=['MailInteraction','rawAttributes','fieldName','type','key','query','keys','filters','attributes','intersection','model','fields','length','nolimit','order','sort','where','pick','field','color','from','tools_tags','select','u.id','u.fullname','user_has_mail_interactions','users','u.id\x20=\x20ui.UserId','mail_interactions','left_join','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','mail_messages','me.MailInteractionId\x20=\x20i.id','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','ContactId','buildExpression','text','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','find','UserId','start','compact','isEmpty','i.MailAccountId\x20IN\x20?','concat','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','replace','i.id\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','Sequelize','QueryTypes','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','DESC','t.id\x20IN\x20?','i.MailAccountId\x20IS\x20NOT\x20NULL','role','agent','user','getMailAccounts','i.MailAccountId\x20IS\x20NULL','sequelize','toString','merge','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.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.subject','i.disposition','i.secondDisposition','i.thirdDisposition','i.substatus','i.to','i.ContactId','i.MailAccountId','c.firstName','Contact.firstName','Contact.lastName','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','enableEmailPreview','all','catch','params','include','options','body','describe','addMessage','MailMessage','omit','ids','getMessages','hasOwnProperty','MailInteractionId','filter','format','YYYY-MM-DD\x20HH:mm:ss','includeAll','findAll','inlineCss','true','rows','addTags','spread','Tag','emit','mailInteractionTags:save','removeTags','unix','root','server','join','files','attachments','transcript-%d-%s.zip','Attachment','Messages','subject','createdAt','mkdirSync','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','bcc','Attachments','basename','existsSync','push','message%d.eml','download','log','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','querystring','papaparse','html-to-text','juice','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','register','end','status','json','offset','limit','undefined','count','set','apply','update','then','destroy','sendStatus','stack','name','Users','map','fullname','TagIds','Tags','split','forEach','findOne','plainBody','-id','lastMsgText'];(function(_0x216915,_0x20a816){var _0x5e1847=function(_0x3fd71f){while(--_0x3fd71f){_0x216915['push'](_0x216915['shift']());}};_0x5e1847(++_0x20a816);}(_0x0e6f,0x1b3));var _0xf0e6=function(_0x313df3,_0x4fca45){_0x313df3=_0x313df3-0x0;var _0x241d59=_0x0e6f[_0x313df3];return _0x241d59;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xf0e6('0x0'));var jsonpatch=require(_0xf0e6('0x1'));var rp=require(_0xf0e6('0x2'));var moment=require(_0xf0e6('0x3'));var BPromise=require(_0xf0e6('0x4'));var Mustache=require(_0xf0e6('0x5'));var util=require(_0xf0e6('0x6'));var path=require('path');var sox=require(_0xf0e6('0x7'));var csv=require(_0xf0e6('0x8'));var ejs=require(_0xf0e6('0x9'));var fs=require('fs');var fs_extra=require(_0xf0e6('0xa'));var _=require('lodash');var squel=require(_0xf0e6('0xb'));var crypto=require(_0xf0e6('0xc'));var jsforce=require(_0xf0e6('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xf0e6('0x8'));var querystring=require(_0xf0e6('0xe'));var Papa=require(_0xf0e6('0xf'));var htmlToText=require(_0xf0e6('0x10'));var juice=require(_0xf0e6('0x11'));var Redis=require(_0xf0e6('0x12'));var authService=require(_0xf0e6('0x13'));var qs=require(_0xf0e6('0x14'));var as=require(_0xf0e6('0x15'));var hardwareService=require(_0xf0e6('0x16'));var logger=require(_0xf0e6('0x17'))(_0xf0e6('0x18'));var utils=require(_0xf0e6('0x19'));var config=require(_0xf0e6('0x1a'));var licenseUtil=require(_0xf0e6('0x1b'));var db=require(_0xf0e6('0x1c'))['db'];config[_0xf0e6('0x1d')]=_[_0xf0e6('0x1e')](config[_0xf0e6('0x1d')],{'host':_0xf0e6('0x1f'),'port':0x18eb});var socket=require(_0xf0e6('0x20'))(new Redis(config['redis']));require(_0xf0e6('0x21'))[_0xf0e6('0x22')](socket);function respondWithStatusCode(_0xa13000,_0x586d2e){_0x586d2e=_0x586d2e||0xcc;return function(_0x92275f){if(_0x92275f){return _0xa13000['sendStatus'](_0x586d2e);}return _0xa13000['status'](_0x586d2e)[_0xf0e6('0x23')]();};}function respondWithResult(_0x326bbe,_0x1d5cc5){_0x1d5cc5=_0x1d5cc5||0xc8;return function(_0x21b8b5){if(_0x21b8b5){return _0x326bbe[_0xf0e6('0x24')](_0x1d5cc5)[_0xf0e6('0x25')](_0x21b8b5);}};}function respondWithFilteredResult(_0x183097,_0x4a042e){return function(_0x3cc2bf){if(_0x3cc2bf){var _0x5170ed=typeof _0x4a042e[_0xf0e6('0x26')]==='undefined'&&typeof _0x4a042e[_0xf0e6('0x27')]===_0xf0e6('0x28');var _0x2e388c=_0x3cc2bf['count'];var _0x27e77f=_0x5170ed?0x0:_0x4a042e['offset'];var _0xdbf2c2=_0x5170ed?_0x3cc2bf[_0xf0e6('0x29')]:_0x4a042e[_0xf0e6('0x26')]+_0x4a042e[_0xf0e6('0x27')];var _0x3623b2;if(_0xdbf2c2>=_0x2e388c){_0xdbf2c2=_0x2e388c;_0x3623b2=0xc8;}else{_0x3623b2=0xce;}_0x183097['status'](_0x3623b2);return _0x183097[_0xf0e6('0x2a')]('Content-Range',_0x27e77f+'-'+_0xdbf2c2+'/'+_0x2e388c)[_0xf0e6('0x25')](_0x3cc2bf);}return null;};}function patchUpdates(_0xdc6afc){return function(_0x13f69d){try{jsonpatch[_0xf0e6('0x2b')](_0x13f69d,_0xdc6afc,!![]);}catch(_0x54668c){return BPromise['reject'](_0x54668c);}return _0x13f69d['save']();};}function saveUpdates(_0x467fe8,_0x33bab5){return function(_0x4bf1d6){if(_0x4bf1d6){return _0x4bf1d6[_0xf0e6('0x2c')](_0x467fe8)[_0xf0e6('0x2d')](function(_0x1eae3d){return _0x1eae3d;});}return null;};}function removeEntity(_0x297c75,_0x2901f2){return function(_0x391189){if(_0x391189){return _0x391189[_0xf0e6('0x2e')]()[_0xf0e6('0x2d')](function(){_0x297c75[_0xf0e6('0x24')](0xcc)[_0xf0e6('0x23')]();});}};}function handleEntityNotFound(_0xbbee9a,_0x5d61d6){return function(_0x5ea97d){if(!_0x5ea97d){_0xbbee9a[_0xf0e6('0x2f')](0x194);}return _0x5ea97d;};}function handleError(_0x348d0e,_0x2ea95a){_0x2ea95a=_0x2ea95a||0x1f4;return function(_0x1cb02a){logger['error'](_0x1cb02a[_0xf0e6('0x30')]);if(_0x1cb02a[_0xf0e6('0x31')]){delete _0x1cb02a[_0xf0e6('0x31')];}_0x348d0e[_0xf0e6('0x24')](_0x2ea95a)['send'](_0x1cb02a);};}function getInteractionUsers(_0x3c6adf,_0x247d81){return new BPromise(function(_0x52f9e7,_0x2b9645){try{if(_0x247d81[_0x3c6adf['id']]){_0x3c6adf[_0xf0e6('0x32')]=_[_0xf0e6('0x33')](_0x247d81[_0x3c6adf['id']],function(_0x17e190){return{'id':_0x17e190['id'],'fullname':_0x17e190[_0xf0e6('0x34')]};});}}catch(_0x397c8c){_0x2b9645(_0x397c8c);}_0x52f9e7(_0x3c6adf);});}function getInteractionTags(_0x2c582d,_0x5e44fd){return new BPromise(function(_0xd932e5,_0x57e85b){try{if(_0x2c582d[_0xf0e6('0x35')]){_0x2c582d[_0xf0e6('0x36')]=[];_0x2c582d[_0xf0e6('0x35')][_0xf0e6('0x37')](',')[_0xf0e6('0x38')](function(_0x469104){_0x2c582d['Tags']['push'](_0x5e44fd[_0x469104]);});}delete _0x2c582d[_0xf0e6('0x35')];}catch(_0xc2b0cf){_0x57e85b(_0xc2b0cf);}_0xd932e5(_0x2c582d);});}function getLastMessageText(_0x5e7c7b){return new BPromise(function(_0x5cd4f7,_0x21d136){return db['MailMessage'][_0xf0e6('0x39')]({'where':{'$and':[{'MailInteractionId':_0x5e7c7b['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':'out'},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0xf0e6('0x3a')],'order':_0xf0e6('0x3b'),'raw':!![]})[_0xf0e6('0x2d')](function(_0x5d08b8){if(_0x5d08b8&&_0x5d08b8[_0xf0e6('0x3a')]){_0x5e7c7b[_0xf0e6('0x3c')]=_['trimStart'](_0x5d08b8[_0xf0e6('0x3a')]);}_0x5cd4f7(_0x5e7c7b);})['catch'](function(_0x144578){_0x21d136(_0x144578);});});}function updateMailInteraction(_0x52daab,_0x2e6649,_0x1a8f3c,_0x54ef1a){return new BPromise(function(_0x44cf75,_0x273339){return getInteractionUsers(_0x52daab,_0x1a8f3c)[_0xf0e6('0x2d')](function(_0x3369e7){return getInteractionTags(_0x3369e7,_0x2e6649);})[_0xf0e6('0x2d')](function(_0x8b3a30){if(_0x54ef1a){_0x44cf75(getLastMessageText(_0x8b3a30));}else{_0x44cf75(_0x8b3a30);}})['catch'](function(_0x242a71){_0x273339(_0x242a71);});});}exports['index']=function(_0x186243,_0x584493){var _0xf75877={},_0x1140e9={},_0xeb984={'count':0x0,'rows':[]};var _0x4f85e7=_[_0xf0e6('0x33')](db[_0xf0e6('0x3d')][_0xf0e6('0x3e')],function(_0x3ebb20){return{'name':_0x3ebb20[_0xf0e6('0x3f')],'type':_0x3ebb20[_0xf0e6('0x40')][_0xf0e6('0x41')]};});_0x1140e9['model']=_[_0xf0e6('0x33')](_0x4f85e7,_0xf0e6('0x31'));_0x1140e9[_0xf0e6('0x42')]=_[_0xf0e6('0x43')](_0x186243['query']);_0x1140e9[_0xf0e6('0x44')]=_['intersection'](_0x1140e9['model'],_0x1140e9[_0xf0e6('0x42')]);_0xf75877[_0xf0e6('0x45')]=_[_0xf0e6('0x46')](_0x1140e9[_0xf0e6('0x47')],qs[_0xf0e6('0x48')](_0x186243[_0xf0e6('0x42')]['fields']));_0xf75877[_0xf0e6('0x45')]=_0xf75877[_0xf0e6('0x45')][_0xf0e6('0x49')]?_0xf75877[_0xf0e6('0x45')]:_0x1140e9[_0xf0e6('0x47')];if(!_0x186243['query']['hasOwnProperty'](_0xf0e6('0x4a'))){_0xf75877[_0xf0e6('0x27')]=qs['limit'](_0x186243['query']['limit']);_0xf75877[_0xf0e6('0x26')]=qs[_0xf0e6('0x26')](_0x186243[_0xf0e6('0x42')][_0xf0e6('0x26')]);}_0xf75877[_0xf0e6('0x4b')]=qs[_0xf0e6('0x4c')](_0x186243[_0xf0e6('0x42')][_0xf0e6('0x4c')]);_0xf75877[_0xf0e6('0x4d')]=qs['filters'](_[_0xf0e6('0x4e')](_0x186243[_0xf0e6('0x42')],_0x1140e9[_0xf0e6('0x44')]),_0x4f85e7);var _0x1a5c3c=[];var _0x446773=squel['select']()[_0xf0e6('0x4f')]('id')[_0xf0e6('0x4f')](_0xf0e6('0x31'))['field'](_0xf0e6('0x50'))[_0xf0e6('0x51')](_0xf0e6('0x52'));var _0x5bd54a=squel[_0xf0e6('0x53')]()[_0xf0e6('0x4f')](_0xf0e6('0x54'))['field'](_0xf0e6('0x55'))[_0xf0e6('0x4f')]('ui.MailInteractionId')[_0xf0e6('0x51')](_0xf0e6('0x56'),'ui')['left_join'](_0xf0e6('0x57'),'u',_0xf0e6('0x58'));var _0x3c5ffe=squel['select']()['from'](_0xf0e6('0x59'),'i')[_0xf0e6('0x5a')](_0xf0e6('0x5b'),'c',_0xf0e6('0x5c'))['left_join']('users','o',_0xf0e6('0x5d'))[_0xf0e6('0x5a')](_0xf0e6('0x5e'),'a','a.id\x20=\x20i.MailAccountId')[_0xf0e6('0x5a')](_0xf0e6('0x5f'),'me',_0xf0e6('0x60'))['left_join'](_0xf0e6('0x61'),'it',_0xf0e6('0x62'))[_0xf0e6('0x5a')](_0xf0e6('0x52'),'t',_0xf0e6('0x63'));var _0x1f210b=squel[_0xf0e6('0x64')]();var _0x4c81ea=[];var _0x4fd74d=squel[_0xf0e6('0x64')]();var _0x1c97e9;if(_0x186243[_0xf0e6('0x42')][_0xf0e6('0x65')]){_0x1c97e9=as[_0xf0e6('0x66')](_0x186243['query'][_0xf0e6('0x65')]);var _0x5e15a3=_0x1c97e9[_0xf0e6('0x67')];for(var _0x580002=0x0;_0x580002<_0x1c97e9[_0xf0e6('0x68')]['length'];_0x580002++){var _0x339b96=_0x1c97e9[_0xf0e6('0x68')][_0x580002];var _0xe8c0='i';var _0x1f9e12=_['find'](_0x4f85e7,[_0xf0e6('0x31'),_0x339b96['field']]);if(!_0x1f9e12){switch(_0x339b96['field']){case _0xf0e6('0x69'):if(_0x339b96[_0xf0e6('0x6a')]==0x1){_0x3c5ffe[_0xf0e6('0x6b')]('`'+_0x339b96['field']+_0xf0e6('0x6c'));}else{_0x3c5ffe[_0xf0e6('0x6b')]('`'+_0x339b96[_0xf0e6('0x4f')]+_0xf0e6('0x6d'));}break;case _0xf0e6('0x6e'):if(_0x339b96[_0xf0e6('0x6f')]===_0xf0e6('0x70')){if(_0x339b96[_0xf0e6('0x6a')][_0xf0e6('0x37')]('\x20')[_0xf0e6('0x49')]>0x1){_0x1f210b[_0x5e15a3](_0xf0e6('0x71'),qs[_0xf0e6('0x72')](_0x339b96[_0xf0e6('0x6a')]),null);}else{var _0x522807='%'+_0x339b96['value']+'%';_0x1f210b[_0x5e15a3]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x522807,_0x522807,_0x522807);}}else{_0x1f9e12=_['find'](_0x4f85e7,[_0xf0e6('0x31'),_0xf0e6('0x73')]);_0x339b96[_0xf0e6('0x4f')]=_0xf0e6('0x73');_0x543a9c=as[_0xf0e6('0x74')](_0xe8c0,_0x1f9e12['type'],_0x339b96);_0x1f210b[_0x5e15a3](_0x543a9c[_0xf0e6('0x75')],_0x543a9c[_0xf0e6('0x6a')]['start'],_0x543a9c[_0xf0e6('0x6a')]['end']);}break;case'Tag':var _0x490fb2=_0x339b96[_0xf0e6('0x6a')][_0xf0e6('0x37')](',')[_0xf0e6('0x33')](function(_0x3db403){return Number(_0x3db403);});_0x490fb2['forEach'](function(_0x23586e){_0x4fd74d['or'](_0xf0e6('0x76'),'%,'+_0x23586e+',%');});_0x4c81ea=_[_0xf0e6('0x77')](_0x4c81ea,_0x490fb2);break;case _0xf0e6('0x78'):if(_0x339b96[_0xf0e6('0x6f')]===_0xf0e6('0x70')){_0x1f210b[_0x5e15a3](_0xf0e6('0x79'),'%'+_0x339b96[_0xf0e6('0x6a')]+'%',null);}else{_0x1f9e12=_[_0xf0e6('0x7a')](_0x4f85e7,[_0xf0e6('0x31'),_0xf0e6('0x7b')]);_0x339b96[_0xf0e6('0x4f')]=_0xf0e6('0x7b');_0x543a9c=as[_0xf0e6('0x74')](_0xe8c0,_0x1f9e12[_0xf0e6('0x40')],_0x339b96);_0x1f210b[_0x5e15a3](_0x543a9c[_0xf0e6('0x75')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x7c')],_0x543a9c['value'][_0xf0e6('0x23')]);}break;case _0xf0e6('0x3a'):_0x543a9c=as['buildExpression']('me',null,_0x339b96);_0x1f210b[_0x5e15a3](_0x543a9c[_0xf0e6('0x75')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x7c')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x23')]);break;}}else{var _0x543a9c=as[_0xf0e6('0x74')](_0xe8c0,_0x1f9e12[_0xf0e6('0x40')],_0x339b96);_0x1f210b[_0x5e15a3](_0x543a9c[_0xf0e6('0x75')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x7c')],_0x543a9c[_0xf0e6('0x6a')][_0xf0e6('0x23')]);}}}else{var _0x41f490=_(_0x186243[_0xf0e6('0x42')])[_0xf0e6('0x43')]()[_0xf0e6('0x33')](function(_0x4053bf){return _['some'](_0x4f85e7,[_0xf0e6('0x31'),_0x4053bf])?_0x4053bf:undefined;})[_0xf0e6('0x7d')]()[_0xf0e6('0x6a')]();if(!_[_0xf0e6('0x7e')](_0x41f490)){_0x41f490[_0xf0e6('0x38')](function(_0x5e43e5){if(_0x5e43e5==='MailAccountId'){_0x3c5ffe['where'](_0xf0e6('0x7f'),[][_0xf0e6('0x80')](_0x186243['query'][_0x5e43e5]));}else if(_0x5e43e5==='createdAt'){var _0x25ccb5=JSON[_0xf0e6('0x81')](_0x186243[_0xf0e6('0x42')][_0x5e43e5])[_0xf0e6('0x82')];var _0x4da613=JSON[_0xf0e6('0x81')](_0x186243[_0xf0e6('0x42')][_0x5e43e5])[_0xf0e6('0x83')];_0x3c5ffe[_0xf0e6('0x4d')](_0xf0e6('0x84'),_0x25ccb5,_0x4da613);}else{if(_0x186243[_0xf0e6('0x42')][_0x5e43e5]===_0xf0e6('0x85')){_0x3c5ffe[_0xf0e6('0x4d')]('i.'+_0x5e43e5+'\x20IS\x20NULL');}else{_0x3c5ffe[_0xf0e6('0x4d')]('i.'+_0x5e43e5+_0xf0e6('0x86'),_0x186243[_0xf0e6('0x42')][_0x5e43e5]);}}});}if(_0x186243[_0xf0e6('0x42')][_0xf0e6('0x87')]){if(_0x186243[_0xf0e6('0x42')][_0xf0e6('0x87')]==0x1){_0x3c5ffe[_0xf0e6('0x6b')](_0xf0e6('0x88'));}else{_0x3c5ffe[_0xf0e6('0x6b')](_0xf0e6('0x89'));}}if(_0x186243['query'][_0xf0e6('0x8a')]){_0x4c81ea=_[_0xf0e6('0x8b')](_0x186243[_0xf0e6('0x42')][_0xf0e6('0x8a')])?_0x186243[_0xf0e6('0x42')][_0xf0e6('0x8a')]:new Array(_0x186243['query'][_0xf0e6('0x8a')]);_0x4c81ea[_0xf0e6('0x38')](function(_0x4c8f6b){_0x4fd74d['or'](_0xf0e6('0x76'),'%,'+_0x4c8f6b+',%');});}if(_0x186243[_0xf0e6('0x42')]['filter']){var _0x1648de=_0x186243[_0xf0e6('0x42')]['filter'][_0xf0e6('0x8c')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs['isNumeric'](_0x1648de)){_0x1f210b['or'](_0xf0e6('0x8d'),_0x1648de+'%');}else if(qs[_0xf0e6('0x8e')](_0x1648de)){_0x1f210b['or'](_0xf0e6('0x8f'),_0x1648de+'%');}else{_0x1f210b['or'](_0xf0e6('0x90'),qs[_0xf0e6('0x72')](_0x1648de))['or'](_0xf0e6('0x91'),qs[_0xf0e6('0x72')](_0x1648de));}}}_0x3c5ffe[_0xf0e6('0x4d')](_0x1f210b);_0x3c5ffe[_0xf0e6('0x92')](_0xf0e6('0x93'));var _0x4cf681={'type':db[_0xf0e6('0x94')][_0xf0e6('0x95')]['SELECT'],'raw':!![]};var _0x48aed2=_0x3c5ffe[_0xf0e6('0x96')]();_0x48aed2[_0xf0e6('0x4f')](_0xf0e6('0x93'));_0x48aed2['field'](_0xf0e6('0x97'),_0xf0e6('0x69'));if(_0xf75877[_0xf0e6('0x4b')]){_0xf75877['order'][_0xf0e6('0x38')](function(_0x5a4284){var _0xe90cac=_0x5a4284[0x0]==='contactName'?_0x5a4284[0x0]:'i.'+_0x5a4284[0x0];_0x3c5ffe[_0xf0e6('0x4b')](_0xe90cac,_0x5a4284[0x1]===_0xf0e6('0x98')?![]:!![]);});}if(!_[_0xf0e6('0x7e')](_0x4c81ea)){_0x3c5ffe[_0xf0e6('0x6b')](_0x4fd74d);_0x48aed2['where'](_0xf0e6('0x99'),_0x4c81ea);}BPromise['resolve']()['then'](function(){if(!_0x1c97e9){if(_0x186243['query']['MailAccountId'])return;_0x48aed2[_0xf0e6('0x4d')](_0xf0e6('0x9a'));_0x3c5ffe['where'](_0xf0e6('0x9a'));return;}if(_0x186243['user'][_0xf0e6('0x9b')]!==_0xf0e6('0x9c'))return;return _0x186243[_0xf0e6('0x9d')][_0xf0e6('0x9e')]({'attributes':['id'],'raw':!![]})[_0xf0e6('0x2d')](function(_0x5d1085){if(_[_0xf0e6('0x7e')](_0x5d1085)){_0x48aed2[_0xf0e6('0x4d')](_0xf0e6('0x9f'));_0x3c5ffe['where'](_0xf0e6('0x9f'));}else{_0x48aed2[_0xf0e6('0x4d')](_0xf0e6('0x7f'),_['map'](_0x5d1085,'id'));_0x3c5ffe['where'](_0xf0e6('0x7f'),_['map'](_0x5d1085,'id'));}});})['then'](function(){if(_0x186243[_0xf0e6('0x9d')]['role']==='agent'&&!_0x1c97e9&&!_0x186243[_0xf0e6('0x42')]['MailAccountId'])return[];return db[_0xf0e6('0xa0')][_0xf0e6('0x42')](_0x48aed2['toString'](),_0x4cf681);})['then'](function(_0x1efaa6){_0xeb984[_0xf0e6('0x29')]=_0x1efaa6[_0xf0e6('0x49')];if(_0xeb984[_0xf0e6('0x29')]===0x0)return[];return db[_0xf0e6('0xa0')][_0xf0e6('0x42')](_0x446773[_0xf0e6('0xa1')](),_0x4cf681)[_0xf0e6('0x2d')](function(_0x43c503){_0x1a5c3c=_['keyBy'](_0x43c503,'id');_0x4cf681=_[_0xf0e6('0xa2')](_0x4cf681,{'model':db['MailInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x186243[_0xf0e6('0x42')][_0xf0e6('0x48')]){_0xf75877[_0xf0e6('0x45')][_0xf0e6('0x38')](function(_0x256e18){_0x3c5ffe[_0xf0e6('0x4f')]('i.'+_0x256e18);});}else{_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0x97'),'unreadMessages');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xa3'),_0xf0e6('0xa4'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xa5'),_0xf0e6('0xa6'));_0x3c5ffe['field'](_0xf0e6('0xa7'),_0xf0e6('0xa8'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0x93'));_0x3c5ffe['field']('i.createdAt');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xa9'));_0x3c5ffe['field'](_0xf0e6('0xaa'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xab'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xac'));_0x3c5ffe['field'](_0xf0e6('0xad'));_0x3c5ffe[_0xf0e6('0x4f')]('i.lastMsgDirection');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xae'));_0x3c5ffe['field'](_0xf0e6('0xaf'));_0x3c5ffe['field'](_0xf0e6('0xb0'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb1'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb2'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb3'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb4'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb5'));_0x3c5ffe[_0xf0e6('0x4f')]('i.UserId');_0x3c5ffe['field'](_0xf0e6('0xb6'),_0xf0e6('0xb7'));_0x3c5ffe['field']('c.lastName',_0xf0e6('0xb8'));_0x3c5ffe['field']('c.email','Contact.email');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xb9'),_0xf0e6('0xba'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xbb'),_0xf0e6('0xbc'));_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xbd'),_0xf0e6('0xbe'));_0x3c5ffe['field'](_0xf0e6('0xbf'),'Owner.fullname');_0x3c5ffe[_0xf0e6('0x4f')](_0xf0e6('0xc0'),'Owner.internal');_0x3c5ffe['field'](_0xf0e6('0xc1'),_0xf0e6('0x35'));}if(_0xf75877[_0xf0e6('0x27')])_0x3c5ffe[_0xf0e6('0x27')](_0xf75877[_0xf0e6('0x27')]);if(_0xf75877['offset'])_0x3c5ffe[_0xf0e6('0x26')](_0xf75877[_0xf0e6('0x26')]);return db[_0xf0e6('0xa0')][_0xf0e6('0x42')](_0x3c5ffe[_0xf0e6('0xa1')](),_0x4cf681);})['then'](function(_0x2570f8){if(_0x2570f8['length']>0x0)_0x5bd54a['where'](_0xf0e6('0xc2'),_[_0xf0e6('0x33')](_0x2570f8,'id'));return db[_0xf0e6('0xa0')][_0xf0e6('0x42')](_0x5bd54a[_0xf0e6('0xa1')](),_0x4cf681)['then'](function(_0x5c15ef){var _0x2624cd=_[_0xf0e6('0xc3')](_0x5c15ef,'MailInteractionId');var _0x2c8554=[];return db['Setting'][_0xf0e6('0x39')]({'attributes':[_0xf0e6('0xc4')],'raw':!![]})[_0xf0e6('0x2d')](function(_0x5c097e){var _0x5bcac2=_0x5c097e[_0xf0e6('0xc4')];_0x2570f8['forEach'](function(_0xd9a66d){_0x2c8554['push'](updateMailInteraction(_0xd9a66d,_0x1a5c3c,_0x2624cd,_0x5bcac2));});return BPromise[_0xf0e6('0xc5')](_0x2c8554);});});});})['then'](function(_0x9e463d){_0xeb984['rows']=_0x9e463d;return _0xeb984;})[_0xf0e6('0x2d')](respondWithFilteredResult(_0x584493,_0xf75877))[_0xf0e6('0xc6')](handleError(_0x584493,null));};exports['show']=function(_0x16b0c7,_0xa41166){var _0x4977bf={'raw':![],'where':{'id':_0x16b0c7[_0xf0e6('0xc7')]['id']}},_0x159b9b={};_0x159b9b[_0xf0e6('0x47')]=_[_0xf0e6('0x43')](db[_0xf0e6('0x3d')][_0xf0e6('0x3e')]);_0x159b9b[_0xf0e6('0x42')]=_['keys'](_0x16b0c7[_0xf0e6('0x42')]);_0x159b9b['filters']=_[_0xf0e6('0x46')](_0x159b9b[_0xf0e6('0x47')],_0x159b9b['query']);_0x4977bf[_0xf0e6('0x45')]=_[_0xf0e6('0x46')](_0x159b9b[_0xf0e6('0x47')],qs['fields'](_0x16b0c7[_0xf0e6('0x42')][_0xf0e6('0x48')]));_0x4977bf['attributes']=_0x4977bf[_0xf0e6('0x45')]['length']?_0x4977bf[_0xf0e6('0x45')]:_0x159b9b[_0xf0e6('0x47')];if(_0x16b0c7[_0xf0e6('0x42')]['includeAll']){_0x4977bf[_0xf0e6('0xc8')]=[{'all':!![]}];}_0x4977bf=_[_0xf0e6('0xa2')]({},_0x4977bf,_0x16b0c7[_0xf0e6('0xc9')]);return db['MailInteraction'][_0xf0e6('0x7a')](_0x4977bf)['then'](handleEntityNotFound(_0xa41166,null))[_0xf0e6('0x2d')](respondWithResult(_0xa41166,null))[_0xf0e6('0xc6')](handleError(_0xa41166,null));};exports['create']=function(_0x5994f5,_0x3fabf9){return db[_0xf0e6('0x3d')]['create'](_0x5994f5[_0xf0e6('0xca')],{})['then'](respondWithResult(_0x3fabf9,0xc9))['catch'](handleError(_0x3fabf9,null));};exports[_0xf0e6('0x2c')]=function(_0x4113a5,_0x1f23f2){if(_0x4113a5['body']['id']){delete _0x4113a5['body']['id'];}return db[_0xf0e6('0x3d')][_0xf0e6('0x7a')]({'where':{'id':_0x4113a5[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x1f23f2,null))[_0xf0e6('0x2d')](saveUpdates(_0x4113a5[_0xf0e6('0xca')],null))[_0xf0e6('0x2d')](respondWithResult(_0x1f23f2,null))[_0xf0e6('0xc6')](handleError(_0x1f23f2,null));};exports[_0xf0e6('0x2e')]=function(_0x4c8212,_0x4a5fbd){return db['MailInteraction'][_0xf0e6('0x7a')]({'where':{'id':_0x4c8212['params']['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x4a5fbd,null))[_0xf0e6('0x2d')](removeEntity(_0x4a5fbd,null))[_0xf0e6('0xc6')](handleError(_0x4a5fbd,null));};exports[_0xf0e6('0xcb')]=function(_0x4f47b6,_0x2cdb03){return db[_0xf0e6('0x3d')][_0xf0e6('0xcb')]()[_0xf0e6('0x2d')](respondWithResult(_0x2cdb03,null))[_0xf0e6('0xc6')](handleError(_0x2cdb03,null));};exports[_0xf0e6('0xcc')]=function(_0x411ed0,_0x2dcfdd,_0x27ff1e){return db[_0xf0e6('0xcd')][_0xf0e6('0x7a')]({'where':{'id':_0x411ed0[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x2dcfdd,null))[_0xf0e6('0x2d')](function(_0x373948){if(_0x373948){return _0x373948[_0xf0e6('0xcc')](_0x411ed0[_0xf0e6('0xca')]['ids'],_[_0xf0e6('0xce')](_0x411ed0[_0xf0e6('0xca')],[_0xf0e6('0xcf'),'id'])||{});}})[_0xf0e6('0x2d')](respondWithResult(_0x2dcfdd,null))[_0xf0e6('0xc6')](handleError(_0x2dcfdd,null));};exports[_0xf0e6('0xd0')]=function(_0x550610,_0x53e278,_0x242d5d){var _0x2992b1={'raw':![],'where':{}};var _0x4434a9={};var _0x2bb5fb={'count':0x0,'rows':[]};return db[_0xf0e6('0x3d')][_0xf0e6('0x39')]({'where':{'id':_0x550610[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x53e278,null))[_0xf0e6('0x2d')](function(_0x3ed3d7){if(_0x3ed3d7){_0x4434a9[_0xf0e6('0x47')]=_[_0xf0e6('0x43')](db[_0xf0e6('0xcd')][_0xf0e6('0x3e')]);_0x4434a9[_0xf0e6('0x42')]=_[_0xf0e6('0x43')](_0x550610[_0xf0e6('0x42')]);_0x4434a9['filters']=_[_0xf0e6('0x46')](_0x4434a9[_0xf0e6('0x47')],_0x4434a9['query']);_0x2992b1[_0xf0e6('0x45')]=_['intersection'](_0x4434a9['model'],qs[_0xf0e6('0x48')](_0x550610['query']['fields']));_0x2992b1[_0xf0e6('0x45')]=_0x2992b1['attributes'][_0xf0e6('0x49')]?_0x2992b1[_0xf0e6('0x45')]:_0x4434a9[_0xf0e6('0x47')];if(!_0x550610[_0xf0e6('0x42')][_0xf0e6('0xd1')]('nolimit')){_0x2992b1[_0xf0e6('0x27')]=qs[_0xf0e6('0x27')](_0x550610['query'][_0xf0e6('0x27')]);_0x2992b1['offset']=qs['offset'](_0x550610[_0xf0e6('0x42')]['offset']);}_0x2992b1[_0xf0e6('0x4b')]=qs['sort'](_0x550610[_0xf0e6('0x42')][_0xf0e6('0x4c')]);_0x2992b1[_0xf0e6('0x4d')]=qs[_0xf0e6('0x44')](_['pick'](_0x550610[_0xf0e6('0x42')],_0x4434a9[_0xf0e6('0x44')]));_0x2992b1['where'][_0xf0e6('0xd2')]=_0x3ed3d7['id'];if(_0x550610['query']['filter']){_0x2992b1[_0xf0e6('0x4d')]=_[_0xf0e6('0xa2')](_0x2992b1[_0xf0e6('0x4d')],{'$or':_[_0xf0e6('0x33')](_0x2992b1[_0xf0e6('0x45')],function(_0x2e898e){var _0x422951={};_0x422951[_0x2e898e]={'$like':'%'+_0x550610['query'][_0xf0e6('0xd3')]+'%'};return _0x422951;})});}if(_0x550610[_0xf0e6('0x42')]['$gte']){var _0x43fbf7=_0x550610['query'][_0xf0e6('0x82')][_0xf0e6('0x37')](',');var _0xb1ce22={};_0xb1ce22[_0x43fbf7[0x0]]={'$gte':moment(_0x43fbf7[0x1])[_0xf0e6('0xd4')](_0xf0e6('0xd5'))};_0x2992b1['where']=_[_0xf0e6('0xa2')](_0x2992b1['where'],_0xb1ce22);}_0x2992b1=_[_0xf0e6('0xa2')]({},_0x2992b1,_0x550610[_0xf0e6('0xc9')]);return db[_0xf0e6('0xcd')][_0xf0e6('0x29')]({'where':_0x2992b1['where']})['then'](function(_0x4e71ad){_0x2bb5fb[_0xf0e6('0x29')]=_0x4e71ad;if(_0x550610[_0xf0e6('0x42')][_0xf0e6('0xd6')]){_0x2992b1[_0xf0e6('0xc8')]=[{'all':!![]}];}return db['MailMessage'][_0xf0e6('0xd7')](_0x2992b1);})[_0xf0e6('0x2d')](function(_0x5deb66){if(_0x550610['query'][_0xf0e6('0xd8')]===_0xf0e6('0xd9')){for(var _0x1a1176=0x0;_0x1a1176<_0x5deb66['length'];_0x1a1176++){_0x5deb66[_0x1a1176][_0xf0e6('0xca')]=juice(_0x5deb66[_0x1a1176][_0xf0e6('0xca')]);}}_0x2bb5fb[_0xf0e6('0xda')]=_0x5deb66;return _0x2bb5fb;});}})[_0xf0e6('0x2d')](respondWithFilteredResult(_0x53e278,_0x2992b1))[_0xf0e6('0xc6')](handleError(_0x53e278,null));};exports[_0xf0e6('0xdb')]=function(_0x17ed25,_0x174aff,_0x4296a7){return db[_0xf0e6('0x3d')][_0xf0e6('0x7a')]({'where':{'id':_0x17ed25[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x174aff,null))[_0xf0e6('0x2d')](function(_0x272f7c){if(_0x272f7c){return _0x272f7c['setTags'](_0x17ed25[_0xf0e6('0xca')][_0xf0e6('0xcf')],_[_0xf0e6('0xce')](_0x17ed25[_0xf0e6('0xca')],[_0xf0e6('0xcf'),'id'])||{})[_0xf0e6('0xdc')](function(){return db[_0xf0e6('0xdd')][_0xf0e6('0xd7')]({'attributes':['id',_0xf0e6('0x31'),'color'],'where':{'id':_0x17ed25[_0xf0e6('0xca')][_0xf0e6('0xcf')]}});})[_0xf0e6('0x2d')](function(_0x579262){socket[_0xf0e6('0xde')](_0xf0e6('0xdf'),{'id':Number(_0x17ed25['params']['id']),'tags':_0x579262||[]});return{'id':Number(_0x17ed25[_0xf0e6('0xc7')]['id']),'tags':_0x579262||[]};});}})[_0xf0e6('0x2d')](respondWithResult(_0x174aff,null))[_0xf0e6('0xc6')](handleError(_0x174aff,null));};exports[_0xf0e6('0xe0')]=function(_0x1d5e2d,_0x1bc886,_0x509fe8){return db[_0xf0e6('0x3d')][_0xf0e6('0x7a')]({'where':{'id':_0x1d5e2d[_0xf0e6('0xc7')]['id']}})[_0xf0e6('0x2d')](handleEntityNotFound(_0x1bc886,null))[_0xf0e6('0x2d')](function(_0x32aa03){if(_0x32aa03){return _0x32aa03[_0xf0e6('0xe0')](_0x1d5e2d[_0xf0e6('0x42')][_0xf0e6('0xcf')]);}})[_0xf0e6('0x2d')](respondWithStatusCode(_0x1bc886,null))[_0xf0e6('0xc6')](handleError(_0x1bc886,null));};exports['download']=function(_0x45f686,_0x297c3d){var _0x14183f=moment()[_0xf0e6('0xe1')]()['toString']();var _0x1273b0=path['join'](config[_0xf0e6('0xe2')],_0xf0e6('0xe3'),'files','tmp');var _0x47127f=path[_0xf0e6('0xe4')](config['root'],'server',_0xf0e6('0xe5'),_0xf0e6('0xe6'));var _0x2385b1=path['join'](_0x1273b0,_0x14183f);var _0x3cff12=util[_0xf0e6('0xd4')](_0xf0e6('0xe7'),_0x45f686[_0xf0e6('0xc7')]['id'],_0x14183f);var _0x56631f=path['join'](_0x1273b0,_0x3cff12);var _0x9375ec=[];if(_0x45f686[_0xf0e6('0x42')][_0xf0e6('0xe6')]){_0x9375ec['push']({'model':db[_0xf0e6('0xe8')],'as':'Attachments','raw':!![]});}var _0x2ababf=[{'model':db[_0xf0e6('0xcd')],'as':_0xf0e6('0xe9'),'attributes':['id',_0xf0e6('0xca'),_0xf0e6('0x51'),'to','cc','bcc',_0xf0e6('0xea'),_0xf0e6('0xeb')],'where':{'secret':![]},'order':qs[_0xf0e6('0x4c')]('id'),'include':_0x9375ec}];return db['MailInteraction'][_0xf0e6('0x7a')]({'where':{'id':_0x45f686[_0xf0e6('0xc7')]['id']},'include':_0x2ababf})[_0xf0e6('0x2d')](handleEntityNotFound(_0x297c3d,null))[_0xf0e6('0x2d')](function(_0x1e89f0){if(_0x1e89f0&&_0x1e89f0[_0xf0e6('0xe9')]){var _0x48df7c=_0x1e89f0['get']({'plain':!![]});fs[_0xf0e6('0xec')](_0x2385b1);return BPromise['each'](_0x48df7c[_0xf0e6('0xe9')],function(_0x5006fc,_0xd58acb){var _0x131845={'from':_0x5006fc['from'],'to':_0x5006fc['to'],'subject':_0x5006fc[_0xf0e6('0xea')],'html':_0x5006fc[_0xf0e6('0xca')],'headers':{'Date':moment(_0x5006fc[_0xf0e6('0xeb')])[_0xf0e6('0xd4')](_0xf0e6('0xed'))},'attachments':[]};if(_0x5006fc['cc']){_0x131845[_0xf0e6('0xee')]['Cc']=_0x5006fc['cc'];}if(_0x5006fc['bcc']){_0x131845['headers'][_0xf0e6('0xef')]=_0x5006fc[_0xf0e6('0xf0')];}return new BPromise(function(_0x217c5d,_0x1ba2a1){if(_0x5006fc[_0xf0e6('0xf1')]){for(var _0x41df91=0x0;_0x41df91<_0x5006fc[_0xf0e6('0xf1')][_0xf0e6('0x49')];_0x41df91++){var _0x22b9f9=_0x5006fc[_0xf0e6('0xf1')][_0x41df91];var _0x444fc6=path['join'](_0x47127f,_0x22b9f9[_0xf0e6('0xf2')]);if(fs[_0xf0e6('0xf3')](_0x444fc6)){_0x131845[_0xf0e6('0xe6')][_0xf0e6('0xf4')]({'name':_0x22b9f9[_0xf0e6('0x31')],'contentType':_0x22b9f9[_0xf0e6('0x40')],'data':fs['readFileSync'](_0x444fc6)});}}}emlformat['build'](_0x131845,function(_0x14d3f5,_0x407605){if(_0x14d3f5)return _0x1ba2a1(_0x14d3f5);fs['writeFileSync'](path['join'](_0x2385b1,util['format'](_0xf0e6('0xf5'),_0xd58acb)),_0x407605);return _0x217c5d(_0x407605);});});})[_0xf0e6('0x2d')](function(){return new BPromise(function(_0x53c569,_0xcec9dc){zipdir(_0x2385b1,{'saveTo':_0x56631f},function(_0x2f2739,_0x11010a){if(_0x2f2739)return _0xcec9dc(_0x2f2739);return _0x53c569(_0x11010a);});})[_0xf0e6('0x2d')](function(){return new BPromise(function(_0x59d909,_0x2b5246){rimraf(_0x2385b1,function(_0x2ab3f1){if(_0x2ab3f1)_0x2b5246(_0x2ab3f1);return _0x59d909();});});})[_0xf0e6('0x2d')](function(){return _0x297c3d[_0xf0e6('0xf6')](_0x56631f,_0x3cff12,function(_0x17dc8b){if(_0x17dc8b){console[_0xf0e6('0xf7')]('err',_0x17dc8b);}else{fs['unlinkSync'](_0x56631f);}});});});}else{return _0x297c3d['sendStatus'](0xc8);}})[_0xf0e6('0xc6')](handleError(_0x297c3d,null));};
git://repos.xcallymotion.com / motion2.git / blob