Built motion from commit 47436d59.|2.6.7

[motion2.git] / server / api / voiceQueue / voiceQueue.controller.js

diff --git a/server/api/voiceQueue/voiceQueue.controller.js b/server/api/voiceQueue/voiceQueue.controller.js
index 57a5108..221a0a1 100644 (file)
--- a/server/api/voiceQueue/voiceQueue.controller.js
+++ b/server/api/voiceQueue/voiceQueue.controller.js
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x2ebf=['to-csv','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','../../config/environment','../../config/license/util','redis','localhost','socket.io-emitter','sendStatus','status','end','offset','undefined','count','limit','set','json','apply','reject','save','update','then','destroy','get','VoiceQueues','inbound','QueueCampaigns','outbound','map','value','includes','type','name','error','stack','send','rawAttributes','fieldName','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','pick','filter','where','merge','VIRTUAL','includeAll','include','VoiceQueue','params','keys','options','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','find','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','catch','omit','createdAt','updatedAt','getHoppers','findOne','sort','VoiceQueueId','CmHopper','getHopperHistories','CmHopperHistory','order','findAll','rows','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','User','Agents','online','voicePause','interface','flatMap','forEach','penalty','sequelize','transaction','addTeams','each','findOrCreate','UserVoiceQueueRt','upsert','format','SIP/%s','emit','userVoiceQueue:save','ids','field','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','TeamId','union','compact','removeTeams','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','isNil','all','isArray','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','insert','cm_hopper','fromQuery','phone','scheduledAt','ContactId','NOW()','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)','onlyIfOpen','select','ListId\x20=\x20?','into','removeLists','getBlackLists','cm_hopper_black','removeBlackLists','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','ejs','squel','crypto','jsforce','desk.js'];(function(_0x251d9c,_0x580977){var _0x16ae64=function(_0x4d3b53){while(--_0x4d3b53){_0x251d9c['push'](_0x251d9c['shift']());}};_0x16ae64(++_0x580977);}(_0x2ebf,0x153));var _0xf2eb=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x2ebf[_0x3dd15e];return _0x231fd0;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xf2eb('0x0'));var zipdir=require(_0xf2eb('0x1'));var jsonpatch=require(_0xf2eb('0x2'));var rp=require(_0xf2eb('0x3'));var moment=require('moment');var BPromise=require(_0xf2eb('0x4'));var Mustache=require(_0xf2eb('0x5'));var util=require('util');var path=require(_0xf2eb('0x6'));var sox=require(_0xf2eb('0x7'));var csv=require('to-csv');var ejs=require(_0xf2eb('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0xf2eb('0x9'));var crypto=require(_0xf2eb('0xa'));var jsforce=require(_0xf2eb('0xb'));var deskjs=require(_0xf2eb('0xc'));var toCsv=require(_0xf2eb('0xd'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xf2eb('0xe'));var authService=require(_0xf2eb('0xf'));var qs=require(_0xf2eb('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xf2eb('0x11'))('api');var utils=require('../../config/utils');var config=require(_0xf2eb('0x12'));var licenseUtil=require(_0xf2eb('0x13'));var db=require('../../mysqldb')['db'];config[_0xf2eb('0x14')]=_['defaults'](config['redis'],{'host':_0xf2eb('0x15'),'port':0x18eb});var socket=require(_0xf2eb('0x16'))(new Redis(config[_0xf2eb('0x14')]));require('./voiceQueue.socket')['register'](socket);function respondWithStatusCode(_0x5a9923,_0x2a7e79){_0x2a7e79=_0x2a7e79||0xcc;return function(_0x4f76cb){if(_0x4f76cb){return _0x5a9923[_0xf2eb('0x17')](_0x2a7e79);}return _0x5a9923[_0xf2eb('0x18')](_0x2a7e79)[_0xf2eb('0x19')]();};}function respondWithResult(_0x44f718,_0x47e24e){_0x47e24e=_0x47e24e||0xc8;return function(_0x2252b5){if(_0x2252b5){return _0x44f718[_0xf2eb('0x18')](_0x47e24e)['json'](_0x2252b5);}};}function respondWithFilteredResult(_0x3c5857,_0x581857){return function(_0x29dc76){if(_0x29dc76){var _0x56fd8d=typeof _0x581857[_0xf2eb('0x1a')]==='undefined'&&typeof _0x581857['limit']===_0xf2eb('0x1b');var _0x5e073f=_0x29dc76['count'];var _0x1609ee=_0x56fd8d?0x0:_0x581857[_0xf2eb('0x1a')];var _0x500f58=_0x56fd8d?_0x29dc76[_0xf2eb('0x1c')]:_0x581857[_0xf2eb('0x1a')]+_0x581857[_0xf2eb('0x1d')];var _0x4f83ec;if(_0x500f58>=_0x5e073f){_0x500f58=_0x5e073f;_0x4f83ec=0xc8;}else{_0x4f83ec=0xce;}_0x3c5857[_0xf2eb('0x18')](_0x4f83ec);return _0x3c5857[_0xf2eb('0x1e')]('Content-Range',_0x1609ee+'-'+_0x500f58+'/'+_0x5e073f)[_0xf2eb('0x1f')](_0x29dc76);}return null;};}function patchUpdates(_0x253e1a){return function(_0x472517){try{jsonpatch[_0xf2eb('0x20')](_0x472517,_0x253e1a,!![]);}catch(_0x33e785){return BPromise[_0xf2eb('0x21')](_0x33e785);}return _0x472517[_0xf2eb('0x22')]();};}function saveUpdates(_0x33e595,_0x4919b8){return function(_0x4ead05){if(_0x4ead05){return _0x4ead05[_0xf2eb('0x23')](_0x33e595)[_0xf2eb('0x24')](function(_0x4efc95){return _0x4efc95;});}return null;};}function removeEntity(_0x771623,_0x57f120){return function(_0x54b076){if(_0x54b076){return _0x54b076[_0xf2eb('0x25')]()[_0xf2eb('0x24')](function(){var _0x4d8359=_0x54b076[_0xf2eb('0x26')]({'plain':!![]});var _0x5dc675=[{'name':_0xf2eb('0x27'),'value':_0xf2eb('0x28'),'ignore':![]},{'name':_0xf2eb('0x29'),'value':_0xf2eb('0x2a'),'ignore':![]}];var _0x281d06=_(_0x5dc675)['filter']('ignore')[_0xf2eb('0x2b')](_0xf2eb('0x2c'))[_0xf2eb('0x2c')]();if(_[_0xf2eb('0x2d')](_0x281d06,_0x4d8359['type'])){return;}var _0x11a2e5=_['find'](_0x5dc675,[_0xf2eb('0x2c'),_0x4d8359[_0xf2eb('0x2e')]])[_0xf2eb('0x2f')];return db['UserProfileResource']['destroy']({'where':{'type':_0x11a2e5,'resourceId':_0x4d8359['id']}})['then'](function(){return _0x54b076;});})[_0xf2eb('0x24')](function(){_0x771623[_0xf2eb('0x18')](0xcc)[_0xf2eb('0x19')]();});}};}function handleEntityNotFound(_0x5de148,_0x12e26c){return function(_0x14cc25){if(!_0x14cc25){_0x5de148[_0xf2eb('0x17')](0x194);}return _0x14cc25;};}function handleError(_0x5694ba,_0x32c84b){_0x32c84b=_0x32c84b||0x1f4;return function(_0x598cc1){logger[_0xf2eb('0x30')](_0x598cc1[_0xf2eb('0x31')]);if(_0x598cc1[_0xf2eb('0x2f')]){delete _0x598cc1['name'];}_0x5694ba[_0xf2eb('0x18')](_0x32c84b)[_0xf2eb('0x32')](_0x598cc1);};}exports['index']=function(_0x20fdfc,_0x5d60c4){var _0x6bf346={},_0x2d1cf4={},_0x44a3ac={'count':0x0,'rows':[]};var _0x40156c=_[_0xf2eb('0x2b')](db['VoiceQueue'][_0xf2eb('0x33')],function(_0x5690b5){return{'name':_0x5690b5[_0xf2eb('0x34')],'type':_0x5690b5[_0xf2eb('0x2e')]['key']};});_0x2d1cf4[_0xf2eb('0x35')]=_[_0xf2eb('0x2b')](_0x40156c,_0xf2eb('0x2f'));_0x2d1cf4[_0xf2eb('0x36')]=_['keys'](_0x20fdfc[_0xf2eb('0x36')]);_0x2d1cf4[_0xf2eb('0x37')]=_[_0xf2eb('0x38')](_0x2d1cf4[_0xf2eb('0x35')],_0x2d1cf4[_0xf2eb('0x36')]);_0x6bf346[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x2d1cf4[_0xf2eb('0x35')],qs['fields'](_0x20fdfc[_0xf2eb('0x36')][_0xf2eb('0x3a')]));_0x6bf346[_0xf2eb('0x39')]=_0x6bf346[_0xf2eb('0x39')][_0xf2eb('0x3b')]?_0x6bf346['attributes']:_0x2d1cf4[_0xf2eb('0x35')];if(!_0x20fdfc[_0xf2eb('0x36')][_0xf2eb('0x3c')](_0xf2eb('0x3d'))){_0x6bf346[_0xf2eb('0x1d')]=qs[_0xf2eb('0x1d')](_0x20fdfc[_0xf2eb('0x36')][_0xf2eb('0x1d')]);_0x6bf346['offset']=qs['offset'](_0x20fdfc[_0xf2eb('0x36')]['offset']);}_0x6bf346['order']=qs['sort'](_0x20fdfc[_0xf2eb('0x36')]['sort']);_0x6bf346['where']=qs[_0xf2eb('0x37')](_[_0xf2eb('0x3e')](_0x20fdfc[_0xf2eb('0x36')],_0x2d1cf4[_0xf2eb('0x37')]),_0x40156c);if(_0x20fdfc[_0xf2eb('0x36')][_0xf2eb('0x3f')]){_0x6bf346[_0xf2eb('0x40')]=_[_0xf2eb('0x41')](_0x6bf346['where'],{'$or':_[_0xf2eb('0x2b')](_0x40156c,function(_0x1c7171){if(_0x1c7171[_0xf2eb('0x2e')]!==_0xf2eb('0x42')){var _0x351aa5={};_0x351aa5[_0x1c7171[_0xf2eb('0x2f')]]={'$like':'%'+_0x20fdfc['query'][_0xf2eb('0x3f')]+'%'};return _0x351aa5;}})});}_0x6bf346=_[_0xf2eb('0x41')]({},_0x6bf346,_0x20fdfc['options']);var _0xd713ac={'where':_0x6bf346[_0xf2eb('0x40')]};return db['VoiceQueue'][_0xf2eb('0x1c')](_0xd713ac)[_0xf2eb('0x24')](function(_0x578b3b){_0x44a3ac[_0xf2eb('0x1c')]=_0x578b3b;if(_0x20fdfc['query'][_0xf2eb('0x43')]){_0x6bf346[_0xf2eb('0x44')]=[{'all':!![]}];}return db[_0xf2eb('0x45')]['findAll'](_0x6bf346);})[_0xf2eb('0x24')](function(_0x55c10b){_0x44a3ac['rows']=_0x55c10b;return _0x44a3ac;})[_0xf2eb('0x24')](respondWithFilteredResult(_0x5d60c4,_0x6bf346))['catch'](handleError(_0x5d60c4,null));};exports['show']=function(_0x5448b1,_0x15e271){var _0x5a4312={'raw':![],'where':{'id':_0x5448b1[_0xf2eb('0x46')]['id']}},_0x3c5627={};_0x3c5627['model']=_[_0xf2eb('0x47')](db[_0xf2eb('0x45')][_0xf2eb('0x33')]);_0x3c5627[_0xf2eb('0x36')]=_[_0xf2eb('0x47')](_0x5448b1[_0xf2eb('0x36')]);_0x3c5627['filters']=_[_0xf2eb('0x38')](_0x3c5627['model'],_0x3c5627['query']);_0x5a4312[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x3c5627['model'],qs[_0xf2eb('0x3a')](_0x5448b1['query']['fields']));_0x5a4312['attributes']=_0x5a4312[_0xf2eb('0x39')]['length']?_0x5a4312[_0xf2eb('0x39')]:_0x3c5627[_0xf2eb('0x35')];if(_0x5448b1[_0xf2eb('0x36')][_0xf2eb('0x43')]){_0x5a4312[_0xf2eb('0x44')]=[{'all':!![]}];}_0x5a4312=_[_0xf2eb('0x41')]({},_0x5a4312,_0x5448b1[_0xf2eb('0x48')]);return db[_0xf2eb('0x45')]['find'](_0x5a4312)[_0xf2eb('0x24')](handleEntityNotFound(_0x15e271,null))[_0xf2eb('0x24')](respondWithResult(_0x15e271,null))['catch'](handleError(_0x15e271,null));};exports[_0xf2eb('0x49')]=function(_0x4c799d,_0x447c02){return db['VoiceQueue'][_0xf2eb('0x49')](_0x4c799d[_0xf2eb('0x4a')],{})[_0xf2eb('0x24')](function(_0x1684c0){var _0x584770=_0x4c799d[_0xf2eb('0x4b')][_0xf2eb('0x26')]({'plain':!![]});if(!_0x584770)throw new Error(_0xf2eb('0x4c'));if(_0x584770['role']===_0xf2eb('0x4b')){var _0x5d832e=_0x1684c0[_0xf2eb('0x26')]({'plain':!![]});var _0x36e4df=[{'name':'VoiceQueues','value':_0xf2eb('0x28')},{'name':_0xf2eb('0x29'),'value':_0xf2eb('0x2a')}];var _0x423685=_[_0xf2eb('0x4d')](_0x36e4df,[_0xf2eb('0x2c'),_0x5d832e[_0xf2eb('0x2e')]])[_0xf2eb('0x2f')];return db[_0xf2eb('0x4e')][_0xf2eb('0x4d')]({'where':{'name':_0x423685,'userProfileId':_0x584770['userProfileId']},'raw':!![]})['then'](function(_0x5f0ef5){if(_0x5f0ef5&&_0x5f0ef5[_0xf2eb('0x4f')]===0x0){return db['UserProfileResource'][_0xf2eb('0x49')]({'name':_0x5d832e[_0xf2eb('0x2f')],'resourceId':_0x5d832e['id'],'type':_0x5f0ef5[_0xf2eb('0x2f')],'sectionId':_0x5f0ef5['id']},{})[_0xf2eb('0x24')](function(){return _0x1684c0;});}else{return _0x1684c0;}})['catch'](function(_0x92a70c){logger[_0xf2eb('0x30')](_0xf2eb('0x50'),_0x92a70c);throw _0x92a70c;});}return _0x1684c0;})[_0xf2eb('0x24')](respondWithResult(_0x447c02,0xc9))[_0xf2eb('0x51')](handleError(_0x447c02,null));};exports['clone']=function(_0x1f5556,_0x2874cf){var _0x425ec0={'where':{'id':_0x1f5556['params']['id']}},_0x5032c6={};_0x5032c6[_0xf2eb('0x35')]=_[_0xf2eb('0x47')](db[_0xf2eb('0x45')][_0xf2eb('0x33')]);_0x425ec0['attributes']=_[_0xf2eb('0x38')](_0x5032c6[_0xf2eb('0x35')],qs[_0xf2eb('0x3a')](_0x1f5556['query'][_0xf2eb('0x3a')]));_0x425ec0[_0xf2eb('0x39')]=_0x425ec0[_0xf2eb('0x39')][_0xf2eb('0x3b')]?_0x425ec0[_0xf2eb('0x39')]:_0x5032c6[_0xf2eb('0x35')];if(_0x1f5556[_0xf2eb('0x36')]['includeAll']){_0x425ec0[_0xf2eb('0x44')]=[{'all':!![]}];}_0x425ec0=_[_0xf2eb('0x41')]({},_0x425ec0,_0x1f5556[_0xf2eb('0x48')]);return db['VoiceQueue'][_0xf2eb('0x4d')](_0x425ec0)[_0xf2eb('0x24')](handleEntityNotFound(_0x2874cf,null))[_0xf2eb('0x24')](function(_0x2ead71){if(_0x2ead71){var _0x500147=_0x2ead71[_0xf2eb('0x26')]({'plain':!![]});_0x500147=qs[_0xf2eb('0x52')](_0x500147,['id',_0xf2eb('0x53'),_0xf2eb('0x54')]);_0x1f5556[_0xf2eb('0x4a')]=_[_0xf2eb('0x52')](_0x1f5556[_0xf2eb('0x4a')],['id',_0xf2eb('0x53'),_0xf2eb('0x54')]);return db[_0xf2eb('0x45')][_0xf2eb('0x49')](_['merge'](_0x500147,_0x1f5556['body']),{'include':_0x1f5556[_0xf2eb('0x36')][_0xf2eb('0x43')]?[{'all':!![]}]:undefined})[_0xf2eb('0x24')](function(_0x200981){var _0x326a5d=_0x1f5556['user']['get']({'plain':!![]});if(!_0x326a5d)throw new Error(_0xf2eb('0x4c'));if(_0x326a5d['role']===_0xf2eb('0x4b')){var _0x4242a2=_0x200981[_0xf2eb('0x26')]({'plain':!![]});var _0x1551e4=[{'name':_0xf2eb('0x27'),'value':_0xf2eb('0x28')},{'name':_0xf2eb('0x29'),'value':_0xf2eb('0x2a')}];var _0x3273f2=_[_0xf2eb('0x4d')](_0x1551e4,['value',_0x4242a2[_0xf2eb('0x2e')]])[_0xf2eb('0x2f')];return db[_0xf2eb('0x4e')]['find']({'where':{'name':_0x3273f2,'userProfileId':_0x326a5d['userProfileId']},'raw':!![]})[_0xf2eb('0x24')](function(_0x328202){if(_0x328202&&_0x328202[_0xf2eb('0x4f')]===0x0){return db['UserProfileResource'][_0xf2eb('0x49')]({'name':_0x4242a2[_0xf2eb('0x2f')],'resourceId':_0x4242a2['id'],'type':_0x328202[_0xf2eb('0x2f')],'sectionId':_0x328202['id']},{})[_0xf2eb('0x24')](function(){return _0x200981;});}else{return _0x200981;}})[_0xf2eb('0x51')](function(_0x3a5afe){logger['error'](_0xf2eb('0x50'),_0x3a5afe);throw _0x3a5afe;});}return _0x200981;});}})[_0xf2eb('0x24')](respondWithResult(_0x2874cf,0xc9))[_0xf2eb('0x51')](handleError(_0x2874cf,null));};exports[_0xf2eb('0x23')]=function(_0x3361fc,_0x38273a){if(_0x3361fc['body']['id']){delete _0x3361fc['body']['id'];}return db[_0xf2eb('0x45')][_0xf2eb('0x4d')]({'where':{'id':_0x3361fc[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x38273a,null))[_0xf2eb('0x24')](saveUpdates(_0x3361fc['body'],null))[_0xf2eb('0x24')](respondWithResult(_0x38273a,null))[_0xf2eb('0x51')](handleError(_0x38273a,null));};exports[_0xf2eb('0x25')]=function(_0x2b2afc,_0x15e9e4){return db['VoiceQueue'][_0xf2eb('0x4d')]({'where':{'id':_0x2b2afc[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x15e9e4,null))[_0xf2eb('0x24')](removeEntity(_0x15e9e4,null))[_0xf2eb('0x51')](handleError(_0x15e9e4,null));};exports[_0xf2eb('0x55')]=function(_0x50c029,_0x421cd1,_0x42818f){var _0x1dfb71={'raw':![],'where':{}};var _0x9c43ad={};var _0x3c501e={'count':0x0,'rows':[]};return db[_0xf2eb('0x45')][_0xf2eb('0x56')]({'where':{'id':_0x50c029[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x421cd1,null))[_0xf2eb('0x24')](function(_0x2f5e66){if(_0x2f5e66){_0x9c43ad[_0xf2eb('0x35')]=_[_0xf2eb('0x47')](db['CmHopper'][_0xf2eb('0x33')]);_0x9c43ad[_0xf2eb('0x36')]=_[_0xf2eb('0x47')](_0x50c029[_0xf2eb('0x36')]);_0x9c43ad['filters']=_[_0xf2eb('0x38')](_0x9c43ad[_0xf2eb('0x35')],_0x9c43ad['query']);_0x1dfb71[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x9c43ad[_0xf2eb('0x35')],qs['fields'](_0x50c029[_0xf2eb('0x36')][_0xf2eb('0x3a')]));_0x1dfb71[_0xf2eb('0x39')]=_0x1dfb71[_0xf2eb('0x39')]['length']?_0x1dfb71[_0xf2eb('0x39')]:_0x9c43ad[_0xf2eb('0x35')];if(!_0x50c029[_0xf2eb('0x36')]['hasOwnProperty']('nolimit')){_0x1dfb71[_0xf2eb('0x1d')]=qs[_0xf2eb('0x1d')](_0x50c029['query']['limit']);_0x1dfb71[_0xf2eb('0x1a')]=qs[_0xf2eb('0x1a')](_0x50c029[_0xf2eb('0x36')]['offset']);}_0x1dfb71['order']=qs[_0xf2eb('0x57')](_0x50c029[_0xf2eb('0x36')]['sort']);_0x1dfb71['where']=qs[_0xf2eb('0x37')](_[_0xf2eb('0x3e')](_0x50c029[_0xf2eb('0x36')],_0x9c43ad[_0xf2eb('0x37')]));_0x1dfb71['where'][_0xf2eb('0x58')]=_0x2f5e66['id'];if(_0x50c029[_0xf2eb('0x36')][_0xf2eb('0x3f')]){_0x1dfb71[_0xf2eb('0x40')]=_[_0xf2eb('0x41')](_0x1dfb71['where'],{'$or':_[_0xf2eb('0x2b')](_0x1dfb71['attributes'],function(_0x1e5a7c){var _0x95414a={};_0x95414a[_0x1e5a7c]={'$like':'%'+_0x50c029[_0xf2eb('0x36')][_0xf2eb('0x3f')]+'%'};return _0x95414a;})});}_0x1dfb71=_['merge']({},_0x1dfb71,_0x50c029[_0xf2eb('0x48')]);return db[_0xf2eb('0x59')][_0xf2eb('0x1c')]({'where':_0x1dfb71[_0xf2eb('0x40')]})['then'](function(_0x1f2a23){_0x3c501e[_0xf2eb('0x1c')]=_0x1f2a23;if(_0x50c029['query'][_0xf2eb('0x43')]){_0x1dfb71[_0xf2eb('0x44')]=[{'all':!![]}];}return db[_0xf2eb('0x59')]['findAll'](_0x1dfb71);})[_0xf2eb('0x24')](function(_0xdd027d){_0x3c501e['rows']=_0xdd027d;return _0x3c501e;});}})[_0xf2eb('0x24')](respondWithFilteredResult(_0x421cd1,_0x1dfb71))['catch'](handleError(_0x421cd1,null));};exports[_0xf2eb('0x5a')]=function(_0x270131,_0x368397,_0xd06ca1){var _0x1a19eb={'raw':!![],'where':{}};var _0x442731={};var _0x144b8f={'count':0x0,'rows':[]};return db[_0xf2eb('0x45')][_0xf2eb('0x56')]({'where':{'id':_0x270131[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x368397,null))[_0xf2eb('0x24')](function(_0x560142){if(_0x560142){_0x442731[_0xf2eb('0x35')]=_[_0xf2eb('0x47')](db[_0xf2eb('0x5b')][_0xf2eb('0x33')]);_0x442731[_0xf2eb('0x36')]=_[_0xf2eb('0x47')](_0x270131[_0xf2eb('0x36')]);_0x442731[_0xf2eb('0x37')]=_[_0xf2eb('0x38')](_0x442731[_0xf2eb('0x35')],_0x442731[_0xf2eb('0x36')]);_0x1a19eb[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x442731[_0xf2eb('0x35')],qs[_0xf2eb('0x3a')](_0x270131[_0xf2eb('0x36')][_0xf2eb('0x3a')]));_0x1a19eb[_0xf2eb('0x39')]=_0x1a19eb['attributes'][_0xf2eb('0x3b')]?_0x1a19eb[_0xf2eb('0x39')]:_0x442731['model'];if(!_0x270131[_0xf2eb('0x36')][_0xf2eb('0x3c')](_0xf2eb('0x3d'))){_0x1a19eb[_0xf2eb('0x1d')]=qs[_0xf2eb('0x1d')](_0x270131[_0xf2eb('0x36')][_0xf2eb('0x1d')]);_0x1a19eb[_0xf2eb('0x1a')]=qs[_0xf2eb('0x1a')](_0x270131[_0xf2eb('0x36')][_0xf2eb('0x1a')]);}_0x1a19eb[_0xf2eb('0x5c')]=qs[_0xf2eb('0x57')](_0x270131[_0xf2eb('0x36')][_0xf2eb('0x57')]);_0x1a19eb[_0xf2eb('0x40')]=qs['filters'](_['pick'](_0x270131['query'],_0x442731[_0xf2eb('0x37')]));_0x1a19eb[_0xf2eb('0x40')]['VoiceQueueId']=_0x560142['id'];if(_0x270131[_0xf2eb('0x36')]['filter']){_0x1a19eb[_0xf2eb('0x40')]=_['merge'](_0x1a19eb[_0xf2eb('0x40')],{'$or':_[_0xf2eb('0x2b')](_0x1a19eb[_0xf2eb('0x39')],function(_0x4e90dd){var _0x26e15b={};_0x26e15b[_0x4e90dd]={'$like':'%'+_0x270131[_0xf2eb('0x36')]['filter']+'%'};return _0x26e15b;})});}_0x1a19eb=_['merge']({},_0x1a19eb,_0x270131[_0xf2eb('0x48')]);return db[_0xf2eb('0x5b')][_0xf2eb('0x1c')]({'where':_0x1a19eb[_0xf2eb('0x40')]})[_0xf2eb('0x24')](function(_0x155f7a){_0x144b8f[_0xf2eb('0x1c')]=_0x155f7a;if(_0x270131[_0xf2eb('0x36')][_0xf2eb('0x43')]){_0x1a19eb[_0xf2eb('0x44')]=[{'all':!![]}];}return db[_0xf2eb('0x5b')][_0xf2eb('0x5d')](_0x1a19eb);})[_0xf2eb('0x24')](function(_0x49c312){_0x144b8f[_0xf2eb('0x5e')]=_0x49c312;return _0x144b8f;});}})[_0xf2eb('0x24')](respondWithFilteredResult(_0x368397,_0x1a19eb))[_0xf2eb('0x51')](handleError(_0x368397,null));};exports[_0xf2eb('0x5f')]=function(_0x3e8be1,_0x41936e,_0x194491){var _0x5045a3={'raw':!![],'where':{}};var _0x525cd4={};var _0x2bfb5e={'count':0x0,'rows':[]};return db[_0xf2eb('0x45')][_0xf2eb('0x56')]({'where':{'id':_0x3e8be1[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x41936e,null))[_0xf2eb('0x24')](function(_0x4cb6b9){if(_0x4cb6b9){_0x525cd4[_0xf2eb('0x35')]=_[_0xf2eb('0x47')](db[_0xf2eb('0x60')][_0xf2eb('0x33')]);_0x525cd4[_0xf2eb('0x36')]=_['keys'](_0x3e8be1['query']);_0x525cd4[_0xf2eb('0x37')]=_[_0xf2eb('0x38')](_0x525cd4[_0xf2eb('0x35')],_0x525cd4[_0xf2eb('0x36')]);_0x5045a3[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x525cd4[_0xf2eb('0x35')],qs[_0xf2eb('0x3a')](_0x3e8be1[_0xf2eb('0x36')]['fields']));_0x5045a3['attributes']=_0x5045a3[_0xf2eb('0x39')]['length']?_0x5045a3['attributes']:_0x525cd4['model'];if(!_0x3e8be1['query'][_0xf2eb('0x3c')](_0xf2eb('0x3d'))){_0x5045a3[_0xf2eb('0x1d')]=qs[_0xf2eb('0x1d')](_0x3e8be1['query']['limit']);_0x5045a3['offset']=qs[_0xf2eb('0x1a')](_0x3e8be1[_0xf2eb('0x36')][_0xf2eb('0x1a')]);}_0x5045a3['order']=qs['sort'](_0x3e8be1['query'][_0xf2eb('0x57')]);_0x5045a3[_0xf2eb('0x40')]=qs[_0xf2eb('0x37')](_[_0xf2eb('0x3e')](_0x3e8be1[_0xf2eb('0x36')],_0x525cd4['filters']));_0x5045a3[_0xf2eb('0x40')][_0xf2eb('0x58')]=_0x4cb6b9['id'];if(_0x3e8be1['query'][_0xf2eb('0x3f')]){_0x5045a3[_0xf2eb('0x40')]=_[_0xf2eb('0x41')](_0x5045a3['where'],{'$or':_['map'](_0x5045a3[_0xf2eb('0x39')],function(_0x6a365f){var _0x2e86db={};_0x2e86db[_0x6a365f]={'$like':'%'+_0x3e8be1[_0xf2eb('0x36')][_0xf2eb('0x3f')]+'%'};return _0x2e86db;})});}_0x5045a3=_[_0xf2eb('0x41')]({},_0x5045a3,_0x3e8be1[_0xf2eb('0x48')]);return db[_0xf2eb('0x60')][_0xf2eb('0x1c')]({'where':_0x5045a3[_0xf2eb('0x40')]})['then'](function(_0x341be8){_0x2bfb5e[_0xf2eb('0x1c')]=_0x341be8;if(_0x3e8be1['query'][_0xf2eb('0x43')]){_0x5045a3['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0xf2eb('0x5d')](_0x5045a3);})[_0xf2eb('0x24')](function(_0x2e1562){_0x2bfb5e[_0xf2eb('0x5e')]=_0x2e1562;return _0x2bfb5e;});}})[_0xf2eb('0x24')](respondWithFilteredResult(_0x41936e,_0x5045a3))[_0xf2eb('0x51')](handleError(_0x41936e,null));};exports[_0xf2eb('0x61')]=function(_0x57cf21,_0x58a951,_0x1af5fe){var _0xc84952={'raw':!![],'where':{}};var _0x3e4517={};var _0x4dc378={'count':0x0,'rows':[]};return db[_0xf2eb('0x45')][_0xf2eb('0x56')]({'where':{'id':_0x57cf21[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x58a951,null))[_0xf2eb('0x24')](function(_0x120eef){if(_0x120eef){_0x3e4517['model']=_['keys'](db[_0xf2eb('0x62')][_0xf2eb('0x33')]);_0x3e4517['query']=_[_0xf2eb('0x47')](_0x57cf21[_0xf2eb('0x36')]);_0x3e4517[_0xf2eb('0x37')]=_['intersection'](_0x3e4517['model'],_0x3e4517[_0xf2eb('0x36')]);_0xc84952[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x3e4517[_0xf2eb('0x35')],qs['fields'](_0x57cf21['query'][_0xf2eb('0x3a')]));_0xc84952['attributes']=_0xc84952['attributes']['length']?_0xc84952[_0xf2eb('0x39')]:_0x3e4517[_0xf2eb('0x35')];if(!_0x57cf21[_0xf2eb('0x36')]['hasOwnProperty'](_0xf2eb('0x3d'))){_0xc84952[_0xf2eb('0x1d')]=qs[_0xf2eb('0x1d')](_0x57cf21[_0xf2eb('0x36')][_0xf2eb('0x1d')]);_0xc84952[_0xf2eb('0x1a')]=qs[_0xf2eb('0x1a')](_0x57cf21[_0xf2eb('0x36')][_0xf2eb('0x1a')]);}_0xc84952[_0xf2eb('0x5c')]=qs[_0xf2eb('0x57')](_0x57cf21[_0xf2eb('0x36')]['sort']);_0xc84952[_0xf2eb('0x40')]=qs[_0xf2eb('0x37')](_[_0xf2eb('0x3e')](_0x57cf21[_0xf2eb('0x36')],_0x3e4517[_0xf2eb('0x37')]));_0xc84952[_0xf2eb('0x40')][_0xf2eb('0x58')]=_0x120eef['id'];if(_0x57cf21['query'][_0xf2eb('0x3f')]){_0xc84952[_0xf2eb('0x40')]=_[_0xf2eb('0x41')](_0xc84952['where'],{'$or':_[_0xf2eb('0x2b')](_0xc84952[_0xf2eb('0x39')],function(_0x40a420){var _0x3228d3={};_0x3228d3[_0x40a420]={'$like':'%'+_0x57cf21[_0xf2eb('0x36')][_0xf2eb('0x3f')]+'%'};return _0x3228d3;})});}_0xc84952=_[_0xf2eb('0x41')]({},_0xc84952,_0x57cf21[_0xf2eb('0x48')]);return db[_0xf2eb('0x62')]['count']({'where':_0xc84952[_0xf2eb('0x40')]})[_0xf2eb('0x24')](function(_0x87a350){_0x4dc378['count']=_0x87a350;if(_0x57cf21[_0xf2eb('0x36')]['includeAll']){_0xc84952[_0xf2eb('0x44')]=[{'all':!![]}];}return db[_0xf2eb('0x62')][_0xf2eb('0x5d')](_0xc84952);})[_0xf2eb('0x24')](function(_0x553054){_0x4dc378[_0xf2eb('0x5e')]=_0x553054;return _0x4dc378;});}})['then'](respondWithFilteredResult(_0x58a951,_0xc84952))[_0xf2eb('0x51')](handleError(_0x58a951,null));};exports[_0xf2eb('0x63')]=function(_0x49fc40,_0x252872,_0x18ebcc){var _0x57345a={};var _0x1d535b={};var _0x447435;var _0x353037;return db[_0xf2eb('0x45')]['findOne']({'where':{'id':_0x49fc40[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x252872,null))[_0xf2eb('0x24')](function(_0x3c2aba){if(_0x3c2aba){_0x447435=_0x3c2aba;_0x1d535b['model']=_['keys'](db['Team'][_0xf2eb('0x33')]);_0x1d535b[_0xf2eb('0x36')]=_[_0xf2eb('0x47')](_0x49fc40[_0xf2eb('0x36')]);_0x1d535b[_0xf2eb('0x37')]=_[_0xf2eb('0x38')](_0x1d535b[_0xf2eb('0x35')],_0x1d535b[_0xf2eb('0x36')]);_0x57345a[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x1d535b['model'],qs[_0xf2eb('0x3a')](_0x49fc40[_0xf2eb('0x36')]['fields']));_0x57345a[_0xf2eb('0x39')]=_0x57345a['attributes']['length']?_0x57345a[_0xf2eb('0x39')]:_0x1d535b[_0xf2eb('0x35')];_0x57345a['order']=qs[_0xf2eb('0x57')](_0x49fc40[_0xf2eb('0x36')][_0xf2eb('0x57')]);_0x57345a['where']=qs[_0xf2eb('0x37')](_['pick'](_0x49fc40[_0xf2eb('0x36')],_0x1d535b['filters']));if(_0x49fc40['query'][_0xf2eb('0x3f')]){_0x57345a[_0xf2eb('0x40')]=_[_0xf2eb('0x41')](_0x57345a[_0xf2eb('0x40')],{'$or':_['map'](_0x57345a[_0xf2eb('0x39')],function(_0xb1b96d){var _0x141af7={};_0x141af7[_0xb1b96d]={'$like':'%'+_0x49fc40['query'][_0xf2eb('0x3f')]+'%'};return _0x141af7;})});}_0x57345a=_['merge']({},_0x57345a,_0x49fc40[_0xf2eb('0x48')]);return _0x447435['getTeams'](_0x57345a);}})[_0xf2eb('0x24')](function(_0x1a2b94){if(_0x1a2b94){_0x353037=_0x1a2b94[_0xf2eb('0x3b')];if(!_0x49fc40[_0xf2eb('0x36')]['hasOwnProperty'](_0xf2eb('0x3d'))){_0x57345a['limit']=qs[_0xf2eb('0x1d')](_0x49fc40[_0xf2eb('0x36')]['limit']);_0x57345a[_0xf2eb('0x1a')]=qs[_0xf2eb('0x1a')](_0x49fc40[_0xf2eb('0x36')]['offset']);}return _0x447435['getTeams'](_0x57345a);}})[_0xf2eb('0x24')](function(_0x5f243a){if(_0x5f243a){return _0x5f243a?{'count':_0x353037,'rows':_0x5f243a}:null;}})[_0xf2eb('0x24')](respondWithResult(_0x252872,null))[_0xf2eb('0x51')](handleError(_0x252872,null));};exports['addTeams']=function(_0x31fba4,_0x2a983b,_0xfc446b){var _0x2c5dbe=_0x31fba4[_0xf2eb('0x4a')]['teams'];var _0x485db0=_[_0xf2eb('0x2b')](_0x2c5dbe,'id');return db[_0xf2eb('0x64')][_0xf2eb('0x5d')]({'where':{'id':_0x485db0},'attributes':['id'],'include':[{'model':db[_0xf2eb('0x65')],'as':_0xf2eb('0x66'),'attributes':['id','name',_0xf2eb('0x67'),_0xf2eb('0x68'),_0xf2eb('0x69')],'raw':!![]}]})[_0xf2eb('0x24')](function(_0x4a0846){if(_0x4a0846){var _0x34e749=_[_0xf2eb('0x6a')](_0x4a0846,function(_0x559f84){var _0xd2abe3=_0x559f84['get']({'plain':!![]});_0xd2abe3['Agents'][_0xf2eb('0x6b')](function(_0x5b6d35){_0x5b6d35[_0xf2eb('0x6c')]=_[_0xf2eb('0x4d')](_0x2c5dbe,{'id':_0xd2abe3['id']})[_0xf2eb('0x6c')];});return _0xd2abe3[_0xf2eb('0x66')];});return db[_0xf2eb('0x45')][_0xf2eb('0x4d')]({'where':{'id':_0x31fba4[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](function(_0x39f5c6){return db[_0xf2eb('0x6d')][_0xf2eb('0x6e')](function(_0x3626db){return _0x39f5c6[_0xf2eb('0x6f')](_0x485db0,{'transaction':_0x3626db})['then'](function(){return BPromise[_0xf2eb('0x70')](_0x2c5dbe,function(_0x123c4c){return db['TeamVoiceQueue']['upsert']({'TeamId':_0x123c4c['id'],'VoiceQueueId':_0x31fba4[_0xf2eb('0x46')]['id'],'penalty':_0x123c4c[_0xf2eb('0x6c')]},{'transaction':_0x3626db});});})['then'](function(){return BPromise['each'](_0x34e749,function(_0x25e2c8){return db['UserVoiceQueue'][_0xf2eb('0x71')]({'where':{'UserId':_0x25e2c8['id'],'VoiceQueueId':_0x31fba4[_0xf2eb('0x46')]['id']},'defaults':{'penalty':_0x25e2c8[_0xf2eb('0x6c')]},'transaction':_0x3626db});});})[_0xf2eb('0x24')](function(){return BPromise[_0xf2eb('0x70')](_['filter'](_0x34e749,{'online':!![]}),function(_0x3968c1){return db[_0xf2eb('0x72')][_0xf2eb('0x73')]({'membername':_0x3968c1[_0xf2eb('0x2f')],'UserId':_0x3968c1['id'],'queue_name':_0x39f5c6[_0xf2eb('0x2f')],'VoiceQueueId':_0x39f5c6['id'],'interface':_['isNil'](_0x3968c1[_0xf2eb('0x69')])?util[_0xf2eb('0x74')](_0xf2eb('0x75'),_0x3968c1[_0xf2eb('0x2f')]):_0x3968c1[_0xf2eb('0x69')],'paused':_0x3968c1[_0xf2eb('0x68')]||![],'penalty':_0x3968c1['penalty']},{'transaction':_0x3626db});});})[_0xf2eb('0x24')](function(){_0x34e749[_0xf2eb('0x6b')](function(_0x4b752c){socket[_0xf2eb('0x76')](_0xf2eb('0x77'),{'UserId':_0x4b752c['id'],'VoiceQueueId':_0x39f5c6['id']});});});});});}})['then'](respondWithStatusCode(_0x2a983b,null))[_0xf2eb('0x51')](handleError(_0x2a983b,null));};exports['removeTeams']=function(_0x225835,_0x1c786f,_0x540756){return db[_0xf2eb('0x64')][_0xf2eb('0x5d')]({'where':{'id':_0x225835[_0xf2eb('0x36')][_0xf2eb('0x78')]},'attributes':['id'],'include':[{'model':db[_0xf2eb('0x65')],'as':_0xf2eb('0x66'),'attributes':['id'],'raw':!![]}]})[_0xf2eb('0x24')](handleEntityNotFound(_0x1c786f,null))[_0xf2eb('0x24')](function(_0x1e8f5a){var _0x2e371f=_[_0xf2eb('0x2b')](_0x1e8f5a,'id');var _0x30e814=[];var _0x255511=[];var _0x57ba72=squel['select']();_0x57ba72[_0xf2eb('0x79')](_0xf2eb('0x7a'))[_0xf2eb('0x7b')](_0xf2eb('0x7c'),'tq')[_0xf2eb('0x7d')](_0xf2eb('0x7e'),'ut',_0xf2eb('0x7f'))[_0xf2eb('0x40')](_0xf2eb('0x80'),_0x225835[_0xf2eb('0x46')]['id']);for(var _0x56b674=0x0;_0x56b674<_0x1e8f5a[_0xf2eb('0x3b')];_0x56b674+=0x1){let _0x42a08f=_0x1e8f5a[_0x56b674];for(var _0xa40cd3=0x0;_0xa40cd3<_0x42a08f[_0xf2eb('0x66')][_0xf2eb('0x3b')];_0xa40cd3+=0x1){let _0x533f64=_0x42a08f[_0xf2eb('0x66')][_0xa40cd3];var _0x28c4d6=_0x57ba72[_0xf2eb('0x81')]();_0x28c4d6[_0xf2eb('0x40')](_0xf2eb('0x82'),_0x533f64['id']);_0x255511[_0xf2eb('0x83')](db[_0xf2eb('0x6d')][_0xf2eb('0x36')](_0x28c4d6[_0xf2eb('0x84')](),{'type':db[_0xf2eb('0x6d')][_0xf2eb('0x85')][_0xf2eb('0x86')]})[_0xf2eb('0x24')](function(_0x536cf1){if(_0x536cf1[_0xf2eb('0x3b')]===0x1){return _0x533f64['id'];}else{var _0x5aa63e=_['every'](_[_0xf2eb('0x2b')](_0x536cf1,_0xf2eb('0x87')),function(_0x22b908){return _[_0xf2eb('0x2d')](_0x2e371f,_0x22b908);});if(_0x5aa63e){return _0x533f64['id'];}}}));}}return BPromise['all'](_0x255511)[_0xf2eb('0x24')](function(_0x4360b3){_0x30e814=_(_0x30e814)[_0xf2eb('0x88')](_0x4360b3)[_0xf2eb('0x89')]()[_0xf2eb('0x2c')]();return db[_0xf2eb('0x45')][_0xf2eb('0x4d')]({'where':{'id':_0x225835[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](function(_0xd7efd6){return db['sequelize'][_0xf2eb('0x6e')](function(_0x4c4c62){return _0xd7efd6[_0xf2eb('0x8a')](_0x225835[_0xf2eb('0x36')][_0xf2eb('0x78')],{'transaction':_0x4c4c62})[_0xf2eb('0x24')](function(){if(!_[_0xf2eb('0x8b')](_0x30e814)){return _0xd7efd6[_0xf2eb('0x8c')](_0x30e814,{'transaction':_0x4c4c62})['then'](function(){return db[_0xf2eb('0x72')][_0xf2eb('0x25')]({'where':{'VoiceQueueId':_0x225835[_0xf2eb('0x46')]['id'],'UserId':_0x30e814},'transaction':_0x4c4c62});});}})[_0xf2eb('0x24')](function(){_0x30e814[_0xf2eb('0x6b')](function(_0xd5aa94){socket[_0xf2eb('0x76')](_0xf2eb('0x8d'),{'UserId':_0xd5aa94,'VoiceQueueId':_0xd7efd6['id']});});});});});});})[_0xf2eb('0x24')](respondWithStatusCode(_0x1c786f,null))[_0xf2eb('0x51')](handleError(_0x1c786f,null));};exports[_0xf2eb('0x8e')]=function(_0x1f47ca,_0x3eb5e1,_0x340899){var _0xad16fe,_0x508ed9;return db['VoiceQueue'][_0xf2eb('0x4d')]({'where':{'id':_0x1f47ca[_0xf2eb('0x46')]['id']}})['then'](handleEntityNotFound(_0x3eb5e1,null))[_0xf2eb('0x24')](function(_0x2645c0){if(_0x2645c0){_0x508ed9=_0x2645c0;return _0x2645c0[_0xf2eb('0x8e')](_0x1f47ca[_0xf2eb('0x4a')][_0xf2eb('0x78')],_[_0xf2eb('0x52')](_0x1f47ca[_0xf2eb('0x4a')],[_0xf2eb('0x78'),'id'])||{})[_0xf2eb('0x8f')](function(_0x5456ce){for(var _0x3598ea=0x0;_0x3598ea<_0x1f47ca['body'][_0xf2eb('0x78')]['length'];_0x3598ea+=0x1){socket[_0xf2eb('0x76')](_0xf2eb('0x77'),{'UserId':Number(_0x1f47ca[_0xf2eb('0x4a')][_0xf2eb('0x78')][_0x3598ea]),'VoiceQueueId':Number(_0x1f47ca[_0xf2eb('0x46')]['id'])});}return _0x5456ce;});}})['then'](function(_0x2a16aa){_0xad16fe=_0x2a16aa||[];if(_0x508ed9){return db['User'][_0xf2eb('0x5d')]({'where':{'id':_0x1f47ca[_0xf2eb('0x4a')][_0xf2eb('0x78')]},'attributes':['id',_0xf2eb('0x2f'),_0xf2eb('0x67'),_0xf2eb('0x68'),'interface'],'raw':!![]});}})['then'](function(_0x360f48){if(!_[_0xf2eb('0x8b')](_0x360f48)){var _0x443e6c=[];for(var _0x27b811=0x0;_0x27b811<_0x360f48[_0xf2eb('0x3b')];_0x27b811++){if(_0x360f48[_0x27b811][_0xf2eb('0x67')]){_0x443e6c[_0xf2eb('0x83')](db[_0xf2eb('0x72')][_0xf2eb('0x73')]({'membername':_0x360f48[_0x27b811]['name'],'UserId':_0x360f48[_0x27b811]['id'],'queue_name':_0x508ed9[_0xf2eb('0x2f')],'VoiceQueueId':_0x508ed9['id'],'interface':_[_0xf2eb('0x90')](_0x360f48[_0x27b811][_0xf2eb('0x69')])?util[_0xf2eb('0x74')]('SIP/%s',_0x360f48[_0x27b811][_0xf2eb('0x2f')]):_0x360f48[_0x27b811]['interface'],'paused':_0x360f48[_0x27b811][_0xf2eb('0x68')]||![],'penalty':_0x1f47ca[_0xf2eb('0x4a')]['penalty']||0x0}));}}return BPromise[_0xf2eb('0x91')](_0x443e6c);}})[_0xf2eb('0x24')](function(){return _0xad16fe;})[_0xf2eb('0x24')](respondWithResult(_0x3eb5e1,null))['catch'](handleError(_0x3eb5e1,null));};exports[_0xf2eb('0x8c')]=function(_0x444e18,_0x46c17b,_0x2e039d){return db[_0xf2eb('0x45')][_0xf2eb('0x4d')]({'where':{'id':_0x444e18[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x46c17b,null))[_0xf2eb('0x24')](function(_0x3dd661){if(_0x3dd661){return _0x3dd661[_0xf2eb('0x8c')](_0x444e18['query'][_0xf2eb('0x78')])[_0xf2eb('0x24')](function(){if(_[_0xf2eb('0x92')](_0x444e18['query'][_0xf2eb('0x78')])){for(var _0x936e16=0x0;_0x936e16<_0x444e18[_0xf2eb('0x36')][_0xf2eb('0x78')]['length'];_0x936e16+=0x1){socket[_0xf2eb('0x76')](_0xf2eb('0x8d'),{'UserId':Number(_0x444e18[_0xf2eb('0x36')][_0xf2eb('0x78')][_0x936e16]),'VoiceQueueId':Number(_0x444e18[_0xf2eb('0x46')]['id'])});}}else{socket[_0xf2eb('0x76')](_0xf2eb('0x8d'),{'UserId':Number(_0x444e18[_0xf2eb('0x36')][_0xf2eb('0x78')]),'VoiceQueueId':Number(_0x444e18[_0xf2eb('0x46')]['id'])});}});}})[_0xf2eb('0x24')](function(_0x3350d1){return db[_0xf2eb('0x72')][_0xf2eb('0x25')]({'where':{'VoiceQueueId':_0x444e18[_0xf2eb('0x46')]['id'],'UserId':_0x444e18[_0xf2eb('0x36')][_0xf2eb('0x78')]}})[_0xf2eb('0x24')](function(){return _0x3350d1;});})[_0xf2eb('0x24')](respondWithStatusCode(_0x46c17b,null))['catch'](handleError(_0x46c17b,null));};exports['getAgents']=function(_0x416b0a,_0x23ecb2,_0x4cdc8e){var _0x33fa67={};var _0x727a1d={};var _0x2a458a;var _0x709a33;return db[_0xf2eb('0x45')][_0xf2eb('0x56')]({'where':{'id':_0x416b0a['params']['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x23ecb2,null))[_0xf2eb('0x24')](function(_0x199420){if(_0x199420){_0x2a458a=_0x199420;_0x727a1d['model']=_['keys'](db[_0xf2eb('0x65')][_0xf2eb('0x33')]);_0x727a1d['query']=_['keys'](_0x416b0a[_0xf2eb('0x36')]);_0x727a1d[_0xf2eb('0x37')]=_['intersection'](_0x727a1d['model'],_0x727a1d[_0xf2eb('0x36')]);_0x33fa67['attributes']=_[_0xf2eb('0x38')](_0x727a1d[_0xf2eb('0x35')],qs['fields'](_0x416b0a['query'][_0xf2eb('0x3a')]));_0x33fa67['attributes']=_0x33fa67[_0xf2eb('0x39')]['length']?_0x33fa67[_0xf2eb('0x39')]:_0x727a1d['model'];_0x33fa67[_0xf2eb('0x5c')]=qs[_0xf2eb('0x57')](_0x416b0a[_0xf2eb('0x36')][_0xf2eb('0x57')]);_0x33fa67[_0xf2eb('0x40')]=qs[_0xf2eb('0x37')](_[_0xf2eb('0x3e')](_0x416b0a[_0xf2eb('0x36')],_0x727a1d['filters']));if(_0x416b0a[_0xf2eb('0x36')][_0xf2eb('0x3f')]){_0x33fa67[_0xf2eb('0x40')]=_['merge'](_0x33fa67['where'],{'$or':_[_0xf2eb('0x2b')](_0x33fa67[_0xf2eb('0x39')],function(_0x55fd41){var _0x44cb74={};_0x44cb74[_0x55fd41]={'$like':'%'+_0x416b0a[_0xf2eb('0x36')][_0xf2eb('0x3f')]+'%'};return _0x44cb74;})});}_0x33fa67=_[_0xf2eb('0x41')]({},_0x33fa67,_0x416b0a[_0xf2eb('0x48')]);return _0x2a458a['getAgents'](_0x33fa67);}})[_0xf2eb('0x24')](function(_0x193ae9){if(_0x193ae9){_0x709a33=_0x193ae9[_0xf2eb('0x3b')];if(!_0x416b0a[_0xf2eb('0x36')][_0xf2eb('0x3c')](_0xf2eb('0x3d'))){_0x33fa67[_0xf2eb('0x1d')]=qs[_0xf2eb('0x1d')](_0x416b0a['query']['limit']);_0x33fa67['offset']=qs['offset'](_0x416b0a[_0xf2eb('0x36')][_0xf2eb('0x1a')]);}return _0x2a458a['getAgents'](_0x33fa67);}})[_0xf2eb('0x24')](function(_0x3e5933){if(_0x3e5933){return _0x3e5933?{'count':_0x709a33,'rows':_0x3e5933}:null;}})[_0xf2eb('0x24')](respondWithResult(_0x23ecb2,null))[_0xf2eb('0x51')](handleError(_0x23ecb2,null));};exports[_0xf2eb('0x93')]=function(_0x45c0d7,_0x3bd59b,_0x2a6acc){var _0x2fe0d7={};var _0x17769e={};var _0x502c27;var _0x54c22f;return db[_0xf2eb('0x45')][_0xf2eb('0x56')]({'where':{'id':_0x45c0d7[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x3bd59b,null))[_0xf2eb('0x24')](function(_0x3719b6){if(_0x3719b6){_0x502c27=_0x3719b6;_0x17769e[_0xf2eb('0x35')]=_[_0xf2eb('0x47')](db[_0xf2eb('0x72')][_0xf2eb('0x33')]);_0x17769e['query']=_[_0xf2eb('0x47')](_0x45c0d7['query']);_0x17769e[_0xf2eb('0x37')]=_[_0xf2eb('0x38')](_0x17769e[_0xf2eb('0x35')],_0x17769e[_0xf2eb('0x36')]);_0x2fe0d7[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x17769e[_0xf2eb('0x35')],qs[_0xf2eb('0x3a')](_0x45c0d7[_0xf2eb('0x36')][_0xf2eb('0x3a')]));_0x2fe0d7[_0xf2eb('0x39')]=_0x2fe0d7['attributes']['length']?_0x2fe0d7['attributes']:_0x17769e[_0xf2eb('0x35')];_0x2fe0d7[_0xf2eb('0x5c')]=qs[_0xf2eb('0x57')](_0x45c0d7[_0xf2eb('0x36')]['sort']);_0x2fe0d7[_0xf2eb('0x40')]=qs[_0xf2eb('0x37')](_[_0xf2eb('0x3e')](_0x45c0d7['query'],_0x17769e[_0xf2eb('0x37')]));if(_0x45c0d7['query'][_0xf2eb('0x3f')]){_0x2fe0d7[_0xf2eb('0x40')]=_[_0xf2eb('0x41')](_0x2fe0d7[_0xf2eb('0x40')],{'$or':_[_0xf2eb('0x2b')](_0x2fe0d7['attributes'],function(_0xadb126){var _0xa05917={};_0xa05917[_0xadb126]={'$like':'%'+_0x45c0d7['query']['filter']+'%'};return _0xa05917;})});}_0x2fe0d7=_[_0xf2eb('0x41')]({},_0x2fe0d7,_0x45c0d7[_0xf2eb('0x48')]);return _0x502c27['getMembers'](_0x2fe0d7);}})['then'](function(_0xf9d8ce){if(_0xf9d8ce){_0x54c22f=_0xf9d8ce[_0xf2eb('0x3b')];if(!_0x45c0d7[_0xf2eb('0x36')]['hasOwnProperty'](_0xf2eb('0x3d'))){_0x2fe0d7[_0xf2eb('0x1d')]=qs[_0xf2eb('0x1d')](_0x45c0d7['query'][_0xf2eb('0x1d')]);_0x2fe0d7[_0xf2eb('0x1a')]=qs[_0xf2eb('0x1a')](_0x45c0d7[_0xf2eb('0x36')][_0xf2eb('0x1a')]);}return _0x502c27['getMembers'](_0x2fe0d7);}})[_0xf2eb('0x24')](function(_0x420ac2){return _0x420ac2?{'count':_0x54c22f,'rows':_0x420ac2}:null;})['then'](respondWithResult(_0x3bd59b,null))[_0xf2eb('0x51')](handleError(_0x3bd59b,null));};exports[_0xf2eb('0x94')]=function(_0x2201f1,_0x4e9512,_0x3b98d6){var _0x2b9ee3={};var _0x19b8c7={};var _0x424086;var _0x2f340f;return db['VoiceQueue'][_0xf2eb('0x56')]({'where':{'id':_0x2201f1[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x4e9512,null))['then'](function(_0x208142){if(_0x208142){_0x424086=_0x208142;_0x19b8c7[_0xf2eb('0x35')]=_[_0xf2eb('0x47')](db[_0xf2eb('0x95')][_0xf2eb('0x33')]);_0x19b8c7['query']=_[_0xf2eb('0x47')](_0x2201f1[_0xf2eb('0x36')]);_0x19b8c7['filters']=_[_0xf2eb('0x38')](_0x19b8c7[_0xf2eb('0x35')],_0x19b8c7[_0xf2eb('0x36')]);_0x2b9ee3[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x19b8c7['model'],qs[_0xf2eb('0x3a')](_0x2201f1['query'][_0xf2eb('0x3a')]));_0x2b9ee3[_0xf2eb('0x39')]=_0x2b9ee3['attributes'][_0xf2eb('0x3b')]?_0x2b9ee3[_0xf2eb('0x39')]:_0x19b8c7[_0xf2eb('0x35')];_0x2b9ee3[_0xf2eb('0x5c')]=qs[_0xf2eb('0x57')](_0x2201f1[_0xf2eb('0x36')][_0xf2eb('0x57')]);_0x2b9ee3[_0xf2eb('0x40')]=qs[_0xf2eb('0x37')](_['pick'](_0x2201f1[_0xf2eb('0x36')],_0x19b8c7[_0xf2eb('0x37')]));if(_0x2201f1[_0xf2eb('0x36')]['filter']){_0x2b9ee3[_0xf2eb('0x40')]=_['merge'](_0x2b9ee3[_0xf2eb('0x40')],{'$or':_['map'](_0x2b9ee3['attributes'],function(_0x50cf22){var _0x581cb7={};_0x581cb7[_0x50cf22]={'$like':'%'+_0x2201f1[_0xf2eb('0x36')][_0xf2eb('0x3f')]+'%'};return _0x581cb7;})});}_0x2b9ee3=_[_0xf2eb('0x41')]({},_0x2b9ee3,_0x2201f1[_0xf2eb('0x48')]);return _0x424086[_0xf2eb('0x94')](_0x2b9ee3);}})[_0xf2eb('0x24')](function(_0x15100c){if(_0x15100c){_0x2f340f=_0x15100c[_0xf2eb('0x3b')];if(!_0x2201f1[_0xf2eb('0x36')]['hasOwnProperty']('nolimit')){_0x2b9ee3[_0xf2eb('0x1d')]=qs['limit'](_0x2201f1[_0xf2eb('0x36')][_0xf2eb('0x1d')]);_0x2b9ee3[_0xf2eb('0x1a')]=qs['offset'](_0x2201f1[_0xf2eb('0x36')]['offset']);}return _0x424086[_0xf2eb('0x94')](_0x2b9ee3);}})[_0xf2eb('0x24')](function(_0x304dea){if(_0x304dea){return _0x304dea?{'count':_0x2f340f,'rows':_0x304dea}:null;}})[_0xf2eb('0x24')](respondWithResult(_0x4e9512,null))[_0xf2eb('0x51')](handleError(_0x4e9512,null));};exports[_0xf2eb('0x96')]=function(_0x4d4b2d,_0x10a5f2,_0x1e1994){var _0x14fc47,_0x48ab6a;return db[_0xf2eb('0x45')][_0xf2eb('0x4d')]({'where':{'id':_0x4d4b2d[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x10a5f2,null))[_0xf2eb('0x24')](function(_0x47a5f8){if(_0x47a5f8){_0x48ab6a=_0x47a5f8;return _0x47a5f8[_0xf2eb('0x96')](_0x4d4b2d[_0xf2eb('0x4a')][_0xf2eb('0x78')],_[_0xf2eb('0x52')](_0x4d4b2d[_0xf2eb('0x4a')],['ids','id'])||{});}return null;})[_0xf2eb('0x8f')](function(_0x5df0b7){var _0x1a8c15;_0x14fc47=_0x5df0b7||[];var _0x6a7509=[];if(_0x5df0b7){for(var _0x16fd79=0x0;_0x16fd79<_0x5df0b7['length'];_0x16fd79+=0x1){var _0xc5dd6d=_0x5df0b7[_0x16fd79][_0xf2eb('0x26')]({'plain':!![]});_0x48ab6a['dialCheckDuplicateType']=_0x4d4b2d[_0xf2eb('0x4a')]['dialCheckDuplicateType']?_0x4d4b2d[_0xf2eb('0x4a')]['dialCheckDuplicateType']:_0x48ab6a[_0xf2eb('0x97')];switch(_0x48ab6a[_0xf2eb('0x97')]){case'always':_0x1a8c15=squel[_0xf2eb('0x98')]()['into'](_0xf2eb('0x99'))[_0xf2eb('0x9a')]([_0xf2eb('0x9b'),_0xf2eb('0x9c'),_0xf2eb('0x9d'),'ListId',_0xf2eb('0x58'),'createdAt',_0xf2eb('0x54')],squel['select']()['field'](_0xf2eb('0x9b'),_0xf2eb('0x9b'))[_0xf2eb('0x79')](_0xf2eb('0x9e'),_0xf2eb('0x9c'))[_0xf2eb('0x79')]('id',_0xf2eb('0x9d'))[_0xf2eb('0x79')](_0xc5dd6d[_0xf2eb('0x9f')][_0xf2eb('0x84')](),_0xf2eb('0xa0'))[_0xf2eb('0x79')](_0x4d4b2d[_0xf2eb('0x46')]['id'][_0xf2eb('0x84')](),_0xf2eb('0x58'))[_0xf2eb('0x79')](_0xf2eb('0x9e'),_0xf2eb('0x53'))[_0xf2eb('0x79')]('NOW()',_0xf2eb('0x54'))['from'](_0xf2eb('0xa1'))[_0xf2eb('0x40')](_0xf2eb('0xa2'))[_0xf2eb('0x40')]('ListId\x20=\x20?',_0xc5dd6d[_0xf2eb('0x9f')]['toString']())['where'](_0xf2eb('0xa3'))['where'](_0xf2eb('0xa4'),squel['select']()[_0xf2eb('0x79')](_0xf2eb('0xa5'))[_0xf2eb('0x7b')](_0xf2eb('0xa6'))['where'](_0xf2eb('0x80'),_0x4d4b2d[_0xf2eb('0x46')]['id']['toString']()))[_0xf2eb('0x40')](_0xf2eb('0xa4'),squel['select']()[_0xf2eb('0x79')](_0xf2eb('0xa7'))[_0xf2eb('0x7b')](_0xf2eb('0x99'))[_0xf2eb('0x40')](_0xf2eb('0x80'),_0x4d4b2d[_0xf2eb('0x46')]['id'][_0xf2eb('0x84')]())))[_0xf2eb('0x84')]();break;case _0xf2eb('0xa8'):_0x1a8c15=squel[_0xf2eb('0x98')]()['into']('cm_hopper')[_0xf2eb('0x9a')]([_0xf2eb('0x9b'),'scheduledAt',_0xf2eb('0x9d'),_0xf2eb('0xa0'),_0xf2eb('0x58'),_0xf2eb('0x53'),_0xf2eb('0x54')],squel[_0xf2eb('0xa9')]()['field']('phone',_0xf2eb('0x9b'))['field'](_0xf2eb('0x9e'),_0xf2eb('0x9c'))[_0xf2eb('0x79')]('id',_0xf2eb('0x9d'))['field'](_0xc5dd6d['CmListId'][_0xf2eb('0x84')](),'ListId')[_0xf2eb('0x79')](_0x4d4b2d[_0xf2eb('0x46')]['id'][_0xf2eb('0x84')](),'VoiceQueueId')[_0xf2eb('0x79')](_0xf2eb('0x9e'),_0xf2eb('0x53'))[_0xf2eb('0x79')](_0xf2eb('0x9e'),'updatedAt')[_0xf2eb('0x7b')](_0xf2eb('0xa1'))[_0xf2eb('0x40')](_0xf2eb('0xa2'))[_0xf2eb('0x40')](_0xf2eb('0xaa'),_0xc5dd6d[_0xf2eb('0x9f')][_0xf2eb('0x84')]())[_0xf2eb('0x40')](_0xf2eb('0xa3'))[_0xf2eb('0x40')]('phone\x20NOT\x20IN\x20(?)',squel[_0xf2eb('0xa9')]()[_0xf2eb('0x79')]('COALESCE(phone,\x27\x27)')[_0xf2eb('0x7b')](_0xf2eb('0x99'))[_0xf2eb('0x40')](_0xf2eb('0x80'),_0x4d4b2d[_0xf2eb('0x46')]['id'][_0xf2eb('0x84')]())))[_0xf2eb('0x84')]();break;default:_0x1a8c15=squel[_0xf2eb('0x98')]()[_0xf2eb('0xab')]('cm_hopper')[_0xf2eb('0x9a')]([_0xf2eb('0x9b'),'scheduledAt',_0xf2eb('0x9d'),'ListId',_0xf2eb('0x58'),_0xf2eb('0x53'),'updatedAt'],squel[_0xf2eb('0xa9')]()[_0xf2eb('0x79')]('phone',_0xf2eb('0x9b'))[_0xf2eb('0x79')](_0xf2eb('0x9e'),'scheduledAt')[_0xf2eb('0x79')]('id',_0xf2eb('0x9d'))['field'](_0xc5dd6d[_0xf2eb('0x9f')][_0xf2eb('0x84')](),_0xf2eb('0xa0'))[_0xf2eb('0x79')](_0x4d4b2d[_0xf2eb('0x46')]['id'][_0xf2eb('0x84')](),'VoiceQueueId')[_0xf2eb('0x79')](_0xf2eb('0x9e'),_0xf2eb('0x53'))[_0xf2eb('0x79')](_0xf2eb('0x9e'),_0xf2eb('0x54'))[_0xf2eb('0x7b')](_0xf2eb('0xa1'))[_0xf2eb('0x40')](_0xf2eb('0xa2'))[_0xf2eb('0x40')]('ListId\x20=\x20?',_0xc5dd6d[_0xf2eb('0x9f')][_0xf2eb('0x84')]())[_0xf2eb('0x40')](_0xf2eb('0xa3')))[_0xf2eb('0x84')]();}_0x6a7509[_0xf2eb('0x83')](db[_0xf2eb('0x6d')][_0xf2eb('0x36')](_0x1a8c15));}return BPromise[_0xf2eb('0x91')](_0x6a7509);}})[_0xf2eb('0x24')](function(){return _0x14fc47;})[_0xf2eb('0x24')](respondWithResult(_0x10a5f2,null))[_0xf2eb('0x51')](handleError(_0x10a5f2,null));};exports[_0xf2eb('0xac')]=function(_0xa900ab,_0x551b14,_0xad834){return db[_0xf2eb('0x45')][_0xf2eb('0x4d')]({'where':{'id':_0xa900ab['params']['id']}})['then'](handleEntityNotFound(_0x551b14,null))['then'](function(_0x45e492){if(_0x45e492){return _0x45e492[_0xf2eb('0xac')](_0xa900ab[_0xf2eb('0x36')][_0xf2eb('0x78')]);}})[_0xf2eb('0x24')](function(_0x48b7d8){if(_0x48b7d8){return db['CmHopper']['destroy']({'where':{'ListId':_0xa900ab[_0xf2eb('0x36')][_0xf2eb('0x78')],'VoiceQueueId':_0xa900ab[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](function(){return _0x48b7d8;});}})['then'](respondWithStatusCode(_0x551b14,null))['catch'](handleError(_0x551b14,null));};exports[_0xf2eb('0xad')]=function(_0x1e489b,_0x164c46,_0x48c2ee){var _0x19b38f={};var _0x490bb1={};var _0x324411;var _0x1fa147;return db[_0xf2eb('0x45')]['findOne']({'where':{'id':_0x1e489b[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x164c46,null))[_0xf2eb('0x24')](function(_0xe010ae){if(_0xe010ae){_0x324411=_0xe010ae;_0x490bb1[_0xf2eb('0x35')]=_[_0xf2eb('0x47')](db[_0xf2eb('0x95')][_0xf2eb('0x33')]);_0x490bb1[_0xf2eb('0x36')]=_[_0xf2eb('0x47')](_0x1e489b[_0xf2eb('0x36')]);_0x490bb1[_0xf2eb('0x37')]=_[_0xf2eb('0x38')](_0x490bb1[_0xf2eb('0x35')],_0x490bb1[_0xf2eb('0x36')]);_0x19b38f[_0xf2eb('0x39')]=_[_0xf2eb('0x38')](_0x490bb1[_0xf2eb('0x35')],qs[_0xf2eb('0x3a')](_0x1e489b['query'][_0xf2eb('0x3a')]));_0x19b38f[_0xf2eb('0x39')]=_0x19b38f[_0xf2eb('0x39')][_0xf2eb('0x3b')]?_0x19b38f['attributes']:_0x490bb1['model'];_0x19b38f['order']=qs[_0xf2eb('0x57')](_0x1e489b[_0xf2eb('0x36')]['sort']);_0x19b38f[_0xf2eb('0x40')]=qs[_0xf2eb('0x37')](_['pick'](_0x1e489b[_0xf2eb('0x36')],_0x490bb1[_0xf2eb('0x37')]));if(_0x1e489b[_0xf2eb('0x36')][_0xf2eb('0x3f')]){_0x19b38f['where']=_[_0xf2eb('0x41')](_0x19b38f[_0xf2eb('0x40')],{'$or':_[_0xf2eb('0x2b')](_0x19b38f[_0xf2eb('0x39')],function(_0x37d3ac){var _0x5dffe3={};_0x5dffe3[_0x37d3ac]={'$like':'%'+_0x1e489b[_0xf2eb('0x36')][_0xf2eb('0x3f')]+'%'};return _0x5dffe3;})});}_0x19b38f=_[_0xf2eb('0x41')]({},_0x19b38f,_0x1e489b[_0xf2eb('0x48')]);return _0x324411[_0xf2eb('0xad')](_0x19b38f);}})[_0xf2eb('0x24')](function(_0x525da2){if(_0x525da2){_0x1fa147=_0x525da2[_0xf2eb('0x3b')];if(!_0x1e489b[_0xf2eb('0x36')][_0xf2eb('0x3c')]('nolimit')){_0x19b38f[_0xf2eb('0x1d')]=qs['limit'](_0x1e489b[_0xf2eb('0x36')][_0xf2eb('0x1d')]);_0x19b38f[_0xf2eb('0x1a')]=qs['offset'](_0x1e489b['query'][_0xf2eb('0x1a')]);}return _0x324411[_0xf2eb('0xad')](_0x19b38f);}})[_0xf2eb('0x24')](function(_0x4d2d0d){if(_0x4d2d0d){return _0x4d2d0d?{'count':_0x1fa147,'rows':_0x4d2d0d}:null;}})[_0xf2eb('0x24')](respondWithResult(_0x164c46,null))[_0xf2eb('0x51')](handleError(_0x164c46,null));};exports['addBlackLists']=function(_0x5c0f2c,_0x590172,_0x357b46){var _0xd63e45,_0x200cbc;return db[_0xf2eb('0x45')][_0xf2eb('0x4d')]({'where':{'id':_0x5c0f2c[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x590172,null))[_0xf2eb('0x24')](function(_0x1f0618){if(_0x1f0618){_0x200cbc=_0x1f0618;return _0x1f0618['addBlackLists'](_0x5c0f2c[_0xf2eb('0x4a')][_0xf2eb('0x78')],_[_0xf2eb('0x52')](_0x5c0f2c[_0xf2eb('0x4a')],['ids','id'])||{});}return null;})[_0xf2eb('0x8f')](function(_0x2831c3){var _0x26a322;_0xd63e45=_0x2831c3||[];var _0x1d8d9e=[];if(_0x2831c3){for(var _0x2deda8=0x0;_0x2deda8<_0x2831c3[_0xf2eb('0x3b')];_0x2deda8+=0x1){var _0x28f300=_0x2831c3[_0x2deda8][_0xf2eb('0x26')]({'plain':!![]});_0x26a322=squel['insert']()['into'](_0xf2eb('0xae'))[_0xf2eb('0x9a')]([_0xf2eb('0x9b'),'ContactId',_0xf2eb('0xa0'),_0xf2eb('0x58'),'createdAt',_0xf2eb('0x54')],squel['select']()[_0xf2eb('0x79')](_0xf2eb('0x9b'),_0xf2eb('0x9b'))['field']('id',_0xf2eb('0x9d'))['field'](_0x28f300['CmListId'][_0xf2eb('0x84')](),_0xf2eb('0xa0'))[_0xf2eb('0x79')](_0x5c0f2c[_0xf2eb('0x46')]['id'][_0xf2eb('0x84')](),_0xf2eb('0x58'))[_0xf2eb('0x79')](_0xf2eb('0x9e'),_0xf2eb('0x53'))[_0xf2eb('0x79')](_0xf2eb('0x9e'),_0xf2eb('0x54'))[_0xf2eb('0x7b')]('cm_contacts')[_0xf2eb('0x40')]('deletedAt\x20IS\x20NULL')[_0xf2eb('0x40')](_0xf2eb('0xaa'),_0x28f300['CmListId'][_0xf2eb('0x84')]())[_0xf2eb('0x40')](_0xf2eb('0xa3')))['toString']();_0x1d8d9e[_0xf2eb('0x83')](db[_0xf2eb('0x6d')][_0xf2eb('0x36')](_0x26a322));}return BPromise[_0xf2eb('0x91')](_0x1d8d9e);}})['then'](function(){return _0xd63e45;})[_0xf2eb('0x24')](respondWithResult(_0x590172,null))['catch'](handleError(_0x590172,null));};exports[_0xf2eb('0xaf')]=function(_0x1ba838,_0x2c04a5,_0xfe73ac){return db['VoiceQueue'][_0xf2eb('0x4d')]({'where':{'id':_0x1ba838[_0xf2eb('0x46')]['id']}})[_0xf2eb('0x24')](handleEntityNotFound(_0x2c04a5,null))['then'](function(_0x4057de){if(_0x4057de){return _0x4057de[_0xf2eb('0xaf')](_0x1ba838['query']['ids']);}})[_0xf2eb('0x24')](function(_0x214c3b){if(_0x214c3b){return db[_0xf2eb('0x62')]['destroy']({'where':{'ListId':_0x1ba838[_0xf2eb('0x36')][_0xf2eb('0x78')],'VoiceQueueId':_0x1ba838['params']['id']}})[_0xf2eb('0x24')](function(){return _0x214c3b;});}})[_0xf2eb('0x24')](respondWithStatusCode(_0x2c04a5,null))[_0xf2eb('0x51')](handleError(_0x2c04a5,null));};
\ No newline at end of file
+var _0xfd20=['autoAssociation','clone','merge','createdAt','updatedAt','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','findOne','CmHopper','nolimit','VoiceQueueId','CmHopperHistory','CmHopperFinal','findAll','getHopperBlacks','CmHopperBlack','getTeams','Team','addTeams','Agents','voicePause','interface','flatMap','penalty','sequelize','each','TeamVoiceQueue','upsert','UserVoiceQueue','UserVoiceQueueRt','format','SIP/%s','forEach','emit','userVoiceQueue:save','removeTeams','User','field','from','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','toString','QueryTypes','every','TeamId','includes','union','compact','transaction','removeAgents','userVoiceQueue:remove','addAgents','omit','ids','spread','online','isEmpty','isNil','getAgents','getMembers','getLists','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','always','insert','cm_hopper','fromQuery','phone','ListId','scheduledAt','ContactId','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20NOT\x20IN\x20(?)','select','COALESCE(phone,\x27\x27)','onlyIfOpen','into','phone\x20IS\x20NOT\x20NULL','CmHopperId','OrderBy','ci.item','ci.OrderBy+1','cm_contact_has_items','h.scheduledat=?','ci.ItemClass=?','PHONE','all','removeLists','CmList','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','rimraf','request-promise','moment','mustache','path','sox','to-csv','ejs','fs-extra','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','./voiceQueue.socket','register','sendStatus','json','offset','limit','undefined','count','Content-Range','apply','reject','save','update','then','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','map','value','type','find','name','UserProfileResource','destroy','error','stack','send','rawAttributes','key','query','keys','filters','intersection','model','attributes','fields','hasOwnProperty','order','sort','where','pick','VIRTUAL','options','VoiceQueue','includeAll','include','rows','catch','show','params','length','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0xfd20,0x66));var _0x0fd2=function(_0x268509,_0x196d93){_0x268509=_0x268509-0x0;var _0x5de441=_0xfd20[_0x268509];return _0x5de441;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x0fd2('0x0'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x0fd2('0x1'));var moment=require(_0x0fd2('0x2'));var BPromise=require('bluebird');var Mustache=require(_0x0fd2('0x3'));var util=require('util');var path=require(_0x0fd2('0x4'));var sox=require(_0x0fd2('0x5'));var csv=require(_0x0fd2('0x6'));var ejs=require(_0x0fd2('0x7'));var fs=require('fs');var fs_extra=require(_0x0fd2('0x8'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x0fd2('0x9'));var jsforce=require(_0x0fd2('0xa'));var deskjs=require(_0x0fd2('0xb'));var toCsv=require(_0x0fd2('0x6'));var querystring=require(_0x0fd2('0xc'));var Papa=require(_0x0fd2('0xd'));var Redis=require(_0x0fd2('0xe'));var authService=require('../../components/auth/service');var qs=require(_0x0fd2('0xf'));var as=require(_0x0fd2('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x0fd2('0x11'))('api');var utils=require(_0x0fd2('0x12'));var config=require(_0x0fd2('0x13'));var licenseUtil=require(_0x0fd2('0x14'));var db=require(_0x0fd2('0x15'))['db'];config[_0x0fd2('0x16')]=_[_0x0fd2('0x17')](config[_0x0fd2('0x16')],{'host':_0x0fd2('0x18'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x0fd2('0x19'))[_0x0fd2('0x1a')](socket);function respondWithStatusCode(_0x21dcc5,_0x28dd2b){_0x28dd2b=_0x28dd2b||0xcc;return function(_0x52ab36){if(_0x52ab36){return _0x21dcc5[_0x0fd2('0x1b')](_0x28dd2b);}return _0x21dcc5['status'](_0x28dd2b)['end']();};}function respondWithResult(_0x2b6254,_0x50eedc){_0x50eedc=_0x50eedc||0xc8;return function(_0x42f44c){if(_0x42f44c){return _0x2b6254['status'](_0x50eedc)[_0x0fd2('0x1c')](_0x42f44c);}};}function respondWithFilteredResult(_0x4cd2bf,_0x267dfb){return function(_0x15c9de){if(_0x15c9de){var _0x53787a=typeof _0x267dfb[_0x0fd2('0x1d')]==='undefined'&&typeof _0x267dfb[_0x0fd2('0x1e')]===_0x0fd2('0x1f');var _0x3fb07e=_0x15c9de[_0x0fd2('0x20')];var _0x2977ef=_0x53787a?0x0:_0x267dfb[_0x0fd2('0x1d')];var _0x3ea260=_0x53787a?_0x15c9de[_0x0fd2('0x20')]:_0x267dfb[_0x0fd2('0x1d')]+_0x267dfb[_0x0fd2('0x1e')];var _0x5c50ad;if(_0x3ea260>=_0x3fb07e){_0x3ea260=_0x3fb07e;_0x5c50ad=0xc8;}else{_0x5c50ad=0xce;}_0x4cd2bf['status'](_0x5c50ad);return _0x4cd2bf['set'](_0x0fd2('0x21'),_0x2977ef+'-'+_0x3ea260+'/'+_0x3fb07e)[_0x0fd2('0x1c')](_0x15c9de);}return null;};}function patchUpdates(_0x53ab17){return function(_0x48586c){try{jsonpatch[_0x0fd2('0x22')](_0x48586c,_0x53ab17,!![]);}catch(_0x25563c){return BPromise[_0x0fd2('0x23')](_0x25563c);}return _0x48586c[_0x0fd2('0x24')]();};}function saveUpdates(_0x25cdd2,_0x5d15ed){return function(_0x233b01){if(_0x233b01){return _0x233b01[_0x0fd2('0x25')](_0x25cdd2)[_0x0fd2('0x26')](function(_0x54cce1){return _0x54cce1;});}return null;};}function removeEntity(_0x4c77a8,_0x11bb10){return function(_0x2a45e1){if(_0x2a45e1){return _0x2a45e1['destroy']()[_0x0fd2('0x26')](function(){var _0x429fef=_0x2a45e1[_0x0fd2('0x27')]({'plain':!![]});var _0x1defb4=[{'name':_0x0fd2('0x28'),'value':_0x0fd2('0x29'),'ignore':![]},{'name':_0x0fd2('0x2a'),'value':_0x0fd2('0x2b'),'ignore':![]}];var _0x5b32df=_(_0x1defb4)[_0x0fd2('0x2c')](_0x0fd2('0x2d'))[_0x0fd2('0x2e')](_0x0fd2('0x2f'))[_0x0fd2('0x2f')]();if(_['includes'](_0x5b32df,_0x429fef[_0x0fd2('0x30')])){return;}var _0x33335b=_[_0x0fd2('0x31')](_0x1defb4,[_0x0fd2('0x2f'),_0x429fef[_0x0fd2('0x30')]])[_0x0fd2('0x32')];return db[_0x0fd2('0x33')][_0x0fd2('0x34')]({'where':{'type':_0x33335b,'resourceId':_0x429fef['id']}})['then'](function(){return _0x2a45e1;});})[_0x0fd2('0x26')](function(){_0x4c77a8['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x1828cc,_0x553715){return function(_0x2faac3){if(!_0x2faac3){_0x1828cc['sendStatus'](0x194);}return _0x2faac3;};}function handleError(_0x244095,_0x53f585){_0x53f585=_0x53f585||0x1f4;return function(_0x5caeff){logger[_0x0fd2('0x35')](_0x5caeff[_0x0fd2('0x36')]);if(_0x5caeff[_0x0fd2('0x32')]){delete _0x5caeff['name'];}_0x244095['status'](_0x53f585)[_0x0fd2('0x37')](_0x5caeff);};}exports['index']=function(_0x11917f,_0x6b6cb4){var _0x803113={},_0x44167a={},_0x12f9ad={'count':0x0,'rows':[]};var _0x2975fb=_[_0x0fd2('0x2e')](db['VoiceQueue'][_0x0fd2('0x38')],function(_0x2ccfbe){return{'name':_0x2ccfbe['fieldName'],'type':_0x2ccfbe['type'][_0x0fd2('0x39')]};});_0x44167a['model']=_['map'](_0x2975fb,_0x0fd2('0x32'));_0x44167a[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x11917f[_0x0fd2('0x3a')]);_0x44167a[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x44167a[_0x0fd2('0x3e')],_0x44167a[_0x0fd2('0x3a')]);_0x803113[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x44167a[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x803113[_0x0fd2('0x3f')]=_0x803113[_0x0fd2('0x3f')]['length']?_0x803113[_0x0fd2('0x3f')]:_0x44167a[_0x0fd2('0x3e')];if(!_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x41')]('nolimit')){_0x803113[_0x0fd2('0x1e')]=qs['limit'](_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x803113['offset']=qs[_0x0fd2('0x1d')](_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}_0x803113[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x11917f[_0x0fd2('0x3a')]['sort']);_0x803113[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x11917f[_0x0fd2('0x3a')],_0x44167a[_0x0fd2('0x3c')]),_0x2975fb);if(_0x11917f['query'][_0x0fd2('0x2c')]){_0x803113[_0x0fd2('0x44')]=_['merge'](_0x803113[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x2975fb,function(_0x400b49){if(_0x400b49[_0x0fd2('0x30')]!==_0x0fd2('0x46')){var _0x22c89d={};_0x22c89d[_0x400b49[_0x0fd2('0x32')]]={'$like':'%'+_0x11917f[_0x0fd2('0x3a')]['filter']+'%'};return _0x22c89d;}})});}_0x803113=_['merge']({},_0x803113,_0x11917f[_0x0fd2('0x47')]);var _0x19d9e2={'where':_0x803113['where']};return db[_0x0fd2('0x48')]['count'](_0x19d9e2)[_0x0fd2('0x26')](function(_0x241570){_0x12f9ad[_0x0fd2('0x20')]=_0x241570;if(_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x49')]){_0x803113[_0x0fd2('0x4a')]=[{'all':!![]}];}return db['VoiceQueue']['findAll'](_0x803113);})[_0x0fd2('0x26')](function(_0x5065dc){_0x12f9ad[_0x0fd2('0x4b')]=_0x5065dc;return _0x12f9ad;})[_0x0fd2('0x26')](respondWithFilteredResult(_0x6b6cb4,_0x803113))[_0x0fd2('0x4c')](handleError(_0x6b6cb4,null));};exports[_0x0fd2('0x4d')]=function(_0x2f47f9,_0x500d1a){var _0x1bbe6a={'raw':![],'where':{'id':_0x2f47f9[_0x0fd2('0x4e')]['id']}},_0x49f5c2={};_0x49f5c2[_0x0fd2('0x3e')]=_['keys'](db[_0x0fd2('0x48')]['rawAttributes']);_0x49f5c2['query']=_[_0x0fd2('0x3b')](_0x2f47f9[_0x0fd2('0x3a')]);_0x49f5c2[_0x0fd2('0x3c')]=_['intersection'](_0x49f5c2[_0x0fd2('0x3e')],_0x49f5c2[_0x0fd2('0x3a')]);_0x1bbe6a[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x49f5c2['model'],qs[_0x0fd2('0x40')](_0x2f47f9[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x1bbe6a[_0x0fd2('0x3f')]=_0x1bbe6a[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x1bbe6a[_0x0fd2('0x3f')]:_0x49f5c2[_0x0fd2('0x3e')];if(_0x2f47f9[_0x0fd2('0x3a')][_0x0fd2('0x49')]){_0x1bbe6a[_0x0fd2('0x4a')]=[{'all':!![]}];}_0x1bbe6a=_['merge']({},_0x1bbe6a,_0x2f47f9[_0x0fd2('0x47')]);return db[_0x0fd2('0x48')]['find'](_0x1bbe6a)[_0x0fd2('0x26')](handleEntityNotFound(_0x500d1a,null))['then'](respondWithResult(_0x500d1a,null))[_0x0fd2('0x4c')](handleError(_0x500d1a,null));};exports[_0x0fd2('0x50')]=function(_0xe2cd72,_0xed36b3){return db[_0x0fd2('0x48')]['create'](_0xe2cd72[_0x0fd2('0x51')],{})[_0x0fd2('0x26')](function(_0x101509){var _0x4c1020=_0xe2cd72['user'][_0x0fd2('0x27')]({'plain':!![]});if(!_0x4c1020)throw new Error(_0x0fd2('0x52'));if(_0x4c1020[_0x0fd2('0x53')]===_0x0fd2('0x54')){var _0xec149c=_0x101509[_0x0fd2('0x27')]({'plain':!![]});var _0x4a9fe1=[{'name':_0x0fd2('0x28'),'value':_0x0fd2('0x29')},{'name':_0x0fd2('0x2a'),'value':_0x0fd2('0x2b')}];var _0x379524=_[_0x0fd2('0x31')](_0x4a9fe1,[_0x0fd2('0x2f'),_0xec149c[_0x0fd2('0x30')]])[_0x0fd2('0x32')];return db[_0x0fd2('0x55')][_0x0fd2('0x31')]({'where':{'name':_0x379524,'userProfileId':_0x4c1020[_0x0fd2('0x56')]},'raw':!![]})[_0x0fd2('0x26')](function(_0x50929f){if(_0x50929f&&_0x50929f[_0x0fd2('0x57')]===0x0){return db[_0x0fd2('0x33')]['create']({'name':_0xec149c[_0x0fd2('0x32')],'resourceId':_0xec149c['id'],'type':_0x50929f[_0x0fd2('0x32')],'sectionId':_0x50929f['id']},{})[_0x0fd2('0x26')](function(){return _0x101509;});}else{return _0x101509;}})[_0x0fd2('0x4c')](function(_0x5674b3){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5674b3);throw _0x5674b3;});}return _0x101509;})[_0x0fd2('0x26')](respondWithResult(_0xed36b3,0xc9))[_0x0fd2('0x4c')](handleError(_0xed36b3,null));};exports[_0x0fd2('0x58')]=function(_0x27754d,_0x41dd02){var _0x1ba67f={'where':{'id':_0x27754d[_0x0fd2('0x4e')]['id']}},_0x47343a={};_0x47343a[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db['VoiceQueue']['rawAttributes']);_0x1ba67f['attributes']=_['intersection'](_0x47343a['model'],qs[_0x0fd2('0x40')](_0x27754d['query'][_0x0fd2('0x40')]));_0x1ba67f['attributes']=_0x1ba67f[_0x0fd2('0x3f')]['length']?_0x1ba67f[_0x0fd2('0x3f')]:_0x47343a[_0x0fd2('0x3e')];if(_0x27754d[_0x0fd2('0x3a')]['includeAll']){_0x1ba67f['include']=[{'all':!![]}];}_0x1ba67f=_[_0x0fd2('0x59')]({},_0x1ba67f,_0x27754d[_0x0fd2('0x47')]);return db[_0x0fd2('0x48')][_0x0fd2('0x31')](_0x1ba67f)[_0x0fd2('0x26')](handleEntityNotFound(_0x41dd02,null))[_0x0fd2('0x26')](function(_0x359ee2){if(_0x359ee2){var _0x44fd9d=_0x359ee2[_0x0fd2('0x27')]({'plain':!![]});_0x44fd9d=qs['omit'](_0x44fd9d,['id',_0x0fd2('0x5a'),_0x0fd2('0x5b')]);_0x27754d[_0x0fd2('0x51')]=_['omit'](_0x27754d[_0x0fd2('0x51')],['id','createdAt',_0x0fd2('0x5b')]);return db[_0x0fd2('0x48')][_0x0fd2('0x50')](_[_0x0fd2('0x59')](_0x44fd9d,_0x27754d[_0x0fd2('0x51')]),{'include':_0x27754d[_0x0fd2('0x3a')][_0x0fd2('0x49')]?[{'all':!![]}]:undefined})[_0x0fd2('0x26')](function(_0x53bb88){var _0x33530b=_0x27754d[_0x0fd2('0x54')]['get']({'plain':!![]});if(!_0x33530b)throw new Error(_0x0fd2('0x52'));if(_0x33530b[_0x0fd2('0x53')]===_0x0fd2('0x54')){var _0x58d2f1=_0x53bb88[_0x0fd2('0x27')]({'plain':!![]});var _0x43f751=[{'name':_0x0fd2('0x28'),'value':_0x0fd2('0x29')},{'name':_0x0fd2('0x2a'),'value':_0x0fd2('0x2b')}];var _0x1ed5db=_[_0x0fd2('0x31')](_0x43f751,[_0x0fd2('0x2f'),_0x58d2f1['type']])[_0x0fd2('0x32')];return db[_0x0fd2('0x55')][_0x0fd2('0x31')]({'where':{'name':_0x1ed5db,'userProfileId':_0x33530b['userProfileId']},'raw':!![]})[_0x0fd2('0x26')](function(_0x288212){if(_0x288212&&_0x288212[_0x0fd2('0x57')]===0x0){return db[_0x0fd2('0x33')][_0x0fd2('0x50')]({'name':_0x58d2f1['name'],'resourceId':_0x58d2f1['id'],'type':_0x288212['name'],'sectionId':_0x288212['id']},{})[_0x0fd2('0x26')](function(){return _0x53bb88;});}else{return _0x53bb88;}})[_0x0fd2('0x4c')](function(_0x39bd89){logger[_0x0fd2('0x35')](_0x0fd2('0x5c'),_0x39bd89);throw _0x39bd89;});}return _0x53bb88;});}})[_0x0fd2('0x26')](respondWithResult(_0x41dd02,0xc9))[_0x0fd2('0x4c')](handleError(_0x41dd02,null));};exports[_0x0fd2('0x25')]=function(_0x54aadc,_0x14f6fb){if(_0x54aadc[_0x0fd2('0x51')]['id']){delete _0x54aadc[_0x0fd2('0x51')]['id'];}return db[_0x0fd2('0x48')]['find']({'where':{'id':_0x54aadc[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x14f6fb,null))[_0x0fd2('0x26')](saveUpdates(_0x54aadc[_0x0fd2('0x51')],null))[_0x0fd2('0x26')](respondWithResult(_0x14f6fb,null))[_0x0fd2('0x4c')](handleError(_0x14f6fb,null));};exports[_0x0fd2('0x34')]=function(_0x16d33b,_0x404af9){return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x16d33b[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x404af9,null))[_0x0fd2('0x26')](removeEntity(_0x404af9,null))[_0x0fd2('0x4c')](handleError(_0x404af9,null));};exports[_0x0fd2('0x5d')]=function(_0x294e12,_0x3fb02f,_0x5e91c0){var _0x6660e4={'raw':![],'where':{}};var _0x3b4bfc={};var _0x32ee12={'count':0x0,'rows':[]};return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x294e12['params']['id']}})['then'](handleEntityNotFound(_0x3fb02f,null))[_0x0fd2('0x26')](function(_0x158899){if(_0x158899){_0x3b4bfc[_0x0fd2('0x3e')]=_['keys'](db[_0x0fd2('0x5f')][_0x0fd2('0x38')]);_0x3b4bfc[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x294e12[_0x0fd2('0x3a')]);_0x3b4bfc[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x3b4bfc[_0x0fd2('0x3e')],_0x3b4bfc[_0x0fd2('0x3a')]);_0x6660e4[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x3b4bfc[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x294e12[_0x0fd2('0x3a')]['fields']));_0x6660e4[_0x0fd2('0x3f')]=_0x6660e4[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x6660e4['attributes']:_0x3b4bfc[_0x0fd2('0x3e')];if(!_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x41')](_0x0fd2('0x60'))){_0x6660e4[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x6660e4[_0x0fd2('0x1d')]=qs['offset'](_0x294e12['query']['offset']);}_0x6660e4[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x6660e4[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_['pick'](_0x294e12[_0x0fd2('0x3a')],_0x3b4bfc['filters']));_0x6660e4[_0x0fd2('0x44')][_0x0fd2('0x61')]=_0x158899['id'];if(_0x294e12['query'][_0x0fd2('0x2c')]){_0x6660e4[_0x0fd2('0x44')]=_[_0x0fd2('0x59')](_0x6660e4['where'],{'$or':_[_0x0fd2('0x2e')](_0x6660e4[_0x0fd2('0x3f')],function(_0x5ee8bc){var _0x5659f6={};_0x5659f6[_0x5ee8bc]={'$like':'%'+_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0x5659f6;})});}_0x6660e4=_[_0x0fd2('0x59')]({},_0x6660e4,_0x294e12[_0x0fd2('0x47')]);return db[_0x0fd2('0x5f')]['count']({'where':_0x6660e4[_0x0fd2('0x44')]})[_0x0fd2('0x26')](function(_0x53a49c){_0x32ee12[_0x0fd2('0x20')]=_0x53a49c;if(_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x49')]){_0x6660e4[_0x0fd2('0x4a')]=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x6660e4);})[_0x0fd2('0x26')](function(_0x524528){_0x32ee12[_0x0fd2('0x4b')]=_0x524528;return _0x32ee12;});}})[_0x0fd2('0x26')](respondWithFilteredResult(_0x3fb02f,_0x6660e4))['catch'](handleError(_0x3fb02f,null));};exports['getHopperHistories']=function(_0x405814,_0x21d371,_0x2043f5){var _0x552dcd={'raw':!![],'where':{}};var _0x22c88a={};var _0x3883de={'count':0x0,'rows':[]};return db[_0x0fd2('0x48')]['findOne']({'where':{'id':_0x405814[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x21d371,null))['then'](function(_0x5cc6fe){if(_0x5cc6fe){_0x22c88a[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db[_0x0fd2('0x62')][_0x0fd2('0x38')]);_0x22c88a[_0x0fd2('0x3a')]=_['keys'](_0x405814[_0x0fd2('0x3a')]);_0x22c88a[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x22c88a[_0x0fd2('0x3e')],_0x22c88a[_0x0fd2('0x3a')]);_0x552dcd[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x22c88a[_0x0fd2('0x3e')],qs['fields'](_0x405814['query'][_0x0fd2('0x40')]));_0x552dcd[_0x0fd2('0x3f')]=_0x552dcd[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x552dcd['attributes']:_0x22c88a[_0x0fd2('0x3e')];if(!_0x405814[_0x0fd2('0x3a')]['hasOwnProperty']('nolimit')){_0x552dcd['limit']=qs[_0x0fd2('0x1e')](_0x405814[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x552dcd[_0x0fd2('0x1d')]=qs[_0x0fd2('0x1d')](_0x405814[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}_0x552dcd[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x405814[_0x0fd2('0x3a')]['sort']);_0x552dcd[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x405814[_0x0fd2('0x3a')],_0x22c88a[_0x0fd2('0x3c')]));_0x552dcd[_0x0fd2('0x44')][_0x0fd2('0x61')]=_0x5cc6fe['id'];if(_0x405814['query'][_0x0fd2('0x2c')]){_0x552dcd[_0x0fd2('0x44')]=_[_0x0fd2('0x59')](_0x552dcd[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x552dcd[_0x0fd2('0x3f')],function(_0x203979){var _0x4141de={};_0x4141de[_0x203979]={'$like':'%'+_0x405814['query'][_0x0fd2('0x2c')]+'%'};return _0x4141de;})});}_0x552dcd=_[_0x0fd2('0x59')]({},_0x552dcd,_0x405814[_0x0fd2('0x47')]);return db[_0x0fd2('0x62')][_0x0fd2('0x20')]({'where':_0x552dcd[_0x0fd2('0x44')]})['then'](function(_0x146f01){_0x3883de[_0x0fd2('0x20')]=_0x146f01;if(_0x405814['query'][_0x0fd2('0x49')]){_0x552dcd[_0x0fd2('0x4a')]=[{'all':!![]}];}return db['CmHopperHistory']['findAll'](_0x552dcd);})[_0x0fd2('0x26')](function(_0x27e6ac){_0x3883de[_0x0fd2('0x4b')]=_0x27e6ac;return _0x3883de;});}})[_0x0fd2('0x26')](respondWithFilteredResult(_0x21d371,_0x552dcd))['catch'](handleError(_0x21d371,null));};exports['getHopperFinals']=function(_0x12e136,_0x46d4f2,_0x35ec32){var _0x5b88fc={'raw':!![],'where':{}};var _0x2fa756={};var _0x2acc75={'count':0x0,'rows':[]};return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x12e136[_0x0fd2('0x4e')]['id']}})['then'](handleEntityNotFound(_0x46d4f2,null))[_0x0fd2('0x26')](function(_0x2f5c3b){if(_0x2f5c3b){_0x2fa756['model']=_[_0x0fd2('0x3b')](db[_0x0fd2('0x63')]['rawAttributes']);_0x2fa756[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x12e136[_0x0fd2('0x3a')]);_0x2fa756[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x2fa756[_0x0fd2('0x3e')],_0x2fa756[_0x0fd2('0x3a')]);_0x5b88fc[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x2fa756[_0x0fd2('0x3e')],qs['fields'](_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x5b88fc[_0x0fd2('0x3f')]=_0x5b88fc[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x5b88fc[_0x0fd2('0x3f')]:_0x2fa756[_0x0fd2('0x3e')];if(!_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x41')]('nolimit')){_0x5b88fc[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x5b88fc['offset']=qs[_0x0fd2('0x1d')](_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}_0x5b88fc['order']=qs['sort'](_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x5b88fc[_0x0fd2('0x44')]=qs['filters'](_[_0x0fd2('0x45')](_0x12e136[_0x0fd2('0x3a')],_0x2fa756['filters']));_0x5b88fc[_0x0fd2('0x44')][_0x0fd2('0x61')]=_0x2f5c3b['id'];if(_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x5b88fc[_0x0fd2('0x44')]=_['merge'](_0x5b88fc[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x5b88fc[_0x0fd2('0x3f')],function(_0x1260db){var _0x3dfe33={};_0x3dfe33[_0x1260db]={'$like':'%'+_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0x3dfe33;})});}_0x5b88fc=_['merge']({},_0x5b88fc,_0x12e136[_0x0fd2('0x47')]);return db[_0x0fd2('0x63')]['count']({'where':_0x5b88fc['where']})['then'](function(_0x3ab8c6){_0x2acc75['count']=_0x3ab8c6;if(_0x12e136['query'][_0x0fd2('0x49')]){_0x5b88fc['include']=[{'all':!![]}];}return db[_0x0fd2('0x63')][_0x0fd2('0x64')](_0x5b88fc);})['then'](function(_0x5d0ca9){_0x2acc75['rows']=_0x5d0ca9;return _0x2acc75;});}})['then'](respondWithFilteredResult(_0x46d4f2,_0x5b88fc))['catch'](handleError(_0x46d4f2,null));};exports[_0x0fd2('0x65')]=function(_0x244fd2,_0x50502e,_0x528fa4){var _0x453b8d={'raw':!![],'where':{}};var _0x1771ce={};var _0xf445a8={'count':0x0,'rows':[]};return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x244fd2[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x50502e,null))[_0x0fd2('0x26')](function(_0x2f56dd){if(_0x2f56dd){_0x1771ce[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db['CmHopperBlack'][_0x0fd2('0x38')]);_0x1771ce['query']=_[_0x0fd2('0x3b')](_0x244fd2[_0x0fd2('0x3a')]);_0x1771ce[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x1771ce['model'],_0x1771ce[_0x0fd2('0x3a')]);_0x453b8d[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x1771ce['model'],qs[_0x0fd2('0x40')](_0x244fd2[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x453b8d[_0x0fd2('0x3f')]=_0x453b8d[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x453b8d[_0x0fd2('0x3f')]:_0x1771ce[_0x0fd2('0x3e')];if(!_0x244fd2['query'][_0x0fd2('0x41')]('nolimit')){_0x453b8d[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x244fd2['query']['limit']);_0x453b8d[_0x0fd2('0x1d')]=qs[_0x0fd2('0x1d')](_0x244fd2[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}_0x453b8d[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x244fd2['query'][_0x0fd2('0x43')]);_0x453b8d[_0x0fd2('0x44')]=qs['filters'](_['pick'](_0x244fd2[_0x0fd2('0x3a')],_0x1771ce['filters']));_0x453b8d[_0x0fd2('0x44')][_0x0fd2('0x61')]=_0x2f56dd['id'];if(_0x244fd2[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x453b8d['where']=_[_0x0fd2('0x59')](_0x453b8d['where'],{'$or':_['map'](_0x453b8d[_0x0fd2('0x3f')],function(_0x1b7818){var _0x41e57e={};_0x41e57e[_0x1b7818]={'$like':'%'+_0x244fd2[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0x41e57e;})});}_0x453b8d=_['merge']({},_0x453b8d,_0x244fd2['options']);return db['CmHopperBlack']['count']({'where':_0x453b8d[_0x0fd2('0x44')]})['then'](function(_0x36b164){_0xf445a8[_0x0fd2('0x20')]=_0x36b164;if(_0x244fd2[_0x0fd2('0x3a')]['includeAll']){_0x453b8d[_0x0fd2('0x4a')]=[{'all':!![]}];}return db[_0x0fd2('0x66')][_0x0fd2('0x64')](_0x453b8d);})['then'](function(_0x1c0392){_0xf445a8[_0x0fd2('0x4b')]=_0x1c0392;return _0xf445a8;});}})[_0x0fd2('0x26')](respondWithFilteredResult(_0x50502e,_0x453b8d))[_0x0fd2('0x4c')](handleError(_0x50502e,null));};exports[_0x0fd2('0x67')]=function(_0x2dd7bd,_0x2fb19f,_0x1361ff){var _0x2311d8={};var _0x2fd8f8={};var _0xcc05d5;var _0x19f8c0;return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x2dd7bd[_0x0fd2('0x4e')]['id']}})['then'](handleEntityNotFound(_0x2fb19f,null))[_0x0fd2('0x26')](function(_0x4463eb){if(_0x4463eb){_0xcc05d5=_0x4463eb;_0x2fd8f8[_0x0fd2('0x3e')]=_['keys'](db[_0x0fd2('0x68')][_0x0fd2('0x38')]);_0x2fd8f8[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x2dd7bd[_0x0fd2('0x3a')]);_0x2fd8f8[_0x0fd2('0x3c')]=_['intersection'](_0x2fd8f8[_0x0fd2('0x3e')],_0x2fd8f8[_0x0fd2('0x3a')]);_0x2311d8[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x2fd8f8[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x2dd7bd[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x2311d8[_0x0fd2('0x3f')]=_0x2311d8[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x2311d8[_0x0fd2('0x3f')]:_0x2fd8f8[_0x0fd2('0x3e')];_0x2311d8[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x2dd7bd[_0x0fd2('0x3a')]['sort']);_0x2311d8[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x2dd7bd[_0x0fd2('0x3a')],_0x2fd8f8[_0x0fd2('0x3c')]));if(_0x2dd7bd[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x2311d8['where']=_[_0x0fd2('0x59')](_0x2311d8[_0x0fd2('0x44')],{'$or':_['map'](_0x2311d8[_0x0fd2('0x3f')],function(_0x425333){var _0x7e2917={};_0x7e2917[_0x425333]={'$like':'%'+_0x2dd7bd[_0x0fd2('0x3a')]['filter']+'%'};return _0x7e2917;})});}_0x2311d8=_['merge']({},_0x2311d8,_0x2dd7bd[_0x0fd2('0x47')]);return _0xcc05d5['getTeams'](_0x2311d8);}})['then'](function(_0x11db90){if(_0x11db90){_0x19f8c0=_0x11db90['length'];if(!_0x2dd7bd[_0x0fd2('0x3a')]['hasOwnProperty'](_0x0fd2('0x60'))){_0x2311d8[_0x0fd2('0x1e')]=qs['limit'](_0x2dd7bd[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x2311d8[_0x0fd2('0x1d')]=qs['offset'](_0x2dd7bd[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0xcc05d5['getTeams'](_0x2311d8);}})[_0x0fd2('0x26')](function(_0x293098){if(_0x293098){return _0x293098?{'count':_0x19f8c0,'rows':_0x293098}:null;}})[_0x0fd2('0x26')](respondWithResult(_0x2fb19f,null))[_0x0fd2('0x4c')](handleError(_0x2fb19f,null));};exports[_0x0fd2('0x69')]=function(_0x23db78,_0x2d97de,_0x5cb489){var _0x5a3809=_0x23db78[_0x0fd2('0x51')]['teams'];var _0x549306=_[_0x0fd2('0x2e')](_0x5a3809,'id');return db[_0x0fd2('0x68')][_0x0fd2('0x64')]({'where':{'id':_0x549306},'attributes':['id'],'include':[{'model':db['User'],'as':_0x0fd2('0x6a'),'attributes':['id',_0x0fd2('0x32'),'online',_0x0fd2('0x6b'),_0x0fd2('0x6c')],'raw':!![]}]})[_0x0fd2('0x26')](function(_0x45eb44){if(_0x45eb44){var _0x254999=_[_0x0fd2('0x6d')](_0x45eb44,function(_0x3cc23a){var _0x17b6ee=_0x3cc23a[_0x0fd2('0x27')]({'plain':!![]});_0x17b6ee[_0x0fd2('0x6a')]['forEach'](function(_0x5d1bd1){_0x5d1bd1['penalty']=_[_0x0fd2('0x31')](_0x5a3809,{'id':_0x17b6ee['id']})[_0x0fd2('0x6e')];});return _0x17b6ee[_0x0fd2('0x6a')];});return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x23db78[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](function(_0x30c8aa){return db[_0x0fd2('0x6f')]['transaction'](function(_0x8aa97d){return _0x30c8aa[_0x0fd2('0x69')](_0x549306,{'transaction':_0x8aa97d})[_0x0fd2('0x26')](function(){return BPromise[_0x0fd2('0x70')](_0x5a3809,function(_0x3ac89f){return db[_0x0fd2('0x71')][_0x0fd2('0x72')]({'TeamId':_0x3ac89f['id'],'VoiceQueueId':_0x23db78['params']['id'],'penalty':_0x3ac89f[_0x0fd2('0x6e')]},{'transaction':_0x8aa97d});});})[_0x0fd2('0x26')](function(){return BPromise['each'](_0x254999,function(_0x26b5b0){return db[_0x0fd2('0x73')]['findOrCreate']({'where':{'UserId':_0x26b5b0['id'],'VoiceQueueId':_0x23db78['params']['id']},'defaults':{'penalty':_0x26b5b0['penalty']},'transaction':_0x8aa97d});});})['then'](function(){return BPromise[_0x0fd2('0x70')](_[_0x0fd2('0x2c')](_0x254999,{'online':!![]}),function(_0x45f4be){return db[_0x0fd2('0x74')][_0x0fd2('0x72')]({'membername':_0x45f4be['name'],'UserId':_0x45f4be['id'],'queue_name':_0x30c8aa[_0x0fd2('0x32')],'VoiceQueueId':_0x30c8aa['id'],'interface':_['isNil'](_0x45f4be[_0x0fd2('0x6c')])?util[_0x0fd2('0x75')](_0x0fd2('0x76'),_0x45f4be[_0x0fd2('0x32')]):_0x45f4be['interface'],'paused':_0x45f4be['voicePause']||![],'penalty':_0x45f4be[_0x0fd2('0x6e')]},{'transaction':_0x8aa97d});});})[_0x0fd2('0x26')](function(){_0x254999[_0x0fd2('0x77')](function(_0x5592a5){socket[_0x0fd2('0x78')](_0x0fd2('0x79'),{'UserId':_0x5592a5['id'],'VoiceQueueId':_0x30c8aa['id']});});});});});}})[_0x0fd2('0x26')](respondWithStatusCode(_0x2d97de,null))[_0x0fd2('0x4c')](handleError(_0x2d97de,null));};exports[_0x0fd2('0x7a')]=function(_0x204295,_0x3acba7,_0x502625){return db[_0x0fd2('0x68')][_0x0fd2('0x64')]({'where':{'id':_0x204295[_0x0fd2('0x3a')]['ids']},'attributes':['id'],'include':[{'model':db[_0x0fd2('0x7b')],'as':_0x0fd2('0x6a'),'attributes':['id'],'raw':!![]}]})[_0x0fd2('0x26')](handleEntityNotFound(_0x3acba7,null))[_0x0fd2('0x26')](function(_0x2eee6e){var _0x2f46f0=_[_0x0fd2('0x2e')](_0x2eee6e,'id');var _0x930fd8=[];var _0x42359e=[];var _0x4055f4=squel['select']();_0x4055f4[_0x0fd2('0x7c')]('tq.TeamId')[_0x0fd2('0x7d')]('team_has_voice_queues','tq')[_0x0fd2('0x7e')](_0x0fd2('0x7f'),'ut',_0x0fd2('0x80'))[_0x0fd2('0x44')](_0x0fd2('0x81'),_0x204295[_0x0fd2('0x4e')]['id']);for(var _0x24676f=0x0;_0x24676f<_0x2eee6e['length'];_0x24676f+=0x1){let _0x4102c4=_0x2eee6e[_0x24676f];for(var _0x3cab70=0x0;_0x3cab70<_0x4102c4[_0x0fd2('0x6a')][_0x0fd2('0x4f')];_0x3cab70+=0x1){let _0x4af57f=_0x4102c4[_0x0fd2('0x6a')][_0x3cab70];var _0x5f54bb=_0x4055f4['clone']();_0x5f54bb[_0x0fd2('0x44')](_0x0fd2('0x82'),_0x4af57f['id']);_0x42359e[_0x0fd2('0x83')](db[_0x0fd2('0x6f')][_0x0fd2('0x3a')](_0x5f54bb[_0x0fd2('0x84')](),{'type':db[_0x0fd2('0x6f')][_0x0fd2('0x85')]['SELECT']})[_0x0fd2('0x26')](function(_0x1b8a6b){if(_0x1b8a6b[_0x0fd2('0x4f')]===0x1){return _0x4af57f['id'];}else{var _0x55bf30=_[_0x0fd2('0x86')](_['map'](_0x1b8a6b,_0x0fd2('0x87')),function(_0x329f21){return _[_0x0fd2('0x88')](_0x2f46f0,_0x329f21);});if(_0x55bf30){return _0x4af57f['id'];}}}));}}return BPromise['all'](_0x42359e)[_0x0fd2('0x26')](function(_0xfbbf6a){_0x930fd8=_(_0x930fd8)[_0x0fd2('0x89')](_0xfbbf6a)[_0x0fd2('0x8a')]()['value']();return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x204295[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](function(_0x1ea889){return db[_0x0fd2('0x6f')][_0x0fd2('0x8b')](function(_0x4ef946){return _0x1ea889[_0x0fd2('0x7a')](_0x204295[_0x0fd2('0x3a')]['ids'],{'transaction':_0x4ef946})[_0x0fd2('0x26')](function(){if(!_['isEmpty'](_0x930fd8)){return _0x1ea889[_0x0fd2('0x8c')](_0x930fd8,{'transaction':_0x4ef946})[_0x0fd2('0x26')](function(){return db[_0x0fd2('0x74')][_0x0fd2('0x34')]({'where':{'VoiceQueueId':_0x204295[_0x0fd2('0x4e')]['id'],'UserId':_0x930fd8},'transaction':_0x4ef946});});}})['then'](function(){_0x930fd8['forEach'](function(_0x337a61){socket['emit'](_0x0fd2('0x8d'),{'UserId':_0x337a61,'VoiceQueueId':_0x1ea889['id']});});});});});});})[_0x0fd2('0x26')](respondWithStatusCode(_0x3acba7,null))[_0x0fd2('0x4c')](handleError(_0x3acba7,null));};exports[_0x0fd2('0x8e')]=function(_0x2b36ba,_0x8ec643,_0xd0380a){var _0x5e7a1e,_0x33fb11;return db[_0x0fd2('0x48')][_0x0fd2('0x31')]({'where':{'id':_0x2b36ba[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x8ec643,null))[_0x0fd2('0x26')](function(_0x45a93b){if(_0x45a93b){_0x33fb11=_0x45a93b;return _0x45a93b[_0x0fd2('0x8e')](_0x2b36ba[_0x0fd2('0x51')]['ids'],_[_0x0fd2('0x8f')](_0x2b36ba[_0x0fd2('0x51')],[_0x0fd2('0x90'),'id'])||{})[_0x0fd2('0x91')](function(_0x489a04){for(var _0x56fa58=0x0;_0x56fa58<_0x2b36ba[_0x0fd2('0x51')]['ids'][_0x0fd2('0x4f')];_0x56fa58+=0x1){socket[_0x0fd2('0x78')](_0x0fd2('0x79'),{'UserId':Number(_0x2b36ba[_0x0fd2('0x51')]['ids'][_0x56fa58]),'VoiceQueueId':Number(_0x2b36ba[_0x0fd2('0x4e')]['id'])});}return _0x489a04;});}})[_0x0fd2('0x26')](function(_0x278640){_0x5e7a1e=_0x278640||[];if(_0x33fb11){return db[_0x0fd2('0x7b')]['findAll']({'where':{'id':_0x2b36ba[_0x0fd2('0x51')]['ids']},'attributes':['id',_0x0fd2('0x32'),_0x0fd2('0x92'),'voicePause','interface'],'raw':!![]});}})['then'](function(_0x2e2316){if(!_[_0x0fd2('0x93')](_0x2e2316)){var _0x44c4f6=[];for(var _0x5dce22=0x0;_0x5dce22<_0x2e2316[_0x0fd2('0x4f')];_0x5dce22++){if(_0x2e2316[_0x5dce22][_0x0fd2('0x92')]){_0x44c4f6[_0x0fd2('0x83')](db['UserVoiceQueueRt'][_0x0fd2('0x72')]({'membername':_0x2e2316[_0x5dce22][_0x0fd2('0x32')],'UserId':_0x2e2316[_0x5dce22]['id'],'queue_name':_0x33fb11[_0x0fd2('0x32')],'VoiceQueueId':_0x33fb11['id'],'interface':_[_0x0fd2('0x94')](_0x2e2316[_0x5dce22][_0x0fd2('0x6c')])?util['format'](_0x0fd2('0x76'),_0x2e2316[_0x5dce22][_0x0fd2('0x32')]):_0x2e2316[_0x5dce22]['interface'],'paused':_0x2e2316[_0x5dce22][_0x0fd2('0x6b')]||![],'penalty':_0x2b36ba['body'][_0x0fd2('0x6e')]||0x0}));}}return BPromise['all'](_0x44c4f6);}})['then'](function(){return _0x5e7a1e;})['then'](respondWithResult(_0x8ec643,null))[_0x0fd2('0x4c')](handleError(_0x8ec643,null));};exports[_0x0fd2('0x8c')]=function(_0x171fcd,_0x39d82a,_0x352e30){return db[_0x0fd2('0x48')][_0x0fd2('0x31')]({'where':{'id':_0x171fcd[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x39d82a,null))[_0x0fd2('0x26')](function(_0x25ec73){if(_0x25ec73){return _0x25ec73[_0x0fd2('0x8c')](_0x171fcd[_0x0fd2('0x3a')][_0x0fd2('0x90')])[_0x0fd2('0x26')](function(){if(_['isArray'](_0x171fcd[_0x0fd2('0x3a')][_0x0fd2('0x90')])){for(var _0xc64ae7=0x0;_0xc64ae7<_0x171fcd['query'][_0x0fd2('0x90')][_0x0fd2('0x4f')];_0xc64ae7+=0x1){socket['emit'](_0x0fd2('0x8d'),{'UserId':Number(_0x171fcd['query'][_0x0fd2('0x90')][_0xc64ae7]),'VoiceQueueId':Number(_0x171fcd[_0x0fd2('0x4e')]['id'])});}}else{socket[_0x0fd2('0x78')]('userVoiceQueue:remove',{'UserId':Number(_0x171fcd[_0x0fd2('0x3a')][_0x0fd2('0x90')]),'VoiceQueueId':Number(_0x171fcd[_0x0fd2('0x4e')]['id'])});}});}})[_0x0fd2('0x26')](function(_0x386e89){return db[_0x0fd2('0x74')][_0x0fd2('0x34')]({'where':{'VoiceQueueId':_0x171fcd['params']['id'],'UserId':_0x171fcd['query'][_0x0fd2('0x90')]}})[_0x0fd2('0x26')](function(){return _0x386e89;});})[_0x0fd2('0x26')](respondWithStatusCode(_0x39d82a,null))[_0x0fd2('0x4c')](handleError(_0x39d82a,null));};exports[_0x0fd2('0x95')]=function(_0x5288b4,_0x52581b,_0x36f6ad){var _0x38c3dc={};var _0x40d38a={};var _0xcb396d;var _0x3da13b;return db['VoiceQueue'][_0x0fd2('0x5e')]({'where':{'id':_0x5288b4[_0x0fd2('0x4e')]['id']}})['then'](handleEntityNotFound(_0x52581b,null))[_0x0fd2('0x26')](function(_0x12c6fd){if(_0x12c6fd){_0xcb396d=_0x12c6fd;_0x40d38a[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db[_0x0fd2('0x7b')]['rawAttributes']);_0x40d38a[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x5288b4[_0x0fd2('0x3a')]);_0x40d38a['filters']=_[_0x0fd2('0x3d')](_0x40d38a[_0x0fd2('0x3e')],_0x40d38a[_0x0fd2('0x3a')]);_0x38c3dc[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x40d38a[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x38c3dc[_0x0fd2('0x3f')]=_0x38c3dc[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x38c3dc['attributes']:_0x40d38a[_0x0fd2('0x3e')];_0x38c3dc[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x38c3dc['where']=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x5288b4[_0x0fd2('0x3a')],_0x40d38a[_0x0fd2('0x3c')]));if(_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x38c3dc[_0x0fd2('0x44')]=_[_0x0fd2('0x59')](_0x38c3dc['where'],{'$or':_[_0x0fd2('0x2e')](_0x38c3dc['attributes'],function(_0x838146){var _0x46c7de={};_0x46c7de[_0x838146]={'$like':'%'+_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0x46c7de;})});}_0x38c3dc=_[_0x0fd2('0x59')]({},_0x38c3dc,_0x5288b4[_0x0fd2('0x47')]);return _0xcb396d[_0x0fd2('0x95')](_0x38c3dc);}})[_0x0fd2('0x26')](function(_0x9e4ce8){if(_0x9e4ce8){_0x3da13b=_0x9e4ce8[_0x0fd2('0x4f')];if(!_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x41')](_0x0fd2('0x60'))){_0x38c3dc[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x5288b4['query'][_0x0fd2('0x1e')]);_0x38c3dc['offset']=qs['offset'](_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0xcb396d[_0x0fd2('0x95')](_0x38c3dc);}})['then'](function(_0x389a13){if(_0x389a13){return _0x389a13?{'count':_0x3da13b,'rows':_0x389a13}:null;}})[_0x0fd2('0x26')](respondWithResult(_0x52581b,null))[_0x0fd2('0x4c')](handleError(_0x52581b,null));};exports['getMembers']=function(_0x2d72d3,_0x13d21f,_0x839fa2){var _0x2c937e={};var _0x2182ff={};var _0x57a3b7;var _0x4a560f;return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x2d72d3['params']['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x13d21f,null))[_0x0fd2('0x26')](function(_0xfb23b5){if(_0xfb23b5){_0x57a3b7=_0xfb23b5;_0x2182ff[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db[_0x0fd2('0x74')]['rawAttributes']);_0x2182ff[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x2d72d3[_0x0fd2('0x3a')]);_0x2182ff['filters']=_[_0x0fd2('0x3d')](_0x2182ff['model'],_0x2182ff['query']);_0x2c937e[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x2182ff[_0x0fd2('0x3e')],qs['fields'](_0x2d72d3[_0x0fd2('0x3a')]['fields']));_0x2c937e[_0x0fd2('0x3f')]=_0x2c937e[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x2c937e['attributes']:_0x2182ff[_0x0fd2('0x3e')];_0x2c937e[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x2c937e[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x2d72d3['query'],_0x2182ff['filters']));if(_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x2c937e[_0x0fd2('0x44')]=_['merge'](_0x2c937e[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x2c937e['attributes'],function(_0x4cbf0b){var _0xbbdba={};_0xbbdba[_0x4cbf0b]={'$like':'%'+_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0xbbdba;})});}_0x2c937e=_[_0x0fd2('0x59')]({},_0x2c937e,_0x2d72d3[_0x0fd2('0x47')]);return _0x57a3b7[_0x0fd2('0x96')](_0x2c937e);}})['then'](function(_0xbc48){if(_0xbc48){_0x4a560f=_0xbc48['length'];if(!_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x41')](_0x0fd2('0x60'))){_0x2c937e[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x2c937e[_0x0fd2('0x1d')]=qs[_0x0fd2('0x1d')](_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0x57a3b7[_0x0fd2('0x96')](_0x2c937e);}})[_0x0fd2('0x26')](function(_0x46d429){return _0x46d429?{'count':_0x4a560f,'rows':_0x46d429}:null;})[_0x0fd2('0x26')](respondWithResult(_0x13d21f,null))[_0x0fd2('0x4c')](handleError(_0x13d21f,null));};exports[_0x0fd2('0x97')]=function(_0x591dab,_0x187f92,_0x26d3d5){var _0x522123={};var _0xe0bf92={};var _0x15c72e;var _0x59eca9;return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x591dab['params']['id']}})['then'](handleEntityNotFound(_0x187f92,null))[_0x0fd2('0x26')](function(_0x5d3ae7){if(_0x5d3ae7){_0x15c72e=_0x5d3ae7;_0xe0bf92['model']=_[_0x0fd2('0x3b')](db['CmList'][_0x0fd2('0x38')]);_0xe0bf92[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x591dab[_0x0fd2('0x3a')]);_0xe0bf92[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0xe0bf92[_0x0fd2('0x3e')],_0xe0bf92[_0x0fd2('0x3a')]);_0x522123[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0xe0bf92[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x522123['attributes']=_0x522123[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x522123['attributes']:_0xe0bf92[_0x0fd2('0x3e')];_0x522123['order']=qs[_0x0fd2('0x43')](_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x522123['where']=qs['filters'](_[_0x0fd2('0x45')](_0x591dab[_0x0fd2('0x3a')],_0xe0bf92[_0x0fd2('0x3c')]));if(_0x591dab['query'][_0x0fd2('0x2c')]){_0x522123[_0x0fd2('0x44')]=_[_0x0fd2('0x59')](_0x522123[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x522123[_0x0fd2('0x3f')],function(_0x3ce674){var _0x43f2c6={};_0x43f2c6[_0x3ce674]={'$like':'%'+_0x591dab['query']['filter']+'%'};return _0x43f2c6;})});}_0x522123=_[_0x0fd2('0x59')]({},_0x522123,_0x591dab[_0x0fd2('0x47')]);return _0x15c72e[_0x0fd2('0x97')](_0x522123);}})[_0x0fd2('0x26')](function(_0xaace5f){if(_0xaace5f){_0x59eca9=_0xaace5f[_0x0fd2('0x4f')];if(!_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x41')](_0x0fd2('0x60'))){_0x522123[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x522123[_0x0fd2('0x1d')]=qs[_0x0fd2('0x1d')](_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0x15c72e['getLists'](_0x522123);}})[_0x0fd2('0x26')](function(_0x451f31){if(_0x451f31){return _0x451f31?{'count':_0x59eca9,'rows':_0x451f31}:null;}})[_0x0fd2('0x26')](respondWithResult(_0x187f92,null))[_0x0fd2('0x4c')](handleError(_0x187f92,null));};exports[_0x0fd2('0x98')]=function(_0x468f7a,_0x4b0e7d,_0x4e1cef){var _0x2dc84d=moment()['format'](_0x0fd2('0x99'));var _0x1b61b2,_0x4f4b3b;return db[_0x0fd2('0x48')][_0x0fd2('0x31')]({'where':{'id':_0x468f7a[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x4b0e7d,null))['then'](function(_0x203fbe){if(_0x203fbe){_0x4f4b3b=_0x203fbe;return _0x203fbe[_0x0fd2('0x98')](_0x468f7a[_0x0fd2('0x51')][_0x0fd2('0x90')],_[_0x0fd2('0x8f')](_0x468f7a[_0x0fd2('0x51')],[_0x0fd2('0x90'),'id'])||{});}return null;})['spread'](function(_0x23a184){var _0x544885;_0x1b61b2=_0x23a184||[];var _0x6d0e63=[];if(_0x23a184){for(var _0x2379c0=0x0;_0x2379c0<_0x23a184[_0x0fd2('0x4f')];_0x2379c0+=0x1){var _0x285bd7=_0x23a184[_0x2379c0][_0x0fd2('0x27')]({'plain':!![]});_0x4f4b3b[_0x0fd2('0x9a')]=_0x468f7a['body'][_0x0fd2('0x9a')]?_0x468f7a[_0x0fd2('0x51')][_0x0fd2('0x9a')]:_0x4f4b3b[_0x0fd2('0x9a')];switch(_0x4f4b3b['dialCheckDuplicateType']){case _0x0fd2('0x9b'):_0x544885=squel[_0x0fd2('0x9c')]()['into'](_0x0fd2('0x9d'))[_0x0fd2('0x9e')]([_0x0fd2('0x9f'),'scheduledAt','ContactId',_0x0fd2('0xa0'),_0x0fd2('0x61'),_0x0fd2('0x5a'),'updatedAt'],squel['select']()[_0x0fd2('0x7c')](_0x0fd2('0x9f'),_0x0fd2('0x9f'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0xa1'))[_0x0fd2('0x7c')]('id',_0x0fd2('0xa2'))[_0x0fd2('0x7c')](_0x285bd7['CmListId'][_0x0fd2('0x84')](),_0x0fd2('0xa0'))[_0x0fd2('0x7c')](_0x468f7a[_0x0fd2('0x4e')]['id'][_0x0fd2('0x84')](),'VoiceQueueId')[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0x5a'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0x5b'))[_0x0fd2('0x7d')](_0x0fd2('0xa3'))[_0x0fd2('0x44')](_0x0fd2('0xa4'))[_0x0fd2('0x44')](_0x0fd2('0xa5'),_0x285bd7[_0x0fd2('0xa6')][_0x0fd2('0x84')]())[_0x0fd2('0x44')]('phone\x20IS\x20NOT\x20NULL')[_0x0fd2('0x44')](_0x0fd2('0xa7'),squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')]('COALESCE(calleridnum,\x27\x27)')[_0x0fd2('0x7d')]('cm_hopper_final')[_0x0fd2('0x44')]('VoiceQueueId\x20=\x20?',_0x468f7a[_0x0fd2('0x4e')]['id']['toString']()))[_0x0fd2('0x44')](_0x0fd2('0xa7'),squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')](_0x0fd2('0xa9'))[_0x0fd2('0x7d')](_0x0fd2('0x9d'))[_0x0fd2('0x44')](_0x0fd2('0x81'),_0x468f7a[_0x0fd2('0x4e')]['id'][_0x0fd2('0x84')]())))[_0x0fd2('0x84')]();break;case _0x0fd2('0xaa'):_0x544885=squel['insert']()[_0x0fd2('0xab')]('cm_hopper')['fromQuery']([_0x0fd2('0x9f'),_0x0fd2('0xa1'),_0x0fd2('0xa2'),_0x0fd2('0xa0'),_0x0fd2('0x61'),_0x0fd2('0x5a'),'updatedAt'],squel[_0x0fd2('0xa8')]()['field'](_0x0fd2('0x9f'),_0x0fd2('0x9f'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','scheduledAt')[_0x0fd2('0x7c')]('id',_0x0fd2('0xa2'))[_0x0fd2('0x7c')](_0x285bd7[_0x0fd2('0xa6')]['toString'](),_0x0fd2('0xa0'))[_0x0fd2('0x7c')](_0x468f7a[_0x0fd2('0x4e')]['id'][_0x0fd2('0x84')](),_0x0fd2('0x61'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','createdAt')[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','updatedAt')[_0x0fd2('0x7d')]('cm_contacts')[_0x0fd2('0x44')]('deletedAt\x20IS\x20NULL')[_0x0fd2('0x44')]('ListId\x20=\x20?',_0x285bd7['CmListId'][_0x0fd2('0x84')]())[_0x0fd2('0x44')](_0x0fd2('0xac'))[_0x0fd2('0x44')](_0x0fd2('0xa7'),squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')](_0x0fd2('0xa9'))[_0x0fd2('0x7d')]('cm_hopper')[_0x0fd2('0x44')]('VoiceQueueId\x20=\x20?',_0x468f7a[_0x0fd2('0x4e')]['id']['toString']())))[_0x0fd2('0x84')]();break;default:_0x544885=squel[_0x0fd2('0x9c')]()['into'](_0x0fd2('0x9d'))['fromQuery']([_0x0fd2('0x9f'),_0x0fd2('0xa1'),_0x0fd2('0xa2'),_0x0fd2('0xa0'),'VoiceQueueId',_0x0fd2('0x5a'),_0x0fd2('0x5b')],squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')](_0x0fd2('0x9f'),'phone')[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','scheduledAt')['field']('id','ContactId')[_0x0fd2('0x7c')](_0x285bd7[_0x0fd2('0xa6')]['toString'](),_0x0fd2('0xa0'))['field'](_0x468f7a[_0x0fd2('0x4e')]['id'][_0x0fd2('0x84')](),_0x0fd2('0x61'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','createdAt')[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0x5b'))[_0x0fd2('0x7d')](_0x0fd2('0xa3'))[_0x0fd2('0x44')]('deletedAt\x20IS\x20NULL')[_0x0fd2('0x44')]('ListId\x20=\x20?',_0x285bd7[_0x0fd2('0xa6')]['toString']())[_0x0fd2('0x44')](_0x0fd2('0xac')))[_0x0fd2('0x84')]();}_0x6d0e63[_0x0fd2('0x83')](db[_0x0fd2('0x6f')][_0x0fd2('0x3a')](_0x544885));}return BPromise['all'](_0x6d0e63);}})[_0x0fd2('0x26')](function(){var _0x4b2a0e=[];var _0x1ad987=squel[_0x0fd2('0x9c')]()[_0x0fd2('0xab')]('cm_hopper_additional_phones')[_0x0fd2('0x9e')]([_0x0fd2('0xad'),'phone',_0x0fd2('0xae'),_0x0fd2('0x5a'),'updatedAt'],squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')]('h.id')[_0x0fd2('0x7c')](_0x0fd2('0xaf'))[_0x0fd2('0x7c')](_0x0fd2('0xb0'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0x5a'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','updatedAt')[_0x0fd2('0x7d')](_0x0fd2('0xb1'),'ci')[_0x0fd2('0x7e')](_0x0fd2('0x9d'),'h','h.ContactId=ci.CmContactId')[_0x0fd2('0x44')](_0x0fd2('0xb2'),_0x2dc84d)[_0x0fd2('0x44')](_0x0fd2('0xb3'),_0x0fd2('0xb4')))[_0x0fd2('0x84')]();_0x4b2a0e['push'](db[_0x0fd2('0x6f')]['query'](_0x1ad987));return BPromise[_0x0fd2('0xb5')](_0x4b2a0e);})[_0x0fd2('0x26')](function(){return _0x1b61b2;})['then'](respondWithResult(_0x4b0e7d,null))['catch'](handleError(_0x4b0e7d,null));};exports[_0x0fd2('0xb6')]=function(_0x3878eb,_0x5383ea,_0x260a1d){return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x3878eb['params']['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x5383ea,null))[_0x0fd2('0x26')](function(_0x4fd20b){if(_0x4fd20b){return _0x4fd20b[_0x0fd2('0xb6')](_0x3878eb[_0x0fd2('0x3a')][_0x0fd2('0x90')]);}})[_0x0fd2('0x26')](function(_0x318144){if(_0x318144){return db[_0x0fd2('0x5f')][_0x0fd2('0x34')]({'where':{'ListId':_0x3878eb[_0x0fd2('0x3a')][_0x0fd2('0x90')],'VoiceQueueId':_0x3878eb[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](function(){return _0x318144;});}})[_0x0fd2('0x26')](respondWithStatusCode(_0x5383ea,null))[_0x0fd2('0x4c')](handleError(_0x5383ea,null));};exports['getBlackLists']=function(_0x51b80a,_0x54585d,_0x407be5){var _0x241914={};var _0x64e087={};var _0x35479a;var _0x81b4bb;return db[_0x0fd2('0x48')]['findOne']({'where':{'id':_0x51b80a[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x54585d,null))['then'](function(_0x2ec276){if(_0x2ec276){_0x35479a=_0x2ec276;_0x64e087['model']=_[_0x0fd2('0x3b')](db[_0x0fd2('0xb7')][_0x0fd2('0x38')]);_0x64e087[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x51b80a[_0x0fd2('0x3a')]);_0x64e087[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x64e087[_0x0fd2('0x3e')],_0x64e087[_0x0fd2('0x3a')]);_0x241914[_0x0fd2('0x3f')]=_['intersection'](_0x64e087[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x51b80a[_0x0fd2('0x3a')]['fields']));_0x241914['attributes']=_0x241914[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x241914[_0x0fd2('0x3f')]:_0x64e087[_0x0fd2('0x3e')];_0x241914['order']=qs[_0x0fd2('0x43')](_0x51b80a[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x241914[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_['pick'](_0x51b80a['query'],_0x64e087[_0x0fd2('0x3c')]));if(_0x51b80a[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x241914[_0x0fd2('0x44')]=_['merge'](_0x241914[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x241914[_0x0fd2('0x3f')],function(_0x2c7824){var _0x1ec0da={};_0x1ec0da[_0x2c7824]={'$like':'%'+_0x51b80a['query']['filter']+'%'};return _0x1ec0da;})});}_0x241914=_[_0x0fd2('0x59')]({},_0x241914,_0x51b80a[_0x0fd2('0x47')]);return _0x35479a[_0x0fd2('0xb8')](_0x241914);}})[_0x0fd2('0x26')](function(_0x5a3e6d){if(_0x5a3e6d){_0x81b4bb=_0x5a3e6d[_0x0fd2('0x4f')];if(!_0x51b80a['query']['hasOwnProperty'](_0x0fd2('0x60'))){_0x241914[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x51b80a[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x241914['offset']=qs[_0x0fd2('0x1d')](_0x51b80a[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0x35479a[_0x0fd2('0xb8')](_0x241914);}})['then'](function(_0x4567ad){if(_0x4567ad){return _0x4567ad?{'count':_0x81b4bb,'rows':_0x4567ad}:null;}})[_0x0fd2('0x26')](respondWithResult(_0x54585d,null))[_0x0fd2('0x4c')](handleError(_0x54585d,null));};exports[_0x0fd2('0xb9')]=function(_0x30ef90,_0x6ea2c8,_0x17a770){var _0x34b662,_0x14df62;return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x30ef90[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x6ea2c8,null))[_0x0fd2('0x26')](function(_0x3c0c6c){if(_0x3c0c6c){_0x14df62=_0x3c0c6c;return _0x3c0c6c[_0x0fd2('0xb9')](_0x30ef90[_0x0fd2('0x51')]['ids'],_[_0x0fd2('0x8f')](_0x30ef90[_0x0fd2('0x51')],[_0x0fd2('0x90'),'id'])||{});}return null;})[_0x0fd2('0x91')](function(_0x1da9f3){var _0x50e7ba;_0x34b662=_0x1da9f3||[];var _0x1739c7=[];if(_0x1da9f3){for(var _0x59618c=0x0;_0x59618c<_0x1da9f3[_0x0fd2('0x4f')];_0x59618c+=0x1){var _0x18ec77=_0x1da9f3[_0x59618c][_0x0fd2('0x27')]({'plain':!![]});_0x50e7ba=squel[_0x0fd2('0x9c')]()[_0x0fd2('0xab')](_0x0fd2('0xba'))[_0x0fd2('0x9e')]([_0x0fd2('0x9f'),_0x0fd2('0xa2'),_0x0fd2('0xa0'),'VoiceQueueId',_0x0fd2('0x5a'),_0x0fd2('0x5b')],squel['select']()[_0x0fd2('0x7c')](_0x0fd2('0x9f'),_0x0fd2('0x9f'))[_0x0fd2('0x7c')]('id',_0x0fd2('0xa2'))[_0x0fd2('0x7c')](_0x18ec77[_0x0fd2('0xa6')][_0x0fd2('0x84')](),'ListId')[_0x0fd2('0x7c')](_0x30ef90['params']['id'][_0x0fd2('0x84')](),_0x0fd2('0x61'))[_0x0fd2('0x7c')](_0x0fd2('0xbb'),_0x0fd2('0x5a'))[_0x0fd2('0x7c')](_0x0fd2('0xbb'),_0x0fd2('0x5b'))[_0x0fd2('0x7d')](_0x0fd2('0xa3'))[_0x0fd2('0x44')](_0x0fd2('0xa4'))[_0x0fd2('0x44')](_0x0fd2('0xa5'),_0x18ec77[_0x0fd2('0xa6')][_0x0fd2('0x84')]())[_0x0fd2('0x44')](_0x0fd2('0xac')))['toString']();_0x1739c7['push'](db[_0x0fd2('0x6f')][_0x0fd2('0x3a')](_0x50e7ba));}return BPromise[_0x0fd2('0xb5')](_0x1739c7);}})[_0x0fd2('0x26')](function(){return _0x34b662;})[_0x0fd2('0x26')](respondWithResult(_0x6ea2c8,null))[_0x0fd2('0x4c')](handleError(_0x6ea2c8,null));};exports[_0x0fd2('0xbc')]=function(_0x2085ad,_0x44db9a,_0x5134d9){return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x2085ad[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x44db9a,null))[_0x0fd2('0x26')](function(_0x5af168){if(_0x5af168){return _0x5af168[_0x0fd2('0xbc')](_0x2085ad['query'][_0x0fd2('0x90')]);}})[_0x0fd2('0x26')](function(_0x30e702){if(_0x30e702){return db[_0x0fd2('0x66')][_0x0fd2('0x34')]({'where':{'ListId':_0x2085ad['query'][_0x0fd2('0x90')],'VoiceQueueId':_0x2085ad[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](function(){return _0x30e702;});}})[_0x0fd2('0x26')](respondWithStatusCode(_0x44db9a,null))['catch'](handleError(_0x44db9a,null));};
\ No newline at end of file