Built motion from commit a679711e.|2.6.15
[motion2.git] / server / api / voiceQueue / voiceQueue.controller.js
index 40a512f..300c508 100644 (file)
@@ -15,4 +15,4 @@
 // * 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 _0x3079=['UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','format','SIP/%s','forEach','emit','removeTeams','ids','select','field','tq.TeamId','from','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','every','TeamId','all','union','compact','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','userVoiceQueue:save','voicePause','isArray','getAgents','getMembers','getLists','CmList','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','scheduledAt','ContactId','phone','CmListId','ListId','cm_contacts','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','COALESCE(phone,\x27\x27)','onlyIfOpen','deletedAt\x20IS\x20NULL','cm_hopper_additional_phones','OrderBy','h.id','ci.item','ci.OrderBy+1','cm_contact_has_items','h.ContactId=ci.CmContactId','h.scheduledat=?','ci.ItemClass=?','PHONE','removeLists','CmHopper','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','sox','to-csv','ejs','fs-extra','lodash','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','redis','./voiceQueue.socket','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','destroy','then','get','VoiceQueues','QueueCampaigns','filter','ignore','value','type','name','UserProfileResource','end','error','stack','send','index','map','VoiceQueue','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','fields','nolimit','where','merge','options','includeAll','findAll','rows','catch','show','params','length','include','create','user','role','inbound','find','UserProfileSection','userProfileId','clone','omit','createdAt','updatedAt','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','findOne','order','sort','VoiceQueueId','getHopperHistories','CmHopperHistory','hasOwnProperty','pick','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','addTeams','Team','User','online','interface','Agents','penalty','sequelize','transaction','each','TeamVoiceQueue'];(function(_0x2e54bc,_0x304463){var _0x95de19=function(_0x46fbac){while(--_0x46fbac){_0x2e54bc['push'](_0x2e54bc['shift']());}};_0x95de19(++_0x304463);}(_0x3079,0x110));var _0x9307=function(_0x37c7a5,_0x1c901b){_0x37c7a5=_0x37c7a5-0x0;var _0x3ecbc7=_0x3079[_0x37c7a5];return _0x3ecbc7;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x9307('0x0'));var zipdir=require(_0x9307('0x1'));var jsonpatch=require(_0x9307('0x2'));var rp=require(_0x9307('0x3'));var moment=require('moment');var BPromise=require(_0x9307('0x4'));var Mustache=require(_0x9307('0x5'));var util=require('util');var path=require('path');var sox=require(_0x9307('0x6'));var csv=require(_0x9307('0x7'));var ejs=require(_0x9307('0x8'));var fs=require('fs');var fs_extra=require(_0x9307('0x9'));var _=require(_0x9307('0xa'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x9307('0xb'));var deskjs=require('desk.js');var toCsv=require(_0x9307('0x7'));var querystring=require(_0x9307('0xc'));var Papa=require('papaparse');var Redis=require(_0x9307('0xd'));var authService=require(_0x9307('0xe'));var qs=require(_0x9307('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x9307('0x10'))(_0x9307('0x11'));var utils=require(_0x9307('0x12'));var config=require(_0x9307('0x13'));var licenseUtil=require(_0x9307('0x14'));var db=require(_0x9307('0x15'))['db'];config['redis']=_[_0x9307('0x16')](config[_0x9307('0x17')],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x9307('0x17')]));require(_0x9307('0x18'))['register'](socket);function respondWithStatusCode(_0x3d9864,_0x4053e2){_0x4053e2=_0x4053e2||0xcc;return function(_0x545b0a){if(_0x545b0a){return _0x3d9864[_0x9307('0x19')](_0x4053e2);}return _0x3d9864[_0x9307('0x1a')](_0x4053e2)['end']();};}function respondWithResult(_0x3fc6fd,_0x4296e9){_0x4296e9=_0x4296e9||0xc8;return function(_0x100f15){if(_0x100f15){return _0x3fc6fd['status'](_0x4296e9)[_0x9307('0x1b')](_0x100f15);}};}function respondWithFilteredResult(_0x27682a,_0x503338){return function(_0xbba867){if(_0xbba867){var _0x3d84b0=typeof _0x503338[_0x9307('0x1c')]===_0x9307('0x1d')&&typeof _0x503338[_0x9307('0x1e')]===_0x9307('0x1d');var _0x5810d7=_0xbba867[_0x9307('0x1f')];var _0x10aa66=_0x3d84b0?0x0:_0x503338[_0x9307('0x1c')];var _0x58574e=_0x3d84b0?_0xbba867[_0x9307('0x1f')]:_0x503338[_0x9307('0x1c')]+_0x503338['limit'];var _0x307ab9;if(_0x58574e>=_0x5810d7){_0x58574e=_0x5810d7;_0x307ab9=0xc8;}else{_0x307ab9=0xce;}_0x27682a[_0x9307('0x1a')](_0x307ab9);return _0x27682a[_0x9307('0x20')](_0x9307('0x21'),_0x10aa66+'-'+_0x58574e+'/'+_0x5810d7)[_0x9307('0x1b')](_0xbba867);}return null;};}function patchUpdates(_0xf39222){return function(_0x1d671b){try{jsonpatch[_0x9307('0x22')](_0x1d671b,_0xf39222,!![]);}catch(_0x2f5f68){return BPromise[_0x9307('0x23')](_0x2f5f68);}return _0x1d671b[_0x9307('0x24')]();};}function saveUpdates(_0x5d42a0,_0x1e17c5){return function(_0x593f27){if(_0x593f27){return _0x593f27[_0x9307('0x25')](_0x5d42a0)['then'](function(_0x2c59ef){return _0x2c59ef;});}return null;};}function removeEntity(_0x5bb98a,_0x4d1a13){return function(_0x428043){if(_0x428043){return _0x428043[_0x9307('0x26')]()[_0x9307('0x27')](function(){var _0x330d48=_0x428043[_0x9307('0x28')]({'plain':!![]});var _0xd89e2f=[{'name':_0x9307('0x29'),'value':'inbound','ignore':![]},{'name':_0x9307('0x2a'),'value':'outbound','ignore':![]}];var _0x1da3e3=_(_0xd89e2f)[_0x9307('0x2b')](_0x9307('0x2c'))['map'](_0x9307('0x2d'))['value']();if(_['includes'](_0x1da3e3,_0x330d48['type'])){return;}var _0x27faa5=_['find'](_0xd89e2f,[_0x9307('0x2d'),_0x330d48[_0x9307('0x2e')]])[_0x9307('0x2f')];return db[_0x9307('0x30')][_0x9307('0x26')]({'where':{'type':_0x27faa5,'resourceId':_0x330d48['id']}})[_0x9307('0x27')](function(){return _0x428043;});})['then'](function(){_0x5bb98a[_0x9307('0x1a')](0xcc)[_0x9307('0x31')]();});}};}function handleEntityNotFound(_0x824001,_0x1f5ee1){return function(_0x34fa73){if(!_0x34fa73){_0x824001[_0x9307('0x19')](0x194);}return _0x34fa73;};}function handleError(_0x158145,_0x54ffa7){_0x54ffa7=_0x54ffa7||0x1f4;return function(_0x5b79da){logger[_0x9307('0x32')](_0x5b79da[_0x9307('0x33')]);if(_0x5b79da[_0x9307('0x2f')]){delete _0x5b79da[_0x9307('0x2f')];}_0x158145[_0x9307('0x1a')](_0x54ffa7)[_0x9307('0x34')](_0x5b79da);};}exports[_0x9307('0x35')]=function(_0x139c45,_0x8e2cb4){var _0x33a507={},_0x4df3a6={},_0x443d35={'count':0x0,'rows':[]};var _0x42595e=_[_0x9307('0x36')](db[_0x9307('0x37')][_0x9307('0x38')],function(_0x11d342){return{'name':_0x11d342[_0x9307('0x39')],'type':_0x11d342[_0x9307('0x2e')][_0x9307('0x3a')]};});_0x4df3a6[_0x9307('0x3b')]=_[_0x9307('0x36')](_0x42595e,_0x9307('0x2f'));_0x4df3a6[_0x9307('0x3c')]=_[_0x9307('0x3d')](_0x139c45['query']);_0x4df3a6[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x4df3a6[_0x9307('0x3b')],_0x4df3a6[_0x9307('0x3c')]);_0x33a507[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x4df3a6[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x139c45['query'][_0x9307('0x41')]));_0x33a507[_0x9307('0x40')]=_0x33a507[_0x9307('0x40')]['length']?_0x33a507[_0x9307('0x40')]:_0x4df3a6[_0x9307('0x3b')];if(!_0x139c45[_0x9307('0x3c')]['hasOwnProperty'](_0x9307('0x42'))){_0x33a507[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x139c45[_0x9307('0x3c')]['limit']);_0x33a507['offset']=qs[_0x9307('0x1c')](_0x139c45[_0x9307('0x3c')][_0x9307('0x1c')]);}_0x33a507['order']=qs['sort'](_0x139c45[_0x9307('0x3c')]['sort']);_0x33a507[_0x9307('0x43')]=qs[_0x9307('0x3e')](_['pick'](_0x139c45[_0x9307('0x3c')],_0x4df3a6[_0x9307('0x3e')]),_0x42595e);if(_0x139c45[_0x9307('0x3c')][_0x9307('0x2b')]){_0x33a507[_0x9307('0x43')]=_[_0x9307('0x44')](_0x33a507[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x42595e,function(_0x593a19){if(_0x593a19['type']!=='VIRTUAL'){var _0x274598={};_0x274598[_0x593a19[_0x9307('0x2f')]]={'$like':'%'+_0x139c45[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x274598;}})});}_0x33a507=_[_0x9307('0x44')]({},_0x33a507,_0x139c45[_0x9307('0x45')]);var _0x4fadc9={'where':_0x33a507['where']};return db[_0x9307('0x37')][_0x9307('0x1f')](_0x4fadc9)['then'](function(_0x1d24d3){_0x443d35['count']=_0x1d24d3;if(_0x139c45[_0x9307('0x3c')][_0x9307('0x46')]){_0x33a507['include']=[{'all':!![]}];}return db[_0x9307('0x37')][_0x9307('0x47')](_0x33a507);})[_0x9307('0x27')](function(_0x276ed5){_0x443d35[_0x9307('0x48')]=_0x276ed5;return _0x443d35;})[_0x9307('0x27')](respondWithFilteredResult(_0x8e2cb4,_0x33a507))[_0x9307('0x49')](handleError(_0x8e2cb4,null));};exports[_0x9307('0x4a')]=function(_0x57f146,_0x3ff0a4){var _0x2d2e5b={'raw':![],'where':{'id':_0x57f146[_0x9307('0x4b')]['id']}},_0x390eef={};_0x390eef[_0x9307('0x3b')]=_['keys'](db[_0x9307('0x37')]['rawAttributes']);_0x390eef['query']=_[_0x9307('0x3d')](_0x57f146[_0x9307('0x3c')]);_0x390eef[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x390eef[_0x9307('0x3b')],_0x390eef['query']);_0x2d2e5b[_0x9307('0x40')]=_['intersection'](_0x390eef[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x57f146['query']['fields']));_0x2d2e5b[_0x9307('0x40')]=_0x2d2e5b[_0x9307('0x40')][_0x9307('0x4c')]?_0x2d2e5b[_0x9307('0x40')]:_0x390eef[_0x9307('0x3b')];if(_0x57f146['query'][_0x9307('0x46')]){_0x2d2e5b[_0x9307('0x4d')]=[{'all':!![]}];}_0x2d2e5b=_[_0x9307('0x44')]({},_0x2d2e5b,_0x57f146[_0x9307('0x45')]);return db['VoiceQueue']['find'](_0x2d2e5b)['then'](handleEntityNotFound(_0x3ff0a4,null))[_0x9307('0x27')](respondWithResult(_0x3ff0a4,null))['catch'](handleError(_0x3ff0a4,null));};exports[_0x9307('0x4e')]=function(_0x5bb358,_0x6272c7){return db[_0x9307('0x37')][_0x9307('0x4e')](_0x5bb358['body'],{})[_0x9307('0x27')](function(_0x1e8e32){var _0x4db0dd=_0x5bb358[_0x9307('0x4f')][_0x9307('0x28')]({'plain':!![]});if(!_0x4db0dd)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4db0dd[_0x9307('0x50')]===_0x9307('0x4f')){var _0xf75713=_0x1e8e32[_0x9307('0x28')]({'plain':!![]});var _0x1cca54=[{'name':_0x9307('0x29'),'value':_0x9307('0x51')},{'name':'QueueCampaigns','value':'outbound'}];var _0x2268d2=_[_0x9307('0x52')](_0x1cca54,[_0x9307('0x2d'),_0xf75713['type']])[_0x9307('0x2f')];return db[_0x9307('0x53')]['find']({'where':{'name':_0x2268d2,'userProfileId':_0x4db0dd[_0x9307('0x54')]},'raw':!![]})[_0x9307('0x27')](function(_0x1bb8e1){if(_0x1bb8e1&&_0x1bb8e1['autoAssociation']===0x0){return db[_0x9307('0x30')][_0x9307('0x4e')]({'name':_0xf75713['name'],'resourceId':_0xf75713['id'],'type':_0x1bb8e1[_0x9307('0x2f')],'sectionId':_0x1bb8e1['id']},{})[_0x9307('0x27')](function(){return _0x1e8e32;});}else{return _0x1e8e32;}})[_0x9307('0x49')](function(_0x49fa2b){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x49fa2b);throw _0x49fa2b;});}return _0x1e8e32;})['then'](respondWithResult(_0x6272c7,0xc9))[_0x9307('0x49')](handleError(_0x6272c7,null));};exports[_0x9307('0x55')]=function(_0x34bc1e,_0x5c4907){var _0x5ec1ac={'where':{'id':_0x34bc1e[_0x9307('0x4b')]['id']}},_0x39b01d={};_0x39b01d[_0x9307('0x3b')]=_[_0x9307('0x3d')](db[_0x9307('0x37')][_0x9307('0x38')]);_0x5ec1ac['attributes']=_[_0x9307('0x3f')](_0x39b01d[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x34bc1e[_0x9307('0x3c')][_0x9307('0x41')]));_0x5ec1ac['attributes']=_0x5ec1ac[_0x9307('0x40')][_0x9307('0x4c')]?_0x5ec1ac['attributes']:_0x39b01d[_0x9307('0x3b')];if(_0x34bc1e[_0x9307('0x3c')]['includeAll']){_0x5ec1ac[_0x9307('0x4d')]=[{'all':!![]}];}_0x5ec1ac=_[_0x9307('0x44')]({},_0x5ec1ac,_0x34bc1e['options']);return db[_0x9307('0x37')][_0x9307('0x52')](_0x5ec1ac)[_0x9307('0x27')](handleEntityNotFound(_0x5c4907,null))[_0x9307('0x27')](function(_0x3a6564){if(_0x3a6564){var _0x383e4d=_0x3a6564[_0x9307('0x28')]({'plain':!![]});_0x383e4d=qs[_0x9307('0x56')](_0x383e4d,['id',_0x9307('0x57'),_0x9307('0x58')]);_0x34bc1e[_0x9307('0x59')]=_[_0x9307('0x56')](_0x34bc1e['body'],['id',_0x9307('0x57'),'updatedAt']);return db[_0x9307('0x37')][_0x9307('0x4e')](_['merge'](_0x383e4d,_0x34bc1e[_0x9307('0x59')]),{'include':_0x34bc1e[_0x9307('0x3c')]['includeAll']?[{'all':!![]}]:undefined})[_0x9307('0x27')](function(_0xf5390d){var _0xdb251b=_0x34bc1e[_0x9307('0x4f')][_0x9307('0x28')]({'plain':!![]});if(!_0xdb251b)throw new Error(_0x9307('0x5a'));if(_0xdb251b['role']===_0x9307('0x4f')){var _0x1f0936=_0xf5390d[_0x9307('0x28')]({'plain':!![]});var _0x5041d3=[{'name':_0x9307('0x29'),'value':_0x9307('0x51')},{'name':_0x9307('0x2a'),'value':'outbound'}];var _0x16a62b=_[_0x9307('0x52')](_0x5041d3,['value',_0x1f0936[_0x9307('0x2e')]])[_0x9307('0x2f')];return db[_0x9307('0x53')][_0x9307('0x52')]({'where':{'name':_0x16a62b,'userProfileId':_0xdb251b[_0x9307('0x54')]},'raw':!![]})['then'](function(_0x22fc8c){if(_0x22fc8c&&_0x22fc8c[_0x9307('0x5b')]===0x0){return db['UserProfileResource']['create']({'name':_0x1f0936[_0x9307('0x2f')],'resourceId':_0x1f0936['id'],'type':_0x22fc8c['name'],'sectionId':_0x22fc8c['id']},{})['then'](function(){return _0xf5390d;});}else{return _0xf5390d;}})[_0x9307('0x49')](function(_0x2780a2){logger[_0x9307('0x32')](_0x9307('0x5c'),_0x2780a2);throw _0x2780a2;});}return _0xf5390d;});}})['then'](respondWithResult(_0x5c4907,0xc9))[_0x9307('0x49')](handleError(_0x5c4907,null));};exports[_0x9307('0x25')]=function(_0x1da55c,_0x17e344){if(_0x1da55c['body']['id']){delete _0x1da55c[_0x9307('0x59')]['id'];}return db['VoiceQueue'][_0x9307('0x52')]({'where':{'id':_0x1da55c[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x17e344,null))['then'](saveUpdates(_0x1da55c[_0x9307('0x59')],null))[_0x9307('0x27')](respondWithResult(_0x17e344,null))['catch'](handleError(_0x17e344,null));};exports[_0x9307('0x26')]=function(_0x53d490,_0x1c1351){return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x53d490[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x1c1351,null))['then'](removeEntity(_0x1c1351,null))[_0x9307('0x49')](handleError(_0x1c1351,null));};exports[_0x9307('0x5d')]=function(_0x36d456,_0x1224b3,_0x798430){var _0x270afc={'raw':![],'where':{}};var _0x1102c7={};var _0x340e6e={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x9307('0x5e')]({'where':{'id':_0x36d456[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x1224b3,null))[_0x9307('0x27')](function(_0x4e798d){if(_0x4e798d){_0x1102c7['model']=_[_0x9307('0x3d')](db['CmHopper']['rawAttributes']);_0x1102c7[_0x9307('0x3c')]=_[_0x9307('0x3d')](_0x36d456['query']);_0x1102c7[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x1102c7['model'],_0x1102c7['query']);_0x270afc[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x1102c7[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x36d456['query']['fields']));_0x270afc['attributes']=_0x270afc[_0x9307('0x40')][_0x9307('0x4c')]?_0x270afc[_0x9307('0x40')]:_0x1102c7[_0x9307('0x3b')];if(!_0x36d456[_0x9307('0x3c')]['hasOwnProperty'](_0x9307('0x42'))){_0x270afc[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x36d456[_0x9307('0x3c')]['limit']);_0x270afc[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x36d456[_0x9307('0x3c')][_0x9307('0x1c')]);}_0x270afc[_0x9307('0x5f')]=qs['sort'](_0x36d456[_0x9307('0x3c')][_0x9307('0x60')]);_0x270afc['where']=qs[_0x9307('0x3e')](_['pick'](_0x36d456[_0x9307('0x3c')],_0x1102c7[_0x9307('0x3e')]));_0x270afc['where'][_0x9307('0x61')]=_0x4e798d['id'];if(_0x36d456[_0x9307('0x3c')][_0x9307('0x2b')]){_0x270afc[_0x9307('0x43')]=_['merge'](_0x270afc[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x270afc[_0x9307('0x40')],function(_0x2abde0){var _0x3e1d15={};_0x3e1d15[_0x2abde0]={'$like':'%'+_0x36d456[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x3e1d15;})});}_0x270afc=_[_0x9307('0x44')]({},_0x270afc,_0x36d456[_0x9307('0x45')]);return db['CmHopper'][_0x9307('0x1f')]({'where':_0x270afc[_0x9307('0x43')]})['then'](function(_0x1d37ac){_0x340e6e[_0x9307('0x1f')]=_0x1d37ac;if(_0x36d456[_0x9307('0x3c')][_0x9307('0x46')]){_0x270afc['include']=[{'all':!![]}];}return db['CmHopper'][_0x9307('0x47')](_0x270afc);})[_0x9307('0x27')](function(_0x456095){_0x340e6e[_0x9307('0x48')]=_0x456095;return _0x340e6e;});}})['then'](respondWithFilteredResult(_0x1224b3,_0x270afc))[_0x9307('0x49')](handleError(_0x1224b3,null));};exports[_0x9307('0x62')]=function(_0x4fdda9,_0x3a2290,_0x3207ba){var _0x59a5fa={'raw':!![],'where':{}};var _0x159d6f={};var _0x285d99={'count':0x0,'rows':[]};return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x4fdda9[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x3a2290,null))[_0x9307('0x27')](function(_0x4c8349){if(_0x4c8349){_0x159d6f[_0x9307('0x3b')]=_['keys'](db[_0x9307('0x63')][_0x9307('0x38')]);_0x159d6f[_0x9307('0x3c')]=_['keys'](_0x4fdda9[_0x9307('0x3c')]);_0x159d6f[_0x9307('0x3e')]=_['intersection'](_0x159d6f['model'],_0x159d6f[_0x9307('0x3c')]);_0x59a5fa[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x159d6f[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x4fdda9[_0x9307('0x3c')][_0x9307('0x41')]));_0x59a5fa['attributes']=_0x59a5fa[_0x9307('0x40')][_0x9307('0x4c')]?_0x59a5fa[_0x9307('0x40')]:_0x159d6f[_0x9307('0x3b')];if(!_0x4fdda9[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x59a5fa[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x4fdda9[_0x9307('0x3c')][_0x9307('0x1e')]);_0x59a5fa[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x4fdda9['query'][_0x9307('0x1c')]);}_0x59a5fa[_0x9307('0x5f')]=qs['sort'](_0x4fdda9[_0x9307('0x3c')][_0x9307('0x60')]);_0x59a5fa[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x4fdda9[_0x9307('0x3c')],_0x159d6f['filters']));_0x59a5fa['where'][_0x9307('0x61')]=_0x4c8349['id'];if(_0x4fdda9[_0x9307('0x3c')][_0x9307('0x2b')]){_0x59a5fa[_0x9307('0x43')]=_['merge'](_0x59a5fa['where'],{'$or':_['map'](_0x59a5fa['attributes'],function(_0x8e5f70){var _0x4a14af={};_0x4a14af[_0x8e5f70]={'$like':'%'+_0x4fdda9[_0x9307('0x3c')]['filter']+'%'};return _0x4a14af;})});}_0x59a5fa=_[_0x9307('0x44')]({},_0x59a5fa,_0x4fdda9[_0x9307('0x45')]);return db[_0x9307('0x63')]['count']({'where':_0x59a5fa[_0x9307('0x43')]})[_0x9307('0x27')](function(_0x21c818){_0x285d99[_0x9307('0x1f')]=_0x21c818;if(_0x4fdda9[_0x9307('0x3c')][_0x9307('0x46')]){_0x59a5fa[_0x9307('0x4d')]=[{'all':!![]}];}return db[_0x9307('0x63')]['findAll'](_0x59a5fa);})[_0x9307('0x27')](function(_0x2c2806){_0x285d99[_0x9307('0x48')]=_0x2c2806;return _0x285d99;});}})[_0x9307('0x27')](respondWithFilteredResult(_0x3a2290,_0x59a5fa))[_0x9307('0x49')](handleError(_0x3a2290,null));};exports[_0x9307('0x66')]=function(_0x4bc9a0,_0x54b06a,_0x268b52){var _0x21e3da={'raw':!![],'where':{}};var _0x530bb0={};var _0x9e0e88={'count':0x0,'rows':[]};return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x4bc9a0[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x54b06a,null))[_0x9307('0x27')](function(_0x4cfdbb){if(_0x4cfdbb){_0x530bb0[_0x9307('0x3b')]=_[_0x9307('0x3d')](db['CmHopperFinal'][_0x9307('0x38')]);_0x530bb0['query']=_[_0x9307('0x3d')](_0x4bc9a0[_0x9307('0x3c')]);_0x530bb0[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x530bb0[_0x9307('0x3b')],_0x530bb0[_0x9307('0x3c')]);_0x21e3da[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x530bb0[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x41')]));_0x21e3da[_0x9307('0x40')]=_0x21e3da[_0x9307('0x40')]['length']?_0x21e3da[_0x9307('0x40')]:_0x530bb0[_0x9307('0x3b')];if(!_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x21e3da[_0x9307('0x1e')]=qs['limit'](_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x1e')]);_0x21e3da[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x1c')]);}_0x21e3da['order']=qs[_0x9307('0x60')](_0x4bc9a0['query'][_0x9307('0x60')]);_0x21e3da[_0x9307('0x43')]=qs[_0x9307('0x3e')](_['pick'](_0x4bc9a0[_0x9307('0x3c')],_0x530bb0[_0x9307('0x3e')]));_0x21e3da[_0x9307('0x43')][_0x9307('0x61')]=_0x4cfdbb['id'];if(_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x2b')]){_0x21e3da['where']=_[_0x9307('0x44')](_0x21e3da[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x21e3da[_0x9307('0x40')],function(_0x50014d){var _0x3bbdd1={};_0x3bbdd1[_0x50014d]={'$like':'%'+_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x3bbdd1;})});}_0x21e3da=_[_0x9307('0x44')]({},_0x21e3da,_0x4bc9a0[_0x9307('0x45')]);return db[_0x9307('0x67')]['count']({'where':_0x21e3da[_0x9307('0x43')]})['then'](function(_0x52f551){_0x9e0e88[_0x9307('0x1f')]=_0x52f551;if(_0x4bc9a0['query'][_0x9307('0x46')]){_0x21e3da['include']=[{'all':!![]}];}return db[_0x9307('0x67')]['findAll'](_0x21e3da);})[_0x9307('0x27')](function(_0x4f0994){_0x9e0e88[_0x9307('0x48')]=_0x4f0994;return _0x9e0e88;});}})[_0x9307('0x27')](respondWithFilteredResult(_0x54b06a,_0x21e3da))['catch'](handleError(_0x54b06a,null));};exports[_0x9307('0x68')]=function(_0x57c981,_0x5ee5e0,_0x5037ca){var _0x4383cb={'raw':!![],'where':{}};var _0x3e3bbf={};var _0x366e9d={'count':0x0,'rows':[]};return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x57c981[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x5ee5e0,null))[_0x9307('0x27')](function(_0x5dd2c3){if(_0x5dd2c3){_0x3e3bbf[_0x9307('0x3b')]=_['keys'](db['CmHopperBlack'][_0x9307('0x38')]);_0x3e3bbf[_0x9307('0x3c')]=_['keys'](_0x57c981[_0x9307('0x3c')]);_0x3e3bbf['filters']=_[_0x9307('0x3f')](_0x3e3bbf[_0x9307('0x3b')],_0x3e3bbf['query']);_0x4383cb[_0x9307('0x40')]=_['intersection'](_0x3e3bbf[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x57c981[_0x9307('0x3c')]['fields']));_0x4383cb['attributes']=_0x4383cb[_0x9307('0x40')][_0x9307('0x4c')]?_0x4383cb[_0x9307('0x40')]:_0x3e3bbf[_0x9307('0x3b')];if(!_0x57c981[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x4383cb[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x57c981['query'][_0x9307('0x1e')]);_0x4383cb[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x57c981[_0x9307('0x3c')][_0x9307('0x1c')]);}_0x4383cb[_0x9307('0x5f')]=qs[_0x9307('0x60')](_0x57c981[_0x9307('0x3c')]['sort']);_0x4383cb[_0x9307('0x43')]=qs['filters'](_['pick'](_0x57c981[_0x9307('0x3c')],_0x3e3bbf[_0x9307('0x3e')]));_0x4383cb['where'][_0x9307('0x61')]=_0x5dd2c3['id'];if(_0x57c981[_0x9307('0x3c')][_0x9307('0x2b')]){_0x4383cb[_0x9307('0x43')]=_[_0x9307('0x44')](_0x4383cb[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x4383cb[_0x9307('0x40')],function(_0x45e1c1){var _0x4974dd={};_0x4974dd[_0x45e1c1]={'$like':'%'+_0x57c981[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x4974dd;})});}_0x4383cb=_[_0x9307('0x44')]({},_0x4383cb,_0x57c981[_0x9307('0x45')]);return db[_0x9307('0x69')]['count']({'where':_0x4383cb[_0x9307('0x43')]})[_0x9307('0x27')](function(_0x30af84){_0x366e9d['count']=_0x30af84;if(_0x57c981[_0x9307('0x3c')]['includeAll']){_0x4383cb['include']=[{'all':!![]}];}return db[_0x9307('0x69')][_0x9307('0x47')](_0x4383cb);})[_0x9307('0x27')](function(_0x3f1920){_0x366e9d[_0x9307('0x48')]=_0x3f1920;return _0x366e9d;});}})[_0x9307('0x27')](respondWithFilteredResult(_0x5ee5e0,_0x4383cb))[_0x9307('0x49')](handleError(_0x5ee5e0,null));};exports[_0x9307('0x6a')]=function(_0x3a834d,_0x4fc7f3,_0x593e0e){var _0x19def4={};var _0x4ec335={};var _0x4cd875;var _0x44724c;return db['VoiceQueue'][_0x9307('0x5e')]({'where':{'id':_0x3a834d[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x4fc7f3,null))[_0x9307('0x27')](function(_0x4e2e2e){if(_0x4e2e2e){_0x4cd875=_0x4e2e2e;_0x4ec335['model']=_[_0x9307('0x3d')](db['Team'][_0x9307('0x38')]);_0x4ec335['query']=_['keys'](_0x3a834d[_0x9307('0x3c')]);_0x4ec335[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x4ec335[_0x9307('0x3b')],_0x4ec335[_0x9307('0x3c')]);_0x19def4[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x4ec335['model'],qs[_0x9307('0x41')](_0x3a834d['query'][_0x9307('0x41')]));_0x19def4[_0x9307('0x40')]=_0x19def4[_0x9307('0x40')][_0x9307('0x4c')]?_0x19def4['attributes']:_0x4ec335[_0x9307('0x3b')];_0x19def4[_0x9307('0x5f')]=qs['sort'](_0x3a834d[_0x9307('0x3c')][_0x9307('0x60')]);_0x19def4[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x3a834d[_0x9307('0x3c')],_0x4ec335[_0x9307('0x3e')]));if(_0x3a834d[_0x9307('0x3c')][_0x9307('0x2b')]){_0x19def4['where']=_[_0x9307('0x44')](_0x19def4[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x19def4[_0x9307('0x40')],function(_0x7a0d7e){var _0xf067f6={};_0xf067f6[_0x7a0d7e]={'$like':'%'+_0x3a834d['query']['filter']+'%'};return _0xf067f6;})});}_0x19def4=_[_0x9307('0x44')]({},_0x19def4,_0x3a834d[_0x9307('0x45')]);return _0x4cd875[_0x9307('0x6a')](_0x19def4);}})[_0x9307('0x27')](function(_0x96c64a){if(_0x96c64a){_0x44724c=_0x96c64a[_0x9307('0x4c')];if(!_0x3a834d[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x19def4[_0x9307('0x1e')]=qs['limit'](_0x3a834d['query'][_0x9307('0x1e')]);_0x19def4[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x3a834d[_0x9307('0x3c')]['offset']);}return _0x4cd875[_0x9307('0x6a')](_0x19def4);}})['then'](function(_0x5562a8){if(_0x5562a8){return _0x5562a8?{'count':_0x44724c,'rows':_0x5562a8}:null;}})['then'](respondWithResult(_0x4fc7f3,null))[_0x9307('0x49')](handleError(_0x4fc7f3,null));};exports[_0x9307('0x6b')]=function(_0x216953,_0x9127d,_0x505bb4){var _0x21aeb8=_0x216953[_0x9307('0x59')]['teams'];var _0xa0bfe7=_[_0x9307('0x36')](_0x21aeb8,'id');return db[_0x9307('0x6c')][_0x9307('0x47')]({'where':{'id':_0xa0bfe7},'attributes':['id'],'include':[{'model':db[_0x9307('0x6d')],'as':'Agents','attributes':['id',_0x9307('0x2f'),_0x9307('0x6e'),'voicePause',_0x9307('0x6f')],'raw':!![]}]})['then'](function(_0x195b90){if(_0x195b90){var _0x3e166c=_['flatMap'](_0x195b90,function(_0x12f7db){var _0x4616b2=_0x12f7db['get']({'plain':!![]});_0x4616b2[_0x9307('0x70')]['forEach'](function(_0x5d5cdf){_0x5d5cdf[_0x9307('0x71')]=_['find'](_0x21aeb8,{'id':_0x4616b2['id']})['penalty'];});return _0x4616b2[_0x9307('0x70')];});return db[_0x9307('0x37')]['find']({'where':{'id':_0x216953[_0x9307('0x4b')]['id']}})['then'](function(_0x40ad77){return db[_0x9307('0x72')][_0x9307('0x73')](function(_0x21dba8){return _0x40ad77[_0x9307('0x6b')](_0xa0bfe7,{'transaction':_0x21dba8})['then'](function(){return BPromise[_0x9307('0x74')](_0x21aeb8,function(_0x1614ac){return db[_0x9307('0x75')]['upsert']({'TeamId':_0x1614ac['id'],'VoiceQueueId':_0x216953['params']['id'],'penalty':_0x1614ac[_0x9307('0x71')]},{'transaction':_0x21dba8});});})[_0x9307('0x27')](function(){return BPromise[_0x9307('0x74')](_0x3e166c,function(_0x18a44f){return db[_0x9307('0x76')][_0x9307('0x77')]({'where':{'UserId':_0x18a44f['id'],'VoiceQueueId':_0x216953[_0x9307('0x4b')]['id']},'defaults':{'penalty':_0x18a44f[_0x9307('0x71')]},'transaction':_0x21dba8});});})[_0x9307('0x27')](function(){return BPromise[_0x9307('0x74')](_[_0x9307('0x2b')](_0x3e166c,{'online':!![]}),function(_0x567681){return db[_0x9307('0x78')]['upsert']({'membername':_0x567681[_0x9307('0x2f')],'UserId':_0x567681['id'],'queue_name':_0x40ad77[_0x9307('0x2f')],'VoiceQueueId':_0x40ad77['id'],'interface':_[_0x9307('0x79')](_0x567681['interface'])?util[_0x9307('0x7a')](_0x9307('0x7b'),_0x567681[_0x9307('0x2f')]):_0x567681[_0x9307('0x6f')],'paused':_0x567681['voicePause']||![],'penalty':_0x567681[_0x9307('0x71')]},{'transaction':_0x21dba8});});})['then'](function(){_0x3e166c[_0x9307('0x7c')](function(_0x40fa18){socket[_0x9307('0x7d')]('userVoiceQueue:save',{'UserId':_0x40fa18['id'],'VoiceQueueId':_0x40ad77['id']});});});});});}})[_0x9307('0x27')](respondWithStatusCode(_0x9127d,null))['catch'](handleError(_0x9127d,null));};exports[_0x9307('0x7e')]=function(_0x21a4de,_0x9a6f62,_0x5b946a){return db[_0x9307('0x6c')][_0x9307('0x47')]({'where':{'id':_0x21a4de['query'][_0x9307('0x7f')]},'attributes':['id'],'include':[{'model':db[_0x9307('0x6d')],'as':_0x9307('0x70'),'attributes':['id'],'raw':!![]}]})[_0x9307('0x27')](handleEntityNotFound(_0x9a6f62,null))[_0x9307('0x27')](function(_0x38239d){var _0x4010a5=_[_0x9307('0x36')](_0x38239d,'id');var _0x5e93a2=[];var _0x6c402=[];var _0x157f7e=squel[_0x9307('0x80')]();_0x157f7e[_0x9307('0x81')](_0x9307('0x82'))[_0x9307('0x83')]('team_has_voice_queues','tq')['join'](_0x9307('0x84'),'ut',_0x9307('0x85'))[_0x9307('0x43')](_0x9307('0x86'),_0x21a4de[_0x9307('0x4b')]['id']);for(var _0x4219a1=0x0;_0x4219a1<_0x38239d[_0x9307('0x4c')];_0x4219a1+=0x1){let _0x2f75d3=_0x38239d[_0x4219a1];for(var _0x114cf5=0x0;_0x114cf5<_0x2f75d3[_0x9307('0x70')][_0x9307('0x4c')];_0x114cf5+=0x1){let _0xb2905f=_0x2f75d3[_0x9307('0x70')][_0x114cf5];var _0x10ae91=_0x157f7e[_0x9307('0x55')]();_0x10ae91[_0x9307('0x43')](_0x9307('0x87'),_0xb2905f['id']);_0x6c402[_0x9307('0x88')](db[_0x9307('0x72')][_0x9307('0x3c')](_0x10ae91[_0x9307('0x89')](),{'type':db['sequelize'][_0x9307('0x8a')][_0x9307('0x8b')]})[_0x9307('0x27')](function(_0x4ce6d5){if(_0x4ce6d5['length']===0x1){return _0xb2905f['id'];}else{var _0x359031=_[_0x9307('0x8c')](_[_0x9307('0x36')](_0x4ce6d5,_0x9307('0x8d')),function(_0x4b7d15){return _['includes'](_0x4010a5,_0x4b7d15);});if(_0x359031){return _0xb2905f['id'];}}}));}}return BPromise[_0x9307('0x8e')](_0x6c402)[_0x9307('0x27')](function(_0x49cca6){_0x5e93a2=_(_0x5e93a2)[_0x9307('0x8f')](_0x49cca6)[_0x9307('0x90')]()[_0x9307('0x2d')]();return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x21a4de[_0x9307('0x4b')]['id']}})['then'](function(_0x4c0366){return db[_0x9307('0x72')][_0x9307('0x73')](function(_0x2dfced){return _0x4c0366[_0x9307('0x7e')](_0x21a4de[_0x9307('0x3c')][_0x9307('0x7f')],{'transaction':_0x2dfced})[_0x9307('0x27')](function(){if(!_[_0x9307('0x91')](_0x5e93a2)){return _0x4c0366[_0x9307('0x92')](_0x5e93a2,{'transaction':_0x2dfced})[_0x9307('0x27')](function(){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x21a4de[_0x9307('0x4b')]['id'],'UserId':_0x5e93a2},'transaction':_0x2dfced});});}})[_0x9307('0x27')](function(){_0x5e93a2[_0x9307('0x7c')](function(_0x366059){socket[_0x9307('0x7d')](_0x9307('0x93'),{'UserId':_0x366059,'VoiceQueueId':_0x4c0366['id']});});});});});});})['then'](respondWithStatusCode(_0x9a6f62,null))[_0x9307('0x49')](handleError(_0x9a6f62,null));};exports[_0x9307('0x94')]=function(_0x13a4b7,_0x517ce5,_0x303946){var _0x4daf38,_0xc8877b;return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x13a4b7[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x517ce5,null))[_0x9307('0x27')](function(_0x1c02fa){if(_0x1c02fa){_0xc8877b=_0x1c02fa;return _0x1c02fa[_0x9307('0x94')](_0x13a4b7['body'][_0x9307('0x7f')],_[_0x9307('0x56')](_0x13a4b7[_0x9307('0x59')],[_0x9307('0x7f'),'id'])||{})[_0x9307('0x95')](function(_0x23bc4a){for(var _0x4175b4=0x0;_0x4175b4<_0x13a4b7[_0x9307('0x59')][_0x9307('0x7f')][_0x9307('0x4c')];_0x4175b4+=0x1){socket[_0x9307('0x7d')](_0x9307('0x96'),{'UserId':Number(_0x13a4b7['body']['ids'][_0x4175b4]),'VoiceQueueId':Number(_0x13a4b7[_0x9307('0x4b')]['id'])});}return _0x23bc4a;});}})[_0x9307('0x27')](function(_0x536930){_0x4daf38=_0x536930||[];if(_0xc8877b){return db[_0x9307('0x6d')][_0x9307('0x47')]({'where':{'id':_0x13a4b7[_0x9307('0x59')][_0x9307('0x7f')]},'attributes':['id',_0x9307('0x2f'),_0x9307('0x6e'),_0x9307('0x97'),_0x9307('0x6f')],'raw':!![]});}})[_0x9307('0x27')](function(_0xa95202){if(!_[_0x9307('0x91')](_0xa95202)){var _0x17b856=[];for(var _0x12f595=0x0;_0x12f595<_0xa95202[_0x9307('0x4c')];_0x12f595++){if(_0xa95202[_0x12f595][_0x9307('0x6e')]){_0x17b856[_0x9307('0x88')](db[_0x9307('0x78')]['upsert']({'membername':_0xa95202[_0x12f595]['name'],'UserId':_0xa95202[_0x12f595]['id'],'queue_name':_0xc8877b[_0x9307('0x2f')],'VoiceQueueId':_0xc8877b['id'],'interface':_[_0x9307('0x79')](_0xa95202[_0x12f595]['interface'])?util[_0x9307('0x7a')](_0x9307('0x7b'),_0xa95202[_0x12f595][_0x9307('0x2f')]):_0xa95202[_0x12f595][_0x9307('0x6f')],'paused':_0xa95202[_0x12f595]['voicePause']||![],'penalty':_0x13a4b7['body'][_0x9307('0x71')]||0x0}));}}return BPromise[_0x9307('0x8e')](_0x17b856);}})['then'](function(){return _0x4daf38;})[_0x9307('0x27')](respondWithResult(_0x517ce5,null))[_0x9307('0x49')](handleError(_0x517ce5,null));};exports[_0x9307('0x92')]=function(_0x2d8ea9,_0x484f1c,_0x310402){return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x2d8ea9[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x484f1c,null))[_0x9307('0x27')](function(_0x3e4fec){if(_0x3e4fec){return _0x3e4fec[_0x9307('0x92')](_0x2d8ea9['query'][_0x9307('0x7f')])[_0x9307('0x27')](function(){if(_[_0x9307('0x98')](_0x2d8ea9['query'][_0x9307('0x7f')])){for(var _0x51ffd0=0x0;_0x51ffd0<_0x2d8ea9[_0x9307('0x3c')][_0x9307('0x7f')][_0x9307('0x4c')];_0x51ffd0+=0x1){socket[_0x9307('0x7d')]('userVoiceQueue:remove',{'UserId':Number(_0x2d8ea9[_0x9307('0x3c')][_0x9307('0x7f')][_0x51ffd0]),'VoiceQueueId':Number(_0x2d8ea9[_0x9307('0x4b')]['id'])});}}else{socket[_0x9307('0x7d')]('userVoiceQueue:remove',{'UserId':Number(_0x2d8ea9[_0x9307('0x3c')][_0x9307('0x7f')]),'VoiceQueueId':Number(_0x2d8ea9[_0x9307('0x4b')]['id'])});}});}})[_0x9307('0x27')](function(_0x56e69e){return db[_0x9307('0x78')][_0x9307('0x26')]({'where':{'VoiceQueueId':_0x2d8ea9[_0x9307('0x4b')]['id'],'UserId':_0x2d8ea9[_0x9307('0x3c')][_0x9307('0x7f')]}})[_0x9307('0x27')](function(){return _0x56e69e;});})[_0x9307('0x27')](respondWithStatusCode(_0x484f1c,null))['catch'](handleError(_0x484f1c,null));};exports[_0x9307('0x99')]=function(_0x55f414,_0x5d69d6,_0x36c195){var _0x3f020b={};var _0x166c73={};var _0x5c3b81;var _0x229499;return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x55f414['params']['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x5d69d6,null))['then'](function(_0x193d52){if(_0x193d52){_0x5c3b81=_0x193d52;_0x166c73[_0x9307('0x3b')]=_['keys'](db[_0x9307('0x6d')][_0x9307('0x38')]);_0x166c73['query']=_['keys'](_0x55f414['query']);_0x166c73['filters']=_[_0x9307('0x3f')](_0x166c73[_0x9307('0x3b')],_0x166c73['query']);_0x3f020b[_0x9307('0x40')]=_['intersection'](_0x166c73[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x55f414[_0x9307('0x3c')][_0x9307('0x41')]));_0x3f020b['attributes']=_0x3f020b[_0x9307('0x40')]['length']?_0x3f020b[_0x9307('0x40')]:_0x166c73[_0x9307('0x3b')];_0x3f020b[_0x9307('0x5f')]=qs[_0x9307('0x60')](_0x55f414[_0x9307('0x3c')][_0x9307('0x60')]);_0x3f020b['where']=qs[_0x9307('0x3e')](_['pick'](_0x55f414[_0x9307('0x3c')],_0x166c73[_0x9307('0x3e')]));if(_0x55f414[_0x9307('0x3c')]['filter']){_0x3f020b['where']=_[_0x9307('0x44')](_0x3f020b['where'],{'$or':_[_0x9307('0x36')](_0x3f020b[_0x9307('0x40')],function(_0x1be923){var _0x146962={};_0x146962[_0x1be923]={'$like':'%'+_0x55f414[_0x9307('0x3c')]['filter']+'%'};return _0x146962;})});}_0x3f020b=_[_0x9307('0x44')]({},_0x3f020b,_0x55f414[_0x9307('0x45')]);return _0x5c3b81['getAgents'](_0x3f020b);}})[_0x9307('0x27')](function(_0x375280){if(_0x375280){_0x229499=_0x375280['length'];if(!_0x55f414['query'][_0x9307('0x64')](_0x9307('0x42'))){_0x3f020b[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x55f414[_0x9307('0x3c')][_0x9307('0x1e')]);_0x3f020b[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x55f414[_0x9307('0x3c')]['offset']);}return _0x5c3b81[_0x9307('0x99')](_0x3f020b);}})[_0x9307('0x27')](function(_0xce8c88){if(_0xce8c88){return _0xce8c88?{'count':_0x229499,'rows':_0xce8c88}:null;}})[_0x9307('0x27')](respondWithResult(_0x5d69d6,null))['catch'](handleError(_0x5d69d6,null));};exports[_0x9307('0x9a')]=function(_0x3301c3,_0x1daf74,_0x3db4cc){var _0x4dd2e4={};var _0x5baf63={};var _0x73d1aa;var _0xed5cfa;return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x3301c3[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x1daf74,null))[_0x9307('0x27')](function(_0x1495af){if(_0x1495af){_0x73d1aa=_0x1495af;_0x5baf63['model']=_['keys'](db['UserVoiceQueueRt'][_0x9307('0x38')]);_0x5baf63[_0x9307('0x3c')]=_[_0x9307('0x3d')](_0x3301c3[_0x9307('0x3c')]);_0x5baf63['filters']=_[_0x9307('0x3f')](_0x5baf63['model'],_0x5baf63[_0x9307('0x3c')]);_0x4dd2e4['attributes']=_[_0x9307('0x3f')](_0x5baf63[_0x9307('0x3b')],qs['fields'](_0x3301c3[_0x9307('0x3c')][_0x9307('0x41')]));_0x4dd2e4[_0x9307('0x40')]=_0x4dd2e4[_0x9307('0x40')][_0x9307('0x4c')]?_0x4dd2e4[_0x9307('0x40')]:_0x5baf63[_0x9307('0x3b')];_0x4dd2e4[_0x9307('0x5f')]=qs['sort'](_0x3301c3['query']['sort']);_0x4dd2e4[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x3301c3[_0x9307('0x3c')],_0x5baf63[_0x9307('0x3e')]));if(_0x3301c3['query'][_0x9307('0x2b')]){_0x4dd2e4[_0x9307('0x43')]=_['merge'](_0x4dd2e4[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x4dd2e4[_0x9307('0x40')],function(_0x324fa9){var _0x4b106c={};_0x4b106c[_0x324fa9]={'$like':'%'+_0x3301c3[_0x9307('0x3c')]['filter']+'%'};return _0x4b106c;})});}_0x4dd2e4=_[_0x9307('0x44')]({},_0x4dd2e4,_0x3301c3[_0x9307('0x45')]);return _0x73d1aa['getMembers'](_0x4dd2e4);}})[_0x9307('0x27')](function(_0x2743f5){if(_0x2743f5){_0xed5cfa=_0x2743f5[_0x9307('0x4c')];if(!_0x3301c3[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x4dd2e4[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x3301c3[_0x9307('0x3c')][_0x9307('0x1e')]);_0x4dd2e4[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x3301c3[_0x9307('0x3c')][_0x9307('0x1c')]);}return _0x73d1aa['getMembers'](_0x4dd2e4);}})[_0x9307('0x27')](function(_0x434a7b){return _0x434a7b?{'count':_0xed5cfa,'rows':_0x434a7b}:null;})[_0x9307('0x27')](respondWithResult(_0x1daf74,null))[_0x9307('0x49')](handleError(_0x1daf74,null));};exports[_0x9307('0x9b')]=function(_0x413d86,_0x444e17,_0x4c9cdf){var _0xaf6e35={};var _0x33cd1={};var _0x3e3834;var _0x456589;return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x413d86[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x444e17,null))['then'](function(_0x7f93de){if(_0x7f93de){_0x3e3834=_0x7f93de;_0x33cd1[_0x9307('0x3b')]=_[_0x9307('0x3d')](db[_0x9307('0x9c')]['rawAttributes']);_0x33cd1['query']=_['keys'](_0x413d86[_0x9307('0x3c')]);_0x33cd1['filters']=_[_0x9307('0x3f')](_0x33cd1[_0x9307('0x3b')],_0x33cd1[_0x9307('0x3c')]);_0xaf6e35[_0x9307('0x40')]=_['intersection'](_0x33cd1[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x413d86[_0x9307('0x3c')][_0x9307('0x41')]));_0xaf6e35[_0x9307('0x40')]=_0xaf6e35[_0x9307('0x40')][_0x9307('0x4c')]?_0xaf6e35['attributes']:_0x33cd1[_0x9307('0x3b')];_0xaf6e35['order']=qs[_0x9307('0x60')](_0x413d86[_0x9307('0x3c')]['sort']);_0xaf6e35[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x413d86['query'],_0x33cd1[_0x9307('0x3e')]));if(_0x413d86[_0x9307('0x3c')][_0x9307('0x2b')]){_0xaf6e35['where']=_['merge'](_0xaf6e35[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0xaf6e35[_0x9307('0x40')],function(_0x447171){var _0x560f62={};_0x560f62[_0x447171]={'$like':'%'+_0x413d86['query'][_0x9307('0x2b')]+'%'};return _0x560f62;})});}_0xaf6e35=_[_0x9307('0x44')]({},_0xaf6e35,_0x413d86[_0x9307('0x45')]);return _0x3e3834['getLists'](_0xaf6e35);}})['then'](function(_0x2b054a){if(_0x2b054a){_0x456589=_0x2b054a[_0x9307('0x4c')];if(!_0x413d86[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0xaf6e35[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x413d86['query'][_0x9307('0x1e')]);_0xaf6e35[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x413d86[_0x9307('0x3c')][_0x9307('0x1c')]);}return _0x3e3834[_0x9307('0x9b')](_0xaf6e35);}})[_0x9307('0x27')](function(_0x3373cf){if(_0x3373cf){return _0x3373cf?{'count':_0x456589,'rows':_0x3373cf}:null;}})['then'](respondWithResult(_0x444e17,null))[_0x9307('0x49')](handleError(_0x444e17,null));};exports[_0x9307('0x9d')]=function(_0x1b58c5,_0xa13cd1,_0x58b692){var _0x1b564d=moment()[_0x9307('0x7a')](_0x9307('0x9e'));var _0x1cd08c,_0x4631ec;return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x1b58c5[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0xa13cd1,null))[_0x9307('0x27')](function(_0x2f7ad9){if(_0x2f7ad9){_0x4631ec=_0x2f7ad9;return _0x2f7ad9[_0x9307('0x9d')](_0x1b58c5[_0x9307('0x59')][_0x9307('0x7f')],_[_0x9307('0x56')](_0x1b58c5['body'],[_0x9307('0x7f'),'id'])||{});}return null;})[_0x9307('0x95')](function(_0x3c140e){var _0x4da62e;_0x1cd08c=_0x3c140e||[];var _0x25f206=[];if(_0x3c140e){for(var _0x501875=0x0;_0x501875<_0x3c140e[_0x9307('0x4c')];_0x501875+=0x1){var _0x534638=_0x3c140e[_0x501875][_0x9307('0x28')]({'plain':!![]});_0x4631ec[_0x9307('0x9f')]=_0x1b58c5[_0x9307('0x59')]['dialCheckDuplicateType']?_0x1b58c5[_0x9307('0x59')][_0x9307('0x9f')]:_0x4631ec[_0x9307('0x9f')];switch(_0x4631ec[_0x9307('0x9f')]){case _0x9307('0xa0'):_0x4da62e=squel[_0x9307('0xa1')]()[_0x9307('0xa2')](_0x9307('0xa3'))[_0x9307('0xa4')](['phone',_0x9307('0xa5'),_0x9307('0xa6'),'ListId',_0x9307('0x61'),_0x9307('0x57'),_0x9307('0x58')],squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xa7'),_0x9307('0xa7'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0xa5'))[_0x9307('0x81')]('id',_0x9307('0xa6'))[_0x9307('0x81')](_0x534638[_0x9307('0xa8')]['toString'](),_0x9307('0xa9'))[_0x9307('0x81')](_0x1b58c5['params']['id'][_0x9307('0x89')](),_0x9307('0x61'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0x57'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0x58'))[_0x9307('0x83')](_0x9307('0xaa'))[_0x9307('0x43')]('deletedAt\x20IS\x20NULL')[_0x9307('0x43')](_0x9307('0xab'),_0x534638[_0x9307('0xa8')][_0x9307('0x89')]())[_0x9307('0x43')](_0x9307('0xac'))[_0x9307('0x43')](_0x9307('0xad'),squel[_0x9307('0x80')]()[_0x9307('0x81')]('COALESCE(calleridnum,\x27\x27)')[_0x9307('0x83')](_0x9307('0xae'))[_0x9307('0x43')](_0x9307('0x86'),_0x1b58c5[_0x9307('0x4b')]['id'][_0x9307('0x89')]()))[_0x9307('0x43')]('phone\x20NOT\x20IN\x20(?)',squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xaf'))['from']('cm_hopper')[_0x9307('0x43')](_0x9307('0x86'),_0x1b58c5['params']['id'][_0x9307('0x89')]())))[_0x9307('0x89')]();break;case _0x9307('0xb0'):_0x4da62e=squel[_0x9307('0xa1')]()[_0x9307('0xa2')](_0x9307('0xa3'))[_0x9307('0xa4')]([_0x9307('0xa7'),'scheduledAt',_0x9307('0xa6'),_0x9307('0xa9'),'VoiceQueueId','createdAt',_0x9307('0x58')],squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xa7'),_0x9307('0xa7'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0xa5'))[_0x9307('0x81')]('id','ContactId')[_0x9307('0x81')](_0x534638[_0x9307('0xa8')][_0x9307('0x89')](),_0x9307('0xa9'))[_0x9307('0x81')](_0x1b58c5[_0x9307('0x4b')]['id'][_0x9307('0x89')](),_0x9307('0x61'))['field']('\x27'+_0x1b564d+'\x27',_0x9307('0x57'))['field']('\x27'+_0x1b564d+'\x27',_0x9307('0x58'))['from'](_0x9307('0xaa'))['where'](_0x9307('0xb1'))[_0x9307('0x43')](_0x9307('0xab'),_0x534638[_0x9307('0xa8')]['toString']())[_0x9307('0x43')](_0x9307('0xac'))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0x9307('0x80')]()[_0x9307('0x81')]('COALESCE(phone,\x27\x27)')[_0x9307('0x83')](_0x9307('0xa3'))[_0x9307('0x43')](_0x9307('0x86'),_0x1b58c5['params']['id']['toString']())))[_0x9307('0x89')]();break;default:_0x4da62e=squel['insert']()[_0x9307('0xa2')](_0x9307('0xa3'))['fromQuery']([_0x9307('0xa7'),_0x9307('0xa5'),_0x9307('0xa6'),_0x9307('0xa9'),_0x9307('0x61'),_0x9307('0x57'),_0x9307('0x58')],squel['select']()[_0x9307('0x81')](_0x9307('0xa7'),_0x9307('0xa7'))['field']('\x27'+_0x1b564d+'\x27',_0x9307('0xa5'))[_0x9307('0x81')]('id',_0x9307('0xa6'))['field'](_0x534638[_0x9307('0xa8')][_0x9307('0x89')](),_0x9307('0xa9'))['field'](_0x1b58c5[_0x9307('0x4b')]['id'][_0x9307('0x89')](),_0x9307('0x61'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0x57'))['field']('\x27'+_0x1b564d+'\x27','updatedAt')[_0x9307('0x83')](_0x9307('0xaa'))[_0x9307('0x43')](_0x9307('0xb1'))[_0x9307('0x43')](_0x9307('0xab'),_0x534638[_0x9307('0xa8')]['toString']())[_0x9307('0x43')]('phone\x20IS\x20NOT\x20NULL'))['toString']();}_0x25f206[_0x9307('0x88')](db['sequelize'][_0x9307('0x3c')](_0x4da62e));}return BPromise['all'](_0x25f206);}})[_0x9307('0x27')](function(){var _0x7d82bc=[];var _0x21a33b=squel['insert']()[_0x9307('0xa2')](_0x9307('0xb2'))[_0x9307('0xa4')](['CmHopperId',_0x9307('0xa7'),_0x9307('0xb3'),'createdAt',_0x9307('0x58')],squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xb4'))[_0x9307('0x81')](_0x9307('0xb5'))[_0x9307('0x81')](_0x9307('0xb6'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0x57'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27','updatedAt')['from'](_0x9307('0xb7'),'ci')['join']('cm_hopper','h',_0x9307('0xb8'))['where'](_0x9307('0xb9'),_0x1b564d)['where'](_0x9307('0xba'),_0x9307('0xbb')))[_0x9307('0x89')]();_0x7d82bc[_0x9307('0x88')](db[_0x9307('0x72')][_0x9307('0x3c')](_0x21a33b));return BPromise[_0x9307('0x8e')](_0x7d82bc);})[_0x9307('0x27')](function(){return _0x1cd08c;})[_0x9307('0x27')](respondWithResult(_0xa13cd1,null))[_0x9307('0x49')](handleError(_0xa13cd1,null));};exports[_0x9307('0xbc')]=function(_0x4e62f8,_0x40d1c3,_0x33495e){return db['VoiceQueue'][_0x9307('0x52')]({'where':{'id':_0x4e62f8[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x40d1c3,null))['then'](function(_0xc41ba3){if(_0xc41ba3){return _0xc41ba3['removeLists'](_0x4e62f8[_0x9307('0x3c')]['ids']);}})[_0x9307('0x27')](function(_0x116e55){if(_0x116e55){return db[_0x9307('0xbd')][_0x9307('0x26')]({'where':{'ListId':_0x4e62f8[_0x9307('0x3c')][_0x9307('0x7f')],'VoiceQueueId':_0x4e62f8[_0x9307('0x4b')]['id']}})['then'](function(){return _0x116e55;});}})[_0x9307('0x27')](respondWithStatusCode(_0x40d1c3,null))['catch'](handleError(_0x40d1c3,null));};exports[_0x9307('0xbe')]=function(_0x58167e,_0x2abb5e,_0x1a6cd5){var _0x5ec693={};var _0x4e28ed={};var _0x387e30;var _0x37a9ac;return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x58167e[_0x9307('0x4b')]['id']}})['then'](handleEntityNotFound(_0x2abb5e,null))['then'](function(_0x1490ff){if(_0x1490ff){_0x387e30=_0x1490ff;_0x4e28ed[_0x9307('0x3b')]=_[_0x9307('0x3d')](db[_0x9307('0x9c')][_0x9307('0x38')]);_0x4e28ed[_0x9307('0x3c')]=_[_0x9307('0x3d')](_0x58167e['query']);_0x4e28ed['filters']=_[_0x9307('0x3f')](_0x4e28ed[_0x9307('0x3b')],_0x4e28ed[_0x9307('0x3c')]);_0x5ec693['attributes']=_[_0x9307('0x3f')](_0x4e28ed[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x58167e[_0x9307('0x3c')]['fields']));_0x5ec693[_0x9307('0x40')]=_0x5ec693['attributes'][_0x9307('0x4c')]?_0x5ec693[_0x9307('0x40')]:_0x4e28ed['model'];_0x5ec693[_0x9307('0x5f')]=qs[_0x9307('0x60')](_0x58167e[_0x9307('0x3c')][_0x9307('0x60')]);_0x5ec693[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x58167e[_0x9307('0x3c')],_0x4e28ed[_0x9307('0x3e')]));if(_0x58167e[_0x9307('0x3c')][_0x9307('0x2b')]){_0x5ec693['where']=_[_0x9307('0x44')](_0x5ec693['where'],{'$or':_[_0x9307('0x36')](_0x5ec693['attributes'],function(_0x29b0c3){var _0x1fa8c9={};_0x1fa8c9[_0x29b0c3]={'$like':'%'+_0x58167e[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x1fa8c9;})});}_0x5ec693=_[_0x9307('0x44')]({},_0x5ec693,_0x58167e['options']);return _0x387e30[_0x9307('0xbe')](_0x5ec693);}})[_0x9307('0x27')](function(_0x33270c){if(_0x33270c){_0x37a9ac=_0x33270c[_0x9307('0x4c')];if(!_0x58167e[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x5ec693[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x58167e['query']['limit']);_0x5ec693[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x58167e['query']['offset']);}return _0x387e30[_0x9307('0xbe')](_0x5ec693);}})[_0x9307('0x27')](function(_0x4f1234){if(_0x4f1234){return _0x4f1234?{'count':_0x37a9ac,'rows':_0x4f1234}:null;}})[_0x9307('0x27')](respondWithResult(_0x2abb5e,null))[_0x9307('0x49')](handleError(_0x2abb5e,null));};exports[_0x9307('0xbf')]=function(_0x3ac422,_0x31b34e,_0x49774c){var _0x2e6975,_0x1ba90d;return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x3ac422[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x31b34e,null))['then'](function(_0x2ffb3e){if(_0x2ffb3e){_0x1ba90d=_0x2ffb3e;return _0x2ffb3e[_0x9307('0xbf')](_0x3ac422[_0x9307('0x59')][_0x9307('0x7f')],_[_0x9307('0x56')](_0x3ac422[_0x9307('0x59')],['ids','id'])||{});}return null;})[_0x9307('0x95')](function(_0x242835){var _0x13fd0f;_0x2e6975=_0x242835||[];var _0x4b547f=[];if(_0x242835){for(var _0x4c2086=0x0;_0x4c2086<_0x242835[_0x9307('0x4c')];_0x4c2086+=0x1){var _0x29fdf6=_0x242835[_0x4c2086][_0x9307('0x28')]({'plain':!![]});_0x13fd0f=squel[_0x9307('0xa1')]()[_0x9307('0xa2')](_0x9307('0xc0'))['fromQuery']([_0x9307('0xa7'),_0x9307('0xa6'),_0x9307('0xa9'),'VoiceQueueId',_0x9307('0x57'),_0x9307('0x58')],squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xa7'),'phone')[_0x9307('0x81')]('id',_0x9307('0xa6'))[_0x9307('0x81')](_0x29fdf6[_0x9307('0xa8')][_0x9307('0x89')](),_0x9307('0xa9'))[_0x9307('0x81')](_0x3ac422['params']['id'][_0x9307('0x89')](),'VoiceQueueId')[_0x9307('0x81')](_0x9307('0xc1'),_0x9307('0x57'))[_0x9307('0x81')](_0x9307('0xc1'),_0x9307('0x58'))[_0x9307('0x83')](_0x9307('0xaa'))[_0x9307('0x43')]('deletedAt\x20IS\x20NULL')['where']('ListId\x20=\x20?',_0x29fdf6[_0x9307('0xa8')]['toString']())[_0x9307('0x43')](_0x9307('0xac')))[_0x9307('0x89')]();_0x4b547f['push'](db[_0x9307('0x72')][_0x9307('0x3c')](_0x13fd0f));}return BPromise[_0x9307('0x8e')](_0x4b547f);}})['then'](function(){return _0x2e6975;})[_0x9307('0x27')](respondWithResult(_0x31b34e,null))[_0x9307('0x49')](handleError(_0x31b34e,null));};exports[_0x9307('0xc2')]=function(_0x5a9f60,_0x20cb54,_0xfb3a2){return db[_0x9307('0x37')]['find']({'where':{'id':_0x5a9f60['params']['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x20cb54,null))[_0x9307('0x27')](function(_0x4842d4){if(_0x4842d4){return _0x4842d4[_0x9307('0xc2')](_0x5a9f60['query']['ids']);}})[_0x9307('0x27')](function(_0x190875){if(_0x190875){return db['CmHopperBlack'][_0x9307('0x26')]({'where':{'ListId':_0x5a9f60[_0x9307('0x3c')][_0x9307('0x7f')],'VoiceQueueId':_0x5a9f60[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](function(){return _0x190875;});}})['then'](respondWithStatusCode(_0x20cb54,null))['catch'](handleError(_0x20cb54,null));};
\ No newline at end of file