// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4990=['options','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','createdAt','updatedAt','user','UserProfileSection','userProfileId','getHoppers','findOne','CmHopper','VoiceQueueId','getHopperHistories','CmHopperHistory','CmHopperFinal','CmHopperBlack','Team','getTeams','teams','User','Agents','interface','flatMap','forEach','penalty','sequelize','transaction','addTeams','TeamVoiceQueue','upsert','each','findOrCreate','UserVoiceQueueRt','isNil','format','emit','userVoiceQueue:save','removeTeams','select','field','tq.TeamId','from','team_has_voice_queues','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','every','TeamId','includes','all','union','compact','ids','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','voicePause','isArray','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','fromQuery','phone','scheduledAt','ListId','NOW()','ContactId','CmListId','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','cm_hopper','onlyIfOpen','insert','into','cm_contacts','phone\x20IS\x20NOT\x20NULL','COALESCE(phone,\x27\x27)','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','html-pdf','eml-format','rimraf','zip-dir','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','crypto','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','defaults','localhost','socket.io-emitter','./voiceQueue.socket','register','sendStatus','end','status','count','set','Content-Range','apply','update','destroy','then','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','map','value','type','find','name','UserProfileResource','error','send','rawAttributes','fieldName','model','keys','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','limit','offset','order','sort','where','pick','merge','VIRTUAL','VoiceQueue','includeAll','findAll','rows','catch','show','params','include'];(function(_0x19a087,_0xb1ff28){var _0x1785f6=function(_0x23725b){while(--_0x23725b){_0x19a087['push'](_0x19a087['shift']());}};_0x1785f6(++_0xb1ff28);}(_0x4990,0x11a));var _0x0499=function(_0x5be8cc,_0x4a6037){_0x5be8cc=_0x5be8cc-0x0;var _0x5f1b7e=_0x4990[_0x5be8cc];return _0x5f1b7e;};'use strict';var pdf=require(_0x0499('0x0'));var emlformat=require(_0x0499('0x1'));var rimraf=require(_0x0499('0x2'));var zipdir=require(_0x0499('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x0499('0x4'));var moment=require('moment');var BPromise=require(_0x0499('0x5'));var Mustache=require(_0x0499('0x6'));var util=require(_0x0499('0x7'));var path=require(_0x0499('0x8'));var sox=require(_0x0499('0x9'));var csv=require(_0x0499('0xa'));var ejs=require(_0x0499('0xb'));var fs=require('fs');var _=require(_0x0499('0xc'));var squel=require('squel');var crypto=require(_0x0499('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x0499('0xe'));var toCsv=require(_0x0499('0xa'));var querystring=require('querystring');var Papa=require(_0x0499('0xf'));var Redis=require(_0x0499('0x10'));var authService=require(_0x0499('0x11'));var qs=require(_0x0499('0x12'));var as=require(_0x0499('0x13'));var hardwareService=require(_0x0499('0x14'));var logger=require('../../config/logger')(_0x0499('0x15'));var utils=require(_0x0499('0x16'));var config=require(_0x0499('0x17'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config['redis']=_[_0x0499('0x18')](config['redis'],{'host':_0x0499('0x19'),'port':0x18eb});var socket=require(_0x0499('0x1a'))(new Redis(config['redis']));require(_0x0499('0x1b'))[_0x0499('0x1c')](socket);function respondWithStatusCode(_0x1c6a4a,_0x1f555a){_0x1f555a=_0x1f555a||0xcc;return function(_0x58ef44){if(_0x58ef44){return _0x1c6a4a[_0x0499('0x1d')](_0x1f555a);}return _0x1c6a4a['status'](_0x1f555a)[_0x0499('0x1e')]();};}function respondWithResult(_0x23fef6,_0x29762c){_0x29762c=_0x29762c||0xc8;return function(_0x1c1420){if(_0x1c1420){return _0x23fef6[_0x0499('0x1f')](_0x29762c)['json'](_0x1c1420);}};}function respondWithFilteredResult(_0x3c0bd2,_0x5343e7){return function(_0x460dae){if(_0x460dae){var _0x5b3c17=_0x460dae[_0x0499('0x20')],_0x3b8e86=_0x5343e7['offset'],_0x59f44e=_0x5343e7['offset']+_0x5343e7['limit'],_0x5dab37;if(_0x59f44e>=_0x5b3c17){_0x59f44e=_0x5b3c17;_0x5dab37=0xc8;}else{_0x5dab37=0xce;}_0x3c0bd2[_0x0499('0x1f')](_0x5dab37);return _0x3c0bd2[_0x0499('0x21')](_0x0499('0x22'),_0x3b8e86+'-'+_0x59f44e+'/'+_0x5b3c17)['json'](_0x460dae);}return null;};}function patchUpdates(_0x3166df){return function(_0x3cab4e){try{jsonpatch[_0x0499('0x23')](_0x3cab4e,_0x3166df,!![]);}catch(_0x34a6aa){return BPromise['reject'](_0x34a6aa);}return _0x3cab4e['save']();};}function saveUpdates(_0x2d1bd7,_0x51b1dd){return function(_0x53ed02){if(_0x53ed02){return _0x53ed02[_0x0499('0x24')](_0x2d1bd7)['then'](function(_0x1da232){return _0x1da232;});}return null;};}function removeEntity(_0x95e4ab,_0x396bdb){return function(_0x3ed348){if(_0x3ed348){return _0x3ed348[_0x0499('0x25')]()[_0x0499('0x26')](function(){var _0x4cbe9d=_0x3ed348[_0x0499('0x27')]({'plain':!![]});var _0x117b1d=[{'name':_0x0499('0x28'),'value':_0x0499('0x29'),'ignore':![]},{'name':_0x0499('0x2a'),'value':_0x0499('0x2b'),'ignore':![]}];var _0x389898=_(_0x117b1d)[_0x0499('0x2c')](_0x0499('0x2d'))[_0x0499('0x2e')](_0x0499('0x2f'))[_0x0499('0x2f')]();if(_['includes'](_0x389898,_0x4cbe9d[_0x0499('0x30')])){return;}var _0x3be255=_[_0x0499('0x31')](_0x117b1d,[_0x0499('0x2f'),_0x4cbe9d[_0x0499('0x30')]])[_0x0499('0x32')];return db[_0x0499('0x33')][_0x0499('0x25')]({'where':{'type':_0x3be255,'resourceId':_0x4cbe9d['id']}})[_0x0499('0x26')](function(){return _0x3ed348;});})[_0x0499('0x26')](function(){_0x95e4ab['status'](0xcc)[_0x0499('0x1e')]();});}};}function handleEntityNotFound(_0x11c8c6,_0x6be50e){return function(_0x23e430){if(!_0x23e430){_0x11c8c6[_0x0499('0x1d')](0x194);}return _0x23e430;};}function handleError(_0x47231d,_0x6cd2db){_0x6cd2db=_0x6cd2db||0x1f4;return function(_0x1d9972){logger[_0x0499('0x34')](_0x1d9972['stack']);if(_0x1d9972[_0x0499('0x32')]){delete _0x1d9972[_0x0499('0x32')];}_0x47231d['status'](_0x6cd2db)[_0x0499('0x35')](_0x1d9972);};}exports['index']=function(_0x1b2bc2,_0x4f815c){var _0x37dcc1={},_0x12a550={},_0xcd483e={'count':0x0,'rows':[]};var _0x1ca34e=_['map'](db['VoiceQueue'][_0x0499('0x36')],function(_0x48f080){return{'name':_0x48f080[_0x0499('0x37')],'type':_0x48f080[_0x0499('0x30')]['key']};});_0x12a550[_0x0499('0x38')]=_[_0x0499('0x2e')](_0x1ca34e,_0x0499('0x32'));_0x12a550['query']=_[_0x0499('0x39')](_0x1b2bc2[_0x0499('0x3a')]);_0x12a550[_0x0499('0x3b')]=_['intersection'](_0x12a550['model'],_0x12a550[_0x0499('0x3a')]);_0x37dcc1['attributes']=_[_0x0499('0x3c')](_0x12a550['model'],qs[_0x0499('0x3d')](_0x1b2bc2[_0x0499('0x3a')][_0x0499('0x3d')]));_0x37dcc1[_0x0499('0x3e')]=_0x37dcc1['attributes'][_0x0499('0x3f')]?_0x37dcc1['attributes']:_0x12a550['model'];if(!_0x1b2bc2[_0x0499('0x3a')][_0x0499('0x40')](_0x0499('0x41'))){_0x37dcc1[_0x0499('0x42')]=qs['limit'](_0x1b2bc2[_0x0499('0x3a')][_0x0499('0x42')]);_0x37dcc1['offset']=qs[_0x0499('0x43')](_0x1b2bc2['query']['offset']);}_0x37dcc1[_0x0499('0x44')]=qs[_0x0499('0x45')](_0x1b2bc2[_0x0499('0x3a')][_0x0499('0x45')]);_0x37dcc1[_0x0499('0x46')]=qs['filters'](_[_0x0499('0x47')](_0x1b2bc2[_0x0499('0x3a')],_0x12a550['filters']),_0x1ca34e);if(_0x1b2bc2[_0x0499('0x3a')]['filter']){_0x37dcc1['where']=_[_0x0499('0x48')](_0x37dcc1[_0x0499('0x46')],{'$or':_['map'](_0x1ca34e,function(_0xab14a4){if(_0xab14a4['type']!==_0x0499('0x49')){var _0x61bdc6={};_0x61bdc6[_0xab14a4[_0x0499('0x32')]]={'$like':'%'+_0x1b2bc2[_0x0499('0x3a')][_0x0499('0x2c')]+'%'};return _0x61bdc6;}})});}_0x37dcc1=_[_0x0499('0x48')]({},_0x37dcc1,_0x1b2bc2['options']);var _0x13d4de={'where':_0x37dcc1[_0x0499('0x46')]};return db[_0x0499('0x4a')][_0x0499('0x20')](_0x13d4de)[_0x0499('0x26')](function(_0x4530d0){_0xcd483e[_0x0499('0x20')]=_0x4530d0;if(_0x1b2bc2[_0x0499('0x3a')][_0x0499('0x4b')]){_0x37dcc1['include']=[{'all':!![]}];}return db[_0x0499('0x4a')][_0x0499('0x4c')](_0x37dcc1);})[_0x0499('0x26')](function(_0x171874){_0xcd483e[_0x0499('0x4d')]=_0x171874;return _0xcd483e;})['then'](respondWithFilteredResult(_0x4f815c,_0x37dcc1))[_0x0499('0x4e')](handleError(_0x4f815c,null));};exports[_0x0499('0x4f')]=function(_0x2b3cf8,_0x5cf2a6){var _0x3f4688={'raw':![],'where':{'id':_0x2b3cf8[_0x0499('0x50')]['id']}},_0x36c81c={};_0x36c81c[_0x0499('0x38')]=_[_0x0499('0x39')](db['VoiceQueue'][_0x0499('0x36')]);_0x36c81c[_0x0499('0x3a')]=_[_0x0499('0x39')](_0x2b3cf8[_0x0499('0x3a')]);_0x36c81c['filters']=_[_0x0499('0x3c')](_0x36c81c[_0x0499('0x38')],_0x36c81c[_0x0499('0x3a')]);_0x3f4688[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x36c81c[_0x0499('0x38')],qs[_0x0499('0x3d')](_0x2b3cf8[_0x0499('0x3a')][_0x0499('0x3d')]));_0x3f4688[_0x0499('0x3e')]=_0x3f4688[_0x0499('0x3e')]['length']?_0x3f4688['attributes']:_0x36c81c[_0x0499('0x38')];if(_0x2b3cf8[_0x0499('0x3a')][_0x0499('0x4b')]){_0x3f4688[_0x0499('0x51')]=[{'all':!![]}];}_0x3f4688=_['merge']({},_0x3f4688,_0x2b3cf8[_0x0499('0x52')]);return db[_0x0499('0x4a')][_0x0499('0x31')](_0x3f4688)[_0x0499('0x26')](handleEntityNotFound(_0x5cf2a6,null))['then'](respondWithResult(_0x5cf2a6,null))[_0x0499('0x4e')](handleError(_0x5cf2a6,null));};exports[_0x0499('0x53')]=function(_0x2b33b4,_0x1f93cb){return db[_0x0499('0x4a')][_0x0499('0x53')](_0x2b33b4[_0x0499('0x54')],{})[_0x0499('0x26')](function(_0x262432){var _0x1822ac=_0x2b33b4['user'][_0x0499('0x27')]({'plain':!![]});if(!_0x1822ac)throw new Error(_0x0499('0x55'));if(_0x1822ac[_0x0499('0x56')]==='user'){var _0x1b9c38=_0x262432[_0x0499('0x27')]({'plain':!![]});var _0x432de1=[{'name':'VoiceQueues','value':_0x0499('0x29')},{'name':_0x0499('0x2a'),'value':_0x0499('0x2b')}];var _0x20826b=_[_0x0499('0x31')](_0x432de1,[_0x0499('0x2f'),_0x1b9c38[_0x0499('0x30')]])['name'];return db['UserProfileSection']['find']({'where':{'name':_0x20826b,'userProfileId':_0x1822ac['userProfileId']},'raw':!![]})[_0x0499('0x26')](function(_0x3cd4d3){if(_0x3cd4d3&&_0x3cd4d3[_0x0499('0x57')]===0x0){return db[_0x0499('0x33')][_0x0499('0x53')]({'name':_0x1b9c38['name'],'resourceId':_0x1b9c38['id'],'type':_0x3cd4d3[_0x0499('0x32')],'sectionId':_0x3cd4d3['id']},{})[_0x0499('0x26')](function(){return _0x262432;});}else{return _0x262432;}})[_0x0499('0x4e')](function(_0x397392){logger[_0x0499('0x34')](_0x0499('0x58'),_0x397392);throw _0x397392;});}return _0x262432;})[_0x0499('0x26')](respondWithResult(_0x1f93cb,0xc9))['catch'](handleError(_0x1f93cb,null));};exports['clone']=function(_0x2d10f6,_0xcb4448){var _0x2ba045={'where':{'id':_0x2d10f6[_0x0499('0x50')]['id']}},_0x8f4f40={};_0x8f4f40[_0x0499('0x38')]=_[_0x0499('0x39')](db[_0x0499('0x4a')][_0x0499('0x36')]);_0x2ba045[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x8f4f40['model'],qs[_0x0499('0x3d')](_0x2d10f6[_0x0499('0x3a')][_0x0499('0x3d')]));_0x2ba045[_0x0499('0x3e')]=_0x2ba045[_0x0499('0x3e')][_0x0499('0x3f')]?_0x2ba045[_0x0499('0x3e')]:_0x8f4f40['model'];if(_0x2d10f6['query']['includeAll']){_0x2ba045[_0x0499('0x51')]=[{'all':!![]}];}_0x2ba045=_[_0x0499('0x48')]({},_0x2ba045,_0x2d10f6[_0x0499('0x52')]);return db[_0x0499('0x4a')][_0x0499('0x31')](_0x2ba045)[_0x0499('0x26')](handleEntityNotFound(_0xcb4448,null))[_0x0499('0x26')](function(_0x575124){if(_0x575124){var _0x38a6e4=_0x575124['get']({'plain':!![]});_0x38a6e4=qs[_0x0499('0x59')](_0x38a6e4,['id',_0x0499('0x5a'),_0x0499('0x5b')]);_0x2d10f6[_0x0499('0x54')]=_[_0x0499('0x59')](_0x2d10f6[_0x0499('0x54')],['id',_0x0499('0x5a'),_0x0499('0x5b')]);return db['VoiceQueue'][_0x0499('0x53')](_['merge'](_0x38a6e4,_0x2d10f6[_0x0499('0x54')]),{'include':_0x2d10f6[_0x0499('0x3a')][_0x0499('0x4b')]?[{'all':!![]}]:undefined})[_0x0499('0x26')](function(_0x2e549b){var _0x563eae=_0x2d10f6['user']['get']({'plain':!![]});if(!_0x563eae)throw new Error(_0x0499('0x55'));if(_0x563eae['role']===_0x0499('0x5c')){var _0x3c15dd=_0x2e549b[_0x0499('0x27')]({'plain':!![]});var _0x51048f=[{'name':'VoiceQueues','value':_0x0499('0x29')},{'name':_0x0499('0x2a'),'value':_0x0499('0x2b')}];var _0xd6f199=_['find'](_0x51048f,['value',_0x3c15dd[_0x0499('0x30')]])[_0x0499('0x32')];return db[_0x0499('0x5d')][_0x0499('0x31')]({'where':{'name':_0xd6f199,'userProfileId':_0x563eae[_0x0499('0x5e')]},'raw':!![]})['then'](function(_0x22203a){if(_0x22203a&&_0x22203a[_0x0499('0x57')]===0x0){return db['UserProfileResource'][_0x0499('0x53')]({'name':_0x3c15dd['name'],'resourceId':_0x3c15dd['id'],'type':_0x22203a['name'],'sectionId':_0x22203a['id']},{})[_0x0499('0x26')](function(){return _0x2e549b;});}else{return _0x2e549b;}})[_0x0499('0x4e')](function(_0x498279){logger[_0x0499('0x34')](_0x0499('0x58'),_0x498279);throw _0x498279;});}return _0x2e549b;});}})[_0x0499('0x26')](respondWithResult(_0xcb4448,0xc9))[_0x0499('0x4e')](handleError(_0xcb4448,null));};exports[_0x0499('0x24')]=function(_0x441bde,_0x2438b6){if(_0x441bde[_0x0499('0x54')]['id']){delete _0x441bde[_0x0499('0x54')]['id'];}return db[_0x0499('0x4a')][_0x0499('0x31')]({'where':{'id':_0x441bde[_0x0499('0x50')]['id']}})['then'](handleEntityNotFound(_0x2438b6,null))[_0x0499('0x26')](saveUpdates(_0x441bde[_0x0499('0x54')],null))['then'](respondWithResult(_0x2438b6,null))['catch'](handleError(_0x2438b6,null));};exports['destroy']=function(_0x2fa114,_0x28d7b6){return db['VoiceQueue'][_0x0499('0x31')]({'where':{'id':_0x2fa114[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x28d7b6,null))['then'](removeEntity(_0x28d7b6,null))[_0x0499('0x4e')](handleError(_0x28d7b6,null));};exports[_0x0499('0x5f')]=function(_0x5ecf60,_0x196f30,_0x349b47){var _0x936ea={'raw':![],'where':{}};var _0x1ff364={};var _0x1a75f8={'count':0x0,'rows':[]};return db[_0x0499('0x4a')][_0x0499('0x60')]({'where':{'id':_0x5ecf60['params']['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x196f30,null))[_0x0499('0x26')](function(_0xf75e4f){if(_0xf75e4f){_0x1ff364['model']=_[_0x0499('0x39')](db[_0x0499('0x61')][_0x0499('0x36')]);_0x1ff364[_0x0499('0x3a')]=_[_0x0499('0x39')](_0x5ecf60[_0x0499('0x3a')]);_0x1ff364[_0x0499('0x3b')]=_[_0x0499('0x3c')](_0x1ff364['model'],_0x1ff364[_0x0499('0x3a')]);_0x936ea[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x1ff364[_0x0499('0x38')],qs[_0x0499('0x3d')](_0x5ecf60['query'][_0x0499('0x3d')]));_0x936ea[_0x0499('0x3e')]=_0x936ea[_0x0499('0x3e')][_0x0499('0x3f')]?_0x936ea[_0x0499('0x3e')]:_0x1ff364[_0x0499('0x38')];if(!_0x5ecf60['query'][_0x0499('0x40')]('nolimit')){_0x936ea['limit']=qs[_0x0499('0x42')](_0x5ecf60[_0x0499('0x3a')]['limit']);_0x936ea[_0x0499('0x43')]=qs[_0x0499('0x43')](_0x5ecf60[_0x0499('0x3a')]['offset']);}_0x936ea['order']=qs[_0x0499('0x45')](_0x5ecf60[_0x0499('0x3a')][_0x0499('0x45')]);_0x936ea['where']=qs[_0x0499('0x3b')](_[_0x0499('0x47')](_0x5ecf60['query'],_0x1ff364['filters']));_0x936ea[_0x0499('0x46')][_0x0499('0x62')]=_0xf75e4f['id'];if(_0x5ecf60['query'][_0x0499('0x2c')]){_0x936ea[_0x0499('0x46')]=_[_0x0499('0x48')](_0x936ea[_0x0499('0x46')],{'$or':_['map'](_0x936ea[_0x0499('0x3e')],function(_0x486197){var _0x27c174={};_0x27c174[_0x486197]={'$like':'%'+_0x5ecf60['query'][_0x0499('0x2c')]+'%'};return _0x27c174;})});}_0x936ea=_[_0x0499('0x48')]({},_0x936ea,_0x5ecf60[_0x0499('0x52')]);return db[_0x0499('0x61')][_0x0499('0x20')]({'where':_0x936ea[_0x0499('0x46')]})[_0x0499('0x26')](function(_0x10d33e){_0x1a75f8['count']=_0x10d33e;if(_0x5ecf60[_0x0499('0x3a')][_0x0499('0x4b')]){_0x936ea[_0x0499('0x51')]=[{'all':!![]}];}return db[_0x0499('0x61')][_0x0499('0x4c')](_0x936ea);})[_0x0499('0x26')](function(_0x238866){_0x1a75f8[_0x0499('0x4d')]=_0x238866;return _0x1a75f8;});}})[_0x0499('0x26')](respondWithFilteredResult(_0x196f30,_0x936ea))[_0x0499('0x4e')](handleError(_0x196f30,null));};exports[_0x0499('0x63')]=function(_0x3e7f7,_0x42b2e9,_0x246b8e){var _0x419035={'raw':!![],'where':{}};var _0x450d5e={};var _0x2ce792={'count':0x0,'rows':[]};return db[_0x0499('0x4a')][_0x0499('0x60')]({'where':{'id':_0x3e7f7[_0x0499('0x50')]['id']}})['then'](handleEntityNotFound(_0x42b2e9,null))[_0x0499('0x26')](function(_0x298b82){if(_0x298b82){_0x450d5e[_0x0499('0x38')]=_['keys'](db[_0x0499('0x64')]['rawAttributes']);_0x450d5e['query']=_[_0x0499('0x39')](_0x3e7f7[_0x0499('0x3a')]);_0x450d5e[_0x0499('0x3b')]=_[_0x0499('0x3c')](_0x450d5e[_0x0499('0x38')],_0x450d5e['query']);_0x419035[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x450d5e[_0x0499('0x38')],qs[_0x0499('0x3d')](_0x3e7f7[_0x0499('0x3a')][_0x0499('0x3d')]));_0x419035[_0x0499('0x3e')]=_0x419035[_0x0499('0x3e')][_0x0499('0x3f')]?_0x419035[_0x0499('0x3e')]:_0x450d5e[_0x0499('0x38')];if(!_0x3e7f7['query'][_0x0499('0x40')](_0x0499('0x41'))){_0x419035['limit']=qs[_0x0499('0x42')](_0x3e7f7[_0x0499('0x3a')][_0x0499('0x42')]);_0x419035[_0x0499('0x43')]=qs[_0x0499('0x43')](_0x3e7f7[_0x0499('0x3a')][_0x0499('0x43')]);}_0x419035[_0x0499('0x44')]=qs[_0x0499('0x45')](_0x3e7f7[_0x0499('0x3a')][_0x0499('0x45')]);_0x419035[_0x0499('0x46')]=qs[_0x0499('0x3b')](_['pick'](_0x3e7f7[_0x0499('0x3a')],_0x450d5e[_0x0499('0x3b')]));_0x419035[_0x0499('0x46')][_0x0499('0x62')]=_0x298b82['id'];if(_0x3e7f7[_0x0499('0x3a')][_0x0499('0x2c')]){_0x419035[_0x0499('0x46')]=_[_0x0499('0x48')](_0x419035['where'],{'$or':_['map'](_0x419035['attributes'],function(_0x4e0fe1){var _0x3a5263={};_0x3a5263[_0x4e0fe1]={'$like':'%'+_0x3e7f7[_0x0499('0x3a')][_0x0499('0x2c')]+'%'};return _0x3a5263;})});}_0x419035=_[_0x0499('0x48')]({},_0x419035,_0x3e7f7[_0x0499('0x52')]);return db[_0x0499('0x64')][_0x0499('0x20')]({'where':_0x419035[_0x0499('0x46')]})[_0x0499('0x26')](function(_0x4e9b95){_0x2ce792[_0x0499('0x20')]=_0x4e9b95;if(_0x3e7f7['query'][_0x0499('0x4b')]){_0x419035[_0x0499('0x51')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x0499('0x4c')](_0x419035);})[_0x0499('0x26')](function(_0x43523b){_0x2ce792[_0x0499('0x4d')]=_0x43523b;return _0x2ce792;});}})[_0x0499('0x26')](respondWithFilteredResult(_0x42b2e9,_0x419035))[_0x0499('0x4e')](handleError(_0x42b2e9,null));};exports['getHopperFinals']=function(_0x49e90f,_0x219eeb,_0x3c25a3){var _0x19f2d3={'raw':!![],'where':{}};var _0x2369b7={};var _0x151508={'count':0x0,'rows':[]};return db[_0x0499('0x4a')]['findOne']({'where':{'id':_0x49e90f[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x219eeb,null))[_0x0499('0x26')](function(_0x167a04){if(_0x167a04){_0x2369b7[_0x0499('0x38')]=_[_0x0499('0x39')](db[_0x0499('0x65')][_0x0499('0x36')]);_0x2369b7[_0x0499('0x3a')]=_[_0x0499('0x39')](_0x49e90f[_0x0499('0x3a')]);_0x2369b7[_0x0499('0x3b')]=_[_0x0499('0x3c')](_0x2369b7['model'],_0x2369b7[_0x0499('0x3a')]);_0x19f2d3['attributes']=_['intersection'](_0x2369b7[_0x0499('0x38')],qs[_0x0499('0x3d')](_0x49e90f[_0x0499('0x3a')][_0x0499('0x3d')]));_0x19f2d3[_0x0499('0x3e')]=_0x19f2d3['attributes'][_0x0499('0x3f')]?_0x19f2d3['attributes']:_0x2369b7[_0x0499('0x38')];if(!_0x49e90f['query']['hasOwnProperty'](_0x0499('0x41'))){_0x19f2d3[_0x0499('0x42')]=qs[_0x0499('0x42')](_0x49e90f[_0x0499('0x3a')][_0x0499('0x42')]);_0x19f2d3['offset']=qs[_0x0499('0x43')](_0x49e90f['query']['offset']);}_0x19f2d3[_0x0499('0x44')]=qs[_0x0499('0x45')](_0x49e90f['query']['sort']);_0x19f2d3[_0x0499('0x46')]=qs[_0x0499('0x3b')](_[_0x0499('0x47')](_0x49e90f[_0x0499('0x3a')],_0x2369b7['filters']));_0x19f2d3['where'][_0x0499('0x62')]=_0x167a04['id'];if(_0x49e90f['query']['filter']){_0x19f2d3['where']=_[_0x0499('0x48')](_0x19f2d3[_0x0499('0x46')],{'$or':_['map'](_0x19f2d3[_0x0499('0x3e')],function(_0x28ade8){var _0x3f1e08={};_0x3f1e08[_0x28ade8]={'$like':'%'+_0x49e90f['query'][_0x0499('0x2c')]+'%'};return _0x3f1e08;})});}_0x19f2d3=_[_0x0499('0x48')]({},_0x19f2d3,_0x49e90f[_0x0499('0x52')]);return db[_0x0499('0x65')][_0x0499('0x20')]({'where':_0x19f2d3[_0x0499('0x46')]})[_0x0499('0x26')](function(_0x29b8b9){_0x151508[_0x0499('0x20')]=_0x29b8b9;if(_0x49e90f[_0x0499('0x3a')][_0x0499('0x4b')]){_0x19f2d3[_0x0499('0x51')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x19f2d3);})[_0x0499('0x26')](function(_0x360bb7){_0x151508[_0x0499('0x4d')]=_0x360bb7;return _0x151508;});}})[_0x0499('0x26')](respondWithFilteredResult(_0x219eeb,_0x19f2d3))[_0x0499('0x4e')](handleError(_0x219eeb,null));};exports['getHopperBlacks']=function(_0x3e886e,_0x250b7c,_0x3264fc){var _0x370283={'raw':!![],'where':{}};var _0x426154={};var _0x5f3f35={'count':0x0,'rows':[]};return db[_0x0499('0x4a')][_0x0499('0x60')]({'where':{'id':_0x3e886e[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x250b7c,null))[_0x0499('0x26')](function(_0x26fde2){if(_0x26fde2){_0x426154[_0x0499('0x38')]=_[_0x0499('0x39')](db[_0x0499('0x66')]['rawAttributes']);_0x426154[_0x0499('0x3a')]=_[_0x0499('0x39')](_0x3e886e['query']);_0x426154[_0x0499('0x3b')]=_[_0x0499('0x3c')](_0x426154[_0x0499('0x38')],_0x426154[_0x0499('0x3a')]);_0x370283[_0x0499('0x3e')]=_['intersection'](_0x426154[_0x0499('0x38')],qs['fields'](_0x3e886e['query'][_0x0499('0x3d')]));_0x370283[_0x0499('0x3e')]=_0x370283[_0x0499('0x3e')][_0x0499('0x3f')]?_0x370283[_0x0499('0x3e')]:_0x426154[_0x0499('0x38')];if(!_0x3e886e['query'][_0x0499('0x40')](_0x0499('0x41'))){_0x370283[_0x0499('0x42')]=qs[_0x0499('0x42')](_0x3e886e[_0x0499('0x3a')][_0x0499('0x42')]);_0x370283[_0x0499('0x43')]=qs[_0x0499('0x43')](_0x3e886e[_0x0499('0x3a')]['offset']);}_0x370283[_0x0499('0x44')]=qs['sort'](_0x3e886e['query'][_0x0499('0x45')]);_0x370283[_0x0499('0x46')]=qs['filters'](_[_0x0499('0x47')](_0x3e886e[_0x0499('0x3a')],_0x426154[_0x0499('0x3b')]));_0x370283[_0x0499('0x46')][_0x0499('0x62')]=_0x26fde2['id'];if(_0x3e886e['query']['filter']){_0x370283[_0x0499('0x46')]=_[_0x0499('0x48')](_0x370283[_0x0499('0x46')],{'$or':_[_0x0499('0x2e')](_0x370283[_0x0499('0x3e')],function(_0x4db38a){var _0x1626b0={};_0x1626b0[_0x4db38a]={'$like':'%'+_0x3e886e[_0x0499('0x3a')][_0x0499('0x2c')]+'%'};return _0x1626b0;})});}_0x370283=_[_0x0499('0x48')]({},_0x370283,_0x3e886e[_0x0499('0x52')]);return db[_0x0499('0x66')]['count']({'where':_0x370283[_0x0499('0x46')]})[_0x0499('0x26')](function(_0x1d2f4c){_0x5f3f35[_0x0499('0x20')]=_0x1d2f4c;if(_0x3e886e[_0x0499('0x3a')][_0x0499('0x4b')]){_0x370283[_0x0499('0x51')]=[{'all':!![]}];}return db[_0x0499('0x66')]['findAll'](_0x370283);})[_0x0499('0x26')](function(_0x5d7830){_0x5f3f35[_0x0499('0x4d')]=_0x5d7830;return _0x5f3f35;});}})[_0x0499('0x26')](respondWithFilteredResult(_0x250b7c,_0x370283))[_0x0499('0x4e')](handleError(_0x250b7c,null));};exports['getTeams']=function(_0x2493b2,_0x1222c3,_0x5248d8){var _0x56acce={};var _0x352e48={};var _0x4e62d7;var _0x36b3e8;return db[_0x0499('0x4a')][_0x0499('0x60')]({'where':{'id':_0x2493b2['params']['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x1222c3,null))[_0x0499('0x26')](function(_0x32d204){if(_0x32d204){_0x4e62d7=_0x32d204;_0x352e48[_0x0499('0x38')]=_[_0x0499('0x39')](db[_0x0499('0x67')][_0x0499('0x36')]);_0x352e48['query']=_[_0x0499('0x39')](_0x2493b2['query']);_0x352e48[_0x0499('0x3b')]=_[_0x0499('0x3c')](_0x352e48['model'],_0x352e48[_0x0499('0x3a')]);_0x56acce[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x352e48['model'],qs[_0x0499('0x3d')](_0x2493b2[_0x0499('0x3a')][_0x0499('0x3d')]));_0x56acce[_0x0499('0x3e')]=_0x56acce[_0x0499('0x3e')]['length']?_0x56acce[_0x0499('0x3e')]:_0x352e48['model'];_0x56acce['order']=qs[_0x0499('0x45')](_0x2493b2['query'][_0x0499('0x45')]);_0x56acce['where']=qs[_0x0499('0x3b')](_[_0x0499('0x47')](_0x2493b2[_0x0499('0x3a')],_0x352e48[_0x0499('0x3b')]));if(_0x2493b2[_0x0499('0x3a')][_0x0499('0x2c')]){_0x56acce[_0x0499('0x46')]=_[_0x0499('0x48')](_0x56acce['where'],{'$or':_[_0x0499('0x2e')](_0x56acce[_0x0499('0x3e')],function(_0x141fb3){var _0x5f1cdd={};_0x5f1cdd[_0x141fb3]={'$like':'%'+_0x2493b2['query'][_0x0499('0x2c')]+'%'};return _0x5f1cdd;})});}_0x56acce=_[_0x0499('0x48')]({},_0x56acce,_0x2493b2['options']);return _0x4e62d7[_0x0499('0x68')](_0x56acce);}})[_0x0499('0x26')](function(_0x407630){if(_0x407630){_0x36b3e8=_0x407630[_0x0499('0x3f')];if(!_0x2493b2[_0x0499('0x3a')]['hasOwnProperty']('nolimit')){_0x56acce[_0x0499('0x42')]=qs[_0x0499('0x42')](_0x2493b2[_0x0499('0x3a')][_0x0499('0x42')]);_0x56acce[_0x0499('0x43')]=qs[_0x0499('0x43')](_0x2493b2['query']['offset']);}return _0x4e62d7['getTeams'](_0x56acce);}})[_0x0499('0x26')](function(_0x3d8d53){if(_0x3d8d53){return _0x3d8d53?{'count':_0x36b3e8,'rows':_0x3d8d53}:null;}})[_0x0499('0x26')](respondWithResult(_0x1222c3,null))[_0x0499('0x4e')](handleError(_0x1222c3,null));};exports['addTeams']=function(_0x5550ce,_0x17f760,_0x2d8544){var _0x6772c1=_0x5550ce[_0x0499('0x54')][_0x0499('0x69')];var _0x1ee815=_['map'](_0x6772c1,'id');return db[_0x0499('0x67')]['findAll']({'where':{'id':_0x1ee815},'attributes':['id'],'include':[{'model':db[_0x0499('0x6a')],'as':_0x0499('0x6b'),'attributes':['id',_0x0499('0x32'),'online','voicePause',_0x0499('0x6c')],'raw':!![]}]})[_0x0499('0x26')](function(_0x5a9a6a){if(_0x5a9a6a){var _0x1ea363=_[_0x0499('0x6d')](_0x5a9a6a,function(_0x4b3459){var _0x448d5e=_0x4b3459[_0x0499('0x27')]({'plain':!![]});_0x448d5e[_0x0499('0x6b')][_0x0499('0x6e')](function(_0x4f3e1a){_0x4f3e1a['penalty']=_['find'](_0x6772c1,{'id':_0x448d5e['id']})[_0x0499('0x6f')];});return _0x448d5e[_0x0499('0x6b')];});return db[_0x0499('0x4a')][_0x0499('0x31')]({'where':{'id':_0x5550ce[_0x0499('0x50')]['id']}})[_0x0499('0x26')](function(_0x56207a){return db[_0x0499('0x70')][_0x0499('0x71')](function(_0x9f1fe3){return _0x56207a[_0x0499('0x72')](_0x1ee815,{'transaction':_0x9f1fe3})[_0x0499('0x26')](function(){return BPromise['each'](_0x6772c1,function(_0x138b7b){return db[_0x0499('0x73')][_0x0499('0x74')]({'TeamId':_0x138b7b['id'],'VoiceQueueId':_0x5550ce[_0x0499('0x50')]['id'],'penalty':_0x138b7b[_0x0499('0x6f')]},{'transaction':_0x9f1fe3});});})[_0x0499('0x26')](function(){return BPromise[_0x0499('0x75')](_0x1ea363,function(_0x520e52){return db['UserVoiceQueue'][_0x0499('0x76')]({'where':{'UserId':_0x520e52['id'],'VoiceQueueId':_0x5550ce[_0x0499('0x50')]['id']},'defaults':{'penalty':_0x520e52[_0x0499('0x6f')]},'transaction':_0x9f1fe3});});})[_0x0499('0x26')](function(){return BPromise['each'](_[_0x0499('0x2c')](_0x1ea363,{'online':!![]}),function(_0x8d0bfb){return db[_0x0499('0x77')][_0x0499('0x74')]({'membername':_0x8d0bfb[_0x0499('0x32')],'UserId':_0x8d0bfb['id'],'queue_name':_0x56207a[_0x0499('0x32')],'VoiceQueueId':_0x56207a['id'],'interface':_[_0x0499('0x78')](_0x8d0bfb[_0x0499('0x6c')])?util[_0x0499('0x79')]('SIP/%s',_0x8d0bfb[_0x0499('0x32')]):_0x8d0bfb['interface'],'paused':_0x8d0bfb['voicePause']||![],'penalty':_0x8d0bfb[_0x0499('0x6f')]},{'transaction':_0x9f1fe3});});})[_0x0499('0x26')](function(){_0x1ea363[_0x0499('0x6e')](function(_0x54807f){socket[_0x0499('0x7a')](_0x0499('0x7b'),{'UserId':_0x54807f['id'],'VoiceQueueId':_0x56207a['id']});});});});});}})[_0x0499('0x26')](respondWithStatusCode(_0x17f760,null))[_0x0499('0x4e')](handleError(_0x17f760,null));};exports[_0x0499('0x7c')]=function(_0x415819,_0x4a8721,_0x450d45){return db[_0x0499('0x67')][_0x0499('0x4c')]({'where':{'id':_0x415819[_0x0499('0x3a')]['ids']},'attributes':['id'],'include':[{'model':db[_0x0499('0x6a')],'as':_0x0499('0x6b'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x4a8721,null))[_0x0499('0x26')](function(_0x5e95c7){var _0x586662=_[_0x0499('0x2e')](_0x5e95c7,'id');var _0x131991=[];var _0x218efc=[];var _0x302b81=squel[_0x0499('0x7d')]();_0x302b81[_0x0499('0x7e')](_0x0499('0x7f'))[_0x0499('0x80')](_0x0499('0x81'),'tq')['join'](_0x0499('0x82'),'ut',_0x0499('0x83'))['where'](_0x0499('0x84'),_0x415819[_0x0499('0x50')]['id']);for(var _0x51e90c=0x0;_0x51e90c<_0x5e95c7[_0x0499('0x3f')];_0x51e90c+=0x1){let _0x3adf79=_0x5e95c7[_0x51e90c];for(var _0x30474c=0x0;_0x30474c<_0x3adf79['Agents'][_0x0499('0x3f')];_0x30474c+=0x1){let _0x24f44c=_0x3adf79[_0x0499('0x6b')][_0x30474c];var _0xf24a46=_0x302b81[_0x0499('0x85')]();_0xf24a46['where'](_0x0499('0x86'),_0x24f44c['id']);_0x218efc[_0x0499('0x87')](db[_0x0499('0x70')]['query'](_0xf24a46[_0x0499('0x88')](),{'type':db[_0x0499('0x70')][_0x0499('0x89')][_0x0499('0x8a')]})[_0x0499('0x26')](function(_0x3ac1a0){if(_0x3ac1a0['length']===0x1){return _0x24f44c['id'];}else{var _0x39e65f=_[_0x0499('0x8b')](_[_0x0499('0x2e')](_0x3ac1a0,_0x0499('0x8c')),function(_0x229138){return _[_0x0499('0x8d')](_0x586662,_0x229138);});if(_0x39e65f){return _0x24f44c['id'];}}}));}}return BPromise[_0x0499('0x8e')](_0x218efc)[_0x0499('0x26')](function(_0xfe1edd){_0x131991=_(_0x131991)[_0x0499('0x8f')](_0xfe1edd)[_0x0499('0x90')]()[_0x0499('0x2f')]();return db['VoiceQueue']['find']({'where':{'id':_0x415819[_0x0499('0x50')]['id']}})[_0x0499('0x26')](function(_0x292a81){return db[_0x0499('0x70')]['transaction'](function(_0x2b2d5f){return _0x292a81[_0x0499('0x7c')](_0x415819[_0x0499('0x3a')][_0x0499('0x91')],{'transaction':_0x2b2d5f})['then'](function(){if(!_[_0x0499('0x92')](_0x131991)){return _0x292a81[_0x0499('0x93')](_0x131991,{'transaction':_0x2b2d5f})['then'](function(){return db[_0x0499('0x77')][_0x0499('0x25')]({'where':{'VoiceQueueId':_0x415819['params']['id'],'UserId':_0x131991},'transaction':_0x2b2d5f});});}})[_0x0499('0x26')](function(){_0x131991[_0x0499('0x6e')](function(_0xf37b65){socket[_0x0499('0x7a')](_0x0499('0x94'),{'UserId':_0xf37b65,'VoiceQueueId':_0x292a81['id']});});});});});});})[_0x0499('0x26')](respondWithStatusCode(_0x4a8721,null))[_0x0499('0x4e')](handleError(_0x4a8721,null));};exports[_0x0499('0x95')]=function(_0x4d1eaf,_0x2cc21f,_0x51ba59){var _0x5c4052,_0x143722;return db[_0x0499('0x4a')][_0x0499('0x31')]({'where':{'id':_0x4d1eaf[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x2cc21f,null))[_0x0499('0x26')](function(_0x5b924e){if(_0x5b924e){_0x143722=_0x5b924e;return _0x5b924e['addAgents'](_0x4d1eaf[_0x0499('0x54')][_0x0499('0x91')],_[_0x0499('0x59')](_0x4d1eaf[_0x0499('0x54')],['ids','id'])||{})[_0x0499('0x96')](function(_0x37d450){for(var _0x45cc16=0x0;_0x45cc16<_0x4d1eaf[_0x0499('0x54')][_0x0499('0x91')][_0x0499('0x3f')];_0x45cc16+=0x1){socket['emit'](_0x0499('0x7b'),{'UserId':_0x4d1eaf[_0x0499('0x54')][_0x0499('0x91')][_0x45cc16],'VoiceQueueId':_0x4d1eaf[_0x0499('0x50')]['id']});}return _0x37d450;});}})[_0x0499('0x26')](function(_0x370642){_0x5c4052=_0x370642||[];if(_0x143722){return db['User']['findAll']({'where':{'id':_0x4d1eaf[_0x0499('0x54')][_0x0499('0x91')]},'attributes':['id',_0x0499('0x32'),'online','voicePause',_0x0499('0x6c')],'raw':!![]});}})[_0x0499('0x26')](function(_0x57fe5a){if(!_[_0x0499('0x92')](_0x57fe5a)){var _0x224407=[];for(var _0x5d83da=0x0;_0x5d83da<_0x57fe5a[_0x0499('0x3f')];_0x5d83da++){if(_0x57fe5a[_0x5d83da]['online']){_0x224407[_0x0499('0x87')](db[_0x0499('0x77')]['upsert']({'membername':_0x57fe5a[_0x5d83da][_0x0499('0x32')],'UserId':_0x57fe5a[_0x5d83da]['id'],'queue_name':_0x143722['name'],'VoiceQueueId':_0x143722['id'],'interface':_[_0x0499('0x78')](_0x57fe5a[_0x5d83da][_0x0499('0x6c')])?util['format']('SIP/%s',_0x57fe5a[_0x5d83da][_0x0499('0x32')]):_0x57fe5a[_0x5d83da][_0x0499('0x6c')],'paused':_0x57fe5a[_0x5d83da][_0x0499('0x97')]||![],'penalty':_0x4d1eaf['body'][_0x0499('0x6f')]||0x0}));}}return BPromise[_0x0499('0x8e')](_0x224407);}})[_0x0499('0x26')](function(){return _0x5c4052;})[_0x0499('0x26')](respondWithResult(_0x2cc21f,null))[_0x0499('0x4e')](handleError(_0x2cc21f,null));};exports[_0x0499('0x93')]=function(_0x10ab62,_0x35b939,_0x2ae991){return db[_0x0499('0x4a')][_0x0499('0x31')]({'where':{'id':_0x10ab62['params']['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x35b939,null))['then'](function(_0x4590a4){if(_0x4590a4){return _0x4590a4[_0x0499('0x93')](_0x10ab62['query']['ids'])[_0x0499('0x26')](function(){if(_[_0x0499('0x98')](_0x10ab62['query'][_0x0499('0x91')])){for(var _0x5d481a=0x0;_0x5d481a<_0x10ab62[_0x0499('0x3a')][_0x0499('0x91')]['length'];_0x5d481a+=0x1){socket[_0x0499('0x7a')](_0x0499('0x94'),{'UserId':Number(_0x10ab62[_0x0499('0x3a')]['ids'][_0x5d481a]),'VoiceQueueId':Number(_0x10ab62[_0x0499('0x50')]['id'])});}}else{socket[_0x0499('0x7a')]('userVoiceQueue:remove',{'UserId':Number(_0x10ab62[_0x0499('0x3a')][_0x0499('0x91')]),'VoiceQueueId':Number(_0x10ab62['params']['id'])});}});}})[_0x0499('0x26')](function(_0x3ccede){return db[_0x0499('0x77')][_0x0499('0x25')]({'where':{'VoiceQueueId':_0x10ab62[_0x0499('0x50')]['id'],'UserId':_0x10ab62['query'][_0x0499('0x91')]}})[_0x0499('0x26')](function(){return _0x3ccede;});})[_0x0499('0x26')](respondWithStatusCode(_0x35b939,null))[_0x0499('0x4e')](handleError(_0x35b939,null));};exports[_0x0499('0x99')]=function(_0xa44d0e,_0x29735f,_0x849a52){var _0x41c2a2={};var _0x39ff64={};var _0x2e4e50;var _0x1a4a14;return db[_0x0499('0x4a')][_0x0499('0x60')]({'where':{'id':_0xa44d0e[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x29735f,null))[_0x0499('0x26')](function(_0x15dd1b){if(_0x15dd1b){_0x2e4e50=_0x15dd1b;_0x39ff64[_0x0499('0x38')]=_['keys'](db[_0x0499('0x6a')][_0x0499('0x36')]);_0x39ff64['query']=_['keys'](_0xa44d0e[_0x0499('0x3a')]);_0x39ff64[_0x0499('0x3b')]=_['intersection'](_0x39ff64[_0x0499('0x38')],_0x39ff64[_0x0499('0x3a')]);_0x41c2a2[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x39ff64['model'],qs[_0x0499('0x3d')](_0xa44d0e[_0x0499('0x3a')]['fields']));_0x41c2a2[_0x0499('0x3e')]=_0x41c2a2[_0x0499('0x3e')][_0x0499('0x3f')]?_0x41c2a2[_0x0499('0x3e')]:_0x39ff64[_0x0499('0x38')];_0x41c2a2[_0x0499('0x44')]=qs[_0x0499('0x45')](_0xa44d0e[_0x0499('0x3a')]['sort']);_0x41c2a2['where']=qs['filters'](_[_0x0499('0x47')](_0xa44d0e[_0x0499('0x3a')],_0x39ff64[_0x0499('0x3b')]));if(_0xa44d0e['query']['filter']){_0x41c2a2['where']=_[_0x0499('0x48')](_0x41c2a2[_0x0499('0x46')],{'$or':_['map'](_0x41c2a2['attributes'],function(_0x1a3dfd){var _0x13a072={};_0x13a072[_0x1a3dfd]={'$like':'%'+_0xa44d0e[_0x0499('0x3a')][_0x0499('0x2c')]+'%'};return _0x13a072;})});}_0x41c2a2=_[_0x0499('0x48')]({},_0x41c2a2,_0xa44d0e[_0x0499('0x52')]);return _0x2e4e50[_0x0499('0x99')](_0x41c2a2);}})[_0x0499('0x26')](function(_0x51eba1){if(_0x51eba1){_0x1a4a14=_0x51eba1['length'];if(!_0xa44d0e[_0x0499('0x3a')][_0x0499('0x40')]('nolimit')){_0x41c2a2['limit']=qs[_0x0499('0x42')](_0xa44d0e[_0x0499('0x3a')][_0x0499('0x42')]);_0x41c2a2[_0x0499('0x43')]=qs[_0x0499('0x43')](_0xa44d0e[_0x0499('0x3a')][_0x0499('0x43')]);}return _0x2e4e50['getAgents'](_0x41c2a2);}})[_0x0499('0x26')](function(_0x3cfd29){if(_0x3cfd29){return _0x3cfd29?{'count':_0x1a4a14,'rows':_0x3cfd29}:null;}})[_0x0499('0x26')](respondWithResult(_0x29735f,null))[_0x0499('0x4e')](handleError(_0x29735f,null));};exports[_0x0499('0x9a')]=function(_0x52816a,_0x473cf3,_0x293ded){var _0x542fb5={};var _0x266aab={};var _0x2e3680;var _0x5d9b61;return db['VoiceQueue'][_0x0499('0x60')]({'where':{'id':_0x52816a[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x473cf3,null))[_0x0499('0x26')](function(_0x961448){if(_0x961448){_0x2e3680=_0x961448;_0x266aab['model']=_[_0x0499('0x39')](db['UserVoiceQueueRt'][_0x0499('0x36')]);_0x266aab[_0x0499('0x3a')]=_['keys'](_0x52816a[_0x0499('0x3a')]);_0x266aab[_0x0499('0x3b')]=_[_0x0499('0x3c')](_0x266aab['model'],_0x266aab[_0x0499('0x3a')]);_0x542fb5[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x266aab[_0x0499('0x38')],qs[_0x0499('0x3d')](_0x52816a[_0x0499('0x3a')][_0x0499('0x3d')]));_0x542fb5[_0x0499('0x3e')]=_0x542fb5[_0x0499('0x3e')]['length']?_0x542fb5['attributes']:_0x266aab['model'];_0x542fb5[_0x0499('0x44')]=qs[_0x0499('0x45')](_0x52816a['query'][_0x0499('0x45')]);_0x542fb5[_0x0499('0x46')]=qs['filters'](_[_0x0499('0x47')](_0x52816a['query'],_0x266aab['filters']));if(_0x52816a[_0x0499('0x3a')]['filter']){_0x542fb5['where']=_[_0x0499('0x48')](_0x542fb5[_0x0499('0x46')],{'$or':_[_0x0499('0x2e')](_0x542fb5[_0x0499('0x3e')],function(_0x113063){var _0x46066f={};_0x46066f[_0x113063]={'$like':'%'+_0x52816a[_0x0499('0x3a')]['filter']+'%'};return _0x46066f;})});}_0x542fb5=_[_0x0499('0x48')]({},_0x542fb5,_0x52816a[_0x0499('0x52')]);return _0x2e3680[_0x0499('0x9a')](_0x542fb5);}})[_0x0499('0x26')](function(_0x58b51e){if(_0x58b51e){_0x5d9b61=_0x58b51e[_0x0499('0x3f')];if(!_0x52816a[_0x0499('0x3a')][_0x0499('0x40')](_0x0499('0x41'))){_0x542fb5[_0x0499('0x42')]=qs['limit'](_0x52816a[_0x0499('0x3a')][_0x0499('0x42')]);_0x542fb5[_0x0499('0x43')]=qs[_0x0499('0x43')](_0x52816a[_0x0499('0x3a')][_0x0499('0x43')]);}return _0x2e3680[_0x0499('0x9a')](_0x542fb5);}})[_0x0499('0x26')](function(_0xeb3e16){return _0xeb3e16?{'count':_0x5d9b61,'rows':_0xeb3e16}:null;})['then'](respondWithResult(_0x473cf3,null))['catch'](handleError(_0x473cf3,null));};exports[_0x0499('0x9b')]=function(_0xa64028,_0x1a560c,_0xd6af9d){var _0x469478={};var _0x42ee3f={};var _0x2125c4;var _0x2d98f0;return db[_0x0499('0x4a')][_0x0499('0x60')]({'where':{'id':_0xa64028[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x1a560c,null))['then'](function(_0x1aff74){if(_0x1aff74){_0x2125c4=_0x1aff74;_0x42ee3f[_0x0499('0x38')]=_[_0x0499('0x39')](db[_0x0499('0x9c')][_0x0499('0x36')]);_0x42ee3f[_0x0499('0x3a')]=_['keys'](_0xa64028[_0x0499('0x3a')]);_0x42ee3f[_0x0499('0x3b')]=_['intersection'](_0x42ee3f[_0x0499('0x38')],_0x42ee3f[_0x0499('0x3a')]);_0x469478[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x42ee3f[_0x0499('0x38')],qs[_0x0499('0x3d')](_0xa64028[_0x0499('0x3a')][_0x0499('0x3d')]));_0x469478[_0x0499('0x3e')]=_0x469478[_0x0499('0x3e')][_0x0499('0x3f')]?_0x469478[_0x0499('0x3e')]:_0x42ee3f[_0x0499('0x38')];_0x469478['order']=qs['sort'](_0xa64028['query']['sort']);_0x469478['where']=qs[_0x0499('0x3b')](_[_0x0499('0x47')](_0xa64028[_0x0499('0x3a')],_0x42ee3f[_0x0499('0x3b')]));if(_0xa64028[_0x0499('0x3a')][_0x0499('0x2c')]){_0x469478[_0x0499('0x46')]=_[_0x0499('0x48')](_0x469478['where'],{'$or':_[_0x0499('0x2e')](_0x469478[_0x0499('0x3e')],function(_0x397dab){var _0x4aa6ac={};_0x4aa6ac[_0x397dab]={'$like':'%'+_0xa64028[_0x0499('0x3a')]['filter']+'%'};return _0x4aa6ac;})});}_0x469478=_[_0x0499('0x48')]({},_0x469478,_0xa64028[_0x0499('0x52')]);return _0x2125c4[_0x0499('0x9b')](_0x469478);}})[_0x0499('0x26')](function(_0x2e07a9){if(_0x2e07a9){_0x2d98f0=_0x2e07a9[_0x0499('0x3f')];if(!_0xa64028[_0x0499('0x3a')][_0x0499('0x40')](_0x0499('0x41'))){_0x469478[_0x0499('0x42')]=qs[_0x0499('0x42')](_0xa64028[_0x0499('0x3a')][_0x0499('0x42')]);_0x469478[_0x0499('0x43')]=qs[_0x0499('0x43')](_0xa64028[_0x0499('0x3a')][_0x0499('0x43')]);}return _0x2125c4['getLists'](_0x469478);}})[_0x0499('0x26')](function(_0x1ba578){if(_0x1ba578){return _0x1ba578?{'count':_0x2d98f0,'rows':_0x1ba578}:null;}})['then'](respondWithResult(_0x1a560c,null))[_0x0499('0x4e')](handleError(_0x1a560c,null));};exports[_0x0499('0x9d')]=function(_0x56e968,_0xad1109,_0x5c502c){var _0x132557,_0x5792b5;return db[_0x0499('0x4a')][_0x0499('0x31')]({'where':{'id':_0x56e968[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0xad1109,null))['then'](function(_0x5b0ba5){if(_0x5b0ba5){_0x5792b5=_0x5b0ba5;return _0x5b0ba5[_0x0499('0x9d')](_0x56e968['body'][_0x0499('0x91')],_[_0x0499('0x59')](_0x56e968['body'],[_0x0499('0x91'),'id'])||{});}return null;})[_0x0499('0x96')](function(_0x649509){var _0x454f0c;_0x132557=_0x649509||[];var _0x3c87de=[];if(_0x649509){for(var _0x24f44f=0x0;_0x24f44f<_0x649509['length'];_0x24f44f+=0x1){var _0x4d9dbf=_0x649509[_0x24f44f][_0x0499('0x27')]({'plain':!![]});_0x5792b5[_0x0499('0x9e')]=_0x56e968[_0x0499('0x54')][_0x0499('0x9e')]?_0x56e968[_0x0499('0x54')][_0x0499('0x9e')]:_0x5792b5[_0x0499('0x9e')];switch(_0x5792b5[_0x0499('0x9e')]){case'always':_0x454f0c=squel['insert']()['into']('cm_hopper')[_0x0499('0x9f')]([_0x0499('0xa0'),_0x0499('0xa1'),'ContactId',_0x0499('0xa2'),_0x0499('0x62'),_0x0499('0x5a'),_0x0499('0x5b')],squel[_0x0499('0x7d')]()[_0x0499('0x7e')](_0x0499('0xa0'),'phone')['field'](_0x0499('0xa3'),_0x0499('0xa1'))['field']('id',_0x0499('0xa4'))['field'](_0x4d9dbf[_0x0499('0xa5')][_0x0499('0x88')](),_0x0499('0xa2'))[_0x0499('0x7e')](_0x56e968[_0x0499('0x50')]['id'][_0x0499('0x88')](),'VoiceQueueId')['field']('NOW()',_0x0499('0x5a'))[_0x0499('0x7e')]('NOW()',_0x0499('0x5b'))[_0x0499('0x80')]('cm_contacts')['where'](_0x0499('0xa6'))[_0x0499('0x46')](_0x0499('0xa7'),_0x4d9dbf[_0x0499('0xa5')]['toString']())[_0x0499('0x46')]('phone\x20IS\x20NOT\x20NULL')['where'](_0x0499('0xa8'),squel[_0x0499('0x7d')]()['field']('COALESCE(calleridnum,\x27\x27)')['from'](_0x0499('0xa9'))[_0x0499('0x46')](_0x0499('0x84'),_0x56e968['params']['id'][_0x0499('0x88')]()))[_0x0499('0x46')](_0x0499('0xa8'),squel[_0x0499('0x7d')]()[_0x0499('0x7e')]('COALESCE(phone,\x27\x27)')['from'](_0x0499('0xaa'))[_0x0499('0x46')](_0x0499('0x84'),_0x56e968['params']['id'][_0x0499('0x88')]())))[_0x0499('0x88')]();break;case _0x0499('0xab'):_0x454f0c=squel[_0x0499('0xac')]()[_0x0499('0xad')](_0x0499('0xaa'))[_0x0499('0x9f')]([_0x0499('0xa0'),_0x0499('0xa1'),_0x0499('0xa4'),_0x0499('0xa2'),_0x0499('0x62'),'createdAt','updatedAt'],squel[_0x0499('0x7d')]()[_0x0499('0x7e')](_0x0499('0xa0'),'phone')[_0x0499('0x7e')](_0x0499('0xa3'),_0x0499('0xa1'))[_0x0499('0x7e')]('id',_0x0499('0xa4'))['field'](_0x4d9dbf['CmListId'][_0x0499('0x88')](),_0x0499('0xa2'))[_0x0499('0x7e')](_0x56e968['params']['id']['toString'](),_0x0499('0x62'))[_0x0499('0x7e')](_0x0499('0xa3'),_0x0499('0x5a'))[_0x0499('0x7e')](_0x0499('0xa3'),_0x0499('0x5b'))[_0x0499('0x80')](_0x0499('0xae'))['where'](_0x0499('0xa6'))[_0x0499('0x46')](_0x0499('0xa7'),_0x4d9dbf[_0x0499('0xa5')][_0x0499('0x88')]())[_0x0499('0x46')](_0x0499('0xaf'))[_0x0499('0x46')](_0x0499('0xa8'),squel[_0x0499('0x7d')]()[_0x0499('0x7e')](_0x0499('0xb0'))[_0x0499('0x80')](_0x0499('0xaa'))[_0x0499('0x46')](_0x0499('0x84'),_0x56e968[_0x0499('0x50')]['id']['toString']())))[_0x0499('0x88')]();break;default:_0x454f0c=squel[_0x0499('0xac')]()[_0x0499('0xad')]('cm_hopper')[_0x0499('0x9f')]([_0x0499('0xa0'),_0x0499('0xa1'),_0x0499('0xa4'),'ListId','VoiceQueueId',_0x0499('0x5a'),_0x0499('0x5b')],squel[_0x0499('0x7d')]()[_0x0499('0x7e')](_0x0499('0xa0'),_0x0499('0xa0'))[_0x0499('0x7e')](_0x0499('0xa3'),_0x0499('0xa1'))[_0x0499('0x7e')]('id',_0x0499('0xa4'))[_0x0499('0x7e')](_0x4d9dbf[_0x0499('0xa5')][_0x0499('0x88')](),'ListId')[_0x0499('0x7e')](_0x56e968[_0x0499('0x50')]['id'][_0x0499('0x88')](),_0x0499('0x62'))['field']('NOW()','createdAt')[_0x0499('0x7e')](_0x0499('0xa3'),_0x0499('0x5b'))[_0x0499('0x80')]('cm_contacts')[_0x0499('0x46')](_0x0499('0xa6'))[_0x0499('0x46')](_0x0499('0xa7'),_0x4d9dbf[_0x0499('0xa5')][_0x0499('0x88')]())[_0x0499('0x46')]('phone\x20IS\x20NOT\x20NULL'))[_0x0499('0x88')]();}_0x3c87de[_0x0499('0x87')](db[_0x0499('0x70')]['query'](_0x454f0c));}return BPromise['all'](_0x3c87de);}})[_0x0499('0x26')](function(){return _0x132557;})[_0x0499('0x26')](respondWithResult(_0xad1109,null))['catch'](handleError(_0xad1109,null));};exports[_0x0499('0xb1')]=function(_0x18c67a,_0x2d797b,_0x1bc708){return db[_0x0499('0x4a')][_0x0499('0x31')]({'where':{'id':_0x18c67a[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x2d797b,null))[_0x0499('0x26')](function(_0x882f0d){if(_0x882f0d){return _0x882f0d[_0x0499('0xb1')](_0x18c67a['query'][_0x0499('0x91')]);}})['then'](function(_0x33ecd7){if(_0x33ecd7){return db[_0x0499('0x61')]['destroy']({'where':{'ListId':_0x18c67a['query'][_0x0499('0x91')],'VoiceQueueId':_0x18c67a[_0x0499('0x50')]['id']}})[_0x0499('0x26')](function(){return _0x33ecd7;});}})['then'](respondWithStatusCode(_0x2d797b,null))['catch'](handleError(_0x2d797b,null));};exports[_0x0499('0xb2')]=function(_0x4bec1a,_0x203019,_0x3c6d22){var _0x49809f={};var _0x426f87={};var _0x55e54c;var _0x4de74e;return db[_0x0499('0x4a')]['findOne']({'where':{'id':_0x4bec1a[_0x0499('0x50')]['id']}})['then'](handleEntityNotFound(_0x203019,null))[_0x0499('0x26')](function(_0x50d878){if(_0x50d878){_0x55e54c=_0x50d878;_0x426f87[_0x0499('0x38')]=_[_0x0499('0x39')](db[_0x0499('0x9c')][_0x0499('0x36')]);_0x426f87['query']=_['keys'](_0x4bec1a[_0x0499('0x3a')]);_0x426f87[_0x0499('0x3b')]=_[_0x0499('0x3c')](_0x426f87[_0x0499('0x38')],_0x426f87[_0x0499('0x3a')]);_0x49809f[_0x0499('0x3e')]=_[_0x0499('0x3c')](_0x426f87[_0x0499('0x38')],qs[_0x0499('0x3d')](_0x4bec1a['query'][_0x0499('0x3d')]));_0x49809f[_0x0499('0x3e')]=_0x49809f['attributes'][_0x0499('0x3f')]?_0x49809f[_0x0499('0x3e')]:_0x426f87[_0x0499('0x38')];_0x49809f[_0x0499('0x44')]=qs[_0x0499('0x45')](_0x4bec1a['query'][_0x0499('0x45')]);_0x49809f[_0x0499('0x46')]=qs[_0x0499('0x3b')](_[_0x0499('0x47')](_0x4bec1a[_0x0499('0x3a')],_0x426f87[_0x0499('0x3b')]));if(_0x4bec1a[_0x0499('0x3a')][_0x0499('0x2c')]){_0x49809f[_0x0499('0x46')]=_[_0x0499('0x48')](_0x49809f[_0x0499('0x46')],{'$or':_[_0x0499('0x2e')](_0x49809f[_0x0499('0x3e')],function(_0x542164){var _0x5b3099={};_0x5b3099[_0x542164]={'$like':'%'+_0x4bec1a[_0x0499('0x3a')][_0x0499('0x2c')]+'%'};return _0x5b3099;})});}_0x49809f=_[_0x0499('0x48')]({},_0x49809f,_0x4bec1a[_0x0499('0x52')]);return _0x55e54c[_0x0499('0xb2')](_0x49809f);}})[_0x0499('0x26')](function(_0x344697){if(_0x344697){_0x4de74e=_0x344697[_0x0499('0x3f')];if(!_0x4bec1a[_0x0499('0x3a')][_0x0499('0x40')](_0x0499('0x41'))){_0x49809f[_0x0499('0x42')]=qs['limit'](_0x4bec1a[_0x0499('0x3a')][_0x0499('0x42')]);_0x49809f[_0x0499('0x43')]=qs[_0x0499('0x43')](_0x4bec1a[_0x0499('0x3a')][_0x0499('0x43')]);}return _0x55e54c[_0x0499('0xb2')](_0x49809f);}})['then'](function(_0x5c6217){if(_0x5c6217){return _0x5c6217?{'count':_0x4de74e,'rows':_0x5c6217}:null;}})['then'](respondWithResult(_0x203019,null))[_0x0499('0x4e')](handleError(_0x203019,null));};exports[_0x0499('0xb3')]=function(_0x2fce7d,_0x441b0c,_0x1d2e43){var _0x31734,_0x228d94;return db[_0x0499('0x4a')][_0x0499('0x31')]({'where':{'id':_0x2fce7d[_0x0499('0x50')]['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x441b0c,null))[_0x0499('0x26')](function(_0x5b5c33){if(_0x5b5c33){_0x228d94=_0x5b5c33;return _0x5b5c33['addBlackLists'](_0x2fce7d['body']['ids'],_[_0x0499('0x59')](_0x2fce7d[_0x0499('0x54')],[_0x0499('0x91'),'id'])||{});}return null;})[_0x0499('0x96')](function(_0x5b0644){var _0x819386;_0x31734=_0x5b0644||[];var _0x3c5eb4=[];if(_0x5b0644){for(var _0x183f4b=0x0;_0x183f4b<_0x5b0644['length'];_0x183f4b+=0x1){var _0x3f7fd6=_0x5b0644[_0x183f4b][_0x0499('0x27')]({'plain':!![]});_0x819386=squel['insert']()['into'](_0x0499('0xb4'))['fromQuery']([_0x0499('0xa0'),_0x0499('0xa4'),_0x0499('0xa2'),_0x0499('0x62'),_0x0499('0x5a'),_0x0499('0x5b')],squel[_0x0499('0x7d')]()[_0x0499('0x7e')](_0x0499('0xa0'),_0x0499('0xa0'))[_0x0499('0x7e')]('id','ContactId')['field'](_0x3f7fd6[_0x0499('0xa5')][_0x0499('0x88')](),'ListId')[_0x0499('0x7e')](_0x2fce7d[_0x0499('0x50')]['id'][_0x0499('0x88')](),_0x0499('0x62'))[_0x0499('0x7e')](_0x0499('0xa3'),_0x0499('0x5a'))[_0x0499('0x7e')]('NOW()','updatedAt')[_0x0499('0x80')]('cm_contacts')[_0x0499('0x46')](_0x0499('0xa6'))['where'](_0x0499('0xa7'),_0x3f7fd6[_0x0499('0xa5')][_0x0499('0x88')]())[_0x0499('0x46')](_0x0499('0xaf')))[_0x0499('0x88')]();_0x3c5eb4[_0x0499('0x87')](db['sequelize']['query'](_0x819386));}return BPromise[_0x0499('0x8e')](_0x3c5eb4);}})[_0x0499('0x26')](function(){return _0x31734;})['then'](respondWithResult(_0x441b0c,null))[_0x0499('0x4e')](handleError(_0x441b0c,null));};exports['removeBlackLists']=function(_0x168395,_0x2fbbec,_0x1a2048){return db[_0x0499('0x4a')][_0x0499('0x31')]({'where':{'id':_0x168395['params']['id']}})[_0x0499('0x26')](handleEntityNotFound(_0x2fbbec,null))[_0x0499('0x26')](function(_0x33a041){if(_0x33a041){return _0x33a041[_0x0499('0xb5')](_0x168395[_0x0499('0x3a')][_0x0499('0x91')]);}})[_0x0499('0x26')](function(_0x5ea9d4){if(_0x5ea9d4){return db['CmHopperBlack'][_0x0499('0x25')]({'where':{'ListId':_0x168395[_0x0499('0x3a')][_0x0499('0x91')],'VoiceQueueId':_0x168395['params']['id']}})[_0x0499('0x26')](function(){return _0x5ea9d4;});}})[_0x0499('0x26')](respondWithStatusCode(_0x2fbbec,null))['catch'](handleError(_0x2fbbec,null));};
\ No newline at end of file
+var _0x00bb=['query','filters','intersection','attributes','fields','length','merge','options','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','VoiceQueues','QueueCampaigns','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','role','getHoppers','hasOwnProperty','nolimit','sort','VoiceQueueId','CmHopper','includeAll','findAll','CmHopperHistory','order','pick','getHopperFinals','findOne','CmHopperFinal','CmHopperBlack','getTeams','Team','addTeams','online','voicePause','interface','Agents','forEach','penalty','sequelize','transaction','each','upsert','UserVoiceQueue','UserVoiceQueueRt','SIP/%s','emit','userVoiceQueue:save','ids','User','field','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','toString','QueryTypes','every','all','union','compact','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','isNil','format','isArray','getAgents','getMembers','getLists','CmList','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','phone','ContactId','ListId','select','scheduledAt','CmListId','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','onlyIfOpen','push','CmHopperId','OrderBy','ci.item','ci.OrderBy+1','cm_contact_has_items','h.ContactId=ci.CmContactId','h.scheduledat=?','PHONE','removeLists','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','moment','bluebird','util','squel','../../components/parsers/qs','../../config/logger','../../config/environment','../../mysqldb','localhost','socket.io-emitter','redis','./voiceQueue.socket','register','sendStatus','status','end','offset','undefined','limit','count','Content-Range','json','then','destroy','get','inbound','outbound','filter','ignore','value','includes','type','find','name','UserProfileResource','error','stack','send','index','map','rawAttributes','fieldName','key','getOptions','where','VoiceQueue','include','rows','catch','show','params','model','keys'];(function(_0x457b74,_0xecd07a){var _0x38e079=function(_0x405da9){while(--_0x405da9){_0x457b74['push'](_0x457b74['shift']());}};_0x38e079(++_0xecd07a);}(_0x00bb,0x1d8));var _0xb00b=function(_0x56482c,_0x16118d){_0x56482c=_0x56482c-0x0;var _0x5aae7a=_0x00bb[_0x56482c];return _0x5aae7a;};'use strict';var moment=require(_0xb00b('0x0'));var BPromise=require(_0xb00b('0x1'));var util=require(_0xb00b('0x2'));var _=require('lodash');var squel=require(_0xb00b('0x3'));var Redis=require('ioredis');var qs=require(_0xb00b('0x4'));var logger=require(_0xb00b('0x5'))('api');var config=require(_0xb00b('0x6'));var db=require(_0xb00b('0x7'))['db'];config['redis']=_['defaults'](config['redis'],{'host':_0xb00b('0x8'),'port':0x18eb});var socket=require(_0xb00b('0x9'))(new Redis(config[_0xb00b('0xa')]));require(_0xb00b('0xb'))[_0xb00b('0xc')](socket);function respondWithStatusCode(_0x3c36c5,_0x5b0c03){_0x5b0c03=_0x5b0c03||0xcc;return function(_0x51d12b){if(_0x51d12b){return _0x3c36c5[_0xb00b('0xd')](_0x5b0c03);}return _0x3c36c5[_0xb00b('0xe')](_0x5b0c03)[_0xb00b('0xf')]();};}function respondWithResult(_0x46a25c,_0x28d3cc){_0x28d3cc=_0x28d3cc||0xc8;return function(_0x48e125){if(_0x48e125){return _0x46a25c[_0xb00b('0xe')](_0x28d3cc)['json'](_0x48e125);}};}function respondWithFilteredResult(_0x5a4fea,_0x594075){return function(_0x4ff792){if(_0x4ff792){var _0x2d8ddf=typeof _0x594075[_0xb00b('0x10')]===_0xb00b('0x11')&&typeof _0x594075[_0xb00b('0x12')]===_0xb00b('0x11');var _0x4ada81=_0x4ff792[_0xb00b('0x13')];var _0xb0d42e=_0x2d8ddf?0x0:_0x594075['offset'];var _0x88d95e=_0x2d8ddf?_0x4ff792[_0xb00b('0x13')]:_0x594075['offset']+_0x594075['limit'];var _0x9b471e;if(_0x88d95e>=_0x4ada81){_0x88d95e=_0x4ada81;_0x9b471e=0xc8;}else{_0x9b471e=0xce;}_0x5a4fea['status'](_0x9b471e);return _0x5a4fea['set'](_0xb00b('0x14'),_0xb0d42e+'-'+_0x88d95e+'/'+_0x4ada81)[_0xb00b('0x15')](_0x4ff792);}return null;};}function saveUpdates(_0x387d97){return function(_0xbb72fc){if(_0xbb72fc){return _0xbb72fc['update'](_0x387d97)[_0xb00b('0x16')](function(_0x599347){return _0x599347;});}return null;};}function removeEntity(_0x415f91){return function(_0x5aa9a0){if(_0x5aa9a0){return _0x5aa9a0[_0xb00b('0x17')]()['then'](function(){var _0xb26ebb=_0x5aa9a0[_0xb00b('0x18')]({'plain':!![]});var _0x53ee68=[{'name':'VoiceQueues','value':_0xb00b('0x19'),'ignore':![]},{'name':'QueueCampaigns','value':_0xb00b('0x1a'),'ignore':![]}];var _0x43da66=_(_0x53ee68)[_0xb00b('0x1b')](_0xb00b('0x1c'))['map'](_0xb00b('0x1d'))['value']();if(_[_0xb00b('0x1e')](_0x43da66,_0xb26ebb[_0xb00b('0x1f')])){return;}var _0x51b841=_[_0xb00b('0x20')](_0x53ee68,[_0xb00b('0x1d'),_0xb26ebb['type']])[_0xb00b('0x21')];return db[_0xb00b('0x22')]['destroy']({'where':{'type':_0x51b841,'resourceId':_0xb26ebb['id']}})[_0xb00b('0x16')](function(){return _0x5aa9a0;});})[_0xb00b('0x16')](function(){_0x415f91[_0xb00b('0xe')](0xcc)[_0xb00b('0xf')]();});}};}function handleEntityNotFound(_0x520e55){return function(_0x50be6c){if(!_0x50be6c){_0x520e55[_0xb00b('0xd')](0x194);}return _0x50be6c;};}function handleError(_0x490380,_0x550587){_0x550587=_0x550587||0x1f4;return function(_0x4a635e){logger[_0xb00b('0x23')](_0x4a635e[_0xb00b('0x24')]);if(_0x4a635e[_0xb00b('0x21')]){delete _0x4a635e[_0xb00b('0x21')];}_0x490380[_0xb00b('0xe')](_0x550587)[_0xb00b('0x25')](_0x4a635e);};}exports[_0xb00b('0x26')]=function(_0x4a8d2b,_0x22c22d){var _0x503c9c={};var _0x450129={'count':0x0,'rows':[]};var _0x348165=_[_0xb00b('0x27')](db['VoiceQueue'][_0xb00b('0x28')],function(_0x280ed3){return{'name':_0x280ed3[_0xb00b('0x29')],'type':_0x280ed3[_0xb00b('0x1f')][_0xb00b('0x2a')]};});_0x503c9c=qs[_0xb00b('0x2b')](_0x348165,_0x4a8d2b);var _0x2e160a={'where':_0x503c9c[_0xb00b('0x2c')]};return db[_0xb00b('0x2d')]['count'](_0x2e160a)[_0xb00b('0x16')](function(_0x44918d){_0x450129['count']=_0x44918d;_0x503c9c[_0xb00b('0x2e')]=qs[_0xb00b('0x2e')](_0x4a8d2b['query']);return db[_0xb00b('0x2d')]['findAll'](_0x503c9c);})[_0xb00b('0x16')](function(_0x4117f2){_0x450129[_0xb00b('0x2f')]=_0x4117f2;return _0x450129;})[_0xb00b('0x16')](respondWithFilteredResult(_0x22c22d,_0x503c9c))[_0xb00b('0x30')](handleError(_0x22c22d,null));};exports[_0xb00b('0x31')]=function(_0x17f613,_0x594840){var _0x57e8f9={'raw':![],'where':{'id':_0x17f613[_0xb00b('0x32')]['id']}},_0x5b04c2={};_0x5b04c2[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x2d')]['rawAttributes']);_0x5b04c2[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x17f613[_0xb00b('0x35')]);_0x5b04c2[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x5b04c2[_0xb00b('0x33')],_0x5b04c2[_0xb00b('0x35')]);_0x57e8f9[_0xb00b('0x38')]=_['intersection'](_0x5b04c2['model'],qs[_0xb00b('0x39')](_0x17f613['query'][_0xb00b('0x39')]));_0x57e8f9[_0xb00b('0x38')]=_0x57e8f9[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x57e8f9[_0xb00b('0x38')]:_0x5b04c2[_0xb00b('0x33')];if(_0x17f613[_0xb00b('0x35')]['includeAll']){_0x57e8f9[_0xb00b('0x2e')]=[{'all':!![]}];}_0x57e8f9=_[_0xb00b('0x3b')]({},_0x57e8f9,_0x17f613[_0xb00b('0x3c')]);return db[_0xb00b('0x2d')][_0xb00b('0x20')](_0x57e8f9)[_0xb00b('0x16')](handleEntityNotFound(_0x594840,null))['then'](respondWithResult(_0x594840,null))[_0xb00b('0x30')](handleError(_0x594840,null));};exports[_0xb00b('0x3d')]=function(_0x4801e7,_0x17ff34){return db[_0xb00b('0x2d')][_0xb00b('0x3d')](_0x4801e7[_0xb00b('0x3e')],{})[_0xb00b('0x16')](function(_0x5636b1){var _0x14ff6a=_0x4801e7[_0xb00b('0x3f')][_0xb00b('0x18')]({'plain':!![]});if(!_0x14ff6a)throw new Error(_0xb00b('0x40'));if(_0x14ff6a['role']==='user'){var _0x43f834=_0x5636b1[_0xb00b('0x18')]({'plain':!![]});var _0x10a348=[{'name':_0xb00b('0x41'),'value':_0xb00b('0x19')},{'name':_0xb00b('0x42'),'value':_0xb00b('0x1a')}];var _0x493841=_[_0xb00b('0x20')](_0x10a348,[_0xb00b('0x1d'),_0x43f834[_0xb00b('0x1f')]])[_0xb00b('0x21')];return db[_0xb00b('0x43')][_0xb00b('0x20')]({'where':{'name':_0x493841,'userProfileId':_0x14ff6a[_0xb00b('0x44')]},'raw':!![]})[_0xb00b('0x16')](function(_0x2d58e2){if(_0x2d58e2&&_0x2d58e2[_0xb00b('0x45')]===0x0){return db[_0xb00b('0x22')][_0xb00b('0x3d')]({'name':_0x43f834['name'],'resourceId':_0x43f834['id'],'type':_0x2d58e2[_0xb00b('0x21')],'sectionId':_0x2d58e2['id']},{})[_0xb00b('0x16')](function(){return _0x5636b1;});}else{return _0x5636b1;}})[_0xb00b('0x30')](function(_0x44afa0){logger[_0xb00b('0x23')](_0xb00b('0x46'),_0x44afa0);throw _0x44afa0;});}return _0x5636b1;})[_0xb00b('0x16')](respondWithResult(_0x17ff34,0xc9))[_0xb00b('0x30')](handleError(_0x17ff34,null));};exports[_0xb00b('0x47')]=function(_0x103320,_0x1eec12){var _0x3b3031={'where':{'id':_0x103320['params']['id']}},_0x5dbe00={};_0x5dbe00['model']=_[_0xb00b('0x34')](db[_0xb00b('0x2d')]['rawAttributes']);_0x3b3031[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x5dbe00[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x103320['query']['fields']));_0x3b3031[_0xb00b('0x38')]=_0x3b3031[_0xb00b('0x38')]['length']?_0x3b3031['attributes']:_0x5dbe00[_0xb00b('0x33')];if(_0x103320[_0xb00b('0x35')]['includeAll']){_0x3b3031[_0xb00b('0x2e')]=[{'all':!![]}];}_0x3b3031=_['merge']({},_0x3b3031,_0x103320['options']);return db['VoiceQueue'][_0xb00b('0x20')](_0x3b3031)['then'](handleEntityNotFound(_0x1eec12,null))[_0xb00b('0x16')](function(_0x3178aa){if(_0x3178aa){var _0x4b6482=_0x3178aa[_0xb00b('0x18')]({'plain':!![]});_0x4b6482=qs[_0xb00b('0x48')](_0x4b6482,['id',_0xb00b('0x49'),'updatedAt']);_0x103320['body']=_[_0xb00b('0x48')](_0x103320[_0xb00b('0x3e')],['id','createdAt',_0xb00b('0x4a')]);return db[_0xb00b('0x2d')]['create'](_[_0xb00b('0x3b')](_0x4b6482,_0x103320[_0xb00b('0x3e')]),{'include':_0x103320[_0xb00b('0x35')]['includeAll']?[{'all':!![]}]:undefined})['then'](function(_0x19f907){var _0x398deb=_0x103320[_0xb00b('0x3f')][_0xb00b('0x18')]({'plain':!![]});if(!_0x398deb)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x398deb[_0xb00b('0x4b')]===_0xb00b('0x3f')){var _0x4ad9cb=_0x19f907['get']({'plain':!![]});var _0x160965=[{'name':'VoiceQueues','value':_0xb00b('0x19')},{'name':_0xb00b('0x42'),'value':_0xb00b('0x1a')}];var _0x222459=_[_0xb00b('0x20')](_0x160965,[_0xb00b('0x1d'),_0x4ad9cb['type']])[_0xb00b('0x21')];return db['UserProfileSection'][_0xb00b('0x20')]({'where':{'name':_0x222459,'userProfileId':_0x398deb[_0xb00b('0x44')]},'raw':!![]})[_0xb00b('0x16')](function(_0x5ac79e){if(_0x5ac79e&&_0x5ac79e[_0xb00b('0x45')]===0x0){return db[_0xb00b('0x22')][_0xb00b('0x3d')]({'name':_0x4ad9cb['name'],'resourceId':_0x4ad9cb['id'],'type':_0x5ac79e[_0xb00b('0x21')],'sectionId':_0x5ac79e['id']},{})[_0xb00b('0x16')](function(){return _0x19f907;});}else{return _0x19f907;}})[_0xb00b('0x30')](function(_0x385029){logger[_0xb00b('0x23')](_0xb00b('0x46'),_0x385029);throw _0x385029;});}return _0x19f907;});}})[_0xb00b('0x16')](respondWithResult(_0x1eec12,0xc9))[_0xb00b('0x30')](handleError(_0x1eec12,null));};exports['update']=function(_0x153551,_0x2cbe80){if(_0x153551[_0xb00b('0x3e')]['id']){delete _0x153551['body']['id'];}return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x153551[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x2cbe80,null))[_0xb00b('0x16')](saveUpdates(_0x153551['body'],null))[_0xb00b('0x16')](respondWithResult(_0x2cbe80,null))[_0xb00b('0x30')](handleError(_0x2cbe80,null));};exports[_0xb00b('0x17')]=function(_0x1cad79,_0x4b1e5f){return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x1cad79[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x4b1e5f,null))[_0xb00b('0x16')](removeEntity(_0x4b1e5f,null))[_0xb00b('0x30')](handleError(_0x4b1e5f,null));};exports[_0xb00b('0x4c')]=function(_0x542223,_0x2b090a){var _0x502822={'raw':![],'where':{}};var _0x3e0648={};var _0x4c2186={'count':0x0,'rows':[]};return db[_0xb00b('0x2d')]['findOne']({'where':{'id':_0x542223[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x2b090a,null))[_0xb00b('0x16')](function(_0x2534ed){if(_0x2534ed){_0x3e0648[_0xb00b('0x33')]=_['keys'](db['CmHopper']['rawAttributes']);_0x3e0648[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x542223[_0xb00b('0x35')]);_0x3e0648['filters']=_[_0xb00b('0x37')](_0x3e0648[_0xb00b('0x33')],_0x3e0648[_0xb00b('0x35')]);_0x502822[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x3e0648['model'],qs[_0xb00b('0x39')](_0x542223[_0xb00b('0x35')]['fields']));_0x502822[_0xb00b('0x38')]=_0x502822[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x502822['attributes']:_0x3e0648['model'];if(!_0x542223[_0xb00b('0x35')][_0xb00b('0x4d')](_0xb00b('0x4e'))){_0x502822['limit']=qs['limit'](_0x542223['query']['limit']);_0x502822[_0xb00b('0x10')]=qs['offset'](_0x542223[_0xb00b('0x35')][_0xb00b('0x10')]);}_0x502822['order']=qs[_0xb00b('0x4f')](_0x542223[_0xb00b('0x35')][_0xb00b('0x4f')]);_0x502822[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_['pick'](_0x542223[_0xb00b('0x35')],_0x3e0648[_0xb00b('0x36')]));_0x502822[_0xb00b('0x2c')][_0xb00b('0x50')]=_0x2534ed['id'];if(_0x542223[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x502822[_0xb00b('0x2c')]=_['merge'](_0x502822[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0x502822[_0xb00b('0x38')],function(_0x328f72){var _0x109f56={};_0x109f56[_0x328f72]={'$like':'%'+_0x542223[_0xb00b('0x35')][_0xb00b('0x1b')]+'%'};return _0x109f56;})});}_0x502822=_[_0xb00b('0x3b')]({},_0x502822,_0x542223['options']);return db[_0xb00b('0x51')][_0xb00b('0x13')]({'where':_0x502822[_0xb00b('0x2c')]})[_0xb00b('0x16')](function(_0x3d6b33){_0x4c2186[_0xb00b('0x13')]=_0x3d6b33;if(_0x542223[_0xb00b('0x35')][_0xb00b('0x52')]){_0x502822['include']=[{'all':!![]}];}return db[_0xb00b('0x51')][_0xb00b('0x53')](_0x502822);})[_0xb00b('0x16')](function(_0x26b82a){_0x4c2186[_0xb00b('0x2f')]=_0x26b82a;return _0x4c2186;});}})[_0xb00b('0x16')](respondWithFilteredResult(_0x2b090a,_0x502822))[_0xb00b('0x30')](handleError(_0x2b090a,null));};exports['getHopperHistories']=function(_0x207bda,_0x37a4c0){var _0x28ecf8={'raw':!![],'where':{}};var _0x22b19c={};var _0x16e8ff={'count':0x0,'rows':[]};return db[_0xb00b('0x2d')]['findOne']({'where':{'id':_0x207bda[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x37a4c0,null))[_0xb00b('0x16')](function(_0x50922f){if(_0x50922f){_0x22b19c[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x54')]['rawAttributes']);_0x22b19c['query']=_[_0xb00b('0x34')](_0x207bda[_0xb00b('0x35')]);_0x22b19c[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x22b19c[_0xb00b('0x33')],_0x22b19c[_0xb00b('0x35')]);_0x28ecf8[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x22b19c[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x207bda[_0xb00b('0x35')][_0xb00b('0x39')]));_0x28ecf8[_0xb00b('0x38')]=_0x28ecf8[_0xb00b('0x38')]['length']?_0x28ecf8['attributes']:_0x22b19c[_0xb00b('0x33')];if(!_0x207bda[_0xb00b('0x35')]['hasOwnProperty']('nolimit')){_0x28ecf8[_0xb00b('0x12')]=qs[_0xb00b('0x12')](_0x207bda[_0xb00b('0x35')]['limit']);_0x28ecf8[_0xb00b('0x10')]=qs[_0xb00b('0x10')](_0x207bda[_0xb00b('0x35')][_0xb00b('0x10')]);}_0x28ecf8[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x207bda[_0xb00b('0x35')]['sort']);_0x28ecf8[_0xb00b('0x2c')]=qs['filters'](_[_0xb00b('0x56')](_0x207bda[_0xb00b('0x35')],_0x22b19c['filters']));_0x28ecf8[_0xb00b('0x2c')][_0xb00b('0x50')]=_0x50922f['id'];if(_0x207bda[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x28ecf8[_0xb00b('0x2c')]=_[_0xb00b('0x3b')](_0x28ecf8[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0x28ecf8[_0xb00b('0x38')],function(_0x383d16){var _0x2ec3f2={};_0x2ec3f2[_0x383d16]={'$like':'%'+_0x207bda[_0xb00b('0x35')]['filter']+'%'};return _0x2ec3f2;})});}_0x28ecf8=_[_0xb00b('0x3b')]({},_0x28ecf8,_0x207bda[_0xb00b('0x3c')]);return db[_0xb00b('0x54')][_0xb00b('0x13')]({'where':_0x28ecf8['where']})[_0xb00b('0x16')](function(_0x17503d){_0x16e8ff[_0xb00b('0x13')]=_0x17503d;if(_0x207bda[_0xb00b('0x35')][_0xb00b('0x52')]){_0x28ecf8['include']=[{'all':!![]}];}return db[_0xb00b('0x54')][_0xb00b('0x53')](_0x28ecf8);})[_0xb00b('0x16')](function(_0x2b66b7){_0x16e8ff['rows']=_0x2b66b7;return _0x16e8ff;});}})[_0xb00b('0x16')](respondWithFilteredResult(_0x37a4c0,_0x28ecf8))['catch'](handleError(_0x37a4c0,null));};exports[_0xb00b('0x57')]=function(_0x202d5f,_0x69b4e0){var _0x165442={'raw':!![],'where':{}};var _0x188349={};var _0x27e051={'count':0x0,'rows':[]};return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x202d5f[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x69b4e0,null))[_0xb00b('0x16')](function(_0x551a55){if(_0x551a55){_0x188349[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x59')][_0xb00b('0x28')]);_0x188349['query']=_[_0xb00b('0x34')](_0x202d5f[_0xb00b('0x35')]);_0x188349['filters']=_[_0xb00b('0x37')](_0x188349['model'],_0x188349[_0xb00b('0x35')]);_0x165442[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x188349['model'],qs[_0xb00b('0x39')](_0x202d5f[_0xb00b('0x35')][_0xb00b('0x39')]));_0x165442[_0xb00b('0x38')]=_0x165442[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x165442[_0xb00b('0x38')]:_0x188349[_0xb00b('0x33')];if(!_0x202d5f[_0xb00b('0x35')]['hasOwnProperty']('nolimit')){_0x165442[_0xb00b('0x12')]=qs[_0xb00b('0x12')](_0x202d5f[_0xb00b('0x35')][_0xb00b('0x12')]);_0x165442['offset']=qs[_0xb00b('0x10')](_0x202d5f[_0xb00b('0x35')]['offset']);}_0x165442[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x202d5f[_0xb00b('0x35')]['sort']);_0x165442[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_['pick'](_0x202d5f[_0xb00b('0x35')],_0x188349[_0xb00b('0x36')]));_0x165442[_0xb00b('0x2c')][_0xb00b('0x50')]=_0x551a55['id'];if(_0x202d5f[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x165442[_0xb00b('0x2c')]=_[_0xb00b('0x3b')](_0x165442['where'],{'$or':_[_0xb00b('0x27')](_0x165442[_0xb00b('0x38')],function(_0x320542){var _0x29d101={};_0x29d101[_0x320542]={'$like':'%'+_0x202d5f['query'][_0xb00b('0x1b')]+'%'};return _0x29d101;})});}_0x165442=_['merge']({},_0x165442,_0x202d5f[_0xb00b('0x3c')]);return db['CmHopperFinal'][_0xb00b('0x13')]({'where':_0x165442[_0xb00b('0x2c')]})[_0xb00b('0x16')](function(_0x3e0e49){_0x27e051[_0xb00b('0x13')]=_0x3e0e49;if(_0x202d5f['query'][_0xb00b('0x52')]){_0x165442[_0xb00b('0x2e')]=[{'all':!![]}];}return db['CmHopperFinal'][_0xb00b('0x53')](_0x165442);})['then'](function(_0x20a690){_0x27e051[_0xb00b('0x2f')]=_0x20a690;return _0x27e051;});}})[_0xb00b('0x16')](respondWithFilteredResult(_0x69b4e0,_0x165442))[_0xb00b('0x30')](handleError(_0x69b4e0,null));};exports['getHopperBlacks']=function(_0x3ae4a4,_0x76b483){var _0x190019={'raw':!![],'where':{}};var _0x44ea58={};var _0x11172e={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x3ae4a4[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x76b483,null))[_0xb00b('0x16')](function(_0x2d5652){if(_0x2d5652){_0x44ea58[_0xb00b('0x33')]=_['keys'](db['CmHopperBlack'][_0xb00b('0x28')]);_0x44ea58[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x3ae4a4[_0xb00b('0x35')]);_0x44ea58[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x44ea58[_0xb00b('0x33')],_0x44ea58['query']);_0x190019[_0xb00b('0x38')]=_['intersection'](_0x44ea58[_0xb00b('0x33')],qs['fields'](_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x39')]));_0x190019[_0xb00b('0x38')]=_0x190019[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x190019[_0xb00b('0x38')]:_0x44ea58[_0xb00b('0x33')];if(!_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x4d')](_0xb00b('0x4e'))){_0x190019[_0xb00b('0x12')]=qs['limit'](_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x12')]);_0x190019[_0xb00b('0x10')]=qs[_0xb00b('0x10')](_0x3ae4a4['query'][_0xb00b('0x10')]);}_0x190019[_0xb00b('0x55')]=qs['sort'](_0x3ae4a4[_0xb00b('0x35')]['sort']);_0x190019[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_['pick'](_0x3ae4a4[_0xb00b('0x35')],_0x44ea58[_0xb00b('0x36')]));_0x190019[_0xb00b('0x2c')][_0xb00b('0x50')]=_0x2d5652['id'];if(_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x190019['where']=_[_0xb00b('0x3b')](_0x190019['where'],{'$or':_[_0xb00b('0x27')](_0x190019[_0xb00b('0x38')],function(_0x140bfd){var _0x43fbc5={};_0x43fbc5[_0x140bfd]={'$like':'%'+_0x3ae4a4['query'][_0xb00b('0x1b')]+'%'};return _0x43fbc5;})});}_0x190019=_[_0xb00b('0x3b')]({},_0x190019,_0x3ae4a4[_0xb00b('0x3c')]);return db['CmHopperBlack'][_0xb00b('0x13')]({'where':_0x190019[_0xb00b('0x2c')]})[_0xb00b('0x16')](function(_0xcc2183){_0x11172e['count']=_0xcc2183;if(_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x52')]){_0x190019[_0xb00b('0x2e')]=[{'all':!![]}];}return db[_0xb00b('0x5a')][_0xb00b('0x53')](_0x190019);})[_0xb00b('0x16')](function(_0x568c0a){_0x11172e['rows']=_0x568c0a;return _0x11172e;});}})[_0xb00b('0x16')](respondWithFilteredResult(_0x76b483,_0x190019))[_0xb00b('0x30')](handleError(_0x76b483,null));};exports[_0xb00b('0x5b')]=function(_0x2ec514,_0x3de4f6){var _0x5f0fd8={};var _0x3d80e7={};var _0xbe553c;var _0x14597c;return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x2ec514[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x3de4f6,null))[_0xb00b('0x16')](function(_0x2414bd){if(_0x2414bd){_0xbe553c=_0x2414bd;_0x3d80e7[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x5c')][_0xb00b('0x28')]);_0x3d80e7[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x2ec514[_0xb00b('0x35')]);_0x3d80e7[_0xb00b('0x36')]=_['intersection'](_0x3d80e7['model'],_0x3d80e7[_0xb00b('0x35')]);_0x5f0fd8[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x3d80e7['model'],qs['fields'](_0x2ec514['query'][_0xb00b('0x39')]));_0x5f0fd8[_0xb00b('0x38')]=_0x5f0fd8[_0xb00b('0x38')]['length']?_0x5f0fd8[_0xb00b('0x38')]:_0x3d80e7[_0xb00b('0x33')];_0x5f0fd8[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x2ec514['query'][_0xb00b('0x4f')]);_0x5f0fd8[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_[_0xb00b('0x56')](_0x2ec514[_0xb00b('0x35')],_0x3d80e7[_0xb00b('0x36')]));if(_0x2ec514[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x5f0fd8['where']=_[_0xb00b('0x3b')](_0x5f0fd8[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0x5f0fd8[_0xb00b('0x38')],function(_0xf9c361){var _0x24c646={};_0x24c646[_0xf9c361]={'$like':'%'+_0x2ec514[_0xb00b('0x35')][_0xb00b('0x1b')]+'%'};return _0x24c646;})});}_0x5f0fd8=_['merge']({},_0x5f0fd8,_0x2ec514[_0xb00b('0x3c')]);return _0xbe553c[_0xb00b('0x5b')](_0x5f0fd8);}})[_0xb00b('0x16')](function(_0x122522){if(_0x122522){_0x14597c=_0x122522['length'];if(!_0x2ec514[_0xb00b('0x35')][_0xb00b('0x4d')](_0xb00b('0x4e'))){_0x5f0fd8[_0xb00b('0x12')]=qs[_0xb00b('0x12')](_0x2ec514[_0xb00b('0x35')][_0xb00b('0x12')]);_0x5f0fd8[_0xb00b('0x10')]=qs['offset'](_0x2ec514['query'][_0xb00b('0x10')]);}return _0xbe553c[_0xb00b('0x5b')](_0x5f0fd8);}})[_0xb00b('0x16')](function(_0x58894a){if(_0x58894a){return _0x58894a?{'count':_0x14597c,'rows':_0x58894a}:null;}})[_0xb00b('0x16')](respondWithResult(_0x3de4f6,null))[_0xb00b('0x30')](handleError(_0x3de4f6,null));};exports[_0xb00b('0x5d')]=function(_0x581548,_0x44d3c0){var _0x3d5880=_0x581548[_0xb00b('0x3e')]['teams'];var _0x58808e=_[_0xb00b('0x27')](_0x3d5880,'id');return db['Team'][_0xb00b('0x53')]({'where':{'id':_0x58808e},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id',_0xb00b('0x21'),_0xb00b('0x5e'),_0xb00b('0x5f'),_0xb00b('0x60')],'raw':!![]}]})[_0xb00b('0x16')](function(_0x5c5a04){if(_0x5c5a04){var _0x1aa5e5=_['flatMap'](_0x5c5a04,function(_0x592206){var _0x3551ca=_0x592206[_0xb00b('0x18')]({'plain':!![]});_0x3551ca[_0xb00b('0x61')][_0xb00b('0x62')](function(_0x8b31d3){_0x8b31d3[_0xb00b('0x63')]=_['find'](_0x3d5880,{'id':_0x3551ca['id']})[_0xb00b('0x63')];});return _0x3551ca['Agents'];});return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x581548[_0xb00b('0x32')]['id']}})['then'](function(_0x226527){return db[_0xb00b('0x64')][_0xb00b('0x65')](function(_0x3dc8d2){return _0x226527['addTeams'](_0x58808e,{'transaction':_0x3dc8d2})['then'](function(){return BPromise[_0xb00b('0x66')](_0x3d5880,function(_0x55bb31){return db['TeamVoiceQueue'][_0xb00b('0x67')]({'TeamId':_0x55bb31['id'],'VoiceQueueId':_0x581548['params']['id'],'penalty':_0x55bb31['penalty']},{'transaction':_0x3dc8d2});});})[_0xb00b('0x16')](function(){return BPromise[_0xb00b('0x66')](_0x1aa5e5,function(_0x745803){return db[_0xb00b('0x68')]['findOrCreate']({'where':{'UserId':_0x745803['id'],'VoiceQueueId':_0x581548['params']['id']},'defaults':{'penalty':_0x745803[_0xb00b('0x63')]},'transaction':_0x3dc8d2});});})[_0xb00b('0x16')](function(){return BPromise[_0xb00b('0x66')](_['filter'](_0x1aa5e5,{'online':!![]}),function(_0x48bac5){return db[_0xb00b('0x69')]['upsert']({'membername':_0x48bac5['name'],'UserId':_0x48bac5['id'],'queue_name':_0x226527[_0xb00b('0x21')],'VoiceQueueId':_0x226527['id'],'interface':_['isNil'](_0x48bac5[_0xb00b('0x60')])?util['format'](_0xb00b('0x6a'),_0x48bac5['name']):_0x48bac5[_0xb00b('0x60')],'paused':_0x48bac5[_0xb00b('0x5f')]||![],'penalty':_0x48bac5[_0xb00b('0x63')]},{'transaction':_0x3dc8d2});});})['then'](function(){_0x1aa5e5[_0xb00b('0x62')](function(_0x596092){socket[_0xb00b('0x6b')](_0xb00b('0x6c'),{'UserId':_0x596092['id'],'VoiceQueueId':_0x226527['id']});});});});});}})['then'](respondWithStatusCode(_0x44d3c0,null))['catch'](handleError(_0x44d3c0,null));};exports['removeTeams']=function(_0x552f73,_0x192b43){return db['Team'][_0xb00b('0x53')]({'where':{'id':_0x552f73['query'][_0xb00b('0x6d')]},'attributes':['id'],'include':[{'model':db[_0xb00b('0x6e')],'as':_0xb00b('0x61'),'attributes':['id'],'raw':!![]}]})[_0xb00b('0x16')](handleEntityNotFound(_0x192b43,null))[_0xb00b('0x16')](function(_0x5b1576){var _0x8292fe=_[_0xb00b('0x27')](_0x5b1576,'id');var _0x3c1cc5=[];var _0x38e425=[];var _0x515143=squel['select']();_0x515143[_0xb00b('0x6f')](_0xb00b('0x70'))[_0xb00b('0x71')](_0xb00b('0x72'),'tq')[_0xb00b('0x73')](_0xb00b('0x74'),'ut',_0xb00b('0x75'))[_0xb00b('0x2c')](_0xb00b('0x76'),_0x552f73['params']['id']);for(var _0x45bae8=0x0;_0x45bae8<_0x5b1576[_0xb00b('0x3a')];_0x45bae8+=0x1){let _0x496500=_0x5b1576[_0x45bae8];for(var _0x475ebb=0x0;_0x475ebb<_0x496500['Agents'][_0xb00b('0x3a')];_0x475ebb+=0x1){let _0x13054a=_0x496500['Agents'][_0x475ebb];var _0x4ce456=_0x515143[_0xb00b('0x47')]();_0x4ce456[_0xb00b('0x2c')](_0xb00b('0x77'),_0x13054a['id']);_0x38e425['push'](db[_0xb00b('0x64')][_0xb00b('0x35')](_0x4ce456[_0xb00b('0x78')](),{'type':db['sequelize'][_0xb00b('0x79')]['SELECT']})['then'](function(_0x58ea43){if(_0x58ea43[_0xb00b('0x3a')]===0x1){return _0x13054a['id'];}else{var _0x4d42af=_[_0xb00b('0x7a')](_[_0xb00b('0x27')](_0x58ea43,'TeamId'),function(_0x4c389f){return _[_0xb00b('0x1e')](_0x8292fe,_0x4c389f);});if(_0x4d42af){return _0x13054a['id'];}}}));}}return BPromise[_0xb00b('0x7b')](_0x38e425)['then'](function(_0x2f131e){_0x3c1cc5=_(_0x3c1cc5)[_0xb00b('0x7c')](_0x2f131e)[_0xb00b('0x7d')]()[_0xb00b('0x1d')]();return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x552f73['params']['id']}})[_0xb00b('0x16')](function(_0x22b425){return db['sequelize'][_0xb00b('0x65')](function(_0x4ed3c7){return _0x22b425['removeTeams'](_0x552f73[_0xb00b('0x35')]['ids'],{'transaction':_0x4ed3c7})[_0xb00b('0x16')](function(){if(!_[_0xb00b('0x7e')](_0x3c1cc5)){return _0x22b425[_0xb00b('0x7f')](_0x3c1cc5,{'transaction':_0x4ed3c7})['then'](function(){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x552f73[_0xb00b('0x32')]['id'],'UserId':_0x3c1cc5},'transaction':_0x4ed3c7});});}})[_0xb00b('0x16')](function(){_0x3c1cc5['forEach'](function(_0x20f4d2){socket[_0xb00b('0x6b')](_0xb00b('0x80'),{'UserId':_0x20f4d2,'VoiceQueueId':_0x22b425['id']});});});});});});})[_0xb00b('0x16')](respondWithStatusCode(_0x192b43,null))[_0xb00b('0x30')](handleError(_0x192b43,null));};exports[_0xb00b('0x81')]=function(_0x21ecef,_0x40f6f6){var _0x48125c,_0x1b097a;return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x21ecef['params']['id']}})['then'](handleEntityNotFound(_0x40f6f6,null))['then'](function(_0x1e66eb){if(_0x1e66eb){_0x1b097a=_0x1e66eb;return _0x1e66eb[_0xb00b('0x81')](_0x21ecef[_0xb00b('0x3e')]['ids'],_[_0xb00b('0x48')](_0x21ecef[_0xb00b('0x3e')],[_0xb00b('0x6d'),'id'])||{})[_0xb00b('0x82')](function(_0x2c3557){for(var _0x5b7137=0x0;_0x5b7137<_0x21ecef[_0xb00b('0x3e')]['ids'][_0xb00b('0x3a')];_0x5b7137+=0x1){socket[_0xb00b('0x6b')](_0xb00b('0x6c'),{'UserId':Number(_0x21ecef[_0xb00b('0x3e')][_0xb00b('0x6d')][_0x5b7137]),'VoiceQueueId':Number(_0x21ecef[_0xb00b('0x32')]['id'])});}return _0x2c3557;});}})['then'](function(_0xeaa6ea){_0x48125c=_0xeaa6ea||[];if(_0x1b097a){return db[_0xb00b('0x6e')][_0xb00b('0x53')]({'where':{'id':_0x21ecef[_0xb00b('0x3e')][_0xb00b('0x6d')]},'attributes':['id',_0xb00b('0x21'),_0xb00b('0x5e'),_0xb00b('0x5f'),_0xb00b('0x60')],'raw':!![]});}})[_0xb00b('0x16')](function(_0x5f1258){if(!_[_0xb00b('0x7e')](_0x5f1258)){var _0x33952b=[];for(var _0x4cd459=0x0;_0x4cd459<_0x5f1258[_0xb00b('0x3a')];_0x4cd459++){if(_0x5f1258[_0x4cd459]['online']){_0x33952b['push'](db['UserVoiceQueueRt'][_0xb00b('0x67')]({'membername':_0x5f1258[_0x4cd459]['name'],'UserId':_0x5f1258[_0x4cd459]['id'],'queue_name':_0x1b097a[_0xb00b('0x21')],'VoiceQueueId':_0x1b097a['id'],'interface':_[_0xb00b('0x83')](_0x5f1258[_0x4cd459][_0xb00b('0x60')])?util[_0xb00b('0x84')](_0xb00b('0x6a'),_0x5f1258[_0x4cd459][_0xb00b('0x21')]):_0x5f1258[_0x4cd459][_0xb00b('0x60')],'paused':_0x5f1258[_0x4cd459][_0xb00b('0x5f')]||![],'penalty':_0x21ecef[_0xb00b('0x3e')][_0xb00b('0x63')]||0x0}));}}return BPromise[_0xb00b('0x7b')](_0x33952b);}})[_0xb00b('0x16')](function(){return _0x48125c;})[_0xb00b('0x16')](respondWithResult(_0x40f6f6,null))[_0xb00b('0x30')](handleError(_0x40f6f6,null));};exports['removeAgents']=function(_0x31d2f0,_0x15f9cd){return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x31d2f0[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x15f9cd,null))[_0xb00b('0x16')](function(_0x387744){if(_0x387744){return _0x387744['removeAgents'](_0x31d2f0['query'][_0xb00b('0x6d')])[_0xb00b('0x16')](function(){if(_[_0xb00b('0x85')](_0x31d2f0[_0xb00b('0x35')][_0xb00b('0x6d')])){for(var _0x11f9b7=0x0;_0x11f9b7<_0x31d2f0[_0xb00b('0x35')][_0xb00b('0x6d')][_0xb00b('0x3a')];_0x11f9b7+=0x1){socket[_0xb00b('0x6b')](_0xb00b('0x80'),{'UserId':Number(_0x31d2f0['query'][_0xb00b('0x6d')][_0x11f9b7]),'VoiceQueueId':Number(_0x31d2f0['params']['id'])});}}else{socket[_0xb00b('0x6b')](_0xb00b('0x80'),{'UserId':Number(_0x31d2f0[_0xb00b('0x35')][_0xb00b('0x6d')]),'VoiceQueueId':Number(_0x31d2f0[_0xb00b('0x32')]['id'])});}});}})[_0xb00b('0x16')](function(_0x59c4b6){return db[_0xb00b('0x69')][_0xb00b('0x17')]({'where':{'VoiceQueueId':_0x31d2f0[_0xb00b('0x32')]['id'],'UserId':_0x31d2f0[_0xb00b('0x35')]['ids']}})[_0xb00b('0x16')](function(){return _0x59c4b6;});})[_0xb00b('0x16')](respondWithStatusCode(_0x15f9cd,null))['catch'](handleError(_0x15f9cd,null));};exports[_0xb00b('0x86')]=function(_0x16cca9,_0x3c57b2){var _0xca4a87={};var _0x456515={};var _0x26145a;var _0x31fa5b;return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x16cca9['params']['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x3c57b2,null))[_0xb00b('0x16')](function(_0x4b0306){if(_0x4b0306){_0x26145a=_0x4b0306;_0x456515[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x6e')][_0xb00b('0x28')]);_0x456515[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x16cca9[_0xb00b('0x35')]);_0x456515[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x456515[_0xb00b('0x33')],_0x456515[_0xb00b('0x35')]);_0xca4a87['attributes']=_[_0xb00b('0x37')](_0x456515[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x16cca9['query'][_0xb00b('0x39')]));_0xca4a87[_0xb00b('0x38')]=_0xca4a87[_0xb00b('0x38')][_0xb00b('0x3a')]?_0xca4a87['attributes']:_0x456515[_0xb00b('0x33')];_0xca4a87[_0xb00b('0x55')]=qs['sort'](_0x16cca9['query'][_0xb00b('0x4f')]);_0xca4a87[_0xb00b('0x2c')]=qs['filters'](_[_0xb00b('0x56')](_0x16cca9['query'],_0x456515['filters']));if(_0x16cca9[_0xb00b('0x35')]['filter']){_0xca4a87['where']=_[_0xb00b('0x3b')](_0xca4a87[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0xca4a87[_0xb00b('0x38')],function(_0x11e9b4){var _0x2ae27c={};_0x2ae27c[_0x11e9b4]={'$like':'%'+_0x16cca9[_0xb00b('0x35')][_0xb00b('0x1b')]+'%'};return _0x2ae27c;})});}_0xca4a87=_[_0xb00b('0x3b')]({},_0xca4a87,_0x16cca9[_0xb00b('0x3c')]);return _0x26145a[_0xb00b('0x86')](_0xca4a87);}})[_0xb00b('0x16')](function(_0x29ba55){if(_0x29ba55){_0x31fa5b=_0x29ba55[_0xb00b('0x3a')];if(!_0x16cca9['query'][_0xb00b('0x4d')](_0xb00b('0x4e'))){_0xca4a87['limit']=qs[_0xb00b('0x12')](_0x16cca9['query'][_0xb00b('0x12')]);_0xca4a87[_0xb00b('0x10')]=qs[_0xb00b('0x10')](_0x16cca9['query'][_0xb00b('0x10')]);}return _0x26145a[_0xb00b('0x86')](_0xca4a87);}})['then'](function(_0x8478c8){if(_0x8478c8){return _0x8478c8?{'count':_0x31fa5b,'rows':_0x8478c8}:null;}})[_0xb00b('0x16')](respondWithResult(_0x3c57b2,null))[_0xb00b('0x30')](handleError(_0x3c57b2,null));};exports[_0xb00b('0x87')]=function(_0x57bfab,_0x2dab12){var _0x47194e={};var _0x19d24b={};var _0x52b54b;var _0x571811;return db['VoiceQueue'][_0xb00b('0x58')]({'where':{'id':_0x57bfab[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x2dab12,null))[_0xb00b('0x16')](function(_0x344379){if(_0x344379){_0x52b54b=_0x344379;_0x19d24b[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x69')][_0xb00b('0x28')]);_0x19d24b['query']=_['keys'](_0x57bfab[_0xb00b('0x35')]);_0x19d24b[_0xb00b('0x36')]=_['intersection'](_0x19d24b[_0xb00b('0x33')],_0x19d24b['query']);_0x47194e[_0xb00b('0x38')]=_['intersection'](_0x19d24b[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x57bfab['query'][_0xb00b('0x39')]));_0x47194e[_0xb00b('0x38')]=_0x47194e['attributes'][_0xb00b('0x3a')]?_0x47194e['attributes']:_0x19d24b[_0xb00b('0x33')];_0x47194e[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x57bfab[_0xb00b('0x35')][_0xb00b('0x4f')]);_0x47194e[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_[_0xb00b('0x56')](_0x57bfab[_0xb00b('0x35')],_0x19d24b[_0xb00b('0x36')]));if(_0x57bfab['query']['filter']){_0x47194e[_0xb00b('0x2c')]=_['merge'](_0x47194e[_0xb00b('0x2c')],{'$or':_['map'](_0x47194e[_0xb00b('0x38')],function(_0x1600f1){var _0x58bd2a={};_0x58bd2a[_0x1600f1]={'$like':'%'+_0x57bfab[_0xb00b('0x35')]['filter']+'%'};return _0x58bd2a;})});}_0x47194e=_[_0xb00b('0x3b')]({},_0x47194e,_0x57bfab[_0xb00b('0x3c')]);return _0x52b54b['getMembers'](_0x47194e);}})[_0xb00b('0x16')](function(_0x307c52){if(_0x307c52){_0x571811=_0x307c52[_0xb00b('0x3a')];if(!_0x57bfab[_0xb00b('0x35')][_0xb00b('0x4d')]('nolimit')){_0x47194e[_0xb00b('0x12')]=qs[_0xb00b('0x12')](_0x57bfab['query']['limit']);_0x47194e[_0xb00b('0x10')]=qs['offset'](_0x57bfab['query']['offset']);}return _0x52b54b[_0xb00b('0x87')](_0x47194e);}})[_0xb00b('0x16')](function(_0x39eb7a){return _0x39eb7a?{'count':_0x571811,'rows':_0x39eb7a}:null;})[_0xb00b('0x16')](respondWithResult(_0x2dab12,null))['catch'](handleError(_0x2dab12,null));};exports[_0xb00b('0x88')]=function(_0x482fc4,_0x3232cc){var _0x89225a={};var _0x22f2f6={};var _0x459f30;var _0x5aa72a;return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x482fc4['params']['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x3232cc,null))[_0xb00b('0x16')](function(_0x4291a3){if(_0x4291a3){_0x459f30=_0x4291a3;_0x22f2f6['model']=_['keys'](db[_0xb00b('0x89')][_0xb00b('0x28')]);_0x22f2f6[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x482fc4[_0xb00b('0x35')]);_0x22f2f6[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x22f2f6['model'],_0x22f2f6['query']);_0x89225a[_0xb00b('0x38')]=_['intersection'](_0x22f2f6['model'],qs[_0xb00b('0x39')](_0x482fc4[_0xb00b('0x35')]['fields']));_0x89225a[_0xb00b('0x38')]=_0x89225a[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x89225a['attributes']:_0x22f2f6[_0xb00b('0x33')];_0x89225a[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x482fc4[_0xb00b('0x35')][_0xb00b('0x4f')]);_0x89225a[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_['pick'](_0x482fc4[_0xb00b('0x35')],_0x22f2f6[_0xb00b('0x36')]));if(_0x482fc4['query']['filter']){_0x89225a['where']=_[_0xb00b('0x3b')](_0x89225a[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0x89225a[_0xb00b('0x38')],function(_0x3deb79){var _0x1901d1={};_0x1901d1[_0x3deb79]={'$like':'%'+_0x482fc4[_0xb00b('0x35')]['filter']+'%'};return _0x1901d1;})});}_0x89225a=_['merge']({},_0x89225a,_0x482fc4[_0xb00b('0x3c')]);return _0x459f30[_0xb00b('0x88')](_0x89225a);}})['then'](function(_0x3517d6){if(_0x3517d6){_0x5aa72a=_0x3517d6[_0xb00b('0x3a')];if(!_0x482fc4['query'][_0xb00b('0x4d')]('nolimit')){_0x89225a[_0xb00b('0x12')]=qs['limit'](_0x482fc4['query']['limit']);_0x89225a[_0xb00b('0x10')]=qs[_0xb00b('0x10')](_0x482fc4[_0xb00b('0x35')][_0xb00b('0x10')]);}return _0x459f30['getLists'](_0x89225a);}})[_0xb00b('0x16')](function(_0x481abb){if(_0x481abb){return _0x481abb?{'count':_0x5aa72a,'rows':_0x481abb}:null;}})[_0xb00b('0x16')](respondWithResult(_0x3232cc,null))[_0xb00b('0x30')](handleError(_0x3232cc,null));};exports[_0xb00b('0x8a')]=function(_0x7ecc19,_0x1cc9fb){var _0x259acf=moment()[_0xb00b('0x84')](_0xb00b('0x8b'));var _0x57834b,_0x5448bb;return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x7ecc19[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x1cc9fb,null))[_0xb00b('0x16')](function(_0x1e0206){if(_0x1e0206){_0x5448bb=_0x1e0206;return _0x1e0206[_0xb00b('0x8a')](_0x7ecc19[_0xb00b('0x3e')][_0xb00b('0x6d')],_['omit'](_0x7ecc19[_0xb00b('0x3e')],[_0xb00b('0x6d'),'id'])||{});}return null;})[_0xb00b('0x82')](function(_0x26b234){var _0x4fe674;_0x57834b=_0x26b234||[];var _0x45ad1f=[];if(_0x26b234){for(var _0x11b817=0x0;_0x11b817<_0x26b234[_0xb00b('0x3a')];_0x11b817+=0x1){var _0x89dd0a=_0x26b234[_0x11b817][_0xb00b('0x18')]({'plain':!![]});_0x5448bb[_0xb00b('0x8c')]=_0x7ecc19[_0xb00b('0x3e')][_0xb00b('0x8c')]?_0x7ecc19[_0xb00b('0x3e')]['dialCheckDuplicateType']:_0x5448bb['dialCheckDuplicateType'];switch(_0x5448bb[_0xb00b('0x8c')]){case _0xb00b('0x8d'):_0x4fe674=squel[_0xb00b('0x8e')]()[_0xb00b('0x8f')](_0xb00b('0x90'))[_0xb00b('0x91')]([_0xb00b('0x92'),'scheduledAt',_0xb00b('0x93'),_0xb00b('0x94'),_0xb00b('0x50'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()['field'](_0xb00b('0x92'),_0xb00b('0x92'))['field']('\x27'+_0x259acf+'\x27',_0xb00b('0x96'))[_0xb00b('0x6f')]('id',_0xb00b('0x93'))[_0xb00b('0x6f')](_0x89dd0a[_0xb00b('0x97')][_0xb00b('0x78')](),'ListId')['field'](_0x7ecc19[_0xb00b('0x32')]['id']['toString'](),'VoiceQueueId')['field']('\x27'+_0x259acf+'\x27',_0xb00b('0x49'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27','updatedAt')['from'](_0xb00b('0x98'))[_0xb00b('0x2c')](_0xb00b('0x99'))[_0xb00b('0x2c')](_0xb00b('0x9a'),_0x89dd0a[_0xb00b('0x97')][_0xb00b('0x78')]())[_0xb00b('0x2c')](_0xb00b('0x9b'))[_0xb00b('0x2c')](_0xb00b('0x9c'),squel['select']()[_0xb00b('0x6f')](_0xb00b('0x9d'))[_0xb00b('0x71')](_0xb00b('0x9e'))[_0xb00b('0x2c')](_0xb00b('0x76'),_0x7ecc19['params']['id'][_0xb00b('0x78')]()))[_0xb00b('0x2c')](_0xb00b('0x9c'),squel[_0xb00b('0x95')]()['field']('COALESCE(phone,\x27\x27)')[_0xb00b('0x71')](_0xb00b('0x90'))[_0xb00b('0x2c')](_0xb00b('0x76'),_0x7ecc19[_0xb00b('0x32')]['id'][_0xb00b('0x78')]())))[_0xb00b('0x78')]();break;case _0xb00b('0x9f'):_0x4fe674=squel[_0xb00b('0x8e')]()[_0xb00b('0x8f')](_0xb00b('0x90'))['fromQuery']([_0xb00b('0x92'),_0xb00b('0x96'),_0xb00b('0x93'),_0xb00b('0x94'),_0xb00b('0x50'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()['field'](_0xb00b('0x92'),_0xb00b('0x92'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x96'))['field']('id','ContactId')['field'](_0x89dd0a[_0xb00b('0x97')]['toString'](),_0xb00b('0x94'))[_0xb00b('0x6f')](_0x7ecc19[_0xb00b('0x32')]['id'][_0xb00b('0x78')](),'VoiceQueueId')['field']('\x27'+_0x259acf+'\x27',_0xb00b('0x49'))['field']('\x27'+_0x259acf+'\x27','updatedAt')[_0xb00b('0x71')]('cm_contacts')[_0xb00b('0x2c')](_0xb00b('0x99'))[_0xb00b('0x2c')](_0xb00b('0x9a'),_0x89dd0a['CmListId'][_0xb00b('0x78')]())[_0xb00b('0x2c')](_0xb00b('0x9b'))[_0xb00b('0x2c')](_0xb00b('0x9c'),squel['select']()['field']('COALESCE(phone,\x27\x27)')[_0xb00b('0x71')](_0xb00b('0x90'))['where'](_0xb00b('0x76'),_0x7ecc19[_0xb00b('0x32')]['id'][_0xb00b('0x78')]())))[_0xb00b('0x78')]();break;default:_0x4fe674=squel['insert']()[_0xb00b('0x8f')](_0xb00b('0x90'))[_0xb00b('0x91')]([_0xb00b('0x92'),'scheduledAt',_0xb00b('0x93'),'ListId',_0xb00b('0x50'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()[_0xb00b('0x6f')](_0xb00b('0x92'),_0xb00b('0x92'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x96'))[_0xb00b('0x6f')]('id',_0xb00b('0x93'))[_0xb00b('0x6f')](_0x89dd0a[_0xb00b('0x97')][_0xb00b('0x78')](),_0xb00b('0x94'))[_0xb00b('0x6f')](_0x7ecc19[_0xb00b('0x32')]['id']['toString'](),_0xb00b('0x50'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x49'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x4a'))['from'](_0xb00b('0x98'))[_0xb00b('0x2c')](_0xb00b('0x99'))[_0xb00b('0x2c')](_0xb00b('0x9a'),_0x89dd0a[_0xb00b('0x97')][_0xb00b('0x78')]())['where'](_0xb00b('0x9b')))['toString']();}_0x45ad1f[_0xb00b('0xa0')](db[_0xb00b('0x64')][_0xb00b('0x35')](_0x4fe674));}return BPromise['all'](_0x45ad1f);}})[_0xb00b('0x16')](function(){var _0x2bf68f=[];var _0x283ad6=squel[_0xb00b('0x8e')]()['into']('cm_hopper_additional_phones')[_0xb00b('0x91')]([_0xb00b('0xa1'),'phone',_0xb00b('0xa2'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()['field']('h.id')[_0xb00b('0x6f')](_0xb00b('0xa3'))[_0xb00b('0x6f')](_0xb00b('0xa4'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x49'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x4a'))['from'](_0xb00b('0xa5'),'ci')[_0xb00b('0x73')](_0xb00b('0x90'),'h',_0xb00b('0xa6'))[_0xb00b('0x2c')](_0xb00b('0xa7'),_0x259acf)[_0xb00b('0x2c')]('ci.ItemClass=?',_0xb00b('0xa8')))[_0xb00b('0x78')]();_0x2bf68f[_0xb00b('0xa0')](db[_0xb00b('0x64')][_0xb00b('0x35')](_0x283ad6));return BPromise[_0xb00b('0x7b')](_0x2bf68f);})[_0xb00b('0x16')](function(){return _0x57834b;})[_0xb00b('0x16')](respondWithResult(_0x1cc9fb,null))[_0xb00b('0x30')](handleError(_0x1cc9fb,null));};exports[_0xb00b('0xa9')]=function(_0x229197,_0x5ce3f3){return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x229197[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x5ce3f3,null))[_0xb00b('0x16')](function(_0x406469){if(_0x406469){return _0x406469['removeLists'](_0x229197[_0xb00b('0x35')][_0xb00b('0x6d')]);}})[_0xb00b('0x16')](function(_0x4ffe41){if(_0x4ffe41){return db['CmHopper'][_0xb00b('0x17')]({'where':{'ListId':_0x229197['query'][_0xb00b('0x6d')],'VoiceQueueId':_0x229197[_0xb00b('0x32')]['id']}})['then'](function(){return _0x4ffe41;});}})[_0xb00b('0x16')](respondWithStatusCode(_0x5ce3f3,null))['catch'](handleError(_0x5ce3f3,null));};exports['getBlackLists']=function(_0x122be3,_0x4cb6ba){var _0x3ca253={};var _0x438281={};var _0x23b994;var _0x564934;return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x122be3[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x4cb6ba,null))[_0xb00b('0x16')](function(_0x18f5ac){if(_0x18f5ac){_0x23b994=_0x18f5ac;_0x438281[_0xb00b('0x33')]=_['keys'](db[_0xb00b('0x89')]['rawAttributes']);_0x438281[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x122be3[_0xb00b('0x35')]);_0x438281[_0xb00b('0x36')]=_['intersection'](_0x438281[_0xb00b('0x33')],_0x438281[_0xb00b('0x35')]);_0x3ca253[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x438281[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x122be3['query'][_0xb00b('0x39')]));_0x3ca253[_0xb00b('0x38')]=_0x3ca253['attributes'][_0xb00b('0x3a')]?_0x3ca253[_0xb00b('0x38')]:_0x438281[_0xb00b('0x33')];_0x3ca253[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x122be3[_0xb00b('0x35')][_0xb00b('0x4f')]);_0x3ca253[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_[_0xb00b('0x56')](_0x122be3[_0xb00b('0x35')],_0x438281[_0xb00b('0x36')]));if(_0x122be3[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x3ca253['where']=_['merge'](_0x3ca253['where'],{'$or':_[_0xb00b('0x27')](_0x3ca253[_0xb00b('0x38')],function(_0x966247){var _0x58b695={};_0x58b695[_0x966247]={'$like':'%'+_0x122be3[_0xb00b('0x35')][_0xb00b('0x1b')]+'%'};return _0x58b695;})});}_0x3ca253=_[_0xb00b('0x3b')]({},_0x3ca253,_0x122be3[_0xb00b('0x3c')]);return _0x23b994[_0xb00b('0xaa')](_0x3ca253);}})['then'](function(_0x1bafb2){if(_0x1bafb2){_0x564934=_0x1bafb2['length'];if(!_0x122be3['query']['hasOwnProperty'](_0xb00b('0x4e'))){_0x3ca253[_0xb00b('0x12')]=qs['limit'](_0x122be3[_0xb00b('0x35')][_0xb00b('0x12')]);_0x3ca253[_0xb00b('0x10')]=qs['offset'](_0x122be3[_0xb00b('0x35')]['offset']);}return _0x23b994[_0xb00b('0xaa')](_0x3ca253);}})[_0xb00b('0x16')](function(_0x2e3e5a){if(_0x2e3e5a){return _0x2e3e5a?{'count':_0x564934,'rows':_0x2e3e5a}:null;}})[_0xb00b('0x16')](respondWithResult(_0x4cb6ba,null))['catch'](handleError(_0x4cb6ba,null));};exports['addBlackLists']=function(_0x470c4a,_0x12cc9d){var _0xe5b66f;return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x470c4a[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x12cc9d,null))[_0xb00b('0x16')](function(_0x3afb66){if(_0x3afb66){return _0x3afb66[_0xb00b('0xab')](_0x470c4a[_0xb00b('0x3e')]['ids'],_[_0xb00b('0x48')](_0x470c4a[_0xb00b('0x3e')],[_0xb00b('0x6d'),'id'])||{});}return null;})[_0xb00b('0x82')](function(_0x379b81){var _0x46c784;_0xe5b66f=_0x379b81||[];var _0x471db4=[];if(_0x379b81){for(var _0x333bee=0x0;_0x333bee<_0x379b81['length'];_0x333bee+=0x1){var _0x1a94bf=_0x379b81[_0x333bee][_0xb00b('0x18')]({'plain':!![]});_0x46c784=squel[_0xb00b('0x8e')]()['into'](_0xb00b('0xac'))[_0xb00b('0x91')]([_0xb00b('0x92'),'ContactId',_0xb00b('0x94'),_0xb00b('0x50'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()[_0xb00b('0x6f')](_0xb00b('0x92'),'phone')[_0xb00b('0x6f')]('id',_0xb00b('0x93'))[_0xb00b('0x6f')](_0x1a94bf['CmListId'][_0xb00b('0x78')](),_0xb00b('0x94'))[_0xb00b('0x6f')](_0x470c4a[_0xb00b('0x32')]['id']['toString'](),_0xb00b('0x50'))['field'](_0xb00b('0xad'),_0xb00b('0x49'))['field'](_0xb00b('0xad'),_0xb00b('0x4a'))[_0xb00b('0x71')](_0xb00b('0x98'))[_0xb00b('0x2c')]('deletedAt\x20IS\x20NULL')['where'](_0xb00b('0x9a'),_0x1a94bf[_0xb00b('0x97')][_0xb00b('0x78')]())['where'](_0xb00b('0x9b')))[_0xb00b('0x78')]();_0x471db4[_0xb00b('0xa0')](db['sequelize'][_0xb00b('0x35')](_0x46c784));}return BPromise[_0xb00b('0x7b')](_0x471db4);}})[_0xb00b('0x16')](function(){return _0xe5b66f;})['then'](respondWithResult(_0x12cc9d,null))[_0xb00b('0x30')](handleError(_0x12cc9d,null));};exports[_0xb00b('0xae')]=function(_0x4d30c3,_0x5099fd){return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x4d30c3[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x5099fd,null))['then'](function(_0x45b2e1){if(_0x45b2e1){return _0x45b2e1[_0xb00b('0xae')](_0x4d30c3[_0xb00b('0x35')][_0xb00b('0x6d')]);}})[_0xb00b('0x16')](function(_0x5e12dc){if(_0x5e12dc){return db[_0xb00b('0x5a')][_0xb00b('0x17')]({'where':{'ListId':_0x4d30c3[_0xb00b('0x35')][_0xb00b('0x6d')],'VoiceQueueId':_0x4d30c3[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](function(){return _0x5e12dc;});}})[_0xb00b('0x16')](respondWithStatusCode(_0x5099fd,null))[_0xb00b('0x30')](handleError(_0x5099fd,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff