// * 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 _0x07d7=['stack','send','index','VoiceQueue','rawAttributes','key','model','keys','query','filters','attributes','intersection','fields','nolimit','order','sort','where','pick','merge','options','includeAll','include','findAll','catch','show','params','length','find','body','role','user','UserProfileSection','autoAssociation','create','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','userProfileId','getHoppers','CmHopper','hasOwnProperty','VoiceQueueId','rows','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','teams','User','Agents','penalty','sequelize','transaction','TeamVoiceQueue','upsert','each','UserVoiceQueue','findOrCreate','isNil','interface','format','voicePause','emit','userVoiceQueue:save','removeTeams','ids','select','field','tq.TeamId','from','team_has_voice_queues','join','VoiceQueueId\x20=\x20?','push','toString','SELECT','TeamId','all','union','compact','isEmpty','removeAgents','UserVoiceQueueRt','userVoiceQueue:remove','addAgents','online','SIP/%s','isArray','getAgents','getMembers','getLists','CmList','YYYY-MM-DD\x20HH:mm:ss','addLists','spread','dialCheckDuplicateType','always','cm_hopper','scheduledAt','ContactId','ListId','phone','CmListId','updatedAt','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','cm_hopper_final','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','insert','into','cm_contacts','deletedAt\x20IS\x20NULL','cm_hopper_additional_phones','fromQuery','OrderBy','ci.item','ci.OrderBy+1','h.ContactId=ci.CmContactId','h.scheduledat=?','ci.ItemClass=?','removeLists','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','defaults','redis','localhost','register','sendStatus','end','status','json','offset','limit','undefined','count','set','Content-Range','save','update','destroy','then','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','map','value','includes','type','name','UserProfileResource','error'];(function(_0x33505b,_0x1517b6){var _0x89a416=function(_0x84db75){while(--_0x84db75){_0x33505b['push'](_0x33505b['shift']());}};_0x89a416(++_0x1517b6);}(_0x07d7,0x85));var _0x707d=function(_0x725b8e,_0xc22b48){_0x725b8e=_0x725b8e-0x0;var _0x43ac45=_0x07d7[_0x725b8e];return _0x43ac45;};'use strict';var emlformat=require(_0x707d('0x0'));var rimraf=require(_0x707d('0x1'));var zipdir=require(_0x707d('0x2'));var jsonpatch=require(_0x707d('0x3'));var rp=require(_0x707d('0x4'));var moment=require(_0x707d('0x5'));var BPromise=require(_0x707d('0x6'));var Mustache=require(_0x707d('0x7'));var util=require(_0x707d('0x8'));var path=require(_0x707d('0x9'));var sox=require(_0x707d('0xa'));var csv=require(_0x707d('0xb'));var ejs=require(_0x707d('0xc'));var fs=require('fs');var fs_extra=require(_0x707d('0xd'));var _=require(_0x707d('0xe'));var squel=require(_0x707d('0xf'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x707d('0x10'));var toCsv=require(_0x707d('0xb'));var querystring=require(_0x707d('0x11'));var Papa=require(_0x707d('0x12'));var Redis=require(_0x707d('0x13'));var authService=require('../../components/auth/service');var qs=require(_0x707d('0x14'));var as=require(_0x707d('0x15'));var hardwareService=require(_0x707d('0x16'));var logger=require('../../config/logger')(_0x707d('0x17'));var utils=require(_0x707d('0x18'));var config=require(_0x707d('0x19'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config['redis']=_[_0x707d('0x1a')](config[_0x707d('0x1b')],{'host':_0x707d('0x1c'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x707d('0x1b')]));require('./voiceQueue.socket')[_0x707d('0x1d')](socket);function respondWithStatusCode(_0x42e27f,_0x509ec8){_0x509ec8=_0x509ec8||0xcc;return function(_0x4d598e){if(_0x4d598e){return _0x42e27f[_0x707d('0x1e')](_0x509ec8);}return _0x42e27f['status'](_0x509ec8)[_0x707d('0x1f')]();};}function respondWithResult(_0x2c63c9,_0xeed67d){_0xeed67d=_0xeed67d||0xc8;return function(_0x1f4f0e){if(_0x1f4f0e){return _0x2c63c9[_0x707d('0x20')](_0xeed67d)[_0x707d('0x21')](_0x1f4f0e);}};}function respondWithFilteredResult(_0x318251,_0x50869d){return function(_0x1d3fe6){if(_0x1d3fe6){var _0x275a7b=typeof _0x50869d[_0x707d('0x22')]==='undefined'&&typeof _0x50869d[_0x707d('0x23')]===_0x707d('0x24');var _0xf5375f=_0x1d3fe6[_0x707d('0x25')];var _0x81f93f=_0x275a7b?0x0:_0x50869d[_0x707d('0x22')];var _0xb7171a=_0x275a7b?_0x1d3fe6[_0x707d('0x25')]:_0x50869d[_0x707d('0x22')]+_0x50869d[_0x707d('0x23')];var _0x2da0c0;if(_0xb7171a>=_0xf5375f){_0xb7171a=_0xf5375f;_0x2da0c0=0xc8;}else{_0x2da0c0=0xce;}_0x318251[_0x707d('0x20')](_0x2da0c0);return _0x318251[_0x707d('0x26')](_0x707d('0x27'),_0x81f93f+'-'+_0xb7171a+'/'+_0xf5375f)[_0x707d('0x21')](_0x1d3fe6);}return null;};}function patchUpdates(_0x30d175){return function(_0x1ce813){try{jsonpatch['apply'](_0x1ce813,_0x30d175,!![]);}catch(_0x24ba23){return BPromise['reject'](_0x24ba23);}return _0x1ce813[_0x707d('0x28')]();};}function saveUpdates(_0x139ad5,_0x8810fe){return function(_0x1a5e03){if(_0x1a5e03){return _0x1a5e03[_0x707d('0x29')](_0x139ad5)['then'](function(_0x115e5c){return _0x115e5c;});}return null;};}function removeEntity(_0x5b2db7,_0x3760bb){return function(_0x26741e){if(_0x26741e){return _0x26741e[_0x707d('0x2a')]()[_0x707d('0x2b')](function(){var _0x40551d=_0x26741e[_0x707d('0x2c')]({'plain':!![]});var _0x38b4fe=[{'name':_0x707d('0x2d'),'value':_0x707d('0x2e'),'ignore':![]},{'name':_0x707d('0x2f'),'value':_0x707d('0x30'),'ignore':![]}];var _0x4274e9=_(_0x38b4fe)[_0x707d('0x31')](_0x707d('0x32'))[_0x707d('0x33')](_0x707d('0x34'))['value']();if(_[_0x707d('0x35')](_0x4274e9,_0x40551d[_0x707d('0x36')])){return;}var _0x1784ce=_['find'](_0x38b4fe,['value',_0x40551d['type']])[_0x707d('0x37')];return db[_0x707d('0x38')][_0x707d('0x2a')]({'where':{'type':_0x1784ce,'resourceId':_0x40551d['id']}})[_0x707d('0x2b')](function(){return _0x26741e;});})[_0x707d('0x2b')](function(){_0x5b2db7[_0x707d('0x20')](0xcc)[_0x707d('0x1f')]();});}};}function handleEntityNotFound(_0x3734be,_0xd310cc){return function(_0x43ec7a){if(!_0x43ec7a){_0x3734be[_0x707d('0x1e')](0x194);}return _0x43ec7a;};}function handleError(_0x455841,_0x54a0f3){_0x54a0f3=_0x54a0f3||0x1f4;return function(_0x39bb5f){logger[_0x707d('0x39')](_0x39bb5f[_0x707d('0x3a')]);if(_0x39bb5f[_0x707d('0x37')]){delete _0x39bb5f[_0x707d('0x37')];}_0x455841['status'](_0x54a0f3)[_0x707d('0x3b')](_0x39bb5f);};}exports[_0x707d('0x3c')]=function(_0x4d2051,_0x325bd9){var _0x260b2={},_0x299460={},_0x425e2e={'count':0x0,'rows':[]};var _0x247aa8=_[_0x707d('0x33')](db[_0x707d('0x3d')][_0x707d('0x3e')],function(_0x19e6a7){return{'name':_0x19e6a7['fieldName'],'type':_0x19e6a7[_0x707d('0x36')][_0x707d('0x3f')]};});_0x299460[_0x707d('0x40')]=_[_0x707d('0x33')](_0x247aa8,_0x707d('0x37'));_0x299460['query']=_[_0x707d('0x41')](_0x4d2051[_0x707d('0x42')]);_0x299460[_0x707d('0x43')]=_['intersection'](_0x299460[_0x707d('0x40')],_0x299460['query']);_0x260b2[_0x707d('0x44')]=_[_0x707d('0x45')](_0x299460[_0x707d('0x40')],qs[_0x707d('0x46')](_0x4d2051['query']['fields']));_0x260b2[_0x707d('0x44')]=_0x260b2[_0x707d('0x44')]['length']?_0x260b2['attributes']:_0x299460[_0x707d('0x40')];if(!_0x4d2051['query']['hasOwnProperty'](_0x707d('0x47'))){_0x260b2[_0x707d('0x23')]=qs[_0x707d('0x23')](_0x4d2051[_0x707d('0x42')][_0x707d('0x23')]);_0x260b2['offset']=qs[_0x707d('0x22')](_0x4d2051[_0x707d('0x42')][_0x707d('0x22')]);}_0x260b2[_0x707d('0x48')]=qs[_0x707d('0x49')](_0x4d2051[_0x707d('0x42')][_0x707d('0x49')]);_0x260b2[_0x707d('0x4a')]=qs[_0x707d('0x43')](_[_0x707d('0x4b')](_0x4d2051[_0x707d('0x42')],_0x299460['filters']),_0x247aa8);if(_0x4d2051[_0x707d('0x42')][_0x707d('0x31')]){_0x260b2['where']=_[_0x707d('0x4c')](_0x260b2[_0x707d('0x4a')],{'$or':_[_0x707d('0x33')](_0x247aa8,function(_0x8183a9){if(_0x8183a9[_0x707d('0x36')]!=='VIRTUAL'){var _0x1f90af={};_0x1f90af[_0x8183a9[_0x707d('0x37')]]={'$like':'%'+_0x4d2051[_0x707d('0x42')][_0x707d('0x31')]+'%'};return _0x1f90af;}})});}_0x260b2=_[_0x707d('0x4c')]({},_0x260b2,_0x4d2051[_0x707d('0x4d')]);var _0x93aacd={'where':_0x260b2[_0x707d('0x4a')]};return db[_0x707d('0x3d')]['count'](_0x93aacd)[_0x707d('0x2b')](function(_0x59b928){_0x425e2e[_0x707d('0x25')]=_0x59b928;if(_0x4d2051[_0x707d('0x42')][_0x707d('0x4e')]){_0x260b2[_0x707d('0x4f')]=[{'all':!![]}];}return db[_0x707d('0x3d')][_0x707d('0x50')](_0x260b2);})[_0x707d('0x2b')](function(_0x8bf45a){_0x425e2e['rows']=_0x8bf45a;return _0x425e2e;})[_0x707d('0x2b')](respondWithFilteredResult(_0x325bd9,_0x260b2))[_0x707d('0x51')](handleError(_0x325bd9,null));};exports[_0x707d('0x52')]=function(_0x3f9c77,_0xe5c80b){var _0x225dde={'raw':![],'where':{'id':_0x3f9c77[_0x707d('0x53')]['id']}},_0x5d6590={};_0x5d6590[_0x707d('0x40')]=_[_0x707d('0x41')](db[_0x707d('0x3d')][_0x707d('0x3e')]);_0x5d6590[_0x707d('0x42')]=_['keys'](_0x3f9c77['query']);_0x5d6590[_0x707d('0x43')]=_[_0x707d('0x45')](_0x5d6590['model'],_0x5d6590[_0x707d('0x42')]);_0x225dde[_0x707d('0x44')]=_[_0x707d('0x45')](_0x5d6590[_0x707d('0x40')],qs['fields'](_0x3f9c77[_0x707d('0x42')][_0x707d('0x46')]));_0x225dde[_0x707d('0x44')]=_0x225dde['attributes'][_0x707d('0x54')]?_0x225dde[_0x707d('0x44')]:_0x5d6590['model'];if(_0x3f9c77[_0x707d('0x42')]['includeAll']){_0x225dde['include']=[{'all':!![]}];}_0x225dde=_['merge']({},_0x225dde,_0x3f9c77[_0x707d('0x4d')]);return db[_0x707d('0x3d')][_0x707d('0x55')](_0x225dde)[_0x707d('0x2b')](handleEntityNotFound(_0xe5c80b,null))[_0x707d('0x2b')](respondWithResult(_0xe5c80b,null))[_0x707d('0x51')](handleError(_0xe5c80b,null));};exports['create']=function(_0x439281,_0x2f4627){return db['VoiceQueue']['create'](_0x439281[_0x707d('0x56')],{})['then'](function(_0x17c0df){var _0x1582e4=_0x439281['user'][_0x707d('0x2c')]({'plain':!![]});if(!_0x1582e4)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1582e4[_0x707d('0x57')]===_0x707d('0x58')){var _0x1c540c=_0x17c0df[_0x707d('0x2c')]({'plain':!![]});var _0x32fd36=[{'name':'VoiceQueues','value':_0x707d('0x2e')},{'name':_0x707d('0x2f'),'value':_0x707d('0x30')}];var _0x4f7081=_[_0x707d('0x55')](_0x32fd36,['value',_0x1c540c[_0x707d('0x36')]])[_0x707d('0x37')];return db[_0x707d('0x59')]['find']({'where':{'name':_0x4f7081,'userProfileId':_0x1582e4['userProfileId']},'raw':!![]})[_0x707d('0x2b')](function(_0x211c37){if(_0x211c37&&_0x211c37[_0x707d('0x5a')]===0x0){return db[_0x707d('0x38')][_0x707d('0x5b')]({'name':_0x1c540c[_0x707d('0x37')],'resourceId':_0x1c540c['id'],'type':_0x211c37[_0x707d('0x37')],'sectionId':_0x211c37['id']},{})[_0x707d('0x2b')](function(){return _0x17c0df;});}else{return _0x17c0df;}})['catch'](function(_0x475dbc){logger[_0x707d('0x39')](_0x707d('0x5c'),_0x475dbc);throw _0x475dbc;});}return _0x17c0df;})[_0x707d('0x2b')](respondWithResult(_0x2f4627,0xc9))[_0x707d('0x51')](handleError(_0x2f4627,null));};exports[_0x707d('0x5d')]=function(_0x20ed5f,_0x20c101){var _0x1b8b5a={'where':{'id':_0x20ed5f[_0x707d('0x53')]['id']}},_0x90c5c4={};_0x90c5c4[_0x707d('0x40')]=_[_0x707d('0x41')](db[_0x707d('0x3d')][_0x707d('0x3e')]);_0x1b8b5a[_0x707d('0x44')]=_['intersection'](_0x90c5c4[_0x707d('0x40')],qs[_0x707d('0x46')](_0x20ed5f[_0x707d('0x42')][_0x707d('0x46')]));_0x1b8b5a[_0x707d('0x44')]=_0x1b8b5a['attributes'][_0x707d('0x54')]?_0x1b8b5a[_0x707d('0x44')]:_0x90c5c4[_0x707d('0x40')];if(_0x20ed5f[_0x707d('0x42')][_0x707d('0x4e')]){_0x1b8b5a[_0x707d('0x4f')]=[{'all':!![]}];}_0x1b8b5a=_[_0x707d('0x4c')]({},_0x1b8b5a,_0x20ed5f['options']);return db[_0x707d('0x3d')]['find'](_0x1b8b5a)[_0x707d('0x2b')](handleEntityNotFound(_0x20c101,null))[_0x707d('0x2b')](function(_0x4aaaff){if(_0x4aaaff){var _0x2f8869=_0x4aaaff[_0x707d('0x2c')]({'plain':!![]});_0x2f8869=qs[_0x707d('0x5e')](_0x2f8869,['id',_0x707d('0x5f'),'updatedAt']);_0x20ed5f[_0x707d('0x56')]=_[_0x707d('0x5e')](_0x20ed5f[_0x707d('0x56')],['id',_0x707d('0x5f'),'updatedAt']);return db[_0x707d('0x3d')]['create'](_[_0x707d('0x4c')](_0x2f8869,_0x20ed5f['body']),{'include':_0x20ed5f[_0x707d('0x42')][_0x707d('0x4e')]?[{'all':!![]}]:undefined})['then'](function(_0x278483){var _0x592953=_0x20ed5f[_0x707d('0x58')][_0x707d('0x2c')]({'plain':!![]});if(!_0x592953)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x592953[_0x707d('0x57')]===_0x707d('0x58')){var _0x4ab11d=_0x278483[_0x707d('0x2c')]({'plain':!![]});var _0x4eba16=[{'name':_0x707d('0x2d'),'value':_0x707d('0x2e')},{'name':_0x707d('0x2f'),'value':_0x707d('0x30')}];var _0x30b5cb=_[_0x707d('0x55')](_0x4eba16,[_0x707d('0x34'),_0x4ab11d[_0x707d('0x36')]])[_0x707d('0x37')];return db[_0x707d('0x59')][_0x707d('0x55')]({'where':{'name':_0x30b5cb,'userProfileId':_0x592953[_0x707d('0x60')]},'raw':!![]})[_0x707d('0x2b')](function(_0x5ea54f){if(_0x5ea54f&&_0x5ea54f['autoAssociation']===0x0){return db[_0x707d('0x38')]['create']({'name':_0x4ab11d[_0x707d('0x37')],'resourceId':_0x4ab11d['id'],'type':_0x5ea54f[_0x707d('0x37')],'sectionId':_0x5ea54f['id']},{})[_0x707d('0x2b')](function(){return _0x278483;});}else{return _0x278483;}})[_0x707d('0x51')](function(_0xfbe3c0){logger[_0x707d('0x39')](_0x707d('0x5c'),_0xfbe3c0);throw _0xfbe3c0;});}return _0x278483;});}})['then'](respondWithResult(_0x20c101,0xc9))['catch'](handleError(_0x20c101,null));};exports['update']=function(_0x7d7fac,_0x5179eb){if(_0x7d7fac[_0x707d('0x56')]['id']){delete _0x7d7fac[_0x707d('0x56')]['id'];}return db['VoiceQueue'][_0x707d('0x55')]({'where':{'id':_0x7d7fac[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x5179eb,null))[_0x707d('0x2b')](saveUpdates(_0x7d7fac[_0x707d('0x56')],null))[_0x707d('0x2b')](respondWithResult(_0x5179eb,null))[_0x707d('0x51')](handleError(_0x5179eb,null));};exports[_0x707d('0x2a')]=function(_0x2c4f59,_0x1ff192){return db['VoiceQueue']['find']({'where':{'id':_0x2c4f59[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x1ff192,null))[_0x707d('0x2b')](removeEntity(_0x1ff192,null))[_0x707d('0x51')](handleError(_0x1ff192,null));};exports[_0x707d('0x61')]=function(_0x1c2dcf,_0x4a8fbb,_0xf71ac){var _0x5a15aa={'raw':![],'where':{}};var _0x4d2578={};var _0x424a6e={'count':0x0,'rows':[]};return db[_0x707d('0x3d')]['findOne']({'where':{'id':_0x1c2dcf[_0x707d('0x53')]['id']}})['then'](handleEntityNotFound(_0x4a8fbb,null))['then'](function(_0x11d410){if(_0x11d410){_0x4d2578[_0x707d('0x40')]=_['keys'](db[_0x707d('0x62')][_0x707d('0x3e')]);_0x4d2578[_0x707d('0x42')]=_[_0x707d('0x41')](_0x1c2dcf['query']);_0x4d2578[_0x707d('0x43')]=_[_0x707d('0x45')](_0x4d2578[_0x707d('0x40')],_0x4d2578['query']);_0x5a15aa[_0x707d('0x44')]=_['intersection'](_0x4d2578[_0x707d('0x40')],qs[_0x707d('0x46')](_0x1c2dcf['query'][_0x707d('0x46')]));_0x5a15aa[_0x707d('0x44')]=_0x5a15aa['attributes'][_0x707d('0x54')]?_0x5a15aa[_0x707d('0x44')]:_0x4d2578[_0x707d('0x40')];if(!_0x1c2dcf[_0x707d('0x42')][_0x707d('0x63')]('nolimit')){_0x5a15aa['limit']=qs['limit'](_0x1c2dcf['query']['limit']);_0x5a15aa[_0x707d('0x22')]=qs[_0x707d('0x22')](_0x1c2dcf[_0x707d('0x42')][_0x707d('0x22')]);}_0x5a15aa[_0x707d('0x48')]=qs[_0x707d('0x49')](_0x1c2dcf[_0x707d('0x42')][_0x707d('0x49')]);_0x5a15aa['where']=qs[_0x707d('0x43')](_['pick'](_0x1c2dcf[_0x707d('0x42')],_0x4d2578[_0x707d('0x43')]));_0x5a15aa[_0x707d('0x4a')][_0x707d('0x64')]=_0x11d410['id'];if(_0x1c2dcf[_0x707d('0x42')]['filter']){_0x5a15aa[_0x707d('0x4a')]=_['merge'](_0x5a15aa[_0x707d('0x4a')],{'$or':_[_0x707d('0x33')](_0x5a15aa[_0x707d('0x44')],function(_0x2ec5c4){var _0x36c591={};_0x36c591[_0x2ec5c4]={'$like':'%'+_0x1c2dcf[_0x707d('0x42')][_0x707d('0x31')]+'%'};return _0x36c591;})});}_0x5a15aa=_[_0x707d('0x4c')]({},_0x5a15aa,_0x1c2dcf[_0x707d('0x4d')]);return db['CmHopper'][_0x707d('0x25')]({'where':_0x5a15aa[_0x707d('0x4a')]})['then'](function(_0xa301b3){_0x424a6e[_0x707d('0x25')]=_0xa301b3;if(_0x1c2dcf['query'][_0x707d('0x4e')]){_0x5a15aa[_0x707d('0x4f')]=[{'all':!![]}];}return db[_0x707d('0x62')][_0x707d('0x50')](_0x5a15aa);})['then'](function(_0x206003){_0x424a6e[_0x707d('0x65')]=_0x206003;return _0x424a6e;});}})[_0x707d('0x2b')](respondWithFilteredResult(_0x4a8fbb,_0x5a15aa))['catch'](handleError(_0x4a8fbb,null));};exports[_0x707d('0x66')]=function(_0x6363bd,_0x12f8ec,_0x2c4940){var _0x30023b={'raw':!![],'where':{}};var _0x34ba29={};var _0x580c83={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x707d('0x67')]({'where':{'id':_0x6363bd[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x12f8ec,null))[_0x707d('0x2b')](function(_0x160907){if(_0x160907){_0x34ba29[_0x707d('0x40')]=_[_0x707d('0x41')](db[_0x707d('0x68')]['rawAttributes']);_0x34ba29[_0x707d('0x42')]=_[_0x707d('0x41')](_0x6363bd[_0x707d('0x42')]);_0x34ba29[_0x707d('0x43')]=_[_0x707d('0x45')](_0x34ba29[_0x707d('0x40')],_0x34ba29['query']);_0x30023b['attributes']=_[_0x707d('0x45')](_0x34ba29['model'],qs[_0x707d('0x46')](_0x6363bd[_0x707d('0x42')][_0x707d('0x46')]));_0x30023b[_0x707d('0x44')]=_0x30023b[_0x707d('0x44')][_0x707d('0x54')]?_0x30023b['attributes']:_0x34ba29[_0x707d('0x40')];if(!_0x6363bd[_0x707d('0x42')][_0x707d('0x63')](_0x707d('0x47'))){_0x30023b[_0x707d('0x23')]=qs[_0x707d('0x23')](_0x6363bd[_0x707d('0x42')][_0x707d('0x23')]);_0x30023b[_0x707d('0x22')]=qs[_0x707d('0x22')](_0x6363bd[_0x707d('0x42')][_0x707d('0x22')]);}_0x30023b[_0x707d('0x48')]=qs[_0x707d('0x49')](_0x6363bd[_0x707d('0x42')][_0x707d('0x49')]);_0x30023b[_0x707d('0x4a')]=qs[_0x707d('0x43')](_[_0x707d('0x4b')](_0x6363bd[_0x707d('0x42')],_0x34ba29['filters']));_0x30023b[_0x707d('0x4a')][_0x707d('0x64')]=_0x160907['id'];if(_0x6363bd[_0x707d('0x42')][_0x707d('0x31')]){_0x30023b['where']=_[_0x707d('0x4c')](_0x30023b[_0x707d('0x4a')],{'$or':_[_0x707d('0x33')](_0x30023b[_0x707d('0x44')],function(_0x5c7049){var _0x3eb4c7={};_0x3eb4c7[_0x5c7049]={'$like':'%'+_0x6363bd['query'][_0x707d('0x31')]+'%'};return _0x3eb4c7;})});}_0x30023b=_[_0x707d('0x4c')]({},_0x30023b,_0x6363bd[_0x707d('0x4d')]);return db[_0x707d('0x68')][_0x707d('0x25')]({'where':_0x30023b['where']})[_0x707d('0x2b')](function(_0x49704f){_0x580c83[_0x707d('0x25')]=_0x49704f;if(_0x6363bd[_0x707d('0x42')][_0x707d('0x4e')]){_0x30023b['include']=[{'all':!![]}];}return db[_0x707d('0x68')][_0x707d('0x50')](_0x30023b);})['then'](function(_0x4ee0d0){_0x580c83[_0x707d('0x65')]=_0x4ee0d0;return _0x580c83;});}})[_0x707d('0x2b')](respondWithFilteredResult(_0x12f8ec,_0x30023b))[_0x707d('0x51')](handleError(_0x12f8ec,null));};exports[_0x707d('0x69')]=function(_0x18c641,_0xce0ddb,_0x54190e){var _0x22d3e4={'raw':!![],'where':{}};var _0x456e77={};var _0xb15220={'count':0x0,'rows':[]};return db[_0x707d('0x3d')]['findOne']({'where':{'id':_0x18c641[_0x707d('0x53')]['id']}})['then'](handleEntityNotFound(_0xce0ddb,null))[_0x707d('0x2b')](function(_0x3c5621){if(_0x3c5621){_0x456e77['model']=_[_0x707d('0x41')](db[_0x707d('0x6a')][_0x707d('0x3e')]);_0x456e77[_0x707d('0x42')]=_[_0x707d('0x41')](_0x18c641['query']);_0x456e77[_0x707d('0x43')]=_[_0x707d('0x45')](_0x456e77['model'],_0x456e77[_0x707d('0x42')]);_0x22d3e4[_0x707d('0x44')]=_[_0x707d('0x45')](_0x456e77[_0x707d('0x40')],qs['fields'](_0x18c641['query'][_0x707d('0x46')]));_0x22d3e4[_0x707d('0x44')]=_0x22d3e4[_0x707d('0x44')]['length']?_0x22d3e4[_0x707d('0x44')]:_0x456e77[_0x707d('0x40')];if(!_0x18c641['query']['hasOwnProperty'](_0x707d('0x47'))){_0x22d3e4[_0x707d('0x23')]=qs[_0x707d('0x23')](_0x18c641[_0x707d('0x42')][_0x707d('0x23')]);_0x22d3e4[_0x707d('0x22')]=qs['offset'](_0x18c641[_0x707d('0x42')][_0x707d('0x22')]);}_0x22d3e4[_0x707d('0x48')]=qs[_0x707d('0x49')](_0x18c641[_0x707d('0x42')][_0x707d('0x49')]);_0x22d3e4['where']=qs[_0x707d('0x43')](_[_0x707d('0x4b')](_0x18c641['query'],_0x456e77[_0x707d('0x43')]));_0x22d3e4[_0x707d('0x4a')][_0x707d('0x64')]=_0x3c5621['id'];if(_0x18c641['query']['filter']){_0x22d3e4[_0x707d('0x4a')]=_[_0x707d('0x4c')](_0x22d3e4[_0x707d('0x4a')],{'$or':_[_0x707d('0x33')](_0x22d3e4[_0x707d('0x44')],function(_0x1e9db1){var _0x3d7a57={};_0x3d7a57[_0x1e9db1]={'$like':'%'+_0x18c641[_0x707d('0x42')]['filter']+'%'};return _0x3d7a57;})});}_0x22d3e4=_[_0x707d('0x4c')]({},_0x22d3e4,_0x18c641[_0x707d('0x4d')]);return db[_0x707d('0x6a')][_0x707d('0x25')]({'where':_0x22d3e4[_0x707d('0x4a')]})['then'](function(_0x46685a){_0xb15220['count']=_0x46685a;if(_0x18c641[_0x707d('0x42')][_0x707d('0x4e')]){_0x22d3e4['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x707d('0x50')](_0x22d3e4);})['then'](function(_0x1c8879){_0xb15220['rows']=_0x1c8879;return _0xb15220;});}})['then'](respondWithFilteredResult(_0xce0ddb,_0x22d3e4))[_0x707d('0x51')](handleError(_0xce0ddb,null));};exports[_0x707d('0x6b')]=function(_0x2e8763,_0x40bed5,_0x1b26c9){var _0x26bbb1={'raw':!![],'where':{}};var _0x8e725={};var _0x311044={'count':0x0,'rows':[]};return db[_0x707d('0x3d')][_0x707d('0x67')]({'where':{'id':_0x2e8763[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x40bed5,null))[_0x707d('0x2b')](function(_0x35dee7){if(_0x35dee7){_0x8e725[_0x707d('0x40')]=_[_0x707d('0x41')](db[_0x707d('0x6c')][_0x707d('0x3e')]);_0x8e725[_0x707d('0x42')]=_[_0x707d('0x41')](_0x2e8763['query']);_0x8e725[_0x707d('0x43')]=_[_0x707d('0x45')](_0x8e725['model'],_0x8e725[_0x707d('0x42')]);_0x26bbb1[_0x707d('0x44')]=_[_0x707d('0x45')](_0x8e725['model'],qs['fields'](_0x2e8763[_0x707d('0x42')][_0x707d('0x46')]));_0x26bbb1[_0x707d('0x44')]=_0x26bbb1[_0x707d('0x44')][_0x707d('0x54')]?_0x26bbb1['attributes']:_0x8e725['model'];if(!_0x2e8763[_0x707d('0x42')][_0x707d('0x63')](_0x707d('0x47'))){_0x26bbb1['limit']=qs[_0x707d('0x23')](_0x2e8763[_0x707d('0x42')][_0x707d('0x23')]);_0x26bbb1[_0x707d('0x22')]=qs[_0x707d('0x22')](_0x2e8763[_0x707d('0x42')][_0x707d('0x22')]);}_0x26bbb1[_0x707d('0x48')]=qs[_0x707d('0x49')](_0x2e8763[_0x707d('0x42')]['sort']);_0x26bbb1[_0x707d('0x4a')]=qs[_0x707d('0x43')](_[_0x707d('0x4b')](_0x2e8763[_0x707d('0x42')],_0x8e725['filters']));_0x26bbb1[_0x707d('0x4a')]['VoiceQueueId']=_0x35dee7['id'];if(_0x2e8763[_0x707d('0x42')][_0x707d('0x31')]){_0x26bbb1['where']=_[_0x707d('0x4c')](_0x26bbb1['where'],{'$or':_[_0x707d('0x33')](_0x26bbb1['attributes'],function(_0x52fe2e){var _0x54ad2c={};_0x54ad2c[_0x52fe2e]={'$like':'%'+_0x2e8763['query'][_0x707d('0x31')]+'%'};return _0x54ad2c;})});}_0x26bbb1=_['merge']({},_0x26bbb1,_0x2e8763[_0x707d('0x4d')]);return db[_0x707d('0x6c')][_0x707d('0x25')]({'where':_0x26bbb1[_0x707d('0x4a')]})[_0x707d('0x2b')](function(_0xbeba07){_0x311044['count']=_0xbeba07;if(_0x2e8763[_0x707d('0x42')][_0x707d('0x4e')]){_0x26bbb1['include']=[{'all':!![]}];}return db[_0x707d('0x6c')][_0x707d('0x50')](_0x26bbb1);})[_0x707d('0x2b')](function(_0xdaabd1){_0x311044[_0x707d('0x65')]=_0xdaabd1;return _0x311044;});}})[_0x707d('0x2b')](respondWithFilteredResult(_0x40bed5,_0x26bbb1))[_0x707d('0x51')](handleError(_0x40bed5,null));};exports[_0x707d('0x6d')]=function(_0x53cf9a,_0x140685,_0x27ebf0){var _0x589ba7={};var _0x4f20da={};var _0x214517;var _0x5121f9;return db[_0x707d('0x3d')][_0x707d('0x67')]({'where':{'id':_0x53cf9a['params']['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x140685,null))[_0x707d('0x2b')](function(_0x3f0cb0){if(_0x3f0cb0){_0x214517=_0x3f0cb0;_0x4f20da[_0x707d('0x40')]=_[_0x707d('0x41')](db[_0x707d('0x6e')][_0x707d('0x3e')]);_0x4f20da[_0x707d('0x42')]=_[_0x707d('0x41')](_0x53cf9a[_0x707d('0x42')]);_0x4f20da[_0x707d('0x43')]=_[_0x707d('0x45')](_0x4f20da['model'],_0x4f20da[_0x707d('0x42')]);_0x589ba7[_0x707d('0x44')]=_[_0x707d('0x45')](_0x4f20da[_0x707d('0x40')],qs[_0x707d('0x46')](_0x53cf9a[_0x707d('0x42')][_0x707d('0x46')]));_0x589ba7[_0x707d('0x44')]=_0x589ba7[_0x707d('0x44')][_0x707d('0x54')]?_0x589ba7['attributes']:_0x4f20da[_0x707d('0x40')];_0x589ba7[_0x707d('0x48')]=qs[_0x707d('0x49')](_0x53cf9a[_0x707d('0x42')][_0x707d('0x49')]);_0x589ba7[_0x707d('0x4a')]=qs[_0x707d('0x43')](_['pick'](_0x53cf9a[_0x707d('0x42')],_0x4f20da[_0x707d('0x43')]));if(_0x53cf9a['query'][_0x707d('0x31')]){_0x589ba7[_0x707d('0x4a')]=_[_0x707d('0x4c')](_0x589ba7['where'],{'$or':_['map'](_0x589ba7[_0x707d('0x44')],function(_0x27251d){var _0x4952cb={};_0x4952cb[_0x27251d]={'$like':'%'+_0x53cf9a[_0x707d('0x42')][_0x707d('0x31')]+'%'};return _0x4952cb;})});}_0x589ba7=_['merge']({},_0x589ba7,_0x53cf9a[_0x707d('0x4d')]);return _0x214517[_0x707d('0x6d')](_0x589ba7);}})[_0x707d('0x2b')](function(_0x327304){if(_0x327304){_0x5121f9=_0x327304['length'];if(!_0x53cf9a[_0x707d('0x42')][_0x707d('0x63')](_0x707d('0x47'))){_0x589ba7[_0x707d('0x23')]=qs['limit'](_0x53cf9a[_0x707d('0x42')][_0x707d('0x23')]);_0x589ba7[_0x707d('0x22')]=qs[_0x707d('0x22')](_0x53cf9a[_0x707d('0x42')][_0x707d('0x22')]);}return _0x214517[_0x707d('0x6d')](_0x589ba7);}})[_0x707d('0x2b')](function(_0x530c48){if(_0x530c48){return _0x530c48?{'count':_0x5121f9,'rows':_0x530c48}:null;}})[_0x707d('0x2b')](respondWithResult(_0x140685,null))[_0x707d('0x51')](handleError(_0x140685,null));};exports['addTeams']=function(_0x55eab1,_0x474d48,_0x1993a8){var _0x3c76cb=_0x55eab1['body'][_0x707d('0x6f')];var _0x31c711=_[_0x707d('0x33')](_0x3c76cb,'id');return db[_0x707d('0x6e')]['findAll']({'where':{'id':_0x31c711},'attributes':['id'],'include':[{'model':db[_0x707d('0x70')],'as':'Agents','attributes':['id',_0x707d('0x37'),'online','voicePause','interface'],'raw':!![]}]})[_0x707d('0x2b')](function(_0x515704){if(_0x515704){var _0x37a4ab=_['flatMap'](_0x515704,function(_0x51e554){var _0x162e7a=_0x51e554[_0x707d('0x2c')]({'plain':!![]});_0x162e7a[_0x707d('0x71')]['forEach'](function(_0x4bfb92){_0x4bfb92[_0x707d('0x72')]=_[_0x707d('0x55')](_0x3c76cb,{'id':_0x162e7a['id']})[_0x707d('0x72')];});return _0x162e7a[_0x707d('0x71')];});return db['VoiceQueue'][_0x707d('0x55')]({'where':{'id':_0x55eab1[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](function(_0x5cb102){return db[_0x707d('0x73')][_0x707d('0x74')](function(_0x26b528){return _0x5cb102['addTeams'](_0x31c711,{'transaction':_0x26b528})[_0x707d('0x2b')](function(){return BPromise['each'](_0x3c76cb,function(_0x3ffa80){return db[_0x707d('0x75')][_0x707d('0x76')]({'TeamId':_0x3ffa80['id'],'VoiceQueueId':_0x55eab1[_0x707d('0x53')]['id'],'penalty':_0x3ffa80[_0x707d('0x72')]},{'transaction':_0x26b528});});})[_0x707d('0x2b')](function(){return BPromise[_0x707d('0x77')](_0x37a4ab,function(_0x5f4a92){return db[_0x707d('0x78')][_0x707d('0x79')]({'where':{'UserId':_0x5f4a92['id'],'VoiceQueueId':_0x55eab1[_0x707d('0x53')]['id']},'defaults':{'penalty':_0x5f4a92['penalty']},'transaction':_0x26b528});});})[_0x707d('0x2b')](function(){return BPromise[_0x707d('0x77')](_[_0x707d('0x31')](_0x37a4ab,{'online':!![]}),function(_0x5a4489){return db['UserVoiceQueueRt']['upsert']({'membername':_0x5a4489[_0x707d('0x37')],'UserId':_0x5a4489['id'],'queue_name':_0x5cb102[_0x707d('0x37')],'VoiceQueueId':_0x5cb102['id'],'interface':_[_0x707d('0x7a')](_0x5a4489[_0x707d('0x7b')])?util[_0x707d('0x7c')]('SIP/%s',_0x5a4489[_0x707d('0x37')]):_0x5a4489[_0x707d('0x7b')],'paused':_0x5a4489[_0x707d('0x7d')]||![],'penalty':_0x5a4489[_0x707d('0x72')]},{'transaction':_0x26b528});});})['then'](function(){_0x37a4ab['forEach'](function(_0x254f7b){socket[_0x707d('0x7e')](_0x707d('0x7f'),{'UserId':_0x254f7b['id'],'VoiceQueueId':_0x5cb102['id']});});});});});}})[_0x707d('0x2b')](respondWithStatusCode(_0x474d48,null))[_0x707d('0x51')](handleError(_0x474d48,null));};exports[_0x707d('0x80')]=function(_0x31da99,_0x1e847e,_0x19ba1a){return db['Team'][_0x707d('0x50')]({'where':{'id':_0x31da99[_0x707d('0x42')][_0x707d('0x81')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0x707d('0x71'),'attributes':['id'],'raw':!![]}]})[_0x707d('0x2b')](handleEntityNotFound(_0x1e847e,null))[_0x707d('0x2b')](function(_0x2f6809){var _0x245ad9=_[_0x707d('0x33')](_0x2f6809,'id');var _0x164a2c=[];var _0x59086f=[];var _0xc3733a=squel[_0x707d('0x82')]();_0xc3733a[_0x707d('0x83')](_0x707d('0x84'))[_0x707d('0x85')](_0x707d('0x86'),'tq')[_0x707d('0x87')]('user_has_teams','ut','ut.TeamId\x20=\x20tq.TeamId')[_0x707d('0x4a')](_0x707d('0x88'),_0x31da99[_0x707d('0x53')]['id']);for(var _0x37a62f=0x0;_0x37a62f<_0x2f6809['length'];_0x37a62f+=0x1){let _0x2bdb10=_0x2f6809[_0x37a62f];for(var _0x4190bc=0x0;_0x4190bc<_0x2bdb10[_0x707d('0x71')]['length'];_0x4190bc+=0x1){let _0x5c710d=_0x2bdb10[_0x707d('0x71')][_0x4190bc];var _0x4970aa=_0xc3733a[_0x707d('0x5d')]();_0x4970aa[_0x707d('0x4a')]('ut.UserId\x20=\x20?',_0x5c710d['id']);_0x59086f[_0x707d('0x89')](db[_0x707d('0x73')]['query'](_0x4970aa[_0x707d('0x8a')](),{'type':db[_0x707d('0x73')]['QueryTypes'][_0x707d('0x8b')]})['then'](function(_0x444965){if(_0x444965['length']===0x1){return _0x5c710d['id'];}else{var _0x2a41aa=_['every'](_['map'](_0x444965,_0x707d('0x8c')),function(_0x4f0e96){return _[_0x707d('0x35')](_0x245ad9,_0x4f0e96);});if(_0x2a41aa){return _0x5c710d['id'];}}}));}}return BPromise[_0x707d('0x8d')](_0x59086f)[_0x707d('0x2b')](function(_0x57601e){_0x164a2c=_(_0x164a2c)[_0x707d('0x8e')](_0x57601e)[_0x707d('0x8f')]()[_0x707d('0x34')]();return db['VoiceQueue']['find']({'where':{'id':_0x31da99[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](function(_0x360c80){return db[_0x707d('0x73')][_0x707d('0x74')](function(_0x4eff7f){return _0x360c80[_0x707d('0x80')](_0x31da99['query']['ids'],{'transaction':_0x4eff7f})['then'](function(){if(!_[_0x707d('0x90')](_0x164a2c)){return _0x360c80[_0x707d('0x91')](_0x164a2c,{'transaction':_0x4eff7f})[_0x707d('0x2b')](function(){return db[_0x707d('0x92')]['destroy']({'where':{'VoiceQueueId':_0x31da99[_0x707d('0x53')]['id'],'UserId':_0x164a2c},'transaction':_0x4eff7f});});}})[_0x707d('0x2b')](function(){_0x164a2c['forEach'](function(_0x3083d4){socket[_0x707d('0x7e')](_0x707d('0x93'),{'UserId':_0x3083d4,'VoiceQueueId':_0x360c80['id']});});});});});});})[_0x707d('0x2b')](respondWithStatusCode(_0x1e847e,null))['catch'](handleError(_0x1e847e,null));};exports[_0x707d('0x94')]=function(_0x2d0faf,_0x54f6dd,_0x1237f5){var _0x1c7e8c,_0x164f8c;return db['VoiceQueue'][_0x707d('0x55')]({'where':{'id':_0x2d0faf[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x54f6dd,null))[_0x707d('0x2b')](function(_0x13c988){if(_0x13c988){_0x164f8c=_0x13c988;return _0x13c988['addAgents'](_0x2d0faf[_0x707d('0x56')]['ids'],_[_0x707d('0x5e')](_0x2d0faf['body'],[_0x707d('0x81'),'id'])||{})['spread'](function(_0x4da240){for(var _0x3dd8b8=0x0;_0x3dd8b8<_0x2d0faf[_0x707d('0x56')][_0x707d('0x81')][_0x707d('0x54')];_0x3dd8b8+=0x1){socket['emit']('userVoiceQueue:save',{'UserId':Number(_0x2d0faf[_0x707d('0x56')][_0x707d('0x81')][_0x3dd8b8]),'VoiceQueueId':Number(_0x2d0faf['params']['id'])});}return _0x4da240;});}})[_0x707d('0x2b')](function(_0x2134c6){_0x1c7e8c=_0x2134c6||[];if(_0x164f8c){return db[_0x707d('0x70')]['findAll']({'where':{'id':_0x2d0faf['body'][_0x707d('0x81')]},'attributes':['id',_0x707d('0x37'),_0x707d('0x95'),'voicePause',_0x707d('0x7b')],'raw':!![]});}})['then'](function(_0x174451){if(!_[_0x707d('0x90')](_0x174451)){var _0x378539=[];for(var _0x2fe9c8=0x0;_0x2fe9c8<_0x174451[_0x707d('0x54')];_0x2fe9c8++){if(_0x174451[_0x2fe9c8][_0x707d('0x95')]){_0x378539['push'](db[_0x707d('0x92')][_0x707d('0x76')]({'membername':_0x174451[_0x2fe9c8][_0x707d('0x37')],'UserId':_0x174451[_0x2fe9c8]['id'],'queue_name':_0x164f8c[_0x707d('0x37')],'VoiceQueueId':_0x164f8c['id'],'interface':_[_0x707d('0x7a')](_0x174451[_0x2fe9c8][_0x707d('0x7b')])?util['format'](_0x707d('0x96'),_0x174451[_0x2fe9c8][_0x707d('0x37')]):_0x174451[_0x2fe9c8][_0x707d('0x7b')],'paused':_0x174451[_0x2fe9c8]['voicePause']||![],'penalty':_0x2d0faf['body'][_0x707d('0x72')]||0x0}));}}return BPromise[_0x707d('0x8d')](_0x378539);}})[_0x707d('0x2b')](function(){return _0x1c7e8c;})[_0x707d('0x2b')](respondWithResult(_0x54f6dd,null))[_0x707d('0x51')](handleError(_0x54f6dd,null));};exports['removeAgents']=function(_0x257edb,_0x1b0edb,_0x3903cd){return db[_0x707d('0x3d')]['find']({'where':{'id':_0x257edb[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x1b0edb,null))['then'](function(_0x39de42){if(_0x39de42){return _0x39de42[_0x707d('0x91')](_0x257edb[_0x707d('0x42')][_0x707d('0x81')])[_0x707d('0x2b')](function(){if(_[_0x707d('0x97')](_0x257edb['query'][_0x707d('0x81')])){for(var _0x17c223=0x0;_0x17c223<_0x257edb['query'][_0x707d('0x81')][_0x707d('0x54')];_0x17c223+=0x1){socket[_0x707d('0x7e')](_0x707d('0x93'),{'UserId':Number(_0x257edb[_0x707d('0x42')][_0x707d('0x81')][_0x17c223]),'VoiceQueueId':Number(_0x257edb[_0x707d('0x53')]['id'])});}}else{socket['emit']('userVoiceQueue:remove',{'UserId':Number(_0x257edb[_0x707d('0x42')][_0x707d('0x81')]),'VoiceQueueId':Number(_0x257edb[_0x707d('0x53')]['id'])});}});}})[_0x707d('0x2b')](function(_0x1a6179){return db[_0x707d('0x92')]['destroy']({'where':{'VoiceQueueId':_0x257edb['params']['id'],'UserId':_0x257edb['query'][_0x707d('0x81')]}})[_0x707d('0x2b')](function(){return _0x1a6179;});})['then'](respondWithStatusCode(_0x1b0edb,null))[_0x707d('0x51')](handleError(_0x1b0edb,null));};exports[_0x707d('0x98')]=function(_0x320171,_0x17e33e,_0x132d8d){var _0x4ac27c={};var _0x4ddc3f={};var _0x3ae4a1;var _0xfbf1e0;return db[_0x707d('0x3d')][_0x707d('0x67')]({'where':{'id':_0x320171['params']['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x17e33e,null))[_0x707d('0x2b')](function(_0x3f5076){if(_0x3f5076){_0x3ae4a1=_0x3f5076;_0x4ddc3f[_0x707d('0x40')]=_[_0x707d('0x41')](db[_0x707d('0x70')][_0x707d('0x3e')]);_0x4ddc3f['query']=_[_0x707d('0x41')](_0x320171['query']);_0x4ddc3f[_0x707d('0x43')]=_['intersection'](_0x4ddc3f[_0x707d('0x40')],_0x4ddc3f[_0x707d('0x42')]);_0x4ac27c[_0x707d('0x44')]=_['intersection'](_0x4ddc3f[_0x707d('0x40')],qs[_0x707d('0x46')](_0x320171['query']['fields']));_0x4ac27c[_0x707d('0x44')]=_0x4ac27c['attributes'][_0x707d('0x54')]?_0x4ac27c[_0x707d('0x44')]:_0x4ddc3f[_0x707d('0x40')];_0x4ac27c[_0x707d('0x48')]=qs['sort'](_0x320171[_0x707d('0x42')]['sort']);_0x4ac27c[_0x707d('0x4a')]=qs[_0x707d('0x43')](_[_0x707d('0x4b')](_0x320171['query'],_0x4ddc3f[_0x707d('0x43')]));if(_0x320171[_0x707d('0x42')]['filter']){_0x4ac27c['where']=_[_0x707d('0x4c')](_0x4ac27c[_0x707d('0x4a')],{'$or':_['map'](_0x4ac27c[_0x707d('0x44')],function(_0x4fd358){var _0x499cdf={};_0x499cdf[_0x4fd358]={'$like':'%'+_0x320171[_0x707d('0x42')][_0x707d('0x31')]+'%'};return _0x499cdf;})});}_0x4ac27c=_[_0x707d('0x4c')]({},_0x4ac27c,_0x320171[_0x707d('0x4d')]);return _0x3ae4a1[_0x707d('0x98')](_0x4ac27c);}})[_0x707d('0x2b')](function(_0x1683ae){if(_0x1683ae){_0xfbf1e0=_0x1683ae['length'];if(!_0x320171['query'][_0x707d('0x63')](_0x707d('0x47'))){_0x4ac27c[_0x707d('0x23')]=qs[_0x707d('0x23')](_0x320171[_0x707d('0x42')][_0x707d('0x23')]);_0x4ac27c[_0x707d('0x22')]=qs[_0x707d('0x22')](_0x320171['query']['offset']);}return _0x3ae4a1[_0x707d('0x98')](_0x4ac27c);}})[_0x707d('0x2b')](function(_0x496849){if(_0x496849){return _0x496849?{'count':_0xfbf1e0,'rows':_0x496849}:null;}})['then'](respondWithResult(_0x17e33e,null))[_0x707d('0x51')](handleError(_0x17e33e,null));};exports[_0x707d('0x99')]=function(_0x2d99ea,_0x1aadbe,_0x47dd95){var _0x565467={};var _0x599fb4={};var _0xe1e062;var _0x14dcef;return db['VoiceQueue'][_0x707d('0x67')]({'where':{'id':_0x2d99ea[_0x707d('0x53')]['id']}})['then'](handleEntityNotFound(_0x1aadbe,null))[_0x707d('0x2b')](function(_0x35e80a){if(_0x35e80a){_0xe1e062=_0x35e80a;_0x599fb4[_0x707d('0x40')]=_[_0x707d('0x41')](db['UserVoiceQueueRt']['rawAttributes']);_0x599fb4['query']=_[_0x707d('0x41')](_0x2d99ea[_0x707d('0x42')]);_0x599fb4[_0x707d('0x43')]=_['intersection'](_0x599fb4[_0x707d('0x40')],_0x599fb4[_0x707d('0x42')]);_0x565467[_0x707d('0x44')]=_[_0x707d('0x45')](_0x599fb4[_0x707d('0x40')],qs[_0x707d('0x46')](_0x2d99ea[_0x707d('0x42')][_0x707d('0x46')]));_0x565467[_0x707d('0x44')]=_0x565467[_0x707d('0x44')]['length']?_0x565467[_0x707d('0x44')]:_0x599fb4['model'];_0x565467[_0x707d('0x48')]=qs[_0x707d('0x49')](_0x2d99ea[_0x707d('0x42')][_0x707d('0x49')]);_0x565467[_0x707d('0x4a')]=qs[_0x707d('0x43')](_[_0x707d('0x4b')](_0x2d99ea[_0x707d('0x42')],_0x599fb4[_0x707d('0x43')]));if(_0x2d99ea['query'][_0x707d('0x31')]){_0x565467[_0x707d('0x4a')]=_[_0x707d('0x4c')](_0x565467['where'],{'$or':_['map'](_0x565467[_0x707d('0x44')],function(_0x17f9b0){var _0x41ac21={};_0x41ac21[_0x17f9b0]={'$like':'%'+_0x2d99ea['query'][_0x707d('0x31')]+'%'};return _0x41ac21;})});}_0x565467=_[_0x707d('0x4c')]({},_0x565467,_0x2d99ea['options']);return _0xe1e062[_0x707d('0x99')](_0x565467);}})['then'](function(_0x6cbcbd){if(_0x6cbcbd){_0x14dcef=_0x6cbcbd[_0x707d('0x54')];if(!_0x2d99ea['query'][_0x707d('0x63')](_0x707d('0x47'))){_0x565467[_0x707d('0x23')]=qs[_0x707d('0x23')](_0x2d99ea[_0x707d('0x42')]['limit']);_0x565467[_0x707d('0x22')]=qs[_0x707d('0x22')](_0x2d99ea[_0x707d('0x42')][_0x707d('0x22')]);}return _0xe1e062[_0x707d('0x99')](_0x565467);}})[_0x707d('0x2b')](function(_0x5489ca){return _0x5489ca?{'count':_0x14dcef,'rows':_0x5489ca}:null;})[_0x707d('0x2b')](respondWithResult(_0x1aadbe,null))[_0x707d('0x51')](handleError(_0x1aadbe,null));};exports[_0x707d('0x9a')]=function(_0x5c51ea,_0x4f93de,_0x5afcc4){var _0xfe67a5={};var _0x541a7e={};var _0x391d59;var _0x3d215e;return db['VoiceQueue']['findOne']({'where':{'id':_0x5c51ea[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x4f93de,null))[_0x707d('0x2b')](function(_0xa581cf){if(_0xa581cf){_0x391d59=_0xa581cf;_0x541a7e[_0x707d('0x40')]=_['keys'](db[_0x707d('0x9b')][_0x707d('0x3e')]);_0x541a7e[_0x707d('0x42')]=_['keys'](_0x5c51ea[_0x707d('0x42')]);_0x541a7e[_0x707d('0x43')]=_[_0x707d('0x45')](_0x541a7e[_0x707d('0x40')],_0x541a7e['query']);_0xfe67a5[_0x707d('0x44')]=_[_0x707d('0x45')](_0x541a7e[_0x707d('0x40')],qs[_0x707d('0x46')](_0x5c51ea[_0x707d('0x42')][_0x707d('0x46')]));_0xfe67a5[_0x707d('0x44')]=_0xfe67a5[_0x707d('0x44')][_0x707d('0x54')]?_0xfe67a5[_0x707d('0x44')]:_0x541a7e[_0x707d('0x40')];_0xfe67a5[_0x707d('0x48')]=qs[_0x707d('0x49')](_0x5c51ea['query'][_0x707d('0x49')]);_0xfe67a5[_0x707d('0x4a')]=qs[_0x707d('0x43')](_[_0x707d('0x4b')](_0x5c51ea['query'],_0x541a7e['filters']));if(_0x5c51ea[_0x707d('0x42')][_0x707d('0x31')]){_0xfe67a5[_0x707d('0x4a')]=_['merge'](_0xfe67a5[_0x707d('0x4a')],{'$or':_['map'](_0xfe67a5[_0x707d('0x44')],function(_0x280cca){var _0x20c197={};_0x20c197[_0x280cca]={'$like':'%'+_0x5c51ea['query']['filter']+'%'};return _0x20c197;})});}_0xfe67a5=_[_0x707d('0x4c')]({},_0xfe67a5,_0x5c51ea[_0x707d('0x4d')]);return _0x391d59[_0x707d('0x9a')](_0xfe67a5);}})['then'](function(_0x11971d){if(_0x11971d){_0x3d215e=_0x11971d[_0x707d('0x54')];if(!_0x5c51ea[_0x707d('0x42')][_0x707d('0x63')]('nolimit')){_0xfe67a5['limit']=qs[_0x707d('0x23')](_0x5c51ea['query']['limit']);_0xfe67a5['offset']=qs[_0x707d('0x22')](_0x5c51ea['query'][_0x707d('0x22')]);}return _0x391d59[_0x707d('0x9a')](_0xfe67a5);}})['then'](function(_0x369100){if(_0x369100){return _0x369100?{'count':_0x3d215e,'rows':_0x369100}:null;}})['then'](respondWithResult(_0x4f93de,null))[_0x707d('0x51')](handleError(_0x4f93de,null));};exports['addLists']=function(_0xcf6002,_0xe9c38e,_0x40381d){var _0x104709=moment()[_0x707d('0x7c')](_0x707d('0x9c'));var _0x5c67f5,_0x4e985c;return db[_0x707d('0x3d')]['find']({'where':{'id':_0xcf6002[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0xe9c38e,null))['then'](function(_0x3abc79){if(_0x3abc79){_0x4e985c=_0x3abc79;return _0x3abc79[_0x707d('0x9d')](_0xcf6002['body']['ids'],_[_0x707d('0x5e')](_0xcf6002['body'],[_0x707d('0x81'),'id'])||{});}return null;})[_0x707d('0x9e')](function(_0x2acc07){var _0x3d7be0;_0x5c67f5=_0x2acc07||[];var _0x5be04c=[];if(_0x2acc07){for(var _0x4fa015=0x0;_0x4fa015<_0x2acc07[_0x707d('0x54')];_0x4fa015+=0x1){var _0x1cf938=_0x2acc07[_0x4fa015][_0x707d('0x2c')]({'plain':!![]});_0x4e985c['dialCheckDuplicateType']=_0xcf6002[_0x707d('0x56')][_0x707d('0x9f')]?_0xcf6002[_0x707d('0x56')]['dialCheckDuplicateType']:_0x4e985c[_0x707d('0x9f')];switch(_0x4e985c[_0x707d('0x9f')]){case _0x707d('0xa0'):_0x3d7be0=squel['insert']()['into'](_0x707d('0xa1'))['fromQuery'](['phone',_0x707d('0xa2'),_0x707d('0xa3'),_0x707d('0xa4'),_0x707d('0x64'),_0x707d('0x5f'),'updatedAt'],squel[_0x707d('0x82')]()['field'](_0x707d('0xa5'),_0x707d('0xa5'))[_0x707d('0x83')]('\x27'+_0x104709+'\x27','scheduledAt')['field']('id',_0x707d('0xa3'))['field'](_0x1cf938[_0x707d('0xa6')][_0x707d('0x8a')](),_0x707d('0xa4'))[_0x707d('0x83')](_0xcf6002[_0x707d('0x53')]['id']['toString'](),'VoiceQueueId')[_0x707d('0x83')]('\x27'+_0x104709+'\x27',_0x707d('0x5f'))[_0x707d('0x83')]('\x27'+_0x104709+'\x27',_0x707d('0xa7'))[_0x707d('0x85')]('cm_contacts')[_0x707d('0x4a')]('deletedAt\x20IS\x20NULL')[_0x707d('0x4a')](_0x707d('0xa8'),_0x1cf938['CmListId']['toString']())[_0x707d('0x4a')](_0x707d('0xa9'))[_0x707d('0x4a')]('phone\x20NOT\x20IN\x20(?)',squel[_0x707d('0x82')]()[_0x707d('0x83')]('COALESCE(calleridnum,\x27\x27)')[_0x707d('0x85')](_0x707d('0xaa'))[_0x707d('0x4a')](_0x707d('0x88'),_0xcf6002['params']['id'][_0x707d('0x8a')]()))[_0x707d('0x4a')](_0x707d('0xab'),squel[_0x707d('0x82')]()[_0x707d('0x83')](_0x707d('0xac'))[_0x707d('0x85')](_0x707d('0xa1'))[_0x707d('0x4a')](_0x707d('0x88'),_0xcf6002[_0x707d('0x53')]['id'][_0x707d('0x8a')]())))[_0x707d('0x8a')]();break;case'onlyIfOpen':_0x3d7be0=squel[_0x707d('0xad')]()[_0x707d('0xae')](_0x707d('0xa1'))['fromQuery']([_0x707d('0xa5'),'scheduledAt',_0x707d('0xa3'),_0x707d('0xa4'),_0x707d('0x64'),_0x707d('0x5f'),'updatedAt'],squel['select']()['field'](_0x707d('0xa5'),_0x707d('0xa5'))[_0x707d('0x83')]('\x27'+_0x104709+'\x27',_0x707d('0xa2'))[_0x707d('0x83')]('id',_0x707d('0xa3'))[_0x707d('0x83')](_0x1cf938[_0x707d('0xa6')][_0x707d('0x8a')](),_0x707d('0xa4'))[_0x707d('0x83')](_0xcf6002['params']['id'][_0x707d('0x8a')](),_0x707d('0x64'))['field']('\x27'+_0x104709+'\x27',_0x707d('0x5f'))['field']('\x27'+_0x104709+'\x27',_0x707d('0xa7'))[_0x707d('0x85')](_0x707d('0xaf'))[_0x707d('0x4a')](_0x707d('0xb0'))['where'](_0x707d('0xa8'),_0x1cf938[_0x707d('0xa6')][_0x707d('0x8a')]())[_0x707d('0x4a')](_0x707d('0xa9'))[_0x707d('0x4a')](_0x707d('0xab'),squel[_0x707d('0x82')]()[_0x707d('0x83')](_0x707d('0xac'))['from'](_0x707d('0xa1'))[_0x707d('0x4a')](_0x707d('0x88'),_0xcf6002[_0x707d('0x53')]['id']['toString']())))['toString']();break;default:_0x3d7be0=squel['insert']()['into'](_0x707d('0xa1'))['fromQuery']([_0x707d('0xa5'),'scheduledAt',_0x707d('0xa3'),_0x707d('0xa4'),_0x707d('0x64'),_0x707d('0x5f'),_0x707d('0xa7')],squel[_0x707d('0x82')]()[_0x707d('0x83')](_0x707d('0xa5'),_0x707d('0xa5'))[_0x707d('0x83')]('\x27'+_0x104709+'\x27',_0x707d('0xa2'))[_0x707d('0x83')]('id',_0x707d('0xa3'))[_0x707d('0x83')](_0x1cf938[_0x707d('0xa6')][_0x707d('0x8a')](),'ListId')[_0x707d('0x83')](_0xcf6002[_0x707d('0x53')]['id'][_0x707d('0x8a')](),_0x707d('0x64'))[_0x707d('0x83')]('\x27'+_0x104709+'\x27','createdAt')[_0x707d('0x83')]('\x27'+_0x104709+'\x27',_0x707d('0xa7'))[_0x707d('0x85')]('cm_contacts')[_0x707d('0x4a')](_0x707d('0xb0'))[_0x707d('0x4a')]('ListId\x20=\x20?',_0x1cf938[_0x707d('0xa6')]['toString']())[_0x707d('0x4a')](_0x707d('0xa9')))[_0x707d('0x8a')]();}_0x5be04c[_0x707d('0x89')](db[_0x707d('0x73')][_0x707d('0x42')](_0x3d7be0));}return BPromise[_0x707d('0x8d')](_0x5be04c);}})[_0x707d('0x2b')](function(){var _0x3db3d3=[];var _0x538f5f=squel['insert']()[_0x707d('0xae')](_0x707d('0xb1'))[_0x707d('0xb2')](['CmHopperId',_0x707d('0xa5'),_0x707d('0xb3'),'createdAt',_0x707d('0xa7')],squel[_0x707d('0x82')]()[_0x707d('0x83')]('h.id')[_0x707d('0x83')](_0x707d('0xb4'))[_0x707d('0x83')](_0x707d('0xb5'))[_0x707d('0x83')]('\x27'+_0x104709+'\x27',_0x707d('0x5f'))['field']('\x27'+_0x104709+'\x27',_0x707d('0xa7'))[_0x707d('0x85')]('cm_contact_has_items','ci')['join']('cm_hopper','h',_0x707d('0xb6'))[_0x707d('0x4a')](_0x707d('0xb7'),_0x104709)[_0x707d('0x4a')](_0x707d('0xb8'),'PHONE'))[_0x707d('0x8a')]();_0x3db3d3[_0x707d('0x89')](db[_0x707d('0x73')]['query'](_0x538f5f));return BPromise[_0x707d('0x8d')](_0x3db3d3);})[_0x707d('0x2b')](function(){return _0x5c67f5;})[_0x707d('0x2b')](respondWithResult(_0xe9c38e,null))[_0x707d('0x51')](handleError(_0xe9c38e,null));};exports[_0x707d('0xb9')]=function(_0x207a95,_0x40e36b,_0x37bb7f){return db['VoiceQueue'][_0x707d('0x55')]({'where':{'id':_0x207a95[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x40e36b,null))[_0x707d('0x2b')](function(_0x13a55a){if(_0x13a55a){return _0x13a55a[_0x707d('0xb9')](_0x207a95[_0x707d('0x42')][_0x707d('0x81')]);}})[_0x707d('0x2b')](function(_0x10b9e4){if(_0x10b9e4){return db[_0x707d('0x62')][_0x707d('0x2a')]({'where':{'ListId':_0x207a95[_0x707d('0x42')][_0x707d('0x81')],'VoiceQueueId':_0x207a95[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](function(){return _0x10b9e4;});}})[_0x707d('0x2b')](respondWithStatusCode(_0x40e36b,null))['catch'](handleError(_0x40e36b,null));};exports[_0x707d('0xba')]=function(_0x1fdc5e,_0xc479ab,_0xb0ab94){var _0x59fa37={};var _0x590278={};var _0x2c28ab;var _0x497c85;return db[_0x707d('0x3d')]['findOne']({'where':{'id':_0x1fdc5e['params']['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0xc479ab,null))[_0x707d('0x2b')](function(_0x4ef445){if(_0x4ef445){_0x2c28ab=_0x4ef445;_0x590278[_0x707d('0x40')]=_['keys'](db[_0x707d('0x9b')]['rawAttributes']);_0x590278['query']=_[_0x707d('0x41')](_0x1fdc5e['query']);_0x590278[_0x707d('0x43')]=_[_0x707d('0x45')](_0x590278[_0x707d('0x40')],_0x590278[_0x707d('0x42')]);_0x59fa37[_0x707d('0x44')]=_['intersection'](_0x590278[_0x707d('0x40')],qs[_0x707d('0x46')](_0x1fdc5e[_0x707d('0x42')][_0x707d('0x46')]));_0x59fa37[_0x707d('0x44')]=_0x59fa37[_0x707d('0x44')][_0x707d('0x54')]?_0x59fa37[_0x707d('0x44')]:_0x590278[_0x707d('0x40')];_0x59fa37['order']=qs[_0x707d('0x49')](_0x1fdc5e[_0x707d('0x42')][_0x707d('0x49')]);_0x59fa37['where']=qs[_0x707d('0x43')](_['pick'](_0x1fdc5e[_0x707d('0x42')],_0x590278[_0x707d('0x43')]));if(_0x1fdc5e[_0x707d('0x42')]['filter']){_0x59fa37[_0x707d('0x4a')]=_['merge'](_0x59fa37[_0x707d('0x4a')],{'$or':_[_0x707d('0x33')](_0x59fa37[_0x707d('0x44')],function(_0x5647e0){var _0x45b864={};_0x45b864[_0x5647e0]={'$like':'%'+_0x1fdc5e[_0x707d('0x42')][_0x707d('0x31')]+'%'};return _0x45b864;})});}_0x59fa37=_[_0x707d('0x4c')]({},_0x59fa37,_0x1fdc5e['options']);return _0x2c28ab[_0x707d('0xba')](_0x59fa37);}})['then'](function(_0x43a0a7){if(_0x43a0a7){_0x497c85=_0x43a0a7[_0x707d('0x54')];if(!_0x1fdc5e['query'][_0x707d('0x63')](_0x707d('0x47'))){_0x59fa37[_0x707d('0x23')]=qs[_0x707d('0x23')](_0x1fdc5e[_0x707d('0x42')][_0x707d('0x23')]);_0x59fa37[_0x707d('0x22')]=qs[_0x707d('0x22')](_0x1fdc5e[_0x707d('0x42')][_0x707d('0x22')]);}return _0x2c28ab['getBlackLists'](_0x59fa37);}})['then'](function(_0x10e0ab){if(_0x10e0ab){return _0x10e0ab?{'count':_0x497c85,'rows':_0x10e0ab}:null;}})['then'](respondWithResult(_0xc479ab,null))[_0x707d('0x51')](handleError(_0xc479ab,null));};exports[_0x707d('0xbb')]=function(_0xdb193,_0x5b6f23,_0x217ab9){var _0x1e8fad,_0x15edf2;return db[_0x707d('0x3d')][_0x707d('0x55')]({'where':{'id':_0xdb193[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x5b6f23,null))[_0x707d('0x2b')](function(_0x455cf4){if(_0x455cf4){_0x15edf2=_0x455cf4;return _0x455cf4[_0x707d('0xbb')](_0xdb193['body'][_0x707d('0x81')],_['omit'](_0xdb193['body'],[_0x707d('0x81'),'id'])||{});}return null;})[_0x707d('0x9e')](function(_0x316bf2){var _0x43475f;_0x1e8fad=_0x316bf2||[];var _0x380bea=[];if(_0x316bf2){for(var _0xd43cd=0x0;_0xd43cd<_0x316bf2[_0x707d('0x54')];_0xd43cd+=0x1){var _0x327559=_0x316bf2[_0xd43cd]['get']({'plain':!![]});_0x43475f=squel['insert']()['into'](_0x707d('0xbc'))[_0x707d('0xb2')]([_0x707d('0xa5'),_0x707d('0xa3'),_0x707d('0xa4'),'VoiceQueueId','createdAt',_0x707d('0xa7')],squel[_0x707d('0x82')]()[_0x707d('0x83')](_0x707d('0xa5'),_0x707d('0xa5'))[_0x707d('0x83')]('id','ContactId')['field'](_0x327559[_0x707d('0xa6')][_0x707d('0x8a')](),'ListId')['field'](_0xdb193['params']['id'][_0x707d('0x8a')](),'VoiceQueueId')[_0x707d('0x83')]('NOW()','createdAt')[_0x707d('0x83')](_0x707d('0xbd'),_0x707d('0xa7'))[_0x707d('0x85')](_0x707d('0xaf'))[_0x707d('0x4a')](_0x707d('0xb0'))['where']('ListId\x20=\x20?',_0x327559[_0x707d('0xa6')]['toString']())[_0x707d('0x4a')](_0x707d('0xa9')))[_0x707d('0x8a')]();_0x380bea[_0x707d('0x89')](db[_0x707d('0x73')][_0x707d('0x42')](_0x43475f));}return BPromise['all'](_0x380bea);}})['then'](function(){return _0x1e8fad;})['then'](respondWithResult(_0x5b6f23,null))[_0x707d('0x51')](handleError(_0x5b6f23,null));};exports[_0x707d('0xbe')]=function(_0x1be10c,_0x264b2f,_0xab81bb){return db[_0x707d('0x3d')][_0x707d('0x55')]({'where':{'id':_0x1be10c['params']['id']}})[_0x707d('0x2b')](handleEntityNotFound(_0x264b2f,null))[_0x707d('0x2b')](function(_0x31f37c){if(_0x31f37c){return _0x31f37c[_0x707d('0xbe')](_0x1be10c[_0x707d('0x42')][_0x707d('0x81')]);}})[_0x707d('0x2b')](function(_0x11d313){if(_0x11d313){return db[_0x707d('0x6c')][_0x707d('0x2a')]({'where':{'ListId':_0x1be10c['query'][_0x707d('0x81')],'VoiceQueueId':_0x1be10c[_0x707d('0x53')]['id']}})[_0x707d('0x2b')](function(){return _0x11d313;});}})[_0x707d('0x2b')](respondWithStatusCode(_0x264b2f,null))[_0x707d('0x51')](handleError(_0x264b2f,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff