Built motion from commit a679711e.|2.6.15
[motion2.git] / server / api / voiceQueue / voiceQueue.controller.js
index 221a0a1..300c508 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xfd20=['autoAssociation','clone','merge','createdAt','updatedAt','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','findOne','CmHopper','nolimit','VoiceQueueId','CmHopperHistory','CmHopperFinal','findAll','getHopperBlacks','CmHopperBlack','getTeams','Team','addTeams','Agents','voicePause','interface','flatMap','penalty','sequelize','each','TeamVoiceQueue','upsert','UserVoiceQueue','UserVoiceQueueRt','format','SIP/%s','forEach','emit','userVoiceQueue:save','removeTeams','User','field','from','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','toString','QueryTypes','every','TeamId','includes','union','compact','transaction','removeAgents','userVoiceQueue:remove','addAgents','omit','ids','spread','online','isEmpty','isNil','getAgents','getMembers','getLists','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','always','insert','cm_hopper','fromQuery','phone','ListId','scheduledAt','ContactId','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20NOT\x20IN\x20(?)','select','COALESCE(phone,\x27\x27)','onlyIfOpen','into','phone\x20IS\x20NOT\x20NULL','CmHopperId','OrderBy','ci.item','ci.OrderBy+1','cm_contact_has_items','h.scheduledat=?','ci.ItemClass=?','PHONE','all','removeLists','CmList','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','rimraf','request-promise','moment','mustache','path','sox','to-csv','ejs','fs-extra','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','./voiceQueue.socket','register','sendStatus','json','offset','limit','undefined','count','Content-Range','apply','reject','save','update','then','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','map','value','type','find','name','UserProfileResource','destroy','error','stack','send','rawAttributes','key','query','keys','filters','intersection','model','attributes','fields','hasOwnProperty','order','sort','where','pick','VIRTUAL','options','VoiceQueue','includeAll','include','rows','catch','show','params','length','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0xfd20,0x66));var _0x0fd2=function(_0x268509,_0x196d93){_0x268509=_0x268509-0x0;var _0x5de441=_0xfd20[_0x268509];return _0x5de441;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x0fd2('0x0'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x0fd2('0x1'));var moment=require(_0x0fd2('0x2'));var BPromise=require('bluebird');var Mustache=require(_0x0fd2('0x3'));var util=require('util');var path=require(_0x0fd2('0x4'));var sox=require(_0x0fd2('0x5'));var csv=require(_0x0fd2('0x6'));var ejs=require(_0x0fd2('0x7'));var fs=require('fs');var fs_extra=require(_0x0fd2('0x8'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x0fd2('0x9'));var jsforce=require(_0x0fd2('0xa'));var deskjs=require(_0x0fd2('0xb'));var toCsv=require(_0x0fd2('0x6'));var querystring=require(_0x0fd2('0xc'));var Papa=require(_0x0fd2('0xd'));var Redis=require(_0x0fd2('0xe'));var authService=require('../../components/auth/service');var qs=require(_0x0fd2('0xf'));var as=require(_0x0fd2('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x0fd2('0x11'))('api');var utils=require(_0x0fd2('0x12'));var config=require(_0x0fd2('0x13'));var licenseUtil=require(_0x0fd2('0x14'));var db=require(_0x0fd2('0x15'))['db'];config[_0x0fd2('0x16')]=_[_0x0fd2('0x17')](config[_0x0fd2('0x16')],{'host':_0x0fd2('0x18'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x0fd2('0x19'))[_0x0fd2('0x1a')](socket);function respondWithStatusCode(_0x21dcc5,_0x28dd2b){_0x28dd2b=_0x28dd2b||0xcc;return function(_0x52ab36){if(_0x52ab36){return _0x21dcc5[_0x0fd2('0x1b')](_0x28dd2b);}return _0x21dcc5['status'](_0x28dd2b)['end']();};}function respondWithResult(_0x2b6254,_0x50eedc){_0x50eedc=_0x50eedc||0xc8;return function(_0x42f44c){if(_0x42f44c){return _0x2b6254['status'](_0x50eedc)[_0x0fd2('0x1c')](_0x42f44c);}};}function respondWithFilteredResult(_0x4cd2bf,_0x267dfb){return function(_0x15c9de){if(_0x15c9de){var _0x53787a=typeof _0x267dfb[_0x0fd2('0x1d')]==='undefined'&&typeof _0x267dfb[_0x0fd2('0x1e')]===_0x0fd2('0x1f');var _0x3fb07e=_0x15c9de[_0x0fd2('0x20')];var _0x2977ef=_0x53787a?0x0:_0x267dfb[_0x0fd2('0x1d')];var _0x3ea260=_0x53787a?_0x15c9de[_0x0fd2('0x20')]:_0x267dfb[_0x0fd2('0x1d')]+_0x267dfb[_0x0fd2('0x1e')];var _0x5c50ad;if(_0x3ea260>=_0x3fb07e){_0x3ea260=_0x3fb07e;_0x5c50ad=0xc8;}else{_0x5c50ad=0xce;}_0x4cd2bf['status'](_0x5c50ad);return _0x4cd2bf['set'](_0x0fd2('0x21'),_0x2977ef+'-'+_0x3ea260+'/'+_0x3fb07e)[_0x0fd2('0x1c')](_0x15c9de);}return null;};}function patchUpdates(_0x53ab17){return function(_0x48586c){try{jsonpatch[_0x0fd2('0x22')](_0x48586c,_0x53ab17,!![]);}catch(_0x25563c){return BPromise[_0x0fd2('0x23')](_0x25563c);}return _0x48586c[_0x0fd2('0x24')]();};}function saveUpdates(_0x25cdd2,_0x5d15ed){return function(_0x233b01){if(_0x233b01){return _0x233b01[_0x0fd2('0x25')](_0x25cdd2)[_0x0fd2('0x26')](function(_0x54cce1){return _0x54cce1;});}return null;};}function removeEntity(_0x4c77a8,_0x11bb10){return function(_0x2a45e1){if(_0x2a45e1){return _0x2a45e1['destroy']()[_0x0fd2('0x26')](function(){var _0x429fef=_0x2a45e1[_0x0fd2('0x27')]({'plain':!![]});var _0x1defb4=[{'name':_0x0fd2('0x28'),'value':_0x0fd2('0x29'),'ignore':![]},{'name':_0x0fd2('0x2a'),'value':_0x0fd2('0x2b'),'ignore':![]}];var _0x5b32df=_(_0x1defb4)[_0x0fd2('0x2c')](_0x0fd2('0x2d'))[_0x0fd2('0x2e')](_0x0fd2('0x2f'))[_0x0fd2('0x2f')]();if(_['includes'](_0x5b32df,_0x429fef[_0x0fd2('0x30')])){return;}var _0x33335b=_[_0x0fd2('0x31')](_0x1defb4,[_0x0fd2('0x2f'),_0x429fef[_0x0fd2('0x30')]])[_0x0fd2('0x32')];return db[_0x0fd2('0x33')][_0x0fd2('0x34')]({'where':{'type':_0x33335b,'resourceId':_0x429fef['id']}})['then'](function(){return _0x2a45e1;});})[_0x0fd2('0x26')](function(){_0x4c77a8['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x1828cc,_0x553715){return function(_0x2faac3){if(!_0x2faac3){_0x1828cc['sendStatus'](0x194);}return _0x2faac3;};}function handleError(_0x244095,_0x53f585){_0x53f585=_0x53f585||0x1f4;return function(_0x5caeff){logger[_0x0fd2('0x35')](_0x5caeff[_0x0fd2('0x36')]);if(_0x5caeff[_0x0fd2('0x32')]){delete _0x5caeff['name'];}_0x244095['status'](_0x53f585)[_0x0fd2('0x37')](_0x5caeff);};}exports['index']=function(_0x11917f,_0x6b6cb4){var _0x803113={},_0x44167a={},_0x12f9ad={'count':0x0,'rows':[]};var _0x2975fb=_[_0x0fd2('0x2e')](db['VoiceQueue'][_0x0fd2('0x38')],function(_0x2ccfbe){return{'name':_0x2ccfbe['fieldName'],'type':_0x2ccfbe['type'][_0x0fd2('0x39')]};});_0x44167a['model']=_['map'](_0x2975fb,_0x0fd2('0x32'));_0x44167a[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x11917f[_0x0fd2('0x3a')]);_0x44167a[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x44167a[_0x0fd2('0x3e')],_0x44167a[_0x0fd2('0x3a')]);_0x803113[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x44167a[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x803113[_0x0fd2('0x3f')]=_0x803113[_0x0fd2('0x3f')]['length']?_0x803113[_0x0fd2('0x3f')]:_0x44167a[_0x0fd2('0x3e')];if(!_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x41')]('nolimit')){_0x803113[_0x0fd2('0x1e')]=qs['limit'](_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x803113['offset']=qs[_0x0fd2('0x1d')](_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}_0x803113[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x11917f[_0x0fd2('0x3a')]['sort']);_0x803113[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x11917f[_0x0fd2('0x3a')],_0x44167a[_0x0fd2('0x3c')]),_0x2975fb);if(_0x11917f['query'][_0x0fd2('0x2c')]){_0x803113[_0x0fd2('0x44')]=_['merge'](_0x803113[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x2975fb,function(_0x400b49){if(_0x400b49[_0x0fd2('0x30')]!==_0x0fd2('0x46')){var _0x22c89d={};_0x22c89d[_0x400b49[_0x0fd2('0x32')]]={'$like':'%'+_0x11917f[_0x0fd2('0x3a')]['filter']+'%'};return _0x22c89d;}})});}_0x803113=_['merge']({},_0x803113,_0x11917f[_0x0fd2('0x47')]);var _0x19d9e2={'where':_0x803113['where']};return db[_0x0fd2('0x48')]['count'](_0x19d9e2)[_0x0fd2('0x26')](function(_0x241570){_0x12f9ad[_0x0fd2('0x20')]=_0x241570;if(_0x11917f[_0x0fd2('0x3a')][_0x0fd2('0x49')]){_0x803113[_0x0fd2('0x4a')]=[{'all':!![]}];}return db['VoiceQueue']['findAll'](_0x803113);})[_0x0fd2('0x26')](function(_0x5065dc){_0x12f9ad[_0x0fd2('0x4b')]=_0x5065dc;return _0x12f9ad;})[_0x0fd2('0x26')](respondWithFilteredResult(_0x6b6cb4,_0x803113))[_0x0fd2('0x4c')](handleError(_0x6b6cb4,null));};exports[_0x0fd2('0x4d')]=function(_0x2f47f9,_0x500d1a){var _0x1bbe6a={'raw':![],'where':{'id':_0x2f47f9[_0x0fd2('0x4e')]['id']}},_0x49f5c2={};_0x49f5c2[_0x0fd2('0x3e')]=_['keys'](db[_0x0fd2('0x48')]['rawAttributes']);_0x49f5c2['query']=_[_0x0fd2('0x3b')](_0x2f47f9[_0x0fd2('0x3a')]);_0x49f5c2[_0x0fd2('0x3c')]=_['intersection'](_0x49f5c2[_0x0fd2('0x3e')],_0x49f5c2[_0x0fd2('0x3a')]);_0x1bbe6a[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x49f5c2['model'],qs[_0x0fd2('0x40')](_0x2f47f9[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x1bbe6a[_0x0fd2('0x3f')]=_0x1bbe6a[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x1bbe6a[_0x0fd2('0x3f')]:_0x49f5c2[_0x0fd2('0x3e')];if(_0x2f47f9[_0x0fd2('0x3a')][_0x0fd2('0x49')]){_0x1bbe6a[_0x0fd2('0x4a')]=[{'all':!![]}];}_0x1bbe6a=_['merge']({},_0x1bbe6a,_0x2f47f9[_0x0fd2('0x47')]);return db[_0x0fd2('0x48')]['find'](_0x1bbe6a)[_0x0fd2('0x26')](handleEntityNotFound(_0x500d1a,null))['then'](respondWithResult(_0x500d1a,null))[_0x0fd2('0x4c')](handleError(_0x500d1a,null));};exports[_0x0fd2('0x50')]=function(_0xe2cd72,_0xed36b3){return db[_0x0fd2('0x48')]['create'](_0xe2cd72[_0x0fd2('0x51')],{})[_0x0fd2('0x26')](function(_0x101509){var _0x4c1020=_0xe2cd72['user'][_0x0fd2('0x27')]({'plain':!![]});if(!_0x4c1020)throw new Error(_0x0fd2('0x52'));if(_0x4c1020[_0x0fd2('0x53')]===_0x0fd2('0x54')){var _0xec149c=_0x101509[_0x0fd2('0x27')]({'plain':!![]});var _0x4a9fe1=[{'name':_0x0fd2('0x28'),'value':_0x0fd2('0x29')},{'name':_0x0fd2('0x2a'),'value':_0x0fd2('0x2b')}];var _0x379524=_[_0x0fd2('0x31')](_0x4a9fe1,[_0x0fd2('0x2f'),_0xec149c[_0x0fd2('0x30')]])[_0x0fd2('0x32')];return db[_0x0fd2('0x55')][_0x0fd2('0x31')]({'where':{'name':_0x379524,'userProfileId':_0x4c1020[_0x0fd2('0x56')]},'raw':!![]})[_0x0fd2('0x26')](function(_0x50929f){if(_0x50929f&&_0x50929f[_0x0fd2('0x57')]===0x0){return db[_0x0fd2('0x33')]['create']({'name':_0xec149c[_0x0fd2('0x32')],'resourceId':_0xec149c['id'],'type':_0x50929f[_0x0fd2('0x32')],'sectionId':_0x50929f['id']},{})[_0x0fd2('0x26')](function(){return _0x101509;});}else{return _0x101509;}})[_0x0fd2('0x4c')](function(_0x5674b3){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5674b3);throw _0x5674b3;});}return _0x101509;})[_0x0fd2('0x26')](respondWithResult(_0xed36b3,0xc9))[_0x0fd2('0x4c')](handleError(_0xed36b3,null));};exports[_0x0fd2('0x58')]=function(_0x27754d,_0x41dd02){var _0x1ba67f={'where':{'id':_0x27754d[_0x0fd2('0x4e')]['id']}},_0x47343a={};_0x47343a[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db['VoiceQueue']['rawAttributes']);_0x1ba67f['attributes']=_['intersection'](_0x47343a['model'],qs[_0x0fd2('0x40')](_0x27754d['query'][_0x0fd2('0x40')]));_0x1ba67f['attributes']=_0x1ba67f[_0x0fd2('0x3f')]['length']?_0x1ba67f[_0x0fd2('0x3f')]:_0x47343a[_0x0fd2('0x3e')];if(_0x27754d[_0x0fd2('0x3a')]['includeAll']){_0x1ba67f['include']=[{'all':!![]}];}_0x1ba67f=_[_0x0fd2('0x59')]({},_0x1ba67f,_0x27754d[_0x0fd2('0x47')]);return db[_0x0fd2('0x48')][_0x0fd2('0x31')](_0x1ba67f)[_0x0fd2('0x26')](handleEntityNotFound(_0x41dd02,null))[_0x0fd2('0x26')](function(_0x359ee2){if(_0x359ee2){var _0x44fd9d=_0x359ee2[_0x0fd2('0x27')]({'plain':!![]});_0x44fd9d=qs['omit'](_0x44fd9d,['id',_0x0fd2('0x5a'),_0x0fd2('0x5b')]);_0x27754d[_0x0fd2('0x51')]=_['omit'](_0x27754d[_0x0fd2('0x51')],['id','createdAt',_0x0fd2('0x5b')]);return db[_0x0fd2('0x48')][_0x0fd2('0x50')](_[_0x0fd2('0x59')](_0x44fd9d,_0x27754d[_0x0fd2('0x51')]),{'include':_0x27754d[_0x0fd2('0x3a')][_0x0fd2('0x49')]?[{'all':!![]}]:undefined})[_0x0fd2('0x26')](function(_0x53bb88){var _0x33530b=_0x27754d[_0x0fd2('0x54')]['get']({'plain':!![]});if(!_0x33530b)throw new Error(_0x0fd2('0x52'));if(_0x33530b[_0x0fd2('0x53')]===_0x0fd2('0x54')){var _0x58d2f1=_0x53bb88[_0x0fd2('0x27')]({'plain':!![]});var _0x43f751=[{'name':_0x0fd2('0x28'),'value':_0x0fd2('0x29')},{'name':_0x0fd2('0x2a'),'value':_0x0fd2('0x2b')}];var _0x1ed5db=_[_0x0fd2('0x31')](_0x43f751,[_0x0fd2('0x2f'),_0x58d2f1['type']])[_0x0fd2('0x32')];return db[_0x0fd2('0x55')][_0x0fd2('0x31')]({'where':{'name':_0x1ed5db,'userProfileId':_0x33530b['userProfileId']},'raw':!![]})[_0x0fd2('0x26')](function(_0x288212){if(_0x288212&&_0x288212[_0x0fd2('0x57')]===0x0){return db[_0x0fd2('0x33')][_0x0fd2('0x50')]({'name':_0x58d2f1['name'],'resourceId':_0x58d2f1['id'],'type':_0x288212['name'],'sectionId':_0x288212['id']},{})[_0x0fd2('0x26')](function(){return _0x53bb88;});}else{return _0x53bb88;}})[_0x0fd2('0x4c')](function(_0x39bd89){logger[_0x0fd2('0x35')](_0x0fd2('0x5c'),_0x39bd89);throw _0x39bd89;});}return _0x53bb88;});}})[_0x0fd2('0x26')](respondWithResult(_0x41dd02,0xc9))[_0x0fd2('0x4c')](handleError(_0x41dd02,null));};exports[_0x0fd2('0x25')]=function(_0x54aadc,_0x14f6fb){if(_0x54aadc[_0x0fd2('0x51')]['id']){delete _0x54aadc[_0x0fd2('0x51')]['id'];}return db[_0x0fd2('0x48')]['find']({'where':{'id':_0x54aadc[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x14f6fb,null))[_0x0fd2('0x26')](saveUpdates(_0x54aadc[_0x0fd2('0x51')],null))[_0x0fd2('0x26')](respondWithResult(_0x14f6fb,null))[_0x0fd2('0x4c')](handleError(_0x14f6fb,null));};exports[_0x0fd2('0x34')]=function(_0x16d33b,_0x404af9){return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x16d33b[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x404af9,null))[_0x0fd2('0x26')](removeEntity(_0x404af9,null))[_0x0fd2('0x4c')](handleError(_0x404af9,null));};exports[_0x0fd2('0x5d')]=function(_0x294e12,_0x3fb02f,_0x5e91c0){var _0x6660e4={'raw':![],'where':{}};var _0x3b4bfc={};var _0x32ee12={'count':0x0,'rows':[]};return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x294e12['params']['id']}})['then'](handleEntityNotFound(_0x3fb02f,null))[_0x0fd2('0x26')](function(_0x158899){if(_0x158899){_0x3b4bfc[_0x0fd2('0x3e')]=_['keys'](db[_0x0fd2('0x5f')][_0x0fd2('0x38')]);_0x3b4bfc[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x294e12[_0x0fd2('0x3a')]);_0x3b4bfc[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x3b4bfc[_0x0fd2('0x3e')],_0x3b4bfc[_0x0fd2('0x3a')]);_0x6660e4[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x3b4bfc[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x294e12[_0x0fd2('0x3a')]['fields']));_0x6660e4[_0x0fd2('0x3f')]=_0x6660e4[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x6660e4['attributes']:_0x3b4bfc[_0x0fd2('0x3e')];if(!_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x41')](_0x0fd2('0x60'))){_0x6660e4[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x6660e4[_0x0fd2('0x1d')]=qs['offset'](_0x294e12['query']['offset']);}_0x6660e4[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x6660e4[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_['pick'](_0x294e12[_0x0fd2('0x3a')],_0x3b4bfc['filters']));_0x6660e4[_0x0fd2('0x44')][_0x0fd2('0x61')]=_0x158899['id'];if(_0x294e12['query'][_0x0fd2('0x2c')]){_0x6660e4[_0x0fd2('0x44')]=_[_0x0fd2('0x59')](_0x6660e4['where'],{'$or':_[_0x0fd2('0x2e')](_0x6660e4[_0x0fd2('0x3f')],function(_0x5ee8bc){var _0x5659f6={};_0x5659f6[_0x5ee8bc]={'$like':'%'+_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0x5659f6;})});}_0x6660e4=_[_0x0fd2('0x59')]({},_0x6660e4,_0x294e12[_0x0fd2('0x47')]);return db[_0x0fd2('0x5f')]['count']({'where':_0x6660e4[_0x0fd2('0x44')]})[_0x0fd2('0x26')](function(_0x53a49c){_0x32ee12[_0x0fd2('0x20')]=_0x53a49c;if(_0x294e12[_0x0fd2('0x3a')][_0x0fd2('0x49')]){_0x6660e4[_0x0fd2('0x4a')]=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x6660e4);})[_0x0fd2('0x26')](function(_0x524528){_0x32ee12[_0x0fd2('0x4b')]=_0x524528;return _0x32ee12;});}})[_0x0fd2('0x26')](respondWithFilteredResult(_0x3fb02f,_0x6660e4))['catch'](handleError(_0x3fb02f,null));};exports['getHopperHistories']=function(_0x405814,_0x21d371,_0x2043f5){var _0x552dcd={'raw':!![],'where':{}};var _0x22c88a={};var _0x3883de={'count':0x0,'rows':[]};return db[_0x0fd2('0x48')]['findOne']({'where':{'id':_0x405814[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x21d371,null))['then'](function(_0x5cc6fe){if(_0x5cc6fe){_0x22c88a[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db[_0x0fd2('0x62')][_0x0fd2('0x38')]);_0x22c88a[_0x0fd2('0x3a')]=_['keys'](_0x405814[_0x0fd2('0x3a')]);_0x22c88a[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x22c88a[_0x0fd2('0x3e')],_0x22c88a[_0x0fd2('0x3a')]);_0x552dcd[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x22c88a[_0x0fd2('0x3e')],qs['fields'](_0x405814['query'][_0x0fd2('0x40')]));_0x552dcd[_0x0fd2('0x3f')]=_0x552dcd[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x552dcd['attributes']:_0x22c88a[_0x0fd2('0x3e')];if(!_0x405814[_0x0fd2('0x3a')]['hasOwnProperty']('nolimit')){_0x552dcd['limit']=qs[_0x0fd2('0x1e')](_0x405814[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x552dcd[_0x0fd2('0x1d')]=qs[_0x0fd2('0x1d')](_0x405814[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}_0x552dcd[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x405814[_0x0fd2('0x3a')]['sort']);_0x552dcd[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x405814[_0x0fd2('0x3a')],_0x22c88a[_0x0fd2('0x3c')]));_0x552dcd[_0x0fd2('0x44')][_0x0fd2('0x61')]=_0x5cc6fe['id'];if(_0x405814['query'][_0x0fd2('0x2c')]){_0x552dcd[_0x0fd2('0x44')]=_[_0x0fd2('0x59')](_0x552dcd[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x552dcd[_0x0fd2('0x3f')],function(_0x203979){var _0x4141de={};_0x4141de[_0x203979]={'$like':'%'+_0x405814['query'][_0x0fd2('0x2c')]+'%'};return _0x4141de;})});}_0x552dcd=_[_0x0fd2('0x59')]({},_0x552dcd,_0x405814[_0x0fd2('0x47')]);return db[_0x0fd2('0x62')][_0x0fd2('0x20')]({'where':_0x552dcd[_0x0fd2('0x44')]})['then'](function(_0x146f01){_0x3883de[_0x0fd2('0x20')]=_0x146f01;if(_0x405814['query'][_0x0fd2('0x49')]){_0x552dcd[_0x0fd2('0x4a')]=[{'all':!![]}];}return db['CmHopperHistory']['findAll'](_0x552dcd);})[_0x0fd2('0x26')](function(_0x27e6ac){_0x3883de[_0x0fd2('0x4b')]=_0x27e6ac;return _0x3883de;});}})[_0x0fd2('0x26')](respondWithFilteredResult(_0x21d371,_0x552dcd))['catch'](handleError(_0x21d371,null));};exports['getHopperFinals']=function(_0x12e136,_0x46d4f2,_0x35ec32){var _0x5b88fc={'raw':!![],'where':{}};var _0x2fa756={};var _0x2acc75={'count':0x0,'rows':[]};return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x12e136[_0x0fd2('0x4e')]['id']}})['then'](handleEntityNotFound(_0x46d4f2,null))[_0x0fd2('0x26')](function(_0x2f5c3b){if(_0x2f5c3b){_0x2fa756['model']=_[_0x0fd2('0x3b')](db[_0x0fd2('0x63')]['rawAttributes']);_0x2fa756[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x12e136[_0x0fd2('0x3a')]);_0x2fa756[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x2fa756[_0x0fd2('0x3e')],_0x2fa756[_0x0fd2('0x3a')]);_0x5b88fc[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x2fa756[_0x0fd2('0x3e')],qs['fields'](_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x5b88fc[_0x0fd2('0x3f')]=_0x5b88fc[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x5b88fc[_0x0fd2('0x3f')]:_0x2fa756[_0x0fd2('0x3e')];if(!_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x41')]('nolimit')){_0x5b88fc[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x5b88fc['offset']=qs[_0x0fd2('0x1d')](_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}_0x5b88fc['order']=qs['sort'](_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x5b88fc[_0x0fd2('0x44')]=qs['filters'](_[_0x0fd2('0x45')](_0x12e136[_0x0fd2('0x3a')],_0x2fa756['filters']));_0x5b88fc[_0x0fd2('0x44')][_0x0fd2('0x61')]=_0x2f5c3b['id'];if(_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x5b88fc[_0x0fd2('0x44')]=_['merge'](_0x5b88fc[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x5b88fc[_0x0fd2('0x3f')],function(_0x1260db){var _0x3dfe33={};_0x3dfe33[_0x1260db]={'$like':'%'+_0x12e136[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0x3dfe33;})});}_0x5b88fc=_['merge']({},_0x5b88fc,_0x12e136[_0x0fd2('0x47')]);return db[_0x0fd2('0x63')]['count']({'where':_0x5b88fc['where']})['then'](function(_0x3ab8c6){_0x2acc75['count']=_0x3ab8c6;if(_0x12e136['query'][_0x0fd2('0x49')]){_0x5b88fc['include']=[{'all':!![]}];}return db[_0x0fd2('0x63')][_0x0fd2('0x64')](_0x5b88fc);})['then'](function(_0x5d0ca9){_0x2acc75['rows']=_0x5d0ca9;return _0x2acc75;});}})['then'](respondWithFilteredResult(_0x46d4f2,_0x5b88fc))['catch'](handleError(_0x46d4f2,null));};exports[_0x0fd2('0x65')]=function(_0x244fd2,_0x50502e,_0x528fa4){var _0x453b8d={'raw':!![],'where':{}};var _0x1771ce={};var _0xf445a8={'count':0x0,'rows':[]};return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x244fd2[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x50502e,null))[_0x0fd2('0x26')](function(_0x2f56dd){if(_0x2f56dd){_0x1771ce[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db['CmHopperBlack'][_0x0fd2('0x38')]);_0x1771ce['query']=_[_0x0fd2('0x3b')](_0x244fd2[_0x0fd2('0x3a')]);_0x1771ce[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x1771ce['model'],_0x1771ce[_0x0fd2('0x3a')]);_0x453b8d[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x1771ce['model'],qs[_0x0fd2('0x40')](_0x244fd2[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x453b8d[_0x0fd2('0x3f')]=_0x453b8d[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x453b8d[_0x0fd2('0x3f')]:_0x1771ce[_0x0fd2('0x3e')];if(!_0x244fd2['query'][_0x0fd2('0x41')]('nolimit')){_0x453b8d[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x244fd2['query']['limit']);_0x453b8d[_0x0fd2('0x1d')]=qs[_0x0fd2('0x1d')](_0x244fd2[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}_0x453b8d[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x244fd2['query'][_0x0fd2('0x43')]);_0x453b8d[_0x0fd2('0x44')]=qs['filters'](_['pick'](_0x244fd2[_0x0fd2('0x3a')],_0x1771ce['filters']));_0x453b8d[_0x0fd2('0x44')][_0x0fd2('0x61')]=_0x2f56dd['id'];if(_0x244fd2[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x453b8d['where']=_[_0x0fd2('0x59')](_0x453b8d['where'],{'$or':_['map'](_0x453b8d[_0x0fd2('0x3f')],function(_0x1b7818){var _0x41e57e={};_0x41e57e[_0x1b7818]={'$like':'%'+_0x244fd2[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0x41e57e;})});}_0x453b8d=_['merge']({},_0x453b8d,_0x244fd2['options']);return db['CmHopperBlack']['count']({'where':_0x453b8d[_0x0fd2('0x44')]})['then'](function(_0x36b164){_0xf445a8[_0x0fd2('0x20')]=_0x36b164;if(_0x244fd2[_0x0fd2('0x3a')]['includeAll']){_0x453b8d[_0x0fd2('0x4a')]=[{'all':!![]}];}return db[_0x0fd2('0x66')][_0x0fd2('0x64')](_0x453b8d);})['then'](function(_0x1c0392){_0xf445a8[_0x0fd2('0x4b')]=_0x1c0392;return _0xf445a8;});}})[_0x0fd2('0x26')](respondWithFilteredResult(_0x50502e,_0x453b8d))[_0x0fd2('0x4c')](handleError(_0x50502e,null));};exports[_0x0fd2('0x67')]=function(_0x2dd7bd,_0x2fb19f,_0x1361ff){var _0x2311d8={};var _0x2fd8f8={};var _0xcc05d5;var _0x19f8c0;return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x2dd7bd[_0x0fd2('0x4e')]['id']}})['then'](handleEntityNotFound(_0x2fb19f,null))[_0x0fd2('0x26')](function(_0x4463eb){if(_0x4463eb){_0xcc05d5=_0x4463eb;_0x2fd8f8[_0x0fd2('0x3e')]=_['keys'](db[_0x0fd2('0x68')][_0x0fd2('0x38')]);_0x2fd8f8[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x2dd7bd[_0x0fd2('0x3a')]);_0x2fd8f8[_0x0fd2('0x3c')]=_['intersection'](_0x2fd8f8[_0x0fd2('0x3e')],_0x2fd8f8[_0x0fd2('0x3a')]);_0x2311d8[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x2fd8f8[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x2dd7bd[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x2311d8[_0x0fd2('0x3f')]=_0x2311d8[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x2311d8[_0x0fd2('0x3f')]:_0x2fd8f8[_0x0fd2('0x3e')];_0x2311d8[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x2dd7bd[_0x0fd2('0x3a')]['sort']);_0x2311d8[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x2dd7bd[_0x0fd2('0x3a')],_0x2fd8f8[_0x0fd2('0x3c')]));if(_0x2dd7bd[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x2311d8['where']=_[_0x0fd2('0x59')](_0x2311d8[_0x0fd2('0x44')],{'$or':_['map'](_0x2311d8[_0x0fd2('0x3f')],function(_0x425333){var _0x7e2917={};_0x7e2917[_0x425333]={'$like':'%'+_0x2dd7bd[_0x0fd2('0x3a')]['filter']+'%'};return _0x7e2917;})});}_0x2311d8=_['merge']({},_0x2311d8,_0x2dd7bd[_0x0fd2('0x47')]);return _0xcc05d5['getTeams'](_0x2311d8);}})['then'](function(_0x11db90){if(_0x11db90){_0x19f8c0=_0x11db90['length'];if(!_0x2dd7bd[_0x0fd2('0x3a')]['hasOwnProperty'](_0x0fd2('0x60'))){_0x2311d8[_0x0fd2('0x1e')]=qs['limit'](_0x2dd7bd[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x2311d8[_0x0fd2('0x1d')]=qs['offset'](_0x2dd7bd[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0xcc05d5['getTeams'](_0x2311d8);}})[_0x0fd2('0x26')](function(_0x293098){if(_0x293098){return _0x293098?{'count':_0x19f8c0,'rows':_0x293098}:null;}})[_0x0fd2('0x26')](respondWithResult(_0x2fb19f,null))[_0x0fd2('0x4c')](handleError(_0x2fb19f,null));};exports[_0x0fd2('0x69')]=function(_0x23db78,_0x2d97de,_0x5cb489){var _0x5a3809=_0x23db78[_0x0fd2('0x51')]['teams'];var _0x549306=_[_0x0fd2('0x2e')](_0x5a3809,'id');return db[_0x0fd2('0x68')][_0x0fd2('0x64')]({'where':{'id':_0x549306},'attributes':['id'],'include':[{'model':db['User'],'as':_0x0fd2('0x6a'),'attributes':['id',_0x0fd2('0x32'),'online',_0x0fd2('0x6b'),_0x0fd2('0x6c')],'raw':!![]}]})[_0x0fd2('0x26')](function(_0x45eb44){if(_0x45eb44){var _0x254999=_[_0x0fd2('0x6d')](_0x45eb44,function(_0x3cc23a){var _0x17b6ee=_0x3cc23a[_0x0fd2('0x27')]({'plain':!![]});_0x17b6ee[_0x0fd2('0x6a')]['forEach'](function(_0x5d1bd1){_0x5d1bd1['penalty']=_[_0x0fd2('0x31')](_0x5a3809,{'id':_0x17b6ee['id']})[_0x0fd2('0x6e')];});return _0x17b6ee[_0x0fd2('0x6a')];});return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x23db78[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](function(_0x30c8aa){return db[_0x0fd2('0x6f')]['transaction'](function(_0x8aa97d){return _0x30c8aa[_0x0fd2('0x69')](_0x549306,{'transaction':_0x8aa97d})[_0x0fd2('0x26')](function(){return BPromise[_0x0fd2('0x70')](_0x5a3809,function(_0x3ac89f){return db[_0x0fd2('0x71')][_0x0fd2('0x72')]({'TeamId':_0x3ac89f['id'],'VoiceQueueId':_0x23db78['params']['id'],'penalty':_0x3ac89f[_0x0fd2('0x6e')]},{'transaction':_0x8aa97d});});})[_0x0fd2('0x26')](function(){return BPromise['each'](_0x254999,function(_0x26b5b0){return db[_0x0fd2('0x73')]['findOrCreate']({'where':{'UserId':_0x26b5b0['id'],'VoiceQueueId':_0x23db78['params']['id']},'defaults':{'penalty':_0x26b5b0['penalty']},'transaction':_0x8aa97d});});})['then'](function(){return BPromise[_0x0fd2('0x70')](_[_0x0fd2('0x2c')](_0x254999,{'online':!![]}),function(_0x45f4be){return db[_0x0fd2('0x74')][_0x0fd2('0x72')]({'membername':_0x45f4be['name'],'UserId':_0x45f4be['id'],'queue_name':_0x30c8aa[_0x0fd2('0x32')],'VoiceQueueId':_0x30c8aa['id'],'interface':_['isNil'](_0x45f4be[_0x0fd2('0x6c')])?util[_0x0fd2('0x75')](_0x0fd2('0x76'),_0x45f4be[_0x0fd2('0x32')]):_0x45f4be['interface'],'paused':_0x45f4be['voicePause']||![],'penalty':_0x45f4be[_0x0fd2('0x6e')]},{'transaction':_0x8aa97d});});})[_0x0fd2('0x26')](function(){_0x254999[_0x0fd2('0x77')](function(_0x5592a5){socket[_0x0fd2('0x78')](_0x0fd2('0x79'),{'UserId':_0x5592a5['id'],'VoiceQueueId':_0x30c8aa['id']});});});});});}})[_0x0fd2('0x26')](respondWithStatusCode(_0x2d97de,null))[_0x0fd2('0x4c')](handleError(_0x2d97de,null));};exports[_0x0fd2('0x7a')]=function(_0x204295,_0x3acba7,_0x502625){return db[_0x0fd2('0x68')][_0x0fd2('0x64')]({'where':{'id':_0x204295[_0x0fd2('0x3a')]['ids']},'attributes':['id'],'include':[{'model':db[_0x0fd2('0x7b')],'as':_0x0fd2('0x6a'),'attributes':['id'],'raw':!![]}]})[_0x0fd2('0x26')](handleEntityNotFound(_0x3acba7,null))[_0x0fd2('0x26')](function(_0x2eee6e){var _0x2f46f0=_[_0x0fd2('0x2e')](_0x2eee6e,'id');var _0x930fd8=[];var _0x42359e=[];var _0x4055f4=squel['select']();_0x4055f4[_0x0fd2('0x7c')]('tq.TeamId')[_0x0fd2('0x7d')]('team_has_voice_queues','tq')[_0x0fd2('0x7e')](_0x0fd2('0x7f'),'ut',_0x0fd2('0x80'))[_0x0fd2('0x44')](_0x0fd2('0x81'),_0x204295[_0x0fd2('0x4e')]['id']);for(var _0x24676f=0x0;_0x24676f<_0x2eee6e['length'];_0x24676f+=0x1){let _0x4102c4=_0x2eee6e[_0x24676f];for(var _0x3cab70=0x0;_0x3cab70<_0x4102c4[_0x0fd2('0x6a')][_0x0fd2('0x4f')];_0x3cab70+=0x1){let _0x4af57f=_0x4102c4[_0x0fd2('0x6a')][_0x3cab70];var _0x5f54bb=_0x4055f4['clone']();_0x5f54bb[_0x0fd2('0x44')](_0x0fd2('0x82'),_0x4af57f['id']);_0x42359e[_0x0fd2('0x83')](db[_0x0fd2('0x6f')][_0x0fd2('0x3a')](_0x5f54bb[_0x0fd2('0x84')](),{'type':db[_0x0fd2('0x6f')][_0x0fd2('0x85')]['SELECT']})[_0x0fd2('0x26')](function(_0x1b8a6b){if(_0x1b8a6b[_0x0fd2('0x4f')]===0x1){return _0x4af57f['id'];}else{var _0x55bf30=_[_0x0fd2('0x86')](_['map'](_0x1b8a6b,_0x0fd2('0x87')),function(_0x329f21){return _[_0x0fd2('0x88')](_0x2f46f0,_0x329f21);});if(_0x55bf30){return _0x4af57f['id'];}}}));}}return BPromise['all'](_0x42359e)[_0x0fd2('0x26')](function(_0xfbbf6a){_0x930fd8=_(_0x930fd8)[_0x0fd2('0x89')](_0xfbbf6a)[_0x0fd2('0x8a')]()['value']();return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x204295[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](function(_0x1ea889){return db[_0x0fd2('0x6f')][_0x0fd2('0x8b')](function(_0x4ef946){return _0x1ea889[_0x0fd2('0x7a')](_0x204295[_0x0fd2('0x3a')]['ids'],{'transaction':_0x4ef946})[_0x0fd2('0x26')](function(){if(!_['isEmpty'](_0x930fd8)){return _0x1ea889[_0x0fd2('0x8c')](_0x930fd8,{'transaction':_0x4ef946})[_0x0fd2('0x26')](function(){return db[_0x0fd2('0x74')][_0x0fd2('0x34')]({'where':{'VoiceQueueId':_0x204295[_0x0fd2('0x4e')]['id'],'UserId':_0x930fd8},'transaction':_0x4ef946});});}})['then'](function(){_0x930fd8['forEach'](function(_0x337a61){socket['emit'](_0x0fd2('0x8d'),{'UserId':_0x337a61,'VoiceQueueId':_0x1ea889['id']});});});});});});})[_0x0fd2('0x26')](respondWithStatusCode(_0x3acba7,null))[_0x0fd2('0x4c')](handleError(_0x3acba7,null));};exports[_0x0fd2('0x8e')]=function(_0x2b36ba,_0x8ec643,_0xd0380a){var _0x5e7a1e,_0x33fb11;return db[_0x0fd2('0x48')][_0x0fd2('0x31')]({'where':{'id':_0x2b36ba[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x8ec643,null))[_0x0fd2('0x26')](function(_0x45a93b){if(_0x45a93b){_0x33fb11=_0x45a93b;return _0x45a93b[_0x0fd2('0x8e')](_0x2b36ba[_0x0fd2('0x51')]['ids'],_[_0x0fd2('0x8f')](_0x2b36ba[_0x0fd2('0x51')],[_0x0fd2('0x90'),'id'])||{})[_0x0fd2('0x91')](function(_0x489a04){for(var _0x56fa58=0x0;_0x56fa58<_0x2b36ba[_0x0fd2('0x51')]['ids'][_0x0fd2('0x4f')];_0x56fa58+=0x1){socket[_0x0fd2('0x78')](_0x0fd2('0x79'),{'UserId':Number(_0x2b36ba[_0x0fd2('0x51')]['ids'][_0x56fa58]),'VoiceQueueId':Number(_0x2b36ba[_0x0fd2('0x4e')]['id'])});}return _0x489a04;});}})[_0x0fd2('0x26')](function(_0x278640){_0x5e7a1e=_0x278640||[];if(_0x33fb11){return db[_0x0fd2('0x7b')]['findAll']({'where':{'id':_0x2b36ba[_0x0fd2('0x51')]['ids']},'attributes':['id',_0x0fd2('0x32'),_0x0fd2('0x92'),'voicePause','interface'],'raw':!![]});}})['then'](function(_0x2e2316){if(!_[_0x0fd2('0x93')](_0x2e2316)){var _0x44c4f6=[];for(var _0x5dce22=0x0;_0x5dce22<_0x2e2316[_0x0fd2('0x4f')];_0x5dce22++){if(_0x2e2316[_0x5dce22][_0x0fd2('0x92')]){_0x44c4f6[_0x0fd2('0x83')](db['UserVoiceQueueRt'][_0x0fd2('0x72')]({'membername':_0x2e2316[_0x5dce22][_0x0fd2('0x32')],'UserId':_0x2e2316[_0x5dce22]['id'],'queue_name':_0x33fb11[_0x0fd2('0x32')],'VoiceQueueId':_0x33fb11['id'],'interface':_[_0x0fd2('0x94')](_0x2e2316[_0x5dce22][_0x0fd2('0x6c')])?util['format'](_0x0fd2('0x76'),_0x2e2316[_0x5dce22][_0x0fd2('0x32')]):_0x2e2316[_0x5dce22]['interface'],'paused':_0x2e2316[_0x5dce22][_0x0fd2('0x6b')]||![],'penalty':_0x2b36ba['body'][_0x0fd2('0x6e')]||0x0}));}}return BPromise['all'](_0x44c4f6);}})['then'](function(){return _0x5e7a1e;})['then'](respondWithResult(_0x8ec643,null))[_0x0fd2('0x4c')](handleError(_0x8ec643,null));};exports[_0x0fd2('0x8c')]=function(_0x171fcd,_0x39d82a,_0x352e30){return db[_0x0fd2('0x48')][_0x0fd2('0x31')]({'where':{'id':_0x171fcd[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x39d82a,null))[_0x0fd2('0x26')](function(_0x25ec73){if(_0x25ec73){return _0x25ec73[_0x0fd2('0x8c')](_0x171fcd[_0x0fd2('0x3a')][_0x0fd2('0x90')])[_0x0fd2('0x26')](function(){if(_['isArray'](_0x171fcd[_0x0fd2('0x3a')][_0x0fd2('0x90')])){for(var _0xc64ae7=0x0;_0xc64ae7<_0x171fcd['query'][_0x0fd2('0x90')][_0x0fd2('0x4f')];_0xc64ae7+=0x1){socket['emit'](_0x0fd2('0x8d'),{'UserId':Number(_0x171fcd['query'][_0x0fd2('0x90')][_0xc64ae7]),'VoiceQueueId':Number(_0x171fcd[_0x0fd2('0x4e')]['id'])});}}else{socket[_0x0fd2('0x78')]('userVoiceQueue:remove',{'UserId':Number(_0x171fcd[_0x0fd2('0x3a')][_0x0fd2('0x90')]),'VoiceQueueId':Number(_0x171fcd[_0x0fd2('0x4e')]['id'])});}});}})[_0x0fd2('0x26')](function(_0x386e89){return db[_0x0fd2('0x74')][_0x0fd2('0x34')]({'where':{'VoiceQueueId':_0x171fcd['params']['id'],'UserId':_0x171fcd['query'][_0x0fd2('0x90')]}})[_0x0fd2('0x26')](function(){return _0x386e89;});})[_0x0fd2('0x26')](respondWithStatusCode(_0x39d82a,null))[_0x0fd2('0x4c')](handleError(_0x39d82a,null));};exports[_0x0fd2('0x95')]=function(_0x5288b4,_0x52581b,_0x36f6ad){var _0x38c3dc={};var _0x40d38a={};var _0xcb396d;var _0x3da13b;return db['VoiceQueue'][_0x0fd2('0x5e')]({'where':{'id':_0x5288b4[_0x0fd2('0x4e')]['id']}})['then'](handleEntityNotFound(_0x52581b,null))[_0x0fd2('0x26')](function(_0x12c6fd){if(_0x12c6fd){_0xcb396d=_0x12c6fd;_0x40d38a[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db[_0x0fd2('0x7b')]['rawAttributes']);_0x40d38a[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x5288b4[_0x0fd2('0x3a')]);_0x40d38a['filters']=_[_0x0fd2('0x3d')](_0x40d38a[_0x0fd2('0x3e')],_0x40d38a[_0x0fd2('0x3a')]);_0x38c3dc[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x40d38a[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x38c3dc[_0x0fd2('0x3f')]=_0x38c3dc[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x38c3dc['attributes']:_0x40d38a[_0x0fd2('0x3e')];_0x38c3dc[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x38c3dc['where']=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x5288b4[_0x0fd2('0x3a')],_0x40d38a[_0x0fd2('0x3c')]));if(_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x38c3dc[_0x0fd2('0x44')]=_[_0x0fd2('0x59')](_0x38c3dc['where'],{'$or':_[_0x0fd2('0x2e')](_0x38c3dc['attributes'],function(_0x838146){var _0x46c7de={};_0x46c7de[_0x838146]={'$like':'%'+_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0x46c7de;})});}_0x38c3dc=_[_0x0fd2('0x59')]({},_0x38c3dc,_0x5288b4[_0x0fd2('0x47')]);return _0xcb396d[_0x0fd2('0x95')](_0x38c3dc);}})[_0x0fd2('0x26')](function(_0x9e4ce8){if(_0x9e4ce8){_0x3da13b=_0x9e4ce8[_0x0fd2('0x4f')];if(!_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x41')](_0x0fd2('0x60'))){_0x38c3dc[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x5288b4['query'][_0x0fd2('0x1e')]);_0x38c3dc['offset']=qs['offset'](_0x5288b4[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0xcb396d[_0x0fd2('0x95')](_0x38c3dc);}})['then'](function(_0x389a13){if(_0x389a13){return _0x389a13?{'count':_0x3da13b,'rows':_0x389a13}:null;}})[_0x0fd2('0x26')](respondWithResult(_0x52581b,null))[_0x0fd2('0x4c')](handleError(_0x52581b,null));};exports['getMembers']=function(_0x2d72d3,_0x13d21f,_0x839fa2){var _0x2c937e={};var _0x2182ff={};var _0x57a3b7;var _0x4a560f;return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x2d72d3['params']['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x13d21f,null))[_0x0fd2('0x26')](function(_0xfb23b5){if(_0xfb23b5){_0x57a3b7=_0xfb23b5;_0x2182ff[_0x0fd2('0x3e')]=_[_0x0fd2('0x3b')](db[_0x0fd2('0x74')]['rawAttributes']);_0x2182ff[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x2d72d3[_0x0fd2('0x3a')]);_0x2182ff['filters']=_[_0x0fd2('0x3d')](_0x2182ff['model'],_0x2182ff['query']);_0x2c937e[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0x2182ff[_0x0fd2('0x3e')],qs['fields'](_0x2d72d3[_0x0fd2('0x3a')]['fields']));_0x2c937e[_0x0fd2('0x3f')]=_0x2c937e[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x2c937e['attributes']:_0x2182ff[_0x0fd2('0x3e')];_0x2c937e[_0x0fd2('0x42')]=qs[_0x0fd2('0x43')](_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x2c937e[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_[_0x0fd2('0x45')](_0x2d72d3['query'],_0x2182ff['filters']));if(_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x2c937e[_0x0fd2('0x44')]=_['merge'](_0x2c937e[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x2c937e['attributes'],function(_0x4cbf0b){var _0xbbdba={};_0xbbdba[_0x4cbf0b]={'$like':'%'+_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x2c')]+'%'};return _0xbbdba;})});}_0x2c937e=_[_0x0fd2('0x59')]({},_0x2c937e,_0x2d72d3[_0x0fd2('0x47')]);return _0x57a3b7[_0x0fd2('0x96')](_0x2c937e);}})['then'](function(_0xbc48){if(_0xbc48){_0x4a560f=_0xbc48['length'];if(!_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x41')](_0x0fd2('0x60'))){_0x2c937e[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x2c937e[_0x0fd2('0x1d')]=qs[_0x0fd2('0x1d')](_0x2d72d3[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0x57a3b7[_0x0fd2('0x96')](_0x2c937e);}})[_0x0fd2('0x26')](function(_0x46d429){return _0x46d429?{'count':_0x4a560f,'rows':_0x46d429}:null;})[_0x0fd2('0x26')](respondWithResult(_0x13d21f,null))[_0x0fd2('0x4c')](handleError(_0x13d21f,null));};exports[_0x0fd2('0x97')]=function(_0x591dab,_0x187f92,_0x26d3d5){var _0x522123={};var _0xe0bf92={};var _0x15c72e;var _0x59eca9;return db[_0x0fd2('0x48')][_0x0fd2('0x5e')]({'where':{'id':_0x591dab['params']['id']}})['then'](handleEntityNotFound(_0x187f92,null))[_0x0fd2('0x26')](function(_0x5d3ae7){if(_0x5d3ae7){_0x15c72e=_0x5d3ae7;_0xe0bf92['model']=_[_0x0fd2('0x3b')](db['CmList'][_0x0fd2('0x38')]);_0xe0bf92[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x591dab[_0x0fd2('0x3a')]);_0xe0bf92[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0xe0bf92[_0x0fd2('0x3e')],_0xe0bf92[_0x0fd2('0x3a')]);_0x522123[_0x0fd2('0x3f')]=_[_0x0fd2('0x3d')](_0xe0bf92[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x40')]));_0x522123['attributes']=_0x522123[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x522123['attributes']:_0xe0bf92[_0x0fd2('0x3e')];_0x522123['order']=qs[_0x0fd2('0x43')](_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x522123['where']=qs['filters'](_[_0x0fd2('0x45')](_0x591dab[_0x0fd2('0x3a')],_0xe0bf92[_0x0fd2('0x3c')]));if(_0x591dab['query'][_0x0fd2('0x2c')]){_0x522123[_0x0fd2('0x44')]=_[_0x0fd2('0x59')](_0x522123[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x522123[_0x0fd2('0x3f')],function(_0x3ce674){var _0x43f2c6={};_0x43f2c6[_0x3ce674]={'$like':'%'+_0x591dab['query']['filter']+'%'};return _0x43f2c6;})});}_0x522123=_[_0x0fd2('0x59')]({},_0x522123,_0x591dab[_0x0fd2('0x47')]);return _0x15c72e[_0x0fd2('0x97')](_0x522123);}})[_0x0fd2('0x26')](function(_0xaace5f){if(_0xaace5f){_0x59eca9=_0xaace5f[_0x0fd2('0x4f')];if(!_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x41')](_0x0fd2('0x60'))){_0x522123[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x522123[_0x0fd2('0x1d')]=qs[_0x0fd2('0x1d')](_0x591dab[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0x15c72e['getLists'](_0x522123);}})[_0x0fd2('0x26')](function(_0x451f31){if(_0x451f31){return _0x451f31?{'count':_0x59eca9,'rows':_0x451f31}:null;}})[_0x0fd2('0x26')](respondWithResult(_0x187f92,null))[_0x0fd2('0x4c')](handleError(_0x187f92,null));};exports[_0x0fd2('0x98')]=function(_0x468f7a,_0x4b0e7d,_0x4e1cef){var _0x2dc84d=moment()['format'](_0x0fd2('0x99'));var _0x1b61b2,_0x4f4b3b;return db[_0x0fd2('0x48')][_0x0fd2('0x31')]({'where':{'id':_0x468f7a[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x4b0e7d,null))['then'](function(_0x203fbe){if(_0x203fbe){_0x4f4b3b=_0x203fbe;return _0x203fbe[_0x0fd2('0x98')](_0x468f7a[_0x0fd2('0x51')][_0x0fd2('0x90')],_[_0x0fd2('0x8f')](_0x468f7a[_0x0fd2('0x51')],[_0x0fd2('0x90'),'id'])||{});}return null;})['spread'](function(_0x23a184){var _0x544885;_0x1b61b2=_0x23a184||[];var _0x6d0e63=[];if(_0x23a184){for(var _0x2379c0=0x0;_0x2379c0<_0x23a184[_0x0fd2('0x4f')];_0x2379c0+=0x1){var _0x285bd7=_0x23a184[_0x2379c0][_0x0fd2('0x27')]({'plain':!![]});_0x4f4b3b[_0x0fd2('0x9a')]=_0x468f7a['body'][_0x0fd2('0x9a')]?_0x468f7a[_0x0fd2('0x51')][_0x0fd2('0x9a')]:_0x4f4b3b[_0x0fd2('0x9a')];switch(_0x4f4b3b['dialCheckDuplicateType']){case _0x0fd2('0x9b'):_0x544885=squel[_0x0fd2('0x9c')]()['into'](_0x0fd2('0x9d'))[_0x0fd2('0x9e')]([_0x0fd2('0x9f'),'scheduledAt','ContactId',_0x0fd2('0xa0'),_0x0fd2('0x61'),_0x0fd2('0x5a'),'updatedAt'],squel['select']()[_0x0fd2('0x7c')](_0x0fd2('0x9f'),_0x0fd2('0x9f'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0xa1'))[_0x0fd2('0x7c')]('id',_0x0fd2('0xa2'))[_0x0fd2('0x7c')](_0x285bd7['CmListId'][_0x0fd2('0x84')](),_0x0fd2('0xa0'))[_0x0fd2('0x7c')](_0x468f7a[_0x0fd2('0x4e')]['id'][_0x0fd2('0x84')](),'VoiceQueueId')[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0x5a'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0x5b'))[_0x0fd2('0x7d')](_0x0fd2('0xa3'))[_0x0fd2('0x44')](_0x0fd2('0xa4'))[_0x0fd2('0x44')](_0x0fd2('0xa5'),_0x285bd7[_0x0fd2('0xa6')][_0x0fd2('0x84')]())[_0x0fd2('0x44')]('phone\x20IS\x20NOT\x20NULL')[_0x0fd2('0x44')](_0x0fd2('0xa7'),squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')]('COALESCE(calleridnum,\x27\x27)')[_0x0fd2('0x7d')]('cm_hopper_final')[_0x0fd2('0x44')]('VoiceQueueId\x20=\x20?',_0x468f7a[_0x0fd2('0x4e')]['id']['toString']()))[_0x0fd2('0x44')](_0x0fd2('0xa7'),squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')](_0x0fd2('0xa9'))[_0x0fd2('0x7d')](_0x0fd2('0x9d'))[_0x0fd2('0x44')](_0x0fd2('0x81'),_0x468f7a[_0x0fd2('0x4e')]['id'][_0x0fd2('0x84')]())))[_0x0fd2('0x84')]();break;case _0x0fd2('0xaa'):_0x544885=squel['insert']()[_0x0fd2('0xab')]('cm_hopper')['fromQuery']([_0x0fd2('0x9f'),_0x0fd2('0xa1'),_0x0fd2('0xa2'),_0x0fd2('0xa0'),_0x0fd2('0x61'),_0x0fd2('0x5a'),'updatedAt'],squel[_0x0fd2('0xa8')]()['field'](_0x0fd2('0x9f'),_0x0fd2('0x9f'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','scheduledAt')[_0x0fd2('0x7c')]('id',_0x0fd2('0xa2'))[_0x0fd2('0x7c')](_0x285bd7[_0x0fd2('0xa6')]['toString'](),_0x0fd2('0xa0'))[_0x0fd2('0x7c')](_0x468f7a[_0x0fd2('0x4e')]['id'][_0x0fd2('0x84')](),_0x0fd2('0x61'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','createdAt')[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','updatedAt')[_0x0fd2('0x7d')]('cm_contacts')[_0x0fd2('0x44')]('deletedAt\x20IS\x20NULL')[_0x0fd2('0x44')]('ListId\x20=\x20?',_0x285bd7['CmListId'][_0x0fd2('0x84')]())[_0x0fd2('0x44')](_0x0fd2('0xac'))[_0x0fd2('0x44')](_0x0fd2('0xa7'),squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')](_0x0fd2('0xa9'))[_0x0fd2('0x7d')]('cm_hopper')[_0x0fd2('0x44')]('VoiceQueueId\x20=\x20?',_0x468f7a[_0x0fd2('0x4e')]['id']['toString']())))[_0x0fd2('0x84')]();break;default:_0x544885=squel[_0x0fd2('0x9c')]()['into'](_0x0fd2('0x9d'))['fromQuery']([_0x0fd2('0x9f'),_0x0fd2('0xa1'),_0x0fd2('0xa2'),_0x0fd2('0xa0'),'VoiceQueueId',_0x0fd2('0x5a'),_0x0fd2('0x5b')],squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')](_0x0fd2('0x9f'),'phone')[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','scheduledAt')['field']('id','ContactId')[_0x0fd2('0x7c')](_0x285bd7[_0x0fd2('0xa6')]['toString'](),_0x0fd2('0xa0'))['field'](_0x468f7a[_0x0fd2('0x4e')]['id'][_0x0fd2('0x84')](),_0x0fd2('0x61'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','createdAt')[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0x5b'))[_0x0fd2('0x7d')](_0x0fd2('0xa3'))[_0x0fd2('0x44')]('deletedAt\x20IS\x20NULL')[_0x0fd2('0x44')]('ListId\x20=\x20?',_0x285bd7[_0x0fd2('0xa6')]['toString']())[_0x0fd2('0x44')](_0x0fd2('0xac')))[_0x0fd2('0x84')]();}_0x6d0e63[_0x0fd2('0x83')](db[_0x0fd2('0x6f')][_0x0fd2('0x3a')](_0x544885));}return BPromise['all'](_0x6d0e63);}})[_0x0fd2('0x26')](function(){var _0x4b2a0e=[];var _0x1ad987=squel[_0x0fd2('0x9c')]()[_0x0fd2('0xab')]('cm_hopper_additional_phones')[_0x0fd2('0x9e')]([_0x0fd2('0xad'),'phone',_0x0fd2('0xae'),_0x0fd2('0x5a'),'updatedAt'],squel[_0x0fd2('0xa8')]()[_0x0fd2('0x7c')]('h.id')[_0x0fd2('0x7c')](_0x0fd2('0xaf'))[_0x0fd2('0x7c')](_0x0fd2('0xb0'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27',_0x0fd2('0x5a'))[_0x0fd2('0x7c')]('\x27'+_0x2dc84d+'\x27','updatedAt')[_0x0fd2('0x7d')](_0x0fd2('0xb1'),'ci')[_0x0fd2('0x7e')](_0x0fd2('0x9d'),'h','h.ContactId=ci.CmContactId')[_0x0fd2('0x44')](_0x0fd2('0xb2'),_0x2dc84d)[_0x0fd2('0x44')](_0x0fd2('0xb3'),_0x0fd2('0xb4')))[_0x0fd2('0x84')]();_0x4b2a0e['push'](db[_0x0fd2('0x6f')]['query'](_0x1ad987));return BPromise[_0x0fd2('0xb5')](_0x4b2a0e);})[_0x0fd2('0x26')](function(){return _0x1b61b2;})['then'](respondWithResult(_0x4b0e7d,null))['catch'](handleError(_0x4b0e7d,null));};exports[_0x0fd2('0xb6')]=function(_0x3878eb,_0x5383ea,_0x260a1d){return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x3878eb['params']['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x5383ea,null))[_0x0fd2('0x26')](function(_0x4fd20b){if(_0x4fd20b){return _0x4fd20b[_0x0fd2('0xb6')](_0x3878eb[_0x0fd2('0x3a')][_0x0fd2('0x90')]);}})[_0x0fd2('0x26')](function(_0x318144){if(_0x318144){return db[_0x0fd2('0x5f')][_0x0fd2('0x34')]({'where':{'ListId':_0x3878eb[_0x0fd2('0x3a')][_0x0fd2('0x90')],'VoiceQueueId':_0x3878eb[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](function(){return _0x318144;});}})[_0x0fd2('0x26')](respondWithStatusCode(_0x5383ea,null))[_0x0fd2('0x4c')](handleError(_0x5383ea,null));};exports['getBlackLists']=function(_0x51b80a,_0x54585d,_0x407be5){var _0x241914={};var _0x64e087={};var _0x35479a;var _0x81b4bb;return db[_0x0fd2('0x48')]['findOne']({'where':{'id':_0x51b80a[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x54585d,null))['then'](function(_0x2ec276){if(_0x2ec276){_0x35479a=_0x2ec276;_0x64e087['model']=_[_0x0fd2('0x3b')](db[_0x0fd2('0xb7')][_0x0fd2('0x38')]);_0x64e087[_0x0fd2('0x3a')]=_[_0x0fd2('0x3b')](_0x51b80a[_0x0fd2('0x3a')]);_0x64e087[_0x0fd2('0x3c')]=_[_0x0fd2('0x3d')](_0x64e087[_0x0fd2('0x3e')],_0x64e087[_0x0fd2('0x3a')]);_0x241914[_0x0fd2('0x3f')]=_['intersection'](_0x64e087[_0x0fd2('0x3e')],qs[_0x0fd2('0x40')](_0x51b80a[_0x0fd2('0x3a')]['fields']));_0x241914['attributes']=_0x241914[_0x0fd2('0x3f')][_0x0fd2('0x4f')]?_0x241914[_0x0fd2('0x3f')]:_0x64e087[_0x0fd2('0x3e')];_0x241914['order']=qs[_0x0fd2('0x43')](_0x51b80a[_0x0fd2('0x3a')][_0x0fd2('0x43')]);_0x241914[_0x0fd2('0x44')]=qs[_0x0fd2('0x3c')](_['pick'](_0x51b80a['query'],_0x64e087[_0x0fd2('0x3c')]));if(_0x51b80a[_0x0fd2('0x3a')][_0x0fd2('0x2c')]){_0x241914[_0x0fd2('0x44')]=_['merge'](_0x241914[_0x0fd2('0x44')],{'$or':_[_0x0fd2('0x2e')](_0x241914[_0x0fd2('0x3f')],function(_0x2c7824){var _0x1ec0da={};_0x1ec0da[_0x2c7824]={'$like':'%'+_0x51b80a['query']['filter']+'%'};return _0x1ec0da;})});}_0x241914=_[_0x0fd2('0x59')]({},_0x241914,_0x51b80a[_0x0fd2('0x47')]);return _0x35479a[_0x0fd2('0xb8')](_0x241914);}})[_0x0fd2('0x26')](function(_0x5a3e6d){if(_0x5a3e6d){_0x81b4bb=_0x5a3e6d[_0x0fd2('0x4f')];if(!_0x51b80a['query']['hasOwnProperty'](_0x0fd2('0x60'))){_0x241914[_0x0fd2('0x1e')]=qs[_0x0fd2('0x1e')](_0x51b80a[_0x0fd2('0x3a')][_0x0fd2('0x1e')]);_0x241914['offset']=qs[_0x0fd2('0x1d')](_0x51b80a[_0x0fd2('0x3a')][_0x0fd2('0x1d')]);}return _0x35479a[_0x0fd2('0xb8')](_0x241914);}})['then'](function(_0x4567ad){if(_0x4567ad){return _0x4567ad?{'count':_0x81b4bb,'rows':_0x4567ad}:null;}})[_0x0fd2('0x26')](respondWithResult(_0x54585d,null))[_0x0fd2('0x4c')](handleError(_0x54585d,null));};exports[_0x0fd2('0xb9')]=function(_0x30ef90,_0x6ea2c8,_0x17a770){var _0x34b662,_0x14df62;return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x30ef90[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x6ea2c8,null))[_0x0fd2('0x26')](function(_0x3c0c6c){if(_0x3c0c6c){_0x14df62=_0x3c0c6c;return _0x3c0c6c[_0x0fd2('0xb9')](_0x30ef90[_0x0fd2('0x51')]['ids'],_[_0x0fd2('0x8f')](_0x30ef90[_0x0fd2('0x51')],[_0x0fd2('0x90'),'id'])||{});}return null;})[_0x0fd2('0x91')](function(_0x1da9f3){var _0x50e7ba;_0x34b662=_0x1da9f3||[];var _0x1739c7=[];if(_0x1da9f3){for(var _0x59618c=0x0;_0x59618c<_0x1da9f3[_0x0fd2('0x4f')];_0x59618c+=0x1){var _0x18ec77=_0x1da9f3[_0x59618c][_0x0fd2('0x27')]({'plain':!![]});_0x50e7ba=squel[_0x0fd2('0x9c')]()[_0x0fd2('0xab')](_0x0fd2('0xba'))[_0x0fd2('0x9e')]([_0x0fd2('0x9f'),_0x0fd2('0xa2'),_0x0fd2('0xa0'),'VoiceQueueId',_0x0fd2('0x5a'),_0x0fd2('0x5b')],squel['select']()[_0x0fd2('0x7c')](_0x0fd2('0x9f'),_0x0fd2('0x9f'))[_0x0fd2('0x7c')]('id',_0x0fd2('0xa2'))[_0x0fd2('0x7c')](_0x18ec77[_0x0fd2('0xa6')][_0x0fd2('0x84')](),'ListId')[_0x0fd2('0x7c')](_0x30ef90['params']['id'][_0x0fd2('0x84')](),_0x0fd2('0x61'))[_0x0fd2('0x7c')](_0x0fd2('0xbb'),_0x0fd2('0x5a'))[_0x0fd2('0x7c')](_0x0fd2('0xbb'),_0x0fd2('0x5b'))[_0x0fd2('0x7d')](_0x0fd2('0xa3'))[_0x0fd2('0x44')](_0x0fd2('0xa4'))[_0x0fd2('0x44')](_0x0fd2('0xa5'),_0x18ec77[_0x0fd2('0xa6')][_0x0fd2('0x84')]())[_0x0fd2('0x44')](_0x0fd2('0xac')))['toString']();_0x1739c7['push'](db[_0x0fd2('0x6f')][_0x0fd2('0x3a')](_0x50e7ba));}return BPromise[_0x0fd2('0xb5')](_0x1739c7);}})[_0x0fd2('0x26')](function(){return _0x34b662;})[_0x0fd2('0x26')](respondWithResult(_0x6ea2c8,null))[_0x0fd2('0x4c')](handleError(_0x6ea2c8,null));};exports[_0x0fd2('0xbc')]=function(_0x2085ad,_0x44db9a,_0x5134d9){return db['VoiceQueue'][_0x0fd2('0x31')]({'where':{'id':_0x2085ad[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](handleEntityNotFound(_0x44db9a,null))[_0x0fd2('0x26')](function(_0x5af168){if(_0x5af168){return _0x5af168[_0x0fd2('0xbc')](_0x2085ad['query'][_0x0fd2('0x90')]);}})[_0x0fd2('0x26')](function(_0x30e702){if(_0x30e702){return db[_0x0fd2('0x66')][_0x0fd2('0x34')]({'where':{'ListId':_0x2085ad['query'][_0x0fd2('0x90')],'VoiceQueueId':_0x2085ad[_0x0fd2('0x4e')]['id']}})[_0x0fd2('0x26')](function(){return _0x30e702;});}})[_0x0fd2('0x26')](respondWithStatusCode(_0x44db9a,null))['catch'](handleError(_0x44db9a,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