// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x83d0=['talking','answered','unmanaged','total','waiting','closed','UserId','index','MailInteraction','fieldName','key','model','query','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','tools_tags','u.fullname','ui.MailInteractionId','from','u.id\x20=\x20ui.UserId','mail_interactions','left_join','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','a.id\x20=\x20i.MailAccountId','mail_messages','me.MailInteractionId\x20=\x20i.id','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','length','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','type','text','start','Tag','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','buildExpression','some','isEmpty','MailAccountId','i.MailAccountId\x20IN\x20?','concat','createdAt','parse','$lte','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','isArray','tag','filter','replace','isNumeric','i.id\x20LIKE\x20?','isEmail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','Sequelize','SELECT','clone','i.id','t.id\x20IN\x20?','resolve','user','agent','getMailAccounts','i.MailAccountId\x20IS\x20NULL','toString','sequelize','merge','a.key','Account.key','a.mandatoryDisposition','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20(\x27%\x27\x20+\x20a.email\x20+\x20\x27%\x27)\x20THEN\x20SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201)\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.createdAt','i.updatedAt','i.closed','i.lastMsgAt','i.lastMsgDirection','i.secondDisposition','i.thirdDisposition','i.substatus','i.MailAccountId','i.UserId','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.mobile','Contact.mobile','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','groupBy','Setting','enableEmailPreview','rows','show','params','options','create','body','destroy','addMessage','ids','omit','rawAttributes','MailInteractionId','$gte','format','YYYY-MM-DD\x20HH:mm:ss','includeAll','findAll','inlineCss','true','addTags','setTags','spread','emit','mailInteractionTags:save','removeTags','download','unix','root','server','files','tmp','join','attachments','Attachment','Messages','bcc','mkdirSync','each','subject','decode','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','Bcc','Attachments','basename','existsSync','build','writeFileSync','message%d.eml','unlinkSync','eml-format','rimraf','zip-dir','moment','bluebird','util','lodash','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','html-entities','redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','sendStatus','end','status','limit','undefined','count','offset','set','Content-Range','json','update','then','error','stack','name','send','Users','map','fullname','TagIds','Tags','split','forEach','push','MailMessage','findOne','plainBody','-id','trimStart','catch'];(function(_0x3220c9,_0xa67ccd){var _0x45528a=function(_0x1d7405){while(--_0x1d7405){_0x3220c9['push'](_0x3220c9['shift']());}};_0x45528a(++_0xa67ccd);}(_0x83d0,0xb7));var _0x083d=function(_0x2ba21a,_0x4aca4e){_0x2ba21a=_0x2ba21a-0x0;var _0x51ce42=_0x83d0[_0x2ba21a];return _0x51ce42;};'use strict';var emlformat=require(_0x083d('0x0'));var rimraf=require(_0x083d('0x1'));var zipdir=require(_0x083d('0x2'));var moment=require(_0x083d('0x3'));var BPromise=require(_0x083d('0x4'));var util=require(_0x083d('0x5'));var path=require('path');var fs=require('fs');var _=require(_0x083d('0x6'));var squel=require('squel');var juice=require('juice');var Redis=require(_0x083d('0x7'));var qs=require(_0x083d('0x8'));var as=require(_0x083d('0x9'));var logger=require(_0x083d('0xa'))(_0x083d('0xb'));var config=require('../../config/environment');var db=require('../../mysqldb')['db'];var htmlEntities=require(_0x083d('0xc'));config[_0x083d('0xd')]=_[_0x083d('0xe')](config['redis'],{'host':_0x083d('0xf'),'port':0x18eb});var socket=require(_0x083d('0x10'))(new Redis(config[_0x083d('0xd')]));require(_0x083d('0x11'))['register'](socket);function respondWithStatusCode(_0x3473fa,_0x5be91f){_0x5be91f=_0x5be91f||0xcc;return function(_0x1a2155){if(_0x1a2155){return _0x3473fa[_0x083d('0x12')](_0x5be91f);}return _0x3473fa['status'](_0x5be91f)[_0x083d('0x13')]();};}function respondWithResult(_0x93be5c,_0x23ccf2){_0x23ccf2=_0x23ccf2||0xc8;return function(_0x3e5be5){if(_0x3e5be5){return _0x93be5c[_0x083d('0x14')](_0x23ccf2)['json'](_0x3e5be5);}};}function respondWithFilteredResult(_0xeb0ac2,_0x2266b2){return function(_0x4ee93c){if(_0x4ee93c){var _0x11c03f=typeof _0x2266b2['offset']==='undefined'&&typeof _0x2266b2[_0x083d('0x15')]===_0x083d('0x16');var _0x356d8e=_0x4ee93c[_0x083d('0x17')];var _0x381455=_0x11c03f?0x0:_0x2266b2['offset'];var _0x2ec521=_0x11c03f?_0x4ee93c['count']:_0x2266b2[_0x083d('0x18')]+_0x2266b2[_0x083d('0x15')];var _0x24708d;if(_0x2ec521>=_0x356d8e){_0x2ec521=_0x356d8e;_0x24708d=0xc8;}else{_0x24708d=0xce;}_0xeb0ac2[_0x083d('0x14')](_0x24708d);return _0xeb0ac2[_0x083d('0x19')](_0x083d('0x1a'),_0x381455+'-'+_0x2ec521+'/'+_0x356d8e)[_0x083d('0x1b')](_0x4ee93c);}return null;};}function saveUpdates(_0x3a3dd3){return function(_0x160afb){if(_0x160afb){return _0x160afb[_0x083d('0x1c')](_0x3a3dd3)[_0x083d('0x1d')](function(_0xb8a16f){return _0xb8a16f;});}return null;};}function removeEntity(_0x5dd1ba){return function(_0x24dd4e){if(_0x24dd4e){return _0x24dd4e['destroy']()[_0x083d('0x1d')](function(){_0x5dd1ba[_0x083d('0x14')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2b2ba6){return function(_0x4bd7c2){if(!_0x4bd7c2){_0x2b2ba6['sendStatus'](0x194);}return _0x4bd7c2;};}function handleError(_0x59828a,_0xcde93c){_0xcde93c=_0xcde93c||0x1f4;return function(_0x32f1ba){logger[_0x083d('0x1e')](_0x32f1ba[_0x083d('0x1f')]);if(_0x32f1ba[_0x083d('0x20')]){delete _0x32f1ba[_0x083d('0x20')];}_0x59828a['status'](_0xcde93c)[_0x083d('0x21')](_0x32f1ba);};}function getInteractionUsers(_0x33f423,_0x5e6e43){return new BPromise(function(_0x3a0ce2,_0x38ca23){try{if(_0x5e6e43[_0x33f423['id']]){_0x33f423[_0x083d('0x22')]=_[_0x083d('0x23')](_0x5e6e43[_0x33f423['id']],function(_0x42a8f8){return{'id':_0x42a8f8['id'],'fullname':_0x42a8f8[_0x083d('0x24')]};});}}catch(_0x9bc640){_0x38ca23(_0x9bc640);}_0x3a0ce2(_0x33f423);});}function getInteractionTags(_0x3923ff,_0x552bc9){return new BPromise(function(_0x6bccbd,_0x50e5ae){try{if(_0x3923ff[_0x083d('0x25')]){_0x3923ff[_0x083d('0x26')]=[];_0x3923ff[_0x083d('0x25')][_0x083d('0x27')](',')[_0x083d('0x28')](function(_0x13c376){_0x3923ff[_0x083d('0x26')][_0x083d('0x29')](_0x552bc9[_0x13c376]);});}delete _0x3923ff[_0x083d('0x25')];}catch(_0x3f41a4){_0x50e5ae(_0x3f41a4);}_0x6bccbd(_0x3923ff);});}function getLastMessageText(_0x2d9202){return new BPromise(function(_0x24c32c,_0x4588df){return db[_0x083d('0x2a')][_0x083d('0x2b')]({'where':{'$and':[{'MailInteractionId':_0x2d9202['id']},{'$or':[{'direction':'in'},{'$and':[{'direction':'out'},{'secret':![]},{'UserId':{'$ne':null}}]}]}]},'attributes':[_0x083d('0x2c')],'order':_0x083d('0x2d'),'raw':!![]})['then'](function(_0x4c971d){if(_0x4c971d&&_0x4c971d[_0x083d('0x2c')]){_0x2d9202['lastMsgText']=_[_0x083d('0x2e')](_0x4c971d['plainBody']);}_0x24c32c(_0x2d9202);})[_0x083d('0x2f')](function(_0x59f1d5){_0x4588df(_0x59f1d5);});});}function updateMailInteraction(_0x3a2c3d,_0x46d991,_0x3ab8cd,_0x5ae450){return new BPromise(function(_0x5e5e4e,_0x3563bf){return getInteractionUsers(_0x3a2c3d,_0x3ab8cd)['then'](function(_0x18d68c){return getInteractionTags(_0x18d68c,_0x46d991);})[_0x083d('0x1d')](function(_0x17a3e3){return getStateInteraction(_0x17a3e3);})[_0x083d('0x1d')](function(_0x4d76c7){if(_0x5ae450){_0x5e5e4e(getLastMessageText(_0x4d76c7));}else{_0x5e5e4e(_0x4d76c7);}})[_0x083d('0x2f')](function(_0x438957){_0x3563bf(_0x438957);});});}function getStateInteraction(_0x1cc755){return new BPromise(function(_0x30f4ad){_0x1cc755['waiting']=0x0;_0x1cc755[_0x083d('0x30')]=0x0;_0x1cc755[_0x083d('0x31')]=0x0;_0x1cc755[_0x083d('0x32')]=0x0;_0x1cc755[_0x083d('0x33')]=0x0;if(!_0x1cc755['closed']&&!_0x1cc755['UserId']){_0x1cc755[_0x083d('0x34')]+=0x1;}if(!_0x1cc755[_0x083d('0x35')]&&_0x1cc755[_0x083d('0x36')]){_0x1cc755[_0x083d('0x30')]+=0x1;if(_0x1cc755[_0x083d('0x34')]){_0x1cc755['waiting']-=0x1;}}if(_0x1cc755[_0x083d('0x35')]&&_0x1cc755[_0x083d('0x36')]){_0x1cc755['answered']+=0x1;if(_0x1cc755[_0x083d('0x30')]){_0x1cc755['talking']-=0x1;}}if(_0x1cc755['closed']&&!_0x1cc755[_0x083d('0x36')]){_0x1cc755[_0x083d('0x32')]+=0x1;if(_0x1cc755['waiting']){_0x1cc755[_0x083d('0x34')]-=0x1;}}_0x1cc755[_0x083d('0x33')]+=0x1;_0x30f4ad(_0x1cc755);});}exports[_0x083d('0x37')]=function(_0x594327,_0x5766d5){var _0x48e297={},_0x4b1268={},_0xbc94e8={'count':0x0,'rows':[]};var _0x417585=_[_0x083d('0x23')](db[_0x083d('0x38')]['rawAttributes'],function(_0x5ad9f2){return{'name':_0x5ad9f2[_0x083d('0x39')],'type':_0x5ad9f2['type'][_0x083d('0x3a')]};});_0x4b1268[_0x083d('0x3b')]=_[_0x083d('0x23')](_0x417585,_0x083d('0x20'));_0x4b1268[_0x083d('0x3c')]=_[_0x083d('0x3d')](_0x594327[_0x083d('0x3c')]);_0x4b1268[_0x083d('0x3e')]=_['intersection'](_0x4b1268[_0x083d('0x3b')],_0x4b1268[_0x083d('0x3c')]);_0x48e297[_0x083d('0x3f')]=_[_0x083d('0x40')](_0x4b1268[_0x083d('0x3b')],qs[_0x083d('0x41')](_0x594327[_0x083d('0x3c')]['fields']));_0x48e297[_0x083d('0x3f')]=_0x48e297[_0x083d('0x3f')]['length']?_0x48e297[_0x083d('0x3f')]:_0x4b1268[_0x083d('0x3b')];if(!_0x594327[_0x083d('0x3c')][_0x083d('0x42')](_0x083d('0x43'))){_0x48e297['limit']=qs[_0x083d('0x15')](_0x594327[_0x083d('0x3c')][_0x083d('0x15')]);_0x48e297[_0x083d('0x18')]=qs[_0x083d('0x18')](_0x594327['query'][_0x083d('0x18')]);}_0x48e297[_0x083d('0x44')]=qs[_0x083d('0x45')](_0x594327[_0x083d('0x3c')][_0x083d('0x45')]);_0x48e297[_0x083d('0x46')]=qs['filters'](_[_0x083d('0x47')](_0x594327[_0x083d('0x3c')],_0x4b1268[_0x083d('0x3e')]),_0x417585);var _0x1bdafc=[];var _0x19bdc0=squel[_0x083d('0x48')]()[_0x083d('0x49')]('id')['field']('name')['field'](_0x083d('0x4a'))['from'](_0x083d('0x4b'));var _0x42af7d=squel[_0x083d('0x48')]()[_0x083d('0x49')]('u.id')[_0x083d('0x49')](_0x083d('0x4c'))[_0x083d('0x49')](_0x083d('0x4d'))[_0x083d('0x4e')]('user_has_mail_interactions','ui')['left_join']('users','u',_0x083d('0x4f'));var _0x34ed6c=squel[_0x083d('0x48')]()[_0x083d('0x4e')](_0x083d('0x50'),'i')[_0x083d('0x51')](_0x083d('0x52'),'c',_0x083d('0x53'))[_0x083d('0x51')]('users','o','o.id\x20=\x20i.UserId')[_0x083d('0x51')]('mail_accounts','a',_0x083d('0x54'))[_0x083d('0x51')](_0x083d('0x55'),'me',_0x083d('0x56'))[_0x083d('0x51')]('mail_interaction_has_tags','it',_0x083d('0x57'))['left_join']('tools_tags','t',_0x083d('0x58'));var _0x1bdfe5=squel[_0x083d('0x59')]();var _0x4273b2=[];var _0x10db3e=squel[_0x083d('0x59')]();var _0xa7a4bd;if(_0x594327['query'][_0x083d('0x5a')]){_0xa7a4bd=as[_0x083d('0x5b')](_0x594327[_0x083d('0x3c')][_0x083d('0x5a')]);var _0x395350=_0xa7a4bd[_0x083d('0x5c')];for(var _0x912e1e=0x0;_0x912e1e<_0xa7a4bd[_0x083d('0x5d')]['length'];_0x912e1e++){var _0x16892c=_0xa7a4bd[_0x083d('0x5d')][_0x912e1e];var _0x1505f8='i';var _0x20472f=_[_0x083d('0x5e')](_0x417585,[_0x083d('0x20'),_0x16892c[_0x083d('0x49')]]);if(!_0x20472f){switch(_0x16892c[_0x083d('0x49')]){case _0x083d('0x5f'):if(_0x16892c[_0x083d('0x60')]==0x1){_0x34ed6c[_0x083d('0x61')]('`'+_0x16892c[_0x083d('0x49')]+_0x083d('0x62'));}else{_0x34ed6c['having']('`'+_0x16892c['field']+_0x083d('0x63'));}break;case _0x083d('0x64'):if(_0x16892c[_0x083d('0x65')]===_0x083d('0x66')){if(_0x16892c['value'][_0x083d('0x27')]('\x20')[_0x083d('0x67')]>0x1){_0x1bdfe5[_0x395350](_0x083d('0x68'),qs[_0x083d('0x69')](_0x16892c[_0x083d('0x60')]),null);}else{var _0x48c6b3='%'+_0x16892c['value']+'%';_0x1bdfe5[_0x395350](_0x083d('0x6a'),_0x48c6b3,_0x48c6b3,_0x48c6b3);}}else{_0x20472f=_[_0x083d('0x5e')](_0x417585,[_0x083d('0x20'),'ContactId']);_0x16892c[_0x083d('0x49')]=_0x083d('0x6b');_0x3d6af8=as['buildExpression'](_0x1505f8,_0x20472f[_0x083d('0x6c')],_0x16892c);_0x1bdfe5[_0x395350](_0x3d6af8[_0x083d('0x6d')],_0x3d6af8['value'][_0x083d('0x6e')],_0x3d6af8[_0x083d('0x60')]['end']);}break;case _0x083d('0x6f'):var _0x6e2328=_0x16892c['value']['split'](',')[_0x083d('0x23')](function(_0x24acf7){return Number(_0x24acf7);});_0x6e2328[_0x083d('0x28')](function(_0x1d5761){_0x10db3e['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x1d5761+',%');});_0x4273b2=_[_0x083d('0x70')](_0x4273b2,_0x6e2328);break;case _0x083d('0x71'):if(_0x16892c[_0x083d('0x65')]==='$substring'){_0x1bdfe5[_0x395350](_0x083d('0x72'),'%'+_0x16892c[_0x083d('0x60')]+'%',null);}else{_0x20472f=_[_0x083d('0x5e')](_0x417585,[_0x083d('0x20'),'UserId']);_0x16892c['field']=_0x083d('0x36');_0x3d6af8=as[_0x083d('0x73')](_0x1505f8,_0x20472f['type'],_0x16892c);_0x1bdfe5[_0x395350](_0x3d6af8[_0x083d('0x6d')],_0x3d6af8[_0x083d('0x60')][_0x083d('0x6e')],_0x3d6af8[_0x083d('0x60')][_0x083d('0x13')]);}break;case'plainBody':_0x3d6af8=as[_0x083d('0x73')]('me',null,_0x16892c);_0x1bdfe5[_0x395350](_0x3d6af8[_0x083d('0x6d')],_0x3d6af8[_0x083d('0x60')][_0x083d('0x6e')],_0x3d6af8[_0x083d('0x60')][_0x083d('0x13')]);break;}}else{var _0x3d6af8=as[_0x083d('0x73')](_0x1505f8,_0x20472f['type'],_0x16892c);_0x1bdfe5[_0x395350](_0x3d6af8[_0x083d('0x6d')],_0x3d6af8[_0x083d('0x60')][_0x083d('0x6e')],_0x3d6af8['value']['end']);}}}else{var _0x63eda5=_(_0x594327[_0x083d('0x3c')])[_0x083d('0x3d')]()[_0x083d('0x23')](function(_0x51db05){return _[_0x083d('0x74')](_0x417585,['name',_0x51db05])?_0x51db05:undefined;})['compact']()[_0x083d('0x60')]();if(!_[_0x083d('0x75')](_0x63eda5)){_0x63eda5[_0x083d('0x28')](function(_0x276ac1){if(_0x276ac1===_0x083d('0x76')){_0x34ed6c[_0x083d('0x46')](_0x083d('0x77'),[][_0x083d('0x78')](_0x594327[_0x083d('0x3c')][_0x276ac1]));}else if(_0x276ac1===_0x083d('0x79')){var _0x3b54a4=JSON['parse'](_0x594327[_0x083d('0x3c')][_0x276ac1])['$gte'];var _0x5ea764=JSON[_0x083d('0x7a')](_0x594327[_0x083d('0x3c')][_0x276ac1])[_0x083d('0x7b')];_0x34ed6c[_0x083d('0x46')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x3b54a4,_0x5ea764);}else{if(_0x594327['query'][_0x276ac1]===_0x083d('0x7c')){_0x34ed6c[_0x083d('0x46')]('i.'+_0x276ac1+_0x083d('0x7d'));}else{_0x34ed6c['where']('i.'+_0x276ac1+_0x083d('0x7e'),_0x594327[_0x083d('0x3c')][_0x276ac1]);}}});}if(_0x594327['query'][_0x083d('0x7f')]){if(_0x594327[_0x083d('0x3c')][_0x083d('0x7f')]==0x1){_0x34ed6c[_0x083d('0x61')](_0x083d('0x80'));}else{_0x34ed6c[_0x083d('0x61')]('`unreadMessages`\x20>\x200');}}if(_0x594327[_0x083d('0x3c')]['tag']){_0x4273b2=_[_0x083d('0x81')](_0x594327['query']['tag'])?_0x594327[_0x083d('0x3c')]['tag']:new Array(_0x594327[_0x083d('0x3c')][_0x083d('0x82')]);_0x4273b2[_0x083d('0x28')](function(_0xa5d49d){_0x10db3e['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0xa5d49d+',%');});}if(_0x594327[_0x083d('0x3c')][_0x083d('0x83')]){var _0x154da6=_0x594327[_0x083d('0x3c')][_0x083d('0x83')][_0x083d('0x84')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0x083d('0x85')](_0x154da6)){_0x1bdfe5['or'](_0x083d('0x86'),_0x154da6+'%');}else if(qs[_0x083d('0x87')](_0x154da6)){_0x1bdfe5['or']('c.email\x20LIKE\x20?',_0x154da6+'%');}else{_0x1bdfe5['or'](_0x083d('0x88'),qs[_0x083d('0x69')](_0x154da6))['or'](_0x083d('0x89'),qs[_0x083d('0x69')](_0x154da6));}}}_0x34ed6c[_0x083d('0x46')](_0x1bdfe5);_0x34ed6c[_0x083d('0x8a')]('i.id');var _0x24b593={'type':db[_0x083d('0x8b')]['QueryTypes'][_0x083d('0x8c')],'raw':!![]};var _0x347ea0=_0x34ed6c[_0x083d('0x8d')]();_0x347ea0['field'](_0x083d('0x8e'));_0x347ea0[_0x083d('0x49')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x083d('0x5f'));if(_0x48e297['order']){_0x48e297[_0x083d('0x44')][_0x083d('0x28')](function(_0x3997b8){var _0x38ac1f=_0x3997b8[0x0]==='contactName'?_0x3997b8[0x0]:'i.'+_0x3997b8[0x0];_0x34ed6c[_0x083d('0x44')](_0x38ac1f,_0x3997b8[0x1]==='DESC'?![]:!![]);});}if(!_[_0x083d('0x75')](_0x4273b2)){_0x34ed6c[_0x083d('0x61')](_0x10db3e);_0x347ea0['where'](_0x083d('0x8f'),_0x4273b2);}BPromise[_0x083d('0x90')]()[_0x083d('0x1d')](function(){if(!_0xa7a4bd){if(_0x594327[_0x083d('0x3c')]['MailAccountId'])return;_0x347ea0['where']('i.MailAccountId\x20IS\x20NOT\x20NULL');_0x34ed6c[_0x083d('0x46')]('i.MailAccountId\x20IS\x20NOT\x20NULL');return;}if(_0x594327[_0x083d('0x91')]['role']!==_0x083d('0x92'))return;return _0x594327[_0x083d('0x91')][_0x083d('0x93')]({'attributes':['id'],'raw':!![]})[_0x083d('0x1d')](function(_0x3b38ae){if(_[_0x083d('0x75')](_0x3b38ae)){_0x347ea0[_0x083d('0x46')](_0x083d('0x94'));_0x34ed6c['where'](_0x083d('0x94'));}else{_0x347ea0[_0x083d('0x46')]('i.MailAccountId\x20IN\x20?',_[_0x083d('0x23')](_0x3b38ae,'id'));_0x34ed6c[_0x083d('0x46')](_0x083d('0x77'),_[_0x083d('0x23')](_0x3b38ae,'id'));}});})[_0x083d('0x1d')](function(){if(_0x594327[_0x083d('0x91')]['role']===_0x083d('0x92')&&!_0xa7a4bd&&!_0x594327[_0x083d('0x3c')]['MailAccountId'])return[];return db['sequelize'][_0x083d('0x3c')](_0x347ea0[_0x083d('0x95')](),_0x24b593);})[_0x083d('0x1d')](function(_0x212473){_0xbc94e8['count']=_0x212473[_0x083d('0x67')];if(_0xbc94e8[_0x083d('0x17')]===0x0)return[];return db[_0x083d('0x96')][_0x083d('0x3c')](_0x19bdc0['toString'](),_0x24b593)['then'](function(_0x586a14){_0x1bdafc=_['keyBy'](_0x586a14,'id');_0x24b593=_[_0x083d('0x97')](_0x24b593,{'model':db[_0x083d('0x38')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x594327[_0x083d('0x3c')][_0x083d('0x41')]){_0x48e297[_0x083d('0x3f')][_0x083d('0x28')](function(_0x181a7a){_0x34ed6c[_0x083d('0x49')]('i.'+_0x181a7a);});}else{_0x34ed6c['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x083d('0x5f'));_0x34ed6c[_0x083d('0x49')](_0x083d('0x98'),_0x083d('0x99'));_0x34ed6c[_0x083d('0x49')](_0x083d('0x9a'),'Account.mandatoryDisposition');_0x34ed6c[_0x083d('0x49')](_0x083d('0x9b'),_0x083d('0x9c'));_0x34ed6c[_0x083d('0x49')](_0x083d('0x8e'));_0x34ed6c[_0x083d('0x49')](_0x083d('0x9d'));_0x34ed6c[_0x083d('0x49')](_0x083d('0x9e'));_0x34ed6c[_0x083d('0x49')](_0x083d('0x9f'));_0x34ed6c['field']('i.closedAt');_0x34ed6c[_0x083d('0x49')]('i.attach');_0x34ed6c[_0x083d('0x49')](_0x083d('0xa0'));_0x34ed6c[_0x083d('0x49')](_0x083d('0xa1'));_0x34ed6c['field']('i.subject');_0x34ed6c['field']('i.disposition');_0x34ed6c[_0x083d('0x49')](_0x083d('0xa2'));_0x34ed6c[_0x083d('0x49')](_0x083d('0xa3'));_0x34ed6c[_0x083d('0x49')](_0x083d('0xa4'));_0x34ed6c[_0x083d('0x49')]('i.to');_0x34ed6c[_0x083d('0x49')]('i.ContactId');_0x34ed6c[_0x083d('0x49')](_0x083d('0xa5'));_0x34ed6c[_0x083d('0x49')](_0x083d('0xa6'));_0x34ed6c['field']('c.firstName',_0x083d('0xa7'));_0x34ed6c[_0x083d('0x49')](_0x083d('0xa8'),_0x083d('0xa9'));_0x34ed6c['field'](_0x083d('0xaa'),_0x083d('0xab'));_0x34ed6c[_0x083d('0x49')]('c.phone','Contact.phone');_0x34ed6c[_0x083d('0x49')](_0x083d('0xac'),_0x083d('0xad'));_0x34ed6c[_0x083d('0x49')]('c.fax',_0x083d('0xae'));_0x34ed6c[_0x083d('0x49')](_0x083d('0xaf'),_0x083d('0xb0'));_0x34ed6c[_0x083d('0x49')](_0x083d('0xb1'),_0x083d('0xb2'));_0x34ed6c['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0x083d('0x25'));}if(_0x48e297[_0x083d('0x15')])_0x34ed6c[_0x083d('0x15')](_0x48e297[_0x083d('0x15')]);if(_0x48e297[_0x083d('0x18')])_0x34ed6c[_0x083d('0x18')](_0x48e297['offset']);return db[_0x083d('0x96')][_0x083d('0x3c')](_0x34ed6c[_0x083d('0x95')](),_0x24b593);})[_0x083d('0x1d')](function(_0x23a718){if(_0x23a718[_0x083d('0x67')]>0x0)_0x42af7d[_0x083d('0x46')]('ui.MailInteractionId\x20IN\x20?',_[_0x083d('0x23')](_0x23a718,'id'));return db[_0x083d('0x96')]['query'](_0x42af7d[_0x083d('0x95')](),_0x24b593)[_0x083d('0x1d')](function(_0x1075c7){var _0x3bc174=_[_0x083d('0xb3')](_0x1075c7,'MailInteractionId');var _0x3d340d=[];return db[_0x083d('0xb4')]['findOne']({'attributes':[_0x083d('0xb5')],'raw':!![]})['then'](function(_0x2e43d7){var _0x2a01b4=_0x2e43d7[_0x083d('0xb5')];_0x23a718['forEach'](function(_0x3575df){_0x3d340d[_0x083d('0x29')](updateMailInteraction(_0x3575df,_0x1bdafc,_0x3bc174,_0x2a01b4));});return BPromise['all'](_0x3d340d);});});});})[_0x083d('0x1d')](function(_0x2918ce){_0xbc94e8[_0x083d('0xb6')]=_0x2918ce;return _0xbc94e8;})[_0x083d('0x1d')](respondWithFilteredResult(_0x5766d5,_0x48e297))[_0x083d('0x2f')](handleError(_0x5766d5,null));};exports[_0x083d('0xb7')]=function(_0x12c819,_0x2cc7e3){var _0x4f1aee={'raw':![],'where':{'id':_0x12c819[_0x083d('0xb8')]['id']}},_0x5554a0={};_0x5554a0[_0x083d('0x3b')]=_[_0x083d('0x3d')](db['MailInteraction']['rawAttributes']);_0x5554a0[_0x083d('0x3c')]=_['keys'](_0x12c819[_0x083d('0x3c')]);_0x5554a0['filters']=_['intersection'](_0x5554a0['model'],_0x5554a0[_0x083d('0x3c')]);_0x4f1aee[_0x083d('0x3f')]=_[_0x083d('0x40')](_0x5554a0['model'],qs[_0x083d('0x41')](_0x12c819[_0x083d('0x3c')]['fields']));_0x4f1aee[_0x083d('0x3f')]=_0x4f1aee['attributes'][_0x083d('0x67')]?_0x4f1aee[_0x083d('0x3f')]:_0x5554a0[_0x083d('0x3b')];if(_0x12c819['query']['includeAll']){_0x4f1aee['include']=[{'all':!![]}];}_0x4f1aee=_[_0x083d('0x97')]({},_0x4f1aee,_0x12c819[_0x083d('0xb9')]);return db[_0x083d('0x38')][_0x083d('0x5e')](_0x4f1aee)[_0x083d('0x1d')](handleEntityNotFound(_0x2cc7e3,null))[_0x083d('0x1d')](respondWithResult(_0x2cc7e3,null))[_0x083d('0x2f')](handleError(_0x2cc7e3,null));};exports[_0x083d('0xba')]=function(_0x46a46d,_0x1fca11){return db['MailInteraction'][_0x083d('0xba')](_0x46a46d[_0x083d('0xbb')],{})['then'](respondWithResult(_0x1fca11,0xc9))['catch'](handleError(_0x1fca11,null));};exports[_0x083d('0x1c')]=function(_0x3603d9,_0x2c5cc7){if(_0x3603d9[_0x083d('0xbb')]['id']){delete _0x3603d9[_0x083d('0xbb')]['id'];}return db[_0x083d('0x38')]['find']({'where':{'id':_0x3603d9['params']['id']}})[_0x083d('0x1d')](handleEntityNotFound(_0x2c5cc7,null))[_0x083d('0x1d')](saveUpdates(_0x3603d9[_0x083d('0xbb')],null))['then'](respondWithResult(_0x2c5cc7,null))[_0x083d('0x2f')](handleError(_0x2c5cc7,null));};exports[_0x083d('0xbc')]=function(_0x295574,_0x221d42){return db[_0x083d('0x38')][_0x083d('0x5e')]({'where':{'id':_0x295574[_0x083d('0xb8')]['id']}})['then'](handleEntityNotFound(_0x221d42,null))[_0x083d('0x1d')](removeEntity(_0x221d42,null))[_0x083d('0x2f')](handleError(_0x221d42,null));};exports['describe']=function(_0x45456e,_0x5bd5b9){return db[_0x083d('0x38')]['describe']()[_0x083d('0x1d')](respondWithResult(_0x5bd5b9,null))['catch'](handleError(_0x5bd5b9,null));};exports[_0x083d('0xbd')]=function(_0x5336b9,_0x3ced98){return db[_0x083d('0x2a')][_0x083d('0x5e')]({'where':{'id':_0x5336b9[_0x083d('0xb8')]['id']}})[_0x083d('0x1d')](handleEntityNotFound(_0x3ced98,null))['then'](function(_0x3aed94){if(_0x3aed94){return _0x3aed94[_0x083d('0xbd')](_0x5336b9['body'][_0x083d('0xbe')],_[_0x083d('0xbf')](_0x5336b9[_0x083d('0xbb')],['ids','id'])||{});}})[_0x083d('0x1d')](respondWithResult(_0x3ced98,null))[_0x083d('0x2f')](handleError(_0x3ced98,null));};exports['getMessages']=function(_0x8a8105,_0x1deffd){var _0x1e3427={'raw':![],'where':{}};var _0x2e7d58={};var _0x2f9741={'count':0x0,'rows':[]};return db['MailInteraction'][_0x083d('0x2b')]({'where':{'id':_0x8a8105['params']['id']}})[_0x083d('0x1d')](handleEntityNotFound(_0x1deffd,null))[_0x083d('0x1d')](function(_0x3b0c46){if(_0x3b0c46){_0x2e7d58[_0x083d('0x3b')]=_['keys'](db[_0x083d('0x2a')][_0x083d('0xc0')]);_0x2e7d58[_0x083d('0x3c')]=_[_0x083d('0x3d')](_0x8a8105[_0x083d('0x3c')]);_0x2e7d58[_0x083d('0x3e')]=_[_0x083d('0x40')](_0x2e7d58[_0x083d('0x3b')],_0x2e7d58[_0x083d('0x3c')]);_0x1e3427[_0x083d('0x3f')]=_[_0x083d('0x40')](_0x2e7d58[_0x083d('0x3b')],qs['fields'](_0x8a8105[_0x083d('0x3c')][_0x083d('0x41')]));_0x1e3427['attributes']=_0x1e3427[_0x083d('0x3f')][_0x083d('0x67')]?_0x1e3427['attributes']:_0x2e7d58[_0x083d('0x3b')];if(!_0x8a8105[_0x083d('0x3c')][_0x083d('0x42')]('nolimit')){_0x1e3427['limit']=qs[_0x083d('0x15')](_0x8a8105['query'][_0x083d('0x15')]);_0x1e3427[_0x083d('0x18')]=qs['offset'](_0x8a8105[_0x083d('0x3c')][_0x083d('0x18')]);}_0x1e3427[_0x083d('0x44')]=qs[_0x083d('0x45')](_0x8a8105[_0x083d('0x3c')][_0x083d('0x45')]);_0x1e3427[_0x083d('0x46')]=qs[_0x083d('0x3e')](_[_0x083d('0x47')](_0x8a8105[_0x083d('0x3c')],_0x2e7d58['filters']));_0x1e3427[_0x083d('0x46')][_0x083d('0xc1')]=_0x3b0c46['id'];if(_0x8a8105[_0x083d('0x3c')][_0x083d('0x83')]){_0x1e3427[_0x083d('0x46')]=_[_0x083d('0x97')](_0x1e3427[_0x083d('0x46')],{'$or':_['map'](_0x1e3427[_0x083d('0x3f')],function(_0x4d1a56){var _0x53c18c={};_0x53c18c[_0x4d1a56]={'$like':'%'+_0x8a8105[_0x083d('0x3c')]['filter']+'%'};return _0x53c18c;})});}if(_0x8a8105[_0x083d('0x3c')][_0x083d('0xc2')]){var _0xb8e3ae=_0x8a8105[_0x083d('0x3c')][_0x083d('0xc2')][_0x083d('0x27')](',');var _0x1584f1={};_0x1584f1[_0xb8e3ae[0x0]]={'$gte':moment(_0xb8e3ae[0x1])[_0x083d('0xc3')](_0x083d('0xc4'))};_0x1e3427['where']=_['merge'](_0x1e3427[_0x083d('0x46')],_0x1584f1);}_0x1e3427=_[_0x083d('0x97')]({},_0x1e3427,_0x8a8105[_0x083d('0xb9')]);return db[_0x083d('0x2a')][_0x083d('0x17')]({'where':_0x1e3427[_0x083d('0x46')]})[_0x083d('0x1d')](function(_0x48c7f2){_0x2f9741[_0x083d('0x17')]=_0x48c7f2;if(_0x8a8105[_0x083d('0x3c')][_0x083d('0xc5')]){_0x1e3427['include']=[{'all':!![]}];}return db[_0x083d('0x2a')][_0x083d('0xc6')](_0x1e3427);})['then'](function(_0x3db632){if(_0x8a8105[_0x083d('0x3c')][_0x083d('0xc7')]===_0x083d('0xc8')){for(var _0x38c181=0x0;_0x38c181<_0x3db632[_0x083d('0x67')];_0x38c181++){_0x3db632[_0x38c181][_0x083d('0xbb')]=juice(_0x3db632[_0x38c181]['body']);}}_0x2f9741['rows']=_0x3db632;return _0x2f9741;});}})['then'](respondWithFilteredResult(_0x1deffd,_0x1e3427))[_0x083d('0x2f')](handleError(_0x1deffd,null));};exports[_0x083d('0xc9')]=function(_0x464a39,_0xefb039){return db[_0x083d('0x38')][_0x083d('0x5e')]({'where':{'id':_0x464a39[_0x083d('0xb8')]['id']}})['then'](handleEntityNotFound(_0xefb039,null))[_0x083d('0x1d')](function(_0x337890){if(_0x337890){return _0x337890[_0x083d('0xca')](_0x464a39[_0x083d('0xbb')][_0x083d('0xbe')],_[_0x083d('0xbf')](_0x464a39['body'],[_0x083d('0xbe'),'id'])||{})[_0x083d('0xcb')](function(){return db[_0x083d('0x6f')]['findAll']({'attributes':['id','name',_0x083d('0x4a')],'where':{'id':_0x464a39[_0x083d('0xbb')]['ids']}});})['then'](function(_0x48ee79){socket[_0x083d('0xcc')](_0x083d('0xcd'),{'id':Number(_0x464a39[_0x083d('0xb8')]['id']),'tags':_0x48ee79||[]});return{'id':Number(_0x464a39[_0x083d('0xb8')]['id']),'tags':_0x48ee79||[]};});}})[_0x083d('0x1d')](respondWithResult(_0xefb039,null))[_0x083d('0x2f')](handleError(_0xefb039,null));};exports[_0x083d('0xce')]=function(_0xf8c2c0,_0x29e65a){return db[_0x083d('0x38')][_0x083d('0x5e')]({'where':{'id':_0xf8c2c0[_0x083d('0xb8')]['id']}})['then'](handleEntityNotFound(_0x29e65a,null))[_0x083d('0x1d')](function(_0x58fc22){if(_0x58fc22){return _0x58fc22['removeTags'](_0xf8c2c0['query'][_0x083d('0xbe')]);}})['then'](respondWithStatusCode(_0x29e65a,null))['catch'](handleError(_0x29e65a,null));};exports[_0x083d('0xcf')]=function(_0x546931,_0x2f30ae){var _0xdc0baf=moment()[_0x083d('0xd0')]()[_0x083d('0x95')]();var _0x489a84=path['join'](config[_0x083d('0xd1')],_0x083d('0xd2'),_0x083d('0xd3'),_0x083d('0xd4'));var _0x39d9a2=path[_0x083d('0xd5')](config[_0x083d('0xd1')],'server',_0x083d('0xd3'),'attachments');var _0x17a569=path[_0x083d('0xd5')](_0x489a84,_0xdc0baf);var _0x364036=util[_0x083d('0xc3')]('transcript-%d-%s.zip',_0x546931[_0x083d('0xb8')]['id'],_0xdc0baf);var _0x58077e=path['join'](_0x489a84,_0x364036);var _0x3edf16=[];if(_0x546931[_0x083d('0x3c')][_0x083d('0xd6')]){_0x3edf16[_0x083d('0x29')]({'model':db[_0x083d('0xd7')],'as':'Attachments','raw':!![]});}var _0x1f2ae6=[{'model':db[_0x083d('0x2a')],'as':_0x083d('0xd8'),'attributes':['id','body',_0x083d('0x4e'),'to','cc',_0x083d('0xd9'),'subject','createdAt'],'where':{'secret':![]},'order':qs[_0x083d('0x45')]('id'),'include':_0x3edf16}];return db[_0x083d('0x38')][_0x083d('0x5e')]({'where':{'id':_0x546931[_0x083d('0xb8')]['id']},'include':_0x1f2ae6})['then'](handleEntityNotFound(_0x2f30ae,null))[_0x083d('0x1d')](function(_0x1ddfcf){if(_0x1ddfcf&&_0x1ddfcf['Messages']){var _0x3700fb=_0x1ddfcf['get']({'plain':!![]});fs[_0x083d('0xda')](_0x17a569);return BPromise[_0x083d('0xdb')](_0x3700fb[_0x083d('0xd8')],function(_0x26d1c2,_0x444045){var _0xcdfc86={'from':_0x26d1c2[_0x083d('0x4e')],'to':_0x26d1c2['to'],'subject':_0x26d1c2[_0x083d('0xdc')],'html':htmlEntities[_0x083d('0xdd')](_0x26d1c2[_0x083d('0xbb')]),'headers':{'Date':moment(_0x26d1c2[_0x083d('0x79')])['format'](_0x083d('0xde'))},'attachments':[]};if(_0x26d1c2['cc']){_0xcdfc86['headers']['Cc']=_0x26d1c2['cc'];}if(_0x26d1c2[_0x083d('0xd9')]){_0xcdfc86['headers'][_0x083d('0xdf')]=_0x26d1c2[_0x083d('0xd9')];}return new BPromise(function(_0x509f34,_0x5d0315){if(_0x26d1c2[_0x083d('0xe0')]){for(var _0x4cd5db=0x0;_0x4cd5db<_0x26d1c2[_0x083d('0xe0')][_0x083d('0x67')];_0x4cd5db++){var _0x335523=_0x26d1c2['Attachments'][_0x4cd5db];var _0x8e6b98=path[_0x083d('0xd5')](_0x39d9a2,_0x335523[_0x083d('0xe1')]);if(fs[_0x083d('0xe2')](_0x8e6b98)){_0xcdfc86[_0x083d('0xd6')][_0x083d('0x29')]({'name':_0x335523['name'],'contentType':_0x335523[_0x083d('0x6c')],'data':fs['readFileSync'](_0x8e6b98)});}}}emlformat[_0x083d('0xe3')](_0xcdfc86,function(_0x3da861,_0x3beb7f){if(_0x3da861)return _0x5d0315(_0x3da861);fs[_0x083d('0xe4')](path['join'](_0x17a569,util[_0x083d('0xc3')](_0x083d('0xe5'),_0x444045)),_0x3beb7f);return _0x509f34(_0x3beb7f);});});})['then'](function(){return new BPromise(function(_0x1aa443,_0x9045cf){zipdir(_0x17a569,{'saveTo':_0x58077e},function(_0x2400fb,_0x43f335){if(_0x2400fb)return _0x9045cf(_0x2400fb);return _0x1aa443(_0x43f335);});})[_0x083d('0x1d')](function(){return new BPromise(function(_0x33a691,_0x45c9d9){rimraf(_0x17a569,function(_0x6ae77b){if(_0x6ae77b)_0x45c9d9(_0x6ae77b);return _0x33a691();});});})[_0x083d('0x1d')](function(){return _0x2f30ae[_0x083d('0xcf')](_0x58077e,_0x364036,function(_0x88235a){if(!_0x88235a)fs[_0x083d('0xe6')](_0x58077e);});});});}else{return _0x2f30ae['sendStatus'](0xc8);}})[_0x083d('0x2f')](handleError(_0x2f30ae,null));};
\ No newline at end of file
+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
git://repos.xcallymotion.com / motion2.git / blobdiff