// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x486d=['save','update','then','destroy','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','value','type','find','name','stack','send','index','map','VoiceQueue','rawAttributes','model','query','keys','filters','intersection','attributes','fields','nolimit','order','sort','where','pick','merge','includeAll','include','findAll','rows','show','params','length','options','create','body','user','role','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','catch','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','getHoppers','findOne','CmHopper','hasOwnProperty','VoiceQueueId','getHopperHistories','CmHopperHistory','CmHopperFinal','getHopperBlacks','CmHopperBlack','Team','getTeams','addTeams','teams','User','Agents','online','flatMap','forEach','penalty','sequelize','transaction','each','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','upsert','isNil','format','interface','voicePause','emit','userVoiceQueue:save','removeTeams','ids','select','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','VoiceQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','QueryTypes','every','all','union','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','SIP/%s','isArray','getAgents','getLists','addLists','spread','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','scheduledAt','ContactId','ListId','field','NOW()','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','COALESCE(phone,\x27\x27)','onlyIfOpen','phone','cm_contacts','removeLists','getBlackLists','CmList','addBlackLists','removeBlackLists','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','path','sox','to-csv','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../config/license/hardware','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','register','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x486d,0x140));var _0xd486=function(_0x244d28,_0x2856b2){_0x244d28=_0x244d28-0x0;var _0x35dc8a=_0x486d[_0x244d28];return _0x35dc8a;};'use strict';var pdf=require(_0xd486('0x0'));var emlformat=require(_0xd486('0x1'));var rimraf=require(_0xd486('0x2'));var zipdir=require(_0xd486('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0xd486('0x4'));var moment=require(_0xd486('0x5'));var BPromise=require(_0xd486('0x6'));var Mustache=require('mustache');var util=require('util');var path=require(_0xd486('0x7'));var sox=require(_0xd486('0x8'));var csv=require(_0xd486('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xd486('0xa'));var squel=require(_0xd486('0xb'));var crypto=require(_0xd486('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xd486('0xd'));var toCsv=require(_0xd486('0x9'));var querystring=require(_0xd486('0xe'));var Papa=require(_0xd486('0xf'));var Redis=require(_0xd486('0x10'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xd486('0x11'));var logger=require('../../config/logger')('api');var utils=require(_0xd486('0x12'));var config=require(_0xd486('0x13'));var licenseUtil=require(_0xd486('0x14'));var db=require(_0xd486('0x15'))['db'];config[_0xd486('0x16')]=_[_0xd486('0x17')](config[_0xd486('0x16')],{'host':_0xd486('0x18'),'port':0x18eb});var socket=require(_0xd486('0x19'))(new Redis(config[_0xd486('0x16')]));require(_0xd486('0x1a'))[_0xd486('0x1b')](socket);function respondWithStatusCode(_0x1ee2fb,_0x46eb17){_0x46eb17=_0x46eb17||0xcc;return function(_0xd1ace9){if(_0xd1ace9){return _0x1ee2fb[_0xd486('0x1c')](_0x46eb17);}return _0x1ee2fb[_0xd486('0x1d')](_0x46eb17)[_0xd486('0x1e')]();};}function respondWithResult(_0x12fd98,_0x3bd13e){_0x3bd13e=_0x3bd13e||0xc8;return function(_0x288a0e){if(_0x288a0e){return _0x12fd98[_0xd486('0x1d')](_0x3bd13e)[_0xd486('0x1f')](_0x288a0e);}};}function respondWithFilteredResult(_0x2ce1ba,_0x115ee7){return function(_0x19b143){if(_0x19b143){var _0xac053=_0x19b143[_0xd486('0x20')],_0x2d5b50=_0x115ee7[_0xd486('0x21')],_0x179d45=_0x115ee7[_0xd486('0x21')]+_0x115ee7[_0xd486('0x22')],_0x32e265;if(_0x179d45>=_0xac053){_0x179d45=_0xac053;_0x32e265=0xc8;}else{_0x32e265=0xce;}_0x2ce1ba[_0xd486('0x1d')](_0x32e265);return _0x2ce1ba['set'](_0xd486('0x23'),_0x2d5b50+'-'+_0x179d45+'/'+_0xac053)[_0xd486('0x1f')](_0x19b143);}return null;};}function patchUpdates(_0x406287){return function(_0x3a7a68){try{jsonpatch[_0xd486('0x24')](_0x3a7a68,_0x406287,!![]);}catch(_0x579580){return BPromise[_0xd486('0x25')](_0x579580);}return _0x3a7a68[_0xd486('0x26')]();};}function saveUpdates(_0x8e636,_0x57cb80){return function(_0x4346dd){if(_0x4346dd){return _0x4346dd[_0xd486('0x27')](_0x8e636)[_0xd486('0x28')](function(_0x1d9a19){return _0x1d9a19;});}return null;};}function removeEntity(_0x571d6c,_0x19cf1b){return function(_0x233fff){if(_0x233fff){return _0x233fff[_0xd486('0x29')]()[_0xd486('0x28')](function(){var _0x5ab435=_0x233fff[_0xd486('0x2a')]({'plain':!![]});var _0x493fdd=[{'name':_0xd486('0x2b'),'value':_0xd486('0x2c'),'ignore':![]},{'name':_0xd486('0x2d'),'value':_0xd486('0x2e'),'ignore':![]}];var _0x6bda15=_(_0x493fdd)[_0xd486('0x2f')](_0xd486('0x30'))['map']('value')[_0xd486('0x31')]();if(_['includes'](_0x6bda15,_0x5ab435[_0xd486('0x32')])){return;}var _0x2bd0df=_[_0xd486('0x33')](_0x493fdd,[_0xd486('0x31'),_0x5ab435[_0xd486('0x32')]])[_0xd486('0x34')];return db['UserProfileResource'][_0xd486('0x29')]({'where':{'type':_0x2bd0df,'resourceId':_0x5ab435['id']}})['then'](function(){return _0x233fff;});})[_0xd486('0x28')](function(){_0x571d6c[_0xd486('0x1d')](0xcc)[_0xd486('0x1e')]();});}};}function handleEntityNotFound(_0x3eb626,_0x414fe3){return function(_0x226fd7){if(!_0x226fd7){_0x3eb626['sendStatus'](0x194);}return _0x226fd7;};}function handleError(_0x29499e,_0x504429){_0x504429=_0x504429||0x1f4;return function(_0x2a8f16){logger['error'](_0x2a8f16[_0xd486('0x35')]);if(_0x2a8f16[_0xd486('0x34')]){delete _0x2a8f16[_0xd486('0x34')];}_0x29499e[_0xd486('0x1d')](_0x504429)[_0xd486('0x36')](_0x2a8f16);};}exports[_0xd486('0x37')]=function(_0x5ac055,_0x5cfaf4){var _0x2b1adc={},_0x5afc5c={},_0x342065={'count':0x0,'rows':[]};var _0xe403ec=_[_0xd486('0x38')](db[_0xd486('0x39')][_0xd486('0x3a')],function(_0x7cd29a){return{'name':_0x7cd29a['fieldName'],'type':_0x7cd29a['type']['key']};});_0x5afc5c[_0xd486('0x3b')]=_['map'](_0xe403ec,_0xd486('0x34'));_0x5afc5c[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x5ac055[_0xd486('0x3c')]);_0x5afc5c[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x5afc5c[_0xd486('0x3b')],_0x5afc5c[_0xd486('0x3c')]);_0x2b1adc[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x5afc5c[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x5ac055[_0xd486('0x3c')][_0xd486('0x41')]));_0x2b1adc[_0xd486('0x40')]=_0x2b1adc[_0xd486('0x40')]['length']?_0x2b1adc['attributes']:_0x5afc5c['model'];if(!_0x5ac055[_0xd486('0x3c')]['hasOwnProperty'](_0xd486('0x42'))){_0x2b1adc['limit']=qs[_0xd486('0x22')](_0x5ac055[_0xd486('0x3c')][_0xd486('0x22')]);_0x2b1adc[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x5ac055[_0xd486('0x3c')][_0xd486('0x21')]);}_0x2b1adc[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x5ac055[_0xd486('0x3c')]['sort']);_0x2b1adc[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x5ac055['query'],_0x5afc5c[_0xd486('0x3e')]),_0xe403ec);if(_0x5ac055[_0xd486('0x3c')][_0xd486('0x2f')]){_0x2b1adc['where']=_[_0xd486('0x47')](_0x2b1adc[_0xd486('0x45')],{'$or':_['map'](_0xe403ec,function(_0x243fc6){if(_0x243fc6[_0xd486('0x32')]!=='VIRTUAL'){var _0x5867bb={};_0x5867bb[_0x243fc6[_0xd486('0x34')]]={'$like':'%'+_0x5ac055['query'][_0xd486('0x2f')]+'%'};return _0x5867bb;}})});}_0x2b1adc=_[_0xd486('0x47')]({},_0x2b1adc,_0x5ac055['options']);var _0x16b8be={'where':_0x2b1adc[_0xd486('0x45')]};return db[_0xd486('0x39')][_0xd486('0x20')](_0x16b8be)[_0xd486('0x28')](function(_0x3a66a3){_0x342065[_0xd486('0x20')]=_0x3a66a3;if(_0x5ac055['query'][_0xd486('0x48')]){_0x2b1adc[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x39')][_0xd486('0x4a')](_0x2b1adc);})[_0xd486('0x28')](function(_0x5791e4){_0x342065[_0xd486('0x4b')]=_0x5791e4;return _0x342065;})['then'](respondWithFilteredResult(_0x5cfaf4,_0x2b1adc))['catch'](handleError(_0x5cfaf4,null));};exports[_0xd486('0x4c')]=function(_0x16f1ac,_0x51c7bb){var _0x131f0f={'raw':![],'where':{'id':_0x16f1ac[_0xd486('0x4d')]['id']}},_0x5daf56={};_0x5daf56['model']=_['keys'](db[_0xd486('0x39')][_0xd486('0x3a')]);_0x5daf56[_0xd486('0x3c')]=_['keys'](_0x16f1ac[_0xd486('0x3c')]);_0x5daf56['filters']=_[_0xd486('0x3f')](_0x5daf56[_0xd486('0x3b')],_0x5daf56['query']);_0x131f0f['attributes']=_['intersection'](_0x5daf56['model'],qs[_0xd486('0x41')](_0x16f1ac['query']['fields']));_0x131f0f['attributes']=_0x131f0f['attributes'][_0xd486('0x4e')]?_0x131f0f[_0xd486('0x40')]:_0x5daf56[_0xd486('0x3b')];if(_0x16f1ac[_0xd486('0x3c')]['includeAll']){_0x131f0f[_0xd486('0x49')]=[{'all':!![]}];}_0x131f0f=_[_0xd486('0x47')]({},_0x131f0f,_0x16f1ac[_0xd486('0x4f')]);return db[_0xd486('0x39')][_0xd486('0x33')](_0x131f0f)[_0xd486('0x28')](handleEntityNotFound(_0x51c7bb,null))[_0xd486('0x28')](respondWithResult(_0x51c7bb,null))['catch'](handleError(_0x51c7bb,null));};exports[_0xd486('0x50')]=function(_0x2ab0ad,_0x40fea5){return db[_0xd486('0x39')]['create'](_0x2ab0ad[_0xd486('0x51')],{})[_0xd486('0x28')](function(_0xa3b09b){var _0x85e6ad=_0x2ab0ad[_0xd486('0x52')]['get']({'plain':!![]});if(!_0x85e6ad)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x85e6ad[_0xd486('0x53')]===_0xd486('0x52')){var _0x563228=_0xa3b09b[_0xd486('0x2a')]({'plain':!![]});var _0x450ea2=[{'name':_0xd486('0x2b'),'value':_0xd486('0x2c')},{'name':_0xd486('0x2d'),'value':_0xd486('0x2e')}];var _0x19832c=_[_0xd486('0x33')](_0x450ea2,['value',_0x563228[_0xd486('0x32')]])[_0xd486('0x34')];return db[_0xd486('0x54')][_0xd486('0x33')]({'where':{'name':_0x19832c,'userProfileId':_0x85e6ad[_0xd486('0x55')]},'raw':!![]})[_0xd486('0x28')](function(_0x2c817a){if(_0x2c817a&&_0x2c817a[_0xd486('0x56')]===0x0){return db[_0xd486('0x57')][_0xd486('0x50')]({'name':_0x563228[_0xd486('0x34')],'resourceId':_0x563228['id'],'type':_0x2c817a['name'],'sectionId':_0x2c817a['id']},{})['then'](function(){return _0xa3b09b;});}else{return _0xa3b09b;}})[_0xd486('0x58')](function(_0x2a77b8){logger[_0xd486('0x59')](_0xd486('0x5a'),_0x2a77b8);throw _0x2a77b8;});}return _0xa3b09b;})[_0xd486('0x28')](respondWithResult(_0x40fea5,0xc9))[_0xd486('0x58')](handleError(_0x40fea5,null));};exports['clone']=function(_0x4ee7a4,_0x2bca08){var _0x23b76f={'where':{'id':_0x4ee7a4['params']['id']}},_0x50b03e={};_0x50b03e[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0x39')][_0xd486('0x3a')]);_0x23b76f[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x50b03e[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x4ee7a4[_0xd486('0x3c')][_0xd486('0x41')]));_0x23b76f[_0xd486('0x40')]=_0x23b76f[_0xd486('0x40')][_0xd486('0x4e')]?_0x23b76f[_0xd486('0x40')]:_0x50b03e[_0xd486('0x3b')];if(_0x4ee7a4[_0xd486('0x3c')][_0xd486('0x48')]){_0x23b76f[_0xd486('0x49')]=[{'all':!![]}];}_0x23b76f=_[_0xd486('0x47')]({},_0x23b76f,_0x4ee7a4[_0xd486('0x4f')]);return db[_0xd486('0x39')][_0xd486('0x33')](_0x23b76f)[_0xd486('0x28')](handleEntityNotFound(_0x2bca08,null))[_0xd486('0x28')](function(_0x15a858){if(_0x15a858){var _0x251068=_0x15a858[_0xd486('0x2a')]({'plain':!![]});_0x251068=qs[_0xd486('0x5b')](_0x251068,['id',_0xd486('0x5c'),_0xd486('0x5d')]);_0x4ee7a4[_0xd486('0x51')]=_['omit'](_0x4ee7a4[_0xd486('0x51')],['id',_0xd486('0x5c'),_0xd486('0x5d')]);return db[_0xd486('0x39')][_0xd486('0x50')](_[_0xd486('0x47')](_0x251068,_0x4ee7a4[_0xd486('0x51')]),{'include':_0x4ee7a4[_0xd486('0x3c')][_0xd486('0x48')]?[{'all':!![]}]:undefined})[_0xd486('0x28')](function(_0x28fc4e){var _0x1e171c=_0x4ee7a4[_0xd486('0x52')]['get']({'plain':!![]});if(!_0x1e171c)throw new Error(_0xd486('0x5e'));if(_0x1e171c[_0xd486('0x53')]==='user'){var _0x3b7348=_0x28fc4e[_0xd486('0x2a')]({'plain':!![]});var _0x4c3cd1=[{'name':'VoiceQueues','value':'inbound'},{'name':'QueueCampaigns','value':_0xd486('0x2e')}];var _0x5456d5=_[_0xd486('0x33')](_0x4c3cd1,[_0xd486('0x31'),_0x3b7348[_0xd486('0x32')]])['name'];return db[_0xd486('0x54')][_0xd486('0x33')]({'where':{'name':_0x5456d5,'userProfileId':_0x1e171c['userProfileId']},'raw':!![]})[_0xd486('0x28')](function(_0x1e9c91){if(_0x1e9c91&&_0x1e9c91['autoAssociation']===0x0){return db[_0xd486('0x57')][_0xd486('0x50')]({'name':_0x3b7348[_0xd486('0x34')],'resourceId':_0x3b7348['id'],'type':_0x1e9c91['name'],'sectionId':_0x1e9c91['id']},{})[_0xd486('0x28')](function(){return _0x28fc4e;});}else{return _0x28fc4e;}})[_0xd486('0x58')](function(_0x43a24e){logger['error'](_0xd486('0x5a'),_0x43a24e);throw _0x43a24e;});}return _0x28fc4e;});}})['then'](respondWithResult(_0x2bca08,0xc9))[_0xd486('0x58')](handleError(_0x2bca08,null));};exports[_0xd486('0x27')]=function(_0x482155,_0x129353){if(_0x482155[_0xd486('0x51')]['id']){delete _0x482155[_0xd486('0x51')]['id'];}return db['VoiceQueue']['find']({'where':{'id':_0x482155['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x129353,null))['then'](saveUpdates(_0x482155[_0xd486('0x51')],null))['then'](respondWithResult(_0x129353,null))[_0xd486('0x58')](handleError(_0x129353,null));};exports[_0xd486('0x29')]=function(_0x44fc33,_0x2f9e55){return db[_0xd486('0x39')]['find']({'where':{'id':_0x44fc33[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x2f9e55,null))['then'](removeEntity(_0x2f9e55,null))[_0xd486('0x58')](handleError(_0x2f9e55,null));};exports[_0xd486('0x5f')]=function(_0x2bd391,_0x3ebdc9,_0x59e5f4){var _0x45ca2c={'raw':![],'where':{}};var _0x1bf7d8={};var _0x4f6c05={'count':0x0,'rows':[]};return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x2bd391[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x3ebdc9,null))['then'](function(_0x4ec9a6){if(_0x4ec9a6){_0x1bf7d8[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0x61')][_0xd486('0x3a')]);_0x1bf7d8[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x2bd391[_0xd486('0x3c')]);_0x1bf7d8[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x1bf7d8[_0xd486('0x3b')],_0x1bf7d8[_0xd486('0x3c')]);_0x45ca2c[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x1bf7d8[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x2bd391[_0xd486('0x3c')][_0xd486('0x41')]));_0x45ca2c[_0xd486('0x40')]=_0x45ca2c[_0xd486('0x40')][_0xd486('0x4e')]?_0x45ca2c[_0xd486('0x40')]:_0x1bf7d8['model'];if(!_0x2bd391[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x45ca2c[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x2bd391[_0xd486('0x3c')][_0xd486('0x22')]);_0x45ca2c[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x2bd391[_0xd486('0x3c')]['offset']);}_0x45ca2c['order']=qs[_0xd486('0x44')](_0x2bd391['query'][_0xd486('0x44')]);_0x45ca2c[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x2bd391['query'],_0x1bf7d8[_0xd486('0x3e')]));_0x45ca2c[_0xd486('0x45')][_0xd486('0x63')]=_0x4ec9a6['id'];if(_0x2bd391['query'][_0xd486('0x2f')]){_0x45ca2c['where']=_[_0xd486('0x47')](_0x45ca2c[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0x45ca2c[_0xd486('0x40')],function(_0x2643b4){var _0x329a29={};_0x329a29[_0x2643b4]={'$like':'%'+_0x2bd391['query'][_0xd486('0x2f')]+'%'};return _0x329a29;})});}_0x45ca2c=_[_0xd486('0x47')]({},_0x45ca2c,_0x2bd391[_0xd486('0x4f')]);return db[_0xd486('0x61')][_0xd486('0x20')]({'where':_0x45ca2c['where']})[_0xd486('0x28')](function(_0x1f4c25){_0x4f6c05['count']=_0x1f4c25;if(_0x2bd391[_0xd486('0x3c')]['includeAll']){_0x45ca2c[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x61')][_0xd486('0x4a')](_0x45ca2c);})['then'](function(_0x581237){_0x4f6c05['rows']=_0x581237;return _0x4f6c05;});}})[_0xd486('0x28')](respondWithFilteredResult(_0x3ebdc9,_0x45ca2c))['catch'](handleError(_0x3ebdc9,null));};exports[_0xd486('0x64')]=function(_0x5abcf7,_0x10fa12,_0x2e97a2){var _0x12fc3d={'raw':!![],'where':{}};var _0x47fd23={};var _0x164ee9={'count':0x0,'rows':[]};return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x5abcf7['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x10fa12,null))['then'](function(_0x5a56f8){if(_0x5a56f8){_0x47fd23['model']=_[_0xd486('0x3d')](db[_0xd486('0x65')][_0xd486('0x3a')]);_0x47fd23[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x5abcf7['query']);_0x47fd23['filters']=_[_0xd486('0x3f')](_0x47fd23[_0xd486('0x3b')],_0x47fd23[_0xd486('0x3c')]);_0x12fc3d[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x47fd23[_0xd486('0x3b')],qs['fields'](_0x5abcf7['query']['fields']));_0x12fc3d[_0xd486('0x40')]=_0x12fc3d[_0xd486('0x40')][_0xd486('0x4e')]?_0x12fc3d[_0xd486('0x40')]:_0x47fd23[_0xd486('0x3b')];if(!_0x5abcf7[_0xd486('0x3c')]['hasOwnProperty']('nolimit')){_0x12fc3d[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x5abcf7[_0xd486('0x3c')][_0xd486('0x22')]);_0x12fc3d[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x5abcf7[_0xd486('0x3c')][_0xd486('0x21')]);}_0x12fc3d[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x5abcf7[_0xd486('0x3c')]['sort']);_0x12fc3d[_0xd486('0x45')]=qs['filters'](_[_0xd486('0x46')](_0x5abcf7[_0xd486('0x3c')],_0x47fd23[_0xd486('0x3e')]));_0x12fc3d[_0xd486('0x45')][_0xd486('0x63')]=_0x5a56f8['id'];if(_0x5abcf7['query'][_0xd486('0x2f')]){_0x12fc3d[_0xd486('0x45')]=_['merge'](_0x12fc3d[_0xd486('0x45')],{'$or':_['map'](_0x12fc3d[_0xd486('0x40')],function(_0x5f084c){var _0x35eb70={};_0x35eb70[_0x5f084c]={'$like':'%'+_0x5abcf7[_0xd486('0x3c')]['filter']+'%'};return _0x35eb70;})});}_0x12fc3d=_[_0xd486('0x47')]({},_0x12fc3d,_0x5abcf7[_0xd486('0x4f')]);return db[_0xd486('0x65')][_0xd486('0x20')]({'where':_0x12fc3d[_0xd486('0x45')]})['then'](function(_0x306e43){_0x164ee9[_0xd486('0x20')]=_0x306e43;if(_0x5abcf7[_0xd486('0x3c')][_0xd486('0x48')]){_0x12fc3d[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x65')][_0xd486('0x4a')](_0x12fc3d);})['then'](function(_0x238453){_0x164ee9[_0xd486('0x4b')]=_0x238453;return _0x164ee9;});}})[_0xd486('0x28')](respondWithFilteredResult(_0x10fa12,_0x12fc3d))[_0xd486('0x58')](handleError(_0x10fa12,null));};exports['getHopperFinals']=function(_0x4add22,_0x772832,_0x55df3f){var _0xdc3e88={'raw':!![],'where':{}};var _0xc23eb2={};var _0x50f64a={'count':0x0,'rows':[]};return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x4add22[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x772832,null))[_0xd486('0x28')](function(_0x3b026b){if(_0x3b026b){_0xc23eb2[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0x66')][_0xd486('0x3a')]);_0xc23eb2['query']=_[_0xd486('0x3d')](_0x4add22[_0xd486('0x3c')]);_0xc23eb2['filters']=_[_0xd486('0x3f')](_0xc23eb2[_0xd486('0x3b')],_0xc23eb2['query']);_0xdc3e88[_0xd486('0x40')]=_[_0xd486('0x3f')](_0xc23eb2[_0xd486('0x3b')],qs['fields'](_0x4add22[_0xd486('0x3c')]['fields']));_0xdc3e88[_0xd486('0x40')]=_0xdc3e88['attributes'][_0xd486('0x4e')]?_0xdc3e88['attributes']:_0xc23eb2[_0xd486('0x3b')];if(!_0x4add22[_0xd486('0x3c')][_0xd486('0x62')]('nolimit')){_0xdc3e88[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x4add22['query'][_0xd486('0x22')]);_0xdc3e88[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x4add22['query'][_0xd486('0x21')]);}_0xdc3e88[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x4add22[_0xd486('0x3c')][_0xd486('0x44')]);_0xdc3e88[_0xd486('0x45')]=qs[_0xd486('0x3e')](_['pick'](_0x4add22['query'],_0xc23eb2[_0xd486('0x3e')]));_0xdc3e88[_0xd486('0x45')]['VoiceQueueId']=_0x3b026b['id'];if(_0x4add22[_0xd486('0x3c')][_0xd486('0x2f')]){_0xdc3e88[_0xd486('0x45')]=_[_0xd486('0x47')](_0xdc3e88[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0xdc3e88[_0xd486('0x40')],function(_0x5e0730){var _0x50ee64={};_0x50ee64[_0x5e0730]={'$like':'%'+_0x4add22[_0xd486('0x3c')][_0xd486('0x2f')]+'%'};return _0x50ee64;})});}_0xdc3e88=_[_0xd486('0x47')]({},_0xdc3e88,_0x4add22[_0xd486('0x4f')]);return db['CmHopperFinal'][_0xd486('0x20')]({'where':_0xdc3e88[_0xd486('0x45')]})[_0xd486('0x28')](function(_0x1b849b){_0x50f64a[_0xd486('0x20')]=_0x1b849b;if(_0x4add22[_0xd486('0x3c')][_0xd486('0x48')]){_0xdc3e88[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x66')][_0xd486('0x4a')](_0xdc3e88);})['then'](function(_0x5388b2){_0x50f64a[_0xd486('0x4b')]=_0x5388b2;return _0x50f64a;});}})[_0xd486('0x28')](respondWithFilteredResult(_0x772832,_0xdc3e88))['catch'](handleError(_0x772832,null));};exports[_0xd486('0x67')]=function(_0x5e9b2b,_0x3caeae,_0x1dfbde){var _0x2b8c96={'raw':!![],'where':{}};var _0x5062d9={};var _0x2598a0={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xd486('0x60')]({'where':{'id':_0x5e9b2b[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x3caeae,null))[_0xd486('0x28')](function(_0x318332){if(_0x318332){_0x5062d9[_0xd486('0x3b')]=_[_0xd486('0x3d')](db['CmHopperBlack'][_0xd486('0x3a')]);_0x5062d9[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x5e9b2b[_0xd486('0x3c')]);_0x5062d9[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x5062d9['model'],_0x5062d9[_0xd486('0x3c')]);_0x2b8c96[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x5062d9[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x41')]));_0x2b8c96[_0xd486('0x40')]=_0x2b8c96['attributes'][_0xd486('0x4e')]?_0x2b8c96[_0xd486('0x40')]:_0x5062d9[_0xd486('0x3b')];if(!_0x5e9b2b['query'][_0xd486('0x62')](_0xd486('0x42'))){_0x2b8c96[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x22')]);_0x2b8c96[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x5e9b2b['query'][_0xd486('0x21')]);}_0x2b8c96[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x44')]);_0x2b8c96['where']=qs[_0xd486('0x3e')](_['pick'](_0x5e9b2b[_0xd486('0x3c')],_0x5062d9['filters']));_0x2b8c96[_0xd486('0x45')][_0xd486('0x63')]=_0x318332['id'];if(_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x2f')]){_0x2b8c96[_0xd486('0x45')]=_['merge'](_0x2b8c96[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0x2b8c96['attributes'],function(_0x23ada8){var _0x24a90b={};_0x24a90b[_0x23ada8]={'$like':'%'+_0x5e9b2b['query'][_0xd486('0x2f')]+'%'};return _0x24a90b;})});}_0x2b8c96=_[_0xd486('0x47')]({},_0x2b8c96,_0x5e9b2b[_0xd486('0x4f')]);return db[_0xd486('0x68')][_0xd486('0x20')]({'where':_0x2b8c96[_0xd486('0x45')]})['then'](function(_0x33ce32){_0x2598a0[_0xd486('0x20')]=_0x33ce32;if(_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x48')]){_0x2b8c96[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x68')]['findAll'](_0x2b8c96);})['then'](function(_0x44b875){_0x2598a0['rows']=_0x44b875;return _0x2598a0;});}})[_0xd486('0x28')](respondWithFilteredResult(_0x3caeae,_0x2b8c96))[_0xd486('0x58')](handleError(_0x3caeae,null));};exports['getTeams']=function(_0x1cf8b6,_0x66e5e9,_0x140dcd){var _0x42f94c={};var _0x1fe9fd={};var _0x8fbc32;var _0x390d40;return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x1cf8b6['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x66e5e9,null))[_0xd486('0x28')](function(_0xf1786c){if(_0xf1786c){_0x8fbc32=_0xf1786c;_0x1fe9fd[_0xd486('0x3b')]=_['keys'](db[_0xd486('0x69')][_0xd486('0x3a')]);_0x1fe9fd['query']=_[_0xd486('0x3d')](_0x1cf8b6[_0xd486('0x3c')]);_0x1fe9fd[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x1fe9fd[_0xd486('0x3b')],_0x1fe9fd['query']);_0x42f94c[_0xd486('0x40')]=_['intersection'](_0x1fe9fd[_0xd486('0x3b')],qs['fields'](_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x41')]));_0x42f94c[_0xd486('0x40')]=_0x42f94c['attributes'][_0xd486('0x4e')]?_0x42f94c[_0xd486('0x40')]:_0x1fe9fd[_0xd486('0x3b')];_0x42f94c[_0xd486('0x43')]=qs['sort'](_0x1cf8b6['query'][_0xd486('0x44')]);_0x42f94c[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x1cf8b6[_0xd486('0x3c')],_0x1fe9fd[_0xd486('0x3e')]));if(_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x2f')]){_0x42f94c[_0xd486('0x45')]=_[_0xd486('0x47')](_0x42f94c[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0x42f94c['attributes'],function(_0x2d342a){var _0x546455={};_0x546455[_0x2d342a]={'$like':'%'+_0x1cf8b6[_0xd486('0x3c')]['filter']+'%'};return _0x546455;})});}_0x42f94c=_[_0xd486('0x47')]({},_0x42f94c,_0x1cf8b6[_0xd486('0x4f')]);return _0x8fbc32[_0xd486('0x6a')](_0x42f94c);}})[_0xd486('0x28')](function(_0x425f16){if(_0x425f16){_0x390d40=_0x425f16[_0xd486('0x4e')];if(!_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x42f94c['limit']=qs[_0xd486('0x22')](_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x22')]);_0x42f94c[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x21')]);}return _0x8fbc32[_0xd486('0x6a')](_0x42f94c);}})[_0xd486('0x28')](function(_0x1ed9c1){if(_0x1ed9c1){return _0x1ed9c1?{'count':_0x390d40,'rows':_0x1ed9c1}:null;}})[_0xd486('0x28')](respondWithResult(_0x66e5e9,null))[_0xd486('0x58')](handleError(_0x66e5e9,null));};exports[_0xd486('0x6b')]=function(_0xb9089f,_0x3e8a10,_0x1b4273){var _0x275a8d=_0xb9089f['body'][_0xd486('0x6c')];var _0xadbe10=_[_0xd486('0x38')](_0x275a8d,'id');return db[_0xd486('0x69')][_0xd486('0x4a')]({'where':{'id':_0xadbe10},'attributes':['id'],'include':[{'model':db[_0xd486('0x6d')],'as':_0xd486('0x6e'),'attributes':['id',_0xd486('0x34'),_0xd486('0x6f'),'voicePause','interface'],'raw':!![]}]})[_0xd486('0x28')](function(_0x35a1b){if(_0x35a1b){var _0x385063=_[_0xd486('0x70')](_0x35a1b,function(_0x5a9532){var _0x4a614e=_0x5a9532[_0xd486('0x2a')]({'plain':!![]});_0x4a614e[_0xd486('0x6e')][_0xd486('0x71')](function(_0x37e5f6){_0x37e5f6[_0xd486('0x72')]=_['find'](_0x275a8d,{'id':_0x4a614e['id']})[_0xd486('0x72')];});return _0x4a614e[_0xd486('0x6e')];});return db['VoiceQueue'][_0xd486('0x33')]({'where':{'id':_0xb9089f[_0xd486('0x4d')]['id']}})['then'](function(_0xeed84f){return db[_0xd486('0x73')][_0xd486('0x74')](function(_0x50b270){return _0xeed84f[_0xd486('0x6b')](_0xadbe10,{'transaction':_0x50b270})[_0xd486('0x28')](function(){return BPromise[_0xd486('0x75')](_0x385063,function(_0x19a43f){return db[_0xd486('0x76')][_0xd486('0x77')]({'where':{'UserId':_0x19a43f['id'],'VoiceQueueId':_0xb9089f[_0xd486('0x4d')]['id']},'defaults':{'penalty':_0x19a43f[_0xd486('0x72')]},'transaction':_0x50b270});});})[_0xd486('0x28')](function(){return BPromise[_0xd486('0x75')](_[_0xd486('0x2f')](_0x385063,{'online':!![]}),function(_0x47fe7b){return db[_0xd486('0x78')][_0xd486('0x79')]({'membername':_0x47fe7b[_0xd486('0x34')],'UserId':_0x47fe7b['id'],'queue_name':_0xeed84f[_0xd486('0x34')],'VoiceQueueId':_0xeed84f['id'],'interface':_[_0xd486('0x7a')](_0x47fe7b['interface'])?util[_0xd486('0x7b')]('SIP/%s',_0x47fe7b[_0xd486('0x34')]):_0x47fe7b[_0xd486('0x7c')],'paused':_0x47fe7b[_0xd486('0x7d')]||![],'penalty':_0x47fe7b['penalty']},{'transaction':_0x50b270});});})[_0xd486('0x28')](function(){_0x385063[_0xd486('0x71')](function(_0x35a64d){socket[_0xd486('0x7e')](_0xd486('0x7f'),{'UserId':_0x35a64d['id'],'VoiceQueueId':_0xeed84f['id']});});});});});}})[_0xd486('0x28')](respondWithStatusCode(_0x3e8a10,null))[_0xd486('0x58')](handleError(_0x3e8a10,null));};exports[_0xd486('0x80')]=function(_0x232732,_0x3b1178,_0x21d44){return db[_0xd486('0x69')]['findAll']({'where':{'id':_0x232732['query'][_0xd486('0x81')]},'attributes':['id'],'include':[{'model':db[_0xd486('0x6d')],'as':_0xd486('0x6e'),'attributes':['id'],'raw':!![]}]})[_0xd486('0x28')](handleEntityNotFound(_0x3b1178,null))[_0xd486('0x28')](function(_0x948c0c){var _0x184a94=_[_0xd486('0x38')](_0x948c0c,'id');var _0x76320=[];var _0x3a0443=[];var _0x7566f8=squel[_0xd486('0x82')]();_0x7566f8['field'](_0xd486('0x83'))[_0xd486('0x84')](_0xd486('0x85'),'tq')[_0xd486('0x86')](_0xd486('0x87'),'ut','ut.TeamId\x20=\x20tq.TeamId')['where'](_0xd486('0x88'),_0x232732['params']['id']);for(var _0x271f6a=0x0;_0x271f6a<_0x948c0c[_0xd486('0x4e')];_0x271f6a+=0x1){let _0x27007e=_0x948c0c[_0x271f6a];for(var _0xa0e94b=0x0;_0xa0e94b<_0x27007e[_0xd486('0x6e')][_0xd486('0x4e')];_0xa0e94b+=0x1){let _0x48bad4=_0x27007e['Agents'][_0xa0e94b];var _0x49ec74=_0x7566f8[_0xd486('0x89')]();_0x49ec74['where'](_0xd486('0x8a'),_0x48bad4['id']);_0x3a0443[_0xd486('0x8b')](db[_0xd486('0x73')][_0xd486('0x3c')](_0x49ec74[_0xd486('0x8c')](),{'type':db[_0xd486('0x73')][_0xd486('0x8d')]['SELECT']})['then'](function(_0x1712e1){if(_0x1712e1['length']===0x1){return _0x48bad4['id'];}else{var _0x1fd9ae=_[_0xd486('0x8e')](_[_0xd486('0x38')](_0x1712e1,'TeamId'),function(_0x3b9aea){return _['includes'](_0x184a94,_0x3b9aea);});if(_0x1fd9ae){return _0x48bad4['id'];}}}));}}return BPromise[_0xd486('0x8f')](_0x3a0443)[_0xd486('0x28')](function(_0x5a3c66){_0x76320=_(_0x76320)[_0xd486('0x90')](_0x5a3c66)['compact']()[_0xd486('0x31')]();return db[_0xd486('0x39')][_0xd486('0x33')]({'where':{'id':_0x232732[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](function(_0x5f20a8){return db['sequelize']['transaction'](function(_0x10c677){return _0x5f20a8[_0xd486('0x80')](_0x232732['query'][_0xd486('0x81')],{'transaction':_0x10c677})[_0xd486('0x28')](function(){if(!_[_0xd486('0x91')](_0x76320)){return _0x5f20a8[_0xd486('0x92')](_0x76320,{'transaction':_0x10c677})[_0xd486('0x28')](function(){return db[_0xd486('0x78')][_0xd486('0x29')]({'where':{'VoiceQueueId':_0x232732[_0xd486('0x4d')]['id'],'UserId':_0x76320},'transaction':_0x10c677});});}})[_0xd486('0x28')](function(){_0x76320[_0xd486('0x71')](function(_0x2e7e2c){socket[_0xd486('0x7e')](_0xd486('0x93'),{'UserId':_0x2e7e2c,'VoiceQueueId':_0x5f20a8['id']});});});});});});})[_0xd486('0x28')](respondWithStatusCode(_0x3b1178,null))['catch'](handleError(_0x3b1178,null));};exports[_0xd486('0x94')]=function(_0x33abe6,_0x251c9b,_0x4eaf1b){var _0x19f9b1,_0x4fe8bc;return db['VoiceQueue'][_0xd486('0x33')]({'where':{'id':_0x33abe6[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x251c9b,null))[_0xd486('0x28')](function(_0x267dc8){if(_0x267dc8){_0x4fe8bc=_0x267dc8;return _0x267dc8['addAgents'](_0x33abe6[_0xd486('0x51')][_0xd486('0x81')],_[_0xd486('0x5b')](_0x33abe6[_0xd486('0x51')],[_0xd486('0x81'),'id'])||{})['spread'](function(_0x160dc6){for(var _0x3d495a=0x0;_0x3d495a<_0x33abe6[_0xd486('0x51')][_0xd486('0x81')][_0xd486('0x4e')];_0x3d495a+=0x1){socket[_0xd486('0x7e')](_0xd486('0x7f'),{'UserId':_0x33abe6['body'][_0xd486('0x81')][_0x3d495a],'VoiceQueueId':_0x33abe6[_0xd486('0x4d')]['id']});}return _0x160dc6;});}})['then'](function(_0x5e1aa5){_0x19f9b1=_0x5e1aa5||[];if(_0x4fe8bc){return db[_0xd486('0x6d')][_0xd486('0x4a')]({'where':{'id':_0x33abe6[_0xd486('0x51')]['ids']},'attributes':['id','name',_0xd486('0x6f'),_0xd486('0x7d'),_0xd486('0x7c')],'raw':!![]});}})[_0xd486('0x28')](function(_0x50ee49){if(!_[_0xd486('0x91')](_0x50ee49)){var _0x2ce3e2=[];for(var _0x3e51d6=0x0;_0x3e51d6<_0x50ee49[_0xd486('0x4e')];_0x3e51d6++){if(_0x50ee49[_0x3e51d6][_0xd486('0x6f')]){_0x2ce3e2['push'](db['UserVoiceQueueRt'][_0xd486('0x79')]({'membername':_0x50ee49[_0x3e51d6][_0xd486('0x34')],'UserId':_0x50ee49[_0x3e51d6]['id'],'queue_name':_0x4fe8bc[_0xd486('0x34')],'VoiceQueueId':_0x4fe8bc['id'],'interface':_[_0xd486('0x7a')](_0x50ee49[_0x3e51d6][_0xd486('0x7c')])?util[_0xd486('0x7b')](_0xd486('0x95'),_0x50ee49[_0x3e51d6][_0xd486('0x34')]):_0x50ee49[_0x3e51d6][_0xd486('0x7c')],'paused':_0x50ee49[_0x3e51d6][_0xd486('0x7d')]||![],'penalty':_0x33abe6[_0xd486('0x51')][_0xd486('0x72')]||0x0}));}}return BPromise[_0xd486('0x8f')](_0x2ce3e2);}})[_0xd486('0x28')](function(){return _0x19f9b1;})[_0xd486('0x28')](respondWithResult(_0x251c9b,null))[_0xd486('0x58')](handleError(_0x251c9b,null));};exports[_0xd486('0x92')]=function(_0x52fb58,_0x4a1f6a,_0x314475){return db[_0xd486('0x39')][_0xd486('0x33')]({'where':{'id':_0x52fb58['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x4a1f6a,null))[_0xd486('0x28')](function(_0x215155){if(_0x215155){return _0x215155[_0xd486('0x92')](_0x52fb58[_0xd486('0x3c')][_0xd486('0x81')])[_0xd486('0x28')](function(){if(_[_0xd486('0x96')](_0x52fb58[_0xd486('0x3c')][_0xd486('0x81')])){for(var _0xe803c0=0x0;_0xe803c0<_0x52fb58[_0xd486('0x3c')]['ids'][_0xd486('0x4e')];_0xe803c0+=0x1){socket[_0xd486('0x7e')](_0xd486('0x93'),{'UserId':Number(_0x52fb58[_0xd486('0x3c')][_0xd486('0x81')][_0xe803c0]),'VoiceQueueId':Number(_0x52fb58[_0xd486('0x4d')]['id'])});}}else{socket['emit'](_0xd486('0x93'),{'UserId':Number(_0x52fb58['query'][_0xd486('0x81')]),'VoiceQueueId':Number(_0x52fb58[_0xd486('0x4d')]['id'])});}});}})[_0xd486('0x28')](function(_0x15f38b){return db['UserVoiceQueueRt'][_0xd486('0x29')]({'where':{'VoiceQueueId':_0x52fb58[_0xd486('0x4d')]['id'],'UserId':_0x52fb58[_0xd486('0x3c')]['ids']}})['then'](function(){return _0x15f38b;});})[_0xd486('0x28')](respondWithStatusCode(_0x4a1f6a,null))[_0xd486('0x58')](handleError(_0x4a1f6a,null));};exports[_0xd486('0x97')]=function(_0x5a9bc5,_0xf02844,_0xc843a3){var _0x5c3b74={};var _0x14efaf={};var _0x101cd2;var _0x1dc9e6;return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x5a9bc5[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0xf02844,null))[_0xd486('0x28')](function(_0x4df273){if(_0x4df273){_0x101cd2=_0x4df273;_0x14efaf[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0x6d')][_0xd486('0x3a')]);_0x14efaf[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x5a9bc5[_0xd486('0x3c')]);_0x14efaf[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x14efaf[_0xd486('0x3b')],_0x14efaf[_0xd486('0x3c')]);_0x5c3b74[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x14efaf['model'],qs[_0xd486('0x41')](_0x5a9bc5[_0xd486('0x3c')][_0xd486('0x41')]));_0x5c3b74[_0xd486('0x40')]=_0x5c3b74[_0xd486('0x40')][_0xd486('0x4e')]?_0x5c3b74[_0xd486('0x40')]:_0x14efaf[_0xd486('0x3b')];_0x5c3b74[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x5a9bc5[_0xd486('0x3c')]['sort']);_0x5c3b74[_0xd486('0x45')]=qs[_0xd486('0x3e')](_['pick'](_0x5a9bc5[_0xd486('0x3c')],_0x14efaf['filters']));if(_0x5a9bc5[_0xd486('0x3c')][_0xd486('0x2f')]){_0x5c3b74[_0xd486('0x45')]=_[_0xd486('0x47')](_0x5c3b74['where'],{'$or':_['map'](_0x5c3b74[_0xd486('0x40')],function(_0x379120){var _0x2e8f1e={};_0x2e8f1e[_0x379120]={'$like':'%'+_0x5a9bc5[_0xd486('0x3c')]['filter']+'%'};return _0x2e8f1e;})});}_0x5c3b74=_['merge']({},_0x5c3b74,_0x5a9bc5[_0xd486('0x4f')]);return _0x101cd2[_0xd486('0x97')](_0x5c3b74);}})[_0xd486('0x28')](function(_0x562568){if(_0x562568){_0x1dc9e6=_0x562568['length'];if(!_0x5a9bc5[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x5c3b74[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x5a9bc5[_0xd486('0x3c')]['limit']);_0x5c3b74[_0xd486('0x21')]=qs['offset'](_0x5a9bc5[_0xd486('0x3c')]['offset']);}return _0x101cd2[_0xd486('0x97')](_0x5c3b74);}})[_0xd486('0x28')](function(_0x5dde84){if(_0x5dde84){return _0x5dde84?{'count':_0x1dc9e6,'rows':_0x5dde84}:null;}})[_0xd486('0x28')](respondWithResult(_0xf02844,null))[_0xd486('0x58')](handleError(_0xf02844,null));};exports['getMembers']=function(_0x2e9174,_0x1ad035,_0x1d5025){var _0x1cdb65={};var _0x383df4={};var _0x3e95e4;var _0x45bf23;return db['VoiceQueue'][_0xd486('0x60')]({'where':{'id':_0x2e9174[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x1ad035,null))[_0xd486('0x28')](function(_0x54a806){if(_0x54a806){_0x3e95e4=_0x54a806;_0x383df4['model']=_[_0xd486('0x3d')](db['UserVoiceQueueRt']['rawAttributes']);_0x383df4[_0xd486('0x3c')]=_['keys'](_0x2e9174[_0xd486('0x3c')]);_0x383df4['filters']=_[_0xd486('0x3f')](_0x383df4[_0xd486('0x3b')],_0x383df4[_0xd486('0x3c')]);_0x1cdb65['attributes']=_[_0xd486('0x3f')](_0x383df4[_0xd486('0x3b')],qs['fields'](_0x2e9174[_0xd486('0x3c')][_0xd486('0x41')]));_0x1cdb65[_0xd486('0x40')]=_0x1cdb65[_0xd486('0x40')]['length']?_0x1cdb65['attributes']:_0x383df4['model'];_0x1cdb65['order']=qs['sort'](_0x2e9174[_0xd486('0x3c')]['sort']);_0x1cdb65[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x2e9174['query'],_0x383df4['filters']));if(_0x2e9174[_0xd486('0x3c')]['filter']){_0x1cdb65['where']=_[_0xd486('0x47')](_0x1cdb65['where'],{'$or':_[_0xd486('0x38')](_0x1cdb65[_0xd486('0x40')],function(_0x4375bc){var _0x4b420f={};_0x4b420f[_0x4375bc]={'$like':'%'+_0x2e9174[_0xd486('0x3c')][_0xd486('0x2f')]+'%'};return _0x4b420f;})});}_0x1cdb65=_[_0xd486('0x47')]({},_0x1cdb65,_0x2e9174['options']);return _0x3e95e4['getMembers'](_0x1cdb65);}})[_0xd486('0x28')](function(_0x9ed562){if(_0x9ed562){_0x45bf23=_0x9ed562[_0xd486('0x4e')];if(!_0x2e9174[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x1cdb65[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x2e9174['query']['limit']);_0x1cdb65['offset']=qs[_0xd486('0x21')](_0x2e9174[_0xd486('0x3c')][_0xd486('0x21')]);}return _0x3e95e4['getMembers'](_0x1cdb65);}})[_0xd486('0x28')](function(_0x361b29){return _0x361b29?{'count':_0x45bf23,'rows':_0x361b29}:null;})['then'](respondWithResult(_0x1ad035,null))[_0xd486('0x58')](handleError(_0x1ad035,null));};exports['getLists']=function(_0x28c226,_0x3deb92,_0x50616d){var _0x236798={};var _0x5140b3={};var _0x21a49d;var _0x5bb207;return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x28c226[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x3deb92,null))[_0xd486('0x28')](function(_0x2e7163){if(_0x2e7163){_0x21a49d=_0x2e7163;_0x5140b3[_0xd486('0x3b')]=_[_0xd486('0x3d')](db['CmList'][_0xd486('0x3a')]);_0x5140b3[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x28c226[_0xd486('0x3c')]);_0x5140b3[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x5140b3['model'],_0x5140b3['query']);_0x236798[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x5140b3[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x28c226['query'][_0xd486('0x41')]));_0x236798['attributes']=_0x236798[_0xd486('0x40')][_0xd486('0x4e')]?_0x236798[_0xd486('0x40')]:_0x5140b3['model'];_0x236798[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x28c226[_0xd486('0x3c')][_0xd486('0x44')]);_0x236798[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x28c226['query'],_0x5140b3[_0xd486('0x3e')]));if(_0x28c226['query'][_0xd486('0x2f')]){_0x236798[_0xd486('0x45')]=_[_0xd486('0x47')](_0x236798[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0x236798[_0xd486('0x40')],function(_0x484279){var _0x70c740={};_0x70c740[_0x484279]={'$like':'%'+_0x28c226[_0xd486('0x3c')]['filter']+'%'};return _0x70c740;})});}_0x236798=_[_0xd486('0x47')]({},_0x236798,_0x28c226[_0xd486('0x4f')]);return _0x21a49d[_0xd486('0x98')](_0x236798);}})['then'](function(_0x5e024f){if(_0x5e024f){_0x5bb207=_0x5e024f[_0xd486('0x4e')];if(!_0x28c226[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x236798[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x28c226[_0xd486('0x3c')][_0xd486('0x22')]);_0x236798[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x28c226['query'][_0xd486('0x21')]);}return _0x21a49d[_0xd486('0x98')](_0x236798);}})[_0xd486('0x28')](function(_0x2b2be3){if(_0x2b2be3){return _0x2b2be3?{'count':_0x5bb207,'rows':_0x2b2be3}:null;}})[_0xd486('0x28')](respondWithResult(_0x3deb92,null))[_0xd486('0x58')](handleError(_0x3deb92,null));};exports[_0xd486('0x99')]=function(_0x22be90,_0x3b507c,_0x143d28){var _0x3df219,_0x1cfcc8;return db[_0xd486('0x39')][_0xd486('0x33')]({'where':{'id':_0x22be90['params']['id']}})['then'](handleEntityNotFound(_0x3b507c,null))[_0xd486('0x28')](function(_0x1c0d41){if(_0x1c0d41){_0x1cfcc8=_0x1c0d41;return _0x1c0d41[_0xd486('0x99')](_0x22be90[_0xd486('0x51')][_0xd486('0x81')],_[_0xd486('0x5b')](_0x22be90[_0xd486('0x51')],['ids','id'])||{});}return null;})[_0xd486('0x9a')](function(_0x318eaa){var _0x3dcc87;_0x3df219=_0x318eaa||[];var _0x1edb19=[];if(_0x318eaa){for(var _0x5f16a6=0x0;_0x5f16a6<_0x318eaa['length'];_0x5f16a6+=0x1){var _0xd9847=_0x318eaa[_0x5f16a6][_0xd486('0x2a')]({'plain':!![]});_0x1cfcc8[_0xd486('0x9b')]=_0x22be90[_0xd486('0x51')]['dialCheckDuplicateType']?_0x22be90[_0xd486('0x51')][_0xd486('0x9b')]:_0x1cfcc8[_0xd486('0x9b')];switch(_0x1cfcc8[_0xd486('0x9b')]){case _0xd486('0x9c'):_0x3dcc87=squel[_0xd486('0x9d')]()[_0xd486('0x9e')](_0xd486('0x9f'))[_0xd486('0xa0')](['phone',_0xd486('0xa1'),_0xd486('0xa2'),_0xd486('0xa3'),_0xd486('0x63'),_0xd486('0x5c'),_0xd486('0x5d')],squel[_0xd486('0x82')]()[_0xd486('0xa4')]('phone','phone')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0xa1'))[_0xd486('0xa4')]('id',_0xd486('0xa2'))['field'](_0xd9847['CmListId'][_0xd486('0x8c')](),'ListId')['field'](_0x22be90[_0xd486('0x4d')]['id'][_0xd486('0x8c')](),'VoiceQueueId')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0x5c'))[_0xd486('0xa4')]('NOW()',_0xd486('0x5d'))['from']('cm_contacts')[_0xd486('0x45')](_0xd486('0xa6'))[_0xd486('0x45')](_0xd486('0xa7'),_0xd9847[_0xd486('0xa8')][_0xd486('0x8c')]())[_0xd486('0x45')](_0xd486('0xa9'))['where']('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0xd486('0xa4')]('COALESCE(calleridnum,\x27\x27)')[_0xd486('0x84')]('cm_hopper_final')[_0xd486('0x45')](_0xd486('0x88'),_0x22be90[_0xd486('0x4d')]['id'][_0xd486('0x8c')]()))[_0xd486('0x45')]('phone\x20NOT\x20IN\x20(?)',squel[_0xd486('0x82')]()['field'](_0xd486('0xaa'))[_0xd486('0x84')](_0xd486('0x9f'))['where'](_0xd486('0x88'),_0x22be90[_0xd486('0x4d')]['id'][_0xd486('0x8c')]())))[_0xd486('0x8c')]();break;case _0xd486('0xab'):_0x3dcc87=squel['insert']()[_0xd486('0x9e')](_0xd486('0x9f'))[_0xd486('0xa0')]([_0xd486('0xac'),_0xd486('0xa1'),'ContactId',_0xd486('0xa3'),'VoiceQueueId',_0xd486('0x5c'),_0xd486('0x5d')],squel[_0xd486('0x82')]()[_0xd486('0xa4')](_0xd486('0xac'),'phone')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0xa1'))['field']('id',_0xd486('0xa2'))[_0xd486('0xa4')](_0xd9847['CmListId'][_0xd486('0x8c')](),'ListId')[_0xd486('0xa4')](_0x22be90['params']['id'][_0xd486('0x8c')](),'VoiceQueueId')[_0xd486('0xa4')]('NOW()','createdAt')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0x5d'))[_0xd486('0x84')](_0xd486('0xad'))[_0xd486('0x45')]('deletedAt\x20IS\x20NULL')[_0xd486('0x45')](_0xd486('0xa7'),_0xd9847[_0xd486('0xa8')][_0xd486('0x8c')]())[_0xd486('0x45')](_0xd486('0xa9'))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0xd486('0x82')]()[_0xd486('0xa4')](_0xd486('0xaa'))['from'](_0xd486('0x9f'))['where']('VoiceQueueId\x20=\x20?',_0x22be90[_0xd486('0x4d')]['id'][_0xd486('0x8c')]())))['toString']();break;default:_0x3dcc87=squel['insert']()['into']('cm_hopper')[_0xd486('0xa0')](['phone',_0xd486('0xa1'),_0xd486('0xa2'),'ListId',_0xd486('0x63'),_0xd486('0x5c'),_0xd486('0x5d')],squel[_0xd486('0x82')]()[_0xd486('0xa4')]('phone',_0xd486('0xac'))['field']('NOW()',_0xd486('0xa1'))[_0xd486('0xa4')]('id','ContactId')[_0xd486('0xa4')](_0xd9847[_0xd486('0xa8')][_0xd486('0x8c')](),'ListId')[_0xd486('0xa4')](_0x22be90[_0xd486('0x4d')]['id']['toString'](),_0xd486('0x63'))['field'](_0xd486('0xa5'),_0xd486('0x5c'))['field'](_0xd486('0xa5'),_0xd486('0x5d'))[_0xd486('0x84')](_0xd486('0xad'))[_0xd486('0x45')]('deletedAt\x20IS\x20NULL')[_0xd486('0x45')](_0xd486('0xa7'),_0xd9847[_0xd486('0xa8')][_0xd486('0x8c')]())['where'](_0xd486('0xa9')))[_0xd486('0x8c')]();}_0x1edb19[_0xd486('0x8b')](db['sequelize'][_0xd486('0x3c')](_0x3dcc87));}return BPromise['all'](_0x1edb19);}})[_0xd486('0x28')](function(){return _0x3df219;})[_0xd486('0x28')](respondWithResult(_0x3b507c,null))['catch'](handleError(_0x3b507c,null));};exports[_0xd486('0xae')]=function(_0x3dc6ed,_0x23a20e,_0x26f36d){return db['VoiceQueue'][_0xd486('0x33')]({'where':{'id':_0x3dc6ed[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x23a20e,null))[_0xd486('0x28')](function(_0x558e92){if(_0x558e92){return _0x558e92[_0xd486('0xae')](_0x3dc6ed[_0xd486('0x3c')][_0xd486('0x81')]);}})[_0xd486('0x28')](function(_0x52b90f){if(_0x52b90f){return db['CmHopper'][_0xd486('0x29')]({'where':{'ListId':_0x3dc6ed[_0xd486('0x3c')][_0xd486('0x81')],'VoiceQueueId':_0x3dc6ed[_0xd486('0x4d')]['id']}})['then'](function(){return _0x52b90f;});}})['then'](respondWithStatusCode(_0x23a20e,null))[_0xd486('0x58')](handleError(_0x23a20e,null));};exports[_0xd486('0xaf')]=function(_0x4d4a26,_0x4a1ca3,_0x1a03fc){var _0xccc3d2={};var _0x3a8351={};var _0x2bf5bd;var _0x22daa5;return db[_0xd486('0x39')]['findOne']({'where':{'id':_0x4d4a26[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x4a1ca3,null))[_0xd486('0x28')](function(_0x35c2f6){if(_0x35c2f6){_0x2bf5bd=_0x35c2f6;_0x3a8351[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0xb0')][_0xd486('0x3a')]);_0x3a8351[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x4d4a26[_0xd486('0x3c')]);_0x3a8351[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x3a8351['model'],_0x3a8351['query']);_0xccc3d2['attributes']=_['intersection'](_0x3a8351[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x4d4a26[_0xd486('0x3c')]['fields']));_0xccc3d2[_0xd486('0x40')]=_0xccc3d2[_0xd486('0x40')][_0xd486('0x4e')]?_0xccc3d2[_0xd486('0x40')]:_0x3a8351['model'];_0xccc3d2[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x4d4a26[_0xd486('0x3c')][_0xd486('0x44')]);_0xccc3d2['where']=qs[_0xd486('0x3e')](_['pick'](_0x4d4a26[_0xd486('0x3c')],_0x3a8351['filters']));if(_0x4d4a26[_0xd486('0x3c')]['filter']){_0xccc3d2[_0xd486('0x45')]=_[_0xd486('0x47')](_0xccc3d2[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0xccc3d2['attributes'],function(_0x43d523){var _0x157b22={};_0x157b22[_0x43d523]={'$like':'%'+_0x4d4a26[_0xd486('0x3c')][_0xd486('0x2f')]+'%'};return _0x157b22;})});}_0xccc3d2=_[_0xd486('0x47')]({},_0xccc3d2,_0x4d4a26[_0xd486('0x4f')]);return _0x2bf5bd[_0xd486('0xaf')](_0xccc3d2);}})['then'](function(_0x2a3bc6){if(_0x2a3bc6){_0x22daa5=_0x2a3bc6['length'];if(!_0x4d4a26[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0xccc3d2[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x4d4a26[_0xd486('0x3c')][_0xd486('0x22')]);_0xccc3d2[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x4d4a26[_0xd486('0x3c')][_0xd486('0x21')]);}return _0x2bf5bd[_0xd486('0xaf')](_0xccc3d2);}})[_0xd486('0x28')](function(_0x13a5ed){if(_0x13a5ed){return _0x13a5ed?{'count':_0x22daa5,'rows':_0x13a5ed}:null;}})[_0xd486('0x28')](respondWithResult(_0x4a1ca3,null))[_0xd486('0x58')](handleError(_0x4a1ca3,null));};exports['addBlackLists']=function(_0xa0e3e9,_0x4c046c,_0x33983f){var _0x10333f,_0x201b39;return db[_0xd486('0x39')]['find']({'where':{'id':_0xa0e3e9[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x4c046c,null))[_0xd486('0x28')](function(_0x5698ce){if(_0x5698ce){_0x201b39=_0x5698ce;return _0x5698ce[_0xd486('0xb1')](_0xa0e3e9[_0xd486('0x51')][_0xd486('0x81')],_[_0xd486('0x5b')](_0xa0e3e9['body'],[_0xd486('0x81'),'id'])||{});}return null;})[_0xd486('0x9a')](function(_0x497b01){var _0x2217f0;_0x10333f=_0x497b01||[];var _0x48b1ef=[];if(_0x497b01){for(var _0x444ce7=0x0;_0x444ce7<_0x497b01[_0xd486('0x4e')];_0x444ce7+=0x1){var _0x5518d8=_0x497b01[_0x444ce7][_0xd486('0x2a')]({'plain':!![]});_0x2217f0=squel[_0xd486('0x9d')]()['into']('cm_hopper_black')[_0xd486('0xa0')]([_0xd486('0xac'),_0xd486('0xa2'),'ListId',_0xd486('0x63'),_0xd486('0x5c'),'updatedAt'],squel[_0xd486('0x82')]()[_0xd486('0xa4')](_0xd486('0xac'),'phone')[_0xd486('0xa4')]('id',_0xd486('0xa2'))[_0xd486('0xa4')](_0x5518d8[_0xd486('0xa8')][_0xd486('0x8c')](),_0xd486('0xa3'))['field'](_0xa0e3e9[_0xd486('0x4d')]['id'][_0xd486('0x8c')](),'VoiceQueueId')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0x5c'))[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0x5d'))[_0xd486('0x84')](_0xd486('0xad'))[_0xd486('0x45')]('deletedAt\x20IS\x20NULL')[_0xd486('0x45')]('ListId\x20=\x20?',_0x5518d8[_0xd486('0xa8')][_0xd486('0x8c')]())[_0xd486('0x45')](_0xd486('0xa9')))['toString']();_0x48b1ef[_0xd486('0x8b')](db[_0xd486('0x73')][_0xd486('0x3c')](_0x2217f0));}return BPromise[_0xd486('0x8f')](_0x48b1ef);}})[_0xd486('0x28')](function(){return _0x10333f;})['then'](respondWithResult(_0x4c046c,null))[_0xd486('0x58')](handleError(_0x4c046c,null));};exports[_0xd486('0xb2')]=function(_0x33e6ef,_0x451a48,_0x42f9d2){return db[_0xd486('0x39')][_0xd486('0x33')]({'where':{'id':_0x33e6ef['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x451a48,null))[_0xd486('0x28')](function(_0x3cbcc5){if(_0x3cbcc5){return _0x3cbcc5[_0xd486('0xb2')](_0x33e6ef[_0xd486('0x3c')][_0xd486('0x81')]);}})['then'](function(_0x1a4f0f){if(_0x1a4f0f){return db[_0xd486('0x68')][_0xd486('0x29')]({'where':{'ListId':_0x33e6ef[_0xd486('0x3c')]['ids'],'VoiceQueueId':_0x33e6ef[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](function(){return _0x1a4f0f;});}})[_0xd486('0x28')](respondWithStatusCode(_0x451a48,null))['catch'](handleError(_0x451a48,null));};
\ No newline at end of file
+var _0x7f93=['status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','get','VoiceQueues','inbound','QueueCampaigns','filter','ignore','map','value','includes','find','type','name','UserProfileResource','send','index','VoiceQueue','fieldName','key','query','keys','filters','intersection','model','fields','attributes','nolimit','order','sort','pick','where','merge','VIRTUAL','options','includeAll','findAll','catch','params','rawAttributes','length','create','body','user','role','outbound','UserProfileSection','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','include','omit','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','userProfileId','getHoppers','findOne','CmHopper','hasOwnProperty','VoiceQueueId','rows','getHopperHistories','CmHopperFinal','CmHopperBlack','getTeams','Team','addTeams','teams','User','Agents','online','voicePause','flatMap','forEach','penalty','sequelize','transaction','findOrCreate','UserVoiceQueueRt','upsert','isNil','interface','format','SIP/%s','removeTeams','select','field','tq.TeamId','from','team_has_voice_queues','join','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','SELECT','every','TeamId','all','union','compact','emit','addAgents','ids','spread','userVoiceQueue:save','isEmpty','removeAgents','isArray','userVoiceQueue:remove','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','always','insert','cm_hopper','fromQuery','phone','ListId','NOW()','ContactId','CmListId','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','COALESCE(phone,\x27\x27)','onlyIfOpen','into','scheduledAt','ListId\x20=\x20?','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','sendStatus'];(function(_0x3ff10b,_0x3ceeba){var _0x4f116f=function(_0x5052b7){while(--_0x5052b7){_0x3ff10b['push'](_0x3ff10b['shift']());}};_0x4f116f(++_0x3ceeba);}(_0x7f93,0x153));var _0x37f9=function(_0x123d7f,_0x24ea2c){_0x123d7f=_0x123d7f-0x0;var _0x2c8dea=_0x7f93[_0x123d7f];return _0x2c8dea;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x37f9('0x0'));var jsonpatch=require(_0x37f9('0x1'));var rp=require(_0x37f9('0x2'));var moment=require(_0x37f9('0x3'));var BPromise=require(_0x37f9('0x4'));var Mustache=require(_0x37f9('0x5'));var util=require(_0x37f9('0x6'));var path=require(_0x37f9('0x7'));var sox=require('sox');var csv=require(_0x37f9('0x8'));var ejs=require(_0x37f9('0x9'));var fs=require('fs');var _=require(_0x37f9('0xa'));var squel=require('squel');var crypto=require(_0x37f9('0xb'));var jsforce=require(_0x37f9('0xc'));var deskjs=require(_0x37f9('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x37f9('0xe'));var Redis=require('ioredis');var authService=require(_0x37f9('0xf'));var qs=require(_0x37f9('0x10'));var as=require(_0x37f9('0x11'));var hardwareService=require(_0x37f9('0x12'));var logger=require('../../config/logger')(_0x37f9('0x13'));var utils=require(_0x37f9('0x14'));var config=require(_0x37f9('0x15'));var licenseUtil=require(_0x37f9('0x16'));var db=require('../../mysqldb')['db'];config[_0x37f9('0x17')]=_[_0x37f9('0x18')](config[_0x37f9('0x17')],{'host':_0x37f9('0x19'),'port':0x18eb});var socket=require(_0x37f9('0x1a'))(new Redis(config[_0x37f9('0x17')]));require(_0x37f9('0x1b'))['register'](socket);function respondWithStatusCode(_0x36a202,_0x1fe1f9){_0x1fe1f9=_0x1fe1f9||0xcc;return function(_0x334605){if(_0x334605){return _0x36a202[_0x37f9('0x1c')](_0x1fe1f9);}return _0x36a202[_0x37f9('0x1d')](_0x1fe1f9)[_0x37f9('0x1e')]();};}function respondWithResult(_0x3f70a3,_0x5f2a0b){_0x5f2a0b=_0x5f2a0b||0xc8;return function(_0x11a2c6){if(_0x11a2c6){return _0x3f70a3[_0x37f9('0x1d')](_0x5f2a0b)[_0x37f9('0x1f')](_0x11a2c6);}};}function respondWithFilteredResult(_0x484990,_0x6546bd){return function(_0x2a1f9d){if(_0x2a1f9d){var _0x1de03d=_0x2a1f9d[_0x37f9('0x20')],_0x5592cb=_0x6546bd['offset'],_0x2f8f6d=_0x6546bd[_0x37f9('0x21')]+_0x6546bd[_0x37f9('0x22')],_0x579084;if(_0x2f8f6d>=_0x1de03d){_0x2f8f6d=_0x1de03d;_0x579084=0xc8;}else{_0x579084=0xce;}_0x484990[_0x37f9('0x1d')](_0x579084);return _0x484990[_0x37f9('0x23')](_0x37f9('0x24'),_0x5592cb+'-'+_0x2f8f6d+'/'+_0x1de03d)['json'](_0x2a1f9d);}return null;};}function patchUpdates(_0x114662){return function(_0x3134f2){try{jsonpatch[_0x37f9('0x25')](_0x3134f2,_0x114662,!![]);}catch(_0x496d09){return BPromise[_0x37f9('0x26')](_0x496d09);}return _0x3134f2[_0x37f9('0x27')]();};}function saveUpdates(_0x181b91,_0x13566f){return function(_0x47ecb8){if(_0x47ecb8){return _0x47ecb8[_0x37f9('0x28')](_0x181b91)[_0x37f9('0x29')](function(_0x37784a){return _0x37784a;});}return null;};}function removeEntity(_0x58149a,_0x3c3e70){return function(_0x5cfd03){if(_0x5cfd03){return _0x5cfd03[_0x37f9('0x2a')]()[_0x37f9('0x29')](function(){var _0x6b8a14=_0x5cfd03[_0x37f9('0x2b')]({'plain':!![]});var _0x53c51c=[{'name':_0x37f9('0x2c'),'value':_0x37f9('0x2d'),'ignore':![]},{'name':_0x37f9('0x2e'),'value':'outbound','ignore':![]}];var _0x25b727=_(_0x53c51c)[_0x37f9('0x2f')](_0x37f9('0x30'))[_0x37f9('0x31')]('value')[_0x37f9('0x32')]();if(_[_0x37f9('0x33')](_0x25b727,_0x6b8a14['type'])){return;}var _0x177b05=_[_0x37f9('0x34')](_0x53c51c,['value',_0x6b8a14[_0x37f9('0x35')]])[_0x37f9('0x36')];return db[_0x37f9('0x37')][_0x37f9('0x2a')]({'where':{'type':_0x177b05,'resourceId':_0x6b8a14['id']}})[_0x37f9('0x29')](function(){return _0x5cfd03;});})[_0x37f9('0x29')](function(){_0x58149a[_0x37f9('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0xaa0d05,_0x16bff5){return function(_0x4d3d2d){if(!_0x4d3d2d){_0xaa0d05[_0x37f9('0x1c')](0x194);}return _0x4d3d2d;};}function handleError(_0x307102,_0xfe6bfd){_0xfe6bfd=_0xfe6bfd||0x1f4;return function(_0xebbbcf){logger['error'](_0xebbbcf['stack']);if(_0xebbbcf['name']){delete _0xebbbcf['name'];}_0x307102[_0x37f9('0x1d')](_0xfe6bfd)[_0x37f9('0x38')](_0xebbbcf);};}exports[_0x37f9('0x39')]=function(_0x4d04d8,_0x94401b){var _0xd4a861={},_0x48645c={},_0xc81f28={'count':0x0,'rows':[]};var _0x411fc6=_[_0x37f9('0x31')](db[_0x37f9('0x3a')]['rawAttributes'],function(_0x368e82){return{'name':_0x368e82[_0x37f9('0x3b')],'type':_0x368e82[_0x37f9('0x35')][_0x37f9('0x3c')]};});_0x48645c['model']=_[_0x37f9('0x31')](_0x411fc6,_0x37f9('0x36'));_0x48645c[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x4d04d8['query']);_0x48645c[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x48645c[_0x37f9('0x41')],_0x48645c[_0x37f9('0x3d')]);_0xd4a861['attributes']=_[_0x37f9('0x40')](_0x48645c[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x42')]));_0xd4a861[_0x37f9('0x43')]=_0xd4a861[_0x37f9('0x43')]['length']?_0xd4a861[_0x37f9('0x43')]:_0x48645c[_0x37f9('0x41')];if(!_0x4d04d8[_0x37f9('0x3d')]['hasOwnProperty'](_0x37f9('0x44'))){_0xd4a861[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x4d04d8['query']['limit']);_0xd4a861['offset']=qs['offset'](_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x21')]);}_0xd4a861[_0x37f9('0x45')]=qs['sort'](_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x46')]);_0xd4a861['where']=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x4d04d8['query'],_0x48645c[_0x37f9('0x3f')]),_0x411fc6);if(_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x2f')]){_0xd4a861[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0xd4a861[_0x37f9('0x48')],{'$or':_[_0x37f9('0x31')](_0x411fc6,function(_0x338d85){if(_0x338d85['type']!==_0x37f9('0x4a')){var _0x40fd89={};_0x40fd89[_0x338d85[_0x37f9('0x36')]]={'$like':'%'+_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x40fd89;}})});}_0xd4a861=_[_0x37f9('0x49')]({},_0xd4a861,_0x4d04d8[_0x37f9('0x4b')]);var _0x2bec95={'where':_0xd4a861['where']};return db['VoiceQueue'][_0x37f9('0x20')](_0x2bec95)[_0x37f9('0x29')](function(_0x181f6e){_0xc81f28[_0x37f9('0x20')]=_0x181f6e;if(_0x4d04d8[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0xd4a861['include']=[{'all':!![]}];}return db[_0x37f9('0x3a')][_0x37f9('0x4d')](_0xd4a861);})[_0x37f9('0x29')](function(_0x2a9c3d){_0xc81f28['rows']=_0x2a9c3d;return _0xc81f28;})[_0x37f9('0x29')](respondWithFilteredResult(_0x94401b,_0xd4a861))[_0x37f9('0x4e')](handleError(_0x94401b,null));};exports['show']=function(_0x825a9e,_0xbfa661){var _0x19e524={'raw':![],'where':{'id':_0x825a9e[_0x37f9('0x4f')]['id']}},_0x2bc856={};_0x2bc856[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db['VoiceQueue'][_0x37f9('0x50')]);_0x2bc856[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x825a9e[_0x37f9('0x3d')]);_0x2bc856[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x2bc856[_0x37f9('0x41')],_0x2bc856[_0x37f9('0x3d')]);_0x19e524['attributes']=_[_0x37f9('0x40')](_0x2bc856['model'],qs[_0x37f9('0x42')](_0x825a9e[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x19e524['attributes']=_0x19e524[_0x37f9('0x43')][_0x37f9('0x51')]?_0x19e524[_0x37f9('0x43')]:_0x2bc856[_0x37f9('0x41')];if(_0x825a9e[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0x19e524['include']=[{'all':!![]}];}_0x19e524=_[_0x37f9('0x49')]({},_0x19e524,_0x825a9e[_0x37f9('0x4b')]);return db[_0x37f9('0x3a')][_0x37f9('0x34')](_0x19e524)[_0x37f9('0x29')](handleEntityNotFound(_0xbfa661,null))[_0x37f9('0x29')](respondWithResult(_0xbfa661,null))[_0x37f9('0x4e')](handleError(_0xbfa661,null));};exports['create']=function(_0x552bf4,_0x50132a){return db[_0x37f9('0x3a')][_0x37f9('0x52')](_0x552bf4[_0x37f9('0x53')],{})[_0x37f9('0x29')](function(_0x3a864d){var _0x535636=_0x552bf4[_0x37f9('0x54')][_0x37f9('0x2b')]({'plain':!![]});if(!_0x535636)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x535636[_0x37f9('0x55')]==='user'){var _0x2b1c82=_0x3a864d[_0x37f9('0x2b')]({'plain':!![]});var _0xd37646=[{'name':_0x37f9('0x2c'),'value':_0x37f9('0x2d')},{'name':_0x37f9('0x2e'),'value':_0x37f9('0x56')}];var _0x1140c7=_['find'](_0xd37646,[_0x37f9('0x32'),_0x2b1c82[_0x37f9('0x35')]])[_0x37f9('0x36')];return db[_0x37f9('0x57')][_0x37f9('0x34')]({'where':{'name':_0x1140c7,'userProfileId':_0x535636['userProfileId']},'raw':!![]})[_0x37f9('0x29')](function(_0x5df2d8){if(_0x5df2d8&&_0x5df2d8[_0x37f9('0x58')]===0x0){return db[_0x37f9('0x37')][_0x37f9('0x52')]({'name':_0x2b1c82['name'],'resourceId':_0x2b1c82['id'],'type':_0x5df2d8['name'],'sectionId':_0x5df2d8['id']},{})[_0x37f9('0x29')](function(){return _0x3a864d;});}else{return _0x3a864d;}})['catch'](function(_0x225222){logger[_0x37f9('0x59')](_0x37f9('0x5a'),_0x225222);throw _0x225222;});}return _0x3a864d;})[_0x37f9('0x29')](respondWithResult(_0x50132a,0xc9))[_0x37f9('0x4e')](handleError(_0x50132a,null));};exports['clone']=function(_0x3c6acd,_0x43159e){var _0x23c552={'where':{'id':_0x3c6acd[_0x37f9('0x4f')]['id']}},_0x5948c3={};_0x5948c3['model']=_[_0x37f9('0x3e')](db[_0x37f9('0x3a')][_0x37f9('0x50')]);_0x23c552['attributes']=_[_0x37f9('0x40')](_0x5948c3[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x3c6acd['query'][_0x37f9('0x42')]));_0x23c552[_0x37f9('0x43')]=_0x23c552['attributes'][_0x37f9('0x51')]?_0x23c552[_0x37f9('0x43')]:_0x5948c3[_0x37f9('0x41')];if(_0x3c6acd[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0x23c552[_0x37f9('0x5b')]=[{'all':!![]}];}_0x23c552=_[_0x37f9('0x49')]({},_0x23c552,_0x3c6acd[_0x37f9('0x4b')]);return db[_0x37f9('0x3a')][_0x37f9('0x34')](_0x23c552)['then'](handleEntityNotFound(_0x43159e,null))[_0x37f9('0x29')](function(_0x209824){if(_0x209824){var _0x5bb5c5=_0x209824['get']({'plain':!![]});_0x5bb5c5=qs[_0x37f9('0x5c')](_0x5bb5c5,['id',_0x37f9('0x5d'),_0x37f9('0x5e')]);_0x3c6acd[_0x37f9('0x53')]=_['omit'](_0x3c6acd[_0x37f9('0x53')],['id',_0x37f9('0x5d'),_0x37f9('0x5e')]);return db[_0x37f9('0x3a')][_0x37f9('0x52')](_[_0x37f9('0x49')](_0x5bb5c5,_0x3c6acd['body']),{'include':_0x3c6acd[_0x37f9('0x3d')][_0x37f9('0x4c')]?[{'all':!![]}]:undefined})[_0x37f9('0x29')](function(_0x1a5fe3){var _0x52314d=_0x3c6acd[_0x37f9('0x54')][_0x37f9('0x2b')]({'plain':!![]});if(!_0x52314d)throw new Error(_0x37f9('0x5f'));if(_0x52314d[_0x37f9('0x55')]===_0x37f9('0x54')){var _0x5580bc=_0x1a5fe3[_0x37f9('0x2b')]({'plain':!![]});var _0x131920=[{'name':_0x37f9('0x2c'),'value':_0x37f9('0x2d')},{'name':_0x37f9('0x2e'),'value':_0x37f9('0x56')}];var _0x3e31a6=_['find'](_0x131920,[_0x37f9('0x32'),_0x5580bc[_0x37f9('0x35')]])[_0x37f9('0x36')];return db[_0x37f9('0x57')]['find']({'where':{'name':_0x3e31a6,'userProfileId':_0x52314d[_0x37f9('0x60')]},'raw':!![]})['then'](function(_0x273ef1){if(_0x273ef1&&_0x273ef1[_0x37f9('0x58')]===0x0){return db[_0x37f9('0x37')][_0x37f9('0x52')]({'name':_0x5580bc[_0x37f9('0x36')],'resourceId':_0x5580bc['id'],'type':_0x273ef1['name'],'sectionId':_0x273ef1['id']},{})[_0x37f9('0x29')](function(){return _0x1a5fe3;});}else{return _0x1a5fe3;}})[_0x37f9('0x4e')](function(_0x2386c5){logger[_0x37f9('0x59')](_0x37f9('0x5a'),_0x2386c5);throw _0x2386c5;});}return _0x1a5fe3;});}})[_0x37f9('0x29')](respondWithResult(_0x43159e,0xc9))[_0x37f9('0x4e')](handleError(_0x43159e,null));};exports['update']=function(_0xf38da2,_0x4fd8c8){if(_0xf38da2[_0x37f9('0x53')]['id']){delete _0xf38da2[_0x37f9('0x53')]['id'];}return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0xf38da2[_0x37f9('0x4f')]['id']}})['then'](handleEntityNotFound(_0x4fd8c8,null))[_0x37f9('0x29')](saveUpdates(_0xf38da2[_0x37f9('0x53')],null))[_0x37f9('0x29')](respondWithResult(_0x4fd8c8,null))['catch'](handleError(_0x4fd8c8,null));};exports[_0x37f9('0x2a')]=function(_0x29244e,_0x1aab7f){return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0x29244e[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x1aab7f,null))[_0x37f9('0x29')](removeEntity(_0x1aab7f,null))['catch'](handleError(_0x1aab7f,null));};exports[_0x37f9('0x61')]=function(_0x4e0831,_0x317c59,_0x2c7cf7){var _0x29ea19={'raw':![],'where':{}};var _0x29d1c4={};var _0x94bf83={'count':0x0,'rows':[]};return db[_0x37f9('0x3a')][_0x37f9('0x62')]({'where':{'id':_0x4e0831['params']['id']}})['then'](handleEntityNotFound(_0x317c59,null))[_0x37f9('0x29')](function(_0x4e65bb){if(_0x4e65bb){_0x29d1c4[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x63')][_0x37f9('0x50')]);_0x29d1c4[_0x37f9('0x3d')]=_['keys'](_0x4e0831[_0x37f9('0x3d')]);_0x29d1c4[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x29d1c4[_0x37f9('0x41')],_0x29d1c4[_0x37f9('0x3d')]);_0x29ea19[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x29d1c4[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x4e0831[_0x37f9('0x3d')]['fields']));_0x29ea19[_0x37f9('0x43')]=_0x29ea19[_0x37f9('0x43')][_0x37f9('0x51')]?_0x29ea19['attributes']:_0x29d1c4['model'];if(!_0x4e0831['query'][_0x37f9('0x64')](_0x37f9('0x44'))){_0x29ea19['limit']=qs[_0x37f9('0x22')](_0x4e0831[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x29ea19[_0x37f9('0x21')]=qs['offset'](_0x4e0831['query'][_0x37f9('0x21')]);}_0x29ea19['order']=qs['sort'](_0x4e0831[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x29ea19[_0x37f9('0x48')]=qs['filters'](_[_0x37f9('0x47')](_0x4e0831[_0x37f9('0x3d')],_0x29d1c4[_0x37f9('0x3f')]));_0x29ea19[_0x37f9('0x48')][_0x37f9('0x65')]=_0x4e65bb['id'];if(_0x4e0831['query']['filter']){_0x29ea19[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x29ea19[_0x37f9('0x48')],{'$or':_[_0x37f9('0x31')](_0x29ea19['attributes'],function(_0x554f3b){var _0x3da191={};_0x3da191[_0x554f3b]={'$like':'%'+_0x4e0831['query'][_0x37f9('0x2f')]+'%'};return _0x3da191;})});}_0x29ea19=_['merge']({},_0x29ea19,_0x4e0831['options']);return db[_0x37f9('0x63')]['count']({'where':_0x29ea19[_0x37f9('0x48')]})[_0x37f9('0x29')](function(_0x26958b){_0x94bf83[_0x37f9('0x20')]=_0x26958b;if(_0x4e0831[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0x29ea19['include']=[{'all':!![]}];}return db[_0x37f9('0x63')]['findAll'](_0x29ea19);})[_0x37f9('0x29')](function(_0x47e66e){_0x94bf83[_0x37f9('0x66')]=_0x47e66e;return _0x94bf83;});}})[_0x37f9('0x29')](respondWithFilteredResult(_0x317c59,_0x29ea19))[_0x37f9('0x4e')](handleError(_0x317c59,null));};exports[_0x37f9('0x67')]=function(_0x3bf50f,_0x24c480,_0x3059fa){var _0x410c1c={'raw':!![],'where':{}};var _0x5608fa={};var _0x203bae={'count':0x0,'rows':[]};return db[_0x37f9('0x3a')][_0x37f9('0x62')]({'where':{'id':_0x3bf50f[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x24c480,null))[_0x37f9('0x29')](function(_0x213c7d){if(_0x213c7d){_0x5608fa[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db['CmHopperHistory'][_0x37f9('0x50')]);_0x5608fa[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x3bf50f[_0x37f9('0x3d')]);_0x5608fa[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x5608fa[_0x37f9('0x41')],_0x5608fa[_0x37f9('0x3d')]);_0x410c1c[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x5608fa['model'],qs['fields'](_0x3bf50f[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x410c1c[_0x37f9('0x43')]=_0x410c1c[_0x37f9('0x43')][_0x37f9('0x51')]?_0x410c1c[_0x37f9('0x43')]:_0x5608fa[_0x37f9('0x41')];if(!_0x3bf50f[_0x37f9('0x3d')][_0x37f9('0x64')](_0x37f9('0x44'))){_0x410c1c[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x3bf50f[_0x37f9('0x3d')]['limit']);_0x410c1c[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x3bf50f['query']['offset']);}_0x410c1c['order']=qs['sort'](_0x3bf50f[_0x37f9('0x3d')]['sort']);_0x410c1c[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_['pick'](_0x3bf50f[_0x37f9('0x3d')],_0x5608fa[_0x37f9('0x3f')]));_0x410c1c[_0x37f9('0x48')][_0x37f9('0x65')]=_0x213c7d['id'];if(_0x3bf50f['query'][_0x37f9('0x2f')]){_0x410c1c['where']=_[_0x37f9('0x49')](_0x410c1c['where'],{'$or':_[_0x37f9('0x31')](_0x410c1c[_0x37f9('0x43')],function(_0x583859){var _0x5d58be={};_0x5d58be[_0x583859]={'$like':'%'+_0x3bf50f[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x5d58be;})});}_0x410c1c=_[_0x37f9('0x49')]({},_0x410c1c,_0x3bf50f[_0x37f9('0x4b')]);return db['CmHopperHistory'][_0x37f9('0x20')]({'where':_0x410c1c[_0x37f9('0x48')]})[_0x37f9('0x29')](function(_0x5d2d0d){_0x203bae['count']=_0x5d2d0d;if(_0x3bf50f[_0x37f9('0x3d')][_0x37f9('0x4c')]){_0x410c1c[_0x37f9('0x5b')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x37f9('0x4d')](_0x410c1c);})[_0x37f9('0x29')](function(_0x1d93a5){_0x203bae[_0x37f9('0x66')]=_0x1d93a5;return _0x203bae;});}})[_0x37f9('0x29')](respondWithFilteredResult(_0x24c480,_0x410c1c))['catch'](handleError(_0x24c480,null));};exports['getHopperFinals']=function(_0x498ae5,_0x3876d5,_0x4d1ebc){var _0x32d20e={'raw':!![],'where':{}};var _0x1faa22={};var _0xe6e44f={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x37f9('0x62')]({'where':{'id':_0x498ae5['params']['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x3876d5,null))['then'](function(_0xad9933){if(_0xad9933){_0x1faa22[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x68')][_0x37f9('0x50')]);_0x1faa22['query']=_[_0x37f9('0x3e')](_0x498ae5['query']);_0x1faa22[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x1faa22[_0x37f9('0x41')],_0x1faa22['query']);_0x32d20e[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x1faa22[_0x37f9('0x41')],qs['fields'](_0x498ae5['query']['fields']));_0x32d20e[_0x37f9('0x43')]=_0x32d20e['attributes']['length']?_0x32d20e['attributes']:_0x1faa22['model'];if(!_0x498ae5['query'][_0x37f9('0x64')](_0x37f9('0x44'))){_0x32d20e[_0x37f9('0x22')]=qs['limit'](_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x32d20e[_0x37f9('0x21')]=qs['offset'](_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x21')]);}_0x32d20e[_0x37f9('0x45')]=qs[_0x37f9('0x46')](_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x32d20e[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_['pick'](_0x498ae5[_0x37f9('0x3d')],_0x1faa22['filters']));_0x32d20e[_0x37f9('0x48')][_0x37f9('0x65')]=_0xad9933['id'];if(_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x2f')]){_0x32d20e[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x32d20e[_0x37f9('0x48')],{'$or':_[_0x37f9('0x31')](_0x32d20e[_0x37f9('0x43')],function(_0x5ce60d){var _0x1220ea={};_0x1220ea[_0x5ce60d]={'$like':'%'+_0x498ae5[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x1220ea;})});}_0x32d20e=_[_0x37f9('0x49')]({},_0x32d20e,_0x498ae5[_0x37f9('0x4b')]);return db['CmHopperFinal']['count']({'where':_0x32d20e[_0x37f9('0x48')]})['then'](function(_0x8b2b01){_0xe6e44f[_0x37f9('0x20')]=_0x8b2b01;if(_0x498ae5['query']['includeAll']){_0x32d20e[_0x37f9('0x5b')]=[{'all':!![]}];}return db[_0x37f9('0x68')][_0x37f9('0x4d')](_0x32d20e);})[_0x37f9('0x29')](function(_0x28e457){_0xe6e44f[_0x37f9('0x66')]=_0x28e457;return _0xe6e44f;});}})[_0x37f9('0x29')](respondWithFilteredResult(_0x3876d5,_0x32d20e))[_0x37f9('0x4e')](handleError(_0x3876d5,null));};exports['getHopperBlacks']=function(_0x1e3017,_0x301aee,_0x46a493){var _0x1f906d={'raw':!![],'where':{}};var _0x774f69={};var _0x3618ad={'count':0x0,'rows':[]};return db[_0x37f9('0x3a')][_0x37f9('0x62')]({'where':{'id':_0x1e3017[_0x37f9('0x4f')]['id']}})['then'](handleEntityNotFound(_0x301aee,null))[_0x37f9('0x29')](function(_0x3a3205){if(_0x3a3205){_0x774f69[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db['CmHopperBlack'][_0x37f9('0x50')]);_0x774f69[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x1e3017[_0x37f9('0x3d')]);_0x774f69[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x774f69['model'],_0x774f69['query']);_0x1f906d[_0x37f9('0x43')]=_['intersection'](_0x774f69[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x1e3017[_0x37f9('0x3d')]['fields']));_0x1f906d[_0x37f9('0x43')]=_0x1f906d['attributes'][_0x37f9('0x51')]?_0x1f906d[_0x37f9('0x43')]:_0x774f69['model'];if(!_0x1e3017[_0x37f9('0x3d')][_0x37f9('0x64')](_0x37f9('0x44'))){_0x1f906d['limit']=qs[_0x37f9('0x22')](_0x1e3017[_0x37f9('0x3d')]['limit']);_0x1f906d[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x1e3017[_0x37f9('0x3d')][_0x37f9('0x21')]);}_0x1f906d[_0x37f9('0x45')]=qs[_0x37f9('0x46')](_0x1e3017[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x1f906d[_0x37f9('0x48')]=qs['filters'](_[_0x37f9('0x47')](_0x1e3017['query'],_0x774f69[_0x37f9('0x3f')]));_0x1f906d[_0x37f9('0x48')][_0x37f9('0x65')]=_0x3a3205['id'];if(_0x1e3017[_0x37f9('0x3d')][_0x37f9('0x2f')]){_0x1f906d[_0x37f9('0x48')]=_['merge'](_0x1f906d['where'],{'$or':_[_0x37f9('0x31')](_0x1f906d[_0x37f9('0x43')],function(_0x548854){var _0x5c7497={};_0x5c7497[_0x548854]={'$like':'%'+_0x1e3017[_0x37f9('0x3d')]['filter']+'%'};return _0x5c7497;})});}_0x1f906d=_['merge']({},_0x1f906d,_0x1e3017[_0x37f9('0x4b')]);return db[_0x37f9('0x69')][_0x37f9('0x20')]({'where':_0x1f906d['where']})['then'](function(_0x2dd59f){_0x3618ad[_0x37f9('0x20')]=_0x2dd59f;if(_0x1e3017['query'][_0x37f9('0x4c')]){_0x1f906d[_0x37f9('0x5b')]=[{'all':!![]}];}return db[_0x37f9('0x69')][_0x37f9('0x4d')](_0x1f906d);})['then'](function(_0x58b16f){_0x3618ad[_0x37f9('0x66')]=_0x58b16f;return _0x3618ad;});}})[_0x37f9('0x29')](respondWithFilteredResult(_0x301aee,_0x1f906d))[_0x37f9('0x4e')](handleError(_0x301aee,null));};exports[_0x37f9('0x6a')]=function(_0x383842,_0x49302f,_0x3482c8){var _0x41f298={};var _0x212cc9={};var _0x441e36;var _0x90667;return db['VoiceQueue'][_0x37f9('0x62')]({'where':{'id':_0x383842['params']['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x49302f,null))[_0x37f9('0x29')](function(_0x34476c){if(_0x34476c){_0x441e36=_0x34476c;_0x212cc9[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x6b')]['rawAttributes']);_0x212cc9[_0x37f9('0x3d')]=_['keys'](_0x383842[_0x37f9('0x3d')]);_0x212cc9[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x212cc9[_0x37f9('0x41')],_0x212cc9[_0x37f9('0x3d')]);_0x41f298[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x212cc9[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x383842[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x41f298['attributes']=_0x41f298[_0x37f9('0x43')][_0x37f9('0x51')]?_0x41f298[_0x37f9('0x43')]:_0x212cc9[_0x37f9('0x41')];_0x41f298[_0x37f9('0x45')]=qs['sort'](_0x383842[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x41f298[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x383842['query'],_0x212cc9[_0x37f9('0x3f')]));if(_0x383842[_0x37f9('0x3d')][_0x37f9('0x2f')]){_0x41f298[_0x37f9('0x48')]=_['merge'](_0x41f298['where'],{'$or':_[_0x37f9('0x31')](_0x41f298[_0x37f9('0x43')],function(_0x564636){var _0x452e49={};_0x452e49[_0x564636]={'$like':'%'+_0x383842[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x452e49;})});}_0x41f298=_[_0x37f9('0x49')]({},_0x41f298,_0x383842[_0x37f9('0x4b')]);return _0x441e36[_0x37f9('0x6a')](_0x41f298);}})[_0x37f9('0x29')](function(_0xa2f58f){if(_0xa2f58f){_0x90667=_0xa2f58f['length'];if(!_0x383842['query'][_0x37f9('0x64')]('nolimit')){_0x41f298[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x383842[_0x37f9('0x3d')]['limit']);_0x41f298[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x383842['query'][_0x37f9('0x21')]);}return _0x441e36[_0x37f9('0x6a')](_0x41f298);}})[_0x37f9('0x29')](function(_0x35c2e1){if(_0x35c2e1){return _0x35c2e1?{'count':_0x90667,'rows':_0x35c2e1}:null;}})[_0x37f9('0x29')](respondWithResult(_0x49302f,null))['catch'](handleError(_0x49302f,null));};exports[_0x37f9('0x6c')]=function(_0x303132,_0x1a73c3,_0xfa970b){var _0x49526d=_0x303132['body'][_0x37f9('0x6d')];var _0x4656d5=_[_0x37f9('0x31')](_0x49526d,'id');return db[_0x37f9('0x6b')][_0x37f9('0x4d')]({'where':{'id':_0x4656d5},'attributes':['id'],'include':[{'model':db[_0x37f9('0x6e')],'as':_0x37f9('0x6f'),'attributes':['id',_0x37f9('0x36'),_0x37f9('0x70'),_0x37f9('0x71'),'interface'],'raw':!![]}]})['then'](function(_0x3edcae){if(_0x3edcae){var _0x2d22c4=_[_0x37f9('0x72')](_0x3edcae,function(_0x3b4288){var _0x5470e4=_0x3b4288[_0x37f9('0x2b')]({'plain':!![]});_0x5470e4[_0x37f9('0x6f')][_0x37f9('0x73')](function(_0x42864c){_0x42864c[_0x37f9('0x74')]=_['find'](_0x49526d,{'id':_0x5470e4['id']})[_0x37f9('0x74')];});return _0x5470e4[_0x37f9('0x6f')];});return db['VoiceQueue'][_0x37f9('0x34')]({'where':{'id':_0x303132[_0x37f9('0x4f')]['id']}})['then'](function(_0x414da9){return db[_0x37f9('0x75')][_0x37f9('0x76')](function(_0x2cf138){return _0x414da9[_0x37f9('0x6c')](_0x4656d5,{'transaction':_0x2cf138})['then'](function(){return BPromise['each'](_0x2d22c4,function(_0x1cc003){return db['UserVoiceQueue'][_0x37f9('0x77')]({'where':{'UserId':_0x1cc003['id'],'VoiceQueueId':_0x303132[_0x37f9('0x4f')]['id']},'defaults':{'penalty':_0x1cc003[_0x37f9('0x74')]},'transaction':_0x2cf138});});})[_0x37f9('0x29')](function(){return BPromise['each'](_[_0x37f9('0x2f')](_0x2d22c4,{'online':!![]}),function(_0x34ae23){return db[_0x37f9('0x78')][_0x37f9('0x79')]({'membername':_0x34ae23[_0x37f9('0x36')],'UserId':_0x34ae23['id'],'queue_name':_0x414da9['name'],'VoiceQueueId':_0x414da9['id'],'interface':_[_0x37f9('0x7a')](_0x34ae23[_0x37f9('0x7b')])?util[_0x37f9('0x7c')](_0x37f9('0x7d'),_0x34ae23[_0x37f9('0x36')]):_0x34ae23[_0x37f9('0x7b')],'paused':_0x34ae23[_0x37f9('0x71')]||![],'penalty':_0x34ae23['penalty']},{'transaction':_0x2cf138});});})[_0x37f9('0x29')](function(){_0x2d22c4[_0x37f9('0x73')](function(_0x295f58){socket['emit']('userVoiceQueue:save',{'UserId':_0x295f58['id'],'VoiceQueueId':_0x414da9['id']});});});});});}})[_0x37f9('0x29')](respondWithStatusCode(_0x1a73c3,null))[_0x37f9('0x4e')](handleError(_0x1a73c3,null));};exports[_0x37f9('0x7e')]=function(_0x51eaaf,_0x9a1782,_0x2b9b44){return db[_0x37f9('0x6b')][_0x37f9('0x4d')]({'where':{'id':_0x51eaaf['query']['ids']},'attributes':['id'],'include':[{'model':db[_0x37f9('0x6e')],'as':_0x37f9('0x6f'),'attributes':['id'],'raw':!![]}]})[_0x37f9('0x29')](handleEntityNotFound(_0x9a1782,null))[_0x37f9('0x29')](function(_0x4d3c72){var _0x43731d=_[_0x37f9('0x31')](_0x4d3c72,'id');var _0x3bc466=[];var _0x22aa1d=[];var _0x2c4455=squel[_0x37f9('0x7f')]();_0x2c4455[_0x37f9('0x80')](_0x37f9('0x81'))[_0x37f9('0x82')](_0x37f9('0x83'),'tq')[_0x37f9('0x84')]('user_has_teams','ut',_0x37f9('0x85'))[_0x37f9('0x48')](_0x37f9('0x86'),_0x51eaaf[_0x37f9('0x4f')]['id']);for(var _0x288e11=0x0;_0x288e11<_0x4d3c72['length'];_0x288e11+=0x1){let _0x3419c0=_0x4d3c72[_0x288e11];for(var _0x5b701a=0x0;_0x5b701a<_0x3419c0[_0x37f9('0x6f')][_0x37f9('0x51')];_0x5b701a+=0x1){let _0x1e49d6=_0x3419c0[_0x37f9('0x6f')][_0x5b701a];var _0x2be08d=_0x2c4455[_0x37f9('0x87')]();_0x2be08d[_0x37f9('0x48')](_0x37f9('0x88'),_0x1e49d6['id']);_0x22aa1d[_0x37f9('0x89')](db[_0x37f9('0x75')][_0x37f9('0x3d')](_0x2be08d[_0x37f9('0x8a')](),{'type':db[_0x37f9('0x75')]['QueryTypes'][_0x37f9('0x8b')]})['then'](function(_0x59e479){if(_0x59e479[_0x37f9('0x51')]===0x1){return _0x1e49d6['id'];}else{var _0x119316=_[_0x37f9('0x8c')](_['map'](_0x59e479,_0x37f9('0x8d')),function(_0x242100){return _[_0x37f9('0x33')](_0x43731d,_0x242100);});if(_0x119316){return _0x1e49d6['id'];}}}));}}return BPromise[_0x37f9('0x8e')](_0x22aa1d)['then'](function(_0x218c8a){_0x3bc466=_(_0x3bc466)[_0x37f9('0x8f')](_0x218c8a)[_0x37f9('0x90')]()['value']();return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0x51eaaf[_0x37f9('0x4f')]['id']}})['then'](function(_0xfe96ff){return db[_0x37f9('0x75')][_0x37f9('0x76')](function(_0x3fff27){return _0xfe96ff['removeTeams'](_0x51eaaf[_0x37f9('0x3d')]['ids'],{'transaction':_0x3fff27})[_0x37f9('0x29')](function(){if(!_['isEmpty'](_0x3bc466)){return _0xfe96ff['removeAgents'](_0x3bc466,{'transaction':_0x3fff27})[_0x37f9('0x29')](function(){return db[_0x37f9('0x78')]['destroy']({'where':{'VoiceQueueId':_0x51eaaf['params']['id'],'UserId':_0x3bc466},'transaction':_0x3fff27});});}})['then'](function(){_0x3bc466[_0x37f9('0x73')](function(_0x37148c){socket[_0x37f9('0x91')]('userVoiceQueue:remove',{'UserId':_0x37148c,'VoiceQueueId':_0xfe96ff['id']});});});});});});})['then'](respondWithStatusCode(_0x9a1782,null))['catch'](handleError(_0x9a1782,null));};exports[_0x37f9('0x92')]=function(_0x5beebc,_0x18f9ff,_0x1d4174){var _0x155c7a,_0x1d3cec;return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0x5beebc[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x18f9ff,null))['then'](function(_0x197f81){if(_0x197f81){_0x1d3cec=_0x197f81;return _0x197f81[_0x37f9('0x92')](_0x5beebc[_0x37f9('0x53')]['ids'],_[_0x37f9('0x5c')](_0x5beebc[_0x37f9('0x53')],[_0x37f9('0x93'),'id'])||{})[_0x37f9('0x94')](function(_0x2eb86c){for(var _0x30e24e=0x0;_0x30e24e<_0x5beebc[_0x37f9('0x53')][_0x37f9('0x93')][_0x37f9('0x51')];_0x30e24e+=0x1){socket['emit'](_0x37f9('0x95'),{'UserId':_0x5beebc[_0x37f9('0x53')]['ids'][_0x30e24e],'VoiceQueueId':_0x5beebc[_0x37f9('0x4f')]['id']});}return _0x2eb86c;});}})[_0x37f9('0x29')](function(_0x434f59){_0x155c7a=_0x434f59||[];if(_0x1d3cec){return db[_0x37f9('0x6e')][_0x37f9('0x4d')]({'where':{'id':_0x5beebc[_0x37f9('0x53')][_0x37f9('0x93')]},'attributes':['id',_0x37f9('0x36'),_0x37f9('0x70'),_0x37f9('0x71'),'interface'],'raw':!![]});}})[_0x37f9('0x29')](function(_0x42ccd2){if(!_[_0x37f9('0x96')](_0x42ccd2)){var _0x53cc59=[];for(var _0x46429f=0x0;_0x46429f<_0x42ccd2[_0x37f9('0x51')];_0x46429f++){if(_0x42ccd2[_0x46429f][_0x37f9('0x70')]){_0x53cc59[_0x37f9('0x89')](db['UserVoiceQueueRt'][_0x37f9('0x79')]({'membername':_0x42ccd2[_0x46429f]['name'],'UserId':_0x42ccd2[_0x46429f]['id'],'queue_name':_0x1d3cec[_0x37f9('0x36')],'VoiceQueueId':_0x1d3cec['id'],'interface':_['isNil'](_0x42ccd2[_0x46429f][_0x37f9('0x7b')])?util['format'](_0x37f9('0x7d'),_0x42ccd2[_0x46429f][_0x37f9('0x36')]):_0x42ccd2[_0x46429f][_0x37f9('0x7b')],'paused':_0x42ccd2[_0x46429f]['voicePause']||![],'penalty':_0x5beebc[_0x37f9('0x53')][_0x37f9('0x74')]||0x0}));}}return BPromise[_0x37f9('0x8e')](_0x53cc59);}})['then'](function(){return _0x155c7a;})[_0x37f9('0x29')](respondWithResult(_0x18f9ff,null))[_0x37f9('0x4e')](handleError(_0x18f9ff,null));};exports[_0x37f9('0x97')]=function(_0x5f4574,_0x1a95be,_0x2785a9){return db['VoiceQueue'][_0x37f9('0x34')]({'where':{'id':_0x5f4574[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x1a95be,null))[_0x37f9('0x29')](function(_0x6ca85){if(_0x6ca85){return _0x6ca85[_0x37f9('0x97')](_0x5f4574[_0x37f9('0x3d')][_0x37f9('0x93')])['then'](function(){if(_[_0x37f9('0x98')](_0x5f4574['query'][_0x37f9('0x93')])){for(var _0x4b3d1b=0x0;_0x4b3d1b<_0x5f4574[_0x37f9('0x3d')][_0x37f9('0x93')][_0x37f9('0x51')];_0x4b3d1b+=0x1){socket[_0x37f9('0x91')]('userVoiceQueue:remove',{'UserId':Number(_0x5f4574[_0x37f9('0x3d')][_0x37f9('0x93')][_0x4b3d1b]),'VoiceQueueId':Number(_0x5f4574['params']['id'])});}}else{socket[_0x37f9('0x91')](_0x37f9('0x99'),{'UserId':Number(_0x5f4574[_0x37f9('0x3d')][_0x37f9('0x93')]),'VoiceQueueId':Number(_0x5f4574[_0x37f9('0x4f')]['id'])});}});}})['then'](function(_0x37f2fe){return db[_0x37f9('0x78')]['destroy']({'where':{'VoiceQueueId':_0x5f4574[_0x37f9('0x4f')]['id'],'UserId':_0x5f4574[_0x37f9('0x3d')]['ids']}})[_0x37f9('0x29')](function(){return _0x37f2fe;});})[_0x37f9('0x29')](respondWithStatusCode(_0x1a95be,null))['catch'](handleError(_0x1a95be,null));};exports[_0x37f9('0x9a')]=function(_0xbaed9c,_0x28d8a3,_0x57198f){var _0x279bc2={};var _0x3fe434={};var _0x2be9bd;var _0x30d52b;return db[_0x37f9('0x3a')][_0x37f9('0x62')]({'where':{'id':_0xbaed9c['params']['id']}})['then'](handleEntityNotFound(_0x28d8a3,null))['then'](function(_0x27b203){if(_0x27b203){_0x2be9bd=_0x27b203;_0x3fe434[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x6e')][_0x37f9('0x50')]);_0x3fe434['query']=_['keys'](_0xbaed9c[_0x37f9('0x3d')]);_0x3fe434[_0x37f9('0x3f')]=_['intersection'](_0x3fe434[_0x37f9('0x41')],_0x3fe434[_0x37f9('0x3d')]);_0x279bc2[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x3fe434[_0x37f9('0x41')],qs['fields'](_0xbaed9c['query'][_0x37f9('0x42')]));_0x279bc2[_0x37f9('0x43')]=_0x279bc2[_0x37f9('0x43')]['length']?_0x279bc2[_0x37f9('0x43')]:_0x3fe434['model'];_0x279bc2[_0x37f9('0x45')]=qs['sort'](_0xbaed9c[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x279bc2[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_['pick'](_0xbaed9c['query'],_0x3fe434[_0x37f9('0x3f')]));if(_0xbaed9c[_0x37f9('0x3d')]['filter']){_0x279bc2['where']=_[_0x37f9('0x49')](_0x279bc2[_0x37f9('0x48')],{'$or':_['map'](_0x279bc2[_0x37f9('0x43')],function(_0x1afd11){var _0x346bf0={};_0x346bf0[_0x1afd11]={'$like':'%'+_0xbaed9c[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x346bf0;})});}_0x279bc2=_[_0x37f9('0x49')]({},_0x279bc2,_0xbaed9c[_0x37f9('0x4b')]);return _0x2be9bd[_0x37f9('0x9a')](_0x279bc2);}})[_0x37f9('0x29')](function(_0x43bf3c){if(_0x43bf3c){_0x30d52b=_0x43bf3c['length'];if(!_0xbaed9c[_0x37f9('0x3d')][_0x37f9('0x64')](_0x37f9('0x44'))){_0x279bc2[_0x37f9('0x22')]=qs['limit'](_0xbaed9c[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x279bc2[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0xbaed9c['query']['offset']);}return _0x2be9bd[_0x37f9('0x9a')](_0x279bc2);}})[_0x37f9('0x29')](function(_0x5ef570){if(_0x5ef570){return _0x5ef570?{'count':_0x30d52b,'rows':_0x5ef570}:null;}})[_0x37f9('0x29')](respondWithResult(_0x28d8a3,null))['catch'](handleError(_0x28d8a3,null));};exports[_0x37f9('0x9b')]=function(_0x310612,_0x34ff42,_0x4e7e2a){var _0x26796f={};var _0x496c8c={};var _0x52f92d;var _0x267563;return db[_0x37f9('0x3a')]['findOne']({'where':{'id':_0x310612['params']['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x34ff42,null))[_0x37f9('0x29')](function(_0x406123){if(_0x406123){_0x52f92d=_0x406123;_0x496c8c[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x78')][_0x37f9('0x50')]);_0x496c8c[_0x37f9('0x3d')]=_['keys'](_0x310612[_0x37f9('0x3d')]);_0x496c8c[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x496c8c[_0x37f9('0x41')],_0x496c8c[_0x37f9('0x3d')]);_0x26796f['attributes']=_['intersection'](_0x496c8c[_0x37f9('0x41')],qs[_0x37f9('0x42')](_0x310612['query'][_0x37f9('0x42')]));_0x26796f[_0x37f9('0x43')]=_0x26796f[_0x37f9('0x43')][_0x37f9('0x51')]?_0x26796f[_0x37f9('0x43')]:_0x496c8c[_0x37f9('0x41')];_0x26796f[_0x37f9('0x45')]=qs[_0x37f9('0x46')](_0x310612[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x26796f[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x310612[_0x37f9('0x3d')],_0x496c8c[_0x37f9('0x3f')]));if(_0x310612[_0x37f9('0x3d')]['filter']){_0x26796f[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x26796f['where'],{'$or':_['map'](_0x26796f[_0x37f9('0x43')],function(_0x134c4e){var _0x5ebead={};_0x5ebead[_0x134c4e]={'$like':'%'+_0x310612[_0x37f9('0x3d')]['filter']+'%'};return _0x5ebead;})});}_0x26796f=_['merge']({},_0x26796f,_0x310612[_0x37f9('0x4b')]);return _0x52f92d[_0x37f9('0x9b')](_0x26796f);}})[_0x37f9('0x29')](function(_0x16b328){if(_0x16b328){_0x267563=_0x16b328[_0x37f9('0x51')];if(!_0x310612[_0x37f9('0x3d')]['hasOwnProperty']('nolimit')){_0x26796f[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x310612['query'][_0x37f9('0x22')]);_0x26796f[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x310612[_0x37f9('0x3d')]['offset']);}return _0x52f92d[_0x37f9('0x9b')](_0x26796f);}})[_0x37f9('0x29')](function(_0x26b7c6){return _0x26b7c6?{'count':_0x267563,'rows':_0x26b7c6}:null;})[_0x37f9('0x29')](respondWithResult(_0x34ff42,null))['catch'](handleError(_0x34ff42,null));};exports[_0x37f9('0x9c')]=function(_0x5af22d,_0xf572a2,_0x25e2d2){var _0x58a325={};var _0x71ad9a={};var _0x10d9f8;var _0xd59dd;return db['VoiceQueue']['findOne']({'where':{'id':_0x5af22d['params']['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0xf572a2,null))[_0x37f9('0x29')](function(_0x1c6f14){if(_0x1c6f14){_0x10d9f8=_0x1c6f14;_0x71ad9a[_0x37f9('0x41')]=_[_0x37f9('0x3e')](db[_0x37f9('0x9d')][_0x37f9('0x50')]);_0x71ad9a[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x5af22d['query']);_0x71ad9a[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x71ad9a[_0x37f9('0x41')],_0x71ad9a[_0x37f9('0x3d')]);_0x58a325['attributes']=_[_0x37f9('0x40')](_0x71ad9a[_0x37f9('0x41')],qs['fields'](_0x5af22d[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x58a325[_0x37f9('0x43')]=_0x58a325['attributes'][_0x37f9('0x51')]?_0x58a325[_0x37f9('0x43')]:_0x71ad9a[_0x37f9('0x41')];_0x58a325[_0x37f9('0x45')]=qs['sort'](_0x5af22d[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x58a325[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x5af22d[_0x37f9('0x3d')],_0x71ad9a[_0x37f9('0x3f')]));if(_0x5af22d['query'][_0x37f9('0x2f')]){_0x58a325[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x58a325[_0x37f9('0x48')],{'$or':_['map'](_0x58a325[_0x37f9('0x43')],function(_0x58f736){var _0x3f5bac={};_0x3f5bac[_0x58f736]={'$like':'%'+_0x5af22d[_0x37f9('0x3d')]['filter']+'%'};return _0x3f5bac;})});}_0x58a325=_['merge']({},_0x58a325,_0x5af22d['options']);return _0x10d9f8[_0x37f9('0x9c')](_0x58a325);}})['then'](function(_0x5a0869){if(_0x5a0869){_0xd59dd=_0x5a0869[_0x37f9('0x51')];if(!_0x5af22d['query'][_0x37f9('0x64')]('nolimit')){_0x58a325[_0x37f9('0x22')]=qs['limit'](_0x5af22d[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x58a325[_0x37f9('0x21')]=qs['offset'](_0x5af22d['query'][_0x37f9('0x21')]);}return _0x10d9f8[_0x37f9('0x9c')](_0x58a325);}})[_0x37f9('0x29')](function(_0x2b2f75){if(_0x2b2f75){return _0x2b2f75?{'count':_0xd59dd,'rows':_0x2b2f75}:null;}})[_0x37f9('0x29')](respondWithResult(_0xf572a2,null))[_0x37f9('0x4e')](handleError(_0xf572a2,null));};exports['addLists']=function(_0x8aa215,_0x2e883a,_0x136302){var _0x23fd78,_0x11a959;return db[_0x37f9('0x3a')]['find']({'where':{'id':_0x8aa215[_0x37f9('0x4f')]['id']}})['then'](handleEntityNotFound(_0x2e883a,null))[_0x37f9('0x29')](function(_0x2f400c){if(_0x2f400c){_0x11a959=_0x2f400c;return _0x2f400c[_0x37f9('0x9e')](_0x8aa215[_0x37f9('0x53')][_0x37f9('0x93')],_['omit'](_0x8aa215[_0x37f9('0x53')],[_0x37f9('0x93'),'id'])||{});}return null;})[_0x37f9('0x94')](function(_0x3e1ff0){var _0x23ec78;_0x23fd78=_0x3e1ff0||[];var _0x1e2ae0=[];if(_0x3e1ff0){for(var _0x3286d1=0x0;_0x3286d1<_0x3e1ff0[_0x37f9('0x51')];_0x3286d1+=0x1){var _0x5b6168=_0x3e1ff0[_0x3286d1][_0x37f9('0x2b')]({'plain':!![]});_0x11a959[_0x37f9('0x9f')]=_0x8aa215['body'][_0x37f9('0x9f')]?_0x8aa215[_0x37f9('0x53')]['dialCheckDuplicateType']:_0x11a959[_0x37f9('0x9f')];switch(_0x11a959[_0x37f9('0x9f')]){case _0x37f9('0xa0'):_0x23ec78=squel[_0x37f9('0xa1')]()['into'](_0x37f9('0xa2'))[_0x37f9('0xa3')]([_0x37f9('0xa4'),'scheduledAt','ContactId',_0x37f9('0xa5'),_0x37f9('0x65'),_0x37f9('0x5d'),_0x37f9('0x5e')],squel[_0x37f9('0x7f')]()[_0x37f9('0x80')](_0x37f9('0xa4'),_0x37f9('0xa4'))[_0x37f9('0x80')](_0x37f9('0xa6'),'scheduledAt')[_0x37f9('0x80')]('id',_0x37f9('0xa7'))[_0x37f9('0x80')](_0x5b6168[_0x37f9('0xa8')]['toString'](),_0x37f9('0xa5'))[_0x37f9('0x80')](_0x8aa215['params']['id'][_0x37f9('0x8a')](),_0x37f9('0x65'))['field'](_0x37f9('0xa6'),'createdAt')['field']('NOW()','updatedAt')[_0x37f9('0x82')](_0x37f9('0xa9'))['where'](_0x37f9('0xaa'))[_0x37f9('0x48')]('ListId\x20=\x20?',_0x5b6168['CmListId'][_0x37f9('0x8a')]())[_0x37f9('0x48')](_0x37f9('0xab'))['where'](_0x37f9('0xac'),squel[_0x37f9('0x7f')]()['field']('COALESCE(calleridnum,\x27\x27)')[_0x37f9('0x82')](_0x37f9('0xad'))[_0x37f9('0x48')](_0x37f9('0x86'),_0x8aa215[_0x37f9('0x4f')]['id'][_0x37f9('0x8a')]()))[_0x37f9('0x48')](_0x37f9('0xac'),squel[_0x37f9('0x7f')]()['field'](_0x37f9('0xae'))[_0x37f9('0x82')](_0x37f9('0xa2'))['where'](_0x37f9('0x86'),_0x8aa215[_0x37f9('0x4f')]['id']['toString']())))[_0x37f9('0x8a')]();break;case _0x37f9('0xaf'):_0x23ec78=squel['insert']()[_0x37f9('0xb0')](_0x37f9('0xa2'))[_0x37f9('0xa3')]([_0x37f9('0xa4'),_0x37f9('0xb1'),_0x37f9('0xa7'),_0x37f9('0xa5'),'VoiceQueueId',_0x37f9('0x5d'),'updatedAt'],squel['select']()['field'](_0x37f9('0xa4'),_0x37f9('0xa4'))[_0x37f9('0x80')](_0x37f9('0xa6'),'scheduledAt')[_0x37f9('0x80')]('id',_0x37f9('0xa7'))[_0x37f9('0x80')](_0x5b6168[_0x37f9('0xa8')]['toString'](),'ListId')['field'](_0x8aa215[_0x37f9('0x4f')]['id'][_0x37f9('0x8a')](),'VoiceQueueId')[_0x37f9('0x80')](_0x37f9('0xa6'),_0x37f9('0x5d'))[_0x37f9('0x80')](_0x37f9('0xa6'),_0x37f9('0x5e'))[_0x37f9('0x82')](_0x37f9('0xa9'))['where'](_0x37f9('0xaa'))['where'](_0x37f9('0xb2'),_0x5b6168[_0x37f9('0xa8')][_0x37f9('0x8a')]())[_0x37f9('0x48')](_0x37f9('0xab'))[_0x37f9('0x48')]('phone\x20NOT\x20IN\x20(?)',squel[_0x37f9('0x7f')]()[_0x37f9('0x80')](_0x37f9('0xae'))[_0x37f9('0x82')](_0x37f9('0xa2'))[_0x37f9('0x48')](_0x37f9('0x86'),_0x8aa215['params']['id'][_0x37f9('0x8a')]())))[_0x37f9('0x8a')]();break;default:_0x23ec78=squel[_0x37f9('0xa1')]()[_0x37f9('0xb0')](_0x37f9('0xa2'))[_0x37f9('0xa3')]([_0x37f9('0xa4'),_0x37f9('0xb1'),_0x37f9('0xa7'),_0x37f9('0xa5'),_0x37f9('0x65'),_0x37f9('0x5d'),_0x37f9('0x5e')],squel[_0x37f9('0x7f')]()[_0x37f9('0x80')]('phone','phone')[_0x37f9('0x80')](_0x37f9('0xa6'),'scheduledAt')[_0x37f9('0x80')]('id',_0x37f9('0xa7'))[_0x37f9('0x80')](_0x5b6168['CmListId'][_0x37f9('0x8a')](),'ListId')[_0x37f9('0x80')](_0x8aa215['params']['id'][_0x37f9('0x8a')](),_0x37f9('0x65'))['field'](_0x37f9('0xa6'),_0x37f9('0x5d'))['field'](_0x37f9('0xa6'),'updatedAt')['from'](_0x37f9('0xa9'))[_0x37f9('0x48')](_0x37f9('0xaa'))[_0x37f9('0x48')](_0x37f9('0xb2'),_0x5b6168[_0x37f9('0xa8')]['toString']())[_0x37f9('0x48')](_0x37f9('0xab')))['toString']();}_0x1e2ae0[_0x37f9('0x89')](db[_0x37f9('0x75')]['query'](_0x23ec78));}return BPromise[_0x37f9('0x8e')](_0x1e2ae0);}})[_0x37f9('0x29')](function(){return _0x23fd78;})[_0x37f9('0x29')](respondWithResult(_0x2e883a,null))[_0x37f9('0x4e')](handleError(_0x2e883a,null));};exports[_0x37f9('0xb3')]=function(_0x50addd,_0x19b3e2,_0x31678a){return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0x50addd['params']['id']}})['then'](handleEntityNotFound(_0x19b3e2,null))['then'](function(_0xf1b1f7){if(_0xf1b1f7){return _0xf1b1f7[_0x37f9('0xb3')](_0x50addd['query'][_0x37f9('0x93')]);}})['then'](function(_0x10a923){if(_0x10a923){return db[_0x37f9('0x63')][_0x37f9('0x2a')]({'where':{'ListId':_0x50addd[_0x37f9('0x3d')]['ids'],'VoiceQueueId':_0x50addd[_0x37f9('0x4f')]['id']}})['then'](function(){return _0x10a923;});}})['then'](respondWithStatusCode(_0x19b3e2,null))[_0x37f9('0x4e')](handleError(_0x19b3e2,null));};exports[_0x37f9('0xb4')]=function(_0x2e6303,_0x4971c9,_0x5b5731){var _0x14fce4={};var _0x309c8a={};var _0x594fe9;var _0x3eccfc;return db['VoiceQueue'][_0x37f9('0x62')]({'where':{'id':_0x2e6303['params']['id']}})['then'](handleEntityNotFound(_0x4971c9,null))[_0x37f9('0x29')](function(_0x417c02){if(_0x417c02){_0x594fe9=_0x417c02;_0x309c8a[_0x37f9('0x41')]=_['keys'](db[_0x37f9('0x9d')][_0x37f9('0x50')]);_0x309c8a[_0x37f9('0x3d')]=_[_0x37f9('0x3e')](_0x2e6303[_0x37f9('0x3d')]);_0x309c8a[_0x37f9('0x3f')]=_[_0x37f9('0x40')](_0x309c8a[_0x37f9('0x41')],_0x309c8a[_0x37f9('0x3d')]);_0x14fce4[_0x37f9('0x43')]=_[_0x37f9('0x40')](_0x309c8a['model'],qs['fields'](_0x2e6303[_0x37f9('0x3d')][_0x37f9('0x42')]));_0x14fce4[_0x37f9('0x43')]=_0x14fce4[_0x37f9('0x43')][_0x37f9('0x51')]?_0x14fce4['attributes']:_0x309c8a['model'];_0x14fce4[_0x37f9('0x45')]=qs[_0x37f9('0x46')](_0x2e6303[_0x37f9('0x3d')][_0x37f9('0x46')]);_0x14fce4[_0x37f9('0x48')]=qs[_0x37f9('0x3f')](_[_0x37f9('0x47')](_0x2e6303[_0x37f9('0x3d')],_0x309c8a['filters']));if(_0x2e6303['query'][_0x37f9('0x2f')]){_0x14fce4[_0x37f9('0x48')]=_[_0x37f9('0x49')](_0x14fce4['where'],{'$or':_[_0x37f9('0x31')](_0x14fce4[_0x37f9('0x43')],function(_0x49e401){var _0x19260c={};_0x19260c[_0x49e401]={'$like':'%'+_0x2e6303[_0x37f9('0x3d')][_0x37f9('0x2f')]+'%'};return _0x19260c;})});}_0x14fce4=_[_0x37f9('0x49')]({},_0x14fce4,_0x2e6303[_0x37f9('0x4b')]);return _0x594fe9[_0x37f9('0xb4')](_0x14fce4);}})[_0x37f9('0x29')](function(_0xc0d60){if(_0xc0d60){_0x3eccfc=_0xc0d60['length'];if(!_0x2e6303[_0x37f9('0x3d')]['hasOwnProperty'](_0x37f9('0x44'))){_0x14fce4[_0x37f9('0x22')]=qs[_0x37f9('0x22')](_0x2e6303[_0x37f9('0x3d')][_0x37f9('0x22')]);_0x14fce4[_0x37f9('0x21')]=qs[_0x37f9('0x21')](_0x2e6303[_0x37f9('0x3d')]['offset']);}return _0x594fe9[_0x37f9('0xb4')](_0x14fce4);}})[_0x37f9('0x29')](function(_0x2a8e9c){if(_0x2a8e9c){return _0x2a8e9c?{'count':_0x3eccfc,'rows':_0x2a8e9c}:null;}})[_0x37f9('0x29')](respondWithResult(_0x4971c9,null))['catch'](handleError(_0x4971c9,null));};exports[_0x37f9('0xb5')]=function(_0xf9247e,_0x219656,_0x5ee649){var _0x5e0b33,_0x381b00;return db[_0x37f9('0x3a')][_0x37f9('0x34')]({'where':{'id':_0xf9247e[_0x37f9('0x4f')]['id']}})[_0x37f9('0x29')](handleEntityNotFound(_0x219656,null))[_0x37f9('0x29')](function(_0x126163){if(_0x126163){_0x381b00=_0x126163;return _0x126163[_0x37f9('0xb5')](_0xf9247e[_0x37f9('0x53')][_0x37f9('0x93')],_[_0x37f9('0x5c')](_0xf9247e['body'],['ids','id'])||{});}return null;})['spread'](function(_0x6e3bc5){var _0x343ed4;_0x5e0b33=_0x6e3bc5||[];var _0x29971a=[];if(_0x6e3bc5){for(var _0x47805a=0x0;_0x47805a<_0x6e3bc5[_0x37f9('0x51')];_0x47805a+=0x1){var _0x1a2857=_0x6e3bc5[_0x47805a][_0x37f9('0x2b')]({'plain':!![]});_0x343ed4=squel['insert']()['into'](_0x37f9('0xb6'))[_0x37f9('0xa3')]([_0x37f9('0xa4'),_0x37f9('0xa7'),_0x37f9('0xa5'),_0x37f9('0x65'),'createdAt',_0x37f9('0x5e')],squel[_0x37f9('0x7f')]()[_0x37f9('0x80')](_0x37f9('0xa4'),_0x37f9('0xa4'))['field']('id','ContactId')[_0x37f9('0x80')](_0x1a2857[_0x37f9('0xa8')][_0x37f9('0x8a')](),_0x37f9('0xa5'))[_0x37f9('0x80')](_0xf9247e[_0x37f9('0x4f')]['id'][_0x37f9('0x8a')](),_0x37f9('0x65'))[_0x37f9('0x80')](_0x37f9('0xa6'),_0x37f9('0x5d'))['field']('NOW()',_0x37f9('0x5e'))[_0x37f9('0x82')](_0x37f9('0xa9'))['where'](_0x37f9('0xaa'))[_0x37f9('0x48')](_0x37f9('0xb2'),_0x1a2857[_0x37f9('0xa8')][_0x37f9('0x8a')]())[_0x37f9('0x48')](_0x37f9('0xab')))[_0x37f9('0x8a')]();_0x29971a[_0x37f9('0x89')](db[_0x37f9('0x75')][_0x37f9('0x3d')](_0x343ed4));}return BPromise['all'](_0x29971a);}})[_0x37f9('0x29')](function(){return _0x5e0b33;})[_0x37f9('0x29')](respondWithResult(_0x219656,null))[_0x37f9('0x4e')](handleError(_0x219656,null));};exports[_0x37f9('0xb7')]=function(_0x3b8753,_0x157572,_0x2b8e0c){return db[_0x37f9('0x3a')]['find']({'where':{'id':_0x3b8753[_0x37f9('0x4f')]['id']}})['then'](handleEntityNotFound(_0x157572,null))[_0x37f9('0x29')](function(_0x3e2df1){if(_0x3e2df1){return _0x3e2df1['removeBlackLists'](_0x3b8753[_0x37f9('0x3d')][_0x37f9('0x93')]);}})[_0x37f9('0x29')](function(_0x493e4b){if(_0x493e4b){return db[_0x37f9('0x69')][_0x37f9('0x2a')]({'where':{'ListId':_0x3b8753['query'][_0x37f9('0x93')],'VoiceQueueId':_0x3b8753[_0x37f9('0x4f')]['id']}})['then'](function(){return _0x493e4b;});}})['then'](respondWithStatusCode(_0x157572,null))['catch'](handleError(_0x157572,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff