Built motion from commit (unavailable).|2.5.14
[motion2.git] / server / api / openchannelInteraction / openchannelInteraction.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0x55f6=['UserId','body','some','compact','OpenchannelAccountId','where','i.OpenchannelAccountId\x20IN\x20?','concat','createdAt','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','isArray','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','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','i.id','Sequelize','QueryTypes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','order','contactName','DESC','isEmpty','t.id\x20IN\x20?','resolve','journey','i.OpenchannelAccountId\x20IS\x20NOT\x20NULL','user','role','agent','i.OpenchannelAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','fields','a.key','Account.key','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.*','c.firstName','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','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.OpenchannelInteractionId\x20IN\x20?','groupBy','OpenchannelInteractionId','all','rows','show','params','includeAll','describe','addMessage','OpenchannelMessage','ids','omit','getMessages','format','YYYY-MM-DD\x20HH:mm:ss','options','include','findAll','emit','openchannelInteractionTags:save','removeTags','unix','join','root','server','files','tmp','transcript-%d-%s.zip','push','CmContact','firstName','lastName','Attachment','Messages','secret','OpenchannelAccount','Account','10px','<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','YYYY-MM-DD','Owner','N.A.','Public','Private','basename','existsSync','createReadStream','createWriteStream','out','System','direction','renderFile','views','create','toFile','log','err','unlinkSync','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','ejs','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','defaults','redis','localhost','./openchannelInteraction.socket','register','sendStatus','status','end','count','offset','limit','Content-Range','json','apply','update','then','destroy','error','stack','name','send','Users','map','fullname','Tags','TagIds','split','forEach','catch','OpenchannelInteraction','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','length','hasOwnProperty','nolimit','sort','select','field','color','from','tools_tags','u.fullname','user_has_openchannel_interactions','left_join','users','u.id\x20=\x20ui.UserId','openchannel_interactions','o.id\x20=\x20i.UserId','openchannel_accounts','a.id\x20=\x20i.OpenchannelAccountId','openchannel_messages','openchannel_interaction_has_tags','it.OpenchannelInteractionId\x20=\x20i.id','expr','search','parseSearch','conditions','find','unreadMessages','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?','ContactId','buildExpression','text','start','Tag','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?'];(function(_0x1ff2ec,_0x386e86){var _0x405683=function(_0x22f921){while(--_0x22f921){_0x1ff2ec['push'](_0x1ff2ec['shift']());}};_0x405683(++_0x386e86);}(_0x55f6,0x17a));var _0x655f=function(_0x1a0d09,_0x228e8f){_0x1a0d09=_0x1a0d09-0x0;var _0x507f0a=_0x55f6[_0x1a0d09];return _0x507f0a;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x655f('0x0'));var rimraf=require(_0x655f('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x655f('0x2'));var rp=require(_0x655f('0x3'));var moment=require(_0x655f('0x4'));var BPromise=require(_0x655f('0x5'));var Mustache=require(_0x655f('0x6'));var util=require(_0x655f('0x7'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x655f('0x8'));var fs=require('fs');var _=require('lodash');var squel=require(_0x655f('0x9'));var crypto=require(_0x655f('0xa'));var jsforce=require(_0x655f('0xb'));var deskjs=require(_0x655f('0xc'));var toCsv=require(_0x655f('0xd'));var querystring=require(_0x655f('0xe'));var Papa=require(_0x655f('0xf'));var Redis=require(_0x655f('0x10'));var authService=require(_0x655f('0x11'));var qs=require(_0x655f('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x655f('0x13'));var logger=require(_0x655f('0x14'))(_0x655f('0x15'));var utils=require(_0x655f('0x16'));var config=require(_0x655f('0x17'));var licenseUtil=require(_0x655f('0x18'));var db=require('../../mysqldb')['db'];config['redis']=_[_0x655f('0x19')](config[_0x655f('0x1a')],{'host':_0x655f('0x1b'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x655f('0x1a')]));require(_0x655f('0x1c'))[_0x655f('0x1d')](socket);function respondWithStatusCode(_0x203b64,_0x1c3492){_0x1c3492=_0x1c3492||0xcc;return function(_0x382cfe){if(_0x382cfe){return _0x203b64[_0x655f('0x1e')](_0x1c3492);}return _0x203b64[_0x655f('0x1f')](_0x1c3492)[_0x655f('0x20')]();};}function respondWithResult(_0x15d938,_0x6ce5d6){_0x6ce5d6=_0x6ce5d6||0xc8;return function(_0x4fdade){if(_0x4fdade){return _0x15d938[_0x655f('0x1f')](_0x6ce5d6)['json'](_0x4fdade);}};}function respondWithFilteredResult(_0xb7abf2,_0x4a9b23){return function(_0x2d0674){if(_0x2d0674){var _0x30927b=_0x2d0674[_0x655f('0x21')],_0x68be57=_0x4a9b23[_0x655f('0x22')],_0x4954a4=_0x4a9b23['offset']+_0x4a9b23[_0x655f('0x23')],_0x5552d7;if(_0x4954a4>=_0x30927b){_0x4954a4=_0x30927b;_0x5552d7=0xc8;}else{_0x5552d7=0xce;}_0xb7abf2['status'](_0x5552d7);return _0xb7abf2['set'](_0x655f('0x24'),_0x68be57+'-'+_0x4954a4+'/'+_0x30927b)[_0x655f('0x25')](_0x2d0674);}return null;};}function patchUpdates(_0x2c7768){return function(_0x193eb0){try{jsonpatch[_0x655f('0x26')](_0x193eb0,_0x2c7768,!![]);}catch(_0x47190b){return BPromise['reject'](_0x47190b);}return _0x193eb0['save']();};}function saveUpdates(_0x2eb59b,_0x32108e){return function(_0x2c4d06){if(_0x2c4d06){return _0x2c4d06[_0x655f('0x27')](_0x2eb59b)[_0x655f('0x28')](function(_0x3fc5cf){return _0x3fc5cf;});}return null;};}function removeEntity(_0xe5be77,_0x233a06){return function(_0x28b1cf){if(_0x28b1cf){return _0x28b1cf[_0x655f('0x29')]()[_0x655f('0x28')](function(){_0xe5be77[_0x655f('0x1f')](0xcc)[_0x655f('0x20')]();});}};}function handleEntityNotFound(_0x52a061,_0x1c3b76){return function(_0x43c3b7){if(!_0x43c3b7){_0x52a061[_0x655f('0x1e')](0x194);}return _0x43c3b7;};}function handleError(_0x5823cc,_0x41bdc8){_0x41bdc8=_0x41bdc8||0x1f4;return function(_0x4ef92d){logger[_0x655f('0x2a')](_0x4ef92d[_0x655f('0x2b')]);if(_0x4ef92d[_0x655f('0x2c')]){delete _0x4ef92d[_0x655f('0x2c')];}_0x5823cc[_0x655f('0x1f')](_0x41bdc8)[_0x655f('0x2d')](_0x4ef92d);};}function getInteractionUsers(_0x1c35f1,_0x1ed77c){return new BPromise(function(_0x4b3108,_0x3bc2be){try{if(_0x1ed77c[_0x1c35f1['id']]){_0x1c35f1[_0x655f('0x2e')]=_[_0x655f('0x2f')](_0x1ed77c[_0x1c35f1['id']],function(_0x21e803){return{'id':_0x21e803['id'],'fullname':_0x21e803[_0x655f('0x30')]};});}}catch(_0x4a0071){_0x3bc2be(_0x4a0071);}_0x4b3108(_0x1c35f1);});}function getInteractionTags(_0x5123a3,_0x2d24f3){return new BPromise(function(_0x1dbc8d,_0x106108){try{if(_0x5123a3['TagIds']){_0x5123a3[_0x655f('0x31')]=[];_0x5123a3[_0x655f('0x32')][_0x655f('0x33')](',')[_0x655f('0x34')](function(_0x4e84c0){_0x5123a3[_0x655f('0x31')]['push'](_0x2d24f3[_0x4e84c0]);});}delete _0x5123a3['TagIds'];}catch(_0x390e36){_0x106108(_0x390e36);}_0x1dbc8d(_0x5123a3);});}function updateOpenchannelInteraction(_0x316ecc,_0x2c3d57,_0xf03e51){return new BPromise(function(_0x3f9979,_0x30a861){return getInteractionUsers(_0x316ecc,_0xf03e51)[_0x655f('0x28')](function(_0x5304f4){return getInteractionTags(_0x5304f4,_0x2c3d57);})[_0x655f('0x28')](function(_0x14c917){_0x3f9979(_0x14c917);})[_0x655f('0x35')](function(_0x1b0848){_0x30a861(_0x1b0848);});});}exports['index']=function(_0x4fc22b,_0x57e97c){var _0x3f4c42={},_0x34b799={},_0x2ab879={'count':0x0,'rows':[]};var _0x374f47=_[_0x655f('0x2f')](db[_0x655f('0x36')][_0x655f('0x37')],function(_0xda0272){return{'name':_0xda0272[_0x655f('0x38')],'type':_0xda0272[_0x655f('0x39')][_0x655f('0x3a')]};});_0x34b799[_0x655f('0x3b')]=_['map'](_0x374f47,'name');_0x34b799[_0x655f('0x3c')]=_[_0x655f('0x3d')](_0x4fc22b[_0x655f('0x3c')]);_0x34b799[_0x655f('0x3e')]=_[_0x655f('0x3f')](_0x34b799[_0x655f('0x3b')],_0x34b799[_0x655f('0x3c')]);_0x3f4c42[_0x655f('0x40')]=_[_0x655f('0x3f')](_0x34b799[_0x655f('0x3b')],qs['fields'](_0x4fc22b[_0x655f('0x3c')]['fields']));_0x3f4c42[_0x655f('0x40')]=_0x3f4c42[_0x655f('0x40')][_0x655f('0x41')]?_0x3f4c42[_0x655f('0x40')]:_0x34b799['model'];if(!_0x4fc22b[_0x655f('0x3c')][_0x655f('0x42')](_0x655f('0x43'))){_0x3f4c42[_0x655f('0x23')]=qs[_0x655f('0x23')](_0x4fc22b[_0x655f('0x3c')]['limit']);_0x3f4c42[_0x655f('0x22')]=qs[_0x655f('0x22')](_0x4fc22b[_0x655f('0x3c')][_0x655f('0x22')]);}_0x3f4c42['order']=qs[_0x655f('0x44')](_0x4fc22b[_0x655f('0x3c')][_0x655f('0x44')]);_0x3f4c42['where']=qs[_0x655f('0x3e')](_['pick'](_0x4fc22b[_0x655f('0x3c')],_0x34b799['filters']),_0x374f47);var _0x573108=[];var _0x3b5b99=squel[_0x655f('0x45')]()[_0x655f('0x46')]('id')[_0x655f('0x46')](_0x655f('0x2c'))['field'](_0x655f('0x47'))[_0x655f('0x48')](_0x655f('0x49'));var _0x336766=squel[_0x655f('0x45')]()[_0x655f('0x46')]('u.id')[_0x655f('0x46')](_0x655f('0x4a'))[_0x655f('0x46')]('ui.OpenchannelInteractionId')[_0x655f('0x48')](_0x655f('0x4b'),'ui')[_0x655f('0x4c')](_0x655f('0x4d'),'u',_0x655f('0x4e'));var _0x14c175=squel[_0x655f('0x45')]()[_0x655f('0x48')](_0x655f('0x4f'),'i')[_0x655f('0x4c')]('cm_contacts','c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x655f('0x4c')](_0x655f('0x4d'),'o',_0x655f('0x50'))[_0x655f('0x4c')](_0x655f('0x51'),'a',_0x655f('0x52'))['left_join'](_0x655f('0x53'),'me','me.OpenchannelInteractionId\x20=\x20i.id')[_0x655f('0x4c')](_0x655f('0x54'),'it',_0x655f('0x55'))[_0x655f('0x4c')](_0x655f('0x49'),'t','t.id\x20=\x20it.TagId');var _0x239fde=squel[_0x655f('0x56')]();var _0xd92e18=[];var _0x14ba62=squel[_0x655f('0x56')]();var _0x3aece5;if(_0x4fc22b[_0x655f('0x3c')][_0x655f('0x57')]){_0x3aece5=as[_0x655f('0x58')](_0x4fc22b[_0x655f('0x3c')][_0x655f('0x57')]);var _0x41d4f3=_0x3aece5['sqlOperator'];for(var _0x3e9f06=0x0;_0x3e9f06<_0x3aece5[_0x655f('0x59')][_0x655f('0x41')];_0x3e9f06++){var _0x421132=_0x3aece5['conditions'][_0x3e9f06];var _0x441eed='i';var _0xaabbbb=_[_0x655f('0x5a')](_0x374f47,[_0x655f('0x2c'),_0x421132['field']]);if(!_0xaabbbb){switch(_0x421132['field']){case _0x655f('0x5b'):if(_0x421132['value']==0x1){_0x14c175[_0x655f('0x5c')]('`'+_0x421132[_0x655f('0x46')]+_0x655f('0x5d'));}else{_0x14c175[_0x655f('0x5c')]('`'+_0x421132[_0x655f('0x46')]+_0x655f('0x5e'));}break;case _0x655f('0x5f'):if(_0x421132[_0x655f('0x60')]===_0x655f('0x61')){if(_0x421132[_0x655f('0x62')][_0x655f('0x33')]('\x20')['length']>0x1){_0x239fde[_0x41d4f3](_0x655f('0x63'),qs[_0x655f('0x64')](_0x421132[_0x655f('0x62')]),null);}else{var _0x32c23b='%'+_0x421132[_0x655f('0x62')]+'%';_0x239fde[_0x41d4f3](_0x655f('0x65'),_0x32c23b,_0x32c23b,_0x32c23b);}}else{_0xaabbbb=_[_0x655f('0x5a')](_0x374f47,['name',_0x655f('0x66')]);_0x421132['field']='ContactId';_0x1ee8d7=as[_0x655f('0x67')](_0x441eed,_0xaabbbb[_0x655f('0x39')],_0x421132);_0x239fde[_0x41d4f3](_0x1ee8d7[_0x655f('0x68')],_0x1ee8d7['value'][_0x655f('0x69')],_0x1ee8d7[_0x655f('0x62')][_0x655f('0x20')]);}break;case _0x655f('0x6a'):var _0x39474a=_0x421132[_0x655f('0x62')][_0x655f('0x33')](',')['map'](function(_0x240257){return Number(_0x240257);});_0x39474a[_0x655f('0x34')](function(_0x3bcc9f){_0x14ba62['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x3bcc9f+',%');});_0xd92e18=_[_0x655f('0x6b')](_0xd92e18,_0x39474a);break;case _0x655f('0x6c'):if(_0x421132[_0x655f('0x60')]===_0x655f('0x61')){_0x239fde[_0x41d4f3](_0x655f('0x6d'),'%'+_0x421132[_0x655f('0x62')]+'%',null);}else{_0xaabbbb=_[_0x655f('0x5a')](_0x374f47,[_0x655f('0x2c'),_0x655f('0x6e')]);_0x421132[_0x655f('0x46')]=_0x655f('0x6e');_0x1ee8d7=as[_0x655f('0x67')](_0x441eed,_0xaabbbb[_0x655f('0x39')],_0x421132);_0x239fde[_0x41d4f3](_0x1ee8d7['text'],_0x1ee8d7[_0x655f('0x62')]['start'],_0x1ee8d7[_0x655f('0x62')]['end']);}break;case _0x655f('0x6f'):_0x1ee8d7=as['buildExpression']('me',null,_0x421132);_0x239fde[_0x41d4f3](_0x1ee8d7[_0x655f('0x68')],_0x1ee8d7[_0x655f('0x62')][_0x655f('0x69')],_0x1ee8d7[_0x655f('0x62')][_0x655f('0x20')]);break;}}else{var _0x1ee8d7=as[_0x655f('0x67')](_0x441eed,_0xaabbbb[_0x655f('0x39')],_0x421132);_0x239fde[_0x41d4f3](_0x1ee8d7['text'],_0x1ee8d7[_0x655f('0x62')][_0x655f('0x69')],_0x1ee8d7[_0x655f('0x62')][_0x655f('0x20')]);}}}else{var _0x335630=_(_0x4fc22b[_0x655f('0x3c')])['keys']()['map'](function(_0x397381){return _[_0x655f('0x70')](_0x374f47,[_0x655f('0x2c'),_0x397381])?_0x397381:undefined;})[_0x655f('0x71')]()[_0x655f('0x62')]();if(!_['isEmpty'](_0x335630)){_0x335630[_0x655f('0x34')](function(_0x26b646){if(_0x26b646===_0x655f('0x72')){_0x14c175[_0x655f('0x73')](_0x655f('0x74'),[][_0x655f('0x75')](_0x4fc22b[_0x655f('0x3c')][_0x26b646]));}else if(_0x26b646===_0x655f('0x76')){var _0xd9c137=JSON[_0x655f('0x77')](_0x4fc22b['query'][_0x26b646])[_0x655f('0x78')];var _0x1c9b4f=JSON[_0x655f('0x77')](_0x4fc22b[_0x655f('0x3c')][_0x26b646])['$lte'];_0x14c175[_0x655f('0x73')](_0x655f('0x79'),_0xd9c137,_0x1c9b4f);}else{if(_0x4fc22b['query'][_0x26b646]===_0x655f('0x7a')){_0x14c175[_0x655f('0x73')]('i.'+_0x26b646+_0x655f('0x7b'));}else{_0x14c175[_0x655f('0x73')]('i.'+_0x26b646+_0x655f('0x7c'),_0x4fc22b['query'][_0x26b646]);}}});}if(_0x4fc22b[_0x655f('0x3c')][_0x655f('0x7d')]){if(_0x4fc22b[_0x655f('0x3c')][_0x655f('0x7d')]==0x1){_0x14c175[_0x655f('0x5c')](_0x655f('0x7e'));}else{_0x14c175['having'](_0x655f('0x7f'));}}if(_0x4fc22b[_0x655f('0x3c')][_0x655f('0x80')]){_0xd92e18=_[_0x655f('0x81')](_0x4fc22b[_0x655f('0x3c')]['tag'])?_0x4fc22b['query']['tag']:new Array(_0x4fc22b['query']['tag']);_0xd92e18[_0x655f('0x34')](function(_0x2eb465){_0x14ba62['or'](_0x655f('0x82'),'%,'+_0x2eb465+',%');});}if(_0x4fc22b[_0x655f('0x3c')][_0x655f('0x83')]){var _0x217a38=_0x4fc22b[_0x655f('0x3c')][_0x655f('0x83')][_0x655f('0x84')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0x655f('0x85')](_0x217a38)){_0x239fde['or'](_0x655f('0x86'),_0x217a38+'%');}else{_0x239fde['or'](_0x655f('0x87'),qs[_0x655f('0x64')](_0x217a38))['or'](_0x655f('0x88'),_0x217a38+'%')['or'](_0x655f('0x89'),_0x217a38+'%');}}}_0x14c175['where'](_0x239fde);_0x14c175[_0x655f('0x8a')](_0x655f('0x8b'));var _0x4f7f10={'type':db[_0x655f('0x8c')][_0x655f('0x8d')]['SELECT'],'raw':!![]};var _0xcf1459=_0x14c175['clone']();_0xcf1459['field'](_0x655f('0x8b'));_0xcf1459['field'](_0x655f('0x8e'),_0x655f('0x5b'));if(_0x3f4c42[_0x655f('0x8f')]){_0x3f4c42[_0x655f('0x8f')][_0x655f('0x34')](function(_0x36ca31){var _0xb17ea2=_0x36ca31[0x0]===_0x655f('0x90')?_0x36ca31[0x0]:'i.'+_0x36ca31[0x0];_0x14c175[_0x655f('0x8f')](_0xb17ea2,_0x36ca31[0x1]===_0x655f('0x91')?![]:!![]);});}if(!_[_0x655f('0x92')](_0xd92e18)){_0x14c175['having'](_0x14ba62);_0xcf1459[_0x655f('0x73')](_0x655f('0x93'),_0xd92e18);}BPromise[_0x655f('0x94')]()['then'](function(){if(!_0x3aece5){if(_0x4fc22b[_0x655f('0x3c')]['OpenchannelAccountId']||_0x4fc22b[_0x655f('0x3c')][_0x655f('0x95')])return;_0xcf1459[_0x655f('0x73')]('i.OpenchannelAccountId\x20IS\x20NOT\x20NULL');_0x14c175[_0x655f('0x73')](_0x655f('0x96'));return;}if(_0x4fc22b[_0x655f('0x97')][_0x655f('0x98')]!==_0x655f('0x99'))return;return _0x4fc22b[_0x655f('0x97')]['getOpenchannelAccounts']({'attributes':['id'],'raw':!![]})[_0x655f('0x28')](function(_0x40935c){if(_[_0x655f('0x92')](_0x40935c)){_0xcf1459[_0x655f('0x73')](_0x655f('0x9a'));_0x14c175[_0x655f('0x73')](_0x655f('0x9a'));}else{_0xcf1459[_0x655f('0x73')](_0x655f('0x74'),_[_0x655f('0x2f')](_0x40935c,'id'));_0x14c175[_0x655f('0x73')]('i.OpenchannelAccountId\x20IN\x20?',_['map'](_0x40935c,'id'));}});})['then'](function(){if(_0x4fc22b[_0x655f('0x97')][_0x655f('0x98')]==='agent'&&!_0x3aece5&&!_0x4fc22b['query'][_0x655f('0x72')])return[];return db[_0x655f('0x9b')][_0x655f('0x3c')](_0xcf1459[_0x655f('0x9c')](),_0x4f7f10);})[_0x655f('0x28')](function(_0x18ee03){_0x2ab879[_0x655f('0x21')]=_0x18ee03[_0x655f('0x41')];if(_0x2ab879[_0x655f('0x21')]===0x0)return[];return db[_0x655f('0x9b')][_0x655f('0x3c')](_0x3b5b99[_0x655f('0x9c')](),_0x4f7f10)['then'](function(_0x1f4937){_0x573108=_[_0x655f('0x9d')](_0x1f4937,'id');_0x4f7f10=_[_0x655f('0x9e')](_0x4f7f10,{'model':db[_0x655f('0x36')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x4fc22b[_0x655f('0x3c')][_0x655f('0x9f')]){_0x3f4c42[_0x655f('0x40')][_0x655f('0x34')](function(_0x3c03c9){_0x14c175[_0x655f('0x46')]('i.'+_0x3c03c9);});}else{_0x14c175[_0x655f('0x46')](_0x655f('0x8e'),'unreadMessages');_0x14c175[_0x655f('0x46')](_0x655f('0xa0'),_0x655f('0xa1'));_0x14c175[_0x655f('0x46')]('a.mandatoryDisposition','Account.mandatoryDisposition');_0x14c175[_0x655f('0x46')](_0x655f('0xa2'),'contactName');_0x14c175[_0x655f('0x46')](_0x655f('0xa3'));_0x14c175[_0x655f('0x46')](_0x655f('0xa4'),_0x655f('0xa5'));_0x14c175[_0x655f('0x46')](_0x655f('0xa6'),_0x655f('0xa7'));_0x14c175[_0x655f('0x46')](_0x655f('0xa8'),_0x655f('0xa9'));_0x14c175[_0x655f('0x46')](_0x655f('0xaa'),_0x655f('0xab'));_0x14c175['field'](_0x655f('0xac'),_0x655f('0xad'));_0x14c175['field'](_0x655f('0xae'),_0x655f('0xaf'));_0x14c175['field'](_0x655f('0xb0'),_0x655f('0xb1'));_0x14c175[_0x655f('0x46')](_0x655f('0xb2'),_0x655f('0xb3'));_0x14c175[_0x655f('0x46')](_0x655f('0xb4'),_0x655f('0x32'));}if(_0x3f4c42[_0x655f('0x23')])_0x14c175[_0x655f('0x23')](_0x3f4c42[_0x655f('0x23')]);if(_0x3f4c42[_0x655f('0x22')])_0x14c175['offset'](_0x3f4c42['offset']);return db[_0x655f('0x9b')][_0x655f('0x3c')](_0x14c175[_0x655f('0x9c')](),_0x4f7f10);})['then'](function(_0x2d2c1e){_0x336766[_0x655f('0x73')](_0x655f('0xb5'),_['map'](_0x2d2c1e,'id'));return db['sequelize'][_0x655f('0x3c')](_0x336766[_0x655f('0x9c')](),_0x4f7f10)[_0x655f('0x28')](function(_0x507b40){var _0x49c99b=_[_0x655f('0xb6')](_0x507b40,_0x655f('0xb7'));var _0x4151f0=[];_0x2d2c1e['forEach'](function(_0x41139f){_0x4151f0['push'](updateOpenchannelInteraction(_0x41139f,_0x573108,_0x49c99b));});return BPromise[_0x655f('0xb8')](_0x4151f0);});});})['then'](function(_0x43ec9f){_0x2ab879[_0x655f('0xb9')]=_0x43ec9f;return _0x2ab879;})[_0x655f('0x28')](respondWithFilteredResult(_0x57e97c,_0x3f4c42))[_0x655f('0x35')](handleError(_0x57e97c,null));};exports[_0x655f('0xba')]=function(_0x23623a,_0x58ecb8){var _0x112122={};if(_0x23623a['query'][_0x655f('0x39')]&&_0x23623a[_0x655f('0x3c')][_0x655f('0x39')]===_0x655f('0x48')){_0x112122[_0x655f('0x48')]=_0x23623a[_0x655f('0xbb')]['id'];}else{_0x112122['id']=_0x23623a[_0x655f('0xbb')]['id'];}var _0x1758b3={'raw':![],'where':_0x112122},_0x3a5110={};_0x3a5110['model']=_['keys'](db[_0x655f('0x36')]['rawAttributes']);_0x3a5110['query']=_['keys'](_0x23623a[_0x655f('0x3c')]);_0x3a5110[_0x655f('0x3e')]=_[_0x655f('0x3f')](_0x3a5110[_0x655f('0x3b')],_0x3a5110['query']);_0x1758b3[_0x655f('0x40')]=_['intersection'](_0x3a5110[_0x655f('0x3b')],qs[_0x655f('0x9f')](_0x23623a['query'][_0x655f('0x9f')]));_0x1758b3['attributes']=_0x1758b3[_0x655f('0x40')][_0x655f('0x41')]?_0x1758b3[_0x655f('0x40')]:_0x3a5110[_0x655f('0x3b')];if(_0x23623a[_0x655f('0x3c')][_0x655f('0xbc')]){_0x1758b3['include']=[{'all':!![]}];}_0x1758b3=_[_0x655f('0x9e')]({},_0x1758b3,_0x23623a['options']);return db[_0x655f('0x36')]['find'](_0x1758b3)['then'](handleEntityNotFound(_0x58ecb8,null))[_0x655f('0x28')](respondWithResult(_0x58ecb8,null))[_0x655f('0x35')](handleError(_0x58ecb8,null));};exports['create']=function(_0x12030d,_0x3a4b76){return db[_0x655f('0x36')]['create'](_0x12030d[_0x655f('0x6f')],{})[_0x655f('0x28')](respondWithResult(_0x3a4b76,0xc9))['catch'](handleError(_0x3a4b76,null));};exports['update']=function(_0xcf7453,_0x16a09f){if(_0xcf7453[_0x655f('0x6f')]['id']){delete _0xcf7453['body']['id'];}return db[_0x655f('0x36')][_0x655f('0x5a')]({'where':{'id':_0xcf7453[_0x655f('0xbb')]['id']}})[_0x655f('0x28')](handleEntityNotFound(_0x16a09f,null))[_0x655f('0x28')](saveUpdates(_0xcf7453[_0x655f('0x6f')],null))[_0x655f('0x28')](respondWithResult(_0x16a09f,null))['catch'](handleError(_0x16a09f,null));};exports[_0x655f('0x29')]=function(_0x1a8527,_0x1d9fcb){return db[_0x655f('0x36')][_0x655f('0x5a')]({'where':{'id':_0x1a8527[_0x655f('0xbb')]['id']}})[_0x655f('0x28')](handleEntityNotFound(_0x1d9fcb,null))[_0x655f('0x28')](removeEntity(_0x1d9fcb,null))['catch'](handleError(_0x1d9fcb,null));};exports['describe']=function(_0x4868ea,_0x51a92b){return db[_0x655f('0x36')][_0x655f('0xbd')]()[_0x655f('0x28')](respondWithResult(_0x51a92b,null))['catch'](handleError(_0x51a92b,null));};exports[_0x655f('0xbe')]=function(_0x157868,_0x6533fb,_0x18560d){return db[_0x655f('0xbf')][_0x655f('0x5a')]({'where':{'id':_0x157868[_0x655f('0xbb')]['id']}})[_0x655f('0x28')](handleEntityNotFound(_0x6533fb,null))[_0x655f('0x28')](function(_0x54d73c){if(_0x54d73c){return _0x54d73c[_0x655f('0xbe')](_0x157868[_0x655f('0x6f')][_0x655f('0xc0')],_[_0x655f('0xc1')](_0x157868[_0x655f('0x6f')],[_0x655f('0xc0'),'id'])||{});}})[_0x655f('0x28')](respondWithResult(_0x6533fb,null))['catch'](handleError(_0x6533fb,null));};exports[_0x655f('0xc2')]=function(_0x5db969,_0x384173,_0x42066a){var _0x122f51={'raw':![],'where':{}};var _0x146e31={};var _0x27fac7={'count':0x0,'rows':[]};return db[_0x655f('0x36')]['findOne']({'where':{'id':_0x5db969[_0x655f('0xbb')]['id']}})[_0x655f('0x28')](handleEntityNotFound(_0x384173,null))['then'](function(_0x23692c){if(_0x23692c){_0x146e31[_0x655f('0x3b')]=_[_0x655f('0x3d')](db['OpenchannelMessage'][_0x655f('0x37')]);_0x146e31[_0x655f('0x3c')]=_[_0x655f('0x3d')](_0x5db969[_0x655f('0x3c')]);_0x146e31[_0x655f('0x3e')]=_[_0x655f('0x3f')](_0x146e31['model'],_0x146e31[_0x655f('0x3c')]);_0x122f51[_0x655f('0x40')]=_[_0x655f('0x3f')](_0x146e31[_0x655f('0x3b')],qs[_0x655f('0x9f')](_0x5db969[_0x655f('0x3c')][_0x655f('0x9f')]));_0x122f51[_0x655f('0x40')]=_0x122f51[_0x655f('0x40')][_0x655f('0x41')]?_0x122f51[_0x655f('0x40')]:_0x146e31[_0x655f('0x3b')];if(!_0x5db969[_0x655f('0x3c')][_0x655f('0x42')](_0x655f('0x43'))){_0x122f51[_0x655f('0x23')]=qs[_0x655f('0x23')](_0x5db969[_0x655f('0x3c')][_0x655f('0x23')]);_0x122f51[_0x655f('0x22')]=qs[_0x655f('0x22')](_0x5db969[_0x655f('0x3c')][_0x655f('0x22')]);}_0x122f51[_0x655f('0x8f')]=qs[_0x655f('0x44')](_0x5db969['query'][_0x655f('0x44')]);_0x122f51[_0x655f('0x73')]=qs[_0x655f('0x3e')](_['pick'](_0x5db969[_0x655f('0x3c')],_0x146e31[_0x655f('0x3e')]));_0x122f51[_0x655f('0x73')][_0x655f('0xb7')]=_0x23692c['id'];if(_0x5db969[_0x655f('0x3c')]['filter']){_0x122f51[_0x655f('0x73')]=_[_0x655f('0x9e')](_0x122f51['where'],{'$or':_[_0x655f('0x2f')](_0x122f51[_0x655f('0x40')],function(_0xc663c1){var _0x4a4ce3={};_0x4a4ce3[_0xc663c1]={'$like':'%'+_0x5db969[_0x655f('0x3c')][_0x655f('0x83')]+'%'};return _0x4a4ce3;})});}if(_0x5db969[_0x655f('0x3c')][_0x655f('0x78')]){var _0x4ceced=_0x5db969[_0x655f('0x3c')][_0x655f('0x78')][_0x655f('0x33')](',');var _0x557bf4={};_0x557bf4[_0x4ceced[0x0]]={'$gte':moment(_0x4ceced[0x1])[_0x655f('0xc3')](_0x655f('0xc4'))};_0x122f51[_0x655f('0x73')]=_[_0x655f('0x9e')](_0x122f51['where'],_0x557bf4);}_0x122f51=_[_0x655f('0x9e')]({},_0x122f51,_0x5db969[_0x655f('0xc5')]);return db[_0x655f('0xbf')][_0x655f('0x21')]({'where':_0x122f51['where']})[_0x655f('0x28')](function(_0xb01427){_0x27fac7[_0x655f('0x21')]=_0xb01427;if(_0x5db969[_0x655f('0x3c')][_0x655f('0xbc')]){_0x122f51[_0x655f('0xc6')]=[{'all':!![]}];}return db[_0x655f('0xbf')][_0x655f('0xc7')](_0x122f51);})[_0x655f('0x28')](function(_0x5a3b7d){_0x27fac7[_0x655f('0xb9')]=_0x5a3b7d;return _0x27fac7;});}})[_0x655f('0x28')](respondWithFilteredResult(_0x384173,_0x122f51))[_0x655f('0x35')](handleError(_0x384173,null));};exports['addTags']=function(_0x81df35,_0x3fe873,_0x34cf51){return db[_0x655f('0x36')][_0x655f('0x5a')]({'where':{'id':_0x81df35[_0x655f('0xbb')]['id']}})[_0x655f('0x28')](handleEntityNotFound(_0x3fe873,null))[_0x655f('0x28')](function(_0x410470){if(_0x410470){return _0x410470['setTags'](_0x81df35[_0x655f('0x6f')]['ids'],_[_0x655f('0xc1')](_0x81df35['body'],['ids','id'])||{})['spread'](function(){return db['Tag'][_0x655f('0xc7')]({'attributes':['id',_0x655f('0x2c'),_0x655f('0x47')],'where':{'id':_0x81df35['body'][_0x655f('0xc0')]}});})['then'](function(_0x26b863){socket[_0x655f('0xc8')](_0x655f('0xc9'),{'id':Number(_0x81df35['params']['id']),'tags':_0x26b863||[]});return{'id':Number(_0x81df35[_0x655f('0xbb')]['id']),'tags':_0x26b863||[]};});}})['then'](respondWithResult(_0x3fe873,null))['catch'](handleError(_0x3fe873,null));};exports[_0x655f('0xca')]=function(_0x5de090,_0x3f82cc,_0x59b8a6){return db[_0x655f('0x36')][_0x655f('0x5a')]({'where':{'id':_0x5de090['params']['id']}})[_0x655f('0x28')](handleEntityNotFound(_0x3f82cc,null))['then'](function(_0x3ff61e){if(_0x3ff61e){return _0x3ff61e[_0x655f('0xca')](_0x5de090[_0x655f('0x3c')][_0x655f('0xc0')]);}})[_0x655f('0x28')](respondWithStatusCode(_0x3f82cc,null))[_0x655f('0x35')](handleError(_0x3f82cc,null));};exports['download']=function(_0x67a605,_0x2bea7d){var _0x48221f=moment()[_0x655f('0xcb')]()[_0x655f('0x9c')]();var _0x27a7ce=path[_0x655f('0xcc')](config[_0x655f('0xcd')],_0x655f('0xce'),_0x655f('0xcf'),_0x655f('0xd0'));var _0x56379f=path[_0x655f('0xcc')](config[_0x655f('0xcd')],_0x655f('0xce'),_0x655f('0xcf'),'attachments');var _0x425219=path['join'](_0x27a7ce,_0x48221f);var _0x375466=util[_0x655f('0xc3')](_0x655f('0xd1'),_0x67a605['params']['id'],_0x48221f);var _0x52e584=path[_0x655f('0xcc')](_0x27a7ce,_0x375466);var _0x26296f=[];_0x26296f[_0x655f('0xd2')]({'model':db[_0x655f('0x6c')],'as':_0x655f('0x6c'),'attributes':['id',_0x655f('0x30')],'raw':!![]});_0x26296f[_0x655f('0xd2')]({'model':db[_0x655f('0xd3')],'as':_0x655f('0x5f'),'attributes':['id',_0x655f('0xd4'),_0x655f('0xd5')],'raw':!![]});if(_0x67a605['query']['attachments']){_0x26296f['push']({'model':db['Attachment'],'as':_0x655f('0xd6'),'raw':!![]});}var _0x585728=[{'model':db[_0x655f('0xbf')],'as':_0x655f('0xd7'),'attributes':['id','body',_0x655f('0x76'),'direction',_0x655f('0xd8'),'read'],'include':_0x26296f}];_0x585728[_0x655f('0xd2')]({'model':db[_0x655f('0xd9')],'as':_0x655f('0xda'),'attributes':['id',_0x655f('0x2c')]});_0x585728[_0x655f('0xd2')]({'model':db[_0x655f('0x6c')],'as':'Owner','attributes':['id',_0x655f('0x30')]});return db[_0x655f('0x36')][_0x655f('0x5a')]({'where':{'id':_0x67a605[_0x655f('0xbb')]['id']},'include':_0x585728})['then'](handleEntityNotFound(_0x2bea7d,null))[_0x655f('0x28')](function(_0x6cebb8){if(_0x6cebb8){var _0xe118c1=_0x6cebb8['get']({'plain':!![]});fs['mkdirSync'](_0x425219);var _0x46f87e={'format':'A4','border':_0x655f('0xdb'),'header':{'height':'40px','contents':{'first':_0x655f('0xdc')}},'footer':{'height':_0x655f('0xdd'),'contents':{'default':util[_0x655f('0xc3')](_0x655f('0xde'),util[_0x655f('0xc3')](_0x655f('0xdf'),_0x655f('0xe0'),_0xe118c1['id']),moment()[_0x655f('0xc3')](_0x655f('0xe1'))[_0x655f('0x9c')]())}}};var _0x4bf280={'channel':'Openchannel','account':_0xe118c1['Account'][_0x655f('0x2c')],'agent':_0xe118c1['Owner']?_0xe118c1[_0x655f('0xe2')][_0x655f('0x30')]:_0x655f('0xe3'),'createdAt':moment(_0xe118c1[_0x655f('0x76')])['format'](_0x655f('0xc4'))[_0x655f('0x9c')](),'closedAt':_0xe118c1['closed']?moment(_0xe118c1['closedAt'])['format'](_0x655f('0xc4'))[_0x655f('0x9c')]():'','disposition':_0xe118c1['disposition'],'visibility':_0xe118c1['threadId']?_0x655f('0xe4'):_0x655f('0xe5'),'messages':_(_0xe118c1[_0x655f('0xd7')])['filter']({'secret':![]})[_0x655f('0x2f')](function(_0x38a5cf){if(_0x38a5cf['Attachment']){var _0xfff834=path['join'](_0x56379f,_0x38a5cf['Attachment'][_0x655f('0xe6')]);if(fs[_0x655f('0xe7')](_0xfff834)){fs[_0x655f('0xe8')](_0xfff834)['pipe'](fs[_0x655f('0xe9')](path[_0x655f('0xcc')](_0x425219,_0x38a5cf[_0x655f('0xd6')][_0x655f('0xe6')])));}}return{'date':moment(_0x38a5cf[_0x655f('0x76')])['format'](_0x655f('0xc4'))['toString'](),'sender':_0x38a5cf['direction']===_0x655f('0xea')?_0x38a5cf[_0x655f('0x6c')]?_0x38a5cf['User'][_0x655f('0x30')]:_0x655f('0xeb'):_0x38a5cf[_0x655f('0x5f')]['firstName']+(_0x38a5cf[_0x655f('0x5f')][_0x655f('0xd5')]?'\x20'+_0x38a5cf[_0x655f('0x5f')][_0x655f('0xd5')]:''),'body':_0x38a5cf[_0x655f('0xd6')]?_0x38a5cf['Attachment'][_0x655f('0xe6')]:_0x38a5cf[_0x655f('0x6f')],'direction':_0x38a5cf[_0x655f('0xec')]===_0x655f('0xea')?'A':'C','secret':_0x38a5cf[_0x655f('0xd8')],'read':_0x38a5cf[_0x655f('0x7d')],'attachment':_0x38a5cf[_0x655f('0xd6')]};})['value']()};return ejs[_0x655f('0xed')](path[_0x655f('0xcc')](config['root'],_0x655f('0xce'),_0x655f('0xee'),'downloadInteraction.html'),{'interaction':_0x4bf280})[_0x655f('0x28')](function(_0x55b393){return new BPromise(function(_0x5a983d,_0x20c099){pdf[_0x655f('0xef')](_0x55b393,_0x46f87e)[_0x655f('0xf0')](path[_0x655f('0xcc')](_0x425219,'transcript-'+_0xe118c1['id']+'-'+_0x48221f+'.pdf'),function(_0x4dbaf3,_0x1aa720){if(_0x4dbaf3)return _0x20c099(_0x4dbaf3);_0x5a983d(_0x1aa720);});});})[_0x655f('0x28')](function(){return new BPromise(function(_0x3d0c8b,_0x373e52){zipdir(_0x425219,{'saveTo':_0x52e584},function(_0x18a7f6,_0x33016e){if(_0x18a7f6)return _0x373e52(_0x18a7f6);return _0x3d0c8b(_0x33016e);});})[_0x655f('0x28')](function(){return new BPromise(function(_0xe6ec3e,_0xe730a0){rimraf(_0x425219,function(_0x176c92){if(_0x176c92)_0xe730a0(_0x176c92);return _0xe6ec3e();});});})[_0x655f('0x28')](function(){return _0x2bea7d['download'](_0x52e584,_0x375466,function(_0x410151){if(_0x410151){console[_0x655f('0xf1')](_0x655f('0xf2'),_0x410151);}else{fs[_0x655f('0xf3')](_0x52e584);}});});});}else{return _0x2bea7d[_0x655f('0x1e')](0xc8);}})[_0x655f('0x35')](handleError(_0x2bea7d,null));};