18 var _0xcf21=['total','closed','UserId','index','OpenchannelInteraction','fieldName','type','key','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','order','sort','where','pick','select','field','color','tools_tags','u.id','u.fullname','ui.OpenchannelInteractionId','user_has_openchannel_interactions','left_join','openchannel_interactions','cm_contacts','openchannel_messages','me.OpenchannelInteractionId\x20=\x20i.id','openchannel_interaction_has_tags','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','$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','text','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','User','operator','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','body','start','some','compact','OpenchannelAccountId','i.OpenchannelAccountId\x20IN\x20?','concat','createdAt','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','filter','replace','isNumeric','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?','i.id','Sequelize','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','contactName','isEmpty','resolve','i.OpenchannelAccountId\x20IS\x20NOT\x20NULL','user','role','agent','i.OpenchannelAccountId\x20IS\x20NULL','sequelize','toString','keyBy','a.key','Account.key','a.mandatoryDisposition','Account.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','c.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.mobile','Contact.mobile','Contact.fax','o.fullname','GROUP_CONCAT(DISTINCT\x20t.id)','ui.OpenchannelInteractionId\x20IN\x20?','all','rows','show','from','params','rawAttributes','includeAll','include','merge','options','catch','create','describe','addMessage','OpenchannelMessage','ids','getMessages','findOne','nolimit','OpenchannelInteractionId','$gte','findAll','addTags','setTags','omit','spread','emit','removeTags','download','unix','join','root','server','tmp','Contact','firstName','attachments','Attachment','direction','OpenchannelAccount','Account','Owner','get','N.A.','format','YYYY-MM-DD\x20HH:mm:ss','disposition','Public','Messages','basename','createReadStream','pipe','createWriteStream','lastName','secret','renderFile','views','downloadInteraction.ejs','transcript-','.pdf','Openchannel','log','err','unlinkSync','eml-format','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','ejs','lodash','squel','crypto','to-csv','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../components/export/pdf','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','register','sendStatus','end','status','json','offset','limit','count','set','apply','save','update','then','destroy','error','name','send','map','fullname','TagIds','split','forEach','Tags','push','waiting','talking','answered','unmanaged'];(function(_0x5ab89b,_0x5893ac){var _0x154a8a=function(_0x3b1dc5){while(--_0x3b1dc5){_0x5ab89b['push'](_0x5ab89b['shift']());}};_0x154a8a(++_0x5893ac);}(_0xcf21,0x19e));var _0x1cf2=function(_0x2766b3,_0x42ac7b){_0x2766b3=_0x2766b3-0x0;var _0x2a8580=_0xcf21[_0x2766b3];return _0x2a8580;};'use strict';var emlformat=require(_0x1cf2('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x1cf2('0x1'));var jsonpatch=require(_0x1cf2('0x2'));var rp=require(_0x1cf2('0x3'));var moment=require('moment');var BPromise=require(_0x1cf2('0x4'));var Mustache=require(_0x1cf2('0x5'));var util=require('util');var path=require(_0x1cf2('0x6'));var sox=require(_0x1cf2('0x7'));var csv=require('to-csv');var ejs=require(_0x1cf2('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x1cf2('0x9'));var squel=require(_0x1cf2('0xa'));var crypto=require(_0x1cf2('0xb'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x1cf2('0xc'));var querystring=require(_0x1cf2('0xd'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x1cf2('0xe'));var qs=require(_0x1cf2('0xf'));var as=require(_0x1cf2('0x10'));var pdf=require(_0x1cf2('0x11'));var hardwareService=require(_0x1cf2('0x12'));var logger=require(_0x1cf2('0x13'))('api');var utils=require(_0x1cf2('0x14'));var config=require(_0x1cf2('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x1cf2('0x16'))['db'];config[_0x1cf2('0x17')]=_[_0x1cf2('0x18')](config['redis'],{'host':_0x1cf2('0x19'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x1cf2('0x17')]));require('./openchannelInteraction.socket')[_0x1cf2('0x1a')](socket);function respondWithStatusCode(_0x2cccf1,_0x3a3bd6){_0x3a3bd6=_0x3a3bd6||0xcc;return function(_0x389fa4){if(_0x389fa4){return _0x2cccf1[_0x1cf2('0x1b')](_0x3a3bd6);}return _0x2cccf1['status'](_0x3a3bd6)[_0x1cf2('0x1c')]();};}function respondWithResult(_0x5ec5f5,_0x5bbfb9){_0x5bbfb9=_0x5bbfb9||0xc8;return function(_0x158718){if(_0x158718){return _0x5ec5f5[_0x1cf2('0x1d')](_0x5bbfb9)[_0x1cf2('0x1e')](_0x158718);}};}function respondWithFilteredResult(_0x2bbaef,_0xe2c2c4){return function(_0xc8ee1b){if(_0xc8ee1b){var _0x31dafa=typeof _0xe2c2c4[_0x1cf2('0x1f')]==='undefined'&&typeof _0xe2c2c4[_0x1cf2('0x20')]==='undefined';var _0x485d81=_0xc8ee1b[_0x1cf2('0x21')];var _0x111c7f=_0x31dafa?0x0:_0xe2c2c4[_0x1cf2('0x1f')];var _0x588ff7=_0x31dafa?_0xc8ee1b[_0x1cf2('0x21')]:_0xe2c2c4['offset']+_0xe2c2c4[_0x1cf2('0x20')];var _0x4bd5d5;if(_0x588ff7>=_0x485d81){_0x588ff7=_0x485d81;_0x4bd5d5=0xc8;}else{_0x4bd5d5=0xce;}_0x2bbaef['status'](_0x4bd5d5);return _0x2bbaef[_0x1cf2('0x22')]('Content-Range',_0x111c7f+'-'+_0x588ff7+'/'+_0x485d81)[_0x1cf2('0x1e')](_0xc8ee1b);}return null;};}function patchUpdates(_0x392444){return function(_0x526015){try{jsonpatch[_0x1cf2('0x23')](_0x526015,_0x392444,!![]);}catch(_0x3ccfcf){return BPromise['reject'](_0x3ccfcf);}return _0x526015[_0x1cf2('0x24')]();};}function saveUpdates(_0x49610b,_0x3f2328){return function(_0x349c7e){if(_0x349c7e){return _0x349c7e[_0x1cf2('0x25')](_0x49610b)[_0x1cf2('0x26')](function(_0x5c61fa){return _0x5c61fa;});}return null;};}function removeEntity(_0x184cf7,_0x830993){return function(_0x46ef76){if(_0x46ef76){return _0x46ef76[_0x1cf2('0x27')]()['then'](function(){_0x184cf7[_0x1cf2('0x1d')](0xcc)[_0x1cf2('0x1c')]();});}};}function handleEntityNotFound(_0x531a8e,_0x152324){return function(_0x4ddab){if(!_0x4ddab){_0x531a8e[_0x1cf2('0x1b')](0x194);}return _0x4ddab;};}function handleError(_0xced9ce,_0xbcf069){_0xbcf069=_0xbcf069||0x1f4;return function(_0x39af29){logger[_0x1cf2('0x28')](_0x39af29['stack']);if(_0x39af29['name']){delete _0x39af29[_0x1cf2('0x29')];}_0xced9ce[_0x1cf2('0x1d')](_0xbcf069)[_0x1cf2('0x2a')](_0x39af29);};}function getInteractionUsers(_0xd109d3,_0x11a742){return new BPromise(function(_0x274388,_0x39c68d){try{if(_0x11a742[_0xd109d3['id']]){_0xd109d3['Users']=_[_0x1cf2('0x2b')](_0x11a742[_0xd109d3['id']],function(_0xc19e6e){return{'id':_0xc19e6e['id'],'fullname':_0xc19e6e[_0x1cf2('0x2c')]};});}}catch(_0x4638ba){_0x39c68d(_0x4638ba);}_0x274388(_0xd109d3);});}function getInteractionTags(_0x2a71c3,_0x47f95c){return new BPromise(function(_0x56de7e,_0x3382a5){try{if(_0x2a71c3[_0x1cf2('0x2d')]){_0x2a71c3['Tags']=[];_0x2a71c3['TagIds'][_0x1cf2('0x2e')](',')[_0x1cf2('0x2f')](function(_0x383cb2){_0x2a71c3[_0x1cf2('0x30')][_0x1cf2('0x31')](_0x47f95c[_0x383cb2]);});}delete _0x2a71c3['TagIds'];}catch(_0x45b41a){_0x3382a5(_0x45b41a);}_0x56de7e(_0x2a71c3);});}function updateOpenchannelInteraction(_0x1708e3,_0x15de45,_0x3fef38){return new BPromise(function(_0x24f084,_0x3a704e){return getInteractionUsers(_0x1708e3,_0x3fef38)['then'](function(_0x55db4d){return getInteractionTags(_0x55db4d,_0x15de45);})[_0x1cf2('0x26')](function(_0x2efc47){return getStateInteraction(_0x2efc47);})[_0x1cf2('0x26')](function(_0xa37119){_0x24f084(_0xa37119);})['catch'](function(_0x5c006f){_0x3a704e(_0x5c006f);});});}function getStateInteraction(_0x51ce7c){return new BPromise(function(_0x996f7d){_0x51ce7c[_0x1cf2('0x32')]=0x0;_0x51ce7c[_0x1cf2('0x33')]=0x0;_0x51ce7c[_0x1cf2('0x34')]=0x0;_0x51ce7c[_0x1cf2('0x35')]=0x0;_0x51ce7c[_0x1cf2('0x36')]=0x0;if(!_0x51ce7c['closed']&&!_0x51ce7c['UserId']){_0x51ce7c[_0x1cf2('0x32')]+=0x1;}if(!_0x51ce7c[_0x1cf2('0x37')]&&_0x51ce7c[_0x1cf2('0x38')]){_0x51ce7c[_0x1cf2('0x33')]+=0x1;if(_0x51ce7c[_0x1cf2('0x32')]){_0x51ce7c[_0x1cf2('0x32')]-=0x1;}}if(_0x51ce7c[_0x1cf2('0x37')]&&_0x51ce7c[_0x1cf2('0x38')]){_0x51ce7c[_0x1cf2('0x34')]+=0x1;if(_0x51ce7c['talking']){_0x51ce7c['talking']-=0x1;}}if(_0x51ce7c[_0x1cf2('0x37')]&&!_0x51ce7c[_0x1cf2('0x38')]){_0x51ce7c['unmanaged']+=0x1;if(_0x51ce7c[_0x1cf2('0x32')]){_0x51ce7c[_0x1cf2('0x32')]-=0x1;}}_0x51ce7c[_0x1cf2('0x36')]+=0x1;_0x996f7d(_0x51ce7c);});}exports[_0x1cf2('0x39')]=function(_0x4f4ab3,_0xde50d6){var _0x1260f1={},_0x557c58={},_0x1375ba={'count':0x0,'rows':[]};var _0x350b66=_[_0x1cf2('0x2b')](db[_0x1cf2('0x3a')]['rawAttributes'],function(_0x29ba85){return{'name':_0x29ba85[_0x1cf2('0x3b')],'type':_0x29ba85[_0x1cf2('0x3c')][_0x1cf2('0x3d')]};});_0x557c58[_0x1cf2('0x3e')]=_[_0x1cf2('0x2b')](_0x350b66,_0x1cf2('0x29'));_0x557c58[_0x1cf2('0x3f')]=_[_0x1cf2('0x40')](_0x4f4ab3[_0x1cf2('0x3f')]);_0x557c58[_0x1cf2('0x41')]=_['intersection'](_0x557c58['model'],_0x557c58[_0x1cf2('0x3f')]);_0x1260f1[_0x1cf2('0x42')]=_[_0x1cf2('0x43')](_0x557c58['model'],qs[_0x1cf2('0x44')](_0x4f4ab3[_0x1cf2('0x3f')][_0x1cf2('0x44')]));_0x1260f1[_0x1cf2('0x42')]=_0x1260f1[_0x1cf2('0x42')][_0x1cf2('0x45')]?_0x1260f1[_0x1cf2('0x42')]:_0x557c58['model'];if(!_0x4f4ab3['query'][_0x1cf2('0x46')]('nolimit')){_0x1260f1[_0x1cf2('0x20')]=qs[_0x1cf2('0x20')](_0x4f4ab3[_0x1cf2('0x3f')]['limit']);_0x1260f1[_0x1cf2('0x1f')]=qs['offset'](_0x4f4ab3[_0x1cf2('0x3f')][_0x1cf2('0x1f')]);}_0x1260f1[_0x1cf2('0x47')]=qs[_0x1cf2('0x48')](_0x4f4ab3[_0x1cf2('0x3f')]['sort']);_0x1260f1[_0x1cf2('0x49')]=qs[_0x1cf2('0x41')](_[_0x1cf2('0x4a')](_0x4f4ab3[_0x1cf2('0x3f')],_0x557c58[_0x1cf2('0x41')]),_0x350b66);var _0x4a9c9d=[];var _0x3aca31=squel[_0x1cf2('0x4b')]()[_0x1cf2('0x4c')]('id')['field'](_0x1cf2('0x29'))[_0x1cf2('0x4c')](_0x1cf2('0x4d'))['from'](_0x1cf2('0x4e'));var _0xda8d99=squel[_0x1cf2('0x4b')]()[_0x1cf2('0x4c')](_0x1cf2('0x4f'))[_0x1cf2('0x4c')](_0x1cf2('0x50'))['field'](_0x1cf2('0x51'))['from'](_0x1cf2('0x52'),'ui')[_0x1cf2('0x53')]('users','u','u.id\x20=\x20ui.UserId');var _0xf28dbd=squel[_0x1cf2('0x4b')]()['from'](_0x1cf2('0x54'),'i')[_0x1cf2('0x53')](_0x1cf2('0x55'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x1cf2('0x53')]('users','o','o.id\x20=\x20i.UserId')[_0x1cf2('0x53')]('openchannel_accounts','a','a.id\x20=\x20i.OpenchannelAccountId')['left_join'](_0x1cf2('0x56'),'me',_0x1cf2('0x57'))[_0x1cf2('0x53')](_0x1cf2('0x58'),'it','it.OpenchannelInteractionId\x20=\x20i.id')[_0x1cf2('0x53')](_0x1cf2('0x4e'),'t',_0x1cf2('0x59'));var _0x3c1eb0=squel['expr']();var _0x4a2076=[];var _0x354d4a=squel[_0x1cf2('0x5a')]();var _0xdf0652;if(_0x4f4ab3[_0x1cf2('0x3f')][_0x1cf2('0x5b')]){_0xdf0652=as[_0x1cf2('0x5c')](_0x4f4ab3[_0x1cf2('0x3f')]['search']);var _0x31637c=_0xdf0652[_0x1cf2('0x5d')];for(var _0x31b64d=0x0;_0x31b64d<_0xdf0652[_0x1cf2('0x5e')]['length'];_0x31b64d++){var _0x4bc5b9=_0xdf0652[_0x1cf2('0x5e')][_0x31b64d];var _0x56db8b='i';var _0x1cd5cf=_[_0x1cf2('0x5f')](_0x350b66,['name',_0x4bc5b9[_0x1cf2('0x4c')]]);if(!_0x1cd5cf){switch(_0x4bc5b9['field']){case _0x1cf2('0x60'):if(_0x4bc5b9[_0x1cf2('0x61')]==0x1){_0xf28dbd[_0x1cf2('0x62')]('`'+_0x4bc5b9[_0x1cf2('0x4c')]+_0x1cf2('0x63'));}else{_0xf28dbd[_0x1cf2('0x62')]('`'+_0x4bc5b9[_0x1cf2('0x4c')]+_0x1cf2('0x64'));}break;case'Contact':if(_0x4bc5b9['operator']===_0x1cf2('0x65')){if(_0x4bc5b9[_0x1cf2('0x61')][_0x1cf2('0x2e')]('\x20')['length']>0x1){_0x3c1eb0[_0x31637c](_0x1cf2('0x66'),qs[_0x1cf2('0x67')](_0x4bc5b9['value']),null);}else{var _0x13d9e4='%'+_0x4bc5b9[_0x1cf2('0x61')]+'%';_0x3c1eb0[_0x31637c](_0x1cf2('0x68'),_0x13d9e4,_0x13d9e4,_0x13d9e4);}}else{_0x1cd5cf=_['find'](_0x350b66,['name',_0x1cf2('0x69')]);_0x4bc5b9[_0x1cf2('0x4c')]='ContactId';_0x437459=as[_0x1cf2('0x6a')](_0x56db8b,_0x1cd5cf[_0x1cf2('0x3c')],_0x4bc5b9);_0x3c1eb0[_0x31637c](_0x437459[_0x1cf2('0x6b')],_0x437459['value']['start'],_0x437459['value'][_0x1cf2('0x1c')]);}break;case _0x1cf2('0x6c'):var _0x27af52=_0x4bc5b9['value']['split'](',')[_0x1cf2('0x2b')](function(_0x2fca10){return Number(_0x2fca10);});_0x27af52[_0x1cf2('0x2f')](function(_0x4bbdc7){_0x354d4a['or'](_0x1cf2('0x6d'),'%,'+_0x4bbdc7+',%');});_0x4a2076=_['union'](_0x4a2076,_0x27af52);break;case _0x1cf2('0x6e'):if(_0x4bc5b9[_0x1cf2('0x6f')]===_0x1cf2('0x65')){_0x3c1eb0[_0x31637c](_0x1cf2('0x70'),'%'+_0x4bc5b9[_0x1cf2('0x61')]+'%',null);}else{_0x1cd5cf=_[_0x1cf2('0x5f')](_0x350b66,[_0x1cf2('0x29'),_0x1cf2('0x38')]);_0x4bc5b9['field']=_0x1cf2('0x38');_0x437459=as[_0x1cf2('0x6a')](_0x56db8b,_0x1cd5cf[_0x1cf2('0x3c')],_0x4bc5b9);_0x3c1eb0[_0x31637c](_0x437459[_0x1cf2('0x6b')],_0x437459['value']['start'],_0x437459[_0x1cf2('0x61')][_0x1cf2('0x1c')]);}break;case _0x1cf2('0x71'):_0x437459=as[_0x1cf2('0x6a')]('me',null,_0x4bc5b9);_0x3c1eb0[_0x31637c](_0x437459[_0x1cf2('0x6b')],_0x437459[_0x1cf2('0x61')][_0x1cf2('0x72')],_0x437459[_0x1cf2('0x61')][_0x1cf2('0x1c')]);break;}}else{var _0x437459=as['buildExpression'](_0x56db8b,_0x1cd5cf[_0x1cf2('0x3c')],_0x4bc5b9);_0x3c1eb0[_0x31637c](_0x437459[_0x1cf2('0x6b')],_0x437459[_0x1cf2('0x61')][_0x1cf2('0x72')],_0x437459[_0x1cf2('0x61')][_0x1cf2('0x1c')]);}}}else{var _0x256238=_(_0x4f4ab3[_0x1cf2('0x3f')])[_0x1cf2('0x40')]()['map'](function(_0xbb3d88){return _[_0x1cf2('0x73')](_0x350b66,[_0x1cf2('0x29'),_0xbb3d88])?_0xbb3d88:undefined;})[_0x1cf2('0x74')]()[_0x1cf2('0x61')]();if(!_['isEmpty'](_0x256238)){_0x256238[_0x1cf2('0x2f')](function(_0x37f44e){if(_0x37f44e===_0x1cf2('0x75')){_0xf28dbd[_0x1cf2('0x49')](_0x1cf2('0x76'),[][_0x1cf2('0x77')](_0x4f4ab3[_0x1cf2('0x3f')][_0x37f44e]));}else if(_0x37f44e===_0x1cf2('0x78')){var _0x22ffdb=JSON[_0x1cf2('0x79')](_0x4f4ab3['query'][_0x37f44e])['$gte'];var _0xee0ff9=JSON['parse'](_0x4f4ab3[_0x1cf2('0x3f')][_0x37f44e])[_0x1cf2('0x7a')];_0xf28dbd['where'](_0x1cf2('0x7b'),_0x22ffdb,_0xee0ff9);}else{if(_0x4f4ab3[_0x1cf2('0x3f')][_0x37f44e]===_0x1cf2('0x7c')){_0xf28dbd[_0x1cf2('0x49')]('i.'+_0x37f44e+_0x1cf2('0x7d'));}else{_0xf28dbd['where']('i.'+_0x37f44e+_0x1cf2('0x7e'),_0x4f4ab3[_0x1cf2('0x3f')][_0x37f44e]);}}});}if(_0x4f4ab3['query']['read']){if(_0x4f4ab3[_0x1cf2('0x3f')][_0x1cf2('0x7f')]==0x1){_0xf28dbd[_0x1cf2('0x62')](_0x1cf2('0x80'));}else{_0xf28dbd['having'](_0x1cf2('0x81'));}}if(_0x4f4ab3[_0x1cf2('0x3f')]['tag']){_0x4a2076=_['isArray'](_0x4f4ab3['query']['tag'])?_0x4f4ab3[_0x1cf2('0x3f')]['tag']:new Array(_0x4f4ab3['query'][_0x1cf2('0x82')]);_0x4a2076[_0x1cf2('0x2f')](function(_0x50d608){_0x354d4a['or'](_0x1cf2('0x6d'),'%,'+_0x50d608+',%');});}if(_0x4f4ab3[_0x1cf2('0x3f')][_0x1cf2('0x83')]){var _0x1553d8=_0x4f4ab3[_0x1cf2('0x3f')][_0x1cf2('0x83')][_0x1cf2('0x84')]('\x5c','\x5c\x5c')[_0x1cf2('0x84')](/'/g,'\x27\x27');if(qs[_0x1cf2('0x85')](_0x1553d8)){_0x3c1eb0['or'](_0x1cf2('0x86'),_0x1553d8+'%');}else{_0x3c1eb0['or'](_0x1cf2('0x87'),qs[_0x1cf2('0x67')](_0x1553d8))['or'](_0x1cf2('0x88'),_0x1553d8+'%')['or'](_0x1cf2('0x89'),_0x1553d8+'%');}}}_0xf28dbd[_0x1cf2('0x49')](_0x3c1eb0);_0xf28dbd['group'](_0x1cf2('0x8a'));var _0x3b08a8={'type':db[_0x1cf2('0x8b')]['QueryTypes'][_0x1cf2('0x8c')],'raw':!![]};var _0x1e2556=_0xf28dbd[_0x1cf2('0x8d')]();_0x1e2556[_0x1cf2('0x4c')](_0x1cf2('0x8a'));_0x1e2556[_0x1cf2('0x4c')](_0x1cf2('0x8e'),_0x1cf2('0x60'));if(_0x1260f1[_0x1cf2('0x47')]){_0x1260f1[_0x1cf2('0x47')]['forEach'](function(_0x34db5){var _0x2cb340=_0x34db5[0x0]===_0x1cf2('0x8f')?_0x34db5[0x0]:'i.'+_0x34db5[0x0];_0xf28dbd[_0x1cf2('0x47')](_0x2cb340,_0x34db5[0x1]==='DESC'?![]:!![]);});}if(!_[_0x1cf2('0x90')](_0x4a2076)){_0xf28dbd[_0x1cf2('0x62')](_0x354d4a);_0x1e2556[_0x1cf2('0x49')]('t.id\x20IN\x20?',_0x4a2076);}BPromise[_0x1cf2('0x91')]()['then'](function(){if(!_0xdf0652){if(_0x4f4ab3[_0x1cf2('0x3f')][_0x1cf2('0x75')])return;_0x1e2556['where']('i.OpenchannelAccountId\x20IS\x20NOT\x20NULL');_0xf28dbd[_0x1cf2('0x49')](_0x1cf2('0x92'));return;}if(_0x4f4ab3[_0x1cf2('0x93')][_0x1cf2('0x94')]!==_0x1cf2('0x95'))return;return _0x4f4ab3[_0x1cf2('0x93')]['getOpenchannelAccounts']({'attributes':['id'],'raw':!![]})[_0x1cf2('0x26')](function(_0x4faeb0){if(_['isEmpty'](_0x4faeb0)){_0x1e2556[_0x1cf2('0x49')](_0x1cf2('0x96'));_0xf28dbd[_0x1cf2('0x49')]('i.OpenchannelAccountId\x20IS\x20NULL');}else{_0x1e2556[_0x1cf2('0x49')]('i.OpenchannelAccountId\x20IN\x20?',_[_0x1cf2('0x2b')](_0x4faeb0,'id'));_0xf28dbd[_0x1cf2('0x49')]('i.OpenchannelAccountId\x20IN\x20?',_[_0x1cf2('0x2b')](_0x4faeb0,'id'));}});})[_0x1cf2('0x26')](function(){if(_0x4f4ab3[_0x1cf2('0x93')][_0x1cf2('0x94')]==='agent'&&!_0xdf0652&&!_0x4f4ab3[_0x1cf2('0x3f')]['OpenchannelAccountId'])return[];return db['sequelize'][_0x1cf2('0x3f')](_0x1e2556['toString'](),_0x3b08a8);})[_0x1cf2('0x26')](function(_0x4ffd75){_0x1375ba[_0x1cf2('0x21')]=_0x4ffd75['length'];if(_0x1375ba['count']===0x0)return[];return db[_0x1cf2('0x97')]['query'](_0x3aca31[_0x1cf2('0x98')](),_0x3b08a8)[_0x1cf2('0x26')](function(_0x5b7d6d){_0x4a9c9d=_[_0x1cf2('0x99')](_0x5b7d6d,'id');_0x3b08a8=_['merge'](_0x3b08a8,{'model':db[_0x1cf2('0x3a')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x4f4ab3[_0x1cf2('0x3f')][_0x1cf2('0x44')]){_0x1260f1[_0x1cf2('0x42')][_0x1cf2('0x2f')](function(_0x590293){_0xf28dbd[_0x1cf2('0x4c')]('i.'+_0x590293);});}else{_0xf28dbd[_0x1cf2('0x4c')](_0x1cf2('0x8e'),_0x1cf2('0x60'));_0xf28dbd['field'](_0x1cf2('0x9a'),_0x1cf2('0x9b'));_0xf28dbd[_0x1cf2('0x4c')](_0x1cf2('0x9c'),_0x1cf2('0x9d'));_0xf28dbd[_0x1cf2('0x4c')](_0x1cf2('0x9e'),_0x1cf2('0x8f'));_0xf28dbd[_0x1cf2('0x4c')]('i.*');_0xf28dbd['field'](_0x1cf2('0x9f'),'Contact.firstName');_0xf28dbd['field'](_0x1cf2('0xa0'),_0x1cf2('0xa1'));_0xf28dbd[_0x1cf2('0x4c')](_0x1cf2('0xa2'),_0x1cf2('0xa3'));_0xf28dbd['field']('c.phone','Contact.phone');_0xf28dbd['field'](_0x1cf2('0xa4'),_0x1cf2('0xa5'));_0xf28dbd['field']('c.fax',_0x1cf2('0xa6'));_0xf28dbd[_0x1cf2('0x4c')](_0x1cf2('0xa7'),'Owner.fullname');_0xf28dbd[_0x1cf2('0x4c')]('o.internal','Owner.internal');_0xf28dbd[_0x1cf2('0x4c')](_0x1cf2('0xa8'),_0x1cf2('0x2d'));}if(_0x1260f1[_0x1cf2('0x20')])_0xf28dbd[_0x1cf2('0x20')](_0x1260f1[_0x1cf2('0x20')]);if(_0x1260f1[_0x1cf2('0x1f')])_0xf28dbd[_0x1cf2('0x1f')](_0x1260f1[_0x1cf2('0x1f')]);return db[_0x1cf2('0x97')][_0x1cf2('0x3f')](_0xf28dbd[_0x1cf2('0x98')](),_0x3b08a8);})[_0x1cf2('0x26')](function(_0x4efb70){if(_0x4efb70[_0x1cf2('0x45')]>0x0)_0xda8d99[_0x1cf2('0x49')](_0x1cf2('0xa9'),_[_0x1cf2('0x2b')](_0x4efb70,'id'));return db[_0x1cf2('0x97')][_0x1cf2('0x3f')](_0xda8d99[_0x1cf2('0x98')](),_0x3b08a8)[_0x1cf2('0x26')](function(_0x1cae95){var _0x291108=_['groupBy'](_0x1cae95,'OpenchannelInteractionId');var _0x34e174=[];_0x4efb70[_0x1cf2('0x2f')](function(_0x2da5a){_0x34e174[_0x1cf2('0x31')](updateOpenchannelInteraction(_0x2da5a,_0x4a9c9d,_0x291108));});return BPromise[_0x1cf2('0xaa')](_0x34e174);});});})[_0x1cf2('0x26')](function(_0x2d2494){_0x1375ba[_0x1cf2('0xab')]=_0x2d2494;return _0x1375ba;})[_0x1cf2('0x26')](respondWithFilteredResult(_0xde50d6,_0x1260f1))['catch'](handleError(_0xde50d6,null));};exports[_0x1cf2('0xac')]=function(_0x3c5e99,_0x31e037){var _0x9cb597={};if(_0x3c5e99[_0x1cf2('0x3f')][_0x1cf2('0x3c')]&&_0x3c5e99['query'][_0x1cf2('0x3c')]==='from'){_0x9cb597[_0x1cf2('0xad')]=_0x3c5e99[_0x1cf2('0xae')]['id'];}else{_0x9cb597['id']=_0x3c5e99[_0x1cf2('0xae')]['id'];}var _0x367953={'raw':![],'where':_0x9cb597},_0x3615aa={};_0x3615aa[_0x1cf2('0x3e')]=_['keys'](db['OpenchannelInteraction'][_0x1cf2('0xaf')]);_0x3615aa['query']=_['keys'](_0x3c5e99['query']);_0x3615aa[_0x1cf2('0x41')]=_[_0x1cf2('0x43')](_0x3615aa[_0x1cf2('0x3e')],_0x3615aa[_0x1cf2('0x3f')]);_0x367953[_0x1cf2('0x42')]=_['intersection'](_0x3615aa[_0x1cf2('0x3e')],qs[_0x1cf2('0x44')](_0x3c5e99['query'][_0x1cf2('0x44')]));_0x367953['attributes']=_0x367953[_0x1cf2('0x42')][_0x1cf2('0x45')]?_0x367953[_0x1cf2('0x42')]:_0x3615aa[_0x1cf2('0x3e')];if(_0x3c5e99[_0x1cf2('0x3f')][_0x1cf2('0xb0')]){_0x367953[_0x1cf2('0xb1')]=[{'all':!![]}];}_0x367953=_[_0x1cf2('0xb2')]({},_0x367953,_0x3c5e99[_0x1cf2('0xb3')]);return db['OpenchannelInteraction'][_0x1cf2('0x5f')](_0x367953)['then'](handleEntityNotFound(_0x31e037,null))[_0x1cf2('0x26')](respondWithResult(_0x31e037,null))[_0x1cf2('0xb4')](handleError(_0x31e037,null));};exports[_0x1cf2('0xb5')]=function(_0x115656,_0x3395f5){return db[_0x1cf2('0x3a')]['create'](_0x115656['body'],{})['then'](respondWithResult(_0x3395f5,0xc9))[_0x1cf2('0xb4')](handleError(_0x3395f5,null));};exports[_0x1cf2('0x25')]=function(_0x21847a,_0x360f3a){if(_0x21847a[_0x1cf2('0x71')]['id']){delete _0x21847a[_0x1cf2('0x71')]['id'];}return db['OpenchannelInteraction'][_0x1cf2('0x5f')]({'where':{'id':_0x21847a[_0x1cf2('0xae')]['id']}})[_0x1cf2('0x26')](handleEntityNotFound(_0x360f3a,null))[_0x1cf2('0x26')](saveUpdates(_0x21847a['body'],null))[_0x1cf2('0x26')](respondWithResult(_0x360f3a,null))[_0x1cf2('0xb4')](handleError(_0x360f3a,null));};exports[_0x1cf2('0x27')]=function(_0x37e827,_0x20add9){return db[_0x1cf2('0x3a')][_0x1cf2('0x5f')]({'where':{'id':_0x37e827['params']['id']}})[_0x1cf2('0x26')](handleEntityNotFound(_0x20add9,null))[_0x1cf2('0x26')](removeEntity(_0x20add9,null))[_0x1cf2('0xb4')](handleError(_0x20add9,null));};exports[_0x1cf2('0xb6')]=function(_0x1a4f2f,_0x389ede){return db[_0x1cf2('0x3a')][_0x1cf2('0xb6')]()['then'](respondWithResult(_0x389ede,null))[_0x1cf2('0xb4')](handleError(_0x389ede,null));};exports[_0x1cf2('0xb7')]=function(_0x3c4253,_0x3b8d0d,_0x3c01c9){return db[_0x1cf2('0xb8')]['find']({'where':{'id':_0x3c4253['params']['id']}})[_0x1cf2('0x26')](handleEntityNotFound(_0x3b8d0d,null))[_0x1cf2('0x26')](function(_0x4c7848){if(_0x4c7848){return _0x4c7848['addMessage'](_0x3c4253[_0x1cf2('0x71')][_0x1cf2('0xb9')],_['omit'](_0x3c4253[_0x1cf2('0x71')],['ids','id'])||{});}})[_0x1cf2('0x26')](respondWithResult(_0x3b8d0d,null))[_0x1cf2('0xb4')](handleError(_0x3b8d0d,null));};exports[_0x1cf2('0xba')]=function(_0x5468c0,_0x5333d0,_0x51b86a){var _0xad4d22={'raw':![],'where':{}};var _0x3a9bbc={};var _0x347ead={'count':0x0,'rows':[]};return db[_0x1cf2('0x3a')][_0x1cf2('0xbb')]({'where':{'id':_0x5468c0[_0x1cf2('0xae')]['id']}})[_0x1cf2('0x26')](handleEntityNotFound(_0x5333d0,null))['then'](function(_0x12830f){if(_0x12830f){_0x3a9bbc['model']=_[_0x1cf2('0x40')](db[_0x1cf2('0xb8')][_0x1cf2('0xaf')]);_0x3a9bbc[_0x1cf2('0x3f')]=_[_0x1cf2('0x40')](_0x5468c0[_0x1cf2('0x3f')]);_0x3a9bbc[_0x1cf2('0x41')]=_['intersection'](_0x3a9bbc['model'],_0x3a9bbc[_0x1cf2('0x3f')]);_0xad4d22[_0x1cf2('0x42')]=_[_0x1cf2('0x43')](_0x3a9bbc[_0x1cf2('0x3e')],qs[_0x1cf2('0x44')](_0x5468c0['query']['fields']));_0xad4d22[_0x1cf2('0x42')]=_0xad4d22[_0x1cf2('0x42')]['length']?_0xad4d22[_0x1cf2('0x42')]:_0x3a9bbc[_0x1cf2('0x3e')];if(!_0x5468c0[_0x1cf2('0x3f')][_0x1cf2('0x46')](_0x1cf2('0xbc'))){_0xad4d22['limit']=qs[_0x1cf2('0x20')](_0x5468c0['query'][_0x1cf2('0x20')]);_0xad4d22[_0x1cf2('0x1f')]=qs[_0x1cf2('0x1f')](_0x5468c0['query'][_0x1cf2('0x1f')]);}_0xad4d22[_0x1cf2('0x47')]=qs[_0x1cf2('0x48')](_0x5468c0[_0x1cf2('0x3f')]['sort']);_0xad4d22[_0x1cf2('0x49')]=qs[_0x1cf2('0x41')](_[_0x1cf2('0x4a')](_0x5468c0[_0x1cf2('0x3f')],_0x3a9bbc['filters']));_0xad4d22[_0x1cf2('0x49')][_0x1cf2('0xbd')]=_0x12830f['id'];if(_0x5468c0['query'][_0x1cf2('0x83')]){_0xad4d22[_0x1cf2('0x49')]=_[_0x1cf2('0xb2')](_0xad4d22['where'],{'$or':_[_0x1cf2('0x2b')](_0xad4d22['attributes'],function(_0x495561){var _0x4b9160={};_0x4b9160[_0x495561]={'$like':'%'+_0x5468c0[_0x1cf2('0x3f')]['filter']+'%'};return _0x4b9160;})});}if(_0x5468c0[_0x1cf2('0x3f')][_0x1cf2('0xbe')]){var _0x18f9a6=_0x5468c0['query'][_0x1cf2('0xbe')][_0x1cf2('0x2e')](',');var _0x2eab24={};_0x2eab24[_0x18f9a6[0x0]]={'$gte':moment(_0x18f9a6[0x1])['format']('YYYY-MM-DD\x20HH:mm:ss')};_0xad4d22[_0x1cf2('0x49')]=_[_0x1cf2('0xb2')](_0xad4d22[_0x1cf2('0x49')],_0x2eab24);}_0xad4d22=_[_0x1cf2('0xb2')]({},_0xad4d22,_0x5468c0['options']);return db[_0x1cf2('0xb8')]['count']({'where':_0xad4d22['where']})[_0x1cf2('0x26')](function(_0x526963){_0x347ead[_0x1cf2('0x21')]=_0x526963;if(_0x5468c0[_0x1cf2('0x3f')][_0x1cf2('0xb0')]){_0xad4d22[_0x1cf2('0xb1')]=[{'all':!![]}];}return db[_0x1cf2('0xb8')][_0x1cf2('0xbf')](_0xad4d22);})[_0x1cf2('0x26')](function(_0x59a8b5){_0x347ead['rows']=_0x59a8b5;return _0x347ead;});}})['then'](respondWithFilteredResult(_0x5333d0,_0xad4d22))[_0x1cf2('0xb4')](handleError(_0x5333d0,null));};exports[_0x1cf2('0xc0')]=function(_0x13a5ea,_0x58f1c9,_0x346bd2){return db[_0x1cf2('0x3a')][_0x1cf2('0x5f')]({'where':{'id':_0x13a5ea[_0x1cf2('0xae')]['id']}})[_0x1cf2('0x26')](handleEntityNotFound(_0x58f1c9,null))[_0x1cf2('0x26')](function(_0x17d759){if(_0x17d759){return _0x17d759[_0x1cf2('0xc1')](_0x13a5ea[_0x1cf2('0x71')][_0x1cf2('0xb9')],_[_0x1cf2('0xc2')](_0x13a5ea['body'],['ids','id'])||{})[_0x1cf2('0xc3')](function(){return db['Tag'][_0x1cf2('0xbf')]({'attributes':['id',_0x1cf2('0x29'),'color'],'where':{'id':_0x13a5ea[_0x1cf2('0x71')][_0x1cf2('0xb9')]}});})[_0x1cf2('0x26')](function(_0x3728bd){socket[_0x1cf2('0xc4')]('openchannelInteractionTags:save',{'id':Number(_0x13a5ea[_0x1cf2('0xae')]['id']),'tags':_0x3728bd||[]});return{'id':Number(_0x13a5ea[_0x1cf2('0xae')]['id']),'tags':_0x3728bd||[]};});}})['then'](respondWithResult(_0x58f1c9,null))['catch'](handleError(_0x58f1c9,null));};exports[_0x1cf2('0xc5')]=function(_0xe0efe,_0x49a46a,_0x41dad3){return db[_0x1cf2('0x3a')][_0x1cf2('0x5f')]({'where':{'id':_0xe0efe['params']['id']}})['then'](handleEntityNotFound(_0x49a46a,null))['then'](function(_0x369989){if(_0x369989){return _0x369989['removeTags'](_0xe0efe[_0x1cf2('0x3f')][_0x1cf2('0xb9')]);}})[_0x1cf2('0x26')](respondWithStatusCode(_0x49a46a,null))[_0x1cf2('0xb4')](handleError(_0x49a46a,null));};exports[_0x1cf2('0xc6')]=function(_0x4543a0,_0x4fbce0){var _0x3b93f1=moment()[_0x1cf2('0xc7')]()[_0x1cf2('0x98')]();var _0x6f7d45=path[_0x1cf2('0xc8')](config[_0x1cf2('0xc9')],_0x1cf2('0xca'),'files',_0x1cf2('0xcb'));var _0x562345=path[_0x1cf2('0xc8')](config[_0x1cf2('0xc9')],_0x1cf2('0xca'),'files','attachments');var _0x151876=path[_0x1cf2('0xc8')](_0x6f7d45,_0x3b93f1);var _0xa3c2a5=util['format']('transcript-%d-%s.zip',_0x4543a0[_0x1cf2('0xae')]['id'],_0x3b93f1);var _0x9173ec=path['join'](_0x6f7d45,_0xa3c2a5);var _0x45c247=[];_0x45c247[_0x1cf2('0x31')]({'model':db[_0x1cf2('0x6e')],'as':'User','attributes':['id',_0x1cf2('0x2c')],'raw':!![]});_0x45c247[_0x1cf2('0x31')]({'model':db['CmContact'],'as':_0x1cf2('0xcc'),'attributes':['id',_0x1cf2('0xcd'),'lastName'],'raw':!![]});if(_0x4543a0['query'][_0x1cf2('0xce')]){_0x45c247['push']({'model':db['Attachment'],'as':_0x1cf2('0xcf'),'raw':!![]});}var _0x1a279b=[{'model':db[_0x1cf2('0xb8')],'as':'Messages','attributes':['id','body','createdAt',_0x1cf2('0xd0'),'secret',_0x1cf2('0x7f')],'include':_0x45c247}];_0x1a279b[_0x1cf2('0x31')]({'model':db[_0x1cf2('0xd1')],'as':_0x1cf2('0xd2'),'attributes':['id',_0x1cf2('0x29')]});_0x1a279b[_0x1cf2('0x31')]({'model':db[_0x1cf2('0x6e')],'as':_0x1cf2('0xd3'),'attributes':['id',_0x1cf2('0x2c')]});return db[_0x1cf2('0x3a')][_0x1cf2('0x5f')]({'where':{'id':_0x4543a0['params']['id']},'include':_0x1a279b})[_0x1cf2('0x26')](handleEntityNotFound(_0x4fbce0,null))[_0x1cf2('0x26')](function(_0x1e02a5){if(_0x1e02a5){var _0xbd4003=_0x1e02a5[_0x1cf2('0xd4')]({'plain':!![]});fs['mkdirSync'](_0x151876);var _0x12e907={'channel':'Openchannel','account':_0xbd4003['Account'][_0x1cf2('0x29')],'agent':_0xbd4003[_0x1cf2('0xd3')]?_0xbd4003[_0x1cf2('0xd3')]['fullname']:_0x1cf2('0xd5'),'createdAt':moment(_0xbd4003['createdAt'])[_0x1cf2('0xd6')](_0x1cf2('0xd7'))[_0x1cf2('0x98')](),'closedAt':_0xbd4003['closed']?moment(_0xbd4003['closedAt'])[_0x1cf2('0xd6')](_0x1cf2('0xd7'))['toString']():'','disposition':_0xbd4003[_0x1cf2('0xd8')],'visibility':_0xbd4003['threadId']?_0x1cf2('0xd9'):'Private','messages':_(_0xbd4003[_0x1cf2('0xda')])['filter']({'secret':![]})['map'](function(_0x23eead){if(_0x23eead[_0x1cf2('0xcf')]){var _0x5f11e1=path['join'](_0x562345,_0x23eead[_0x1cf2('0xcf')][_0x1cf2('0xdb')]);if(fs['existsSync'](_0x5f11e1)){fs[_0x1cf2('0xdc')](_0x5f11e1)[_0x1cf2('0xdd')](fs[_0x1cf2('0xde')](path[_0x1cf2('0xc8')](_0x151876,_0x23eead[_0x1cf2('0xcf')][_0x1cf2('0xdb')])));}}return{'date':moment(_0x23eead[_0x1cf2('0x78')])[_0x1cf2('0xd6')](_0x1cf2('0xd7'))[_0x1cf2('0x98')](),'sender':_0x23eead[_0x1cf2('0xd0')]==='out'?_0x23eead['User']?_0x23eead[_0x1cf2('0x6e')][_0x1cf2('0x2c')]:'System':_0x23eead[_0x1cf2('0xcc')][_0x1cf2('0xcd')]+(_0x23eead[_0x1cf2('0xcc')][_0x1cf2('0xdf')]?'\x20'+_0x23eead[_0x1cf2('0xcc')][_0x1cf2('0xdf')]:''),'body':_0x23eead[_0x1cf2('0xcf')]?_0x23eead[_0x1cf2('0xcf')][_0x1cf2('0xdb')]:_0x23eead[_0x1cf2('0x71')],'direction':_0x23eead[_0x1cf2('0xd0')]==='out'?'A':'C','secret':_0x23eead[_0x1cf2('0xe0')],'read':_0x23eead['read'],'attachment':_0x23eead[_0x1cf2('0xcf')]};})['value']()};return ejs[_0x1cf2('0xe1')](path['join'](config[_0x1cf2('0xc9')],'server',_0x1cf2('0xe2'),_0x1cf2('0xe3')),{'interaction':_0x12e907})[_0x1cf2('0x26')](function(_0x39a50d){var _0x1075c3=path[_0x1cf2('0xc8')](_0x151876,_0x1cf2('0xe4')+_0xbd4003['id']+'-'+_0x3b93f1+_0x1cf2('0xe5'));var _0x5b9282={'path':_0x1075c3,'channel':_0x1cf2('0xe6'),'interactionId':_0xbd4003['id']};return pdf['createPdfFromHTML'](_0x39a50d,_0x5b9282);})[_0x1cf2('0x26')](function(){return new BPromise(function(_0x5ef977,_0x53488f){zipdir(_0x151876,{'saveTo':_0x9173ec},function(_0x4623e0,_0x28b3e7){if(_0x4623e0)return _0x53488f(_0x4623e0);return _0x5ef977(_0x28b3e7);});})['then'](function(){return new BPromise(function(_0x3c637e,_0x96313d){rimraf(_0x151876,function(_0x4cdb85){if(_0x4cdb85)_0x96313d(_0x4cdb85);return _0x3c637e();});});})[_0x1cf2('0x26')](function(){return _0x4fbce0[_0x1cf2('0xc6')](_0x9173ec,_0xa3c2a5,function(_0x5aa436){if(_0x5aa436){console[_0x1cf2('0xe7')](_0x1cf2('0xe8'),_0x5aa436);}else{fs[_0x1cf2('0xe9')](_0x9173ec);}});});});}else{return _0x4fbce0[_0x1cf2('0x1b')](0xc8);}})['catch'](handleError(_0x4fbce0,null));};
git://repos.xcallymotion.com / motion2.git / blob