// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x86b7=['register','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','save','update','then','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','map','value','includes','type','find','name','UserProfileResource','destroy','error','stack','index','VoiceQueue','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','merge','include','findAll','rows','catch','show','includeAll','options','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','UserProfileSection','userProfileId','clone','params','omit','createdAt','updatedAt','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','CmHopper','VoiceQueueId','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','addTeams','online','voicePause','interface','flatMap','Agents','forEach','penalty','sequelize','transaction','TeamVoiceQueue','upsert','UserVoiceQueue','each','UserVoiceQueueRt','isNil','format','SIP/%s','emit','removeTeams','ids','User','select','field','tq.TeamId','from','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','TeamId','all','union','compact','removeAgents','userVoiceQueue:remove','addAgents','spread','userVoiceQueue:save','isEmpty','isArray','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','always','into','cm_hopper','phone','scheduledAt','ContactId','CmListId','NOW()','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','VoiceQueueId\x20=\x20?','COALESCE(phone,\x27\x27)','onlyIfOpen','insert','ListId','phone\x20IS\x20NOT\x20NULL','fromQuery','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','fs-extra','lodash','crypto','jsforce','to-csv','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket'];(function(_0x10bc2e,_0x47b94e){var _0x3c6aaf=function(_0x1fd869){while(--_0x1fd869){_0x10bc2e['push'](_0x10bc2e['shift']());}};_0x3c6aaf(++_0x47b94e);}(_0x86b7,0xa0));var _0x786b=function(_0x5331b2,_0x457265){_0x5331b2=_0x5331b2-0x0;var _0x1095f8=_0x86b7[_0x5331b2];return _0x1095f8;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x786b('0x0'));var zipdir=require(_0x786b('0x1'));var jsonpatch=require(_0x786b('0x2'));var rp=require(_0x786b('0x3'));var moment=require(_0x786b('0x4'));var BPromise=require(_0x786b('0x5'));var Mustache=require(_0x786b('0x6'));var util=require('util');var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x786b('0x7'));var _=require(_0x786b('0x8'));var squel=require('squel');var crypto=require(_0x786b('0x9'));var jsforce=require(_0x786b('0xa'));var deskjs=require('desk.js');var toCsv=require(_0x786b('0xb'));var querystring=require(_0x786b('0xc'));var Papa=require(_0x786b('0xd'));var Redis=require('ioredis');var authService=require(_0x786b('0xe'));var qs=require(_0x786b('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x786b('0x10'));var logger=require(_0x786b('0x11'))(_0x786b('0x12'));var utils=require('../../config/utils');var config=require(_0x786b('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0x786b('0x14'))['db'];config[_0x786b('0x15')]=_[_0x786b('0x16')](config['redis'],{'host':_0x786b('0x17'),'port':0x18eb});var socket=require(_0x786b('0x18'))(new Redis(config[_0x786b('0x15')]));require(_0x786b('0x19'))[_0x786b('0x1a')](socket);function respondWithStatusCode(_0x3ea97a,_0x223129){_0x223129=_0x223129||0xcc;return function(_0x39aeb4){if(_0x39aeb4){return _0x3ea97a[_0x786b('0x1b')](_0x223129);}return _0x3ea97a[_0x786b('0x1c')](_0x223129)['end']();};}function respondWithResult(_0x56132c,_0xe06459){_0xe06459=_0xe06459||0xc8;return function(_0x1d2312){if(_0x1d2312){return _0x56132c[_0x786b('0x1c')](_0xe06459)[_0x786b('0x1d')](_0x1d2312);}};}function respondWithFilteredResult(_0x4948f4,_0x3bb984){return function(_0x3f6cc3){if(_0x3f6cc3){var _0x2a2dd7=typeof _0x3bb984[_0x786b('0x1e')]===_0x786b('0x1f')&&typeof _0x3bb984[_0x786b('0x20')]===_0x786b('0x1f');var _0x2175f7=_0x3f6cc3[_0x786b('0x21')];var _0x1abe8b=_0x2a2dd7?0x0:_0x3bb984[_0x786b('0x1e')];var _0x4a6066=_0x2a2dd7?_0x3f6cc3[_0x786b('0x21')]:_0x3bb984[_0x786b('0x1e')]+_0x3bb984[_0x786b('0x20')];var _0x31c27a;if(_0x4a6066>=_0x2175f7){_0x4a6066=_0x2175f7;_0x31c27a=0xc8;}else{_0x31c27a=0xce;}_0x4948f4[_0x786b('0x1c')](_0x31c27a);return _0x4948f4[_0x786b('0x22')](_0x786b('0x23'),_0x1abe8b+'-'+_0x4a6066+'/'+_0x2175f7)[_0x786b('0x1d')](_0x3f6cc3);}return null;};}function patchUpdates(_0x59bc30){return function(_0x299e08){try{jsonpatch['apply'](_0x299e08,_0x59bc30,!![]);}catch(_0x504ff5){return BPromise['reject'](_0x504ff5);}return _0x299e08[_0x786b('0x24')]();};}function saveUpdates(_0x30c2b5,_0x3b3d98){return function(_0x82919e){if(_0x82919e){return _0x82919e[_0x786b('0x25')](_0x30c2b5)[_0x786b('0x26')](function(_0x4a750e){return _0x4a750e;});}return null;};}function removeEntity(_0x45c75a,_0x49b22b){return function(_0x2c9ad1){if(_0x2c9ad1){return _0x2c9ad1['destroy']()[_0x786b('0x26')](function(){var _0xd4d337=_0x2c9ad1['get']({'plain':!![]});var _0x30e69a=[{'name':_0x786b('0x27'),'value':_0x786b('0x28'),'ignore':![]},{'name':_0x786b('0x29'),'value':_0x786b('0x2a'),'ignore':![]}];var _0x273a39=_(_0x30e69a)[_0x786b('0x2b')](_0x786b('0x2c'))[_0x786b('0x2d')](_0x786b('0x2e'))[_0x786b('0x2e')]();if(_[_0x786b('0x2f')](_0x273a39,_0xd4d337[_0x786b('0x30')])){return;}var _0x24fafc=_[_0x786b('0x31')](_0x30e69a,[_0x786b('0x2e'),_0xd4d337[_0x786b('0x30')]])[_0x786b('0x32')];return db[_0x786b('0x33')][_0x786b('0x34')]({'where':{'type':_0x24fafc,'resourceId':_0xd4d337['id']}})['then'](function(){return _0x2c9ad1;});})[_0x786b('0x26')](function(){_0x45c75a[_0x786b('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4c614d,_0x1b71d6){return function(_0x223145){if(!_0x223145){_0x4c614d[_0x786b('0x1b')](0x194);}return _0x223145;};}function handleError(_0x4e350,_0x517cd3){_0x517cd3=_0x517cd3||0x1f4;return function(_0x19ecd0){logger[_0x786b('0x35')](_0x19ecd0[_0x786b('0x36')]);if(_0x19ecd0[_0x786b('0x32')]){delete _0x19ecd0[_0x786b('0x32')];}_0x4e350['status'](_0x517cd3)['send'](_0x19ecd0);};}exports[_0x786b('0x37')]=function(_0x5878d4,_0x2136c8){var _0x580c27={},_0xf294b3={},_0x575480={'count':0x0,'rows':[]};var _0x2a0cbf=_['map'](db[_0x786b('0x38')][_0x786b('0x39')],function(_0x2653d8){return{'name':_0x2653d8[_0x786b('0x3a')],'type':_0x2653d8[_0x786b('0x30')][_0x786b('0x3b')]};});_0xf294b3[_0x786b('0x3c')]=_['map'](_0x2a0cbf,_0x786b('0x32'));_0xf294b3[_0x786b('0x3d')]=_[_0x786b('0x3e')](_0x5878d4['query']);_0xf294b3[_0x786b('0x3f')]=_[_0x786b('0x40')](_0xf294b3[_0x786b('0x3c')],_0xf294b3['query']);_0x580c27[_0x786b('0x41')]=_[_0x786b('0x40')](_0xf294b3[_0x786b('0x3c')],qs[_0x786b('0x42')](_0x5878d4[_0x786b('0x3d')]['fields']));_0x580c27[_0x786b('0x41')]=_0x580c27[_0x786b('0x41')][_0x786b('0x43')]?_0x580c27[_0x786b('0x41')]:_0xf294b3[_0x786b('0x3c')];if(!_0x5878d4['query'][_0x786b('0x44')](_0x786b('0x45'))){_0x580c27['limit']=qs['limit'](_0x5878d4[_0x786b('0x3d')]['limit']);_0x580c27['offset']=qs['offset'](_0x5878d4['query'][_0x786b('0x1e')]);}_0x580c27[_0x786b('0x46')]=qs[_0x786b('0x47')](_0x5878d4[_0x786b('0x3d')][_0x786b('0x47')]);_0x580c27[_0x786b('0x48')]=qs[_0x786b('0x3f')](_[_0x786b('0x49')](_0x5878d4['query'],_0xf294b3['filters']),_0x2a0cbf);if(_0x5878d4[_0x786b('0x3d')][_0x786b('0x2b')]){_0x580c27[_0x786b('0x48')]=_[_0x786b('0x4a')](_0x580c27[_0x786b('0x48')],{'$or':_[_0x786b('0x2d')](_0x2a0cbf,function(_0x303fc6){if(_0x303fc6[_0x786b('0x30')]!=='VIRTUAL'){var _0x3f6a81={};_0x3f6a81[_0x303fc6[_0x786b('0x32')]]={'$like':'%'+_0x5878d4['query'][_0x786b('0x2b')]+'%'};return _0x3f6a81;}})});}_0x580c27=_['merge']({},_0x580c27,_0x5878d4['options']);var _0x1c642b={'where':_0x580c27[_0x786b('0x48')]};return db[_0x786b('0x38')][_0x786b('0x21')](_0x1c642b)['then'](function(_0x36962c){_0x575480[_0x786b('0x21')]=_0x36962c;if(_0x5878d4[_0x786b('0x3d')]['includeAll']){_0x580c27[_0x786b('0x4b')]=[{'all':!![]}];}return db[_0x786b('0x38')][_0x786b('0x4c')](_0x580c27);})[_0x786b('0x26')](function(_0x461ac3){_0x575480[_0x786b('0x4d')]=_0x461ac3;return _0x575480;})[_0x786b('0x26')](respondWithFilteredResult(_0x2136c8,_0x580c27))[_0x786b('0x4e')](handleError(_0x2136c8,null));};exports[_0x786b('0x4f')]=function(_0x298a6b,_0x54bd27){var _0x20f256={'raw':![],'where':{'id':_0x298a6b['params']['id']}},_0x4d4367={};_0x4d4367['model']=_[_0x786b('0x3e')](db[_0x786b('0x38')][_0x786b('0x39')]);_0x4d4367[_0x786b('0x3d')]=_[_0x786b('0x3e')](_0x298a6b[_0x786b('0x3d')]);_0x4d4367[_0x786b('0x3f')]=_['intersection'](_0x4d4367[_0x786b('0x3c')],_0x4d4367[_0x786b('0x3d')]);_0x20f256[_0x786b('0x41')]=_[_0x786b('0x40')](_0x4d4367[_0x786b('0x3c')],qs['fields'](_0x298a6b[_0x786b('0x3d')][_0x786b('0x42')]));_0x20f256[_0x786b('0x41')]=_0x20f256[_0x786b('0x41')][_0x786b('0x43')]?_0x20f256['attributes']:_0x4d4367[_0x786b('0x3c')];if(_0x298a6b['query'][_0x786b('0x50')]){_0x20f256['include']=[{'all':!![]}];}_0x20f256=_[_0x786b('0x4a')]({},_0x20f256,_0x298a6b[_0x786b('0x51')]);return db[_0x786b('0x38')][_0x786b('0x31')](_0x20f256)[_0x786b('0x26')](handleEntityNotFound(_0x54bd27,null))[_0x786b('0x26')](respondWithResult(_0x54bd27,null))['catch'](handleError(_0x54bd27,null));};exports[_0x786b('0x52')]=function(_0x2d7f4e,_0x497dfd){return db['VoiceQueue'][_0x786b('0x52')](_0x2d7f4e[_0x786b('0x53')],{})[_0x786b('0x26')](function(_0xed143f){var _0x579fbe=_0x2d7f4e[_0x786b('0x54')]['get']({'plain':!![]});if(!_0x579fbe)throw new Error(_0x786b('0x55'));if(_0x579fbe[_0x786b('0x56')]===_0x786b('0x54')){var _0x5aafe2=_0xed143f[_0x786b('0x57')]({'plain':!![]});var _0x5ce938=[{'name':_0x786b('0x27'),'value':_0x786b('0x28')},{'name':_0x786b('0x29'),'value':_0x786b('0x2a')}];var _0x58f763=_[_0x786b('0x31')](_0x5ce938,[_0x786b('0x2e'),_0x5aafe2['type']])[_0x786b('0x32')];return db[_0x786b('0x58')]['find']({'where':{'name':_0x58f763,'userProfileId':_0x579fbe[_0x786b('0x59')]},'raw':!![]})[_0x786b('0x26')](function(_0x4d274d){if(_0x4d274d&&_0x4d274d['autoAssociation']===0x0){return db[_0x786b('0x33')]['create']({'name':_0x5aafe2['name'],'resourceId':_0x5aafe2['id'],'type':_0x4d274d[_0x786b('0x32')],'sectionId':_0x4d274d['id']},{})[_0x786b('0x26')](function(){return _0xed143f;});}else{return _0xed143f;}})[_0x786b('0x4e')](function(_0x406555){logger[_0x786b('0x35')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x406555);throw _0x406555;});}return _0xed143f;})['then'](respondWithResult(_0x497dfd,0xc9))[_0x786b('0x4e')](handleError(_0x497dfd,null));};exports[_0x786b('0x5a')]=function(_0x16907b,_0x3047be){var _0x1d6691={'where':{'id':_0x16907b[_0x786b('0x5b')]['id']}},_0x12a24c={};_0x12a24c[_0x786b('0x3c')]=_[_0x786b('0x3e')](db['VoiceQueue'][_0x786b('0x39')]);_0x1d6691[_0x786b('0x41')]=_[_0x786b('0x40')](_0x12a24c[_0x786b('0x3c')],qs[_0x786b('0x42')](_0x16907b['query'][_0x786b('0x42')]));_0x1d6691['attributes']=_0x1d6691['attributes']['length']?_0x1d6691[_0x786b('0x41')]:_0x12a24c['model'];if(_0x16907b[_0x786b('0x3d')][_0x786b('0x50')]){_0x1d6691['include']=[{'all':!![]}];}_0x1d6691=_[_0x786b('0x4a')]({},_0x1d6691,_0x16907b['options']);return db[_0x786b('0x38')][_0x786b('0x31')](_0x1d6691)['then'](handleEntityNotFound(_0x3047be,null))[_0x786b('0x26')](function(_0xe3aa89){if(_0xe3aa89){var _0x52107a=_0xe3aa89[_0x786b('0x57')]({'plain':!![]});_0x52107a=qs[_0x786b('0x5c')](_0x52107a,['id',_0x786b('0x5d'),_0x786b('0x5e')]);_0x16907b[_0x786b('0x53')]=_[_0x786b('0x5c')](_0x16907b[_0x786b('0x53')],['id','createdAt','updatedAt']);return db[_0x786b('0x38')][_0x786b('0x52')](_[_0x786b('0x4a')](_0x52107a,_0x16907b['body']),{'include':_0x16907b[_0x786b('0x3d')]['includeAll']?[{'all':!![]}]:undefined})[_0x786b('0x26')](function(_0x402c3a){var _0x2e02c3=_0x16907b[_0x786b('0x54')][_0x786b('0x57')]({'plain':!![]});if(!_0x2e02c3)throw new Error(_0x786b('0x55'));if(_0x2e02c3[_0x786b('0x56')]===_0x786b('0x54')){var _0x578bcf=_0x402c3a[_0x786b('0x57')]({'plain':!![]});var _0x2c69c0=[{'name':'VoiceQueues','value':_0x786b('0x28')},{'name':'QueueCampaigns','value':_0x786b('0x2a')}];var _0x1d33dc=_[_0x786b('0x31')](_0x2c69c0,[_0x786b('0x2e'),_0x578bcf[_0x786b('0x30')]])[_0x786b('0x32')];return db[_0x786b('0x58')][_0x786b('0x31')]({'where':{'name':_0x1d33dc,'userProfileId':_0x2e02c3[_0x786b('0x59')]},'raw':!![]})[_0x786b('0x26')](function(_0x45ed84){if(_0x45ed84&&_0x45ed84[_0x786b('0x5f')]===0x0){return db[_0x786b('0x33')][_0x786b('0x52')]({'name':_0x578bcf[_0x786b('0x32')],'resourceId':_0x578bcf['id'],'type':_0x45ed84[_0x786b('0x32')],'sectionId':_0x45ed84['id']},{})[_0x786b('0x26')](function(){return _0x402c3a;});}else{return _0x402c3a;}})[_0x786b('0x4e')](function(_0x14c39f){logger[_0x786b('0x35')](_0x786b('0x60'),_0x14c39f);throw _0x14c39f;});}return _0x402c3a;});}})['then'](respondWithResult(_0x3047be,0xc9))[_0x786b('0x4e')](handleError(_0x3047be,null));};exports[_0x786b('0x25')]=function(_0x11d129,_0x1fc826){if(_0x11d129[_0x786b('0x53')]['id']){delete _0x11d129[_0x786b('0x53')]['id'];}return db['VoiceQueue'][_0x786b('0x31')]({'where':{'id':_0x11d129[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x1fc826,null))['then'](saveUpdates(_0x11d129[_0x786b('0x53')],null))[_0x786b('0x26')](respondWithResult(_0x1fc826,null))[_0x786b('0x4e')](handleError(_0x1fc826,null));};exports['destroy']=function(_0x158b11,_0x103780){return db[_0x786b('0x38')][_0x786b('0x31')]({'where':{'id':_0x158b11[_0x786b('0x5b')]['id']}})['then'](handleEntityNotFound(_0x103780,null))['then'](removeEntity(_0x103780,null))['catch'](handleError(_0x103780,null));};exports[_0x786b('0x61')]=function(_0x4234ca,_0x33f456,_0x2e9370){var _0x14ab60={'raw':![],'where':{}};var _0xfbd53c={};var _0x1fdfa6={'count':0x0,'rows':[]};return db[_0x786b('0x38')]['findOne']({'where':{'id':_0x4234ca[_0x786b('0x5b')]['id']}})['then'](handleEntityNotFound(_0x33f456,null))['then'](function(_0x23a4b2){if(_0x23a4b2){_0xfbd53c[_0x786b('0x3c')]=_[_0x786b('0x3e')](db[_0x786b('0x62')]['rawAttributes']);_0xfbd53c['query']=_['keys'](_0x4234ca['query']);_0xfbd53c[_0x786b('0x3f')]=_['intersection'](_0xfbd53c[_0x786b('0x3c')],_0xfbd53c[_0x786b('0x3d')]);_0x14ab60[_0x786b('0x41')]=_[_0x786b('0x40')](_0xfbd53c['model'],qs[_0x786b('0x42')](_0x4234ca['query'][_0x786b('0x42')]));_0x14ab60[_0x786b('0x41')]=_0x14ab60[_0x786b('0x41')]['length']?_0x14ab60[_0x786b('0x41')]:_0xfbd53c[_0x786b('0x3c')];if(!_0x4234ca[_0x786b('0x3d')]['hasOwnProperty'](_0x786b('0x45'))){_0x14ab60[_0x786b('0x20')]=qs[_0x786b('0x20')](_0x4234ca[_0x786b('0x3d')]['limit']);_0x14ab60[_0x786b('0x1e')]=qs['offset'](_0x4234ca[_0x786b('0x3d')][_0x786b('0x1e')]);}_0x14ab60[_0x786b('0x46')]=qs[_0x786b('0x47')](_0x4234ca[_0x786b('0x3d')][_0x786b('0x47')]);_0x14ab60[_0x786b('0x48')]=qs[_0x786b('0x3f')](_[_0x786b('0x49')](_0x4234ca[_0x786b('0x3d')],_0xfbd53c[_0x786b('0x3f')]));_0x14ab60[_0x786b('0x48')][_0x786b('0x63')]=_0x23a4b2['id'];if(_0x4234ca['query'][_0x786b('0x2b')]){_0x14ab60[_0x786b('0x48')]=_[_0x786b('0x4a')](_0x14ab60['where'],{'$or':_[_0x786b('0x2d')](_0x14ab60[_0x786b('0x41')],function(_0x2e8eea){var _0x39a2e2={};_0x39a2e2[_0x2e8eea]={'$like':'%'+_0x4234ca['query'][_0x786b('0x2b')]+'%'};return _0x39a2e2;})});}_0x14ab60=_[_0x786b('0x4a')]({},_0x14ab60,_0x4234ca[_0x786b('0x51')]);return db[_0x786b('0x62')][_0x786b('0x21')]({'where':_0x14ab60[_0x786b('0x48')]})[_0x786b('0x26')](function(_0x13c5c3){_0x1fdfa6[_0x786b('0x21')]=_0x13c5c3;if(_0x4234ca[_0x786b('0x3d')][_0x786b('0x50')]){_0x14ab60[_0x786b('0x4b')]=[{'all':!![]}];}return db[_0x786b('0x62')]['findAll'](_0x14ab60);})[_0x786b('0x26')](function(_0x51340f){_0x1fdfa6[_0x786b('0x4d')]=_0x51340f;return _0x1fdfa6;});}})[_0x786b('0x26')](respondWithFilteredResult(_0x33f456,_0x14ab60))[_0x786b('0x4e')](handleError(_0x33f456,null));};exports[_0x786b('0x64')]=function(_0x3df691,_0x2cef07,_0x13b9b2){var _0x5b8974={'raw':!![],'where':{}};var _0x59c729={};var _0x28a388={'count':0x0,'rows':[]};return db[_0x786b('0x38')][_0x786b('0x65')]({'where':{'id':_0x3df691[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x2cef07,null))[_0x786b('0x26')](function(_0x363183){if(_0x363183){_0x59c729[_0x786b('0x3c')]=_['keys'](db['CmHopperHistory'][_0x786b('0x39')]);_0x59c729['query']=_[_0x786b('0x3e')](_0x3df691[_0x786b('0x3d')]);_0x59c729[_0x786b('0x3f')]=_[_0x786b('0x40')](_0x59c729[_0x786b('0x3c')],_0x59c729[_0x786b('0x3d')]);_0x5b8974['attributes']=_[_0x786b('0x40')](_0x59c729[_0x786b('0x3c')],qs[_0x786b('0x42')](_0x3df691[_0x786b('0x3d')][_0x786b('0x42')]));_0x5b8974[_0x786b('0x41')]=_0x5b8974[_0x786b('0x41')][_0x786b('0x43')]?_0x5b8974[_0x786b('0x41')]:_0x59c729[_0x786b('0x3c')];if(!_0x3df691[_0x786b('0x3d')][_0x786b('0x44')](_0x786b('0x45'))){_0x5b8974['limit']=qs[_0x786b('0x20')](_0x3df691[_0x786b('0x3d')][_0x786b('0x20')]);_0x5b8974[_0x786b('0x1e')]=qs['offset'](_0x3df691[_0x786b('0x3d')][_0x786b('0x1e')]);}_0x5b8974[_0x786b('0x46')]=qs[_0x786b('0x47')](_0x3df691[_0x786b('0x3d')][_0x786b('0x47')]);_0x5b8974[_0x786b('0x48')]=qs['filters'](_[_0x786b('0x49')](_0x3df691[_0x786b('0x3d')],_0x59c729['filters']));_0x5b8974['where'][_0x786b('0x63')]=_0x363183['id'];if(_0x3df691[_0x786b('0x3d')][_0x786b('0x2b')]){_0x5b8974['where']=_[_0x786b('0x4a')](_0x5b8974['where'],{'$or':_['map'](_0x5b8974['attributes'],function(_0x306355){var _0x494710={};_0x494710[_0x306355]={'$like':'%'+_0x3df691['query'][_0x786b('0x2b')]+'%'};return _0x494710;})});}_0x5b8974=_[_0x786b('0x4a')]({},_0x5b8974,_0x3df691[_0x786b('0x51')]);return db['CmHopperHistory'][_0x786b('0x21')]({'where':_0x5b8974[_0x786b('0x48')]})['then'](function(_0x1753a8){_0x28a388[_0x786b('0x21')]=_0x1753a8;if(_0x3df691['query'][_0x786b('0x50')]){_0x5b8974['include']=[{'all':!![]}];}return db[_0x786b('0x66')][_0x786b('0x4c')](_0x5b8974);})[_0x786b('0x26')](function(_0x42828c){_0x28a388[_0x786b('0x4d')]=_0x42828c;return _0x28a388;});}})['then'](respondWithFilteredResult(_0x2cef07,_0x5b8974))[_0x786b('0x4e')](handleError(_0x2cef07,null));};exports[_0x786b('0x67')]=function(_0x544e3b,_0x5a1ba5,_0x595dcc){var _0x5f2050={'raw':!![],'where':{}};var _0x13c1fc={};var _0x56dad7={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x786b('0x65')]({'where':{'id':_0x544e3b[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x5a1ba5,null))[_0x786b('0x26')](function(_0x5d51eb){if(_0x5d51eb){_0x13c1fc[_0x786b('0x3c')]=_[_0x786b('0x3e')](db['CmHopperFinal'][_0x786b('0x39')]);_0x13c1fc['query']=_[_0x786b('0x3e')](_0x544e3b[_0x786b('0x3d')]);_0x13c1fc[_0x786b('0x3f')]=_[_0x786b('0x40')](_0x13c1fc[_0x786b('0x3c')],_0x13c1fc[_0x786b('0x3d')]);_0x5f2050['attributes']=_['intersection'](_0x13c1fc[_0x786b('0x3c')],qs[_0x786b('0x42')](_0x544e3b[_0x786b('0x3d')]['fields']));_0x5f2050[_0x786b('0x41')]=_0x5f2050[_0x786b('0x41')]['length']?_0x5f2050[_0x786b('0x41')]:_0x13c1fc['model'];if(!_0x544e3b[_0x786b('0x3d')][_0x786b('0x44')](_0x786b('0x45'))){_0x5f2050['limit']=qs[_0x786b('0x20')](_0x544e3b[_0x786b('0x3d')][_0x786b('0x20')]);_0x5f2050[_0x786b('0x1e')]=qs[_0x786b('0x1e')](_0x544e3b[_0x786b('0x3d')][_0x786b('0x1e')]);}_0x5f2050['order']=qs['sort'](_0x544e3b[_0x786b('0x3d')]['sort']);_0x5f2050[_0x786b('0x48')]=qs[_0x786b('0x3f')](_[_0x786b('0x49')](_0x544e3b[_0x786b('0x3d')],_0x13c1fc[_0x786b('0x3f')]));_0x5f2050[_0x786b('0x48')][_0x786b('0x63')]=_0x5d51eb['id'];if(_0x544e3b[_0x786b('0x3d')][_0x786b('0x2b')]){_0x5f2050[_0x786b('0x48')]=_['merge'](_0x5f2050[_0x786b('0x48')],{'$or':_[_0x786b('0x2d')](_0x5f2050['attributes'],function(_0x5215ca){var _0x3a9b0c={};_0x3a9b0c[_0x5215ca]={'$like':'%'+_0x544e3b[_0x786b('0x3d')]['filter']+'%'};return _0x3a9b0c;})});}_0x5f2050=_['merge']({},_0x5f2050,_0x544e3b[_0x786b('0x51')]);return db[_0x786b('0x68')][_0x786b('0x21')]({'where':_0x5f2050[_0x786b('0x48')]})[_0x786b('0x26')](function(_0x5c961b){_0x56dad7[_0x786b('0x21')]=_0x5c961b;if(_0x544e3b[_0x786b('0x3d')][_0x786b('0x50')]){_0x5f2050[_0x786b('0x4b')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x786b('0x4c')](_0x5f2050);})['then'](function(_0x4c6571){_0x56dad7[_0x786b('0x4d')]=_0x4c6571;return _0x56dad7;});}})[_0x786b('0x26')](respondWithFilteredResult(_0x5a1ba5,_0x5f2050))[_0x786b('0x4e')](handleError(_0x5a1ba5,null));};exports[_0x786b('0x69')]=function(_0x169eab,_0x2db73f,_0x2c2c9b){var _0x46c3e1={'raw':!![],'where':{}};var _0x4cd0b1={};var _0x1ca252={'count':0x0,'rows':[]};return db[_0x786b('0x38')][_0x786b('0x65')]({'where':{'id':_0x169eab['params']['id']}})['then'](handleEntityNotFound(_0x2db73f,null))['then'](function(_0x412367){if(_0x412367){_0x4cd0b1[_0x786b('0x3c')]=_[_0x786b('0x3e')](db[_0x786b('0x6a')][_0x786b('0x39')]);_0x4cd0b1['query']=_[_0x786b('0x3e')](_0x169eab[_0x786b('0x3d')]);_0x4cd0b1[_0x786b('0x3f')]=_['intersection'](_0x4cd0b1[_0x786b('0x3c')],_0x4cd0b1['query']);_0x46c3e1[_0x786b('0x41')]=_['intersection'](_0x4cd0b1['model'],qs['fields'](_0x169eab[_0x786b('0x3d')][_0x786b('0x42')]));_0x46c3e1[_0x786b('0x41')]=_0x46c3e1[_0x786b('0x41')][_0x786b('0x43')]?_0x46c3e1[_0x786b('0x41')]:_0x4cd0b1[_0x786b('0x3c')];if(!_0x169eab[_0x786b('0x3d')][_0x786b('0x44')](_0x786b('0x45'))){_0x46c3e1[_0x786b('0x20')]=qs[_0x786b('0x20')](_0x169eab[_0x786b('0x3d')][_0x786b('0x20')]);_0x46c3e1[_0x786b('0x1e')]=qs[_0x786b('0x1e')](_0x169eab['query']['offset']);}_0x46c3e1['order']=qs['sort'](_0x169eab['query'][_0x786b('0x47')]);_0x46c3e1[_0x786b('0x48')]=qs[_0x786b('0x3f')](_[_0x786b('0x49')](_0x169eab[_0x786b('0x3d')],_0x4cd0b1[_0x786b('0x3f')]));_0x46c3e1[_0x786b('0x48')][_0x786b('0x63')]=_0x412367['id'];if(_0x169eab[_0x786b('0x3d')][_0x786b('0x2b')]){_0x46c3e1[_0x786b('0x48')]=_[_0x786b('0x4a')](_0x46c3e1[_0x786b('0x48')],{'$or':_[_0x786b('0x2d')](_0x46c3e1['attributes'],function(_0x318944){var _0x53586f={};_0x53586f[_0x318944]={'$like':'%'+_0x169eab[_0x786b('0x3d')][_0x786b('0x2b')]+'%'};return _0x53586f;})});}_0x46c3e1=_[_0x786b('0x4a')]({},_0x46c3e1,_0x169eab[_0x786b('0x51')]);return db[_0x786b('0x6a')][_0x786b('0x21')]({'where':_0x46c3e1[_0x786b('0x48')]})[_0x786b('0x26')](function(_0x35f528){_0x1ca252[_0x786b('0x21')]=_0x35f528;if(_0x169eab[_0x786b('0x3d')][_0x786b('0x50')]){_0x46c3e1[_0x786b('0x4b')]=[{'all':!![]}];}return db[_0x786b('0x6a')][_0x786b('0x4c')](_0x46c3e1);})[_0x786b('0x26')](function(_0x4208fb){_0x1ca252[_0x786b('0x4d')]=_0x4208fb;return _0x1ca252;});}})['then'](respondWithFilteredResult(_0x2db73f,_0x46c3e1))['catch'](handleError(_0x2db73f,null));};exports[_0x786b('0x6b')]=function(_0x1a5238,_0x31aaf,_0x15ebfe){var _0x22711b={};var _0xbccfa4={};var _0x3f87f8;var _0x3d6051;return db[_0x786b('0x38')][_0x786b('0x65')]({'where':{'id':_0x1a5238['params']['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x31aaf,null))[_0x786b('0x26')](function(_0xc1b5d6){if(_0xc1b5d6){_0x3f87f8=_0xc1b5d6;_0xbccfa4[_0x786b('0x3c')]=_[_0x786b('0x3e')](db[_0x786b('0x6c')][_0x786b('0x39')]);_0xbccfa4[_0x786b('0x3d')]=_[_0x786b('0x3e')](_0x1a5238[_0x786b('0x3d')]);_0xbccfa4[_0x786b('0x3f')]=_[_0x786b('0x40')](_0xbccfa4[_0x786b('0x3c')],_0xbccfa4['query']);_0x22711b['attributes']=_[_0x786b('0x40')](_0xbccfa4[_0x786b('0x3c')],qs['fields'](_0x1a5238['query'][_0x786b('0x42')]));_0x22711b[_0x786b('0x41')]=_0x22711b['attributes']['length']?_0x22711b[_0x786b('0x41')]:_0xbccfa4[_0x786b('0x3c')];_0x22711b[_0x786b('0x46')]=qs['sort'](_0x1a5238[_0x786b('0x3d')]['sort']);_0x22711b[_0x786b('0x48')]=qs['filters'](_[_0x786b('0x49')](_0x1a5238[_0x786b('0x3d')],_0xbccfa4['filters']));if(_0x1a5238[_0x786b('0x3d')][_0x786b('0x2b')]){_0x22711b[_0x786b('0x48')]=_['merge'](_0x22711b[_0x786b('0x48')],{'$or':_[_0x786b('0x2d')](_0x22711b[_0x786b('0x41')],function(_0x10e69b){var _0x1a49c6={};_0x1a49c6[_0x10e69b]={'$like':'%'+_0x1a5238[_0x786b('0x3d')][_0x786b('0x2b')]+'%'};return _0x1a49c6;})});}_0x22711b=_[_0x786b('0x4a')]({},_0x22711b,_0x1a5238['options']);return _0x3f87f8[_0x786b('0x6b')](_0x22711b);}})['then'](function(_0x1c0edc){if(_0x1c0edc){_0x3d6051=_0x1c0edc['length'];if(!_0x1a5238[_0x786b('0x3d')][_0x786b('0x44')]('nolimit')){_0x22711b[_0x786b('0x20')]=qs['limit'](_0x1a5238['query'][_0x786b('0x20')]);_0x22711b[_0x786b('0x1e')]=qs[_0x786b('0x1e')](_0x1a5238['query'][_0x786b('0x1e')]);}return _0x3f87f8['getTeams'](_0x22711b);}})[_0x786b('0x26')](function(_0x10bc4a){if(_0x10bc4a){return _0x10bc4a?{'count':_0x3d6051,'rows':_0x10bc4a}:null;}})[_0x786b('0x26')](respondWithResult(_0x31aaf,null))['catch'](handleError(_0x31aaf,null));};exports[_0x786b('0x6d')]=function(_0x5c70d4,_0x44e5f6,_0x2cf998){var _0x4e2402=_0x5c70d4[_0x786b('0x53')]['teams'];var _0x519138=_[_0x786b('0x2d')](_0x4e2402,'id');return db[_0x786b('0x6c')][_0x786b('0x4c')]({'where':{'id':_0x519138},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id','name',_0x786b('0x6e'),_0x786b('0x6f'),_0x786b('0x70')],'raw':!![]}]})[_0x786b('0x26')](function(_0x36663c){if(_0x36663c){var _0x29126a=_[_0x786b('0x71')](_0x36663c,function(_0x3aa0e0){var _0x593191=_0x3aa0e0[_0x786b('0x57')]({'plain':!![]});_0x593191[_0x786b('0x72')][_0x786b('0x73')](function(_0x5cf38c){_0x5cf38c[_0x786b('0x74')]=_['find'](_0x4e2402,{'id':_0x593191['id']})[_0x786b('0x74')];});return _0x593191['Agents'];});return db[_0x786b('0x38')][_0x786b('0x31')]({'where':{'id':_0x5c70d4['params']['id']}})['then'](function(_0x3bfcae){return db[_0x786b('0x75')][_0x786b('0x76')](function(_0x2bdb99){return _0x3bfcae['addTeams'](_0x519138,{'transaction':_0x2bdb99})[_0x786b('0x26')](function(){return BPromise['each'](_0x4e2402,function(_0x55b76b){return db[_0x786b('0x77')][_0x786b('0x78')]({'TeamId':_0x55b76b['id'],'VoiceQueueId':_0x5c70d4[_0x786b('0x5b')]['id'],'penalty':_0x55b76b[_0x786b('0x74')]},{'transaction':_0x2bdb99});});})[_0x786b('0x26')](function(){return BPromise['each'](_0x29126a,function(_0x22f4cf){return db[_0x786b('0x79')]['findOrCreate']({'where':{'UserId':_0x22f4cf['id'],'VoiceQueueId':_0x5c70d4['params']['id']},'defaults':{'penalty':_0x22f4cf[_0x786b('0x74')]},'transaction':_0x2bdb99});});})[_0x786b('0x26')](function(){return BPromise[_0x786b('0x7a')](_[_0x786b('0x2b')](_0x29126a,{'online':!![]}),function(_0x25ca97){return db[_0x786b('0x7b')][_0x786b('0x78')]({'membername':_0x25ca97[_0x786b('0x32')],'UserId':_0x25ca97['id'],'queue_name':_0x3bfcae[_0x786b('0x32')],'VoiceQueueId':_0x3bfcae['id'],'interface':_[_0x786b('0x7c')](_0x25ca97[_0x786b('0x70')])?util[_0x786b('0x7d')](_0x786b('0x7e'),_0x25ca97[_0x786b('0x32')]):_0x25ca97[_0x786b('0x70')],'paused':_0x25ca97[_0x786b('0x6f')]||![],'penalty':_0x25ca97[_0x786b('0x74')]},{'transaction':_0x2bdb99});});})[_0x786b('0x26')](function(){_0x29126a[_0x786b('0x73')](function(_0x22daf7){socket[_0x786b('0x7f')]('userVoiceQueue:save',{'UserId':_0x22daf7['id'],'VoiceQueueId':_0x3bfcae['id']});});});});});}})[_0x786b('0x26')](respondWithStatusCode(_0x44e5f6,null))[_0x786b('0x4e')](handleError(_0x44e5f6,null));};exports[_0x786b('0x80')]=function(_0x1ef6ba,_0x38b6fa,_0x1885b9){return db['Team'][_0x786b('0x4c')]({'where':{'id':_0x1ef6ba[_0x786b('0x3d')][_0x786b('0x81')]},'attributes':['id'],'include':[{'model':db[_0x786b('0x82')],'as':_0x786b('0x72'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x38b6fa,null))[_0x786b('0x26')](function(_0x1d91f5){var _0x4d1cef=_['map'](_0x1d91f5,'id');var _0x4ee793=[];var _0x4f21ca=[];var _0x40491b=squel[_0x786b('0x83')]();_0x40491b[_0x786b('0x84')](_0x786b('0x85'))[_0x786b('0x86')]('team_has_voice_queues','tq')[_0x786b('0x87')](_0x786b('0x88'),'ut',_0x786b('0x89'))[_0x786b('0x48')]('VoiceQueueId\x20=\x20?',_0x1ef6ba[_0x786b('0x5b')]['id']);for(var _0x590786=0x0;_0x590786<_0x1d91f5[_0x786b('0x43')];_0x590786+=0x1){let _0x139f10=_0x1d91f5[_0x590786];for(var _0x5e068b=0x0;_0x5e068b<_0x139f10[_0x786b('0x72')]['length'];_0x5e068b+=0x1){let _0x12e940=_0x139f10[_0x786b('0x72')][_0x5e068b];var _0x2216a3=_0x40491b[_0x786b('0x5a')]();_0x2216a3[_0x786b('0x48')](_0x786b('0x8a'),_0x12e940['id']);_0x4f21ca[_0x786b('0x8b')](db[_0x786b('0x75')][_0x786b('0x3d')](_0x2216a3[_0x786b('0x8c')](),{'type':db[_0x786b('0x75')][_0x786b('0x8d')][_0x786b('0x8e')]})[_0x786b('0x26')](function(_0x2bb9ee){if(_0x2bb9ee[_0x786b('0x43')]===0x1){return _0x12e940['id'];}else{var _0x4cf058=_['every'](_[_0x786b('0x2d')](_0x2bb9ee,_0x786b('0x8f')),function(_0x9ad308){return _[_0x786b('0x2f')](_0x4d1cef,_0x9ad308);});if(_0x4cf058){return _0x12e940['id'];}}}));}}return BPromise[_0x786b('0x90')](_0x4f21ca)['then'](function(_0x39cb75){_0x4ee793=_(_0x4ee793)[_0x786b('0x91')](_0x39cb75)[_0x786b('0x92')]()[_0x786b('0x2e')]();return db[_0x786b('0x38')][_0x786b('0x31')]({'where':{'id':_0x1ef6ba['params']['id']}})[_0x786b('0x26')](function(_0x517b9c){return db[_0x786b('0x75')][_0x786b('0x76')](function(_0x2b722d){return _0x517b9c[_0x786b('0x80')](_0x1ef6ba[_0x786b('0x3d')][_0x786b('0x81')],{'transaction':_0x2b722d})[_0x786b('0x26')](function(){if(!_['isEmpty'](_0x4ee793)){return _0x517b9c[_0x786b('0x93')](_0x4ee793,{'transaction':_0x2b722d})[_0x786b('0x26')](function(){return db[_0x786b('0x7b')][_0x786b('0x34')]({'where':{'VoiceQueueId':_0x1ef6ba[_0x786b('0x5b')]['id'],'UserId':_0x4ee793},'transaction':_0x2b722d});});}})[_0x786b('0x26')](function(){_0x4ee793[_0x786b('0x73')](function(_0x5aa9f2){socket[_0x786b('0x7f')](_0x786b('0x94'),{'UserId':_0x5aa9f2,'VoiceQueueId':_0x517b9c['id']});});});});});});})[_0x786b('0x26')](respondWithStatusCode(_0x38b6fa,null))[_0x786b('0x4e')](handleError(_0x38b6fa,null));};exports[_0x786b('0x95')]=function(_0x117add,_0x24cf63,_0x373e75){var _0x22338a,_0x27c288;return db[_0x786b('0x38')][_0x786b('0x31')]({'where':{'id':_0x117add[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x24cf63,null))[_0x786b('0x26')](function(_0x17fe08){if(_0x17fe08){_0x27c288=_0x17fe08;return _0x17fe08[_0x786b('0x95')](_0x117add[_0x786b('0x53')][_0x786b('0x81')],_[_0x786b('0x5c')](_0x117add[_0x786b('0x53')],[_0x786b('0x81'),'id'])||{})[_0x786b('0x96')](function(_0xe0b3e7){for(var _0x2e2361=0x0;_0x2e2361<_0x117add[_0x786b('0x53')][_0x786b('0x81')][_0x786b('0x43')];_0x2e2361+=0x1){socket['emit'](_0x786b('0x97'),{'UserId':Number(_0x117add[_0x786b('0x53')][_0x786b('0x81')][_0x2e2361]),'VoiceQueueId':Number(_0x117add['params']['id'])});}return _0xe0b3e7;});}})[_0x786b('0x26')](function(_0x2bf50b){_0x22338a=_0x2bf50b||[];if(_0x27c288){return db[_0x786b('0x82')][_0x786b('0x4c')]({'where':{'id':_0x117add[_0x786b('0x53')][_0x786b('0x81')]},'attributes':['id',_0x786b('0x32'),_0x786b('0x6e'),_0x786b('0x6f'),'interface'],'raw':!![]});}})[_0x786b('0x26')](function(_0x16c93b){if(!_[_0x786b('0x98')](_0x16c93b)){var _0x1c21e4=[];for(var _0x2d26a4=0x0;_0x2d26a4<_0x16c93b[_0x786b('0x43')];_0x2d26a4++){if(_0x16c93b[_0x2d26a4]['online']){_0x1c21e4[_0x786b('0x8b')](db[_0x786b('0x7b')][_0x786b('0x78')]({'membername':_0x16c93b[_0x2d26a4][_0x786b('0x32')],'UserId':_0x16c93b[_0x2d26a4]['id'],'queue_name':_0x27c288['name'],'VoiceQueueId':_0x27c288['id'],'interface':_['isNil'](_0x16c93b[_0x2d26a4][_0x786b('0x70')])?util[_0x786b('0x7d')]('SIP/%s',_0x16c93b[_0x2d26a4][_0x786b('0x32')]):_0x16c93b[_0x2d26a4]['interface'],'paused':_0x16c93b[_0x2d26a4]['voicePause']||![],'penalty':_0x117add[_0x786b('0x53')][_0x786b('0x74')]||0x0}));}}return BPromise[_0x786b('0x90')](_0x1c21e4);}})[_0x786b('0x26')](function(){return _0x22338a;})[_0x786b('0x26')](respondWithResult(_0x24cf63,null))[_0x786b('0x4e')](handleError(_0x24cf63,null));};exports[_0x786b('0x93')]=function(_0x2e5774,_0x522692,_0x1e6a31){return db[_0x786b('0x38')]['find']({'where':{'id':_0x2e5774[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x522692,null))[_0x786b('0x26')](function(_0x111fa7){if(_0x111fa7){return _0x111fa7['removeAgents'](_0x2e5774[_0x786b('0x3d')][_0x786b('0x81')])[_0x786b('0x26')](function(){if(_[_0x786b('0x99')](_0x2e5774[_0x786b('0x3d')][_0x786b('0x81')])){for(var _0x32aaa5=0x0;_0x32aaa5<_0x2e5774['query']['ids'][_0x786b('0x43')];_0x32aaa5+=0x1){socket[_0x786b('0x7f')]('userVoiceQueue:remove',{'UserId':Number(_0x2e5774['query'][_0x786b('0x81')][_0x32aaa5]),'VoiceQueueId':Number(_0x2e5774[_0x786b('0x5b')]['id'])});}}else{socket[_0x786b('0x7f')]('userVoiceQueue:remove',{'UserId':Number(_0x2e5774['query'][_0x786b('0x81')]),'VoiceQueueId':Number(_0x2e5774[_0x786b('0x5b')]['id'])});}});}})[_0x786b('0x26')](function(_0x304bf1){return db[_0x786b('0x7b')][_0x786b('0x34')]({'where':{'VoiceQueueId':_0x2e5774[_0x786b('0x5b')]['id'],'UserId':_0x2e5774[_0x786b('0x3d')][_0x786b('0x81')]}})[_0x786b('0x26')](function(){return _0x304bf1;});})[_0x786b('0x26')](respondWithStatusCode(_0x522692,null))['catch'](handleError(_0x522692,null));};exports[_0x786b('0x9a')]=function(_0x3120fc,_0x15c650,_0x4574da){var _0x371715={};var _0x3290b8={};var _0x2c1844;var _0x138834;return db[_0x786b('0x38')][_0x786b('0x65')]({'where':{'id':_0x3120fc[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x15c650,null))[_0x786b('0x26')](function(_0x6e2e47){if(_0x6e2e47){_0x2c1844=_0x6e2e47;_0x3290b8[_0x786b('0x3c')]=_[_0x786b('0x3e')](db['User']['rawAttributes']);_0x3290b8[_0x786b('0x3d')]=_[_0x786b('0x3e')](_0x3120fc[_0x786b('0x3d')]);_0x3290b8[_0x786b('0x3f')]=_['intersection'](_0x3290b8[_0x786b('0x3c')],_0x3290b8['query']);_0x371715[_0x786b('0x41')]=_[_0x786b('0x40')](_0x3290b8[_0x786b('0x3c')],qs[_0x786b('0x42')](_0x3120fc['query'][_0x786b('0x42')]));_0x371715[_0x786b('0x41')]=_0x371715[_0x786b('0x41')]['length']?_0x371715['attributes']:_0x3290b8[_0x786b('0x3c')];_0x371715[_0x786b('0x46')]=qs[_0x786b('0x47')](_0x3120fc['query']['sort']);_0x371715[_0x786b('0x48')]=qs['filters'](_[_0x786b('0x49')](_0x3120fc['query'],_0x3290b8['filters']));if(_0x3120fc[_0x786b('0x3d')]['filter']){_0x371715[_0x786b('0x48')]=_['merge'](_0x371715[_0x786b('0x48')],{'$or':_[_0x786b('0x2d')](_0x371715[_0x786b('0x41')],function(_0xcf2f35){var _0x2eee8b={};_0x2eee8b[_0xcf2f35]={'$like':'%'+_0x3120fc[_0x786b('0x3d')][_0x786b('0x2b')]+'%'};return _0x2eee8b;})});}_0x371715=_[_0x786b('0x4a')]({},_0x371715,_0x3120fc['options']);return _0x2c1844[_0x786b('0x9a')](_0x371715);}})['then'](function(_0x24d12a){if(_0x24d12a){_0x138834=_0x24d12a['length'];if(!_0x3120fc[_0x786b('0x3d')][_0x786b('0x44')](_0x786b('0x45'))){_0x371715[_0x786b('0x20')]=qs[_0x786b('0x20')](_0x3120fc[_0x786b('0x3d')]['limit']);_0x371715['offset']=qs[_0x786b('0x1e')](_0x3120fc[_0x786b('0x3d')]['offset']);}return _0x2c1844[_0x786b('0x9a')](_0x371715);}})[_0x786b('0x26')](function(_0x3336ca){if(_0x3336ca){return _0x3336ca?{'count':_0x138834,'rows':_0x3336ca}:null;}})[_0x786b('0x26')](respondWithResult(_0x15c650,null))[_0x786b('0x4e')](handleError(_0x15c650,null));};exports[_0x786b('0x9b')]=function(_0xec01d0,_0x2eba02,_0x16eba0){var _0x1f5fa5={};var _0x244a53={};var _0xac0fab;var _0x58aa3b;return db['VoiceQueue'][_0x786b('0x65')]({'where':{'id':_0xec01d0[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x2eba02,null))['then'](function(_0x4a2151){if(_0x4a2151){_0xac0fab=_0x4a2151;_0x244a53[_0x786b('0x3c')]=_[_0x786b('0x3e')](db[_0x786b('0x7b')]['rawAttributes']);_0x244a53[_0x786b('0x3d')]=_[_0x786b('0x3e')](_0xec01d0['query']);_0x244a53['filters']=_[_0x786b('0x40')](_0x244a53[_0x786b('0x3c')],_0x244a53[_0x786b('0x3d')]);_0x1f5fa5[_0x786b('0x41')]=_[_0x786b('0x40')](_0x244a53['model'],qs[_0x786b('0x42')](_0xec01d0[_0x786b('0x3d')][_0x786b('0x42')]));_0x1f5fa5[_0x786b('0x41')]=_0x1f5fa5[_0x786b('0x41')][_0x786b('0x43')]?_0x1f5fa5['attributes']:_0x244a53[_0x786b('0x3c')];_0x1f5fa5[_0x786b('0x46')]=qs[_0x786b('0x47')](_0xec01d0[_0x786b('0x3d')][_0x786b('0x47')]);_0x1f5fa5[_0x786b('0x48')]=qs['filters'](_[_0x786b('0x49')](_0xec01d0[_0x786b('0x3d')],_0x244a53[_0x786b('0x3f')]));if(_0xec01d0[_0x786b('0x3d')][_0x786b('0x2b')]){_0x1f5fa5[_0x786b('0x48')]=_[_0x786b('0x4a')](_0x1f5fa5[_0x786b('0x48')],{'$or':_['map'](_0x1f5fa5[_0x786b('0x41')],function(_0x1ebc5a){var _0x3dd508={};_0x3dd508[_0x1ebc5a]={'$like':'%'+_0xec01d0['query'][_0x786b('0x2b')]+'%'};return _0x3dd508;})});}_0x1f5fa5=_['merge']({},_0x1f5fa5,_0xec01d0['options']);return _0xac0fab[_0x786b('0x9b')](_0x1f5fa5);}})[_0x786b('0x26')](function(_0x18b49f){if(_0x18b49f){_0x58aa3b=_0x18b49f[_0x786b('0x43')];if(!_0xec01d0[_0x786b('0x3d')][_0x786b('0x44')](_0x786b('0x45'))){_0x1f5fa5[_0x786b('0x20')]=qs['limit'](_0xec01d0[_0x786b('0x3d')][_0x786b('0x20')]);_0x1f5fa5[_0x786b('0x1e')]=qs[_0x786b('0x1e')](_0xec01d0[_0x786b('0x3d')][_0x786b('0x1e')]);}return _0xac0fab['getMembers'](_0x1f5fa5);}})[_0x786b('0x26')](function(_0x5def9c){return _0x5def9c?{'count':_0x58aa3b,'rows':_0x5def9c}:null;})[_0x786b('0x26')](respondWithResult(_0x2eba02,null))[_0x786b('0x4e')](handleError(_0x2eba02,null));};exports[_0x786b('0x9c')]=function(_0x4fe48d,_0x38c778,_0x83fffb){var _0x12ed77={};var _0x4d02b3={};var _0x537f41;var _0x3902dc;return db[_0x786b('0x38')][_0x786b('0x65')]({'where':{'id':_0x4fe48d['params']['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x38c778,null))[_0x786b('0x26')](function(_0x3188c0){if(_0x3188c0){_0x537f41=_0x3188c0;_0x4d02b3[_0x786b('0x3c')]=_[_0x786b('0x3e')](db[_0x786b('0x9d')][_0x786b('0x39')]);_0x4d02b3['query']=_['keys'](_0x4fe48d[_0x786b('0x3d')]);_0x4d02b3[_0x786b('0x3f')]=_[_0x786b('0x40')](_0x4d02b3[_0x786b('0x3c')],_0x4d02b3['query']);_0x12ed77[_0x786b('0x41')]=_[_0x786b('0x40')](_0x4d02b3[_0x786b('0x3c')],qs['fields'](_0x4fe48d[_0x786b('0x3d')][_0x786b('0x42')]));_0x12ed77['attributes']=_0x12ed77[_0x786b('0x41')]['length']?_0x12ed77[_0x786b('0x41')]:_0x4d02b3[_0x786b('0x3c')];_0x12ed77[_0x786b('0x46')]=qs[_0x786b('0x47')](_0x4fe48d[_0x786b('0x3d')][_0x786b('0x47')]);_0x12ed77[_0x786b('0x48')]=qs[_0x786b('0x3f')](_[_0x786b('0x49')](_0x4fe48d[_0x786b('0x3d')],_0x4d02b3[_0x786b('0x3f')]));if(_0x4fe48d[_0x786b('0x3d')][_0x786b('0x2b')]){_0x12ed77[_0x786b('0x48')]=_['merge'](_0x12ed77[_0x786b('0x48')],{'$or':_['map'](_0x12ed77[_0x786b('0x41')],function(_0x12e2d5){var _0x2a20fe={};_0x2a20fe[_0x12e2d5]={'$like':'%'+_0x4fe48d[_0x786b('0x3d')][_0x786b('0x2b')]+'%'};return _0x2a20fe;})});}_0x12ed77=_[_0x786b('0x4a')]({},_0x12ed77,_0x4fe48d[_0x786b('0x51')]);return _0x537f41[_0x786b('0x9c')](_0x12ed77);}})['then'](function(_0x34a4c9){if(_0x34a4c9){_0x3902dc=_0x34a4c9[_0x786b('0x43')];if(!_0x4fe48d[_0x786b('0x3d')]['hasOwnProperty'](_0x786b('0x45'))){_0x12ed77[_0x786b('0x20')]=qs['limit'](_0x4fe48d[_0x786b('0x3d')][_0x786b('0x20')]);_0x12ed77[_0x786b('0x1e')]=qs['offset'](_0x4fe48d[_0x786b('0x3d')][_0x786b('0x1e')]);}return _0x537f41[_0x786b('0x9c')](_0x12ed77);}})[_0x786b('0x26')](function(_0x24721f){if(_0x24721f){return _0x24721f?{'count':_0x3902dc,'rows':_0x24721f}:null;}})['then'](respondWithResult(_0x38c778,null))[_0x786b('0x4e')](handleError(_0x38c778,null));};exports[_0x786b('0x9e')]=function(_0x4a824a,_0x477f9a,_0x53dd67){var _0x7b2d27,_0x16834d;return db[_0x786b('0x38')][_0x786b('0x31')]({'where':{'id':_0x4a824a[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x477f9a,null))[_0x786b('0x26')](function(_0x3e3c5c){if(_0x3e3c5c){_0x16834d=_0x3e3c5c;return _0x3e3c5c[_0x786b('0x9e')](_0x4a824a[_0x786b('0x53')][_0x786b('0x81')],_[_0x786b('0x5c')](_0x4a824a[_0x786b('0x53')],[_0x786b('0x81'),'id'])||{});}return null;})[_0x786b('0x96')](function(_0x48ef5a){var _0x6b5f47;_0x7b2d27=_0x48ef5a||[];var _0x1f696f=[];if(_0x48ef5a){for(var _0x24113f=0x0;_0x24113f<_0x48ef5a[_0x786b('0x43')];_0x24113f+=0x1){var _0xad1a05=_0x48ef5a[_0x24113f]['get']({'plain':!![]});_0x16834d[_0x786b('0x9f')]=_0x4a824a[_0x786b('0x53')][_0x786b('0x9f')]?_0x4a824a[_0x786b('0x53')][_0x786b('0x9f')]:_0x16834d[_0x786b('0x9f')];switch(_0x16834d[_0x786b('0x9f')]){case _0x786b('0xa0'):_0x6b5f47=squel['insert']()[_0x786b('0xa1')](_0x786b('0xa2'))['fromQuery']([_0x786b('0xa3'),_0x786b('0xa4'),_0x786b('0xa5'),'ListId',_0x786b('0x63'),_0x786b('0x5d'),_0x786b('0x5e')],squel[_0x786b('0x83')]()[_0x786b('0x84')](_0x786b('0xa3'),_0x786b('0xa3'))['field']('NOW()',_0x786b('0xa4'))[_0x786b('0x84')]('id',_0x786b('0xa5'))['field'](_0xad1a05[_0x786b('0xa6')][_0x786b('0x8c')](),'ListId')['field'](_0x4a824a[_0x786b('0x5b')]['id'][_0x786b('0x8c')](),'VoiceQueueId')[_0x786b('0x84')](_0x786b('0xa7'),_0x786b('0x5d'))[_0x786b('0x84')](_0x786b('0xa7'),'updatedAt')[_0x786b('0x86')](_0x786b('0xa8'))[_0x786b('0x48')](_0x786b('0xa9'))[_0x786b('0x48')](_0x786b('0xaa'),_0xad1a05['CmListId'][_0x786b('0x8c')]())[_0x786b('0x48')]('phone\x20IS\x20NOT\x20NULL')[_0x786b('0x48')](_0x786b('0xab'),squel[_0x786b('0x83')]()[_0x786b('0x84')](_0x786b('0xac'))[_0x786b('0x86')](_0x786b('0xad'))['where'](_0x786b('0xae'),_0x4a824a[_0x786b('0x5b')]['id']['toString']()))[_0x786b('0x48')]('phone\x20NOT\x20IN\x20(?)',squel[_0x786b('0x83')]()[_0x786b('0x84')](_0x786b('0xaf'))[_0x786b('0x86')]('cm_hopper')[_0x786b('0x48')](_0x786b('0xae'),_0x4a824a[_0x786b('0x5b')]['id']['toString']())))[_0x786b('0x8c')]();break;case _0x786b('0xb0'):_0x6b5f47=squel[_0x786b('0xb1')]()[_0x786b('0xa1')](_0x786b('0xa2'))['fromQuery']([_0x786b('0xa3'),_0x786b('0xa4'),_0x786b('0xa5'),_0x786b('0xb2'),'VoiceQueueId',_0x786b('0x5d'),_0x786b('0x5e')],squel['select']()['field'](_0x786b('0xa3'),_0x786b('0xa3'))[_0x786b('0x84')](_0x786b('0xa7'),'scheduledAt')[_0x786b('0x84')]('id',_0x786b('0xa5'))[_0x786b('0x84')](_0xad1a05['CmListId']['toString'](),_0x786b('0xb2'))[_0x786b('0x84')](_0x4a824a[_0x786b('0x5b')]['id'][_0x786b('0x8c')](),_0x786b('0x63'))[_0x786b('0x84')](_0x786b('0xa7'),_0x786b('0x5d'))[_0x786b('0x84')](_0x786b('0xa7'),_0x786b('0x5e'))['from'](_0x786b('0xa8'))[_0x786b('0x48')](_0x786b('0xa9'))[_0x786b('0x48')](_0x786b('0xaa'),_0xad1a05[_0x786b('0xa6')]['toString']())['where'](_0x786b('0xb3'))[_0x786b('0x48')](_0x786b('0xab'),squel[_0x786b('0x83')]()[_0x786b('0x84')](_0x786b('0xaf'))[_0x786b('0x86')]('cm_hopper')[_0x786b('0x48')](_0x786b('0xae'),_0x4a824a[_0x786b('0x5b')]['id'][_0x786b('0x8c')]())))[_0x786b('0x8c')]();break;default:_0x6b5f47=squel[_0x786b('0xb1')]()[_0x786b('0xa1')](_0x786b('0xa2'))[_0x786b('0xb4')](['phone',_0x786b('0xa4'),_0x786b('0xa5'),'ListId','VoiceQueueId',_0x786b('0x5d'),_0x786b('0x5e')],squel[_0x786b('0x83')]()[_0x786b('0x84')]('phone',_0x786b('0xa3'))[_0x786b('0x84')]('NOW()',_0x786b('0xa4'))[_0x786b('0x84')]('id','ContactId')[_0x786b('0x84')](_0xad1a05[_0x786b('0xa6')]['toString'](),'ListId')[_0x786b('0x84')](_0x4a824a[_0x786b('0x5b')]['id'][_0x786b('0x8c')](),'VoiceQueueId')['field'](_0x786b('0xa7'),_0x786b('0x5d'))['field'](_0x786b('0xa7'),_0x786b('0x5e'))[_0x786b('0x86')](_0x786b('0xa8'))[_0x786b('0x48')](_0x786b('0xa9'))['where'](_0x786b('0xaa'),_0xad1a05['CmListId'][_0x786b('0x8c')]())[_0x786b('0x48')](_0x786b('0xb3')))[_0x786b('0x8c')]();}_0x1f696f[_0x786b('0x8b')](db[_0x786b('0x75')]['query'](_0x6b5f47));}return BPromise[_0x786b('0x90')](_0x1f696f);}})[_0x786b('0x26')](function(){return _0x7b2d27;})['then'](respondWithResult(_0x477f9a,null))[_0x786b('0x4e')](handleError(_0x477f9a,null));};exports[_0x786b('0xb5')]=function(_0x57f201,_0x4b9831,_0x102b05){return db[_0x786b('0x38')][_0x786b('0x31')]({'where':{'id':_0x57f201[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x4b9831,null))[_0x786b('0x26')](function(_0x2b1a8e){if(_0x2b1a8e){return _0x2b1a8e[_0x786b('0xb5')](_0x57f201[_0x786b('0x3d')]['ids']);}})[_0x786b('0x26')](function(_0x24e139){if(_0x24e139){return db['CmHopper'][_0x786b('0x34')]({'where':{'ListId':_0x57f201['query'][_0x786b('0x81')],'VoiceQueueId':_0x57f201[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](function(){return _0x24e139;});}})[_0x786b('0x26')](respondWithStatusCode(_0x4b9831,null))[_0x786b('0x4e')](handleError(_0x4b9831,null));};exports['getBlackLists']=function(_0x19851b,_0x2f4b2c,_0x4a4147){var _0x3ce068={};var _0x296b84={};var _0x4e52eb;var _0xf26cf0;return db[_0x786b('0x38')]['findOne']({'where':{'id':_0x19851b[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x2f4b2c,null))[_0x786b('0x26')](function(_0x446e82){if(_0x446e82){_0x4e52eb=_0x446e82;_0x296b84[_0x786b('0x3c')]=_[_0x786b('0x3e')](db[_0x786b('0x9d')][_0x786b('0x39')]);_0x296b84[_0x786b('0x3d')]=_[_0x786b('0x3e')](_0x19851b[_0x786b('0x3d')]);_0x296b84['filters']=_[_0x786b('0x40')](_0x296b84['model'],_0x296b84[_0x786b('0x3d')]);_0x3ce068[_0x786b('0x41')]=_[_0x786b('0x40')](_0x296b84[_0x786b('0x3c')],qs['fields'](_0x19851b['query'][_0x786b('0x42')]));_0x3ce068['attributes']=_0x3ce068[_0x786b('0x41')][_0x786b('0x43')]?_0x3ce068[_0x786b('0x41')]:_0x296b84['model'];_0x3ce068[_0x786b('0x46')]=qs['sort'](_0x19851b[_0x786b('0x3d')][_0x786b('0x47')]);_0x3ce068[_0x786b('0x48')]=qs[_0x786b('0x3f')](_[_0x786b('0x49')](_0x19851b[_0x786b('0x3d')],_0x296b84[_0x786b('0x3f')]));if(_0x19851b[_0x786b('0x3d')]['filter']){_0x3ce068['where']=_[_0x786b('0x4a')](_0x3ce068['where'],{'$or':_['map'](_0x3ce068[_0x786b('0x41')],function(_0x37c5ab){var _0x5eec60={};_0x5eec60[_0x37c5ab]={'$like':'%'+_0x19851b[_0x786b('0x3d')][_0x786b('0x2b')]+'%'};return _0x5eec60;})});}_0x3ce068=_[_0x786b('0x4a')]({},_0x3ce068,_0x19851b['options']);return _0x4e52eb['getBlackLists'](_0x3ce068);}})[_0x786b('0x26')](function(_0x2165e5){if(_0x2165e5){_0xf26cf0=_0x2165e5[_0x786b('0x43')];if(!_0x19851b[_0x786b('0x3d')][_0x786b('0x44')](_0x786b('0x45'))){_0x3ce068[_0x786b('0x20')]=qs['limit'](_0x19851b[_0x786b('0x3d')][_0x786b('0x20')]);_0x3ce068[_0x786b('0x1e')]=qs[_0x786b('0x1e')](_0x19851b[_0x786b('0x3d')]['offset']);}return _0x4e52eb[_0x786b('0xb6')](_0x3ce068);}})[_0x786b('0x26')](function(_0x28700a){if(_0x28700a){return _0x28700a?{'count':_0xf26cf0,'rows':_0x28700a}:null;}})[_0x786b('0x26')](respondWithResult(_0x2f4b2c,null))[_0x786b('0x4e')](handleError(_0x2f4b2c,null));};exports[_0x786b('0xb7')]=function(_0x5737cc,_0x7053be,_0x8a1353){var _0x267097,_0x2e863f;return db[_0x786b('0x38')][_0x786b('0x31')]({'where':{'id':_0x5737cc[_0x786b('0x5b')]['id']}})['then'](handleEntityNotFound(_0x7053be,null))['then'](function(_0x2847c2){if(_0x2847c2){_0x2e863f=_0x2847c2;return _0x2847c2[_0x786b('0xb7')](_0x5737cc[_0x786b('0x53')][_0x786b('0x81')],_[_0x786b('0x5c')](_0x5737cc[_0x786b('0x53')],['ids','id'])||{});}return null;})[_0x786b('0x96')](function(_0x15a524){var _0x367ef1;_0x267097=_0x15a524||[];var _0xaa0056=[];if(_0x15a524){for(var _0x3302be=0x0;_0x3302be<_0x15a524[_0x786b('0x43')];_0x3302be+=0x1){var _0x33b51=_0x15a524[_0x3302be][_0x786b('0x57')]({'plain':!![]});_0x367ef1=squel[_0x786b('0xb1')]()[_0x786b('0xa1')](_0x786b('0xb8'))[_0x786b('0xb4')]([_0x786b('0xa3'),_0x786b('0xa5'),_0x786b('0xb2'),'VoiceQueueId',_0x786b('0x5d'),_0x786b('0x5e')],squel['select']()[_0x786b('0x84')]('phone','phone')['field']('id',_0x786b('0xa5'))['field'](_0x33b51[_0x786b('0xa6')][_0x786b('0x8c')](),'ListId')[_0x786b('0x84')](_0x5737cc['params']['id'][_0x786b('0x8c')](),'VoiceQueueId')['field'](_0x786b('0xa7'),_0x786b('0x5d'))[_0x786b('0x84')](_0x786b('0xa7'),_0x786b('0x5e'))[_0x786b('0x86')](_0x786b('0xa8'))[_0x786b('0x48')](_0x786b('0xa9'))[_0x786b('0x48')](_0x786b('0xaa'),_0x33b51[_0x786b('0xa6')][_0x786b('0x8c')]())[_0x786b('0x48')]('phone\x20IS\x20NOT\x20NULL'))['toString']();_0xaa0056[_0x786b('0x8b')](db[_0x786b('0x75')][_0x786b('0x3d')](_0x367ef1));}return BPromise[_0x786b('0x90')](_0xaa0056);}})[_0x786b('0x26')](function(){return _0x267097;})[_0x786b('0x26')](respondWithResult(_0x7053be,null))[_0x786b('0x4e')](handleError(_0x7053be,null));};exports[_0x786b('0xb9')]=function(_0x46bb2c,_0x52eb41,_0x56c5e8){return db[_0x786b('0x38')][_0x786b('0x31')]({'where':{'id':_0x46bb2c[_0x786b('0x5b')]['id']}})[_0x786b('0x26')](handleEntityNotFound(_0x52eb41,null))[_0x786b('0x26')](function(_0x547927){if(_0x547927){return _0x547927[_0x786b('0xb9')](_0x46bb2c[_0x786b('0x3d')][_0x786b('0x81')]);}})['then'](function(_0x3f3088){if(_0x3f3088){return db['CmHopperBlack'][_0x786b('0x34')]({'where':{'ListId':_0x46bb2c[_0x786b('0x3d')][_0x786b('0x81')],'VoiceQueueId':_0x46bb2c[_0x786b('0x5b')]['id']}})['then'](function(){return _0x3f3088;});}})[_0x786b('0x26')](respondWithStatusCode(_0x52eb41,null))[_0x786b('0x4e')](handleError(_0x52eb41,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