18 var _0xa9e0=['sequelize','keyBy','merge','a.key','Account.key','i.createdAt','i.updatedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.disposition','i.substatus','i.to','i.ContactId','Contact.firstName','Contact.email','c.phone','c.mobile','c.fax','Contact.fax','GROUP_CONCAT(DISTINCT\x20t.id)','ui.MailInteractionId\x20IN\x20?','MailInteractionId','enableEmailPreview','all','rows','show','params','includeAll','include','options','find','create','body','describe','addMessage','ids','omit','getMessages','$gte','YYYY-MM-DD\x20HH:mm:ss','addTags','setTags','spread','Tag','findAll','emit','removeTags','unix','root','server','files','join','tmp','interaction-%s.zip','bcc','attachments','Attachment','Attachments','mkdirSync','subject','ddd,\x20DD\x20MMM\x20YYYY\x20HH:mm:ss\x20ZZ','headers','basename','writeFileSync','message%d.eml','download','log','err','unlinkSync','html-pdf','eml-format','rimraf','request-promise','bluebird','mustache','util','path','sox','ejs','lodash','squel','desk.js','papaparse','html-to-text','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./mailInteraction.socket','register','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','reject','update','then','destroy','error','name','send','closed','unreadMessages','MailMessage','Users','map','Tags','TagIds','split','forEach','push','MailInteraction','findOne','lastMsgText','trimStart','lastMsgBody','catch','index','rawAttributes','model','keys','query','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','select','field','color','tools_tags','COUNT(*)','mail_messages','me.MailInteractionId\x20=\x20i.id','me.direction\x20=\x20\x27in\x27','me.read\x20=\x20false','u.id','ui.MailInteractionId','from','user_has_mail_interactions','left_join','users','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','mail_accounts','a.id\x20=\x20i.MailAccountId','expr','parse','createdAt','value','startOf','day','utc','and','isArray','TagId','Messages.count','\x20IN\x20?','tableAlias','\x20=\x20?','LIKE','c.lastName','c.email','\x20LIKE\x20?','\x20>\x20?','\x20<\x20?','condition','ContactId','c.firstName','isNil','isEmpty','MailAccountId','i.MailAccountId\x20IN\x20?','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','filter','replace','\x27\x27\x27\x27','isNumeric','i.id\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','toString','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.id','QueryTypes','clone','advancedFilter','read','format','%s\x20=\x200','having','`Messages.count`\x20>\x200','tag','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','t.id\x20IN\x20?','`Messages.count`\x20=\x200'];(function(_0x4d9c48,_0x2dbb71){var _0x276911=function(_0x40b506){while(--_0x40b506){_0x4d9c48['push'](_0x4d9c48['shift']());}};_0x276911(++_0x2dbb71);}(_0xa9e0,0x123));var _0x0a9e=function(_0x521929,_0x479be5){_0x521929=_0x521929-0x0;var _0x632436=_0xa9e0[_0x521929];return _0x632436;};'use strict';var pdf=require(_0x0a9e('0x0'));var emlformat=require(_0x0a9e('0x1'));var rimraf=require(_0x0a9e('0x2'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x0a9e('0x3'));var moment=require('moment');var BPromise=require(_0x0a9e('0x4'));var Mustache=require(_0x0a9e('0x5'));var util=require(_0x0a9e('0x6'));var path=require(_0x0a9e('0x7'));var sox=require(_0x0a9e('0x8'));var csv=require('to-csv');var ejs=require(_0x0a9e('0x9'));var fs=require('fs');var _=require(_0x0a9e('0xa'));var squel=require(_0x0a9e('0xb'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x0a9e('0xc'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x0a9e('0xd'));var htmlToText=require(_0x0a9e('0xe'));var Redis=require(_0x0a9e('0xf'));var authService=require(_0x0a9e('0x10'));var qs=require(_0x0a9e('0x11'));var hardwareService=require(_0x0a9e('0x12'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require('../../config/environment');var db=require(_0x0a9e('0x13'))['db'];config[_0x0a9e('0x14')]=_[_0x0a9e('0x15')](config[_0x0a9e('0x14')],{'host':_0x0a9e('0x16'),'port':0x18eb});var socket=require(_0x0a9e('0x17'))(new Redis(config['redis']));require(_0x0a9e('0x18'))[_0x0a9e('0x19')](socket);function respondWithStatusCode(_0x2b4227,_0x281129){_0x281129=_0x281129||0xcc;return function(_0x44dcfd){if(_0x44dcfd){return _0x2b4227[_0x0a9e('0x1a')](_0x281129);}return _0x2b4227['status'](_0x281129)[_0x0a9e('0x1b')]();};}function respondWithResult(_0x5d0880,_0x1985b6){_0x1985b6=_0x1985b6||0xc8;return function(_0x519dfd){if(_0x519dfd){return _0x5d0880[_0x0a9e('0x1c')](_0x1985b6)[_0x0a9e('0x1d')](_0x519dfd);}};}function respondWithFilteredResult(_0x48f32d,_0x225616){return function(_0x5a0a06){if(_0x5a0a06){var _0x459eb1=_0x5a0a06[_0x0a9e('0x1e')],_0x478723=_0x225616[_0x0a9e('0x1f')],_0x106033=_0x225616[_0x0a9e('0x1f')]+_0x225616[_0x0a9e('0x20')],_0x205fd6;if(_0x106033>=_0x459eb1){_0x106033=_0x459eb1;_0x205fd6=0xc8;}else{_0x205fd6=0xce;}_0x48f32d[_0x0a9e('0x1c')](_0x205fd6);return _0x48f32d[_0x0a9e('0x21')](_0x0a9e('0x22'),_0x478723+'-'+_0x106033+'/'+_0x459eb1)[_0x0a9e('0x1d')](_0x5a0a06);}return null;};}function patchUpdates(_0x4bb1e3){return function(_0x2c3407){try{jsonpatch[_0x0a9e('0x23')](_0x2c3407,_0x4bb1e3,!![]);}catch(_0x53682f){return BPromise[_0x0a9e('0x24')](_0x53682f);}return _0x2c3407['save']();};}function saveUpdates(_0x588269,_0x3a02e1){return function(_0x432e56){if(_0x432e56){return _0x432e56[_0x0a9e('0x25')](_0x588269)[_0x0a9e('0x26')](function(_0x4abc77){return _0x4abc77;});}return null;};}function removeEntity(_0xfb6e48,_0x2fb0e4){return function(_0x3b45bc){if(_0x3b45bc){return _0x3b45bc[_0x0a9e('0x27')]()[_0x0a9e('0x26')](function(){_0xfb6e48[_0x0a9e('0x1c')](0xcc)[_0x0a9e('0x1b')]();});}};}function handleEntityNotFound(_0x5ea472,_0x59181e){return function(_0x197ec0){if(!_0x197ec0){_0x5ea472[_0x0a9e('0x1a')](0x194);}return _0x197ec0;};}function handleError(_0x40c424,_0x33161b){_0x33161b=_0x33161b||0x1f4;return function(_0x526cf3){logger[_0x0a9e('0x28')](_0x526cf3['stack']);if(_0x526cf3[_0x0a9e('0x29')]){delete _0x526cf3['name'];}_0x40c424[_0x0a9e('0x1c')](_0x33161b)[_0x0a9e('0x2a')](_0x526cf3);};}function getInteractionUnreadMessages(_0x25fba9){return new BPromise(function(_0x14433c,_0x140511){try{if(_0x25fba9[_0x0a9e('0x2b')]){_0x25fba9[_0x0a9e('0x2c')]=0x0;_0x14433c(_0x25fba9);}else{return db[_0x0a9e('0x2d')]['count']({'where':{'MailInteractionId':_0x25fba9['id'],'direction':'in','read':![]}})[_0x0a9e('0x26')](function(_0x468813){_0x25fba9[_0x0a9e('0x2c')]=_0x468813;_0x14433c(_0x25fba9);});}}catch(_0x2ec755){_0x140511(_0x2ec755);}});}function getInteractionUsers(_0x5c877d,_0x15b200){return new BPromise(function(_0x40e7a3,_0x1843b2){try{if(_0x15b200[_0x5c877d['id']]){_0x5c877d[_0x0a9e('0x2e')]=_[_0x0a9e('0x2f')](_0x15b200[_0x5c877d['id']],function(_0x563b45){return{'id':_0x563b45['id']};});}}catch(_0x296f41){_0x1843b2(_0x296f41);}_0x40e7a3(_0x5c877d);});}function getInteractionTags(_0x2e8759,_0x1dbde2){return new BPromise(function(_0x540530,_0x426950){try{if(_0x2e8759['TagIds']){_0x2e8759[_0x0a9e('0x30')]=[];_0x2e8759[_0x0a9e('0x31')][_0x0a9e('0x32')](',')[_0x0a9e('0x33')](function(_0x25ce3a){_0x2e8759['Tags'][_0x0a9e('0x34')](_0x1dbde2[_0x25ce3a]);});}delete _0x2e8759[_0x0a9e('0x31')];}catch(_0x40cb85){_0x426950(_0x40cb85);}_0x540530(_0x2e8759);});}function getLastMessageText(_0x2da5c0){return new BPromise(function(_0x2b45ea,_0x409319){return db[_0x0a9e('0x35')][_0x0a9e('0x36')]({'where':{'id':_0x2da5c0['id']},'attributes':['lastMsgBody',_0x0a9e('0x37')],'raw':!![]})['then'](function(_0x2cc7a0){if(!_0x2cc7a0[_0x0a9e('0x37')]){_0x2da5c0[_0x0a9e('0x37')]=_[_0x0a9e('0x38')](htmlToText['fromString'](_0x2cc7a0[_0x0a9e('0x39')],{'preserveNewlines':!![],'singleNewLineParagraphs':!![],'uppercaseHeadings':![],'noLinkBrackets':!![],'ignoreImage':!![]}));}else{_0x2da5c0[_0x0a9e('0x37')]=_0x2cc7a0[_0x0a9e('0x37')];}_0x2b45ea(_0x2da5c0);})[_0x0a9e('0x3a')](function(_0x4853b1){_0x409319(_0x4853b1);});});}function updateMailInteraction(_0x54135e,_0x1e8694,_0x5640eb,_0x24936a){return new BPromise(function(_0x3d9717,_0x381c37){return getInteractionUnreadMessages(_0x54135e)[_0x0a9e('0x26')](function(_0x4f41ae){return getInteractionUsers(_0x4f41ae,_0x5640eb);})[_0x0a9e('0x26')](function(_0x3bfce8){return getInteractionTags(_0x3bfce8,_0x1e8694);})[_0x0a9e('0x26')](function(_0x533942){if(_0x24936a){_0x3d9717(getLastMessageText(_0x533942));}else{_0x3d9717(_0x533942);}})[_0x0a9e('0x3a')](function(_0x1a180b){_0x381c37(_0x1a180b);});});}exports[_0x0a9e('0x3b')]=function(_0x4c1c0e,_0x546ef8){var _0x11b61d={},_0x40d766={},_0x5adda1={'count':0x0,'rows':[]};var _0x2b814e=db[_0x0a9e('0x35')][_0x0a9e('0x3c')];_0x40d766[_0x0a9e('0x3d')]=_['keys'](_0x2b814e);_0x40d766['query']=_[_0x0a9e('0x3e')](_0x4c1c0e[_0x0a9e('0x3f')]);_0x40d766['filters']=_[_0x0a9e('0x40')](_0x40d766[_0x0a9e('0x3d')],_0x40d766[_0x0a9e('0x3f')]);_0x11b61d['attributes']=_[_0x0a9e('0x40')](_0x40d766[_0x0a9e('0x3d')],qs[_0x0a9e('0x41')](_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x41')]));_0x11b61d[_0x0a9e('0x42')]=_0x11b61d[_0x0a9e('0x42')][_0x0a9e('0x43')]?_0x11b61d[_0x0a9e('0x42')]:_0x40d766[_0x0a9e('0x3d')];if(!_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x44')](_0x0a9e('0x45'))){_0x11b61d[_0x0a9e('0x20')]=qs[_0x0a9e('0x20')](_0x4c1c0e['query']['limit']);_0x11b61d[_0x0a9e('0x1f')]=qs[_0x0a9e('0x1f')](_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x1f')]);}_0x11b61d[_0x0a9e('0x46')]=qs[_0x0a9e('0x47')](_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x47')]);_0x11b61d[_0x0a9e('0x48')]=qs[_0x0a9e('0x49')](_[_0x0a9e('0x4a')](_0x4c1c0e[_0x0a9e('0x3f')],_0x40d766['filters']));var _0x117c99=[];var _0x138b8b=squel[_0x0a9e('0x4b')]()[_0x0a9e('0x4c')]('id')[_0x0a9e('0x4c')](_0x0a9e('0x29'))[_0x0a9e('0x4c')](_0x0a9e('0x4d'))['from'](_0x0a9e('0x4e'));var _0x48fd45=squel[_0x0a9e('0x4b')]()[_0x0a9e('0x4c')](_0x0a9e('0x4f'))['from'](_0x0a9e('0x50'),'me')[_0x0a9e('0x48')](_0x0a9e('0x51'))[_0x0a9e('0x48')](_0x0a9e('0x52'))[_0x0a9e('0x48')](_0x0a9e('0x53'));var _0x5bbcde=squel[_0x0a9e('0x4b')]()[_0x0a9e('0x4c')](_0x0a9e('0x54'))[_0x0a9e('0x4c')](_0x0a9e('0x55'))[_0x0a9e('0x56')](_0x0a9e('0x57'),'ui')[_0x0a9e('0x58')](_0x0a9e('0x59'),'u','u.id\x20=\x20ui.UserId');var _0xe401a=squel[_0x0a9e('0x4b')]()['from']('mail_interactions','i')['left_join'](_0x0a9e('0x5a'),'c',_0x0a9e('0x5b'))[_0x0a9e('0x58')](_0x0a9e('0x59'),'o',_0x0a9e('0x5c'))[_0x0a9e('0x58')](_0x0a9e('0x5d'),'a',_0x0a9e('0x5e'))['left_join']('mail_messages','me','me.MailInteractionId\x20=\x20i.id');var _0x39d77d=squel[_0x0a9e('0x5f')]();if(_0x4c1c0e[_0x0a9e('0x3f')]['advancedFilter']){var _0x5fd5db=JSON[_0x0a9e('0x60')](_0x4c1c0e['query']['advancedFilter']);_[_0x0a9e('0x3e')](_0x5fd5db)['forEach'](function(_0x443e72){var _0x4c3845=_0x5fd5db[_0x443e72];if(_0x443e72===_0x0a9e('0x61')){var _0x3c20b2=moment(_0x4c3845[_0x0a9e('0x62')]['dateStart'])[_0x0a9e('0x63')](_0x0a9e('0x64'))['utc']()['format']();var _0x128aa6=moment(_0x128aa6)[_0x0a9e('0x65')]()['endOf'](_0x0a9e('0x64'))['format']();_0x39d77d[_0x0a9e('0x66')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x3c20b2,_0x128aa6);}else{if(_[_0x0a9e('0x67')](_0x4c3845['condition'])){_0x4c3845['condition']['forEach'](function(_0x2da03c){switch(_0x4c3845['condition'][_0x0a9e('0x62')]){case'IS':if(_0x443e72!==_0x0a9e('0x68')&&_0x443e72!==_0x0a9e('0x69')){if(_[_0x0a9e('0x67')](_0x4c3845[_0x0a9e('0x62')])&&_0x4c3845[_0x0a9e('0x62')][_0x0a9e('0x43')]>0x1){_0x39d77d[_0x0a9e('0x66')](_0x4c3845['tableAlias']+'.'+_0x443e72+_0x0a9e('0x6a'),_0x4c3845[_0x0a9e('0x62')]);}else{_0x39d77d[_0x0a9e('0x66')](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+_0x0a9e('0x6c'),_0x4c3845[_0x0a9e('0x62')][0x0]);}}break;case'=':_0x39d77d['and'](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+_0x0a9e('0x6c'),_0x4c3845['value']);break;case _0x0a9e('0x6d'):if(_0x443e72==='ContactId'){_0x39d77d[_0x0a9e('0x66')]('c.firstName'+'\x20LIKE\x20?','%'+_0x4c3845['value']+'%');_0x39d77d['or'](_0x0a9e('0x6e')+'\x20LIKE\x20?','%'+_0x4c3845[_0x0a9e('0x62')]+'%');_0x39d77d['or'](_0x0a9e('0x6f')+_0x0a9e('0x70'),'%'+_0x4c3845[_0x0a9e('0x62')]+'%');}else{_0x39d77d[_0x0a9e('0x66')](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+'\x20LIKE\x20?','%'+_0x4c3845[_0x0a9e('0x62')]+'%');}break;case'>':_0x39d77d['and'](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+_0x0a9e('0x71'),_0x4c3845[_0x0a9e('0x62')]);break;case'<':_0x39d77d['and'](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+_0x0a9e('0x72'),_0x4c3845[_0x0a9e('0x62')]);break;}});}else{switch(_0x4c3845[_0x0a9e('0x73')]['value']){case'IS':if(_0x443e72!==_0x0a9e('0x68')&&_0x443e72!==_0x0a9e('0x69')){if(_['isArray'](_0x4c3845[_0x0a9e('0x62')])&&_0x4c3845[_0x0a9e('0x62')][_0x0a9e('0x43')]>0x1){_0x39d77d[_0x0a9e('0x66')](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+'\x20IN\x20?',_0x4c3845[_0x0a9e('0x62')]);}else{_0x39d77d[_0x0a9e('0x66')](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+'\x20=\x20?',_0x4c3845[_0x0a9e('0x62')][0x0]);}}break;case'=':_0x39d77d['and'](_0x4c3845['tableAlias']+'.'+_0x443e72+_0x0a9e('0x6c'),_0x4c3845[_0x0a9e('0x62')]);break;case _0x0a9e('0x6d'):if(_0x443e72===_0x0a9e('0x74')){_0x39d77d[_0x0a9e('0x66')](_0x0a9e('0x75')+_0x0a9e('0x70'),'%'+_0x4c3845[_0x0a9e('0x62')]+'%');_0x39d77d['or'](_0x0a9e('0x6e')+_0x0a9e('0x70'),'%'+_0x4c3845[_0x0a9e('0x62')]+'%');_0x39d77d['or'](_0x0a9e('0x6f')+_0x0a9e('0x70'),'%'+_0x4c3845[_0x0a9e('0x62')]+'%');}else{_0x39d77d[_0x0a9e('0x66')](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+_0x0a9e('0x70'),'%'+_0x4c3845[_0x0a9e('0x62')]+'%');}break;case'>':_0x39d77d['and'](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+_0x0a9e('0x71'),_0x4c3845[_0x0a9e('0x62')]);break;case'<':_0x39d77d['and'](_0x4c3845[_0x0a9e('0x6b')]+'.'+_0x443e72+_0x0a9e('0x72'),_0x4c3845['value']);break;}}}});}else{var _0x83f0b2=_(Object[_0x0a9e('0x3e')](_0x4c1c0e[_0x0a9e('0x3f')]))[_0x0a9e('0x2f')](function(_0x13b5c0){return _0x2b814e['hasOwnProperty'](_0x13b5c0)?_0x13b5c0:undefined;})['filter'](function(_0x4a2438){return!_[_0x0a9e('0x76')](_0x4a2438);})[_0x0a9e('0x62')]();if(!_[_0x0a9e('0x77')](_0x83f0b2)){_0x83f0b2[_0x0a9e('0x33')](function(_0x6abd03){if(_0x6abd03===_0x0a9e('0x78')){_0xe401a[_0x0a9e('0x48')](_0x0a9e('0x79'),[]['concat'](_0x4c1c0e[_0x0a9e('0x3f')][_0x6abd03]));}else if(_0x6abd03===_0x0a9e('0x61')){var _0x12ccdb=JSON['parse'](_0x4c1c0e[_0x0a9e('0x3f')][_0x6abd03])['$gte'];var _0x4437ff=JSON[_0x0a9e('0x60')](_0x4c1c0e['query'][_0x6abd03])[_0x0a9e('0x7a')];_0xe401a[_0x0a9e('0x48')](_0x0a9e('0x7b'),_0x12ccdb,_0x4437ff);}else{if(_0x4c1c0e[_0x0a9e('0x3f')][_0x6abd03]==='null'){_0xe401a[_0x0a9e('0x48')]('i.'+_0x6abd03+_0x0a9e('0x7c'));}else{_0xe401a[_0x0a9e('0x48')]('i.'+_0x6abd03+_0x0a9e('0x6c'),_0x4c1c0e['query'][_0x6abd03]);}}});}if(_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x7d')]){var _0x2d5506=_0x4c1c0e[_0x0a9e('0x3f')]['filter'][_0x0a9e('0x7e')]('\x5c','\x5c\x5c')[_0x0a9e('0x7e')]('\x27\x27',_0x0a9e('0x7f'));if(qs[_0x0a9e('0x80')](_0x2d5506)){_0x39d77d['or'](_0x0a9e('0x81'),_0x2d5506+'%');}else if(qs[_0x0a9e('0x82')](_0x2d5506)){_0x39d77d['or'](_0x0a9e('0x83'),_0x2d5506+'%');}else{var _0x3df0e3=[];_0x2d5506[_0x0a9e('0x32')]('\x20')[_0x0a9e('0x33')](function(_0xc4c230){_0x3df0e3[_0x0a9e('0x34')]('+'+_0xc4c230[_0x0a9e('0x84')]());});var _0xe0749e=_0x3df0e3['join']('\x20');_0x39d77d['or'](_0x0a9e('0x85'),_0xe0749e)['or'](_0x0a9e('0x86'),_0xe0749e);}}}_0xe401a[_0x0a9e('0x48')](_0x39d77d);if(_0x11b61d['order']){_0x11b61d[_0x0a9e('0x46')][_0x0a9e('0x33')](function(_0x8cea96){_0xe401a[_0x0a9e('0x46')]('i.'+_0x8cea96[0x0],_0x8cea96[0x1]==='DESC'?![]:!![]);});}_0xe401a['group'](_0x0a9e('0x87'));var _0x2bbdb5={'type':db['Sequelize'][_0x0a9e('0x88')]['SELECT'],'raw':!![]};var _0x260f4b=_0xe401a[_0x0a9e('0x89')]()['field'](_0x0a9e('0x4f'));if(!_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x8a')]){if(_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x8b')]){if(_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x8b')]==0x1){_0x260f4b['where'](util[_0x0a9e('0x8c')](_0x0a9e('0x8d'),_0x48fd45[_0x0a9e('0x84')]()));_0xe401a[_0x0a9e('0x8e')]('`Messages.count`\x20=\x200');}else{_0x260f4b[_0x0a9e('0x48')](util[_0x0a9e('0x8c')]('%s\x20>\x200',_0x48fd45[_0x0a9e('0x84')]()));_0xe401a['having'](_0x0a9e('0x8f'));}}if(_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x90')]){var _0x385d52=_['isArray'](_0x4c1c0e['query'][_0x0a9e('0x90')])?_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x90')]:new Array(_0x4c1c0e['query'][_0x0a9e('0x90')]);var _0x36e975=squel['expr']();_0x385d52['forEach'](function(_0xf0a802){_0x36e975['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0xf0a802+',%');});_0xe401a['having'](_0x36e975);_0x260f4b['left_join'](_0x0a9e('0x91'),'it',_0x0a9e('0x92'));_0x260f4b[_0x0a9e('0x58')](_0x0a9e('0x4e'),'t',_0x0a9e('0x93'));_0x260f4b[_0x0a9e('0x48')]('t.id\x20IN\x20?',_0x385d52);}}else{var _0x5fd5db=JSON['parse'](_0x4c1c0e[_0x0a9e('0x3f')][_0x0a9e('0x8a')]);_[_0x0a9e('0x3e')](_0x5fd5db)[_0x0a9e('0x33')](function(_0x50f8d7){var _0x46c9ac=_0x5fd5db[_0x50f8d7];if(_0x50f8d7===_0x0a9e('0x68')){var _0x1d4877=_0x46c9ac['value'];var _0xb6e411=squel[_0x0a9e('0x5f')]();_0x1d4877[_0x0a9e('0x33')](function(_0x22063c){_0xb6e411['or'](_0x0a9e('0x94'),'%,'+_0x22063c+',%');});_0xe401a[_0x0a9e('0x8e')](_0xb6e411);_0x260f4b[_0x0a9e('0x58')](_0x0a9e('0x91'),'it','it.MailInteractionId\x20=\x20i.id');_0x260f4b[_0x0a9e('0x58')](_0x0a9e('0x4e'),'t','t.id\x20=\x20it.TagId');_0x260f4b[_0x0a9e('0x48')](_0x0a9e('0x95'),_0x1d4877);}else if(_0x50f8d7===_0x0a9e('0x69')){if(_0x46c9ac['value'][_0x0a9e('0x43')]===0x1){if(_0x46c9ac['value'][0x0]===0x1){_0x260f4b[_0x0a9e('0x48')](util[_0x0a9e('0x8c')](_0x0a9e('0x8d'),_0x48fd45[_0x0a9e('0x84')]()));_0xe401a[_0x0a9e('0x8e')](_0x0a9e('0x96'));}else{_0x260f4b[_0x0a9e('0x48')](util[_0x0a9e('0x8c')]('%s\x20>\x200',_0x48fd45[_0x0a9e('0x84')]()));_0xe401a[_0x0a9e('0x8e')](_0x0a9e('0x8f'));}}}});}db[_0x0a9e('0x97')][_0x0a9e('0x3f')](_0x260f4b[_0x0a9e('0x84')](),_0x2bbdb5)[_0x0a9e('0x26')](function(_0x33f0c9){_0x5adda1[_0x0a9e('0x1e')]=_0x33f0c9[_0x0a9e('0x43')];if(_0x5adda1[_0x0a9e('0x1e')]===0x0)return[];return db[_0x0a9e('0x97')][_0x0a9e('0x3f')](_0x138b8b['toString'](),_0x2bbdb5)[_0x0a9e('0x26')](function(_0x23e2bd){_0x117c99=_[_0x0a9e('0x98')](_0x23e2bd,'id');_0x2bbdb5=_[_0x0a9e('0x99')](_0x2bbdb5,{'model':db[_0x0a9e('0x35')],'mapToModel':!![],'raw':!![],'nest':!![]});_0xe401a['field'](_0x0a9e('0x9a'),_0x0a9e('0x9b'));_0xe401a['field'](_0x0a9e('0x87'));_0xe401a['field'](_0x0a9e('0x9c'));_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0x9d'));_0xe401a[_0x0a9e('0x4c')]('i.closed');_0xe401a[_0x0a9e('0x4c')]('i.closedAt');_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0x9e'));_0xe401a['field'](_0x0a9e('0x9f'));_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0xa0'));_0xe401a['field']('i.subject');_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0xa1'));_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0xa2'));_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0xa3'));_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0xa4'));_0xe401a[_0x0a9e('0x4c')]('i.MailAccountId');_0xe401a[_0x0a9e('0x4c')]('i.UserId');_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0x75'),_0x0a9e('0xa5'));_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0x6e'),'Contact.lastName');_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0x6f'),_0x0a9e('0xa6'));_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0xa7'),'Contact.phone');_0xe401a['field'](_0x0a9e('0xa8'),'Contact.mobile');_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0xa9'),_0x0a9e('0xaa'));_0xe401a[_0x0a9e('0x4c')](_0x0a9e('0xab'),_0x0a9e('0x31'));_0xe401a['left_join']('mail_interaction_has_tags','it',_0x0a9e('0x92'));_0xe401a['left_join'](_0x0a9e('0x4e'),'t','t.id\x20=\x20it.TagId');_0xe401a[_0x0a9e('0x20')](_0x11b61d['limit']);_0xe401a['offset'](_0x11b61d[_0x0a9e('0x1f')]);return db[_0x0a9e('0x97')]['query'](_0xe401a[_0x0a9e('0x84')](),_0x2bbdb5);})[_0x0a9e('0x26')](function(_0x15c6b9){_0x5bbcde[_0x0a9e('0x48')](_0x0a9e('0xac'),_['map'](_0x15c6b9,'id'));return db['sequelize'][_0x0a9e('0x3f')](_0x5bbcde[_0x0a9e('0x84')](),_0x2bbdb5)[_0x0a9e('0x26')](function(_0x24beb6){var _0x59303b=_['groupBy'](_0x24beb6,_0x0a9e('0xad'));var _0xadce3d=[];return db['Setting'][_0x0a9e('0x36')]({'attributes':[_0x0a9e('0xae')],'raw':!![]})[_0x0a9e('0x26')](function(_0x2427d5){var _0x23b25b=_0x2427d5[_0x0a9e('0xae')];_0x15c6b9[_0x0a9e('0x33')](function(_0x476993){_0xadce3d[_0x0a9e('0x34')](updateMailInteraction(_0x476993,_0x117c99,_0x59303b,_0x23b25b));});return BPromise[_0x0a9e('0xaf')](_0xadce3d);});});});})['then'](function(_0x1065a7){_0x5adda1[_0x0a9e('0xb0')]=_0x1065a7;return _0x5adda1;})[_0x0a9e('0x26')](respondWithFilteredResult(_0x546ef8,_0x11b61d))[_0x0a9e('0x3a')](handleError(_0x546ef8,null));};exports[_0x0a9e('0xb1')]=function(_0x547e37,_0x500868){var _0x21902c={'raw':![],'where':{'id':_0x547e37[_0x0a9e('0xb2')]['id']}},_0x16ae1a={};_0x16ae1a[_0x0a9e('0x3d')]=_[_0x0a9e('0x3e')](db['MailInteraction'][_0x0a9e('0x3c')]);_0x16ae1a[_0x0a9e('0x3f')]=_[_0x0a9e('0x3e')](_0x547e37['query']);_0x16ae1a[_0x0a9e('0x49')]=_['intersection'](_0x16ae1a[_0x0a9e('0x3d')],_0x16ae1a['query']);_0x21902c[_0x0a9e('0x42')]=_[_0x0a9e('0x40')](_0x16ae1a[_0x0a9e('0x3d')],qs['fields'](_0x547e37[_0x0a9e('0x3f')]['fields']));_0x21902c[_0x0a9e('0x42')]=_0x21902c[_0x0a9e('0x42')][_0x0a9e('0x43')]?_0x21902c[_0x0a9e('0x42')]:_0x16ae1a[_0x0a9e('0x3d')];if(_0x547e37[_0x0a9e('0x3f')][_0x0a9e('0xb3')]){_0x21902c[_0x0a9e('0xb4')]=[{'all':!![]}];}_0x21902c=_[_0x0a9e('0x99')]({},_0x21902c,_0x547e37[_0x0a9e('0xb5')]);return db[_0x0a9e('0x35')][_0x0a9e('0xb6')](_0x21902c)[_0x0a9e('0x26')](handleEntityNotFound(_0x500868,null))[_0x0a9e('0x26')](respondWithResult(_0x500868,null))[_0x0a9e('0x3a')](handleError(_0x500868,null));};exports[_0x0a9e('0xb7')]=function(_0x5b93dd,_0x556443){return db[_0x0a9e('0x35')]['create'](_0x5b93dd[_0x0a9e('0xb8')],{})[_0x0a9e('0x26')](respondWithResult(_0x556443,0xc9))['catch'](handleError(_0x556443,null));};exports[_0x0a9e('0x25')]=function(_0xe2b083,_0x387bbe){if(_0xe2b083[_0x0a9e('0xb8')]['id']){delete _0xe2b083['body']['id'];}return db[_0x0a9e('0x35')][_0x0a9e('0xb6')]({'where':{'id':_0xe2b083[_0x0a9e('0xb2')]['id']}})[_0x0a9e('0x26')](handleEntityNotFound(_0x387bbe,null))['then'](saveUpdates(_0xe2b083[_0x0a9e('0xb8')],null))[_0x0a9e('0x26')](respondWithResult(_0x387bbe,null))[_0x0a9e('0x3a')](handleError(_0x387bbe,null));};exports['destroy']=function(_0x2650eb,_0x270df8){return db[_0x0a9e('0x35')]['find']({'where':{'id':_0x2650eb[_0x0a9e('0xb2')]['id']}})[_0x0a9e('0x26')](handleEntityNotFound(_0x270df8,null))[_0x0a9e('0x26')](removeEntity(_0x270df8,null))[_0x0a9e('0x3a')](handleError(_0x270df8,null));};exports[_0x0a9e('0xb9')]=function(_0x555780,_0x3211d2){return db[_0x0a9e('0x35')]['describe']()[_0x0a9e('0x26')](respondWithResult(_0x3211d2,null))[_0x0a9e('0x3a')](handleError(_0x3211d2,null));};exports[_0x0a9e('0xba')]=function(_0x5822a7,_0x5c3b6f,_0x523d08){return db[_0x0a9e('0x2d')][_0x0a9e('0xb6')]({'where':{'id':_0x5822a7['params']['id']}})[_0x0a9e('0x26')](handleEntityNotFound(_0x5c3b6f,null))[_0x0a9e('0x26')](function(_0x2a8d55){if(_0x2a8d55){return _0x2a8d55['addMessage'](_0x5822a7[_0x0a9e('0xb8')][_0x0a9e('0xbb')],_[_0x0a9e('0xbc')](_0x5822a7[_0x0a9e('0xb8')],[_0x0a9e('0xbb'),'id'])||{});}})[_0x0a9e('0x26')](respondWithResult(_0x5c3b6f,null))[_0x0a9e('0x3a')](handleError(_0x5c3b6f,null));};exports[_0x0a9e('0xbd')]=function(_0x3b5bda,_0x5a1848,_0x43c397){var _0x5526a7={'raw':![],'where':{}};var _0x138cf5={};var _0x4093e6={'count':0x0,'rows':[]};return db[_0x0a9e('0x35')][_0x0a9e('0x36')]({'where':{'id':_0x3b5bda[_0x0a9e('0xb2')]['id']}})[_0x0a9e('0x26')](handleEntityNotFound(_0x5a1848,null))['then'](function(_0x1a0314){if(_0x1a0314){_0x138cf5[_0x0a9e('0x3d')]=_[_0x0a9e('0x3e')](db[_0x0a9e('0x2d')]['rawAttributes']);_0x138cf5[_0x0a9e('0x3f')]=_[_0x0a9e('0x3e')](_0x3b5bda[_0x0a9e('0x3f')]);_0x138cf5[_0x0a9e('0x49')]=_[_0x0a9e('0x40')](_0x138cf5[_0x0a9e('0x3d')],_0x138cf5[_0x0a9e('0x3f')]);_0x5526a7[_0x0a9e('0x42')]=_[_0x0a9e('0x40')](_0x138cf5[_0x0a9e('0x3d')],qs['fields'](_0x3b5bda[_0x0a9e('0x3f')][_0x0a9e('0x41')]));_0x5526a7[_0x0a9e('0x42')]=_0x5526a7[_0x0a9e('0x42')][_0x0a9e('0x43')]?_0x5526a7[_0x0a9e('0x42')]:_0x138cf5[_0x0a9e('0x3d')];if(!_0x3b5bda[_0x0a9e('0x3f')]['hasOwnProperty'](_0x0a9e('0x45'))){_0x5526a7[_0x0a9e('0x20')]=qs[_0x0a9e('0x20')](_0x3b5bda['query'][_0x0a9e('0x20')]);_0x5526a7[_0x0a9e('0x1f')]=qs[_0x0a9e('0x1f')](_0x3b5bda[_0x0a9e('0x3f')][_0x0a9e('0x1f')]);}_0x5526a7[_0x0a9e('0x46')]=qs[_0x0a9e('0x47')](_0x3b5bda[_0x0a9e('0x3f')][_0x0a9e('0x47')]);_0x5526a7[_0x0a9e('0x48')]=qs['filters'](_[_0x0a9e('0x4a')](_0x3b5bda[_0x0a9e('0x3f')],_0x138cf5[_0x0a9e('0x49')]));_0x5526a7[_0x0a9e('0x48')][_0x0a9e('0xad')]=_0x1a0314['id'];if(_0x3b5bda[_0x0a9e('0x3f')]['filter']){_0x5526a7[_0x0a9e('0x48')]=_['merge'](_0x5526a7['where'],{'$or':_['map'](_0x5526a7[_0x0a9e('0x42')],function(_0x3fa3f2){var _0x426cb4={};_0x426cb4[_0x3fa3f2]={'$like':'%'+_0x3b5bda[_0x0a9e('0x3f')]['filter']+'%'};return _0x426cb4;})});}if(_0x3b5bda[_0x0a9e('0x3f')][_0x0a9e('0xbe')]){var _0x3ddbc7=_0x3b5bda[_0x0a9e('0x3f')][_0x0a9e('0xbe')]['split'](',');var _0x57b1b1={};_0x57b1b1[_0x3ddbc7[0x0]]={'$gte':moment(_0x3ddbc7[0x1])[_0x0a9e('0x8c')](_0x0a9e('0xbf'))};_0x5526a7[_0x0a9e('0x48')]=_['merge'](_0x5526a7[_0x0a9e('0x48')],_0x57b1b1);}_0x5526a7=_[_0x0a9e('0x99')]({},_0x5526a7,_0x3b5bda[_0x0a9e('0xb5')]);return db['MailMessage'][_0x0a9e('0x1e')]({'where':_0x5526a7[_0x0a9e('0x48')]})[_0x0a9e('0x26')](function(_0x4eda8f){_0x4093e6[_0x0a9e('0x1e')]=_0x4eda8f;if(_0x3b5bda[_0x0a9e('0x3f')][_0x0a9e('0xb3')]){_0x5526a7['include']=[{'all':!![]}];}return db['MailMessage']['findAll'](_0x5526a7);})[_0x0a9e('0x26')](function(_0x1f50db){_0x4093e6[_0x0a9e('0xb0')]=_0x1f50db;return _0x4093e6;});}})[_0x0a9e('0x26')](respondWithFilteredResult(_0x5a1848,_0x5526a7))['catch'](handleError(_0x5a1848,null));};exports[_0x0a9e('0xc0')]=function(_0x532424,_0x3b4af9,_0x2ff2ab){return db[_0x0a9e('0x35')]['find']({'where':{'id':_0x532424[_0x0a9e('0xb2')]['id']}})[_0x0a9e('0x26')](handleEntityNotFound(_0x3b4af9,null))[_0x0a9e('0x26')](function(_0x580dd6){if(_0x580dd6){return _0x580dd6[_0x0a9e('0xc1')](_0x532424['body'][_0x0a9e('0xbb')],_['omit'](_0x532424[_0x0a9e('0xb8')],['ids','id'])||{})[_0x0a9e('0xc2')](function(){return db[_0x0a9e('0xc3')][_0x0a9e('0xc4')]({'attributes':['id',_0x0a9e('0x29'),_0x0a9e('0x4d')],'where':{'id':_0x532424[_0x0a9e('0xb8')][_0x0a9e('0xbb')]}});})['then'](function(_0x35ace3){socket[_0x0a9e('0xc5')]('mailInteractionTags:save',{'id':Number(_0x532424[_0x0a9e('0xb2')]['id']),'tags':_0x35ace3||[]});return{'id':Number(_0x532424[_0x0a9e('0xb2')]['id']),'tags':_0x35ace3||[]};});}})['then'](respondWithResult(_0x3b4af9,null))[_0x0a9e('0x3a')](handleError(_0x3b4af9,null));};exports[_0x0a9e('0xc6')]=function(_0x16b578,_0x569528,_0x3766d7){return db[_0x0a9e('0x35')][_0x0a9e('0xb6')]({'where':{'id':_0x16b578[_0x0a9e('0xb2')]['id']}})[_0x0a9e('0x26')](handleEntityNotFound(_0x569528,null))[_0x0a9e('0x26')](function(_0x3ba897){if(_0x3ba897){return _0x3ba897[_0x0a9e('0xc6')](_0x16b578[_0x0a9e('0x3f')][_0x0a9e('0xbb')]);}})['then'](respondWithStatusCode(_0x569528,null))[_0x0a9e('0x3a')](handleError(_0x569528,null));};exports['download']=function(_0x3c9854,_0x2968e2){var _0x5b9c76=moment()[_0x0a9e('0xc7')]()[_0x0a9e('0x84')]();var _0x2d45db=path['join'](config[_0x0a9e('0xc8')],_0x0a9e('0xc9'),_0x0a9e('0xca'),'attachments');var _0x11e4e3=path[_0x0a9e('0xcb')](config[_0x0a9e('0xc8')],_0x0a9e('0xc9'),_0x0a9e('0xca'),_0x0a9e('0xcc'));var _0x1e93f5=path['join'](_0x11e4e3,_0x5b9c76);var _0x4e1b3=util[_0x0a9e('0x8c')](_0x0a9e('0xcd'),_0x5b9c76);var _0x2ce3be=path[_0x0a9e('0xcb')](_0x11e4e3,_0x4e1b3);var _0x241404=![];return db[_0x0a9e('0x35')]['find']({'where':{'id':_0x3c9854['params']['id']}})[_0x0a9e('0x26')](handleEntityNotFound(_0x2968e2,null))[_0x0a9e('0x26')](function(_0x1f4929){if(_0x1f4929){return _0x1f4929[_0x0a9e('0xbd')]({'attributes':['id',_0x0a9e('0xb8'),_0x0a9e('0x56'),'to','cc',_0x0a9e('0xce'),'subject',_0x0a9e('0x61')],'where':{'secret':![]},'include':_0x3c9854[_0x0a9e('0x3f')][_0x0a9e('0xcf')]?[{'model':db[_0x0a9e('0xd0')],'as':_0x0a9e('0xd1')}]:undefined,'order':qs[_0x0a9e('0x47')]('id')});}return[];})[_0x0a9e('0x26')](function(_0x54f0b8){_0x241404=_0x54f0b8[_0x0a9e('0x43')];if(_0x54f0b8[_0x0a9e('0x43')]){fs[_0x0a9e('0xd2')](_0x1e93f5);return BPromise['each'](_0x54f0b8,function(_0x2b8ad4,_0x387817){var _0x2030cf=_0x2b8ad4;var _0x292f02={'from':_0x2030cf['from'],'to':_0x2030cf['to'],'subject':_0x2030cf[_0x0a9e('0xd3')],'html':_0x2030cf[_0x0a9e('0xb8')],'headers':{'Date':moment(_0x2030cf[_0x0a9e('0x61')])[_0x0a9e('0x8c')](_0x0a9e('0xd4'))},'attachments':[]};if(_0x2b8ad4['cc']){_0x292f02[_0x0a9e('0xd5')]['Cc']=_0x2b8ad4['cc'];}if(_0x2b8ad4[_0x0a9e('0xce')]){_0x292f02[_0x0a9e('0xd5')]['Bcc']=_0x2b8ad4[_0x0a9e('0xce')];}return new BPromise(function(_0x266aa1,_0x25e41f){if(_0x2b8ad4[_0x0a9e('0xd1')]){for(var _0x5f4c6f=0x0;_0x5f4c6f<_0x2b8ad4['Attachments'][_0x0a9e('0x43')];_0x5f4c6f++){var _0x2abe55=_0x2b8ad4[_0x0a9e('0xd1')][_0x5f4c6f];var _0x596ba3=path[_0x0a9e('0xcb')](_0x2d45db,_0x2abe55[_0x0a9e('0xd6')]);if(fs['existsSync'](_0x596ba3)){_0x292f02[_0x0a9e('0xcf')]['push']({'name':_0x2abe55[_0x0a9e('0x29')],'contentType':_0x2abe55['type'],'data':fs['readFileSync'](_0x596ba3)});}}}emlformat['build'](_0x292f02,function(_0xad4d10,_0x4297d1){if(_0xad4d10)return _0x25e41f(_0xad4d10);fs[_0x0a9e('0xd7')](path[_0x0a9e('0xcb')](_0x1e93f5,util[_0x0a9e('0x8c')](_0x0a9e('0xd8'),_0x387817)),_0x4297d1);return _0x266aa1(_0x4297d1);});});});}})['then'](function(){if(_0x241404){return new BPromise(function(_0x5fb7ce,_0x213e5f){zipdir(_0x1e93f5,{'saveTo':_0x2ce3be},function(_0x1713a7,_0xd18f82){if(_0x1713a7)return _0x213e5f(_0x1713a7);return _0x5fb7ce(_0xd18f82);});});}})[_0x0a9e('0x26')](function(){if(_0x241404){return new BPromise(function(_0x18dccf,_0x31c937){rimraf(_0x1e93f5,function(_0x5312fa){if(_0x5312fa)_0x31c937(_0x5312fa);return _0x18dccf();});});}})['then'](function(){if(_0x241404){return _0x2968e2[_0x0a9e('0xd9')](_0x2ce3be,_0x4e1b3,function(_0x5b6edc){if(_0x5b6edc){console[_0x0a9e('0xda')](_0x0a9e('0xdb'),_0x5b6edc);}else{fs[_0x0a9e('0xdc')](_0x2ce3be);}});}else{return _0x2968e2[_0x0a9e('0x1a')](0xc8);}})[_0x0a9e('0x3a')](handleError(_0x2968e2,null));};
git://repos.xcallymotion.com / motion2.git / blob