18 var _0x0e8a=['squel','crypto','jsforce','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./openchannelInteraction.socket','register','sendStatus','status','json','offset','undefined','count','set','apply','reject','save','update','then','destroy','error','stack','name','Users','map','TagIds','Tags','split','forEach','waiting','talking','answered','total','closed','UserId','unmanaged','OpenchannelInteraction','rawAttributes','model','query','attributes','intersection','hasOwnProperty','nolimit','limit','order','where','filters','pick','field','from','select','u.id','u.fullname','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','a.id\x20=\x20i.OpenchannelAccountId','openchannel_messages','me.OpenchannelInteractionId\x20=\x20i.id','it.OpenchannelInteractionId\x20=\x20i.id','tools_tags','expr','parseSearch','search','sqlOperator','conditions','find','unreadMessages','value','`\x20=\x200','having','`\x20>\x200','Contact','operator','$substring','length','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','type','start','end','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','text','buildExpression','keys','compact','isEmpty','OpenchannelAccountId','concat','createdAt','parse','$lte','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','tag','isArray','filter','replace','isNumeric','i.id\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','i.from\x20LIKE\x20?','SELECT','clone','i.id','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','DESC','t.id\x20IN\x20?','resolve','i.OpenchannelAccountId\x20IS\x20NOT\x20NULL','user','role','getOpenchannelAccounts','i.OpenchannelAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','fields','a.key','a.mandatoryDisposition','CASE\x20WHEN\x20i.from\x20IS\x20NOT\x20NULL\x20AND\x20i.from\x20<>\x20\x27\x27\x20THEN\x20i.from\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.OpenchannelInteractionId\x20IN\x20?','groupBy','push','all','rows','catch','includeAll','options','create','body','params','describe','addMessage','ids','omit','findOne','OpenchannelMessage','sort','$gte','format','YYYY-MM-DD\x20HH:mm:ss','findAll','addTags','setTags','spread','Tag','color','emit','openchannelInteractionTags:save','removeTags','download','join','root','server','files','attachments','transcript-%d-%s.zip','firstName','lastName','Attachment','Messages','direction','secret','OpenchannelAccount','Owner','fullname','mkdirSync','Openchannel','Account','N.A.','disposition','threadId','Public','basename','existsSync','createReadStream','createWriteStream','out','renderFile','downloadInteraction.ejs','transcript-','createPdfFromHTML','log','err','unlinkSync','eml-format','fast-json-patch','request-promise','bluebird','mustache','util','to-csv','ejs','lodash'];(function(_0x5948dd,_0x1f6ac8){var _0xb1f8be=function(_0x31a8d2){while(--_0x31a8d2){_0x5948dd['push'](_0x5948dd['shift']());}};_0xb1f8be(++_0x1f6ac8);}(_0x0e8a,0xe1));var _0xa0e8=function(_0x4c440b,_0x3ea627){_0x4c440b=_0x4c440b-0x0;var _0x2d48cf=_0x0e8a[_0x4c440b];return _0x2d48cf;};'use strict';var emlformat=require(_0xa0e8('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xa0e8('0x1'));var rp=require(_0xa0e8('0x2'));var moment=require('moment');var BPromise=require(_0xa0e8('0x3'));var Mustache=require(_0xa0e8('0x4'));var util=require(_0xa0e8('0x5'));var path=require('path');var sox=require('sox');var csv=require(_0xa0e8('0x6'));var ejs=require(_0xa0e8('0x7'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xa0e8('0x8'));var squel=require(_0xa0e8('0x9'));var crypto=require(_0xa0e8('0xa'));var jsforce=require(_0xa0e8('0xb'));var deskjs=require('desk.js');var toCsv=require(_0xa0e8('0x6'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xa0e8('0xc'));var as=require('../../components/parsers/advancedSearch');var pdf=require('../../components/export/pdf');var hardwareService=require('../../config/license/hardware');var logger=require(_0xa0e8('0xd'))(_0xa0e8('0xe'));var utils=require(_0xa0e8('0xf'));var config=require(_0xa0e8('0x10'));var licenseUtil=require('../../config/license/util');var db=require(_0xa0e8('0x11'))['db'];config[_0xa0e8('0x12')]=_[_0xa0e8('0x13')](config[_0xa0e8('0x12')],{'host':_0xa0e8('0x14'),'port':0x18eb});var socket=require(_0xa0e8('0x15'))(new Redis(config[_0xa0e8('0x12')]));require(_0xa0e8('0x16'))[_0xa0e8('0x17')](socket);function respondWithStatusCode(_0x1a74dd,_0x5a18de){_0x5a18de=_0x5a18de||0xcc;return function(_0x1993db){if(_0x1993db){return _0x1a74dd[_0xa0e8('0x18')](_0x5a18de);}return _0x1a74dd[_0xa0e8('0x19')](_0x5a18de)['end']();};}function respondWithResult(_0x5ddf5d,_0x579d7b){_0x579d7b=_0x579d7b||0xc8;return function(_0x2a3982){if(_0x2a3982){return _0x5ddf5d['status'](_0x579d7b)[_0xa0e8('0x1a')](_0x2a3982);}};}function respondWithFilteredResult(_0x461f67,_0x468172){return function(_0x43ef4){if(_0x43ef4){var _0x225251=typeof _0x468172[_0xa0e8('0x1b')]===_0xa0e8('0x1c')&&typeof _0x468172['limit']==='undefined';var _0x3de80a=_0x43ef4['count'];var _0x508f7a=_0x225251?0x0:_0x468172[_0xa0e8('0x1b')];var _0x14d5d9=_0x225251?_0x43ef4[_0xa0e8('0x1d')]:_0x468172[_0xa0e8('0x1b')]+_0x468172['limit'];var _0x52111f;if(_0x14d5d9>=_0x3de80a){_0x14d5d9=_0x3de80a;_0x52111f=0xc8;}else{_0x52111f=0xce;}_0x461f67['status'](_0x52111f);return _0x461f67[_0xa0e8('0x1e')]('Content-Range',_0x508f7a+'-'+_0x14d5d9+'/'+_0x3de80a)['json'](_0x43ef4);}return null;};}function patchUpdates(_0x164309){return function(_0x1f6e0b){try{jsonpatch[_0xa0e8('0x1f')](_0x1f6e0b,_0x164309,!![]);}catch(_0x54f3f2){return BPromise[_0xa0e8('0x20')](_0x54f3f2);}return _0x1f6e0b[_0xa0e8('0x21')]();};}function saveUpdates(_0x3b16c8,_0x481160){return function(_0x1292d9){if(_0x1292d9){return _0x1292d9[_0xa0e8('0x22')](_0x3b16c8)[_0xa0e8('0x23')](function(_0x18592f){return _0x18592f;});}return null;};}function removeEntity(_0x290e73,_0x1dc0ee){return function(_0x48c28f){if(_0x48c28f){return _0x48c28f[_0xa0e8('0x24')]()[_0xa0e8('0x23')](function(){_0x290e73[_0xa0e8('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3b2634,_0x151fe6){return function(_0x5e41c2){if(!_0x5e41c2){_0x3b2634[_0xa0e8('0x18')](0x194);}return _0x5e41c2;};}function handleError(_0x46c806,_0x2f3949){_0x2f3949=_0x2f3949||0x1f4;return function(_0x4b7324){logger[_0xa0e8('0x25')](_0x4b7324[_0xa0e8('0x26')]);if(_0x4b7324[_0xa0e8('0x27')]){delete _0x4b7324[_0xa0e8('0x27')];}_0x46c806[_0xa0e8('0x19')](_0x2f3949)['send'](_0x4b7324);};}function getInteractionUsers(_0x171dc0,_0x21ad74){return new BPromise(function(_0x1a97bd,_0x442e24){try{if(_0x21ad74[_0x171dc0['id']]){_0x171dc0[_0xa0e8('0x28')]=_[_0xa0e8('0x29')](_0x21ad74[_0x171dc0['id']],function(_0x474fab){return{'id':_0x474fab['id'],'fullname':_0x474fab['fullname']};});}}catch(_0x391884){_0x442e24(_0x391884);}_0x1a97bd(_0x171dc0);});}function getInteractionTags(_0x348a82,_0x2cb06a){return new BPromise(function(_0x56abb4,_0x51ef9d){try{if(_0x348a82[_0xa0e8('0x2a')]){_0x348a82[_0xa0e8('0x2b')]=[];_0x348a82[_0xa0e8('0x2a')][_0xa0e8('0x2c')](',')[_0xa0e8('0x2d')](function(_0x5a32c7){_0x348a82[_0xa0e8('0x2b')]['push'](_0x2cb06a[_0x5a32c7]);});}delete _0x348a82[_0xa0e8('0x2a')];}catch(_0x38420c){_0x51ef9d(_0x38420c);}_0x56abb4(_0x348a82);});}function updateOpenchannelInteraction(_0x41a6b4,_0x4e22f4,_0x83f1a3){return new BPromise(function(_0x5318fb,_0x4a4cbe){return getInteractionUsers(_0x41a6b4,_0x83f1a3)[_0xa0e8('0x23')](function(_0x10ba7e){return getInteractionTags(_0x10ba7e,_0x4e22f4);})['then'](function(_0x178e02){return getStateInteraction(_0x178e02);})[_0xa0e8('0x23')](function(_0x190458){_0x5318fb(_0x190458);})['catch'](function(_0x7c99bb){_0x4a4cbe(_0x7c99bb);});});}function getStateInteraction(_0x3e4076){return new BPromise(function(_0x42703c){_0x3e4076[_0xa0e8('0x2e')]=0x0;_0x3e4076[_0xa0e8('0x2f')]=0x0;_0x3e4076[_0xa0e8('0x30')]=0x0;_0x3e4076['unmanaged']=0x0;_0x3e4076[_0xa0e8('0x31')]=0x0;if(!_0x3e4076[_0xa0e8('0x32')]&&!_0x3e4076[_0xa0e8('0x33')]){_0x3e4076[_0xa0e8('0x2e')]+=0x1;}if(!_0x3e4076[_0xa0e8('0x32')]&&_0x3e4076[_0xa0e8('0x33')]){_0x3e4076['talking']+=0x1;if(_0x3e4076[_0xa0e8('0x2e')]){_0x3e4076[_0xa0e8('0x2e')]-=0x1;}}if(_0x3e4076[_0xa0e8('0x32')]&&_0x3e4076[_0xa0e8('0x33')]){_0x3e4076['answered']+=0x1;if(_0x3e4076['talking']){_0x3e4076[_0xa0e8('0x2f')]-=0x1;}}if(_0x3e4076[_0xa0e8('0x32')]&&!_0x3e4076[_0xa0e8('0x33')]){_0x3e4076[_0xa0e8('0x34')]+=0x1;if(_0x3e4076[_0xa0e8('0x2e')]){_0x3e4076[_0xa0e8('0x2e')]-=0x1;}}_0x3e4076[_0xa0e8('0x31')]+=0x1;_0x42703c(_0x3e4076);});}exports['index']=function(_0x5790d4,_0x4d9ea6){var _0x700294={},_0x20d7a8={},_0x9b45d={'count':0x0,'rows':[]};var _0x3e1127=_[_0xa0e8('0x29')](db[_0xa0e8('0x35')][_0xa0e8('0x36')],function(_0x4ebf60){return{'name':_0x4ebf60['fieldName'],'type':_0x4ebf60['type']['key']};});_0x20d7a8[_0xa0e8('0x37')]=_['map'](_0x3e1127,_0xa0e8('0x27'));_0x20d7a8[_0xa0e8('0x38')]=_['keys'](_0x5790d4[_0xa0e8('0x38')]);_0x20d7a8['filters']=_['intersection'](_0x20d7a8[_0xa0e8('0x37')],_0x20d7a8[_0xa0e8('0x38')]);_0x700294[_0xa0e8('0x39')]=_[_0xa0e8('0x3a')](_0x20d7a8['model'],qs['fields'](_0x5790d4[_0xa0e8('0x38')]['fields']));_0x700294['attributes']=_0x700294['attributes']['length']?_0x700294[_0xa0e8('0x39')]:_0x20d7a8[_0xa0e8('0x37')];if(!_0x5790d4['query'][_0xa0e8('0x3b')](_0xa0e8('0x3c'))){_0x700294['limit']=qs[_0xa0e8('0x3d')](_0x5790d4[_0xa0e8('0x38')][_0xa0e8('0x3d')]);_0x700294['offset']=qs[_0xa0e8('0x1b')](_0x5790d4[_0xa0e8('0x38')]['offset']);}_0x700294[_0xa0e8('0x3e')]=qs['sort'](_0x5790d4[_0xa0e8('0x38')]['sort']);_0x700294[_0xa0e8('0x3f')]=qs[_0xa0e8('0x40')](_[_0xa0e8('0x41')](_0x5790d4[_0xa0e8('0x38')],_0x20d7a8[_0xa0e8('0x40')]),_0x3e1127);var _0x25e56b=[];var _0x18aa0d=squel['select']()[_0xa0e8('0x42')]('id')[_0xa0e8('0x42')]('name')[_0xa0e8('0x42')]('color')[_0xa0e8('0x43')]('tools_tags');var _0x1f95fa=squel[_0xa0e8('0x44')]()[_0xa0e8('0x42')](_0xa0e8('0x45'))['field'](_0xa0e8('0x46'))[_0xa0e8('0x42')]('ui.OpenchannelInteractionId')[_0xa0e8('0x43')](_0xa0e8('0x47'),'ui')[_0xa0e8('0x48')](_0xa0e8('0x49'),'u','u.id\x20=\x20ui.UserId');var _0xcfd94f=squel[_0xa0e8('0x44')]()[_0xa0e8('0x43')](_0xa0e8('0x4a'),'i')['left_join'](_0xa0e8('0x4b'),'c',_0xa0e8('0x4c'))['left_join'](_0xa0e8('0x49'),'o',_0xa0e8('0x4d'))['left_join']('openchannel_accounts','a',_0xa0e8('0x4e'))[_0xa0e8('0x48')](_0xa0e8('0x4f'),'me',_0xa0e8('0x50'))[_0xa0e8('0x48')]('openchannel_interaction_has_tags','it',_0xa0e8('0x51'))['left_join'](_0xa0e8('0x52'),'t','t.id\x20=\x20it.TagId');var _0x1a4e41=squel[_0xa0e8('0x53')]();var _0x26de62=[];var _0x1fd493=squel[_0xa0e8('0x53')]();var _0x1584fb;if(_0x5790d4[_0xa0e8('0x38')]['search']){_0x1584fb=as[_0xa0e8('0x54')](_0x5790d4['query'][_0xa0e8('0x55')]);var _0x23c04f=_0x1584fb[_0xa0e8('0x56')];for(var _0x4a8afc=0x0;_0x4a8afc<_0x1584fb[_0xa0e8('0x57')]['length'];_0x4a8afc++){var _0x21fe25=_0x1584fb[_0xa0e8('0x57')][_0x4a8afc];var _0x3fedc2='i';var _0x3cf9e8=_[_0xa0e8('0x58')](_0x3e1127,[_0xa0e8('0x27'),_0x21fe25[_0xa0e8('0x42')]]);if(!_0x3cf9e8){switch(_0x21fe25[_0xa0e8('0x42')]){case _0xa0e8('0x59'):if(_0x21fe25[_0xa0e8('0x5a')]==0x1){_0xcfd94f['having']('`'+_0x21fe25[_0xa0e8('0x42')]+_0xa0e8('0x5b'));}else{_0xcfd94f[_0xa0e8('0x5c')]('`'+_0x21fe25[_0xa0e8('0x42')]+_0xa0e8('0x5d'));}break;case _0xa0e8('0x5e'):if(_0x21fe25[_0xa0e8('0x5f')]===_0xa0e8('0x60')){if(_0x21fe25[_0xa0e8('0x5a')][_0xa0e8('0x2c')]('\x20')[_0xa0e8('0x61')]>0x1){_0x1a4e41[_0x23c04f](_0xa0e8('0x62'),qs[_0xa0e8('0x63')](_0x21fe25['value']),null);}else{var _0x1357b4='%'+_0x21fe25[_0xa0e8('0x5a')]+'%';_0x1a4e41[_0x23c04f](_0xa0e8('0x64'),_0x1357b4,_0x1357b4,_0x1357b4);}}else{_0x3cf9e8=_[_0xa0e8('0x58')](_0x3e1127,['name',_0xa0e8('0x65')]);_0x21fe25[_0xa0e8('0x42')]='ContactId';_0x217751=as['buildExpression'](_0x3fedc2,_0x3cf9e8[_0xa0e8('0x66')],_0x21fe25);_0x1a4e41[_0x23c04f](_0x217751['text'],_0x217751[_0xa0e8('0x5a')][_0xa0e8('0x67')],_0x217751[_0xa0e8('0x5a')][_0xa0e8('0x68')]);}break;case'Tag':var _0x457431=_0x21fe25[_0xa0e8('0x5a')]['split'](',')['map'](function(_0x1bc1e5){return Number(_0x1bc1e5);});_0x457431['forEach'](function(_0x2c8aa7){_0x1fd493['or'](_0xa0e8('0x69'),'%,'+_0x2c8aa7+',%');});_0x26de62=_[_0xa0e8('0x6a')](_0x26de62,_0x457431);break;case _0xa0e8('0x6b'):if(_0x21fe25[_0xa0e8('0x5f')]===_0xa0e8('0x60')){_0x1a4e41[_0x23c04f]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x21fe25['value']+'%',null);}else{_0x3cf9e8=_[_0xa0e8('0x58')](_0x3e1127,[_0xa0e8('0x27'),_0xa0e8('0x33')]);_0x21fe25[_0xa0e8('0x42')]=_0xa0e8('0x33');_0x217751=as['buildExpression'](_0x3fedc2,_0x3cf9e8[_0xa0e8('0x66')],_0x21fe25);_0x1a4e41[_0x23c04f](_0x217751[_0xa0e8('0x6c')],_0x217751[_0xa0e8('0x5a')][_0xa0e8('0x67')],_0x217751['value'][_0xa0e8('0x68')]);}break;case'body':_0x217751=as[_0xa0e8('0x6d')]('me',null,_0x21fe25);_0x1a4e41[_0x23c04f](_0x217751[_0xa0e8('0x6c')],_0x217751[_0xa0e8('0x5a')]['start'],_0x217751[_0xa0e8('0x5a')][_0xa0e8('0x68')]);break;}}else{var _0x217751=as[_0xa0e8('0x6d')](_0x3fedc2,_0x3cf9e8[_0xa0e8('0x66')],_0x21fe25);_0x1a4e41[_0x23c04f](_0x217751[_0xa0e8('0x6c')],_0x217751['value']['start'],_0x217751[_0xa0e8('0x5a')]['end']);}}}else{var _0x5d9ddb=_(_0x5790d4[_0xa0e8('0x38')])[_0xa0e8('0x6e')]()[_0xa0e8('0x29')](function(_0x28b8f9){return _['some'](_0x3e1127,[_0xa0e8('0x27'),_0x28b8f9])?_0x28b8f9:undefined;})[_0xa0e8('0x6f')]()[_0xa0e8('0x5a')]();if(!_[_0xa0e8('0x70')](_0x5d9ddb)){_0x5d9ddb[_0xa0e8('0x2d')](function(_0x124942){if(_0x124942===_0xa0e8('0x71')){_0xcfd94f[_0xa0e8('0x3f')]('i.OpenchannelAccountId\x20IN\x20?',[][_0xa0e8('0x72')](_0x5790d4[_0xa0e8('0x38')][_0x124942]));}else if(_0x124942===_0xa0e8('0x73')){var _0x4d80af=JSON[_0xa0e8('0x74')](_0x5790d4[_0xa0e8('0x38')][_0x124942])['$gte'];var _0x2c2eb1=JSON[_0xa0e8('0x74')](_0x5790d4[_0xa0e8('0x38')][_0x124942])[_0xa0e8('0x75')];_0xcfd94f[_0xa0e8('0x3f')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x4d80af,_0x2c2eb1);}else{if(_0x5790d4['query'][_0x124942]===_0xa0e8('0x76')){_0xcfd94f[_0xa0e8('0x3f')]('i.'+_0x124942+_0xa0e8('0x77'));}else{_0xcfd94f[_0xa0e8('0x3f')]('i.'+_0x124942+_0xa0e8('0x78'),_0x5790d4[_0xa0e8('0x38')][_0x124942]);}}});}if(_0x5790d4[_0xa0e8('0x38')][_0xa0e8('0x79')]){if(_0x5790d4[_0xa0e8('0x38')]['read']==0x1){_0xcfd94f[_0xa0e8('0x5c')](_0xa0e8('0x7a'));}else{_0xcfd94f[_0xa0e8('0x5c')]('`unreadMessages`\x20>\x200');}}if(_0x5790d4[_0xa0e8('0x38')][_0xa0e8('0x7b')]){_0x26de62=_[_0xa0e8('0x7c')](_0x5790d4['query'][_0xa0e8('0x7b')])?_0x5790d4[_0xa0e8('0x38')]['tag']:new Array(_0x5790d4[_0xa0e8('0x38')][_0xa0e8('0x7b')]);_0x26de62[_0xa0e8('0x2d')](function(_0x3d32ee){_0x1fd493['or'](_0xa0e8('0x69'),'%,'+_0x3d32ee+',%');});}if(_0x5790d4['query'][_0xa0e8('0x7d')]){var _0x2de44b=_0x5790d4[_0xa0e8('0x38')][_0xa0e8('0x7d')][_0xa0e8('0x7e')]('\x5c','\x5c\x5c')[_0xa0e8('0x7e')](/'/g,'\x27\x27');if(qs[_0xa0e8('0x7f')](_0x2de44b)){_0x1a4e41['or'](_0xa0e8('0x80'),_0x2de44b+'%');}else{_0x1a4e41['or'](_0xa0e8('0x81'),qs['getFullTextValue'](_0x2de44b))['or'](_0xa0e8('0x82'),_0x2de44b+'%')['or']('CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?',_0x2de44b+'%');}}}_0xcfd94f[_0xa0e8('0x3f')](_0x1a4e41);_0xcfd94f['group']('i.id');var _0x56bf42={'type':db['Sequelize']['QueryTypes'][_0xa0e8('0x83')],'raw':!![]};var _0x3de4d4=_0xcfd94f[_0xa0e8('0x84')]();_0x3de4d4[_0xa0e8('0x42')](_0xa0e8('0x85'));_0x3de4d4[_0xa0e8('0x42')](_0xa0e8('0x86'),'unreadMessages');if(_0x700294[_0xa0e8('0x3e')]){_0x700294[_0xa0e8('0x3e')]['forEach'](function(_0x388e5a){var _0x56247c=_0x388e5a[0x0]==='contactName'?_0x388e5a[0x0]:'i.'+_0x388e5a[0x0];_0xcfd94f[_0xa0e8('0x3e')](_0x56247c,_0x388e5a[0x1]===_0xa0e8('0x87')?![]:!![]);});}if(!_['isEmpty'](_0x26de62)){_0xcfd94f['having'](_0x1fd493);_0x3de4d4['where'](_0xa0e8('0x88'),_0x26de62);}BPromise[_0xa0e8('0x89')]()[_0xa0e8('0x23')](function(){if(!_0x1584fb){if(_0x5790d4[_0xa0e8('0x38')][_0xa0e8('0x71')])return;_0x3de4d4[_0xa0e8('0x3f')]('i.OpenchannelAccountId\x20IS\x20NOT\x20NULL');_0xcfd94f[_0xa0e8('0x3f')](_0xa0e8('0x8a'));return;}if(_0x5790d4[_0xa0e8('0x8b')][_0xa0e8('0x8c')]!=='agent')return;return _0x5790d4[_0xa0e8('0x8b')][_0xa0e8('0x8d')]({'attributes':['id'],'raw':!![]})[_0xa0e8('0x23')](function(_0x5cc1a9){if(_['isEmpty'](_0x5cc1a9)){_0x3de4d4['where'](_0xa0e8('0x8e'));_0xcfd94f[_0xa0e8('0x3f')](_0xa0e8('0x8e'));}else{_0x3de4d4[_0xa0e8('0x3f')]('i.OpenchannelAccountId\x20IN\x20?',_['map'](_0x5cc1a9,'id'));_0xcfd94f[_0xa0e8('0x3f')]('i.OpenchannelAccountId\x20IN\x20?',_[_0xa0e8('0x29')](_0x5cc1a9,'id'));}});})[_0xa0e8('0x23')](function(){if(_0x5790d4[_0xa0e8('0x8b')][_0xa0e8('0x8c')]==='agent'&&!_0x1584fb&&!_0x5790d4[_0xa0e8('0x38')][_0xa0e8('0x71')])return[];return db[_0xa0e8('0x8f')][_0xa0e8('0x38')](_0x3de4d4[_0xa0e8('0x90')](),_0x56bf42);})[_0xa0e8('0x23')](function(_0x16c408){_0x9b45d[_0xa0e8('0x1d')]=_0x16c408[_0xa0e8('0x61')];if(_0x9b45d[_0xa0e8('0x1d')]===0x0)return[];return db[_0xa0e8('0x8f')][_0xa0e8('0x38')](_0x18aa0d[_0xa0e8('0x90')](),_0x56bf42)[_0xa0e8('0x23')](function(_0x9966ae){_0x25e56b=_[_0xa0e8('0x91')](_0x9966ae,'id');_0x56bf42=_[_0xa0e8('0x92')](_0x56bf42,{'model':db[_0xa0e8('0x35')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5790d4[_0xa0e8('0x38')][_0xa0e8('0x93')]){_0x700294[_0xa0e8('0x39')]['forEach'](function(_0x3fdbd9){_0xcfd94f['field']('i.'+_0x3fdbd9);});}else{_0xcfd94f[_0xa0e8('0x42')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0xa0e8('0x59'));_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0x94'),'Account.key');_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0x95'),'Account.mandatoryDisposition');_0xcfd94f['field'](_0xa0e8('0x96'),_0xa0e8('0x97'));_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0x98'));_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0x99'),_0xa0e8('0x9a'));_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0x9b'),_0xa0e8('0x9c'));_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0x9d'),_0xa0e8('0x9e'));_0xcfd94f['field'](_0xa0e8('0x9f'),_0xa0e8('0xa0'));_0xcfd94f['field'](_0xa0e8('0xa1'),_0xa0e8('0xa2'));_0xcfd94f[_0xa0e8('0x42')]('c.fax',_0xa0e8('0xa3'));_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0xa4'),_0xa0e8('0xa5'));_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0xa6'),_0xa0e8('0xa7'));_0xcfd94f[_0xa0e8('0x42')](_0xa0e8('0xa8'),_0xa0e8('0x2a'));}if(_0x700294[_0xa0e8('0x3d')])_0xcfd94f[_0xa0e8('0x3d')](_0x700294[_0xa0e8('0x3d')]);if(_0x700294['offset'])_0xcfd94f[_0xa0e8('0x1b')](_0x700294[_0xa0e8('0x1b')]);return db[_0xa0e8('0x8f')][_0xa0e8('0x38')](_0xcfd94f[_0xa0e8('0x90')](),_0x56bf42);})[_0xa0e8('0x23')](function(_0x48e541){if(_0x48e541[_0xa0e8('0x61')]>0x0)_0x1f95fa['where'](_0xa0e8('0xa9'),_[_0xa0e8('0x29')](_0x48e541,'id'));return db[_0xa0e8('0x8f')]['query'](_0x1f95fa[_0xa0e8('0x90')](),_0x56bf42)[_0xa0e8('0x23')](function(_0x4056d){var _0x5f5204=_[_0xa0e8('0xaa')](_0x4056d,'OpenchannelInteractionId');var _0x325074=[];_0x48e541[_0xa0e8('0x2d')](function(_0x5a6d40){_0x325074[_0xa0e8('0xab')](updateOpenchannelInteraction(_0x5a6d40,_0x25e56b,_0x5f5204));});return BPromise[_0xa0e8('0xac')](_0x325074);});});})[_0xa0e8('0x23')](function(_0x22bdc1){_0x9b45d[_0xa0e8('0xad')]=_0x22bdc1;return _0x9b45d;})[_0xa0e8('0x23')](respondWithFilteredResult(_0x4d9ea6,_0x700294))[_0xa0e8('0xae')](handleError(_0x4d9ea6,null));};exports['show']=function(_0x18f56f,_0x205f8d){var _0x359329={};if(_0x18f56f[_0xa0e8('0x38')]['type']&&_0x18f56f[_0xa0e8('0x38')][_0xa0e8('0x66')]===_0xa0e8('0x43')){_0x359329[_0xa0e8('0x43')]=_0x18f56f['params']['id'];}else{_0x359329['id']=_0x18f56f['params']['id'];}var _0x52d54b={'raw':![],'where':_0x359329},_0x165934={};_0x165934[_0xa0e8('0x37')]=_[_0xa0e8('0x6e')](db[_0xa0e8('0x35')][_0xa0e8('0x36')]);_0x165934['query']=_[_0xa0e8('0x6e')](_0x18f56f[_0xa0e8('0x38')]);_0x165934['filters']=_['intersection'](_0x165934[_0xa0e8('0x37')],_0x165934[_0xa0e8('0x38')]);_0x52d54b['attributes']=_[_0xa0e8('0x3a')](_0x165934[_0xa0e8('0x37')],qs[_0xa0e8('0x93')](_0x18f56f[_0xa0e8('0x38')][_0xa0e8('0x93')]));_0x52d54b[_0xa0e8('0x39')]=_0x52d54b[_0xa0e8('0x39')][_0xa0e8('0x61')]?_0x52d54b[_0xa0e8('0x39')]:_0x165934['model'];if(_0x18f56f[_0xa0e8('0x38')][_0xa0e8('0xaf')]){_0x52d54b['include']=[{'all':!![]}];}_0x52d54b=_['merge']({},_0x52d54b,_0x18f56f[_0xa0e8('0xb0')]);return db['OpenchannelInteraction'][_0xa0e8('0x58')](_0x52d54b)[_0xa0e8('0x23')](handleEntityNotFound(_0x205f8d,null))[_0xa0e8('0x23')](respondWithResult(_0x205f8d,null))[_0xa0e8('0xae')](handleError(_0x205f8d,null));};exports[_0xa0e8('0xb1')]=function(_0x492b87,_0x514b6e){return db['OpenchannelInteraction'][_0xa0e8('0xb1')](_0x492b87[_0xa0e8('0xb2')],{})['then'](respondWithResult(_0x514b6e,0xc9))[_0xa0e8('0xae')](handleError(_0x514b6e,null));};exports[_0xa0e8('0x22')]=function(_0x541396,_0x173d03){if(_0x541396[_0xa0e8('0xb2')]['id']){delete _0x541396[_0xa0e8('0xb2')]['id'];}return db['OpenchannelInteraction'][_0xa0e8('0x58')]({'where':{'id':_0x541396[_0xa0e8('0xb3')]['id']}})['then'](handleEntityNotFound(_0x173d03,null))[_0xa0e8('0x23')](saveUpdates(_0x541396[_0xa0e8('0xb2')],null))[_0xa0e8('0x23')](respondWithResult(_0x173d03,null))['catch'](handleError(_0x173d03,null));};exports[_0xa0e8('0x24')]=function(_0x1bc6b8,_0x34924b){return db[_0xa0e8('0x35')][_0xa0e8('0x58')]({'where':{'id':_0x1bc6b8[_0xa0e8('0xb3')]['id']}})[_0xa0e8('0x23')](handleEntityNotFound(_0x34924b,null))['then'](removeEntity(_0x34924b,null))[_0xa0e8('0xae')](handleError(_0x34924b,null));};exports[_0xa0e8('0xb4')]=function(_0x2b0a62,_0xb03aff){return db[_0xa0e8('0x35')][_0xa0e8('0xb4')]()[_0xa0e8('0x23')](respondWithResult(_0xb03aff,null))[_0xa0e8('0xae')](handleError(_0xb03aff,null));};exports['addMessage']=function(_0x4e1b43,_0x234f47,_0x350905){return db['OpenchannelMessage'][_0xa0e8('0x58')]({'where':{'id':_0x4e1b43[_0xa0e8('0xb3')]['id']}})['then'](handleEntityNotFound(_0x234f47,null))[_0xa0e8('0x23')](function(_0x3efae5){if(_0x3efae5){return _0x3efae5[_0xa0e8('0xb5')](_0x4e1b43['body'][_0xa0e8('0xb6')],_[_0xa0e8('0xb7')](_0x4e1b43[_0xa0e8('0xb2')],[_0xa0e8('0xb6'),'id'])||{});}})[_0xa0e8('0x23')](respondWithResult(_0x234f47,null))['catch'](handleError(_0x234f47,null));};exports['getMessages']=function(_0xe30bcf,_0x196251,_0x3524d4){var _0x861107={'raw':![],'where':{}};var _0x307b46={};var _0x4be959={'count':0x0,'rows':[]};return db[_0xa0e8('0x35')][_0xa0e8('0xb8')]({'where':{'id':_0xe30bcf[_0xa0e8('0xb3')]['id']}})[_0xa0e8('0x23')](handleEntityNotFound(_0x196251,null))[_0xa0e8('0x23')](function(_0x547716){if(_0x547716){_0x307b46[_0xa0e8('0x37')]=_['keys'](db[_0xa0e8('0xb9')][_0xa0e8('0x36')]);_0x307b46[_0xa0e8('0x38')]=_[_0xa0e8('0x6e')](_0xe30bcf[_0xa0e8('0x38')]);_0x307b46[_0xa0e8('0x40')]=_[_0xa0e8('0x3a')](_0x307b46[_0xa0e8('0x37')],_0x307b46[_0xa0e8('0x38')]);_0x861107[_0xa0e8('0x39')]=_[_0xa0e8('0x3a')](_0x307b46['model'],qs[_0xa0e8('0x93')](_0xe30bcf[_0xa0e8('0x38')]['fields']));_0x861107[_0xa0e8('0x39')]=_0x861107['attributes'][_0xa0e8('0x61')]?_0x861107[_0xa0e8('0x39')]:_0x307b46[_0xa0e8('0x37')];if(!_0xe30bcf[_0xa0e8('0x38')]['hasOwnProperty']('nolimit')){_0x861107[_0xa0e8('0x3d')]=qs['limit'](_0xe30bcf[_0xa0e8('0x38')][_0xa0e8('0x3d')]);_0x861107[_0xa0e8('0x1b')]=qs[_0xa0e8('0x1b')](_0xe30bcf[_0xa0e8('0x38')][_0xa0e8('0x1b')]);}_0x861107[_0xa0e8('0x3e')]=qs[_0xa0e8('0xba')](_0xe30bcf['query'][_0xa0e8('0xba')]);_0x861107[_0xa0e8('0x3f')]=qs[_0xa0e8('0x40')](_[_0xa0e8('0x41')](_0xe30bcf[_0xa0e8('0x38')],_0x307b46[_0xa0e8('0x40')]));_0x861107[_0xa0e8('0x3f')]['OpenchannelInteractionId']=_0x547716['id'];if(_0xe30bcf[_0xa0e8('0x38')][_0xa0e8('0x7d')]){_0x861107[_0xa0e8('0x3f')]=_[_0xa0e8('0x92')](_0x861107[_0xa0e8('0x3f')],{'$or':_[_0xa0e8('0x29')](_0x861107[_0xa0e8('0x39')],function(_0x3d7019){var _0x3abeaa={};_0x3abeaa[_0x3d7019]={'$like':'%'+_0xe30bcf[_0xa0e8('0x38')][_0xa0e8('0x7d')]+'%'};return _0x3abeaa;})});}if(_0xe30bcf[_0xa0e8('0x38')][_0xa0e8('0xbb')]){var _0x16a05b=_0xe30bcf[_0xa0e8('0x38')][_0xa0e8('0xbb')][_0xa0e8('0x2c')](',');var _0x5b4064={};_0x5b4064[_0x16a05b[0x0]]={'$gte':moment(_0x16a05b[0x1])[_0xa0e8('0xbc')](_0xa0e8('0xbd'))};_0x861107[_0xa0e8('0x3f')]=_['merge'](_0x861107['where'],_0x5b4064);}_0x861107=_['merge']({},_0x861107,_0xe30bcf['options']);return db['OpenchannelMessage'][_0xa0e8('0x1d')]({'where':_0x861107[_0xa0e8('0x3f')]})[_0xa0e8('0x23')](function(_0x30814d){_0x4be959[_0xa0e8('0x1d')]=_0x30814d;if(_0xe30bcf[_0xa0e8('0x38')][_0xa0e8('0xaf')]){_0x861107['include']=[{'all':!![]}];}return db[_0xa0e8('0xb9')][_0xa0e8('0xbe')](_0x861107);})[_0xa0e8('0x23')](function(_0x23229a){_0x4be959[_0xa0e8('0xad')]=_0x23229a;return _0x4be959;});}})['then'](respondWithFilteredResult(_0x196251,_0x861107))[_0xa0e8('0xae')](handleError(_0x196251,null));};exports[_0xa0e8('0xbf')]=function(_0x2739dc,_0x360543,_0x460eee){return db[_0xa0e8('0x35')][_0xa0e8('0x58')]({'where':{'id':_0x2739dc[_0xa0e8('0xb3')]['id']}})[_0xa0e8('0x23')](handleEntityNotFound(_0x360543,null))[_0xa0e8('0x23')](function(_0x1e0960){if(_0x1e0960){return _0x1e0960[_0xa0e8('0xc0')](_0x2739dc['body'][_0xa0e8('0xb6')],_[_0xa0e8('0xb7')](_0x2739dc[_0xa0e8('0xb2')],[_0xa0e8('0xb6'),'id'])||{})[_0xa0e8('0xc1')](function(){return db[_0xa0e8('0xc2')]['findAll']({'attributes':['id',_0xa0e8('0x27'),_0xa0e8('0xc3')],'where':{'id':_0x2739dc['body'][_0xa0e8('0xb6')]}});})[_0xa0e8('0x23')](function(_0x227230){socket[_0xa0e8('0xc4')](_0xa0e8('0xc5'),{'id':Number(_0x2739dc[_0xa0e8('0xb3')]['id']),'tags':_0x227230||[]});return{'id':Number(_0x2739dc[_0xa0e8('0xb3')]['id']),'tags':_0x227230||[]};});}})['then'](respondWithResult(_0x360543,null))['catch'](handleError(_0x360543,null));};exports[_0xa0e8('0xc6')]=function(_0x27fb51,_0x31e747,_0x2c1f42){return db[_0xa0e8('0x35')]['find']({'where':{'id':_0x27fb51[_0xa0e8('0xb3')]['id']}})[_0xa0e8('0x23')](handleEntityNotFound(_0x31e747,null))[_0xa0e8('0x23')](function(_0xa9583b){if(_0xa9583b){return _0xa9583b[_0xa0e8('0xc6')](_0x27fb51['query'][_0xa0e8('0xb6')]);}})[_0xa0e8('0x23')](respondWithStatusCode(_0x31e747,null))['catch'](handleError(_0x31e747,null));};exports[_0xa0e8('0xc7')]=function(_0x2d6137,_0x556867){var _0x4f5879=moment()['unix']()[_0xa0e8('0x90')]();var _0x58af85=path[_0xa0e8('0xc8')](config[_0xa0e8('0xc9')],_0xa0e8('0xca'),_0xa0e8('0xcb'),'tmp');var _0x251b9b=path[_0xa0e8('0xc8')](config[_0xa0e8('0xc9')],_0xa0e8('0xca'),_0xa0e8('0xcb'),_0xa0e8('0xcc'));var _0x4ff1e5=path[_0xa0e8('0xc8')](_0x58af85,_0x4f5879);var _0x2fdd12=util[_0xa0e8('0xbc')](_0xa0e8('0xcd'),_0x2d6137[_0xa0e8('0xb3')]['id'],_0x4f5879);var _0x28ad07=path[_0xa0e8('0xc8')](_0x58af85,_0x2fdd12);var _0x242e77=[];_0x242e77[_0xa0e8('0xab')]({'model':db['User'],'as':'User','attributes':['id','fullname'],'raw':!![]});_0x242e77['push']({'model':db['CmContact'],'as':_0xa0e8('0x5e'),'attributes':['id',_0xa0e8('0xce'),_0xa0e8('0xcf')],'raw':!![]});if(_0x2d6137[_0xa0e8('0x38')]['attachments']){_0x242e77[_0xa0e8('0xab')]({'model':db[_0xa0e8('0xd0')],'as':_0xa0e8('0xd0'),'raw':!![]});}var _0x2a76fc=[{'model':db[_0xa0e8('0xb9')],'as':_0xa0e8('0xd1'),'attributes':['id','body','createdAt',_0xa0e8('0xd2'),_0xa0e8('0xd3'),_0xa0e8('0x79')],'include':_0x242e77}];_0x2a76fc[_0xa0e8('0xab')]({'model':db[_0xa0e8('0xd4')],'as':'Account','attributes':['id',_0xa0e8('0x27')]});_0x2a76fc[_0xa0e8('0xab')]({'model':db[_0xa0e8('0x6b')],'as':_0xa0e8('0xd5'),'attributes':['id',_0xa0e8('0xd6')]});return db[_0xa0e8('0x35')][_0xa0e8('0x58')]({'where':{'id':_0x2d6137['params']['id']},'include':_0x2a76fc})['then'](handleEntityNotFound(_0x556867,null))[_0xa0e8('0x23')](function(_0x5c6d09){if(_0x5c6d09){var _0x4240a2=_0x5c6d09['get']({'plain':!![]});fs[_0xa0e8('0xd7')](_0x4ff1e5);var _0x984025={'channel':_0xa0e8('0xd8'),'account':_0x4240a2[_0xa0e8('0xd9')][_0xa0e8('0x27')],'agent':_0x4240a2[_0xa0e8('0xd5')]?_0x4240a2[_0xa0e8('0xd5')][_0xa0e8('0xd6')]:_0xa0e8('0xda'),'createdAt':moment(_0x4240a2[_0xa0e8('0x73')])[_0xa0e8('0xbc')](_0xa0e8('0xbd'))[_0xa0e8('0x90')](),'closedAt':_0x4240a2[_0xa0e8('0x32')]?moment(_0x4240a2['closedAt'])[_0xa0e8('0xbc')]('YYYY-MM-DD\x20HH:mm:ss')['toString']():'','disposition':_0x4240a2[_0xa0e8('0xdb')],'visibility':_0x4240a2[_0xa0e8('0xdc')]?_0xa0e8('0xdd'):'Private','messages':_(_0x4240a2[_0xa0e8('0xd1')])[_0xa0e8('0x7d')]({'secret':![]})[_0xa0e8('0x29')](function(_0x2644f3){if(_0x2644f3[_0xa0e8('0xd0')]){var _0x45b40a=path['join'](_0x251b9b,_0x2644f3['Attachment'][_0xa0e8('0xde')]);if(fs[_0xa0e8('0xdf')](_0x45b40a)){fs[_0xa0e8('0xe0')](_0x45b40a)['pipe'](fs[_0xa0e8('0xe1')](path['join'](_0x4ff1e5,_0x2644f3[_0xa0e8('0xd0')][_0xa0e8('0xde')])));}}return{'date':moment(_0x2644f3[_0xa0e8('0x73')])['format'](_0xa0e8('0xbd'))['toString'](),'sender':_0x2644f3['direction']===_0xa0e8('0xe2')?_0x2644f3[_0xa0e8('0x6b')]?_0x2644f3[_0xa0e8('0x6b')][_0xa0e8('0xd6')]:'System':_0x2644f3[_0xa0e8('0x5e')][_0xa0e8('0xce')]+(_0x2644f3[_0xa0e8('0x5e')]['lastName']?'\x20'+_0x2644f3[_0xa0e8('0x5e')][_0xa0e8('0xcf')]:''),'body':_0x2644f3[_0xa0e8('0xd0')]?_0x2644f3[_0xa0e8('0xd0')]['basename']:_0x2644f3[_0xa0e8('0xb2')],'direction':_0x2644f3[_0xa0e8('0xd2')]===_0xa0e8('0xe2')?'A':'C','secret':_0x2644f3[_0xa0e8('0xd3')],'read':_0x2644f3[_0xa0e8('0x79')],'attachment':_0x2644f3['Attachment']};})[_0xa0e8('0x5a')]()};return ejs[_0xa0e8('0xe3')](path[_0xa0e8('0xc8')](config['root'],'server','views',_0xa0e8('0xe4')),{'interaction':_0x984025})[_0xa0e8('0x23')](function(_0x31dafc){var _0x419846=path[_0xa0e8('0xc8')](_0x4ff1e5,_0xa0e8('0xe5')+_0x4240a2['id']+'-'+_0x4f5879+'.pdf');var _0x9b7236={'path':_0x419846,'channel':'Openchannel','interactionId':_0x4240a2['id']};return pdf[_0xa0e8('0xe6')](_0x31dafc,_0x9b7236);})['then'](function(){return new BPromise(function(_0x230235,_0xce6df){zipdir(_0x4ff1e5,{'saveTo':_0x28ad07},function(_0x1298e9,_0x317c99){if(_0x1298e9)return _0xce6df(_0x1298e9);return _0x230235(_0x317c99);});})[_0xa0e8('0x23')](function(){return new BPromise(function(_0x30f2fa,_0x5f383d){rimraf(_0x4ff1e5,function(_0x4a36fd){if(_0x4a36fd)_0x5f383d(_0x4a36fd);return _0x30f2fa();});});})[_0xa0e8('0x23')](function(){return _0x556867[_0xa0e8('0xc7')](_0x28ad07,_0x2fdd12,function(_0x3528f9){if(_0x3528f9){console[_0xa0e8('0xe7')](_0xa0e8('0xe8'),_0x3528f9);}else{fs[_0xa0e8('0xe9')](_0x28ad07);}});});});}else{return _0x556867[_0xa0e8('0x18')](0xc8);}})['catch'](handleError(_0x556867,null));};
git://repos.xcallymotion.com / motion2.git / blob