// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa423=['ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','redis','localhost','socket.io-emitter','./voiceQueue.socket','register','sendStatus','end','offset','limit','undefined','count','status','Content-Range','json','apply','reject','save','update','then','inbound','QueueCampaigns','outbound','filter','ignore','value','includes','type','find','name','UserProfileResource','destroy','error','VoiceQueue','rawAttributes','fieldName','key','model','keys','filters','intersection','query','attributes','fields','length','hasOwnProperty','sort','where','pick','map','VIRTUAL','merge','includeAll','findAll','rows','catch','show','params','options','create','body','user','get','role','VoiceQueues','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','include','omit','createdAt','updatedAt','userProfileId','getHoppers','nolimit','order','VoiceQueueId','CmHopper','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','CmHopperBlack','getTeams','Team','teams','online','voicePause','interface','Agents','forEach','penalty','sequelize','transaction','addTeams','each','TeamVoiceQueue','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','format','SIP/%s','emit','userVoiceQueue:save','removeTeams','ids','select','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','QueryTypes','SELECT','every','TeamId','all','compact','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','User','push','isArray','getAgents','getMembers','getLists','CmList','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','insert','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','field','CmListId','toString','cm_contacts','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','COALESCE(phone,\x27\x27)','onlyIfOpen','into','deletedAt\x20IS\x20NULL','cm_hopper_additional_phones','h.id','ci.item','ci.OrderBy+1','PHONE','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0xa423,0x16c));var _0x3a42=function(_0x2250d9,_0x30e8f2){_0x2250d9=_0x2250d9-0x0;var _0x2a0cb3=_0xa423[_0x2250d9];return _0x2a0cb3;};'use strict';var emlformat=require(_0x3a42('0x0'));var rimraf=require(_0x3a42('0x1'));var zipdir=require(_0x3a42('0x2'));var jsonpatch=require(_0x3a42('0x3'));var rp=require(_0x3a42('0x4'));var moment=require('moment');var BPromise=require(_0x3a42('0x5'));var Mustache=require(_0x3a42('0x6'));var util=require('util');var path=require(_0x3a42('0x7'));var sox=require(_0x3a42('0x8'));var csv=require(_0x3a42('0x9'));var ejs=require(_0x3a42('0xa'));var fs=require('fs');var fs_extra=require(_0x3a42('0xb'));var _=require('lodash');var squel=require(_0x3a42('0xc'));var crypto=require(_0x3a42('0xd'));var jsforce=require(_0x3a42('0xe'));var deskjs=require(_0x3a42('0xf'));var toCsv=require(_0x3a42('0x9'));var querystring=require(_0x3a42('0x10'));var Papa=require(_0x3a42('0x11'));var Redis=require(_0x3a42('0x12'));var authService=require(_0x3a42('0x13'));var qs=require(_0x3a42('0x14'));var as=require(_0x3a42('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x3a42('0x16'))(_0x3a42('0x17'));var utils=require(_0x3a42('0x18'));var config=require(_0x3a42('0x19'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config[_0x3a42('0x1a')]=_['defaults'](config[_0x3a42('0x1a')],{'host':_0x3a42('0x1b'),'port':0x18eb});var socket=require(_0x3a42('0x1c'))(new Redis(config[_0x3a42('0x1a')]));require(_0x3a42('0x1d'))[_0x3a42('0x1e')](socket);function respondWithStatusCode(_0x5f5244,_0xd32889){_0xd32889=_0xd32889||0xcc;return function(_0x4f715c){if(_0x4f715c){return _0x5f5244[_0x3a42('0x1f')](_0xd32889);}return _0x5f5244['status'](_0xd32889)[_0x3a42('0x20')]();};}function respondWithResult(_0x5895a8,_0x46ef1e){_0x46ef1e=_0x46ef1e||0xc8;return function(_0x4edcf5){if(_0x4edcf5){return _0x5895a8['status'](_0x46ef1e)['json'](_0x4edcf5);}};}function respondWithFilteredResult(_0x26c844,_0x3a1dd0){return function(_0x438cf1){if(_0x438cf1){var _0x39e620=typeof _0x3a1dd0[_0x3a42('0x21')]==='undefined'&&typeof _0x3a1dd0[_0x3a42('0x22')]===_0x3a42('0x23');var _0x49f00e=_0x438cf1[_0x3a42('0x24')];var _0xa89087=_0x39e620?0x0:_0x3a1dd0[_0x3a42('0x21')];var _0x59f337=_0x39e620?_0x438cf1[_0x3a42('0x24')]:_0x3a1dd0[_0x3a42('0x21')]+_0x3a1dd0[_0x3a42('0x22')];var _0x477605;if(_0x59f337>=_0x49f00e){_0x59f337=_0x49f00e;_0x477605=0xc8;}else{_0x477605=0xce;}_0x26c844[_0x3a42('0x25')](_0x477605);return _0x26c844['set'](_0x3a42('0x26'),_0xa89087+'-'+_0x59f337+'/'+_0x49f00e)[_0x3a42('0x27')](_0x438cf1);}return null;};}function patchUpdates(_0x379fe6){return function(_0x434283){try{jsonpatch[_0x3a42('0x28')](_0x434283,_0x379fe6,!![]);}catch(_0x5b41d2){return BPromise[_0x3a42('0x29')](_0x5b41d2);}return _0x434283[_0x3a42('0x2a')]();};}function saveUpdates(_0x477cb9,_0x1add9b){return function(_0x1540e5){if(_0x1540e5){return _0x1540e5[_0x3a42('0x2b')](_0x477cb9)[_0x3a42('0x2c')](function(_0x434044){return _0x434044;});}return null;};}function removeEntity(_0x2c4b3a,_0x3a3f87){return function(_0x29a4d0){if(_0x29a4d0){return _0x29a4d0['destroy']()[_0x3a42('0x2c')](function(){var _0x468ea8=_0x29a4d0['get']({'plain':!![]});var _0x3027dd=[{'name':'VoiceQueues','value':_0x3a42('0x2d'),'ignore':![]},{'name':_0x3a42('0x2e'),'value':_0x3a42('0x2f'),'ignore':![]}];var _0x299282=_(_0x3027dd)[_0x3a42('0x30')](_0x3a42('0x31'))['map'](_0x3a42('0x32'))[_0x3a42('0x32')]();if(_[_0x3a42('0x33')](_0x299282,_0x468ea8[_0x3a42('0x34')])){return;}var _0x1c8fe1=_[_0x3a42('0x35')](_0x3027dd,[_0x3a42('0x32'),_0x468ea8['type']])[_0x3a42('0x36')];return db[_0x3a42('0x37')][_0x3a42('0x38')]({'where':{'type':_0x1c8fe1,'resourceId':_0x468ea8['id']}})[_0x3a42('0x2c')](function(){return _0x29a4d0;});})[_0x3a42('0x2c')](function(){_0x2c4b3a['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x1032eb,_0x51871b){return function(_0x3fb07d){if(!_0x3fb07d){_0x1032eb[_0x3a42('0x1f')](0x194);}return _0x3fb07d;};}function handleError(_0x2bbfe4,_0x421d3b){_0x421d3b=_0x421d3b||0x1f4;return function(_0x37defa){logger[_0x3a42('0x39')](_0x37defa['stack']);if(_0x37defa[_0x3a42('0x36')]){delete _0x37defa[_0x3a42('0x36')];}_0x2bbfe4[_0x3a42('0x25')](_0x421d3b)['send'](_0x37defa);};}exports['index']=function(_0x41df56,_0x3f21ed){var _0xb2f1d3={},_0xe51e6={},_0xb297ad={'count':0x0,'rows':[]};var _0x4e872b=_['map'](db[_0x3a42('0x3a')][_0x3a42('0x3b')],function(_0x6a44e8){return{'name':_0x6a44e8[_0x3a42('0x3c')],'type':_0x6a44e8['type'][_0x3a42('0x3d')]};});_0xe51e6[_0x3a42('0x3e')]=_['map'](_0x4e872b,'name');_0xe51e6['query']=_[_0x3a42('0x3f')](_0x41df56['query']);_0xe51e6[_0x3a42('0x40')]=_[_0x3a42('0x41')](_0xe51e6[_0x3a42('0x3e')],_0xe51e6[_0x3a42('0x42')]);_0xb2f1d3[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0xe51e6[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x41df56[_0x3a42('0x42')]['fields']));_0xb2f1d3[_0x3a42('0x43')]=_0xb2f1d3[_0x3a42('0x43')][_0x3a42('0x45')]?_0xb2f1d3[_0x3a42('0x43')]:_0xe51e6[_0x3a42('0x3e')];if(!_0x41df56['query'][_0x3a42('0x46')]('nolimit')){_0xb2f1d3['limit']=qs['limit'](_0x41df56['query'][_0x3a42('0x22')]);_0xb2f1d3['offset']=qs['offset'](_0x41df56['query'][_0x3a42('0x21')]);}_0xb2f1d3['order']=qs['sort'](_0x41df56[_0x3a42('0x42')][_0x3a42('0x47')]);_0xb2f1d3[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x41df56[_0x3a42('0x42')],_0xe51e6['filters']),_0x4e872b);if(_0x41df56[_0x3a42('0x42')][_0x3a42('0x30')]){_0xb2f1d3[_0x3a42('0x48')]=_['merge'](_0xb2f1d3[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x4e872b,function(_0x4f5f18){if(_0x4f5f18[_0x3a42('0x34')]!==_0x3a42('0x4b')){var _0x3b7e7d={};_0x3b7e7d[_0x4f5f18[_0x3a42('0x36')]]={'$like':'%'+_0x41df56[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x3b7e7d;}})});}_0xb2f1d3=_[_0x3a42('0x4c')]({},_0xb2f1d3,_0x41df56['options']);var _0x384758={'where':_0xb2f1d3[_0x3a42('0x48')]};return db[_0x3a42('0x3a')][_0x3a42('0x24')](_0x384758)[_0x3a42('0x2c')](function(_0x4f6f26){_0xb297ad[_0x3a42('0x24')]=_0x4f6f26;if(_0x41df56[_0x3a42('0x42')][_0x3a42('0x4d')]){_0xb2f1d3['include']=[{'all':!![]}];}return db[_0x3a42('0x3a')][_0x3a42('0x4e')](_0xb2f1d3);})[_0x3a42('0x2c')](function(_0x1645b8){_0xb297ad[_0x3a42('0x4f')]=_0x1645b8;return _0xb297ad;})['then'](respondWithFilteredResult(_0x3f21ed,_0xb2f1d3))[_0x3a42('0x50')](handleError(_0x3f21ed,null));};exports[_0x3a42('0x51')]=function(_0x3a3293,_0xa46b2a){var _0x52ab00={'raw':![],'where':{'id':_0x3a3293[_0x3a42('0x52')]['id']}},_0x2686a5={};_0x2686a5[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db[_0x3a42('0x3a')][_0x3a42('0x3b')]);_0x2686a5[_0x3a42('0x42')]=_['keys'](_0x3a3293[_0x3a42('0x42')]);_0x2686a5[_0x3a42('0x40')]=_[_0x3a42('0x41')](_0x2686a5[_0x3a42('0x3e')],_0x2686a5[_0x3a42('0x42')]);_0x52ab00[_0x3a42('0x43')]=_['intersection'](_0x2686a5[_0x3a42('0x3e')],qs['fields'](_0x3a3293[_0x3a42('0x42')][_0x3a42('0x44')]));_0x52ab00[_0x3a42('0x43')]=_0x52ab00[_0x3a42('0x43')][_0x3a42('0x45')]?_0x52ab00[_0x3a42('0x43')]:_0x2686a5[_0x3a42('0x3e')];if(_0x3a3293[_0x3a42('0x42')][_0x3a42('0x4d')]){_0x52ab00['include']=[{'all':!![]}];}_0x52ab00=_[_0x3a42('0x4c')]({},_0x52ab00,_0x3a3293[_0x3a42('0x53')]);return db['VoiceQueue']['find'](_0x52ab00)[_0x3a42('0x2c')](handleEntityNotFound(_0xa46b2a,null))[_0x3a42('0x2c')](respondWithResult(_0xa46b2a,null))['catch'](handleError(_0xa46b2a,null));};exports[_0x3a42('0x54')]=function(_0xd3d58,_0x44e249){return db['VoiceQueue'][_0x3a42('0x54')](_0xd3d58[_0x3a42('0x55')],{})['then'](function(_0x49d120){var _0x59ea1e=_0xd3d58[_0x3a42('0x56')][_0x3a42('0x57')]({'plain':!![]});if(!_0x59ea1e)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x59ea1e[_0x3a42('0x58')]===_0x3a42('0x56')){var _0x23ca9d=_0x49d120[_0x3a42('0x57')]({'plain':!![]});var _0x7a6ab6=[{'name':_0x3a42('0x59'),'value':_0x3a42('0x2d')},{'name':_0x3a42('0x2e'),'value':_0x3a42('0x2f')}];var _0x16f7a7=_['find'](_0x7a6ab6,[_0x3a42('0x32'),_0x23ca9d[_0x3a42('0x34')]])[_0x3a42('0x36')];return db[_0x3a42('0x5a')][_0x3a42('0x35')]({'where':{'name':_0x16f7a7,'userProfileId':_0x59ea1e['userProfileId']},'raw':!![]})[_0x3a42('0x2c')](function(_0xa9a61b){if(_0xa9a61b&&_0xa9a61b[_0x3a42('0x5b')]===0x0){return db['UserProfileResource'][_0x3a42('0x54')]({'name':_0x23ca9d[_0x3a42('0x36')],'resourceId':_0x23ca9d['id'],'type':_0xa9a61b['name'],'sectionId':_0xa9a61b['id']},{})[_0x3a42('0x2c')](function(){return _0x49d120;});}else{return _0x49d120;}})[_0x3a42('0x50')](function(_0x287802){logger[_0x3a42('0x39')](_0x3a42('0x5c'),_0x287802);throw _0x287802;});}return _0x49d120;})[_0x3a42('0x2c')](respondWithResult(_0x44e249,0xc9))['catch'](handleError(_0x44e249,null));};exports['clone']=function(_0x4c20f4,_0xc2e895){var _0x352967={'where':{'id':_0x4c20f4[_0x3a42('0x52')]['id']}},_0x302b24={};_0x302b24['model']=_[_0x3a42('0x3f')](db[_0x3a42('0x3a')][_0x3a42('0x3b')]);_0x352967['attributes']=_[_0x3a42('0x41')](_0x302b24[_0x3a42('0x3e')],qs['fields'](_0x4c20f4[_0x3a42('0x42')][_0x3a42('0x44')]));_0x352967[_0x3a42('0x43')]=_0x352967[_0x3a42('0x43')][_0x3a42('0x45')]?_0x352967[_0x3a42('0x43')]:_0x302b24[_0x3a42('0x3e')];if(_0x4c20f4[_0x3a42('0x42')][_0x3a42('0x4d')]){_0x352967[_0x3a42('0x5d')]=[{'all':!![]}];}_0x352967=_[_0x3a42('0x4c')]({},_0x352967,_0x4c20f4[_0x3a42('0x53')]);return db[_0x3a42('0x3a')][_0x3a42('0x35')](_0x352967)[_0x3a42('0x2c')](handleEntityNotFound(_0xc2e895,null))[_0x3a42('0x2c')](function(_0x16ece1){if(_0x16ece1){var _0x27fb39=_0x16ece1['get']({'plain':!![]});_0x27fb39=qs[_0x3a42('0x5e')](_0x27fb39,['id',_0x3a42('0x5f'),_0x3a42('0x60')]);_0x4c20f4['body']=_['omit'](_0x4c20f4['body'],['id',_0x3a42('0x5f'),_0x3a42('0x60')]);return db[_0x3a42('0x3a')][_0x3a42('0x54')](_[_0x3a42('0x4c')](_0x27fb39,_0x4c20f4[_0x3a42('0x55')]),{'include':_0x4c20f4[_0x3a42('0x42')]['includeAll']?[{'all':!![]}]:undefined})[_0x3a42('0x2c')](function(_0x20f8e9){var _0x5986fc=_0x4c20f4[_0x3a42('0x56')][_0x3a42('0x57')]({'plain':!![]});if(!_0x5986fc)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5986fc[_0x3a42('0x58')]==='user'){var _0x33f633=_0x20f8e9['get']({'plain':!![]});var _0x69fb42=[{'name':_0x3a42('0x59'),'value':_0x3a42('0x2d')},{'name':_0x3a42('0x2e'),'value':_0x3a42('0x2f')}];var _0x46a14d=_[_0x3a42('0x35')](_0x69fb42,['value',_0x33f633[_0x3a42('0x34')]])[_0x3a42('0x36')];return db['UserProfileSection'][_0x3a42('0x35')]({'where':{'name':_0x46a14d,'userProfileId':_0x5986fc[_0x3a42('0x61')]},'raw':!![]})['then'](function(_0x3126a1){if(_0x3126a1&&_0x3126a1[_0x3a42('0x5b')]===0x0){return db[_0x3a42('0x37')][_0x3a42('0x54')]({'name':_0x33f633[_0x3a42('0x36')],'resourceId':_0x33f633['id'],'type':_0x3126a1['name'],'sectionId':_0x3126a1['id']},{})['then'](function(){return _0x20f8e9;});}else{return _0x20f8e9;}})[_0x3a42('0x50')](function(_0x248bb9){logger[_0x3a42('0x39')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x248bb9);throw _0x248bb9;});}return _0x20f8e9;});}})['then'](respondWithResult(_0xc2e895,0xc9))['catch'](handleError(_0xc2e895,null));};exports[_0x3a42('0x2b')]=function(_0x560e3c,_0x263559){if(_0x560e3c['body']['id']){delete _0x560e3c[_0x3a42('0x55')]['id'];}return db['VoiceQueue']['find']({'where':{'id':_0x560e3c[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0x263559,null))[_0x3a42('0x2c')](saveUpdates(_0x560e3c['body'],null))['then'](respondWithResult(_0x263559,null))[_0x3a42('0x50')](handleError(_0x263559,null));};exports[_0x3a42('0x38')]=function(_0x23c72c,_0x3739fa){return db['VoiceQueue'][_0x3a42('0x35')]({'where':{'id':_0x23c72c[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x3739fa,null))['then'](removeEntity(_0x3739fa,null))[_0x3a42('0x50')](handleError(_0x3739fa,null));};exports[_0x3a42('0x62')]=function(_0x4b322a,_0xb12ea1,_0x3212b7){var _0x15648d={'raw':![],'where':{}};var _0x2e2e38={};var _0x317061={'count':0x0,'rows':[]};return db[_0x3a42('0x3a')]['findOne']({'where':{'id':_0x4b322a[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0xb12ea1,null))[_0x3a42('0x2c')](function(_0x189f96){if(_0x189f96){_0x2e2e38['model']=_[_0x3a42('0x3f')](db['CmHopper'][_0x3a42('0x3b')]);_0x2e2e38[_0x3a42('0x42')]=_[_0x3a42('0x3f')](_0x4b322a[_0x3a42('0x42')]);_0x2e2e38['filters']=_[_0x3a42('0x41')](_0x2e2e38[_0x3a42('0x3e')],_0x2e2e38[_0x3a42('0x42')]);_0x15648d['attributes']=_[_0x3a42('0x41')](_0x2e2e38[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x4b322a[_0x3a42('0x42')][_0x3a42('0x44')]));_0x15648d[_0x3a42('0x43')]=_0x15648d['attributes'][_0x3a42('0x45')]?_0x15648d[_0x3a42('0x43')]:_0x2e2e38['model'];if(!_0x4b322a[_0x3a42('0x42')][_0x3a42('0x46')](_0x3a42('0x63'))){_0x15648d[_0x3a42('0x22')]=qs['limit'](_0x4b322a[_0x3a42('0x42')][_0x3a42('0x22')]);_0x15648d[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x4b322a[_0x3a42('0x42')][_0x3a42('0x21')]);}_0x15648d[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x4b322a[_0x3a42('0x42')][_0x3a42('0x47')]);_0x15648d['where']=qs[_0x3a42('0x40')](_['pick'](_0x4b322a[_0x3a42('0x42')],_0x2e2e38['filters']));_0x15648d[_0x3a42('0x48')][_0x3a42('0x65')]=_0x189f96['id'];if(_0x4b322a[_0x3a42('0x42')]['filter']){_0x15648d[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x15648d[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x15648d[_0x3a42('0x43')],function(_0x7ba739){var _0x8bcc02={};_0x8bcc02[_0x7ba739]={'$like':'%'+_0x4b322a['query'][_0x3a42('0x30')]+'%'};return _0x8bcc02;})});}_0x15648d=_[_0x3a42('0x4c')]({},_0x15648d,_0x4b322a['options']);return db[_0x3a42('0x66')][_0x3a42('0x24')]({'where':_0x15648d[_0x3a42('0x48')]})['then'](function(_0x1ea0b3){_0x317061[_0x3a42('0x24')]=_0x1ea0b3;if(_0x4b322a[_0x3a42('0x42')][_0x3a42('0x4d')]){_0x15648d['include']=[{'all':!![]}];}return db[_0x3a42('0x66')][_0x3a42('0x4e')](_0x15648d);})[_0x3a42('0x2c')](function(_0x118d23){_0x317061['rows']=_0x118d23;return _0x317061;});}})[_0x3a42('0x2c')](respondWithFilteredResult(_0xb12ea1,_0x15648d))[_0x3a42('0x50')](handleError(_0xb12ea1,null));};exports[_0x3a42('0x67')]=function(_0x1d9b25,_0x397dba,_0x17b306){var _0x2cd983={'raw':!![],'where':{}};var _0x1337e1={};var _0x31bd65={'count':0x0,'rows':[]};return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x1d9b25[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x397dba,null))[_0x3a42('0x2c')](function(_0x54150c){if(_0x54150c){_0x1337e1[_0x3a42('0x3e')]=_['keys'](db[_0x3a42('0x69')][_0x3a42('0x3b')]);_0x1337e1[_0x3a42('0x42')]=_['keys'](_0x1d9b25['query']);_0x1337e1[_0x3a42('0x40')]=_['intersection'](_0x1337e1[_0x3a42('0x3e')],_0x1337e1[_0x3a42('0x42')]);_0x2cd983[_0x3a42('0x43')]=_['intersection'](_0x1337e1[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x1d9b25['query'][_0x3a42('0x44')]));_0x2cd983['attributes']=_0x2cd983[_0x3a42('0x43')][_0x3a42('0x45')]?_0x2cd983[_0x3a42('0x43')]:_0x1337e1[_0x3a42('0x3e')];if(!_0x1d9b25[_0x3a42('0x42')][_0x3a42('0x46')]('nolimit')){_0x2cd983['limit']=qs[_0x3a42('0x22')](_0x1d9b25['query'][_0x3a42('0x22')]);_0x2cd983['offset']=qs['offset'](_0x1d9b25[_0x3a42('0x42')]['offset']);}_0x2cd983['order']=qs[_0x3a42('0x47')](_0x1d9b25[_0x3a42('0x42')][_0x3a42('0x47')]);_0x2cd983[_0x3a42('0x48')]=qs['filters'](_['pick'](_0x1d9b25[_0x3a42('0x42')],_0x1337e1[_0x3a42('0x40')]));_0x2cd983['where']['VoiceQueueId']=_0x54150c['id'];if(_0x1d9b25[_0x3a42('0x42')][_0x3a42('0x30')]){_0x2cd983[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x2cd983[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x2cd983['attributes'],function(_0x49779b){var _0x108185={};_0x108185[_0x49779b]={'$like':'%'+_0x1d9b25[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x108185;})});}_0x2cd983=_[_0x3a42('0x4c')]({},_0x2cd983,_0x1d9b25['options']);return db[_0x3a42('0x69')][_0x3a42('0x24')]({'where':_0x2cd983['where']})[_0x3a42('0x2c')](function(_0x2fcec5){_0x31bd65[_0x3a42('0x24')]=_0x2fcec5;if(_0x1d9b25[_0x3a42('0x42')]['includeAll']){_0x2cd983[_0x3a42('0x5d')]=[{'all':!![]}];}return db[_0x3a42('0x69')][_0x3a42('0x4e')](_0x2cd983);})['then'](function(_0x42b76f){_0x31bd65[_0x3a42('0x4f')]=_0x42b76f;return _0x31bd65;});}})['then'](respondWithFilteredResult(_0x397dba,_0x2cd983))[_0x3a42('0x50')](handleError(_0x397dba,null));};exports[_0x3a42('0x6a')]=function(_0x42919f,_0x4b8010,_0x376fe7){var _0x48ea2f={'raw':!![],'where':{}};var _0x35b712={};var _0xcce2d1={'count':0x0,'rows':[]};return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x42919f[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x4b8010,null))[_0x3a42('0x2c')](function(_0x173af8){if(_0x173af8){_0x35b712[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db[_0x3a42('0x6b')][_0x3a42('0x3b')]);_0x35b712[_0x3a42('0x42')]=_[_0x3a42('0x3f')](_0x42919f[_0x3a42('0x42')]);_0x35b712[_0x3a42('0x40')]=_['intersection'](_0x35b712['model'],_0x35b712['query']);_0x48ea2f[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0x35b712[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x42919f[_0x3a42('0x42')][_0x3a42('0x44')]));_0x48ea2f[_0x3a42('0x43')]=_0x48ea2f[_0x3a42('0x43')][_0x3a42('0x45')]?_0x48ea2f[_0x3a42('0x43')]:_0x35b712[_0x3a42('0x3e')];if(!_0x42919f[_0x3a42('0x42')][_0x3a42('0x46')](_0x3a42('0x63'))){_0x48ea2f[_0x3a42('0x22')]=qs[_0x3a42('0x22')](_0x42919f['query'][_0x3a42('0x22')]);_0x48ea2f[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x42919f[_0x3a42('0x42')][_0x3a42('0x21')]);}_0x48ea2f[_0x3a42('0x64')]=qs['sort'](_0x42919f[_0x3a42('0x42')][_0x3a42('0x47')]);_0x48ea2f[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x42919f[_0x3a42('0x42')],_0x35b712[_0x3a42('0x40')]));_0x48ea2f[_0x3a42('0x48')][_0x3a42('0x65')]=_0x173af8['id'];if(_0x42919f['query'][_0x3a42('0x30')]){_0x48ea2f[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x48ea2f[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x48ea2f['attributes'],function(_0x19d7b6){var _0x3619ba={};_0x3619ba[_0x19d7b6]={'$like':'%'+_0x42919f[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x3619ba;})});}_0x48ea2f=_[_0x3a42('0x4c')]({},_0x48ea2f,_0x42919f[_0x3a42('0x53')]);return db[_0x3a42('0x6b')]['count']({'where':_0x48ea2f['where']})['then'](function(_0x55a39a){_0xcce2d1[_0x3a42('0x24')]=_0x55a39a;if(_0x42919f['query'][_0x3a42('0x4d')]){_0x48ea2f[_0x3a42('0x5d')]=[{'all':!![]}];}return db[_0x3a42('0x6b')]['findAll'](_0x48ea2f);})[_0x3a42('0x2c')](function(_0x3afa2c){_0xcce2d1[_0x3a42('0x4f')]=_0x3afa2c;return _0xcce2d1;});}})['then'](respondWithFilteredResult(_0x4b8010,_0x48ea2f))['catch'](handleError(_0x4b8010,null));};exports['getHopperBlacks']=function(_0x343105,_0x581854,_0x41ff50){var _0x506259={'raw':!![],'where':{}};var _0x23f119={};var _0x27e6f5={'count':0x0,'rows':[]};return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x343105['params']['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x581854,null))[_0x3a42('0x2c')](function(_0x4ff6c4){if(_0x4ff6c4){_0x23f119[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db['CmHopperBlack'][_0x3a42('0x3b')]);_0x23f119['query']=_[_0x3a42('0x3f')](_0x343105['query']);_0x23f119['filters']=_[_0x3a42('0x41')](_0x23f119[_0x3a42('0x3e')],_0x23f119[_0x3a42('0x42')]);_0x506259[_0x3a42('0x43')]=_['intersection'](_0x23f119[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x343105['query'][_0x3a42('0x44')]));_0x506259['attributes']=_0x506259[_0x3a42('0x43')][_0x3a42('0x45')]?_0x506259[_0x3a42('0x43')]:_0x23f119[_0x3a42('0x3e')];if(!_0x343105['query'][_0x3a42('0x46')](_0x3a42('0x63'))){_0x506259['limit']=qs[_0x3a42('0x22')](_0x343105['query'][_0x3a42('0x22')]);_0x506259[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x343105['query']['offset']);}_0x506259[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x343105['query'][_0x3a42('0x47')]);_0x506259[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_['pick'](_0x343105[_0x3a42('0x42')],_0x23f119[_0x3a42('0x40')]));_0x506259[_0x3a42('0x48')]['VoiceQueueId']=_0x4ff6c4['id'];if(_0x343105[_0x3a42('0x42')]['filter']){_0x506259['where']=_[_0x3a42('0x4c')](_0x506259['where'],{'$or':_[_0x3a42('0x4a')](_0x506259['attributes'],function(_0x29dd77){var _0x2f59df={};_0x2f59df[_0x29dd77]={'$like':'%'+_0x343105[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x2f59df;})});}_0x506259=_[_0x3a42('0x4c')]({},_0x506259,_0x343105[_0x3a42('0x53')]);return db[_0x3a42('0x6c')][_0x3a42('0x24')]({'where':_0x506259[_0x3a42('0x48')]})['then'](function(_0x5301da){_0x27e6f5[_0x3a42('0x24')]=_0x5301da;if(_0x343105[_0x3a42('0x42')][_0x3a42('0x4d')]){_0x506259['include']=[{'all':!![]}];}return db[_0x3a42('0x6c')][_0x3a42('0x4e')](_0x506259);})[_0x3a42('0x2c')](function(_0x949b84){_0x27e6f5[_0x3a42('0x4f')]=_0x949b84;return _0x27e6f5;});}})[_0x3a42('0x2c')](respondWithFilteredResult(_0x581854,_0x506259))['catch'](handleError(_0x581854,null));};exports[_0x3a42('0x6d')]=function(_0x544488,_0xbb3e8c,_0x5932e9){var _0x33b32f={};var _0x402b51={};var _0x22b9a3;var _0x1415c6;return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x544488[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0xbb3e8c,null))[_0x3a42('0x2c')](function(_0x1ce88a){if(_0x1ce88a){_0x22b9a3=_0x1ce88a;_0x402b51['model']=_['keys'](db[_0x3a42('0x6e')][_0x3a42('0x3b')]);_0x402b51[_0x3a42('0x42')]=_[_0x3a42('0x3f')](_0x544488[_0x3a42('0x42')]);_0x402b51['filters']=_[_0x3a42('0x41')](_0x402b51[_0x3a42('0x3e')],_0x402b51['query']);_0x33b32f[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0x402b51['model'],qs[_0x3a42('0x44')](_0x544488[_0x3a42('0x42')][_0x3a42('0x44')]));_0x33b32f[_0x3a42('0x43')]=_0x33b32f['attributes']['length']?_0x33b32f[_0x3a42('0x43')]:_0x402b51[_0x3a42('0x3e')];_0x33b32f['order']=qs['sort'](_0x544488['query']['sort']);_0x33b32f['where']=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x544488[_0x3a42('0x42')],_0x402b51[_0x3a42('0x40')]));if(_0x544488[_0x3a42('0x42')][_0x3a42('0x30')]){_0x33b32f[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x33b32f[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x33b32f[_0x3a42('0x43')],function(_0x2725c4){var _0x30a696={};_0x30a696[_0x2725c4]={'$like':'%'+_0x544488[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x30a696;})});}_0x33b32f=_[_0x3a42('0x4c')]({},_0x33b32f,_0x544488[_0x3a42('0x53')]);return _0x22b9a3[_0x3a42('0x6d')](_0x33b32f);}})[_0x3a42('0x2c')](function(_0x2bb8d0){if(_0x2bb8d0){_0x1415c6=_0x2bb8d0[_0x3a42('0x45')];if(!_0x544488['query']['hasOwnProperty'](_0x3a42('0x63'))){_0x33b32f[_0x3a42('0x22')]=qs[_0x3a42('0x22')](_0x544488['query'][_0x3a42('0x22')]);_0x33b32f[_0x3a42('0x21')]=qs['offset'](_0x544488[_0x3a42('0x42')][_0x3a42('0x21')]);}return _0x22b9a3[_0x3a42('0x6d')](_0x33b32f);}})[_0x3a42('0x2c')](function(_0x194415){if(_0x194415){return _0x194415?{'count':_0x1415c6,'rows':_0x194415}:null;}})[_0x3a42('0x2c')](respondWithResult(_0xbb3e8c,null))['catch'](handleError(_0xbb3e8c,null));};exports['addTeams']=function(_0x3dd02a,_0x1a0144,_0x27ebcf){var _0x41987b=_0x3dd02a[_0x3a42('0x55')][_0x3a42('0x6f')];var _0x51da2b=_['map'](_0x41987b,'id');return db[_0x3a42('0x6e')][_0x3a42('0x4e')]({'where':{'id':_0x51da2b},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id','name',_0x3a42('0x70'),_0x3a42('0x71'),_0x3a42('0x72')],'raw':!![]}]})[_0x3a42('0x2c')](function(_0x35d355){if(_0x35d355){var _0x277478=_['flatMap'](_0x35d355,function(_0x42a2b7){var _0xbc102b=_0x42a2b7[_0x3a42('0x57')]({'plain':!![]});_0xbc102b[_0x3a42('0x73')][_0x3a42('0x74')](function(_0x2ec4d0){_0x2ec4d0[_0x3a42('0x75')]=_[_0x3a42('0x35')](_0x41987b,{'id':_0xbc102b['id']})['penalty'];});return _0xbc102b[_0x3a42('0x73')];});return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x3dd02a['params']['id']}})[_0x3a42('0x2c')](function(_0x76b1ef){return db[_0x3a42('0x76')][_0x3a42('0x77')](function(_0x1663df){return _0x76b1ef[_0x3a42('0x78')](_0x51da2b,{'transaction':_0x1663df})[_0x3a42('0x2c')](function(){return BPromise[_0x3a42('0x79')](_0x41987b,function(_0x553b3c){return db[_0x3a42('0x7a')][_0x3a42('0x7b')]({'TeamId':_0x553b3c['id'],'VoiceQueueId':_0x3dd02a[_0x3a42('0x52')]['id'],'penalty':_0x553b3c[_0x3a42('0x75')]},{'transaction':_0x1663df});});})['then'](function(){return BPromise[_0x3a42('0x79')](_0x277478,function(_0x241a20){return db[_0x3a42('0x7c')][_0x3a42('0x7d')]({'where':{'UserId':_0x241a20['id'],'VoiceQueueId':_0x3dd02a[_0x3a42('0x52')]['id']},'defaults':{'penalty':_0x241a20[_0x3a42('0x75')]},'transaction':_0x1663df});});})[_0x3a42('0x2c')](function(){return BPromise[_0x3a42('0x79')](_[_0x3a42('0x30')](_0x277478,{'online':!![]}),function(_0x47d5ed){return db[_0x3a42('0x7e')][_0x3a42('0x7b')]({'membername':_0x47d5ed['name'],'UserId':_0x47d5ed['id'],'queue_name':_0x76b1ef[_0x3a42('0x36')],'VoiceQueueId':_0x76b1ef['id'],'interface':_[_0x3a42('0x7f')](_0x47d5ed[_0x3a42('0x72')])?util[_0x3a42('0x80')](_0x3a42('0x81'),_0x47d5ed['name']):_0x47d5ed[_0x3a42('0x72')],'paused':_0x47d5ed[_0x3a42('0x71')]||![],'penalty':_0x47d5ed[_0x3a42('0x75')]},{'transaction':_0x1663df});});})[_0x3a42('0x2c')](function(){_0x277478[_0x3a42('0x74')](function(_0x200c91){socket[_0x3a42('0x82')](_0x3a42('0x83'),{'UserId':_0x200c91['id'],'VoiceQueueId':_0x76b1ef['id']});});});});});}})['then'](respondWithStatusCode(_0x1a0144,null))['catch'](handleError(_0x1a0144,null));};exports[_0x3a42('0x84')]=function(_0x4505cc,_0x1289bc,_0x5cab4b){return db[_0x3a42('0x6e')][_0x3a42('0x4e')]({'where':{'id':_0x4505cc[_0x3a42('0x42')][_0x3a42('0x85')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0x3a42('0x73'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x1289bc,null))[_0x3a42('0x2c')](function(_0x3f7b3f){var _0x23faba=_['map'](_0x3f7b3f,'id');var _0x398ffa=[];var _0x1b57b4=[];var _0x178500=squel[_0x3a42('0x86')]();_0x178500['field']('tq.TeamId')[_0x3a42('0x87')](_0x3a42('0x88'),'tq')[_0x3a42('0x89')](_0x3a42('0x8a'),'ut',_0x3a42('0x8b'))['where'](_0x3a42('0x8c'),_0x4505cc['params']['id']);for(var _0x3d19f9=0x0;_0x3d19f9<_0x3f7b3f[_0x3a42('0x45')];_0x3d19f9+=0x1){let _0x5457d1=_0x3f7b3f[_0x3d19f9];for(var _0x149e12=0x0;_0x149e12<_0x5457d1[_0x3a42('0x73')][_0x3a42('0x45')];_0x149e12+=0x1){let _0x265427=_0x5457d1[_0x3a42('0x73')][_0x149e12];var _0x54eaa8=_0x178500['clone']();_0x54eaa8[_0x3a42('0x48')]('ut.UserId\x20=\x20?',_0x265427['id']);_0x1b57b4['push'](db['sequelize'][_0x3a42('0x42')](_0x54eaa8['toString'](),{'type':db[_0x3a42('0x76')][_0x3a42('0x8d')][_0x3a42('0x8e')]})[_0x3a42('0x2c')](function(_0xf22c9c){if(_0xf22c9c['length']===0x1){return _0x265427['id'];}else{var _0x3a605c=_[_0x3a42('0x8f')](_[_0x3a42('0x4a')](_0xf22c9c,_0x3a42('0x90')),function(_0x311d24){return _[_0x3a42('0x33')](_0x23faba,_0x311d24);});if(_0x3a605c){return _0x265427['id'];}}}));}}return BPromise[_0x3a42('0x91')](_0x1b57b4)[_0x3a42('0x2c')](function(_0x168e97){_0x398ffa=_(_0x398ffa)['union'](_0x168e97)[_0x3a42('0x92')]()[_0x3a42('0x32')]();return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x4505cc['params']['id']}})[_0x3a42('0x2c')](function(_0x53117c){return db[_0x3a42('0x76')][_0x3a42('0x77')](function(_0x30ffdf){return _0x53117c[_0x3a42('0x84')](_0x4505cc[_0x3a42('0x42')][_0x3a42('0x85')],{'transaction':_0x30ffdf})[_0x3a42('0x2c')](function(){if(!_[_0x3a42('0x93')](_0x398ffa)){return _0x53117c[_0x3a42('0x94')](_0x398ffa,{'transaction':_0x30ffdf})[_0x3a42('0x2c')](function(){return db[_0x3a42('0x7e')][_0x3a42('0x38')]({'where':{'VoiceQueueId':_0x4505cc[_0x3a42('0x52')]['id'],'UserId':_0x398ffa},'transaction':_0x30ffdf});});}})[_0x3a42('0x2c')](function(){_0x398ffa[_0x3a42('0x74')](function(_0x5e1368){socket[_0x3a42('0x82')](_0x3a42('0x95'),{'UserId':_0x5e1368,'VoiceQueueId':_0x53117c['id']});});});});});});})[_0x3a42('0x2c')](respondWithStatusCode(_0x1289bc,null))[_0x3a42('0x50')](handleError(_0x1289bc,null));};exports[_0x3a42('0x96')]=function(_0x56e035,_0x358938,_0xff006){var _0x259264,_0x11084e;return db['VoiceQueue'][_0x3a42('0x35')]({'where':{'id':_0x56e035[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x358938,null))['then'](function(_0x4faba7){if(_0x4faba7){_0x11084e=_0x4faba7;return _0x4faba7[_0x3a42('0x96')](_0x56e035[_0x3a42('0x55')][_0x3a42('0x85')],_[_0x3a42('0x5e')](_0x56e035[_0x3a42('0x55')],['ids','id'])||{})[_0x3a42('0x97')](function(_0x2549bc){for(var _0x5012a4=0x0;_0x5012a4<_0x56e035[_0x3a42('0x55')]['ids'][_0x3a42('0x45')];_0x5012a4+=0x1){socket[_0x3a42('0x82')]('userVoiceQueue:save',{'UserId':Number(_0x56e035[_0x3a42('0x55')][_0x3a42('0x85')][_0x5012a4]),'VoiceQueueId':Number(_0x56e035[_0x3a42('0x52')]['id'])});}return _0x2549bc;});}})[_0x3a42('0x2c')](function(_0x2429ed){_0x259264=_0x2429ed||[];if(_0x11084e){return db[_0x3a42('0x98')][_0x3a42('0x4e')]({'where':{'id':_0x56e035[_0x3a42('0x55')][_0x3a42('0x85')]},'attributes':['id',_0x3a42('0x36'),'online',_0x3a42('0x71'),_0x3a42('0x72')],'raw':!![]});}})[_0x3a42('0x2c')](function(_0x362369){if(!_[_0x3a42('0x93')](_0x362369)){var _0x113bfc=[];for(var _0x2ec996=0x0;_0x2ec996<_0x362369[_0x3a42('0x45')];_0x2ec996++){if(_0x362369[_0x2ec996][_0x3a42('0x70')]){_0x113bfc[_0x3a42('0x99')](db[_0x3a42('0x7e')][_0x3a42('0x7b')]({'membername':_0x362369[_0x2ec996][_0x3a42('0x36')],'UserId':_0x362369[_0x2ec996]['id'],'queue_name':_0x11084e[_0x3a42('0x36')],'VoiceQueueId':_0x11084e['id'],'interface':_[_0x3a42('0x7f')](_0x362369[_0x2ec996][_0x3a42('0x72')])?util['format'](_0x3a42('0x81'),_0x362369[_0x2ec996][_0x3a42('0x36')]):_0x362369[_0x2ec996][_0x3a42('0x72')],'paused':_0x362369[_0x2ec996]['voicePause']||![],'penalty':_0x56e035[_0x3a42('0x55')][_0x3a42('0x75')]||0x0}));}}return BPromise[_0x3a42('0x91')](_0x113bfc);}})[_0x3a42('0x2c')](function(){return _0x259264;})[_0x3a42('0x2c')](respondWithResult(_0x358938,null))[_0x3a42('0x50')](handleError(_0x358938,null));};exports[_0x3a42('0x94')]=function(_0x353b03,_0x20fc4a,_0xe62af3){return db['VoiceQueue']['find']({'where':{'id':_0x353b03[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x20fc4a,null))[_0x3a42('0x2c')](function(_0x1cb326){if(_0x1cb326){return _0x1cb326[_0x3a42('0x94')](_0x353b03[_0x3a42('0x42')][_0x3a42('0x85')])['then'](function(){if(_[_0x3a42('0x9a')](_0x353b03[_0x3a42('0x42')][_0x3a42('0x85')])){for(var _0x1f5bba=0x0;_0x1f5bba<_0x353b03['query'][_0x3a42('0x85')][_0x3a42('0x45')];_0x1f5bba+=0x1){socket['emit'](_0x3a42('0x95'),{'UserId':Number(_0x353b03[_0x3a42('0x42')][_0x3a42('0x85')][_0x1f5bba]),'VoiceQueueId':Number(_0x353b03[_0x3a42('0x52')]['id'])});}}else{socket['emit']('userVoiceQueue:remove',{'UserId':Number(_0x353b03['query'][_0x3a42('0x85')]),'VoiceQueueId':Number(_0x353b03[_0x3a42('0x52')]['id'])});}});}})[_0x3a42('0x2c')](function(_0xb75dc7){return db[_0x3a42('0x7e')][_0x3a42('0x38')]({'where':{'VoiceQueueId':_0x353b03[_0x3a42('0x52')]['id'],'UserId':_0x353b03[_0x3a42('0x42')][_0x3a42('0x85')]}})[_0x3a42('0x2c')](function(){return _0xb75dc7;});})[_0x3a42('0x2c')](respondWithStatusCode(_0x20fc4a,null))[_0x3a42('0x50')](handleError(_0x20fc4a,null));};exports[_0x3a42('0x9b')]=function(_0x25a590,_0x2e8847,_0x4e881a){var _0x5a076d={};var _0x221dde={};var _0x547949;var _0x2e1d79;return db['VoiceQueue'][_0x3a42('0x68')]({'where':{'id':_0x25a590[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x2e8847,null))[_0x3a42('0x2c')](function(_0x43324c){if(_0x43324c){_0x547949=_0x43324c;_0x221dde[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db['User'][_0x3a42('0x3b')]);_0x221dde[_0x3a42('0x42')]=_['keys'](_0x25a590[_0x3a42('0x42')]);_0x221dde[_0x3a42('0x40')]=_[_0x3a42('0x41')](_0x221dde['model'],_0x221dde[_0x3a42('0x42')]);_0x5a076d['attributes']=_[_0x3a42('0x41')](_0x221dde[_0x3a42('0x3e')],qs['fields'](_0x25a590['query']['fields']));_0x5a076d[_0x3a42('0x43')]=_0x5a076d[_0x3a42('0x43')]['length']?_0x5a076d[_0x3a42('0x43')]:_0x221dde[_0x3a42('0x3e')];_0x5a076d[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x25a590[_0x3a42('0x42')][_0x3a42('0x47')]);_0x5a076d['where']=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x25a590[_0x3a42('0x42')],_0x221dde[_0x3a42('0x40')]));if(_0x25a590[_0x3a42('0x42')]['filter']){_0x5a076d['where']=_[_0x3a42('0x4c')](_0x5a076d[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x5a076d[_0x3a42('0x43')],function(_0x4e3238){var _0x3bbe75={};_0x3bbe75[_0x4e3238]={'$like':'%'+_0x25a590[_0x3a42('0x42')]['filter']+'%'};return _0x3bbe75;})});}_0x5a076d=_[_0x3a42('0x4c')]({},_0x5a076d,_0x25a590[_0x3a42('0x53')]);return _0x547949['getAgents'](_0x5a076d);}})['then'](function(_0x508921){if(_0x508921){_0x2e1d79=_0x508921[_0x3a42('0x45')];if(!_0x25a590[_0x3a42('0x42')]['hasOwnProperty'](_0x3a42('0x63'))){_0x5a076d[_0x3a42('0x22')]=qs[_0x3a42('0x22')](_0x25a590[_0x3a42('0x42')]['limit']);_0x5a076d[_0x3a42('0x21')]=qs['offset'](_0x25a590['query'][_0x3a42('0x21')]);}return _0x547949['getAgents'](_0x5a076d);}})[_0x3a42('0x2c')](function(_0x3cd547){if(_0x3cd547){return _0x3cd547?{'count':_0x2e1d79,'rows':_0x3cd547}:null;}})[_0x3a42('0x2c')](respondWithResult(_0x2e8847,null))[_0x3a42('0x50')](handleError(_0x2e8847,null));};exports[_0x3a42('0x9c')]=function(_0x46cd40,_0x1c2f79,_0x5029d1){var _0x250159={};var _0x1fc928={};var _0x599932;var _0x8b81f0;return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x46cd40[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x1c2f79,null))[_0x3a42('0x2c')](function(_0x1a6dc0){if(_0x1a6dc0){_0x599932=_0x1a6dc0;_0x1fc928['model']=_[_0x3a42('0x3f')](db[_0x3a42('0x7e')][_0x3a42('0x3b')]);_0x1fc928[_0x3a42('0x42')]=_[_0x3a42('0x3f')](_0x46cd40['query']);_0x1fc928['filters']=_[_0x3a42('0x41')](_0x1fc928[_0x3a42('0x3e')],_0x1fc928[_0x3a42('0x42')]);_0x250159[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0x1fc928[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x46cd40['query']['fields']));_0x250159[_0x3a42('0x43')]=_0x250159[_0x3a42('0x43')][_0x3a42('0x45')]?_0x250159[_0x3a42('0x43')]:_0x1fc928[_0x3a42('0x3e')];_0x250159[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x46cd40[_0x3a42('0x42')]['sort']);_0x250159[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x46cd40[_0x3a42('0x42')],_0x1fc928[_0x3a42('0x40')]));if(_0x46cd40[_0x3a42('0x42')][_0x3a42('0x30')]){_0x250159[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x250159['where'],{'$or':_[_0x3a42('0x4a')](_0x250159[_0x3a42('0x43')],function(_0x437e31){var _0x474c89={};_0x474c89[_0x437e31]={'$like':'%'+_0x46cd40[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x474c89;})});}_0x250159=_[_0x3a42('0x4c')]({},_0x250159,_0x46cd40[_0x3a42('0x53')]);return _0x599932[_0x3a42('0x9c')](_0x250159);}})[_0x3a42('0x2c')](function(_0x1deb32){if(_0x1deb32){_0x8b81f0=_0x1deb32[_0x3a42('0x45')];if(!_0x46cd40[_0x3a42('0x42')][_0x3a42('0x46')](_0x3a42('0x63'))){_0x250159['limit']=qs[_0x3a42('0x22')](_0x46cd40[_0x3a42('0x42')][_0x3a42('0x22')]);_0x250159[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x46cd40['query'][_0x3a42('0x21')]);}return _0x599932[_0x3a42('0x9c')](_0x250159);}})[_0x3a42('0x2c')](function(_0x4ef7b3){return _0x4ef7b3?{'count':_0x8b81f0,'rows':_0x4ef7b3}:null;})[_0x3a42('0x2c')](respondWithResult(_0x1c2f79,null))[_0x3a42('0x50')](handleError(_0x1c2f79,null));};exports[_0x3a42('0x9d')]=function(_0x44f0c2,_0x55a346,_0x28a7a7){var _0x20d04d={};var _0x51eb31={};var _0x206acd;var _0x47424d;return db[_0x3a42('0x3a')]['findOne']({'where':{'id':_0x44f0c2[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0x55a346,null))['then'](function(_0x4fe380){if(_0x4fe380){_0x206acd=_0x4fe380;_0x51eb31[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db[_0x3a42('0x9e')][_0x3a42('0x3b')]);_0x51eb31['query']=_[_0x3a42('0x3f')](_0x44f0c2[_0x3a42('0x42')]);_0x51eb31[_0x3a42('0x40')]=_[_0x3a42('0x41')](_0x51eb31[_0x3a42('0x3e')],_0x51eb31[_0x3a42('0x42')]);_0x20d04d[_0x3a42('0x43')]=_['intersection'](_0x51eb31[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x44f0c2[_0x3a42('0x42')]['fields']));_0x20d04d[_0x3a42('0x43')]=_0x20d04d[_0x3a42('0x43')][_0x3a42('0x45')]?_0x20d04d[_0x3a42('0x43')]:_0x51eb31[_0x3a42('0x3e')];_0x20d04d[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x44f0c2['query'][_0x3a42('0x47')]);_0x20d04d[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_['pick'](_0x44f0c2[_0x3a42('0x42')],_0x51eb31['filters']));if(_0x44f0c2['query']['filter']){_0x20d04d[_0x3a42('0x48')]=_['merge'](_0x20d04d[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x20d04d['attributes'],function(_0x1f83ec){var _0x3cc23c={};_0x3cc23c[_0x1f83ec]={'$like':'%'+_0x44f0c2[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x3cc23c;})});}_0x20d04d=_[_0x3a42('0x4c')]({},_0x20d04d,_0x44f0c2[_0x3a42('0x53')]);return _0x206acd[_0x3a42('0x9d')](_0x20d04d);}})['then'](function(_0x17b056){if(_0x17b056){_0x47424d=_0x17b056[_0x3a42('0x45')];if(!_0x44f0c2[_0x3a42('0x42')]['hasOwnProperty'](_0x3a42('0x63'))){_0x20d04d['limit']=qs[_0x3a42('0x22')](_0x44f0c2[_0x3a42('0x42')][_0x3a42('0x22')]);_0x20d04d[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x44f0c2['query'][_0x3a42('0x21')]);}return _0x206acd[_0x3a42('0x9d')](_0x20d04d);}})[_0x3a42('0x2c')](function(_0x1c946e){if(_0x1c946e){return _0x1c946e?{'count':_0x47424d,'rows':_0x1c946e}:null;}})['then'](respondWithResult(_0x55a346,null))[_0x3a42('0x50')](handleError(_0x55a346,null));};exports[_0x3a42('0x9f')]=function(_0x4369cc,_0x38d045,_0x286102){var _0x51323d=moment()['format'](_0x3a42('0xa0'));var _0x404f0c,_0x1cefc7;return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x4369cc[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0x38d045,null))['then'](function(_0x1657a2){if(_0x1657a2){_0x1cefc7=_0x1657a2;return _0x1657a2[_0x3a42('0x9f')](_0x4369cc[_0x3a42('0x55')][_0x3a42('0x85')],_[_0x3a42('0x5e')](_0x4369cc['body'],[_0x3a42('0x85'),'id'])||{});}return null;})[_0x3a42('0x97')](function(_0x293f46){var _0x382156;_0x404f0c=_0x293f46||[];var _0x492a92=[];if(_0x293f46){for(var _0x2e8d4c=0x0;_0x2e8d4c<_0x293f46['length'];_0x2e8d4c+=0x1){var _0x313c81=_0x293f46[_0x2e8d4c][_0x3a42('0x57')]({'plain':!![]});_0x1cefc7[_0x3a42('0xa1')]=_0x4369cc['body'][_0x3a42('0xa1')]?_0x4369cc[_0x3a42('0x55')][_0x3a42('0xa1')]:_0x1cefc7[_0x3a42('0xa1')];switch(_0x1cefc7[_0x3a42('0xa1')]){case'always':_0x382156=squel[_0x3a42('0xa2')]()['into'](_0x3a42('0xa3'))[_0x3a42('0xa4')]([_0x3a42('0xa5'),_0x3a42('0xa6'),_0x3a42('0xa7'),_0x3a42('0xa8'),'VoiceQueueId',_0x3a42('0x5f'),_0x3a42('0x60')],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xa5'),'phone')[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0xa6'))[_0x3a42('0xa9')]('id',_0x3a42('0xa7'))[_0x3a42('0xa9')](_0x313c81[_0x3a42('0xaa')]['toString'](),_0x3a42('0xa8'))['field'](_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')](),_0x3a42('0x65'))['field']('\x27'+_0x51323d+'\x27',_0x3a42('0x5f'))[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0x60'))[_0x3a42('0x87')](_0x3a42('0xac'))['where']('deletedAt\x20IS\x20NULL')[_0x3a42('0x48')](_0x3a42('0xad'),_0x313c81[_0x3a42('0xaa')][_0x3a42('0xab')]())[_0x3a42('0x48')](_0x3a42('0xae'))[_0x3a42('0x48')](_0x3a42('0xaf'),squel[_0x3a42('0x86')]()['field']('COALESCE(calleridnum,\x27\x27)')['from'](_0x3a42('0xb0'))[_0x3a42('0x48')]('VoiceQueueId\x20=\x20?',_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')]()))[_0x3a42('0x48')](_0x3a42('0xaf'),squel['select']()[_0x3a42('0xa9')](_0x3a42('0xb1'))['from'](_0x3a42('0xa3'))[_0x3a42('0x48')]('VoiceQueueId\x20=\x20?',_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')]())))[_0x3a42('0xab')]();break;case _0x3a42('0xb2'):_0x382156=squel[_0x3a42('0xa2')]()[_0x3a42('0xb3')](_0x3a42('0xa3'))[_0x3a42('0xa4')](['phone',_0x3a42('0xa6'),_0x3a42('0xa7'),_0x3a42('0xa8'),_0x3a42('0x65'),'createdAt',_0x3a42('0x60')],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xa5'),_0x3a42('0xa5'))['field']('\x27'+_0x51323d+'\x27','scheduledAt')[_0x3a42('0xa9')]('id',_0x3a42('0xa7'))['field'](_0x313c81['CmListId'][_0x3a42('0xab')](),'ListId')[_0x3a42('0xa9')](_0x4369cc['params']['id'][_0x3a42('0xab')](),_0x3a42('0x65'))[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0x5f'))['field']('\x27'+_0x51323d+'\x27',_0x3a42('0x60'))[_0x3a42('0x87')](_0x3a42('0xac'))[_0x3a42('0x48')](_0x3a42('0xb4'))['where']('ListId\x20=\x20?',_0x313c81['CmListId'][_0x3a42('0xab')]())['where']('phone\x20IS\x20NOT\x20NULL')[_0x3a42('0x48')]('phone\x20NOT\x20IN\x20(?)',squel[_0x3a42('0x86')]()['field'](_0x3a42('0xb1'))[_0x3a42('0x87')](_0x3a42('0xa3'))[_0x3a42('0x48')](_0x3a42('0x8c'),_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')]())))[_0x3a42('0xab')]();break;default:_0x382156=squel[_0x3a42('0xa2')]()[_0x3a42('0xb3')](_0x3a42('0xa3'))[_0x3a42('0xa4')]([_0x3a42('0xa5'),'scheduledAt','ContactId',_0x3a42('0xa8'),_0x3a42('0x65'),_0x3a42('0x5f'),'updatedAt'],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xa5'),_0x3a42('0xa5'))['field']('\x27'+_0x51323d+'\x27',_0x3a42('0xa6'))[_0x3a42('0xa9')]('id',_0x3a42('0xa7'))['field'](_0x313c81['CmListId']['toString'](),_0x3a42('0xa8'))[_0x3a42('0xa9')](_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')](),'VoiceQueueId')[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0x5f'))['field']('\x27'+_0x51323d+'\x27',_0x3a42('0x60'))['from'](_0x3a42('0xac'))['where'](_0x3a42('0xb4'))['where'](_0x3a42('0xad'),_0x313c81[_0x3a42('0xaa')][_0x3a42('0xab')]())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x3a42('0xab')]();}_0x492a92[_0x3a42('0x99')](db['sequelize'][_0x3a42('0x42')](_0x382156));}return BPromise[_0x3a42('0x91')](_0x492a92);}})[_0x3a42('0x2c')](function(){var _0x1bd1d2=[];var _0x15f99e=squel[_0x3a42('0xa2')]()[_0x3a42('0xb3')](_0x3a42('0xb5'))[_0x3a42('0xa4')](['CmHopperId',_0x3a42('0xa5'),'OrderBy',_0x3a42('0x5f'),_0x3a42('0x60')],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xb6'))['field'](_0x3a42('0xb7'))[_0x3a42('0xa9')](_0x3a42('0xb8'))[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0x5f'))[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27','updatedAt')[_0x3a42('0x87')]('cm_contact_has_items','ci')['join']('cm_hopper','h','h.ContactId=ci.CmContactId')[_0x3a42('0x48')]('h.scheduledat=?',_0x51323d)[_0x3a42('0x48')]('ci.ItemClass=?',_0x3a42('0xb9')))[_0x3a42('0xab')]();_0x1bd1d2['push'](db[_0x3a42('0x76')][_0x3a42('0x42')](_0x15f99e));return BPromise[_0x3a42('0x91')](_0x1bd1d2);})[_0x3a42('0x2c')](function(){return _0x404f0c;})[_0x3a42('0x2c')](respondWithResult(_0x38d045,null))[_0x3a42('0x50')](handleError(_0x38d045,null));};exports['removeLists']=function(_0x39bfdf,_0x26eccd,_0x5b4d89){return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x39bfdf[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0x26eccd,null))['then'](function(_0x57f5cd){if(_0x57f5cd){return _0x57f5cd['removeLists'](_0x39bfdf[_0x3a42('0x42')][_0x3a42('0x85')]);}})[_0x3a42('0x2c')](function(_0x121a00){if(_0x121a00){return db[_0x3a42('0x66')][_0x3a42('0x38')]({'where':{'ListId':_0x39bfdf[_0x3a42('0x42')][_0x3a42('0x85')],'VoiceQueueId':_0x39bfdf[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](function(){return _0x121a00;});}})[_0x3a42('0x2c')](respondWithStatusCode(_0x26eccd,null))[_0x3a42('0x50')](handleError(_0x26eccd,null));};exports[_0x3a42('0xba')]=function(_0x5d7b90,_0x2c8cdc,_0x92a168){var _0x8dcfd5={};var _0x50017d={};var _0x1aa408;var _0x356ac0;return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x5d7b90['params']['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x2c8cdc,null))[_0x3a42('0x2c')](function(_0x502890){if(_0x502890){_0x1aa408=_0x502890;_0x50017d[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db[_0x3a42('0x9e')]['rawAttributes']);_0x50017d[_0x3a42('0x42')]=_['keys'](_0x5d7b90['query']);_0x50017d[_0x3a42('0x40')]=_['intersection'](_0x50017d['model'],_0x50017d[_0x3a42('0x42')]);_0x8dcfd5[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0x50017d['model'],qs[_0x3a42('0x44')](_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x44')]));_0x8dcfd5[_0x3a42('0x43')]=_0x8dcfd5['attributes']['length']?_0x8dcfd5['attributes']:_0x50017d['model'];_0x8dcfd5[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x47')]);_0x8dcfd5[_0x3a42('0x48')]=qs['filters'](_[_0x3a42('0x49')](_0x5d7b90[_0x3a42('0x42')],_0x50017d[_0x3a42('0x40')]));if(_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x30')]){_0x8dcfd5[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x8dcfd5[_0x3a42('0x48')],{'$or':_['map'](_0x8dcfd5[_0x3a42('0x43')],function(_0x4bf34a){var _0x55d2c4={};_0x55d2c4[_0x4bf34a]={'$like':'%'+_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x55d2c4;})});}_0x8dcfd5=_[_0x3a42('0x4c')]({},_0x8dcfd5,_0x5d7b90['options']);return _0x1aa408[_0x3a42('0xba')](_0x8dcfd5);}})[_0x3a42('0x2c')](function(_0xe3fad2){if(_0xe3fad2){_0x356ac0=_0xe3fad2[_0x3a42('0x45')];if(!_0x5d7b90['query']['hasOwnProperty']('nolimit')){_0x8dcfd5[_0x3a42('0x22')]=qs['limit'](_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x22')]);_0x8dcfd5[_0x3a42('0x21')]=qs['offset'](_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x21')]);}return _0x1aa408[_0x3a42('0xba')](_0x8dcfd5);}})[_0x3a42('0x2c')](function(_0x4410c1){if(_0x4410c1){return _0x4410c1?{'count':_0x356ac0,'rows':_0x4410c1}:null;}})[_0x3a42('0x2c')](respondWithResult(_0x2c8cdc,null))[_0x3a42('0x50')](handleError(_0x2c8cdc,null));};exports[_0x3a42('0xbb')]=function(_0x13989b,_0x1127aa,_0x1a8917){var _0x2df895,_0x30a5ca;return db['VoiceQueue']['find']({'where':{'id':_0x13989b[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x1127aa,null))['then'](function(_0x1b10b9){if(_0x1b10b9){_0x30a5ca=_0x1b10b9;return _0x1b10b9[_0x3a42('0xbb')](_0x13989b[_0x3a42('0x55')]['ids'],_[_0x3a42('0x5e')](_0x13989b[_0x3a42('0x55')],[_0x3a42('0x85'),'id'])||{});}return null;})[_0x3a42('0x97')](function(_0x4c40e9){var _0x21cd17;_0x2df895=_0x4c40e9||[];var _0x57a9fc=[];if(_0x4c40e9){for(var _0x1d828b=0x0;_0x1d828b<_0x4c40e9[_0x3a42('0x45')];_0x1d828b+=0x1){var _0x496ad4=_0x4c40e9[_0x1d828b][_0x3a42('0x57')]({'plain':!![]});_0x21cd17=squel[_0x3a42('0xa2')]()['into'](_0x3a42('0xbc'))[_0x3a42('0xa4')]([_0x3a42('0xa5'),_0x3a42('0xa7'),_0x3a42('0xa8'),_0x3a42('0x65'),_0x3a42('0x5f'),_0x3a42('0x60')],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xa5'),_0x3a42('0xa5'))[_0x3a42('0xa9')]('id','ContactId')[_0x3a42('0xa9')](_0x496ad4[_0x3a42('0xaa')][_0x3a42('0xab')](),_0x3a42('0xa8'))[_0x3a42('0xa9')](_0x13989b[_0x3a42('0x52')]['id']['toString'](),'VoiceQueueId')['field']('NOW()','createdAt')[_0x3a42('0xa9')](_0x3a42('0xbd'),'updatedAt')['from'](_0x3a42('0xac'))[_0x3a42('0x48')]('deletedAt\x20IS\x20NULL')[_0x3a42('0x48')](_0x3a42('0xad'),_0x496ad4[_0x3a42('0xaa')][_0x3a42('0xab')]())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x3a42('0xab')]();_0x57a9fc[_0x3a42('0x99')](db['sequelize']['query'](_0x21cd17));}return BPromise[_0x3a42('0x91')](_0x57a9fc);}})['then'](function(){return _0x2df895;})[_0x3a42('0x2c')](respondWithResult(_0x1127aa,null))[_0x3a42('0x50')](handleError(_0x1127aa,null));};exports[_0x3a42('0xbe')]=function(_0x5c866d,_0x4d2c6a,_0xb456c3){return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x5c866d['params']['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x4d2c6a,null))[_0x3a42('0x2c')](function(_0x568252){if(_0x568252){return _0x568252[_0x3a42('0xbe')](_0x5c866d[_0x3a42('0x42')][_0x3a42('0x85')]);}})[_0x3a42('0x2c')](function(_0x17cac7){if(_0x17cac7){return db[_0x3a42('0x6c')][_0x3a42('0x38')]({'where':{'ListId':_0x5c866d[_0x3a42('0x42')][_0x3a42('0x85')],'VoiceQueueId':_0x5c866d[_0x3a42('0x52')]['id']}})['then'](function(){return _0x17cac7;});}})[_0x3a42('0x2c')](respondWithStatusCode(_0x4d2c6a,null))[_0x3a42('0x50')](handleError(_0x4d2c6a,null));};
\ No newline at end of file
+var _0x3079=['UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','format','SIP/%s','forEach','emit','removeTeams','ids','select','field','tq.TeamId','from','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','every','TeamId','all','union','compact','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','userVoiceQueue:save','voicePause','isArray','getAgents','getMembers','getLists','CmList','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','scheduledAt','ContactId','phone','CmListId','ListId','cm_contacts','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','COALESCE(phone,\x27\x27)','onlyIfOpen','deletedAt\x20IS\x20NULL','cm_hopper_additional_phones','OrderBy','h.id','ci.item','ci.OrderBy+1','cm_contact_has_items','h.ContactId=ci.CmContactId','h.scheduledat=?','ci.ItemClass=?','PHONE','removeLists','CmHopper','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','sox','to-csv','ejs','fs-extra','lodash','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','redis','./voiceQueue.socket','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','destroy','then','get','VoiceQueues','QueueCampaigns','filter','ignore','value','type','name','UserProfileResource','end','error','stack','send','index','map','VoiceQueue','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','fields','nolimit','where','merge','options','includeAll','findAll','rows','catch','show','params','length','include','create','user','role','inbound','find','UserProfileSection','userProfileId','clone','omit','createdAt','updatedAt','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','findOne','order','sort','VoiceQueueId','getHopperHistories','CmHopperHistory','hasOwnProperty','pick','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','addTeams','Team','User','online','interface','Agents','penalty','sequelize','transaction','each','TeamVoiceQueue'];(function(_0x2e54bc,_0x304463){var _0x95de19=function(_0x46fbac){while(--_0x46fbac){_0x2e54bc['push'](_0x2e54bc['shift']());}};_0x95de19(++_0x304463);}(_0x3079,0x110));var _0x9307=function(_0x37c7a5,_0x1c901b){_0x37c7a5=_0x37c7a5-0x0;var _0x3ecbc7=_0x3079[_0x37c7a5];return _0x3ecbc7;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x9307('0x0'));var zipdir=require(_0x9307('0x1'));var jsonpatch=require(_0x9307('0x2'));var rp=require(_0x9307('0x3'));var moment=require('moment');var BPromise=require(_0x9307('0x4'));var Mustache=require(_0x9307('0x5'));var util=require('util');var path=require('path');var sox=require(_0x9307('0x6'));var csv=require(_0x9307('0x7'));var ejs=require(_0x9307('0x8'));var fs=require('fs');var fs_extra=require(_0x9307('0x9'));var _=require(_0x9307('0xa'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x9307('0xb'));var deskjs=require('desk.js');var toCsv=require(_0x9307('0x7'));var querystring=require(_0x9307('0xc'));var Papa=require('papaparse');var Redis=require(_0x9307('0xd'));var authService=require(_0x9307('0xe'));var qs=require(_0x9307('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x9307('0x10'))(_0x9307('0x11'));var utils=require(_0x9307('0x12'));var config=require(_0x9307('0x13'));var licenseUtil=require(_0x9307('0x14'));var db=require(_0x9307('0x15'))['db'];config['redis']=_[_0x9307('0x16')](config[_0x9307('0x17')],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x9307('0x17')]));require(_0x9307('0x18'))['register'](socket);function respondWithStatusCode(_0x3d9864,_0x4053e2){_0x4053e2=_0x4053e2||0xcc;return function(_0x545b0a){if(_0x545b0a){return _0x3d9864[_0x9307('0x19')](_0x4053e2);}return _0x3d9864[_0x9307('0x1a')](_0x4053e2)['end']();};}function respondWithResult(_0x3fc6fd,_0x4296e9){_0x4296e9=_0x4296e9||0xc8;return function(_0x100f15){if(_0x100f15){return _0x3fc6fd['status'](_0x4296e9)[_0x9307('0x1b')](_0x100f15);}};}function respondWithFilteredResult(_0x27682a,_0x503338){return function(_0xbba867){if(_0xbba867){var _0x3d84b0=typeof _0x503338[_0x9307('0x1c')]===_0x9307('0x1d')&&typeof _0x503338[_0x9307('0x1e')]===_0x9307('0x1d');var _0x5810d7=_0xbba867[_0x9307('0x1f')];var _0x10aa66=_0x3d84b0?0x0:_0x503338[_0x9307('0x1c')];var _0x58574e=_0x3d84b0?_0xbba867[_0x9307('0x1f')]:_0x503338[_0x9307('0x1c')]+_0x503338['limit'];var _0x307ab9;if(_0x58574e>=_0x5810d7){_0x58574e=_0x5810d7;_0x307ab9=0xc8;}else{_0x307ab9=0xce;}_0x27682a[_0x9307('0x1a')](_0x307ab9);return _0x27682a[_0x9307('0x20')](_0x9307('0x21'),_0x10aa66+'-'+_0x58574e+'/'+_0x5810d7)[_0x9307('0x1b')](_0xbba867);}return null;};}function patchUpdates(_0xf39222){return function(_0x1d671b){try{jsonpatch[_0x9307('0x22')](_0x1d671b,_0xf39222,!![]);}catch(_0x2f5f68){return BPromise[_0x9307('0x23')](_0x2f5f68);}return _0x1d671b[_0x9307('0x24')]();};}function saveUpdates(_0x5d42a0,_0x1e17c5){return function(_0x593f27){if(_0x593f27){return _0x593f27[_0x9307('0x25')](_0x5d42a0)['then'](function(_0x2c59ef){return _0x2c59ef;});}return null;};}function removeEntity(_0x5bb98a,_0x4d1a13){return function(_0x428043){if(_0x428043){return _0x428043[_0x9307('0x26')]()[_0x9307('0x27')](function(){var _0x330d48=_0x428043[_0x9307('0x28')]({'plain':!![]});var _0xd89e2f=[{'name':_0x9307('0x29'),'value':'inbound','ignore':![]},{'name':_0x9307('0x2a'),'value':'outbound','ignore':![]}];var _0x1da3e3=_(_0xd89e2f)[_0x9307('0x2b')](_0x9307('0x2c'))['map'](_0x9307('0x2d'))['value']();if(_['includes'](_0x1da3e3,_0x330d48['type'])){return;}var _0x27faa5=_['find'](_0xd89e2f,[_0x9307('0x2d'),_0x330d48[_0x9307('0x2e')]])[_0x9307('0x2f')];return db[_0x9307('0x30')][_0x9307('0x26')]({'where':{'type':_0x27faa5,'resourceId':_0x330d48['id']}})[_0x9307('0x27')](function(){return _0x428043;});})['then'](function(){_0x5bb98a[_0x9307('0x1a')](0xcc)[_0x9307('0x31')]();});}};}function handleEntityNotFound(_0x824001,_0x1f5ee1){return function(_0x34fa73){if(!_0x34fa73){_0x824001[_0x9307('0x19')](0x194);}return _0x34fa73;};}function handleError(_0x158145,_0x54ffa7){_0x54ffa7=_0x54ffa7||0x1f4;return function(_0x5b79da){logger[_0x9307('0x32')](_0x5b79da[_0x9307('0x33')]);if(_0x5b79da[_0x9307('0x2f')]){delete _0x5b79da[_0x9307('0x2f')];}_0x158145[_0x9307('0x1a')](_0x54ffa7)[_0x9307('0x34')](_0x5b79da);};}exports[_0x9307('0x35')]=function(_0x139c45,_0x8e2cb4){var _0x33a507={},_0x4df3a6={},_0x443d35={'count':0x0,'rows':[]};var _0x42595e=_[_0x9307('0x36')](db[_0x9307('0x37')][_0x9307('0x38')],function(_0x11d342){return{'name':_0x11d342[_0x9307('0x39')],'type':_0x11d342[_0x9307('0x2e')][_0x9307('0x3a')]};});_0x4df3a6[_0x9307('0x3b')]=_[_0x9307('0x36')](_0x42595e,_0x9307('0x2f'));_0x4df3a6[_0x9307('0x3c')]=_[_0x9307('0x3d')](_0x139c45['query']);_0x4df3a6[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x4df3a6[_0x9307('0x3b')],_0x4df3a6[_0x9307('0x3c')]);_0x33a507[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x4df3a6[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x139c45['query'][_0x9307('0x41')]));_0x33a507[_0x9307('0x40')]=_0x33a507[_0x9307('0x40')]['length']?_0x33a507[_0x9307('0x40')]:_0x4df3a6[_0x9307('0x3b')];if(!_0x139c45[_0x9307('0x3c')]['hasOwnProperty'](_0x9307('0x42'))){_0x33a507[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x139c45[_0x9307('0x3c')]['limit']);_0x33a507['offset']=qs[_0x9307('0x1c')](_0x139c45[_0x9307('0x3c')][_0x9307('0x1c')]);}_0x33a507['order']=qs['sort'](_0x139c45[_0x9307('0x3c')]['sort']);_0x33a507[_0x9307('0x43')]=qs[_0x9307('0x3e')](_['pick'](_0x139c45[_0x9307('0x3c')],_0x4df3a6[_0x9307('0x3e')]),_0x42595e);if(_0x139c45[_0x9307('0x3c')][_0x9307('0x2b')]){_0x33a507[_0x9307('0x43')]=_[_0x9307('0x44')](_0x33a507[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x42595e,function(_0x593a19){if(_0x593a19['type']!=='VIRTUAL'){var _0x274598={};_0x274598[_0x593a19[_0x9307('0x2f')]]={'$like':'%'+_0x139c45[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x274598;}})});}_0x33a507=_[_0x9307('0x44')]({},_0x33a507,_0x139c45[_0x9307('0x45')]);var _0x4fadc9={'where':_0x33a507['where']};return db[_0x9307('0x37')][_0x9307('0x1f')](_0x4fadc9)['then'](function(_0x1d24d3){_0x443d35['count']=_0x1d24d3;if(_0x139c45[_0x9307('0x3c')][_0x9307('0x46')]){_0x33a507['include']=[{'all':!![]}];}return db[_0x9307('0x37')][_0x9307('0x47')](_0x33a507);})[_0x9307('0x27')](function(_0x276ed5){_0x443d35[_0x9307('0x48')]=_0x276ed5;return _0x443d35;})[_0x9307('0x27')](respondWithFilteredResult(_0x8e2cb4,_0x33a507))[_0x9307('0x49')](handleError(_0x8e2cb4,null));};exports[_0x9307('0x4a')]=function(_0x57f146,_0x3ff0a4){var _0x2d2e5b={'raw':![],'where':{'id':_0x57f146[_0x9307('0x4b')]['id']}},_0x390eef={};_0x390eef[_0x9307('0x3b')]=_['keys'](db[_0x9307('0x37')]['rawAttributes']);_0x390eef['query']=_[_0x9307('0x3d')](_0x57f146[_0x9307('0x3c')]);_0x390eef[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x390eef[_0x9307('0x3b')],_0x390eef['query']);_0x2d2e5b[_0x9307('0x40')]=_['intersection'](_0x390eef[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x57f146['query']['fields']));_0x2d2e5b[_0x9307('0x40')]=_0x2d2e5b[_0x9307('0x40')][_0x9307('0x4c')]?_0x2d2e5b[_0x9307('0x40')]:_0x390eef[_0x9307('0x3b')];if(_0x57f146['query'][_0x9307('0x46')]){_0x2d2e5b[_0x9307('0x4d')]=[{'all':!![]}];}_0x2d2e5b=_[_0x9307('0x44')]({},_0x2d2e5b,_0x57f146[_0x9307('0x45')]);return db['VoiceQueue']['find'](_0x2d2e5b)['then'](handleEntityNotFound(_0x3ff0a4,null))[_0x9307('0x27')](respondWithResult(_0x3ff0a4,null))['catch'](handleError(_0x3ff0a4,null));};exports[_0x9307('0x4e')]=function(_0x5bb358,_0x6272c7){return db[_0x9307('0x37')][_0x9307('0x4e')](_0x5bb358['body'],{})[_0x9307('0x27')](function(_0x1e8e32){var _0x4db0dd=_0x5bb358[_0x9307('0x4f')][_0x9307('0x28')]({'plain':!![]});if(!_0x4db0dd)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4db0dd[_0x9307('0x50')]===_0x9307('0x4f')){var _0xf75713=_0x1e8e32[_0x9307('0x28')]({'plain':!![]});var _0x1cca54=[{'name':_0x9307('0x29'),'value':_0x9307('0x51')},{'name':'QueueCampaigns','value':'outbound'}];var _0x2268d2=_[_0x9307('0x52')](_0x1cca54,[_0x9307('0x2d'),_0xf75713['type']])[_0x9307('0x2f')];return db[_0x9307('0x53')]['find']({'where':{'name':_0x2268d2,'userProfileId':_0x4db0dd[_0x9307('0x54')]},'raw':!![]})[_0x9307('0x27')](function(_0x1bb8e1){if(_0x1bb8e1&&_0x1bb8e1['autoAssociation']===0x0){return db[_0x9307('0x30')][_0x9307('0x4e')]({'name':_0xf75713['name'],'resourceId':_0xf75713['id'],'type':_0x1bb8e1[_0x9307('0x2f')],'sectionId':_0x1bb8e1['id']},{})[_0x9307('0x27')](function(){return _0x1e8e32;});}else{return _0x1e8e32;}})[_0x9307('0x49')](function(_0x49fa2b){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x49fa2b);throw _0x49fa2b;});}return _0x1e8e32;})['then'](respondWithResult(_0x6272c7,0xc9))[_0x9307('0x49')](handleError(_0x6272c7,null));};exports[_0x9307('0x55')]=function(_0x34bc1e,_0x5c4907){var _0x5ec1ac={'where':{'id':_0x34bc1e[_0x9307('0x4b')]['id']}},_0x39b01d={};_0x39b01d[_0x9307('0x3b')]=_[_0x9307('0x3d')](db[_0x9307('0x37')][_0x9307('0x38')]);_0x5ec1ac['attributes']=_[_0x9307('0x3f')](_0x39b01d[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x34bc1e[_0x9307('0x3c')][_0x9307('0x41')]));_0x5ec1ac['attributes']=_0x5ec1ac[_0x9307('0x40')][_0x9307('0x4c')]?_0x5ec1ac['attributes']:_0x39b01d[_0x9307('0x3b')];if(_0x34bc1e[_0x9307('0x3c')]['includeAll']){_0x5ec1ac[_0x9307('0x4d')]=[{'all':!![]}];}_0x5ec1ac=_[_0x9307('0x44')]({},_0x5ec1ac,_0x34bc1e['options']);return db[_0x9307('0x37')][_0x9307('0x52')](_0x5ec1ac)[_0x9307('0x27')](handleEntityNotFound(_0x5c4907,null))[_0x9307('0x27')](function(_0x3a6564){if(_0x3a6564){var _0x383e4d=_0x3a6564[_0x9307('0x28')]({'plain':!![]});_0x383e4d=qs[_0x9307('0x56')](_0x383e4d,['id',_0x9307('0x57'),_0x9307('0x58')]);_0x34bc1e[_0x9307('0x59')]=_[_0x9307('0x56')](_0x34bc1e['body'],['id',_0x9307('0x57'),'updatedAt']);return db[_0x9307('0x37')][_0x9307('0x4e')](_['merge'](_0x383e4d,_0x34bc1e[_0x9307('0x59')]),{'include':_0x34bc1e[_0x9307('0x3c')]['includeAll']?[{'all':!![]}]:undefined})[_0x9307('0x27')](function(_0xf5390d){var _0xdb251b=_0x34bc1e[_0x9307('0x4f')][_0x9307('0x28')]({'plain':!![]});if(!_0xdb251b)throw new Error(_0x9307('0x5a'));if(_0xdb251b['role']===_0x9307('0x4f')){var _0x1f0936=_0xf5390d[_0x9307('0x28')]({'plain':!![]});var _0x5041d3=[{'name':_0x9307('0x29'),'value':_0x9307('0x51')},{'name':_0x9307('0x2a'),'value':'outbound'}];var _0x16a62b=_[_0x9307('0x52')](_0x5041d3,['value',_0x1f0936[_0x9307('0x2e')]])[_0x9307('0x2f')];return db[_0x9307('0x53')][_0x9307('0x52')]({'where':{'name':_0x16a62b,'userProfileId':_0xdb251b[_0x9307('0x54')]},'raw':!![]})['then'](function(_0x22fc8c){if(_0x22fc8c&&_0x22fc8c[_0x9307('0x5b')]===0x0){return db['UserProfileResource']['create']({'name':_0x1f0936[_0x9307('0x2f')],'resourceId':_0x1f0936['id'],'type':_0x22fc8c['name'],'sectionId':_0x22fc8c['id']},{})['then'](function(){return _0xf5390d;});}else{return _0xf5390d;}})[_0x9307('0x49')](function(_0x2780a2){logger[_0x9307('0x32')](_0x9307('0x5c'),_0x2780a2);throw _0x2780a2;});}return _0xf5390d;});}})['then'](respondWithResult(_0x5c4907,0xc9))[_0x9307('0x49')](handleError(_0x5c4907,null));};exports[_0x9307('0x25')]=function(_0x1da55c,_0x17e344){if(_0x1da55c['body']['id']){delete _0x1da55c[_0x9307('0x59')]['id'];}return db['VoiceQueue'][_0x9307('0x52')]({'where':{'id':_0x1da55c[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x17e344,null))['then'](saveUpdates(_0x1da55c[_0x9307('0x59')],null))[_0x9307('0x27')](respondWithResult(_0x17e344,null))['catch'](handleError(_0x17e344,null));};exports[_0x9307('0x26')]=function(_0x53d490,_0x1c1351){return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x53d490[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x1c1351,null))['then'](removeEntity(_0x1c1351,null))[_0x9307('0x49')](handleError(_0x1c1351,null));};exports[_0x9307('0x5d')]=function(_0x36d456,_0x1224b3,_0x798430){var _0x270afc={'raw':![],'where':{}};var _0x1102c7={};var _0x340e6e={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x9307('0x5e')]({'where':{'id':_0x36d456[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x1224b3,null))[_0x9307('0x27')](function(_0x4e798d){if(_0x4e798d){_0x1102c7['model']=_[_0x9307('0x3d')](db['CmHopper']['rawAttributes']);_0x1102c7[_0x9307('0x3c')]=_[_0x9307('0x3d')](_0x36d456['query']);_0x1102c7[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x1102c7['model'],_0x1102c7['query']);_0x270afc[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x1102c7[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x36d456['query']['fields']));_0x270afc['attributes']=_0x270afc[_0x9307('0x40')][_0x9307('0x4c')]?_0x270afc[_0x9307('0x40')]:_0x1102c7[_0x9307('0x3b')];if(!_0x36d456[_0x9307('0x3c')]['hasOwnProperty'](_0x9307('0x42'))){_0x270afc[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x36d456[_0x9307('0x3c')]['limit']);_0x270afc[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x36d456[_0x9307('0x3c')][_0x9307('0x1c')]);}_0x270afc[_0x9307('0x5f')]=qs['sort'](_0x36d456[_0x9307('0x3c')][_0x9307('0x60')]);_0x270afc['where']=qs[_0x9307('0x3e')](_['pick'](_0x36d456[_0x9307('0x3c')],_0x1102c7[_0x9307('0x3e')]));_0x270afc['where'][_0x9307('0x61')]=_0x4e798d['id'];if(_0x36d456[_0x9307('0x3c')][_0x9307('0x2b')]){_0x270afc[_0x9307('0x43')]=_['merge'](_0x270afc[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x270afc[_0x9307('0x40')],function(_0x2abde0){var _0x3e1d15={};_0x3e1d15[_0x2abde0]={'$like':'%'+_0x36d456[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x3e1d15;})});}_0x270afc=_[_0x9307('0x44')]({},_0x270afc,_0x36d456[_0x9307('0x45')]);return db['CmHopper'][_0x9307('0x1f')]({'where':_0x270afc[_0x9307('0x43')]})['then'](function(_0x1d37ac){_0x340e6e[_0x9307('0x1f')]=_0x1d37ac;if(_0x36d456[_0x9307('0x3c')][_0x9307('0x46')]){_0x270afc['include']=[{'all':!![]}];}return db['CmHopper'][_0x9307('0x47')](_0x270afc);})[_0x9307('0x27')](function(_0x456095){_0x340e6e[_0x9307('0x48')]=_0x456095;return _0x340e6e;});}})['then'](respondWithFilteredResult(_0x1224b3,_0x270afc))[_0x9307('0x49')](handleError(_0x1224b3,null));};exports[_0x9307('0x62')]=function(_0x4fdda9,_0x3a2290,_0x3207ba){var _0x59a5fa={'raw':!![],'where':{}};var _0x159d6f={};var _0x285d99={'count':0x0,'rows':[]};return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x4fdda9[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x3a2290,null))[_0x9307('0x27')](function(_0x4c8349){if(_0x4c8349){_0x159d6f[_0x9307('0x3b')]=_['keys'](db[_0x9307('0x63')][_0x9307('0x38')]);_0x159d6f[_0x9307('0x3c')]=_['keys'](_0x4fdda9[_0x9307('0x3c')]);_0x159d6f[_0x9307('0x3e')]=_['intersection'](_0x159d6f['model'],_0x159d6f[_0x9307('0x3c')]);_0x59a5fa[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x159d6f[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x4fdda9[_0x9307('0x3c')][_0x9307('0x41')]));_0x59a5fa['attributes']=_0x59a5fa[_0x9307('0x40')][_0x9307('0x4c')]?_0x59a5fa[_0x9307('0x40')]:_0x159d6f[_0x9307('0x3b')];if(!_0x4fdda9[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x59a5fa[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x4fdda9[_0x9307('0x3c')][_0x9307('0x1e')]);_0x59a5fa[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x4fdda9['query'][_0x9307('0x1c')]);}_0x59a5fa[_0x9307('0x5f')]=qs['sort'](_0x4fdda9[_0x9307('0x3c')][_0x9307('0x60')]);_0x59a5fa[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x4fdda9[_0x9307('0x3c')],_0x159d6f['filters']));_0x59a5fa['where'][_0x9307('0x61')]=_0x4c8349['id'];if(_0x4fdda9[_0x9307('0x3c')][_0x9307('0x2b')]){_0x59a5fa[_0x9307('0x43')]=_['merge'](_0x59a5fa['where'],{'$or':_['map'](_0x59a5fa['attributes'],function(_0x8e5f70){var _0x4a14af={};_0x4a14af[_0x8e5f70]={'$like':'%'+_0x4fdda9[_0x9307('0x3c')]['filter']+'%'};return _0x4a14af;})});}_0x59a5fa=_[_0x9307('0x44')]({},_0x59a5fa,_0x4fdda9[_0x9307('0x45')]);return db[_0x9307('0x63')]['count']({'where':_0x59a5fa[_0x9307('0x43')]})[_0x9307('0x27')](function(_0x21c818){_0x285d99[_0x9307('0x1f')]=_0x21c818;if(_0x4fdda9[_0x9307('0x3c')][_0x9307('0x46')]){_0x59a5fa[_0x9307('0x4d')]=[{'all':!![]}];}return db[_0x9307('0x63')]['findAll'](_0x59a5fa);})[_0x9307('0x27')](function(_0x2c2806){_0x285d99[_0x9307('0x48')]=_0x2c2806;return _0x285d99;});}})[_0x9307('0x27')](respondWithFilteredResult(_0x3a2290,_0x59a5fa))[_0x9307('0x49')](handleError(_0x3a2290,null));};exports[_0x9307('0x66')]=function(_0x4bc9a0,_0x54b06a,_0x268b52){var _0x21e3da={'raw':!![],'where':{}};var _0x530bb0={};var _0x9e0e88={'count':0x0,'rows':[]};return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x4bc9a0[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x54b06a,null))[_0x9307('0x27')](function(_0x4cfdbb){if(_0x4cfdbb){_0x530bb0[_0x9307('0x3b')]=_[_0x9307('0x3d')](db['CmHopperFinal'][_0x9307('0x38')]);_0x530bb0['query']=_[_0x9307('0x3d')](_0x4bc9a0[_0x9307('0x3c')]);_0x530bb0[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x530bb0[_0x9307('0x3b')],_0x530bb0[_0x9307('0x3c')]);_0x21e3da[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x530bb0[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x41')]));_0x21e3da[_0x9307('0x40')]=_0x21e3da[_0x9307('0x40')]['length']?_0x21e3da[_0x9307('0x40')]:_0x530bb0[_0x9307('0x3b')];if(!_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x21e3da[_0x9307('0x1e')]=qs['limit'](_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x1e')]);_0x21e3da[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x1c')]);}_0x21e3da['order']=qs[_0x9307('0x60')](_0x4bc9a0['query'][_0x9307('0x60')]);_0x21e3da[_0x9307('0x43')]=qs[_0x9307('0x3e')](_['pick'](_0x4bc9a0[_0x9307('0x3c')],_0x530bb0[_0x9307('0x3e')]));_0x21e3da[_0x9307('0x43')][_0x9307('0x61')]=_0x4cfdbb['id'];if(_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x2b')]){_0x21e3da['where']=_[_0x9307('0x44')](_0x21e3da[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x21e3da[_0x9307('0x40')],function(_0x50014d){var _0x3bbdd1={};_0x3bbdd1[_0x50014d]={'$like':'%'+_0x4bc9a0[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x3bbdd1;})});}_0x21e3da=_[_0x9307('0x44')]({},_0x21e3da,_0x4bc9a0[_0x9307('0x45')]);return db[_0x9307('0x67')]['count']({'where':_0x21e3da[_0x9307('0x43')]})['then'](function(_0x52f551){_0x9e0e88[_0x9307('0x1f')]=_0x52f551;if(_0x4bc9a0['query'][_0x9307('0x46')]){_0x21e3da['include']=[{'all':!![]}];}return db[_0x9307('0x67')]['findAll'](_0x21e3da);})[_0x9307('0x27')](function(_0x4f0994){_0x9e0e88[_0x9307('0x48')]=_0x4f0994;return _0x9e0e88;});}})[_0x9307('0x27')](respondWithFilteredResult(_0x54b06a,_0x21e3da))['catch'](handleError(_0x54b06a,null));};exports[_0x9307('0x68')]=function(_0x57c981,_0x5ee5e0,_0x5037ca){var _0x4383cb={'raw':!![],'where':{}};var _0x3e3bbf={};var _0x366e9d={'count':0x0,'rows':[]};return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x57c981[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x5ee5e0,null))[_0x9307('0x27')](function(_0x5dd2c3){if(_0x5dd2c3){_0x3e3bbf[_0x9307('0x3b')]=_['keys'](db['CmHopperBlack'][_0x9307('0x38')]);_0x3e3bbf[_0x9307('0x3c')]=_['keys'](_0x57c981[_0x9307('0x3c')]);_0x3e3bbf['filters']=_[_0x9307('0x3f')](_0x3e3bbf[_0x9307('0x3b')],_0x3e3bbf['query']);_0x4383cb[_0x9307('0x40')]=_['intersection'](_0x3e3bbf[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x57c981[_0x9307('0x3c')]['fields']));_0x4383cb['attributes']=_0x4383cb[_0x9307('0x40')][_0x9307('0x4c')]?_0x4383cb[_0x9307('0x40')]:_0x3e3bbf[_0x9307('0x3b')];if(!_0x57c981[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x4383cb[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x57c981['query'][_0x9307('0x1e')]);_0x4383cb[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x57c981[_0x9307('0x3c')][_0x9307('0x1c')]);}_0x4383cb[_0x9307('0x5f')]=qs[_0x9307('0x60')](_0x57c981[_0x9307('0x3c')]['sort']);_0x4383cb[_0x9307('0x43')]=qs['filters'](_['pick'](_0x57c981[_0x9307('0x3c')],_0x3e3bbf[_0x9307('0x3e')]));_0x4383cb['where'][_0x9307('0x61')]=_0x5dd2c3['id'];if(_0x57c981[_0x9307('0x3c')][_0x9307('0x2b')]){_0x4383cb[_0x9307('0x43')]=_[_0x9307('0x44')](_0x4383cb[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x4383cb[_0x9307('0x40')],function(_0x45e1c1){var _0x4974dd={};_0x4974dd[_0x45e1c1]={'$like':'%'+_0x57c981[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x4974dd;})});}_0x4383cb=_[_0x9307('0x44')]({},_0x4383cb,_0x57c981[_0x9307('0x45')]);return db[_0x9307('0x69')]['count']({'where':_0x4383cb[_0x9307('0x43')]})[_0x9307('0x27')](function(_0x30af84){_0x366e9d['count']=_0x30af84;if(_0x57c981[_0x9307('0x3c')]['includeAll']){_0x4383cb['include']=[{'all':!![]}];}return db[_0x9307('0x69')][_0x9307('0x47')](_0x4383cb);})[_0x9307('0x27')](function(_0x3f1920){_0x366e9d[_0x9307('0x48')]=_0x3f1920;return _0x366e9d;});}})[_0x9307('0x27')](respondWithFilteredResult(_0x5ee5e0,_0x4383cb))[_0x9307('0x49')](handleError(_0x5ee5e0,null));};exports[_0x9307('0x6a')]=function(_0x3a834d,_0x4fc7f3,_0x593e0e){var _0x19def4={};var _0x4ec335={};var _0x4cd875;var _0x44724c;return db['VoiceQueue'][_0x9307('0x5e')]({'where':{'id':_0x3a834d[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x4fc7f3,null))[_0x9307('0x27')](function(_0x4e2e2e){if(_0x4e2e2e){_0x4cd875=_0x4e2e2e;_0x4ec335['model']=_[_0x9307('0x3d')](db['Team'][_0x9307('0x38')]);_0x4ec335['query']=_['keys'](_0x3a834d[_0x9307('0x3c')]);_0x4ec335[_0x9307('0x3e')]=_[_0x9307('0x3f')](_0x4ec335[_0x9307('0x3b')],_0x4ec335[_0x9307('0x3c')]);_0x19def4[_0x9307('0x40')]=_[_0x9307('0x3f')](_0x4ec335['model'],qs[_0x9307('0x41')](_0x3a834d['query'][_0x9307('0x41')]));_0x19def4[_0x9307('0x40')]=_0x19def4[_0x9307('0x40')][_0x9307('0x4c')]?_0x19def4['attributes']:_0x4ec335[_0x9307('0x3b')];_0x19def4[_0x9307('0x5f')]=qs['sort'](_0x3a834d[_0x9307('0x3c')][_0x9307('0x60')]);_0x19def4[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x3a834d[_0x9307('0x3c')],_0x4ec335[_0x9307('0x3e')]));if(_0x3a834d[_0x9307('0x3c')][_0x9307('0x2b')]){_0x19def4['where']=_[_0x9307('0x44')](_0x19def4[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x19def4[_0x9307('0x40')],function(_0x7a0d7e){var _0xf067f6={};_0xf067f6[_0x7a0d7e]={'$like':'%'+_0x3a834d['query']['filter']+'%'};return _0xf067f6;})});}_0x19def4=_[_0x9307('0x44')]({},_0x19def4,_0x3a834d[_0x9307('0x45')]);return _0x4cd875[_0x9307('0x6a')](_0x19def4);}})[_0x9307('0x27')](function(_0x96c64a){if(_0x96c64a){_0x44724c=_0x96c64a[_0x9307('0x4c')];if(!_0x3a834d[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x19def4[_0x9307('0x1e')]=qs['limit'](_0x3a834d['query'][_0x9307('0x1e')]);_0x19def4[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x3a834d[_0x9307('0x3c')]['offset']);}return _0x4cd875[_0x9307('0x6a')](_0x19def4);}})['then'](function(_0x5562a8){if(_0x5562a8){return _0x5562a8?{'count':_0x44724c,'rows':_0x5562a8}:null;}})['then'](respondWithResult(_0x4fc7f3,null))[_0x9307('0x49')](handleError(_0x4fc7f3,null));};exports[_0x9307('0x6b')]=function(_0x216953,_0x9127d,_0x505bb4){var _0x21aeb8=_0x216953[_0x9307('0x59')]['teams'];var _0xa0bfe7=_[_0x9307('0x36')](_0x21aeb8,'id');return db[_0x9307('0x6c')][_0x9307('0x47')]({'where':{'id':_0xa0bfe7},'attributes':['id'],'include':[{'model':db[_0x9307('0x6d')],'as':'Agents','attributes':['id',_0x9307('0x2f'),_0x9307('0x6e'),'voicePause',_0x9307('0x6f')],'raw':!![]}]})['then'](function(_0x195b90){if(_0x195b90){var _0x3e166c=_['flatMap'](_0x195b90,function(_0x12f7db){var _0x4616b2=_0x12f7db['get']({'plain':!![]});_0x4616b2[_0x9307('0x70')]['forEach'](function(_0x5d5cdf){_0x5d5cdf[_0x9307('0x71')]=_['find'](_0x21aeb8,{'id':_0x4616b2['id']})['penalty'];});return _0x4616b2[_0x9307('0x70')];});return db[_0x9307('0x37')]['find']({'where':{'id':_0x216953[_0x9307('0x4b')]['id']}})['then'](function(_0x40ad77){return db[_0x9307('0x72')][_0x9307('0x73')](function(_0x21dba8){return _0x40ad77[_0x9307('0x6b')](_0xa0bfe7,{'transaction':_0x21dba8})['then'](function(){return BPromise[_0x9307('0x74')](_0x21aeb8,function(_0x1614ac){return db[_0x9307('0x75')]['upsert']({'TeamId':_0x1614ac['id'],'VoiceQueueId':_0x216953['params']['id'],'penalty':_0x1614ac[_0x9307('0x71')]},{'transaction':_0x21dba8});});})[_0x9307('0x27')](function(){return BPromise[_0x9307('0x74')](_0x3e166c,function(_0x18a44f){return db[_0x9307('0x76')][_0x9307('0x77')]({'where':{'UserId':_0x18a44f['id'],'VoiceQueueId':_0x216953[_0x9307('0x4b')]['id']},'defaults':{'penalty':_0x18a44f[_0x9307('0x71')]},'transaction':_0x21dba8});});})[_0x9307('0x27')](function(){return BPromise[_0x9307('0x74')](_[_0x9307('0x2b')](_0x3e166c,{'online':!![]}),function(_0x567681){return db[_0x9307('0x78')]['upsert']({'membername':_0x567681[_0x9307('0x2f')],'UserId':_0x567681['id'],'queue_name':_0x40ad77[_0x9307('0x2f')],'VoiceQueueId':_0x40ad77['id'],'interface':_[_0x9307('0x79')](_0x567681['interface'])?util[_0x9307('0x7a')](_0x9307('0x7b'),_0x567681[_0x9307('0x2f')]):_0x567681[_0x9307('0x6f')],'paused':_0x567681['voicePause']||![],'penalty':_0x567681[_0x9307('0x71')]},{'transaction':_0x21dba8});});})['then'](function(){_0x3e166c[_0x9307('0x7c')](function(_0x40fa18){socket[_0x9307('0x7d')]('userVoiceQueue:save',{'UserId':_0x40fa18['id'],'VoiceQueueId':_0x40ad77['id']});});});});});}})[_0x9307('0x27')](respondWithStatusCode(_0x9127d,null))['catch'](handleError(_0x9127d,null));};exports[_0x9307('0x7e')]=function(_0x21a4de,_0x9a6f62,_0x5b946a){return db[_0x9307('0x6c')][_0x9307('0x47')]({'where':{'id':_0x21a4de['query'][_0x9307('0x7f')]},'attributes':['id'],'include':[{'model':db[_0x9307('0x6d')],'as':_0x9307('0x70'),'attributes':['id'],'raw':!![]}]})[_0x9307('0x27')](handleEntityNotFound(_0x9a6f62,null))[_0x9307('0x27')](function(_0x38239d){var _0x4010a5=_[_0x9307('0x36')](_0x38239d,'id');var _0x5e93a2=[];var _0x6c402=[];var _0x157f7e=squel[_0x9307('0x80')]();_0x157f7e[_0x9307('0x81')](_0x9307('0x82'))[_0x9307('0x83')]('team_has_voice_queues','tq')['join'](_0x9307('0x84'),'ut',_0x9307('0x85'))[_0x9307('0x43')](_0x9307('0x86'),_0x21a4de[_0x9307('0x4b')]['id']);for(var _0x4219a1=0x0;_0x4219a1<_0x38239d[_0x9307('0x4c')];_0x4219a1+=0x1){let _0x2f75d3=_0x38239d[_0x4219a1];for(var _0x114cf5=0x0;_0x114cf5<_0x2f75d3[_0x9307('0x70')][_0x9307('0x4c')];_0x114cf5+=0x1){let _0xb2905f=_0x2f75d3[_0x9307('0x70')][_0x114cf5];var _0x10ae91=_0x157f7e[_0x9307('0x55')]();_0x10ae91[_0x9307('0x43')](_0x9307('0x87'),_0xb2905f['id']);_0x6c402[_0x9307('0x88')](db[_0x9307('0x72')][_0x9307('0x3c')](_0x10ae91[_0x9307('0x89')](),{'type':db['sequelize'][_0x9307('0x8a')][_0x9307('0x8b')]})[_0x9307('0x27')](function(_0x4ce6d5){if(_0x4ce6d5['length']===0x1){return _0xb2905f['id'];}else{var _0x359031=_[_0x9307('0x8c')](_[_0x9307('0x36')](_0x4ce6d5,_0x9307('0x8d')),function(_0x4b7d15){return _['includes'](_0x4010a5,_0x4b7d15);});if(_0x359031){return _0xb2905f['id'];}}}));}}return BPromise[_0x9307('0x8e')](_0x6c402)[_0x9307('0x27')](function(_0x49cca6){_0x5e93a2=_(_0x5e93a2)[_0x9307('0x8f')](_0x49cca6)[_0x9307('0x90')]()[_0x9307('0x2d')]();return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x21a4de[_0x9307('0x4b')]['id']}})['then'](function(_0x4c0366){return db[_0x9307('0x72')][_0x9307('0x73')](function(_0x2dfced){return _0x4c0366[_0x9307('0x7e')](_0x21a4de[_0x9307('0x3c')][_0x9307('0x7f')],{'transaction':_0x2dfced})[_0x9307('0x27')](function(){if(!_[_0x9307('0x91')](_0x5e93a2)){return _0x4c0366[_0x9307('0x92')](_0x5e93a2,{'transaction':_0x2dfced})[_0x9307('0x27')](function(){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x21a4de[_0x9307('0x4b')]['id'],'UserId':_0x5e93a2},'transaction':_0x2dfced});});}})[_0x9307('0x27')](function(){_0x5e93a2[_0x9307('0x7c')](function(_0x366059){socket[_0x9307('0x7d')](_0x9307('0x93'),{'UserId':_0x366059,'VoiceQueueId':_0x4c0366['id']});});});});});});})['then'](respondWithStatusCode(_0x9a6f62,null))[_0x9307('0x49')](handleError(_0x9a6f62,null));};exports[_0x9307('0x94')]=function(_0x13a4b7,_0x517ce5,_0x303946){var _0x4daf38,_0xc8877b;return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x13a4b7[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x517ce5,null))[_0x9307('0x27')](function(_0x1c02fa){if(_0x1c02fa){_0xc8877b=_0x1c02fa;return _0x1c02fa[_0x9307('0x94')](_0x13a4b7['body'][_0x9307('0x7f')],_[_0x9307('0x56')](_0x13a4b7[_0x9307('0x59')],[_0x9307('0x7f'),'id'])||{})[_0x9307('0x95')](function(_0x23bc4a){for(var _0x4175b4=0x0;_0x4175b4<_0x13a4b7[_0x9307('0x59')][_0x9307('0x7f')][_0x9307('0x4c')];_0x4175b4+=0x1){socket[_0x9307('0x7d')](_0x9307('0x96'),{'UserId':Number(_0x13a4b7['body']['ids'][_0x4175b4]),'VoiceQueueId':Number(_0x13a4b7[_0x9307('0x4b')]['id'])});}return _0x23bc4a;});}})[_0x9307('0x27')](function(_0x536930){_0x4daf38=_0x536930||[];if(_0xc8877b){return db[_0x9307('0x6d')][_0x9307('0x47')]({'where':{'id':_0x13a4b7[_0x9307('0x59')][_0x9307('0x7f')]},'attributes':['id',_0x9307('0x2f'),_0x9307('0x6e'),_0x9307('0x97'),_0x9307('0x6f')],'raw':!![]});}})[_0x9307('0x27')](function(_0xa95202){if(!_[_0x9307('0x91')](_0xa95202)){var _0x17b856=[];for(var _0x12f595=0x0;_0x12f595<_0xa95202[_0x9307('0x4c')];_0x12f595++){if(_0xa95202[_0x12f595][_0x9307('0x6e')]){_0x17b856[_0x9307('0x88')](db[_0x9307('0x78')]['upsert']({'membername':_0xa95202[_0x12f595]['name'],'UserId':_0xa95202[_0x12f595]['id'],'queue_name':_0xc8877b[_0x9307('0x2f')],'VoiceQueueId':_0xc8877b['id'],'interface':_[_0x9307('0x79')](_0xa95202[_0x12f595]['interface'])?util[_0x9307('0x7a')](_0x9307('0x7b'),_0xa95202[_0x12f595][_0x9307('0x2f')]):_0xa95202[_0x12f595][_0x9307('0x6f')],'paused':_0xa95202[_0x12f595]['voicePause']||![],'penalty':_0x13a4b7['body'][_0x9307('0x71')]||0x0}));}}return BPromise[_0x9307('0x8e')](_0x17b856);}})['then'](function(){return _0x4daf38;})[_0x9307('0x27')](respondWithResult(_0x517ce5,null))[_0x9307('0x49')](handleError(_0x517ce5,null));};exports[_0x9307('0x92')]=function(_0x2d8ea9,_0x484f1c,_0x310402){return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x2d8ea9[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x484f1c,null))[_0x9307('0x27')](function(_0x3e4fec){if(_0x3e4fec){return _0x3e4fec[_0x9307('0x92')](_0x2d8ea9['query'][_0x9307('0x7f')])[_0x9307('0x27')](function(){if(_[_0x9307('0x98')](_0x2d8ea9['query'][_0x9307('0x7f')])){for(var _0x51ffd0=0x0;_0x51ffd0<_0x2d8ea9[_0x9307('0x3c')][_0x9307('0x7f')][_0x9307('0x4c')];_0x51ffd0+=0x1){socket[_0x9307('0x7d')]('userVoiceQueue:remove',{'UserId':Number(_0x2d8ea9[_0x9307('0x3c')][_0x9307('0x7f')][_0x51ffd0]),'VoiceQueueId':Number(_0x2d8ea9[_0x9307('0x4b')]['id'])});}}else{socket[_0x9307('0x7d')]('userVoiceQueue:remove',{'UserId':Number(_0x2d8ea9[_0x9307('0x3c')][_0x9307('0x7f')]),'VoiceQueueId':Number(_0x2d8ea9[_0x9307('0x4b')]['id'])});}});}})[_0x9307('0x27')](function(_0x56e69e){return db[_0x9307('0x78')][_0x9307('0x26')]({'where':{'VoiceQueueId':_0x2d8ea9[_0x9307('0x4b')]['id'],'UserId':_0x2d8ea9[_0x9307('0x3c')][_0x9307('0x7f')]}})[_0x9307('0x27')](function(){return _0x56e69e;});})[_0x9307('0x27')](respondWithStatusCode(_0x484f1c,null))['catch'](handleError(_0x484f1c,null));};exports[_0x9307('0x99')]=function(_0x55f414,_0x5d69d6,_0x36c195){var _0x3f020b={};var _0x166c73={};var _0x5c3b81;var _0x229499;return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x55f414['params']['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x5d69d6,null))['then'](function(_0x193d52){if(_0x193d52){_0x5c3b81=_0x193d52;_0x166c73[_0x9307('0x3b')]=_['keys'](db[_0x9307('0x6d')][_0x9307('0x38')]);_0x166c73['query']=_['keys'](_0x55f414['query']);_0x166c73['filters']=_[_0x9307('0x3f')](_0x166c73[_0x9307('0x3b')],_0x166c73['query']);_0x3f020b[_0x9307('0x40')]=_['intersection'](_0x166c73[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x55f414[_0x9307('0x3c')][_0x9307('0x41')]));_0x3f020b['attributes']=_0x3f020b[_0x9307('0x40')]['length']?_0x3f020b[_0x9307('0x40')]:_0x166c73[_0x9307('0x3b')];_0x3f020b[_0x9307('0x5f')]=qs[_0x9307('0x60')](_0x55f414[_0x9307('0x3c')][_0x9307('0x60')]);_0x3f020b['where']=qs[_0x9307('0x3e')](_['pick'](_0x55f414[_0x9307('0x3c')],_0x166c73[_0x9307('0x3e')]));if(_0x55f414[_0x9307('0x3c')]['filter']){_0x3f020b['where']=_[_0x9307('0x44')](_0x3f020b['where'],{'$or':_[_0x9307('0x36')](_0x3f020b[_0x9307('0x40')],function(_0x1be923){var _0x146962={};_0x146962[_0x1be923]={'$like':'%'+_0x55f414[_0x9307('0x3c')]['filter']+'%'};return _0x146962;})});}_0x3f020b=_[_0x9307('0x44')]({},_0x3f020b,_0x55f414[_0x9307('0x45')]);return _0x5c3b81['getAgents'](_0x3f020b);}})[_0x9307('0x27')](function(_0x375280){if(_0x375280){_0x229499=_0x375280['length'];if(!_0x55f414['query'][_0x9307('0x64')](_0x9307('0x42'))){_0x3f020b[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x55f414[_0x9307('0x3c')][_0x9307('0x1e')]);_0x3f020b[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x55f414[_0x9307('0x3c')]['offset']);}return _0x5c3b81[_0x9307('0x99')](_0x3f020b);}})[_0x9307('0x27')](function(_0xce8c88){if(_0xce8c88){return _0xce8c88?{'count':_0x229499,'rows':_0xce8c88}:null;}})[_0x9307('0x27')](respondWithResult(_0x5d69d6,null))['catch'](handleError(_0x5d69d6,null));};exports[_0x9307('0x9a')]=function(_0x3301c3,_0x1daf74,_0x3db4cc){var _0x4dd2e4={};var _0x5baf63={};var _0x73d1aa;var _0xed5cfa;return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x3301c3[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x1daf74,null))[_0x9307('0x27')](function(_0x1495af){if(_0x1495af){_0x73d1aa=_0x1495af;_0x5baf63['model']=_['keys'](db['UserVoiceQueueRt'][_0x9307('0x38')]);_0x5baf63[_0x9307('0x3c')]=_[_0x9307('0x3d')](_0x3301c3[_0x9307('0x3c')]);_0x5baf63['filters']=_[_0x9307('0x3f')](_0x5baf63['model'],_0x5baf63[_0x9307('0x3c')]);_0x4dd2e4['attributes']=_[_0x9307('0x3f')](_0x5baf63[_0x9307('0x3b')],qs['fields'](_0x3301c3[_0x9307('0x3c')][_0x9307('0x41')]));_0x4dd2e4[_0x9307('0x40')]=_0x4dd2e4[_0x9307('0x40')][_0x9307('0x4c')]?_0x4dd2e4[_0x9307('0x40')]:_0x5baf63[_0x9307('0x3b')];_0x4dd2e4[_0x9307('0x5f')]=qs['sort'](_0x3301c3['query']['sort']);_0x4dd2e4[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x3301c3[_0x9307('0x3c')],_0x5baf63[_0x9307('0x3e')]));if(_0x3301c3['query'][_0x9307('0x2b')]){_0x4dd2e4[_0x9307('0x43')]=_['merge'](_0x4dd2e4[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0x4dd2e4[_0x9307('0x40')],function(_0x324fa9){var _0x4b106c={};_0x4b106c[_0x324fa9]={'$like':'%'+_0x3301c3[_0x9307('0x3c')]['filter']+'%'};return _0x4b106c;})});}_0x4dd2e4=_[_0x9307('0x44')]({},_0x4dd2e4,_0x3301c3[_0x9307('0x45')]);return _0x73d1aa['getMembers'](_0x4dd2e4);}})[_0x9307('0x27')](function(_0x2743f5){if(_0x2743f5){_0xed5cfa=_0x2743f5[_0x9307('0x4c')];if(!_0x3301c3[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x4dd2e4[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x3301c3[_0x9307('0x3c')][_0x9307('0x1e')]);_0x4dd2e4[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x3301c3[_0x9307('0x3c')][_0x9307('0x1c')]);}return _0x73d1aa['getMembers'](_0x4dd2e4);}})[_0x9307('0x27')](function(_0x434a7b){return _0x434a7b?{'count':_0xed5cfa,'rows':_0x434a7b}:null;})[_0x9307('0x27')](respondWithResult(_0x1daf74,null))[_0x9307('0x49')](handleError(_0x1daf74,null));};exports[_0x9307('0x9b')]=function(_0x413d86,_0x444e17,_0x4c9cdf){var _0xaf6e35={};var _0x33cd1={};var _0x3e3834;var _0x456589;return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x413d86[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x444e17,null))['then'](function(_0x7f93de){if(_0x7f93de){_0x3e3834=_0x7f93de;_0x33cd1[_0x9307('0x3b')]=_[_0x9307('0x3d')](db[_0x9307('0x9c')]['rawAttributes']);_0x33cd1['query']=_['keys'](_0x413d86[_0x9307('0x3c')]);_0x33cd1['filters']=_[_0x9307('0x3f')](_0x33cd1[_0x9307('0x3b')],_0x33cd1[_0x9307('0x3c')]);_0xaf6e35[_0x9307('0x40')]=_['intersection'](_0x33cd1[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x413d86[_0x9307('0x3c')][_0x9307('0x41')]));_0xaf6e35[_0x9307('0x40')]=_0xaf6e35[_0x9307('0x40')][_0x9307('0x4c')]?_0xaf6e35['attributes']:_0x33cd1[_0x9307('0x3b')];_0xaf6e35['order']=qs[_0x9307('0x60')](_0x413d86[_0x9307('0x3c')]['sort']);_0xaf6e35[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x413d86['query'],_0x33cd1[_0x9307('0x3e')]));if(_0x413d86[_0x9307('0x3c')][_0x9307('0x2b')]){_0xaf6e35['where']=_['merge'](_0xaf6e35[_0x9307('0x43')],{'$or':_[_0x9307('0x36')](_0xaf6e35[_0x9307('0x40')],function(_0x447171){var _0x560f62={};_0x560f62[_0x447171]={'$like':'%'+_0x413d86['query'][_0x9307('0x2b')]+'%'};return _0x560f62;})});}_0xaf6e35=_[_0x9307('0x44')]({},_0xaf6e35,_0x413d86[_0x9307('0x45')]);return _0x3e3834['getLists'](_0xaf6e35);}})['then'](function(_0x2b054a){if(_0x2b054a){_0x456589=_0x2b054a[_0x9307('0x4c')];if(!_0x413d86[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0xaf6e35[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x413d86['query'][_0x9307('0x1e')]);_0xaf6e35[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x413d86[_0x9307('0x3c')][_0x9307('0x1c')]);}return _0x3e3834[_0x9307('0x9b')](_0xaf6e35);}})[_0x9307('0x27')](function(_0x3373cf){if(_0x3373cf){return _0x3373cf?{'count':_0x456589,'rows':_0x3373cf}:null;}})['then'](respondWithResult(_0x444e17,null))[_0x9307('0x49')](handleError(_0x444e17,null));};exports[_0x9307('0x9d')]=function(_0x1b58c5,_0xa13cd1,_0x58b692){var _0x1b564d=moment()[_0x9307('0x7a')](_0x9307('0x9e'));var _0x1cd08c,_0x4631ec;return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x1b58c5[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0xa13cd1,null))[_0x9307('0x27')](function(_0x2f7ad9){if(_0x2f7ad9){_0x4631ec=_0x2f7ad9;return _0x2f7ad9[_0x9307('0x9d')](_0x1b58c5[_0x9307('0x59')][_0x9307('0x7f')],_[_0x9307('0x56')](_0x1b58c5['body'],[_0x9307('0x7f'),'id'])||{});}return null;})[_0x9307('0x95')](function(_0x3c140e){var _0x4da62e;_0x1cd08c=_0x3c140e||[];var _0x25f206=[];if(_0x3c140e){for(var _0x501875=0x0;_0x501875<_0x3c140e[_0x9307('0x4c')];_0x501875+=0x1){var _0x534638=_0x3c140e[_0x501875][_0x9307('0x28')]({'plain':!![]});_0x4631ec[_0x9307('0x9f')]=_0x1b58c5[_0x9307('0x59')]['dialCheckDuplicateType']?_0x1b58c5[_0x9307('0x59')][_0x9307('0x9f')]:_0x4631ec[_0x9307('0x9f')];switch(_0x4631ec[_0x9307('0x9f')]){case _0x9307('0xa0'):_0x4da62e=squel[_0x9307('0xa1')]()[_0x9307('0xa2')](_0x9307('0xa3'))[_0x9307('0xa4')](['phone',_0x9307('0xa5'),_0x9307('0xa6'),'ListId',_0x9307('0x61'),_0x9307('0x57'),_0x9307('0x58')],squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xa7'),_0x9307('0xa7'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0xa5'))[_0x9307('0x81')]('id',_0x9307('0xa6'))[_0x9307('0x81')](_0x534638[_0x9307('0xa8')]['toString'](),_0x9307('0xa9'))[_0x9307('0x81')](_0x1b58c5['params']['id'][_0x9307('0x89')](),_0x9307('0x61'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0x57'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0x58'))[_0x9307('0x83')](_0x9307('0xaa'))[_0x9307('0x43')]('deletedAt\x20IS\x20NULL')[_0x9307('0x43')](_0x9307('0xab'),_0x534638[_0x9307('0xa8')][_0x9307('0x89')]())[_0x9307('0x43')](_0x9307('0xac'))[_0x9307('0x43')](_0x9307('0xad'),squel[_0x9307('0x80')]()[_0x9307('0x81')]('COALESCE(calleridnum,\x27\x27)')[_0x9307('0x83')](_0x9307('0xae'))[_0x9307('0x43')](_0x9307('0x86'),_0x1b58c5[_0x9307('0x4b')]['id'][_0x9307('0x89')]()))[_0x9307('0x43')]('phone\x20NOT\x20IN\x20(?)',squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xaf'))['from']('cm_hopper')[_0x9307('0x43')](_0x9307('0x86'),_0x1b58c5['params']['id'][_0x9307('0x89')]())))[_0x9307('0x89')]();break;case _0x9307('0xb0'):_0x4da62e=squel[_0x9307('0xa1')]()[_0x9307('0xa2')](_0x9307('0xa3'))[_0x9307('0xa4')]([_0x9307('0xa7'),'scheduledAt',_0x9307('0xa6'),_0x9307('0xa9'),'VoiceQueueId','createdAt',_0x9307('0x58')],squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xa7'),_0x9307('0xa7'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0xa5'))[_0x9307('0x81')]('id','ContactId')[_0x9307('0x81')](_0x534638[_0x9307('0xa8')][_0x9307('0x89')](),_0x9307('0xa9'))[_0x9307('0x81')](_0x1b58c5[_0x9307('0x4b')]['id'][_0x9307('0x89')](),_0x9307('0x61'))['field']('\x27'+_0x1b564d+'\x27',_0x9307('0x57'))['field']('\x27'+_0x1b564d+'\x27',_0x9307('0x58'))['from'](_0x9307('0xaa'))['where'](_0x9307('0xb1'))[_0x9307('0x43')](_0x9307('0xab'),_0x534638[_0x9307('0xa8')]['toString']())[_0x9307('0x43')](_0x9307('0xac'))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0x9307('0x80')]()[_0x9307('0x81')]('COALESCE(phone,\x27\x27)')[_0x9307('0x83')](_0x9307('0xa3'))[_0x9307('0x43')](_0x9307('0x86'),_0x1b58c5['params']['id']['toString']())))[_0x9307('0x89')]();break;default:_0x4da62e=squel['insert']()[_0x9307('0xa2')](_0x9307('0xa3'))['fromQuery']([_0x9307('0xa7'),_0x9307('0xa5'),_0x9307('0xa6'),_0x9307('0xa9'),_0x9307('0x61'),_0x9307('0x57'),_0x9307('0x58')],squel['select']()[_0x9307('0x81')](_0x9307('0xa7'),_0x9307('0xa7'))['field']('\x27'+_0x1b564d+'\x27',_0x9307('0xa5'))[_0x9307('0x81')]('id',_0x9307('0xa6'))['field'](_0x534638[_0x9307('0xa8')][_0x9307('0x89')](),_0x9307('0xa9'))['field'](_0x1b58c5[_0x9307('0x4b')]['id'][_0x9307('0x89')](),_0x9307('0x61'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0x57'))['field']('\x27'+_0x1b564d+'\x27','updatedAt')[_0x9307('0x83')](_0x9307('0xaa'))[_0x9307('0x43')](_0x9307('0xb1'))[_0x9307('0x43')](_0x9307('0xab'),_0x534638[_0x9307('0xa8')]['toString']())[_0x9307('0x43')]('phone\x20IS\x20NOT\x20NULL'))['toString']();}_0x25f206[_0x9307('0x88')](db['sequelize'][_0x9307('0x3c')](_0x4da62e));}return BPromise['all'](_0x25f206);}})[_0x9307('0x27')](function(){var _0x7d82bc=[];var _0x21a33b=squel['insert']()[_0x9307('0xa2')](_0x9307('0xb2'))[_0x9307('0xa4')](['CmHopperId',_0x9307('0xa7'),_0x9307('0xb3'),'createdAt',_0x9307('0x58')],squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xb4'))[_0x9307('0x81')](_0x9307('0xb5'))[_0x9307('0x81')](_0x9307('0xb6'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27',_0x9307('0x57'))[_0x9307('0x81')]('\x27'+_0x1b564d+'\x27','updatedAt')['from'](_0x9307('0xb7'),'ci')['join']('cm_hopper','h',_0x9307('0xb8'))['where'](_0x9307('0xb9'),_0x1b564d)['where'](_0x9307('0xba'),_0x9307('0xbb')))[_0x9307('0x89')]();_0x7d82bc[_0x9307('0x88')](db[_0x9307('0x72')][_0x9307('0x3c')](_0x21a33b));return BPromise[_0x9307('0x8e')](_0x7d82bc);})[_0x9307('0x27')](function(){return _0x1cd08c;})[_0x9307('0x27')](respondWithResult(_0xa13cd1,null))[_0x9307('0x49')](handleError(_0xa13cd1,null));};exports[_0x9307('0xbc')]=function(_0x4e62f8,_0x40d1c3,_0x33495e){return db['VoiceQueue'][_0x9307('0x52')]({'where':{'id':_0x4e62f8[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x40d1c3,null))['then'](function(_0xc41ba3){if(_0xc41ba3){return _0xc41ba3['removeLists'](_0x4e62f8[_0x9307('0x3c')]['ids']);}})[_0x9307('0x27')](function(_0x116e55){if(_0x116e55){return db[_0x9307('0xbd')][_0x9307('0x26')]({'where':{'ListId':_0x4e62f8[_0x9307('0x3c')][_0x9307('0x7f')],'VoiceQueueId':_0x4e62f8[_0x9307('0x4b')]['id']}})['then'](function(){return _0x116e55;});}})[_0x9307('0x27')](respondWithStatusCode(_0x40d1c3,null))['catch'](handleError(_0x40d1c3,null));};exports[_0x9307('0xbe')]=function(_0x58167e,_0x2abb5e,_0x1a6cd5){var _0x5ec693={};var _0x4e28ed={};var _0x387e30;var _0x37a9ac;return db[_0x9307('0x37')][_0x9307('0x5e')]({'where':{'id':_0x58167e[_0x9307('0x4b')]['id']}})['then'](handleEntityNotFound(_0x2abb5e,null))['then'](function(_0x1490ff){if(_0x1490ff){_0x387e30=_0x1490ff;_0x4e28ed[_0x9307('0x3b')]=_[_0x9307('0x3d')](db[_0x9307('0x9c')][_0x9307('0x38')]);_0x4e28ed[_0x9307('0x3c')]=_[_0x9307('0x3d')](_0x58167e['query']);_0x4e28ed['filters']=_[_0x9307('0x3f')](_0x4e28ed[_0x9307('0x3b')],_0x4e28ed[_0x9307('0x3c')]);_0x5ec693['attributes']=_[_0x9307('0x3f')](_0x4e28ed[_0x9307('0x3b')],qs[_0x9307('0x41')](_0x58167e[_0x9307('0x3c')]['fields']));_0x5ec693[_0x9307('0x40')]=_0x5ec693['attributes'][_0x9307('0x4c')]?_0x5ec693[_0x9307('0x40')]:_0x4e28ed['model'];_0x5ec693[_0x9307('0x5f')]=qs[_0x9307('0x60')](_0x58167e[_0x9307('0x3c')][_0x9307('0x60')]);_0x5ec693[_0x9307('0x43')]=qs[_0x9307('0x3e')](_[_0x9307('0x65')](_0x58167e[_0x9307('0x3c')],_0x4e28ed[_0x9307('0x3e')]));if(_0x58167e[_0x9307('0x3c')][_0x9307('0x2b')]){_0x5ec693['where']=_[_0x9307('0x44')](_0x5ec693['where'],{'$or':_[_0x9307('0x36')](_0x5ec693['attributes'],function(_0x29b0c3){var _0x1fa8c9={};_0x1fa8c9[_0x29b0c3]={'$like':'%'+_0x58167e[_0x9307('0x3c')][_0x9307('0x2b')]+'%'};return _0x1fa8c9;})});}_0x5ec693=_[_0x9307('0x44')]({},_0x5ec693,_0x58167e['options']);return _0x387e30[_0x9307('0xbe')](_0x5ec693);}})[_0x9307('0x27')](function(_0x33270c){if(_0x33270c){_0x37a9ac=_0x33270c[_0x9307('0x4c')];if(!_0x58167e[_0x9307('0x3c')][_0x9307('0x64')](_0x9307('0x42'))){_0x5ec693[_0x9307('0x1e')]=qs[_0x9307('0x1e')](_0x58167e['query']['limit']);_0x5ec693[_0x9307('0x1c')]=qs[_0x9307('0x1c')](_0x58167e['query']['offset']);}return _0x387e30[_0x9307('0xbe')](_0x5ec693);}})[_0x9307('0x27')](function(_0x4f1234){if(_0x4f1234){return _0x4f1234?{'count':_0x37a9ac,'rows':_0x4f1234}:null;}})[_0x9307('0x27')](respondWithResult(_0x2abb5e,null))[_0x9307('0x49')](handleError(_0x2abb5e,null));};exports[_0x9307('0xbf')]=function(_0x3ac422,_0x31b34e,_0x49774c){var _0x2e6975,_0x1ba90d;return db[_0x9307('0x37')][_0x9307('0x52')]({'where':{'id':_0x3ac422[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x31b34e,null))['then'](function(_0x2ffb3e){if(_0x2ffb3e){_0x1ba90d=_0x2ffb3e;return _0x2ffb3e[_0x9307('0xbf')](_0x3ac422[_0x9307('0x59')][_0x9307('0x7f')],_[_0x9307('0x56')](_0x3ac422[_0x9307('0x59')],['ids','id'])||{});}return null;})[_0x9307('0x95')](function(_0x242835){var _0x13fd0f;_0x2e6975=_0x242835||[];var _0x4b547f=[];if(_0x242835){for(var _0x4c2086=0x0;_0x4c2086<_0x242835[_0x9307('0x4c')];_0x4c2086+=0x1){var _0x29fdf6=_0x242835[_0x4c2086][_0x9307('0x28')]({'plain':!![]});_0x13fd0f=squel[_0x9307('0xa1')]()[_0x9307('0xa2')](_0x9307('0xc0'))['fromQuery']([_0x9307('0xa7'),_0x9307('0xa6'),_0x9307('0xa9'),'VoiceQueueId',_0x9307('0x57'),_0x9307('0x58')],squel[_0x9307('0x80')]()[_0x9307('0x81')](_0x9307('0xa7'),'phone')[_0x9307('0x81')]('id',_0x9307('0xa6'))[_0x9307('0x81')](_0x29fdf6[_0x9307('0xa8')][_0x9307('0x89')](),_0x9307('0xa9'))[_0x9307('0x81')](_0x3ac422['params']['id'][_0x9307('0x89')](),'VoiceQueueId')[_0x9307('0x81')](_0x9307('0xc1'),_0x9307('0x57'))[_0x9307('0x81')](_0x9307('0xc1'),_0x9307('0x58'))[_0x9307('0x83')](_0x9307('0xaa'))[_0x9307('0x43')]('deletedAt\x20IS\x20NULL')['where']('ListId\x20=\x20?',_0x29fdf6[_0x9307('0xa8')]['toString']())[_0x9307('0x43')](_0x9307('0xac')))[_0x9307('0x89')]();_0x4b547f['push'](db[_0x9307('0x72')][_0x9307('0x3c')](_0x13fd0f));}return BPromise[_0x9307('0x8e')](_0x4b547f);}})['then'](function(){return _0x2e6975;})[_0x9307('0x27')](respondWithResult(_0x31b34e,null))[_0x9307('0x49')](handleError(_0x31b34e,null));};exports[_0x9307('0xc2')]=function(_0x5a9f60,_0x20cb54,_0xfb3a2){return db[_0x9307('0x37')]['find']({'where':{'id':_0x5a9f60['params']['id']}})[_0x9307('0x27')](handleEntityNotFound(_0x20cb54,null))[_0x9307('0x27')](function(_0x4842d4){if(_0x4842d4){return _0x4842d4[_0x9307('0xc2')](_0x5a9f60['query']['ids']);}})[_0x9307('0x27')](function(_0x190875){if(_0x190875){return db['CmHopperBlack'][_0x9307('0x26')]({'where':{'ListId':_0x5a9f60[_0x9307('0x3c')][_0x9307('0x7f')],'VoiceQueueId':_0x5a9f60[_0x9307('0x4b')]['id']}})[_0x9307('0x27')](function(){return _0x190875;});}})['then'](respondWithStatusCode(_0x20cb54,null))['catch'](handleError(_0x20cb54,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff