// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x7f93=['status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','get','VoiceQueues','inbound','QueueCampaigns','filter','ignore','map','value','includes','find','type','name','UserProfileResource','send','index','VoiceQueue','fieldName','key','query','keys','filters','intersection','model','fields','attributes','nolimit','order','sort','pick','where','merge','VIRTUAL','options','includeAll','findAll','catch','params','rawAttributes','length','create','body','user','role','outbound','UserProfileSection','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','include','omit','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','userProfileId','getHoppers','findOne','CmHopper','hasOwnProperty','VoiceQueueId','rows','getHopperHistories','CmHopperFinal','CmHopperBlack','getTeams','Team','addTeams','teams','User','Agents','online','voicePause','flatMap','forEach','penalty','sequelize','transaction','findOrCreate','UserVoiceQueueRt','upsert','isNil','interface','format','SIP/%s','removeTeams','select','field','tq.TeamId','from','team_has_voice_queues','join','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','SELECT','every','TeamId','all','union','compact','emit','addAgents','ids','spread','userVoiceQueue:save','isEmpty','removeAgents','isArray','userVoiceQueue:remove','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','always','insert','cm_hopper','fromQuery','phone','ListId','NOW()','ContactId','CmListId','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','COALESCE(phone,\x27\x27)','onlyIfOpen','into','scheduledAt','ListId\x20=\x20?','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','sendStatus'];(function(_0x3ff10b,_0x3ceeba){var _0x4f116f=function(_0x5052b7){while(--_0x5052b7){_0x3ff10b['push'](_0x3ff10b['shift']());}};_0x4f116f(++_0x3ceeba);}(_0x7f93,0x153));var _0x37f9=function(_0x123d7f,_0x24ea2c){_0x123d7f=_0x123d7f-0x0;var _0x2c8dea=_0x7f93[_0x123d7f];return _0x2c8dea;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x37f9('0x0'));var jsonpatch=require(_0x37f9('0x1'));var rp=require(_0x37f9('0x2'));var moment=require(_0x37f9('0x3'));var BPromise=require(_0x37f9('0x4'));var Mustache=require(_0x37f9('0x5'));var util=require(_0x37f9('0x6'));var path=require(_0x37f9('0x7'));var sox=require('sox');var csv=require(_0x37f9('0x8'));var ejs=require(_0x37f9('0x9'));var fs=require('fs');var _=require(_0x37f9('0xa'));var squel=require('squel');var crypto=require(_0x37f9('0xb'));var jsforce=require(_0x37f9('0xc'));var deskjs=require(_0x37f9('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x37f9('0xe'));var Redis=require('ioredis');var authService=require(_0x37f9('0xf'));var qs=require(_0x37f9('0x10'));var as=require(_0x37f9('0x11'));var hardwareService=require(_0x37f9('0x12'));var logger=require('../../config/logger')(_0x37f9('0x13'));var utils=require(_0x37f9('0x14'));var config=require(_0x37f9('0x15'));var licenseUtil=require(_0x37f9('0x16'));var db=require('../../mysqldb')['db'];config[_0x37f9('0x17')]=_[_0x37f9('0x18')](config[_0x37f9('0x17')],{'host':_0x37f9('0x19'),'port':0x18eb});var socket=require(_0x37f9('0x1a'))(new Redis(config[_0x37f9('0x17')]));require(_0x37f9('0x1b'))['register'](socket);function respondWithStatusCode(_0x36a202,_0x1fe1f9){_0x1fe1f9=_0x1fe1f9||0xcc;return function(_0x334605){if(_0x334605){return _0x36a202[_0x37f9('0x1c')](_0x1fe1f9);}return _0x36a202[_0x37f9('0x1d')](_0x1fe1f9)[_0x37f9('0x1e')]();};}function respondWithResult(_0x3f70a3,_0x5f2a0b){_0x5f2a0b=_0x5f2a0b||0xc8;return function(_0x11a2c6){if(_0x11a2c6){return _0x3f70a3[_0x37f9('0x1d')](_0x5f2a0b)[_0x37f9('0x1f')](_0x11a2c6);}};}function respondWithFilteredResult(_0x484990,_0x6546bd){return function(_0x2a1f9d){if(_0x2a1f9d){var _0x1de03d=_0x2a1f9d[_0x37f9('0x20')],_0x5592cb=_0x6546bd['offset'],_0x2f8f6d=_0x6546bd[_0x37f9('0x21')]+_0x6546bd[_0x37f9('0x22')],_0x579084;if(_0x2f8f6d>=_0x1de03d){_0x2f8f6d=_0x1de03d;_0x579084=0xc8;}else{_0x579084=0xce;}_0x484990[_0x37f9('0x1d')](_0x579084);return _0x484990[_0x37f9('0x23')](_0x37f9('0x24'),_0x5592cb+'-'+_0x2f8f6d+'/'+_0x1de03d)['json'](_0x2a1f9d);}return null;};}function patchUpdates(_0x114662){return function(_0x3134f2){try{jsonpatch[_0x37f9('0x25')](_0x3134f2,_0x114662,!![]);}catch(_0x496d09){return BPromise[_0x37f9('0x26')](_0x496d09);}return _0x3134f2[_0x37f9('0x27')]();};}function saveUpdates(_0x181b91,_0x13566f){return function(_0x47ecb8){if(_0x47ecb8){return _0x47ecb8[_0x37f9('0x28')](_0x181b91)[_0x37f9('0x29')](function(_0x37784a){return _0x37784a;});}return null;};}function removeEntity(_0x58149a,_0x3c3e70){return function(_0x5cfd03){if(_0x5cfd03){return _0x5cfd03[_0x37f9('0x2a')]()[_0x37f9('0x29')](function(){var _0x6b8a14=_0x5cfd03[_0x37f9('0x2b')]({'plain':!![]});var _0x53c51c=[{'name':_0x37f9('0x2c'),'value':_0x37f9('0x2d'),'ignore':![]},{'name':_0x37f9('0x2e'),'value':'outbound','ignore':![]}];var _0x25b727=_(_0x53c51c)[_0x37f9('0x2f')](_0x37f9('0x30'))[_0x37f9('0x31')]('value')[_0x37f9('0x32')]();if(_[_0x37f9('0x33')](_0x25b727,_0x6b8a14['type'])){return;}var _0x177b05=_[_0x37f9('0x34')](_0x53c51c,['value',_0x6b8a14[_0x37f9('0x35')]])[_0x37f9('0x36')];return db[_0x37f9('0x37')][_0x37f9('0x2a')]({'where':{'type':_0x177b05,'resourceId':_0x6b8a14['id']}})[_0x37f9('0x29')](function(){return _0x5cfd03;});})[_0x37f9('0x29')](function(){_0x58149a[_0x37f9('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0xaa0d05,_0x16bff5){return function(_0x4d3d2d){if(!_0x4d3d2d){_0xaa0d05[_0x37f9('0x1c')](0x194);}return _0x4d3d2d;};}function handleError(_0x307102,_0xfe6bfd){_0xfe6bfd=_0xfe6bfd||0x1f4;return function(_0xebbbcf){logger['error'](_0xebbbcf['stack']);if(_0xebbbcf['name']){delete _0xebbbcf['name'];}_0x307102[_0x37f9('0x1d')](_0xfe6bfd)[_0x37f9('0x38')](_0xebbbcf);};}exports[_0x37f9('0x39')]=function(_0x4d04d8,_0x94401b){var _0xd4a861={},_0x48645c={},_0xc81f28={'count':0x0,'rows':[]};var _0x411fc6=_[_0x37f9('0x31')](db[_0x37f9('0x3a')]['rawAttributes'],function(_0x368e82){return{'name':_0x368e82[_0x37f9('0x3b')],'type':_0x368e82[_0x37f9('0x35')][_0x37f9('0x3c')]};});_0x48645c['model']=_[_0x37f9('0x31')](_0x411fc6,_0x37f9('0x36'));_0x48645c[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x4d04d8['query']);_0x48645c[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x48645c[_0x37f9('0x41')],_0x48645c[_0x37f9('0x3d')]);_0xd4a861['attributes']=_[_0x37f9('0x40')](_0x48645c[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x42')]));_0xd4a861[_0x37f9('0x43')]=_0xd4a861[_0x37f9('0x43')]['length']?_0xd4a861[_0x37f9('0x43')]:_0x48645c[_0x37f9('0x41')];if(!_0x4d04d8[_0x37f9('0x3d')]['hasOwnProperty'](_0x37f9('0x44'))){_0xd4a861[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x4d04d8['query']['limit']);_0xd4a861['offset']=qs['offset'](_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x21')]);}_0xd4a861[_0x37f9('0x45')]=qs['sort'](_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x46')]);_0xd4a861['where']=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x4d04d8['query'],_0x48645c[_0x37f9('0x3f')]),_0x411fc6);if(_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x2f')]){_0xd4a861[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0xd4a861[_0x37f9('0x48')],{'$or':_[_0x37f9('0x31')](_0x411fc6,function(_0x338d85){if(_0x338d85['type']!==_0x37f9('0x4a')){var _0x40fd89={};_0x40fd89[_0x338d85[_0x37f9('0x36')]]={'$like':'%'+_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x40fd89;}})});}_0xd4a861=_[_0x37f9('0x49')]({},_0xd4a861,_0x4d04d8[_0x37f9('0x4b')]);var _0x2bec95={'where':_0xd4a861['where']};return db['VoiceQueue'][_0x37f9('0x20')](_0x2bec95)[_0x37f9('0x29')](function(_0x181f6e){_0xc81f28[_0x37f9('0x20')]=_0x181f6e;if(_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0xd4a861['include']=[{'all':!![]}];}return db[_0x37f9('0x3a')][_0x37f9('0x4d')](_0xd4a861);})[_0x37f9('0x29')](function(_0x2a9c3d){_0xc81f28['rows']=_0x2a9c3d;return _0xc81f28;})[_0x37f9('0x29')](respondWithFilteredResult(_0x94401b,_0xd4a861))[_0x37f9('0x4e')](handleError(_0x94401b,null));};exports['show']=function(_0x825a9e,_0xbfa661){var _0x19e524={'raw':![],'where':{'id':_0x825a9e[_0x37f9('0x4f')]['id']}},_0x2bc856={};_0x2bc856[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db['VoiceQueue'][_0x37f9('0x50')]);_0x2bc856[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x825a9e[_0x37f9('0x3d')]);_0x2bc856[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x2bc856[_0x37f9('0x41')],_0x2bc856[_0x37f9('0x3d')]);_0x19e524['attributes']=_[_0x37f9('0x40')](_0x2bc856['model'],qs[_0x37f9('0x42')](_0x825a9e[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x19e524['attributes']=_0x19e524[_0x37f9('0x43')][_0x37f9('0x51')]?_0x19e524[_0x37f9('0x43')]:_0x2bc856[_0x37f9('0x41')];if(_0x825a9e[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0x19e524['include']=[{'all':!![]}];}_0x19e524=_[_0x37f9('0x49')]({},_0x19e524,_0x825a9e[_0x37f9('0x4b')]);return db[_0x37f9('0x3a')][_0x37f9('0x34')](_0x19e524)[_0x37f9('0x29')](handleEntityNotFound(_0xbfa661,null))[_0x37f9('0x29')](respondWithResult(_0xbfa661,null))[_0x37f9('0x4e')](handleError(_0xbfa661,null));};exports['create']=function(_0x552bf4,_0x50132a){return db[_0x37f9('0x3a')][_0x37f9('0x52')](_0x552bf4[_0x37f9('0x53')],{})[_0x37f9('0x29')](function(_0x3a864d){var _0x535636=_0x552bf4[_0x37f9('0x54')][_0x37f9('0x2b')]({'plain':!![]});if(!_0x535636)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x535636[_0x37f9('0x55')]==='user'){var _0x2b1c82=_0x3a864d[_0x37f9('0x2b')]({'plain':!![]});var _0xd37646=[{'name':_0x37f9('0x2c'),'value':_0x37f9('0x2d')},{'name':_0x37f9('0x2e'),'value':_0x37f9('0x56')}];var _0x1140c7=_['find'](_0xd37646,[_0x37f9('0x32'),_0x2b1c82[_0x37f9('0x35')]])[_0x37f9('0x36')];return db[_0x37f9('0x57')][_0x37f9('0x34')]({'where':{'name':_0x1140c7,'userProfileId':_0x535636['userProfileId']},'raw':!![]})[_0x37f9('0x29')](function(_0x5df2d8){if(_0x5df2d8&&_0x5df2d8[_0x37f9('0x58')]===0x0){return db[_0x37f9('0x37')][_0x37f9('0x52')]({'name':_0x2b1c82['name'],'resourceId':_0x2b1c82['id'],'type':_0x5df2d8['name'],'sectionId':_0x5df2d8['id']},{})[_0x37f9('0x29')](function(){return _0x3a864d;});}else{return _0x3a864d;}})['catch'](function(_0x225222){logger[_0x37f9('0x59')](_0x37f9('0x5a'),_0x225222);throw _0x225222;});}return _0x3a864d;})[_0x37f9('0x29')](respondWithResult(_0x50132a,0xc9))[_0x37f9('0x4e')](handleError(_0x50132a,null));};exports['clone']=function(_0x3c6acd,_0x43159e){var _0x23c552={'where':{'id':_0x3c6acd[_0x37f9('0x4f')]['id']}},_0x5948c3={};_0x5948c3['model']=_[_0x37f9('0x3e')](db[_0x37f9('0x3a')][_0x37f9('0x50')]);_0x23c552['attributes']=_[_0x37f9('0x40')](_0x5948c3[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x3c6acd['query'][_0x37f9('0x42')]));_0x23c552[_0x37f9('0x43')]=_0x23c552['attributes'][_0x37f9('0x51')]?_0x23c552[_0x37f9('0x43')]:_0x5948c3[_0x37f9('0x41')];if(_0x3c6acd[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0x23c552[_0x37f9('0x5b')]=[{'all':!![]}];}_0x23c552=_[_0x37f9('0x49')]({},_0x23c552,_0x3c6acd[_0x37f9('0x4b')]);return db[_0x37f9('0x3a')][_0x37f9('0x34')](_0x23c552)['then'](handleEntityNotFound(_0x43159e,null))[_0x37f9('0x29')](function(_0x209824){if(_0x209824){var _0x5bb5c5=_0x209824['get']({'plain':!![]});_0x5bb5c5=qs[_0x37f9('0x5c')](_0x5bb5c5,['id',_0x37f9('0x5d'),_0x37f9('0x5e')]);_0x3c6acd[_0x37f9('0x53')]=_['omit'](_0x3c6acd[_0x37f9('0x53')],['id',_0x37f9('0x5d'),_0x37f9('0x5e')]);return db[_0x37f9('0x3a')][_0x37f9('0x52')](_[_0x37f9('0x49')](_0x5bb5c5,_0x3c6acd['body']),{'include':_0x3c6acd[_0x37f9('0x3d')][_0x37f9('0x4c')]?[{'all':!![]}]:undefined})[_0x37f9('0x29')](function(_0x1a5fe3){var _0x52314d=_0x3c6acd[_0x37f9('0x54')][_0x37f9('0x2b')]({'plain':!![]});if(!_0x52314d)throw new Error(_0x37f9('0x5f'));if(_0x52314d[_0x37f9('0x55')]===_0x37f9('0x54')){var _0x5580bc=_0x1a5fe3[_0x37f9('0x2b')]({'plain':!![]});var _0x131920=[{'name':_0x37f9('0x2c'),'value':_0x37f9('0x2d')},{'name':_0x37f9('0x2e'),'value':_0x37f9('0x56')}];var _0x3e31a6=_['find'](_0x131920,[_0x37f9('0x32'),_0x5580bc[_0x37f9('0x35')]])[_0x37f9('0x36')];return db[_0x37f9('0x57')]['find']({'where':{'name':_0x3e31a6,'userProfileId':_0x52314d[_0x37f9('0x60')]},'raw':!![]})['then'](function(_0x273ef1){if(_0x273ef1&&_0x273ef1[_0x37f9('0x58')]===0x0){return db[_0x37f9('0x37')][_0x37f9('0x52')]({'name':_0x5580bc[_0x37f9('0x36')],'resourceId':_0x5580bc['id'],'type':_0x273ef1['name'],'sectionId':_0x273ef1['id']},{})[_0x37f9('0x29')](function(){return _0x1a5fe3;});}else{return _0x1a5fe3;}})[_0x37f9('0x4e')](function(_0x2386c5){logger[_0x37f9('0x59')](_0x37f9('0x5a'),_0x2386c5);throw _0x2386c5;});}return _0x1a5fe3;});}})[_0x37f9('0x29')](respondWithResult(_0x43159e,0xc9))[_0x37f9('0x4e')](handleError(_0x43159e,null));};exports['update']=function(_0xf38da2,_0x4fd8c8){if(_0xf38da2[_0x37f9('0x53')]['id']){delete _0xf38da2[_0x37f9('0x53')]['id'];}return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0xf38da2[_0x37f9('0x4f')]['id']}})['then'](handleEntityNotFound(_0x4fd8c8,null))[_0x37f9('0x29')](saveUpdates(_0xf38da2[_0x37f9('0x53')],null))[_0x37f9('0x29')](respondWithResult(_0x4fd8c8,null))['catch'](handleError(_0x4fd8c8,null));};exports[_0x37f9('0x2a')]=function(_0x29244e,_0x1aab7f){return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0x29244e[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x1aab7f,null))[_0x37f9('0x29')](removeEntity(_0x1aab7f,null))['catch'](handleError(_0x1aab7f,null));};exports[_0x37f9('0x61')]=function(_0x4e0831,_0x317c59,_0x2c7cf7){var _0x29ea19={'raw':![],'where':{}};var _0x29d1c4={};var _0x94bf83={'count':0x0,'rows':[]};return db[_0x37f9('0x3a')][_0x37f9('0x62')]({'where':{'id':_0x4e0831['params']['id']}})['then'](handleEntityNotFound(_0x317c59,null))[_0x37f9('0x29')](function(_0x4e65bb){if(_0x4e65bb){_0x29d1c4[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x63')][_0x37f9('0x50')]);_0x29d1c4[_0x37f9('0x3d')]=_['keys'](_0x4e0831[_0x37f9('0x3d')]);_0x29d1c4[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x29d1c4[_0x37f9('0x41')],_0x29d1c4[_0x37f9('0x3d')]);_0x29ea19[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x29d1c4[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x4e0831[_0x37f9('0x3d')]['fields']));_0x29ea19[_0x37f9('0x43')]=_0x29ea19[_0x37f9('0x43')][_0x37f9('0x51')]?_0x29ea19['attributes']:_0x29d1c4['model'];if(!_0x4e0831['query'][_0x37f9('0x64')](_0x37f9('0x44'))){_0x29ea19['limit']=qs[_0x37f9('0x22')](_0x4e0831[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x29ea19[_0x37f9('0x21')]=qs['offset'](_0x4e0831['query'][_0x37f9('0x21')]);}_0x29ea19['order']=qs['sort'](_0x4e0831[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x29ea19[_0x37f9('0x48')]=qs['filters'](_[_0x37f9('0x47')](_0x4e0831[_0x37f9('0x3d')],_0x29d1c4[_0x37f9('0x3f')]));_0x29ea19[_0x37f9('0x48')][_0x37f9('0x65')]=_0x4e65bb['id'];if(_0x4e0831['query']['filter']){_0x29ea19[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x29ea19[_0x37f9('0x48')],{'$or':_[_0x37f9('0x31')](_0x29ea19['attributes'],function(_0x554f3b){var _0x3da191={};_0x3da191[_0x554f3b]={'$like':'%'+_0x4e0831['query'][_0x37f9('0x2f')]+'%'};return _0x3da191;})});}_0x29ea19=_['merge']({},_0x29ea19,_0x4e0831['options']);return db[_0x37f9('0x63')]['count']({'where':_0x29ea19[_0x37f9('0x48')]})[_0x37f9('0x29')](function(_0x26958b){_0x94bf83[_0x37f9('0x20')]=_0x26958b;if(_0x4e0831[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0x29ea19['include']=[{'all':!![]}];}return db[_0x37f9('0x63')]['findAll'](_0x29ea19);})[_0x37f9('0x29')](function(_0x47e66e){_0x94bf83[_0x37f9('0x66')]=_0x47e66e;return _0x94bf83;});}})[_0x37f9('0x29')](respondWithFilteredResult(_0x317c59,_0x29ea19))[_0x37f9('0x4e')](handleError(_0x317c59,null));};exports[_0x37f9('0x67')]=function(_0x3bf50f,_0x24c480,_0x3059fa){var _0x410c1c={'raw':!![],'where':{}};var _0x5608fa={};var _0x203bae={'count':0x0,'rows':[]};return db[_0x37f9('0x3a')][_0x37f9('0x62')]({'where':{'id':_0x3bf50f[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x24c480,null))[_0x37f9('0x29')](function(_0x213c7d){if(_0x213c7d){_0x5608fa[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db['CmHopperHistory'][_0x37f9('0x50')]);_0x5608fa[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x3bf50f[_0x37f9('0x3d')]);_0x5608fa[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x5608fa[_0x37f9('0x41')],_0x5608fa[_0x37f9('0x3d')]);_0x410c1c[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x5608fa['model'],qs['fields'](_0x3bf50f[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x410c1c[_0x37f9('0x43')]=_0x410c1c[_0x37f9('0x43')][_0x37f9('0x51')]?_0x410c1c[_0x37f9('0x43')]:_0x5608fa[_0x37f9('0x41')];if(!_0x3bf50f[_0x37f9('0x3d')][_0x37f9('0x64')](_0x37f9('0x44'))){_0x410c1c[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x3bf50f[_0x37f9('0x3d')]['limit']);_0x410c1c[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x3bf50f['query']['offset']);}_0x410c1c['order']=qs['sort'](_0x3bf50f[_0x37f9('0x3d')]['sort']);_0x410c1c[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_['pick'](_0x3bf50f[_0x37f9('0x3d')],_0x5608fa[_0x37f9('0x3f')]));_0x410c1c[_0x37f9('0x48')][_0x37f9('0x65')]=_0x213c7d['id'];if(_0x3bf50f['query'][_0x37f9('0x2f')]){_0x410c1c['where']=_[_0x37f9('0x49')](_0x410c1c['where'],{'$or':_[_0x37f9('0x31')](_0x410c1c[_0x37f9('0x43')],function(_0x583859){var _0x5d58be={};_0x5d58be[_0x583859]={'$like':'%'+_0x3bf50f[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x5d58be;})});}_0x410c1c=_[_0x37f9('0x49')]({},_0x410c1c,_0x3bf50f[_0x37f9('0x4b')]);return db['CmHopperHistory'][_0x37f9('0x20')]({'where':_0x410c1c[_0x37f9('0x48')]})[_0x37f9('0x29')](function(_0x5d2d0d){_0x203bae['count']=_0x5d2d0d;if(_0x3bf50f[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0x410c1c[_0x37f9('0x5b')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x37f9('0x4d')](_0x410c1c);})[_0x37f9('0x29')](function(_0x1d93a5){_0x203bae[_0x37f9('0x66')]=_0x1d93a5;return _0x203bae;});}})[_0x37f9('0x29')](respondWithFilteredResult(_0x24c480,_0x410c1c))['catch'](handleError(_0x24c480,null));};exports['getHopperFinals']=function(_0x498ae5,_0x3876d5,_0x4d1ebc){var _0x32d20e={'raw':!![],'where':{}};var _0x1faa22={};var _0xe6e44f={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x37f9('0x62')]({'where':{'id':_0x498ae5['params']['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x3876d5,null))['then'](function(_0xad9933){if(_0xad9933){_0x1faa22[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x68')][_0x37f9('0x50')]);_0x1faa22['query']=_[_0x37f9('0x3e')](_0x498ae5['query']);_0x1faa22[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x1faa22[_0x37f9('0x41')],_0x1faa22['query']);_0x32d20e[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x1faa22[_0x37f9('0x41')],qs['fields'](_0x498ae5['query']['fields']));_0x32d20e[_0x37f9('0x43')]=_0x32d20e['attributes']['length']?_0x32d20e['attributes']:_0x1faa22['model'];if(!_0x498ae5['query'][_0x37f9('0x64')](_0x37f9('0x44'))){_0x32d20e[_0x37f9('0x22')]=qs['limit'](_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x32d20e[_0x37f9('0x21')]=qs['offset'](_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x21')]);}_0x32d20e[_0x37f9('0x45')]=qs[_0x37f9('0x46')](_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x32d20e[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_['pick'](_0x498ae5[_0x37f9('0x3d')],_0x1faa22['filters']));_0x32d20e[_0x37f9('0x48')][_0x37f9('0x65')]=_0xad9933['id'];if(_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x2f')]){_0x32d20e[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x32d20e[_0x37f9('0x48')],{'$or':_[_0x37f9('0x31')](_0x32d20e[_0x37f9('0x43')],function(_0x5ce60d){var _0x1220ea={};_0x1220ea[_0x5ce60d]={'$like':'%'+_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x1220ea;})});}_0x32d20e=_[_0x37f9('0x49')]({},_0x32d20e,_0x498ae5[_0x37f9('0x4b')]);return db['CmHopperFinal']['count']({'where':_0x32d20e[_0x37f9('0x48')]})['then'](function(_0x8b2b01){_0xe6e44f[_0x37f9('0x20')]=_0x8b2b01;if(_0x498ae5['query']['includeAll']){_0x32d20e[_0x37f9('0x5b')]=[{'all':!![]}];}return db[_0x37f9('0x68')][_0x37f9('0x4d')](_0x32d20e);})[_0x37f9('0x29')](function(_0x28e457){_0xe6e44f[_0x37f9('0x66')]=_0x28e457;return _0xe6e44f;});}})[_0x37f9('0x29')](respondWithFilteredResult(_0x3876d5,_0x32d20e))[_0x37f9('0x4e')](handleError(_0x3876d5,null));};exports['getHopperBlacks']=function(_0x1e3017,_0x301aee,_0x46a493){var _0x1f906d={'raw':!![],'where':{}};var _0x774f69={};var _0x3618ad={'count':0x0,'rows':[]};return db[_0x37f9('0x3a')][_0x37f9('0x62')]({'where':{'id':_0x1e3017[_0x37f9('0x4f')]['id']}})['then'](handleEntityNotFound(_0x301aee,null))[_0x37f9('0x29')](function(_0x3a3205){if(_0x3a3205){_0x774f69[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db['CmHopperBlack'][_0x37f9('0x50')]);_0x774f69[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x1e3017[_0x37f9('0x3d')]);_0x774f69[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x774f69['model'],_0x774f69['query']);_0x1f906d[_0x37f9('0x43')]=_['intersection'](_0x774f69[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x1e3017[_0x37f9('0x3d')]['fields']));_0x1f906d[_0x37f9('0x43')]=_0x1f906d['attributes'][_0x37f9('0x51')]?_0x1f906d[_0x37f9('0x43')]:_0x774f69['model'];if(!_0x1e3017[_0x37f9('0x3d')][_0x37f9('0x64')](_0x37f9('0x44'))){_0x1f906d['limit']=qs[_0x37f9('0x22')](_0x1e3017[_0x37f9('0x3d')]['limit']);_0x1f906d[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x1e3017[_0x37f9('0x3d')][_0x37f9('0x21')]);}_0x1f906d[_0x37f9('0x45')]=qs[_0x37f9('0x46')](_0x1e3017[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x1f906d[_0x37f9('0x48')]=qs['filters'](_[_0x37f9('0x47')](_0x1e3017['query'],_0x774f69[_0x37f9('0x3f')]));_0x1f906d[_0x37f9('0x48')][_0x37f9('0x65')]=_0x3a3205['id'];if(_0x1e3017[_0x37f9('0x3d')][_0x37f9('0x2f')]){_0x1f906d[_0x37f9('0x48')]=_['merge'](_0x1f906d['where'],{'$or':_[_0x37f9('0x31')](_0x1f906d[_0x37f9('0x43')],function(_0x548854){var _0x5c7497={};_0x5c7497[_0x548854]={'$like':'%'+_0x1e3017[_0x37f9('0x3d')]['filter']+'%'};return _0x5c7497;})});}_0x1f906d=_['merge']({},_0x1f906d,_0x1e3017[_0x37f9('0x4b')]);return db[_0x37f9('0x69')][_0x37f9('0x20')]({'where':_0x1f906d['where']})['then'](function(_0x2dd59f){_0x3618ad[_0x37f9('0x20')]=_0x2dd59f;if(_0x1e3017['query'][_0x37f9('0x4c')]){_0x1f906d[_0x37f9('0x5b')]=[{'all':!![]}];}return db[_0x37f9('0x69')][_0x37f9('0x4d')](_0x1f906d);})['then'](function(_0x58b16f){_0x3618ad[_0x37f9('0x66')]=_0x58b16f;return _0x3618ad;});}})[_0x37f9('0x29')](respondWithFilteredResult(_0x301aee,_0x1f906d))[_0x37f9('0x4e')](handleError(_0x301aee,null));};exports[_0x37f9('0x6a')]=function(_0x383842,_0x49302f,_0x3482c8){var _0x41f298={};var _0x212cc9={};var _0x441e36;var _0x90667;return db['VoiceQueue'][_0x37f9('0x62')]({'where':{'id':_0x383842['params']['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x49302f,null))[_0x37f9('0x29')](function(_0x34476c){if(_0x34476c){_0x441e36=_0x34476c;_0x212cc9[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x6b')]['rawAttributes']);_0x212cc9[_0x37f9('0x3d')]=_['keys'](_0x383842[_0x37f9('0x3d')]);_0x212cc9[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x212cc9[_0x37f9('0x41')],_0x212cc9[_0x37f9('0x3d')]);_0x41f298[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x212cc9[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x383842[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x41f298['attributes']=_0x41f298[_0x37f9('0x43')][_0x37f9('0x51')]?_0x41f298[_0x37f9('0x43')]:_0x212cc9[_0x37f9('0x41')];_0x41f298[_0x37f9('0x45')]=qs['sort'](_0x383842[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x41f298[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x383842['query'],_0x212cc9[_0x37f9('0x3f')]));if(_0x383842[_0x37f9('0x3d')][_0x37f9('0x2f')]){_0x41f298[_0x37f9('0x48')]=_['merge'](_0x41f298['where'],{'$or':_[_0x37f9('0x31')](_0x41f298[_0x37f9('0x43')],function(_0x564636){var _0x452e49={};_0x452e49[_0x564636]={'$like':'%'+_0x383842[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x452e49;})});}_0x41f298=_[_0x37f9('0x49')]({},_0x41f298,_0x383842[_0x37f9('0x4b')]);return _0x441e36[_0x37f9('0x6a')](_0x41f298);}})[_0x37f9('0x29')](function(_0xa2f58f){if(_0xa2f58f){_0x90667=_0xa2f58f['length'];if(!_0x383842['query'][_0x37f9('0x64')]('nolimit')){_0x41f298[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x383842[_0x37f9('0x3d')]['limit']);_0x41f298[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x383842['query'][_0x37f9('0x21')]);}return _0x441e36[_0x37f9('0x6a')](_0x41f298);}})[_0x37f9('0x29')](function(_0x35c2e1){if(_0x35c2e1){return _0x35c2e1?{'count':_0x90667,'rows':_0x35c2e1}:null;}})[_0x37f9('0x29')](respondWithResult(_0x49302f,null))['catch'](handleError(_0x49302f,null));};exports[_0x37f9('0x6c')]=function(_0x303132,_0x1a73c3,_0xfa970b){var _0x49526d=_0x303132['body'][_0x37f9('0x6d')];var _0x4656d5=_[_0x37f9('0x31')](_0x49526d,'id');return db[_0x37f9('0x6b')][_0x37f9('0x4d')]({'where':{'id':_0x4656d5},'attributes':['id'],'include':[{'model':db[_0x37f9('0x6e')],'as':_0x37f9('0x6f'),'attributes':['id',_0x37f9('0x36'),_0x37f9('0x70'),_0x37f9('0x71'),'interface'],'raw':!![]}]})['then'](function(_0x3edcae){if(_0x3edcae){var _0x2d22c4=_[_0x37f9('0x72')](_0x3edcae,function(_0x3b4288){var _0x5470e4=_0x3b4288[_0x37f9('0x2b')]({'plain':!![]});_0x5470e4[_0x37f9('0x6f')][_0x37f9('0x73')](function(_0x42864c){_0x42864c[_0x37f9('0x74')]=_['find'](_0x49526d,{'id':_0x5470e4['id']})[_0x37f9('0x74')];});return _0x5470e4[_0x37f9('0x6f')];});return db['VoiceQueue'][_0x37f9('0x34')]({'where':{'id':_0x303132[_0x37f9('0x4f')]['id']}})['then'](function(_0x414da9){return db[_0x37f9('0x75')][_0x37f9('0x76')](function(_0x2cf138){return _0x414da9[_0x37f9('0x6c')](_0x4656d5,{'transaction':_0x2cf138})['then'](function(){return BPromise['each'](_0x2d22c4,function(_0x1cc003){return db['UserVoiceQueue'][_0x37f9('0x77')]({'where':{'UserId':_0x1cc003['id'],'VoiceQueueId':_0x303132[_0x37f9('0x4f')]['id']},'defaults':{'penalty':_0x1cc003[_0x37f9('0x74')]},'transaction':_0x2cf138});});})[_0x37f9('0x29')](function(){return BPromise['each'](_[_0x37f9('0x2f')](_0x2d22c4,{'online':!![]}),function(_0x34ae23){return db[_0x37f9('0x78')][_0x37f9('0x79')]({'membername':_0x34ae23[_0x37f9('0x36')],'UserId':_0x34ae23['id'],'queue_name':_0x414da9['name'],'VoiceQueueId':_0x414da9['id'],'interface':_[_0x37f9('0x7a')](_0x34ae23[_0x37f9('0x7b')])?util[_0x37f9('0x7c')](_0x37f9('0x7d'),_0x34ae23[_0x37f9('0x36')]):_0x34ae23[_0x37f9('0x7b')],'paused':_0x34ae23[_0x37f9('0x71')]||![],'penalty':_0x34ae23['penalty']},{'transaction':_0x2cf138});});})[_0x37f9('0x29')](function(){_0x2d22c4[_0x37f9('0x73')](function(_0x295f58){socket['emit']('userVoiceQueue:save',{'UserId':_0x295f58['id'],'VoiceQueueId':_0x414da9['id']});});});});});}})[_0x37f9('0x29')](respondWithStatusCode(_0x1a73c3,null))[_0x37f9('0x4e')](handleError(_0x1a73c3,null));};exports[_0x37f9('0x7e')]=function(_0x51eaaf,_0x9a1782,_0x2b9b44){return db[_0x37f9('0x6b')][_0x37f9('0x4d')]({'where':{'id':_0x51eaaf['query']['ids']},'attributes':['id'],'include':[{'model':db[_0x37f9('0x6e')],'as':_0x37f9('0x6f'),'attributes':['id'],'raw':!![]}]})[_0x37f9('0x29')](handleEntityNotFound(_0x9a1782,null))[_0x37f9('0x29')](function(_0x4d3c72){var _0x43731d=_[_0x37f9('0x31')](_0x4d3c72,'id');var _0x3bc466=[];var _0x22aa1d=[];var _0x2c4455=squel[_0x37f9('0x7f')]();_0x2c4455[_0x37f9('0x80')](_0x37f9('0x81'))[_0x37f9('0x82')](_0x37f9('0x83'),'tq')[_0x37f9('0x84')]('user_has_teams','ut',_0x37f9('0x85'))[_0x37f9('0x48')](_0x37f9('0x86'),_0x51eaaf[_0x37f9('0x4f')]['id']);for(var _0x288e11=0x0;_0x288e11<_0x4d3c72['length'];_0x288e11+=0x1){let _0x3419c0=_0x4d3c72[_0x288e11];for(var _0x5b701a=0x0;_0x5b701a<_0x3419c0[_0x37f9('0x6f')][_0x37f9('0x51')];_0x5b701a+=0x1){let _0x1e49d6=_0x3419c0[_0x37f9('0x6f')][_0x5b701a];var _0x2be08d=_0x2c4455[_0x37f9('0x87')]();_0x2be08d[_0x37f9('0x48')](_0x37f9('0x88'),_0x1e49d6['id']);_0x22aa1d[_0x37f9('0x89')](db[_0x37f9('0x75')][_0x37f9('0x3d')](_0x2be08d[_0x37f9('0x8a')](),{'type':db[_0x37f9('0x75')]['QueryTypes'][_0x37f9('0x8b')]})['then'](function(_0x59e479){if(_0x59e479[_0x37f9('0x51')]===0x1){return _0x1e49d6['id'];}else{var _0x119316=_[_0x37f9('0x8c')](_['map'](_0x59e479,_0x37f9('0x8d')),function(_0x242100){return _[_0x37f9('0x33')](_0x43731d,_0x242100);});if(_0x119316){return _0x1e49d6['id'];}}}));}}return BPromise[_0x37f9('0x8e')](_0x22aa1d)['then'](function(_0x218c8a){_0x3bc466=_(_0x3bc466)[_0x37f9('0x8f')](_0x218c8a)[_0x37f9('0x90')]()['value']();return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0x51eaaf[_0x37f9('0x4f')]['id']}})['then'](function(_0xfe96ff){return db[_0x37f9('0x75')][_0x37f9('0x76')](function(_0x3fff27){return _0xfe96ff['removeTeams'](_0x51eaaf[_0x37f9('0x3d')]['ids'],{'transaction':_0x3fff27})[_0x37f9('0x29')](function(){if(!_['isEmpty'](_0x3bc466)){return _0xfe96ff['removeAgents'](_0x3bc466,{'transaction':_0x3fff27})[_0x37f9('0x29')](function(){return db[_0x37f9('0x78')]['destroy']({'where':{'VoiceQueueId':_0x51eaaf['params']['id'],'UserId':_0x3bc466},'transaction':_0x3fff27});});}})['then'](function(){_0x3bc466[_0x37f9('0x73')](function(_0x37148c){socket[_0x37f9('0x91')]('userVoiceQueue:remove',{'UserId':_0x37148c,'VoiceQueueId':_0xfe96ff['id']});});});});});});})['then'](respondWithStatusCode(_0x9a1782,null))['catch'](handleError(_0x9a1782,null));};exports[_0x37f9('0x92')]=function(_0x5beebc,_0x18f9ff,_0x1d4174){var _0x155c7a,_0x1d3cec;return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0x5beebc[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x18f9ff,null))['then'](function(_0x197f81){if(_0x197f81){_0x1d3cec=_0x197f81;return _0x197f81[_0x37f9('0x92')](_0x5beebc[_0x37f9('0x53')]['ids'],_[_0x37f9('0x5c')](_0x5beebc[_0x37f9('0x53')],[_0x37f9('0x93'),'id'])||{})[_0x37f9('0x94')](function(_0x2eb86c){for(var _0x30e24e=0x0;_0x30e24e<_0x5beebc[_0x37f9('0x53')][_0x37f9('0x93')][_0x37f9('0x51')];_0x30e24e+=0x1){socket['emit'](_0x37f9('0x95'),{'UserId':_0x5beebc[_0x37f9('0x53')]['ids'][_0x30e24e],'VoiceQueueId':_0x5beebc[_0x37f9('0x4f')]['id']});}return _0x2eb86c;});}})[_0x37f9('0x29')](function(_0x434f59){_0x155c7a=_0x434f59||[];if(_0x1d3cec){return db[_0x37f9('0x6e')][_0x37f9('0x4d')]({'where':{'id':_0x5beebc[_0x37f9('0x53')][_0x37f9('0x93')]},'attributes':['id',_0x37f9('0x36'),_0x37f9('0x70'),_0x37f9('0x71'),'interface'],'raw':!![]});}})[_0x37f9('0x29')](function(_0x42ccd2){if(!_[_0x37f9('0x96')](_0x42ccd2)){var _0x53cc59=[];for(var _0x46429f=0x0;_0x46429f<_0x42ccd2[_0x37f9('0x51')];_0x46429f++){if(_0x42ccd2[_0x46429f][_0x37f9('0x70')]){_0x53cc59[_0x37f9('0x89')](db['UserVoiceQueueRt'][_0x37f9('0x79')]({'membername':_0x42ccd2[_0x46429f]['name'],'UserId':_0x42ccd2[_0x46429f]['id'],'queue_name':_0x1d3cec[_0x37f9('0x36')],'VoiceQueueId':_0x1d3cec['id'],'interface':_['isNil'](_0x42ccd2[_0x46429f][_0x37f9('0x7b')])?util['format'](_0x37f9('0x7d'),_0x42ccd2[_0x46429f][_0x37f9('0x36')]):_0x42ccd2[_0x46429f][_0x37f9('0x7b')],'paused':_0x42ccd2[_0x46429f]['voicePause']||![],'penalty':_0x5beebc[_0x37f9('0x53')][_0x37f9('0x74')]||0x0}));}}return BPromise[_0x37f9('0x8e')](_0x53cc59);}})['then'](function(){return _0x155c7a;})[_0x37f9('0x29')](respondWithResult(_0x18f9ff,null))[_0x37f9('0x4e')](handleError(_0x18f9ff,null));};exports[_0x37f9('0x97')]=function(_0x5f4574,_0x1a95be,_0x2785a9){return db['VoiceQueue'][_0x37f9('0x34')]({'where':{'id':_0x5f4574[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x1a95be,null))[_0x37f9('0x29')](function(_0x6ca85){if(_0x6ca85){return _0x6ca85[_0x37f9('0x97')](_0x5f4574[_0x37f9('0x3d')][_0x37f9('0x93')])['then'](function(){if(_[_0x37f9('0x98')](_0x5f4574['query'][_0x37f9('0x93')])){for(var _0x4b3d1b=0x0;_0x4b3d1b<_0x5f4574[_0x37f9('0x3d')][_0x37f9('0x93')][_0x37f9('0x51')];_0x4b3d1b+=0x1){socket[_0x37f9('0x91')]('userVoiceQueue:remove',{'UserId':Number(_0x5f4574[_0x37f9('0x3d')][_0x37f9('0x93')][_0x4b3d1b]),'VoiceQueueId':Number(_0x5f4574['params']['id'])});}}else{socket[_0x37f9('0x91')](_0x37f9('0x99'),{'UserId':Number(_0x5f4574[_0x37f9('0x3d')][_0x37f9('0x93')]),'VoiceQueueId':Number(_0x5f4574[_0x37f9('0x4f')]['id'])});}});}})['then'](function(_0x37f2fe){return db[_0x37f9('0x78')]['destroy']({'where':{'VoiceQueueId':_0x5f4574[_0x37f9('0x4f')]['id'],'UserId':_0x5f4574[_0x37f9('0x3d')]['ids']}})[_0x37f9('0x29')](function(){return _0x37f2fe;});})[_0x37f9('0x29')](respondWithStatusCode(_0x1a95be,null))['catch'](handleError(_0x1a95be,null));};exports[_0x37f9('0x9a')]=function(_0xbaed9c,_0x28d8a3,_0x57198f){var _0x279bc2={};var _0x3fe434={};var _0x2be9bd;var _0x30d52b;return db[_0x37f9('0x3a')][_0x37f9('0x62')]({'where':{'id':_0xbaed9c['params']['id']}})['then'](handleEntityNotFound(_0x28d8a3,null))['then'](function(_0x27b203){if(_0x27b203){_0x2be9bd=_0x27b203;_0x3fe434[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x6e')][_0x37f9('0x50')]);_0x3fe434['query']=_['keys'](_0xbaed9c[_0x37f9('0x3d')]);_0x3fe434[_0x37f9('0x3f')]=_['intersection'](_0x3fe434[_0x37f9('0x41')],_0x3fe434[_0x37f9('0x3d')]);_0x279bc2[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x3fe434[_0x37f9('0x41')],qs['fields'](_0xbaed9c['query'][_0x37f9('0x42')]));_0x279bc2[_0x37f9('0x43')]=_0x279bc2[_0x37f9('0x43')]['length']?_0x279bc2[_0x37f9('0x43')]:_0x3fe434['model'];_0x279bc2[_0x37f9('0x45')]=qs['sort'](_0xbaed9c[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x279bc2[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_['pick'](_0xbaed9c['query'],_0x3fe434[_0x37f9('0x3f')]));if(_0xbaed9c[_0x37f9('0x3d')]['filter']){_0x279bc2['where']=_[_0x37f9('0x49')](_0x279bc2[_0x37f9('0x48')],{'$or':_['map'](_0x279bc2[_0x37f9('0x43')],function(_0x1afd11){var _0x346bf0={};_0x346bf0[_0x1afd11]={'$like':'%'+_0xbaed9c[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x346bf0;})});}_0x279bc2=_[_0x37f9('0x49')]({},_0x279bc2,_0xbaed9c[_0x37f9('0x4b')]);return _0x2be9bd[_0x37f9('0x9a')](_0x279bc2);}})[_0x37f9('0x29')](function(_0x43bf3c){if(_0x43bf3c){_0x30d52b=_0x43bf3c['length'];if(!_0xbaed9c[_0x37f9('0x3d')][_0x37f9('0x64')](_0x37f9('0x44'))){_0x279bc2[_0x37f9('0x22')]=qs['limit'](_0xbaed9c[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x279bc2[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0xbaed9c['query']['offset']);}return _0x2be9bd[_0x37f9('0x9a')](_0x279bc2);}})[_0x37f9('0x29')](function(_0x5ef570){if(_0x5ef570){return _0x5ef570?{'count':_0x30d52b,'rows':_0x5ef570}:null;}})[_0x37f9('0x29')](respondWithResult(_0x28d8a3,null))['catch'](handleError(_0x28d8a3,null));};exports[_0x37f9('0x9b')]=function(_0x310612,_0x34ff42,_0x4e7e2a){var _0x26796f={};var _0x496c8c={};var _0x52f92d;var _0x267563;return db[_0x37f9('0x3a')]['findOne']({'where':{'id':_0x310612['params']['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x34ff42,null))[_0x37f9('0x29')](function(_0x406123){if(_0x406123){_0x52f92d=_0x406123;_0x496c8c[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x78')][_0x37f9('0x50')]);_0x496c8c[_0x37f9('0x3d')]=_['keys'](_0x310612[_0x37f9('0x3d')]);_0x496c8c[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x496c8c[_0x37f9('0x41')],_0x496c8c[_0x37f9('0x3d')]);_0x26796f['attributes']=_['intersection'](_0x496c8c[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x310612['query'][_0x37f9('0x42')]));_0x26796f[_0x37f9('0x43')]=_0x26796f[_0x37f9('0x43')][_0x37f9('0x51')]?_0x26796f[_0x37f9('0x43')]:_0x496c8c[_0x37f9('0x41')];_0x26796f[_0x37f9('0x45')]=qs[_0x37f9('0x46')](_0x310612[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x26796f[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x310612[_0x37f9('0x3d')],_0x496c8c[_0x37f9('0x3f')]));if(_0x310612[_0x37f9('0x3d')]['filter']){_0x26796f[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x26796f['where'],{'$or':_['map'](_0x26796f[_0x37f9('0x43')],function(_0x134c4e){var _0x5ebead={};_0x5ebead[_0x134c4e]={'$like':'%'+_0x310612[_0x37f9('0x3d')]['filter']+'%'};return _0x5ebead;})});}_0x26796f=_['merge']({},_0x26796f,_0x310612[_0x37f9('0x4b')]);return _0x52f92d[_0x37f9('0x9b')](_0x26796f);}})[_0x37f9('0x29')](function(_0x16b328){if(_0x16b328){_0x267563=_0x16b328[_0x37f9('0x51')];if(!_0x310612[_0x37f9('0x3d')]['hasOwnProperty']('nolimit')){_0x26796f[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x310612['query'][_0x37f9('0x22')]);_0x26796f[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x310612[_0x37f9('0x3d')]['offset']);}return _0x52f92d[_0x37f9('0x9b')](_0x26796f);}})[_0x37f9('0x29')](function(_0x26b7c6){return _0x26b7c6?{'count':_0x267563,'rows':_0x26b7c6}:null;})[_0x37f9('0x29')](respondWithResult(_0x34ff42,null))['catch'](handleError(_0x34ff42,null));};exports[_0x37f9('0x9c')]=function(_0x5af22d,_0xf572a2,_0x25e2d2){var _0x58a325={};var _0x71ad9a={};var _0x10d9f8;var _0xd59dd;return db['VoiceQueue']['findOne']({'where':{'id':_0x5af22d['params']['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0xf572a2,null))[_0x37f9('0x29')](function(_0x1c6f14){if(_0x1c6f14){_0x10d9f8=_0x1c6f14;_0x71ad9a[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x9d')][_0x37f9('0x50')]);_0x71ad9a[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x5af22d['query']);_0x71ad9a[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x71ad9a[_0x37f9('0x41')],_0x71ad9a[_0x37f9('0x3d')]);_0x58a325['attributes']=_[_0x37f9('0x40')](_0x71ad9a[_0x37f9('0x41')],qs['fields'](_0x5af22d[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x58a325[_0x37f9('0x43')]=_0x58a325['attributes'][_0x37f9('0x51')]?_0x58a325[_0x37f9('0x43')]:_0x71ad9a[_0x37f9('0x41')];_0x58a325[_0x37f9('0x45')]=qs['sort'](_0x5af22d[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x58a325[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x5af22d[_0x37f9('0x3d')],_0x71ad9a[_0x37f9('0x3f')]));if(_0x5af22d['query'][_0x37f9('0x2f')]){_0x58a325[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x58a325[_0x37f9('0x48')],{'$or':_['map'](_0x58a325[_0x37f9('0x43')],function(_0x58f736){var _0x3f5bac={};_0x3f5bac[_0x58f736]={'$like':'%'+_0x5af22d[_0x37f9('0x3d')]['filter']+'%'};return _0x3f5bac;})});}_0x58a325=_['merge']({},_0x58a325,_0x5af22d['options']);return _0x10d9f8[_0x37f9('0x9c')](_0x58a325);}})['then'](function(_0x5a0869){if(_0x5a0869){_0xd59dd=_0x5a0869[_0x37f9('0x51')];if(!_0x5af22d['query'][_0x37f9('0x64')]('nolimit')){_0x58a325[_0x37f9('0x22')]=qs['limit'](_0x5af22d[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x58a325[_0x37f9('0x21')]=qs['offset'](_0x5af22d['query'][_0x37f9('0x21')]);}return _0x10d9f8[_0x37f9('0x9c')](_0x58a325);}})[_0x37f9('0x29')](function(_0x2b2f75){if(_0x2b2f75){return _0x2b2f75?{'count':_0xd59dd,'rows':_0x2b2f75}:null;}})[_0x37f9('0x29')](respondWithResult(_0xf572a2,null))[_0x37f9('0x4e')](handleError(_0xf572a2,null));};exports['addLists']=function(_0x8aa215,_0x2e883a,_0x136302){var _0x23fd78,_0x11a959;return db[_0x37f9('0x3a')]['find']({'where':{'id':_0x8aa215[_0x37f9('0x4f')]['id']}})['then'](handleEntityNotFound(_0x2e883a,null))[_0x37f9('0x29')](function(_0x2f400c){if(_0x2f400c){_0x11a959=_0x2f400c;return _0x2f400c[_0x37f9('0x9e')](_0x8aa215[_0x37f9('0x53')][_0x37f9('0x93')],_['omit'](_0x8aa215[_0x37f9('0x53')],[_0x37f9('0x93'),'id'])||{});}return null;})[_0x37f9('0x94')](function(_0x3e1ff0){var _0x23ec78;_0x23fd78=_0x3e1ff0||[];var _0x1e2ae0=[];if(_0x3e1ff0){for(var _0x3286d1=0x0;_0x3286d1<_0x3e1ff0[_0x37f9('0x51')];_0x3286d1+=0x1){var _0x5b6168=_0x3e1ff0[_0x3286d1][_0x37f9('0x2b')]({'plain':!![]});_0x11a959[_0x37f9('0x9f')]=_0x8aa215['body'][_0x37f9('0x9f')]?_0x8aa215[_0x37f9('0x53')]['dialCheckDuplicateType']:_0x11a959[_0x37f9('0x9f')];switch(_0x11a959[_0x37f9('0x9f')]){case _0x37f9('0xa0'):_0x23ec78=squel[_0x37f9('0xa1')]()['into'](_0x37f9('0xa2'))[_0x37f9('0xa3')]([_0x37f9('0xa4'),'scheduledAt','ContactId',_0x37f9('0xa5'),_0x37f9('0x65'),_0x37f9('0x5d'),_0x37f9('0x5e')],squel[_0x37f9('0x7f')]()[_0x37f9('0x80')](_0x37f9('0xa4'),_0x37f9('0xa4'))[_0x37f9('0x80')](_0x37f9('0xa6'),'scheduledAt')[_0x37f9('0x80')]('id',_0x37f9('0xa7'))[_0x37f9('0x80')](_0x5b6168[_0x37f9('0xa8')]['toString'](),_0x37f9('0xa5'))[_0x37f9('0x80')](_0x8aa215['params']['id'][_0x37f9('0x8a')](),_0x37f9('0x65'))['field'](_0x37f9('0xa6'),'createdAt')['field']('NOW()','updatedAt')[_0x37f9('0x82')](_0x37f9('0xa9'))['where'](_0x37f9('0xaa'))[_0x37f9('0x48')]('ListId\x20=\x20?',_0x5b6168['CmListId'][_0x37f9('0x8a')]())[_0x37f9('0x48')](_0x37f9('0xab'))['where'](_0x37f9('0xac'),squel[_0x37f9('0x7f')]()['field']('COALESCE(calleridnum,\x27\x27)')[_0x37f9('0x82')](_0x37f9('0xad'))[_0x37f9('0x48')](_0x37f9('0x86'),_0x8aa215[_0x37f9('0x4f')]['id'][_0x37f9('0x8a')]()))[_0x37f9('0x48')](_0x37f9('0xac'),squel[_0x37f9('0x7f')]()['field'](_0x37f9('0xae'))[_0x37f9('0x82')](_0x37f9('0xa2'))['where'](_0x37f9('0x86'),_0x8aa215[_0x37f9('0x4f')]['id']['toString']())))[_0x37f9('0x8a')]();break;case _0x37f9('0xaf'):_0x23ec78=squel['insert']()[_0x37f9('0xb0')](_0x37f9('0xa2'))[_0x37f9('0xa3')]([_0x37f9('0xa4'),_0x37f9('0xb1'),_0x37f9('0xa7'),_0x37f9('0xa5'),'VoiceQueueId',_0x37f9('0x5d'),'updatedAt'],squel['select']()['field'](_0x37f9('0xa4'),_0x37f9('0xa4'))[_0x37f9('0x80')](_0x37f9('0xa6'),'scheduledAt')[_0x37f9('0x80')]('id',_0x37f9('0xa7'))[_0x37f9('0x80')](_0x5b6168[_0x37f9('0xa8')]['toString'](),'ListId')['field'](_0x8aa215[_0x37f9('0x4f')]['id'][_0x37f9('0x8a')](),'VoiceQueueId')[_0x37f9('0x80')](_0x37f9('0xa6'),_0x37f9('0x5d'))[_0x37f9('0x80')](_0x37f9('0xa6'),_0x37f9('0x5e'))[_0x37f9('0x82')](_0x37f9('0xa9'))['where'](_0x37f9('0xaa'))['where'](_0x37f9('0xb2'),_0x5b6168[_0x37f9('0xa8')][_0x37f9('0x8a')]())[_0x37f9('0x48')](_0x37f9('0xab'))[_0x37f9('0x48')]('phone\x20NOT\x20IN\x20(?)',squel[_0x37f9('0x7f')]()[_0x37f9('0x80')](_0x37f9('0xae'))[_0x37f9('0x82')](_0x37f9('0xa2'))[_0x37f9('0x48')](_0x37f9('0x86'),_0x8aa215['params']['id'][_0x37f9('0x8a')]())))[_0x37f9('0x8a')]();break;default:_0x23ec78=squel[_0x37f9('0xa1')]()[_0x37f9('0xb0')](_0x37f9('0xa2'))[_0x37f9('0xa3')]([_0x37f9('0xa4'),_0x37f9('0xb1'),_0x37f9('0xa7'),_0x37f9('0xa5'),_0x37f9('0x65'),_0x37f9('0x5d'),_0x37f9('0x5e')],squel[_0x37f9('0x7f')]()[_0x37f9('0x80')]('phone','phone')[_0x37f9('0x80')](_0x37f9('0xa6'),'scheduledAt')[_0x37f9('0x80')]('id',_0x37f9('0xa7'))[_0x37f9('0x80')](_0x5b6168['CmListId'][_0x37f9('0x8a')](),'ListId')[_0x37f9('0x80')](_0x8aa215['params']['id'][_0x37f9('0x8a')](),_0x37f9('0x65'))['field'](_0x37f9('0xa6'),_0x37f9('0x5d'))['field'](_0x37f9('0xa6'),'updatedAt')['from'](_0x37f9('0xa9'))[_0x37f9('0x48')](_0x37f9('0xaa'))[_0x37f9('0x48')](_0x37f9('0xb2'),_0x5b6168[_0x37f9('0xa8')]['toString']())[_0x37f9('0x48')](_0x37f9('0xab')))['toString']();}_0x1e2ae0[_0x37f9('0x89')](db[_0x37f9('0x75')]['query'](_0x23ec78));}return BPromise[_0x37f9('0x8e')](_0x1e2ae0);}})[_0x37f9('0x29')](function(){return _0x23fd78;})[_0x37f9('0x29')](respondWithResult(_0x2e883a,null))[_0x37f9('0x4e')](handleError(_0x2e883a,null));};exports[_0x37f9('0xb3')]=function(_0x50addd,_0x19b3e2,_0x31678a){return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0x50addd['params']['id']}})['then'](handleEntityNotFound(_0x19b3e2,null))['then'](function(_0xf1b1f7){if(_0xf1b1f7){return _0xf1b1f7[_0x37f9('0xb3')](_0x50addd['query'][_0x37f9('0x93')]);}})['then'](function(_0x10a923){if(_0x10a923){return db[_0x37f9('0x63')][_0x37f9('0x2a')]({'where':{'ListId':_0x50addd[_0x37f9('0x3d')]['ids'],'VoiceQueueId':_0x50addd[_0x37f9('0x4f')]['id']}})['then'](function(){return _0x10a923;});}})['then'](respondWithStatusCode(_0x19b3e2,null))[_0x37f9('0x4e')](handleError(_0x19b3e2,null));};exports[_0x37f9('0xb4')]=function(_0x2e6303,_0x4971c9,_0x5b5731){var _0x14fce4={};var _0x309c8a={};var _0x594fe9;var _0x3eccfc;return db['VoiceQueue'][_0x37f9('0x62')]({'where':{'id':_0x2e6303['params']['id']}})['then'](handleEntityNotFound(_0x4971c9,null))[_0x37f9('0x29')](function(_0x417c02){if(_0x417c02){_0x594fe9=_0x417c02;_0x309c8a[_0x37f9('0x41')]=_['keys'](db[_0x37f9('0x9d')][_0x37f9('0x50')]);_0x309c8a[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x2e6303[_0x37f9('0x3d')]);_0x309c8a[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x309c8a[_0x37f9('0x41')],_0x309c8a[_0x37f9('0x3d')]);_0x14fce4[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x309c8a['model'],qs['fields'](_0x2e6303[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x14fce4[_0x37f9('0x43')]=_0x14fce4[_0x37f9('0x43')][_0x37f9('0x51')]?_0x14fce4['attributes']:_0x309c8a['model'];_0x14fce4[_0x37f9('0x45')]=qs[_0x37f9('0x46')](_0x2e6303[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x14fce4[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x2e6303[_0x37f9('0x3d')],_0x309c8a['filters']));if(_0x2e6303['query'][_0x37f9('0x2f')]){_0x14fce4[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x14fce4['where'],{'$or':_[_0x37f9('0x31')](_0x14fce4[_0x37f9('0x43')],function(_0x49e401){var _0x19260c={};_0x19260c[_0x49e401]={'$like':'%'+_0x2e6303[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x19260c;})});}_0x14fce4=_[_0x37f9('0x49')]({},_0x14fce4,_0x2e6303[_0x37f9('0x4b')]);return _0x594fe9[_0x37f9('0xb4')](_0x14fce4);}})[_0x37f9('0x29')](function(_0xc0d60){if(_0xc0d60){_0x3eccfc=_0xc0d60['length'];if(!_0x2e6303[_0x37f9('0x3d')]['hasOwnProperty'](_0x37f9('0x44'))){_0x14fce4[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x2e6303[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x14fce4[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x2e6303[_0x37f9('0x3d')]['offset']);}return _0x594fe9[_0x37f9('0xb4')](_0x14fce4);}})[_0x37f9('0x29')](function(_0x2a8e9c){if(_0x2a8e9c){return _0x2a8e9c?{'count':_0x3eccfc,'rows':_0x2a8e9c}:null;}})[_0x37f9('0x29')](respondWithResult(_0x4971c9,null))['catch'](handleError(_0x4971c9,null));};exports[_0x37f9('0xb5')]=function(_0xf9247e,_0x219656,_0x5ee649){var _0x5e0b33,_0x381b00;return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0xf9247e[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x219656,null))[_0x37f9('0x29')](function(_0x126163){if(_0x126163){_0x381b00=_0x126163;return _0x126163[_0x37f9('0xb5')](_0xf9247e[_0x37f9('0x53')][_0x37f9('0x93')],_[_0x37f9('0x5c')](_0xf9247e['body'],['ids','id'])||{});}return null;})['spread'](function(_0x6e3bc5){var _0x343ed4;_0x5e0b33=_0x6e3bc5||[];var _0x29971a=[];if(_0x6e3bc5){for(var _0x47805a=0x0;_0x47805a<_0x6e3bc5[_0x37f9('0x51')];_0x47805a+=0x1){var _0x1a2857=_0x6e3bc5[_0x47805a][_0x37f9('0x2b')]({'plain':!![]});_0x343ed4=squel['insert']()['into'](_0x37f9('0xb6'))[_0x37f9('0xa3')]([_0x37f9('0xa4'),_0x37f9('0xa7'),_0x37f9('0xa5'),_0x37f9('0x65'),'createdAt',_0x37f9('0x5e')],squel[_0x37f9('0x7f')]()[_0x37f9('0x80')](_0x37f9('0xa4'),_0x37f9('0xa4'))['field']('id','ContactId')[_0x37f9('0x80')](_0x1a2857[_0x37f9('0xa8')][_0x37f9('0x8a')](),_0x37f9('0xa5'))[_0x37f9('0x80')](_0xf9247e[_0x37f9('0x4f')]['id'][_0x37f9('0x8a')](),_0x37f9('0x65'))[_0x37f9('0x80')](_0x37f9('0xa6'),_0x37f9('0x5d'))['field']('NOW()',_0x37f9('0x5e'))[_0x37f9('0x82')](_0x37f9('0xa9'))['where'](_0x37f9('0xaa'))[_0x37f9('0x48')](_0x37f9('0xb2'),_0x1a2857[_0x37f9('0xa8')][_0x37f9('0x8a')]())[_0x37f9('0x48')](_0x37f9('0xab')))[_0x37f9('0x8a')]();_0x29971a[_0x37f9('0x89')](db[_0x37f9('0x75')][_0x37f9('0x3d')](_0x343ed4));}return BPromise['all'](_0x29971a);}})[_0x37f9('0x29')](function(){return _0x5e0b33;})[_0x37f9('0x29')](respondWithResult(_0x219656,null))[_0x37f9('0x4e')](handleError(_0x219656,null));};exports[_0x37f9('0xb7')]=function(_0x3b8753,_0x157572,_0x2b8e0c){return db[_0x37f9('0x3a')]['find']({'where':{'id':_0x3b8753[_0x37f9('0x4f')]['id']}})['then'](handleEntityNotFound(_0x157572,null))[_0x37f9('0x29')](function(_0x3e2df1){if(_0x3e2df1){return _0x3e2df1['removeBlackLists'](_0x3b8753[_0x37f9('0x3d')][_0x37f9('0x93')]);}})[_0x37f9('0x29')](function(_0x493e4b){if(_0x493e4b){return db[_0x37f9('0x69')][_0x37f9('0x2a')]({'where':{'ListId':_0x3b8753['query'][_0x37f9('0x93')],'VoiceQueueId':_0x3b8753[_0x37f9('0x4f')]['id']}})['then'](function(){return _0x493e4b;});}})['then'](respondWithStatusCode(_0x157572,null))['catch'](handleError(_0x157572,null));};
\ No newline at end of file
+var _0x6aa7=['ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','deletedAt\x20IS\x20NULL','cm_hopper_additional_phones','CmHopperId','OrderBy','ci.item','ci.OrderBy+1','cm_contact_has_items','h.ContactId=ci.CmContactId','h.scheduledat=?','ci.ItemClass=?','PHONE','getBlackLists','CmList','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','moment','util','lodash','squel','ioredis','../../config/logger','api','../../config/environment','defaults','localhost','socket.io-emitter','redis','register','sendStatus','status','end','json','undefined','limit','count','offset','Content-Range','update','then','get','VoiceQueues','inbound','QueueCampaigns','outbound','ignore','map','value','includes','type','find','name','UserProfileResource','destroy','error','stack','index','VoiceQueue','rawAttributes','fieldName','getOptions','where','include','rows','show','model','keys','query','attributes','intersection','fields','length','includeAll','merge','options','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','omit','updatedAt','createdAt','getHoppers','findOne','filters','nolimit','order','sort','pick','VoiceQueueId','filter','CmHopper','findAll','getHopperHistories','CmHopperHistory','CmHopperFinal','hasOwnProperty','CmHopperBlack','getTeams','Team','addTeams','teams','User','online','voicePause','interface','flatMap','forEach','penalty','Agents','sequelize','transaction','each','TeamVoiceQueue','upsert','findOrCreate','UserVoiceQueueRt','isNil','format','SIP/%s','emit','userVoiceQueue:save','removeTeams','ids','field','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','SELECT','every','TeamId','compact','isEmpty','removeAgents','addAgents','spread','all','isArray','userVoiceQueue:remove','getAgents','getMembers','getLists','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','toString','cm_contacts','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','onlyIfOpen','select'];(function(_0x4baae2,_0x487ab6){var _0x1a2285=function(_0x1cea47){while(--_0x1cea47){_0x4baae2['push'](_0x4baae2['shift']());}};_0x1a2285(++_0x487ab6);}(_0x6aa7,0x178));var _0x76aa=function(_0x55579c,_0x1bc809){_0x55579c=_0x55579c-0x0;var _0x3b421a=_0x6aa7[_0x55579c];return _0x3b421a;};'use strict';var moment=require(_0x76aa('0x0'));var BPromise=require('bluebird');var util=require(_0x76aa('0x1'));var _=require(_0x76aa('0x2'));var squel=require(_0x76aa('0x3'));var Redis=require(_0x76aa('0x4'));var qs=require('../../components/parsers/qs');var logger=require(_0x76aa('0x5'))(_0x76aa('0x6'));var config=require(_0x76aa('0x7'));var db=require('../../mysqldb')['db'];config['redis']=_[_0x76aa('0x8')](config['redis'],{'host':_0x76aa('0x9'),'port':0x18eb});var socket=require(_0x76aa('0xa'))(new Redis(config[_0x76aa('0xb')]));require('./voiceQueue.socket')[_0x76aa('0xc')](socket);function respondWithStatusCode(_0x266bd5,_0x3a3f36){_0x3a3f36=_0x3a3f36||0xcc;return function(_0x557d69){if(_0x557d69){return _0x266bd5[_0x76aa('0xd')](_0x3a3f36);}return _0x266bd5[_0x76aa('0xe')](_0x3a3f36)[_0x76aa('0xf')]();};}function respondWithResult(_0x16cb50,_0x37f1ab){_0x37f1ab=_0x37f1ab||0xc8;return function(_0x128435){if(_0x128435){return _0x16cb50[_0x76aa('0xe')](_0x37f1ab)[_0x76aa('0x10')](_0x128435);}};}function respondWithFilteredResult(_0xd6327,_0x17a417){return function(_0x5e5f47){if(_0x5e5f47){var _0x112c39=typeof _0x17a417['offset']===_0x76aa('0x11')&&typeof _0x17a417[_0x76aa('0x12')]===_0x76aa('0x11');var _0x8e44ed=_0x5e5f47[_0x76aa('0x13')];var _0x4e309f=_0x112c39?0x0:_0x17a417['offset'];var _0x2b3b4f=_0x112c39?_0x5e5f47['count']:_0x17a417[_0x76aa('0x14')]+_0x17a417[_0x76aa('0x12')];var _0x5cf594;if(_0x2b3b4f>=_0x8e44ed){_0x2b3b4f=_0x8e44ed;_0x5cf594=0xc8;}else{_0x5cf594=0xce;}_0xd6327[_0x76aa('0xe')](_0x5cf594);return _0xd6327['set'](_0x76aa('0x15'),_0x4e309f+'-'+_0x2b3b4f+'/'+_0x8e44ed)['json'](_0x5e5f47);}return null;};}function saveUpdates(_0x1515e9){return function(_0x413cf6){if(_0x413cf6){return _0x413cf6[_0x76aa('0x16')](_0x1515e9)[_0x76aa('0x17')](function(_0xa1bc7){return _0xa1bc7;});}return null;};}function removeEntity(_0x3ead3f){return function(_0x496902){if(_0x496902){return _0x496902['destroy']()[_0x76aa('0x17')](function(){var _0x454dd3=_0x496902[_0x76aa('0x18')]({'plain':!![]});var _0x15b931=[{'name':_0x76aa('0x19'),'value':_0x76aa('0x1a'),'ignore':![]},{'name':_0x76aa('0x1b'),'value':_0x76aa('0x1c'),'ignore':![]}];var _0x385157=_(_0x15b931)['filter'](_0x76aa('0x1d'))[_0x76aa('0x1e')](_0x76aa('0x1f'))['value']();if(_[_0x76aa('0x20')](_0x385157,_0x454dd3[_0x76aa('0x21')])){return;}var _0x31252f=_[_0x76aa('0x22')](_0x15b931,[_0x76aa('0x1f'),_0x454dd3[_0x76aa('0x21')]])[_0x76aa('0x23')];return db[_0x76aa('0x24')][_0x76aa('0x25')]({'where':{'type':_0x31252f,'resourceId':_0x454dd3['id']}})[_0x76aa('0x17')](function(){return _0x496902;});})[_0x76aa('0x17')](function(){_0x3ead3f[_0x76aa('0xe')](0xcc)[_0x76aa('0xf')]();});}};}function handleEntityNotFound(_0x4ef9b0){return function(_0xb5e8a9){if(!_0xb5e8a9){_0x4ef9b0[_0x76aa('0xd')](0x194);}return _0xb5e8a9;};}function handleError(_0x25c614,_0x2e7ab4){_0x2e7ab4=_0x2e7ab4||0x1f4;return function(_0xa1e6){logger[_0x76aa('0x26')](_0xa1e6[_0x76aa('0x27')]);if(_0xa1e6[_0x76aa('0x23')]){delete _0xa1e6[_0x76aa('0x23')];}_0x25c614[_0x76aa('0xe')](_0x2e7ab4)['send'](_0xa1e6);};}exports[_0x76aa('0x28')]=function(_0x5a8030,_0x994550){var _0x365ff8={};var _0x2dec94={'count':0x0,'rows':[]};var _0x1e90b9=_[_0x76aa('0x1e')](db[_0x76aa('0x29')][_0x76aa('0x2a')],function(_0x3827ec){return{'name':_0x3827ec[_0x76aa('0x2b')],'type':_0x3827ec[_0x76aa('0x21')]['key']};});_0x365ff8=qs[_0x76aa('0x2c')](_0x1e90b9,_0x5a8030);var _0x5532c7={'where':_0x365ff8[_0x76aa('0x2d')]};return db[_0x76aa('0x29')][_0x76aa('0x13')](_0x5532c7)[_0x76aa('0x17')](function(_0x35a705){_0x2dec94['count']=_0x35a705;_0x365ff8[_0x76aa('0x2e')]=qs[_0x76aa('0x2e')](_0x5a8030['query']);return db[_0x76aa('0x29')]['findAll'](_0x365ff8);})[_0x76aa('0x17')](function(_0x4c90b6){_0x2dec94[_0x76aa('0x2f')]=_0x4c90b6;return _0x2dec94;})['then'](respondWithFilteredResult(_0x994550,_0x365ff8))['catch'](handleError(_0x994550,null));};exports[_0x76aa('0x30')]=function(_0x282c56,_0x198fcb){var _0x37dfab={'raw':![],'where':{'id':_0x282c56['params']['id']}},_0x595a0f={};_0x595a0f[_0x76aa('0x31')]=_[_0x76aa('0x32')](db[_0x76aa('0x29')][_0x76aa('0x2a')]);_0x595a0f[_0x76aa('0x33')]=_['keys'](_0x282c56[_0x76aa('0x33')]);_0x595a0f['filters']=_['intersection'](_0x595a0f[_0x76aa('0x31')],_0x595a0f[_0x76aa('0x33')]);_0x37dfab[_0x76aa('0x34')]=_[_0x76aa('0x35')](_0x595a0f['model'],qs[_0x76aa('0x36')](_0x282c56[_0x76aa('0x33')][_0x76aa('0x36')]));_0x37dfab['attributes']=_0x37dfab[_0x76aa('0x34')][_0x76aa('0x37')]?_0x37dfab[_0x76aa('0x34')]:_0x595a0f[_0x76aa('0x31')];if(_0x282c56[_0x76aa('0x33')][_0x76aa('0x38')]){_0x37dfab[_0x76aa('0x2e')]=[{'all':!![]}];}_0x37dfab=_[_0x76aa('0x39')]({},_0x37dfab,_0x282c56[_0x76aa('0x3a')]);return db['VoiceQueue'][_0x76aa('0x22')](_0x37dfab)[_0x76aa('0x17')](handleEntityNotFound(_0x198fcb,null))[_0x76aa('0x17')](respondWithResult(_0x198fcb,null))[_0x76aa('0x3b')](handleError(_0x198fcb,null));};exports[_0x76aa('0x3c')]=function(_0x2957aa,_0x572fdb){return db['VoiceQueue'][_0x76aa('0x3c')](_0x2957aa[_0x76aa('0x3d')],{})[_0x76aa('0x17')](function(_0x365612){var _0x50599f=_0x2957aa[_0x76aa('0x3e')][_0x76aa('0x18')]({'plain':!![]});if(!_0x50599f)throw new Error(_0x76aa('0x3f'));if(_0x50599f[_0x76aa('0x40')]===_0x76aa('0x3e')){var _0x4aa2f3=_0x365612[_0x76aa('0x18')]({'plain':!![]});var _0x556f59=[{'name':_0x76aa('0x19'),'value':'inbound'},{'name':'QueueCampaigns','value':'outbound'}];var _0x144f0a=_['find'](_0x556f59,['value',_0x4aa2f3['type']])[_0x76aa('0x23')];return db[_0x76aa('0x41')][_0x76aa('0x22')]({'where':{'name':_0x144f0a,'userProfileId':_0x50599f[_0x76aa('0x42')]},'raw':!![]})[_0x76aa('0x17')](function(_0x47b0c8){if(_0x47b0c8&&_0x47b0c8[_0x76aa('0x43')]===0x0){return db[_0x76aa('0x24')][_0x76aa('0x3c')]({'name':_0x4aa2f3[_0x76aa('0x23')],'resourceId':_0x4aa2f3['id'],'type':_0x47b0c8[_0x76aa('0x23')],'sectionId':_0x47b0c8['id']},{})['then'](function(){return _0x365612;});}else{return _0x365612;}})[_0x76aa('0x3b')](function(_0x1c62a9){logger['error'](_0x76aa('0x44'),_0x1c62a9);throw _0x1c62a9;});}return _0x365612;})['then'](respondWithResult(_0x572fdb,0xc9))[_0x76aa('0x3b')](handleError(_0x572fdb,null));};exports[_0x76aa('0x45')]=function(_0x31930b,_0x18fd3e){var _0x2d0bc4={'where':{'id':_0x31930b[_0x76aa('0x46')]['id']}},_0x3e0315={};_0x3e0315[_0x76aa('0x31')]=_[_0x76aa('0x32')](db[_0x76aa('0x29')]['rawAttributes']);_0x2d0bc4[_0x76aa('0x34')]=_['intersection'](_0x3e0315[_0x76aa('0x31')],qs[_0x76aa('0x36')](_0x31930b[_0x76aa('0x33')][_0x76aa('0x36')]));_0x2d0bc4['attributes']=_0x2d0bc4['attributes'][_0x76aa('0x37')]?_0x2d0bc4['attributes']:_0x3e0315[_0x76aa('0x31')];if(_0x31930b[_0x76aa('0x33')][_0x76aa('0x38')]){_0x2d0bc4[_0x76aa('0x2e')]=[{'all':!![]}];}_0x2d0bc4=_[_0x76aa('0x39')]({},_0x2d0bc4,_0x31930b[_0x76aa('0x3a')]);return db['VoiceQueue']['find'](_0x2d0bc4)[_0x76aa('0x17')](handleEntityNotFound(_0x18fd3e,null))[_0x76aa('0x17')](function(_0x1708d4){if(_0x1708d4){var _0x40e8ff=_0x1708d4[_0x76aa('0x18')]({'plain':!![]});_0x40e8ff=qs[_0x76aa('0x47')](_0x40e8ff,['id','createdAt',_0x76aa('0x48')]);_0x31930b[_0x76aa('0x3d')]=_[_0x76aa('0x47')](_0x31930b['body'],['id',_0x76aa('0x49'),'updatedAt']);return db[_0x76aa('0x29')]['create'](_[_0x76aa('0x39')](_0x40e8ff,_0x31930b[_0x76aa('0x3d')]),{'include':_0x31930b[_0x76aa('0x33')][_0x76aa('0x38')]?[{'all':!![]}]:undefined})[_0x76aa('0x17')](function(_0x316de3){var _0x953726=_0x31930b['user'][_0x76aa('0x18')]({'plain':!![]});if(!_0x953726)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x953726[_0x76aa('0x40')]===_0x76aa('0x3e')){var _0x288151=_0x316de3[_0x76aa('0x18')]({'plain':!![]});var _0x3fa7ec=[{'name':_0x76aa('0x19'),'value':_0x76aa('0x1a')},{'name':'QueueCampaigns','value':_0x76aa('0x1c')}];var _0x281f73=_[_0x76aa('0x22')](_0x3fa7ec,[_0x76aa('0x1f'),_0x288151['type']])[_0x76aa('0x23')];return db[_0x76aa('0x41')][_0x76aa('0x22')]({'where':{'name':_0x281f73,'userProfileId':_0x953726[_0x76aa('0x42')]},'raw':!![]})[_0x76aa('0x17')](function(_0xf7732){if(_0xf7732&&_0xf7732['autoAssociation']===0x0){return db[_0x76aa('0x24')][_0x76aa('0x3c')]({'name':_0x288151[_0x76aa('0x23')],'resourceId':_0x288151['id'],'type':_0xf7732[_0x76aa('0x23')],'sectionId':_0xf7732['id']},{})[_0x76aa('0x17')](function(){return _0x316de3;});}else{return _0x316de3;}})[_0x76aa('0x3b')](function(_0x37babe){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x37babe);throw _0x37babe;});}return _0x316de3;});}})[_0x76aa('0x17')](respondWithResult(_0x18fd3e,0xc9))[_0x76aa('0x3b')](handleError(_0x18fd3e,null));};exports['update']=function(_0x3d7802,_0x1e6f3c){if(_0x3d7802['body']['id']){delete _0x3d7802[_0x76aa('0x3d')]['id'];}return db[_0x76aa('0x29')][_0x76aa('0x22')]({'where':{'id':_0x3d7802[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x1e6f3c,null))[_0x76aa('0x17')](saveUpdates(_0x3d7802[_0x76aa('0x3d')],null))[_0x76aa('0x17')](respondWithResult(_0x1e6f3c,null))[_0x76aa('0x3b')](handleError(_0x1e6f3c,null));};exports['destroy']=function(_0xd337f0,_0x49156c){return db[_0x76aa('0x29')][_0x76aa('0x22')]({'where':{'id':_0xd337f0[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x49156c,null))[_0x76aa('0x17')](removeEntity(_0x49156c,null))[_0x76aa('0x3b')](handleError(_0x49156c,null));};exports[_0x76aa('0x4a')]=function(_0x431d1c,_0x2f1263){var _0x5eceba={'raw':![],'where':{}};var _0x267fcf={};var _0x3d4025={'count':0x0,'rows':[]};return db[_0x76aa('0x29')][_0x76aa('0x4b')]({'where':{'id':_0x431d1c[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x2f1263,null))[_0x76aa('0x17')](function(_0x157540){if(_0x157540){_0x267fcf['model']=_[_0x76aa('0x32')](db['CmHopper'][_0x76aa('0x2a')]);_0x267fcf[_0x76aa('0x33')]=_[_0x76aa('0x32')](_0x431d1c[_0x76aa('0x33')]);_0x267fcf[_0x76aa('0x4c')]=_[_0x76aa('0x35')](_0x267fcf[_0x76aa('0x31')],_0x267fcf['query']);_0x5eceba[_0x76aa('0x34')]=_[_0x76aa('0x35')](_0x267fcf['model'],qs['fields'](_0x431d1c[_0x76aa('0x33')][_0x76aa('0x36')]));_0x5eceba['attributes']=_0x5eceba[_0x76aa('0x34')][_0x76aa('0x37')]?_0x5eceba[_0x76aa('0x34')]:_0x267fcf['model'];if(!_0x431d1c[_0x76aa('0x33')]['hasOwnProperty'](_0x76aa('0x4d'))){_0x5eceba[_0x76aa('0x12')]=qs[_0x76aa('0x12')](_0x431d1c[_0x76aa('0x33')]['limit']);_0x5eceba['offset']=qs[_0x76aa('0x14')](_0x431d1c['query'][_0x76aa('0x14')]);}_0x5eceba[_0x76aa('0x4e')]=qs[_0x76aa('0x4f')](_0x431d1c[_0x76aa('0x33')][_0x76aa('0x4f')]);_0x5eceba[_0x76aa('0x2d')]=qs[_0x76aa('0x4c')](_[_0x76aa('0x50')](_0x431d1c[_0x76aa('0x33')],_0x267fcf['filters']));_0x5eceba[_0x76aa('0x2d')][_0x76aa('0x51')]=_0x157540['id'];if(_0x431d1c[_0x76aa('0x33')][_0x76aa('0x52')]){_0x5eceba['where']=_['merge'](_0x5eceba['where'],{'$or':_[_0x76aa('0x1e')](_0x5eceba['attributes'],function(_0xb61e5){var _0x256195={};_0x256195[_0xb61e5]={'$like':'%'+_0x431d1c[_0x76aa('0x33')][_0x76aa('0x52')]+'%'};return _0x256195;})});}_0x5eceba=_['merge']({},_0x5eceba,_0x431d1c[_0x76aa('0x3a')]);return db['CmHopper'][_0x76aa('0x13')]({'where':_0x5eceba[_0x76aa('0x2d')]})[_0x76aa('0x17')](function(_0x11d602){_0x3d4025[_0x76aa('0x13')]=_0x11d602;if(_0x431d1c['query'][_0x76aa('0x38')]){_0x5eceba[_0x76aa('0x2e')]=[{'all':!![]}];}return db[_0x76aa('0x53')][_0x76aa('0x54')](_0x5eceba);})[_0x76aa('0x17')](function(_0x22432d){_0x3d4025[_0x76aa('0x2f')]=_0x22432d;return _0x3d4025;});}})[_0x76aa('0x17')](respondWithFilteredResult(_0x2f1263,_0x5eceba))['catch'](handleError(_0x2f1263,null));};exports[_0x76aa('0x55')]=function(_0x381f44,_0x48136a){var _0x3c1b98={'raw':!![],'where':{}};var _0x215463={};var _0x325487={'count':0x0,'rows':[]};return db[_0x76aa('0x29')][_0x76aa('0x4b')]({'where':{'id':_0x381f44[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x48136a,null))['then'](function(_0xdb821b){if(_0xdb821b){_0x215463['model']=_['keys'](db[_0x76aa('0x56')][_0x76aa('0x2a')]);_0x215463['query']=_['keys'](_0x381f44[_0x76aa('0x33')]);_0x215463[_0x76aa('0x4c')]=_[_0x76aa('0x35')](_0x215463['model'],_0x215463['query']);_0x3c1b98[_0x76aa('0x34')]=_[_0x76aa('0x35')](_0x215463[_0x76aa('0x31')],qs['fields'](_0x381f44[_0x76aa('0x33')]['fields']));_0x3c1b98[_0x76aa('0x34')]=_0x3c1b98[_0x76aa('0x34')][_0x76aa('0x37')]?_0x3c1b98[_0x76aa('0x34')]:_0x215463[_0x76aa('0x31')];if(!_0x381f44['query']['hasOwnProperty'](_0x76aa('0x4d'))){_0x3c1b98[_0x76aa('0x12')]=qs[_0x76aa('0x12')](_0x381f44['query'][_0x76aa('0x12')]);_0x3c1b98[_0x76aa('0x14')]=qs[_0x76aa('0x14')](_0x381f44[_0x76aa('0x33')][_0x76aa('0x14')]);}_0x3c1b98['order']=qs[_0x76aa('0x4f')](_0x381f44['query'][_0x76aa('0x4f')]);_0x3c1b98[_0x76aa('0x2d')]=qs[_0x76aa('0x4c')](_[_0x76aa('0x50')](_0x381f44[_0x76aa('0x33')],_0x215463[_0x76aa('0x4c')]));_0x3c1b98['where']['VoiceQueueId']=_0xdb821b['id'];if(_0x381f44['query']['filter']){_0x3c1b98['where']=_[_0x76aa('0x39')](_0x3c1b98[_0x76aa('0x2d')],{'$or':_['map'](_0x3c1b98['attributes'],function(_0x4f01e9){var _0x3a6326={};_0x3a6326[_0x4f01e9]={'$like':'%'+_0x381f44[_0x76aa('0x33')][_0x76aa('0x52')]+'%'};return _0x3a6326;})});}_0x3c1b98=_['merge']({},_0x3c1b98,_0x381f44['options']);return db[_0x76aa('0x56')][_0x76aa('0x13')]({'where':_0x3c1b98[_0x76aa('0x2d')]})[_0x76aa('0x17')](function(_0x354c7b){_0x325487['count']=_0x354c7b;if(_0x381f44['query'][_0x76aa('0x38')]){_0x3c1b98['include']=[{'all':!![]}];}return db['CmHopperHistory']['findAll'](_0x3c1b98);})[_0x76aa('0x17')](function(_0xbb1ccd){_0x325487['rows']=_0xbb1ccd;return _0x325487;});}})[_0x76aa('0x17')](respondWithFilteredResult(_0x48136a,_0x3c1b98))[_0x76aa('0x3b')](handleError(_0x48136a,null));};exports['getHopperFinals']=function(_0x22063f,_0x24331a){var _0x11d91f={'raw':!![],'where':{}};var _0x258e5a={};var _0x1fa86b={'count':0x0,'rows':[]};return db[_0x76aa('0x29')][_0x76aa('0x4b')]({'where':{'id':_0x22063f[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x24331a,null))['then'](function(_0x84bc91){if(_0x84bc91){_0x258e5a[_0x76aa('0x31')]=_['keys'](db[_0x76aa('0x57')][_0x76aa('0x2a')]);_0x258e5a[_0x76aa('0x33')]=_['keys'](_0x22063f[_0x76aa('0x33')]);_0x258e5a[_0x76aa('0x4c')]=_['intersection'](_0x258e5a[_0x76aa('0x31')],_0x258e5a[_0x76aa('0x33')]);_0x11d91f[_0x76aa('0x34')]=_['intersection'](_0x258e5a[_0x76aa('0x31')],qs[_0x76aa('0x36')](_0x22063f['query']['fields']));_0x11d91f['attributes']=_0x11d91f[_0x76aa('0x34')][_0x76aa('0x37')]?_0x11d91f[_0x76aa('0x34')]:_0x258e5a[_0x76aa('0x31')];if(!_0x22063f['query']['hasOwnProperty']('nolimit')){_0x11d91f[_0x76aa('0x12')]=qs['limit'](_0x22063f[_0x76aa('0x33')][_0x76aa('0x12')]);_0x11d91f['offset']=qs[_0x76aa('0x14')](_0x22063f[_0x76aa('0x33')]['offset']);}_0x11d91f[_0x76aa('0x4e')]=qs[_0x76aa('0x4f')](_0x22063f[_0x76aa('0x33')][_0x76aa('0x4f')]);_0x11d91f[_0x76aa('0x2d')]=qs[_0x76aa('0x4c')](_['pick'](_0x22063f[_0x76aa('0x33')],_0x258e5a['filters']));_0x11d91f['where']['VoiceQueueId']=_0x84bc91['id'];if(_0x22063f['query']['filter']){_0x11d91f[_0x76aa('0x2d')]=_[_0x76aa('0x39')](_0x11d91f[_0x76aa('0x2d')],{'$or':_[_0x76aa('0x1e')](_0x11d91f['attributes'],function(_0x447103){var _0x2192ed={};_0x2192ed[_0x447103]={'$like':'%'+_0x22063f[_0x76aa('0x33')][_0x76aa('0x52')]+'%'};return _0x2192ed;})});}_0x11d91f=_[_0x76aa('0x39')]({},_0x11d91f,_0x22063f['options']);return db[_0x76aa('0x57')][_0x76aa('0x13')]({'where':_0x11d91f[_0x76aa('0x2d')]})[_0x76aa('0x17')](function(_0x13be70){_0x1fa86b[_0x76aa('0x13')]=_0x13be70;if(_0x22063f[_0x76aa('0x33')]['includeAll']){_0x11d91f[_0x76aa('0x2e')]=[{'all':!![]}];}return db[_0x76aa('0x57')]['findAll'](_0x11d91f);})['then'](function(_0x216e87){_0x1fa86b[_0x76aa('0x2f')]=_0x216e87;return _0x1fa86b;});}})['then'](respondWithFilteredResult(_0x24331a,_0x11d91f))[_0x76aa('0x3b')](handleError(_0x24331a,null));};exports['getHopperBlacks']=function(_0x28ec11,_0x5cc005){var _0x28b439={'raw':!![],'where':{}};var _0x583924={};var _0x45227e={'count':0x0,'rows':[]};return db[_0x76aa('0x29')][_0x76aa('0x4b')]({'where':{'id':_0x28ec11['params']['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x5cc005,null))['then'](function(_0x1af32e){if(_0x1af32e){_0x583924[_0x76aa('0x31')]=_['keys'](db['CmHopperBlack'][_0x76aa('0x2a')]);_0x583924[_0x76aa('0x33')]=_[_0x76aa('0x32')](_0x28ec11[_0x76aa('0x33')]);_0x583924['filters']=_['intersection'](_0x583924[_0x76aa('0x31')],_0x583924['query']);_0x28b439[_0x76aa('0x34')]=_['intersection'](_0x583924[_0x76aa('0x31')],qs[_0x76aa('0x36')](_0x28ec11['query'][_0x76aa('0x36')]));_0x28b439['attributes']=_0x28b439['attributes'][_0x76aa('0x37')]?_0x28b439[_0x76aa('0x34')]:_0x583924['model'];if(!_0x28ec11[_0x76aa('0x33')][_0x76aa('0x58')](_0x76aa('0x4d'))){_0x28b439['limit']=qs[_0x76aa('0x12')](_0x28ec11[_0x76aa('0x33')][_0x76aa('0x12')]);_0x28b439[_0x76aa('0x14')]=qs[_0x76aa('0x14')](_0x28ec11[_0x76aa('0x33')][_0x76aa('0x14')]);}_0x28b439[_0x76aa('0x4e')]=qs[_0x76aa('0x4f')](_0x28ec11[_0x76aa('0x33')][_0x76aa('0x4f')]);_0x28b439[_0x76aa('0x2d')]=qs['filters'](_[_0x76aa('0x50')](_0x28ec11[_0x76aa('0x33')],_0x583924['filters']));_0x28b439[_0x76aa('0x2d')][_0x76aa('0x51')]=_0x1af32e['id'];if(_0x28ec11['query']['filter']){_0x28b439[_0x76aa('0x2d')]=_[_0x76aa('0x39')](_0x28b439['where'],{'$or':_[_0x76aa('0x1e')](_0x28b439[_0x76aa('0x34')],function(_0x24af48){var _0x5010c8={};_0x5010c8[_0x24af48]={'$like':'%'+_0x28ec11[_0x76aa('0x33')][_0x76aa('0x52')]+'%'};return _0x5010c8;})});}_0x28b439=_['merge']({},_0x28b439,_0x28ec11[_0x76aa('0x3a')]);return db[_0x76aa('0x59')][_0x76aa('0x13')]({'where':_0x28b439[_0x76aa('0x2d')]})[_0x76aa('0x17')](function(_0x42543c){_0x45227e['count']=_0x42543c;if(_0x28ec11[_0x76aa('0x33')]['includeAll']){_0x28b439[_0x76aa('0x2e')]=[{'all':!![]}];}return db[_0x76aa('0x59')][_0x76aa('0x54')](_0x28b439);})['then'](function(_0x4c5f54){_0x45227e[_0x76aa('0x2f')]=_0x4c5f54;return _0x45227e;});}})[_0x76aa('0x17')](respondWithFilteredResult(_0x5cc005,_0x28b439))[_0x76aa('0x3b')](handleError(_0x5cc005,null));};exports[_0x76aa('0x5a')]=function(_0x1a81fd,_0x1eb8f2){var _0x4f7dd4={};var _0x5a4c03={};var _0x2565a2;var _0x109bd3;return db[_0x76aa('0x29')][_0x76aa('0x4b')]({'where':{'id':_0x1a81fd['params']['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x1eb8f2,null))['then'](function(_0x54d530){if(_0x54d530){_0x2565a2=_0x54d530;_0x5a4c03[_0x76aa('0x31')]=_[_0x76aa('0x32')](db[_0x76aa('0x5b')]['rawAttributes']);_0x5a4c03[_0x76aa('0x33')]=_[_0x76aa('0x32')](_0x1a81fd[_0x76aa('0x33')]);_0x5a4c03[_0x76aa('0x4c')]=_[_0x76aa('0x35')](_0x5a4c03[_0x76aa('0x31')],_0x5a4c03[_0x76aa('0x33')]);_0x4f7dd4['attributes']=_[_0x76aa('0x35')](_0x5a4c03[_0x76aa('0x31')],qs[_0x76aa('0x36')](_0x1a81fd[_0x76aa('0x33')][_0x76aa('0x36')]));_0x4f7dd4[_0x76aa('0x34')]=_0x4f7dd4['attributes'][_0x76aa('0x37')]?_0x4f7dd4[_0x76aa('0x34')]:_0x5a4c03[_0x76aa('0x31')];_0x4f7dd4[_0x76aa('0x4e')]=qs['sort'](_0x1a81fd[_0x76aa('0x33')][_0x76aa('0x4f')]);_0x4f7dd4[_0x76aa('0x2d')]=qs[_0x76aa('0x4c')](_[_0x76aa('0x50')](_0x1a81fd['query'],_0x5a4c03[_0x76aa('0x4c')]));if(_0x1a81fd[_0x76aa('0x33')]['filter']){_0x4f7dd4['where']=_[_0x76aa('0x39')](_0x4f7dd4[_0x76aa('0x2d')],{'$or':_[_0x76aa('0x1e')](_0x4f7dd4[_0x76aa('0x34')],function(_0x46f098){var _0x293221={};_0x293221[_0x46f098]={'$like':'%'+_0x1a81fd['query'][_0x76aa('0x52')]+'%'};return _0x293221;})});}_0x4f7dd4=_[_0x76aa('0x39')]({},_0x4f7dd4,_0x1a81fd[_0x76aa('0x3a')]);return _0x2565a2[_0x76aa('0x5a')](_0x4f7dd4);}})[_0x76aa('0x17')](function(_0x2e7bb7){if(_0x2e7bb7){_0x109bd3=_0x2e7bb7['length'];if(!_0x1a81fd[_0x76aa('0x33')][_0x76aa('0x58')](_0x76aa('0x4d'))){_0x4f7dd4[_0x76aa('0x12')]=qs[_0x76aa('0x12')](_0x1a81fd[_0x76aa('0x33')]['limit']);_0x4f7dd4[_0x76aa('0x14')]=qs['offset'](_0x1a81fd[_0x76aa('0x33')]['offset']);}return _0x2565a2[_0x76aa('0x5a')](_0x4f7dd4);}})[_0x76aa('0x17')](function(_0x56d6af){if(_0x56d6af){return _0x56d6af?{'count':_0x109bd3,'rows':_0x56d6af}:null;}})[_0x76aa('0x17')](respondWithResult(_0x1eb8f2,null))[_0x76aa('0x3b')](handleError(_0x1eb8f2,null));};exports[_0x76aa('0x5c')]=function(_0x57636c,_0x3ae5e8){var _0x46c818=_0x57636c['body'][_0x76aa('0x5d')];var _0xfe926d=_[_0x76aa('0x1e')](_0x46c818,'id');return db[_0x76aa('0x5b')][_0x76aa('0x54')]({'where':{'id':_0xfe926d},'attributes':['id'],'include':[{'model':db[_0x76aa('0x5e')],'as':'Agents','attributes':['id',_0x76aa('0x23'),_0x76aa('0x5f'),_0x76aa('0x60'),_0x76aa('0x61')],'raw':!![]}]})[_0x76aa('0x17')](function(_0x28e1a4){if(_0x28e1a4){var _0x8bb516=_[_0x76aa('0x62')](_0x28e1a4,function(_0xf9f670){var _0x1359f9=_0xf9f670[_0x76aa('0x18')]({'plain':!![]});_0x1359f9['Agents'][_0x76aa('0x63')](function(_0x58cd0c){_0x58cd0c[_0x76aa('0x64')]=_[_0x76aa('0x22')](_0x46c818,{'id':_0x1359f9['id']})[_0x76aa('0x64')];});return _0x1359f9[_0x76aa('0x65')];});return db[_0x76aa('0x29')][_0x76aa('0x22')]({'where':{'id':_0x57636c['params']['id']}})[_0x76aa('0x17')](function(_0x53090c){return db[_0x76aa('0x66')][_0x76aa('0x67')](function(_0x2045a2){return _0x53090c['addTeams'](_0xfe926d,{'transaction':_0x2045a2})[_0x76aa('0x17')](function(){return BPromise[_0x76aa('0x68')](_0x46c818,function(_0x228968){return db[_0x76aa('0x69')][_0x76aa('0x6a')]({'TeamId':_0x228968['id'],'VoiceQueueId':_0x57636c['params']['id'],'penalty':_0x228968[_0x76aa('0x64')]},{'transaction':_0x2045a2});});})['then'](function(){return BPromise[_0x76aa('0x68')](_0x8bb516,function(_0x1bc764){return db['UserVoiceQueue'][_0x76aa('0x6b')]({'where':{'UserId':_0x1bc764['id'],'VoiceQueueId':_0x57636c[_0x76aa('0x46')]['id']},'defaults':{'penalty':_0x1bc764[_0x76aa('0x64')]},'transaction':_0x2045a2});});})[_0x76aa('0x17')](function(){return BPromise[_0x76aa('0x68')](_[_0x76aa('0x52')](_0x8bb516,{'online':!![]}),function(_0x245af7){return db[_0x76aa('0x6c')]['upsert']({'membername':_0x245af7[_0x76aa('0x23')],'UserId':_0x245af7['id'],'queue_name':_0x53090c[_0x76aa('0x23')],'VoiceQueueId':_0x53090c['id'],'interface':_[_0x76aa('0x6d')](_0x245af7[_0x76aa('0x61')])?util[_0x76aa('0x6e')](_0x76aa('0x6f'),_0x245af7[_0x76aa('0x23')]):_0x245af7[_0x76aa('0x61')],'paused':_0x245af7['voicePause']||![],'penalty':_0x245af7[_0x76aa('0x64')]},{'transaction':_0x2045a2});});})[_0x76aa('0x17')](function(){_0x8bb516[_0x76aa('0x63')](function(_0x54e450){socket[_0x76aa('0x70')](_0x76aa('0x71'),{'UserId':_0x54e450['id'],'VoiceQueueId':_0x53090c['id']});});});});});}})[_0x76aa('0x17')](respondWithStatusCode(_0x3ae5e8,null))[_0x76aa('0x3b')](handleError(_0x3ae5e8,null));};exports[_0x76aa('0x72')]=function(_0x5db8d8,_0x21fd43){return db['Team'][_0x76aa('0x54')]({'where':{'id':_0x5db8d8[_0x76aa('0x33')][_0x76aa('0x73')]},'attributes':['id'],'include':[{'model':db[_0x76aa('0x5e')],'as':_0x76aa('0x65'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x21fd43,null))[_0x76aa('0x17')](function(_0x4920fa){var _0x577463=_[_0x76aa('0x1e')](_0x4920fa,'id');var _0x20ba92=[];var _0x533080=[];var _0x3cd088=squel['select']();_0x3cd088[_0x76aa('0x74')](_0x76aa('0x75'))[_0x76aa('0x76')](_0x76aa('0x77'),'tq')[_0x76aa('0x78')](_0x76aa('0x79'),'ut','ut.TeamId\x20=\x20tq.TeamId')[_0x76aa('0x2d')](_0x76aa('0x7a'),_0x5db8d8[_0x76aa('0x46')]['id']);for(var _0x3ebe91=0x0;_0x3ebe91<_0x4920fa[_0x76aa('0x37')];_0x3ebe91+=0x1){let _0x14318c=_0x4920fa[_0x3ebe91];for(var _0xbfa5f8=0x0;_0xbfa5f8<_0x14318c[_0x76aa('0x65')][_0x76aa('0x37')];_0xbfa5f8+=0x1){let _0x46772f=_0x14318c[_0x76aa('0x65')][_0xbfa5f8];var _0x40df44=_0x3cd088[_0x76aa('0x45')]();_0x40df44[_0x76aa('0x2d')](_0x76aa('0x7b'),_0x46772f['id']);_0x533080[_0x76aa('0x7c')](db[_0x76aa('0x66')][_0x76aa('0x33')](_0x40df44['toString'](),{'type':db[_0x76aa('0x66')]['QueryTypes'][_0x76aa('0x7d')]})[_0x76aa('0x17')](function(_0x4a093b){if(_0x4a093b[_0x76aa('0x37')]===0x1){return _0x46772f['id'];}else{var _0x5305f1=_[_0x76aa('0x7e')](_[_0x76aa('0x1e')](_0x4a093b,_0x76aa('0x7f')),function(_0x5ceae2){return _[_0x76aa('0x20')](_0x577463,_0x5ceae2);});if(_0x5305f1){return _0x46772f['id'];}}}));}}return BPromise['all'](_0x533080)['then'](function(_0x3c9841){_0x20ba92=_(_0x20ba92)['union'](_0x3c9841)[_0x76aa('0x80')]()['value']();return db['VoiceQueue'][_0x76aa('0x22')]({'where':{'id':_0x5db8d8[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](function(_0x3f4ded){return db[_0x76aa('0x66')][_0x76aa('0x67')](function(_0x434634){return _0x3f4ded[_0x76aa('0x72')](_0x5db8d8[_0x76aa('0x33')][_0x76aa('0x73')],{'transaction':_0x434634})[_0x76aa('0x17')](function(){if(!_[_0x76aa('0x81')](_0x20ba92)){return _0x3f4ded[_0x76aa('0x82')](_0x20ba92,{'transaction':_0x434634})[_0x76aa('0x17')](function(){return db['UserVoiceQueueRt'][_0x76aa('0x25')]({'where':{'VoiceQueueId':_0x5db8d8[_0x76aa('0x46')]['id'],'UserId':_0x20ba92},'transaction':_0x434634});});}})[_0x76aa('0x17')](function(){_0x20ba92[_0x76aa('0x63')](function(_0x540bf3){socket[_0x76aa('0x70')]('userVoiceQueue:remove',{'UserId':_0x540bf3,'VoiceQueueId':_0x3f4ded['id']});});});});});});})[_0x76aa('0x17')](respondWithStatusCode(_0x21fd43,null))['catch'](handleError(_0x21fd43,null));};exports[_0x76aa('0x83')]=function(_0x5427f0,_0x3e9153){var _0x490090,_0x31b7a8;return db['VoiceQueue'][_0x76aa('0x22')]({'where':{'id':_0x5427f0[_0x76aa('0x46')]['id']}})['then'](handleEntityNotFound(_0x3e9153,null))[_0x76aa('0x17')](function(_0x51feca){if(_0x51feca){_0x31b7a8=_0x51feca;return _0x51feca[_0x76aa('0x83')](_0x5427f0['body'][_0x76aa('0x73')],_['omit'](_0x5427f0['body'],[_0x76aa('0x73'),'id'])||{})[_0x76aa('0x84')](function(_0x38b6aa){for(var _0x395501=0x0;_0x395501<_0x5427f0[_0x76aa('0x3d')][_0x76aa('0x73')][_0x76aa('0x37')];_0x395501+=0x1){socket[_0x76aa('0x70')](_0x76aa('0x71'),{'UserId':Number(_0x5427f0[_0x76aa('0x3d')]['ids'][_0x395501]),'VoiceQueueId':Number(_0x5427f0[_0x76aa('0x46')]['id'])});}return _0x38b6aa;});}})[_0x76aa('0x17')](function(_0x3d969f){_0x490090=_0x3d969f||[];if(_0x31b7a8){return db[_0x76aa('0x5e')][_0x76aa('0x54')]({'where':{'id':_0x5427f0[_0x76aa('0x3d')][_0x76aa('0x73')]},'attributes':['id',_0x76aa('0x23'),_0x76aa('0x5f'),_0x76aa('0x60'),_0x76aa('0x61')],'raw':!![]});}})[_0x76aa('0x17')](function(_0x3274a9){if(!_[_0x76aa('0x81')](_0x3274a9)){var _0x5c0268=[];for(var _0x5c5a6f=0x0;_0x5c5a6f<_0x3274a9[_0x76aa('0x37')];_0x5c5a6f++){if(_0x3274a9[_0x5c5a6f][_0x76aa('0x5f')]){_0x5c0268[_0x76aa('0x7c')](db['UserVoiceQueueRt']['upsert']({'membername':_0x3274a9[_0x5c5a6f][_0x76aa('0x23')],'UserId':_0x3274a9[_0x5c5a6f]['id'],'queue_name':_0x31b7a8[_0x76aa('0x23')],'VoiceQueueId':_0x31b7a8['id'],'interface':_[_0x76aa('0x6d')](_0x3274a9[_0x5c5a6f]['interface'])?util[_0x76aa('0x6e')](_0x76aa('0x6f'),_0x3274a9[_0x5c5a6f]['name']):_0x3274a9[_0x5c5a6f]['interface'],'paused':_0x3274a9[_0x5c5a6f]['voicePause']||![],'penalty':_0x5427f0[_0x76aa('0x3d')][_0x76aa('0x64')]||0x0}));}}return BPromise[_0x76aa('0x85')](_0x5c0268);}})['then'](function(){return _0x490090;})[_0x76aa('0x17')](respondWithResult(_0x3e9153,null))[_0x76aa('0x3b')](handleError(_0x3e9153,null));};exports['removeAgents']=function(_0x5433dc,_0x328d1a){return db[_0x76aa('0x29')][_0x76aa('0x22')]({'where':{'id':_0x5433dc['params']['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x328d1a,null))[_0x76aa('0x17')](function(_0x546770){if(_0x546770){return _0x546770[_0x76aa('0x82')](_0x5433dc[_0x76aa('0x33')]['ids'])[_0x76aa('0x17')](function(){if(_[_0x76aa('0x86')](_0x5433dc['query'][_0x76aa('0x73')])){for(var _0x4df504=0x0;_0x4df504<_0x5433dc['query'][_0x76aa('0x73')][_0x76aa('0x37')];_0x4df504+=0x1){socket[_0x76aa('0x70')](_0x76aa('0x87'),{'UserId':Number(_0x5433dc[_0x76aa('0x33')][_0x76aa('0x73')][_0x4df504]),'VoiceQueueId':Number(_0x5433dc[_0x76aa('0x46')]['id'])});}}else{socket[_0x76aa('0x70')](_0x76aa('0x87'),{'UserId':Number(_0x5433dc[_0x76aa('0x33')]['ids']),'VoiceQueueId':Number(_0x5433dc['params']['id'])});}});}})[_0x76aa('0x17')](function(_0x2726da){return db[_0x76aa('0x6c')][_0x76aa('0x25')]({'where':{'VoiceQueueId':_0x5433dc[_0x76aa('0x46')]['id'],'UserId':_0x5433dc[_0x76aa('0x33')]['ids']}})[_0x76aa('0x17')](function(){return _0x2726da;});})[_0x76aa('0x17')](respondWithStatusCode(_0x328d1a,null))[_0x76aa('0x3b')](handleError(_0x328d1a,null));};exports[_0x76aa('0x88')]=function(_0x38694d,_0xf0b932){var _0x1c8cf5={};var _0x5a8d0f={};var _0x5f513d;var _0x54e70c;return db[_0x76aa('0x29')][_0x76aa('0x4b')]({'where':{'id':_0x38694d[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0xf0b932,null))[_0x76aa('0x17')](function(_0x4afe13){if(_0x4afe13){_0x5f513d=_0x4afe13;_0x5a8d0f['model']=_[_0x76aa('0x32')](db[_0x76aa('0x5e')][_0x76aa('0x2a')]);_0x5a8d0f[_0x76aa('0x33')]=_[_0x76aa('0x32')](_0x38694d['query']);_0x5a8d0f[_0x76aa('0x4c')]=_['intersection'](_0x5a8d0f[_0x76aa('0x31')],_0x5a8d0f['query']);_0x1c8cf5['attributes']=_[_0x76aa('0x35')](_0x5a8d0f['model'],qs[_0x76aa('0x36')](_0x38694d[_0x76aa('0x33')][_0x76aa('0x36')]));_0x1c8cf5[_0x76aa('0x34')]=_0x1c8cf5[_0x76aa('0x34')][_0x76aa('0x37')]?_0x1c8cf5[_0x76aa('0x34')]:_0x5a8d0f[_0x76aa('0x31')];_0x1c8cf5['order']=qs[_0x76aa('0x4f')](_0x38694d[_0x76aa('0x33')][_0x76aa('0x4f')]);_0x1c8cf5[_0x76aa('0x2d')]=qs[_0x76aa('0x4c')](_['pick'](_0x38694d[_0x76aa('0x33')],_0x5a8d0f['filters']));if(_0x38694d[_0x76aa('0x33')]['filter']){_0x1c8cf5[_0x76aa('0x2d')]=_['merge'](_0x1c8cf5[_0x76aa('0x2d')],{'$or':_['map'](_0x1c8cf5[_0x76aa('0x34')],function(_0x8b2ee1){var _0x279be2={};_0x279be2[_0x8b2ee1]={'$like':'%'+_0x38694d['query']['filter']+'%'};return _0x279be2;})});}_0x1c8cf5=_[_0x76aa('0x39')]({},_0x1c8cf5,_0x38694d['options']);return _0x5f513d[_0x76aa('0x88')](_0x1c8cf5);}})[_0x76aa('0x17')](function(_0x1b99d8){if(_0x1b99d8){_0x54e70c=_0x1b99d8['length'];if(!_0x38694d['query']['hasOwnProperty']('nolimit')){_0x1c8cf5[_0x76aa('0x12')]=qs[_0x76aa('0x12')](_0x38694d[_0x76aa('0x33')][_0x76aa('0x12')]);_0x1c8cf5[_0x76aa('0x14')]=qs[_0x76aa('0x14')](_0x38694d[_0x76aa('0x33')][_0x76aa('0x14')]);}return _0x5f513d[_0x76aa('0x88')](_0x1c8cf5);}})[_0x76aa('0x17')](function(_0x2484fd){if(_0x2484fd){return _0x2484fd?{'count':_0x54e70c,'rows':_0x2484fd}:null;}})[_0x76aa('0x17')](respondWithResult(_0xf0b932,null))[_0x76aa('0x3b')](handleError(_0xf0b932,null));};exports['getMembers']=function(_0x2b12e9,_0x4e697b){var _0x1e902d={};var _0x3a7658={};var _0x1b1f85;var _0x3fb275;return db[_0x76aa('0x29')][_0x76aa('0x4b')]({'where':{'id':_0x2b12e9[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x4e697b,null))[_0x76aa('0x17')](function(_0x1bdc5c){if(_0x1bdc5c){_0x1b1f85=_0x1bdc5c;_0x3a7658[_0x76aa('0x31')]=_['keys'](db['UserVoiceQueueRt'][_0x76aa('0x2a')]);_0x3a7658[_0x76aa('0x33')]=_['keys'](_0x2b12e9[_0x76aa('0x33')]);_0x3a7658[_0x76aa('0x4c')]=_[_0x76aa('0x35')](_0x3a7658[_0x76aa('0x31')],_0x3a7658[_0x76aa('0x33')]);_0x1e902d[_0x76aa('0x34')]=_[_0x76aa('0x35')](_0x3a7658['model'],qs[_0x76aa('0x36')](_0x2b12e9[_0x76aa('0x33')]['fields']));_0x1e902d['attributes']=_0x1e902d[_0x76aa('0x34')][_0x76aa('0x37')]?_0x1e902d[_0x76aa('0x34')]:_0x3a7658[_0x76aa('0x31')];_0x1e902d[_0x76aa('0x4e')]=qs[_0x76aa('0x4f')](_0x2b12e9[_0x76aa('0x33')][_0x76aa('0x4f')]);_0x1e902d[_0x76aa('0x2d')]=qs[_0x76aa('0x4c')](_[_0x76aa('0x50')](_0x2b12e9[_0x76aa('0x33')],_0x3a7658[_0x76aa('0x4c')]));if(_0x2b12e9['query']['filter']){_0x1e902d[_0x76aa('0x2d')]=_[_0x76aa('0x39')](_0x1e902d[_0x76aa('0x2d')],{'$or':_[_0x76aa('0x1e')](_0x1e902d['attributes'],function(_0x5f3819){var _0x2a8410={};_0x2a8410[_0x5f3819]={'$like':'%'+_0x2b12e9[_0x76aa('0x33')][_0x76aa('0x52')]+'%'};return _0x2a8410;})});}_0x1e902d=_['merge']({},_0x1e902d,_0x2b12e9['options']);return _0x1b1f85['getMembers'](_0x1e902d);}})[_0x76aa('0x17')](function(_0x4df872){if(_0x4df872){_0x3fb275=_0x4df872[_0x76aa('0x37')];if(!_0x2b12e9[_0x76aa('0x33')][_0x76aa('0x58')](_0x76aa('0x4d'))){_0x1e902d[_0x76aa('0x12')]=qs[_0x76aa('0x12')](_0x2b12e9[_0x76aa('0x33')][_0x76aa('0x12')]);_0x1e902d[_0x76aa('0x14')]=qs[_0x76aa('0x14')](_0x2b12e9[_0x76aa('0x33')][_0x76aa('0x14')]);}return _0x1b1f85[_0x76aa('0x89')](_0x1e902d);}})[_0x76aa('0x17')](function(_0x3b1f33){return _0x3b1f33?{'count':_0x3fb275,'rows':_0x3b1f33}:null;})[_0x76aa('0x17')](respondWithResult(_0x4e697b,null))['catch'](handleError(_0x4e697b,null));};exports[_0x76aa('0x8a')]=function(_0x5e8cec,_0x1a37e9){var _0x58932f={};var _0x17bd1a={};var _0x5d7a2b;var _0x363c45;return db['VoiceQueue']['findOne']({'where':{'id':_0x5e8cec[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x1a37e9,null))[_0x76aa('0x17')](function(_0x44668d){if(_0x44668d){_0x5d7a2b=_0x44668d;_0x17bd1a[_0x76aa('0x31')]=_[_0x76aa('0x32')](db['CmList'][_0x76aa('0x2a')]);_0x17bd1a[_0x76aa('0x33')]=_[_0x76aa('0x32')](_0x5e8cec[_0x76aa('0x33')]);_0x17bd1a['filters']=_[_0x76aa('0x35')](_0x17bd1a[_0x76aa('0x31')],_0x17bd1a[_0x76aa('0x33')]);_0x58932f[_0x76aa('0x34')]=_[_0x76aa('0x35')](_0x17bd1a[_0x76aa('0x31')],qs[_0x76aa('0x36')](_0x5e8cec[_0x76aa('0x33')][_0x76aa('0x36')]));_0x58932f[_0x76aa('0x34')]=_0x58932f[_0x76aa('0x34')][_0x76aa('0x37')]?_0x58932f['attributes']:_0x17bd1a['model'];_0x58932f[_0x76aa('0x4e')]=qs[_0x76aa('0x4f')](_0x5e8cec[_0x76aa('0x33')][_0x76aa('0x4f')]);_0x58932f[_0x76aa('0x2d')]=qs[_0x76aa('0x4c')](_[_0x76aa('0x50')](_0x5e8cec[_0x76aa('0x33')],_0x17bd1a[_0x76aa('0x4c')]));if(_0x5e8cec[_0x76aa('0x33')][_0x76aa('0x52')]){_0x58932f['where']=_[_0x76aa('0x39')](_0x58932f['where'],{'$or':_[_0x76aa('0x1e')](_0x58932f[_0x76aa('0x34')],function(_0x278bac){var _0x14256c={};_0x14256c[_0x278bac]={'$like':'%'+_0x5e8cec[_0x76aa('0x33')]['filter']+'%'};return _0x14256c;})});}_0x58932f=_['merge']({},_0x58932f,_0x5e8cec[_0x76aa('0x3a')]);return _0x5d7a2b['getLists'](_0x58932f);}})[_0x76aa('0x17')](function(_0xb760ca){if(_0xb760ca){_0x363c45=_0xb760ca[_0x76aa('0x37')];if(!_0x5e8cec[_0x76aa('0x33')][_0x76aa('0x58')]('nolimit')){_0x58932f['limit']=qs[_0x76aa('0x12')](_0x5e8cec[_0x76aa('0x33')][_0x76aa('0x12')]);_0x58932f[_0x76aa('0x14')]=qs[_0x76aa('0x14')](_0x5e8cec[_0x76aa('0x33')][_0x76aa('0x14')]);}return _0x5d7a2b[_0x76aa('0x8a')](_0x58932f);}})[_0x76aa('0x17')](function(_0x33644d){if(_0x33644d){return _0x33644d?{'count':_0x363c45,'rows':_0x33644d}:null;}})['then'](respondWithResult(_0x1a37e9,null))[_0x76aa('0x3b')](handleError(_0x1a37e9,null));};exports[_0x76aa('0x8b')]=function(_0x4830ea,_0x20638f){var _0x2b2f27=moment()[_0x76aa('0x6e')](_0x76aa('0x8c'));var _0x1a5297,_0x487c28;return db[_0x76aa('0x29')]['find']({'where':{'id':_0x4830ea[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x20638f,null))[_0x76aa('0x17')](function(_0x2f2a27){if(_0x2f2a27){_0x487c28=_0x2f2a27;return _0x2f2a27['addLists'](_0x4830ea[_0x76aa('0x3d')][_0x76aa('0x73')],_[_0x76aa('0x47')](_0x4830ea[_0x76aa('0x3d')],[_0x76aa('0x73'),'id'])||{});}return null;})[_0x76aa('0x84')](function(_0xca12fa){var _0xb0a4e1;_0x1a5297=_0xca12fa||[];var _0x1f7f1d=[];if(_0xca12fa){for(var _0x413528=0x0;_0x413528<_0xca12fa[_0x76aa('0x37')];_0x413528+=0x1){var _0x39de41=_0xca12fa[_0x413528][_0x76aa('0x18')]({'plain':!![]});_0x487c28[_0x76aa('0x8d')]=_0x4830ea['body']['dialCheckDuplicateType']?_0x4830ea[_0x76aa('0x3d')][_0x76aa('0x8d')]:_0x487c28['dialCheckDuplicateType'];switch(_0x487c28[_0x76aa('0x8d')]){case'always':_0xb0a4e1=squel[_0x76aa('0x8e')]()[_0x76aa('0x8f')](_0x76aa('0x90'))[_0x76aa('0x91')]([_0x76aa('0x92'),_0x76aa('0x93'),_0x76aa('0x94'),_0x76aa('0x95'),'VoiceQueueId',_0x76aa('0x49'),_0x76aa('0x48')],squel['select']()['field'](_0x76aa('0x92'),_0x76aa('0x92'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27',_0x76aa('0x93'))[_0x76aa('0x74')]('id','ContactId')[_0x76aa('0x74')](_0x39de41['CmListId'][_0x76aa('0x96')](),_0x76aa('0x95'))[_0x76aa('0x74')](_0x4830ea[_0x76aa('0x46')]['id'][_0x76aa('0x96')](),_0x76aa('0x51'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27',_0x76aa('0x49'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27',_0x76aa('0x48'))[_0x76aa('0x76')](_0x76aa('0x97'))[_0x76aa('0x2d')]('deletedAt\x20IS\x20NULL')[_0x76aa('0x2d')]('ListId\x20=\x20?',_0x39de41['CmListId']['toString']())[_0x76aa('0x2d')]('phone\x20IS\x20NOT\x20NULL')['where']('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x76aa('0x74')](_0x76aa('0x98'))['from'](_0x76aa('0x99'))[_0x76aa('0x2d')](_0x76aa('0x7a'),_0x4830ea['params']['id']['toString']()))['where'](_0x76aa('0x9a'),squel['select']()[_0x76aa('0x74')](_0x76aa('0x9b'))['from'](_0x76aa('0x90'))[_0x76aa('0x2d')]('VoiceQueueId\x20=\x20?',_0x4830ea[_0x76aa('0x46')]['id'][_0x76aa('0x96')]())))[_0x76aa('0x96')]();break;case _0x76aa('0x9c'):_0xb0a4e1=squel[_0x76aa('0x8e')]()[_0x76aa('0x8f')](_0x76aa('0x90'))[_0x76aa('0x91')](['phone',_0x76aa('0x93'),_0x76aa('0x94'),_0x76aa('0x95'),_0x76aa('0x51'),_0x76aa('0x49'),_0x76aa('0x48')],squel[_0x76aa('0x9d')]()[_0x76aa('0x74')](_0x76aa('0x92'),_0x76aa('0x92'))['field']('\x27'+_0x2b2f27+'\x27',_0x76aa('0x93'))[_0x76aa('0x74')]('id',_0x76aa('0x94'))['field'](_0x39de41['CmListId']['toString'](),_0x76aa('0x95'))[_0x76aa('0x74')](_0x4830ea['params']['id'][_0x76aa('0x96')](),'VoiceQueueId')['field']('\x27'+_0x2b2f27+'\x27',_0x76aa('0x49'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27','updatedAt')[_0x76aa('0x76')](_0x76aa('0x97'))[_0x76aa('0x2d')]('deletedAt\x20IS\x20NULL')[_0x76aa('0x2d')](_0x76aa('0x9e'),_0x39de41[_0x76aa('0x9f')][_0x76aa('0x96')]())[_0x76aa('0x2d')](_0x76aa('0xa0'))[_0x76aa('0x2d')](_0x76aa('0x9a'),squel[_0x76aa('0x9d')]()[_0x76aa('0x74')](_0x76aa('0x9b'))['from'](_0x76aa('0x90'))[_0x76aa('0x2d')](_0x76aa('0x7a'),_0x4830ea['params']['id']['toString']())))[_0x76aa('0x96')]();break;default:_0xb0a4e1=squel[_0x76aa('0x8e')]()[_0x76aa('0x8f')]('cm_hopper')[_0x76aa('0x91')]([_0x76aa('0x92'),_0x76aa('0x93'),_0x76aa('0x94'),_0x76aa('0x95'),_0x76aa('0x51'),_0x76aa('0x49'),_0x76aa('0x48')],squel[_0x76aa('0x9d')]()[_0x76aa('0x74')](_0x76aa('0x92'),_0x76aa('0x92'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27',_0x76aa('0x93'))['field']('id',_0x76aa('0x94'))['field'](_0x39de41[_0x76aa('0x9f')]['toString'](),_0x76aa('0x95'))[_0x76aa('0x74')](_0x4830ea[_0x76aa('0x46')]['id']['toString'](),_0x76aa('0x51'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27',_0x76aa('0x49'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27',_0x76aa('0x48'))[_0x76aa('0x76')]('cm_contacts')['where'](_0x76aa('0xa1'))[_0x76aa('0x2d')](_0x76aa('0x9e'),_0x39de41['CmListId']['toString']())[_0x76aa('0x2d')](_0x76aa('0xa0')))[_0x76aa('0x96')]();}_0x1f7f1d['push'](db['sequelize'][_0x76aa('0x33')](_0xb0a4e1));}return BPromise[_0x76aa('0x85')](_0x1f7f1d);}})[_0x76aa('0x17')](function(){var _0xbb19e4=[];var _0x226b44=squel[_0x76aa('0x8e')]()[_0x76aa('0x8f')](_0x76aa('0xa2'))['fromQuery']([_0x76aa('0xa3'),_0x76aa('0x92'),_0x76aa('0xa4'),'createdAt',_0x76aa('0x48')],squel[_0x76aa('0x9d')]()[_0x76aa('0x74')]('h.id')['field'](_0x76aa('0xa5'))['field'](_0x76aa('0xa6'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27',_0x76aa('0x49'))[_0x76aa('0x74')]('\x27'+_0x2b2f27+'\x27','updatedAt')['from'](_0x76aa('0xa7'),'ci')[_0x76aa('0x78')](_0x76aa('0x90'),'h',_0x76aa('0xa8'))[_0x76aa('0x2d')](_0x76aa('0xa9'),_0x2b2f27)['where'](_0x76aa('0xaa'),_0x76aa('0xab')))[_0x76aa('0x96')]();_0xbb19e4['push'](db[_0x76aa('0x66')][_0x76aa('0x33')](_0x226b44));return BPromise[_0x76aa('0x85')](_0xbb19e4);})['then'](function(){return _0x1a5297;})[_0x76aa('0x17')](respondWithResult(_0x20638f,null))['catch'](handleError(_0x20638f,null));};exports['removeLists']=function(_0xef9ea7,_0x45f21f){return db[_0x76aa('0x29')]['find']({'where':{'id':_0xef9ea7[_0x76aa('0x46')]['id']}})['then'](handleEntityNotFound(_0x45f21f,null))[_0x76aa('0x17')](function(_0x113e70){if(_0x113e70){return _0x113e70['removeLists'](_0xef9ea7[_0x76aa('0x33')]['ids']);}})['then'](function(_0x583d68){if(_0x583d68){return db[_0x76aa('0x53')]['destroy']({'where':{'ListId':_0xef9ea7[_0x76aa('0x33')]['ids'],'VoiceQueueId':_0xef9ea7['params']['id']}})[_0x76aa('0x17')](function(){return _0x583d68;});}})['then'](respondWithStatusCode(_0x45f21f,null))['catch'](handleError(_0x45f21f,null));};exports[_0x76aa('0xac')]=function(_0x3b7370,_0x1c3431){var _0x865a1b={};var _0x132d60={};var _0x1a3074;var _0x3184a2;return db['VoiceQueue']['findOne']({'where':{'id':_0x3b7370[_0x76aa('0x46')]['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x1c3431,null))[_0x76aa('0x17')](function(_0x274356){if(_0x274356){_0x1a3074=_0x274356;_0x132d60[_0x76aa('0x31')]=_[_0x76aa('0x32')](db[_0x76aa('0xad')][_0x76aa('0x2a')]);_0x132d60[_0x76aa('0x33')]=_['keys'](_0x3b7370['query']);_0x132d60[_0x76aa('0x4c')]=_[_0x76aa('0x35')](_0x132d60[_0x76aa('0x31')],_0x132d60[_0x76aa('0x33')]);_0x865a1b['attributes']=_['intersection'](_0x132d60[_0x76aa('0x31')],qs['fields'](_0x3b7370[_0x76aa('0x33')][_0x76aa('0x36')]));_0x865a1b['attributes']=_0x865a1b[_0x76aa('0x34')][_0x76aa('0x37')]?_0x865a1b[_0x76aa('0x34')]:_0x132d60[_0x76aa('0x31')];_0x865a1b[_0x76aa('0x4e')]=qs['sort'](_0x3b7370[_0x76aa('0x33')][_0x76aa('0x4f')]);_0x865a1b['where']=qs['filters'](_[_0x76aa('0x50')](_0x3b7370[_0x76aa('0x33')],_0x132d60[_0x76aa('0x4c')]));if(_0x3b7370[_0x76aa('0x33')][_0x76aa('0x52')]){_0x865a1b[_0x76aa('0x2d')]=_[_0x76aa('0x39')](_0x865a1b[_0x76aa('0x2d')],{'$or':_[_0x76aa('0x1e')](_0x865a1b[_0x76aa('0x34')],function(_0xbb0ea3){var _0x4978dd={};_0x4978dd[_0xbb0ea3]={'$like':'%'+_0x3b7370[_0x76aa('0x33')][_0x76aa('0x52')]+'%'};return _0x4978dd;})});}_0x865a1b=_[_0x76aa('0x39')]({},_0x865a1b,_0x3b7370[_0x76aa('0x3a')]);return _0x1a3074['getBlackLists'](_0x865a1b);}})['then'](function(_0x4ee1d3){if(_0x4ee1d3){_0x3184a2=_0x4ee1d3['length'];if(!_0x3b7370[_0x76aa('0x33')][_0x76aa('0x58')](_0x76aa('0x4d'))){_0x865a1b[_0x76aa('0x12')]=qs[_0x76aa('0x12')](_0x3b7370[_0x76aa('0x33')][_0x76aa('0x12')]);_0x865a1b['offset']=qs['offset'](_0x3b7370[_0x76aa('0x33')]['offset']);}return _0x1a3074[_0x76aa('0xac')](_0x865a1b);}})[_0x76aa('0x17')](function(_0x3bc149){if(_0x3bc149){return _0x3bc149?{'count':_0x3184a2,'rows':_0x3bc149}:null;}})['then'](respondWithResult(_0x1c3431,null))[_0x76aa('0x3b')](handleError(_0x1c3431,null));};exports[_0x76aa('0xae')]=function(_0x29e112,_0x3fd683){var _0x5c2c4d;return db[_0x76aa('0x29')][_0x76aa('0x22')]({'where':{'id':_0x29e112[_0x76aa('0x46')]['id']}})['then'](handleEntityNotFound(_0x3fd683,null))[_0x76aa('0x17')](function(_0xcb041d){if(_0xcb041d){return _0xcb041d[_0x76aa('0xae')](_0x29e112[_0x76aa('0x3d')][_0x76aa('0x73')],_[_0x76aa('0x47')](_0x29e112[_0x76aa('0x3d')],['ids','id'])||{});}return null;})['spread'](function(_0x72b9a){var _0x29db0f;_0x5c2c4d=_0x72b9a||[];var _0x28a212=[];if(_0x72b9a){for(var _0x242cd6=0x0;_0x242cd6<_0x72b9a[_0x76aa('0x37')];_0x242cd6+=0x1){var _0xeb428a=_0x72b9a[_0x242cd6][_0x76aa('0x18')]({'plain':!![]});_0x29db0f=squel[_0x76aa('0x8e')]()[_0x76aa('0x8f')](_0x76aa('0xaf'))[_0x76aa('0x91')]([_0x76aa('0x92'),_0x76aa('0x94'),_0x76aa('0x95'),_0x76aa('0x51'),_0x76aa('0x49'),_0x76aa('0x48')],squel[_0x76aa('0x9d')]()[_0x76aa('0x74')](_0x76aa('0x92'),_0x76aa('0x92'))[_0x76aa('0x74')]('id',_0x76aa('0x94'))[_0x76aa('0x74')](_0xeb428a[_0x76aa('0x9f')][_0x76aa('0x96')](),_0x76aa('0x95'))[_0x76aa('0x74')](_0x29e112['params']['id'][_0x76aa('0x96')](),_0x76aa('0x51'))[_0x76aa('0x74')](_0x76aa('0xb0'),'createdAt')[_0x76aa('0x74')](_0x76aa('0xb0'),_0x76aa('0x48'))['from'](_0x76aa('0x97'))[_0x76aa('0x2d')]('deletedAt\x20IS\x20NULL')[_0x76aa('0x2d')]('ListId\x20=\x20?',_0xeb428a[_0x76aa('0x9f')][_0x76aa('0x96')]())[_0x76aa('0x2d')](_0x76aa('0xa0')))['toString']();_0x28a212[_0x76aa('0x7c')](db['sequelize'][_0x76aa('0x33')](_0x29db0f));}return BPromise['all'](_0x28a212);}})[_0x76aa('0x17')](function(){return _0x5c2c4d;})['then'](respondWithResult(_0x3fd683,null))[_0x76aa('0x3b')](handleError(_0x3fd683,null));};exports[_0x76aa('0xb1')]=function(_0x140ee1,_0x3d9e9e){return db[_0x76aa('0x29')][_0x76aa('0x22')]({'where':{'id':_0x140ee1['params']['id']}})[_0x76aa('0x17')](handleEntityNotFound(_0x3d9e9e,null))[_0x76aa('0x17')](function(_0x139e67){if(_0x139e67){return _0x139e67[_0x76aa('0xb1')](_0x140ee1['query'][_0x76aa('0x73')]);}})[_0x76aa('0x17')](function(_0x506cad){if(_0x506cad){return db['CmHopperBlack'][_0x76aa('0x25')]({'where':{'ListId':_0x140ee1[_0x76aa('0x33')][_0x76aa('0x73')],'VoiceQueueId':_0x140ee1[_0x76aa('0x46')]['id']}})['then'](function(){return _0x506cad;});}})['then'](respondWithStatusCode(_0x3d9e9e,null))[_0x76aa('0x3b')](handleError(_0x3d9e9e,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff