Built motion from commit (unavailable).|2.5.11
[motion2.git] / server / api / voiceQueue / voiceQueue.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 _0x0d86=['removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','eml-format','rimraf','zip-dir','request-promise','moment','mustache','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/license/util','../../mysqldb','redis','localhost','socket.io-emitter','./voiceQueue.socket','sendStatus','status','end','count','offset','limit','set','Content-Range','apply','reject','update','destroy','then','VoiceQueues','inbound','QueueCampaigns','filter','ignore','value','includes','type','name','UserProfileResource','error','stack','send','index','VoiceQueue','fieldName','key','model','map','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','VIRTUAL','options','includeAll','include','rows','show','params','rawAttributes','merge','find','catch','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','createdAt','updatedAt','body','outbound','autoAssociation','getHoppers','findOne','CmHopper','VoiceQueueId','findAll','getHopperHistories','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','teams','User','Agents','online','interface','flatMap','forEach','penalty','sequelize','transaction','each','findOrCreate','UserVoiceQueueRt','upsert','isNil','format','SIP/%s','emit','userVoiceQueue:save','removeTeams','ids','field','tq.TeamId','from','team_has_voice_queues','join','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','QueryTypes','SELECT','TeamId','all','union','compact','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','voicePause','isArray','getAgents','getMembers','CmList','getLists','dialCheckDuplicateType','always','insert','cm_hopper','fromQuery','ContactId','ListId','select','phone','scheduledAt','CmListId','toString','NOW()','cm_contacts','phone\x20IS\x20NOT\x20NULL','COALESCE(calleridnum,\x27\x27)','phone\x20NOT\x20IN\x20(?)','onlyIfOpen','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','COALESCE(phone,\x27\x27)','into'];(function(_0x1eab75,_0x2d0dd4){var _0x5a48c8=function(_0x7d9cc0){while(--_0x7d9cc0){_0x1eab75['push'](_0x1eab75['shift']());}};_0x5a48c8(++_0x2d0dd4);}(_0x0d86,0x17b));var _0x60d8=function(_0x10c89e,_0x457e5e){_0x10c89e=_0x10c89e-0x0;var _0xe328a1=_0x0d86[_0x10c89e];return _0xe328a1;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x60d8('0x0'));var rimraf=require(_0x60d8('0x1'));var zipdir=require(_0x60d8('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x60d8('0x3'));var moment=require(_0x60d8('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x60d8('0x5'));var util=require('util');var path=require(_0x60d8('0x6'));var sox=require(_0x60d8('0x7'));var csv=require(_0x60d8('0x8'));var ejs=require(_0x60d8('0x9'));var fs=require('fs');var _=require(_0x60d8('0xa'));var squel=require(_0x60d8('0xb'));var crypto=require('crypto');var jsforce=require(_0x60d8('0xc'));var deskjs=require(_0x60d8('0xd'));var toCsv=require('to-csv');var querystring=require(_0x60d8('0xe'));var Papa=require(_0x60d8('0xf'));var Redis=require(_0x60d8('0x10'));var authService=require(_0x60d8('0x11'));var qs=require(_0x60d8('0x12'));var as=require(_0x60d8('0x13'));var hardwareService=require(_0x60d8('0x14'));var logger=require(_0x60d8('0x15'))('api');var utils=require(_0x60d8('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0x60d8('0x17'));var db=require(_0x60d8('0x18'))['db'];config[_0x60d8('0x19')]=_['defaults'](config[_0x60d8('0x19')],{'host':_0x60d8('0x1a'),'port':0x18eb});var socket=require(_0x60d8('0x1b'))(new Redis(config[_0x60d8('0x19')]));require(_0x60d8('0x1c'))['register'](socket);function respondWithStatusCode(_0x448cde,_0x36a6d2){_0x36a6d2=_0x36a6d2||0xcc;return function(_0x5bba00){if(_0x5bba00){return _0x448cde[_0x60d8('0x1d')](_0x36a6d2);}return _0x448cde[_0x60d8('0x1e')](_0x36a6d2)[_0x60d8('0x1f')]();};}function respondWithResult(_0x5e8284,_0x5ad237){_0x5ad237=_0x5ad237||0xc8;return function(_0x2c5193){if(_0x2c5193){return _0x5e8284[_0x60d8('0x1e')](_0x5ad237)['json'](_0x2c5193);}};}function respondWithFilteredResult(_0x4618f8,_0x44fef4){return function(_0x469158){if(_0x469158){var _0x159694=_0x469158[_0x60d8('0x20')],_0x51ca23=_0x44fef4[_0x60d8('0x21')],_0x3eea5f=_0x44fef4[_0x60d8('0x21')]+_0x44fef4[_0x60d8('0x22')],_0x288ff9;if(_0x3eea5f>=_0x159694){_0x3eea5f=_0x159694;_0x288ff9=0xc8;}else{_0x288ff9=0xce;}_0x4618f8[_0x60d8('0x1e')](_0x288ff9);return _0x4618f8[_0x60d8('0x23')](_0x60d8('0x24'),_0x51ca23+'-'+_0x3eea5f+'/'+_0x159694)['json'](_0x469158);}return null;};}function patchUpdates(_0x579b60){return function(_0x5870b4){try{jsonpatch[_0x60d8('0x25')](_0x5870b4,_0x579b60,!![]);}catch(_0x17beee){return BPromise[_0x60d8('0x26')](_0x17beee);}return _0x5870b4['save']();};}function saveUpdates(_0xdc3d4f,_0x36cb66){return function(_0x579730){if(_0x579730){return _0x579730[_0x60d8('0x27')](_0xdc3d4f)['then'](function(_0x22cb17){return _0x22cb17;});}return null;};}function removeEntity(_0x19972a,_0xe13102){return function(_0x387d65){if(_0x387d65){return _0x387d65[_0x60d8('0x28')]()[_0x60d8('0x29')](function(){var _0x5cca40=_0x387d65['get']({'plain':!![]});var _0x503050=[{'name':_0x60d8('0x2a'),'value':_0x60d8('0x2b'),'ignore':![]},{'name':_0x60d8('0x2c'),'value':'outbound','ignore':![]}];var _0x55904b=_(_0x503050)[_0x60d8('0x2d')](_0x60d8('0x2e'))['map'](_0x60d8('0x2f'))[_0x60d8('0x2f')]();if(_[_0x60d8('0x30')](_0x55904b,_0x5cca40['type'])){return;}var _0x3f8fc1=_['find'](_0x503050,[_0x60d8('0x2f'),_0x5cca40[_0x60d8('0x31')]])[_0x60d8('0x32')];return db[_0x60d8('0x33')][_0x60d8('0x28')]({'where':{'type':_0x3f8fc1,'resourceId':_0x5cca40['id']}})[_0x60d8('0x29')](function(){return _0x387d65;});})[_0x60d8('0x29')](function(){_0x19972a[_0x60d8('0x1e')](0xcc)[_0x60d8('0x1f')]();});}};}function handleEntityNotFound(_0x4300a9,_0x2a9121){return function(_0x59c8cf){if(!_0x59c8cf){_0x4300a9[_0x60d8('0x1d')](0x194);}return _0x59c8cf;};}function handleError(_0x77e020,_0x47943e){_0x47943e=_0x47943e||0x1f4;return function(_0x463dec){logger[_0x60d8('0x34')](_0x463dec[_0x60d8('0x35')]);if(_0x463dec['name']){delete _0x463dec[_0x60d8('0x32')];}_0x77e020['status'](_0x47943e)[_0x60d8('0x36')](_0x463dec);};}exports[_0x60d8('0x37')]=function(_0x35da64,_0x54031e){var _0x31c46e={},_0x54f70c={},_0x392b28={'count':0x0,'rows':[]};var _0x1b2953=_['map'](db[_0x60d8('0x38')]['rawAttributes'],function(_0x4664c5){return{'name':_0x4664c5[_0x60d8('0x39')],'type':_0x4664c5[_0x60d8('0x31')][_0x60d8('0x3a')]};});_0x54f70c[_0x60d8('0x3b')]=_[_0x60d8('0x3c')](_0x1b2953,_0x60d8('0x32'));_0x54f70c[_0x60d8('0x3d')]=_[_0x60d8('0x3e')](_0x35da64[_0x60d8('0x3d')]);_0x54f70c[_0x60d8('0x3f')]=_[_0x60d8('0x40')](_0x54f70c[_0x60d8('0x3b')],_0x54f70c[_0x60d8('0x3d')]);_0x31c46e[_0x60d8('0x41')]=_[_0x60d8('0x40')](_0x54f70c['model'],qs[_0x60d8('0x42')](_0x35da64[_0x60d8('0x3d')]['fields']));_0x31c46e[_0x60d8('0x41')]=_0x31c46e[_0x60d8('0x41')][_0x60d8('0x43')]?_0x31c46e[_0x60d8('0x41')]:_0x54f70c[_0x60d8('0x3b')];if(!_0x35da64[_0x60d8('0x3d')][_0x60d8('0x44')](_0x60d8('0x45'))){_0x31c46e[_0x60d8('0x22')]=qs['limit'](_0x35da64[_0x60d8('0x3d')][_0x60d8('0x22')]);_0x31c46e[_0x60d8('0x21')]=qs['offset'](_0x35da64['query'][_0x60d8('0x21')]);}_0x31c46e[_0x60d8('0x46')]=qs[_0x60d8('0x47')](_0x35da64[_0x60d8('0x3d')][_0x60d8('0x47')]);_0x31c46e[_0x60d8('0x48')]=qs[_0x60d8('0x3f')](_[_0x60d8('0x49')](_0x35da64[_0x60d8('0x3d')],_0x54f70c[_0x60d8('0x3f')]),_0x1b2953);if(_0x35da64[_0x60d8('0x3d')][_0x60d8('0x2d')]){_0x31c46e[_0x60d8('0x48')]=_['merge'](_0x31c46e[_0x60d8('0x48')],{'$or':_['map'](_0x1b2953,function(_0x367a9b){if(_0x367a9b['type']!==_0x60d8('0x4a')){var _0x348df6={};_0x348df6[_0x367a9b[_0x60d8('0x32')]]={'$like':'%'+_0x35da64[_0x60d8('0x3d')][_0x60d8('0x2d')]+'%'};return _0x348df6;}})});}_0x31c46e=_['merge']({},_0x31c46e,_0x35da64[_0x60d8('0x4b')]);var _0x29b801={'where':_0x31c46e[_0x60d8('0x48')]};return db[_0x60d8('0x38')]['count'](_0x29b801)[_0x60d8('0x29')](function(_0x216039){_0x392b28[_0x60d8('0x20')]=_0x216039;if(_0x35da64[_0x60d8('0x3d')][_0x60d8('0x4c')]){_0x31c46e[_0x60d8('0x4d')]=[{'all':!![]}];}return db['VoiceQueue']['findAll'](_0x31c46e);})['then'](function(_0x2a56cb){_0x392b28[_0x60d8('0x4e')]=_0x2a56cb;return _0x392b28;})['then'](respondWithFilteredResult(_0x54031e,_0x31c46e))['catch'](handleError(_0x54031e,null));};exports[_0x60d8('0x4f')]=function(_0x18fdb4,_0x5bb6aa){var _0x1861ae={'raw':![],'where':{'id':_0x18fdb4[_0x60d8('0x50')]['id']}},_0x1552c6={};_0x1552c6['model']=_[_0x60d8('0x3e')](db[_0x60d8('0x38')][_0x60d8('0x51')]);_0x1552c6[_0x60d8('0x3d')]=_['keys'](_0x18fdb4[_0x60d8('0x3d')]);_0x1552c6[_0x60d8('0x3f')]=_[_0x60d8('0x40')](_0x1552c6['model'],_0x1552c6['query']);_0x1861ae[_0x60d8('0x41')]=_[_0x60d8('0x40')](_0x1552c6[_0x60d8('0x3b')],qs[_0x60d8('0x42')](_0x18fdb4[_0x60d8('0x3d')]['fields']));_0x1861ae[_0x60d8('0x41')]=_0x1861ae[_0x60d8('0x41')][_0x60d8('0x43')]?_0x1861ae[_0x60d8('0x41')]:_0x1552c6[_0x60d8('0x3b')];if(_0x18fdb4['query'][_0x60d8('0x4c')]){_0x1861ae['include']=[{'all':!![]}];}_0x1861ae=_[_0x60d8('0x52')]({},_0x1861ae,_0x18fdb4['options']);return db[_0x60d8('0x38')][_0x60d8('0x53')](_0x1861ae)[_0x60d8('0x29')](handleEntityNotFound(_0x5bb6aa,null))[_0x60d8('0x29')](respondWithResult(_0x5bb6aa,null))[_0x60d8('0x54')](handleError(_0x5bb6aa,null));};exports['create']=function(_0x16d50a,_0x41c580){return db[_0x60d8('0x38')][_0x60d8('0x55')](_0x16d50a['body'],{})[_0x60d8('0x29')](function(_0x246b16){var _0x11f9d1=_0x16d50a[_0x60d8('0x56')]['get']({'plain':!![]});if(!_0x11f9d1)throw new Error(_0x60d8('0x57'));if(_0x11f9d1[_0x60d8('0x58')]===_0x60d8('0x56')){var _0xf08b0a=_0x246b16[_0x60d8('0x59')]({'plain':!![]});var _0x476a39=[{'name':'VoiceQueues','value':'inbound'},{'name':_0x60d8('0x2c'),'value':'outbound'}];var _0xfe1bc=_['find'](_0x476a39,[_0x60d8('0x2f'),_0xf08b0a[_0x60d8('0x31')]])['name'];return db[_0x60d8('0x5a')][_0x60d8('0x53')]({'where':{'name':_0xfe1bc,'userProfileId':_0x11f9d1[_0x60d8('0x5b')]},'raw':!![]})[_0x60d8('0x29')](function(_0x4e923a){if(_0x4e923a&&_0x4e923a['autoAssociation']===0x0){return db[_0x60d8('0x33')][_0x60d8('0x55')]({'name':_0xf08b0a['name'],'resourceId':_0xf08b0a['id'],'type':_0x4e923a[_0x60d8('0x32')],'sectionId':_0x4e923a['id']},{})[_0x60d8('0x29')](function(){return _0x246b16;});}else{return _0x246b16;}})[_0x60d8('0x54')](function(_0x5795b3){logger['error'](_0x60d8('0x5c'),_0x5795b3);throw _0x5795b3;});}return _0x246b16;})[_0x60d8('0x29')](respondWithResult(_0x41c580,0xc9))[_0x60d8('0x54')](handleError(_0x41c580,null));};exports['clone']=function(_0xc26109,_0x4f1567){var _0x3b51e2={'where':{'id':_0xc26109[_0x60d8('0x50')]['id']}},_0x167e2e={};_0x167e2e['model']=_[_0x60d8('0x3e')](db[_0x60d8('0x38')][_0x60d8('0x51')]);_0x3b51e2[_0x60d8('0x41')]=_[_0x60d8('0x40')](_0x167e2e[_0x60d8('0x3b')],qs[_0x60d8('0x42')](_0xc26109[_0x60d8('0x3d')][_0x60d8('0x42')]));_0x3b51e2[_0x60d8('0x41')]=_0x3b51e2[_0x60d8('0x41')][_0x60d8('0x43')]?_0x3b51e2['attributes']:_0x167e2e['model'];if(_0xc26109[_0x60d8('0x3d')][_0x60d8('0x4c')]){_0x3b51e2[_0x60d8('0x4d')]=[{'all':!![]}];}_0x3b51e2=_['merge']({},_0x3b51e2,_0xc26109['options']);return db[_0x60d8('0x38')]['find'](_0x3b51e2)[_0x60d8('0x29')](handleEntityNotFound(_0x4f1567,null))[_0x60d8('0x29')](function(_0x22a5eb){if(_0x22a5eb){var _0x23b5a4=_0x22a5eb[_0x60d8('0x59')]({'plain':!![]});_0x23b5a4=qs[_0x60d8('0x5d')](_0x23b5a4,['id',_0x60d8('0x5e'),_0x60d8('0x5f')]);_0xc26109[_0x60d8('0x60')]=_[_0x60d8('0x5d')](_0xc26109[_0x60d8('0x60')],['id','createdAt','updatedAt']);return db['VoiceQueue'][_0x60d8('0x55')](_[_0x60d8('0x52')](_0x23b5a4,_0xc26109[_0x60d8('0x60')]),{'include':_0xc26109[_0x60d8('0x3d')][_0x60d8('0x4c')]?[{'all':!![]}]:undefined})[_0x60d8('0x29')](function(_0x5a3bf0){var _0x10be8e=_0xc26109[_0x60d8('0x56')]['get']({'plain':!![]});if(!_0x10be8e)throw new Error(_0x60d8('0x57'));if(_0x10be8e[_0x60d8('0x58')]===_0x60d8('0x56')){var _0x359664=_0x5a3bf0[_0x60d8('0x59')]({'plain':!![]});var _0xcd5063=[{'name':_0x60d8('0x2a'),'value':_0x60d8('0x2b')},{'name':_0x60d8('0x2c'),'value':_0x60d8('0x61')}];var _0x3b0098=_[_0x60d8('0x53')](_0xcd5063,[_0x60d8('0x2f'),_0x359664[_0x60d8('0x31')]])[_0x60d8('0x32')];return db[_0x60d8('0x5a')][_0x60d8('0x53')]({'where':{'name':_0x3b0098,'userProfileId':_0x10be8e['userProfileId']},'raw':!![]})['then'](function(_0x49a766){if(_0x49a766&&_0x49a766[_0x60d8('0x62')]===0x0){return db[_0x60d8('0x33')][_0x60d8('0x55')]({'name':_0x359664['name'],'resourceId':_0x359664['id'],'type':_0x49a766[_0x60d8('0x32')],'sectionId':_0x49a766['id']},{})[_0x60d8('0x29')](function(){return _0x5a3bf0;});}else{return _0x5a3bf0;}})['catch'](function(_0x316a70){logger['error'](_0x60d8('0x5c'),_0x316a70);throw _0x316a70;});}return _0x5a3bf0;});}})['then'](respondWithResult(_0x4f1567,0xc9))[_0x60d8('0x54')](handleError(_0x4f1567,null));};exports[_0x60d8('0x27')]=function(_0xab5847,_0x49e582){if(_0xab5847[_0x60d8('0x60')]['id']){delete _0xab5847['body']['id'];}return db['VoiceQueue'][_0x60d8('0x53')]({'where':{'id':_0xab5847[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x49e582,null))[_0x60d8('0x29')](saveUpdates(_0xab5847['body'],null))[_0x60d8('0x29')](respondWithResult(_0x49e582,null))[_0x60d8('0x54')](handleError(_0x49e582,null));};exports['destroy']=function(_0x46dd28,_0x3f19e5){return db['VoiceQueue']['find']({'where':{'id':_0x46dd28[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x3f19e5,null))[_0x60d8('0x29')](removeEntity(_0x3f19e5,null))[_0x60d8('0x54')](handleError(_0x3f19e5,null));};exports[_0x60d8('0x63')]=function(_0x8439ff,_0x57b8ae,_0x36c690){var _0x233995={'raw':![],'where':{}};var _0x4230ac={};var _0x1aa6ac={'count':0x0,'rows':[]};return db[_0x60d8('0x38')][_0x60d8('0x64')]({'where':{'id':_0x8439ff['params']['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x57b8ae,null))[_0x60d8('0x29')](function(_0x406202){if(_0x406202){_0x4230ac[_0x60d8('0x3b')]=_[_0x60d8('0x3e')](db[_0x60d8('0x65')][_0x60d8('0x51')]);_0x4230ac[_0x60d8('0x3d')]=_[_0x60d8('0x3e')](_0x8439ff[_0x60d8('0x3d')]);_0x4230ac[_0x60d8('0x3f')]=_['intersection'](_0x4230ac[_0x60d8('0x3b')],_0x4230ac[_0x60d8('0x3d')]);_0x233995[_0x60d8('0x41')]=_['intersection'](_0x4230ac[_0x60d8('0x3b')],qs[_0x60d8('0x42')](_0x8439ff[_0x60d8('0x3d')][_0x60d8('0x42')]));_0x233995[_0x60d8('0x41')]=_0x233995[_0x60d8('0x41')][_0x60d8('0x43')]?_0x233995[_0x60d8('0x41')]:_0x4230ac[_0x60d8('0x3b')];if(!_0x8439ff[_0x60d8('0x3d')][_0x60d8('0x44')](_0x60d8('0x45'))){_0x233995[_0x60d8('0x22')]=qs[_0x60d8('0x22')](_0x8439ff[_0x60d8('0x3d')][_0x60d8('0x22')]);_0x233995[_0x60d8('0x21')]=qs['offset'](_0x8439ff[_0x60d8('0x3d')]['offset']);}_0x233995[_0x60d8('0x46')]=qs[_0x60d8('0x47')](_0x8439ff[_0x60d8('0x3d')]['sort']);_0x233995[_0x60d8('0x48')]=qs[_0x60d8('0x3f')](_[_0x60d8('0x49')](_0x8439ff['query'],_0x4230ac[_0x60d8('0x3f')]));_0x233995[_0x60d8('0x48')][_0x60d8('0x66')]=_0x406202['id'];if(_0x8439ff['query']['filter']){_0x233995[_0x60d8('0x48')]=_[_0x60d8('0x52')](_0x233995[_0x60d8('0x48')],{'$or':_[_0x60d8('0x3c')](_0x233995[_0x60d8('0x41')],function(_0x46da1f){var _0x131ced={};_0x131ced[_0x46da1f]={'$like':'%'+_0x8439ff[_0x60d8('0x3d')]['filter']+'%'};return _0x131ced;})});}_0x233995=_['merge']({},_0x233995,_0x8439ff['options']);return db[_0x60d8('0x65')][_0x60d8('0x20')]({'where':_0x233995['where']})[_0x60d8('0x29')](function(_0x53d873){_0x1aa6ac[_0x60d8('0x20')]=_0x53d873;if(_0x8439ff[_0x60d8('0x3d')]['includeAll']){_0x233995[_0x60d8('0x4d')]=[{'all':!![]}];}return db['CmHopper'][_0x60d8('0x67')](_0x233995);})[_0x60d8('0x29')](function(_0x231e97){_0x1aa6ac[_0x60d8('0x4e')]=_0x231e97;return _0x1aa6ac;});}})['then'](respondWithFilteredResult(_0x57b8ae,_0x233995))[_0x60d8('0x54')](handleError(_0x57b8ae,null));};exports[_0x60d8('0x68')]=function(_0x18dc5a,_0x4eaa10,_0x4e1b53){var _0x4709f1={'raw':!![],'where':{}};var _0x534e43={};var _0x42894f={'count':0x0,'rows':[]};return db[_0x60d8('0x38')][_0x60d8('0x64')]({'where':{'id':_0x18dc5a[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x4eaa10,null))[_0x60d8('0x29')](function(_0xf064b2){if(_0xf064b2){_0x534e43[_0x60d8('0x3b')]=_['keys'](db[_0x60d8('0x69')][_0x60d8('0x51')]);_0x534e43[_0x60d8('0x3d')]=_[_0x60d8('0x3e')](_0x18dc5a[_0x60d8('0x3d')]);_0x534e43[_0x60d8('0x3f')]=_[_0x60d8('0x40')](_0x534e43[_0x60d8('0x3b')],_0x534e43['query']);_0x4709f1[_0x60d8('0x41')]=_[_0x60d8('0x40')](_0x534e43['model'],qs['fields'](_0x18dc5a[_0x60d8('0x3d')][_0x60d8('0x42')]));_0x4709f1[_0x60d8('0x41')]=_0x4709f1[_0x60d8('0x41')][_0x60d8('0x43')]?_0x4709f1[_0x60d8('0x41')]:_0x534e43[_0x60d8('0x3b')];if(!_0x18dc5a['query'][_0x60d8('0x44')](_0x60d8('0x45'))){_0x4709f1[_0x60d8('0x22')]=qs[_0x60d8('0x22')](_0x18dc5a[_0x60d8('0x3d')][_0x60d8('0x22')]);_0x4709f1[_0x60d8('0x21')]=qs[_0x60d8('0x21')](_0x18dc5a[_0x60d8('0x3d')]['offset']);}_0x4709f1[_0x60d8('0x46')]=qs[_0x60d8('0x47')](_0x18dc5a[_0x60d8('0x3d')][_0x60d8('0x47')]);_0x4709f1[_0x60d8('0x48')]=qs['filters'](_[_0x60d8('0x49')](_0x18dc5a[_0x60d8('0x3d')],_0x534e43[_0x60d8('0x3f')]));_0x4709f1[_0x60d8('0x48')][_0x60d8('0x66')]=_0xf064b2['id'];if(_0x18dc5a[_0x60d8('0x3d')][_0x60d8('0x2d')]){_0x4709f1['where']=_['merge'](_0x4709f1[_0x60d8('0x48')],{'$or':_[_0x60d8('0x3c')](_0x4709f1[_0x60d8('0x41')],function(_0x33b518){var _0x81671c={};_0x81671c[_0x33b518]={'$like':'%'+_0x18dc5a['query'][_0x60d8('0x2d')]+'%'};return _0x81671c;})});}_0x4709f1=_[_0x60d8('0x52')]({},_0x4709f1,_0x18dc5a[_0x60d8('0x4b')]);return db['CmHopperHistory'][_0x60d8('0x20')]({'where':_0x4709f1['where']})['then'](function(_0x2fbf82){_0x42894f[_0x60d8('0x20')]=_0x2fbf82;if(_0x18dc5a['query'][_0x60d8('0x4c')]){_0x4709f1[_0x60d8('0x4d')]=[{'all':!![]}];}return db[_0x60d8('0x69')][_0x60d8('0x67')](_0x4709f1);})[_0x60d8('0x29')](function(_0x469060){_0x42894f[_0x60d8('0x4e')]=_0x469060;return _0x42894f;});}})['then'](respondWithFilteredResult(_0x4eaa10,_0x4709f1))[_0x60d8('0x54')](handleError(_0x4eaa10,null));};exports[_0x60d8('0x6a')]=function(_0x12518c,_0x32d604,_0x4eef42){var _0x1c5455={'raw':!![],'where':{}};var _0x3b5ad0={};var _0x558633={'count':0x0,'rows':[]};return db[_0x60d8('0x38')][_0x60d8('0x64')]({'where':{'id':_0x12518c['params']['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x32d604,null))[_0x60d8('0x29')](function(_0x3eccfd){if(_0x3eccfd){_0x3b5ad0['model']=_[_0x60d8('0x3e')](db[_0x60d8('0x6b')][_0x60d8('0x51')]);_0x3b5ad0[_0x60d8('0x3d')]=_['keys'](_0x12518c[_0x60d8('0x3d')]);_0x3b5ad0['filters']=_['intersection'](_0x3b5ad0[_0x60d8('0x3b')],_0x3b5ad0['query']);_0x1c5455[_0x60d8('0x41')]=_[_0x60d8('0x40')](_0x3b5ad0[_0x60d8('0x3b')],qs[_0x60d8('0x42')](_0x12518c[_0x60d8('0x3d')][_0x60d8('0x42')]));_0x1c5455[_0x60d8('0x41')]=_0x1c5455[_0x60d8('0x41')]['length']?_0x1c5455['attributes']:_0x3b5ad0[_0x60d8('0x3b')];if(!_0x12518c['query']['hasOwnProperty'](_0x60d8('0x45'))){_0x1c5455['limit']=qs[_0x60d8('0x22')](_0x12518c[_0x60d8('0x3d')][_0x60d8('0x22')]);_0x1c5455[_0x60d8('0x21')]=qs[_0x60d8('0x21')](_0x12518c[_0x60d8('0x3d')][_0x60d8('0x21')]);}_0x1c5455[_0x60d8('0x46')]=qs[_0x60d8('0x47')](_0x12518c[_0x60d8('0x3d')][_0x60d8('0x47')]);_0x1c5455[_0x60d8('0x48')]=qs[_0x60d8('0x3f')](_['pick'](_0x12518c[_0x60d8('0x3d')],_0x3b5ad0[_0x60d8('0x3f')]));_0x1c5455[_0x60d8('0x48')][_0x60d8('0x66')]=_0x3eccfd['id'];if(_0x12518c['query'][_0x60d8('0x2d')]){_0x1c5455['where']=_[_0x60d8('0x52')](_0x1c5455[_0x60d8('0x48')],{'$or':_['map'](_0x1c5455[_0x60d8('0x41')],function(_0x3c94dd){var _0x500907={};_0x500907[_0x3c94dd]={'$like':'%'+_0x12518c['query']['filter']+'%'};return _0x500907;})});}_0x1c5455=_[_0x60d8('0x52')]({},_0x1c5455,_0x12518c[_0x60d8('0x4b')]);return db[_0x60d8('0x6b')][_0x60d8('0x20')]({'where':_0x1c5455[_0x60d8('0x48')]})['then'](function(_0x38e4d5){_0x558633[_0x60d8('0x20')]=_0x38e4d5;if(_0x12518c[_0x60d8('0x3d')][_0x60d8('0x4c')]){_0x1c5455['include']=[{'all':!![]}];}return db[_0x60d8('0x6b')][_0x60d8('0x67')](_0x1c5455);})[_0x60d8('0x29')](function(_0x1293f1){_0x558633[_0x60d8('0x4e')]=_0x1293f1;return _0x558633;});}})['then'](respondWithFilteredResult(_0x32d604,_0x1c5455))[_0x60d8('0x54')](handleError(_0x32d604,null));};exports[_0x60d8('0x6c')]=function(_0x31aa95,_0x3baf63,_0x3030e){var _0x5738f7={'raw':!![],'where':{}};var _0x3aa741={};var _0x6d4e90={'count':0x0,'rows':[]};return db[_0x60d8('0x38')][_0x60d8('0x64')]({'where':{'id':_0x31aa95[_0x60d8('0x50')]['id']}})['then'](handleEntityNotFound(_0x3baf63,null))[_0x60d8('0x29')](function(_0x2c0c8b){if(_0x2c0c8b){_0x3aa741[_0x60d8('0x3b')]=_[_0x60d8('0x3e')](db[_0x60d8('0x6d')][_0x60d8('0x51')]);_0x3aa741[_0x60d8('0x3d')]=_[_0x60d8('0x3e')](_0x31aa95[_0x60d8('0x3d')]);_0x3aa741[_0x60d8('0x3f')]=_[_0x60d8('0x40')](_0x3aa741[_0x60d8('0x3b')],_0x3aa741[_0x60d8('0x3d')]);_0x5738f7[_0x60d8('0x41')]=_['intersection'](_0x3aa741[_0x60d8('0x3b')],qs[_0x60d8('0x42')](_0x31aa95[_0x60d8('0x3d')]['fields']));_0x5738f7[_0x60d8('0x41')]=_0x5738f7['attributes'][_0x60d8('0x43')]?_0x5738f7[_0x60d8('0x41')]:_0x3aa741['model'];if(!_0x31aa95[_0x60d8('0x3d')][_0x60d8('0x44')](_0x60d8('0x45'))){_0x5738f7[_0x60d8('0x22')]=qs['limit'](_0x31aa95['query']['limit']);_0x5738f7[_0x60d8('0x21')]=qs['offset'](_0x31aa95[_0x60d8('0x3d')][_0x60d8('0x21')]);}_0x5738f7[_0x60d8('0x46')]=qs[_0x60d8('0x47')](_0x31aa95['query']['sort']);_0x5738f7[_0x60d8('0x48')]=qs[_0x60d8('0x3f')](_[_0x60d8('0x49')](_0x31aa95[_0x60d8('0x3d')],_0x3aa741[_0x60d8('0x3f')]));_0x5738f7[_0x60d8('0x48')][_0x60d8('0x66')]=_0x2c0c8b['id'];if(_0x31aa95[_0x60d8('0x3d')][_0x60d8('0x2d')]){_0x5738f7[_0x60d8('0x48')]=_[_0x60d8('0x52')](_0x5738f7[_0x60d8('0x48')],{'$or':_[_0x60d8('0x3c')](_0x5738f7[_0x60d8('0x41')],function(_0xd0061f){var _0x4bba22={};_0x4bba22[_0xd0061f]={'$like':'%'+_0x31aa95[_0x60d8('0x3d')][_0x60d8('0x2d')]+'%'};return _0x4bba22;})});}_0x5738f7=_['merge']({},_0x5738f7,_0x31aa95['options']);return db['CmHopperBlack'][_0x60d8('0x20')]({'where':_0x5738f7[_0x60d8('0x48')]})[_0x60d8('0x29')](function(_0x15613f){_0x6d4e90[_0x60d8('0x20')]=_0x15613f;if(_0x31aa95[_0x60d8('0x3d')]['includeAll']){_0x5738f7[_0x60d8('0x4d')]=[{'all':!![]}];}return db[_0x60d8('0x6d')][_0x60d8('0x67')](_0x5738f7);})[_0x60d8('0x29')](function(_0x16b01c){_0x6d4e90[_0x60d8('0x4e')]=_0x16b01c;return _0x6d4e90;});}})[_0x60d8('0x29')](respondWithFilteredResult(_0x3baf63,_0x5738f7))['catch'](handleError(_0x3baf63,null));};exports[_0x60d8('0x6e')]=function(_0x24233b,_0x595fab,_0x111565){var _0x370d6b={};var _0x13f3bd={};var _0x14a813;var _0x2509ce;return db[_0x60d8('0x38')][_0x60d8('0x64')]({'where':{'id':_0x24233b[_0x60d8('0x50')]['id']}})['then'](handleEntityNotFound(_0x595fab,null))[_0x60d8('0x29')](function(_0x4c0f9c){if(_0x4c0f9c){_0x14a813=_0x4c0f9c;_0x13f3bd[_0x60d8('0x3b')]=_[_0x60d8('0x3e')](db[_0x60d8('0x6f')]['rawAttributes']);_0x13f3bd['query']=_[_0x60d8('0x3e')](_0x24233b['query']);_0x13f3bd[_0x60d8('0x3f')]=_['intersection'](_0x13f3bd['model'],_0x13f3bd[_0x60d8('0x3d')]);_0x370d6b[_0x60d8('0x41')]=_[_0x60d8('0x40')](_0x13f3bd[_0x60d8('0x3b')],qs[_0x60d8('0x42')](_0x24233b['query'][_0x60d8('0x42')]));_0x370d6b['attributes']=_0x370d6b[_0x60d8('0x41')][_0x60d8('0x43')]?_0x370d6b['attributes']:_0x13f3bd['model'];_0x370d6b[_0x60d8('0x46')]=qs['sort'](_0x24233b[_0x60d8('0x3d')][_0x60d8('0x47')]);_0x370d6b['where']=qs['filters'](_['pick'](_0x24233b[_0x60d8('0x3d')],_0x13f3bd[_0x60d8('0x3f')]));if(_0x24233b[_0x60d8('0x3d')][_0x60d8('0x2d')]){_0x370d6b[_0x60d8('0x48')]=_['merge'](_0x370d6b[_0x60d8('0x48')],{'$or':_[_0x60d8('0x3c')](_0x370d6b['attributes'],function(_0x37e20b){var _0x4de537={};_0x4de537[_0x37e20b]={'$like':'%'+_0x24233b[_0x60d8('0x3d')][_0x60d8('0x2d')]+'%'};return _0x4de537;})});}_0x370d6b=_['merge']({},_0x370d6b,_0x24233b['options']);return _0x14a813[_0x60d8('0x6e')](_0x370d6b);}})[_0x60d8('0x29')](function(_0x42e884){if(_0x42e884){_0x2509ce=_0x42e884[_0x60d8('0x43')];if(!_0x24233b[_0x60d8('0x3d')][_0x60d8('0x44')](_0x60d8('0x45'))){_0x370d6b[_0x60d8('0x22')]=qs[_0x60d8('0x22')](_0x24233b[_0x60d8('0x3d')]['limit']);_0x370d6b[_0x60d8('0x21')]=qs[_0x60d8('0x21')](_0x24233b[_0x60d8('0x3d')]['offset']);}return _0x14a813[_0x60d8('0x6e')](_0x370d6b);}})[_0x60d8('0x29')](function(_0x24d37c){if(_0x24d37c){return _0x24d37c?{'count':_0x2509ce,'rows':_0x24d37c}:null;}})[_0x60d8('0x29')](respondWithResult(_0x595fab,null))[_0x60d8('0x54')](handleError(_0x595fab,null));};exports['addTeams']=function(_0xd55df7,_0x3b28de,_0x207955){var _0x5783e3=_0xd55df7[_0x60d8('0x60')][_0x60d8('0x70')];var _0x488d18=_[_0x60d8('0x3c')](_0x5783e3,'id');return db[_0x60d8('0x6f')]['findAll']({'where':{'id':_0x488d18},'attributes':['id'],'include':[{'model':db[_0x60d8('0x71')],'as':_0x60d8('0x72'),'attributes':['id','name',_0x60d8('0x73'),'voicePause',_0x60d8('0x74')],'raw':!![]}]})[_0x60d8('0x29')](function(_0x29bf9c){if(_0x29bf9c){var _0x5815ed=_[_0x60d8('0x75')](_0x29bf9c,function(_0x38b8ef){var _0x8fa729=_0x38b8ef[_0x60d8('0x59')]({'plain':!![]});_0x8fa729[_0x60d8('0x72')][_0x60d8('0x76')](function(_0x9c6c57){_0x9c6c57['penalty']=_[_0x60d8('0x53')](_0x5783e3,{'id':_0x8fa729['id']})[_0x60d8('0x77')];});return _0x8fa729['Agents'];});return db[_0x60d8('0x38')][_0x60d8('0x53')]({'where':{'id':_0xd55df7[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](function(_0x469417){return db[_0x60d8('0x78')][_0x60d8('0x79')](function(_0x5f51de){return _0x469417['addTeams'](_0x488d18,{'transaction':_0x5f51de})[_0x60d8('0x29')](function(){return BPromise[_0x60d8('0x7a')](_0x5815ed,function(_0x31df6a){return db['UserVoiceQueue'][_0x60d8('0x7b')]({'where':{'UserId':_0x31df6a['id'],'VoiceQueueId':_0xd55df7[_0x60d8('0x50')]['id']},'defaults':{'penalty':_0x31df6a['penalty']},'transaction':_0x5f51de});});})['then'](function(){return BPromise['each'](_['filter'](_0x5815ed,{'online':!![]}),function(_0x34ad3a){return db[_0x60d8('0x7c')][_0x60d8('0x7d')]({'membername':_0x34ad3a[_0x60d8('0x32')],'UserId':_0x34ad3a['id'],'queue_name':_0x469417[_0x60d8('0x32')],'VoiceQueueId':_0x469417['id'],'interface':_[_0x60d8('0x7e')](_0x34ad3a[_0x60d8('0x74')])?util[_0x60d8('0x7f')](_0x60d8('0x80'),_0x34ad3a['name']):_0x34ad3a['interface'],'paused':_0x34ad3a['voicePause']||![],'penalty':_0x34ad3a[_0x60d8('0x77')]},{'transaction':_0x5f51de});});})[_0x60d8('0x29')](function(){_0x5815ed[_0x60d8('0x76')](function(_0x5450b1){socket[_0x60d8('0x81')](_0x60d8('0x82'),{'UserId':_0x5450b1['id'],'VoiceQueueId':_0x469417['id']});});});});});}})[_0x60d8('0x29')](respondWithStatusCode(_0x3b28de,null))[_0x60d8('0x54')](handleError(_0x3b28de,null));};exports[_0x60d8('0x83')]=function(_0x3e046a,_0x5a6cf9,_0x4712aa){return db[_0x60d8('0x6f')]['findAll']({'where':{'id':_0x3e046a[_0x60d8('0x3d')][_0x60d8('0x84')]},'attributes':['id'],'include':[{'model':db[_0x60d8('0x71')],'as':_0x60d8('0x72'),'attributes':['id'],'raw':!![]}]})[_0x60d8('0x29')](handleEntityNotFound(_0x5a6cf9,null))[_0x60d8('0x29')](function(_0x58cfb0){var _0x2bbf55=_[_0x60d8('0x3c')](_0x58cfb0,'id');var _0x4cc6ea=[];var _0x39dbf2=[];var _0x3cc60b=squel['select']();_0x3cc60b[_0x60d8('0x85')](_0x60d8('0x86'))[_0x60d8('0x87')](_0x60d8('0x88'),'tq')[_0x60d8('0x89')]('user_has_teams','ut',_0x60d8('0x8a'))[_0x60d8('0x48')](_0x60d8('0x8b'),_0x3e046a['params']['id']);for(var _0x16394d=0x0;_0x16394d<_0x58cfb0[_0x60d8('0x43')];_0x16394d+=0x1){let _0x670ed0=_0x58cfb0[_0x16394d];for(var _0x114da1=0x0;_0x114da1<_0x670ed0[_0x60d8('0x72')]['length'];_0x114da1+=0x1){let _0x590d03=_0x670ed0[_0x60d8('0x72')][_0x114da1];var _0x4d7fbd=_0x3cc60b[_0x60d8('0x8c')]();_0x4d7fbd[_0x60d8('0x48')](_0x60d8('0x8d'),_0x590d03['id']);_0x39dbf2[_0x60d8('0x8e')](db[_0x60d8('0x78')][_0x60d8('0x3d')](_0x4d7fbd['toString'](),{'type':db[_0x60d8('0x78')][_0x60d8('0x8f')][_0x60d8('0x90')]})[_0x60d8('0x29')](function(_0x546452){if(_0x546452[_0x60d8('0x43')]===0x1){return _0x590d03['id'];}else{var _0x436c52=_['every'](_[_0x60d8('0x3c')](_0x546452,_0x60d8('0x91')),function(_0x3e9704){return _[_0x60d8('0x30')](_0x2bbf55,_0x3e9704);});if(_0x436c52){return _0x590d03['id'];}}}));}}return BPromise[_0x60d8('0x92')](_0x39dbf2)[_0x60d8('0x29')](function(_0x447b5a){_0x4cc6ea=_(_0x4cc6ea)[_0x60d8('0x93')](_0x447b5a)[_0x60d8('0x94')]()[_0x60d8('0x2f')]();return db[_0x60d8('0x38')][_0x60d8('0x53')]({'where':{'id':_0x3e046a['params']['id']}})[_0x60d8('0x29')](function(_0x2e81de){return db[_0x60d8('0x78')][_0x60d8('0x79')](function(_0x34702){return _0x2e81de[_0x60d8('0x83')](_0x3e046a[_0x60d8('0x3d')][_0x60d8('0x84')],{'transaction':_0x34702})['then'](function(){if(!_[_0x60d8('0x95')](_0x4cc6ea)){return _0x2e81de[_0x60d8('0x96')](_0x4cc6ea,{'transaction':_0x34702})[_0x60d8('0x29')](function(){return db[_0x60d8('0x7c')][_0x60d8('0x28')]({'where':{'VoiceQueueId':_0x3e046a[_0x60d8('0x50')]['id'],'UserId':_0x4cc6ea},'transaction':_0x34702});});}})[_0x60d8('0x29')](function(){_0x4cc6ea[_0x60d8('0x76')](function(_0x4ccd9e){socket[_0x60d8('0x81')](_0x60d8('0x97'),{'UserId':_0x4ccd9e,'VoiceQueueId':_0x2e81de['id']});});});});});});})[_0x60d8('0x29')](respondWithStatusCode(_0x5a6cf9,null))[_0x60d8('0x54')](handleError(_0x5a6cf9,null));};exports['addAgents']=function(_0x35c878,_0x4c8e14,_0x448c75){var _0x423549,_0x28c0a5;return db[_0x60d8('0x38')][_0x60d8('0x53')]({'where':{'id':_0x35c878['params']['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x4c8e14,null))['then'](function(_0x48c35d){if(_0x48c35d){_0x28c0a5=_0x48c35d;return _0x48c35d[_0x60d8('0x98')](_0x35c878[_0x60d8('0x60')][_0x60d8('0x84')],_[_0x60d8('0x5d')](_0x35c878[_0x60d8('0x60')],[_0x60d8('0x84'),'id'])||{})[_0x60d8('0x99')](function(_0x278a96){for(var _0x4d4598=0x0;_0x4d4598<_0x35c878[_0x60d8('0x60')][_0x60d8('0x84')][_0x60d8('0x43')];_0x4d4598+=0x1){socket['emit']('userVoiceQueue:save',{'UserId':_0x35c878[_0x60d8('0x60')][_0x60d8('0x84')][_0x4d4598],'VoiceQueueId':_0x35c878[_0x60d8('0x50')]['id']});}return _0x278a96;});}})[_0x60d8('0x29')](function(_0x32958c){_0x423549=_0x32958c||[];if(_0x28c0a5){return db['User'][_0x60d8('0x67')]({'where':{'id':_0x35c878['body'][_0x60d8('0x84')]},'attributes':['id',_0x60d8('0x32'),_0x60d8('0x73'),_0x60d8('0x9a'),_0x60d8('0x74')],'raw':!![]});}})[_0x60d8('0x29')](function(_0x4be4fa){if(!_['isEmpty'](_0x4be4fa)){var _0x1ccb33=[];for(var _0x57e3aa=0x0;_0x57e3aa<_0x4be4fa['length'];_0x57e3aa++){if(_0x4be4fa[_0x57e3aa][_0x60d8('0x73')]){_0x1ccb33['push'](db[_0x60d8('0x7c')][_0x60d8('0x7d')]({'membername':_0x4be4fa[_0x57e3aa][_0x60d8('0x32')],'UserId':_0x4be4fa[_0x57e3aa]['id'],'queue_name':_0x28c0a5[_0x60d8('0x32')],'VoiceQueueId':_0x28c0a5['id'],'interface':_[_0x60d8('0x7e')](_0x4be4fa[_0x57e3aa][_0x60d8('0x74')])?util[_0x60d8('0x7f')]('SIP/%s',_0x4be4fa[_0x57e3aa][_0x60d8('0x32')]):_0x4be4fa[_0x57e3aa][_0x60d8('0x74')],'paused':_0x4be4fa[_0x57e3aa][_0x60d8('0x9a')]||![],'penalty':_0x35c878[_0x60d8('0x60')]['penalty']||0x0}));}}return BPromise['all'](_0x1ccb33);}})['then'](function(){return _0x423549;})[_0x60d8('0x29')](respondWithResult(_0x4c8e14,null))[_0x60d8('0x54')](handleError(_0x4c8e14,null));};exports[_0x60d8('0x96')]=function(_0x124baf,_0x1c3530,_0x4d91e3){return db[_0x60d8('0x38')][_0x60d8('0x53')]({'where':{'id':_0x124baf[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x1c3530,null))[_0x60d8('0x29')](function(_0x30f6a6){if(_0x30f6a6){return _0x30f6a6[_0x60d8('0x96')](_0x124baf[_0x60d8('0x3d')][_0x60d8('0x84')])[_0x60d8('0x29')](function(){if(_[_0x60d8('0x9b')](_0x124baf[_0x60d8('0x3d')][_0x60d8('0x84')])){for(var _0xf37c68=0x0;_0xf37c68<_0x124baf[_0x60d8('0x3d')][_0x60d8('0x84')][_0x60d8('0x43')];_0xf37c68+=0x1){socket[_0x60d8('0x81')](_0x60d8('0x97'),{'UserId':Number(_0x124baf[_0x60d8('0x3d')][_0x60d8('0x84')][_0xf37c68]),'VoiceQueueId':Number(_0x124baf[_0x60d8('0x50')]['id'])});}}else{socket[_0x60d8('0x81')](_0x60d8('0x97'),{'UserId':Number(_0x124baf[_0x60d8('0x3d')][_0x60d8('0x84')]),'VoiceQueueId':Number(_0x124baf[_0x60d8('0x50')]['id'])});}});}})[_0x60d8('0x29')](function(_0x16e032){return db[_0x60d8('0x7c')][_0x60d8('0x28')]({'where':{'VoiceQueueId':_0x124baf[_0x60d8('0x50')]['id'],'UserId':_0x124baf['query'][_0x60d8('0x84')]}})['then'](function(){return _0x16e032;});})[_0x60d8('0x29')](respondWithStatusCode(_0x1c3530,null))[_0x60d8('0x54')](handleError(_0x1c3530,null));};exports['getAgents']=function(_0x2e1d58,_0x1d5849,_0x49bdf9){var _0x430287={};var _0x1fcc7d={};var _0x2caf47;var _0x95daaa;return db[_0x60d8('0x38')][_0x60d8('0x64')]({'where':{'id':_0x2e1d58['params']['id']}})['then'](handleEntityNotFound(_0x1d5849,null))[_0x60d8('0x29')](function(_0x2f5531){if(_0x2f5531){_0x2caf47=_0x2f5531;_0x1fcc7d[_0x60d8('0x3b')]=_['keys'](db[_0x60d8('0x71')][_0x60d8('0x51')]);_0x1fcc7d[_0x60d8('0x3d')]=_[_0x60d8('0x3e')](_0x2e1d58[_0x60d8('0x3d')]);_0x1fcc7d[_0x60d8('0x3f')]=_[_0x60d8('0x40')](_0x1fcc7d[_0x60d8('0x3b')],_0x1fcc7d[_0x60d8('0x3d')]);_0x430287[_0x60d8('0x41')]=_[_0x60d8('0x40')](_0x1fcc7d[_0x60d8('0x3b')],qs['fields'](_0x2e1d58['query'][_0x60d8('0x42')]));_0x430287[_0x60d8('0x41')]=_0x430287['attributes'][_0x60d8('0x43')]?_0x430287[_0x60d8('0x41')]:_0x1fcc7d[_0x60d8('0x3b')];_0x430287[_0x60d8('0x46')]=qs[_0x60d8('0x47')](_0x2e1d58[_0x60d8('0x3d')]['sort']);_0x430287[_0x60d8('0x48')]=qs['filters'](_[_0x60d8('0x49')](_0x2e1d58[_0x60d8('0x3d')],_0x1fcc7d[_0x60d8('0x3f')]));if(_0x2e1d58['query'][_0x60d8('0x2d')]){_0x430287[_0x60d8('0x48')]=_[_0x60d8('0x52')](_0x430287[_0x60d8('0x48')],{'$or':_[_0x60d8('0x3c')](_0x430287[_0x60d8('0x41')],function(_0x4f19e0){var _0x196ec2={};_0x196ec2[_0x4f19e0]={'$like':'%'+_0x2e1d58[_0x60d8('0x3d')][_0x60d8('0x2d')]+'%'};return _0x196ec2;})});}_0x430287=_[_0x60d8('0x52')]({},_0x430287,_0x2e1d58['options']);return _0x2caf47[_0x60d8('0x9c')](_0x430287);}})[_0x60d8('0x29')](function(_0x4234cd){if(_0x4234cd){_0x95daaa=_0x4234cd[_0x60d8('0x43')];if(!_0x2e1d58['query'][_0x60d8('0x44')](_0x60d8('0x45'))){_0x430287[_0x60d8('0x22')]=qs[_0x60d8('0x22')](_0x2e1d58[_0x60d8('0x3d')][_0x60d8('0x22')]);_0x430287[_0x60d8('0x21')]=qs[_0x60d8('0x21')](_0x2e1d58['query']['offset']);}return _0x2caf47[_0x60d8('0x9c')](_0x430287);}})[_0x60d8('0x29')](function(_0x2d8090){if(_0x2d8090){return _0x2d8090?{'count':_0x95daaa,'rows':_0x2d8090}:null;}})[_0x60d8('0x29')](respondWithResult(_0x1d5849,null))[_0x60d8('0x54')](handleError(_0x1d5849,null));};exports[_0x60d8('0x9d')]=function(_0x36304e,_0xc0566e,_0x275fec){var _0xb80470={};var _0x40bf53={};var _0x5eb386;var _0x2da54f;return db[_0x60d8('0x38')][_0x60d8('0x64')]({'where':{'id':_0x36304e[_0x60d8('0x50')]['id']}})['then'](handleEntityNotFound(_0xc0566e,null))['then'](function(_0x111469){if(_0x111469){_0x5eb386=_0x111469;_0x40bf53[_0x60d8('0x3b')]=_['keys'](db[_0x60d8('0x7c')][_0x60d8('0x51')]);_0x40bf53[_0x60d8('0x3d')]=_[_0x60d8('0x3e')](_0x36304e[_0x60d8('0x3d')]);_0x40bf53[_0x60d8('0x3f')]=_['intersection'](_0x40bf53[_0x60d8('0x3b')],_0x40bf53['query']);_0xb80470[_0x60d8('0x41')]=_[_0x60d8('0x40')](_0x40bf53['model'],qs['fields'](_0x36304e[_0x60d8('0x3d')][_0x60d8('0x42')]));_0xb80470[_0x60d8('0x41')]=_0xb80470[_0x60d8('0x41')][_0x60d8('0x43')]?_0xb80470[_0x60d8('0x41')]:_0x40bf53[_0x60d8('0x3b')];_0xb80470[_0x60d8('0x46')]=qs[_0x60d8('0x47')](_0x36304e[_0x60d8('0x3d')]['sort']);_0xb80470[_0x60d8('0x48')]=qs[_0x60d8('0x3f')](_[_0x60d8('0x49')](_0x36304e[_0x60d8('0x3d')],_0x40bf53[_0x60d8('0x3f')]));if(_0x36304e[_0x60d8('0x3d')]['filter']){_0xb80470[_0x60d8('0x48')]=_['merge'](_0xb80470[_0x60d8('0x48')],{'$or':_[_0x60d8('0x3c')](_0xb80470[_0x60d8('0x41')],function(_0x41900b){var _0x1761e9={};_0x1761e9[_0x41900b]={'$like':'%'+_0x36304e[_0x60d8('0x3d')][_0x60d8('0x2d')]+'%'};return _0x1761e9;})});}_0xb80470=_[_0x60d8('0x52')]({},_0xb80470,_0x36304e[_0x60d8('0x4b')]);return _0x5eb386[_0x60d8('0x9d')](_0xb80470);}})['then'](function(_0x9960b6){if(_0x9960b6){_0x2da54f=_0x9960b6['length'];if(!_0x36304e['query'][_0x60d8('0x44')]('nolimit')){_0xb80470[_0x60d8('0x22')]=qs[_0x60d8('0x22')](_0x36304e[_0x60d8('0x3d')][_0x60d8('0x22')]);_0xb80470['offset']=qs[_0x60d8('0x21')](_0x36304e[_0x60d8('0x3d')][_0x60d8('0x21')]);}return _0x5eb386[_0x60d8('0x9d')](_0xb80470);}})[_0x60d8('0x29')](function(_0x1f422a){return _0x1f422a?{'count':_0x2da54f,'rows':_0x1f422a}:null;})[_0x60d8('0x29')](respondWithResult(_0xc0566e,null))[_0x60d8('0x54')](handleError(_0xc0566e,null));};exports['getLists']=function(_0x245b5a,_0x55cc91,_0x1e5995){var _0x3f9eb4={};var _0x15458c={};var _0x2f734b;var _0x502da8;return db[_0x60d8('0x38')][_0x60d8('0x64')]({'where':{'id':_0x245b5a[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x55cc91,null))['then'](function(_0x42f922){if(_0x42f922){_0x2f734b=_0x42f922;_0x15458c[_0x60d8('0x3b')]=_[_0x60d8('0x3e')](db[_0x60d8('0x9e')][_0x60d8('0x51')]);_0x15458c[_0x60d8('0x3d')]=_['keys'](_0x245b5a[_0x60d8('0x3d')]);_0x15458c[_0x60d8('0x3f')]=_['intersection'](_0x15458c[_0x60d8('0x3b')],_0x15458c[_0x60d8('0x3d')]);_0x3f9eb4[_0x60d8('0x41')]=_['intersection'](_0x15458c[_0x60d8('0x3b')],qs[_0x60d8('0x42')](_0x245b5a[_0x60d8('0x3d')][_0x60d8('0x42')]));_0x3f9eb4[_0x60d8('0x41')]=_0x3f9eb4[_0x60d8('0x41')][_0x60d8('0x43')]?_0x3f9eb4[_0x60d8('0x41')]:_0x15458c['model'];_0x3f9eb4[_0x60d8('0x46')]=qs[_0x60d8('0x47')](_0x245b5a[_0x60d8('0x3d')][_0x60d8('0x47')]);_0x3f9eb4[_0x60d8('0x48')]=qs[_0x60d8('0x3f')](_[_0x60d8('0x49')](_0x245b5a[_0x60d8('0x3d')],_0x15458c['filters']));if(_0x245b5a[_0x60d8('0x3d')][_0x60d8('0x2d')]){_0x3f9eb4[_0x60d8('0x48')]=_[_0x60d8('0x52')](_0x3f9eb4['where'],{'$or':_[_0x60d8('0x3c')](_0x3f9eb4[_0x60d8('0x41')],function(_0x46d2db){var _0x3a2b67={};_0x3a2b67[_0x46d2db]={'$like':'%'+_0x245b5a[_0x60d8('0x3d')]['filter']+'%'};return _0x3a2b67;})});}_0x3f9eb4=_[_0x60d8('0x52')]({},_0x3f9eb4,_0x245b5a[_0x60d8('0x4b')]);return _0x2f734b[_0x60d8('0x9f')](_0x3f9eb4);}})['then'](function(_0x2aa924){if(_0x2aa924){_0x502da8=_0x2aa924[_0x60d8('0x43')];if(!_0x245b5a[_0x60d8('0x3d')]['hasOwnProperty'](_0x60d8('0x45'))){_0x3f9eb4['limit']=qs['limit'](_0x245b5a['query'][_0x60d8('0x22')]);_0x3f9eb4[_0x60d8('0x21')]=qs[_0x60d8('0x21')](_0x245b5a['query'][_0x60d8('0x21')]);}return _0x2f734b['getLists'](_0x3f9eb4);}})[_0x60d8('0x29')](function(_0xf7e795){if(_0xf7e795){return _0xf7e795?{'count':_0x502da8,'rows':_0xf7e795}:null;}})[_0x60d8('0x29')](respondWithResult(_0x55cc91,null))[_0x60d8('0x54')](handleError(_0x55cc91,null));};exports['addLists']=function(_0xc63d07,_0x37676f,_0x1aa243){var _0x376d33,_0x2a2f35;return db['VoiceQueue'][_0x60d8('0x53')]({'where':{'id':_0xc63d07['params']['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x37676f,null))[_0x60d8('0x29')](function(_0x2e85cc){if(_0x2e85cc){_0x2a2f35=_0x2e85cc;return _0x2e85cc['addLists'](_0xc63d07[_0x60d8('0x60')][_0x60d8('0x84')],_[_0x60d8('0x5d')](_0xc63d07[_0x60d8('0x60')],['ids','id'])||{});}return null;})[_0x60d8('0x99')](function(_0x21acb9){var _0x53f09d;_0x376d33=_0x21acb9||[];var _0x2ec6df=[];if(_0x21acb9){for(var _0x3e58b3=0x0;_0x3e58b3<_0x21acb9[_0x60d8('0x43')];_0x3e58b3+=0x1){var _0x4f5218=_0x21acb9[_0x3e58b3]['get']({'plain':!![]});_0x2a2f35['dialCheckDuplicateType']=_0xc63d07[_0x60d8('0x60')]['dialCheckDuplicateType']?_0xc63d07[_0x60d8('0x60')][_0x60d8('0xa0')]:_0x2a2f35[_0x60d8('0xa0')];switch(_0x2a2f35[_0x60d8('0xa0')]){case _0x60d8('0xa1'):_0x53f09d=squel[_0x60d8('0xa2')]()['into'](_0x60d8('0xa3'))[_0x60d8('0xa4')](['phone','scheduledAt',_0x60d8('0xa5'),_0x60d8('0xa6'),'VoiceQueueId',_0x60d8('0x5e'),'updatedAt'],squel[_0x60d8('0xa7')]()[_0x60d8('0x85')](_0x60d8('0xa8'),_0x60d8('0xa8'))['field']('NOW()',_0x60d8('0xa9'))[_0x60d8('0x85')]('id',_0x60d8('0xa5'))[_0x60d8('0x85')](_0x4f5218[_0x60d8('0xaa')][_0x60d8('0xab')](),_0x60d8('0xa6'))[_0x60d8('0x85')](_0xc63d07['params']['id'][_0x60d8('0xab')](),_0x60d8('0x66'))[_0x60d8('0x85')](_0x60d8('0xac'),_0x60d8('0x5e'))['field'](_0x60d8('0xac'),_0x60d8('0x5f'))['from'](_0x60d8('0xad'))['where']('deletedAt\x20IS\x20NULL')[_0x60d8('0x48')]('ListId\x20=\x20?',_0x4f5218[_0x60d8('0xaa')][_0x60d8('0xab')]())[_0x60d8('0x48')](_0x60d8('0xae'))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0x60d8('0xa7')]()[_0x60d8('0x85')](_0x60d8('0xaf'))[_0x60d8('0x87')]('cm_hopper_final')[_0x60d8('0x48')](_0x60d8('0x8b'),_0xc63d07[_0x60d8('0x50')]['id']['toString']()))['where'](_0x60d8('0xb0'),squel[_0x60d8('0xa7')]()['field']('COALESCE(phone,\x27\x27)')['from'](_0x60d8('0xa3'))[_0x60d8('0x48')](_0x60d8('0x8b'),_0xc63d07[_0x60d8('0x50')]['id'][_0x60d8('0xab')]())))[_0x60d8('0xab')]();break;case _0x60d8('0xb1'):_0x53f09d=squel[_0x60d8('0xa2')]()['into']('cm_hopper')[_0x60d8('0xa4')]([_0x60d8('0xa8'),_0x60d8('0xa9'),_0x60d8('0xa5'),_0x60d8('0xa6'),_0x60d8('0x66'),_0x60d8('0x5e'),_0x60d8('0x5f')],squel['select']()['field'](_0x60d8('0xa8'),'phone')[_0x60d8('0x85')](_0x60d8('0xac'),_0x60d8('0xa9'))[_0x60d8('0x85')]('id','ContactId')[_0x60d8('0x85')](_0x4f5218['CmListId'][_0x60d8('0xab')](),'ListId')[_0x60d8('0x85')](_0xc63d07['params']['id'][_0x60d8('0xab')](),_0x60d8('0x66'))['field'](_0x60d8('0xac'),_0x60d8('0x5e'))['field']('NOW()',_0x60d8('0x5f'))[_0x60d8('0x87')](_0x60d8('0xad'))['where'](_0x60d8('0xb2'))[_0x60d8('0x48')](_0x60d8('0xb3'),_0x4f5218[_0x60d8('0xaa')][_0x60d8('0xab')]())[_0x60d8('0x48')](_0x60d8('0xae'))[_0x60d8('0x48')]('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x60d8('0x85')](_0x60d8('0xb4'))[_0x60d8('0x87')]('cm_hopper')[_0x60d8('0x48')]('VoiceQueueId\x20=\x20?',_0xc63d07[_0x60d8('0x50')]['id'][_0x60d8('0xab')]())))['toString']();break;default:_0x53f09d=squel[_0x60d8('0xa2')]()[_0x60d8('0xb5')](_0x60d8('0xa3'))['fromQuery']([_0x60d8('0xa8'),'scheduledAt','ContactId',_0x60d8('0xa6'),_0x60d8('0x66'),_0x60d8('0x5e'),_0x60d8('0x5f')],squel[_0x60d8('0xa7')]()[_0x60d8('0x85')](_0x60d8('0xa8'),_0x60d8('0xa8'))['field'](_0x60d8('0xac'),_0x60d8('0xa9'))[_0x60d8('0x85')]('id',_0x60d8('0xa5'))[_0x60d8('0x85')](_0x4f5218[_0x60d8('0xaa')][_0x60d8('0xab')](),_0x60d8('0xa6'))['field'](_0xc63d07[_0x60d8('0x50')]['id'][_0x60d8('0xab')](),_0x60d8('0x66'))['field'](_0x60d8('0xac'),'createdAt')[_0x60d8('0x85')]('NOW()','updatedAt')[_0x60d8('0x87')](_0x60d8('0xad'))[_0x60d8('0x48')]('deletedAt\x20IS\x20NULL')[_0x60d8('0x48')](_0x60d8('0xb3'),_0x4f5218['CmListId'][_0x60d8('0xab')]())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x60d8('0xab')]();}_0x2ec6df['push'](db[_0x60d8('0x78')][_0x60d8('0x3d')](_0x53f09d));}return BPromise[_0x60d8('0x92')](_0x2ec6df);}})['then'](function(){return _0x376d33;})['then'](respondWithResult(_0x37676f,null))['catch'](handleError(_0x37676f,null));};exports[_0x60d8('0xb6')]=function(_0x2ab260,_0x4a7d1f,_0x1b5bb1){return db[_0x60d8('0x38')][_0x60d8('0x53')]({'where':{'id':_0x2ab260[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x4a7d1f,null))[_0x60d8('0x29')](function(_0x4b22bd){if(_0x4b22bd){return _0x4b22bd[_0x60d8('0xb6')](_0x2ab260['query']['ids']);}})[_0x60d8('0x29')](function(_0x3e89a2){if(_0x3e89a2){return db[_0x60d8('0x65')][_0x60d8('0x28')]({'where':{'ListId':_0x2ab260['query']['ids'],'VoiceQueueId':_0x2ab260[_0x60d8('0x50')]['id']}})['then'](function(){return _0x3e89a2;});}})[_0x60d8('0x29')](respondWithStatusCode(_0x4a7d1f,null))['catch'](handleError(_0x4a7d1f,null));};exports[_0x60d8('0xb7')]=function(_0x52ad96,_0x51e5db,_0x4e0a0e){var _0x54c457={};var _0x4d0e97={};var _0x771553;var _0x34deb1;return db['VoiceQueue']['findOne']({'where':{'id':_0x52ad96[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x51e5db,null))[_0x60d8('0x29')](function(_0x5b9c8b){if(_0x5b9c8b){_0x771553=_0x5b9c8b;_0x4d0e97['model']=_[_0x60d8('0x3e')](db['CmList'][_0x60d8('0x51')]);_0x4d0e97['query']=_[_0x60d8('0x3e')](_0x52ad96[_0x60d8('0x3d')]);_0x4d0e97[_0x60d8('0x3f')]=_['intersection'](_0x4d0e97['model'],_0x4d0e97['query']);_0x54c457['attributes']=_['intersection'](_0x4d0e97[_0x60d8('0x3b')],qs[_0x60d8('0x42')](_0x52ad96['query']['fields']));_0x54c457[_0x60d8('0x41')]=_0x54c457[_0x60d8('0x41')][_0x60d8('0x43')]?_0x54c457[_0x60d8('0x41')]:_0x4d0e97[_0x60d8('0x3b')];_0x54c457['order']=qs[_0x60d8('0x47')](_0x52ad96[_0x60d8('0x3d')][_0x60d8('0x47')]);_0x54c457[_0x60d8('0x48')]=qs['filters'](_[_0x60d8('0x49')](_0x52ad96['query'],_0x4d0e97[_0x60d8('0x3f')]));if(_0x52ad96[_0x60d8('0x3d')][_0x60d8('0x2d')]){_0x54c457['where']=_[_0x60d8('0x52')](_0x54c457['where'],{'$or':_[_0x60d8('0x3c')](_0x54c457[_0x60d8('0x41')],function(_0x5f212b){var _0x341a1e={};_0x341a1e[_0x5f212b]={'$like':'%'+_0x52ad96[_0x60d8('0x3d')]['filter']+'%'};return _0x341a1e;})});}_0x54c457=_[_0x60d8('0x52')]({},_0x54c457,_0x52ad96[_0x60d8('0x4b')]);return _0x771553[_0x60d8('0xb7')](_0x54c457);}})[_0x60d8('0x29')](function(_0x288515){if(_0x288515){_0x34deb1=_0x288515[_0x60d8('0x43')];if(!_0x52ad96['query'][_0x60d8('0x44')](_0x60d8('0x45'))){_0x54c457[_0x60d8('0x22')]=qs[_0x60d8('0x22')](_0x52ad96[_0x60d8('0x3d')][_0x60d8('0x22')]);_0x54c457['offset']=qs[_0x60d8('0x21')](_0x52ad96['query'][_0x60d8('0x21')]);}return _0x771553[_0x60d8('0xb7')](_0x54c457);}})['then'](function(_0x25798a){if(_0x25798a){return _0x25798a?{'count':_0x34deb1,'rows':_0x25798a}:null;}})[_0x60d8('0x29')](respondWithResult(_0x51e5db,null))[_0x60d8('0x54')](handleError(_0x51e5db,null));};exports[_0x60d8('0xb8')]=function(_0x498b06,_0x47ba4f,_0x2bea78){var _0x1d2c22,_0x105c47;return db['VoiceQueue'][_0x60d8('0x53')]({'where':{'id':_0x498b06[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x47ba4f,null))[_0x60d8('0x29')](function(_0x282e51){if(_0x282e51){_0x105c47=_0x282e51;return _0x282e51[_0x60d8('0xb8')](_0x498b06[_0x60d8('0x60')][_0x60d8('0x84')],_[_0x60d8('0x5d')](_0x498b06[_0x60d8('0x60')],[_0x60d8('0x84'),'id'])||{});}return null;})[_0x60d8('0x99')](function(_0x3e7f6c){var _0x11c367;_0x1d2c22=_0x3e7f6c||[];var _0x3f44a1=[];if(_0x3e7f6c){for(var _0x3d23b4=0x0;_0x3d23b4<_0x3e7f6c[_0x60d8('0x43')];_0x3d23b4+=0x1){var _0x19fbb0=_0x3e7f6c[_0x3d23b4][_0x60d8('0x59')]({'plain':!![]});_0x11c367=squel[_0x60d8('0xa2')]()[_0x60d8('0xb5')](_0x60d8('0xb9'))[_0x60d8('0xa4')]([_0x60d8('0xa8'),_0x60d8('0xa5'),_0x60d8('0xa6'),_0x60d8('0x66'),_0x60d8('0x5e'),_0x60d8('0x5f')],squel[_0x60d8('0xa7')]()[_0x60d8('0x85')](_0x60d8('0xa8'),_0x60d8('0xa8'))[_0x60d8('0x85')]('id',_0x60d8('0xa5'))['field'](_0x19fbb0[_0x60d8('0xaa')]['toString'](),_0x60d8('0xa6'))[_0x60d8('0x85')](_0x498b06['params']['id']['toString'](),'VoiceQueueId')[_0x60d8('0x85')](_0x60d8('0xac'),_0x60d8('0x5e'))[_0x60d8('0x85')](_0x60d8('0xac'),_0x60d8('0x5f'))[_0x60d8('0x87')](_0x60d8('0xad'))[_0x60d8('0x48')](_0x60d8('0xb2'))[_0x60d8('0x48')](_0x60d8('0xb3'),_0x19fbb0['CmListId'][_0x60d8('0xab')]())[_0x60d8('0x48')]('phone\x20IS\x20NOT\x20NULL'))[_0x60d8('0xab')]();_0x3f44a1[_0x60d8('0x8e')](db[_0x60d8('0x78')][_0x60d8('0x3d')](_0x11c367));}return BPromise['all'](_0x3f44a1);}})[_0x60d8('0x29')](function(){return _0x1d2c22;})[_0x60d8('0x29')](respondWithResult(_0x47ba4f,null))['catch'](handleError(_0x47ba4f,null));};exports[_0x60d8('0xba')]=function(_0x51e1e3,_0x327d87,_0x3f7346){return db[_0x60d8('0x38')]['find']({'where':{'id':_0x51e1e3[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](handleEntityNotFound(_0x327d87,null))[_0x60d8('0x29')](function(_0x5a93dd){if(_0x5a93dd){return _0x5a93dd['removeBlackLists'](_0x51e1e3[_0x60d8('0x3d')][_0x60d8('0x84')]);}})[_0x60d8('0x29')](function(_0xb33aa4){if(_0xb33aa4){return db[_0x60d8('0x6d')][_0x60d8('0x28')]({'where':{'ListId':_0x51e1e3[_0x60d8('0x3d')][_0x60d8('0x84')],'VoiceQueueId':_0x51e1e3[_0x60d8('0x50')]['id']}})[_0x60d8('0x29')](function(){return _0xb33aa4;});}})[_0x60d8('0x29')](respondWithStatusCode(_0x327d87,null))[_0x60d8('0x54')](handleError(_0x327d87,null));};