// * 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 _0x393b=['json','count','offset','limit','set','apply','save','update','then','destroy','VoiceQueues','inbound','QueueCampaigns','ignore','map','value','includes','type','UserProfileResource','error','stack','name','send','fieldName','key','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','options','VoiceQueue','includeAll','findAll','catch','show','rawAttributes','include','create','body','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','find','autoAssociation','clone','omit','createdAt','outbound','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','getHoppers','order','pick','VoiceQueueId','CmHopper','getHopperHistories','CmHopperHistory','rows','findOne','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','addTeams','teams','Team','User','Agents','online','voicePause','interface','forEach','penalty','sequelize','transaction','each','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','emit','userVoiceQueue:save','ids','select','field','tq.TeamId','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','toString','SELECT','TeamId','all','union','compact','removeTeams','isEmpty','removeAgents','addAgents','spread','push','format','SIP/%s','isArray','userVoiceQueue:remove','getAgents','getMembers','CmList','getLists','addLists','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','NOW()','CmListId','ListId','updatedAt','from','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','onlyIfOpen','ListId\x20=\x20?','removeLists','getBlackLists','addBlackLists','removeBlackLists','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','querystring','ioredis','../../components/auth/service','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','localhost','socket.io-emitter','./voiceQueue.socket','sendStatus','status'];(function(_0x4b07d8,_0x379f7c){var _0x2eada4=function(_0x2387bf){while(--_0x2387bf){_0x4b07d8['push'](_0x4b07d8['shift']());}};_0x2eada4(++_0x379f7c);}(_0x393b,0x97));var _0xb393=function(_0x44c768,_0x552a5e){_0x44c768=_0x44c768-0x0;var _0x55daf5=_0x393b[_0x44c768];return _0x55daf5;};'use strict';var pdf=require(_0xb393('0x0'));var emlformat=require(_0xb393('0x1'));var rimraf=require(_0xb393('0x2'));var zipdir=require(_0xb393('0x3'));var jsonpatch=require(_0xb393('0x4'));var rp=require(_0xb393('0x5'));var moment=require(_0xb393('0x6'));var BPromise=require(_0xb393('0x7'));var Mustache=require(_0xb393('0x8'));var util=require(_0xb393('0x9'));var path=require(_0xb393('0xa'));var sox=require(_0xb393('0xb'));var csv=require(_0xb393('0xc'));var ejs=require(_0xb393('0xd'));var fs=require('fs');var _=require(_0xb393('0xe'));var squel=require(_0xb393('0xf'));var crypto=require(_0xb393('0x10'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xb393('0xc'));var querystring=require(_0xb393('0x11'));var Papa=require('papaparse');var Redis=require(_0xb393('0x12'));var authService=require(_0xb393('0x13'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xb393('0x14'))(_0xb393('0x15'));var utils=require(_0xb393('0x16'));var config=require(_0xb393('0x17'));var licenseUtil=require(_0xb393('0x18'));var db=require(_0xb393('0x19'))['db'];config[_0xb393('0x1a')]=_['defaults'](config[_0xb393('0x1a')],{'host':_0xb393('0x1b'),'port':0x18eb});var socket=require(_0xb393('0x1c'))(new Redis(config[_0xb393('0x1a')]));require(_0xb393('0x1d'))['register'](socket);function respondWithStatusCode(_0xcaa308,_0x413afb){_0x413afb=_0x413afb||0xcc;return function(_0x22a62e){if(_0x22a62e){return _0xcaa308[_0xb393('0x1e')](_0x413afb);}return _0xcaa308['status'](_0x413afb)['end']();};}function respondWithResult(_0x33d449,_0x290565){_0x290565=_0x290565||0xc8;return function(_0x4180c3){if(_0x4180c3){return _0x33d449[_0xb393('0x1f')](_0x290565)[_0xb393('0x20')](_0x4180c3);}};}function respondWithFilteredResult(_0x2ddd78,_0x31ddc6){return function(_0x34544){if(_0x34544){var _0xc0fa9=_0x34544[_0xb393('0x21')],_0x376ee5=_0x31ddc6[_0xb393('0x22')],_0xf55450=_0x31ddc6[_0xb393('0x22')]+_0x31ddc6[_0xb393('0x23')],_0x3770db;if(_0xf55450>=_0xc0fa9){_0xf55450=_0xc0fa9;_0x3770db=0xc8;}else{_0x3770db=0xce;}_0x2ddd78['status'](_0x3770db);return _0x2ddd78[_0xb393('0x24')]('Content-Range',_0x376ee5+'-'+_0xf55450+'/'+_0xc0fa9)[_0xb393('0x20')](_0x34544);}return null;};}function patchUpdates(_0x331ebd){return function(_0x5198ab){try{jsonpatch[_0xb393('0x25')](_0x5198ab,_0x331ebd,!![]);}catch(_0x197149){return BPromise['reject'](_0x197149);}return _0x5198ab[_0xb393('0x26')]();};}function saveUpdates(_0x20d86e,_0x466d8a){return function(_0x13861d){if(_0x13861d){return _0x13861d[_0xb393('0x27')](_0x20d86e)[_0xb393('0x28')](function(_0x5403a1){return _0x5403a1;});}return null;};}function removeEntity(_0x1b3611,_0x2f26f4){return function(_0x25ee07){if(_0x25ee07){return _0x25ee07[_0xb393('0x29')]()[_0xb393('0x28')](function(){var _0x252d83=_0x25ee07['get']({'plain':!![]});var _0x1ece79=[{'name':_0xb393('0x2a'),'value':_0xb393('0x2b'),'ignore':![]},{'name':_0xb393('0x2c'),'value':'outbound','ignore':![]}];var _0x32d6bd=_(_0x1ece79)['filter'](_0xb393('0x2d'))[_0xb393('0x2e')](_0xb393('0x2f'))[_0xb393('0x2f')]();if(_[_0xb393('0x30')](_0x32d6bd,_0x252d83[_0xb393('0x31')])){return;}var _0x31a7bd=_['find'](_0x1ece79,[_0xb393('0x2f'),_0x252d83[_0xb393('0x31')]])['name'];return db[_0xb393('0x32')][_0xb393('0x29')]({'where':{'type':_0x31a7bd,'resourceId':_0x252d83['id']}})[_0xb393('0x28')](function(){return _0x25ee07;});})[_0xb393('0x28')](function(){_0x1b3611[_0xb393('0x1f')](0xcc)['end']();});}};}function handleEntityNotFound(_0x32bf1f,_0x57071b){return function(_0x31dbc9){if(!_0x31dbc9){_0x32bf1f[_0xb393('0x1e')](0x194);}return _0x31dbc9;};}function handleError(_0x51d4eb,_0x218de3){_0x218de3=_0x218de3||0x1f4;return function(_0x3ddd81){logger[_0xb393('0x33')](_0x3ddd81[_0xb393('0x34')]);if(_0x3ddd81[_0xb393('0x35')]){delete _0x3ddd81[_0xb393('0x35')];}_0x51d4eb[_0xb393('0x1f')](_0x218de3)[_0xb393('0x36')](_0x3ddd81);};}exports['index']=function(_0x3d284a,_0x438a15){var _0x41c178={},_0x4dfcbb={},_0x2a4395={'count':0x0,'rows':[]};var _0x480e22=_[_0xb393('0x2e')](db['VoiceQueue']['rawAttributes'],function(_0x3460fe){return{'name':_0x3460fe[_0xb393('0x37')],'type':_0x3460fe['type'][_0xb393('0x38')]};});_0x4dfcbb['model']=_[_0xb393('0x2e')](_0x480e22,_0xb393('0x35'));_0x4dfcbb[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x3d284a['query']);_0x4dfcbb[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x4dfcbb[_0xb393('0x3d')],_0x4dfcbb[_0xb393('0x39')]);_0x41c178[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x4dfcbb[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x3d284a[_0xb393('0x39')]['fields']));_0x41c178[_0xb393('0x3e')]=_0x41c178[_0xb393('0x3e')][_0xb393('0x40')]?_0x41c178[_0xb393('0x3e')]:_0x4dfcbb[_0xb393('0x3d')];if(!_0x3d284a[_0xb393('0x39')][_0xb393('0x41')](_0xb393('0x42'))){_0x41c178[_0xb393('0x23')]=qs['limit'](_0x3d284a[_0xb393('0x39')]['limit']);_0x41c178[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x3d284a[_0xb393('0x39')]['offset']);}_0x41c178['order']=qs['sort'](_0x3d284a[_0xb393('0x39')][_0xb393('0x43')]);_0x41c178[_0xb393('0x44')]=qs['filters'](_['pick'](_0x3d284a[_0xb393('0x39')],_0x4dfcbb['filters']),_0x480e22);if(_0x3d284a[_0xb393('0x39')][_0xb393('0x45')]){_0x41c178[_0xb393('0x44')]=_[_0xb393('0x46')](_0x41c178[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x480e22,function(_0x222f39){if(_0x222f39['type']!==_0xb393('0x47')){var _0x2b882e={};_0x2b882e[_0x222f39['name']]={'$like':'%'+_0x3d284a[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x2b882e;}})});}_0x41c178=_[_0xb393('0x46')]({},_0x41c178,_0x3d284a[_0xb393('0x48')]);var _0x5f5048={'where':_0x41c178[_0xb393('0x44')]};return db[_0xb393('0x49')]['count'](_0x5f5048)[_0xb393('0x28')](function(_0x5568cf){_0x2a4395[_0xb393('0x21')]=_0x5568cf;if(_0x3d284a[_0xb393('0x39')][_0xb393('0x4a')]){_0x41c178['include']=[{'all':!![]}];}return db['VoiceQueue'][_0xb393('0x4b')](_0x41c178);})[_0xb393('0x28')](function(_0x559482){_0x2a4395['rows']=_0x559482;return _0x2a4395;})[_0xb393('0x28')](respondWithFilteredResult(_0x438a15,_0x41c178))[_0xb393('0x4c')](handleError(_0x438a15,null));};exports[_0xb393('0x4d')]=function(_0x50afdb,_0x2e8064){var _0x171b88={'raw':![],'where':{'id':_0x50afdb['params']['id']}},_0x1e8e27={};_0x1e8e27[_0xb393('0x3d')]=_[_0xb393('0x3a')](db[_0xb393('0x49')][_0xb393('0x4e')]);_0x1e8e27[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x50afdb[_0xb393('0x39')]);_0x1e8e27[_0xb393('0x3b')]=_['intersection'](_0x1e8e27[_0xb393('0x3d')],_0x1e8e27[_0xb393('0x39')]);_0x171b88['attributes']=_['intersection'](_0x1e8e27[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x50afdb[_0xb393('0x39')][_0xb393('0x3f')]));_0x171b88[_0xb393('0x3e')]=_0x171b88[_0xb393('0x3e')][_0xb393('0x40')]?_0x171b88[_0xb393('0x3e')]:_0x1e8e27[_0xb393('0x3d')];if(_0x50afdb[_0xb393('0x39')][_0xb393('0x4a')]){_0x171b88[_0xb393('0x4f')]=[{'all':!![]}];}_0x171b88=_['merge']({},_0x171b88,_0x50afdb['options']);return db[_0xb393('0x49')]['find'](_0x171b88)[_0xb393('0x28')](handleEntityNotFound(_0x2e8064,null))[_0xb393('0x28')](respondWithResult(_0x2e8064,null))[_0xb393('0x4c')](handleError(_0x2e8064,null));};exports[_0xb393('0x50')]=function(_0x166aa3,_0x150be9){return db['VoiceQueue'][_0xb393('0x50')](_0x166aa3[_0xb393('0x51')],{})[_0xb393('0x28')](function(_0x360cf1){var _0x194677=_0x166aa3['user'][_0xb393('0x52')]({'plain':!![]});if(!_0x194677)throw new Error(_0xb393('0x53'));if(_0x194677[_0xb393('0x54')]===_0xb393('0x55')){var _0x4db6a0=_0x360cf1['get']({'plain':!![]});var _0x56fdd5=[{'name':_0xb393('0x2a'),'value':_0xb393('0x2b')},{'name':_0xb393('0x2c'),'value':'outbound'}];var _0x3f0fa5=_['find'](_0x56fdd5,[_0xb393('0x2f'),_0x4db6a0[_0xb393('0x31')]])[_0xb393('0x35')];return db[_0xb393('0x56')][_0xb393('0x57')]({'where':{'name':_0x3f0fa5,'userProfileId':_0x194677['userProfileId']},'raw':!![]})[_0xb393('0x28')](function(_0x3f510e){if(_0x3f510e&&_0x3f510e[_0xb393('0x58')]===0x0){return db[_0xb393('0x32')][_0xb393('0x50')]({'name':_0x4db6a0[_0xb393('0x35')],'resourceId':_0x4db6a0['id'],'type':_0x3f510e[_0xb393('0x35')],'sectionId':_0x3f510e['id']},{})[_0xb393('0x28')](function(){return _0x360cf1;});}else{return _0x360cf1;}})[_0xb393('0x4c')](function(_0x38f5c3){logger[_0xb393('0x33')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x38f5c3);throw _0x38f5c3;});}return _0x360cf1;})[_0xb393('0x28')](respondWithResult(_0x150be9,0xc9))[_0xb393('0x4c')](handleError(_0x150be9,null));};exports[_0xb393('0x59')]=function(_0x540df2,_0x2cdd4a){var _0x3e3742={'where':{'id':_0x540df2['params']['id']}},_0x52ded4={};_0x52ded4[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['VoiceQueue']['rawAttributes']);_0x3e3742[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x52ded4[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x540df2['query']['fields']));_0x3e3742[_0xb393('0x3e')]=_0x3e3742[_0xb393('0x3e')][_0xb393('0x40')]?_0x3e3742[_0xb393('0x3e')]:_0x52ded4[_0xb393('0x3d')];if(_0x540df2[_0xb393('0x39')]['includeAll']){_0x3e3742['include']=[{'all':!![]}];}_0x3e3742=_[_0xb393('0x46')]({},_0x3e3742,_0x540df2[_0xb393('0x48')]);return db[_0xb393('0x49')]['find'](_0x3e3742)['then'](handleEntityNotFound(_0x2cdd4a,null))['then'](function(_0x38a7ad){if(_0x38a7ad){var _0x33dbfe=_0x38a7ad[_0xb393('0x52')]({'plain':!![]});_0x33dbfe=qs[_0xb393('0x5a')](_0x33dbfe,['id',_0xb393('0x5b'),'updatedAt']);_0x540df2[_0xb393('0x51')]=_[_0xb393('0x5a')](_0x540df2['body'],['id',_0xb393('0x5b'),'updatedAt']);return db['VoiceQueue'][_0xb393('0x50')](_['merge'](_0x33dbfe,_0x540df2[_0xb393('0x51')]),{'include':_0x540df2[_0xb393('0x39')]['includeAll']?[{'all':!![]}]:undefined})[_0xb393('0x28')](function(_0x56f883){var _0x16c4b1=_0x540df2['user'][_0xb393('0x52')]({'plain':!![]});if(!_0x16c4b1)throw new Error(_0xb393('0x53'));if(_0x16c4b1[_0xb393('0x54')]===_0xb393('0x55')){var _0x5c2183=_0x56f883[_0xb393('0x52')]({'plain':!![]});var _0x3c817d=[{'name':_0xb393('0x2a'),'value':_0xb393('0x2b')},{'name':_0xb393('0x2c'),'value':_0xb393('0x5c')}];var _0x36c102=_[_0xb393('0x57')](_0x3c817d,[_0xb393('0x2f'),_0x5c2183[_0xb393('0x31')]])[_0xb393('0x35')];return db[_0xb393('0x56')][_0xb393('0x57')]({'where':{'name':_0x36c102,'userProfileId':_0x16c4b1['userProfileId']},'raw':!![]})['then'](function(_0x2f4667){if(_0x2f4667&&_0x2f4667[_0xb393('0x58')]===0x0){return db[_0xb393('0x32')][_0xb393('0x50')]({'name':_0x5c2183[_0xb393('0x35')],'resourceId':_0x5c2183['id'],'type':_0x2f4667[_0xb393('0x35')],'sectionId':_0x2f4667['id']},{})[_0xb393('0x28')](function(){return _0x56f883;});}else{return _0x56f883;}})['catch'](function(_0x158960){logger[_0xb393('0x33')](_0xb393('0x5d'),_0x158960);throw _0x158960;});}return _0x56f883;});}})[_0xb393('0x28')](respondWithResult(_0x2cdd4a,0xc9))[_0xb393('0x4c')](handleError(_0x2cdd4a,null));};exports[_0xb393('0x27')]=function(_0x29c195,_0x11d944){if(_0x29c195[_0xb393('0x51')]['id']){delete _0x29c195[_0xb393('0x51')]['id'];}return db['VoiceQueue'][_0xb393('0x57')]({'where':{'id':_0x29c195['params']['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x11d944,null))['then'](saveUpdates(_0x29c195[_0xb393('0x51')],null))[_0xb393('0x28')](respondWithResult(_0x11d944,null))[_0xb393('0x4c')](handleError(_0x11d944,null));};exports[_0xb393('0x29')]=function(_0x12506e,_0x16d780){return db['VoiceQueue']['find']({'where':{'id':_0x12506e[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x16d780,null))[_0xb393('0x28')](removeEntity(_0x16d780,null))[_0xb393('0x4c')](handleError(_0x16d780,null));};exports[_0xb393('0x5f')]=function(_0x10ed9b,_0x38e920,_0x37c2b5){var _0x3cb28d={'raw':![],'where':{}};var _0x12684b={};var _0x527ea1={'count':0x0,'rows':[]};return db[_0xb393('0x49')]['findOne']({'where':{'id':_0x10ed9b['params']['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x38e920,null))[_0xb393('0x28')](function(_0x4ae395){if(_0x4ae395){_0x12684b[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['CmHopper'][_0xb393('0x4e')]);_0x12684b[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x10ed9b['query']);_0x12684b[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x12684b['model'],_0x12684b['query']);_0x3cb28d[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x12684b[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x10ed9b[_0xb393('0x39')][_0xb393('0x3f')]));_0x3cb28d[_0xb393('0x3e')]=_0x3cb28d[_0xb393('0x3e')][_0xb393('0x40')]?_0x3cb28d['attributes']:_0x12684b['model'];if(!_0x10ed9b[_0xb393('0x39')]['hasOwnProperty'](_0xb393('0x42'))){_0x3cb28d[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x10ed9b['query'][_0xb393('0x23')]);_0x3cb28d[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x10ed9b['query'][_0xb393('0x22')]);}_0x3cb28d[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x10ed9b[_0xb393('0x39')]['sort']);_0x3cb28d[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x10ed9b[_0xb393('0x39')],_0x12684b[_0xb393('0x3b')]));_0x3cb28d[_0xb393('0x44')][_0xb393('0x62')]=_0x4ae395['id'];if(_0x10ed9b[_0xb393('0x39')][_0xb393('0x45')]){_0x3cb28d['where']=_['merge'](_0x3cb28d['where'],{'$or':_[_0xb393('0x2e')](_0x3cb28d[_0xb393('0x3e')],function(_0x5e2aa2){var _0x3f62e4={};_0x3f62e4[_0x5e2aa2]={'$like':'%'+_0x10ed9b[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x3f62e4;})});}_0x3cb28d=_[_0xb393('0x46')]({},_0x3cb28d,_0x10ed9b[_0xb393('0x48')]);return db[_0xb393('0x63')]['count']({'where':_0x3cb28d[_0xb393('0x44')]})[_0xb393('0x28')](function(_0x3c4dc9){_0x527ea1['count']=_0x3c4dc9;if(_0x10ed9b[_0xb393('0x39')][_0xb393('0x4a')]){_0x3cb28d['include']=[{'all':!![]}];}return db[_0xb393('0x63')][_0xb393('0x4b')](_0x3cb28d);})[_0xb393('0x28')](function(_0x5e47fa){_0x527ea1['rows']=_0x5e47fa;return _0x527ea1;});}})[_0xb393('0x28')](respondWithFilteredResult(_0x38e920,_0x3cb28d))[_0xb393('0x4c')](handleError(_0x38e920,null));};exports[_0xb393('0x64')]=function(_0x1323a0,_0x411d0a,_0x7adaf3){var _0x1d6889={'raw':!![],'where':{}};var _0x55ab15={};var _0x1d7b9f={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x1323a0[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x411d0a,null))['then'](function(_0x3ea8af){if(_0x3ea8af){_0x55ab15['model']=_['keys'](db[_0xb393('0x65')][_0xb393('0x4e')]);_0x55ab15['query']=_[_0xb393('0x3a')](_0x1323a0['query']);_0x55ab15[_0xb393('0x3b')]=_['intersection'](_0x55ab15[_0xb393('0x3d')],_0x55ab15[_0xb393('0x39')]);_0x1d6889[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x55ab15[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x1323a0[_0xb393('0x39')][_0xb393('0x3f')]));_0x1d6889[_0xb393('0x3e')]=_0x1d6889[_0xb393('0x3e')][_0xb393('0x40')]?_0x1d6889[_0xb393('0x3e')]:_0x55ab15[_0xb393('0x3d')];if(!_0x1323a0[_0xb393('0x39')][_0xb393('0x41')](_0xb393('0x42'))){_0x1d6889[_0xb393('0x23')]=qs['limit'](_0x1323a0[_0xb393('0x39')][_0xb393('0x23')]);_0x1d6889['offset']=qs[_0xb393('0x22')](_0x1323a0[_0xb393('0x39')]['offset']);}_0x1d6889[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x1323a0[_0xb393('0x39')][_0xb393('0x43')]);_0x1d6889['where']=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x1323a0[_0xb393('0x39')],_0x55ab15[_0xb393('0x3b')]));_0x1d6889['where'][_0xb393('0x62')]=_0x3ea8af['id'];if(_0x1323a0[_0xb393('0x39')][_0xb393('0x45')]){_0x1d6889[_0xb393('0x44')]=_[_0xb393('0x46')](_0x1d6889[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x1d6889['attributes'],function(_0x3ebf4f){var _0x24e788={};_0x24e788[_0x3ebf4f]={'$like':'%'+_0x1323a0[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x24e788;})});}_0x1d6889=_[_0xb393('0x46')]({},_0x1d6889,_0x1323a0['options']);return db[_0xb393('0x65')][_0xb393('0x21')]({'where':_0x1d6889[_0xb393('0x44')]})[_0xb393('0x28')](function(_0x3be61d){_0x1d7b9f[_0xb393('0x21')]=_0x3be61d;if(_0x1323a0[_0xb393('0x39')][_0xb393('0x4a')]){_0x1d6889[_0xb393('0x4f')]=[{'all':!![]}];}return db[_0xb393('0x65')]['findAll'](_0x1d6889);})[_0xb393('0x28')](function(_0x28c00b){_0x1d7b9f[_0xb393('0x66')]=_0x28c00b;return _0x1d7b9f;});}})[_0xb393('0x28')](respondWithFilteredResult(_0x411d0a,_0x1d6889))[_0xb393('0x4c')](handleError(_0x411d0a,null));};exports['getHopperFinals']=function(_0x332005,_0x47ecc2,_0x41bac3){var _0x231c9b={'raw':!![],'where':{}};var _0x434c0b={};var _0xb4c029={'count':0x0,'rows':[]};return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x332005[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x47ecc2,null))['then'](function(_0x3db029){if(_0x3db029){_0x434c0b[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['CmHopperFinal'][_0xb393('0x4e')]);_0x434c0b['query']=_[_0xb393('0x3a')](_0x332005[_0xb393('0x39')]);_0x434c0b[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x434c0b['model'],_0x434c0b['query']);_0x231c9b[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x434c0b[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x332005['query'][_0xb393('0x3f')]));_0x231c9b[_0xb393('0x3e')]=_0x231c9b[_0xb393('0x3e')]['length']?_0x231c9b[_0xb393('0x3e')]:_0x434c0b[_0xb393('0x3d')];if(!_0x332005['query'][_0xb393('0x41')](_0xb393('0x42'))){_0x231c9b[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x332005[_0xb393('0x39')][_0xb393('0x23')]);_0x231c9b[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x332005['query'][_0xb393('0x22')]);}_0x231c9b[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x332005[_0xb393('0x39')][_0xb393('0x43')]);_0x231c9b[_0xb393('0x44')]=qs['filters'](_['pick'](_0x332005[_0xb393('0x39')],_0x434c0b[_0xb393('0x3b')]));_0x231c9b[_0xb393('0x44')][_0xb393('0x62')]=_0x3db029['id'];if(_0x332005[_0xb393('0x39')]['filter']){_0x231c9b[_0xb393('0x44')]=_[_0xb393('0x46')](_0x231c9b['where'],{'$or':_[_0xb393('0x2e')](_0x231c9b['attributes'],function(_0x55328c){var _0x1ca382={};_0x1ca382[_0x55328c]={'$like':'%'+_0x332005[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x1ca382;})});}_0x231c9b=_[_0xb393('0x46')]({},_0x231c9b,_0x332005[_0xb393('0x48')]);return db['CmHopperFinal'][_0xb393('0x21')]({'where':_0x231c9b[_0xb393('0x44')]})[_0xb393('0x28')](function(_0x571cb2){_0xb4c029['count']=_0x571cb2;if(_0x332005['query'][_0xb393('0x4a')]){_0x231c9b[_0xb393('0x4f')]=[{'all':!![]}];}return db[_0xb393('0x68')][_0xb393('0x4b')](_0x231c9b);})['then'](function(_0x75ae24){_0xb4c029[_0xb393('0x66')]=_0x75ae24;return _0xb4c029;});}})[_0xb393('0x28')](respondWithFilteredResult(_0x47ecc2,_0x231c9b))[_0xb393('0x4c')](handleError(_0x47ecc2,null));};exports[_0xb393('0x69')]=function(_0x7ebf69,_0x368bc9,_0x514588){var _0x1f3ff0={'raw':!![],'where':{}};var _0x51a715={};var _0x34756a={'count':0x0,'rows':[]};return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x7ebf69[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x368bc9,null))[_0xb393('0x28')](function(_0x3afe2c){if(_0x3afe2c){_0x51a715[_0xb393('0x3d')]=_[_0xb393('0x3a')](db[_0xb393('0x6a')][_0xb393('0x4e')]);_0x51a715[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x7ebf69['query']);_0x51a715[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x51a715[_0xb393('0x3d')],_0x51a715['query']);_0x1f3ff0[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x51a715[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x7ebf69[_0xb393('0x39')]['fields']));_0x1f3ff0[_0xb393('0x3e')]=_0x1f3ff0[_0xb393('0x3e')][_0xb393('0x40')]?_0x1f3ff0['attributes']:_0x51a715[_0xb393('0x3d')];if(!_0x7ebf69[_0xb393('0x39')]['hasOwnProperty'](_0xb393('0x42'))){_0x1f3ff0[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x7ebf69[_0xb393('0x39')][_0xb393('0x23')]);_0x1f3ff0[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x7ebf69[_0xb393('0x39')][_0xb393('0x22')]);}_0x1f3ff0['order']=qs['sort'](_0x7ebf69[_0xb393('0x39')][_0xb393('0x43')]);_0x1f3ff0['where']=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x7ebf69[_0xb393('0x39')],_0x51a715[_0xb393('0x3b')]));_0x1f3ff0[_0xb393('0x44')][_0xb393('0x62')]=_0x3afe2c['id'];if(_0x7ebf69[_0xb393('0x39')][_0xb393('0x45')]){_0x1f3ff0['where']=_[_0xb393('0x46')](_0x1f3ff0['where'],{'$or':_[_0xb393('0x2e')](_0x1f3ff0['attributes'],function(_0x5052ef){var _0x35a2a0={};_0x35a2a0[_0x5052ef]={'$like':'%'+_0x7ebf69[_0xb393('0x39')]['filter']+'%'};return _0x35a2a0;})});}_0x1f3ff0=_['merge']({},_0x1f3ff0,_0x7ebf69[_0xb393('0x48')]);return db[_0xb393('0x6a')][_0xb393('0x21')]({'where':_0x1f3ff0['where']})[_0xb393('0x28')](function(_0x1e9252){_0x34756a[_0xb393('0x21')]=_0x1e9252;if(_0x7ebf69[_0xb393('0x39')][_0xb393('0x4a')]){_0x1f3ff0[_0xb393('0x4f')]=[{'all':!![]}];}return db[_0xb393('0x6a')][_0xb393('0x4b')](_0x1f3ff0);})[_0xb393('0x28')](function(_0x5b8748){_0x34756a[_0xb393('0x66')]=_0x5b8748;return _0x34756a;});}})[_0xb393('0x28')](respondWithFilteredResult(_0x368bc9,_0x1f3ff0))[_0xb393('0x4c')](handleError(_0x368bc9,null));};exports[_0xb393('0x6b')]=function(_0x30dba2,_0x50b5f1,_0x4e42ae){var _0x41986d={};var _0x12c5dc={};var _0x1b5020;var _0x5a6636;return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x30dba2[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x50b5f1,null))['then'](function(_0x592033){if(_0x592033){_0x1b5020=_0x592033;_0x12c5dc[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['Team'][_0xb393('0x4e')]);_0x12c5dc['query']=_[_0xb393('0x3a')](_0x30dba2[_0xb393('0x39')]);_0x12c5dc[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x12c5dc['model'],_0x12c5dc['query']);_0x41986d[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x12c5dc['model'],qs[_0xb393('0x3f')](_0x30dba2[_0xb393('0x39')][_0xb393('0x3f')]));_0x41986d['attributes']=_0x41986d['attributes']['length']?_0x41986d[_0xb393('0x3e')]:_0x12c5dc['model'];_0x41986d[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x30dba2[_0xb393('0x39')][_0xb393('0x43')]);_0x41986d[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x30dba2[_0xb393('0x39')],_0x12c5dc[_0xb393('0x3b')]));if(_0x30dba2[_0xb393('0x39')][_0xb393('0x45')]){_0x41986d[_0xb393('0x44')]=_[_0xb393('0x46')](_0x41986d[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x41986d[_0xb393('0x3e')],function(_0x37b388){var _0x2890fb={};_0x2890fb[_0x37b388]={'$like':'%'+_0x30dba2['query'][_0xb393('0x45')]+'%'};return _0x2890fb;})});}_0x41986d=_[_0xb393('0x46')]({},_0x41986d,_0x30dba2['options']);return _0x1b5020[_0xb393('0x6b')](_0x41986d);}})[_0xb393('0x28')](function(_0x14b50f){if(_0x14b50f){_0x5a6636=_0x14b50f['length'];if(!_0x30dba2[_0xb393('0x39')]['hasOwnProperty'](_0xb393('0x42'))){_0x41986d[_0xb393('0x23')]=qs['limit'](_0x30dba2[_0xb393('0x39')]['limit']);_0x41986d['offset']=qs[_0xb393('0x22')](_0x30dba2[_0xb393('0x39')][_0xb393('0x22')]);}return _0x1b5020[_0xb393('0x6b')](_0x41986d);}})[_0xb393('0x28')](function(_0x66ae05){if(_0x66ae05){return _0x66ae05?{'count':_0x5a6636,'rows':_0x66ae05}:null;}})[_0xb393('0x28')](respondWithResult(_0x50b5f1,null))['catch'](handleError(_0x50b5f1,null));};exports[_0xb393('0x6c')]=function(_0x2a70e3,_0x481d7c,_0x46709f){var _0x48da15=_0x2a70e3['body'][_0xb393('0x6d')];var _0x4e5419=_[_0xb393('0x2e')](_0x48da15,'id');return db[_0xb393('0x6e')][_0xb393('0x4b')]({'where':{'id':_0x4e5419},'attributes':['id'],'include':[{'model':db[_0xb393('0x6f')],'as':_0xb393('0x70'),'attributes':['id',_0xb393('0x35'),_0xb393('0x71'),_0xb393('0x72'),_0xb393('0x73')],'raw':!![]}]})[_0xb393('0x28')](function(_0x1b1b2b){if(_0x1b1b2b){var _0x32829d=_['flatMap'](_0x1b1b2b,function(_0x230016){var _0x260335=_0x230016['get']({'plain':!![]});_0x260335[_0xb393('0x70')][_0xb393('0x74')](function(_0x5ca6cd){_0x5ca6cd[_0xb393('0x75')]=_[_0xb393('0x57')](_0x48da15,{'id':_0x260335['id']})['penalty'];});return _0x260335[_0xb393('0x70')];});return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0x2a70e3[_0xb393('0x5e')]['id']}})['then'](function(_0x28f71d){return db[_0xb393('0x76')][_0xb393('0x77')](function(_0x317399){return _0x28f71d[_0xb393('0x6c')](_0x4e5419,{'transaction':_0x317399})['then'](function(){return BPromise[_0xb393('0x78')](_0x48da15,function(_0x2f3aa1){return db['TeamVoiceQueue'][_0xb393('0x79')]({'TeamId':_0x2f3aa1['id'],'VoiceQueueId':_0x2a70e3[_0xb393('0x5e')]['id'],'penalty':_0x2f3aa1[_0xb393('0x75')]},{'transaction':_0x317399});});})[_0xb393('0x28')](function(){return BPromise[_0xb393('0x78')](_0x32829d,function(_0x55d50e){return db[_0xb393('0x7a')][_0xb393('0x7b')]({'where':{'UserId':_0x55d50e['id'],'VoiceQueueId':_0x2a70e3[_0xb393('0x5e')]['id']},'defaults':{'penalty':_0x55d50e[_0xb393('0x75')]},'transaction':_0x317399});});})[_0xb393('0x28')](function(){return BPromise['each'](_[_0xb393('0x45')](_0x32829d,{'online':!![]}),function(_0xda2c91){return db[_0xb393('0x7c')][_0xb393('0x79')]({'membername':_0xda2c91[_0xb393('0x35')],'UserId':_0xda2c91['id'],'queue_name':_0x28f71d[_0xb393('0x35')],'VoiceQueueId':_0x28f71d['id'],'interface':_[_0xb393('0x7d')](_0xda2c91[_0xb393('0x73')])?util['format']('SIP/%s',_0xda2c91['name']):_0xda2c91['interface'],'paused':_0xda2c91[_0xb393('0x72')]||![],'penalty':_0xda2c91[_0xb393('0x75')]},{'transaction':_0x317399});});})[_0xb393('0x28')](function(){_0x32829d[_0xb393('0x74')](function(_0x3fdb4f){socket[_0xb393('0x7e')](_0xb393('0x7f'),{'UserId':_0x3fdb4f['id'],'VoiceQueueId':_0x28f71d['id']});});});});});}})[_0xb393('0x28')](respondWithStatusCode(_0x481d7c,null))[_0xb393('0x4c')](handleError(_0x481d7c,null));};exports['removeTeams']=function(_0x301c46,_0x5e2d5b,_0x291451){return db['Team'][_0xb393('0x4b')]({'where':{'id':_0x301c46[_0xb393('0x39')][_0xb393('0x80')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0xb393('0x70'),'attributes':['id'],'raw':!![]}]})[_0xb393('0x28')](handleEntityNotFound(_0x5e2d5b,null))[_0xb393('0x28')](function(_0x42c26c){var _0x48be64=_[_0xb393('0x2e')](_0x42c26c,'id');var _0x55afe6=[];var _0x2a0243=[];var _0x4412ec=squel[_0xb393('0x81')]();_0x4412ec[_0xb393('0x82')](_0xb393('0x83'))['from'](_0xb393('0x84'),'tq')[_0xb393('0x85')](_0xb393('0x86'),'ut',_0xb393('0x87'))['where'](_0xb393('0x88'),_0x301c46[_0xb393('0x5e')]['id']);for(var _0x3aa9b4=0x0;_0x3aa9b4<_0x42c26c[_0xb393('0x40')];_0x3aa9b4+=0x1){let _0x1dd99d=_0x42c26c[_0x3aa9b4];for(var _0x59dc2f=0x0;_0x59dc2f<_0x1dd99d[_0xb393('0x70')][_0xb393('0x40')];_0x59dc2f+=0x1){let _0x15eb3b=_0x1dd99d[_0xb393('0x70')][_0x59dc2f];var _0x43ecd0=_0x4412ec[_0xb393('0x59')]();_0x43ecd0[_0xb393('0x44')](_0xb393('0x89'),_0x15eb3b['id']);_0x2a0243['push'](db[_0xb393('0x76')]['query'](_0x43ecd0[_0xb393('0x8a')](),{'type':db[_0xb393('0x76')]['QueryTypes'][_0xb393('0x8b')]})[_0xb393('0x28')](function(_0x3c43bd){if(_0x3c43bd[_0xb393('0x40')]===0x1){return _0x15eb3b['id'];}else{var _0xee6ecd=_['every'](_['map'](_0x3c43bd,_0xb393('0x8c')),function(_0x104fcd){return _['includes'](_0x48be64,_0x104fcd);});if(_0xee6ecd){return _0x15eb3b['id'];}}}));}}return BPromise[_0xb393('0x8d')](_0x2a0243)['then'](function(_0x597730){_0x55afe6=_(_0x55afe6)[_0xb393('0x8e')](_0x597730)[_0xb393('0x8f')]()[_0xb393('0x2f')]();return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0x301c46[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](function(_0x39f85b){return db[_0xb393('0x76')][_0xb393('0x77')](function(_0x4de0fb){return _0x39f85b[_0xb393('0x90')](_0x301c46['query']['ids'],{'transaction':_0x4de0fb})[_0xb393('0x28')](function(){if(!_[_0xb393('0x91')](_0x55afe6)){return _0x39f85b[_0xb393('0x92')](_0x55afe6,{'transaction':_0x4de0fb})[_0xb393('0x28')](function(){return db['UserVoiceQueueRt'][_0xb393('0x29')]({'where':{'VoiceQueueId':_0x301c46['params']['id'],'UserId':_0x55afe6},'transaction':_0x4de0fb});});}})[_0xb393('0x28')](function(){_0x55afe6[_0xb393('0x74')](function(_0x3dc43e){socket[_0xb393('0x7e')]('userVoiceQueue:remove',{'UserId':_0x3dc43e,'VoiceQueueId':_0x39f85b['id']});});});});});});})[_0xb393('0x28')](respondWithStatusCode(_0x5e2d5b,null))['catch'](handleError(_0x5e2d5b,null));};exports[_0xb393('0x93')]=function(_0x511e18,_0x471df3,_0x87bc9){var _0x13aae1,_0xfd024b;return db[_0xb393('0x49')]['find']({'where':{'id':_0x511e18[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x471df3,null))['then'](function(_0x1122e8){if(_0x1122e8){_0xfd024b=_0x1122e8;return _0x1122e8[_0xb393('0x93')](_0x511e18[_0xb393('0x51')][_0xb393('0x80')],_[_0xb393('0x5a')](_0x511e18[_0xb393('0x51')],[_0xb393('0x80'),'id'])||{})[_0xb393('0x94')](function(_0x5a7dc8){for(var _0x4e08be=0x0;_0x4e08be<_0x511e18[_0xb393('0x51')][_0xb393('0x80')]['length'];_0x4e08be+=0x1){socket[_0xb393('0x7e')](_0xb393('0x7f'),{'UserId':_0x511e18[_0xb393('0x51')]['ids'][_0x4e08be],'VoiceQueueId':_0x511e18['params']['id']});}return _0x5a7dc8;});}})[_0xb393('0x28')](function(_0x505e3c){_0x13aae1=_0x505e3c||[];if(_0xfd024b){return db[_0xb393('0x6f')][_0xb393('0x4b')]({'where':{'id':_0x511e18['body'][_0xb393('0x80')]},'attributes':['id','name',_0xb393('0x71'),_0xb393('0x72'),'interface'],'raw':!![]});}})[_0xb393('0x28')](function(_0xc5be2b){if(!_[_0xb393('0x91')](_0xc5be2b)){var _0x3ef40e=[];for(var _0x838a65=0x0;_0x838a65<_0xc5be2b[_0xb393('0x40')];_0x838a65++){if(_0xc5be2b[_0x838a65]['online']){_0x3ef40e[_0xb393('0x95')](db[_0xb393('0x7c')]['upsert']({'membername':_0xc5be2b[_0x838a65]['name'],'UserId':_0xc5be2b[_0x838a65]['id'],'queue_name':_0xfd024b['name'],'VoiceQueueId':_0xfd024b['id'],'interface':_[_0xb393('0x7d')](_0xc5be2b[_0x838a65]['interface'])?util[_0xb393('0x96')](_0xb393('0x97'),_0xc5be2b[_0x838a65]['name']):_0xc5be2b[_0x838a65][_0xb393('0x73')],'paused':_0xc5be2b[_0x838a65][_0xb393('0x72')]||![],'penalty':_0x511e18[_0xb393('0x51')][_0xb393('0x75')]||0x0}));}}return BPromise[_0xb393('0x8d')](_0x3ef40e);}})[_0xb393('0x28')](function(){return _0x13aae1;})['then'](respondWithResult(_0x471df3,null))[_0xb393('0x4c')](handleError(_0x471df3,null));};exports[_0xb393('0x92')]=function(_0xa8b888,_0x3836b2,_0x6b1f59){return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0xa8b888[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x3836b2,null))[_0xb393('0x28')](function(_0x4492ae){if(_0x4492ae){return _0x4492ae['removeAgents'](_0xa8b888[_0xb393('0x39')]['ids'])[_0xb393('0x28')](function(){if(_[_0xb393('0x98')](_0xa8b888[_0xb393('0x39')]['ids'])){for(var _0x4ec18e=0x0;_0x4ec18e<_0xa8b888[_0xb393('0x39')]['ids']['length'];_0x4ec18e+=0x1){socket['emit'](_0xb393('0x99'),{'UserId':Number(_0xa8b888['query'][_0xb393('0x80')][_0x4ec18e]),'VoiceQueueId':Number(_0xa8b888['params']['id'])});}}else{socket[_0xb393('0x7e')](_0xb393('0x99'),{'UserId':Number(_0xa8b888['query'][_0xb393('0x80')]),'VoiceQueueId':Number(_0xa8b888[_0xb393('0x5e')]['id'])});}});}})[_0xb393('0x28')](function(_0x43d7dc){return db[_0xb393('0x7c')][_0xb393('0x29')]({'where':{'VoiceQueueId':_0xa8b888[_0xb393('0x5e')]['id'],'UserId':_0xa8b888[_0xb393('0x39')][_0xb393('0x80')]}})[_0xb393('0x28')](function(){return _0x43d7dc;});})[_0xb393('0x28')](respondWithStatusCode(_0x3836b2,null))[_0xb393('0x4c')](handleError(_0x3836b2,null));};exports[_0xb393('0x9a')]=function(_0x2214f9,_0x3f7802,_0x1e9330){var _0x2e67dc={};var _0x2f88a2={};var _0x322d6f;var _0x1e65b7;return db[_0xb393('0x49')]['findOne']({'where':{'id':_0x2214f9[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x3f7802,null))[_0xb393('0x28')](function(_0xa9e40f){if(_0xa9e40f){_0x322d6f=_0xa9e40f;_0x2f88a2[_0xb393('0x3d')]=_['keys'](db[_0xb393('0x6f')][_0xb393('0x4e')]);_0x2f88a2[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x2214f9['query']);_0x2f88a2[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x2f88a2[_0xb393('0x3d')],_0x2f88a2[_0xb393('0x39')]);_0x2e67dc[_0xb393('0x3e')]=_['intersection'](_0x2f88a2[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x2214f9[_0xb393('0x39')][_0xb393('0x3f')]));_0x2e67dc[_0xb393('0x3e')]=_0x2e67dc['attributes'][_0xb393('0x40')]?_0x2e67dc[_0xb393('0x3e')]:_0x2f88a2['model'];_0x2e67dc[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x2214f9[_0xb393('0x39')][_0xb393('0x43')]);_0x2e67dc[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x2214f9[_0xb393('0x39')],_0x2f88a2[_0xb393('0x3b')]));if(_0x2214f9['query'][_0xb393('0x45')]){_0x2e67dc['where']=_[_0xb393('0x46')](_0x2e67dc[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x2e67dc[_0xb393('0x3e')],function(_0x2d2ca7){var _0x47c6da={};_0x47c6da[_0x2d2ca7]={'$like':'%'+_0x2214f9[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x47c6da;})});}_0x2e67dc=_['merge']({},_0x2e67dc,_0x2214f9[_0xb393('0x48')]);return _0x322d6f[_0xb393('0x9a')](_0x2e67dc);}})[_0xb393('0x28')](function(_0x25425e){if(_0x25425e){_0x1e65b7=_0x25425e[_0xb393('0x40')];if(!_0x2214f9[_0xb393('0x39')][_0xb393('0x41')](_0xb393('0x42'))){_0x2e67dc[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x2214f9['query'][_0xb393('0x23')]);_0x2e67dc[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x2214f9['query'][_0xb393('0x22')]);}return _0x322d6f[_0xb393('0x9a')](_0x2e67dc);}})[_0xb393('0x28')](function(_0x50acb2){if(_0x50acb2){return _0x50acb2?{'count':_0x1e65b7,'rows':_0x50acb2}:null;}})[_0xb393('0x28')](respondWithResult(_0x3f7802,null))[_0xb393('0x4c')](handleError(_0x3f7802,null));};exports[_0xb393('0x9b')]=function(_0x5802a0,_0x4fd994,_0x270804){var _0x37d882={};var _0x42221f={};var _0x4cd0ca;var _0x31e419;return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x5802a0[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x4fd994,null))[_0xb393('0x28')](function(_0x4286a1){if(_0x4286a1){_0x4cd0ca=_0x4286a1;_0x42221f[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['UserVoiceQueueRt'][_0xb393('0x4e')]);_0x42221f[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x5802a0[_0xb393('0x39')]);_0x42221f[_0xb393('0x3b')]=_['intersection'](_0x42221f[_0xb393('0x3d')],_0x42221f[_0xb393('0x39')]);_0x37d882['attributes']=_[_0xb393('0x3c')](_0x42221f[_0xb393('0x3d')],qs['fields'](_0x5802a0['query'][_0xb393('0x3f')]));_0x37d882['attributes']=_0x37d882[_0xb393('0x3e')][_0xb393('0x40')]?_0x37d882[_0xb393('0x3e')]:_0x42221f[_0xb393('0x3d')];_0x37d882[_0xb393('0x60')]=qs['sort'](_0x5802a0[_0xb393('0x39')][_0xb393('0x43')]);_0x37d882['where']=qs['filters'](_['pick'](_0x5802a0[_0xb393('0x39')],_0x42221f[_0xb393('0x3b')]));if(_0x5802a0['query'][_0xb393('0x45')]){_0x37d882[_0xb393('0x44')]=_[_0xb393('0x46')](_0x37d882['where'],{'$or':_[_0xb393('0x2e')](_0x37d882['attributes'],function(_0x343b03){var _0x4ac4e9={};_0x4ac4e9[_0x343b03]={'$like':'%'+_0x5802a0[_0xb393('0x39')]['filter']+'%'};return _0x4ac4e9;})});}_0x37d882=_[_0xb393('0x46')]({},_0x37d882,_0x5802a0[_0xb393('0x48')]);return _0x4cd0ca[_0xb393('0x9b')](_0x37d882);}})[_0xb393('0x28')](function(_0x4ca685){if(_0x4ca685){_0x31e419=_0x4ca685['length'];if(!_0x5802a0[_0xb393('0x39')]['hasOwnProperty']('nolimit')){_0x37d882[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x5802a0['query'][_0xb393('0x23')]);_0x37d882[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x5802a0[_0xb393('0x39')]['offset']);}return _0x4cd0ca[_0xb393('0x9b')](_0x37d882);}})[_0xb393('0x28')](function(_0x563685){return _0x563685?{'count':_0x31e419,'rows':_0x563685}:null;})[_0xb393('0x28')](respondWithResult(_0x4fd994,null))[_0xb393('0x4c')](handleError(_0x4fd994,null));};exports['getLists']=function(_0x532190,_0x39c559,_0x4eaf15){var _0x2b330d={};var _0xd67292={};var _0x5ead19;var _0x2f93db;return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x532190[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x39c559,null))[_0xb393('0x28')](function(_0x2fe39d){if(_0x2fe39d){_0x5ead19=_0x2fe39d;_0xd67292['model']=_['keys'](db[_0xb393('0x9c')][_0xb393('0x4e')]);_0xd67292[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x532190[_0xb393('0x39')]);_0xd67292[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0xd67292[_0xb393('0x3d')],_0xd67292[_0xb393('0x39')]);_0x2b330d[_0xb393('0x3e')]=_['intersection'](_0xd67292[_0xb393('0x3d')],qs['fields'](_0x532190[_0xb393('0x39')]['fields']));_0x2b330d[_0xb393('0x3e')]=_0x2b330d[_0xb393('0x3e')]['length']?_0x2b330d[_0xb393('0x3e')]:_0xd67292['model'];_0x2b330d[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x532190[_0xb393('0x39')][_0xb393('0x43')]);_0x2b330d[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x532190[_0xb393('0x39')],_0xd67292[_0xb393('0x3b')]));if(_0x532190[_0xb393('0x39')]['filter']){_0x2b330d['where']=_['merge'](_0x2b330d[_0xb393('0x44')],{'$or':_['map'](_0x2b330d[_0xb393('0x3e')],function(_0x23d1f9){var _0x17756d={};_0x17756d[_0x23d1f9]={'$like':'%'+_0x532190[_0xb393('0x39')]['filter']+'%'};return _0x17756d;})});}_0x2b330d=_[_0xb393('0x46')]({},_0x2b330d,_0x532190[_0xb393('0x48')]);return _0x5ead19[_0xb393('0x9d')](_0x2b330d);}})[_0xb393('0x28')](function(_0x529296){if(_0x529296){_0x2f93db=_0x529296[_0xb393('0x40')];if(!_0x532190['query'][_0xb393('0x41')](_0xb393('0x42'))){_0x2b330d[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x532190[_0xb393('0x39')][_0xb393('0x23')]);_0x2b330d['offset']=qs[_0xb393('0x22')](_0x532190['query']['offset']);}return _0x5ead19[_0xb393('0x9d')](_0x2b330d);}})[_0xb393('0x28')](function(_0x1730a9){if(_0x1730a9){return _0x1730a9?{'count':_0x2f93db,'rows':_0x1730a9}:null;}})['then'](respondWithResult(_0x39c559,null))['catch'](handleError(_0x39c559,null));};exports[_0xb393('0x9e')]=function(_0x520585,_0x1e1479,_0x3d52d0){var _0x435feb,_0x3d8091;return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0x520585[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x1e1479,null))[_0xb393('0x28')](function(_0x205059){if(_0x205059){_0x3d8091=_0x205059;return _0x205059[_0xb393('0x9e')](_0x520585[_0xb393('0x51')][_0xb393('0x80')],_[_0xb393('0x5a')](_0x520585[_0xb393('0x51')],['ids','id'])||{});}return null;})[_0xb393('0x94')](function(_0x1df4d5){var _0x24b255;_0x435feb=_0x1df4d5||[];var _0x448923=[];if(_0x1df4d5){for(var _0x21764e=0x0;_0x21764e<_0x1df4d5[_0xb393('0x40')];_0x21764e+=0x1){var _0x4212a5=_0x1df4d5[_0x21764e][_0xb393('0x52')]({'plain':!![]});_0x3d8091[_0xb393('0x9f')]=_0x520585['body'][_0xb393('0x9f')]?_0x520585['body']['dialCheckDuplicateType']:_0x3d8091[_0xb393('0x9f')];switch(_0x3d8091[_0xb393('0x9f')]){case'always':_0x24b255=squel[_0xb393('0xa0')]()[_0xb393('0xa1')](_0xb393('0xa2'))[_0xb393('0xa3')]([_0xb393('0xa4'),_0xb393('0xa5'),_0xb393('0xa6'),'ListId','VoiceQueueId',_0xb393('0x5b'),'updatedAt'],squel[_0xb393('0x81')]()[_0xb393('0x82')](_0xb393('0xa4'),'phone')[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0xa5'))[_0xb393('0x82')]('id',_0xb393('0xa6'))[_0xb393('0x82')](_0x4212a5[_0xb393('0xa8')][_0xb393('0x8a')](),_0xb393('0xa9'))[_0xb393('0x82')](_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')](),_0xb393('0x62'))['field'](_0xb393('0xa7'),'createdAt')[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0xaa'))[_0xb393('0xab')](_0xb393('0xac'))[_0xb393('0x44')](_0xb393('0xad'))[_0xb393('0x44')]('ListId\x20=\x20?',_0x4212a5['CmListId'][_0xb393('0x8a')]())[_0xb393('0x44')](_0xb393('0xae'))[_0xb393('0x44')](_0xb393('0xaf'),squel[_0xb393('0x81')]()[_0xb393('0x82')](_0xb393('0xb0'))[_0xb393('0xab')]('cm_hopper_final')[_0xb393('0x44')](_0xb393('0x88'),_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')]()))[_0xb393('0x44')](_0xb393('0xaf'),squel['select']()[_0xb393('0x82')]('COALESCE(phone,\x27\x27)')['from'](_0xb393('0xa2'))[_0xb393('0x44')]('VoiceQueueId\x20=\x20?',_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')]())))[_0xb393('0x8a')]();break;case _0xb393('0xb1'):_0x24b255=squel[_0xb393('0xa0')]()[_0xb393('0xa1')](_0xb393('0xa2'))['fromQuery']([_0xb393('0xa4'),_0xb393('0xa5'),_0xb393('0xa6'),'ListId',_0xb393('0x62'),'createdAt',_0xb393('0xaa')],squel[_0xb393('0x81')]()[_0xb393('0x82')](_0xb393('0xa4'),_0xb393('0xa4'))['field'](_0xb393('0xa7'),_0xb393('0xa5'))[_0xb393('0x82')]('id',_0xb393('0xa6'))['field'](_0x4212a5[_0xb393('0xa8')]['toString'](),_0xb393('0xa9'))[_0xb393('0x82')](_0x520585[_0xb393('0x5e')]['id']['toString'](),_0xb393('0x62'))[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0x5b'))[_0xb393('0x82')]('NOW()',_0xb393('0xaa'))[_0xb393('0xab')](_0xb393('0xac'))[_0xb393('0x44')](_0xb393('0xad'))['where']('ListId\x20=\x20?',_0x4212a5['CmListId']['toString']())['where'](_0xb393('0xae'))[_0xb393('0x44')](_0xb393('0xaf'),squel[_0xb393('0x81')]()[_0xb393('0x82')]('COALESCE(phone,\x27\x27)')['from'](_0xb393('0xa2'))[_0xb393('0x44')](_0xb393('0x88'),_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')]())))[_0xb393('0x8a')]();break;default:_0x24b255=squel[_0xb393('0xa0')]()[_0xb393('0xa1')](_0xb393('0xa2'))[_0xb393('0xa3')]([_0xb393('0xa4'),_0xb393('0xa5'),_0xb393('0xa6'),_0xb393('0xa9'),'VoiceQueueId','createdAt','updatedAt'],squel['select']()[_0xb393('0x82')](_0xb393('0xa4'),_0xb393('0xa4'))['field'](_0xb393('0xa7'),_0xb393('0xa5'))[_0xb393('0x82')]('id',_0xb393('0xa6'))[_0xb393('0x82')](_0x4212a5[_0xb393('0xa8')][_0xb393('0x8a')](),'ListId')[_0xb393('0x82')](_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')](),_0xb393('0x62'))[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0x5b'))['field'](_0xb393('0xa7'),_0xb393('0xaa'))[_0xb393('0xab')]('cm_contacts')[_0xb393('0x44')](_0xb393('0xad'))['where'](_0xb393('0xb2'),_0x4212a5[_0xb393('0xa8')][_0xb393('0x8a')]())[_0xb393('0x44')](_0xb393('0xae')))[_0xb393('0x8a')]();}_0x448923[_0xb393('0x95')](db[_0xb393('0x76')][_0xb393('0x39')](_0x24b255));}return BPromise[_0xb393('0x8d')](_0x448923);}})[_0xb393('0x28')](function(){return _0x435feb;})[_0xb393('0x28')](respondWithResult(_0x1e1479,null))[_0xb393('0x4c')](handleError(_0x1e1479,null));};exports['removeLists']=function(_0x45d3ed,_0x340221,_0x25656b){return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0x45d3ed[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x340221,null))['then'](function(_0x3e8090){if(_0x3e8090){return _0x3e8090[_0xb393('0xb3')](_0x45d3ed['query']['ids']);}})[_0xb393('0x28')](function(_0x23b66f){if(_0x23b66f){return db[_0xb393('0x63')]['destroy']({'where':{'ListId':_0x45d3ed[_0xb393('0x39')][_0xb393('0x80')],'VoiceQueueId':_0x45d3ed[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](function(){return _0x23b66f;});}})['then'](respondWithStatusCode(_0x340221,null))[_0xb393('0x4c')](handleError(_0x340221,null));};exports[_0xb393('0xb4')]=function(_0x5f1658,_0x25150f,_0x4ecbb4){var _0x7a6dc2={};var _0x1c0965={};var _0x571f40;var _0x127cab;return db['VoiceQueue']['findOne']({'where':{'id':_0x5f1658[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x25150f,null))['then'](function(_0x1d6e37){if(_0x1d6e37){_0x571f40=_0x1d6e37;_0x1c0965[_0xb393('0x3d')]=_[_0xb393('0x3a')](db[_0xb393('0x9c')][_0xb393('0x4e')]);_0x1c0965[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x5f1658[_0xb393('0x39')]);_0x1c0965[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x1c0965[_0xb393('0x3d')],_0x1c0965['query']);_0x7a6dc2[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x1c0965[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x5f1658['query'][_0xb393('0x3f')]));_0x7a6dc2[_0xb393('0x3e')]=_0x7a6dc2[_0xb393('0x3e')][_0xb393('0x40')]?_0x7a6dc2[_0xb393('0x3e')]:_0x1c0965[_0xb393('0x3d')];_0x7a6dc2[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x5f1658[_0xb393('0x39')]['sort']);_0x7a6dc2[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x5f1658[_0xb393('0x39')],_0x1c0965[_0xb393('0x3b')]));if(_0x5f1658[_0xb393('0x39')]['filter']){_0x7a6dc2['where']=_[_0xb393('0x46')](_0x7a6dc2[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x7a6dc2[_0xb393('0x3e')],function(_0x3bb622){var _0x160497={};_0x160497[_0x3bb622]={'$like':'%'+_0x5f1658[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x160497;})});}_0x7a6dc2=_['merge']({},_0x7a6dc2,_0x5f1658[_0xb393('0x48')]);return _0x571f40[_0xb393('0xb4')](_0x7a6dc2);}})[_0xb393('0x28')](function(_0x405908){if(_0x405908){_0x127cab=_0x405908[_0xb393('0x40')];if(!_0x5f1658['query'][_0xb393('0x41')](_0xb393('0x42'))){_0x7a6dc2[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x5f1658[_0xb393('0x39')][_0xb393('0x23')]);_0x7a6dc2[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x5f1658[_0xb393('0x39')][_0xb393('0x22')]);}return _0x571f40['getBlackLists'](_0x7a6dc2);}})[_0xb393('0x28')](function(_0x567cc1){if(_0x567cc1){return _0x567cc1?{'count':_0x127cab,'rows':_0x567cc1}:null;}})[_0xb393('0x28')](respondWithResult(_0x25150f,null))[_0xb393('0x4c')](handleError(_0x25150f,null));};exports[_0xb393('0xb5')]=function(_0x4a4ca6,_0xbc7e4a,_0x169ecf){var _0x4e2f72,_0x1aa2b2;return db['VoiceQueue'][_0xb393('0x57')]({'where':{'id':_0x4a4ca6[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0xbc7e4a,null))[_0xb393('0x28')](function(_0x18b230){if(_0x18b230){_0x1aa2b2=_0x18b230;return _0x18b230[_0xb393('0xb5')](_0x4a4ca6[_0xb393('0x51')]['ids'],_['omit'](_0x4a4ca6[_0xb393('0x51')],[_0xb393('0x80'),'id'])||{});}return null;})[_0xb393('0x94')](function(_0x5c898b){var _0x58381e;_0x4e2f72=_0x5c898b||[];var _0x3a39f6=[];if(_0x5c898b){for(var _0x30335b=0x0;_0x30335b<_0x5c898b[_0xb393('0x40')];_0x30335b+=0x1){var _0x3d9fc7=_0x5c898b[_0x30335b][_0xb393('0x52')]({'plain':!![]});_0x58381e=squel['insert']()[_0xb393('0xa1')]('cm_hopper_black')[_0xb393('0xa3')](['phone',_0xb393('0xa6'),_0xb393('0xa9'),_0xb393('0x62'),'createdAt',_0xb393('0xaa')],squel[_0xb393('0x81')]()['field'](_0xb393('0xa4'),_0xb393('0xa4'))['field']('id',_0xb393('0xa6'))['field'](_0x3d9fc7[_0xb393('0xa8')]['toString'](),_0xb393('0xa9'))['field'](_0x4a4ca6[_0xb393('0x5e')]['id']['toString'](),_0xb393('0x62'))[_0xb393('0x82')]('NOW()',_0xb393('0x5b'))[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0xaa'))['from'](_0xb393('0xac'))[_0xb393('0x44')]('deletedAt\x20IS\x20NULL')['where']('ListId\x20=\x20?',_0x3d9fc7[_0xb393('0xa8')][_0xb393('0x8a')]())['where'](_0xb393('0xae')))[_0xb393('0x8a')]();_0x3a39f6[_0xb393('0x95')](db[_0xb393('0x76')]['query'](_0x58381e));}return BPromise[_0xb393('0x8d')](_0x3a39f6);}})[_0xb393('0x28')](function(){return _0x4e2f72;})[_0xb393('0x28')](respondWithResult(_0xbc7e4a,null))[_0xb393('0x4c')](handleError(_0xbc7e4a,null));};exports['removeBlackLists']=function(_0xd9d963,_0x174ad0,_0x401aaa){return db['VoiceQueue'][_0xb393('0x57')]({'where':{'id':_0xd9d963[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x174ad0,null))['then'](function(_0x540ef7){if(_0x540ef7){return _0x540ef7[_0xb393('0xb6')](_0xd9d963[_0xb393('0x39')][_0xb393('0x80')]);}})[_0xb393('0x28')](function(_0x498f17){if(_0x498f17){return db[_0xb393('0x6a')][_0xb393('0x29')]({'where':{'ListId':_0xd9d963[_0xb393('0x39')][_0xb393('0x80')],'VoiceQueueId':_0xd9d963[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](function(){return _0x498f17;});}})['then'](respondWithStatusCode(_0x174ad0,null))[_0xb393('0x4c')](handleError(_0x174ad0,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff