// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x486d=['save','update','then','destroy','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','value','type','find','name','stack','send','index','map','VoiceQueue','rawAttributes','model','query','keys','filters','intersection','attributes','fields','nolimit','order','sort','where','pick','merge','includeAll','include','findAll','rows','show','params','length','options','create','body','user','role','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','catch','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','getHoppers','findOne','CmHopper','hasOwnProperty','VoiceQueueId','getHopperHistories','CmHopperHistory','CmHopperFinal','getHopperBlacks','CmHopperBlack','Team','getTeams','addTeams','teams','User','Agents','online','flatMap','forEach','penalty','sequelize','transaction','each','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','upsert','isNil','format','interface','voicePause','emit','userVoiceQueue:save','removeTeams','ids','select','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','VoiceQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','QueryTypes','every','all','union','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','SIP/%s','isArray','getAgents','getLists','addLists','spread','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','scheduledAt','ContactId','ListId','field','NOW()','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','COALESCE(phone,\x27\x27)','onlyIfOpen','phone','cm_contacts','removeLists','getBlackLists','CmList','addBlackLists','removeBlackLists','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','path','sox','to-csv','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../config/license/hardware','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','register','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x486d,0x140));var _0xd486=function(_0x244d28,_0x2856b2){_0x244d28=_0x244d28-0x0;var _0x35dc8a=_0x486d[_0x244d28];return _0x35dc8a;};'use strict';var pdf=require(_0xd486('0x0'));var emlformat=require(_0xd486('0x1'));var rimraf=require(_0xd486('0x2'));var zipdir=require(_0xd486('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0xd486('0x4'));var moment=require(_0xd486('0x5'));var BPromise=require(_0xd486('0x6'));var Mustache=require('mustache');var util=require('util');var path=require(_0xd486('0x7'));var sox=require(_0xd486('0x8'));var csv=require(_0xd486('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xd486('0xa'));var squel=require(_0xd486('0xb'));var crypto=require(_0xd486('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xd486('0xd'));var toCsv=require(_0xd486('0x9'));var querystring=require(_0xd486('0xe'));var Papa=require(_0xd486('0xf'));var Redis=require(_0xd486('0x10'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xd486('0x11'));var logger=require('../../config/logger')('api');var utils=require(_0xd486('0x12'));var config=require(_0xd486('0x13'));var licenseUtil=require(_0xd486('0x14'));var db=require(_0xd486('0x15'))['db'];config[_0xd486('0x16')]=_[_0xd486('0x17')](config[_0xd486('0x16')],{'host':_0xd486('0x18'),'port':0x18eb});var socket=require(_0xd486('0x19'))(new Redis(config[_0xd486('0x16')]));require(_0xd486('0x1a'))[_0xd486('0x1b')](socket);function respondWithStatusCode(_0x1ee2fb,_0x46eb17){_0x46eb17=_0x46eb17||0xcc;return function(_0xd1ace9){if(_0xd1ace9){return _0x1ee2fb[_0xd486('0x1c')](_0x46eb17);}return _0x1ee2fb[_0xd486('0x1d')](_0x46eb17)[_0xd486('0x1e')]();};}function respondWithResult(_0x12fd98,_0x3bd13e){_0x3bd13e=_0x3bd13e||0xc8;return function(_0x288a0e){if(_0x288a0e){return _0x12fd98[_0xd486('0x1d')](_0x3bd13e)[_0xd486('0x1f')](_0x288a0e);}};}function respondWithFilteredResult(_0x2ce1ba,_0x115ee7){return function(_0x19b143){if(_0x19b143){var _0xac053=_0x19b143[_0xd486('0x20')],_0x2d5b50=_0x115ee7[_0xd486('0x21')],_0x179d45=_0x115ee7[_0xd486('0x21')]+_0x115ee7[_0xd486('0x22')],_0x32e265;if(_0x179d45>=_0xac053){_0x179d45=_0xac053;_0x32e265=0xc8;}else{_0x32e265=0xce;}_0x2ce1ba[_0xd486('0x1d')](_0x32e265);return _0x2ce1ba['set'](_0xd486('0x23'),_0x2d5b50+'-'+_0x179d45+'/'+_0xac053)[_0xd486('0x1f')](_0x19b143);}return null;};}function patchUpdates(_0x406287){return function(_0x3a7a68){try{jsonpatch[_0xd486('0x24')](_0x3a7a68,_0x406287,!![]);}catch(_0x579580){return BPromise[_0xd486('0x25')](_0x579580);}return _0x3a7a68[_0xd486('0x26')]();};}function saveUpdates(_0x8e636,_0x57cb80){return function(_0x4346dd){if(_0x4346dd){return _0x4346dd[_0xd486('0x27')](_0x8e636)[_0xd486('0x28')](function(_0x1d9a19){return _0x1d9a19;});}return null;};}function removeEntity(_0x571d6c,_0x19cf1b){return function(_0x233fff){if(_0x233fff){return _0x233fff[_0xd486('0x29')]()[_0xd486('0x28')](function(){var _0x5ab435=_0x233fff[_0xd486('0x2a')]({'plain':!![]});var _0x493fdd=[{'name':_0xd486('0x2b'),'value':_0xd486('0x2c'),'ignore':![]},{'name':_0xd486('0x2d'),'value':_0xd486('0x2e'),'ignore':![]}];var _0x6bda15=_(_0x493fdd)[_0xd486('0x2f')](_0xd486('0x30'))['map']('value')[_0xd486('0x31')]();if(_['includes'](_0x6bda15,_0x5ab435[_0xd486('0x32')])){return;}var _0x2bd0df=_[_0xd486('0x33')](_0x493fdd,[_0xd486('0x31'),_0x5ab435[_0xd486('0x32')]])[_0xd486('0x34')];return db['UserProfileResource'][_0xd486('0x29')]({'where':{'type':_0x2bd0df,'resourceId':_0x5ab435['id']}})['then'](function(){return _0x233fff;});})[_0xd486('0x28')](function(){_0x571d6c[_0xd486('0x1d')](0xcc)[_0xd486('0x1e')]();});}};}function handleEntityNotFound(_0x3eb626,_0x414fe3){return function(_0x226fd7){if(!_0x226fd7){_0x3eb626['sendStatus'](0x194);}return _0x226fd7;};}function handleError(_0x29499e,_0x504429){_0x504429=_0x504429||0x1f4;return function(_0x2a8f16){logger['error'](_0x2a8f16[_0xd486('0x35')]);if(_0x2a8f16[_0xd486('0x34')]){delete _0x2a8f16[_0xd486('0x34')];}_0x29499e[_0xd486('0x1d')](_0x504429)[_0xd486('0x36')](_0x2a8f16);};}exports[_0xd486('0x37')]=function(_0x5ac055,_0x5cfaf4){var _0x2b1adc={},_0x5afc5c={},_0x342065={'count':0x0,'rows':[]};var _0xe403ec=_[_0xd486('0x38')](db[_0xd486('0x39')][_0xd486('0x3a')],function(_0x7cd29a){return{'name':_0x7cd29a['fieldName'],'type':_0x7cd29a['type']['key']};});_0x5afc5c[_0xd486('0x3b')]=_['map'](_0xe403ec,_0xd486('0x34'));_0x5afc5c[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x5ac055[_0xd486('0x3c')]);_0x5afc5c[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x5afc5c[_0xd486('0x3b')],_0x5afc5c[_0xd486('0x3c')]);_0x2b1adc[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x5afc5c[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x5ac055[_0xd486('0x3c')][_0xd486('0x41')]));_0x2b1adc[_0xd486('0x40')]=_0x2b1adc[_0xd486('0x40')]['length']?_0x2b1adc['attributes']:_0x5afc5c['model'];if(!_0x5ac055[_0xd486('0x3c')]['hasOwnProperty'](_0xd486('0x42'))){_0x2b1adc['limit']=qs[_0xd486('0x22')](_0x5ac055[_0xd486('0x3c')][_0xd486('0x22')]);_0x2b1adc[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x5ac055[_0xd486('0x3c')][_0xd486('0x21')]);}_0x2b1adc[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x5ac055[_0xd486('0x3c')]['sort']);_0x2b1adc[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x5ac055['query'],_0x5afc5c[_0xd486('0x3e')]),_0xe403ec);if(_0x5ac055[_0xd486('0x3c')][_0xd486('0x2f')]){_0x2b1adc['where']=_[_0xd486('0x47')](_0x2b1adc[_0xd486('0x45')],{'$or':_['map'](_0xe403ec,function(_0x243fc6){if(_0x243fc6[_0xd486('0x32')]!=='VIRTUAL'){var _0x5867bb={};_0x5867bb[_0x243fc6[_0xd486('0x34')]]={'$like':'%'+_0x5ac055['query'][_0xd486('0x2f')]+'%'};return _0x5867bb;}})});}_0x2b1adc=_[_0xd486('0x47')]({},_0x2b1adc,_0x5ac055['options']);var _0x16b8be={'where':_0x2b1adc[_0xd486('0x45')]};return db[_0xd486('0x39')][_0xd486('0x20')](_0x16b8be)[_0xd486('0x28')](function(_0x3a66a3){_0x342065[_0xd486('0x20')]=_0x3a66a3;if(_0x5ac055['query'][_0xd486('0x48')]){_0x2b1adc[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x39')][_0xd486('0x4a')](_0x2b1adc);})[_0xd486('0x28')](function(_0x5791e4){_0x342065[_0xd486('0x4b')]=_0x5791e4;return _0x342065;})['then'](respondWithFilteredResult(_0x5cfaf4,_0x2b1adc))['catch'](handleError(_0x5cfaf4,null));};exports[_0xd486('0x4c')]=function(_0x16f1ac,_0x51c7bb){var _0x131f0f={'raw':![],'where':{'id':_0x16f1ac[_0xd486('0x4d')]['id']}},_0x5daf56={};_0x5daf56['model']=_['keys'](db[_0xd486('0x39')][_0xd486('0x3a')]);_0x5daf56[_0xd486('0x3c')]=_['keys'](_0x16f1ac[_0xd486('0x3c')]);_0x5daf56['filters']=_[_0xd486('0x3f')](_0x5daf56[_0xd486('0x3b')],_0x5daf56['query']);_0x131f0f['attributes']=_['intersection'](_0x5daf56['model'],qs[_0xd486('0x41')](_0x16f1ac['query']['fields']));_0x131f0f['attributes']=_0x131f0f['attributes'][_0xd486('0x4e')]?_0x131f0f[_0xd486('0x40')]:_0x5daf56[_0xd486('0x3b')];if(_0x16f1ac[_0xd486('0x3c')]['includeAll']){_0x131f0f[_0xd486('0x49')]=[{'all':!![]}];}_0x131f0f=_[_0xd486('0x47')]({},_0x131f0f,_0x16f1ac[_0xd486('0x4f')]);return db[_0xd486('0x39')][_0xd486('0x33')](_0x131f0f)[_0xd486('0x28')](handleEntityNotFound(_0x51c7bb,null))[_0xd486('0x28')](respondWithResult(_0x51c7bb,null))['catch'](handleError(_0x51c7bb,null));};exports[_0xd486('0x50')]=function(_0x2ab0ad,_0x40fea5){return db[_0xd486('0x39')]['create'](_0x2ab0ad[_0xd486('0x51')],{})[_0xd486('0x28')](function(_0xa3b09b){var _0x85e6ad=_0x2ab0ad[_0xd486('0x52')]['get']({'plain':!![]});if(!_0x85e6ad)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x85e6ad[_0xd486('0x53')]===_0xd486('0x52')){var _0x563228=_0xa3b09b[_0xd486('0x2a')]({'plain':!![]});var _0x450ea2=[{'name':_0xd486('0x2b'),'value':_0xd486('0x2c')},{'name':_0xd486('0x2d'),'value':_0xd486('0x2e')}];var _0x19832c=_[_0xd486('0x33')](_0x450ea2,['value',_0x563228[_0xd486('0x32')]])[_0xd486('0x34')];return db[_0xd486('0x54')][_0xd486('0x33')]({'where':{'name':_0x19832c,'userProfileId':_0x85e6ad[_0xd486('0x55')]},'raw':!![]})[_0xd486('0x28')](function(_0x2c817a){if(_0x2c817a&&_0x2c817a[_0xd486('0x56')]===0x0){return db[_0xd486('0x57')][_0xd486('0x50')]({'name':_0x563228[_0xd486('0x34')],'resourceId':_0x563228['id'],'type':_0x2c817a['name'],'sectionId':_0x2c817a['id']},{})['then'](function(){return _0xa3b09b;});}else{return _0xa3b09b;}})[_0xd486('0x58')](function(_0x2a77b8){logger[_0xd486('0x59')](_0xd486('0x5a'),_0x2a77b8);throw _0x2a77b8;});}return _0xa3b09b;})[_0xd486('0x28')](respondWithResult(_0x40fea5,0xc9))[_0xd486('0x58')](handleError(_0x40fea5,null));};exports['clone']=function(_0x4ee7a4,_0x2bca08){var _0x23b76f={'where':{'id':_0x4ee7a4['params']['id']}},_0x50b03e={};_0x50b03e[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0x39')][_0xd486('0x3a')]);_0x23b76f[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x50b03e[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x4ee7a4[_0xd486('0x3c')][_0xd486('0x41')]));_0x23b76f[_0xd486('0x40')]=_0x23b76f[_0xd486('0x40')][_0xd486('0x4e')]?_0x23b76f[_0xd486('0x40')]:_0x50b03e[_0xd486('0x3b')];if(_0x4ee7a4[_0xd486('0x3c')][_0xd486('0x48')]){_0x23b76f[_0xd486('0x49')]=[{'all':!![]}];}_0x23b76f=_[_0xd486('0x47')]({},_0x23b76f,_0x4ee7a4[_0xd486('0x4f')]);return db[_0xd486('0x39')][_0xd486('0x33')](_0x23b76f)[_0xd486('0x28')](handleEntityNotFound(_0x2bca08,null))[_0xd486('0x28')](function(_0x15a858){if(_0x15a858){var _0x251068=_0x15a858[_0xd486('0x2a')]({'plain':!![]});_0x251068=qs[_0xd486('0x5b')](_0x251068,['id',_0xd486('0x5c'),_0xd486('0x5d')]);_0x4ee7a4[_0xd486('0x51')]=_['omit'](_0x4ee7a4[_0xd486('0x51')],['id',_0xd486('0x5c'),_0xd486('0x5d')]);return db[_0xd486('0x39')][_0xd486('0x50')](_[_0xd486('0x47')](_0x251068,_0x4ee7a4[_0xd486('0x51')]),{'include':_0x4ee7a4[_0xd486('0x3c')][_0xd486('0x48')]?[{'all':!![]}]:undefined})[_0xd486('0x28')](function(_0x28fc4e){var _0x1e171c=_0x4ee7a4[_0xd486('0x52')]['get']({'plain':!![]});if(!_0x1e171c)throw new Error(_0xd486('0x5e'));if(_0x1e171c[_0xd486('0x53')]==='user'){var _0x3b7348=_0x28fc4e[_0xd486('0x2a')]({'plain':!![]});var _0x4c3cd1=[{'name':'VoiceQueues','value':'inbound'},{'name':'QueueCampaigns','value':_0xd486('0x2e')}];var _0x5456d5=_[_0xd486('0x33')](_0x4c3cd1,[_0xd486('0x31'),_0x3b7348[_0xd486('0x32')]])['name'];return db[_0xd486('0x54')][_0xd486('0x33')]({'where':{'name':_0x5456d5,'userProfileId':_0x1e171c['userProfileId']},'raw':!![]})[_0xd486('0x28')](function(_0x1e9c91){if(_0x1e9c91&&_0x1e9c91['autoAssociation']===0x0){return db[_0xd486('0x57')][_0xd486('0x50')]({'name':_0x3b7348[_0xd486('0x34')],'resourceId':_0x3b7348['id'],'type':_0x1e9c91['name'],'sectionId':_0x1e9c91['id']},{})[_0xd486('0x28')](function(){return _0x28fc4e;});}else{return _0x28fc4e;}})[_0xd486('0x58')](function(_0x43a24e){logger['error'](_0xd486('0x5a'),_0x43a24e);throw _0x43a24e;});}return _0x28fc4e;});}})['then'](respondWithResult(_0x2bca08,0xc9))[_0xd486('0x58')](handleError(_0x2bca08,null));};exports[_0xd486('0x27')]=function(_0x482155,_0x129353){if(_0x482155[_0xd486('0x51')]['id']){delete _0x482155[_0xd486('0x51')]['id'];}return db['VoiceQueue']['find']({'where':{'id':_0x482155['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x129353,null))['then'](saveUpdates(_0x482155[_0xd486('0x51')],null))['then'](respondWithResult(_0x129353,null))[_0xd486('0x58')](handleError(_0x129353,null));};exports[_0xd486('0x29')]=function(_0x44fc33,_0x2f9e55){return db[_0xd486('0x39')]['find']({'where':{'id':_0x44fc33[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x2f9e55,null))['then'](removeEntity(_0x2f9e55,null))[_0xd486('0x58')](handleError(_0x2f9e55,null));};exports[_0xd486('0x5f')]=function(_0x2bd391,_0x3ebdc9,_0x59e5f4){var _0x45ca2c={'raw':![],'where':{}};var _0x1bf7d8={};var _0x4f6c05={'count':0x0,'rows':[]};return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x2bd391[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x3ebdc9,null))['then'](function(_0x4ec9a6){if(_0x4ec9a6){_0x1bf7d8[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0x61')][_0xd486('0x3a')]);_0x1bf7d8[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x2bd391[_0xd486('0x3c')]);_0x1bf7d8[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x1bf7d8[_0xd486('0x3b')],_0x1bf7d8[_0xd486('0x3c')]);_0x45ca2c[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x1bf7d8[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x2bd391[_0xd486('0x3c')][_0xd486('0x41')]));_0x45ca2c[_0xd486('0x40')]=_0x45ca2c[_0xd486('0x40')][_0xd486('0x4e')]?_0x45ca2c[_0xd486('0x40')]:_0x1bf7d8['model'];if(!_0x2bd391[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x45ca2c[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x2bd391[_0xd486('0x3c')][_0xd486('0x22')]);_0x45ca2c[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x2bd391[_0xd486('0x3c')]['offset']);}_0x45ca2c['order']=qs[_0xd486('0x44')](_0x2bd391['query'][_0xd486('0x44')]);_0x45ca2c[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x2bd391['query'],_0x1bf7d8[_0xd486('0x3e')]));_0x45ca2c[_0xd486('0x45')][_0xd486('0x63')]=_0x4ec9a6['id'];if(_0x2bd391['query'][_0xd486('0x2f')]){_0x45ca2c['where']=_[_0xd486('0x47')](_0x45ca2c[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0x45ca2c[_0xd486('0x40')],function(_0x2643b4){var _0x329a29={};_0x329a29[_0x2643b4]={'$like':'%'+_0x2bd391['query'][_0xd486('0x2f')]+'%'};return _0x329a29;})});}_0x45ca2c=_[_0xd486('0x47')]({},_0x45ca2c,_0x2bd391[_0xd486('0x4f')]);return db[_0xd486('0x61')][_0xd486('0x20')]({'where':_0x45ca2c['where']})[_0xd486('0x28')](function(_0x1f4c25){_0x4f6c05['count']=_0x1f4c25;if(_0x2bd391[_0xd486('0x3c')]['includeAll']){_0x45ca2c[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x61')][_0xd486('0x4a')](_0x45ca2c);})['then'](function(_0x581237){_0x4f6c05['rows']=_0x581237;return _0x4f6c05;});}})[_0xd486('0x28')](respondWithFilteredResult(_0x3ebdc9,_0x45ca2c))['catch'](handleError(_0x3ebdc9,null));};exports[_0xd486('0x64')]=function(_0x5abcf7,_0x10fa12,_0x2e97a2){var _0x12fc3d={'raw':!![],'where':{}};var _0x47fd23={};var _0x164ee9={'count':0x0,'rows':[]};return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x5abcf7['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x10fa12,null))['then'](function(_0x5a56f8){if(_0x5a56f8){_0x47fd23['model']=_[_0xd486('0x3d')](db[_0xd486('0x65')][_0xd486('0x3a')]);_0x47fd23[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x5abcf7['query']);_0x47fd23['filters']=_[_0xd486('0x3f')](_0x47fd23[_0xd486('0x3b')],_0x47fd23[_0xd486('0x3c')]);_0x12fc3d[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x47fd23[_0xd486('0x3b')],qs['fields'](_0x5abcf7['query']['fields']));_0x12fc3d[_0xd486('0x40')]=_0x12fc3d[_0xd486('0x40')][_0xd486('0x4e')]?_0x12fc3d[_0xd486('0x40')]:_0x47fd23[_0xd486('0x3b')];if(!_0x5abcf7[_0xd486('0x3c')]['hasOwnProperty']('nolimit')){_0x12fc3d[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x5abcf7[_0xd486('0x3c')][_0xd486('0x22')]);_0x12fc3d[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x5abcf7[_0xd486('0x3c')][_0xd486('0x21')]);}_0x12fc3d[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x5abcf7[_0xd486('0x3c')]['sort']);_0x12fc3d[_0xd486('0x45')]=qs['filters'](_[_0xd486('0x46')](_0x5abcf7[_0xd486('0x3c')],_0x47fd23[_0xd486('0x3e')]));_0x12fc3d[_0xd486('0x45')][_0xd486('0x63')]=_0x5a56f8['id'];if(_0x5abcf7['query'][_0xd486('0x2f')]){_0x12fc3d[_0xd486('0x45')]=_['merge'](_0x12fc3d[_0xd486('0x45')],{'$or':_['map'](_0x12fc3d[_0xd486('0x40')],function(_0x5f084c){var _0x35eb70={};_0x35eb70[_0x5f084c]={'$like':'%'+_0x5abcf7[_0xd486('0x3c')]['filter']+'%'};return _0x35eb70;})});}_0x12fc3d=_[_0xd486('0x47')]({},_0x12fc3d,_0x5abcf7[_0xd486('0x4f')]);return db[_0xd486('0x65')][_0xd486('0x20')]({'where':_0x12fc3d[_0xd486('0x45')]})['then'](function(_0x306e43){_0x164ee9[_0xd486('0x20')]=_0x306e43;if(_0x5abcf7[_0xd486('0x3c')][_0xd486('0x48')]){_0x12fc3d[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x65')][_0xd486('0x4a')](_0x12fc3d);})['then'](function(_0x238453){_0x164ee9[_0xd486('0x4b')]=_0x238453;return _0x164ee9;});}})[_0xd486('0x28')](respondWithFilteredResult(_0x10fa12,_0x12fc3d))[_0xd486('0x58')](handleError(_0x10fa12,null));};exports['getHopperFinals']=function(_0x4add22,_0x772832,_0x55df3f){var _0xdc3e88={'raw':!![],'where':{}};var _0xc23eb2={};var _0x50f64a={'count':0x0,'rows':[]};return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x4add22[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x772832,null))[_0xd486('0x28')](function(_0x3b026b){if(_0x3b026b){_0xc23eb2[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0x66')][_0xd486('0x3a')]);_0xc23eb2['query']=_[_0xd486('0x3d')](_0x4add22[_0xd486('0x3c')]);_0xc23eb2['filters']=_[_0xd486('0x3f')](_0xc23eb2[_0xd486('0x3b')],_0xc23eb2['query']);_0xdc3e88[_0xd486('0x40')]=_[_0xd486('0x3f')](_0xc23eb2[_0xd486('0x3b')],qs['fields'](_0x4add22[_0xd486('0x3c')]['fields']));_0xdc3e88[_0xd486('0x40')]=_0xdc3e88['attributes'][_0xd486('0x4e')]?_0xdc3e88['attributes']:_0xc23eb2[_0xd486('0x3b')];if(!_0x4add22[_0xd486('0x3c')][_0xd486('0x62')]('nolimit')){_0xdc3e88[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x4add22['query'][_0xd486('0x22')]);_0xdc3e88[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x4add22['query'][_0xd486('0x21')]);}_0xdc3e88[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x4add22[_0xd486('0x3c')][_0xd486('0x44')]);_0xdc3e88[_0xd486('0x45')]=qs[_0xd486('0x3e')](_['pick'](_0x4add22['query'],_0xc23eb2[_0xd486('0x3e')]));_0xdc3e88[_0xd486('0x45')]['VoiceQueueId']=_0x3b026b['id'];if(_0x4add22[_0xd486('0x3c')][_0xd486('0x2f')]){_0xdc3e88[_0xd486('0x45')]=_[_0xd486('0x47')](_0xdc3e88[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0xdc3e88[_0xd486('0x40')],function(_0x5e0730){var _0x50ee64={};_0x50ee64[_0x5e0730]={'$like':'%'+_0x4add22[_0xd486('0x3c')][_0xd486('0x2f')]+'%'};return _0x50ee64;})});}_0xdc3e88=_[_0xd486('0x47')]({},_0xdc3e88,_0x4add22[_0xd486('0x4f')]);return db['CmHopperFinal'][_0xd486('0x20')]({'where':_0xdc3e88[_0xd486('0x45')]})[_0xd486('0x28')](function(_0x1b849b){_0x50f64a[_0xd486('0x20')]=_0x1b849b;if(_0x4add22[_0xd486('0x3c')][_0xd486('0x48')]){_0xdc3e88[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x66')][_0xd486('0x4a')](_0xdc3e88);})['then'](function(_0x5388b2){_0x50f64a[_0xd486('0x4b')]=_0x5388b2;return _0x50f64a;});}})[_0xd486('0x28')](respondWithFilteredResult(_0x772832,_0xdc3e88))['catch'](handleError(_0x772832,null));};exports[_0xd486('0x67')]=function(_0x5e9b2b,_0x3caeae,_0x1dfbde){var _0x2b8c96={'raw':!![],'where':{}};var _0x5062d9={};var _0x2598a0={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xd486('0x60')]({'where':{'id':_0x5e9b2b[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x3caeae,null))[_0xd486('0x28')](function(_0x318332){if(_0x318332){_0x5062d9[_0xd486('0x3b')]=_[_0xd486('0x3d')](db['CmHopperBlack'][_0xd486('0x3a')]);_0x5062d9[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x5e9b2b[_0xd486('0x3c')]);_0x5062d9[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x5062d9['model'],_0x5062d9[_0xd486('0x3c')]);_0x2b8c96[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x5062d9[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x41')]));_0x2b8c96[_0xd486('0x40')]=_0x2b8c96['attributes'][_0xd486('0x4e')]?_0x2b8c96[_0xd486('0x40')]:_0x5062d9[_0xd486('0x3b')];if(!_0x5e9b2b['query'][_0xd486('0x62')](_0xd486('0x42'))){_0x2b8c96[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x22')]);_0x2b8c96[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x5e9b2b['query'][_0xd486('0x21')]);}_0x2b8c96[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x44')]);_0x2b8c96['where']=qs[_0xd486('0x3e')](_['pick'](_0x5e9b2b[_0xd486('0x3c')],_0x5062d9['filters']));_0x2b8c96[_0xd486('0x45')][_0xd486('0x63')]=_0x318332['id'];if(_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x2f')]){_0x2b8c96[_0xd486('0x45')]=_['merge'](_0x2b8c96[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0x2b8c96['attributes'],function(_0x23ada8){var _0x24a90b={};_0x24a90b[_0x23ada8]={'$like':'%'+_0x5e9b2b['query'][_0xd486('0x2f')]+'%'};return _0x24a90b;})});}_0x2b8c96=_[_0xd486('0x47')]({},_0x2b8c96,_0x5e9b2b[_0xd486('0x4f')]);return db[_0xd486('0x68')][_0xd486('0x20')]({'where':_0x2b8c96[_0xd486('0x45')]})['then'](function(_0x33ce32){_0x2598a0[_0xd486('0x20')]=_0x33ce32;if(_0x5e9b2b[_0xd486('0x3c')][_0xd486('0x48')]){_0x2b8c96[_0xd486('0x49')]=[{'all':!![]}];}return db[_0xd486('0x68')]['findAll'](_0x2b8c96);})['then'](function(_0x44b875){_0x2598a0['rows']=_0x44b875;return _0x2598a0;});}})[_0xd486('0x28')](respondWithFilteredResult(_0x3caeae,_0x2b8c96))[_0xd486('0x58')](handleError(_0x3caeae,null));};exports['getTeams']=function(_0x1cf8b6,_0x66e5e9,_0x140dcd){var _0x42f94c={};var _0x1fe9fd={};var _0x8fbc32;var _0x390d40;return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x1cf8b6['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x66e5e9,null))[_0xd486('0x28')](function(_0xf1786c){if(_0xf1786c){_0x8fbc32=_0xf1786c;_0x1fe9fd[_0xd486('0x3b')]=_['keys'](db[_0xd486('0x69')][_0xd486('0x3a')]);_0x1fe9fd['query']=_[_0xd486('0x3d')](_0x1cf8b6[_0xd486('0x3c')]);_0x1fe9fd[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x1fe9fd[_0xd486('0x3b')],_0x1fe9fd['query']);_0x42f94c[_0xd486('0x40')]=_['intersection'](_0x1fe9fd[_0xd486('0x3b')],qs['fields'](_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x41')]));_0x42f94c[_0xd486('0x40')]=_0x42f94c['attributes'][_0xd486('0x4e')]?_0x42f94c[_0xd486('0x40')]:_0x1fe9fd[_0xd486('0x3b')];_0x42f94c[_0xd486('0x43')]=qs['sort'](_0x1cf8b6['query'][_0xd486('0x44')]);_0x42f94c[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x1cf8b6[_0xd486('0x3c')],_0x1fe9fd[_0xd486('0x3e')]));if(_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x2f')]){_0x42f94c[_0xd486('0x45')]=_[_0xd486('0x47')](_0x42f94c[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0x42f94c['attributes'],function(_0x2d342a){var _0x546455={};_0x546455[_0x2d342a]={'$like':'%'+_0x1cf8b6[_0xd486('0x3c')]['filter']+'%'};return _0x546455;})});}_0x42f94c=_[_0xd486('0x47')]({},_0x42f94c,_0x1cf8b6[_0xd486('0x4f')]);return _0x8fbc32[_0xd486('0x6a')](_0x42f94c);}})[_0xd486('0x28')](function(_0x425f16){if(_0x425f16){_0x390d40=_0x425f16[_0xd486('0x4e')];if(!_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x42f94c['limit']=qs[_0xd486('0x22')](_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x22')]);_0x42f94c[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x1cf8b6[_0xd486('0x3c')][_0xd486('0x21')]);}return _0x8fbc32[_0xd486('0x6a')](_0x42f94c);}})[_0xd486('0x28')](function(_0x1ed9c1){if(_0x1ed9c1){return _0x1ed9c1?{'count':_0x390d40,'rows':_0x1ed9c1}:null;}})[_0xd486('0x28')](respondWithResult(_0x66e5e9,null))[_0xd486('0x58')](handleError(_0x66e5e9,null));};exports[_0xd486('0x6b')]=function(_0xb9089f,_0x3e8a10,_0x1b4273){var _0x275a8d=_0xb9089f['body'][_0xd486('0x6c')];var _0xadbe10=_[_0xd486('0x38')](_0x275a8d,'id');return db[_0xd486('0x69')][_0xd486('0x4a')]({'where':{'id':_0xadbe10},'attributes':['id'],'include':[{'model':db[_0xd486('0x6d')],'as':_0xd486('0x6e'),'attributes':['id',_0xd486('0x34'),_0xd486('0x6f'),'voicePause','interface'],'raw':!![]}]})[_0xd486('0x28')](function(_0x35a1b){if(_0x35a1b){var _0x385063=_[_0xd486('0x70')](_0x35a1b,function(_0x5a9532){var _0x4a614e=_0x5a9532[_0xd486('0x2a')]({'plain':!![]});_0x4a614e[_0xd486('0x6e')][_0xd486('0x71')](function(_0x37e5f6){_0x37e5f6[_0xd486('0x72')]=_['find'](_0x275a8d,{'id':_0x4a614e['id']})[_0xd486('0x72')];});return _0x4a614e[_0xd486('0x6e')];});return db['VoiceQueue'][_0xd486('0x33')]({'where':{'id':_0xb9089f[_0xd486('0x4d')]['id']}})['then'](function(_0xeed84f){return db[_0xd486('0x73')][_0xd486('0x74')](function(_0x50b270){return _0xeed84f[_0xd486('0x6b')](_0xadbe10,{'transaction':_0x50b270})[_0xd486('0x28')](function(){return BPromise[_0xd486('0x75')](_0x385063,function(_0x19a43f){return db[_0xd486('0x76')][_0xd486('0x77')]({'where':{'UserId':_0x19a43f['id'],'VoiceQueueId':_0xb9089f[_0xd486('0x4d')]['id']},'defaults':{'penalty':_0x19a43f[_0xd486('0x72')]},'transaction':_0x50b270});});})[_0xd486('0x28')](function(){return BPromise[_0xd486('0x75')](_[_0xd486('0x2f')](_0x385063,{'online':!![]}),function(_0x47fe7b){return db[_0xd486('0x78')][_0xd486('0x79')]({'membername':_0x47fe7b[_0xd486('0x34')],'UserId':_0x47fe7b['id'],'queue_name':_0xeed84f[_0xd486('0x34')],'VoiceQueueId':_0xeed84f['id'],'interface':_[_0xd486('0x7a')](_0x47fe7b['interface'])?util[_0xd486('0x7b')]('SIP/%s',_0x47fe7b[_0xd486('0x34')]):_0x47fe7b[_0xd486('0x7c')],'paused':_0x47fe7b[_0xd486('0x7d')]||![],'penalty':_0x47fe7b['penalty']},{'transaction':_0x50b270});});})[_0xd486('0x28')](function(){_0x385063[_0xd486('0x71')](function(_0x35a64d){socket[_0xd486('0x7e')](_0xd486('0x7f'),{'UserId':_0x35a64d['id'],'VoiceQueueId':_0xeed84f['id']});});});});});}})[_0xd486('0x28')](respondWithStatusCode(_0x3e8a10,null))[_0xd486('0x58')](handleError(_0x3e8a10,null));};exports[_0xd486('0x80')]=function(_0x232732,_0x3b1178,_0x21d44){return db[_0xd486('0x69')]['findAll']({'where':{'id':_0x232732['query'][_0xd486('0x81')]},'attributes':['id'],'include':[{'model':db[_0xd486('0x6d')],'as':_0xd486('0x6e'),'attributes':['id'],'raw':!![]}]})[_0xd486('0x28')](handleEntityNotFound(_0x3b1178,null))[_0xd486('0x28')](function(_0x948c0c){var _0x184a94=_[_0xd486('0x38')](_0x948c0c,'id');var _0x76320=[];var _0x3a0443=[];var _0x7566f8=squel[_0xd486('0x82')]();_0x7566f8['field'](_0xd486('0x83'))[_0xd486('0x84')](_0xd486('0x85'),'tq')[_0xd486('0x86')](_0xd486('0x87'),'ut','ut.TeamId\x20=\x20tq.TeamId')['where'](_0xd486('0x88'),_0x232732['params']['id']);for(var _0x271f6a=0x0;_0x271f6a<_0x948c0c[_0xd486('0x4e')];_0x271f6a+=0x1){let _0x27007e=_0x948c0c[_0x271f6a];for(var _0xa0e94b=0x0;_0xa0e94b<_0x27007e[_0xd486('0x6e')][_0xd486('0x4e')];_0xa0e94b+=0x1){let _0x48bad4=_0x27007e['Agents'][_0xa0e94b];var _0x49ec74=_0x7566f8[_0xd486('0x89')]();_0x49ec74['where'](_0xd486('0x8a'),_0x48bad4['id']);_0x3a0443[_0xd486('0x8b')](db[_0xd486('0x73')][_0xd486('0x3c')](_0x49ec74[_0xd486('0x8c')](),{'type':db[_0xd486('0x73')][_0xd486('0x8d')]['SELECT']})['then'](function(_0x1712e1){if(_0x1712e1['length']===0x1){return _0x48bad4['id'];}else{var _0x1fd9ae=_[_0xd486('0x8e')](_[_0xd486('0x38')](_0x1712e1,'TeamId'),function(_0x3b9aea){return _['includes'](_0x184a94,_0x3b9aea);});if(_0x1fd9ae){return _0x48bad4['id'];}}}));}}return BPromise[_0xd486('0x8f')](_0x3a0443)[_0xd486('0x28')](function(_0x5a3c66){_0x76320=_(_0x76320)[_0xd486('0x90')](_0x5a3c66)['compact']()[_0xd486('0x31')]();return db[_0xd486('0x39')][_0xd486('0x33')]({'where':{'id':_0x232732[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](function(_0x5f20a8){return db['sequelize']['transaction'](function(_0x10c677){return _0x5f20a8[_0xd486('0x80')](_0x232732['query'][_0xd486('0x81')],{'transaction':_0x10c677})[_0xd486('0x28')](function(){if(!_[_0xd486('0x91')](_0x76320)){return _0x5f20a8[_0xd486('0x92')](_0x76320,{'transaction':_0x10c677})[_0xd486('0x28')](function(){return db[_0xd486('0x78')][_0xd486('0x29')]({'where':{'VoiceQueueId':_0x232732[_0xd486('0x4d')]['id'],'UserId':_0x76320},'transaction':_0x10c677});});}})[_0xd486('0x28')](function(){_0x76320[_0xd486('0x71')](function(_0x2e7e2c){socket[_0xd486('0x7e')](_0xd486('0x93'),{'UserId':_0x2e7e2c,'VoiceQueueId':_0x5f20a8['id']});});});});});});})[_0xd486('0x28')](respondWithStatusCode(_0x3b1178,null))['catch'](handleError(_0x3b1178,null));};exports[_0xd486('0x94')]=function(_0x33abe6,_0x251c9b,_0x4eaf1b){var _0x19f9b1,_0x4fe8bc;return db['VoiceQueue'][_0xd486('0x33')]({'where':{'id':_0x33abe6[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x251c9b,null))[_0xd486('0x28')](function(_0x267dc8){if(_0x267dc8){_0x4fe8bc=_0x267dc8;return _0x267dc8['addAgents'](_0x33abe6[_0xd486('0x51')][_0xd486('0x81')],_[_0xd486('0x5b')](_0x33abe6[_0xd486('0x51')],[_0xd486('0x81'),'id'])||{})['spread'](function(_0x160dc6){for(var _0x3d495a=0x0;_0x3d495a<_0x33abe6[_0xd486('0x51')][_0xd486('0x81')][_0xd486('0x4e')];_0x3d495a+=0x1){socket[_0xd486('0x7e')](_0xd486('0x7f'),{'UserId':_0x33abe6['body'][_0xd486('0x81')][_0x3d495a],'VoiceQueueId':_0x33abe6[_0xd486('0x4d')]['id']});}return _0x160dc6;});}})['then'](function(_0x5e1aa5){_0x19f9b1=_0x5e1aa5||[];if(_0x4fe8bc){return db[_0xd486('0x6d')][_0xd486('0x4a')]({'where':{'id':_0x33abe6[_0xd486('0x51')]['ids']},'attributes':['id','name',_0xd486('0x6f'),_0xd486('0x7d'),_0xd486('0x7c')],'raw':!![]});}})[_0xd486('0x28')](function(_0x50ee49){if(!_[_0xd486('0x91')](_0x50ee49)){var _0x2ce3e2=[];for(var _0x3e51d6=0x0;_0x3e51d6<_0x50ee49[_0xd486('0x4e')];_0x3e51d6++){if(_0x50ee49[_0x3e51d6][_0xd486('0x6f')]){_0x2ce3e2['push'](db['UserVoiceQueueRt'][_0xd486('0x79')]({'membername':_0x50ee49[_0x3e51d6][_0xd486('0x34')],'UserId':_0x50ee49[_0x3e51d6]['id'],'queue_name':_0x4fe8bc[_0xd486('0x34')],'VoiceQueueId':_0x4fe8bc['id'],'interface':_[_0xd486('0x7a')](_0x50ee49[_0x3e51d6][_0xd486('0x7c')])?util[_0xd486('0x7b')](_0xd486('0x95'),_0x50ee49[_0x3e51d6][_0xd486('0x34')]):_0x50ee49[_0x3e51d6][_0xd486('0x7c')],'paused':_0x50ee49[_0x3e51d6][_0xd486('0x7d')]||![],'penalty':_0x33abe6[_0xd486('0x51')][_0xd486('0x72')]||0x0}));}}return BPromise[_0xd486('0x8f')](_0x2ce3e2);}})[_0xd486('0x28')](function(){return _0x19f9b1;})[_0xd486('0x28')](respondWithResult(_0x251c9b,null))[_0xd486('0x58')](handleError(_0x251c9b,null));};exports[_0xd486('0x92')]=function(_0x52fb58,_0x4a1f6a,_0x314475){return db[_0xd486('0x39')][_0xd486('0x33')]({'where':{'id':_0x52fb58['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x4a1f6a,null))[_0xd486('0x28')](function(_0x215155){if(_0x215155){return _0x215155[_0xd486('0x92')](_0x52fb58[_0xd486('0x3c')][_0xd486('0x81')])[_0xd486('0x28')](function(){if(_[_0xd486('0x96')](_0x52fb58[_0xd486('0x3c')][_0xd486('0x81')])){for(var _0xe803c0=0x0;_0xe803c0<_0x52fb58[_0xd486('0x3c')]['ids'][_0xd486('0x4e')];_0xe803c0+=0x1){socket[_0xd486('0x7e')](_0xd486('0x93'),{'UserId':Number(_0x52fb58[_0xd486('0x3c')][_0xd486('0x81')][_0xe803c0]),'VoiceQueueId':Number(_0x52fb58[_0xd486('0x4d')]['id'])});}}else{socket['emit'](_0xd486('0x93'),{'UserId':Number(_0x52fb58['query'][_0xd486('0x81')]),'VoiceQueueId':Number(_0x52fb58[_0xd486('0x4d')]['id'])});}});}})[_0xd486('0x28')](function(_0x15f38b){return db['UserVoiceQueueRt'][_0xd486('0x29')]({'where':{'VoiceQueueId':_0x52fb58[_0xd486('0x4d')]['id'],'UserId':_0x52fb58[_0xd486('0x3c')]['ids']}})['then'](function(){return _0x15f38b;});})[_0xd486('0x28')](respondWithStatusCode(_0x4a1f6a,null))[_0xd486('0x58')](handleError(_0x4a1f6a,null));};exports[_0xd486('0x97')]=function(_0x5a9bc5,_0xf02844,_0xc843a3){var _0x5c3b74={};var _0x14efaf={};var _0x101cd2;var _0x1dc9e6;return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x5a9bc5[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0xf02844,null))[_0xd486('0x28')](function(_0x4df273){if(_0x4df273){_0x101cd2=_0x4df273;_0x14efaf[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0x6d')][_0xd486('0x3a')]);_0x14efaf[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x5a9bc5[_0xd486('0x3c')]);_0x14efaf[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x14efaf[_0xd486('0x3b')],_0x14efaf[_0xd486('0x3c')]);_0x5c3b74[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x14efaf['model'],qs[_0xd486('0x41')](_0x5a9bc5[_0xd486('0x3c')][_0xd486('0x41')]));_0x5c3b74[_0xd486('0x40')]=_0x5c3b74[_0xd486('0x40')][_0xd486('0x4e')]?_0x5c3b74[_0xd486('0x40')]:_0x14efaf[_0xd486('0x3b')];_0x5c3b74[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x5a9bc5[_0xd486('0x3c')]['sort']);_0x5c3b74[_0xd486('0x45')]=qs[_0xd486('0x3e')](_['pick'](_0x5a9bc5[_0xd486('0x3c')],_0x14efaf['filters']));if(_0x5a9bc5[_0xd486('0x3c')][_0xd486('0x2f')]){_0x5c3b74[_0xd486('0x45')]=_[_0xd486('0x47')](_0x5c3b74['where'],{'$or':_['map'](_0x5c3b74[_0xd486('0x40')],function(_0x379120){var _0x2e8f1e={};_0x2e8f1e[_0x379120]={'$like':'%'+_0x5a9bc5[_0xd486('0x3c')]['filter']+'%'};return _0x2e8f1e;})});}_0x5c3b74=_['merge']({},_0x5c3b74,_0x5a9bc5[_0xd486('0x4f')]);return _0x101cd2[_0xd486('0x97')](_0x5c3b74);}})[_0xd486('0x28')](function(_0x562568){if(_0x562568){_0x1dc9e6=_0x562568['length'];if(!_0x5a9bc5[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x5c3b74[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x5a9bc5[_0xd486('0x3c')]['limit']);_0x5c3b74[_0xd486('0x21')]=qs['offset'](_0x5a9bc5[_0xd486('0x3c')]['offset']);}return _0x101cd2[_0xd486('0x97')](_0x5c3b74);}})[_0xd486('0x28')](function(_0x5dde84){if(_0x5dde84){return _0x5dde84?{'count':_0x1dc9e6,'rows':_0x5dde84}:null;}})[_0xd486('0x28')](respondWithResult(_0xf02844,null))[_0xd486('0x58')](handleError(_0xf02844,null));};exports['getMembers']=function(_0x2e9174,_0x1ad035,_0x1d5025){var _0x1cdb65={};var _0x383df4={};var _0x3e95e4;var _0x45bf23;return db['VoiceQueue'][_0xd486('0x60')]({'where':{'id':_0x2e9174[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x1ad035,null))[_0xd486('0x28')](function(_0x54a806){if(_0x54a806){_0x3e95e4=_0x54a806;_0x383df4['model']=_[_0xd486('0x3d')](db['UserVoiceQueueRt']['rawAttributes']);_0x383df4[_0xd486('0x3c')]=_['keys'](_0x2e9174[_0xd486('0x3c')]);_0x383df4['filters']=_[_0xd486('0x3f')](_0x383df4[_0xd486('0x3b')],_0x383df4[_0xd486('0x3c')]);_0x1cdb65['attributes']=_[_0xd486('0x3f')](_0x383df4[_0xd486('0x3b')],qs['fields'](_0x2e9174[_0xd486('0x3c')][_0xd486('0x41')]));_0x1cdb65[_0xd486('0x40')]=_0x1cdb65[_0xd486('0x40')]['length']?_0x1cdb65['attributes']:_0x383df4['model'];_0x1cdb65['order']=qs['sort'](_0x2e9174[_0xd486('0x3c')]['sort']);_0x1cdb65[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x2e9174['query'],_0x383df4['filters']));if(_0x2e9174[_0xd486('0x3c')]['filter']){_0x1cdb65['where']=_[_0xd486('0x47')](_0x1cdb65['where'],{'$or':_[_0xd486('0x38')](_0x1cdb65[_0xd486('0x40')],function(_0x4375bc){var _0x4b420f={};_0x4b420f[_0x4375bc]={'$like':'%'+_0x2e9174[_0xd486('0x3c')][_0xd486('0x2f')]+'%'};return _0x4b420f;})});}_0x1cdb65=_[_0xd486('0x47')]({},_0x1cdb65,_0x2e9174['options']);return _0x3e95e4['getMembers'](_0x1cdb65);}})[_0xd486('0x28')](function(_0x9ed562){if(_0x9ed562){_0x45bf23=_0x9ed562[_0xd486('0x4e')];if(!_0x2e9174[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x1cdb65[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x2e9174['query']['limit']);_0x1cdb65['offset']=qs[_0xd486('0x21')](_0x2e9174[_0xd486('0x3c')][_0xd486('0x21')]);}return _0x3e95e4['getMembers'](_0x1cdb65);}})[_0xd486('0x28')](function(_0x361b29){return _0x361b29?{'count':_0x45bf23,'rows':_0x361b29}:null;})['then'](respondWithResult(_0x1ad035,null))[_0xd486('0x58')](handleError(_0x1ad035,null));};exports['getLists']=function(_0x28c226,_0x3deb92,_0x50616d){var _0x236798={};var _0x5140b3={};var _0x21a49d;var _0x5bb207;return db[_0xd486('0x39')][_0xd486('0x60')]({'where':{'id':_0x28c226[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x3deb92,null))[_0xd486('0x28')](function(_0x2e7163){if(_0x2e7163){_0x21a49d=_0x2e7163;_0x5140b3[_0xd486('0x3b')]=_[_0xd486('0x3d')](db['CmList'][_0xd486('0x3a')]);_0x5140b3[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x28c226[_0xd486('0x3c')]);_0x5140b3[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x5140b3['model'],_0x5140b3['query']);_0x236798[_0xd486('0x40')]=_[_0xd486('0x3f')](_0x5140b3[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x28c226['query'][_0xd486('0x41')]));_0x236798['attributes']=_0x236798[_0xd486('0x40')][_0xd486('0x4e')]?_0x236798[_0xd486('0x40')]:_0x5140b3['model'];_0x236798[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x28c226[_0xd486('0x3c')][_0xd486('0x44')]);_0x236798[_0xd486('0x45')]=qs[_0xd486('0x3e')](_[_0xd486('0x46')](_0x28c226['query'],_0x5140b3[_0xd486('0x3e')]));if(_0x28c226['query'][_0xd486('0x2f')]){_0x236798[_0xd486('0x45')]=_[_0xd486('0x47')](_0x236798[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0x236798[_0xd486('0x40')],function(_0x484279){var _0x70c740={};_0x70c740[_0x484279]={'$like':'%'+_0x28c226[_0xd486('0x3c')]['filter']+'%'};return _0x70c740;})});}_0x236798=_[_0xd486('0x47')]({},_0x236798,_0x28c226[_0xd486('0x4f')]);return _0x21a49d[_0xd486('0x98')](_0x236798);}})['then'](function(_0x5e024f){if(_0x5e024f){_0x5bb207=_0x5e024f[_0xd486('0x4e')];if(!_0x28c226[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0x236798[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x28c226[_0xd486('0x3c')][_0xd486('0x22')]);_0x236798[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x28c226['query'][_0xd486('0x21')]);}return _0x21a49d[_0xd486('0x98')](_0x236798);}})[_0xd486('0x28')](function(_0x2b2be3){if(_0x2b2be3){return _0x2b2be3?{'count':_0x5bb207,'rows':_0x2b2be3}:null;}})[_0xd486('0x28')](respondWithResult(_0x3deb92,null))[_0xd486('0x58')](handleError(_0x3deb92,null));};exports[_0xd486('0x99')]=function(_0x22be90,_0x3b507c,_0x143d28){var _0x3df219,_0x1cfcc8;return db[_0xd486('0x39')][_0xd486('0x33')]({'where':{'id':_0x22be90['params']['id']}})['then'](handleEntityNotFound(_0x3b507c,null))[_0xd486('0x28')](function(_0x1c0d41){if(_0x1c0d41){_0x1cfcc8=_0x1c0d41;return _0x1c0d41[_0xd486('0x99')](_0x22be90[_0xd486('0x51')][_0xd486('0x81')],_[_0xd486('0x5b')](_0x22be90[_0xd486('0x51')],['ids','id'])||{});}return null;})[_0xd486('0x9a')](function(_0x318eaa){var _0x3dcc87;_0x3df219=_0x318eaa||[];var _0x1edb19=[];if(_0x318eaa){for(var _0x5f16a6=0x0;_0x5f16a6<_0x318eaa['length'];_0x5f16a6+=0x1){var _0xd9847=_0x318eaa[_0x5f16a6][_0xd486('0x2a')]({'plain':!![]});_0x1cfcc8[_0xd486('0x9b')]=_0x22be90[_0xd486('0x51')]['dialCheckDuplicateType']?_0x22be90[_0xd486('0x51')][_0xd486('0x9b')]:_0x1cfcc8[_0xd486('0x9b')];switch(_0x1cfcc8[_0xd486('0x9b')]){case _0xd486('0x9c'):_0x3dcc87=squel[_0xd486('0x9d')]()[_0xd486('0x9e')](_0xd486('0x9f'))[_0xd486('0xa0')](['phone',_0xd486('0xa1'),_0xd486('0xa2'),_0xd486('0xa3'),_0xd486('0x63'),_0xd486('0x5c'),_0xd486('0x5d')],squel[_0xd486('0x82')]()[_0xd486('0xa4')]('phone','phone')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0xa1'))[_0xd486('0xa4')]('id',_0xd486('0xa2'))['field'](_0xd9847['CmListId'][_0xd486('0x8c')](),'ListId')['field'](_0x22be90[_0xd486('0x4d')]['id'][_0xd486('0x8c')](),'VoiceQueueId')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0x5c'))[_0xd486('0xa4')]('NOW()',_0xd486('0x5d'))['from']('cm_contacts')[_0xd486('0x45')](_0xd486('0xa6'))[_0xd486('0x45')](_0xd486('0xa7'),_0xd9847[_0xd486('0xa8')][_0xd486('0x8c')]())[_0xd486('0x45')](_0xd486('0xa9'))['where']('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0xd486('0xa4')]('COALESCE(calleridnum,\x27\x27)')[_0xd486('0x84')]('cm_hopper_final')[_0xd486('0x45')](_0xd486('0x88'),_0x22be90[_0xd486('0x4d')]['id'][_0xd486('0x8c')]()))[_0xd486('0x45')]('phone\x20NOT\x20IN\x20(?)',squel[_0xd486('0x82')]()['field'](_0xd486('0xaa'))[_0xd486('0x84')](_0xd486('0x9f'))['where'](_0xd486('0x88'),_0x22be90[_0xd486('0x4d')]['id'][_0xd486('0x8c')]())))[_0xd486('0x8c')]();break;case _0xd486('0xab'):_0x3dcc87=squel['insert']()[_0xd486('0x9e')](_0xd486('0x9f'))[_0xd486('0xa0')]([_0xd486('0xac'),_0xd486('0xa1'),'ContactId',_0xd486('0xa3'),'VoiceQueueId',_0xd486('0x5c'),_0xd486('0x5d')],squel[_0xd486('0x82')]()[_0xd486('0xa4')](_0xd486('0xac'),'phone')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0xa1'))['field']('id',_0xd486('0xa2'))[_0xd486('0xa4')](_0xd9847['CmListId'][_0xd486('0x8c')](),'ListId')[_0xd486('0xa4')](_0x22be90['params']['id'][_0xd486('0x8c')](),'VoiceQueueId')[_0xd486('0xa4')]('NOW()','createdAt')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0x5d'))[_0xd486('0x84')](_0xd486('0xad'))[_0xd486('0x45')]('deletedAt\x20IS\x20NULL')[_0xd486('0x45')](_0xd486('0xa7'),_0xd9847[_0xd486('0xa8')][_0xd486('0x8c')]())[_0xd486('0x45')](_0xd486('0xa9'))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0xd486('0x82')]()[_0xd486('0xa4')](_0xd486('0xaa'))['from'](_0xd486('0x9f'))['where']('VoiceQueueId\x20=\x20?',_0x22be90[_0xd486('0x4d')]['id'][_0xd486('0x8c')]())))['toString']();break;default:_0x3dcc87=squel['insert']()['into']('cm_hopper')[_0xd486('0xa0')](['phone',_0xd486('0xa1'),_0xd486('0xa2'),'ListId',_0xd486('0x63'),_0xd486('0x5c'),_0xd486('0x5d')],squel[_0xd486('0x82')]()[_0xd486('0xa4')]('phone',_0xd486('0xac'))['field']('NOW()',_0xd486('0xa1'))[_0xd486('0xa4')]('id','ContactId')[_0xd486('0xa4')](_0xd9847[_0xd486('0xa8')][_0xd486('0x8c')](),'ListId')[_0xd486('0xa4')](_0x22be90[_0xd486('0x4d')]['id']['toString'](),_0xd486('0x63'))['field'](_0xd486('0xa5'),_0xd486('0x5c'))['field'](_0xd486('0xa5'),_0xd486('0x5d'))[_0xd486('0x84')](_0xd486('0xad'))[_0xd486('0x45')]('deletedAt\x20IS\x20NULL')[_0xd486('0x45')](_0xd486('0xa7'),_0xd9847[_0xd486('0xa8')][_0xd486('0x8c')]())['where'](_0xd486('0xa9')))[_0xd486('0x8c')]();}_0x1edb19[_0xd486('0x8b')](db['sequelize'][_0xd486('0x3c')](_0x3dcc87));}return BPromise['all'](_0x1edb19);}})[_0xd486('0x28')](function(){return _0x3df219;})[_0xd486('0x28')](respondWithResult(_0x3b507c,null))['catch'](handleError(_0x3b507c,null));};exports[_0xd486('0xae')]=function(_0x3dc6ed,_0x23a20e,_0x26f36d){return db['VoiceQueue'][_0xd486('0x33')]({'where':{'id':_0x3dc6ed[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x23a20e,null))[_0xd486('0x28')](function(_0x558e92){if(_0x558e92){return _0x558e92[_0xd486('0xae')](_0x3dc6ed[_0xd486('0x3c')][_0xd486('0x81')]);}})[_0xd486('0x28')](function(_0x52b90f){if(_0x52b90f){return db['CmHopper'][_0xd486('0x29')]({'where':{'ListId':_0x3dc6ed[_0xd486('0x3c')][_0xd486('0x81')],'VoiceQueueId':_0x3dc6ed[_0xd486('0x4d')]['id']}})['then'](function(){return _0x52b90f;});}})['then'](respondWithStatusCode(_0x23a20e,null))[_0xd486('0x58')](handleError(_0x23a20e,null));};exports[_0xd486('0xaf')]=function(_0x4d4a26,_0x4a1ca3,_0x1a03fc){var _0xccc3d2={};var _0x3a8351={};var _0x2bf5bd;var _0x22daa5;return db[_0xd486('0x39')]['findOne']({'where':{'id':_0x4d4a26[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x4a1ca3,null))[_0xd486('0x28')](function(_0x35c2f6){if(_0x35c2f6){_0x2bf5bd=_0x35c2f6;_0x3a8351[_0xd486('0x3b')]=_[_0xd486('0x3d')](db[_0xd486('0xb0')][_0xd486('0x3a')]);_0x3a8351[_0xd486('0x3c')]=_[_0xd486('0x3d')](_0x4d4a26[_0xd486('0x3c')]);_0x3a8351[_0xd486('0x3e')]=_[_0xd486('0x3f')](_0x3a8351['model'],_0x3a8351['query']);_0xccc3d2['attributes']=_['intersection'](_0x3a8351[_0xd486('0x3b')],qs[_0xd486('0x41')](_0x4d4a26[_0xd486('0x3c')]['fields']));_0xccc3d2[_0xd486('0x40')]=_0xccc3d2[_0xd486('0x40')][_0xd486('0x4e')]?_0xccc3d2[_0xd486('0x40')]:_0x3a8351['model'];_0xccc3d2[_0xd486('0x43')]=qs[_0xd486('0x44')](_0x4d4a26[_0xd486('0x3c')][_0xd486('0x44')]);_0xccc3d2['where']=qs[_0xd486('0x3e')](_['pick'](_0x4d4a26[_0xd486('0x3c')],_0x3a8351['filters']));if(_0x4d4a26[_0xd486('0x3c')]['filter']){_0xccc3d2[_0xd486('0x45')]=_[_0xd486('0x47')](_0xccc3d2[_0xd486('0x45')],{'$or':_[_0xd486('0x38')](_0xccc3d2['attributes'],function(_0x43d523){var _0x157b22={};_0x157b22[_0x43d523]={'$like':'%'+_0x4d4a26[_0xd486('0x3c')][_0xd486('0x2f')]+'%'};return _0x157b22;})});}_0xccc3d2=_[_0xd486('0x47')]({},_0xccc3d2,_0x4d4a26[_0xd486('0x4f')]);return _0x2bf5bd[_0xd486('0xaf')](_0xccc3d2);}})['then'](function(_0x2a3bc6){if(_0x2a3bc6){_0x22daa5=_0x2a3bc6['length'];if(!_0x4d4a26[_0xd486('0x3c')][_0xd486('0x62')](_0xd486('0x42'))){_0xccc3d2[_0xd486('0x22')]=qs[_0xd486('0x22')](_0x4d4a26[_0xd486('0x3c')][_0xd486('0x22')]);_0xccc3d2[_0xd486('0x21')]=qs[_0xd486('0x21')](_0x4d4a26[_0xd486('0x3c')][_0xd486('0x21')]);}return _0x2bf5bd[_0xd486('0xaf')](_0xccc3d2);}})[_0xd486('0x28')](function(_0x13a5ed){if(_0x13a5ed){return _0x13a5ed?{'count':_0x22daa5,'rows':_0x13a5ed}:null;}})[_0xd486('0x28')](respondWithResult(_0x4a1ca3,null))[_0xd486('0x58')](handleError(_0x4a1ca3,null));};exports['addBlackLists']=function(_0xa0e3e9,_0x4c046c,_0x33983f){var _0x10333f,_0x201b39;return db[_0xd486('0x39')]['find']({'where':{'id':_0xa0e3e9[_0xd486('0x4d')]['id']}})['then'](handleEntityNotFound(_0x4c046c,null))[_0xd486('0x28')](function(_0x5698ce){if(_0x5698ce){_0x201b39=_0x5698ce;return _0x5698ce[_0xd486('0xb1')](_0xa0e3e9[_0xd486('0x51')][_0xd486('0x81')],_[_0xd486('0x5b')](_0xa0e3e9['body'],[_0xd486('0x81'),'id'])||{});}return null;})[_0xd486('0x9a')](function(_0x497b01){var _0x2217f0;_0x10333f=_0x497b01||[];var _0x48b1ef=[];if(_0x497b01){for(var _0x444ce7=0x0;_0x444ce7<_0x497b01[_0xd486('0x4e')];_0x444ce7+=0x1){var _0x5518d8=_0x497b01[_0x444ce7][_0xd486('0x2a')]({'plain':!![]});_0x2217f0=squel[_0xd486('0x9d')]()['into']('cm_hopper_black')[_0xd486('0xa0')]([_0xd486('0xac'),_0xd486('0xa2'),'ListId',_0xd486('0x63'),_0xd486('0x5c'),'updatedAt'],squel[_0xd486('0x82')]()[_0xd486('0xa4')](_0xd486('0xac'),'phone')[_0xd486('0xa4')]('id',_0xd486('0xa2'))[_0xd486('0xa4')](_0x5518d8[_0xd486('0xa8')][_0xd486('0x8c')](),_0xd486('0xa3'))['field'](_0xa0e3e9[_0xd486('0x4d')]['id'][_0xd486('0x8c')](),'VoiceQueueId')[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0x5c'))[_0xd486('0xa4')](_0xd486('0xa5'),_0xd486('0x5d'))[_0xd486('0x84')](_0xd486('0xad'))[_0xd486('0x45')]('deletedAt\x20IS\x20NULL')[_0xd486('0x45')]('ListId\x20=\x20?',_0x5518d8[_0xd486('0xa8')][_0xd486('0x8c')]())[_0xd486('0x45')](_0xd486('0xa9')))['toString']();_0x48b1ef[_0xd486('0x8b')](db[_0xd486('0x73')][_0xd486('0x3c')](_0x2217f0));}return BPromise[_0xd486('0x8f')](_0x48b1ef);}})[_0xd486('0x28')](function(){return _0x10333f;})['then'](respondWithResult(_0x4c046c,null))[_0xd486('0x58')](handleError(_0x4c046c,null));};exports[_0xd486('0xb2')]=function(_0x33e6ef,_0x451a48,_0x42f9d2){return db[_0xd486('0x39')][_0xd486('0x33')]({'where':{'id':_0x33e6ef['params']['id']}})[_0xd486('0x28')](handleEntityNotFound(_0x451a48,null))[_0xd486('0x28')](function(_0x3cbcc5){if(_0x3cbcc5){return _0x3cbcc5[_0xd486('0xb2')](_0x33e6ef[_0xd486('0x3c')][_0xd486('0x81')]);}})['then'](function(_0x1a4f0f){if(_0x1a4f0f){return db[_0xd486('0x68')][_0xd486('0x29')]({'where':{'ListId':_0x33e6ef[_0xd486('0x3c')]['ids'],'VoiceQueueId':_0x33e6ef[_0xd486('0x4d')]['id']}})[_0xd486('0x28')](function(){return _0x1a4f0f;});}})[_0xd486('0x28')](respondWithStatusCode(_0x451a48,null))['catch'](handleError(_0x451a48,null));};
\ No newline at end of file
+var _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