18 var _0x7c4d=['unreadMessages','a.key','Account.key','a.mandatoryDisposition','CASE\x20WHEN\x20i.from\x20IS\x20NOT\x20NULL\x20AND\x20i.from\x20<>\x20\x27\x27\x20THEN\x20i.from\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','Contact.firstName','c.phone','Contact.phone','Contact.mobile','c.fax','Owner.fullname','o.internal','Owner.internal','ui.OpenchannelInteractionId\x20IN\x20?','groupBy','OpenchannelInteractionId','all','show','params','includeAll','options','create','addMessage','OpenchannelMessage','ids','omit','getMessages','findOne','format','YYYY-MM-DD\x20HH:mm:ss','include','findAll','setTags','spread','Tag','emit','openchannelInteractionTags:save','removeTags','download','unix','root','server','files','join','CmContact','Contact','firstName','lastName','attachments','Attachment','Messages','OpenchannelAccount','Account','Owner','get','Openchannel','N.A.','threadId','Public','Private','basename','existsSync','createReadStream','pipe','createWriteStream','out','System','direction','renderFile','views','downloadInteraction.ejs','transcript-','.pdf','createPdfFromHTML','err','unlinkSync','sendStatus','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','util','path','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../components/export/pdf','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./openchannelInteraction.socket','register','status','end','json','count','offset','limit','set','Content-Range','reject','update','destroy','stack','name','Users','map','fullname','Tags','split','forEach','push','TagIds','then','catch','waiting','answered','unmanaged','total','closed','UserId','talking','index','OpenchannelInteraction','rawAttributes','type','filters','intersection','query','attributes','model','length','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','from','tools_tags','u.id','u.fullname','ui.OpenchannelInteractionId','users','u.id\x20=\x20ui.UserId','openchannel_interactions','left_join','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','openchannel_accounts','a.id\x20=\x20i.OpenchannelAccountId','me.OpenchannelInteractionId\x20=\x20i.id','openchannel_interaction_has_tags','it.OpenchannelInteractionId\x20=\x20i.id','expr','search','parseSearch','sqlOperator','find','value','`\x20=\x200','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','text','start','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','body','keys','some','compact','OpenchannelAccountId','i.OpenchannelAccountId\x20IN\x20?','createdAt','$gte','parse','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','read','having','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','isArray','tag','filter','replace','isNumeric','i.id\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','i.from\x20LIKE\x20?','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','group','i.id','SELECT','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','DESC','isEmpty','t.id\x20IN\x20?','resolve','i.OpenchannelAccountId\x20IS\x20NOT\x20NULL','user','role','getOpenchannelAccounts','i.OpenchannelAccountId\x20IS\x20NULL','sequelize','toString','merge','fields'];(function(_0x181707,_0x47d753){var _0x1d2b7a=function(_0x508991){while(--_0x508991){_0x181707['push'](_0x181707['shift']());}};_0x1d2b7a(++_0x47d753);}(_0x7c4d,0x13a));var _0xd7c4=function(_0x2a54a2,_0x520dd2){_0x2a54a2=_0x2a54a2-0x0;var _0x1e6da7=_0x7c4d[_0x2a54a2];return _0x1e6da7;};'use strict';var emlformat=require(_0xd7c4('0x0'));var rimraf=require(_0xd7c4('0x1'));var zipdir=require(_0xd7c4('0x2'));var jsonpatch=require(_0xd7c4('0x3'));var rp=require('request-promise');var moment=require(_0xd7c4('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xd7c4('0x5'));var util=require(_0xd7c4('0x6'));var path=require(_0xd7c4('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xd7c4('0x8'));var fs=require('fs');var fs_extra=require(_0xd7c4('0x9'));var _=require(_0xd7c4('0xa'));var squel=require(_0xd7c4('0xb'));var crypto=require(_0xd7c4('0xc'));var jsforce=require(_0xd7c4('0xd'));var deskjs=require(_0xd7c4('0xe'));var toCsv=require('to-csv');var querystring=require(_0xd7c4('0xf'));var Papa=require(_0xd7c4('0x10'));var Redis=require('ioredis');var authService=require(_0xd7c4('0x11'));var qs=require(_0xd7c4('0x12'));var as=require(_0xd7c4('0x13'));var pdf=require(_0xd7c4('0x14'));var hardwareService=require(_0xd7c4('0x15'));var logger=require(_0xd7c4('0x16'))(_0xd7c4('0x17'));var utils=require(_0xd7c4('0x18'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xd7c4('0x19'))['db'];config[_0xd7c4('0x1a')]=_[_0xd7c4('0x1b')](config[_0xd7c4('0x1a')],{'host':_0xd7c4('0x1c'),'port':0x18eb});var socket=require(_0xd7c4('0x1d'))(new Redis(config[_0xd7c4('0x1a')]));require(_0xd7c4('0x1e'))[_0xd7c4('0x1f')](socket);function respondWithStatusCode(_0x4f3240,_0x2f33e1){_0x2f33e1=_0x2f33e1||0xcc;return function(_0x2cfe17){if(_0x2cfe17){return _0x4f3240['sendStatus'](_0x2f33e1);}return _0x4f3240[_0xd7c4('0x20')](_0x2f33e1)[_0xd7c4('0x21')]();};}function respondWithResult(_0x419c9b,_0x16b505){_0x16b505=_0x16b505||0xc8;return function(_0x57a7c4){if(_0x57a7c4){return _0x419c9b[_0xd7c4('0x20')](_0x16b505)[_0xd7c4('0x22')](_0x57a7c4);}};}function respondWithFilteredResult(_0x396fc1,_0x4d3bbc){return function(_0x43929d){if(_0x43929d){var _0x4803d9=typeof _0x4d3bbc['offset']==='undefined'&&typeof _0x4d3bbc['limit']==='undefined';var _0x6dc651=_0x43929d[_0xd7c4('0x23')];var _0x546260=_0x4803d9?0x0:_0x4d3bbc[_0xd7c4('0x24')];var _0x3e941b=_0x4803d9?_0x43929d['count']:_0x4d3bbc[_0xd7c4('0x24')]+_0x4d3bbc[_0xd7c4('0x25')];var _0x5033a7;if(_0x3e941b>=_0x6dc651){_0x3e941b=_0x6dc651;_0x5033a7=0xc8;}else{_0x5033a7=0xce;}_0x396fc1[_0xd7c4('0x20')](_0x5033a7);return _0x396fc1[_0xd7c4('0x26')](_0xd7c4('0x27'),_0x546260+'-'+_0x3e941b+'/'+_0x6dc651)[_0xd7c4('0x22')](_0x43929d);}return null;};}function patchUpdates(_0x3a4a89){return function(_0x276425){try{jsonpatch['apply'](_0x276425,_0x3a4a89,!![]);}catch(_0xb65da3){return BPromise[_0xd7c4('0x28')](_0xb65da3);}return _0x276425['save']();};}function saveUpdates(_0x314953,_0x286edc){return function(_0x8bfce9){if(_0x8bfce9){return _0x8bfce9[_0xd7c4('0x29')](_0x314953)['then'](function(_0x369981){return _0x369981;});}return null;};}function removeEntity(_0x4d7acd,_0x20eaa7){return function(_0x3d1754){if(_0x3d1754){return _0x3d1754[_0xd7c4('0x2a')]()['then'](function(){_0x4d7acd[_0xd7c4('0x20')](0xcc)[_0xd7c4('0x21')]();});}};}function handleEntityNotFound(_0x3210e6,_0x2ba4f8){return function(_0x4eb8fd){if(!_0x4eb8fd){_0x3210e6['sendStatus'](0x194);}return _0x4eb8fd;};}function handleError(_0x372d7d,_0x3bbbcb){_0x3bbbcb=_0x3bbbcb||0x1f4;return function(_0xeeb865){logger['error'](_0xeeb865[_0xd7c4('0x2b')]);if(_0xeeb865[_0xd7c4('0x2c')]){delete _0xeeb865[_0xd7c4('0x2c')];}_0x372d7d[_0xd7c4('0x20')](_0x3bbbcb)['send'](_0xeeb865);};}function getInteractionUsers(_0x44c39d,_0x142205){return new BPromise(function(_0x11782a,_0x3308ad){try{if(_0x142205[_0x44c39d['id']]){_0x44c39d[_0xd7c4('0x2d')]=_[_0xd7c4('0x2e')](_0x142205[_0x44c39d['id']],function(_0x171c0c){return{'id':_0x171c0c['id'],'fullname':_0x171c0c[_0xd7c4('0x2f')]};});}}catch(_0x3498b8){_0x3308ad(_0x3498b8);}_0x11782a(_0x44c39d);});}function getInteractionTags(_0x25e928,_0x32e97b){return new BPromise(function(_0xec2321,_0x379394){try{if(_0x25e928['TagIds']){_0x25e928[_0xd7c4('0x30')]=[];_0x25e928['TagIds'][_0xd7c4('0x31')](',')[_0xd7c4('0x32')](function(_0x4f824f){_0x25e928['Tags'][_0xd7c4('0x33')](_0x32e97b[_0x4f824f]);});}delete _0x25e928[_0xd7c4('0x34')];}catch(_0x470f73){_0x379394(_0x470f73);}_0xec2321(_0x25e928);});}function updateOpenchannelInteraction(_0x3df5db,_0xc2b6b2,_0x2a09ae){return new BPromise(function(_0x555359,_0x3d8a73){return getInteractionUsers(_0x3df5db,_0x2a09ae)[_0xd7c4('0x35')](function(_0x5b0eca){return getInteractionTags(_0x5b0eca,_0xc2b6b2);})['then'](function(_0x4e5eb1){return getStateInteraction(_0x4e5eb1);})[_0xd7c4('0x35')](function(_0x2fd663){_0x555359(_0x2fd663);})[_0xd7c4('0x36')](function(_0x31854c){_0x3d8a73(_0x31854c);});});}function getStateInteraction(_0x415543){return new BPromise(function(_0x4f0ccc){_0x415543[_0xd7c4('0x37')]=0x0;_0x415543['talking']=0x0;_0x415543[_0xd7c4('0x38')]=0x0;_0x415543[_0xd7c4('0x39')]=0x0;_0x415543[_0xd7c4('0x3a')]=0x0;if(!_0x415543['closed']&&!_0x415543['UserId']){_0x415543[_0xd7c4('0x37')]+=0x1;}if(!_0x415543[_0xd7c4('0x3b')]&&_0x415543[_0xd7c4('0x3c')]){_0x415543['talking']+=0x1;if(_0x415543['waiting']){_0x415543[_0xd7c4('0x37')]-=0x1;}}if(_0x415543[_0xd7c4('0x3b')]&&_0x415543['UserId']){_0x415543[_0xd7c4('0x38')]+=0x1;if(_0x415543[_0xd7c4('0x3d')]){_0x415543[_0xd7c4('0x3d')]-=0x1;}}if(_0x415543['closed']&&!_0x415543[_0xd7c4('0x3c')]){_0x415543[_0xd7c4('0x39')]+=0x1;if(_0x415543[_0xd7c4('0x37')]){_0x415543['waiting']-=0x1;}}_0x415543[_0xd7c4('0x3a')]+=0x1;_0x4f0ccc(_0x415543);});}exports[_0xd7c4('0x3e')]=function(_0x12cb71,_0x3f4f12){var _0x15dd4a={},_0x560288={},_0x3f7668={'count':0x0,'rows':[]};var _0x259e72=_[_0xd7c4('0x2e')](db[_0xd7c4('0x3f')][_0xd7c4('0x40')],function(_0x5cb8e7){return{'name':_0x5cb8e7['fieldName'],'type':_0x5cb8e7[_0xd7c4('0x41')]['key']};});_0x560288['model']=_[_0xd7c4('0x2e')](_0x259e72,_0xd7c4('0x2c'));_0x560288['query']=_['keys'](_0x12cb71['query']);_0x560288[_0xd7c4('0x42')]=_[_0xd7c4('0x43')](_0x560288['model'],_0x560288[_0xd7c4('0x44')]);_0x15dd4a[_0xd7c4('0x45')]=_['intersection'](_0x560288[_0xd7c4('0x46')],qs['fields'](_0x12cb71[_0xd7c4('0x44')]['fields']));_0x15dd4a['attributes']=_0x15dd4a[_0xd7c4('0x45')][_0xd7c4('0x47')]?_0x15dd4a['attributes']:_0x560288['model'];if(!_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x48')](_0xd7c4('0x49'))){_0x15dd4a[_0xd7c4('0x25')]=qs['limit'](_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x25')]);_0x15dd4a[_0xd7c4('0x24')]=qs['offset'](_0x12cb71['query'][_0xd7c4('0x24')]);}_0x15dd4a[_0xd7c4('0x4a')]=qs[_0xd7c4('0x4b')](_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x4b')]);_0x15dd4a[_0xd7c4('0x4c')]=qs[_0xd7c4('0x42')](_[_0xd7c4('0x4d')](_0x12cb71['query'],_0x560288[_0xd7c4('0x42')]),_0x259e72);var _0x3b59cf=[];var _0x4fa7f9=squel[_0xd7c4('0x4e')]()[_0xd7c4('0x4f')]('id')['field'](_0xd7c4('0x2c'))[_0xd7c4('0x4f')](_0xd7c4('0x50'))[_0xd7c4('0x51')](_0xd7c4('0x52'));var _0x20fc3b=squel['select']()[_0xd7c4('0x4f')](_0xd7c4('0x53'))['field'](_0xd7c4('0x54'))[_0xd7c4('0x4f')](_0xd7c4('0x55'))[_0xd7c4('0x51')]('user_has_openchannel_interactions','ui')['left_join'](_0xd7c4('0x56'),'u',_0xd7c4('0x57'));var _0x4def8d=squel[_0xd7c4('0x4e')]()[_0xd7c4('0x51')](_0xd7c4('0x58'),'i')[_0xd7c4('0x59')]('cm_contacts','c',_0xd7c4('0x5a'))['left_join'](_0xd7c4('0x56'),'o',_0xd7c4('0x5b'))[_0xd7c4('0x59')](_0xd7c4('0x5c'),'a',_0xd7c4('0x5d'))['left_join']('openchannel_messages','me',_0xd7c4('0x5e'))[_0xd7c4('0x59')](_0xd7c4('0x5f'),'it',_0xd7c4('0x60'))[_0xd7c4('0x59')](_0xd7c4('0x52'),'t','t.id\x20=\x20it.TagId');var _0xf77909=squel['expr']();var _0x3e7c2f=[];var _0x588c23=squel[_0xd7c4('0x61')]();var _0x448a36;if(_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x62')]){_0x448a36=as[_0xd7c4('0x63')](_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x62')]);var _0x325ddc=_0x448a36[_0xd7c4('0x64')];for(var _0x3477d8=0x0;_0x3477d8<_0x448a36['conditions']['length'];_0x3477d8++){var _0x463d82=_0x448a36['conditions'][_0x3477d8];var _0x3f291a='i';var _0x2c3b1e=_[_0xd7c4('0x65')](_0x259e72,[_0xd7c4('0x2c'),_0x463d82[_0xd7c4('0x4f')]]);if(!_0x2c3b1e){switch(_0x463d82[_0xd7c4('0x4f')]){case'unreadMessages':if(_0x463d82[_0xd7c4('0x66')]==0x1){_0x4def8d['having']('`'+_0x463d82[_0xd7c4('0x4f')]+_0xd7c4('0x67'));}else{_0x4def8d['having']('`'+_0x463d82[_0xd7c4('0x4f')]+'`\x20>\x200');}break;case'Contact':if(_0x463d82['operator']===_0xd7c4('0x68')){if(_0x463d82[_0xd7c4('0x66')][_0xd7c4('0x31')]('\x20')['length']>0x1){_0xf77909[_0x325ddc](_0xd7c4('0x69'),qs['getFullTextValue'](_0x463d82[_0xd7c4('0x66')]),null);}else{var _0xd771a7='%'+_0x463d82[_0xd7c4('0x66')]+'%';_0xf77909[_0x325ddc](_0xd7c4('0x6a'),_0xd771a7,_0xd771a7,_0xd771a7);}}else{_0x2c3b1e=_[_0xd7c4('0x65')](_0x259e72,[_0xd7c4('0x2c'),_0xd7c4('0x6b')]);_0x463d82[_0xd7c4('0x4f')]=_0xd7c4('0x6b');_0x47458d=as[_0xd7c4('0x6c')](_0x3f291a,_0x2c3b1e[_0xd7c4('0x41')],_0x463d82);_0xf77909[_0x325ddc](_0x47458d[_0xd7c4('0x6d')],_0x47458d[_0xd7c4('0x66')][_0xd7c4('0x6e')],_0x47458d[_0xd7c4('0x66')][_0xd7c4('0x21')]);}break;case'Tag':var _0x3cbaef=_0x463d82[_0xd7c4('0x66')]['split'](',')[_0xd7c4('0x2e')](function(_0x2088aa){return Number(_0x2088aa);});_0x3cbaef[_0xd7c4('0x32')](function(_0x2d51c1){_0x588c23['or'](_0xd7c4('0x6f'),'%,'+_0x2d51c1+',%');});_0x3e7c2f=_[_0xd7c4('0x70')](_0x3e7c2f,_0x3cbaef);break;case _0xd7c4('0x71'):if(_0x463d82['operator']===_0xd7c4('0x68')){_0xf77909[_0x325ddc](_0xd7c4('0x72'),'%'+_0x463d82[_0xd7c4('0x66')]+'%',null);}else{_0x2c3b1e=_[_0xd7c4('0x65')](_0x259e72,['name',_0xd7c4('0x3c')]);_0x463d82[_0xd7c4('0x4f')]=_0xd7c4('0x3c');_0x47458d=as[_0xd7c4('0x6c')](_0x3f291a,_0x2c3b1e[_0xd7c4('0x41')],_0x463d82);_0xf77909[_0x325ddc](_0x47458d[_0xd7c4('0x6d')],_0x47458d[_0xd7c4('0x66')]['start'],_0x47458d[_0xd7c4('0x66')][_0xd7c4('0x21')]);}break;case _0xd7c4('0x73'):_0x47458d=as[_0xd7c4('0x6c')]('me',null,_0x463d82);_0xf77909[_0x325ddc](_0x47458d[_0xd7c4('0x6d')],_0x47458d[_0xd7c4('0x66')]['start'],_0x47458d['value'][_0xd7c4('0x21')]);break;}}else{var _0x47458d=as[_0xd7c4('0x6c')](_0x3f291a,_0x2c3b1e[_0xd7c4('0x41')],_0x463d82);_0xf77909[_0x325ddc](_0x47458d[_0xd7c4('0x6d')],_0x47458d['value'][_0xd7c4('0x6e')],_0x47458d[_0xd7c4('0x66')]['end']);}}}else{var _0x2a9ed7=_(_0x12cb71[_0xd7c4('0x44')])[_0xd7c4('0x74')]()['map'](function(_0x521da1){return _[_0xd7c4('0x75')](_0x259e72,[_0xd7c4('0x2c'),_0x521da1])?_0x521da1:undefined;})[_0xd7c4('0x76')]()[_0xd7c4('0x66')]();if(!_['isEmpty'](_0x2a9ed7)){_0x2a9ed7[_0xd7c4('0x32')](function(_0x1e6128){if(_0x1e6128===_0xd7c4('0x77')){_0x4def8d[_0xd7c4('0x4c')](_0xd7c4('0x78'),[]['concat'](_0x12cb71[_0xd7c4('0x44')][_0x1e6128]));}else if(_0x1e6128===_0xd7c4('0x79')){var _0xe0fc42=JSON['parse'](_0x12cb71[_0xd7c4('0x44')][_0x1e6128])[_0xd7c4('0x7a')];var _0x386c4c=JSON[_0xd7c4('0x7b')](_0x12cb71[_0xd7c4('0x44')][_0x1e6128])['$lte'];_0x4def8d['where'](_0xd7c4('0x7c'),_0xe0fc42,_0x386c4c);}else{if(_0x12cb71[_0xd7c4('0x44')][_0x1e6128]===_0xd7c4('0x7d')){_0x4def8d[_0xd7c4('0x4c')]('i.'+_0x1e6128+_0xd7c4('0x7e'));}else{_0x4def8d[_0xd7c4('0x4c')]('i.'+_0x1e6128+'\x20=\x20?',_0x12cb71['query'][_0x1e6128]);}}});}if(_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x7f')]){if(_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x7f')]==0x1){_0x4def8d[_0xd7c4('0x80')](_0xd7c4('0x81'));}else{_0x4def8d[_0xd7c4('0x80')](_0xd7c4('0x82'));}}if(_0x12cb71[_0xd7c4('0x44')]['tag']){_0x3e7c2f=_[_0xd7c4('0x83')](_0x12cb71['query']['tag'])?_0x12cb71['query']['tag']:new Array(_0x12cb71['query'][_0xd7c4('0x84')]);_0x3e7c2f[_0xd7c4('0x32')](function(_0x3f2d5e){_0x588c23['or'](_0xd7c4('0x6f'),'%,'+_0x3f2d5e+',%');});}if(_0x12cb71[_0xd7c4('0x44')]['filter']){var _0x2316b4=_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x85')][_0xd7c4('0x86')]('\x5c','\x5c\x5c')[_0xd7c4('0x86')](/'/g,'\x27\x27');if(qs[_0xd7c4('0x87')](_0x2316b4)){_0xf77909['or'](_0xd7c4('0x88'),_0x2316b4+'%');}else{_0xf77909['or'](_0xd7c4('0x89'),qs[_0xd7c4('0x8a')](_0x2316b4))['or'](_0xd7c4('0x8b'),_0x2316b4+'%')['or'](_0xd7c4('0x8c'),_0x2316b4+'%');}}}_0x4def8d[_0xd7c4('0x4c')](_0xf77909);_0x4def8d[_0xd7c4('0x8d')](_0xd7c4('0x8e'));var _0x382268={'type':db['Sequelize']['QueryTypes'][_0xd7c4('0x8f')],'raw':!![]};var _0x468464=_0x4def8d['clone']();_0x468464[_0xd7c4('0x4f')](_0xd7c4('0x8e'));_0x468464[_0xd7c4('0x4f')](_0xd7c4('0x90'),'unreadMessages');if(_0x15dd4a['order']){_0x15dd4a[_0xd7c4('0x4a')][_0xd7c4('0x32')](function(_0x51f489){var _0x2cb685=_0x51f489[0x0]==='contactName'?_0x51f489[0x0]:'i.'+_0x51f489[0x0];_0x4def8d[_0xd7c4('0x4a')](_0x2cb685,_0x51f489[0x1]===_0xd7c4('0x91')?![]:!![]);});}if(!_[_0xd7c4('0x92')](_0x3e7c2f)){_0x4def8d[_0xd7c4('0x80')](_0x588c23);_0x468464['where'](_0xd7c4('0x93'),_0x3e7c2f);}BPromise[_0xd7c4('0x94')]()[_0xd7c4('0x35')](function(){if(!_0x448a36){if(_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x77')])return;_0x468464[_0xd7c4('0x4c')](_0xd7c4('0x95'));_0x4def8d[_0xd7c4('0x4c')]('i.OpenchannelAccountId\x20IS\x20NOT\x20NULL');return;}if(_0x12cb71[_0xd7c4('0x96')][_0xd7c4('0x97')]!=='agent')return;return _0x12cb71[_0xd7c4('0x96')][_0xd7c4('0x98')]({'attributes':['id'],'raw':!![]})[_0xd7c4('0x35')](function(_0x4912c5){if(_[_0xd7c4('0x92')](_0x4912c5)){_0x468464[_0xd7c4('0x4c')](_0xd7c4('0x99'));_0x4def8d[_0xd7c4('0x4c')](_0xd7c4('0x99'));}else{_0x468464['where'](_0xd7c4('0x78'),_[_0xd7c4('0x2e')](_0x4912c5,'id'));_0x4def8d['where']('i.OpenchannelAccountId\x20IN\x20?',_[_0xd7c4('0x2e')](_0x4912c5,'id'));}});})[_0xd7c4('0x35')](function(){if(_0x12cb71[_0xd7c4('0x96')][_0xd7c4('0x97')]==='agent'&&!_0x448a36&&!_0x12cb71['query']['OpenchannelAccountId'])return[];return db[_0xd7c4('0x9a')][_0xd7c4('0x44')](_0x468464[_0xd7c4('0x9b')](),_0x382268);})[_0xd7c4('0x35')](function(_0x2e2fb4){_0x3f7668['count']=_0x2e2fb4[_0xd7c4('0x47')];if(_0x3f7668[_0xd7c4('0x23')]===0x0)return[];return db[_0xd7c4('0x9a')][_0xd7c4('0x44')](_0x4fa7f9[_0xd7c4('0x9b')](),_0x382268)[_0xd7c4('0x35')](function(_0x445836){_0x3b59cf=_['keyBy'](_0x445836,'id');_0x382268=_[_0xd7c4('0x9c')](_0x382268,{'model':db[_0xd7c4('0x3f')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x12cb71[_0xd7c4('0x44')][_0xd7c4('0x9d')]){_0x15dd4a[_0xd7c4('0x45')][_0xd7c4('0x32')](function(_0x2c10ea){_0x4def8d[_0xd7c4('0x4f')]('i.'+_0x2c10ea);});}else{_0x4def8d[_0xd7c4('0x4f')](_0xd7c4('0x90'),_0xd7c4('0x9e'));_0x4def8d[_0xd7c4('0x4f')](_0xd7c4('0x9f'),_0xd7c4('0xa0'));_0x4def8d[_0xd7c4('0x4f')](_0xd7c4('0xa1'),'Account.mandatoryDisposition');_0x4def8d[_0xd7c4('0x4f')](_0xd7c4('0xa2'),_0xd7c4('0xa3'));_0x4def8d[_0xd7c4('0x4f')]('i.*');_0x4def8d[_0xd7c4('0x4f')]('c.firstName',_0xd7c4('0xa4'));_0x4def8d['field']('c.lastName','Contact.lastName');_0x4def8d[_0xd7c4('0x4f')]('c.email','Contact.email');_0x4def8d['field'](_0xd7c4('0xa5'),_0xd7c4('0xa6'));_0x4def8d[_0xd7c4('0x4f')]('c.mobile',_0xd7c4('0xa7'));_0x4def8d[_0xd7c4('0x4f')](_0xd7c4('0xa8'),'Contact.fax');_0x4def8d[_0xd7c4('0x4f')]('o.fullname',_0xd7c4('0xa9'));_0x4def8d[_0xd7c4('0x4f')](_0xd7c4('0xaa'),_0xd7c4('0xab'));_0x4def8d[_0xd7c4('0x4f')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x15dd4a[_0xd7c4('0x25')])_0x4def8d[_0xd7c4('0x25')](_0x15dd4a[_0xd7c4('0x25')]);if(_0x15dd4a[_0xd7c4('0x24')])_0x4def8d[_0xd7c4('0x24')](_0x15dd4a['offset']);return db[_0xd7c4('0x9a')][_0xd7c4('0x44')](_0x4def8d['toString'](),_0x382268);})[_0xd7c4('0x35')](function(_0x48c205){if(_0x48c205['length']>0x0)_0x20fc3b[_0xd7c4('0x4c')](_0xd7c4('0xac'),_[_0xd7c4('0x2e')](_0x48c205,'id'));return db[_0xd7c4('0x9a')]['query'](_0x20fc3b[_0xd7c4('0x9b')](),_0x382268)[_0xd7c4('0x35')](function(_0x59ead6){var _0x40f808=_[_0xd7c4('0xad')](_0x59ead6,_0xd7c4('0xae'));var _0x3fd45b=[];_0x48c205[_0xd7c4('0x32')](function(_0x2d35d0){_0x3fd45b[_0xd7c4('0x33')](updateOpenchannelInteraction(_0x2d35d0,_0x3b59cf,_0x40f808));});return BPromise[_0xd7c4('0xaf')](_0x3fd45b);});});})['then'](function(_0x38f22c){_0x3f7668['rows']=_0x38f22c;return _0x3f7668;})['then'](respondWithFilteredResult(_0x3f4f12,_0x15dd4a))[_0xd7c4('0x36')](handleError(_0x3f4f12,null));};exports[_0xd7c4('0xb0')]=function(_0x497322,_0x837b60){var _0x241e7c={};if(_0x497322['query'][_0xd7c4('0x41')]&&_0x497322[_0xd7c4('0x44')][_0xd7c4('0x41')]==='from'){_0x241e7c[_0xd7c4('0x51')]=_0x497322['params']['id'];}else{_0x241e7c['id']=_0x497322[_0xd7c4('0xb1')]['id'];}var _0x30fe57={'raw':![],'where':_0x241e7c},_0x4535e9={};_0x4535e9['model']=_['keys'](db['OpenchannelInteraction'][_0xd7c4('0x40')]);_0x4535e9['query']=_[_0xd7c4('0x74')](_0x497322[_0xd7c4('0x44')]);_0x4535e9['filters']=_[_0xd7c4('0x43')](_0x4535e9['model'],_0x4535e9[_0xd7c4('0x44')]);_0x30fe57[_0xd7c4('0x45')]=_[_0xd7c4('0x43')](_0x4535e9['model'],qs[_0xd7c4('0x9d')](_0x497322[_0xd7c4('0x44')][_0xd7c4('0x9d')]));_0x30fe57['attributes']=_0x30fe57[_0xd7c4('0x45')][_0xd7c4('0x47')]?_0x30fe57['attributes']:_0x4535e9['model'];if(_0x497322[_0xd7c4('0x44')][_0xd7c4('0xb2')]){_0x30fe57['include']=[{'all':!![]}];}_0x30fe57=_[_0xd7c4('0x9c')]({},_0x30fe57,_0x497322[_0xd7c4('0xb3')]);return db[_0xd7c4('0x3f')][_0xd7c4('0x65')](_0x30fe57)['then'](handleEntityNotFound(_0x837b60,null))[_0xd7c4('0x35')](respondWithResult(_0x837b60,null))['catch'](handleError(_0x837b60,null));};exports[_0xd7c4('0xb4')]=function(_0x43ad55,_0x464f79){return db['OpenchannelInteraction'][_0xd7c4('0xb4')](_0x43ad55[_0xd7c4('0x73')],{})[_0xd7c4('0x35')](respondWithResult(_0x464f79,0xc9))[_0xd7c4('0x36')](handleError(_0x464f79,null));};exports['update']=function(_0x382e59,_0x2d35c3){if(_0x382e59['body']['id']){delete _0x382e59[_0xd7c4('0x73')]['id'];}return db[_0xd7c4('0x3f')]['find']({'where':{'id':_0x382e59['params']['id']}})[_0xd7c4('0x35')](handleEntityNotFound(_0x2d35c3,null))[_0xd7c4('0x35')](saveUpdates(_0x382e59[_0xd7c4('0x73')],null))[_0xd7c4('0x35')](respondWithResult(_0x2d35c3,null))[_0xd7c4('0x36')](handleError(_0x2d35c3,null));};exports['destroy']=function(_0x4c4ac7,_0x1c0de7){return db['OpenchannelInteraction'][_0xd7c4('0x65')]({'where':{'id':_0x4c4ac7[_0xd7c4('0xb1')]['id']}})[_0xd7c4('0x35')](handleEntityNotFound(_0x1c0de7,null))[_0xd7c4('0x35')](removeEntity(_0x1c0de7,null))['catch'](handleError(_0x1c0de7,null));};exports['describe']=function(_0x5301a1,_0x4050fe){return db['OpenchannelInteraction']['describe']()[_0xd7c4('0x35')](respondWithResult(_0x4050fe,null))['catch'](handleError(_0x4050fe,null));};exports[_0xd7c4('0xb5')]=function(_0x4a088e,_0xdcea5c,_0x2b9f46){return db[_0xd7c4('0xb6')][_0xd7c4('0x65')]({'where':{'id':_0x4a088e[_0xd7c4('0xb1')]['id']}})[_0xd7c4('0x35')](handleEntityNotFound(_0xdcea5c,null))[_0xd7c4('0x35')](function(_0x2460bf){if(_0x2460bf){return _0x2460bf[_0xd7c4('0xb5')](_0x4a088e[_0xd7c4('0x73')][_0xd7c4('0xb7')],_[_0xd7c4('0xb8')](_0x4a088e[_0xd7c4('0x73')],['ids','id'])||{});}})[_0xd7c4('0x35')](respondWithResult(_0xdcea5c,null))['catch'](handleError(_0xdcea5c,null));};exports[_0xd7c4('0xb9')]=function(_0x126652,_0x46fc98,_0x4ef7ac){var _0x22de9b={'raw':![],'where':{}};var _0x35c946={};var _0x5bad2e={'count':0x0,'rows':[]};return db['OpenchannelInteraction'][_0xd7c4('0xba')]({'where':{'id':_0x126652[_0xd7c4('0xb1')]['id']}})[_0xd7c4('0x35')](handleEntityNotFound(_0x46fc98,null))[_0xd7c4('0x35')](function(_0x29cace){if(_0x29cace){_0x35c946[_0xd7c4('0x46')]=_['keys'](db[_0xd7c4('0xb6')][_0xd7c4('0x40')]);_0x35c946[_0xd7c4('0x44')]=_['keys'](_0x126652[_0xd7c4('0x44')]);_0x35c946[_0xd7c4('0x42')]=_[_0xd7c4('0x43')](_0x35c946[_0xd7c4('0x46')],_0x35c946['query']);_0x22de9b[_0xd7c4('0x45')]=_[_0xd7c4('0x43')](_0x35c946[_0xd7c4('0x46')],qs[_0xd7c4('0x9d')](_0x126652[_0xd7c4('0x44')]['fields']));_0x22de9b[_0xd7c4('0x45')]=_0x22de9b[_0xd7c4('0x45')]['length']?_0x22de9b[_0xd7c4('0x45')]:_0x35c946[_0xd7c4('0x46')];if(!_0x126652['query'][_0xd7c4('0x48')](_0xd7c4('0x49'))){_0x22de9b['limit']=qs[_0xd7c4('0x25')](_0x126652[_0xd7c4('0x44')][_0xd7c4('0x25')]);_0x22de9b[_0xd7c4('0x24')]=qs[_0xd7c4('0x24')](_0x126652[_0xd7c4('0x44')][_0xd7c4('0x24')]);}_0x22de9b[_0xd7c4('0x4a')]=qs[_0xd7c4('0x4b')](_0x126652['query'][_0xd7c4('0x4b')]);_0x22de9b['where']=qs[_0xd7c4('0x42')](_['pick'](_0x126652[_0xd7c4('0x44')],_0x35c946[_0xd7c4('0x42')]));_0x22de9b['where'][_0xd7c4('0xae')]=_0x29cace['id'];if(_0x126652[_0xd7c4('0x44')][_0xd7c4('0x85')]){_0x22de9b[_0xd7c4('0x4c')]=_[_0xd7c4('0x9c')](_0x22de9b[_0xd7c4('0x4c')],{'$or':_['map'](_0x22de9b[_0xd7c4('0x45')],function(_0x86e6d){var _0x3e962f={};_0x3e962f[_0x86e6d]={'$like':'%'+_0x126652[_0xd7c4('0x44')]['filter']+'%'};return _0x3e962f;})});}if(_0x126652[_0xd7c4('0x44')]['$gte']){var _0x47ee8c=_0x126652[_0xd7c4('0x44')][_0xd7c4('0x7a')][_0xd7c4('0x31')](',');var _0x20bd4d={};_0x20bd4d[_0x47ee8c[0x0]]={'$gte':moment(_0x47ee8c[0x1])[_0xd7c4('0xbb')](_0xd7c4('0xbc'))};_0x22de9b[_0xd7c4('0x4c')]=_[_0xd7c4('0x9c')](_0x22de9b[_0xd7c4('0x4c')],_0x20bd4d);}_0x22de9b=_['merge']({},_0x22de9b,_0x126652[_0xd7c4('0xb3')]);return db[_0xd7c4('0xb6')][_0xd7c4('0x23')]({'where':_0x22de9b[_0xd7c4('0x4c')]})['then'](function(_0x1fc543){_0x5bad2e['count']=_0x1fc543;if(_0x126652[_0xd7c4('0x44')][_0xd7c4('0xb2')]){_0x22de9b[_0xd7c4('0xbd')]=[{'all':!![]}];}return db[_0xd7c4('0xb6')][_0xd7c4('0xbe')](_0x22de9b);})[_0xd7c4('0x35')](function(_0x2b01fb){_0x5bad2e['rows']=_0x2b01fb;return _0x5bad2e;});}})[_0xd7c4('0x35')](respondWithFilteredResult(_0x46fc98,_0x22de9b))[_0xd7c4('0x36')](handleError(_0x46fc98,null));};exports['addTags']=function(_0x516934,_0x3bb907,_0x2d9afb){return db[_0xd7c4('0x3f')][_0xd7c4('0x65')]({'where':{'id':_0x516934['params']['id']}})[_0xd7c4('0x35')](handleEntityNotFound(_0x3bb907,null))[_0xd7c4('0x35')](function(_0x106c53){if(_0x106c53){return _0x106c53[_0xd7c4('0xbf')](_0x516934['body'][_0xd7c4('0xb7')],_[_0xd7c4('0xb8')](_0x516934[_0xd7c4('0x73')],[_0xd7c4('0xb7'),'id'])||{})[_0xd7c4('0xc0')](function(){return db[_0xd7c4('0xc1')][_0xd7c4('0xbe')]({'attributes':['id','name','color'],'where':{'id':_0x516934[_0xd7c4('0x73')][_0xd7c4('0xb7')]}});})[_0xd7c4('0x35')](function(_0x3bd348){socket[_0xd7c4('0xc2')](_0xd7c4('0xc3'),{'id':Number(_0x516934[_0xd7c4('0xb1')]['id']),'tags':_0x3bd348||[]});return{'id':Number(_0x516934['params']['id']),'tags':_0x3bd348||[]};});}})[_0xd7c4('0x35')](respondWithResult(_0x3bb907,null))[_0xd7c4('0x36')](handleError(_0x3bb907,null));};exports[_0xd7c4('0xc4')]=function(_0x15c8fe,_0x31c288,_0x422edb){return db[_0xd7c4('0x3f')][_0xd7c4('0x65')]({'where':{'id':_0x15c8fe[_0xd7c4('0xb1')]['id']}})['then'](handleEntityNotFound(_0x31c288,null))[_0xd7c4('0x35')](function(_0x2bdff7){if(_0x2bdff7){return _0x2bdff7[_0xd7c4('0xc4')](_0x15c8fe[_0xd7c4('0x44')]['ids']);}})[_0xd7c4('0x35')](respondWithStatusCode(_0x31c288,null))[_0xd7c4('0x36')](handleError(_0x31c288,null));};exports[_0xd7c4('0xc5')]=function(_0x3e1b0b,_0x3125c0){var _0x1233ec=moment()[_0xd7c4('0xc6')]()[_0xd7c4('0x9b')]();var _0x46c520=path['join'](config[_0xd7c4('0xc7')],_0xd7c4('0xc8'),_0xd7c4('0xc9'),'tmp');var _0x3e3728=path[_0xd7c4('0xca')](config[_0xd7c4('0xc7')],_0xd7c4('0xc8'),_0xd7c4('0xc9'),'attachments');var _0x1114fd=path[_0xd7c4('0xca')](_0x46c520,_0x1233ec);var _0x1c838c=util[_0xd7c4('0xbb')]('transcript-%d-%s.zip',_0x3e1b0b[_0xd7c4('0xb1')]['id'],_0x1233ec);var _0x40389c=path[_0xd7c4('0xca')](_0x46c520,_0x1c838c);var _0x5af071=[];_0x5af071[_0xd7c4('0x33')]({'model':db[_0xd7c4('0x71')],'as':_0xd7c4('0x71'),'attributes':['id','fullname'],'raw':!![]});_0x5af071['push']({'model':db[_0xd7c4('0xcb')],'as':_0xd7c4('0xcc'),'attributes':['id',_0xd7c4('0xcd'),_0xd7c4('0xce')],'raw':!![]});if(_0x3e1b0b[_0xd7c4('0x44')][_0xd7c4('0xcf')]){_0x5af071[_0xd7c4('0x33')]({'model':db['Attachment'],'as':_0xd7c4('0xd0'),'raw':!![]});}var _0xcc738=[{'model':db[_0xd7c4('0xb6')],'as':_0xd7c4('0xd1'),'attributes':['id',_0xd7c4('0x73'),_0xd7c4('0x79'),'direction','secret','read'],'include':_0x5af071}];_0xcc738[_0xd7c4('0x33')]({'model':db[_0xd7c4('0xd2')],'as':_0xd7c4('0xd3'),'attributes':['id',_0xd7c4('0x2c')]});_0xcc738[_0xd7c4('0x33')]({'model':db[_0xd7c4('0x71')],'as':_0xd7c4('0xd4'),'attributes':['id',_0xd7c4('0x2f')]});return db[_0xd7c4('0x3f')]['find']({'where':{'id':_0x3e1b0b[_0xd7c4('0xb1')]['id']},'include':_0xcc738})[_0xd7c4('0x35')](handleEntityNotFound(_0x3125c0,null))['then'](function(_0x38ba96){if(_0x38ba96){var _0x3757ad=_0x38ba96[_0xd7c4('0xd5')]({'plain':!![]});fs['mkdirSync'](_0x1114fd);var _0x20aa76={'channel':_0xd7c4('0xd6'),'account':_0x3757ad[_0xd7c4('0xd3')][_0xd7c4('0x2c')],'agent':_0x3757ad[_0xd7c4('0xd4')]?_0x3757ad['Owner'][_0xd7c4('0x2f')]:_0xd7c4('0xd7'),'createdAt':moment(_0x3757ad['createdAt'])['format'](_0xd7c4('0xbc'))[_0xd7c4('0x9b')](),'closedAt':_0x3757ad[_0xd7c4('0x3b')]?moment(_0x3757ad['closedAt'])[_0xd7c4('0xbb')](_0xd7c4('0xbc'))[_0xd7c4('0x9b')]():'','disposition':_0x3757ad['disposition'],'visibility':_0x3757ad[_0xd7c4('0xd8')]?_0xd7c4('0xd9'):_0xd7c4('0xda'),'messages':_(_0x3757ad[_0xd7c4('0xd1')])[_0xd7c4('0x85')]({'secret':![]})['map'](function(_0x3273f7){if(_0x3273f7[_0xd7c4('0xd0')]){var _0x1242f=path[_0xd7c4('0xca')](_0x3e3728,_0x3273f7['Attachment'][_0xd7c4('0xdb')]);if(fs[_0xd7c4('0xdc')](_0x1242f)){fs[_0xd7c4('0xdd')](_0x1242f)[_0xd7c4('0xde')](fs[_0xd7c4('0xdf')](path[_0xd7c4('0xca')](_0x1114fd,_0x3273f7[_0xd7c4('0xd0')][_0xd7c4('0xdb')])));}}return{'date':moment(_0x3273f7[_0xd7c4('0x79')])[_0xd7c4('0xbb')](_0xd7c4('0xbc'))[_0xd7c4('0x9b')](),'sender':_0x3273f7['direction']===_0xd7c4('0xe0')?_0x3273f7['User']?_0x3273f7['User'][_0xd7c4('0x2f')]:_0xd7c4('0xe1'):_0x3273f7[_0xd7c4('0xcc')][_0xd7c4('0xcd')]+(_0x3273f7[_0xd7c4('0xcc')][_0xd7c4('0xce')]?'\x20'+_0x3273f7['Contact'][_0xd7c4('0xce')]:''),'body':_0x3273f7[_0xd7c4('0xd0')]?_0x3273f7['Attachment'][_0xd7c4('0xdb')]:_0x3273f7['body'],'direction':_0x3273f7[_0xd7c4('0xe2')]===_0xd7c4('0xe0')?'A':'C','secret':_0x3273f7['secret'],'read':_0x3273f7[_0xd7c4('0x7f')],'attachment':_0x3273f7[_0xd7c4('0xd0')]};})[_0xd7c4('0x66')]()};return ejs[_0xd7c4('0xe3')](path[_0xd7c4('0xca')](config['root'],_0xd7c4('0xc8'),_0xd7c4('0xe4'),_0xd7c4('0xe5')),{'interaction':_0x20aa76})[_0xd7c4('0x35')](function(_0xf0563f){var _0x24629c=path[_0xd7c4('0xca')](_0x1114fd,_0xd7c4('0xe6')+_0x3757ad['id']+'-'+_0x1233ec+_0xd7c4('0xe7'));var _0x37c966={'path':_0x24629c,'channel':_0xd7c4('0xd6'),'interactionId':_0x3757ad['id']};return pdf[_0xd7c4('0xe8')](_0xf0563f,_0x37c966);})[_0xd7c4('0x35')](function(){return new BPromise(function(_0x44dbdd,_0x202a14){zipdir(_0x1114fd,{'saveTo':_0x40389c},function(_0x45f584,_0x5500b3){if(_0x45f584)return _0x202a14(_0x45f584);return _0x44dbdd(_0x5500b3);});})[_0xd7c4('0x35')](function(){return new BPromise(function(_0xa0e9d7,_0x4a0d06){rimraf(_0x1114fd,function(_0x310d7b){if(_0x310d7b)_0x4a0d06(_0x310d7b);return _0xa0e9d7();});});})[_0xd7c4('0x35')](function(){return _0x3125c0[_0xd7c4('0xc5')](_0x40389c,_0x1c838c,function(_0x2a428c){if(_0x2a428c){console['log'](_0xd7c4('0xe9'),_0x2a428c);}else{fs[_0xd7c4('0xea')](_0x40389c);}});});});}else{return _0x3125c0[_0xd7c4('0xeb')](0xc8);}})['catch'](handleError(_0x3125c0,null));};
git://repos.xcallymotion.com / motion2.git / blob