// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xb511=['limit','count','set','Content-Range','apply','reject','update','then','destroy','get','VoiceQueues','inbound','QueueCampaigns','outbound','ignore','map','value','includes','type','find','name','end','stack','send','index','VoiceQueue','rawAttributes','fieldName','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filters','filter','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','merge','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','UserProfileResource','error','clone','omit','createdAt','body','updatedAt','UserProfileSection','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','findOne','CmHopper','nolimit','VoiceQueueId','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','addTeams','User','voicePause','interface','Agents','forEach','sequelize','transaction','TeamVoiceQueue','upsert','penalty','UserVoiceQueue','each','isNil','format','SIP/%s','emit','removeTeams','ids','field','tq.TeamId','from','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','ut.UserId\x20=\x20?','push','toString','QueryTypes','every','TeamId','all','union','compact','isEmpty','removeAgents','UserVoiceQueueRt','addAgents','spread','online','isArray','userVoiceQueue:remove','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','always','into','cm_hopper','scheduledAt','ContactId','ListId','phone','CmListId','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20NOT\x20IN\x20(?)','select','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','VoiceQueueId\x20=\x20?','onlyIfOpen','insert','fromQuery','phone\x20IS\x20NOT\x20NULL','COALESCE(phone,\x27\x27)','cm_hopper_additional_phones','CmHopperId','OrderBy','h.id','ci.item','ci.OrderBy+1','cm_contact_has_items','h.ContactId=ci.CmContactId','h.scheduledat=?','removeLists','getBlackLists','addBlackLists','NOW()','ListId\x20=\x20?','removeBlackLists','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','path','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','sendStatus','status','json','offset','undefined'];(function(_0x27af45,_0x1b57aa){var _0x18df21=function(_0x4b7679){while(--_0x4b7679){_0x27af45['push'](_0x27af45['shift']());}};_0x18df21(++_0x1b57aa);}(_0xb511,0x165));var _0x1b51=function(_0x52ef28,_0x18b524){_0x52ef28=_0x52ef28-0x0;var _0x9ed1cd=_0xb511[_0x52ef28];return _0x9ed1cd;};'use strict';var emlformat=require(_0x1b51('0x0'));var rimraf=require(_0x1b51('0x1'));var zipdir=require(_0x1b51('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x1b51('0x3'));var moment=require(_0x1b51('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x1b51('0x5'));var util=require(_0x1b51('0x6'));var path=require(_0x1b51('0x7'));var sox=require('sox');var csv=require(_0x1b51('0x8'));var ejs=require(_0x1b51('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x1b51('0xa'));var squel=require(_0x1b51('0xb'));var crypto=require('crypto');var jsforce=require(_0x1b51('0xc'));var deskjs=require(_0x1b51('0xd'));var toCsv=require(_0x1b51('0x8'));var querystring=require(_0x1b51('0xe'));var Papa=require(_0x1b51('0xf'));var Redis=require(_0x1b51('0x10'));var authService=require(_0x1b51('0x11'));var qs=require(_0x1b51('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x1b51('0x13'));var logger=require(_0x1b51('0x14'))(_0x1b51('0x15'));var utils=require(_0x1b51('0x16'));var config=require(_0x1b51('0x17'));var licenseUtil=require(_0x1b51('0x18'));var db=require('../../mysqldb')['db'];config[_0x1b51('0x19')]=_[_0x1b51('0x1a')](config[_0x1b51('0x19')],{'host':_0x1b51('0x1b'),'port':0x18eb});var socket=require(_0x1b51('0x1c'))(new Redis(config[_0x1b51('0x19')]));require(_0x1b51('0x1d'))['register'](socket);function respondWithStatusCode(_0x23f5f7,_0x4f1ad8){_0x4f1ad8=_0x4f1ad8||0xcc;return function(_0x5db91e){if(_0x5db91e){return _0x23f5f7[_0x1b51('0x1e')](_0x4f1ad8);}return _0x23f5f7[_0x1b51('0x1f')](_0x4f1ad8)['end']();};}function respondWithResult(_0x231475,_0x3ece8d){_0x3ece8d=_0x3ece8d||0xc8;return function(_0x3f3850){if(_0x3f3850){return _0x231475['status'](_0x3ece8d)[_0x1b51('0x20')](_0x3f3850);}};}function respondWithFilteredResult(_0x2c2559,_0x24bfc1){return function(_0x1ef8fe){if(_0x1ef8fe){var _0x5deebf=typeof _0x24bfc1[_0x1b51('0x21')]===_0x1b51('0x22')&&typeof _0x24bfc1[_0x1b51('0x23')]==='undefined';var _0x5e222b=_0x1ef8fe[_0x1b51('0x24')];var _0x3ff992=_0x5deebf?0x0:_0x24bfc1['offset'];var _0x2c9e54=_0x5deebf?_0x1ef8fe[_0x1b51('0x24')]:_0x24bfc1['offset']+_0x24bfc1['limit'];var _0x37577c;if(_0x2c9e54>=_0x5e222b){_0x2c9e54=_0x5e222b;_0x37577c=0xc8;}else{_0x37577c=0xce;}_0x2c2559[_0x1b51('0x1f')](_0x37577c);return _0x2c2559[_0x1b51('0x25')](_0x1b51('0x26'),_0x3ff992+'-'+_0x2c9e54+'/'+_0x5e222b)['json'](_0x1ef8fe);}return null;};}function patchUpdates(_0x495173){return function(_0x10bf16){try{jsonpatch[_0x1b51('0x27')](_0x10bf16,_0x495173,!![]);}catch(_0x4c6c6b){return BPromise[_0x1b51('0x28')](_0x4c6c6b);}return _0x10bf16['save']();};}function saveUpdates(_0x4a2e45,_0x3d9178){return function(_0x4b43c8){if(_0x4b43c8){return _0x4b43c8[_0x1b51('0x29')](_0x4a2e45)[_0x1b51('0x2a')](function(_0x54a526){return _0x54a526;});}return null;};}function removeEntity(_0x1ba4d2,_0x68cdfb){return function(_0xdf1239){if(_0xdf1239){return _0xdf1239[_0x1b51('0x2b')]()['then'](function(){var _0x5559cf=_0xdf1239[_0x1b51('0x2c')]({'plain':!![]});var _0x1a6c68=[{'name':_0x1b51('0x2d'),'value':_0x1b51('0x2e'),'ignore':![]},{'name':_0x1b51('0x2f'),'value':_0x1b51('0x30'),'ignore':![]}];var _0x19f20f=_(_0x1a6c68)['filter'](_0x1b51('0x31'))[_0x1b51('0x32')](_0x1b51('0x33'))['value']();if(_[_0x1b51('0x34')](_0x19f20f,_0x5559cf[_0x1b51('0x35')])){return;}var _0x18acad=_[_0x1b51('0x36')](_0x1a6c68,[_0x1b51('0x33'),_0x5559cf[_0x1b51('0x35')]])[_0x1b51('0x37')];return db['UserProfileResource'][_0x1b51('0x2b')]({'where':{'type':_0x18acad,'resourceId':_0x5559cf['id']}})[_0x1b51('0x2a')](function(){return _0xdf1239;});})[_0x1b51('0x2a')](function(){_0x1ba4d2[_0x1b51('0x1f')](0xcc)[_0x1b51('0x38')]();});}};}function handleEntityNotFound(_0x2378c2,_0x38e547){return function(_0xf92a7f){if(!_0xf92a7f){_0x2378c2[_0x1b51('0x1e')](0x194);}return _0xf92a7f;};}function handleError(_0x59858d,_0x11219d){_0x11219d=_0x11219d||0x1f4;return function(_0x3cf225){logger['error'](_0x3cf225[_0x1b51('0x39')]);if(_0x3cf225['name']){delete _0x3cf225[_0x1b51('0x37')];}_0x59858d[_0x1b51('0x1f')](_0x11219d)[_0x1b51('0x3a')](_0x3cf225);};}exports[_0x1b51('0x3b')]=function(_0x5e7447,_0x1e4f24){var _0x1f1b72={},_0x28b0f5={},_0x28b206={'count':0x0,'rows':[]};var _0x58cfaa=_['map'](db[_0x1b51('0x3c')][_0x1b51('0x3d')],function(_0x19896a){return{'name':_0x19896a[_0x1b51('0x3e')],'type':_0x19896a[_0x1b51('0x35')]['key']};});_0x28b0f5[_0x1b51('0x3f')]=_[_0x1b51('0x32')](_0x58cfaa,_0x1b51('0x37'));_0x28b0f5[_0x1b51('0x40')]=_[_0x1b51('0x41')](_0x5e7447[_0x1b51('0x40')]);_0x28b0f5['filters']=_[_0x1b51('0x42')](_0x28b0f5[_0x1b51('0x3f')],_0x28b0f5[_0x1b51('0x40')]);_0x1f1b72[_0x1b51('0x43')]=_['intersection'](_0x28b0f5[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0x5e7447[_0x1b51('0x40')][_0x1b51('0x44')]));_0x1f1b72['attributes']=_0x1f1b72[_0x1b51('0x43')][_0x1b51('0x45')]?_0x1f1b72[_0x1b51('0x43')]:_0x28b0f5['model'];if(!_0x5e7447['query'][_0x1b51('0x46')]('nolimit')){_0x1f1b72[_0x1b51('0x23')]=qs['limit'](_0x5e7447[_0x1b51('0x40')][_0x1b51('0x23')]);_0x1f1b72['offset']=qs[_0x1b51('0x21')](_0x5e7447['query'][_0x1b51('0x21')]);}_0x1f1b72[_0x1b51('0x47')]=qs[_0x1b51('0x48')](_0x5e7447[_0x1b51('0x40')][_0x1b51('0x48')]);_0x1f1b72[_0x1b51('0x49')]=qs['filters'](_[_0x1b51('0x4a')](_0x5e7447[_0x1b51('0x40')],_0x28b0f5[_0x1b51('0x4b')]),_0x58cfaa);if(_0x5e7447[_0x1b51('0x40')][_0x1b51('0x4c')]){_0x1f1b72[_0x1b51('0x49')]=_['merge'](_0x1f1b72[_0x1b51('0x49')],{'$or':_[_0x1b51('0x32')](_0x58cfaa,function(_0x2fd104){if(_0x2fd104[_0x1b51('0x35')]!==_0x1b51('0x4d')){var _0x2661c3={};_0x2661c3[_0x2fd104['name']]={'$like':'%'+_0x5e7447[_0x1b51('0x40')][_0x1b51('0x4c')]+'%'};return _0x2661c3;}})});}_0x1f1b72=_['merge']({},_0x1f1b72,_0x5e7447[_0x1b51('0x4e')]);var _0x15aa1b={'where':_0x1f1b72[_0x1b51('0x49')]};return db[_0x1b51('0x3c')][_0x1b51('0x24')](_0x15aa1b)[_0x1b51('0x2a')](function(_0x2e1101){_0x28b206[_0x1b51('0x24')]=_0x2e1101;if(_0x5e7447[_0x1b51('0x40')][_0x1b51('0x4f')]){_0x1f1b72[_0x1b51('0x50')]=[{'all':!![]}];}return db[_0x1b51('0x3c')][_0x1b51('0x51')](_0x1f1b72);})[_0x1b51('0x2a')](function(_0x526547){_0x28b206[_0x1b51('0x52')]=_0x526547;return _0x28b206;})[_0x1b51('0x2a')](respondWithFilteredResult(_0x1e4f24,_0x1f1b72))[_0x1b51('0x53')](handleError(_0x1e4f24,null));};exports[_0x1b51('0x54')]=function(_0x1a15b3,_0x32079c){var _0x59d227={'raw':![],'where':{'id':_0x1a15b3[_0x1b51('0x55')]['id']}},_0x3ef6af={};_0x3ef6af[_0x1b51('0x3f')]=_[_0x1b51('0x41')](db[_0x1b51('0x3c')][_0x1b51('0x3d')]);_0x3ef6af['query']=_[_0x1b51('0x41')](_0x1a15b3[_0x1b51('0x40')]);_0x3ef6af[_0x1b51('0x4b')]=_['intersection'](_0x3ef6af[_0x1b51('0x3f')],_0x3ef6af[_0x1b51('0x40')]);_0x59d227[_0x1b51('0x43')]=_[_0x1b51('0x42')](_0x3ef6af[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0x1a15b3[_0x1b51('0x40')][_0x1b51('0x44')]));_0x59d227['attributes']=_0x59d227['attributes']['length']?_0x59d227[_0x1b51('0x43')]:_0x3ef6af[_0x1b51('0x3f')];if(_0x1a15b3['query']['includeAll']){_0x59d227['include']=[{'all':!![]}];}_0x59d227=_[_0x1b51('0x56')]({},_0x59d227,_0x1a15b3[_0x1b51('0x4e')]);return db['VoiceQueue'][_0x1b51('0x36')](_0x59d227)[_0x1b51('0x2a')](handleEntityNotFound(_0x32079c,null))[_0x1b51('0x2a')](respondWithResult(_0x32079c,null))['catch'](handleError(_0x32079c,null));};exports[_0x1b51('0x57')]=function(_0xdc909,_0x305468){return db[_0x1b51('0x3c')]['create'](_0xdc909['body'],{})[_0x1b51('0x2a')](function(_0x1e6202){var _0x4ed381=_0xdc909[_0x1b51('0x58')][_0x1b51('0x2c')]({'plain':!![]});if(!_0x4ed381)throw new Error(_0x1b51('0x59'));if(_0x4ed381[_0x1b51('0x5a')]===_0x1b51('0x58')){var _0x1d382d=_0x1e6202['get']({'plain':!![]});var _0x561d09=[{'name':_0x1b51('0x2d'),'value':_0x1b51('0x2e')},{'name':_0x1b51('0x2f'),'value':_0x1b51('0x30')}];var _0x42b94f=_['find'](_0x561d09,['value',_0x1d382d[_0x1b51('0x35')]])['name'];return db['UserProfileSection']['find']({'where':{'name':_0x42b94f,'userProfileId':_0x4ed381[_0x1b51('0x5b')]},'raw':!![]})[_0x1b51('0x2a')](function(_0x381034){if(_0x381034&&_0x381034[_0x1b51('0x5c')]===0x0){return db[_0x1b51('0x5d')][_0x1b51('0x57')]({'name':_0x1d382d[_0x1b51('0x37')],'resourceId':_0x1d382d['id'],'type':_0x381034[_0x1b51('0x37')],'sectionId':_0x381034['id']},{})[_0x1b51('0x2a')](function(){return _0x1e6202;});}else{return _0x1e6202;}})[_0x1b51('0x53')](function(_0x46c866){logger[_0x1b51('0x5e')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x46c866);throw _0x46c866;});}return _0x1e6202;})[_0x1b51('0x2a')](respondWithResult(_0x305468,0xc9))[_0x1b51('0x53')](handleError(_0x305468,null));};exports[_0x1b51('0x5f')]=function(_0x2063c6,_0x875489){var _0x4a6993={'where':{'id':_0x2063c6['params']['id']}},_0x2fb81c={};_0x2fb81c[_0x1b51('0x3f')]=_[_0x1b51('0x41')](db[_0x1b51('0x3c')][_0x1b51('0x3d')]);_0x4a6993[_0x1b51('0x43')]=_[_0x1b51('0x42')](_0x2fb81c[_0x1b51('0x3f')],qs['fields'](_0x2063c6[_0x1b51('0x40')]['fields']));_0x4a6993[_0x1b51('0x43')]=_0x4a6993['attributes']['length']?_0x4a6993[_0x1b51('0x43')]:_0x2fb81c[_0x1b51('0x3f')];if(_0x2063c6['query']['includeAll']){_0x4a6993['include']=[{'all':!![]}];}_0x4a6993=_[_0x1b51('0x56')]({},_0x4a6993,_0x2063c6[_0x1b51('0x4e')]);return db[_0x1b51('0x3c')][_0x1b51('0x36')](_0x4a6993)[_0x1b51('0x2a')](handleEntityNotFound(_0x875489,null))[_0x1b51('0x2a')](function(_0x41922f){if(_0x41922f){var _0x2f919b=_0x41922f[_0x1b51('0x2c')]({'plain':!![]});_0x2f919b=qs[_0x1b51('0x60')](_0x2f919b,['id',_0x1b51('0x61'),'updatedAt']);_0x2063c6['body']=_[_0x1b51('0x60')](_0x2063c6[_0x1b51('0x62')],['id',_0x1b51('0x61'),_0x1b51('0x63')]);return db[_0x1b51('0x3c')][_0x1b51('0x57')](_[_0x1b51('0x56')](_0x2f919b,_0x2063c6[_0x1b51('0x62')]),{'include':_0x2063c6['query'][_0x1b51('0x4f')]?[{'all':!![]}]:undefined})[_0x1b51('0x2a')](function(_0x19b760){var _0x36f2fa=_0x2063c6[_0x1b51('0x58')][_0x1b51('0x2c')]({'plain':!![]});if(!_0x36f2fa)throw new Error(_0x1b51('0x59'));if(_0x36f2fa['role']===_0x1b51('0x58')){var _0x3b0af5=_0x19b760[_0x1b51('0x2c')]({'plain':!![]});var _0x5b51d1=[{'name':_0x1b51('0x2d'),'value':_0x1b51('0x2e')},{'name':_0x1b51('0x2f'),'value':_0x1b51('0x30')}];var _0x2a01a9=_[_0x1b51('0x36')](_0x5b51d1,['value',_0x3b0af5[_0x1b51('0x35')]])[_0x1b51('0x37')];return db[_0x1b51('0x64')]['find']({'where':{'name':_0x2a01a9,'userProfileId':_0x36f2fa['userProfileId']},'raw':!![]})[_0x1b51('0x2a')](function(_0x4cc7ea){if(_0x4cc7ea&&_0x4cc7ea['autoAssociation']===0x0){return db[_0x1b51('0x5d')][_0x1b51('0x57')]({'name':_0x3b0af5[_0x1b51('0x37')],'resourceId':_0x3b0af5['id'],'type':_0x4cc7ea[_0x1b51('0x37')],'sectionId':_0x4cc7ea['id']},{})[_0x1b51('0x2a')](function(){return _0x19b760;});}else{return _0x19b760;}})[_0x1b51('0x53')](function(_0x499d97){logger[_0x1b51('0x5e')](_0x1b51('0x65'),_0x499d97);throw _0x499d97;});}return _0x19b760;});}})[_0x1b51('0x2a')](respondWithResult(_0x875489,0xc9))['catch'](handleError(_0x875489,null));};exports[_0x1b51('0x29')]=function(_0x2fad15,_0xe37dc1){if(_0x2fad15['body']['id']){delete _0x2fad15['body']['id'];}return db[_0x1b51('0x3c')][_0x1b51('0x36')]({'where':{'id':_0x2fad15[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0xe37dc1,null))['then'](saveUpdates(_0x2fad15['body'],null))[_0x1b51('0x2a')](respondWithResult(_0xe37dc1,null))['catch'](handleError(_0xe37dc1,null));};exports[_0x1b51('0x2b')]=function(_0x1f6395,_0x75749){return db['VoiceQueue'][_0x1b51('0x36')]({'where':{'id':_0x1f6395[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x75749,null))[_0x1b51('0x2a')](removeEntity(_0x75749,null))[_0x1b51('0x53')](handleError(_0x75749,null));};exports[_0x1b51('0x66')]=function(_0x5bad63,_0x1e766d,_0x294a8a){var _0x4d61bf={'raw':![],'where':{}};var _0x4ae114={};var _0x1bda95={'count':0x0,'rows':[]};return db[_0x1b51('0x3c')][_0x1b51('0x67')]({'where':{'id':_0x5bad63[_0x1b51('0x55')]['id']}})['then'](handleEntityNotFound(_0x1e766d,null))[_0x1b51('0x2a')](function(_0x4878c7){if(_0x4878c7){_0x4ae114[_0x1b51('0x3f')]=_[_0x1b51('0x41')](db[_0x1b51('0x68')][_0x1b51('0x3d')]);_0x4ae114[_0x1b51('0x40')]=_['keys'](_0x5bad63[_0x1b51('0x40')]);_0x4ae114[_0x1b51('0x4b')]=_['intersection'](_0x4ae114[_0x1b51('0x3f')],_0x4ae114[_0x1b51('0x40')]);_0x4d61bf[_0x1b51('0x43')]=_[_0x1b51('0x42')](_0x4ae114['model'],qs[_0x1b51('0x44')](_0x5bad63[_0x1b51('0x40')][_0x1b51('0x44')]));_0x4d61bf[_0x1b51('0x43')]=_0x4d61bf[_0x1b51('0x43')][_0x1b51('0x45')]?_0x4d61bf[_0x1b51('0x43')]:_0x4ae114['model'];if(!_0x5bad63[_0x1b51('0x40')][_0x1b51('0x46')](_0x1b51('0x69'))){_0x4d61bf[_0x1b51('0x23')]=qs[_0x1b51('0x23')](_0x5bad63['query'][_0x1b51('0x23')]);_0x4d61bf[_0x1b51('0x21')]=qs[_0x1b51('0x21')](_0x5bad63[_0x1b51('0x40')][_0x1b51('0x21')]);}_0x4d61bf[_0x1b51('0x47')]=qs[_0x1b51('0x48')](_0x5bad63['query']['sort']);_0x4d61bf['where']=qs[_0x1b51('0x4b')](_[_0x1b51('0x4a')](_0x5bad63[_0x1b51('0x40')],_0x4ae114[_0x1b51('0x4b')]));_0x4d61bf[_0x1b51('0x49')][_0x1b51('0x6a')]=_0x4878c7['id'];if(_0x5bad63[_0x1b51('0x40')][_0x1b51('0x4c')]){_0x4d61bf[_0x1b51('0x49')]=_[_0x1b51('0x56')](_0x4d61bf[_0x1b51('0x49')],{'$or':_[_0x1b51('0x32')](_0x4d61bf[_0x1b51('0x43')],function(_0x5d99df){var _0x327fb2={};_0x327fb2[_0x5d99df]={'$like':'%'+_0x5bad63[_0x1b51('0x40')]['filter']+'%'};return _0x327fb2;})});}_0x4d61bf=_[_0x1b51('0x56')]({},_0x4d61bf,_0x5bad63[_0x1b51('0x4e')]);return db['CmHopper'][_0x1b51('0x24')]({'where':_0x4d61bf[_0x1b51('0x49')]})['then'](function(_0x1e5d04){_0x1bda95['count']=_0x1e5d04;if(_0x5bad63[_0x1b51('0x40')][_0x1b51('0x4f')]){_0x4d61bf[_0x1b51('0x50')]=[{'all':!![]}];}return db[_0x1b51('0x68')][_0x1b51('0x51')](_0x4d61bf);})[_0x1b51('0x2a')](function(_0x6d9b96){_0x1bda95[_0x1b51('0x52')]=_0x6d9b96;return _0x1bda95;});}})['then'](respondWithFilteredResult(_0x1e766d,_0x4d61bf))[_0x1b51('0x53')](handleError(_0x1e766d,null));};exports['getHopperHistories']=function(_0x3bb690,_0x11ea3b,_0x1de9bd){var _0x446563={'raw':!![],'where':{}};var _0x1eaeeb={};var _0x237d0c={'count':0x0,'rows':[]};return db[_0x1b51('0x3c')][_0x1b51('0x67')]({'where':{'id':_0x3bb690[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x11ea3b,null))[_0x1b51('0x2a')](function(_0x1fafbc){if(_0x1fafbc){_0x1eaeeb['model']=_[_0x1b51('0x41')](db['CmHopperHistory'][_0x1b51('0x3d')]);_0x1eaeeb['query']=_[_0x1b51('0x41')](_0x3bb690[_0x1b51('0x40')]);_0x1eaeeb[_0x1b51('0x4b')]=_[_0x1b51('0x42')](_0x1eaeeb[_0x1b51('0x3f')],_0x1eaeeb[_0x1b51('0x40')]);_0x446563[_0x1b51('0x43')]=_[_0x1b51('0x42')](_0x1eaeeb[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0x3bb690[_0x1b51('0x40')]['fields']));_0x446563[_0x1b51('0x43')]=_0x446563['attributes']['length']?_0x446563[_0x1b51('0x43')]:_0x1eaeeb[_0x1b51('0x3f')];if(!_0x3bb690[_0x1b51('0x40')]['hasOwnProperty'](_0x1b51('0x69'))){_0x446563['limit']=qs['limit'](_0x3bb690[_0x1b51('0x40')][_0x1b51('0x23')]);_0x446563[_0x1b51('0x21')]=qs[_0x1b51('0x21')](_0x3bb690[_0x1b51('0x40')][_0x1b51('0x21')]);}_0x446563[_0x1b51('0x47')]=qs[_0x1b51('0x48')](_0x3bb690[_0x1b51('0x40')][_0x1b51('0x48')]);_0x446563['where']=qs[_0x1b51('0x4b')](_[_0x1b51('0x4a')](_0x3bb690[_0x1b51('0x40')],_0x1eaeeb[_0x1b51('0x4b')]));_0x446563['where']['VoiceQueueId']=_0x1fafbc['id'];if(_0x3bb690[_0x1b51('0x40')]['filter']){_0x446563['where']=_[_0x1b51('0x56')](_0x446563[_0x1b51('0x49')],{'$or':_[_0x1b51('0x32')](_0x446563[_0x1b51('0x43')],function(_0x1c4239){var _0x176299={};_0x176299[_0x1c4239]={'$like':'%'+_0x3bb690[_0x1b51('0x40')][_0x1b51('0x4c')]+'%'};return _0x176299;})});}_0x446563=_[_0x1b51('0x56')]({},_0x446563,_0x3bb690[_0x1b51('0x4e')]);return db['CmHopperHistory'][_0x1b51('0x24')]({'where':_0x446563[_0x1b51('0x49')]})['then'](function(_0x57a887){_0x237d0c[_0x1b51('0x24')]=_0x57a887;if(_0x3bb690[_0x1b51('0x40')][_0x1b51('0x4f')]){_0x446563[_0x1b51('0x50')]=[{'all':!![]}];}return db[_0x1b51('0x6b')][_0x1b51('0x51')](_0x446563);})['then'](function(_0x47fda3){_0x237d0c['rows']=_0x47fda3;return _0x237d0c;});}})[_0x1b51('0x2a')](respondWithFilteredResult(_0x11ea3b,_0x446563))['catch'](handleError(_0x11ea3b,null));};exports[_0x1b51('0x6c')]=function(_0x3458fd,_0x2ae6cc,_0x3a3e26){var _0x8903a3={'raw':!![],'where':{}};var _0x1a73a5={};var _0x576cb6={'count':0x0,'rows':[]};return db[_0x1b51('0x3c')][_0x1b51('0x67')]({'where':{'id':_0x3458fd['params']['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x2ae6cc,null))[_0x1b51('0x2a')](function(_0x42885b){if(_0x42885b){_0x1a73a5['model']=_[_0x1b51('0x41')](db[_0x1b51('0x6d')][_0x1b51('0x3d')]);_0x1a73a5[_0x1b51('0x40')]=_['keys'](_0x3458fd[_0x1b51('0x40')]);_0x1a73a5[_0x1b51('0x4b')]=_['intersection'](_0x1a73a5[_0x1b51('0x3f')],_0x1a73a5[_0x1b51('0x40')]);_0x8903a3['attributes']=_[_0x1b51('0x42')](_0x1a73a5[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0x3458fd[_0x1b51('0x40')]['fields']));_0x8903a3[_0x1b51('0x43')]=_0x8903a3[_0x1b51('0x43')][_0x1b51('0x45')]?_0x8903a3[_0x1b51('0x43')]:_0x1a73a5[_0x1b51('0x3f')];if(!_0x3458fd['query']['hasOwnProperty'](_0x1b51('0x69'))){_0x8903a3[_0x1b51('0x23')]=qs[_0x1b51('0x23')](_0x3458fd[_0x1b51('0x40')][_0x1b51('0x23')]);_0x8903a3['offset']=qs[_0x1b51('0x21')](_0x3458fd['query'][_0x1b51('0x21')]);}_0x8903a3[_0x1b51('0x47')]=qs[_0x1b51('0x48')](_0x3458fd['query'][_0x1b51('0x48')]);_0x8903a3['where']=qs[_0x1b51('0x4b')](_['pick'](_0x3458fd['query'],_0x1a73a5[_0x1b51('0x4b')]));_0x8903a3[_0x1b51('0x49')]['VoiceQueueId']=_0x42885b['id'];if(_0x3458fd[_0x1b51('0x40')][_0x1b51('0x4c')]){_0x8903a3[_0x1b51('0x49')]=_['merge'](_0x8903a3['where'],{'$or':_[_0x1b51('0x32')](_0x8903a3['attributes'],function(_0x4801aa){var _0x40123a={};_0x40123a[_0x4801aa]={'$like':'%'+_0x3458fd[_0x1b51('0x40')]['filter']+'%'};return _0x40123a;})});}_0x8903a3=_['merge']({},_0x8903a3,_0x3458fd[_0x1b51('0x4e')]);return db[_0x1b51('0x6d')][_0x1b51('0x24')]({'where':_0x8903a3['where']})[_0x1b51('0x2a')](function(_0x14d61a){_0x576cb6['count']=_0x14d61a;if(_0x3458fd[_0x1b51('0x40')][_0x1b51('0x4f')]){_0x8903a3['include']=[{'all':!![]}];}return db[_0x1b51('0x6d')]['findAll'](_0x8903a3);})[_0x1b51('0x2a')](function(_0x4ca543){_0x576cb6[_0x1b51('0x52')]=_0x4ca543;return _0x576cb6;});}})[_0x1b51('0x2a')](respondWithFilteredResult(_0x2ae6cc,_0x8903a3))[_0x1b51('0x53')](handleError(_0x2ae6cc,null));};exports[_0x1b51('0x6e')]=function(_0x3f7e2d,_0x4bbc93,_0x3fdcd0){var _0x2a6c51={'raw':!![],'where':{}};var _0x419b32={};var _0x4494bf={'count':0x0,'rows':[]};return db[_0x1b51('0x3c')][_0x1b51('0x67')]({'where':{'id':_0x3f7e2d[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x4bbc93,null))[_0x1b51('0x2a')](function(_0x1fd88e){if(_0x1fd88e){_0x419b32['model']=_[_0x1b51('0x41')](db[_0x1b51('0x6f')][_0x1b51('0x3d')]);_0x419b32[_0x1b51('0x40')]=_['keys'](_0x3f7e2d['query']);_0x419b32[_0x1b51('0x4b')]=_['intersection'](_0x419b32[_0x1b51('0x3f')],_0x419b32[_0x1b51('0x40')]);_0x2a6c51[_0x1b51('0x43')]=_['intersection'](_0x419b32[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0x3f7e2d[_0x1b51('0x40')][_0x1b51('0x44')]));_0x2a6c51[_0x1b51('0x43')]=_0x2a6c51[_0x1b51('0x43')][_0x1b51('0x45')]?_0x2a6c51[_0x1b51('0x43')]:_0x419b32[_0x1b51('0x3f')];if(!_0x3f7e2d['query'][_0x1b51('0x46')](_0x1b51('0x69'))){_0x2a6c51[_0x1b51('0x23')]=qs[_0x1b51('0x23')](_0x3f7e2d[_0x1b51('0x40')][_0x1b51('0x23')]);_0x2a6c51[_0x1b51('0x21')]=qs[_0x1b51('0x21')](_0x3f7e2d[_0x1b51('0x40')]['offset']);}_0x2a6c51['order']=qs[_0x1b51('0x48')](_0x3f7e2d['query'][_0x1b51('0x48')]);_0x2a6c51[_0x1b51('0x49')]=qs[_0x1b51('0x4b')](_[_0x1b51('0x4a')](_0x3f7e2d[_0x1b51('0x40')],_0x419b32[_0x1b51('0x4b')]));_0x2a6c51[_0x1b51('0x49')][_0x1b51('0x6a')]=_0x1fd88e['id'];if(_0x3f7e2d[_0x1b51('0x40')][_0x1b51('0x4c')]){_0x2a6c51[_0x1b51('0x49')]=_[_0x1b51('0x56')](_0x2a6c51[_0x1b51('0x49')],{'$or':_['map'](_0x2a6c51[_0x1b51('0x43')],function(_0xc082e9){var _0x26e6bc={};_0x26e6bc[_0xc082e9]={'$like':'%'+_0x3f7e2d[_0x1b51('0x40')][_0x1b51('0x4c')]+'%'};return _0x26e6bc;})});}_0x2a6c51=_[_0x1b51('0x56')]({},_0x2a6c51,_0x3f7e2d['options']);return db[_0x1b51('0x6f')][_0x1b51('0x24')]({'where':_0x2a6c51[_0x1b51('0x49')]})['then'](function(_0x26fe0b){_0x4494bf[_0x1b51('0x24')]=_0x26fe0b;if(_0x3f7e2d['query'][_0x1b51('0x4f')]){_0x2a6c51[_0x1b51('0x50')]=[{'all':!![]}];}return db[_0x1b51('0x6f')][_0x1b51('0x51')](_0x2a6c51);})[_0x1b51('0x2a')](function(_0x2e72a0){_0x4494bf[_0x1b51('0x52')]=_0x2e72a0;return _0x4494bf;});}})[_0x1b51('0x2a')](respondWithFilteredResult(_0x4bbc93,_0x2a6c51))['catch'](handleError(_0x4bbc93,null));};exports['getTeams']=function(_0x465fa3,_0x404289,_0x2de545){var _0x2558c1={};var _0x5c498f={};var _0x1c07be;var _0x1e59ca;return db[_0x1b51('0x3c')]['findOne']({'where':{'id':_0x465fa3['params']['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x404289,null))[_0x1b51('0x2a')](function(_0x4c9777){if(_0x4c9777){_0x1c07be=_0x4c9777;_0x5c498f[_0x1b51('0x3f')]=_[_0x1b51('0x41')](db['Team'][_0x1b51('0x3d')]);_0x5c498f['query']=_[_0x1b51('0x41')](_0x465fa3[_0x1b51('0x40')]);_0x5c498f['filters']=_['intersection'](_0x5c498f['model'],_0x5c498f['query']);_0x2558c1['attributes']=_[_0x1b51('0x42')](_0x5c498f[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0x465fa3[_0x1b51('0x40')][_0x1b51('0x44')]));_0x2558c1[_0x1b51('0x43')]=_0x2558c1[_0x1b51('0x43')][_0x1b51('0x45')]?_0x2558c1['attributes']:_0x5c498f['model'];_0x2558c1[_0x1b51('0x47')]=qs[_0x1b51('0x48')](_0x465fa3[_0x1b51('0x40')][_0x1b51('0x48')]);_0x2558c1['where']=qs[_0x1b51('0x4b')](_[_0x1b51('0x4a')](_0x465fa3[_0x1b51('0x40')],_0x5c498f[_0x1b51('0x4b')]));if(_0x465fa3[_0x1b51('0x40')]['filter']){_0x2558c1[_0x1b51('0x49')]=_['merge'](_0x2558c1[_0x1b51('0x49')],{'$or':_[_0x1b51('0x32')](_0x2558c1[_0x1b51('0x43')],function(_0x292c07){var _0x43fc7f={};_0x43fc7f[_0x292c07]={'$like':'%'+_0x465fa3[_0x1b51('0x40')][_0x1b51('0x4c')]+'%'};return _0x43fc7f;})});}_0x2558c1=_[_0x1b51('0x56')]({},_0x2558c1,_0x465fa3[_0x1b51('0x4e')]);return _0x1c07be[_0x1b51('0x70')](_0x2558c1);}})[_0x1b51('0x2a')](function(_0x220338){if(_0x220338){_0x1e59ca=_0x220338['length'];if(!_0x465fa3['query'][_0x1b51('0x46')]('nolimit')){_0x2558c1[_0x1b51('0x23')]=qs['limit'](_0x465fa3[_0x1b51('0x40')][_0x1b51('0x23')]);_0x2558c1['offset']=qs[_0x1b51('0x21')](_0x465fa3[_0x1b51('0x40')][_0x1b51('0x21')]);}return _0x1c07be[_0x1b51('0x70')](_0x2558c1);}})['then'](function(_0x3d3d22){if(_0x3d3d22){return _0x3d3d22?{'count':_0x1e59ca,'rows':_0x3d3d22}:null;}})[_0x1b51('0x2a')](respondWithResult(_0x404289,null))[_0x1b51('0x53')](handleError(_0x404289,null));};exports[_0x1b51('0x71')]=function(_0x4133f0,_0x45f7fc,_0x3c4f04){var _0x5ef452=_0x4133f0[_0x1b51('0x62')]['teams'];var _0x39b541=_[_0x1b51('0x32')](_0x5ef452,'id');return db['Team'][_0x1b51('0x51')]({'where':{'id':_0x39b541},'attributes':['id'],'include':[{'model':db[_0x1b51('0x72')],'as':'Agents','attributes':['id',_0x1b51('0x37'),'online',_0x1b51('0x73'),_0x1b51('0x74')],'raw':!![]}]})[_0x1b51('0x2a')](function(_0x49b91a){if(_0x49b91a){var _0x58a4db=_['flatMap'](_0x49b91a,function(_0x4c1866){var _0x414fae=_0x4c1866['get']({'plain':!![]});_0x414fae[_0x1b51('0x75')][_0x1b51('0x76')](function(_0x5d99c4){_0x5d99c4['penalty']=_[_0x1b51('0x36')](_0x5ef452,{'id':_0x414fae['id']})['penalty'];});return _0x414fae[_0x1b51('0x75')];});return db[_0x1b51('0x3c')][_0x1b51('0x36')]({'where':{'id':_0x4133f0[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](function(_0x151385){return db[_0x1b51('0x77')][_0x1b51('0x78')](function(_0x172854){return _0x151385[_0x1b51('0x71')](_0x39b541,{'transaction':_0x172854})[_0x1b51('0x2a')](function(){return BPromise['each'](_0x5ef452,function(_0x3a2e8f){return db[_0x1b51('0x79')][_0x1b51('0x7a')]({'TeamId':_0x3a2e8f['id'],'VoiceQueueId':_0x4133f0[_0x1b51('0x55')]['id'],'penalty':_0x3a2e8f[_0x1b51('0x7b')]},{'transaction':_0x172854});});})[_0x1b51('0x2a')](function(){return BPromise['each'](_0x58a4db,function(_0x40dba2){return db[_0x1b51('0x7c')]['findOrCreate']({'where':{'UserId':_0x40dba2['id'],'VoiceQueueId':_0x4133f0['params']['id']},'defaults':{'penalty':_0x40dba2[_0x1b51('0x7b')]},'transaction':_0x172854});});})[_0x1b51('0x2a')](function(){return BPromise[_0x1b51('0x7d')](_['filter'](_0x58a4db,{'online':!![]}),function(_0x53115d){return db['UserVoiceQueueRt']['upsert']({'membername':_0x53115d[_0x1b51('0x37')],'UserId':_0x53115d['id'],'queue_name':_0x151385[_0x1b51('0x37')],'VoiceQueueId':_0x151385['id'],'interface':_[_0x1b51('0x7e')](_0x53115d['interface'])?util[_0x1b51('0x7f')](_0x1b51('0x80'),_0x53115d[_0x1b51('0x37')]):_0x53115d['interface'],'paused':_0x53115d[_0x1b51('0x73')]||![],'penalty':_0x53115d[_0x1b51('0x7b')]},{'transaction':_0x172854});});})['then'](function(){_0x58a4db['forEach'](function(_0x4f308d){socket[_0x1b51('0x81')]('userVoiceQueue:save',{'UserId':_0x4f308d['id'],'VoiceQueueId':_0x151385['id']});});});});});}})['then'](respondWithStatusCode(_0x45f7fc,null))[_0x1b51('0x53')](handleError(_0x45f7fc,null));};exports[_0x1b51('0x82')]=function(_0x43872a,_0x12a964,_0x25304c){return db['Team'][_0x1b51('0x51')]({'where':{'id':_0x43872a[_0x1b51('0x40')][_0x1b51('0x83')]},'attributes':['id'],'include':[{'model':db[_0x1b51('0x72')],'as':_0x1b51('0x75'),'attributes':['id'],'raw':!![]}]})[_0x1b51('0x2a')](handleEntityNotFound(_0x12a964,null))['then'](function(_0x57a6d2){var _0x57f45e=_['map'](_0x57a6d2,'id');var _0x53e9e0=[];var _0x4c9e77=[];var _0x4bb233=squel['select']();_0x4bb233[_0x1b51('0x84')](_0x1b51('0x85'))[_0x1b51('0x86')]('team_has_voice_queues','tq')[_0x1b51('0x87')](_0x1b51('0x88'),'ut',_0x1b51('0x89'))[_0x1b51('0x49')]('VoiceQueueId\x20=\x20?',_0x43872a[_0x1b51('0x55')]['id']);for(var _0x47d70c=0x0;_0x47d70c<_0x57a6d2[_0x1b51('0x45')];_0x47d70c+=0x1){let _0x52cb45=_0x57a6d2[_0x47d70c];for(var _0x4b2b5d=0x0;_0x4b2b5d<_0x52cb45[_0x1b51('0x75')][_0x1b51('0x45')];_0x4b2b5d+=0x1){let _0x40cdcd=_0x52cb45[_0x1b51('0x75')][_0x4b2b5d];var _0x38cb67=_0x4bb233[_0x1b51('0x5f')]();_0x38cb67['where'](_0x1b51('0x8a'),_0x40cdcd['id']);_0x4c9e77[_0x1b51('0x8b')](db[_0x1b51('0x77')][_0x1b51('0x40')](_0x38cb67[_0x1b51('0x8c')](),{'type':db[_0x1b51('0x77')][_0x1b51('0x8d')]['SELECT']})[_0x1b51('0x2a')](function(_0x58777b){if(_0x58777b[_0x1b51('0x45')]===0x1){return _0x40cdcd['id'];}else{var _0x3da5b5=_[_0x1b51('0x8e')](_[_0x1b51('0x32')](_0x58777b,_0x1b51('0x8f')),function(_0x1168d6){return _['includes'](_0x57f45e,_0x1168d6);});if(_0x3da5b5){return _0x40cdcd['id'];}}}));}}return BPromise[_0x1b51('0x90')](_0x4c9e77)['then'](function(_0x38609b){_0x53e9e0=_(_0x53e9e0)[_0x1b51('0x91')](_0x38609b)[_0x1b51('0x92')]()['value']();return db['VoiceQueue'][_0x1b51('0x36')]({'where':{'id':_0x43872a[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](function(_0x209c81){return db[_0x1b51('0x77')][_0x1b51('0x78')](function(_0x2b808d){return _0x209c81[_0x1b51('0x82')](_0x43872a[_0x1b51('0x40')][_0x1b51('0x83')],{'transaction':_0x2b808d})[_0x1b51('0x2a')](function(){if(!_[_0x1b51('0x93')](_0x53e9e0)){return _0x209c81[_0x1b51('0x94')](_0x53e9e0,{'transaction':_0x2b808d})[_0x1b51('0x2a')](function(){return db[_0x1b51('0x95')][_0x1b51('0x2b')]({'where':{'VoiceQueueId':_0x43872a[_0x1b51('0x55')]['id'],'UserId':_0x53e9e0},'transaction':_0x2b808d});});}})['then'](function(){_0x53e9e0['forEach'](function(_0x1e46ef){socket[_0x1b51('0x81')]('userVoiceQueue:remove',{'UserId':_0x1e46ef,'VoiceQueueId':_0x209c81['id']});});});});});});})['then'](respondWithStatusCode(_0x12a964,null))[_0x1b51('0x53')](handleError(_0x12a964,null));};exports['addAgents']=function(_0x22a035,_0x474021,_0x519dac){var _0x2fef49,_0x48bdc4;return db[_0x1b51('0x3c')][_0x1b51('0x36')]({'where':{'id':_0x22a035[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x474021,null))[_0x1b51('0x2a')](function(_0x5413d8){if(_0x5413d8){_0x48bdc4=_0x5413d8;return _0x5413d8[_0x1b51('0x96')](_0x22a035['body'][_0x1b51('0x83')],_[_0x1b51('0x60')](_0x22a035[_0x1b51('0x62')],[_0x1b51('0x83'),'id'])||{})[_0x1b51('0x97')](function(_0x30da37){for(var _0x5514d0=0x0;_0x5514d0<_0x22a035[_0x1b51('0x62')]['ids']['length'];_0x5514d0+=0x1){socket[_0x1b51('0x81')]('userVoiceQueue:save',{'UserId':Number(_0x22a035[_0x1b51('0x62')]['ids'][_0x5514d0]),'VoiceQueueId':Number(_0x22a035[_0x1b51('0x55')]['id'])});}return _0x30da37;});}})[_0x1b51('0x2a')](function(_0xb614c6){_0x2fef49=_0xb614c6||[];if(_0x48bdc4){return db[_0x1b51('0x72')][_0x1b51('0x51')]({'where':{'id':_0x22a035[_0x1b51('0x62')]['ids']},'attributes':['id','name',_0x1b51('0x98'),_0x1b51('0x73'),_0x1b51('0x74')],'raw':!![]});}})[_0x1b51('0x2a')](function(_0x39aedc){if(!_[_0x1b51('0x93')](_0x39aedc)){var _0x1914f6=[];for(var _0x33d80d=0x0;_0x33d80d<_0x39aedc['length'];_0x33d80d++){if(_0x39aedc[_0x33d80d]['online']){_0x1914f6['push'](db[_0x1b51('0x95')][_0x1b51('0x7a')]({'membername':_0x39aedc[_0x33d80d][_0x1b51('0x37')],'UserId':_0x39aedc[_0x33d80d]['id'],'queue_name':_0x48bdc4[_0x1b51('0x37')],'VoiceQueueId':_0x48bdc4['id'],'interface':_[_0x1b51('0x7e')](_0x39aedc[_0x33d80d][_0x1b51('0x74')])?util['format'](_0x1b51('0x80'),_0x39aedc[_0x33d80d][_0x1b51('0x37')]):_0x39aedc[_0x33d80d]['interface'],'paused':_0x39aedc[_0x33d80d][_0x1b51('0x73')]||![],'penalty':_0x22a035[_0x1b51('0x62')]['penalty']||0x0}));}}return BPromise['all'](_0x1914f6);}})[_0x1b51('0x2a')](function(){return _0x2fef49;})[_0x1b51('0x2a')](respondWithResult(_0x474021,null))[_0x1b51('0x53')](handleError(_0x474021,null));};exports[_0x1b51('0x94')]=function(_0x170688,_0x41e674,_0x4a8f34){return db['VoiceQueue'][_0x1b51('0x36')]({'where':{'id':_0x170688[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x41e674,null))[_0x1b51('0x2a')](function(_0xc13904){if(_0xc13904){return _0xc13904[_0x1b51('0x94')](_0x170688[_0x1b51('0x40')][_0x1b51('0x83')])[_0x1b51('0x2a')](function(){if(_[_0x1b51('0x99')](_0x170688[_0x1b51('0x40')][_0x1b51('0x83')])){for(var _0x5cc441=0x0;_0x5cc441<_0x170688[_0x1b51('0x40')][_0x1b51('0x83')][_0x1b51('0x45')];_0x5cc441+=0x1){socket[_0x1b51('0x81')](_0x1b51('0x9a'),{'UserId':Number(_0x170688[_0x1b51('0x40')][_0x1b51('0x83')][_0x5cc441]),'VoiceQueueId':Number(_0x170688[_0x1b51('0x55')]['id'])});}}else{socket['emit'](_0x1b51('0x9a'),{'UserId':Number(_0x170688[_0x1b51('0x40')]['ids']),'VoiceQueueId':Number(_0x170688[_0x1b51('0x55')]['id'])});}});}})[_0x1b51('0x2a')](function(_0x48f542){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x170688[_0x1b51('0x55')]['id'],'UserId':_0x170688[_0x1b51('0x40')][_0x1b51('0x83')]}})[_0x1b51('0x2a')](function(){return _0x48f542;});})['then'](respondWithStatusCode(_0x41e674,null))[_0x1b51('0x53')](handleError(_0x41e674,null));};exports[_0x1b51('0x9b')]=function(_0x1d53e7,_0x521d25,_0x10234d){var _0x168f1e={};var _0x38857e={};var _0x1d605a;var _0x3261bc;return db[_0x1b51('0x3c')][_0x1b51('0x67')]({'where':{'id':_0x1d53e7[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x521d25,null))[_0x1b51('0x2a')](function(_0x5ecc32){if(_0x5ecc32){_0x1d605a=_0x5ecc32;_0x38857e[_0x1b51('0x3f')]=_[_0x1b51('0x41')](db[_0x1b51('0x72')][_0x1b51('0x3d')]);_0x38857e[_0x1b51('0x40')]=_['keys'](_0x1d53e7[_0x1b51('0x40')]);_0x38857e[_0x1b51('0x4b')]=_[_0x1b51('0x42')](_0x38857e['model'],_0x38857e[_0x1b51('0x40')]);_0x168f1e['attributes']=_[_0x1b51('0x42')](_0x38857e[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0x1d53e7[_0x1b51('0x40')][_0x1b51('0x44')]));_0x168f1e[_0x1b51('0x43')]=_0x168f1e[_0x1b51('0x43')][_0x1b51('0x45')]?_0x168f1e[_0x1b51('0x43')]:_0x38857e[_0x1b51('0x3f')];_0x168f1e[_0x1b51('0x47')]=qs[_0x1b51('0x48')](_0x1d53e7[_0x1b51('0x40')][_0x1b51('0x48')]);_0x168f1e[_0x1b51('0x49')]=qs[_0x1b51('0x4b')](_[_0x1b51('0x4a')](_0x1d53e7[_0x1b51('0x40')],_0x38857e[_0x1b51('0x4b')]));if(_0x1d53e7[_0x1b51('0x40')]['filter']){_0x168f1e[_0x1b51('0x49')]=_[_0x1b51('0x56')](_0x168f1e['where'],{'$or':_[_0x1b51('0x32')](_0x168f1e[_0x1b51('0x43')],function(_0x482209){var _0x1f546f={};_0x1f546f[_0x482209]={'$like':'%'+_0x1d53e7[_0x1b51('0x40')][_0x1b51('0x4c')]+'%'};return _0x1f546f;})});}_0x168f1e=_[_0x1b51('0x56')]({},_0x168f1e,_0x1d53e7[_0x1b51('0x4e')]);return _0x1d605a[_0x1b51('0x9b')](_0x168f1e);}})[_0x1b51('0x2a')](function(_0x48841b){if(_0x48841b){_0x3261bc=_0x48841b[_0x1b51('0x45')];if(!_0x1d53e7[_0x1b51('0x40')][_0x1b51('0x46')](_0x1b51('0x69'))){_0x168f1e[_0x1b51('0x23')]=qs[_0x1b51('0x23')](_0x1d53e7[_0x1b51('0x40')][_0x1b51('0x23')]);_0x168f1e[_0x1b51('0x21')]=qs[_0x1b51('0x21')](_0x1d53e7[_0x1b51('0x40')][_0x1b51('0x21')]);}return _0x1d605a['getAgents'](_0x168f1e);}})[_0x1b51('0x2a')](function(_0x3b3a13){if(_0x3b3a13){return _0x3b3a13?{'count':_0x3261bc,'rows':_0x3b3a13}:null;}})[_0x1b51('0x2a')](respondWithResult(_0x521d25,null))[_0x1b51('0x53')](handleError(_0x521d25,null));};exports[_0x1b51('0x9c')]=function(_0x585def,_0x5f52c8,_0x36de99){var _0x10fef9={};var _0x1be5f8={};var _0x3fa184;var _0x3b2339;return db[_0x1b51('0x3c')][_0x1b51('0x67')]({'where':{'id':_0x585def[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x5f52c8,null))[_0x1b51('0x2a')](function(_0x9e725f){if(_0x9e725f){_0x3fa184=_0x9e725f;_0x1be5f8[_0x1b51('0x3f')]=_['keys'](db[_0x1b51('0x95')][_0x1b51('0x3d')]);_0x1be5f8[_0x1b51('0x40')]=_[_0x1b51('0x41')](_0x585def[_0x1b51('0x40')]);_0x1be5f8[_0x1b51('0x4b')]=_[_0x1b51('0x42')](_0x1be5f8[_0x1b51('0x3f')],_0x1be5f8[_0x1b51('0x40')]);_0x10fef9[_0x1b51('0x43')]=_['intersection'](_0x1be5f8[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0x585def['query']['fields']));_0x10fef9[_0x1b51('0x43')]=_0x10fef9[_0x1b51('0x43')][_0x1b51('0x45')]?_0x10fef9[_0x1b51('0x43')]:_0x1be5f8['model'];_0x10fef9[_0x1b51('0x47')]=qs[_0x1b51('0x48')](_0x585def[_0x1b51('0x40')][_0x1b51('0x48')]);_0x10fef9[_0x1b51('0x49')]=qs['filters'](_[_0x1b51('0x4a')](_0x585def[_0x1b51('0x40')],_0x1be5f8[_0x1b51('0x4b')]));if(_0x585def[_0x1b51('0x40')][_0x1b51('0x4c')]){_0x10fef9[_0x1b51('0x49')]=_[_0x1b51('0x56')](_0x10fef9[_0x1b51('0x49')],{'$or':_['map'](_0x10fef9[_0x1b51('0x43')],function(_0x2b6f11){var _0x576f8d={};_0x576f8d[_0x2b6f11]={'$like':'%'+_0x585def[_0x1b51('0x40')]['filter']+'%'};return _0x576f8d;})});}_0x10fef9=_[_0x1b51('0x56')]({},_0x10fef9,_0x585def[_0x1b51('0x4e')]);return _0x3fa184[_0x1b51('0x9c')](_0x10fef9);}})[_0x1b51('0x2a')](function(_0x42a861){if(_0x42a861){_0x3b2339=_0x42a861[_0x1b51('0x45')];if(!_0x585def['query'][_0x1b51('0x46')](_0x1b51('0x69'))){_0x10fef9['limit']=qs[_0x1b51('0x23')](_0x585def[_0x1b51('0x40')]['limit']);_0x10fef9[_0x1b51('0x21')]=qs[_0x1b51('0x21')](_0x585def[_0x1b51('0x40')][_0x1b51('0x21')]);}return _0x3fa184[_0x1b51('0x9c')](_0x10fef9);}})[_0x1b51('0x2a')](function(_0x2ccf39){return _0x2ccf39?{'count':_0x3b2339,'rows':_0x2ccf39}:null;})[_0x1b51('0x2a')](respondWithResult(_0x5f52c8,null))[_0x1b51('0x53')](handleError(_0x5f52c8,null));};exports[_0x1b51('0x9d')]=function(_0x1c7e39,_0x1b899d,_0x25b155){var _0x527c10={};var _0x4dd70c={};var _0x4b5210;var _0x17fb83;return db[_0x1b51('0x3c')][_0x1b51('0x67')]({'where':{'id':_0x1c7e39[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x1b899d,null))[_0x1b51('0x2a')](function(_0x440c30){if(_0x440c30){_0x4b5210=_0x440c30;_0x4dd70c[_0x1b51('0x3f')]=_[_0x1b51('0x41')](db[_0x1b51('0x9e')][_0x1b51('0x3d')]);_0x4dd70c[_0x1b51('0x40')]=_[_0x1b51('0x41')](_0x1c7e39[_0x1b51('0x40')]);_0x4dd70c[_0x1b51('0x4b')]=_[_0x1b51('0x42')](_0x4dd70c[_0x1b51('0x3f')],_0x4dd70c[_0x1b51('0x40')]);_0x527c10[_0x1b51('0x43')]=_[_0x1b51('0x42')](_0x4dd70c['model'],qs['fields'](_0x1c7e39[_0x1b51('0x40')][_0x1b51('0x44')]));_0x527c10[_0x1b51('0x43')]=_0x527c10['attributes']['length']?_0x527c10[_0x1b51('0x43')]:_0x4dd70c[_0x1b51('0x3f')];_0x527c10[_0x1b51('0x47')]=qs['sort'](_0x1c7e39[_0x1b51('0x40')]['sort']);_0x527c10[_0x1b51('0x49')]=qs[_0x1b51('0x4b')](_['pick'](_0x1c7e39[_0x1b51('0x40')],_0x4dd70c[_0x1b51('0x4b')]));if(_0x1c7e39[_0x1b51('0x40')][_0x1b51('0x4c')]){_0x527c10['where']=_['merge'](_0x527c10['where'],{'$or':_['map'](_0x527c10['attributes'],function(_0x220ae0){var _0x4d7f66={};_0x4d7f66[_0x220ae0]={'$like':'%'+_0x1c7e39[_0x1b51('0x40')][_0x1b51('0x4c')]+'%'};return _0x4d7f66;})});}_0x527c10=_[_0x1b51('0x56')]({},_0x527c10,_0x1c7e39[_0x1b51('0x4e')]);return _0x4b5210['getLists'](_0x527c10);}})['then'](function(_0xc8aec0){if(_0xc8aec0){_0x17fb83=_0xc8aec0[_0x1b51('0x45')];if(!_0x1c7e39[_0x1b51('0x40')][_0x1b51('0x46')](_0x1b51('0x69'))){_0x527c10[_0x1b51('0x23')]=qs['limit'](_0x1c7e39[_0x1b51('0x40')]['limit']);_0x527c10[_0x1b51('0x21')]=qs['offset'](_0x1c7e39[_0x1b51('0x40')][_0x1b51('0x21')]);}return _0x4b5210[_0x1b51('0x9d')](_0x527c10);}})[_0x1b51('0x2a')](function(_0x22b3ea){if(_0x22b3ea){return _0x22b3ea?{'count':_0x17fb83,'rows':_0x22b3ea}:null;}})['then'](respondWithResult(_0x1b899d,null))[_0x1b51('0x53')](handleError(_0x1b899d,null));};exports[_0x1b51('0x9f')]=function(_0x389f1c,_0x348764,_0x5f410c){var _0x5cb779=moment()[_0x1b51('0x7f')]('YYYY-MM-DD\x20HH:mm:ss');var _0x4ef8a7,_0x32d585;return db[_0x1b51('0x3c')][_0x1b51('0x36')]({'where':{'id':_0x389f1c[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x348764,null))[_0x1b51('0x2a')](function(_0x3e5484){if(_0x3e5484){_0x32d585=_0x3e5484;return _0x3e5484[_0x1b51('0x9f')](_0x389f1c['body'][_0x1b51('0x83')],_[_0x1b51('0x60')](_0x389f1c[_0x1b51('0x62')],[_0x1b51('0x83'),'id'])||{});}return null;})[_0x1b51('0x97')](function(_0x220caf){var _0x687917;_0x4ef8a7=_0x220caf||[];var _0x8eae7c=[];if(_0x220caf){for(var _0x563805=0x0;_0x563805<_0x220caf[_0x1b51('0x45')];_0x563805+=0x1){var _0x34cdfa=_0x220caf[_0x563805]['get']({'plain':!![]});_0x32d585[_0x1b51('0xa0')]=_0x389f1c[_0x1b51('0x62')][_0x1b51('0xa0')]?_0x389f1c[_0x1b51('0x62')][_0x1b51('0xa0')]:_0x32d585[_0x1b51('0xa0')];switch(_0x32d585['dialCheckDuplicateType']){case _0x1b51('0xa1'):_0x687917=squel['insert']()[_0x1b51('0xa2')](_0x1b51('0xa3'))['fromQuery'](['phone',_0x1b51('0xa4'),_0x1b51('0xa5'),_0x1b51('0xa6'),'VoiceQueueId',_0x1b51('0x61'),'updatedAt'],squel['select']()[_0x1b51('0x84')](_0x1b51('0xa7'),_0x1b51('0xa7'))[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27',_0x1b51('0xa4'))[_0x1b51('0x84')]('id',_0x1b51('0xa5'))['field'](_0x34cdfa[_0x1b51('0xa8')]['toString'](),'ListId')[_0x1b51('0x84')](_0x389f1c[_0x1b51('0x55')]['id']['toString'](),_0x1b51('0x6a'))['field']('\x27'+_0x5cb779+'\x27',_0x1b51('0x61'))[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27',_0x1b51('0x63'))[_0x1b51('0x86')](_0x1b51('0xa9'))['where'](_0x1b51('0xaa'))[_0x1b51('0x49')]('ListId\x20=\x20?',_0x34cdfa[_0x1b51('0xa8')][_0x1b51('0x8c')]())['where']('phone\x20IS\x20NOT\x20NULL')[_0x1b51('0x49')](_0x1b51('0xab'),squel[_0x1b51('0xac')]()[_0x1b51('0x84')](_0x1b51('0xad'))[_0x1b51('0x86')](_0x1b51('0xae'))[_0x1b51('0x49')](_0x1b51('0xaf'),_0x389f1c[_0x1b51('0x55')]['id'][_0x1b51('0x8c')]()))[_0x1b51('0x49')](_0x1b51('0xab'),squel[_0x1b51('0xac')]()[_0x1b51('0x84')]('COALESCE(phone,\x27\x27)')[_0x1b51('0x86')]('cm_hopper')[_0x1b51('0x49')](_0x1b51('0xaf'),_0x389f1c[_0x1b51('0x55')]['id'][_0x1b51('0x8c')]())))[_0x1b51('0x8c')]();break;case _0x1b51('0xb0'):_0x687917=squel[_0x1b51('0xb1')]()['into'](_0x1b51('0xa3'))[_0x1b51('0xb2')]([_0x1b51('0xa7'),'scheduledAt','ContactId','ListId',_0x1b51('0x6a'),_0x1b51('0x61'),_0x1b51('0x63')],squel[_0x1b51('0xac')]()[_0x1b51('0x84')](_0x1b51('0xa7'),'phone')[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27',_0x1b51('0xa4'))[_0x1b51('0x84')]('id','ContactId')[_0x1b51('0x84')](_0x34cdfa['CmListId'][_0x1b51('0x8c')](),_0x1b51('0xa6'))[_0x1b51('0x84')](_0x389f1c[_0x1b51('0x55')]['id'][_0x1b51('0x8c')](),_0x1b51('0x6a'))['field']('\x27'+_0x5cb779+'\x27',_0x1b51('0x61'))[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27',_0x1b51('0x63'))[_0x1b51('0x86')](_0x1b51('0xa9'))['where'](_0x1b51('0xaa'))['where']('ListId\x20=\x20?',_0x34cdfa[_0x1b51('0xa8')][_0x1b51('0x8c')]())[_0x1b51('0x49')](_0x1b51('0xb3'))[_0x1b51('0x49')](_0x1b51('0xab'),squel[_0x1b51('0xac')]()[_0x1b51('0x84')](_0x1b51('0xb4'))[_0x1b51('0x86')](_0x1b51('0xa3'))[_0x1b51('0x49')]('VoiceQueueId\x20=\x20?',_0x389f1c[_0x1b51('0x55')]['id'][_0x1b51('0x8c')]())))[_0x1b51('0x8c')]();break;default:_0x687917=squel[_0x1b51('0xb1')]()[_0x1b51('0xa2')]('cm_hopper')['fromQuery'](['phone','scheduledAt',_0x1b51('0xa5'),_0x1b51('0xa6'),_0x1b51('0x6a'),_0x1b51('0x61'),_0x1b51('0x63')],squel[_0x1b51('0xac')]()['field']('phone','phone')[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27','scheduledAt')[_0x1b51('0x84')]('id',_0x1b51('0xa5'))[_0x1b51('0x84')](_0x34cdfa['CmListId'][_0x1b51('0x8c')](),_0x1b51('0xa6'))['field'](_0x389f1c[_0x1b51('0x55')]['id'][_0x1b51('0x8c')](),'VoiceQueueId')[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27',_0x1b51('0x61'))[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27',_0x1b51('0x63'))[_0x1b51('0x86')](_0x1b51('0xa9'))[_0x1b51('0x49')](_0x1b51('0xaa'))[_0x1b51('0x49')]('ListId\x20=\x20?',_0x34cdfa[_0x1b51('0xa8')][_0x1b51('0x8c')]())[_0x1b51('0x49')](_0x1b51('0xb3')))['toString']();}_0x8eae7c[_0x1b51('0x8b')](db[_0x1b51('0x77')]['query'](_0x687917));}return BPromise[_0x1b51('0x90')](_0x8eae7c);}})[_0x1b51('0x2a')](function(){var _0x435d25=[];var _0x1345e4=squel['insert']()[_0x1b51('0xa2')](_0x1b51('0xb5'))[_0x1b51('0xb2')]([_0x1b51('0xb6'),_0x1b51('0xa7'),_0x1b51('0xb7'),_0x1b51('0x61'),_0x1b51('0x63')],squel['select']()['field'](_0x1b51('0xb8'))[_0x1b51('0x84')](_0x1b51('0xb9'))[_0x1b51('0x84')](_0x1b51('0xba'))[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27',_0x1b51('0x61'))[_0x1b51('0x84')]('\x27'+_0x5cb779+'\x27','updatedAt')[_0x1b51('0x86')](_0x1b51('0xbb'),'ci')['join'](_0x1b51('0xa3'),'h',_0x1b51('0xbc'))['where'](_0x1b51('0xbd'),_0x5cb779)[_0x1b51('0x49')]('ci.ItemClass=?','PHONE'))[_0x1b51('0x8c')]();_0x435d25['push'](db[_0x1b51('0x77')]['query'](_0x1345e4));return BPromise['all'](_0x435d25);})[_0x1b51('0x2a')](function(){return _0x4ef8a7;})['then'](respondWithResult(_0x348764,null))[_0x1b51('0x53')](handleError(_0x348764,null));};exports[_0x1b51('0xbe')]=function(_0x147418,_0x289b3e,_0x4984bc){return db[_0x1b51('0x3c')]['find']({'where':{'id':_0x147418[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x289b3e,null))['then'](function(_0x5ed072){if(_0x5ed072){return _0x5ed072[_0x1b51('0xbe')](_0x147418[_0x1b51('0x40')][_0x1b51('0x83')]);}})[_0x1b51('0x2a')](function(_0x465d2f){if(_0x465d2f){return db[_0x1b51('0x68')]['destroy']({'where':{'ListId':_0x147418[_0x1b51('0x40')][_0x1b51('0x83')],'VoiceQueueId':_0x147418[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](function(){return _0x465d2f;});}})['then'](respondWithStatusCode(_0x289b3e,null))[_0x1b51('0x53')](handleError(_0x289b3e,null));};exports[_0x1b51('0xbf')]=function(_0xb11c6,_0x456502,_0x352025){var _0x5cc751={};var _0x388698={};var _0x57ecf8;var _0x563774;return db[_0x1b51('0x3c')][_0x1b51('0x67')]({'where':{'id':_0xb11c6[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x456502,null))[_0x1b51('0x2a')](function(_0x5eed33){if(_0x5eed33){_0x57ecf8=_0x5eed33;_0x388698[_0x1b51('0x3f')]=_[_0x1b51('0x41')](db[_0x1b51('0x9e')]['rawAttributes']);_0x388698['query']=_['keys'](_0xb11c6['query']);_0x388698[_0x1b51('0x4b')]=_['intersection'](_0x388698[_0x1b51('0x3f')],_0x388698[_0x1b51('0x40')]);_0x5cc751[_0x1b51('0x43')]=_[_0x1b51('0x42')](_0x388698[_0x1b51('0x3f')],qs[_0x1b51('0x44')](_0xb11c6[_0x1b51('0x40')][_0x1b51('0x44')]));_0x5cc751['attributes']=_0x5cc751[_0x1b51('0x43')]['length']?_0x5cc751[_0x1b51('0x43')]:_0x388698[_0x1b51('0x3f')];_0x5cc751[_0x1b51('0x47')]=qs[_0x1b51('0x48')](_0xb11c6[_0x1b51('0x40')][_0x1b51('0x48')]);_0x5cc751['where']=qs[_0x1b51('0x4b')](_[_0x1b51('0x4a')](_0xb11c6[_0x1b51('0x40')],_0x388698[_0x1b51('0x4b')]));if(_0xb11c6['query']['filter']){_0x5cc751[_0x1b51('0x49')]=_['merge'](_0x5cc751[_0x1b51('0x49')],{'$or':_['map'](_0x5cc751[_0x1b51('0x43')],function(_0x488879){var _0x1bac07={};_0x1bac07[_0x488879]={'$like':'%'+_0xb11c6[_0x1b51('0x40')][_0x1b51('0x4c')]+'%'};return _0x1bac07;})});}_0x5cc751=_['merge']({},_0x5cc751,_0xb11c6['options']);return _0x57ecf8[_0x1b51('0xbf')](_0x5cc751);}})['then'](function(_0x289586){if(_0x289586){_0x563774=_0x289586[_0x1b51('0x45')];if(!_0xb11c6[_0x1b51('0x40')]['hasOwnProperty']('nolimit')){_0x5cc751['limit']=qs[_0x1b51('0x23')](_0xb11c6[_0x1b51('0x40')][_0x1b51('0x23')]);_0x5cc751['offset']=qs[_0x1b51('0x21')](_0xb11c6[_0x1b51('0x40')][_0x1b51('0x21')]);}return _0x57ecf8[_0x1b51('0xbf')](_0x5cc751);}})[_0x1b51('0x2a')](function(_0x41038c){if(_0x41038c){return _0x41038c?{'count':_0x563774,'rows':_0x41038c}:null;}})[_0x1b51('0x2a')](respondWithResult(_0x456502,null))[_0x1b51('0x53')](handleError(_0x456502,null));};exports[_0x1b51('0xc0')]=function(_0xc4d411,_0x3da5a1,_0x9b7749){var _0x139a40,_0x261e4c;return db[_0x1b51('0x3c')][_0x1b51('0x36')]({'where':{'id':_0xc4d411[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x3da5a1,null))[_0x1b51('0x2a')](function(_0x17e2f2){if(_0x17e2f2){_0x261e4c=_0x17e2f2;return _0x17e2f2[_0x1b51('0xc0')](_0xc4d411['body'][_0x1b51('0x83')],_[_0x1b51('0x60')](_0xc4d411[_0x1b51('0x62')],[_0x1b51('0x83'),'id'])||{});}return null;})[_0x1b51('0x97')](function(_0x4033fa){var _0x23b8dc;_0x139a40=_0x4033fa||[];var _0x15fcb0=[];if(_0x4033fa){for(var _0x53c8c6=0x0;_0x53c8c6<_0x4033fa[_0x1b51('0x45')];_0x53c8c6+=0x1){var _0x467156=_0x4033fa[_0x53c8c6][_0x1b51('0x2c')]({'plain':!![]});_0x23b8dc=squel[_0x1b51('0xb1')]()['into']('cm_hopper_black')[_0x1b51('0xb2')]([_0x1b51('0xa7'),'ContactId',_0x1b51('0xa6'),'VoiceQueueId','createdAt',_0x1b51('0x63')],squel[_0x1b51('0xac')]()['field'](_0x1b51('0xa7'),_0x1b51('0xa7'))[_0x1b51('0x84')]('id','ContactId')[_0x1b51('0x84')](_0x467156[_0x1b51('0xa8')]['toString'](),_0x1b51('0xa6'))[_0x1b51('0x84')](_0xc4d411[_0x1b51('0x55')]['id'][_0x1b51('0x8c')](),_0x1b51('0x6a'))['field'](_0x1b51('0xc1'),_0x1b51('0x61'))['field'](_0x1b51('0xc1'),_0x1b51('0x63'))['from'](_0x1b51('0xa9'))[_0x1b51('0x49')](_0x1b51('0xaa'))[_0x1b51('0x49')](_0x1b51('0xc2'),_0x467156[_0x1b51('0xa8')]['toString']())[_0x1b51('0x49')]('phone\x20IS\x20NOT\x20NULL'))[_0x1b51('0x8c')]();_0x15fcb0[_0x1b51('0x8b')](db['sequelize'][_0x1b51('0x40')](_0x23b8dc));}return BPromise[_0x1b51('0x90')](_0x15fcb0);}})['then'](function(){return _0x139a40;})['then'](respondWithResult(_0x3da5a1,null))[_0x1b51('0x53')](handleError(_0x3da5a1,null));};exports[_0x1b51('0xc3')]=function(_0x40a75e,_0x525df8,_0xceca01){return db[_0x1b51('0x3c')][_0x1b51('0x36')]({'where':{'id':_0x40a75e['params']['id']}})[_0x1b51('0x2a')](handleEntityNotFound(_0x525df8,null))[_0x1b51('0x2a')](function(_0x3a9677){if(_0x3a9677){return _0x3a9677['removeBlackLists'](_0x40a75e[_0x1b51('0x40')][_0x1b51('0x83')]);}})[_0x1b51('0x2a')](function(_0x4e7df4){if(_0x4e7df4){return db[_0x1b51('0x6f')][_0x1b51('0x2b')]({'where':{'ListId':_0x40a75e[_0x1b51('0x40')]['ids'],'VoiceQueueId':_0x40a75e[_0x1b51('0x55')]['id']}})[_0x1b51('0x2a')](function(){return _0x4e7df4;});}})[_0x1b51('0x2a')](respondWithStatusCode(_0x525df8,null))[_0x1b51('0x53')](handleError(_0x525df8,null));};
\ No newline at end of file
+var _0x008c=['deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','cm_hopper','onlyIfOpen','into','fromQuery','COALESCE(phone,\x27\x27)','all','cm_hopper_additional_phones','CmHopperId','OrderBy','h.id','ci.item','ci.OrderBy+1','cm_contact_has_items','join','h.ContactId=ci.CmContactId','h.scheduledat=?','ci.ItemClass=?','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','moment','bluebird','util','lodash','squel','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','localhost','register','sendStatus','json','offset','undefined','count','set','Content-Range','then','inbound','map','value','includes','type','UserProfileResource','destroy','status','send','index','VoiceQueue','rawAttributes','key','getOptions','where','include','query','findAll','rows','catch','show','params','keys','filters','model','intersection','fields','attributes','includeAll','merge','options','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','VoiceQueues','QueueCampaigns','outbound','name','UserProfileSection','userProfileId','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','body','createdAt','updatedAt','autoAssociation','getHoppers','findOne','CmHopper','length','hasOwnProperty','nolimit','limit','sort','pick','VoiceQueueId','filter','getHopperHistories','CmHopperHistory','order','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','Team','getTeams','addTeams','teams','Agents','online','voicePause','flatMap','forEach','penalty','sequelize','transaction','each','TeamVoiceQueue','UserVoiceQueue','findOrCreate','upsert','isNil','interface','format','SIP/%s','userVoiceQueue:save','removeTeams','ids','User','select','tq.TeamId','from','team_has_voice_queues','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','QueryTypes','SELECT','TeamId','union','compact','removeAgents','userVoiceQueue:remove','addAgents','spread','emit','isEmpty','UserVoiceQueueRt','isArray','getAgents','getMembers','getLists','CmList','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','insert','phone','scheduledAt','ContactId','ListId','field','CmListId','toString','cm_contacts'];(function(_0x5d7118,_0x495f38){var _0x593c1d=function(_0x249ccb){while(--_0x249ccb){_0x5d7118['push'](_0x5d7118['shift']());}};_0x593c1d(++_0x495f38);}(_0x008c,0x188));var _0xc008=function(_0x492445,_0x1454f9){_0x492445=_0x492445-0x0;var _0x34ca20=_0x008c[_0x492445];return _0x34ca20;};'use strict';var moment=require(_0xc008('0x0'));var BPromise=require(_0xc008('0x1'));var util=require(_0xc008('0x2'));var _=require(_0xc008('0x3'));var squel=require(_0xc008('0x4'));var Redis=require('ioredis');var qs=require(_0xc008('0x5'));var logger=require(_0xc008('0x6'))(_0xc008('0x7'));var config=require(_0xc008('0x8'));var db=require(_0xc008('0x9'))['db'];config[_0xc008('0xa')]=_[_0xc008('0xb')](config[_0xc008('0xa')],{'host':_0xc008('0xc'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xc008('0xa')]));require('./voiceQueue.socket')[_0xc008('0xd')](socket);function respondWithStatusCode(_0x5b64f8,_0x52041f){_0x52041f=_0x52041f||0xcc;return function(_0x27830d){if(_0x27830d){return _0x5b64f8[_0xc008('0xe')](_0x52041f);}return _0x5b64f8['status'](_0x52041f)['end']();};}function respondWithResult(_0x543eb8,_0x1eacfa){_0x1eacfa=_0x1eacfa||0xc8;return function(_0xc881aa){if(_0xc881aa){return _0x543eb8['status'](_0x1eacfa)[_0xc008('0xf')](_0xc881aa);}};}function respondWithFilteredResult(_0x332fd4,_0x2ea200){return function(_0x2a5b4e){if(_0x2a5b4e){var _0x9ffa93=typeof _0x2ea200[_0xc008('0x10')]===_0xc008('0x11')&&typeof _0x2ea200['limit']==='undefined';var _0x33f44c=_0x2a5b4e['count'];var _0x25e13f=_0x9ffa93?0x0:_0x2ea200[_0xc008('0x10')];var _0x2073ef=_0x9ffa93?_0x2a5b4e[_0xc008('0x12')]:_0x2ea200[_0xc008('0x10')]+_0x2ea200['limit'];var _0x5e894e;if(_0x2073ef>=_0x33f44c){_0x2073ef=_0x33f44c;_0x5e894e=0xc8;}else{_0x5e894e=0xce;}_0x332fd4['status'](_0x5e894e);return _0x332fd4[_0xc008('0x13')](_0xc008('0x14'),_0x25e13f+'-'+_0x2073ef+'/'+_0x33f44c)[_0xc008('0xf')](_0x2a5b4e);}return null;};}function saveUpdates(_0x3eb12a){return function(_0x4fe771){if(_0x4fe771){return _0x4fe771['update'](_0x3eb12a)['then'](function(_0x5c2668){return _0x5c2668;});}return null;};}function removeEntity(_0x46042b){return function(_0x462af5){if(_0x462af5){return _0x462af5['destroy']()[_0xc008('0x15')](function(){var _0x5906e6=_0x462af5['get']({'plain':!![]});var _0x543e5d=[{'name':'VoiceQueues','value':_0xc008('0x16'),'ignore':![]},{'name':'QueueCampaigns','value':'outbound','ignore':![]}];var _0x590a71=_(_0x543e5d)['filter']('ignore')[_0xc008('0x17')](_0xc008('0x18'))[_0xc008('0x18')]();if(_[_0xc008('0x19')](_0x590a71,_0x5906e6[_0xc008('0x1a')])){return;}var _0x110128=_['find'](_0x543e5d,[_0xc008('0x18'),_0x5906e6['type']])['name'];return db[_0xc008('0x1b')][_0xc008('0x1c')]({'where':{'type':_0x110128,'resourceId':_0x5906e6['id']}})[_0xc008('0x15')](function(){return _0x462af5;});})[_0xc008('0x15')](function(){_0x46042b['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x5de1e9){return function(_0x3f7b07){if(!_0x3f7b07){_0x5de1e9[_0xc008('0xe')](0x194);}return _0x3f7b07;};}function handleError(_0x92c582,_0x2e31c2){_0x2e31c2=_0x2e31c2||0x1f4;return function(_0x5bebd9){logger['error'](_0x5bebd9['stack']);if(_0x5bebd9['name']){delete _0x5bebd9['name'];}_0x92c582[_0xc008('0x1d')](_0x2e31c2)[_0xc008('0x1e')](_0x5bebd9);};}exports[_0xc008('0x1f')]=function(_0x529961,_0x24c14c){var _0x32390d={};var _0x209591={'count':0x0,'rows':[]};var _0x2a7d4f=_['map'](db[_0xc008('0x20')][_0xc008('0x21')],function(_0x53ed35){return{'name':_0x53ed35['fieldName'],'type':_0x53ed35['type'][_0xc008('0x22')]};});_0x32390d=qs[_0xc008('0x23')](_0x2a7d4f,_0x529961);var _0xf831f2={'where':_0x32390d[_0xc008('0x24')]};return db[_0xc008('0x20')][_0xc008('0x12')](_0xf831f2)[_0xc008('0x15')](function(_0x22d8e8){_0x209591[_0xc008('0x12')]=_0x22d8e8;_0x32390d[_0xc008('0x25')]=qs[_0xc008('0x25')](_0x529961[_0xc008('0x26')]);return db['VoiceQueue'][_0xc008('0x27')](_0x32390d);})[_0xc008('0x15')](function(_0x499754){_0x209591[_0xc008('0x28')]=_0x499754;return _0x209591;})[_0xc008('0x15')](respondWithFilteredResult(_0x24c14c,_0x32390d))[_0xc008('0x29')](handleError(_0x24c14c,null));};exports[_0xc008('0x2a')]=function(_0xd0e05a,_0x3cd878){var _0x7cfbc5={'raw':![],'where':{'id':_0xd0e05a[_0xc008('0x2b')]['id']}},_0x470e79={};_0x470e79['model']=_[_0xc008('0x2c')](db[_0xc008('0x20')][_0xc008('0x21')]);_0x470e79[_0xc008('0x26')]=_[_0xc008('0x2c')](_0xd0e05a[_0xc008('0x26')]);_0x470e79[_0xc008('0x2d')]=_['intersection'](_0x470e79[_0xc008('0x2e')],_0x470e79[_0xc008('0x26')]);_0x7cfbc5['attributes']=_[_0xc008('0x2f')](_0x470e79[_0xc008('0x2e')],qs['fields'](_0xd0e05a[_0xc008('0x26')][_0xc008('0x30')]));_0x7cfbc5[_0xc008('0x31')]=_0x7cfbc5['attributes']['length']?_0x7cfbc5['attributes']:_0x470e79[_0xc008('0x2e')];if(_0xd0e05a['query'][_0xc008('0x32')]){_0x7cfbc5[_0xc008('0x25')]=[{'all':!![]}];}_0x7cfbc5=_[_0xc008('0x33')]({},_0x7cfbc5,_0xd0e05a[_0xc008('0x34')]);return db[_0xc008('0x20')][_0xc008('0x35')](_0x7cfbc5)[_0xc008('0x15')](handleEntityNotFound(_0x3cd878,null))[_0xc008('0x15')](respondWithResult(_0x3cd878,null))[_0xc008('0x29')](handleError(_0x3cd878,null));};exports[_0xc008('0x36')]=function(_0x3ebb83,_0xdfca2e){return db[_0xc008('0x20')][_0xc008('0x36')](_0x3ebb83['body'],{})[_0xc008('0x15')](function(_0x23c4db){var _0x30b7df=_0x3ebb83[_0xc008('0x37')]['get']({'plain':!![]});if(!_0x30b7df)throw new Error(_0xc008('0x38'));if(_0x30b7df[_0xc008('0x39')]===_0xc008('0x37')){var _0x36e7ae=_0x23c4db[_0xc008('0x3a')]({'plain':!![]});var _0x5706bb=[{'name':_0xc008('0x3b'),'value':_0xc008('0x16')},{'name':_0xc008('0x3c'),'value':_0xc008('0x3d')}];var _0x7279e8=_['find'](_0x5706bb,[_0xc008('0x18'),_0x36e7ae[_0xc008('0x1a')]])[_0xc008('0x3e')];return db[_0xc008('0x3f')]['find']({'where':{'name':_0x7279e8,'userProfileId':_0x30b7df[_0xc008('0x40')]},'raw':!![]})[_0xc008('0x15')](function(_0x351d5c){if(_0x351d5c&&_0x351d5c['autoAssociation']===0x0){return db[_0xc008('0x1b')]['create']({'name':_0x36e7ae[_0xc008('0x3e')],'resourceId':_0x36e7ae['id'],'type':_0x351d5c['name'],'sectionId':_0x351d5c['id']},{})[_0xc008('0x15')](function(){return _0x23c4db;});}else{return _0x23c4db;}})[_0xc008('0x29')](function(_0x5a5d85){logger[_0xc008('0x41')](_0xc008('0x42'),_0x5a5d85);throw _0x5a5d85;});}return _0x23c4db;})[_0xc008('0x15')](respondWithResult(_0xdfca2e,0xc9))['catch'](handleError(_0xdfca2e,null));};exports[_0xc008('0x43')]=function(_0x2a9b5c,_0x200469){var _0x44fc5d={'where':{'id':_0x2a9b5c[_0xc008('0x2b')]['id']}},_0x347629={};_0x347629['model']=_['keys'](db['VoiceQueue'][_0xc008('0x21')]);_0x44fc5d[_0xc008('0x31')]=_[_0xc008('0x2f')](_0x347629[_0xc008('0x2e')],qs[_0xc008('0x30')](_0x2a9b5c[_0xc008('0x26')][_0xc008('0x30')]));_0x44fc5d[_0xc008('0x31')]=_0x44fc5d['attributes']['length']?_0x44fc5d['attributes']:_0x347629[_0xc008('0x2e')];if(_0x2a9b5c[_0xc008('0x26')][_0xc008('0x32')]){_0x44fc5d['include']=[{'all':!![]}];}_0x44fc5d=_[_0xc008('0x33')]({},_0x44fc5d,_0x2a9b5c[_0xc008('0x34')]);return db[_0xc008('0x20')][_0xc008('0x35')](_0x44fc5d)[_0xc008('0x15')](handleEntityNotFound(_0x200469,null))[_0xc008('0x15')](function(_0x17ec90){if(_0x17ec90){var _0x405e87=_0x17ec90[_0xc008('0x3a')]({'plain':!![]});_0x405e87=qs[_0xc008('0x44')](_0x405e87,['id','createdAt','updatedAt']);_0x2a9b5c[_0xc008('0x45')]=_['omit'](_0x2a9b5c[_0xc008('0x45')],['id',_0xc008('0x46'),_0xc008('0x47')]);return db['VoiceQueue'][_0xc008('0x36')](_[_0xc008('0x33')](_0x405e87,_0x2a9b5c[_0xc008('0x45')]),{'include':_0x2a9b5c[_0xc008('0x26')][_0xc008('0x32')]?[{'all':!![]}]:undefined})['then'](function(_0x3a7b3b){var _0x27b022=_0x2a9b5c['user'][_0xc008('0x3a')]({'plain':!![]});if(!_0x27b022)throw new Error(_0xc008('0x38'));if(_0x27b022['role']==='user'){var _0x2df905=_0x3a7b3b[_0xc008('0x3a')]({'plain':!![]});var _0x20947b=[{'name':_0xc008('0x3b'),'value':_0xc008('0x16')},{'name':'QueueCampaigns','value':'outbound'}];var _0x34b72a=_['find'](_0x20947b,[_0xc008('0x18'),_0x2df905[_0xc008('0x1a')]])[_0xc008('0x3e')];return db[_0xc008('0x3f')][_0xc008('0x35')]({'where':{'name':_0x34b72a,'userProfileId':_0x27b022[_0xc008('0x40')]},'raw':!![]})['then'](function(_0x2ea742){if(_0x2ea742&&_0x2ea742[_0xc008('0x48')]===0x0){return db[_0xc008('0x1b')][_0xc008('0x36')]({'name':_0x2df905[_0xc008('0x3e')],'resourceId':_0x2df905['id'],'type':_0x2ea742['name'],'sectionId':_0x2ea742['id']},{})[_0xc008('0x15')](function(){return _0x3a7b3b;});}else{return _0x3a7b3b;}})['catch'](function(_0x535e6e){logger['error'](_0xc008('0x42'),_0x535e6e);throw _0x535e6e;});}return _0x3a7b3b;});}})[_0xc008('0x15')](respondWithResult(_0x200469,0xc9))[_0xc008('0x29')](handleError(_0x200469,null));};exports['update']=function(_0x3aeeab,_0x2d8361){if(_0x3aeeab[_0xc008('0x45')]['id']){delete _0x3aeeab['body']['id'];}return db[_0xc008('0x20')][_0xc008('0x35')]({'where':{'id':_0x3aeeab[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x2d8361,null))['then'](saveUpdates(_0x3aeeab[_0xc008('0x45')],null))['then'](respondWithResult(_0x2d8361,null))[_0xc008('0x29')](handleError(_0x2d8361,null));};exports[_0xc008('0x1c')]=function(_0x2ae14e,_0x943c91){return db[_0xc008('0x20')][_0xc008('0x35')]({'where':{'id':_0x2ae14e['params']['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x943c91,null))['then'](removeEntity(_0x943c91,null))['catch'](handleError(_0x943c91,null));};exports[_0xc008('0x49')]=function(_0x30aa1e,_0x56e755){var _0xb1befa={'raw':![],'where':{}};var _0xb8ba7={};var _0x3e373e={'count':0x0,'rows':[]};return db[_0xc008('0x20')][_0xc008('0x4a')]({'where':{'id':_0x30aa1e[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x56e755,null))['then'](function(_0x16e052){if(_0x16e052){_0xb8ba7[_0xc008('0x2e')]=_[_0xc008('0x2c')](db[_0xc008('0x4b')][_0xc008('0x21')]);_0xb8ba7[_0xc008('0x26')]=_[_0xc008('0x2c')](_0x30aa1e[_0xc008('0x26')]);_0xb8ba7[_0xc008('0x2d')]=_[_0xc008('0x2f')](_0xb8ba7[_0xc008('0x2e')],_0xb8ba7[_0xc008('0x26')]);_0xb1befa[_0xc008('0x31')]=_[_0xc008('0x2f')](_0xb8ba7['model'],qs[_0xc008('0x30')](_0x30aa1e[_0xc008('0x26')][_0xc008('0x30')]));_0xb1befa['attributes']=_0xb1befa[_0xc008('0x31')][_0xc008('0x4c')]?_0xb1befa['attributes']:_0xb8ba7['model'];if(!_0x30aa1e[_0xc008('0x26')][_0xc008('0x4d')](_0xc008('0x4e'))){_0xb1befa[_0xc008('0x4f')]=qs[_0xc008('0x4f')](_0x30aa1e[_0xc008('0x26')][_0xc008('0x4f')]);_0xb1befa[_0xc008('0x10')]=qs[_0xc008('0x10')](_0x30aa1e[_0xc008('0x26')][_0xc008('0x10')]);}_0xb1befa['order']=qs[_0xc008('0x50')](_0x30aa1e[_0xc008('0x26')][_0xc008('0x50')]);_0xb1befa[_0xc008('0x24')]=qs['filters'](_[_0xc008('0x51')](_0x30aa1e['query'],_0xb8ba7[_0xc008('0x2d')]));_0xb1befa[_0xc008('0x24')][_0xc008('0x52')]=_0x16e052['id'];if(_0x30aa1e['query'][_0xc008('0x53')]){_0xb1befa[_0xc008('0x24')]=_[_0xc008('0x33')](_0xb1befa['where'],{'$or':_[_0xc008('0x17')](_0xb1befa['attributes'],function(_0x50ee03){var _0xee7a85={};_0xee7a85[_0x50ee03]={'$like':'%'+_0x30aa1e[_0xc008('0x26')][_0xc008('0x53')]+'%'};return _0xee7a85;})});}_0xb1befa=_[_0xc008('0x33')]({},_0xb1befa,_0x30aa1e['options']);return db[_0xc008('0x4b')][_0xc008('0x12')]({'where':_0xb1befa['where']})[_0xc008('0x15')](function(_0x5233bb){_0x3e373e[_0xc008('0x12')]=_0x5233bb;if(_0x30aa1e['query'][_0xc008('0x32')]){_0xb1befa['include']=[{'all':!![]}];}return db[_0xc008('0x4b')][_0xc008('0x27')](_0xb1befa);})[_0xc008('0x15')](function(_0x47337b){_0x3e373e['rows']=_0x47337b;return _0x3e373e;});}})[_0xc008('0x15')](respondWithFilteredResult(_0x56e755,_0xb1befa))[_0xc008('0x29')](handleError(_0x56e755,null));};exports[_0xc008('0x54')]=function(_0x1d49db,_0x321500){var _0x13ef78={'raw':!![],'where':{}};var _0xd9e3fd={};var _0x3b46e4={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xc008('0x4a')]({'where':{'id':_0x1d49db['params']['id']}})['then'](handleEntityNotFound(_0x321500,null))['then'](function(_0x406ead){if(_0x406ead){_0xd9e3fd[_0xc008('0x2e')]=_[_0xc008('0x2c')](db[_0xc008('0x55')][_0xc008('0x21')]);_0xd9e3fd[_0xc008('0x26')]=_[_0xc008('0x2c')](_0x1d49db[_0xc008('0x26')]);_0xd9e3fd[_0xc008('0x2d')]=_['intersection'](_0xd9e3fd[_0xc008('0x2e')],_0xd9e3fd[_0xc008('0x26')]);_0x13ef78[_0xc008('0x31')]=_[_0xc008('0x2f')](_0xd9e3fd[_0xc008('0x2e')],qs[_0xc008('0x30')](_0x1d49db[_0xc008('0x26')][_0xc008('0x30')]));_0x13ef78[_0xc008('0x31')]=_0x13ef78[_0xc008('0x31')][_0xc008('0x4c')]?_0x13ef78[_0xc008('0x31')]:_0xd9e3fd['model'];if(!_0x1d49db['query'][_0xc008('0x4d')](_0xc008('0x4e'))){_0x13ef78[_0xc008('0x4f')]=qs['limit'](_0x1d49db[_0xc008('0x26')][_0xc008('0x4f')]);_0x13ef78['offset']=qs['offset'](_0x1d49db['query'][_0xc008('0x10')]);}_0x13ef78[_0xc008('0x56')]=qs[_0xc008('0x50')](_0x1d49db[_0xc008('0x26')][_0xc008('0x50')]);_0x13ef78[_0xc008('0x24')]=qs[_0xc008('0x2d')](_[_0xc008('0x51')](_0x1d49db[_0xc008('0x26')],_0xd9e3fd[_0xc008('0x2d')]));_0x13ef78['where']['VoiceQueueId']=_0x406ead['id'];if(_0x1d49db[_0xc008('0x26')][_0xc008('0x53')]){_0x13ef78[_0xc008('0x24')]=_[_0xc008('0x33')](_0x13ef78[_0xc008('0x24')],{'$or':_[_0xc008('0x17')](_0x13ef78['attributes'],function(_0x5794fe){var _0x68372f={};_0x68372f[_0x5794fe]={'$like':'%'+_0x1d49db[_0xc008('0x26')][_0xc008('0x53')]+'%'};return _0x68372f;})});}_0x13ef78=_['merge']({},_0x13ef78,_0x1d49db['options']);return db['CmHopperHistory']['count']({'where':_0x13ef78['where']})['then'](function(_0x276de2){_0x3b46e4['count']=_0x276de2;if(_0x1d49db[_0xc008('0x26')]['includeAll']){_0x13ef78[_0xc008('0x25')]=[{'all':!![]}];}return db[_0xc008('0x55')][_0xc008('0x27')](_0x13ef78);})['then'](function(_0x58f348){_0x3b46e4[_0xc008('0x28')]=_0x58f348;return _0x3b46e4;});}})['then'](respondWithFilteredResult(_0x321500,_0x13ef78))[_0xc008('0x29')](handleError(_0x321500,null));};exports[_0xc008('0x57')]=function(_0x544519,_0x7b7246){var _0x4db90b={'raw':!![],'where':{}};var _0x554cf4={};var _0x23bece={'count':0x0,'rows':[]};return db[_0xc008('0x20')]['findOne']({'where':{'id':_0x544519[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x7b7246,null))[_0xc008('0x15')](function(_0x4bd290){if(_0x4bd290){_0x554cf4[_0xc008('0x2e')]=_[_0xc008('0x2c')](db[_0xc008('0x58')][_0xc008('0x21')]);_0x554cf4[_0xc008('0x26')]=_[_0xc008('0x2c')](_0x544519['query']);_0x554cf4[_0xc008('0x2d')]=_[_0xc008('0x2f')](_0x554cf4[_0xc008('0x2e')],_0x554cf4['query']);_0x4db90b[_0xc008('0x31')]=_[_0xc008('0x2f')](_0x554cf4[_0xc008('0x2e')],qs['fields'](_0x544519['query']['fields']));_0x4db90b[_0xc008('0x31')]=_0x4db90b[_0xc008('0x31')][_0xc008('0x4c')]?_0x4db90b[_0xc008('0x31')]:_0x554cf4[_0xc008('0x2e')];if(!_0x544519[_0xc008('0x26')][_0xc008('0x4d')](_0xc008('0x4e'))){_0x4db90b['limit']=qs[_0xc008('0x4f')](_0x544519[_0xc008('0x26')]['limit']);_0x4db90b['offset']=qs[_0xc008('0x10')](_0x544519[_0xc008('0x26')][_0xc008('0x10')]);}_0x4db90b[_0xc008('0x56')]=qs[_0xc008('0x50')](_0x544519['query'][_0xc008('0x50')]);_0x4db90b[_0xc008('0x24')]=qs['filters'](_[_0xc008('0x51')](_0x544519[_0xc008('0x26')],_0x554cf4[_0xc008('0x2d')]));_0x4db90b[_0xc008('0x24')]['VoiceQueueId']=_0x4bd290['id'];if(_0x544519[_0xc008('0x26')][_0xc008('0x53')]){_0x4db90b[_0xc008('0x24')]=_[_0xc008('0x33')](_0x4db90b['where'],{'$or':_[_0xc008('0x17')](_0x4db90b[_0xc008('0x31')],function(_0x57cf19){var _0x555e8a={};_0x555e8a[_0x57cf19]={'$like':'%'+_0x544519[_0xc008('0x26')]['filter']+'%'};return _0x555e8a;})});}_0x4db90b=_[_0xc008('0x33')]({},_0x4db90b,_0x544519[_0xc008('0x34')]);return db['CmHopperFinal'][_0xc008('0x12')]({'where':_0x4db90b[_0xc008('0x24')]})[_0xc008('0x15')](function(_0xbe42a2){_0x23bece[_0xc008('0x12')]=_0xbe42a2;if(_0x544519[_0xc008('0x26')][_0xc008('0x32')]){_0x4db90b[_0xc008('0x25')]=[{'all':!![]}];}return db[_0xc008('0x58')][_0xc008('0x27')](_0x4db90b);})['then'](function(_0x49e6d5){_0x23bece[_0xc008('0x28')]=_0x49e6d5;return _0x23bece;});}})[_0xc008('0x15')](respondWithFilteredResult(_0x7b7246,_0x4db90b))['catch'](handleError(_0x7b7246,null));};exports[_0xc008('0x59')]=function(_0x1bdaa9,_0x698d5c){var _0x5f1e48={'raw':!![],'where':{}};var _0x303cdd={};var _0x38239a={'count':0x0,'rows':[]};return db[_0xc008('0x20')][_0xc008('0x4a')]({'where':{'id':_0x1bdaa9[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x698d5c,null))[_0xc008('0x15')](function(_0x5bd010){if(_0x5bd010){_0x303cdd[_0xc008('0x2e')]=_['keys'](db[_0xc008('0x5a')][_0xc008('0x21')]);_0x303cdd[_0xc008('0x26')]=_['keys'](_0x1bdaa9[_0xc008('0x26')]);_0x303cdd[_0xc008('0x2d')]=_[_0xc008('0x2f')](_0x303cdd[_0xc008('0x2e')],_0x303cdd[_0xc008('0x26')]);_0x5f1e48[_0xc008('0x31')]=_[_0xc008('0x2f')](_0x303cdd[_0xc008('0x2e')],qs[_0xc008('0x30')](_0x1bdaa9[_0xc008('0x26')]['fields']));_0x5f1e48[_0xc008('0x31')]=_0x5f1e48[_0xc008('0x31')][_0xc008('0x4c')]?_0x5f1e48[_0xc008('0x31')]:_0x303cdd[_0xc008('0x2e')];if(!_0x1bdaa9['query'][_0xc008('0x4d')](_0xc008('0x4e'))){_0x5f1e48[_0xc008('0x4f')]=qs[_0xc008('0x4f')](_0x1bdaa9[_0xc008('0x26')][_0xc008('0x4f')]);_0x5f1e48[_0xc008('0x10')]=qs[_0xc008('0x10')](_0x1bdaa9[_0xc008('0x26')][_0xc008('0x10')]);}_0x5f1e48[_0xc008('0x56')]=qs[_0xc008('0x50')](_0x1bdaa9[_0xc008('0x26')][_0xc008('0x50')]);_0x5f1e48[_0xc008('0x24')]=qs['filters'](_['pick'](_0x1bdaa9[_0xc008('0x26')],_0x303cdd[_0xc008('0x2d')]));_0x5f1e48[_0xc008('0x24')][_0xc008('0x52')]=_0x5bd010['id'];if(_0x1bdaa9[_0xc008('0x26')][_0xc008('0x53')]){_0x5f1e48[_0xc008('0x24')]=_[_0xc008('0x33')](_0x5f1e48[_0xc008('0x24')],{'$or':_['map'](_0x5f1e48[_0xc008('0x31')],function(_0x2bbadf){var _0x54fd75={};_0x54fd75[_0x2bbadf]={'$like':'%'+_0x1bdaa9[_0xc008('0x26')][_0xc008('0x53')]+'%'};return _0x54fd75;})});}_0x5f1e48=_[_0xc008('0x33')]({},_0x5f1e48,_0x1bdaa9[_0xc008('0x34')]);return db[_0xc008('0x5a')][_0xc008('0x12')]({'where':_0x5f1e48['where']})[_0xc008('0x15')](function(_0x321532){_0x38239a[_0xc008('0x12')]=_0x321532;if(_0x1bdaa9[_0xc008('0x26')]['includeAll']){_0x5f1e48[_0xc008('0x25')]=[{'all':!![]}];}return db['CmHopperBlack'][_0xc008('0x27')](_0x5f1e48);})[_0xc008('0x15')](function(_0x5b47c3){_0x38239a[_0xc008('0x28')]=_0x5b47c3;return _0x38239a;});}})['then'](respondWithFilteredResult(_0x698d5c,_0x5f1e48))[_0xc008('0x29')](handleError(_0x698d5c,null));};exports['getTeams']=function(_0x5b387d,_0x5351f7){var _0x79dfea={};var _0x402b67={};var _0x48f40f;var _0x4fda8;return db[_0xc008('0x20')]['findOne']({'where':{'id':_0x5b387d[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x5351f7,null))[_0xc008('0x15')](function(_0x5843ee){if(_0x5843ee){_0x48f40f=_0x5843ee;_0x402b67[_0xc008('0x2e')]=_[_0xc008('0x2c')](db[_0xc008('0x5b')][_0xc008('0x21')]);_0x402b67[_0xc008('0x26')]=_[_0xc008('0x2c')](_0x5b387d[_0xc008('0x26')]);_0x402b67[_0xc008('0x2d')]=_[_0xc008('0x2f')](_0x402b67[_0xc008('0x2e')],_0x402b67[_0xc008('0x26')]);_0x79dfea['attributes']=_[_0xc008('0x2f')](_0x402b67[_0xc008('0x2e')],qs[_0xc008('0x30')](_0x5b387d['query'][_0xc008('0x30')]));_0x79dfea[_0xc008('0x31')]=_0x79dfea[_0xc008('0x31')]['length']?_0x79dfea[_0xc008('0x31')]:_0x402b67['model'];_0x79dfea[_0xc008('0x56')]=qs[_0xc008('0x50')](_0x5b387d[_0xc008('0x26')]['sort']);_0x79dfea[_0xc008('0x24')]=qs[_0xc008('0x2d')](_[_0xc008('0x51')](_0x5b387d[_0xc008('0x26')],_0x402b67[_0xc008('0x2d')]));if(_0x5b387d[_0xc008('0x26')][_0xc008('0x53')]){_0x79dfea['where']=_[_0xc008('0x33')](_0x79dfea[_0xc008('0x24')],{'$or':_[_0xc008('0x17')](_0x79dfea[_0xc008('0x31')],function(_0x5a61d6){var _0x46fba5={};_0x46fba5[_0x5a61d6]={'$like':'%'+_0x5b387d['query'][_0xc008('0x53')]+'%'};return _0x46fba5;})});}_0x79dfea=_[_0xc008('0x33')]({},_0x79dfea,_0x5b387d[_0xc008('0x34')]);return _0x48f40f[_0xc008('0x5c')](_0x79dfea);}})[_0xc008('0x15')](function(_0x9f266e){if(_0x9f266e){_0x4fda8=_0x9f266e[_0xc008('0x4c')];if(!_0x5b387d['query'][_0xc008('0x4d')](_0xc008('0x4e'))){_0x79dfea[_0xc008('0x4f')]=qs[_0xc008('0x4f')](_0x5b387d['query'][_0xc008('0x4f')]);_0x79dfea['offset']=qs[_0xc008('0x10')](_0x5b387d[_0xc008('0x26')][_0xc008('0x10')]);}return _0x48f40f['getTeams'](_0x79dfea);}})['then'](function(_0x39bfc0){if(_0x39bfc0){return _0x39bfc0?{'count':_0x4fda8,'rows':_0x39bfc0}:null;}})['then'](respondWithResult(_0x5351f7,null))[_0xc008('0x29')](handleError(_0x5351f7,null));};exports[_0xc008('0x5d')]=function(_0x1c2e63,_0xaf3bed){var _0x58ae7b=_0x1c2e63[_0xc008('0x45')][_0xc008('0x5e')];var _0x537e5e=_['map'](_0x58ae7b,'id');return db[_0xc008('0x5b')][_0xc008('0x27')]({'where':{'id':_0x537e5e},'attributes':['id'],'include':[{'model':db['User'],'as':_0xc008('0x5f'),'attributes':['id',_0xc008('0x3e'),_0xc008('0x60'),_0xc008('0x61'),'interface'],'raw':!![]}]})[_0xc008('0x15')](function(_0x3721e8){if(_0x3721e8){var _0xc344a7=_[_0xc008('0x62')](_0x3721e8,function(_0x78b833){var _0x177733=_0x78b833[_0xc008('0x3a')]({'plain':!![]});_0x177733[_0xc008('0x5f')][_0xc008('0x63')](function(_0xa332b1){_0xa332b1[_0xc008('0x64')]=_[_0xc008('0x35')](_0x58ae7b,{'id':_0x177733['id']})[_0xc008('0x64')];});return _0x177733['Agents'];});return db['VoiceQueue'][_0xc008('0x35')]({'where':{'id':_0x1c2e63[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](function(_0x4447ba){return db[_0xc008('0x65')][_0xc008('0x66')](function(_0xe5d226){return _0x4447ba['addTeams'](_0x537e5e,{'transaction':_0xe5d226})['then'](function(){return BPromise[_0xc008('0x67')](_0x58ae7b,function(_0x3d33ed){return db[_0xc008('0x68')]['upsert']({'TeamId':_0x3d33ed['id'],'VoiceQueueId':_0x1c2e63[_0xc008('0x2b')]['id'],'penalty':_0x3d33ed[_0xc008('0x64')]},{'transaction':_0xe5d226});});})[_0xc008('0x15')](function(){return BPromise[_0xc008('0x67')](_0xc344a7,function(_0x156ec3){return db[_0xc008('0x69')][_0xc008('0x6a')]({'where':{'UserId':_0x156ec3['id'],'VoiceQueueId':_0x1c2e63[_0xc008('0x2b')]['id']},'defaults':{'penalty':_0x156ec3[_0xc008('0x64')]},'transaction':_0xe5d226});});})[_0xc008('0x15')](function(){return BPromise[_0xc008('0x67')](_[_0xc008('0x53')](_0xc344a7,{'online':!![]}),function(_0x4ffaa3){return db['UserVoiceQueueRt'][_0xc008('0x6b')]({'membername':_0x4ffaa3[_0xc008('0x3e')],'UserId':_0x4ffaa3['id'],'queue_name':_0x4447ba['name'],'VoiceQueueId':_0x4447ba['id'],'interface':_[_0xc008('0x6c')](_0x4ffaa3[_0xc008('0x6d')])?util[_0xc008('0x6e')](_0xc008('0x6f'),_0x4ffaa3[_0xc008('0x3e')]):_0x4ffaa3[_0xc008('0x6d')],'paused':_0x4ffaa3[_0xc008('0x61')]||![],'penalty':_0x4ffaa3[_0xc008('0x64')]},{'transaction':_0xe5d226});});})[_0xc008('0x15')](function(){_0xc344a7['forEach'](function(_0x51b305){socket['emit'](_0xc008('0x70'),{'UserId':_0x51b305['id'],'VoiceQueueId':_0x4447ba['id']});});});});});}})['then'](respondWithStatusCode(_0xaf3bed,null))[_0xc008('0x29')](handleError(_0xaf3bed,null));};exports[_0xc008('0x71')]=function(_0x2c6a48,_0x177e8e){return db[_0xc008('0x5b')][_0xc008('0x27')]({'where':{'id':_0x2c6a48[_0xc008('0x26')][_0xc008('0x72')]},'attributes':['id'],'include':[{'model':db[_0xc008('0x73')],'as':_0xc008('0x5f'),'attributes':['id'],'raw':!![]}]})[_0xc008('0x15')](handleEntityNotFound(_0x177e8e,null))[_0xc008('0x15')](function(_0x1fea74){var _0x304083=_[_0xc008('0x17')](_0x1fea74,'id');var _0x473f44=[];var _0x41d1ea=[];var _0x5c2ca1=squel[_0xc008('0x74')]();_0x5c2ca1['field'](_0xc008('0x75'))[_0xc008('0x76')](_0xc008('0x77'),'tq')['join'](_0xc008('0x78'),'ut',_0xc008('0x79'))[_0xc008('0x24')](_0xc008('0x7a'),_0x2c6a48[_0xc008('0x2b')]['id']);for(var _0x377754=0x0;_0x377754<_0x1fea74[_0xc008('0x4c')];_0x377754+=0x1){let _0x57b8da=_0x1fea74[_0x377754];for(var _0x1cad4b=0x0;_0x1cad4b<_0x57b8da[_0xc008('0x5f')][_0xc008('0x4c')];_0x1cad4b+=0x1){let _0xdb4cef=_0x57b8da['Agents'][_0x1cad4b];var _0x555e8c=_0x5c2ca1['clone']();_0x555e8c['where'](_0xc008('0x7b'),_0xdb4cef['id']);_0x41d1ea[_0xc008('0x7c')](db[_0xc008('0x65')][_0xc008('0x26')](_0x555e8c['toString'](),{'type':db[_0xc008('0x65')][_0xc008('0x7d')][_0xc008('0x7e')]})['then'](function(_0x438195){if(_0x438195['length']===0x1){return _0xdb4cef['id'];}else{var _0x3d76b7=_['every'](_[_0xc008('0x17')](_0x438195,_0xc008('0x7f')),function(_0x1aaf89){return _[_0xc008('0x19')](_0x304083,_0x1aaf89);});if(_0x3d76b7){return _0xdb4cef['id'];}}}));}}return BPromise['all'](_0x41d1ea)[_0xc008('0x15')](function(_0x19dcb7){_0x473f44=_(_0x473f44)[_0xc008('0x80')](_0x19dcb7)[_0xc008('0x81')]()[_0xc008('0x18')]();return db[_0xc008('0x20')][_0xc008('0x35')]({'where':{'id':_0x2c6a48['params']['id']}})[_0xc008('0x15')](function(_0x30b6af){return db[_0xc008('0x65')]['transaction'](function(_0x5ba04f){return _0x30b6af[_0xc008('0x71')](_0x2c6a48[_0xc008('0x26')][_0xc008('0x72')],{'transaction':_0x5ba04f})[_0xc008('0x15')](function(){if(!_['isEmpty'](_0x473f44)){return _0x30b6af[_0xc008('0x82')](_0x473f44,{'transaction':_0x5ba04f})[_0xc008('0x15')](function(){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x2c6a48['params']['id'],'UserId':_0x473f44},'transaction':_0x5ba04f});});}})[_0xc008('0x15')](function(){_0x473f44['forEach'](function(_0x3744e1){socket['emit'](_0xc008('0x83'),{'UserId':_0x3744e1,'VoiceQueueId':_0x30b6af['id']});});});});});});})[_0xc008('0x15')](respondWithStatusCode(_0x177e8e,null))[_0xc008('0x29')](handleError(_0x177e8e,null));};exports[_0xc008('0x84')]=function(_0x5c24cd,_0x5effd6){var _0x23ba7e,_0x274739;return db[_0xc008('0x20')]['find']({'where':{'id':_0x5c24cd[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x5effd6,null))[_0xc008('0x15')](function(_0x272d98){if(_0x272d98){_0x274739=_0x272d98;return _0x272d98[_0xc008('0x84')](_0x5c24cd[_0xc008('0x45')][_0xc008('0x72')],_[_0xc008('0x44')](_0x5c24cd[_0xc008('0x45')],[_0xc008('0x72'),'id'])||{})[_0xc008('0x85')](function(_0x57687f){for(var _0x5ea13a=0x0;_0x5ea13a<_0x5c24cd[_0xc008('0x45')]['ids'][_0xc008('0x4c')];_0x5ea13a+=0x1){socket[_0xc008('0x86')]('userVoiceQueue:save',{'UserId':Number(_0x5c24cd['body'][_0xc008('0x72')][_0x5ea13a]),'VoiceQueueId':Number(_0x5c24cd[_0xc008('0x2b')]['id'])});}return _0x57687f;});}})[_0xc008('0x15')](function(_0x129cbf){_0x23ba7e=_0x129cbf||[];if(_0x274739){return db[_0xc008('0x73')][_0xc008('0x27')]({'where':{'id':_0x5c24cd['body'][_0xc008('0x72')]},'attributes':['id',_0xc008('0x3e'),_0xc008('0x60'),'voicePause',_0xc008('0x6d')],'raw':!![]});}})[_0xc008('0x15')](function(_0xcef0e4){if(!_[_0xc008('0x87')](_0xcef0e4)){var _0x49f92e=[];for(var _0x4ae026=0x0;_0x4ae026<_0xcef0e4[_0xc008('0x4c')];_0x4ae026++){if(_0xcef0e4[_0x4ae026]['online']){_0x49f92e[_0xc008('0x7c')](db[_0xc008('0x88')][_0xc008('0x6b')]({'membername':_0xcef0e4[_0x4ae026][_0xc008('0x3e')],'UserId':_0xcef0e4[_0x4ae026]['id'],'queue_name':_0x274739[_0xc008('0x3e')],'VoiceQueueId':_0x274739['id'],'interface':_['isNil'](_0xcef0e4[_0x4ae026]['interface'])?util[_0xc008('0x6e')](_0xc008('0x6f'),_0xcef0e4[_0x4ae026][_0xc008('0x3e')]):_0xcef0e4[_0x4ae026][_0xc008('0x6d')],'paused':_0xcef0e4[_0x4ae026][_0xc008('0x61')]||![],'penalty':_0x5c24cd[_0xc008('0x45')][_0xc008('0x64')]||0x0}));}}return BPromise['all'](_0x49f92e);}})[_0xc008('0x15')](function(){return _0x23ba7e;})[_0xc008('0x15')](respondWithResult(_0x5effd6,null))[_0xc008('0x29')](handleError(_0x5effd6,null));};exports[_0xc008('0x82')]=function(_0x1afb32,_0x1c2263){return db[_0xc008('0x20')][_0xc008('0x35')]({'where':{'id':_0x1afb32[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x1c2263,null))[_0xc008('0x15')](function(_0x328284){if(_0x328284){return _0x328284['removeAgents'](_0x1afb32[_0xc008('0x26')][_0xc008('0x72')])['then'](function(){if(_[_0xc008('0x89')](_0x1afb32[_0xc008('0x26')][_0xc008('0x72')])){for(var _0x2598be=0x0;_0x2598be<_0x1afb32[_0xc008('0x26')][_0xc008('0x72')][_0xc008('0x4c')];_0x2598be+=0x1){socket[_0xc008('0x86')](_0xc008('0x83'),{'UserId':Number(_0x1afb32[_0xc008('0x26')][_0xc008('0x72')][_0x2598be]),'VoiceQueueId':Number(_0x1afb32['params']['id'])});}}else{socket[_0xc008('0x86')](_0xc008('0x83'),{'UserId':Number(_0x1afb32[_0xc008('0x26')][_0xc008('0x72')]),'VoiceQueueId':Number(_0x1afb32[_0xc008('0x2b')]['id'])});}});}})[_0xc008('0x15')](function(_0x12f5d1){return db[_0xc008('0x88')][_0xc008('0x1c')]({'where':{'VoiceQueueId':_0x1afb32[_0xc008('0x2b')]['id'],'UserId':_0x1afb32[_0xc008('0x26')][_0xc008('0x72')]}})[_0xc008('0x15')](function(){return _0x12f5d1;});})[_0xc008('0x15')](respondWithStatusCode(_0x1c2263,null))[_0xc008('0x29')](handleError(_0x1c2263,null));};exports[_0xc008('0x8a')]=function(_0x5c358b,_0x49688b){var _0x51fd86={};var _0x10778f={};var _0x237ffb;var _0x3f80f4;return db[_0xc008('0x20')][_0xc008('0x4a')]({'where':{'id':_0x5c358b[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x49688b,null))['then'](function(_0x3e7099){if(_0x3e7099){_0x237ffb=_0x3e7099;_0x10778f['model']=_['keys'](db[_0xc008('0x73')][_0xc008('0x21')]);_0x10778f['query']=_[_0xc008('0x2c')](_0x5c358b[_0xc008('0x26')]);_0x10778f[_0xc008('0x2d')]=_['intersection'](_0x10778f[_0xc008('0x2e')],_0x10778f[_0xc008('0x26')]);_0x51fd86[_0xc008('0x31')]=_['intersection'](_0x10778f[_0xc008('0x2e')],qs[_0xc008('0x30')](_0x5c358b[_0xc008('0x26')][_0xc008('0x30')]));_0x51fd86[_0xc008('0x31')]=_0x51fd86[_0xc008('0x31')][_0xc008('0x4c')]?_0x51fd86[_0xc008('0x31')]:_0x10778f['model'];_0x51fd86[_0xc008('0x56')]=qs[_0xc008('0x50')](_0x5c358b[_0xc008('0x26')][_0xc008('0x50')]);_0x51fd86[_0xc008('0x24')]=qs['filters'](_[_0xc008('0x51')](_0x5c358b[_0xc008('0x26')],_0x10778f[_0xc008('0x2d')]));if(_0x5c358b[_0xc008('0x26')][_0xc008('0x53')]){_0x51fd86[_0xc008('0x24')]=_[_0xc008('0x33')](_0x51fd86[_0xc008('0x24')],{'$or':_['map'](_0x51fd86[_0xc008('0x31')],function(_0x231318){var _0x3df369={};_0x3df369[_0x231318]={'$like':'%'+_0x5c358b[_0xc008('0x26')]['filter']+'%'};return _0x3df369;})});}_0x51fd86=_['merge']({},_0x51fd86,_0x5c358b[_0xc008('0x34')]);return _0x237ffb[_0xc008('0x8a')](_0x51fd86);}})['then'](function(_0x30e433){if(_0x30e433){_0x3f80f4=_0x30e433[_0xc008('0x4c')];if(!_0x5c358b[_0xc008('0x26')][_0xc008('0x4d')](_0xc008('0x4e'))){_0x51fd86[_0xc008('0x4f')]=qs[_0xc008('0x4f')](_0x5c358b['query']['limit']);_0x51fd86[_0xc008('0x10')]=qs['offset'](_0x5c358b[_0xc008('0x26')][_0xc008('0x10')]);}return _0x237ffb[_0xc008('0x8a')](_0x51fd86);}})[_0xc008('0x15')](function(_0x2ea1db){if(_0x2ea1db){return _0x2ea1db?{'count':_0x3f80f4,'rows':_0x2ea1db}:null;}})[_0xc008('0x15')](respondWithResult(_0x49688b,null))[_0xc008('0x29')](handleError(_0x49688b,null));};exports[_0xc008('0x8b')]=function(_0x367873,_0x356a82){var _0x368c1f={};var _0x4fd0ff={};var _0x22772e;var _0x39fd43;return db[_0xc008('0x20')][_0xc008('0x4a')]({'where':{'id':_0x367873[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x356a82,null))[_0xc008('0x15')](function(_0x506dc0){if(_0x506dc0){_0x22772e=_0x506dc0;_0x4fd0ff[_0xc008('0x2e')]=_[_0xc008('0x2c')](db[_0xc008('0x88')]['rawAttributes']);_0x4fd0ff[_0xc008('0x26')]=_[_0xc008('0x2c')](_0x367873[_0xc008('0x26')]);_0x4fd0ff[_0xc008('0x2d')]=_[_0xc008('0x2f')](_0x4fd0ff[_0xc008('0x2e')],_0x4fd0ff['query']);_0x368c1f['attributes']=_[_0xc008('0x2f')](_0x4fd0ff[_0xc008('0x2e')],qs[_0xc008('0x30')](_0x367873[_0xc008('0x26')][_0xc008('0x30')]));_0x368c1f['attributes']=_0x368c1f[_0xc008('0x31')]['length']?_0x368c1f[_0xc008('0x31')]:_0x4fd0ff[_0xc008('0x2e')];_0x368c1f['order']=qs[_0xc008('0x50')](_0x367873[_0xc008('0x26')][_0xc008('0x50')]);_0x368c1f[_0xc008('0x24')]=qs['filters'](_[_0xc008('0x51')](_0x367873[_0xc008('0x26')],_0x4fd0ff[_0xc008('0x2d')]));if(_0x367873[_0xc008('0x26')][_0xc008('0x53')]){_0x368c1f['where']=_[_0xc008('0x33')](_0x368c1f[_0xc008('0x24')],{'$or':_[_0xc008('0x17')](_0x368c1f['attributes'],function(_0x43f96e){var _0x353cd5={};_0x353cd5[_0x43f96e]={'$like':'%'+_0x367873[_0xc008('0x26')][_0xc008('0x53')]+'%'};return _0x353cd5;})});}_0x368c1f=_['merge']({},_0x368c1f,_0x367873[_0xc008('0x34')]);return _0x22772e[_0xc008('0x8b')](_0x368c1f);}})[_0xc008('0x15')](function(_0x9afcd6){if(_0x9afcd6){_0x39fd43=_0x9afcd6[_0xc008('0x4c')];if(!_0x367873['query'][_0xc008('0x4d')]('nolimit')){_0x368c1f['limit']=qs[_0xc008('0x4f')](_0x367873['query'][_0xc008('0x4f')]);_0x368c1f[_0xc008('0x10')]=qs[_0xc008('0x10')](_0x367873[_0xc008('0x26')][_0xc008('0x10')]);}return _0x22772e[_0xc008('0x8b')](_0x368c1f);}})[_0xc008('0x15')](function(_0x5e9e9c){return _0x5e9e9c?{'count':_0x39fd43,'rows':_0x5e9e9c}:null;})[_0xc008('0x15')](respondWithResult(_0x356a82,null))[_0xc008('0x29')](handleError(_0x356a82,null));};exports[_0xc008('0x8c')]=function(_0x45fe90,_0xc046ce){var _0x46fc75={};var _0x59b5b9={};var _0x3c3ead;var _0x3c8a79;return db[_0xc008('0x20')][_0xc008('0x4a')]({'where':{'id':_0x45fe90[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0xc046ce,null))[_0xc008('0x15')](function(_0x3aa9b4){if(_0x3aa9b4){_0x3c3ead=_0x3aa9b4;_0x59b5b9['model']=_['keys'](db[_0xc008('0x8d')][_0xc008('0x21')]);_0x59b5b9['query']=_[_0xc008('0x2c')](_0x45fe90['query']);_0x59b5b9[_0xc008('0x2d')]=_[_0xc008('0x2f')](_0x59b5b9[_0xc008('0x2e')],_0x59b5b9[_0xc008('0x26')]);_0x46fc75[_0xc008('0x31')]=_[_0xc008('0x2f')](_0x59b5b9[_0xc008('0x2e')],qs['fields'](_0x45fe90[_0xc008('0x26')]['fields']));_0x46fc75[_0xc008('0x31')]=_0x46fc75[_0xc008('0x31')][_0xc008('0x4c')]?_0x46fc75[_0xc008('0x31')]:_0x59b5b9[_0xc008('0x2e')];_0x46fc75[_0xc008('0x56')]=qs[_0xc008('0x50')](_0x45fe90['query'][_0xc008('0x50')]);_0x46fc75[_0xc008('0x24')]=qs['filters'](_[_0xc008('0x51')](_0x45fe90[_0xc008('0x26')],_0x59b5b9[_0xc008('0x2d')]));if(_0x45fe90[_0xc008('0x26')][_0xc008('0x53')]){_0x46fc75[_0xc008('0x24')]=_['merge'](_0x46fc75[_0xc008('0x24')],{'$or':_[_0xc008('0x17')](_0x46fc75[_0xc008('0x31')],function(_0x3e7c19){var _0x47d263={};_0x47d263[_0x3e7c19]={'$like':'%'+_0x45fe90['query']['filter']+'%'};return _0x47d263;})});}_0x46fc75=_[_0xc008('0x33')]({},_0x46fc75,_0x45fe90[_0xc008('0x34')]);return _0x3c3ead['getLists'](_0x46fc75);}})['then'](function(_0x5035ca){if(_0x5035ca){_0x3c8a79=_0x5035ca['length'];if(!_0x45fe90[_0xc008('0x26')][_0xc008('0x4d')]('nolimit')){_0x46fc75[_0xc008('0x4f')]=qs[_0xc008('0x4f')](_0x45fe90[_0xc008('0x26')][_0xc008('0x4f')]);_0x46fc75[_0xc008('0x10')]=qs['offset'](_0x45fe90['query'][_0xc008('0x10')]);}return _0x3c3ead[_0xc008('0x8c')](_0x46fc75);}})[_0xc008('0x15')](function(_0x46f9ab){if(_0x46f9ab){return _0x46f9ab?{'count':_0x3c8a79,'rows':_0x46f9ab}:null;}})[_0xc008('0x15')](respondWithResult(_0xc046ce,null))[_0xc008('0x29')](handleError(_0xc046ce,null));};exports[_0xc008('0x8e')]=function(_0x5645bb,_0x2ebe07){var _0x3d6f0d=moment()[_0xc008('0x6e')](_0xc008('0x8f'));var _0x3be328,_0x3bcf94;return db[_0xc008('0x20')]['find']({'where':{'id':_0x5645bb['params']['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x2ebe07,null))[_0xc008('0x15')](function(_0x11bcba){if(_0x11bcba){_0x3bcf94=_0x11bcba;return _0x11bcba[_0xc008('0x8e')](_0x5645bb[_0xc008('0x45')][_0xc008('0x72')],_[_0xc008('0x44')](_0x5645bb[_0xc008('0x45')],[_0xc008('0x72'),'id'])||{});}return null;})[_0xc008('0x85')](function(_0xefba5){var _0x202826;_0x3be328=_0xefba5||[];var _0x37e1f2=[];if(_0xefba5){for(var _0x5161f3=0x0;_0x5161f3<_0xefba5['length'];_0x5161f3+=0x1){var _0x43ec81=_0xefba5[_0x5161f3][_0xc008('0x3a')]({'plain':!![]});_0x3bcf94[_0xc008('0x90')]=_0x5645bb[_0xc008('0x45')][_0xc008('0x90')]?_0x5645bb[_0xc008('0x45')][_0xc008('0x90')]:_0x3bcf94['dialCheckDuplicateType'];switch(_0x3bcf94['dialCheckDuplicateType']){case'always':_0x202826=squel[_0xc008('0x91')]()['into']('cm_hopper')['fromQuery']([_0xc008('0x92'),_0xc008('0x93'),_0xc008('0x94'),_0xc008('0x95'),_0xc008('0x52'),_0xc008('0x46'),_0xc008('0x47')],squel[_0xc008('0x74')]()[_0xc008('0x96')](_0xc008('0x92'),_0xc008('0x92'))[_0xc008('0x96')]('\x27'+_0x3d6f0d+'\x27','scheduledAt')['field']('id',_0xc008('0x94'))[_0xc008('0x96')](_0x43ec81[_0xc008('0x97')][_0xc008('0x98')](),_0xc008('0x95'))[_0xc008('0x96')](_0x5645bb[_0xc008('0x2b')]['id'][_0xc008('0x98')](),'VoiceQueueId')[_0xc008('0x96')]('\x27'+_0x3d6f0d+'\x27','createdAt')['field']('\x27'+_0x3d6f0d+'\x27','updatedAt')['from'](_0xc008('0x99'))['where'](_0xc008('0x9a'))[_0xc008('0x24')](_0xc008('0x9b'),_0x43ec81['CmListId']['toString']())[_0xc008('0x24')](_0xc008('0x9c'))['where'](_0xc008('0x9d'),squel[_0xc008('0x74')]()[_0xc008('0x96')](_0xc008('0x9e'))[_0xc008('0x76')](_0xc008('0x9f'))[_0xc008('0x24')](_0xc008('0x7a'),_0x5645bb[_0xc008('0x2b')]['id'][_0xc008('0x98')]()))['where'](_0xc008('0x9d'),squel[_0xc008('0x74')]()['field']('COALESCE(phone,\x27\x27)')[_0xc008('0x76')](_0xc008('0xa0'))[_0xc008('0x24')]('VoiceQueueId\x20=\x20?',_0x5645bb['params']['id']['toString']())))['toString']();break;case _0xc008('0xa1'):_0x202826=squel[_0xc008('0x91')]()[_0xc008('0xa2')](_0xc008('0xa0'))[_0xc008('0xa3')]([_0xc008('0x92'),_0xc008('0x93'),'ContactId',_0xc008('0x95'),_0xc008('0x52'),_0xc008('0x46'),_0xc008('0x47')],squel[_0xc008('0x74')]()['field'](_0xc008('0x92'),_0xc008('0x92'))['field']('\x27'+_0x3d6f0d+'\x27',_0xc008('0x93'))[_0xc008('0x96')]('id',_0xc008('0x94'))[_0xc008('0x96')](_0x43ec81['CmListId'][_0xc008('0x98')](),'ListId')[_0xc008('0x96')](_0x5645bb[_0xc008('0x2b')]['id'][_0xc008('0x98')](),_0xc008('0x52'))[_0xc008('0x96')]('\x27'+_0x3d6f0d+'\x27','createdAt')[_0xc008('0x96')]('\x27'+_0x3d6f0d+'\x27',_0xc008('0x47'))[_0xc008('0x76')](_0xc008('0x99'))['where'](_0xc008('0x9a'))['where']('ListId\x20=\x20?',_0x43ec81[_0xc008('0x97')][_0xc008('0x98')]())[_0xc008('0x24')]('phone\x20IS\x20NOT\x20NULL')[_0xc008('0x24')](_0xc008('0x9d'),squel['select']()[_0xc008('0x96')](_0xc008('0xa4'))['from']('cm_hopper')[_0xc008('0x24')]('VoiceQueueId\x20=\x20?',_0x5645bb['params']['id'][_0xc008('0x98')]())))['toString']();break;default:_0x202826=squel[_0xc008('0x91')]()[_0xc008('0xa2')](_0xc008('0xa0'))[_0xc008('0xa3')]([_0xc008('0x92'),'scheduledAt','ContactId',_0xc008('0x95'),'VoiceQueueId',_0xc008('0x46'),'updatedAt'],squel['select']()['field'](_0xc008('0x92'),'phone')[_0xc008('0x96')]('\x27'+_0x3d6f0d+'\x27',_0xc008('0x93'))['field']('id','ContactId')[_0xc008('0x96')](_0x43ec81[_0xc008('0x97')][_0xc008('0x98')](),_0xc008('0x95'))['field'](_0x5645bb['params']['id'][_0xc008('0x98')](),'VoiceQueueId')['field']('\x27'+_0x3d6f0d+'\x27',_0xc008('0x46'))[_0xc008('0x96')]('\x27'+_0x3d6f0d+'\x27','updatedAt')['from']('cm_contacts')[_0xc008('0x24')]('deletedAt\x20IS\x20NULL')[_0xc008('0x24')](_0xc008('0x9b'),_0x43ec81[_0xc008('0x97')][_0xc008('0x98')]())[_0xc008('0x24')]('phone\x20IS\x20NOT\x20NULL'))['toString']();}_0x37e1f2[_0xc008('0x7c')](db[_0xc008('0x65')][_0xc008('0x26')](_0x202826));}return BPromise[_0xc008('0xa5')](_0x37e1f2);}})[_0xc008('0x15')](function(){var _0x262b79=[];var _0x15c5a2=squel[_0xc008('0x91')]()[_0xc008('0xa2')](_0xc008('0xa6'))[_0xc008('0xa3')]([_0xc008('0xa7'),'phone',_0xc008('0xa8'),_0xc008('0x46'),_0xc008('0x47')],squel[_0xc008('0x74')]()['field'](_0xc008('0xa9'))[_0xc008('0x96')](_0xc008('0xaa'))[_0xc008('0x96')](_0xc008('0xab'))[_0xc008('0x96')]('\x27'+_0x3d6f0d+'\x27',_0xc008('0x46'))[_0xc008('0x96')]('\x27'+_0x3d6f0d+'\x27','updatedAt')[_0xc008('0x76')](_0xc008('0xac'),'ci')[_0xc008('0xad')](_0xc008('0xa0'),'h',_0xc008('0xae'))[_0xc008('0x24')](_0xc008('0xaf'),_0x3d6f0d)['where'](_0xc008('0xb0'),'PHONE'))[_0xc008('0x98')]();_0x262b79[_0xc008('0x7c')](db[_0xc008('0x65')][_0xc008('0x26')](_0x15c5a2));return BPromise[_0xc008('0xa5')](_0x262b79);})[_0xc008('0x15')](function(){return _0x3be328;})[_0xc008('0x15')](respondWithResult(_0x2ebe07,null))[_0xc008('0x29')](handleError(_0x2ebe07,null));};exports[_0xc008('0xb1')]=function(_0x471780,_0x4fae34){return db[_0xc008('0x20')][_0xc008('0x35')]({'where':{'id':_0x471780[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x4fae34,null))[_0xc008('0x15')](function(_0x1cc6a6){if(_0x1cc6a6){return _0x1cc6a6[_0xc008('0xb1')](_0x471780[_0xc008('0x26')][_0xc008('0x72')]);}})[_0xc008('0x15')](function(_0x471618){if(_0x471618){return db[_0xc008('0x4b')][_0xc008('0x1c')]({'where':{'ListId':_0x471780['query'][_0xc008('0x72')],'VoiceQueueId':_0x471780['params']['id']}})[_0xc008('0x15')](function(){return _0x471618;});}})[_0xc008('0x15')](respondWithStatusCode(_0x4fae34,null))[_0xc008('0x29')](handleError(_0x4fae34,null));};exports[_0xc008('0xb2')]=function(_0x370234,_0x3ff7d2){var _0x478794={};var _0x406de6={};var _0x34cbce;var _0x337acd;return db['VoiceQueue']['findOne']({'where':{'id':_0x370234['params']['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x3ff7d2,null))[_0xc008('0x15')](function(_0x2ccfcf){if(_0x2ccfcf){_0x34cbce=_0x2ccfcf;_0x406de6[_0xc008('0x2e')]=_[_0xc008('0x2c')](db[_0xc008('0x8d')][_0xc008('0x21')]);_0x406de6['query']=_[_0xc008('0x2c')](_0x370234[_0xc008('0x26')]);_0x406de6[_0xc008('0x2d')]=_[_0xc008('0x2f')](_0x406de6[_0xc008('0x2e')],_0x406de6['query']);_0x478794[_0xc008('0x31')]=_[_0xc008('0x2f')](_0x406de6[_0xc008('0x2e')],qs[_0xc008('0x30')](_0x370234[_0xc008('0x26')][_0xc008('0x30')]));_0x478794[_0xc008('0x31')]=_0x478794[_0xc008('0x31')][_0xc008('0x4c')]?_0x478794[_0xc008('0x31')]:_0x406de6[_0xc008('0x2e')];_0x478794['order']=qs[_0xc008('0x50')](_0x370234['query'][_0xc008('0x50')]);_0x478794[_0xc008('0x24')]=qs[_0xc008('0x2d')](_['pick'](_0x370234[_0xc008('0x26')],_0x406de6['filters']));if(_0x370234[_0xc008('0x26')][_0xc008('0x53')]){_0x478794[_0xc008('0x24')]=_[_0xc008('0x33')](_0x478794[_0xc008('0x24')],{'$or':_[_0xc008('0x17')](_0x478794[_0xc008('0x31')],function(_0x89601c){var _0x22bb2a={};_0x22bb2a[_0x89601c]={'$like':'%'+_0x370234[_0xc008('0x26')]['filter']+'%'};return _0x22bb2a;})});}_0x478794=_[_0xc008('0x33')]({},_0x478794,_0x370234['options']);return _0x34cbce['getBlackLists'](_0x478794);}})[_0xc008('0x15')](function(_0x55ad1f){if(_0x55ad1f){_0x337acd=_0x55ad1f[_0xc008('0x4c')];if(!_0x370234[_0xc008('0x26')][_0xc008('0x4d')](_0xc008('0x4e'))){_0x478794['limit']=qs[_0xc008('0x4f')](_0x370234[_0xc008('0x26')][_0xc008('0x4f')]);_0x478794[_0xc008('0x10')]=qs[_0xc008('0x10')](_0x370234['query'][_0xc008('0x10')]);}return _0x34cbce[_0xc008('0xb2')](_0x478794);}})['then'](function(_0x247e3a){if(_0x247e3a){return _0x247e3a?{'count':_0x337acd,'rows':_0x247e3a}:null;}})[_0xc008('0x15')](respondWithResult(_0x3ff7d2,null))[_0xc008('0x29')](handleError(_0x3ff7d2,null));};exports[_0xc008('0xb3')]=function(_0x252c44,_0x3b46db){var _0x482efd;return db[_0xc008('0x20')][_0xc008('0x35')]({'where':{'id':_0x252c44[_0xc008('0x2b')]['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x3b46db,null))[_0xc008('0x15')](function(_0x2f217e){if(_0x2f217e){return _0x2f217e[_0xc008('0xb3')](_0x252c44[_0xc008('0x45')][_0xc008('0x72')],_[_0xc008('0x44')](_0x252c44['body'],[_0xc008('0x72'),'id'])||{});}return null;})[_0xc008('0x85')](function(_0x298783){var _0xe349bd;_0x482efd=_0x298783||[];var _0x50db48=[];if(_0x298783){for(var _0x384f2f=0x0;_0x384f2f<_0x298783[_0xc008('0x4c')];_0x384f2f+=0x1){var _0x367581=_0x298783[_0x384f2f][_0xc008('0x3a')]({'plain':!![]});_0xe349bd=squel[_0xc008('0x91')]()[_0xc008('0xa2')](_0xc008('0xb4'))[_0xc008('0xa3')]([_0xc008('0x92'),_0xc008('0x94'),_0xc008('0x95'),_0xc008('0x52'),_0xc008('0x46'),_0xc008('0x47')],squel['select']()[_0xc008('0x96')](_0xc008('0x92'),_0xc008('0x92'))[_0xc008('0x96')]('id',_0xc008('0x94'))['field'](_0x367581[_0xc008('0x97')][_0xc008('0x98')](),'ListId')[_0xc008('0x96')](_0x252c44[_0xc008('0x2b')]['id']['toString'](),'VoiceQueueId')['field']('NOW()',_0xc008('0x46'))['field']('NOW()',_0xc008('0x47'))[_0xc008('0x76')](_0xc008('0x99'))['where']('deletedAt\x20IS\x20NULL')[_0xc008('0x24')](_0xc008('0x9b'),_0x367581[_0xc008('0x97')][_0xc008('0x98')]())['where'](_0xc008('0x9c')))[_0xc008('0x98')]();_0x50db48['push'](db[_0xc008('0x65')]['query'](_0xe349bd));}return BPromise['all'](_0x50db48);}})[_0xc008('0x15')](function(){return _0x482efd;})[_0xc008('0x15')](respondWithResult(_0x3b46db,null))['catch'](handleError(_0x3b46db,null));};exports['removeBlackLists']=function(_0x1e3098,_0x9b997d){return db['VoiceQueue'][_0xc008('0x35')]({'where':{'id':_0x1e3098['params']['id']}})[_0xc008('0x15')](handleEntityNotFound(_0x9b997d,null))[_0xc008('0x15')](function(_0x1422ab){if(_0x1422ab){return _0x1422ab[_0xc008('0xb5')](_0x1e3098[_0xc008('0x26')][_0xc008('0x72')]);}})[_0xc008('0x15')](function(_0x41a8a6){if(_0x41a8a6){return db['CmHopperBlack'][_0xc008('0x1c')]({'where':{'ListId':_0x1e3098['query'][_0xc008('0x72')],'VoiceQueueId':_0x1e3098['params']['id']}})['then'](function(){return _0x41a8a6;});}})[_0xc008('0x15')](respondWithStatusCode(_0x9b997d,null))[_0xc008('0x29')](handleError(_0x9b997d,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff