18 var _0x3954=['$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','i.id\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.from\x20LIKE\x20?','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','group','i.id','QueryTypes','SELECT','clone','t.id\x20IN\x20?','resolve','journey','i.OpenchannelAccountId\x20IS\x20NOT\x20NULL','getOpenchannelAccounts','i.OpenchannelAccountId\x20IS\x20NULL','i.OpenchannelAccountId\x20IN\x20?','toString','sequelize','keyBy','OpenchannelInteraction','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','c.firstName','Contact.firstName','Contact.email','c.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.OpenchannelInteractionId\x20IN\x20?','OpenchannelInteractionId','all','show','params','includeAll','include','merge','options','catch','create','describe','OpenchannelMessage','addMessage','ids','omit','getMessages','findOne','hasOwnProperty','filter','format','YYYY-MM-DD\x20HH:mm:ss','findAll','rows','addTags','setTags','spread','Tag','emit','openchannelInteractionTags:save','removeTags','download','join','server','files','tmp','attachments','CmContact','lastName','Attachment','Messages','direction','secret','OpenchannelAccount','Account','get','mkdirSync','10px','40px','<div\x20class=\x22header\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<h5>Interaction\x20Transcript</h5>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>','<hr\x20class=\x22separator\x22/>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22footer\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22left\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>%s</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22center\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>{{page}}/{{pages}}</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22right\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>%s</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>','YYYY-MM-DD','Openchannel','Owner','N.A.','closed','closedAt','disposition','Private','basename','existsSync','createReadStream','createWriteStream','out','System','firstName','renderFile','root','views','transcript-','.pdf','log','err','unlinkSync','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','lodash','squel','crypto','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','./openchannelInteraction.socket','register','sendStatus','end','status','json','count','offset','limit','Content-Range','apply','save','update','then','destroy','stack','name','send','Users','map','fullname','Tags','TagIds','split','forEach','push','index','rawAttributes','fieldName','type','key','model','query','keys','attributes','intersection','fields','length','nolimit','order','sort','where','filters','pick','select','field','color','tools_tags','u.id','u.fullname','ui.OpenchannelInteractionId','from','user_has_openchannel_interactions','left_join','u.id\x20=\x20ui.UserId','openchannel_interactions','cm_contacts','o.id\x20=\x20i.UserId','openchannel_accounts','a.id\x20=\x20i.OpenchannelAccountId','openchannel_messages','me.OpenchannelInteractionId\x20=\x20i.id','it.OpenchannelInteractionId\x20=\x20i.id','expr','search','sqlOperator','conditions','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','text','start','body','some','compact','isEmpty','OpenchannelAccountId','concat','createdAt','parse','$gte'];(function(_0x3054be,_0x1bdc8b){var _0x3df150=function(_0x56cfbf){while(--_0x56cfbf){_0x3054be['push'](_0x3054be['shift']());}};_0x3df150(++_0x1bdc8b);}(_0x3954,0x16d));var _0x4395=function(_0x23766d,_0xcbcb33){_0x23766d=_0x23766d-0x0;var _0x22e21e=_0x3954[_0x23766d];return _0x22e21e;};'use strict';var pdf=require(_0x4395('0x0'));var emlformat=require(_0x4395('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x4395('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x4395('0x3'));var moment=require(_0x4395('0x4'));var BPromise=require(_0x4395('0x5'));var Mustache=require(_0x4395('0x6'));var util=require(_0x4395('0x7'));var path=require(_0x4395('0x8'));var sox=require(_0x4395('0x9'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x4395('0xa'));var squel=require(_0x4395('0xb'));var crypto=require(_0x4395('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x4395('0xd'));var toCsv=require(_0x4395('0xe'));var querystring=require(_0x4395('0xf'));var Papa=require(_0x4395('0x10'));var Redis=require(_0x4395('0x11'));var authService=require(_0x4395('0x12'));var qs=require(_0x4395('0x13'));var as=require(_0x4395('0x14'));var hardwareService=require(_0x4395('0x15'));var logger=require(_0x4395('0x16'))(_0x4395('0x17'));var utils=require(_0x4395('0x18'));var config=require(_0x4395('0x19'));var db=require(_0x4395('0x1a'))['db'];config[_0x4395('0x1b')]=_['defaults'](config[_0x4395('0x1b')],{'host':_0x4395('0x1c'),'port':0x18eb});var socket=require(_0x4395('0x1d'))(new Redis(config['redis']));require(_0x4395('0x1e'))[_0x4395('0x1f')](socket);function respondWithStatusCode(_0x1dc7f6,_0x4a6ec2){_0x4a6ec2=_0x4a6ec2||0xcc;return function(_0x4a666c){if(_0x4a666c){return _0x1dc7f6[_0x4395('0x20')](_0x4a6ec2);}return _0x1dc7f6['status'](_0x4a6ec2)[_0x4395('0x21')]();};}function respondWithResult(_0x10cf4e,_0x322da3){_0x322da3=_0x322da3||0xc8;return function(_0x4109d4){if(_0x4109d4){return _0x10cf4e[_0x4395('0x22')](_0x322da3)[_0x4395('0x23')](_0x4109d4);}};}function respondWithFilteredResult(_0x294339,_0x562fd1){return function(_0x4f1d15){if(_0x4f1d15){var _0x5d5575=_0x4f1d15[_0x4395('0x24')],_0x4ac329=_0x562fd1[_0x4395('0x25')],_0x3c2ec9=_0x562fd1[_0x4395('0x25')]+_0x562fd1[_0x4395('0x26')],_0x569e12;if(_0x3c2ec9>=_0x5d5575){_0x3c2ec9=_0x5d5575;_0x569e12=0xc8;}else{_0x569e12=0xce;}_0x294339['status'](_0x569e12);return _0x294339['set'](_0x4395('0x27'),_0x4ac329+'-'+_0x3c2ec9+'/'+_0x5d5575)['json'](_0x4f1d15);}return null;};}function patchUpdates(_0x23f590){return function(_0x9528c){try{jsonpatch[_0x4395('0x28')](_0x9528c,_0x23f590,!![]);}catch(_0x179ffc){return BPromise['reject'](_0x179ffc);}return _0x9528c[_0x4395('0x29')]();};}function saveUpdates(_0x456d25,_0x20acc3){return function(_0x4b30b9){if(_0x4b30b9){return _0x4b30b9[_0x4395('0x2a')](_0x456d25)[_0x4395('0x2b')](function(_0x338d56){return _0x338d56;});}return null;};}function removeEntity(_0xb77236,_0x1de16f){return function(_0x3768db){if(_0x3768db){return _0x3768db[_0x4395('0x2c')]()['then'](function(){_0xb77236[_0x4395('0x22')](0xcc)[_0x4395('0x21')]();});}};}function handleEntityNotFound(_0x56fc47,_0x4c2603){return function(_0x3d4b3b){if(!_0x3d4b3b){_0x56fc47[_0x4395('0x20')](0x194);}return _0x3d4b3b;};}function handleError(_0x23f173,_0x493500){_0x493500=_0x493500||0x1f4;return function(_0x463c04){logger['error'](_0x463c04[_0x4395('0x2d')]);if(_0x463c04['name']){delete _0x463c04[_0x4395('0x2e')];}_0x23f173['status'](_0x493500)[_0x4395('0x2f')](_0x463c04);};}function getInteractionUsers(_0x355a7,_0x496eb3){return new BPromise(function(_0x124a3b,_0x23caa5){try{if(_0x496eb3[_0x355a7['id']]){_0x355a7[_0x4395('0x30')]=_[_0x4395('0x31')](_0x496eb3[_0x355a7['id']],function(_0x3ec303){return{'id':_0x3ec303['id'],'fullname':_0x3ec303[_0x4395('0x32')]};});}}catch(_0x3dd2a3){_0x23caa5(_0x3dd2a3);}_0x124a3b(_0x355a7);});}function getInteractionTags(_0x4a9f00,_0x10fcb3){return new BPromise(function(_0x1ecc84,_0x175328){try{if(_0x4a9f00['TagIds']){_0x4a9f00[_0x4395('0x33')]=[];_0x4a9f00[_0x4395('0x34')][_0x4395('0x35')](',')[_0x4395('0x36')](function(_0x5cd3ec){_0x4a9f00['Tags'][_0x4395('0x37')](_0x10fcb3[_0x5cd3ec]);});}delete _0x4a9f00[_0x4395('0x34')];}catch(_0x3a5871){_0x175328(_0x3a5871);}_0x1ecc84(_0x4a9f00);});}function updateOpenchannelInteraction(_0x4544f4,_0x434764,_0x28cb8f){return new BPromise(function(_0x5bc62c,_0x42dd48){return getInteractionUsers(_0x4544f4,_0x28cb8f)[_0x4395('0x2b')](function(_0x3a95f0){return getInteractionTags(_0x3a95f0,_0x434764);})['then'](function(_0x422c15){_0x5bc62c(_0x422c15);})['catch'](function(_0x1fe7ac){_0x42dd48(_0x1fe7ac);});});}exports[_0x4395('0x38')]=function(_0x2bf58e,_0x57dc22){var _0x5929fb={},_0x2857e8={},_0x477006={'count':0x0,'rows':[]};var _0x3ade9e=_[_0x4395('0x31')](db['OpenchannelInteraction'][_0x4395('0x39')],function(_0x1a9cb6){return{'name':_0x1a9cb6[_0x4395('0x3a')],'type':_0x1a9cb6[_0x4395('0x3b')][_0x4395('0x3c')]};});_0x2857e8[_0x4395('0x3d')]=_[_0x4395('0x31')](_0x3ade9e,_0x4395('0x2e'));_0x2857e8[_0x4395('0x3e')]=_[_0x4395('0x3f')](_0x2bf58e[_0x4395('0x3e')]);_0x2857e8['filters']=_['intersection'](_0x2857e8[_0x4395('0x3d')],_0x2857e8[_0x4395('0x3e')]);_0x5929fb[_0x4395('0x40')]=_[_0x4395('0x41')](_0x2857e8[_0x4395('0x3d')],qs[_0x4395('0x42')](_0x2bf58e[_0x4395('0x3e')][_0x4395('0x42')]));_0x5929fb[_0x4395('0x40')]=_0x5929fb['attributes'][_0x4395('0x43')]?_0x5929fb[_0x4395('0x40')]:_0x2857e8[_0x4395('0x3d')];if(!_0x2bf58e[_0x4395('0x3e')]['hasOwnProperty'](_0x4395('0x44'))){_0x5929fb[_0x4395('0x26')]=qs[_0x4395('0x26')](_0x2bf58e[_0x4395('0x3e')][_0x4395('0x26')]);_0x5929fb['offset']=qs[_0x4395('0x25')](_0x2bf58e['query'][_0x4395('0x25')]);}_0x5929fb[_0x4395('0x45')]=qs[_0x4395('0x46')](_0x2bf58e['query'][_0x4395('0x46')]);_0x5929fb[_0x4395('0x47')]=qs[_0x4395('0x48')](_[_0x4395('0x49')](_0x2bf58e[_0x4395('0x3e')],_0x2857e8[_0x4395('0x48')]),_0x3ade9e);var _0x41a9a5=[];var _0x5848ba=squel[_0x4395('0x4a')]()['field']('id')[_0x4395('0x4b')](_0x4395('0x2e'))[_0x4395('0x4b')](_0x4395('0x4c'))['from'](_0x4395('0x4d'));var _0x5792e6=squel[_0x4395('0x4a')]()[_0x4395('0x4b')](_0x4395('0x4e'))['field'](_0x4395('0x4f'))['field'](_0x4395('0x50'))[_0x4395('0x51')](_0x4395('0x52'),'ui')[_0x4395('0x53')]('users','u',_0x4395('0x54'));var _0x51b0c8=squel[_0x4395('0x4a')]()[_0x4395('0x51')](_0x4395('0x55'),'i')[_0x4395('0x53')](_0x4395('0x56'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x4395('0x53')]('users','o',_0x4395('0x57'))['left_join'](_0x4395('0x58'),'a',_0x4395('0x59'))[_0x4395('0x53')](_0x4395('0x5a'),'me',_0x4395('0x5b'))[_0x4395('0x53')]('openchannel_interaction_has_tags','it',_0x4395('0x5c'))[_0x4395('0x53')](_0x4395('0x4d'),'t','t.id\x20=\x20it.TagId');var _0x37dd78=squel[_0x4395('0x5d')]();var _0x434fea=[];var _0x2d62e2=squel[_0x4395('0x5d')]();var _0x4e341f;if(_0x2bf58e[_0x4395('0x3e')]['search']){_0x4e341f=as['parseSearch'](_0x2bf58e[_0x4395('0x3e')][_0x4395('0x5e')]);var _0x532cc7=_0x4e341f[_0x4395('0x5f')];for(var _0xf017dc=0x0;_0xf017dc<_0x4e341f['conditions'][_0x4395('0x43')];_0xf017dc++){var _0x292319=_0x4e341f[_0x4395('0x60')][_0xf017dc];var _0x212867='i';var _0x549992=_[_0x4395('0x61')](_0x3ade9e,[_0x4395('0x2e'),_0x292319[_0x4395('0x4b')]]);if(!_0x549992){switch(_0x292319[_0x4395('0x4b')]){case _0x4395('0x62'):if(_0x292319[_0x4395('0x63')]==0x1){_0x51b0c8[_0x4395('0x64')]('`'+_0x292319['field']+_0x4395('0x65'));}else{_0x51b0c8[_0x4395('0x64')]('`'+_0x292319['field']+_0x4395('0x66'));}break;case _0x4395('0x67'):if(_0x292319[_0x4395('0x68')]===_0x4395('0x69')){if(_0x292319['value'][_0x4395('0x35')]('\x20')[_0x4395('0x43')]>0x1){_0x37dd78[_0x532cc7](_0x4395('0x6a'),qs[_0x4395('0x6b')](_0x292319[_0x4395('0x63')]),null);}else{var _0x5d09e3='%'+_0x292319[_0x4395('0x63')]+'%';_0x37dd78[_0x532cc7](_0x4395('0x6c'),_0x5d09e3,_0x5d09e3,_0x5d09e3);}}else{_0x549992=_[_0x4395('0x61')](_0x3ade9e,[_0x4395('0x2e'),_0x4395('0x6d')]);_0x292319[_0x4395('0x4b')]=_0x4395('0x6d');_0x172afb=as[_0x4395('0x6e')](_0x212867,_0x549992[_0x4395('0x3b')],_0x292319);_0x37dd78[_0x532cc7](_0x172afb['text'],_0x172afb[_0x4395('0x63')]['start'],_0x172afb[_0x4395('0x63')][_0x4395('0x21')]);}break;case'Tag':var _0x582e37=_0x292319[_0x4395('0x63')][_0x4395('0x35')](',')[_0x4395('0x31')](function(_0x1b40ad){return Number(_0x1b40ad);});_0x582e37['forEach'](function(_0x35532b){_0x2d62e2['or'](_0x4395('0x6f'),'%,'+_0x35532b+',%');});_0x434fea=_[_0x4395('0x70')](_0x434fea,_0x582e37);break;case _0x4395('0x71'):if(_0x292319[_0x4395('0x68')]===_0x4395('0x69')){_0x37dd78[_0x532cc7](_0x4395('0x72'),'%'+_0x292319[_0x4395('0x63')]+'%',null);}else{_0x549992=_[_0x4395('0x61')](_0x3ade9e,['name',_0x4395('0x73')]);_0x292319[_0x4395('0x4b')]=_0x4395('0x73');_0x172afb=as[_0x4395('0x6e')](_0x212867,_0x549992[_0x4395('0x3b')],_0x292319);_0x37dd78[_0x532cc7](_0x172afb[_0x4395('0x74')],_0x172afb[_0x4395('0x63')][_0x4395('0x75')],_0x172afb[_0x4395('0x63')][_0x4395('0x21')]);}break;case _0x4395('0x76'):_0x172afb=as[_0x4395('0x6e')]('me',null,_0x292319);_0x37dd78[_0x532cc7](_0x172afb[_0x4395('0x74')],_0x172afb[_0x4395('0x63')][_0x4395('0x75')],_0x172afb['value'][_0x4395('0x21')]);break;}}else{var _0x172afb=as[_0x4395('0x6e')](_0x212867,_0x549992[_0x4395('0x3b')],_0x292319);_0x37dd78[_0x532cc7](_0x172afb[_0x4395('0x74')],_0x172afb['value']['start'],_0x172afb[_0x4395('0x63')][_0x4395('0x21')]);}}}else{var _0x2444e8=_(_0x2bf58e[_0x4395('0x3e')])[_0x4395('0x3f')]()[_0x4395('0x31')](function(_0x162213){return _[_0x4395('0x77')](_0x3ade9e,[_0x4395('0x2e'),_0x162213])?_0x162213:undefined;})[_0x4395('0x78')]()[_0x4395('0x63')]();if(!_[_0x4395('0x79')](_0x2444e8)){_0x2444e8[_0x4395('0x36')](function(_0x5b3cf8){if(_0x5b3cf8===_0x4395('0x7a')){_0x51b0c8[_0x4395('0x47')]('i.OpenchannelAccountId\x20IN\x20?',[][_0x4395('0x7b')](_0x2bf58e['query'][_0x5b3cf8]));}else if(_0x5b3cf8===_0x4395('0x7c')){var _0x39b50d=JSON[_0x4395('0x7d')](_0x2bf58e[_0x4395('0x3e')][_0x5b3cf8])[_0x4395('0x7e')];var _0x2ed656=JSON[_0x4395('0x7d')](_0x2bf58e['query'][_0x5b3cf8])[_0x4395('0x7f')];_0x51b0c8[_0x4395('0x47')](_0x4395('0x80'),_0x39b50d,_0x2ed656);}else{if(_0x2bf58e[_0x4395('0x3e')][_0x5b3cf8]==='null'){_0x51b0c8[_0x4395('0x47')]('i.'+_0x5b3cf8+'\x20IS\x20NULL');}else{_0x51b0c8['where']('i.'+_0x5b3cf8+_0x4395('0x81'),_0x2bf58e[_0x4395('0x3e')][_0x5b3cf8]);}}});}if(_0x2bf58e['query'][_0x4395('0x82')]){if(_0x2bf58e[_0x4395('0x3e')][_0x4395('0x82')]==0x1){_0x51b0c8[_0x4395('0x64')](_0x4395('0x83'));}else{_0x51b0c8[_0x4395('0x64')](_0x4395('0x84'));}}if(_0x2bf58e[_0x4395('0x3e')][_0x4395('0x85')]){_0x434fea=_[_0x4395('0x86')](_0x2bf58e['query'][_0x4395('0x85')])?_0x2bf58e[_0x4395('0x3e')][_0x4395('0x85')]:new Array(_0x2bf58e[_0x4395('0x3e')][_0x4395('0x85')]);_0x434fea[_0x4395('0x36')](function(_0x128626){_0x2d62e2['or'](_0x4395('0x6f'),'%,'+_0x128626+',%');});}if(_0x2bf58e['query']['filter']){var _0x4b64d3=_0x2bf58e[_0x4395('0x3e')]['filter']['replace']('\x5c','\x5c\x5c')['replace']('\x27\x27','\x27\x27\x27\x27');if(qs['isNumeric'](_0x4b64d3)){_0x37dd78['or'](_0x4395('0x87'),_0x4b64d3+'%');}else{_0x37dd78['or'](_0x4395('0x88'),qs[_0x4395('0x6b')](_0x4b64d3))['or'](_0x4395('0x89'),_0x4b64d3+'%')['or'](_0x4395('0x8a'),_0x4b64d3+'%');}}}_0x51b0c8[_0x4395('0x47')](_0x37dd78);_0x51b0c8[_0x4395('0x8b')](_0x4395('0x8c'));var _0x14f956={'type':db['Sequelize'][_0x4395('0x8d')][_0x4395('0x8e')],'raw':!![]};var _0x52dfe2=_0x51b0c8[_0x4395('0x8f')]();_0x52dfe2[_0x4395('0x4b')]('i.id');_0x52dfe2['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x4395('0x62'));if(_0x5929fb['order']){_0x5929fb['order'][_0x4395('0x36')](function(_0xc0d0ed){_0x51b0c8[_0x4395('0x45')]('i.'+_0xc0d0ed[0x0],_0xc0d0ed[0x1]==='DESC'?![]:!![]);});}if(!_['isEmpty'](_0x434fea)){_0x51b0c8[_0x4395('0x64')](_0x2d62e2);_0x52dfe2[_0x4395('0x47')](_0x4395('0x90'),_0x434fea);}BPromise[_0x4395('0x91')]()[_0x4395('0x2b')](function(){if(!_0x4e341f){if(_0x2bf58e[_0x4395('0x3e')][_0x4395('0x7a')]||_0x2bf58e['query'][_0x4395('0x92')])return;_0x52dfe2[_0x4395('0x47')](_0x4395('0x93'));_0x51b0c8[_0x4395('0x47')](_0x4395('0x93'));return;}return _0x2bf58e['user'][_0x4395('0x94')]({'attributes':['id'],'raw':!![]})[_0x4395('0x2b')](function(_0x518e55){if(_[_0x4395('0x79')](_0x518e55)){_0x52dfe2[_0x4395('0x47')](_0x4395('0x95'));_0x51b0c8[_0x4395('0x47')](_0x4395('0x95'));}else{_0x52dfe2[_0x4395('0x47')]('i.OpenchannelAccountId\x20IN\x20?',_['map'](_0x518e55,'id'));_0x51b0c8[_0x4395('0x47')](_0x4395('0x96'),_[_0x4395('0x31')](_0x518e55,'id'));}});})[_0x4395('0x2b')](function(){db['sequelize'][_0x4395('0x3e')](_0x52dfe2[_0x4395('0x97')](),_0x14f956)[_0x4395('0x2b')](function(_0xb4a6a9){_0x477006[_0x4395('0x24')]=_0xb4a6a9[_0x4395('0x43')];if(_0x477006[_0x4395('0x24')]===0x0)return[];return db[_0x4395('0x98')][_0x4395('0x3e')](_0x5848ba[_0x4395('0x97')](),_0x14f956)[_0x4395('0x2b')](function(_0xd19f0a){_0x41a9a5=_[_0x4395('0x99')](_0xd19f0a,'id');_0x14f956=_['merge'](_0x14f956,{'model':db[_0x4395('0x9a')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x2bf58e['query']['fields']){_0x5929fb[_0x4395('0x40')][_0x4395('0x36')](function(_0x5cfd76){_0x51b0c8[_0x4395('0x4b')]('i.'+_0x5cfd76);});}else{_0x51b0c8['field'](_0x4395('0x9b'),_0x4395('0x62'));_0x51b0c8[_0x4395('0x4b')](_0x4395('0x9c'),_0x4395('0x9d'));_0x51b0c8[_0x4395('0x4b')](_0x4395('0x9e'),_0x4395('0x9f'));_0x51b0c8[_0x4395('0x4b')]('i.*');_0x51b0c8[_0x4395('0x4b')](_0x4395('0xa0'),_0x4395('0xa1'));_0x51b0c8[_0x4395('0x4b')]('c.lastName','Contact.lastName');_0x51b0c8[_0x4395('0x4b')]('c.email',_0x4395('0xa2'));_0x51b0c8[_0x4395('0x4b')](_0x4395('0xa3'),'Contact.phone');_0x51b0c8[_0x4395('0x4b')](_0x4395('0xa4'),_0x4395('0xa5'));_0x51b0c8[_0x4395('0x4b')](_0x4395('0xa6'),_0x4395('0xa7'));_0x51b0c8[_0x4395('0x4b')](_0x4395('0xa8'),_0x4395('0xa9'));_0x51b0c8[_0x4395('0x4b')](_0x4395('0xaa'),'Owner.internal');_0x51b0c8['field'](_0x4395('0xab'),'TagIds');}if(_0x5929fb[_0x4395('0x26')])_0x51b0c8[_0x4395('0x26')](_0x5929fb['limit']);if(_0x5929fb[_0x4395('0x25')])_0x51b0c8[_0x4395('0x25')](_0x5929fb[_0x4395('0x25')]);return db['sequelize'][_0x4395('0x3e')](_0x51b0c8[_0x4395('0x97')](),_0x14f956);})['then'](function(_0xe04f11){_0x5792e6[_0x4395('0x47')](_0x4395('0xac'),_[_0x4395('0x31')](_0xe04f11,'id'));return db['sequelize']['query'](_0x5792e6[_0x4395('0x97')](),_0x14f956)[_0x4395('0x2b')](function(_0xfc7eaa){var _0x5610bf=_['groupBy'](_0xfc7eaa,_0x4395('0xad'));var _0x5a5e74=[];_0xe04f11['forEach'](function(_0x2ec4f8){_0x5a5e74['push'](updateOpenchannelInteraction(_0x2ec4f8,_0x41a9a5,_0x5610bf));});return BPromise[_0x4395('0xae')](_0x5a5e74);});});})[_0x4395('0x2b')](function(_0x154373){_0x477006['rows']=_0x154373;return _0x477006;})['then'](respondWithFilteredResult(_0x57dc22,_0x5929fb));})['catch'](handleError(_0x57dc22,null));};exports[_0x4395('0xaf')]=function(_0x4946ee,_0x470cd7){var _0x2668c5={'raw':![],'where':{'id':_0x4946ee[_0x4395('0xb0')]['id']}},_0x17c1bc={};_0x17c1bc[_0x4395('0x3d')]=_[_0x4395('0x3f')](db[_0x4395('0x9a')][_0x4395('0x39')]);_0x17c1bc[_0x4395('0x3e')]=_['keys'](_0x4946ee[_0x4395('0x3e')]);_0x17c1bc[_0x4395('0x48')]=_[_0x4395('0x41')](_0x17c1bc[_0x4395('0x3d')],_0x17c1bc[_0x4395('0x3e')]);_0x2668c5['attributes']=_[_0x4395('0x41')](_0x17c1bc[_0x4395('0x3d')],qs['fields'](_0x4946ee[_0x4395('0x3e')][_0x4395('0x42')]));_0x2668c5['attributes']=_0x2668c5[_0x4395('0x40')][_0x4395('0x43')]?_0x2668c5[_0x4395('0x40')]:_0x17c1bc['model'];if(_0x4946ee['query'][_0x4395('0xb1')]){_0x2668c5[_0x4395('0xb2')]=[{'all':!![]}];}_0x2668c5=_[_0x4395('0xb3')]({},_0x2668c5,_0x4946ee[_0x4395('0xb4')]);return db[_0x4395('0x9a')][_0x4395('0x61')](_0x2668c5)['then'](handleEntityNotFound(_0x470cd7,null))[_0x4395('0x2b')](respondWithResult(_0x470cd7,null))[_0x4395('0xb5')](handleError(_0x470cd7,null));};exports['create']=function(_0xba8b45,_0x2c4f4c){return db[_0x4395('0x9a')][_0x4395('0xb6')](_0xba8b45[_0x4395('0x76')],{})[_0x4395('0x2b')](respondWithResult(_0x2c4f4c,0xc9))[_0x4395('0xb5')](handleError(_0x2c4f4c,null));};exports['update']=function(_0x1ba02c,_0x42ca28){if(_0x1ba02c[_0x4395('0x76')]['id']){delete _0x1ba02c[_0x4395('0x76')]['id'];}return db[_0x4395('0x9a')]['find']({'where':{'id':_0x1ba02c[_0x4395('0xb0')]['id']}})[_0x4395('0x2b')](handleEntityNotFound(_0x42ca28,null))[_0x4395('0x2b')](saveUpdates(_0x1ba02c['body'],null))[_0x4395('0x2b')](respondWithResult(_0x42ca28,null))[_0x4395('0xb5')](handleError(_0x42ca28,null));};exports[_0x4395('0x2c')]=function(_0x3b3b3e,_0x220d61){return db[_0x4395('0x9a')][_0x4395('0x61')]({'where':{'id':_0x3b3b3e[_0x4395('0xb0')]['id']}})[_0x4395('0x2b')](handleEntityNotFound(_0x220d61,null))[_0x4395('0x2b')](removeEntity(_0x220d61,null))[_0x4395('0xb5')](handleError(_0x220d61,null));};exports[_0x4395('0xb7')]=function(_0x689d34,_0x1ec410){return db[_0x4395('0x9a')][_0x4395('0xb7')]()[_0x4395('0x2b')](respondWithResult(_0x1ec410,null))['catch'](handleError(_0x1ec410,null));};exports['addMessage']=function(_0xb7bdf5,_0xafa428,_0x1fa152){return db[_0x4395('0xb8')][_0x4395('0x61')]({'where':{'id':_0xb7bdf5[_0x4395('0xb0')]['id']}})[_0x4395('0x2b')](handleEntityNotFound(_0xafa428,null))[_0x4395('0x2b')](function(_0x80452){if(_0x80452){return _0x80452[_0x4395('0xb9')](_0xb7bdf5[_0x4395('0x76')][_0x4395('0xba')],_[_0x4395('0xbb')](_0xb7bdf5[_0x4395('0x76')],['ids','id'])||{});}})[_0x4395('0x2b')](respondWithResult(_0xafa428,null))[_0x4395('0xb5')](handleError(_0xafa428,null));};exports[_0x4395('0xbc')]=function(_0x484522,_0x106e77,_0x3fd4d5){var _0x4d046f={'raw':![],'where':{}};var _0x442ceb={};var _0x39f7dd={'count':0x0,'rows':[]};return db[_0x4395('0x9a')][_0x4395('0xbd')]({'where':{'id':_0x484522[_0x4395('0xb0')]['id']}})[_0x4395('0x2b')](handleEntityNotFound(_0x106e77,null))[_0x4395('0x2b')](function(_0xd2eaac){if(_0xd2eaac){_0x442ceb[_0x4395('0x3d')]=_[_0x4395('0x3f')](db['OpenchannelMessage'][_0x4395('0x39')]);_0x442ceb['query']=_[_0x4395('0x3f')](_0x484522[_0x4395('0x3e')]);_0x442ceb[_0x4395('0x48')]=_[_0x4395('0x41')](_0x442ceb['model'],_0x442ceb['query']);_0x4d046f['attributes']=_[_0x4395('0x41')](_0x442ceb[_0x4395('0x3d')],qs[_0x4395('0x42')](_0x484522[_0x4395('0x3e')][_0x4395('0x42')]));_0x4d046f['attributes']=_0x4d046f[_0x4395('0x40')][_0x4395('0x43')]?_0x4d046f[_0x4395('0x40')]:_0x442ceb[_0x4395('0x3d')];if(!_0x484522[_0x4395('0x3e')][_0x4395('0xbe')]('nolimit')){_0x4d046f['limit']=qs['limit'](_0x484522[_0x4395('0x3e')][_0x4395('0x26')]);_0x4d046f[_0x4395('0x25')]=qs['offset'](_0x484522[_0x4395('0x3e')][_0x4395('0x25')]);}_0x4d046f[_0x4395('0x45')]=qs[_0x4395('0x46')](_0x484522['query'][_0x4395('0x46')]);_0x4d046f[_0x4395('0x47')]=qs[_0x4395('0x48')](_['pick'](_0x484522[_0x4395('0x3e')],_0x442ceb[_0x4395('0x48')]));_0x4d046f['where'][_0x4395('0xad')]=_0xd2eaac['id'];if(_0x484522[_0x4395('0x3e')]['filter']){_0x4d046f[_0x4395('0x47')]=_[_0x4395('0xb3')](_0x4d046f[_0x4395('0x47')],{'$or':_['map'](_0x4d046f[_0x4395('0x40')],function(_0x1f62fc){var _0x1b1a75={};_0x1b1a75[_0x1f62fc]={'$like':'%'+_0x484522[_0x4395('0x3e')][_0x4395('0xbf')]+'%'};return _0x1b1a75;})});}if(_0x484522[_0x4395('0x3e')]['$gte']){var _0x40bee8=_0x484522[_0x4395('0x3e')]['$gte']['split'](',');var _0x47c0b0={};_0x47c0b0[_0x40bee8[0x0]]={'$gte':moment(_0x40bee8[0x1])[_0x4395('0xc0')](_0x4395('0xc1'))};_0x4d046f['where']=_[_0x4395('0xb3')](_0x4d046f['where'],_0x47c0b0);}_0x4d046f=_[_0x4395('0xb3')]({},_0x4d046f,_0x484522['options']);return db[_0x4395('0xb8')][_0x4395('0x24')]({'where':_0x4d046f[_0x4395('0x47')]})[_0x4395('0x2b')](function(_0x25764f){_0x39f7dd[_0x4395('0x24')]=_0x25764f;if(_0x484522[_0x4395('0x3e')][_0x4395('0xb1')]){_0x4d046f[_0x4395('0xb2')]=[{'all':!![]}];}return db[_0x4395('0xb8')][_0x4395('0xc2')](_0x4d046f);})[_0x4395('0x2b')](function(_0x505cb2){_0x39f7dd[_0x4395('0xc3')]=_0x505cb2;return _0x39f7dd;});}})[_0x4395('0x2b')](respondWithFilteredResult(_0x106e77,_0x4d046f))[_0x4395('0xb5')](handleError(_0x106e77,null));};exports[_0x4395('0xc4')]=function(_0x5c4d8d,_0x62e0a2,_0x45d96a){return db['OpenchannelInteraction']['find']({'where':{'id':_0x5c4d8d['params']['id']}})['then'](handleEntityNotFound(_0x62e0a2,null))['then'](function(_0x11fdef){if(_0x11fdef){return _0x11fdef[_0x4395('0xc5')](_0x5c4d8d[_0x4395('0x76')][_0x4395('0xba')],_[_0x4395('0xbb')](_0x5c4d8d[_0x4395('0x76')],['ids','id'])||{})[_0x4395('0xc6')](function(){return db[_0x4395('0xc7')][_0x4395('0xc2')]({'attributes':['id','name',_0x4395('0x4c')],'where':{'id':_0x5c4d8d[_0x4395('0x76')][_0x4395('0xba')]}});})[_0x4395('0x2b')](function(_0x433d3b){socket[_0x4395('0xc8')](_0x4395('0xc9'),{'id':Number(_0x5c4d8d['params']['id']),'tags':_0x433d3b||[]});return{'id':Number(_0x5c4d8d[_0x4395('0xb0')]['id']),'tags':_0x433d3b||[]};});}})[_0x4395('0x2b')](respondWithResult(_0x62e0a2,null))[_0x4395('0xb5')](handleError(_0x62e0a2,null));};exports[_0x4395('0xca')]=function(_0x4df0f4,_0x240d4c,_0x253976){return db[_0x4395('0x9a')]['find']({'where':{'id':_0x4df0f4[_0x4395('0xb0')]['id']}})['then'](handleEntityNotFound(_0x240d4c,null))[_0x4395('0x2b')](function(_0x5631b0){if(_0x5631b0){return _0x5631b0[_0x4395('0xca')](_0x4df0f4[_0x4395('0x3e')][_0x4395('0xba')]);}})['then'](respondWithStatusCode(_0x240d4c,null))[_0x4395('0xb5')](handleError(_0x240d4c,null));};exports[_0x4395('0xcb')]=function(_0x30ae4b,_0x51972f){var _0x26800b=moment()['unix']()[_0x4395('0x97')]();var _0x24f89e=path[_0x4395('0xcc')](config['root'],_0x4395('0xcd'),_0x4395('0xce'),_0x4395('0xcf'));var _0xaed8f4=path[_0x4395('0xcc')](config['root'],_0x4395('0xcd'),'files',_0x4395('0xd0'));var _0x9873f0=path['join'](_0x24f89e,_0x26800b);var _0x3d1a6f=util['format']('transcript-%d-%s.zip',_0x30ae4b[_0x4395('0xb0')]['id'],_0x26800b);var _0x1584d9=path[_0x4395('0xcc')](_0x24f89e,_0x3d1a6f);var _0x10ec23=[];_0x10ec23[_0x4395('0x37')]({'model':db[_0x4395('0x71')],'as':'User','attributes':['id','fullname'],'raw':!![]});_0x10ec23[_0x4395('0x37')]({'model':db[_0x4395('0xd1')],'as':_0x4395('0x67'),'attributes':['id','firstName',_0x4395('0xd2')],'raw':!![]});if(_0x30ae4b[_0x4395('0x3e')][_0x4395('0xd0')]){_0x10ec23[_0x4395('0x37')]({'model':db[_0x4395('0xd3')],'as':_0x4395('0xd3'),'raw':!![]});}var _0x1b2fa0=[{'model':db['OpenchannelMessage'],'as':_0x4395('0xd4'),'attributes':['id',_0x4395('0x76'),_0x4395('0x7c'),_0x4395('0xd5'),_0x4395('0xd6'),_0x4395('0x82')],'include':_0x10ec23}];_0x1b2fa0[_0x4395('0x37')]({'model':db[_0x4395('0xd7')],'as':_0x4395('0xd8'),'attributes':['id','name']});_0x1b2fa0[_0x4395('0x37')]({'model':db[_0x4395('0x71')],'as':'Owner','attributes':['id',_0x4395('0x32')]});return db[_0x4395('0x9a')][_0x4395('0x61')]({'where':{'id':_0x30ae4b[_0x4395('0xb0')]['id']},'include':_0x1b2fa0})[_0x4395('0x2b')](handleEntityNotFound(_0x51972f,null))[_0x4395('0x2b')](function(_0x50282c){if(_0x50282c){var _0x17323b=_0x50282c[_0x4395('0xd9')]({'plain':!![]});fs[_0x4395('0xda')](_0x9873f0);var _0x53a35a={'format':'A4','border':_0x4395('0xdb'),'header':{'height':_0x4395('0xdc'),'contents':{'first':_0x4395('0xdd')}},'footer':{'height':'30px','contents':{'default':util[_0x4395('0xc0')](_0x4395('0xde'),util[_0x4395('0xc0')]('%s\x20#%d','Openchannel',_0x17323b['id']),moment()[_0x4395('0xc0')](_0x4395('0xdf'))[_0x4395('0x97')]())}}};var _0x430954={'channel':_0x4395('0xe0'),'account':_0x17323b[_0x4395('0xd8')]['name'],'agent':_0x17323b[_0x4395('0xe1')]?_0x17323b['Owner']['fullname']:_0x4395('0xe2'),'createdAt':moment(_0x17323b[_0x4395('0x7c')])[_0x4395('0xc0')](_0x4395('0xc1'))[_0x4395('0x97')](),'closedAt':_0x17323b[_0x4395('0xe3')]?moment(_0x17323b[_0x4395('0xe4')])[_0x4395('0xc0')](_0x4395('0xc1'))[_0x4395('0x97')]():'','disposition':_0x17323b[_0x4395('0xe5')],'visibility':_0x17323b['threadId']?'Public':_0x4395('0xe6'),'messages':_(_0x17323b[_0x4395('0xd4')])[_0x4395('0xbf')]({'secret':![]})['map'](function(_0x479976){if(_0x479976['Attachment']){var _0x27c05=path[_0x4395('0xcc')](_0xaed8f4,_0x479976[_0x4395('0xd3')][_0x4395('0xe7')]);if(fs[_0x4395('0xe8')](_0x27c05)){fs[_0x4395('0xe9')](_0x27c05)['pipe'](fs[_0x4395('0xea')](path['join'](_0x9873f0,_0x479976[_0x4395('0xd3')][_0x4395('0xe7')])));}}return{'date':moment(_0x479976[_0x4395('0x7c')])[_0x4395('0xc0')](_0x4395('0xc1'))[_0x4395('0x97')](),'sender':_0x479976[_0x4395('0xd5')]===_0x4395('0xeb')?_0x479976[_0x4395('0x71')]?_0x479976[_0x4395('0x71')][_0x4395('0x32')]:_0x4395('0xec'):_0x479976[_0x4395('0x67')][_0x4395('0xed')]+(_0x479976[_0x4395('0x67')]['lastName']?'\x20'+_0x479976['Contact'][_0x4395('0xd2')]:''),'body':_0x479976['Attachment']?_0x479976[_0x4395('0xd3')][_0x4395('0xe7')]:_0x479976[_0x4395('0x76')],'direction':_0x479976[_0x4395('0xd5')]===_0x4395('0xeb')?'A':'C','secret':_0x479976[_0x4395('0xd6')],'read':_0x479976[_0x4395('0x82')],'attachment':_0x479976['Attachment']};})[_0x4395('0x63')]()};return ejs[_0x4395('0xee')](path[_0x4395('0xcc')](config[_0x4395('0xef')],_0x4395('0xcd'),_0x4395('0xf0'),'downloadInteraction.html'),{'interaction':_0x430954})['then'](function(_0x7c48e9){return new BPromise(function(_0x3aa8ed,_0x561ca9){pdf[_0x4395('0xb6')](_0x7c48e9,_0x53a35a)['toFile'](path[_0x4395('0xcc')](_0x9873f0,_0x4395('0xf1')+_0x17323b['id']+'-'+_0x26800b+_0x4395('0xf2')),function(_0x3c2ac1,_0x280d42){if(_0x3c2ac1)return _0x561ca9(_0x3c2ac1);_0x3aa8ed(_0x280d42);});});})[_0x4395('0x2b')](function(){return new BPromise(function(_0x2df85c,_0x5c2a2b){zipdir(_0x9873f0,{'saveTo':_0x1584d9},function(_0xaeb4bc,_0x470ec1){if(_0xaeb4bc)return _0x5c2a2b(_0xaeb4bc);return _0x2df85c(_0x470ec1);});})[_0x4395('0x2b')](function(){return new BPromise(function(_0x389810,_0x1dca27){rimraf(_0x9873f0,function(_0x1d8f27){if(_0x1d8f27)_0x1dca27(_0x1d8f27);return _0x389810();});});})['then'](function(){return _0x51972f[_0x4395('0xcb')](_0x1584d9,_0x3d1a6f,function(_0x4eb6c0){if(_0x4eb6c0){console[_0x4395('0xf3')](_0x4395('0xf4'),_0x4eb6c0);}else{fs[_0x4395('0xf5')](_0x1584d9);}});});});}else{return _0x51972f[_0x4395('0x20')](0xc8);}})[_0x4395('0xb5')](handleError(_0x51972f,null));};
git://repos.xcallymotion.com / motion2.git / blob