// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x326f=['status','end','json','limit','apply','update','then','error','stack','name','Users','map','fullname','TagIds','Tags','split','push','catch','index','type','model','keys','query','intersection','attributes','fields','length','hasOwnProperty','offset','order','sort','where','filters','pick','select','field','color','from','tools_tags','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','openchannel_messages','me.OpenchannelInteractionId\x20=\x20i.id','openchannel_interaction_has_tags','it.OpenchannelInteractionId\x20=\x20i.id','expr','search','parseSearch','sqlOperator','conditions','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','value','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?','find','ContactId','buildExpression','text','start','Tag','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','UserId','body','compact','isEmpty','i.OpenchannelAccountId\x20IN\x20?','concat','createdAt','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','filter','replace','isNumeric','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','Sequelize','QueryTypes','clone','i.id','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','contactName','DESC','t.id\x20IN\x20?','OpenchannelAccountId','role','agent','i.OpenchannelAccountId\x20IS\x20NULL','user','sequelize','toString','count','keyBy','merge','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','i.*','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.OpenchannelInteractionId\x20IN\x20?','groupBy','OpenchannelInteractionId','rows','show','OpenchannelInteraction','rawAttributes','includeAll','include','options','create','params','destroy','describe','addMessage','OpenchannelMessage','ids','getMessages','findOne','format','YYYY-MM-DD\x20HH:mm:ss','findAll','addTags','setTags','omit','spread','emit','openchannelInteractionTags:save','removeTags','download','unix','join','root','server','files','transcript-%d-%s.zip','User','CmContact','firstName','lastName','Messages','secret','read','OpenchannelAccount','get','mkdirSync','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>','30px','<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>','%s\x20#%d','Openchannel','Owner','closed','closedAt','threadId','Private','pipe','createWriteStream','Attachment','basename','direction','out','System','renderFile','views','downloadInteraction.html','toFile','transcript-','.pdf','err','unlinkSync','html-pdf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','lodash','squel','crypto','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/license/util','redis','defaults','localhost','socket.io-emitter','./openchannelInteraction.socket','sendStatus'];(function(_0x20d0b9,_0x2f67c4){var _0xf4cdcc=function(_0xb80c85){while(--_0xb80c85){_0x20d0b9['push'](_0x20d0b9['shift']());}};_0xf4cdcc(++_0x2f67c4);}(_0x326f,0xd1));var _0xf326=function(_0x5dc2ba,_0x30a7c8){_0x5dc2ba=_0x5dc2ba-0x0;var _0x4636ad=_0x326f[_0x5dc2ba];return _0x4636ad;};'use strict';var pdf=require(_0xf326('0x0'));var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xf326('0x1'));var jsonpatch=require(_0xf326('0x2'));var rp=require(_0xf326('0x3'));var moment=require(_0xf326('0x4'));var BPromise=require(_0xf326('0x5'));var Mustache=require(_0xf326('0x6'));var util=require(_0xf326('0x7'));var path=require(_0xf326('0x8'));var sox=require(_0xf326('0x9'));var csv=require(_0xf326('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xf326('0xb'));var squel=require(_0xf326('0xc'));var crypto=require(_0xf326('0xd'));var jsforce=require(_0xf326('0xe'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xf326('0xf'));var Redis=require(_0xf326('0x10'));var authService=require(_0xf326('0x11'));var qs=require(_0xf326('0x12'));var as=require(_0xf326('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xf326('0x14'))('api');var utils=require(_0xf326('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0xf326('0x16'));var db=require('../../mysqldb')['db'];config[_0xf326('0x17')]=_[_0xf326('0x18')](config['redis'],{'host':_0xf326('0x19'),'port':0x18eb});var socket=require(_0xf326('0x1a'))(new Redis(config[_0xf326('0x17')]));require(_0xf326('0x1b'))['register'](socket);function respondWithStatusCode(_0x45c1b6,_0x5204ee){_0x5204ee=_0x5204ee||0xcc;return function(_0x54bd1a){if(_0x54bd1a){return _0x45c1b6[_0xf326('0x1c')](_0x5204ee);}return _0x45c1b6[_0xf326('0x1d')](_0x5204ee)[_0xf326('0x1e')]();};}function respondWithResult(_0xa63d1a,_0x292f4b){_0x292f4b=_0x292f4b||0xc8;return function(_0x287a2a){if(_0x287a2a){return _0xa63d1a[_0xf326('0x1d')](_0x292f4b)[_0xf326('0x1f')](_0x287a2a);}};}function respondWithFilteredResult(_0x5a682a,_0x3ad7da){return function(_0x453100){if(_0x453100){var _0x18bee3=_0x453100['count'],_0x31ffb9=_0x3ad7da['offset'],_0xcef2b5=_0x3ad7da['offset']+_0x3ad7da[_0xf326('0x20')],_0x311af0;if(_0xcef2b5>=_0x18bee3){_0xcef2b5=_0x18bee3;_0x311af0=0xc8;}else{_0x311af0=0xce;}_0x5a682a[_0xf326('0x1d')](_0x311af0);return _0x5a682a['set']('Content-Range',_0x31ffb9+'-'+_0xcef2b5+'/'+_0x18bee3)[_0xf326('0x1f')](_0x453100);}return null;};}function patchUpdates(_0x4dfa76){return function(_0x5b6d3c){try{jsonpatch[_0xf326('0x21')](_0x5b6d3c,_0x4dfa76,!![]);}catch(_0x18ead3){return BPromise['reject'](_0x18ead3);}return _0x5b6d3c['save']();};}function saveUpdates(_0x19b8ba,_0xb1efcf){return function(_0x5f21a2){if(_0x5f21a2){return _0x5f21a2[_0xf326('0x22')](_0x19b8ba)[_0xf326('0x23')](function(_0x43c53e){return _0x43c53e;});}return null;};}function removeEntity(_0x295752,_0x17c157){return function(_0x2049ec){if(_0x2049ec){return _0x2049ec['destroy']()['then'](function(){_0x295752['status'](0xcc)[_0xf326('0x1e')]();});}};}function handleEntityNotFound(_0x1a2c4e,_0x2cd45a){return function(_0x1ff2b5){if(!_0x1ff2b5){_0x1a2c4e[_0xf326('0x1c')](0x194);}return _0x1ff2b5;};}function handleError(_0x410237,_0x5217d4){_0x5217d4=_0x5217d4||0x1f4;return function(_0x201d28){logger[_0xf326('0x24')](_0x201d28[_0xf326('0x25')]);if(_0x201d28['name']){delete _0x201d28[_0xf326('0x26')];}_0x410237['status'](_0x5217d4)['send'](_0x201d28);};}function getInteractionUsers(_0x6a8e89,_0x1ae23a){return new BPromise(function(_0x2fa28e,_0x5dbe63){try{if(_0x1ae23a[_0x6a8e89['id']]){_0x6a8e89[_0xf326('0x27')]=_[_0xf326('0x28')](_0x1ae23a[_0x6a8e89['id']],function(_0x55790d){return{'id':_0x55790d['id'],'fullname':_0x55790d[_0xf326('0x29')]};});}}catch(_0x119ab8){_0x5dbe63(_0x119ab8);}_0x2fa28e(_0x6a8e89);});}function getInteractionTags(_0xd77aba,_0x18d110){return new BPromise(function(_0xa80156,_0x269be9){try{if(_0xd77aba[_0xf326('0x2a')]){_0xd77aba[_0xf326('0x2b')]=[];_0xd77aba[_0xf326('0x2a')][_0xf326('0x2c')](',')['forEach'](function(_0x1035ed){_0xd77aba[_0xf326('0x2b')][_0xf326('0x2d')](_0x18d110[_0x1035ed]);});}delete _0xd77aba['TagIds'];}catch(_0x2c0cac){_0x269be9(_0x2c0cac);}_0xa80156(_0xd77aba);});}function updateOpenchannelInteraction(_0x1721fd,_0x303dc6,_0x4df451){return new BPromise(function(_0x5b101d,_0x2b8b31){return getInteractionUsers(_0x1721fd,_0x4df451)[_0xf326('0x23')](function(_0x9c3039){return getInteractionTags(_0x9c3039,_0x303dc6);})[_0xf326('0x23')](function(_0x30694f){_0x5b101d(_0x30694f);})[_0xf326('0x2e')](function(_0x62585a){_0x2b8b31(_0x62585a);});});}exports[_0xf326('0x2f')]=function(_0x580374,_0x461e93){var _0x1981bc={},_0x51207a={},_0x4083a2={'count':0x0,'rows':[]};var _0x4e5d7c=_[_0xf326('0x28')](db['OpenchannelInteraction']['rawAttributes'],function(_0xadb020){return{'name':_0xadb020['fieldName'],'type':_0xadb020[_0xf326('0x30')]['key']};});_0x51207a[_0xf326('0x31')]=_[_0xf326('0x28')](_0x4e5d7c,_0xf326('0x26'));_0x51207a['query']=_[_0xf326('0x32')](_0x580374[_0xf326('0x33')]);_0x51207a['filters']=_[_0xf326('0x34')](_0x51207a[_0xf326('0x31')],_0x51207a[_0xf326('0x33')]);_0x1981bc[_0xf326('0x35')]=_['intersection'](_0x51207a[_0xf326('0x31')],qs[_0xf326('0x36')](_0x580374[_0xf326('0x33')][_0xf326('0x36')]));_0x1981bc[_0xf326('0x35')]=_0x1981bc['attributes'][_0xf326('0x37')]?_0x1981bc[_0xf326('0x35')]:_0x51207a['model'];if(!_0x580374['query'][_0xf326('0x38')]('nolimit')){_0x1981bc['limit']=qs[_0xf326('0x20')](_0x580374['query'][_0xf326('0x20')]);_0x1981bc[_0xf326('0x39')]=qs[_0xf326('0x39')](_0x580374[_0xf326('0x33')]['offset']);}_0x1981bc[_0xf326('0x3a')]=qs[_0xf326('0x3b')](_0x580374[_0xf326('0x33')][_0xf326('0x3b')]);_0x1981bc[_0xf326('0x3c')]=qs[_0xf326('0x3d')](_[_0xf326('0x3e')](_0x580374[_0xf326('0x33')],_0x51207a[_0xf326('0x3d')]),_0x4e5d7c);var _0x1227d3=[];var _0x361776=squel[_0xf326('0x3f')]()['field']('id')[_0xf326('0x40')](_0xf326('0x26'))[_0xf326('0x40')](_0xf326('0x41'))[_0xf326('0x42')](_0xf326('0x43'));var _0x4f4c51=squel[_0xf326('0x3f')]()[_0xf326('0x40')]('u.id')[_0xf326('0x40')](_0xf326('0x44'))[_0xf326('0x40')](_0xf326('0x45'))[_0xf326('0x42')]('user_has_openchannel_interactions','ui')['left_join'](_0xf326('0x46'),'u',_0xf326('0x47'));var _0x5ed62e=squel['select']()[_0xf326('0x42')](_0xf326('0x48'),'i')[_0xf326('0x49')]('cm_contacts','c',_0xf326('0x4a'))[_0xf326('0x49')](_0xf326('0x46'),'o',_0xf326('0x4b'))[_0xf326('0x49')](_0xf326('0x4c'),'a',_0xf326('0x4d'))[_0xf326('0x49')](_0xf326('0x4e'),'me',_0xf326('0x4f'))[_0xf326('0x49')](_0xf326('0x50'),'it',_0xf326('0x51'))[_0xf326('0x49')](_0xf326('0x43'),'t','t.id\x20=\x20it.TagId');var _0x199f8b=squel[_0xf326('0x52')]();var _0x6c55a0=[];var _0x28dde6=squel['expr']();var _0x10f437;if(_0x580374[_0xf326('0x33')][_0xf326('0x53')]){_0x10f437=as[_0xf326('0x54')](_0x580374['query'][_0xf326('0x53')]);var _0x1967ab=_0x10f437[_0xf326('0x55')];for(var _0x451ac7=0x0;_0x451ac7<_0x10f437[_0xf326('0x56')]['length'];_0x451ac7++){var _0x5d312d=_0x10f437[_0xf326('0x56')][_0x451ac7];var _0x38ff64='i';var _0x2ff126=_['find'](_0x4e5d7c,[_0xf326('0x26'),_0x5d312d[_0xf326('0x40')]]);if(!_0x2ff126){switch(_0x5d312d[_0xf326('0x40')]){case'unreadMessages':if(_0x5d312d['value']==0x1){_0x5ed62e[_0xf326('0x57')]('`'+_0x5d312d['field']+_0xf326('0x58'));}else{_0x5ed62e['having']('`'+_0x5d312d[_0xf326('0x40')]+_0xf326('0x59'));}break;case _0xf326('0x5a'):if(_0x5d312d[_0xf326('0x5b')]===_0xf326('0x5c')){if(_0x5d312d[_0xf326('0x5d')][_0xf326('0x2c')]('\x20')['length']>0x1){_0x199f8b[_0x1967ab](_0xf326('0x5e'),qs[_0xf326('0x5f')](_0x5d312d[_0xf326('0x5d')]),null);}else{var _0x4b0d8e='%'+_0x5d312d[_0xf326('0x5d')]+'%';_0x199f8b[_0x1967ab](_0xf326('0x60'),_0x4b0d8e,_0x4b0d8e,_0x4b0d8e);}}else{_0x2ff126=_[_0xf326('0x61')](_0x4e5d7c,[_0xf326('0x26'),_0xf326('0x62')]);_0x5d312d['field']=_0xf326('0x62');_0x3aeb20=as[_0xf326('0x63')](_0x38ff64,_0x2ff126[_0xf326('0x30')],_0x5d312d);_0x199f8b[_0x1967ab](_0x3aeb20[_0xf326('0x64')],_0x3aeb20['value'][_0xf326('0x65')],_0x3aeb20[_0xf326('0x5d')][_0xf326('0x1e')]);}break;case _0xf326('0x66'):var _0x4d3b9e=_0x5d312d['value'][_0xf326('0x2c')](',')[_0xf326('0x28')](function(_0x55ca96){return Number(_0x55ca96);});_0x4d3b9e[_0xf326('0x67')](function(_0x29de71){_0x28dde6['or'](_0xf326('0x68'),'%,'+_0x29de71+',%');});_0x6c55a0=_[_0xf326('0x69')](_0x6c55a0,_0x4d3b9e);break;case'User':if(_0x5d312d[_0xf326('0x5b')]==='$substring'){_0x199f8b[_0x1967ab]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x5d312d[_0xf326('0x5d')]+'%',null);}else{_0x2ff126=_['find'](_0x4e5d7c,[_0xf326('0x26'),_0xf326('0x6a')]);_0x5d312d[_0xf326('0x40')]='UserId';_0x3aeb20=as['buildExpression'](_0x38ff64,_0x2ff126[_0xf326('0x30')],_0x5d312d);_0x199f8b[_0x1967ab](_0x3aeb20[_0xf326('0x64')],_0x3aeb20[_0xf326('0x5d')]['start'],_0x3aeb20[_0xf326('0x5d')]['end']);}break;case _0xf326('0x6b'):_0x3aeb20=as[_0xf326('0x63')]('me',null,_0x5d312d);_0x199f8b[_0x1967ab](_0x3aeb20[_0xf326('0x64')],_0x3aeb20[_0xf326('0x5d')][_0xf326('0x65')],_0x3aeb20[_0xf326('0x5d')][_0xf326('0x1e')]);break;}}else{var _0x3aeb20=as[_0xf326('0x63')](_0x38ff64,_0x2ff126[_0xf326('0x30')],_0x5d312d);_0x199f8b[_0x1967ab](_0x3aeb20[_0xf326('0x64')],_0x3aeb20[_0xf326('0x5d')][_0xf326('0x65')],_0x3aeb20['value'][_0xf326('0x1e')]);}}}else{var _0x5ae666=_(_0x580374[_0xf326('0x33')])[_0xf326('0x32')]()['map'](function(_0x2b770c){return _['some'](_0x4e5d7c,[_0xf326('0x26'),_0x2b770c])?_0x2b770c:undefined;})[_0xf326('0x6c')]()[_0xf326('0x5d')]();if(!_[_0xf326('0x6d')](_0x5ae666)){_0x5ae666[_0xf326('0x67')](function(_0x51ff5e){if(_0x51ff5e==='OpenchannelAccountId'){_0x5ed62e[_0xf326('0x3c')](_0xf326('0x6e'),[][_0xf326('0x6f')](_0x580374[_0xf326('0x33')][_0x51ff5e]));}else if(_0x51ff5e===_0xf326('0x70')){var _0x579d2c=JSON[_0xf326('0x71')](_0x580374[_0xf326('0x33')][_0x51ff5e])['$gte'];var _0x50319a=JSON['parse'](_0x580374[_0xf326('0x33')][_0x51ff5e])[_0xf326('0x72')];_0x5ed62e[_0xf326('0x3c')](_0xf326('0x73'),_0x579d2c,_0x50319a);}else{if(_0x580374[_0xf326('0x33')][_0x51ff5e]===_0xf326('0x74')){_0x5ed62e[_0xf326('0x3c')]('i.'+_0x51ff5e+'\x20IS\x20NULL');}else{_0x5ed62e[_0xf326('0x3c')]('i.'+_0x51ff5e+_0xf326('0x75'),_0x580374[_0xf326('0x33')][_0x51ff5e]);}}});}if(_0x580374[_0xf326('0x33')]['read']){if(_0x580374[_0xf326('0x33')]['read']==0x1){_0x5ed62e['having'](_0xf326('0x76'));}else{_0x5ed62e['having'](_0xf326('0x77'));}}if(_0x580374[_0xf326('0x33')][_0xf326('0x78')]){_0x6c55a0=_[_0xf326('0x79')](_0x580374[_0xf326('0x33')]['tag'])?_0x580374['query']['tag']:new Array(_0x580374[_0xf326('0x33')][_0xf326('0x78')]);_0x6c55a0[_0xf326('0x67')](function(_0x180616){_0x28dde6['or'](_0xf326('0x68'),'%,'+_0x180616+',%');});}if(_0x580374['query'][_0xf326('0x7a')]){var _0x372dc8=_0x580374[_0xf326('0x33')]['filter']['replace']('\x5c','\x5c\x5c')[_0xf326('0x7b')](/'/g,'\x27\x27');if(qs[_0xf326('0x7c')](_0x372dc8)){_0x199f8b['or']('i.id\x20LIKE\x20?',_0x372dc8+'%');}else{_0x199f8b['or']('MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xf326('0x5f')](_0x372dc8))['or']('i.from\x20LIKE\x20?',_0x372dc8+'%')['or'](_0xf326('0x7d'),_0x372dc8+'%');}}}_0x5ed62e['where'](_0x199f8b);_0x5ed62e['group']('i.id');var _0x1bb63e={'type':db[_0xf326('0x7e')][_0xf326('0x7f')]['SELECT'],'raw':!![]};var _0x1cf9a8=_0x5ed62e[_0xf326('0x80')]();_0x1cf9a8[_0xf326('0x40')](_0xf326('0x81'));_0x1cf9a8[_0xf326('0x40')](_0xf326('0x82'),_0xf326('0x83'));if(_0x1981bc[_0xf326('0x3a')]){_0x1981bc[_0xf326('0x3a')]['forEach'](function(_0x34c3cf){var _0x5b1494=_0x34c3cf[0x0]===_0xf326('0x84')?_0x34c3cf[0x0]:'i.'+_0x34c3cf[0x0];_0x5ed62e[_0xf326('0x3a')](_0x5b1494,_0x34c3cf[0x1]===_0xf326('0x85')?![]:!![]);});}if(!_['isEmpty'](_0x6c55a0)){_0x5ed62e[_0xf326('0x57')](_0x28dde6);_0x1cf9a8[_0xf326('0x3c')](_0xf326('0x86'),_0x6c55a0);}BPromise['resolve']()[_0xf326('0x23')](function(){if(!_0x10f437){if(_0x580374[_0xf326('0x33')][_0xf326('0x87')])return;_0x1cf9a8[_0xf326('0x3c')]('i.OpenchannelAccountId\x20IS\x20NOT\x20NULL');_0x5ed62e[_0xf326('0x3c')]('i.OpenchannelAccountId\x20IS\x20NOT\x20NULL');return;}if(_0x580374['user'][_0xf326('0x88')]!==_0xf326('0x89'))return;return _0x580374['user']['getOpenchannelAccounts']({'attributes':['id'],'raw':!![]})['then'](function(_0x2bd990){if(_['isEmpty'](_0x2bd990)){_0x1cf9a8[_0xf326('0x3c')](_0xf326('0x8a'));_0x5ed62e[_0xf326('0x3c')](_0xf326('0x8a'));}else{_0x1cf9a8[_0xf326('0x3c')](_0xf326('0x6e'),_['map'](_0x2bd990,'id'));_0x5ed62e[_0xf326('0x3c')](_0xf326('0x6e'),_['map'](_0x2bd990,'id'));}});})['then'](function(){if(_0x580374[_0xf326('0x8b')]['role']===_0xf326('0x89')&&!_0x10f437&&!_0x580374[_0xf326('0x33')][_0xf326('0x87')])return[];return db[_0xf326('0x8c')][_0xf326('0x33')](_0x1cf9a8[_0xf326('0x8d')](),_0x1bb63e);})[_0xf326('0x23')](function(_0x8ca46f){_0x4083a2[_0xf326('0x8e')]=_0x8ca46f['length'];if(_0x4083a2[_0xf326('0x8e')]===0x0)return[];return db[_0xf326('0x8c')]['query'](_0x361776[_0xf326('0x8d')](),_0x1bb63e)['then'](function(_0x28763a){_0x1227d3=_[_0xf326('0x8f')](_0x28763a,'id');_0x1bb63e=_[_0xf326('0x90')](_0x1bb63e,{'model':db['OpenchannelInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x580374[_0xf326('0x33')][_0xf326('0x36')]){_0x1981bc[_0xf326('0x35')][_0xf326('0x67')](function(_0x30e096){_0x5ed62e[_0xf326('0x40')]('i.'+_0x30e096);});}else{_0x5ed62e[_0xf326('0x40')](_0xf326('0x82'),_0xf326('0x83'));_0x5ed62e[_0xf326('0x40')](_0xf326('0x91'),_0xf326('0x92'));_0x5ed62e[_0xf326('0x40')](_0xf326('0x93'),_0xf326('0x94'));_0x5ed62e['field'](_0xf326('0x95'),_0xf326('0x84'));_0x5ed62e['field'](_0xf326('0x96'));_0x5ed62e[_0xf326('0x40')]('c.firstName',_0xf326('0x97'));_0x5ed62e[_0xf326('0x40')](_0xf326('0x98'),_0xf326('0x99'));_0x5ed62e[_0xf326('0x40')](_0xf326('0x9a'),_0xf326('0x9b'));_0x5ed62e['field'](_0xf326('0x9c'),_0xf326('0x9d'));_0x5ed62e[_0xf326('0x40')](_0xf326('0x9e'),_0xf326('0x9f'));_0x5ed62e[_0xf326('0x40')](_0xf326('0xa0'),_0xf326('0xa1'));_0x5ed62e['field'](_0xf326('0xa2'),_0xf326('0xa3'));_0x5ed62e['field'](_0xf326('0xa4'),'Owner.internal');_0x5ed62e[_0xf326('0x40')](_0xf326('0xa5'),_0xf326('0x2a'));}if(_0x1981bc[_0xf326('0x20')])_0x5ed62e[_0xf326('0x20')](_0x1981bc[_0xf326('0x20')]);if(_0x1981bc[_0xf326('0x39')])_0x5ed62e[_0xf326('0x39')](_0x1981bc[_0xf326('0x39')]);return db[_0xf326('0x8c')][_0xf326('0x33')](_0x5ed62e[_0xf326('0x8d')](),_0x1bb63e);})[_0xf326('0x23')](function(_0x274ad0){_0x4f4c51['where'](_0xf326('0xa6'),_[_0xf326('0x28')](_0x274ad0,'id'));return db[_0xf326('0x8c')][_0xf326('0x33')](_0x4f4c51[_0xf326('0x8d')](),_0x1bb63e)['then'](function(_0x1ec128){var _0x1b6a15=_[_0xf326('0xa7')](_0x1ec128,_0xf326('0xa8'));var _0x127be1=[];_0x274ad0['forEach'](function(_0x4b6ec0){_0x127be1[_0xf326('0x2d')](updateOpenchannelInteraction(_0x4b6ec0,_0x1227d3,_0x1b6a15));});return BPromise['all'](_0x127be1);});});})[_0xf326('0x23')](function(_0x143965){_0x4083a2[_0xf326('0xa9')]=_0x143965;return _0x4083a2;})['then'](respondWithFilteredResult(_0x461e93,_0x1981bc))['catch'](handleError(_0x461e93,null));};exports[_0xf326('0xaa')]=function(_0x2d92e4,_0x167ac9){var _0x34870c={};if(_0x2d92e4[_0xf326('0x33')]['type']&&_0x2d92e4[_0xf326('0x33')][_0xf326('0x30')]===_0xf326('0x42')){_0x34870c['from']=_0x2d92e4['params']['id'];}else{_0x34870c['id']=_0x2d92e4['params']['id'];}var _0x9afd56={'raw':![],'where':_0x34870c},_0x17c96c={};_0x17c96c[_0xf326('0x31')]=_[_0xf326('0x32')](db[_0xf326('0xab')][_0xf326('0xac')]);_0x17c96c[_0xf326('0x33')]=_['keys'](_0x2d92e4['query']);_0x17c96c[_0xf326('0x3d')]=_[_0xf326('0x34')](_0x17c96c[_0xf326('0x31')],_0x17c96c['query']);_0x9afd56[_0xf326('0x35')]=_[_0xf326('0x34')](_0x17c96c[_0xf326('0x31')],qs['fields'](_0x2d92e4[_0xf326('0x33')][_0xf326('0x36')]));_0x9afd56[_0xf326('0x35')]=_0x9afd56[_0xf326('0x35')]['length']?_0x9afd56['attributes']:_0x17c96c['model'];if(_0x2d92e4[_0xf326('0x33')][_0xf326('0xad')]){_0x9afd56[_0xf326('0xae')]=[{'all':!![]}];}_0x9afd56=_['merge']({},_0x9afd56,_0x2d92e4[_0xf326('0xaf')]);return db[_0xf326('0xab')][_0xf326('0x61')](_0x9afd56)['then'](handleEntityNotFound(_0x167ac9,null))[_0xf326('0x23')](respondWithResult(_0x167ac9,null))[_0xf326('0x2e')](handleError(_0x167ac9,null));};exports[_0xf326('0xb0')]=function(_0x218553,_0x500011){return db[_0xf326('0xab')]['create'](_0x218553[_0xf326('0x6b')],{})[_0xf326('0x23')](respondWithResult(_0x500011,0xc9))[_0xf326('0x2e')](handleError(_0x500011,null));};exports[_0xf326('0x22')]=function(_0x547fe9,_0x2e2f70){if(_0x547fe9['body']['id']){delete _0x547fe9[_0xf326('0x6b')]['id'];}return db[_0xf326('0xab')][_0xf326('0x61')]({'where':{'id':_0x547fe9[_0xf326('0xb1')]['id']}})[_0xf326('0x23')](handleEntityNotFound(_0x2e2f70,null))['then'](saveUpdates(_0x547fe9['body'],null))[_0xf326('0x23')](respondWithResult(_0x2e2f70,null))[_0xf326('0x2e')](handleError(_0x2e2f70,null));};exports[_0xf326('0xb2')]=function(_0xc67315,_0x55c2f8){return db[_0xf326('0xab')]['find']({'where':{'id':_0xc67315[_0xf326('0xb1')]['id']}})[_0xf326('0x23')](handleEntityNotFound(_0x55c2f8,null))[_0xf326('0x23')](removeEntity(_0x55c2f8,null))['catch'](handleError(_0x55c2f8,null));};exports[_0xf326('0xb3')]=function(_0x42bbd7,_0x866c2){return db[_0xf326('0xab')][_0xf326('0xb3')]()['then'](respondWithResult(_0x866c2,null))[_0xf326('0x2e')](handleError(_0x866c2,null));};exports[_0xf326('0xb4')]=function(_0x53348c,_0x40cea4,_0x2ecb04){return db[_0xf326('0xb5')][_0xf326('0x61')]({'where':{'id':_0x53348c['params']['id']}})['then'](handleEntityNotFound(_0x40cea4,null))[_0xf326('0x23')](function(_0x40e683){if(_0x40e683){return _0x40e683['addMessage'](_0x53348c[_0xf326('0x6b')]['ids'],_['omit'](_0x53348c[_0xf326('0x6b')],[_0xf326('0xb6'),'id'])||{});}})[_0xf326('0x23')](respondWithResult(_0x40cea4,null))[_0xf326('0x2e')](handleError(_0x40cea4,null));};exports[_0xf326('0xb7')]=function(_0xdfae35,_0xf5440,_0x467563){var _0xc9dead={'raw':![],'where':{}};var _0x5c6179={};var _0x28a0d1={'count':0x0,'rows':[]};return db[_0xf326('0xab')][_0xf326('0xb8')]({'where':{'id':_0xdfae35[_0xf326('0xb1')]['id']}})['then'](handleEntityNotFound(_0xf5440,null))[_0xf326('0x23')](function(_0x20020c){if(_0x20020c){_0x5c6179[_0xf326('0x31')]=_[_0xf326('0x32')](db[_0xf326('0xb5')]['rawAttributes']);_0x5c6179[_0xf326('0x33')]=_['keys'](_0xdfae35[_0xf326('0x33')]);_0x5c6179[_0xf326('0x3d')]=_[_0xf326('0x34')](_0x5c6179[_0xf326('0x31')],_0x5c6179['query']);_0xc9dead[_0xf326('0x35')]=_[_0xf326('0x34')](_0x5c6179[_0xf326('0x31')],qs['fields'](_0xdfae35[_0xf326('0x33')][_0xf326('0x36')]));_0xc9dead[_0xf326('0x35')]=_0xc9dead[_0xf326('0x35')]['length']?_0xc9dead[_0xf326('0x35')]:_0x5c6179[_0xf326('0x31')];if(!_0xdfae35[_0xf326('0x33')][_0xf326('0x38')]('nolimit')){_0xc9dead[_0xf326('0x20')]=qs[_0xf326('0x20')](_0xdfae35[_0xf326('0x33')]['limit']);_0xc9dead[_0xf326('0x39')]=qs[_0xf326('0x39')](_0xdfae35['query'][_0xf326('0x39')]);}_0xc9dead[_0xf326('0x3a')]=qs[_0xf326('0x3b')](_0xdfae35[_0xf326('0x33')][_0xf326('0x3b')]);_0xc9dead[_0xf326('0x3c')]=qs['filters'](_['pick'](_0xdfae35[_0xf326('0x33')],_0x5c6179[_0xf326('0x3d')]));_0xc9dead[_0xf326('0x3c')][_0xf326('0xa8')]=_0x20020c['id'];if(_0xdfae35[_0xf326('0x33')][_0xf326('0x7a')]){_0xc9dead['where']=_[_0xf326('0x90')](_0xc9dead[_0xf326('0x3c')],{'$or':_[_0xf326('0x28')](_0xc9dead[_0xf326('0x35')],function(_0x50d506){var _0x204077={};_0x204077[_0x50d506]={'$like':'%'+_0xdfae35[_0xf326('0x33')][_0xf326('0x7a')]+'%'};return _0x204077;})});}if(_0xdfae35[_0xf326('0x33')]['$gte']){var _0x3ca75e=_0xdfae35['query']['$gte'][_0xf326('0x2c')](',');var _0x549a1f={};_0x549a1f[_0x3ca75e[0x0]]={'$gte':moment(_0x3ca75e[0x1])[_0xf326('0xb9')](_0xf326('0xba'))};_0xc9dead[_0xf326('0x3c')]=_[_0xf326('0x90')](_0xc9dead[_0xf326('0x3c')],_0x549a1f);}_0xc9dead=_[_0xf326('0x90')]({},_0xc9dead,_0xdfae35[_0xf326('0xaf')]);return db[_0xf326('0xb5')][_0xf326('0x8e')]({'where':_0xc9dead[_0xf326('0x3c')]})[_0xf326('0x23')](function(_0x4371f7){_0x28a0d1['count']=_0x4371f7;if(_0xdfae35[_0xf326('0x33')][_0xf326('0xad')]){_0xc9dead[_0xf326('0xae')]=[{'all':!![]}];}return db[_0xf326('0xb5')][_0xf326('0xbb')](_0xc9dead);})[_0xf326('0x23')](function(_0x1ba5a4){_0x28a0d1['rows']=_0x1ba5a4;return _0x28a0d1;});}})[_0xf326('0x23')](respondWithFilteredResult(_0xf5440,_0xc9dead))[_0xf326('0x2e')](handleError(_0xf5440,null));};exports[_0xf326('0xbc')]=function(_0x316877,_0x79faa1,_0x14259b){return db[_0xf326('0xab')]['find']({'where':{'id':_0x316877[_0xf326('0xb1')]['id']}})[_0xf326('0x23')](handleEntityNotFound(_0x79faa1,null))[_0xf326('0x23')](function(_0x9a0455){if(_0x9a0455){return _0x9a0455[_0xf326('0xbd')](_0x316877[_0xf326('0x6b')][_0xf326('0xb6')],_[_0xf326('0xbe')](_0x316877[_0xf326('0x6b')],[_0xf326('0xb6'),'id'])||{})[_0xf326('0xbf')](function(){return db[_0xf326('0x66')]['findAll']({'attributes':['id',_0xf326('0x26'),_0xf326('0x41')],'where':{'id':_0x316877[_0xf326('0x6b')]['ids']}});})['then'](function(_0x354338){socket[_0xf326('0xc0')](_0xf326('0xc1'),{'id':Number(_0x316877[_0xf326('0xb1')]['id']),'tags':_0x354338||[]});return{'id':Number(_0x316877['params']['id']),'tags':_0x354338||[]};});}})[_0xf326('0x23')](respondWithResult(_0x79faa1,null))[_0xf326('0x2e')](handleError(_0x79faa1,null));};exports[_0xf326('0xc2')]=function(_0x5a7164,_0x48bc4d,_0x510b4b){return db[_0xf326('0xab')][_0xf326('0x61')]({'where':{'id':_0x5a7164[_0xf326('0xb1')]['id']}})['then'](handleEntityNotFound(_0x48bc4d,null))[_0xf326('0x23')](function(_0x513fd8){if(_0x513fd8){return _0x513fd8[_0xf326('0xc2')](_0x5a7164['query'][_0xf326('0xb6')]);}})[_0xf326('0x23')](respondWithStatusCode(_0x48bc4d,null))[_0xf326('0x2e')](handleError(_0x48bc4d,null));};exports[_0xf326('0xc3')]=function(_0x435692,_0x3dcaf9){var _0x1f05a2=moment()[_0xf326('0xc4')]()[_0xf326('0x8d')]();var _0x21c576=path[_0xf326('0xc5')](config[_0xf326('0xc6')],_0xf326('0xc7'),_0xf326('0xc8'),'tmp');var _0x2e3517=path[_0xf326('0xc5')](config[_0xf326('0xc6')],'server','files','attachments');var _0x3fc996=path[_0xf326('0xc5')](_0x21c576,_0x1f05a2);var _0x29f0bc=util[_0xf326('0xb9')](_0xf326('0xc9'),_0x435692[_0xf326('0xb1')]['id'],_0x1f05a2);var _0x4fa367=path[_0xf326('0xc5')](_0x21c576,_0x29f0bc);var _0x13b421=[];_0x13b421[_0xf326('0x2d')]({'model':db[_0xf326('0xca')],'as':_0xf326('0xca'),'attributes':['id','fullname'],'raw':!![]});_0x13b421[_0xf326('0x2d')]({'model':db[_0xf326('0xcb')],'as':_0xf326('0x5a'),'attributes':['id',_0xf326('0xcc'),_0xf326('0xcd')],'raw':!![]});if(_0x435692['query']['attachments']){_0x13b421[_0xf326('0x2d')]({'model':db['Attachment'],'as':'Attachment','raw':!![]});}var _0x78e7b0=[{'model':db[_0xf326('0xb5')],'as':_0xf326('0xce'),'attributes':['id',_0xf326('0x6b'),_0xf326('0x70'),'direction',_0xf326('0xcf'),_0xf326('0xd0')],'include':_0x13b421}];_0x78e7b0[_0xf326('0x2d')]({'model':db[_0xf326('0xd1')],'as':'Account','attributes':['id',_0xf326('0x26')]});_0x78e7b0['push']({'model':db['User'],'as':'Owner','attributes':['id',_0xf326('0x29')]});return db[_0xf326('0xab')][_0xf326('0x61')]({'where':{'id':_0x435692[_0xf326('0xb1')]['id']},'include':_0x78e7b0})[_0xf326('0x23')](handleEntityNotFound(_0x3dcaf9,null))[_0xf326('0x23')](function(_0x3bca4e){if(_0x3bca4e){var _0x3833f9=_0x3bca4e[_0xf326('0xd2')]({'plain':!![]});fs[_0xf326('0xd3')](_0x3fc996);var _0xb4b180={'format':'A4','border':'10px','header':{'height':_0xf326('0xd4'),'contents':{'first':_0xf326('0xd5')}},'footer':{'height':_0xf326('0xd6'),'contents':{'default':util[_0xf326('0xb9')](_0xf326('0xd7'),util[_0xf326('0xb9')](_0xf326('0xd8'),_0xf326('0xd9'),_0x3833f9['id']),moment()[_0xf326('0xb9')]('YYYY-MM-DD')[_0xf326('0x8d')]())}}};var _0x3c7e4a={'channel':_0xf326('0xd9'),'account':_0x3833f9['Account']['name'],'agent':_0x3833f9[_0xf326('0xda')]?_0x3833f9[_0xf326('0xda')]['fullname']:'N.A.','createdAt':moment(_0x3833f9[_0xf326('0x70')])['format'](_0xf326('0xba'))['toString'](),'closedAt':_0x3833f9[_0xf326('0xdb')]?moment(_0x3833f9[_0xf326('0xdc')])[_0xf326('0xb9')](_0xf326('0xba'))[_0xf326('0x8d')]():'','disposition':_0x3833f9['disposition'],'visibility':_0x3833f9[_0xf326('0xdd')]?'Public':_0xf326('0xde'),'messages':_(_0x3833f9[_0xf326('0xce')])[_0xf326('0x7a')]({'secret':![]})[_0xf326('0x28')](function(_0x76ad63){if(_0x76ad63['Attachment']){var _0x4ecacc=path[_0xf326('0xc5')](_0x2e3517,_0x76ad63['Attachment']['basename']);if(fs['existsSync'](_0x4ecacc)){fs['createReadStream'](_0x4ecacc)[_0xf326('0xdf')](fs[_0xf326('0xe0')](path[_0xf326('0xc5')](_0x3fc996,_0x76ad63[_0xf326('0xe1')][_0xf326('0xe2')])));}}return{'date':moment(_0x76ad63[_0xf326('0x70')])[_0xf326('0xb9')](_0xf326('0xba'))[_0xf326('0x8d')](),'sender':_0x76ad63[_0xf326('0xe3')]===_0xf326('0xe4')?_0x76ad63['User']?_0x76ad63[_0xf326('0xca')][_0xf326('0x29')]:_0xf326('0xe5'):_0x76ad63[_0xf326('0x5a')][_0xf326('0xcc')]+(_0x76ad63[_0xf326('0x5a')][_0xf326('0xcd')]?'\x20'+_0x76ad63[_0xf326('0x5a')][_0xf326('0xcd')]:''),'body':_0x76ad63['Attachment']?_0x76ad63[_0xf326('0xe1')]['basename']:_0x76ad63[_0xf326('0x6b')],'direction':_0x76ad63['direction']==='out'?'A':'C','secret':_0x76ad63[_0xf326('0xcf')],'read':_0x76ad63['read'],'attachment':_0x76ad63[_0xf326('0xe1')]};})[_0xf326('0x5d')]()};return ejs[_0xf326('0xe6')](path[_0xf326('0xc5')](config['root'],_0xf326('0xc7'),_0xf326('0xe7'),_0xf326('0xe8')),{'interaction':_0x3c7e4a})[_0xf326('0x23')](function(_0x517b1c){return new BPromise(function(_0x50e35f,_0x24bef0){pdf[_0xf326('0xb0')](_0x517b1c,_0xb4b180)[_0xf326('0xe9')](path[_0xf326('0xc5')](_0x3fc996,_0xf326('0xea')+_0x3833f9['id']+'-'+_0x1f05a2+_0xf326('0xeb')),function(_0x7e238b,_0x3faa73){if(_0x7e238b)return _0x24bef0(_0x7e238b);_0x50e35f(_0x3faa73);});});})[_0xf326('0x23')](function(){return new BPromise(function(_0xa5963a,_0x51e50d){zipdir(_0x3fc996,{'saveTo':_0x4fa367},function(_0x4e9000,_0x129595){if(_0x4e9000)return _0x51e50d(_0x4e9000);return _0xa5963a(_0x129595);});})[_0xf326('0x23')](function(){return new BPromise(function(_0x41f7a7,_0x5419cc){rimraf(_0x3fc996,function(_0x38390d){if(_0x38390d)_0x5419cc(_0x38390d);return _0x41f7a7();});});})['then'](function(){return _0x3dcaf9[_0xf326('0xc3')](_0x4fa367,_0x29f0bc,function(_0x761ccb){if(_0x761ccb){console['log'](_0xf326('0xec'),_0x761ccb);}else{fs[_0xf326('0xed')](_0x4fa367);}});});});}else{return _0x3dcaf9[_0xf326('0x1c')](0xc8);}})[_0xf326('0x2e')](handleError(_0x3dcaf9,null));};
\ No newline at end of file
+var _0x02fb=['$substring','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','type','start','body','compact','isEmpty','OpenchannelAccountId','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','read','tag','isArray','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?','group','QueryTypes','SELECT','i.id','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','order','DESC','i.OpenchannelAccountId\x20IS\x20NOT\x20NULL','user','role','i.OpenchannelAccountId\x20IN\x20?','agent','sequelize','toString','keyBy','merge','fields','unreadMessages','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','contactName','i.*','Contact.firstName','Contact.lastName','c.email','Contact.email','c.mobile','Contact.mobile','Contact.fax','o.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','groupBy','all','rows','show','includeAll','include','options','create','params','describe','OpenchannelMessage','addMessage','ids','omit','findOne','OpenchannelInteractionId','format','findAll','addTags','setTags','spread','emit','openchannelInteractionTags:save','removeTags','download','unix','root','server','tmp','join','files','attachments','transcript-%d-%s.zip','CmContact','firstName','Attachment','secret','Owner','get','mkdirSync','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>','30px','<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>','Openchannel','YYYY-MM-DD','Account','N.A.','YYYY-MM-DD\x20HH:mm:ss','closed','disposition','threadId','Public','Private','Messages','basename','createReadStream','pipe','direction','out','System','lastName','renderFile','downloadInteraction.html','transcript-','.pdf','err','unlinkSync','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','ejs','lodash','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/environment','../../config/license/util','../../mysqldb','defaults','localhost','redis','./openchannelInteraction.socket','sendStatus','status','end','json','count','offset','limit','apply','reject','save','update','then','destroy','name','Users','map','fullname','TagIds','Tags','forEach','push','catch','OpenchannelInteraction','rawAttributes','fieldName','query','keys','intersection','model','attributes','length','hasOwnProperty','nolimit','sort','where','filters','pick','select','field','color','from','tools_tags','u.id','u.fullname','ui.OpenchannelInteractionId','user_has_openchannel_interactions','left_join','users','openchannel_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','openchannel_accounts','a.id\x20=\x20i.OpenchannelAccountId','openchannel_messages','me.OpenchannelInteractionId\x20=\x20i.id','openchannel_interaction_has_tags','t.id\x20=\x20it.TagId','expr','search','conditions','find','having','`\x20=\x200','`\x20>\x200','Contact','operator','value','split','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'];(function(_0x355c9a,_0x688098){var _0x41c8a4=function(_0x1832a6){while(--_0x1832a6){_0x355c9a['push'](_0x355c9a['shift']());}};_0x41c8a4(++_0x688098);}(_0x02fb,0x16c));var _0xb02f=function(_0x3f4639,_0x579849){_0x3f4639=_0x3f4639-0x0;var _0x5ef2c9=_0x02fb[_0x3f4639];return _0x5ef2c9;};'use strict';var pdf=require(_0xb02f('0x0'));var emlformat=require(_0xb02f('0x1'));var rimraf=require(_0xb02f('0x2'));var zipdir=require(_0xb02f('0x3'));var jsonpatch=require(_0xb02f('0x4'));var rp=require(_0xb02f('0x5'));var moment=require(_0xb02f('0x6'));var BPromise=require('bluebird');var Mustache=require(_0xb02f('0x7'));var util=require(_0xb02f('0x8'));var path=require(_0xb02f('0x9'));var sox=require('sox');var csv=require(_0xb02f('0xa'));var ejs=require(_0xb02f('0xb'));var fs=require('fs');var _=require(_0xb02f('0xc'));var squel=require('squel');var crypto=require(_0xb02f('0xd'));var jsforce=require(_0xb02f('0xe'));var deskjs=require(_0xb02f('0xf'));var toCsv=require(_0xb02f('0xa'));var querystring=require('querystring');var Papa=require(_0xb02f('0x10'));var Redis=require(_0xb02f('0x11'));var authService=require(_0xb02f('0x12'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xb02f('0x13'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require(_0xb02f('0x14'));var licenseUtil=require(_0xb02f('0x15'));var db=require(_0xb02f('0x16'))['db'];config['redis']=_[_0xb02f('0x17')](config['redis'],{'host':_0xb02f('0x18'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xb02f('0x19')]));require(_0xb02f('0x1a'))['register'](socket);function respondWithStatusCode(_0x11a6ea,_0x3ce985){_0x3ce985=_0x3ce985||0xcc;return function(_0x4d2955){if(_0x4d2955){return _0x11a6ea[_0xb02f('0x1b')](_0x3ce985);}return _0x11a6ea[_0xb02f('0x1c')](_0x3ce985)[_0xb02f('0x1d')]();};}function respondWithResult(_0xa751de,_0x5c649a){_0x5c649a=_0x5c649a||0xc8;return function(_0x28b8d9){if(_0x28b8d9){return _0xa751de[_0xb02f('0x1c')](_0x5c649a)[_0xb02f('0x1e')](_0x28b8d9);}};}function respondWithFilteredResult(_0x10ef2e,_0x336fd1){return function(_0x35d6e7){if(_0x35d6e7){var _0x46b46d=_0x35d6e7[_0xb02f('0x1f')],_0x40d305=_0x336fd1[_0xb02f('0x20')],_0x3897f4=_0x336fd1[_0xb02f('0x20')]+_0x336fd1[_0xb02f('0x21')],_0x57ecd9;if(_0x3897f4>=_0x46b46d){_0x3897f4=_0x46b46d;_0x57ecd9=0xc8;}else{_0x57ecd9=0xce;}_0x10ef2e[_0xb02f('0x1c')](_0x57ecd9);return _0x10ef2e['set']('Content-Range',_0x40d305+'-'+_0x3897f4+'/'+_0x46b46d)['json'](_0x35d6e7);}return null;};}function patchUpdates(_0x329a25){return function(_0x29b2aa){try{jsonpatch[_0xb02f('0x22')](_0x29b2aa,_0x329a25,!![]);}catch(_0x23daa0){return BPromise[_0xb02f('0x23')](_0x23daa0);}return _0x29b2aa[_0xb02f('0x24')]();};}function saveUpdates(_0x134366,_0x1be900){return function(_0x220643){if(_0x220643){return _0x220643[_0xb02f('0x25')](_0x134366)[_0xb02f('0x26')](function(_0x84d57d){return _0x84d57d;});}return null;};}function removeEntity(_0xdeadc8,_0x54d59f){return function(_0x541f72){if(_0x541f72){return _0x541f72[_0xb02f('0x27')]()[_0xb02f('0x26')](function(){_0xdeadc8[_0xb02f('0x1c')](0xcc)[_0xb02f('0x1d')]();});}};}function handleEntityNotFound(_0x2a5dd2,_0x591cfb){return function(_0x1423e9){if(!_0x1423e9){_0x2a5dd2[_0xb02f('0x1b')](0x194);}return _0x1423e9;};}function handleError(_0x591f19,_0x1a84a5){_0x1a84a5=_0x1a84a5||0x1f4;return function(_0x403a52){logger['error'](_0x403a52['stack']);if(_0x403a52['name']){delete _0x403a52[_0xb02f('0x28')];}_0x591f19[_0xb02f('0x1c')](_0x1a84a5)['send'](_0x403a52);};}function getInteractionUsers(_0x37a2a8,_0x5e71d8){return new BPromise(function(_0x17f83d,_0xd16bae){try{if(_0x5e71d8[_0x37a2a8['id']]){_0x37a2a8[_0xb02f('0x29')]=_[_0xb02f('0x2a')](_0x5e71d8[_0x37a2a8['id']],function(_0x2efaa6){return{'id':_0x2efaa6['id'],'fullname':_0x2efaa6[_0xb02f('0x2b')]};});}}catch(_0x4343d4){_0xd16bae(_0x4343d4);}_0x17f83d(_0x37a2a8);});}function getInteractionTags(_0x1cb2cf,_0x124709){return new BPromise(function(_0x489609,_0x53387a){try{if(_0x1cb2cf[_0xb02f('0x2c')]){_0x1cb2cf[_0xb02f('0x2d')]=[];_0x1cb2cf[_0xb02f('0x2c')]['split'](',')[_0xb02f('0x2e')](function(_0x57399e){_0x1cb2cf[_0xb02f('0x2d')][_0xb02f('0x2f')](_0x124709[_0x57399e]);});}delete _0x1cb2cf[_0xb02f('0x2c')];}catch(_0x82c900){_0x53387a(_0x82c900);}_0x489609(_0x1cb2cf);});}function updateOpenchannelInteraction(_0x257b9c,_0x11421a,_0x5326e7){return new BPromise(function(_0x23c118,_0x18a4f7){return getInteractionUsers(_0x257b9c,_0x5326e7)[_0xb02f('0x26')](function(_0x59fc78){return getInteractionTags(_0x59fc78,_0x11421a);})[_0xb02f('0x26')](function(_0x599c10){_0x23c118(_0x599c10);})[_0xb02f('0x30')](function(_0x8db873){_0x18a4f7(_0x8db873);});});}exports['index']=function(_0x5508eb,_0x410785){var _0x26c3a0={},_0x1043ad={},_0x14ef66={'count':0x0,'rows':[]};var _0xea9c44=_['map'](db[_0xb02f('0x31')][_0xb02f('0x32')],function(_0x52da1c){return{'name':_0x52da1c[_0xb02f('0x33')],'type':_0x52da1c['type']['key']};});_0x1043ad['model']=_['map'](_0xea9c44,_0xb02f('0x28'));_0x1043ad[_0xb02f('0x34')]=_[_0xb02f('0x35')](_0x5508eb[_0xb02f('0x34')]);_0x1043ad['filters']=_[_0xb02f('0x36')](_0x1043ad[_0xb02f('0x37')],_0x1043ad[_0xb02f('0x34')]);_0x26c3a0[_0xb02f('0x38')]=_[_0xb02f('0x36')](_0x1043ad[_0xb02f('0x37')],qs['fields'](_0x5508eb[_0xb02f('0x34')]['fields']));_0x26c3a0[_0xb02f('0x38')]=_0x26c3a0[_0xb02f('0x38')][_0xb02f('0x39')]?_0x26c3a0[_0xb02f('0x38')]:_0x1043ad[_0xb02f('0x37')];if(!_0x5508eb[_0xb02f('0x34')][_0xb02f('0x3a')](_0xb02f('0x3b'))){_0x26c3a0[_0xb02f('0x21')]=qs['limit'](_0x5508eb['query']['limit']);_0x26c3a0['offset']=qs[_0xb02f('0x20')](_0x5508eb['query'][_0xb02f('0x20')]);}_0x26c3a0['order']=qs[_0xb02f('0x3c')](_0x5508eb['query'][_0xb02f('0x3c')]);_0x26c3a0[_0xb02f('0x3d')]=qs[_0xb02f('0x3e')](_[_0xb02f('0x3f')](_0x5508eb[_0xb02f('0x34')],_0x1043ad[_0xb02f('0x3e')]),_0xea9c44);var _0x2cafcb=[];var _0x4e67a4=squel[_0xb02f('0x40')]()[_0xb02f('0x41')]('id')[_0xb02f('0x41')](_0xb02f('0x28'))[_0xb02f('0x41')](_0xb02f('0x42'))[_0xb02f('0x43')](_0xb02f('0x44'));var _0x589680=squel['select']()[_0xb02f('0x41')](_0xb02f('0x45'))[_0xb02f('0x41')](_0xb02f('0x46'))[_0xb02f('0x41')](_0xb02f('0x47'))['from'](_0xb02f('0x48'),'ui')[_0xb02f('0x49')](_0xb02f('0x4a'),'u','u.id\x20=\x20ui.UserId');var _0x3ebbc4=squel[_0xb02f('0x40')]()['from'](_0xb02f('0x4b'),'i')[_0xb02f('0x49')](_0xb02f('0x4c'),'c',_0xb02f('0x4d'))[_0xb02f('0x49')]('users','o',_0xb02f('0x4e'))['left_join'](_0xb02f('0x4f'),'a',_0xb02f('0x50'))['left_join'](_0xb02f('0x51'),'me',_0xb02f('0x52'))[_0xb02f('0x49')](_0xb02f('0x53'),'it','it.OpenchannelInteractionId\x20=\x20i.id')[_0xb02f('0x49')]('tools_tags','t',_0xb02f('0x54'));var _0x180169=squel[_0xb02f('0x55')]();var _0x17ecb5=[];var _0xd11747=squel[_0xb02f('0x55')]();var _0xc7011e;if(_0x5508eb[_0xb02f('0x34')][_0xb02f('0x56')]){_0xc7011e=as['parseSearch'](_0x5508eb['query'][_0xb02f('0x56')]);var _0x5607ae=_0xc7011e['sqlOperator'];for(var _0x5e95a9=0x0;_0x5e95a9<_0xc7011e[_0xb02f('0x57')]['length'];_0x5e95a9++){var _0x485a59=_0xc7011e[_0xb02f('0x57')][_0x5e95a9];var _0x92f5ec='i';var _0x2f3dc6=_[_0xb02f('0x58')](_0xea9c44,[_0xb02f('0x28'),_0x485a59[_0xb02f('0x41')]]);if(!_0x2f3dc6){switch(_0x485a59[_0xb02f('0x41')]){case'unreadMessages':if(_0x485a59['value']==0x1){_0x3ebbc4[_0xb02f('0x59')]('`'+_0x485a59[_0xb02f('0x41')]+_0xb02f('0x5a'));}else{_0x3ebbc4[_0xb02f('0x59')]('`'+_0x485a59[_0xb02f('0x41')]+_0xb02f('0x5b'));}break;case _0xb02f('0x5c'):if(_0x485a59[_0xb02f('0x5d')]==='$substring'){if(_0x485a59[_0xb02f('0x5e')][_0xb02f('0x5f')]('\x20')[_0xb02f('0x39')]>0x1){_0x180169[_0x5607ae]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xb02f('0x60')](_0x485a59[_0xb02f('0x5e')]),null);}else{var _0x36e324='%'+_0x485a59['value']+'%';_0x180169[_0x5607ae](_0xb02f('0x61'),_0x36e324,_0x36e324,_0x36e324);}}else{_0x2f3dc6=_[_0xb02f('0x58')](_0xea9c44,[_0xb02f('0x28'),_0xb02f('0x62')]);_0x485a59[_0xb02f('0x41')]='ContactId';_0x3ca1b0=as[_0xb02f('0x63')](_0x92f5ec,_0x2f3dc6['type'],_0x485a59);_0x180169[_0x5607ae](_0x3ca1b0[_0xb02f('0x64')],_0x3ca1b0['value']['start'],_0x3ca1b0[_0xb02f('0x5e')][_0xb02f('0x1d')]);}break;case _0xb02f('0x65'):var _0x24f942=_0x485a59['value'][_0xb02f('0x5f')](',')[_0xb02f('0x2a')](function(_0x297482){return Number(_0x297482);});_0x24f942[_0xb02f('0x2e')](function(_0x540d87){_0xd11747['or'](_0xb02f('0x66'),'%,'+_0x540d87+',%');});_0x17ecb5=_['union'](_0x17ecb5,_0x24f942);break;case _0xb02f('0x67'):if(_0x485a59[_0xb02f('0x5d')]===_0xb02f('0x68')){_0x180169[_0x5607ae](_0xb02f('0x69'),'%'+_0x485a59['value']+'%',null);}else{_0x2f3dc6=_['find'](_0xea9c44,['name',_0xb02f('0x6a')]);_0x485a59[_0xb02f('0x41')]=_0xb02f('0x6a');_0x3ca1b0=as[_0xb02f('0x63')](_0x92f5ec,_0x2f3dc6[_0xb02f('0x6b')],_0x485a59);_0x180169[_0x5607ae](_0x3ca1b0['text'],_0x3ca1b0['value'][_0xb02f('0x6c')],_0x3ca1b0['value']['end']);}break;case _0xb02f('0x6d'):_0x3ca1b0=as[_0xb02f('0x63')]('me',null,_0x485a59);_0x180169[_0x5607ae](_0x3ca1b0[_0xb02f('0x64')],_0x3ca1b0['value'][_0xb02f('0x6c')],_0x3ca1b0[_0xb02f('0x5e')][_0xb02f('0x1d')]);break;}}else{var _0x3ca1b0=as[_0xb02f('0x63')](_0x92f5ec,_0x2f3dc6[_0xb02f('0x6b')],_0x485a59);_0x180169[_0x5607ae](_0x3ca1b0['text'],_0x3ca1b0[_0xb02f('0x5e')][_0xb02f('0x6c')],_0x3ca1b0[_0xb02f('0x5e')][_0xb02f('0x1d')]);}}}else{var _0x434e31=_(_0x5508eb[_0xb02f('0x34')])[_0xb02f('0x35')]()['map'](function(_0x421034){return _['some'](_0xea9c44,['name',_0x421034])?_0x421034:undefined;})[_0xb02f('0x6e')]()['value']();if(!_[_0xb02f('0x6f')](_0x434e31)){_0x434e31[_0xb02f('0x2e')](function(_0x217e89){if(_0x217e89===_0xb02f('0x70')){_0x3ebbc4[_0xb02f('0x3d')]('i.OpenchannelAccountId\x20IN\x20?',[][_0xb02f('0x71')](_0x5508eb[_0xb02f('0x34')][_0x217e89]));}else if(_0x217e89===_0xb02f('0x72')){var _0x566e66=JSON[_0xb02f('0x73')](_0x5508eb[_0xb02f('0x34')][_0x217e89])[_0xb02f('0x74')];var _0x1dcb69=JSON['parse'](_0x5508eb['query'][_0x217e89])[_0xb02f('0x75')];_0x3ebbc4[_0xb02f('0x3d')](_0xb02f('0x76'),_0x566e66,_0x1dcb69);}else{if(_0x5508eb[_0xb02f('0x34')][_0x217e89]===_0xb02f('0x77')){_0x3ebbc4[_0xb02f('0x3d')]('i.'+_0x217e89+'\x20IS\x20NULL');}else{_0x3ebbc4[_0xb02f('0x3d')]('i.'+_0x217e89+_0xb02f('0x78'),_0x5508eb[_0xb02f('0x34')][_0x217e89]);}}});}if(_0x5508eb[_0xb02f('0x34')][_0xb02f('0x79')]){if(_0x5508eb['query'][_0xb02f('0x79')]==0x1){_0x3ebbc4[_0xb02f('0x59')]('`unreadMessages`\x20=\x200');}else{_0x3ebbc4[_0xb02f('0x59')]('`unreadMessages`\x20>\x200');}}if(_0x5508eb[_0xb02f('0x34')][_0xb02f('0x7a')]){_0x17ecb5=_[_0xb02f('0x7b')](_0x5508eb[_0xb02f('0x34')][_0xb02f('0x7a')])?_0x5508eb['query'][_0xb02f('0x7a')]:new Array(_0x5508eb[_0xb02f('0x34')][_0xb02f('0x7a')]);_0x17ecb5[_0xb02f('0x2e')](function(_0x10c9c8){_0xd11747['or'](_0xb02f('0x66'),'%,'+_0x10c9c8+',%');});}if(_0x5508eb[_0xb02f('0x34')][_0xb02f('0x7c')]){var _0x2845d9=_0x5508eb[_0xb02f('0x34')][_0xb02f('0x7c')][_0xb02f('0x7d')]('\x5c','\x5c\x5c')[_0xb02f('0x7d')](/'/g,'\x27\x27');if(qs[_0xb02f('0x7e')](_0x2845d9)){_0x180169['or'](_0xb02f('0x7f'),_0x2845d9+'%');}else{_0x180169['or'](_0xb02f('0x80'),qs['getFullTextValue'](_0x2845d9))['or'](_0xb02f('0x81'),_0x2845d9+'%')['or'](_0xb02f('0x82'),_0x2845d9+'%');}}}_0x3ebbc4['where'](_0x180169);_0x3ebbc4[_0xb02f('0x83')]('i.id');var _0x1b4e0d={'type':db['Sequelize'][_0xb02f('0x84')][_0xb02f('0x85')],'raw':!![]};var _0x5364a9=_0x3ebbc4['clone']();_0x5364a9[_0xb02f('0x41')](_0xb02f('0x86'));_0x5364a9[_0xb02f('0x41')](_0xb02f('0x87'),'unreadMessages');if(_0x26c3a0[_0xb02f('0x88')]){_0x26c3a0[_0xb02f('0x88')][_0xb02f('0x2e')](function(_0x260f97){var _0x539d33=_0x260f97[0x0]==='contactName'?_0x260f97[0x0]:'i.'+_0x260f97[0x0];_0x3ebbc4[_0xb02f('0x88')](_0x539d33,_0x260f97[0x1]===_0xb02f('0x89')?![]:!![]);});}if(!_[_0xb02f('0x6f')](_0x17ecb5)){_0x3ebbc4['having'](_0xd11747);_0x5364a9[_0xb02f('0x3d')]('t.id\x20IN\x20?',_0x17ecb5);}BPromise['resolve']()[_0xb02f('0x26')](function(){if(!_0xc7011e){if(_0x5508eb[_0xb02f('0x34')][_0xb02f('0x70')])return;_0x5364a9[_0xb02f('0x3d')](_0xb02f('0x8a'));_0x3ebbc4['where'](_0xb02f('0x8a'));return;}if(_0x5508eb[_0xb02f('0x8b')][_0xb02f('0x8c')]!=='agent')return;return _0x5508eb[_0xb02f('0x8b')]['getOpenchannelAccounts']({'attributes':['id'],'raw':!![]})[_0xb02f('0x26')](function(_0xf767a7){if(_[_0xb02f('0x6f')](_0xf767a7)){_0x5364a9[_0xb02f('0x3d')]('i.OpenchannelAccountId\x20IS\x20NULL');_0x3ebbc4[_0xb02f('0x3d')]('i.OpenchannelAccountId\x20IS\x20NULL');}else{_0x5364a9['where'](_0xb02f('0x8d'),_[_0xb02f('0x2a')](_0xf767a7,'id'));_0x3ebbc4[_0xb02f('0x3d')](_0xb02f('0x8d'),_[_0xb02f('0x2a')](_0xf767a7,'id'));}});})[_0xb02f('0x26')](function(){if(_0x5508eb['user']['role']===_0xb02f('0x8e')&&!_0xc7011e&&!_0x5508eb[_0xb02f('0x34')][_0xb02f('0x70')])return[];return db[_0xb02f('0x8f')][_0xb02f('0x34')](_0x5364a9['toString'](),_0x1b4e0d);})[_0xb02f('0x26')](function(_0x575c28){_0x14ef66[_0xb02f('0x1f')]=_0x575c28['length'];if(_0x14ef66[_0xb02f('0x1f')]===0x0)return[];return db[_0xb02f('0x8f')]['query'](_0x4e67a4[_0xb02f('0x90')](),_0x1b4e0d)[_0xb02f('0x26')](function(_0x4bbb8d){_0x2cafcb=_[_0xb02f('0x91')](_0x4bbb8d,'id');_0x1b4e0d=_[_0xb02f('0x92')](_0x1b4e0d,{'model':db[_0xb02f('0x31')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5508eb['query'][_0xb02f('0x93')]){_0x26c3a0[_0xb02f('0x38')][_0xb02f('0x2e')](function(_0xd4874b){_0x3ebbc4[_0xb02f('0x41')]('i.'+_0xd4874b);});}else{_0x3ebbc4[_0xb02f('0x41')](_0xb02f('0x87'),_0xb02f('0x94'));_0x3ebbc4[_0xb02f('0x41')](_0xb02f('0x95'),_0xb02f('0x96'));_0x3ebbc4[_0xb02f('0x41')](_0xb02f('0x97'),_0xb02f('0x98'));_0x3ebbc4[_0xb02f('0x41')](_0xb02f('0x99'),_0xb02f('0x9a'));_0x3ebbc4['field'](_0xb02f('0x9b'));_0x3ebbc4[_0xb02f('0x41')]('c.firstName',_0xb02f('0x9c'));_0x3ebbc4[_0xb02f('0x41')]('c.lastName',_0xb02f('0x9d'));_0x3ebbc4['field'](_0xb02f('0x9e'),_0xb02f('0x9f'));_0x3ebbc4[_0xb02f('0x41')]('c.phone','Contact.phone');_0x3ebbc4['field'](_0xb02f('0xa0'),_0xb02f('0xa1'));_0x3ebbc4['field']('c.fax',_0xb02f('0xa2'));_0x3ebbc4[_0xb02f('0x41')](_0xb02f('0xa3'),'Owner.fullname');_0x3ebbc4[_0xb02f('0x41')]('o.internal',_0xb02f('0xa4'));_0x3ebbc4[_0xb02f('0x41')](_0xb02f('0xa5'),'TagIds');}if(_0x26c3a0[_0xb02f('0x21')])_0x3ebbc4[_0xb02f('0x21')](_0x26c3a0[_0xb02f('0x21')]);if(_0x26c3a0[_0xb02f('0x20')])_0x3ebbc4['offset'](_0x26c3a0[_0xb02f('0x20')]);return db['sequelize'][_0xb02f('0x34')](_0x3ebbc4[_0xb02f('0x90')](),_0x1b4e0d);})['then'](function(_0x52ec54){_0x589680[_0xb02f('0x3d')]('ui.OpenchannelInteractionId\x20IN\x20?',_[_0xb02f('0x2a')](_0x52ec54,'id'));return db[_0xb02f('0x8f')][_0xb02f('0x34')](_0x589680[_0xb02f('0x90')](),_0x1b4e0d)['then'](function(_0x595d0b){var _0x2023c9=_[_0xb02f('0xa6')](_0x595d0b,'OpenchannelInteractionId');var _0x2386fb=[];_0x52ec54['forEach'](function(_0x477aa2){_0x2386fb[_0xb02f('0x2f')](updateOpenchannelInteraction(_0x477aa2,_0x2cafcb,_0x2023c9));});return BPromise[_0xb02f('0xa7')](_0x2386fb);});});})[_0xb02f('0x26')](function(_0x4fbee5){_0x14ef66[_0xb02f('0xa8')]=_0x4fbee5;return _0x14ef66;})['then'](respondWithFilteredResult(_0x410785,_0x26c3a0))[_0xb02f('0x30')](handleError(_0x410785,null));};exports[_0xb02f('0xa9')]=function(_0x59c70c,_0x141086){var _0x47a4b1={};if(_0x59c70c[_0xb02f('0x34')][_0xb02f('0x6b')]&&_0x59c70c[_0xb02f('0x34')][_0xb02f('0x6b')]==='from'){_0x47a4b1[_0xb02f('0x43')]=_0x59c70c['params']['id'];}else{_0x47a4b1['id']=_0x59c70c['params']['id'];}var _0x5875d2={'raw':![],'where':_0x47a4b1},_0xa1069a={};_0xa1069a[_0xb02f('0x37')]=_[_0xb02f('0x35')](db['OpenchannelInteraction'][_0xb02f('0x32')]);_0xa1069a['query']=_['keys'](_0x59c70c['query']);_0xa1069a[_0xb02f('0x3e')]=_[_0xb02f('0x36')](_0xa1069a[_0xb02f('0x37')],_0xa1069a[_0xb02f('0x34')]);_0x5875d2[_0xb02f('0x38')]=_[_0xb02f('0x36')](_0xa1069a[_0xb02f('0x37')],qs['fields'](_0x59c70c[_0xb02f('0x34')][_0xb02f('0x93')]));_0x5875d2[_0xb02f('0x38')]=_0x5875d2['attributes']['length']?_0x5875d2[_0xb02f('0x38')]:_0xa1069a[_0xb02f('0x37')];if(_0x59c70c[_0xb02f('0x34')][_0xb02f('0xaa')]){_0x5875d2[_0xb02f('0xab')]=[{'all':!![]}];}_0x5875d2=_[_0xb02f('0x92')]({},_0x5875d2,_0x59c70c[_0xb02f('0xac')]);return db['OpenchannelInteraction'][_0xb02f('0x58')](_0x5875d2)[_0xb02f('0x26')](handleEntityNotFound(_0x141086,null))[_0xb02f('0x26')](respondWithResult(_0x141086,null))[_0xb02f('0x30')](handleError(_0x141086,null));};exports[_0xb02f('0xad')]=function(_0x595a3d,_0x4e698b){return db[_0xb02f('0x31')][_0xb02f('0xad')](_0x595a3d[_0xb02f('0x6d')],{})['then'](respondWithResult(_0x4e698b,0xc9))[_0xb02f('0x30')](handleError(_0x4e698b,null));};exports['update']=function(_0x42e0c6,_0x3cf8c4){if(_0x42e0c6['body']['id']){delete _0x42e0c6['body']['id'];}return db['OpenchannelInteraction'][_0xb02f('0x58')]({'where':{'id':_0x42e0c6['params']['id']}})['then'](handleEntityNotFound(_0x3cf8c4,null))['then'](saveUpdates(_0x42e0c6[_0xb02f('0x6d')],null))[_0xb02f('0x26')](respondWithResult(_0x3cf8c4,null))[_0xb02f('0x30')](handleError(_0x3cf8c4,null));};exports['destroy']=function(_0x97f152,_0x589372){return db[_0xb02f('0x31')][_0xb02f('0x58')]({'where':{'id':_0x97f152[_0xb02f('0xae')]['id']}})[_0xb02f('0x26')](handleEntityNotFound(_0x589372,null))['then'](removeEntity(_0x589372,null))[_0xb02f('0x30')](handleError(_0x589372,null));};exports['describe']=function(_0x5eb135,_0x209cce){return db[_0xb02f('0x31')][_0xb02f('0xaf')]()[_0xb02f('0x26')](respondWithResult(_0x209cce,null))[_0xb02f('0x30')](handleError(_0x209cce,null));};exports['addMessage']=function(_0xd40ebb,_0x29b686,_0x131c44){return db[_0xb02f('0xb0')][_0xb02f('0x58')]({'where':{'id':_0xd40ebb[_0xb02f('0xae')]['id']}})[_0xb02f('0x26')](handleEntityNotFound(_0x29b686,null))[_0xb02f('0x26')](function(_0x28b095){if(_0x28b095){return _0x28b095[_0xb02f('0xb1')](_0xd40ebb[_0xb02f('0x6d')][_0xb02f('0xb2')],_[_0xb02f('0xb3')](_0xd40ebb[_0xb02f('0x6d')],[_0xb02f('0xb2'),'id'])||{});}})[_0xb02f('0x26')](respondWithResult(_0x29b686,null))['catch'](handleError(_0x29b686,null));};exports['getMessages']=function(_0xcd0c40,_0x5daffe,_0xd56b9d){var _0x56ff87={'raw':![],'where':{}};var _0x5e6c81={};var _0x50444b={'count':0x0,'rows':[]};return db[_0xb02f('0x31')][_0xb02f('0xb4')]({'where':{'id':_0xcd0c40['params']['id']}})[_0xb02f('0x26')](handleEntityNotFound(_0x5daffe,null))['then'](function(_0x39f1f5){if(_0x39f1f5){_0x5e6c81[_0xb02f('0x37')]=_['keys'](db['OpenchannelMessage'][_0xb02f('0x32')]);_0x5e6c81[_0xb02f('0x34')]=_[_0xb02f('0x35')](_0xcd0c40[_0xb02f('0x34')]);_0x5e6c81[_0xb02f('0x3e')]=_[_0xb02f('0x36')](_0x5e6c81[_0xb02f('0x37')],_0x5e6c81[_0xb02f('0x34')]);_0x56ff87['attributes']=_['intersection'](_0x5e6c81[_0xb02f('0x37')],qs[_0xb02f('0x93')](_0xcd0c40['query'][_0xb02f('0x93')]));_0x56ff87[_0xb02f('0x38')]=_0x56ff87[_0xb02f('0x38')][_0xb02f('0x39')]?_0x56ff87[_0xb02f('0x38')]:_0x5e6c81[_0xb02f('0x37')];if(!_0xcd0c40[_0xb02f('0x34')][_0xb02f('0x3a')](_0xb02f('0x3b'))){_0x56ff87[_0xb02f('0x21')]=qs[_0xb02f('0x21')](_0xcd0c40[_0xb02f('0x34')][_0xb02f('0x21')]);_0x56ff87[_0xb02f('0x20')]=qs[_0xb02f('0x20')](_0xcd0c40['query']['offset']);}_0x56ff87[_0xb02f('0x88')]=qs[_0xb02f('0x3c')](_0xcd0c40[_0xb02f('0x34')][_0xb02f('0x3c')]);_0x56ff87[_0xb02f('0x3d')]=qs[_0xb02f('0x3e')](_[_0xb02f('0x3f')](_0xcd0c40[_0xb02f('0x34')],_0x5e6c81[_0xb02f('0x3e')]));_0x56ff87[_0xb02f('0x3d')][_0xb02f('0xb5')]=_0x39f1f5['id'];if(_0xcd0c40['query'][_0xb02f('0x7c')]){_0x56ff87[_0xb02f('0x3d')]=_['merge'](_0x56ff87[_0xb02f('0x3d')],{'$or':_[_0xb02f('0x2a')](_0x56ff87['attributes'],function(_0x10b022){var _0x56874a={};_0x56874a[_0x10b022]={'$like':'%'+_0xcd0c40['query'][_0xb02f('0x7c')]+'%'};return _0x56874a;})});}if(_0xcd0c40['query'][_0xb02f('0x74')]){var _0x2e0dcd=_0xcd0c40[_0xb02f('0x34')][_0xb02f('0x74')][_0xb02f('0x5f')](',');var _0x107a90={};_0x107a90[_0x2e0dcd[0x0]]={'$gte':moment(_0x2e0dcd[0x1])[_0xb02f('0xb6')]('YYYY-MM-DD\x20HH:mm:ss')};_0x56ff87[_0xb02f('0x3d')]=_['merge'](_0x56ff87['where'],_0x107a90);}_0x56ff87=_[_0xb02f('0x92')]({},_0x56ff87,_0xcd0c40[_0xb02f('0xac')]);return db['OpenchannelMessage'][_0xb02f('0x1f')]({'where':_0x56ff87[_0xb02f('0x3d')]})[_0xb02f('0x26')](function(_0x368805){_0x50444b[_0xb02f('0x1f')]=_0x368805;if(_0xcd0c40[_0xb02f('0x34')][_0xb02f('0xaa')]){_0x56ff87['include']=[{'all':!![]}];}return db[_0xb02f('0xb0')][_0xb02f('0xb7')](_0x56ff87);})['then'](function(_0x25074c){_0x50444b['rows']=_0x25074c;return _0x50444b;});}})['then'](respondWithFilteredResult(_0x5daffe,_0x56ff87))[_0xb02f('0x30')](handleError(_0x5daffe,null));};exports[_0xb02f('0xb8')]=function(_0x1f939c,_0x487491,_0xb1f899){return db[_0xb02f('0x31')]['find']({'where':{'id':_0x1f939c['params']['id']}})[_0xb02f('0x26')](handleEntityNotFound(_0x487491,null))[_0xb02f('0x26')](function(_0x385cbc){if(_0x385cbc){return _0x385cbc[_0xb02f('0xb9')](_0x1f939c['body'][_0xb02f('0xb2')],_[_0xb02f('0xb3')](_0x1f939c[_0xb02f('0x6d')],[_0xb02f('0xb2'),'id'])||{})[_0xb02f('0xba')](function(){return db[_0xb02f('0x65')][_0xb02f('0xb7')]({'attributes':['id',_0xb02f('0x28'),_0xb02f('0x42')],'where':{'id':_0x1f939c[_0xb02f('0x6d')][_0xb02f('0xb2')]}});})['then'](function(_0x512ed2){socket[_0xb02f('0xbb')](_0xb02f('0xbc'),{'id':Number(_0x1f939c[_0xb02f('0xae')]['id']),'tags':_0x512ed2||[]});return{'id':Number(_0x1f939c[_0xb02f('0xae')]['id']),'tags':_0x512ed2||[]};});}})[_0xb02f('0x26')](respondWithResult(_0x487491,null))[_0xb02f('0x30')](handleError(_0x487491,null));};exports[_0xb02f('0xbd')]=function(_0x484f87,_0x27d9cb,_0x2bde7b){return db['OpenchannelInteraction']['find']({'where':{'id':_0x484f87['params']['id']}})['then'](handleEntityNotFound(_0x27d9cb,null))['then'](function(_0x58fc1e){if(_0x58fc1e){return _0x58fc1e[_0xb02f('0xbd')](_0x484f87['query'][_0xb02f('0xb2')]);}})[_0xb02f('0x26')](respondWithStatusCode(_0x27d9cb,null))['catch'](handleError(_0x27d9cb,null));};exports[_0xb02f('0xbe')]=function(_0x3a1ccc,_0x14bc9b){var _0x2729aa=moment()[_0xb02f('0xbf')]()[_0xb02f('0x90')]();var _0x377f3c=path['join'](config[_0xb02f('0xc0')],_0xb02f('0xc1'),'files',_0xb02f('0xc2'));var _0x3718bf=path[_0xb02f('0xc3')](config[_0xb02f('0xc0')],'server',_0xb02f('0xc4'),_0xb02f('0xc5'));var _0x4a0bdf=path[_0xb02f('0xc3')](_0x377f3c,_0x2729aa);var _0x1769ad=util['format'](_0xb02f('0xc6'),_0x3a1ccc[_0xb02f('0xae')]['id'],_0x2729aa);var _0x4f1da2=path[_0xb02f('0xc3')](_0x377f3c,_0x1769ad);var _0x52df41=[];_0x52df41[_0xb02f('0x2f')]({'model':db[_0xb02f('0x67')],'as':_0xb02f('0x67'),'attributes':['id',_0xb02f('0x2b')],'raw':!![]});_0x52df41[_0xb02f('0x2f')]({'model':db[_0xb02f('0xc7')],'as':_0xb02f('0x5c'),'attributes':['id',_0xb02f('0xc8'),'lastName'],'raw':!![]});if(_0x3a1ccc[_0xb02f('0x34')][_0xb02f('0xc5')]){_0x52df41[_0xb02f('0x2f')]({'model':db['Attachment'],'as':_0xb02f('0xc9'),'raw':!![]});}var _0x215f82=[{'model':db[_0xb02f('0xb0')],'as':'Messages','attributes':['id',_0xb02f('0x6d'),'createdAt','direction',_0xb02f('0xca'),'read'],'include':_0x52df41}];_0x215f82[_0xb02f('0x2f')]({'model':db['OpenchannelAccount'],'as':'Account','attributes':['id',_0xb02f('0x28')]});_0x215f82[_0xb02f('0x2f')]({'model':db[_0xb02f('0x67')],'as':_0xb02f('0xcb'),'attributes':['id',_0xb02f('0x2b')]});return db[_0xb02f('0x31')]['find']({'where':{'id':_0x3a1ccc[_0xb02f('0xae')]['id']},'include':_0x215f82})['then'](handleEntityNotFound(_0x14bc9b,null))['then'](function(_0x123f4d){if(_0x123f4d){var _0x40507f=_0x123f4d[_0xb02f('0xcc')]({'plain':!![]});fs[_0xb02f('0xcd')](_0x4a0bdf);var _0x5280e8={'format':'A4','border':'10px','header':{'height':_0xb02f('0xce'),'contents':{'first':_0xb02f('0xcf')}},'footer':{'height':_0xb02f('0xd0'),'contents':{'default':util[_0xb02f('0xb6')](_0xb02f('0xd1'),util[_0xb02f('0xb6')]('%s\x20#%d',_0xb02f('0xd2'),_0x40507f['id']),moment()[_0xb02f('0xb6')](_0xb02f('0xd3'))[_0xb02f('0x90')]())}}};var _0x421450={'channel':_0xb02f('0xd2'),'account':_0x40507f[_0xb02f('0xd4')][_0xb02f('0x28')],'agent':_0x40507f[_0xb02f('0xcb')]?_0x40507f[_0xb02f('0xcb')]['fullname']:_0xb02f('0xd5'),'createdAt':moment(_0x40507f[_0xb02f('0x72')])[_0xb02f('0xb6')](_0xb02f('0xd6'))[_0xb02f('0x90')](),'closedAt':_0x40507f[_0xb02f('0xd7')]?moment(_0x40507f['closedAt'])['format']('YYYY-MM-DD\x20HH:mm:ss')[_0xb02f('0x90')]():'','disposition':_0x40507f[_0xb02f('0xd8')],'visibility':_0x40507f[_0xb02f('0xd9')]?_0xb02f('0xda'):_0xb02f('0xdb'),'messages':_(_0x40507f[_0xb02f('0xdc')])[_0xb02f('0x7c')]({'secret':![]})[_0xb02f('0x2a')](function(_0x349952){if(_0x349952[_0xb02f('0xc9')]){var _0x2fbbf0=path['join'](_0x3718bf,_0x349952[_0xb02f('0xc9')][_0xb02f('0xdd')]);if(fs['existsSync'](_0x2fbbf0)){fs[_0xb02f('0xde')](_0x2fbbf0)[_0xb02f('0xdf')](fs['createWriteStream'](path[_0xb02f('0xc3')](_0x4a0bdf,_0x349952[_0xb02f('0xc9')][_0xb02f('0xdd')])));}}return{'date':moment(_0x349952['createdAt'])['format'](_0xb02f('0xd6'))['toString'](),'sender':_0x349952[_0xb02f('0xe0')]===_0xb02f('0xe1')?_0x349952[_0xb02f('0x67')]?_0x349952['User']['fullname']:_0xb02f('0xe2'):_0x349952['Contact'][_0xb02f('0xc8')]+(_0x349952[_0xb02f('0x5c')]['lastName']?'\x20'+_0x349952[_0xb02f('0x5c')][_0xb02f('0xe3')]:''),'body':_0x349952['Attachment']?_0x349952[_0xb02f('0xc9')][_0xb02f('0xdd')]:_0x349952['body'],'direction':_0x349952[_0xb02f('0xe0')]===_0xb02f('0xe1')?'A':'C','secret':_0x349952['secret'],'read':_0x349952[_0xb02f('0x79')],'attachment':_0x349952[_0xb02f('0xc9')]};})[_0xb02f('0x5e')]()};return ejs[_0xb02f('0xe4')](path['join'](config['root'],'server','views',_0xb02f('0xe5')),{'interaction':_0x421450})[_0xb02f('0x26')](function(_0x30cb4a){return new BPromise(function(_0x222f22,_0x13966c){pdf[_0xb02f('0xad')](_0x30cb4a,_0x5280e8)['toFile'](path[_0xb02f('0xc3')](_0x4a0bdf,_0xb02f('0xe6')+_0x40507f['id']+'-'+_0x2729aa+_0xb02f('0xe7')),function(_0x43cb3c,_0x51eeb1){if(_0x43cb3c)return _0x13966c(_0x43cb3c);_0x222f22(_0x51eeb1);});});})[_0xb02f('0x26')](function(){return new BPromise(function(_0x44306a,_0x4a9908){zipdir(_0x4a0bdf,{'saveTo':_0x4f1da2},function(_0x3a6bbd,_0xa17efe){if(_0x3a6bbd)return _0x4a9908(_0x3a6bbd);return _0x44306a(_0xa17efe);});})[_0xb02f('0x26')](function(){return new BPromise(function(_0x52ba36,_0x273417){rimraf(_0x4a0bdf,function(_0x474624){if(_0x474624)_0x273417(_0x474624);return _0x52ba36();});});})[_0xb02f('0x26')](function(){return _0x14bc9b[_0xb02f('0xbe')](_0x4f1da2,_0x1769ad,function(_0x55dae1){if(_0x55dae1){console['log'](_0xb02f('0xe8'),_0x55dae1);}else{fs[_0xb02f('0xe9')](_0x4f1da2);}});});});}else{return _0x14bc9b['sendStatus'](0xc8);}})[_0xb02f('0x30')](handleError(_0x14bc9b,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff