Built motion from commit 85328c08.|2.5.50
[motion2.git] / server / api / voiceQueue / voiceQueue.controller.js
index 50a55c4..490aff3 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x0e9b=['util','path','sox','to-csv','fs-extra','squel','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','localhost','socket.io-emitter','redis','register','sendStatus','status','end','json','offset','undefined','count','limit','set','save','update','then','destroy','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','map','value','includes','type','name','UserProfileResource','error','stack','index','VoiceQueue','rawAttributes','key','query','filters','intersection','model','fields','attributes','length','hasOwnProperty','order','sort','where','VIRTUAL','merge','options','catch','show','params','keys','includeAll','include','find','create','body','user','role','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','updatedAt','createdAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','getHoppers','nolimit','pick','VoiceQueueId','CmHopper','findAll','rows','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','addTeams','Team','voicePause','interface','flatMap','Agents','forEach','penalty','sequelize','transaction','each','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','SIP/%s','emit','userVoiceQueue:save','ids','select','field','tq.TeamId','from','team_has_voice_queues','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','every','TeamId','all','union','removeTeams','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','User','online','format','getAgents','getMembers','getLists','addLists','dialCheckDuplicateType','always','insert','fromQuery','phone','scheduledAt','NOW()','ContactId','CmListId','ListId','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','COALESCE(phone,\x27\x27)','cm_hopper','onlyIfOpen','into','ListId\x20=\x20?','removeLists','getBlackLists','CmList','addBlackLists','cm_hopper_black','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache'];(function(_0x4eaa4c,_0x2f7422){var _0x15aec6=function(_0x23efc9){while(--_0x23efc9){_0x4eaa4c['push'](_0x4eaa4c['shift']());}};_0x15aec6(++_0x2f7422);}(_0x0e9b,0xb3));var _0xb0e9=function(_0x53e885,_0x49d504){_0x53e885=_0x53e885-0x0;var _0x40e126=_0x0e9b[_0x53e885];return _0x40e126;};'use strict';var emlformat=require(_0xb0e9('0x0'));var rimraf=require(_0xb0e9('0x1'));var zipdir=require(_0xb0e9('0x2'));var jsonpatch=require(_0xb0e9('0x3'));var rp=require(_0xb0e9('0x4'));var moment=require(_0xb0e9('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xb0e9('0x6'));var util=require(_0xb0e9('0x7'));var path=require(_0xb0e9('0x8'));var sox=require(_0xb0e9('0x9'));var csv=require(_0xb0e9('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xb0e9('0xb'));var _=require('lodash');var squel=require(_0xb0e9('0xc'));var crypto=require('crypto');var jsforce=require(_0xb0e9('0xd'));var deskjs=require(_0xb0e9('0xe'));var toCsv=require(_0xb0e9('0xa'));var querystring=require(_0xb0e9('0xf'));var Papa=require('papaparse');var Redis=require(_0xb0e9('0x10'));var authService=require(_0xb0e9('0x11'));var qs=require(_0xb0e9('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xb0e9('0x13'))(_0xb0e9('0x14'));var utils=require(_0xb0e9('0x15'));var config=require(_0xb0e9('0x16'));var licenseUtil=require(_0xb0e9('0x17'));var db=require(_0xb0e9('0x18'))['db'];config['redis']=_[_0xb0e9('0x19')](config['redis'],{'host':_0xb0e9('0x1a'),'port':0x18eb});var socket=require(_0xb0e9('0x1b'))(new Redis(config[_0xb0e9('0x1c')]));require('./voiceQueue.socket')[_0xb0e9('0x1d')](socket);function respondWithStatusCode(_0x20db9c,_0xa5927f){_0xa5927f=_0xa5927f||0xcc;return function(_0x142539){if(_0x142539){return _0x20db9c[_0xb0e9('0x1e')](_0xa5927f);}return _0x20db9c[_0xb0e9('0x1f')](_0xa5927f)[_0xb0e9('0x20')]();};}function respondWithResult(_0x480028,_0x43f181){_0x43f181=_0x43f181||0xc8;return function(_0x5efd29){if(_0x5efd29){return _0x480028[_0xb0e9('0x1f')](_0x43f181)[_0xb0e9('0x21')](_0x5efd29);}};}function respondWithFilteredResult(_0x20f038,_0xa5c04b){return function(_0x42674b){if(_0x42674b){var _0x4675ca=typeof _0xa5c04b[_0xb0e9('0x22')]===_0xb0e9('0x23')&&typeof _0xa5c04b['limit']===_0xb0e9('0x23');var _0x5431ce=_0x42674b[_0xb0e9('0x24')];var _0x8fabf5=_0x4675ca?0x0:_0xa5c04b['offset'];var _0x42353b=_0x4675ca?_0x42674b[_0xb0e9('0x24')]:_0xa5c04b['offset']+_0xa5c04b[_0xb0e9('0x25')];var _0x3847d3;if(_0x42353b>=_0x5431ce){_0x42353b=_0x5431ce;_0x3847d3=0xc8;}else{_0x3847d3=0xce;}_0x20f038[_0xb0e9('0x1f')](_0x3847d3);return _0x20f038[_0xb0e9('0x26')]('Content-Range',_0x8fabf5+'-'+_0x42353b+'/'+_0x5431ce)[_0xb0e9('0x21')](_0x42674b);}return null;};}function patchUpdates(_0x5035c4){return function(_0x1f144e){try{jsonpatch['apply'](_0x1f144e,_0x5035c4,!![]);}catch(_0x154c0b){return BPromise['reject'](_0x154c0b);}return _0x1f144e[_0xb0e9('0x27')]();};}function saveUpdates(_0x18a5a8,_0xb618ed){return function(_0x1b5215){if(_0x1b5215){return _0x1b5215[_0xb0e9('0x28')](_0x18a5a8)[_0xb0e9('0x29')](function(_0x4bd1df){return _0x4bd1df;});}return null;};}function removeEntity(_0x409e97,_0x4b16e5){return function(_0x3ac7cd){if(_0x3ac7cd){return _0x3ac7cd[_0xb0e9('0x2a')]()[_0xb0e9('0x29')](function(){var _0x30157d=_0x3ac7cd[_0xb0e9('0x2b')]({'plain':!![]});var _0x46a199=[{'name':_0xb0e9('0x2c'),'value':_0xb0e9('0x2d'),'ignore':![]},{'name':_0xb0e9('0x2e'),'value':_0xb0e9('0x2f'),'ignore':![]}];var _0x5a1024=_(_0x46a199)[_0xb0e9('0x30')]('ignore')[_0xb0e9('0x31')](_0xb0e9('0x32'))[_0xb0e9('0x32')]();if(_[_0xb0e9('0x33')](_0x5a1024,_0x30157d['type'])){return;}var _0x136685=_['find'](_0x46a199,[_0xb0e9('0x32'),_0x30157d[_0xb0e9('0x34')]])[_0xb0e9('0x35')];return db[_0xb0e9('0x36')]['destroy']({'where':{'type':_0x136685,'resourceId':_0x30157d['id']}})['then'](function(){return _0x3ac7cd;});})[_0xb0e9('0x29')](function(){_0x409e97[_0xb0e9('0x1f')](0xcc)[_0xb0e9('0x20')]();});}};}function handleEntityNotFound(_0x1e1b24,_0x5a3a00){return function(_0xf281d6){if(!_0xf281d6){_0x1e1b24[_0xb0e9('0x1e')](0x194);}return _0xf281d6;};}function handleError(_0x5a1231,_0x4edf59){_0x4edf59=_0x4edf59||0x1f4;return function(_0x201128){logger[_0xb0e9('0x37')](_0x201128[_0xb0e9('0x38')]);if(_0x201128[_0xb0e9('0x35')]){delete _0x201128[_0xb0e9('0x35')];}_0x5a1231[_0xb0e9('0x1f')](_0x4edf59)['send'](_0x201128);};}exports[_0xb0e9('0x39')]=function(_0x2510c1,_0x37e033){var _0x186e71={},_0x3dd8b3={},_0x965d08={'count':0x0,'rows':[]};var _0x39e934=_[_0xb0e9('0x31')](db[_0xb0e9('0x3a')][_0xb0e9('0x3b')],function(_0x2bdec8){return{'name':_0x2bdec8['fieldName'],'type':_0x2bdec8[_0xb0e9('0x34')][_0xb0e9('0x3c')]};});_0x3dd8b3['model']=_[_0xb0e9('0x31')](_0x39e934,_0xb0e9('0x35'));_0x3dd8b3[_0xb0e9('0x3d')]=_['keys'](_0x2510c1[_0xb0e9('0x3d')]);_0x3dd8b3[_0xb0e9('0x3e')]=_[_0xb0e9('0x3f')](_0x3dd8b3[_0xb0e9('0x40')],_0x3dd8b3[_0xb0e9('0x3d')]);_0x186e71['attributes']=_['intersection'](_0x3dd8b3['model'],qs[_0xb0e9('0x41')](_0x2510c1[_0xb0e9('0x3d')][_0xb0e9('0x41')]));_0x186e71[_0xb0e9('0x42')]=_0x186e71[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x186e71['attributes']:_0x3dd8b3[_0xb0e9('0x40')];if(!_0x2510c1['query'][_0xb0e9('0x44')]('nolimit')){_0x186e71[_0xb0e9('0x25')]=qs[_0xb0e9('0x25')](_0x2510c1['query']['limit']);_0x186e71[_0xb0e9('0x22')]=qs['offset'](_0x2510c1[_0xb0e9('0x3d')][_0xb0e9('0x22')]);}_0x186e71[_0xb0e9('0x45')]=qs[_0xb0e9('0x46')](_0x2510c1[_0xb0e9('0x3d')][_0xb0e9('0x46')]);_0x186e71[_0xb0e9('0x47')]=qs['filters'](_['pick'](_0x2510c1['query'],_0x3dd8b3[_0xb0e9('0x3e')]),_0x39e934);if(_0x2510c1[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x186e71[_0xb0e9('0x47')]=_['merge'](_0x186e71[_0xb0e9('0x47')],{'$or':_[_0xb0e9('0x31')](_0x39e934,function(_0x54cc80){if(_0x54cc80[_0xb0e9('0x34')]!==_0xb0e9('0x48')){var _0x3d211b={};_0x3d211b[_0x54cc80[_0xb0e9('0x35')]]={'$like':'%'+_0x2510c1[_0xb0e9('0x3d')][_0xb0e9('0x30')]+'%'};return _0x3d211b;}})});}_0x186e71=_[_0xb0e9('0x49')]({},_0x186e71,_0x2510c1[_0xb0e9('0x4a')]);var _0x2e77f3={'where':_0x186e71[_0xb0e9('0x47')]};return db['VoiceQueue'][_0xb0e9('0x24')](_0x2e77f3)[_0xb0e9('0x29')](function(_0x2819cd){_0x965d08[_0xb0e9('0x24')]=_0x2819cd;if(_0x2510c1[_0xb0e9('0x3d')]['includeAll']){_0x186e71['include']=[{'all':!![]}];}return db[_0xb0e9('0x3a')]['findAll'](_0x186e71);})[_0xb0e9('0x29')](function(_0x1e9b76){_0x965d08['rows']=_0x1e9b76;return _0x965d08;})[_0xb0e9('0x29')](respondWithFilteredResult(_0x37e033,_0x186e71))[_0xb0e9('0x4b')](handleError(_0x37e033,null));};exports[_0xb0e9('0x4c')]=function(_0xb3779c,_0x2b91bd){var _0x4b3af2={'raw':![],'where':{'id':_0xb3779c[_0xb0e9('0x4d')]['id']}},_0x20d4a4={};_0x20d4a4['model']=_[_0xb0e9('0x4e')](db['VoiceQueue'][_0xb0e9('0x3b')]);_0x20d4a4[_0xb0e9('0x3d')]=_[_0xb0e9('0x4e')](_0xb3779c[_0xb0e9('0x3d')]);_0x20d4a4[_0xb0e9('0x3e')]=_['intersection'](_0x20d4a4['model'],_0x20d4a4[_0xb0e9('0x3d')]);_0x4b3af2[_0xb0e9('0x42')]=_[_0xb0e9('0x3f')](_0x20d4a4[_0xb0e9('0x40')],qs[_0xb0e9('0x41')](_0xb3779c[_0xb0e9('0x3d')][_0xb0e9('0x41')]));_0x4b3af2[_0xb0e9('0x42')]=_0x4b3af2[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x4b3af2[_0xb0e9('0x42')]:_0x20d4a4[_0xb0e9('0x40')];if(_0xb3779c[_0xb0e9('0x3d')][_0xb0e9('0x4f')]){_0x4b3af2[_0xb0e9('0x50')]=[{'all':!![]}];}_0x4b3af2=_[_0xb0e9('0x49')]({},_0x4b3af2,_0xb3779c['options']);return db[_0xb0e9('0x3a')][_0xb0e9('0x51')](_0x4b3af2)[_0xb0e9('0x29')](handleEntityNotFound(_0x2b91bd,null))[_0xb0e9('0x29')](respondWithResult(_0x2b91bd,null))[_0xb0e9('0x4b')](handleError(_0x2b91bd,null));};exports['create']=function(_0x3bb3de,_0x2e9d99){return db[_0xb0e9('0x3a')][_0xb0e9('0x52')](_0x3bb3de[_0xb0e9('0x53')],{})[_0xb0e9('0x29')](function(_0x2ba8e7){var _0x484ab3=_0x3bb3de[_0xb0e9('0x54')][_0xb0e9('0x2b')]({'plain':!![]});if(!_0x484ab3)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x484ab3[_0xb0e9('0x55')]===_0xb0e9('0x54')){var _0x1398f1=_0x2ba8e7[_0xb0e9('0x2b')]({'plain':!![]});var _0x121873=[{'name':_0xb0e9('0x2c'),'value':_0xb0e9('0x2d')},{'name':_0xb0e9('0x2e'),'value':_0xb0e9('0x2f')}];var _0x3842af=_['find'](_0x121873,[_0xb0e9('0x32'),_0x1398f1[_0xb0e9('0x34')]])[_0xb0e9('0x35')];return db['UserProfileSection']['find']({'where':{'name':_0x3842af,'userProfileId':_0x484ab3[_0xb0e9('0x56')]},'raw':!![]})[_0xb0e9('0x29')](function(_0x34aa36){if(_0x34aa36&&_0x34aa36[_0xb0e9('0x57')]===0x0){return db[_0xb0e9('0x36')]['create']({'name':_0x1398f1[_0xb0e9('0x35')],'resourceId':_0x1398f1['id'],'type':_0x34aa36['name'],'sectionId':_0x34aa36['id']},{})[_0xb0e9('0x29')](function(){return _0x2ba8e7;});}else{return _0x2ba8e7;}})[_0xb0e9('0x4b')](function(_0x4a8ccf){logger[_0xb0e9('0x37')](_0xb0e9('0x58'),_0x4a8ccf);throw _0x4a8ccf;});}return _0x2ba8e7;})[_0xb0e9('0x29')](respondWithResult(_0x2e9d99,0xc9))[_0xb0e9('0x4b')](handleError(_0x2e9d99,null));};exports[_0xb0e9('0x59')]=function(_0x1c5c2b,_0x1ced50){var _0x23b839={'where':{'id':_0x1c5c2b[_0xb0e9('0x4d')]['id']}},_0x198d66={};_0x198d66[_0xb0e9('0x40')]=_[_0xb0e9('0x4e')](db['VoiceQueue'][_0xb0e9('0x3b')]);_0x23b839[_0xb0e9('0x42')]=_[_0xb0e9('0x3f')](_0x198d66[_0xb0e9('0x40')],qs[_0xb0e9('0x41')](_0x1c5c2b[_0xb0e9('0x3d')][_0xb0e9('0x41')]));_0x23b839[_0xb0e9('0x42')]=_0x23b839[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x23b839[_0xb0e9('0x42')]:_0x198d66['model'];if(_0x1c5c2b[_0xb0e9('0x3d')][_0xb0e9('0x4f')]){_0x23b839[_0xb0e9('0x50')]=[{'all':!![]}];}_0x23b839=_[_0xb0e9('0x49')]({},_0x23b839,_0x1c5c2b['options']);return db['VoiceQueue'][_0xb0e9('0x51')](_0x23b839)[_0xb0e9('0x29')](handleEntityNotFound(_0x1ced50,null))['then'](function(_0x47eeb7){if(_0x47eeb7){var _0x3c0d02=_0x47eeb7[_0xb0e9('0x2b')]({'plain':!![]});_0x3c0d02=qs[_0xb0e9('0x5a')](_0x3c0d02,['id','createdAt',_0xb0e9('0x5b')]);_0x1c5c2b[_0xb0e9('0x53')]=_[_0xb0e9('0x5a')](_0x1c5c2b[_0xb0e9('0x53')],['id',_0xb0e9('0x5c'),_0xb0e9('0x5b')]);return db[_0xb0e9('0x3a')][_0xb0e9('0x52')](_[_0xb0e9('0x49')](_0x3c0d02,_0x1c5c2b[_0xb0e9('0x53')]),{'include':_0x1c5c2b[_0xb0e9('0x3d')]['includeAll']?[{'all':!![]}]:undefined})[_0xb0e9('0x29')](function(_0x4c476d){var _0x14bcb2=_0x1c5c2b[_0xb0e9('0x54')]['get']({'plain':!![]});if(!_0x14bcb2)throw new Error(_0xb0e9('0x5d'));if(_0x14bcb2[_0xb0e9('0x55')]===_0xb0e9('0x54')){var _0x306eb2=_0x4c476d[_0xb0e9('0x2b')]({'plain':!![]});var _0x5db9d1=[{'name':_0xb0e9('0x2c'),'value':'inbound'},{'name':_0xb0e9('0x2e'),'value':'outbound'}];var _0x54cdcf=_[_0xb0e9('0x51')](_0x5db9d1,[_0xb0e9('0x32'),_0x306eb2[_0xb0e9('0x34')]])[_0xb0e9('0x35')];return db[_0xb0e9('0x5e')][_0xb0e9('0x51')]({'where':{'name':_0x54cdcf,'userProfileId':_0x14bcb2[_0xb0e9('0x56')]},'raw':!![]})['then'](function(_0x3d0296){if(_0x3d0296&&_0x3d0296[_0xb0e9('0x57')]===0x0){return db[_0xb0e9('0x36')][_0xb0e9('0x52')]({'name':_0x306eb2[_0xb0e9('0x35')],'resourceId':_0x306eb2['id'],'type':_0x3d0296[_0xb0e9('0x35')],'sectionId':_0x3d0296['id']},{})[_0xb0e9('0x29')](function(){return _0x4c476d;});}else{return _0x4c476d;}})[_0xb0e9('0x4b')](function(_0x182b0e){logger[_0xb0e9('0x37')](_0xb0e9('0x58'),_0x182b0e);throw _0x182b0e;});}return _0x4c476d;});}})[_0xb0e9('0x29')](respondWithResult(_0x1ced50,0xc9))['catch'](handleError(_0x1ced50,null));};exports[_0xb0e9('0x28')]=function(_0x3e1ffd,_0x2712b1){if(_0x3e1ffd[_0xb0e9('0x53')]['id']){delete _0x3e1ffd[_0xb0e9('0x53')]['id'];}return db[_0xb0e9('0x3a')][_0xb0e9('0x51')]({'where':{'id':_0x3e1ffd[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0x2712b1,null))[_0xb0e9('0x29')](saveUpdates(_0x3e1ffd[_0xb0e9('0x53')],null))[_0xb0e9('0x29')](respondWithResult(_0x2712b1,null))['catch'](handleError(_0x2712b1,null));};exports[_0xb0e9('0x2a')]=function(_0x3b3fbc,_0x5855be){return db[_0xb0e9('0x3a')]['find']({'where':{'id':_0x3b3fbc[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0x5855be,null))['then'](removeEntity(_0x5855be,null))['catch'](handleError(_0x5855be,null));};exports[_0xb0e9('0x5f')]=function(_0x5b67ba,_0x1030c0,_0xf5bce4){var _0x5a7368={'raw':![],'where':{}};var _0x261374={};var _0x5cc487={'count':0x0,'rows':[]};return db[_0xb0e9('0x3a')]['findOne']({'where':{'id':_0x5b67ba[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0x1030c0,null))['then'](function(_0x459947){if(_0x459947){_0x261374[_0xb0e9('0x40')]=_[_0xb0e9('0x4e')](db['CmHopper'][_0xb0e9('0x3b')]);_0x261374['query']=_['keys'](_0x5b67ba['query']);_0x261374[_0xb0e9('0x3e')]=_[_0xb0e9('0x3f')](_0x261374['model'],_0x261374[_0xb0e9('0x3d')]);_0x5a7368[_0xb0e9('0x42')]=_[_0xb0e9('0x3f')](_0x261374[_0xb0e9('0x40')],qs['fields'](_0x5b67ba[_0xb0e9('0x3d')]['fields']));_0x5a7368[_0xb0e9('0x42')]=_0x5a7368[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x5a7368['attributes']:_0x261374[_0xb0e9('0x40')];if(!_0x5b67ba[_0xb0e9('0x3d')]['hasOwnProperty'](_0xb0e9('0x60'))){_0x5a7368['limit']=qs['limit'](_0x5b67ba[_0xb0e9('0x3d')][_0xb0e9('0x25')]);_0x5a7368['offset']=qs['offset'](_0x5b67ba['query'][_0xb0e9('0x22')]);}_0x5a7368[_0xb0e9('0x45')]=qs[_0xb0e9('0x46')](_0x5b67ba[_0xb0e9('0x3d')][_0xb0e9('0x46')]);_0x5a7368[_0xb0e9('0x47')]=qs[_0xb0e9('0x3e')](_[_0xb0e9('0x61')](_0x5b67ba[_0xb0e9('0x3d')],_0x261374[_0xb0e9('0x3e')]));_0x5a7368[_0xb0e9('0x47')][_0xb0e9('0x62')]=_0x459947['id'];if(_0x5b67ba[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x5a7368[_0xb0e9('0x47')]=_[_0xb0e9('0x49')](_0x5a7368[_0xb0e9('0x47')],{'$or':_[_0xb0e9('0x31')](_0x5a7368[_0xb0e9('0x42')],function(_0x419485){var _0x77272d={};_0x77272d[_0x419485]={'$like':'%'+_0x5b67ba[_0xb0e9('0x3d')][_0xb0e9('0x30')]+'%'};return _0x77272d;})});}_0x5a7368=_[_0xb0e9('0x49')]({},_0x5a7368,_0x5b67ba[_0xb0e9('0x4a')]);return db[_0xb0e9('0x63')]['count']({'where':_0x5a7368[_0xb0e9('0x47')]})[_0xb0e9('0x29')](function(_0x13114d){_0x5cc487[_0xb0e9('0x24')]=_0x13114d;if(_0x5b67ba[_0xb0e9('0x3d')][_0xb0e9('0x4f')]){_0x5a7368['include']=[{'all':!![]}];}return db['CmHopper'][_0xb0e9('0x64')](_0x5a7368);})[_0xb0e9('0x29')](function(_0x74b29a){_0x5cc487[_0xb0e9('0x65')]=_0x74b29a;return _0x5cc487;});}})[_0xb0e9('0x29')](respondWithFilteredResult(_0x1030c0,_0x5a7368))['catch'](handleError(_0x1030c0,null));};exports[_0xb0e9('0x66')]=function(_0x290eab,_0xa2c67e,_0x5b86f7){var _0x5a68b7={'raw':!![],'where':{}};var _0x21bdbb={};var _0x265a8c={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xb0e9('0x67')]({'where':{'id':_0x290eab[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0xa2c67e,null))[_0xb0e9('0x29')](function(_0x3e3038){if(_0x3e3038){_0x21bdbb[_0xb0e9('0x40')]=_[_0xb0e9('0x4e')](db[_0xb0e9('0x68')][_0xb0e9('0x3b')]);_0x21bdbb[_0xb0e9('0x3d')]=_[_0xb0e9('0x4e')](_0x290eab[_0xb0e9('0x3d')]);_0x21bdbb[_0xb0e9('0x3e')]=_[_0xb0e9('0x3f')](_0x21bdbb[_0xb0e9('0x40')],_0x21bdbb[_0xb0e9('0x3d')]);_0x5a68b7['attributes']=_[_0xb0e9('0x3f')](_0x21bdbb['model'],qs[_0xb0e9('0x41')](_0x290eab['query'][_0xb0e9('0x41')]));_0x5a68b7[_0xb0e9('0x42')]=_0x5a68b7[_0xb0e9('0x42')]['length']?_0x5a68b7['attributes']:_0x21bdbb['model'];if(!_0x290eab[_0xb0e9('0x3d')][_0xb0e9('0x44')]('nolimit')){_0x5a68b7[_0xb0e9('0x25')]=qs[_0xb0e9('0x25')](_0x290eab['query'][_0xb0e9('0x25')]);_0x5a68b7[_0xb0e9('0x22')]=qs[_0xb0e9('0x22')](_0x290eab['query']['offset']);}_0x5a68b7['order']=qs[_0xb0e9('0x46')](_0x290eab[_0xb0e9('0x3d')][_0xb0e9('0x46')]);_0x5a68b7[_0xb0e9('0x47')]=qs['filters'](_['pick'](_0x290eab[_0xb0e9('0x3d')],_0x21bdbb[_0xb0e9('0x3e')]));_0x5a68b7[_0xb0e9('0x47')][_0xb0e9('0x62')]=_0x3e3038['id'];if(_0x290eab[_0xb0e9('0x3d')]['filter']){_0x5a68b7[_0xb0e9('0x47')]=_['merge'](_0x5a68b7[_0xb0e9('0x47')],{'$or':_[_0xb0e9('0x31')](_0x5a68b7[_0xb0e9('0x42')],function(_0x3bf6a5){var _0x5c860e={};_0x5c860e[_0x3bf6a5]={'$like':'%'+_0x290eab[_0xb0e9('0x3d')][_0xb0e9('0x30')]+'%'};return _0x5c860e;})});}_0x5a68b7=_[_0xb0e9('0x49')]({},_0x5a68b7,_0x290eab[_0xb0e9('0x4a')]);return db['CmHopperHistory']['count']({'where':_0x5a68b7['where']})[_0xb0e9('0x29')](function(_0xf0b8ff){_0x265a8c[_0xb0e9('0x24')]=_0xf0b8ff;if(_0x290eab['query'][_0xb0e9('0x4f')]){_0x5a68b7[_0xb0e9('0x50')]=[{'all':!![]}];}return db[_0xb0e9('0x68')]['findAll'](_0x5a68b7);})[_0xb0e9('0x29')](function(_0xfd45d){_0x265a8c[_0xb0e9('0x65')]=_0xfd45d;return _0x265a8c;});}})[_0xb0e9('0x29')](respondWithFilteredResult(_0xa2c67e,_0x5a68b7))[_0xb0e9('0x4b')](handleError(_0xa2c67e,null));};exports[_0xb0e9('0x69')]=function(_0x42d3e8,_0x5ca2e7,_0x35f105){var _0x1a7a20={'raw':!![],'where':{}};var _0x5c075f={};var _0x1be8e4={'count':0x0,'rows':[]};return db[_0xb0e9('0x3a')][_0xb0e9('0x67')]({'where':{'id':_0x42d3e8[_0xb0e9('0x4d')]['id']}})['then'](handleEntityNotFound(_0x5ca2e7,null))[_0xb0e9('0x29')](function(_0x4f7dd1){if(_0x4f7dd1){_0x5c075f[_0xb0e9('0x40')]=_[_0xb0e9('0x4e')](db[_0xb0e9('0x6a')][_0xb0e9('0x3b')]);_0x5c075f[_0xb0e9('0x3d')]=_[_0xb0e9('0x4e')](_0x42d3e8[_0xb0e9('0x3d')]);_0x5c075f['filters']=_[_0xb0e9('0x3f')](_0x5c075f['model'],_0x5c075f[_0xb0e9('0x3d')]);_0x1a7a20[_0xb0e9('0x42')]=_[_0xb0e9('0x3f')](_0x5c075f['model'],qs[_0xb0e9('0x41')](_0x42d3e8[_0xb0e9('0x3d')][_0xb0e9('0x41')]));_0x1a7a20['attributes']=_0x1a7a20[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x1a7a20[_0xb0e9('0x42')]:_0x5c075f[_0xb0e9('0x40')];if(!_0x42d3e8[_0xb0e9('0x3d')][_0xb0e9('0x44')](_0xb0e9('0x60'))){_0x1a7a20[_0xb0e9('0x25')]=qs[_0xb0e9('0x25')](_0x42d3e8[_0xb0e9('0x3d')]['limit']);_0x1a7a20[_0xb0e9('0x22')]=qs[_0xb0e9('0x22')](_0x42d3e8[_0xb0e9('0x3d')]['offset']);}_0x1a7a20[_0xb0e9('0x45')]=qs['sort'](_0x42d3e8[_0xb0e9('0x3d')][_0xb0e9('0x46')]);_0x1a7a20[_0xb0e9('0x47')]=qs[_0xb0e9('0x3e')](_[_0xb0e9('0x61')](_0x42d3e8[_0xb0e9('0x3d')],_0x5c075f[_0xb0e9('0x3e')]));_0x1a7a20['where']['VoiceQueueId']=_0x4f7dd1['id'];if(_0x42d3e8[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x1a7a20[_0xb0e9('0x47')]=_['merge'](_0x1a7a20[_0xb0e9('0x47')],{'$or':_[_0xb0e9('0x31')](_0x1a7a20[_0xb0e9('0x42')],function(_0x42fa14){var _0x3c4c72={};_0x3c4c72[_0x42fa14]={'$like':'%'+_0x42d3e8['query']['filter']+'%'};return _0x3c4c72;})});}_0x1a7a20=_[_0xb0e9('0x49')]({},_0x1a7a20,_0x42d3e8[_0xb0e9('0x4a')]);return db['CmHopperFinal']['count']({'where':_0x1a7a20[_0xb0e9('0x47')]})[_0xb0e9('0x29')](function(_0x18f98b){_0x1be8e4[_0xb0e9('0x24')]=_0x18f98b;if(_0x42d3e8[_0xb0e9('0x3d')][_0xb0e9('0x4f')]){_0x1a7a20['include']=[{'all':!![]}];}return db[_0xb0e9('0x6a')][_0xb0e9('0x64')](_0x1a7a20);})[_0xb0e9('0x29')](function(_0x5c0068){_0x1be8e4[_0xb0e9('0x65')]=_0x5c0068;return _0x1be8e4;});}})[_0xb0e9('0x29')](respondWithFilteredResult(_0x5ca2e7,_0x1a7a20))[_0xb0e9('0x4b')](handleError(_0x5ca2e7,null));};exports[_0xb0e9('0x6b')]=function(_0x2b2a16,_0x47b266,_0x101608){var _0x34b532={'raw':!![],'where':{}};var _0x38ecd4={};var _0x26b8d4={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xb0e9('0x67')]({'where':{'id':_0x2b2a16[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0x47b266,null))['then'](function(_0x14d815){if(_0x14d815){_0x38ecd4[_0xb0e9('0x40')]=_['keys'](db[_0xb0e9('0x6c')]['rawAttributes']);_0x38ecd4[_0xb0e9('0x3d')]=_[_0xb0e9('0x4e')](_0x2b2a16['query']);_0x38ecd4[_0xb0e9('0x3e')]=_['intersection'](_0x38ecd4[_0xb0e9('0x40')],_0x38ecd4[_0xb0e9('0x3d')]);_0x34b532['attributes']=_[_0xb0e9('0x3f')](_0x38ecd4[_0xb0e9('0x40')],qs[_0xb0e9('0x41')](_0x2b2a16[_0xb0e9('0x3d')]['fields']));_0x34b532[_0xb0e9('0x42')]=_0x34b532[_0xb0e9('0x42')]['length']?_0x34b532[_0xb0e9('0x42')]:_0x38ecd4['model'];if(!_0x2b2a16[_0xb0e9('0x3d')][_0xb0e9('0x44')]('nolimit')){_0x34b532[_0xb0e9('0x25')]=qs[_0xb0e9('0x25')](_0x2b2a16[_0xb0e9('0x3d')][_0xb0e9('0x25')]);_0x34b532[_0xb0e9('0x22')]=qs[_0xb0e9('0x22')](_0x2b2a16[_0xb0e9('0x3d')]['offset']);}_0x34b532[_0xb0e9('0x45')]=qs['sort'](_0x2b2a16[_0xb0e9('0x3d')][_0xb0e9('0x46')]);_0x34b532['where']=qs[_0xb0e9('0x3e')](_[_0xb0e9('0x61')](_0x2b2a16[_0xb0e9('0x3d')],_0x38ecd4[_0xb0e9('0x3e')]));_0x34b532['where'][_0xb0e9('0x62')]=_0x14d815['id'];if(_0x2b2a16[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x34b532['where']=_[_0xb0e9('0x49')](_0x34b532[_0xb0e9('0x47')],{'$or':_['map'](_0x34b532[_0xb0e9('0x42')],function(_0x5cc689){var _0x56bf7d={};_0x56bf7d[_0x5cc689]={'$like':'%'+_0x2b2a16[_0xb0e9('0x3d')][_0xb0e9('0x30')]+'%'};return _0x56bf7d;})});}_0x34b532=_['merge']({},_0x34b532,_0x2b2a16[_0xb0e9('0x4a')]);return db['CmHopperBlack'][_0xb0e9('0x24')]({'where':_0x34b532[_0xb0e9('0x47')]})[_0xb0e9('0x29')](function(_0x25cf13){_0x26b8d4[_0xb0e9('0x24')]=_0x25cf13;if(_0x2b2a16[_0xb0e9('0x3d')][_0xb0e9('0x4f')]){_0x34b532[_0xb0e9('0x50')]=[{'all':!![]}];}return db['CmHopperBlack'][_0xb0e9('0x64')](_0x34b532);})[_0xb0e9('0x29')](function(_0x2fea86){_0x26b8d4[_0xb0e9('0x65')]=_0x2fea86;return _0x26b8d4;});}})['then'](respondWithFilteredResult(_0x47b266,_0x34b532))[_0xb0e9('0x4b')](handleError(_0x47b266,null));};exports[_0xb0e9('0x6d')]=function(_0x442543,_0x40e800,_0x5d215f){var _0x3a8400={};var _0x1d1bd5={};var _0x297a34;var _0x214127;return db['VoiceQueue']['findOne']({'where':{'id':_0x442543[_0xb0e9('0x4d')]['id']}})['then'](handleEntityNotFound(_0x40e800,null))['then'](function(_0x52c7ef){if(_0x52c7ef){_0x297a34=_0x52c7ef;_0x1d1bd5[_0xb0e9('0x40')]=_['keys'](db['Team'][_0xb0e9('0x3b')]);_0x1d1bd5[_0xb0e9('0x3d')]=_[_0xb0e9('0x4e')](_0x442543[_0xb0e9('0x3d')]);_0x1d1bd5[_0xb0e9('0x3e')]=_[_0xb0e9('0x3f')](_0x1d1bd5['model'],_0x1d1bd5['query']);_0x3a8400['attributes']=_['intersection'](_0x1d1bd5[_0xb0e9('0x40')],qs['fields'](_0x442543[_0xb0e9('0x3d')][_0xb0e9('0x41')]));_0x3a8400[_0xb0e9('0x42')]=_0x3a8400[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x3a8400[_0xb0e9('0x42')]:_0x1d1bd5[_0xb0e9('0x40')];_0x3a8400[_0xb0e9('0x45')]=qs[_0xb0e9('0x46')](_0x442543[_0xb0e9('0x3d')][_0xb0e9('0x46')]);_0x3a8400['where']=qs[_0xb0e9('0x3e')](_[_0xb0e9('0x61')](_0x442543[_0xb0e9('0x3d')],_0x1d1bd5['filters']));if(_0x442543[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x3a8400[_0xb0e9('0x47')]=_[_0xb0e9('0x49')](_0x3a8400[_0xb0e9('0x47')],{'$or':_['map'](_0x3a8400['attributes'],function(_0x29c425){var _0x27d1b7={};_0x27d1b7[_0x29c425]={'$like':'%'+_0x442543[_0xb0e9('0x3d')][_0xb0e9('0x30')]+'%'};return _0x27d1b7;})});}_0x3a8400=_[_0xb0e9('0x49')]({},_0x3a8400,_0x442543['options']);return _0x297a34['getTeams'](_0x3a8400);}})[_0xb0e9('0x29')](function(_0x5a6629){if(_0x5a6629){_0x214127=_0x5a6629['length'];if(!_0x442543['query'][_0xb0e9('0x44')]('nolimit')){_0x3a8400[_0xb0e9('0x25')]=qs[_0xb0e9('0x25')](_0x442543[_0xb0e9('0x3d')][_0xb0e9('0x25')]);_0x3a8400[_0xb0e9('0x22')]=qs['offset'](_0x442543[_0xb0e9('0x3d')][_0xb0e9('0x22')]);}return _0x297a34['getTeams'](_0x3a8400);}})[_0xb0e9('0x29')](function(_0x56e43b){if(_0x56e43b){return _0x56e43b?{'count':_0x214127,'rows':_0x56e43b}:null;}})[_0xb0e9('0x29')](respondWithResult(_0x40e800,null))[_0xb0e9('0x4b')](handleError(_0x40e800,null));};exports[_0xb0e9('0x6e')]=function(_0xfcfe5d,_0x4b479d,_0x3e52a8){var _0x3e5dab=_0xfcfe5d['body']['teams'];var _0x5cc7cd=_[_0xb0e9('0x31')](_0x3e5dab,'id');return db[_0xb0e9('0x6f')][_0xb0e9('0x64')]({'where':{'id':_0x5cc7cd},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id','name','online',_0xb0e9('0x70'),_0xb0e9('0x71')],'raw':!![]}]})[_0xb0e9('0x29')](function(_0x4315bd){if(_0x4315bd){var _0x482c34=_[_0xb0e9('0x72')](_0x4315bd,function(_0x49f740){var _0xbc36cc=_0x49f740['get']({'plain':!![]});_0xbc36cc[_0xb0e9('0x73')][_0xb0e9('0x74')](function(_0x49e999){_0x49e999[_0xb0e9('0x75')]=_[_0xb0e9('0x51')](_0x3e5dab,{'id':_0xbc36cc['id']})[_0xb0e9('0x75')];});return _0xbc36cc[_0xb0e9('0x73')];});return db[_0xb0e9('0x3a')][_0xb0e9('0x51')]({'where':{'id':_0xfcfe5d[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](function(_0x2f209c){return db[_0xb0e9('0x76')][_0xb0e9('0x77')](function(_0x386e92){return _0x2f209c[_0xb0e9('0x6e')](_0x5cc7cd,{'transaction':_0x386e92})[_0xb0e9('0x29')](function(){return BPromise[_0xb0e9('0x78')](_0x3e5dab,function(_0x8ee83d){return db['TeamVoiceQueue'][_0xb0e9('0x79')]({'TeamId':_0x8ee83d['id'],'VoiceQueueId':_0xfcfe5d[_0xb0e9('0x4d')]['id'],'penalty':_0x8ee83d[_0xb0e9('0x75')]},{'transaction':_0x386e92});});})[_0xb0e9('0x29')](function(){return BPromise[_0xb0e9('0x78')](_0x482c34,function(_0x119e8a){return db[_0xb0e9('0x7a')][_0xb0e9('0x7b')]({'where':{'UserId':_0x119e8a['id'],'VoiceQueueId':_0xfcfe5d['params']['id']},'defaults':{'penalty':_0x119e8a['penalty']},'transaction':_0x386e92});});})[_0xb0e9('0x29')](function(){return BPromise[_0xb0e9('0x78')](_['filter'](_0x482c34,{'online':!![]}),function(_0x9244cc){return db[_0xb0e9('0x7c')][_0xb0e9('0x79')]({'membername':_0x9244cc[_0xb0e9('0x35')],'UserId':_0x9244cc['id'],'queue_name':_0x2f209c[_0xb0e9('0x35')],'VoiceQueueId':_0x2f209c['id'],'interface':_[_0xb0e9('0x7d')](_0x9244cc['interface'])?util['format'](_0xb0e9('0x7e'),_0x9244cc[_0xb0e9('0x35')]):_0x9244cc['interface'],'paused':_0x9244cc['voicePause']||![],'penalty':_0x9244cc[_0xb0e9('0x75')]},{'transaction':_0x386e92});});})[_0xb0e9('0x29')](function(){_0x482c34[_0xb0e9('0x74')](function(_0x56580d){socket[_0xb0e9('0x7f')](_0xb0e9('0x80'),{'UserId':_0x56580d['id'],'VoiceQueueId':_0x2f209c['id']});});});});});}})[_0xb0e9('0x29')](respondWithStatusCode(_0x4b479d,null))['catch'](handleError(_0x4b479d,null));};exports['removeTeams']=function(_0xaac117,_0x4617ff,_0xa2c78e){return db[_0xb0e9('0x6f')][_0xb0e9('0x64')]({'where':{'id':_0xaac117[_0xb0e9('0x3d')][_0xb0e9('0x81')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0xb0e9('0x73'),'attributes':['id'],'raw':!![]}]})[_0xb0e9('0x29')](handleEntityNotFound(_0x4617ff,null))[_0xb0e9('0x29')](function(_0x9ee37){var _0x588e8f=_[_0xb0e9('0x31')](_0x9ee37,'id');var _0x5ed4d5=[];var _0x4379a7=[];var _0xde6e43=squel[_0xb0e9('0x82')]();_0xde6e43[_0xb0e9('0x83')](_0xb0e9('0x84'))[_0xb0e9('0x85')](_0xb0e9('0x86'),'tq')['join']('user_has_teams','ut',_0xb0e9('0x87'))[_0xb0e9('0x47')](_0xb0e9('0x88'),_0xaac117[_0xb0e9('0x4d')]['id']);for(var _0x2eb49a=0x0;_0x2eb49a<_0x9ee37[_0xb0e9('0x43')];_0x2eb49a+=0x1){let _0x3b4ccc=_0x9ee37[_0x2eb49a];for(var _0x2bb99d=0x0;_0x2bb99d<_0x3b4ccc['Agents'][_0xb0e9('0x43')];_0x2bb99d+=0x1){let _0x257650=_0x3b4ccc[_0xb0e9('0x73')][_0x2bb99d];var _0x40860b=_0xde6e43['clone']();_0x40860b['where'](_0xb0e9('0x89'),_0x257650['id']);_0x4379a7[_0xb0e9('0x8a')](db[_0xb0e9('0x76')][_0xb0e9('0x3d')](_0x40860b[_0xb0e9('0x8b')](),{'type':db[_0xb0e9('0x76')][_0xb0e9('0x8c')][_0xb0e9('0x8d')]})[_0xb0e9('0x29')](function(_0x121049){if(_0x121049[_0xb0e9('0x43')]===0x1){return _0x257650['id'];}else{var _0x2ee2c3=_[_0xb0e9('0x8e')](_[_0xb0e9('0x31')](_0x121049,_0xb0e9('0x8f')),function(_0x35ab73){return _[_0xb0e9('0x33')](_0x588e8f,_0x35ab73);});if(_0x2ee2c3){return _0x257650['id'];}}}));}}return BPromise[_0xb0e9('0x90')](_0x4379a7)['then'](function(_0xd9b620){_0x5ed4d5=_(_0x5ed4d5)[_0xb0e9('0x91')](_0xd9b620)['compact']()[_0xb0e9('0x32')]();return db['VoiceQueue'][_0xb0e9('0x51')]({'where':{'id':_0xaac117[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](function(_0x21a966){return db[_0xb0e9('0x76')][_0xb0e9('0x77')](function(_0x3bd9d2){return _0x21a966[_0xb0e9('0x92')](_0xaac117[_0xb0e9('0x3d')][_0xb0e9('0x81')],{'transaction':_0x3bd9d2})['then'](function(){if(!_[_0xb0e9('0x93')](_0x5ed4d5)){return _0x21a966[_0xb0e9('0x94')](_0x5ed4d5,{'transaction':_0x3bd9d2})[_0xb0e9('0x29')](function(){return db[_0xb0e9('0x7c')]['destroy']({'where':{'VoiceQueueId':_0xaac117[_0xb0e9('0x4d')]['id'],'UserId':_0x5ed4d5},'transaction':_0x3bd9d2});});}})['then'](function(){_0x5ed4d5[_0xb0e9('0x74')](function(_0x2e21aa){socket[_0xb0e9('0x7f')](_0xb0e9('0x95'),{'UserId':_0x2e21aa,'VoiceQueueId':_0x21a966['id']});});});});});});})['then'](respondWithStatusCode(_0x4617ff,null))[_0xb0e9('0x4b')](handleError(_0x4617ff,null));};exports['addAgents']=function(_0xe21957,_0x1a9dab,_0x590a83){var _0x2709c6,_0x14438b;return db[_0xb0e9('0x3a')][_0xb0e9('0x51')]({'where':{'id':_0xe21957['params']['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0x1a9dab,null))[_0xb0e9('0x29')](function(_0xa8e90e){if(_0xa8e90e){_0x14438b=_0xa8e90e;return _0xa8e90e[_0xb0e9('0x96')](_0xe21957[_0xb0e9('0x53')][_0xb0e9('0x81')],_[_0xb0e9('0x5a')](_0xe21957[_0xb0e9('0x53')],['ids','id'])||{})[_0xb0e9('0x97')](function(_0x49385a){for(var _0x65aa74=0x0;_0x65aa74<_0xe21957[_0xb0e9('0x53')][_0xb0e9('0x81')]['length'];_0x65aa74+=0x1){socket[_0xb0e9('0x7f')](_0xb0e9('0x80'),{'UserId':Number(_0xe21957[_0xb0e9('0x53')][_0xb0e9('0x81')][_0x65aa74]),'VoiceQueueId':Number(_0xe21957['params']['id'])});}return _0x49385a;});}})[_0xb0e9('0x29')](function(_0x4845a4){_0x2709c6=_0x4845a4||[];if(_0x14438b){return db[_0xb0e9('0x98')][_0xb0e9('0x64')]({'where':{'id':_0xe21957['body'][_0xb0e9('0x81')]},'attributes':['id','name',_0xb0e9('0x99'),_0xb0e9('0x70'),_0xb0e9('0x71')],'raw':!![]});}})['then'](function(_0x1c8b7d){if(!_[_0xb0e9('0x93')](_0x1c8b7d)){var _0x412943=[];for(var _0x2d2e60=0x0;_0x2d2e60<_0x1c8b7d[_0xb0e9('0x43')];_0x2d2e60++){if(_0x1c8b7d[_0x2d2e60][_0xb0e9('0x99')]){_0x412943['push'](db[_0xb0e9('0x7c')][_0xb0e9('0x79')]({'membername':_0x1c8b7d[_0x2d2e60][_0xb0e9('0x35')],'UserId':_0x1c8b7d[_0x2d2e60]['id'],'queue_name':_0x14438b[_0xb0e9('0x35')],'VoiceQueueId':_0x14438b['id'],'interface':_[_0xb0e9('0x7d')](_0x1c8b7d[_0x2d2e60][_0xb0e9('0x71')])?util[_0xb0e9('0x9a')]('SIP/%s',_0x1c8b7d[_0x2d2e60][_0xb0e9('0x35')]):_0x1c8b7d[_0x2d2e60]['interface'],'paused':_0x1c8b7d[_0x2d2e60][_0xb0e9('0x70')]||![],'penalty':_0xe21957[_0xb0e9('0x53')][_0xb0e9('0x75')]||0x0}));}}return BPromise[_0xb0e9('0x90')](_0x412943);}})['then'](function(){return _0x2709c6;})[_0xb0e9('0x29')](respondWithResult(_0x1a9dab,null))[_0xb0e9('0x4b')](handleError(_0x1a9dab,null));};exports['removeAgents']=function(_0x1561c7,_0xd7435d,_0x15b5c5){return db[_0xb0e9('0x3a')]['find']({'where':{'id':_0x1561c7[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0xd7435d,null))['then'](function(_0x39c750){if(_0x39c750){return _0x39c750[_0xb0e9('0x94')](_0x1561c7[_0xb0e9('0x3d')]['ids'])[_0xb0e9('0x29')](function(){if(_['isArray'](_0x1561c7[_0xb0e9('0x3d')][_0xb0e9('0x81')])){for(var _0x4dc3f7=0x0;_0x4dc3f7<_0x1561c7[_0xb0e9('0x3d')][_0xb0e9('0x81')]['length'];_0x4dc3f7+=0x1){socket[_0xb0e9('0x7f')](_0xb0e9('0x95'),{'UserId':Number(_0x1561c7[_0xb0e9('0x3d')][_0xb0e9('0x81')][_0x4dc3f7]),'VoiceQueueId':Number(_0x1561c7[_0xb0e9('0x4d')]['id'])});}}else{socket[_0xb0e9('0x7f')](_0xb0e9('0x95'),{'UserId':Number(_0x1561c7['query']['ids']),'VoiceQueueId':Number(_0x1561c7[_0xb0e9('0x4d')]['id'])});}});}})[_0xb0e9('0x29')](function(_0x59c6d8){return db[_0xb0e9('0x7c')]['destroy']({'where':{'VoiceQueueId':_0x1561c7['params']['id'],'UserId':_0x1561c7[_0xb0e9('0x3d')][_0xb0e9('0x81')]}})['then'](function(){return _0x59c6d8;});})[_0xb0e9('0x29')](respondWithStatusCode(_0xd7435d,null))['catch'](handleError(_0xd7435d,null));};exports[_0xb0e9('0x9b')]=function(_0x9811b,_0x20539a,_0x33455b){var _0x227810={};var _0x13ee97={};var _0x2978c4;var _0x31266c;return db['VoiceQueue']['findOne']({'where':{'id':_0x9811b[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0x20539a,null))['then'](function(_0xdbe506){if(_0xdbe506){_0x2978c4=_0xdbe506;_0x13ee97[_0xb0e9('0x40')]=_[_0xb0e9('0x4e')](db[_0xb0e9('0x98')]['rawAttributes']);_0x13ee97['query']=_[_0xb0e9('0x4e')](_0x9811b[_0xb0e9('0x3d')]);_0x13ee97['filters']=_[_0xb0e9('0x3f')](_0x13ee97[_0xb0e9('0x40')],_0x13ee97[_0xb0e9('0x3d')]);_0x227810['attributes']=_[_0xb0e9('0x3f')](_0x13ee97[_0xb0e9('0x40')],qs[_0xb0e9('0x41')](_0x9811b[_0xb0e9('0x3d')]['fields']));_0x227810['attributes']=_0x227810[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x227810[_0xb0e9('0x42')]:_0x13ee97[_0xb0e9('0x40')];_0x227810[_0xb0e9('0x45')]=qs['sort'](_0x9811b[_0xb0e9('0x3d')][_0xb0e9('0x46')]);_0x227810['where']=qs[_0xb0e9('0x3e')](_[_0xb0e9('0x61')](_0x9811b[_0xb0e9('0x3d')],_0x13ee97[_0xb0e9('0x3e')]));if(_0x9811b[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x227810[_0xb0e9('0x47')]=_[_0xb0e9('0x49')](_0x227810[_0xb0e9('0x47')],{'$or':_[_0xb0e9('0x31')](_0x227810[_0xb0e9('0x42')],function(_0x460886){var _0x4db17f={};_0x4db17f[_0x460886]={'$like':'%'+_0x9811b[_0xb0e9('0x3d')][_0xb0e9('0x30')]+'%'};return _0x4db17f;})});}_0x227810=_[_0xb0e9('0x49')]({},_0x227810,_0x9811b[_0xb0e9('0x4a')]);return _0x2978c4['getAgents'](_0x227810);}})['then'](function(_0x3983ff){if(_0x3983ff){_0x31266c=_0x3983ff['length'];if(!_0x9811b['query'][_0xb0e9('0x44')](_0xb0e9('0x60'))){_0x227810[_0xb0e9('0x25')]=qs[_0xb0e9('0x25')](_0x9811b[_0xb0e9('0x3d')][_0xb0e9('0x25')]);_0x227810[_0xb0e9('0x22')]=qs['offset'](_0x9811b[_0xb0e9('0x3d')]['offset']);}return _0x2978c4['getAgents'](_0x227810);}})['then'](function(_0x4cee91){if(_0x4cee91){return _0x4cee91?{'count':_0x31266c,'rows':_0x4cee91}:null;}})[_0xb0e9('0x29')](respondWithResult(_0x20539a,null))[_0xb0e9('0x4b')](handleError(_0x20539a,null));};exports['getMembers']=function(_0x4cc164,_0xd35758,_0x4076d2){var _0x13e45b={};var _0x517b98={};var _0xf8520a;var _0x3f4132;return db[_0xb0e9('0x3a')]['findOne']({'where':{'id':_0x4cc164[_0xb0e9('0x4d')]['id']}})['then'](handleEntityNotFound(_0xd35758,null))['then'](function(_0x525226){if(_0x525226){_0xf8520a=_0x525226;_0x517b98[_0xb0e9('0x40')]=_['keys'](db[_0xb0e9('0x7c')][_0xb0e9('0x3b')]);_0x517b98[_0xb0e9('0x3d')]=_['keys'](_0x4cc164[_0xb0e9('0x3d')]);_0x517b98[_0xb0e9('0x3e')]=_[_0xb0e9('0x3f')](_0x517b98[_0xb0e9('0x40')],_0x517b98[_0xb0e9('0x3d')]);_0x13e45b['attributes']=_[_0xb0e9('0x3f')](_0x517b98['model'],qs[_0xb0e9('0x41')](_0x4cc164[_0xb0e9('0x3d')][_0xb0e9('0x41')]));_0x13e45b['attributes']=_0x13e45b[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x13e45b['attributes']:_0x517b98[_0xb0e9('0x40')];_0x13e45b[_0xb0e9('0x45')]=qs['sort'](_0x4cc164[_0xb0e9('0x3d')][_0xb0e9('0x46')]);_0x13e45b[_0xb0e9('0x47')]=qs['filters'](_[_0xb0e9('0x61')](_0x4cc164[_0xb0e9('0x3d')],_0x517b98[_0xb0e9('0x3e')]));if(_0x4cc164[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x13e45b['where']=_[_0xb0e9('0x49')](_0x13e45b[_0xb0e9('0x47')],{'$or':_['map'](_0x13e45b[_0xb0e9('0x42')],function(_0x424c67){var _0x310857={};_0x310857[_0x424c67]={'$like':'%'+_0x4cc164[_0xb0e9('0x3d')][_0xb0e9('0x30')]+'%'};return _0x310857;})});}_0x13e45b=_['merge']({},_0x13e45b,_0x4cc164[_0xb0e9('0x4a')]);return _0xf8520a['getMembers'](_0x13e45b);}})['then'](function(_0x36d14b){if(_0x36d14b){_0x3f4132=_0x36d14b[_0xb0e9('0x43')];if(!_0x4cc164[_0xb0e9('0x3d')]['hasOwnProperty'](_0xb0e9('0x60'))){_0x13e45b['limit']=qs['limit'](_0x4cc164[_0xb0e9('0x3d')][_0xb0e9('0x25')]);_0x13e45b[_0xb0e9('0x22')]=qs[_0xb0e9('0x22')](_0x4cc164[_0xb0e9('0x3d')]['offset']);}return _0xf8520a[_0xb0e9('0x9c')](_0x13e45b);}})[_0xb0e9('0x29')](function(_0x51b71a){return _0x51b71a?{'count':_0x3f4132,'rows':_0x51b71a}:null;})[_0xb0e9('0x29')](respondWithResult(_0xd35758,null))[_0xb0e9('0x4b')](handleError(_0xd35758,null));};exports[_0xb0e9('0x9d')]=function(_0x48144a,_0x32a0c0,_0x3b84f9){var _0x5b26e9={};var _0x3613f3={};var _0x14e390;var _0xf46ec3;return db[_0xb0e9('0x3a')][_0xb0e9('0x67')]({'where':{'id':_0x48144a[_0xb0e9('0x4d')]['id']}})['then'](handleEntityNotFound(_0x32a0c0,null))['then'](function(_0x3f8bc8){if(_0x3f8bc8){_0x14e390=_0x3f8bc8;_0x3613f3[_0xb0e9('0x40')]=_[_0xb0e9('0x4e')](db['CmList'][_0xb0e9('0x3b')]);_0x3613f3[_0xb0e9('0x3d')]=_[_0xb0e9('0x4e')](_0x48144a[_0xb0e9('0x3d')]);_0x3613f3[_0xb0e9('0x3e')]=_[_0xb0e9('0x3f')](_0x3613f3[_0xb0e9('0x40')],_0x3613f3[_0xb0e9('0x3d')]);_0x5b26e9['attributes']=_['intersection'](_0x3613f3[_0xb0e9('0x40')],qs[_0xb0e9('0x41')](_0x48144a[_0xb0e9('0x3d')]['fields']));_0x5b26e9[_0xb0e9('0x42')]=_0x5b26e9[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x5b26e9[_0xb0e9('0x42')]:_0x3613f3['model'];_0x5b26e9['order']=qs[_0xb0e9('0x46')](_0x48144a['query'][_0xb0e9('0x46')]);_0x5b26e9[_0xb0e9('0x47')]=qs[_0xb0e9('0x3e')](_['pick'](_0x48144a[_0xb0e9('0x3d')],_0x3613f3['filters']));if(_0x48144a[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x5b26e9['where']=_[_0xb0e9('0x49')](_0x5b26e9[_0xb0e9('0x47')],{'$or':_[_0xb0e9('0x31')](_0x5b26e9[_0xb0e9('0x42')],function(_0x1ae9e1){var _0x33ce6b={};_0x33ce6b[_0x1ae9e1]={'$like':'%'+_0x48144a[_0xb0e9('0x3d')]['filter']+'%'};return _0x33ce6b;})});}_0x5b26e9=_[_0xb0e9('0x49')]({},_0x5b26e9,_0x48144a[_0xb0e9('0x4a')]);return _0x14e390[_0xb0e9('0x9d')](_0x5b26e9);}})[_0xb0e9('0x29')](function(_0x142e1c){if(_0x142e1c){_0xf46ec3=_0x142e1c['length'];if(!_0x48144a[_0xb0e9('0x3d')][_0xb0e9('0x44')](_0xb0e9('0x60'))){_0x5b26e9[_0xb0e9('0x25')]=qs[_0xb0e9('0x25')](_0x48144a[_0xb0e9('0x3d')][_0xb0e9('0x25')]);_0x5b26e9[_0xb0e9('0x22')]=qs[_0xb0e9('0x22')](_0x48144a[_0xb0e9('0x3d')][_0xb0e9('0x22')]);}return _0x14e390['getLists'](_0x5b26e9);}})[_0xb0e9('0x29')](function(_0x35f7ac){if(_0x35f7ac){return _0x35f7ac?{'count':_0xf46ec3,'rows':_0x35f7ac}:null;}})['then'](respondWithResult(_0x32a0c0,null))[_0xb0e9('0x4b')](handleError(_0x32a0c0,null));};exports[_0xb0e9('0x9e')]=function(_0x1f43ca,_0x204954,_0x3a29d6){var _0x59bee3,_0x3cc232;return db[_0xb0e9('0x3a')][_0xb0e9('0x51')]({'where':{'id':_0x1f43ca[_0xb0e9('0x4d')]['id']}})['then'](handleEntityNotFound(_0x204954,null))[_0xb0e9('0x29')](function(_0x5b691f){if(_0x5b691f){_0x3cc232=_0x5b691f;return _0x5b691f[_0xb0e9('0x9e')](_0x1f43ca[_0xb0e9('0x53')]['ids'],_['omit'](_0x1f43ca[_0xb0e9('0x53')],[_0xb0e9('0x81'),'id'])||{});}return null;})[_0xb0e9('0x97')](function(_0x2c81bc){var _0x20f18d;_0x59bee3=_0x2c81bc||[];var _0x4f6854=[];if(_0x2c81bc){for(var _0x7bb709=0x0;_0x7bb709<_0x2c81bc['length'];_0x7bb709+=0x1){var _0xc3543c=_0x2c81bc[_0x7bb709]['get']({'plain':!![]});_0x3cc232[_0xb0e9('0x9f')]=_0x1f43ca[_0xb0e9('0x53')][_0xb0e9('0x9f')]?_0x1f43ca[_0xb0e9('0x53')][_0xb0e9('0x9f')]:_0x3cc232[_0xb0e9('0x9f')];switch(_0x3cc232[_0xb0e9('0x9f')]){case _0xb0e9('0xa0'):_0x20f18d=squel[_0xb0e9('0xa1')]()['into']('cm_hopper')[_0xb0e9('0xa2')]([_0xb0e9('0xa3'),_0xb0e9('0xa4'),'ContactId','ListId','VoiceQueueId',_0xb0e9('0x5c'),'updatedAt'],squel['select']()[_0xb0e9('0x83')]('phone','phone')[_0xb0e9('0x83')](_0xb0e9('0xa5'),_0xb0e9('0xa4'))[_0xb0e9('0x83')]('id',_0xb0e9('0xa6'))[_0xb0e9('0x83')](_0xc3543c[_0xb0e9('0xa7')][_0xb0e9('0x8b')](),_0xb0e9('0xa8'))[_0xb0e9('0x83')](_0x1f43ca[_0xb0e9('0x4d')]['id'][_0xb0e9('0x8b')](),_0xb0e9('0x62'))[_0xb0e9('0x83')](_0xb0e9('0xa5'),_0xb0e9('0x5c'))[_0xb0e9('0x83')](_0xb0e9('0xa5'),'updatedAt')[_0xb0e9('0x85')](_0xb0e9('0xa9'))[_0xb0e9('0x47')](_0xb0e9('0xaa'))[_0xb0e9('0x47')]('ListId\x20=\x20?',_0xc3543c[_0xb0e9('0xa7')][_0xb0e9('0x8b')]())[_0xb0e9('0x47')](_0xb0e9('0xab'))[_0xb0e9('0x47')](_0xb0e9('0xac'),squel[_0xb0e9('0x82')]()[_0xb0e9('0x83')](_0xb0e9('0xad'))[_0xb0e9('0x85')](_0xb0e9('0xae'))[_0xb0e9('0x47')]('VoiceQueueId\x20=\x20?',_0x1f43ca[_0xb0e9('0x4d')]['id'][_0xb0e9('0x8b')]()))[_0xb0e9('0x47')](_0xb0e9('0xac'),squel[_0xb0e9('0x82')]()[_0xb0e9('0x83')](_0xb0e9('0xaf'))[_0xb0e9('0x85')](_0xb0e9('0xb0'))[_0xb0e9('0x47')](_0xb0e9('0x88'),_0x1f43ca[_0xb0e9('0x4d')]['id'][_0xb0e9('0x8b')]())))[_0xb0e9('0x8b')]();break;case _0xb0e9('0xb1'):_0x20f18d=squel['insert']()[_0xb0e9('0xb2')](_0xb0e9('0xb0'))[_0xb0e9('0xa2')]([_0xb0e9('0xa3'),_0xb0e9('0xa4'),_0xb0e9('0xa6'),_0xb0e9('0xa8'),_0xb0e9('0x62'),_0xb0e9('0x5c'),'updatedAt'],squel['select']()['field'](_0xb0e9('0xa3'),_0xb0e9('0xa3'))[_0xb0e9('0x83')](_0xb0e9('0xa5'),_0xb0e9('0xa4'))['field']('id',_0xb0e9('0xa6'))['field'](_0xc3543c[_0xb0e9('0xa7')][_0xb0e9('0x8b')](),_0xb0e9('0xa8'))[_0xb0e9('0x83')](_0x1f43ca['params']['id']['toString'](),_0xb0e9('0x62'))['field'](_0xb0e9('0xa5'),'createdAt')['field'](_0xb0e9('0xa5'),'updatedAt')['from'](_0xb0e9('0xa9'))[_0xb0e9('0x47')](_0xb0e9('0xaa'))[_0xb0e9('0x47')](_0xb0e9('0xb3'),_0xc3543c['CmListId'][_0xb0e9('0x8b')]())['where'](_0xb0e9('0xab'))[_0xb0e9('0x47')]('phone\x20NOT\x20IN\x20(?)',squel['select']()['field'](_0xb0e9('0xaf'))[_0xb0e9('0x85')](_0xb0e9('0xb0'))[_0xb0e9('0x47')](_0xb0e9('0x88'),_0x1f43ca['params']['id']['toString']())))[_0xb0e9('0x8b')]();break;default:_0x20f18d=squel['insert']()[_0xb0e9('0xb2')](_0xb0e9('0xb0'))[_0xb0e9('0xa2')]([_0xb0e9('0xa3'),_0xb0e9('0xa4'),_0xb0e9('0xa6'),_0xb0e9('0xa8'),'VoiceQueueId',_0xb0e9('0x5c'),'updatedAt'],squel[_0xb0e9('0x82')]()[_0xb0e9('0x83')]('phone',_0xb0e9('0xa3'))[_0xb0e9('0x83')]('NOW()','scheduledAt')[_0xb0e9('0x83')]('id','ContactId')[_0xb0e9('0x83')](_0xc3543c[_0xb0e9('0xa7')][_0xb0e9('0x8b')](),_0xb0e9('0xa8'))[_0xb0e9('0x83')](_0x1f43ca[_0xb0e9('0x4d')]['id'][_0xb0e9('0x8b')](),_0xb0e9('0x62'))['field'](_0xb0e9('0xa5'),_0xb0e9('0x5c'))[_0xb0e9('0x83')]('NOW()',_0xb0e9('0x5b'))[_0xb0e9('0x85')](_0xb0e9('0xa9'))['where'](_0xb0e9('0xaa'))['where'](_0xb0e9('0xb3'),_0xc3543c[_0xb0e9('0xa7')][_0xb0e9('0x8b')]())[_0xb0e9('0x47')](_0xb0e9('0xab')))[_0xb0e9('0x8b')]();}_0x4f6854[_0xb0e9('0x8a')](db[_0xb0e9('0x76')]['query'](_0x20f18d));}return BPromise['all'](_0x4f6854);}})[_0xb0e9('0x29')](function(){return _0x59bee3;})['then'](respondWithResult(_0x204954,null))['catch'](handleError(_0x204954,null));};exports[_0xb0e9('0xb4')]=function(_0x4fa908,_0x385bac,_0x218e6d){return db['VoiceQueue']['find']({'where':{'id':_0x4fa908['params']['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0x385bac,null))[_0xb0e9('0x29')](function(_0x549088){if(_0x549088){return _0x549088[_0xb0e9('0xb4')](_0x4fa908[_0xb0e9('0x3d')][_0xb0e9('0x81')]);}})[_0xb0e9('0x29')](function(_0x74850d){if(_0x74850d){return db['CmHopper'][_0xb0e9('0x2a')]({'where':{'ListId':_0x4fa908[_0xb0e9('0x3d')]['ids'],'VoiceQueueId':_0x4fa908[_0xb0e9('0x4d')]['id']}})['then'](function(){return _0x74850d;});}})[_0xb0e9('0x29')](respondWithStatusCode(_0x385bac,null))['catch'](handleError(_0x385bac,null));};exports[_0xb0e9('0xb5')]=function(_0x261978,_0xf94b1b,_0x771707){var _0x630dde={};var _0x5cc9c0={};var _0x3269d6;var _0x4821fa;return db['VoiceQueue'][_0xb0e9('0x67')]({'where':{'id':_0x261978[_0xb0e9('0x4d')]['id']}})['then'](handleEntityNotFound(_0xf94b1b,null))[_0xb0e9('0x29')](function(_0x3cd1c6){if(_0x3cd1c6){_0x3269d6=_0x3cd1c6;_0x5cc9c0[_0xb0e9('0x40')]=_[_0xb0e9('0x4e')](db[_0xb0e9('0xb6')][_0xb0e9('0x3b')]);_0x5cc9c0[_0xb0e9('0x3d')]=_[_0xb0e9('0x4e')](_0x261978[_0xb0e9('0x3d')]);_0x5cc9c0[_0xb0e9('0x3e')]=_['intersection'](_0x5cc9c0['model'],_0x5cc9c0['query']);_0x630dde['attributes']=_[_0xb0e9('0x3f')](_0x5cc9c0[_0xb0e9('0x40')],qs['fields'](_0x261978['query'][_0xb0e9('0x41')]));_0x630dde['attributes']=_0x630dde[_0xb0e9('0x42')][_0xb0e9('0x43')]?_0x630dde[_0xb0e9('0x42')]:_0x5cc9c0['model'];_0x630dde[_0xb0e9('0x45')]=qs[_0xb0e9('0x46')](_0x261978['query']['sort']);_0x630dde[_0xb0e9('0x47')]=qs[_0xb0e9('0x3e')](_[_0xb0e9('0x61')](_0x261978[_0xb0e9('0x3d')],_0x5cc9c0['filters']));if(_0x261978[_0xb0e9('0x3d')][_0xb0e9('0x30')]){_0x630dde[_0xb0e9('0x47')]=_[_0xb0e9('0x49')](_0x630dde['where'],{'$or':_[_0xb0e9('0x31')](_0x630dde[_0xb0e9('0x42')],function(_0x1327d3){var _0x8b6dc6={};_0x8b6dc6[_0x1327d3]={'$like':'%'+_0x261978[_0xb0e9('0x3d')][_0xb0e9('0x30')]+'%'};return _0x8b6dc6;})});}_0x630dde=_[_0xb0e9('0x49')]({},_0x630dde,_0x261978[_0xb0e9('0x4a')]);return _0x3269d6[_0xb0e9('0xb5')](_0x630dde);}})[_0xb0e9('0x29')](function(_0x5019b0){if(_0x5019b0){_0x4821fa=_0x5019b0[_0xb0e9('0x43')];if(!_0x261978['query']['hasOwnProperty']('nolimit')){_0x630dde[_0xb0e9('0x25')]=qs[_0xb0e9('0x25')](_0x261978[_0xb0e9('0x3d')]['limit']);_0x630dde['offset']=qs['offset'](_0x261978[_0xb0e9('0x3d')][_0xb0e9('0x22')]);}return _0x3269d6[_0xb0e9('0xb5')](_0x630dde);}})[_0xb0e9('0x29')](function(_0x26d382){if(_0x26d382){return _0x26d382?{'count':_0x4821fa,'rows':_0x26d382}:null;}})['then'](respondWithResult(_0xf94b1b,null))[_0xb0e9('0x4b')](handleError(_0xf94b1b,null));};exports[_0xb0e9('0xb7')]=function(_0x258e43,_0xd7d02,_0x20a52a){var _0x753c81,_0x2f82a2;return db[_0xb0e9('0x3a')][_0xb0e9('0x51')]({'where':{'id':_0x258e43['params']['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0xd7d02,null))[_0xb0e9('0x29')](function(_0x45d752){if(_0x45d752){_0x2f82a2=_0x45d752;return _0x45d752[_0xb0e9('0xb7')](_0x258e43[_0xb0e9('0x53')][_0xb0e9('0x81')],_[_0xb0e9('0x5a')](_0x258e43[_0xb0e9('0x53')],['ids','id'])||{});}return null;})[_0xb0e9('0x97')](function(_0x528f21){var _0x3d2096;_0x753c81=_0x528f21||[];var _0x4ddc6c=[];if(_0x528f21){for(var _0x5dfc79=0x0;_0x5dfc79<_0x528f21['length'];_0x5dfc79+=0x1){var _0x1bc2cd=_0x528f21[_0x5dfc79][_0xb0e9('0x2b')]({'plain':!![]});_0x3d2096=squel['insert']()[_0xb0e9('0xb2')](_0xb0e9('0xb8'))['fromQuery']([_0xb0e9('0xa3'),_0xb0e9('0xa6'),_0xb0e9('0xa8'),'VoiceQueueId',_0xb0e9('0x5c'),_0xb0e9('0x5b')],squel[_0xb0e9('0x82')]()[_0xb0e9('0x83')](_0xb0e9('0xa3'),_0xb0e9('0xa3'))['field']('id','ContactId')['field'](_0x1bc2cd['CmListId'][_0xb0e9('0x8b')](),_0xb0e9('0xa8'))[_0xb0e9('0x83')](_0x258e43['params']['id'][_0xb0e9('0x8b')](),'VoiceQueueId')[_0xb0e9('0x83')](_0xb0e9('0xa5'),_0xb0e9('0x5c'))[_0xb0e9('0x83')](_0xb0e9('0xa5'),_0xb0e9('0x5b'))[_0xb0e9('0x85')](_0xb0e9('0xa9'))[_0xb0e9('0x47')](_0xb0e9('0xaa'))['where'](_0xb0e9('0xb3'),_0x1bc2cd[_0xb0e9('0xa7')][_0xb0e9('0x8b')]())['where'](_0xb0e9('0xab')))[_0xb0e9('0x8b')]();_0x4ddc6c[_0xb0e9('0x8a')](db[_0xb0e9('0x76')][_0xb0e9('0x3d')](_0x3d2096));}return BPromise['all'](_0x4ddc6c);}})['then'](function(){return _0x753c81;})[_0xb0e9('0x29')](respondWithResult(_0xd7d02,null))['catch'](handleError(_0xd7d02,null));};exports[_0xb0e9('0xb9')]=function(_0x3b37a0,_0x1e8d20,_0x7d596e){return db[_0xb0e9('0x3a')][_0xb0e9('0x51')]({'where':{'id':_0x3b37a0[_0xb0e9('0x4d')]['id']}})[_0xb0e9('0x29')](handleEntityNotFound(_0x1e8d20,null))['then'](function(_0x1d21a0){if(_0x1d21a0){return _0x1d21a0[_0xb0e9('0xb9')](_0x3b37a0[_0xb0e9('0x3d')][_0xb0e9('0x81')]);}})[_0xb0e9('0x29')](function(_0x5dc41a){if(_0x5dc41a){return db[_0xb0e9('0x6c')]['destroy']({'where':{'ListId':_0x3b37a0[_0xb0e9('0x3d')][_0xb0e9('0x81')],'VoiceQueueId':_0x3b37a0[_0xb0e9('0x4d')]['id']}})['then'](function(){return _0x5dc41a;});}})[_0xb0e9('0x29')](respondWithStatusCode(_0x1e8d20,null))[_0xb0e9('0x4b')](handleError(_0x1e8d20,null));};
\ No newline at end of file
+var _0x2689=['fs-extra','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/license/util','../../mysqldb','defaults','redis','localhost','socket.io-emitter','./voiceQueue.socket','register','status','end','json','offset','undefined','count','limit','set','Content-Range','apply','reject','save','update','then','destroy','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','map','value','includes','type','find','UserProfileResource','sendStatus','stack','name','send','VoiceQueue','rawAttributes','fieldName','key','model','query','attributes','intersection','fields','length','hasOwnProperty','order','sort','filters','where','merge','VIRTUAL','options','includeAll','rows','catch','show','params','keys','include','create','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','UserProfileSection','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','updatedAt','body','omit','role','userProfileId','findOne','CmHopper','nolimit','pick','VoiceQueueId','findAll','getHopperHistories','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','teams','online','voicePause','Agents','forEach','penalty','sequelize','transaction','each','UserVoiceQueue','UserVoiceQueueRt','upsert','isNil','interface','format','SIP/%s','emit','userVoiceQueue:save','removeTeams','ids','User','select','field','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','toString','SELECT','every','all','compact','removeAgents','userVoiceQueue:remove','addAgents','push','isArray','getAgents','getMembers','CmList','getLists','addLists','spread','dialCheckDuplicateType','always','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','NOW()','CmListId','ListId','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','onlyIfOpen','insert','createdAt','COALESCE(phone,\x27\x27)','removeLists','getBlackLists','addBlackLists','removeBlackLists','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','to-csv','ejs'];(function(_0x429d83,_0x988373){var _0x206410=function(_0x5e0067){while(--_0x5e0067){_0x429d83['push'](_0x429d83['shift']());}};_0x206410(++_0x988373);}(_0x2689,0xae));var _0x9268=function(_0xaae8e8,_0x35aa5c){_0xaae8e8=_0xaae8e8-0x0;var _0xcff5cf=_0x2689[_0xaae8e8];return _0xcff5cf;};'use strict';var emlformat=require(_0x9268('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x9268('0x1'));var jsonpatch=require(_0x9268('0x2'));var rp=require(_0x9268('0x3'));var moment=require(_0x9268('0x4'));var BPromise=require(_0x9268('0x5'));var Mustache=require('mustache');var util=require(_0x9268('0x6'));var path=require(_0x9268('0x7'));var sox=require('sox');var csv=require(_0x9268('0x8'));var ejs=require(_0x9268('0x9'));var fs=require('fs');var fs_extra=require(_0x9268('0xa'));var _=require('lodash');var squel=require(_0x9268('0xb'));var crypto=require(_0x9268('0xc'));var jsforce=require(_0x9268('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x9268('0x8'));var querystring=require(_0x9268('0xe'));var Papa=require(_0x9268('0xf'));var Redis=require(_0x9268('0x10'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x9268('0x11'));var hardwareService=require(_0x9268('0x12'));var logger=require(_0x9268('0x13'))('api');var utils=require(_0x9268('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x9268('0x15'));var db=require(_0x9268('0x16'))['db'];config['redis']=_[_0x9268('0x17')](config[_0x9268('0x18')],{'host':_0x9268('0x19'),'port':0x18eb});var socket=require(_0x9268('0x1a'))(new Redis(config['redis']));require(_0x9268('0x1b'))[_0x9268('0x1c')](socket);function respondWithStatusCode(_0x46136f,_0xdef076){_0xdef076=_0xdef076||0xcc;return function(_0x4c0c9d){if(_0x4c0c9d){return _0x46136f['sendStatus'](_0xdef076);}return _0x46136f[_0x9268('0x1d')](_0xdef076)[_0x9268('0x1e')]();};}function respondWithResult(_0x3293cd,_0x2bb201){_0x2bb201=_0x2bb201||0xc8;return function(_0x3d03e2){if(_0x3d03e2){return _0x3293cd['status'](_0x2bb201)[_0x9268('0x1f')](_0x3d03e2);}};}function respondWithFilteredResult(_0x4b65df,_0xa56f11){return function(_0x12f5d3){if(_0x12f5d3){var _0x13ddb9=typeof _0xa56f11[_0x9268('0x20')]==='undefined'&&typeof _0xa56f11['limit']===_0x9268('0x21');var _0x14588f=_0x12f5d3[_0x9268('0x22')];var _0x508a9c=_0x13ddb9?0x0:_0xa56f11[_0x9268('0x20')];var _0x40b1e0=_0x13ddb9?_0x12f5d3[_0x9268('0x22')]:_0xa56f11[_0x9268('0x20')]+_0xa56f11[_0x9268('0x23')];var _0x363962;if(_0x40b1e0>=_0x14588f){_0x40b1e0=_0x14588f;_0x363962=0xc8;}else{_0x363962=0xce;}_0x4b65df[_0x9268('0x1d')](_0x363962);return _0x4b65df[_0x9268('0x24')](_0x9268('0x25'),_0x508a9c+'-'+_0x40b1e0+'/'+_0x14588f)[_0x9268('0x1f')](_0x12f5d3);}return null;};}function patchUpdates(_0x4a7596){return function(_0x100ddb){try{jsonpatch[_0x9268('0x26')](_0x100ddb,_0x4a7596,!![]);}catch(_0x2d0b64){return BPromise[_0x9268('0x27')](_0x2d0b64);}return _0x100ddb[_0x9268('0x28')]();};}function saveUpdates(_0x5cbb17,_0x589dfe){return function(_0x59628a){if(_0x59628a){return _0x59628a[_0x9268('0x29')](_0x5cbb17)[_0x9268('0x2a')](function(_0x224d43){return _0x224d43;});}return null;};}function removeEntity(_0x35702f,_0x1b5f88){return function(_0x461675){if(_0x461675){return _0x461675[_0x9268('0x2b')]()[_0x9268('0x2a')](function(){var _0x267ce6=_0x461675['get']({'plain':!![]});var _0x5610a2=[{'name':_0x9268('0x2c'),'value':_0x9268('0x2d'),'ignore':![]},{'name':_0x9268('0x2e'),'value':_0x9268('0x2f'),'ignore':![]}];var _0x1d75d3=_(_0x5610a2)[_0x9268('0x30')](_0x9268('0x31'))[_0x9268('0x32')](_0x9268('0x33'))[_0x9268('0x33')]();if(_[_0x9268('0x34')](_0x1d75d3,_0x267ce6[_0x9268('0x35')])){return;}var _0x31fdb8=_[_0x9268('0x36')](_0x5610a2,[_0x9268('0x33'),_0x267ce6[_0x9268('0x35')]])['name'];return db[_0x9268('0x37')][_0x9268('0x2b')]({'where':{'type':_0x31fdb8,'resourceId':_0x267ce6['id']}})['then'](function(){return _0x461675;});})[_0x9268('0x2a')](function(){_0x35702f[_0x9268('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0xf0ecaf,_0x223884){return function(_0x227bbf){if(!_0x227bbf){_0xf0ecaf[_0x9268('0x38')](0x194);}return _0x227bbf;};}function handleError(_0x46f752,_0xd7b03a){_0xd7b03a=_0xd7b03a||0x1f4;return function(_0x22b130){logger['error'](_0x22b130[_0x9268('0x39')]);if(_0x22b130[_0x9268('0x3a')]){delete _0x22b130[_0x9268('0x3a')];}_0x46f752['status'](_0xd7b03a)[_0x9268('0x3b')](_0x22b130);};}exports['index']=function(_0x4deb36,_0x5c138e){var _0x1dd4da={},_0x5beccd={},_0x397201={'count':0x0,'rows':[]};var _0x157998=_['map'](db[_0x9268('0x3c')][_0x9268('0x3d')],function(_0x1df408){return{'name':_0x1df408[_0x9268('0x3e')],'type':_0x1df408[_0x9268('0x35')][_0x9268('0x3f')]};});_0x5beccd[_0x9268('0x40')]=_['map'](_0x157998,'name');_0x5beccd['query']=_['keys'](_0x4deb36[_0x9268('0x41')]);_0x5beccd['filters']=_['intersection'](_0x5beccd['model'],_0x5beccd['query']);_0x1dd4da[_0x9268('0x42')]=_[_0x9268('0x43')](_0x5beccd[_0x9268('0x40')],qs[_0x9268('0x44')](_0x4deb36[_0x9268('0x41')][_0x9268('0x44')]));_0x1dd4da[_0x9268('0x42')]=_0x1dd4da[_0x9268('0x42')][_0x9268('0x45')]?_0x1dd4da[_0x9268('0x42')]:_0x5beccd['model'];if(!_0x4deb36[_0x9268('0x41')][_0x9268('0x46')]('nolimit')){_0x1dd4da[_0x9268('0x23')]=qs[_0x9268('0x23')](_0x4deb36['query']['limit']);_0x1dd4da[_0x9268('0x20')]=qs[_0x9268('0x20')](_0x4deb36[_0x9268('0x41')][_0x9268('0x20')]);}_0x1dd4da[_0x9268('0x47')]=qs[_0x9268('0x48')](_0x4deb36[_0x9268('0x41')][_0x9268('0x48')]);_0x1dd4da['where']=qs['filters'](_['pick'](_0x4deb36[_0x9268('0x41')],_0x5beccd[_0x9268('0x49')]),_0x157998);if(_0x4deb36[_0x9268('0x41')][_0x9268('0x30')]){_0x1dd4da[_0x9268('0x4a')]=_[_0x9268('0x4b')](_0x1dd4da['where'],{'$or':_[_0x9268('0x32')](_0x157998,function(_0x6cd13d){if(_0x6cd13d['type']!==_0x9268('0x4c')){var _0x156f23={};_0x156f23[_0x6cd13d['name']]={'$like':'%'+_0x4deb36[_0x9268('0x41')][_0x9268('0x30')]+'%'};return _0x156f23;}})});}_0x1dd4da=_[_0x9268('0x4b')]({},_0x1dd4da,_0x4deb36[_0x9268('0x4d')]);var _0x1ed1e7={'where':_0x1dd4da[_0x9268('0x4a')]};return db[_0x9268('0x3c')]['count'](_0x1ed1e7)['then'](function(_0x23bafe){_0x397201[_0x9268('0x22')]=_0x23bafe;if(_0x4deb36[_0x9268('0x41')][_0x9268('0x4e')]){_0x1dd4da['include']=[{'all':!![]}];}return db[_0x9268('0x3c')]['findAll'](_0x1dd4da);})['then'](function(_0xf43496){_0x397201[_0x9268('0x4f')]=_0xf43496;return _0x397201;})[_0x9268('0x2a')](respondWithFilteredResult(_0x5c138e,_0x1dd4da))[_0x9268('0x50')](handleError(_0x5c138e,null));};exports[_0x9268('0x51')]=function(_0x543df1,_0x58ebd8){var _0x11932b={'raw':![],'where':{'id':_0x543df1[_0x9268('0x52')]['id']}},_0x355087={};_0x355087[_0x9268('0x40')]=_[_0x9268('0x53')](db[_0x9268('0x3c')]['rawAttributes']);_0x355087[_0x9268('0x41')]=_[_0x9268('0x53')](_0x543df1[_0x9268('0x41')]);_0x355087[_0x9268('0x49')]=_[_0x9268('0x43')](_0x355087[_0x9268('0x40')],_0x355087[_0x9268('0x41')]);_0x11932b[_0x9268('0x42')]=_['intersection'](_0x355087[_0x9268('0x40')],qs[_0x9268('0x44')](_0x543df1['query'][_0x9268('0x44')]));_0x11932b[_0x9268('0x42')]=_0x11932b[_0x9268('0x42')][_0x9268('0x45')]?_0x11932b[_0x9268('0x42')]:_0x355087[_0x9268('0x40')];if(_0x543df1['query'][_0x9268('0x4e')]){_0x11932b[_0x9268('0x54')]=[{'all':!![]}];}_0x11932b=_[_0x9268('0x4b')]({},_0x11932b,_0x543df1[_0x9268('0x4d')]);return db[_0x9268('0x3c')][_0x9268('0x36')](_0x11932b)['then'](handleEntityNotFound(_0x58ebd8,null))['then'](respondWithResult(_0x58ebd8,null))[_0x9268('0x50')](handleError(_0x58ebd8,null));};exports['create']=function(_0x56f846,_0x30789a){return db['VoiceQueue'][_0x9268('0x55')](_0x56f846['body'],{})[_0x9268('0x2a')](function(_0x28b240){var _0xf097d7=_0x56f846['user'][_0x9268('0x56')]({'plain':!![]});if(!_0xf097d7)throw new Error(_0x9268('0x57'));if(_0xf097d7['role']===_0x9268('0x58')){var _0x19f526=_0x28b240[_0x9268('0x56')]({'plain':!![]});var _0x329482=[{'name':'VoiceQueues','value':'inbound'},{'name':_0x9268('0x2e'),'value':_0x9268('0x2f')}];var _0x5c1264=_[_0x9268('0x36')](_0x329482,[_0x9268('0x33'),_0x19f526[_0x9268('0x35')]])[_0x9268('0x3a')];return db[_0x9268('0x59')][_0x9268('0x36')]({'where':{'name':_0x5c1264,'userProfileId':_0xf097d7['userProfileId']},'raw':!![]})[_0x9268('0x2a')](function(_0x171d3b){if(_0x171d3b&&_0x171d3b['autoAssociation']===0x0){return db[_0x9268('0x37')]['create']({'name':_0x19f526[_0x9268('0x3a')],'resourceId':_0x19f526['id'],'type':_0x171d3b[_0x9268('0x3a')],'sectionId':_0x171d3b['id']},{})[_0x9268('0x2a')](function(){return _0x28b240;});}else{return _0x28b240;}})[_0x9268('0x50')](function(_0x298933){logger[_0x9268('0x5a')](_0x9268('0x5b'),_0x298933);throw _0x298933;});}return _0x28b240;})['then'](respondWithResult(_0x30789a,0xc9))['catch'](handleError(_0x30789a,null));};exports[_0x9268('0x5c')]=function(_0x225e4e,_0x4acf0a){var _0x41f407={'where':{'id':_0x225e4e[_0x9268('0x52')]['id']}},_0x4dcf20={};_0x4dcf20[_0x9268('0x40')]=_[_0x9268('0x53')](db[_0x9268('0x3c')][_0x9268('0x3d')]);_0x41f407['attributes']=_[_0x9268('0x43')](_0x4dcf20[_0x9268('0x40')],qs[_0x9268('0x44')](_0x225e4e[_0x9268('0x41')][_0x9268('0x44')]));_0x41f407['attributes']=_0x41f407['attributes'][_0x9268('0x45')]?_0x41f407[_0x9268('0x42')]:_0x4dcf20[_0x9268('0x40')];if(_0x225e4e[_0x9268('0x41')][_0x9268('0x4e')]){_0x41f407['include']=[{'all':!![]}];}_0x41f407=_[_0x9268('0x4b')]({},_0x41f407,_0x225e4e[_0x9268('0x4d')]);return db['VoiceQueue'][_0x9268('0x36')](_0x41f407)[_0x9268('0x2a')](handleEntityNotFound(_0x4acf0a,null))[_0x9268('0x2a')](function(_0x4f5e13){if(_0x4f5e13){var _0x5abc75=_0x4f5e13[_0x9268('0x56')]({'plain':!![]});_0x5abc75=qs['omit'](_0x5abc75,['id','createdAt',_0x9268('0x5d')]);_0x225e4e[_0x9268('0x5e')]=_[_0x9268('0x5f')](_0x225e4e[_0x9268('0x5e')],['id','createdAt',_0x9268('0x5d')]);return db[_0x9268('0x3c')]['create'](_[_0x9268('0x4b')](_0x5abc75,_0x225e4e[_0x9268('0x5e')]),{'include':_0x225e4e['query'][_0x9268('0x4e')]?[{'all':!![]}]:undefined})[_0x9268('0x2a')](function(_0x28f240){var _0x268606=_0x225e4e[_0x9268('0x58')][_0x9268('0x56')]({'plain':!![]});if(!_0x268606)throw new Error(_0x9268('0x57'));if(_0x268606[_0x9268('0x60')]===_0x9268('0x58')){var _0x12ffb8=_0x28f240[_0x9268('0x56')]({'plain':!![]});var _0x45c081=[{'name':_0x9268('0x2c'),'value':_0x9268('0x2d')},{'name':_0x9268('0x2e'),'value':_0x9268('0x2f')}];var _0x291328=_[_0x9268('0x36')](_0x45c081,['value',_0x12ffb8[_0x9268('0x35')]])[_0x9268('0x3a')];return db[_0x9268('0x59')][_0x9268('0x36')]({'where':{'name':_0x291328,'userProfileId':_0x268606[_0x9268('0x61')]},'raw':!![]})[_0x9268('0x2a')](function(_0x142cc9){if(_0x142cc9&&_0x142cc9['autoAssociation']===0x0){return db[_0x9268('0x37')]['create']({'name':_0x12ffb8[_0x9268('0x3a')],'resourceId':_0x12ffb8['id'],'type':_0x142cc9[_0x9268('0x3a')],'sectionId':_0x142cc9['id']},{})[_0x9268('0x2a')](function(){return _0x28f240;});}else{return _0x28f240;}})['catch'](function(_0x5f0beb){logger['error'](_0x9268('0x5b'),_0x5f0beb);throw _0x5f0beb;});}return _0x28f240;});}})['then'](respondWithResult(_0x4acf0a,0xc9))[_0x9268('0x50')](handleError(_0x4acf0a,null));};exports['update']=function(_0x26712b,_0x459bda){if(_0x26712b[_0x9268('0x5e')]['id']){delete _0x26712b['body']['id'];}return db[_0x9268('0x3c')][_0x9268('0x36')]({'where':{'id':_0x26712b[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x459bda,null))[_0x9268('0x2a')](saveUpdates(_0x26712b[_0x9268('0x5e')],null))[_0x9268('0x2a')](respondWithResult(_0x459bda,null))[_0x9268('0x50')](handleError(_0x459bda,null));};exports[_0x9268('0x2b')]=function(_0x5baf94,_0x5c5797){return db[_0x9268('0x3c')][_0x9268('0x36')]({'where':{'id':_0x5baf94[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x5c5797,null))[_0x9268('0x2a')](removeEntity(_0x5c5797,null))[_0x9268('0x50')](handleError(_0x5c5797,null));};exports['getHoppers']=function(_0x70a079,_0x3d6833,_0x409093){var _0x31435f={'raw':![],'where':{}};var _0x18848b={};var _0x4db4aa={'count':0x0,'rows':[]};return db[_0x9268('0x3c')][_0x9268('0x62')]({'where':{'id':_0x70a079['params']['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x3d6833,null))['then'](function(_0x1977ad){if(_0x1977ad){_0x18848b['model']=_[_0x9268('0x53')](db[_0x9268('0x63')][_0x9268('0x3d')]);_0x18848b[_0x9268('0x41')]=_[_0x9268('0x53')](_0x70a079[_0x9268('0x41')]);_0x18848b['filters']=_[_0x9268('0x43')](_0x18848b['model'],_0x18848b[_0x9268('0x41')]);_0x31435f[_0x9268('0x42')]=_['intersection'](_0x18848b[_0x9268('0x40')],qs['fields'](_0x70a079[_0x9268('0x41')][_0x9268('0x44')]));_0x31435f[_0x9268('0x42')]=_0x31435f[_0x9268('0x42')][_0x9268('0x45')]?_0x31435f[_0x9268('0x42')]:_0x18848b[_0x9268('0x40')];if(!_0x70a079[_0x9268('0x41')][_0x9268('0x46')](_0x9268('0x64'))){_0x31435f[_0x9268('0x23')]=qs[_0x9268('0x23')](_0x70a079[_0x9268('0x41')]['limit']);_0x31435f['offset']=qs[_0x9268('0x20')](_0x70a079[_0x9268('0x41')]['offset']);}_0x31435f[_0x9268('0x47')]=qs['sort'](_0x70a079[_0x9268('0x41')][_0x9268('0x48')]);_0x31435f[_0x9268('0x4a')]=qs[_0x9268('0x49')](_[_0x9268('0x65')](_0x70a079['query'],_0x18848b['filters']));_0x31435f[_0x9268('0x4a')][_0x9268('0x66')]=_0x1977ad['id'];if(_0x70a079[_0x9268('0x41')][_0x9268('0x30')]){_0x31435f['where']=_[_0x9268('0x4b')](_0x31435f[_0x9268('0x4a')],{'$or':_[_0x9268('0x32')](_0x31435f[_0x9268('0x42')],function(_0x59a753){var _0x5179f2={};_0x5179f2[_0x59a753]={'$like':'%'+_0x70a079[_0x9268('0x41')]['filter']+'%'};return _0x5179f2;})});}_0x31435f=_[_0x9268('0x4b')]({},_0x31435f,_0x70a079[_0x9268('0x4d')]);return db[_0x9268('0x63')]['count']({'where':_0x31435f[_0x9268('0x4a')]})['then'](function(_0xa047dd){_0x4db4aa[_0x9268('0x22')]=_0xa047dd;if(_0x70a079[_0x9268('0x41')]['includeAll']){_0x31435f[_0x9268('0x54')]=[{'all':!![]}];}return db['CmHopper'][_0x9268('0x67')](_0x31435f);})[_0x9268('0x2a')](function(_0x3f1d1f){_0x4db4aa[_0x9268('0x4f')]=_0x3f1d1f;return _0x4db4aa;});}})['then'](respondWithFilteredResult(_0x3d6833,_0x31435f))['catch'](handleError(_0x3d6833,null));};exports[_0x9268('0x68')]=function(_0x11175d,_0x1924af,_0x59a92b){var _0x377328={'raw':!![],'where':{}};var _0x32ca4e={};var _0x267d35={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x9268('0x62')]({'where':{'id':_0x11175d[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x1924af,null))[_0x9268('0x2a')](function(_0x5e1ecb){if(_0x5e1ecb){_0x32ca4e[_0x9268('0x40')]=_['keys'](db[_0x9268('0x69')]['rawAttributes']);_0x32ca4e[_0x9268('0x41')]=_[_0x9268('0x53')](_0x11175d[_0x9268('0x41')]);_0x32ca4e[_0x9268('0x49')]=_['intersection'](_0x32ca4e[_0x9268('0x40')],_0x32ca4e[_0x9268('0x41')]);_0x377328[_0x9268('0x42')]=_['intersection'](_0x32ca4e[_0x9268('0x40')],qs[_0x9268('0x44')](_0x11175d['query'][_0x9268('0x44')]));_0x377328[_0x9268('0x42')]=_0x377328[_0x9268('0x42')][_0x9268('0x45')]?_0x377328[_0x9268('0x42')]:_0x32ca4e[_0x9268('0x40')];if(!_0x11175d[_0x9268('0x41')]['hasOwnProperty'](_0x9268('0x64'))){_0x377328[_0x9268('0x23')]=qs['limit'](_0x11175d[_0x9268('0x41')][_0x9268('0x23')]);_0x377328[_0x9268('0x20')]=qs[_0x9268('0x20')](_0x11175d['query'][_0x9268('0x20')]);}_0x377328[_0x9268('0x47')]=qs[_0x9268('0x48')](_0x11175d[_0x9268('0x41')][_0x9268('0x48')]);_0x377328['where']=qs['filters'](_[_0x9268('0x65')](_0x11175d[_0x9268('0x41')],_0x32ca4e[_0x9268('0x49')]));_0x377328[_0x9268('0x4a')]['VoiceQueueId']=_0x5e1ecb['id'];if(_0x11175d['query'][_0x9268('0x30')]){_0x377328[_0x9268('0x4a')]=_['merge'](_0x377328[_0x9268('0x4a')],{'$or':_['map'](_0x377328[_0x9268('0x42')],function(_0x5c4828){var _0x48e65f={};_0x48e65f[_0x5c4828]={'$like':'%'+_0x11175d[_0x9268('0x41')]['filter']+'%'};return _0x48e65f;})});}_0x377328=_[_0x9268('0x4b')]({},_0x377328,_0x11175d[_0x9268('0x4d')]);return db[_0x9268('0x69')]['count']({'where':_0x377328[_0x9268('0x4a')]})[_0x9268('0x2a')](function(_0x2297b6){_0x267d35[_0x9268('0x22')]=_0x2297b6;if(_0x11175d['query'][_0x9268('0x4e')]){_0x377328['include']=[{'all':!![]}];}return db['CmHopperHistory'][_0x9268('0x67')](_0x377328);})[_0x9268('0x2a')](function(_0x1ab881){_0x267d35[_0x9268('0x4f')]=_0x1ab881;return _0x267d35;});}})[_0x9268('0x2a')](respondWithFilteredResult(_0x1924af,_0x377328))[_0x9268('0x50')](handleError(_0x1924af,null));};exports[_0x9268('0x6a')]=function(_0x55beec,_0x34587d,_0x493c01){var _0x1347ef={'raw':!![],'where':{}};var _0x2bcefe={};var _0x36a99e={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x9268('0x62')]({'where':{'id':_0x55beec['params']['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x34587d,null))['then'](function(_0x2b0fd5){if(_0x2b0fd5){_0x2bcefe[_0x9268('0x40')]=_[_0x9268('0x53')](db['CmHopperFinal'][_0x9268('0x3d')]);_0x2bcefe[_0x9268('0x41')]=_['keys'](_0x55beec[_0x9268('0x41')]);_0x2bcefe[_0x9268('0x49')]=_['intersection'](_0x2bcefe['model'],_0x2bcefe[_0x9268('0x41')]);_0x1347ef['attributes']=_[_0x9268('0x43')](_0x2bcefe[_0x9268('0x40')],qs[_0x9268('0x44')](_0x55beec[_0x9268('0x41')][_0x9268('0x44')]));_0x1347ef['attributes']=_0x1347ef[_0x9268('0x42')][_0x9268('0x45')]?_0x1347ef[_0x9268('0x42')]:_0x2bcefe[_0x9268('0x40')];if(!_0x55beec[_0x9268('0x41')][_0x9268('0x46')]('nolimit')){_0x1347ef[_0x9268('0x23')]=qs[_0x9268('0x23')](_0x55beec[_0x9268('0x41')][_0x9268('0x23')]);_0x1347ef[_0x9268('0x20')]=qs['offset'](_0x55beec[_0x9268('0x41')][_0x9268('0x20')]);}_0x1347ef[_0x9268('0x47')]=qs['sort'](_0x55beec[_0x9268('0x41')][_0x9268('0x48')]);_0x1347ef['where']=qs['filters'](_['pick'](_0x55beec[_0x9268('0x41')],_0x2bcefe[_0x9268('0x49')]));_0x1347ef['where'][_0x9268('0x66')]=_0x2b0fd5['id'];if(_0x55beec[_0x9268('0x41')][_0x9268('0x30')]){_0x1347ef[_0x9268('0x4a')]=_['merge'](_0x1347ef['where'],{'$or':_[_0x9268('0x32')](_0x1347ef[_0x9268('0x42')],function(_0x5ad154){var _0x237d30={};_0x237d30[_0x5ad154]={'$like':'%'+_0x55beec[_0x9268('0x41')][_0x9268('0x30')]+'%'};return _0x237d30;})});}_0x1347ef=_[_0x9268('0x4b')]({},_0x1347ef,_0x55beec[_0x9268('0x4d')]);return db['CmHopperFinal'][_0x9268('0x22')]({'where':_0x1347ef[_0x9268('0x4a')]})[_0x9268('0x2a')](function(_0x19a919){_0x36a99e[_0x9268('0x22')]=_0x19a919;if(_0x55beec[_0x9268('0x41')]['includeAll']){_0x1347ef[_0x9268('0x54')]=[{'all':!![]}];}return db[_0x9268('0x6b')][_0x9268('0x67')](_0x1347ef);})[_0x9268('0x2a')](function(_0x24e02f){_0x36a99e[_0x9268('0x4f')]=_0x24e02f;return _0x36a99e;});}})[_0x9268('0x2a')](respondWithFilteredResult(_0x34587d,_0x1347ef))[_0x9268('0x50')](handleError(_0x34587d,null));};exports[_0x9268('0x6c')]=function(_0x31b01a,_0xa9b44c,_0x5e69f6){var _0x40cefe={'raw':!![],'where':{}};var _0x136261={};var _0x1ed862={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x9268('0x62')]({'where':{'id':_0x31b01a[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0xa9b44c,null))[_0x9268('0x2a')](function(_0x14fcff){if(_0x14fcff){_0x136261[_0x9268('0x40')]=_[_0x9268('0x53')](db['CmHopperBlack'][_0x9268('0x3d')]);_0x136261[_0x9268('0x41')]=_[_0x9268('0x53')](_0x31b01a[_0x9268('0x41')]);_0x136261[_0x9268('0x49')]=_[_0x9268('0x43')](_0x136261[_0x9268('0x40')],_0x136261['query']);_0x40cefe[_0x9268('0x42')]=_[_0x9268('0x43')](_0x136261[_0x9268('0x40')],qs[_0x9268('0x44')](_0x31b01a[_0x9268('0x41')][_0x9268('0x44')]));_0x40cefe[_0x9268('0x42')]=_0x40cefe['attributes'][_0x9268('0x45')]?_0x40cefe[_0x9268('0x42')]:_0x136261[_0x9268('0x40')];if(!_0x31b01a[_0x9268('0x41')][_0x9268('0x46')](_0x9268('0x64'))){_0x40cefe[_0x9268('0x23')]=qs[_0x9268('0x23')](_0x31b01a[_0x9268('0x41')][_0x9268('0x23')]);_0x40cefe[_0x9268('0x20')]=qs['offset'](_0x31b01a[_0x9268('0x41')][_0x9268('0x20')]);}_0x40cefe['order']=qs[_0x9268('0x48')](_0x31b01a[_0x9268('0x41')]['sort']);_0x40cefe[_0x9268('0x4a')]=qs[_0x9268('0x49')](_['pick'](_0x31b01a[_0x9268('0x41')],_0x136261[_0x9268('0x49')]));_0x40cefe['where']['VoiceQueueId']=_0x14fcff['id'];if(_0x31b01a['query'][_0x9268('0x30')]){_0x40cefe[_0x9268('0x4a')]=_['merge'](_0x40cefe[_0x9268('0x4a')],{'$or':_['map'](_0x40cefe[_0x9268('0x42')],function(_0x4d603e){var _0x1347f8={};_0x1347f8[_0x4d603e]={'$like':'%'+_0x31b01a['query'][_0x9268('0x30')]+'%'};return _0x1347f8;})});}_0x40cefe=_[_0x9268('0x4b')]({},_0x40cefe,_0x31b01a[_0x9268('0x4d')]);return db[_0x9268('0x6d')]['count']({'where':_0x40cefe[_0x9268('0x4a')]})[_0x9268('0x2a')](function(_0x548fdd){_0x1ed862['count']=_0x548fdd;if(_0x31b01a[_0x9268('0x41')][_0x9268('0x4e')]){_0x40cefe[_0x9268('0x54')]=[{'all':!![]}];}return db['CmHopperBlack'][_0x9268('0x67')](_0x40cefe);})['then'](function(_0x4c5615){_0x1ed862[_0x9268('0x4f')]=_0x4c5615;return _0x1ed862;});}})[_0x9268('0x2a')](respondWithFilteredResult(_0xa9b44c,_0x40cefe))['catch'](handleError(_0xa9b44c,null));};exports[_0x9268('0x6e')]=function(_0x56bb57,_0x169847,_0x350474){var _0x230d9b={};var _0x304350={};var _0x24d4b4;var _0x2b37ba;return db[_0x9268('0x3c')]['findOne']({'where':{'id':_0x56bb57[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x169847,null))[_0x9268('0x2a')](function(_0x28174c){if(_0x28174c){_0x24d4b4=_0x28174c;_0x304350[_0x9268('0x40')]=_[_0x9268('0x53')](db[_0x9268('0x6f')][_0x9268('0x3d')]);_0x304350[_0x9268('0x41')]=_[_0x9268('0x53')](_0x56bb57[_0x9268('0x41')]);_0x304350['filters']=_['intersection'](_0x304350[_0x9268('0x40')],_0x304350[_0x9268('0x41')]);_0x230d9b[_0x9268('0x42')]=_[_0x9268('0x43')](_0x304350[_0x9268('0x40')],qs[_0x9268('0x44')](_0x56bb57[_0x9268('0x41')][_0x9268('0x44')]));_0x230d9b['attributes']=_0x230d9b[_0x9268('0x42')][_0x9268('0x45')]?_0x230d9b['attributes']:_0x304350['model'];_0x230d9b[_0x9268('0x47')]=qs[_0x9268('0x48')](_0x56bb57[_0x9268('0x41')][_0x9268('0x48')]);_0x230d9b[_0x9268('0x4a')]=qs[_0x9268('0x49')](_['pick'](_0x56bb57['query'],_0x304350[_0x9268('0x49')]));if(_0x56bb57[_0x9268('0x41')][_0x9268('0x30')]){_0x230d9b[_0x9268('0x4a')]=_[_0x9268('0x4b')](_0x230d9b['where'],{'$or':_[_0x9268('0x32')](_0x230d9b[_0x9268('0x42')],function(_0x2c790e){var _0x5f34c9={};_0x5f34c9[_0x2c790e]={'$like':'%'+_0x56bb57['query']['filter']+'%'};return _0x5f34c9;})});}_0x230d9b=_[_0x9268('0x4b')]({},_0x230d9b,_0x56bb57['options']);return _0x24d4b4[_0x9268('0x6e')](_0x230d9b);}})[_0x9268('0x2a')](function(_0x2a14b9){if(_0x2a14b9){_0x2b37ba=_0x2a14b9[_0x9268('0x45')];if(!_0x56bb57[_0x9268('0x41')][_0x9268('0x46')](_0x9268('0x64'))){_0x230d9b[_0x9268('0x23')]=qs[_0x9268('0x23')](_0x56bb57[_0x9268('0x41')][_0x9268('0x23')]);_0x230d9b['offset']=qs[_0x9268('0x20')](_0x56bb57['query']['offset']);}return _0x24d4b4[_0x9268('0x6e')](_0x230d9b);}})['then'](function(_0x382113){if(_0x382113){return _0x382113?{'count':_0x2b37ba,'rows':_0x382113}:null;}})['then'](respondWithResult(_0x169847,null))[_0x9268('0x50')](handleError(_0x169847,null));};exports['addTeams']=function(_0x30bcd3,_0x33ea21,_0xbc25b3){var _0x39eff7=_0x30bcd3[_0x9268('0x5e')][_0x9268('0x70')];var _0x820d02=_[_0x9268('0x32')](_0x39eff7,'id');return db[_0x9268('0x6f')][_0x9268('0x67')]({'where':{'id':_0x820d02},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id',_0x9268('0x3a'),_0x9268('0x71'),_0x9268('0x72'),'interface'],'raw':!![]}]})[_0x9268('0x2a')](function(_0x152c70){if(_0x152c70){var _0xcaef50=_['flatMap'](_0x152c70,function(_0x3c06e1){var _0x4dbcae=_0x3c06e1[_0x9268('0x56')]({'plain':!![]});_0x4dbcae[_0x9268('0x73')][_0x9268('0x74')](function(_0x4a863d){_0x4a863d[_0x9268('0x75')]=_[_0x9268('0x36')](_0x39eff7,{'id':_0x4dbcae['id']})[_0x9268('0x75')];});return _0x4dbcae[_0x9268('0x73')];});return db['VoiceQueue']['find']({'where':{'id':_0x30bcd3[_0x9268('0x52')]['id']}})['then'](function(_0x5b18bb){return db[_0x9268('0x76')][_0x9268('0x77')](function(_0x5a9fa8){return _0x5b18bb['addTeams'](_0x820d02,{'transaction':_0x5a9fa8})['then'](function(){return BPromise[_0x9268('0x78')](_0x39eff7,function(_0x251a8c){return db['TeamVoiceQueue']['upsert']({'TeamId':_0x251a8c['id'],'VoiceQueueId':_0x30bcd3[_0x9268('0x52')]['id'],'penalty':_0x251a8c[_0x9268('0x75')]},{'transaction':_0x5a9fa8});});})[_0x9268('0x2a')](function(){return BPromise['each'](_0xcaef50,function(_0x40b09b){return db[_0x9268('0x79')]['findOrCreate']({'where':{'UserId':_0x40b09b['id'],'VoiceQueueId':_0x30bcd3[_0x9268('0x52')]['id']},'defaults':{'penalty':_0x40b09b['penalty']},'transaction':_0x5a9fa8});});})[_0x9268('0x2a')](function(){return BPromise[_0x9268('0x78')](_[_0x9268('0x30')](_0xcaef50,{'online':!![]}),function(_0x38f020){return db[_0x9268('0x7a')][_0x9268('0x7b')]({'membername':_0x38f020['name'],'UserId':_0x38f020['id'],'queue_name':_0x5b18bb[_0x9268('0x3a')],'VoiceQueueId':_0x5b18bb['id'],'interface':_[_0x9268('0x7c')](_0x38f020[_0x9268('0x7d')])?util[_0x9268('0x7e')](_0x9268('0x7f'),_0x38f020[_0x9268('0x3a')]):_0x38f020['interface'],'paused':_0x38f020[_0x9268('0x72')]||![],'penalty':_0x38f020[_0x9268('0x75')]},{'transaction':_0x5a9fa8});});})[_0x9268('0x2a')](function(){_0xcaef50['forEach'](function(_0x54ef3d){socket[_0x9268('0x80')](_0x9268('0x81'),{'UserId':_0x54ef3d['id'],'VoiceQueueId':_0x5b18bb['id']});});});});});}})[_0x9268('0x2a')](respondWithStatusCode(_0x33ea21,null))[_0x9268('0x50')](handleError(_0x33ea21,null));};exports[_0x9268('0x82')]=function(_0x1d72e8,_0x6096bc,_0x184e05){return db[_0x9268('0x6f')]['findAll']({'where':{'id':_0x1d72e8[_0x9268('0x41')][_0x9268('0x83')]},'attributes':['id'],'include':[{'model':db[_0x9268('0x84')],'as':_0x9268('0x73'),'attributes':['id'],'raw':!![]}]})[_0x9268('0x2a')](handleEntityNotFound(_0x6096bc,null))[_0x9268('0x2a')](function(_0x3f9214){var _0x4f1975=_[_0x9268('0x32')](_0x3f9214,'id');var _0x5675be=[];var _0x477497=[];var _0x55f6e6=squel[_0x9268('0x85')]();_0x55f6e6[_0x9268('0x86')](_0x9268('0x87'))[_0x9268('0x88')](_0x9268('0x89'),'tq')[_0x9268('0x8a')](_0x9268('0x8b'),'ut',_0x9268('0x8c'))['where'](_0x9268('0x8d'),_0x1d72e8[_0x9268('0x52')]['id']);for(var _0x5005c5=0x0;_0x5005c5<_0x3f9214['length'];_0x5005c5+=0x1){let _0x10c647=_0x3f9214[_0x5005c5];for(var _0x213117=0x0;_0x213117<_0x10c647[_0x9268('0x73')][_0x9268('0x45')];_0x213117+=0x1){let _0x5c9861=_0x10c647['Agents'][_0x213117];var _0x1a18db=_0x55f6e6['clone']();_0x1a18db['where'](_0x9268('0x8e'),_0x5c9861['id']);_0x477497['push'](db[_0x9268('0x76')][_0x9268('0x41')](_0x1a18db[_0x9268('0x8f')](),{'type':db[_0x9268('0x76')]['QueryTypes'][_0x9268('0x90')]})['then'](function(_0x1eef5c){if(_0x1eef5c[_0x9268('0x45')]===0x1){return _0x5c9861['id'];}else{var _0x4ac3f8=_[_0x9268('0x91')](_[_0x9268('0x32')](_0x1eef5c,'TeamId'),function(_0x1d4c58){return _[_0x9268('0x34')](_0x4f1975,_0x1d4c58);});if(_0x4ac3f8){return _0x5c9861['id'];}}}));}}return BPromise[_0x9268('0x92')](_0x477497)[_0x9268('0x2a')](function(_0x230802){_0x5675be=_(_0x5675be)['union'](_0x230802)[_0x9268('0x93')]()['value']();return db[_0x9268('0x3c')]['find']({'where':{'id':_0x1d72e8['params']['id']}})['then'](function(_0x295c48){return db[_0x9268('0x76')][_0x9268('0x77')](function(_0x8bfb39){return _0x295c48[_0x9268('0x82')](_0x1d72e8['query'][_0x9268('0x83')],{'transaction':_0x8bfb39})[_0x9268('0x2a')](function(){if(!_['isEmpty'](_0x5675be)){return _0x295c48[_0x9268('0x94')](_0x5675be,{'transaction':_0x8bfb39})['then'](function(){return db[_0x9268('0x7a')]['destroy']({'where':{'VoiceQueueId':_0x1d72e8[_0x9268('0x52')]['id'],'UserId':_0x5675be},'transaction':_0x8bfb39});});}})[_0x9268('0x2a')](function(){_0x5675be[_0x9268('0x74')](function(_0x582227){socket[_0x9268('0x80')](_0x9268('0x95'),{'UserId':_0x582227,'VoiceQueueId':_0x295c48['id']});});});});});});})[_0x9268('0x2a')](respondWithStatusCode(_0x6096bc,null))['catch'](handleError(_0x6096bc,null));};exports[_0x9268('0x96')]=function(_0x49646c,_0x19cd4a,_0x546be7){var _0x1092be,_0x4c8dd1;return db[_0x9268('0x3c')][_0x9268('0x36')]({'where':{'id':_0x49646c['params']['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x19cd4a,null))['then'](function(_0x359b32){if(_0x359b32){_0x4c8dd1=_0x359b32;return _0x359b32[_0x9268('0x96')](_0x49646c[_0x9268('0x5e')][_0x9268('0x83')],_['omit'](_0x49646c[_0x9268('0x5e')],[_0x9268('0x83'),'id'])||{})['spread'](function(_0x1a6624){for(var _0x412def=0x0;_0x412def<_0x49646c[_0x9268('0x5e')][_0x9268('0x83')][_0x9268('0x45')];_0x412def+=0x1){socket[_0x9268('0x80')]('userVoiceQueue:save',{'UserId':Number(_0x49646c['body'][_0x9268('0x83')][_0x412def]),'VoiceQueueId':Number(_0x49646c[_0x9268('0x52')]['id'])});}return _0x1a6624;});}})[_0x9268('0x2a')](function(_0x4850ba){_0x1092be=_0x4850ba||[];if(_0x4c8dd1){return db[_0x9268('0x84')]['findAll']({'where':{'id':_0x49646c['body']['ids']},'attributes':['id',_0x9268('0x3a'),_0x9268('0x71'),_0x9268('0x72'),'interface'],'raw':!![]});}})[_0x9268('0x2a')](function(_0x4b0b54){if(!_['isEmpty'](_0x4b0b54)){var _0x4c6a39=[];for(var _0x48a88b=0x0;_0x48a88b<_0x4b0b54['length'];_0x48a88b++){if(_0x4b0b54[_0x48a88b][_0x9268('0x71')]){_0x4c6a39[_0x9268('0x97')](db[_0x9268('0x7a')][_0x9268('0x7b')]({'membername':_0x4b0b54[_0x48a88b][_0x9268('0x3a')],'UserId':_0x4b0b54[_0x48a88b]['id'],'queue_name':_0x4c8dd1['name'],'VoiceQueueId':_0x4c8dd1['id'],'interface':_['isNil'](_0x4b0b54[_0x48a88b][_0x9268('0x7d')])?util[_0x9268('0x7e')](_0x9268('0x7f'),_0x4b0b54[_0x48a88b][_0x9268('0x3a')]):_0x4b0b54[_0x48a88b][_0x9268('0x7d')],'paused':_0x4b0b54[_0x48a88b][_0x9268('0x72')]||![],'penalty':_0x49646c[_0x9268('0x5e')][_0x9268('0x75')]||0x0}));}}return BPromise[_0x9268('0x92')](_0x4c6a39);}})[_0x9268('0x2a')](function(){return _0x1092be;})[_0x9268('0x2a')](respondWithResult(_0x19cd4a,null))['catch'](handleError(_0x19cd4a,null));};exports['removeAgents']=function(_0x21961f,_0x4a5d31,_0x23d661){return db[_0x9268('0x3c')][_0x9268('0x36')]({'where':{'id':_0x21961f[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x4a5d31,null))[_0x9268('0x2a')](function(_0x257009){if(_0x257009){return _0x257009[_0x9268('0x94')](_0x21961f[_0x9268('0x41')]['ids'])[_0x9268('0x2a')](function(){if(_[_0x9268('0x98')](_0x21961f[_0x9268('0x41')][_0x9268('0x83')])){for(var _0x1ae501=0x0;_0x1ae501<_0x21961f['query'][_0x9268('0x83')][_0x9268('0x45')];_0x1ae501+=0x1){socket['emit'](_0x9268('0x95'),{'UserId':Number(_0x21961f[_0x9268('0x41')][_0x9268('0x83')][_0x1ae501]),'VoiceQueueId':Number(_0x21961f[_0x9268('0x52')]['id'])});}}else{socket[_0x9268('0x80')]('userVoiceQueue:remove',{'UserId':Number(_0x21961f[_0x9268('0x41')]['ids']),'VoiceQueueId':Number(_0x21961f['params']['id'])});}});}})[_0x9268('0x2a')](function(_0x504bb6){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x21961f['params']['id'],'UserId':_0x21961f[_0x9268('0x41')][_0x9268('0x83')]}})[_0x9268('0x2a')](function(){return _0x504bb6;});})[_0x9268('0x2a')](respondWithStatusCode(_0x4a5d31,null))[_0x9268('0x50')](handleError(_0x4a5d31,null));};exports[_0x9268('0x99')]=function(_0x2062de,_0x3145dc,_0x227455){var _0x3cfaf0={};var _0x2dd42f={};var _0x403b05;var _0x3eea11;return db[_0x9268('0x3c')][_0x9268('0x62')]({'where':{'id':_0x2062de[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x3145dc,null))['then'](function(_0x274850){if(_0x274850){_0x403b05=_0x274850;_0x2dd42f['model']=_[_0x9268('0x53')](db[_0x9268('0x84')][_0x9268('0x3d')]);_0x2dd42f['query']=_['keys'](_0x2062de[_0x9268('0x41')]);_0x2dd42f['filters']=_[_0x9268('0x43')](_0x2dd42f[_0x9268('0x40')],_0x2dd42f[_0x9268('0x41')]);_0x3cfaf0[_0x9268('0x42')]=_[_0x9268('0x43')](_0x2dd42f[_0x9268('0x40')],qs[_0x9268('0x44')](_0x2062de[_0x9268('0x41')][_0x9268('0x44')]));_0x3cfaf0[_0x9268('0x42')]=_0x3cfaf0['attributes'][_0x9268('0x45')]?_0x3cfaf0[_0x9268('0x42')]:_0x2dd42f[_0x9268('0x40')];_0x3cfaf0['order']=qs[_0x9268('0x48')](_0x2062de[_0x9268('0x41')][_0x9268('0x48')]);_0x3cfaf0[_0x9268('0x4a')]=qs['filters'](_['pick'](_0x2062de[_0x9268('0x41')],_0x2dd42f[_0x9268('0x49')]));if(_0x2062de[_0x9268('0x41')]['filter']){_0x3cfaf0['where']=_[_0x9268('0x4b')](_0x3cfaf0['where'],{'$or':_['map'](_0x3cfaf0[_0x9268('0x42')],function(_0x29f4f8){var _0x183286={};_0x183286[_0x29f4f8]={'$like':'%'+_0x2062de['query'][_0x9268('0x30')]+'%'};return _0x183286;})});}_0x3cfaf0=_[_0x9268('0x4b')]({},_0x3cfaf0,_0x2062de[_0x9268('0x4d')]);return _0x403b05['getAgents'](_0x3cfaf0);}})[_0x9268('0x2a')](function(_0x3f1c80){if(_0x3f1c80){_0x3eea11=_0x3f1c80[_0x9268('0x45')];if(!_0x2062de[_0x9268('0x41')][_0x9268('0x46')]('nolimit')){_0x3cfaf0[_0x9268('0x23')]=qs[_0x9268('0x23')](_0x2062de[_0x9268('0x41')][_0x9268('0x23')]);_0x3cfaf0[_0x9268('0x20')]=qs[_0x9268('0x20')](_0x2062de[_0x9268('0x41')][_0x9268('0x20')]);}return _0x403b05['getAgents'](_0x3cfaf0);}})[_0x9268('0x2a')](function(_0x12afae){if(_0x12afae){return _0x12afae?{'count':_0x3eea11,'rows':_0x12afae}:null;}})[_0x9268('0x2a')](respondWithResult(_0x3145dc,null))[_0x9268('0x50')](handleError(_0x3145dc,null));};exports[_0x9268('0x9a')]=function(_0x5ce6d4,_0x4dca1c,_0x58e1ce){var _0x4e34dd={};var _0x2d5e5e={};var _0x38a419;var _0x5aa233;return db[_0x9268('0x3c')][_0x9268('0x62')]({'where':{'id':_0x5ce6d4[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x4dca1c,null))[_0x9268('0x2a')](function(_0x2b94f9){if(_0x2b94f9){_0x38a419=_0x2b94f9;_0x2d5e5e['model']=_[_0x9268('0x53')](db[_0x9268('0x7a')]['rawAttributes']);_0x2d5e5e[_0x9268('0x41')]=_[_0x9268('0x53')](_0x5ce6d4[_0x9268('0x41')]);_0x2d5e5e[_0x9268('0x49')]=_[_0x9268('0x43')](_0x2d5e5e['model'],_0x2d5e5e[_0x9268('0x41')]);_0x4e34dd['attributes']=_['intersection'](_0x2d5e5e[_0x9268('0x40')],qs[_0x9268('0x44')](_0x5ce6d4[_0x9268('0x41')][_0x9268('0x44')]));_0x4e34dd[_0x9268('0x42')]=_0x4e34dd[_0x9268('0x42')][_0x9268('0x45')]?_0x4e34dd[_0x9268('0x42')]:_0x2d5e5e[_0x9268('0x40')];_0x4e34dd['order']=qs[_0x9268('0x48')](_0x5ce6d4[_0x9268('0x41')][_0x9268('0x48')]);_0x4e34dd[_0x9268('0x4a')]=qs[_0x9268('0x49')](_['pick'](_0x5ce6d4[_0x9268('0x41')],_0x2d5e5e[_0x9268('0x49')]));if(_0x5ce6d4['query'][_0x9268('0x30')]){_0x4e34dd[_0x9268('0x4a')]=_[_0x9268('0x4b')](_0x4e34dd['where'],{'$or':_[_0x9268('0x32')](_0x4e34dd['attributes'],function(_0x4d2c6c){var _0x3bb016={};_0x3bb016[_0x4d2c6c]={'$like':'%'+_0x5ce6d4[_0x9268('0x41')][_0x9268('0x30')]+'%'};return _0x3bb016;})});}_0x4e34dd=_[_0x9268('0x4b')]({},_0x4e34dd,_0x5ce6d4[_0x9268('0x4d')]);return _0x38a419[_0x9268('0x9a')](_0x4e34dd);}})['then'](function(_0x53b5ab){if(_0x53b5ab){_0x5aa233=_0x53b5ab[_0x9268('0x45')];if(!_0x5ce6d4[_0x9268('0x41')][_0x9268('0x46')](_0x9268('0x64'))){_0x4e34dd[_0x9268('0x23')]=qs[_0x9268('0x23')](_0x5ce6d4[_0x9268('0x41')][_0x9268('0x23')]);_0x4e34dd[_0x9268('0x20')]=qs[_0x9268('0x20')](_0x5ce6d4[_0x9268('0x41')][_0x9268('0x20')]);}return _0x38a419[_0x9268('0x9a')](_0x4e34dd);}})[_0x9268('0x2a')](function(_0x50ea78){return _0x50ea78?{'count':_0x5aa233,'rows':_0x50ea78}:null;})[_0x9268('0x2a')](respondWithResult(_0x4dca1c,null))[_0x9268('0x50')](handleError(_0x4dca1c,null));};exports['getLists']=function(_0x5e8753,_0x3a1ef2,_0x18a139){var _0x14a23c={};var _0x42405e={};var _0x437218;var _0x40ad48;return db[_0x9268('0x3c')][_0x9268('0x62')]({'where':{'id':_0x5e8753['params']['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x3a1ef2,null))[_0x9268('0x2a')](function(_0x3a6aa5){if(_0x3a6aa5){_0x437218=_0x3a6aa5;_0x42405e[_0x9268('0x40')]=_[_0x9268('0x53')](db[_0x9268('0x9b')]['rawAttributes']);_0x42405e[_0x9268('0x41')]=_[_0x9268('0x53')](_0x5e8753[_0x9268('0x41')]);_0x42405e[_0x9268('0x49')]=_[_0x9268('0x43')](_0x42405e[_0x9268('0x40')],_0x42405e[_0x9268('0x41')]);_0x14a23c[_0x9268('0x42')]=_[_0x9268('0x43')](_0x42405e['model'],qs['fields'](_0x5e8753[_0x9268('0x41')][_0x9268('0x44')]));_0x14a23c[_0x9268('0x42')]=_0x14a23c[_0x9268('0x42')][_0x9268('0x45')]?_0x14a23c[_0x9268('0x42')]:_0x42405e[_0x9268('0x40')];_0x14a23c[_0x9268('0x47')]=qs['sort'](_0x5e8753['query'][_0x9268('0x48')]);_0x14a23c['where']=qs['filters'](_[_0x9268('0x65')](_0x5e8753['query'],_0x42405e[_0x9268('0x49')]));if(_0x5e8753[_0x9268('0x41')]['filter']){_0x14a23c[_0x9268('0x4a')]=_[_0x9268('0x4b')](_0x14a23c[_0x9268('0x4a')],{'$or':_['map'](_0x14a23c[_0x9268('0x42')],function(_0x10dafb){var _0x4dd656={};_0x4dd656[_0x10dafb]={'$like':'%'+_0x5e8753[_0x9268('0x41')][_0x9268('0x30')]+'%'};return _0x4dd656;})});}_0x14a23c=_[_0x9268('0x4b')]({},_0x14a23c,_0x5e8753[_0x9268('0x4d')]);return _0x437218[_0x9268('0x9c')](_0x14a23c);}})[_0x9268('0x2a')](function(_0x5b5c4b){if(_0x5b5c4b){_0x40ad48=_0x5b5c4b[_0x9268('0x45')];if(!_0x5e8753[_0x9268('0x41')][_0x9268('0x46')](_0x9268('0x64'))){_0x14a23c['limit']=qs[_0x9268('0x23')](_0x5e8753[_0x9268('0x41')][_0x9268('0x23')]);_0x14a23c[_0x9268('0x20')]=qs[_0x9268('0x20')](_0x5e8753['query'][_0x9268('0x20')]);}return _0x437218[_0x9268('0x9c')](_0x14a23c);}})[_0x9268('0x2a')](function(_0x80ebb3){if(_0x80ebb3){return _0x80ebb3?{'count':_0x40ad48,'rows':_0x80ebb3}:null;}})[_0x9268('0x2a')](respondWithResult(_0x3a1ef2,null))[_0x9268('0x50')](handleError(_0x3a1ef2,null));};exports[_0x9268('0x9d')]=function(_0x4ec6fd,_0x3d1d76,_0x556052){var _0x3172aa,_0x435251;return db[_0x9268('0x3c')][_0x9268('0x36')]({'where':{'id':_0x4ec6fd[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x3d1d76,null))['then'](function(_0x18df3e){if(_0x18df3e){_0x435251=_0x18df3e;return _0x18df3e[_0x9268('0x9d')](_0x4ec6fd['body']['ids'],_[_0x9268('0x5f')](_0x4ec6fd['body'],[_0x9268('0x83'),'id'])||{});}return null;})[_0x9268('0x9e')](function(_0x2460e6){var _0x1364d0;_0x3172aa=_0x2460e6||[];var _0x295785=[];if(_0x2460e6){for(var _0x2227d7=0x0;_0x2227d7<_0x2460e6['length'];_0x2227d7+=0x1){var _0x275b63=_0x2460e6[_0x2227d7][_0x9268('0x56')]({'plain':!![]});_0x435251[_0x9268('0x9f')]=_0x4ec6fd[_0x9268('0x5e')][_0x9268('0x9f')]?_0x4ec6fd[_0x9268('0x5e')][_0x9268('0x9f')]:_0x435251[_0x9268('0x9f')];switch(_0x435251[_0x9268('0x9f')]){case _0x9268('0xa0'):_0x1364d0=squel['insert']()[_0x9268('0xa1')](_0x9268('0xa2'))[_0x9268('0xa3')]([_0x9268('0xa4'),_0x9268('0xa5'),_0x9268('0xa6'),'ListId',_0x9268('0x66'),'createdAt','updatedAt'],squel[_0x9268('0x85')]()[_0x9268('0x86')](_0x9268('0xa4'),_0x9268('0xa4'))['field'](_0x9268('0xa7'),'scheduledAt')['field']('id',_0x9268('0xa6'))[_0x9268('0x86')](_0x275b63[_0x9268('0xa8')][_0x9268('0x8f')](),_0x9268('0xa9'))[_0x9268('0x86')](_0x4ec6fd[_0x9268('0x52')]['id'][_0x9268('0x8f')](),_0x9268('0x66'))[_0x9268('0x86')]('NOW()','createdAt')['field']('NOW()',_0x9268('0x5d'))[_0x9268('0x88')](_0x9268('0xaa'))[_0x9268('0x4a')](_0x9268('0xab'))[_0x9268('0x4a')](_0x9268('0xac'),_0x275b63[_0x9268('0xa8')][_0x9268('0x8f')]())[_0x9268('0x4a')](_0x9268('0xad'))[_0x9268('0x4a')](_0x9268('0xae'),squel[_0x9268('0x85')]()['field'](_0x9268('0xaf'))[_0x9268('0x88')]('cm_hopper_final')[_0x9268('0x4a')]('VoiceQueueId\x20=\x20?',_0x4ec6fd[_0x9268('0x52')]['id']['toString']()))[_0x9268('0x4a')](_0x9268('0xae'),squel[_0x9268('0x85')]()[_0x9268('0x86')]('COALESCE(phone,\x27\x27)')[_0x9268('0x88')](_0x9268('0xa2'))[_0x9268('0x4a')](_0x9268('0x8d'),_0x4ec6fd[_0x9268('0x52')]['id'][_0x9268('0x8f')]())))[_0x9268('0x8f')]();break;case _0x9268('0xb0'):_0x1364d0=squel[_0x9268('0xb1')]()[_0x9268('0xa1')](_0x9268('0xa2'))[_0x9268('0xa3')]([_0x9268('0xa4'),_0x9268('0xa5'),_0x9268('0xa6'),_0x9268('0xa9'),_0x9268('0x66'),_0x9268('0xb2'),_0x9268('0x5d')],squel[_0x9268('0x85')]()[_0x9268('0x86')](_0x9268('0xa4'),_0x9268('0xa4'))[_0x9268('0x86')]('NOW()',_0x9268('0xa5'))['field']('id','ContactId')['field'](_0x275b63['CmListId'][_0x9268('0x8f')](),_0x9268('0xa9'))[_0x9268('0x86')](_0x4ec6fd[_0x9268('0x52')]['id'][_0x9268('0x8f')](),_0x9268('0x66'))[_0x9268('0x86')](_0x9268('0xa7'),'createdAt')[_0x9268('0x86')](_0x9268('0xa7'),_0x9268('0x5d'))[_0x9268('0x88')](_0x9268('0xaa'))[_0x9268('0x4a')](_0x9268('0xab'))[_0x9268('0x4a')](_0x9268('0xac'),_0x275b63['CmListId']['toString']())['where'](_0x9268('0xad'))[_0x9268('0x4a')](_0x9268('0xae'),squel[_0x9268('0x85')]()['field'](_0x9268('0xb3'))[_0x9268('0x88')]('cm_hopper')['where'](_0x9268('0x8d'),_0x4ec6fd[_0x9268('0x52')]['id'][_0x9268('0x8f')]())))['toString']();break;default:_0x1364d0=squel[_0x9268('0xb1')]()['into'](_0x9268('0xa2'))['fromQuery']([_0x9268('0xa4'),_0x9268('0xa5'),'ContactId',_0x9268('0xa9'),'VoiceQueueId',_0x9268('0xb2'),_0x9268('0x5d')],squel[_0x9268('0x85')]()[_0x9268('0x86')](_0x9268('0xa4'),_0x9268('0xa4'))[_0x9268('0x86')](_0x9268('0xa7'),_0x9268('0xa5'))[_0x9268('0x86')]('id',_0x9268('0xa6'))[_0x9268('0x86')](_0x275b63[_0x9268('0xa8')][_0x9268('0x8f')](),'ListId')[_0x9268('0x86')](_0x4ec6fd[_0x9268('0x52')]['id'][_0x9268('0x8f')](),_0x9268('0x66'))[_0x9268('0x86')](_0x9268('0xa7'),'createdAt')['field'](_0x9268('0xa7'),_0x9268('0x5d'))[_0x9268('0x88')](_0x9268('0xaa'))[_0x9268('0x4a')](_0x9268('0xab'))['where'](_0x9268('0xac'),_0x275b63[_0x9268('0xa8')][_0x9268('0x8f')]())[_0x9268('0x4a')](_0x9268('0xad')))['toString']();}_0x295785[_0x9268('0x97')](db[_0x9268('0x76')][_0x9268('0x41')](_0x1364d0));}return BPromise['all'](_0x295785);}})[_0x9268('0x2a')](function(){return _0x3172aa;})[_0x9268('0x2a')](respondWithResult(_0x3d1d76,null))[_0x9268('0x50')](handleError(_0x3d1d76,null));};exports[_0x9268('0xb4')]=function(_0x3f2c54,_0xb08891,_0x27caa0){return db[_0x9268('0x3c')][_0x9268('0x36')]({'where':{'id':_0x3f2c54['params']['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0xb08891,null))[_0x9268('0x2a')](function(_0x5f5973){if(_0x5f5973){return _0x5f5973[_0x9268('0xb4')](_0x3f2c54['query']['ids']);}})[_0x9268('0x2a')](function(_0x2c014c){if(_0x2c014c){return db[_0x9268('0x63')][_0x9268('0x2b')]({'where':{'ListId':_0x3f2c54['query'][_0x9268('0x83')],'VoiceQueueId':_0x3f2c54[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](function(){return _0x2c014c;});}})['then'](respondWithStatusCode(_0xb08891,null))[_0x9268('0x50')](handleError(_0xb08891,null));};exports[_0x9268('0xb5')]=function(_0x39958d,_0x4e09e7,_0x228b02){var _0xdf4b07={};var _0x63e3cf={};var _0x187771;var _0x3771e1;return db[_0x9268('0x3c')]['findOne']({'where':{'id':_0x39958d[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x4e09e7,null))[_0x9268('0x2a')](function(_0x12edc2){if(_0x12edc2){_0x187771=_0x12edc2;_0x63e3cf[_0x9268('0x40')]=_[_0x9268('0x53')](db[_0x9268('0x9b')][_0x9268('0x3d')]);_0x63e3cf['query']=_[_0x9268('0x53')](_0x39958d[_0x9268('0x41')]);_0x63e3cf[_0x9268('0x49')]=_['intersection'](_0x63e3cf[_0x9268('0x40')],_0x63e3cf[_0x9268('0x41')]);_0xdf4b07[_0x9268('0x42')]=_['intersection'](_0x63e3cf[_0x9268('0x40')],qs[_0x9268('0x44')](_0x39958d[_0x9268('0x41')]['fields']));_0xdf4b07[_0x9268('0x42')]=_0xdf4b07[_0x9268('0x42')][_0x9268('0x45')]?_0xdf4b07['attributes']:_0x63e3cf[_0x9268('0x40')];_0xdf4b07[_0x9268('0x47')]=qs[_0x9268('0x48')](_0x39958d[_0x9268('0x41')]['sort']);_0xdf4b07[_0x9268('0x4a')]=qs[_0x9268('0x49')](_[_0x9268('0x65')](_0x39958d[_0x9268('0x41')],_0x63e3cf[_0x9268('0x49')]));if(_0x39958d[_0x9268('0x41')][_0x9268('0x30')]){_0xdf4b07['where']=_['merge'](_0xdf4b07[_0x9268('0x4a')],{'$or':_[_0x9268('0x32')](_0xdf4b07[_0x9268('0x42')],function(_0xe5853c){var _0x15fc31={};_0x15fc31[_0xe5853c]={'$like':'%'+_0x39958d['query'][_0x9268('0x30')]+'%'};return _0x15fc31;})});}_0xdf4b07=_['merge']({},_0xdf4b07,_0x39958d[_0x9268('0x4d')]);return _0x187771['getBlackLists'](_0xdf4b07);}})[_0x9268('0x2a')](function(_0x2b4869){if(_0x2b4869){_0x3771e1=_0x2b4869[_0x9268('0x45')];if(!_0x39958d['query']['hasOwnProperty']('nolimit')){_0xdf4b07[_0x9268('0x23')]=qs[_0x9268('0x23')](_0x39958d[_0x9268('0x41')][_0x9268('0x23')]);_0xdf4b07[_0x9268('0x20')]=qs[_0x9268('0x20')](_0x39958d[_0x9268('0x41')][_0x9268('0x20')]);}return _0x187771[_0x9268('0xb5')](_0xdf4b07);}})[_0x9268('0x2a')](function(_0x4a5c65){if(_0x4a5c65){return _0x4a5c65?{'count':_0x3771e1,'rows':_0x4a5c65}:null;}})[_0x9268('0x2a')](respondWithResult(_0x4e09e7,null))[_0x9268('0x50')](handleError(_0x4e09e7,null));};exports[_0x9268('0xb6')]=function(_0xf1694c,_0x543e63,_0x4ab7f5){var _0x40baf0,_0x3164bb;return db['VoiceQueue'][_0x9268('0x36')]({'where':{'id':_0xf1694c[_0x9268('0x52')]['id']}})['then'](handleEntityNotFound(_0x543e63,null))[_0x9268('0x2a')](function(_0x43e938){if(_0x43e938){_0x3164bb=_0x43e938;return _0x43e938[_0x9268('0xb6')](_0xf1694c[_0x9268('0x5e')]['ids'],_[_0x9268('0x5f')](_0xf1694c[_0x9268('0x5e')],[_0x9268('0x83'),'id'])||{});}return null;})[_0x9268('0x9e')](function(_0x35590b){var _0x401d3c;_0x40baf0=_0x35590b||[];var _0x5c64e7=[];if(_0x35590b){for(var _0x45d060=0x0;_0x45d060<_0x35590b[_0x9268('0x45')];_0x45d060+=0x1){var _0x5f4d81=_0x35590b[_0x45d060][_0x9268('0x56')]({'plain':!![]});_0x401d3c=squel[_0x9268('0xb1')]()[_0x9268('0xa1')]('cm_hopper_black')['fromQuery'](['phone',_0x9268('0xa6'),_0x9268('0xa9'),_0x9268('0x66'),_0x9268('0xb2'),_0x9268('0x5d')],squel[_0x9268('0x85')]()[_0x9268('0x86')]('phone',_0x9268('0xa4'))[_0x9268('0x86')]('id',_0x9268('0xa6'))[_0x9268('0x86')](_0x5f4d81[_0x9268('0xa8')]['toString'](),_0x9268('0xa9'))[_0x9268('0x86')](_0xf1694c[_0x9268('0x52')]['id'][_0x9268('0x8f')](),_0x9268('0x66'))['field']('NOW()',_0x9268('0xb2'))[_0x9268('0x86')](_0x9268('0xa7'),_0x9268('0x5d'))[_0x9268('0x88')](_0x9268('0xaa'))['where'](_0x9268('0xab'))[_0x9268('0x4a')](_0x9268('0xac'),_0x5f4d81[_0x9268('0xa8')][_0x9268('0x8f')]())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x9268('0x8f')]();_0x5c64e7[_0x9268('0x97')](db[_0x9268('0x76')][_0x9268('0x41')](_0x401d3c));}return BPromise['all'](_0x5c64e7);}})[_0x9268('0x2a')](function(){return _0x40baf0;})['then'](respondWithResult(_0x543e63,null))[_0x9268('0x50')](handleError(_0x543e63,null));};exports[_0x9268('0xb7')]=function(_0xfaa947,_0x3d26f2,_0x173992){return db[_0x9268('0x3c')]['find']({'where':{'id':_0xfaa947[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](handleEntityNotFound(_0x3d26f2,null))['then'](function(_0x152881){if(_0x152881){return _0x152881['removeBlackLists'](_0xfaa947[_0x9268('0x41')][_0x9268('0x83')]);}})[_0x9268('0x2a')](function(_0x1de925){if(_0x1de925){return db[_0x9268('0x6d')]['destroy']({'where':{'ListId':_0xfaa947[_0x9268('0x41')][_0x9268('0x83')],'VoiceQueueId':_0xfaa947[_0x9268('0x52')]['id']}})[_0x9268('0x2a')](function(){return _0x1de925;});}})['then'](respondWithStatusCode(_0x3d26f2,null))['catch'](handleError(_0x3d26f2,null));};
\ No newline at end of file