// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x283e=['ContactId','ListId','select','NOW()','CmListId','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','cm_hopper','VoiceQueueId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','into','fromQuery','removeLists','getBlackLists','addBlackLists','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','socket.io-emitter','./voiceQueue.socket','end','offset','undefined','limit','count','status','set','Content-Range','json','reject','update','then','get','VoiceQueues','outbound','filter','ignore','map','value','includes','type','find','name','UserProfileResource','error','send','index','VoiceQueue','rawAttributes','fieldName','key','model','attributes','intersection','fields','query','length','hasOwnProperty','order','sort','where','filters','pick','merge','VIRTUAL','includeAll','include','findAll','rows','catch','show','params','keys','options','create','body','user','role','inbound','QueueCampaigns','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','createdAt','updatedAt','omit','Unable\x20to\x20retrieve\x20the\x20current\x20user','destroy','getHoppers','CmHopper','VoiceQueueId','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','nolimit','getHopperBlacks','CmHopperBlack','getTeams','Team','addTeams','teams','User','Agents','online','interface','flatMap','penalty','transaction','each','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','format','SIP/%s','forEach','emit','userVoiceQueue:save','field','tq.TeamId','from','team_has_voice_queues','join','ut.TeamId\x20=\x20tq.TeamId','push','sequelize','toString','QueryTypes','SELECT','TeamId','all','ids','removeAgents','spread','voicePause','isEmpty','isArray','userVoiceQueue:remove','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','always','insert','phone','scheduledAt'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x283e,0xcf));var _0xe283=function(_0x14add3,_0x13ce8d){_0x14add3=_0x14add3-0x0;var _0x4a174f=_0x283e[_0x14add3];return _0x4a174f;};'use strict';var emlformat=require(_0xe283('0x0'));var rimraf=require(_0xe283('0x1'));var zipdir=require(_0xe283('0x2'));var jsonpatch=require(_0xe283('0x3'));var rp=require('request-promise');var moment=require(_0xe283('0x4'));var BPromise=require(_0xe283('0x5'));var Mustache=require(_0xe283('0x6'));var util=require(_0xe283('0x7'));var path=require(_0xe283('0x8'));var sox=require(_0xe283('0x9'));var csv=require(_0xe283('0xa'));var ejs=require(_0xe283('0xb'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xe283('0xc'));var squel=require(_0xe283('0xd'));var crypto=require(_0xe283('0xe'));var jsforce=require(_0xe283('0xf'));var deskjs=require(_0xe283('0x10'));var toCsv=require('to-csv');var querystring=require(_0xe283('0x11'));var Papa=require('papaparse');var Redis=require(_0xe283('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xe283('0x13'));var as=require(_0xe283('0x14'));var hardwareService=require(_0xe283('0x15'));var logger=require(_0xe283('0x16'))(_0xe283('0x17'));var utils=require(_0xe283('0x18'));var config=require(_0xe283('0x19'));var licenseUtil=require(_0xe283('0x1a'));var db=require(_0xe283('0x1b'))['db'];config[_0xe283('0x1c')]=_[_0xe283('0x1d')](config[_0xe283('0x1c')],{'host':'localhost','port':0x18eb});var socket=require(_0xe283('0x1e'))(new Redis(config[_0xe283('0x1c')]));require(_0xe283('0x1f'))['register'](socket);function respondWithStatusCode(_0x24fbb4,_0x52a75f){_0x52a75f=_0x52a75f||0xcc;return function(_0x1380c6){if(_0x1380c6){return _0x24fbb4['sendStatus'](_0x52a75f);}return _0x24fbb4['status'](_0x52a75f)[_0xe283('0x20')]();};}function respondWithResult(_0x110281,_0x26dae6){_0x26dae6=_0x26dae6||0xc8;return function(_0x94da57){if(_0x94da57){return _0x110281['status'](_0x26dae6)['json'](_0x94da57);}};}function respondWithFilteredResult(_0x48b601,_0x44a903){return function(_0x2091d0){if(_0x2091d0){var _0x1307f4=typeof _0x44a903[_0xe283('0x21')]===_0xe283('0x22')&&typeof _0x44a903[_0xe283('0x23')]===_0xe283('0x22');var _0xeff2b5=_0x2091d0['count'];var _0x152409=_0x1307f4?0x0:_0x44a903[_0xe283('0x21')];var _0x34e7ae=_0x1307f4?_0x2091d0[_0xe283('0x24')]:_0x44a903[_0xe283('0x21')]+_0x44a903[_0xe283('0x23')];var _0x9bdd67;if(_0x34e7ae>=_0xeff2b5){_0x34e7ae=_0xeff2b5;_0x9bdd67=0xc8;}else{_0x9bdd67=0xce;}_0x48b601[_0xe283('0x25')](_0x9bdd67);return _0x48b601[_0xe283('0x26')](_0xe283('0x27'),_0x152409+'-'+_0x34e7ae+'/'+_0xeff2b5)[_0xe283('0x28')](_0x2091d0);}return null;};}function patchUpdates(_0x1bc7b9){return function(_0x19919b){try{jsonpatch['apply'](_0x19919b,_0x1bc7b9,!![]);}catch(_0x2852ca){return BPromise[_0xe283('0x29')](_0x2852ca);}return _0x19919b['save']();};}function saveUpdates(_0x206eb9,_0xfc70d6){return function(_0x56426c){if(_0x56426c){return _0x56426c[_0xe283('0x2a')](_0x206eb9)[_0xe283('0x2b')](function(_0x4c1f44){return _0x4c1f44;});}return null;};}function removeEntity(_0x21601f,_0x20aa85){return function(_0x21f72d){if(_0x21f72d){return _0x21f72d['destroy']()[_0xe283('0x2b')](function(){var _0x52e0aa=_0x21f72d[_0xe283('0x2c')]({'plain':!![]});var _0x2466df=[{'name':_0xe283('0x2d'),'value':'inbound','ignore':![]},{'name':'QueueCampaigns','value':_0xe283('0x2e'),'ignore':![]}];var _0x40d403=_(_0x2466df)[_0xe283('0x2f')](_0xe283('0x30'))[_0xe283('0x31')](_0xe283('0x32'))[_0xe283('0x32')]();if(_[_0xe283('0x33')](_0x40d403,_0x52e0aa[_0xe283('0x34')])){return;}var _0x20a7fe=_[_0xe283('0x35')](_0x2466df,[_0xe283('0x32'),_0x52e0aa[_0xe283('0x34')]])[_0xe283('0x36')];return db[_0xe283('0x37')]['destroy']({'where':{'type':_0x20a7fe,'resourceId':_0x52e0aa['id']}})[_0xe283('0x2b')](function(){return _0x21f72d;});})['then'](function(){_0x21601f[_0xe283('0x25')](0xcc)['end']();});}};}function handleEntityNotFound(_0x21be24,_0x583214){return function(_0x3db7ec){if(!_0x3db7ec){_0x21be24['sendStatus'](0x194);}return _0x3db7ec;};}function handleError(_0x17de79,_0x2d176c){_0x2d176c=_0x2d176c||0x1f4;return function(_0x54b230){logger[_0xe283('0x38')](_0x54b230['stack']);if(_0x54b230[_0xe283('0x36')]){delete _0x54b230[_0xe283('0x36')];}_0x17de79[_0xe283('0x25')](_0x2d176c)[_0xe283('0x39')](_0x54b230);};}exports[_0xe283('0x3a')]=function(_0x49195b,_0x4078f3){var _0x278f3b={},_0x409fc6={},_0x4ece7d={'count':0x0,'rows':[]};var _0x2ece06=_[_0xe283('0x31')](db[_0xe283('0x3b')][_0xe283('0x3c')],function(_0x13526e){return{'name':_0x13526e[_0xe283('0x3d')],'type':_0x13526e[_0xe283('0x34')][_0xe283('0x3e')]};});_0x409fc6[_0xe283('0x3f')]=_[_0xe283('0x31')](_0x2ece06,_0xe283('0x36'));_0x409fc6['query']=_['keys'](_0x49195b['query']);_0x409fc6['filters']=_['intersection'](_0x409fc6[_0xe283('0x3f')],_0x409fc6['query']);_0x278f3b[_0xe283('0x40')]=_[_0xe283('0x41')](_0x409fc6[_0xe283('0x3f')],qs[_0xe283('0x42')](_0x49195b[_0xe283('0x43')][_0xe283('0x42')]));_0x278f3b['attributes']=_0x278f3b[_0xe283('0x40')][_0xe283('0x44')]?_0x278f3b[_0xe283('0x40')]:_0x409fc6[_0xe283('0x3f')];if(!_0x49195b[_0xe283('0x43')][_0xe283('0x45')]('nolimit')){_0x278f3b[_0xe283('0x23')]=qs[_0xe283('0x23')](_0x49195b[_0xe283('0x43')][_0xe283('0x23')]);_0x278f3b[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x49195b[_0xe283('0x43')][_0xe283('0x21')]);}_0x278f3b[_0xe283('0x46')]=qs[_0xe283('0x47')](_0x49195b['query']['sort']);_0x278f3b[_0xe283('0x48')]=qs[_0xe283('0x49')](_[_0xe283('0x4a')](_0x49195b[_0xe283('0x43')],_0x409fc6[_0xe283('0x49')]),_0x2ece06);if(_0x49195b['query']['filter']){_0x278f3b[_0xe283('0x48')]=_[_0xe283('0x4b')](_0x278f3b[_0xe283('0x48')],{'$or':_[_0xe283('0x31')](_0x2ece06,function(_0x13245a){if(_0x13245a[_0xe283('0x34')]!==_0xe283('0x4c')){var _0x43ca13={};_0x43ca13[_0x13245a['name']]={'$like':'%'+_0x49195b['query'][_0xe283('0x2f')]+'%'};return _0x43ca13;}})});}_0x278f3b=_['merge']({},_0x278f3b,_0x49195b['options']);var _0x56c041={'where':_0x278f3b[_0xe283('0x48')]};return db[_0xe283('0x3b')]['count'](_0x56c041)[_0xe283('0x2b')](function(_0x58d585){_0x4ece7d['count']=_0x58d585;if(_0x49195b[_0xe283('0x43')][_0xe283('0x4d')]){_0x278f3b[_0xe283('0x4e')]=[{'all':!![]}];}return db[_0xe283('0x3b')][_0xe283('0x4f')](_0x278f3b);})[_0xe283('0x2b')](function(_0x4c7072){_0x4ece7d[_0xe283('0x50')]=_0x4c7072;return _0x4ece7d;})[_0xe283('0x2b')](respondWithFilteredResult(_0x4078f3,_0x278f3b))[_0xe283('0x51')](handleError(_0x4078f3,null));};exports[_0xe283('0x52')]=function(_0x3defb5,_0x2a69ad){var _0x5b6523={'raw':![],'where':{'id':_0x3defb5[_0xe283('0x53')]['id']}},_0x6cffc7={};_0x6cffc7[_0xe283('0x3f')]=_[_0xe283('0x54')](db['VoiceQueue']['rawAttributes']);_0x6cffc7[_0xe283('0x43')]=_[_0xe283('0x54')](_0x3defb5[_0xe283('0x43')]);_0x6cffc7[_0xe283('0x49')]=_['intersection'](_0x6cffc7[_0xe283('0x3f')],_0x6cffc7[_0xe283('0x43')]);_0x5b6523[_0xe283('0x40')]=_[_0xe283('0x41')](_0x6cffc7[_0xe283('0x3f')],qs[_0xe283('0x42')](_0x3defb5[_0xe283('0x43')]['fields']));_0x5b6523[_0xe283('0x40')]=_0x5b6523[_0xe283('0x40')][_0xe283('0x44')]?_0x5b6523[_0xe283('0x40')]:_0x6cffc7[_0xe283('0x3f')];if(_0x3defb5[_0xe283('0x43')][_0xe283('0x4d')]){_0x5b6523[_0xe283('0x4e')]=[{'all':!![]}];}_0x5b6523=_[_0xe283('0x4b')]({},_0x5b6523,_0x3defb5[_0xe283('0x55')]);return db[_0xe283('0x3b')][_0xe283('0x35')](_0x5b6523)[_0xe283('0x2b')](handleEntityNotFound(_0x2a69ad,null))[_0xe283('0x2b')](respondWithResult(_0x2a69ad,null))[_0xe283('0x51')](handleError(_0x2a69ad,null));};exports[_0xe283('0x56')]=function(_0x3d73ce,_0x4bb212){return db[_0xe283('0x3b')][_0xe283('0x56')](_0x3d73ce[_0xe283('0x57')],{})[_0xe283('0x2b')](function(_0x656bab){var _0x43f459=_0x3d73ce[_0xe283('0x58')]['get']({'plain':!![]});if(!_0x43f459)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x43f459[_0xe283('0x59')]===_0xe283('0x58')){var _0x358e80=_0x656bab[_0xe283('0x2c')]({'plain':!![]});var _0x1dd0cc=[{'name':_0xe283('0x2d'),'value':_0xe283('0x5a')},{'name':_0xe283('0x5b'),'value':_0xe283('0x2e')}];var _0x3bd008=_[_0xe283('0x35')](_0x1dd0cc,[_0xe283('0x32'),_0x358e80[_0xe283('0x34')]])[_0xe283('0x36')];return db[_0xe283('0x5c')]['find']({'where':{'name':_0x3bd008,'userProfileId':_0x43f459[_0xe283('0x5d')]},'raw':!![]})[_0xe283('0x2b')](function(_0x5f4669){if(_0x5f4669&&_0x5f4669[_0xe283('0x5e')]===0x0){return db[_0xe283('0x37')][_0xe283('0x56')]({'name':_0x358e80[_0xe283('0x36')],'resourceId':_0x358e80['id'],'type':_0x5f4669['name'],'sectionId':_0x5f4669['id']},{})[_0xe283('0x2b')](function(){return _0x656bab;});}else{return _0x656bab;}})[_0xe283('0x51')](function(_0x309be7){logger[_0xe283('0x38')](_0xe283('0x5f'),_0x309be7);throw _0x309be7;});}return _0x656bab;})['then'](respondWithResult(_0x4bb212,0xc9))['catch'](handleError(_0x4bb212,null));};exports[_0xe283('0x60')]=function(_0x22fa32,_0x5e5b37){var _0x3499c0={'where':{'id':_0x22fa32['params']['id']}},_0x1eb147={};_0x1eb147[_0xe283('0x3f')]=_[_0xe283('0x54')](db[_0xe283('0x3b')][_0xe283('0x3c')]);_0x3499c0[_0xe283('0x40')]=_['intersection'](_0x1eb147['model'],qs[_0xe283('0x42')](_0x22fa32[_0xe283('0x43')][_0xe283('0x42')]));_0x3499c0['attributes']=_0x3499c0[_0xe283('0x40')][_0xe283('0x44')]?_0x3499c0[_0xe283('0x40')]:_0x1eb147[_0xe283('0x3f')];if(_0x22fa32[_0xe283('0x43')]['includeAll']){_0x3499c0[_0xe283('0x4e')]=[{'all':!![]}];}_0x3499c0=_[_0xe283('0x4b')]({},_0x3499c0,_0x22fa32[_0xe283('0x55')]);return db[_0xe283('0x3b')]['find'](_0x3499c0)[_0xe283('0x2b')](handleEntityNotFound(_0x5e5b37,null))[_0xe283('0x2b')](function(_0x3202d2){if(_0x3202d2){var _0x237bfa=_0x3202d2['get']({'plain':!![]});_0x237bfa=qs['omit'](_0x237bfa,['id',_0xe283('0x61'),_0xe283('0x62')]);_0x22fa32[_0xe283('0x57')]=_[_0xe283('0x63')](_0x22fa32[_0xe283('0x57')],['id',_0xe283('0x61'),_0xe283('0x62')]);return db[_0xe283('0x3b')]['create'](_[_0xe283('0x4b')](_0x237bfa,_0x22fa32['body']),{'include':_0x22fa32[_0xe283('0x43')][_0xe283('0x4d')]?[{'all':!![]}]:undefined})[_0xe283('0x2b')](function(_0x2a383e){var _0x330a43=_0x22fa32[_0xe283('0x58')]['get']({'plain':!![]});if(!_0x330a43)throw new Error(_0xe283('0x64'));if(_0x330a43[_0xe283('0x59')]===_0xe283('0x58')){var _0x1df666=_0x2a383e[_0xe283('0x2c')]({'plain':!![]});var _0x5baa52=[{'name':_0xe283('0x2d'),'value':_0xe283('0x5a')},{'name':_0xe283('0x5b'),'value':_0xe283('0x2e')}];var _0x215fd0=_[_0xe283('0x35')](_0x5baa52,['value',_0x1df666[_0xe283('0x34')]])[_0xe283('0x36')];return db[_0xe283('0x5c')][_0xe283('0x35')]({'where':{'name':_0x215fd0,'userProfileId':_0x330a43[_0xe283('0x5d')]},'raw':!![]})[_0xe283('0x2b')](function(_0x43fcbb){if(_0x43fcbb&&_0x43fcbb[_0xe283('0x5e')]===0x0){return db[_0xe283('0x37')][_0xe283('0x56')]({'name':_0x1df666['name'],'resourceId':_0x1df666['id'],'type':_0x43fcbb[_0xe283('0x36')],'sectionId':_0x43fcbb['id']},{})[_0xe283('0x2b')](function(){return _0x2a383e;});}else{return _0x2a383e;}})[_0xe283('0x51')](function(_0x98ae77){logger['error'](_0xe283('0x5f'),_0x98ae77);throw _0x98ae77;});}return _0x2a383e;});}})['then'](respondWithResult(_0x5e5b37,0xc9))[_0xe283('0x51')](handleError(_0x5e5b37,null));};exports[_0xe283('0x2a')]=function(_0xbdaf7d,_0x50bc4f){if(_0xbdaf7d[_0xe283('0x57')]['id']){delete _0xbdaf7d['body']['id'];}return db['VoiceQueue']['find']({'where':{'id':_0xbdaf7d['params']['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x50bc4f,null))[_0xe283('0x2b')](saveUpdates(_0xbdaf7d['body'],null))[_0xe283('0x2b')](respondWithResult(_0x50bc4f,null))['catch'](handleError(_0x50bc4f,null));};exports[_0xe283('0x65')]=function(_0x43d9ad,_0x28eaf8){return db[_0xe283('0x3b')][_0xe283('0x35')]({'where':{'id':_0x43d9ad['params']['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x28eaf8,null))[_0xe283('0x2b')](removeEntity(_0x28eaf8,null))[_0xe283('0x51')](handleError(_0x28eaf8,null));};exports[_0xe283('0x66')]=function(_0x2b13b3,_0x1d0137,_0x509ce4){var _0x58635c={'raw':![],'where':{}};var _0x39959c={};var _0x104833={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x2b13b3[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x1d0137,null))[_0xe283('0x2b')](function(_0x258eb5){if(_0x258eb5){_0x39959c[_0xe283('0x3f')]=_[_0xe283('0x54')](db[_0xe283('0x67')][_0xe283('0x3c')]);_0x39959c['query']=_[_0xe283('0x54')](_0x2b13b3['query']);_0x39959c['filters']=_[_0xe283('0x41')](_0x39959c[_0xe283('0x3f')],_0x39959c[_0xe283('0x43')]);_0x58635c['attributes']=_['intersection'](_0x39959c[_0xe283('0x3f')],qs['fields'](_0x2b13b3[_0xe283('0x43')][_0xe283('0x42')]));_0x58635c['attributes']=_0x58635c['attributes'][_0xe283('0x44')]?_0x58635c[_0xe283('0x40')]:_0x39959c[_0xe283('0x3f')];if(!_0x2b13b3['query'][_0xe283('0x45')]('nolimit')){_0x58635c[_0xe283('0x23')]=qs['limit'](_0x2b13b3[_0xe283('0x43')][_0xe283('0x23')]);_0x58635c[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x2b13b3[_0xe283('0x43')][_0xe283('0x21')]);}_0x58635c[_0xe283('0x46')]=qs[_0xe283('0x47')](_0x2b13b3['query']['sort']);_0x58635c[_0xe283('0x48')]=qs[_0xe283('0x49')](_[_0xe283('0x4a')](_0x2b13b3['query'],_0x39959c['filters']));_0x58635c[_0xe283('0x48')][_0xe283('0x68')]=_0x258eb5['id'];if(_0x2b13b3[_0xe283('0x43')][_0xe283('0x2f')]){_0x58635c['where']=_['merge'](_0x58635c['where'],{'$or':_[_0xe283('0x31')](_0x58635c[_0xe283('0x40')],function(_0x13f662){var _0x34a327={};_0x34a327[_0x13f662]={'$like':'%'+_0x2b13b3['query'][_0xe283('0x2f')]+'%'};return _0x34a327;})});}_0x58635c=_['merge']({},_0x58635c,_0x2b13b3[_0xe283('0x55')]);return db['CmHopper'][_0xe283('0x24')]({'where':_0x58635c[_0xe283('0x48')]})[_0xe283('0x2b')](function(_0x3cd41c){_0x104833[_0xe283('0x24')]=_0x3cd41c;if(_0x2b13b3[_0xe283('0x43')][_0xe283('0x4d')]){_0x58635c[_0xe283('0x4e')]=[{'all':!![]}];}return db['CmHopper'][_0xe283('0x4f')](_0x58635c);})[_0xe283('0x2b')](function(_0xaa4c32){_0x104833[_0xe283('0x50')]=_0xaa4c32;return _0x104833;});}})[_0xe283('0x2b')](respondWithFilteredResult(_0x1d0137,_0x58635c))[_0xe283('0x51')](handleError(_0x1d0137,null));};exports[_0xe283('0x69')]=function(_0x2fc21b,_0x494fa9,_0x4d816b){var _0xcb5014={'raw':!![],'where':{}};var _0x5c0550={};var _0x39a2c9={'count':0x0,'rows':[]};return db[_0xe283('0x3b')][_0xe283('0x6a')]({'where':{'id':_0x2fc21b[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x494fa9,null))['then'](function(_0x2b8a92){if(_0x2b8a92){_0x5c0550[_0xe283('0x3f')]=_['keys'](db[_0xe283('0x6b')][_0xe283('0x3c')]);_0x5c0550['query']=_[_0xe283('0x54')](_0x2fc21b[_0xe283('0x43')]);_0x5c0550[_0xe283('0x49')]=_[_0xe283('0x41')](_0x5c0550[_0xe283('0x3f')],_0x5c0550[_0xe283('0x43')]);_0xcb5014['attributes']=_[_0xe283('0x41')](_0x5c0550[_0xe283('0x3f')],qs[_0xe283('0x42')](_0x2fc21b[_0xe283('0x43')][_0xe283('0x42')]));_0xcb5014['attributes']=_0xcb5014[_0xe283('0x40')][_0xe283('0x44')]?_0xcb5014[_0xe283('0x40')]:_0x5c0550[_0xe283('0x3f')];if(!_0x2fc21b[_0xe283('0x43')][_0xe283('0x45')]('nolimit')){_0xcb5014['limit']=qs[_0xe283('0x23')](_0x2fc21b[_0xe283('0x43')][_0xe283('0x23')]);_0xcb5014[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x2fc21b['query'][_0xe283('0x21')]);}_0xcb5014[_0xe283('0x46')]=qs[_0xe283('0x47')](_0x2fc21b['query']['sort']);_0xcb5014[_0xe283('0x48')]=qs[_0xe283('0x49')](_[_0xe283('0x4a')](_0x2fc21b['query'],_0x5c0550[_0xe283('0x49')]));_0xcb5014[_0xe283('0x48')]['VoiceQueueId']=_0x2b8a92['id'];if(_0x2fc21b[_0xe283('0x43')][_0xe283('0x2f')]){_0xcb5014['where']=_[_0xe283('0x4b')](_0xcb5014[_0xe283('0x48')],{'$or':_[_0xe283('0x31')](_0xcb5014['attributes'],function(_0x20ded7){var _0x4c6432={};_0x4c6432[_0x20ded7]={'$like':'%'+_0x2fc21b[_0xe283('0x43')][_0xe283('0x2f')]+'%'};return _0x4c6432;})});}_0xcb5014=_[_0xe283('0x4b')]({},_0xcb5014,_0x2fc21b[_0xe283('0x55')]);return db[_0xe283('0x6b')][_0xe283('0x24')]({'where':_0xcb5014[_0xe283('0x48')]})[_0xe283('0x2b')](function(_0x17d461){_0x39a2c9['count']=_0x17d461;if(_0x2fc21b[_0xe283('0x43')]['includeAll']){_0xcb5014[_0xe283('0x4e')]=[{'all':!![]}];}return db[_0xe283('0x6b')]['findAll'](_0xcb5014);})[_0xe283('0x2b')](function(_0x17fd58){_0x39a2c9[_0xe283('0x50')]=_0x17fd58;return _0x39a2c9;});}})[_0xe283('0x2b')](respondWithFilteredResult(_0x494fa9,_0xcb5014))[_0xe283('0x51')](handleError(_0x494fa9,null));};exports[_0xe283('0x6c')]=function(_0x1edb83,_0x29a133,_0x2cf55e){var _0x398a49={'raw':!![],'where':{}};var _0x26c1ed={};var _0x588781={'count':0x0,'rows':[]};return db[_0xe283('0x3b')][_0xe283('0x6a')]({'where':{'id':_0x1edb83[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x29a133,null))[_0xe283('0x2b')](function(_0x177eae){if(_0x177eae){_0x26c1ed[_0xe283('0x3f')]=_[_0xe283('0x54')](db[_0xe283('0x6d')][_0xe283('0x3c')]);_0x26c1ed[_0xe283('0x43')]=_[_0xe283('0x54')](_0x1edb83['query']);_0x26c1ed['filters']=_[_0xe283('0x41')](_0x26c1ed[_0xe283('0x3f')],_0x26c1ed['query']);_0x398a49['attributes']=_[_0xe283('0x41')](_0x26c1ed[_0xe283('0x3f')],qs[_0xe283('0x42')](_0x1edb83[_0xe283('0x43')][_0xe283('0x42')]));_0x398a49[_0xe283('0x40')]=_0x398a49[_0xe283('0x40')]['length']?_0x398a49[_0xe283('0x40')]:_0x26c1ed['model'];if(!_0x1edb83[_0xe283('0x43')][_0xe283('0x45')](_0xe283('0x6e'))){_0x398a49[_0xe283('0x23')]=qs[_0xe283('0x23')](_0x1edb83[_0xe283('0x43')][_0xe283('0x23')]);_0x398a49[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x1edb83[_0xe283('0x43')][_0xe283('0x21')]);}_0x398a49['order']=qs[_0xe283('0x47')](_0x1edb83[_0xe283('0x43')]['sort']);_0x398a49[_0xe283('0x48')]=qs['filters'](_['pick'](_0x1edb83[_0xe283('0x43')],_0x26c1ed[_0xe283('0x49')]));_0x398a49[_0xe283('0x48')][_0xe283('0x68')]=_0x177eae['id'];if(_0x1edb83[_0xe283('0x43')][_0xe283('0x2f')]){_0x398a49[_0xe283('0x48')]=_[_0xe283('0x4b')](_0x398a49[_0xe283('0x48')],{'$or':_[_0xe283('0x31')](_0x398a49[_0xe283('0x40')],function(_0x291c46){var _0x4d4880={};_0x4d4880[_0x291c46]={'$like':'%'+_0x1edb83[_0xe283('0x43')][_0xe283('0x2f')]+'%'};return _0x4d4880;})});}_0x398a49=_[_0xe283('0x4b')]({},_0x398a49,_0x1edb83['options']);return db[_0xe283('0x6d')][_0xe283('0x24')]({'where':_0x398a49['where']})[_0xe283('0x2b')](function(_0x3a18a6){_0x588781[_0xe283('0x24')]=_0x3a18a6;if(_0x1edb83[_0xe283('0x43')][_0xe283('0x4d')]){_0x398a49[_0xe283('0x4e')]=[{'all':!![]}];}return db[_0xe283('0x6d')][_0xe283('0x4f')](_0x398a49);})['then'](function(_0x2e5f00){_0x588781[_0xe283('0x50')]=_0x2e5f00;return _0x588781;});}})[_0xe283('0x2b')](respondWithFilteredResult(_0x29a133,_0x398a49))[_0xe283('0x51')](handleError(_0x29a133,null));};exports[_0xe283('0x6f')]=function(_0x2902ab,_0x26f2e7,_0x189cba){var _0x1fe7cf={'raw':!![],'where':{}};var _0x4b5a3d={};var _0x412bfd={'count':0x0,'rows':[]};return db[_0xe283('0x3b')][_0xe283('0x6a')]({'where':{'id':_0x2902ab[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x26f2e7,null))['then'](function(_0x887e20){if(_0x887e20){_0x4b5a3d[_0xe283('0x3f')]=_['keys'](db['CmHopperBlack'][_0xe283('0x3c')]);_0x4b5a3d[_0xe283('0x43')]=_[_0xe283('0x54')](_0x2902ab['query']);_0x4b5a3d[_0xe283('0x49')]=_['intersection'](_0x4b5a3d['model'],_0x4b5a3d['query']);_0x1fe7cf[_0xe283('0x40')]=_[_0xe283('0x41')](_0x4b5a3d[_0xe283('0x3f')],qs[_0xe283('0x42')](_0x2902ab[_0xe283('0x43')][_0xe283('0x42')]));_0x1fe7cf[_0xe283('0x40')]=_0x1fe7cf[_0xe283('0x40')]['length']?_0x1fe7cf[_0xe283('0x40')]:_0x4b5a3d[_0xe283('0x3f')];if(!_0x2902ab[_0xe283('0x43')][_0xe283('0x45')]('nolimit')){_0x1fe7cf['limit']=qs['limit'](_0x2902ab['query'][_0xe283('0x23')]);_0x1fe7cf[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x2902ab[_0xe283('0x43')][_0xe283('0x21')]);}_0x1fe7cf[_0xe283('0x46')]=qs[_0xe283('0x47')](_0x2902ab[_0xe283('0x43')]['sort']);_0x1fe7cf['where']=qs[_0xe283('0x49')](_[_0xe283('0x4a')](_0x2902ab[_0xe283('0x43')],_0x4b5a3d[_0xe283('0x49')]));_0x1fe7cf[_0xe283('0x48')][_0xe283('0x68')]=_0x887e20['id'];if(_0x2902ab[_0xe283('0x43')][_0xe283('0x2f')]){_0x1fe7cf[_0xe283('0x48')]=_[_0xe283('0x4b')](_0x1fe7cf['where'],{'$or':_[_0xe283('0x31')](_0x1fe7cf['attributes'],function(_0x1ed9ed){var _0x50a778={};_0x50a778[_0x1ed9ed]={'$like':'%'+_0x2902ab[_0xe283('0x43')][_0xe283('0x2f')]+'%'};return _0x50a778;})});}_0x1fe7cf=_[_0xe283('0x4b')]({},_0x1fe7cf,_0x2902ab[_0xe283('0x55')]);return db[_0xe283('0x70')][_0xe283('0x24')]({'where':_0x1fe7cf[_0xe283('0x48')]})[_0xe283('0x2b')](function(_0x46cc06){_0x412bfd[_0xe283('0x24')]=_0x46cc06;if(_0x2902ab[_0xe283('0x43')][_0xe283('0x4d')]){_0x1fe7cf[_0xe283('0x4e')]=[{'all':!![]}];}return db[_0xe283('0x70')][_0xe283('0x4f')](_0x1fe7cf);})[_0xe283('0x2b')](function(_0x5c7897){_0x412bfd[_0xe283('0x50')]=_0x5c7897;return _0x412bfd;});}})[_0xe283('0x2b')](respondWithFilteredResult(_0x26f2e7,_0x1fe7cf))[_0xe283('0x51')](handleError(_0x26f2e7,null));};exports[_0xe283('0x71')]=function(_0x2172a7,_0x1837be,_0x1ee2d1){var _0x72c590={};var _0x168744={};var _0x31f231;var _0x53148b;return db[_0xe283('0x3b')]['findOne']({'where':{'id':_0x2172a7[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x1837be,null))[_0xe283('0x2b')](function(_0x386ab3){if(_0x386ab3){_0x31f231=_0x386ab3;_0x168744['model']=_[_0xe283('0x54')](db[_0xe283('0x72')]['rawAttributes']);_0x168744[_0xe283('0x43')]=_[_0xe283('0x54')](_0x2172a7[_0xe283('0x43')]);_0x168744['filters']=_['intersection'](_0x168744['model'],_0x168744[_0xe283('0x43')]);_0x72c590[_0xe283('0x40')]=_[_0xe283('0x41')](_0x168744['model'],qs[_0xe283('0x42')](_0x2172a7[_0xe283('0x43')][_0xe283('0x42')]));_0x72c590[_0xe283('0x40')]=_0x72c590[_0xe283('0x40')][_0xe283('0x44')]?_0x72c590[_0xe283('0x40')]:_0x168744['model'];_0x72c590[_0xe283('0x46')]=qs[_0xe283('0x47')](_0x2172a7[_0xe283('0x43')][_0xe283('0x47')]);_0x72c590[_0xe283('0x48')]=qs[_0xe283('0x49')](_[_0xe283('0x4a')](_0x2172a7[_0xe283('0x43')],_0x168744['filters']));if(_0x2172a7[_0xe283('0x43')]['filter']){_0x72c590[_0xe283('0x48')]=_[_0xe283('0x4b')](_0x72c590[_0xe283('0x48')],{'$or':_[_0xe283('0x31')](_0x72c590[_0xe283('0x40')],function(_0x38cd8c){var _0x455d8b={};_0x455d8b[_0x38cd8c]={'$like':'%'+_0x2172a7[_0xe283('0x43')]['filter']+'%'};return _0x455d8b;})});}_0x72c590=_[_0xe283('0x4b')]({},_0x72c590,_0x2172a7['options']);return _0x31f231[_0xe283('0x71')](_0x72c590);}})[_0xe283('0x2b')](function(_0x3d5e94){if(_0x3d5e94){_0x53148b=_0x3d5e94['length'];if(!_0x2172a7[_0xe283('0x43')][_0xe283('0x45')](_0xe283('0x6e'))){_0x72c590['limit']=qs[_0xe283('0x23')](_0x2172a7['query'][_0xe283('0x23')]);_0x72c590[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x2172a7[_0xe283('0x43')][_0xe283('0x21')]);}return _0x31f231[_0xe283('0x71')](_0x72c590);}})['then'](function(_0x57cf2d){if(_0x57cf2d){return _0x57cf2d?{'count':_0x53148b,'rows':_0x57cf2d}:null;}})['then'](respondWithResult(_0x1837be,null))[_0xe283('0x51')](handleError(_0x1837be,null));};exports[_0xe283('0x73')]=function(_0x56bd7d,_0x5e972f,_0x53ecf5){var _0x58d547=_0x56bd7d[_0xe283('0x57')][_0xe283('0x74')];var _0xeab17f=_[_0xe283('0x31')](_0x58d547,'id');return db[_0xe283('0x72')][_0xe283('0x4f')]({'where':{'id':_0xeab17f},'attributes':['id'],'include':[{'model':db[_0xe283('0x75')],'as':_0xe283('0x76'),'attributes':['id','name',_0xe283('0x77'),'voicePause',_0xe283('0x78')],'raw':!![]}]})[_0xe283('0x2b')](function(_0x2d2dcd){if(_0x2d2dcd){var _0x56b0bb=_[_0xe283('0x79')](_0x2d2dcd,function(_0x4cd739){var _0x2e5faa=_0x4cd739[_0xe283('0x2c')]({'plain':!![]});_0x2e5faa[_0xe283('0x76')]['forEach'](function(_0x3ca4c5){_0x3ca4c5[_0xe283('0x7a')]=_[_0xe283('0x35')](_0x58d547,{'id':_0x2e5faa['id']})[_0xe283('0x7a')];});return _0x2e5faa['Agents'];});return db[_0xe283('0x3b')][_0xe283('0x35')]({'where':{'id':_0x56bd7d[_0xe283('0x53')]['id']}})['then'](function(_0x205a1b){return db['sequelize'][_0xe283('0x7b')](function(_0x1db23c){return _0x205a1b[_0xe283('0x73')](_0xeab17f,{'transaction':_0x1db23c})['then'](function(){return BPromise[_0xe283('0x7c')](_0x58d547,function(_0x48ff0d){return db['TeamVoiceQueue'][_0xe283('0x7d')]({'TeamId':_0x48ff0d['id'],'VoiceQueueId':_0x56bd7d['params']['id'],'penalty':_0x48ff0d[_0xe283('0x7a')]},{'transaction':_0x1db23c});});})[_0xe283('0x2b')](function(){return BPromise[_0xe283('0x7c')](_0x56b0bb,function(_0x42f254){return db[_0xe283('0x7e')][_0xe283('0x7f')]({'where':{'UserId':_0x42f254['id'],'VoiceQueueId':_0x56bd7d['params']['id']},'defaults':{'penalty':_0x42f254[_0xe283('0x7a')]},'transaction':_0x1db23c});});})['then'](function(){return BPromise[_0xe283('0x7c')](_['filter'](_0x56b0bb,{'online':!![]}),function(_0x48973b){return db[_0xe283('0x80')][_0xe283('0x7d')]({'membername':_0x48973b[_0xe283('0x36')],'UserId':_0x48973b['id'],'queue_name':_0x205a1b[_0xe283('0x36')],'VoiceQueueId':_0x205a1b['id'],'interface':_[_0xe283('0x81')](_0x48973b[_0xe283('0x78')])?util[_0xe283('0x82')](_0xe283('0x83'),_0x48973b[_0xe283('0x36')]):_0x48973b[_0xe283('0x78')],'paused':_0x48973b['voicePause']||![],'penalty':_0x48973b[_0xe283('0x7a')]},{'transaction':_0x1db23c});});})[_0xe283('0x2b')](function(){_0x56b0bb[_0xe283('0x84')](function(_0x32b33a){socket[_0xe283('0x85')](_0xe283('0x86'),{'UserId':_0x32b33a['id'],'VoiceQueueId':_0x205a1b['id']});});});});});}})['then'](respondWithStatusCode(_0x5e972f,null))[_0xe283('0x51')](handleError(_0x5e972f,null));};exports['removeTeams']=function(_0x4dc3ec,_0x36d758,_0x3c3d3a){return db[_0xe283('0x72')]['findAll']({'where':{'id':_0x4dc3ec[_0xe283('0x43')]['ids']},'attributes':['id'],'include':[{'model':db[_0xe283('0x75')],'as':_0xe283('0x76'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x36d758,null))[_0xe283('0x2b')](function(_0x53c4e0){var _0x51cc65=_[_0xe283('0x31')](_0x53c4e0,'id');var _0x96a44d=[];var _0x466212=[];var _0x55aada=squel['select']();_0x55aada[_0xe283('0x87')](_0xe283('0x88'))[_0xe283('0x89')](_0xe283('0x8a'),'tq')[_0xe283('0x8b')]('user_has_teams','ut',_0xe283('0x8c'))[_0xe283('0x48')]('VoiceQueueId\x20=\x20?',_0x4dc3ec['params']['id']);for(var _0xe48c46=0x0;_0xe48c46<_0x53c4e0[_0xe283('0x44')];_0xe48c46+=0x1){let _0xc659b8=_0x53c4e0[_0xe48c46];for(var _0x43a7ee=0x0;_0x43a7ee<_0xc659b8[_0xe283('0x76')][_0xe283('0x44')];_0x43a7ee+=0x1){let _0x5664c8=_0xc659b8[_0xe283('0x76')][_0x43a7ee];var _0x5334bb=_0x55aada[_0xe283('0x60')]();_0x5334bb['where']('ut.UserId\x20=\x20?',_0x5664c8['id']);_0x466212[_0xe283('0x8d')](db[_0xe283('0x8e')]['query'](_0x5334bb[_0xe283('0x8f')](),{'type':db[_0xe283('0x8e')][_0xe283('0x90')][_0xe283('0x91')]})['then'](function(_0xfc540b){if(_0xfc540b['length']===0x1){return _0x5664c8['id'];}else{var _0x154d88=_['every'](_[_0xe283('0x31')](_0xfc540b,_0xe283('0x92')),function(_0x1c92c6){return _[_0xe283('0x33')](_0x51cc65,_0x1c92c6);});if(_0x154d88){return _0x5664c8['id'];}}}));}}return BPromise[_0xe283('0x93')](_0x466212)[_0xe283('0x2b')](function(_0xd07b68){_0x96a44d=_(_0x96a44d)['union'](_0xd07b68)['compact']()[_0xe283('0x32')]();return db[_0xe283('0x3b')][_0xe283('0x35')]({'where':{'id':_0x4dc3ec[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](function(_0x22ffaa){return db[_0xe283('0x8e')]['transaction'](function(_0x355d02){return _0x22ffaa['removeTeams'](_0x4dc3ec['query'][_0xe283('0x94')],{'transaction':_0x355d02})[_0xe283('0x2b')](function(){if(!_['isEmpty'](_0x96a44d)){return _0x22ffaa[_0xe283('0x95')](_0x96a44d,{'transaction':_0x355d02})['then'](function(){return db['UserVoiceQueueRt'][_0xe283('0x65')]({'where':{'VoiceQueueId':_0x4dc3ec[_0xe283('0x53')]['id'],'UserId':_0x96a44d},'transaction':_0x355d02});});}})[_0xe283('0x2b')](function(){_0x96a44d[_0xe283('0x84')](function(_0x69e685){socket[_0xe283('0x85')]('userVoiceQueue:remove',{'UserId':_0x69e685,'VoiceQueueId':_0x22ffaa['id']});});});});});});})[_0xe283('0x2b')](respondWithStatusCode(_0x36d758,null))[_0xe283('0x51')](handleError(_0x36d758,null));};exports['addAgents']=function(_0x2c08de,_0x16d27b,_0x53f68c){var _0x393b5c,_0x163f79;return db[_0xe283('0x3b')][_0xe283('0x35')]({'where':{'id':_0x2c08de['params']['id']}})['then'](handleEntityNotFound(_0x16d27b,null))['then'](function(_0x393af7){if(_0x393af7){_0x163f79=_0x393af7;return _0x393af7['addAgents'](_0x2c08de[_0xe283('0x57')][_0xe283('0x94')],_[_0xe283('0x63')](_0x2c08de[_0xe283('0x57')],[_0xe283('0x94'),'id'])||{})[_0xe283('0x96')](function(_0x2b8e98){for(var _0x196cc2=0x0;_0x196cc2<_0x2c08de[_0xe283('0x57')][_0xe283('0x94')]['length'];_0x196cc2+=0x1){socket[_0xe283('0x85')](_0xe283('0x86'),{'UserId':Number(_0x2c08de[_0xe283('0x57')][_0xe283('0x94')][_0x196cc2]),'VoiceQueueId':Number(_0x2c08de[_0xe283('0x53')]['id'])});}return _0x2b8e98;});}})[_0xe283('0x2b')](function(_0x102856){_0x393b5c=_0x102856||[];if(_0x163f79){return db[_0xe283('0x75')][_0xe283('0x4f')]({'where':{'id':_0x2c08de[_0xe283('0x57')][_0xe283('0x94')]},'attributes':['id',_0xe283('0x36'),_0xe283('0x77'),_0xe283('0x97'),_0xe283('0x78')],'raw':!![]});}})[_0xe283('0x2b')](function(_0x1eb84c){if(!_[_0xe283('0x98')](_0x1eb84c)){var _0x1ec509=[];for(var _0xcb5b1d=0x0;_0xcb5b1d<_0x1eb84c[_0xe283('0x44')];_0xcb5b1d++){if(_0x1eb84c[_0xcb5b1d][_0xe283('0x77')]){_0x1ec509[_0xe283('0x8d')](db[_0xe283('0x80')]['upsert']({'membername':_0x1eb84c[_0xcb5b1d][_0xe283('0x36')],'UserId':_0x1eb84c[_0xcb5b1d]['id'],'queue_name':_0x163f79[_0xe283('0x36')],'VoiceQueueId':_0x163f79['id'],'interface':_[_0xe283('0x81')](_0x1eb84c[_0xcb5b1d][_0xe283('0x78')])?util[_0xe283('0x82')](_0xe283('0x83'),_0x1eb84c[_0xcb5b1d][_0xe283('0x36')]):_0x1eb84c[_0xcb5b1d][_0xe283('0x78')],'paused':_0x1eb84c[_0xcb5b1d][_0xe283('0x97')]||![],'penalty':_0x2c08de[_0xe283('0x57')]['penalty']||0x0}));}}return BPromise[_0xe283('0x93')](_0x1ec509);}})[_0xe283('0x2b')](function(){return _0x393b5c;})['then'](respondWithResult(_0x16d27b,null))[_0xe283('0x51')](handleError(_0x16d27b,null));};exports['removeAgents']=function(_0xce11a4,_0x15687f,_0x193b72){return db['VoiceQueue']['find']({'where':{'id':_0xce11a4[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x15687f,null))[_0xe283('0x2b')](function(_0x233f9c){if(_0x233f9c){return _0x233f9c[_0xe283('0x95')](_0xce11a4['query'][_0xe283('0x94')])[_0xe283('0x2b')](function(){if(_[_0xe283('0x99')](_0xce11a4[_0xe283('0x43')][_0xe283('0x94')])){for(var _0xb36f21=0x0;_0xb36f21<_0xce11a4['query'][_0xe283('0x94')][_0xe283('0x44')];_0xb36f21+=0x1){socket[_0xe283('0x85')](_0xe283('0x9a'),{'UserId':Number(_0xce11a4[_0xe283('0x43')]['ids'][_0xb36f21]),'VoiceQueueId':Number(_0xce11a4[_0xe283('0x53')]['id'])});}}else{socket[_0xe283('0x85')]('userVoiceQueue:remove',{'UserId':Number(_0xce11a4[_0xe283('0x43')][_0xe283('0x94')]),'VoiceQueueId':Number(_0xce11a4[_0xe283('0x53')]['id'])});}});}})[_0xe283('0x2b')](function(_0x3e9f03){return db[_0xe283('0x80')][_0xe283('0x65')]({'where':{'VoiceQueueId':_0xce11a4[_0xe283('0x53')]['id'],'UserId':_0xce11a4[_0xe283('0x43')][_0xe283('0x94')]}})[_0xe283('0x2b')](function(){return _0x3e9f03;});})[_0xe283('0x2b')](respondWithStatusCode(_0x15687f,null))[_0xe283('0x51')](handleError(_0x15687f,null));};exports['getAgents']=function(_0x303686,_0x4ceeb9,_0x49b605){var _0xa1fdb4={};var _0x500367={};var _0x4ac3ad;var _0x1c5432;return db[_0xe283('0x3b')][_0xe283('0x6a')]({'where':{'id':_0x303686[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x4ceeb9,null))[_0xe283('0x2b')](function(_0x232222){if(_0x232222){_0x4ac3ad=_0x232222;_0x500367[_0xe283('0x3f')]=_[_0xe283('0x54')](db[_0xe283('0x75')][_0xe283('0x3c')]);_0x500367[_0xe283('0x43')]=_['keys'](_0x303686[_0xe283('0x43')]);_0x500367['filters']=_[_0xe283('0x41')](_0x500367[_0xe283('0x3f')],_0x500367[_0xe283('0x43')]);_0xa1fdb4[_0xe283('0x40')]=_[_0xe283('0x41')](_0x500367['model'],qs[_0xe283('0x42')](_0x303686[_0xe283('0x43')]['fields']));_0xa1fdb4[_0xe283('0x40')]=_0xa1fdb4[_0xe283('0x40')][_0xe283('0x44')]?_0xa1fdb4['attributes']:_0x500367['model'];_0xa1fdb4[_0xe283('0x46')]=qs[_0xe283('0x47')](_0x303686[_0xe283('0x43')]['sort']);_0xa1fdb4[_0xe283('0x48')]=qs['filters'](_['pick'](_0x303686[_0xe283('0x43')],_0x500367['filters']));if(_0x303686[_0xe283('0x43')][_0xe283('0x2f')]){_0xa1fdb4[_0xe283('0x48')]=_[_0xe283('0x4b')](_0xa1fdb4[_0xe283('0x48')],{'$or':_[_0xe283('0x31')](_0xa1fdb4[_0xe283('0x40')],function(_0x30e2d3){var _0x20d034={};_0x20d034[_0x30e2d3]={'$like':'%'+_0x303686[_0xe283('0x43')]['filter']+'%'};return _0x20d034;})});}_0xa1fdb4=_[_0xe283('0x4b')]({},_0xa1fdb4,_0x303686[_0xe283('0x55')]);return _0x4ac3ad[_0xe283('0x9b')](_0xa1fdb4);}})[_0xe283('0x2b')](function(_0x30978d){if(_0x30978d){_0x1c5432=_0x30978d['length'];if(!_0x303686[_0xe283('0x43')][_0xe283('0x45')]('nolimit')){_0xa1fdb4[_0xe283('0x23')]=qs[_0xe283('0x23')](_0x303686[_0xe283('0x43')][_0xe283('0x23')]);_0xa1fdb4[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x303686[_0xe283('0x43')][_0xe283('0x21')]);}return _0x4ac3ad[_0xe283('0x9b')](_0xa1fdb4);}})[_0xe283('0x2b')](function(_0x312418){if(_0x312418){return _0x312418?{'count':_0x1c5432,'rows':_0x312418}:null;}})[_0xe283('0x2b')](respondWithResult(_0x4ceeb9,null))[_0xe283('0x51')](handleError(_0x4ceeb9,null));};exports[_0xe283('0x9c')]=function(_0x340f55,_0x3827c0,_0x333baa){var _0x4140d7={};var _0x1a730a={};var _0x4c0195;var _0x4a303c;return db[_0xe283('0x3b')][_0xe283('0x6a')]({'where':{'id':_0x340f55[_0xe283('0x53')]['id']}})['then'](handleEntityNotFound(_0x3827c0,null))['then'](function(_0xeeccae){if(_0xeeccae){_0x4c0195=_0xeeccae;_0x1a730a['model']=_[_0xe283('0x54')](db['UserVoiceQueueRt'][_0xe283('0x3c')]);_0x1a730a[_0xe283('0x43')]=_['keys'](_0x340f55[_0xe283('0x43')]);_0x1a730a[_0xe283('0x49')]=_[_0xe283('0x41')](_0x1a730a[_0xe283('0x3f')],_0x1a730a[_0xe283('0x43')]);_0x4140d7[_0xe283('0x40')]=_[_0xe283('0x41')](_0x1a730a[_0xe283('0x3f')],qs[_0xe283('0x42')](_0x340f55[_0xe283('0x43')][_0xe283('0x42')]));_0x4140d7[_0xe283('0x40')]=_0x4140d7[_0xe283('0x40')][_0xe283('0x44')]?_0x4140d7['attributes']:_0x1a730a['model'];_0x4140d7['order']=qs[_0xe283('0x47')](_0x340f55[_0xe283('0x43')][_0xe283('0x47')]);_0x4140d7['where']=qs[_0xe283('0x49')](_[_0xe283('0x4a')](_0x340f55[_0xe283('0x43')],_0x1a730a[_0xe283('0x49')]));if(_0x340f55['query'][_0xe283('0x2f')]){_0x4140d7['where']=_[_0xe283('0x4b')](_0x4140d7[_0xe283('0x48')],{'$or':_[_0xe283('0x31')](_0x4140d7['attributes'],function(_0x17c4af){var _0x1d91cf={};_0x1d91cf[_0x17c4af]={'$like':'%'+_0x340f55['query'][_0xe283('0x2f')]+'%'};return _0x1d91cf;})});}_0x4140d7=_[_0xe283('0x4b')]({},_0x4140d7,_0x340f55[_0xe283('0x55')]);return _0x4c0195[_0xe283('0x9c')](_0x4140d7);}})[_0xe283('0x2b')](function(_0x1a606b){if(_0x1a606b){_0x4a303c=_0x1a606b[_0xe283('0x44')];if(!_0x340f55[_0xe283('0x43')][_0xe283('0x45')](_0xe283('0x6e'))){_0x4140d7[_0xe283('0x23')]=qs['limit'](_0x340f55[_0xe283('0x43')][_0xe283('0x23')]);_0x4140d7[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x340f55[_0xe283('0x43')]['offset']);}return _0x4c0195['getMembers'](_0x4140d7);}})['then'](function(_0x24f748){return _0x24f748?{'count':_0x4a303c,'rows':_0x24f748}:null;})[_0xe283('0x2b')](respondWithResult(_0x3827c0,null))[_0xe283('0x51')](handleError(_0x3827c0,null));};exports[_0xe283('0x9d')]=function(_0x3392bb,_0x8f3f6b,_0x580dc3){var _0x1980a2={};var _0x8316ec={};var _0x52e0b6;var _0x9db0ec;return db[_0xe283('0x3b')][_0xe283('0x6a')]({'where':{'id':_0x3392bb['params']['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x8f3f6b,null))[_0xe283('0x2b')](function(_0x5b2df6){if(_0x5b2df6){_0x52e0b6=_0x5b2df6;_0x8316ec[_0xe283('0x3f')]=_[_0xe283('0x54')](db[_0xe283('0x9e')]['rawAttributes']);_0x8316ec['query']=_[_0xe283('0x54')](_0x3392bb[_0xe283('0x43')]);_0x8316ec['filters']=_[_0xe283('0x41')](_0x8316ec['model'],_0x8316ec[_0xe283('0x43')]);_0x1980a2[_0xe283('0x40')]=_[_0xe283('0x41')](_0x8316ec['model'],qs['fields'](_0x3392bb[_0xe283('0x43')][_0xe283('0x42')]));_0x1980a2[_0xe283('0x40')]=_0x1980a2[_0xe283('0x40')][_0xe283('0x44')]?_0x1980a2['attributes']:_0x8316ec[_0xe283('0x3f')];_0x1980a2['order']=qs[_0xe283('0x47')](_0x3392bb[_0xe283('0x43')][_0xe283('0x47')]);_0x1980a2[_0xe283('0x48')]=qs[_0xe283('0x49')](_['pick'](_0x3392bb[_0xe283('0x43')],_0x8316ec[_0xe283('0x49')]));if(_0x3392bb['query'][_0xe283('0x2f')]){_0x1980a2[_0xe283('0x48')]=_[_0xe283('0x4b')](_0x1980a2[_0xe283('0x48')],{'$or':_['map'](_0x1980a2[_0xe283('0x40')],function(_0x78b29c){var _0x574759={};_0x574759[_0x78b29c]={'$like':'%'+_0x3392bb['query']['filter']+'%'};return _0x574759;})});}_0x1980a2=_[_0xe283('0x4b')]({},_0x1980a2,_0x3392bb[_0xe283('0x55')]);return _0x52e0b6[_0xe283('0x9d')](_0x1980a2);}})['then'](function(_0x5f15b9){if(_0x5f15b9){_0x9db0ec=_0x5f15b9[_0xe283('0x44')];if(!_0x3392bb[_0xe283('0x43')][_0xe283('0x45')](_0xe283('0x6e'))){_0x1980a2[_0xe283('0x23')]=qs[_0xe283('0x23')](_0x3392bb['query'][_0xe283('0x23')]);_0x1980a2['offset']=qs['offset'](_0x3392bb[_0xe283('0x43')][_0xe283('0x21')]);}return _0x52e0b6[_0xe283('0x9d')](_0x1980a2);}})[_0xe283('0x2b')](function(_0x281511){if(_0x281511){return _0x281511?{'count':_0x9db0ec,'rows':_0x281511}:null;}})['then'](respondWithResult(_0x8f3f6b,null))['catch'](handleError(_0x8f3f6b,null));};exports[_0xe283('0x9f')]=function(_0x5ec863,_0x2cb51c,_0x831d13){var _0x47b882,_0x3bdf7e;return db[_0xe283('0x3b')][_0xe283('0x35')]({'where':{'id':_0x5ec863[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x2cb51c,null))[_0xe283('0x2b')](function(_0x116b08){if(_0x116b08){_0x3bdf7e=_0x116b08;return _0x116b08[_0xe283('0x9f')](_0x5ec863['body']['ids'],_['omit'](_0x5ec863[_0xe283('0x57')],[_0xe283('0x94'),'id'])||{});}return null;})[_0xe283('0x96')](function(_0x4a9ff3){var _0x413b29;_0x47b882=_0x4a9ff3||[];var _0x35c718=[];if(_0x4a9ff3){for(var _0x2358cf=0x0;_0x2358cf<_0x4a9ff3[_0xe283('0x44')];_0x2358cf+=0x1){var _0x4f9566=_0x4a9ff3[_0x2358cf][_0xe283('0x2c')]({'plain':!![]});_0x3bdf7e[_0xe283('0xa0')]=_0x5ec863[_0xe283('0x57')]['dialCheckDuplicateType']?_0x5ec863[_0xe283('0x57')][_0xe283('0xa0')]:_0x3bdf7e[_0xe283('0xa0')];switch(_0x3bdf7e[_0xe283('0xa0')]){case _0xe283('0xa1'):_0x413b29=squel[_0xe283('0xa2')]()['into']('cm_hopper')['fromQuery']([_0xe283('0xa3'),_0xe283('0xa4'),_0xe283('0xa5'),_0xe283('0xa6'),_0xe283('0x68'),_0xe283('0x61'),'updatedAt'],squel[_0xe283('0xa7')]()[_0xe283('0x87')]('phone',_0xe283('0xa3'))[_0xe283('0x87')](_0xe283('0xa8'),'scheduledAt')['field']('id','ContactId')[_0xe283('0x87')](_0x4f9566[_0xe283('0xa9')][_0xe283('0x8f')](),'ListId')[_0xe283('0x87')](_0x5ec863[_0xe283('0x53')]['id'][_0xe283('0x8f')](),_0xe283('0x68'))[_0xe283('0x87')](_0xe283('0xa8'),_0xe283('0x61'))[_0xe283('0x87')](_0xe283('0xa8'),_0xe283('0x62'))[_0xe283('0x89')](_0xe283('0xaa'))[_0xe283('0x48')](_0xe283('0xab'))['where'](_0xe283('0xac'),_0x4f9566[_0xe283('0xa9')][_0xe283('0x8f')]())['where']('phone\x20IS\x20NOT\x20NULL')[_0xe283('0x48')]('phone\x20NOT\x20IN\x20(?)',squel[_0xe283('0xa7')]()[_0xe283('0x87')](_0xe283('0xad'))['from'](_0xe283('0xae'))[_0xe283('0x48')]('VoiceQueueId\x20=\x20?',_0x5ec863[_0xe283('0x53')]['id']['toString']()))[_0xe283('0x48')](_0xe283('0xaf'),squel[_0xe283('0xa7')]()[_0xe283('0x87')](_0xe283('0xb0'))[_0xe283('0x89')](_0xe283('0xb1'))['where'](_0xe283('0xb2'),_0x5ec863[_0xe283('0x53')]['id'][_0xe283('0x8f')]())))['toString']();break;case'onlyIfOpen':_0x413b29=squel['insert']()['into'](_0xe283('0xb1'))['fromQuery']([_0xe283('0xa3'),_0xe283('0xa4'),_0xe283('0xa5'),'ListId',_0xe283('0x68'),'createdAt',_0xe283('0x62')],squel[_0xe283('0xa7')]()[_0xe283('0x87')](_0xe283('0xa3'),_0xe283('0xa3'))[_0xe283('0x87')](_0xe283('0xa8'),_0xe283('0xa4'))['field']('id',_0xe283('0xa5'))[_0xe283('0x87')](_0x4f9566[_0xe283('0xa9')][_0xe283('0x8f')](),_0xe283('0xa6'))['field'](_0x5ec863[_0xe283('0x53')]['id'][_0xe283('0x8f')](),_0xe283('0x68'))[_0xe283('0x87')](_0xe283('0xa8'),_0xe283('0x61'))[_0xe283('0x87')](_0xe283('0xa8'),_0xe283('0x62'))[_0xe283('0x89')](_0xe283('0xaa'))['where'](_0xe283('0xab'))[_0xe283('0x48')](_0xe283('0xac'),_0x4f9566['CmListId'][_0xe283('0x8f')]())[_0xe283('0x48')](_0xe283('0xb3'))[_0xe283('0x48')](_0xe283('0xaf'),squel['select']()[_0xe283('0x87')](_0xe283('0xb0'))[_0xe283('0x89')](_0xe283('0xb1'))[_0xe283('0x48')](_0xe283('0xb2'),_0x5ec863[_0xe283('0x53')]['id'][_0xe283('0x8f')]())))[_0xe283('0x8f')]();break;default:_0x413b29=squel[_0xe283('0xa2')]()[_0xe283('0xb4')](_0xe283('0xb1'))[_0xe283('0xb5')](['phone',_0xe283('0xa4'),_0xe283('0xa5'),'ListId','VoiceQueueId',_0xe283('0x61'),_0xe283('0x62')],squel[_0xe283('0xa7')]()[_0xe283('0x87')](_0xe283('0xa3'),_0xe283('0xa3'))[_0xe283('0x87')](_0xe283('0xa8'),_0xe283('0xa4'))[_0xe283('0x87')]('id',_0xe283('0xa5'))['field'](_0x4f9566[_0xe283('0xa9')]['toString'](),_0xe283('0xa6'))['field'](_0x5ec863[_0xe283('0x53')]['id'][_0xe283('0x8f')](),_0xe283('0x68'))[_0xe283('0x87')](_0xe283('0xa8'),_0xe283('0x61'))[_0xe283('0x87')]('NOW()',_0xe283('0x62'))[_0xe283('0x89')]('cm_contacts')[_0xe283('0x48')](_0xe283('0xab'))['where'](_0xe283('0xac'),_0x4f9566[_0xe283('0xa9')][_0xe283('0x8f')]())['where'](_0xe283('0xb3')))[_0xe283('0x8f')]();}_0x35c718['push'](db[_0xe283('0x8e')][_0xe283('0x43')](_0x413b29));}return BPromise[_0xe283('0x93')](_0x35c718);}})[_0xe283('0x2b')](function(){return _0x47b882;})[_0xe283('0x2b')](respondWithResult(_0x2cb51c,null))[_0xe283('0x51')](handleError(_0x2cb51c,null));};exports[_0xe283('0xb6')]=function(_0x62e949,_0x54e07e,_0x444909){return db[_0xe283('0x3b')][_0xe283('0x35')]({'where':{'id':_0x62e949[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x54e07e,null))['then'](function(_0x4fc20a){if(_0x4fc20a){return _0x4fc20a[_0xe283('0xb6')](_0x62e949['query'][_0xe283('0x94')]);}})[_0xe283('0x2b')](function(_0x3a3cab){if(_0x3a3cab){return db[_0xe283('0x67')][_0xe283('0x65')]({'where':{'ListId':_0x62e949[_0xe283('0x43')][_0xe283('0x94')],'VoiceQueueId':_0x62e949[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](function(){return _0x3a3cab;});}})[_0xe283('0x2b')](respondWithStatusCode(_0x54e07e,null))[_0xe283('0x51')](handleError(_0x54e07e,null));};exports[_0xe283('0xb7')]=function(_0x3bcbab,_0x3e4a05,_0x50f059){var _0x292735={};var _0x28b3c9={};var _0x123ddf;var _0x1785bb;return db['VoiceQueue'][_0xe283('0x6a')]({'where':{'id':_0x3bcbab[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x3e4a05,null))[_0xe283('0x2b')](function(_0x691f1e){if(_0x691f1e){_0x123ddf=_0x691f1e;_0x28b3c9[_0xe283('0x3f')]=_[_0xe283('0x54')](db[_0xe283('0x9e')]['rawAttributes']);_0x28b3c9['query']=_[_0xe283('0x54')](_0x3bcbab['query']);_0x28b3c9[_0xe283('0x49')]=_[_0xe283('0x41')](_0x28b3c9[_0xe283('0x3f')],_0x28b3c9[_0xe283('0x43')]);_0x292735['attributes']=_[_0xe283('0x41')](_0x28b3c9[_0xe283('0x3f')],qs[_0xe283('0x42')](_0x3bcbab[_0xe283('0x43')][_0xe283('0x42')]));_0x292735['attributes']=_0x292735['attributes']['length']?_0x292735[_0xe283('0x40')]:_0x28b3c9[_0xe283('0x3f')];_0x292735[_0xe283('0x46')]=qs[_0xe283('0x47')](_0x3bcbab[_0xe283('0x43')][_0xe283('0x47')]);_0x292735[_0xe283('0x48')]=qs[_0xe283('0x49')](_[_0xe283('0x4a')](_0x3bcbab[_0xe283('0x43')],_0x28b3c9[_0xe283('0x49')]));if(_0x3bcbab[_0xe283('0x43')]['filter']){_0x292735[_0xe283('0x48')]=_[_0xe283('0x4b')](_0x292735[_0xe283('0x48')],{'$or':_[_0xe283('0x31')](_0x292735[_0xe283('0x40')],function(_0x5739b3){var _0x56bc36={};_0x56bc36[_0x5739b3]={'$like':'%'+_0x3bcbab['query'][_0xe283('0x2f')]+'%'};return _0x56bc36;})});}_0x292735=_[_0xe283('0x4b')]({},_0x292735,_0x3bcbab['options']);return _0x123ddf['getBlackLists'](_0x292735);}})[_0xe283('0x2b')](function(_0x3e6be2){if(_0x3e6be2){_0x1785bb=_0x3e6be2[_0xe283('0x44')];if(!_0x3bcbab[_0xe283('0x43')][_0xe283('0x45')](_0xe283('0x6e'))){_0x292735[_0xe283('0x23')]=qs[_0xe283('0x23')](_0x3bcbab[_0xe283('0x43')][_0xe283('0x23')]);_0x292735[_0xe283('0x21')]=qs[_0xe283('0x21')](_0x3bcbab[_0xe283('0x43')][_0xe283('0x21')]);}return _0x123ddf['getBlackLists'](_0x292735);}})[_0xe283('0x2b')](function(_0x52dcb4){if(_0x52dcb4){return _0x52dcb4?{'count':_0x1785bb,'rows':_0x52dcb4}:null;}})[_0xe283('0x2b')](respondWithResult(_0x3e4a05,null))[_0xe283('0x51')](handleError(_0x3e4a05,null));};exports[_0xe283('0xb8')]=function(_0x573aaa,_0x21e36b,_0x5818df){var _0x8d71aa,_0x19fead;return db[_0xe283('0x3b')]['find']({'where':{'id':_0x573aaa[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](handleEntityNotFound(_0x21e36b,null))[_0xe283('0x2b')](function(_0x3e938d){if(_0x3e938d){_0x19fead=_0x3e938d;return _0x3e938d[_0xe283('0xb8')](_0x573aaa[_0xe283('0x57')][_0xe283('0x94')],_[_0xe283('0x63')](_0x573aaa[_0xe283('0x57')],[_0xe283('0x94'),'id'])||{});}return null;})[_0xe283('0x96')](function(_0x5314a2){var _0x54f7e7;_0x8d71aa=_0x5314a2||[];var _0x1445e5=[];if(_0x5314a2){for(var _0x132d8c=0x0;_0x132d8c<_0x5314a2[_0xe283('0x44')];_0x132d8c+=0x1){var _0x52a778=_0x5314a2[_0x132d8c][_0xe283('0x2c')]({'plain':!![]});_0x54f7e7=squel[_0xe283('0xa2')]()['into']('cm_hopper_black')['fromQuery']([_0xe283('0xa3'),_0xe283('0xa5'),_0xe283('0xa6'),'VoiceQueueId',_0xe283('0x61'),_0xe283('0x62')],squel[_0xe283('0xa7')]()['field'](_0xe283('0xa3'),_0xe283('0xa3'))[_0xe283('0x87')]('id',_0xe283('0xa5'))[_0xe283('0x87')](_0x52a778[_0xe283('0xa9')][_0xe283('0x8f')](),_0xe283('0xa6'))[_0xe283('0x87')](_0x573aaa[_0xe283('0x53')]['id'][_0xe283('0x8f')](),_0xe283('0x68'))['field'](_0xe283('0xa8'),_0xe283('0x61'))[_0xe283('0x87')](_0xe283('0xa8'),_0xe283('0x62'))['from'](_0xe283('0xaa'))[_0xe283('0x48')]('deletedAt\x20IS\x20NULL')[_0xe283('0x48')](_0xe283('0xac'),_0x52a778['CmListId'][_0xe283('0x8f')]())['where'](_0xe283('0xb3')))[_0xe283('0x8f')]();_0x1445e5[_0xe283('0x8d')](db[_0xe283('0x8e')][_0xe283('0x43')](_0x54f7e7));}return BPromise[_0xe283('0x93')](_0x1445e5);}})[_0xe283('0x2b')](function(){return _0x8d71aa;})[_0xe283('0x2b')](respondWithResult(_0x21e36b,null))[_0xe283('0x51')](handleError(_0x21e36b,null));};exports['removeBlackLists']=function(_0x324040,_0x59f4ec,_0x483c19){return db[_0xe283('0x3b')]['find']({'where':{'id':_0x324040[_0xe283('0x53')]['id']}})['then'](handleEntityNotFound(_0x59f4ec,null))['then'](function(_0x22e9f4){if(_0x22e9f4){return _0x22e9f4[_0xe283('0xb9')](_0x324040['query'][_0xe283('0x94')]);}})[_0xe283('0x2b')](function(_0x57763d){if(_0x57763d){return db['CmHopperBlack']['destroy']({'where':{'ListId':_0x324040[_0xe283('0x43')][_0xe283('0x94')],'VoiceQueueId':_0x324040[_0xe283('0x53')]['id']}})[_0xe283('0x2b')](function(){return _0x57763d;});}})[_0xe283('0x2b')](respondWithStatusCode(_0x59f4ec,null))[_0xe283('0x51')](handleError(_0x59f4ec,null));};
\ No newline at end of file
+var _0x4757=['NOW()','ContactId','CmListId','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','VoiceQueueId\x20=\x20?','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','onlyIfOpen','fromQuery','select','ListId\x20=\x20?','removeLists','getBlackLists','cm_hopper_black','removeBlackLists','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./voiceQueue.socket','register','sendStatus','end','status','json','undefined','limit','offset','count','set','Content-Range','apply','reject','save','update','then','destroy','get','VoiceQueues','outbound','filter','ignore','map','value','includes','find','type','name','UserProfileResource','error','send','index','VoiceQueue','fieldName','key','model','query','keys','filters','intersection','attributes','hasOwnProperty','nolimit','order','sort','where','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','fields','include','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','inbound','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','createdAt','updatedAt','body','omit','QueueCampaigns','UserProfileSection','userProfileId','findOne','CmHopper','rawAttributes','pick','VoiceQueueId','CmHopperHistory','CmHopperFinal','getHopperBlacks','CmHopperBlack','length','Team','getTeams','addTeams','User','voicePause','flatMap','Agents','forEach','penalty','each','UserVoiceQueue','UserVoiceQueueRt','isNil','format','SIP/%s','userVoiceQueue:save','removeTeams','ids','field','from','team_has_voice_queues','join','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','TeamId','all','sequelize','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','emit','online','interface','isArray','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','insert','into','cm_hopper','scheduledAt','ListId','phone'];(function(_0x20b0ef,_0x20e8c8){var _0x1f32c8=function(_0x3c42c5){while(--_0x3c42c5){_0x20b0ef['push'](_0x20b0ef['shift']());}};_0x1f32c8(++_0x20e8c8);}(_0x4757,0xc9));var _0x7475=function(_0x41cfd4,_0x1ed2cc){_0x41cfd4=_0x41cfd4-0x0;var _0x190f48=_0x4757[_0x41cfd4];return _0x190f48;};'use strict';var emlformat=require(_0x7475('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x7475('0x1'));var jsonpatch=require(_0x7475('0x2'));var rp=require(_0x7475('0x3'));var moment=require(_0x7475('0x4'));var BPromise=require(_0x7475('0x5'));var Mustache=require(_0x7475('0x6'));var util=require('util');var path=require('path');var sox=require('sox');var csv=require(_0x7475('0x7'));var ejs=require(_0x7475('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x7475('0x9'));var squel=require(_0x7475('0xa'));var crypto=require(_0x7475('0xb'));var jsforce=require(_0x7475('0xc'));var deskjs=require(_0x7475('0xd'));var toCsv=require(_0x7475('0x7'));var querystring=require(_0x7475('0xe'));var Papa=require(_0x7475('0xf'));var Redis=require(_0x7475('0x10'));var authService=require(_0x7475('0x11'));var qs=require(_0x7475('0x12'));var as=require(_0x7475('0x13'));var hardwareService=require(_0x7475('0x14'));var logger=require(_0x7475('0x15'))(_0x7475('0x16'));var utils=require(_0x7475('0x17'));var config=require(_0x7475('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0x7475('0x19'))['db'];config[_0x7475('0x1a')]=_[_0x7475('0x1b')](config[_0x7475('0x1a')],{'host':'localhost','port':0x18eb});var socket=require(_0x7475('0x1c'))(new Redis(config['redis']));require(_0x7475('0x1d'))[_0x7475('0x1e')](socket);function respondWithStatusCode(_0x1113f3,_0x2d4116){_0x2d4116=_0x2d4116||0xcc;return function(_0x1e8490){if(_0x1e8490){return _0x1113f3[_0x7475('0x1f')](_0x2d4116);}return _0x1113f3['status'](_0x2d4116)[_0x7475('0x20')]();};}function respondWithResult(_0x1f427f,_0x2d5596){_0x2d5596=_0x2d5596||0xc8;return function(_0x363971){if(_0x363971){return _0x1f427f[_0x7475('0x21')](_0x2d5596)[_0x7475('0x22')](_0x363971);}};}function respondWithFilteredResult(_0x56edf1,_0x3b03e9){return function(_0x4509c4){if(_0x4509c4){var _0x5d65cd=typeof _0x3b03e9['offset']===_0x7475('0x23')&&typeof _0x3b03e9[_0x7475('0x24')]===_0x7475('0x23');var _0x3d9ee1=_0x4509c4['count'];var _0x371bf9=_0x5d65cd?0x0:_0x3b03e9[_0x7475('0x25')];var _0x3ecd64=_0x5d65cd?_0x4509c4[_0x7475('0x26')]:_0x3b03e9[_0x7475('0x25')]+_0x3b03e9[_0x7475('0x24')];var _0x20c0a5;if(_0x3ecd64>=_0x3d9ee1){_0x3ecd64=_0x3d9ee1;_0x20c0a5=0xc8;}else{_0x20c0a5=0xce;}_0x56edf1[_0x7475('0x21')](_0x20c0a5);return _0x56edf1[_0x7475('0x27')](_0x7475('0x28'),_0x371bf9+'-'+_0x3ecd64+'/'+_0x3d9ee1)[_0x7475('0x22')](_0x4509c4);}return null;};}function patchUpdates(_0x2300ef){return function(_0x67ca7){try{jsonpatch[_0x7475('0x29')](_0x67ca7,_0x2300ef,!![]);}catch(_0x5176ab){return BPromise[_0x7475('0x2a')](_0x5176ab);}return _0x67ca7[_0x7475('0x2b')]();};}function saveUpdates(_0x31c2b8,_0x27c379){return function(_0x7423fc){if(_0x7423fc){return _0x7423fc[_0x7475('0x2c')](_0x31c2b8)[_0x7475('0x2d')](function(_0x36eb84){return _0x36eb84;});}return null;};}function removeEntity(_0x5eaf18,_0x4e645a){return function(_0x17a45a){if(_0x17a45a){return _0x17a45a[_0x7475('0x2e')]()[_0x7475('0x2d')](function(){var _0x172a74=_0x17a45a[_0x7475('0x2f')]({'plain':!![]});var _0x12ad54=[{'name':_0x7475('0x30'),'value':'inbound','ignore':![]},{'name':'QueueCampaigns','value':_0x7475('0x31'),'ignore':![]}];var _0x16164b=_(_0x12ad54)[_0x7475('0x32')](_0x7475('0x33'))[_0x7475('0x34')](_0x7475('0x35'))[_0x7475('0x35')]();if(_[_0x7475('0x36')](_0x16164b,_0x172a74['type'])){return;}var _0x54c3b4=_[_0x7475('0x37')](_0x12ad54,['value',_0x172a74[_0x7475('0x38')]])[_0x7475('0x39')];return db[_0x7475('0x3a')][_0x7475('0x2e')]({'where':{'type':_0x54c3b4,'resourceId':_0x172a74['id']}})['then'](function(){return _0x17a45a;});})[_0x7475('0x2d')](function(){_0x5eaf18[_0x7475('0x21')](0xcc)[_0x7475('0x20')]();});}};}function handleEntityNotFound(_0x2b7383,_0x1ed2e9){return function(_0x4c95a4){if(!_0x4c95a4){_0x2b7383[_0x7475('0x1f')](0x194);}return _0x4c95a4;};}function handleError(_0x22ef00,_0x234e25){_0x234e25=_0x234e25||0x1f4;return function(_0x487f4b){logger[_0x7475('0x3b')](_0x487f4b['stack']);if(_0x487f4b[_0x7475('0x39')]){delete _0x487f4b['name'];}_0x22ef00[_0x7475('0x21')](_0x234e25)[_0x7475('0x3c')](_0x487f4b);};}exports[_0x7475('0x3d')]=function(_0x271f02,_0x16cee9){var _0xa57dab={},_0x31abd0={},_0x353d81={'count':0x0,'rows':[]};var _0xc6e128=_['map'](db[_0x7475('0x3e')]['rawAttributes'],function(_0x293afd){return{'name':_0x293afd[_0x7475('0x3f')],'type':_0x293afd[_0x7475('0x38')][_0x7475('0x40')]};});_0x31abd0[_0x7475('0x41')]=_['map'](_0xc6e128,'name');_0x31abd0[_0x7475('0x42')]=_[_0x7475('0x43')](_0x271f02['query']);_0x31abd0[_0x7475('0x44')]=_[_0x7475('0x45')](_0x31abd0[_0x7475('0x41')],_0x31abd0[_0x7475('0x42')]);_0xa57dab[_0x7475('0x46')]=_[_0x7475('0x45')](_0x31abd0['model'],qs['fields'](_0x271f02[_0x7475('0x42')]['fields']));_0xa57dab[_0x7475('0x46')]=_0xa57dab['attributes']['length']?_0xa57dab[_0x7475('0x46')]:_0x31abd0[_0x7475('0x41')];if(!_0x271f02['query'][_0x7475('0x47')](_0x7475('0x48'))){_0xa57dab['limit']=qs[_0x7475('0x24')](_0x271f02[_0x7475('0x42')][_0x7475('0x24')]);_0xa57dab[_0x7475('0x25')]=qs[_0x7475('0x25')](_0x271f02[_0x7475('0x42')][_0x7475('0x25')]);}_0xa57dab[_0x7475('0x49')]=qs['sort'](_0x271f02['query'][_0x7475('0x4a')]);_0xa57dab[_0x7475('0x4b')]=qs[_0x7475('0x44')](_['pick'](_0x271f02['query'],_0x31abd0['filters']),_0xc6e128);if(_0x271f02[_0x7475('0x42')][_0x7475('0x32')]){_0xa57dab['where']=_[_0x7475('0x4c')](_0xa57dab[_0x7475('0x4b')],{'$or':_['map'](_0xc6e128,function(_0x33db0d){if(_0x33db0d[_0x7475('0x38')]!==_0x7475('0x4d')){var _0x356e58={};_0x356e58[_0x33db0d[_0x7475('0x39')]]={'$like':'%'+_0x271f02[_0x7475('0x42')]['filter']+'%'};return _0x356e58;}})});}_0xa57dab=_[_0x7475('0x4c')]({},_0xa57dab,_0x271f02[_0x7475('0x4e')]);var _0x2636ee={'where':_0xa57dab['where']};return db[_0x7475('0x3e')][_0x7475('0x26')](_0x2636ee)[_0x7475('0x2d')](function(_0x5c4524){_0x353d81[_0x7475('0x26')]=_0x5c4524;if(_0x271f02[_0x7475('0x42')][_0x7475('0x4f')]){_0xa57dab['include']=[{'all':!![]}];}return db[_0x7475('0x3e')][_0x7475('0x50')](_0xa57dab);})[_0x7475('0x2d')](function(_0x1348ee){_0x353d81[_0x7475('0x51')]=_0x1348ee;return _0x353d81;})[_0x7475('0x2d')](respondWithFilteredResult(_0x16cee9,_0xa57dab))[_0x7475('0x52')](handleError(_0x16cee9,null));};exports[_0x7475('0x53')]=function(_0x4f34a3,_0x5b84fb){var _0x1287df={'raw':![],'where':{'id':_0x4f34a3['params']['id']}},_0x1765b5={};_0x1765b5[_0x7475('0x41')]=_[_0x7475('0x43')](db['VoiceQueue']['rawAttributes']);_0x1765b5['query']=_[_0x7475('0x43')](_0x4f34a3[_0x7475('0x42')]);_0x1765b5[_0x7475('0x44')]=_[_0x7475('0x45')](_0x1765b5[_0x7475('0x41')],_0x1765b5[_0x7475('0x42')]);_0x1287df['attributes']=_[_0x7475('0x45')](_0x1765b5[_0x7475('0x41')],qs[_0x7475('0x54')](_0x4f34a3['query'][_0x7475('0x54')]));_0x1287df['attributes']=_0x1287df[_0x7475('0x46')]['length']?_0x1287df['attributes']:_0x1765b5['model'];if(_0x4f34a3[_0x7475('0x42')][_0x7475('0x4f')]){_0x1287df[_0x7475('0x55')]=[{'all':!![]}];}_0x1287df=_[_0x7475('0x4c')]({},_0x1287df,_0x4f34a3[_0x7475('0x4e')]);return db[_0x7475('0x3e')][_0x7475('0x37')](_0x1287df)[_0x7475('0x2d')](handleEntityNotFound(_0x5b84fb,null))[_0x7475('0x2d')](respondWithResult(_0x5b84fb,null))[_0x7475('0x52')](handleError(_0x5b84fb,null));};exports[_0x7475('0x56')]=function(_0x53bce1,_0x5ce37f){return db[_0x7475('0x3e')][_0x7475('0x56')](_0x53bce1['body'],{})[_0x7475('0x2d')](function(_0x298087){var _0x5e7ae9=_0x53bce1[_0x7475('0x57')][_0x7475('0x2f')]({'plain':!![]});if(!_0x5e7ae9)throw new Error(_0x7475('0x58'));if(_0x5e7ae9[_0x7475('0x59')]===_0x7475('0x57')){var _0x202e19=_0x298087[_0x7475('0x2f')]({'plain':!![]});var _0x458306=[{'name':_0x7475('0x30'),'value':_0x7475('0x5a')},{'name':'QueueCampaigns','value':_0x7475('0x31')}];var _0x1555e8=_['find'](_0x458306,['value',_0x202e19[_0x7475('0x38')]])[_0x7475('0x39')];return db['UserProfileSection'][_0x7475('0x37')]({'where':{'name':_0x1555e8,'userProfileId':_0x5e7ae9['userProfileId']},'raw':!![]})[_0x7475('0x2d')](function(_0x4d28c9){if(_0x4d28c9&&_0x4d28c9[_0x7475('0x5b')]===0x0){return db[_0x7475('0x3a')][_0x7475('0x56')]({'name':_0x202e19[_0x7475('0x39')],'resourceId':_0x202e19['id'],'type':_0x4d28c9[_0x7475('0x39')],'sectionId':_0x4d28c9['id']},{})[_0x7475('0x2d')](function(){return _0x298087;});}else{return _0x298087;}})[_0x7475('0x52')](function(_0x2c2a0d){logger[_0x7475('0x3b')](_0x7475('0x5c'),_0x2c2a0d);throw _0x2c2a0d;});}return _0x298087;})[_0x7475('0x2d')](respondWithResult(_0x5ce37f,0xc9))[_0x7475('0x52')](handleError(_0x5ce37f,null));};exports[_0x7475('0x5d')]=function(_0x27a48c,_0x1675d2){var _0x3b9c2c={'where':{'id':_0x27a48c[_0x7475('0x5e')]['id']}},_0x20b64a={};_0x20b64a[_0x7475('0x41')]=_[_0x7475('0x43')](db[_0x7475('0x3e')]['rawAttributes']);_0x3b9c2c[_0x7475('0x46')]=_[_0x7475('0x45')](_0x20b64a['model'],qs[_0x7475('0x54')](_0x27a48c[_0x7475('0x42')]['fields']));_0x3b9c2c[_0x7475('0x46')]=_0x3b9c2c[_0x7475('0x46')]['length']?_0x3b9c2c['attributes']:_0x20b64a[_0x7475('0x41')];if(_0x27a48c['query'][_0x7475('0x4f')]){_0x3b9c2c[_0x7475('0x55')]=[{'all':!![]}];}_0x3b9c2c=_[_0x7475('0x4c')]({},_0x3b9c2c,_0x27a48c['options']);return db['VoiceQueue'][_0x7475('0x37')](_0x3b9c2c)[_0x7475('0x2d')](handleEntityNotFound(_0x1675d2,null))[_0x7475('0x2d')](function(_0x3cf44a){if(_0x3cf44a){var _0x21c5af=_0x3cf44a['get']({'plain':!![]});_0x21c5af=qs['omit'](_0x21c5af,['id',_0x7475('0x5f'),_0x7475('0x60')]);_0x27a48c[_0x7475('0x61')]=_[_0x7475('0x62')](_0x27a48c[_0x7475('0x61')],['id',_0x7475('0x5f'),_0x7475('0x60')]);return db['VoiceQueue'][_0x7475('0x56')](_[_0x7475('0x4c')](_0x21c5af,_0x27a48c[_0x7475('0x61')]),{'include':_0x27a48c['query']['includeAll']?[{'all':!![]}]:undefined})[_0x7475('0x2d')](function(_0x317aff){var _0x19283d=_0x27a48c[_0x7475('0x57')]['get']({'plain':!![]});if(!_0x19283d)throw new Error(_0x7475('0x58'));if(_0x19283d[_0x7475('0x59')]===_0x7475('0x57')){var _0x52d170=_0x317aff['get']({'plain':!![]});var _0x4e89a2=[{'name':_0x7475('0x30'),'value':_0x7475('0x5a')},{'name':_0x7475('0x63'),'value':_0x7475('0x31')}];var _0x5ecd9a=_[_0x7475('0x37')](_0x4e89a2,[_0x7475('0x35'),_0x52d170[_0x7475('0x38')]])[_0x7475('0x39')];return db[_0x7475('0x64')][_0x7475('0x37')]({'where':{'name':_0x5ecd9a,'userProfileId':_0x19283d[_0x7475('0x65')]},'raw':!![]})['then'](function(_0xa44927){if(_0xa44927&&_0xa44927[_0x7475('0x5b')]===0x0){return db[_0x7475('0x3a')][_0x7475('0x56')]({'name':_0x52d170[_0x7475('0x39')],'resourceId':_0x52d170['id'],'type':_0xa44927[_0x7475('0x39')],'sectionId':_0xa44927['id']},{})['then'](function(){return _0x317aff;});}else{return _0x317aff;}})[_0x7475('0x52')](function(_0x266ffb){logger[_0x7475('0x3b')](_0x7475('0x5c'),_0x266ffb);throw _0x266ffb;});}return _0x317aff;});}})[_0x7475('0x2d')](respondWithResult(_0x1675d2,0xc9))[_0x7475('0x52')](handleError(_0x1675d2,null));};exports[_0x7475('0x2c')]=function(_0xc5fce5,_0x1526da){if(_0xc5fce5[_0x7475('0x61')]['id']){delete _0xc5fce5[_0x7475('0x61')]['id'];}return db['VoiceQueue']['find']({'where':{'id':_0xc5fce5[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x1526da,null))[_0x7475('0x2d')](saveUpdates(_0xc5fce5[_0x7475('0x61')],null))[_0x7475('0x2d')](respondWithResult(_0x1526da,null))[_0x7475('0x52')](handleError(_0x1526da,null));};exports['destroy']=function(_0x1720f1,_0x49c74b){return db[_0x7475('0x3e')][_0x7475('0x37')]({'where':{'id':_0x1720f1[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x49c74b,null))[_0x7475('0x2d')](removeEntity(_0x49c74b,null))[_0x7475('0x52')](handleError(_0x49c74b,null));};exports['getHoppers']=function(_0x2a8bee,_0x51974d,_0x14e1dc){var _0x578b3b={'raw':![],'where':{}};var _0xc1df01={};var _0x56f0a1={'count':0x0,'rows':[]};return db[_0x7475('0x3e')][_0x7475('0x66')]({'where':{'id':_0x2a8bee[_0x7475('0x5e')]['id']}})['then'](handleEntityNotFound(_0x51974d,null))['then'](function(_0x1f59cb){if(_0x1f59cb){_0xc1df01[_0x7475('0x41')]=_[_0x7475('0x43')](db[_0x7475('0x67')][_0x7475('0x68')]);_0xc1df01[_0x7475('0x42')]=_[_0x7475('0x43')](_0x2a8bee[_0x7475('0x42')]);_0xc1df01['filters']=_[_0x7475('0x45')](_0xc1df01['model'],_0xc1df01[_0x7475('0x42')]);_0x578b3b[_0x7475('0x46')]=_[_0x7475('0x45')](_0xc1df01[_0x7475('0x41')],qs['fields'](_0x2a8bee[_0x7475('0x42')][_0x7475('0x54')]));_0x578b3b['attributes']=_0x578b3b['attributes']['length']?_0x578b3b[_0x7475('0x46')]:_0xc1df01[_0x7475('0x41')];if(!_0x2a8bee[_0x7475('0x42')]['hasOwnProperty'](_0x7475('0x48'))){_0x578b3b['limit']=qs[_0x7475('0x24')](_0x2a8bee[_0x7475('0x42')][_0x7475('0x24')]);_0x578b3b[_0x7475('0x25')]=qs['offset'](_0x2a8bee[_0x7475('0x42')][_0x7475('0x25')]);}_0x578b3b[_0x7475('0x49')]=qs[_0x7475('0x4a')](_0x2a8bee[_0x7475('0x42')][_0x7475('0x4a')]);_0x578b3b['where']=qs[_0x7475('0x44')](_[_0x7475('0x69')](_0x2a8bee[_0x7475('0x42')],_0xc1df01['filters']));_0x578b3b['where'][_0x7475('0x6a')]=_0x1f59cb['id'];if(_0x2a8bee[_0x7475('0x42')]['filter']){_0x578b3b[_0x7475('0x4b')]=_[_0x7475('0x4c')](_0x578b3b[_0x7475('0x4b')],{'$or':_[_0x7475('0x34')](_0x578b3b[_0x7475('0x46')],function(_0x29fb59){var _0x471821={};_0x471821[_0x29fb59]={'$like':'%'+_0x2a8bee[_0x7475('0x42')][_0x7475('0x32')]+'%'};return _0x471821;})});}_0x578b3b=_[_0x7475('0x4c')]({},_0x578b3b,_0x2a8bee[_0x7475('0x4e')]);return db['CmHopper'][_0x7475('0x26')]({'where':_0x578b3b[_0x7475('0x4b')]})[_0x7475('0x2d')](function(_0x33585b){_0x56f0a1['count']=_0x33585b;if(_0x2a8bee[_0x7475('0x42')][_0x7475('0x4f')]){_0x578b3b[_0x7475('0x55')]=[{'all':!![]}];}return db[_0x7475('0x67')][_0x7475('0x50')](_0x578b3b);})[_0x7475('0x2d')](function(_0x126623){_0x56f0a1[_0x7475('0x51')]=_0x126623;return _0x56f0a1;});}})[_0x7475('0x2d')](respondWithFilteredResult(_0x51974d,_0x578b3b))[_0x7475('0x52')](handleError(_0x51974d,null));};exports['getHopperHistories']=function(_0x557b37,_0x4f5b1e,_0x14b465){var _0x3835b9={'raw':!![],'where':{}};var _0x1e1454={};var _0x25a0ce={'count':0x0,'rows':[]};return db[_0x7475('0x3e')][_0x7475('0x66')]({'where':{'id':_0x557b37[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x4f5b1e,null))['then'](function(_0x406bbb){if(_0x406bbb){_0x1e1454[_0x7475('0x41')]=_[_0x7475('0x43')](db[_0x7475('0x6b')][_0x7475('0x68')]);_0x1e1454[_0x7475('0x42')]=_[_0x7475('0x43')](_0x557b37[_0x7475('0x42')]);_0x1e1454[_0x7475('0x44')]=_[_0x7475('0x45')](_0x1e1454[_0x7475('0x41')],_0x1e1454[_0x7475('0x42')]);_0x3835b9[_0x7475('0x46')]=_['intersection'](_0x1e1454[_0x7475('0x41')],qs[_0x7475('0x54')](_0x557b37[_0x7475('0x42')][_0x7475('0x54')]));_0x3835b9[_0x7475('0x46')]=_0x3835b9[_0x7475('0x46')]['length']?_0x3835b9[_0x7475('0x46')]:_0x1e1454['model'];if(!_0x557b37[_0x7475('0x42')][_0x7475('0x47')](_0x7475('0x48'))){_0x3835b9[_0x7475('0x24')]=qs[_0x7475('0x24')](_0x557b37['query'][_0x7475('0x24')]);_0x3835b9[_0x7475('0x25')]=qs['offset'](_0x557b37['query'][_0x7475('0x25')]);}_0x3835b9[_0x7475('0x49')]=qs[_0x7475('0x4a')](_0x557b37[_0x7475('0x42')]['sort']);_0x3835b9[_0x7475('0x4b')]=qs[_0x7475('0x44')](_[_0x7475('0x69')](_0x557b37[_0x7475('0x42')],_0x1e1454[_0x7475('0x44')]));_0x3835b9[_0x7475('0x4b')][_0x7475('0x6a')]=_0x406bbb['id'];if(_0x557b37[_0x7475('0x42')][_0x7475('0x32')]){_0x3835b9['where']=_['merge'](_0x3835b9[_0x7475('0x4b')],{'$or':_[_0x7475('0x34')](_0x3835b9[_0x7475('0x46')],function(_0x70f89c){var _0x245e59={};_0x245e59[_0x70f89c]={'$like':'%'+_0x557b37['query']['filter']+'%'};return _0x245e59;})});}_0x3835b9=_[_0x7475('0x4c')]({},_0x3835b9,_0x557b37[_0x7475('0x4e')]);return db[_0x7475('0x6b')]['count']({'where':_0x3835b9['where']})[_0x7475('0x2d')](function(_0x19df41){_0x25a0ce[_0x7475('0x26')]=_0x19df41;if(_0x557b37[_0x7475('0x42')][_0x7475('0x4f')]){_0x3835b9[_0x7475('0x55')]=[{'all':!![]}];}return db[_0x7475('0x6b')][_0x7475('0x50')](_0x3835b9);})[_0x7475('0x2d')](function(_0x4b50f8){_0x25a0ce['rows']=_0x4b50f8;return _0x25a0ce;});}})['then'](respondWithFilteredResult(_0x4f5b1e,_0x3835b9))[_0x7475('0x52')](handleError(_0x4f5b1e,null));};exports['getHopperFinals']=function(_0x5b7886,_0x4b8b6c,_0x5edef4){var _0x56fd58={'raw':!![],'where':{}};var _0x5a085d={};var _0x4aa122={'count':0x0,'rows':[]};return db[_0x7475('0x3e')][_0x7475('0x66')]({'where':{'id':_0x5b7886[_0x7475('0x5e')]['id']}})['then'](handleEntityNotFound(_0x4b8b6c,null))['then'](function(_0x561f5c){if(_0x561f5c){_0x5a085d['model']=_[_0x7475('0x43')](db['CmHopperFinal'][_0x7475('0x68')]);_0x5a085d[_0x7475('0x42')]=_['keys'](_0x5b7886[_0x7475('0x42')]);_0x5a085d[_0x7475('0x44')]=_[_0x7475('0x45')](_0x5a085d[_0x7475('0x41')],_0x5a085d[_0x7475('0x42')]);_0x56fd58[_0x7475('0x46')]=_['intersection'](_0x5a085d['model'],qs[_0x7475('0x54')](_0x5b7886[_0x7475('0x42')]['fields']));_0x56fd58[_0x7475('0x46')]=_0x56fd58['attributes']['length']?_0x56fd58[_0x7475('0x46')]:_0x5a085d[_0x7475('0x41')];if(!_0x5b7886[_0x7475('0x42')][_0x7475('0x47')](_0x7475('0x48'))){_0x56fd58[_0x7475('0x24')]=qs[_0x7475('0x24')](_0x5b7886[_0x7475('0x42')][_0x7475('0x24')]);_0x56fd58[_0x7475('0x25')]=qs[_0x7475('0x25')](_0x5b7886[_0x7475('0x42')][_0x7475('0x25')]);}_0x56fd58[_0x7475('0x49')]=qs[_0x7475('0x4a')](_0x5b7886[_0x7475('0x42')][_0x7475('0x4a')]);_0x56fd58[_0x7475('0x4b')]=qs[_0x7475('0x44')](_['pick'](_0x5b7886[_0x7475('0x42')],_0x5a085d['filters']));_0x56fd58['where']['VoiceQueueId']=_0x561f5c['id'];if(_0x5b7886[_0x7475('0x42')][_0x7475('0x32')]){_0x56fd58[_0x7475('0x4b')]=_[_0x7475('0x4c')](_0x56fd58[_0x7475('0x4b')],{'$or':_['map'](_0x56fd58[_0x7475('0x46')],function(_0x1d3712){var _0x35858c={};_0x35858c[_0x1d3712]={'$like':'%'+_0x5b7886[_0x7475('0x42')][_0x7475('0x32')]+'%'};return _0x35858c;})});}_0x56fd58=_['merge']({},_0x56fd58,_0x5b7886[_0x7475('0x4e')]);return db[_0x7475('0x6c')][_0x7475('0x26')]({'where':_0x56fd58[_0x7475('0x4b')]})[_0x7475('0x2d')](function(_0x26fd43){_0x4aa122[_0x7475('0x26')]=_0x26fd43;if(_0x5b7886[_0x7475('0x42')][_0x7475('0x4f')]){_0x56fd58[_0x7475('0x55')]=[{'all':!![]}];}return db[_0x7475('0x6c')][_0x7475('0x50')](_0x56fd58);})[_0x7475('0x2d')](function(_0x51c247){_0x4aa122[_0x7475('0x51')]=_0x51c247;return _0x4aa122;});}})[_0x7475('0x2d')](respondWithFilteredResult(_0x4b8b6c,_0x56fd58))['catch'](handleError(_0x4b8b6c,null));};exports[_0x7475('0x6d')]=function(_0x13a851,_0x422569,_0x31f074){var _0x526d84={'raw':!![],'where':{}};var _0x2da4d1={};var _0x3b6def={'count':0x0,'rows':[]};return db[_0x7475('0x3e')]['findOne']({'where':{'id':_0x13a851[_0x7475('0x5e')]['id']}})['then'](handleEntityNotFound(_0x422569,null))[_0x7475('0x2d')](function(_0x4ff1f0){if(_0x4ff1f0){_0x2da4d1[_0x7475('0x41')]=_[_0x7475('0x43')](db[_0x7475('0x6e')]['rawAttributes']);_0x2da4d1['query']=_[_0x7475('0x43')](_0x13a851[_0x7475('0x42')]);_0x2da4d1[_0x7475('0x44')]=_[_0x7475('0x45')](_0x2da4d1[_0x7475('0x41')],_0x2da4d1[_0x7475('0x42')]);_0x526d84[_0x7475('0x46')]=_[_0x7475('0x45')](_0x2da4d1[_0x7475('0x41')],qs[_0x7475('0x54')](_0x13a851[_0x7475('0x42')][_0x7475('0x54')]));_0x526d84[_0x7475('0x46')]=_0x526d84[_0x7475('0x46')][_0x7475('0x6f')]?_0x526d84[_0x7475('0x46')]:_0x2da4d1[_0x7475('0x41')];if(!_0x13a851[_0x7475('0x42')][_0x7475('0x47')]('nolimit')){_0x526d84['limit']=qs[_0x7475('0x24')](_0x13a851['query'][_0x7475('0x24')]);_0x526d84['offset']=qs['offset'](_0x13a851['query'][_0x7475('0x25')]);}_0x526d84['order']=qs['sort'](_0x13a851[_0x7475('0x42')][_0x7475('0x4a')]);_0x526d84[_0x7475('0x4b')]=qs[_0x7475('0x44')](_[_0x7475('0x69')](_0x13a851[_0x7475('0x42')],_0x2da4d1['filters']));_0x526d84[_0x7475('0x4b')][_0x7475('0x6a')]=_0x4ff1f0['id'];if(_0x13a851['query'][_0x7475('0x32')]){_0x526d84[_0x7475('0x4b')]=_[_0x7475('0x4c')](_0x526d84['where'],{'$or':_[_0x7475('0x34')](_0x526d84[_0x7475('0x46')],function(_0x22e1bd){var _0x2517bf={};_0x2517bf[_0x22e1bd]={'$like':'%'+_0x13a851['query']['filter']+'%'};return _0x2517bf;})});}_0x526d84=_[_0x7475('0x4c')]({},_0x526d84,_0x13a851[_0x7475('0x4e')]);return db[_0x7475('0x6e')][_0x7475('0x26')]({'where':_0x526d84[_0x7475('0x4b')]})[_0x7475('0x2d')](function(_0x1a7860){_0x3b6def['count']=_0x1a7860;if(_0x13a851[_0x7475('0x42')][_0x7475('0x4f')]){_0x526d84[_0x7475('0x55')]=[{'all':!![]}];}return db['CmHopperBlack'][_0x7475('0x50')](_0x526d84);})['then'](function(_0x134e28){_0x3b6def[_0x7475('0x51')]=_0x134e28;return _0x3b6def;});}})['then'](respondWithFilteredResult(_0x422569,_0x526d84))['catch'](handleError(_0x422569,null));};exports['getTeams']=function(_0x5a1904,_0x22f00c,_0x2483c2){var _0x511ad2={};var _0x1e4d18={};var _0x5ab645;var _0xd179ff;return db[_0x7475('0x3e')]['findOne']({'where':{'id':_0x5a1904[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x22f00c,null))[_0x7475('0x2d')](function(_0x488f2a){if(_0x488f2a){_0x5ab645=_0x488f2a;_0x1e4d18[_0x7475('0x41')]=_[_0x7475('0x43')](db[_0x7475('0x70')][_0x7475('0x68')]);_0x1e4d18[_0x7475('0x42')]=_['keys'](_0x5a1904[_0x7475('0x42')]);_0x1e4d18['filters']=_['intersection'](_0x1e4d18[_0x7475('0x41')],_0x1e4d18[_0x7475('0x42')]);_0x511ad2[_0x7475('0x46')]=_[_0x7475('0x45')](_0x1e4d18[_0x7475('0x41')],qs[_0x7475('0x54')](_0x5a1904[_0x7475('0x42')][_0x7475('0x54')]));_0x511ad2[_0x7475('0x46')]=_0x511ad2[_0x7475('0x46')][_0x7475('0x6f')]?_0x511ad2['attributes']:_0x1e4d18['model'];_0x511ad2[_0x7475('0x49')]=qs[_0x7475('0x4a')](_0x5a1904[_0x7475('0x42')]['sort']);_0x511ad2[_0x7475('0x4b')]=qs[_0x7475('0x44')](_[_0x7475('0x69')](_0x5a1904[_0x7475('0x42')],_0x1e4d18['filters']));if(_0x5a1904[_0x7475('0x42')][_0x7475('0x32')]){_0x511ad2[_0x7475('0x4b')]=_['merge'](_0x511ad2['where'],{'$or':_['map'](_0x511ad2[_0x7475('0x46')],function(_0x5d00aa){var _0x212853={};_0x212853[_0x5d00aa]={'$like':'%'+_0x5a1904[_0x7475('0x42')]['filter']+'%'};return _0x212853;})});}_0x511ad2=_[_0x7475('0x4c')]({},_0x511ad2,_0x5a1904[_0x7475('0x4e')]);return _0x5ab645[_0x7475('0x71')](_0x511ad2);}})[_0x7475('0x2d')](function(_0x4ba0b7){if(_0x4ba0b7){_0xd179ff=_0x4ba0b7['length'];if(!_0x5a1904[_0x7475('0x42')]['hasOwnProperty'](_0x7475('0x48'))){_0x511ad2['limit']=qs[_0x7475('0x24')](_0x5a1904[_0x7475('0x42')]['limit']);_0x511ad2[_0x7475('0x25')]=qs[_0x7475('0x25')](_0x5a1904[_0x7475('0x42')][_0x7475('0x25')]);}return _0x5ab645[_0x7475('0x71')](_0x511ad2);}})[_0x7475('0x2d')](function(_0x251ac1){if(_0x251ac1){return _0x251ac1?{'count':_0xd179ff,'rows':_0x251ac1}:null;}})[_0x7475('0x2d')](respondWithResult(_0x22f00c,null))['catch'](handleError(_0x22f00c,null));};exports[_0x7475('0x72')]=function(_0x4897ab,_0x356fe8,_0x4603a3){var _0x3973d2=_0x4897ab[_0x7475('0x61')]['teams'];var _0x2651e4=_[_0x7475('0x34')](_0x3973d2,'id');return db[_0x7475('0x70')][_0x7475('0x50')]({'where':{'id':_0x2651e4},'attributes':['id'],'include':[{'model':db[_0x7475('0x73')],'as':'Agents','attributes':['id',_0x7475('0x39'),'online',_0x7475('0x74'),'interface'],'raw':!![]}]})['then'](function(_0x35d719){if(_0x35d719){var _0x51695c=_[_0x7475('0x75')](_0x35d719,function(_0x1ea07f){var _0x47aa75=_0x1ea07f[_0x7475('0x2f')]({'plain':!![]});_0x47aa75[_0x7475('0x76')][_0x7475('0x77')](function(_0x298791){_0x298791[_0x7475('0x78')]=_['find'](_0x3973d2,{'id':_0x47aa75['id']})['penalty'];});return _0x47aa75[_0x7475('0x76')];});return db[_0x7475('0x3e')][_0x7475('0x37')]({'where':{'id':_0x4897ab[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](function(_0x17f461){return db['sequelize']['transaction'](function(_0x1043e4){return _0x17f461['addTeams'](_0x2651e4,{'transaction':_0x1043e4})['then'](function(){return BPromise[_0x7475('0x79')](_0x3973d2,function(_0x52585d){return db['TeamVoiceQueue']['upsert']({'TeamId':_0x52585d['id'],'VoiceQueueId':_0x4897ab[_0x7475('0x5e')]['id'],'penalty':_0x52585d['penalty']},{'transaction':_0x1043e4});});})[_0x7475('0x2d')](function(){return BPromise[_0x7475('0x79')](_0x51695c,function(_0x331ba5){return db[_0x7475('0x7a')]['findOrCreate']({'where':{'UserId':_0x331ba5['id'],'VoiceQueueId':_0x4897ab[_0x7475('0x5e')]['id']},'defaults':{'penalty':_0x331ba5[_0x7475('0x78')]},'transaction':_0x1043e4});});})[_0x7475('0x2d')](function(){return BPromise[_0x7475('0x79')](_[_0x7475('0x32')](_0x51695c,{'online':!![]}),function(_0x14696c){return db[_0x7475('0x7b')]['upsert']({'membername':_0x14696c[_0x7475('0x39')],'UserId':_0x14696c['id'],'queue_name':_0x17f461['name'],'VoiceQueueId':_0x17f461['id'],'interface':_[_0x7475('0x7c')](_0x14696c['interface'])?util[_0x7475('0x7d')](_0x7475('0x7e'),_0x14696c[_0x7475('0x39')]):_0x14696c['interface'],'paused':_0x14696c['voicePause']||![],'penalty':_0x14696c[_0x7475('0x78')]},{'transaction':_0x1043e4});});})[_0x7475('0x2d')](function(){_0x51695c['forEach'](function(_0x287aae){socket['emit'](_0x7475('0x7f'),{'UserId':_0x287aae['id'],'VoiceQueueId':_0x17f461['id']});});});});});}})[_0x7475('0x2d')](respondWithStatusCode(_0x356fe8,null))[_0x7475('0x52')](handleError(_0x356fe8,null));};exports[_0x7475('0x80')]=function(_0x17e67,_0x2feba6,_0x49143b){return db[_0x7475('0x70')][_0x7475('0x50')]({'where':{'id':_0x17e67['query'][_0x7475('0x81')]},'attributes':['id'],'include':[{'model':db[_0x7475('0x73')],'as':_0x7475('0x76'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x2feba6,null))[_0x7475('0x2d')](function(_0x4b8001){var _0x5b164b=_[_0x7475('0x34')](_0x4b8001,'id');var _0x446e71=[];var _0x192fdb=[];var _0x186d31=squel['select']();_0x186d31[_0x7475('0x82')]('tq.TeamId')[_0x7475('0x83')](_0x7475('0x84'),'tq')[_0x7475('0x85')]('user_has_teams','ut','ut.TeamId\x20=\x20tq.TeamId')[_0x7475('0x4b')]('VoiceQueueId\x20=\x20?',_0x17e67['params']['id']);for(var _0x3aa4db=0x0;_0x3aa4db<_0x4b8001[_0x7475('0x6f')];_0x3aa4db+=0x1){let _0x554974=_0x4b8001[_0x3aa4db];for(var _0x156d4b=0x0;_0x156d4b<_0x554974['Agents'][_0x7475('0x6f')];_0x156d4b+=0x1){let _0x1deb69=_0x554974['Agents'][_0x156d4b];var _0x19e13a=_0x186d31[_0x7475('0x5d')]();_0x19e13a[_0x7475('0x4b')](_0x7475('0x86'),_0x1deb69['id']);_0x192fdb[_0x7475('0x87')](db['sequelize'][_0x7475('0x42')](_0x19e13a[_0x7475('0x88')](),{'type':db['sequelize'][_0x7475('0x89')][_0x7475('0x8a')]})['then'](function(_0x3cd60e){if(_0x3cd60e[_0x7475('0x6f')]===0x1){return _0x1deb69['id'];}else{var _0x3e0967=_['every'](_[_0x7475('0x34')](_0x3cd60e,_0x7475('0x8b')),function(_0x44bdc8){return _['includes'](_0x5b164b,_0x44bdc8);});if(_0x3e0967){return _0x1deb69['id'];}}}));}}return BPromise[_0x7475('0x8c')](_0x192fdb)['then'](function(_0x156220){_0x446e71=_(_0x446e71)['union'](_0x156220)['compact']()[_0x7475('0x35')]();return db[_0x7475('0x3e')]['find']({'where':{'id':_0x17e67[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](function(_0xcf2c45){return db[_0x7475('0x8d')]['transaction'](function(_0x2acc0a){return _0xcf2c45['removeTeams'](_0x17e67[_0x7475('0x42')][_0x7475('0x81')],{'transaction':_0x2acc0a})[_0x7475('0x2d')](function(){if(!_[_0x7475('0x8e')](_0x446e71)){return _0xcf2c45[_0x7475('0x8f')](_0x446e71,{'transaction':_0x2acc0a})['then'](function(){return db[_0x7475('0x7b')]['destroy']({'where':{'VoiceQueueId':_0x17e67['params']['id'],'UserId':_0x446e71},'transaction':_0x2acc0a});});}})[_0x7475('0x2d')](function(){_0x446e71[_0x7475('0x77')](function(_0x5cf75c){socket['emit'](_0x7475('0x90'),{'UserId':_0x5cf75c,'VoiceQueueId':_0xcf2c45['id']});});});});});});})['then'](respondWithStatusCode(_0x2feba6,null))['catch'](handleError(_0x2feba6,null));};exports[_0x7475('0x91')]=function(_0x1f297f,_0x58b3d6,_0x1592e4){var _0x1573b1,_0x58fa0b;return db[_0x7475('0x3e')][_0x7475('0x37')]({'where':{'id':_0x1f297f['params']['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x58b3d6,null))[_0x7475('0x2d')](function(_0x24740e){if(_0x24740e){_0x58fa0b=_0x24740e;return _0x24740e[_0x7475('0x91')](_0x1f297f[_0x7475('0x61')][_0x7475('0x81')],_[_0x7475('0x62')](_0x1f297f['body'],['ids','id'])||{})[_0x7475('0x92')](function(_0x2f3a6f){for(var _0x4eb59d=0x0;_0x4eb59d<_0x1f297f[_0x7475('0x61')][_0x7475('0x81')][_0x7475('0x6f')];_0x4eb59d+=0x1){socket[_0x7475('0x93')]('userVoiceQueue:save',{'UserId':Number(_0x1f297f['body'][_0x7475('0x81')][_0x4eb59d]),'VoiceQueueId':Number(_0x1f297f[_0x7475('0x5e')]['id'])});}return _0x2f3a6f;});}})[_0x7475('0x2d')](function(_0x5ea563){_0x1573b1=_0x5ea563||[];if(_0x58fa0b){return db['User'][_0x7475('0x50')]({'where':{'id':_0x1f297f[_0x7475('0x61')]['ids']},'attributes':['id',_0x7475('0x39'),_0x7475('0x94'),'voicePause',_0x7475('0x95')],'raw':!![]});}})['then'](function(_0x2b57f7){if(!_[_0x7475('0x8e')](_0x2b57f7)){var _0x1dd666=[];for(var _0x4c10ba=0x0;_0x4c10ba<_0x2b57f7['length'];_0x4c10ba++){if(_0x2b57f7[_0x4c10ba][_0x7475('0x94')]){_0x1dd666['push'](db['UserVoiceQueueRt']['upsert']({'membername':_0x2b57f7[_0x4c10ba][_0x7475('0x39')],'UserId':_0x2b57f7[_0x4c10ba]['id'],'queue_name':_0x58fa0b[_0x7475('0x39')],'VoiceQueueId':_0x58fa0b['id'],'interface':_[_0x7475('0x7c')](_0x2b57f7[_0x4c10ba]['interface'])?util[_0x7475('0x7d')](_0x7475('0x7e'),_0x2b57f7[_0x4c10ba]['name']):_0x2b57f7[_0x4c10ba][_0x7475('0x95')],'paused':_0x2b57f7[_0x4c10ba][_0x7475('0x74')]||![],'penalty':_0x1f297f[_0x7475('0x61')][_0x7475('0x78')]||0x0}));}}return BPromise[_0x7475('0x8c')](_0x1dd666);}})[_0x7475('0x2d')](function(){return _0x1573b1;})[_0x7475('0x2d')](respondWithResult(_0x58b3d6,null))[_0x7475('0x52')](handleError(_0x58b3d6,null));};exports[_0x7475('0x8f')]=function(_0x4fb6e0,_0x58c1ed,_0x495176){return db[_0x7475('0x3e')]['find']({'where':{'id':_0x4fb6e0[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x58c1ed,null))[_0x7475('0x2d')](function(_0x2e8f50){if(_0x2e8f50){return _0x2e8f50[_0x7475('0x8f')](_0x4fb6e0[_0x7475('0x42')][_0x7475('0x81')])[_0x7475('0x2d')](function(){if(_[_0x7475('0x96')](_0x4fb6e0[_0x7475('0x42')][_0x7475('0x81')])){for(var _0xacc1e3=0x0;_0xacc1e3<_0x4fb6e0[_0x7475('0x42')][_0x7475('0x81')][_0x7475('0x6f')];_0xacc1e3+=0x1){socket['emit'](_0x7475('0x90'),{'UserId':Number(_0x4fb6e0[_0x7475('0x42')]['ids'][_0xacc1e3]),'VoiceQueueId':Number(_0x4fb6e0[_0x7475('0x5e')]['id'])});}}else{socket[_0x7475('0x93')](_0x7475('0x90'),{'UserId':Number(_0x4fb6e0[_0x7475('0x42')][_0x7475('0x81')]),'VoiceQueueId':Number(_0x4fb6e0[_0x7475('0x5e')]['id'])});}});}})['then'](function(_0x11f19f){return db['UserVoiceQueueRt'][_0x7475('0x2e')]({'where':{'VoiceQueueId':_0x4fb6e0['params']['id'],'UserId':_0x4fb6e0['query'][_0x7475('0x81')]}})[_0x7475('0x2d')](function(){return _0x11f19f;});})[_0x7475('0x2d')](respondWithStatusCode(_0x58c1ed,null))['catch'](handleError(_0x58c1ed,null));};exports['getAgents']=function(_0x2e97d4,_0x3315ae,_0x241e77){var _0x3f1599={};var _0x40c912={};var _0x16bc13;var _0x4e2428;return db[_0x7475('0x3e')][_0x7475('0x66')]({'where':{'id':_0x2e97d4['params']['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x3315ae,null))[_0x7475('0x2d')](function(_0x2a6321){if(_0x2a6321){_0x16bc13=_0x2a6321;_0x40c912[_0x7475('0x41')]=_[_0x7475('0x43')](db['User'][_0x7475('0x68')]);_0x40c912['query']=_['keys'](_0x2e97d4[_0x7475('0x42')]);_0x40c912[_0x7475('0x44')]=_['intersection'](_0x40c912[_0x7475('0x41')],_0x40c912[_0x7475('0x42')]);_0x3f1599['attributes']=_[_0x7475('0x45')](_0x40c912['model'],qs[_0x7475('0x54')](_0x2e97d4[_0x7475('0x42')]['fields']));_0x3f1599[_0x7475('0x46')]=_0x3f1599[_0x7475('0x46')]['length']?_0x3f1599[_0x7475('0x46')]:_0x40c912['model'];_0x3f1599[_0x7475('0x49')]=qs[_0x7475('0x4a')](_0x2e97d4[_0x7475('0x42')][_0x7475('0x4a')]);_0x3f1599['where']=qs[_0x7475('0x44')](_[_0x7475('0x69')](_0x2e97d4[_0x7475('0x42')],_0x40c912[_0x7475('0x44')]));if(_0x2e97d4['query'][_0x7475('0x32')]){_0x3f1599['where']=_[_0x7475('0x4c')](_0x3f1599[_0x7475('0x4b')],{'$or':_[_0x7475('0x34')](_0x3f1599[_0x7475('0x46')],function(_0x191ff0){var _0x21d17f={};_0x21d17f[_0x191ff0]={'$like':'%'+_0x2e97d4['query'][_0x7475('0x32')]+'%'};return _0x21d17f;})});}_0x3f1599=_[_0x7475('0x4c')]({},_0x3f1599,_0x2e97d4[_0x7475('0x4e')]);return _0x16bc13[_0x7475('0x97')](_0x3f1599);}})['then'](function(_0x56d9b3){if(_0x56d9b3){_0x4e2428=_0x56d9b3['length'];if(!_0x2e97d4[_0x7475('0x42')][_0x7475('0x47')](_0x7475('0x48'))){_0x3f1599[_0x7475('0x24')]=qs[_0x7475('0x24')](_0x2e97d4[_0x7475('0x42')]['limit']);_0x3f1599[_0x7475('0x25')]=qs[_0x7475('0x25')](_0x2e97d4['query'][_0x7475('0x25')]);}return _0x16bc13[_0x7475('0x97')](_0x3f1599);}})[_0x7475('0x2d')](function(_0xf00160){if(_0xf00160){return _0xf00160?{'count':_0x4e2428,'rows':_0xf00160}:null;}})[_0x7475('0x2d')](respondWithResult(_0x3315ae,null))[_0x7475('0x52')](handleError(_0x3315ae,null));};exports[_0x7475('0x98')]=function(_0x1e8373,_0x4c1820,_0x4e7dc6){var _0x402969={};var _0x3066f9={};var _0x4b346d;var _0x3416ad;return db[_0x7475('0x3e')][_0x7475('0x66')]({'where':{'id':_0x1e8373['params']['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x4c1820,null))[_0x7475('0x2d')](function(_0x446c0b){if(_0x446c0b){_0x4b346d=_0x446c0b;_0x3066f9[_0x7475('0x41')]=_[_0x7475('0x43')](db[_0x7475('0x7b')][_0x7475('0x68')]);_0x3066f9[_0x7475('0x42')]=_[_0x7475('0x43')](_0x1e8373[_0x7475('0x42')]);_0x3066f9['filters']=_[_0x7475('0x45')](_0x3066f9[_0x7475('0x41')],_0x3066f9['query']);_0x402969[_0x7475('0x46')]=_[_0x7475('0x45')](_0x3066f9[_0x7475('0x41')],qs[_0x7475('0x54')](_0x1e8373[_0x7475('0x42')][_0x7475('0x54')]));_0x402969[_0x7475('0x46')]=_0x402969[_0x7475('0x46')]['length']?_0x402969[_0x7475('0x46')]:_0x3066f9[_0x7475('0x41')];_0x402969[_0x7475('0x49')]=qs['sort'](_0x1e8373['query'][_0x7475('0x4a')]);_0x402969[_0x7475('0x4b')]=qs['filters'](_[_0x7475('0x69')](_0x1e8373[_0x7475('0x42')],_0x3066f9[_0x7475('0x44')]));if(_0x1e8373[_0x7475('0x42')][_0x7475('0x32')]){_0x402969[_0x7475('0x4b')]=_[_0x7475('0x4c')](_0x402969[_0x7475('0x4b')],{'$or':_[_0x7475('0x34')](_0x402969['attributes'],function(_0x25dc71){var _0x12b484={};_0x12b484[_0x25dc71]={'$like':'%'+_0x1e8373[_0x7475('0x42')][_0x7475('0x32')]+'%'};return _0x12b484;})});}_0x402969=_['merge']({},_0x402969,_0x1e8373[_0x7475('0x4e')]);return _0x4b346d[_0x7475('0x98')](_0x402969);}})['then'](function(_0x12e5ef){if(_0x12e5ef){_0x3416ad=_0x12e5ef[_0x7475('0x6f')];if(!_0x1e8373[_0x7475('0x42')]['hasOwnProperty']('nolimit')){_0x402969[_0x7475('0x24')]=qs['limit'](_0x1e8373[_0x7475('0x42')]['limit']);_0x402969[_0x7475('0x25')]=qs['offset'](_0x1e8373[_0x7475('0x42')][_0x7475('0x25')]);}return _0x4b346d['getMembers'](_0x402969);}})[_0x7475('0x2d')](function(_0xa19a08){return _0xa19a08?{'count':_0x3416ad,'rows':_0xa19a08}:null;})[_0x7475('0x2d')](respondWithResult(_0x4c1820,null))[_0x7475('0x52')](handleError(_0x4c1820,null));};exports[_0x7475('0x99')]=function(_0x39fae9,_0x2cb0fa,_0x16336b){var _0x4c1fa6={};var _0x8cf006={};var _0x22d479;var _0x2acd7c;return db[_0x7475('0x3e')]['findOne']({'where':{'id':_0x39fae9[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x2cb0fa,null))[_0x7475('0x2d')](function(_0x384cd1){if(_0x384cd1){_0x22d479=_0x384cd1;_0x8cf006[_0x7475('0x41')]=_[_0x7475('0x43')](db[_0x7475('0x9a')][_0x7475('0x68')]);_0x8cf006[_0x7475('0x42')]=_[_0x7475('0x43')](_0x39fae9[_0x7475('0x42')]);_0x8cf006[_0x7475('0x44')]=_[_0x7475('0x45')](_0x8cf006[_0x7475('0x41')],_0x8cf006['query']);_0x4c1fa6[_0x7475('0x46')]=_[_0x7475('0x45')](_0x8cf006[_0x7475('0x41')],qs[_0x7475('0x54')](_0x39fae9['query'][_0x7475('0x54')]));_0x4c1fa6[_0x7475('0x46')]=_0x4c1fa6[_0x7475('0x46')][_0x7475('0x6f')]?_0x4c1fa6[_0x7475('0x46')]:_0x8cf006[_0x7475('0x41')];_0x4c1fa6[_0x7475('0x49')]=qs[_0x7475('0x4a')](_0x39fae9['query'][_0x7475('0x4a')]);_0x4c1fa6[_0x7475('0x4b')]=qs[_0x7475('0x44')](_[_0x7475('0x69')](_0x39fae9[_0x7475('0x42')],_0x8cf006['filters']));if(_0x39fae9[_0x7475('0x42')][_0x7475('0x32')]){_0x4c1fa6[_0x7475('0x4b')]=_[_0x7475('0x4c')](_0x4c1fa6[_0x7475('0x4b')],{'$or':_['map'](_0x4c1fa6[_0x7475('0x46')],function(_0x5c2d77){var _0x1c919f={};_0x1c919f[_0x5c2d77]={'$like':'%'+_0x39fae9['query']['filter']+'%'};return _0x1c919f;})});}_0x4c1fa6=_[_0x7475('0x4c')]({},_0x4c1fa6,_0x39fae9['options']);return _0x22d479[_0x7475('0x99')](_0x4c1fa6);}})['then'](function(_0xcd1d31){if(_0xcd1d31){_0x2acd7c=_0xcd1d31[_0x7475('0x6f')];if(!_0x39fae9['query'][_0x7475('0x47')]('nolimit')){_0x4c1fa6['limit']=qs[_0x7475('0x24')](_0x39fae9[_0x7475('0x42')][_0x7475('0x24')]);_0x4c1fa6[_0x7475('0x25')]=qs[_0x7475('0x25')](_0x39fae9['query'][_0x7475('0x25')]);}return _0x22d479['getLists'](_0x4c1fa6);}})[_0x7475('0x2d')](function(_0x3d003c){if(_0x3d003c){return _0x3d003c?{'count':_0x2acd7c,'rows':_0x3d003c}:null;}})['then'](respondWithResult(_0x2cb0fa,null))[_0x7475('0x52')](handleError(_0x2cb0fa,null));};exports[_0x7475('0x9b')]=function(_0x345fda,_0x877652,_0x5d5e0e){var _0x391325,_0x3a3a83;return db['VoiceQueue'][_0x7475('0x37')]({'where':{'id':_0x345fda[_0x7475('0x5e')]['id']}})['then'](handleEntityNotFound(_0x877652,null))[_0x7475('0x2d')](function(_0x53e086){if(_0x53e086){_0x3a3a83=_0x53e086;return _0x53e086['addLists'](_0x345fda[_0x7475('0x61')][_0x7475('0x81')],_[_0x7475('0x62')](_0x345fda['body'],[_0x7475('0x81'),'id'])||{});}return null;})[_0x7475('0x92')](function(_0x291719){var _0x17226b;_0x391325=_0x291719||[];var _0x261cb8=[];if(_0x291719){for(var _0x3b767c=0x0;_0x3b767c<_0x291719[_0x7475('0x6f')];_0x3b767c+=0x1){var _0x270901=_0x291719[_0x3b767c]['get']({'plain':!![]});_0x3a3a83['dialCheckDuplicateType']=_0x345fda[_0x7475('0x61')][_0x7475('0x9c')]?_0x345fda[_0x7475('0x61')][_0x7475('0x9c')]:_0x3a3a83[_0x7475('0x9c')];switch(_0x3a3a83[_0x7475('0x9c')]){case'always':_0x17226b=squel[_0x7475('0x9d')]()[_0x7475('0x9e')](_0x7475('0x9f'))['fromQuery'](['phone',_0x7475('0xa0'),'ContactId',_0x7475('0xa1'),'VoiceQueueId',_0x7475('0x5f'),'updatedAt'],squel['select']()[_0x7475('0x82')](_0x7475('0xa2'),_0x7475('0xa2'))['field'](_0x7475('0xa3'),_0x7475('0xa0'))[_0x7475('0x82')]('id',_0x7475('0xa4'))[_0x7475('0x82')](_0x270901[_0x7475('0xa5')][_0x7475('0x88')](),_0x7475('0xa1'))['field'](_0x345fda[_0x7475('0x5e')]['id'][_0x7475('0x88')](),_0x7475('0x6a'))[_0x7475('0x82')]('NOW()',_0x7475('0x5f'))['field']('NOW()',_0x7475('0x60'))[_0x7475('0x83')](_0x7475('0xa6'))[_0x7475('0x4b')](_0x7475('0xa7'))[_0x7475('0x4b')]('ListId\x20=\x20?',_0x270901[_0x7475('0xa5')]['toString']())['where'](_0x7475('0xa8'))['where']('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x7475('0x82')](_0x7475('0xa9'))[_0x7475('0x83')](_0x7475('0xaa'))[_0x7475('0x4b')](_0x7475('0xab'),_0x345fda[_0x7475('0x5e')]['id'][_0x7475('0x88')]()))[_0x7475('0x4b')](_0x7475('0xac'),squel['select']()[_0x7475('0x82')](_0x7475('0xad'))[_0x7475('0x83')](_0x7475('0x9f'))[_0x7475('0x4b')]('VoiceQueueId\x20=\x20?',_0x345fda['params']['id'][_0x7475('0x88')]())))[_0x7475('0x88')]();break;case _0x7475('0xae'):_0x17226b=squel[_0x7475('0x9d')]()[_0x7475('0x9e')](_0x7475('0x9f'))[_0x7475('0xaf')]([_0x7475('0xa2'),_0x7475('0xa0'),'ContactId',_0x7475('0xa1'),_0x7475('0x6a'),'createdAt','updatedAt'],squel[_0x7475('0xb0')]()[_0x7475('0x82')](_0x7475('0xa2'),'phone')[_0x7475('0x82')]('NOW()',_0x7475('0xa0'))['field']('id',_0x7475('0xa4'))['field'](_0x270901[_0x7475('0xa5')][_0x7475('0x88')](),_0x7475('0xa1'))[_0x7475('0x82')](_0x345fda['params']['id'][_0x7475('0x88')](),_0x7475('0x6a'))[_0x7475('0x82')]('NOW()',_0x7475('0x5f'))['field'](_0x7475('0xa3'),_0x7475('0x60'))['from'](_0x7475('0xa6'))[_0x7475('0x4b')]('deletedAt\x20IS\x20NULL')[_0x7475('0x4b')](_0x7475('0xb1'),_0x270901[_0x7475('0xa5')][_0x7475('0x88')]())[_0x7475('0x4b')](_0x7475('0xa8'))[_0x7475('0x4b')](_0x7475('0xac'),squel[_0x7475('0xb0')]()[_0x7475('0x82')](_0x7475('0xad'))['from'](_0x7475('0x9f'))['where'](_0x7475('0xab'),_0x345fda[_0x7475('0x5e')]['id']['toString']())))[_0x7475('0x88')]();break;default:_0x17226b=squel[_0x7475('0x9d')]()[_0x7475('0x9e')]('cm_hopper')[_0x7475('0xaf')](['phone',_0x7475('0xa0'),_0x7475('0xa4'),'ListId','VoiceQueueId',_0x7475('0x5f'),'updatedAt'],squel[_0x7475('0xb0')]()[_0x7475('0x82')](_0x7475('0xa2'),_0x7475('0xa2'))[_0x7475('0x82')]('NOW()',_0x7475('0xa0'))[_0x7475('0x82')]('id',_0x7475('0xa4'))[_0x7475('0x82')](_0x270901[_0x7475('0xa5')][_0x7475('0x88')](),_0x7475('0xa1'))['field'](_0x345fda[_0x7475('0x5e')]['id'][_0x7475('0x88')](),_0x7475('0x6a'))['field'](_0x7475('0xa3'),_0x7475('0x5f'))[_0x7475('0x82')](_0x7475('0xa3'),_0x7475('0x60'))[_0x7475('0x83')](_0x7475('0xa6'))[_0x7475('0x4b')](_0x7475('0xa7'))['where'](_0x7475('0xb1'),_0x270901[_0x7475('0xa5')]['toString']())[_0x7475('0x4b')]('phone\x20IS\x20NOT\x20NULL'))['toString']();}_0x261cb8['push'](db[_0x7475('0x8d')][_0x7475('0x42')](_0x17226b));}return BPromise[_0x7475('0x8c')](_0x261cb8);}})[_0x7475('0x2d')](function(){return _0x391325;})['then'](respondWithResult(_0x877652,null))[_0x7475('0x52')](handleError(_0x877652,null));};exports['removeLists']=function(_0x4c84f9,_0x2d9dd6,_0x4ea087){return db[_0x7475('0x3e')][_0x7475('0x37')]({'where':{'id':_0x4c84f9[_0x7475('0x5e')]['id']}})['then'](handleEntityNotFound(_0x2d9dd6,null))[_0x7475('0x2d')](function(_0x4e76c2){if(_0x4e76c2){return _0x4e76c2[_0x7475('0xb2')](_0x4c84f9[_0x7475('0x42')][_0x7475('0x81')]);}})[_0x7475('0x2d')](function(_0x22b853){if(_0x22b853){return db['CmHopper'][_0x7475('0x2e')]({'where':{'ListId':_0x4c84f9[_0x7475('0x42')]['ids'],'VoiceQueueId':_0x4c84f9[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](function(){return _0x22b853;});}})[_0x7475('0x2d')](respondWithStatusCode(_0x2d9dd6,null))[_0x7475('0x52')](handleError(_0x2d9dd6,null));};exports[_0x7475('0xb3')]=function(_0x369f9f,_0x5354a4,_0x177cc8){var _0x144acc={};var _0x5213d4={};var _0x3408c0;var _0x17db9e;return db[_0x7475('0x3e')][_0x7475('0x66')]({'where':{'id':_0x369f9f[_0x7475('0x5e')]['id']}})['then'](handleEntityNotFound(_0x5354a4,null))[_0x7475('0x2d')](function(_0x27a701){if(_0x27a701){_0x3408c0=_0x27a701;_0x5213d4['model']=_[_0x7475('0x43')](db[_0x7475('0x9a')][_0x7475('0x68')]);_0x5213d4[_0x7475('0x42')]=_[_0x7475('0x43')](_0x369f9f[_0x7475('0x42')]);_0x5213d4['filters']=_[_0x7475('0x45')](_0x5213d4['model'],_0x5213d4['query']);_0x144acc[_0x7475('0x46')]=_['intersection'](_0x5213d4[_0x7475('0x41')],qs[_0x7475('0x54')](_0x369f9f[_0x7475('0x42')][_0x7475('0x54')]));_0x144acc['attributes']=_0x144acc[_0x7475('0x46')][_0x7475('0x6f')]?_0x144acc[_0x7475('0x46')]:_0x5213d4['model'];_0x144acc[_0x7475('0x49')]=qs['sort'](_0x369f9f[_0x7475('0x42')]['sort']);_0x144acc[_0x7475('0x4b')]=qs[_0x7475('0x44')](_[_0x7475('0x69')](_0x369f9f[_0x7475('0x42')],_0x5213d4[_0x7475('0x44')]));if(_0x369f9f[_0x7475('0x42')][_0x7475('0x32')]){_0x144acc[_0x7475('0x4b')]=_[_0x7475('0x4c')](_0x144acc['where'],{'$or':_[_0x7475('0x34')](_0x144acc['attributes'],function(_0x3ece0b){var _0x42e6c8={};_0x42e6c8[_0x3ece0b]={'$like':'%'+_0x369f9f[_0x7475('0x42')][_0x7475('0x32')]+'%'};return _0x42e6c8;})});}_0x144acc=_['merge']({},_0x144acc,_0x369f9f[_0x7475('0x4e')]);return _0x3408c0[_0x7475('0xb3')](_0x144acc);}})[_0x7475('0x2d')](function(_0x24d499){if(_0x24d499){_0x17db9e=_0x24d499['length'];if(!_0x369f9f['query'][_0x7475('0x47')](_0x7475('0x48'))){_0x144acc[_0x7475('0x24')]=qs['limit'](_0x369f9f[_0x7475('0x42')][_0x7475('0x24')]);_0x144acc[_0x7475('0x25')]=qs['offset'](_0x369f9f[_0x7475('0x42')][_0x7475('0x25')]);}return _0x3408c0['getBlackLists'](_0x144acc);}})[_0x7475('0x2d')](function(_0x3ea69c){if(_0x3ea69c){return _0x3ea69c?{'count':_0x17db9e,'rows':_0x3ea69c}:null;}})[_0x7475('0x2d')](respondWithResult(_0x5354a4,null))['catch'](handleError(_0x5354a4,null));};exports['addBlackLists']=function(_0x480931,_0x5e131d,_0x18fcd1){var _0xb506fc,_0x5aba46;return db[_0x7475('0x3e')]['find']({'where':{'id':_0x480931[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x5e131d,null))[_0x7475('0x2d')](function(_0x12512e){if(_0x12512e){_0x5aba46=_0x12512e;return _0x12512e['addBlackLists'](_0x480931[_0x7475('0x61')][_0x7475('0x81')],_[_0x7475('0x62')](_0x480931['body'],[_0x7475('0x81'),'id'])||{});}return null;})[_0x7475('0x92')](function(_0x15e19e){var _0xfc9d9c;_0xb506fc=_0x15e19e||[];var _0x3df6a=[];if(_0x15e19e){for(var _0x28cffe=0x0;_0x28cffe<_0x15e19e[_0x7475('0x6f')];_0x28cffe+=0x1){var _0x5ecd0e=_0x15e19e[_0x28cffe][_0x7475('0x2f')]({'plain':!![]});_0xfc9d9c=squel['insert']()[_0x7475('0x9e')](_0x7475('0xb4'))[_0x7475('0xaf')](['phone',_0x7475('0xa4'),_0x7475('0xa1'),_0x7475('0x6a'),_0x7475('0x5f'),_0x7475('0x60')],squel[_0x7475('0xb0')]()['field'](_0x7475('0xa2'),'phone')[_0x7475('0x82')]('id',_0x7475('0xa4'))[_0x7475('0x82')](_0x5ecd0e[_0x7475('0xa5')]['toString'](),_0x7475('0xa1'))[_0x7475('0x82')](_0x480931[_0x7475('0x5e')]['id'][_0x7475('0x88')](),_0x7475('0x6a'))[_0x7475('0x82')](_0x7475('0xa3'),_0x7475('0x5f'))[_0x7475('0x82')]('NOW()',_0x7475('0x60'))['from'](_0x7475('0xa6'))[_0x7475('0x4b')](_0x7475('0xa7'))['where'](_0x7475('0xb1'),_0x5ecd0e[_0x7475('0xa5')][_0x7475('0x88')]())[_0x7475('0x4b')](_0x7475('0xa8')))[_0x7475('0x88')]();_0x3df6a[_0x7475('0x87')](db[_0x7475('0x8d')]['query'](_0xfc9d9c));}return BPromise[_0x7475('0x8c')](_0x3df6a);}})[_0x7475('0x2d')](function(){return _0xb506fc;})[_0x7475('0x2d')](respondWithResult(_0x5e131d,null))['catch'](handleError(_0x5e131d,null));};exports[_0x7475('0xb5')]=function(_0x5b6276,_0x3c63c5,_0x14544a){return db[_0x7475('0x3e')][_0x7475('0x37')]({'where':{'id':_0x5b6276[_0x7475('0x5e')]['id']}})[_0x7475('0x2d')](handleEntityNotFound(_0x3c63c5,null))[_0x7475('0x2d')](function(_0x4e7fbb){if(_0x4e7fbb){return _0x4e7fbb[_0x7475('0xb5')](_0x5b6276[_0x7475('0x42')][_0x7475('0x81')]);}})[_0x7475('0x2d')](function(_0x5599df){if(_0x5599df){return db[_0x7475('0x6e')]['destroy']({'where':{'ListId':_0x5b6276[_0x7475('0x42')][_0x7475('0x81')],'VoiceQueueId':_0x5b6276[_0x7475('0x5e')]['id']}})['then'](function(){return _0x5599df;});}})[_0x7475('0x2d')](respondWithStatusCode(_0x3c63c5,null))[_0x7475('0x52')](handleError(_0x3c63c5,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff