// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa423=['ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','redis','localhost','socket.io-emitter','./voiceQueue.socket','register','sendStatus','end','offset','limit','undefined','count','status','Content-Range','json','apply','reject','save','update','then','inbound','QueueCampaigns','outbound','filter','ignore','value','includes','type','find','name','UserProfileResource','destroy','error','VoiceQueue','rawAttributes','fieldName','key','model','keys','filters','intersection','query','attributes','fields','length','hasOwnProperty','sort','where','pick','map','VIRTUAL','merge','includeAll','findAll','rows','catch','show','params','options','create','body','user','get','role','VoiceQueues','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','include','omit','createdAt','updatedAt','userProfileId','getHoppers','nolimit','order','VoiceQueueId','CmHopper','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','CmHopperBlack','getTeams','Team','teams','online','voicePause','interface','Agents','forEach','penalty','sequelize','transaction','addTeams','each','TeamVoiceQueue','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','format','SIP/%s','emit','userVoiceQueue:save','removeTeams','ids','select','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','QueryTypes','SELECT','every','TeamId','all','compact','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','User','push','isArray','getAgents','getMembers','getLists','CmList','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','insert','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','field','CmListId','toString','cm_contacts','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','COALESCE(phone,\x27\x27)','onlyIfOpen','into','deletedAt\x20IS\x20NULL','cm_hopper_additional_phones','h.id','ci.item','ci.OrderBy+1','PHONE','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0xa423,0x16c));var _0x3a42=function(_0x2250d9,_0x30e8f2){_0x2250d9=_0x2250d9-0x0;var _0x2a0cb3=_0xa423[_0x2250d9];return _0x2a0cb3;};'use strict';var emlformat=require(_0x3a42('0x0'));var rimraf=require(_0x3a42('0x1'));var zipdir=require(_0x3a42('0x2'));var jsonpatch=require(_0x3a42('0x3'));var rp=require(_0x3a42('0x4'));var moment=require('moment');var BPromise=require(_0x3a42('0x5'));var Mustache=require(_0x3a42('0x6'));var util=require('util');var path=require(_0x3a42('0x7'));var sox=require(_0x3a42('0x8'));var csv=require(_0x3a42('0x9'));var ejs=require(_0x3a42('0xa'));var fs=require('fs');var fs_extra=require(_0x3a42('0xb'));var _=require('lodash');var squel=require(_0x3a42('0xc'));var crypto=require(_0x3a42('0xd'));var jsforce=require(_0x3a42('0xe'));var deskjs=require(_0x3a42('0xf'));var toCsv=require(_0x3a42('0x9'));var querystring=require(_0x3a42('0x10'));var Papa=require(_0x3a42('0x11'));var Redis=require(_0x3a42('0x12'));var authService=require(_0x3a42('0x13'));var qs=require(_0x3a42('0x14'));var as=require(_0x3a42('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x3a42('0x16'))(_0x3a42('0x17'));var utils=require(_0x3a42('0x18'));var config=require(_0x3a42('0x19'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config[_0x3a42('0x1a')]=_['defaults'](config[_0x3a42('0x1a')],{'host':_0x3a42('0x1b'),'port':0x18eb});var socket=require(_0x3a42('0x1c'))(new Redis(config[_0x3a42('0x1a')]));require(_0x3a42('0x1d'))[_0x3a42('0x1e')](socket);function respondWithStatusCode(_0x5f5244,_0xd32889){_0xd32889=_0xd32889||0xcc;return function(_0x4f715c){if(_0x4f715c){return _0x5f5244[_0x3a42('0x1f')](_0xd32889);}return _0x5f5244['status'](_0xd32889)[_0x3a42('0x20')]();};}function respondWithResult(_0x5895a8,_0x46ef1e){_0x46ef1e=_0x46ef1e||0xc8;return function(_0x4edcf5){if(_0x4edcf5){return _0x5895a8['status'](_0x46ef1e)['json'](_0x4edcf5);}};}function respondWithFilteredResult(_0x26c844,_0x3a1dd0){return function(_0x438cf1){if(_0x438cf1){var _0x39e620=typeof _0x3a1dd0[_0x3a42('0x21')]==='undefined'&&typeof _0x3a1dd0[_0x3a42('0x22')]===_0x3a42('0x23');var _0x49f00e=_0x438cf1[_0x3a42('0x24')];var _0xa89087=_0x39e620?0x0:_0x3a1dd0[_0x3a42('0x21')];var _0x59f337=_0x39e620?_0x438cf1[_0x3a42('0x24')]:_0x3a1dd0[_0x3a42('0x21')]+_0x3a1dd0[_0x3a42('0x22')];var _0x477605;if(_0x59f337>=_0x49f00e){_0x59f337=_0x49f00e;_0x477605=0xc8;}else{_0x477605=0xce;}_0x26c844[_0x3a42('0x25')](_0x477605);return _0x26c844['set'](_0x3a42('0x26'),_0xa89087+'-'+_0x59f337+'/'+_0x49f00e)[_0x3a42('0x27')](_0x438cf1);}return null;};}function patchUpdates(_0x379fe6){return function(_0x434283){try{jsonpatch[_0x3a42('0x28')](_0x434283,_0x379fe6,!![]);}catch(_0x5b41d2){return BPromise[_0x3a42('0x29')](_0x5b41d2);}return _0x434283[_0x3a42('0x2a')]();};}function saveUpdates(_0x477cb9,_0x1add9b){return function(_0x1540e5){if(_0x1540e5){return _0x1540e5[_0x3a42('0x2b')](_0x477cb9)[_0x3a42('0x2c')](function(_0x434044){return _0x434044;});}return null;};}function removeEntity(_0x2c4b3a,_0x3a3f87){return function(_0x29a4d0){if(_0x29a4d0){return _0x29a4d0['destroy']()[_0x3a42('0x2c')](function(){var _0x468ea8=_0x29a4d0['get']({'plain':!![]});var _0x3027dd=[{'name':'VoiceQueues','value':_0x3a42('0x2d'),'ignore':![]},{'name':_0x3a42('0x2e'),'value':_0x3a42('0x2f'),'ignore':![]}];var _0x299282=_(_0x3027dd)[_0x3a42('0x30')](_0x3a42('0x31'))['map'](_0x3a42('0x32'))[_0x3a42('0x32')]();if(_[_0x3a42('0x33')](_0x299282,_0x468ea8[_0x3a42('0x34')])){return;}var _0x1c8fe1=_[_0x3a42('0x35')](_0x3027dd,[_0x3a42('0x32'),_0x468ea8['type']])[_0x3a42('0x36')];return db[_0x3a42('0x37')][_0x3a42('0x38')]({'where':{'type':_0x1c8fe1,'resourceId':_0x468ea8['id']}})[_0x3a42('0x2c')](function(){return _0x29a4d0;});})[_0x3a42('0x2c')](function(){_0x2c4b3a['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x1032eb,_0x51871b){return function(_0x3fb07d){if(!_0x3fb07d){_0x1032eb[_0x3a42('0x1f')](0x194);}return _0x3fb07d;};}function handleError(_0x2bbfe4,_0x421d3b){_0x421d3b=_0x421d3b||0x1f4;return function(_0x37defa){logger[_0x3a42('0x39')](_0x37defa['stack']);if(_0x37defa[_0x3a42('0x36')]){delete _0x37defa[_0x3a42('0x36')];}_0x2bbfe4[_0x3a42('0x25')](_0x421d3b)['send'](_0x37defa);};}exports['index']=function(_0x41df56,_0x3f21ed){var _0xb2f1d3={},_0xe51e6={},_0xb297ad={'count':0x0,'rows':[]};var _0x4e872b=_['map'](db[_0x3a42('0x3a')][_0x3a42('0x3b')],function(_0x6a44e8){return{'name':_0x6a44e8[_0x3a42('0x3c')],'type':_0x6a44e8['type'][_0x3a42('0x3d')]};});_0xe51e6[_0x3a42('0x3e')]=_['map'](_0x4e872b,'name');_0xe51e6['query']=_[_0x3a42('0x3f')](_0x41df56['query']);_0xe51e6[_0x3a42('0x40')]=_[_0x3a42('0x41')](_0xe51e6[_0x3a42('0x3e')],_0xe51e6[_0x3a42('0x42')]);_0xb2f1d3[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0xe51e6[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x41df56[_0x3a42('0x42')]['fields']));_0xb2f1d3[_0x3a42('0x43')]=_0xb2f1d3[_0x3a42('0x43')][_0x3a42('0x45')]?_0xb2f1d3[_0x3a42('0x43')]:_0xe51e6[_0x3a42('0x3e')];if(!_0x41df56['query'][_0x3a42('0x46')]('nolimit')){_0xb2f1d3['limit']=qs['limit'](_0x41df56['query'][_0x3a42('0x22')]);_0xb2f1d3['offset']=qs['offset'](_0x41df56['query'][_0x3a42('0x21')]);}_0xb2f1d3['order']=qs['sort'](_0x41df56[_0x3a42('0x42')][_0x3a42('0x47')]);_0xb2f1d3[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x41df56[_0x3a42('0x42')],_0xe51e6['filters']),_0x4e872b);if(_0x41df56[_0x3a42('0x42')][_0x3a42('0x30')]){_0xb2f1d3[_0x3a42('0x48')]=_['merge'](_0xb2f1d3[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x4e872b,function(_0x4f5f18){if(_0x4f5f18[_0x3a42('0x34')]!==_0x3a42('0x4b')){var _0x3b7e7d={};_0x3b7e7d[_0x4f5f18[_0x3a42('0x36')]]={'$like':'%'+_0x41df56[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x3b7e7d;}})});}_0xb2f1d3=_[_0x3a42('0x4c')]({},_0xb2f1d3,_0x41df56['options']);var _0x384758={'where':_0xb2f1d3[_0x3a42('0x48')]};return db[_0x3a42('0x3a')][_0x3a42('0x24')](_0x384758)[_0x3a42('0x2c')](function(_0x4f6f26){_0xb297ad[_0x3a42('0x24')]=_0x4f6f26;if(_0x41df56[_0x3a42('0x42')][_0x3a42('0x4d')]){_0xb2f1d3['include']=[{'all':!![]}];}return db[_0x3a42('0x3a')][_0x3a42('0x4e')](_0xb2f1d3);})[_0x3a42('0x2c')](function(_0x1645b8){_0xb297ad[_0x3a42('0x4f')]=_0x1645b8;return _0xb297ad;})['then'](respondWithFilteredResult(_0x3f21ed,_0xb2f1d3))[_0x3a42('0x50')](handleError(_0x3f21ed,null));};exports[_0x3a42('0x51')]=function(_0x3a3293,_0xa46b2a){var _0x52ab00={'raw':![],'where':{'id':_0x3a3293[_0x3a42('0x52')]['id']}},_0x2686a5={};_0x2686a5[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db[_0x3a42('0x3a')][_0x3a42('0x3b')]);_0x2686a5[_0x3a42('0x42')]=_['keys'](_0x3a3293[_0x3a42('0x42')]);_0x2686a5[_0x3a42('0x40')]=_[_0x3a42('0x41')](_0x2686a5[_0x3a42('0x3e')],_0x2686a5[_0x3a42('0x42')]);_0x52ab00[_0x3a42('0x43')]=_['intersection'](_0x2686a5[_0x3a42('0x3e')],qs['fields'](_0x3a3293[_0x3a42('0x42')][_0x3a42('0x44')]));_0x52ab00[_0x3a42('0x43')]=_0x52ab00[_0x3a42('0x43')][_0x3a42('0x45')]?_0x52ab00[_0x3a42('0x43')]:_0x2686a5[_0x3a42('0x3e')];if(_0x3a3293[_0x3a42('0x42')][_0x3a42('0x4d')]){_0x52ab00['include']=[{'all':!![]}];}_0x52ab00=_[_0x3a42('0x4c')]({},_0x52ab00,_0x3a3293[_0x3a42('0x53')]);return db['VoiceQueue']['find'](_0x52ab00)[_0x3a42('0x2c')](handleEntityNotFound(_0xa46b2a,null))[_0x3a42('0x2c')](respondWithResult(_0xa46b2a,null))['catch'](handleError(_0xa46b2a,null));};exports[_0x3a42('0x54')]=function(_0xd3d58,_0x44e249){return db['VoiceQueue'][_0x3a42('0x54')](_0xd3d58[_0x3a42('0x55')],{})['then'](function(_0x49d120){var _0x59ea1e=_0xd3d58[_0x3a42('0x56')][_0x3a42('0x57')]({'plain':!![]});if(!_0x59ea1e)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x59ea1e[_0x3a42('0x58')]===_0x3a42('0x56')){var _0x23ca9d=_0x49d120[_0x3a42('0x57')]({'plain':!![]});var _0x7a6ab6=[{'name':_0x3a42('0x59'),'value':_0x3a42('0x2d')},{'name':_0x3a42('0x2e'),'value':_0x3a42('0x2f')}];var _0x16f7a7=_['find'](_0x7a6ab6,[_0x3a42('0x32'),_0x23ca9d[_0x3a42('0x34')]])[_0x3a42('0x36')];return db[_0x3a42('0x5a')][_0x3a42('0x35')]({'where':{'name':_0x16f7a7,'userProfileId':_0x59ea1e['userProfileId']},'raw':!![]})[_0x3a42('0x2c')](function(_0xa9a61b){if(_0xa9a61b&&_0xa9a61b[_0x3a42('0x5b')]===0x0){return db['UserProfileResource'][_0x3a42('0x54')]({'name':_0x23ca9d[_0x3a42('0x36')],'resourceId':_0x23ca9d['id'],'type':_0xa9a61b['name'],'sectionId':_0xa9a61b['id']},{})[_0x3a42('0x2c')](function(){return _0x49d120;});}else{return _0x49d120;}})[_0x3a42('0x50')](function(_0x287802){logger[_0x3a42('0x39')](_0x3a42('0x5c'),_0x287802);throw _0x287802;});}return _0x49d120;})[_0x3a42('0x2c')](respondWithResult(_0x44e249,0xc9))['catch'](handleError(_0x44e249,null));};exports['clone']=function(_0x4c20f4,_0xc2e895){var _0x352967={'where':{'id':_0x4c20f4[_0x3a42('0x52')]['id']}},_0x302b24={};_0x302b24['model']=_[_0x3a42('0x3f')](db[_0x3a42('0x3a')][_0x3a42('0x3b')]);_0x352967['attributes']=_[_0x3a42('0x41')](_0x302b24[_0x3a42('0x3e')],qs['fields'](_0x4c20f4[_0x3a42('0x42')][_0x3a42('0x44')]));_0x352967[_0x3a42('0x43')]=_0x352967[_0x3a42('0x43')][_0x3a42('0x45')]?_0x352967[_0x3a42('0x43')]:_0x302b24[_0x3a42('0x3e')];if(_0x4c20f4[_0x3a42('0x42')][_0x3a42('0x4d')]){_0x352967[_0x3a42('0x5d')]=[{'all':!![]}];}_0x352967=_[_0x3a42('0x4c')]({},_0x352967,_0x4c20f4[_0x3a42('0x53')]);return db[_0x3a42('0x3a')][_0x3a42('0x35')](_0x352967)[_0x3a42('0x2c')](handleEntityNotFound(_0xc2e895,null))[_0x3a42('0x2c')](function(_0x16ece1){if(_0x16ece1){var _0x27fb39=_0x16ece1['get']({'plain':!![]});_0x27fb39=qs[_0x3a42('0x5e')](_0x27fb39,['id',_0x3a42('0x5f'),_0x3a42('0x60')]);_0x4c20f4['body']=_['omit'](_0x4c20f4['body'],['id',_0x3a42('0x5f'),_0x3a42('0x60')]);return db[_0x3a42('0x3a')][_0x3a42('0x54')](_[_0x3a42('0x4c')](_0x27fb39,_0x4c20f4[_0x3a42('0x55')]),{'include':_0x4c20f4[_0x3a42('0x42')]['includeAll']?[{'all':!![]}]:undefined})[_0x3a42('0x2c')](function(_0x20f8e9){var _0x5986fc=_0x4c20f4[_0x3a42('0x56')][_0x3a42('0x57')]({'plain':!![]});if(!_0x5986fc)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5986fc[_0x3a42('0x58')]==='user'){var _0x33f633=_0x20f8e9['get']({'plain':!![]});var _0x69fb42=[{'name':_0x3a42('0x59'),'value':_0x3a42('0x2d')},{'name':_0x3a42('0x2e'),'value':_0x3a42('0x2f')}];var _0x46a14d=_[_0x3a42('0x35')](_0x69fb42,['value',_0x33f633[_0x3a42('0x34')]])[_0x3a42('0x36')];return db['UserProfileSection'][_0x3a42('0x35')]({'where':{'name':_0x46a14d,'userProfileId':_0x5986fc[_0x3a42('0x61')]},'raw':!![]})['then'](function(_0x3126a1){if(_0x3126a1&&_0x3126a1[_0x3a42('0x5b')]===0x0){return db[_0x3a42('0x37')][_0x3a42('0x54')]({'name':_0x33f633[_0x3a42('0x36')],'resourceId':_0x33f633['id'],'type':_0x3126a1['name'],'sectionId':_0x3126a1['id']},{})['then'](function(){return _0x20f8e9;});}else{return _0x20f8e9;}})[_0x3a42('0x50')](function(_0x248bb9){logger[_0x3a42('0x39')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x248bb9);throw _0x248bb9;});}return _0x20f8e9;});}})['then'](respondWithResult(_0xc2e895,0xc9))['catch'](handleError(_0xc2e895,null));};exports[_0x3a42('0x2b')]=function(_0x560e3c,_0x263559){if(_0x560e3c['body']['id']){delete _0x560e3c[_0x3a42('0x55')]['id'];}return db['VoiceQueue']['find']({'where':{'id':_0x560e3c[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0x263559,null))[_0x3a42('0x2c')](saveUpdates(_0x560e3c['body'],null))['then'](respondWithResult(_0x263559,null))[_0x3a42('0x50')](handleError(_0x263559,null));};exports[_0x3a42('0x38')]=function(_0x23c72c,_0x3739fa){return db['VoiceQueue'][_0x3a42('0x35')]({'where':{'id':_0x23c72c[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x3739fa,null))['then'](removeEntity(_0x3739fa,null))[_0x3a42('0x50')](handleError(_0x3739fa,null));};exports[_0x3a42('0x62')]=function(_0x4b322a,_0xb12ea1,_0x3212b7){var _0x15648d={'raw':![],'where':{}};var _0x2e2e38={};var _0x317061={'count':0x0,'rows':[]};return db[_0x3a42('0x3a')]['findOne']({'where':{'id':_0x4b322a[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0xb12ea1,null))[_0x3a42('0x2c')](function(_0x189f96){if(_0x189f96){_0x2e2e38['model']=_[_0x3a42('0x3f')](db['CmHopper'][_0x3a42('0x3b')]);_0x2e2e38[_0x3a42('0x42')]=_[_0x3a42('0x3f')](_0x4b322a[_0x3a42('0x42')]);_0x2e2e38['filters']=_[_0x3a42('0x41')](_0x2e2e38[_0x3a42('0x3e')],_0x2e2e38[_0x3a42('0x42')]);_0x15648d['attributes']=_[_0x3a42('0x41')](_0x2e2e38[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x4b322a[_0x3a42('0x42')][_0x3a42('0x44')]));_0x15648d[_0x3a42('0x43')]=_0x15648d['attributes'][_0x3a42('0x45')]?_0x15648d[_0x3a42('0x43')]:_0x2e2e38['model'];if(!_0x4b322a[_0x3a42('0x42')][_0x3a42('0x46')](_0x3a42('0x63'))){_0x15648d[_0x3a42('0x22')]=qs['limit'](_0x4b322a[_0x3a42('0x42')][_0x3a42('0x22')]);_0x15648d[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x4b322a[_0x3a42('0x42')][_0x3a42('0x21')]);}_0x15648d[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x4b322a[_0x3a42('0x42')][_0x3a42('0x47')]);_0x15648d['where']=qs[_0x3a42('0x40')](_['pick'](_0x4b322a[_0x3a42('0x42')],_0x2e2e38['filters']));_0x15648d[_0x3a42('0x48')][_0x3a42('0x65')]=_0x189f96['id'];if(_0x4b322a[_0x3a42('0x42')]['filter']){_0x15648d[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x15648d[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x15648d[_0x3a42('0x43')],function(_0x7ba739){var _0x8bcc02={};_0x8bcc02[_0x7ba739]={'$like':'%'+_0x4b322a['query'][_0x3a42('0x30')]+'%'};return _0x8bcc02;})});}_0x15648d=_[_0x3a42('0x4c')]({},_0x15648d,_0x4b322a['options']);return db[_0x3a42('0x66')][_0x3a42('0x24')]({'where':_0x15648d[_0x3a42('0x48')]})['then'](function(_0x1ea0b3){_0x317061[_0x3a42('0x24')]=_0x1ea0b3;if(_0x4b322a[_0x3a42('0x42')][_0x3a42('0x4d')]){_0x15648d['include']=[{'all':!![]}];}return db[_0x3a42('0x66')][_0x3a42('0x4e')](_0x15648d);})[_0x3a42('0x2c')](function(_0x118d23){_0x317061['rows']=_0x118d23;return _0x317061;});}})[_0x3a42('0x2c')](respondWithFilteredResult(_0xb12ea1,_0x15648d))[_0x3a42('0x50')](handleError(_0xb12ea1,null));};exports[_0x3a42('0x67')]=function(_0x1d9b25,_0x397dba,_0x17b306){var _0x2cd983={'raw':!![],'where':{}};var _0x1337e1={};var _0x31bd65={'count':0x0,'rows':[]};return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x1d9b25[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x397dba,null))[_0x3a42('0x2c')](function(_0x54150c){if(_0x54150c){_0x1337e1[_0x3a42('0x3e')]=_['keys'](db[_0x3a42('0x69')][_0x3a42('0x3b')]);_0x1337e1[_0x3a42('0x42')]=_['keys'](_0x1d9b25['query']);_0x1337e1[_0x3a42('0x40')]=_['intersection'](_0x1337e1[_0x3a42('0x3e')],_0x1337e1[_0x3a42('0x42')]);_0x2cd983[_0x3a42('0x43')]=_['intersection'](_0x1337e1[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x1d9b25['query'][_0x3a42('0x44')]));_0x2cd983['attributes']=_0x2cd983[_0x3a42('0x43')][_0x3a42('0x45')]?_0x2cd983[_0x3a42('0x43')]:_0x1337e1[_0x3a42('0x3e')];if(!_0x1d9b25[_0x3a42('0x42')][_0x3a42('0x46')]('nolimit')){_0x2cd983['limit']=qs[_0x3a42('0x22')](_0x1d9b25['query'][_0x3a42('0x22')]);_0x2cd983['offset']=qs['offset'](_0x1d9b25[_0x3a42('0x42')]['offset']);}_0x2cd983['order']=qs[_0x3a42('0x47')](_0x1d9b25[_0x3a42('0x42')][_0x3a42('0x47')]);_0x2cd983[_0x3a42('0x48')]=qs['filters'](_['pick'](_0x1d9b25[_0x3a42('0x42')],_0x1337e1[_0x3a42('0x40')]));_0x2cd983['where']['VoiceQueueId']=_0x54150c['id'];if(_0x1d9b25[_0x3a42('0x42')][_0x3a42('0x30')]){_0x2cd983[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x2cd983[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x2cd983['attributes'],function(_0x49779b){var _0x108185={};_0x108185[_0x49779b]={'$like':'%'+_0x1d9b25[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x108185;})});}_0x2cd983=_[_0x3a42('0x4c')]({},_0x2cd983,_0x1d9b25['options']);return db[_0x3a42('0x69')][_0x3a42('0x24')]({'where':_0x2cd983['where']})[_0x3a42('0x2c')](function(_0x2fcec5){_0x31bd65[_0x3a42('0x24')]=_0x2fcec5;if(_0x1d9b25[_0x3a42('0x42')]['includeAll']){_0x2cd983[_0x3a42('0x5d')]=[{'all':!![]}];}return db[_0x3a42('0x69')][_0x3a42('0x4e')](_0x2cd983);})['then'](function(_0x42b76f){_0x31bd65[_0x3a42('0x4f')]=_0x42b76f;return _0x31bd65;});}})['then'](respondWithFilteredResult(_0x397dba,_0x2cd983))[_0x3a42('0x50')](handleError(_0x397dba,null));};exports[_0x3a42('0x6a')]=function(_0x42919f,_0x4b8010,_0x376fe7){var _0x48ea2f={'raw':!![],'where':{}};var _0x35b712={};var _0xcce2d1={'count':0x0,'rows':[]};return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x42919f[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x4b8010,null))[_0x3a42('0x2c')](function(_0x173af8){if(_0x173af8){_0x35b712[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db[_0x3a42('0x6b')][_0x3a42('0x3b')]);_0x35b712[_0x3a42('0x42')]=_[_0x3a42('0x3f')](_0x42919f[_0x3a42('0x42')]);_0x35b712[_0x3a42('0x40')]=_['intersection'](_0x35b712['model'],_0x35b712['query']);_0x48ea2f[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0x35b712[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x42919f[_0x3a42('0x42')][_0x3a42('0x44')]));_0x48ea2f[_0x3a42('0x43')]=_0x48ea2f[_0x3a42('0x43')][_0x3a42('0x45')]?_0x48ea2f[_0x3a42('0x43')]:_0x35b712[_0x3a42('0x3e')];if(!_0x42919f[_0x3a42('0x42')][_0x3a42('0x46')](_0x3a42('0x63'))){_0x48ea2f[_0x3a42('0x22')]=qs[_0x3a42('0x22')](_0x42919f['query'][_0x3a42('0x22')]);_0x48ea2f[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x42919f[_0x3a42('0x42')][_0x3a42('0x21')]);}_0x48ea2f[_0x3a42('0x64')]=qs['sort'](_0x42919f[_0x3a42('0x42')][_0x3a42('0x47')]);_0x48ea2f[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x42919f[_0x3a42('0x42')],_0x35b712[_0x3a42('0x40')]));_0x48ea2f[_0x3a42('0x48')][_0x3a42('0x65')]=_0x173af8['id'];if(_0x42919f['query'][_0x3a42('0x30')]){_0x48ea2f[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x48ea2f[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x48ea2f['attributes'],function(_0x19d7b6){var _0x3619ba={};_0x3619ba[_0x19d7b6]={'$like':'%'+_0x42919f[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x3619ba;})});}_0x48ea2f=_[_0x3a42('0x4c')]({},_0x48ea2f,_0x42919f[_0x3a42('0x53')]);return db[_0x3a42('0x6b')]['count']({'where':_0x48ea2f['where']})['then'](function(_0x55a39a){_0xcce2d1[_0x3a42('0x24')]=_0x55a39a;if(_0x42919f['query'][_0x3a42('0x4d')]){_0x48ea2f[_0x3a42('0x5d')]=[{'all':!![]}];}return db[_0x3a42('0x6b')]['findAll'](_0x48ea2f);})[_0x3a42('0x2c')](function(_0x3afa2c){_0xcce2d1[_0x3a42('0x4f')]=_0x3afa2c;return _0xcce2d1;});}})['then'](respondWithFilteredResult(_0x4b8010,_0x48ea2f))['catch'](handleError(_0x4b8010,null));};exports['getHopperBlacks']=function(_0x343105,_0x581854,_0x41ff50){var _0x506259={'raw':!![],'where':{}};var _0x23f119={};var _0x27e6f5={'count':0x0,'rows':[]};return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x343105['params']['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x581854,null))[_0x3a42('0x2c')](function(_0x4ff6c4){if(_0x4ff6c4){_0x23f119[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db['CmHopperBlack'][_0x3a42('0x3b')]);_0x23f119['query']=_[_0x3a42('0x3f')](_0x343105['query']);_0x23f119['filters']=_[_0x3a42('0x41')](_0x23f119[_0x3a42('0x3e')],_0x23f119[_0x3a42('0x42')]);_0x506259[_0x3a42('0x43')]=_['intersection'](_0x23f119[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x343105['query'][_0x3a42('0x44')]));_0x506259['attributes']=_0x506259[_0x3a42('0x43')][_0x3a42('0x45')]?_0x506259[_0x3a42('0x43')]:_0x23f119[_0x3a42('0x3e')];if(!_0x343105['query'][_0x3a42('0x46')](_0x3a42('0x63'))){_0x506259['limit']=qs[_0x3a42('0x22')](_0x343105['query'][_0x3a42('0x22')]);_0x506259[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x343105['query']['offset']);}_0x506259[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x343105['query'][_0x3a42('0x47')]);_0x506259[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_['pick'](_0x343105[_0x3a42('0x42')],_0x23f119[_0x3a42('0x40')]));_0x506259[_0x3a42('0x48')]['VoiceQueueId']=_0x4ff6c4['id'];if(_0x343105[_0x3a42('0x42')]['filter']){_0x506259['where']=_[_0x3a42('0x4c')](_0x506259['where'],{'$or':_[_0x3a42('0x4a')](_0x506259['attributes'],function(_0x29dd77){var _0x2f59df={};_0x2f59df[_0x29dd77]={'$like':'%'+_0x343105[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x2f59df;})});}_0x506259=_[_0x3a42('0x4c')]({},_0x506259,_0x343105[_0x3a42('0x53')]);return db[_0x3a42('0x6c')][_0x3a42('0x24')]({'where':_0x506259[_0x3a42('0x48')]})['then'](function(_0x5301da){_0x27e6f5[_0x3a42('0x24')]=_0x5301da;if(_0x343105[_0x3a42('0x42')][_0x3a42('0x4d')]){_0x506259['include']=[{'all':!![]}];}return db[_0x3a42('0x6c')][_0x3a42('0x4e')](_0x506259);})[_0x3a42('0x2c')](function(_0x949b84){_0x27e6f5[_0x3a42('0x4f')]=_0x949b84;return _0x27e6f5;});}})[_0x3a42('0x2c')](respondWithFilteredResult(_0x581854,_0x506259))['catch'](handleError(_0x581854,null));};exports[_0x3a42('0x6d')]=function(_0x544488,_0xbb3e8c,_0x5932e9){var _0x33b32f={};var _0x402b51={};var _0x22b9a3;var _0x1415c6;return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x544488[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0xbb3e8c,null))[_0x3a42('0x2c')](function(_0x1ce88a){if(_0x1ce88a){_0x22b9a3=_0x1ce88a;_0x402b51['model']=_['keys'](db[_0x3a42('0x6e')][_0x3a42('0x3b')]);_0x402b51[_0x3a42('0x42')]=_[_0x3a42('0x3f')](_0x544488[_0x3a42('0x42')]);_0x402b51['filters']=_[_0x3a42('0x41')](_0x402b51[_0x3a42('0x3e')],_0x402b51['query']);_0x33b32f[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0x402b51['model'],qs[_0x3a42('0x44')](_0x544488[_0x3a42('0x42')][_0x3a42('0x44')]));_0x33b32f[_0x3a42('0x43')]=_0x33b32f['attributes']['length']?_0x33b32f[_0x3a42('0x43')]:_0x402b51[_0x3a42('0x3e')];_0x33b32f['order']=qs['sort'](_0x544488['query']['sort']);_0x33b32f['where']=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x544488[_0x3a42('0x42')],_0x402b51[_0x3a42('0x40')]));if(_0x544488[_0x3a42('0x42')][_0x3a42('0x30')]){_0x33b32f[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x33b32f[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x33b32f[_0x3a42('0x43')],function(_0x2725c4){var _0x30a696={};_0x30a696[_0x2725c4]={'$like':'%'+_0x544488[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x30a696;})});}_0x33b32f=_[_0x3a42('0x4c')]({},_0x33b32f,_0x544488[_0x3a42('0x53')]);return _0x22b9a3[_0x3a42('0x6d')](_0x33b32f);}})[_0x3a42('0x2c')](function(_0x2bb8d0){if(_0x2bb8d0){_0x1415c6=_0x2bb8d0[_0x3a42('0x45')];if(!_0x544488['query']['hasOwnProperty'](_0x3a42('0x63'))){_0x33b32f[_0x3a42('0x22')]=qs[_0x3a42('0x22')](_0x544488['query'][_0x3a42('0x22')]);_0x33b32f[_0x3a42('0x21')]=qs['offset'](_0x544488[_0x3a42('0x42')][_0x3a42('0x21')]);}return _0x22b9a3[_0x3a42('0x6d')](_0x33b32f);}})[_0x3a42('0x2c')](function(_0x194415){if(_0x194415){return _0x194415?{'count':_0x1415c6,'rows':_0x194415}:null;}})[_0x3a42('0x2c')](respondWithResult(_0xbb3e8c,null))['catch'](handleError(_0xbb3e8c,null));};exports['addTeams']=function(_0x3dd02a,_0x1a0144,_0x27ebcf){var _0x41987b=_0x3dd02a[_0x3a42('0x55')][_0x3a42('0x6f')];var _0x51da2b=_['map'](_0x41987b,'id');return db[_0x3a42('0x6e')][_0x3a42('0x4e')]({'where':{'id':_0x51da2b},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id','name',_0x3a42('0x70'),_0x3a42('0x71'),_0x3a42('0x72')],'raw':!![]}]})[_0x3a42('0x2c')](function(_0x35d355){if(_0x35d355){var _0x277478=_['flatMap'](_0x35d355,function(_0x42a2b7){var _0xbc102b=_0x42a2b7[_0x3a42('0x57')]({'plain':!![]});_0xbc102b[_0x3a42('0x73')][_0x3a42('0x74')](function(_0x2ec4d0){_0x2ec4d0[_0x3a42('0x75')]=_[_0x3a42('0x35')](_0x41987b,{'id':_0xbc102b['id']})['penalty'];});return _0xbc102b[_0x3a42('0x73')];});return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x3dd02a['params']['id']}})[_0x3a42('0x2c')](function(_0x76b1ef){return db[_0x3a42('0x76')][_0x3a42('0x77')](function(_0x1663df){return _0x76b1ef[_0x3a42('0x78')](_0x51da2b,{'transaction':_0x1663df})[_0x3a42('0x2c')](function(){return BPromise[_0x3a42('0x79')](_0x41987b,function(_0x553b3c){return db[_0x3a42('0x7a')][_0x3a42('0x7b')]({'TeamId':_0x553b3c['id'],'VoiceQueueId':_0x3dd02a[_0x3a42('0x52')]['id'],'penalty':_0x553b3c[_0x3a42('0x75')]},{'transaction':_0x1663df});});})['then'](function(){return BPromise[_0x3a42('0x79')](_0x277478,function(_0x241a20){return db[_0x3a42('0x7c')][_0x3a42('0x7d')]({'where':{'UserId':_0x241a20['id'],'VoiceQueueId':_0x3dd02a[_0x3a42('0x52')]['id']},'defaults':{'penalty':_0x241a20[_0x3a42('0x75')]},'transaction':_0x1663df});});})[_0x3a42('0x2c')](function(){return BPromise[_0x3a42('0x79')](_[_0x3a42('0x30')](_0x277478,{'online':!![]}),function(_0x47d5ed){return db[_0x3a42('0x7e')][_0x3a42('0x7b')]({'membername':_0x47d5ed['name'],'UserId':_0x47d5ed['id'],'queue_name':_0x76b1ef[_0x3a42('0x36')],'VoiceQueueId':_0x76b1ef['id'],'interface':_[_0x3a42('0x7f')](_0x47d5ed[_0x3a42('0x72')])?util[_0x3a42('0x80')](_0x3a42('0x81'),_0x47d5ed['name']):_0x47d5ed[_0x3a42('0x72')],'paused':_0x47d5ed[_0x3a42('0x71')]||![],'penalty':_0x47d5ed[_0x3a42('0x75')]},{'transaction':_0x1663df});});})[_0x3a42('0x2c')](function(){_0x277478[_0x3a42('0x74')](function(_0x200c91){socket[_0x3a42('0x82')](_0x3a42('0x83'),{'UserId':_0x200c91['id'],'VoiceQueueId':_0x76b1ef['id']});});});});});}})['then'](respondWithStatusCode(_0x1a0144,null))['catch'](handleError(_0x1a0144,null));};exports[_0x3a42('0x84')]=function(_0x4505cc,_0x1289bc,_0x5cab4b){return db[_0x3a42('0x6e')][_0x3a42('0x4e')]({'where':{'id':_0x4505cc[_0x3a42('0x42')][_0x3a42('0x85')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0x3a42('0x73'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x1289bc,null))[_0x3a42('0x2c')](function(_0x3f7b3f){var _0x23faba=_['map'](_0x3f7b3f,'id');var _0x398ffa=[];var _0x1b57b4=[];var _0x178500=squel[_0x3a42('0x86')]();_0x178500['field']('tq.TeamId')[_0x3a42('0x87')](_0x3a42('0x88'),'tq')[_0x3a42('0x89')](_0x3a42('0x8a'),'ut',_0x3a42('0x8b'))['where'](_0x3a42('0x8c'),_0x4505cc['params']['id']);for(var _0x3d19f9=0x0;_0x3d19f9<_0x3f7b3f[_0x3a42('0x45')];_0x3d19f9+=0x1){let _0x5457d1=_0x3f7b3f[_0x3d19f9];for(var _0x149e12=0x0;_0x149e12<_0x5457d1[_0x3a42('0x73')][_0x3a42('0x45')];_0x149e12+=0x1){let _0x265427=_0x5457d1[_0x3a42('0x73')][_0x149e12];var _0x54eaa8=_0x178500['clone']();_0x54eaa8[_0x3a42('0x48')]('ut.UserId\x20=\x20?',_0x265427['id']);_0x1b57b4['push'](db['sequelize'][_0x3a42('0x42')](_0x54eaa8['toString'](),{'type':db[_0x3a42('0x76')][_0x3a42('0x8d')][_0x3a42('0x8e')]})[_0x3a42('0x2c')](function(_0xf22c9c){if(_0xf22c9c['length']===0x1){return _0x265427['id'];}else{var _0x3a605c=_[_0x3a42('0x8f')](_[_0x3a42('0x4a')](_0xf22c9c,_0x3a42('0x90')),function(_0x311d24){return _[_0x3a42('0x33')](_0x23faba,_0x311d24);});if(_0x3a605c){return _0x265427['id'];}}}));}}return BPromise[_0x3a42('0x91')](_0x1b57b4)[_0x3a42('0x2c')](function(_0x168e97){_0x398ffa=_(_0x398ffa)['union'](_0x168e97)[_0x3a42('0x92')]()[_0x3a42('0x32')]();return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x4505cc['params']['id']}})[_0x3a42('0x2c')](function(_0x53117c){return db[_0x3a42('0x76')][_0x3a42('0x77')](function(_0x30ffdf){return _0x53117c[_0x3a42('0x84')](_0x4505cc[_0x3a42('0x42')][_0x3a42('0x85')],{'transaction':_0x30ffdf})[_0x3a42('0x2c')](function(){if(!_[_0x3a42('0x93')](_0x398ffa)){return _0x53117c[_0x3a42('0x94')](_0x398ffa,{'transaction':_0x30ffdf})[_0x3a42('0x2c')](function(){return db[_0x3a42('0x7e')][_0x3a42('0x38')]({'where':{'VoiceQueueId':_0x4505cc[_0x3a42('0x52')]['id'],'UserId':_0x398ffa},'transaction':_0x30ffdf});});}})[_0x3a42('0x2c')](function(){_0x398ffa[_0x3a42('0x74')](function(_0x5e1368){socket[_0x3a42('0x82')](_0x3a42('0x95'),{'UserId':_0x5e1368,'VoiceQueueId':_0x53117c['id']});});});});});});})[_0x3a42('0x2c')](respondWithStatusCode(_0x1289bc,null))[_0x3a42('0x50')](handleError(_0x1289bc,null));};exports[_0x3a42('0x96')]=function(_0x56e035,_0x358938,_0xff006){var _0x259264,_0x11084e;return db['VoiceQueue'][_0x3a42('0x35')]({'where':{'id':_0x56e035[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x358938,null))['then'](function(_0x4faba7){if(_0x4faba7){_0x11084e=_0x4faba7;return _0x4faba7[_0x3a42('0x96')](_0x56e035[_0x3a42('0x55')][_0x3a42('0x85')],_[_0x3a42('0x5e')](_0x56e035[_0x3a42('0x55')],['ids','id'])||{})[_0x3a42('0x97')](function(_0x2549bc){for(var _0x5012a4=0x0;_0x5012a4<_0x56e035[_0x3a42('0x55')]['ids'][_0x3a42('0x45')];_0x5012a4+=0x1){socket[_0x3a42('0x82')]('userVoiceQueue:save',{'UserId':Number(_0x56e035[_0x3a42('0x55')][_0x3a42('0x85')][_0x5012a4]),'VoiceQueueId':Number(_0x56e035[_0x3a42('0x52')]['id'])});}return _0x2549bc;});}})[_0x3a42('0x2c')](function(_0x2429ed){_0x259264=_0x2429ed||[];if(_0x11084e){return db[_0x3a42('0x98')][_0x3a42('0x4e')]({'where':{'id':_0x56e035[_0x3a42('0x55')][_0x3a42('0x85')]},'attributes':['id',_0x3a42('0x36'),'online',_0x3a42('0x71'),_0x3a42('0x72')],'raw':!![]});}})[_0x3a42('0x2c')](function(_0x362369){if(!_[_0x3a42('0x93')](_0x362369)){var _0x113bfc=[];for(var _0x2ec996=0x0;_0x2ec996<_0x362369[_0x3a42('0x45')];_0x2ec996++){if(_0x362369[_0x2ec996][_0x3a42('0x70')]){_0x113bfc[_0x3a42('0x99')](db[_0x3a42('0x7e')][_0x3a42('0x7b')]({'membername':_0x362369[_0x2ec996][_0x3a42('0x36')],'UserId':_0x362369[_0x2ec996]['id'],'queue_name':_0x11084e[_0x3a42('0x36')],'VoiceQueueId':_0x11084e['id'],'interface':_[_0x3a42('0x7f')](_0x362369[_0x2ec996][_0x3a42('0x72')])?util['format'](_0x3a42('0x81'),_0x362369[_0x2ec996][_0x3a42('0x36')]):_0x362369[_0x2ec996][_0x3a42('0x72')],'paused':_0x362369[_0x2ec996]['voicePause']||![],'penalty':_0x56e035[_0x3a42('0x55')][_0x3a42('0x75')]||0x0}));}}return BPromise[_0x3a42('0x91')](_0x113bfc);}})[_0x3a42('0x2c')](function(){return _0x259264;})[_0x3a42('0x2c')](respondWithResult(_0x358938,null))[_0x3a42('0x50')](handleError(_0x358938,null));};exports[_0x3a42('0x94')]=function(_0x353b03,_0x20fc4a,_0xe62af3){return db['VoiceQueue']['find']({'where':{'id':_0x353b03[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x20fc4a,null))[_0x3a42('0x2c')](function(_0x1cb326){if(_0x1cb326){return _0x1cb326[_0x3a42('0x94')](_0x353b03[_0x3a42('0x42')][_0x3a42('0x85')])['then'](function(){if(_[_0x3a42('0x9a')](_0x353b03[_0x3a42('0x42')][_0x3a42('0x85')])){for(var _0x1f5bba=0x0;_0x1f5bba<_0x353b03['query'][_0x3a42('0x85')][_0x3a42('0x45')];_0x1f5bba+=0x1){socket['emit'](_0x3a42('0x95'),{'UserId':Number(_0x353b03[_0x3a42('0x42')][_0x3a42('0x85')][_0x1f5bba]),'VoiceQueueId':Number(_0x353b03[_0x3a42('0x52')]['id'])});}}else{socket['emit']('userVoiceQueue:remove',{'UserId':Number(_0x353b03['query'][_0x3a42('0x85')]),'VoiceQueueId':Number(_0x353b03[_0x3a42('0x52')]['id'])});}});}})[_0x3a42('0x2c')](function(_0xb75dc7){return db[_0x3a42('0x7e')][_0x3a42('0x38')]({'where':{'VoiceQueueId':_0x353b03[_0x3a42('0x52')]['id'],'UserId':_0x353b03[_0x3a42('0x42')][_0x3a42('0x85')]}})[_0x3a42('0x2c')](function(){return _0xb75dc7;});})[_0x3a42('0x2c')](respondWithStatusCode(_0x20fc4a,null))[_0x3a42('0x50')](handleError(_0x20fc4a,null));};exports[_0x3a42('0x9b')]=function(_0x25a590,_0x2e8847,_0x4e881a){var _0x5a076d={};var _0x221dde={};var _0x547949;var _0x2e1d79;return db['VoiceQueue'][_0x3a42('0x68')]({'where':{'id':_0x25a590[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x2e8847,null))[_0x3a42('0x2c')](function(_0x43324c){if(_0x43324c){_0x547949=_0x43324c;_0x221dde[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db['User'][_0x3a42('0x3b')]);_0x221dde[_0x3a42('0x42')]=_['keys'](_0x25a590[_0x3a42('0x42')]);_0x221dde[_0x3a42('0x40')]=_[_0x3a42('0x41')](_0x221dde['model'],_0x221dde[_0x3a42('0x42')]);_0x5a076d['attributes']=_[_0x3a42('0x41')](_0x221dde[_0x3a42('0x3e')],qs['fields'](_0x25a590['query']['fields']));_0x5a076d[_0x3a42('0x43')]=_0x5a076d[_0x3a42('0x43')]['length']?_0x5a076d[_0x3a42('0x43')]:_0x221dde[_0x3a42('0x3e')];_0x5a076d[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x25a590[_0x3a42('0x42')][_0x3a42('0x47')]);_0x5a076d['where']=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x25a590[_0x3a42('0x42')],_0x221dde[_0x3a42('0x40')]));if(_0x25a590[_0x3a42('0x42')]['filter']){_0x5a076d['where']=_[_0x3a42('0x4c')](_0x5a076d[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x5a076d[_0x3a42('0x43')],function(_0x4e3238){var _0x3bbe75={};_0x3bbe75[_0x4e3238]={'$like':'%'+_0x25a590[_0x3a42('0x42')]['filter']+'%'};return _0x3bbe75;})});}_0x5a076d=_[_0x3a42('0x4c')]({},_0x5a076d,_0x25a590[_0x3a42('0x53')]);return _0x547949['getAgents'](_0x5a076d);}})['then'](function(_0x508921){if(_0x508921){_0x2e1d79=_0x508921[_0x3a42('0x45')];if(!_0x25a590[_0x3a42('0x42')]['hasOwnProperty'](_0x3a42('0x63'))){_0x5a076d[_0x3a42('0x22')]=qs[_0x3a42('0x22')](_0x25a590[_0x3a42('0x42')]['limit']);_0x5a076d[_0x3a42('0x21')]=qs['offset'](_0x25a590['query'][_0x3a42('0x21')]);}return _0x547949['getAgents'](_0x5a076d);}})[_0x3a42('0x2c')](function(_0x3cd547){if(_0x3cd547){return _0x3cd547?{'count':_0x2e1d79,'rows':_0x3cd547}:null;}})[_0x3a42('0x2c')](respondWithResult(_0x2e8847,null))[_0x3a42('0x50')](handleError(_0x2e8847,null));};exports[_0x3a42('0x9c')]=function(_0x46cd40,_0x1c2f79,_0x5029d1){var _0x250159={};var _0x1fc928={};var _0x599932;var _0x8b81f0;return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x46cd40[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x1c2f79,null))[_0x3a42('0x2c')](function(_0x1a6dc0){if(_0x1a6dc0){_0x599932=_0x1a6dc0;_0x1fc928['model']=_[_0x3a42('0x3f')](db[_0x3a42('0x7e')][_0x3a42('0x3b')]);_0x1fc928[_0x3a42('0x42')]=_[_0x3a42('0x3f')](_0x46cd40['query']);_0x1fc928['filters']=_[_0x3a42('0x41')](_0x1fc928[_0x3a42('0x3e')],_0x1fc928[_0x3a42('0x42')]);_0x250159[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0x1fc928[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x46cd40['query']['fields']));_0x250159[_0x3a42('0x43')]=_0x250159[_0x3a42('0x43')][_0x3a42('0x45')]?_0x250159[_0x3a42('0x43')]:_0x1fc928[_0x3a42('0x3e')];_0x250159[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x46cd40[_0x3a42('0x42')]['sort']);_0x250159[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_[_0x3a42('0x49')](_0x46cd40[_0x3a42('0x42')],_0x1fc928[_0x3a42('0x40')]));if(_0x46cd40[_0x3a42('0x42')][_0x3a42('0x30')]){_0x250159[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x250159['where'],{'$or':_[_0x3a42('0x4a')](_0x250159[_0x3a42('0x43')],function(_0x437e31){var _0x474c89={};_0x474c89[_0x437e31]={'$like':'%'+_0x46cd40[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x474c89;})});}_0x250159=_[_0x3a42('0x4c')]({},_0x250159,_0x46cd40[_0x3a42('0x53')]);return _0x599932[_0x3a42('0x9c')](_0x250159);}})[_0x3a42('0x2c')](function(_0x1deb32){if(_0x1deb32){_0x8b81f0=_0x1deb32[_0x3a42('0x45')];if(!_0x46cd40[_0x3a42('0x42')][_0x3a42('0x46')](_0x3a42('0x63'))){_0x250159['limit']=qs[_0x3a42('0x22')](_0x46cd40[_0x3a42('0x42')][_0x3a42('0x22')]);_0x250159[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x46cd40['query'][_0x3a42('0x21')]);}return _0x599932[_0x3a42('0x9c')](_0x250159);}})[_0x3a42('0x2c')](function(_0x4ef7b3){return _0x4ef7b3?{'count':_0x8b81f0,'rows':_0x4ef7b3}:null;})[_0x3a42('0x2c')](respondWithResult(_0x1c2f79,null))[_0x3a42('0x50')](handleError(_0x1c2f79,null));};exports[_0x3a42('0x9d')]=function(_0x44f0c2,_0x55a346,_0x28a7a7){var _0x20d04d={};var _0x51eb31={};var _0x206acd;var _0x47424d;return db[_0x3a42('0x3a')]['findOne']({'where':{'id':_0x44f0c2[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0x55a346,null))['then'](function(_0x4fe380){if(_0x4fe380){_0x206acd=_0x4fe380;_0x51eb31[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db[_0x3a42('0x9e')][_0x3a42('0x3b')]);_0x51eb31['query']=_[_0x3a42('0x3f')](_0x44f0c2[_0x3a42('0x42')]);_0x51eb31[_0x3a42('0x40')]=_[_0x3a42('0x41')](_0x51eb31[_0x3a42('0x3e')],_0x51eb31[_0x3a42('0x42')]);_0x20d04d[_0x3a42('0x43')]=_['intersection'](_0x51eb31[_0x3a42('0x3e')],qs[_0x3a42('0x44')](_0x44f0c2[_0x3a42('0x42')]['fields']));_0x20d04d[_0x3a42('0x43')]=_0x20d04d[_0x3a42('0x43')][_0x3a42('0x45')]?_0x20d04d[_0x3a42('0x43')]:_0x51eb31[_0x3a42('0x3e')];_0x20d04d[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x44f0c2['query'][_0x3a42('0x47')]);_0x20d04d[_0x3a42('0x48')]=qs[_0x3a42('0x40')](_['pick'](_0x44f0c2[_0x3a42('0x42')],_0x51eb31['filters']));if(_0x44f0c2['query']['filter']){_0x20d04d[_0x3a42('0x48')]=_['merge'](_0x20d04d[_0x3a42('0x48')],{'$or':_[_0x3a42('0x4a')](_0x20d04d['attributes'],function(_0x1f83ec){var _0x3cc23c={};_0x3cc23c[_0x1f83ec]={'$like':'%'+_0x44f0c2[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x3cc23c;})});}_0x20d04d=_[_0x3a42('0x4c')]({},_0x20d04d,_0x44f0c2[_0x3a42('0x53')]);return _0x206acd[_0x3a42('0x9d')](_0x20d04d);}})['then'](function(_0x17b056){if(_0x17b056){_0x47424d=_0x17b056[_0x3a42('0x45')];if(!_0x44f0c2[_0x3a42('0x42')]['hasOwnProperty'](_0x3a42('0x63'))){_0x20d04d['limit']=qs[_0x3a42('0x22')](_0x44f0c2[_0x3a42('0x42')][_0x3a42('0x22')]);_0x20d04d[_0x3a42('0x21')]=qs[_0x3a42('0x21')](_0x44f0c2['query'][_0x3a42('0x21')]);}return _0x206acd[_0x3a42('0x9d')](_0x20d04d);}})[_0x3a42('0x2c')](function(_0x1c946e){if(_0x1c946e){return _0x1c946e?{'count':_0x47424d,'rows':_0x1c946e}:null;}})['then'](respondWithResult(_0x55a346,null))[_0x3a42('0x50')](handleError(_0x55a346,null));};exports[_0x3a42('0x9f')]=function(_0x4369cc,_0x38d045,_0x286102){var _0x51323d=moment()['format'](_0x3a42('0xa0'));var _0x404f0c,_0x1cefc7;return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x4369cc[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0x38d045,null))['then'](function(_0x1657a2){if(_0x1657a2){_0x1cefc7=_0x1657a2;return _0x1657a2[_0x3a42('0x9f')](_0x4369cc[_0x3a42('0x55')][_0x3a42('0x85')],_[_0x3a42('0x5e')](_0x4369cc['body'],[_0x3a42('0x85'),'id'])||{});}return null;})[_0x3a42('0x97')](function(_0x293f46){var _0x382156;_0x404f0c=_0x293f46||[];var _0x492a92=[];if(_0x293f46){for(var _0x2e8d4c=0x0;_0x2e8d4c<_0x293f46['length'];_0x2e8d4c+=0x1){var _0x313c81=_0x293f46[_0x2e8d4c][_0x3a42('0x57')]({'plain':!![]});_0x1cefc7[_0x3a42('0xa1')]=_0x4369cc['body'][_0x3a42('0xa1')]?_0x4369cc[_0x3a42('0x55')][_0x3a42('0xa1')]:_0x1cefc7[_0x3a42('0xa1')];switch(_0x1cefc7[_0x3a42('0xa1')]){case'always':_0x382156=squel[_0x3a42('0xa2')]()['into'](_0x3a42('0xa3'))[_0x3a42('0xa4')]([_0x3a42('0xa5'),_0x3a42('0xa6'),_0x3a42('0xa7'),_0x3a42('0xa8'),'VoiceQueueId',_0x3a42('0x5f'),_0x3a42('0x60')],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xa5'),'phone')[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0xa6'))[_0x3a42('0xa9')]('id',_0x3a42('0xa7'))[_0x3a42('0xa9')](_0x313c81[_0x3a42('0xaa')]['toString'](),_0x3a42('0xa8'))['field'](_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')](),_0x3a42('0x65'))['field']('\x27'+_0x51323d+'\x27',_0x3a42('0x5f'))[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0x60'))[_0x3a42('0x87')](_0x3a42('0xac'))['where']('deletedAt\x20IS\x20NULL')[_0x3a42('0x48')](_0x3a42('0xad'),_0x313c81[_0x3a42('0xaa')][_0x3a42('0xab')]())[_0x3a42('0x48')](_0x3a42('0xae'))[_0x3a42('0x48')](_0x3a42('0xaf'),squel[_0x3a42('0x86')]()['field']('COALESCE(calleridnum,\x27\x27)')['from'](_0x3a42('0xb0'))[_0x3a42('0x48')]('VoiceQueueId\x20=\x20?',_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')]()))[_0x3a42('0x48')](_0x3a42('0xaf'),squel['select']()[_0x3a42('0xa9')](_0x3a42('0xb1'))['from'](_0x3a42('0xa3'))[_0x3a42('0x48')]('VoiceQueueId\x20=\x20?',_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')]())))[_0x3a42('0xab')]();break;case _0x3a42('0xb2'):_0x382156=squel[_0x3a42('0xa2')]()[_0x3a42('0xb3')](_0x3a42('0xa3'))[_0x3a42('0xa4')](['phone',_0x3a42('0xa6'),_0x3a42('0xa7'),_0x3a42('0xa8'),_0x3a42('0x65'),'createdAt',_0x3a42('0x60')],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xa5'),_0x3a42('0xa5'))['field']('\x27'+_0x51323d+'\x27','scheduledAt')[_0x3a42('0xa9')]('id',_0x3a42('0xa7'))['field'](_0x313c81['CmListId'][_0x3a42('0xab')](),'ListId')[_0x3a42('0xa9')](_0x4369cc['params']['id'][_0x3a42('0xab')](),_0x3a42('0x65'))[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0x5f'))['field']('\x27'+_0x51323d+'\x27',_0x3a42('0x60'))[_0x3a42('0x87')](_0x3a42('0xac'))[_0x3a42('0x48')](_0x3a42('0xb4'))['where']('ListId\x20=\x20?',_0x313c81['CmListId'][_0x3a42('0xab')]())['where']('phone\x20IS\x20NOT\x20NULL')[_0x3a42('0x48')]('phone\x20NOT\x20IN\x20(?)',squel[_0x3a42('0x86')]()['field'](_0x3a42('0xb1'))[_0x3a42('0x87')](_0x3a42('0xa3'))[_0x3a42('0x48')](_0x3a42('0x8c'),_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')]())))[_0x3a42('0xab')]();break;default:_0x382156=squel[_0x3a42('0xa2')]()[_0x3a42('0xb3')](_0x3a42('0xa3'))[_0x3a42('0xa4')]([_0x3a42('0xa5'),'scheduledAt','ContactId',_0x3a42('0xa8'),_0x3a42('0x65'),_0x3a42('0x5f'),'updatedAt'],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xa5'),_0x3a42('0xa5'))['field']('\x27'+_0x51323d+'\x27',_0x3a42('0xa6'))[_0x3a42('0xa9')]('id',_0x3a42('0xa7'))['field'](_0x313c81['CmListId']['toString'](),_0x3a42('0xa8'))[_0x3a42('0xa9')](_0x4369cc[_0x3a42('0x52')]['id'][_0x3a42('0xab')](),'VoiceQueueId')[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0x5f'))['field']('\x27'+_0x51323d+'\x27',_0x3a42('0x60'))['from'](_0x3a42('0xac'))['where'](_0x3a42('0xb4'))['where'](_0x3a42('0xad'),_0x313c81[_0x3a42('0xaa')][_0x3a42('0xab')]())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x3a42('0xab')]();}_0x492a92[_0x3a42('0x99')](db['sequelize'][_0x3a42('0x42')](_0x382156));}return BPromise[_0x3a42('0x91')](_0x492a92);}})[_0x3a42('0x2c')](function(){var _0x1bd1d2=[];var _0x15f99e=squel[_0x3a42('0xa2')]()[_0x3a42('0xb3')](_0x3a42('0xb5'))[_0x3a42('0xa4')](['CmHopperId',_0x3a42('0xa5'),'OrderBy',_0x3a42('0x5f'),_0x3a42('0x60')],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xb6'))['field'](_0x3a42('0xb7'))[_0x3a42('0xa9')](_0x3a42('0xb8'))[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27',_0x3a42('0x5f'))[_0x3a42('0xa9')]('\x27'+_0x51323d+'\x27','updatedAt')[_0x3a42('0x87')]('cm_contact_has_items','ci')['join']('cm_hopper','h','h.ContactId=ci.CmContactId')[_0x3a42('0x48')]('h.scheduledat=?',_0x51323d)[_0x3a42('0x48')]('ci.ItemClass=?',_0x3a42('0xb9')))[_0x3a42('0xab')]();_0x1bd1d2['push'](db[_0x3a42('0x76')][_0x3a42('0x42')](_0x15f99e));return BPromise[_0x3a42('0x91')](_0x1bd1d2);})[_0x3a42('0x2c')](function(){return _0x404f0c;})[_0x3a42('0x2c')](respondWithResult(_0x38d045,null))[_0x3a42('0x50')](handleError(_0x38d045,null));};exports['removeLists']=function(_0x39bfdf,_0x26eccd,_0x5b4d89){return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x39bfdf[_0x3a42('0x52')]['id']}})['then'](handleEntityNotFound(_0x26eccd,null))['then'](function(_0x57f5cd){if(_0x57f5cd){return _0x57f5cd['removeLists'](_0x39bfdf[_0x3a42('0x42')][_0x3a42('0x85')]);}})[_0x3a42('0x2c')](function(_0x121a00){if(_0x121a00){return db[_0x3a42('0x66')][_0x3a42('0x38')]({'where':{'ListId':_0x39bfdf[_0x3a42('0x42')][_0x3a42('0x85')],'VoiceQueueId':_0x39bfdf[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](function(){return _0x121a00;});}})[_0x3a42('0x2c')](respondWithStatusCode(_0x26eccd,null))[_0x3a42('0x50')](handleError(_0x26eccd,null));};exports[_0x3a42('0xba')]=function(_0x5d7b90,_0x2c8cdc,_0x92a168){var _0x8dcfd5={};var _0x50017d={};var _0x1aa408;var _0x356ac0;return db[_0x3a42('0x3a')][_0x3a42('0x68')]({'where':{'id':_0x5d7b90['params']['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x2c8cdc,null))[_0x3a42('0x2c')](function(_0x502890){if(_0x502890){_0x1aa408=_0x502890;_0x50017d[_0x3a42('0x3e')]=_[_0x3a42('0x3f')](db[_0x3a42('0x9e')]['rawAttributes']);_0x50017d[_0x3a42('0x42')]=_['keys'](_0x5d7b90['query']);_0x50017d[_0x3a42('0x40')]=_['intersection'](_0x50017d['model'],_0x50017d[_0x3a42('0x42')]);_0x8dcfd5[_0x3a42('0x43')]=_[_0x3a42('0x41')](_0x50017d['model'],qs[_0x3a42('0x44')](_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x44')]));_0x8dcfd5[_0x3a42('0x43')]=_0x8dcfd5['attributes']['length']?_0x8dcfd5['attributes']:_0x50017d['model'];_0x8dcfd5[_0x3a42('0x64')]=qs[_0x3a42('0x47')](_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x47')]);_0x8dcfd5[_0x3a42('0x48')]=qs['filters'](_[_0x3a42('0x49')](_0x5d7b90[_0x3a42('0x42')],_0x50017d[_0x3a42('0x40')]));if(_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x30')]){_0x8dcfd5[_0x3a42('0x48')]=_[_0x3a42('0x4c')](_0x8dcfd5[_0x3a42('0x48')],{'$or':_['map'](_0x8dcfd5[_0x3a42('0x43')],function(_0x4bf34a){var _0x55d2c4={};_0x55d2c4[_0x4bf34a]={'$like':'%'+_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x30')]+'%'};return _0x55d2c4;})});}_0x8dcfd5=_[_0x3a42('0x4c')]({},_0x8dcfd5,_0x5d7b90['options']);return _0x1aa408[_0x3a42('0xba')](_0x8dcfd5);}})[_0x3a42('0x2c')](function(_0xe3fad2){if(_0xe3fad2){_0x356ac0=_0xe3fad2[_0x3a42('0x45')];if(!_0x5d7b90['query']['hasOwnProperty']('nolimit')){_0x8dcfd5[_0x3a42('0x22')]=qs['limit'](_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x22')]);_0x8dcfd5[_0x3a42('0x21')]=qs['offset'](_0x5d7b90[_0x3a42('0x42')][_0x3a42('0x21')]);}return _0x1aa408[_0x3a42('0xba')](_0x8dcfd5);}})[_0x3a42('0x2c')](function(_0x4410c1){if(_0x4410c1){return _0x4410c1?{'count':_0x356ac0,'rows':_0x4410c1}:null;}})[_0x3a42('0x2c')](respondWithResult(_0x2c8cdc,null))[_0x3a42('0x50')](handleError(_0x2c8cdc,null));};exports[_0x3a42('0xbb')]=function(_0x13989b,_0x1127aa,_0x1a8917){var _0x2df895,_0x30a5ca;return db['VoiceQueue']['find']({'where':{'id':_0x13989b[_0x3a42('0x52')]['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x1127aa,null))['then'](function(_0x1b10b9){if(_0x1b10b9){_0x30a5ca=_0x1b10b9;return _0x1b10b9[_0x3a42('0xbb')](_0x13989b[_0x3a42('0x55')]['ids'],_[_0x3a42('0x5e')](_0x13989b[_0x3a42('0x55')],[_0x3a42('0x85'),'id'])||{});}return null;})[_0x3a42('0x97')](function(_0x4c40e9){var _0x21cd17;_0x2df895=_0x4c40e9||[];var _0x57a9fc=[];if(_0x4c40e9){for(var _0x1d828b=0x0;_0x1d828b<_0x4c40e9[_0x3a42('0x45')];_0x1d828b+=0x1){var _0x496ad4=_0x4c40e9[_0x1d828b][_0x3a42('0x57')]({'plain':!![]});_0x21cd17=squel[_0x3a42('0xa2')]()['into'](_0x3a42('0xbc'))[_0x3a42('0xa4')]([_0x3a42('0xa5'),_0x3a42('0xa7'),_0x3a42('0xa8'),_0x3a42('0x65'),_0x3a42('0x5f'),_0x3a42('0x60')],squel[_0x3a42('0x86')]()[_0x3a42('0xa9')](_0x3a42('0xa5'),_0x3a42('0xa5'))[_0x3a42('0xa9')]('id','ContactId')[_0x3a42('0xa9')](_0x496ad4[_0x3a42('0xaa')][_0x3a42('0xab')](),_0x3a42('0xa8'))[_0x3a42('0xa9')](_0x13989b[_0x3a42('0x52')]['id']['toString'](),'VoiceQueueId')['field']('NOW()','createdAt')[_0x3a42('0xa9')](_0x3a42('0xbd'),'updatedAt')['from'](_0x3a42('0xac'))[_0x3a42('0x48')]('deletedAt\x20IS\x20NULL')[_0x3a42('0x48')](_0x3a42('0xad'),_0x496ad4[_0x3a42('0xaa')][_0x3a42('0xab')]())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x3a42('0xab')]();_0x57a9fc[_0x3a42('0x99')](db['sequelize']['query'](_0x21cd17));}return BPromise[_0x3a42('0x91')](_0x57a9fc);}})['then'](function(){return _0x2df895;})[_0x3a42('0x2c')](respondWithResult(_0x1127aa,null))[_0x3a42('0x50')](handleError(_0x1127aa,null));};exports[_0x3a42('0xbe')]=function(_0x5c866d,_0x4d2c6a,_0xb456c3){return db[_0x3a42('0x3a')][_0x3a42('0x35')]({'where':{'id':_0x5c866d['params']['id']}})[_0x3a42('0x2c')](handleEntityNotFound(_0x4d2c6a,null))[_0x3a42('0x2c')](function(_0x568252){if(_0x568252){return _0x568252[_0x3a42('0xbe')](_0x5c866d[_0x3a42('0x42')][_0x3a42('0x85')]);}})[_0x3a42('0x2c')](function(_0x17cac7){if(_0x17cac7){return db[_0x3a42('0x6c')][_0x3a42('0x38')]({'where':{'ListId':_0x5c866d[_0x3a42('0x42')][_0x3a42('0x85')],'VoiceQueueId':_0x5c866d[_0x3a42('0x52')]['id']}})['then'](function(){return _0x17cac7;});}})[_0x3a42('0x2c')](respondWithStatusCode(_0x4d2c6a,null))[_0x3a42('0x50')](handleError(_0x4d2c6a,null));};
\ No newline at end of file
+var _0x8f6b=['nolimit','order','sort','where','pick','filters','VIRTUAL','merge','options','includeAll','include','rows','catch','show','params','find','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','QueueCampaigns','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','rawAttributes','omit','createdAt','create','user','getHoppers','findOne','CmHopper','VoiceQueueId','findAll','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','addTeams','teams','User','online','flatMap','Agents','penalty','sequelize','transaction','each','TeamVoiceQueue','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','interface','format','SIP/%s','voicePause','emit','userVoiceQueue:save','removeTeams','select','field','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','QueryTypes','every','TeamId','all','union','isEmpty','userVoiceQueue:remove','addAgents','ids','spread','push','removeAgents','isArray','getAgents','getMembers','CmList','getLists','addLists','dialCheckDuplicateType','always','insert','fromQuery','phone','scheduledAt','ContactId','ListId','updatedAt','toString','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','COALESCE(calleridnum,\x27\x27)','cm_hopper','onlyIfOpen','into','COALESCE(phone,\x27\x27)','CmHopperId','OrderBy','h.id','ci.item','cm_contact_has_items','h.ContactId=ci.CmContactId','h.scheduledat=?','ci.ItemClass=?','PHONE','removeLists','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','sox','ejs','lodash','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','redis','defaults','localhost','socket.io-emitter','register','end','status','json','undefined','limit','count','offset','set','Content-Range','apply','reject','save','update','then','destroy','VoiceQueues','inbound','outbound','filter','ignore','map','includes','value','type','name','UserProfileResource','sendStatus','stack','index','VoiceQueue','key','keys','query','model','attributes','intersection','fields','length','hasOwnProperty'];(function(_0x3a245d,_0x21d769){var _0x4867f2=function(_0x1dd270){while(--_0x1dd270){_0x3a245d['push'](_0x3a245d['shift']());}};_0x4867f2(++_0x21d769);}(_0x8f6b,0x146));var _0xb8f6=function(_0x5447fd,_0x52a6b5){_0x5447fd=_0x5447fd-0x0;var _0x15b28a=_0x8f6b[_0x5447fd];return _0x15b28a;};'use strict';var emlformat=require(_0xb8f6('0x0'));var rimraf=require(_0xb8f6('0x1'));var zipdir=require(_0xb8f6('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xb8f6('0x3'));var moment=require(_0xb8f6('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xb8f6('0x5'));var util=require(_0xb8f6('0x6'));var path=require('path');var sox=require(_0xb8f6('0x7'));var csv=require('to-csv');var ejs=require(_0xb8f6('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xb8f6('0x9'));var squel=require('squel');var crypto=require(_0xb8f6('0xa'));var jsforce=require(_0xb8f6('0xb'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xb8f6('0xc'));var Papa=require(_0xb8f6('0xd'));var Redis=require(_0xb8f6('0xe'));var authService=require(_0xb8f6('0xf'));var qs=require(_0xb8f6('0x10'));var as=require(_0xb8f6('0x11'));var hardwareService=require(_0xb8f6('0x12'));var logger=require(_0xb8f6('0x13'))(_0xb8f6('0x14'));var utils=require(_0xb8f6('0x15'));var config=require(_0xb8f6('0x16'));var licenseUtil=require(_0xb8f6('0x17'));var db=require('../../mysqldb')['db'];config[_0xb8f6('0x18')]=_[_0xb8f6('0x19')](config['redis'],{'host':_0xb8f6('0x1a'),'port':0x18eb});var socket=require(_0xb8f6('0x1b'))(new Redis(config[_0xb8f6('0x18')]));require('./voiceQueue.socket')[_0xb8f6('0x1c')](socket);function respondWithStatusCode(_0x50d3a1,_0x237dc3){_0x237dc3=_0x237dc3||0xcc;return function(_0x2aee53){if(_0x2aee53){return _0x50d3a1['sendStatus'](_0x237dc3);}return _0x50d3a1['status'](_0x237dc3)[_0xb8f6('0x1d')]();};}function respondWithResult(_0x28c214,_0x2db63b){_0x2db63b=_0x2db63b||0xc8;return function(_0x8f42ec){if(_0x8f42ec){return _0x28c214[_0xb8f6('0x1e')](_0x2db63b)[_0xb8f6('0x1f')](_0x8f42ec);}};}function respondWithFilteredResult(_0x2e998b,_0x30c2b3){return function(_0x3592a5){if(_0x3592a5){var _0x537d5e=typeof _0x30c2b3['offset']===_0xb8f6('0x20')&&typeof _0x30c2b3[_0xb8f6('0x21')]===_0xb8f6('0x20');var _0x335e9c=_0x3592a5[_0xb8f6('0x22')];var _0x5c2506=_0x537d5e?0x0:_0x30c2b3[_0xb8f6('0x23')];var _0x13f964=_0x537d5e?_0x3592a5[_0xb8f6('0x22')]:_0x30c2b3[_0xb8f6('0x23')]+_0x30c2b3['limit'];var _0x38c93e;if(_0x13f964>=_0x335e9c){_0x13f964=_0x335e9c;_0x38c93e=0xc8;}else{_0x38c93e=0xce;}_0x2e998b[_0xb8f6('0x1e')](_0x38c93e);return _0x2e998b[_0xb8f6('0x24')](_0xb8f6('0x25'),_0x5c2506+'-'+_0x13f964+'/'+_0x335e9c)[_0xb8f6('0x1f')](_0x3592a5);}return null;};}function patchUpdates(_0x59c5f1){return function(_0x3805d7){try{jsonpatch[_0xb8f6('0x26')](_0x3805d7,_0x59c5f1,!![]);}catch(_0x4e62c0){return BPromise[_0xb8f6('0x27')](_0x4e62c0);}return _0x3805d7[_0xb8f6('0x28')]();};}function saveUpdates(_0x3a4fd2,_0x15e0cb){return function(_0x4ca430){if(_0x4ca430){return _0x4ca430[_0xb8f6('0x29')](_0x3a4fd2)[_0xb8f6('0x2a')](function(_0x4fea2e){return _0x4fea2e;});}return null;};}function removeEntity(_0x3e9b2b,_0x4ee750){return function(_0x126f78){if(_0x126f78){return _0x126f78[_0xb8f6('0x2b')]()[_0xb8f6('0x2a')](function(){var _0x1b0f80=_0x126f78['get']({'plain':!![]});var _0x36ad7a=[{'name':_0xb8f6('0x2c'),'value':_0xb8f6('0x2d'),'ignore':![]},{'name':'QueueCampaigns','value':_0xb8f6('0x2e'),'ignore':![]}];var _0x2c0600=_(_0x36ad7a)[_0xb8f6('0x2f')](_0xb8f6('0x30'))[_0xb8f6('0x31')]('value')['value']();if(_[_0xb8f6('0x32')](_0x2c0600,_0x1b0f80['type'])){return;}var _0x2f98ff=_['find'](_0x36ad7a,[_0xb8f6('0x33'),_0x1b0f80[_0xb8f6('0x34')]])[_0xb8f6('0x35')];return db[_0xb8f6('0x36')][_0xb8f6('0x2b')]({'where':{'type':_0x2f98ff,'resourceId':_0x1b0f80['id']}})[_0xb8f6('0x2a')](function(){return _0x126f78;});})[_0xb8f6('0x2a')](function(){_0x3e9b2b[_0xb8f6('0x1e')](0xcc)[_0xb8f6('0x1d')]();});}};}function handleEntityNotFound(_0x5b509a,_0x23def4){return function(_0x1173cb){if(!_0x1173cb){_0x5b509a[_0xb8f6('0x37')](0x194);}return _0x1173cb;};}function handleError(_0xcb1a51,_0x4c5c52){_0x4c5c52=_0x4c5c52||0x1f4;return function(_0x3bfc5a){logger['error'](_0x3bfc5a[_0xb8f6('0x38')]);if(_0x3bfc5a[_0xb8f6('0x35')]){delete _0x3bfc5a[_0xb8f6('0x35')];}_0xcb1a51[_0xb8f6('0x1e')](_0x4c5c52)['send'](_0x3bfc5a);};}exports[_0xb8f6('0x39')]=function(_0x4b5f65,_0x3b268b){var _0x546081={},_0x238778={},_0x5e9c8f={'count':0x0,'rows':[]};var _0x2bf4d2=_[_0xb8f6('0x31')](db[_0xb8f6('0x3a')]['rawAttributes'],function(_0x2ba31c){return{'name':_0x2ba31c['fieldName'],'type':_0x2ba31c[_0xb8f6('0x34')][_0xb8f6('0x3b')]};});_0x238778['model']=_[_0xb8f6('0x31')](_0x2bf4d2,_0xb8f6('0x35'));_0x238778['query']=_[_0xb8f6('0x3c')](_0x4b5f65[_0xb8f6('0x3d')]);_0x238778['filters']=_['intersection'](_0x238778[_0xb8f6('0x3e')],_0x238778[_0xb8f6('0x3d')]);_0x546081[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x238778[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x4b5f65['query'][_0xb8f6('0x41')]));_0x546081[_0xb8f6('0x3f')]=_0x546081[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x546081[_0xb8f6('0x3f')]:_0x238778[_0xb8f6('0x3e')];if(!_0x4b5f65['query'][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x546081['limit']=qs[_0xb8f6('0x21')](_0x4b5f65[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x546081[_0xb8f6('0x23')]=qs[_0xb8f6('0x23')](_0x4b5f65['query']['offset']);}_0x546081[_0xb8f6('0x45')]=qs['sort'](_0x4b5f65[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x546081[_0xb8f6('0x47')]=qs['filters'](_[_0xb8f6('0x48')](_0x4b5f65[_0xb8f6('0x3d')],_0x238778[_0xb8f6('0x49')]),_0x2bf4d2);if(_0x4b5f65[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x546081[_0xb8f6('0x47')]=_['merge'](_0x546081[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x2bf4d2,function(_0x7fad7c){if(_0x7fad7c[_0xb8f6('0x34')]!==_0xb8f6('0x4a')){var _0x1a1650={};_0x1a1650[_0x7fad7c[_0xb8f6('0x35')]]={'$like':'%'+_0x4b5f65['query'][_0xb8f6('0x2f')]+'%'};return _0x1a1650;}})});}_0x546081=_[_0xb8f6('0x4b')]({},_0x546081,_0x4b5f65[_0xb8f6('0x4c')]);var _0x2d148f={'where':_0x546081[_0xb8f6('0x47')]};return db[_0xb8f6('0x3a')][_0xb8f6('0x22')](_0x2d148f)['then'](function(_0x5c1a54){_0x5e9c8f[_0xb8f6('0x22')]=_0x5c1a54;if(_0x4b5f65[_0xb8f6('0x3d')][_0xb8f6('0x4d')]){_0x546081[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x3a')]['findAll'](_0x546081);})[_0xb8f6('0x2a')](function(_0x47e77c){_0x5e9c8f[_0xb8f6('0x4f')]=_0x47e77c;return _0x5e9c8f;})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x3b268b,_0x546081))[_0xb8f6('0x50')](handleError(_0x3b268b,null));};exports[_0xb8f6('0x51')]=function(_0x331539,_0x2191ae){var _0x5702f4={'raw':![],'where':{'id':_0x331539[_0xb8f6('0x52')]['id']}},_0x47723a={};_0x47723a['model']=_[_0xb8f6('0x3c')](db['VoiceQueue']['rawAttributes']);_0x47723a['query']=_[_0xb8f6('0x3c')](_0x331539[_0xb8f6('0x3d')]);_0x47723a[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x47723a['model'],_0x47723a[_0xb8f6('0x3d')]);_0x5702f4[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x47723a[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x331539[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0x5702f4['attributes']=_0x5702f4['attributes'][_0xb8f6('0x42')]?_0x5702f4[_0xb8f6('0x3f')]:_0x47723a[_0xb8f6('0x3e')];if(_0x331539[_0xb8f6('0x3d')][_0xb8f6('0x4d')]){_0x5702f4[_0xb8f6('0x4e')]=[{'all':!![]}];}_0x5702f4=_[_0xb8f6('0x4b')]({},_0x5702f4,_0x331539[_0xb8f6('0x4c')]);return db[_0xb8f6('0x3a')][_0xb8f6('0x53')](_0x5702f4)[_0xb8f6('0x2a')](handleEntityNotFound(_0x2191ae,null))['then'](respondWithResult(_0x2191ae,null))[_0xb8f6('0x50')](handleError(_0x2191ae,null));};exports['create']=function(_0x17b711,_0x5a5180){return db[_0xb8f6('0x3a')]['create'](_0x17b711[_0xb8f6('0x54')],{})['then'](function(_0x50bb2f){var _0x22ea73=_0x17b711['user']['get']({'plain':!![]});if(!_0x22ea73)throw new Error(_0xb8f6('0x55'));if(_0x22ea73[_0xb8f6('0x56')]==='user'){var _0x9440c8=_0x50bb2f[_0xb8f6('0x57')]({'plain':!![]});var _0x1a2328=[{'name':_0xb8f6('0x2c'),'value':_0xb8f6('0x2d')},{'name':_0xb8f6('0x58'),'value':'outbound'}];var _0x242c89=_['find'](_0x1a2328,[_0xb8f6('0x33'),_0x9440c8[_0xb8f6('0x34')]])[_0xb8f6('0x35')];return db['UserProfileSection']['find']({'where':{'name':_0x242c89,'userProfileId':_0x22ea73[_0xb8f6('0x59')]},'raw':!![]})[_0xb8f6('0x2a')](function(_0x5b397d){if(_0x5b397d&&_0x5b397d[_0xb8f6('0x5a')]===0x0){return db['UserProfileResource']['create']({'name':_0x9440c8['name'],'resourceId':_0x9440c8['id'],'type':_0x5b397d[_0xb8f6('0x35')],'sectionId':_0x5b397d['id']},{})[_0xb8f6('0x2a')](function(){return _0x50bb2f;});}else{return _0x50bb2f;}})['catch'](function(_0x362858){logger[_0xb8f6('0x5b')](_0xb8f6('0x5c'),_0x362858);throw _0x362858;});}return _0x50bb2f;})[_0xb8f6('0x2a')](respondWithResult(_0x5a5180,0xc9))[_0xb8f6('0x50')](handleError(_0x5a5180,null));};exports[_0xb8f6('0x5d')]=function(_0x26ceb6,_0x2463ed){var _0x12b485={'where':{'id':_0x26ceb6[_0xb8f6('0x52')]['id']}},_0x401e9f={};_0x401e9f[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x3a')][_0xb8f6('0x5e')]);_0x12b485[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x401e9f[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x26ceb6[_0xb8f6('0x3d')]['fields']));_0x12b485[_0xb8f6('0x3f')]=_0x12b485['attributes'][_0xb8f6('0x42')]?_0x12b485[_0xb8f6('0x3f')]:_0x401e9f[_0xb8f6('0x3e')];if(_0x26ceb6[_0xb8f6('0x3d')][_0xb8f6('0x4d')]){_0x12b485[_0xb8f6('0x4e')]=[{'all':!![]}];}_0x12b485=_[_0xb8f6('0x4b')]({},_0x12b485,_0x26ceb6[_0xb8f6('0x4c')]);return db['VoiceQueue'][_0xb8f6('0x53')](_0x12b485)[_0xb8f6('0x2a')](handleEntityNotFound(_0x2463ed,null))[_0xb8f6('0x2a')](function(_0x1a1910){if(_0x1a1910){var _0x3587eb=_0x1a1910[_0xb8f6('0x57')]({'plain':!![]});_0x3587eb=qs[_0xb8f6('0x5f')](_0x3587eb,['id',_0xb8f6('0x60'),'updatedAt']);_0x26ceb6[_0xb8f6('0x54')]=_[_0xb8f6('0x5f')](_0x26ceb6[_0xb8f6('0x54')],['id',_0xb8f6('0x60'),'updatedAt']);return db[_0xb8f6('0x3a')][_0xb8f6('0x61')](_[_0xb8f6('0x4b')](_0x3587eb,_0x26ceb6[_0xb8f6('0x54')]),{'include':_0x26ceb6[_0xb8f6('0x3d')][_0xb8f6('0x4d')]?[{'all':!![]}]:undefined})[_0xb8f6('0x2a')](function(_0xce53f){var _0x2312d5=_0x26ceb6[_0xb8f6('0x62')][_0xb8f6('0x57')]({'plain':!![]});if(!_0x2312d5)throw new Error(_0xb8f6('0x55'));if(_0x2312d5[_0xb8f6('0x56')]==='user'){var _0x3dfa2d=_0xce53f['get']({'plain':!![]});var _0x3da374=[{'name':_0xb8f6('0x2c'),'value':_0xb8f6('0x2d')},{'name':'QueueCampaigns','value':_0xb8f6('0x2e')}];var _0x256df0=_[_0xb8f6('0x53')](_0x3da374,['value',_0x3dfa2d[_0xb8f6('0x34')]])['name'];return db['UserProfileSection'][_0xb8f6('0x53')]({'where':{'name':_0x256df0,'userProfileId':_0x2312d5[_0xb8f6('0x59')]},'raw':!![]})[_0xb8f6('0x2a')](function(_0x5556d5){if(_0x5556d5&&_0x5556d5[_0xb8f6('0x5a')]===0x0){return db[_0xb8f6('0x36')][_0xb8f6('0x61')]({'name':_0x3dfa2d[_0xb8f6('0x35')],'resourceId':_0x3dfa2d['id'],'type':_0x5556d5['name'],'sectionId':_0x5556d5['id']},{})['then'](function(){return _0xce53f;});}else{return _0xce53f;}})['catch'](function(_0x37873f){logger[_0xb8f6('0x5b')](_0xb8f6('0x5c'),_0x37873f);throw _0x37873f;});}return _0xce53f;});}})[_0xb8f6('0x2a')](respondWithResult(_0x2463ed,0xc9))[_0xb8f6('0x50')](handleError(_0x2463ed,null));};exports['update']=function(_0x34baf2,_0xf170e3){if(_0x34baf2[_0xb8f6('0x54')]['id']){delete _0x34baf2[_0xb8f6('0x54')]['id'];}return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x34baf2[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0xf170e3,null))[_0xb8f6('0x2a')](saveUpdates(_0x34baf2[_0xb8f6('0x54')],null))[_0xb8f6('0x2a')](respondWithResult(_0xf170e3,null))['catch'](handleError(_0xf170e3,null));};exports[_0xb8f6('0x2b')]=function(_0x55b72e,_0x5b547a){return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x55b72e[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x5b547a,null))['then'](removeEntity(_0x5b547a,null))[_0xb8f6('0x50')](handleError(_0x5b547a,null));};exports[_0xb8f6('0x63')]=function(_0x442b9d,_0x18967c,_0x3f04b2){var _0x454ca0={'raw':![],'where':{}};var _0x4684fb={};var _0x33f846={'count':0x0,'rows':[]};return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x442b9d['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x18967c,null))[_0xb8f6('0x2a')](function(_0x3ae9c4){if(_0x3ae9c4){_0x4684fb[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x65')][_0xb8f6('0x5e')]);_0x4684fb[_0xb8f6('0x3d')]=_[_0xb8f6('0x3c')](_0x442b9d[_0xb8f6('0x3d')]);_0x4684fb[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x4684fb[_0xb8f6('0x3e')],_0x4684fb['query']);_0x454ca0[_0xb8f6('0x3f')]=_['intersection'](_0x4684fb[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0x454ca0[_0xb8f6('0x3f')]=_0x454ca0['attributes'][_0xb8f6('0x42')]?_0x454ca0[_0xb8f6('0x3f')]:_0x4684fb[_0xb8f6('0x3e')];if(!_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x454ca0[_0xb8f6('0x21')]=qs['limit'](_0x442b9d[_0xb8f6('0x3d')]['limit']);_0x454ca0['offset']=qs[_0xb8f6('0x23')](_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x23')]);}_0x454ca0[_0xb8f6('0x45')]=qs['sort'](_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x454ca0['where']=qs['filters'](_[_0xb8f6('0x48')](_0x442b9d[_0xb8f6('0x3d')],_0x4684fb['filters']));_0x454ca0[_0xb8f6('0x47')][_0xb8f6('0x66')]=_0x3ae9c4['id'];if(_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x454ca0[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x454ca0[_0xb8f6('0x47')],{'$or':_['map'](_0x454ca0[_0xb8f6('0x3f')],function(_0x567190){var _0x42180c={};_0x42180c[_0x567190]={'$like':'%'+_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x42180c;})});}_0x454ca0=_['merge']({},_0x454ca0,_0x442b9d[_0xb8f6('0x4c')]);return db[_0xb8f6('0x65')][_0xb8f6('0x22')]({'where':_0x454ca0[_0xb8f6('0x47')]})[_0xb8f6('0x2a')](function(_0x28998e){_0x33f846['count']=_0x28998e;if(_0x442b9d['query']['includeAll']){_0x454ca0[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x65')][_0xb8f6('0x67')](_0x454ca0);})[_0xb8f6('0x2a')](function(_0x5926c2){_0x33f846[_0xb8f6('0x4f')]=_0x5926c2;return _0x33f846;});}})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x18967c,_0x454ca0))['catch'](handleError(_0x18967c,null));};exports['getHopperHistories']=function(_0x41bf59,_0x2c8055,_0x37e28c){var _0x164219={'raw':!![],'where':{}};var _0x435e8e={};var _0x4ad371={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x41bf59['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x2c8055,null))[_0xb8f6('0x2a')](function(_0x583afa){if(_0x583afa){_0x435e8e[_0xb8f6('0x3e')]=_['keys'](db['CmHopperHistory'][_0xb8f6('0x5e')]);_0x435e8e['query']=_[_0xb8f6('0x3c')](_0x41bf59['query']);_0x435e8e[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x435e8e[_0xb8f6('0x3e')],_0x435e8e[_0xb8f6('0x3d')]);_0x164219[_0xb8f6('0x3f')]=_['intersection'](_0x435e8e[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x41bf59[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0x164219[_0xb8f6('0x3f')]=_0x164219[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x164219['attributes']:_0x435e8e[_0xb8f6('0x3e')];if(!_0x41bf59['query'][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x164219[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x41bf59['query'][_0xb8f6('0x21')]);_0x164219[_0xb8f6('0x23')]=qs[_0xb8f6('0x23')](_0x41bf59[_0xb8f6('0x3d')]['offset']);}_0x164219[_0xb8f6('0x45')]=qs[_0xb8f6('0x46')](_0x41bf59[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x164219['where']=qs['filters'](_[_0xb8f6('0x48')](_0x41bf59[_0xb8f6('0x3d')],_0x435e8e[_0xb8f6('0x49')]));_0x164219[_0xb8f6('0x47')][_0xb8f6('0x66')]=_0x583afa['id'];if(_0x41bf59['query']['filter']){_0x164219[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x164219[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x164219['attributes'],function(_0x5347f5){var _0x27622d={};_0x27622d[_0x5347f5]={'$like':'%'+_0x41bf59[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x27622d;})});}_0x164219=_[_0xb8f6('0x4b')]({},_0x164219,_0x41bf59[_0xb8f6('0x4c')]);return db[_0xb8f6('0x68')][_0xb8f6('0x22')]({'where':_0x164219[_0xb8f6('0x47')]})[_0xb8f6('0x2a')](function(_0x36ad59){_0x4ad371['count']=_0x36ad59;if(_0x41bf59[_0xb8f6('0x3d')][_0xb8f6('0x4d')]){_0x164219[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x68')]['findAll'](_0x164219);})[_0xb8f6('0x2a')](function(_0x47ab85){_0x4ad371[_0xb8f6('0x4f')]=_0x47ab85;return _0x4ad371;});}})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x2c8055,_0x164219))['catch'](handleError(_0x2c8055,null));};exports[_0xb8f6('0x69')]=function(_0x34b15c,_0x8cc47c,_0x343168){var _0x910baa={'raw':!![],'where':{}};var _0x25e482={};var _0x562671={'count':0x0,'rows':[]};return db[_0xb8f6('0x3a')]['findOne']({'where':{'id':_0x34b15c[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x8cc47c,null))[_0xb8f6('0x2a')](function(_0x2feb9c){if(_0x2feb9c){_0x25e482['model']=_['keys'](db[_0xb8f6('0x6a')][_0xb8f6('0x5e')]);_0x25e482['query']=_[_0xb8f6('0x3c')](_0x34b15c[_0xb8f6('0x3d')]);_0x25e482[_0xb8f6('0x49')]=_['intersection'](_0x25e482[_0xb8f6('0x3e')],_0x25e482[_0xb8f6('0x3d')]);_0x910baa['attributes']=_[_0xb8f6('0x40')](_0x25e482[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x34b15c[_0xb8f6('0x3d')]['fields']));_0x910baa['attributes']=_0x910baa[_0xb8f6('0x3f')]['length']?_0x910baa[_0xb8f6('0x3f')]:_0x25e482[_0xb8f6('0x3e')];if(!_0x34b15c[_0xb8f6('0x3d')][_0xb8f6('0x43')]('nolimit')){_0x910baa['limit']=qs[_0xb8f6('0x21')](_0x34b15c[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x910baa[_0xb8f6('0x23')]=qs['offset'](_0x34b15c['query'][_0xb8f6('0x23')]);}_0x910baa[_0xb8f6('0x45')]=qs[_0xb8f6('0x46')](_0x34b15c['query'][_0xb8f6('0x46')]);_0x910baa[_0xb8f6('0x47')]=qs[_0xb8f6('0x49')](_['pick'](_0x34b15c[_0xb8f6('0x3d')],_0x25e482[_0xb8f6('0x49')]));_0x910baa[_0xb8f6('0x47')]['VoiceQueueId']=_0x2feb9c['id'];if(_0x34b15c[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x910baa[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x910baa[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x910baa[_0xb8f6('0x3f')],function(_0x280031){var _0x17aca4={};_0x17aca4[_0x280031]={'$like':'%'+_0x34b15c[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x17aca4;})});}_0x910baa=_[_0xb8f6('0x4b')]({},_0x910baa,_0x34b15c[_0xb8f6('0x4c')]);return db[_0xb8f6('0x6a')][_0xb8f6('0x22')]({'where':_0x910baa[_0xb8f6('0x47')]})[_0xb8f6('0x2a')](function(_0x3c2134){_0x562671['count']=_0x3c2134;if(_0x34b15c[_0xb8f6('0x3d')]['includeAll']){_0x910baa[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x6a')]['findAll'](_0x910baa);})['then'](function(_0x2773f2){_0x562671['rows']=_0x2773f2;return _0x562671;});}})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x8cc47c,_0x910baa))['catch'](handleError(_0x8cc47c,null));};exports[_0xb8f6('0x6b')]=function(_0x240edd,_0x590b72,_0x4433ab){var _0x45addb={'raw':!![],'where':{}};var _0x175cc2={};var _0x380191={'count':0x0,'rows':[]};return db[_0xb8f6('0x3a')]['findOne']({'where':{'id':_0x240edd[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x590b72,null))[_0xb8f6('0x2a')](function(_0x230f75){if(_0x230f75){_0x175cc2[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x6c')][_0xb8f6('0x5e')]);_0x175cc2['query']=_['keys'](_0x240edd['query']);_0x175cc2[_0xb8f6('0x49')]=_['intersection'](_0x175cc2[_0xb8f6('0x3e')],_0x175cc2[_0xb8f6('0x3d')]);_0x45addb[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x175cc2[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x240edd[_0xb8f6('0x3d')]['fields']));_0x45addb[_0xb8f6('0x3f')]=_0x45addb[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x45addb[_0xb8f6('0x3f')]:_0x175cc2[_0xb8f6('0x3e')];if(!_0x240edd[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x45addb[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x240edd[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x45addb[_0xb8f6('0x23')]=qs[_0xb8f6('0x23')](_0x240edd[_0xb8f6('0x3d')]['offset']);}_0x45addb[_0xb8f6('0x45')]=qs[_0xb8f6('0x46')](_0x240edd['query'][_0xb8f6('0x46')]);_0x45addb[_0xb8f6('0x47')]=qs[_0xb8f6('0x49')](_[_0xb8f6('0x48')](_0x240edd['query'],_0x175cc2[_0xb8f6('0x49')]));_0x45addb[_0xb8f6('0x47')][_0xb8f6('0x66')]=_0x230f75['id'];if(_0x240edd['query']['filter']){_0x45addb[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x45addb[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x45addb['attributes'],function(_0x2a63ae){var _0xa4666f={};_0xa4666f[_0x2a63ae]={'$like':'%'+_0x240edd['query'][_0xb8f6('0x2f')]+'%'};return _0xa4666f;})});}_0x45addb=_['merge']({},_0x45addb,_0x240edd[_0xb8f6('0x4c')]);return db[_0xb8f6('0x6c')]['count']({'where':_0x45addb[_0xb8f6('0x47')]})['then'](function(_0x451740){_0x380191[_0xb8f6('0x22')]=_0x451740;if(_0x240edd[_0xb8f6('0x3d')]['includeAll']){_0x45addb[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x6c')][_0xb8f6('0x67')](_0x45addb);})[_0xb8f6('0x2a')](function(_0x379f58){_0x380191[_0xb8f6('0x4f')]=_0x379f58;return _0x380191;});}})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x590b72,_0x45addb))['catch'](handleError(_0x590b72,null));};exports[_0xb8f6('0x6d')]=function(_0x12b220,_0x49403d,_0x24a2ec){var _0xbab6b3={};var _0x18a0df={};var _0x2187c0;var _0x5677a6;return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x12b220['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x49403d,null))[_0xb8f6('0x2a')](function(_0x4820ac){if(_0x4820ac){_0x2187c0=_0x4820ac;_0x18a0df[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x6e')][_0xb8f6('0x5e')]);_0x18a0df['query']=_[_0xb8f6('0x3c')](_0x12b220[_0xb8f6('0x3d')]);_0x18a0df[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x18a0df[_0xb8f6('0x3e')],_0x18a0df['query']);_0xbab6b3['attributes']=_[_0xb8f6('0x40')](_0x18a0df[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x12b220[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0xbab6b3['attributes']=_0xbab6b3[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0xbab6b3[_0xb8f6('0x3f')]:_0x18a0df[_0xb8f6('0x3e')];_0xbab6b3[_0xb8f6('0x45')]=qs['sort'](_0x12b220[_0xb8f6('0x3d')]['sort']);_0xbab6b3[_0xb8f6('0x47')]=qs[_0xb8f6('0x49')](_[_0xb8f6('0x48')](_0x12b220[_0xb8f6('0x3d')],_0x18a0df[_0xb8f6('0x49')]));if(_0x12b220['query'][_0xb8f6('0x2f')]){_0xbab6b3[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0xbab6b3[_0xb8f6('0x47')],{'$or':_['map'](_0xbab6b3[_0xb8f6('0x3f')],function(_0x566fea){var _0x5b402f={};_0x5b402f[_0x566fea]={'$like':'%'+_0x12b220['query'][_0xb8f6('0x2f')]+'%'};return _0x5b402f;})});}_0xbab6b3=_[_0xb8f6('0x4b')]({},_0xbab6b3,_0x12b220['options']);return _0x2187c0[_0xb8f6('0x6d')](_0xbab6b3);}})[_0xb8f6('0x2a')](function(_0x37109d){if(_0x37109d){_0x5677a6=_0x37109d['length'];if(!_0x12b220['query']['hasOwnProperty']('nolimit')){_0xbab6b3[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x12b220[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0xbab6b3[_0xb8f6('0x23')]=qs['offset'](_0x12b220[_0xb8f6('0x3d')]['offset']);}return _0x2187c0['getTeams'](_0xbab6b3);}})[_0xb8f6('0x2a')](function(_0xa80e81){if(_0xa80e81){return _0xa80e81?{'count':_0x5677a6,'rows':_0xa80e81}:null;}})[_0xb8f6('0x2a')](respondWithResult(_0x49403d,null))['catch'](handleError(_0x49403d,null));};exports[_0xb8f6('0x6f')]=function(_0x9c9558,_0x164f8a,_0x6e4170){var _0x3927e7=_0x9c9558[_0xb8f6('0x54')][_0xb8f6('0x70')];var _0x254e42=_[_0xb8f6('0x31')](_0x3927e7,'id');return db[_0xb8f6('0x6e')][_0xb8f6('0x67')]({'where':{'id':_0x254e42},'attributes':['id'],'include':[{'model':db[_0xb8f6('0x71')],'as':'Agents','attributes':['id',_0xb8f6('0x35'),_0xb8f6('0x72'),'voicePause','interface'],'raw':!![]}]})['then'](function(_0x41dfc0){if(_0x41dfc0){var _0x117c53=_[_0xb8f6('0x73')](_0x41dfc0,function(_0x4e1696){var _0x2e714b=_0x4e1696[_0xb8f6('0x57')]({'plain':!![]});_0x2e714b[_0xb8f6('0x74')]['forEach'](function(_0x1a3c91){_0x1a3c91[_0xb8f6('0x75')]=_[_0xb8f6('0x53')](_0x3927e7,{'id':_0x2e714b['id']})[_0xb8f6('0x75')];});return _0x2e714b[_0xb8f6('0x74')];});return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x9c9558[_0xb8f6('0x52')]['id']}})['then'](function(_0x1685fd){return db[_0xb8f6('0x76')][_0xb8f6('0x77')](function(_0x12f8a){return _0x1685fd[_0xb8f6('0x6f')](_0x254e42,{'transaction':_0x12f8a})['then'](function(){return BPromise[_0xb8f6('0x78')](_0x3927e7,function(_0x55b680){return db[_0xb8f6('0x79')][_0xb8f6('0x7a')]({'TeamId':_0x55b680['id'],'VoiceQueueId':_0x9c9558[_0xb8f6('0x52')]['id'],'penalty':_0x55b680['penalty']},{'transaction':_0x12f8a});});})[_0xb8f6('0x2a')](function(){return BPromise[_0xb8f6('0x78')](_0x117c53,function(_0x437491){return db[_0xb8f6('0x7b')][_0xb8f6('0x7c')]({'where':{'UserId':_0x437491['id'],'VoiceQueueId':_0x9c9558['params']['id']},'defaults':{'penalty':_0x437491[_0xb8f6('0x75')]},'transaction':_0x12f8a});});})['then'](function(){return BPromise[_0xb8f6('0x78')](_[_0xb8f6('0x2f')](_0x117c53,{'online':!![]}),function(_0x1ca744){return db[_0xb8f6('0x7d')][_0xb8f6('0x7a')]({'membername':_0x1ca744[_0xb8f6('0x35')],'UserId':_0x1ca744['id'],'queue_name':_0x1685fd[_0xb8f6('0x35')],'VoiceQueueId':_0x1685fd['id'],'interface':_[_0xb8f6('0x7e')](_0x1ca744[_0xb8f6('0x7f')])?util[_0xb8f6('0x80')](_0xb8f6('0x81'),_0x1ca744['name']):_0x1ca744[_0xb8f6('0x7f')],'paused':_0x1ca744[_0xb8f6('0x82')]||![],'penalty':_0x1ca744[_0xb8f6('0x75')]},{'transaction':_0x12f8a});});})[_0xb8f6('0x2a')](function(){_0x117c53['forEach'](function(_0x2ea673){socket[_0xb8f6('0x83')](_0xb8f6('0x84'),{'UserId':_0x2ea673['id'],'VoiceQueueId':_0x1685fd['id']});});});});});}})[_0xb8f6('0x2a')](respondWithStatusCode(_0x164f8a,null))[_0xb8f6('0x50')](handleError(_0x164f8a,null));};exports[_0xb8f6('0x85')]=function(_0x4c3e2a,_0x2f91cc,_0x5f1cb9){return db[_0xb8f6('0x6e')][_0xb8f6('0x67')]({'where':{'id':_0x4c3e2a[_0xb8f6('0x3d')]['ids']},'attributes':['id'],'include':[{'model':db[_0xb8f6('0x71')],'as':_0xb8f6('0x74'),'attributes':['id'],'raw':!![]}]})[_0xb8f6('0x2a')](handleEntityNotFound(_0x2f91cc,null))[_0xb8f6('0x2a')](function(_0x243b99){var _0x43111a=_[_0xb8f6('0x31')](_0x243b99,'id');var _0x2194c8=[];var _0x2dbbb2=[];var _0x2e585e=squel[_0xb8f6('0x86')]();_0x2e585e[_0xb8f6('0x87')](_0xb8f6('0x88'))[_0xb8f6('0x89')](_0xb8f6('0x8a'),'tq')[_0xb8f6('0x8b')](_0xb8f6('0x8c'),'ut',_0xb8f6('0x8d'))[_0xb8f6('0x47')](_0xb8f6('0x8e'),_0x4c3e2a[_0xb8f6('0x52')]['id']);for(var _0x272257=0x0;_0x272257<_0x243b99[_0xb8f6('0x42')];_0x272257+=0x1){let _0x4bdf28=_0x243b99[_0x272257];for(var _0x27bc7a=0x0;_0x27bc7a<_0x4bdf28[_0xb8f6('0x74')][_0xb8f6('0x42')];_0x27bc7a+=0x1){let _0x58f1c=_0x4bdf28[_0xb8f6('0x74')][_0x27bc7a];var _0x1260fe=_0x2e585e[_0xb8f6('0x5d')]();_0x1260fe['where'](_0xb8f6('0x8f'),_0x58f1c['id']);_0x2dbbb2['push'](db[_0xb8f6('0x76')][_0xb8f6('0x3d')](_0x1260fe['toString'](),{'type':db[_0xb8f6('0x76')][_0xb8f6('0x90')]['SELECT']})['then'](function(_0x24c879){if(_0x24c879[_0xb8f6('0x42')]===0x1){return _0x58f1c['id'];}else{var _0x4fbaa6=_[_0xb8f6('0x91')](_['map'](_0x24c879,_0xb8f6('0x92')),function(_0x4e8c0f){return _[_0xb8f6('0x32')](_0x43111a,_0x4e8c0f);});if(_0x4fbaa6){return _0x58f1c['id'];}}}));}}return BPromise[_0xb8f6('0x93')](_0x2dbbb2)['then'](function(_0x4164f5){_0x2194c8=_(_0x2194c8)[_0xb8f6('0x94')](_0x4164f5)['compact']()[_0xb8f6('0x33')]();return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x4c3e2a[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](function(_0x2ed3d7){return db['sequelize'][_0xb8f6('0x77')](function(_0xdc912f){return _0x2ed3d7[_0xb8f6('0x85')](_0x4c3e2a[_0xb8f6('0x3d')]['ids'],{'transaction':_0xdc912f})[_0xb8f6('0x2a')](function(){if(!_[_0xb8f6('0x95')](_0x2194c8)){return _0x2ed3d7['removeAgents'](_0x2194c8,{'transaction':_0xdc912f})[_0xb8f6('0x2a')](function(){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x4c3e2a['params']['id'],'UserId':_0x2194c8},'transaction':_0xdc912f});});}})[_0xb8f6('0x2a')](function(){_0x2194c8['forEach'](function(_0x4b5007){socket[_0xb8f6('0x83')](_0xb8f6('0x96'),{'UserId':_0x4b5007,'VoiceQueueId':_0x2ed3d7['id']});});});});});});})[_0xb8f6('0x2a')](respondWithStatusCode(_0x2f91cc,null))['catch'](handleError(_0x2f91cc,null));};exports[_0xb8f6('0x97')]=function(_0x2271d4,_0x49c3a6,_0x159c45){var _0x58330f,_0x568960;return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x2271d4[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x49c3a6,null))['then'](function(_0x5a7274){if(_0x5a7274){_0x568960=_0x5a7274;return _0x5a7274[_0xb8f6('0x97')](_0x2271d4[_0xb8f6('0x54')][_0xb8f6('0x98')],_[_0xb8f6('0x5f')](_0x2271d4[_0xb8f6('0x54')],[_0xb8f6('0x98'),'id'])||{})[_0xb8f6('0x99')](function(_0x2cc0f8){for(var _0x2f0270=0x0;_0x2f0270<_0x2271d4[_0xb8f6('0x54')]['ids'][_0xb8f6('0x42')];_0x2f0270+=0x1){socket['emit']('userVoiceQueue:save',{'UserId':Number(_0x2271d4[_0xb8f6('0x54')][_0xb8f6('0x98')][_0x2f0270]),'VoiceQueueId':Number(_0x2271d4[_0xb8f6('0x52')]['id'])});}return _0x2cc0f8;});}})[_0xb8f6('0x2a')](function(_0x4c2b73){_0x58330f=_0x4c2b73||[];if(_0x568960){return db[_0xb8f6('0x71')]['findAll']({'where':{'id':_0x2271d4[_0xb8f6('0x54')]['ids']},'attributes':['id',_0xb8f6('0x35'),'online',_0xb8f6('0x82'),_0xb8f6('0x7f')],'raw':!![]});}})['then'](function(_0x30add6){if(!_[_0xb8f6('0x95')](_0x30add6)){var _0x10423b=[];for(var _0x365532=0x0;_0x365532<_0x30add6['length'];_0x365532++){if(_0x30add6[_0x365532][_0xb8f6('0x72')]){_0x10423b[_0xb8f6('0x9a')](db['UserVoiceQueueRt']['upsert']({'membername':_0x30add6[_0x365532]['name'],'UserId':_0x30add6[_0x365532]['id'],'queue_name':_0x568960[_0xb8f6('0x35')],'VoiceQueueId':_0x568960['id'],'interface':_[_0xb8f6('0x7e')](_0x30add6[_0x365532][_0xb8f6('0x7f')])?util[_0xb8f6('0x80')](_0xb8f6('0x81'),_0x30add6[_0x365532][_0xb8f6('0x35')]):_0x30add6[_0x365532][_0xb8f6('0x7f')],'paused':_0x30add6[_0x365532][_0xb8f6('0x82')]||![],'penalty':_0x2271d4[_0xb8f6('0x54')]['penalty']||0x0}));}}return BPromise[_0xb8f6('0x93')](_0x10423b);}})[_0xb8f6('0x2a')](function(){return _0x58330f;})['then'](respondWithResult(_0x49c3a6,null))['catch'](handleError(_0x49c3a6,null));};exports[_0xb8f6('0x9b')]=function(_0x3a234a,_0xa55633,_0x391b2e){return db['VoiceQueue'][_0xb8f6('0x53')]({'where':{'id':_0x3a234a[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0xa55633,null))[_0xb8f6('0x2a')](function(_0x49365a){if(_0x49365a){return _0x49365a[_0xb8f6('0x9b')](_0x3a234a[_0xb8f6('0x3d')][_0xb8f6('0x98')])[_0xb8f6('0x2a')](function(){if(_[_0xb8f6('0x9c')](_0x3a234a[_0xb8f6('0x3d')][_0xb8f6('0x98')])){for(var _0x801f2e=0x0;_0x801f2e<_0x3a234a[_0xb8f6('0x3d')][_0xb8f6('0x98')][_0xb8f6('0x42')];_0x801f2e+=0x1){socket[_0xb8f6('0x83')](_0xb8f6('0x96'),{'UserId':Number(_0x3a234a[_0xb8f6('0x3d')]['ids'][_0x801f2e]),'VoiceQueueId':Number(_0x3a234a[_0xb8f6('0x52')]['id'])});}}else{socket[_0xb8f6('0x83')](_0xb8f6('0x96'),{'UserId':Number(_0x3a234a['query']['ids']),'VoiceQueueId':Number(_0x3a234a[_0xb8f6('0x52')]['id'])});}});}})[_0xb8f6('0x2a')](function(_0xded28c){return db[_0xb8f6('0x7d')][_0xb8f6('0x2b')]({'where':{'VoiceQueueId':_0x3a234a[_0xb8f6('0x52')]['id'],'UserId':_0x3a234a[_0xb8f6('0x3d')]['ids']}})['then'](function(){return _0xded28c;});})[_0xb8f6('0x2a')](respondWithStatusCode(_0xa55633,null))[_0xb8f6('0x50')](handleError(_0xa55633,null));};exports['getAgents']=function(_0x302960,_0xf4e658,_0xc2d373){var _0x22dd7c={};var _0x2c0d95={};var _0x4c1e01;var _0x51d40e;return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x302960[_0xb8f6('0x52')]['id']}})['then'](handleEntityNotFound(_0xf4e658,null))[_0xb8f6('0x2a')](function(_0x3c8ed5){if(_0x3c8ed5){_0x4c1e01=_0x3c8ed5;_0x2c0d95[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x71')][_0xb8f6('0x5e')]);_0x2c0d95[_0xb8f6('0x3d')]=_['keys'](_0x302960[_0xb8f6('0x3d')]);_0x2c0d95['filters']=_['intersection'](_0x2c0d95[_0xb8f6('0x3e')],_0x2c0d95[_0xb8f6('0x3d')]);_0x22dd7c['attributes']=_[_0xb8f6('0x40')](_0x2c0d95['model'],qs[_0xb8f6('0x41')](_0x302960[_0xb8f6('0x3d')]['fields']));_0x22dd7c[_0xb8f6('0x3f')]=_0x22dd7c[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x22dd7c[_0xb8f6('0x3f')]:_0x2c0d95[_0xb8f6('0x3e')];_0x22dd7c['order']=qs[_0xb8f6('0x46')](_0x302960['query'][_0xb8f6('0x46')]);_0x22dd7c[_0xb8f6('0x47')]=qs['filters'](_[_0xb8f6('0x48')](_0x302960['query'],_0x2c0d95['filters']));if(_0x302960[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x22dd7c['where']=_[_0xb8f6('0x4b')](_0x22dd7c[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x22dd7c['attributes'],function(_0x43a6af){var _0x52d4df={};_0x52d4df[_0x43a6af]={'$like':'%'+_0x302960[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x52d4df;})});}_0x22dd7c=_['merge']({},_0x22dd7c,_0x302960[_0xb8f6('0x4c')]);return _0x4c1e01['getAgents'](_0x22dd7c);}})[_0xb8f6('0x2a')](function(_0x52e0ef){if(_0x52e0ef){_0x51d40e=_0x52e0ef[_0xb8f6('0x42')];if(!_0x302960[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x22dd7c[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x302960[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x22dd7c[_0xb8f6('0x23')]=qs[_0xb8f6('0x23')](_0x302960['query'][_0xb8f6('0x23')]);}return _0x4c1e01[_0xb8f6('0x9d')](_0x22dd7c);}})[_0xb8f6('0x2a')](function(_0x5ac6a8){if(_0x5ac6a8){return _0x5ac6a8?{'count':_0x51d40e,'rows':_0x5ac6a8}:null;}})[_0xb8f6('0x2a')](respondWithResult(_0xf4e658,null))[_0xb8f6('0x50')](handleError(_0xf4e658,null));};exports[_0xb8f6('0x9e')]=function(_0x550a63,_0x50dcbe,_0x4563b1){var _0x3f9b3d={};var _0x2d17f6={};var _0x3f0209;var _0x122e64;return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x550a63[_0xb8f6('0x52')]['id']}})['then'](handleEntityNotFound(_0x50dcbe,null))[_0xb8f6('0x2a')](function(_0x16f845){if(_0x16f845){_0x3f0209=_0x16f845;_0x2d17f6[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x7d')][_0xb8f6('0x5e')]);_0x2d17f6['query']=_[_0xb8f6('0x3c')](_0x550a63[_0xb8f6('0x3d')]);_0x2d17f6['filters']=_['intersection'](_0x2d17f6[_0xb8f6('0x3e')],_0x2d17f6['query']);_0x3f9b3d['attributes']=_[_0xb8f6('0x40')](_0x2d17f6[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0x3f9b3d[_0xb8f6('0x3f')]=_0x3f9b3d[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x3f9b3d[_0xb8f6('0x3f')]:_0x2d17f6['model'];_0x3f9b3d['order']=qs[_0xb8f6('0x46')](_0x550a63[_0xb8f6('0x3d')]['sort']);_0x3f9b3d[_0xb8f6('0x47')]=qs['filters'](_[_0xb8f6('0x48')](_0x550a63['query'],_0x2d17f6[_0xb8f6('0x49')]));if(_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x3f9b3d[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x3f9b3d[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x3f9b3d[_0xb8f6('0x3f')],function(_0x5d8a0b){var _0x20e569={};_0x20e569[_0x5d8a0b]={'$like':'%'+_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x20e569;})});}_0x3f9b3d=_[_0xb8f6('0x4b')]({},_0x3f9b3d,_0x550a63[_0xb8f6('0x4c')]);return _0x3f0209[_0xb8f6('0x9e')](_0x3f9b3d);}})[_0xb8f6('0x2a')](function(_0x57edb5){if(_0x57edb5){_0x122e64=_0x57edb5[_0xb8f6('0x42')];if(!_0x550a63[_0xb8f6('0x3d')]['hasOwnProperty'](_0xb8f6('0x44'))){_0x3f9b3d[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x3f9b3d['offset']=qs['offset'](_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x23')]);}return _0x3f0209[_0xb8f6('0x9e')](_0x3f9b3d);}})[_0xb8f6('0x2a')](function(_0x214b9a){return _0x214b9a?{'count':_0x122e64,'rows':_0x214b9a}:null;})[_0xb8f6('0x2a')](respondWithResult(_0x50dcbe,null))[_0xb8f6('0x50')](handleError(_0x50dcbe,null));};exports['getLists']=function(_0x475791,_0x4cfa57,_0x113a60){var _0x47ebea={};var _0x41db42={};var _0x3c9e30;var _0x2f5bf3;return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x475791[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x4cfa57,null))[_0xb8f6('0x2a')](function(_0x528156){if(_0x528156){_0x3c9e30=_0x528156;_0x41db42[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x9f')][_0xb8f6('0x5e')]);_0x41db42[_0xb8f6('0x3d')]=_[_0xb8f6('0x3c')](_0x475791[_0xb8f6('0x3d')]);_0x41db42['filters']=_[_0xb8f6('0x40')](_0x41db42['model'],_0x41db42['query']);_0x47ebea['attributes']=_[_0xb8f6('0x40')](_0x41db42[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x475791[_0xb8f6('0x3d')]['fields']));_0x47ebea[_0xb8f6('0x3f')]=_0x47ebea[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x47ebea[_0xb8f6('0x3f')]:_0x41db42[_0xb8f6('0x3e')];_0x47ebea['order']=qs[_0xb8f6('0x46')](_0x475791[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x47ebea[_0xb8f6('0x47')]=qs[_0xb8f6('0x49')](_[_0xb8f6('0x48')](_0x475791[_0xb8f6('0x3d')],_0x41db42[_0xb8f6('0x49')]));if(_0x475791[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x47ebea[_0xb8f6('0x47')]=_['merge'](_0x47ebea[_0xb8f6('0x47')],{'$or':_['map'](_0x47ebea['attributes'],function(_0x32d87a){var _0x4cbc95={};_0x4cbc95[_0x32d87a]={'$like':'%'+_0x475791[_0xb8f6('0x3d')]['filter']+'%'};return _0x4cbc95;})});}_0x47ebea=_[_0xb8f6('0x4b')]({},_0x47ebea,_0x475791[_0xb8f6('0x4c')]);return _0x3c9e30['getLists'](_0x47ebea);}})[_0xb8f6('0x2a')](function(_0xf54ae9){if(_0xf54ae9){_0x2f5bf3=_0xf54ae9[_0xb8f6('0x42')];if(!_0x475791[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x47ebea[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x475791[_0xb8f6('0x3d')]['limit']);_0x47ebea[_0xb8f6('0x23')]=qs['offset'](_0x475791['query']['offset']);}return _0x3c9e30[_0xb8f6('0xa0')](_0x47ebea);}})['then'](function(_0x1ad4a3){if(_0x1ad4a3){return _0x1ad4a3?{'count':_0x2f5bf3,'rows':_0x1ad4a3}:null;}})[_0xb8f6('0x2a')](respondWithResult(_0x4cfa57,null))[_0xb8f6('0x50')](handleError(_0x4cfa57,null));};exports[_0xb8f6('0xa1')]=function(_0x44d034,_0x5ba34a,_0xbafd08){var _0x20f45f=moment()['format']('YYYY-MM-DD\x20HH:mm:ss');var _0x1ebb54,_0xcf5610;return db['VoiceQueue']['find']({'where':{'id':_0x44d034['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x5ba34a,null))['then'](function(_0x154f01){if(_0x154f01){_0xcf5610=_0x154f01;return _0x154f01[_0xb8f6('0xa1')](_0x44d034[_0xb8f6('0x54')][_0xb8f6('0x98')],_[_0xb8f6('0x5f')](_0x44d034[_0xb8f6('0x54')],[_0xb8f6('0x98'),'id'])||{});}return null;})[_0xb8f6('0x99')](function(_0x2fb788){var _0x489313;_0x1ebb54=_0x2fb788||[];var _0x33ca2a=[];if(_0x2fb788){for(var _0x575018=0x0;_0x575018<_0x2fb788['length'];_0x575018+=0x1){var _0x2e57da=_0x2fb788[_0x575018][_0xb8f6('0x57')]({'plain':!![]});_0xcf5610[_0xb8f6('0xa2')]=_0x44d034['body']['dialCheckDuplicateType']?_0x44d034[_0xb8f6('0x54')][_0xb8f6('0xa2')]:_0xcf5610[_0xb8f6('0xa2')];switch(_0xcf5610['dialCheckDuplicateType']){case _0xb8f6('0xa3'):_0x489313=squel[_0xb8f6('0xa4')]()['into']('cm_hopper')[_0xb8f6('0xa5')]([_0xb8f6('0xa6'),_0xb8f6('0xa7'),_0xb8f6('0xa8'),_0xb8f6('0xa9'),_0xb8f6('0x66'),_0xb8f6('0x60'),_0xb8f6('0xaa')],squel[_0xb8f6('0x86')]()[_0xb8f6('0x87')](_0xb8f6('0xa6'),'phone')['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0xa7'))[_0xb8f6('0x87')]('id',_0xb8f6('0xa8'))['field'](_0x2e57da['CmListId'][_0xb8f6('0xab')](),'ListId')[_0xb8f6('0x87')](_0x44d034[_0xb8f6('0x52')]['id']['toString'](),_0xb8f6('0x66'))['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0x60'))['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0xaa'))[_0xb8f6('0x89')](_0xb8f6('0xac'))[_0xb8f6('0x47')](_0xb8f6('0xad'))[_0xb8f6('0x47')](_0xb8f6('0xae'),_0x2e57da[_0xb8f6('0xaf')][_0xb8f6('0xab')]())[_0xb8f6('0x47')](_0xb8f6('0xb0'))[_0xb8f6('0x47')]('phone\x20NOT\x20IN\x20(?)',squel[_0xb8f6('0x86')]()[_0xb8f6('0x87')](_0xb8f6('0xb1'))[_0xb8f6('0x89')]('cm_hopper_final')[_0xb8f6('0x47')](_0xb8f6('0x8e'),_0x44d034[_0xb8f6('0x52')]['id'][_0xb8f6('0xab')]()))[_0xb8f6('0x47')]('phone\x20NOT\x20IN\x20(?)',squel[_0xb8f6('0x86')]()['field']('COALESCE(phone,\x27\x27)')[_0xb8f6('0x89')](_0xb8f6('0xb2'))[_0xb8f6('0x47')](_0xb8f6('0x8e'),_0x44d034[_0xb8f6('0x52')]['id']['toString']())))[_0xb8f6('0xab')]();break;case _0xb8f6('0xb3'):_0x489313=squel[_0xb8f6('0xa4')]()[_0xb8f6('0xb4')](_0xb8f6('0xb2'))['fromQuery']([_0xb8f6('0xa6'),_0xb8f6('0xa7'),_0xb8f6('0xa8'),_0xb8f6('0xa9'),'VoiceQueueId',_0xb8f6('0x60'),_0xb8f6('0xaa')],squel['select']()[_0xb8f6('0x87')]('phone',_0xb8f6('0xa6'))[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27',_0xb8f6('0xa7'))[_0xb8f6('0x87')]('id',_0xb8f6('0xa8'))[_0xb8f6('0x87')](_0x2e57da[_0xb8f6('0xaf')]['toString'](),_0xb8f6('0xa9'))[_0xb8f6('0x87')](_0x44d034[_0xb8f6('0x52')]['id']['toString'](),'VoiceQueueId')[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27',_0xb8f6('0x60'))[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27','updatedAt')['from'](_0xb8f6('0xac'))[_0xb8f6('0x47')](_0xb8f6('0xad'))[_0xb8f6('0x47')]('ListId\x20=\x20?',_0x2e57da[_0xb8f6('0xaf')]['toString']())[_0xb8f6('0x47')]('phone\x20IS\x20NOT\x20NULL')['where']('phone\x20NOT\x20IN\x20(?)',squel[_0xb8f6('0x86')]()['field'](_0xb8f6('0xb5'))['from'](_0xb8f6('0xb2'))[_0xb8f6('0x47')](_0xb8f6('0x8e'),_0x44d034[_0xb8f6('0x52')]['id'][_0xb8f6('0xab')]())))[_0xb8f6('0xab')]();break;default:_0x489313=squel[_0xb8f6('0xa4')]()[_0xb8f6('0xb4')]('cm_hopper')['fromQuery'](['phone',_0xb8f6('0xa7'),_0xb8f6('0xa8'),'ListId',_0xb8f6('0x66'),_0xb8f6('0x60'),_0xb8f6('0xaa')],squel['select']()[_0xb8f6('0x87')](_0xb8f6('0xa6'),_0xb8f6('0xa6'))[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27','scheduledAt')[_0xb8f6('0x87')]('id',_0xb8f6('0xa8'))[_0xb8f6('0x87')](_0x2e57da[_0xb8f6('0xaf')][_0xb8f6('0xab')](),_0xb8f6('0xa9'))[_0xb8f6('0x87')](_0x44d034['params']['id'][_0xb8f6('0xab')](),'VoiceQueueId')[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27',_0xb8f6('0x60'))['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0xaa'))['from'](_0xb8f6('0xac'))[_0xb8f6('0x47')](_0xb8f6('0xad'))[_0xb8f6('0x47')]('ListId\x20=\x20?',_0x2e57da['CmListId'][_0xb8f6('0xab')]())['where'](_0xb8f6('0xb0')))[_0xb8f6('0xab')]();}_0x33ca2a[_0xb8f6('0x9a')](db[_0xb8f6('0x76')][_0xb8f6('0x3d')](_0x489313));}return BPromise['all'](_0x33ca2a);}})[_0xb8f6('0x2a')](function(){var _0x3a1dcc=[];var _0x41c30a=squel['insert']()['into']('cm_hopper_additional_phones')[_0xb8f6('0xa5')]([_0xb8f6('0xb6'),_0xb8f6('0xa6'),_0xb8f6('0xb7'),'createdAt',_0xb8f6('0xaa')],squel['select']()['field'](_0xb8f6('0xb8'))[_0xb8f6('0x87')](_0xb8f6('0xb9'))[_0xb8f6('0x87')]('ci.OrderBy+1')[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27',_0xb8f6('0x60'))['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0xaa'))['from'](_0xb8f6('0xba'),'ci')[_0xb8f6('0x8b')]('cm_hopper','h',_0xb8f6('0xbb'))[_0xb8f6('0x47')](_0xb8f6('0xbc'),_0x20f45f)[_0xb8f6('0x47')](_0xb8f6('0xbd'),_0xb8f6('0xbe')))[_0xb8f6('0xab')]();_0x3a1dcc[_0xb8f6('0x9a')](db[_0xb8f6('0x76')][_0xb8f6('0x3d')](_0x41c30a));return BPromise[_0xb8f6('0x93')](_0x3a1dcc);})[_0xb8f6('0x2a')](function(){return _0x1ebb54;})[_0xb8f6('0x2a')](respondWithResult(_0x5ba34a,null))[_0xb8f6('0x50')](handleError(_0x5ba34a,null));};exports['removeLists']=function(_0x579e0e,_0x431240,_0x245f88){return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x579e0e['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x431240,null))['then'](function(_0x2aaf49){if(_0x2aaf49){return _0x2aaf49[_0xb8f6('0xbf')](_0x579e0e[_0xb8f6('0x3d')][_0xb8f6('0x98')]);}})[_0xb8f6('0x2a')](function(_0x21c5b6){if(_0x21c5b6){return db[_0xb8f6('0x65')][_0xb8f6('0x2b')]({'where':{'ListId':_0x579e0e[_0xb8f6('0x3d')][_0xb8f6('0x98')],'VoiceQueueId':_0x579e0e['params']['id']}})[_0xb8f6('0x2a')](function(){return _0x21c5b6;});}})[_0xb8f6('0x2a')](respondWithStatusCode(_0x431240,null))['catch'](handleError(_0x431240,null));};exports[_0xb8f6('0xc0')]=function(_0x40d0f0,_0x22da7a,_0x2df9cb){var _0x50d060={};var _0x3cb302={};var _0x433956;var _0xd39fa4;return db['VoiceQueue'][_0xb8f6('0x64')]({'where':{'id':_0x40d0f0[_0xb8f6('0x52')]['id']}})['then'](handleEntityNotFound(_0x22da7a,null))[_0xb8f6('0x2a')](function(_0x239212){if(_0x239212){_0x433956=_0x239212;_0x3cb302[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x9f')][_0xb8f6('0x5e')]);_0x3cb302[_0xb8f6('0x3d')]=_[_0xb8f6('0x3c')](_0x40d0f0['query']);_0x3cb302[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x3cb302[_0xb8f6('0x3e')],_0x3cb302[_0xb8f6('0x3d')]);_0x50d060[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x3cb302[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x40d0f0[_0xb8f6('0x3d')]['fields']));_0x50d060[_0xb8f6('0x3f')]=_0x50d060[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x50d060[_0xb8f6('0x3f')]:_0x3cb302[_0xb8f6('0x3e')];_0x50d060[_0xb8f6('0x45')]=qs[_0xb8f6('0x46')](_0x40d0f0[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x50d060[_0xb8f6('0x47')]=qs['filters'](_[_0xb8f6('0x48')](_0x40d0f0[_0xb8f6('0x3d')],_0x3cb302[_0xb8f6('0x49')]));if(_0x40d0f0[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x50d060[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x50d060[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x50d060[_0xb8f6('0x3f')],function(_0x293261){var _0x4e41c7={};_0x4e41c7[_0x293261]={'$like':'%'+_0x40d0f0['query'][_0xb8f6('0x2f')]+'%'};return _0x4e41c7;})});}_0x50d060=_[_0xb8f6('0x4b')]({},_0x50d060,_0x40d0f0[_0xb8f6('0x4c')]);return _0x433956[_0xb8f6('0xc0')](_0x50d060);}})[_0xb8f6('0x2a')](function(_0x445fa2){if(_0x445fa2){_0xd39fa4=_0x445fa2[_0xb8f6('0x42')];if(!_0x40d0f0[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x50d060['limit']=qs[_0xb8f6('0x21')](_0x40d0f0[_0xb8f6('0x3d')]['limit']);_0x50d060[_0xb8f6('0x23')]=qs['offset'](_0x40d0f0['query'][_0xb8f6('0x23')]);}return _0x433956[_0xb8f6('0xc0')](_0x50d060);}})[_0xb8f6('0x2a')](function(_0x226d61){if(_0x226d61){return _0x226d61?{'count':_0xd39fa4,'rows':_0x226d61}:null;}})[_0xb8f6('0x2a')](respondWithResult(_0x22da7a,null))[_0xb8f6('0x50')](handleError(_0x22da7a,null));};exports[_0xb8f6('0xc1')]=function(_0x3f4148,_0x1c17d5,_0x33cee2){var _0x5cdd96,_0x15684a;return db['VoiceQueue']['find']({'where':{'id':_0x3f4148[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x1c17d5,null))['then'](function(_0x22c171){if(_0x22c171){_0x15684a=_0x22c171;return _0x22c171[_0xb8f6('0xc1')](_0x3f4148[_0xb8f6('0x54')][_0xb8f6('0x98')],_[_0xb8f6('0x5f')](_0x3f4148[_0xb8f6('0x54')],[_0xb8f6('0x98'),'id'])||{});}return null;})['spread'](function(_0xdc77d7){var _0x2a2c54;_0x5cdd96=_0xdc77d7||[];var _0x80606d=[];if(_0xdc77d7){for(var _0x40a393=0x0;_0x40a393<_0xdc77d7[_0xb8f6('0x42')];_0x40a393+=0x1){var _0x1c2a07=_0xdc77d7[_0x40a393][_0xb8f6('0x57')]({'plain':!![]});_0x2a2c54=squel['insert']()['into'](_0xb8f6('0xc2'))[_0xb8f6('0xa5')]([_0xb8f6('0xa6'),_0xb8f6('0xa8'),_0xb8f6('0xa9'),_0xb8f6('0x66'),_0xb8f6('0x60'),'updatedAt'],squel[_0xb8f6('0x86')]()[_0xb8f6('0x87')](_0xb8f6('0xa6'),'phone')['field']('id',_0xb8f6('0xa8'))[_0xb8f6('0x87')](_0x1c2a07[_0xb8f6('0xaf')][_0xb8f6('0xab')](),_0xb8f6('0xa9'))[_0xb8f6('0x87')](_0x3f4148[_0xb8f6('0x52')]['id'][_0xb8f6('0xab')](),_0xb8f6('0x66'))['field'](_0xb8f6('0xc3'),'createdAt')['field'](_0xb8f6('0xc3'),_0xb8f6('0xaa'))[_0xb8f6('0x89')](_0xb8f6('0xac'))[_0xb8f6('0x47')](_0xb8f6('0xad'))[_0xb8f6('0x47')](_0xb8f6('0xae'),_0x1c2a07[_0xb8f6('0xaf')][_0xb8f6('0xab')]())['where'](_0xb8f6('0xb0')))[_0xb8f6('0xab')]();_0x80606d[_0xb8f6('0x9a')](db[_0xb8f6('0x76')]['query'](_0x2a2c54));}return BPromise[_0xb8f6('0x93')](_0x80606d);}})[_0xb8f6('0x2a')](function(){return _0x5cdd96;})[_0xb8f6('0x2a')](respondWithResult(_0x1c17d5,null))[_0xb8f6('0x50')](handleError(_0x1c17d5,null));};exports['removeBlackLists']=function(_0x33e334,_0x3b7526,_0x1020d7){return db['VoiceQueue'][_0xb8f6('0x53')]({'where':{'id':_0x33e334[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x3b7526,null))[_0xb8f6('0x2a')](function(_0x246a2b){if(_0x246a2b){return _0x246a2b[_0xb8f6('0xc4')](_0x33e334['query'][_0xb8f6('0x98')]);}})[_0xb8f6('0x2a')](function(_0xf37127){if(_0xf37127){return db[_0xb8f6('0x6c')][_0xb8f6('0x2b')]({'where':{'ListId':_0x33e334[_0xb8f6('0x3d')][_0xb8f6('0x98')],'VoiceQueueId':_0x33e334[_0xb8f6('0x52')]['id']}})['then'](function(){return _0xf37127;});}})[_0xb8f6('0x2a')](respondWithStatusCode(_0x3b7526,null))['catch'](handleError(_0x3b7526,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff