// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa23f=['buildExpression','some','compact','MailAccountId','i.MailAccountId\x20IN\x20?','concat','createdAt','parse','$gte','null','\x20IS\x20NULL','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','isArray','tag','filter','replace','isNumeric','i.id\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','MATCH\x20(me.plainBody,\x20me.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)','unreadMessages','contactName','DESC','isEmpty','t.id\x20IN\x20?','user','role','agent','getMailAccounts','i.MailAccountId\x20IS\x20NULL','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','i.createdAt','i.updatedAt','i.closed','i.attach','i.lastMsgAt','i.lastMsgDirection','i.thirdDisposition','i.substatus','i.to','i.ContactId','i.MailAccountId','i.UserId','c.firstName','Contact.firstName','c.lastName','c.phone','Contact.phone','c.mobile','c.fax','Contact.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','groupBy','MailInteractionId','Setting','enableEmailPreview','rows','show','params','includeAll','include','merge','options','create','body','destroy','describe','addMessage','MailMessage','ids','omit','getMessages','format','YYYY-MM-DD\x20HH:mm:ss','inlineCss','true','addTags','spread','emit','mailInteractionTags:save','removeTags','download','unix','join','root','files','tmp','attachments','transcript-%d-%s.zip','Attachment','Attachments','Messages','bcc','subject','get','mkdirSync','decode','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','existsSync','readFileSync','writeFileSync','message%d.eml','eml-format','rimraf','bluebird','util','path','lodash','juice','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','sendStatus','status','end','offset','limit','undefined','count','Content-Range','json','update','then','error','stack','name','Users','map','fullname','Tags','TagIds','split','forEach','push','findOne','out','plainBody','-id','lastMsgText','trimStart','catch','waiting','talking','answered','total','closed','UserId','unmanaged','index','MailInteraction','rawAttributes','fieldName','type','key','keys','query','intersection','model','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','select','field','color','from','tools_tags','u.id','u.fullname','ui.MailInteractionId','user_has_mail_interactions','left_join','users','u.id\x20=\x20ui.UserId','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','a.id\x20=\x20i.MailAccountId','mail_messages','me.MailInteractionId\x20=\x20i.id','mail_interaction_has_tags','t.id\x20=\x20it.TagId','expr','search','sqlOperator','conditions','find','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','text','start','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','$substring','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?'];(function(_0x11dc39,_0x491115){var _0x457277=function(_0x1d77cd){while(--_0x1d77cd){_0x11dc39['push'](_0x11dc39['shift']());}};_0x457277(++_0x491115);}(_0xa23f,0x7c));var _0xfa23=function(_0x479ed6,_0x74c485){_0x479ed6=_0x479ed6-0x0;var _0x2e6a58=_0xa23f[_0x479ed6];return _0x2e6a58;};'use strict';var emlformat=require(_0xfa23('0x0'));var rimraf=require(_0xfa23('0x1'));var zipdir=require('zip-dir');var moment=require('moment');var BPromise=require(_0xfa23('0x2'));var util=require(_0xfa23('0x3'));var path=require(_0xfa23('0x4'));var fs=require('fs');var _=require(_0xfa23('0x5'));var squel=require('squel');var juice=require(_0xfa23('0x6'));var Redis=require('ioredis');var qs=require(_0xfa23('0x7'));var as=require(_0xfa23('0x8'));var logger=require(_0xfa23('0x9'))(_0xfa23('0xa'));var config=require('../../config/environment');var db=require(_0xfa23('0xb'))['db'];var htmlEntities=require('html-entities');config[_0xfa23('0xc')]=_[_0xfa23('0xd')](config[_0xfa23('0xc')],{'host':_0xfa23('0xe'),'port':0x18eb});var socket=require(_0xfa23('0xf'))(new Redis(config['redis']));require('./mailInteraction.socket')[_0xfa23('0x10')](socket);function respondWithStatusCode(_0x4ea7a8,_0x3128d3){_0x3128d3=_0x3128d3||0xcc;return function(_0x5c0ec9){if(_0x5c0ec9){return _0x4ea7a8[_0xfa23('0x11')](_0x3128d3);}return _0x4ea7a8[_0xfa23('0x12')](_0x3128d3)[_0xfa23('0x13')]();};}function respondWithResult(_0x52ef2a,_0x1e5ffe){_0x1e5ffe=_0x1e5ffe||0xc8;return function(_0x42380){if(_0x42380){return _0x52ef2a[_0xfa23('0x12')](_0x1e5ffe)['json'](_0x42380);}};}function respondWithFilteredResult(_0x56f927,_0x17e782){return function(_0x23712b){if(_0x23712b){var _0x3f50f0=typeof _0x17e782[_0xfa23('0x14')]==='undefined'&&typeof _0x17e782[_0xfa23('0x15')]===_0xfa23('0x16');var _0x2095a5=_0x23712b[_0xfa23('0x17')];var _0x542d9a=_0x3f50f0?0x0:_0x17e782[_0xfa23('0x14')];var _0x39729e=_0x3f50f0?_0x23712b[_0xfa23('0x17')]:_0x17e782[_0xfa23('0x14')]+_0x17e782[_0xfa23('0x15')];var _0x4e5b77;if(_0x39729e>=_0x2095a5){_0x39729e=_0x2095a5;_0x4e5b77=0xc8;}else{_0x4e5b77=0xce;}_0x56f927['status'](_0x4e5b77);return _0x56f927['set'](_0xfa23('0x18'),_0x542d9a+'-'+_0x39729e+'/'+_0x2095a5)[_0xfa23('0x19')](_0x23712b);}return null;};}function saveUpdates(_0x4bd0e0){return function(_0x9effe6){if(_0x9effe6){return _0x9effe6[_0xfa23('0x1a')](_0x4bd0e0)[_0xfa23('0x1b')](function(_0x54bb04){return _0x54bb04;});}return null;};}function removeEntity(_0x1970ec){return function(_0x452604){if(_0x452604){return _0x452604['destroy']()[_0xfa23('0x1b')](function(){_0x1970ec[_0xfa23('0x12')](0xcc)[_0xfa23('0x13')]();});}};}function handleEntityNotFound(_0x1b9994){return function(_0x2ce89a){if(!_0x2ce89a){_0x1b9994[_0xfa23('0x11')](0x194);}return _0x2ce89a;};}function handleError(_0x31eedb,_0x485838){_0x485838=_0x485838||0x1f4;return function(_0x147228){logger[_0xfa23('0x1c')](_0x147228[_0xfa23('0x1d')]);if(_0x147228[_0xfa23('0x1e')]){delete _0x147228['name'];}_0x31eedb[_0xfa23('0x12')](_0x485838)['send'](_0x147228);};}function getInteractionUsers(_0x34ecab,_0x1abb42){return new BPromise(function(_0x2481e9,_0x26bdce){try{if(_0x1abb42[_0x34ecab['id']]){_0x34ecab[_0xfa23('0x1f')]=_[_0xfa23('0x20')](_0x1abb42[_0x34ecab['id']],function(_0x21bbc0){return{'id':_0x21bbc0['id'],'fullname':_0x21bbc0[_0xfa23('0x21')]};});}}catch(_0x5e1780){_0x26bdce(_0x5e1780);}_0x2481e9(_0x34ecab);});}function getInteractionTags(_0x2ae826,_0x4ab34d){return new BPromise(function(_0x1ae38a,_0x5de208){try{if(_0x2ae826['TagIds']){_0x2ae826[_0xfa23('0x22')]=[];_0x2ae826[_0xfa23('0x23')][_0xfa23('0x24')](',')[_0xfa23('0x25')](function(_0x374169){_0x2ae826[_0xfa23('0x22')][_0xfa23('0x26')](_0x4ab34d[_0x374169]);});}delete _0x2ae826['TagIds'];}catch(_0x591797){_0x5de208(_0x591797);}_0x1ae38a(_0x2ae826);});}function getLastMessageText(_0x47ced6){return new BPromise(function(_0x380d42,_0x6bf719){return db['MailMessage'][_0xfa23('0x27')]({'where':{'$and':[{'MailInteractionId':_0x47ced6['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':_0xfa23('0x28')},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0xfa23('0x29')],'order':_0xfa23('0x2a'),'raw':!![]})[_0xfa23('0x1b')](function(_0x16393f){if(_0x16393f&&_0x16393f[_0xfa23('0x29')]){_0x47ced6[_0xfa23('0x2b')]=_[_0xfa23('0x2c')](_0x16393f['plainBody']);}_0x380d42(_0x47ced6);})[_0xfa23('0x2d')](function(_0x59c393){_0x6bf719(_0x59c393);});});}function updateMailInteraction(_0x9d0602,_0x41d235,_0x451e40,_0xaa1d77){return new BPromise(function(_0x1801f1,_0x8ac724){return getInteractionUsers(_0x9d0602,_0x451e40)[_0xfa23('0x1b')](function(_0x33aa43){return getInteractionTags(_0x33aa43,_0x41d235);})[_0xfa23('0x1b')](function(_0x59aa98){return getStateInteraction(_0x59aa98);})[_0xfa23('0x1b')](function(_0x4e82a3){if(_0xaa1d77){_0x1801f1(getLastMessageText(_0x4e82a3));}else{_0x1801f1(_0x4e82a3);}})[_0xfa23('0x2d')](function(_0x88a593){_0x8ac724(_0x88a593);});});}function getStateInteraction(_0x17c407){return new BPromise(function(_0x30ea1e){_0x17c407[_0xfa23('0x2e')]=0x0;_0x17c407[_0xfa23('0x2f')]=0x0;_0x17c407[_0xfa23('0x30')]=0x0;_0x17c407['unmanaged']=0x0;_0x17c407[_0xfa23('0x31')]=0x0;if(!_0x17c407[_0xfa23('0x32')]&&!_0x17c407[_0xfa23('0x33')]){_0x17c407[_0xfa23('0x2e')]+=0x1;}if(!_0x17c407['closed']&&_0x17c407['UserId']){_0x17c407['talking']+=0x1;if(_0x17c407[_0xfa23('0x2e')]){_0x17c407[_0xfa23('0x2e')]-=0x1;}}if(_0x17c407['closed']&&_0x17c407[_0xfa23('0x33')]){_0x17c407[_0xfa23('0x30')]+=0x1;if(_0x17c407[_0xfa23('0x2f')]){_0x17c407['talking']-=0x1;}}if(_0x17c407[_0xfa23('0x32')]&&!_0x17c407['UserId']){_0x17c407[_0xfa23('0x34')]+=0x1;if(_0x17c407[_0xfa23('0x2e')]){_0x17c407[_0xfa23('0x2e')]-=0x1;}}_0x17c407[_0xfa23('0x31')]+=0x1;_0x30ea1e(_0x17c407);});}exports[_0xfa23('0x35')]=function(_0x80827f,_0x58fc41){var _0xe546db={},_0x3c4743={},_0x43eb23={'count':0x0,'rows':[]};var _0x245f49=_['map'](db[_0xfa23('0x36')][_0xfa23('0x37')],function(_0x15480c){return{'name':_0x15480c[_0xfa23('0x38')],'type':_0x15480c[_0xfa23('0x39')][_0xfa23('0x3a')]};});_0x3c4743['model']=_[_0xfa23('0x20')](_0x245f49,'name');_0x3c4743['query']=_[_0xfa23('0x3b')](_0x80827f[_0xfa23('0x3c')]);_0x3c4743['filters']=_[_0xfa23('0x3d')](_0x3c4743[_0xfa23('0x3e')],_0x3c4743[_0xfa23('0x3c')]);_0xe546db['attributes']=_[_0xfa23('0x3d')](_0x3c4743[_0xfa23('0x3e')],qs[_0xfa23('0x3f')](_0x80827f['query']['fields']));_0xe546db[_0xfa23('0x40')]=_0xe546db['attributes'][_0xfa23('0x41')]?_0xe546db[_0xfa23('0x40')]:_0x3c4743[_0xfa23('0x3e')];if(!_0x80827f['query'][_0xfa23('0x42')](_0xfa23('0x43'))){_0xe546db[_0xfa23('0x15')]=qs[_0xfa23('0x15')](_0x80827f['query'][_0xfa23('0x15')]);_0xe546db[_0xfa23('0x14')]=qs[_0xfa23('0x14')](_0x80827f['query']['offset']);}_0xe546db[_0xfa23('0x44')]=qs['sort'](_0x80827f[_0xfa23('0x3c')][_0xfa23('0x45')]);_0xe546db[_0xfa23('0x46')]=qs[_0xfa23('0x47')](_[_0xfa23('0x48')](_0x80827f[_0xfa23('0x3c')],_0x3c4743['filters']),_0x245f49);var _0xd2345d=[];var _0x1ca7c3=squel[_0xfa23('0x49')]()[_0xfa23('0x4a')]('id')[_0xfa23('0x4a')](_0xfa23('0x1e'))['field'](_0xfa23('0x4b'))[_0xfa23('0x4c')](_0xfa23('0x4d'));var _0x2f6a37=squel[_0xfa23('0x49')]()['field'](_0xfa23('0x4e'))[_0xfa23('0x4a')](_0xfa23('0x4f'))['field'](_0xfa23('0x50'))[_0xfa23('0x4c')](_0xfa23('0x51'),'ui')[_0xfa23('0x52')](_0xfa23('0x53'),'u',_0xfa23('0x54'));var _0x709755=squel['select']()[_0xfa23('0x4c')]('mail_interactions','i')[_0xfa23('0x52')](_0xfa23('0x55'),'c',_0xfa23('0x56'))[_0xfa23('0x52')](_0xfa23('0x53'),'o',_0xfa23('0x57'))['left_join'](_0xfa23('0x58'),'a',_0xfa23('0x59'))[_0xfa23('0x52')](_0xfa23('0x5a'),'me',_0xfa23('0x5b'))[_0xfa23('0x52')](_0xfa23('0x5c'),'it','it.MailInteractionId\x20=\x20i.id')[_0xfa23('0x52')](_0xfa23('0x4d'),'t',_0xfa23('0x5d'));var _0xd64189=squel['expr']();var _0xbb8b7d=[];var _0x9bf852=squel[_0xfa23('0x5e')]();var _0x26e171;if(_0x80827f[_0xfa23('0x3c')][_0xfa23('0x5f')]){_0x26e171=as['parseSearch'](_0x80827f[_0xfa23('0x3c')]['search']);var _0x476fdc=_0x26e171[_0xfa23('0x60')];for(var _0x595cdb=0x0;_0x595cdb<_0x26e171[_0xfa23('0x61')][_0xfa23('0x41')];_0x595cdb++){var _0x5a5397=_0x26e171[_0xfa23('0x61')][_0x595cdb];var _0xb9b7d8='i';var _0x5d3777=_[_0xfa23('0x62')](_0x245f49,[_0xfa23('0x1e'),_0x5a5397[_0xfa23('0x4a')]]);if(!_0x5d3777){switch(_0x5a5397[_0xfa23('0x4a')]){case'unreadMessages':if(_0x5a5397[_0xfa23('0x63')]==0x1){_0x709755[_0xfa23('0x64')]('`'+_0x5a5397['field']+_0xfa23('0x65'));}else{_0x709755[_0xfa23('0x64')]('`'+_0x5a5397[_0xfa23('0x4a')]+_0xfa23('0x66'));}break;case _0xfa23('0x67'):if(_0x5a5397[_0xfa23('0x68')]==='$substring'){if(_0x5a5397[_0xfa23('0x63')][_0xfa23('0x24')]('\x20')[_0xfa23('0x41')]>0x1){_0xd64189[_0x476fdc]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xfa23('0x69')](_0x5a5397[_0xfa23('0x63')]),null);}else{var _0x1ea6a1='%'+_0x5a5397['value']+'%';_0xd64189[_0x476fdc](_0xfa23('0x6a'),_0x1ea6a1,_0x1ea6a1,_0x1ea6a1);}}else{_0x5d3777=_[_0xfa23('0x62')](_0x245f49,[_0xfa23('0x1e'),_0xfa23('0x6b')]);_0x5a5397[_0xfa23('0x4a')]='ContactId';_0x4c2103=as['buildExpression'](_0xb9b7d8,_0x5d3777[_0xfa23('0x39')],_0x5a5397);_0xd64189[_0x476fdc](_0x4c2103[_0xfa23('0x6c')],_0x4c2103[_0xfa23('0x63')][_0xfa23('0x6d')],_0x4c2103['value']['end']);}break;case _0xfa23('0x6e'):var _0x303ee9=_0x5a5397[_0xfa23('0x63')][_0xfa23('0x24')](',')['map'](function(_0x41ac7a){return Number(_0x41ac7a);});_0x303ee9[_0xfa23('0x25')](function(_0x4b1545){_0x9bf852['or'](_0xfa23('0x6f'),'%,'+_0x4b1545+',%');});_0xbb8b7d=_[_0xfa23('0x70')](_0xbb8b7d,_0x303ee9);break;case'User':if(_0x5a5397[_0xfa23('0x68')]===_0xfa23('0x71')){_0xd64189[_0x476fdc](_0xfa23('0x72'),'%'+_0x5a5397[_0xfa23('0x63')]+'%',null);}else{_0x5d3777=_[_0xfa23('0x62')](_0x245f49,[_0xfa23('0x1e'),'UserId']);_0x5a5397[_0xfa23('0x4a')]='UserId';_0x4c2103=as[_0xfa23('0x73')](_0xb9b7d8,_0x5d3777[_0xfa23('0x39')],_0x5a5397);_0xd64189[_0x476fdc](_0x4c2103[_0xfa23('0x6c')],_0x4c2103[_0xfa23('0x63')][_0xfa23('0x6d')],_0x4c2103[_0xfa23('0x63')][_0xfa23('0x13')]);}break;case _0xfa23('0x29'):_0x4c2103=as[_0xfa23('0x73')]('me',null,_0x5a5397);_0xd64189[_0x476fdc](_0x4c2103['text'],_0x4c2103[_0xfa23('0x63')]['start'],_0x4c2103[_0xfa23('0x63')][_0xfa23('0x13')]);break;}}else{var _0x4c2103=as['buildExpression'](_0xb9b7d8,_0x5d3777[_0xfa23('0x39')],_0x5a5397);_0xd64189[_0x476fdc](_0x4c2103['text'],_0x4c2103[_0xfa23('0x63')][_0xfa23('0x6d')],_0x4c2103[_0xfa23('0x63')][_0xfa23('0x13')]);}}}else{var _0x3d0f94=_(_0x80827f[_0xfa23('0x3c')])[_0xfa23('0x3b')]()['map'](function(_0x57a71c){return _[_0xfa23('0x74')](_0x245f49,[_0xfa23('0x1e'),_0x57a71c])?_0x57a71c:undefined;})[_0xfa23('0x75')]()[_0xfa23('0x63')]();if(!_['isEmpty'](_0x3d0f94)){_0x3d0f94[_0xfa23('0x25')](function(_0x4d3144){if(_0x4d3144===_0xfa23('0x76')){_0x709755[_0xfa23('0x46')](_0xfa23('0x77'),[][_0xfa23('0x78')](_0x80827f[_0xfa23('0x3c')][_0x4d3144]));}else if(_0x4d3144===_0xfa23('0x79')){var _0x19c67f=JSON[_0xfa23('0x7a')](_0x80827f[_0xfa23('0x3c')][_0x4d3144])[_0xfa23('0x7b')];var _0x5c3a1e=JSON['parse'](_0x80827f[_0xfa23('0x3c')][_0x4d3144])['$lte'];_0x709755[_0xfa23('0x46')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x19c67f,_0x5c3a1e);}else{if(_0x80827f[_0xfa23('0x3c')][_0x4d3144]===_0xfa23('0x7c')){_0x709755['where']('i.'+_0x4d3144+_0xfa23('0x7d'));}else{_0x709755['where']('i.'+_0x4d3144+'\x20=\x20?',_0x80827f[_0xfa23('0x3c')][_0x4d3144]);}}});}if(_0x80827f[_0xfa23('0x3c')]['read']){if(_0x80827f[_0xfa23('0x3c')][_0xfa23('0x7e')]==0x1){_0x709755[_0xfa23('0x64')](_0xfa23('0x7f'));}else{_0x709755[_0xfa23('0x64')](_0xfa23('0x80'));}}if(_0x80827f[_0xfa23('0x3c')]['tag']){_0xbb8b7d=_[_0xfa23('0x81')](_0x80827f[_0xfa23('0x3c')][_0xfa23('0x82')])?_0x80827f[_0xfa23('0x3c')][_0xfa23('0x82')]:new Array(_0x80827f['query'][_0xfa23('0x82')]);_0xbb8b7d['forEach'](function(_0x5bb05f){_0x9bf852['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x5bb05f+',%');});}if(_0x80827f[_0xfa23('0x3c')][_0xfa23('0x83')]){var _0x1b12af=_0x80827f['query'][_0xfa23('0x83')][_0xfa23('0x84')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0xfa23('0x85')](_0x1b12af)){_0xd64189['or'](_0xfa23('0x86'),_0x1b12af+'%');}else if(qs[_0xfa23('0x87')](_0x1b12af)){_0xd64189['or'](_0xfa23('0x88'),_0x1b12af+'%');}else{_0xd64189['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x1b12af))['or'](_0xfa23('0x89'),qs['getFullTextValue'](_0x1b12af));}}}_0x709755[_0xfa23('0x46')](_0xd64189);_0x709755[_0xfa23('0x8a')](_0xfa23('0x8b'));var _0x4a77e5={'type':db[_0xfa23('0x8c')][_0xfa23('0x8d')][_0xfa23('0x8e')],'raw':!![]};var _0xcf4b16=_0x709755[_0xfa23('0x8f')]();_0xcf4b16[_0xfa23('0x4a')]('i.id');_0xcf4b16[_0xfa23('0x4a')](_0xfa23('0x90'),_0xfa23('0x91'));if(_0xe546db[_0xfa23('0x44')]){_0xe546db[_0xfa23('0x44')][_0xfa23('0x25')](function(_0x56b78d){var _0x11b3fa=_0x56b78d[0x0]===_0xfa23('0x92')?_0x56b78d[0x0]:'i.'+_0x56b78d[0x0];_0x709755['order'](_0x11b3fa,_0x56b78d[0x1]===_0xfa23('0x93')?![]:!![]);});}if(!_[_0xfa23('0x94')](_0xbb8b7d)){_0x709755[_0xfa23('0x64')](_0x9bf852);_0xcf4b16[_0xfa23('0x46')](_0xfa23('0x95'),_0xbb8b7d);}BPromise['resolve']()[_0xfa23('0x1b')](function(){if(!_0x26e171){if(_0x80827f['query']['MailAccountId'])return;_0xcf4b16['where']('i.MailAccountId\x20IS\x20NOT\x20NULL');_0x709755[_0xfa23('0x46')]('i.MailAccountId\x20IS\x20NOT\x20NULL');return;}if(_0x80827f[_0xfa23('0x96')][_0xfa23('0x97')]!==_0xfa23('0x98'))return;return _0x80827f[_0xfa23('0x96')][_0xfa23('0x99')]({'attributes':['id'],'raw':!![]})[_0xfa23('0x1b')](function(_0x23c6f4){if(_[_0xfa23('0x94')](_0x23c6f4)){_0xcf4b16['where'](_0xfa23('0x9a'));_0x709755['where'](_0xfa23('0x9a'));}else{_0xcf4b16[_0xfa23('0x46')]('i.MailAccountId\x20IN\x20?',_[_0xfa23('0x20')](_0x23c6f4,'id'));_0x709755[_0xfa23('0x46')]('i.MailAccountId\x20IN\x20?',_[_0xfa23('0x20')](_0x23c6f4,'id'));}});})['then'](function(){if(_0x80827f[_0xfa23('0x96')]['role']===_0xfa23('0x98')&&!_0x26e171&&!_0x80827f['query'][_0xfa23('0x76')])return[];return db[_0xfa23('0x9b')]['query'](_0xcf4b16[_0xfa23('0x9c')](),_0x4a77e5);})[_0xfa23('0x1b')](function(_0x1787b5){_0x43eb23['count']=_0x1787b5[_0xfa23('0x41')];if(_0x43eb23['count']===0x0)return[];return db[_0xfa23('0x9b')][_0xfa23('0x3c')](_0x1ca7c3[_0xfa23('0x9c')](),_0x4a77e5)[_0xfa23('0x1b')](function(_0x58f34e){_0xd2345d=_[_0xfa23('0x9d')](_0x58f34e,'id');_0x4a77e5=_['merge'](_0x4a77e5,{'model':db[_0xfa23('0x36')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x80827f['query'][_0xfa23('0x3f')]){_0xe546db[_0xfa23('0x40')][_0xfa23('0x25')](function(_0x376b22){_0x709755[_0xfa23('0x4a')]('i.'+_0x376b22);});}else{_0x709755['field'](_0xfa23('0x90'),'unreadMessages');_0x709755['field'](_0xfa23('0x9e'),_0xfa23('0x9f'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xa0'),'Account.mandatoryDisposition');_0x709755[_0xfa23('0x4a')](_0xfa23('0xa1'),_0xfa23('0x92'));_0x709755[_0xfa23('0x4a')](_0xfa23('0x8b'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xa2'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xa3'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xa4'));_0x709755[_0xfa23('0x4a')]('i.closedAt');_0x709755[_0xfa23('0x4a')](_0xfa23('0xa5'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xa6'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xa7'));_0x709755[_0xfa23('0x4a')]('i.subject');_0x709755[_0xfa23('0x4a')]('i.disposition');_0x709755['field']('i.secondDisposition');_0x709755['field'](_0xfa23('0xa8'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xa9'));_0x709755['field'](_0xfa23('0xaa'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xab'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xac'));_0x709755['field'](_0xfa23('0xad'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xae'),_0xfa23('0xaf'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xb0'),'Contact.lastName');_0x709755['field']('c.email','Contact.email');_0x709755[_0xfa23('0x4a')](_0xfa23('0xb1'),_0xfa23('0xb2'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xb3'),'Contact.mobile');_0x709755[_0xfa23('0x4a')](_0xfa23('0xb4'),_0xfa23('0xb5'));_0x709755['field'](_0xfa23('0xb6'),'Owner.fullname');_0x709755['field'](_0xfa23('0xb7'),_0xfa23('0xb8'));_0x709755[_0xfa23('0x4a')](_0xfa23('0xb9'),'TagIds');}if(_0xe546db[_0xfa23('0x15')])_0x709755[_0xfa23('0x15')](_0xe546db['limit']);if(_0xe546db[_0xfa23('0x14')])_0x709755[_0xfa23('0x14')](_0xe546db['offset']);return db['sequelize'][_0xfa23('0x3c')](_0x709755['toString'](),_0x4a77e5);})[_0xfa23('0x1b')](function(_0x3d5a10){if(_0x3d5a10[_0xfa23('0x41')]>0x0)_0x2f6a37[_0xfa23('0x46')](_0xfa23('0xba'),_[_0xfa23('0x20')](_0x3d5a10,'id'));return db[_0xfa23('0x9b')][_0xfa23('0x3c')](_0x2f6a37[_0xfa23('0x9c')](),_0x4a77e5)[_0xfa23('0x1b')](function(_0x11fce6){var _0x4c0059=_[_0xfa23('0xbb')](_0x11fce6,_0xfa23('0xbc'));var _0x48a314=[];return db[_0xfa23('0xbd')][_0xfa23('0x27')]({'attributes':[_0xfa23('0xbe')],'raw':!![]})[_0xfa23('0x1b')](function(_0x49ab16){var _0x55c627=_0x49ab16[_0xfa23('0xbe')];_0x3d5a10[_0xfa23('0x25')](function(_0x289e3b){_0x48a314[_0xfa23('0x26')](updateMailInteraction(_0x289e3b,_0xd2345d,_0x4c0059,_0x55c627));});return BPromise['all'](_0x48a314);});});});})['then'](function(_0x393695){_0x43eb23[_0xfa23('0xbf')]=_0x393695;return _0x43eb23;})[_0xfa23('0x1b')](respondWithFilteredResult(_0x58fc41,_0xe546db))['catch'](handleError(_0x58fc41,null));};exports[_0xfa23('0xc0')]=function(_0x123824,_0x4909a5){var _0x40f83b={'raw':![],'where':{'id':_0x123824[_0xfa23('0xc1')]['id']}},_0x56b6c8={};_0x56b6c8[_0xfa23('0x3e')]=_[_0xfa23('0x3b')](db[_0xfa23('0x36')][_0xfa23('0x37')]);_0x56b6c8[_0xfa23('0x3c')]=_[_0xfa23('0x3b')](_0x123824['query']);_0x56b6c8['filters']=_[_0xfa23('0x3d')](_0x56b6c8[_0xfa23('0x3e')],_0x56b6c8[_0xfa23('0x3c')]);_0x40f83b['attributes']=_[_0xfa23('0x3d')](_0x56b6c8[_0xfa23('0x3e')],qs[_0xfa23('0x3f')](_0x123824[_0xfa23('0x3c')][_0xfa23('0x3f')]));_0x40f83b[_0xfa23('0x40')]=_0x40f83b[_0xfa23('0x40')][_0xfa23('0x41')]?_0x40f83b['attributes']:_0x56b6c8[_0xfa23('0x3e')];if(_0x123824[_0xfa23('0x3c')][_0xfa23('0xc2')]){_0x40f83b[_0xfa23('0xc3')]=[{'all':!![]}];}_0x40f83b=_[_0xfa23('0xc4')]({},_0x40f83b,_0x123824[_0xfa23('0xc5')]);return db['MailInteraction'][_0xfa23('0x62')](_0x40f83b)[_0xfa23('0x1b')](handleEntityNotFound(_0x4909a5,null))['then'](respondWithResult(_0x4909a5,null))[_0xfa23('0x2d')](handleError(_0x4909a5,null));};exports[_0xfa23('0xc6')]=function(_0x88da46,_0x2229fe){return db[_0xfa23('0x36')][_0xfa23('0xc6')](_0x88da46[_0xfa23('0xc7')],{})[_0xfa23('0x1b')](respondWithResult(_0x2229fe,0xc9))[_0xfa23('0x2d')](handleError(_0x2229fe,null));};exports[_0xfa23('0x1a')]=function(_0x3c0c1a,_0xa57d4e){if(_0x3c0c1a[_0xfa23('0xc7')]['id']){delete _0x3c0c1a[_0xfa23('0xc7')]['id'];}return db[_0xfa23('0x36')][_0xfa23('0x62')]({'where':{'id':_0x3c0c1a[_0xfa23('0xc1')]['id']}})[_0xfa23('0x1b')](handleEntityNotFound(_0xa57d4e,null))[_0xfa23('0x1b')](saveUpdates(_0x3c0c1a[_0xfa23('0xc7')],null))[_0xfa23('0x1b')](respondWithResult(_0xa57d4e,null))['catch'](handleError(_0xa57d4e,null));};exports[_0xfa23('0xc8')]=function(_0x37146b,_0x3116f6){return db[_0xfa23('0x36')][_0xfa23('0x62')]({'where':{'id':_0x37146b['params']['id']}})[_0xfa23('0x1b')](handleEntityNotFound(_0x3116f6,null))[_0xfa23('0x1b')](removeEntity(_0x3116f6,null))['catch'](handleError(_0x3116f6,null));};exports[_0xfa23('0xc9')]=function(_0x459318,_0xd1193a){return db[_0xfa23('0x36')][_0xfa23('0xc9')]()[_0xfa23('0x1b')](respondWithResult(_0xd1193a,null))['catch'](handleError(_0xd1193a,null));};exports[_0xfa23('0xca')]=function(_0x3ca789,_0x3b6730){return db[_0xfa23('0xcb')][_0xfa23('0x62')]({'where':{'id':_0x3ca789[_0xfa23('0xc1')]['id']}})[_0xfa23('0x1b')](handleEntityNotFound(_0x3b6730,null))[_0xfa23('0x1b')](function(_0x17a179){if(_0x17a179){return _0x17a179['addMessage'](_0x3ca789[_0xfa23('0xc7')][_0xfa23('0xcc')],_[_0xfa23('0xcd')](_0x3ca789['body'],[_0xfa23('0xcc'),'id'])||{});}})[_0xfa23('0x1b')](respondWithResult(_0x3b6730,null))[_0xfa23('0x2d')](handleError(_0x3b6730,null));};exports[_0xfa23('0xce')]=function(_0x34c78d,_0x4542ed){var _0x288500={'raw':![],'where':{}};var _0x2c040d={};var _0x1c4467={'count':0x0,'rows':[]};return db[_0xfa23('0x36')]['findOne']({'where':{'id':_0x34c78d[_0xfa23('0xc1')]['id']}})[_0xfa23('0x1b')](handleEntityNotFound(_0x4542ed,null))['then'](function(_0x48f2ee){if(_0x48f2ee){_0x2c040d[_0xfa23('0x3e')]=_[_0xfa23('0x3b')](db[_0xfa23('0xcb')][_0xfa23('0x37')]);_0x2c040d['query']=_[_0xfa23('0x3b')](_0x34c78d['query']);_0x2c040d[_0xfa23('0x47')]=_[_0xfa23('0x3d')](_0x2c040d[_0xfa23('0x3e')],_0x2c040d[_0xfa23('0x3c')]);_0x288500['attributes']=_[_0xfa23('0x3d')](_0x2c040d[_0xfa23('0x3e')],qs[_0xfa23('0x3f')](_0x34c78d[_0xfa23('0x3c')][_0xfa23('0x3f')]));_0x288500[_0xfa23('0x40')]=_0x288500[_0xfa23('0x40')][_0xfa23('0x41')]?_0x288500['attributes']:_0x2c040d['model'];if(!_0x34c78d[_0xfa23('0x3c')][_0xfa23('0x42')](_0xfa23('0x43'))){_0x288500[_0xfa23('0x15')]=qs[_0xfa23('0x15')](_0x34c78d[_0xfa23('0x3c')][_0xfa23('0x15')]);_0x288500[_0xfa23('0x14')]=qs[_0xfa23('0x14')](_0x34c78d[_0xfa23('0x3c')][_0xfa23('0x14')]);}_0x288500[_0xfa23('0x44')]=qs[_0xfa23('0x45')](_0x34c78d[_0xfa23('0x3c')][_0xfa23('0x45')]);_0x288500['where']=qs['filters'](_['pick'](_0x34c78d[_0xfa23('0x3c')],_0x2c040d['filters']));_0x288500[_0xfa23('0x46')][_0xfa23('0xbc')]=_0x48f2ee['id'];if(_0x34c78d[_0xfa23('0x3c')][_0xfa23('0x83')]){_0x288500['where']=_[_0xfa23('0xc4')](_0x288500['where'],{'$or':_[_0xfa23('0x20')](_0x288500['attributes'],function(_0x2fc119){var _0x274067={};_0x274067[_0x2fc119]={'$like':'%'+_0x34c78d[_0xfa23('0x3c')][_0xfa23('0x83')]+'%'};return _0x274067;})});}if(_0x34c78d[_0xfa23('0x3c')][_0xfa23('0x7b')]){var _0x3a1762=_0x34c78d[_0xfa23('0x3c')]['$gte'][_0xfa23('0x24')](',');var _0xd31f63={};_0xd31f63[_0x3a1762[0x0]]={'$gte':moment(_0x3a1762[0x1])[_0xfa23('0xcf')](_0xfa23('0xd0'))};_0x288500['where']=_[_0xfa23('0xc4')](_0x288500[_0xfa23('0x46')],_0xd31f63);}_0x288500=_[_0xfa23('0xc4')]({},_0x288500,_0x34c78d[_0xfa23('0xc5')]);return db[_0xfa23('0xcb')][_0xfa23('0x17')]({'where':_0x288500[_0xfa23('0x46')]})[_0xfa23('0x1b')](function(_0x341fb7){_0x1c4467['count']=_0x341fb7;if(_0x34c78d[_0xfa23('0x3c')][_0xfa23('0xc2')]){_0x288500[_0xfa23('0xc3')]=[{'all':!![]}];}return db['MailMessage']['findAll'](_0x288500);})[_0xfa23('0x1b')](function(_0x2d0233){if(_0x34c78d[_0xfa23('0x3c')][_0xfa23('0xd1')]===_0xfa23('0xd2')){for(var _0x3e0a20=0x0;_0x3e0a20<_0x2d0233['length'];_0x3e0a20++){_0x2d0233[_0x3e0a20][_0xfa23('0xc7')]=juice(_0x2d0233[_0x3e0a20][_0xfa23('0xc7')]);}}_0x1c4467['rows']=_0x2d0233;return _0x1c4467;});}})[_0xfa23('0x1b')](respondWithFilteredResult(_0x4542ed,_0x288500))[_0xfa23('0x2d')](handleError(_0x4542ed,null));};exports[_0xfa23('0xd3')]=function(_0x1a6be6,_0x415741){return db[_0xfa23('0x36')][_0xfa23('0x62')]({'where':{'id':_0x1a6be6['params']['id']}})[_0xfa23('0x1b')](handleEntityNotFound(_0x415741,null))[_0xfa23('0x1b')](function(_0x468604){if(_0x468604){return _0x468604['setTags'](_0x1a6be6[_0xfa23('0xc7')]['ids'],_[_0xfa23('0xcd')](_0x1a6be6[_0xfa23('0xc7')],[_0xfa23('0xcc'),'id'])||{})[_0xfa23('0xd4')](function(){return db[_0xfa23('0x6e')]['findAll']({'attributes':['id',_0xfa23('0x1e'),_0xfa23('0x4b')],'where':{'id':_0x1a6be6[_0xfa23('0xc7')][_0xfa23('0xcc')]}});})[_0xfa23('0x1b')](function(_0x1a93ba){socket[_0xfa23('0xd5')](_0xfa23('0xd6'),{'id':Number(_0x1a6be6['params']['id']),'tags':_0x1a93ba||[]});return{'id':Number(_0x1a6be6[_0xfa23('0xc1')]['id']),'tags':_0x1a93ba||[]};});}})['then'](respondWithResult(_0x415741,null))[_0xfa23('0x2d')](handleError(_0x415741,null));};exports[_0xfa23('0xd7')]=function(_0x1e8cae,_0x45e847){return db[_0xfa23('0x36')]['find']({'where':{'id':_0x1e8cae[_0xfa23('0xc1')]['id']}})['then'](handleEntityNotFound(_0x45e847,null))[_0xfa23('0x1b')](function(_0x11bc79){if(_0x11bc79){return _0x11bc79[_0xfa23('0xd7')](_0x1e8cae[_0xfa23('0x3c')][_0xfa23('0xcc')]);}})[_0xfa23('0x1b')](respondWithStatusCode(_0x45e847,null))[_0xfa23('0x2d')](handleError(_0x45e847,null));};exports[_0xfa23('0xd8')]=function(_0x26581e,_0x18effe){var _0x55dd79=moment()[_0xfa23('0xd9')]()[_0xfa23('0x9c')]();var _0x1b0f19=path[_0xfa23('0xda')](config[_0xfa23('0xdb')],'server',_0xfa23('0xdc'),_0xfa23('0xdd'));var _0x20bb3a=path[_0xfa23('0xda')](config[_0xfa23('0xdb')],'server',_0xfa23('0xdc'),_0xfa23('0xde'));var _0x3ff523=path[_0xfa23('0xda')](_0x1b0f19,_0x55dd79);var _0x381290=util['format'](_0xfa23('0xdf'),_0x26581e['params']['id'],_0x55dd79);var _0x55dc5f=path['join'](_0x1b0f19,_0x381290);var _0x37ba1a=[];if(_0x26581e['query']['attachments']){_0x37ba1a[_0xfa23('0x26')]({'model':db[_0xfa23('0xe0')],'as':_0xfa23('0xe1'),'raw':!![]});}var _0xf39a18=[{'model':db[_0xfa23('0xcb')],'as':_0xfa23('0xe2'),'attributes':['id',_0xfa23('0xc7'),_0xfa23('0x4c'),'to','cc',_0xfa23('0xe3'),_0xfa23('0xe4'),_0xfa23('0x79')],'where':{'secret':![]},'order':qs[_0xfa23('0x45')]('id'),'include':_0x37ba1a}];return db[_0xfa23('0x36')][_0xfa23('0x62')]({'where':{'id':_0x26581e[_0xfa23('0xc1')]['id']},'include':_0xf39a18})[_0xfa23('0x1b')](handleEntityNotFound(_0x18effe,null))[_0xfa23('0x1b')](function(_0x4ec3c5){if(_0x4ec3c5&&_0x4ec3c5[_0xfa23('0xe2')]){var _0x48e4e0=_0x4ec3c5[_0xfa23('0xe5')]({'plain':!![]});fs[_0xfa23('0xe6')](_0x3ff523);return BPromise['each'](_0x48e4e0[_0xfa23('0xe2')],function(_0x19111c,_0x235ea6){var _0xdb3e45={'from':_0x19111c[_0xfa23('0x4c')],'to':_0x19111c['to'],'subject':_0x19111c[_0xfa23('0xe4')],'html':htmlEntities[_0xfa23('0xe7')](_0x19111c[_0xfa23('0xc7')]),'headers':{'Date':moment(_0x19111c[_0xfa23('0x79')])[_0xfa23('0xcf')](_0xfa23('0xe8'))},'attachments':[]};if(_0x19111c['cc']){_0xdb3e45[_0xfa23('0xe9')]['Cc']=_0x19111c['cc'];}if(_0x19111c[_0xfa23('0xe3')]){_0xdb3e45['headers'][_0xfa23('0xea')]=_0x19111c[_0xfa23('0xe3')];}return new BPromise(function(_0x1ed7c5,_0x550424){if(_0x19111c[_0xfa23('0xe1')]){for(var _0x2aa3a5=0x0;_0x2aa3a5<_0x19111c[_0xfa23('0xe1')][_0xfa23('0x41')];_0x2aa3a5++){var _0x1d50ef=_0x19111c[_0xfa23('0xe1')][_0x2aa3a5];var _0x55f89c=path[_0xfa23('0xda')](_0x20bb3a,_0x1d50ef['basename']);if(fs[_0xfa23('0xeb')](_0x55f89c)){_0xdb3e45[_0xfa23('0xde')]['push']({'name':_0x1d50ef[_0xfa23('0x1e')],'contentType':_0x1d50ef[_0xfa23('0x39')],'data':fs[_0xfa23('0xec')](_0x55f89c)});}}}emlformat['build'](_0xdb3e45,function(_0x796110,_0x47cb3e){if(_0x796110)return _0x550424(_0x796110);fs[_0xfa23('0xed')](path['join'](_0x3ff523,util[_0xfa23('0xcf')](_0xfa23('0xee'),_0x235ea6)),_0x47cb3e);return _0x1ed7c5(_0x47cb3e);});});})[_0xfa23('0x1b')](function(){return new BPromise(function(_0x14892d,_0x3c9c27){zipdir(_0x3ff523,{'saveTo':_0x55dc5f},function(_0x4e9855,_0x3d6b2f){if(_0x4e9855)return _0x3c9c27(_0x4e9855);return _0x14892d(_0x3d6b2f);});})[_0xfa23('0x1b')](function(){return new BPromise(function(_0xe2aa6c,_0xdf540f){rimraf(_0x3ff523,function(_0x244672){if(_0x244672)_0xdf540f(_0x244672);return _0xe2aa6c();});});})['then'](function(){return _0x18effe['download'](_0x55dc5f,_0x381290,function(_0x188ce1){if(!_0x188ce1)fs['unlinkSync'](_0x55dc5f);});});});}else{return _0x18effe['sendStatus'](0xc8);}})[_0xfa23('0x2d')](handleError(_0x18effe,null));};
\ No newline at end of file
+var _0xf8af=['search','parseSearch','sqlOperator','conditions','length','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','text','start','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','buildExpression','type','compact','isEmpty','MailAccountId','i.MailAccountId\x20IN\x20?','concat','createdAt','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20>\x200','isArray','tag','filter','replace','isNumeric','i.id\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','SELECT','order','DESC','resolve','i.MailAccountId\x20IS\x20NOT\x20NULL','user','role','agent','getMailAccounts','i.MailAccountId\x20IS\x20NULL','toString','keyBy','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','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.updatedAt','i.closedAt','i.attach','i.subject','i.substatus','i.to','i.ContactId','i.MailAccountId','c.firstName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','c.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','sequelize','ui.MailInteractionId\x20IN\x20?','groupBy','Setting','enableEmailPreview','push','all','rows','show','params','includeAll','include','merge','options','create','body','update','describe','addMessage','ids','omit','pick','MailInteractionId','format','findAll','true','addTags','setTags','Tag','color','emit','removeTags','download','unix','join','root','server','files','tmp','attachments','Attachment','Attachments','Messages','bcc','subject','mkdirSync','each','decode','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','Bcc','writeFileSync','message%d.eml','unlinkSync','eml-format','zip-dir','moment','bluebird','util','lodash','squel','juice','ioredis','../../config/logger','../../config/environment','../../mysqldb','html-entities','redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','register','sendStatus','end','status','offset','count','set','json','then','destroy','error','name','send','Users','map','fullname','TagIds','Tags','split','forEach','MailMessage','findOne','plainBody','-id','lastMsgText','catch','waiting','talking','answered','unmanaged','total','closed','UserId','MailInteraction','rawAttributes','fieldName','key','query','keys','filters','intersection','attributes','model','fields','hasOwnProperty','nolimit','limit','sort','where','field','from','tools_tags','select','u.id','u.fullname','ui.MailInteractionId','left_join','users','mail_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','a.id\x20=\x20i.MailAccountId','mail_messages','me.MailInteractionId\x20=\x20i.id','it.MailInteractionId\x20=\x20i.id','expr'];(function(_0x23d0fc,_0x20b841){var _0x41f208=function(_0x2d3aa2){while(--_0x2d3aa2){_0x23d0fc['push'](_0x23d0fc['shift']());}};_0x41f208(++_0x20b841);}(_0xf8af,0x8b));var _0xff8a=function(_0x59ee6f,_0x450239){_0x59ee6f=_0x59ee6f-0x0;var _0x4c0979=_0xf8af[_0x59ee6f];return _0x4c0979;};'use strict';var emlformat=require(_0xff8a('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xff8a('0x1'));var moment=require(_0xff8a('0x2'));var BPromise=require(_0xff8a('0x3'));var util=require(_0xff8a('0x4'));var path=require('path');var fs=require('fs');var _=require(_0xff8a('0x5'));var squel=require(_0xff8a('0x6'));var juice=require(_0xff8a('0x7'));var Redis=require(_0xff8a('0x8'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var logger=require(_0xff8a('0x9'))('api');var config=require(_0xff8a('0xa'));var db=require(_0xff8a('0xb'))['db'];var htmlEntities=require(_0xff8a('0xc'));config[_0xff8a('0xd')]=_[_0xff8a('0xe')](config[_0xff8a('0xd')],{'host':_0xff8a('0xf'),'port':0x18eb});var socket=require(_0xff8a('0x10'))(new Redis(config[_0xff8a('0xd')]));require(_0xff8a('0x11'))[_0xff8a('0x12')](socket);function respondWithStatusCode(_0x5a31cb,_0x3d7e93){_0x3d7e93=_0x3d7e93||0xcc;return function(_0x437fc8){if(_0x437fc8){return _0x5a31cb[_0xff8a('0x13')](_0x3d7e93);}return _0x5a31cb['status'](_0x3d7e93)[_0xff8a('0x14')]();};}function respondWithResult(_0x35eca7,_0x252271){_0x252271=_0x252271||0xc8;return function(_0x40bf06){if(_0x40bf06){return _0x35eca7[_0xff8a('0x15')](_0x252271)['json'](_0x40bf06);}};}function respondWithFilteredResult(_0x2e72a7,_0x4236c5){return function(_0xf81533){if(_0xf81533){var _0x1cd47d=typeof _0x4236c5['offset']==='undefined'&&typeof _0x4236c5['limit']==='undefined';var _0x2f83df=_0xf81533['count'];var _0x279441=_0x1cd47d?0x0:_0x4236c5[_0xff8a('0x16')];var _0x4e98b0=_0x1cd47d?_0xf81533[_0xff8a('0x17')]:_0x4236c5['offset']+_0x4236c5['limit'];var _0x392f43;if(_0x4e98b0>=_0x2f83df){_0x4e98b0=_0x2f83df;_0x392f43=0xc8;}else{_0x392f43=0xce;}_0x2e72a7[_0xff8a('0x15')](_0x392f43);return _0x2e72a7[_0xff8a('0x18')]('Content-Range',_0x279441+'-'+_0x4e98b0+'/'+_0x2f83df)[_0xff8a('0x19')](_0xf81533);}return null;};}function saveUpdates(_0x5c4349){return function(_0x1d3767){if(_0x1d3767){return _0x1d3767['update'](_0x5c4349)[_0xff8a('0x1a')](function(_0x1b4272){return _0x1b4272;});}return null;};}function removeEntity(_0x794015){return function(_0xdb1027){if(_0xdb1027){return _0xdb1027[_0xff8a('0x1b')]()[_0xff8a('0x1a')](function(){_0x794015[_0xff8a('0x15')](0xcc)[_0xff8a('0x14')]();});}};}function handleEntityNotFound(_0xead978){return function(_0xe2ed2b){if(!_0xe2ed2b){_0xead978[_0xff8a('0x13')](0x194);}return _0xe2ed2b;};}function handleError(_0x2d0fc2,_0x3bb4ac){_0x3bb4ac=_0x3bb4ac||0x1f4;return function(_0x1d9a9b){logger[_0xff8a('0x1c')](_0x1d9a9b['stack']);if(_0x1d9a9b[_0xff8a('0x1d')]){delete _0x1d9a9b[_0xff8a('0x1d')];}_0x2d0fc2[_0xff8a('0x15')](_0x3bb4ac)[_0xff8a('0x1e')](_0x1d9a9b);};}function getInteractionUsers(_0x518d33,_0x2370f1){return new BPromise(function(_0x49b441,_0x1c9ecc){try{if(_0x2370f1[_0x518d33['id']]){_0x518d33[_0xff8a('0x1f')]=_[_0xff8a('0x20')](_0x2370f1[_0x518d33['id']],function(_0x3fdce3){return{'id':_0x3fdce3['id'],'fullname':_0x3fdce3[_0xff8a('0x21')]};});}}catch(_0x55b267){_0x1c9ecc(_0x55b267);}_0x49b441(_0x518d33);});}function getInteractionTags(_0x2c57c9,_0x178f73){return new BPromise(function(_0x3063b1,_0x5153f6){try{if(_0x2c57c9[_0xff8a('0x22')]){_0x2c57c9[_0xff8a('0x23')]=[];_0x2c57c9[_0xff8a('0x22')][_0xff8a('0x24')](',')[_0xff8a('0x25')](function(_0xba33b6){_0x2c57c9[_0xff8a('0x23')]['push'](_0x178f73[_0xba33b6]);});}delete _0x2c57c9['TagIds'];}catch(_0x1fc2a8){_0x5153f6(_0x1fc2a8);}_0x3063b1(_0x2c57c9);});}function getLastMessageText(_0x3849df){return new BPromise(function(_0x15d5c2,_0x279347){return db[_0xff8a('0x26')][_0xff8a('0x27')]({'where':{'$and':[{'MailInteractionId':_0x3849df['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':'out'},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0xff8a('0x28')],'order':_0xff8a('0x29'),'raw':!![]})['then'](function(_0x422410){if(_0x422410&&_0x422410[_0xff8a('0x28')]){_0x3849df[_0xff8a('0x2a')]=_['trimStart'](_0x422410[_0xff8a('0x28')]);}_0x15d5c2(_0x3849df);})[_0xff8a('0x2b')](function(_0x5a1c84){_0x279347(_0x5a1c84);});});}function updateMailInteraction(_0x231d1c,_0x37d035,_0x3ad597,_0x3355db){return new BPromise(function(_0x203546,_0x3b90be){return getInteractionUsers(_0x231d1c,_0x3ad597)[_0xff8a('0x1a')](function(_0x3b894e){return getInteractionTags(_0x3b894e,_0x37d035);})[_0xff8a('0x1a')](function(_0x4dff27){return getStateInteraction(_0x4dff27);})[_0xff8a('0x1a')](function(_0x1330ea){if(_0x3355db){_0x203546(getLastMessageText(_0x1330ea));}else{_0x203546(_0x1330ea);}})['catch'](function(_0x2e3829){_0x3b90be(_0x2e3829);});});}function getStateInteraction(_0x3a82c2){return new BPromise(function(_0xfc4000){_0x3a82c2[_0xff8a('0x2c')]=0x0;_0x3a82c2[_0xff8a('0x2d')]=0x0;_0x3a82c2[_0xff8a('0x2e')]=0x0;_0x3a82c2[_0xff8a('0x2f')]=0x0;_0x3a82c2[_0xff8a('0x30')]=0x0;if(!_0x3a82c2[_0xff8a('0x31')]&&!_0x3a82c2['UserId']){_0x3a82c2['waiting']+=0x1;}if(!_0x3a82c2[_0xff8a('0x31')]&&_0x3a82c2[_0xff8a('0x32')]){_0x3a82c2['talking']+=0x1;if(_0x3a82c2[_0xff8a('0x2c')]){_0x3a82c2[_0xff8a('0x2c')]-=0x1;}}if(_0x3a82c2['closed']&&_0x3a82c2['UserId']){_0x3a82c2['answered']+=0x1;if(_0x3a82c2[_0xff8a('0x2d')]){_0x3a82c2[_0xff8a('0x2d')]-=0x1;}}if(_0x3a82c2['closed']&&!_0x3a82c2[_0xff8a('0x32')]){_0x3a82c2[_0xff8a('0x2f')]+=0x1;if(_0x3a82c2[_0xff8a('0x2c')]){_0x3a82c2['waiting']-=0x1;}}_0x3a82c2[_0xff8a('0x30')]+=0x1;_0xfc4000(_0x3a82c2);});}exports['index']=function(_0x2e7ac7,_0x128936){var _0x5ed49e={},_0x3769b3={},_0x5c1bea={'count':0x0,'rows':[]};var _0x4c263e=_[_0xff8a('0x20')](db[_0xff8a('0x33')][_0xff8a('0x34')],function(_0x4291c3){return{'name':_0x4291c3[_0xff8a('0x35')],'type':_0x4291c3['type'][_0xff8a('0x36')]};});_0x3769b3['model']=_[_0xff8a('0x20')](_0x4c263e,_0xff8a('0x1d'));_0x3769b3[_0xff8a('0x37')]=_[_0xff8a('0x38')](_0x2e7ac7[_0xff8a('0x37')]);_0x3769b3[_0xff8a('0x39')]=_[_0xff8a('0x3a')](_0x3769b3['model'],_0x3769b3[_0xff8a('0x37')]);_0x5ed49e[_0xff8a('0x3b')]=_[_0xff8a('0x3a')](_0x3769b3[_0xff8a('0x3c')],qs[_0xff8a('0x3d')](_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x3d')]));_0x5ed49e[_0xff8a('0x3b')]=_0x5ed49e[_0xff8a('0x3b')]['length']?_0x5ed49e[_0xff8a('0x3b')]:_0x3769b3['model'];if(!_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x3e')](_0xff8a('0x3f'))){_0x5ed49e[_0xff8a('0x40')]=qs[_0xff8a('0x40')](_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x40')]);_0x5ed49e[_0xff8a('0x16')]=qs[_0xff8a('0x16')](_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x16')]);}_0x5ed49e['order']=qs[_0xff8a('0x41')](_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x41')]);_0x5ed49e[_0xff8a('0x42')]=qs[_0xff8a('0x39')](_['pick'](_0x2e7ac7[_0xff8a('0x37')],_0x3769b3[_0xff8a('0x39')]),_0x4c263e);var _0x21ef6d=[];var _0x579664=squel['select']()[_0xff8a('0x43')]('id')[_0xff8a('0x43')](_0xff8a('0x1d'))[_0xff8a('0x43')]('color')[_0xff8a('0x44')](_0xff8a('0x45'));var _0x342873=squel[_0xff8a('0x46')]()[_0xff8a('0x43')](_0xff8a('0x47'))[_0xff8a('0x43')](_0xff8a('0x48'))[_0xff8a('0x43')](_0xff8a('0x49'))[_0xff8a('0x44')]('user_has_mail_interactions','ui')[_0xff8a('0x4a')](_0xff8a('0x4b'),'u','u.id\x20=\x20ui.UserId');var _0x1a7973=squel[_0xff8a('0x46')]()['from'](_0xff8a('0x4c'),'i')[_0xff8a('0x4a')](_0xff8a('0x4d'),'c',_0xff8a('0x4e'))[_0xff8a('0x4a')](_0xff8a('0x4b'),'o',_0xff8a('0x4f'))[_0xff8a('0x4a')](_0xff8a('0x50'),'a',_0xff8a('0x51'))[_0xff8a('0x4a')](_0xff8a('0x52'),'me',_0xff8a('0x53'))[_0xff8a('0x4a')]('mail_interaction_has_tags','it',_0xff8a('0x54'))[_0xff8a('0x4a')](_0xff8a('0x45'),'t','t.id\x20=\x20it.TagId');var _0x3b52d0=squel[_0xff8a('0x55')]();var _0x2c274b=[];var _0xb2eea9=squel[_0xff8a('0x55')]();var _0x8cd263;if(_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x56')]){_0x8cd263=as[_0xff8a('0x57')](_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x56')]);var _0x54240e=_0x8cd263[_0xff8a('0x58')];for(var _0xfec238=0x0;_0xfec238<_0x8cd263[_0xff8a('0x59')][_0xff8a('0x5a')];_0xfec238++){var _0x139be3=_0x8cd263[_0xff8a('0x59')][_0xfec238];var _0x1534f1='i';var _0x5b77f8=_[_0xff8a('0x5b')](_0x4c263e,[_0xff8a('0x1d'),_0x139be3['field']]);if(!_0x5b77f8){switch(_0x139be3[_0xff8a('0x43')]){case _0xff8a('0x5c'):if(_0x139be3[_0xff8a('0x5d')]==0x1){_0x1a7973[_0xff8a('0x5e')]('`'+_0x139be3[_0xff8a('0x43')]+_0xff8a('0x5f'));}else{_0x1a7973[_0xff8a('0x5e')]('`'+_0x139be3['field']+_0xff8a('0x60'));}break;case'Contact':if(_0x139be3[_0xff8a('0x61')]===_0xff8a('0x62')){if(_0x139be3[_0xff8a('0x5d')]['split']('\x20')[_0xff8a('0x5a')]>0x1){_0x3b52d0[_0x54240e](_0xff8a('0x63'),qs[_0xff8a('0x64')](_0x139be3[_0xff8a('0x5d')]),null);}else{var _0x2e9675='%'+_0x139be3[_0xff8a('0x5d')]+'%';_0x3b52d0[_0x54240e](_0xff8a('0x65'),_0x2e9675,_0x2e9675,_0x2e9675);}}else{_0x5b77f8=_['find'](_0x4c263e,[_0xff8a('0x1d'),'ContactId']);_0x139be3[_0xff8a('0x43')]=_0xff8a('0x66');_0x143b12=as['buildExpression'](_0x1534f1,_0x5b77f8['type'],_0x139be3);_0x3b52d0[_0x54240e](_0x143b12[_0xff8a('0x67')],_0x143b12[_0xff8a('0x5d')][_0xff8a('0x68')],_0x143b12['value'][_0xff8a('0x14')]);}break;case'Tag':var _0x3fcd5d=_0x139be3[_0xff8a('0x5d')][_0xff8a('0x24')](',')['map'](function(_0x57410a){return Number(_0x57410a);});_0x3fcd5d[_0xff8a('0x25')](function(_0x1aca5e){_0xb2eea9['or'](_0xff8a('0x69'),'%,'+_0x1aca5e+',%');});_0x2c274b=_[_0xff8a('0x6a')](_0x2c274b,_0x3fcd5d);break;case'User':if(_0x139be3[_0xff8a('0x61')]===_0xff8a('0x62')){_0x3b52d0[_0x54240e]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x139be3[_0xff8a('0x5d')]+'%',null);}else{_0x5b77f8=_['find'](_0x4c263e,[_0xff8a('0x1d'),_0xff8a('0x32')]);_0x139be3[_0xff8a('0x43')]=_0xff8a('0x32');_0x143b12=as[_0xff8a('0x6b')](_0x1534f1,_0x5b77f8['type'],_0x139be3);_0x3b52d0[_0x54240e](_0x143b12[_0xff8a('0x67')],_0x143b12[_0xff8a('0x5d')]['start'],_0x143b12['value'][_0xff8a('0x14')]);}break;case _0xff8a('0x28'):_0x143b12=as['buildExpression']('me',null,_0x139be3);_0x3b52d0[_0x54240e](_0x143b12['text'],_0x143b12[_0xff8a('0x5d')]['start'],_0x143b12[_0xff8a('0x5d')][_0xff8a('0x14')]);break;}}else{var _0x143b12=as[_0xff8a('0x6b')](_0x1534f1,_0x5b77f8[_0xff8a('0x6c')],_0x139be3);_0x3b52d0[_0x54240e](_0x143b12[_0xff8a('0x67')],_0x143b12[_0xff8a('0x5d')][_0xff8a('0x68')],_0x143b12[_0xff8a('0x5d')][_0xff8a('0x14')]);}}}else{var _0x182026=_(_0x2e7ac7['query'])[_0xff8a('0x38')]()[_0xff8a('0x20')](function(_0x3df16f){return _['some'](_0x4c263e,[_0xff8a('0x1d'),_0x3df16f])?_0x3df16f:undefined;})[_0xff8a('0x6d')]()['value']();if(!_[_0xff8a('0x6e')](_0x182026)){_0x182026['forEach'](function(_0x19d9a0){if(_0x19d9a0===_0xff8a('0x6f')){_0x1a7973[_0xff8a('0x42')](_0xff8a('0x70'),[][_0xff8a('0x71')](_0x2e7ac7[_0xff8a('0x37')][_0x19d9a0]));}else if(_0x19d9a0===_0xff8a('0x72')){var _0x397197=JSON[_0xff8a('0x73')](_0x2e7ac7['query'][_0x19d9a0])[_0xff8a('0x74')];var _0x22caf3=JSON[_0xff8a('0x73')](_0x2e7ac7[_0xff8a('0x37')][_0x19d9a0])['$lte'];_0x1a7973[_0xff8a('0x42')](_0xff8a('0x75'),_0x397197,_0x22caf3);}else{if(_0x2e7ac7[_0xff8a('0x37')][_0x19d9a0]===_0xff8a('0x76')){_0x1a7973[_0xff8a('0x42')]('i.'+_0x19d9a0+_0xff8a('0x77'));}else{_0x1a7973[_0xff8a('0x42')]('i.'+_0x19d9a0+_0xff8a('0x78'),_0x2e7ac7[_0xff8a('0x37')][_0x19d9a0]);}}});}if(_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x79')]){if(_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x79')]==0x1){_0x1a7973[_0xff8a('0x5e')]('`unreadMessages`\x20=\x200');}else{_0x1a7973['having'](_0xff8a('0x7a'));}}if(_0x2e7ac7[_0xff8a('0x37')]['tag']){_0x2c274b=_[_0xff8a('0x7b')](_0x2e7ac7[_0xff8a('0x37')]['tag'])?_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x7c')]:new Array(_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x7c')]);_0x2c274b[_0xff8a('0x25')](function(_0xa7f21c){_0xb2eea9['or'](_0xff8a('0x69'),'%,'+_0xa7f21c+',%');});}if(_0x2e7ac7['query'][_0xff8a('0x7d')]){var _0x43cc0e=_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x7d')][_0xff8a('0x7e')]('\x5c','\x5c\x5c')[_0xff8a('0x7e')](/'/g,'\x27\x27');if(qs[_0xff8a('0x7f')](_0x43cc0e)){_0x3b52d0['or'](_0xff8a('0x80'),_0x43cc0e+'%');}else if(qs['isEmail'](_0x43cc0e)){_0x3b52d0['or']('c.email\x20LIKE\x20?',_0x43cc0e+'%');}else{_0x3b52d0['or'](_0xff8a('0x81'),qs[_0xff8a('0x64')](_0x43cc0e))['or'](_0xff8a('0x82'),qs[_0xff8a('0x64')](_0x43cc0e));}}}_0x1a7973['where'](_0x3b52d0);_0x1a7973[_0xff8a('0x83')](_0xff8a('0x84'));var _0x5667dc={'type':db['Sequelize']['QueryTypes'][_0xff8a('0x85')],'raw':!![]};var _0x4b8abb=_0x1a7973['clone']();_0x4b8abb[_0xff8a('0x43')](_0xff8a('0x84'));_0x4b8abb['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0xff8a('0x5c'));if(_0x5ed49e[_0xff8a('0x86')]){_0x5ed49e[_0xff8a('0x86')][_0xff8a('0x25')](function(_0x55caa2){var _0x44d4c7=_0x55caa2[0x0]==='contactName'?_0x55caa2[0x0]:'i.'+_0x55caa2[0x0];_0x1a7973[_0xff8a('0x86')](_0x44d4c7,_0x55caa2[0x1]===_0xff8a('0x87')?![]:!![]);});}if(!_[_0xff8a('0x6e')](_0x2c274b)){_0x1a7973[_0xff8a('0x5e')](_0xb2eea9);_0x4b8abb[_0xff8a('0x42')]('t.id\x20IN\x20?',_0x2c274b);}BPromise[_0xff8a('0x88')]()['then'](function(){if(!_0x8cd263){if(_0x2e7ac7['query'][_0xff8a('0x6f')])return;_0x4b8abb[_0xff8a('0x42')](_0xff8a('0x89'));_0x1a7973[_0xff8a('0x42')](_0xff8a('0x89'));return;}if(_0x2e7ac7[_0xff8a('0x8a')][_0xff8a('0x8b')]!==_0xff8a('0x8c'))return;return _0x2e7ac7[_0xff8a('0x8a')][_0xff8a('0x8d')]({'attributes':['id'],'raw':!![]})['then'](function(_0x4bbb86){if(_[_0xff8a('0x6e')](_0x4bbb86)){_0x4b8abb[_0xff8a('0x42')](_0xff8a('0x8e'));_0x1a7973[_0xff8a('0x42')](_0xff8a('0x8e'));}else{_0x4b8abb[_0xff8a('0x42')](_0xff8a('0x70'),_[_0xff8a('0x20')](_0x4bbb86,'id'));_0x1a7973[_0xff8a('0x42')]('i.MailAccountId\x20IN\x20?',_[_0xff8a('0x20')](_0x4bbb86,'id'));}});})[_0xff8a('0x1a')](function(){if(_0x2e7ac7[_0xff8a('0x8a')][_0xff8a('0x8b')]==='agent'&&!_0x8cd263&&!_0x2e7ac7['query'][_0xff8a('0x6f')])return[];return db['sequelize'][_0xff8a('0x37')](_0x4b8abb[_0xff8a('0x8f')](),_0x5667dc);})[_0xff8a('0x1a')](function(_0x2510dc){_0x5c1bea['count']=_0x2510dc[_0xff8a('0x5a')];if(_0x5c1bea[_0xff8a('0x17')]===0x0)return[];return db['sequelize']['query'](_0x579664[_0xff8a('0x8f')](),_0x5667dc)[_0xff8a('0x1a')](function(_0x23994e){_0x21ef6d=_[_0xff8a('0x90')](_0x23994e,'id');_0x5667dc=_['merge'](_0x5667dc,{'model':db[_0xff8a('0x33')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x2e7ac7[_0xff8a('0x37')][_0xff8a('0x3d')]){_0x5ed49e[_0xff8a('0x3b')][_0xff8a('0x25')](function(_0x5a3919){_0x1a7973[_0xff8a('0x43')]('i.'+_0x5a3919);});}else{_0x1a7973[_0xff8a('0x43')](_0xff8a('0x91'),'unreadMessages');_0x1a7973[_0xff8a('0x43')](_0xff8a('0x92'),'Account.key');_0x1a7973[_0xff8a('0x43')]('a.mandatoryDisposition',_0xff8a('0x93'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0x94'),_0xff8a('0x95'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0x84'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0x96'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0x97'));_0x1a7973[_0xff8a('0x43')]('i.closed');_0x1a7973['field'](_0xff8a('0x98'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0x99'));_0x1a7973[_0xff8a('0x43')]('i.lastMsgAt');_0x1a7973[_0xff8a('0x43')]('i.lastMsgDirection');_0x1a7973[_0xff8a('0x43')](_0xff8a('0x9a'));_0x1a7973[_0xff8a('0x43')]('i.disposition');_0x1a7973[_0xff8a('0x43')]('i.secondDisposition');_0x1a7973[_0xff8a('0x43')]('i.thirdDisposition');_0x1a7973[_0xff8a('0x43')](_0xff8a('0x9b'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0x9c'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0x9d'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0x9e'));_0x1a7973[_0xff8a('0x43')]('i.UserId');_0x1a7973[_0xff8a('0x43')](_0xff8a('0x9f'),'Contact.firstName');_0x1a7973[_0xff8a('0x43')]('c.lastName',_0xff8a('0xa0'));_0x1a7973['field'](_0xff8a('0xa1'),_0xff8a('0xa2'));_0x1a7973['field'](_0xff8a('0xa3'),_0xff8a('0xa4'));_0x1a7973[_0xff8a('0x43')](_0xff8a('0xa5'),'Contact.mobile');_0x1a7973[_0xff8a('0x43')](_0xff8a('0xa6'),'Contact.fax');_0x1a7973[_0xff8a('0x43')](_0xff8a('0xa7'),'Owner.fullname');_0x1a7973[_0xff8a('0x43')](_0xff8a('0xa8'),_0xff8a('0xa9'));_0x1a7973['field'](_0xff8a('0xaa'),'TagIds');}if(_0x5ed49e['limit'])_0x1a7973[_0xff8a('0x40')](_0x5ed49e[_0xff8a('0x40')]);if(_0x5ed49e['offset'])_0x1a7973['offset'](_0x5ed49e['offset']);return db[_0xff8a('0xab')][_0xff8a('0x37')](_0x1a7973[_0xff8a('0x8f')](),_0x5667dc);})[_0xff8a('0x1a')](function(_0xc1d78){if(_0xc1d78[_0xff8a('0x5a')]>0x0)_0x342873[_0xff8a('0x42')](_0xff8a('0xac'),_['map'](_0xc1d78,'id'));return db[_0xff8a('0xab')][_0xff8a('0x37')](_0x342873[_0xff8a('0x8f')](),_0x5667dc)[_0xff8a('0x1a')](function(_0x5ae102){var _0x55a003=_[_0xff8a('0xad')](_0x5ae102,'MailInteractionId');var _0x14f280=[];return db[_0xff8a('0xae')][_0xff8a('0x27')]({'attributes':['enableEmailPreview'],'raw':!![]})[_0xff8a('0x1a')](function(_0x27e158){var _0x4cbb77=_0x27e158[_0xff8a('0xaf')];_0xc1d78[_0xff8a('0x25')](function(_0x3aede0){_0x14f280[_0xff8a('0xb0')](updateMailInteraction(_0x3aede0,_0x21ef6d,_0x55a003,_0x4cbb77));});return BPromise[_0xff8a('0xb1')](_0x14f280);});});});})[_0xff8a('0x1a')](function(_0x508189){_0x5c1bea[_0xff8a('0xb2')]=_0x508189;return _0x5c1bea;})[_0xff8a('0x1a')](respondWithFilteredResult(_0x128936,_0x5ed49e))['catch'](handleError(_0x128936,null));};exports[_0xff8a('0xb3')]=function(_0x1e9ffa,_0xd4ec24){var _0x545cb1={'raw':![],'where':{'id':_0x1e9ffa[_0xff8a('0xb4')]['id']}},_0x34efdb={};_0x34efdb[_0xff8a('0x3c')]=_[_0xff8a('0x38')](db[_0xff8a('0x33')]['rawAttributes']);_0x34efdb['query']=_[_0xff8a('0x38')](_0x1e9ffa[_0xff8a('0x37')]);_0x34efdb['filters']=_[_0xff8a('0x3a')](_0x34efdb[_0xff8a('0x3c')],_0x34efdb[_0xff8a('0x37')]);_0x545cb1[_0xff8a('0x3b')]=_[_0xff8a('0x3a')](_0x34efdb['model'],qs['fields'](_0x1e9ffa[_0xff8a('0x37')][_0xff8a('0x3d')]));_0x545cb1[_0xff8a('0x3b')]=_0x545cb1[_0xff8a('0x3b')][_0xff8a('0x5a')]?_0x545cb1['attributes']:_0x34efdb[_0xff8a('0x3c')];if(_0x1e9ffa[_0xff8a('0x37')][_0xff8a('0xb5')]){_0x545cb1[_0xff8a('0xb6')]=[{'all':!![]}];}_0x545cb1=_[_0xff8a('0xb7')]({},_0x545cb1,_0x1e9ffa[_0xff8a('0xb8')]);return db[_0xff8a('0x33')][_0xff8a('0x5b')](_0x545cb1)[_0xff8a('0x1a')](handleEntityNotFound(_0xd4ec24,null))[_0xff8a('0x1a')](respondWithResult(_0xd4ec24,null))[_0xff8a('0x2b')](handleError(_0xd4ec24,null));};exports[_0xff8a('0xb9')]=function(_0x483094,_0x3ed9fd){return db[_0xff8a('0x33')][_0xff8a('0xb9')](_0x483094[_0xff8a('0xba')],{})[_0xff8a('0x1a')](respondWithResult(_0x3ed9fd,0xc9))[_0xff8a('0x2b')](handleError(_0x3ed9fd,null));};exports[_0xff8a('0xbb')]=function(_0x345cfe,_0x40ef95){if(_0x345cfe['body']['id']){delete _0x345cfe[_0xff8a('0xba')]['id'];}return db['MailInteraction'][_0xff8a('0x5b')]({'where':{'id':_0x345cfe[_0xff8a('0xb4')]['id']}})[_0xff8a('0x1a')](handleEntityNotFound(_0x40ef95,null))[_0xff8a('0x1a')](saveUpdates(_0x345cfe['body'],null))['then'](respondWithResult(_0x40ef95,null))[_0xff8a('0x2b')](handleError(_0x40ef95,null));};exports['destroy']=function(_0x2b7830,_0x21973a){return db[_0xff8a('0x33')]['find']({'where':{'id':_0x2b7830[_0xff8a('0xb4')]['id']}})[_0xff8a('0x1a')](handleEntityNotFound(_0x21973a,null))[_0xff8a('0x1a')](removeEntity(_0x21973a,null))[_0xff8a('0x2b')](handleError(_0x21973a,null));};exports[_0xff8a('0xbc')]=function(_0x4b2a18,_0x50c558){return db[_0xff8a('0x33')][_0xff8a('0xbc')]()[_0xff8a('0x1a')](respondWithResult(_0x50c558,null))['catch'](handleError(_0x50c558,null));};exports[_0xff8a('0xbd')]=function(_0x2ffe0b,_0x37c831){return db[_0xff8a('0x26')][_0xff8a('0x5b')]({'where':{'id':_0x2ffe0b[_0xff8a('0xb4')]['id']}})[_0xff8a('0x1a')](handleEntityNotFound(_0x37c831,null))['then'](function(_0x12d71c){if(_0x12d71c){return _0x12d71c['addMessage'](_0x2ffe0b[_0xff8a('0xba')][_0xff8a('0xbe')],_[_0xff8a('0xbf')](_0x2ffe0b[_0xff8a('0xba')],['ids','id'])||{});}})[_0xff8a('0x1a')](respondWithResult(_0x37c831,null))[_0xff8a('0x2b')](handleError(_0x37c831,null));};exports['getMessages']=function(_0x5ed7c0,_0x524069){var _0x380830={'raw':![],'where':{}};var _0x3220f9={};var _0x387d7d={'count':0x0,'rows':[]};return db[_0xff8a('0x33')][_0xff8a('0x27')]({'where':{'id':_0x5ed7c0[_0xff8a('0xb4')]['id']}})['then'](handleEntityNotFound(_0x524069,null))['then'](function(_0x2b48f0){if(_0x2b48f0){_0x3220f9[_0xff8a('0x3c')]=_[_0xff8a('0x38')](db[_0xff8a('0x26')][_0xff8a('0x34')]);_0x3220f9['query']=_[_0xff8a('0x38')](_0x5ed7c0[_0xff8a('0x37')]);_0x3220f9['filters']=_[_0xff8a('0x3a')](_0x3220f9[_0xff8a('0x3c')],_0x3220f9[_0xff8a('0x37')]);_0x380830['attributes']=_[_0xff8a('0x3a')](_0x3220f9['model'],qs[_0xff8a('0x3d')](_0x5ed7c0[_0xff8a('0x37')][_0xff8a('0x3d')]));_0x380830[_0xff8a('0x3b')]=_0x380830[_0xff8a('0x3b')][_0xff8a('0x5a')]?_0x380830[_0xff8a('0x3b')]:_0x3220f9['model'];if(!_0x5ed7c0[_0xff8a('0x37')][_0xff8a('0x3e')](_0xff8a('0x3f'))){_0x380830['limit']=qs['limit'](_0x5ed7c0['query']['limit']);_0x380830[_0xff8a('0x16')]=qs[_0xff8a('0x16')](_0x5ed7c0[_0xff8a('0x37')][_0xff8a('0x16')]);}_0x380830[_0xff8a('0x86')]=qs[_0xff8a('0x41')](_0x5ed7c0['query']['sort']);_0x380830[_0xff8a('0x42')]=qs[_0xff8a('0x39')](_[_0xff8a('0xc0')](_0x5ed7c0[_0xff8a('0x37')],_0x3220f9[_0xff8a('0x39')]));_0x380830[_0xff8a('0x42')][_0xff8a('0xc1')]=_0x2b48f0['id'];if(_0x5ed7c0[_0xff8a('0x37')]['filter']){_0x380830[_0xff8a('0x42')]=_['merge'](_0x380830[_0xff8a('0x42')],{'$or':_[_0xff8a('0x20')](_0x380830[_0xff8a('0x3b')],function(_0x218271){var _0x5729cd={};_0x5729cd[_0x218271]={'$like':'%'+_0x5ed7c0[_0xff8a('0x37')][_0xff8a('0x7d')]+'%'};return _0x5729cd;})});}if(_0x5ed7c0[_0xff8a('0x37')][_0xff8a('0x74')]){var _0x427c55=_0x5ed7c0['query'][_0xff8a('0x74')][_0xff8a('0x24')](',');var _0x178bbe={};_0x178bbe[_0x427c55[0x0]]={'$gte':moment(_0x427c55[0x1])[_0xff8a('0xc2')]('YYYY-MM-DD\x20HH:mm:ss')};_0x380830[_0xff8a('0x42')]=_[_0xff8a('0xb7')](_0x380830['where'],_0x178bbe);}_0x380830=_[_0xff8a('0xb7')]({},_0x380830,_0x5ed7c0['options']);return db[_0xff8a('0x26')][_0xff8a('0x17')]({'where':_0x380830[_0xff8a('0x42')]})['then'](function(_0x1c4606){_0x387d7d['count']=_0x1c4606;if(_0x5ed7c0[_0xff8a('0x37')][_0xff8a('0xb5')]){_0x380830[_0xff8a('0xb6')]=[{'all':!![]}];}return db[_0xff8a('0x26')][_0xff8a('0xc3')](_0x380830);})[_0xff8a('0x1a')](function(_0x5c190a){if(_0x5ed7c0[_0xff8a('0x37')]['inlineCss']===_0xff8a('0xc4')){for(var _0x479ef3=0x0;_0x479ef3<_0x5c190a[_0xff8a('0x5a')];_0x479ef3++){_0x5c190a[_0x479ef3]['body']=juice(_0x5c190a[_0x479ef3][_0xff8a('0xba')]);}}_0x387d7d['rows']=_0x5c190a;return _0x387d7d;});}})[_0xff8a('0x1a')](respondWithFilteredResult(_0x524069,_0x380830))['catch'](handleError(_0x524069,null));};exports[_0xff8a('0xc5')]=function(_0x3db9e9,_0x5ccc46){return db[_0xff8a('0x33')]['find']({'where':{'id':_0x3db9e9[_0xff8a('0xb4')]['id']}})['then'](handleEntityNotFound(_0x5ccc46,null))[_0xff8a('0x1a')](function(_0x3934a5){if(_0x3934a5){return _0x3934a5[_0xff8a('0xc6')](_0x3db9e9[_0xff8a('0xba')][_0xff8a('0xbe')],_[_0xff8a('0xbf')](_0x3db9e9['body'],[_0xff8a('0xbe'),'id'])||{})['spread'](function(){return db[_0xff8a('0xc7')][_0xff8a('0xc3')]({'attributes':['id',_0xff8a('0x1d'),_0xff8a('0xc8')],'where':{'id':_0x3db9e9[_0xff8a('0xba')][_0xff8a('0xbe')]}});})[_0xff8a('0x1a')](function(_0x250b60){socket[_0xff8a('0xc9')]('mailInteractionTags:save',{'id':Number(_0x3db9e9[_0xff8a('0xb4')]['id']),'tags':_0x250b60||[]});return{'id':Number(_0x3db9e9[_0xff8a('0xb4')]['id']),'tags':_0x250b60||[]};});}})[_0xff8a('0x1a')](respondWithResult(_0x5ccc46,null))[_0xff8a('0x2b')](handleError(_0x5ccc46,null));};exports[_0xff8a('0xca')]=function(_0x1326a9,_0x7fcde8){return db['MailInteraction']['find']({'where':{'id':_0x1326a9[_0xff8a('0xb4')]['id']}})[_0xff8a('0x1a')](handleEntityNotFound(_0x7fcde8,null))[_0xff8a('0x1a')](function(_0x178eb4){if(_0x178eb4){return _0x178eb4[_0xff8a('0xca')](_0x1326a9[_0xff8a('0x37')]['ids']);}})[_0xff8a('0x1a')](respondWithStatusCode(_0x7fcde8,null))['catch'](handleError(_0x7fcde8,null));};exports[_0xff8a('0xcb')]=function(_0x311d68,_0x404909){var _0x2fdd6e=moment()[_0xff8a('0xcc')]()[_0xff8a('0x8f')]();var _0x45247f=path[_0xff8a('0xcd')](config[_0xff8a('0xce')],_0xff8a('0xcf'),_0xff8a('0xd0'),_0xff8a('0xd1'));var _0x1ba8c3=path[_0xff8a('0xcd')](config[_0xff8a('0xce')],_0xff8a('0xcf'),_0xff8a('0xd0'),'attachments');var _0x236eb2=path[_0xff8a('0xcd')](_0x45247f,_0x2fdd6e);var _0xeb9e6c=util['format']('transcript-%d-%s.zip',_0x311d68[_0xff8a('0xb4')]['id'],_0x2fdd6e);var _0x283e17=path[_0xff8a('0xcd')](_0x45247f,_0xeb9e6c);var _0x2b24ca=[];if(_0x311d68['query'][_0xff8a('0xd2')]){_0x2b24ca[_0xff8a('0xb0')]({'model':db[_0xff8a('0xd3')],'as':_0xff8a('0xd4'),'raw':!![]});}var _0x5c9682=[{'model':db[_0xff8a('0x26')],'as':_0xff8a('0xd5'),'attributes':['id',_0xff8a('0xba'),'from','to','cc',_0xff8a('0xd6'),_0xff8a('0xd7'),'createdAt'],'where':{'secret':![]},'order':qs[_0xff8a('0x41')]('id'),'include':_0x2b24ca}];return db[_0xff8a('0x33')][_0xff8a('0x5b')]({'where':{'id':_0x311d68[_0xff8a('0xb4')]['id']},'include':_0x5c9682})[_0xff8a('0x1a')](handleEntityNotFound(_0x404909,null))[_0xff8a('0x1a')](function(_0x27a29a){if(_0x27a29a&&_0x27a29a[_0xff8a('0xd5')]){var _0x4b8636=_0x27a29a['get']({'plain':!![]});fs[_0xff8a('0xd8')](_0x236eb2);return BPromise[_0xff8a('0xd9')](_0x4b8636[_0xff8a('0xd5')],function(_0x1a1945,_0x504443){var _0x2bdb43={'from':_0x1a1945[_0xff8a('0x44')],'to':_0x1a1945['to'],'subject':_0x1a1945[_0xff8a('0xd7')],'html':htmlEntities[_0xff8a('0xda')](_0x1a1945['body']),'headers':{'Date':moment(_0x1a1945[_0xff8a('0x72')])[_0xff8a('0xc2')](_0xff8a('0xdb'))},'attachments':[]};if(_0x1a1945['cc']){_0x2bdb43[_0xff8a('0xdc')]['Cc']=_0x1a1945['cc'];}if(_0x1a1945[_0xff8a('0xd6')]){_0x2bdb43[_0xff8a('0xdc')][_0xff8a('0xdd')]=_0x1a1945[_0xff8a('0xd6')];}return new BPromise(function(_0x428ed3,_0x30233b){if(_0x1a1945[_0xff8a('0xd4')]){for(var _0x362fca=0x0;_0x362fca<_0x1a1945[_0xff8a('0xd4')][_0xff8a('0x5a')];_0x362fca++){var _0x1a7772=_0x1a1945[_0xff8a('0xd4')][_0x362fca];var _0x1cb1fa=path[_0xff8a('0xcd')](_0x1ba8c3,_0x1a7772['basename']);if(fs['existsSync'](_0x1cb1fa)){_0x2bdb43[_0xff8a('0xd2')][_0xff8a('0xb0')]({'name':_0x1a7772[_0xff8a('0x1d')],'contentType':_0x1a7772[_0xff8a('0x6c')],'data':fs['readFileSync'](_0x1cb1fa)});}}}emlformat['build'](_0x2bdb43,function(_0x456e4a,_0x3ac259){if(_0x456e4a)return _0x30233b(_0x456e4a);fs[_0xff8a('0xde')](path[_0xff8a('0xcd')](_0x236eb2,util['format'](_0xff8a('0xdf'),_0x504443)),_0x3ac259);return _0x428ed3(_0x3ac259);});});})[_0xff8a('0x1a')](function(){return new BPromise(function(_0x30edca,_0x3ce848){zipdir(_0x236eb2,{'saveTo':_0x283e17},function(_0xca22eb,_0x6c0634){if(_0xca22eb)return _0x3ce848(_0xca22eb);return _0x30edca(_0x6c0634);});})[_0xff8a('0x1a')](function(){return new BPromise(function(_0x59734,_0x4657ef){rimraf(_0x236eb2,function(_0x1a9e9e){if(_0x1a9e9e)_0x4657ef(_0x1a9e9e);return _0x59734();});});})['then'](function(){return _0x404909[_0xff8a('0xcb')](_0x283e17,_0xeb9e6c,function(_0x25f412){if(!_0x25f412)fs[_0xff8a('0xe0')](_0x283e17);});});});}else{return _0x404909['sendStatus'](0xc8);}})['catch'](handleError(_0x404909,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff