// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x393b=['json','count','offset','limit','set','apply','save','update','then','destroy','VoiceQueues','inbound','QueueCampaigns','ignore','map','value','includes','type','UserProfileResource','error','stack','name','send','fieldName','key','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','options','VoiceQueue','includeAll','findAll','catch','show','rawAttributes','include','create','body','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','find','autoAssociation','clone','omit','createdAt','outbound','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','getHoppers','order','pick','VoiceQueueId','CmHopper','getHopperHistories','CmHopperHistory','rows','findOne','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','addTeams','teams','Team','User','Agents','online','voicePause','interface','forEach','penalty','sequelize','transaction','each','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','emit','userVoiceQueue:save','ids','select','field','tq.TeamId','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','toString','SELECT','TeamId','all','union','compact','removeTeams','isEmpty','removeAgents','addAgents','spread','push','format','SIP/%s','isArray','userVoiceQueue:remove','getAgents','getMembers','CmList','getLists','addLists','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','NOW()','CmListId','ListId','updatedAt','from','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','onlyIfOpen','ListId\x20=\x20?','removeLists','getBlackLists','addBlackLists','removeBlackLists','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','querystring','ioredis','../../components/auth/service','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','localhost','socket.io-emitter','./voiceQueue.socket','sendStatus','status'];(function(_0x4b07d8,_0x379f7c){var _0x2eada4=function(_0x2387bf){while(--_0x2387bf){_0x4b07d8['push'](_0x4b07d8['shift']());}};_0x2eada4(++_0x379f7c);}(_0x393b,0x97));var _0xb393=function(_0x44c768,_0x552a5e){_0x44c768=_0x44c768-0x0;var _0x55daf5=_0x393b[_0x44c768];return _0x55daf5;};'use strict';var pdf=require(_0xb393('0x0'));var emlformat=require(_0xb393('0x1'));var rimraf=require(_0xb393('0x2'));var zipdir=require(_0xb393('0x3'));var jsonpatch=require(_0xb393('0x4'));var rp=require(_0xb393('0x5'));var moment=require(_0xb393('0x6'));var BPromise=require(_0xb393('0x7'));var Mustache=require(_0xb393('0x8'));var util=require(_0xb393('0x9'));var path=require(_0xb393('0xa'));var sox=require(_0xb393('0xb'));var csv=require(_0xb393('0xc'));var ejs=require(_0xb393('0xd'));var fs=require('fs');var _=require(_0xb393('0xe'));var squel=require(_0xb393('0xf'));var crypto=require(_0xb393('0x10'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xb393('0xc'));var querystring=require(_0xb393('0x11'));var Papa=require('papaparse');var Redis=require(_0xb393('0x12'));var authService=require(_0xb393('0x13'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xb393('0x14'))(_0xb393('0x15'));var utils=require(_0xb393('0x16'));var config=require(_0xb393('0x17'));var licenseUtil=require(_0xb393('0x18'));var db=require(_0xb393('0x19'))['db'];config[_0xb393('0x1a')]=_['defaults'](config[_0xb393('0x1a')],{'host':_0xb393('0x1b'),'port':0x18eb});var socket=require(_0xb393('0x1c'))(new Redis(config[_0xb393('0x1a')]));require(_0xb393('0x1d'))['register'](socket);function respondWithStatusCode(_0xcaa308,_0x413afb){_0x413afb=_0x413afb||0xcc;return function(_0x22a62e){if(_0x22a62e){return _0xcaa308[_0xb393('0x1e')](_0x413afb);}return _0xcaa308['status'](_0x413afb)['end']();};}function respondWithResult(_0x33d449,_0x290565){_0x290565=_0x290565||0xc8;return function(_0x4180c3){if(_0x4180c3){return _0x33d449[_0xb393('0x1f')](_0x290565)[_0xb393('0x20')](_0x4180c3);}};}function respondWithFilteredResult(_0x2ddd78,_0x31ddc6){return function(_0x34544){if(_0x34544){var _0xc0fa9=_0x34544[_0xb393('0x21')],_0x376ee5=_0x31ddc6[_0xb393('0x22')],_0xf55450=_0x31ddc6[_0xb393('0x22')]+_0x31ddc6[_0xb393('0x23')],_0x3770db;if(_0xf55450>=_0xc0fa9){_0xf55450=_0xc0fa9;_0x3770db=0xc8;}else{_0x3770db=0xce;}_0x2ddd78['status'](_0x3770db);return _0x2ddd78[_0xb393('0x24')]('Content-Range',_0x376ee5+'-'+_0xf55450+'/'+_0xc0fa9)[_0xb393('0x20')](_0x34544);}return null;};}function patchUpdates(_0x331ebd){return function(_0x5198ab){try{jsonpatch[_0xb393('0x25')](_0x5198ab,_0x331ebd,!![]);}catch(_0x197149){return BPromise['reject'](_0x197149);}return _0x5198ab[_0xb393('0x26')]();};}function saveUpdates(_0x20d86e,_0x466d8a){return function(_0x13861d){if(_0x13861d){return _0x13861d[_0xb393('0x27')](_0x20d86e)[_0xb393('0x28')](function(_0x5403a1){return _0x5403a1;});}return null;};}function removeEntity(_0x1b3611,_0x2f26f4){return function(_0x25ee07){if(_0x25ee07){return _0x25ee07[_0xb393('0x29')]()[_0xb393('0x28')](function(){var _0x252d83=_0x25ee07['get']({'plain':!![]});var _0x1ece79=[{'name':_0xb393('0x2a'),'value':_0xb393('0x2b'),'ignore':![]},{'name':_0xb393('0x2c'),'value':'outbound','ignore':![]}];var _0x32d6bd=_(_0x1ece79)['filter'](_0xb393('0x2d'))[_0xb393('0x2e')](_0xb393('0x2f'))[_0xb393('0x2f')]();if(_[_0xb393('0x30')](_0x32d6bd,_0x252d83[_0xb393('0x31')])){return;}var _0x31a7bd=_['find'](_0x1ece79,[_0xb393('0x2f'),_0x252d83[_0xb393('0x31')]])['name'];return db[_0xb393('0x32')][_0xb393('0x29')]({'where':{'type':_0x31a7bd,'resourceId':_0x252d83['id']}})[_0xb393('0x28')](function(){return _0x25ee07;});})[_0xb393('0x28')](function(){_0x1b3611[_0xb393('0x1f')](0xcc)['end']();});}};}function handleEntityNotFound(_0x32bf1f,_0x57071b){return function(_0x31dbc9){if(!_0x31dbc9){_0x32bf1f[_0xb393('0x1e')](0x194);}return _0x31dbc9;};}function handleError(_0x51d4eb,_0x218de3){_0x218de3=_0x218de3||0x1f4;return function(_0x3ddd81){logger[_0xb393('0x33')](_0x3ddd81[_0xb393('0x34')]);if(_0x3ddd81[_0xb393('0x35')]){delete _0x3ddd81[_0xb393('0x35')];}_0x51d4eb[_0xb393('0x1f')](_0x218de3)[_0xb393('0x36')](_0x3ddd81);};}exports['index']=function(_0x3d284a,_0x438a15){var _0x41c178={},_0x4dfcbb={},_0x2a4395={'count':0x0,'rows':[]};var _0x480e22=_[_0xb393('0x2e')](db['VoiceQueue']['rawAttributes'],function(_0x3460fe){return{'name':_0x3460fe[_0xb393('0x37')],'type':_0x3460fe['type'][_0xb393('0x38')]};});_0x4dfcbb['model']=_[_0xb393('0x2e')](_0x480e22,_0xb393('0x35'));_0x4dfcbb[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x3d284a['query']);_0x4dfcbb[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x4dfcbb[_0xb393('0x3d')],_0x4dfcbb[_0xb393('0x39')]);_0x41c178[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x4dfcbb[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x3d284a[_0xb393('0x39')]['fields']));_0x41c178[_0xb393('0x3e')]=_0x41c178[_0xb393('0x3e')][_0xb393('0x40')]?_0x41c178[_0xb393('0x3e')]:_0x4dfcbb[_0xb393('0x3d')];if(!_0x3d284a[_0xb393('0x39')][_0xb393('0x41')](_0xb393('0x42'))){_0x41c178[_0xb393('0x23')]=qs['limit'](_0x3d284a[_0xb393('0x39')]['limit']);_0x41c178[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x3d284a[_0xb393('0x39')]['offset']);}_0x41c178['order']=qs['sort'](_0x3d284a[_0xb393('0x39')][_0xb393('0x43')]);_0x41c178[_0xb393('0x44')]=qs['filters'](_['pick'](_0x3d284a[_0xb393('0x39')],_0x4dfcbb['filters']),_0x480e22);if(_0x3d284a[_0xb393('0x39')][_0xb393('0x45')]){_0x41c178[_0xb393('0x44')]=_[_0xb393('0x46')](_0x41c178[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x480e22,function(_0x222f39){if(_0x222f39['type']!==_0xb393('0x47')){var _0x2b882e={};_0x2b882e[_0x222f39['name']]={'$like':'%'+_0x3d284a[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x2b882e;}})});}_0x41c178=_[_0xb393('0x46')]({},_0x41c178,_0x3d284a[_0xb393('0x48')]);var _0x5f5048={'where':_0x41c178[_0xb393('0x44')]};return db[_0xb393('0x49')]['count'](_0x5f5048)[_0xb393('0x28')](function(_0x5568cf){_0x2a4395[_0xb393('0x21')]=_0x5568cf;if(_0x3d284a[_0xb393('0x39')][_0xb393('0x4a')]){_0x41c178['include']=[{'all':!![]}];}return db['VoiceQueue'][_0xb393('0x4b')](_0x41c178);})[_0xb393('0x28')](function(_0x559482){_0x2a4395['rows']=_0x559482;return _0x2a4395;})[_0xb393('0x28')](respondWithFilteredResult(_0x438a15,_0x41c178))[_0xb393('0x4c')](handleError(_0x438a15,null));};exports[_0xb393('0x4d')]=function(_0x50afdb,_0x2e8064){var _0x171b88={'raw':![],'where':{'id':_0x50afdb['params']['id']}},_0x1e8e27={};_0x1e8e27[_0xb393('0x3d')]=_[_0xb393('0x3a')](db[_0xb393('0x49')][_0xb393('0x4e')]);_0x1e8e27[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x50afdb[_0xb393('0x39')]);_0x1e8e27[_0xb393('0x3b')]=_['intersection'](_0x1e8e27[_0xb393('0x3d')],_0x1e8e27[_0xb393('0x39')]);_0x171b88['attributes']=_['intersection'](_0x1e8e27[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x50afdb[_0xb393('0x39')][_0xb393('0x3f')]));_0x171b88[_0xb393('0x3e')]=_0x171b88[_0xb393('0x3e')][_0xb393('0x40')]?_0x171b88[_0xb393('0x3e')]:_0x1e8e27[_0xb393('0x3d')];if(_0x50afdb[_0xb393('0x39')][_0xb393('0x4a')]){_0x171b88[_0xb393('0x4f')]=[{'all':!![]}];}_0x171b88=_['merge']({},_0x171b88,_0x50afdb['options']);return db[_0xb393('0x49')]['find'](_0x171b88)[_0xb393('0x28')](handleEntityNotFound(_0x2e8064,null))[_0xb393('0x28')](respondWithResult(_0x2e8064,null))[_0xb393('0x4c')](handleError(_0x2e8064,null));};exports[_0xb393('0x50')]=function(_0x166aa3,_0x150be9){return db['VoiceQueue'][_0xb393('0x50')](_0x166aa3[_0xb393('0x51')],{})[_0xb393('0x28')](function(_0x360cf1){var _0x194677=_0x166aa3['user'][_0xb393('0x52')]({'plain':!![]});if(!_0x194677)throw new Error(_0xb393('0x53'));if(_0x194677[_0xb393('0x54')]===_0xb393('0x55')){var _0x4db6a0=_0x360cf1['get']({'plain':!![]});var _0x56fdd5=[{'name':_0xb393('0x2a'),'value':_0xb393('0x2b')},{'name':_0xb393('0x2c'),'value':'outbound'}];var _0x3f0fa5=_['find'](_0x56fdd5,[_0xb393('0x2f'),_0x4db6a0[_0xb393('0x31')]])[_0xb393('0x35')];return db[_0xb393('0x56')][_0xb393('0x57')]({'where':{'name':_0x3f0fa5,'userProfileId':_0x194677['userProfileId']},'raw':!![]})[_0xb393('0x28')](function(_0x3f510e){if(_0x3f510e&&_0x3f510e[_0xb393('0x58')]===0x0){return db[_0xb393('0x32')][_0xb393('0x50')]({'name':_0x4db6a0[_0xb393('0x35')],'resourceId':_0x4db6a0['id'],'type':_0x3f510e[_0xb393('0x35')],'sectionId':_0x3f510e['id']},{})[_0xb393('0x28')](function(){return _0x360cf1;});}else{return _0x360cf1;}})[_0xb393('0x4c')](function(_0x38f5c3){logger[_0xb393('0x33')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x38f5c3);throw _0x38f5c3;});}return _0x360cf1;})[_0xb393('0x28')](respondWithResult(_0x150be9,0xc9))[_0xb393('0x4c')](handleError(_0x150be9,null));};exports[_0xb393('0x59')]=function(_0x540df2,_0x2cdd4a){var _0x3e3742={'where':{'id':_0x540df2['params']['id']}},_0x52ded4={};_0x52ded4[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['VoiceQueue']['rawAttributes']);_0x3e3742[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x52ded4[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x540df2['query']['fields']));_0x3e3742[_0xb393('0x3e')]=_0x3e3742[_0xb393('0x3e')][_0xb393('0x40')]?_0x3e3742[_0xb393('0x3e')]:_0x52ded4[_0xb393('0x3d')];if(_0x540df2[_0xb393('0x39')]['includeAll']){_0x3e3742['include']=[{'all':!![]}];}_0x3e3742=_[_0xb393('0x46')]({},_0x3e3742,_0x540df2[_0xb393('0x48')]);return db[_0xb393('0x49')]['find'](_0x3e3742)['then'](handleEntityNotFound(_0x2cdd4a,null))['then'](function(_0x38a7ad){if(_0x38a7ad){var _0x33dbfe=_0x38a7ad[_0xb393('0x52')]({'plain':!![]});_0x33dbfe=qs[_0xb393('0x5a')](_0x33dbfe,['id',_0xb393('0x5b'),'updatedAt']);_0x540df2[_0xb393('0x51')]=_[_0xb393('0x5a')](_0x540df2['body'],['id',_0xb393('0x5b'),'updatedAt']);return db['VoiceQueue'][_0xb393('0x50')](_['merge'](_0x33dbfe,_0x540df2[_0xb393('0x51')]),{'include':_0x540df2[_0xb393('0x39')]['includeAll']?[{'all':!![]}]:undefined})[_0xb393('0x28')](function(_0x56f883){var _0x16c4b1=_0x540df2['user'][_0xb393('0x52')]({'plain':!![]});if(!_0x16c4b1)throw new Error(_0xb393('0x53'));if(_0x16c4b1[_0xb393('0x54')]===_0xb393('0x55')){var _0x5c2183=_0x56f883[_0xb393('0x52')]({'plain':!![]});var _0x3c817d=[{'name':_0xb393('0x2a'),'value':_0xb393('0x2b')},{'name':_0xb393('0x2c'),'value':_0xb393('0x5c')}];var _0x36c102=_[_0xb393('0x57')](_0x3c817d,[_0xb393('0x2f'),_0x5c2183[_0xb393('0x31')]])[_0xb393('0x35')];return db[_0xb393('0x56')][_0xb393('0x57')]({'where':{'name':_0x36c102,'userProfileId':_0x16c4b1['userProfileId']},'raw':!![]})['then'](function(_0x2f4667){if(_0x2f4667&&_0x2f4667[_0xb393('0x58')]===0x0){return db[_0xb393('0x32')][_0xb393('0x50')]({'name':_0x5c2183[_0xb393('0x35')],'resourceId':_0x5c2183['id'],'type':_0x2f4667[_0xb393('0x35')],'sectionId':_0x2f4667['id']},{})[_0xb393('0x28')](function(){return _0x56f883;});}else{return _0x56f883;}})['catch'](function(_0x158960){logger[_0xb393('0x33')](_0xb393('0x5d'),_0x158960);throw _0x158960;});}return _0x56f883;});}})[_0xb393('0x28')](respondWithResult(_0x2cdd4a,0xc9))[_0xb393('0x4c')](handleError(_0x2cdd4a,null));};exports[_0xb393('0x27')]=function(_0x29c195,_0x11d944){if(_0x29c195[_0xb393('0x51')]['id']){delete _0x29c195[_0xb393('0x51')]['id'];}return db['VoiceQueue'][_0xb393('0x57')]({'where':{'id':_0x29c195['params']['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x11d944,null))['then'](saveUpdates(_0x29c195[_0xb393('0x51')],null))[_0xb393('0x28')](respondWithResult(_0x11d944,null))[_0xb393('0x4c')](handleError(_0x11d944,null));};exports[_0xb393('0x29')]=function(_0x12506e,_0x16d780){return db['VoiceQueue']['find']({'where':{'id':_0x12506e[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x16d780,null))[_0xb393('0x28')](removeEntity(_0x16d780,null))[_0xb393('0x4c')](handleError(_0x16d780,null));};exports[_0xb393('0x5f')]=function(_0x10ed9b,_0x38e920,_0x37c2b5){var _0x3cb28d={'raw':![],'where':{}};var _0x12684b={};var _0x527ea1={'count':0x0,'rows':[]};return db[_0xb393('0x49')]['findOne']({'where':{'id':_0x10ed9b['params']['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x38e920,null))[_0xb393('0x28')](function(_0x4ae395){if(_0x4ae395){_0x12684b[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['CmHopper'][_0xb393('0x4e')]);_0x12684b[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x10ed9b['query']);_0x12684b[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x12684b['model'],_0x12684b['query']);_0x3cb28d[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x12684b[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x10ed9b[_0xb393('0x39')][_0xb393('0x3f')]));_0x3cb28d[_0xb393('0x3e')]=_0x3cb28d[_0xb393('0x3e')][_0xb393('0x40')]?_0x3cb28d['attributes']:_0x12684b['model'];if(!_0x10ed9b[_0xb393('0x39')]['hasOwnProperty'](_0xb393('0x42'))){_0x3cb28d[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x10ed9b['query'][_0xb393('0x23')]);_0x3cb28d[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x10ed9b['query'][_0xb393('0x22')]);}_0x3cb28d[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x10ed9b[_0xb393('0x39')]['sort']);_0x3cb28d[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x10ed9b[_0xb393('0x39')],_0x12684b[_0xb393('0x3b')]));_0x3cb28d[_0xb393('0x44')][_0xb393('0x62')]=_0x4ae395['id'];if(_0x10ed9b[_0xb393('0x39')][_0xb393('0x45')]){_0x3cb28d['where']=_['merge'](_0x3cb28d['where'],{'$or':_[_0xb393('0x2e')](_0x3cb28d[_0xb393('0x3e')],function(_0x5e2aa2){var _0x3f62e4={};_0x3f62e4[_0x5e2aa2]={'$like':'%'+_0x10ed9b[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x3f62e4;})});}_0x3cb28d=_[_0xb393('0x46')]({},_0x3cb28d,_0x10ed9b[_0xb393('0x48')]);return db[_0xb393('0x63')]['count']({'where':_0x3cb28d[_0xb393('0x44')]})[_0xb393('0x28')](function(_0x3c4dc9){_0x527ea1['count']=_0x3c4dc9;if(_0x10ed9b[_0xb393('0x39')][_0xb393('0x4a')]){_0x3cb28d['include']=[{'all':!![]}];}return db[_0xb393('0x63')][_0xb393('0x4b')](_0x3cb28d);})[_0xb393('0x28')](function(_0x5e47fa){_0x527ea1['rows']=_0x5e47fa;return _0x527ea1;});}})[_0xb393('0x28')](respondWithFilteredResult(_0x38e920,_0x3cb28d))[_0xb393('0x4c')](handleError(_0x38e920,null));};exports[_0xb393('0x64')]=function(_0x1323a0,_0x411d0a,_0x7adaf3){var _0x1d6889={'raw':!![],'where':{}};var _0x55ab15={};var _0x1d7b9f={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x1323a0[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x411d0a,null))['then'](function(_0x3ea8af){if(_0x3ea8af){_0x55ab15['model']=_['keys'](db[_0xb393('0x65')][_0xb393('0x4e')]);_0x55ab15['query']=_[_0xb393('0x3a')](_0x1323a0['query']);_0x55ab15[_0xb393('0x3b')]=_['intersection'](_0x55ab15[_0xb393('0x3d')],_0x55ab15[_0xb393('0x39')]);_0x1d6889[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x55ab15[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x1323a0[_0xb393('0x39')][_0xb393('0x3f')]));_0x1d6889[_0xb393('0x3e')]=_0x1d6889[_0xb393('0x3e')][_0xb393('0x40')]?_0x1d6889[_0xb393('0x3e')]:_0x55ab15[_0xb393('0x3d')];if(!_0x1323a0[_0xb393('0x39')][_0xb393('0x41')](_0xb393('0x42'))){_0x1d6889[_0xb393('0x23')]=qs['limit'](_0x1323a0[_0xb393('0x39')][_0xb393('0x23')]);_0x1d6889['offset']=qs[_0xb393('0x22')](_0x1323a0[_0xb393('0x39')]['offset']);}_0x1d6889[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x1323a0[_0xb393('0x39')][_0xb393('0x43')]);_0x1d6889['where']=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x1323a0[_0xb393('0x39')],_0x55ab15[_0xb393('0x3b')]));_0x1d6889['where'][_0xb393('0x62')]=_0x3ea8af['id'];if(_0x1323a0[_0xb393('0x39')][_0xb393('0x45')]){_0x1d6889[_0xb393('0x44')]=_[_0xb393('0x46')](_0x1d6889[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x1d6889['attributes'],function(_0x3ebf4f){var _0x24e788={};_0x24e788[_0x3ebf4f]={'$like':'%'+_0x1323a0[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x24e788;})});}_0x1d6889=_[_0xb393('0x46')]({},_0x1d6889,_0x1323a0['options']);return db[_0xb393('0x65')][_0xb393('0x21')]({'where':_0x1d6889[_0xb393('0x44')]})[_0xb393('0x28')](function(_0x3be61d){_0x1d7b9f[_0xb393('0x21')]=_0x3be61d;if(_0x1323a0[_0xb393('0x39')][_0xb393('0x4a')]){_0x1d6889[_0xb393('0x4f')]=[{'all':!![]}];}return db[_0xb393('0x65')]['findAll'](_0x1d6889);})[_0xb393('0x28')](function(_0x28c00b){_0x1d7b9f[_0xb393('0x66')]=_0x28c00b;return _0x1d7b9f;});}})[_0xb393('0x28')](respondWithFilteredResult(_0x411d0a,_0x1d6889))[_0xb393('0x4c')](handleError(_0x411d0a,null));};exports['getHopperFinals']=function(_0x332005,_0x47ecc2,_0x41bac3){var _0x231c9b={'raw':!![],'where':{}};var _0x434c0b={};var _0xb4c029={'count':0x0,'rows':[]};return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x332005[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x47ecc2,null))['then'](function(_0x3db029){if(_0x3db029){_0x434c0b[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['CmHopperFinal'][_0xb393('0x4e')]);_0x434c0b['query']=_[_0xb393('0x3a')](_0x332005[_0xb393('0x39')]);_0x434c0b[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x434c0b['model'],_0x434c0b['query']);_0x231c9b[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x434c0b[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x332005['query'][_0xb393('0x3f')]));_0x231c9b[_0xb393('0x3e')]=_0x231c9b[_0xb393('0x3e')]['length']?_0x231c9b[_0xb393('0x3e')]:_0x434c0b[_0xb393('0x3d')];if(!_0x332005['query'][_0xb393('0x41')](_0xb393('0x42'))){_0x231c9b[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x332005[_0xb393('0x39')][_0xb393('0x23')]);_0x231c9b[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x332005['query'][_0xb393('0x22')]);}_0x231c9b[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x332005[_0xb393('0x39')][_0xb393('0x43')]);_0x231c9b[_0xb393('0x44')]=qs['filters'](_['pick'](_0x332005[_0xb393('0x39')],_0x434c0b[_0xb393('0x3b')]));_0x231c9b[_0xb393('0x44')][_0xb393('0x62')]=_0x3db029['id'];if(_0x332005[_0xb393('0x39')]['filter']){_0x231c9b[_0xb393('0x44')]=_[_0xb393('0x46')](_0x231c9b['where'],{'$or':_[_0xb393('0x2e')](_0x231c9b['attributes'],function(_0x55328c){var _0x1ca382={};_0x1ca382[_0x55328c]={'$like':'%'+_0x332005[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x1ca382;})});}_0x231c9b=_[_0xb393('0x46')]({},_0x231c9b,_0x332005[_0xb393('0x48')]);return db['CmHopperFinal'][_0xb393('0x21')]({'where':_0x231c9b[_0xb393('0x44')]})[_0xb393('0x28')](function(_0x571cb2){_0xb4c029['count']=_0x571cb2;if(_0x332005['query'][_0xb393('0x4a')]){_0x231c9b[_0xb393('0x4f')]=[{'all':!![]}];}return db[_0xb393('0x68')][_0xb393('0x4b')](_0x231c9b);})['then'](function(_0x75ae24){_0xb4c029[_0xb393('0x66')]=_0x75ae24;return _0xb4c029;});}})[_0xb393('0x28')](respondWithFilteredResult(_0x47ecc2,_0x231c9b))[_0xb393('0x4c')](handleError(_0x47ecc2,null));};exports[_0xb393('0x69')]=function(_0x7ebf69,_0x368bc9,_0x514588){var _0x1f3ff0={'raw':!![],'where':{}};var _0x51a715={};var _0x34756a={'count':0x0,'rows':[]};return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x7ebf69[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x368bc9,null))[_0xb393('0x28')](function(_0x3afe2c){if(_0x3afe2c){_0x51a715[_0xb393('0x3d')]=_[_0xb393('0x3a')](db[_0xb393('0x6a')][_0xb393('0x4e')]);_0x51a715[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x7ebf69['query']);_0x51a715[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x51a715[_0xb393('0x3d')],_0x51a715['query']);_0x1f3ff0[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x51a715[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x7ebf69[_0xb393('0x39')]['fields']));_0x1f3ff0[_0xb393('0x3e')]=_0x1f3ff0[_0xb393('0x3e')][_0xb393('0x40')]?_0x1f3ff0['attributes']:_0x51a715[_0xb393('0x3d')];if(!_0x7ebf69[_0xb393('0x39')]['hasOwnProperty'](_0xb393('0x42'))){_0x1f3ff0[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x7ebf69[_0xb393('0x39')][_0xb393('0x23')]);_0x1f3ff0[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x7ebf69[_0xb393('0x39')][_0xb393('0x22')]);}_0x1f3ff0['order']=qs['sort'](_0x7ebf69[_0xb393('0x39')][_0xb393('0x43')]);_0x1f3ff0['where']=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x7ebf69[_0xb393('0x39')],_0x51a715[_0xb393('0x3b')]));_0x1f3ff0[_0xb393('0x44')][_0xb393('0x62')]=_0x3afe2c['id'];if(_0x7ebf69[_0xb393('0x39')][_0xb393('0x45')]){_0x1f3ff0['where']=_[_0xb393('0x46')](_0x1f3ff0['where'],{'$or':_[_0xb393('0x2e')](_0x1f3ff0['attributes'],function(_0x5052ef){var _0x35a2a0={};_0x35a2a0[_0x5052ef]={'$like':'%'+_0x7ebf69[_0xb393('0x39')]['filter']+'%'};return _0x35a2a0;})});}_0x1f3ff0=_['merge']({},_0x1f3ff0,_0x7ebf69[_0xb393('0x48')]);return db[_0xb393('0x6a')][_0xb393('0x21')]({'where':_0x1f3ff0['where']})[_0xb393('0x28')](function(_0x1e9252){_0x34756a[_0xb393('0x21')]=_0x1e9252;if(_0x7ebf69[_0xb393('0x39')][_0xb393('0x4a')]){_0x1f3ff0[_0xb393('0x4f')]=[{'all':!![]}];}return db[_0xb393('0x6a')][_0xb393('0x4b')](_0x1f3ff0);})[_0xb393('0x28')](function(_0x5b8748){_0x34756a[_0xb393('0x66')]=_0x5b8748;return _0x34756a;});}})[_0xb393('0x28')](respondWithFilteredResult(_0x368bc9,_0x1f3ff0))[_0xb393('0x4c')](handleError(_0x368bc9,null));};exports[_0xb393('0x6b')]=function(_0x30dba2,_0x50b5f1,_0x4e42ae){var _0x41986d={};var _0x12c5dc={};var _0x1b5020;var _0x5a6636;return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x30dba2[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x50b5f1,null))['then'](function(_0x592033){if(_0x592033){_0x1b5020=_0x592033;_0x12c5dc[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['Team'][_0xb393('0x4e')]);_0x12c5dc['query']=_[_0xb393('0x3a')](_0x30dba2[_0xb393('0x39')]);_0x12c5dc[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x12c5dc['model'],_0x12c5dc['query']);_0x41986d[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x12c5dc['model'],qs[_0xb393('0x3f')](_0x30dba2[_0xb393('0x39')][_0xb393('0x3f')]));_0x41986d['attributes']=_0x41986d['attributes']['length']?_0x41986d[_0xb393('0x3e')]:_0x12c5dc['model'];_0x41986d[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x30dba2[_0xb393('0x39')][_0xb393('0x43')]);_0x41986d[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x30dba2[_0xb393('0x39')],_0x12c5dc[_0xb393('0x3b')]));if(_0x30dba2[_0xb393('0x39')][_0xb393('0x45')]){_0x41986d[_0xb393('0x44')]=_[_0xb393('0x46')](_0x41986d[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x41986d[_0xb393('0x3e')],function(_0x37b388){var _0x2890fb={};_0x2890fb[_0x37b388]={'$like':'%'+_0x30dba2['query'][_0xb393('0x45')]+'%'};return _0x2890fb;})});}_0x41986d=_[_0xb393('0x46')]({},_0x41986d,_0x30dba2['options']);return _0x1b5020[_0xb393('0x6b')](_0x41986d);}})[_0xb393('0x28')](function(_0x14b50f){if(_0x14b50f){_0x5a6636=_0x14b50f['length'];if(!_0x30dba2[_0xb393('0x39')]['hasOwnProperty'](_0xb393('0x42'))){_0x41986d[_0xb393('0x23')]=qs['limit'](_0x30dba2[_0xb393('0x39')]['limit']);_0x41986d['offset']=qs[_0xb393('0x22')](_0x30dba2[_0xb393('0x39')][_0xb393('0x22')]);}return _0x1b5020[_0xb393('0x6b')](_0x41986d);}})[_0xb393('0x28')](function(_0x66ae05){if(_0x66ae05){return _0x66ae05?{'count':_0x5a6636,'rows':_0x66ae05}:null;}})[_0xb393('0x28')](respondWithResult(_0x50b5f1,null))['catch'](handleError(_0x50b5f1,null));};exports[_0xb393('0x6c')]=function(_0x2a70e3,_0x481d7c,_0x46709f){var _0x48da15=_0x2a70e3['body'][_0xb393('0x6d')];var _0x4e5419=_[_0xb393('0x2e')](_0x48da15,'id');return db[_0xb393('0x6e')][_0xb393('0x4b')]({'where':{'id':_0x4e5419},'attributes':['id'],'include':[{'model':db[_0xb393('0x6f')],'as':_0xb393('0x70'),'attributes':['id',_0xb393('0x35'),_0xb393('0x71'),_0xb393('0x72'),_0xb393('0x73')],'raw':!![]}]})[_0xb393('0x28')](function(_0x1b1b2b){if(_0x1b1b2b){var _0x32829d=_['flatMap'](_0x1b1b2b,function(_0x230016){var _0x260335=_0x230016['get']({'plain':!![]});_0x260335[_0xb393('0x70')][_0xb393('0x74')](function(_0x5ca6cd){_0x5ca6cd[_0xb393('0x75')]=_[_0xb393('0x57')](_0x48da15,{'id':_0x260335['id']})['penalty'];});return _0x260335[_0xb393('0x70')];});return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0x2a70e3[_0xb393('0x5e')]['id']}})['then'](function(_0x28f71d){return db[_0xb393('0x76')][_0xb393('0x77')](function(_0x317399){return _0x28f71d[_0xb393('0x6c')](_0x4e5419,{'transaction':_0x317399})['then'](function(){return BPromise[_0xb393('0x78')](_0x48da15,function(_0x2f3aa1){return db['TeamVoiceQueue'][_0xb393('0x79')]({'TeamId':_0x2f3aa1['id'],'VoiceQueueId':_0x2a70e3[_0xb393('0x5e')]['id'],'penalty':_0x2f3aa1[_0xb393('0x75')]},{'transaction':_0x317399});});})[_0xb393('0x28')](function(){return BPromise[_0xb393('0x78')](_0x32829d,function(_0x55d50e){return db[_0xb393('0x7a')][_0xb393('0x7b')]({'where':{'UserId':_0x55d50e['id'],'VoiceQueueId':_0x2a70e3[_0xb393('0x5e')]['id']},'defaults':{'penalty':_0x55d50e[_0xb393('0x75')]},'transaction':_0x317399});});})[_0xb393('0x28')](function(){return BPromise['each'](_[_0xb393('0x45')](_0x32829d,{'online':!![]}),function(_0xda2c91){return db[_0xb393('0x7c')][_0xb393('0x79')]({'membername':_0xda2c91[_0xb393('0x35')],'UserId':_0xda2c91['id'],'queue_name':_0x28f71d[_0xb393('0x35')],'VoiceQueueId':_0x28f71d['id'],'interface':_[_0xb393('0x7d')](_0xda2c91[_0xb393('0x73')])?util['format']('SIP/%s',_0xda2c91['name']):_0xda2c91['interface'],'paused':_0xda2c91[_0xb393('0x72')]||![],'penalty':_0xda2c91[_0xb393('0x75')]},{'transaction':_0x317399});});})[_0xb393('0x28')](function(){_0x32829d[_0xb393('0x74')](function(_0x3fdb4f){socket[_0xb393('0x7e')](_0xb393('0x7f'),{'UserId':_0x3fdb4f['id'],'VoiceQueueId':_0x28f71d['id']});});});});});}})[_0xb393('0x28')](respondWithStatusCode(_0x481d7c,null))[_0xb393('0x4c')](handleError(_0x481d7c,null));};exports['removeTeams']=function(_0x301c46,_0x5e2d5b,_0x291451){return db['Team'][_0xb393('0x4b')]({'where':{'id':_0x301c46[_0xb393('0x39')][_0xb393('0x80')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0xb393('0x70'),'attributes':['id'],'raw':!![]}]})[_0xb393('0x28')](handleEntityNotFound(_0x5e2d5b,null))[_0xb393('0x28')](function(_0x42c26c){var _0x48be64=_[_0xb393('0x2e')](_0x42c26c,'id');var _0x55afe6=[];var _0x2a0243=[];var _0x4412ec=squel[_0xb393('0x81')]();_0x4412ec[_0xb393('0x82')](_0xb393('0x83'))['from'](_0xb393('0x84'),'tq')[_0xb393('0x85')](_0xb393('0x86'),'ut',_0xb393('0x87'))['where'](_0xb393('0x88'),_0x301c46[_0xb393('0x5e')]['id']);for(var _0x3aa9b4=0x0;_0x3aa9b4<_0x42c26c[_0xb393('0x40')];_0x3aa9b4+=0x1){let _0x1dd99d=_0x42c26c[_0x3aa9b4];for(var _0x59dc2f=0x0;_0x59dc2f<_0x1dd99d[_0xb393('0x70')][_0xb393('0x40')];_0x59dc2f+=0x1){let _0x15eb3b=_0x1dd99d[_0xb393('0x70')][_0x59dc2f];var _0x43ecd0=_0x4412ec[_0xb393('0x59')]();_0x43ecd0[_0xb393('0x44')](_0xb393('0x89'),_0x15eb3b['id']);_0x2a0243['push'](db[_0xb393('0x76')]['query'](_0x43ecd0[_0xb393('0x8a')](),{'type':db[_0xb393('0x76')]['QueryTypes'][_0xb393('0x8b')]})[_0xb393('0x28')](function(_0x3c43bd){if(_0x3c43bd[_0xb393('0x40')]===0x1){return _0x15eb3b['id'];}else{var _0xee6ecd=_['every'](_['map'](_0x3c43bd,_0xb393('0x8c')),function(_0x104fcd){return _['includes'](_0x48be64,_0x104fcd);});if(_0xee6ecd){return _0x15eb3b['id'];}}}));}}return BPromise[_0xb393('0x8d')](_0x2a0243)['then'](function(_0x597730){_0x55afe6=_(_0x55afe6)[_0xb393('0x8e')](_0x597730)[_0xb393('0x8f')]()[_0xb393('0x2f')]();return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0x301c46[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](function(_0x39f85b){return db[_0xb393('0x76')][_0xb393('0x77')](function(_0x4de0fb){return _0x39f85b[_0xb393('0x90')](_0x301c46['query']['ids'],{'transaction':_0x4de0fb})[_0xb393('0x28')](function(){if(!_[_0xb393('0x91')](_0x55afe6)){return _0x39f85b[_0xb393('0x92')](_0x55afe6,{'transaction':_0x4de0fb})[_0xb393('0x28')](function(){return db['UserVoiceQueueRt'][_0xb393('0x29')]({'where':{'VoiceQueueId':_0x301c46['params']['id'],'UserId':_0x55afe6},'transaction':_0x4de0fb});});}})[_0xb393('0x28')](function(){_0x55afe6[_0xb393('0x74')](function(_0x3dc43e){socket[_0xb393('0x7e')]('userVoiceQueue:remove',{'UserId':_0x3dc43e,'VoiceQueueId':_0x39f85b['id']});});});});});});})[_0xb393('0x28')](respondWithStatusCode(_0x5e2d5b,null))['catch'](handleError(_0x5e2d5b,null));};exports[_0xb393('0x93')]=function(_0x511e18,_0x471df3,_0x87bc9){var _0x13aae1,_0xfd024b;return db[_0xb393('0x49')]['find']({'where':{'id':_0x511e18[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x471df3,null))['then'](function(_0x1122e8){if(_0x1122e8){_0xfd024b=_0x1122e8;return _0x1122e8[_0xb393('0x93')](_0x511e18[_0xb393('0x51')][_0xb393('0x80')],_[_0xb393('0x5a')](_0x511e18[_0xb393('0x51')],[_0xb393('0x80'),'id'])||{})[_0xb393('0x94')](function(_0x5a7dc8){for(var _0x4e08be=0x0;_0x4e08be<_0x511e18[_0xb393('0x51')][_0xb393('0x80')]['length'];_0x4e08be+=0x1){socket[_0xb393('0x7e')](_0xb393('0x7f'),{'UserId':_0x511e18[_0xb393('0x51')]['ids'][_0x4e08be],'VoiceQueueId':_0x511e18['params']['id']});}return _0x5a7dc8;});}})[_0xb393('0x28')](function(_0x505e3c){_0x13aae1=_0x505e3c||[];if(_0xfd024b){return db[_0xb393('0x6f')][_0xb393('0x4b')]({'where':{'id':_0x511e18['body'][_0xb393('0x80')]},'attributes':['id','name',_0xb393('0x71'),_0xb393('0x72'),'interface'],'raw':!![]});}})[_0xb393('0x28')](function(_0xc5be2b){if(!_[_0xb393('0x91')](_0xc5be2b)){var _0x3ef40e=[];for(var _0x838a65=0x0;_0x838a65<_0xc5be2b[_0xb393('0x40')];_0x838a65++){if(_0xc5be2b[_0x838a65]['online']){_0x3ef40e[_0xb393('0x95')](db[_0xb393('0x7c')]['upsert']({'membername':_0xc5be2b[_0x838a65]['name'],'UserId':_0xc5be2b[_0x838a65]['id'],'queue_name':_0xfd024b['name'],'VoiceQueueId':_0xfd024b['id'],'interface':_[_0xb393('0x7d')](_0xc5be2b[_0x838a65]['interface'])?util[_0xb393('0x96')](_0xb393('0x97'),_0xc5be2b[_0x838a65]['name']):_0xc5be2b[_0x838a65][_0xb393('0x73')],'paused':_0xc5be2b[_0x838a65][_0xb393('0x72')]||![],'penalty':_0x511e18[_0xb393('0x51')][_0xb393('0x75')]||0x0}));}}return BPromise[_0xb393('0x8d')](_0x3ef40e);}})[_0xb393('0x28')](function(){return _0x13aae1;})['then'](respondWithResult(_0x471df3,null))[_0xb393('0x4c')](handleError(_0x471df3,null));};exports[_0xb393('0x92')]=function(_0xa8b888,_0x3836b2,_0x6b1f59){return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0xa8b888[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x3836b2,null))[_0xb393('0x28')](function(_0x4492ae){if(_0x4492ae){return _0x4492ae['removeAgents'](_0xa8b888[_0xb393('0x39')]['ids'])[_0xb393('0x28')](function(){if(_[_0xb393('0x98')](_0xa8b888[_0xb393('0x39')]['ids'])){for(var _0x4ec18e=0x0;_0x4ec18e<_0xa8b888[_0xb393('0x39')]['ids']['length'];_0x4ec18e+=0x1){socket['emit'](_0xb393('0x99'),{'UserId':Number(_0xa8b888['query'][_0xb393('0x80')][_0x4ec18e]),'VoiceQueueId':Number(_0xa8b888['params']['id'])});}}else{socket[_0xb393('0x7e')](_0xb393('0x99'),{'UserId':Number(_0xa8b888['query'][_0xb393('0x80')]),'VoiceQueueId':Number(_0xa8b888[_0xb393('0x5e')]['id'])});}});}})[_0xb393('0x28')](function(_0x43d7dc){return db[_0xb393('0x7c')][_0xb393('0x29')]({'where':{'VoiceQueueId':_0xa8b888[_0xb393('0x5e')]['id'],'UserId':_0xa8b888[_0xb393('0x39')][_0xb393('0x80')]}})[_0xb393('0x28')](function(){return _0x43d7dc;});})[_0xb393('0x28')](respondWithStatusCode(_0x3836b2,null))[_0xb393('0x4c')](handleError(_0x3836b2,null));};exports[_0xb393('0x9a')]=function(_0x2214f9,_0x3f7802,_0x1e9330){var _0x2e67dc={};var _0x2f88a2={};var _0x322d6f;var _0x1e65b7;return db[_0xb393('0x49')]['findOne']({'where':{'id':_0x2214f9[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x3f7802,null))[_0xb393('0x28')](function(_0xa9e40f){if(_0xa9e40f){_0x322d6f=_0xa9e40f;_0x2f88a2[_0xb393('0x3d')]=_['keys'](db[_0xb393('0x6f')][_0xb393('0x4e')]);_0x2f88a2[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x2214f9['query']);_0x2f88a2[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x2f88a2[_0xb393('0x3d')],_0x2f88a2[_0xb393('0x39')]);_0x2e67dc[_0xb393('0x3e')]=_['intersection'](_0x2f88a2[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x2214f9[_0xb393('0x39')][_0xb393('0x3f')]));_0x2e67dc[_0xb393('0x3e')]=_0x2e67dc['attributes'][_0xb393('0x40')]?_0x2e67dc[_0xb393('0x3e')]:_0x2f88a2['model'];_0x2e67dc[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x2214f9[_0xb393('0x39')][_0xb393('0x43')]);_0x2e67dc[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x2214f9[_0xb393('0x39')],_0x2f88a2[_0xb393('0x3b')]));if(_0x2214f9['query'][_0xb393('0x45')]){_0x2e67dc['where']=_[_0xb393('0x46')](_0x2e67dc[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x2e67dc[_0xb393('0x3e')],function(_0x2d2ca7){var _0x47c6da={};_0x47c6da[_0x2d2ca7]={'$like':'%'+_0x2214f9[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x47c6da;})});}_0x2e67dc=_['merge']({},_0x2e67dc,_0x2214f9[_0xb393('0x48')]);return _0x322d6f[_0xb393('0x9a')](_0x2e67dc);}})[_0xb393('0x28')](function(_0x25425e){if(_0x25425e){_0x1e65b7=_0x25425e[_0xb393('0x40')];if(!_0x2214f9[_0xb393('0x39')][_0xb393('0x41')](_0xb393('0x42'))){_0x2e67dc[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x2214f9['query'][_0xb393('0x23')]);_0x2e67dc[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x2214f9['query'][_0xb393('0x22')]);}return _0x322d6f[_0xb393('0x9a')](_0x2e67dc);}})[_0xb393('0x28')](function(_0x50acb2){if(_0x50acb2){return _0x50acb2?{'count':_0x1e65b7,'rows':_0x50acb2}:null;}})[_0xb393('0x28')](respondWithResult(_0x3f7802,null))[_0xb393('0x4c')](handleError(_0x3f7802,null));};exports[_0xb393('0x9b')]=function(_0x5802a0,_0x4fd994,_0x270804){var _0x37d882={};var _0x42221f={};var _0x4cd0ca;var _0x31e419;return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x5802a0[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x4fd994,null))[_0xb393('0x28')](function(_0x4286a1){if(_0x4286a1){_0x4cd0ca=_0x4286a1;_0x42221f[_0xb393('0x3d')]=_[_0xb393('0x3a')](db['UserVoiceQueueRt'][_0xb393('0x4e')]);_0x42221f[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x5802a0[_0xb393('0x39')]);_0x42221f[_0xb393('0x3b')]=_['intersection'](_0x42221f[_0xb393('0x3d')],_0x42221f[_0xb393('0x39')]);_0x37d882['attributes']=_[_0xb393('0x3c')](_0x42221f[_0xb393('0x3d')],qs['fields'](_0x5802a0['query'][_0xb393('0x3f')]));_0x37d882['attributes']=_0x37d882[_0xb393('0x3e')][_0xb393('0x40')]?_0x37d882[_0xb393('0x3e')]:_0x42221f[_0xb393('0x3d')];_0x37d882[_0xb393('0x60')]=qs['sort'](_0x5802a0[_0xb393('0x39')][_0xb393('0x43')]);_0x37d882['where']=qs['filters'](_['pick'](_0x5802a0[_0xb393('0x39')],_0x42221f[_0xb393('0x3b')]));if(_0x5802a0['query'][_0xb393('0x45')]){_0x37d882[_0xb393('0x44')]=_[_0xb393('0x46')](_0x37d882['where'],{'$or':_[_0xb393('0x2e')](_0x37d882['attributes'],function(_0x343b03){var _0x4ac4e9={};_0x4ac4e9[_0x343b03]={'$like':'%'+_0x5802a0[_0xb393('0x39')]['filter']+'%'};return _0x4ac4e9;})});}_0x37d882=_[_0xb393('0x46')]({},_0x37d882,_0x5802a0[_0xb393('0x48')]);return _0x4cd0ca[_0xb393('0x9b')](_0x37d882);}})[_0xb393('0x28')](function(_0x4ca685){if(_0x4ca685){_0x31e419=_0x4ca685['length'];if(!_0x5802a0[_0xb393('0x39')]['hasOwnProperty']('nolimit')){_0x37d882[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x5802a0['query'][_0xb393('0x23')]);_0x37d882[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x5802a0[_0xb393('0x39')]['offset']);}return _0x4cd0ca[_0xb393('0x9b')](_0x37d882);}})[_0xb393('0x28')](function(_0x563685){return _0x563685?{'count':_0x31e419,'rows':_0x563685}:null;})[_0xb393('0x28')](respondWithResult(_0x4fd994,null))[_0xb393('0x4c')](handleError(_0x4fd994,null));};exports['getLists']=function(_0x532190,_0x39c559,_0x4eaf15){var _0x2b330d={};var _0xd67292={};var _0x5ead19;var _0x2f93db;return db[_0xb393('0x49')][_0xb393('0x67')]({'where':{'id':_0x532190[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x39c559,null))[_0xb393('0x28')](function(_0x2fe39d){if(_0x2fe39d){_0x5ead19=_0x2fe39d;_0xd67292['model']=_['keys'](db[_0xb393('0x9c')][_0xb393('0x4e')]);_0xd67292[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x532190[_0xb393('0x39')]);_0xd67292[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0xd67292[_0xb393('0x3d')],_0xd67292[_0xb393('0x39')]);_0x2b330d[_0xb393('0x3e')]=_['intersection'](_0xd67292[_0xb393('0x3d')],qs['fields'](_0x532190[_0xb393('0x39')]['fields']));_0x2b330d[_0xb393('0x3e')]=_0x2b330d[_0xb393('0x3e')]['length']?_0x2b330d[_0xb393('0x3e')]:_0xd67292['model'];_0x2b330d[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x532190[_0xb393('0x39')][_0xb393('0x43')]);_0x2b330d[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x532190[_0xb393('0x39')],_0xd67292[_0xb393('0x3b')]));if(_0x532190[_0xb393('0x39')]['filter']){_0x2b330d['where']=_['merge'](_0x2b330d[_0xb393('0x44')],{'$or':_['map'](_0x2b330d[_0xb393('0x3e')],function(_0x23d1f9){var _0x17756d={};_0x17756d[_0x23d1f9]={'$like':'%'+_0x532190[_0xb393('0x39')]['filter']+'%'};return _0x17756d;})});}_0x2b330d=_[_0xb393('0x46')]({},_0x2b330d,_0x532190[_0xb393('0x48')]);return _0x5ead19[_0xb393('0x9d')](_0x2b330d);}})[_0xb393('0x28')](function(_0x529296){if(_0x529296){_0x2f93db=_0x529296[_0xb393('0x40')];if(!_0x532190['query'][_0xb393('0x41')](_0xb393('0x42'))){_0x2b330d[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x532190[_0xb393('0x39')][_0xb393('0x23')]);_0x2b330d['offset']=qs[_0xb393('0x22')](_0x532190['query']['offset']);}return _0x5ead19[_0xb393('0x9d')](_0x2b330d);}})[_0xb393('0x28')](function(_0x1730a9){if(_0x1730a9){return _0x1730a9?{'count':_0x2f93db,'rows':_0x1730a9}:null;}})['then'](respondWithResult(_0x39c559,null))['catch'](handleError(_0x39c559,null));};exports[_0xb393('0x9e')]=function(_0x520585,_0x1e1479,_0x3d52d0){var _0x435feb,_0x3d8091;return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0x520585[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x1e1479,null))[_0xb393('0x28')](function(_0x205059){if(_0x205059){_0x3d8091=_0x205059;return _0x205059[_0xb393('0x9e')](_0x520585[_0xb393('0x51')][_0xb393('0x80')],_[_0xb393('0x5a')](_0x520585[_0xb393('0x51')],['ids','id'])||{});}return null;})[_0xb393('0x94')](function(_0x1df4d5){var _0x24b255;_0x435feb=_0x1df4d5||[];var _0x448923=[];if(_0x1df4d5){for(var _0x21764e=0x0;_0x21764e<_0x1df4d5[_0xb393('0x40')];_0x21764e+=0x1){var _0x4212a5=_0x1df4d5[_0x21764e][_0xb393('0x52')]({'plain':!![]});_0x3d8091[_0xb393('0x9f')]=_0x520585['body'][_0xb393('0x9f')]?_0x520585['body']['dialCheckDuplicateType']:_0x3d8091[_0xb393('0x9f')];switch(_0x3d8091[_0xb393('0x9f')]){case'always':_0x24b255=squel[_0xb393('0xa0')]()[_0xb393('0xa1')](_0xb393('0xa2'))[_0xb393('0xa3')]([_0xb393('0xa4'),_0xb393('0xa5'),_0xb393('0xa6'),'ListId','VoiceQueueId',_0xb393('0x5b'),'updatedAt'],squel[_0xb393('0x81')]()[_0xb393('0x82')](_0xb393('0xa4'),'phone')[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0xa5'))[_0xb393('0x82')]('id',_0xb393('0xa6'))[_0xb393('0x82')](_0x4212a5[_0xb393('0xa8')][_0xb393('0x8a')](),_0xb393('0xa9'))[_0xb393('0x82')](_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')](),_0xb393('0x62'))['field'](_0xb393('0xa7'),'createdAt')[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0xaa'))[_0xb393('0xab')](_0xb393('0xac'))[_0xb393('0x44')](_0xb393('0xad'))[_0xb393('0x44')]('ListId\x20=\x20?',_0x4212a5['CmListId'][_0xb393('0x8a')]())[_0xb393('0x44')](_0xb393('0xae'))[_0xb393('0x44')](_0xb393('0xaf'),squel[_0xb393('0x81')]()[_0xb393('0x82')](_0xb393('0xb0'))[_0xb393('0xab')]('cm_hopper_final')[_0xb393('0x44')](_0xb393('0x88'),_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')]()))[_0xb393('0x44')](_0xb393('0xaf'),squel['select']()[_0xb393('0x82')]('COALESCE(phone,\x27\x27)')['from'](_0xb393('0xa2'))[_0xb393('0x44')]('VoiceQueueId\x20=\x20?',_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')]())))[_0xb393('0x8a')]();break;case _0xb393('0xb1'):_0x24b255=squel[_0xb393('0xa0')]()[_0xb393('0xa1')](_0xb393('0xa2'))['fromQuery']([_0xb393('0xa4'),_0xb393('0xa5'),_0xb393('0xa6'),'ListId',_0xb393('0x62'),'createdAt',_0xb393('0xaa')],squel[_0xb393('0x81')]()[_0xb393('0x82')](_0xb393('0xa4'),_0xb393('0xa4'))['field'](_0xb393('0xa7'),_0xb393('0xa5'))[_0xb393('0x82')]('id',_0xb393('0xa6'))['field'](_0x4212a5[_0xb393('0xa8')]['toString'](),_0xb393('0xa9'))[_0xb393('0x82')](_0x520585[_0xb393('0x5e')]['id']['toString'](),_0xb393('0x62'))[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0x5b'))[_0xb393('0x82')]('NOW()',_0xb393('0xaa'))[_0xb393('0xab')](_0xb393('0xac'))[_0xb393('0x44')](_0xb393('0xad'))['where']('ListId\x20=\x20?',_0x4212a5['CmListId']['toString']())['where'](_0xb393('0xae'))[_0xb393('0x44')](_0xb393('0xaf'),squel[_0xb393('0x81')]()[_0xb393('0x82')]('COALESCE(phone,\x27\x27)')['from'](_0xb393('0xa2'))[_0xb393('0x44')](_0xb393('0x88'),_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')]())))[_0xb393('0x8a')]();break;default:_0x24b255=squel[_0xb393('0xa0')]()[_0xb393('0xa1')](_0xb393('0xa2'))[_0xb393('0xa3')]([_0xb393('0xa4'),_0xb393('0xa5'),_0xb393('0xa6'),_0xb393('0xa9'),'VoiceQueueId','createdAt','updatedAt'],squel['select']()[_0xb393('0x82')](_0xb393('0xa4'),_0xb393('0xa4'))['field'](_0xb393('0xa7'),_0xb393('0xa5'))[_0xb393('0x82')]('id',_0xb393('0xa6'))[_0xb393('0x82')](_0x4212a5[_0xb393('0xa8')][_0xb393('0x8a')](),'ListId')[_0xb393('0x82')](_0x520585[_0xb393('0x5e')]['id'][_0xb393('0x8a')](),_0xb393('0x62'))[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0x5b'))['field'](_0xb393('0xa7'),_0xb393('0xaa'))[_0xb393('0xab')]('cm_contacts')[_0xb393('0x44')](_0xb393('0xad'))['where'](_0xb393('0xb2'),_0x4212a5[_0xb393('0xa8')][_0xb393('0x8a')]())[_0xb393('0x44')](_0xb393('0xae')))[_0xb393('0x8a')]();}_0x448923[_0xb393('0x95')](db[_0xb393('0x76')][_0xb393('0x39')](_0x24b255));}return BPromise[_0xb393('0x8d')](_0x448923);}})[_0xb393('0x28')](function(){return _0x435feb;})[_0xb393('0x28')](respondWithResult(_0x1e1479,null))[_0xb393('0x4c')](handleError(_0x1e1479,null));};exports['removeLists']=function(_0x45d3ed,_0x340221,_0x25656b){return db[_0xb393('0x49')][_0xb393('0x57')]({'where':{'id':_0x45d3ed[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](handleEntityNotFound(_0x340221,null))['then'](function(_0x3e8090){if(_0x3e8090){return _0x3e8090[_0xb393('0xb3')](_0x45d3ed['query']['ids']);}})[_0xb393('0x28')](function(_0x23b66f){if(_0x23b66f){return db[_0xb393('0x63')]['destroy']({'where':{'ListId':_0x45d3ed[_0xb393('0x39')][_0xb393('0x80')],'VoiceQueueId':_0x45d3ed[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](function(){return _0x23b66f;});}})['then'](respondWithStatusCode(_0x340221,null))[_0xb393('0x4c')](handleError(_0x340221,null));};exports[_0xb393('0xb4')]=function(_0x5f1658,_0x25150f,_0x4ecbb4){var _0x7a6dc2={};var _0x1c0965={};var _0x571f40;var _0x127cab;return db['VoiceQueue']['findOne']({'where':{'id':_0x5f1658[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x25150f,null))['then'](function(_0x1d6e37){if(_0x1d6e37){_0x571f40=_0x1d6e37;_0x1c0965[_0xb393('0x3d')]=_[_0xb393('0x3a')](db[_0xb393('0x9c')][_0xb393('0x4e')]);_0x1c0965[_0xb393('0x39')]=_[_0xb393('0x3a')](_0x5f1658[_0xb393('0x39')]);_0x1c0965[_0xb393('0x3b')]=_[_0xb393('0x3c')](_0x1c0965[_0xb393('0x3d')],_0x1c0965['query']);_0x7a6dc2[_0xb393('0x3e')]=_[_0xb393('0x3c')](_0x1c0965[_0xb393('0x3d')],qs[_0xb393('0x3f')](_0x5f1658['query'][_0xb393('0x3f')]));_0x7a6dc2[_0xb393('0x3e')]=_0x7a6dc2[_0xb393('0x3e')][_0xb393('0x40')]?_0x7a6dc2[_0xb393('0x3e')]:_0x1c0965[_0xb393('0x3d')];_0x7a6dc2[_0xb393('0x60')]=qs[_0xb393('0x43')](_0x5f1658[_0xb393('0x39')]['sort']);_0x7a6dc2[_0xb393('0x44')]=qs[_0xb393('0x3b')](_[_0xb393('0x61')](_0x5f1658[_0xb393('0x39')],_0x1c0965[_0xb393('0x3b')]));if(_0x5f1658[_0xb393('0x39')]['filter']){_0x7a6dc2['where']=_[_0xb393('0x46')](_0x7a6dc2[_0xb393('0x44')],{'$or':_[_0xb393('0x2e')](_0x7a6dc2[_0xb393('0x3e')],function(_0x3bb622){var _0x160497={};_0x160497[_0x3bb622]={'$like':'%'+_0x5f1658[_0xb393('0x39')][_0xb393('0x45')]+'%'};return _0x160497;})});}_0x7a6dc2=_['merge']({},_0x7a6dc2,_0x5f1658[_0xb393('0x48')]);return _0x571f40[_0xb393('0xb4')](_0x7a6dc2);}})[_0xb393('0x28')](function(_0x405908){if(_0x405908){_0x127cab=_0x405908[_0xb393('0x40')];if(!_0x5f1658['query'][_0xb393('0x41')](_0xb393('0x42'))){_0x7a6dc2[_0xb393('0x23')]=qs[_0xb393('0x23')](_0x5f1658[_0xb393('0x39')][_0xb393('0x23')]);_0x7a6dc2[_0xb393('0x22')]=qs[_0xb393('0x22')](_0x5f1658[_0xb393('0x39')][_0xb393('0x22')]);}return _0x571f40['getBlackLists'](_0x7a6dc2);}})[_0xb393('0x28')](function(_0x567cc1){if(_0x567cc1){return _0x567cc1?{'count':_0x127cab,'rows':_0x567cc1}:null;}})[_0xb393('0x28')](respondWithResult(_0x25150f,null))[_0xb393('0x4c')](handleError(_0x25150f,null));};exports[_0xb393('0xb5')]=function(_0x4a4ca6,_0xbc7e4a,_0x169ecf){var _0x4e2f72,_0x1aa2b2;return db['VoiceQueue'][_0xb393('0x57')]({'where':{'id':_0x4a4ca6[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0xbc7e4a,null))[_0xb393('0x28')](function(_0x18b230){if(_0x18b230){_0x1aa2b2=_0x18b230;return _0x18b230[_0xb393('0xb5')](_0x4a4ca6[_0xb393('0x51')]['ids'],_['omit'](_0x4a4ca6[_0xb393('0x51')],[_0xb393('0x80'),'id'])||{});}return null;})[_0xb393('0x94')](function(_0x5c898b){var _0x58381e;_0x4e2f72=_0x5c898b||[];var _0x3a39f6=[];if(_0x5c898b){for(var _0x30335b=0x0;_0x30335b<_0x5c898b[_0xb393('0x40')];_0x30335b+=0x1){var _0x3d9fc7=_0x5c898b[_0x30335b][_0xb393('0x52')]({'plain':!![]});_0x58381e=squel['insert']()[_0xb393('0xa1')]('cm_hopper_black')[_0xb393('0xa3')](['phone',_0xb393('0xa6'),_0xb393('0xa9'),_0xb393('0x62'),'createdAt',_0xb393('0xaa')],squel[_0xb393('0x81')]()['field'](_0xb393('0xa4'),_0xb393('0xa4'))['field']('id',_0xb393('0xa6'))['field'](_0x3d9fc7[_0xb393('0xa8')]['toString'](),_0xb393('0xa9'))['field'](_0x4a4ca6[_0xb393('0x5e')]['id']['toString'](),_0xb393('0x62'))[_0xb393('0x82')]('NOW()',_0xb393('0x5b'))[_0xb393('0x82')](_0xb393('0xa7'),_0xb393('0xaa'))['from'](_0xb393('0xac'))[_0xb393('0x44')]('deletedAt\x20IS\x20NULL')['where']('ListId\x20=\x20?',_0x3d9fc7[_0xb393('0xa8')][_0xb393('0x8a')]())['where'](_0xb393('0xae')))[_0xb393('0x8a')]();_0x3a39f6[_0xb393('0x95')](db[_0xb393('0x76')]['query'](_0x58381e));}return BPromise[_0xb393('0x8d')](_0x3a39f6);}})[_0xb393('0x28')](function(){return _0x4e2f72;})[_0xb393('0x28')](respondWithResult(_0xbc7e4a,null))[_0xb393('0x4c')](handleError(_0xbc7e4a,null));};exports['removeBlackLists']=function(_0xd9d963,_0x174ad0,_0x401aaa){return db['VoiceQueue'][_0xb393('0x57')]({'where':{'id':_0xd9d963[_0xb393('0x5e')]['id']}})['then'](handleEntityNotFound(_0x174ad0,null))['then'](function(_0x540ef7){if(_0x540ef7){return _0x540ef7[_0xb393('0xb6')](_0xd9d963[_0xb393('0x39')][_0xb393('0x80')]);}})[_0xb393('0x28')](function(_0x498f17){if(_0x498f17){return db[_0xb393('0x6a')][_0xb393('0x29')]({'where':{'ListId':_0xd9d963[_0xb393('0x39')][_0xb393('0x80')],'VoiceQueueId':_0xd9d963[_0xb393('0x5e')]['id']}})[_0xb393('0x28')](function(){return _0x498f17;});}})['then'](respondWithStatusCode(_0x174ad0,null))[_0xb393('0x4c')](handleError(_0x174ad0,null));};
\ No newline at end of file
+var _0x00bb=['query','filters','intersection','attributes','fields','length','merge','options','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','VoiceQueues','QueueCampaigns','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','role','getHoppers','hasOwnProperty','nolimit','sort','VoiceQueueId','CmHopper','includeAll','findAll','CmHopperHistory','order','pick','getHopperFinals','findOne','CmHopperFinal','CmHopperBlack','getTeams','Team','addTeams','online','voicePause','interface','Agents','forEach','penalty','sequelize','transaction','each','upsert','UserVoiceQueue','UserVoiceQueueRt','SIP/%s','emit','userVoiceQueue:save','ids','User','field','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','toString','QueryTypes','every','all','union','compact','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','isNil','format','isArray','getAgents','getMembers','getLists','CmList','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','phone','ContactId','ListId','select','scheduledAt','CmListId','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','onlyIfOpen','push','CmHopperId','OrderBy','ci.item','ci.OrderBy+1','cm_contact_has_items','h.ContactId=ci.CmContactId','h.scheduledat=?','PHONE','removeLists','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','moment','bluebird','util','squel','../../components/parsers/qs','../../config/logger','../../config/environment','../../mysqldb','localhost','socket.io-emitter','redis','./voiceQueue.socket','register','sendStatus','status','end','offset','undefined','limit','count','Content-Range','json','then','destroy','get','inbound','outbound','filter','ignore','value','includes','type','find','name','UserProfileResource','error','stack','send','index','map','rawAttributes','fieldName','key','getOptions','where','VoiceQueue','include','rows','catch','show','params','model','keys'];(function(_0x457b74,_0xecd07a){var _0x38e079=function(_0x405da9){while(--_0x405da9){_0x457b74['push'](_0x457b74['shift']());}};_0x38e079(++_0xecd07a);}(_0x00bb,0x1d8));var _0xb00b=function(_0x56482c,_0x16118d){_0x56482c=_0x56482c-0x0;var _0x5aae7a=_0x00bb[_0x56482c];return _0x5aae7a;};'use strict';var moment=require(_0xb00b('0x0'));var BPromise=require(_0xb00b('0x1'));var util=require(_0xb00b('0x2'));var _=require('lodash');var squel=require(_0xb00b('0x3'));var Redis=require('ioredis');var qs=require(_0xb00b('0x4'));var logger=require(_0xb00b('0x5'))('api');var config=require(_0xb00b('0x6'));var db=require(_0xb00b('0x7'))['db'];config['redis']=_['defaults'](config['redis'],{'host':_0xb00b('0x8'),'port':0x18eb});var socket=require(_0xb00b('0x9'))(new Redis(config[_0xb00b('0xa')]));require(_0xb00b('0xb'))[_0xb00b('0xc')](socket);function respondWithStatusCode(_0x3c36c5,_0x5b0c03){_0x5b0c03=_0x5b0c03||0xcc;return function(_0x51d12b){if(_0x51d12b){return _0x3c36c5[_0xb00b('0xd')](_0x5b0c03);}return _0x3c36c5[_0xb00b('0xe')](_0x5b0c03)[_0xb00b('0xf')]();};}function respondWithResult(_0x46a25c,_0x28d3cc){_0x28d3cc=_0x28d3cc||0xc8;return function(_0x48e125){if(_0x48e125){return _0x46a25c[_0xb00b('0xe')](_0x28d3cc)['json'](_0x48e125);}};}function respondWithFilteredResult(_0x5a4fea,_0x594075){return function(_0x4ff792){if(_0x4ff792){var _0x2d8ddf=typeof _0x594075[_0xb00b('0x10')]===_0xb00b('0x11')&&typeof _0x594075[_0xb00b('0x12')]===_0xb00b('0x11');var _0x4ada81=_0x4ff792[_0xb00b('0x13')];var _0xb0d42e=_0x2d8ddf?0x0:_0x594075['offset'];var _0x88d95e=_0x2d8ddf?_0x4ff792[_0xb00b('0x13')]:_0x594075['offset']+_0x594075['limit'];var _0x9b471e;if(_0x88d95e>=_0x4ada81){_0x88d95e=_0x4ada81;_0x9b471e=0xc8;}else{_0x9b471e=0xce;}_0x5a4fea['status'](_0x9b471e);return _0x5a4fea['set'](_0xb00b('0x14'),_0xb0d42e+'-'+_0x88d95e+'/'+_0x4ada81)[_0xb00b('0x15')](_0x4ff792);}return null;};}function saveUpdates(_0x387d97){return function(_0xbb72fc){if(_0xbb72fc){return _0xbb72fc['update'](_0x387d97)[_0xb00b('0x16')](function(_0x599347){return _0x599347;});}return null;};}function removeEntity(_0x415f91){return function(_0x5aa9a0){if(_0x5aa9a0){return _0x5aa9a0[_0xb00b('0x17')]()['then'](function(){var _0xb26ebb=_0x5aa9a0[_0xb00b('0x18')]({'plain':!![]});var _0x53ee68=[{'name':'VoiceQueues','value':_0xb00b('0x19'),'ignore':![]},{'name':'QueueCampaigns','value':_0xb00b('0x1a'),'ignore':![]}];var _0x43da66=_(_0x53ee68)[_0xb00b('0x1b')](_0xb00b('0x1c'))['map'](_0xb00b('0x1d'))['value']();if(_[_0xb00b('0x1e')](_0x43da66,_0xb26ebb[_0xb00b('0x1f')])){return;}var _0x51b841=_[_0xb00b('0x20')](_0x53ee68,[_0xb00b('0x1d'),_0xb26ebb['type']])[_0xb00b('0x21')];return db[_0xb00b('0x22')]['destroy']({'where':{'type':_0x51b841,'resourceId':_0xb26ebb['id']}})[_0xb00b('0x16')](function(){return _0x5aa9a0;});})[_0xb00b('0x16')](function(){_0x415f91[_0xb00b('0xe')](0xcc)[_0xb00b('0xf')]();});}};}function handleEntityNotFound(_0x520e55){return function(_0x50be6c){if(!_0x50be6c){_0x520e55[_0xb00b('0xd')](0x194);}return _0x50be6c;};}function handleError(_0x490380,_0x550587){_0x550587=_0x550587||0x1f4;return function(_0x4a635e){logger[_0xb00b('0x23')](_0x4a635e[_0xb00b('0x24')]);if(_0x4a635e[_0xb00b('0x21')]){delete _0x4a635e[_0xb00b('0x21')];}_0x490380[_0xb00b('0xe')](_0x550587)[_0xb00b('0x25')](_0x4a635e);};}exports[_0xb00b('0x26')]=function(_0x4a8d2b,_0x22c22d){var _0x503c9c={};var _0x450129={'count':0x0,'rows':[]};var _0x348165=_[_0xb00b('0x27')](db['VoiceQueue'][_0xb00b('0x28')],function(_0x280ed3){return{'name':_0x280ed3[_0xb00b('0x29')],'type':_0x280ed3[_0xb00b('0x1f')][_0xb00b('0x2a')]};});_0x503c9c=qs[_0xb00b('0x2b')](_0x348165,_0x4a8d2b);var _0x2e160a={'where':_0x503c9c[_0xb00b('0x2c')]};return db[_0xb00b('0x2d')]['count'](_0x2e160a)[_0xb00b('0x16')](function(_0x44918d){_0x450129['count']=_0x44918d;_0x503c9c[_0xb00b('0x2e')]=qs[_0xb00b('0x2e')](_0x4a8d2b['query']);return db[_0xb00b('0x2d')]['findAll'](_0x503c9c);})[_0xb00b('0x16')](function(_0x4117f2){_0x450129[_0xb00b('0x2f')]=_0x4117f2;return _0x450129;})[_0xb00b('0x16')](respondWithFilteredResult(_0x22c22d,_0x503c9c))[_0xb00b('0x30')](handleError(_0x22c22d,null));};exports[_0xb00b('0x31')]=function(_0x17f613,_0x594840){var _0x57e8f9={'raw':![],'where':{'id':_0x17f613[_0xb00b('0x32')]['id']}},_0x5b04c2={};_0x5b04c2[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x2d')]['rawAttributes']);_0x5b04c2[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x17f613[_0xb00b('0x35')]);_0x5b04c2[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x5b04c2[_0xb00b('0x33')],_0x5b04c2[_0xb00b('0x35')]);_0x57e8f9[_0xb00b('0x38')]=_['intersection'](_0x5b04c2['model'],qs[_0xb00b('0x39')](_0x17f613['query'][_0xb00b('0x39')]));_0x57e8f9[_0xb00b('0x38')]=_0x57e8f9[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x57e8f9[_0xb00b('0x38')]:_0x5b04c2[_0xb00b('0x33')];if(_0x17f613[_0xb00b('0x35')]['includeAll']){_0x57e8f9[_0xb00b('0x2e')]=[{'all':!![]}];}_0x57e8f9=_[_0xb00b('0x3b')]({},_0x57e8f9,_0x17f613[_0xb00b('0x3c')]);return db[_0xb00b('0x2d')][_0xb00b('0x20')](_0x57e8f9)[_0xb00b('0x16')](handleEntityNotFound(_0x594840,null))['then'](respondWithResult(_0x594840,null))[_0xb00b('0x30')](handleError(_0x594840,null));};exports[_0xb00b('0x3d')]=function(_0x4801e7,_0x17ff34){return db[_0xb00b('0x2d')][_0xb00b('0x3d')](_0x4801e7[_0xb00b('0x3e')],{})[_0xb00b('0x16')](function(_0x5636b1){var _0x14ff6a=_0x4801e7[_0xb00b('0x3f')][_0xb00b('0x18')]({'plain':!![]});if(!_0x14ff6a)throw new Error(_0xb00b('0x40'));if(_0x14ff6a['role']==='user'){var _0x43f834=_0x5636b1[_0xb00b('0x18')]({'plain':!![]});var _0x10a348=[{'name':_0xb00b('0x41'),'value':_0xb00b('0x19')},{'name':_0xb00b('0x42'),'value':_0xb00b('0x1a')}];var _0x493841=_[_0xb00b('0x20')](_0x10a348,[_0xb00b('0x1d'),_0x43f834[_0xb00b('0x1f')]])[_0xb00b('0x21')];return db[_0xb00b('0x43')][_0xb00b('0x20')]({'where':{'name':_0x493841,'userProfileId':_0x14ff6a[_0xb00b('0x44')]},'raw':!![]})[_0xb00b('0x16')](function(_0x2d58e2){if(_0x2d58e2&&_0x2d58e2[_0xb00b('0x45')]===0x0){return db[_0xb00b('0x22')][_0xb00b('0x3d')]({'name':_0x43f834['name'],'resourceId':_0x43f834['id'],'type':_0x2d58e2[_0xb00b('0x21')],'sectionId':_0x2d58e2['id']},{})[_0xb00b('0x16')](function(){return _0x5636b1;});}else{return _0x5636b1;}})[_0xb00b('0x30')](function(_0x44afa0){logger[_0xb00b('0x23')](_0xb00b('0x46'),_0x44afa0);throw _0x44afa0;});}return _0x5636b1;})[_0xb00b('0x16')](respondWithResult(_0x17ff34,0xc9))[_0xb00b('0x30')](handleError(_0x17ff34,null));};exports[_0xb00b('0x47')]=function(_0x103320,_0x1eec12){var _0x3b3031={'where':{'id':_0x103320['params']['id']}},_0x5dbe00={};_0x5dbe00['model']=_[_0xb00b('0x34')](db[_0xb00b('0x2d')]['rawAttributes']);_0x3b3031[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x5dbe00[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x103320['query']['fields']));_0x3b3031[_0xb00b('0x38')]=_0x3b3031[_0xb00b('0x38')]['length']?_0x3b3031['attributes']:_0x5dbe00[_0xb00b('0x33')];if(_0x103320[_0xb00b('0x35')]['includeAll']){_0x3b3031[_0xb00b('0x2e')]=[{'all':!![]}];}_0x3b3031=_['merge']({},_0x3b3031,_0x103320['options']);return db['VoiceQueue'][_0xb00b('0x20')](_0x3b3031)['then'](handleEntityNotFound(_0x1eec12,null))[_0xb00b('0x16')](function(_0x3178aa){if(_0x3178aa){var _0x4b6482=_0x3178aa[_0xb00b('0x18')]({'plain':!![]});_0x4b6482=qs[_0xb00b('0x48')](_0x4b6482,['id',_0xb00b('0x49'),'updatedAt']);_0x103320['body']=_[_0xb00b('0x48')](_0x103320[_0xb00b('0x3e')],['id','createdAt',_0xb00b('0x4a')]);return db[_0xb00b('0x2d')]['create'](_[_0xb00b('0x3b')](_0x4b6482,_0x103320[_0xb00b('0x3e')]),{'include':_0x103320[_0xb00b('0x35')]['includeAll']?[{'all':!![]}]:undefined})['then'](function(_0x19f907){var _0x398deb=_0x103320[_0xb00b('0x3f')][_0xb00b('0x18')]({'plain':!![]});if(!_0x398deb)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x398deb[_0xb00b('0x4b')]===_0xb00b('0x3f')){var _0x4ad9cb=_0x19f907['get']({'plain':!![]});var _0x160965=[{'name':'VoiceQueues','value':_0xb00b('0x19')},{'name':_0xb00b('0x42'),'value':_0xb00b('0x1a')}];var _0x222459=_[_0xb00b('0x20')](_0x160965,[_0xb00b('0x1d'),_0x4ad9cb['type']])[_0xb00b('0x21')];return db['UserProfileSection'][_0xb00b('0x20')]({'where':{'name':_0x222459,'userProfileId':_0x398deb[_0xb00b('0x44')]},'raw':!![]})[_0xb00b('0x16')](function(_0x5ac79e){if(_0x5ac79e&&_0x5ac79e[_0xb00b('0x45')]===0x0){return db[_0xb00b('0x22')][_0xb00b('0x3d')]({'name':_0x4ad9cb['name'],'resourceId':_0x4ad9cb['id'],'type':_0x5ac79e[_0xb00b('0x21')],'sectionId':_0x5ac79e['id']},{})[_0xb00b('0x16')](function(){return _0x19f907;});}else{return _0x19f907;}})[_0xb00b('0x30')](function(_0x385029){logger[_0xb00b('0x23')](_0xb00b('0x46'),_0x385029);throw _0x385029;});}return _0x19f907;});}})[_0xb00b('0x16')](respondWithResult(_0x1eec12,0xc9))[_0xb00b('0x30')](handleError(_0x1eec12,null));};exports['update']=function(_0x153551,_0x2cbe80){if(_0x153551[_0xb00b('0x3e')]['id']){delete _0x153551['body']['id'];}return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x153551[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x2cbe80,null))[_0xb00b('0x16')](saveUpdates(_0x153551['body'],null))[_0xb00b('0x16')](respondWithResult(_0x2cbe80,null))[_0xb00b('0x30')](handleError(_0x2cbe80,null));};exports[_0xb00b('0x17')]=function(_0x1cad79,_0x4b1e5f){return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x1cad79[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x4b1e5f,null))[_0xb00b('0x16')](removeEntity(_0x4b1e5f,null))[_0xb00b('0x30')](handleError(_0x4b1e5f,null));};exports[_0xb00b('0x4c')]=function(_0x542223,_0x2b090a){var _0x502822={'raw':![],'where':{}};var _0x3e0648={};var _0x4c2186={'count':0x0,'rows':[]};return db[_0xb00b('0x2d')]['findOne']({'where':{'id':_0x542223[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x2b090a,null))[_0xb00b('0x16')](function(_0x2534ed){if(_0x2534ed){_0x3e0648[_0xb00b('0x33')]=_['keys'](db['CmHopper']['rawAttributes']);_0x3e0648[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x542223[_0xb00b('0x35')]);_0x3e0648['filters']=_[_0xb00b('0x37')](_0x3e0648[_0xb00b('0x33')],_0x3e0648[_0xb00b('0x35')]);_0x502822[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x3e0648['model'],qs[_0xb00b('0x39')](_0x542223[_0xb00b('0x35')]['fields']));_0x502822[_0xb00b('0x38')]=_0x502822[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x502822['attributes']:_0x3e0648['model'];if(!_0x542223[_0xb00b('0x35')][_0xb00b('0x4d')](_0xb00b('0x4e'))){_0x502822['limit']=qs['limit'](_0x542223['query']['limit']);_0x502822[_0xb00b('0x10')]=qs['offset'](_0x542223[_0xb00b('0x35')][_0xb00b('0x10')]);}_0x502822['order']=qs[_0xb00b('0x4f')](_0x542223[_0xb00b('0x35')][_0xb00b('0x4f')]);_0x502822[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_['pick'](_0x542223[_0xb00b('0x35')],_0x3e0648[_0xb00b('0x36')]));_0x502822[_0xb00b('0x2c')][_0xb00b('0x50')]=_0x2534ed['id'];if(_0x542223[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x502822[_0xb00b('0x2c')]=_['merge'](_0x502822[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0x502822[_0xb00b('0x38')],function(_0x328f72){var _0x109f56={};_0x109f56[_0x328f72]={'$like':'%'+_0x542223[_0xb00b('0x35')][_0xb00b('0x1b')]+'%'};return _0x109f56;})});}_0x502822=_[_0xb00b('0x3b')]({},_0x502822,_0x542223['options']);return db[_0xb00b('0x51')][_0xb00b('0x13')]({'where':_0x502822[_0xb00b('0x2c')]})[_0xb00b('0x16')](function(_0x3d6b33){_0x4c2186[_0xb00b('0x13')]=_0x3d6b33;if(_0x542223[_0xb00b('0x35')][_0xb00b('0x52')]){_0x502822['include']=[{'all':!![]}];}return db[_0xb00b('0x51')][_0xb00b('0x53')](_0x502822);})[_0xb00b('0x16')](function(_0x26b82a){_0x4c2186[_0xb00b('0x2f')]=_0x26b82a;return _0x4c2186;});}})[_0xb00b('0x16')](respondWithFilteredResult(_0x2b090a,_0x502822))[_0xb00b('0x30')](handleError(_0x2b090a,null));};exports['getHopperHistories']=function(_0x207bda,_0x37a4c0){var _0x28ecf8={'raw':!![],'where':{}};var _0x22b19c={};var _0x16e8ff={'count':0x0,'rows':[]};return db[_0xb00b('0x2d')]['findOne']({'where':{'id':_0x207bda[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x37a4c0,null))[_0xb00b('0x16')](function(_0x50922f){if(_0x50922f){_0x22b19c[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x54')]['rawAttributes']);_0x22b19c['query']=_[_0xb00b('0x34')](_0x207bda[_0xb00b('0x35')]);_0x22b19c[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x22b19c[_0xb00b('0x33')],_0x22b19c[_0xb00b('0x35')]);_0x28ecf8[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x22b19c[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x207bda[_0xb00b('0x35')][_0xb00b('0x39')]));_0x28ecf8[_0xb00b('0x38')]=_0x28ecf8[_0xb00b('0x38')]['length']?_0x28ecf8['attributes']:_0x22b19c[_0xb00b('0x33')];if(!_0x207bda[_0xb00b('0x35')]['hasOwnProperty']('nolimit')){_0x28ecf8[_0xb00b('0x12')]=qs[_0xb00b('0x12')](_0x207bda[_0xb00b('0x35')]['limit']);_0x28ecf8[_0xb00b('0x10')]=qs[_0xb00b('0x10')](_0x207bda[_0xb00b('0x35')][_0xb00b('0x10')]);}_0x28ecf8[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x207bda[_0xb00b('0x35')]['sort']);_0x28ecf8[_0xb00b('0x2c')]=qs['filters'](_[_0xb00b('0x56')](_0x207bda[_0xb00b('0x35')],_0x22b19c['filters']));_0x28ecf8[_0xb00b('0x2c')][_0xb00b('0x50')]=_0x50922f['id'];if(_0x207bda[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x28ecf8[_0xb00b('0x2c')]=_[_0xb00b('0x3b')](_0x28ecf8[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0x28ecf8[_0xb00b('0x38')],function(_0x383d16){var _0x2ec3f2={};_0x2ec3f2[_0x383d16]={'$like':'%'+_0x207bda[_0xb00b('0x35')]['filter']+'%'};return _0x2ec3f2;})});}_0x28ecf8=_[_0xb00b('0x3b')]({},_0x28ecf8,_0x207bda[_0xb00b('0x3c')]);return db[_0xb00b('0x54')][_0xb00b('0x13')]({'where':_0x28ecf8['where']})[_0xb00b('0x16')](function(_0x17503d){_0x16e8ff[_0xb00b('0x13')]=_0x17503d;if(_0x207bda[_0xb00b('0x35')][_0xb00b('0x52')]){_0x28ecf8['include']=[{'all':!![]}];}return db[_0xb00b('0x54')][_0xb00b('0x53')](_0x28ecf8);})[_0xb00b('0x16')](function(_0x2b66b7){_0x16e8ff['rows']=_0x2b66b7;return _0x16e8ff;});}})[_0xb00b('0x16')](respondWithFilteredResult(_0x37a4c0,_0x28ecf8))['catch'](handleError(_0x37a4c0,null));};exports[_0xb00b('0x57')]=function(_0x202d5f,_0x69b4e0){var _0x165442={'raw':!![],'where':{}};var _0x188349={};var _0x27e051={'count':0x0,'rows':[]};return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x202d5f[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x69b4e0,null))[_0xb00b('0x16')](function(_0x551a55){if(_0x551a55){_0x188349[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x59')][_0xb00b('0x28')]);_0x188349['query']=_[_0xb00b('0x34')](_0x202d5f[_0xb00b('0x35')]);_0x188349['filters']=_[_0xb00b('0x37')](_0x188349['model'],_0x188349[_0xb00b('0x35')]);_0x165442[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x188349['model'],qs[_0xb00b('0x39')](_0x202d5f[_0xb00b('0x35')][_0xb00b('0x39')]));_0x165442[_0xb00b('0x38')]=_0x165442[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x165442[_0xb00b('0x38')]:_0x188349[_0xb00b('0x33')];if(!_0x202d5f[_0xb00b('0x35')]['hasOwnProperty']('nolimit')){_0x165442[_0xb00b('0x12')]=qs[_0xb00b('0x12')](_0x202d5f[_0xb00b('0x35')][_0xb00b('0x12')]);_0x165442['offset']=qs[_0xb00b('0x10')](_0x202d5f[_0xb00b('0x35')]['offset']);}_0x165442[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x202d5f[_0xb00b('0x35')]['sort']);_0x165442[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_['pick'](_0x202d5f[_0xb00b('0x35')],_0x188349[_0xb00b('0x36')]));_0x165442[_0xb00b('0x2c')][_0xb00b('0x50')]=_0x551a55['id'];if(_0x202d5f[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x165442[_0xb00b('0x2c')]=_[_0xb00b('0x3b')](_0x165442['where'],{'$or':_[_0xb00b('0x27')](_0x165442[_0xb00b('0x38')],function(_0x320542){var _0x29d101={};_0x29d101[_0x320542]={'$like':'%'+_0x202d5f['query'][_0xb00b('0x1b')]+'%'};return _0x29d101;})});}_0x165442=_['merge']({},_0x165442,_0x202d5f[_0xb00b('0x3c')]);return db['CmHopperFinal'][_0xb00b('0x13')]({'where':_0x165442[_0xb00b('0x2c')]})[_0xb00b('0x16')](function(_0x3e0e49){_0x27e051[_0xb00b('0x13')]=_0x3e0e49;if(_0x202d5f['query'][_0xb00b('0x52')]){_0x165442[_0xb00b('0x2e')]=[{'all':!![]}];}return db['CmHopperFinal'][_0xb00b('0x53')](_0x165442);})['then'](function(_0x20a690){_0x27e051[_0xb00b('0x2f')]=_0x20a690;return _0x27e051;});}})[_0xb00b('0x16')](respondWithFilteredResult(_0x69b4e0,_0x165442))[_0xb00b('0x30')](handleError(_0x69b4e0,null));};exports['getHopperBlacks']=function(_0x3ae4a4,_0x76b483){var _0x190019={'raw':!![],'where':{}};var _0x44ea58={};var _0x11172e={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x3ae4a4[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x76b483,null))[_0xb00b('0x16')](function(_0x2d5652){if(_0x2d5652){_0x44ea58[_0xb00b('0x33')]=_['keys'](db['CmHopperBlack'][_0xb00b('0x28')]);_0x44ea58[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x3ae4a4[_0xb00b('0x35')]);_0x44ea58[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x44ea58[_0xb00b('0x33')],_0x44ea58['query']);_0x190019[_0xb00b('0x38')]=_['intersection'](_0x44ea58[_0xb00b('0x33')],qs['fields'](_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x39')]));_0x190019[_0xb00b('0x38')]=_0x190019[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x190019[_0xb00b('0x38')]:_0x44ea58[_0xb00b('0x33')];if(!_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x4d')](_0xb00b('0x4e'))){_0x190019[_0xb00b('0x12')]=qs['limit'](_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x12')]);_0x190019[_0xb00b('0x10')]=qs[_0xb00b('0x10')](_0x3ae4a4['query'][_0xb00b('0x10')]);}_0x190019[_0xb00b('0x55')]=qs['sort'](_0x3ae4a4[_0xb00b('0x35')]['sort']);_0x190019[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_['pick'](_0x3ae4a4[_0xb00b('0x35')],_0x44ea58[_0xb00b('0x36')]));_0x190019[_0xb00b('0x2c')][_0xb00b('0x50')]=_0x2d5652['id'];if(_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x190019['where']=_[_0xb00b('0x3b')](_0x190019['where'],{'$or':_[_0xb00b('0x27')](_0x190019[_0xb00b('0x38')],function(_0x140bfd){var _0x43fbc5={};_0x43fbc5[_0x140bfd]={'$like':'%'+_0x3ae4a4['query'][_0xb00b('0x1b')]+'%'};return _0x43fbc5;})});}_0x190019=_[_0xb00b('0x3b')]({},_0x190019,_0x3ae4a4[_0xb00b('0x3c')]);return db['CmHopperBlack'][_0xb00b('0x13')]({'where':_0x190019[_0xb00b('0x2c')]})[_0xb00b('0x16')](function(_0xcc2183){_0x11172e['count']=_0xcc2183;if(_0x3ae4a4[_0xb00b('0x35')][_0xb00b('0x52')]){_0x190019[_0xb00b('0x2e')]=[{'all':!![]}];}return db[_0xb00b('0x5a')][_0xb00b('0x53')](_0x190019);})[_0xb00b('0x16')](function(_0x568c0a){_0x11172e['rows']=_0x568c0a;return _0x11172e;});}})[_0xb00b('0x16')](respondWithFilteredResult(_0x76b483,_0x190019))[_0xb00b('0x30')](handleError(_0x76b483,null));};exports[_0xb00b('0x5b')]=function(_0x2ec514,_0x3de4f6){var _0x5f0fd8={};var _0x3d80e7={};var _0xbe553c;var _0x14597c;return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x2ec514[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x3de4f6,null))[_0xb00b('0x16')](function(_0x2414bd){if(_0x2414bd){_0xbe553c=_0x2414bd;_0x3d80e7[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x5c')][_0xb00b('0x28')]);_0x3d80e7[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x2ec514[_0xb00b('0x35')]);_0x3d80e7[_0xb00b('0x36')]=_['intersection'](_0x3d80e7['model'],_0x3d80e7[_0xb00b('0x35')]);_0x5f0fd8[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x3d80e7['model'],qs['fields'](_0x2ec514['query'][_0xb00b('0x39')]));_0x5f0fd8[_0xb00b('0x38')]=_0x5f0fd8[_0xb00b('0x38')]['length']?_0x5f0fd8[_0xb00b('0x38')]:_0x3d80e7[_0xb00b('0x33')];_0x5f0fd8[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x2ec514['query'][_0xb00b('0x4f')]);_0x5f0fd8[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_[_0xb00b('0x56')](_0x2ec514[_0xb00b('0x35')],_0x3d80e7[_0xb00b('0x36')]));if(_0x2ec514[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x5f0fd8['where']=_[_0xb00b('0x3b')](_0x5f0fd8[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0x5f0fd8[_0xb00b('0x38')],function(_0xf9c361){var _0x24c646={};_0x24c646[_0xf9c361]={'$like':'%'+_0x2ec514[_0xb00b('0x35')][_0xb00b('0x1b')]+'%'};return _0x24c646;})});}_0x5f0fd8=_['merge']({},_0x5f0fd8,_0x2ec514[_0xb00b('0x3c')]);return _0xbe553c[_0xb00b('0x5b')](_0x5f0fd8);}})[_0xb00b('0x16')](function(_0x122522){if(_0x122522){_0x14597c=_0x122522['length'];if(!_0x2ec514[_0xb00b('0x35')][_0xb00b('0x4d')](_0xb00b('0x4e'))){_0x5f0fd8[_0xb00b('0x12')]=qs[_0xb00b('0x12')](_0x2ec514[_0xb00b('0x35')][_0xb00b('0x12')]);_0x5f0fd8[_0xb00b('0x10')]=qs['offset'](_0x2ec514['query'][_0xb00b('0x10')]);}return _0xbe553c[_0xb00b('0x5b')](_0x5f0fd8);}})[_0xb00b('0x16')](function(_0x58894a){if(_0x58894a){return _0x58894a?{'count':_0x14597c,'rows':_0x58894a}:null;}})[_0xb00b('0x16')](respondWithResult(_0x3de4f6,null))[_0xb00b('0x30')](handleError(_0x3de4f6,null));};exports[_0xb00b('0x5d')]=function(_0x581548,_0x44d3c0){var _0x3d5880=_0x581548[_0xb00b('0x3e')]['teams'];var _0x58808e=_[_0xb00b('0x27')](_0x3d5880,'id');return db['Team'][_0xb00b('0x53')]({'where':{'id':_0x58808e},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id',_0xb00b('0x21'),_0xb00b('0x5e'),_0xb00b('0x5f'),_0xb00b('0x60')],'raw':!![]}]})[_0xb00b('0x16')](function(_0x5c5a04){if(_0x5c5a04){var _0x1aa5e5=_['flatMap'](_0x5c5a04,function(_0x592206){var _0x3551ca=_0x592206[_0xb00b('0x18')]({'plain':!![]});_0x3551ca[_0xb00b('0x61')][_0xb00b('0x62')](function(_0x8b31d3){_0x8b31d3[_0xb00b('0x63')]=_['find'](_0x3d5880,{'id':_0x3551ca['id']})[_0xb00b('0x63')];});return _0x3551ca['Agents'];});return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x581548[_0xb00b('0x32')]['id']}})['then'](function(_0x226527){return db[_0xb00b('0x64')][_0xb00b('0x65')](function(_0x3dc8d2){return _0x226527['addTeams'](_0x58808e,{'transaction':_0x3dc8d2})['then'](function(){return BPromise[_0xb00b('0x66')](_0x3d5880,function(_0x55bb31){return db['TeamVoiceQueue'][_0xb00b('0x67')]({'TeamId':_0x55bb31['id'],'VoiceQueueId':_0x581548['params']['id'],'penalty':_0x55bb31['penalty']},{'transaction':_0x3dc8d2});});})[_0xb00b('0x16')](function(){return BPromise[_0xb00b('0x66')](_0x1aa5e5,function(_0x745803){return db[_0xb00b('0x68')]['findOrCreate']({'where':{'UserId':_0x745803['id'],'VoiceQueueId':_0x581548['params']['id']},'defaults':{'penalty':_0x745803[_0xb00b('0x63')]},'transaction':_0x3dc8d2});});})[_0xb00b('0x16')](function(){return BPromise[_0xb00b('0x66')](_['filter'](_0x1aa5e5,{'online':!![]}),function(_0x48bac5){return db[_0xb00b('0x69')]['upsert']({'membername':_0x48bac5['name'],'UserId':_0x48bac5['id'],'queue_name':_0x226527[_0xb00b('0x21')],'VoiceQueueId':_0x226527['id'],'interface':_['isNil'](_0x48bac5[_0xb00b('0x60')])?util['format'](_0xb00b('0x6a'),_0x48bac5['name']):_0x48bac5[_0xb00b('0x60')],'paused':_0x48bac5[_0xb00b('0x5f')]||![],'penalty':_0x48bac5[_0xb00b('0x63')]},{'transaction':_0x3dc8d2});});})['then'](function(){_0x1aa5e5[_0xb00b('0x62')](function(_0x596092){socket[_0xb00b('0x6b')](_0xb00b('0x6c'),{'UserId':_0x596092['id'],'VoiceQueueId':_0x226527['id']});});});});});}})['then'](respondWithStatusCode(_0x44d3c0,null))['catch'](handleError(_0x44d3c0,null));};exports['removeTeams']=function(_0x552f73,_0x192b43){return db['Team'][_0xb00b('0x53')]({'where':{'id':_0x552f73['query'][_0xb00b('0x6d')]},'attributes':['id'],'include':[{'model':db[_0xb00b('0x6e')],'as':_0xb00b('0x61'),'attributes':['id'],'raw':!![]}]})[_0xb00b('0x16')](handleEntityNotFound(_0x192b43,null))[_0xb00b('0x16')](function(_0x5b1576){var _0x8292fe=_[_0xb00b('0x27')](_0x5b1576,'id');var _0x3c1cc5=[];var _0x38e425=[];var _0x515143=squel['select']();_0x515143[_0xb00b('0x6f')](_0xb00b('0x70'))[_0xb00b('0x71')](_0xb00b('0x72'),'tq')[_0xb00b('0x73')](_0xb00b('0x74'),'ut',_0xb00b('0x75'))[_0xb00b('0x2c')](_0xb00b('0x76'),_0x552f73['params']['id']);for(var _0x45bae8=0x0;_0x45bae8<_0x5b1576[_0xb00b('0x3a')];_0x45bae8+=0x1){let _0x496500=_0x5b1576[_0x45bae8];for(var _0x475ebb=0x0;_0x475ebb<_0x496500['Agents'][_0xb00b('0x3a')];_0x475ebb+=0x1){let _0x13054a=_0x496500['Agents'][_0x475ebb];var _0x4ce456=_0x515143[_0xb00b('0x47')]();_0x4ce456[_0xb00b('0x2c')](_0xb00b('0x77'),_0x13054a['id']);_0x38e425['push'](db[_0xb00b('0x64')][_0xb00b('0x35')](_0x4ce456[_0xb00b('0x78')](),{'type':db['sequelize'][_0xb00b('0x79')]['SELECT']})['then'](function(_0x58ea43){if(_0x58ea43[_0xb00b('0x3a')]===0x1){return _0x13054a['id'];}else{var _0x4d42af=_[_0xb00b('0x7a')](_[_0xb00b('0x27')](_0x58ea43,'TeamId'),function(_0x4c389f){return _[_0xb00b('0x1e')](_0x8292fe,_0x4c389f);});if(_0x4d42af){return _0x13054a['id'];}}}));}}return BPromise[_0xb00b('0x7b')](_0x38e425)['then'](function(_0x2f131e){_0x3c1cc5=_(_0x3c1cc5)[_0xb00b('0x7c')](_0x2f131e)[_0xb00b('0x7d')]()[_0xb00b('0x1d')]();return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x552f73['params']['id']}})[_0xb00b('0x16')](function(_0x22b425){return db['sequelize'][_0xb00b('0x65')](function(_0x4ed3c7){return _0x22b425['removeTeams'](_0x552f73[_0xb00b('0x35')]['ids'],{'transaction':_0x4ed3c7})[_0xb00b('0x16')](function(){if(!_[_0xb00b('0x7e')](_0x3c1cc5)){return _0x22b425[_0xb00b('0x7f')](_0x3c1cc5,{'transaction':_0x4ed3c7})['then'](function(){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x552f73[_0xb00b('0x32')]['id'],'UserId':_0x3c1cc5},'transaction':_0x4ed3c7});});}})[_0xb00b('0x16')](function(){_0x3c1cc5['forEach'](function(_0x20f4d2){socket[_0xb00b('0x6b')](_0xb00b('0x80'),{'UserId':_0x20f4d2,'VoiceQueueId':_0x22b425['id']});});});});});});})[_0xb00b('0x16')](respondWithStatusCode(_0x192b43,null))[_0xb00b('0x30')](handleError(_0x192b43,null));};exports[_0xb00b('0x81')]=function(_0x21ecef,_0x40f6f6){var _0x48125c,_0x1b097a;return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x21ecef['params']['id']}})['then'](handleEntityNotFound(_0x40f6f6,null))['then'](function(_0x1e66eb){if(_0x1e66eb){_0x1b097a=_0x1e66eb;return _0x1e66eb[_0xb00b('0x81')](_0x21ecef[_0xb00b('0x3e')]['ids'],_[_0xb00b('0x48')](_0x21ecef[_0xb00b('0x3e')],[_0xb00b('0x6d'),'id'])||{})[_0xb00b('0x82')](function(_0x2c3557){for(var _0x5b7137=0x0;_0x5b7137<_0x21ecef[_0xb00b('0x3e')]['ids'][_0xb00b('0x3a')];_0x5b7137+=0x1){socket[_0xb00b('0x6b')](_0xb00b('0x6c'),{'UserId':Number(_0x21ecef[_0xb00b('0x3e')][_0xb00b('0x6d')][_0x5b7137]),'VoiceQueueId':Number(_0x21ecef[_0xb00b('0x32')]['id'])});}return _0x2c3557;});}})['then'](function(_0xeaa6ea){_0x48125c=_0xeaa6ea||[];if(_0x1b097a){return db[_0xb00b('0x6e')][_0xb00b('0x53')]({'where':{'id':_0x21ecef[_0xb00b('0x3e')][_0xb00b('0x6d')]},'attributes':['id',_0xb00b('0x21'),_0xb00b('0x5e'),_0xb00b('0x5f'),_0xb00b('0x60')],'raw':!![]});}})[_0xb00b('0x16')](function(_0x5f1258){if(!_[_0xb00b('0x7e')](_0x5f1258)){var _0x33952b=[];for(var _0x4cd459=0x0;_0x4cd459<_0x5f1258[_0xb00b('0x3a')];_0x4cd459++){if(_0x5f1258[_0x4cd459]['online']){_0x33952b['push'](db['UserVoiceQueueRt'][_0xb00b('0x67')]({'membername':_0x5f1258[_0x4cd459]['name'],'UserId':_0x5f1258[_0x4cd459]['id'],'queue_name':_0x1b097a[_0xb00b('0x21')],'VoiceQueueId':_0x1b097a['id'],'interface':_[_0xb00b('0x83')](_0x5f1258[_0x4cd459][_0xb00b('0x60')])?util[_0xb00b('0x84')](_0xb00b('0x6a'),_0x5f1258[_0x4cd459][_0xb00b('0x21')]):_0x5f1258[_0x4cd459][_0xb00b('0x60')],'paused':_0x5f1258[_0x4cd459][_0xb00b('0x5f')]||![],'penalty':_0x21ecef[_0xb00b('0x3e')][_0xb00b('0x63')]||0x0}));}}return BPromise[_0xb00b('0x7b')](_0x33952b);}})[_0xb00b('0x16')](function(){return _0x48125c;})[_0xb00b('0x16')](respondWithResult(_0x40f6f6,null))[_0xb00b('0x30')](handleError(_0x40f6f6,null));};exports['removeAgents']=function(_0x31d2f0,_0x15f9cd){return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x31d2f0[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x15f9cd,null))[_0xb00b('0x16')](function(_0x387744){if(_0x387744){return _0x387744['removeAgents'](_0x31d2f0['query'][_0xb00b('0x6d')])[_0xb00b('0x16')](function(){if(_[_0xb00b('0x85')](_0x31d2f0[_0xb00b('0x35')][_0xb00b('0x6d')])){for(var _0x11f9b7=0x0;_0x11f9b7<_0x31d2f0[_0xb00b('0x35')][_0xb00b('0x6d')][_0xb00b('0x3a')];_0x11f9b7+=0x1){socket[_0xb00b('0x6b')](_0xb00b('0x80'),{'UserId':Number(_0x31d2f0['query'][_0xb00b('0x6d')][_0x11f9b7]),'VoiceQueueId':Number(_0x31d2f0['params']['id'])});}}else{socket[_0xb00b('0x6b')](_0xb00b('0x80'),{'UserId':Number(_0x31d2f0[_0xb00b('0x35')][_0xb00b('0x6d')]),'VoiceQueueId':Number(_0x31d2f0[_0xb00b('0x32')]['id'])});}});}})[_0xb00b('0x16')](function(_0x59c4b6){return db[_0xb00b('0x69')][_0xb00b('0x17')]({'where':{'VoiceQueueId':_0x31d2f0[_0xb00b('0x32')]['id'],'UserId':_0x31d2f0[_0xb00b('0x35')]['ids']}})[_0xb00b('0x16')](function(){return _0x59c4b6;});})[_0xb00b('0x16')](respondWithStatusCode(_0x15f9cd,null))['catch'](handleError(_0x15f9cd,null));};exports[_0xb00b('0x86')]=function(_0x16cca9,_0x3c57b2){var _0xca4a87={};var _0x456515={};var _0x26145a;var _0x31fa5b;return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x16cca9['params']['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x3c57b2,null))[_0xb00b('0x16')](function(_0x4b0306){if(_0x4b0306){_0x26145a=_0x4b0306;_0x456515[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x6e')][_0xb00b('0x28')]);_0x456515[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x16cca9[_0xb00b('0x35')]);_0x456515[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x456515[_0xb00b('0x33')],_0x456515[_0xb00b('0x35')]);_0xca4a87['attributes']=_[_0xb00b('0x37')](_0x456515[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x16cca9['query'][_0xb00b('0x39')]));_0xca4a87[_0xb00b('0x38')]=_0xca4a87[_0xb00b('0x38')][_0xb00b('0x3a')]?_0xca4a87['attributes']:_0x456515[_0xb00b('0x33')];_0xca4a87[_0xb00b('0x55')]=qs['sort'](_0x16cca9['query'][_0xb00b('0x4f')]);_0xca4a87[_0xb00b('0x2c')]=qs['filters'](_[_0xb00b('0x56')](_0x16cca9['query'],_0x456515['filters']));if(_0x16cca9[_0xb00b('0x35')]['filter']){_0xca4a87['where']=_[_0xb00b('0x3b')](_0xca4a87[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0xca4a87[_0xb00b('0x38')],function(_0x11e9b4){var _0x2ae27c={};_0x2ae27c[_0x11e9b4]={'$like':'%'+_0x16cca9[_0xb00b('0x35')][_0xb00b('0x1b')]+'%'};return _0x2ae27c;})});}_0xca4a87=_[_0xb00b('0x3b')]({},_0xca4a87,_0x16cca9[_0xb00b('0x3c')]);return _0x26145a[_0xb00b('0x86')](_0xca4a87);}})[_0xb00b('0x16')](function(_0x29ba55){if(_0x29ba55){_0x31fa5b=_0x29ba55[_0xb00b('0x3a')];if(!_0x16cca9['query'][_0xb00b('0x4d')](_0xb00b('0x4e'))){_0xca4a87['limit']=qs[_0xb00b('0x12')](_0x16cca9['query'][_0xb00b('0x12')]);_0xca4a87[_0xb00b('0x10')]=qs[_0xb00b('0x10')](_0x16cca9['query'][_0xb00b('0x10')]);}return _0x26145a[_0xb00b('0x86')](_0xca4a87);}})['then'](function(_0x8478c8){if(_0x8478c8){return _0x8478c8?{'count':_0x31fa5b,'rows':_0x8478c8}:null;}})[_0xb00b('0x16')](respondWithResult(_0x3c57b2,null))[_0xb00b('0x30')](handleError(_0x3c57b2,null));};exports[_0xb00b('0x87')]=function(_0x57bfab,_0x2dab12){var _0x47194e={};var _0x19d24b={};var _0x52b54b;var _0x571811;return db['VoiceQueue'][_0xb00b('0x58')]({'where':{'id':_0x57bfab[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x2dab12,null))[_0xb00b('0x16')](function(_0x344379){if(_0x344379){_0x52b54b=_0x344379;_0x19d24b[_0xb00b('0x33')]=_[_0xb00b('0x34')](db[_0xb00b('0x69')][_0xb00b('0x28')]);_0x19d24b['query']=_['keys'](_0x57bfab[_0xb00b('0x35')]);_0x19d24b[_0xb00b('0x36')]=_['intersection'](_0x19d24b[_0xb00b('0x33')],_0x19d24b['query']);_0x47194e[_0xb00b('0x38')]=_['intersection'](_0x19d24b[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x57bfab['query'][_0xb00b('0x39')]));_0x47194e[_0xb00b('0x38')]=_0x47194e['attributes'][_0xb00b('0x3a')]?_0x47194e['attributes']:_0x19d24b[_0xb00b('0x33')];_0x47194e[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x57bfab[_0xb00b('0x35')][_0xb00b('0x4f')]);_0x47194e[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_[_0xb00b('0x56')](_0x57bfab[_0xb00b('0x35')],_0x19d24b[_0xb00b('0x36')]));if(_0x57bfab['query']['filter']){_0x47194e[_0xb00b('0x2c')]=_['merge'](_0x47194e[_0xb00b('0x2c')],{'$or':_['map'](_0x47194e[_0xb00b('0x38')],function(_0x1600f1){var _0x58bd2a={};_0x58bd2a[_0x1600f1]={'$like':'%'+_0x57bfab[_0xb00b('0x35')]['filter']+'%'};return _0x58bd2a;})});}_0x47194e=_[_0xb00b('0x3b')]({},_0x47194e,_0x57bfab[_0xb00b('0x3c')]);return _0x52b54b['getMembers'](_0x47194e);}})[_0xb00b('0x16')](function(_0x307c52){if(_0x307c52){_0x571811=_0x307c52[_0xb00b('0x3a')];if(!_0x57bfab[_0xb00b('0x35')][_0xb00b('0x4d')]('nolimit')){_0x47194e[_0xb00b('0x12')]=qs[_0xb00b('0x12')](_0x57bfab['query']['limit']);_0x47194e[_0xb00b('0x10')]=qs['offset'](_0x57bfab['query']['offset']);}return _0x52b54b[_0xb00b('0x87')](_0x47194e);}})[_0xb00b('0x16')](function(_0x39eb7a){return _0x39eb7a?{'count':_0x571811,'rows':_0x39eb7a}:null;})[_0xb00b('0x16')](respondWithResult(_0x2dab12,null))['catch'](handleError(_0x2dab12,null));};exports[_0xb00b('0x88')]=function(_0x482fc4,_0x3232cc){var _0x89225a={};var _0x22f2f6={};var _0x459f30;var _0x5aa72a;return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x482fc4['params']['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x3232cc,null))[_0xb00b('0x16')](function(_0x4291a3){if(_0x4291a3){_0x459f30=_0x4291a3;_0x22f2f6['model']=_['keys'](db[_0xb00b('0x89')][_0xb00b('0x28')]);_0x22f2f6[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x482fc4[_0xb00b('0x35')]);_0x22f2f6[_0xb00b('0x36')]=_[_0xb00b('0x37')](_0x22f2f6['model'],_0x22f2f6['query']);_0x89225a[_0xb00b('0x38')]=_['intersection'](_0x22f2f6['model'],qs[_0xb00b('0x39')](_0x482fc4[_0xb00b('0x35')]['fields']));_0x89225a[_0xb00b('0x38')]=_0x89225a[_0xb00b('0x38')][_0xb00b('0x3a')]?_0x89225a['attributes']:_0x22f2f6[_0xb00b('0x33')];_0x89225a[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x482fc4[_0xb00b('0x35')][_0xb00b('0x4f')]);_0x89225a[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_['pick'](_0x482fc4[_0xb00b('0x35')],_0x22f2f6[_0xb00b('0x36')]));if(_0x482fc4['query']['filter']){_0x89225a['where']=_[_0xb00b('0x3b')](_0x89225a[_0xb00b('0x2c')],{'$or':_[_0xb00b('0x27')](_0x89225a[_0xb00b('0x38')],function(_0x3deb79){var _0x1901d1={};_0x1901d1[_0x3deb79]={'$like':'%'+_0x482fc4[_0xb00b('0x35')]['filter']+'%'};return _0x1901d1;})});}_0x89225a=_['merge']({},_0x89225a,_0x482fc4[_0xb00b('0x3c')]);return _0x459f30[_0xb00b('0x88')](_0x89225a);}})['then'](function(_0x3517d6){if(_0x3517d6){_0x5aa72a=_0x3517d6[_0xb00b('0x3a')];if(!_0x482fc4['query'][_0xb00b('0x4d')]('nolimit')){_0x89225a[_0xb00b('0x12')]=qs['limit'](_0x482fc4['query']['limit']);_0x89225a[_0xb00b('0x10')]=qs[_0xb00b('0x10')](_0x482fc4[_0xb00b('0x35')][_0xb00b('0x10')]);}return _0x459f30['getLists'](_0x89225a);}})[_0xb00b('0x16')](function(_0x481abb){if(_0x481abb){return _0x481abb?{'count':_0x5aa72a,'rows':_0x481abb}:null;}})[_0xb00b('0x16')](respondWithResult(_0x3232cc,null))[_0xb00b('0x30')](handleError(_0x3232cc,null));};exports[_0xb00b('0x8a')]=function(_0x7ecc19,_0x1cc9fb){var _0x259acf=moment()[_0xb00b('0x84')](_0xb00b('0x8b'));var _0x57834b,_0x5448bb;return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x7ecc19[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x1cc9fb,null))[_0xb00b('0x16')](function(_0x1e0206){if(_0x1e0206){_0x5448bb=_0x1e0206;return _0x1e0206[_0xb00b('0x8a')](_0x7ecc19[_0xb00b('0x3e')][_0xb00b('0x6d')],_['omit'](_0x7ecc19[_0xb00b('0x3e')],[_0xb00b('0x6d'),'id'])||{});}return null;})[_0xb00b('0x82')](function(_0x26b234){var _0x4fe674;_0x57834b=_0x26b234||[];var _0x45ad1f=[];if(_0x26b234){for(var _0x11b817=0x0;_0x11b817<_0x26b234[_0xb00b('0x3a')];_0x11b817+=0x1){var _0x89dd0a=_0x26b234[_0x11b817][_0xb00b('0x18')]({'plain':!![]});_0x5448bb[_0xb00b('0x8c')]=_0x7ecc19[_0xb00b('0x3e')][_0xb00b('0x8c')]?_0x7ecc19[_0xb00b('0x3e')]['dialCheckDuplicateType']:_0x5448bb['dialCheckDuplicateType'];switch(_0x5448bb[_0xb00b('0x8c')]){case _0xb00b('0x8d'):_0x4fe674=squel[_0xb00b('0x8e')]()[_0xb00b('0x8f')](_0xb00b('0x90'))[_0xb00b('0x91')]([_0xb00b('0x92'),'scheduledAt',_0xb00b('0x93'),_0xb00b('0x94'),_0xb00b('0x50'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()['field'](_0xb00b('0x92'),_0xb00b('0x92'))['field']('\x27'+_0x259acf+'\x27',_0xb00b('0x96'))[_0xb00b('0x6f')]('id',_0xb00b('0x93'))[_0xb00b('0x6f')](_0x89dd0a[_0xb00b('0x97')][_0xb00b('0x78')](),'ListId')['field'](_0x7ecc19[_0xb00b('0x32')]['id']['toString'](),'VoiceQueueId')['field']('\x27'+_0x259acf+'\x27',_0xb00b('0x49'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27','updatedAt')['from'](_0xb00b('0x98'))[_0xb00b('0x2c')](_0xb00b('0x99'))[_0xb00b('0x2c')](_0xb00b('0x9a'),_0x89dd0a[_0xb00b('0x97')][_0xb00b('0x78')]())[_0xb00b('0x2c')](_0xb00b('0x9b'))[_0xb00b('0x2c')](_0xb00b('0x9c'),squel['select']()[_0xb00b('0x6f')](_0xb00b('0x9d'))[_0xb00b('0x71')](_0xb00b('0x9e'))[_0xb00b('0x2c')](_0xb00b('0x76'),_0x7ecc19['params']['id'][_0xb00b('0x78')]()))[_0xb00b('0x2c')](_0xb00b('0x9c'),squel[_0xb00b('0x95')]()['field']('COALESCE(phone,\x27\x27)')[_0xb00b('0x71')](_0xb00b('0x90'))[_0xb00b('0x2c')](_0xb00b('0x76'),_0x7ecc19[_0xb00b('0x32')]['id'][_0xb00b('0x78')]())))[_0xb00b('0x78')]();break;case _0xb00b('0x9f'):_0x4fe674=squel[_0xb00b('0x8e')]()[_0xb00b('0x8f')](_0xb00b('0x90'))['fromQuery']([_0xb00b('0x92'),_0xb00b('0x96'),_0xb00b('0x93'),_0xb00b('0x94'),_0xb00b('0x50'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()['field'](_0xb00b('0x92'),_0xb00b('0x92'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x96'))['field']('id','ContactId')['field'](_0x89dd0a[_0xb00b('0x97')]['toString'](),_0xb00b('0x94'))[_0xb00b('0x6f')](_0x7ecc19[_0xb00b('0x32')]['id'][_0xb00b('0x78')](),'VoiceQueueId')['field']('\x27'+_0x259acf+'\x27',_0xb00b('0x49'))['field']('\x27'+_0x259acf+'\x27','updatedAt')[_0xb00b('0x71')]('cm_contacts')[_0xb00b('0x2c')](_0xb00b('0x99'))[_0xb00b('0x2c')](_0xb00b('0x9a'),_0x89dd0a['CmListId'][_0xb00b('0x78')]())[_0xb00b('0x2c')](_0xb00b('0x9b'))[_0xb00b('0x2c')](_0xb00b('0x9c'),squel['select']()['field']('COALESCE(phone,\x27\x27)')[_0xb00b('0x71')](_0xb00b('0x90'))['where'](_0xb00b('0x76'),_0x7ecc19[_0xb00b('0x32')]['id'][_0xb00b('0x78')]())))[_0xb00b('0x78')]();break;default:_0x4fe674=squel['insert']()[_0xb00b('0x8f')](_0xb00b('0x90'))[_0xb00b('0x91')]([_0xb00b('0x92'),'scheduledAt',_0xb00b('0x93'),'ListId',_0xb00b('0x50'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()[_0xb00b('0x6f')](_0xb00b('0x92'),_0xb00b('0x92'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x96'))[_0xb00b('0x6f')]('id',_0xb00b('0x93'))[_0xb00b('0x6f')](_0x89dd0a[_0xb00b('0x97')][_0xb00b('0x78')](),_0xb00b('0x94'))[_0xb00b('0x6f')](_0x7ecc19[_0xb00b('0x32')]['id']['toString'](),_0xb00b('0x50'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x49'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x4a'))['from'](_0xb00b('0x98'))[_0xb00b('0x2c')](_0xb00b('0x99'))[_0xb00b('0x2c')](_0xb00b('0x9a'),_0x89dd0a[_0xb00b('0x97')][_0xb00b('0x78')]())['where'](_0xb00b('0x9b')))['toString']();}_0x45ad1f[_0xb00b('0xa0')](db[_0xb00b('0x64')][_0xb00b('0x35')](_0x4fe674));}return BPromise['all'](_0x45ad1f);}})[_0xb00b('0x16')](function(){var _0x2bf68f=[];var _0x283ad6=squel[_0xb00b('0x8e')]()['into']('cm_hopper_additional_phones')[_0xb00b('0x91')]([_0xb00b('0xa1'),'phone',_0xb00b('0xa2'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()['field']('h.id')[_0xb00b('0x6f')](_0xb00b('0xa3'))[_0xb00b('0x6f')](_0xb00b('0xa4'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x49'))[_0xb00b('0x6f')]('\x27'+_0x259acf+'\x27',_0xb00b('0x4a'))['from'](_0xb00b('0xa5'),'ci')[_0xb00b('0x73')](_0xb00b('0x90'),'h',_0xb00b('0xa6'))[_0xb00b('0x2c')](_0xb00b('0xa7'),_0x259acf)[_0xb00b('0x2c')]('ci.ItemClass=?',_0xb00b('0xa8')))[_0xb00b('0x78')]();_0x2bf68f[_0xb00b('0xa0')](db[_0xb00b('0x64')][_0xb00b('0x35')](_0x283ad6));return BPromise[_0xb00b('0x7b')](_0x2bf68f);})[_0xb00b('0x16')](function(){return _0x57834b;})[_0xb00b('0x16')](respondWithResult(_0x1cc9fb,null))[_0xb00b('0x30')](handleError(_0x1cc9fb,null));};exports[_0xb00b('0xa9')]=function(_0x229197,_0x5ce3f3){return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x229197[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x5ce3f3,null))[_0xb00b('0x16')](function(_0x406469){if(_0x406469){return _0x406469['removeLists'](_0x229197[_0xb00b('0x35')][_0xb00b('0x6d')]);}})[_0xb00b('0x16')](function(_0x4ffe41){if(_0x4ffe41){return db['CmHopper'][_0xb00b('0x17')]({'where':{'ListId':_0x229197['query'][_0xb00b('0x6d')],'VoiceQueueId':_0x229197[_0xb00b('0x32')]['id']}})['then'](function(){return _0x4ffe41;});}})[_0xb00b('0x16')](respondWithStatusCode(_0x5ce3f3,null))['catch'](handleError(_0x5ce3f3,null));};exports['getBlackLists']=function(_0x122be3,_0x4cb6ba){var _0x3ca253={};var _0x438281={};var _0x23b994;var _0x564934;return db[_0xb00b('0x2d')][_0xb00b('0x58')]({'where':{'id':_0x122be3[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x4cb6ba,null))[_0xb00b('0x16')](function(_0x18f5ac){if(_0x18f5ac){_0x23b994=_0x18f5ac;_0x438281[_0xb00b('0x33')]=_['keys'](db[_0xb00b('0x89')]['rawAttributes']);_0x438281[_0xb00b('0x35')]=_[_0xb00b('0x34')](_0x122be3[_0xb00b('0x35')]);_0x438281[_0xb00b('0x36')]=_['intersection'](_0x438281[_0xb00b('0x33')],_0x438281[_0xb00b('0x35')]);_0x3ca253[_0xb00b('0x38')]=_[_0xb00b('0x37')](_0x438281[_0xb00b('0x33')],qs[_0xb00b('0x39')](_0x122be3['query'][_0xb00b('0x39')]));_0x3ca253[_0xb00b('0x38')]=_0x3ca253['attributes'][_0xb00b('0x3a')]?_0x3ca253[_0xb00b('0x38')]:_0x438281[_0xb00b('0x33')];_0x3ca253[_0xb00b('0x55')]=qs[_0xb00b('0x4f')](_0x122be3[_0xb00b('0x35')][_0xb00b('0x4f')]);_0x3ca253[_0xb00b('0x2c')]=qs[_0xb00b('0x36')](_[_0xb00b('0x56')](_0x122be3[_0xb00b('0x35')],_0x438281[_0xb00b('0x36')]));if(_0x122be3[_0xb00b('0x35')][_0xb00b('0x1b')]){_0x3ca253['where']=_['merge'](_0x3ca253['where'],{'$or':_[_0xb00b('0x27')](_0x3ca253[_0xb00b('0x38')],function(_0x966247){var _0x58b695={};_0x58b695[_0x966247]={'$like':'%'+_0x122be3[_0xb00b('0x35')][_0xb00b('0x1b')]+'%'};return _0x58b695;})});}_0x3ca253=_[_0xb00b('0x3b')]({},_0x3ca253,_0x122be3[_0xb00b('0x3c')]);return _0x23b994[_0xb00b('0xaa')](_0x3ca253);}})['then'](function(_0x1bafb2){if(_0x1bafb2){_0x564934=_0x1bafb2['length'];if(!_0x122be3['query']['hasOwnProperty'](_0xb00b('0x4e'))){_0x3ca253[_0xb00b('0x12')]=qs['limit'](_0x122be3[_0xb00b('0x35')][_0xb00b('0x12')]);_0x3ca253[_0xb00b('0x10')]=qs['offset'](_0x122be3[_0xb00b('0x35')]['offset']);}return _0x23b994[_0xb00b('0xaa')](_0x3ca253);}})[_0xb00b('0x16')](function(_0x2e3e5a){if(_0x2e3e5a){return _0x2e3e5a?{'count':_0x564934,'rows':_0x2e3e5a}:null;}})[_0xb00b('0x16')](respondWithResult(_0x4cb6ba,null))['catch'](handleError(_0x4cb6ba,null));};exports['addBlackLists']=function(_0x470c4a,_0x12cc9d){var _0xe5b66f;return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x470c4a[_0xb00b('0x32')]['id']}})['then'](handleEntityNotFound(_0x12cc9d,null))[_0xb00b('0x16')](function(_0x3afb66){if(_0x3afb66){return _0x3afb66[_0xb00b('0xab')](_0x470c4a[_0xb00b('0x3e')]['ids'],_[_0xb00b('0x48')](_0x470c4a[_0xb00b('0x3e')],[_0xb00b('0x6d'),'id'])||{});}return null;})[_0xb00b('0x82')](function(_0x379b81){var _0x46c784;_0xe5b66f=_0x379b81||[];var _0x471db4=[];if(_0x379b81){for(var _0x333bee=0x0;_0x333bee<_0x379b81['length'];_0x333bee+=0x1){var _0x1a94bf=_0x379b81[_0x333bee][_0xb00b('0x18')]({'plain':!![]});_0x46c784=squel[_0xb00b('0x8e')]()['into'](_0xb00b('0xac'))[_0xb00b('0x91')]([_0xb00b('0x92'),'ContactId',_0xb00b('0x94'),_0xb00b('0x50'),_0xb00b('0x49'),_0xb00b('0x4a')],squel[_0xb00b('0x95')]()[_0xb00b('0x6f')](_0xb00b('0x92'),'phone')[_0xb00b('0x6f')]('id',_0xb00b('0x93'))[_0xb00b('0x6f')](_0x1a94bf['CmListId'][_0xb00b('0x78')](),_0xb00b('0x94'))[_0xb00b('0x6f')](_0x470c4a[_0xb00b('0x32')]['id']['toString'](),_0xb00b('0x50'))['field'](_0xb00b('0xad'),_0xb00b('0x49'))['field'](_0xb00b('0xad'),_0xb00b('0x4a'))[_0xb00b('0x71')](_0xb00b('0x98'))[_0xb00b('0x2c')]('deletedAt\x20IS\x20NULL')['where'](_0xb00b('0x9a'),_0x1a94bf[_0xb00b('0x97')][_0xb00b('0x78')]())['where'](_0xb00b('0x9b')))[_0xb00b('0x78')]();_0x471db4[_0xb00b('0xa0')](db['sequelize'][_0xb00b('0x35')](_0x46c784));}return BPromise[_0xb00b('0x7b')](_0x471db4);}})[_0xb00b('0x16')](function(){return _0xe5b66f;})['then'](respondWithResult(_0x12cc9d,null))[_0xb00b('0x30')](handleError(_0x12cc9d,null));};exports[_0xb00b('0xae')]=function(_0x4d30c3,_0x5099fd){return db[_0xb00b('0x2d')][_0xb00b('0x20')]({'where':{'id':_0x4d30c3[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](handleEntityNotFound(_0x5099fd,null))['then'](function(_0x45b2e1){if(_0x45b2e1){return _0x45b2e1[_0xb00b('0xae')](_0x4d30c3[_0xb00b('0x35')][_0xb00b('0x6d')]);}})[_0xb00b('0x16')](function(_0x5e12dc){if(_0x5e12dc){return db[_0xb00b('0x5a')][_0xb00b('0x17')]({'where':{'ListId':_0x4d30c3[_0xb00b('0x35')][_0xb00b('0x6d')],'VoiceQueueId':_0x4d30c3[_0xb00b('0x32')]['id']}})[_0xb00b('0x16')](function(){return _0x5e12dc;});}})[_0xb00b('0x16')](respondWithStatusCode(_0x5099fd,null))[_0xb00b('0x30')](handleError(_0x5099fd,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff